These forums have been archived and are now read-only.

The new forums are live and can be found at https://forums.eveonline.com/

EVE Technology Lab

 
  • Topic is locked indefinitely.
 

newb question excel and xml please help!
Author
Previous Topic Next Topic
Sexy Lovebottom
Hostile.
PURPLE HELMETED WARRIORS
#1 - 2011-12-13 15:11:18 UTC  |  Edited by: Sexy Lovebottom
I have a technical question maybe one of you can give me some advice, I cant find the answer for the sake of it..
anyway, here it goes:

I am using director lvl api to pull corp member lists from the web into an excel spreadsheet for member tracking.
This will give me a complete list of characters with several columns such as pilot name, ID, location and whatnot.
Great.

Now, I want to manually append another column to this list, to assign a certain note next to an api-pulled member name.
The problem now is that when I refresh the api data, everything will be sorted automatically (lines being deleted and added as pilots come and go), without the manually entered column being sorted with it together.

There must be a simple way to just 'link' the manually entered fields to the api-fetched fields in excel??

can anyone help me out here?
Max Kolonko
Caldari Provisions
Caldari State
#2 - 2011-12-13 21:14:26 UTC
Sexy Lovebottom wrote:
I have a technical question maybe one of you can give me some advice, I cant find the answer for the sake of it..
anyway, here it goes:

I am using director lvl api to pull corp member lists from the web into an excel spreadsheet for member tracking.
This will give me a complete list of characters with several columns such as pilot name, ID, location and whatnot.
Great.

Now, I want to manually append another column to this list, to assign a certain note next to an api-pulled member name.
The problem now is that when I refresh the api data, everything will be sorted automatically (lines being deleted and added as pilots come and go), without the manually entered column being sorted with it together.

There must be a simple way to just 'link' the manually entered fields to the api-fetched fields in excel??

can anyone help me out here?


first thing i can think of is vlookup.

create separate list of players (ID + Your Notes) that will have to be manully appended when new players will join.

Than just vlookup those notes to your api-supplied list

Read and support: Don't mess with OUR WH's What is Your stance on WH stuff?
Sexy Lovebottom
Hostile.
PURPLE HELMETED WARRIORS
#3 - 2011-12-14 00:10:09 UTC
Thanks thanks thanks!! This does the trick! Never heard of this function before, but its very very useful!
Max Kolonko
Caldari Provisions
Caldari State
#4 - 2011-12-14 07:29:43 UTC
Sexy Lovebottom wrote:
Thanks thanks thanks!! This does the trick! Never heard of this function before, but its very very useful!


It sure is :)

Read and support: Don't mess with OUR WH's What is Your stance on WH stuff?