But if you do weigh yourself in the mornings, do that consistently.įast weight loss goals aren’t the easiest to achieve. Your body looses water over night, so weighing yourself right when you get up may look good in the numbers, but may be more a reflection of water loss than actual weight loss. When tracking your weight, you should be consistent with the time of day and what you are wearing to avoid any large fluctuations in measurements. To view all your data, click the “View My Data” button at the top of the page. Your information will be automatically stored in “My Data”.
WEIGHT TRACKER EXCEL UPDATE
To update your weight loss progress, enter your current weight and body measurements (and blood pressure measurements) into the white coloured cells, then click the “Update Progress” button at the top of the page. All other cells are automatically calculated for you. Click the “View my Weight Loss Prgress” button.Basically, the way the spreadsheet works is that any “white” background coloured cell, you are able to enter your own information into. On this page, you’ll fill out your name, date of birth, your starting measurements and what your goals are.Once you have done that, pretty much everything else happens on the main page. When you very first open the spreadsheet you’ll want to click the “Update My Personal Details” button. MinimumScale = ActiveSheet.Range("$B$9").Value. MaximumScale = ActiveSheet.Range("$B$49").Value +. MinimumScale = ActiveSheet.Range("$C$5").Value - 3 MaximumScale = ActiveSheet.Range("$C$5").Value + ActiveSheet.Range("$C$4").Value + 3 With ActiveSheet.ChartObjects("Chart 1").Chart Private Sub Worksheet_Change(ByVal Target As Range) MajorUnit is an user-configurable option that you can modify via the Format Axis option - right now, it's set to 7 units, which really is 7 days.
WEIGHT TRACKER EXCEL CODE
Code is as follows if you don't want to open up the spreadsheet with macros enabled - it defaults to disabled anyway. The updated spreadsheet has VBA Code which is shown below for your review. I took liberty in combining Input and Graph worksheets into one clean worksheet, and left Calculations alone. Your blog didn't have an option to send an email if a comment thread got a response.Īnyway, the xlsm is Excel 2007 and later. Sorry for not getting back to you sooner. There are lots of other websites or books with more information on this. If you have a high BMI you should gain a less weight and if you have a low BMI you should gain a bit more. Supposedly in the U.S., woman with normal BMIs are advised to gain 25-35 lbs whereas in Canada they are advised to gain 25-30 lbs (see " CBC: Pregnancy weight gain guidelines may be too high"). The defaults are for someone with average BMI. You only need to enter your starting weight, your date of last menstruation and the low, medium, and high targets on the "Input" sheet and enter your weight weekly (you can skip weeks too and it will still work) on the "Graph" sheet. The minimum and maximum bands are visible on the chart and the goal is to stay within those bands.
The defaults are a minimum gain of 25 lbs, a target gain of 27.5 lbs, and a maximum gain of 30 lbs.
I assumed a weight gain of 4-6 lbs in the first trimester followed by steady weight gain all the way until the end of the pregnancy. The spreadsheets are available below in Excel and OpenOffice format. I made a spreadsheet to help my wife know at any point of her pregnancy whether she is underweight or overweight relative to the end target. But when you are 4 months pregnant or when you are 7 months pregnant it is hard to know how much you should weigh at that point in your pregnancy. Not gaining enough weight can cause problems just as gaining too much weight can cause problems.
When woman get pregnant they are supposed to gain weight.