Build is processing and will deployed soon on production. Soft update that will require a CTRL+F5 to refetch updated files, and/or clearing the addin cache if these functions are something you want to use straight away.
New functions:
Adding a schematics function and the data to pins for factory schematics, .EVEONLINE.SCHEMATIC supports both schematic ids and searching by the type_id of the output type_id for a schematic. Shows input and output quantities, and makes more visible what factories are producing.
Adding SEARCHSTATIONS function that searches SDE data for NPC stations by station name.
Addding STUCTURESEARCH that searches ESI via the search endpoint. Requires a logged in character.
New Parameters to existing functions
Adding an optional end_location_filter to CORPORATION_CONTRACTS that will prefilter based on location_id.
** (Useful for more easily showing fleet ship contract stocks at frontlines for corporations)
CHARACTER_STANDINGS now has an optional “id” filter that will output the standings of the matching corporation/faction directly into the cell for easier calculation and checking that use standings.
**Example: .CHARACTER_STANDINGS(character_id,500010) to check the Guristas faction standings of a character
Bugfixing:
Rework of the logic behind .blueprint_explosion to better work with complicated blueprints. (ME 0 and no bonus applied to all calculations), rogue blueprints in the SDE might cause issues.
Bugfix for duplicated entries in character_journal
Invalid/Expired character tokens should be handled better and logout the characters affected by invalid tokens so they can be logged back in. Previous version was only hiding them from the sidebar, until a user refreshed the site.
At this point I am almost positive that is the save process when closing the files that is creating my find/replace issue.
You can see here the save function that has been popping up. At this point the sheet is functioning perfectly because I have already gone in the done the find replace.
The update for cells requires a manual update unless you do F9 to recalculate the entire sheet, or link it to another cell(like region_id or station_id and hit enter on that, with auto calculation mode on that is)
CTRL+F5 then restarting excel, if the new functions dont appear loaded in.
There is also File->Options->Trust Center->Trust Center Settings(Button) → Trusted Add-in Catalogues(sidebar) → Next time office starts, clear all previously-started web add-ins cache.
“Save external link values” seems to be linked to using other workbooks as references in workbooks, and upon saving it saves the values instead of just the formula. Unknown if it messes with our entity framework in use for almost all the things.
Oh and I recommend saving cells that are static data as Values, that way you won’t have to find+replace them when mac excel decides its time to massacer the addin customfunction link. Such a strange error.
Yeah I’ve done that in a couple of spots already. I found that if I reference a call that has a static value card from the admin that I cannot reference it.
For instance, the below table is used as a lookup reference. If I have those station types (Raitaru, Azbel, Sotiyo) as static cards for the respective stations the formulas cannot refer to them as a lookup. In this case I had to change them to plain text.
1.5.1 scheduled for release tomorrow/this weekend to add new SDE files. (1 new blueprint)
Also includes an improved fallback type fetching from ESI method that was stealth patched into 1.5 and is the functionality telling you what shiny new filaments you have in character_assets list are, instead of a blank text cell with an unresolved type_id.
Oh and .volume_packaged (repackaged volume for ships etc.) should get added to the .TYPE cards in 1.5.1 via everef repackagedvolume.json merged into the addins fuzzworks supplied invTypes.csv
Updated imageMappings helper file for rendering .image on type cards
Updated sidebar example commands with schematic, searchstation and structuresearch
Add-in will now fallback to ESI if the type_id exists in the ESI but not in the SDE (via everef /types)
.TYPE cards will now include .volume_packaged for ships packaged sizes.
market_struture_orders_stats will now return #VALUE if the character token is not valid, or missing ACL.
cache timers for _SKILLS and _SKILL_QUEUE are now the same value.
New blueprints.yaml and staStation.yaml files from SDE.
note, the base .csv files for many things such as solarsystems, invTypes and dogma are still on the old SDE version.
Once fuzzworks.co.uk is updated to latest, we will update the files* with a soft patch, for the new ships dogma attributes, and correct security status for security status bumped systems.
(to etip Agittain: AFAIK ESS Escrow is still missing form the ESI data)
Has all the current issues logged, maybe commenting in the ESS escrow thread will help?
I’m don’t know much about what is being worked on in regards to ESI, so I just don’t know if there is hope or not. Data completion and parity to in game views for transactions is always nice so I personally hope it makes it.
I’m rolling back the volume_packaged for now and readding it later, the invTypes.csv injection seems to have broken the inventorysearch once it’s deployed.
For the save as xldudf and such errors, this might be the fix, basically can you try disabling the analysis and solver default addins in excel? (or show me what default addins are in a mac excel?)
the invalid token logic removed from the add-in. Since it was removing characters if eve was down during the refresh of token, or if the users network was offline. Now it will just display an error in the sidebar. Users have to manually readd characters with properly invalid tokens.
Includes Latest SDE as well for 2 new AT ships, and proper marketgroup_id for expired filaments in assets
blueprint_type_id synced to corporation_industry_jobs like the character version of the function
