water usage

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	Z
1	Date	num days	current reading	prev reading	consumption cubic meters	consumption gallons	Gallons/day	cost water	water daily charge	water usage charge	cost total	cost sewer	cost garbage	discount	Decrease from last	decrease from last season	cost per gallon	cost per cubic meter	gallons/day	Notes	fifth step (548 gallons)

2	10/1/2009	112	5141	5045	96	25360.32	226.4314286	$74.91	$50.29	$24.62	$90.91	$29.76	$32.30	$46.06			$0.000970710148768	$0.7803125	226.4314286		0
3	1/28/2010	119	5185	5141	44	11623.48	97.67630252	$54.64	$53.44	$1.20	$115.04	$31.62	$34.83	$6.05	54.17%		$0.000103604084147	$1.24181818181818	97.67630252		0
4	5/27/2010	119	5230	5185	45	11887.65	99.89621849	$56.89	$53.44	$3.45	$118.97	$31.62	$36.51	$6.05	-2.27%		$0.000290573830824	$1.26422222222222	99.89621849		0
5	10/20/2010	112	5304	5230	74	19548.58	174.5408929	$59.59	$50.29	$9.30	$123.71	$29.76	$34.36	$6.19	-64.44%	22.92%	$0.000475611016248	$0.80527027027027	174.5408929		0
6	1/28/2011	134	0	5304	51	13472.67	100.5423134	$64.79	$60.17	$4.62	$141.67	$35.61	$41.27	$7.08	31.08%	-15.91%	$0.000342815492401	$1.27039215686275	100.5423134	meter failed no reading half period
7	5/27/2011	119	29		33	8717.61	73.25722689	$57.38	$53.44	$3.94	$119.85	$31.62	$37.16	$6.31	35.29%	26.67%	$0.000452445108235	$1.73878787878788	73.25722689		0
8	9/19/2011	111	94	29	65	17171.05	154.6941441	$60.24	$49.84	$10.40	$124.41	$29.50	$34.67	$6.22	-96.97%	12.16%	$0.000605470253712	$0.926769230769231	154.6941441		0
9	1/30/2012	137	133	94	39	10302.63	75.20167883	$66.98	$61.52	$5.46	$139.40	$36.40	$43.36	$7.34	40.00%	23.53%	$0.000530109302188	$1.7174358974359	75.20167883		0
10	5/28/2012	115	168	133	35	9245.95	80.39956522	$58.88	$51.64	$7.24	$121.18	$30.56	$38.12	$6.38	10.26%	-6.06%	$0.000783088811858	$1.68228571428571	80.39956522		0
11	9/14/2012	112	235	168	67	17699.39	158.0302679	$64.15	$50.29	$13.86	$124.48	$29.76	$37.13	$6.56	-91.43%	-3.08%	$0.000782937717063	$0.957462686567164	158.0302679		0
12	1/31/2013	140	276	235	41	10830.97	77.36407143	$71.50	$62.87	$8.63	$147.45	$37.25	$46.46	$7.76	38.81%	-5.13%	$0.000797195449715	$1.74390243902439	77.36407143		0
13	5/24/2013	113	313	276	37	9774.29	86.49814159	$62.77	$50.74	$12.03	$126.56	$31.53	$38.93	$6.67	9.76%	-5.71%	$0.001230624423871	$1.69648648648649	86.49814159		0
14	9/11/2013	110	416	313	103	27209.51	247.3591818	$100.55	$49.39	$51.16	$160.68	$30.69	$37.90	$8.46	-178.38%	-53.73%	$0.001880063257295	$0.97621359223301	247.3591818		0
15	2/4/2014	141	459	416	43	11359.31	80.56248227	$78.87	$63.31	$15.56	$159.06	$39.76	$48.80	$8.37	58.25%	-4.88%	$0.001369393035316	$1.83418604651163	80.56248227		0
16	6/2/2014	123	513	459	54	14265.18	115.9770732	$76.78	$55.23	$21.55	$148.14	$36.03	$43.13	$7.80	-25.58%	-45.95%	$0.001510536845662	$1.42185185185185	115.9770732		0
17	10/10/2014	126	673	513	160	42267.2	335.4539683	$172.23	$56.58	$115.65	$230.75	$36.91	$33.76	$12.15	-196.30%	-55.34%	$0.002736186925086	$1.0764375	335.4539683		0
18	2/10/2015	121	712	673	39	10302.63	85.14570248	$73.70	$54.33	$19.37	$135.15	$35.96	$32.61	$7.12	75.63%	9.30%	$0.001879729738911	$1.88974358974359	85.14570248	0
19	6/17/2015	133	787	712	75	19812.75	148.9680451	$93.50	$59.72	$33.78	$162.21	$40.91	$36.35	$8.55	-92.31%	-38.89%	$0.001704845617090	$1.24666666666667	148.9680451
20	10/27/2015	131	54	0	69	18227.73	139.1429771	$90.84	$58.82	$32.02	$158.59	$40.30	$35.80	$8.35	8.00%	56.88%	$0.001756431546879	$1.31652173913043	139.1429771
21	2/29/2016	119	87	54	33	8717.61	73.25722689	$77.39	$53.44	$23.95	$140.11	$37.42	$32.67	$7.37	52.17%	15.38%	$0.002747798995367	$2.34515151515152	73.25722689
22	06/27/2016	109	155	87	68	17963.56	164.8033028	$84.21	$48.95	$35.26	$142.04	$35.21	$30.09	$7.47	-106.06%	9.33%	$0.001963120895858	$1.23838235294118	164.8033028
23	10/11/2016	119	229	155	74	19548.58	164.2737815	$91.87	$53.44	$38.43	$155.01	$38.44	$32.85	$8.15	-8.82%	-7.25%	$0.001966088585462	$1.24148648648649	164.2737815
24					0	0	#DIV/0!		$0.00	$0.00	$0.00				100.00%	100.00%	#DIV/0!	#DIV/0!	#DIV/0!
25	08/02/2017	112	308	268	40	10566.8	94.34642857	$84.08	$50.29	$33.79	$145.91	$37.98	$31.53	$7.68			$0.003197516750577	$2.10200000000000	94.34642857
26	11/28/2017	125	428	308	120	31700.4	253.6032	$156.77	$56.13	$100.64	$231.33	$42.39	$44.33	$12.16			$0.003174723347339	$1.30641666666667	253.6032
27			458	428	30	7925.1	#DIV/0!		$0.00	$0.00	$0.00						$0.000000000000000	$0.00000000000000	#DIV/0!
28	07/06/2018	111	494	458	36	9510.12	85.67675676	$88.41	$49.84	$38.57	$169.21	$39.53	$50.18	$8.91			$0.004055317913970	$2.45583333333333	85.67675676
29	10/22/2018	152	652	494	158	41738.86	274.5977632	$223.22	$68.25	$154.97	$328.76	$54.13	$68.72	$17.31			$0.003712749222188
30	02/04/2019	99	684	652	32	8453.44	85.38828283	$80.19	$44.45	$35.74	$152.80	$35.58	$45.07	$8.04
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99