Enter into column A, F, and K the number of servings consumed of each food group from Row E in Food Group Analysis EXAMPLE Copy the numbers entered in Column A to Columns F and K Multiply columns A x B and enter the total in column C Multiply columns C x D and enter the total in column E
Add together all the numbers in column C and enter in "Total gms CHO Consumed" Multiply columns F x G and enter the total in column H Multiply columns H x I and enter the total in column J
Add together all the numbers in column H and enter in "Total gms PRO consumed" Multiply columns K x L and enter the total in column M Multiply columns M x N and enter the total in column O
Add together all the numbers in column M and enter in "Total gms FAT consumed" Add together all numbers in Column E and enter total in yellow box at bottom of column Add together all numbers in Column J and enter total in yellow box at bottom of column Add together all numbers in Column O and enter total in yellow box at bottom of column
Add together all the numbers in the three yellow boxes and enter the total in the blue box: "Total CALORIES consumed" CARBOHYDRATE
PROTEIN
A B Gms CHO
Starches
Starchy vegetables Added sugars
Food Groups
Non-starch vegetables Fruit
Milk: fat--free Milk: reduced Fat
Med. fat meat/substitute Fats/oils
Calorie-free
6.5 1
1.5 1
0.5 0 2 9
3.5 1
15 15 15 5
15 12 12 0 0 0
Total gram CHO Total for COLUMN C C
Total Gms CHO
97.5 15
22.5 5
7.5 0
24 0 0 0
172 D Total
cal/gram CHO
4 4 4 4 4 4 4 4 4 4
E
Total cal. from CHO
390 60 90 20 30 0
96 0 0 0
F G Gms PRO
6.5 1
1.5 1
0.5 0 2 9
3.5 1
686 Total gms PRO Total for COLUMN H Total CALORIES consumed 1820
3 3 0 2 0 8 8 7 0 0
H
Total Gms PRO
19.5 3 0 2 0 0
16 63 0 0
104 I Total
cal/gram PRO
4 4 4 4 4 4 4 4 4 4
J
Total cal. from PRO
78 12 0 8 0 0
64
252 0 0
414
K L Gms FAT
6.5 1
1.5 1
0.5 0 2 9
3.5 1
1 1 0 0 0 0 5 5 5 0
Total gms FAT Total for COLUMN M FAT M
Total Gms FAT
6.5 1 0 0 0 0
10 45
17.5 0
80 N Total
cal/gram FAT
9 9 9 9 9 9 9 9
9 O
Total cal. from FAT
58.5 9 0 0 0 0
90 405
9 157.5 0
720
503
Nutrition Fundamentals and Medical Nutrition Therapy