PCE: Cat Info Parser and Village Stats
v2.1.2, 10/3/23: Overhaul, Village Manager, & BEANS! Update
Get all of your village statistics quickly with no effort unless you're a mobile user sorry. This sheet was initially made to work with Remus's Cat Census + ideal jobs spreadsheet, but I thought I'd expand it to the entire cat page!
How do I use this?
File > Make a copy
Entry by Cat Page
1. Open your cat's page. Copy starting from their name to the last 'Luck' line.2. Paste the information into cell A4.
2. Copy ROW 1 and paste values (Ctrl+Shift+V) to a blank row in 'Data'. Enjoy your stats!
(This GIF has the old layout, but it works the same. Do not copy any text after 'Luck'!)
Entry by Village Manager
1. Open your village manager.2. Copy the following pages, starting from the first name to the last line of the last column: Basic Info, Personality, Attributes, Appearance
3. Paste it into ROW 9 of their respective categories.
4. Copy ROW 70 to ROW 129, then paste values (Ctrl+Shift+V) to a blank row in 'Data'.
For every new update, do I need to do copy every cat page again?
NO. Please save yourself the pain. Copy A4:AD of the Data tab and paste it into cell A4 of your new sheet.
Yet to Add:
- Convert Birthdays to IRL Date
- Filter Null Carriers (if Genetic String is available/manually set it to Null Carrier)
Has a sheet ever nearly made you cry out of pure frustration? No? Well. this sheet has nearly done that 3 times in 1 night. /hj But I had fun suffering!!! I am thrilled with how this turned out!!!
A special thank you to my dogs for emotionally supporting me through this. Thank you to fae for inspiring me to make a birthday section!
Are my spreadsheets helpful? Check out my others!
Whisker's Wares Pinglist | Clothing Database and Tracker | Scenario Guide | Inventory Parser
Enjoy my spreadsheets? Consider leaving a tip!
Gift to gay #32 | My Ko-Fi
A special thank you to my dogs for emotionally supporting me through this. Thank you to fae for inspiring me to make a birthday section!
Are my spreadsheets helpful? Check out my others!
Whisker's Wares Pinglist | Clothing Database and Tracker | Scenario Guide | Inventory Parser
Enjoy my spreadsheets? Consider leaving a tip!
Gift to gay #32 | My Ko-Fi