decline.xlsx

	A	B	C	D	E	F	G	H	J	K	L	M
1	Year	NRE decline	NRE diff	NRE + RE	Total divert	RE avail/year	RE cum avail	Total energy	Total avail 1%	Total avail 3%	Total avail 5%	Total avail BE
2	0	100.0000	0.0000	100.0000	5.0000	2.5000	2.5000	97.5000	99.5000	98.5000	97.5000	98.1921
3	1	95.0000	5.0000	97.5000	4.8750	2.4375	4.9375	97.5625	95.5225	96.5525	97.5625	96.8656
4	2	90.2500	9.7500	95.1875	4.7594	2.3797	7.3172	97.7453	91.7489	94.7470	97.7453	95.6701
5	3	85.7375	14.2625	93.0547	4.6527	2.3264	9.6436	98.0455	88.1689	93.0772	98.0455	94.6004
6	4	81.4506	18.5494	91.0942	4.5547	2.2774	11.9209	98.4604	84.7730	91.5368	98.4604	93.6513
7	5	77.3781	22.6219	89.2990	4.4650	2.2325	14.1534	98.9874	81.5520	90.1202	98.9874	92.8180
8	6	73.5092	26.4908	87.6626	4.3831	2.1916	16.3449	99.6244	78.4971	88.8218	99.6244	92.0960
9	7	69.8337	30.1663	86.1787	4.3089	2.1545	18.4994	100.3692	75.6000	87.6364	100.3692	91.4809
10	8	66.3420	33.6580	84.8415	4.2421	2.1210	20.6205	101.2198	72.8529	86.5592	101.2198	90.9687
11	9	63.0249	36.9751	83.6454	4.1823	2.0911	22.7116	102.1747	70.2484	85.5854	102.1747	90.5556
12	10	59.8737	40.1263	82.5853	4.1293	2.0646	24.7762	103.2322	67.7793	84.7105	103.2322	90.2378
13	11	56.8800	43.1200	81.6562	4.0828	2.0414	26.8176	104.3910	65.4388	83.9305	104.3910	90.0121
14	12	54.0360	45.9640	80.8536	4.0427	2.0213	28.8390	105.6499	63.2206	83.2413	105.6499	89.8751
15	13	51.3342	48.6658	80.1732	4.0087	2.0043	30.8433	107.0078	61.1186	82.6392	107.0078	89.8239
16	14	48.7675	51.2325	79.6108	3.9805	1.9903	32.8336	108.4638	59.1270	82.1206	108.4638	89.8556
17	15	46.3291	53.6709	79.1627	3.9581	1.9791	34.8126	110.0172	57.2403	81.6821	110.0172	89.9674
18	16	44.0127	55.9873	78.8253	3.9413	1.9706	36.7833	111.6673	55.4533	81.3206	111.6673	90.1569
19	17	41.8120	58.1880	78.5953	3.9298	1.9649	38.7481	113.4137	53.7610	81.0330	113.4137	90.4217
20	18	39.7214	60.2786	78.4696	3.9235	1.9617	40.7099	115.2560	52.1587	80.8164	115.2560	90.7595
21	19	37.7354	62.2646	78.4452	3.9223	1.9611	42.6710	117.1940	50.6420	80.6682	117.1940	91.1682
22	20	35.8486	64.1514	78.5196	3.9260	1.9630	44.6340	119.2276	49.2065	80.5858	119.2276	91.6460
23	21	34.0562	65.9438	78.6902	3.9345	1.9673	46.6013	121.3569	47.8483	80.5667	121.3569	92.1909
24	22	32.3534	67.6466	78.9546	3.9477	1.9739	48.5751	123.5820	46.5635	80.6088	123.5820	92.8013
25	23	30.7357	69.2643	79.3108	3.9655	1.9828	50.5579	125.9032	45.3485	80.7098	125.9032	93.4755
26	24	29.1989	70.8011	79.7568	3.9878	1.9939	52.5518	128.3208	44.1999	80.8678	128.3208	94.2121
27	25	27.7390	72.2610	80.2908	4.0145	2.0073	54.5591	130.8353	43.1142	81.0808	130.8353	95.0096
28	26	26.3520	73.6480	80.9111	4.0456	2.0228	56.5819	133.4474	42.0885	81.3469	133.4474	95.8669
29	27	25.0344	74.9656	81.6163	4.0808	2.0404	58.6223	136.1577	41.1197	81.6646	136.1577	96.7827
30	28	23.7827	76.2173	82.4050	4.1202	2.0601	60.6824	138.9671	40.2050	82.0321	138.9671	97.7559
31	29	22.5936	77.4064	83.2759	4.1638	2.0819	62.7643	141.8764	39.3417	82.4480	141.8764	98.7855
32	30	21.4639	78.5361	84.2282	4.2114	2.1057	64.8700	144.8868	38.5274	82.9109	144.8868	99.8706
33
34										0.3078727153
35										0.03615745431
36		Parameters
37		Decline rate		0.05
38		Divert rate		0.05
39		EROI		15
40		Lifespan		30
41		EROI/year		0.5
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
100