Back

Guides

Community created guides, helpful strategies, and more.
TOPIC | OLD AS DUNG Keep/Sell/Food spreadsheet
1 2 3 4 5 6
[u][b]---- Disclaimer added Feb 2018: this stuff is old and has been curated by random users over the years, I have no idea who necro'd this but seriously, this is not an up to date source and I am no longer working on this---- [/b][/u] Newbie here, I've been busy collecting, and at some point I noticed I wasn't sure what to keep, what to sell, and what to convert to food of all the stuff I found battling. This list was made with the data in the Swipp encycopledia entry, and with the species I've hunted so far myself. The sheet, open for all to edit, can be found here. [u][b] [url=https://docs.google.com/spreadsheets/d/1vUW3t_AXAOyDM72cpeZgGD1vQhk4Us5vEdTTSXEVdss/edit#gid=0]SHEET ALONG HERE LADS AND LASSES[/urL][/u][/b] To avoid excel messes and you're not sure how not to destroy it, if you want to sort, it'll be the easiest to copy the sheet into a file of your own. [u]Sortable on [/u] [b]Alphabetical item list[/b] Though a search should be easier to find what you want [b]Type:[/b] - Seafood, Plant, Meat, Insect - Apparel - Familiars - Material (coverts trinkets, materials, everything not the above) [b]What to do with it:[/b] - Save: Swipp uses these - Sell: Foodstuffs with a minimum 10T/food unit return - Food: Foodstuffs with a higher food yield than 10T/food unit [i](you can sort based on the ratio, too, this cutoff is just an arbitrary point)[/i] [b]Swipp trade availability[/b] - Simply sort on filtering out the x's [i]Listed are the number of items needed, and the kind of item that will be made. Don't forget to check if the same item made requires a second stash of resources, they usually do.[/i] [u][b]Information still missing: [/b][/u] Sell values for most of the materials Materials not listed in Swipp's Any Swipp trades not found in the encyclopedia (its preview image freakin' shows a trade that's not available now, ha) Should make a column for obsolete trades, too I hope this might be helpful to some of you, thought I'd share. [quote="Tips and Tricks"]Little amendment to make from a now more weathered coli-player: -FOOD SELLS QUITE WELL IN STACKS AT THE AUCTION HOUSE. If you ever find yourself having a good chunk of foodstuffs, sell it on the AH. Best way to go about this is to search for the food item, get an estimate of the best deal on the market, then sell your stuff for a fraction less per unit. You can expect roughly 100treasure per food unit, which is more than you'd get autoselling. It's slower and less reliable though, and not very handy for small amounts. -You can also sell 'useless' materials and 'other' type items from the hoard, though I'd recommend waiting until you have a stack of 99 with a new small stack. This way you won't get caught with your pants down when Crim asks. - If you have a food you only have one or two of, KEEP THEM AROUND, if Crim asks for them you'll make a nice easy buck :) - You can sell Swipp items in stacks if you're not interested in the trade. Very very rare items (like platinum ore or the cobras) I've given up on collecting, but selling a single one on the AH can make me over 10k treasure :) This is how I've been making a nice buck so far, though others prefer to 100% hoard everything. My method is my preferred balance between making quick money but not having my hoard bare. [/quote]
---- Disclaimer added Feb 2018: this stuff is old and has been curated by random users over the years, I have no idea who necro'd this but seriously, this is not an up to date source and I am no longer working on this----


Newbie here, I've been busy collecting, and at some point I noticed I wasn't sure what to keep, what to sell, and what to convert to food of all the stuff I found battling.

This list was made with the data in the Swipp encycopledia entry, and with the species I've hunted so far myself.

The sheet, open for all to edit, can be found here.

SHEET ALONG HERE LADS AND LASSES


To avoid excel messes and you're not sure how not to destroy it, if you want to sort, it'll be the easiest to copy the sheet into a file of your own.

Sortable on

Alphabetical item list
Though a search should be easier to find what you want

Type:
- Seafood, Plant, Meat, Insect
- Apparel
- Familiars
- Material (coverts trinkets, materials, everything not the above)

What to do with it:
- Save: Swipp uses these
- Sell: Foodstuffs with a minimum 10T/food unit return
- Food: Foodstuffs with a higher food yield than 10T/food unit
(you can sort based on the ratio, too, this cutoff is just an arbitrary point)

Swipp trade availability
- Simply sort on filtering out the x's
Listed are the number of items needed, and the kind of item that will be made.
Don't forget to check if the same item made requires a second stash of resources, they usually do.


Information still missing:
Sell values for most of the materials
Materials not listed in Swipp's
Any Swipp trades not found in the encyclopedia (its preview image freakin' shows a trade that's not available now, ha)
Should make a column for obsolete trades, too


I hope this might be helpful to some of you, thought I'd share.
Tips and Tricks wrote:
Little amendment to make from a now more weathered coli-player:

-FOOD SELLS QUITE WELL IN STACKS AT THE AUCTION HOUSE. If you ever find yourself having a good chunk of foodstuffs, sell it on the AH. Best way to go about this is to search for the food item, get an estimate of the best deal on the market, then sell your stuff for a fraction less per unit. You can expect roughly 100treasure per food unit, which is more than you'd get autoselling. It's slower and less reliable though, and not very handy for small amounts.

-You can also sell 'useless' materials and 'other' type items from the hoard, though I'd recommend waiting until you have a stack of 99 with a new small stack. This way you won't get caught with your pants down when Crim asks.

- If you have a food you only have one or two of, KEEP THEM AROUND, if Crim asks for them you'll make a nice easy buck :)

- You can sell Swipp items in stacks if you're not interested in the trade. Very very rare items (like platinum ore or the cobras) I've given up on collecting, but selling a single one on the AH can make me over 10k treasure :)

