# 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.

NOTE: if you just want to bid on it normally (versus solving the attached spreadsheet), then feel free to do so too...

Habilidades: .NET, Algoritmo, Análise de Negócios, Medicina, Estatísticas

( 10 comentários ) Mechanicsburg, United States

ID do Projeto: #549375

## 8 freelancers estão ofertando em média \$105 para esse trabalho

rajtuhin1

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

\$300 USD em 1 dia
(140 Comentários)
7.1
nsurani

Can be done within time & budget.

\$30 USD em 1 dia
(11 Comentários)
5.5
ExtraNet

\$30 USD in 0 dias
(1 Comentário)
3.2
jyclancer

\$150 USD em 1 dia
(2 Comentários)
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 dias
(1 Comentário)
1.3

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

\$50 USD in 0 dias
(0 Comentários)
0.0
ProggerGood