A lot of people sell food in the forums. I looked for something like this, but the only things I found were overly large and cumbersome. So I couldn't sleep and I taught myself to code this.
To use this go to "File" and click "Make a Copy" or else you won't be able to use it. The main file is locked so only I can edit it (that way it stays how it's supposed to be and no one tries to pull a practical joke).
FOODPOINT CONVERTER LINK CLICK THIS
Anyways here's the gist of it.
Column A is the name of the food.
Column B is how many foodpoints each piece of food has.
Both of those should remain unchanged. Seriously don't touch them XD
Column C is how many you have.
Column D is how many food points of that item you have.
You should only EVER enter numbers in column C. D autofigures by itself.
Insects Row 118D, Meat Row 117D, Seafood Row 113D, and Plant Row117D are the total foodpoints you have.
Insect Row 121C is how much you charge per food point. This is the number you change (according to how much you charge) for figuring out how much networth in food you have.
There are two main ways to use this sheet.
1. You can use this tool SOLEY for when your selling. Make a copy and enter numbers in until you get the right amount based on what you have and sell the order. Then delete the copy and make a new one for each order (that way you don't have to erase everything)
Example: Bob buys 3421 Food points. Now you don't have to finnegle with a calculator. You just enter in what you have until you figure out the best way to achieve that number.
2. You can keep track of what you have in you hoard. Make a Copy and Title it something like "Hoard Food Point Tracker". This one you keep so you know what you're running short on. You won't delete this one, but keep it and update it.
Some things to know:
As of 6:04 PM EST on 9/15/2014 this sheet is correct.
I will update it when new food is added.
The first items on each sheet are from the coliseum. These items are listed in order of the areas in which they first appear. Since this is where you find most of your food to sell, they are first on the list. (Insect Row 36, Meat Row 49, Seafood Row 40, and Plant Row 40 are the last item(s) in the coliseum). The ones after that are rated by how many stars they have. I pulled the info from two guides which I'm crediting at the bottom.
You may notice some items are missing. There are two reasons for that.
1. I missed them. I'm human, it happens (or maybe I'm not human.)
2. They are expensive and I didn't list them as a gentle reminder that you don't want to sell those that cheap! No really!
Next post will be a log data to show when I've updated it. I'll also post when I do.
I used the following guides to make sure I had all the food in this tool
Maki's Text Only Coliseum Drops
JinxMagic Guide to Coliseum Drops
Azophel Gathering Reference Guide
@Nevele For giving me the idea
To use this go to "File" and click "Make a Copy" or else you won't be able to use it. The main file is locked so only I can edit it (that way it stays how it's supposed to be and no one tries to pull a practical joke).
FOODPOINT CONVERTER LINK CLICK THIS
Anyways here's the gist of it.
Column A is the name of the food.
Column B is how many foodpoints each piece of food has.
Both of those should remain unchanged. Seriously don't touch them XD
Column C is how many you have.
Column D is how many food points of that item you have.
You should only EVER enter numbers in column C. D autofigures by itself.
Insects Row 118D, Meat Row 117D, Seafood Row 113D, and Plant Row117D are the total foodpoints you have.
Insect Row 121C is how much you charge per food point. This is the number you change (according to how much you charge) for figuring out how much networth in food you have.
There are two main ways to use this sheet.
1. You can use this tool SOLEY for when your selling. Make a copy and enter numbers in until you get the right amount based on what you have and sell the order. Then delete the copy and make a new one for each order (that way you don't have to erase everything)
Example: Bob buys 3421 Food points. Now you don't have to finnegle with a calculator. You just enter in what you have until you figure out the best way to achieve that number.
2. You can keep track of what you have in you hoard. Make a Copy and Title it something like "Hoard Food Point Tracker". This one you keep so you know what you're running short on. You won't delete this one, but keep it and update it.
Some things to know:
As of 6:04 PM EST on 9/15/2014 this sheet is correct.
I will update it when new food is added.
The first items on each sheet are from the coliseum. These items are listed in order of the areas in which they first appear. Since this is where you find most of your food to sell, they are first on the list. (Insect Row 36, Meat Row 49, Seafood Row 40, and Plant Row 40 are the last item(s) in the coliseum). The ones after that are rated by how many stars they have. I pulled the info from two guides which I'm crediting at the bottom.
You may notice some items are missing. There are two reasons for that.
1. I missed them. I'm human, it happens (or maybe I'm not human.)
2. They are expensive and I didn't list them as a gentle reminder that you don't want to sell those that cheap! No really!
Next post will be a log data to show when I've updated it. I'll also post when I do.
I used the following guides to make sure I had all the food in this tool
Maki's Text Only Coliseum Drops
JinxMagic Guide to Coliseum Drops
Azophel Gathering Reference Guide
@Nevele For giving me the idea
