I’m trying to figure out a way to calculate the research time required to max out the ME/TE levels. For this I need a way to get the accurate Blueprint Rank for use in this formula:
Given the list of Blueprint Ranks on the EVEuni wikipedia I’ve come up with this list of possible ranks (removed all ranks related to T2 BPOs), I could write each Blueprint name in the appropriate cells but that would make it impossible to pinpoint the exact rank as Excel cannot do manipulation of Arrays in an Array.
I’ve thought that maybe I could somehow compare a Blueprint’s group_id with a CSV string in the cell for each rank. However I cannot figure out how to find the group_id based to the type_id.