{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":0,"images":6,"macros":1,"external_links":0,"defined_names":1,"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":"Sheet1","index":0,"n_rows":27,"n_cols":8,"rows_kept":27,"cut":false,"hidden":false,"merged":[[7,6,7,8],[8,6,8,8],[12,3,12,4],[7,3,7,4],[11,6,11,8],[12,6,12,8],[0,1,0,8],[1,1,1,8],[6,3,6,4],[3,3,3,4],[4,3,4,4],[5,3,5,4],[3,6,3,8],[4,6,4,8],[5,6,5,8],[9,3,9,4],[10,3,10,4],[6,6,6,8],[9,6,9,8],[10,6,10,8],[13,6,13,8],[2,3,2,8],[26,3,26,6],[16,1,16,3],[17,1,17,3],[18,1,18,3],[21,1,21,2],[22,1,22,2],[23,1,23,2],[24,1,24,2],[20,1,20,3],[13,3,13,4],[8,3,8,4],[11,3,11,4]]}
[null,"Level 2 EV Charging Rebate Calculation Worksheet"]
[null,"A Driving PA Forward Program"]
[null,"Worksheet Instructions","1. Fill in project estimate information in the table below. ","2. \"Total estimated project cost\" will automatically fill based on your invoice data.  Then check the box below that corresponds to your project category.  The rebate amount will automatically caclulate. "]
[null,"Estimate","Description of Estimate","Vendor Name ",null,"Date","Estimated Cost"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[]
[]
[null,"Insert total number of plugs to be installed:"]
[]
[null,"Total estimated project cost:",null,null,{"$f":"SUM(G5:I14)","v":0}]
[]
[null,"A. Project Category (check the appropriate box corresponding to your project category. Only one box can be checked.)",null,null,"B. Maximum Rebate per Plug","C. Maximum Rebate per Plug (x) No. of Plugs","D. Maximum % of Project Cost Allowed","E. Net Project Cost (x) Max %"]
[null,"Full Public Access & Networked, Priority County",null,false,4000,{"$f":"IF(D22=TRUE,E17*E22,0)","v":0},0.7,{"$f":"IF(D22=TRUE,E19*0.7,0)","v":0}]
[null,"Full Public Access & Networked, All Other Counties",null,false,3500,{"$f":"IF(D23=TRUE,E17*E23,0)","v":0},0.6,{"$f":"IF(D23=TRUE,E19*0.6,0)","v":0}]
[null,"Multi Unit Dwelling",null,false,3000,{"$f":"IF(D24=TRUE,E17*E24,0)","v":0},0.5,{"$f":"IF(D24=TRUE,E19*0.5,0)","v":0}]
[null,"All Other Eligible Projects",null,false,2500,{"$f":"IF(D25=TRUE,E17*E25,0)","v":0},0.4,{"$f":"IF(D25=TRUE,E19*0.4,0)","v":0}]
[]
[null,null,null,"Calculated Rebate Amount",null,null,null,{"$f":"IF(D22=TRUE,MIN(F22,H22),IF(D23=TRUE,MIN(F23,H23),IF(D24=TRUE,MIN(F24,H24),IF(D25=TRUE,MIN(F25,H25),IF(#REF!=TRUE,MIN(#REF!,#REF!),IF(#REF!=TRUE,MIN(#REF!,#REF!),IF(D22=FALSE,\"N/A\")))))))","v":{"$error":"#REF!"}}]