excel work
melissam
CourtyardMedical-09.xlsxDental Insurance
| Dental Services | ||||
| Patient ID | Insurance | Service Code | Maximum Benefit | Billed |
| OP0001 | CompDent | D0120 | $125.00 | $135.00 |
| OP0002 | SIP | D1110 | $185.00 | $135.00 |
| OP0003 | CompDent | D2751 | $235.00 | $250.00 |
| OP0004 | Westville | D2751 | $135.00 | $100.00 |
| OP0005 | CompDent | D1110 | $245.00 | $185.00 |
| OP0006 | SIP | D1110 | $275.00 | $100.00 |
| OP0007 | SIP | D1110 | $325.00 | $425.00 |
| OP0008 | Westville | D0120 | $175.00 | $125.00 |
| OP0009 | BlueDent | D0120 | $195.00 | $145.00 |
| OP0010 | BlueDent | D1110 | $200.00 | $225.00 |
| OP0011 | BlueDent | D1110 | $225.00 | $235.00 |
| OP0012 | SIP | D1110 | $200.00 | $185.00 |
| OP0013 | CompDent | D2751 | $475.00 | $325.00 |
| OP0014 | SIP | D1110 | $235.00 | $235.00 |
| OP0015 | SIP | D1110 | $235.00 | $245.00 |
| OP0016 | BlueDent | D1110 | $225.00 | $200.00 |
| OP0017 | BlueDent | D0120 | $185.00 | $175.00 |
| OP0018 | Westville | D0120 | $195.00 | $150.00 |
| OP0019 | Westville | D1110 | $225.00 | $125.00 |
| OP0020 | CompDent | D2751 | $375.00 | $500.00 |
| OP0021 | CompDent | D2330 | $325.00 | $400.00 |
| OP0022 | Westville | D2751 | $450.00 | $400.00 |
| OP0023 | Westville | D0120 | $325.00 | $300.00 |
| OP0024 | SIP | D0210 | $500.00 | $550.00 |
| OP0025 | SIP | D0120 | $250.00 | $250.00 |
| OP0026 | BlueDent | D2751 | $125.00 | $115.00 |
| OP0027 | CompDent | D0120 | $325.00 | $300.00 |
| OP0028 | Westville | D2330 | $275.00 | $250.00 |
| OP0029 | SIP | D2751 | $200.00 | $235.00 |
| OP0030 | BlueDent | D1110 | $185.00 | $175.00 |
| OP0031 | CompDent | D2330 | $225.00 | $235.00 |
Workout Plan
| Wellness Services | |||||||||
| Weekly Workout Plan | |||||||||
| Activity | Calories/Hr | # of Times per Week | Calories Burned per Week | ||||||
| High-Intensity Interval | 525.00 | 1 | 525.00 | Average Weekly Calories Consumed | 15,965.00 | Daily Consumed | 2,280.71 | ||
| Running | 500.00 | 1 | 500.00 | Average Weekly Calories Burned | 2,360.00 | Daily Burned | 337.14 | ||
| Zumba | 400.00 | 2 | 800.00 | ||||||
| Water Aerobics | 300.00 | 1 | 300.00 | ||||||
| Strength Training | 235.00 | 1 | 235.00 | ||||||
| Total | 1,960.00 | 6 | 2,360.00 | ||||||
| Goal | 3,500.00 |
Calorie Journal
| Wellness Services | |||||||||||||||||||
| Weekly Calorie Journal by Meal | |||||||||||||||||||
| Date | Breakfast | Morning Snack | Lunch | Afternoon Snack | Dinner | Dessert | Total | ||||||||||||
| 350 | 200 | 600 | 250 | 800 | 250 | 2,450 | |||||||||||||
| 300 | 190 | 750 | 225 | 675 | 150 | 2,290 | |||||||||||||
| 325 | 250 | 500 | 150 | 500 | 175 | 1,900 | |||||||||||||
| 400 | 275 | 650 | 200 | 850 | 200 | 2,575 | |||||||||||||
| 325 | 300 | 545 | 250 | 575 | 150 | 2,145 | |||||||||||||
| 425 | 150 | 600 | 225 | 650 | 155 | 2,205 | |||||||||||||
| 400 | 200 | 525 | 300 | 775 | 200 | 2,400 | |||||||||||||
| Average | 361 | 224 | 596 | 229 | 689 | 183 | 2,281 | ||||||||||||
| Total Calories | Lunch Calories | ||||||||||||||||||
| 500 | 600 | 700 | 800 | 900 | 1000 | 1100 | 1200 | ||||||||||||
| 500 | 500 | ||||||||||||||||||
| Dinner Calories | 600 | Dinner Calories | 600 | ||||||||||||||||
| 700 | 700 | ||||||||||||||||||
| 800 | 800 | ||||||||||||||||||
| 900 | 900 | ||||||||||||||||||
| 1,000 | 1000 | ||||||||||||||||||
| 1,100 | 1100 | ||||||||||||||||||
| 1,200 | 1200 | ||||||||||||||||||
