# Any details on the new excel integration? **URL:** \ **Category:** General Discussion\ **Created:** [June 16, 2023, 8:34pm UTC](https://forums.eveonline.com/t/any-details-on-the-new-excel-integration/409561 "2023-06-16T20:34:43Z")\ **Posts on this page:** 20\ **Page:** 5
**Author:** ![Martin\_Kangawa](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/martin_kangawa/32/376393_2.png) [@Martin\_Kangawa](https://forums.eveonline.com/u/Martin_Kangawa)\ **Post date:** [June 25, 2023, 10:55am UTC](https://forums.eveonline.com/t/any-details-on-the-new-excel-integration/409561/82 "2023-06-25T10:55:39Z")
Since I have not found any similar threads and couldn’t get help anywhere else I have decided to come here for help. Since I have the original Excel 2021 I thought I’d give the Excel Add-In a try. I followed all the instructions and downloaded CCP’s workbook sample, downloaded the add-in, logged in and authorized my character, but data just won’t load. Upon restarting the file I do get a notification - “Add-in error. We can’t start this add-in because it isn’t set up properly”. So what else should I do to set it up properly? After hours of frustration, restarting, redownloading, trying to set up my own spreadsheet where the data just won’t load and the outcome is always the same I have decided to try the online version. Again, here the data just won’t load and after some time I am getting an error with a very lengthy ID that just doesn’t explain anything. And here the result is the same for both of my computers. If there is someone capable and willing to help me I will be more than happy to cooperate. Can be both on discord or here on the forums. Feel free to ask for any screenshots, or any questions at all- I will provide it. ---
**Author:** ![Jian\_Mira](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/jian_mira/32/509519_2.png) [@Jian\_Mira](https://forums.eveonline.com/u/Jian_Mira)\ **Post date:** [June 25, 2023, 3:45pm UTC](https://forums.eveonline.com/t/any-details-on-the-new-excel-integration/409561/83 "2023-06-25T15:45:07Z")
i cant get it working either it just says #Value! ---
**Author:** ![Elinore\_en\_Divalone](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/elinore_en_divalone/32/507815_2.png) [@Elinore\_en\_Divalone](https://forums.eveonline.com/u/Elinore_en_Divalone)\ **Post date:** [June 25, 2023, 7:58pm UTC](https://forums.eveonline.com/t/any-details-on-the-new-excel-integration/409561/84 "2023-06-25T19:58:19Z")
> [@Martin\_Kangawa](#): > > I am getting an error with a very lengthy ID that just doesn’t explain anything. And here the result is the same for both of my computers. You should post whatever info on that error you have and maybe @Hundasuupa, the Dev working on the _EVE Online Excel Add-in_ and the next update (soonTM), could figure it out 🤔 And here is the main thread (player originated) for actually discussing any issues or hints > [@Any details on the new excel integration?](https://forums.eveonline.com/t/any-details-on-the-new-excel-integration/409561/76): > > One issue I’m facing is not being able to log in all accounts. After you’ve logged in a decent number (30-40 or so), attempting to log in any more throws this error: The exact same issue also has existed with the EvE launcher itself, but the quick fix was always just to delete the “C:\Users\username\AppData\Local\CCP\EVE\QtWebEngine\Default\cookies” file, after which you can then add more accs to the launcher. Is there any way to do something similar with this plugin so a… Maybe @ISD_Traindriver should merge them together? ---
**Author:** ![Jian\_Mira](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/jian_mira/32/509519_2.png) [@Jian\_Mira](https://forums.eveonline.com/u/Jian_Mira)\ **Post date:** [June 25, 2023, 8:00pm UTC](https://forums.eveonline.com/t/any-details-on-the-new-excel-integration/409561/85 "2023-06-25T20:00:19Z")
i got it working but only in office 365 which is a shame as i have office 2021 ---
**Author:** ![ISD\_Traindriver](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/isd_traindriver/32/373313_2.png) [@ISD\_Traindriver](https://forums.eveonline.com/u/ISD_Traindriver)\ **Post date:** [June 26, 2023, 5:18pm UTC](https://forums.eveonline.com/t/any-details-on-the-new-excel-integration/409561/86 "2023-06-26T17:18:00Z")
Merged another Thread in here. ---
**Author:** ![Hundasuupa](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/hundasuupa/32/412082_2.png) [@Hundasuupa](https://forums.eveonline.com/u/Hundasuupa)\ **Post date:** [June 27, 2023, 2:52pm UTC](https://forums.eveonline.com/t/any-details-on-the-new-excel-integration/409561/87 "2023-06-27T14:52:49Z")
You can come to us in #spreadsheets on Discord and I can take a look with you. “Add-in error. We can’t start this add-in because it isn’t set up properly” This looks like an issue with the template sheet once the user install the official addon, since the template used a copy of the official one before it was release the workbook might be loaded with 2 duplicate add-ins and show that error on every load. A user was able to copy the sheets into a fresh sheet with just the official one and have it work after removing external references. ---
**Author:** ![Hundasuupa](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/hundasuupa/32/412082_2.png) [@Hundasuupa](https://forums.eveonline.com/u/Hundasuupa)\ **Post date:** [June 27, 2023, 4:55pm UTC](https://forums.eveonline.com/t/any-details-on-the-new-excel-integration/409561/88 "2023-06-27T16:55:52Z")
V1.1 has been pushed to the production servers. To obtain the update right away you can hit CTRL+F5 in the taskpanel to refetch new content. It’s probably needed to go to My Add-ins and hitting refresh for Excel to relink the updated function information to the functions. Once the app store version get updated the add-in should automatically fetch this new version and load it properly, so this is more of a way to get it right away. **New endpoint** - Character\_LP endpoint added into CHARACTER\_LP(character\_id\_or\_entity) **Data changes** - INVENTORYSEARCH, GROUP, CATEGORY now uses SDE data instead of ESI - CHARACTER\_SKILLS now outputs an “Unallocated SP” item to expose that data from the endpoint. - MARKET\_ORDERS functions now include a data\_updated date field for each item. - CHARACTER\_BLUEPRINTS and CORPORATION\_BLUEPRINTS now include a “blueprint\_data” field with the relevant blueprint information. **New parameters** - CHARACTER\_SKILLS now has an optional search\_string parameter - Character and Corporation INDUSTRY\_JOBS now has an optional status\_filter parameter - Character and Corporation BLUEPRINTS now has an optional search\_string parameter - MARKET\_ORDERS and MARKET\_ORDERS\_STREAMING now has an optional sell\_buy\_only\_boolean parameter to filter by sell/buy. - MARKET\_ORDERS and MARKET\_ORDERS\_STREAMING now has an optional location\_id parameter to allow easier filter by station/structure id - Character and Corporation ASSETS now has an optional location\_filter parameter that will pre-filter the data by matching final\_location.id or location.id to the input. - Character and Corporation ASSETS now has an optional page filter to paginate results to 1000 per page while still resolving all assets first and obtaining a resolved final\_location and location where possible. **UI fixes/changes** - Fixed duplicated CHARACTER in the try it out for Implants and Fittings calls. - Reworded requirements on corporation functions in the list to better reflect the required roles. - Character\_Lp try it out now added to the sidebar list. - Moved INVENTORYSEARCH to the public category. - The sidebar will now properly detect if the ExcelApi is not in the minimun required version. **Bug fixes and other changes.** - Improved multipage endpoint error handling. - Removal of unneccesary structure calls for corporation location resolution. - MARKET\_ORDERS\_STREAMING now properly supports a type\_id\_or\_entity input as it’s type parameters like MARKET\_ORDERS offers. - Categories more reliably return their respective group. - Groups more reliable return their respective types. - Corporation and character contracts logic bug in naming output fixed that was preventing output. - Throttling improved to better support larger sheets with multiple streaming functions. ---
**Author:** ![Elinore\_en\_Divalone](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/elinore_en_divalone/32/507815_2.png) [@Elinore\_en\_Divalone](https://forums.eveonline.com/u/Elinore_en_Divalone)\ **Post date:** [June 27, 2023, 5:44pm UTC](https://forums.eveonline.com/t/any-details-on-the-new-excel-integration/409561/89 "2023-06-27T17:44:17Z")
Thanks for the update with such a bunch of QoL and fixes 🙂 I can see new function signatures, but version number displayed has not changed which may be confusing 🤔 ![image](https://global.discourse-cdn.com/eveonline/original/4X/b/7/1/b71ff9ccdca29879f5ea4118fdc14fa6ebed3624.png) Quick test ```auto =EVEONLINE.CHARACTER_SKILLS(A1.id;"Search string") ``` Returns all skills no matter the search string 😕 aka it is not working unfortunately, has also quick checked the character\_blueprint new search param and it neither works for me ---
**Author:** ![Hundasuupa](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/hundasuupa/32/412082_2.png) [@Hundasuupa](https://forums.eveonline.com/u/Hundasuupa)\ **Post date:** [June 27, 2023, 6:28pm UTC](https://forums.eveonline.com/t/any-details-on-the-new-excel-integration/409561/90 "2023-06-27T18:28:51Z")
Strange, so the updated function.json was loaded but not the function.js which runs it. Shame it’s so messy to get updates without an appstore update. I’d try CTRL+F5’ing again and maybe DevTool via Right-Click inspect and hitting “Disable cache” to try and get it to refresh. ![image](https://global.discourse-cdn.com/eveonline/original/4X/3/3/d/33d0bbb4f55901df2a5d8d53464b761d2d918f6e.png) (and re-enabling the cache after you have it ofc) ---
**Author:** ![Elinore\_en\_Divalone](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/elinore_en_divalone/32/507815_2.png) [@Elinore\_en\_Divalone](https://forums.eveonline.com/u/Elinore_en_Divalone)\ **Post date:** [June 27, 2023, 8:43pm UTC](https://forums.eveonline.com/t/any-details-on-the-new-excel-integration/409561/91 "2023-06-27T20:43:27Z")
Ok, after _Attach Debbuger_ and _Ctrl+F5_ in _Network_ tab the add-in updated itself completely and shows v1.1 now on its panel. …but `MARKET_ORDERS_STREAMING` shows `#BUSY!` ad infinitum. It works in new workbook. Does this mean I need to start from scratch after every add-in update 🤔 `MARKET_ORDERS` works just fine in old workbook, even with Sell/Buy only bool flag. But it may be that because I had used it for the first time in that old workbook just for the purpose of checking if it works. BTW, how do you make it refresh manually? Does _Formulas → Calculate Now_ (or pressing F9) should trigger market data refresh for not streaming version? Or should I use _Data → Refresh All_? Because neither option seems to do this. Only entering edit mode and pressing _Enter_ seems to work 🤔 Formula ```auto =EVEONLINE.CHARACTER_SKILLS(J17;"Unallocated SP") ``` (where cell `J17` contains character entity) works in the new and old workbooks as well EDIT: I managed to make `MARKET_ORDERS_STREAMING` formula work in my _old_ workbook by changing which signature I use like that: ```auto =EVEONLINE.MARKET_ORDERS_STREAMING(A2.id;$A$1.id;;) ``` notice two _empty_ semicolons Cell `A1 `contains inventory id returned by `=EVEONLINE.INVENTORYSEARCH("PLEX";TRUE).id` Cell `A2` contains region entity returned by `=TRANSPOSE(EVEONLINE.SEARCHREGION())` So it is a matter of stored function reference from the previous version of add-in 😕 Any way to refresh that? Other functions refreshed themselves and are working just fine. ---
**Author:** ![Jian\_Mira](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/jian_mira/32/509519_2.png) [@Jian\_Mira](https://forums.eveonline.com/u/Jian_Mira)\ **Post date:** [June 27, 2023, 11:01pm UTC](https://forums.eveonline.com/t/any-details-on-the-new-excel-integration/409561/92 "2023-06-27T23:01:34Z")
This spreadsheet is very complicated! trying to workout how to get your character current location or do a sum to get the total worth of your assets is very difficult. There needs to be more examples of the scripts, you would of thought they would list some useful examples! So far i have the following working in my spreadsheet - Character Name, DOB, Character ID, Corporation Name, Total Wallet, Current Skill Points Anybody got some examples i can use??? ---
**Author:** ![Elinore\_en\_Divalone](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/elinore_en_divalone/32/507815_2.png) [@Elinore\_en\_Divalone](https://forums.eveonline.com/u/Elinore_en_Divalone)\ **Post date:** [June 28, 2023, 5:57pm UTC](https://forums.eveonline.com/t/any-details-on-the-new-excel-integration/409561/93 "2023-06-28T17:57:07Z")
I think there might be an error in `MARKET_ORDERS` and `MARKET_ORDERS_STREAMING`. It shows nothing when there is exactly only one market order for a given inventory type. As an example to test it is one sell order in _Tash-Murkon_ region for _Warclone Blanks_ (yeah I know, i know 😊, booooring ) You should see this order after entering this formula ```auto =EVEONLINE.MARKET_ORDERS_STREAMING(EVEONLINE.SEARCHREGION("Tash-Murkon").id;EVEONLINE.INVENTORYSEARCH("Warclone Blanks";TRUE).id;;) ``` and it shows no (`#N/A`) orders. And here is a regional market window screenshot of that order from the game client. ![image](https://global.discourse-cdn.com/eveonline/original/4X/4/2/d/42dbea7edf11fccb8e092a0880d6d79ba988c64c.jpeg) It is very rare for this situation to see in the market - there is almost always no orders or more than one. I wouldn’t notice it if I wasn’t cross-checking my _Exceladin+_ workbook for _Warclone Blanks_ sell orders with _[EVEMarketer](https://evemarketer.com/types/56788/sell)_ 🤔 ---
**Author:** ![Gelf](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/gelf/32/462608_2.png) [@Gelf](https://forums.eveonline.com/u/Gelf)\ **Post date:** [June 28, 2023, 6:29pm UTC](https://forums.eveonline.com/t/any-details-on-the-new-excel-integration/409561/94 "2023-06-28T18:29:00Z")
Could really do with a separate forum for the excel stuff. It would be useful to find everything excel related under one sub category, rather than having to trawl through multiple sections to find info. ---
**Author:** ![Jian\_Mira](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/jian_mira/32/509519_2.png) [@Jian\_Mira](https://forums.eveonline.com/u/Jian_Mira)\ **Post date:** [June 28, 2023, 11:25pm UTC](https://forums.eveonline.com/t/any-details-on-the-new-excel-integration/409561/95 "2023-06-28T23:25:03Z")
Has anybody got any examples of a spreadsheet they created? Would love to see an ice market and plex market in the spreadsheet! ---
**Author:** ![Elinore\_en\_Divalone](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/elinore_en_divalone/32/507815_2.png) [@Elinore\_en\_Divalone](https://forums.eveonline.com/u/Elinore_en_Divalone)\ **Post date:** [June 29, 2023, 9:07am UTC](https://forums.eveonline.com/t/any-details-on-the-new-excel-integration/409561/96 "2023-06-29T09:07:55Z")
> [@Jian\_Mira](#): > > Has anybody got any examples of a spreadsheet they created? > > Would love to see an ice market and plex market in the spreadsheet! It will be tricky to share example workbooks, which deal with character data because some entity data are stored in the workbook. Even with some example alpha char it could go sideways 😕 People must be cautious what they share to not expose themselves. EVE is a game of cloaks and daggers 😛 and the _Exceladin+_ has become a weapon in that game. It would be much safer to just post some easy to follow step by step instructions to create such workbook manually. I’ll show you what I mean in the following paragraphs 🙂 First let’s assume You have followed the [official manual](https://support.eveonline.com/hc/en-us/articles/8165207770524-EVE-Online-Excel-Add-in) on [installing](https://support.eveonline.com/hc/en-us/articles/8165207770524-EVE-Online-Excel-Add-in#_Toc136513414) _Exceladin+_ (a pet name I coined for _EVE Online Excell Add-in_ 😉 it is a pun to [_Quafe+_](https://universe.eveonline.com/lore/quafe-plus) a highly addictive drink as extensive use of _Exceladin+_ is too highly addictive and fun and I wonder what controversial ingredients are in it hehe) Now let’s find the cheapest deal on PLEX now 🙈 1. Enter this formula in cell `B1`: ```auto =TRANSPOSE(EVEONLINE.SEARCHREGION()) ``` this will generate a row with region names (precisely this are more complex data or entities) spread over columns `B1:DH1` 1. Enter this in cell `A2`: ```auto =MINIFS(B2:DH2;B2:DH2;">0") ``` this will display lowest price and greater than 0 (in a while) 1. Enter this in cell `B3`: ```auto =EVEONLINE.MARKET_ORDERS_STREAMING(B1.id;EVEONLINE.INVENTORYSEARCH("PLEX";TRUE).id;FALSE;).price ``` this will display sell prices for PLEX in Derelik region. Or `#FIELD!` error if there are no orders. It’s ok. The `;FALSE;` part indicates we want `Sell only` offers. Change it to `;TRUE;` to get `Buy only` offers. 1. Copy cell `B3` (or if you prefer just _drag_ it with your mouse) along the row `3` all the way into cells `C3:DH3` this will display sell prices for PLEX in other regions. It may taka a while for formulas to fetch data, don’t panic yet (if they show no data after a few minutes there must be something wrong with add-in installation). Almost there. 2. enter this formula in cell `B2` ```auto =IFERROR(MINIFS(B3#;B3#;">1000000");0) ``` this will display lowest price, greater than 1 million ISK for a given region. IFERROR is in case there are no offers in a region, so a reference to .price throws error (see step 4.). 1. Enter this formula to search for the region with the lowest price ```auto =XLOOKUP(A2;B2:DH2;B1#).regionName ``` Now cell `A2` should show you that lowest PLEX price and cell `A3` will show first region name matching that lowest price You can bolden cells in row `2` to make them more visible. If you would like to just browse the sell orders, remove “.price” from the end of the formulas in cells `B3:DH3` You should end up with something like this ![image](https://global.discourse-cdn.com/eveonline/original/4X/c/4/a/c4aca2b0c8e0d22f45e50fb1b405ac892f56fca3.png) Warning: there are two errors I have noticed until now in `MARKET_ORDERS_STREAMING`. One is that it shows no orders if there is only one offer in the market, and another is it sometimes shows Buy & Sell offers after it refreshes automatically after 5 minutes, despite providing the parameter for `Sell only` - second `;FALSE;` parameter. Strangely enough it happens only in the `B` column for me 🤔 To correct this, enter formula edit mode and press enter to force refresh. I hope you will find it useful. ---
**Author:** ![Hundasuupa](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/hundasuupa/32/412082_2.png) [@Hundasuupa](https://forums.eveonline.com/u/Hundasuupa)\ **Post date:** [June 29, 2023, 11:02am UTC](https://forums.eveonline.com/t/any-details-on-the-new-excel-integration/409561/97 "2023-06-29T11:02:26Z")
I’ll check this, was the output as expected when you omitted the last ;; for blanks? i.e. just standard(regionid;typeid) might be a reference error where the logic written isn’t validating empty parameters smart enough for what excel sends in. I’ll also check the refresh showing buy/sell, this is most likely cache bleeding through or not being grabbed by the filters properly. The market\_streaming uses some fancy logic to populate all the relevant fields with the same regionId, Typeid since they share the core data. edit: bug confirmed in \_STREAMING, investigating and checking for the trigger for it and deploying a fix when it’s fixed. Only happens on the 5 minute timer so it’s easily missed. Back to the ugly is\_buy\_order filtering is needed for v1.1 in streaming ☹ ---
**Author:** ![Jian\_Mira](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/jian_mira/32/509519_2.png) [@Jian\_Mira](https://forums.eveonline.com/u/Jian_Mira)\ **Post date:** [June 29, 2023, 12:13pm UTC](https://forums.eveonline.com/t/any-details-on-the-new-excel-integration/409561/98 "2023-06-29T12:13:10Z")
i cant get that working it does not like this script =EVEONLINE.MARKET\_ORDERS\_STREAMING(B1.id;EVEONLINE.INVENTORYSEARCH(“PLEX”;TRUE).id;FALSE;).price This bit works so it must be the inventory search which does not work =EVEONLINE.MARKET\_ORDERS\_STREAMING(B1.id) ---
**Author:** ![Elinore\_en\_Divalone](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/elinore_en_divalone/32/507815_2.png) [@Elinore\_en\_Divalone](https://forums.eveonline.com/u/Elinore_en_Divalone)\ **Post date:** [June 29, 2023, 12:37pm UTC](https://forums.eveonline.com/t/any-details-on-the-new-excel-integration/409561/99 "2023-06-29T12:37:10Z")
What happens when you use this formula? ```auto =EVEONLINE.INVENTORYSEARCH(“PLEX”;TRUE).id ``` It should return id for PLEX Edit: Try replacing semicolon with _list separator_ set in _Regional settings_ quicktest replace semicolons in my example with commas 🤣 ---
**Author:** ![Elinore\_en\_Divalone](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/elinore_en_divalone/32/507815_2.png) [@Elinore\_en\_Divalone](https://forums.eveonline.com/u/Elinore_en_Divalone)\ **Post date:** [June 29, 2023, 4:16pm UTC](https://forums.eveonline.com/t/any-details-on-the-new-excel-integration/409561/100 "2023-06-29T16:16:41Z")
> [@Hundasuupa](#): > > was the output as expected when you omitted the last ;; for blanks? No, and neither `MARKET_ORDERS` or `MARKET_ORDERS_STREAMING` show this specific market order for _Warclone Blanks_ in _Tash-Murkon_ region. And the sole market order is still active as of now. ---
**Author:** ![Hundasuupa](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/hundasuupa/32/412082_2.png) [@Hundasuupa](https://forums.eveonline.com/u/Hundasuupa)\ **Post date:** [June 29, 2023, 8:31pm UTC](https://forums.eveonline.com/t/any-details-on-the-new-excel-integration/409561/101 "2023-06-29T20:31:21Z")
v1.1.1 with a hotfix for the MARKET\_ORDERS\_STREAMING has been pushed to production and is now available to the add-in. The flow of the auto update code included a trigger that registered a “ghost” data feed that didn’t include the parameters of the cell being targeted. It still worked if the user had only used the parameter version so it was hard to trigger. STREAMING now auto-updates withing it’s own scopes of their parameters and only accept proper feeds of data, while re-using cached data if withing the 5 minute window of a call using the same regionID and typeID. There might be a ghost variable left over that increases resource usage of the sheet, but that’s being looked into. This update won’t apply automatically as it’s only updating the HTML/JS so it’ll in most cases require a cache clear to be active. CTRL+F5 etc. New installs should fetch the v1.1.1 by default. As soon as the v1.1.1 is visible in your taskpane it means you should have the sufficient Javascript loaded to have a working version. (Tested for couple of hours to ensure it works, but we might have some outliers, feel free to report them directly to discord as I watch that more closely) Bonus: Added compatibility to throw in a system\_id into the location\_id parameter (just a simple OR statement, so should work for these ID’s in most if not all cases) I’m investigation the Task-Murkon region and if I can find anything we’ll do another hotfix for it, just not as expedited I imagine as this is a needed QoL component we’re fixing now. [Previous page](https://forums.eveonline.com/t/any-details-on-the-new-excel-integration/409561.md?page=4) [Next page](https://forums.eveonline.com/t/any-details-on-the-new-excel-integration/409561.md?page=6)