ZEN Data for Noosa

New

0. Added explicit args for geom_smooth to eliminate warning messages, and suppress warning messages for summarise in APVI installation ranges code (just for 4563 for now)
1. Added projected capacity for all localities,
2. Added Energex graph - av resi per day consumption - displaying but needs cleanup
3. Added graph of APVI PV installation size ranges - done partially for 4563
4. Added sum of AEMO postcode data, so can give LGA (less Peregian / Marcus)
5. Tested “Knit” to PDF and basically works (but slow), needs some format fixing
6. Included Energex usage data for postcodes (LGAs data is broken)
7. Use Noosa_LGA_PV_SWH_SWHASHP_monthly.rds generated from ProcessCERrefactor.R

To do

1. Forecasting for -> Solar Export & Total Consumption
2. Tidy up “new” items above
3. Try Dashboard ideas after workshop with Annie Nolan - see Miro board

Introdution

** To Do **

Data sources

Clean Energy Regulator : as at December 31, 2022

AEMO DER data : AEMO - December 2022 DERR data.xlsx

Energex Consumption & Solar Export : as at September 30, 2022

Solar PV sizes :

Zone Substation Load Data :

Some other heading or maybe logo

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Vivamus vulputate tellus id urna dignissim ultrices. Proin nulla tellus, pulvinar id diam vitae, malesuada aliquam ligula. Nunc id tellus nec metus tincidunt pharetra nec a turpis. Maecenas eleifend eu leo sit amet mattis. Aliquam vulputate sapien quis purus molestie, et auctor est porta. Duis et aliquam dui, non sagittis tortor. Ut venenatis fermentum lorem, ac rhoncus purus efficitur id. Sed cursus lacus consectetur nisi v

Noosa Data

Noosa Shire

Latest data for postcode NOOSA SHIRE

Noosa Local Government Area

Solar PV Installations	Value
Total Solar PV installations	14,598
Increase in the last 12 months	1,037
Average monthly increase - last 12 months	86
Increase in installations - last 12 months	7.6 %

Solar PV Capacity	Value
Total solar PV capacity (kW)	81,675
Increase in last 12 months (kW)	9,406
Average monthly increase last 12 months (kW)	784
Increase in capacity - last 12 months (kW)	13 %

Energex Connections	Value
Residential connections - NMI	29,229
Residential solar connections - NMI	10,886
Business connections - NMI	2,872
Business solar connections - NMI	510

Batteries	Value
Residential count	260
Residential capacity - kW	2,168
Residential storage - kWh	3,480
Business count	6
Business capacity - kW	235
Business storage - kWh	432

Note

Any batteries for Peregian Beach & Marcus Beach not included, due to data only being available at postcode level, and these locations represent probably around 15% of postcode 4573

NOOSA SHIRE Postcode map

As at December 31, 2022

2021 census dwellings = 28,566

The number of solar installations was 14,598 with total capacity of 81,675 kW.

This represents an increase in capacity of 9,406 kW over the last 12 months, giving an average monthly increase of 784 kW per month.

The corresponding increase in the number of solar installations in the last 12 months was 1,037, giving an average monthly increase of 86 new installations per month.

The increase in capacity over the last 12 months was 13 %

The increase in the number if installations over the last 12 months was 7.6 %

Solar installs and capacity

	per month				total
Date	PV qty	kW	SWH qty	HPSWH qty	PV qty	kW	SWH qty	HPSWH qty
2022-12-31	758	77	5	3	14,598	81,675	3,642	1,275
2022-11-30	1,059	113	7	4	14,521	80,917	3,637	1,272
2022-10-31	846	97	5	4	14,409	79,857	3,630	1,267
2022-09-30	895	105	9	8	14,311	79,011	3,625	1,264
2022-08-31	866	100	14	4	14,207	78,116	3,616	1,255
2022-07-31	614	74	11	7	14,106	77,250	3,602	1,251
2022-06-30	964	108	9	5	14,033	76,636	3,591	1,244
2022-05-31	622	70	6	7	13,924	75,672	3,582	1,239
2022-04-30	746	76	6	3	13,854	75,049	3,576	1,232
2022-03-31	927	92	7	4	13,778	74,304	3,569	1,229
2022-02-28	648	67	0	7	13,686	73,376	3,562	1,225
2022-01-31	460	58	0	2	13,619	72,728	3,562	1,219
2021-12-31	1,030	111	0	6	13,561	72,269	3,562	1,217
2021-11-30	1,137	106	0	0	13,450	71,238	3,562	1,211
2021-10-31	927	99	8	4	13,345	70,101	3,562	1,211
2021-09-30	1,068	107	10	6	13,246	69,175	3,554	1,206
2021-08-31	1,184	124	18	8	13,139	68,107	3,544	1,200
2021-07-31	978	118	7	5	13,015	66,923	3,525	1,192
2021-06-30	1,038	127	12	9	12,897	65,945	3,518	1,187
2021-05-31	1,065	111	7	6	12,770	64,907	3,506	1,179
2021-04-30	985	122	10	7	12,659	63,842	3,499	1,173
2021-03-31	1,026	120	13	2	12,537	62,857	3,488	1,166
2021-02-28	1,219	146	6	9	12,418	61,831	3,475	1,165
2021-01-31	632	84	6	6	12,272	60,612	3,469	1,155
2020-12-31	1,528	153	7	5	12,187	59,980	3,463	1,149
2020-11-30	1,254	145	9	13	12,035	58,452	3,455	1,144
2020-10-31	1,011	125	7	2	11,890	57,198	3,447	1,131
2020-09-30	1,100	127	15	6	11,765	56,187	3,439	1,130
2020-08-31	1,104	121	9	9	11,638	55,087	3,424	1,124
2020-07-31	1,115	134	4	5	11,516	53,983	3,415	1,116
2020-06-30	1,008	123	15	8	11,382	52,868	3,411	1,110
2020-05-31	1,134	133	6	9	11,259	51,860	3,396	1,103
2020-04-30	816	107	7	7	11,127	50,725	3,390	1,093
2020-03-31	1,485	169	7	2	11,020	49,909	3,383	1,087
2020-02-29	920	122	5	4	10,850	48,424	3,376	1,085
2020-01-31	796	100	7	1	10,728	47,505	3,371	1,080
2019-12-31	1,052	128	9	6	10,628	46,709	3,363	1,079
2019-11-30	1,009	129	12	4	10,501	45,656	3,354	1,073
2019-10-31	937	109	11	9	10,372	44,647	3,342	1,069
2019-09-30	757	98	11	4	10,263	43,710	3,332	1,060
2019-08-31	562	76	9	7	10,165	42,953	3,320	1,056
2019-07-31	980	114	11	2	10,089	42,391	3,312	1,049
2019-06-30	637	93	3	4	9,975	41,412	3,300	1,047
2019-05-31	819	102	8	3	9,882	40,775	3,297	1,044
2019-04-30	685	84	14	8	9,780	39,955	3,289	1,041
2019-03-31	819	91	1	13	9,697	39,270	3,275	1,033
2019-02-28	603	85	9	13	9,606	38,451	3,275	1,020
2019-01-31	570	80	5	10	9,521	37,848	3,266	1,006
2018-12-31	825	94	5	6	9,441	37,279	3,261	996
2018-11-30	854	120	18	8	9,347	36,454	3,255	990
2018-10-31	675	85	7	7	9,227	35,600	3,237	983
2018-09-30	561	72	14	11	9,141	34,925	3,230	976
2018-08-31	520	71	13	6	9,069	34,364	3,217	966
2018-07-31	559	86	10	13	8,998	33,844	3,204	960
2018-06-30	783	88	7	4	8,912	33,284	3,194	947
2018-05-31	618	81	12	7	8,824	32,501	3,187	943
2018-04-30	617	73	9	2	8,742	31,883	3,175	937
2018-03-31	515	78	7	4	8,670	31,266	3,165	934
2018-02-28	420	67	10	4	8,592	30,751	3,158	930
2018-01-31	323	56	8	4	8,525	30,330	3,148	926
2017-12-31	570	89	10	3	8,469	30,007	3,140	922
2017-11-30	500	80	15	5	8,380	29,438	3,130	919
2017-10-31	547	90	10	1	8,300	28,937	3,115	913
2017-09-30	525	89	11	4	8,211	28,391	3,105	912
2017-08-31	637	91	12	4	8,122	27,866	3,094	908
2017-07-31	352	75	6	1	8,031	27,229	3,082	904
2017-06-30	473	67	15	9	7,956	26,876	3,076	902
2017-05-31	395	65	13	2	7,890	26,404	3,061	893
2017-04-30	320	67	10	1	7,825	26,008	3,048	891
2017-03-31	468	91	12	2	7,757	25,688	3,038	890
2017-02-28	340	72	8	12	7,666	25,220	3,027	887
2017-01-31	217	43	13	12	7,594	24,880	3,018	875
2016-12-31	556	82	15	13	7,552	24,663	3,005	863
2016-11-30	373	66	11	8	7,470	24,107	2,991	850
2016-10-31	390	67	14	6	7,404	23,734	2,980	842
2016-09-30	371	58	9	3	7,337	23,343	2,966	836
2016-08-31	302	54	11	8	7,279	22,973	2,957	833
2016-07-31	252	45	12	1	7,224	22,671	2,945	824
2016-06-30	316	53	8	4	7,179	22,419	2,933	823
2016-05-31	236	43	8	3	7,126	22,102	2,925	819
2016-04-30	211	45	12	3	7,083	21,867	2,916	816
2016-03-31	207	45	9	7	7,038	21,656	2,905	813
2016-02-29	361	48	13	1	6,993	21,448	2,896	806
2016-01-31	167	34	4	4	6,946	21,087	2,883	805
2015-12-31	218	47	7	0	6,912	20,921	2,879	801
2015-11-30	240	47	18	0	6,865	20,703	2,872	801
2015-10-31	252	54	8	0	6,818	20,462	2,853	801
2015-09-30	217	47	13	0	6,764	20,211	2,845	801
2015-08-31	237	45	10	0	6,717	19,994	2,832	801
2015-07-31	267	58	14	0	6,672	19,757	2,822	801
2015-06-30	299	65	14	0	6,614	19,490	2,808	801
2015-05-31	376	68	19	0	6,549	19,191	2,794	801
2015-04-30	343	60	17	0	6,481	18,816	2,775	801
2015-03-31	264	70	17	0	6,421	18,472	2,758	801
2015-02-28	209	52	10	0	6,352	18,209	2,741	801
2015-01-31	234	51	7	0	6,299	18,000	2,731	801
2014-12-31	218	58	10	2	6,248	17,766	2,725	801
2014-11-30	255	65	13	3	6,190	17,547	2,715	799
2014-10-31	231	62	11	2	6,126	17,292	2,702	796
2014-09-30	331	80	9	4	6,064	17,062	2,691	794
2014-08-31	204	55	23	2	5,984	16,731	2,682	789
2014-07-31	266	63	26	2	5,929	16,527	2,659	787
2014-06-30	293	72	17	0	5,866	16,261	2,633	785
2014-05-31	253	61	8	2	5,793	15,968	2,617	785
2014-04-30	267	58	10	0	5,732	15,714	2,609	783
2014-03-31	204	52	12	6	5,675	15,447	2,599	783
2014-02-28	169	45	8	2	5,623	15,243	2,587	777
2014-01-31	144	35	11	1	5,579	15,075	2,579	774
2013-12-31	166	38	12	0	5,543	14,931	2,569	773
2013-11-30	158	50	13	3	5,505	14,765	2,557	773
2013-10-31	170	45	10	2	5,455	14,607	2,544	770
2013-09-30	245	65	5	15	5,409	14,437	2,534	767
2013-08-31	177	58	11	2	5,345	14,193	2,529	752
2013-07-31	319	89	13	4	5,287	14,016	2,519	750
2013-06-30	693	170	9	3	5,198	13,697	2,505	746
2013-05-31	434	112	7	1	5,027	13,004	2,497	743
2013-04-30	293	85	5	1	4,915	12,570	2,490	741
2013-03-31	319	95	9	4	4,830	12,278	2,485	740
2013-02-28	247	58	7	2	4,736	11,958	2,475	736
2013-01-31	222	63	6	1	4,678	11,711	2,469	734
2012-12-31	562	154	14	2	4,615	11,489	2,463	733
2012-11-30	380	116	8	3	4,460	10,927	2,449	731
2012-10-31	358	118	13	4	4,345	10,548	2,441	728
2012-09-30	449	141	7	3	4,227	10,189	2,428	723
2012-08-31	544	174	14	5	4,086	9,740	2,422	720
2012-07-31	426	138	12	0	3,911	9,196	2,408	715
2012-06-30	924	289	9	4	3,774	8,770	2,396	715
2012-05-31	587	190	10	3	3,485	7,846	2,386	711
2012-04-30	430	139	12	1	3,295	7,259	2,377	708
2012-03-31	299	107	10	7	3,156	6,829	2,365	706
2012-02-29	289	100	20	7	3,049	6,529	2,355	699
2012-01-31	120	45	12	7	2,950	6,240	2,335	692
2011-12-31	284	85	10	15	2,905	6,121	2,323	685
2011-11-30	207	76	22	17	2,820	5,837	2,314	670
2011-10-31	137	55	18	17	2,744	5,630	2,292	653
2011-09-30	204	76	17	11	2,689	5,494	2,274	636
2011-08-31	171	70	15	9	2,614	5,290	2,257	626
2011-07-31	231	91	23	12	2,544	5,118	2,242	617
2011-06-30	834	328	28	8	2,453	4,888	2,219	605
2011-05-31	663	273	33	26	2,125	4,054	2,191	597
2011-04-30	277	124	27	21	1,852	3,391	2,158	571
2011-03-31	326	157	26	11	1,728	3,114	2,131	550
2011-02-28	253	115	16	15	1,571	2,789	2,104	538
2011-01-31	175	78	15	10	1,456	2,536	2,088	524
2010-12-31	183	73	17	18	1,378	2,361	2,073	514
2010-11-30	196	89	28	8	1,305	2,178	2,056	496
2010-10-31	151	65	34	18	1,216	1,983	2,028	488
2010-09-30	144	69	37	8	1,151	1,832	1,994	470
2010-08-31	175	85	45	12	1,082	1,688	1,957	462
2010-07-31	172	92	57	22	997	1,513	1,912	450
2010-06-30	132	90	40	19	905	1,341	1,854	428
2010-05-31	102	47	28	14	815	1,210	1,815	408
2010-04-30	98	52	28	10	768	1,107	1,787	395
2010-03-31	87	45	27	8	716	1,010	1,759	384
2010-02-28	116	86	57	9	671	922	1,733	376
2010-01-31	79	62	33	15	586	807	1,675	367
2009-12-31	113	77	37	12	524	728	1,643	352
2009-11-30	91	65	36	13	447	614	1,606	340
2009-10-31	68	48	43	17	382	524	1,570	327
2009-09-30	30	25	40	32	334	456	1,527	310
2009-08-31	50	39	34	18	308	427	1,487	278
2009-07-31	58	50	43	19	270	377	1,453	260
2009-06-30	43	35	35	10	220	319	1,410	241
2009-05-31	27	24	28	18	185	276	1,375	231
2009-04-30	18	18	17	14	161	249	1,347	213
2009-03-31	28	21	22	15	143	230	1,330	199
2009-02-28	14	8	20	10	122	202	1,308	185
2009-01-31	32	14	18	3	114	188	1,287	174
2008-12-31	9	9	23	9	100	156	1,270	171
2008-11-30	11	8	19	12	91	147	1,246	162
2008-10-31	17	12	22	8	83	136	1,228	150
2008-09-30	20	17	27	6	71	119	1,206	142
2008-08-31	11	8	36	8	54	99	1,179	135
2008-07-31	16	8	27	12	45	88	1,143	128
2008-06-30	10	4	21	10	37	72	1,116	115
2008-05-31	9	4	17	8	33	63	1,095	106
2008-04-30	3	3	11	6	29	54	1,078	98
2008-03-31	3	2	16	7	26	51	1,067	92
2008-02-29	5	3	11	1	24	48	1,051	85
2008-01-31	3	2	13	2	21	43	1,040	84
2007-12-31	8	2	14	2	19	40	1,027	81
2007-11-30	2	1	27	6	17	31	1,013	79
2007-10-31	0	0	22	8	15	29	987	73
2007-09-30	4	1	29	7	15	29	964	65
2007-08-31	3	2	18	5	14	25	935	58
2007-07-31	0	0	32	6	12	22	917	54
2007-06-30	0	0	16	6	12	22	885	48
2007-05-31	0	0	27	9	12	22	869	42
2007-04-30	0	0	11	5	12	22	842	33
2007-03-31	0	0	9	1	12	22	831	28
2007-02-28	0	0	6	5	12	22	823	27
2007-01-31	0	0	11	1	12	22	816	21
2006-12-31	0	0	11	0	12	22	805	21
2006-11-30	0	0	18	5	12	22	794	21
2006-10-31	0	0	11	4	12	22	776	16
2006-09-30	0	0	10	2	12	22	765	12
2006-08-31	0	0	11	1	12	22	755	9
2006-07-31	4	1	9	2	12	22	744	8
2006-06-30	0	0	13	2	11	18	735	7
2006-05-31	0	0	7	0	11	18	721	5
2006-04-30	0	0	9	0	11	18	714	4
2006-03-31	0	0	7	1	11	18	706	4
2006-02-28	0	0	11	1	11	18	698	3
2006-01-31	0	0	6	1	11	18	688	2
2005-12-31	0	0	6	0	11	18	681	1
2005-11-30	0	0	10	0	11	18	675	1
2005-10-31	0	0	14	0	11	18	665	1
2005-09-30	0	0	13	0	11	18	651	1
2005-08-31	0	0	10	0	11	18	638	1
2005-07-31	0	0	22	0	11	18	628	1
2005-06-30	2	1	27	0	11	18	606	1
2005-05-31	0	0	16	0	10	17	579	1
2005-04-30	0	0	10	0	10	17	563	1
2005-03-31	0	0	10	1	10	17	553	1
2005-02-28	0	0	5	0	10	17	543	0
2005-01-31	0	0	7	0	10	17	538	0
2004-12-31	1	1	7	0	10	17	531	0
2004-11-30	0	0	12	0	9	15	524	0
2004-10-31	0	0	16	0	9	15	512	0
2004-09-30	0	0	19	0	9	15	495	0
2004-08-31	1	1	16	0	9	15	476	0
2004-07-31	1	1	15	0	8	15	460	0
2004-06-30	0	0	8	0	7	14	446	0
2004-05-31	1	1	8	0	7	14	438	0
2004-04-30	2	1	8	0	6	13	430	0
2004-03-31	0	0	15	0	5	11	422	0
2004-02-29	1	1	12	0	5	11	407	0
2004-01-31	0	0	6	0	4	10	396	0
2003-12-31	0	0	12	0	4	10	389	0
2003-11-30	0	0	17	0	4	10	377	0
2003-10-31	0	0	16	0	4	10	360	0
2003-09-30	0	0	11	0	4	10	344	0
2003-08-31	2	1	16	0	4	10	333	0
2003-07-31	2	1	16	0	3	9	318	0
2003-06-30	3	1	16	0	2	7	302	0
2003-05-31	0	0	7	0	1	4	285	0
2003-04-30	0	0	9	0	1	4	278	0
2003-03-31	0	0	15	0	1	4	269	0
2003-02-28	0	0	9	0	1	4	253	0
2003-01-31	0	0	15	0	1	4	244	0
2002-12-31	0	0	7	0	1	4	229	0
2002-11-30	0	0	15	0	1	4	222	0
2002-10-31	0	0	13	0	1	4	208	0
2002-09-30	4	1	13	0	1	4	195	0
2002-08-31	0	0	17	0	0	0	182	0
2002-07-31	0	0	18	0	0	0	165	0
2002-06-30	0	0	14	0	0	0	147	0
2002-05-31	0	0	15	0	0	0	132	0
2002-04-30	0	0	10	0	0	0	118	0
2002-03-31	0	0	12	0	0	0	108	0
2002-02-28	0	0	7	0	0	0	96	0
2002-01-31	0	0	6	0	0	0	88	0
2001-12-31	0	0	10	0	0	0	82	0
2001-11-30	0	0	17	0	0	0	72	0
2001-10-31	0	0	12	0	0	0	55	0
2001-09-30	0	0	14	0	0	0	43	0
2001-08-31	0	0	6	0	0	0	29	0
2001-07-31	0	0	5	0	0	0	23	0
2001-06-30	0	0	9	0	0	0	18	0
2001-05-31	0	0	6	0	0	0	10	0
2001-04-30	0	0	3	0	0	0	3	0

==== TO DO ===== Add some words of explanation in here….

Graphs for postcode NOOSA SHIRE

==== TO DO ===== add words of explanation

==== TO DO ===== add words of explanation

==== TO DO ===== add words of explanation

==== TO DO ===== add words of explanation

Energex Consumption

year_month	bus_kWh	resi_kWh	solar_kWh	bus_NMI	resi_NMI	solar_NMI	bus_daily	resi_daily	solar_daily
2022-09-30	9331926	13535301	4012925	2872	29229	11042	108.30927	15.43593	12.114125
2022-08-31	9701493	15561713	3772289	2874	29135	10964	108.89053	17.22982	11.098754
2022-07-31	10093785	17348841	2757480	2859	29305	10942	113.88807	19.09708	8.129315
2022-06-30	9488469	16012125	2906046	2837	29344	10899	111.48478	18.18898	8.887808
2022-05-31	10234808	15397449	2240960	2848	29334	10911	115.92524	16.93229	6.625334
2022-04-30	10158867	14171935	3342185	2854	29347	10847	118.65063	16.09697	10.270691
2022-03-31	11268125	14953250	3736892	2853	29334	10814	127.40551	16.44382	11.147115
2022-02-28	10204733	13816270	3758489	2861	29314	10785	127.38719	16.83285	12.446151
2022-01-31	11695523	15941959	4114036	2854	29321	10738	132.19163	17.53885	12.358990
2021-12-31	11389290	15246644	4493162	2852	29313	10712	128.82064	16.77847	13.530686
2021-11-30	10258697	13575007	4124082	2861	29292	10661	119.52344	15.44791	12.894605
2021-10-31	10053220	13326267	4757373	2860	29267	10602	113.39071	14.68820	14.474970
2021-09-30	8951452	13070006	4413439	2858	29245	10533	104.40228	14.89714	13.967022
2021-08-31	8766210	14514391	3803306	2864	29227	10443	98.73637	16.01964	11.748279
2021-07-31	9424929	15851890	2912599	2860	29218	10348	106.30418	17.50124	9.079512
2021-06-30	9235667	15284300	2528278	2856	29203	10263	107.79256	17.44604	8.211626
2021-05-31	9667995	14662194	2943537	2852	29186	10207	109.35162	16.20551	9.302715
2021-04-30	9818141	13959664	3126915	2842	29178	10096	115.15530	15.94770	10.323941
2021-03-31	11330983	14756985	3095965	2829	29162	10024	129.20310	16.32370	9.963074
2021-02-28	10395061	13737757	3109656	2834	29148	9927	130.99936	16.83252	11.187585
2021-01-31	11669866	15691240	3640439	2831	29147	9826	132.97326	17.36608	11.951305
2020-12-31	11678343	15515786	3640352	2826	29136	9759	133.30528	17.17838	12.033067
2020-11-30	10077847	13723189	4020014	2828	29121	9682	118.78651	15.70824	13.840162
2020-10-31	9665932	13447204	3888466	2815	29106	9574	110.76528	14.90348	13.101566
2020-09-30	8955252	13178587	3452522	2810	29092	9472	106.23075	15.09990	12.149922
2020-08-31	8963599	14611614	3152777	2809	29047	9393	102.93640	16.22689	10.827476
2020-07-31	9089277	15575374	2390126	2797	29026	9291	104.82749	17.30970	8.298444
2020-06-30	8017769	14770580	2078467	2785	28988	9192	95.96372	16.98471	7.537233
2020-05-31	7486510	14379343	2228953	2796	28951	9099	86.37351	16.02189	7.902156
2020-04-30	7631377	13560752	2436119	2751	28934	8987	92.46791	15.62263	9.035716
2020-03-31	10443728	14617999	2554421	2752	28932	8863	122.41804	16.29850	9.297154
2020-02-29	11268785	14525384	2322445	2763	28927	8763	140.63655	17.31515	9.138914
2020-01-31	12362084	15964793	2873301	2761	28911	8672	144.43206	17.81306	10.688091
2019-12-31	11782572	15425121	3175500	2752	28901	8602	138.11154	17.21686	11.908334
2019-11-30	10677964	13727538	3308528	2755	28895	8548	129.19497	15.83612	12.901764
2019-10-31	10009363	13245314	3258856	2749	28849	8471	117.45459	14.81050	12.409915
2019-09-30	9256272	12839527	3001784	2738	28822	8371	112.68897	14.84922	11.953109
2019-08-31	9317054	14052387	2598372	2747	28785	8311	109.41031	15.74788	10.085243
2019-07-31	9479688	14787237	2034098	2739	28754	8227	111.64527	16.58926	7.975698
2019-06-30	9480595	13981429	1667114	2742	28722	8129	115.25158	16.22616	6.836078
2019-05-31	9917594	13878701	1745765	2753	28700	8077	116.20864	15.59930	6.972269
2019-04-30	10196963	13358321	1825668	2739	28679	8002	124.09594	15.52625	7.605047
2019-03-31	11900369	14360776	2030800	2737	28638	7916	140.25680	16.17609	8.275604
2019-02-28	10897489	13308231	2034310	2750	28628	7867	141.52584	16.60242	9.235275
2019-01-31	12553735	15007042	2420508	2739	28600	7807	147.84928	16.92651	10.001398
2018-12-31	11687972	14591682	2373412	2724	28560	7730	138.41092	16.48107	9.904486
2018-11-30	10858976	13458507	2410071	2734	28564	7675	132.39424	15.70567	10.467194
2018-10-31	10333271	13333442	2338562	2717	28541	7599	122.68359	15.06994	9.927292
2018-09-30	9345964	12983789	2178425	2702	28518	7532	115.29686	15.17613	9.640753
2018-08-31	9770181	14003498	2034269	2710	28505	7475	116.29783	15.84725	8.778808
2018-07-31	9921667	14571630	1673593	2708	28472	7398	118.18825	16.50929	7.297494
2018-06-30	9558848	13967019	1438729	2702	28451	7327	117.92312	16.36383	6.545329
2018-05-31	10056389	13814456	1506132	2707	28438	7276	119.83733	15.67015	6.677420
2018-04-30	10772438	13359456	1523092	2707	28418	7187	132.64915	15.67018	7.064105
2018-03-31	11858105	14212333	1622877	2711	28394	7101	141.09904	16.14645	7.372323
2018-02-28	11093470	13341064	1596521	2722	28364	7072	145.55304	16.79829	8.062585
2018-01-31	12754455	15011456	1943317	2721	28346	7043	151.20692	17.08320	8.900701
2017-12-31	12147862	14636462	1996648	2717	28312	7000	144.22765	16.67646	9.201144
2017-11-30	10680724	13360168	1914811	2727	28308	6997	130.55523	15.73191	9.122057
2017-10-31	11076729	13162744	1906199	2711	28284	6929	131.80149	15.01219	8.874339
2017-09-30	10220625	12579777	1833864	2698	28266	6856	126.27409	14.83499	8.916105
2017-08-31	10032403	13338925	1733542	2679	28236	6801	120.80101	15.23898	8.222424
2017-07-31	10075781	13695766	1495692	2664	28195	6747	122.00645	15.66941	7.151051
2017-06-30	9693857	13181896	1311694	2667	28169	6687	121.15806	15.59858	6.538526
2017-05-31	10202710	13386147	1333427	2678	28161	6651	122.89757	15.33366	6.467263
2017-04-30	10248075	13192402	1364520	2664	28114	6595	128.22916	15.64156	6.896741
2017-03-31	12133052	14402019	1464931	2662	28092	6564	147.02808	16.53785	7.199242
2017-02-28	11525249	13746472	1427571	2669	28059	6487	154.22107	17.49690	7.859513
2017-01-31	13173946	15581943	1660819	2674	28021	6450	158.92521	17.93809	8.306172
2016-12-31	12231162	14960233	1716072	2669	27994	6378	147.82826	17.23899	8.679390
2016-11-30	11238075	13555872	1713414	2662	27957	6340	140.72220	16.16276	9.008485
2016-10-31	10456079	13210686	1746657	2632	27929	6283	128.15079	15.25837	8.967655
2016-09-30	9857809	12873092	1550728	2632	27910	6226	124.84560	15.37453	8.302430
2016-08-31	10014429	13964276	1373790	2642	27845	6190	122.27331	16.17743	7.159260
2016-07-31	9956615	14478272	1137876	2623	27829	6138	122.44801	16.78253	5.980073
2016-06-30	9554531	13909838	1023568	2620	27802	6103	121.55891	16.67726	5.590519
2016-05-31	10173017	13790084	1129825	2630	27791	6076	124.77636	16.00667	5.998348
2016-04-30	10534582	13239326	1191754	2624	27738	6037	133.82345	15.90997	6.580275
2016-03-31	11606880	13956069	1302360	2612	27706	5996	143.34437	16.24904	7.006606
2016-02-29	11177655	13395183	1283119	2622	27701	5986	147.00091	16.67459	7.391496
2016-01-31	11646560	14375522	1450865	2608	27668	5958	144.05501	16.76039	7.855339

