data 2016-2021
2024-11-21
Set up
1. Limit to installs 2016-2021
2. Prepare data for isolated analysis
3. Create data for individual arrays
4. Append tables for each array
5. Summary table and plot of pre v post
## array no.check.pre no.check.post difference
## 1 AMF 1054 4960 3906
## 2 AMFNHQ 326 1930 1604
## 3 Arcadia 14 26 12
## 4 ArcadiaB 38 3 -35
## 5 Argyle 366 18 -348
## 6 BHorizons 47 174 127
## 7 BluePrairie 123 43 -80
## 8 Cashton 160 251 91
## 9 Chippewa 48 71 23
## 10 Comm.Ins 17 243 226
## 11 Conrath 13 65 52
## 12 Cumberland 83 78 -5
## 13 DCA 1962 2231 269
## 14 Downsville25 57 166 109
## 15 Downsville600 125 162 37
## 16 Elroy 110 12 -98
## 17 FdL.Inspire 367 138 -229
## 18 Fennimore 68 8 -60
## 19 Flambeau 20 207 187
## 20 GreenValleyDairy 107 1 -106
## 21 Hill.Const 19 192 173
## 22 Lafayette.Inspire 220 391 171
## 23 LibertyPole.Inspire 37 128 91
## 24 MATC 1549 3061 1512
## 25 Medford.Inspire 49 154 105
## 26 MoreyField 1807 2132 325
## 27 MtHope.Inspire 34 33 -1
## 28 NewAuburn.Inspire 118 78 -40
## 29 NewLisbon 88 28 -60
## 30 OBrien 2525 2974 449
## 31 OreDock 398 634 236
## 32 OrganicValley.Inspire 146 372 226
## 33 Price 39 56 17
## 34 PtBeach.Inspire 208 53 -155
## 35 RiceLake 312 37 -275
## 36 Riverland 1 40 39
## 37 RockRiver 58 491 433
## 38 SandLk.Inspire 234 1161 927
## 39 Sauk.Inspire 73 98 25
## 40 Strobus.Inspire 108 21 -87
## 41 Stromland.Inspire 76 35 -41
## 42 TwoCreeks.Inspire 272 215 -57
## 43 Vernon 56 123 67
## 44 WRiverside 235 229 -6
## 45 Warren.Inspire 44 98 54
## 46 WhistlingWinds.Inspire 70 517 447
6. Number of checklists per individual arrays
Note: y-axes not the same
7. Plot all arrays on one graph
8. Number of checklists for individual arrays
Note: y-axes the same and the vertical line represents the year of solar installation
