PPRuNe Forums - View Single Post - Any Excel gurus out there?
View Single Post
Old 2nd April 2006 | 00:01
  #3 (permalink)  
BOFH
Bludger extraordinaire
 
Joined: Jan 2005
Posts: 194
Likes: 0
From: London/Frankfurt
Judging by your figures, I'd say buy tungsten!

Been Accounting is right - I'd do something like this:
IF(B1 > 0 THEN B1 = B1 * <proportion>, {else} B1 = {cost of bulb})

.. and copy it down the range. The whole idea is that you are decrementing until you hit zero, then you bounce up again. Plotted against time, you should see eight bounces on the tungsten side for every CFL bounce.

BOFH
BOFH is offline