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
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
5.75 1 3 1
1.5 0
1.25 10
5.5 1
15 15 5
C
Total Gms CHO
15 86.25 15 45 5
15 12 12 0 0 0
Total gram CHO Total for COLUMN C
22.5 0
15 0 0 0
189 D Total
cal/gram CHO
4 4 4 4 4 4 4 4 4 4
E
Total cal. from CHO
345 60
180 20 90 0
60 0 0 0
F G Gms PRO
5.75 1 3 1
1.5 0
1.25 10
5.5 1
755 Total gms PRO Total for COLUMN H Total CALORIES consumed 1979
3 0 2 0 8 8 7 0 0
PROTEIN H Total Gms PRO
3 17.25 3 0 2 0 0
10 70 0 0
102 I Total
cal/gram PRO
4 4 4 4 4 4 4 4 4 4
J
Total cal. from PRO
69 12 0 8 0 0
40
280 0 0
409
K L Gms FAT
5.75 1 3 1
1.5 0
1.25 10
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
5.75 1 0 0 0 0
6.25 50
27.5 0
91 N Total
cal/gram FAT
9 9 9 9 9
O
Total cal. from FAT
9 51.75 9 0 0 0 0
9 56.25 450
9
9 247.5 0
9 814.5
SUPPLEMENTAL MATERIAL
Nutrition Fundamentals and Medical Nutrition Therapy