==== TO DO ===== add words of explanation

Noosa Monthly Graphs- NOOSA SHIRE

==== TO DO ===== add words of explanation

==== TO DO ===== add words of explanation

==== TO DO ===== add words of explanation

==== TO DO ===== add words of explanation blah blah blah

Noosa Forecasts- NOOSA SHIRE

Should refactor to move forecast code to Main_1.Rmd and save results for later use

APVI installation ranges

Best to grab code from “test script.R” - use the yearly 100% code and use more meaningful headings

4563

Latest data for postcode 4563

Black Mountain, Carters Ridge, Cooroy, Cooroy Mountain, Lake Macdonald, Ridgewood, Tinbeerwah

Solar PV Installations	Value
Total Solar PV installations	2,960
Increase in the last 12 months	170
Average monthly increase - last 12 months	14
Increase in installations - last 12 months	6.1 %

Solar PV Capacity	Value
Total solar PV capacity (kW)	16,018
Increase in last 12 months (kW)	1,515
Average monthly increase last 12 months (kW)	126
Increase in capacity - last 12 months (kW)	10.4 %

Energex Connections	Value
Residential connections - NMI	4,022
Residential solar connections - NMI	2,309
Business connections - NMI	386
Business solar connections - NMI	120

Batteries	Value
Residential count	56
Residential capacity - kW	470
Residential storage - kWh	654
Business count	0
Business capacity - kW	0
Business storage - kWh	0

4563 Postcode map

As at December 31, 2022

2021 census dwellings = 4,140

The number of solar installations was 2,960 with total capacity of 16,018 kW.

This represents an increase in capacity of 1,515 kW over the last 12 months, giving an average monthly increase of 126 kW per month.

The corresponding increase in the number of solar installations in the last 12 months was 170, giving an average monthly increase of 14 new installations per month.

The increase in capacity over the last 12 months was 10.4 %

The increase in the number if installations over the last 12 months was 6.1 %

Solar installs and capacity

	per month				total
Date	PV qty	kW	SWH qty	HPSWH qty	PV qty	kW	SWH qty	HPSWH qty
2022-12-31	133	13	0	1	2,960	16,018	776	345
2022-11-30	218	19	2	2	2,947	15,885	776	344
2022-10-31	70	10	0	0	2,928	15,667	774	342
2022-09-30	139	14	0	0	2,918	15,597	774	342
2022-08-31	153	17	1	1	2,904	15,458	774	342
2022-07-31	108	15	5	1	2,887	15,305	773	341
2022-06-30	148	18	2	0	2,872	15,197	768	340
2022-05-31	85	12	0	2	2,854	15,049	766	340
2022-04-30	90	10	1	0	2,842	14,964	766	338
2022-03-31	141	14	1	0	2,832	14,874	765	338
2022-02-28	152	17	0	2	2,818	14,734	764	338
2022-01-31	79	11	0	0	2,801	14,582	764	336
2021-12-31	234	22	0	2	2,790	14,503	764	336
2021-11-30	145	13	0	0	2,768	14,270	764	334
2021-10-31	147	17	1	1	2,755	14,124	764	334
2021-09-30	316	16	1	1	2,738	13,977	763	333
2021-08-31	197	20	3	1	2,722	13,661	762	332
2021-07-31	144	16	2	2	2,702	13,463	759	331
2021-06-30	174	22	1	0	2,686	13,319	757	329
2021-05-31	155	19	3	0	2,664	13,145	756	329
2021-04-30	223	28	1	1	2,645	12,990	753	329
2021-03-31	180	22	4	0	2,617	12,767	752	328
2021-02-28	257	28	0	3	2,595	12,587	748	328
2021-01-31	147	19	1	3	2,567	12,330	748	325
2020-12-31	206	24	2	3	2,548	12,183	747	322
2020-11-30	216	28	2	8	2,524	11,977	745	319
2020-10-31	233	28	2	0	2,496	11,761	743	311
2020-09-30	220	31	5	4	2,468	11,528	741	311
2020-08-31	253	22	3	4	2,437	11,308	736	307
2020-07-31	197	26	1	4	2,415	11,055	733	303
2020-06-30	296	50	4	4	2,389	10,858	732	299
2020-05-31	343	40	3	4	2,339	10,561	728	295
2020-04-30	257	27	3	2	2,299	10,218	725	291
2020-03-31	202	32	1	1	2,272	9,961	722	289
2020-02-29	155	21	2	3	2,240	9,759	721	288
2020-01-31	143	21	2	0	2,219	9,604	719	285
2019-12-31	220	31	3	4	2,198	9,461	717	285
2019-11-30	205	31	2	3	2,167	9,241	714	281
2019-10-31	163	24	5	6	2,136	9,035	712	278
2019-09-30	130	20	5	2	2,112	8,872	707	272
2019-08-31	126	21	2	6	2,092	8,743	702	270
2019-07-31	216	33	2	0	2,071	8,617	700	264
2019-06-30	98	14	0	2	2,038	8,401	698	264
2019-05-31	112	15	4	1	2,024	8,302	698	262
2019-04-30	107	16	3	5	2,009	8,190	694	261
2019-03-31	299	19	0	9	1,993	8,084	691	256
2019-02-28	118	19	4	8	1,974	7,784	691	247
2019-01-31	103	15	0	8	1,955	7,666	687	239
2018-12-31	107	19	3	0	1,940	7,563	687	231
2018-11-30	151	25	5	5	1,921	7,456	684	231
2018-10-31	193	22	2	3	1,896	7,305	679	226
2018-09-30	130	22	2	8	1,874	7,112	677	223
2018-08-31	97	16	2	1	1,852	6,982	675	215
2018-07-31	151	27	3	5	1,836	6,884	673	214
2018-06-30	210	22	0	0	1,809	6,733	670	209
2018-05-31	101	13	1	2	1,787	6,523	670	209
2018-04-30	152	18	0	1	1,774	6,422	669	207
2018-03-31	108	23	2	0	1,756	6,270	669	206
2018-02-28	93	14	4	2	1,733	6,163	667	206
2018-01-31	68	13	1	0	1,719	6,069	663	204
2017-12-31	88	17	1	2	1,706	6,001	662	204
2017-11-30	152	22	2	1	1,689	5,912	661	202
2017-10-31	118	24	2	0	1,667	5,760	659	201
2017-09-30	136	31	3	2	1,643	5,643	657	201
2017-08-31	97	19	2	1	1,612	5,507	654	199
2017-07-31	90	24	1	1	1,593	5,410	652	198
2017-06-30	78	17	5	4	1,569	5,320	651	197
2017-05-31	78	12	2	1	1,552	5,243	646	193
2017-04-30	93	25	1	0	1,540	5,164	644	192
2017-03-31	107	24	2	1	1,515	5,071	643	192
2017-02-28	82	22	2	11	1,491	4,965	641	191
2017-01-31	37	6	2	12	1,469	4,882	639	180
2016-12-31	49	8	7	11	1,463	4,845	637	168
2016-11-30	32	6	1	6	1,455	4,796	630	157
2016-10-31	75	11	7	2	1,449	4,764	629	151
2016-09-30	19	5	2	1	1,438	4,689	622	149
2016-08-31	58	10	2	0	1,433	4,670	620	148
2016-07-31	41	8	0	0	1,423	4,613	618	148
2016-06-30	85	8	1	1	1,415	4,572	618	148
2016-05-31	51	5	1	0	1,407	4,487	617	147
2016-04-30	59	12	2	1	1,402	4,435	616	147
2016-03-31	37	6	1	0	1,390	4,377	614	146
2016-02-29	79	7	1	1	1,384	4,339	613	146
2016-01-31	28	5	1	0	1,377	4,261	612	145
2015-12-31	35	9	1	0	1,372	4,233	611	145
2015-11-30	41	9	4	0	1,363	4,198	610	145
2015-10-31	74	11	0	0	1,354	4,157	606	145
2015-09-30	33	7	1	0	1,343	4,083	606	145
2015-08-31	62	12	6	0	1,336	4,050	605	145
2015-07-31	17	5	4	0	1,324	3,988	599	145
2015-06-30	52	11	2	0	1,319	3,971	595	145
2015-05-31	37	10	2	0	1,308	3,919	593	145
2015-04-30	41	10	1	0	1,298	3,882	591	145
2015-03-31	38	8	7	0	1,288	3,841	590	145
2015-02-28	19	7	2	0	1,280	3,802	583	145
2015-01-31	18	4	0	0	1,273	3,783	581	145
2014-12-31	26	7	1	0	1,269	3,765	581	145
2014-11-30	52	11	1	0	1,262	3,739	580	145
2014-10-31	46	12	0	0	1,251	3,686	579	145
2014-09-30	87	21	0	0	1,239	3,641	579	145
2014-08-31	35	9	5	1	1,218	3,554	579	145
2014-07-31	42	8	11	0	1,209	3,519	574	144
2014-06-30	58	16	5	0	1,201	3,477	563	144
2014-05-31	51	15	2	0	1,185	3,419	558	144
2014-04-30	36	8	1	0	1,170	3,368	556	144
2014-03-31	42	12	3	1	1,162	3,332	555	144
2014-02-28	51	12	4	0	1,150	3,290	552	143
2014-01-31	22	7	3	0	1,138	3,240	548	143
2013-12-31	23	8	3	0	1,131	3,218	545	143
2013-11-30	19	6	2	0	1,123	3,195	542	143
2013-10-31	24	7	2	0	1,117	3,176	540	143
2013-09-30	56	14	2	0	1,110	3,152	538	143
2013-08-31	46	16	4	1	1,096	3,096	536	143
2013-07-31	45	14	2	0	1,080	3,050	532	142
2013-06-30	152	35	3	1	1,066	3,005	530	142
2013-05-31	73	18	1	0	1,031	2,853	527	141
2013-04-30	60	15	2	0	1,013	2,780	526	141
2013-03-31	61	16	2	1	998	2,720	524	141
2013-02-28	65	15	1	0	982	2,658	522	140
2013-01-31	24	9	0	0	967	2,593	521	140
2012-12-31	86	24	5	1	958	2,570	521	140
2012-11-30	79	26	0	1	934	2,484	516	139
2012-10-31	72	21	5	2	908	2,405	516	138
2012-09-30	87	28	2	1	887	2,333	511	136
2012-08-31	120	31	2	0	859	2,246	509	135
2012-07-31	119	35	3	0	828	2,126	507	135
2012-06-30	148	43	4	0	793	2,006	504	135
2012-05-31	145	46	4	2	750	1,859	500	135
2012-04-30	118	35	5	1	704	1,714	496	133
2012-03-31	71	25	3	1	669	1,596	491	132
2012-02-29	97	30	5	2	644	1,525	488	131
2012-01-31	18	8	3	0	614	1,428	483	129
2011-12-31	58	19	2	2	606	1,410	480	129
2011-11-30	38	12	3	5	587	1,352	478	127
2011-10-31	25	11	2	2	575	1,314	475	122
2011-09-30	69	15	3	6	564	1,289	473	120
2011-08-31	44	18	1	2	549	1,220	470	114
2011-07-31	61	28	5	5	531	1,176	469	112
2011-06-30	216	76	10	0	503	1,116	464	107
2011-05-31	142	52	8	1	427	900	454	107
2011-04-30	86	33	5	1	375	757	446	106
2011-03-31	79	37	10	3	342	671	441	105
2011-02-28	48	20	3	3	305	592	431	102
2011-01-31	62	25	1	1	285	544	428	99
2010-12-31	28	12	1	2	260	482	427	98
2010-11-30	44	18	8	2	248	454	426	96
2010-10-31	35	14	8	1	230	410	418	94
2010-09-30	42	18	5	1	216	375	410	93
2010-08-31	36	15	11	3	198	333	405	92
2010-07-31	30	15	13	4	183	297	394	89
2010-06-30	29	16	9	1	168	267	381	85
2010-05-31	24	10	4	1	152	238	372	84
2010-04-30	17	8	2	5	142	214	368	83
2010-03-31	16	8	5	1	134	197	366	78
2010-02-28	14	9	10	3	126	181	361	77
2010-01-31	13	8	4	1	117	168	351	74
2009-12-31	27	16	11	4	109	155	347	73
2009-11-30	17	12	7	5	93	128	336	69
2009-10-31	16	11	11	5	81	110	329	64
2009-09-30	10	9	6	6	70	94	318	59
2009-08-31	3	4	6	3	61	84	312	53
2009-07-31	13	9	15	3	57	80	306	50
2009-06-30	9	8	2	3	48	68	291	47
2009-05-31	4	4	3	2	40	59	289	44
2009-04-30	6	7	1	2	36	55	286	42
2009-03-31	1	1	7	5	29	48	285	40
2009-02-28	8	4	2	1	28	47	278	35
2009-01-31	2	2	4	0	24	39	276	34
2008-12-31	3	2	4	2	22	37	272	34
2008-11-30	4	3	2	1	20	34	268	32
2008-10-31	4	3	4	2	17	30	266	31
2008-09-30	2	1	7	0	14	27	262	29
2008-08-31	4	3	6	3	13	25	255	29
2008-07-31	3	1	4	0	10	21	249	26
2008-06-30	4	1	4	1	9	18	245	26
2008-05-31	1	1	2	0	8	14	241	25
2008-04-30	1	1	4	2	7	13	239	25
2008-03-31	0	0	3	2	6	12	235	23
2008-02-29	0	0	1	0	6	12	232	21
2008-01-31	1	1	4	0	6	12	231	21
2007-12-31	2	1	4	1	5	11	227	21
2007-11-30	0	0	5	2	4	8	223	20
2007-10-31	0	0	7	2	4	8	218	18
2007-09-30	4	1	5	3	4	8	211	16
2007-08-31	2	1	3	0	3	4	206	13
2007-07-31	0	0	4	0	2	2	203	13
2007-06-30	0	0	2	2	2	2	199	13
2007-05-31	0	0	11	2	2	2	197	11
2007-04-30	0	0	6	2	2	2	186	9
2007-03-31	0	0	3	0	2	2	180	7
2007-02-28	0	0	5	3	2	2	177	7
2007-01-31	0	0	4	0	2	2	172	4
2006-12-31	0	0	3	0	2	2	168	4
2006-11-30	0	0	5	2	2	2	165	4
2006-10-31	0	0	3	1	2	2	160	2
2006-09-30	0	0	4	0	2	2	157	1
2006-08-31	0	0	0	0	2	2	153	1
2006-07-31	0	0	4	0	2	2	153	1
2006-06-30	0	0	1	0	2	2	149	1
2006-05-31	0	0	1	0	2	2	148	1
2006-04-30	0	0	1	0	2	2	147	1
2006-03-31	0	0	1	0	2	2	146	1
2006-02-28	0	0	6	1	2	2	145	1
2006-01-31	0	0	3	0	2	2	139	0
2005-12-31	0	0	2	0	2	2	136	0
2005-11-30	0	0	2	0	2	2	134	0
2005-10-31	0	0	4	0	2	2	132	0
2005-09-30	0	0	1	0	2	2	128	0
2005-08-31	0	0	3	0	2	2	127	0
2005-07-31	0	0	3	0	2	2	124	0
2005-06-30	0	0	5	0	2	2	121	0
2005-05-31	0	0	7	0	2	2	116	0
2005-04-30	0	0	6	0	2	2	109	0
2005-03-31	0	0	0	0	2	2	103	0
2005-02-28	0	0	0	0	2	2	103	0
2005-01-31	0	0	1	0	2	2	103	0
2004-12-31	1	1	1	0	2	2	102	0
2004-11-30	0	0	3	0	1	2	101	0
2004-10-31	0	0	4	0	1	2	98	0
2004-09-30	0	0	5	0	1	2	94	0
2004-08-31	0	0	3	0	1	2	89	0
2004-07-31	0	0	3	0	1	2	86	0
2004-06-30	0	0	1	0	1	2	83	0
2004-05-31	0	0	2	0	1	2	82	0
2004-04-30	0	0	3	0	1	2	80	0
2004-03-31	0	0	1	0	1	2	77	0
2004-02-29	0	0	4	0	1	2	76	0
2004-01-31	0	0	0	0	1	2	72	0
2003-12-31	0	0	3	0	1	2	72	0
2003-11-30	0	0	2	0	1	2	69	0
2003-10-31	0	0	2	0	1	2	67	0
2003-09-30	0	0	5	0	1	2	65	0
2003-08-31	2	1	3	0	1	2	60	0
2003-07-31	0	0	2	0	0	0	57	0
2003-06-30	0	0	3	0	0	0	55	0
2003-05-31	0	0	1	0	0	0	52	0
2003-04-30	0	0	2	0	0	0	51	0
2003-03-31	0	0	3	0	0	0	49	0
2003-02-28	0	0	1	0	0	0	46	0
2003-01-31	0	0	3	0	0	0	45	0
2002-12-31	0	0	2	0	0	0	42	0
2002-11-30	0	0	5	0	0	0	40	0
2002-10-31	0	0	4	0	0	0	35	0
2002-09-30	0	0	1	0	0	0	31	0
2002-08-31	0	0	3	0	0	0	30	0
2002-07-31	0	0	1	0	0	0	27	0
2002-06-30	0	0	1	0	0	0	26	0
2002-05-31	0	0	2	0	0	0	25	0
2002-04-30	0	0	0	0	0	0	23	0
2002-03-31	0	0	2	0	0	0	23	0
2002-02-28	0	0	2	0	0	0	21	0
2002-01-31	0	0	0	0	0	0	19	0
2001-12-31	0	0	4	0	0	0	19	0
2001-11-30	0	0	4	0	0	0	15	0
2001-10-31	0	0	1	0	0	0	11	0
2001-09-30	0	0	3	0	0	0	10	0
2001-08-31	0	0	1	0	0	0	7	0
2001-07-31	0	0	1	0	0	0	6	0
2001-06-30	0	0	4	0	0	0	5	0
2001-05-31	0	0	0	0	0	0	1	0
2001-04-30	0	0	1	0	0	0	1	0

==== TO DO ===== Add some words of explanation in here….

Graphs for postcode 4563

==== TO DO ===== add words of explanation

==== TO DO ===== add words of explanation

==== TO DO ===== add words of explanation

==== TO DO ===== add words of explanation

Energex Consumption

year_month	bus_kWh	resi_kWh	solar_kWh	bus_NMI	resi_NMI	solar_NMI	bus_daily	resi_daily	solar_daily
2022-09-30	1058481	1948105	775684.4	386	4022	2199	91.40595	16.14541	11.758138
2022-08-31	1181144	2346973	728147.7	386	3981	2173	98.70831	19.01754	10.809312
2022-07-31	1258378	2611422	565851.1	384	3986	2157	105.71048	21.13383	8.462338
2022-06-30	1223347	2410741	607398.9	385	4042	2174	105.91747	19.88076	9.313077
2022-05-31	1201893	2225084	463994.2	381	4046	2177	101.76047	17.74021	6.875313
2022-04-30	1055759	1985183	648873.7	381	4048	2176	92.36735	16.34703	9.939854
2022-03-31	1124871	2081473	732965.6	381	4052	2174	95.23928	16.57066	10.875829
2022-02-28	1014260	1897451	732997.0	384	4051	2171	94.33220	16.72824	12.058252
2022-01-31	1120169	2127463	785665.7	386	4054	2162	93.61263	16.92843	11.722504
2021-12-31	1187023	2078684	875796.5	386	4058	2164	99.19966	16.52399	13.055222
2021-11-30	1194936	1898663	802355.5	387	4058	2162	102.92296	15.59605	12.370575
2021-10-31	1104073	1910019	941777.7	386	4059	2146	92.26748	15.17948	14.156535
2021-09-30	1052237	1888298	896619.6	386	4065	2140	90.86673	15.48420	13.966038
2021-08-31	1017055	2191094	777435.8	385	4055	2119	85.21615	17.43045	11.835099
2021-07-31	1055816	2403447	617534.7	385	4059	2107	88.46385	19.10090	9.454425
2021-06-30	1080207	2295309	546847.3	387	4058	2098	93.04111	18.85419	8.688391
2021-05-31	1100627	2095640	639198.0	389	4049	2091	91.27019	16.69580	9.860971
2021-04-30	1011529	1929376	651211.5	389	4043	2068	86.67769	15.90713	10.496639
2021-03-31	1177838	2014735	638390.1	387	4039	2051	98.17769	16.09097	10.040580
2021-02-28	1102774	1863272	641518.4	388	4040	2030	101.50722	16.47164	11.286390
2021-01-31	1171753	2080022	743585.8	387	4038	2015	97.67053	16.61652	11.904039
2020-12-31	1205474	2095260	736276.3	388	4032	2008	100.22233	16.76315	11.828112
2020-11-30	1151360	1869502	816481.3	387	4030	2001	99.16971	15.46321	13.601221
2020-10-31	1121647	1854812	798324.2	386	4027	1980	93.73614	14.85787	13.006259
2020-09-30	1038144	1855746	689773.8	387	4030	1954	89.41809	15.34943	11.766867
2020-08-31	1015504	2131967	641330.9	390	4011	1940	83.99538	17.14613	10.663966
2020-07-31	1070443	2324446	508209.3	388	4000	1918	88.99590	18.74553	8.547367
2020-06-30	1102141	2216057	445414.8	388	3998	1898	94.68563	18.47638	7.822529
2020-05-31	1117118	2124337	468000.0	388	3984	1863	92.87642	17.20055	8.103475
2020-04-30	1043506	1924053	499800.9	344	3976	1814	101.11496	16.13056	9.184140
2020-03-31	1168670	1983312	515764.4	344	3966	1787	109.59020	16.13157	9.310331
2020-02-29	1142931	1952112	468200.3	348	3960	1775	113.25122	16.99854	9.095683
2020-01-31	1228439	2093162	568596.3	347	3947	1761	114.19900	17.10701	10.415569
2019-12-31	1214017	2042209	620059.9	349	3946	1745	112.21160	16.69481	11.462426
2019-11-30	1188878	1828691	652422.4	350	3940	1730	113.22647	15.47116	12.570758
2019-10-31	1179143	1791310	654363.4	350	3927	1713	108.67678	14.71459	12.322531
2019-09-30	1075835	1765212	607961.4	348	3918	1692	103.04931	15.01797	11.977175
2019-08-31	1081394	2002945	522488.4	349	3914	1678	99.95326	16.50770	10.044377
2019-07-31	1116861	2149424	418879.1	347	3892	1654	103.82647	17.81507	8.169426
2019-06-30	1174920	2091957	349681.7	348	3877	1636	112.54023	17.98605	7.124730
2019-05-31	1143973	2017561	365708.6	348	3876	1628	106.04122	16.79118	7.246346
2019-04-30	1052136	1868207	363759.8	349	3865	1616	100.49059	16.11218	7.503297
2019-03-31	1206336	1941348	393524.6	349	3860	1592	111.50165	16.22387	7.973833
2019-02-28	1107397	1761643	400069.5	351	3853	1586	112.67778	16.32905	9.008951
2019-01-31	1203510	1969247	476228.0	351	3844	1580	110.60655	16.52552	9.722907
2018-12-31	1141966	1937971	463143.9	352	3836	1560	104.65226	16.29697	9.577004
2018-11-30	1127107	1826697	477105.2	353	3838	1551	106.43122	15.86500	10.253711
2018-10-31	1052707	1855436	462495.0	352	3826	1528	96.47237	15.64370	9.763870
2018-09-30	1002137	1802685	441703.1	352	3820	1516	94.89929	15.73024	9.712028
2018-08-31	1098354	1990027	406917.0	353	3813	1497	100.37044	16.83567	8.768440
2018-07-31	1073884	2099513	343963.2	348	3796	1470	99.54428	17.84147	7.548019
2018-06-30	1062601	2031912	302108.0	346	3786	1456	102.37006	17.88970	6.916392
2018-05-31	1115681	1951895	315386.5	347	3779	1443	103.71677	16.66164	7.050421
2018-04-30	1126184	1820714	304975.9	347	3770	1421	108.18290	16.09827	7.154021
2018-03-31	1268409	1886746	315152.0	347	3763	1386	117.91476	16.17400	7.334915
2018-02-28	1251731	1768770	316132.8	353	3750	1387	126.64217	16.84543	8.140200
2018-01-31	1317561	1970857	371974.6	350	3739	1372	121.43424	17.00349	8.745759
2017-12-31	1244065	1933726	376341.5	351	3732	1360	114.33374	16.71443	8.926506
2017-11-30	1143629	1767275	363701.1	354	3733	1360	107.68637	15.78065	8.914241
2017-10-31	1156121	1758907	372957.0	350	3722	1351	106.55491	15.24421	8.905161
2017-09-30	1242515	1698169	365302.0	349	3710	1343	118.67386	15.25758	9.066815
2017-08-31	1161376	1832355	346165.6	352	3700	1332	106.43111	15.97520	8.383357
2017-07-31	1196582	1927065	302840.6	352	3680	1316	109.65747	16.89222	7.423293
2017-06-30	1227664	1885744	264065.1	354	3666	1305	115.59921	17.14625	6.744959
2017-05-31	1241814	1870951	265441.2	355	3656	1300	112.84094	16.50800	6.586629
2017-04-30	1101539	1775526	259916.0	353	3624	1283	104.01688	16.33118	6.752820
2017-03-31	1242873	1861112	275122.6	354	3623	1269	113.25618	16.57076	6.993635
2017-02-28	1250721	1774915	266471.9	356	3613	1247	125.47359	17.54492	7.631798
2017-01-31	1424167	2021007	312782.5	355	3591	1242	129.41092	18.15477	8.123800
2016-12-31	1386168	1976678	329350.3	354	3572	1237	126.31387	17.85101	8.588685
2016-11-30	1239816	1805721	334097.9	355	3555	1236	116.41460	16.93128	9.010190
2016-10-31	1202018	1785385	346857.2	352	3547	1228	110.15563	16.23712	9.111517
2016-09-30	1168006	1764981	310667.3	353	3544	1221	110.29327	16.60065	8.481226
2016-08-31	1250474	1963678	274433.8	353	3540	1217	114.27162	17.89391	7.274202
2016-07-31	1210221	2070876	226897.4	352	3534	1203	110.90737	18.90279	6.084183
2016-06-30	1200741	1988627	209157.5	351	3533	1202	114.03053	18.76240	5.800264
2016-05-31	1239903	1910067	232595.9	351	3533	1198	113.95122	17.43987	6.263017
2016-04-30	1169199	1775527	241090.4	349	3514	1193	111.67134	16.84241	6.736251
2016-03-31	1189539	1828159	260954.6	353	3513	1190	108.70322	16.78704	7.073858
2016-02-29	1190948	1743230	253666.9	354	3511	1190	116.00895	17.12087	7.350532
2016-01-31	1202504	1874945	280473.3	354	3504	1179	109.57758	17.26088	7.673897

