Renewable energy calculator

	A	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AL	AM	AN	AO	AP	AQ	AR	AS	AT	AU	AV	AW	AX	AY	AZ	BA	BB	BC	BD	BE	BF	BG	BH	BI	BJ	BK	BL	BM	BN	BO	BP	BQ	BR	BS	BT	BU	BV	BW	BX	BY	BZ	CA	CB	CC	CD	CE	CF	CG
1	* all numbers approximate, based of various estimates
2
3	World consumption (GW)	Year	2019	2020	2021	2022	2023	2024	2025	2026	2027	2028	2029	2030	2031	2032	2033	2034	2035	2036	2037	2038	2039	2040	2041	2042	2043	2044	2045	2046	2047	2048	2049	2050	2051	2052	2053	2054	2055	2056	2057	2058	2059	2060	2061	2062	2063	2064	2065	2066	2067	2068	2069	2070	2071	2072	2073	2074	2075	2076	2077	2078	2079	2080	2081	2082	2083	2084	2085	2086	2087	2088	2089	2090	2091	2092	2093	2094	2095	2096	2097	2098	2099	2100
4	152,000.00	Economy size	$80,000,000,000,000.00	$81,920,000,000,000.00	$83,886,080,000,000.00	$85,899,345,920,000.00	$87,960,930,222,080.00	$90,071,992,547,409.90	$92,233,720,368,547.80	$94,447,329,657,392.90	$96,714,065,569,170.40	$99,035,203,142,830.40	$101,412,048,018,258.00	$103,845,937,170,697.00	$106,338,239,662,793.00	$108,890,357,414,700.00	$111,503,725,992,653.00	$114,179,815,416,477.00	$116,920,130,986,472.00	$119,726,214,130,148.00	$122,599,643,269,271.00	$125,542,034,707,734.00	$128,555,043,540,719.00	$131,640,364,585,697.00	$134,799,733,335,753.00	$138,034,926,935,811.00	$141,347,765,182,271.00	$144,740,111,546,645.00	$148,213,874,223,765.00	$151,771,007,205,135.00	$155,413,511,378,058.00	$159,143,435,651,132.00	$162,962,878,106,759.00	$166,873,987,181,321.00	$170,878,962,873,673.00	$174,980,057,982,641.00	$179,179,579,374,224.00	$183,479,889,279,206.00	$187,883,406,621,907.00	$192,392,608,380,832.00	$197,010,030,981,972.00	$201,738,271,725,540.00	$206,579,990,246,953.00	$211,537,910,012,880.00	$216,614,819,853,189.00	$221,813,575,529,665.00	$227,137,101,342,377.00	$232,588,391,774,594.00	$238,170,513,177,185.00	$243,886,605,493,437.00	$249,739,884,025,280.00	$255,733,641,241,886.00	$261,871,248,631,692.00	$268,156,158,598,852.00	$274,591,906,405,225.00	$281,182,112,158,950.00	$287,930,482,850,765.00	$294,840,814,439,183.00	$301,916,993,985,723.00	$309,163,001,841,381.00	$316,582,913,885,574.00	$324,180,903,818,828.00	$331,961,245,510,480.00	$339,928,315,402,731.00	$348,086,594,972,397.00	$356,440,673,251,734.00	$364,995,249,409,776.00	$373,755,135,395,610.00	$382,725,258,645,105.00	$391,910,664,852,588.00	$401,316,520,809,050.00	$410,948,117,308,467.00	$420,810,872,123,870.00	$430,910,333,054,843.00	$441,252,181,048,159.00	$451,842,233,393,315.00	$462,686,446,994,755.00	$473,790,921,722,629.00	$485,161,903,843,972.00	$496,805,789,536,227.00	$508,729,128,485,096.00	$520,938,627,568,739.00	$533,441,154,630,389.00	$546,243,742,341,518.00
5		Energy share	$6,560,000,000,000.00	$6,717,440,000,000.00	$6,878,658,560,000.00	$7,043,746,365,440.00	$7,212,796,278,210.56	$7,385,903,388,887.61	$7,563,165,070,220.92	$7,744,681,031,906.22	$7,930,553,376,671.97	$8,120,886,657,712.10	$8,315,787,937,497.19	$8,515,366,847,997.12	$8,719,735,652,349.05	$8,929,009,308,005.43	$9,143,305,531,397.56	$9,362,744,864,151.10	$9,587,450,740,890.73	$9,817,549,558,672.10	$10,053,170,748,080.20	$10,294,446,846,034.20	$10,541,513,570,339.00	$10,794,509,896,027.10	$11,053,578,133,531.80	$11,318,864,008,736.50	$11,590,516,744,946.20	$11,868,689,146,824.90	$12,153,537,686,348.70	$12,445,222,590,821.10	$12,743,907,933,000.80	$13,049,761,723,392.80	$13,362,956,004,754.20	$13,683,666,948,868.30	$14,012,074,955,641.20	$14,348,364,754,576.60	$14,692,725,508,686.40	$15,045,350,920,894.90	$15,406,439,342,996.40	$15,776,193,887,228.30	$16,154,822,540,521.70	$16,542,538,281,494.30	$16,939,559,200,250.10	$17,346,108,621,056.10	$17,762,415,227,961.50	$18,188,713,193,432.60	$18,625,242,310,074.90	$19,072,248,125,516.70	$19,529,982,080,529.10	$19,998,701,650,461.80	$20,478,670,490,072.90	$20,970,158,581,834.70	$21,473,442,387,798.70	$21,988,805,005,105.90	$22,516,536,325,228.40	$23,056,933,197,033.90	$23,610,299,593,762.70	$24,176,946,784,013.00	$24,757,193,506,829.30	$25,351,366,150,993.20	$25,959,798,938,617.10	$26,582,834,113,143.90	$27,220,822,131,859.30	$27,874,121,863,023.90	$28,543,100,787,736.50	$29,228,135,206,642.20	$29,929,610,451,601.60	$30,647,921,102,440.10	$31,383,471,208,898.60	$32,136,674,517,912.20	$32,907,954,706,342.10	$33,697,745,619,294.30	$34,506,491,514,157.30	$35,334,647,310,497.10	$36,182,678,845,949.10	$37,051,063,138,251.80	$37,940,288,653,569.90	$38,850,855,581,255.50	$39,783,276,115,205.70	$40,738,074,741,970.60	$41,715,788,535,777.90	$42,716,967,460,636.60	$43,742,174,679,691.90	$44,791,986,872,004.50
6	Electrical Consumption	Renewable Energy Investment	$1,968,000,000,000.00	$2,015,232,000,000.00	$2,063,597,568,000.00	$2,113,123,909,632.00	$2,163,838,883,463.17	$2,215,771,016,666.28	$2,268,949,521,066.28	$2,323,404,309,571.87	$2,379,166,013,001.59	$2,436,265,997,313.63	$2,494,736,381,249.16	$2,554,610,054,399.14	$2,615,920,695,704.71	$2,678,702,792,401.63	$2,742,991,659,419.27	$2,808,823,459,245.33	$2,876,235,222,267.22	$2,945,264,867,601.63	$3,015,951,224,424.07	$3,088,334,053,810.25	$3,162,454,071,101.69	$3,238,352,968,808.13	$3,316,073,440,059.53	$3,395,659,202,620.96	$3,477,155,023,483.86	$3,560,606,744,047.47	$3,646,061,305,904.61	$3,733,566,777,246.32	$3,823,172,379,900.24	$3,914,928,517,017.84	$4,008,886,801,426.27	$4,105,100,084,660.50	$4,203,622,486,692.35	$4,304,509,426,372.97	$4,407,817,652,605.92	$4,513,605,276,268.46	$4,621,931,802,898.90	$4,732,858,166,168.48	$4,846,446,762,156.52	$4,962,761,484,448.28	$1,236,632,167,155.73	$1,248,998,488,827.30	$1,261,488,473,715.56	$1,274,103,358,452.72	$1,286,844,392,037.24	$1,299,712,835,957.61	$1,312,709,964,317.18	$1,325,837,063,960.35	$1,339,095,434,599.96	$1,352,486,388,945.96	$1,366,011,252,835.44	$1,379,671,365,363.78	$1,393,468,079,017.42	$1,407,402,759,807.59	$1,421,476,787,405.67	$1,435,691,555,279.73	$1,450,048,470,832.51	$1,464,548,955,540.85	$1,479,194,445,096.25	$1,493,986,389,547.21	$1,508,926,253,442.68	$1,524,015,515,977.11	$1,539,255,671,136.88	$1,554,648,227,848.27	$1,570,194,710,126.74	$1,585,896,657,228.00	$1,601,755,623,800.28	$1,617,773,180,038.30	$1,633,950,911,838.67	$1,650,290,420,957.06	$1,666,793,325,166.63	$1,683,461,258,418.29	$1,700,295,871,002.49	$1,717,298,829,712.51	$1,734,471,818,009.62	$1,751,816,536,189.72	$1,769,334,701,551.62	$1,787,028,048,567.14	$1,804,898,329,052.83	$1,822,947,312,343.34	$1,841,176,785,466.78	$1,859,588,553,321.45
7	25,551.00	Cost per GW	$850,000,000.00	$824,500,000.00	$799,765,000.00	$775,772,050.00	$752,498,888.50	$729,923,921.85	$708,026,204.19	$686,785,418.06	$666,181,855.52	$646,196,399.86	$626,810,507.86	$608,006,192.62	$589,766,006.85	$572,073,026.64	$554,910,835.84	$538,263,510.77	$522,115,605.44	$506,452,137.28	$500,000,000.00	$500,000,000.00	$500,000,000.00	$500,000,000.00	$500,000,000.00	$500,000,000.00	$500,000,000.00	$500,000,000.00	$500,000,000.00	$500,000,000.00	$500,000,000.00	$500,000,000.00	$500,000,000.00	$500,000,000.00	$500,000,000.00	$500,000,000.00	$500,000,000.00	$500,000,000.00	$500,000,000.00	$500,000,000.00	$500,000,000.00	$500,000,000.00	$500,000,000.00	$500,000,000.00	$500,000,000.00	$500,000,000.00	$500,000,000.00	$500,000,000.00	$500,000,000.00	$500,000,000.00	$500,000,000.00	$500,000,000.00	$500,000,000.00	$500,000,000.00	$500,000,000.00	$500,000,000.00	$500,000,000.00	$500,000,000.00	$500,000,000.00	$500,000,000.00	$500,000,000.00	$500,000,000.00	$500,000,000.00	$500,000,000.00	$500,000,000.00	$500,000,000.00	$500,000,000.00	$500,000,000.00	$500,000,000.00	$500,000,000.00	$500,000,000.00	$500,000,000.00	$500,000,000.00	$500,000,000.00	$500,000,000.00	$500,000,000.00	$500,000,000.00	$500,000,000.00	$500,000,000.00	$500,000,000.00	$500,000,000.00	$500,000,000.00	$500,000,000.00	$500,000,000.00
8		New production (GW)	2,315.29	2,444.19	2,580.25	2,723.90	2,875.54	3,035.62	3,204.61	3,383.01	3,571.35	3,770.16	3,980.05	4,201.62	4,435.52	4,682.45	4,943.12	5,218.31	5,508.81	5,815.49	6,031.90	6,176.67	6,324.91	6,476.71	6,632.15	6,791.32	6,954.31	7,121.21	7,292.12	7,467.13	7,646.34	7,829.86	8,017.77	8,210.20	8,407.24	8,609.02	8,815.64	9,027.21	9,243.86	9,465.72	9,692.89	9,925.52	2,473.26	2,498.00	2,522.98	2,548.21	2,573.69	2,599.43	2,625.42	2,651.67	2,678.19	2,704.97	2,732.02	2,759.34	2,786.94	2,814.81	2,842.95	2,871.38	2,900.10	2,929.10	2,958.39	2,987.97	3,017.85	3,048.03	3,078.51	3,109.30	3,140.39	3,171.79	3,203.51	3,235.55	3,267.90	3,300.58	3,333.59	3,366.92	3,400.59	3,434.60	3,468.94	3,503.63	3,538.67	3,574.06	3,609.80	3,645.89	3,682.35	3,719.18
9	Cost per GW (2019)	New production %	1.52%	1.59%	1.66%	1.74%	1.82%	1.90%	1.99%	2.08%	2.17%	2.27%	2.37%	2.48%	2.58%	2.68%	2.79%	2.90%	3.02%	3.14%	3.20%	3.23%	3.26%	3.29%	3.32%	3.35%	3.38%	3.41%	3.44%	3.47%	3.50%	3.53%	3.56%	3.59%	3.64%	3.69%	3.75%	3.80%	3.85%	3.90%	3.96%	4.01%	0.99%	0.99%	0.99%	0.99%	0.99%	0.99%	0.99%	0.99%	0.99%	0.99%	0.99%	0.99%	0.99%	0.99%	0.99%	0.99%	0.99%	0.99%	0.99%	0.99%	0.99%	0.99%	0.99%	0.99%	0.99%	0.99%	0.99%	0.99%	0.99%	0.99%	0.99%	0.99%	0.99%	0.99%	0.99%	0.99%	0.99%	0.99%	0.99%	0.99%	0.99%	0.99%
10	$850,000,000.00	Total consumption	152,000.00	153,520.00	155,055.20	156,605.75	158,171.81	159,753.53	161,351.06	162,964.57	164,594.22	166,240.16	167,902.56	169,581.59	172,125.31	174,707.19	177,327.80	179,987.72	182,687.53	185,427.85	188,209.26	191,032.40	193,897.89	196,806.36	199,758.45	202,754.83	205,796.15	208,883.09	212,016.34	215,196.59	218,424.53	221,700.90	225,026.42	228,401.81	230,685.83	232,992.69	235,322.62	237,675.84	240,052.60	242,453.13	244,877.66	247,326.43	249,799.70	252,297.69	254,820.67	257,368.88	259,942.57	262,541.99	265,167.41	267,819.09	270,497.28	273,202.25	275,934.27	278,693.62	281,480.55	284,295.36	287,138.31	290,009.69	292,909.79	295,838.89	298,797.28	301,785.25	304,803.10	307,851.13	310,929.65	314,038.94	317,179.33	320,351.12	323,554.64	326,790.18	330,058.08	333,358.67	336,692.25	340,059.17	343,459.77	346,894.36	350,363.31	353,866.94	357,405.61	360,979.67	364,589.46	368,235.36	371,917.71	375,636.89
11		Total renawable	9,915.29	12,359.48	14,939.74	17,663.63	20,539.17	23,574.79	26,779.40	30,162.42	33,733.76	37,503.93	41,483.97	45,685.59	50,121.12	54,803.57	59,746.69	64,964.99	70,473.80	76,289.29	82,321.19	88,497.86	94,822.77	101,299.47	107,931.62	114,722.94	121,677.25	128,798.46	136,090.58	143,557.72	151,204.06	159,033.92	167,051.69	175,261.89	183,669.14	192,278.16	201,093.79	210,121.00	219,364.86	228,830.58	238,523.47	248,449.00	250,922.26	253,420.26	255,943.24	258,491.44	261,065.13	263,664.56	266,289.98	268,941.65	271,619.84	274,324.81	277,056.84	279,816.18	282,603.12	285,417.92	288,260.88	291,132.26	294,032.36	296,961.45	299,919.84	302,907.81	305,925.67	308,973.70	312,052.21	315,161.51	318,301.90	321,473.69	324,677.20	327,912.75	331,180.65	334,481.23	337,814.82	341,181.74	344,582.33	348,016.93	351,485.87	354,989.50	358,528.17	362,102.23	365,712.03	369,357.92	373,040.27	376,759.45
12	Gross World Product (2019)	Non renawable	142,084.71	141,160.52	140,115.46	138,942.12	137,632.64	136,178.74	134,571.66	132,802.16	130,860.46	128,736.24	126,418.59	123,896.00	122,004.20	119,903.63	117,581.11	115,022.72	112,213.73	109,138.56	105,888.07	102,534.55	99,075.12	95,506.89	91,826.83	88,031.89	84,118.91	80,084.63	75,925.76	71,638.87	67,220.47	62,666.98	57,974.72	53,139.92	47,016.69	40,714.53	34,228.82	27,554.84	20,687.73	13,622.54	6,354.18	-1,122.56	-1,122.56	-1,122.56	-1,122.56	-1,122.56	-1,122.56	-1,122.56	-1,122.56	-1,122.56	-1,122.56	-1,122.56	-1,122.56	-1,122.56	-1,122.56	-1,122.56	-1,122.56	-1,122.56	-1,122.56	-1,122.56	-1,122.56	-1,122.56	-1,122.56	-1,122.56	-1,122.56	-1,122.56	-1,122.56	-1,122.56	-1,122.56	-1,122.56	-1,122.56	-1,122.56	-1,122.56	-1,122.56	-1,122.56	-1,122.56	-1,122.56	-1,122.56	-1,122.56	-1,122.56	-1,122.56	-1,122.56	-1,122.56	-1,122.56
13	$80,000,000,000,000.00	Total renawable %	5.00%	8.05%	9.64%	11.28%	12.99%	14.76%	16.60%	18.51%	20.50%	22.56%	24.71%	26.94%	29.12%	31.37%	33.69%	36.09%	38.58%	41.14%	43.74%	46.33%	48.90%	51.47%	54.03%	56.58%	59.13%	61.66%	64.19%	66.71%	69.22%	71.73%	74.24%	76.73%	79.62%	82.53%	85.45%	88.41%	91.38%	94.38%	97.41%	100.45%	100.45%	100.44%	100.44%	100.44%	100.43%	100.43%	100.42%	100.42%	100.42%	100.41%	100.41%	100.40%	100.40%	100.39%	100.39%	100.39%	100.38%	100.38%	100.38%	100.37%	100.37%	100.36%	100.36%	100.36%	100.35%	100.35%	100.35%	100.34%	100.34%	100.34%	100.33%	100.33%	100.33%	100.32%	100.32%	100.32%	100.31%	100.31%	100.31%	100.30%	100.30%	100.30%
14		Non renawable %	95.00%	91.95%	90.36%	88.72%	87.01%	85.24%	83.40%	81.49%	79.50%	77.44%	75.29%	73.06%	70.88%	68.63%	66.31%	63.91%	61.42%	58.86%	56.26%	53.67%	51.10%	48.53%	45.97%	43.42%	40.87%	38.34%	35.81%	33.29%	30.78%	28.27%	25.76%	23.27%	20.38%	17.47%	14.55%	11.59%	8.62%	5.62%	2.59%	-0.45%	-0.45%	-0.44%	-0.44%	-0.44%	-0.43%	-0.43%	-0.42%	-0.42%	-0.42%	-0.41%	-0.41%	-0.40%	-0.40%	-0.39%	-0.39%	-0.39%	-0.38%	-0.38%	-0.38%	-0.37%	-0.37%	-0.36%	-0.36%	-0.36%	-0.35%	-0.35%	-0.35%	-0.34%	-0.34%	-0.34%	-0.33%	-0.33%	-0.33%	-0.32%	-0.32%	-0.32%	-0.31%	-0.31%	-0.31%	-0.30%	-0.30%	-0.30%
15	Share of energy in total economy	Estimated co2 emitions	39,783.72	39,524.95	39,232.33	38,903.79	38,537.14	38,130.05	37,680.06	37,184.60	36,640.93	36,046.15	35,397.20	34,690.88	34,161.17	33,573.02	32,922.71	32,206.36	31,419.84	30,558.80	29,648.66	28,709.67	27,741.03	26,741.93	25,711.51	24,648.93	23,553.29	22,423.70	21,259.21	20,058.88	18,821.73	17,546.76	16,232.92	14,879.18	13,164.67	11,400.07	9,584.07	7,715.36	5,792.57	3,814.31	1,779.17	-314.32	-314.32	-314.32	-314.32	-314.32	-314.32	-314.32	-314.32	-314.32	-314.32	-314.32	-314.32	-314.32	-314.32	-314.32	-314.32	-314.32	-314.32	-314.32	-314.32	-314.32	-314.32	-314.32	-314.32	-314.32	-314.32	-314.32	-314.32	-314.32	-314.32	-314.32	-314.32	-314.32	-314.32	-314.32	-314.32	-314.32	-314.32	-314.32	-314.32	-314.32	-314.32	-314.32
16	8.20%
17
18	Rate of investment (% of total energy cost)
19	30.00%
20
21	Rate of economic growth
22	2.40%
23
24	Cost reduction per year
25	3.00%
26
27	Consumtion growth (now-30)
28	2.20%
29
30	Consumtion growth (30-50)
31	1.50%
32
33	Consumtion growth (50-100)
34	1.00%
35
36	CO2 T per GW
37	0.28
38
39	Cost per GW & kW (spending/consumption)
40	$43,157,894.74
41	$43.16
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