• 100% Satisfaction Guarantee
Richard, Software Specialist
Category: Microsoft Office
Satisfied Customers: 36881
Experience:  Over 15 year experience resolving Microsoft Office Issues
32989067
Type Your Microsoft Office Question Here...
Richard is online now

Looking with advance excel experience especially

Customer Question

Looking for someone with advance excel experience especially with formula's.
Knowledge of OSHA EMR, DART and RIR is helpful.
Submitted: 2 years ago.
Category: Microsoft Office
Expert:  Richard replied 2 years ago.
Hi there and welcomeI do not have knowledge in the areas you specified, but do have with formulas and programming in Excel.Can you explain to me please what it is you would like and I can tell if I am capable to do it or allow an expert that is.
Customer: replied 2 years ago.

I went over the information on the attached spreadsheet with our insurance carrier, but the formula's do not seems to be working. According to our insurance carrier the #'s in yellow are correct.

Can you fix the formula's so they calculate the correct information?

Expert:  Richard replied 2 years ago.
ok, will check this now for you
Expert:  Richard replied 2 years ago.
ok, I checked and the formulas are doing the calculations, so looks normal to me. Which cell in particular do you see as a problem and why?
Customer: replied 2 years ago.
Expert:  Richard replied 2 years ago.
ok, the values change because their caclulating cells with different values. Looks at D11, it says =D12*(200000/D16)On one sheet D16 is 243526 and in the other its 41202That is why you are getting different results.
Customer: replied 2 years ago.

Which spreadsheet did you make the corrections?

Is there and easy was to chart the information?

Expert:  Richard replied 2 years ago.
I did not correct anything yet Vickie as I do not know which sheet to make the correction to.
If you look at the values, you see that they differ for the calculation which is why the calculations differ.
Looks at D11, it says =D12*(200000/D16)
On one sheet D16 is 243526 and in the other its 41202
That is why you are getting different results.
Customer: replied 2 years ago.

Hi Richard,

I would like you to make the corrections to the spreadsheet and if possible chart it?

Customer: replied 2 years ago.

2010 total hours = 41202

2011 total hours = 153681

2012 total hours = 243526

2013 total hours = 268193

2014 total hours = 208,277

If you could format for 2015 and 2016 too?

Customer: replied 2 years ago.

Richard, Can you make the corrections and post the sheet you make them on?