|
site banner: a black cat running through the woods; the weather is rain
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 | [Spreadsheet] Job-Centric Item Search Tool

Not-cat with a charc solid longhair coatbuff solid trade markingsno white markings uwu eyes. Orange GlitterdustCrown of ThymeObsidian SmokeTiger Lily CrownParsley GarlandTiger Lily Necklace

Gathouria

Skyclan

(no pronouns)

account age 8/9

May 28, 2022 0:01:25
Ever wanted to see, at a glance, what your cat could be bringing back from their daily job, and how likely it was? Or maybe every single use you could ever find for Chamomile?

Well, here's a spreadsheet!

This sheet is OPTIONALLY image heavy.
Each image-heavy tab has an image load on/off switch with a count of total tab images listed next to it.
You can also narrow your search options before turning it on for a lower image count!




What's on the sheet:

  • Search tabs: Currently, there are four tabs for searching through items in a variety of ways.

    1. Resources - Search materials used on their name and/or item ID name, the season they're obtained in, the luncheon they're used in, or the craftable they're used in!

    2. Luncheons - Search the different Luncheons based on a dynamically updating dropdown list, sorted in buffs-given ordering. Check off each buff you want a meal to be giving to narrow down the dropdown list! This search will return all the resources used in the Luncheon(s).

    3. Craftables - Search for Craftables and check the materials they need based on the crafting discipline, item name, item type, or a variety of identifying tags that I've included for each and every craftable there is. These tags are the general item set, form, size, color, material, and detail and/or effect of the item. Since there are a lot of identifying tags, these dropdowns will dynamically narrow their options as you select other search terms.

    4. Not-Craftables - Search for items that can be obtained via daily jobs, social interactions, or gifted by Nestor! These can all be sorted by season they can be obtained and by the same options as Craftables, where the crafting discipline search is instead replaced by the method(s) the item is obtained by.


  • Luncheon Details tab: This tab is pretty basic, but handy! It lists all Luncheons, their buffs (both stat-wise and adventuring, for when that becomes useful), and their required resources. This is an at-a-glance view version of the Luncheon searching tab, and lets you view the recipe as a whole! This tab is currently located behind the daily jobs tabs.

  • Daily Job tabs: Each daily job has its own tab which displays the following:

    1. Requisites - At the top of each tab, the associated stat, personality trait, location (indoor/outdoor), and materials required to perform are listed. Each job tab will also be color-coded dependent on the location in which it takes place, to help make decisions based on weather conditions.

    2. Items - Each item that a job could provide is listed and gives the item ID, item number, image, name, rarity of occurrence, item type, seasons it may be collected in, the cost of sale/purchase via NPCs, and what jobs may require it as a material to perform. Currently, all Resource, Clothing, Decor, Trinket, and Collectable items are listed.

    3. Search options - These tabs allow you to display items based on their item type. If you would, say, only like to view the resources you could get, or maybe just the clothing items, you can turn off the checkboxes in the top right corner for the other item types!

      Additionally, items can be filtered by season by going to the top options bar on Google Sheets and selecting Data > Filter Views and selecting a seasonal filter view.


I love feedback! Let me know if you have any ease of use suggestions especially, or what else you might like to see on the sheet! feels

Now go get those items
-- Last edited on Aug 6, 2022 22:42:26
Not-cat with a charc solid longhair coatbuff solid trade markingsno white markings uwu eyes. Orange GlitterdustCrown of ThymeObsidian SmokeTiger Lily CrownParsley GarlandTiger Lily Necklace

Gathouria

Skyclan

(no pronouns)

account age 8/9

Jun 24, 2022 4:07:31
The option to search for items based on the craftable that they're used in is now implemented!

You can now get results that show you just legitimately every single thing there is to know about an item at once.

Searching craftable items for "apothecary's" in order to bring up the ingredients for the two Apothecary's Workstations

scrolling sideways:

Sideways scroll for the same search as above
Not-cat with a charc solid longhair coatbuff solid trade markingsno white markings uwu eyes. Orange GlitterdustCrown of ThymeObsidian SmokeTiger Lily CrownParsley GarlandTiger Lily Necklace

Gathouria

Skyclan

(no pronouns)

account age 8/9

Jun 24, 2022 4:59:48
Additional update: the Not-Craftables search tab is also now up and running! It works similarly to the Craftables search tab.
Not-cat with a charc solid longhair coatbuff solid trade markingsno white markings uwu eyes. Orange GlitterdustCrown of ThymeObsidian SmokeTiger Lily CrownParsley GarlandTiger Lily Necklace

Gathouria

Skyclan

