For this assignment, all you have to do is follow the instructions to complete the Excel document.
The instructions and start file are attached.
Dental Insurance
| |
|
Dental Services |
| Patient ID |
Insurance |
Service Code |
Maximum Benefit |
Billed |
Variance |
| 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 |
| |
|
|
|
|
|
|
|
|
|
|
|
Daily Total Is |
| |
|
|
Daily Total Is |
|
|
|
|
|
|
If Dinner Calories Are |
If Lunch Calories Are |
| |
|
If dinner calories are at this level |
|
|
|
|
|
|
|
|
|
500 |
600 |
700 |
800 |
900 |
1000 |
1100 |
1200 |
| |
|
|
500 |
|
|
|
|
|
|
|
500 |
| |
|
|
600 |
|
|
|
|
|
|
|
600 |
| |
|
|
700 |
|
|
|
|
|
|
|
700 |
| |
|
|
800 |
|
|
|
|
|
|
|
800 |
| |
|
|
900 |
|
|
|
|
|
|
|
900 |
| |
|
|
1,000 |
|
|
|
|
|
|
|
1000 |
| |
|
|
1,100 |
|
|
|
|
|
|
|
1100 |
| |
|
|
1,200 |
|
|
|
|
|
|
|
1200 |
image1.png
