Org-Mode tables to track progress
I use org-mode tables to track my progress on challenges in Strava.
Of course only the hard to achieve ones, i.e. the "Cycling Climbing Challenge".
Today (2020-02-16) my "February Cycling Climbing Challenge" table looks like this:
|-----+-----+-----+--------------+------| | 01. | sat | 0 | sum columns: | 2000 | | 02. | sun | 0 | current: | 5580 | | 03. | mon | 0 | total: | 7580 | | 04. | tue | 0 | goal: | 7500 | | 05. | wed | 0 | missing: | -80 | | 06. | thu | 0 | | | | 07. | fri | 0 | | | | 08. | sat | 0 | | | | 09. | sun | 0 | | | | 10. | mon | 0 | | | | 11. | tue | 0 | | | | 12. | wed | 0 | | | | 13. | thu | 0 | | | | 14. | fri | 0 | | | | 15. | sat | 0 | | | | 16. | sun | 0 | | | | 17. | mon | 200 | | | | 18. | tue | 200 | | | | 19. | wed | 200 | | | | 20. | thu | 200 | | | | 21. | fri | 200 | | | | 22. | sat | 0 | | | | 23. | sun | 0 | | | | 24. | mon | 200 | | | | 25. | tue | 200 | | | | 26. | wed | 200 | | | | 27. | thu | 200 | | | | 28. | fri | 200 | | | | 29. | sat | 0 | | | |-----+-----+-----+--------------+------| #+TBLFM: @3$5=@1+@2::@1$5=vsum(@<$3..@>$3)::@5$5=@4-@2-@1
This month I already cycled enough weekend tours to reach the goal but only if I cycle to work the remaining days (the workday value is
200
meters).To update the table I copy the
current
value manually from the Strava page, set the past days to 0
, and update the table (C-u C-c C-c)
.There is a lot more possible with the org-mode table editor: https://orgmode.org/manual/Built_002din-Table-Editor.html