Trying to set up to find my extraction rates from extractors. Someone said this would work .CHARACTER_PLANET(character_id_or_entity, planet_id) , but im not sure how to use it. Im pretty new so i would need a step by step if anyone is nice enough to take the time.
Let A2 be =@EVEONLINE.CHARACTER_PLANETS(CHAR_ID) - the @ makes it so it only spit out the first item in the array.
Let B2 be =EVEONLINE.CHARACTER_PLANET(CHAR_ID;A2.PLANET_ID).EXTRACTORS
Let C2 be =B2#.EXTRACTOR_PRODUCT_QTY_PER_CYCLE
Let D2 be =B2#.EXTRACTOR_CYCLE_TIME
Let E2 be =(C2#/D2#)*60
All you need to do is replace CHAR_ID with the character’s ID and you’ll end up with something like this:
2 Likes
Index formula allows to to increment as well =INDEX(EVEONLINE.CHARACTER_PLANETS(C3), 2)
where 2 gets the 2nd result
=EVEONLINE.CHARACTER_PLANET(Char_ID,PlanetID).extractors is the answer the ;A2 causes a error even if you relate it to your spreadsheet.
Keen to learn more on this and to add to the thread even if it is a year laters
Can use this as well when you have multiple heads
=INDEX(EVEONLINE.CHARACTER_PLANET(Char_ID,Planet_ID).extractors, 1) Where is is the first result and you can change it to 2 for second result
1 Like