PPRuNe Forums - View Single Post - Any Excel gurus out there?
View Single Post
Old 2nd Apr 2006, 00:01
  #3 (permalink)  
BOFH
Bludger extraordinaire
 
Join Date: Jan 2005
Location: London/Frankfurt
Posts: 194
Likes: 0
Received 0 Likes on 0 Posts
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