Science & Industry

Hello my indy friends, here is my problem:

Couple weeks ago i wanted to create a little excel spreadsheet to make me easier to see which T1 and T2 rigs are worth building and which are not.
Since i'm very noob to excel import materials requirement from a database isn't smth i'm able to do easily and manually "write" material requirements for each single rig available in game is absurd work i started searching around if there were some "formula" to calculate it with the awesome drag excel's function. Found out some Dev Forum post/blog post where they stated each rigs size material requirement were 1/5 of the upper size material requirements, so:

large rig = capital rig material / 5
medium rig = large rig material /5 (or possibly capital rig material /25 ?)
small rig = medium rig material /5 (or possibly large /25 or capital /125)

with that in mind i started placing in my excel sheet capital rig requirements and used simple function to fill numbers of large/medium and small rigs, all using round to closest unit function.
Then i started do some check on random rigs and all seemed right untill i stumbled into T2 Memetic Algorithm Bank II and Hyperspatial Velocity Optimizer II (Note: referring to ME 0 material requirements since it should be the base to calculate all the ME savings)

In game stats (material names aren't important) What iget with 1/5 rounded to up math
Memetic Algorithm Bank II
Capital 120 - 60 - 150 took as base to do maths
Large 24 - 12 - 30 24 - 12 -30 Right!
Medium 5 - 3 - 6 5 - 3 - 6 Right!
Small 1 - 1 - 1 1 - 1 - 2 <---- wrong

Hyperspatial Velocity Optimizer II
Capital 105 - 158 - 150 took as base to do maths
Large 21 - 32 - 21 21 - 32 - 21 Right!
Medium 5 - 6 - 5 5 - 7 - 5 <---- wrong
Small 1 - 1 - 1 1 - 2 - 1 <--- wrong


Tried to round to next unit, round to lower unit, doing divisions from rounded number and from not rounded... if a numbers becames right another one becames wrong.

Not that 1 unit will change prices of a lot... but it fucks the shopping list though


Anyone able to help me to figure it out? (getting mad)

Ehehe i thought i would had that answer from someone and would be ended up there on your site :)

Alredy tried to use your DBs (awesome service btw !! ) but not easy for a excel noob like me to filter out stuff i need from what i don't. Anyway guess i need to climb the rope!

Thx again for your reply!

o7