I’m trying to pull criminal connection skill level but I cant seem to figure out the string part, I know the char id, and the char skill # (3361),
I imported the some standings but in game is different, Im assuming that the eve addon doesn’t pull standings which include skills…
any ideas?
Here is what I use.
In the left cell I filter for a specific skill:
=IF(ISERROR(EVEONLINE.CHARACTER_SKILLS(C12,"Interplanetary Consolidation",1)),"Interplanetary Consolidation Skill not injected",EVEONLINE.CHARACTER_SKILLS(C12,"Interplanetary Consolidation",1))
In the right cell it shows the skill level:
=IF(ISERROR(D12.active_skill_level),0,D12.active_skill_level)
Some more info here.
=IF(ISERROR(EVEONLINE.CHARACTER_SKILLS(C12,“Interplanetary Consolidation”,1)),“Interplanetary Consolidation Skill not injected”,EVEONLINE.CHARACTER_SKILLS(C12,“Interplanetary Consolidation”,1))
C12 references the character
=IF(ISERROR(D12.active_skill_level),0,D12.active_skill_level)
D12 references the value returned by the first formula
The IF/ISERROR just allows me to cleanly account for errors and make it look nice. It makes it so that if I do not have the skill it returns “Skill not injected” rather than an error.
Like this:
OldGuyMonty good day. in other posts, you posted a screenshot of the table with the caveat that you posted the entire table somewhere on the forum. I’ve looked at a lot of different excel topics and haven’t found any. could you please post the table again to familiarize yourself with its functionality?