Project Detail

Derive missing values from National Data   Refundable $5 fee paid

Derive missing values from National Data is project number 549375
posted at Freelancer.com. Click here to post your own project.

 

| More
Free Trial For New Buyers
 

Status: Frozen
(Bid period finished)

Selected Providers: -

Budget: $30-250

Created: 11/12/2009 at 14:19 EST

Bid Count: 9

Average Bid:
$ 97

11/15/2009 at 14:19 EST

Project Creator: SteelersFan
Employer Rating: (No Feedback Yet)

Bid On This Project
 

Description

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.


Additional information submitted:

11/12/2009 at 14:32 EST:
NOTE: if you just want to bid on it normally (versus solving the attached spreadsheet), then feel free to do so too...


Additional files submitted:
Freelancer.xls

Messages Posted:2 View project clarification board Post message on project clarification board

Bid On This Project
 

If you are the project creator or one of the bidders Log In for more options

 

300

1 day

11-12-2009 14:51 EST

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

help

 

30

0 days

11-13-2009 04:30 EST

Hi SteelersFan, please see PM.

help

 

30

0 days

11-14-2009 02:00 EST

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

help

 

30

1 day

11-14-2009 08:09 EST

Can be done within time & budget.

help

 

30

1 day

11-15-2009 13:43 EST

Hi, we can help you on this using our mathematical, healthcare IT and some USA based health insurance background. please have a look at my private message. Thanks

help

 

150

1 day

11-13-2009 00:51 EST

I am ready to start. Please see the PM.

help

 

200

10 days

11-14-2009 10:31 EST

(No Feedback Yet)

Please see at PM Thanks

help

 

50

0 days

11-12-2009 22:16 EST

(No Feedback Yet)

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

help

 

50

1 day

11-13-2009 14:49 EST

(No Feedback Yet)

Hello, please check PMB.

help


    Bid on this Project