Periodic workouts using google forms/spreadsheets

From Blogger Pictures

Using Google Docs spreadsheet forms to collect data and submit to google spreadsheet was able to collect random entries, display last reps/weight for five sets and then using Michael Galloy's Dashboard Widget formula to calculate 1 RM and using a formula using natural log for growth and decay was able to determine next workout RM given goal RM and date expected.

Taking things a bit further incorporated in a min/max reps per set and next highest 5lb weight to make minimum of desired next set RM from reps/weight.

Variable workout period in days, which changes the RM and in turn the weight according to Reps.

Incorporated a way to select what to workout and ultimately Next workout with date/reps/weight and ultimate max RM...

Allot of work, but making a very simple process of looking at next exercise and then using google forms to enter it.. simple :)



Using Google Docs spreadsheet forms to collect data