Calculate Lighting Replacement Costs peer Year I am trying to calculate the cost

Question

Calculate Lighting Replacement Costs peer Year

I am trying to calculate the cost to replace lighht bulbs every year. I have a lot of different categories

How do I take my current information and layout and transfer it to something that looks like this

Calculate Lighting Replacement Costs peer Year I am trying to calculate the cost to replace lighht bulbs every year. I have a lot of different categories and I need to assess exactly what I am going to spend on a yeear by year basis. For instance the 4 Pin Compact based on its rated life and our operating hours will need to be reeplaced at Years 2, 4, 6, 8, 10. How do I take my current information and layout and transfer it to something that looks like this

Explanation / Answer

Hi ,

Try this rather lonng formula in B10 and fill across:

=$D2*$E2*$F2*(TRUNC((B$9*$G2)/$H2)-TRUNC((N(A$9)*$G2)/$H2))+$D3*$E3*$F3*(TRUNC((B$9*$G3)/$H3)-TRUNC((N(A$9)*$G3)/$H3))+$D4*$E4*$F4*(TRUNC((B$9*$G4)/$H4)-TRUNC((N(A$9)*$G4)/$H4))+$D5*$E5*$F5*(TRUNC((B$9*$G5)/$H5)-TRUNC((N(A$9)*$G5)/$H5))++$D6*$E6*$F6*(TRUNC((B$9*$G6)/$H6)--TRUNC((N(A$9)*$G6)/$H6))

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.