# 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:** 7
**Author:** ![Valdorf\_Midgard](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/valdorf_midgard/32/377452_2.png) [@Valdorf\_Midgard](https://forums.eveonline.com/u/Valdorf_Midgard)\ **Post date:** [July 15, 2023, 2:37pm UTC](https://forums.eveonline.com/t/any-details-on-the-new-excel-integration/409561/122 "2023-07-15T14:37:39Z")
Anyone else have a problem getting itemgroup by ID? Its just forever on “busy” ---
**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:** [July 16, 2023, 2:28pm UTC](https://forums.eveonline.com/t/any-details-on-the-new-excel-integration/409561/123 "2023-07-16T14:28:19Z")
Was this happening on a specific ID or on every ID? The GROUP logic is just fetching a static file and then mapping against a static file for all the items in the game, for a .types array. It’s possible that some GROUP has too many items in the .types field for display in web due to the payload limit in web excel. If that’s the case we can create a parameter to not output the types for web excel compatibility. ---
**Author:** ![Rylande\_Talvanen](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/rylande_talvanen/32/377526_2.png) [@Rylande\_Talvanen](https://forums.eveonline.com/u/Rylande_Talvanen)\ **Post date:** [July 19, 2023, 10:35am UTC](https://forums.eveonline.com/t/any-details-on-the-new-excel-integration/409561/124 "2023-07-19T10:35:40Z")
I saw that a 1.2 version was posted. Any resource to point us toward the additions/changes in the new version? ---
**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:** [July 19, 2023, 11:04am UTC](https://forums.eveonline.com/t/any-details-on-the-new-excel-integration/409561/125 "2023-07-19T11:04:54Z")
Since version 1.2 went up I am unable to get any price to update. I just get #FIELD! instead. i was using: =MIN(EVEONLINE.MARKET\_ORDERS\_STREAMING(10000002, 22428, FALSE,60003760).price) Do you know if this is temporary or will I have to modify my formula? ---
**Author:** ![Charlotte\_Aufraises](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/charlotte_aufraises/32/378701_2.png) [@Charlotte\_Aufraises](https://forums.eveonline.com/u/Charlotte_Aufraises)\ **Post date:** [July 19, 2023, 11:15am UTC](https://forums.eveonline.com/t/any-details-on-the-new-excel-integration/409561/126 "2023-07-19T11:15:31Z")
> [@Damhest](#): > > “This add-on is only supported if you have Office365 subscription…" Gotcha ---
**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:** [July 19, 2023, 11:44am UTC](https://forums.eveonline.com/t/any-details-on-the-new-excel-integration/409561/127 "2023-07-19T11:44:20Z")
Try again, there was a downtime at the time of your posting. I got problems with _Exceladin+_ too. Now it seems to work 🙂 ---
**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:** [July 19, 2023, 11:58am UTC](https://forums.eveonline.com/t/any-details-on-the-new-excel-integration/409561/128 "2023-07-19T11:58:22Z")
`MARKET_ORDERS*` in _Exceladin+ v.1.2_ has still a problem to show `Sell` orders if the offer is a sole offer for a given type in a given station. Sole `Buy` orders show just fine. Examples below: ```auto =EVEONLINE.MARKET_ORDERS_STREAMING(10000001, 56788) ``` The above formula shows sole `Buy` order in a whole _Derelik_ region for _Warclone Blanks_ ```auto =EVEONLINE.MARKET_ORDERS_STREAMING(10000020, 56788) ``` The above formula should show a sole `Sell` order for _Warclone Blanks_ in a whole _Tash-Murkon_ region but it shows `#CALC!` error message instead with an `Empty arrays are not supported` explanation as the cause of error. ---
**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:** [July 19, 2023, 12:43pm UTC](https://forums.eveonline.com/t/any-details-on-the-new-excel-integration/409561/129 "2023-07-19T12:43:01Z")
Yup, was a downtime thing. Thanks for the heads up 🙂 ---
**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:** [July 19, 2023, 7:58pm UTC](https://forums.eveonline.com/t/any-details-on-the-new-excel-integration/409561/130 "2023-07-19T19:58:30Z")
> [@Eve x Excel Add-in Version 1.2.0 Patch notes](https://forums.eveonline.com/t/eve-x-excel-add-in-version-1-2-0-patch-notes/412919): > > Version 1.2 Changelog New functions CHARACTER\_ATTRIBUTES -outputs a card with attributes and remap information about a character CHARACTER\_STANDINGS -outputs a card containing an array for faction/npc\_corp standings of the character CHARACTER\_SKILL\_QUEUE -Displays the characters skill queue MARKET\_STRUCTURE\_ORDERS/MARKET\_STRUCTURE\_ORDERS\_STREAMING -input to formula: structure\_id, type\_id, [sell\_buy\_only\_boolean], [character\_id\_or\_entity] -returns orders in a structure you have access t… Here are the patch notes in the new excel addin section. ---
**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:** [July 19, 2023, 8:15pm UTC](https://forums.eveonline.com/t/any-details-on-the-new-excel-integration/409561/131 "2023-07-19T20:15:47Z")
I’ll check this out, but it seems like that I missed that #CALC scenario as the ESI calls is now returning me 0 orders, buy/sell. But should be easily reproduced for testing. First look at the logic I see a logic error that can output this in the 5 min refresh that can be hit with this scenario, but should be more obvious once I reproduce it in debug. The refresh logic looks like it remains intact even with the #N/A error so hopefully it doesn’t drop on the #calc return. Edit: I’ve most likely found what caused the #CALC. If the refresh request failed (fx. due to ESI being down due to downtime) the function will stop updating and return an empty list to the invocation. Making a fix for it to be deployed with the next update. Should hopefully cover this CALC scenario and improve refresh functionality. ---
**Author:** ![Spacetramp\_Drago](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/spacetramp_drago/32/480922_2.png) [@Spacetramp\_Drago](https://forums.eveonline.com/u/Spacetramp_Drago)\ **Post date:** [July 24, 2023, 6:04pm UTC](https://forums.eveonline.com/t/any-details-on-the-new-excel-integration/409561/132 "2023-07-24T18:04:49Z")
If I ever feel the need to use a spreadsheet to play a game I’ll sell my rig and stop playing… ---
**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:** [July 24, 2023, 7:42pm UTC](https://forums.eveonline.com/t/any-details-on-the-new-excel-integration/409561/133 "2023-07-24T19:42:33Z")
What will you run the spreadsheet on if you go medieval? 😉 > **(on selling old pc...)** > > Who buys used pcs? I never tried to sell my old pc when buying new 😕 Only two of them ended up at _reprocesing_ shop (I wonder what was their efficiency 🤔 ) …the remaining four collects dust (514 😛 ) lying on the shelves 😕 ---
**Author:** ![Wadiest\_Yong](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/wadiest_yong/32/426921_2.png) [@Wadiest\_Yong](https://forums.eveonline.com/u/Wadiest_Yong)\ **Post date:** [July 25, 2023, 8:25am UTC](https://forums.eveonline.com/t/any-details-on-the-new-excel-integration/409561/134 "2023-07-25T08:25:04Z")
Excel ? There’s plans and ideas floating around at MS to rebrand it Tweetcel or Tweetsheet. Tit for tat, Musk ! ---
**Author:** ![Barador\_Arantar](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/barador_arantar/32/380317_2.png) [@Barador\_Arantar](https://forums.eveonline.com/u/Barador_Arantar)\ **Post date:** [July 29, 2023, 4:26pm UTC](https://forums.eveonline.com/t/any-details-on-the-new-excel-integration/409561/135 "2023-07-29T16:26:03Z")
Hello the new excel tool is indeed very powerful but also very poorly documented nevertheless I managed to recreate the most popular sellmin and buymax functions for market orders even constrain them to a single station, ie trade hub but especially the sellmin one is a half a mile long and begs for mistakes so I was looking to rewrite them in a custom VBA module, for ease of call and perhaps I need to pass all this over to our corp boss to manage our wallet, buyback etc since CCP is apparently cracking down on the likes of evepraisal problem is I cannot find the .dll name for the add-in, which would be required for referencing it in the VBA editor any tips? ---
**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:** [July 29, 2023, 4:41pm UTC](https://forums.eveonline.com/t/any-details-on-the-new-excel-integration/409561/136 "2023-07-29T16:41:22Z")
> [@Barador\_Arantar](#): > > problem is I cannot find the .dll name for the add-in, which would be required for referencing it in the VBA editor > > any tips? I think this is pure JavaScript based and there is no dll ![image](https://global.discourse-cdn.com/eveonline/original/4X/9/3/0/930a59e4576fb04b75c9b2d4d87b5bc7aec61837.png) there is a button on the side of EVE Add-in panel to enter into web debuger: ![image](https://global.discourse-cdn.com/eveonline/original/4X/8/1/0/81050a94fb8526a05ae6e37905007f98eacd66f8.png) You might try to use ESI which _Exceladin+_ uses too [https://esi.evetech.net/ui/](https://esi.evetech.net/ui/) [https://developers.eveonline.com/resource](https://developers.eveonline.com/resource) ---
**Author:** ![Barador\_Arantar](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/barador_arantar/32/380317_2.png) [@Barador\_Arantar](https://forums.eveonline.com/u/Barador_Arantar)\ **Post date:** [July 29, 2023, 5:09pm UTC](https://forums.eveonline.com/t/any-details-on-the-new-excel-integration/409561/137 "2023-07-29T17:09:10Z")
> [@Elinore\_en\_Divalone](#): > > You might try to use ESI which _Exceladin+_ uses too > [API Explorer - EVE: Developers](https://esi.evetech.net/ui/) > [Index - EVE Developer Documentation](https://developers.eveonline.com/resource) I was working with GESI already, but this excel tool allows to crunch entire arrays of data by simply adding a =MIN( to the beginning 😕 I really just need to rename > =MAX(EVEONLINE.MARKET\_ORDERS\_STREAMING(region\_id;type\_id).price\*EVEONLINE.MARKET\_ORDERS\_STREAMING(region\_id;type\_id).is\_buy\_order\*(EVEONLINE.MARKET\_ORDERS\_STREAMING(region\_id;type\_id).location.id=location\_id)) into a more clever =BUYMAX(region\_id; type\_id; location\_id) and > =MIN(SE(EVEONLINE.MARKET\_ORDERS\_STREAMING(region\_id;type\_id).price\*NON(EVEONLINE.MARKET\_ORDERS\_STREAMING(region\_id;type\_id).is\_buy\_order)\*(EVEONLINE.MARKET\_ORDERS\_STREAMING($B$2;G2).location.id=location\_id)=0;“”;EVEONLINE.MARKET\_ORDERS\_STREAMING(region\_id;type\_id).price\*NON(EVEONLINE.MARKET\_ORDERS\_STREAMING(region\_id;type\_id).is\_buy\_order)\*(EVEONLINE.MARKET\_ORDERS\_STREAMING($B$2;G2).location.id=location\_id))) into the same format ---
**Author:** ![Ban\_Solomon\_Amatin](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/ban_solomon_amatin/32/380325_2.png) [@Ban\_Solomon\_Amatin](https://forums.eveonline.com/u/Ban_Solomon_Amatin)\ **Post date:** [July 29, 2023, 6:56pm UTC](https://forums.eveonline.com/t/any-details-on-the-new-excel-integration/409561/138 "2023-07-29T18:56:52Z")
If running on windows PC you need a Office 365 subscription, eve is expensive enough without adding another £6 a month. Any chance you could get it working on standalone versions of Excel (if CCP every read these posts). The add-on loads up in Excel 2021 but just get #Value!. What a shame , looked like a good add-on, shame I won’t be able to use it. ---
**Author:** ![Ayeonmibak\_Dagger](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/ayeonmibak_dagger/32/380587_2.png) [@Ayeonmibak\_Dagger](https://forums.eveonline.com/u/Ayeonmibak_Dagger)\ **Post date:** [July 31, 2023, 8:26pm UTC](https://forums.eveonline.com/t/any-details-on-the-new-excel-integration/409561/139 "2023-07-31T20:26:35Z")
It’s mind boggling that CCP chose to lock this into something that requires payment/subscription. How about an Alpha state version?! AKA open source software. Not everyone has money to blow on the imaginary. Paying for Excel just to do this 1 thing is not logical. ---
**Author:** ![Netzvamp](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/netzvamp/32/380649_2.png) [@Netzvamp](https://forums.eveonline.com/u/Netzvamp)\ **Post date:** [August 1, 2023, 12:19pm UTC](https://forums.eveonline.com/t/any-details-on-the-new-excel-integration/409561/140 "2023-08-01T12:19:46Z")
I’ve just bought a Office 2021 Pro plus Retail for 20 bugs, since i also wanted a “clean” legal version to replace volume license. It has version “2021 MSO (Version 2307 Build 16.0.16626.20086) 64 Bit”, so looks like the latest available version. I also got the “#VALUE!” error. In the debugger i see it downloads data from the API, so that part works … So whats now? Pls help. ---
**Author:** ![Shpionus](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/shpionus/32/381454_2.png) [@Shpionus](https://forums.eveonline.com/u/Shpionus)\ **Post date:** [August 8, 2023, 4:37pm UTC](https://forums.eveonline.com/t/any-details-on-the-new-excel-integration/409561/141 "2023-08-08T16:37:21Z")
I have Ofiice 365. Must admit that this addon sometimes works. But most of the time it shows “#BUSY!”, “#NAME?”, “#VALUE!” etc… Edit: I think the problem is with that sample file. It seems to try to load tons of data and gets stuck. I created a clean excel file and did all my formulas from scratch taking peeks into stagnant sample file for formulas hints. This new file works fine, at least for several hours non-stop. Just remember that if you don’t type your formulas, but copy those from the sample file instead, make sure to remove links (if any) to the sample file’s sheets. [Previous page](https://forums.eveonline.com/t/any-details-on-the-new-excel-integration/409561.md?page=6) [Next page](https://forums.eveonline.com/t/any-details-on-the-new-excel-integration/409561.md?page=8)