Release Component Calculator for Blueprints

[Nerix]

I posted this already in the engineering forum, but thought this might be a good place to share as well (thanks CMDR amcb10 for the hint).

I created a Component Calculation Tool where you can input the blueprints (+grade +number of rolls) and receive a table with the number of required components you have to farm based on your input. I was tired to calculate it manually, especially with the amount of upgrades I plan to do with 3.0.

Link: https://docs.google.com/spreadsheets/d/1dPSH7nbyVf7A7Y7KhLj7_OYTErZZRX1PX5DfsYkXdg0/edit?usp=sharing

[...]

https://docs.google.com/spreadsheets/d/1dPSH7nbyVf7A7Y7KhLj7_OYTErZZRX1PX5DfsYkXdg0/edit?usp=sharing

 

[Nerix]

Just made an update, column I (amount of required components) now auto-sorts whenever the input in column B to D is edited. Would be nice if someone could confirm it works for him.

 

[Nerix]

Updated manual, as a specific user behaviour can lead to #N/A error.

 

[Nerix]

Fixed a blueprint (wrong materials were listed).

 

[amcb10]

What would be really good is if it calculated all mats needed to go from grade 1 to say 4 or 5.

I and probably others struggle with this but recently used 1,3,5,7,9 as the total rolls needed for each grade and it worked well.

Just a thought.

 

[Nerix]

What would be really good is if it calculated all mats needed to go from grade 1 to say 4 or 5.

I and probably others struggle with this but recently used 1,3,5,7,9 as the total rolls needed for each grade and it worked well.

Just a thought.

I agree, but that number is influenced by the engineer level and rng. So I think it's best if you can input the number of rolls manually. Eventually I'll include some guideline numbers.

 

[amcb10]

I totally agree with you but each CMDR must have an idea how many roles for each grade it will take. On that basis there could be 5 boxes that are populated by said CMDR that are used to calculate total material required to achieve the grade chosen.

 

[Nerix]

Update: fixed a bug (a few cells didn't have the correct formula, which led to not showing any materials despite choosing a recipe)