From WhyNotWiki

Contents 1 Data entry form 1.1 Mock-up 1.2 Metrics / units of measurement for each exercise 2 Problem: recording offline 3 Views

[edit] Data entry form

[edit] Mock-up

• Exercises I can do at work (can print off and bring to work)
  • hands on temples, elbows forward
  • lunges
• Exercises I can do at lunch
• Exercises I can do in the car
• Exercises I can do at home
  • Most common
    • Walking
    • Neck traction
  • On the ball
  • Egoscue
  • On the fun noodle

Might be some overlap between locations.

Give a score, based on how much exercise I do, how much improvement, how little pain, etc...."You get 22 goody points today!"

Also measure flexibilyt limits.

[edit] Metrics / units of measurement for each exercise

Do I want to record a boolean (did the exercise or not = checkbox) or an amount (how many reps, sets, etc. = text field)?

I'm leaning towards having both and making the amount field(s) optional. So if you're in a hurry or don't remember the exact amounts, just check the box by each exercise you did today (not just if you did one rep--enough to be countable). If you enter an amount, it would automatically check the checkbox.

Storage in database:

exercise_log_items:
date_time | sets | reps
Merely being present in the table would indicate that the checkbox was checked... If you don't check the box for Tuesday for exercise A, there would be now row for Tuesday for exercise A.

[edit] Problem: recording offline

Solution:

print off the form; reuse same paper; cross out yesterday's values and write in today's; at the end of the day, enter all the data into an electronic form and cross out yesterday's values .

[edit] Views

1 view for entry (1 field per line), another for reporting