Spreadsheet: 250191d1373864106-condition-formatting-for-a-negative-number-considers-it-still-positive-wow-characters
Sheet: Farm

Item | Lansalot | Fenben | [NAME] | Cainine | [NAME] | Shivme | Goblinsux | Brujae | Soulhunter | Mookitty | Pandatears | TOTAL |  | Bank | needed? |  | Each page listed below's name is set to the farm page and they should be updated, NOT the farm page since it will be automated. If you change the name at the bottom for the page by right clicking the page and renaming it, the formula will adjust for the materials needed but the name at the very top will not change. This will need to be done manually so the names and column O for bank are the only fields that should be touched on this first page.  The last page for pandatears is the most updated page and should be how many materials you will need for 1 character to [NAME] out all 6 cooking skills to 600. This page is also larger than the others so I made drop down tabs for each one of the 6 cooking types. To use this data for a new page, click the turn page icon at top left above 1 and left of A and copy the whole page. Go to the new page and paste it to use this template. The 0's in the farm field means 0 are needed. Blue is showing that there is something needed for the person. Red is shown in total column as this is the total number of the item needed for all your characters. If you have materials stored in bags or bank, add them into the bank tab and it will tell you how many more you need. If negative, you should have an overstock.I would hold onto them until the end just in case my calculations are off. This assumes you are at 525 using only these abilities to gain skill. I hope this beta test program helps. It has not been fully tested so use at your own risk. -[EMAIL]
100 year soy sauce |  |  |  |  |  |  |  |  |  |  |  |  |  | 27
Black Peper |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
Emperor [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | 218
Giant Mantis Shrimp |  |  |  |  |  |  |  |  |  |  |  |  |  | 151
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Golden Carp |  |  |  |  |  |  |  |  |  |  |  |  |  | 213
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | 962
Jade Lungfish |  |  |  |  |  |  |  |  |  |  |  |  |  | 91
Jade Squash |  |  |  |  |  |  |  |  |  |  |  |  |  | 706
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | 505
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | 16
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | 935
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Pink Turnips |  |  |  |  |  |  |  |  |  |  |  |  |  | 917
Raw Crab Meat |  |  |  |  |  |  |  |  |  |  |  |  |  | 29
Raw Crocolisk Belly |  |  |  |  |  |  |  |  |  |  |  |  |  | 7
Raw Tiger Steak |  |  |  |  |  |  |  |  |  |  |  |  |  | 23
Raw Turtle Meat |  |  |  |  |  |  |  |  |  |  |  |  |  | 83
Red [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | 116
Redbelly Mandarin |  |  |  |  |  |  |  |  |  |  |  |  |  | 204
Reef Octopus |  |  |  |  |  |  |  |  |  |  |  |  |  | 343
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Scallions |  |  |  |  |  |  |  |  |  |  |  |  |  | 75
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | 420
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | 16
White Turnip |  |  |  |  |  |  |  |  |  |  |  |  |  | 991
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | 118
Witchberries |  |  |  |  |  |  |  |  |  |  |  |  |  | 1069
Created by Fenben of Zangermarsh ([EMAIL])