{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["ECM Appendix T 2021"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":1,"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":"ECM Appendix T 2021","index":0,"n_rows":127,"n_cols":26,"rows_kept":127,"cut":false,"hidden":false,"merged":[[12,11,12,12],[95,6,95,10],[98,6,98,10],[93,4,93,5],[63,5,63,9],[65,5,65,9],[77,10,77,11],[36,4,36,5],[4,4,5,12],[38,5,39,7],[32,4,32,5],[56,10,56,11],[18,6,18,12],[20,6,20,12],[22,6,22,12],[24,6,24,12],[18,4,18,5],[20,4,20,5],[22,4,22,5],[26,6,26,9],[28,4,28,5],[32,6,32,9],[50,5,50,9],[30,6,30,9],[99,6,99,10],[79,10,79,11],[76,5,76,11],[96,6,96,10],[85,5,85,12],[87,6,87,9],[87,10,87,12],[89,5,89,10],[83,4,83,5],[6,4,6,12],[74,5,74,11],[40,5,40,9],[42,5,42,9],[44,5,44,9],[46,5,46,9],[48,5,48,9],[61,5,61,6],[28,6,28,9],[26,4,26,5],[8,4,8,5],[16,4,16,5],[24,4,24,5],[10,5,10,8],[12,5,12,8],[10,11,10,12]]}
[]
[]
[]
[]
[null,null,null,null,"APPENDIX T - REQUEST FOR OPTIONAL PAYMENT INSTEAD OF STRUCTURAL CONTROLS IN THE URBAN WATERSHEDS"]
[]
[null,null,null,null,"Items in yellow to be completed by applicant.  Please refer to instructions before completing this form.  "]
[]
[null,null,null,null,"A. OWNER/AGENT INFORMATION:"]
[]
[null,null,null,null,"Company:",null,null,null,null,null,"Owner/Agent Name:"]
[]
[null,null,null,null,"Phone Number:",null,null,null,null,null,"Email:"]
[]
[]
[]
[null,null,null,null,"B. PROJECT INFORMATION:"]
[]
[null,null,null,null,"Project name:"]
[]
[null,null,null,null,"Location or Address:"]
[]
[null,null,null,null,"Development Case Number:"]
[]
[null,null,null,null,"Case Manager:"]
[]
[null,null,null,null,"Redeveloped Impervious Cover (ac.):"]
[]
[null,null,null,null,"New Impervious Cover (ac.):"]
[]
[null,null,null,null,"Total Impervious Cover:",null,{"$f":"SUM(G27+G29)","v":0}]
[]
[null,null,null,null,"R/T Ratio = Redeveloped Impervious Cover/ Total Impervious Cover:",null,{"$f":"SUM(G27/G31)","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[null,null,null,null,"C. PAYMENT CALCULATIONS:"]
[]
[null,null,null,null,null,"1. SITE IMPERVIOUS COVER COMPONENT (SICC)",null,null,null,null,"Rate    x","Acreage (ac.)    =","Total ($)"]
[]
[null,null,null,null,null,"0 to 1.0 acre",null,null,null,null,114000,{"$f":"IF(X120<1.01,X120,1)","v":0},{"$f":"+SUM(K41*L41)","v":0}]
[]
[null,null,null,null,null,"1.01 to 2.0 acres",null,null,null,null,58000,{"$f":"IF(X121<2.01,X121,0.99)","v":0},{"$f":"+SUM(K43*L43)","v":0}]
[]
[null,null,null,null,null,"2.01 to 5.0 acres",null,null,null,null,34000,{"$f":"IF(X122<5.01,X122,2.99)","v":0},0]
[]
[null,null,null,null,null,"5.01 to 10.0 acres",null,null,null,null,21000,{"$f":"IF(X123<10.01,X123,4.99)","v":0},0]
[]
[null,null,null,null,null,"10.01 to 20.0 acres",null,null,null,null,14000,{"$f":"IF(X124<20.01,X124,9.99)","v":0},0]
[]
[null,null,null,null,null,"20.01 acres or greater",null,null,null,null,8000,{"$f":"IF(X125<20.01,X125,Z124)","v":0},0]
[]
[null,null,null,null,null,"SICC SUBTOTAL",null,null,null,null,null,{"$f":"SUM(L41:L52)","v":0},{"$f":"SUM(M41:M51)","v":0}]
[]
[null,null,null,null,null,"CONSTRUCTION COST ADJUSTMENT FACTOR (ENR CCI AF)",null,null,null,null,null,null,1.2070000000000001]
[]
[null,null,null,null,null,"SICC TOTAL (PAYMENT 1)",null,null,null,null,"SICC SUBTOTAL X ENR CCI AF =",null,{"$f":"M53*M55","v":0}]
[]
[null,null,null,null,null,"2. BUILDING COMPONENT (PAYMENT 2)",null,null,0.1,"X (B)",null,"sf = ",{"$f":"SUM(I59*K59)","v":0}]
[null,null,null,null,null,"(NOTE: CITY PORTION = $0)"]
[]
[null,null,null,null,null,"3. SITE AREA COMPONENT (SAC = PAYMENT 3)"]
[]
[null,null,null,null,null,"LAND VALUE (AS SHOWN ON CURRENT TCAD OR MOST RECENT APPRAISAL)"]
[]
[null,null,null,null,null,"LAND AREA (AS SHOWN ON CURRENT TCAD OR MOST RECENT APPRAISAL)",null,null,null,null,null,"ac."]
[]
[null,null,null,null,null,"LAND VALUE/ LAND AREA ($/ac.)",null,null,null,null,{"$f":"SUM(K64/K66)","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,null,null,"Site Acreage (LOC)",null,null,null,null,null,"ac."]
[]
[null,null,null,null,null,"SAC TOTAL (PAYMENT 3)",null,null,null,null,null,null,{"$f":"SUM(K68*K70*0.8*0.03)","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,null,null,"4. PAYMENT AMOUNTS"]
[null,null,null,null,null,"TOTAL PAYMENTS (1 + 2 + 3) = ",null,null,null,null,null,null,{"$f":"SUM(M57,M59,M72)","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,null,null,"CITY PORTION (CP): IF SUBJECT PROPERTY DRAINS TO PROPOSED OR EXISTING REGIONAL SCM.  "]
[null,null,null,null,null,"MUST BE VERIFIED BY WATERSHED PROTECTION DEPARTMENT.  OTHERWISE CP = 0",null,null,null,null,"CP = (PAYMENT 1 + PAYMENT 3) X R/T X 75% = "]
[]
[null,null,null,null,null,"APPLICANT PAYMENT: ",null,null,null,null,"TOTAL PAYMENTS - CP = ",null,{"$f":"SUM(M75-M78)","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[null,null,null,null,"D. COST RECOVERY:  To be completed by City staff."]
[]
[null,null,null,null,null,"PARTICIPATION MUST BE APPROVED BY A WATERSHED PROTECTION - STORMWATER TREATMENT SECTION REPRESENTATIVE."]
[]
[null,null,null,null,null,"APPROVED CONSTRUCTION COST = ","$",null,null,null,"ATTACH 300U STANDARD BID DOCUMENT WITH ENGINEER'S COST ESTIMATE."]
[]
[null,null,null,null,null,"CITY PORTION (CONSTRUCTION COST X R/T X 75%) =                                                                                  ",null,null,null,null,null,null,{"$f":"SUM(G88*0.75*G33)","v":{"$error":"#VALUE!"}}]
[]
[]
[]
[null,null,null,null,"E. AUTHORIZATION:"]
[]
[null,null,null,null,null,"OWNER/AGENT:",null,null,null,null,null,"DATE:"]
[null,null,null,null,null,null,"OWNER/AGENT SIGNATURE"]
[]
[null,null,null,null,null,"REVIEWED BY:",null,null,null,null,null,"DATE:"]
[null,null,null,null,null,null,"SIGNATURE FOR THE DIRECTOR, DEVELOPMENT SERVICES DEPARTMENT"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x (A1)","0 - 1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x (A2)","1.01 - 2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x (A3)","2.01 - 5"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x (A3a)","5.01 - 10"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x (A4)","10.01 - 20"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x (A5)","> 20.01"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"det zone","det area",null,"acres left"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"0 - 1.00 acres",{"$f":"IF($G$31<1,1,0)","v":1},{"$f":"IF($G$31<1,$G$31,1)","v":0},null,{"$f":"$G$31-X120","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1.01 - 2.00 acres",{"$f":"IF($G$31>1,(IF($G$31<2,1,0)),0)","v":0},{"$f":"IF($G$31>1,(IF(W121=1,$G$31-X120,0.99)),0)","v":0},null,{"$f":"$G$31-SUM(X120:X121)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2.01 - 5.0 acres",{"$f":"IF($G$31>2,(IF($G$31<7,1,0)),0)","v":0},{"$f":"IF($G$31>2,(IF((SUM(W120:W121)<>1),IF($G$31<5.01,Z121,2.99),0)),0)","v":0},null,{"$f":"$G$31-SUM(X120:X122)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5.01 - 10",{"$f":"IF($G$31>2,(IF($G$31<7,1,0)),0)","v":0},{"$f":"IF($G$31>5,IF($G$31<10.01,Z122,4.99),0)","v":0},null,{"$f":"$G$31-SUM(X120:X123)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"10.01 - 20.00 acres",0,{"$f":"IF($G$31>5,IF($G$31<10.01,Z123,9.99),0)","v":0},null,{"$f":"$G$31-SUM(X120:X124)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"20.01 acres or greater",0,{"$f":"IF($G$31>20.01,Z124,0)","v":0},null,{"$f":"$G$31-SUM(X120:X125)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"total",{"$f":"SUM(X120:X126)","v":0}]