#Isboxer eve online 2017 free#

In conjunction, a separate team of developers had introduced a shield-hp bonus implant set 'Shield Slaves' however, will be soon(tm) nerfing the HP of caps/supers. They have recently been involved in a 'Resource Shakeup', where they have removed 90% of the ore from the normal nullsec mining anomalies and plan to remove the ability to generate minerals from moons. Unfortunately, my older version of jEVEAssets didn't save prior historical data and EveKit was discontinued winter 2019.Д®ither way, the table above doesn't include the 11 fully-fit Rorquals with sets of both Ore and Ice Excavators.ДЄs things go, CCP has been predictable in its behavior.

#Isboxer eve online 2017 free#

Google Sheets also has its own API that users can use to use with external scripts, written in languages like Python, to work with data.ДЇor more information on that topic, feel free to check out the following tutorial: In a future post, I will share using Python and Mongo's NoSQL database for requesting this information and storing it in a usable form, such as for Google Sheets.

This becomes especially relevant when facing rate limits from API's - problem faced with this current spreadsheet project.ДЇixes might include writing custom functions for requesting the data from both zKillboard's API and ESI to prevent unwanted requests when making changes and specify the timing of requests. Once this data is loaded, it's a simple matter of then utilizing basic filtered aggregation functions, such as =sumifs() to summarize the data.ДЇollowing the schema from the individual sheets for each alliance, a 'Summary' worksheet can be used to consolidate data from the individual sheets.ДЇinally, vlookup functions are used in the 'Summary' sheet to put everything together for both user-friendly tables and charts.ДЄs previously mentioned, Google Sheets has limitations when it comes to importing data from external sources. I'm sure that this could be optimized however, functionally, this layered approach has seemed to work. This issue became apparent when initially generating a sheet that used the three query functions across separate columns. Likewise if querying based on the 'location flag' for the item. In some instances, if a query is done for quantum cores, based on their typeID, then a false negative may appear. The ESI responses for structure killmail quantum cores can vary, which results in needing multiple query functions. You will notice the spaghetti for the last formula. = IF ( ISBLANK ( A2 ), , IF ( IFERROR ( VALUE ( IFERROR ( IFERROR ( QUERY ( ImportJSON ( CONCATENATE ( '', A2, '/', B2, '/?datasource=tranquility' ), '/victim/items', 'noInherit' ), 'select Col2 where Col2='' & Types!B2:B9 & '' ', 0 ), INDEX ( QUERY ( ImportJSON ( CONCATENATE ( '', A2, '/', B2, '/?datasource=tranquility' ), '/victim/items', 'noInherit' ), 'select Col2 where Col2>'50000' ', 0 ), 2 ) ), QUERY ( ImportJSON ( CONCATENATE ( '', A2, '/', B2, '/?datasource=tranquility' ), '/victim/items', 'noInherit' ), 'select Col2 where Col1='180' ', 0 ) ) ) ) > 52000, IFERROR ( VALUE ( IFERROR ( IFERROR ( QUERY ( ImportJSON ( CONCATENATE ( '', A2, '/', B2, '/?datasource=tranquility' ), '/victim/items', 'noInherit' ), 'select Col2 where Col2='' & Types!B2:B9 & '' ', 0 ), INDEX ( QUERY ( ImportJSON ( CONCATENATE ( '', A2, '/', B2, '/?datasource=tranquility' ), '/victim/items', 'noInherit' ), 'select Col2 where Col2>'50000' ', 0 ), 2 ) ), QUERY ( ImportJSON ( CONCATENATE ( '', A2, '/', B2, '/?datasource=tranquility' ), '/victim/items', 'noInherit' ), 'select Col2 where Col1='180' ', 0 ) ) ) ), ) ) = IF ( ISBLANK ( A2 ), , ImportJSON ( CONCATENATE ( '', A2, '/', B2, '/?datasource=tranquility' ), '/victim/ship_type_id', 'noInherit,noHeaders' ) ) In order to automatically expand the requests, based on the killmailID and Hash in the respective row, the following formulas are used: The next step is to obtain data from the EVE API (ESI). This is used for the purposes of only outputting killmails from after CCP introduced the Quantum Core update. *Note: You will notice the filter 'Select Col1,Col3,Col5 where Col1>'' & zKillboardAPI!A26 & '' ', 1 ) ) Google's Query function is used to both combine the data from the three sheets:, 'Select Col1,Col3,Col5 where Col1>'' & zKillboardAPI!A26 & '' ', 1 ) ), 1, False ) )