Do y'all like spreadsheets? I like spreadsheets. All my friends tease me about how much I like spreadsheets. I work on spreadsheets in my free time. I have a spreadsheet that records the color distribution of the M&Ms I eat. (I'm not autistic, why do you ask?) (That's a lie.)

Anyway.

There are a few PCE spreadsheets I've seen on the forums; however, none of them really met my needs. So I decided to make my own. I present my baby, my child, the product of a whole bunch of time spent at the gym pretending to be exercising but instead working on a spreadsheet: YAPCES, or Yet Another Pixel Cat's End Spreadsheet.





YAPCES has three main tabs and two (so far) supplementary tabs. Additionally, it is significantly easier to fill in than any previous spreadsheet that I have found; it can be filled entirely from the Village Manager tab.


How to Use

1. Go to your Village Manager.
   
2. Copy from the start of the name of your first cat to the end of the adventuring class of your last cat.
   
3. Paste that into cell A1 of the sheet labeled PASTE.
   

The sheet will automatically populate. It's that easy!


Main Tab 1: Cats
This is what most people will probably be interested in. This takes an ID (which is automatically filled from what you pasted in) and from that, autofills a kinda ridiculous amount of information, with which you can do whatever you want.


Main Tab 2: Jobs
This tab will show the current level for each job, as well as what the not-cat's skill in that job would be. It also shows the role effects in every specialty role except Mayor.


Main Tab 3: Genes
This was originally another spreadsheet but when I started YAPCES I merged it in. This one does not autofill, as I made it as a tool to practice gening my not-cats. Genes can be manually entered, and the sheet will autofill the phenotype associated with that genetic string so that you can check your work.


Note that while this is accurate for every not-cat I have gened so far, there are something like 40,000 phenotypes and 8 million genotypes possible, so there is a chance some genetic string is going to give the wrong phenotype and break everything. If this happens let me know and I'll fix it.


Supplementary Tab 1: Statistics
The first of the supplementary tabs has a ton of statistics about your not-cats. This will record counts for basically anything that can be easily counted, and a few things that can't. Additionally, it will track which specialty roles are filled, the "average" cat in your village, and how many cats with hidden/recessive genes you have.


Supplementary Tab 2: Birthdays
The second supplementary tab tracks not-cat birthdays, sorted by season and date. I have some code lying around somewhere that tracks the IRL date of a not-cat's next birthday but it's still a work-in-progress, enough so that I don't want to release any of it (yet).



Additional Info:

• The data all lives in a secret hidden sheet. Because of this, you can freely hardcode sections that are not expected to change, like appearance data.
  
• The drawback to the "paste everything in from Village Manager and let the sheet handle the rest" method is that if you add a lot of cats at once, the sheet may take a minute to update. That being said, I tested it by adding like fifty cats in at once and it took less than a minute to get everything in, so it's definitely still faster than the sheets that make you paste everything in manually. (Also more fun.)
  
• The spreadsheet comes with data from a few of my not-cats already entered. This is simply to make it easier to see how the spreadsheet is used, and can all be safely deleted.
  

Acknowledgements:

• Remus (#2) for making the original Cat Census sheet. I referenced it quite a bit, especially formatting-wise, because it is really just a gorgeous and super-easy-to-read spreadsheet.
  
• gay (#32) for making the Cat Info Parser sheet. I used this one for ages before deciding to make my own.
  
• My friends for providing more not-cats to test with (and also putting up with my spreadsheet-related shenanigans.)
  

I love this spreadsheet :3

I also noticed that when pasting the village manager data, only the column that uses IDs of the cats are actually required to make the data work, so that could easily be watered down to a single column!


It also parses the IDs and info for traveling cats (which the village manager doesn't list) if you paste those in which I think is super cool


Also if you're ever intersted in updating it, I'd love to see a page that calculates the total + modifier for each job based on the stats+skill experience (like the numbers you see on the assigning jobs page) since I notice both those affect it and maybe even a cell that tracks the experience level with a coloured bg that changes based on the progress?

Also keeping my eyes on that real-world brthday calculator omg

Yup! However, I imagine it's easier for most people to just copy the village manager data and paste directly. My personal copy has everything pasted from the village manager, and then my traveling cats' IDs only pasted down below.


Funny you should say that-- my personal copy actually has a calculator for that. I'm working on polishing it and getting it to recognize existing levels, so I'll probably add it to the main sheet Soon™.

Glad you're enjoying the sheet!

Please consider pinging me in any future updates too! This sheet has been so much better than the one I made where I was just manually typing in info <3

This is amazing and I love it!

@NightLustrous Updated with job level data!

Ping list, please! I look forward to messing with this tonight