Enter into column A, F, and K the #r 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
Starches
Starchy vegetables Added sugars
Food Groups
Non-starch vegetables Fruit
Milk: fat--free Milk: low Fat
Med. fat meat/substitute Fats/oils
Calorie-free
9.5 0 1
0.5
3.25 0
0.25 8.5 5 1
15 15 5
C
Total Gms CHO
15 142.5 0
15 2.5
12 12 0 0 0
15 48.75 0 3 0 0 0
Total gram CHO Total for COLUMN C 212 D Total
cal/gram CHO
4 4 4 4 4 4 4 4 4 0
E
Total cal. from CHO
570 0
60 10
195 0
12 0 0 0
F G Gms PRO
9.5 0 1
0.5
3.25 0
0.25 8.5 5 1
847 Total gms PRO Total for COLUMN H Total CALORIES consumed 1915
3 3 0 2 0 8 8 7 0 0
H Total Gms PRO
28.5 0 0 1 0 0 2
59.5 0 0
91 I Total
cal/gram PRO
4 4 4 4 4 4 4 4 4 0
J
Total cal. from PRO
114 0 0 4 0 0 8
238 0 0
364
K L Gms FAT
9.5 0 1
0.5
3.25 0
0.25 8.5 5 1
1 1 0 0 0 0 5 5 5 0
Total gms FAT Total for COLUMN M FAT M Total Gms FAT
9.5 0 0 0 0 0
1.25 42.5 25 0
78 N Total
cal/gram FAT
9 9 9 9 9 9
9 0
O
Total cal. from FAT
85.5 0 0 0 0 0
9 11.25 9 382.5 225 0
704.25
515
Nutrition Fundamentals and Medical Nutrition Therapy