Hi,
I have a spreadsheet that shows the number of surgery cases for certain procedures for 2010, 2011, and through 6/15/12. How do I annualize the data for 2012?complicated case volume.xlsx
Hi,
I have a spreadsheet that shows the number of surgery cases for certain procedures for 2010, 2011, and through 6/15/12. How do I annualize the data for 2012?complicated case volume.xlsx
I think that in order to do this you need, as a minimum, to know how many of the surgeries in 2010 and 2011 took place in the periode 1/1 to 6/15.
Sincerely
S?ren Larsen
"Give a man a fish, and you'll feed him for a day. Give a man a fishing rod, and he'll steal your yacht!"
In E3
=ROUND(D3/YEARFRAC("1/1/2012","6/15/2012",1),0)
Is that what you need?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Thanks. Attached is the spreadsheet with one procedure by quarter.
From the data provided I see no reason not to use ChemistB's suggestion in #3 and assume that surgeries are evenly distributed over a year.
This could work.
Thank you everyone!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks