notation is ColB, it'll generate relevant metrics, running total for some metrics like sets / INOL
I also have onedit in sheet where if I put $$ anywhere it will calculate for the row
if I have:
++5,10 it will generate warmups 5 reps jumps at 10%, back to 50%
+++5,10 will do ramping warmups i.e. x5, x4, x3, x2, x1
whatever last onedit row will also split up Rep PRs at top
Most useful for me is auto cycle naming and visualization, i.e. the house keeping stuff that makes all the other apps finicky vs just logging on paper or note
#### date = program name
### macrocycle (i.e. month)
## mesocycle (i.e. week)
# microcycle (i.e. day)
so it will auto generate something like
#24/12/27
#24/12/27「188/58」「3/2/4/4」「2D AGO」 (0,4,4,3)
188th session / 58th session of this program (program 3, macro 3 / meso 4/ micro 4), done XYZ days ago. (0,4,4,3) is push, pull, legs, fatigue/recovery out of 5
Visualization shows on/off days so you can get good timeline sense
box border for mesocycles (week) with how many days at corner (useful for intuitive training)
bars are volume (500lb increments) for varios tags (i.e. bp for all bench press variations)
underline shows inol status for session (none, single under line, double underline, thick underline for >0.4, 1, 2, 2+
it'll highlight extra good or bad sessions i.e. (5,4,0,3) was a very good push day
Now mostly i goto gym, log in google keep:
#YY/MM/DD (performance) comments
ex1 (reps x sets) comments
ex2 (reps x sets) comments
ex3 (reps x sets) comments
Copy and paste into sheet when I feel like it and review metrics graph when needed
$sets x $reps $weight $name (i.e. 3x10 135 Bench Press)
I uploaded the log file to ChatGPT and had it spit out a Python script to parse into JSON:
```
for line in file:
date_match = re.match(r'^(\d{1,2}/\d{1,2}).\*?$', line.strip())
if date_match:
# construct a new workout entry
# continue
exercise_match = re.match(r'^(\d+)x(\d+)\s+(\d+)\s+(.+)$', line.strip())
if exercise_match:
# insert new exercise into current workout
# continue
$sets x $reps $weight $name (i.e. 3x10 135 Bench Press)
I uploaded the log file to ChatGPT and had it spit out a Python script to parse into JSON:
```
for line in file:
date_match = re.match(r'^(\d{1,2}/\d{1,2}).\*?$', line.strip())
if date_match:
# construct a new workout entry
# continue
exercise_match = re.match(r'^(\d+)x(\d+)\s+(\d+)\s+(.+)$', line.strip())
if exercise_match:
# insert new exercise into current workout
# continue
For all the apps that are supposed to make this easier none of them do it right.