==== TO DO ===== add words of explanation

Noosa Monthly Graphs- 4563

==== TO DO ===== add words of explanation

==== TO DO ===== add words of explanation

==== TO DO ===== add words of explanation

==== TO DO ===== add words of explanation blah blah blah

Noosa Forecasts- 4563

Should refactor to move forecast code to Main_1.Rmd and save results for later use

APVI installation ranges

Best to grab code from “test script.R” - use the yearly 100% code and use more meaningful headings

4565

Latest data for postcode 4565

Boreen Point, Cooroibah, Cootharaba, Noosa North Shore, Ringtail Creek, Tewantin

Solar PV Installations	Value
Total Solar PV installations	3,887
Increase in the last 12 months	244
Average monthly increase - last 12 months	20
Increase in installations - last 12 months	6.7 %

Solar PV Capacity	Value
Total solar PV capacity (kW)	19,492
Increase in last 12 months (kW)	2,197
Average monthly increase last 12 months (kW)	183
Increase in capacity - last 12 months (kW)	12.7 %

Energex Connections	Value
Residential connections - NMI	6,695
Residential solar connections - NMI	3,233
Business connections - NMI	344
Business solar connections - NMI	66

Batteries	Value
Residential count	58
Residential capacity - kW	414
Residential storage - kWh	683
Business count	0
Business capacity - kW	0
Business storage - kWh	0

4565 Postcode map

As at December 31, 2022

2021 census dwellings = 6,950

The number of solar installations was 3,887 with total capacity of 19,492 kW.

This represents an increase in capacity of 2,197 kW over the last 12 months, giving an average monthly increase of 183 kW per month.

The corresponding increase in the number of solar installations in the last 12 months was 244, giving an average monthly increase of 20 new installations per month.

The increase in capacity over the last 12 months was 12.7 %

The increase in the number if installations over the last 12 months was 6.7 %

Solar installs and capacity

	per month				total
Date	PV qty	kW	SWH qty	HPSWH qty	PV qty	kW	SWH qty	HPSWH qty
2022-12-31	158	15	1	1	3,887	19,492	954	295
2022-11-30	195	23	2	0	3,872	19,334	953	294
2022-10-31	266	28	2	1	3,849	19,139	951	294
2022-09-30	191	22	2	2	3,821	18,873	949	293
2022-08-31	213	27	5	1	3,799	18,682	947	291
2022-07-31	131	15	2	1	3,772	18,468	942	290
2022-06-30	181	25	3	2	3,757	18,338	940	289
2022-05-31	105	13	2	2	3,732	18,157	937	287
2022-04-30	170	18	2	2	3,719	18,052	935	285
2022-03-31	313	26	2	2	3,701	17,882	933	283
2022-02-28	129	14	0	0	3,675	17,568	931	281
2022-01-31	144	18	0	0	3,661	17,439	931	281
2021-12-31	172	22	0	2	3,643	17,295	931	281
2021-11-30	295	32	0	0	3,621	17,123	931	279
2021-10-31	192	23	3	2	3,589	16,828	931	279
2021-09-30	250	33	3	1	3,566	16,636	928	277
2021-08-31	306	42	6	1	3,533	16,386	925	276
2021-07-31	418	59	2	1	3,491	16,080	919	275
2021-06-30	360	50	4	2	3,432	15,662	917	274
2021-05-31	323	34	1	2	3,382	15,302	913	272
2021-04-30	204	29	5	2	3,348	14,979	912	270
2021-03-31	127	18	0	0	3,319	14,775	907	268
2021-02-28	283	36	3	2	3,301	14,648	907	268
2021-01-31	154	22	3	1	3,265	14,366	904	266
2020-12-31	331	33	1	0	3,243	14,212	901	265
2020-11-30	262	35	2	1	3,210	13,881	900	265
2020-10-31	233	29	1	0	3,175	13,619	898	264
2020-09-30	179	21	3	0	3,146	13,386	897	264
2020-08-31	205	27	3	3	3,125	13,207	894	264
2020-07-31	268	33	1	1	3,098	13,002	891	261
2020-06-30	161	22	2	0	3,065	12,734	890	260
2020-05-31	146	22	2	1	3,043	12,573	888	260
2020-04-30	198	30	0	1	3,021	12,427	886	259
2020-03-31	421	48	1	0	2,991	12,229	886	258
2020-02-29	265	32	0	0	2,943	11,809	885	258
2020-01-31	143	22	2	0	2,911	11,544	885	258
2019-12-31	254	30	3	0	2,889	11,400	883	258
2019-11-30	186	25	5	1	2,859	11,146	880	258
2019-10-31	166	20	0	0	2,834	10,960	875	257
2019-09-30	135	20	4	0	2,814	10,794	875	257
2019-08-31	117	18	4	0	2,794	10,659	871	257
2019-07-31	153	21	3	0	2,776	10,542	867	257
2019-06-30	133	19	1	0	2,755	10,390	864	257
2019-05-31	312	37	1	1	2,736	10,257	863	257
2019-04-30	215	24	2	0	2,699	9,945	862	256
2019-03-31	145	21	0	1	2,675	9,730	860	256
2019-02-28	187	28	2	0	2,654	9,586	860	255
2019-01-31	65	10	2	1	2,626	9,398	858	255
2018-12-31	209	18	1	4	2,616	9,333	856	254
2018-11-30	187	25	5	0	2,598	9,124	855	250
2018-10-31	118	19	1	2	2,573	8,937	850	250
2018-09-30	67	11	4	1	2,554	8,819	849	248
2018-08-31	85	12	5	2	2,543	8,752	845	247
2018-07-31	101	14	2	2	2,531	8,667	840	245
2018-06-30	240	25	2	1	2,517	8,566	838	243
2018-05-31	178	23	4	1	2,492	8,326	836	242
2018-04-30	111	13	3	0	2,469	8,149	832	241
2018-03-31	127	19	1	0	2,456	8,038	829	241
2018-02-28	83	14	3	0	2,437	7,911	828	241
2018-01-31	73	12	2	0	2,423	7,828	825	241
2017-12-31	123	19	4	1	2,411	7,755	823	241
2017-11-30	110	18	3	2	2,392	7,632	819	240
2017-10-31	126	22	2	0	2,374	7,523	816	238
2017-09-30	146	25	6	0	2,352	7,397	814	238
2017-08-31	107	18	4	0	2,327	7,251	808	238
2017-07-31	78	15	3	0	2,309	7,144	804	238
2017-06-30	104	20	1	1	2,294	7,065	801	238
2017-05-31	64	13	5	0	2,274	6,961	800	237
2017-04-30	73	14	0	1	2,261	6,897	795	237
2017-03-31	87	17	4	1	2,247	6,824	795	236
2017-02-28	111	21	1	1	2,230	6,736	791	235
2017-01-31	60	12	5	0	2,209	6,625	790	234
2016-12-31	111	22	2	1	2,197	6,565	785	234
2016-11-30	101	19	2	0	2,175	6,454	783	233
2016-10-31	72	15	1	0	2,156	6,353	781	233
2016-09-30	189	24	1	0	2,141	6,281	780	233
2016-08-31	83	16	2	1	2,117	6,092	779	233
2016-07-31	53	12	3	0	2,101	6,009	777	232
2016-06-30	88	16	2	0	2,089	5,956	774	232
2016-05-31	68	13	2	0	2,073	5,868	772	232
2016-04-30	42	10	4	0	2,060	5,801	770	232
2016-03-31	22	6	3	0	2,050	5,759	766	232
2016-02-29	158	15	6	0	2,044	5,736	763	232
2016-01-31	39	10	0	3	2,029	5,579	757	232
2015-12-31	35	8	2	0	2,019	5,540	757	229
2015-11-30	40	8	6	0	2,011	5,505	755	229
2015-10-31	61	14	2	0	2,003	5,465	749	229
2015-09-30	39	13	5	0	1,989	5,404	747	229
2015-08-31	26	6	1	0	1,976	5,365	742	229
2015-07-31	129	27	4	0	1,970	5,339	741	229
2015-06-30	87	19	2	0	1,943	5,209	737	229
2015-05-31	85	21	7	0	1,924	5,123	735	229
2015-04-30	65	16	7	0	1,903	5,038	728	229
2015-03-31	84	23	3	0	1,887	4,973	721	229
2015-02-28	54	14	1	0	1,864	4,889	718	229
2015-01-31	63	16	3	0	1,850	4,835	717	229
2014-12-31	35	10	2	0	1,834	4,772	714	229
2014-11-30	58	19	3	1	1,824	4,736	712	229
2014-10-31	64	19	3	1	1,805	4,678	709	228
2014-09-30	90	24	2	1	1,786	4,615	706	227
2014-08-31	59	13	5	0	1,762	4,525	704	226
2014-07-31	66	18	6	1	1,749	4,466	699	226
2014-06-30	72	18	2	0	1,731	4,400	693	225
2014-05-31	59	11	3	1	1,713	4,328	691	225
2014-04-30	47	12	3	0	1,702	4,269	688	224
2014-03-31	53	12	4	0	1,690	4,223	685	224
2014-02-28	48	13	1	0	1,678	4,169	681	224
2014-01-31	33	9	3	0	1,665	4,121	680	224
2013-12-31	43	11	3	0	1,656	4,088	677	224
2013-11-30	35	13	4	1	1,645	4,046	674	224
2013-10-31	49	11	2	0	1,632	4,011	670	223
2013-09-30	76	23	0	1	1,621	3,962	668	223
2013-08-31	40	16	2	0	1,598	3,886	668	222
2013-07-31	79	24	4	1	1,582	3,846	666	222
2013-06-30	179	44	2	2	1,558	3,766	662	221
2013-05-31	96	28	3	1	1,514	3,587	660	219
2013-04-30	84	25	0	0	1,486	3,491	657	218
2013-03-31	85	29	2	0	1,461	3,407	657	218
2013-02-28	71	22	2	0	1,432	3,322	655	218
2013-01-31	68	20	1	0	1,410	3,250	653	218
2012-12-31	149	39	3	0	1,390	3,183	652	218
2012-11-30	101	30	4	1	1,351	3,034	649	218
2012-10-31	98	36	3	0	1,321	2,933	645	217
2012-09-30	92	32	4	0	1,285	2,835	642	217
2012-08-31	160	57	4	2	1,253	2,742	638	217
2012-07-31	78	29	0	0	1,196	2,582	634	215
2012-06-30	258	95	0	1	1,167	2,503	634	215
2012-05-31	147	50	1	0	1,072	2,246	634	214
2012-04-30	105	35	3	0	1,022	2,099	633	214
2012-03-31	63	29	3	1	987	1,993	630	214
2012-02-29	57	22	1	0	958	1,930	627	213
2012-01-31	23	9	5	3	936	1,873	626	213
2011-12-31	105	25	3	3	927	1,850	621	210
2011-11-30	61	26	8	7	902	1,745	618	207
2011-10-31	46	18	3	13	876	1,684	610	200
2011-09-30	71	33	6	3	858	1,638	607	187
2011-08-31	32	13	0	4	825	1,567	601	184
2011-07-31	50	22	3	2	812	1,535	601	180
2011-06-30	286	114	3	1	790	1,485	598	178
2011-05-31	193	86	10	18	676	1,199	595	177
2011-04-30	82	41	7	15	590	1,006	585	159
2011-03-31	75	40	6	2	549	924	578	144
2011-02-28	103	49	5	4	509	848	572	142
2011-01-31	55	24	4	4	460	746	567	138
2010-12-31	68	27	5	5	436	691	563	134
2010-11-30	45	25	8	2	409	622	558	129
2010-10-31	29	15	9	8	384	577	550	127
2010-09-30	33	18	21	2	369	548	541	119
2010-08-31	75	39	10	2	351	515	520	117
2010-07-31	77	43	20	3	312	440	510	115
2010-06-30	45	36	11	8	269	363	490	112
2010-05-31	28	14	8	2	233	318	479	104
2010-04-30	26	13	10	1	219	290	471	102
2010-03-31	24	12	10	2	206	264	461	101
2010-02-28	15	10	26	1	194	240	451	99
2010-01-31	13	11	10	5	184	225	425	98
2009-12-31	38	30	10	4	173	211	415	93
2009-11-30	32	27	10	3	143	174	405	89
2009-10-31	12	10	13	5	116	142	395	86
2009-09-30	6	6	13	11	106	130	382	81
2009-08-31	12	11	6	3	100	123	369	70
2009-07-31	19	18	9	5	89	112	363	67
2009-06-30	17	14	13	2	71	93	354	62
2009-05-31	12	11	13	5	57	76	341	60
2009-04-30	8	7	4	3	46	64	328	55
2009-03-31	7	6	5	3	39	56	324	52
2009-02-28	4	3	3	5	33	49	319	49
2009-01-31	2	2	5	0	30	45	316	44
2008-12-31	3	4	9	1	28	43	311	44
2008-11-30	1	1	7	4	24	40	302	43
2008-10-31	8	5	6	3	23	38	295	39
2008-09-30	8	7	2	1	18	30	289	36
2008-08-31	2	1	10	2	11	22	287	35
2008-07-31	2	2	4	4	10	20	277	33
2008-06-30	1	1	5	5	8	18	273	29
2008-05-31	6	1	2	3	7	17	268	24
2008-04-30	0	0	2	1	6	11	266	21
2008-03-31	0	0	4	2	6	11	264	20
2008-02-29	3	2	3	0	6	11	260	18
2008-01-31	0	0	5	1	4	9	257	18
2007-12-31	0	0	4	0	4	9	252	17
2007-11-30	0	0	2	1	4	9	248	17
2007-10-31	0	0	1	2	4	9	246	16
2007-09-30	0	0	8	1	4	9	245	14
2007-08-31	0	0	4	1	4	9	237	13
2007-07-31	0	0	10	4	4	9	233	12
2007-06-30	0	0	6	1	4	9	223	8
2007-05-31	0	0	4	4	4	9	217	7
2007-04-30	0	0	2	0	4	9	213	3
2007-03-31	0	0	1	0	4	9	211	3
2007-02-28	0	0	0	0	4	9	210	3
2007-01-31	0	0	1	0	4	9	210	3
2006-12-31	0	0	1	0	4	9	209	3
2006-11-30	0	0	6	0	4	9	208	3
2006-10-31	0	0	5	0	4	9	202	3
2006-09-30	0	0	1	1	4	9	197	3
2006-08-31	0	0	5	1	4	9	196	2
2006-07-31	0	0	1	0	4	9	191	1
2006-06-30	0	0	2	0	4	9	190	1
2006-05-31	0	0	1	0	4	9	188	1
2006-04-30	0	0	4	0	4	9	187	1
2006-03-31	0	0	1	0	4	9	183	1
2006-02-28	0	0	2	0	4	9	182	1
2006-01-31	0	0	1	0	4	9	180	1
2005-12-31	0	0	0	0	4	9	179	1
2005-11-30	0	0	0	0	4	9	179	1
2005-10-31	0	0	2	0	4	9	179	1
2005-09-30	0	0	2	0	4	9	177	1
2005-08-31	0	0	4	0	4	9	175	1
2005-07-31	0	0	2	0	4	9	171	1
2005-06-30	0	0	7	0	4	9	169	1
2005-05-31	0	0	4	0	4	9	162	1
2005-04-30	0	0	2	0	4	9	158	1
2005-03-31	0	0	1	1	4	9	156	1
2005-02-28	0	0	1	0	4	9	155	0
2005-01-31	0	0	4	0	4	9	154	0
2004-12-31	0	0	4	0	4	9	150	0
2004-11-30	0	0	3	0	4	9	146	0
2004-10-31	0	0	3	0	4	9	143	0
2004-09-30	0	0	4	0	4	9	140	0
2004-08-31	0	0	6	0	4	9	136	0
2004-07-31	0	0	3	0	4	9	130	0
2004-06-30	0	0	3	0	4	9	127	0
2004-05-31	1	1	0	0	4	9	124	0
2004-04-30	2	1	1	0	3	8	124	0
2004-03-31	0	0	8	0	2	6	123	0
2004-02-29	0	0	0	0	2	6	115	0
2004-01-31	0	0	3	0	2	6	115	0
2003-12-31	0	0	0	0	2	6	112	0
2003-11-30	0	0	3	0	2	6	112	0
2003-10-31	0	0	4	0	2	6	109	0
2003-09-30	0	0	2	0	2	6	105	0
2003-08-31	0	0	0	0	2	6	103	0
2003-07-31	0	0	7	0	2	6	103	0
2003-06-30	3	1	6	0	2	6	96	0
2003-05-31	0	0	1	0	1	4	90	0
2003-04-30	0	0	3	0	1	4	89	0
2003-03-31	0	0	7	0	1	4	86	0
2003-02-28	0	0	3	0	1	4	79	0
2003-01-31	0	0	4	0	1	4	76	0
2002-12-31	0	0	0	0	1	4	72	0
2002-11-30	0	0	4	0	1	4	72	0
2002-10-31	0	0	2	0	1	4	68	0
2002-09-30	4	1	6	0	1	4	66	0
2002-08-31	0	0	6	0	0	0	60	0
2002-07-31	0	0	6	0	0	0	54	0
2002-06-30	0	0	5	0	0	0	48	0
2002-05-31	0	0	6	0	0	0	43	0
2002-04-30	0	0	4	0	0	0	37	0
2002-03-31	0	0	3	0	0	0	33	0
2002-02-28	0	0	1	0	0	0	30	0
2002-01-31	0	0	4	0	0	0	29	0
2001-12-31	0	0	0	0	0	0	25	0
2001-11-30	0	0	3	0	0	0	25	0
2001-10-31	0	0	7	0	0	0	22	0
2001-09-30	0	0	6	0	0	0	15	0
2001-08-31	0	0	1	0	0	0	9	0
2001-07-31	0	0	2	0	0	0	8	0
2001-06-30	0	0	2	0	0	0	6	0
2001-05-31	0	0	3	0	0	0	4	0
2001-04-30	0	0	1	0	0	0	1	0

==== TO DO ===== Add some words of explanation in here….

Graphs for postcode 4565

==== TO DO ===== add words of explanation

==== TO DO ===== add words of explanation

==== TO DO ===== add words of explanation

==== TO DO ===== add words of explanation

Energex Consumption

year_month	bus_kWh	resi_kWh	solar_kWh	bus_NMI	resi_NMI	solar_NMI	bus_daily	resi_daily	solar_daily
2022-09-30	1066093.9	2905267	1013725.7	344	6695	3006	103.30367	14.46486	11.241136
2022-08-31	1157729.5	3277645	971485.8	341	6708	3001	109.51939	15.76185	10.442603
2022-07-31	1150859.1	3681618	713054.1	338	6726	3000	109.83576	17.65713	7.667249
2022-06-30	1064547.2	3462368	746153.7	337	6720	2977	105.29646	17.17445	8.354649
2022-05-31	1115402.4	3380953	583369.6	336	6725	2981	107.08549	16.21755	6.312772
2022-04-30	1192140.4	3021303	867374.8	342	6736	2992	116.19302	14.95103	9.663266
2022-03-31	1327493.6	3129094	949742.6	343	6725	2973	124.84658	15.00944	10.305031
2022-02-28	1204168.9	2861011	952395.0	344	6730	2966	125.01754	15.18261	11.468006
2022-01-31	1401640.6	3234154	1041513.3	342	6736	2957	132.20530	15.48806	11.361922
2021-12-31	1368921.3	3167794	1135562.4	339	6740	2943	130.26181	15.16126	12.446839
2021-11-30	1237112.5	2911112	1039875.6	340	6736	2927	121.28553	14.40574	11.842337
2021-10-31	1214127.2	2944131	1174305.6	340	6743	2907	115.19234	14.08453	13.030900
2021-09-30	1040220.1	2850063	1101515.8	343	6738	2885	101.09039	14.09945	12.726930
2021-08-31	1017595.3	3128448	961269.6	342	6740	2866	95.98145	14.97295	10.819503
2021-07-31	1102413.2	3373990	736025.8	346	6733	2822	102.77953	16.16492	8.413455
2021-06-30	1072958.7	3311236	620143.6	345	6727	2779	103.66751	16.40769	7.438450
2021-05-31	1081118.7	3226358	712282.5	341	6728	2764	102.27213	15.46910	8.312900
2021-04-30	1102749.9	3029984	759476.1	343	6732	2747	107.16714	15.00289	9.215824
2021-03-31	1297163.8	3127158	762384.3	341	6722	2725	122.70966	15.00685	9.024970
2021-02-28	1190746.3	2885133	740990.5	343	6724	2703	123.98442	15.32428	9.790583
2021-01-31	1331914.7	3219326	874271.5	347	6721	2688	123.81842	15.45145	10.491929
2020-12-31	1340508.8	3211329	883475.8	343	6721	2671	126.07061	15.41307	10.669868
2020-11-30	1171238.6	2946310	955166.4	341	6718	2646	114.49057	14.61899	12.032834
2020-10-31	1115215.8	2961190	937916.8	344	6712	2624	104.57762	14.23157	11.530252
2020-09-30	1033767.2	2919606	853838.1	343	6713	2600	100.46328	14.49728	10.946643
2020-08-31	1058214.6	3164286	809306.7	341	6716	2582	100.10544	15.19859	10.111026
2020-07-31	1071104.7	3393216	605295.5	342	6722	2561	101.02855	16.28363	7.624233
2020-06-30	947365.7	3286085	516843.1	339	6706	2531	93.15297	16.33405	6.806836
2020-05-31	868945.4	3297636	552680.0	339	6705	2524	82.68583	15.86508	7.063545
2020-04-30	873951.1	3080796	603365.8	344	6715	2517	84.68519	15.29311	7.990542
2020-03-31	1207300.0	3194932	633538.4	342	6705	2478	113.87474	15.37097	8.247265
2020-02-29	1319990.1	3096586	569591.3	340	6706	2452	133.87324	15.92288	8.010228
2020-01-31	1422639.6	3282451	721316.2	344	6710	2433	133.40581	15.78026	9.563610
2019-12-31	1347964.2	3193625	789048.4	343	6704	2412	126.77177	15.36697	10.552726
2019-11-30	1186489.4	2948204	809677.0	343	6709	2397	115.30509	14.64801	11.259588
2019-10-31	1131422.9	2901665	801553.5	347	6708	2386	105.18015	13.95380	10.836783
2019-09-30	1049046.3	2824071	748295.8	344	6706	2358	101.65177	14.03753	10.578114
2019-08-31	1125372.3	3030180	675828.3	345	6702	2344	105.22415	14.58486	9.300730
2019-07-31	1135638.5	3197288	524830.1	348	6703	2322	105.26868	15.38689	7.291129
2019-06-30	1091497.8	3121112	418928.4	343	6696	2294	106.07364	15.53719	6.087306
2019-05-31	1134157.4	3143914	435006.4	344	6687	2277	106.35385	15.16623	6.162699
2019-04-30	1171131.5	2989137	466197.7	334	6696	2258	116.87939	14.88021	6.882162
2019-03-31	1418035.7	3148923	523435.4	334	6686	2229	136.95535	15.19266	7.575151
2019-02-28	1274700.9	2874030	499246.5	337	6686	2212	135.08911	15.35207	8.060683
2019-01-31	1451842.9	3203261	606269.2	338	6685	2208	138.56107	15.45714	8.857370
2018-12-31	1353699.5	3124802	606840.2	335	6671	2195	130.35142	15.11019	8.918218
2018-11-30	1254029.2	2947892	614642.1	333	6675	2191	125.52845	14.72106	9.351013
2018-10-31	1184635.1	2974379	603104.7	335	6664	2182	114.07175	14.39792	8.916127
2018-09-30	1068246.2	2922287	566198.4	334	6665	2161	106.61139	14.61509	8.733586
2018-08-31	1151686.6	3096116	552043.1	332	6665	2156	111.90115	14.98495	8.259667
2018-07-31	1190861.9	3244453	448691.7	336	6669	2143	114.33006	15.69347	6.754049
2018-06-30	1134965.5	3139702	378135.3	334	6665	2119	113.27001	15.70243	5.948329
2018-05-31	1174027.6	3156260	395098.7	335	6670	2109	113.05033	15.26459	6.043205
2018-04-30	1235577.1	3003804	404202.9	336	6672	2095	122.57709	15.00702	6.431231
2018-03-31	1394277.5	3140614	435178.3	335	6658	2069	134.25878	15.21630	6.784926
2018-02-28	1297292.3	2883354	417096.4	339	6658	2062	136.67218	15.46664	7.224200
2018-01-31	1522730.1	3205626	515628.7	346	6653	2057	141.96626	15.54296	8.086137
2017-12-31	1460013.3	3135284	540418.1	344	6642	2047	136.91047	15.22707	8.516288
2017-11-30	1256106.2	2947891	520148.7	346	6644	2050	121.01216	14.78974	8.457703
2017-10-31	1332394.5	2954304	516116.4	347	6643	2035	123.86302	14.34595	8.181285
2017-09-30	1210896.8	2852905	487820.1	349	6642	2010	115.65395	14.31750	8.089885
2017-08-31	1215119.3	3005816	475179.7	346	6640	1995	113.28727	14.60268	7.683397
2017-07-31	1222347.8	3093614	403569.6	348	6635	1983	113.30625	15.04054	6.564989
2017-06-30	1157906.5	2994227	351457.3	347	6633	1960	111.23021	15.04712	5.977164
2017-05-31	1208201.8	3067687	359748.7	348	6633	1955	111.99498	14.91899	5.935957
2017-04-30	1206070.4	3004356	371589.8	347	6631	1945	115.85690	15.10258	6.368291
2017-03-31	1519285.1	3244290	405242.7	347	6626	1935	141.23688	15.79452	6.755734
2017-02-28	1433259.6	3035932	383175.2	349	6625	1916	146.67004	16.36621	7.142395
2017-01-31	1622199.3	3397913	447581.1	351	6622	1903	149.08550	16.55241	7.587021
2016-12-31	1509184.2	3269522	462843.8	351	6615	1881	138.69903	15.94383	7.937505
2016-11-30	1367050.6	3029582	456376.1	348	6615	1875	130.94355	15.26622	8.113352
2016-10-31	1269571.8	3009387	459524.1	350	6617	1866	117.01123	14.67085	7.943922
2016-09-30	1209458.4	2945099	410447.7	352	6612	1845	114.53205	14.84724	7.415496
2016-08-31	1252585.6	3158345	380014.3	345	6610	1837	117.11880	15.41333	6.673123
2016-07-31	1255539.8	3313116	310011.3	344	6609	1819	117.73629	16.17109	5.497727
2016-06-30	1199672.9	3220246	271513.8	347	6613	1809	115.24236	16.23190	5.003018
2016-05-31	1271637.4	3223137	294315.4	348	6603	1799	117.87518	15.74620	5.277401
2016-04-30	1319672.3	3037333	315178.0	347	6598	1791	126.76967	15.34472	5.865959
2016-03-31	1489117.7	3155477	347407.6	345	6593	1779	139.23494	15.43904	6.299436
2016-02-29	1438777.4	2999034	336816.5	345	6594	1780	143.80583	15.68319	6.524922
2016-01-31	1477972.4	3187426	390730.6	344	6597	1780	138.59456	15.58590	7.081019

