Cancelled

Derive missing values from National Data

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.

Skills: .NET, Algorithm, Business Analysis, Medical, Statistics

See more: type use case, trees algorithm, solution algorithm, net algorithm, metro one, make yellow, life south, different algorithm, data trees, algorithmic solution problem, excel spreadsheet formula, west, trees, rural, metro, need make excel projects, derive, brain, algorithmic, spreadsheet manipulation, number manipulation, data collection excel spreadsheet, data collection spreadsheet, net spreadsheet, excel algorithm

About the Employer:
( 10 reviews ) Mechanicsburg, United States

Project ID: #549375

8 freelancers are bidding on average $105 for this job

rajtuhin1

I can do this for you, but i have to know total volume of the work first.

$300 USD in 1 day
(140 Reviews)
7.1
nsurani

Can be done within time & budget.

$30 USD in 1 day
(11 Reviews)
5.5
ExtraNet

Hi SteelersFan, please see PM.

$30 USD in 0 days
(1 Review)
3.2
jyclancer

I am ready to start. Please see the PM.

$150 USD in 1 day
(2 Reviews)
3.0
katudeni

Hi, we are an experianced academic service. Pls find the solved problem and more details in PMB. Thanks.

$30 USD in 0 days
(1 Review)
1.3
Vlad84

Greetings! I am willing to solve your problems. See your PM, thanks

$50 USD in 0 days
(0 Reviews)
0.0
ProggerGood

Hello, please check PMB.

$50 USD in 1 day
(1 Review)
0.0
pabna

Please see at PM Thanks

$200 USD in 10 days
(0 Reviews)
0.0