Zoho Sheet - Lighting cost analysis

		Electricity Cost (cent/kWh)	$0.10
		Light on/Day (hrs)	4
	Data
	Reference Brand	Type	Watts	Lumens	Lumens/ Watt	Price/Bulb	Annual Operating Cost	Life (Hours)
http://genet.gelighting.com/LightProducts/Dispatcher?REQUEST=CONSUMERSPECPAGE&PRODUCTCODE=71970&BreadCrumbValues=General%20Purpose_Standard_,A19&ModelSelectionFilter=FT0010:General%20Purpose_Standard	GE A19 long life	Incandescent	57	765	13.4	$0.75	$8.32	1500
http://www.homedepot.com/webapp/wcs/stores/servlet/Navigation?id=4566&jspStoreDir=hdus&catalogId=10053&marketID=401&locStoreNum=8125&N=4566%2B90401&langId=-1&linktype=brand&storeId=10051&ddkey=THDStoreFinder	n:vision	CFL	14	900	64.3	$1.46	$2.04	10000
http://store.mypharox.com/Pharox60--6-Watt-Dimmable-LED-Bulb-40110V41_p_2.html	Pharox 60	LED	6	336	56	$40.00	$0.88	50000

	Begin Analysis
			"Years"	Hours On
			10	14600	Bulbs (round up)	"Years" elec. consumption (kwh)	Elec. Cost	Total Cost (electricity + cost/bulb)
				Incandescent	10	832.2	$83.22	$90.72
				CFL	2	204.4	$20.44	$23.36
				LED	1	87.6	$8.76	$48.76

Lighting cost analysis