In Progress

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

See more: excel dashboard creation, dashboard creation excel, excel dashboard formulas, excel formulas dashboard, data entry excel dashboard, excel dashboard data entry, dashboard chronological data, dashboard creation, dashboard formulas excel, test data creation, max graph, data entry worksheet, data entry score, want dashboard excel, formula dashboard excel, excel data entry dashboard, chronological age decimal excel, birth data entry, format excel, excel html, excel formulas, excel formula, excel 7, data entry raw, Dashboard

About the Employer:
( 18 reviews ) Ipswich, Australia

Project ID: #1277959

Awarded to:

dimkastoras

I've already sent you a sample. I'd be glad to cooperate.

$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

Please, Check my PM.

$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