Skip to main content

Sheets Schemas

Column specs for each spreadsheet referenced from Setup → Sheets.

Personal (private) sheet​

Tracker​

See tracker_example.png. Rainbow color schema from morning to evening. Underline practices that need focus. Don't overengineer.

  • Name: Practice name.
  • Dates: Daily columns.
  • Checkboxes: One per practice per day.
  • Environment score: How pleasant was my environment? Not in your control. Think conditions.
  • Performance score: How well did I perform? In your control. Think execution.

Transactions​

From Tiller. See transactions_example.png.

  • Date
  • Description
  • Category
  • Amount
  • Account
  • Notes: Use hashtags to track specific project costs.

Categories​

From Tiller. See categories_example.png.

  • Category: Name.
  • Type
  • {Month}: Date type.

Activity​

See activity_example.png.

  • Date
  • Type
    • Strength — Upper
    • Strength — Lower
    • Endurance
    • Mobility
    • Recovery (active recovery, not rest)
  • Detail: e.g. Row machine 160 8,8,8. Pullups bw 15,15,15. Shoulder press 145 5,5,5,5. Pushups bw 50,30,30.

Balances​

From Tiller — HIDDEN sheet.

Library (shared) sheet​

Date sorted Z to A. Backlog at the bottom of each sheet.

Grades​

Grading is more intuitive than number and star systems.

  • A++: Outstanding. 5+ stars. 10/10.
  • A+: Amazing. 5 stars. 9/10.
  • A: Solid. 4 stars. 8/10.
  • B: Not great. 3 stars. 6/10.
  • C: Pretty Bad. 2 stars. 4/10.
  • D: Horrible. 1 star.
  • F: 0 stars.

Places​

See Places.

  • Date
  • ID: Google Maps link.
  • Grade
  • Type
  • Name
  • Cost
  • Notes

Books​

See Books.

  • Date
  • Id: ISBN.
  • Grade
  • Type
  • Name
  • Author
  • About
  • Notes

Media​

See Media.

  • Date
  • ID: IMDB.
  • Grade
  • Type
  • Format
  • Name
  • Director
  • About
  • Notes

Podcasts​

See Podcasts.

  • Date
  • ID: YouTube link.
  • Grade
  • Type
  • Name
  • Host
  • Guest
  • Notes

See the full shared sheet.