I came here because I made my own spreadsheet with a nifty visualization that I haven't seen anywhere. strengthjourneys.xyz is stupid good looking and much better than anything I'd make (I'm a backend software engineer), so once I found it I think it's easier to invest in this. Create a matrix with columns as reps, rows as weights, and the cells are the e1RM for that (weight,rep) pair. Then given some (date,exercist, weight, reps) set tuples, generate the e1RM for each set. ## PRs obtained Highlight the (weight, rep) cells which have been achieved in dark green. ## Guaranteed new PRs Highlight the cells which can definitely be done as light green (eg: you lifted 50lbs for 10 reps but never lifted 45 lbs for 8 reps so color that light green) ## Probably new PRs Highlight the cells that are <= to the e1RM in light yellow. This visualization is almost like a farming/terraforming video game: every day try to cover more area Not feeling strong today? Harvest a PR that you definitely can make but just haven't yet drop sets give you a rep target to maybe eke out a new e1RM New e1RMs increase the total area so you can always visualize your current strength there are always multiple paths towards some far off e1RM goal As I'm in my 40s I'm not going to actually attempt a 1RM so I'm not going to push big numbers, so I have to rely on the math for my dopamine hit. ## Google Sheets Implementation Given a workout log titled Sheet1 with the columns used here, the conditional formatting is listed below. NB: INDIRECT is used because you otherwise can't reference a different sheet in a conditional format. # PRs obtained =LTE(B$1, MAX(FILTER(INDIRECT("'Sheet1'!C:C"), INDIRECT("'Sheet1'!B:B")=$A$1, INDIRECT("'Sheet1'!D:D")=$A2))) # Guaranteed new PRs =NOT(ISNA(FILTER(INDIRECT("'Sheet1'!C:C"), INDIRECT("'Sheet1'!B:B")=$A$1, INDIRECT("'Sheet1'!D:D")>=$A2, INDIRECT("'Sheet1'!C:C")>=B$1))) # Probable new PRs =LTE(B2, MAX(FILTER(INDIRECT("'Sheet1'!J:J"), INDIRECT("'Sheet1'!B:B")=$A$1))) I trust that you'll snazz up the visualization if you find it useful.
