I believe it is 2016 and older…
My latest attempt to retrieve Assets of a single toon:
after 1 hour 33 minutes of #BUSY! , Excel now says #NAME?
(Microsoft 365 web app)
All I’ve been able to get with a 2021 home office version. Genuine copy from the Microsoft site. Am I miss-understanding something, this should be working right?
When used on the web version it actually returns values.
1 Like
Of course. And the MSO 2019 is older in programming terms which is demonstrated by this:
Since my Excel is v.2302 (build 16501 whatever), and it is a retail version (not VL), it should support all the functionality. Though it does not.
I just recall how yesterday Oz said that in his opinion this tool will lower the barrier for entry to use spreadsheets by new players from 80% to 50%…lmao
2 Likes
I feel for you. We, at our desktop Office suites at least get the #NAME? error immediately 
1 Like
Anyone got an idea who to translate the 13-digit number that =I2#.location_id gives me, into the name of the actual place?
Does
=EVEONLINE.STATION(I2#.location_id)
or
=EVEONLINE.STRUCTURE(I2#.location_id)
or
=IF(ISERROR(EVEONLINE.STRUCTURE(I2#.location_id));EVEONLINE.STATION(I2#.location_id);EVEONLINE.STRUCTURE(I2#.location_id))
work for you?
1 Like
I tried to retrieve Wallet Transactions of a single toon:
after approx. 2 hours of #BUSY! , Excel now says #NAME?
(Microsoft 365 web app)
I’ve spent 19 hours, all I could get was the 30-ish Market Orders of a single toon (and that took 15 minutes) 
1 Like
Closing down and reopening workseet (and Excel) helped me overcome #BUSY state. Classic IT solution 
Also used Reload command in the Add-in pane a few times.
I suppose you’re not using the Web version (as closing the worksheet also closes Excel in the web app)?
Whenever I close and reopen my worksheet (containing a single call to an Add-in function) Excel goes from #CALC! to #NAME? and stays there, until I click in the formula bar with the cell selected, and hit Enter - then it goes to #BUSY!, as it should AFAIK while waiting for the data from Eve’s API.
Same when I Reload the Add-in pane.
CCP, anybody, any comments on this?
2 Likes
Also can’t get this to work. Any success on your end?
1 Like
Well, tbh in my eyes it seems as a complete failure on side of CCP/Microsoft whoever tested this [censored]. Really, those, who understand the power of spreadsheets would probably agree.
By introducing the Excel add-in CCP was right in intent. But the way it was done completely ruined this intent. I mean that a selected few who have no issues with the add-in now are able to use its power, while others must still rely on their home-made tables with ESI-calls in best case. This gives the ones with working add-in a serious advantage, which I think I can already notice in market’s behaviour. This add-in in the hands of few can ruin the market PVP as a definition.
Uff, I spoke. Sry if angered but it really made me mad.
1 Like
If you just need quick, transregional market overview for a certain item you can catch up with this handy third party EVE complementary service
It precedes now infamous, fussy and evil EVE Online Excel Add-in
TY, I am aware of most of the third-party eve tools, aka EveMarketer, Adam4Eve, EveMarletWatch, EveTycoon, jEveAssets etc, and I also have my own spreadsheets. What makes me mad is that this add-in would make obsolete a lot of time wasted on looking up particular info on different resources but…
1 Like
In the GESI add-on for Google Sheets, one way of doing this looks like this(with data/error checking):
= IFERROR(regexextract(HLOOKUP(“systems”,universe_ids(F2,true),2),“[0-9]+”),“NA”)
This Excel implementation it is a little shorter.
The difference is that in Excel you have to know which property to access in these many complicated objects, whereas using GESI you need to know which parameters to use in its many functions.
Using Excel, function parameter types(data types, not Eve Online types) is not consistent and the function/object combinations are not well documented. Finding a function that extracts the data you want from an object is a bit of a safari.
At first I was dismayed at functions returning objects from this large, complicated object tree; but its getting easier as I become more familiar with them. And of course, some things can be done more directly. We have access to ALL excel functions, which Google does not have.
Google does have the faux SQL commands which make a lot of things easier and more straightforward for me. It’s an excellent alternative to Excel’s terrible Filter() function.
1 Like
I agree. It looks like everything in their propaganda is incorrect.
- It IS part of a third party application.
- It is NOT readily available to all players, unless you mean that anyone can subscribe at significant cost to use it.
- It does not provide access to non-programmers. Have you seen the code in the cells in the demonstration workbook? This would only seem accurate for those who only use the canned worksheets.
P.S. Some of the important cells never load for me, so anything that depends on them throw errors.
2 Likes
I have found that the formulas don’t update by themselves.
I created a macro which copy and pastes the formulas over themselves which seems to trigger the Add-in to refresh the cells.
Cell C2 has the formula =EVEONLINE.TYPE(A2)
With cells A2…A5051 having the type id’s for whatever you want to list.
Sub UpdateMarket()
’
’ UpdateMarket Macro
’
’
Application.ScreenUpdating = False
Sheets(“Market Prices”).Select
Range(“C2”).Select
Selection.AutoFill Destination:=Range(“C2:C5051”), Type:=xlFillDefault
Range(“C2:C5051”).Select
Selection.End(xlUp).Select
Range(“C2”).Select
Application.ScreenUpdating = True
End Sub
2 Likes
I use the streaming formula for refreshing market orders every 5 minutes (let’s not be infogready)
=EVEONLINE.MARKET_ORDERS_STREAMING(<region_id>;<type id>)
I also use this formula
=TRANSPOSE(EVEONLINE.SEARCHREGION())
to get a row with all regions in one row and each in separate column
and in the next row i put that streaming formula with region id from cell above like that
=EVEONLINE.MARKET_ORDERS_STREAMING(A2.id;$A$1)
=EVEONLINE.MARKET_ORDERS_STREAMING(C2.id;$A$1)
.
.
.
=EVEONLINE.MARKET_ORDERS_STREAMING(DG2.id;$A$1)
Cell A1 contains type id of the market item
Row 2 contains regions
Rows 3 and below contains market orders for a given region in a column, it looks like this
This is a kind of mind blowing for me every time I use it
Refreshing the formulas does trigger data download from Add-in but values stayed the same.
Its not working at all now #BUSY! everywhere