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.
• Music Tournament Scoring and Stats SheetHigh Fidelity: Scoring sheet and stats for a music tournament.

• 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.

• osu! Tournament History: A log of my tournament participation in the rhythm game, osu!.
• osu! Tournament Scores High Fidelity: My tournament scores/plays in osu!.
• 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.