{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Target Instructions","Residential Renewable Grants","Commercial Renewable Grants","Instructions"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Target Instructions","index":0,"n_rows":8,"n_cols":1,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
["Click on the Developer tab.  Click on \"Macros\".  Select \"PrepPages\" and then select \"Run\".  This will clear the four worksheets."]
["Go to SalesForce.  Go to Reports.  Under \"CE Reporting\", search for \"Status Report - Residential\"  Run the report.  Export the report to an Excel spreadsheet in .csv format."]
["Open this .csv report.  Place the cursor in cell A1.  Press key F8 then hit Ctrl+Down Arrow, then Ctrl + Right Arrow.  This should select a block with all of the data.  If not, use the Shift+Right Arrow to block all of the data"]
["Copy the data to the \"Residential Target\" worksheet, starting in cell A1."]
["Go to SalesForce.  Go to Reports.  Under \"CE Reporting\", search for \"Status Report - Commercial\"  Run the report.  Export the report to an Excel spreadsheet in .csv format."]
["Open this .csv report.  Place the cursor in cell A1.  Press key F8 then hit Ctrl+Down Arrow, then Ctrl + Right Arrow.  This should select a block with all of the data.  If not, use the Shift+Right Arrow to block all of the data"]
["Copy the data to the \"Commercial Target\" worksheet, starting in cell A1."]

{"sheet":"Residential Renewable Grants","index":1,"n_rows":500,"n_cols":9,"rows_kept":500,"cut":false,"hidden":false,"merged":[[0,0,0,8]]}
["OPEN AWARD STATUS REPORT - RESIDENTIAL CLEAN ENERGY GRANT PROGRAM"]
[null,null,"Report Run",{"$f":"TODAY()","v":"2019-01-27"}]
["Identifier  (last name initial + first name initial + zip code)","Application Received Date","Award Status","MHT Review Status","Potential Award Amount","Last Invoice Received Date","Technology","Capacity","Capacity Units"]
["AB20603","2019-01-16","Application Approved","Passed",1000,null,"Solar PV",3.96,"kW"]
["AB20657","2019-01-02","Invoice Submitted","Passed",500,"2019-01-08","Wood Burning Stove",63700,"BTUs/hr"]
["AB21117","2019-01-21","Awaiting Signature Sheet","Not Started",1000,null,"Solar PV",5.8,"kW"]
["AC21014","2019-01-10","Application Submitted","Not Started",1000,null,"Solar PV",4.3499999999999996,"kW"]
["AD20866","2019-01-08","Invoice Submitted","Passed",1000,"2019-01-24","Solar PV",9.1300000000000008,"kW"]
["AJ20706","2019-01-08","Invoice Submitted","Passed",1000,"2019-01-24","Solar PV",7.93,"kW"]
["AJ20710","2019-01-18","Application Submitted","Not Started",1000,null,"Solar PV",4.0599999999999996,"kW"]
["AM20817","2019-01-07","Invoice Submitted","Passed",1000,"2019-01-08","Solar PV",5.85,"kW"]
["AM21046","2018-12-20","Application Approved","Passed",1000,null,"Solar PV",3.96,"kW"]
["AM21286","2018-12-17","Application Submitted","Under Review",1000,null,"Solar PV",13.92,"kW"]
["AP20871","2019-01-11","Invoice Submitted","Passed",1000,"2019-01-24","Solar PV",17.11,"kW"]
["AR21015","2019-01-07","Invoice Submitted","Passed",350,"2019-01-08","Pellet Burning Stove",28200,"BTUs/hr"]
["AR21638","2018-12-27","Invoice Submitted","Passed",350,"2019-01-04","Pellet Burning Stove",55000,"BTUs/hr"]
["AS20886","2019-01-07","Invoice Submitted","Passed",1000,"2019-01-24","Solar PV",5.31,"kW"]
["AT20706","2019-01-09","Invoice Submitted","Passed",1000,"2019-01-24","Solar PV",7.44,"kW"]
["AT20779","2019-01-18","Application on Standby","Not Started",3000,null,"Geothermal",5,"tons"]
["AT21755","2019-01-09","Invoice Submitted","Passed",1000,"2019-01-24","Solar PV",11.37,"kW"]
["AZ21060","2019-01-09","Application Approved","Passed",1000,null,"Solar PV",8.3699999999999992,"kW"]
["BA20814","2019-01-02","Application Submitted","Not Started",1000,null,"Solar PV",7.93,"kW"]
["BA20817","2019-01-18","Application Submitted","Not Started",1000,null,"Solar PV",8.1199999999999992,"kW"]
["BA21015","2019-01-07","Invoice Submitted","Passed",700,"2019-01-08","Pellet Burning Stove",71200,"BTUs/hr"]
["BC20659","2019-01-14","Invoice Submitted","Passed",700,"2019-01-24","Pellet Burning Stove",35000,"BTUs/hr"]
["BC20737","2018-12-17","Application Submitted","Under Review",1000,null,"Solar PV",8.5500000000000007,"kW"]
["BD20878","2018-12-19","Invoice Submitted","Passed",1000,"2019-01-04","Solar PV",16.100000000000001,"kW"]
["BD21029","2018-11-07","Invoice Submitted","Passed",1000,"2019-01-04",null,7.8,"Not Applicable"]
["BD21136","2018-12-27","Invoice Submitted","Passed",1000,"2019-01-04","Solar PV",4.93,"kW"]
["BD21401","2019-01-18","Application Approved","Passed",500,null,"Geothermal",5,"tons"]
["BD21403","2019-01-14","Application Approved","Passed",3000,null,"Geothermal",10,"tons"]
["BE20852","2019-01-09","Application Submitted","Not Started",1000,null,"Solar PV",7.2,"kW"]
["BG21122","2019-01-10","Invoice Submitted","Passed",700,"2019-01-24","Pellet Burning Stove",null,"BTUs/hr"]
["BJ21620","2018-10-15","Invoice Submitted","Passed",3000,"2019-01-04","Geothermal",5,"tons"]
["BJ21784","2019-01-11","Invoice Submitted","Passed",350,"2019-01-24","Pellet Burning Stove",16400,"BTUs/hr"]
["BK20748","2018-12-18","Application Submitted","Under Review",1000,null,"Solar PV",7.32,"kW"]
["BK21015","2019-01-11","Invoice Submitted","Passed",350,"2019-01-24","Pellet Burning Stove",45000,"BTUs/hr"]
["BK21401","2018-11-19","Invoice Submitted","Passed",3000,"2019-01-24","Geothermal",9,"tons"]
["BL21222","2019-01-18","Application Approved","Passed",1000,null,"Solar PV",2.9,"kW"]
["BL21409","2019-01-04","Invoice Submitted","Passed",700,"2019-01-08","Pellet Burning Stove",71200,"BTUs/hr"]
["BM20744","2019-01-18","Application Approved","Passed",1000,null,"Solar PV",5.22,"kW"]
["BM20886","2019-01-02","Invoice Submitted","Passed",1000,"2019-01-08","Solar PV",6.4,"kW"]
["BM21014","2019-01-10","Application Submitted","Not Started",1000,null,"Solar PV",6.96,"kW"]
["BM21085","2018-12-26","Application Submitted","Under Review",1000,null,"Solar PV",5.8,"kW"]
["BN20816","2019-01-22","Application Submitted","Not Started",1000,null,"Solar PV",6.96,"kW"]
["BR20616","2018-11-28","Invoice Submitted","Passed",700,"2018-12-12","Pellet Burning Stove",51000,"BTUs/hr"]
["BR20872","2018-12-31","Invoice Submitted","Passed",500,"2019-01-08","Wood Burning Stove",33600,"BTUs/hr"]
["BR21212","2019-01-23","Awaiting Signature Sheet","Not Started",1000,null,"Solar PV",9.92,"kW"]
["BS20685","2019-01-24","Application Received","Not Started",700,null,"Pellet Burning Stove",null,"BTUs/hr"]
["BS20895","2018-11-19","Invoice Submitted","Passed",1000,"2019-01-24","Solar PV",10.08,"kW"]
["BS21017","2019-01-14","Invoice Submitted","Passed",700,"2019-01-24","Pellet Burning Stove",46400,"BTUs/hr"]
["BS21054","2019-01-24","Application Received","Not Started",500,null,"Wood Burning Stove",null,"BTUs/hr"]
["BT20783","2019-01-14","Application Approved","Passed",1000,null,"Solar PV",13.865,"kW"]
["BT21015","2019-01-11","Invoice Submitted","Passed",700,"2019-01-24","Pellet Burning Stove",31300,"BTUs/hr"]
["BT21784","2018-12-26","Invoice Submitted","Passed",500,"2019-01-04","Wood Burning Stove",32600,"BTUs/hr"]
["BW21128","2019-01-17","Invoice Submitted","Passed",700,"2019-01-24","Pellet Burning Stove",28800,"BTUs/hr"]
["BW21144","2019-01-09","Invoice Submitted","Passed",1000,"2019-01-24","Solar PV",18.600000000000001,"kW"]
["CA21702","2018-12-28","Invoice Submitted","Passed",1000,"2019-01-24","Solar PV",11.16,"kW"]
["CC20878","2019-01-18","Application Approved","Passed",1000,null,"Solar PV",9.57,"kW"]
["CC21120","2018-12-13","Invoice Submitted","Passed",1000,"2019-01-24","Solar PV",2.2799999999999998,"kW"]
["CC21120","2019-01-18","Application Approved","Passed",3000,null,"Geothermal",4,"tons"]
["CC21228","2019-01-02","Application Submitted","Not Started",1000,null,"Solar PV",4.72,"kW"]
["CD20622","2019-01-21","Application Approved","Passed",1000,null,"Solar PV",12.48,"kW"]
["CD20832","2019-01-18","Application Approved","Passed",1000,null,"Solar PV",8.41,"kW"]
["CD20876","2019-01-24","Awaiting Signature Sheet","Not Started",1000,null,"Solar PV",6.62,"kW"]
["CD20882","2019-01-24","Awaiting Signature Sheet","Not Started",1000,null,"Solar PV",9.9,"kW"]
["CD21122","2019-01-18","Application Approved","Passed",3000,null,"Geothermal",4,"tons"]
["CE21015","2019-01-18","Application Approved","Passed",1000,null,"Solar PV",11.4,"kW"]
["CG20772","2019-01-14","Application Approved","Passed",1000,null,"Solar PV",16.5,"kW"]
["CG21208","2018-11-08","Invoice Submitted","Passed",1000,"2019-01-24","Solar PV",2.92,"kW"]
["CJ21108","2019-01-18","Application Approved","Passed",1000,null,"Solar PV",10.199999999999999,"kW"]
["CJ21122","2018-11-30","Invoice Submitted","Passed",1000,"2019-01-24","Solar PV",13.97,"kW"]
["CJ21160","2019-01-03","Invoice Submitted","Passed",3000,"2019-01-24","Geothermal",4,"tons"]
["CJ21804","2019-01-02","Invoice Submitted","Passed",700,"2019-01-08","Pellet Burning Stove",40200,"BTUs/hr"]
["CK20837","2019-01-15","Application Approved","Passed",1000,null,"Solar PV",4.8499999999999996,"kW"]
["CL21012","2019-01-24","Awaiting Signature Sheet","Not Started",1000,null,"Solar PV",10.199999999999999,"kW"]
["CM21009","2019-01-18","Invoice Submitted","Passed",700,"2019-01-24","Pellet Burning Stove",2600,"BTUs/hr"]
["CM21035","2019-01-03","Invoice Submitted","Passed",3000,"2019-01-24","Geothermal",5,"tons"]
["CM21146","2019-01-23","Invoice Submitted","Passed",250,"2019-01-24","Wood Burning Stove",65000,"BTUs/hr"]
["CR20854","2019-01-14","Application Approved","Passed",1000,null,"Solar PV",12,"kW"]
["CR21710","2019-01-04","Invoice Submitted","Passed",500,"2019-01-08","Wood Burning Stove",30772,"BTUs/hr"]
["CS21133","2019-01-16","Application Approved","Passed",1000,null,"Solar PV",9.42,"kW"]
["CS21219","2019-01-24","Application Received","Not Started",700,null,"Pellet Burning Stove",45000,"BTUs/hr"]
["CT20639","2019-01-14","Invoice Submitted","Passed",700,"2019-01-24","Pellet Burning Stove",50300,"BTUs/hr"]
["CT20783","2018-12-26","Invoice Submitted","Passed",1000,"2019-01-08","Solar PV",5.85,"kW"]
["CT21084","2018-12-17","Invoice Submitted","Passed",700,"2019-01-04","Pellet Burning Stove",72,"BTUs/hr"]
["CV20901","2018-12-10","Invoice Submitted","Passed",1000,"2019-01-24","Solar PV",4.87,"kW"]
["CV21237","2019-01-09","Invoice Submitted","Passed",1000,"2019-01-24","Solar PV",3.2450000000000001,"kW"]
["CW20906","2018-12-26","Application Submitted","Under Review",1000,null,"Solar PV",9.7349999999999994,"kW"]
["CW21015","2018-12-18","Invoice Submitted","Passed",700,"2019-01-04","Pellet Burning Stove",38400,"BTUs/hr"]
["CX20871","2019-01-23","Application Approved","Passed",1000,null,"Solar PV",12,"kW"]
["DA20735","2019-01-10","Application Submitted","Not Started",1000,null,"Solar PV",6.7850000000000001,"kW"]
["DB20678","2019-01-07","Invoice Submitted","Passed",700,"2019-01-08","Pellet Burning Stove",50300,"BTUs/hr"]
["DD21921","2019-01-04","Invoice Submitted","Passed",700,"2019-01-08","Pellet Burning Stove",50300,"BTUs/hr"]
["DE20877","2019-01-10","Application Submitted","Not Started",1000,null,"Solar PV",5.4,"kW"]
["DF20715","2019-01-08","Invoice Submitted","Passed",1000,"2019-01-24","Solar PV",3.48,"kW"]
["DJ20639","2019-01-18","Application Approved","Passed",1000,null,"Solar PV",12,"kW"]
["DJ20878","2019-01-10","Invoice Submitted","Passed",1000,"2019-01-24","Solar PV",9.2799999999999994,"kW"]
["DJ21014","2019-01-09","Application Submitted","Not Started",1000,null,"Solar PV",6.27,"kW"]
["DJ21084","2018-12-19","Invoice Submitted","Passed",1000,"2019-01-04","Solar PV",6.21,"kW"]
["DM20636","2019-01-03","Invoice Submitted","Passed",3000,"2019-01-24","Geothermal",3,"tons"]
["DM20912","2018-12-25","Invoice Submitted","Passed",1000,"2019-01-04","Solar PV",5.58,"kW"]
["DM21037","2019-01-23","Application Approved","Passed",1000,null,"Solar PV",4,"kW"]
["DM21043","2019-01-11","Invoice Submitted","Passed",1000,"2019-01-24","Solar PV",9.75,"kW"]
["DN21401","2018-11-29","Invoice Submitted","Passed",3000,"2019-01-24","Geothermal",6,"tons"]
["DP21208","2018-12-10","Application Submitted","Not Started",1000,null,"Solar PV",7.93,"kW"]
["DR21403","2019-01-23","Awaiting Signature Sheet","Not Started",1000,null,"Solar PV",7.2,"kW"]
["DS20902","2019-01-06","Invoice Submitted","Passed",1000,"2019-01-08","Solar PV",7.02,"kW"]
["DS21001","2019-01-09","Invoice Submitted","Passed",1000,"2019-01-24","Solar PV",4.3499999999999996,"kW"]
["DT20607","2019-01-07","Invoice Submitted","Passed",1000,"2019-01-24","Solar PV",6.49,"kW"]
["DT21620","2019-01-18","Application on Standby","Not Started",1000,null,"Solar PV",10.199999999999999,"kW"]
["DW20723","2018-12-26","Invoice Submitted","Passed",1000,"2019-01-04","Solar PV",6.49,"kW"]
["DW21009","2018-12-18","Invoice Submitted","Passed",1000,"2019-01-04","Solar PV",3.1,"kW"]
["DW21075","2019-01-11","Invoice Submitted","Passed",1000,"2019-01-24","Solar PV",10.44,"kW"]
["ED20603","2019-01-22","Application Approved","Passed",1000,null,"Solar PV",4,"kW"]
["ED21035","2019-01-07","Invoice Submitted","Passed",700,"2019-01-08","Pellet Burning Stove",50300,"BTUs/hr"]
["ED21837","2018-08-13","Invoice Submitted","Passed",500,"2019-01-04","Geothermal",3,"tons"]
["EG21787","2019-01-10","Application Approved","Passed",3000,null,"Geothermal",3,"tons"]
["EM21157","2019-01-10","Invoice Submitted","Passed",1000,"2019-01-24","Solar PV",9.6,"kW"]
["EV21030","2019-01-18","Application on Standby","Not Started",3000,null,"Geothermal",3,"tons"]
["FA21550","2019-01-22","Invoice Submitted","Passed",700,"2019-01-24","Pellet Burning Stove",50262,"BTUs/hr"]
["FB21409","2018-12-26","Invoice Submitted","Passed",700,"2019-01-04","Pellet Burning Stove",39428,"BTUs/hr"]
["FC20657","2019-01-04","Invoice Submitted","Passed",700,"2019-01-08","Pellet Burning Stove",61800,"BTUs/hr"]
["FC20902","2018-11-21","Invoice Submitted","Passed",1000,"2019-01-24","Solar PV",4.8,"kW"]
["FE21666","2019-01-23","Application on Standby","Not Started",700,null,"Pellet Burning Stove",50300,"BTUs/hr"]
["FJ21787","2019-01-22","Application Approved","Passed",1000,null,"Solar PV",10.44,"kW"]
["FM21917","2019-01-24","Awaiting Signature Sheet","Not Started",1000,null,"Solar PV",12.3,"kW"]
["FO21801","2019-01-22","Invoice Submitted","Passed",700,"2019-01-24","Pellet Burning Stove",37600,"BTUs/hr"]
["FS20853","2019-01-09","Application Approved","Passed",1000,null,"Solar PV",10.8,"kW"]
["FS21228","2018-12-28","Application Submitted","Under Review",1000,null,"Solar PV",6.3,"kW"]
["FV21060","2018-12-27","Invoice Submitted","Passed",1000,"2019-01-04","Solar PV",11.34,"kW"]
["GC20774","2018-12-28","Invoice Submitted","Passed",1000,"2019-01-08","Solar PV",12.71,"kW"]
["GC21078","2019-01-24","Application Approved","Passed",1000,null,"Solar PV",10.199999999999999,"kW"]
["GD20904","2018-12-26","Invoice Submitted","Passed",1000,"2019-01-04","Solar PV",12.18,"kW"]
["GD21093","2018-12-07","Application Approved","Passed",1000,null,"Solar PV",17.38,"kW"]
["GD21215","2019-01-16","Application Approved","Passed",1000,null,"Solar PV",9.6,"kW"]
["GF21209","2019-01-16","Application Approved","Passed",1000,null,"Solar PV",4.5,"kW"]
["GH21767","2018-12-26","Application Approved","Passed",1000,null,"Solar PV",10.37,"kW"]
["GJ20871","2018-09-17","Invoice Submitted","Passed",1000,"2019-01-08","Solar PV",8.23,"kW"]
["GJ21085","2019-01-24","Application Received","Not Started",1000,null,"Solar PV",5.8,"kW"]
["GJ21234","2019-01-10","Application Submitted","Not Started",1000,null,"Solar PV",4.93,"kW"]
["GK21117","2019-01-16","Application Approved","Passed",1000,null,"Solar PV",7.2,"kW"]
["GK21157","2019-01-04","Application Submitted","Under Review",1000,null,"Solar PV",8.6999999999999993,"kW"]
["GM21144","2018-12-28","Invoice Submitted","Passed",1000,"2019-01-24","Solar PV",11.97,"kW"]
["GM21701","2019-01-17","Application on Standby","Not Started",1000,null,"Solar PV",5.0999999999999996,"kW"]
["GP21028","2018-12-26","Invoice Submitted","Passed",700,"2019-01-04","Pellet Burning Stove",50300,"BTUs/hr"]
["GP21217","2018-12-20","Invoice Submitted","Passed",1000,"2019-01-04","Solar PV",6.12,"kW"]
["GR20854","2019-01-06","Invoice Submitted","Passed",1000,"2019-01-08","Solar PV",9.76,"kW"]
["GR21060","2018-12-26","Invoice Submitted","Passed",1000,"2019-01-08","Solar PV",9.4499999999999993,"kW"]
["GR21146","2018-12-27","Awaiting Signature Sheet","Not Started",1000,null,"Solar PV",10.54,"kW"]
["GS21286","2018-12-19","Invoice Submitted","Passed",500,"2019-01-04","Wood Burning Stove",27535,"BTUs/hr"]
["GS21704","2019-01-22","Application Submitted","Not Started",3000,null,"Geothermal",4,"tons"]
["GT21028","2019-01-17","Invoice Submitted","Passed",700,"2019-01-24","Pellet Burning Stove",50300,"BTUs/hr"]
["GU21075","2018-12-21","Invoice Submitted","Passed",1000,"2019-01-04","Solar PV",8.6999999999999993,"kW"]
["GW21758","2019-01-07","Invoice Submitted","Passed",700,"2019-01-08","Pellet Burning Stove",39700,"BTUs/hr"]
["GZ21234","2018-11-20","Invoice Submitted","Passed",1000,"2019-01-24","Solar PV",6.3,"kW"]
["HA20735","2018-11-19","Application Approved","Passed",1000,null,"Solar PV",8.4,"kW"]
["HA21784","2018-11-19","Application Approved","Passed",1000,null,"Solar PV",2.9,"kW"]
["HB20853","2019-01-10","Application Approved","Passed",1000,null,"Solar PV",6.1950000000000003,"kW"]
["HC20814","2018-10-10","Application Submitted","Under Review",1000,null,"Solar PV",7.2,"kW"]
["HC20832","2019-01-16","Awaiting Signature Sheet","Not Started",1000,null,"Solar PV",12.2,"kW"]
["HC20904","2018-12-28","Application Approved","Passed",1000,null,"Solar PV",10.54,"kW"]
["HC21060","2019-01-09","Application Approved","Passed",1000,null,"Solar PV",6.82,"kW"]
["HC21136","2019-01-10","Application Submitted","Not Started",1000,null,"Solar PV",6.9,"kW"]
["HC21204","2019-01-18","Awaiting Signature Sheet","Not Started",1000,null,"Solar PV",14.49,"kW"]
["HC21804","2019-01-22","Application Received","Not Started",700,null,"Pellet Burning Stove",37600,"BTUs/hr"]
["HD20613","2018-12-26","Invoice Submitted","Passed",350,"2019-01-07","Pellet Burning Stove",38700,"BTUs/hr"]
["HD20784","2018-12-19","Application Submitted","Under Review",1000,null,"Solar PV",5.7,"kW"]
["HD21047","2019-01-02","Application Approved","Passed",3000,null,"Geothermal",9,"tons"]
["HD21087","2019-01-17","Application on Standby","Not Started",1000,null,"Solar PV",7,"kW"]
["HD21114","2019-01-14","Application Submitted","Not Started",1000,null,"Solar PV",4.0599999999999996,"kW"]
["HD21921","2018-11-27","Application Approved","Passed",1000,null,"Solar PV",8.1199999999999992,"kW"]
["HE20735","2018-12-14","Invoice Submitted","Passed",1000,"2019-01-07","Solar PV",8.85,"kW"]
["HE20882","2018-11-26","Invoice Submitted","Passed",1000,"2019-01-07","Solar PV",9.61,"kW"]
["HG21826","2019-01-16","Application Received","Not Started",1000,null,"Solar PV",6.9,"kW"]
["HG21921","2018-12-26","Application Submitted","Under Review",1000,null,"Solar PV",4.0599999999999996,"kW"]
["HJ20744","2019-01-04","Application Approved","Passed",700,null,"Pellet Burning Stove",37600,"BTUs/hr"]
["HJ21015","2019-01-18","Application Submitted","Not Started",1000,null,"Solar PV",6.38,"kW"]
["HJ21769","2019-01-22","Awaiting Signature Sheet","Not Started",1000,null,"Solar PV",12,"kW"]
["HJ21771","2019-01-22","Application Received","Not Started",1000,null,"Solar PV",20.77,"kW"]
["HK21087","2018-12-08","Invoice Submitted","Passed",700,"2018-12-12","Pellet Burning Stove",50300,"BTUs/hr"]
["HK21122","2019-01-02","Application Approved","Passed",3000,null,"Geothermal",8,"tons"]
["HK21146","2019-01-11","Application Approved","Passed",1000,null,"Solar PV",13.95,"kW"]
["HM20639","2018-12-10","Invoice Submitted","Passed",700,"2019-01-07","Pellet Burning Stove",50300,"BTUs/hr"]
["HM21702","2019-01-10","Application on Standby","Not Started",1000,null,"Solar PV",11.89,"kW"]
["HN21061","2019-01-09","Awaiting Signature Sheet","Not Started",1000,null,"Solar PV",7.13,"kW"]
["HN21666","2018-12-17","Application on Standby","Not Started",350,null,"Pellet Burning Stove",35000,"BTUs/hr"]
["HP21014","2019-01-14","Application Approved","Passed",700,null,"Pellet Burning Stove",50300,"BTUs/hr"]
["HR20601","2019-01-14","Application Approved","Passed",1000,null,"Solar PV",4,"kW"]
["HR20723","2019-01-11","Application Approved","Passed",1000,null,"Solar PV",9.9,"kW"]
["HR21104","2019-01-10","Application Approved","Passed",1000,null,"Solar PV",11.31,"kW"]
["HR21144","2018-11-30","Invoice Submitted","Passed",3000,"2019-01-07","Geothermal",5,"tons"]
["HR21158","2019-01-10","Application Approved","Passed",1000,null,"Solar PV",10.8,"kW"]
["HR21740","2019-01-24","Awaiting Signature Sheet","Not Started",1000,null,"Solar PV",9.3000000000000007,"kW"]
["HS20854","2019-01-10","Application Submitted","Not Started",1000,null,"Solar PV",14.1,"kW"]
["HS21409","2019-01-03","Application Approved","Passed",3000,null,"Geothermal",3,"tons"]
["Ht21001","2019-01-22","Application Received","Not Started",1000,null,"Solar PV",8.1199999999999992,"kW"]
["HT21076","2018-12-13","Application Submitted","Under Review",1000,null,"Solar PV",7.44,"kW"]
["HT21228","2019-01-04","Application Approved","Passed",1000,null,"Solar PV",4.0599999999999996,"kW"]
["HW20657","2018-12-17","Invoice Submitted","Passed",350,"2019-01-07","Pellet Burning Stove",45500,"BTUs/hr"]
["IM20910","2018-12-11","Application Submitted","Under Review",1000,null,"Solar PV",5.94,"kW"]
["IP21043","2018-12-17","Invoice Submitted","Passed",1000,"2019-01-07","Solar PV",18,"kW"]
["JD21047","2019-01-15","Application Approved","Passed",3000,null,"Geothermal",6,"tons"]
["JG20906","2019-01-08","Application Approved","Passed",3000,null,"Geothermal",3,"tons"]
["JJ21040","2018-10-22","Application Approved","Passed",1000,null,"Solar PV",2.3199999999999998,"kW"]
["JK20735","2018-12-14","Invoice Submitted","Passed",1000,"2019-01-07","Solar PV",12.35,"kW"]
["JL21044","2018-10-13","Application Approved","Passed",1000,null,"Solar PV",5.04,"kW"]
["JM20815","2019-01-08","Application Approved","Passed",1000,null,"Solar PV",11.7,"kW"]
["JN21054","2019-01-09","Application Submitted","Passed",1000,null,"Solar PV",9.92,"kW"]
["JP21208","2018-11-19","Application Approved","Passed",1000,null,"Solar PV",5.22,"kW"]
["JR20744","2019-01-11","Awaiting Signature Sheet","Not Started",1000,null,"Solar PV",8.3000000000000007,"kW"]
["JW21784","2019-01-03","Application Received","Not Started",1000,null,"Solar PV",9.1,"kW"]
["KA20759","2019-01-18","Application Approved","Passed",1000,null,"Solar PV",12.6,"kW"]
["KA21903","2019-01-07","Application Approved","Passed",1000,null,"Solar PV",6,"kW"]
["KB20772","2018-12-29","Application Approved","Passed",1000,null,"Solar PV",6.96,"kW"]
["KB21204","2019-01-04","Application Submitted","Not Started",1000,null,"Solar PV",12.35,"kW"]
["KD20853","2018-12-05","Application Approved","Passed",1000,null,"Solar PV",3.6,"kW"]
["KD21076","2019-01-16","Application Approved","Passed",1000,null,"Solar PV",9.9,"kW"]
["KD21111","2018-12-26","Application Submitted","Under Review",3000,null,"Geothermal",6,"tons"]
["KJ20833","2019-01-18","Awaiting Second Review","Not Started",3000,null,"Geothermal",10,"tons"]
["KJ20871","2019-01-17","Application Approved","Passed",1000,null,"Solar PV",12,"kW"]
["KJ21060","2019-01-18","Application Submitted","Not Started",1000,null,"Solar PV",8.26,"kW"]
["KJ21102","2019-01-25","Application Received","Not Started",1000,null,"Solar PV",6,"kW"]
["KK20706","2019-01-18","Application on Standby","Not Started",1000,null,"Solar PV",7.67,"kW"]
["KK20850","2018-11-30","Application Approved","Passed",1000,null,"Solar PV",8.6999999999999993,"kW"]
["KK20878","2019-01-14","Application Received","Not Started",1000,null,"Solar PV",9,"kW"]
["KK20901","2018-12-20","Application Submitted","Under Review",1000,null,"Solar PV",3.27,"kW"]
["KK21015","2019-01-11","Application Approved","Passed",700,null,"Pellet Burning Stove",50300,"BTUs/hr"]
["KK21756","2019-01-17","Application Received","Not Started",3000,null,"Geothermal",3,"tons"]
["KM20659","2018-11-27","Invoice Submitted","Passed",350,"2019-01-07","Pellet Burning Stove",45000,"BTUs/hr"]
["KM20723","2019-01-09","Awaiting Signature Sheet","Not Started",1000,null,"Solar PV",10.85,"kW"]
["KM21075","2018-11-15","Invoice Submitted","Passed",1000,"2018-12-21","Solar PV",6.71,"kW"]
["KO20721","2018-12-31","Application Approved","Passed",1000,null,"Solar PV",8.26,"kW"]
["KR20886","2019-01-24","Awaiting Signature Sheet","Not Started",1000,null,"Solar PV",5.4,"kW"]
["KR21084","2019-01-07","Application Approved","Passed",700,null,"Pellet Burning Stove",71200,"BTUs/hr"]
["KR21146","2019-01-02","Application Approved","Passed",700,null,"Pellet Burning Stove",38400,"BTUs/hr"]
["KR21740","2018-12-10","Invoice Submitted","Passed",700,"2019-01-07","Pellet Burning Stove",52000,"BTUs/hr"]
["KS21131","2018-12-10","Invoice Submitted","Passed",3000,"2019-01-07","Geothermal",6,"tons"]
["KT21154","2018-12-26","Invoice Submitted","Passed",500,"2019-01-07","Geothermal Replacement",4,"tons"]
["KV21784","2019-01-18","Application Received","Not Started",1000,null,"Solar PV",16.53,"kW"]
["LA20855","2019-01-10","Awaiting Signature Sheet","Not Started",1000,null,"Solar PV",9.75,"kW"]
["LA21403","2019-01-09","Application on Standby","Not Started",3000,null,"Geothermal",3,"tons"]
["LC21035","2018-12-10","Invoice Submitted","Passed",3000,"2019-01-07","Geothermal",4,"tons"]
["LC21108","2018-12-26","Application Approved","Passed",1000,null,"Solar PV",7.13,"kW"]
["LD20621","2018-12-20","Invoice Submitted","Passed",700,"2019-01-07","Pellet Burning Stove",40200,"BTUs/hr"]
["LD20724","2018-12-07","Invoice Submitted","Passed",1000,"2019-01-07","Solar PV",12.09,"kW"]
["LD20764","2019-01-24","Application Received","Not Started",1000,null,"Solar PV",5.8,"kW"]
["LE20735","2018-08-08","Awaiting Second Review","Not Started",1000,null,"Solar PV",7.62,"kW"]
["LF20706","2018-12-03","Invoice Submitted","Passed",1000,"2019-01-07","Solar PV",13.72,"kW"]
["LF20855","2019-01-09","Application Approved","Passed",1000,null,"Solar PV",7.88,"kW"]
["LG21113","2019-01-08","Application Approved","Passed",1000,null,"Solar PV",7.75,"kW"]
["LH20814","2019-01-18","Application on Standby","Not Started",1000,null,"Solar PV",10.5,"kW"]
["LI21117","2019-01-10","Application Submitted","Not Started",1000,null,"Solar PV",9.2799999999999994,"kW"]
["LJ20855","2019-01-17","Application Received","Not Started",1000,null,"Solar PV",12.3,"kW"]
["LJ21113","2018-12-14","Application Submitted","Under Review",1000,null,"Solar PV",10.44,"kW"]
["LJ21220","2019-01-09","Application Approved","Passed",3000,null,"Geothermal",7,"tons"]
["LK20711","2019-01-10","Application Approved","Passed",1000,null,"Solar PV",8.1199999999999992,"kW"]
["LL21631","2018-12-19","Invoice Submitted","Passed",350,"2019-01-07","Pellet Burning Stove",28200,"BTUs/hr"]
["LM20902","2019-01-09","Application Approved","Passed",1000,null,"Solar PV",8.4,"kW"]
["LM21050","2019-01-22","Application Received","Not Started",700,null,"Pellet Burning Stove",30000,"BTUs/hr"]
["LP20814","2019-01-24","Awaiting Signature Sheet","Not Started",1000,null,"Solar PV",8.0399999999999991,"kW"]
["LP20878","2019-01-09","Application Approved","Passed",1000,null,"Solar PV",9.3000000000000007,"kW"]
["LP21223","2018-12-20","Application Approved","Passed",1000,null,"Solar PV",3.27,"kW"]
["LR20678","2019-01-03","Invoice Submitted","Passed",700,"2019-01-07","Pellet Burning Stove",46399,"BTUs/hr"]
["LR21093","2019-01-14","Application Received","Not Started",1000,null,"Solar PV",7.5,"kW"]
["LR21122","2018-12-28","Invoice Submitted","Passed",1000,"2019-01-07","Solar PV",7.56,"kW"]
["LS20816","2018-12-03","Application Approved","Passed",1000,null,"Solar PV",8.6999999999999993,"kW"]
["LT20901","2019-01-24","Awaiting Signature Sheet","Not Started",1000,null,"Solar PV",5.4,"kW"]
["LT21060","2018-12-27","Invoice Submitted","Passed",1000,"2019-01-07","Solar PV",3,"kW"]
["LW21050","2019-01-11","Application Accepted","Passed",700,null,"Pellet Burning Stove",50300,"BTUs/hr"]
["LW21108","2018-12-14","Application Submitted","Under Review",1000,null,"Solar PV",9.6,"kW"]
["MA20639","2018-12-26","Invoice Submitted","Passed",700,"2019-01-07","Pellet Burning Stove",28200,"BTUs/hr"]
["MA20646","2018-11-12","Application Submitted","Under Review",1000,null,"Solar PV",18.3,"kW"]
["MA20877","2018-12-18","Invoice Submitted","Passed",1000,"2019-01-07","Solar PV",6.9,"kW"]
["MA21771","2019-01-14","Application Submitted","Not Started",3000,null,"Geothermal",5,"tons"]
["MB21156","2018-08-28","Invoice Submitted","Passed",1000,"2019-01-07","Solar PV",6.27,"kW"]
["MC20759","2019-01-15","Application Approved","Passed",1000,null,"Solar PV",12,"kW"]
["MC21014","2018-12-20","Application Approved","Passed",1000,null,"Solar PV",6.89,"kW"]
["MD20715","2018-12-27","Application Submitted","Under Review",1000,null,"Solar PV",12.35,"kW"]
["MD20748","2018-12-04","Application Approved","Passed",1000,null,"Solar PV",10.07,"kW"]
["ME20636","2019-01-17","Application Approved","Passed",1000,null,"Solar PV",13.92,"kW"]
["ME20874","2019-01-15","Application Received","Not Started",1000,null,"Solar PV",7.25,"kW"]
["ME21144","2018-12-17","Invoice Submitted","Passed",350,"2019-01-07","Pellet Burning Stove",30000,"BTUs/hr"]
["MF20721","2018-12-18","Invoice Submitted","Passed",1000,"2019-01-07","Solar PV",4.13,"kW"]
["MF21797","2018-12-19","Invoice Submitted","Passed",1000,"2019-01-07","Solar PV",16.2,"kW"]
["MJ20618","2018-12-31","Invoice Submitted","Passed",700,"2019-01-07","Pellet Burning Stove",50300,"BTUs/hr"]
["MJ20685","2019-01-22","Application Received","Not Started",700,null,"Pellet Burning Stove",50300,"BTUs/hr"]
["MJ20901","2019-01-24","Awaiting Signature Sheet","Not Started",1000,null,"Solar PV",5.95,"kW"]
["MJ20902","2019-01-07","Application Approved","Passed",1000,null,"Solar PV",19.2,"kW"]
["MJ21044","2019-01-15","Application on Standby","Not Started",3000,null,"Geothermal",4,"tons"]
["MJ21144","2018-12-19","Invoice Submitted","Passed",1000,"2019-01-07","Solar PV",7.75,"kW"]
["MJ21401","2019-01-07","Application Approved","Passed",350,null,"Pellet Burning Stove",55000,"BTUs/hr"]
["MJ21758","2018-12-14","Invoice Submitted","Passed",1000,"2019-01-07","Solar PV",19.664999999999999,"kW"]
["MK21160","2019-01-14","Application Accepted","Passed",700,null,"Pellet Burning Stove",50000,"BTUs/hr"]
["MK21804","2019-01-15","Application Approved","Passed",700,null,"Pellet Burning Stove",40200,"BTUs/hr"]
["ML20866","2019-01-08","Application Approved","Passed",1000,null,"Solar PV",10.39,"kW"]
["ML20906","2018-11-19","Application Approved","Passed",1000,null,"Solar PV",9.15,"kW"]
["ML21122","2018-12-10","Invoice Submitted","Passed",700,"2019-01-07","Pellet Burning Stove",22266,"BTUs/hr"]
["MM20639","2019-01-07","Application Approved","Passed",350,null,"Pellet Burning Stove",null,"BTUs/hr"]
["MM20659","2018-12-26","Invoice Submitted","Passed",350,"2019-01-07","Pellet Burning Stove",33900,"BTUs/hr"]
["MM20777","2018-12-17","Invoice Submitted","Passed",1000,"2019-01-07","Solar PV",13.3,"kW"]
["MM21047","2019-01-07","Application Approved","Passed",700,null,"Pellet Burning Stove",50300,"BTUs/hr"]
["MM21804","2018-11-09","Application Approved","Passed",1000,null,"Solar PV",10.56,"kW"]
["MN20783","2019-01-07","Application Approved","Passed",1000,null,"Solar PV",5.8,"kW"]
["MN20871","2019-01-17","Application Approved","Passed",1000,null,"Solar PV",8.1,"kW"]
["MP21716","2018-12-21","Invoice Submitted","Passed",700,"2019-01-07","Pellet Burning Stove",68000,"BTUs/hr"]
["MP21921","2018-12-05","Awaiting Signature Sheet","Not Started",1000,null,"Solar PV",9.15,"kW"]
["MR20882","2018-11-30","Application Approved","Passed",1000,null,"Solar PV",6.96,"kW"]
["MR21060","2018-11-26","Invoice Submitted","Passed",1000,"2019-01-07","Solar PV",8.5399999999999991,"kW"]
["MR21136","2019-01-11","Application Approved","Passed",1000,null,"Solar PV",14.3,"kW"]
["MS20874","2019-01-17","Application Submitted","Passed",1000,null,"Solar PV",11.02,"kW"]
["MT20770","2018-12-20","Invoice Submitted","Passed",1000,"2019-01-07","Solar PV",11.39,"kW"]
["MT21774","2019-01-07","Application Approved","Passed",500,null,"Wood Burning Stove",45000,"BTUs/hr"]
["MW21157","2019-01-09","Awaiting Signature Sheet","Not Started",1000,null,"Solar PV",8.32,"kW"]
["NA20736","2019-01-04","Application Approved","Passed",700,null,"Pellet Burning Stove",28800,"BTUs/hr"]
["ND21061","2018-12-26","Application Approved","Passed",1000,null,"Solar PV",6.3,"kW"]
["NG20906","2018-10-15","Application Submitted","Passed",1000,null,"Solar PV",4.58,"kW"]
["NG21770","2018-12-26","Invoice Submitted","Passed",1000,"2019-01-07","Solar PV",3.35,"kW"]
["NJ21028","2019-01-16","Application Approved","Passed",1000,null,"Solar PV",16.25,"kW"]
["NL21093","2019-01-16","Application Submitted","Not Started",1000,null,"Solar PV",5.4,"kW"]
["NL21157","2019-01-24","Application Received","Not Started",1000,null,"Solar PV",8.82,"kW"]
["NO21117","2019-01-15","Application Submitted","Passed",1000,null,"Solar PV",3.25,"kW"]
["NP21075","2019-01-11","Application Approved","Passed",1000,null,"Solar PV",8.1,"kW"]
["NR21401","2019-01-24","Application Received","Not Started",500,null,"Geothermal Replacement",4,"tons"]
["NT21228","2018-12-20","Invoice Submitted","Passed",1000,"2019-01-07","Solar PV",8.76,"kW"]
["OA20706","2018-12-26","Application on Standby","Not Started",1000,null,"Solar PV",12.3,"kW"]
["OA20852","2019-01-14","Awaiting Signature Sheet","Not Started",1000,null,"Solar PV",8.1,"kW"]
["OA21053","2018-12-26","Application Approved","Passed",500,null,"Wood Burning Stove",77000,"BTUs/hr"]
["OJ20678","2019-01-07","Application Approved","Passed",700,null,"Pellet Burning Stove",43000,"BTUs/hr"]
["OM21401","2019-01-07","Application Submitted","Not Started",1000,null,"Solar PV",2.74,"kW"]
["OO20905","2019-01-08","Application Approved","Passed",1000,null,"Solar PV",9.3000000000000007,"kW"]
["OR20712","2018-08-24","Application on Standby","Not Started",1000,null,"Solar PV",9,"kW"]
["OR21136","2018-12-20","Awaiting Signature Sheet","Not Started",1000,null,"Solar PV",8.64,"kW"]
["OS21085","2019-01-16","Application Received","Not Started",1000,null,"Solar PV",11.31,"kW"]
["OS21769","2019-01-15","Application Submitted","Passed",1000,null,"Solar PV",7.68,"kW"]
["OT21133","2018-08-23","Application Approved","Passed",1000,null,"Solar PV",4.0599999999999996,"kW"]
["PA20866","2018-12-13","Application Approved","Passed",1000,null,"Solar PV",6.51,"kW"]
["PA21207","2018-11-19","Application Approved","Passed",1000,null,"Solar PV",6.69,"kW"]
["PB21122","2018-12-11","Invoice Submitted","Passed",1000,"2019-01-07","Solar PV",8.3699999999999992,"kW"]
["PC21108","2019-01-09","Awaiting Signature Sheet","Not Started",1000,null,"Solar PV",6.82,"kW"]
["PD20853","2018-12-31","Application Approved","Passed",3000,null,"Geothermal",3,"tons"]
["PD20902","2018-09-19","Invoice Submitted","Passed",1000,"2019-01-07","Solar PV",7.44,"kW"]
["PD20910","2019-01-08","Application Approved","Passed",1000,null,"Solar PV",6.48,"kW"]
["PD21666","2018-12-31","Invoice Submitted","Passed",1000,"2019-01-07","Solar PV",4.72,"kW"]
["PE20695","2019-01-17","Application Received","Not Started",1000,null,"Solar PV",4,"kW"]
["PE21154","2019-01-04","Application Approved","Passed",700,null,"Pellet Burning Stove",35000,"BTUs/hr"]
["PF21631","2019-01-07","Application on Standby","Not Started",500,null,"Wood Burning Stove",27400,"BTUs/hr"]
["PJ20639","2018-11-28","Application on Standby","Not Started",700,null,"Pellet Burning Stove",52600,"BTUs/hr"]
["PJ20905","2018-11-09","Invoice Submitted","Passed",1000,"2019-01-07","Solar PV",13.65,"kW"]
["PJ21060","2018-11-27","Application Approved","Passed",1000,null,"Solar PV",4.34,"kW"]
["PJ21060","2018-12-28","Invoice Submitted","Passed",1000,"2019-01-07","Solar PV",14.26,"kW"]
["PJ21152","2019-01-18","Awaiting Signature Sheet","Not Started",1000,null,"Solar PV",7.44,"kW"]
["PJ21754","2018-12-26","Invoice Submitted","Passed",1000,"2019-01-07","Solar PV",17.100000000000001,"kW"]
["PK20740","2019-01-24","Awaiting Signature Sheet","Not Started",1000,null,"Solar PV",4.2699999999999996,"kW"]
["PM21220","2019-01-03","Application on Standby","Not Started",3000,null,"Geothermal",7,"tons"]
["PP20776","2019-01-10","Application Approved","Passed",3000,null,"Geothermal",4,"tons"]
["PR21919","2018-12-20","Application Submitted","Not Started",3000,null,"Geothermal",4,"tons"]
["PS21122","2019-01-08","Application Approved","Passed",1000,null,"Solar PV",9.61,"kW"]
["PT20855","2018-12-15","Application Submitted","Under Review",1000,null,"Solar PV",7.5,"kW"]
["PV20723","2019-01-24","Awaiting Signature Sheet","Not Started",1000,null,"Solar PV",10.5,"kW"]
["QM20746","2018-08-08","Invoice Submitted","Passed",1000,"2019-01-08","Solar PV",8.5399999999999991,"kW"]
["RD20853","2018-11-05","Invoice Submitted","Passed",1000,"2019-01-08","Solar PV",5.4,"kW"]
["RE21236","2019-01-03","Invoice Submitted","Passed",1000,"2019-01-24","Solar PV",3.835,"kW"]
["RE21244","2018-10-03","Invoice Submitted","Passed",1000,"2019-01-08","Solar PV",7.8,"kW"]
["RG21034","2018-12-13","Application Submitted","Under Review",3000,null,"Geothermal",4,"tons"]
["RG21770","2019-01-14","Invoice Submitted","Passed",700,"2019-01-24","Pellet Burning Stove",52000,"BTUs/hr"]
["RH21228","2019-01-10","Application Submitted","Not Started",1000,null,"Solar PV",9.9,"kW"]
["RJ20721","2019-01-22","Application Approved","Passed",1000,null,"Solar PV",12.685,"kW"]
["RJ21014","2018-10-17","Invoice Submitted","Passed",500,"2019-01-24","Solar Hot Water",1,"sqft"]
["RJ21102","2018-12-27","Invoice Submitted","Passed",1000,"2019-01-08","Solar PV",8.6999999999999993,"kW"]
["RK20817","2018-10-30","Invoice Submitted","Passed",1000,"2019-01-08","Solar PV",5.85,"kW"]
["RM21132","2019-01-07","Invoice Submitted","Passed",1000,"2019-01-24","Solar PV",7.13,"kW"]
["RR21108","2018-12-26","Invoice Submitted","Passed",1000,"2019-01-08","Solar PV",6.3,"kW"]
["RR21160","2019-01-09","Application Submitted","Under Review",3000,null,"Geothermal",3,"tons"]
["RR21209","2018-11-09","Invoice Submitted","Passed",1000,"2019-01-08","Solar PV",8.6999999999999993,"kW"]
["RS20776","2018-12-20","Application Submitted","Under Review",1000,null,"Solar PV",8.4,"kW"]
["RS20816","2018-12-20","Awaiting Signature Sheet","Not Started",1000,null,"Solar PV",10.8,"kW"]
["RS20866","2019-01-08","Invoice Submitted","Passed",1000,"2019-01-24","Solar PV",8.06,"kW"]
["RS21617","2019-01-17","Application Approved","Passed",700,null,"Pellet Burning Stove",40637,"BTUs/hr"]
["RT21161","2019-01-22","Application Approved","Passed",3000,null,"Geothermal",5,"tons"]
["RT21769","2018-12-11","Invoice Submitted","Passed",3000,"2019-01-08","Geothermal",4,"tons"]
["SA21044","2019-01-17","Application Approved","Passed",1000,null,"Solar PV",12.18,"kW"]
["SB21009","2018-12-31","Invoice Submitted","Passed",1000,"2019-01-24","Solar PV",8.5500000000000007,"kW"]
["SC20636","2018-12-10","Invoice Submitted","Passed",700,"2019-01-24","Pellet Burning Stove",50300,"BTUs/hr"]
["SC20902","2019-01-05","Invoice Submitted","Passed",1000,"2019-01-24","Solar PV",4.2,"kW"]
["SC21014","2018-12-19","Invoice Submitted","Passed",700,"2019-01-08","Pellet Burning Stove",38800,"BTUs/hr"]
["SC21060","2018-12-27","Invoice Submitted","Passed",1000,"2019-01-24","Solar PV",6.93,"kW"]
["SC21060","2019-01-11","Application Approved","Passed",1000,null,"Solar PV",4,"kW"]
["SC21146","2019-01-04","Invoice Submitted","Passed",1000,"2019-01-24","Solar PV",10.4,"kW"]
["SC21783","2019-01-11","Application Approved","Passed",3000,null,"Geothermal",4,"tons"]
["SC21813","2018-12-28","Invoice Submitted","Passed",700,"2019-01-08","Pellet Burning Stove",53000,"BTUs/hr"]
["SD20902","2018-12-31","Application Submitted","Under Review",1000,null,"Solar PV",5.9,"kW"]
["SD21122","2018-11-26","Invoice Submitted","Passed",1000,"2019-01-24","Solar PV",13,"kW"]
["SD21911","2018-12-19","Invoice Submitted","Passed",1000,"2019-01-08","Solar PV",5.31,"kW"]
["SE20759","2018-12-19","Invoice Submitted","Passed",1000,"2019-01-24","Solar PV",9.4499999999999993,"kW"]
["SE20878","2018-12-12","Invoice Submitted","Passed",1000,"2019-01-08","Solar PV",10.56,"kW"]
["SE21716","2018-10-18","Invoice Submitted","Passed",1000,"2019-01-08","Solar PV",6.2,"kW"]
["SE21719","2018-11-27","Application Approved","Passed",250,null,"Pellet Burning Stove",75000,"BTUs/hr"]
["SF20772","2018-12-27","Invoice Submitted","Passed",1000,"2019-01-24","Solar PV",7.01,"kW"]
["SH21661","2018-12-05","Invoice Submitted","Passed",1000,"2019-01-24","Solar PV",11.1,"kW"]
["SH21811","2019-01-03","Application on Standby","Not Started",1000,null,"Solar PV",12.2,"kW"]
["SJ20878","2018-09-21","Invoice Submitted","Passed",1000,"2019-01-08","Solar PV",6.3,"kW"]
["SJ20910","2019-01-09","Application Approved","Passed",1000,null,"Solar PV",9.3000000000000007,"kW"]
["SJ21014","2018-12-11","Invoice Submitted","Passed",3000,"2019-01-08","Geothermal",5,"tons"]
["SJ21152","2019-01-09","Application Submitted","Not Started",1000,null,"Solar PV",6.71,"kW"]
["SJ21154","2018-12-31","Invoice Submitted","Passed",700,"2019-01-24","Pellet Burning Stove",38400,"BTUs/hr"]
["SL21144","2019-01-23","Awaiting Signature Sheet","Not Started",1000,null,"Solar PV",4.2,"kW"]
["SL21409","2018-12-26","Invoice Submitted","Passed",1000,"2019-01-24","Solar PV",10.029999999999999,"kW"]
["SM20744","2019-01-04","Invoice Submitted","Passed",350,"2019-01-24","Pellet Burning Stove",55000,"BTUs/hr"]
["SM20815","2018-12-05","Invoice Submitted","Passed",1000,"2019-01-24","Solar PV",9.3000000000000007,"kW"]
["SM21122","2019-01-18","Application Approved","Passed",3000,null,"Geothermal",4,"tons"]
["SM21403","2019-01-04","Application Approved","Passed",1000,null,"Solar PV",1.89,"kW"]
["SM21409","2018-12-28","Invoice Submitted","Passed",350,"2019-01-08","Pellet Burning Stove",34000,"BTUs/hr"]
["SM21742","2018-12-11","Invoice Submitted","Passed",500,"2019-01-24","Geothermal Replacement",5,"tons"]
["SM21787","2019-01-07","Invoice Submitted","Passed",1000,"2019-01-24","Solar PV",8.6999999999999993,"kW"]
["SN21047","2019-01-04","Invoice Submitted","Passed",1000,"2019-01-24","Solar PV",8.6999999999999993,"kW"]
["SN21228","2019-01-17","Application Approved","Passed",1000,null,"Solar PV",5.8,"kW"]
["SO20707","2018-12-10","Invoice Submitted","Passed",1000,"2019-01-08","Solar PV",8.3699999999999992,"kW"]
["SR20736","2019-01-03","Invoice Submitted","Passed",3000,"2019-01-24","Geothermal",4,"tons"]
["SR21620","2019-01-14","Awaiting Signature Sheet","Not Started",1000,null,"Solar PV",8.64,"kW"]
["SR21911","2018-12-19","Invoice Submitted","Passed",1000,"2019-01-08","Solar PV",11.8,"kW"]
["SS20736","2019-01-07","Invoice Submitted","Passed",700,"2019-01-24","Pellet Burning Stove",50300,"BTUs/hr"]
["SS20759","2019-01-11","Application Approved","Passed",1000,null,"Solar PV",15.3,"kW"]
["SS20772","2018-12-14","Invoice Submitted","Passed",1000,"2019-01-24","Solar PV",5.0999999999999996,"kW"]
["SS20910","2019-01-08","Awaiting Signature Sheet","Not Started",1000,null,"Solar PV",8.58,"kW"]
["SS21014","2018-12-19","Application Submitted","Under Review",1000,null,"Solar PV",6.9,"kW"]
["SS21060","2018-10-29","Invoice Submitted","Passed",1000,"2019-01-08","Solar PV",11.78,"kW"]
["SS21154","2019-01-03","Application Approved","Passed",3000,null,"Geothermal",6,"tons"]
["SS21234","2018-11-09","Invoice Submitted","Passed",1000,"2019-01-24","Solar PV",2.4,"kW"]
["SS21666","2019-01-10","Application Submitted","Not Started",1000,null,"Solar PV",9.76,"kW"]
["SS21782","2018-12-31","Invoice Submitted","Passed",3000,"2019-01-24","Geothermal",3,"tons"]
["SV21015","2019-01-18","Application Approved","Passed",700,null,"Pellet Burning Stove",50300,"BTUs/hr"]
["SV21042","2019-01-22","Application Approved","Passed",1000,null,"Solar PV",9.6,"kW"]
["SW20814","2018-12-07","Invoice Submitted","Passed",1000,"2019-01-24","Solar PV",12.76,"kW"]
["SW21108","2018-12-28","Invoice Submitted","Passed",1000,"2019-01-24","Solar PV",6.3,"kW"]
["TA20724","2018-12-06","Invoice Submitted","Passed",1000,"2019-01-08","Solar PV",10.23,"kW"]
["TA20772","2018-12-12","Invoice Submitted","Passed",1000,"2019-01-24","Solar PV",7.62,"kW"]
["TC20850","2018-12-26","Invoice Submitted","Passed",1000,"2019-01-24","Solar PV",6.82,"kW"]
["TD21009","2019-01-17","Application Approved","Passed",1000,null,"Solar PV",6.3,"kW"]
["TD21620","2018-12-21","Application Approved","Passed",1000,null,"Solar PV",2.7,"kW"]
["TE20720","2018-12-14","Invoice Submitted","Passed",1000,"2019-01-08","Solar PV",13.2,"kW"]
["TG20855","2018-10-30","Invoice Submitted","Passed",1000,"2019-01-08","Solar PV",13,"kW"]
["TJ21401","2019-01-18","Application Approved","Passed",3000,null,"Geothermal",3,"tons"]
["TK21015","2019-01-10","Invoice Submitted","Passed",700,"2019-01-24","Pellet Burning Stove",50300,"BTUs/hr"]
["TL21619","2018-12-19","Invoice Submitted","Passed",1000,"2019-01-08","Solar PV",4.13,"kW"]
["TR20772","2019-01-15","Application Approved","Passed",1000,null,"Solar PV",13.5,"kW"]
["TR20817","2018-11-09","Invoice Submitted","Passed",1000,"2019-01-08","Solar PV",4.93,"kW"]
["TS21030","2018-12-20","Application Submitted","Not Started",1000,null,"Solar PV",3.78,"kW"]
["TS21222","2019-01-10","Application Approved","Passed",1000,null,"Solar PV",2,"kW"]
["TU21042","2018-09-12","Invoice Submitted","Passed",1000,"2019-01-08","Solar PV",13.2,"kW"]
["US21901","2018-12-26","Invoice Submitted","Passed",1000,"2019-01-08","Solar PV",8.5500000000000007,"kW"]
["VG20910","2018-10-25","Invoice Submitted","Passed",1000,"2019-01-08","Solar PV",8.4,"kW"]
["VL21403","2018-12-27","Application Submitted","Not Started",1000,null,"Solar PV",7.56,"kW"]
["VM20855","2018-12-18","Application Submitted","Under Review",1000,null,"Solar PV",10.199999999999999,"kW"]
["VZ20853","2018-11-27","Invoice Submitted","Passed",1000,"2019-01-24","Solar PV",10.8,"kW"]
["WA20602","2019-01-14","Application Approved","Passed",1000,null,"Solar PV",3,"kW"]
["WA21144","2018-12-28","Application Submitted","Not Started",1000,null,"Solar PV",11.16,"kW"]
["WA21229","2018-11-27","Invoice Submitted","Passed",1000,"2019-01-24","Solar PV",3.25,"kW"]
["WB20708","2018-10-29","Invoice Submitted","Passed",1000,"2019-01-08","Solar PV",10.4,"kW"]
["WB21220","2018-12-26","Application Approved","Passed",1000,null,"Solar PV",10.85,"kW"]
["WC21409","2018-10-01","Invoice Submitted","Passed",3000,"2019-01-08","Geothermal",10,"tons"]
["WC21737","2018-12-13","Invoice Submitted","Passed",1000,"2019-01-08","Solar PV",13.42,"kW"]
["WC21757","2018-11-05","Invoice Submitted","Passed",1000,"2019-01-08","Solar PV",15.4,"kW"]
["WC21804","2018-12-17","Invoice Submitted","Passed",700,"2019-01-08","Pellet Burning Stove",39428,"BTUs/hr"]
["WD20832","2018-11-20","Invoice Submitted","Passed",1000,"2019-01-24","Solar PV",17.100000000000001,"kW"]
["WD20853","2019-01-18","Application Approved","Passed",1000,null,"Solar PV",9,"kW"]
["WD20902","2018-12-07","Invoice Submitted","Passed",1000,"2019-01-24","Solar PV",8.1,"kW"]
["WE20650","2019-01-07","Invoice Submitted","Passed",700,"2019-01-24","Pellet Burning Stove",50300,"BTUs/hr"]
["WE20871","2019-01-10","Application Approved","Passed",1000,null,"Solar PV",11.4,"kW"]
["WE21144","2018-12-28","Application Approved","Passed",1000,null,"Solar PV",13.86,"kW"]
["WF21075","2018-12-06","Application Submitted","Under Review",1000,null,"Solar PV",15.19,"kW"]
["WG21012","2018-12-12","Application Submitted","Under Review",1000,null,"Solar PV",3.35,"kW"]
["WJ20716","2019-01-04","Awaiting Signature Sheet","Not Started",1000,null,"Solar PV",6.6,"kW"]
["WJ21093","2019-01-24","Awaiting Signature Sheet","Not Started",1000,null,"Solar PV",6.27,"kW"]
["WJ21210","2018-11-02","Application Submitted","Under Review",1000,null,"Solar PV",4.0199999999999996,"kW"]
["WJ21773","2019-01-08","Application Approved","Passed",1000,null,"Solar PV",10.67,"kW"]
["WK20602","2019-01-15","Application Approved","Passed",1000,null,"Solar PV",2.52,"kW"]
["WK21701","2018-12-21","Invoice Submitted","Passed",1000,"2019-01-08","Solar PV",11.4,"kW"]
["WL20744","2018-10-29","Invoice Submitted","Passed",1000,"2019-01-08","Solar PV",5,"kW"]
["WL21237","2019-01-22","Awaiting Signature Sheet","Not Started",1000,null,"Solar PV",10.199999999999999,"kW"]
["WM20855","2019-01-18","Application Approved","Passed",1000,null,"Solar PV",8.1,"kW"]
["WM21403","2018-11-01","Invoice Submitted","Passed",3000,"2019-01-08","Geothermal",6,"tons"]
["WM21757","2019-01-10","Invoice Submitted","Passed",700,"2019-01-24","Pellet Burning Stove",50300,"BTUs/hr"]
["WO20657","2019-01-04","Invoice Submitted","Passed",700,"2019-01-24","Pellet Burning Stove",53300,"BTUs/hr"]
["WQ20866","2018-12-27","Invoice Submitted","Passed",1000,"2019-01-24","Solar PV",8.3699999999999992,"kW"]
["WS21702","2019-01-08","Application Approved","Passed",1000,null,"Solar PV",11.88,"kW"]
["WT21074","2018-12-23","Invoice Submitted","Passed",3000,"2019-01-24","Geothermal",2,"tons"]
["WW21157","2019-01-22","Application Approved","Passed",1000,null,"Solar PV",11.2,"kW"]
["YA20854","2018-11-21","Application Submitted","Not Started",1000,null,"Solar PV",8.06,"kW"]
["YB21015","2018-10-11","Invoice Submitted","Passed",1000,"2019-01-08","Solar PV",20,"kW"]
["YC20854","2018-12-13","Invoice Submitted","Passed",1000,"2019-01-24","Solar PV",14.72,"kW"]
["YG20622","2018-12-21","Invoice Submitted","Passed",700,"2019-01-08","Pellet Burning Stove",50300,"BTUs/hr"]
["YJ21015","2019-01-04","Invoice Submitted","Passed",700,"2019-01-24","Pellet Burning Stove",44200,"BTUs/hr"]
["YL21207","2018-11-27","Invoice Submitted","Passed",1000,"2019-01-08","Solar PV",4.57,"kW"]
["ZB21403","2019-01-23","Awaiting Signature Sheet","Not Started",1000,null,"Solar PV",12.3,"kW"]
["ZJ20817","2019-01-15","Application Submitted","Not Started",1000,null,"Solar PV",5.4,"kW"]
["ZQ20852","2018-12-19","Invoice Submitted","Passed",1000,"2019-01-08","Solar PV",10.5,"kW"]
["ZR21120","2018-12-20","Invoice Submitted","Passed",3000,"2019-01-24","Geothermal",4,"tons"]
["SM20678","2019-01-25","Application Received","Not Started",700,null,"Pellet Burning Stove",61800,"BTUs/hr"]
["SA20904","2019-01-25","Application Received","Not Started",1000,null,"Solar PV",14.455,"kW"]

{"sheet":"Commercial Renewable Grants","index":2,"n_rows":18,"n_cols":10,"rows_kept":18,"cut":false,"hidden":false,"merged":[[0,0,0,8]]}
["OPEN AWARD STATUS REPORT - COMMERCIAL CLEAN ENERGY GRANT PROGRAM"]
[null,null,"Report Run","2018-03-19"]
["Name","Application Received Date","Award Status","MHT Review Status","Potential Award Amount","Last Invoice Received Date","Technology","Capacity","Capacity Units","Zip Code"]
["302 Dove LLC","2018-11-15","Commitment Letter Sent","Passed",900,null,"Geothermal",5,"tons",21403]
["Anemometer Loan Equipment Repair",null,"Not Applicable",null,0,"2016-04-27",null,null,"Not Applicable",21678]
["AOPF Stables, LLC","2018-11-07","Application Approved","Passed",4347,null,"Solar PV",72.45,"kW",20850]
["Atlantic Security for PV","2018-12-21","Application Submitted","Under Review",1155,null,"Solar PV",19.25,"kW",20855]
["Brentwood Development LLC for Commercial PV","2018-12-20","Invoice Submitted","Passed",5858.1,"2019-01-08","Solar PV",97.635000000000005,"kW",21673]
["Brentwood Land LLLP","2018-11-07","Commitment Letter Sent","Passed",3937.5,null,"Solar PV",131.25,"kW",21155]
["Choptank Corner LLC for PV","2019-01-15","Commitment Letter Sent","Passed",614.4,null,"Solar PV",10.24,"kW",20722]
["Goondiwindi LLC","2018-09-07","Commitment Letter Sent","Passed",2430,"2018-10-22","Solar PV",40.5,"kW",21050]
["Hans Asmussen & Sons, Inc","2018-10-09","Invoice Submitted","Passed",2138.4,"2019-01-24","Solar PV",35.6,"kW",20782]
["Hyattsville Mennonite Church (new in FY19)","2018-07-31","Commitment Letter Sent","Passed",1339.8,null,"Solar PV",22.3,"kW",20722]
["Mt. Pleasant Farm - Commerical PV","2016-06-27","Completion Package Rejected","Not Started",0,null,"Solar PV",21.6,"kW",21620]
["Ridgely Retreat LLC for PV","2018-12-19","Commitment Letter Sent","Passed",1344,null,"Solar PV",22.4,"kW",21401]
["Sandy Ridge Farm, Inc. for PV","2018-12-26","Invoice Submitted","Passed",990,"2019-01-24","Solar PV",16.5,"kW",21853]
["Whitaker Brothers Business Machine,Inc","2018-08-17","Commitment Letter Sent","Passed",2556,null,"Solar PV",42.6,"kW",21740]
["White Wind Properties for PV","2018-12-27","Invoice Submitted","Passed",3682.8,"2019-01-08","Solar PV",61.38,"kW",21613]

{"sheet":"Instructions","index":3,"n_rows":44,"n_cols":6,"rows_kept":44,"cut":false,"hidden":false,"merged":[[23,1,26,1],[23,2,26,2],[39,1,42,1],[39,2,42,2],[43,1,46,1],[43,2,46,2],[27,1,30,1],[27,2,30,2],[31,1,34,1],[31,2,34,2],[35,1,38,1],[35,2,38,2],[11,4,12,4],[11,5,12,5],[13,4,14,4],[13,5,14,5],[1,1,1,5],[3,1,5,2],[9,1,10,1],[9,2,10,2],[9,4,10,5],[15,1,18,1],[15,2,18,2],[19,1,22,1],[11,1,14,1],[11,2,14,2],[19,2,22,2]]}
[]
[null,"HOW TO USE THIS REPORT"]
[]
[null,"To locate your application status:\nResidential Applications are identified using the first letter of the last name, the first letter of the first name and the zip code.  As an example: John Smith living in zip code 12345 would be SJ12345).\nCommercial Operations are listed by the Award Name"]
[]
[]
[]
[null,"A description of each award status has been provided in the table below."]
[]
[null,"Award Status","Description - What does this award status mean?",null,"Maryland Energy Administration (MEA)\nContact Information"]
[]
[null,"Awaiting Signature Sheet\n(E-Applications Only)","The Maryland Energy Administration (MEA) has not received your E-Application Signature Sheet. Please print, fill out, and mail this sheet to MEA if you have not done so already. You should have received an email from a no-reply@egov.com email address after the submission of your online application containing your signature sheet.  Please check your inbox and/or spam folder for an email from no-reply@egov.com.  Contact MEA at cegp.mea@maryland.gov or (410) 537-4000 if you cannot locate this email.",null,"Email","cegp.mea@maryland.gov"]
[]
[null,null,null,null,"Phone","(410) 537-4000"]
[]
[null,"Application Received","E-Applications: The Maryland Energy Administration (MEA) has received your signature sheet associated with your e-application and your application is in line to be reviewed for eligibility.\nPaper Applications: MEA has received your application package and your application is in line to be reviewed."]
[]
[]
[]
[null,"Application Submitted\n(PV, Solar Hot Water, Geothermal, and Wind)","Your application has passed an Initial Review for program eligibility and has been submitted to the Maryland Energy Administration's (MEA) Historic Preservation Specialist for the Historic Preservation Review. All solar PV, solar hot water, geothermal, and wind Clean Energy Grant applications must be reviewed for any adverse impact created by the clean energy system installation to the property's historical significance, if any such significance is present. MEA cannot provide a Clean Energy Grant to any project which creates an adverse historical impact."]
[]
[]
[]
[null,"Application Accepted\n(Pellet/Wood Stoves Only)","Your application has passed the Initial Review for program eligibility."]
[]
[]
[]
[null,"Awaiting Second Review","Your application has been selected for, and is awaiting, a secondary quality control review.  "]
[]
[]
[]
[null,"Application Approved","Your application has been approved and is awaiting a signature from the Division Director of Programs."]
[]
[]
[]
[null,"Invoice Submitted","Your Clean Energy Grant has been invoiced for payment and is being submitted to the State finance office for payment processing. Please allow six (6) to eight (8) weeks from the date of invoice to receive your Clean Energy Grant."]
[]
[]
[]
[null,"Application on Standby","Your application is missing required information. You or your installation contractor should have received an email or letter from a Grants Administrator or Energy Program Manager requesting this missing information. If you or your contractor have not received a notification, please contact the Maryland Energy Administration (MEA) via email at cegp.mea@maryland.gov or via phone at (410) 537-4000."]
[]
[]
[]
[null,"Award Complete","Your Clean Energy Grant has been issued."]