{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["DAILY LOG"],"not_rendered":{"charts":1,"defined_names":4},"read":"whole","date_system":"1900"}

{"sheet":"DAILY LOG","index":0,"n_rows":9,"n_cols":12,"rows_kept":9,"merged":[[0,1,0,9],[2,8,2,9],[2,11,3,11],[8,8,16,8]]}
[null,"DAILY CALORIE AND FAT PERCENTAGE LOG"]
[]
[null,"DAY","FOOD","CALORIES","GRAMS OF FAT","CALORIES FROM FAT","FAT PERCENTAGE",null,"SUMMARY",null,null,"INFO: Recommended total fat intake: less than 30% of total calories."]
[null,"Monday","Cereal",175,5,{"$f":"IF(Data[[#This Row],[GRAMS OF FAT]]<>0,Data[[#This Row],[GRAMS OF FAT]]*FatCaloriesPerGram,\"\")","v":45},{"$f":"IF(AND(Data[[#This Row],[CALORIES]]<>0,Data[[#This Row],[GRAMS OF FAT]]<>0,Data[[#This Row],[CALORIES FROM FAT]]<>0),Data[[#This Row],[CALORIES FROM FAT]]/Data[[#This Row],[CALORIES]],\"\")","v":{"v":0.2571428571428571,"d":"25.71%"}},null,"Calories consumed:",{"$f":"SUBTOTAL(109,Data[CALORIES])","v":1075}]
[null,"Monday","Turkey soup",120,3,{"$f":"IF(Data[[#This Row],[GRAMS OF FAT]]<>0,Data[[#This Row],[GRAMS OF FAT]]*FatCaloriesPerGram,\"\")","v":27},{"$f":"IF(AND(Data[[#This Row],[CALORIES]]<>0,Data[[#This Row],[GRAMS OF FAT]]<>0,Data[[#This Row],[CALORIES FROM FAT]]<>0),Data[[#This Row],[CALORIES FROM FAT]]/Data[[#This Row],[CALORIES]],\"\")","v":{"v":0.225,"d":"22.50%"}},null,"Grams of fat in those calories:",{"$f":"SUBTOTAL(109,Data[GRAMS OF FAT])","v":48}]
[null,"Monday","Chicken",110,3,{"$f":"IF(Data[[#This Row],[GRAMS OF FAT]]<>0,Data[[#This Row],[GRAMS OF FAT]]*FatCaloriesPerGram,\"\")","v":27},{"$f":"IF(AND(Data[[#This Row],[CALORIES]]<>0,Data[[#This Row],[GRAMS OF FAT]]<>0,Data[[#This Row],[CALORIES FROM FAT]]<>0),Data[[#This Row],[CALORIES FROM FAT]]/Data[[#This Row],[CALORIES]],\"\")","v":{"v":0.24545454545454545,"d":"24.55%"}},null,"(Fat contains 9 calories per gram)          x",9]
[null,"Monday","Cake",250,18,{"$f":"IF(Data[[#This Row],[GRAMS OF FAT]]<>0,Data[[#This Row],[GRAMS OF FAT]]*FatCaloriesPerGram,\"\")","v":162},{"$f":"IF(AND(Data[[#This Row],[CALORIES]]<>0,Data[[#This Row],[GRAMS OF FAT]]<>0,Data[[#This Row],[CALORIES FROM FAT]]<>0),Data[[#This Row],[CALORIES FROM FAT]]/Data[[#This Row],[CALORIES]],\"\")","v":{"v":0.648,"d":"64.80%"}},null,"Calories of fat consumed:",{"$f":"J5*J6","v":432}]
[null,"Tuesday","Scrambled eggs",300,16,{"$f":"IF(Data[[#This Row],[GRAMS OF FAT]]<>0,Data[[#This Row],[GRAMS OF FAT]]*FatCaloriesPerGram,\"\")","v":144},{"$f":"IF(AND(Data[[#This Row],[CALORIES]]<>0,Data[[#This Row],[GRAMS OF FAT]]<>0,Data[[#This Row],[CALORIES FROM FAT]]<>0),Data[[#This Row],[CALORIES FROM FAT]]/Data[[#This Row],[CALORIES]],\"\")","v":{"v":0.48,"d":"48.00%"}},null,"Fat as a percentage of calories consumed:",{"$f":"IF(AND(J5<>0,J4<>0),(J5*9)/J4,\"\")","v":{"v":0.4018604651162791,"d":"40%"}}]
[null,"Tuesday","Turkey soup",120,3,{"$f":"IF(Data[[#This Row],[GRAMS OF FAT]]<>0,Data[[#This Row],[GRAMS OF FAT]]*FatCaloriesPerGram,\"\")","v":27},{"$f":"IF(AND(Data[[#This Row],[CALORIES]]<>0,Data[[#This Row],[GRAMS OF FAT]]<>0,Data[[#This Row],[CALORIES FROM FAT]]<>0),Data[[#This Row],[CALORIES FROM FAT]]/Data[[#This Row],[CALORIES]],\"\")","v":{"v":0.225,"d":"22.50%"}},null,"Fat as a percentage of calories consumed chart is in this cell."]