This is how I've been making a nice buck so far, though others prefer to 100% hoard everything. My method is my preferred balance between making quick money but not having my hoard bare.
~Reflect Achievement Guide~
~EE trainer, ping for levelling and raising help~
Thank you so much! :o this is really helpful!
Thank you so much! :o this is really helpful!
~✿~ I'd put bunnies here if I knew how to ~✿~
This is great!
This is great!
bump
bump
IJJc6Sg.png 6I84XUY.gif wXPzM1Z.gif
Been slowly adding what I can to this spreadsheet, I use this thing all the time I love it.
Been slowly adding what I can to this spreadsheet, I use this thing all the time I love it.
I've been meaning to put something like this together for ages, thank you so much for sharing!
I've been meaning to put something like this together for ages, thank you so much for sharing!
tumblr_n69vu8VRkE1t0ibwro9_250.gif
Thank you for this guide, it's very helpful!!
I was wondering how do you find out whether food gives a minimum 10T/food unit return?
Thank you for this guide, it's very helpful!!
I was wondering how do you find out whether food gives a minimum 10T/food unit return?
@raru Check the item's information, there's a sell value and then the amount of food points it has. Divide them (Sell Price #/Food Point #), if your number if 10 or higher you should sell it. If it's lower than it should be used for food. So generally food items that have a sell price of 15t/2 food points are used for food, same with 25t/3 food.
@raru Check the item's information, there's a sell value and then the amount of food points it has. Divide them (Sell Price #/Food Point #), if your number if 10 or higher you should sell it. If it's lower than it should be used for food. So generally food items that have a sell price of 15t/2 food points are used for food, same with 25t/3 food.
@bwee thank you so much!!
@bwee thank you so much!!
@graficcha @bwee

What a great reference tool!

I was stressed out today and meddling with spreadsheets is super-soothing, so I spent a couple of hours double-checking information and adding formulas. I created a changelog sheet as well, to record my edits so you can find/undo them quickly if necessary.

I'll probably keep updating and adding info to this for a while.
@graficcha @bwee

What a great reference tool!

I was stressed out today and meddling with spreadsheets is super-soothing, so I spent a couple of hours double-checking information and adding formulas. I created a changelog sheet as well, to record my edits so you can find/undo them quickly if necessary.

I'll probably keep updating and adding info to this for a while.
1 2 3 4 5 6