# Excel formulas and dashboard creation

Excel formulas/workbook/dashboard wanted

I want a workbook that displays up to 30 persons' academic progress. It should have these columns:

Date of Birth

• me to Input a birthdate in dd/mm/yyyy format

Chronological Age

• generated (by your formula) chronological age in years/month/days format (min. 6 years old, max 16 years old) This should update each time the worksheet opens.

Age (Decimal)

• generated(by your formula) chronological age in years and decimal months, to 2 decimal places or rounded up or down to 1 decimal place (min. 6 years old, max 16 years old)

Test Score

• data entry column (me to enter a raw score from 12 to 56)

Spelling Age

• result generated from that raw score (by your formula) in years/decimal month, according to this formula:

raw score - reading age (decimal and .0 to be displayed)

12 or less - 6.0 yrs

13 - 6.0

14 - 6.0

15 - 6.1

16 - 6.3

17 - 6.4

18 - 6.5

19 - 6.7

20 - 6.8

21 - 6.9

22 - 7.1

23 - 7.2

24 - 7.3

25 - 7.5

26 - 7.6

27 - 7.8

28 - 8.0

29 - 8.2

30 - 8.4

31 - 8.6

32 - 8.9

33 - 9.0

34 - 9.2

35 - 9.5

36 - 9.7

37 - 10.0

38 - 10.2

39 - 10.5

40 - 10.7

41 - 10.9

42 - 11.2

43 - 11.4

44 - 11.7

45 - 12.0

46 - 12.2

47 - 12.4

48 - 13.0

49 - 13.8

50 - 14.2

51 - 14.5

52 - 15.5

53+ - 15.5+

Difference

• the difference between chron age and spelling age

Output - 3 sets: each with Name - Chronological Age - Spelling Age - Difference + or -

1. the worksheet

2. A dashboard page showing all students' scores (Chron. Age v Spell Age and Difference + or -) bullet graph???

3. set of individual pages (Max 30) each with a dashboard showing individual student's scores Chron. v Spell Age but not Difference + or - in a vertical bar graph or gauges/ progress bars/ ??

I am open to suggestions for a better solution (including html) for my enquiry or an alternative cheaper solution???

Skills: Data Entry, Data Processing, Excel

( 18 reviews ) Ipswich, Australia

Project ID: #1277959

dimkastoras

\$80 AUD in 1 day
(5 Reviews)
2.9

## 29 freelancers are bidding on average \$64 for this job

gshiels

Hi Samoth I have 20 years Excel experience, great feedback and a 100% completion record. I will not be the cheapest bidder, but that means I have time for each client and therefore can produce a great result. If a More

\$100 AUD in 2 days
(12 Reviews)
5.0
koolsidz

Excel whiz here ;) Please see PMB for more details

\$70 AUD in 2 days
(35 Reviews)
4.7
ExactSystems

Please see a robust solution on PMB. regards

\$195 AUD in 3 days
(5 Reviews)
4.6
psprongs

Hi, I have a good deal of experience in data processing using excel. I can help in creation of this workbook. Please check PMB

\$55 AUD in 2 days
(9 Reviews)
4.2
shacoim

***Plz Check PM***

\$80 AUD in 3 days
(13 Reviews)
4.0
muthumuni

Hi, I am expert for this task, so kindly see my review and select me with confident, I am really happy to work with this interesting project and ready to start it now. Waiting for your response. Thank you in adva More

\$30 AUD in 0 days
(9 Reviews)
3.8
LIMEXS

\$45 AUD in 2 days
(6 Reviews)
3.8
Suri1

Hi, I would like to bid on your project as I have experience on this type of projects before. Please check PM for further details with bid details. Best Regards,

\$50 AUD in 15 days
(5 Reviews)
3.3
IoliteTech

Hi, I would like to discuss the project in more detail. Kindly check out the sample I made for you. Thanks

\$40 AUD in 1 day
(2 Reviews)
2.2
guevanjr

Please consider my bid. Thanks, SG

\$50 AUD in 2 days
(3 Reviews)
2.2
sathish2connect

Hi, I have good experience in excel programming. Ready to start now.

\$30 AUD in 1 day
(1 Review)
1.0
wassanayata31

I've worked as a data entry operator and typist.I can do my best.

\$35 AUD in 2 days
(0 Reviews)
0.0
Benjam355

Hello Samoth, I currently work for a large Australian Company where my job is to create these for a living. This is a straight forward project for me. I would love the opportunity to help. Kind Regards Ben

\$30 AUD in 1 day
(0 Reviews)
0.0
PacificSeoLtd

HI SIR , I WANT TO GET THIS WORK , AS I AM ABLE TO HANDLE YOUR PROJECT .SO,GIVE ME ONE CHANCE. THANKS

\$150 AUD in 3 days
(0 Reviews)
0.0
mgm05267

Expected Data file with complete dashboard with no student limits in 2 days

\$30 AUD in 2 days
(0 Reviews)
0.0
rahulcs068

Hi, i have done this type of work a lot... as i am new here so no worry of money. Worry is only of quality solution..... Regards, Rahul

\$30 AUD in 2 days
(0 Reviews)
0.0
DURGESHSONI

I am confident that I will complete the work accuratly and with in time limit. Kindly give me the chance.

\$100 AUD in 5 days
(0 Reviews)
0.0
abdulghany

It is GOOD to start my freelance career with this easy task!!!!!!!!

\$100 AUD in 3 days
(0 Reviews)
0.0
vinu67

As you're my first freelancer job, I'm willing to bid low to prove my worth and provide you value for money in the process. I have 15 years of experience in working with advanced Excel workbooks using formulae, macros More

\$65 AUD in 10 days
(0 Reviews)
0.0
pathumstf

i end of ur work as my best

\$30 AUD in 1 day
(0 Reviews)
0.0