Pages: [1] :: one page |
|
Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Horiz Rin
School of Applied Knowledge Caldari State
0
|
Posted - 2015.08.01 08:26:12 -
[1] - Quote
Hi,
Is there a quick and easy way to bring some of my Eve possessions into Excel?
I'm an industry player, and I have a 'warehouse' that holds stock. I'd like to be able to get Excel to automatically retrieve the amount of (eg) Hammerheads in the hanger at station 'X'
I'm fairly good with Excel (I already have a decent spreadsheet that pulls data from eve-central) , but that's about the limit of my programming skills.
Failing an easy answer, any hints or tips on how to proceed would be really appreciated.
Thanks :)
|
Hel O'Ween
Men On A Mission
120
|
Posted - 2015.08.04 16:38:42 -
[2] - Quote
Assets is one of the more tricky APIs, as it needs recursion ("a thing in a thing in a thing located at") to fully resolve the location of an item.
Without VBA, I'm afraid you're out of luck with your request.
If you're just after "what's where?", have a look at jEveAssets.
If you want to work with your assets in Excel, have a look at my EVEWalletAware (see my signature). It allows manual exports to Excel. But unlike jEveAssets, my EWA isn't specialized in asset tracking. I'm also not sure if the export is of much help to you.
EVEWalletAware - an offline wallet manager.
|
Golden Gnu
EVE University Ivy League
167
|
Posted - 2015.08.04 22:24:17 -
[3] - Quote
jEveAssets can export to CSV, that should be easy to import in excel It has the added bonus that you don't have to resolve all the typeIDs, locationIDs etc. Disclaimer: I'm the dev of jEveAssets
Drop me a note in the jEveAssets thread if you need any help with it...
Download is the meaning of life, upload is the meaning of intelligent life
http://eve.nikr.net - home of jEveAssets
|
Horiz Rin
School of Applied Knowledge Caldari State
0
|
Posted - 2015.08.11 10:17:18 -
[4] - Quote
Thanks for the tips - and sorry for the delay in my posting, for some reason I'm not getting notifications of replies.
I've been using JEveAssets for a while but never thought of the csv approach. I was hoping for an 'integrated into Excel' solution (pure laziness I'll admit), but I'll give that a go.
Thanks once again :)
Steve
|
|
|
|
Pages: [1] :: one page |
First page | Previous page | Next page | Last page |