Any details on the new excel integration?

Communications Center General Discussion
1

Hi folks:

CCP announcement: The Microsoft Excel add-in is coming! | EVE Online

I am a trader. All I care about is:

Will it have all the market orders in the universe? Or just stuff that only applies to my own api?

Thanks.

2

Lookup
spreadsheets in space

Official game news:

Closed up discussion:

1 Like
3
  • Why Excel and not Libreoffice or both?
  • Why Microsoft Store and not freely downloadable? → not everyone has and wants a Microsoft Account
  • Why a plugin at all and not just a simple export UI from within EVE that writes to an openly readable format like CSV?
1 Like
4

It is live now :slight_smile:
(sorry for my scribbles hehe)

Open new/old file, then

Excel_Add-In_1
Excel_Add-In_11426Ă—713 66.5 KB

(wait a minute for add-in to load up or use left direction button to show tool menu and hit reload)

accept license terms, next login into your account and MFA-it

Excel_Add-In_2.PNG
Excel_Add-In_2.PNG1471Ă—703 109 KB

Excel_Add-In_3.PNG
Excel_Add-In_3.PNG1433Ă—689 109 KB

almost there, now choose your character and authorize access to its data

Excel_Add-In_4.PNG
Excel_Add-In_4.PNG1487Ă—685 107 KB

Excel_Add-In_5.PNG
Excel_Add-In_5.PNG1494Ă—697 269 KB

Now enjoy your info-smorgasbord

Excel_Add-In_6
Excel_Add-In_61599Ă—989 104 KB

Or just click MS Store link:
https://pages.store.office.com/addinsinstallpage.aspx?assetid=WA200005228&rs=en-US&correlationId=c1b15236-2343-c81c-06f3-4583409ebe47

3 Likes
5

Done all that, the functions just show #NAME? error, any ideas ?

2 Likes
6

it only works with a 365 licence not the standalone office packages.

6 Likes
7

Had hoped to be able to get faction/corp/agent standings

8

There is some more options in the right pane below your character. Have you looked there?

9

Is there any feedback/issues threads anywhere I missed?

ie. the function for .CHARACTER_IMPLANTS inserts =EVEONLINE.CHARACTER_CHARACTER_IMPLANTS()
(notice the extra CHARACTER_ - which causes it to just say #NAME? until manually removing the CHARACTER_ in the function)

same error for .CHARACTER_FITTINGS.

  • when inserting from the Public/Character/Corporation tabs below the character selection/add character.
10

Doesn’t work in Excel 2021 :frowning:

5 Likes
11

The plugin installs fine but it doesn’t work correctly, the beta excel, ( EVE_x_MS_Excel-workbook-sample ) doesn’t work either, in character when you try to make it recognize the data it doesn’t.
If someone manages to solve the problem, enlighten us with your wisdom, thanks ^^.

1 Like
12

For me it just works :thinking:

image
image1487Ă—590 78.1 KB

Microsoft® Excel® for Microsoft 365 MSO (Version 2305 Build 16.0.16501.20074) 64-bit

Would you mind posting the formula you are trying to use? Some of them, when you click Try it out are entered with some example data. Like

=EVEONLINE.CHARACTER_ASSETS(;"Rifter")

The first argument may be given char id value, and the second is search string to search in all inventory items. There is even a tooltip when you click formula name in formula box:
image

13

There is even official help page

It was advertised today here

14

How do I get a solar system id for the formules?

15

As it was mentioned in the thread - it does not work with a standalone version of MS Excel (in my case - 2019 x64).
I get the warning which roughly translates (as i’m running non-english version of Excel) as “This add-on is only supported if you have Office365 subscription. Your Office license is not supported.” And, as i really don’t have Office365 subscription, this is sad.

2 Likes
16

The only way that comes to my mind is through ESI Swagger Interface
https://esi.evetech.net/ui/#/Universe/post_universe_ids
click Try it out

In the value model field enter list of name to search, like that:

[
  "Intaki"
]

Then hit Execute, and the response body field further below should show something like this:

{
  "systems": [
    {
      "id": 30003788,
      "name": "Intaki"
    }
  ]
}

You can enter any names that show around in EVE Online. Entering this:

[
  "Damhest",
  "Elinore en Divalone"
]

results in this:

{
  "characters": [
    {
      "id": 1907567787,
      "name": "Damhest"
    },
    {
      "id": 2120819548,
      "name": "Elinore en Divalone"
    }
  ]
}
1 Like
17

Wow this resource is fantastic! Thank you :slight_smile:

18

Hey all!

For those wondering what versions of Microsoft Excel this is compatible with.

Excel custom functions are available on the following platforms.

  • Office on Windows

    • Microsoft 365 subscription
    • retail perpetual Office 2016 and later

  • Office on Mac

  • Office on the web

Excel custom functions are currently not supported in the following:

  • Office on iPad
  • volume-licensed perpetual versions of Office 2019 or earlier
1 Like
19

There is actually a formula for getting solar system id by name :smiley:

image

you can chain it with another formula to get id for other functions or just enter formula:

=(EVEONLINE.SEARCHSOLARSYSTEM("Intaki")).id

to get
image

This is less cumbersome in use than ESI :thinking:

20

what about this?