(no pronouns)

account age 8/9

Aug 6, 2022 22:41:04
Update: A bug fix and a new search option!

  • Fixed a long-standing bug I just realized was hanging around in which users could not change the search type on the resource search tab.

  • Resources and non-craftables can now be searched for by season by marking off the associated checkbox in addition to the currently existing single season filters views.
Not-cat with a albino  longhair coatalbino / C10 white markings uwu eyes. Unnatural Emerald PendantDark ScytheDark Noodle HatGold Worm on Head

Scythe

Ace-ylum

(bat/ae/she)

account age 8/9

Sep 12, 2022 0:46:32
just wanted to let ya know that the spreadsheet shows any of the 3 varieties of leaves as requirements for "flock heard" work, this should (as of current) only be "Large Leaves #271" (summer, spring variety)
other than that one thing that I noticed on my 2nd month of using this spreadsheet at least biweekly

sparklesTHIS SPREADSHEET IS AMAZING, THANKYOUUUUsparkles

(on a side note, absolutely 0 pressure you wanted to collaborate and add more data to your amazing sheet, I am collecting data on the quantity of items when cats work, and its was an ambition too eventually work the findings into a useful sheet)
ill update this with links soon
Not-cat with a charc solid longhair coatbuff solid trade markingsno white markings uwu eyes. Orange GlitterdustCrown of ThymeObsidian SmokeTiger Lily CrownParsley GarlandTiger Lily Necklace

Gathouria

Skyclan

(no pronouns)

account age 8/9

Sep 12, 2022 1:46:17
Corrected the issues with the leaves! Thank you for pointing that out! :D

I'm so glad to hear that someone else finds the sheet useful! I wasn't sure if I was the only one using it lol

Scythe said
(on a side note, absolutely 0 pressure you wanted to collaborate and add more data to your amazing sheet, I am collecting data on the quantity of items when cats work, and its was an ambition too eventually work the findings into a useful sheet)

I would love to do a collab! Though I have to ask.. is the data you're collecting the same as I've been collecting here? thonk

That spreadsheet has gotten a little unwieldly with how much data it's chugging on at any one time (so much so that I actually now have three spreadsheets reading from each other to reduce what any one sheet has to do!) and definitely needs some more love to make it break less. But I've been recording my data daily with it for months and there's a ton there! As well as some helpful publicly submitted info.

If what we're doing is the same, we could look at merging our work!
Not-cat with a albino  longhair coatalbino / C10 white markings uwu eyes. Unnatural Emerald PendantDark ScytheDark Noodle HatGold Worm on Head

Scythe

Ace-ylum

(bat/ae/she)

account age 8/9

Sep 12, 2022 4:19:00
it is, tho its in the raw form
ill update this with links soon
Not-cat with a albino  longhair coatalbino / C10 white markings uwu eyes. Unnatural Emerald PendantDark ScytheDark Noodle HatGold Worm on Head

Scythe

Ace-ylum

(bat/ae/she)

account age 8/9

Sep 12, 2022 4:21:24
would be very keen to merge the data and help complete your sheet

another interesting thing is that the quantity of product seems too be liener with the roll, so that may help add data to the ideal jobs sheet

(i will update my dataset and throw it your way)

what format works best with input to your sheet? or is it more manual? (currently i use unquoted CSV, without feild names, which can be input into most database veiwing software)



edit-
just looked at your data input form, i have over 1000 datapoints, so direct input will be the best way for everyone's sanity ^-^
-- Last edited on Sep 12, 2022 4:26:42
ill update this with links soon
Not-cat with a charc solid longhair coatbuff solid trade markingsno white markings uwu eyes. Orange GlitterdustCrown of ThymeObsidian SmokeTiger Lily CrownParsley GarlandTiger Lily Necklace

Gathouria

Skyclan

(no pronouns)

account age 8/9

Sep 12, 2022 5:01:01
Scythe said
edit-
just looked at your data input form, i have over 1000 datapoints, so direct input will be the best way for everyone's sanity ^-^


Direct would be best, yes lol. If your most up-to-date data is the .csv currently linked in your thread, I can pull that data in directly!
Not-cat with a albino  longhair coatalbino / C10 white markings uwu eyes. Unnatural Emerald PendantDark ScytheDark Noodle HatGold Worm on Head

Scythe

Ace-ylum

(bat/ae/she)

account age 8/9

Sep 12, 2022 5:04:17
i am in the process of updating atm
the most recent one should be dated *today* (waus), so 120922


(just tested, should be done now)
-- Last edited on Sep 12, 2022 5:04:48
ill update this with links soon
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?