Awesome. Thanks.
That Sum filter is definitely on the right track. I’m even able to modify it (will show my work once everything is working) so that it automatically looks up the command center type for the filter so that if you change your PI setup you don’t need to change the formulas.
The problem right now is that pin data for =EVEONLINE.CHARACTER_PLANET(C59,G59).pins is not updating.It was working last night, but now it isn’t.
hmmmm…wondering if there is a delay on the reporting? I have one launchpad that shows contents, but it’s from days ago when I dropped off materials. Those materials are already converted and that launchpad is currently empty. The output launchpads have product on them, but are reporting as empty.
PI only updates when it’s viewed ingame. Have you looked at the planet in client since dropping the materials?
To compensate for that it is needed to guesstimate the actual items by the finished state etc, but makes the contents field not super useful sadly. When we finish the schematics functions from the SDE data conversion that might be a bit easier. But until then you have to do some magic yourself if possible.
Have you looked at the planet in client since dropping the materials?
Multiple times. That’s why it is so odd. I’ve gone to the planet and opened each launchpad to view the contents. Even the PI that I JUST put down a couple of hours ago. It shows a reduction on the input launchpads, but no processed materials on the output launchpad even after going in and verifying it’s there. Both by closing and reopening the PI window as well as opening the view planetary industry window for the planet…
Not sure that any magic is going to be possible for now since it’s failing to pull any numbers at all. Shame. I was looking forward to putting that in place and moving on. Will need to table it for now.
Still seeing the 'https://d.docs.live.net/Applications/Microsoft Excel.app/Contents/Frameworks/ATP.framework/Resources/en.lproj/FUNCRES.XLAM'!_xldudf_EVEONLINE_ breakage every time I open the file though.
Either way. I appreciate the work you guys are doing and the fact that I can post here and get quick feedback!
Another thing for the “Dear Santa” list. Being able to pull the Customs office owner and tax rate for it. 
I don’t want much…just the world.
the only thing for the customs offices I see is a director level command to view your corporations customs offices.
And the PI character_planet function is internally cached for 5 minutes, I don’t see a cache timer on the ESI swagger but the response tells me it’s also 5 minutes. So we’re at least respecting that
Curious. Why am I seeing a majority of my pricing show up, but the occasional #FIELD error shows on some others when using:
=INDEX(EVEONLINE.MARKET_ORDERS_STREAMING(10000002,$B81,0,60003760).price,1)
If I use
=INDEX(EVEONLINE.MARKET_ORDERS(10000002,$B81,0,60003760).price,1)
everything seems fine.
| Qty on Hand | Volume (m3) | Jita Price | Approx Value (Jita Sell) | ||||
|---|---|---|---|---|---|---|---|
| P3 | 2344 | 3 | Condensates | - | - | $75,990.00 | $- |
| 2345 | 3 | Camera Drones | - | - | $123,000.00 | $- | |
| 2346 | 3 | Synthetic Synapses | - | - | $129,900.00 | $- | |
| 2348 | 3 | Gel-Matrix Biopaste | - | - | $155,000.00 | $- | |
| 2349 | 3 | Supercomputers | - | - | $138,500.00 | $- | |
| 2351 | 3 | Smartfab Units | - | - | $110,800.00 | $- | |
| 2352 | 3 | Nuclear Reactors | - | - | $96,440.00 | $- | |
| 2354 | 3 | Neocoms | - | - | $121,400.00 | $- | |
| 2358 | 3 | Biotech Research Reports | - | - | $148,600.00 | $- | |
| 2360 | 3 | Industrial Explosives | - | - | $91,940.00 | $- | |
| 2361 | 3 | Hermetic Membranes | - | - | $133,900.00 | $- | |
| 2366 | 3 | Hazmat Detection Systems | - | - | $138,100.00 | $- | |
| 2367 | 3 | Cryoprotectant Solution | - | - | $180,000.00 | $- | |
| 9834 | 3 | Guidance Systems | - | - | $112,000.00 | $- | |
| 9846 | 3 | Planetary Vehicles | - | - | $130,500.00 | $- | |
| 9848 | 3 | Robotics | 135 | 405 | #FIELD! | #FIELD! | |
| 12836 | 3 | Transcranial Microcontrollers | - | - | $117,000.00 | $- | |
| 17136 | 3 | Ukomi Superconductors | - | - | $148,800.00 | $- | |
| 17392 | 3 | Data Chips | - | - | $145,900.00 | $- | |
| 17898 | 3 | High-Tech Transmitters | - | - | $93,670.00 | $- | |
| 28974 | 3 | Vaccines | - | - | $96,350.00 | $- | |
| On Hand P3 Inventory | #FIELD! |
The #FIELD is potentially from a #CALC limit being hit on the _STREAMING function and thus the .price field is missing. That’s at least what I think doing a .price pop on a #CALC will do.
The #CALC error will be thrown on _STREAMING functions once you’ve hit 100 of them. It’s a safeguard so the add-in doesn’t crash and end up sending thousands of market order requests to esi ending in a ban.
Do you know how many active _STREAMING function you’ve got going?
Sidenote: I’ll most likely add a notification to the sidebar in a future patch when the limit is hit so it’s more noticeable, that’s something that’s useful.
I did a find/replace and removed _STREAMING. There were a total of 92 of them on the 1 page. So that would likely explain what I was seeing. It was mainly odd because it was mostly happening on the values that I wanted to see. LOL
man, I just don’t get it…that weird error that shows up https://d.docs.live.net/Appliblah....blah....blah.... showed up after I had been sitting with the spreadsheet open for hours playing with formulas. As soon as I did a copy/drag it spread like wildfire and I had to do a find/replace. And now, almost 2 hours after dropping some stuff off in a station that’s watched by a formula it STILL hasn’t updated. I’ve restarted EVE, Excel, everything…no updates…
damned annoying
Jesus Christ. Just closing and reopening the sheet slammed that error everywhere. It now sees the inventory I put in, but I have to find/replace everywhere to fix what the addin broke.
I’m drunk and angry at this point. Seriously considering a macro to find/replace as soon as the workbook is opened because the add-in has a self-destruct ‘feature’
Can you fill this out for me so I can include it in the bug report to Microsoft about the d.docs.live.net replacement of formulas in the framework?
Platform [PC desktop, Mac, iOS, Office on the web]:
Office version number [Should be under Account → About]:
Operating System:
Platform - MacOS
Office Version - Excel for Mac version 16.79.1
License: Microsoft 365 subscription
Operating System: MacOS 12.7.1 (Desktop) and 14.1.1 (Laptop)
Something new I’m seeing with regard to the https:// d.doc.live.net thing…Now when I close down the sheet I am seeing a pop-up window that says "saving to https://… (it comes and goes too fast for me to read it all)
I’ve never gotten that before today, but the few times I have shut the sheet down and reopened it it has appeared to be (mostly) error free. The only annoyance is having to enable content. I can’t seem to get around letting it auto-enable.