Eve Excel Addin Formulas: Character Name, Skill Points.

Two simple but almost always required formulas.

Assume the Character ID is in cell B9.

Character Name

=EVEONLINE.CHARACTER(B9)

Very simple, nothing more to say.

Total Skill Points

=SUM(EVEONLINE.CHARACTER_SKILLS(B9).skillpoints_in_skill)

lets break this down.

EVEONLINE.CHARACTER_SKILLS(B9) will list all the skills a character has

adding the method .skillpoints_in_skill will then show the skillpoints in each skill

(for what its worth, i think it shows the skill Advanced Planetology with zero skill points because i once had it but extracted all the skill points in a skill farming routine.)

and the final part is to sum this list:

SUM(EVEONLINE.CHARACTER_SKILLS(B9).skillpoints_in_skill)