==== TO DO ===== add words of explanation

Noosa Monthly Graphs- 4565

==== TO DO ===== add words of explanation

==== TO DO ===== add words of explanation

==== TO DO ===== add words of explanation

==== TO DO ===== add words of explanation blah blah blah

Noosa Forecasts- 4565

Should refactor to move forecast code to Main_1.Rmd and save results for later use

APVI installation ranges

Best to grab code from “test script.R” - use the yearly 100% code and use more meaningful headings

4566

Latest data for postcode 4566

Noosaville

Solar PV Installations	Value
Total Solar PV installations	2,323
Increase in the last 12 months	173
Average monthly increase - last 12 months	14
Increase in installations - last 12 months	8 %

Solar PV Capacity	Value
Total solar PV capacity (kW)	15,577
Increase in last 12 months (kW)	1,579
Average monthly increase last 12 months (kW)	132
Increase in capacity - last 12 months (kW)	11.3 %

Energex Connections	Value
Residential connections - NMI	5,611
Residential solar connections - NMI	1,852
Business connections - NMI	1,243
Business solar connections - NMI	209

Batteries	Value
Residential count	47
Residential capacity - kW	369
Residential storage - kWh	643
Business count	2
Business capacity - kW	110
Business storage - kWh	109

4566 Postcode map

As at December 31, 2022

2021 census dwellings = 5,157

The number of solar installations was 2,323 with total capacity of 15,577 kW.

This represents an increase in capacity of 1,579 kW over the last 12 months, giving an average monthly increase of 132 kW per month.

The corresponding increase in the number of solar installations in the last 12 months was 173, giving an average monthly increase of 14 new installations per month.

The increase in capacity over the last 12 months was 11.3 %

The increase in the number if installations over the last 12 months was 8 %

Solar installs and capacity

	per month				total
Date	PV qty	kW	SWH qty	HPSWH qty	PV qty	kW	SWH qty	HPSWH qty
2022-12-31	100	11	1	0	2,323	15,577	440	171
2022-11-30	97	11	1	1	2,312	15,477	439	171
2022-10-31	158	18	1	0	2,301	15,380	438	170
2022-09-30	175	23	4	0	2,283	15,222	437	170
2022-08-31	148	15	2	0	2,260	15,047	433	170
2022-07-31	84	10	2	1	2,245	14,899	431	170
2022-06-30	216	20	2	1	2,235	14,815	429	169
2022-05-31	161	18	1	1	2,215	14,599	427	168
2022-04-30	154	13	2	0	2,197	14,438	426	167
2022-03-31	123	15	1	1	2,184	14,284	424	167
2022-02-28	87	9	0	0	2,169	14,161	423	166
2022-01-31	75	10	0	0	2,160	14,073	423	166
2021-12-31	219	20	0	0	2,150	13,998	423	166
2021-11-30	151	17	0	0	2,130	13,779	423	166
2021-10-31	122	14	0	0	2,113	13,628	423	166
2021-09-30	142	15	1	0	2,099	13,506	423	166
2021-08-31	343	15	3	3	2,084	13,364	422	166
2021-07-31	120	10	1	2	2,069	13,020	419	163
2021-06-30	126	9	1	4	2,059	12,901	418	161
2021-05-31	163	16	1	0	2,050	12,775	417	157
2021-04-30	153	15	2	1	2,034	12,612	416	157
2021-03-31	229	23	1	0	2,019	12,459	414	156
2021-02-28	273	29	0	1	1,996	12,229	413	156
2021-01-31	114	15	0	0	1,967	11,956	413	155
2020-12-31	425	22	0	0	1,952	11,842	413	155
2020-11-30	350	34	2	2	1,930	11,417	413	155
2020-10-31	168	19	1	1	1,896	11,067	411	153
2020-09-30	296	28	2	0	1,877	10,899	410	152
2020-08-31	276	24	2	0	1,849	10,604	408	152
2020-07-31	245	25	1	0	1,825	10,328	406	152
2020-06-30	284	18	0	1	1,800	10,083	405	152
2020-05-31	129	21	0	2	1,782	9,798	405	151
2020-04-30	79	9	0	0	1,761	9,670	405	149
2020-03-31	367	31	1	0	1,752	9,591	405	149
2020-02-29	161	22	2	0	1,721	9,224	404	149
2020-01-31	186	11	0	0	1,699	9,063	402	149
2019-12-31	226	23	0	1	1,688	8,876	402	149
2019-11-30	171	16	1	0	1,665	8,650	402	148
2019-10-31	276	21	1	0	1,649	8,479	401	148
2019-09-30	122	10	0	0	1,628	8,203	400	148
2019-08-31	75	7	0	0	1,618	8,081	400	148
2019-07-31	299	19	0	0	1,611	8,006	400	148
2019-06-30	137	21	0	1	1,592	7,708	400	148
2019-05-31	89	13	1	0	1,571	7,571	400	147
2019-04-30	144	18	2	0	1,558	7,482	399	147
2019-03-31	107	12	0	0	1,540	7,338	397	147
2019-02-28	57	9	0	0	1,528	7,231	397	147
2019-01-31	148	20	0	0	1,519	7,174	397	147
2018-12-31	210	21	0	1	1,499	7,027	397	147
2018-11-30	188	24	4	1	1,478	6,817	397	146
2018-10-31	155	16	1	0	1,454	6,629	393	145
2018-09-30	139	11	1	0	1,438	6,473	392	145
2018-08-31	100	12	0	1	1,427	6,334	391	145
2018-07-31	128	16	0	0	1,415	6,234	391	144
2018-06-30	210	21	1	1	1,399	6,106	391	144
2018-05-31	77	9	0	0	1,378	5,895	390	143
2018-04-30	178	14	0	1	1,369	5,818	390	143
2018-03-31	115	13	0	2	1,355	5,640	390	142
2018-02-28	76	12	1	1	1,342	5,525	390	140
2018-01-31	73	13	1	0	1,330	5,449	389	139
2017-12-31	204	25	3	0	1,317	5,376	388	139
2017-11-30	63	9	3	0	1,292	5,173	385	139
2017-10-31	120	15	2	0	1,283	5,110	382	139
2017-09-30	98	8	0	0	1,268	4,990	380	139
2017-08-31	232	21	2	1	1,260	4,892	380	139
2017-07-31	74	12	0	0	1,239	4,659	378	138
2017-06-30	153	11	1	1	1,227	4,585	378	138
2017-05-31	86	16	3	0	1,216	4,432	377	137
2017-04-30	28	5	3	0	1,200	4,346	374	137
2017-03-31	90	15	1	0	1,195	4,318	371	137
2017-02-28	43	8	2	0	1,180	4,229	370	137
2017-01-31	49	10	1	0	1,172	4,186	368	137
2016-12-31	181	16	1	1	1,162	4,136	367	137
2016-11-30	83	12	3	0	1,146	3,955	366	136
2016-10-31	98	14	2	1	1,134	3,872	363	136
2016-09-30	75	13	2	0	1,120	3,774	361	135
2016-08-31	54	9	3	2	1,107	3,699	359	135
2016-07-31	68	9	4	1	1,098	3,645	356	133
2016-06-30	50	8	1	1	1,089	3,577	352	132
2016-05-31	52	11	0	1	1,081	3,527	351	131
2016-04-30	37	8	1	1	1,070	3,475	351	130
2016-03-31	78	17	2	3	1,062	3,438	350	129
2016-02-29	34	8	3	0	1,045	3,360	348	126
2016-01-31	8	2	2	0	1,037	3,326	345	126
2015-12-31	34	9	1	0	1,035	3,318	343	126
2015-11-30	76	11	2	0	1,026	3,284	342	126
2015-10-31	47	13	2	0	1,015	3,208	340	126
2015-09-30	58	8	1	0	1,002	3,161	338	126
2015-08-31	22	5	1	0	994	3,102	337	126
2015-07-31	51	10	0	0	989	3,080	336	126
2015-06-30	45	9	3	0	979	3,029	336	126
2015-05-31	60	13	3	0	970	2,984	333	126
2015-04-30	48	8	0	0	957	2,924	330	126
2015-03-31	48	15	2	0	949	2,876	330	126
2015-02-28	48	12	1	0	934	2,828	328	126
2015-01-31	54	10	1	0	922	2,780	327	126
2014-12-31	27	7	2	0	912	2,726	326	126
2014-11-30	31	8	4	1	905	2,699	324	126
2014-10-31	53	13	2	1	897	2,668	320	125
2014-09-30	65	14	0	2	884	2,615	318	124
2014-08-31	32	12	5	0	870	2,550	318	122
2014-07-31	57	12	5	0	858	2,517	313	122
2014-06-30	60	12	0	0	846	2,460	308	122
2014-05-31	14	5	0	0	834	2,401	308	122
2014-04-30	84	13	4	0	829	2,386	308	122
2014-03-31	44	10	1	2	816	2,303	304	122
2014-02-28	30	8	1	0	806	2,258	303	120
2014-01-31	8	2	3	1	798	2,228	302	120
2013-12-31	30	7	0	0	796	2,220	299	119
2013-11-30	48	11	4	1	789	2,190	299	119
2013-10-31	26	8	3	2	778	2,142	295	118
2013-09-30	49	13	0	13	770	2,116	292	116
2013-08-31	31	10	4	0	757	2,067	292	103
2013-07-31	60	17	0	3	747	2,036	288	103
2013-06-30	90	19	0	0	730	1,976	288	100
2013-05-31	56	14	1	0	711	1,886	288	100
2013-04-30	41	13	1	0	697	1,830	287	100
2013-03-31	37	10	4	2	684	1,788	286	100
2013-02-28	20	6	0	2	674	1,751	282	98
2013-01-31	79	20	3	1	668	1,731	282	96
2012-12-31	100	29	2	1	648	1,653	279	95
2012-11-30	70	19	3	0	619	1,553	277	94
2012-10-31	36	11	2	0	600	1,483	274	94
2012-09-30	74	24	0	0	589	1,447	272	94
2012-08-31	84	30	2	0	565	1,373	272	94
2012-07-31	56	18	2	0	535	1,289	270	94
2012-06-30	159	40	3	0	517	1,233	268	94
2012-05-31	106	33	2	0	477	1,074	265	94
2012-04-30	61	20	2	0	444	968	263	94
2012-03-31	54	14	2	0	424	907	261	94
2012-02-29	28	10	4	1	410	853	259	94
2012-01-31	19	6	0	0	400	825	255	93
2011-12-31	51	18	0	1	394	805	255	93
2011-11-30	35	14	5	1	376	754	255	92
2011-10-31	22	10	2	0	362	719	250	91
2011-09-30	9	6	1	0	352	697	248	91
2011-08-31	44	16	5	1	346	688	247	91
2011-07-31	42	12	5	0	330	644	242	90
2011-06-30	86	37	3	4	318	602	237	90
2011-05-31	125	48	3	3	281	516	234	86
2011-04-30	28	13	4	0	233	391	231	83
2011-03-31	62	29	3	2	220	363	227	83
2011-02-28	20	9	2	4	191	302	224	81
2011-01-31	5	3	2	2	182	282	222	77
2010-12-31	21	6	4	0	179	276	220	75
2010-11-30	16	6	0	1	173	255	216	75
2010-10-31	6	3	3	4	167	239	216	74
2010-09-30	21	11	4	1	164	234	213	70
2010-08-31	13	8	3	3	153	213	209	69
2010-07-31	16	8	7	5	145	201	206	66
2010-06-30	15	10	5	4	137	185	199	61
2010-05-31	11	6	4	1	127	170	194	57
2010-04-30	18	10	4	2	121	159	190	56
2010-03-31	9	5	2	1	111	140	186	54
2010-02-28	46	43	4	1	106	131	184	53
2010-01-31	24	22	4	2	63	85	180	52
2009-12-31	10	7	3	1	41	61	176	50
2009-11-30	9	3	3	1	34	51	173	49
2009-10-31	8	7	3	2	31	42	170	48
2009-09-30	4	2	6	8	24	34	167	46
2009-08-31	5	4	2	5	22	30	161	38
2009-07-31	8	6	4	1	18	25	159	33
2009-06-30	3	2	3	2	12	17	155	32
2009-05-31	0	0	4	5	10	14	152	30
2009-04-30	1	1	4	1	10	14	148	25
2009-03-31	4	2	2	2	9	13	144	24
2009-02-28	0	0	2	2	7	8	142	22
2009-01-31	1	1	0	1	7	8	140	20
2008-12-31	0	0	3	2	6	7	140	19
2008-11-30	1	1	4	3	6	7	137	17
2008-10-31	2	1	2	0	5	6	133	14
2008-09-30	1	1	1	3	4	4	131	14
2008-08-31	3	2	6	1	3	3	130	11
2008-07-31	0	0	2	3	1	0	124	10
2008-06-30	0	0	2	1	1	0	122	7
2008-05-31	0	0	3	1	1	0	120	6
2008-04-30	0	1	1	0	1	0	117	5
2008-03-31	0	0	4	1	0	0	116	5
2008-02-29	0	0	1	0	0	0	112	4
2008-01-31	0	0	2	0	0	0	111	4
2007-12-31	0	0	0	0	0	0	109	4
2007-11-30	0	0	0	0	0	0	109	4
2007-10-31	0	0	4	1	0	0	109	4
2007-09-30	0	0	6	1	0	0	105	3
2007-08-31	0	0	2	1	0	0	99	2
2007-07-31	0	0	2	0	0	0	97	1
2007-06-30	0	0	0	0	0	0	95	1
2007-05-31	0	0	3	0	0	0	95	1
2007-04-30	0	0	0	0	0	0	92	1
2007-03-31	0	0	0	0	0	0	92	1
2007-02-28	0	0	0	0	0	0	92	1
2007-01-31	0	0	0	0	0	0	92	1
2006-12-31	0	0	1	0	0	0	92	1
2006-11-30	0	0	2	0	0	0	91	1
2006-10-31	0	0	0	0	0	0	89	1
2006-09-30	0	0	0	0	0	0	89	1
2006-08-31	0	0	1	0	0	0	89	1
2006-07-31	0	0	0	0	0	0	88	1
2006-06-30	0	0	2	1	0	0	88	1
2006-05-31	0	0	1	0	0	0	86	0
2006-04-30	0	0	0	0	0	0	85	0
2006-03-31	0	0	1	0	0	0	85	0
2006-02-28	0	0	2	0	0	0	84	0
2006-01-31	0	0	1	0	0	0	82	0
2005-12-31	0	0	1	0	0	0	81	0
2005-11-30	0	0	3	0	0	0	80	0
2005-10-31	0	0	2	0	0	0	77	0
2005-09-30	0	0	2	0	0	0	75	0
2005-08-31	0	0	0	0	0	0	73	0
2005-07-31	0	0	11	0	0	0	73	0
2005-06-30	0	0	2	0	0	0	62	0
2005-05-31	0	0	0	0	0	0	60	0
2005-04-30	0	0	0	0	0	0	60	0
2005-03-31	0	0	5	0	0	0	60	0
2005-02-28	0	0	0	0	0	0	55	0
2005-01-31	0	0	0	0	0	0	55	0
2004-12-31	0	0	1	0	0	0	55	0
2004-11-30	0	0	0	0	0	0	54	0
2004-10-31	0	0	3	0	0	0	54	0
2004-09-30	0	0	0	0	0	0	51	0
2004-08-31	0	0	2	0	0	0	51	0
2004-07-31	0	0	4	0	0	0	49	0
2004-06-30	0	0	0	0	0	0	45	0
2004-05-31	0	0	0	0	0	0	45	0
2004-04-30	0	0	1	0	0	0	45	0
2004-03-31	0	0	0	0	0	0	44	0
2004-02-29	0	0	1	0	0	0	44	0
2004-01-31	0	0	0	0	0	0	43	0
2003-12-31	0	0	2	0	0	0	43	0
2003-11-30	0	0	6	0	0	0	41	0
2003-10-31	0	0	1	0	0	0	35	0
2003-09-30	0	0	0	0	0	0	34	0
2003-08-31	0	0	1	0	0	0	34	0
2003-07-31	0	0	2	0	0	0	33	0
2003-06-30	0	0	3	0	0	0	31	0
2003-05-31	0	0	0	0	0	0	28	0
2003-04-30	0	0	1	0	0	0	28	0
2003-03-31	0	0	1	0	0	0	27	0
2003-02-28	0	0	1	0	0	0	26	0
2003-01-31	0	0	2	0	0	0	25	0
2002-12-31	0	0	1	0	0	0	23	0
2002-11-30	0	0	2	0	0	0	22	0
2002-10-31	0	0	1	0	0	0	20	0
2002-09-30	0	0	1	0	0	0	19	0
2002-08-31	0	0	3	0	0	0	18	0
2002-07-31	0	0	4	0	0	0	15	0
2002-06-30	0	0	2	0	0	0	11	0
2002-05-31	0	0	1	0	0	0	9	0
2002-04-30	0	0	2	0	0	0	8	0
2002-03-31	0	0	2	0	0	0	6	0
2002-02-28	0	0	0	0	0	0	4	0
2002-01-31	0	0	0	0	0	0	4	0
2001-12-31	0	0	1	0	0	0	4	0
2001-11-30	0	0	0	0	0	0	3	0
2001-10-31	0	0	1	0	0	0	3	0
2001-09-30	0	0	0	0	0	0	2	0
2001-08-31	0	0	1	0	0	0	2	0
2001-07-31	0	0	0	0	0	0	1	0
2001-06-30	0	0	0	0	0	0	1	0
2001-05-31	0	0	1	0	0	0	1	0
2001-04-30	0	0	0	0	0	0	0	0

==== TO DO ===== Add some words of explanation in here….

Graphs for postcode 4566

==== TO DO ===== add words of explanation

==== TO DO ===== add words of explanation

==== TO DO ===== add words of explanation

==== TO DO ===== add words of explanation

Energex Consumption

year_month	bus_kWh	resi_kWh	solar_kWh	bus_NMI	resi_NMI	solar_NMI	bus_daily	resi_daily	solar_daily
2022-09-30	3153971	2424397	774161.0	1243	5611	1867	84.57955	14.40264	13.821835
2022-08-31	3171861	2697351	736990.9	1247	5548	1849	82.05140	15.68336	12.857706
2022-07-31	3230692	3015986	524547.6	1241	5621	1852	83.97734	17.30829	9.136550
2022-06-30	3098418	2775776	558908.4	1237	5631	1842	83.49282	16.43152	10.114159
2022-05-31	3564701	2737926	410224.8	1241	5638	1839	92.65942	15.66516	7.195791
2022-04-30	3477811	2583413	639272.3	1241	5638	1817	93.41421	15.27382	11.727616
2022-03-31	4018853	2801815	701776.9	1241	5634	1815	104.46447	16.04209	12.472708
2022-02-28	3624942	2557863	714752.8	1243	5635	1801	104.15303	16.21158	14.173729
2022-01-31	4066459	2955656	781821.5	1242	5638	1799	105.61682	16.91091	14.018926
2021-12-31	3992509	2793800	842680.4	1242	5633	1794	103.69615	15.99904	15.152307
2021-11-30	3656466	2521644	774387.5	1248	5637	1779	97.66202	14.91126	14.509790
2021-10-31	3570554	2458779	913647.9	1248	5634	1780	92.29101	14.07800	16.557592
2021-09-30	3121890	2341119	852137.3	1252	5631	1770	83.11741	13.85851	16.047783
2021-08-31	3097070	2532374	745653.0	1257	5630	1755	79.47929	14.50968	13.705596
2021-07-31	3192078	2763238	559763.6	1251	5636	1748	82.31036	15.81560	10.330028
2021-06-30	3151550	2690695	488209.6	1246	5636	1736	84.31113	15.91374	9.374225
2021-05-31	3374604	2615849	576039.3	1242	5635	1730	87.64751	14.97466	10.740991
2021-04-30	3398376	2582080	616507.3	1242	5636	1705	91.20710	15.27135	12.052928
2021-03-31	4003010	2811356	591476.3	1230	5631	1689	104.98322	16.10529	11.296554
2021-02-28	3666281	2599080	589231.4	1232	5631	1668	106.28133	16.48451	12.616293
2021-01-31	4023866	2964670	694792.3	1225	5639	1646	105.96091	16.95948	13.616436
2020-12-31	4073605	2952717	697722.4	1223	5637	1632	107.44613	16.89709	13.791160
2020-11-30	3590325	2635614	761768.4	1227	5634	1613	97.53668	15.59351	15.742269
2020-10-31	3409477	2589596	726653.6	1223	5635	1591	89.92896	14.82438	14.733147
2020-09-30	3083087	2458979	654993.0	1220	5623	1568	84.23736	14.57691	13.924171
2020-08-31	3045932	2639645	610511.8	1217	5616	1553	80.73612	15.16201	12.681216
2020-07-31	3100574	2797348	452266.0	1209	5617	1539	82.72831	16.06499	9.479679
2020-06-30	2860418	2576296	390537.3	1204	5611	1524	79.19209	15.30503	8.541935
2020-05-31	2824739	2554577	424102.3	1209	5610	1500	75.36858	14.68907	9.120480
2020-04-30	2983148	2473092	464563.5	1205	5605	1488	82.52139	14.70765	10.406890
2020-03-31	3864529	2891133	488217.3	1207	5610	1472	103.28272	16.62431	10.699011
2020-02-29	4076240	2853779	426172.6	1212	5609	1455	115.97359	17.54434	10.100072
2020-01-31	4382778	3097962	528968.9	1205	5612	1439	117.32774	17.80725	11.857896
2019-12-31	4198641	2915203	616726.0	1201	5605	1421	112.77271	16.77766	14.000272
2019-11-30	3858056	2637649	627004.6	1203	5606	1408	106.90097	15.68349	14.843859
2019-10-31	3574790	2556313	605959.2	1195	5586	1402	96.49858	14.76221	13.942277
2019-09-30	3269519	2428345	554844.1	1195	5577	1387	91.19998	14.51405	13.334392
2019-08-31	3263955	2602431	495516.7	1198	5580	1382	87.88720	15.04469	11.566142
2019-07-31	3295926	2700594	387298.4	1192	5578	1372	89.19479	15.61777	9.106048
2019-06-30	3239152	2479886	304005.1	1197	5574	1350	90.20194	14.83008	7.506298
2019-05-31	3520010	2494562	325639.8	1204	5573	1340	94.30956	14.43922	7.839186
2019-04-30	3668219	2457852	342279.1	1196	5568	1327	102.23577	14.71415	8.597817
2019-03-31	4386497	2866792	384863.6	1194	5552	1313	118.50913	16.65655	9.455412
2019-02-28	3994598	2619025	378141.4	1204	5554	1298	118.49186	16.84130	10.404506
2019-01-31	4479156	2931255	433229.6	1194	5552	1285	121.01249	17.03109	10.875602
2018-12-31	4184325	2748770	430695.1	1186	5545	1266	113.80962	15.99098	10.974241
2018-11-30	3978856	2578438	435449.4	1198	5561	1249	110.70828	15.45548	11.621280
2018-10-31	3771053	2557324	419421.0	1190	5572	1233	102.22426	14.80516	10.973001
2018-09-30	3294822	2463181	393782.0	1181	5566	1221	92.99526	14.75135	10.750259
2018-08-31	3423893	2593947	381281.5	1188	5571	1216	92.96983	15.01988	10.114640
2018-07-31	3455608	2678039	308252.2	1185	5574	1204	94.06855	15.49845	8.258820
2018-06-30	3354392	2508269	251219.9	1179	5566	1190	94.83721	15.02137	7.036972
2018-05-31	3607552	2526999	263191.5	1182	5565	1175	98.45401	14.64799	7.225573
2018-04-30	3909300	2507494	268726.3	1177	5566	1158	110.71368	15.01673	7.735357
2018-03-31	4350028	2820630	289439.9	1184	5564	1149	118.51646	16.35299	8.125998
2018-02-28	4055154	2612635	269281.5	1189	5559	1136	121.80565	16.78511	8.465842
2018-01-31	4601640	2925312	325706.4	1181	5564	1130	125.69008	16.95990	9.297929
2017-12-31	4423195	2804180	338940.3	1183	5577	1116	120.61175	16.21973	9.797096
2017-11-30	3920578	2617205	325338.5	1194	5579	1117	109.45220	15.63724	9.708698
2017-10-31	4044462	2601212	320336.2	1188	5579	1102	109.82031	15.04034	9.376975
2017-09-30	3616724	2418225	314597.5	1180	5579	1086	102.16733	14.44838	9.656154
2017-08-31	3629526	2524378	303986.0	1171	5576	1083	99.98418	14.60394	9.054477
2017-07-31	3583976	2563120	264421.5	1155	5578	1073	100.09709	14.82275	7.949419
2017-06-30	3481142	2426283	220851.7	1154	5578	1064	100.55291	14.49912	6.918913
2017-05-31	3757068	2485870	227399.5	1165	5581	1048	104.03067	14.36827	6.999492
2017-04-30	3763101	2474628	236262.6	1156	5577	1045	108.50926	14.79067	7.536287
2017-03-31	4579214	3002853	253299.8	1157	5570	1040	127.67206	17.39071	7.856694
2017-02-28	4321497	2802121	238793.9	1154	5560	1028	133.74278	17.99923	8.296065
2017-01-31	4827947	3104258	272676.3	1159	5560	1020	134.37466	18.01031	8.623539
2016-12-31	4451663	2803921	289284.6	1157	5555	999	124.11583	16.28246	9.341104
2016-11-30	4186866	2609700	283457.8	1154	5549	988	120.93777	15.67670	9.563353
2016-10-31	3850079	2613031	285716.6	1146	5636	980	108.37354	14.95588	9.404761
2016-09-30	3566895	2515590	241481.4	1147	5627	967	103.65867	14.90190	8.324076
2016-08-31	3581963	2648909	228174.1	1164	5584	955	99.26734	15.30241	7.707281
2016-07-31	3511251	2739007	197906.5	1157	5641	951	97.89643	15.66301	6.713018
2016-06-30	3402469	2615975	168371.6	1168	5658	941	97.10241	15.41166	5.964280
2016-05-31	3758375	2658875	181138.0	1175	5655	935	103.18119	15.16714	6.249372
2016-04-30	3893452	2586036	188151.6	1175	5647	927	110.45253	15.26495	6.765608
2016-03-31	4346707	2899794	212527.4	1168	5621	911	120.04824	16.64148	7.525491
2016-02-29	4188282	2730324	201013.6	1171	5624	906	123.33350	16.74060	7.650665
2016-01-31	4265679	2891329	230223.3	1159	5620	904	118.72525	16.59585	8.215219

