Back to Archives HomeSpreadsheets
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.