# Need a little help figuring out a formula related to Blueprint Research

**URL:** <https://forums.eveonline.com/t/need-a-little-help-figuring-out-a-formula-related-to-blueprint-research/481995>\
**Category:** EVE x Microsoft Excel Add-in\
**Created:** [April 3, 2025, 1:05am UTC](https://forums.eveonline.com/t/need-a-little-help-figuring-out-a-formula-related-to-blueprint-research/481995 "2025-04-03T01:05:04Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Elathy\_Maricadie](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/elathy_maricadie/32/379496_2.png) [@Elathy\_Maricadie](https://forums.eveonline.com/u/Elathy_Maricadie)\
**Post date:** [April 3, 2025, 1:05am UTC](https://forums.eveonline.com/t/need-a-little-help-figuring-out-a-formula-related-to-blueprint-research/481995/1 "2025-04-03T01:05:04Z")

</div>

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:  
 ![image](https://global.discourse-cdn.com/eveonline/original/4X/1/7/a/17ae9108e063be73e2dbbddec0f2cf1d1b71d150.png)

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.

 ![image](https://global.discourse-cdn.com/eveonline/original/4X/c/2/0/c209156fd407df652177c02538b97b9e101294e8.png)

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.