==== TO DO ===== add words of explanation

Noosa Monthly Graphs- 4566

==== TO DO ===== add words of explanation

==== TO DO ===== add words of explanation

==== TO DO ===== add words of explanation

==== TO DO ===== add words of explanation blah blah blah

Noosa Forecasts- 4566

Should refactor to move forecast code to Main_1.Rmd and save results for later use

APVI installation ranges

Best to grab code from “test script.R” - use the yearly 100% code and use more meaningful headings

4567

Latest data for postcode 4567

Noosa Heads, Sunshine Beach, Sunrise Beach

Solar PV Installations	Value
Total Solar PV installations	2,432
Increase in the last 12 months	220
Average monthly increase - last 12 months	18
Increase in installations - last 12 months	9.9 %

Solar PV Capacity	Value
Total solar PV capacity (kW)	14,973
Increase in last 12 months (kW)	2,133
Average monthly increase last 12 months (kW)	178
Increase in capacity - last 12 months (kW)	16.6 %

Energex Connections	Value
Residential connections - NMI	7,859
Residential solar connections - NMI	2,090
Business connections - NMI	640
Business solar connections - NMI	67

Batteries	Value
Residential count	70
Residential capacity - kW	694
Residential storage - kWh	1,181
Business count	4
Business capacity - kW	125
Business storage - kWh	323

4567 Postcode map

As at December 31, 2022

2021 census dwellings = 7,318

The number of solar installations was 2,432 with total capacity of 14,973 kW.

This represents an increase in capacity of 2,133 kW over the last 12 months, giving an average monthly increase of 178 kW per month.

The corresponding increase in the number of solar installations in the last 12 months was 220, giving an average monthly increase of 18 new installations per month.

The increase in capacity over the last 12 months was 16.6 %

The increase in the number if installations over the last 12 months was 9.9 %

Solar installs and capacity

	per month				total
Date	PV qty	kW	SWH qty	HPSWH qty	PV qty	kW	SWH qty	HPSWH qty
2022-12-31	191	19	2	1	2,432	14,973	573	183
2022-11-30	322	32	0	1	2,413	14,782	571	182
2022-10-31	178	20	1	1	2,381	14,460	571	181
2022-09-30	167	20	0	3	2,361	14,281	570	180
2022-08-31	198	22	3	0	2,341	14,115	570	177
2022-07-31	125	14	1	2	2,319	13,917	567	177
2022-06-30	234	24	0	1	2,305	13,792	566	175
2022-05-31	165	14	2	2	2,281	13,558	566	174
2022-04-30	141	15	1	0	2,267	13,393	564	172
2022-03-31	217	20	2	0	2,252	13,252	563	172
2022-02-28	134	13	0	2	2,232	13,035	561	172
2022-01-31	61	7	0	1	2,219	12,901	561	170
2021-12-31	191	21	0	0	2,212	12,840	561	169
2021-11-30	343	22	0	0	2,191	12,649	561	169
2021-10-31	313	26	2	0	2,169	12,306	561	169
2021-09-30	179	21	2	2	2,143	11,993	559	169
2021-08-31	171	26	2	1	2,122	11,814	557	167
2021-07-31	119	13	1	0	2,096	11,642	555	166
2021-06-30	179	21	3	1	2,083	11,523	554	166
2021-05-31	268	25	0	1	2,062	11,344	551	165
2021-04-30	176	20	1	2	2,037	11,076	551	164
2021-03-31	242	26	4	1	2,017	10,900	550	162
2021-02-28	208	26	1	1	1,991	10,658	546	161
2021-01-31	96	12	0	0	1,965	10,450	545	160
2020-12-31	353	47	3	0	1,953	10,354	545	160
2020-11-30	271	28	0	2	1,906	10,001	542	160
2020-10-31	188	22	2	0	1,878	9,730	542	158
2020-09-30	151	15	1	1	1,856	9,542	540	158
2020-08-31	172	22	0	0	1,841	9,391	539	157
2020-07-31	179	22	1	0	1,819	9,219	539	157
2020-06-30	124	14	2	0	1,797	9,040	538	157
2020-05-31	310	24	0	2	1,783	8,916	536	157
2020-04-30	182	27	2	1	1,759	8,607	536	155
2020-03-31	286	30	3	0	1,732	8,424	534	154
2020-02-29	183	24	0	0	1,702	8,138	531	154
2020-01-31	193	27	3	1	1,678	7,956	531	154
2019-12-31	138	19	2	1	1,651	7,762	528	153
2019-11-30	223	25	1	0	1,632	7,625	526	152
2019-10-31	144	18	1	1	1,607	7,402	525	152
2019-09-30	191	24	2	1	1,589	7,258	524	151
2019-08-31	113	13	2	0	1,565	7,067	522	150
2019-07-31	93	13	3	1	1,552	6,955	520	150
2019-06-30	142	18	0	0	1,539	6,862	517	149
2019-05-31	186	22	1	0	1,521	6,720	517	149
2019-04-30	112	12	1	1	1,499	6,534	516	149
2019-03-31	133	19	0	2	1,487	6,422	515	148
2019-02-28	105	13	2	4	1,468	6,289	515	146
2019-01-31	116	15	3	0	1,455	6,185	513	142
2018-12-31	196	20	1	0	1,440	6,068	510	142
2018-11-30	198	27	2	1	1,420	5,872	509	142
2018-10-31	115	15	2	1	1,393	5,674	507	141
2018-09-30	154	19	2	0	1,378	5,559	505	140
2018-08-31	111	13	1	1	1,359	5,405	503	140
2018-07-31	88	14	2	1	1,346	5,294	502	139
2018-06-30	58	9	2	1	1,332	5,206	500	138
2018-05-31	130	16	5	2	1,323	5,148	498	137
2018-04-30	104	15	0	0	1,307	5,017	493	135
2018-03-31	66	10	0	1	1,292	4,914	493	135
2018-02-28	81	12	0	0	1,282	4,848	493	134
2018-01-31	33	5	2	2	1,270	4,767	493	134
2017-12-31	97	17	2	0	1,265	4,734	491	132
2017-11-30	111	18	4	0	1,248	4,638	489	132
2017-10-31	97	14	4	0	1,230	4,526	485	132
2017-09-30	36	7	1	1	1,216	4,430	481	132
2017-08-31	116	18	3	1	1,209	4,393	480	131
2017-07-31	51	12	1	0	1,191	4,278	477	130
2017-06-30	82	9	2	2	1,179	4,227	476	130
2017-05-31	91	14	2	0	1,170	4,145	474	128
2017-04-30	61	11	3	0	1,156	4,054	472	128
2017-03-31	81	18	2	0	1,145	3,993	469	128
2017-02-28	42	9	2	0	1,127	3,912	467	128
2017-01-31	17	3	1	0	1,118	3,870	465	128
2016-12-31	89	18	1	0	1,115	3,853	464	128
2016-11-30	71	14	2	1	1,097	3,764	463	128
2016-10-31	64	13	2	2	1,083	3,693	461	127
2016-09-30	38	5	2	0	1,070	3,628	459	125
2016-08-31	41	9	2	1	1,065	3,590	457	125
2016-07-31	38	4	3	0	1,056	3,549	455	124
2016-06-30	26	5	2	0	1,052	3,511	452	124
2016-05-31	38	8	2	1	1,047	3,485	450	124
2016-04-30	40	8	1	0	1,039	3,447	448	123
2016-03-31	34	7	1	2	1,031	3,407	447	123
2016-02-29	61	10	1	0	1,024	3,373	446	121
2016-01-31	42	8	1	0	1,014	3,313	445	121
2015-12-31	39	8	0	0	1,006	3,271	444	121
2015-11-30	30	6	2	0	998	3,231	444	121
2015-10-31	37	9	2	0	992	3,201	442	121
2015-09-30	46	9	4	0	983	3,164	440	121
2015-08-31	62	13	1	0	974	3,118	436	121
2015-07-31	30	6	4	0	961	3,056	435	121
2015-06-30	58	13	2	0	955	3,026	431	121
2015-05-31	19	5	5	0	942	2,968	429	121
2015-04-30	57	12	5	0	937	2,949	424	121
2015-03-31	37	10	4	0	925	2,893	419	121
2015-02-28	39	7	4	0	915	2,856	415	121
2015-01-31	55	11	1	0	908	2,817	411	121
2014-12-31	85	23	0	1	897	2,762	410	121
2014-11-30	66	13	2	0	874	2,677	410	120
2014-10-31	28	7	3	0	861	2,611	408	120
2014-09-30	50	10	3	1	854	2,584	405	120
2014-08-31	35	10	4	0	844	2,534	402	119
2014-07-31	46	11	1	0	834	2,499	398	119
2014-06-30	35	10	5	0	823	2,452	397	119
2014-05-31	59	14	0	0	813	2,418	392	119
2014-04-30	42	10	1	0	799	2,359	392	119
2014-03-31	30	8	1	1	789	2,317	391	119
2014-02-28	9	4	1	1	781	2,287	390	118
2014-01-31	43	9	1	0	777	2,277	389	117
2013-12-31	49	7	3	0	768	2,234	388	117
2013-11-30	34	12	2	1	761	2,186	385	117
2013-10-31	41	9	0	0	749	2,152	383	116
2013-09-30	21	6	2	1	740	2,111	383	116
2013-08-31	21	7	0	1	734	2,091	381	115
2013-07-31	73	15	3	0	727	2,070	381	114
2013-06-30	139	39	1	0	712	1,997	378	114
2013-05-31	101	25	0	0	673	1,857	377	114
2013-04-30	53	12	1	0	648	1,756	377	114
2013-03-31	53	17	0	1	636	1,704	376	114
2013-02-28	58	7	2	0	619	1,651	376	113
2013-01-31	16	4	1	0	612	1,592	374	113
2012-12-31	94	24	1	0	608	1,576	373	113
2012-11-30	57	20	0	0	584	1,483	372	113
2012-10-31	50	19	1	0	564	1,425	372	113
2012-09-30	104	24	0	1	545	1,375	371	113
2012-08-31	59	19	2	1	521	1,271	371	112
2012-07-31	65	20	1	0	502	1,213	369	111
2012-06-30	163	50	1	2	482	1,147	368	111
2012-05-31	64	21	2	1	432	985	367	109
2012-04-30	60	20	0	0	411	921	365	108
2012-03-31	38	13	0	2	391	861	365	108
2012-02-29	43	14	3	2	378	823	365	106
2012-01-31	16	6	0	2	364	780	362	104
2011-12-31	20	7	3	7	358	764	362	102
2011-11-30	33	10	2	1	351	744	359	95
2011-10-31	14	5	5	0	341	711	357	94
2011-09-30	22	10	3	1	336	697	352	94
2011-08-31	15	7	4	0	326	675	349	93
2011-07-31	26	7	5	2	319	660	345	93
2011-06-30	114	44	3	2	312	634	340	91
2011-05-31	66	30	2	3	268	520	337	89
2011-04-30	34	16	5	2	238	454	335	86
2011-03-31	36	18	1	2	222	420	330	84
2011-02-28	31	15	1	0	204	385	329	82
2011-01-31	11	6	5	0	189	354	328	82
2010-12-31	17	8	3	2	183	343	323	82
2010-11-30	34	15	6	0	175	326	320	80
2010-10-31	41	15	5	3	160	292	314	80
2010-09-30	13	7	1	1	145	251	309	77
2010-08-31	9	4	12	2	138	238	308	76
2010-07-31	11	5	5	7	134	228	296	74
2010-06-30	13	10	5	3	129	218	291	67
2010-05-31	26	9	5	6	119	205	286	64
2010-04-30	14	9	3	2	110	178	281	58
2010-03-31	14	5	3	3	101	164	278	56
2010-02-28	16	11	8	2	96	150	275	53
2010-01-31	11	9	6	4	85	134	267	51
2009-12-31	13	9	6	0	76	124	261	47
2009-11-30	17	12	8	2	67	111	255	47
2009-10-31	9	7	5	2	55	93	247	45
2009-09-30	2	2	7	4	48	84	242	43
2009-08-31	16	9	5	5	46	82	235	39
2009-07-31	7	6	6	3	37	66	230	34
2009-06-30	10	8	6	0	31	59	224	31
2009-05-31	2	2	2	3	23	49	218	31
2009-04-30	0	0	3	4	21	46	216	28
2009-03-31	10	6	4	3	21	46	213	24
2009-02-28	0	0	6	1	15	37	209	21
2009-01-31	14	4	3	0	15	37	203	20
2008-12-31	1	1	2	1	11	23	200	20
2008-11-30	2	1	4	0	10	22	198	19
2008-10-31	0	0	4	0	9	20	194	19
2008-09-30	1	1	5	0	9	20	190	19
2008-08-31	1	1	6	1	8	18	185	19
2008-07-31	2	1	3	0	7	18	179	18
2008-06-30	0	0	6	0	6	15	176	18
2008-05-31	1	1	3	3	6	15	170	18
2008-04-30	0	0	2	0	5	14	167	15
2008-03-31	0	0	2	0	5	14	165	15
2008-02-29	0	0	1	0	5	14	163	15
2008-01-31	2	1	0	0	5	14	162	15
2007-12-31	6	1	1	1	4	13	162	15
2007-11-30	2	1	9	2	3	7	161	14
2007-10-31	0	0	8	0	2	5	152	12
2007-09-30	0	0	3	1	2	5	144	12
2007-08-31	1	1	5	0	2	5	141	11
2007-07-31	0	0	5	0	1	4	136	11
2007-06-30	0	0	2	0	1	4	131	11
2007-05-31	0	0	4	1	1	4	129	11
2007-04-30	0	0	1	2	1	4	125	10
2007-03-31	0	0	3	0	1	4	124	8
2007-02-28	0	0	0	0	1	4	121	8
2007-01-31	0	0	2	0	1	4	121	8
2006-12-31	0	0	3	0	1	4	119	8
2006-11-30	0	0	0	1	1	4	116	8
2006-10-31	0	0	1	2	1	4	116	7
2006-09-30	0	0	1	1	1	4	115	5
2006-08-31	0	0	1	0	1	4	114	4
2006-07-31	4	1	2	1	1	4	113	4
2006-06-30	0	0	4	1	0	0	111	3
2006-05-31	0	0	1	0	0	0	107	2
2006-04-30	0	0	2	0	0	0	106	2
2006-03-31	0	0	0	1	0	0	104	2
2006-02-28	0	0	0	0	0	0	104	1
2006-01-31	0	0	1	1	0	0	104	1
2005-12-31	0	0	0	0	0	0	103	0
2005-11-30	0	0	3	0	0	0	103	0
2005-10-31	0	0	1	0	0	0	100	0
2005-09-30	0	0	5	0	0	0	99	0
2005-08-31	0	0	2	0	0	0	94	0
2005-07-31	0	0	4	0	0	0	92	0
2005-06-30	0	0	8	0	0	0	88	0
2005-05-31	0	0	2	0	0	0	80	0
2005-04-30	0	0	0	0	0	0	78	0
2005-03-31	0	0	1	0	0	0	78	0
2005-02-28	0	0	1	0	0	0	77	0
2005-01-31	0	0	1	0	0	0	76	0
2004-12-31	0	0	0	0	0	0	75	0
2004-11-30	0	0	2	0	0	0	75	0
2004-10-31	0	0	2	0	0	0	73	0
2004-09-30	0	0	6	0	0	0	71	0
2004-08-31	0	0	0	0	0	0	65	0
2004-07-31	0	0	1	0	0	0	65	0
2004-06-30	0	0	1	0	0	0	64	0
2004-05-31	0	0	2	0	0	0	63	0
2004-04-30	0	0	1	0	0	0	61	0
2004-03-31	0	0	1	0	0	0	60	0
2004-02-29	0	0	1	0	0	0	59	0
2004-01-31	0	0	0	0	0	0	58	0
2003-12-31	0	0	3	0	0	0	58	0
2003-11-30	0	0	2	0	0	0	55	0
2003-10-31	0	0	2	0	0	0	53	0
2003-09-30	0	0	1	0	0	0	51	0
2003-08-31	0	0	4	0	0	0	50	0
2003-07-31	0	0	2	0	0	0	46	0
2003-06-30	0	0	1	0	0	0	44	0
2003-05-31	0	0	3	0	0	0	43	0
2003-04-30	0	0	2	0	0	0	40	0
2003-03-31	0	0	1	0	0	0	38	0
2003-02-28	0	0	2	0	0	0	37	0
2003-01-31	0	0	2	0	0	0	35	0
2002-12-31	0	0	1	0	0	0	33	0
2002-11-30	0	0	1	0	0	0	32	0
2002-10-31	0	0	4	0	0	0	31	0
2002-09-30	0	0	2	0	0	0	27	0
2002-08-31	0	0	1	0	0	0	25	0
2002-07-31	0	0	1	0	0	0	24	0
2002-06-30	0	0	1	0	0	0	23	0
2002-05-31	0	0	3	0	0	0	22	0
2002-04-30	0	0	2	0	0	0	19	0
2002-03-31	0	0	0	0	0	0	17	0
2002-02-28	0	0	1	0	0	0	17	0
2002-01-31	0	0	1	0	0	0	16	0
2001-12-31	0	0	3	0	0	0	15	0
2001-11-30	0	0	7	0	0	0	12	0
2001-10-31	0	0	0	0	0	0	5	0
2001-09-30	0	0	0	0	0	0	5	0
2001-08-31	0	0	1	0	0	0	5	0
2001-07-31	0	0	1	0	0	0	4	0
2001-06-30	0	0	1	0	0	0	3	0
2001-05-31	0	0	1	0	0	0	2	0
2001-04-30	0	0	1	0	0	0	1	0

==== TO DO ===== Add some words of explanation in here….

Graphs for postcode 4567

==== TO DO ===== add words of explanation

==== TO DO ===== add words of explanation

==== TO DO ===== add words of explanation

==== TO DO ===== add words of explanation

Energex Consumption

year_month	bus_kWh	resi_kWh	solar_kWh	bus_NMI	resi_NMI	solar_NMI	bus_daily	resi_daily	solar_daily
2022-09-30	3699543	3937524	748894.9	640	7859	1913	192.6845	16.70070	13.049223
2022-08-31	3834616	4515254	688400.4	644	7858	1893	192.0765	18.53568	11.730832
2022-07-31	4078885	4970645	483759.5	641	7936	1909	205.2682	20.20456	8.174513
2022-06-30	3755403	4526961	504320.6	638	7950	1900	196.2070	18.98097	8.847730
2022-05-31	3975612	4447962	394908.6	647	7954	1899	198.2157	18.03905	6.708260
2022-04-30	4092142	4276721	613871.6	650	7957	1858	209.8534	17.91597	11.013125
2022-03-31	4448329	4555113	716024.2	645	7967	1849	222.4721	18.44347	12.491917
2022-02-28	4058310	4289389	711517.8	648	7960	1845	223.6723	19.24529	13.773090
2022-01-31	4775213	5135338	792538.6	645	7972	1837	238.8204	20.77974	13.917127
2021-12-31	4516781	4774333	873012.4	645	7978	1834	225.8955	19.30443	15.355339
2021-11-30	3867870	4085629	807523.0	651	7970	1816	198.0476	17.08753	14.822376
2021-10-31	3865438	3832179	917659.9	652	7973	1805	191.2447	15.50466	16.399963
2021-09-30	3453413	3853934	807885.1	651	7983	1789	176.8260	16.09225	15.052825
2021-08-31	3331090	4222691	668142.8	653	7978	1767	164.5552	17.07393	12.197505
2021-07-31	3726325	4620851	507364.9	649	7983	1749	185.2142	18.67214	9.357696
2021-06-30	3599524	4388979	442189.6	652	7992	1746	184.0248	18.30572	8.441954
2021-05-31	3764283	4300678	509205.1	652	7984	1718	186.2400	17.37620	9.561101
2021-04-30	3986445	4227689	555314.5	646	7987	1687	205.6989	17.64404	10.972426
2021-03-31	4504745	4543554	561780.2	649	7995	1683	223.9050	18.33224	10.767643
2021-02-28	4105088	4256741	582802.6	650	7990	1660	225.5543	19.02709	12.538782
2021-01-31	4775044	5030570	669604.4	648	7989	1638	237.7063	20.31249	13.186900
2020-12-31	4714520	4851349	681204.4	652	7992	1623	233.2535	19.58147	13.539331
2020-11-30	3878411	4176995	771476.9	654	7992	1603	197.6764	17.42157	16.042355
2020-10-31	3710457	3899975	730425.5	648	7987	1579	184.7101	15.75130	14.922175
2020-09-30	3509321	3843848	637605.8	648	7991	1573	180.5206	16.03407	13.511459
2020-08-31	3544624	4250092	551593.8	651	7971	1553	175.6416	17.19982	11.457403
2020-07-31	3560964	4450511	408743.5	651	7962	1531	176.4513	18.03126	8.612197
2020-06-30	2842602	4177831	362250.2	650	7960	1520	145.7744	17.49511	7.944084
2020-05-31	2417296	4007012	386856.6	656	7948	1499	118.8678	16.26301	8.325047
2020-04-30	2478869	3910515	428384.3	652	7949	1471	126.7316	16.39835	9.707325
2020-03-31	3932357	4314521	461538.0	651	7961	1452	194.8544	17.48249	10.253665
2020-02-29	4471311	4417684	424820.5	655	7954	1422	235.3941	19.15186	10.301675
2020-01-31	5061337	5120964	514225.1	654	7953	1404	249.6467	20.77108	11.814748
2019-12-31	4778276	4934798	577821.0	652	7960	1399	236.4079	19.99837	13.323364
2019-11-30	4219885	4277702	617411.2	656	7953	1383	214.4250	17.92909	14.880963
2019-10-31	3870413	3973703	600431.0	653	7948	1361	191.1976	16.12783	14.231258
2019-09-30	3618024	3854964	527996.5	649	7949	1348	185.8256	16.16540	13.056293
2019-08-31	3573842	4201156	437322.6	654	8095	1325	176.2771	16.74134	10.646930
2019-07-31	3640574	4392249	347604.6	650	8095	1318	180.6736	17.50284	8.507628
2019-06-30	3666440	4021289	291010.9	655	8099	1310	186.5873	16.55056	7.404857
2019-05-31	3810138	4052003	293827.4	661	8095	1293	185.9420	16.14698	7.330475
2019-04-30	4018801	4084386	312274.4	662	8095	1276	202.3565	16.81856	8.157639
2019-03-31	4630526	4380761	362833.7	663	8089	1267	225.2969	17.47001	9.237817
2019-02-28	4292927	4149783	377036.1	665	8083	1255	230.5546	18.33558	10.729543
2019-01-31	5167710	4806601	441049.4	660	8081	1234	252.5762	19.18718	11.529497
2018-12-31	4747013	4716508	421880.0	661	8115	1220	231.6633	18.74867	11.154944
2018-11-30	4300034	4279431	424523.7	662	8116	1203	216.5173	17.57611	11.762918
2018-10-31	4085801	4032247	407301.6	656	8116	1187	200.9147	16.02667	11.068882
2018-09-30	3774266	3931594	354767.2	655	8119	1183	192.0746	16.14154	9.996259
2018-08-31	3902072	4196282	324176.0	659	8175	1161	191.0065	16.55828	9.007141
2018-07-31	3980258	4292644	272740.3	657	8170	1149	195.4268	16.94888	7.657157
2018-06-30	3782660	4083669	242067.2	658	8184	1142	191.6241	16.63273	7.065594
2018-05-31	3905062	4098411	249574.5	661	8178	1132	190.5745	16.16616	7.112005
2018-04-30	4255567	4163263	257656.0	661	8170	1111	214.6025	16.98598	7.730453
2018-03-31	4588506	4450661	286301.5	665	8178	1104	222.5809	17.55560	8.365519
2018-02-28	4254541	4268985	284454.6	662	8158	1093	229.5285	18.68887	9.294689
2018-01-31	5075245	4914486	341780.2	664	8157	1089	246.5626	19.43506	10.124121
2017-12-31	4782970	4807715	345775.8	665	8158	1089	232.0141	19.01049	10.242478
2017-11-30	4130443	4290259	326635.4	663	8147	1084	207.6643	17.55353	10.044140
2017-10-31	4302956	4037904	317918.3	661	8147	1065	209.9925	15.98809	9.629511
2017-09-30	3942567	3877321	297425.7	661	8197	1056	198.8183	15.76724	9.388436
2017-08-31	3822008	4082240	277405.7	654	8185	1036	188.5177	16.08860	8.637616
2017-07-31	3876829	4116784	242967.8	658	8218	1036	190.0593	16.15959	7.565319
2017-06-30	3626661	3938910	219020.4	663	8222	1026	182.3359	15.96898	7.115672
2017-05-31	3788813	4044349	215338.9	664	8213	1017	184.0659	15.88492	6.830302
2017-04-30	3990699	4191591	224037.0	662	8212	1003	200.9415	17.01409	7.445562
2017-03-31	4616298	4493931	244707.6	664	8214	1001	224.2663	17.64859	7.885906
2017-02-28	4375774	4416931	248738.1	670	8200	984	233.2502	19.23750	9.027950
2017-01-31	5132238	5160921	283419.3	670	8192	979	247.0986	20.32243	9.338669
2016-12-31	4731125	5037626	289370.7	669	8206	971	228.1270	19.80308	9.613325
2016-11-30	4333283	4442537	293312.5	671	8195	960	215.2649	18.07011	10.184461
2016-10-31	4042463	4068887	299774.7	668	8177	942	195.2126	16.05166	10.265554
2016-09-30	3807577	3972515	256804.4	664	8179	938	191.1434	16.18990	9.125956
2016-08-31	3873621	4262685	216305.0	667	8166	932	187.3396	16.83884	7.486675
2016-07-31	3944942	4330530	182117.9	667	8165	923	190.7889	17.10894	6.364866
2016-06-30	3725803	4123504	173676.3	665	8166	925	186.7570	16.83200	6.258605
2016-05-31	3901448	4164799	187595.3	661	8160	919	190.3981	16.46426	6.584834
2016-04-30	4179421	4207589	197883.3	659	8153	906	211.4022	17.20262	7.280474
2016-03-31	4604057	4433156	216609.8	657	8164	905	226.0547	17.51654	7.720898
2016-02-29	4365643	4339788	222736.3	660	8150	897	228.0900	18.36170	8.562500
2016-01-31	4722124	4760935	244885.6	658	8140	891	231.4994	18.86714	8.865922

