EVEONLINE.BLUEPRINT_EXPLOSION() wrong calculation?

EVE Technology and Research Center EVE x Microsoft Excel Add-in
1

Taking a Vagabond BP as an example I can’t figure out how the above function calculates the composite materials needed.

For quantity of 1 it spits out Ferrogel quantity in components of 200 but in reality for a 0/0 Vagabond blueprint without any structure bonuses it should be:

Plasma Thruster (75 needed) → 75 Ferrogel
Deflection Shield Emitter (450 needed) → 450 Ferrogel

Am I missing something here? Is someone able to reproduce it or has a solution how to properly calculate the composite materials needed for T2 production?

2

eveonline.blueprint_explosion(vagabond BP ID, qty 1)

Yes, I can reproduce it showing 275 Ferrogel.

Ok, so we are obviously doing something wrong in our coding,

*1st edit :man_student:

1 Like
3

Is someone able to fix this or knows a workaround?

Calculating mats for T2 production seems like a guess game like that

4

The recursion makes the explosion a tricky function, I can add a note to debug this specific flow but it’s a messy process, helps to know which material its messing up though.

I mostly tested it on T2 battleships, and got it close enough, but sadly something is going haywire.
Since it’s a 0/0 calculation the gain of spending effort on it is kinda low, but I’d ofc want it to be working. I’ll see if I can get some time to look at this specific instane.