Singapore Microcomputer Society

Established since 1978


Registrar of Societies Ref. no: 0238/1978

UEN : S79SS0023B















Visited 385004 times

Date:    Friday 17 Nov 2017



Venue: 
Lecture Room 1 (third storey) Bishan Community Club 
            51 Bishan Street 13, Singapore 579799
            (near Bishan MRT Station)

Map :   http://www.streetdirectory.com/sg/bishan-community-club/51-bishan-street-13-579799/816_106638.html 


Fee :   
FREE for SMS members ; $10 door fee for non-members ; $5 door fee for Passion Club members , CMI members


Topic : Excel Skill and Application on Data Analytic : How to Analyse TOTO results and Historical Data
 
Presenter:    Mr Raymond Chua
                        Asst. Chairman, Windows Interest Group 
                    
Synopsis 
<< QUOTE >>
Where to Find the Historical Results
 
FUNCTIONS
 
VLOOKUP(lookup_value,Table_array,Col_index_num,Range_lookup)
 
COUNTIF(range, criteria)
 
RANDBETWEEN(bottom, top)
 
PIVOT TABLE
 
RANK Perform Ranking of High, Mid, Low Based on Chan Hung Suggested Fig, And Also Based on Excel Data Analysis
 
CH-HML-DATA
Based on Chan Hung Suggested H,M,L Analysis
 
CONVERTED DATA
Based on Excel Analysis From Data Downloaded From Singapore Pools From 2008 To Current

DATA -3 Another Way of Converting the Data for Excel Analysis
QUICK-PICK

A Simple Quick Pick Like to Suggest Betting Figures Base on 8 Groups of Figures From 1 - 49

You Can Modify the Range

The Quick Pick is Not for Real Suggestion, We are Not Responsible or Suggest for Any Betting,

Just for Education Purpose Only

You can download Mr Raymond Chua's Excel spreadsheet at http://www2.sms.org.sg/17nov17_TOTO2017-V2.xlsx 
<< UNQUOTE >>
Organised by Windows (Excel) Interest Group, SMS

NEXT WEEK : 24 Nov 2017


Topic: 
 
Robo-Advisor - the low cost, diversified, passive investing model

Presenter: Mr Ng Chee Seng
                   Chairman, Stocks & Shares SIG, SMS
                    Stocks & Shares Interest Group