==== TO DO ===== add words of explanation

Noosa Monthly Graphs- 4567

==== TO DO ===== add words of explanation

==== TO DO ===== add words of explanation

==== TO DO ===== add words of explanation

==== TO DO ===== add words of explanation blah blah blah

Noosa Forecasts- 4567

Should refactor to move forecast code to Main_1.Rmd and save results for later use

APVI installation ranges

Best to grab code from “test script.R” - use the yearly 100% code and use more meaningful headings

4568

Latest data for postcode 4568

Federal, Pinbarren, Pomona

Solar PV Installations	Value
Total Solar PV installations	1,070
Increase in the last 12 months	69
Average monthly increase - last 12 months	6
Increase in installations - last 12 months	6.9 %

Solar PV Capacity	Value
Total solar PV capacity (kW)	5,414
Increase in last 12 months (kW)	631
Average monthly increase last 12 months (kW)	53
Increase in capacity - last 12 months (kW)	13.2 %

Energex Connections	Value
Residential connections - NMI	1,545
Residential solar connections - NMI	853
Business connections - NMI	132
Business solar connections - NMI	33

Batteries	Value
Residential count	18
Residential capacity - kW	142
Residential storage - kWh	215
Business count	0
Business capacity - kW	0
Business storage - kWh	0

4568 Postcode map

As at December 31, 2022

2021 census dwellings = 1,566

The number of solar installations was 1,070 with total capacity of 5,414 kW.

This represents an increase in capacity of 631 kW over the last 12 months, giving an average monthly increase of 53 kW per month.

The corresponding increase in the number of solar installations in the last 12 months was 69, giving an average monthly increase of 6 new installations per month.

The increase in capacity over the last 12 months was 13.2 %

The increase in the number if installations over the last 12 months was 6.9 %

Solar installs and capacity

	per month				total
Date	PV qty	kW	SWH qty	HPSWH qty	PV qty	kW	SWH qty	HPSWH qty
2022-12-31	63	7	0	0	1,070	5,414	332	97
2022-11-30	59	8	1	0	1,063	5,351	332	97
2022-10-31	46	5	0	1	1,055	5,292	331	97
2022-09-30	33	5	1	2	1,050	5,245	331	96
2022-08-31	40	4	3	2	1,045	5,212	330	94
2022-07-31	67	8	0	1	1,041	5,172	327	92
2022-06-30	62	7	0	0	1,033	5,105	327	91
2022-05-31	36	4	0	0	1,026	5,043	327	91
2022-04-30	62	6	0	0	1,022	5,007	327	91
2022-03-31	53	6	0	0	1,016	4,945	327	91
2022-02-28	89	7	0	2	1,010	4,892	327	91
2022-01-31	20	2	0	1	1,003	4,803	327	89
2021-12-31	56	10	0	0	1,001	4,783	327	88
2021-11-30	59	8	0	0	991	4,727	327	88
2021-10-31	35	4	0	1	983	4,667	327	88
2021-09-30	50	6	1	1	979	4,633	327	87
2021-08-31	56	7	2	0	973	4,583	326	86
2021-07-31	32	4	0	0	966	4,527	324	86
2021-06-30	90	11	1	1	962	4,495	324	86
2021-05-31	44	3	1	1	951	4,405	323	85
2021-04-30	52	8	0	0	948	4,361	322	84
2021-03-31	126	15	1	0	940	4,309	322	84
2021-02-28	75	9	1	1	925	4,183	321	84
2021-01-31	33	5	0	1	916	4,108	320	83
2020-12-31	79	9	0	2	911	4,075	320	82
2020-11-30	37	4	2	0	902	3,996	320	80
2020-10-31	53	8	0	0	898	3,959	318	80
2020-09-30	98	12	1	0	890	3,906	318	80
2020-08-31	94	13	1	1	878	3,807	317	80
2020-07-31	65	8	0	0	865	3,713	316	79
2020-06-30	23	3	3	1	857	3,648	316	79
2020-05-31	42	5	0	0	854	3,625	313	78
2020-04-30	28	4	1	2	849	3,583	313	78
2020-03-31	33	6	0	0	845	3,555	312	76
2020-02-29	52	9	1	0	839	3,522	312	76
2020-01-31	26	4	0	0	830	3,470	311	76
2019-12-31	66	8	1	0	826	3,444	311	76
2019-11-30	89	12	1	0	818	3,378	310	76
2019-10-31	43	6	1	0	806	3,289	309	76
2019-09-30	54	8	0	0	800	3,246	308	76
2019-08-31	26	3	0	0	792	3,192	308	76
2019-07-31	121	16	1	0	789	3,166	308	76
2019-06-30	63	10	0	0	773	3,045	307	76
2019-05-31	30	4	1	0	763	2,982	307	76
2019-04-30	14	2	3	1	759	2,952	306	76
2019-03-31	50	7	0	0	757	2,938	303	75
2019-02-28	55	6	0	0	750	2,888	303	75
2019-01-31	56	7	0	0	744	2,832	303	75
2018-12-31	40	6	0	0	737	2,777	303	75
2018-11-30	51	8	1	0	731	2,737	303	75
2018-10-31	25	3	0	0	723	2,686	302	75
2018-09-30	31	3	3	1	720	2,661	302	75
2018-08-31	59	8	1	0	717	2,629	299	74
2018-07-31	30	5	2	3	709	2,570	298	74
2018-06-30	26	5	1	0	704	2,540	296	71
2018-05-31	56	10	0	1	699	2,514	295	71
2018-04-30	23	4	4	0	689	2,458	295	70
2018-03-31	25	4	2	1	685	2,435	291	70
2018-02-28	42	7	1	0	681	2,410	289	69
2018-01-31	19	4	0	1	674	2,368	288	69
2017-12-31	21	5	0	0	670	2,350	288	68
2017-11-30	5	2	0	0	665	2,328	288	68
2017-10-31	21	4	0	0	663	2,324	288	68
2017-09-30	31	6	0	1	659	2,302	288	68
2017-08-31	50	9	1	0	653	2,271	288	67
2017-07-31	21	4	0	0	644	2,221	287	67
2017-06-30	5	1	2	0	640	2,201	287	67
2017-05-31	17	2	0	0	639	2,195	285	67
2017-04-30	20	3	2	0	637	2,179	285	67
2017-03-31	33	7	1	0	634	2,159	283	67
2017-02-28	10	2	0	0	627	2,125	282	67
2017-01-31	14	3	2	0	625	2,115	282	67
2016-12-31	21	5	2	0	622	2,101	280	67
2016-11-30	22	4	0	0	617	2,080	278	67
2016-10-31	49	9	0	1	613	2,058	278	67
2016-09-30	24	5	1	0	604	2,009	278	66
2016-08-31	33	4	1	4	599	1,985	277	66
2016-07-31	16	4	1	0	595	1,953	276	62
2016-06-30	19	5	1	0	591	1,937	275	62
2016-05-31	13	3	2	1	586	1,918	274	62
2016-04-30	12	3	2	0	583	1,905	272	61
2016-03-31	4	1	0	0	580	1,893	270	61
2016-02-29	6	1	0	0	579	1,889	270	61
2016-01-31	27	5	0	0	578	1,883	270	61
2015-12-31	18	4	2	0	573	1,855	270	61
2015-11-30	28	6	2	0	569	1,838	268	61
2015-10-31	12	2	1	0	563	1,810	266	61
2015-09-30	0	0	0	0	561	1,798	265	61
2015-08-31	5	2	0	0	561	1,798	265	61
2015-07-31	11	3	0	0	559	1,793	265	61
2015-06-30	27	6	1	0	556	1,782	265	61
2015-05-31	152	12	1	0	550	1,755	264	61
2015-04-30	106	7	2	0	538	1,604	263	61
2015-03-31	28	6	0	0	531	1,497	261	61
2015-02-28	22	5	0	0	525	1,470	261	61
2015-01-31	26	5	1	0	520	1,448	261	61
2014-12-31	18	5	3	1	515	1,422	260	61
2014-11-30	21	6	1	0	510	1,404	257	60
2014-10-31	10	3	1	0	504	1,383	256	60
2014-09-30	8	2	0	0	501	1,373	255	60
2014-08-31	15	4	2	1	499	1,364	255	60
2014-07-31	10	2	1	1	495	1,349	253	59
2014-06-30	44	10	2	0	493	1,339	252	58
2014-05-31	26	6	2	0	483	1,295	250	58
2014-04-30	25	6	0	0	477	1,269	248	58
2014-03-31	8	2	1	1	471	1,244	248	58
2014-02-28	5	2	0	0	469	1,236	247	57
2014-01-31	12	2	0	0	467	1,232	247	57
2013-12-31	11	2	2	0	465	1,220	247	57
2013-11-30	2	1	0	0	463	1,209	245	57
2013-10-31	6	4	2	0	462	1,207	245	57
2013-09-30	2	2	0	0	458	1,201	243	57
2013-08-31	11	2	0	0	456	1,198	243	57
2013-07-31	20	5	2	0	454	1,187	243	57
2013-06-30	50	12	0	0	449	1,167	241	57
2013-05-31	34	9	0	0	437	1,117	241	57
2013-04-30	19	9	1	1	428	1,083	241	57
2013-03-31	33	9	0	0	419	1,063	240	56
2013-02-28	11	2	0	0	410	1,030	240	56
2013-01-31	15	3	0	0	408	1,019	240	56
2012-12-31	68	19	1	0	405	1,004	240	56
2012-11-30	19	5	0	1	386	936	239	56
2012-10-31	29	9	0	1	381	918	239	55
2012-09-30	37	14	0	0	372	889	239	54
2012-08-31	42	12	2	1	358	852	239	54
2012-07-31	44	13	3	0	346	810	237	53
2012-06-30	88	25	0	0	333	766	234	53
2012-05-31	56	17	0	0	308	678	234	53
2012-04-30	26	10	1	0	291	622	234	53
2012-03-31	27	11	1	2	281	596	233	53
2012-02-29	29	10	1	1	270	569	232	51
2012-01-31	20	6	3	1	260	540	231	50
2011-12-31	16	4	0	1	254	520	228	49
2011-11-30	20	7	1	1	250	504	228	48
2011-10-31	17	5	1	1	243	483	227	47
2011-09-30	14	6	1	0	238	466	226	46
2011-08-31	11	5	2	0	232	453	225	46
2011-07-31	15	9	2	1	227	442	223	46
2011-06-30	56	24	1	0	218	427	221	45
2011-05-31	61	23	5	0	194	371	220	45
2011-04-30	10	4	2	2	171	311	215	45
2011-03-31	24	10	1	1	167	301	213	43
2011-02-28	36	14	1	0	157	277	212	42
2011-01-31	21	11	1	0	143	241	211	42
2010-12-31	14	5	2	1	132	219	210	42
2010-11-30	25	11	0	0	127	206	208	41
2010-10-31	13	8	4	0	116	180	208	41
2010-09-30	20	7	1	1	108	167	204	41
2010-08-31	8	4	4	0	101	146	203	40
2010-07-31	11	8	1	0	97	138	199	40
2010-06-30	11	6	3	1	89	127	198	40
2010-05-31	5	3	1	1	83	116	195	39
2010-04-30	5	3	3	0	80	112	194	38
2010-03-31	14	8	1	0	77	106	191	38
2010-02-28	17	7	4	1	69	92	190	38
2010-01-31	6	4	3	2	62	76	186	37
2009-12-31	4	5	1	2	58	69	183	35
2009-11-30	6	5	2	1	53	65	182	33
2009-10-31	5	4	5	2	48	58	180	32
2009-09-30	3	3	4	1	44	54	175	30
2009-08-31	7	5	8	1	41	51	171	29
2009-07-31	3	3	4	1	36	44	163	28
2009-06-30	1	1	7	0	33	41	159	27
2009-05-31	3	3	1	1	32	40	152	27
2009-04-30	2	2	1	0	29	37	151	26
2009-03-31	2	2	1	0	27	35	150	26
2009-02-28	2	1	2	0	25	33	149	26
2009-01-31	3	2	2	1	24	31	147	26
2008-12-31	1	1	2	1	22	28	145	25
2008-11-30	2	2	1	3	21	27	143	24
2008-10-31	3	3	3	1	19	25	142	21
2008-09-30	6	6	7	1	16	22	139	20
2008-08-31	1	1	2	0	10	16	132	19
2008-07-31	7	3	6	4	9	15	130	19
2008-06-30	1	1	1	1	6	7	124	15
2008-05-31	1	1	5	0	5	6	123	14
2008-04-30	2	1	1	2	4	5	118	14
2008-03-31	3	2	1	2	3	4	117	12
2008-02-29	0	0	3	1	1	1	116	10
2008-01-31	0	0	1	1	1	1	113	9
2007-12-31	0	0	2	0	1	1	112	8
2007-11-30	0	0	4	0	1	1	110	8
2007-10-31	0	0	2	2	1	1	106	8
2007-09-30	0	0	2	0	1	1	104	6
2007-08-31	0	0	2	0	1	1	102	6
2007-07-31	0	0	5	0	1	1	100	6
2007-06-30	0	0	3	1	1	1	95	6
2007-05-31	0	0	1	1	1	1	92	5
2007-04-30	0	0	0	1	1	1	91	4
2007-03-31	0	0	1	0	1	1	91	3
2007-02-28	0	0	1	1	1	1	90	3
2007-01-31	0	0	1	0	1	1	89	2
2006-12-31	0	0	1	0	1	1	88	2
2006-11-30	0	0	2	1	1	1	87	2
2006-10-31	0	0	2	1	1	1	85	1
2006-09-30	0	0	1	0	1	1	83	0
2006-08-31	0	0	3	0	1	1	82	0
2006-07-31	0	0	0	0	1	1	79	0
2006-06-30	0	0	3	0	1	1	79	0
2006-05-31	0	0	0	0	1	1	76	0
2006-04-30	0	0	1	0	1	1	76	0
2006-03-31	0	0	1	0	1	1	75	0
2006-02-28	0	0	0	0	1	1	74	0
2006-01-31	0	0	0	0	1	1	74	0
2005-12-31	0	0	2	0	1	1	74	0
2005-11-30	0	0	1	0	1	1	72	0
2005-10-31	0	0	3	0	1	1	71	0
2005-09-30	0	0	2	0	1	1	68	0
2005-08-31	0	0	0	0	1	1	66	0
2005-07-31	0	0	0	0	1	1	66	0
2005-06-30	0	0	1	0	1	1	66	0
2005-05-31	0	0	1	0	1	1	65	0
2005-04-30	0	0	0	0	1	1	64	0
2005-03-31	0	0	1	0	1	1	64	0
2005-02-28	0	0	2	0	1	1	63	0
2005-01-31	0	0	0	0	1	1	61	0
2004-12-31	0	0	1	0	1	1	61	0
2004-11-30	0	0	2	0	1	1	60	0
2004-10-31	0	0	1	0	1	1	58	0
2004-09-30	0	0	3	0	1	1	57	0
2004-08-31	0	0	3	0	1	1	54	0
2004-07-31	1	1	1	0	1	1	51	0
2004-06-30	0	0	1	0	0	0	50	0
2004-05-31	0	0	0	0	0	0	49	0
2004-04-30	0	0	1	0	0	0	49	0
2004-03-31	0	0	3	0	0	0	48	0
2004-02-29	0	0	4	0	0	0	45	0
2004-01-31	0	0	3	0	0	0	41	0
2003-12-31	0	0	1	0	0	0	38	0
2003-11-30	0	0	2	0	0	0	37	0
2003-10-31	0	0	4	0	0	0	35	0
2003-09-30	0	0	1	0	0	0	31	0
2003-08-31	0	0	4	0	0	0	30	0
2003-07-31	0	0	1	0	0	0	26	0
2003-06-30	0	0	2	0	0	0	25	0
2003-05-31	0	0	1	0	0	0	23	0
2003-04-30	0	0	0	0	0	0	22	0
2003-03-31	0	0	0	0	0	0	22	0
2003-02-28	0	0	1	0	0	0	22	0
2003-01-31	0	0	1	0	0	0	21	0
2002-12-31	0	0	2	0	0	0	20	0
2002-11-30	0	0	0	0	0	0	18	0
2002-10-31	0	0	0	0	0	0	18	0
2002-09-30	0	0	2	0	0	0	18	0
2002-08-31	0	0	3	0	0	0	16	0
2002-07-31	0	0	0	0	0	0	13	0
2002-06-30	0	0	2	0	0	0	13	0
2002-05-31	0	0	1	0	0	0	11	0
2002-04-30	0	0	1	0	0	0	10	0
2002-03-31	0	0	0	0	0	0	9	0
2002-02-28	0	0	0	0	0	0	9	0
2002-01-31	0	0	0	0	0	0	9	0
2001-12-31	0	0	1	0	0	0	9	0
2001-11-30	0	0	0	0	0	0	8	0
2001-10-31	0	0	3	0	0	0	8	0
2001-09-30	0	0	2	0	0	0	5	0
2001-08-31	0	0	1	0	0	0	3	0
2001-07-31	0	0	0	0	0	0	2	0
2001-06-30	0	0	1	0	0	0	2	0
2001-05-31	0	0	1	0	0	0	1	0
2001-04-30	0	0	0	0	0	0	0	0

==== TO DO ===== Add some words of explanation in here….

Graphs for postcode 4568

==== TO DO ===== add words of explanation

==== TO DO ===== add words of explanation

==== TO DO ===== add words of explanation

==== TO DO ===== add words of explanation

Energex Consumption

year_month	bus_kWh	resi_kWh	solar_kWh	bus_NMI	resi_NMI	solar_NMI	bus_daily	resi_daily	solar_daily
2022-09-30	235585.9	803109.2	241056.54	132	1545	804	59.49139	17.32706	9.994052
2022-08-31	258336.3	889717.3	232357.29	133	1547	801	62.65735	18.55240	9.357549
2022-07-31	257965.5	1009070.3	171385.43	136	1557	798	61.18727	20.90601	6.928023
2022-06-30	238967.6	955100.8	174872.94	130	1551	791	61.27374	20.52656	7.369277
2022-05-31	266458.6	934320.6	138422.72	131	1553	795	65.61404	19.40719	5.616665
2022-04-30	241842.9	781943.3	212436.96	131	1559	800	61.53764	16.71891	8.851540
2022-03-31	276585.9	781731.2	241853.82	131	1558	796	68.10782	16.18558	9.801176
2022-02-28	239307.7	710420.4	231568.00	131	1556	798	65.24200	16.30601	10.363767
2022-01-31	256390.6	791085.3	253265.39	133	1558	793	62.18545	16.37926	10.302461
2021-12-31	255978.6	775629.6	276738.76	134	1558	791	61.62220	16.05925	11.285786
2021-11-30	263439.8	731741.3	246154.79	133	1559	790	66.02501	15.64553	10.386278
2021-10-31	254158.0	758151.3	291129.58	135	1558	790	60.73069	15.69736	11.887692
2021-09-30	225109.9	757822.0	277208.11	134	1555	783	55.99749	16.24485	11.801112
2021-08-31	235807.7	816143.2	254533.04	135	1554	774	56.34593	16.94157	10.608195
2021-07-31	249855.7	904702.3	190879.98	136	1554	774	59.26367	18.77989	7.955321
2021-06-30	253339.4	880154.1	162566.27	135	1552	766	62.55294	18.90365	7.074250
2021-05-31	254130.5	859670.2	186183.46	136	1550	762	60.27764	17.89116	7.881782
2021-04-30	234252.3	748564.5	203004.53	135	1550	762	57.84008	16.09816	8.880338
2021-03-31	296427.9	758526.8	206573.78	135	1548	756	70.83104	15.80659	8.814379
2021-02-28	264482.3	686877.9	201446.63	134	1546	754	70.49103	15.86763	9.541807
2021-01-31	279292.0	767102.8	244726.19	137	1545	744	65.76219	16.01634	10.610743
2020-12-31	283122.8	772813.9	239596.92	136	1543	740	67.15436	16.15650	10.444504
2020-11-30	279281.2	729650.1	254432.60	137	1544	736	67.95164	15.75238	11.523216
2020-10-31	268468.2	747444.3	247208.81	136	1546	731	63.67842	15.59580	10.908998
2020-09-30	245282.5	744852.7	217284.48	134	1545	726	61.01555	16.07018	9.976331
2020-08-31	248382.0	798574.2	212278.36	134	1545	716	59.79345	16.67343	9.563811
2020-07-31	240082.7	859674.0	165148.52	133	1543	709	58.23009	17.97240	7.513923
2020-06-30	230298.5	839465.8	140975.51	132	1541	704	58.15620	18.15846	6.674977
2020-05-31	224342.6	849944.1	149863.01	132	1540	700	54.82468	17.80360	6.906130
2020-04-30	235814.7	753879.7	169562.09	135	1538	698	58.22585	16.33896	8.097521
2020-03-31	278984.1	767759.4	178283.94	137	1538	690	65.68969	16.10301	8.334920
2020-02-29	268971.1	727214.1	156308.37	136	1538	679	68.19755	16.30452	7.938062
2020-01-31	282610.3	776175.0	205814.15	137	1537	675	66.54350	16.29011	9.835802
2019-12-31	271921.7	764864.8	223234.86	136	1534	671	64.49755	16.08413	10.731929
2019-11-30	271431.7	724036.1	226492.52	136	1536	670	66.52738	15.71259	11.268285
2019-10-31	261395.6	727566.4	222624.96	136	1536	665	62.00084	15.27987	10.799174
2019-09-30	240824.8	713986.3	211305.48	135	1532	658	59.46291	15.53495	10.704432
2019-08-31	248065.8	763476.9	196962.55	136	1530	655	58.83914	16.09692	9.700200
2019-07-31	248125.3	824148.3	148304.82	135	1531	651	59.28921	17.36475	7.348735
2019-06-30	243788.4	814658.1	116005.96	132	1530	636	61.56273	17.74854	6.079977
2019-05-31	253708.1	818868.8	122453.98	132	1528	632	62.00100	17.28738	6.250203
2019-04-30	256336.7	733902.0	135796.04	135	1528	633	63.29301	16.01008	7.150923
2019-03-31	292634.1	743645.5	146930.83	136	1529	625	69.41036	15.68905	7.583527
2019-02-28	262918.7	671738.8	137391.99	136	1528	620	69.04376	15.70070	7.914285
2019-01-31	276384.6	738728.0	169556.22	137	1526	617	65.07760	15.61595	8.864757
2018-12-31	263722.3	733995.7	172544.75	136	1525	611	62.55272	15.52608	9.109590
2018-11-30	267099.7	702573.9	173452.38	137	1523	609	64.98775	15.37697	9.493836
2018-10-31	261847.6	736713.4	167138.58	137	1522	606	61.65472	15.61429	8.896975
2018-09-30	239276.0	730309.9	157248.76	135	1518	597	59.08049	16.03667	8.779942
2018-08-31	247815.1	771365.5	155481.54	135	1518	594	59.21508	16.39180	8.443659
2018-07-31	250265.1	819329.8	126379.83	137	1518	593	58.92749	17.41106	6.874821
2018-06-30	245814.5	804779.4	105169.27	135	1514	587	60.69495	17.71861	5.972134
2018-05-31	257951.2	814373.4	107624.62	133	1516	582	62.56396	17.32857	5.965227
2018-04-30	255859.9	732797.8	112159.07	136	1516	581	62.71075	16.11253	6.434829
2018-03-31	279824.7	746282.3	120054.52	134	1515	575	67.36272	15.89018	6.735177
2018-02-28	260994.1	679347.0	110182.05	134	1513	570	69.56134	16.03595	6.903637
2018-01-31	274349.4	743536.3	144584.15	137	1513	573	64.59840	15.85264	8.139624
2017-12-31	260957.4	731644.3	151375.02	137	1509	572	61.44511	15.64044	8.536827
2017-11-30	269722.4	700264.2	145379.02	136	1509	573	66.10844	15.46862	8.457186
2017-10-31	281571.2	710022.5	144911.74	136	1507	570	66.78635	15.19838	8.201004
2017-09-30	254119.5	684886.8	138136.01	135	1508	565	62.74554	15.13897	8.149617
2017-08-31	270405.1	716063.7	138159.00	135	1507	560	64.61292	15.32769	7.958468
2017-07-31	258575.7	756459.0	113062.80	135	1507	557	61.78630	16.19237	6.547912
2017-06-30	253062.9	747311.0	96153.98	133	1505	554	63.42428	16.55174	5.785438
2017-05-31	261852.7	765587.6	98517.59	134	1509	554	63.03628	16.36605	5.736438
2017-04-30	252750.4	726110.1	107712.10	136	1505	551	61.94863	16.08217	6.516158
2017-03-31	301392.0	757569.1	116952.21	134	1502	548	72.55464	16.27012	6.884401
2017-02-28	276300.0	690542.7	106086.53	134	1503	540	73.64072	16.40868	7.016305
2017-01-31	284998.2	772352.9	130386.74	136	1503	542	67.59919	16.57659	7.760192
2016-12-31	277326.2	758440.3	136973.17	136	1500	537	65.77946	16.31054	8.228099
2016-11-30	284880.5	727338.1	132564.86	136	1495	534	69.82366	16.21713	8.274960
2016-10-31	272687.1	733593.7	131199.61	134	1497	529	65.64446	15.80782	8.000464
2016-09-30	264139.7	712132.1	118391.94	133	1495	519	66.20042	15.87808	7.603850
2016-08-31	282202.8	743283.5	117827.25	134	1495	516	67.93520	16.03805	7.366045
2016-07-31	271494.1	781857.4	94628.37	136	1498	517	64.39615	16.83659	5.904310
2016-06-30	267061.0	770683.8	79983.73	136	1492	509	65.45613	17.21814	5.237965
2016-05-31	274651.8	785234.3	83240.61	136	1492	505	65.14511	16.97731	5.317190
2016-04-30	271819.8	721848.8	94581.94	136	1491	507	66.62250	16.13791	6.218405
2016-03-31	302919.4	728097.7	106252.15	133	1489	505	73.47064	15.77369	6.787106
2016-02-29	292822.6	684047.9	100193.66	135	1487	503	74.79504	15.86272	6.868696
2016-01-31	287145.1	717780.2	116813.42	138	1487	502	67.12133	15.57108	7.506324

