Eve Excel Addin - it can't be this complicated to get a character location?

EVE Technology and Research Center EVE x Microsoft Excel Add-in
1

thinking about the Eve Excel Addin. Just how complicated is it to get the character location in one formula. I may be missing something?

the best i could do was:

Assume the character name is on cell D4 (which can be found using the formula EVEONLINE.CHARACTER(A4) where cell A4 is the character ID), then the formula to find a character location is:

=EVEONLINE.STATION(SUM(IFERROR(EVEONLINE.ACTIVE_CHARACTER().location_station_id,0) * (EVEONLINE.ACTIVE_CHARACTER().name=D4.name)))

which is pretty complicated?

Has anyone managed to get a simpler formula?

And it is weird. the range of methods that can be used on the EVEONLINE.ACTIVE_CHARACTER() formula are different to the range of methods that can be used on the EVEONLINE.CHARACTER() formula. Thats what makes it all complicated. The EVEONLINE.CHARACTER() formula does not give the option to find the station location of the character.

I put this on my blog: marketsforISK: Eve Excel Addin Formulas: Characters connected to the Addin and Character Location

2

and, as ever, the community comes up with a solution

=(EVEONLINE.STATION(EVEONLINE.CHARACTER(character_id,TRUE).location_station_id))

3

Thank you.
That happened to be one of those initial entries I moved-on-from-to-come-back-later-too.

So of course I moved to a structure working out of Perimeter. So how to get an either or…? o?