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

Git annex -- lessons learned

For storing my 2.3TB of images using git-annex I learned a bit.

Instead of saving every single image in git annex I store every folder if images in tar files. Git annex gets pretty slow when storing over one million files. With the big tar files this problem is solved.

To use the files I extract them to a folder shared via sshfs between other servers. Everything is within my tinc, so that access to computers at home is also possible.

Git annex helps me keep files in sync between storage at home and images partially synced to internet servers.

Git annex and rsync

I started to use git-annex for my GoPro archive (atm 2TB of jpg files). But for my upload scripts to openstreetcam and mapillary I needed the files and not the symlinks git-annex is using.

rsync for the rescue.

From the rsync man page:

-L, --copy-links            transform symlink into referent file/dir

In my scripts I now use rsync -aL source target to get the files out of a git-annex repository.