==== TO DO ===== add words of explanation

Noosa Monthly Graphs- 4568

==== TO DO ===== add words of explanation

==== TO DO ===== add words of explanation

==== TO DO ===== add words of explanation

==== TO DO ===== add words of explanation blah blah blah

Noosa Forecasts- 4568

Should refactor to move forecast code to Main_1.Rmd and save results for later use

APVI installation ranges

Best to grab code from “test script.R” - use the yearly 100% code and use more meaningful headings

4569

Latest data for postcode 4569

Cooran

Solar PV Installations	Value
Total Solar PV installations	469
Increase in the last 12 months	30
Average monthly increase - last 12 months	2
Increase in installations - last 12 months	6.8 %

Solar PV Capacity	Value
Total solar PV capacity (kW)	2,167
Increase in last 12 months (kW)	218
Average monthly increase last 12 months (kW)	18
Increase in capacity - last 12 months (kW)	11.2 %

Energex Connections	Value
Residential connections - NMI	714
Residential solar connections - NMI	368
Business connections - NMI	29
Business solar connections - NMI	NA

Batteries	Value
Residential count	5
Residential capacity - kW	31
Residential storage - kWh	48
Business count	NA
Business capacity - kW	NA
Business storage - kWh	NA

4569 Postcode map

As at December 31, 2022

2021 census dwellings = 754

The number of solar installations was 469 with total capacity of 2,167 kW.

This represents an increase in capacity of 218 kW over the last 12 months, giving an average monthly increase of 18 kW per month.

The corresponding increase in the number of solar installations in the last 12 months was 30, giving an average monthly increase of 2 new installations per month.

The increase in capacity over the last 12 months was 11.2 %

The increase in the number if installations over the last 12 months was 6.8 %

Solar installs and capacity

	per month				total
Date	PV qty	kW	SWH qty	HPSWH qty	PV qty	kW	SWH qty	HPSWH qty
2022-12-31	22	2	0	0	469	2,167	154	25
2022-11-30	29	5	0	0	467	2,145	154	25
2022-10-31	20	3	0	0	462	2,116	154	25
2022-09-30	43	6	1	0	459	2,097	154	25
2022-08-31	5	1	0	0	453	2,054	153	25
2022-07-31	13	2	0	0	452	2,048	153	25
2022-06-30	23	3	1	0	450	2,035	153	25
2022-05-31	6	1	0	0	447	2,012	152	25
2022-04-30	34	4	0	0	446	2,006	152	25
2022-03-31	7	1	0	0	442	1,972	152	25
2022-02-28	0	0	0	0	441	1,965	152	25
2022-01-31	17	2	0	0	441	1,965	152	25
2021-12-31	60	4	0	0	439	1,949	152	25
2021-11-30	36	4	0	0	435	1,889	152	25
2021-10-31	28	3	2	0	431	1,854	152	25
2021-09-30	35	5	0	0	428	1,826	150	25
2021-08-31	10	3	1	0	423	1,791	150	25
2021-07-31	24	4	0	0	420	1,781	149	25
2021-06-30	13	2	1	0	416	1,758	149	25
2021-05-31	26	4	0	1	414	1,744	148	25
2021-04-30	39	6	0	0	410	1,719	148	24
2021-03-31	32	4	3	0	404	1,679	148	24
2021-02-28	6	1	0	1	400	1,647	145	24
2021-01-31	0	0	1	0	399	1,641	145	23
2020-12-31	17	3	1	0	399	1,641	144	23
2020-11-30	9	1	0	0	396	1,624	143	23
2020-10-31	43	6	1	0	395	1,615	143	23
2020-09-30	21	3	1	0	389	1,572	142	23
2020-08-31	7	1	0	0	386	1,551	141	23
2020-07-31	41	6	0	0	385	1,544	141	23
2020-06-30	13	2	2	1	379	1,503	141	23
2020-05-31	59	7	0	0	377	1,490	139	22
2020-04-30	0	0	1	0	370	1,431	139	22
2020-03-31	38	6	0	0	370	1,431	138	22
2020-02-29	7	1	0	0	364	1,393	138	22
2020-01-31	25	4	0	0	363	1,386	138	22
2019-12-31	23	3	0	0	359	1,361	138	22
2019-11-30	22	4	1	0	356	1,337	138	22
2019-10-31	61	8	0	1	352	1,315	137	22
2019-09-30	21	3	0	0	344	1,254	137	21
2019-08-31	22	3	0	0	341	1,233	137	21
2019-07-31	12	2	0	0	338	1,211	137	21
2019-06-30	7	2	0	0	336	1,198	137	21
2019-05-31	26	2	0	0	334	1,192	137	21
2019-04-30	20	3	2	1	332	1,166	137	21
2019-03-31	16	3	0	0	329	1,146	135	20
2019-02-28	7	1	0	0	326	1,130	135	20
2019-01-31	21	3	0	1	325	1,124	135	20
2018-12-31	6	1	0	0	322	1,103	135	19
2018-11-30	7	1	0	0	321	1,097	135	19
2018-10-31	13	2	0	0	320	1,090	135	19
2018-09-30	0	0	0	0	318	1,077	135	19
2018-08-31	14	3	0	0	318	1,077	135	19
2018-07-31	26	4	0	0	315	1,062	135	19
2018-06-30	5	1	0	0	311	1,037	135	19
2018-05-31	14	2	1	0	310	1,032	135	19
2018-04-30	15	3	1	0	308	1,018	134	19
2018-03-31	3	1	1	0	305	1,003	133	19
2018-02-28	13	3	0	0	304	999	132	19
2018-01-31	0	0	0	1	301	986	132	19
2017-12-31	0	0	0	0	301	986	132	18
2017-11-30	18	3	2	1	301	986	132	18
2017-10-31	13	2	0	0	298	968	130	17
2017-09-30	4	1	0	0	296	955	130	17
2017-08-31	6	1	0	0	295	951	130	17
2017-07-31	2	1	0	0	294	944	130	17
2017-06-30	5	1	1	0	293	942	130	17
2017-05-31	17	2	0	0	292	937	129	17
2017-04-30	18	4	0	0	290	921	129	17
2017-03-31	0	0	0	0	286	903	129	17
2017-02-28	19	4	0	0	286	903	129	17
2017-01-31	16	4	1	0	282	884	129	17
2016-12-31	22	5	0	0	278	868	128	17
2016-11-30	17	3	1	0	273	846	128	17
2016-10-31	17	2	0	0	270	830	127	17
2016-09-30	6	2	0	0	268	813	127	17
2016-08-31	5	1	0	0	266	807	127	17
2016-07-31	5	2	0	0	265	802	127	17
2016-06-30	18	6	0	1	263	796	127	17
2016-05-31	0	0	0	0	257	779	127	16
2016-04-30	6	1	1	0	257	779	127	16
2016-03-31	14	4	0	1	256	773	126	16
2016-02-29	6	2	1	0	252	759	126	15
2016-01-31	10	2	0	0	250	754	125	15
2015-12-31	19	3	0	0	248	744	125	15
2015-11-30	2	1	1	0	245	725	125	15
2015-10-31	0	0	0	0	244	723	124	15
2015-09-30	10	3	1	0	244	723	124	15
2015-08-31	30	1	0	0	241	712	123	15
2015-07-31	1	1	1	0	240	682	123	15
2015-06-30	13	3	3	0	239	682	122	15
2015-05-31	10	3	0	0	236	669	119	15
2015-04-30	14	3	1	0	233	659	119	15
2015-03-31	1	1	0	0	230	646	118	15
2015-02-28	6	2	1	0	229	645	118	15
2015-01-31	5	2	0	0	227	639	117	15
2014-12-31	5	1	0	0	225	634	117	15
2014-11-30	9	3	0	1	224	629	117	15
2014-10-31	3	1	0	0	221	620	117	14
2014-09-30	3	1	2	0	220	617	117	14
2014-08-31	9	2	0	0	219	614	115	14
2014-07-31	15	4	1	0	217	605	115	14
2014-06-30	10	2	2	0	213	589	114	14
2014-05-31	10	2	0	0	211	579	112	14
2014-04-30	8	2	0	0	209	569	112	14
2014-03-31	4	2	1	1	207	561	112	14
2014-02-28	0	0	0	0	205	557	111	13
2014-01-31	7	2	0	0	205	557	111	13
2013-12-31	0	0	0	0	203	550	111	13
2013-11-30	4	3	0	0	203	550	111	13
2013-10-31	5	1	0	0	200	546	111	13
2013-09-30	10	1	0	0	199	541	111	13
2013-08-31	10	3	0	0	198	531	111	13
2013-07-31	8	3	0	0	195	521	111	13
2013-06-30	11	3	1	0	192	513	111	13
2013-05-31	15	4	0	0	189	503	110	13
2013-04-30	0	0	0	0	185	487	110	13
2013-03-31	27	7	1	0	185	487	110	13
2013-02-28	0	0	0	0	178	461	109	13
2013-01-31	7	2	0	0	178	461	109	13
2012-12-31	17	5	1	0	176	454	109	13
2012-11-30	14	3	0	0	171	437	108	13
2012-10-31	24	9	1	1	168	423	108	13
2012-09-30	5	2	0	0	159	398	107	12
2012-08-31	26	8	0	0	157	393	107	12
2012-07-31	16	6	1	0	149	367	107	12
2012-06-30	24	9	0	0	143	351	106	12
2012-05-31	24	7	0	0	134	327	106	12
2012-04-30	21	6	0	0	127	303	106	12
2012-03-31	19	5	0	0	121	282	106	12
2012-02-29	5	2	3	0	116	263	106	12
2012-01-31	9	4	0	1	114	258	103	12
2011-12-31	13	4	0	0	110	249	103	11
2011-11-30	5	2	0	1	106	236	103	11
2011-10-31	2	1	1	0	104	231	103	10
2011-09-30	6	2	1	0	103	230	102	10
2011-08-31	12	3	1	0	101	223	101	10
2011-07-31	23	7	1	0	98	211	100	10
2011-06-30	14	6	4	0	91	189	99	10
2011-05-31	23	10	1	0	85	175	95	10
2011-04-30	11	4	2	0	75	152	94	10
2011-03-31	11	4	2	0	71	142	92	10
2011-02-28	2	1	1	1	67	131	90	10
2011-01-31	3	2	0	2	66	129	89	9
2010-12-31	19	7	0	0	64	126	89	7
2010-11-30	18	8	0	0	57	107	89	7
2010-10-31	15	4	0	0	49	89	89	7
2010-09-30	2	1	1	0	45	74	89	7
2010-08-31	4	3	1	0	44	72	88	7
2010-07-31	8	2	1	1	41	68	87	7
2010-06-30	4	3	2	0	39	60	86	6
2010-05-31	3	2	2	1	36	56	84	6
2010-04-30	6	3	2	0	34	52	82	5
2010-03-31	3	2	1	0	31	47	80	5
2010-02-28	1	1	1	0	29	44	79	5
2010-01-31	3	2	3	0	28	43	78	5
2009-12-31	6	2	3	0	26	39	75	5
2009-11-30	1	1	1	0	24	33	72	5
2009-10-31	5	3	3	0	23	32	71	5
2009-09-30	1	1	1	0	20	27	68	5
2009-08-31	2	2	3	0	19	26	67	5
2009-07-31	4	4	0	0	17	24	64	5
2009-06-30	0	0	0	0	13	20	64	5
2009-05-31	4	3	3	0	13	20	64	5
2009-04-30	0	0	1	1	10	16	61	5
2009-03-31	3	3	1	1	10	16	60	4
2009-02-28	0	0	1	0	7	12	59	3
2009-01-31	0	0	2	0	7	12	58	3
2008-12-31	0	0	0	0	7	12	56	3
2008-11-30	0	0	0	0	7	12	56	3
2008-10-31	0	0	1	0	7	12	56	3
2008-09-30	0	0	0	0	7	12	55	3
2008-08-31	0	0	0	0	7	12	55	3
2008-07-31	1	1	4	0	7	12	55	3
2008-06-30	4	1	0	1	6	11	51	3
2008-05-31	0	0	1	0	5	8	51	2
2008-04-30	0	0	0	0	5	8	50	2
2008-03-31	0	0	1	0	5	8	50	2
2008-02-29	2	1	1	0	5	8	49	2
2008-01-31	0	0	0	0	4	6	48	2
2007-12-31	0	0	1	0	4	6	48	2
2007-11-30	0	0	3	0	4	6	47	2
2007-10-31	0	0	0	0	4	6	44	2
2007-09-30	0	0	1	0	4	6	44	2
2007-08-31	0	0	0	1	4	6	43	2
2007-07-31	0	0	3	0	4	6	43	1
2007-06-30	0	0	0	1	4	6	40	1
2007-05-31	0	0	0	0	4	6	40	0
2007-04-30	0	0	0	0	4	6	40	0
2007-03-31	0	0	0	0	4	6	40	0
2007-02-28	0	0	0	0	4	6	40	0
2007-01-31	0	0	1	0	4	6	40	0
2006-12-31	0	0	0	0	4	6	39	0
2006-11-30	0	0	0	0	4	6	39	0
2006-10-31	0	0	0	0	4	6	39	0
2006-09-30	0	0	1	0	4	6	39	0
2006-08-31	0	0	0	0	4	6	38	0
2006-07-31	0	0	1	0	4	6	38	0
2006-06-30	0	0	0	0	4	6	37	0
2006-05-31	0	0	2	0	4	6	37	0
2006-04-30	0	0	0	0	4	6	35	0
2006-03-31	0	0	0	0	4	6	35	0
2006-02-28	0	0	0	0	4	6	35	0
2006-01-31	0	0	0	0	4	6	35	0
2005-12-31	0	0	1	0	4	6	35	0
2005-11-30	0	0	0	0	4	6	34	0
2005-10-31	0	0	1	0	4	6	34	0
2005-09-30	0	0	0	0	4	6	33	0
2005-08-31	0	0	1	0	4	6	33	0
2005-07-31	0	0	1	0	4	6	32	0
2005-06-30	2	1	2	0	4	6	31	0
2005-05-31	0	0	1	0	3	4	29	0
2005-04-30	0	0	0	0	3	4	28	0
2005-03-31	0	0	0	0	3	4	28	0
2005-02-28	0	0	0	0	3	4	28	0
2005-01-31	0	0	1	0	3	4	28	0
2004-12-31	0	0	0	0	3	4	27	0
2004-11-30	0	0	1	0	3	4	27	0
2004-10-31	0	0	2	0	3	4	26	0
2004-09-30	0	0	0	0	3	4	24	0
2004-08-31	1	1	1	0	3	4	24	0
2004-07-31	0	0	1	0	2	3	23	0
2004-06-30	0	0	0	0	2	3	22	0
2004-05-31	0	0	3	0	2	3	22	0
2004-04-30	0	0	0	0	2	3	19	0
2004-03-31	0	0	1	0	2	3	19	0
2004-02-29	1	1	0	0	2	3	18	0
2004-01-31	0	0	0	0	1	2	18	0
2003-12-31	0	0	1	0	1	2	18	0
2003-11-30	0	0	2	0	1	2	17	0
2003-10-31	0	0	2	0	1	2	15	0
2003-09-30	0	0	1	0	1	2	13	0
2003-08-31	0	0	2	0	1	2	12	0
2003-07-31	2	1	1	0	1	2	10	0
2003-06-30	0	0	1	0	0	0	9	0
2003-05-31	0	0	0	0	0	0	8	0
2003-04-30	0	0	1	0	0	0	8	0
2003-03-31	0	0	0	0	0	0	7	0
2003-02-28	0	0	1	0	0	0	7	0
2003-01-31	0	0	1	0	0	0	6	0
2002-12-31	0	0	0	0	0	0	5	0
2002-11-30	0	0	0	0	0	0	5	0
2002-10-31	0	0	0	0	0	0	5	0
2002-09-30	0	0	0	0	0	0	5	0
2002-08-31	0	0	0	0	0	0	5	0
2002-07-31	0	0	0	0	0	0	5	0
2002-06-30	0	0	1	0	0	0	5	0
2002-05-31	0	0	0	0	0	0	4	0
2002-04-30	0	0	0	0	0	0	4	0
2002-03-31	0	0	3	0	0	0	4	0
2002-02-28	0	0	1	0	0	0	1	0
2002-01-31	0	0	0	0	0	0	0	0
2001-12-31	0	0	0	0	0	0	0	0
2001-11-30	0	0	0	0	0	0	0	0
2001-10-31	0	0	0	0	0	0	0	0
2001-09-30	0	0	0	0	0	0	0	0
2001-08-31	0	0	0	0	0	0	0	0
2001-07-31	0	0	0	0	0	0	0	0
2001-06-30	0	0	0	0	0	0	0	0
2001-05-31	0	0	0	0	0	0	0	0
2001-04-30	0	0	0	0	0	0	0	0

==== TO DO ===== Add some words of explanation in here….

Graphs for postcode 4569

==== TO DO ===== add words of explanation

==== TO DO ===== add words of explanation

==== TO DO ===== add words of explanation

==== TO DO ===== add words of explanation

Energex Consumption

year_month	bus_kWh	resi_kWh	solar_kWh	bus_NMI	resi_NMI	solar_NMI	bus_daily	resi_daily	solar_daily
2022-09-30	30267.95	315476.6	107687.82	29	714	336	34.79075	14.72813	10.683315
2022-08-31	32086.09	389195.6	97002.04	29	715	336	35.69087	17.55902	9.312792
2022-07-31	32211.77	431538.6	76456.15	28	715	332	37.11033	19.46937	7.428697
2022-06-30	31934.28	401459.9	79519.73	28	716	331	38.01700	18.68994	8.008029
2022-05-31	34860.36	344037.3	65401.40	29	718	335	38.77682	15.45679	6.297679
2022-04-30	33182.43	310478.1	86780.30	29	718	333	38.14073	14.41403	8.686716
2022-03-31	34154.12	325636.1	96647.86	29	722	334	37.99124	14.54902	9.334350
2022-02-28	29412.32	293923.0	99565.15	29	720	335	36.22206	14.57951	10.614622
2022-01-31	32515.29	327315.2	110644.57	29	720	334	36.16829	14.66466	10.686167
2021-12-31	32439.70	323214.2	120105.89	29	721	332	36.08421	14.46084	11.669830
2021-11-30	30880.61	298876.5	107386.25	29	720	331	35.49496	13.83687	10.814325
2021-10-31	31787.82	301929.5	122623.12	29	720	329	35.35909	13.52731	12.023054
2021-09-30	30195.73	296729.4	115368.90	29	721	329	34.70774	13.71842	11.688845
2021-08-31	31114.83	352960.6	99439.84	29	722	328	34.61049	15.76984	9.779685
2021-07-31	31481.14	393303.9	79174.75	29	720	324	35.01795	17.62114	7.882791
2021-06-30	31554.95	372984.0	70149.10	29	720	320	36.27006	17.26778	7.307198
2021-05-31	34495.54	333172.3	82346.62	29	721	321	38.37101	14.90637	8.275211
2021-04-30	32997.68	297638.9	85313.96	29	719	315	37.92837	13.79874	9.027932
2021-03-31	34267.20	309759.7	86000.72	29	721	316	38.11702	13.85887	8.779167
2021-02-28	29635.06	282573.3	88870.04	29	718	314	36.49638	14.05558	10.108058
2021-01-31	30888.67	312506.8	104689.22	28	717	312	35.58602	14.05978	10.823948
2020-12-31	30002.23	310802.6	103646.98	28	716	311	34.56478	14.00264	10.750647
2020-11-30	26913.76	279763.8	116424.78	28	714	312	32.04018	13.06087	12.438545
2020-10-31	27510.44	286330.1	115541.83	27	714	308	32.86791	12.93621	12.101156
2020-09-30	27107.42	281964.3	102124.93	27	713	304	33.46596	13.18206	11.197909
2020-08-31	26175.83	345069.4	88886.81	27	715	305	31.27340	15.56821	9.401038
2020-07-31	27268.05	366278.5	71777.48	26	718	298	33.83133	16.45604	7.769807
2020-06-30	28966.05	349929.6	65010.59	26	717	297	37.13596	16.26823	7.296363
2020-05-31	30142.06	318528.7	68063.67	28	714	295	34.72588	14.39092	7.442720
2020-04-30	27521.91	293766.5	71565.22	28	713	289	32.76418	13.73382	8.254351
2020-03-31	27650.56	303210.5	75360.41	28	715	288	31.85548	13.67970	8.440906
2020-02-29	28396.35	292876.7	75728.28	28	712	287	34.97087	14.18427	9.098676
2020-01-31	30553.52	310588.8	89201.41	28	712	283	35.19991	14.07162	10.167720
2019-12-31	30486.35	310284.4	90722.02	28	712	281	35.12253	14.05783	10.414650
2019-11-30	32624.99	273009.0	99161.16	28	713	282	38.83927	12.76340	11.721177
2019-10-31	34802.81	277470.2	101983.26	28	711	277	40.09541	12.58882	11.876471
2019-09-30	30811.58	269953.0	96288.89	28	710	274	36.68045	12.67385	11.713977
2019-08-31	32110.79	334366.6	73739.72	28	711	272	36.99400	15.17021	8.745223
2019-07-31	32751.39	353173.4	61786.92	27	710	268	39.12950	16.04604	7.437039
2019-06-30	33633.99	343545.9	55360.25	27	709	266	41.52344	16.15166	6.937375
2019-05-31	34641.53	308216.8	56286.06	27	709	266	41.38773	14.02324	6.825862
2019-04-30	35656.03	289886.1	54748.71	27	707	261	44.01980	13.66742	6.992173
2019-03-31	34321.93	302569.6	58697.49	27	708	261	41.00589	13.78575	7.254665
2019-02-28	28349.40	277334.2	66457.42	28	706	263	36.15995	14.02945	9.024636
2019-01-31	31607.24	307529.9	77300.98	28	706	259	36.41388	14.05144	9.627722
2018-12-31	31246.81	301192.2	75643.54	28	704	256	35.99863	13.80096	9.531697
2018-11-30	27652.47	280379.3	77799.65	28	709	255	32.91961	13.18191	10.169889
2018-10-31	27388.87	284515.9	78291.86	28	707	253	31.55400	12.98152	9.982387
2018-09-30	26233.67	279182.4	75523.17	28	704	253	31.23056	13.21886	9.950352
2018-08-31	26865.43	346338.0	61667.38	28	704	255	30.95095	15.86959	7.801060
2018-07-31	28405.02	360466.0	54554.58	28	701	253	32.72468	16.58764	6.955830
2018-06-30	28732.65	346801.0	50036.93	28	700	250	34.20554	16.51433	6.671591
2018-05-31	29718.78	301823.0	52148.38	28	702	251	34.23823	13.86927	6.702015
2018-04-30	29690.84	282954.9	50740.44	28	699	250	35.34624	13.49332	6.765392
2018-03-31	30579.56	294026.7	52537.40	28	697	249	35.22991	13.60794	6.806245
2018-02-28	27114.44	277556.2	59515.19	28	700	250	34.58475	14.16103	8.502169
2018-01-31	29761.10	308288.0	69740.77	28	699	248	34.28699	14.22715	9.071380
2017-12-31	30013.15	305553.4	69912.62	28	697	248	34.57736	14.14141	9.093733
2017-11-30	27057.62	276506.3	67636.00	28	696	246	32.21146	13.24264	9.164770
2017-10-31	27698.37	282022.3	67791.20	28	694	241	31.91056	13.10878	9.073913
2017-09-30	27792.78	272064.6	66999.59	28	693	241	33.08664	13.08632	9.266886
2017-08-31	30756.86	316998.9	56808.24	28	695	242	35.43417	14.71334	7.572412
2017-07-31	29802.48	326294.3	53012.87	28	693	239	34.33466	15.18849	7.155199
2017-06-30	30405.84	314850.9	49038.12	28	689	238	36.19742	15.23226	6.868084
2017-05-31	29422.78	296785.9	47859.15	28	693	239	33.89721	13.81492	6.459596
2017-04-30	28117.38	282904.9	46547.32	27	690	238	34.71282	13.66691	6.519232
2017-03-31	27357.55	294681.5	49190.80	27	690	237	32.68525	13.77660	6.695359
2017-02-28	24966.08	285300.2	53528.68	27	690	237	33.02391	14.76709	8.066407
2017-01-31	28612.94	323106.9	61340.80	27	689	234	34.18511	15.12744	8.456134
2016-12-31	29680.85	318100.7	59747.71	27	687	230	35.46099	14.93641	8.379762
2016-11-30	26889.95	286186.2	62651.73	27	690	228	33.19747	13.82542	9.159609
2016-10-31	26688.67	287335.8	64952.13	27	689	223	31.88611	13.45268	9.395650
2016-09-30	25816.98	278727.9	59302.09	26	689	222	33.09869	13.48466	8.904218
2016-08-31	27847.16	328861.3	44790.06	26	690	222	34.54982	15.37454	6.508291
2016-07-31	31870.09	346948.4	37131.02	26	690	220	39.54105	16.22012	5.444431
2016-06-30	27564.21	333950.3	35377.64	26	686	216	35.33873	16.22693	5.459512
2016-05-31	32266.06	305569.2	41824.62	26	688	215	40.03233	14.32714	6.275263
2016-04-30	28567.78	276495.8	43482.17	27	685	213	35.26886	13.45478	6.804722
2016-03-31	26882.85	286883.0	45679.30	27	684	211	32.11810	13.52966	6.983534
2016-02-29	24448.43	275056.6	46669.01	28	684	210	30.10890	13.86654	7.663221
2016-01-31	26206.96	296152.8	51586.05	28	681	208	30.19235	14.02836	8.000317

