{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["HOME","Applicant Info","Checklist","Terms & Conditions","Sequence of Events","ACTU","Inspection Report","General Info","Pictures"],"not_rendered":{"charts":0,"images":27,"macros":1,"external_links":1,"defined_names":153,"comments":1,"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":"HOME","index":0,"n_rows":43,"n_cols":8,"rows_kept":43,"cut":false,"hidden":false,"merged":[[28,9,28,12],[26,5,26,8],[34,5,34,8],[34,0,37,4],[41,0,44,2],[41,3,44,4],[42,5,42,7],[41,5,41,7],[38,0,39,8],[22,5,25,8],[27,5,31,8],[33,5,33,8],[32,5,32,8],[21,1,23,3],[21,5,21,8],[24,1,27,3],[28,1,30,3],[2,0,13,8],[0,0,1,1],[0,3,0,8],[1,3,1,8],[19,0,19,4],[16,1,18,2],[16,4,18,5],[16,7,18,8]]}
[null,null,null,"2021 v1 Advanced AC Tune-up Application"]
[null,null,null,"PNM Business Energy Efficiency Program"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Why improve energy efficiency?"]
[null,"Directly improves profitability by cutting operating costs",null,null,"Distinguishes your business as an energy efficiency steward in the community",null,null,"Qualifies your business for rebates that can cover portions of the upgrade cost"]
[]
[]
["Application Process",null,null,null,null,"Click on a quick link below:"]
[]
["1.","Work with a qualified A/C Tune-up Trade Ally to complete an Advanced A/C Tune-up. "]
[]
[]
["2.","Complete, sign and submit Final Application with all required documentation within 4 weeks of project completion."]
[]
[]
[]
["3.","The incentive check will be sent 4 to 6 weeks after approval of the Final Application."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Contact Our PNM Business Energy Efficiency Team"]
[]
[]
["320 Gold Avenue SW, Ste 500 Albuquerque, NM 87102",null,null,"(505) 938-9400 Main   (505) 938-9401 Fax",null,"energyefficiency@pnm.com"]
[null,null,null,null,null,"www.pnmenergyefficiency.com"]

{"sheet":"Applicant Info","index":1,"n_rows":66,"n_cols":17,"rows_kept":66,"cut":false,"hidden":false,"merged":[[41,4,41,5],[37,0,37,5],[39,6,39,7],[55,5,55,6],[57,7,57,10],[41,0,41,3],[40,4,40,10],[56,7,56,10],[43,4,43,5],[49,0,49,10],[48,0,48,10],[46,9,46,10],[59,7,59,10],[57,0,57,4],[37,6,37,10],[45,9,45,10],[45,0,45,4],[45,5,45,8],[55,0,55,4],[54,0,54,4],[56,0,56,4],[58,0,58,4],[54,7,54,10],[55,7,55,10],[44,0,44,10],[58,7,58,10],[43,8,43,10],[41,6,41,7],[0,9,0,10],[46,0,46,4],[5,7,5,8],[5,2,5,3],[46,5,46,8],[31,6,31,7],[13,0,13,5],[14,0,14,5],[11,6,11,8],[21,4,21,10],[21,0,21,3],[42,0,42,3],[42,4,42,10],[25,4,25,5],[40,0,40,3],[22,0,22,3],[59,0,59,4],[50,0,50,10],[9,0,9,10],[53,0,53,10],[51,0,51,10],[52,0,52,10],[28,6,28,8],[31,0,31,3],[31,4,31,5],[28,9,28,10],[26,0,26,10],[28,4,28,5],[16,0,16,5],[30,0,30,3],[30,4,30,10],[25,0,25,3],[22,4,22,5],[39,3,39,5],[27,4,27,10],[39,8,39,10],[38,0,38,5],[38,6,38,10],[27,0,27,3],[29,0,29,3],[29,4,29,10],[23,0,23,3],[36,4,36,10],[36,0,36,3],[32,0,32,10],[28,0,28,3],[17,0,17,5],[20,4,20,10],[19,3,19,5],[19,6,19,7],[19,8,19,10],[18,0,18,5],[18,6,18,10],[0,3,0,8],[3,0,3,5],[3,6,3,8],[25,8,25,10],[22,6,22,7],[24,0,24,3],[24,4,24,5],[24,6,24,7],[23,4,23,10],[15,6,15,10],[0,0,0,1],[11,0,11,5],[20,0,20,3],[15,0,15,5],[16,6,16,10],[17,6,17,10]]}
[null,null,null,"APPLICANT INFORMATION",null,null,null,null,null,"For office use only:"]
[null,null,null,null,null,null,null,null,null,"Application #","Revision #"]
[]
["Application Type:"]
[]
[null,null,"A/C Tune-up",null,null,null,null,"Final Application",null,"Date",null,null,null,null,null,{"$f":"IF(G6>0,\"Yes\",)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"New pre notification checkbox flag:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[]
["Customer Information*",null,null,null,null,null,null,null,null,null,null,null,null,null,"Multifacility checkbox flag:"]
[]
["PNM Account Number where measures installed ",null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[]
["Building Type*"]
[]
["Name of Company*",null,null,null,null,null,"Name Exactly as it Appears on Your Utility Bill*",null,null,null,null,null,"Business Type",null,"Tax Status",null,"State"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Assembly",null,"Corporation (Inc, PC, etc.)",null,"AL"]
["Name of Contact Person*",null,null,null,null,null,"Title*",null,null,null,null,null,"College/University",null,"Government Agency",null,"AK"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Grocery",null,"Individual",null,"AZ"]
["Telephone #*",null,null,null,null,null,"Fax #",null,null,null,null,null,"Health Care",null,"Partnership",null,"AR"]
["Email Address*",null,null,null,null,null,null,null,null,null,null,null,"Heavy Industry",null,"Exempt",null,"CA"]
["Address Where Measures Installed*",null,null,null,null,null,null,null,null,null,null,null,"Hotel/Motel",null,null,null,"CO"]
["City Where Measures Installed*",null,null,null,null,null,"State*",null,{"$f":"IF(E23=\"\",\"\",\"NM\")","v":""},"Zip*",null,null,"Light Industry",null,null,null,"CT"]
["Mailing Address*",null,null,null,null,null,null,null,null,null,null,null,"Miscellaneous",null,null,null,"DE"]
["City*",null,null,null,null,null,"State*",null,null,"Zip*",null,null,"Office",null,null,null,"FL"]
["Taxpayer ID Number (SSN/FEIN)*",null,null,null,null,null,"Tax Status*",null,null,null,null,null,"Restaurant",null,null,null,"GA"]
["Contractor Information",null,null,null,null,null,null,null,null,null,null,null,"Retail",null,null,null,"HI"]
["Contracting Company*",null,null,null,null,null,null,null,null,null,null,null,"School/K-12",null,null,null,"ID"]
["Contractor Name*",null,null,null,null,null,"Contractor Phone Number*",null,null,null,null,null,"Warehouse",null,null,null,"IL"]
["Contractor Email Address*",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IN"]
["Contractor Mailing Address*",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IA"]
["City*",null,null,null,null,null,"State*",null,null,"Zip*",null,null,null,null,null,null,"KS"]
["Third Party Payment Release",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KY"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LA"]
[null,null,"I request that the incentive check be sent to the third party below",null,null,null,null,"Check here if the third party payee is the contractor",null,null,null,null,null,null,null,null,"ME"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MD"]
["Name of Third Party*",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MA"]
["Name of Third Party Contact Person*",null,null,null,null,null,"Title*",null,null,null,null,null,null,null,null,null,"MI"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MN"]
["Third Party Phone #*",null,null,null,null,null,"Fax #",null,null,null,null,null,null,null,null,null,"MS"]
["Third Party Mailing Address*",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MO"]
["Third Party City*",null,null,null,null,null,"State*",null,null,"Zip*",null,null,null,null,null,null,"MT"]
["Third Party Email Address*",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NE"]
["Third Party Taxpayer ID # (SSN/FEIN)*",null,null,null,null,null,"Tax Status*",null,null,null,null,null,null,null,null,null,"NV"]
["Incentive Summary",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NH"]
["Total Incentive Requested",null,null,null,null,"Total Project Cost  PRE-TAX * REQUIRED *",null,null,null,"Project Completion Date",null,null,null,null,null,null,"NJ"]
[{"$f":"MIN(ACTU!I29, F47)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NY"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ND"]
["AGREEMENT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OH"]
["I understand that in the event funds are reserved based on a pre-notification, the payment of incentives will be based upon the Final Application and program terms and conditions, and that the PNM Business Energy Efficiency program is subject to change or cancellation at any time and without notice. PNM is not responsible for any lost, late, stolen, ineligible, illegible, misdirected or postage-due mail. All completed submissions become the property of PNM and will not be returned. PNM makes no guarantees about the availability of products or rebate forms. By participating in the PNM Business Energy Efficiency program, customers agree to waive any claims and release PNM from any liability for damages of any kind. Rebates are funded by a charge on PNM electric customer bills.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OK"]
["I have read and understand the program requirements, measure specifications, and Terms & Conditions set forth in this application and agree to abide by those requirements. Furthermore, I concur that I must meet all eligibility criteria in order to be paid under this program.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OR"]
["As an eligible customer, I verify that the signature below is my own and that the information is correct. I am requesting consideration for participation under this program. By signing this agreement I attest that I understand and agree to abide by all Program terms and conditions.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PA"]
["Customer Signature (PNM Customer)",null,null,null,null,null,null,"Third Party Signature",null,null,null,null,null,null,null,null,"RI"]
[null,null,null,null,null,"Please sign by hand",null,null,null,null,null,null,null,null,null,null,"SC"]
["Print Customer Name",null,null,null,null,null,null,"Print Third Party Name",null,null,null,null,null,null,null,null,"SD"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TN"]
["Date",null,null,null,null,null,null,"Date",null,null,null,null,null,null,null,null,"TX"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WI"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WV"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WY"]

{"sheet":"Checklist","index":2,"n_rows":1,"n_cols":4,"rows_kept":1,"cut":false,"hidden":false,"merged":[[0,3,0,6]]}
[null,null,null,"APPLICATION CHECKLIST"]

{"sheet":"Terms & Conditions","index":3,"n_rows":1,"n_cols":4,"rows_kept":1,"cut":false,"hidden":false,"merged":[[0,3,0,6]]}
[null,null,null,"TERMS & CONDITIONS"]

{"sheet":"Sequence of Events","index":4,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[[1,1,1,9]]}
[]
[null,"Advanced AC Tune-up Program Sequence of Events"]

{"sheet":"ACTU","index":5,"n_rows":111,"n_cols":13,"rows_kept":111,"cut":false,"hidden":false,"merged":[[31,0,31,1],[32,0,32,1],[33,0,33,1],[34,0,34,1],[35,0,35,1],[30,0,30,1],[19,3,19,4],[20,3,20,4],[21,3,21,4],[22,3,22,4],[23,3,23,4],[24,3,24,4],[25,3,25,4],[26,3,26,4],[27,3,27,4],[28,0,28,7],[29,0,29,8],[18,3,18,4],[8,1,8,2],[8,4,8,5],[8,7,8,8],[9,1,9,2],[9,4,9,5],[12,3,12,4],[13,3,13,4],[14,3,14,4],[15,3,15,4],[16,3,16,4],[17,3,17,4],[6,1,6,2],[6,4,6,5],[6,7,6,8],[7,1,7,2],[7,4,7,5],[7,7,7,8],[5,1,5,2],[5,4,5,5],[5,7,5,8],[0,1,0,7],[2,1,2,2],[2,4,2,5],[2,7,2,8],[3,1,3,2],[3,4,3,5],[3,7,3,8],[4,1,4,2],[4,4,4,5],[4,7,4,8]]}
[null,"ADVANCED AC TUNE UP INCENTIVES",null,null,null,null,null,null,null,"Zip",null,"System Size","Incentive"]
[null,null,null,null,null,null,null,null,null,87001,null,2.5,90]
["System Size, Tons","Incentive",null,"System Size, Tons","Incentive",null,"System Size, Tons","Incentive",null,87002,null,3,110]
[{"$f":"L2","v":2.5},{"$f":"M2","v":90},0,{"$f":"L9","v":9},{"$f":"M9","v":275},0,{"$f":"L16","v":25},{"$f":"M16","v":650},0,87004,null,4,140]
[{"$f":"L3","v":3},110,0,{"$f":"L10","v":10},300,0,{"$f":"L17","v":30},750,0,87006,null,5,170]
[4,140,0,11,315,0,35,825,0,87008,null,6,200]
[5,170,0,12.5,340,0,40,900,0,87010,null,7.5,240]
[6,200,0,15,400,0,50,1000,0,87022,null,8,255]
[7.5,240,0,17.5,450,0,60,1100,0,87023,null,9,275]
[8,255,0,20,490,0,null,null,null,87026,null,10,300]
[null,null,null,null,null,null,null,null,null,87031,null,11,315]
["All fields are required",null,null,null,null,null,null,null,null,87041,null,12.5,340]
["Installation Zip Code","Unit Age, Years (Must be over 3 years old)","Equipment Description (Make/Model)","Equipment Serial #\n(One serial # per line)",null,"Quantity","A/C Unit Size","Incentive/Unit","Total Rebate",87042,null,15,400]
[null,null,null,null,null,null,null,{"$f":"IF($D14=\"\",\"\",VLOOKUP($G14,$L$2:$M$21,2))","v":""},{"$f":"IF($D14=\"\",\"\",$H14*$F14)","v":""},87043,null,17.5,450]
[null,null,null,null,null,null,null,"",{"$f":"IF($D15=\"\",\"\",$H15*$F15)","v":""},87047,null,20,490]
[null,null,null,null,null,null,null,"","",87048,null,25,650]
[null,null,null,null,null,null,null,"","",87052,null,30,750]
[null,null,null,null,null,null,null,"","",87059,null,35,825]
[null,null,null,null,null,null,null,"","",87060,null,40,900]
[null,null,null,null,null,null,null,"","",87068,null,50,1000]
[null,null,null,null,null,null,null,"","",87072,null,60,1100]
[null,null,null,null,null,null,null,"","",87083]
[null,null,null,null,null,null,null,"","",87101]
[null,null,null,null,null,null,null,"","",87102]
[null,null,null,null,null,null,null,"","",87103]
[null,null,null,null,null,null,null,"","",87104]
[null,null,null,null,null,null,null,"","",87105]
[null,null,null,null,null,null,null,"","",87106]
[1,null,null,null,null,null,null,null,{"$f":"SUM(I14:I28)","v":0},87107]
["INSTRUCTIONS TO COMPLETE THIS WORKSHEET:",null,null,null,null,null,null,null,null,87108]
["Equipment Model:",null,"Enter the equipment model as shown on the invoice; provide the specification sheet(s) that accompany the model",null,null,null,null,null,null,87109]
["Tons:",null,"Enter the equipment tonnage from the AHRI or manufacturer specification sheet",null,null,null,null,null,null,87110]
["Efficiency Rating:",null,"Enter the equipment efficiency rating from the AHRI or manufacturer specification sheet; for chillers, kW/ton = 12/IPLV EER",null,null,null,null,null,null,87111]
["Quantity:",null,"Enter the number of units that fit this size and efficiency rating",null,null,null,null,null,null,87112]
["Equipment Type:",null,"Enter the equipment type from the drop-down menu",null,null,null,null,null,null,87113]
["Size Category:",null,"Enter the equipment size from the drop-down menu",null,null,null,null,null,null,87114]
[null,null,null,null,null,null,null,null,null,87115]
["Advanced AC Tune-up Specifications",null,null,null,null,null,null,null,null,87116]
[null,null,null,null,null,null,null,null,null,87119]
[null,null,null,null,null,null,null,null,null,87120]
[null,null,null,null,null,null,null,null,null,87121]
[null,null,null,null,null,null,null,null,null,87122]
[null,null,null,null,null,null,null,null,null,87123]
[null,null,null,null,null,null,null,null,null,87124]
[null,null,null,null,null,null,null,null,null,87125]
[null,null,null,null,null,null,null,null,null,87131]
[null,null,null,null,null,null,null,null,null,87144]
[null,null,null,null,null,null,null,null,null,87151]
[null,null,null,null,null,null,null,null,null,87153]
[null,null,null,null,null,null,null,null,null,87154]
[null,null,null,null,null,null,null,null,null,87158]
[null,null,null,null,null,null,null,null,null,87174]
[null,null,null,null,null,null,null,null,null,87176]
[null,null,null,null,null,null,null,null,null,87181]
[null,null,null,null,null,null,null,null,null,87184]
[null,null,null,null,null,null,null,null,null,87185]
[null,null,null,null,null,null,null,null,null,87187]
[null,null,null,null,null,null,null,null,null,87190]
[null,null,null,null,null,null,null,null,null,87191]
[null,null,null,null,null,null,null,null,null,87192]
[null,null,null,null,null,null,null,null,null,87193]
[null,null,null,null,null,null,null,null,null,87194]
[null,null,null,null,null,null,null,null,null,87195]
[null,null,null,null,null,null,null,null,null,87196]
[null,null,null,null,null,null,null,null,null,87197]
[null,null,null,null,null,null,null,null,null,87198]
[null,null,null,null,null,null,null,null,null,87199]
[null,null,null,null,null,null,null,null,null,87301]
[null,null,null,null,null,null,null,null,null,87416]
[null,null,null,null,null,null,null,null,null,87501]
[null,null,null,null,null,null,null,null,null,87502]
[null,null,null,null,null,null,null,null,null,87503]
[null,null,null,null,null,null,null,null,null,87504]
[null,null,null,null,null,null,null,null,null,87505]
[null,null,null,null,null,null,null,null,null,87506]
[null,null,null,null,null,null,null,null,null,87507]
[null,null,null,null,null,null,null,null,null,87508]
[null,null,null,null,null,null,null,null,null,87509]
[null,null,null,null,null,null,null,null,null,87540]
[null,null,null,null,null,null,null,null,null,87574]
[null,null,null,null,null,null,null,null,null,87592]
[null,null,null,null,null,null,null,null,null,87594]
[null,null,null,null,null,null,null,null,null,87701]
[null,null,null,null,null,null,null,null,null,87731]
[null,null,null,null,null,null,null,null,null,87935]
[null,null,null,null,null,null,null,null,null,88022]
[null,null,null,null,null,null,null,null,null,88023]
[null,null,null,null,null,null,null,null,null,88025]
[null,null,null,null,null,null,null,null,null,88026]
[null,null,null,null,null,null,null,null,null,88028]
[null,null,null,null,null,null,null,null,null,88030]
[null,null,null,null,null,null,null,null,null,88031]
[null,null,null,null,null,null,null,null,null,88034]
[null,null,null,null,null,null,null,null,null,88036]
[null,null,null,null,null,null,null,null,null,88038]
[null,null,null,null,null,null,null,null,null,88041]
[null,null,null,null,null,null,null,null,null,88043]
[null,null,null,null,null,null,null,null,null,88045]
[null,null,null,null,null,null,null,null,null,88049]
[null,null,null,null,null,null,null,null,null,88051]
[null,null,null,null,null,null,null,null,null,88053]
[null,null,null,null,null,null,null,null,null,88061]
[null,null,null,null,null,null,null,null,null,88062]
[null,null,null,null,null,null,null,null,null,88065]
[null,null,null,null,null,null,null,null,null,88310]
[null,null,null,null,null,null,null,null,null,88311]
[null,null,null,null,null,null,null,null,null,88345]
[null,null,null,null,null,null,null,null,null,88346]
[null,null,null,null,null,null,null,null,null,88352]
[null,null,null,null,null,null,null,null,null,88355]
[null,null,null,null,null,null,null,null,null,88415]

{"sheet":"Inspection Report","index":6,"n_rows":55,"n_cols":20,"rows_kept":55,"cut":false,"hidden":true,"merged":[[13,0,15,23],[8,5,8,21],[9,5,9,21],[10,5,10,11],[19,0,19,23],[30,0,30,23],[31,0,31,23],[32,0,32,23],[24,0,24,23],[18,0,18,23],[20,0,20,23],[21,0,21,23],[22,0,22,23],[23,0,23,23],[25,0,25,23],[26,0,26,23],[27,0,27,23],[28,0,28,23],[29,0,29,23],[5,4,5,7],[5,19,5,23],[7,5,7,21],[44,0,44,13],[44,14,44,16],[44,17,44,23],[42,0,42,13],[42,14,42,16],[42,17,42,23],[43,0,43,13],[43,14,43,16],[43,17,43,23],[40,0,40,13],[40,14,40,16],[40,17,40,23],[41,0,41,13],[0,0,3,18],[0,19,0,23],[1,19,3,23],[4,4,4,7],[4,20,4,23],[46,0,46,13],[46,14,46,16],[46,17,46,23],[45,0,45,13],[45,14,45,16],[45,17,45,23],[41,14,41,16],[41,17,41,23],[38,0,38,13],[38,14,38,16],[38,17,38,23],[39,0,39,13],[39,14,39,16],[39,17,39,23],[47,0,47,13],[47,14,47,16],[47,17,47,23],[48,0,48,13],[48,14,48,16],[48,17,48,23],[49,0,49,13],[49,14,49,16],[49,17,49,23],[50,0,50,13],[50,14,50,16],[50,17,50,23],[51,0,51,13],[51,14,51,16],[51,17,51,23],[53,14,53,20],[54,14,54,20]]}
["     AC Tune-up Post Inspection Form",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Application No."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Applicant Info'!J3","v":0}]
[]
[]
["Date Assigned:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Inspection Date:"]
["Date Due:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Inspector:"]
[]
["Name of Company:",null,null,null,null,{"$f":"'Applicant Info'!A17","v":0}]
["Site Address:",null,null,null,null,{"$f":"'Applicant Info'!E22&\", \"&'Applicant Info'!E23&\", \"&'Applicant Info'!I23&\" \"&'Applicant Info'!K23","v":", ,  "}]
["Contact Name:",null,null,null,null,{"$f":"'Applicant Info'!A19","v":0}]
["Phone Number:",null,null,null,null,{"$f":"'Applicant Info'!D20","v":0}]
[]
["Project Description:"]
[{"$f":"IF('General Info'!C8>0,\"The facility had a total of \" & TEXT('General Info'!C8,0) & \" rooftop unit(s). There were: \" & IF('General Info'!C10>0,\"(\"&TEXT('General Info'!C10,0)& \") 2.5-ton unit(s)\",) & IF('General Info'!C11>0,\", (\"&TEXT('General Info'!C11,0)& \") 3-ton unit(s)\",) & IF('General Info'!C12>0,\"(\"&TEXT('General Info'!C12,0)& \") 4-ton unit(s)\",) & IF('General Info'!C13>0,\", (\"&TEXT('General Info'!C13,0)& \") 5-ton unit(s)\",) & IF('General Info'!C14>0,\", (\"&TEXT('General Info'!C14,0)& \") 6-ton unit(s)\",) & IF('General Info'!C15>0,\", (\"&TEXT('General Info'!C15,0)& \") 7.5-ton unit(s)\",) & IF('General Info'!C16>0,\", (\"&TEXT('General Info'!C16,0)& \") 8-ton unit(s)\",) & IF('General Info'!C17>0,\", (\"&TEXT('General Info'!C17,0)& \") 9-ton unit(s)\",) & IF('General Info'!C18>0,\", (\"&TEXT('General Info'!C18,0)& \") 10-ton unit(s)\",) & IF('General Info'!C19>0,\", (\"&TEXT('General Info'!C19,0)& \") 11-ton unit(s)\",) & IF('General Info'!F10>0,\", (\"&TEXT('General Info'!F10,0)& \") 12.5-ton unit(s)\",) & IF('General Info'!F11>0,\", (\"&TEXT('General Info'!F11,0)& \") 15-ton unit(s)\",) & IF('General Info'!F12>0,\", (\"&TEXT('General Info'!F12,0)& \") 17.5-ton unit(s)\",) & IF('General Info'!F13>0,\", (\"&TEXT('General Info'!F13,0)& \") 20-ton unit(s)\",) & IF('General Info'!F14>0,\", (\"&TEXT('General Info'!F14,0)& \") 25-ton unit(s)\",) & IF('General Info'!F15>0,\", (\"&TEXT('General Info'!F15,0)& \") 30-ton unit(s)\",) & IF('General Info'!F16>0,\", (\"&TEXT('General Info'!F16,0)& \") 35-ton unit(s)\",) & IF('General Info'!F17>0,\", (\"&TEXT('General Info'!F17,0)& \") 40-ton unit(s)\",) &IF('General Info'!F18>0,\", (\"&TEXT('General Info'!F18,0)& \") 50-ton unit(s)\",) & IF('General Info'!F19>0,\", (\"&TEXT('General Info'!F19,0)& \") 60-ton unit(s)\",) & \".\",\"\")","v":""}]
[]
[]
[]
["Inspection Results:"]
[{"$f":"_xlfn.IFNA(TEXT('General Info'!B26,0) & \" Model: \" & TEXT('General Info'!C26,0) & \",  Serial Number: \" & TEXT('General Info'!D26,0) & \". Pre-test diagnosis was to \" & TEXT('General Info'!G26,0) & \" because \" & TEXT('General Info'!H26,0) & \" Post-test diagnosis was \" & TEXT('General Info'!I26,0) & \" due to \" & TEXT('General Info'!J26,0) & _xlfn.IFS('General Info'!K26=\"Yes\",\" A refrigerant charge was added.\", 'General Info'!K26=\"No\", \" Charge addition not necessary.\") & _xlfn.IFS('General Info'!L26=\"Passed\",\" Unit passed.\", 'General Info'!L26=\"Rejected\", \" Unit was rejected due to not meeting minimum requirements.(See notes)\"),\"\")","v":""}]
[{"$f":"_xlfn.IFNA(TEXT('General Info'!B27,0) & \" Model: \" & TEXT('General Info'!C27,0) & \",  Serial Number: \" & TEXT('General Info'!D27,0) & \". Pre-test diagnosis was to \" & TEXT('General Info'!G27,0) & \" because \" & TEXT('General Info'!H27,0) & \" Post-test diagnosis was \" & TEXT('General Info'!I27,0) & \" due to \" & TEXT('General Info'!J27,0) & _xlfn.IFS('General Info'!K27=\"Yes\",\" A refrigerant charge was added.\", 'General Info'!K27=\"No\", \" Charge addition not necessary.\") & _xlfn.IFS('General Info'!L27=\"Passed\",\" Unit passed.\", 'General Info'!L27=\"Rejected\", \" Unit was rejected due to not meeting minimum requirements.(See notes)\"),\"\")","v":""}]
[{"$f":"_xlfn.IFNA(TEXT('General Info'!B28,0) & \" Model: \" & TEXT('General Info'!C28,0) & \",  Serial Number: \" & TEXT('General Info'!D28,0) & \". Pre-test diagnosis was to \" & TEXT('General Info'!G28,0) & \" because \" & TEXT('General Info'!H28,0) & \" Post-test diagnosis was \" & TEXT('General Info'!I28,0) & \" due to \" & TEXT('General Info'!J28,0) & _xlfn.IFS('General Info'!K28=\"Yes\",\" A refrigerant charge was added.\", 'General Info'!K28=\"No\", \" Charge addition not necessary.\") & _xlfn.IFS('General Info'!L28=\"Passed\",\" Unit passed.\", 'General Info'!L28=\"Rejected\", \" Unit was rejected due to not meeting minimum requirements.(See notes)\"),\"\")","v":""}]
[{"$f":"_xlfn.IFNA(TEXT('General Info'!B29,0) & \" Model: \" & TEXT('General Info'!C29,0) & \",  Serial Number: \" & TEXT('General Info'!D29,0) & \". Pre-test diagnosis was to \" & TEXT('General Info'!G29,0) & \" because \" & TEXT('General Info'!H29,0) & \" Post-test diagnosis was \" & TEXT('General Info'!I29,0) & \" due to \" & TEXT('General Info'!J29,0) & _xlfn.IFS('General Info'!K29=\"Yes\",\" A refrigerant charge was added.\", 'General Info'!K29=\"No\", \" Charge addition not necessary.\") & _xlfn.IFS('General Info'!L29=\"Passed\",\" Unit passed.\", 'General Info'!L29=\"Rejected\", \" Unit was rejected due to not meeting minimum requirements.(See notes)\"),\"\")","v":""}]
[{"$f":"_xlfn.IFNA(TEXT('General Info'!B30,0) & \" Model: \" & TEXT('General Info'!C30,0) & \",  Serial Number: \" & TEXT('General Info'!D30,0) & \". Pre-test diagnosis was to \" & TEXT('General Info'!G30,0) & \" because \" & TEXT('General Info'!H30,0) & \" Post-test diagnosis was \" & TEXT('General Info'!I30,0) & \" due to \" & TEXT('General Info'!J30,0) & _xlfn.IFS('General Info'!K30=\"Yes\",\" A refrigerant charge was added.\", 'General Info'!K30=\"No\", \" Charge addition not necessary.\") & _xlfn.IFS('General Info'!L30=\"Passed\",\" Unit passed.\", 'General Info'!L30=\"Rejected\", \" Unit was rejected due to not meeting minimum requirements.(See notes)\"),\"\")","v":""}]
[{"$f":"_xlfn.IFNA(TEXT('General Info'!B31,0) & \" Model: \" & TEXT('General Info'!C31,0) & \",  Serial Number: \" & TEXT('General Info'!D31,0) & \". Pre-test diagnosis was to \" & TEXT('General Info'!G31,0) & \" because \" & TEXT('General Info'!H31,0) & \" Post-test diagnosis was \" & TEXT('General Info'!I31,0) & \" due to \" & TEXT('General Info'!J31,0) & _xlfn.IFS('General Info'!K31=\"Yes\",\" A refrigerant charge was added.\", 'General Info'!K31=\"No\", \" Charge addition not necessary.\") & _xlfn.IFS('General Info'!L31=\"Passed\",\" Unit passed.\", 'General Info'!L31=\"Rejected\", \" Unit was rejected due to not meeting minimum requirements.(See notes)\"),\"\")","v":""}]
[{"$f":"_xlfn.IFNA(TEXT('General Info'!B32,0) & \" Model: \" & TEXT('General Info'!C32,0) & \",  Serial Number: \" & TEXT('General Info'!D32,0) & \". Pre-test diagnosis was to \" & TEXT('General Info'!G32,0) & \" because \" & TEXT('General Info'!H32,0) & \" Post-test diagnosis was \" & TEXT('General Info'!I32,0) & \" due to \" & TEXT('General Info'!J32,0) & _xlfn.IFS('General Info'!K32=\"Yes\",\" A refrigerant charge was added.\", 'General Info'!K32=\"No\", \" Charge addition not necessary.\") & _xlfn.IFS('General Info'!L32=\"Passed\",\" Unit passed.\", 'General Info'!L32=\"Rejected\", \" Unit was rejected due to not meeting minimum requirements.(See notes)\"),\"\")","v":""}]
[{"$f":"_xlfn.IFNA(TEXT('General Info'!B33,0) & \" Model: \" & TEXT('General Info'!C33,0) & \",  Serial Number: \" & TEXT('General Info'!D33,0) & \". Pre-test diagnosis was to \" & TEXT('General Info'!G33,0) & \" because \" & TEXT('General Info'!H33,0) & \" Post-test diagnosis was \" & TEXT('General Info'!I33,0) & \" due to \" & TEXT('General Info'!J33,0) & _xlfn.IFS('General Info'!K33=\"Yes\",\" A refrigerant charge was added.\", 'General Info'!K33=\"No\", \" Charge addition not necessary.\") & _xlfn.IFS('General Info'!L33=\"Passed\",\" Unit passed.\", 'General Info'!L33=\"Rejected\", \" Unit was rejected due to not meeting minimum requirements.(See notes)\"),\"\")","v":""}]
[{"$f":"_xlfn.IFNA(TEXT('General Info'!B34,0) & \" Model: \" & TEXT('General Info'!C34,0) & \",  Serial Number: \" & TEXT('General Info'!D34,0) & \". Pre-test diagnosis was to \" & TEXT('General Info'!G34,0) & \" because \" & TEXT('General Info'!H34,0) & \" Post-test diagnosis was \" & TEXT('General Info'!I34,0) & \" due to \" & TEXT('General Info'!J34,0) & _xlfn.IFS('General Info'!K34=\"Yes\",\" A refrigerant charge was added.\", 'General Info'!K34=\"No\", \" Charge addition not necessary.\") & _xlfn.IFS('General Info'!L34=\"Passed\",\" Unit passed.\", 'General Info'!L34=\"Rejected\", \" Unit was rejected due to not meeting minimum requirements.(See notes)\"),\"\")","v":""}]
[{"$f":"_xlfn.IFNA(TEXT('General Info'!B35,0) & \" Model: \" & TEXT('General Info'!C35,0) & \",  Serial Number: \" & TEXT('General Info'!D35,0) & \". Pre-test diagnosis was to \" & TEXT('General Info'!G35,0) & \" because \" & TEXT('General Info'!H35,0) & \" Post-test diagnosis was \" & TEXT('General Info'!I35,0) & \" due to \" & TEXT('General Info'!J35,0) & _xlfn.IFS('General Info'!K35=\"Yes\",\" A refrigerant charge was added.\", 'General Info'!K35=\"No\", \" Charge addition not necessary.\") & _xlfn.IFS('General Info'!L35=\"Passed\",\" Unit passed.\", 'General Info'!L35=\"Rejected\", \" Unit was rejected due to not meeting minimum requirements.(See notes)\"),\"\")","v":""}]
[{"$f":"_xlfn.IFNA(TEXT('General Info'!B36,0) & \" Model: \" & TEXT('General Info'!C36,0) & \",  Serial Number: \" & TEXT('General Info'!D36,0) & \". Pre-test diagnosis was to \" & TEXT('General Info'!G36,0) & \" because \" & TEXT('General Info'!H36,0) & \" Post-test diagnosis was \" & TEXT('General Info'!I36,0) & \" due to \" & TEXT('General Info'!J36,0) & _xlfn.IFS('General Info'!K36=\"Yes\",\" A refrigerant charge was added.\", 'General Info'!K36=\"No\", \" Charge addition not necessary.\") & _xlfn.IFS('General Info'!L36=\"Passed\",\" Unit passed.\", 'General Info'!L36=\"Rejected\", \" Unit was rejected due to not meeting minimum requirements.(See notes)\"),\"\")","v":""}]
[{"$f":"_xlfn.IFNA(TEXT('General Info'!B37,0) & \" Model: \" & TEXT('General Info'!C37,0) & \",  Serial Number: \" & TEXT('General Info'!D37,0) & \". Pre-test diagnosis was to \" & TEXT('General Info'!G37,0) & \" because \" & TEXT('General Info'!H37,0) & \" Post-test diagnosis was \" & TEXT('General Info'!I37,0) & \" due to \" & TEXT('General Info'!J37,0) & _xlfn.IFS('General Info'!K37=\"Yes\",\" A refrigerant charge was added.\", 'General Info'!K37=\"No\", \" Charge addition not necessary.\") & _xlfn.IFS('General Info'!L37=\"Passed\",\" Unit passed.\", 'General Info'!L37=\"Rejected\", \" Unit was rejected due to not meeting minimum requirements.(See notes)\"),\"\")","v":""}]
[{"$f":"_xlfn.IFNA(TEXT('General Info'!B38,0) & \" Model: \" & TEXT('General Info'!C38,0) & \",  Serial Number: \" & TEXT('General Info'!D38,0) & \". Pre-test diagnosis was to \" & TEXT('General Info'!G38,0) & \" because \" & TEXT('General Info'!H38,0) & \" Post-test diagnosis was \" & TEXT('General Info'!I38,0) & \" due to \" & TEXT('General Info'!J38,0) & _xlfn.IFS('General Info'!K38=\"Yes\",\" A refrigerant charge was added.\", 'General Info'!K38=\"No\", \" Charge addition not necessary.\") & _xlfn.IFS('General Info'!L38=\"Passed\",\" Unit passed.\", 'General Info'!L38=\"Rejected\", \" Unit was rejected due to not meeting minimum requirements.(See notes)\"),\"\")","v":""}]
[{"$f":"_xlfn.IFNA(TEXT('General Info'!B39,0) & \" Model: \" & TEXT('General Info'!C39,0) & \",  Serial Number: \" & TEXT('General Info'!D39,0) & \". Pre-test diagnosis was to \" & TEXT('General Info'!G39,0) & \" because \" & TEXT('General Info'!H39,0) & \" Post-test diagnosis was \" & TEXT('General Info'!I39,0) & \" due to \" & TEXT('General Info'!J39,0) & _xlfn.IFS('General Info'!K39=\"Yes\",\" A refrigerant charge was added.\", 'General Info'!K39=\"No\", \" Charge addition not necessary.\") & _xlfn.IFS('General Info'!L39=\"Passed\",\" Unit passed.\", 'General Info'!L39=\"Rejected\", \" Unit was rejected due to not meeting minimum requirements.(See notes)\"),\"\")","v":""}]
[{"$f":"_xlfn.IFNA(TEXT('General Info'!B40,0) & \" Model: \" & TEXT('General Info'!C40,0) & \",  Serial Number: \" & TEXT('General Info'!D40,0) & \". Pre-test diagnosis was to \" & TEXT('General Info'!G40,0) & \" because \" & TEXT('General Info'!H40,0) & \" Post-test diagnosis was \" & TEXT('General Info'!I40,0) & \" due to \" & TEXT('General Info'!J40,0) & _xlfn.IFS('General Info'!K40=\"Yes\",\" A refrigerant charge was added.\", 'General Info'!K40=\"No\", \" Charge addition not necessary.\") & _xlfn.IFS('General Info'!L40=\"Passed\",\" Unit passed.\", 'General Info'!L40=\"Rejected\", \" Unit was rejected due to not meeting minimum requirements.(See notes)\"),\"\")","v":""}]
["Comments"]
[]
[]
[]
["Recommended Incentive:"]
["Measure",null,null,null,null,null,null,null,null,null,null,null,null,null,"Quantity",null,null,"Incentive"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Requested Incentive Amount Based on Application:",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Applicant Info'!A50","v":0}]
["Recommended Incentive Amount Based on Inspection:",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R40:X52)","v":0}]

{"sheet":"General Info","index":7,"n_rows":40,"n_cols":32,"rows_kept":40,"cut":false,"hidden":true,"merged":[[10,2,10,3],[1,1,1,10],[2,1,2,10],[5,2,5,3],[5,5,5,6],[6,2,6,3],[6,5,6,6],[7,2,7,3],[7,5,7,6],[8,2,8,3],[8,5,8,6],[9,2,9,3],[17,2,17,3],[18,2,18,3],[21,2,21,3],[11,2,11,3],[12,2,12,3],[13,2,13,3],[14,2,14,3],[15,2,15,3],[16,2,16,3]]}
[]
[null,"Advanced AC Tune-up"]
[null,"General Project Information"]
[]
[null,"General Information"]
[null,"Project Name:",null,null,"Street Address:",{"$f":"'Applicant Info'!E22","v":0}]
[null,"Project Number:",{"$f":"'Applicant Info'!J3","v":0},null,"City, State:",{"$f":"CONCATENATE('Applicant Info'!E23, \", \",'Applicant Info'!I23)","v":", "}]
[null,"Number of Units:",{"$f":"SUM(C10:D19,F10:F19)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"System Size","# of units","# of Circuits","Pre-Test Diagnosis was to…","because…","Post-test diagnosis was…","due to..","Ref. Charge","Unit Rejected"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.5,0,1,"check for leaks and repair","it did not meet size requirements.","that it did not qualify","failed post test.","Yes","Passed"]
[null,"2.5-ton",{"$f":"_xlfn.IFNA(SUMIF($F$26:$F$40,$X9,$E$26:$E$40),0)","v":0},null,"12.5-ton",{"$f":"_xlfn.IFNA(SUMIF($F$26:$F$40,$X19,$E$26:$E$40),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,1,2,"tune up high-side","safe and reasonable performance.","that no further repair is needed","safe and reasonable performance.","No","Rejected"]
[null,"3-ton",{"$f":"_xlfn.IFNA(SUMIF($F$26:$F$40,$X10,$E$26:$E$40),0)","v":0},null,"15-ton",{"$f":"_xlfn.IFNA(SUMIF($F$26:$F$40,$X20,$E$26:$E$40),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,2,3,"tune up low-side","a Refrigerant Flow Restriction.","to check for leaks and repair","unknown reasons"]
[null,"4-ton",0,null,"17.5-ton",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,3,4,"leave as-is","it's overcharged.","to tune up high-side","customer declined repairs"]
[null,"5-ton",0,null,"20-ton",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,4,null,"not tune up unit","a High Side Heat Transfer problem.","to tune up low-side"]
[null,"6-ton",0,null,"25-ton",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7.5,5,null,"make a major repair","a Low Side Heat Transfer problem.","not conducted"]
[null,"7.5-ton",0,null,"30-ton",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,6,null,"recover charge","improper evaporator airflow."]
[null,"8-ton",0,null,"35-ton",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,7,null,null,"it was undercharged."]
[null,"9-ton",0,null,"40-ton",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,8,null,null,"faulty txV valve"]
[null,"10-ton",0,null,"50-ton",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,9,null,null,"it's a TxV unit with hot condensor and high SC."]
[null,"11-ton",0,null,"60-ton",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12.5,10,null,null,"it's a fixed orifice unit with cold evap and high SH."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,11,null,null,"this is a fixed orifice unit with high superheat"]
[null,"Project Contact Information",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17.5,12]
[null,"Name:",{"$f":"'Applicant Info'!A19","v":0},null,"Phone:",{"$f":"'Applicant Info'!D20","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30]
[null,"Unit Name","Model","Serial #","Quantity","A/C Unit Size","Pre-Test Diagnosis","Because…","Post-test","due to…","Ref. Charge Added? Yes/No","Unit Passed/Rejected","Notes",null,null,null,null,null,null,null,null,null,null,35]
[null,"RTU-1",{"$f":"ACTU!C14","v":0},{"$f":"ACTU!D14","v":0},{"$f":"ACTU!F14","v":0},{"$f":"ACTU!G14","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,40]
[null,"RTU-2",{"$f":"ACTU!C15","v":0},{"$f":"ACTU!D15","v":0},{"$f":"ACTU!F15","v":0},{"$f":"ACTU!G15","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50]
[null,"RTU-3",{"$f":"ACTU!C16","v":0},{"$f":"ACTU!D16","v":0},{"$f":"ACTU!F16","v":0},{"$f":"ACTU!G16","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,60]
[null,"RTU-4",{"$f":"ACTU!C17","v":0},{"$f":"ACTU!D17","v":0},{"$f":"ACTU!F17","v":0},{"$f":"ACTU!G17","v":0}]
[null,"RTU-5",{"$f":"ACTU!C18","v":0},{"$f":"ACTU!D18","v":0},{"$f":"ACTU!F18","v":0},{"$f":"ACTU!G18","v":0}]
[null,"RTU-6",{"$f":"ACTU!C19","v":0},{"$f":"ACTU!D19","v":0},{"$f":"ACTU!F19","v":0},{"$f":"ACTU!G19","v":0}]
[null,"RTU-7",{"$f":"ACTU!C20","v":0},{"$f":"ACTU!D20","v":0},{"$f":"ACTU!F20","v":0},{"$f":"ACTU!G20","v":0}]
[null,"RTU-8",{"$f":"ACTU!C21","v":0},{"$f":"ACTU!D21","v":0},{"$f":"ACTU!F21","v":0},{"$f":"ACTU!G21","v":0}]
[null,"RTU-9",{"$f":"ACTU!C22","v":0},{"$f":"ACTU!D22","v":0},{"$f":"ACTU!F22","v":0},{"$f":"ACTU!G22","v":0}]
[null,"RTU-10",{"$f":"ACTU!C23","v":0},{"$f":"ACTU!D23","v":0},{"$f":"ACTU!F23","v":0},{"$f":"ACTU!G23","v":0}]
[null,"RTU-11",{"$f":"ACTU!C24","v":0},{"$f":"ACTU!D24","v":0},{"$f":"ACTU!F24","v":0},{"$f":"ACTU!G24","v":0}]
[null,"RTU-12",{"$f":"ACTU!C25","v":0},{"$f":"ACTU!D25","v":0},{"$f":"ACTU!F25","v":0},{"$f":"ACTU!G25","v":0}]
[null,"RTU-13",{"$f":"ACTU!C26","v":0},{"$f":"ACTU!D26","v":0},{"$f":"ACTU!F26","v":0},{"$f":"ACTU!G26","v":0}]
[null,"RTU-14",{"$f":"ACTU!C27","v":0},{"$f":"ACTU!D27","v":0},{"$f":"ACTU!F27","v":0},{"$f":"ACTU!G27","v":0}]
[null,"RTU-15",{"$f":"ACTU!C28","v":0},{"$f":"ACTU!D28","v":0},{"$f":"ACTU!F28","v":0},{"$f":"ACTU!G28","v":0}]

{"sheet":"Pictures","index":8,"n_rows":5,"n_cols":22,"rows_kept":5,"cut":false,"hidden":true,"merged":[[0,0,3,18],[0,19,0,23],[1,19,3,23],[4,0,4,5],[4,6,4,18],[4,19,4,20],[4,21,4,23]]}
["Post Inspection Pictures",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Appllication No."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Applicant Info'!J3","v":0}]
[]
[]
["Project Name",null,null,null,null,null,{"$f":"'General Info'!C6","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"Date:",null,{"$f":"'Inspection Report'!U5","v":"00:00:00"}]