|
site banner: a black cat running through the woods; the weather is partcloud
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 | Cat Census + ideal jobs spreadsheet

Not-cat with a brown clouded shorthair coatbib, boots, & belly / C4 white markings neutral eyes. Winter Leaf CloakSapphire GlitterdustShined Iron ArmorBlue Glittersilk ScarfDark Snailshell NecklaceUncut Diamond CrownFalling Winter LeavesWatercolor Daisy Petal Whirl

Alqamar

Haven's Reach

(he/him)

account age 8/9

Oct 12, 2022 21:04:00
bookmarked!! thanks so much for making this resource <3 hug
Not-cat with a aprico mink longhair coatsnow mink trade markingsno white markings danger eyes. aaaaaaaaaaFallen Grass ScarfKnife

YourLocalGrubdog

Allium

(he/him)

account age 7/9

Nov 18, 2022 19:32:40
I'm sorry, but I'm extremely confused overwhelmed I'm trying to follow the parser instructions, but it just keeps not working. I'm pretty sure it's on my end, from me misunderstanding the given steps. Is it possible for someone (doesn't matter who really) to post screenshots of what to do? I think I'd be able to understand the images better than written text.

I'd appreciate it a lot ;w;
GrubDog ~ PCE +0 ~ I like pikmin hehehehe
Not-cat with a aprico clouded longhair coattan clouded trade markingspiebald / C6 white markings content eyes. Sweet Cat-tato HornsStick CrownTiger Lily Petal WhirlCrown of Parsley

Maplebreeze

Fallenleaf Refuge

(they/them)

account age 7/9

Nov 18, 2022 22:37:41
Hi! I was also struggling with this so I thought I'd let you guys know how to make it work :)

You have to copy J10:BN10 and then when you paste in into the cats section, you need to right-click and select Paste Special > Values Only.

Hope this helped~!
alt text required
Not-cat with a grey colorpoint longhair coatno white markings neutral eyes. Sapphire SmokeBlue Butterfly on HeadTasty Forget-me-notBlue Wildflower NecklacePeriwinkle CrownWatercolor Daisy Petal Whirl

Mayali

Neptune

(she/her)

account age 7/9

Nov 19, 2022 14:57:08
thank you so much for this, as a new player i was kinda overwhelmed by all the stats and jobs but this makes it easy to decide jobs without worrying if im messing it up :D
Not-cat with a smoke mink shorthair coatsilver mink trade markingslocket & toes white markings stern eyes. Light Front Leg ScarsSilver CuffsRunestone TangleSilver AmuletPlain Glittersilk Tail SilksPlain Glittersilk ScarfFabulous Silver Aura

darthfervens

Perihelion

(they/them)

account age 7/9

Nov 19, 2022 16:19:23
Is there a way to manually cut it down to values only? Values-only paste isn’t an option on mobile.
Not-cat with a ginger rosette longhair coatlocket white markings right eyes. Light Back Leg ScarsLight Ear ScarsLight Tail ScarsTan Snail on HeadDark Left Eye ScarAqua Snail on BackLight Back Scars

ChinchBug

The Bards

(he/him)

account age 7/9

Nov 20, 2022 6:15:24
As a heads up, the current (from what I could tell) version seems to get confused at the parser if a cat had adventuring experience?
I fixed that on my end with a bit of rattling it around:
copy pasted '=OFFSET(INDEX($D$33:$D,MATCH(Cats!AF1,$D$33:$D,0)), 1, 0)' formula from AN10 to AT10 (note for anyone who tries to do so, the Cats!AF1 should change in each one, it's hard to explain exactly)
Not-cat with a red mackerel longhair coatspotted piebald / C7 white markings uwu eyes. [Custom] Fernfrond Shawl[Custom] SP24 - Magnolia Spring Witch HatRound Green-Tinted Glasses[Custom] Left Daffodil Headpiece[Custom] Brown Leather Collar

forest

Rootwood

(he/they)

account age 7/9

Nov 21, 2022 17:39:11
ChinchBug said
As a heads up, the current (from what I could tell) version seems to get confused at the parser if a cat had adventuring experience?
I fixed that on my end with a bit of rattling it around:
copy pasted '=OFFSET(INDEX($D$33:$D,MATCH(Cats!AF1,$D$33:$D,0)), 1, 0)' formula from AN10 to AT10 (note for anyone who tries to do so, the Cats!AF1 should change in each one, it's hard to explain exactly)


hiii happy would you mind giving a better walkthrough on what to do here? i am having trouble understanding!
flower1a ginger bicolor cat pixela signpost on grassa ginger bicolor cat pixelflower2
i subscribe to threads ive posted, so no need to ping me in those!
Not-cat with a cream mackerel longhair coatbib & boots white markings uwu eyes.

CatyCrisis

Talokan

(she/her)

account age 7/9

Nov 24, 2022 0:52:57
I seem to be having trouble with the Parser page. Whenever I paste in the required information, the Parser Output has no data in it even though it was successfully doing it just last night. If there's any way to fix this on my end, please let me know!

Edit: I just ended up making a new copy of the spreadsheet and now it's working just fine :)
-- Last edited on Nov 27, 2022 21:45:19
Not-cat with a snow lynxpoint longhair coatno white markings sleepy eyes. White Butterfly SwarmRight Wine Dianthus Headpiece

saulot

Salubri

(he/they/it)

account age 8/9

Dec 15, 2022 3:16:27
If anyone else has a pronoun tie (mine are they/them and he/him), paste this into cell R14 on Stats page:
=JOIN(" or ",UNIQUE(FILTER(Cats!J:J,COUNTIF(Cats!J:J,Cats!J:J)=MAX(COUNTIF(Cats!J:J,Cats!J:J)))))
ᓚᘏᗢ
Not-cat with a snow broken longhair coatpiebald / C6 white markings left eyes. Ace Scarf

Luaii

Asteria Village

(any pronouns)

account age 7/9

Dec 24, 2022 21:48:39
The issue above happens for all of the average stats except for "Total Stats," "White Marks," "Personality," and "Wind."
A fix for this is adding:
JOIN(" or ",

right after the "=" in the code, but before everything else. ("White Marks" and "Personality" already have it, so don't add it to those)


It's also including the title above like "Color" and "Pronouns" and the like since it starts at row 1 rather than row 2. To fix this, just add 2 in front of the first letter in every set of 2. For example, for "Pattern," rather than being
=JOIN(" or ",UNIQUE(FILTER(Cats!W:W,COUNTIF(Cats!W:W,Cats!W:W)=MAX(COUNTIF(Cats!W:W,Cats!W:W)))))

it should be
=JOIN(" or ",UNIQUE(FILTER(Cats!W2:W,COUNTIF(Cats!W2:W,Cats!W2:W)=MAX(COUNTIF(Cats!W2:W,Cats!W2:W)))))


There's also an issue with the "Wind" average because I definitely have more trades than I do souths. I don't know why it's formatted differently than the others, and I'm not familiar enough with Google Sheets to figure out where it's going wrong, so I just stuck the same formula as the others onto it, which is:
=JOIN(" or ",UNIQUE(FILTER(Cats!K2:K,COUNTIF(Cats!K2:K,Cats!K2:K)=MAX(COUNTIF(Cats!K2:K,Cats!K2:K)))))


The code gets cut off from view on this post for some reason but if you highlight it, it should still be getting everything. And remember, don't change "Total Stats."
-- Last edited on Dec 24, 2022 22:00:15
Pixel Art KittyPixel Art KittyPixel Art KittyPixel Art Kitty
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?