Thank you so much!



@AliciaJewel It looks like your cat's info is on several rows instead of all in one cell!



This is how it should look if you put it all in one cell. Double-click into the cell so your cursor is there and then paste the info from your not-cat's profile, it should all stick to one cell then!

Thank you Aurora! Yes, that is how it should be done :3

Double-clicking did the trick! Thanks a ton, @Aurora!

New Luncheons + Minor Bug Fixes
version 2.2.1

Our new luncheons have been added!

The job value number offset bug remains for now until I have more energy to look into it.

Changes are spread across quite a few sheets, and I would recommend transferring your cats over, but I'll detail how to translate your sheet below.






New:

• All new luncheons (Leaf Day and generic)
  
• Ability to search for Leaf Day material luncheons

Bugfix:

• +4 trinkets can now properly be set on the Trinkets Owned tab
  
• Luncheon calculations for very small villages now include a minimum ingredient consumption of 1, rather than 0
  
• Movement boosts from luncheons can now be properly filtered for

If you know what you're doing, here's how to bring your sheet up to date.

1. Make a copy of the new blank sheet
   
   
2. On your old sheet, click on the tab list menu down by the tabs. You will see three greyed-out (hidden) tabs named Luncheon Ingredients, Luncheons, and Ingredients. Click each of these to unhide them.
   
   
3. Rename the Luncheons tab to Luncheon Powers and rename the Ingredients tab to Individual Ingredients. Make sure to do this rename **BEFORE** beginning the next step.
   
   
4. On the new sheet copy, unhide these same three tabs (they'll have the new names) and click the dropdown, select Copy to > Existing spreadsheet, and select your old current sheet for each of them.
   
   
5. For each of these three tabs, on the copied-over tabs, use CTRL+A (select all) and then CTRL+C (copy). Go to its respective original, non-copied tab and use CTRL+A (select all) and then CTRL+P (paste).
   
   
6. Delete the copied tabs and hide the original three tabs again.
   
   
7. On the new sheet, go to the Luncheon Helper tab itself and select cell L3. Select CTRL+A (select all) and copy it.
   
   
8. In the same cell on your own sheet, delete everything in there and replace it with the copied code.
   
   
9. Unhide a tab named Data Validations.
   
   
10. In column B, in the cell under the 3, enter the number 4. You can now hide this tab again, and you're done!
    

@Gathouria I've been trying to update my sheet but my L3 Cell kept throwing an error and I'm unsure why. I followed the steps precisely I thought, and even went through everything twice. I'm out of spoons for this so I reverted the changes on my sheet and am going to take you up on your kind offer to transfer. What's the easiest way to send you our sheet, through private message?

@Gathouria I also seem to be having the issue where the Best per Individual and Job tabs won't account for job levels (for example, Elver is supposed to have +5 to Hunter but only has +3 on the sheet despite being a Level 3 Hunter). [Sheet link redacted]

@Aurora private message with an editor's link works! Just make sure you enable editing for the link when you go to share it through the Share button (top right of page)

@AliciaJewel It seems to me like the issue here is the weather- the current weather you've marked for today will automatically subtract 2 from all outdoor jobs. That would cause Elver to be +5 naturally (level 3 Hunter and +3 from AGI, without any trinkets) which would end up in +3 overall due to weather. I'm currently seeing Elver as a +2 however and not the +3 you noted- did you mean +2? Because a +2 would in fact be a bug, because I don't see any reason that would happen.

@Gathouria

Weird, I'm not getting a +2 on Hunter for Elver anywhere... And doubly weird, it's at +3 without the weather penalty, +1 with it.

@AliciaJewel that definitely sounds like a jobs level issue then- would you mind sending me an editor link via PM? I'll take a look and see if I can fix it!

Job Levels Bug Fix
version 2.2.2

Finally found the issue here! And it's a pretty quick fix. While you could still manually transfer your cats, trinkets, etc, here's how to update your current sheet, which should be much quicker:

• Click on the the menu icon to the left of your list of sheet tabs and select the grey-out (hidden) tab named Workers
  
  
• In this tab, select the cell A3 and press delete to remove the current code there
  
  
• Double-click A3 to start code editing on this cell, and paste this new code in there:

• Hit enter to confirm the code change
  
  
• Click the little arrow menu on this tab, down in the tab list, and select "Hide sheet"
  

And you're good to go!