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:
<tbody>
</tbody>
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:
This is what I have in Excel:
| EI | P (W) | P (kW) | TT | #Res |
| =(((1000/B2)+C2)*D2*E2*1000)*(3600/1)<strike></strike> | 1190 | 0 | 11.4 | 3 |
<tbody>
</tbody>
<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.
</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.
Last edited:
