4/19/2024 0 Comments Weight tracker numbers template![]() You can do this by choosing the graph, in the Axis formatting tab and the Value (Y) subtab selected, enter values in the Min and Max fields, and a Major step that works for you. Chart scale: On some charts, like weight, you’ll need to choose a range that is appropriate for your data. If you choose the entire column with its header and footer rows, it won’t be able to parse the rules and will ask you to combine them. You must choose only the body cells in the column in order to see the rules in effect and change them. To change these coloring rules, choose the column in question, in the Cell formatting tab you’ll see a Conditional Highlighting section, with a button to show all highlighting rules. I find these to be a bit buggy in Numbers. Colored data values: I’ve used data coloring in some of these columns that reflect whether a number is under or over a goal. You could enter a zero for false, but it only makes the sheet more cluttered. We represent true with a “1” and enter nothing for a false value. Boolean data type: In case anyone is wondering, a boolean data type is one that is either true or false. This is not to add to your shame, I just couldn’t find a way to compute this in Numbers (perhaps someone out there knows?). Zero Rings: One-, two-, and three-ring days are automatically computed, but if you have a day where you achieve none of your rings (we all get the stomach flu), you have to enter a “1” manually in the appropriate column. (Numbers still cannot, to my knowledge, lock a cell, so these remain unprotected (be careful!). Do not fill in values here, or delete them. Pale blue columns: All columns in the Daily table with a light blue shade are calculated automatically. Without all three of these, net calories is a meaningless number. Net Calories: Note that net calories should be deleted if you are missing any one of resting, diet, or active calories in your sheet. To make the green boxes, I populate fake data in my first and last day of the vacation, and scale my box to those data points, then I can delete the fake data once the box is in place. The sample ones are locked, and can be altered by going to the Arrange panel and pressing the Unlock button. And, I make boxes on my chart sheets to represent them vertically. Some notes: Vacations: I tend to color the cells on vacation days in a sea green. Some averages will be skewed by assuming empty columns in the month are zero. But, note that the numbers in the table and data in the graphs are not always accurate until the month has ended. Below the table are a series of graphs on your stats, diet, and activity where you can see your monthly progress, or if you need to kick it back into gear-we all have off months. All monthly numbers and charts are generated automatically. The Monthly sheet contains a table at the top which will populate automatically from the daily sheet data. ![]() Diet & Heart ChartsĬharts on this sheet track your weight, blood pressure, resting and walking heart rate, frequency of alcoholic (or sugary) drinks, calories, and macros. See the notes below on how to alter these. When appropriate, lines indicate goals and averages for a particular item. These charts are all aligned vertically so you can compare them to one another with time on the horizontal axis. The activity charts sheet contains visual representations of your move, stand, and exercise data. Feel free to add or subtract from these columns to reflect what you want to track, which can include anything you want to be more disciplined about to develop good habits, or things that will discourage bad habits in your life. Or, enter a “1” if you scarfed down half a package or oreos. ![]() For example, enter a “1” of you went to the gym that day, or if you cooked. These each get a “1” if accomplished for the day. ![]() Vices & VirtuesĪ section for the good things you should be doing more, or the bad things you need some discipline controlling. Heart recovery is a sign of how healthy your heart is. I record the ending heart rate and the 2-minute heart rate. Recovery heart rate appears in the Activity app and appears for certain workouts as a second screen in the app’s heart rate graph. I also track my average heart rate in cardio exercise, and my recovery heart rate. I enter my active calories from my workout (using the workout tracker on the Watch), the type of exercise I did, and the number of minutes I did it. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |