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.
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.
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.
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.
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
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
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.
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.
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.
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.