Enter into column A, F, and K the # of servings consumed of each food group from Row E in Nutrient Analysis 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 #s in the three yellow boxes and enter the total in the blue box: "Total CALORIES consumed" CARBOHYDRATE
PROTEIN
A B Gms CHO
Food Starches
Starchy vegetables Added sugars
Non-starch vegetables Fruit
Milk: fat--free Milk: Low Fat
Meat/meat substitute Fats/oils
Calorie-free
7.5 0 1
1.5 3 0
0.5 6 3 1
15 15 5
15 12 12 0 0 0
Total gram CHO Total for COLUMN C C
Total Gms CHO
15 112.5 0
15
7.5 45 0 6 0 0 0
186 D Total
cal/gram CHO
4 4 4 4 4 4 4 4 4 4
E
Total cal. from CHO
450 0
60 30
180 0
24 0 0 0
F G Gms PRO
7.5 0 1
1.5 3 0
0.5 6 3 1
744 Total gms PRO Total for COLUMN H Total CALORIES consumed 1525
3 3 0 2 0 8 8 7 0 0
H Total Gms PRO
22.5 0 0 3 0 0 4
42 0 0
72 I Total
cal/gram PRO
4 4 4 4 4 4 4 4 4 4
J
Total cal. from PRO
90 0 0
12 0 0
16
168 0 0
286
K L Gms FAT
7.5 0 1
1.5 3 0
0.5 6 3 1
1 1 0 0 0 0 5 5 5 0
Total gms FAT Total for COLUMN M FAT M Total Gms FAT
7.5 0 0 0 0 0
2.5 30 15 0
55 N Total
cal/gram FAT
9 9 9 9 9 9 9 9 9 9
O
Total cal. from FAT
67.5 0 0 0 0 0
22.5 270 135 0
495
SUPPLEMENTAL MATERIAL
Nutrition Fundamentals and Medical Nutrition Therapy