Reply to Thread

Guest, we'd love to know what you think about the forum! Take the Diabetes Forum Survey 2025 »

Message: <blockquote data-quote="SG2016272" data-source="post: 1206318" data-attributes="member: 283446">Hi,Please find attached MS Excel spreadsheet titled 'LCHF Meal Calculator - for Protei-Fat-Carb-GI-GL-Calorie-Meal Fat%.xlsx’  which hopefully may assist you to calculate the total food ingredients Protein-Fat and Cab nutrients based on the amount in portion used (usually per 100g, or parts of). The spread sheet was originally developed in Apples ‘numbers’ format, so I hope this MS Excel version of the original has coverted OK. My apologies if it hasn’t. Post script The Forum blog for some reason refused to allow me to Upload a file ending in the extension '.xlxs'.If you would like a working copy of the file please could you send me a private message with a suitably safe email address for me to send it to.Once received It will be password protected so enter ‘-------' to open it up. I will send this with the above .xlxs file.On the LHS are all the food stuffs I tend to use. This is scrollable down the page.The column to the right of that give the Nutrition Values (Protein, Fat, Carbs, Energy) for each food typeTo the right of those are three columns  for LCHF Fat% (auto calculated), GI (manual input by user - currently data is hard to come by for some foods), GL (auto calculated - once previous GI values gets added)Further to the right are four senate section for four meal - Breakfast, Lunch, Dinner, Other these section are all auto calculated - when their most left hand ‘Portions’ column has a 0 or other number entered into the cell appropriate to the food ingredient on that line (far left - first column). I’ve already populated four meals by way of example. So to begin using these for you meal ingredients just over type than entries I put into the ‘Portions’ columns with ‘0’.Once you have entered the number of food ingredient portions (based on a 100g serving, usually 1 for 100g, or 0.5 for 50g etc.) I suggest that you first check the food column just in case as the description gives how big the food portion size is based upon.The relevant totals for each of the four meals is shown at the bottom of each of the four meal section (scroll down the page if not immediately visible). Since I originally designed this spreadsheet for my own use i.e Type 1 Diabetic on LCHF diet I have only based the bolus BGM entry based on Protein Counting and not carb counting and have also added a 0.38 reduction factor to compensate for the reduced conversion rate of Protein to blood glucose by the gut. For me it works well at 0.38 but can be altered to suit different user. (but essentially around the 0.4 area - according to Dr Bernstein - who himself is a T1D.Final point is to remember to reset at the end of the day (by entering enter ‘0’), all meal portion figures  you’ve previously entered, in readiness for the next day.I truly hope this is of assistance to you in calculating your 'smoothies total ingredient carb count'.</blockquote>

Verification

Top Bottom

Search

Search

Reply to Thread