Thread: Light selection guide.
View Single Post
Old 09-30-05, 02:51 PM
  #13  
Pampusik
File Not Found
 
Pampusik's Avatar
 
Join Date: Jun 2005
Location: Minneapolis, MN
Posts: 135

Bikes: two two-wheeled types

Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Likes: 0
Liked 0 Times in 0 Posts
Originally Posted by slvoid
=ROUND(IF(LIGHTTYPE="Halogen",(-0.0002*WATTAGE^4 + 0.0143*WATTAGE^3 - 0.4048*WATTAGE^2 + 5.5274*WATTAGE - 9.2313)-2,IF(LIGHTTYPE="HID",(-0.0002*WATTAGE^4 + 0.0143*WATTAGE^3 - 0.4048*WATTAGE^2 + 5.5274*WATTAGE - 9.2313)*1.75,(-0.0002*((WATTAGE+4)*1.1)^4+0.0143*((WATTAGE+4)*1.1)^3-0.4048*((WATTAGE+4)*1.1)^2+5.5274*((WATTAGE+4)*1.1)-9.2313))),1)
That is the best use of Excel ever! Thanks!
Pampusik is offline  
Reply