The Burn the Fat EXCEL and PDF meal planning spreadsheets were designed for you to download and use off the web from your computer. The EXCEL sheet is blank except for a sample meal that has been included as an example (you can delete/ overwrite it).Ī PDF version of the spreadsheet is also included, which does not do the math for you, but may be printed and filled out by hand. (Microsoft Excel is required to use this version of the spreadsheet). The Excel spreadsheet version has been pre-formatted to automatically subtotal the nutrition numbers for your meals and grand total the nutrition numbers for the entire day. Spaces are provided for meal subtotals and end of day totals. The spreadsheet contains spaces for the food item, quantity, size, calories, protein, carbohydrate and fat. This handy one-page spreadsheet, created on Microsoft Excel (and also available in a print-ready PDF version), gives you the perfect template for creating your own customized meal plans. Now the food column should be full of pop-up menus that have the "blank" selection.Burn the Fat Daily Meal Planner Spreadsheet (Download) Now select column B2 by clicking the "B" at the top, then unselect the cell in the header row by holding the command key and single click cell B1 Now create a new new table and title is "":Ĭonvert the first row to a header row by selecting the "1" on the left and choosing the contextual menu item "Convert to Header row" Well use it shortly, so do NOT copy anything else. The cell formatted as a pop-up menu is on the clip board. Now select the cell that is empty (in this case cell A9), copy. Now convert these selections to a pop-up menu by opening the cell formatter: Now select the cells in the food column and include one black cell. I'm going to enter made up information so I can confirm it works: I'd sincerely appreciate any help I can get! Thanks, everyone!Ĭreate one table that has the list of foods and the corresponding entries for the Kcal, Protein, Carbs and Fat: I admit Numbers and spreadsheets in general are still relatively new to me. I apologize for this plethora of questions. I know Numbers autofills single cells, but is there a way to get it to also do the rest of the row values? Ideally, I could also have a whole list of Ingredients on another Table, each with the standard values for 100g, and then I could just copy and paste each ingredient into whatever Nutrition Facts Table I'm making and simply change the Amount - or better yet, instead of laboriously copying and pasting, it'd be great if I could just start typing the name of the Ingredient from another table, and Numbers would just autofill the rest of the values. If this is possible, how could I pull this off? I have no idea if this is even possible with spreadsheets, but I have this idea in my mind that if I could only "teach" the cells the values of 100g of each Ingredient, I could somehow get Numbers to do the math and automatically change those values to reflect other gram amounts. But I would like the values of the Calories, Fat, Carbohydrates, and Protein to change correspondingly when I input a different Amount of the Ingredient in grams.įor example, if I were to change the Amount (g) of Dry Yeast from 4 to 10g, I would like the corresponding Calories, Fat, Carbs, and Protein to change accordingly. These are the nutrition facts of some bread I made. Numbers - Nutrition Input Help Hi, Apple Community! I need some help with Numbers regarding the input of my nutritional data. Excel's "data validation" adds them to its "pop-up" without me having to do anything additional. You just type them in and sort the table. I started this with Numbers but have been using Excel instead because it is easier to add new foods to the list.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |