So there's this spreadsheet, yeah? that needs data.
you could even have that data, just lying around.
It can make pretty charts that tell you what a job can give you, like so:



The sheet determines what items and in what quantity one can expect for a job dependent on the roll, for both adults, young kittens, and kittens. You can check it out here and submit data for it here.

Screenshots are also accepted, if you can't use or prefer not to use the form! These would require images that include a not-cat's job results, in which the name of the job that was performed, the number that was rolled, all of the item results, and all of the quantities of these item results are visible.

I have no place to upload screenshots to, so directly it is:

Luncheon - Warm Stew

Weather: incredibly windy (-2 for outdoors)

Gatherer 1: levelled up, skill +5 (new +6), result 6, 3x , 1x
Gatherer 2: skill -1, result 9, 1x, 1x
Hunter: skill +0, Result 17, 2x, 1x, 1x
Builder: skill +1, result 8, 2x
Mason: skill +2, result 7, 2x
Bug Catcher: skill -1, result 8, 3x , 1x
Fisher: skill +4, result 7, 1x, 1x
Miner 1: skill 4, result 12, 2x , 1x
Miner 2: skill 0, result 12, 2x , 1x

@Yanisha Thank you for the data!!

Once I get this next bit ironed out with the sheet (so that the ranges probably show whether x0 of an amount is a possible option for an item at that roll as well, so you know it can be possible but not guaranteed), then I'll make up a form for data submission to hopefully make it easier for submission!

Rough preview of what the charts are going to look like, though obviously it will become more filled out and the formatting will become a bit more sophisticated:

Spreadsheet and form link are now in the thread! Go crazy, y'all.

Major layout change, and the sheet should be a bit zippier now~ There's images!

Change to the data input! It is now much simpler. The only things you are required to submit is the job name, the actual roll, and the items+quantities you received.

(Moving over to the proper thread lol)


Nah I've got it, I can use spreadsheet QUERY()s to pull what's needed!

So that I know how to treat the data, did you record every job+return from your cats each day, or only unique returns? I've been playing with calculating the chances of getting each item and can only use complete data for that portion of the calc, so want to know if this can be used, too!

@Scythe (because I'm not sure if a quote pings )

ok here now,


i recorded every item, every quantity, every job, every roll, every day

and its grouped each line is a unique "work" event

eg

farmer, 1st item, amount &id, 2nd item, amount & id, ect

tried too remove any bias i could (also data is collected from 2 people for a month or 2 now)