jpd236
commented
6 months ago I copied our previous template into a new template and configured it for use going forward, and verified everything worked with a test puzzle:
My changes:
- Remove the frozen first column in the "Puzzle" pane. In my experience, this tends to be more of an interference than a help on many puzzles. It's very easy to freeze columns if/when a puzzle warrants it.
- Replace the "Formulas" tab wholesale, using named functions from the above sheets. Hopefully the given format is clearer, and this is also more reliable than the functions that were present before, which didn't seem to propagate into copied sheets with any consistency.
- Took a pass at the resources in the "URLs" tab, updating/removing dead links and adding a few other resources that I've found useful.
I'll send some notes about this when it comes time to share tech info with the group.
Make common puzzle tasks easier.
There are some common libraries/templates for this that we could probably use as a starting point. https://docs.google.com/spreadsheets/d/1_ghcG3EHLsnUQ6jNx-9svD8e7T5KnkUjc-gdv5kRYn8/edit#gid=2030507275 is a team's template that draws in part upon https://docs.google.com/spreadsheets/d/1mTVD0KtjbU6-wp1mvYU_abrjdCmnP9focRa1qp36rrY/edit#gid=320864130 which is a sheet with a number of helpful puzzle functions. (You can even import named functions from other sheets which can be helpful from a maintenance perspective).