How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask Richard Your Own Question

Richard
Richard, Software Specialist
Category: Microsoft Office
Satisfied Customers: 31232
Experience:  Over 15 year experience resolving Microsoft Office Issues
32989067
Type Your Microsoft Office Question Here...
Richard is online now
A new question is answered every 9 seconds

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: 1 year ago.
Category: Microsoft Office
Expert:  Richard replied 1 year 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 1 year ago.

Spreadsheet

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 1 year ago.
ok, will check this now for you
Expert:  Richard replied 1 year 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 1 year ago.
Expert:  Richard replied 1 year 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 1 year ago.

Which spreadsheet did you make the corrections?

Is there and easy was to chart the information?

Expert:  Richard replied 1 year 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 1 year ago.

Hi Richard,

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

Customer: replied 1 year 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 1 year ago.

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