Back to Archives Home

Spreadsheets

Big Google Sheets nerd here. I love using spreadsheets to track various things and organize data. I've created numerous spreadsheets that I have recycled for various projects and some of the more polished ones are listed here.

Things I need Google Sheets to add:

  • =XLOOKUP
  • Add a "Conditional formatting..." option to the right click context menu when selecting cells.
  • Fix "chart bugging" when editing source data from a large sheet.
  • Add check/tick box customization options (changing the icon).
  • Make =QUERY queries auto-change with sheet changes.
  • Why is a blank cell equal to ""... but a "" cell not =ISBLANK()?

Templates

File > Make a copy

  • Book Pacer: One page target, one end date. Find out how many pages you should read per day to finish a book by a certain date with data visualization. Enter your target in the C column and log your progress in the E column.
  • Advanced Book Pacer: Just like the Book Pacer above, but allows for multiple page targets over the duration of the book. Set targets in the E column, log progress in F column.
  • Reading Log/List: Track the books you read and when along with the length of them. Audiobook support too!

Public

  • Backpack and EDCUpdated!: The things that I carry on me and in my bag.
  • Bugs and Features Under Construction: List of bugs and features requests across major applications.
  • Restaurant Closing Time AnalysisHigh Fidelity: A petty analysis on the closing times of the employees at my workplace.
  • Crossword Speedrun Analysis: An analysis on the suspicious runs submitted to the 100th Anniversary of the Crossword Puzzle leaderboard on speedrun.com.