|
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

Dec 26, 2022 18:01:18
Seems that the parser is designed around a certain amount of jobs and adventuring classes. Might need a form to the side to set amount of jobs, classes, etc?
Oh that was pointed out already

Another thing is the average wind in the stats tab. Trade would almost definitely be discarded incorrectly as it totals the number of Standards (N+S+O) against Trade. I changed it to
=IF(I5=MAX(I5:I8),"North", IF(I6=MAX(I5:I8),"South", IF(I7=MAX(I5:I8),"Trade", "Null")))
-- Last edited on Dec 26, 2022 19:04:26
Not-cat with a aprico lynxpoint longhair coatsnow lynxpoint trade markingslocket white markings danger eyes. Gold Feather AnkletsYellow Wildflower Crown

Wlwyvern

Cathartid

(any pronouns)

account age 7/9

Jan 1, 2023 22:49:49
I wanted to be able to see how many cats had any given job in their top 3, so I added some code for that. It's not as pretty as @remus did, but I think it should at least function. I put it in a new tab called "my work" so it wouldn't mess with the existing code. This is useful for knowing if you have an overabundance of cats with skill in the same job, so you can send the weak links traveling flames
Also so that you can seek out cats with skills you don't have enough of in your village , I guess...

I also added that code to the parser, which lets it handle the adventuring levels without getting all scrambled up. It seems to be working so I guess I did it right? If anyone's reading this and doesn't want to input that code themself, you can make a copy of my sheet instead, til the main one gets updated feels
Link to my sheet
-- Last edited on Jan 1, 2023 22:50:44
Not-cat with a snow cloudpoint longhair coatpiebald / C6 white markings left eyes. Amethyst Glitterdust

icar0s

Regolith

(he/him)

account age 6/9

Jun 25, 2023 2:41:01
oh my god this is AMAZING thank you so much!! cryingfeels how long did this take to code? it's seriously impressive. wish i had one of these for every game now LMAO
-- Last edited on Jun 25, 2023 3:03:36
Not-cat with a buff mink shorthair coatcream mink trade markingslocket white markings uwu eyes. Light RapierRight Maroon Fantail Pigeon FriendSilver Tail RingsaaaaaaaaaaLight Left Eye Scar

huntingforasoul

Namu

(they/she)

account age 8/9

Jul 30, 2023 5:08:56
I absolutely adore this spreadsheet! I actually edited the current version to hopefully help others out.

Updated Spreadsheet!

This one has everything the other version has with the following changes:
  • Average wind code updated (thank you @/Anonymously for the code!)
  • The Parser section can handle adventuring levels (thank you @/Wlwyvern for the code!)
  • Student occupation added
  • Born in Gardenhome City origin added
  • New categorization of whites added (ex: "Locket / C1" instead of just "Locket")
  • All new white markings added
  • Numbers in the Cats sections have been adjusted so there isn't an extra 53
  • Edited Instructions so it makes more sense
  • ★NEW★ Put a percentage sheet to better see the spread of each type of cat


Thank you for this incredible spreadsheet (and for the additional help in the forum)!! feels redheart
-- Last edited on Aug 13, 2023 4:27:13
https://i.postimg.cc/jWqxbH4C/Street-silly-doodle.png
★ ⭒ ⭒ ⭒ ⭒ ⭒ ⭒ ⭒ ⭒ ⭒ ⭒ ⭒ My Art ⭒ ⭒ ⭒ ⭒ ⭒ ⭒ ⭒ ⭒ ⭒ ⭒ ⭒ ★

https://i.postimg.cc/sfcDM9pK/Little-ghost-border.pnghttps://i.postimg.cc/sfcDM9pK/Little-ghost-border.pnghttps://i.postimg.cc/sfcDM9pK/Little-ghost-border.png
https://i.postimg.cc/jWqxbH4C/Street-silly-doodle.png
Not-cat with a albino  shorthair coatalbino / C10 white markings content eyes. Uncut Rose Quartz AnkletsPastel Tie-Dye Head WrapHeart Bubble

DovieCaba

Dovie's Coop

account age 6/9

Aug 12, 2023 11:28:10
@Remus and @huntingforasoul Thank you so much for making this available!
I just joined and having all my cat's info in one place is priceless. cryinghug
Not-cat with a almond clouded shorthair coatbeige clouded trade markingslocket & toes white markings left eyes. Blue Wildflower CrownRight Maroon Fantail Pigeon FriendMaroon Fantail Pigeon on TailHeavy Red Wool Scarf

Zmrrok

Sundown

(she/her)

account age 6/9

Sep 16, 2023 6:22:37
thank you so much for your efforts, all of you!! I came here and wanted to point out the issues, like with multiple classes levels and slightly confusing manual, but it's all taken care of, you're amazing <3
Not-cat with a charc spotted longhair coatgrey spotted trade markingsbib, boots, & belly / C4 white markings squint eyes. Gold Feather TailpieceBlue Wildflower CrownGold Feather Anklets

Perrio

Slate

(he/him)

account age 6/9

Nov 16, 2023 15:36:01
Experiencing an error on the Stats page, X9
Screenshot displaying an error on the google sheet, saying "Array result was not expanded because it would overwrite data in X10."
animated sparkle gif cat time -1hr | registered wolfaboo | ping me!! | queer-platonically married to axoloam animated sparkle gif
animated gif of a wolf running animated gif of a wolf running animated gif of a wolf running animated gif of a wolf running
Not-cat with a charc spotted longhair coatgrey spotted trade markingsbib, boots, & belly / C4 white markings squint eyes. Gold Feather TailpieceBlue Wildflower CrownGold Feather Anklets

Perrio

Slate

(he/him)

account age 6/9

Nov 16, 2023 15:42:51
Resolved itself after adding more cats. Not sure what caused it... hrm
animated sparkle gif cat time -1hr | registered wolfaboo | ping me!! | queer-platonically married to axoloam animated sparkle gif
animated gif of a wolf running animated gif of a wolf running animated gif of a wolf running animated gif of a wolf running
Not-cat with a charc spotted longhair coatgrey spotted trade markingsbib, boots, & belly / C4 white markings squint eyes. Gold Feather TailpieceBlue Wildflower CrownGold Feather Anklets

Perrio

Slate

(he/him)

account age 6/9

Nov 17, 2023 0:53:17
Screenshot displaying an error on the google sheet, saying "Array result was not expanded because it would overwrite data in X8."
Baw shucks. Did all the cats in my village and it returns :P Black and ginger are tied for top, maybe it's gotta do with that.
Edit: Fixed by adding JOIN(" or ", to the start of the formulas
-- Last edited on Nov 17, 2023 0:56:03
animated sparkle gif cat time -1hr | registered wolfaboo | ping me!! | queer-platonically married to axoloam animated sparkle gif
animated gif of a wolf running animated gif of a wolf running animated gif of a wolf running animated gif of a wolf running
Not-cat with a black solid longhair coatno white markings squint eyes. Square SunglassesSilver Firefly Buddies

Gannayev

Oasis

(she/they)

account age 5/9

Dec 13, 2023 16:17:30
I don't use google sheets enough to know, but every attempt I've made with this hasn't worked at all. Lots of references that don't exist? Also the sheet says to copy K9 to BO9 for the output, but the actual boxes on the parser output section are J10 to BN10 so I'm confused.

EDIT: Pasting as values only seemed to fix it

EDIT 2: Nevermind, it's returning things that should not be in those boxes, sheet's broke.
-- Last edited on Dec 13, 2023 16:30:37
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?