==== TO DO ===== add words of explanation

Noosa Monthly Graphs- 4569

==== TO DO ===== add words of explanation

==== TO DO ===== add words of explanation

==== TO DO ===== add words of explanation

==== TO DO ===== add words of explanation blah blah blah

Noosa Forecasts- 4569

Should refactor to move forecast code to Main_1.Rmd and save results for later use

APVI installation ranges

Best to grab code from “test script.R” - use the yearly 100% code and use more meaningful headings

4571

Latest data for postcode 4571

Como, Kin Kin

Solar PV Installations	Value
Total Solar PV installations	235
Increase in the last 12 months	20
Average monthly increase - last 12 months	2
Increase in installations - last 12 months	9.3 %

Solar PV Capacity	Value
Total solar PV capacity (kW)	1,262
Increase in last 12 months (kW)	160
Average monthly increase last 12 months (kW)	13
Increase in capacity - last 12 months (kW)	14.5 %

Energex Connections	Value
Residential connections - NMI	378
Residential solar connections - NMI	181
Business connections - NMI	43
Business solar connections - NMI	15

Batteries	Value
Residential count	6
Residential capacity - kW	48
Residential storage - kWh	56
Business count	0
Business capacity - kW	0
Business storage - kWh	0

4571 Postcode map

As at December 31, 2022

2021 census dwellings = 428

The number of solar installations was 235 with total capacity of 1,262 kW.

This represents an increase in capacity of 160 kW over the last 12 months, giving an average monthly increase of 13 kW per month.

The corresponding increase in the number of solar installations in the last 12 months was 20, giving an average monthly increase of 2 new installations per month.

The increase in capacity over the last 12 months was 14.5 %

The increase in the number if installations over the last 12 months was 9.3 %

Solar installs and capacity

	per month				total
Date	PV qty	kW	SWH qty	HPSWH qty	PV qty	kW	SWH qty	HPSWH qty
2022-12-31	5	1	0	0	235	1,262	79	18
2022-11-30	29	3	0	0	234	1,257	79	18
2022-10-31	19	3	0	0	231	1,228	79	18
2022-09-30	39	3	0	1	228	1,209	79	18
2022-08-31	4	1	0	0	225	1,170	79	17
2022-07-31	7	1	0	0	224	1,165	79	17
2022-06-30	10	1	0	0	223	1,159	79	17
2022-05-31	9	2	0	0	222	1,148	79	17
2022-04-30	11	1	0	0	220	1,139	79	17
2022-03-31	9	2	0	0	219	1,128	79	17
2022-02-28	0	0	0	0	217	1,120	79	17
2022-01-31	18	2	0	0	217	1,120	79	17
2021-12-31	3	1	0	1	215	1,102	79	17
2021-11-30	0	0	0	0	214	1,099	79	16
2021-10-31	8	2	0	0	214	1,099	79	16
2021-09-30	16	2	1	0	212	1,090	79	16
2021-08-31	21	3	1	0	210	1,074	78	16
2021-07-31	53	3	1	0	207	1,053	77	16
2021-06-30	11	1	0	0	204	1,000	76	16
2021-05-31	0	0	0	0	203	989	76	16
2021-04-30	32	3	0	0	203	989	76	16
2021-03-31	7	1	0	0	200	958	76	16
2021-02-28	32	5	0	0	199	951	76	16
2021-01-31	13	2	0	0	194	919	76	16
2020-12-31	13	2	0	0	192	905	76	16
2020-11-30	19	3	0	0	190	893	76	16
2020-10-31	7	1	0	0	187	873	76	16
2020-09-30	23	3	0	0	186	867	76	16
2020-08-31	0	0	0	0	183	844	76	16
2020-07-31	11	2	0	0	183	844	76	16
2020-06-30	21	3	0	0	181	833	76	16
2020-05-31	18	2	0	0	178	812	76	16
2020-04-30	7	1	0	0	176	794	76	16
2020-03-31	39	3	0	0	175	787	76	16
2020-02-29	13	2	0	0	172	749	76	16
2020-01-31	0	0	0	0	170	735	76	16
2019-12-31	38	2	0	0	170	735	76	16
2019-11-30	8	2	0	0	168	697	76	16
2019-10-31	15	2	1	0	166	689	76	16
2019-09-30	34	4	0	0	164	674	75	16
2019-08-31	21	3	0	0	160	640	75	16
2019-07-31	20	2	1	0	157	619	75	16
2019-06-30	0	0	1	0	155	599	74	16
2019-05-31	6	1	0	0	155	599	73	16
2019-04-30	0	0	0	0	154	593	73	16
2019-03-31	14	2	0	0	154	593	73	16
2019-02-28	0	0	0	1	152	579	73	16
2019-01-31	7	1	0	0	152	579	73	15
2018-12-31	7	1	0	0	151	572	73	15
2018-11-30	0	0	0	0	150	566	73	15
2018-10-31	8	1	0	0	150	566	73	15
2018-09-30	19	3	0	0	149	558	73	15
2018-08-31	0	0	3	0	146	539	73	15
2018-07-31	0	0	0	0	146	539	70	15
2018-06-30	7	1	0	0	146	539	70	15
2018-05-31	0	0	0	0	145	531	70	15
2018-04-30	0	0	0	0	145	531	70	15
2018-03-31	13	2	1	0	145	531	70	15
2018-02-28	0	0	1	0	143	518	69	15
2018-01-31	17	3	1	0	143	518	68	15
2017-12-31	0	0	0	0	140	501	67	15
2017-11-30	0	0	0	0	140	501	67	15
2017-10-31	8	2	0	0	140	501	67	15
2017-09-30	24	3	0	0	138	493	67	15
2017-08-31	0	0	0	0	135	469	67	15
2017-07-31	5	1	0	0	135	469	67	15
2017-06-30	7	1	1	0	134	464	67	15
2017-05-31	0	0	0	0	133	457	66	15
2017-04-30	0	0	0	0	133	457	66	15
2017-03-31	12	2	1	0	133	457	66	15
2017-02-28	6	1	0	0	131	446	65	15
2017-01-31	5	1	0	0	130	440	65	15
2016-12-31	34	2	0	0	129	434	65	15
2016-11-30	18	3	0	0	127	401	65	15
2016-10-31	0	0	1	0	124	382	65	15
2016-09-30	0	0	0	0	124	382	64	15
2016-08-31	10	1	0	0	124	382	64	15
2016-07-31	11	2	0	0	123	372	64	15
2016-06-30	3	1	0	0	121	361	64	15
2016-05-31	0	0	0	0	120	358	64	15
2016-04-30	0	0	0	0	120	358	64	15
2016-03-31	0	0	0	0	120	358	64	15
2016-02-29	0	0	0	0	120	358	64	15
2016-01-31	0	0	0	0	120	358	64	15
2015-12-31	3	1	0	0	120	358	64	15
2015-11-30	1	1	0	0	119	355	64	15
2015-10-31	3	1	0	0	118	354	64	15
2015-09-30	9	2	0	0	117	351	64	15
2015-08-31	8	2	0	0	115	342	64	15
2015-07-31	0	0	0	0	113	334	64	15
2015-06-30	0	0	0	0	113	334	64	15
2015-05-31	2	1	0	0	113	334	64	15
2015-04-30	0	0	0	0	112	331	64	15
2015-03-31	9	2	0	0	112	331	64	15
2015-02-28	0	0	0	0	110	323	64	15
2015-01-31	2	1	0	0	110	323	64	15
2014-12-31	0	0	0	0	109	321	64	15
2014-11-30	0	0	0	0	109	321	64	15
2014-10-31	6	1	1	0	109	321	64	15
2014-09-30	5	2	0	0	108	315	63	15
2014-08-31	0	0	0	0	106	310	63	15
2014-07-31	1	1	0	0	106	310	63	15
2014-06-30	0	0	0	0	105	309	63	15
2014-05-31	9	2	0	0	105	309	63	15
2014-04-30	0	0	0	0	103	300	63	15
2014-03-31	8	2	0	0	103	300	63	15
2014-02-28	10	2	0	1	101	292	63	15
2014-01-31	5	1	0	0	99	282	63	14
2013-12-31	2	1	0	0	98	277	63	14
2013-11-30	0	0	0	0	97	275	63	14
2013-10-31	0	0	0	0	97	275	63	14
2013-09-30	5	1	0	0	97	275	63	14
2013-08-31	0	0	0	0	96	271	63	14
2013-07-31	0	0	1	0	96	271	63	14
2013-06-30	14	3	0	0	96	271	62	14
2013-05-31	20	4	0	0	93	257	62	14
2013-04-30	4	2	0	0	89	237	62	14
2013-03-31	0	0	0	0	87	233	62	14
2013-02-28	0	0	1	0	87	233	62	14
2013-01-31	0	0	0	0	87	233	61	14
2012-12-31	14	4	0	0	87	233	61	14
2012-11-30	12	3	0	0	83	219	61	14
2012-10-31	25	5	0	0	80	207	61	14
2012-09-30	14	6	0	1	75	182	61	14
2012-08-31	13	4	1	0	69	168	61	13
2012-07-31	12	4	0	0	65	154	60	13
2012-06-30	9	3	0	0	61	142	60	13
2012-05-31	5	1	0	0	58	133	60	13
2012-04-30	7	3	0	0	57	128	60	13
2012-03-31	6	2	0	0	54	121	60	13
2012-02-29	5	2	1	0	52	115	60	13
2012-01-31	4	2	0	0	50	110	59	13
2011-12-31	2	1	0	0	48	106	59	13
2011-11-30	0	0	0	0	47	104	59	13
2011-10-31	0	0	2	0	47	104	59	13
2011-09-30	0	0	0	0	47	104	57	13
2011-08-31	3	2	1	0	47	104	57	13
2011-07-31	3	1	0	0	45	101	56	13
2011-06-30	6	3	1	0	44	98	56	13
2011-05-31	8	3	1	0	41	92	55	13
2011-04-30	2	1	0	0	38	84	54	13
2011-03-31	9	5	1	0	37	82	54	13
2011-02-28	2	1	0	1	32	74	53	13
2011-01-31	3	1	0	0	31	71	53	12
2010-12-31	5	2	0	0	30	69	53	12
2010-11-30	0	0	2	0	28	64	53	12
2010-10-31	2	1	0	0	28	64	51	12
2010-09-30	2	1	0	0	27	63	51	12
2010-08-31	13	3	2	0	26	61	51	12
2010-07-31	7	4	1	0	23	47	49	12
2010-06-30	4	3	1	0	19	40	48	12
2010-05-31	1	1	1	1	16	36	47	12
2010-04-30	4	2	0	0	15	35	46	11
2010-03-31	0	0	1	0	13	31	46	11
2010-02-28	0	0	1	0	13	31	45	11
2010-01-31	4	2	1	0	13	31	44	11
2009-12-31	8	4	0	0	11	27	43	11
2009-11-30	1	1	0	0	7	20	43	11
2009-10-31	7	1	1	0	6	19	43	11
2009-09-30	0	0	0	0	5	12	42	11
2009-08-31	1	1	0	0	5	12	42	11
2009-07-31	0	0	2	4	4	11	42	11
2009-06-30	0	0	0	1	4	11	40	7
2009-05-31	0	0	0	0	4	11	40	6
2009-04-30	0	0	1	1	4	11	40	6
2009-03-31	0	0	0	0	4	11	39	5
2009-02-28	0	0	0	0	4	11	39	5
2009-01-31	8	2	1	0	4	11	39	5
2008-12-31	1	1	2	0	2	2	38	5
2008-11-30	0	0	0	0	1	1	36	5
2008-10-31	0	0	0	0	1	1	36	5
2008-09-30	1	1	1	0	1	1	36	5
2008-08-31	0	0	1	0	0	0	35	5
2008-07-31	0	0	0	0	0	0	34	5
2008-06-30	0	0	1	0	0	0	34	5
2008-05-31	0	0	0	0	0	0	33	5
2008-04-30	0	0	0	0	0	0	33	5
2008-03-31	0	0	0	0	0	0	33	5
2008-02-29	0	0	0	0	0	0	33	5
2008-01-31	0	0	0	0	0	0	33	5
2007-12-31	0	0	1	0	0	0	33	5
2007-11-30	0	0	1	0	0	0	32	5
2007-10-31	0	0	0	0	0	0	31	5
2007-09-30	0	0	2	1	0	0	31	5
2007-08-31	0	0	0	1	0	0	29	4
2007-07-31	0	0	0	1	0	0	29	3
2007-06-30	0	0	2	0	0	0	29	2
2007-05-31	0	0	2	0	0	0	27	2
2007-04-30	0	0	1	0	0	0	25	2
2007-03-31	0	0	0	1	0	0	24	2
2007-02-28	0	0	0	1	0	0	24	1
2007-01-31	0	0	1	0	0	0	24	0
2006-12-31	0	0	0	0	0	0	23	0
2006-11-30	0	0	1	0	0	0	23	0
2006-10-31	0	0	0	0	0	0	22	0
2006-09-30	0	0	1	0	0	0	22	0
2006-08-31	0	0	0	0	0	0	21	0
2006-07-31	0	0	1	0	0	0	21	0
2006-06-30	0	0	0	0	0	0	20	0
2006-05-31	0	0	0	0	0	0	20	0
2006-04-30	0	0	0	0	0	0	20	0
2006-03-31	0	0	3	0	0	0	20	0
2006-02-28	0	0	0	0	0	0	17	0
2006-01-31	0	0	0	0	0	0	17	0
2005-12-31	0	0	0	0	0	0	17	0
2005-11-30	0	0	0	0	0	0	17	0
2005-10-31	0	0	0	0	0	0	17	0
2005-09-30	0	0	0	0	0	0	17	0
2005-08-31	0	0	0	0	0	0	17	0
2005-07-31	0	0	0	0	0	0	17	0
2005-06-30	0	0	0	0	0	0	17	0
2005-05-31	0	0	0	0	0	0	17	0
2005-04-30	0	0	0	0	0	0	17	0
2005-03-31	0	0	1	0	0	0	17	0
2005-02-28	0	0	1	0	0	0	16	0
2005-01-31	0	0	0	0	0	0	15	0
2004-12-31	0	0	0	0	0	0	15	0
2004-11-30	0	0	0	0	0	0	15	0
2004-10-31	0	0	0	0	0	0	15	0
2004-09-30	0	0	0	0	0	0	15	0
2004-08-31	0	0	0	0	0	0	15	0
2004-07-31	0	0	0	0	0	0	15	0
2004-06-30	0	0	0	0	0	0	15	0
2004-05-31	0	0	0	0	0	0	15	0
2004-04-30	0	0	0	0	0	0	15	0
2004-03-31	0	0	0	0	0	0	15	0
2004-02-29	0	0	1	0	0	0	15	0
2004-01-31	0	0	0	0	0	0	14	0
2003-12-31	0	0	1	0	0	0	14	0
2003-11-30	0	0	0	0	0	0	13	0
2003-10-31	0	0	0	0	0	0	13	0
2003-09-30	0	0	0	0	0	0	13	0
2003-08-31	0	0	0	0	0	0	13	0
2003-07-31	0	0	0	0	0	0	13	0
2003-06-30	0	0	0	0	0	0	13	0
2003-05-31	0	0	0	0	0	0	13	0
2003-04-30	0	0	0	0	0	0	13	0
2003-03-31	0	0	2	0	0	0	13	0
2003-02-28	0	0	0	0	0	0	11	0
2003-01-31	0	0	1	0	0	0	11	0
2002-12-31	0	0	0	0	0	0	10	0
2002-11-30	0	0	1	0	0	0	10	0
2002-10-31	0	0	0	0	0	0	9	0
2002-09-30	0	0	0	0	0	0	9	0
2002-08-31	0	0	0	0	0	0	9	0
2002-07-31	0	0	4	0	0	0	9	0
2002-06-30	0	0	0	0	0	0	5	0
2002-05-31	0	0	0	0	0	0	5	0
2002-04-30	0	0	0	0	0	0	5	0
2002-03-31	0	0	1	0	0	0	5	0
2002-02-28	0	0	1	0	0	0	4	0
2002-01-31	0	0	0	0	0	0	3	0
2001-12-31	0	0	0	0	0	0	3	0
2001-11-30	0	0	2	0	0	0	3	0
2001-10-31	0	0	0	0	0	0	1	0
2001-09-30	0	0	1	0	0	0	1	0
2001-08-31	0	0	0	0	0	0	0	0
2001-07-31	0	0	0	0	0	0	0	0
2001-06-30	0	0	0	0	0	0	0	0
2001-05-31	0	0	0	0	0	0	0	0
2001-04-30	0	0	0	0	0	0	0	0

==== TO DO ===== Add some words of explanation in here….

Graphs for postcode 4571

==== TO DO ===== add words of explanation

==== TO DO ===== add words of explanation

==== TO DO ===== add words of explanation

==== TO DO ===== add words of explanation

Energex Consumption

year_month	bus_kWh	resi_kWh	solar_kWh	bus_NMI	resi_NMI	solar_NMI	bus_daily	resi_daily	solar_daily
2022-09-30	51307.13	168968.4	55272.06	43	378	176	39.77297	14.90021	10.468193
2022-08-31	53352.30	200281.4	53473.06	43	381	176	40.02423	16.95719	9.800780
2022-07-31	59502.82	226725.8	39674.10	42	379	173	45.70109	19.29745	7.397744
2022-06-30	57439.71	214045.5	41283.96	41	379	175	46.69895	18.82546	7.863611
2022-05-31	55950.98	190927.0	34075.29	42	378	176	42.97310	16.29348	6.245472
2022-04-30	49664.13	166887.0	46420.20	42	382	176	39.41597	14.56257	8.791706
2022-03-31	55807.72	175899.1	51417.15	42	381	176	42.86307	14.89282	9.423964
2022-02-28	47387.95	155360.9	50623.97	45	382	177	37.60949	14.52514	10.214683
2022-01-31	50445.29	172198.3	56390.40	44	381	175	36.98335	14.57948	10.394544
2021-12-31	44857.85	173756.4	60945.24	45	380	175	32.15616	14.75012	11.234146
2021-11-30	45486.95	160342.5	56326.35	45	380	176	33.69403	14.06513	10.667869
2021-10-31	46282.06	159887.8	67632.14	44	379	174	33.93113	13.60863	12.538401
2021-09-30	45384.26	155496.1	63570.93	44	378	172	34.38201	13.71218	12.319949
2021-08-31	50067.04	177381.8	56785.43	45	379	171	35.89035	15.09760	10.712211
2021-07-31	59662.09	199677.2	42842.78	45	380	170	42.76853	16.95053	8.129560
2021-06-30	62506.99	191952.4	38147.46	45	378	169	46.30147	16.92702	7.524154
2021-05-31	62485.01	180084.0	45156.71	46	378	171	43.81838	15.36815	8.518526
2021-04-30	56021.42	162191.2	46687.88	45	378	170	41.49735	14.30257	9.154485
2021-03-31	60741.18	167899.6	45263.84	45	376	169	43.54207	14.40456	8.639786
2021-02-28	54712.62	151636.2	45626.07	47	378	167	41.57494	14.32692	9.757500
2021-01-31	57667.26	167668.5	52932.60	46	378	161	40.43987	14.30863	10.605610
2020-12-31	51896.44	169754.2	50989.37	46	377	160	36.39301	14.52504	10.280115
2020-11-30	54557.69	157573.7	57500.37	46	377	159	39.53456	13.93225	12.054584
2020-10-31	54365.90	160723.2	57880.61	46	376	155	38.12475	13.78888	12.045912
2020-09-30	54853.22	157719.0	51318.67	47	376	153	38.90299	13.98218	11.180538
2020-08-31	60351.43	181892.2	47419.35	47	377	155	41.42171	15.56363	9.868752
2020-07-31	48547.68	198219.4	37190.62	46	375	154	34.04465	17.05113	7.790242
2020-06-30	45203.14	189218.1	33112.67	46	375	153	32.75590	16.81939	7.214089
2020-05-31	43399.01	177813.1	36446.47	47	376	152	29.78655	15.25507	7.734820
2020-04-30	41629.51	158455.5	38949.05	46	375	149	30.16631	14.08493	8.713434
2020-03-31	54150.04	162274.7	36935.01	46	375	145	37.97338	13.95911	8.216909
2020-02-29	53817.78	152614.3	37010.75	46	375	144	40.34317	14.03350	8.862726
2020-01-31	56044.99	161554.7	44683.29	46	375	142	39.30224	13.89718	10.150678
2019-12-31	55471.21	160031.7	46372.30	46	376	142	38.89987	13.72956	10.534371
2019-11-30	59170.14	146291.5	47394.16	46	375	143	42.87691	13.00369	11.047591
2019-10-31	55585.10	143815.4	47024.42	45	376	140	39.84595	12.33832	10.835121
2019-09-30	54056.21	140672.6	42491.46	44	375	136	40.95167	12.50423	10.414573
2019-08-31	57206.49	162300.1	35619.65	45	374	137	41.00824	13.99862	8.387014
2019-07-31	56700.40	176723.3	27610.09	45	373	134	40.64545	15.28351	6.646628
2019-06-30	54064.00	170180.5	25090.33	45	372	133	40.04740	15.24915	6.288302
2019-05-31	54233.42	160428.6	27469.45	46	372	134	38.03185	13.91160	6.612770
2019-04-30	52832.01	147496.6	27816.22	45	373	133	39.13482	13.18111	6.971483
2019-03-31	60723.25	154821.6	29055.95	45	373	132	43.52921	13.38940	7.100671
2019-02-28	54512.65	140721.3	31015.56	47	374	132	41.42299	13.43787	8.391657
2019-01-31	58979.40	156234.5	39288.62	47	374	132	40.48003	13.47546	9.601324
2018-12-31	51550.30	155600.9	38189.39	47	374	131	35.38112	13.42081	9.403938
2018-11-30	55698.80	145043.7	38159.18	47	374	132	39.50270	12.92725	9.636156
2018-10-31	53648.68	145064.0	38392.13	45	373	131	38.45784	12.54554	9.453862
2018-09-30	51980.08	140086.0	36703.25	45	373	129	38.50377	12.51885	9.484044
2018-08-31	56632.38	157177.3	31785.11	46	373	129	39.71415	13.59312	7.948264
2018-07-31	59726.69	170256.5	25829.66	46	371	126	41.88407	14.80363	6.612815
2018-06-30	56282.17	166677.9	24274.23	46	370	126	40.78418	15.01603	6.421755
2018-05-31	56035.20	160004.4	25980.37	47	370	128	38.45930	13.94982	6.547473
2018-04-30	54452.16	147887.8	25795.98	47	370	126	38.61855	13.32323	6.824333
2018-03-31	60215.55	152152.9	26306.64	47	371	124	41.32845	13.22953	6.843559
2018-02-28	54176.75	137622.2	28515.19	47	372	126	41.16775	13.21257	8.082537
2018-01-31	60337.08	152772.3	35952.98	46	370	124	42.31212	13.31929	9.353013
2017-12-31	50819.96	152734.5	35928.26	46	370	124	35.63812	13.31600	9.346581
2017-11-30	51934.23	140294.8	34265.29	47	371	126	36.83279	12.60510	9.064892
2017-10-31	54602.87	138875.4	34915.39	46	372	125	38.29093	12.04261	9.010424
2017-09-30	52668.79	134587.4	33453.77	45	371	123	39.01392	12.09231	9.066064
2017-08-31	56311.83	150577.2	30121.67	46	372	123	39.48936	13.05734	7.899731
2017-07-31	57121.20	158931.9	26315.87	45	371	118	40.94710	13.81897	7.194061
2017-06-30	55849.28	155243.4	24635.54	45	371	118	41.36984	13.94820	6.959191
2017-05-31	54044.65	155053.4	25475.29	46	370	117	37.89947	13.51817	7.023790
2017-04-30	49675.72	147569.7	24876.71	45	370	116	36.79683	13.29456	7.148480
2017-03-31	58400.19	152450.0	25445.38	45	371	116	41.86394	13.25537	7.076022
2017-02-28	51783.61	138565.8	25249.51	45	369	117	41.09810	13.41133	7.707421
2017-01-31	57695.84	155643.4	30578.15	45	367	116	41.35903	13.68053	8.503380
2016-12-31	54134.43	155771.3	30200.89	45	367	115	38.80605	13.69178	8.471499
2016-11-30	56699.08	146390.9	29236.95	45	368	113	41.99932	13.26004	8.624470
2016-10-31	57163.39	146356.2	30860.19	44	367	112	41.90865	12.86422	8.888302
2016-09-30	52339.60	141412.1	29441.61	44	367	111	39.65121	12.84396	8.841324
2016-08-31	52176.77	155417.7	25215.93	44	370	111	38.25277	13.54993	7.328081
2016-07-31	54449.84	166499.7	19302.04	43	368	110	40.84759	14.59499	5.660423
2016-06-30	52926.87	160428.0	18332.74	42	368	108	42.00545	14.53153	5.658253
2016-05-31	54629.44	156419.8	20927.14	43	368	108	40.98232	13.71141	6.250639
2016-04-30	53771.80	141958.2	22129.58	43	368	106	41.68357	12.85853	6.958987
2016-03-31	58114.28	146347.2	22840.80	43	369	106	43.59661	12.79371	6.950944
2016-02-29	54258.29	137252.7	22967.46	44	368	109	42.52217	12.86101	7.265884
2016-01-31	55163.09	146165.8	26974.04	43	366	109	41.38267	12.88258	7.982846

==== TO DO ===== add words of explanation

Noosa Monthly Graphs- 4571

==== TO DO ===== add words of explanation

==== TO DO ===== add words of explanation

==== TO DO ===== add words of explanation

==== TO DO ===== add words of explanation blah blah blah

Noosa Forecasts- 4571

Should refactor to move forecast code to Main_1.Rmd and save results for later use

APVI installation ranges

Best to grab code from “test script.R” - use the yearly 100% code and use more meaningful headings