Energy Intesity Formula

[Nanaia]

I've been trying to put the formula for energy intesity into an Excel spreadsheet and seem to be having a brain block on how to get it to work. I'm trying to wrap my head around the subject and want to use this as a checker. I want it set up so you can enter the power input, the takt time, and the number of resources and have it calculate the answer for Energy Intensity but can't seem to get it to give me the correct answer.

The written formula is: Energy Intensity (EI)=Power Input (P) x Customer Takt Time (TT) x number of resources (#Res).

An example of the formula is:

EI​

_Assembly

(Wh) = (760 W+ 430 W)(11.4 s)(3)(h/3600s) = 11.305 Wh

This is what I have in Excel:
​

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]EI[/TD]
[TD]P (W)[/TD]
[TD]P (kW)[/TD]
[TD]TT[/TD]
[TD]#Res[/TD]
[/TR]
[TR]
[TD]=(((1000/B2)+C2)*D2*E2*1000)*(3600/1)<strike></strike>[/TD]
[TD]1190[/TD]
[TD]0[/TD]
[TD]11.4[/TD]
[TD]3[/TD]
[/TR]
</tbody>[/TABLE]

_{^{<strike>
</strike>}}I have B2 in case the information is in Watts, entering 1 in it if it's not used since zero causes an error but I'm not confident about it, and C2 is to be used when the information is in kW. The only thing I can think is affecting it would be how I have the (h/3600s) put in there.
​

 

[bobsan42]

=(b2+c2*1000)*(d2/3600)*e2

 

[Nanaia]

It gives the correct answer. Thank you!

 

[shg]

The reason the 1000 is there is because the header says kW