Last night I decided that something must be done about the ever accumulating pile of mission loot that was accumulating in my current home station. Most of the stuff is complete junk, worthless tech 1 modules that no-one wants to buy. Hidden in among the dross however are a few pearls, individual modules and components worth millions. Sorting the pearls from the dross is not an easy job sadly.
Anyway after some thought I eventually came up with a "method"which automates the job to some extent. It is not completely painless but it does speed things up considerably.
Step 1: Invest in some Giant Secure containers. Give them helpful names and use them to do an initial sort of your stuff. I have Ammo, Fittings (stuff that I will probably use myself ), Tags and Loot. Sort the stuff you want to keep into the relevant containers and put all the stuff you want to convert into ISK into "loot". Giant secure containers really are one of the most useful things in EVE. Even if you never have loot to sell I recommend using them for housekeeping and they come with the added advantage of being bigger inside than out so you can stuff your haulers with them for an extra 30% space .
Step 2: Download and install a programme called jEveAssets. You will need to setup an api key to allow this to read your assets but it will then produce a list of every single thing you own in EVE.
Step 2:Use the update button to read in all of your assets into JEve. WARNING - there is a long cooldown on this function (I assume this is to prevent overloading the server) so only do this after you have already have sorted everything as best you can within EVE or you will need to wait several hours to try again.
Step 3:The list is intimidating at first but it is easy to filter. Look for something you know is stored in your loot container and check the name of the container: It will be something like "Giant Secure Container #############". Copy this label into the paste buffer (right click and copy)and then paste it into the filter box (I use a filter "And", "All", "Contains" "Giant Secure Container ##########") and bingo you are left with just the items in your loot container. Have a quick glance to ensure it is the correct selection.
Step 4: Under the file menu click "Export to CSV"and export the "current filter"to a file of your choosing.
Step 5:Open that file in your spreadsheet of choice (I use Excel).
Step 6: You can hide any columns you don't need. I hide everything except Name, Reprocessed Value, Value, Count.
Step 7. Now decide on a rule which will determine which items are worth trying to sell and which can be reprocessed into minerals. Use an appropriate excel formula to tag these items in an empty right hand column (the "sell or not" column). For example if you want to sell anything whose sale value is greater than its reprocessed value and which is also worth more than 100k then use a formula as follows:
IF(AND(P2>O2, P2>100000),"SELL","")
Where P2 is the value of the first item and O2 is the reprocessed value of the first item. Copy this formula down the whole column to flag items for sale.
Step 8: Use the Data - Sort function to sort the table by the "sell or not" column. I recommend using a second sort criteria to sort alphabetically by name.
Step 9. Now in EVE sort your loot container by name and use the alphabetically ordered list of sell items to pull those items for sale to another location (another container perhaps or the hold of a ship).
Step 10. What ever is left can be reprocessed in one fell swoop. You might want to manually weed out low value items items which have no reprocessed value (salvage loot for example).
Step 11:Load up a hauler with your loot and ore and head to the nearest market to sell it. Normal hauling precautions apply of course. If you are feeling lazy you could try a courier contract.
Remember it is a hell of a lot easier to sell ore than it is to sell modules so for an easy time you might want to bias your selection in favour of reprocessing. For example you could change the formula to
IF(AND(P2>1.2*O2, P2>100000),"SELL","") to only sell items that are worth 20% more than their reprocessed value. Don't forget however that you will also take a hit on the reprocessing unless you have the appropriate skills trained. My untrained reprocessing percentage is only 87% so I take that into account when deciding to reprocess or not.
Edit: If you are not sure how to reprocess just drag the stuff to your hangar storage (Items tab). Highlight the stuff you want to reprocess right click and select reprocess. Warning - make sure you didn't highlight anything you want to keep. If your yield is less than 87% you need to find a better station. There is also a small fee but if you have been running missions for the station faction then it will probably be small. More information about re-processing here:http://wiki.eveonline.com/en/wiki/Reprocessing
For more general advice about selling loot look here: http://eveatoz.blogspot.com/2010/11/how-to-make-most-isk-from-your-loot.html
Anyway after some thought I eventually came up with a "method"which automates the job to some extent. It is not completely painless but it does speed things up considerably.
Step 1: Invest in some Giant Secure containers. Give them helpful names and use them to do an initial sort of your stuff. I have Ammo, Fittings (stuff that I will probably use myself ), Tags and Loot. Sort the stuff you want to keep into the relevant containers and put all the stuff you want to convert into ISK into "loot". Giant secure containers really are one of the most useful things in EVE. Even if you never have loot to sell I recommend using them for housekeeping and they come with the added advantage of being bigger inside than out so you can stuff your haulers with them for an extra 30% space .
Step 2: Download and install a programme called jEveAssets. You will need to setup an api key to allow this to read your assets but it will then produce a list of every single thing you own in EVE.
Step 2:Use the update button to read in all of your assets into JEve. WARNING - there is a long cooldown on this function (I assume this is to prevent overloading the server) so only do this after you have already have sorted everything as best you can within EVE or you will need to wait several hours to try again.
Step 3:The list is intimidating at first but it is easy to filter. Look for something you know is stored in your loot container and check the name of the container: It will be something like "Giant Secure Container #############". Copy this label into the paste buffer (right click and copy)and then paste it into the filter box (I use a filter "And", "All", "Contains" "Giant Secure Container ##########") and bingo you are left with just the items in your loot container. Have a quick glance to ensure it is the correct selection.
Step 4: Under the file menu click "Export to CSV"and export the "current filter"to a file of your choosing.
Step 5:Open that file in your spreadsheet of choice (I use Excel).
Step 6: You can hide any columns you don't need. I hide everything except Name, Reprocessed Value, Value, Count.
Step 7. Now decide on a rule which will determine which items are worth trying to sell and which can be reprocessed into minerals. Use an appropriate excel formula to tag these items in an empty right hand column (the "sell or not" column). For example if you want to sell anything whose sale value is greater than its reprocessed value and which is also worth more than 100k then use a formula as follows:
IF(AND(P2>O2, P2>100000),"SELL","")
Where P2 is the value of the first item and O2 is the reprocessed value of the first item. Copy this formula down the whole column to flag items for sale.
Step 8: Use the Data - Sort function to sort the table by the "sell or not" column. I recommend using a second sort criteria to sort alphabetically by name.
Step 9. Now in EVE sort your loot container by name and use the alphabetically ordered list of sell items to pull those items for sale to another location (another container perhaps or the hold of a ship).
Step 10. What ever is left can be reprocessed in one fell swoop. You might want to manually weed out low value items items which have no reprocessed value (salvage loot for example).
Step 11:Load up a hauler with your loot and ore and head to the nearest market to sell it. Normal hauling precautions apply of course. If you are feeling lazy you could try a courier contract.
Remember it is a hell of a lot easier to sell ore than it is to sell modules so for an easy time you might want to bias your selection in favour of reprocessing. For example you could change the formula to
IF(AND(P2>1.2*O2, P2>100000),"SELL","") to only sell items that are worth 20% more than their reprocessed value. Don't forget however that you will also take a hit on the reprocessing unless you have the appropriate skills trained. My untrained reprocessing percentage is only 87% so I take that into account when deciding to reprocess or not.
Edit: If you are not sure how to reprocess just drag the stuff to your hangar storage (Items tab). Highlight the stuff you want to reprocess right click and select reprocess. Warning - make sure you didn't highlight anything you want to keep. If your yield is less than 87% you need to find a better station. There is also a small fee but if you have been running missions for the station faction then it will probably be small. More information about re-processing here:http://wiki.eveonline.com/en/wiki/Reprocessing
For more general advice about selling loot look here: http://eveatoz.blogspot.com/2010/11/how-to-make-most-isk-from-your-loot.html
Comments
Solbright
Yeah, it does take longing loading now. I was sort of wondering if the extra time it took is the same on Windoze. The launcher window takes quite a few seconds to appear for me. And after clicking play the game splash screen appears and disappears quickly, leaving no visible sign the game is still loading for many more seconds.
PS: I've kept an eye on Eve running on Wine over the years even though I'm not playing it.
Solbriht
Solbright
As to the Eve launcher I haven't had any crashes but I am les than impressed. It adds no functionality for me but it just slows down launching. As an indication of how slow one of the first times I used it I ended up with 3 copies of Eve running because I impatiently kept hitting the play button while waiting.
Also every day there seems to be another mini patch to solve yet another launcher problem.Overall not impressed.
Sorry, I thought you were getting emails for each one of my posts.
It's a bit sad that anon posts are always flagged spam. It's almost a worthless feature that way.
Solbright