News for hackers. Stuff that matters.
Re:I keep turning my Google Sheets into phone-friendly webap... by FredPret on Monday December 30, 2024 @08:19PM (#42555433)
I've recently been toying with the idea of turning my overly complicated weightlifting Excel into an overly complicated me-only webapp / testflight app. It can't be worse than Excel for iOS!
Re:I keep turning my Google Sheets into phone-friendly webap... by abound on Monday December 30, 2024 @08:46PM (#42555555)
Self-plug: I wrote a not-too-overly complicated app for tracking my strength training (a 5/3/1 derivative)

https://github.com/bcspragu/stronk

Re:I keep turning my Google Sheets into phone-friendly webap... by hammock on Monday December 30, 2024 @11:00PM (#42556306)
Nice. If you havent seen it, I use 531 calculator religiously and it has a ton of programs on it, and very customizable https://blackironbeast.com/5/3/1/calculator?

Might inspire you as you continue to develop your app

Re:I keep turning my Google Sheets into phone-friendly webap... by worthless-trash on Monday December 30, 2024 @11:33PM (#42556418)
I use stronk (531 BBB) ! Its a damn small world!

I exported most of my data from "Strong" into Stronk, was easy. Thanks !

The interface showed lbs, but my values were all kg, still works.

Re:I keep turning my Google Sheets into phone-friendly webap... by m-zuber on Monday December 30, 2024 @11:37PM (#42556444)
I've been very impressed with hevy[0] so far

[0] https://www.hevyapp.com/

Re:I keep turning my Google Sheets into phone-friendly webap... by tcandens on Monday December 30, 2024 @10:16PM (#42556079)
This seems like a common predicament. I made this one mostly for myself and to try out VLCN sqlite sync. https://www.dumblift.com
Re:I keep turning my Google Sheets into phone-friendly webap... by dcreater on Monday December 30, 2024 @09:00PM (#42555636)
This is exactly what I've wanted to do for a long time. All the apps in the app store are money sucking or ad ridden and unnecessarily cluttered.

I want a simple front end that lets me log lifts to a sheet/database

Re:I keep turning my Google Sheets into phone-friendly webap... by tmpz22 on Monday December 30, 2024 @10:18PM (#42556087)
I’ve been jotting them down in a standardized format in apple notes and using a regex to parse them into structured json for later analysis.

For all the apps that are supposed to make this easier none of them do it right.

Re:I keep turning my Google Sheets into phone-friendly webap... by fudged71 on Monday December 30, 2024 @11:35PM (#42556431)
I’m verrrry interested in your regex!! Can you share?

I’m interested in building a fitness ontology/terminology linked to a tokenizer and parser.

Re:I keep turning my Google Sheets into phone-friendly webap... by tmpz22 on Wednesday January 01, 2025 @01:16PM (#42567883)
My format is

MM/DD/YYYY (i.e. 1/1/2025)

$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
```
Re:I keep turning my Google Sheets into phone-friendly webap... by maxglute on Tuesday December 31, 2024 @04:02AM (#42557488)
I'm doing something similar, incidentally in a wildly complicated google sheets

lot in google keep and copy paste, then sheet does rest

https://imgur.com/a/xoHaxFY (3 images)

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

Re:I keep turning my Google Sheets into phone-friendly webap... by tmpz22 on Wednesday January 01, 2025 @01:15PM (#42567874)
My format is

MM/DD/YYYY (i.e. 1/1/2025)

$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
```
Re:I keep turning my Google Sheets into phone-friendly webap... by sandspar on Monday December 30, 2024 @11:00PM (#42556305)
I use Google Forms to send data to a Google Sheet. You just put whatever lifts you have in the Form with spaces to add weights. I use this Google Form --> Google Sheets thing for a dozen different things.
Re:I keep turning my Google Sheets into phone-friendly webap... by datadrivenangel on Tuesday December 31, 2024 @09:46AM (#42558981)
I do this same Google Form technique, and save the bookmark to my phone's home screen. So it's like having a dedicated app!
Re:I keep turning my Google Sheets into phone-friendly webap... by httpsterio on Monday December 30, 2024 @09:24PM (#42555758)
you could do an ios shortcut that fills a numbers sheet for you
Re:I keep turning my Google Sheets into phone-friendly webap... by dcreater on Saturday January 04, 2025 @03:12AM (#42593326)
hmm tell me more
Re:I keep turning my Google Sheets into phone-friendly webap... by hackernewds on Monday December 30, 2024 @09:46PM (#42555886)
get Claude to make an app and publish it as a PBA
Re:I keep turning my Google Sheets into phone-friendly webap... by dcreater on Saturday January 04, 2025 @03:04AM (#42593296)
PBA?
Re:I keep turning my Google Sheets into phone-friendly webap... by fragmede on Saturday January 04, 2025 @03:29AM (#42593382)
mispelling of PWA, presumably
Re:I keep turning my Google Sheets into phone-friendly webap... by adlotsof on Tuesday December 31, 2024 @01:24AM (#42556860)
I use https://www.liftosaur.com/ which allows for overly complicated stuff with its liftoscript DSL