excel 2013 assignment
d9f2v6d7v1
assignnment.xlsxPatient Count
| Courtyard Medical Plaza | |||||||||||||
| Patient Count by Month | |||||||||||||
| Process | Jan | Feb | Total | ||||||||||
| Scheduled Appointment | 475 | 598 | 470 | 529 | 622 | 563 | 577 | 455 | 572 | 458 | 543 | 489 | |
| Immediate Care | 643 | 461 | 545 | 605 | 556 | 520 | 549 | 532 | 566 | 644 | 596 | 626 | |
| EMT/Paramedic Arrival | 475 | 466 | 520 | 616 | 615 | 519 | 578 | 606 | 547 | 511 | 580 | 623 | |
| Facility Transfer | 631 | 496 | 469 | 647 | 511 | 605 | 452 | 463 | 465 | 650 | 452 | 623 | |
| Total |
Location 2- Breezy Point
| Paradise Lakes Resort | |||||||
| July 14 - 20, 2014 | |||||||
| Sales Categories | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday |
| Cabin Rentals | 3,405.00 | 2,345.00 | 1,234.00 | 4,533.00 | 6,778.00 | 8,777.00 | 6,789.00 |
| Local Tours | 876.00 | 750.00 | 968.00 | 1,254.00 | 1,456.00 | 2,243.00 | 1,890.00 |
| Fishing Guides | 1,245.00 | 458.00 | 675.00 | 890.00 | 1,564.00 | 1,890.00 | 1,564.00 |
| Equipment Rentals | 358.00 | 250.00 | 325.00 | 678.00 | 654.00 | 876.00 | 657.00 |
| Food & Beverages | |||||||
| Apparel | 451.00 | 356.00 | 543.00 | 532.00 | 678.00 | 764.00 | 892.00 |
| Total | $ 6,335.00 | $ 4,159.00 | $ 3,745.00 | $ 7,887.00 | $ 11,130.00 | $ 14,550.00 | $ 11,792.00 |
&K04-049&F
Procedures Count
| Courtyard Medical Plaza | |||
| In-House Procedures | |||
| Procedure | 2013 | 2014 | 2015 |
| Carpal Tunnel Procedure | 33 | 27 | 15 |
| Central Line Insertion | 21 | 16 | 9 |
| Ear Tube Insertion | 8 | 19 | 29 |
| Gallbladder Removal | 22 | 17 | 31 |
| Hernia Repair | 32 | 34 | 30 |
| Injections | 52 | 58 | 68 |
| Knee Arthroscopy | 19 | 33 | 55 |
| Left Heart Catheterization | 20 | 25 | 35 |
| Peritoneal Cavity Puncture | 14 | 19 | 16 |
| Tonsillectomy | 12 | 18 | 22 |
| Upper GI Endoscopy | 16 | 32 | 30 |
