I am able to weigh myself but the food I ate on the previous day was excessive, e.g.I am able to weigh myself and the food I ate on the previous day was normal.When you have the file running click on the Measurements tab and you will see one of the views below:Įxcel Measurements Sheet for Weight in Stones and PoundsĮach day I find myself in one of three situations: A third sheet has a separate graph reflecting the rate of change of weight entitled Rate of Change.The graph mentioned above is on a second sheet entitled Bar Chart.Data is entered on one sheet of the workbook entitled Measurements.I should point out that there are three spreadsheets in the workbook: Save as – select this and you can choose where to save the file.Save – select this and the file should be saved in your default download folder where you can find it later.Run – select this and if you have a suitable version of Excel installed it should open and display your chosen file.Having clicked on the links above you may be given the following options (at least in IE9 on Windows 7): NOTE: Once you have got these Excel Body Weight Templates into Excel you can save them as templates by changing the “Save as type” to xlt or xltx as appropriate in the Save dialog. MyWeightInStonesAndPounds.xlsx – for people who weigh themselves using an imperial scale and use Excel 2007 or 2010.MyWeightInkgs.xlsx – for people who weigh themselves using a metric scale and use Excel 2007 or 2010.MyWeightInStonesAndPounds.xls – for people who weigh themselves using an imperial scale and use older versions of Excel (97-2003).MyWeightInkgs.xls – for people who weigh themselves using a metric scale and use older versions of Excel (97-2003).Just click on a file name below to down-load one of these Excel Body Weight Templates: I have had seven years to try and perfect the process and have prepared four down-loadable Excel Body Weight Templates for different Excel versions and metric/imperial measurements. I expect people to understand how to use it by following the MS Office Help process. Note: I’m not planning to give a long lecture on the use of Excel. MORE ABOUT USING EXCEL BODY WEIGHT TEMPLATES The point is to try and arrive at a consistent set of measurements that can be used to display a meaningful average weight situation, over time, on a graph. Our weight fluctuates up and down 2 or 3 pounds throughout the day. (We lose up to 1.5kgs at night due to exhaling moisture in our breath and urinating.) The point here is not to come up with an exact daily weight – it’s impossible. This way I get the feel-good-factor of seeing my lowest possible weight each day. I chose first thing in the morning, before eating or drinking, after visiting the bathroom and without clothing (I keep my hat specs on). Having decided on the tool for recording the data I then had to decide when I would measure my weight. Ultimately it offers Excel Body Weight Templates – files that you can download to use with your Excel software so you can record your measurements in like manner. The rest of this post explains my method for collecting the data and the use of Excel Body Weight Templates to start a new record annually. ( Note to self: I need to be more scientific about regulating the calories I consume.)įor me as a Microsoft Excel user for many years, Excel was my tool of choice for recording and plotting the data. Now I have risen again to 14st (88.9kgs) a weight I swore I would never see again. Then I rose again to 14st 7lbs (92kgs) and came down to 13st 2lbs (83.46kgs) in February 2010. During this time I have come down from my heaviest of 15st (95.25kgs) in 2005 and again in July 2007 to 13st 4lbs (84.36kgs) in the same year. I want to see if my weight is actually heading down or up or staying put. Anyone would think that the act of measuring weight caused it to change. (I know Quantum Physicists have their doubts.)īeing scientific requires not just the measurements written down somewhere but a graph to give a picture of what is happening over time. High definition pictures are better than low definition ones and weighing every day gives a good weight definition. I know all those slimming clubs advise against measuring weight daily but to me that is unscientific. I record my weight on a DAILY, yes DAILY, basis. I use Excel for this and I’ve produced some Excel Body Weight Templates for making new sheets annually. One tool I require for this is a spreadsheet to accurately record of my weight. Well I resolved to lose weight every year since at least 2005 and some years I succeeded. Excel Graph of Helpful Colin’s Weight 2011. (Select it to enlarge it.) “Happy New Year! In 2012 I resolve to lose weight (again).”
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |