I’m working on a project to derive the number of individual hospital procedures. I have nation-wide totals by various demographic segments (e.g., North/East/West/South, Metro/Rural, etc), as well as hospital specific data. However, there are a number of missing values that need filled in. The missing hospital value amounts will change based on it's overall % of different payers, e.g., medicare, private, etc.
OPEN THE INCLUDED EXCEL TO SEE THE PROBLEM.
I’m thinking it’s a proportionate value algorithm, but I’ve become too close to this project and can no longer see the forest through the trees. It has taken me weeks of data collection and manipulation to get it to this point.
My brain is mush and I need to double-check myself against another’s solution.
I’ve broken out one case for completion in Excel, and I need a formula created to derive the missing values (listed in yellow in excel).
This needs completed ASAP, so if you simply solve the spreadsheet and get it to me, the lowest reasonable price with the correct answer wins...
Note: many times throughout the year, I have a LOT of these type of projects and this is the first of these I've ever posted because I didn't ever think about using getafreelancer, so this could lead to a lot of these ongoing for the right person...speed and accuracy are important to me, so if you're accurate and can make my life easier, then it's faster and easier for me to use one person as the ongoing resource. Thanks.