The analysis spreadsheet for the Village Life cards is trickier than expected. I wanted to show values like “-1” when a villager loses a coin and “+1” when they gain one. But the formulas for calculating averages don’t recognize “+1” as a number, so I had to remove all the plus symbols.
I have this strange setup now where there’s all the data that actually appears on the cards, and then there are columns for analysis that are mostly derived from that data, but with some manual adjustments based on other effects. And then there’s a separate export sheet composed entirely of formulas to extract the card data from the analysis sheet, without the analysis columns and rows.
Despite all that, I managed to generate a deck and set it up in TTS. I need to tweak some of the buildings and then run another solo playtest.