Building an EVE Online Spreadsheet of my own

Hi everyone. For those That play EVE online im building my own spreadsheet for PI.
For those that don't know what it is (its a game) can you assist me in a few problems?

I need to show a flow chart of numbers associated with production values.
get a pen this gets interesting!

The production flows as this:
3000 of product (e) makes 20 units of product (c)
3000 of (f) makes 20 (d)
then,
40 of product (c) combined with 40 of (d) makes 5 of product (b)
Finally;
10 of product (b) makes 3 of product (a)

if i want to build 6 of product (a), it needs to show how many of all the others i need in their respective multiples- as 2000 of product (e) will not make (c). Also, only when (c) and (d) are combined in multiples of 40 does it make 5 of product (b)

wheres the problem?
WELL, in order to make product (a) it needs to be formatted to only show the closest value of three, and echo down the associated cells ; so i need to know how to format the cell thus.
also, it takes 10 of product (b) and 10 of product (c) in order to make 3 (a)'s. i want the product (a) to be an open cell, for the user to place their desired quantity in, and have the product (b) and (c) cells show in quantities of 10 (directly related to the product (a) cell).

endstate: if i put in that i want 100 of product (a), it shows me how many i need of all the products.

anyone able to follow me through all that?

CERTAINLY!
will try but if you can shortcut and do it while im learning them that would be dandy also (clearly im super lazy

SO, i know 3a=10b
10b= 80d+80c
80d= 12000f and 80c= 12000e.
so how do i get a number entered into field (a) to reflect the numbers i need in all other fields using excel? which formula/command do i use?

i have a number entered into cell for (a). its 3 (to make it simple :p ) to discover what b needs to be and have it rounded to the nearest 10, i have made it: f=MROUND(( product a's cell /0.3333333333333),10)

so i think i have nailed it.
if the user wants to know all the resources needed for the amount he wants to make of (a), it is now all displayed.

And this is what i get.
Now i have a new problem. I wish to create a tick box to the far right that will include/exclude products and thus create a total amount of dollars to the right.