Sunday, November 18, 2012

Spreadsheets as Diary

It occurs to me that there is much to be said for using a spreadsheet for a diary.
1. Formulas help:
A. Restrict entry types for easier categorization and post analysis.
B. Reset event accumulations as in "how long has it been since" or "it's time to do this".
C. Use "now()" to reverse track event duration statistics.
2. Recent entries can use formulas but when archived to another sheet paste special value to save more robustly.