DoubleWolf
Stalker
- Joined
- Apr 25, 2008
- Posts
- 1,592
- Location
- PDX USA
- Society
- Lost Renegades
Not sure if this is the best place to post a thread like this. Seems as good as any though...
With Entropiatools going down recently, I needed a new way to calculate my inventory's total TT value. I for one don't feel like going though everything in my inventory and totaling it up by hand. It's too damn tedious for me, so I can only imagine what that task would be like for someone who's been here for a number of years...
I've found a simple way to total up everything from the "My Items" list on EU's main site. The problem before was when you copy and paste everything into Excel, every cell for the item's total included the word "PED". It makes it hard to just use the "SUM" function to total that up. Well I was able to find an equation that will get the total without having to remove the word "PED" from every cell, so now it is just a matter of copy and paste. This may seem really easy to some, but for those not quite as skilled in Excel, this is a good deal.
Simple instructions:
1. Start a new worksheet in Excel.
2. Go to entropiauniverse.com, log on to the "My Items" section and copy the entire list, starting with the "1" of the first item and ending with the location of the last item.
3. In Excel, highlight the cell you want the list to start at (A1 seems to work well ), right click and select "Paste Special...", then select to paste as TEXT. This will put the items into the right cells.
4. Pick the cell in the worksheet you want to use to show the total, and paste this equation:
=SUMPRODUCT(SUBSTITUTE(0&d:d," PED","")+0)
Your total inventory TT value will then be displayed in that cell.
A few things:
This formula is set to calculate EVERYTHING in the "D" column, which if you paste your list starting in the "A" column, this will be where the PED value cells will end up. If you want to use a different column, simply change the "d:d" part of the formula to whatever corresponding letter column you wish. Also, the formula will not work if there is anything in the column other than the values, so if you try to put the equation in the D column, or if you wanted to put a label on the column for instance, the values will not be calculated.
This will ONLY calculate TT values. Entropiatools was great for calculating the MU values as well, as it could have a direct link to PEAuction through the net, and until either the site comes back up or something else replaces it, you'll have to do that calculation by hand. This at least gives people a little option. And there's likely other ways to do this, but it would seem to me to be one of the quickest...
I only hope that this helps some people out and I didn't just post this here for my own amusement...
With Entropiatools going down recently, I needed a new way to calculate my inventory's total TT value. I for one don't feel like going though everything in my inventory and totaling it up by hand. It's too damn tedious for me, so I can only imagine what that task would be like for someone who's been here for a number of years...
I've found a simple way to total up everything from the "My Items" list on EU's main site. The problem before was when you copy and paste everything into Excel, every cell for the item's total included the word "PED". It makes it hard to just use the "SUM" function to total that up. Well I was able to find an equation that will get the total without having to remove the word "PED" from every cell, so now it is just a matter of copy and paste. This may seem really easy to some, but for those not quite as skilled in Excel, this is a good deal.
Simple instructions:
1. Start a new worksheet in Excel.
2. Go to entropiauniverse.com, log on to the "My Items" section and copy the entire list, starting with the "1" of the first item and ending with the location of the last item.
3. In Excel, highlight the cell you want the list to start at (A1 seems to work well ), right click and select "Paste Special...", then select to paste as TEXT. This will put the items into the right cells.
4. Pick the cell in the worksheet you want to use to show the total, and paste this equation:
=SUMPRODUCT(SUBSTITUTE(0&d:d," PED","")+0)
Your total inventory TT value will then be displayed in that cell.
A few things:
This formula is set to calculate EVERYTHING in the "D" column, which if you paste your list starting in the "A" column, this will be where the PED value cells will end up. If you want to use a different column, simply change the "d:d" part of the formula to whatever corresponding letter column you wish. Also, the formula will not work if there is anything in the column other than the values, so if you try to put the equation in the D column, or if you wanted to put a label on the column for instance, the values will not be calculated.
This will ONLY calculate TT values. Entropiatools was great for calculating the MU values as well, as it could have a direct link to PEAuction through the net, and until either the site comes back up or something else replaces it, you'll have to do that calculation by hand. This at least gives people a little option. And there's likely other ways to do this, but it would seem to me to be one of the quickest...
I only hope that this helps some people out and I didn't just post this here for my own amusement...
Last edited: