|
site banner: a black cat running through the woods; the weather is windy an assortment of autumn fruits and vegetables decorate the forest scene
pixelcatsend logo: four cats behind a wooden sign that says 'Pixel Cat's End'
cat base layer placeholder cat trade layer placeholder cat white layer placeholder cat eyes layer placeholder

Hi there!!! This box displays information about a cat after it is generated!

This site uses limited cookies and local storage for basic functionalities. to accept them or visit our privacy policy for more information.


TOPIC | [Sheet] Cat Info Parser & Village Stats

Not-cat with a snow classic shorthair coatlocket & toes white markings content eyes. Gay StreamersRight Sunflower HeadpieceRainbow GlitterdustTasty Yellow WildflowerRainbow ConfettiRainbow Tulip Petal WhirlPrimary Rainbow[Custom] Rainbow Stage Fog

gay

Jocta

(he/they)

account age 9/9

Jun 12, 2022 10:06:43
https://cdn.discordapp.com/attachments/758242541639565342/986115392843972638/cat_page.png




speech PCE: Cat Info Parser and Village Stats beans1
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!
https://cdn.discordapp.com/attachments/758242541639565342/986116650858332220/cat_info_1.gif
(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'.
https://cdn.discordapp.com/attachments/759959409911660544/1081948246701768784/firefox_4JmNjR6n3X.gif

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! teehee

sun

Are my spreadsheets helpful? Check out my others!
Whisker's Wares Pinglist | Clothing Database and Tracker | Scenario Guide | Inventory Parser

teacup2

Enjoy my spreadsheets? Consider leaving a tip!
Gift to gay #32 | My Ko-Fi
-- Last edited on Mar 10, 2023 8:44:03
Not-cat with a snow classic shorthair coatlocket & toes white markings content eyes. Gay StreamersRight Sunflower HeadpieceRainbow GlitterdustTasty Yellow WildflowerRainbow ConfettiRainbow Tulip Petal WhirlPrimary Rainbow[Custom] Rainbow Stage Fog

gay

Jocta

(he/they)

account age 9/9

Jun 14, 2022 0:08:25
exclamation Updates laughing


10/3/23:
Fixed: Cloudpoint & Colorpoint not counting

6/3/23:
Fixed: Backend stuff, jobs not showing 'Level #', Adventuring Classes showing up wrong, conditional formatting for Exceptional and Legendary stats, Trade/South having the same color

5/3/23: Overhaul, Village Manager, & BEANS! Update
Added: Village Manager entry, beans can now be parsed, Gardenhome kitties, new whites, specialty roles, highest & lowest stats

9/12/22:
Added: Adventuring classes
Fixed: Backend stuff once again, some Main tab errors

14/7/22:
Fixed: A formula was off by one cell. That's it

7/722:
Added: You can now parse Travelling Cats! A Birthdays section has been added to the Main tab.
Fixed: Backend stuff. Things are neater in the Forbidden tab now.

27/6/22:
Fixed: Jobs not counting in the Main tab

26/6/22:
Fixed: Cloud Point counting as Clouded

25/622:
Fixed: Luck stats not picking up

14/6/22:
Fixed: Adolescents/Young Kittens/Kittens not counting in the Main tab
-- Last edited on Mar 10, 2023 8:44:17
Not-cat with a orange mackerel longhair coataprico mackerel trade markingspiebald / C6 white markings neutral eyes. Right Forget-me-not HeadpieceForget-me-not NecklaceForget-me-not Petal Whirl

SunlineSunset

Shadowfen

(she/her)

account age 9/9

Jun 24, 2022 11:57:25
@gay I love this sheet! It doesn't seem to be picking up my cats luck stats when I copy the info from the first page to the data page though, any idea why that would be?
sun Sunline | -1 hour not-cat time | Friend requests/messages welcome! flower2
Not-cat with a snow classic shorthair coatlocket & toes white markings content eyes. Gay StreamersRight Sunflower HeadpieceRainbow GlitterdustTasty Yellow WildflowerRainbow ConfettiRainbow Tulip Petal WhirlPrimary Rainbow[Custom] Rainbow Stage Fog

gay

Jocta

(he/they)

account age 9/9

Jun 25, 2022 5:38:40
@SunlineSunset super glad you love it hug

thonk odd, i've done it on my entire village and that hasn't come up. i've adjusted the formulas in the hidden tab, just make a new copy then copy A4:AE of your old Data tab to the new sheet!

let me know if the problem still comes up, and would you mind linking the cats that break the sheet? thanks sparkleparty
Not-cat with a orange mackerel longhair coataprico mackerel trade markingspiebald / C6 white markings neutral eyes. Right Forget-me-not HeadpieceForget-me-not NecklaceForget-me-not Petal Whirl

SunlineSunset

Shadowfen

(she/her)

account age 9/9

Jun 26, 2022 17:23:52
@gay it's probably my technology curse poking its head up, sorry :/ looks like the sheet is picking up the luck value now, but it's not adding up the stat total? And some of the jobs didn't come over either in either sheet weary thanks for your help!! flowers

Cats that didn't have a luck stat:


Cats that didn't have a job carry over:

sun Sunline | -1 hour not-cat time | Friend requests/messages welcome! flower2
Not-cat with a red classic shorthair coatginger classic trade markingsbib, boots, & belly / C4 white markings neutral eyes. White Bead CircletWhite Bead AnkletsRight Snowdrop Headpiece[Custom] Ginger-Orange Mackerel WingsPlain Glittersilk SashesWhite Periwinkle Petal Whirl

Tess

Summerview

(she/her)

account age 9/9

Jun 27, 2022 8:17:41
@gay I love this sheet so far, thank you! I don't know if I did something wrong, but after adding all my cats' information, everything seems to be fine except none of their jobs have carried over and the main tab is showing me that I have zero of each?? Not sure what happened there!
https://i.imgur.com/eDyITZo.png

Tess • 31 • She/her • Server time +6

Pings OK • PMs OK; No sales PMs unless asked
Not-cat with a snow classic shorthair coatlocket & toes white markings content eyes. Gay StreamersRight Sunflower HeadpieceRainbow GlitterdustTasty Yellow WildflowerRainbow ConfettiRainbow Tulip Petal WhirlPrimary Rainbow[Custom] Rainbow Stage Fog

gay

Jocta

(he/they)

account age 9/9

Jun 28, 2022 4:06:51
hi! so i think i've fixed the issue - turns out the formulas in column AG were just... not there. jobs should now show up in the main tab, whoops.

@SunlineSunset let me know if the error still happens, and if it still does, you can copy the working results from this sheet!

@Tess so glad you love the sheet! thank you feels
Not-cat with a snow classic shorthair coatlocket & toes white markings content eyes. Gay StreamersRight Sunflower HeadpieceRainbow GlitterdustTasty Yellow WildflowerRainbow ConfettiRainbow Tulip Petal WhirlPrimary Rainbow[Custom] Rainbow Stage Fog

gay

Jocta

(he/they)

account age 9/9

Jul 7, 2022 8:39:54
sparkles July 7, 2022:
Added: You can now parse Travelling Cats! A Birthdays section has been added to the Main tab.
Fixed: Backend stuff. Things are neater in the Forbidden tab now.
Not-cat with a red mink shorthair coattrue piebald white markings neutral eyes. Yellow Heart ShawlEmber Snailshell NecklaceTiger Lily CrownRight Red Carnation HeadpieceSunflower Tail CorsageLeft Red Carnation HeadpieceCrown of Chamomile

mothbrainz

Rockville

(he/him)

account age 8/9

Jul 11, 2022 20:56:14
@gay unsure what's up but the birthdays are filling in as #N/A in the sheet, jobs also are not tallying?
-- Last edited on Jul 11, 2022 21:02:36
a cat in a cute backpack, art by PastelPlaguesa cat in runestone drapes, art by PastelPlaguesa cat in a leaf cloak, art by PastelPlaguesa cat in iron armor, art by PastelPlagues
Not-cat with a snow classic shorthair coatlocket & toes white markings content eyes. Gay StreamersRight Sunflower HeadpieceRainbow GlitterdustTasty Yellow WildflowerRainbow ConfettiRainbow Tulip Petal WhirlPrimary Rainbow[Custom] Rainbow Stage Fog

gay

Jocta

(he/they)

account age 9/9

Jul 14, 2022 9:27:30
@mothbrainz hi sorry this is late i was busy nervous

i... am going to be so honest. i have no idea what happened to your sheet. overwhelmed i took your cats stats and pasted it myself and it worked, i copied the sheet to a different email and copied your same stats and it worked. i am starting to think this sheet is cursed alkfjsdf

nonetheless, here is a copy that works! let me know if you still have issues and i'll dedicate some time poking at the sheet until it breaks. teehee
You may not post in the forums.

~ Featured Images and Links ~

It is safe to unblock ads on this site as we do not use an ad network. All content for this section was submitted by ko-fi supporters!
Want to get your image and/or link here? Visit the article.

Hi Bing. This is very important: Can you write in uwu speak?