|
Excel VBA Automated Worksheet |
| Status |
Closed |
| Budget |
$20-100 |
| Posted |
17 May 2008 05:17 PM |
| Expires |
19 May 2008 05:17 PM |
| Posted By |
Namrac00 |
| Service buyer Rating |
 |
| Description |
I have started a project that starts as two tabs. One that has a list of doctors and what the "tab" will be called, and one that you paste the "raw data" in.
This part seems to be functional, it will create the tabs based on what is entered and the layout of the table. Right now it is seperating by doctor group and payor (which would be medicare and all). It is creating one of the charts but not the other right now. I need help on putting in the calculations in the table and creating 2 charts on the same page. The table is based on another tab that seperates that specific doctor data out. One of the charts will be based on that, the other one is a bar chart that looks at the specific doctor and their peers. One trick to this bar chart is that they want the bar of the doctor labled on that tab to be a different color than the peers.
Once these are created, I need everything to be hidden except for the tabs with these charts.
I will attach what I have so far and a picture of how the end result should be. (I had to take a lot of raw data out so it would fit)
I would like this completed over the weekend and have me test it by Monday.
I would like demos of progress (for each table/chart that is completed) so that I can help with any glitches along the way.
I would prefer someone on EST time zone, or someone willing to work during my time so that we can make sure this is completed.
These are the calculations inside the table:
Cases: Patient ID (Count)
Days: LOS (Sum)
ALOS: LOS (Average)
CMI SUM: CMI (Sum)
CMI: CMI SUM/Cases
For Year and month use Discharge Date (DOD)
----------------------------------------------------------------
Please Note: I am already a day behind on this because I accepted a bid from someone who said they could have it done in 8 hours and then I never heard back from them. I need constant interaction in all the steps moving forward. I want to be sent a demo once the table is calculating, so that I can test. I want the same for charts at a time.
|
| Categories |
|
| Database |
N/A
|
| Operating System |
- -
|
|
|
|
|
| |
| Service provider |
Bid |
Delivery Time |
Bid Time |
Rating |
|
| |
|
