I want a workbook that displays up to 30 persons' progress. It should have these columns:
Date of Birth
• me to Input a birthdate in dd/mm/yyyy format
• generated (by your formula) chronological age in years/month/days format This should update each time the worksheet opens.
Test Scores - 4 each week (I will enter this data)
• data entry columns (me to enter a raw score, all out of 20 items)
Output - 3 types: each with Name - dob, Chronological Age ( your formula to calculate in y/m/d format)
1. the worksheet see attachment for detail
2. A dashboard page showing class average % scores for each test over 10 sets of tests.
3. set of individual pages (Max 30) each with a dashboard showing -
Name - dob, Chronological Age (your formula to calculate)
individual student's scores in a table (from sheet 1) hori or vert and vertical bar graphs or other type display - see attachment for concept/detail
I am open to suggestions for a better solution (including html) for my enquiry.
13 freelancers are bidding on average $75 for this job
Hi, I am proficient in using excel. I can do this in no time. Please email me so I can send you thru pm my sample excel sheet formula as per your requirements. Thanks.