Example 11: Give yourself a point.
Self-quantification with time data
With time data, you'll find yourself quantifying everything.
For example, use the time data to determine if you had a good or bad day and give yourself a score.
I present three ways of scoring.
  • 1) Ratio method
The score for the day is expressed as a score of gain time/damage time.
In the monthly pivot table, check Table, Analysis - Options and turn off the "Generate GetPivotDatal" function (tick off).
Adjust the layout as shown below.
Use the formula in column F, with the gain time / damage event, get a set of scores, such as column F, change the score is the score for a different time period, the higher the value of the score represents the gain time activity items more than the damage time.
2) Total percentage method
Divide the gain time and damage time by the total time, respectively.
Right-click on the pivot table and the set value will be displayed as "Parent column summary percentage", as shown in the following figure:
According to the percentage of gain time to fill in the time period of the score, magnify moderately, such as the January score of "32.65%", we directly remove the percentage mark, fill in the score 32.65 can be.
  • (3) Target Completion Act
There is a more sophisticated approach, which is determined by whether or not the broad category of activity completes the goal.
For example, my goals for 2019 in each category are: 33% sleep time, 18% learning growth, 16% work career, 12% daily life, 10% entertainment and leisure, 7% transportation, 4% social interaction. Seven categories with one point for completion and zero points for non-completion for a total of seven points.
In practice, I recommend using Method 2 directly, because there is no need to add other operations such as auxiliary column formula.
复制链接