Cancelado

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

Ver mais: type of use case, trees in algorithm, solution algorithm, net algorithm, metro one, make me yellow, make algorithm, life south, different algorithm, data trees, algorithmic solution to a problem, excel spreadsheet formula, about my life, west, trees, rural, METRO, i need to make excel projects, from the forest, derive, brain, algorithmic, spreadsheet manipulation, excel formula spreadsheet spreadsheet, number manipulation

Acerca do Empregador:
( 10 comentários ) Mechanicsburg, United States

ID do Projeto: #549375

8 freelancers estão ofertando em média $105 para este 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

Hi SteelersFan, please see PM.

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

I am ready to start. Please see the PM.

$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
Vlad84

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

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

Hello, please check PMB.

$50 USD em 1 dia
(1 Comentário)
0.0
pabna

Please see at PM Thanks

$200 USD in 10 dias
(0 Comentários)
0.0