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

  • Valorant RR HistoryHigh Fidelity: Track RR gains and losses. Track win rate across days, maps, agents, and more. Generate a W/L display for your Discord status.
  • Finance TemplateBeta: Track spending across accounts, planned expenses, available money for the week, and more.
  • 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.
  • Crossword Speedrun Analysis: An analysis on the suspicious runs submitted to the 100th Anniversary of the Crossword Puzzle leaderboard on speedrun.com.
  • Portal 2 Co-op Players: A log of all the random queue players I find in Portal 2 Co-op with data visualization for player quality on days and time, individual player stats, and total games.
  • Keep Talking and Nobody Explodes Mod Ideas: A collection of my mod ideas for KTaNE.