{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Overview","1","2","BMP Design","Financial Input","Financial Summary","Detailed Estimation","Background","References","Costs"],"not_rendered":{"charts":1,"images":4,"macros":1,"external_links":0,"defined_names":109,"comments":4,"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":"Overview","index":0,"n_rows":36,"n_cols":12,"rows_kept":36,"cut":false,"hidden":false,"merged":[[22,4,22,7],[13,4,13,6],[2,2,2,7],[4,2,9,8],[10,2,10,8],[19,2,20,7],[16,3,16,6],[31,1,31,3],[29,2,29,7],[24,2,24,7],[27,2,27,7],[28,2,28,7]]}
[]
[]
[null,null,"Stormwater Retention Credit\n(SRC) Price Lock Program\nFinancial Return Calculator\nRegulatory Review Division"]
[]
[null,null,"This calculator estimates the potential SRC eligibility and return on investment for a runoff-reducing green infrastructure project participating in DOEE's SRC Price Lock Program.  To begin your estimate, please complete the fields below.  If  complete site, construction, and financial information is not available, the tool will use assumptions to provide a rough estimate.  This calculator will not continue to subsequent pages if required information is missing or if information provided is inconsistent.\n\nThis calculator is a planning and estimation tool only.  DOEE does not guarantee financial return, SRC eligibility, or other results.  The use of this tool does not submit information to DOEE.\n\nBy enabling macros and using the \"Clear All Fields\" button you can remove your previous inputs and return to a blank template."]
[]
[]
[]
[]
[]
[null,null,"Voluntary SRC Project Overview"]
[]
[]
[null,null,"Project Address: "]
[]
[null,null,"1.  Is the project a voluntary retrofit or a regulated activity?",null,null,null,null,"Please Select  ","Voluntary"]
[null,null,null,"*Projects that trigger Stormwater Regulations have a Stormwater Retention Volume (SWRv) obligation that must be met.  Retention\n volume that exceeds the regulatory requirement may have SRC eligibility."]
[null,null,"1. Did your project receive any funding from DOEE?",null,null,"$i",null,"Please Select  ",null,{"$f":"IF(Activity=\"Regulated\",\"No\",I18)","v":0},{"$f":"IF(Activity=\"Regulated\",0,IF(I18=\"No\",0,G18))","v":0}]
[]
[null,null,{"$f":"IF(Activity=\"Voluntary\",\"2. Is the project located within Municipal Separate Storm Sewer System (MS4) or\n    Combined Sewer System (CSS)?\",\"2. Is the regulated project a Major Land Disturbing activity or a Major Substantial\n    Improvement activity?\")","v":"2. Is the project located within Municipal Separate Storm Sewer System (MS4) or\n    Combined Sewer System (CSS)?"},null,null,null,null,null,null,null,{"$f":"(IF(Activity=\"Regulated\",1,0))","v":0},{"$f":"IF(OR(MS4_MLD=\"MLD\",MS4_MLD=\"MSI\"),1,0)","v":0}]
[]
[null,null,{"$f":"IF(Activity=\"Voluntary\",\"       *For MS4 areas, please indicate whether the project is within the MS4 Tidal or Non-tidal area.\",\"       *Please distinguish between Major Land Disturbing (MLD) activity or Major Substantial Improvement (MSI) activity.\")","v":"       *For MS4 areas, please indicate whether the project is within the MS4 Tidal or Non-tidal area."}]
[null,null,null,{"$f":"IF(Activity=\"Voluntary\",HYPERLINK(\"http://dcgis.maps.arcgis.com/home/webmap/viewer.html?webmap=9519ba345997482d9f66a8513cc4289b\",\"MS4 Map\"),HYPERLINK(\"https://doee.dc.gov/sites/default/files/dc/sites/ddoe/publication/attachments/Appendix%20U%20%20Definitions.pdf\",\"Appendix U\"))","v":"MS4 Map"},{"$f":"IF(Activity=\"Regulated\",\"   The definition for these activities can be found in the Stormwater Management Guidebook.\",\"\")","v":""}]
[null,null,"        *Projects located in the CSS are not eligible for participation in the SRC Price Lock Program"]
[null,null,{"$f":"IF(Activity=\"Voluntary\",\"3. Is the project participating in DOEE's SRC Price Lock Program?\",\"3.  Is the project an Anacostia Waterfront Development Zone (AWDZ) Site?\")","v":"3. Is the project participating in DOEE's SRC Price Lock Program?"},null,null,null,null,null,null,{"$f":"IF(Activity=\"Regulated\",\"No\",IF(MS4_MLD=\"CSS\",\"No\",Price_AWDZ))","v":0}]
[null,null,null,{"$f":"IF(AND(Activity=\"Regulated\",Price_AWDZ=\"Yes\"),\"*AWDZ projects are unlikely to result in SRC eligibility as they are required to retain or treat runoff from a 1.7-inch storm.\",IF(AND(Activity=\"Voluntary\",Price_AWDZ=\"Yes\"),\"To participate in this program you must submit an SRC Price Lock Program application\",\"\"))","v":""}]
[null,null,null,{"$f":"IF(Activity=\"Voluntary\",HYPERLINK(\"https://doee.dc.gov/service/src-price-lock-program\",\"SRC Price Lock\"),HYPERLINK(\"https://octo.quickbase.com/up/bjkxxcfcp/g/rcg/eg/va/info_page.html?pagerecord=27\",\"AWDZ Map\"))","v":"SRC Price Lock"}]
[null,null,{"$f":"IF(Activity=\"Voluntary\",\"4. What is your total project area square footage?\",\"4. What is the square footahge of the project's Limit of Disturbance (LOD)?\")","v":"4. What is your total project area square footage?"}]
[null,null,{"$f":"IF(Activity=\"Voluntary\",\"      Enter the total project area, limited to the BMP(s), contributing drainage areas to the BMP(s), and land cover change.\",\"      LOD includes area within which all construction, materials storage, grading, landscaping, and related activities shall occur.\")","v":"      Enter the total project area, limited to the BMP(s), contributing drainage areas to the BMP(s), and land cover change."}]
[null,null,{"$f":"IF(MS4_MLD=\"MSI\",\"    *Please include the building footprint in your LOD.\",\"\")","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(Activity=\"\",HYPERLINK(\"#Activity\",\"Continue\"),IF(AND(Activity=\"Voluntary\",I18=\"\"),HYPERLINK(\"#'Overview'!I18\",\"Continue\"),IF(AND(I18=\"Yes\",G18=\"\"),HYPERLINK(\"#'Overview'!g18\",\"Continue\"),IF(AND(I18=\"Yes\",G18<1),HYPERLINK(\"#'Overview'!g18\",\"Continue\"),IF(I20=\"\",HYPERLINK(\"#'Overview'!I20\",\"Continue\"),IF(OR(J25=0,J25=\"\"),HYPERLINK(\"#'Overview'!I25\",\"Continue\"),IF(K20-L20<>0,HYPERLINK(\"#'Overview'!I20\",\"Continue\"),IF(AND(I25=\"\",MS4_MLD<>\"CSS\"),HYPERLINK(\"#'Overview'!I25\",\"Continue\"),IF(I28=\"\",HYPERLINK(\"#'Overview'!I27\",\"Continue\"),IF(I16=\"Voluntary\",HYPERLINK(\"#1!e5\",\"Continue\"),HYPERLINK(\"#2!e5\",\"Continue\")))))))))))","v":"Continue"}]
[null,"Version 1.3 (1/31/2020)"]
[]
[null,null,{"$f":"IF(Activity=\"Voluntary\",\"MS4 Tidal\",\"MLD\")","v":"MS4 Tidal"}]
[null,null,{"$f":"IF(Activity=\"Voluntary\",\"MS4 Non-tidal\",\"MSI\")","v":"MS4 Non-tidal"}]
[null,null,{"$f":"IF(Activity=\"Voluntary\",\"CSS\",\"\")","v":"CSS"}]

{"sheet":"1","index":1,"n_rows":93,"n_cols":29,"rows_kept":93,"cut":false,"hidden":false,"merged":[[17,12,19,12],[17,13,19,13],[17,14,19,14],[20,21,20,22],[21,21,21,22],[22,21,22,22],[23,12,23,13],[23,14,23,15],[23,16,23,17],[23,18,23,19],[23,20,23,21],[17,23,19,23],[15,2,16,23],[17,2,18,3],[17,4,18,5],[19,4,19,5],[19,2,19,3],[19,9,19,10],[17,11,19,11],[17,16,19,16],[17,19,19,19],[17,17,19,17],[17,20,19,20],[17,21,19,22],[17,15,19,15],[17,18,19,18],[18,6,18,10],[9,4,10,7],[2,2,2,7],[6,2,6,3],[5,2,5,5],[5,6,5,8],[7,2,7,3],[8,2,8,3],[4,2,4,3],[4,5,4,8],[23,9,23,10],[20,2,20,3],[21,2,21,3],[22,2,22,3],[17,6,17,10],[20,4,20,5],[21,4,21,5],[22,4,22,5],[21,9,21,10],[22,9,22,10],[20,9,20,10]]}
[]
[]
[null,null,"Enter Land Cover Area by Type\nIf land cover information is unavailable, the calculator will assume 100% impervious pre-project land cover and 90% impervious and 10% BMP post-project land cover."]
[]
[null,null,"Total Project Area (ft2):ii",null,{"$f":"Overview!I28","v":0},{"$f":"IF(OR(Pre>0,Post>0),\" \",\"  For a more detailed estimate, include land cover square footage below.\")","v":"  For a more detailed estimate, include land cover square footage below."}]
[]
[null,null,"Land Cover Type:",null,"Natural","Compacted","Impervious","BMP"]
[null,null,"Post-project  (ft2)",null,null,null,null,null,{"$f":"SUM(E8:H8)","v":0}]
[null,null,"Pre-project   (ft2)",null,null,null,null,null,{"$f":"SUM(E9:H9)","v":0}]
[null,null,null,null,{"$f":"IF(I32=\"123456\",E34,IF(I32=\"12345\",E35,IF(I32=\"12346\",E36,IF(I32=\"12356\",E37,IF(I32=\"12456\",E38,IF(I32=\"13456\",E39,IF(I32=\"23456\",E40,IF(I32=\"1234\",E41,IF(I32=\"1235\",E42,IF(I32=\"1236\",E43,IF(I32=\"1245\",E44,IF(I32=\"1246\",E45,IF(I32=\"1256\",E46,IF(I32=\"1345\",E47,IF(I32=\"1346\",E48,IF(I32=\"1356\",E49,IF(I32=\"1456\",E50,IF(I32=\"2345\",E51,IF(I32=\"2346\",E52,IF(I32=\"2456\",E53,IF(I32=\"3456\",E54,IF(I32=\"123\",E55,IF(I32=\"124\",E56,IF(I32=\"125\",E57,IF(I32=\"126\",E58,IF(I32=\"134\",E59,IF(I32=\"135\",E60,IF(I32=\"136\",E61,IF(I32=\"145\",E62,IF(I32=\"146\",E63,IF(I32=\"234\",E64,IF(I32=\"235\",E65,IF(I32=\"236\",E66,IF(I32=\"245\",E67,IF(I32=\"246\",E68,IF(I32=\"256\",E69,IF(I32=\"345\",E70,IF(I32=\"346\",E71,IF(I32=\"456\",E72,IF(I32=\"12\",E73,IF(I32=\"13\",E74,IF(I32=\"14\",E75,IF(I32=\"15\",E76,IF(I32=\"16\",E77,IF(I32=\"23\",E78,IF(I32=\"24\",E79,IF(I32=\"25\",E80,IF(I32=\"26\",E81,IF(I32=\"34\",E82,IF(I32=\"35\",E83,IF(I32=\"36\",E84,IF(I32=\"45\",E85,IF(I32=\"46\",E86,IF(I32=\"56\",E87,IF(I32=\"1\",E88,IF(I32=\"2\",E89,IF(I32=\"3\",E90,IF(I32=\"4\",E91,IF(I32=\"5\",E92,IF(I32=\"6\",E93,\"\"))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))","v":""}]
[null,null,{"$f":"HYPERLINK(\"#'Overview'!i16\",\"Go Back\")","v":"Go Back"},null,null,null,null,null,{"$f":"IF(AND(Post>0,Post<>E5),HYPERLINK(\"#1!I8:I9\",\"Continue\"),IF(Post<>Pre,HYPERLINK(\"#1!e8:h9\",\"Continue\"),IF(AND(H9>0,SUM(J21:K23)<>H9),HYPERLINK(\"#1!J21:J23\",\"Continue\"),HYPERLINK(\"#'BMP Design'!d7\",\"Continue\"))))","v":"Continue"}]
[null,null,null,null,null,"Pre",{"$f":"IF(AND(ISBLANK(G9),Pre=0),E5,G9)","v":0},{"$f":"IF(AND(ISBLANK(H9),Pre=0),0,H9)","v":0}]
[null,null,null,null,null,"Post",{"$f":"IF(AND(ISBLANK(G8),Post=0),$E$5*0.9,G8)","v":0},{"$f":"IF(AND(ISBLANK(H8),Post=0),$E$5*0.1,H8)","v":0}]
[]
[]
[null,null,"Enter Pre-Project BMP Information\nIf existing BMP storage volume information is unavailable, the calculator will assume BMPs manage the 1.7-inch storm across the Contributing Drainage Area."]
[]
[null,null,"BMP",null,"BMP Subtype",null,"Contributing Drainage Area (CDA) (ft2)",null,null,null,null,"Storage Volume (ft3)","Sv Calc","If Sv Blank","1.7 Rv","if blank","Receiving Area (ft2)","Ra Calc","If Ra Blank","Number of Trees","Retention Value","BMP Retention Vol. Achieved (ft3)",null,"BMP Retention (gal)"]
[null,null,null,null,null,null,"CDA Required"]
[null,null,"BMP Type and Subtype do not match",null,"BMP Subtype Required",null,"Natural","Compacted","Impervious","BMP"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(L21),N21,L21)","v":""},{"$f":"IF(E21=\"Rainwater harvesting\",((References!$E$2*O21)*7.48),\"\")","v":""},{"$f":"IF(C21=\"Tree Planting and Preservation\",\"Tree\",1.7/12*(G21*0.05+H21*0.25+I21*0.95+J21*0.95))","v":0},{"$f":"IF(ISBLANK(L21),O21,L21)","v":0},null,{"$f":"IF(ISBLANK(Q21),S21,Q21)","v":0},{"$f":"IF(E21=\"Simple disconnection to amended soils\",(N21/40)*100,IF(E21=\"Simple disconnection to a conservation area\",(N21/60)*100,IF(E21=\"Simple disconnection to a pervious area\",(N21/20)*100,0)))","v":0},null,{"$f":"IFERROR(INDIRECT(Z21),\" \")","v":" "},{"$f":"IF(OR(C21=\"\",E21=\"\",SUM(H21:J21)=0),0,IFERROR(IF(U21>1,MIN(U21,P21),MIN((U21*P21),(1.7/12*(G21*References!$B$16+H21*References!$B$17+I21*References!$B$18+J21*References!$B$18)))),\"0.0\"))","v":0},null,{"$f":"V21*7.48","v":0},{"$f":"IF(C21=\"\",\"\",IF(C21=\"Green Roof\",\"Green\",IF(C21=\"Rainwater Harvesting\",\"Rainwater\",IF(C21=\"Impervious Surface Disconnection\",\"Impervious\",IF(C21=\"Permeable Pavement\",\"Permeable\",IF(C21=\"Tree Planting and Preservation\",\"Tree\",IF(C21=\"Open Channel\",\"Open\",C21)))))))","v":""},{"$f":"IF(E21=\"\",\"\",IF(E21=\"Extensive green roof\",\"Extensive\",IF(E21=\"Intensive green roof\",\"Intensive\",IF(E21=\"Rainwater harvesting\",\"RWHarvest\",IF(E21=\"Simple disconnection to a conservation area\",\"Conservation\",IF(E21=\"Simple disconnection to amended soils\",\"IDAmended\",IF(E21=\"Simple disconnection to a pervious area\",\"Pervious\",IF(E21=\"Permeable pavement - Enhanced\",\"PPEnhanced\",IF(E21=\"Permeable pavement - Standard\",\"PPStandard\",IF(E21=\"Bioretention - Enhanced\",\"BioEnhanced\",IF(E21=\"Bioretention - Standard\",\"BioStandard\",IF(E21=\"Infiltration trench\",\"Trench\",IF(E21=\"Infiltration basin\",\"Basin\",IF(E21=\"Grass channel\",\"Grass\",IF(E21=\"Grass channel - amended soils\",\"GCAmended\",IF(E21=\"Dry swale\",\"DrySwale\",IF(E21=\"wet swale\",\"WetSwale\",IF(E21=\"Micropool ED pond\",\"Micropool\",IF(E21=\"Wet pond\",\"WetPond\",IF(E21=\"Wet ED pond\",\"EDPond\",IF(E21=\"Shallow wetland\",\"Shallow\",IF(E21=\"ED shallow wetland\",\"EDWet\",IF(E21=\"Tree preservation\",\"Preservation\",IF(E21=\"Tree planting\",\"Planting\"))))))))))))))))))))))))","v":""},{"$f":"VLOOKUP(C21,Match,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(E21,Match1,2,0)","v":{"$error":"#N/A"}},{"$f":"IF(AA21=AB21,\"\",1)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(L22),N22,L22)","v":""},{"$f":"IF(E22=\"Rainwater harvesting\",((References!$E$2*O22)*7.48),\"\")","v":""},{"$f":"IF(C22=\"Tree Planting and Preservation\",\"Tree\",1.7/12*(G22*0.05+H22*0.25+I22*0.95+J22*0.95))","v":0},{"$f":"IF(ISBLANK(L22),O22,L22)","v":0},null,{"$f":"IF(ISBLANK(Q22),S22,Q22)","v":0},{"$f":"IF(E22=\"Simple disconnection to amended soils\",(N22/40)*100,IF(E22=\"Simple disconnection to a conservation area\",(N22/60)*100,IF(E22=\"Simple disconnection to a pervious area\",(N22/20)*100,0)))","v":0},null,{"$f":"IFERROR(INDIRECT(Z22),\" \")","v":" "},{"$f":"IF(OR(C22=\"\",E22=\"\",SUM(H22:J22)=0),0,IFERROR(IF(U22>1,MIN(U22,P22),MIN((U22*P22),(1.7/12*(G22*References!$B$16+H22*References!$B$17+I22*References!$B$18+J22*References!$B$18)))),\"0.0\"))","v":0},null,{"$f":"V22*7.48","v":0},{"$f":"IF(C22=\"\",\"\",IF(C22=\"Green Roof\",\"Green\",IF(C22=\"Rainwater Harvesting\",\"Rainwater\",IF(C22=\"Impervious Surface Disconnection\",\"Impervious\",IF(C22=\"Permeable Pavement\",\"Permeable\",IF(C22=\"Tree Planting and Preservation\",\"Tree\",IF(C22=\"Open Channel\",\"Open\",C22)))))))","v":""},{"$f":"IF(E22=\"\",\"\",IF(E22=\"Extensive green roof\",\"Extensive\",IF(E22=\"Intensive green roof\",\"Intensive\",IF(E22=\"Rainwater harvesting\",\"RWHarvest\",IF(E22=\"Simple disconnection to a conservation area\",\"Conservation\",IF(E22=\"Simple disconnection to amended soils\",\"IDAmended\",IF(E22=\"Simple disconnection to a pervious area\",\"Pervious\",IF(E22=\"Permeable pavement - Enhanced\",\"PPEnhanced\",IF(E22=\"Permeable pavement - Standard\",\"PPStandard\",IF(E22=\"Bioretention - Enhanced\",\"BioEnhanced\",IF(E22=\"Bioretention - Standard\",\"BioStandard\",IF(E22=\"Infiltration trench\",\"Trench\",IF(E22=\"Infiltration basin\",\"Basin\",IF(E22=\"Grass channel\",\"Grass\",IF(E22=\"Grass channel - amended soils\",\"GCAmended\",IF(E22=\"Dry swale\",\"DrySwale\",IF(E22=\"wet swale\",\"WetSwale\",IF(E22=\"Micropool ED pond\",\"Micropool\",IF(E22=\"Wet pond\",\"WetPond\",IF(E22=\"Wet ED pond\",\"EDPond\",IF(E22=\"Shallow wetland\",\"Shallow\",IF(E22=\"ED shallow wetland\",\"EDWet\",IF(E22=\"Tree preservation\",\"Preservation\",IF(E22=\"Tree planting\",\"Planting\"))))))))))))))))))))))))","v":""},{"$f":"VLOOKUP(C22,Match,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(E22,Match1,2,0)","v":{"$error":"#N/A"}},{"$f":"IF(AA22=AB22,\"\",1)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(E23=\"Rainwater harvesting\",((References!$E$2*O23)*7.48),\"\")","v":""},0,0,null,0,{"$f":"IF(E23=\"Simple disconnection to amended soils\",(N23/40)*100,IF(E23=\"Simple disconnection to a conservation area\",(N23/60)*100,IF(E23=\"Simple disconnection to a pervious area\",(N23/20)*100,0)))","v":0},null,{"$f":"IFERROR(INDIRECT(Z23),\" \")","v":" "},{"$f":"IF(OR(C23=\"\",E23=\"\",SUM(H23:J23)=0),0,IFERROR(IF(U23>1,MIN(U23,P23),MIN((U23*P23),(1.7/12*(G23*References!$B$16+H23*References!$B$17+I23*References!$B$18+J23*References!$B$18)))),\"0.0\"))","v":0},null,{"$f":"V23*7.48","v":0},{"$f":"IF(C23=\"\",\"\",IF(C23=\"Green Roof\",\"Green\",IF(C23=\"Rainwater Harvesting\",\"Rainwater\",IF(C23=\"Impervious Surface Disconnection\",\"Impervious\",IF(C23=\"Permeable Pavement\",\"Permeable\",IF(C23=\"Tree Planting and Preservation\",\"Tree\",IF(C23=\"Open Channel\",\"Open\",C23)))))))","v":""},{"$f":"IF(E23=\"\",\"\",IF(E23=\"Extensive green roof\",\"Extensive\",IF(E23=\"Intensive green roof\",\"Intensive\",IF(E23=\"Rainwater harvesting\",\"RWHarvest\",IF(E23=\"Simple disconnection to a conservation area\",\"Conservation\",IF(E23=\"Simple disconnection to amended soils\",\"IDAmended\",IF(E23=\"Simple disconnection to a pervious area\",\"Pervious\",IF(E23=\"Permeable pavement - Enhanced\",\"PPEnhanced\",IF(E23=\"Permeable pavement - Standard\",\"PPStandard\",IF(E23=\"Bioretention - Enhanced\",\"BioEnhanced\",IF(E23=\"Bioretention - Standard\",\"BioStandard\",IF(E23=\"Infiltration trench\",\"Trench\",IF(E23=\"Infiltration basin\",\"Basin\",IF(E23=\"Grass channel\",\"Grass\",IF(E23=\"Grass channel - amended soils\",\"GCAmended\",IF(E23=\"Dry swale\",\"DrySwale\",IF(E23=\"wet swale\",\"WetSwale\",IF(E23=\"Micropool ED pond\",\"Micropool\",IF(E23=\"Wet pond\",\"WetPond\",IF(E23=\"Wet ED pond\",\"EDPond\",IF(E23=\"Shallow wetland\",\"Shallow\",IF(E23=\"ED shallow wetland\",\"EDWet\",IF(E23=\"Tree preservation\",\"Preservation\",IF(E23=\"Tree planting\",\"Planting\"))))))))))))))))))))))))","v":""},{"$f":"VLOOKUP(C23,Match,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(E23,Match1,2,0)","v":{"$error":"#N/A"}},{"$f":"IF(AA23=AB23,\"\",1)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(X21:X23)","v":0},null,null,null,null,{"$f":"COUNTIF(AC21:AC23,1)","v":0}]
[null,null,{"$f":"COUNTIF(C21:D23,\"Tree Planting and Preservation\")>0","v":false}]
[null,null,{"$f":"COUNTIF(C21:D23,\"Impervious Surface Disconnection\")>0","v":false},null,{"$f":"IF(SUM(E8:H8)=SUM(E9:H9),\"\",\"Pre and post-project land cover square footage must be equivalent\")","v":""},null,null,null,{"$f":"IF(E26=\"\",\"\",1)","v":""}]
[null,null,null,null,{"$f":"IF(OR(E5<>I8,E5<>I9),\"Total Project Area does not match pre and/or Post project totals\",\"\")","v":""},null,null,null,{"$f":"IF(E27=\"\",\"\",2)","v":""}]
[null,null,null,null,{"$f":"IF(E8<E9,\"Retrofitting natural area does not result in SRC eligibility.\",\"\")","v":""},null,null,null,{"$f":"IF(E28=\"\",\"\",3)","v":""}]
[null,null,null,null,{"$f":"IF(F8<F9,\"Retrofitting compacted area results in less SRC eligibility than retrofitting impervious area.\",\"\")","v":""},null,null,null,{"$f":"IF(E29=\"\",\"\",4)","v":""}]
[null,null,null,null,{"$f":"IFERROR(IF(H8/Post>0.9,\"BMP has little to no additional CDA\",\"\"),\"\")","v":""},null,null,null,{"$f":"IF(E30=\"\",\"\",5)","v":""}]
[null,null,null,null,{"$f":"IF(AND(E5>=5000,G8>G9),\"Project may trigger stormwater regulations\",\"\")","v":""},null,null,null,{"$f":"IF(E31=\"\",\"\",6)","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"I26&I27&I28&I29&I30&I31","v":""}]
[]
[null,null,null,123456,"-Pre and post-project land cover square footage must be equivalent.\n-Total Project Area does not match Pre and/or Post project totals.\n-Retrofitting natural area does not result in SRC eligibility.\n-Retrofitting compacted area results in less SRC eligibility than retrofitting impervious area.\n-BMP has little to no additional CDA.\n-Project may trigger stormwater regulations."]
[null,null,null,12345,"-Pre and post-project land cover square footage must be equivalent.\n-Total Project Area does not match Pre and/or Post project totals.\n-Retrofitting natural area does not result in SRC eligibility.\n-Retrofitting compacted area results in less SRC eligibility than retrofitting impervious area.\n-BMP has little to no additional CDA."]
[null,null,null,12346,"-Pre and post-project land cover square footage must be equivalent.\n-Total Project Area does not match Pre and/or Post project totals.\n-Retrofitting natural area does not result in SRC eligibility.\n-Retrofitting compacted area results in less SRC eligibility than retrofitting impervious area.\n-Project may trigger stormwater regulations."]
[null,null,null,12356,"-Pre and post-project land cover square footage must be equivalent.\n-Total Project Area does not match Pre and/or Post project totals.\n-Retrofitting natural area does not result in SRC eligibility.\n-BMP has little to no additional CDA.\n-Project may trigger stormwater regulations."]
[null,null,null,12456,"-Pre and post-project land cover square footage must be equivalent.\n-Total Project Area does not match Pre and/or Post project totals.\n-Retrofitting compacted area results in less SRC eligibility than retrofitting impervious area.\n-BMP has little to no additional CDA.\n-Project may trigger stormwater regulations."]
[null,null,null,13456,"-Pre and post-project land cover square footage must be equivalent.\n-Retrofitting natural area does not result in SRC eligibility.\n-Retrofitting compacted area results in less SRC eligibility than retrofitting impervious area.\n-BMP has little to no additional CDA.\n-Project may trigger stormwater regulations."]
[null,null,null,23456,"-Total Project Area does not match Pre and/or Post project totals.\n-Retrofitting natural area does not result in SRC eligibility.\n-Retrofitting compacted area results in less SRC eligibility than retrofitting impervious area.\n-BMP has little to no additional CDA.\n-Project may trigger stormwater regulations."]
[null,null,null,1234,"-Pre and post-project land cover square footage must be equivalent.\n-Total Project Area does not match Pre and/or Post project totals.\n-Retrofitting natural area does not result in SRC eligibility.\n-Retrofitting compacted area results in less SRC eligibility than retrofitting impervious area."]
[null,null,null,1235,"-Pre and post-project land cover square footage must be equivalent.\n-Total Project Area does not match Pre and/or Post project totals.\n-Retrofitting natural area does not result in SRC eligibility.\n-BMP has little to no additional CDA."]
[null,null,null,1236,"-Pre and post-project land cover square footage must be equivalent.\n-Total Project Area does not match Pre and/or Post project totals.\n-Retrofitting natural area does not result in SRC eligibility.\n-Project may trigger stormwater regulations."]
[null,null,null,1245,"-Pre and post-project land cover square footage must be equivalent.\n-Total Project Area does not match Pre and/or Post project totals.\n-Retrofitting compacted area results in less SRC eligibility than retrofitting impervious area.\n-BMP has little to no additional CDA."]
[null,null,null,1246,"-Pre and post-project land cover square footage must be equivalent.\n-Total Project Area does not match Pre and/or Post project totals.\n-Retrofitting compacted area results in less SRC eligibility than retrofitting impervious area.\n-Project may trigger stormwater regulations."]
[null,null,null,1256,"-Pre and post-project land cover square footage must be equivalent.\n-Total Project Area does not match Pre and/or Post project totals.\n-BMP has little to no additional CDA.\n-Project may trigger stormwater regulations."]
[null,null,null,1345,"-Pre and post-project land cover square footage must be equivalent.\n-Retrofitting natural area does not result in SRC eligibility.\n-Retrofitting compacted area results in less SRC eligibility than retrofitting impervious area.\n-BMP has little to no additional CDA."]
[null,null,null,1346,"-Pre and post-project land cover square footage must be equivalent.\n-Retrofitting natural area does not result in SRC eligibility.\n-Retrofitting compacted area results in less SRC eligibility than retrofitting impervious area.\n-Project may trigger stormwater regulations."]
[null,null,null,1356,"-Pre and post-project land cover square footage must be equivalent.\n-Retrofitting natural area does not result in SRC eligibility.\n-BMP has little to no additional CDA.\n-Project may trigger stormwater regulations."]
[null,null,null,1456,"-Pre and post-project land cover square footage must be equivalent.\n-Retrofitting compacted area results in less SRC eligibility than retrofitting impervious area.\n-BMP has little to no additional CDA.\n-Project may trigger stormwater regulations."]
[null,null,null,2345,"-Total Project Area does not match Pre and/or Post project totals.\n-Retrofitting natural area does not result in SRC eligibility.\n-Retrofitting compacted area results in less SRC eligibility than retrofitting impervious area.\n-BMP has little to no additional CDA."]
[null,null,null,2346,"-Total Project Area does not match Pre and/or Post project totals.\n-Retrofitting natural area does not result in SRC eligibility.\n-Retrofitting compacted area results in less SRC eligibility than retrofitting impervious area.\n-Project may trigger stormwater regulations."]
[null,null,null,2456,"-Total Project Area does not match Pre and/or Post project totals.\n-Retrofitting compacted area results in less SRC eligibility than retrofitting impervious area.\n-BMP has little to no additional CDA.\n-Project may trigger stormwater regulations."]
[null,null,null,3456,"-Retrofitting natural area does not result in SRC eligibility.\n-Retrofitting compacted area results in less SRC eligibility than retrofitting impervious area.\n-BMP has little to no additional CDA.\n-Project may trigger stormwater regulations."]
[null,null,null,123,"-Pre and post-project land cover square footage must be equivalent.\n-Total Project Area does not match Pre and/or Post project totals.\n-Retrofitting natural area does not result in SRC eligibility."]
[null,null,null,124,"-Pre and post-project land cover square footage must be equivalent.\n-Total Project Area does not match Pre and/or Post project totals.\n-Retrofitting compacted area results in less SRC eligibility than retrofitting impervious area."]
[null,null,null,125,"-Pre and post-project land cover square footage must be equivalent.\n-Total Project Area does not match Pre and/or Post project totals.\n-BMP has little to no additional CDA."]
[null,null,null,126,"-Pre and post-project land cover square footage must be equivalent.\n-Total Project Area does not match Pre and/or Post project totals.\n-Project may trigger stormwater regulations."]
[null,null,null,134,"-Pre and post-project land cover square footage must be equivalent.\n-Retrofitting natural area does not result in SRC eligibility.\n-Retrofitting compacted area results in less SRC eligibility than retrofitting impervious area."]
[null,null,null,135,"-Pre and post-project land cover square footage must be equivalent.\n-Retrofitting natural area does not result in SRC eligibility.\n-BMP has little to no additional CDA."]
[null,null,null,136,"-Pre and post-project land cover square footage must be equivalent.\n-Retrofitting natural area does not result in SRC eligibility.\n-Project may trigger stormwater regulations."]
[null,null,null,145,"-Pre and post-project land cover square footage must be equivalent.\n-Retrofitting compacted area results in less SRC eligibility than retrofitting impervious area.\n-BMP has little to no additional CDA."]
[null,null,null,146,"-Pre and post-project land cover square footage must be equivalent.\n-Retrofitting compacted area results in less SRC eligibility than retrofitting impervious area.\n-Project may trigger stormwater regulations."]
[null,null,null,234,"-Total Project Area does not match Pre and/or Post project totals.\n-Retrofitting natural area does not result in SRC eligibility.\n-Retrofitting compacted area results in less SRC eligibility than retrofitting impervious area."]
[null,null,null,235,"-Total Project Area does not match Pre and/or Post project totals.\n-Retrofitting natural area does not result in SRC eligibility.\n-BMP has little to no additional CDA."]
[null,null,null,236,"-Total Project Area does not match Pre and/or Post project totals.\n-Retrofitting natural area does not result in SRC eligibility.\n-Project may trigger stormwater regulations."]
[null,null,null,245,"-Total Project Area does not match Pre and/or Post project totals.\n-Retrofitting compacted area results in less SRC eligibility than retrofitting impervious area.\n-BMP has little to no additional CDA."]
[null,null,null,246,"-Total Project Area does not match Pre and/or Post project totals.\n-Retrofitting compacted area results in less SRC eligibility than retrofitting impervious area.\n-Project may trigger stormwater regulations."]
[null,null,null,256,"-Total Project Area does not match Pre and/or Post project totals.\n-BMP has little to no additional CDA.\n-Project may trigger stormwater regulations."]
[null,null,null,345,"-Retrofitting natural area does not result in SRC eligibility.\n-Retrofitting compacted area results in less SRC eligibility than retrofitting impervious area.\n-BMP has little to no additional CDA."]
[null,null,null,346,"-Retrofitting natural area does not result in SRC eligibility.\n-Retrofitting compacted area results in less SRC eligibility than retrofitting impervious area.\n-Project may trigger stormwater regulations."]
[null,null,null,456,"-Retrofitting compacted area results in less SRC eligibility than retrofitting impervious area.\n-BMP has little to no additional CDA.\n-Project may trigger stormwater regulations."]
[null,null,null,12,"-Pre and post-project land cover square footage must be equivalent.\n-Total Project Area does not match Pre and/or Post project totals."]
[null,null,null,13,"-Pre and post-project land cover square footage must be equivalent.\n-Retrofitting natural area does not result in SRC eligibility."]
[null,null,null,14,"-Pre and post-project land cover square footage must be equivalent.\n-Retrofitting compacted area results in less SRC eligibility than retrofitting impervious area."]
[null,null,null,15,"-Pre and post-project land cover square footage must be equivalent.\n-BMP has little to no additional CDA."]
[null,null,null,16,"-Pre and post-project land cover square footage must be equivalent.\n-Project may trigger stormwater regulations."]
[null,null,null,23,"-Total Project Area does not match Pre and/or Post project totals.\n-Retrofitting natural area does not result in SRC eligibility."]
[null,null,null,24,"-Total Project Area does not match Pre and/or Post project totals.\n-Retrofitting compacted area results in less SRC eligibility than retrofitting impervious area."]
[null,null,null,25,"-Total Project Area does not match Pre and/or Post project totals.\n-BMP has little to no additional CDA."]
[null,null,null,26,"-Total Project Area does not match Pre and/or Post project totals.\n-Project may trigger stormwater regulations."]
[null,null,null,34,"-Retrofitting natural area does not result in SRC eligibility.\n-Retrofitting compacted area results in less SRC eligibility than retrofitting impervious area."]
[null,null,null,35,"-Retrofitting natural area does not result in SRC eligibility.\n-BMP has little to no additional CDA."]
[null,null,null,36,"-Retrofitting natural area does not result in SRC eligibility.\n-Project may trigger stormwater regulations."]
[null,null,null,45,"-Retrofitting compacted area results in less SRC eligibility than retrofitting impervious area.\n-BMP has little to no additional CDA."]
[null,null,null,46,"-Retrofitting compacted area results in less SRC eligibility than retrofitting impervious area.\n-Project may trigger stormwater regulations."]
[null,null,null,56,"-BMP has little to no additional CDA.\n-Project may trigger stormwater regulations."]
[null,null,null,1,"-Pre and post-project land cover square footage must be equivalent."]
[null,null,null,2,"-Total Project Area does not match Pre and/or Post project totals."]
[null,null,null,3,"-Retrofitting natural area does not result in SRC eligibility."]
[null,null,null,4,"-Retrofitting compacted area results in less SRC eligibility than retrofitting impervious area."]
[null,null,null,5,"-BMP has little to no additional CDA."]
[null,null,null,6,"-Project may trigger stormwater regulations."]

{"sheet":"2","index":2,"n_rows":33,"n_cols":9,"rows_kept":33,"cut":false,"hidden":true,"merged":[[12,4,13,4],[12,5,13,5],[10,8,10,9],[17,8,17,9],[16,2,16,5],[15,2,15,3],[12,2,12,3],[14,2,14,3],[13,2,13,3],[2,2,2,7],[6,8,6,9],[7,2,7,3],[8,2,8,3],[11,2,11,9],[9,4,9,7],[4,2,4,3],[4,5,4,9],[6,2,6,3],[5,2,5,6],[7,8,7,9],[8,8,8,9]]}
[]
[]
[null,null,"Enter Land Cover Type Area\nIf land cover information is unavailable, the calculator will assume 100% impervious land cover pre-project and 90% impervious and 10% BMP post-project land cover."]
[]
[null,null,"Total Project Area (ft2):ii",null,{"$f":"Overview!I28","v":0},{"$f":"IF(OR(I8>0,I9>0),\" \",\"  For a more detailed estimate, include land cover square footage below.\")","v":"  For a more detailed estimate, include land cover square footage below."}]
[null,null,{"$f":"IF(MS4_MLD=\"MSI\",\"*Please include building footprint in the land cover information.\",\"\")","v":""}]
[null,null,"Land Cover Type:",null,"Natural","Compacted","Impervious","BMP","Total"]
[null,null,"Post-project  (ft2)",null,null,null,null,null,{"$f":"SUM(E8:H8)","v":0}]
[null,null,"Pre-project   (ft2)",null,null,null,null,null,{"$f":"SUM(E9:H9)","v":0}]
[null,null,null,null,{"$f":"IF(H25=\"123\",D27,IF(H25=\"12\",D28,IF(H25=\"13\",D29,IF(H25=\"23\",D30,IF(H25=\"1\",D31,IF(H25=\"2\",D32,IF(H25=\"3\",D33,\"\")))))))","v":""}]
[null,null,"Stormwater Retention Volume (SWRv) Requirement",null,null,null,null,null,{"$f":"IF(MS4_MLD=\"\",\"\",IF(MS4_MLD=\"MLD\",1.2,IF(AND(Price_AWDZ=\"Yes\",MS4_MLD=\"MSI\"),1,0.8)))","v":""}]
[null,null,"*SRC eligibility is achieved by retaining stormwater in excess of the regulatory requirement in a 1.7 inch storm."]
[null,null,"Regulatory Requirement",null,"ft2","gal"]
[null,null,{"$f":"IF(MS4_MLD=\"MLD\",\"Major Land Disturbing\",IF(MS4_MLD=\"MSI\",\"Major Substantial Improvement\",IF(Activity=\"Voluntary\",\"Voluntary Retrofit\",\"\")))","v":"Voluntary Retrofit"}]
[null,null,"SWRV",null,{"$f":"IFERROR(IF(I8<1,(I11/12*(E5*References!B18)),(I11/12*((E8*References!B16)+(F8*References!B17)+(G17*References!B18)+(H17*References!B18)))),\"N/A\")","v":"N/A"},{"$f":"IFERROR(E15*7.48,\"N/A\")","v":"N/A"},{"$f":"IF(Activity=\"Voluntary\",0-(1.7/12*(E9+F9*0.75+G9*0.05+H9*0.05))+(1.7/12*(E8+F8*0.75+G8*0.05+H8*0.05)),0)","v":0}]
[null,null,"WQTV",null,{"$f":"IF(Price_AWDZ=\"Yes\",IF(I8<1,(1.7/12*(E5*References!B18)-E15),(1.7/12*(E8*References!B16+'2'!F8*References!B17+G17*References!B18+H17*References!B18))-E15),\"N/A\")","v":"N/A"},{"$f":"IFERROR(E16*7.48,\"N/A\")","v":"N/A"},{"$f":"IF(SUM(E9:H9)=0,E5,G9)","v":0}]
[null,null,"*For AWDZ Projects, the SWRv requirement for MSI activities is based on the 1.0-inch storm event. For MLD activities the SWRv requirement is based on the 1.2-inch storm event.  All AWDZ sites must meet a Water Quality Treatment Volume (WQTv) that is based on a 1.7-inch storm event.  These projects only achieve SRC eligibility by retaining stormwater runoff from non-regulated areas.",null,null,null,{"$f":"IF(SUM(E8:H8)=0,E5*0.9,G8)","v":0},{"$f":"IF(SUM(E8:H8)=0,E5*0.1,H8)","v":0}]
[null,null,{"$f":"HYPERLINK(\"#'Overview'!i16\",\"Go Back\")","v":"Go Back"},null,null,null,null,null,{"$f":"IF(I8<>I9,HYPERLINK(\"#2!c23\",\"Continue\"),HYPERLINK(\"#'BMP Design'!d6\",\"Continue\"))","v":"Continue"}]
[]
[]
[null,null,null,{"$f":"IF(SUM(E8:H8)=SUM(E9:H9),\"\",\"Pre and post-project land cover square footage must be equivalent\")","v":""},null,null,null,{"$f":"IF(D21=\"\",\"\",1)","v":""}]
[null,null,null,{"$f":"IF(OR(E5<>I8,E5<>I9),\"Total Project Area does not match pre and/or Post project totals\",\"\")","v":""},null,null,null,{"$f":"IF(D22=\"\",\"\",2)","v":""}]
[null,null,null,{"$f":"IFERROR(IF(H8/I8>0.9,\"BMP has little to no additional CDA\",\"\"),\"\")","v":""},null,null,null,{"$f":"IF(D23=\"\",\"\",3)","v":""}]
[]
[null,null,null,null,null,null,null,{"$f":"H21&H22&H23","v":""}]
[]
[null,null,123,"-Pre and post-project land cover square footage must be equivalent.\n-Total Project Area does not match Pre and/or Post project totals.\n-BMP has little to no additional CDA."]
[null,null,12,"-Pre and post-project land cover square footage must be equivalent.\n-Total Project Area does not match Pre and/or Post project totals."]
[null,null,13,"-Pre and post-project land cover square footage must be equivalent.\n-BMP has little to no additional CDA."]
[null,null,23,"-Total Project Area does not Match Pre and/or Post Project totals.\n-BMP has little to no additional CDA."]
[null,null,1,"-Pre and post-project land cover square footage must be equivalent."]
[null,null,2,"-Total Project Area does not match Pre and/or Post project totals."]
[null,null,3,"-BMP has little to no additional CDA."]

{"sheet":"BMP Design","index":3,"n_rows":26,"n_cols":38,"rows_kept":26,"cut":false,"hidden":false,"merged":[[21,2,21,3],[8,5,8,6],[9,5,9,6],[10,5,10,6],[11,5,11,6],[12,5,12,6],[13,5,13,6],[14,5,14,6],[15,5,15,6],[16,5,16,6],[17,5,17,6],[16,3,16,4],[17,3,17,4],[10,3,10,4],[11,3,11,4],[13,3,13,4],[14,3,14,4],[15,3,15,4],[4,29,5,29],[4,22,5,22],[4,26,5,26],[4,27,5,27],[4,21,5,21],[5,3,5,4],[6,3,6,4],[7,3,7,4],[8,3,8,4],[9,3,9,4],[7,5,7,6],[3,20,5,20],[3,25,5,25],[3,32,5,32],[6,30,6,31],[7,30,7,31],[8,30,8,31],[12,3,12,4],[3,7,3,10],[3,28,5,28],[6,5,6,6],[2,2,2,30],[4,7,4,10],[4,18,5,18],[4,12,5,12],[4,14,5,14],[4,16,5,16],[4,13,5,13],[4,15,5,15],[4,17,5,17],[4,11,5,11],[5,5,5,6],[3,2,4,4],[3,5,4,6],[3,30,5,31],[20,7,20,10],[15,30,15,31],[16,30,16,31],[17,30,17,31],[9,30,9,31],[10,30,10,31],[11,30,11,31],[12,30,12,31],[13,30,13,31],[18,30,18,31],[14,30,14,31]]}
[]
[]
[null,null,"Enter Project BMP Design Information\nIf BMP design information is unavailable, you may leave this page blank to assume BMPs manage the 1.7-inch storm across the Total Project Area.\nTo estimate more accurate retention volume and project costs, enter BMP Type, BMP Subtype, and Contributing Drainage Area.  If unavailable, Storage Volume information may be left blank."]
[null,null,"BMP",null,null,"BMP Subtype",null,"Contributing Drainage Area (CDA) (ft2)",null,null,null,null,null,null,null,null,null,null,null,null,"Storage Volume (ft3)",null,null,null,null,"Receiving Area (ft2)",null,null,"Number of Trees",null,"BMP Retention Vol. Achieved (ft3)",null,"BMP Retention Vol. Achieved (gal)"]
[null,null,null,null,null,null,null,"CDA Required",null,null,null,"COUNTA","Nat ft2\nCalc","If Nat Blank","Comp ft2\nCalc","If Comp Blank","IMP ft2\nCalc","If IMP Blank","BMP ft2\nCalc",null,null,"If Sv Blank","RWH Sv Conv",null,null,null,"Ra Calc","If Ra Blank",null,"Retention Value"]
[null,null,null,"BMP Type and Subtype do not match",null,"BMP Subtype Required",null,"Natural","Compacted","Impervious","BMP",null,null,null,null,null,null,null,null,"If BMP Blank",null,null,null,"1.7 Rv","if blank"]
[null,null,"1.",null,null,null,null,null,null,null,null,{"$f":"IF(SUM(H7:K7)>0,1,\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(H7),N7,H7),0)","v":0},{"$f":"IFERROR(IF(OR(SUM(H7:K7)>0,COUNTA(F7)=0),0,Background!$E$22-SUM($H$7:$H$18))/(COUNTA('BMP Design'!$F$7:$F$18)-COUNT($L$7:$L$18)),0)","v":0},{"$f":"IFERROR(IF(ISBLANK(I7),P7,I7),0)","v":0},{"$f":"IFERROR(IF(OR(SUM(H7:K7)>0,COUNTA(F7)=0),0,Background!$F$22-SUM($I$7:$I$18))/(COUNTA('BMP Design'!$F$7:$F$18)-COUNT($L$7:$L$18)),0)","v":0},{"$f":"IFERROR(IF(ISBLANK(J7),R7,J7),0)","v":0},{"$f":"IFERROR(IF(OR(SUM(H7:K7)>0,COUNTA(F7)=0),0,Background!$G$22-SUM($J$7:$J$18))/(COUNTA('BMP Design'!$F$7:$F$18)-COUNT($J$7:$J$18)),0)","v":0},{"$f":"IFERROR(IF(ISBLANK(K7),T7,K7),0)","v":0},{"$f":"IFERROR(IF(OR(SUM(H7:K7)>0,COUNTA(F7)=0),0,Background!$H$22-SUM($J$7:$J$18))/(COUNTA('BMP Design'!$E$7:$E$18)-COUNT($K$7:$K$18)),0)","v":0},null,{"$f":"IF(ISBLANK(U7),X7,U7)","v":0},{"$f":"IF(F7=\"Rainwater harvesting\",((References!$E$2*X7)*7.48),\"\")","v":""},{"$f":"IF(D7=\"Tree Planting and Preservation\",\"Tree\",1.7/12*(M7*0.05+O7*0.25+Q7*0.95+S7*0.95))","v":0},{"$f":"IF(ISBLANK(U7),X7,U7)","v":0},null,{"$f":"IF(ISBLANK(Z7),AB7,Z7)","v":0},{"$f":"IF(E7=\"Simple disconnection to amended soils\",(W7/40)*100,IF(E7=\"Simple disconnection to a conservation area\",(W7/60)*100,IF(E7=\"Simple disconnection to a pervious area\",(W7/20)*100,0)))","v":0},null,{"$f":"IFERROR(IF(F7=\"Permeable pavement - Standard\",K7*0.045,(INDIRECT(AI7))),\"\")","v":""},{"$f":"IF(D7=\"Tree Planting and Preservation\",AD7,IF(OR(D7=\"\",F7=\"\",SUM(H7:K7)=0),0,IFERROR(IF(AD7>1,MIN(AD7,Y7),MIN((AD7*Y7),(1.7/12*(M7*References!$B$16+O7*References!$B$17+Q7*References!$B$18+S7*References!$B$18)))),\"0.0\")))","v":0},null,{"$f":"IFERROR(AE7*7.48,0)","v":0},{"$f":"IF(D7=\"\",\"\",IF(D7=\"Green Roof\",\"Green\",IF(D7=\"Rainwater Harvesting\",\"Rainwater\",IF(D7=\"Impervious Surface Disconnection\",\"Impervious\",IF(D7=\"Permeable Pavement\",\"Permeable\",IF(D7=\"Tree Planting and Preservation\",\"Tree\",IF(D7=\"Open Channel\",\"Open\",D7)))))))","v":""},{"$f":"IF(F7=\"\",\"\",IF(F7=\"Extensive green roof\",\"Extensive\",IF(F7=\"Intensive green roof\",\"Intensive\",IF(F7=\"Rainwater harvesting\",\"RWHarvest\",IF(F7=\"Disconnection to a conservation area\",\"Conservation\",IF(F7=\"Disconnection to amended soils\",\"IDAmended\",IF(F7=\"Disconnection to a pervious area\",\"Pervious\",IF(F7=\"Permeable pavement - Enhanced\",\"PPEnhanced\",IF(F7=\"Permeable pavement - Standard\",\"PPStandard\",IF(F7=\"Bioretention - Enhanced\",\"BioEnhanced\",IF(F7=\"Bioretention - Standard\",\"BioStandard\",IF(F7=\"Infiltration trench\",\"Trench\",IF(F7=\"Infiltration basin\",\"Basin\",IF(F7=\"Grass channel\",\"Grass\",IF(F7=\"Grass channel - amended soils\",\"GCAmended\",IF(F7=\"Dry swale\",\"DrySwale\",IF(F7=\"wet swale\",\"WetSwale\",IF(F7=\"Micropool ED pond\",\"Micropool\",IF(F7=\"Wet pond\",\"WetPond\",IF(F7=\"Wet ED pond\",\"EDPond\",IF(F7=\"Shallow wetland\",\"Shallow\",IF(F7=\"ED shallow wetland\",\"EDWet\",IF(F7=\"Tree preservation\",\"Preservation\",IF(F7=\"Tree planting\",\"Planting\"))))))))))))))))))))))))","v":""},{"$f":"VLOOKUP(D7,Match,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(F7,Match1,2,0)","v":{"$error":"#N/A"}},{"$f":"IF(AJ7=AK7,\"\",1)","v":{"$error":"#N/A"}}]
[null,null,"2.",null,null,null,null,null,null,null,null,{"$f":"IF(SUM(H8:K8)>0,1,\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(H8),N8,H8),0)","v":0},{"$f":"IFERROR(IF(OR(SUM(H8:K8)>0,COUNTA(F8)=0),0,Background!$E$22-SUM($H$7:$H$18))/(COUNTA('BMP Design'!$F$7:$F$18)-COUNT($L$7:$L$18)),0)","v":0},{"$f":"IFERROR(IF(ISBLANK(I8),P8,I8),0)","v":0},{"$f":"IFERROR(IF(OR(SUM(H8:K8)>0,COUNTA(F8)=0),0,Background!$F$22-SUM($I$7:$I$18))/(COUNTA('BMP Design'!$F$7:$F$18)-COUNT($L$7:$L$18)),0)","v":0},{"$f":"IFERROR(IF(ISBLANK(J8),R8,J8),0)","v":0},{"$f":"IFERROR(IF(OR(SUM(H8:K8)>0,COUNTA(F8)=0),0,Background!$G$22-SUM($J$7:$J$18))/(COUNTA('BMP Design'!$F$7:$F$18)-COUNT($J$7:$J$18)),0)","v":0},{"$f":"IFERROR(IF(ISBLANK(K8),T8,K8),0)","v":0},{"$f":"IFERROR(IF(OR(SUM(H8:K8)>0,COUNTA(F8)=0),0,Background!$H$22-SUM($J$7:$J$18))/(COUNTA('BMP Design'!$E$7:$E$18)-COUNT($K$7:$K$18)),0)","v":0},null,{"$f":"IF(ISBLANK(U8),W8,U8)","v":""},{"$f":"IF(F8=\"Rainwater harvesting\",((References!$E$2*X8)*7.48),\"\")","v":""},0,{"$f":"IF(ISBLANK(U8),X8,U8)","v":0},null,{"$f":"IF(ISBLANK(Z8),AB8,Z8)","v":0},0,null,{"$f":"IFERROR(IF(F8=\"Permeable pavement - Standard\",K8*0.045,(INDIRECT(AI8))),\"\")","v":""},{"$f":"IF(D8=\"Tree Planting and Preservation\",AD8,IF(OR(D8=\"\",F8=\"\",SUM(H8:K8)=0),0,IFERROR(IF(AD8>1,MIN(AD8,Y8),MIN((AD8*Y8),(1.7/12*(M8*References!$B$16+O8*References!$B$17+Q8*References!$B$18+S8*References!$B$18)))),\"0.0\")))","v":0},null,{"$f":"IFERROR(AE8*7.48,0)","v":0},"","",{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AJ8=AK8,\"\",1)","v":{"$error":"#N/A"}}]
[null,null,"3.",null,null,null,null,null,null,null,null,"",0,{"$f":"IFERROR(IF(OR(SUM(H9:K9)>0,COUNTA(F9)=0),0,Background!$E$22-SUM($H$7:$H$18))/(COUNTA('BMP Design'!$F$7:$F$18)-COUNT($L$7:$L$18)),0)","v":0},0,{"$f":"IFERROR(IF(OR(SUM(H9:K9)>0,COUNTA(F9)=0),0,Background!$F$22-SUM($I$7:$I$18))/(COUNTA('BMP Design'!$F$7:$F$18)-COUNT($L$7:$L$18)),0)","v":0},0,{"$f":"IFERROR(IF(OR(SUM(H9:K9)>0,COUNTA(F9)=0),0,Background!$G$22-SUM($J$7:$J$18))/(COUNTA('BMP Design'!$F$7:$F$18)-COUNT($J$7:$J$18)),0)","v":0},0,{"$f":"IFERROR(IF(OR(SUM(H9:K9)>0,COUNTA(F9)=0),0,Background!$H$22-SUM($J$7:$J$18))/(COUNTA('BMP Design'!$E$7:$E$18)-COUNT($K$7:$K$18)),0)","v":0},null,"",{"$f":"IF(F9=\"Rainwater harvesting\",((References!$E$2*X9)*7.48),\"\")","v":""},0,0,null,0,0,null,"",{"$f":"IF(D9=\"Tree Planting and Preservation\",AD9,IF(OR(D9=\"\",F9=\"\",SUM(H9:K9)=0),0,IFERROR(IF(AD9>1,MIN(AD9,Y9),MIN((AD9*Y9),(1.7/12*(M9*References!$B$16+O9*References!$B$17+Q9*References!$B$18+S9*References!$B$18)))),\"0.0\")))","v":0},null,0,"","",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,"4.",null,null,null,null,null,null,null,null,"",0,{"$f":"IFERROR(IF(OR(SUM(H10:K10)>0,COUNTA(F10)=0),0,Background!$E$22-SUM($H$7:$H$18))/(COUNTA('BMP Design'!$F$7:$F$18)-COUNT($L$7:$L$18)),0)","v":0},0,{"$f":"IFERROR(IF(OR(SUM(H10:K10)>0,COUNTA(F10)=0),0,Background!$F$22-SUM($I$7:$I$18))/(COUNTA('BMP Design'!$F$7:$F$18)-COUNT($L$7:$L$18)),0)","v":0},0,{"$f":"IFERROR(IF(OR(SUM(H10:K10)>0,COUNTA(F10)=0),0,Background!$G$22-SUM($J$7:$J$18))/(COUNTA('BMP Design'!$F$7:$F$18)-COUNT($J$7:$J$18)),0)","v":0},0,{"$f":"IFERROR(IF(OR(SUM(H10:K10)>0,COUNTA(F10)=0),0,Background!$H$22-SUM($J$7:$J$18))/(COUNTA('BMP Design'!$E$7:$E$18)-COUNT($K$7:$K$18)),0)","v":0},null,"",{"$f":"IF(F10=\"Rainwater harvesting\",((References!$E$2*X10)*7.48),\"\")","v":""},0,0,null,0,0,null,"",{"$f":"IF(D10=\"Tree Planting and Preservation\",AD10,IF(OR(D10=\"\",F10=\"\",SUM(H10:K10)=0),0,IFERROR(IF(AD10>1,MIN(AD10,Y10),MIN((AD10*Y10),(1.7/12*(M10*References!$B$16+O10*References!$B$17+Q10*References!$B$18+S10*References!$B$18)))),\"0.0\")))","v":0},null,0,"","",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,"5.",null,null,null,null,null,null,null,null,"",0,{"$f":"IFERROR(IF(OR(SUM(H11:K11)>0,COUNTA(F11)=0),0,Background!$E$22-SUM($H$7:$H$18))/(COUNTA('BMP Design'!$F$7:$F$18)-COUNT($L$7:$L$18)),0)","v":0},0,{"$f":"IFERROR(IF(OR(SUM(H11:K11)>0,COUNTA(F11)=0),0,Background!$F$22-SUM($I$7:$I$18))/(COUNTA('BMP Design'!$F$7:$F$18)-COUNT($L$7:$L$18)),0)","v":0},0,{"$f":"IFERROR(IF(OR(SUM(H11:K11)>0,COUNTA(F11)=0),0,Background!$G$22-SUM($J$7:$J$18))/(COUNTA('BMP Design'!$F$7:$F$18)-COUNT($J$7:$J$18)),0)","v":0},0,{"$f":"IFERROR(IF(OR(SUM(H11:K11)>0,COUNTA(F11)=0),0,Background!$H$22-SUM($J$7:$J$18))/(COUNTA('BMP Design'!$E$7:$E$18)-COUNT($K$7:$K$18)),0)","v":0},null,"",{"$f":"IF(F11=\"Rainwater harvesting\",((References!$E$2*X11)*7.48),\"\")","v":""},0,0,null,0,0,null,"",{"$f":"IF(D11=\"Tree Planting and Preservation\",AD11,IF(OR(D11=\"\",F11=\"\",SUM(H11:K11)=0),0,IFERROR(IF(AD11>1,MIN(AD11,Y11),MIN((AD11*Y11),(1.7/12*(M11*References!$B$16+O11*References!$B$17+Q11*References!$B$18+S11*References!$B$18)))),\"0.0\")))","v":0},null,0,"","",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,"6.",null,null,null,null,null,null,null,null,"",0,{"$f":"IFERROR(IF(OR(SUM(H12:K12)>0,COUNTA(F12)=0),0,Background!$E$22-SUM($H$7:$H$18))/(COUNTA('BMP Design'!$F$7:$F$18)-COUNT($L$7:$L$18)),0)","v":0},0,{"$f":"IFERROR(IF(OR(SUM(H12:K12)>0,COUNTA(F12)=0),0,Background!$F$22-SUM($I$7:$I$18))/(COUNTA('BMP Design'!$F$7:$F$18)-COUNT($L$7:$L$18)),0)","v":0},0,{"$f":"IFERROR(IF(OR(SUM(H12:K12)>0,COUNTA(F12)=0),0,Background!$G$22-SUM($J$7:$J$18))/(COUNTA('BMP Design'!$F$7:$F$18)-COUNT($J$7:$J$18)),0)","v":0},0,{"$f":"IFERROR(IF(OR(SUM(H12:K12)>0,COUNTA(F12)=0),0,Background!$H$22-SUM($J$7:$J$18))/(COUNTA('BMP Design'!$E$7:$E$18)-COUNT($K$7:$K$18)),0)","v":0},null,"",{"$f":"IF(F12=\"Rainwater harvesting\",((References!$E$2*X12)*7.48),\"\")","v":""},0,0,null,0,0,null,"",{"$f":"IF(D12=\"Tree Planting and Preservation\",AD12,IF(OR(D12=\"\",F12=\"\",SUM(H12:K12)=0),0,IFERROR(IF(AD12>1,MIN(AD12,Y12),MIN((AD12*Y12),(1.7/12*(M12*References!$B$16+O12*References!$B$17+Q12*References!$B$18+S12*References!$B$18)))),\"0.0\")))","v":0},null,0,"","",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,"7.",null,null,null,null,null,null,null,null,"",0,{"$f":"IFERROR(IF(OR(SUM(H13:K13)>0,COUNTA(F13)=0),0,Background!$E$22-SUM($H$7:$H$18))/(COUNTA('BMP Design'!$F$7:$F$18)-COUNT($L$7:$L$18)),0)","v":0},0,{"$f":"IFERROR(IF(OR(SUM(H13:K13)>0,COUNTA(F13)=0),0,Background!$F$22-SUM($I$7:$I$18))/(COUNTA('BMP Design'!$F$7:$F$18)-COUNT($L$7:$L$18)),0)","v":0},0,{"$f":"IFERROR(IF(OR(SUM(H13:K13)>0,COUNTA(F13)=0),0,Background!$G$22-SUM($J$7:$J$18))/(COUNTA('BMP Design'!$F$7:$F$18)-COUNT($J$7:$J$18)),0)","v":0},0,{"$f":"IFERROR(IF(OR(SUM(H13:K13)>0,COUNTA(F13)=0),0,Background!$H$22-SUM($J$7:$J$18))/(COUNTA('BMP Design'!$E$7:$E$18)-COUNT($K$7:$K$18)),0)","v":0},null,"",{"$f":"IF(F13=\"Rainwater harvesting\",((References!$E$2*X13)*7.48),\"\")","v":""},0,0,null,0,0,null,"",{"$f":"IF(D13=\"Tree Planting and Preservation\",AD13,IF(OR(D13=\"\",F13=\"\",SUM(H13:K13)=0),0,IFERROR(IF(AD13>1,MIN(AD13,Y13),MIN((AD13*Y13),(1.7/12*(M13*References!$B$16+O13*References!$B$17+Q13*References!$B$18+S13*References!$B$18)))),\"0.0\")))","v":0},null,0,"","",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,"8.",null,null,null,null,null,null,null,null,"",0,{"$f":"IFERROR(IF(OR(SUM(H14:K14)>0,COUNTA(F14)=0),0,Background!$E$22-SUM($H$7:$H$18))/(COUNTA('BMP Design'!$F$7:$F$18)-COUNT($L$7:$L$18)),0)","v":0},0,{"$f":"IFERROR(IF(OR(SUM(H14:K14)>0,COUNTA(F14)=0),0,Background!$F$22-SUM($I$7:$I$18))/(COUNTA('BMP Design'!$F$7:$F$18)-COUNT($L$7:$L$18)),0)","v":0},0,{"$f":"IFERROR(IF(OR(SUM(H14:K14)>0,COUNTA(F14)=0),0,Background!$G$22-SUM($J$7:$J$18))/(COUNTA('BMP Design'!$F$7:$F$18)-COUNT($J$7:$J$18)),0)","v":0},0,{"$f":"IFERROR(IF(OR(SUM(H14:K14)>0,COUNTA(F14)=0),0,Background!$H$22-SUM($J$7:$J$18))/(COUNTA('BMP Design'!$E$7:$E$18)-COUNT($K$7:$K$18)),0)","v":0},null,"",{"$f":"IF(F14=\"Rainwater harvesting\",((References!$E$2*X14)*7.48),\"\")","v":""},0,0,null,0,0,null,"",{"$f":"IF(D14=\"Tree Planting and Preservation\",AD14,IF(OR(D14=\"\",F14=\"\",SUM(H14:K14)=0),0,IFERROR(IF(AD14>1,MIN(AD14,Y14),MIN((AD14*Y14),(1.7/12*(M14*References!$B$16+O14*References!$B$17+Q14*References!$B$18+S14*References!$B$18)))),\"0.0\")))","v":0},null,0,"","",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,"9.",null,null,null,null,null,null,null,null,"",0,{"$f":"IFERROR(IF(OR(SUM(H15:K15)>0,COUNTA(F15)=0),0,Background!$E$22-SUM($H$7:$H$18))/(COUNTA('BMP Design'!$F$7:$F$18)-COUNT($L$7:$L$18)),0)","v":0},0,{"$f":"IFERROR(IF(OR(SUM(H15:K15)>0,COUNTA(F15)=0),0,Background!$F$22-SUM($I$7:$I$18))/(COUNTA('BMP Design'!$F$7:$F$18)-COUNT($L$7:$L$18)),0)","v":0},0,{"$f":"IFERROR(IF(OR(SUM(H15:K15)>0,COUNTA(F15)=0),0,Background!$G$22-SUM($J$7:$J$18))/(COUNTA('BMP Design'!$F$7:$F$18)-COUNT($J$7:$J$18)),0)","v":0},0,{"$f":"IFERROR(IF(OR(SUM(H15:K15)>0,COUNTA(F15)=0),0,Background!$H$22-SUM($J$7:$J$18))/(COUNTA('BMP Design'!$E$7:$E$18)-COUNT($K$7:$K$18)),0)","v":0},null,"",{"$f":"IF(F15=\"Rainwater harvesting\",((References!$E$2*X15)*7.48),\"\")","v":""},0,0,null,0,0,null,"",{"$f":"IF(D15=\"Tree Planting and Preservation\",AD15,IF(OR(D15=\"\",F15=\"\",SUM(H15:K15)=0),0,IFERROR(IF(AD15>1,MIN(AD15,Y15),MIN((AD15*Y15),(1.7/12*(M15*References!$B$16+O15*References!$B$17+Q15*References!$B$18+S15*References!$B$18)))),\"0.0\")))","v":0},null,0,"","",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,"10.",null,null,null,null,null,null,null,null,"",0,{"$f":"IFERROR(IF(OR(SUM(H16:K16)>0,COUNTA(F16)=0),0,Background!$E$22-SUM($H$7:$H$18))/(COUNTA('BMP Design'!$F$7:$F$18)-COUNT($L$7:$L$18)),0)","v":0},0,{"$f":"IFERROR(IF(OR(SUM(H16:K16)>0,COUNTA(F16)=0),0,Background!$F$22-SUM($I$7:$I$18))/(COUNTA('BMP Design'!$F$7:$F$18)-COUNT($L$7:$L$18)),0)","v":0},0,{"$f":"IFERROR(IF(OR(SUM(H16:K16)>0,COUNTA(F16)=0),0,Background!$G$22-SUM($J$7:$J$18))/(COUNTA('BMP Design'!$F$7:$F$18)-COUNT($J$7:$J$18)),0)","v":0},0,{"$f":"IFERROR(IF(OR(SUM(H16:K16)>0,COUNTA(F16)=0),0,Background!$H$22-SUM($J$7:$J$18))/(COUNTA('BMP Design'!$E$7:$E$18)-COUNT($K$7:$K$18)),0)","v":0},null,"",{"$f":"IF(F16=\"Rainwater harvesting\",((References!$E$2*X16)*7.48),\"\")","v":""},0,0,null,0,0,null,"",{"$f":"IF(D16=\"Tree Planting and Preservation\",AD16,IF(OR(D16=\"\",F16=\"\",SUM(H16:K16)=0),0,IFERROR(IF(AD16>1,MIN(AD16,Y16),MIN((AD16*Y16),(1.7/12*(M16*References!$B$16+O16*References!$B$17+Q16*References!$B$18+S16*References!$B$18)))),\"0.0\")))","v":0},null,0,"","",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,"11.",null,null,null,null,null,null,null,null,"",0,{"$f":"IFERROR(IF(OR(SUM(H17:K17)>0,COUNTA(F17)=0),0,Background!$E$22-SUM($H$7:$H$18))/(COUNTA('BMP Design'!$F$7:$F$18)-COUNT($L$7:$L$18)),0)","v":0},0,{"$f":"IFERROR(IF(OR(SUM(H17:K17)>0,COUNTA(F17)=0),0,Background!$F$22-SUM($I$7:$I$18))/(COUNTA('BMP Design'!$F$7:$F$18)-COUNT($L$7:$L$18)),0)","v":0},0,{"$f":"IFERROR(IF(OR(SUM(H17:K17)>0,COUNTA(F17)=0),0,Background!$G$22-SUM($J$7:$J$18))/(COUNTA('BMP Design'!$F$7:$F$18)-COUNT($J$7:$J$18)),0)","v":0},0,{"$f":"IFERROR(IF(OR(SUM(H17:K17)>0,COUNTA(F17)=0),0,Background!$H$22-SUM($J$7:$J$18))/(COUNTA('BMP Design'!$E$7:$E$18)-COUNT($K$7:$K$18)),0)","v":0},null,"",{"$f":"IF(F17=\"Rainwater harvesting\",((References!$E$2*X17)*7.48),\"\")","v":""},0,0,null,0,0,null,"",{"$f":"IF(D17=\"Tree Planting and Preservation\",AD17,IF(OR(D17=\"\",F17=\"\",SUM(H17:K17)=0),0,IFERROR(IF(AD17>1,MIN(AD17,Y17),MIN((AD17*Y17),(1.7/12*(M17*References!$B$16+O17*References!$B$17+Q17*References!$B$18+S17*References!$B$18)))),\"0.0\")))","v":0},null,0,"","",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,"12.",null,null,null,null,null,null,null,null,"",0,{"$f":"IFERROR(IF(OR(SUM(H18:K18)>0,COUNTA(F18)=0),0,Background!$E$22-SUM($H$7:$H$18))/(COUNTA('BMP Design'!$F$7:$F$18)-COUNT($L$7:$L$18)),0)","v":0},0,{"$f":"IFERROR(IF(OR(SUM(H18:K18)>0,COUNTA(F18)=0),0,Background!$F$22-SUM($I$7:$I$18))/(COUNTA('BMP Design'!$F$7:$F$18)-COUNT($L$7:$L$18)),0)","v":0},0,{"$f":"IFERROR(IF(OR(SUM(H18:K18)>0,COUNTA(F18)=0),0,Background!$G$22-SUM($J$7:$J$18))/(COUNTA('BMP Design'!$F$7:$F$18)-COUNT($J$7:$J$18)),0)","v":0},0,{"$f":"IFERROR(IF(OR(SUM(H18:K18)>0,COUNTA(F18)=0),0,Background!$H$22-SUM($J$7:$J$18))/(COUNTA('BMP Design'!$E$7:$E$18)-COUNT($K$7:$K$18)),0)","v":0},null,"",{"$f":"IF(F18=\"Rainwater harvesting\",((References!$E$2*X18)*7.48),\"\")","v":""},0,0,null,0,0,null,"",{"$f":"IF(D18=\"Tree Planting and Preservation\",AD18,IF(OR(D18=\"\",F18=\"\",SUM(H18:K18)=0),0,IFERROR(IF(AD18>1,MIN(AD18,Y18),MIN((AD18*Y18),(1.7/12*(M18*References!$B$16+O18*References!$B$17+Q18*References!$B$18+S18*References!$B$18)))),\"0.0\")))","v":0},null,{"$f":"IFERROR(AE18*7.48,\"\")","v":0},"","",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,"BMP CDA Total",{"$f":"SUM(H7:H18)","v":0},{"$f":"SUM(I7:I18)","v":0},0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Rv (gal):",null,{"$f":"IF(AND(SUM(AG7:AG18)=0,(COUNTA(D7:D18)+COUNTA(F7:F18)=0)),AG20,(SUM(AG7:AG18)))","v":0},null,null,null,null,{"$f":"COUNTIF(AL7:AL18,1)","v":0}]
[null,null,null,null,null,null,{"$f":"IF(Activity=\"Voluntary\",\"Project Area\",IF(Activity=\"Regulated\",\"Project LOD\",\"\"))","v":"Project Area"},{"$f":"Background!E22","v":0},{"$f":"Background!F22","v":0},{"$f":"Background!G22","v":0},{"$f":"Background!H22","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(CDA)<Background!I22,\"*Project has unmanaged area\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"((1.7/12*(Background!E22*0.05+Background!F22*0.25+Background!G22*0.95+Background!H22*0.95)*7.48))","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(U23=1,\"Natural area CDA exceeds post-project land cover information.\",IF(U23=1.1,\"Compacted area CDA exceeds post-project land cover information.\",IF(U23=1.3,\"Impervious area CDA exceeds post-project land cover information.\",IF(U23=1.5,\"BMP area CDA exceeds post-project land cover information.\",IF(U23=2.1,\"Natural and compacted area CDAs exceed post-project land cover information.\",IF(U23=2.3,\"Natural and impervious area CDAs exceed post-project land cover information.\",IF(U23=2.5,\"Natural and BMP area CDAs exceed post-project land cover information.\",IF(U23=2.4,\"Compcated and impervious area CDAs exceed post-project land cover information.\",IF(U23=2.6,\"Compacted and BMP area CDAs exceed post-project land cover information.\",IF(U23=2.8,\"Impervious and BMP area CDAs exceed post-project land cover information.\",IF(U23=3.4,\"Natural, compacted and impervious area CDAs exceed post-project land cover information.\",IF(U23=3.6,\"Natural, compacted, and BMP area CDAs exceed post-project land cover information.\",IF(U23=3.8,\"Natural, impervious, and BMP area CDAs exceed post-project land cover information.\",IF(U23=3.9,\"Compacted, impervious, and BMP area CDAs exceed post-project land cover information.\",IF(U23=4.9,\"All land cover areas CDAs exceed post-project land cover information.\",IF(AND(Activity=\"Regulated\",SUM(CDA)>Background!I22),\"BMP(s) have CDA outside of the LOD\",\"\"))))))))))))))))","v":""},null,null,null,{"$f":"IF(AND(Activity=\"Voluntary\",Post>0,SUM(L7:L18)>Background!I22),1,\"\")","v":""},{"$f":"IF(AND(Activity=\"Voluntary\",Post>0,SUM(M7:M18)>Background!J22),1,\"\")","v":""},{"$f":"IF(AND(Activity=\"Voluntary\",Post>0,SUM(N7:N18)>Background!K22),1,\"\")","v":""},{"$f":"IF(AND(Activity=\"Voluntary\",Post>0,SUM(O7:O18)>Background!L22),1,\"\")","v":""},{"$f":"IF(AND(Activity=\"Voluntary\",Post>0,SUM(P7:P18)>Background!M22),1,\"\")","v":""},{"$f":"IF(AND(Activity=\"Voluntary\",Post>0,SUM(Q7:Q18)>Background!N22),1,\"\")","v":""},{"$f":"IF(AND(Activity=\"Voluntary\",Post>0,SUM(R7:R18)>Background!O22),1,\"\")","v":""},{"$f":"IF(AND(Activity=\"Voluntary\",Post>0,SUM(S7:S18)>Background!P22),1,\"\")","v":""},{"$f":"IF(AND(Activity=\"Voluntary\",Post>0,SUM(T7:T18)>Background!Q22),1,\"\")","v":""}]
[null,null,"Return to Overview",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Activity=\"Voluntary\",HYPERLINK(\"#1!e5\",\"Go Back\"),HYPERLINK(\"#2!e5\",\"Go Back\"))","v":"Go Back"},null,{"$f":"IF(AND(COUNTA(D7:E7)>0,COUNTA(F7:G7)=0),HYPERLINK(\"#'BMP Design'!f7:g7\",\"Continue\"),IF(AND(COUNTA(D8:E8)>0,COUNTA(F8:G8)=0),HYPERLINK(\"#'BMP Design'!f8:g8\",\"Continue\"),IF(AND(COUNTA(D9:E9)>0,COUNTA(F9:G9)=0),HYPERLINK(\"#'BMP Design'!f9:g9\",\"Continue\"),IF(AND(COUNTA(D10:E10)>0,COUNTA(F10:G10)=0),HYPERLINK(\"#'BMP Design'!f10:g10\",\"Continue\"),IF(AND(COUNTA(D11:E11)>0,COUNTA(F11:G11)=0),HYPERLINK(\"#'BMP Design'!f11:g11\",\"Continue\"),IF(AND(COUNTA(D12:E12)>0,COUNTA(F12:G12)=0),HYPERLINK(\"#'BMP Design'!f12:g12\",\"Continue\"),IF(AND(COUNTA(D13:E13)>0,COUNTA(F13:G13)=0),HYPERLINK(\"#'BMP Design'!f13:g13\",\"Continue\"),IF(AND(COUNTA(D14:E14)>0,COUNTA(F14:G14)=0),HYPERLINK(\"#'BMP Design'!f14:g14\",\"Continue\"),IF(AND(COUNTA(D15:E15)>0,COUNTA(F15:G15)=0),HYPERLINK(\"#'BMP Design'!f15:g15\",\"Continue\"),IF(AND(COUNTA(D16:E16)>0,COUNTA(F16:G16)=0),HYPERLINK(\"#'BMP Design'!f16:g16\",\"Continue\"),IF(AND(COUNTA(D17:E17)>0,COUNTA(F17:G17)=0),HYPERLINK(\"#'BMP Design'!f17:g17\",\"Continue\"),IF(AND(COUNTA(D18:E18)>0,COUNTA(F18:G18)=0),HYPERLINK(\"#'BMP Design'!f18:g18\",\"Continue\"),IF(AND(COUNTA(D7:G7)>1,SUM(H7:K7)=0),HYPERLINK(\"#'BMP Design'!H7:K7\",\"Continue\"),IF(AND(COUNTA(D8:G8)>1,SUM(H8:K8)=0),HYPERLINK(\"#'BMP Design'!H8:K8\",\"Continue\"),IF(AND(COUNTA(D9:G9)>1,SUM(H9:K9)=0),HYPERLINK(\"#'BMP Design'!H9:K9\",\"Continue\"),IF(AND(COUNTA(D10:G10)>1,SUM(H10:K10)=0),HYPERLINK(\"#'BMP Design'!H10:K10\",\"Continue\"),IF(AND(COUNTA(D11:G11)>1,SUM(H11:K11)=0),HYPERLINK(\"#'BMP Design'!H11:K11\",\"Continue\"),IF(AND(COUNTA(D12:G12)>1,SUM(H12:K12)=0),HYPERLINK(\"#'BMP Design'!H12:K12\",\"Continue\"),IF(AND(COUNTA(D13:G13)>1,SUM(H13:K13)=0),HYPERLINK(\"#'BMP Design'!H13:K13\",\"Continue\"),IF(AND(COUNTA(D14:G14)>1,SUM(H14:K14)=0),HYPERLINK(\"#'BMP Design'!H14:K14\",\"Continue\"),IF(AND(COUNTA(D15:G15)>1,SUM(H15:K15)=0),HYPERLINK(\"#'BMP Design'!H15:K15\",\"Continue\"),IF(AND(COUNTA(D16:G16)>1,SUM(H16:K16)=0),HYPERLINK(\"#'BMP Design'!H16:K16\",\"Continue\"),IF(AND(COUNTA(D17:G17)>1,SUM(H17:K17)=0),HYPERLINK(\"#'BMP Design'!H17:K17\",\"Continue\"),IF(AND(COUNTA(D18:G18)>1,SUM(H18:K18)=0),HYPERLINK(\"#'BMP Design'!H18:K18\",\"Continue\"),IF(AND(Activity=\"Voluntary\",H19>H20),HYPERLINK(\"#'BMP Design'!H19\",\"Continue\"),IF(AND(Activity=\"Voluntary\",I19>I20),HYPERLINK(\"#'BMP Design'!i19\",\"Continue\"),IF(AND(Activity=\"Voluntary\",J19>J20),HYPERLINK(\"#'BMP Design'!j19\",\"Continue\"),IF(AND(Activity=\"Voluntary\",K19>K20),HYPERLINK(\"#'BMP Design'!k19\",\"Continue\"),IF(AND(G24=0,SUM(H19:K19)>0),HYPERLINK(\"#'BMP Design'!d7:g18\",\"Continue\"),IF(AND(H24=0,AL19=0),HYPERLINK(\"#'Financial Input'!h8\",\"Continue\"),HYPERLINK(\"#'BMP Design'!d7:g18\",\"Continue\")))))))))))))))))))))))))))))))","v":"Continue"}]
[null,null,null,null,null,null,null,{"$f":"IF(AND(Activity=\"Voluntary\",Post>0,SUM(H7:H18)>Background!E22),1,\"\")","v":""},{"$f":"IF(AND(Activity=\"Voluntary\",Post>0,SUM(I7:I18)>Background!F22),1.1,\"\")","v":""},{"$f":"IF(AND(Activity=\"Voluntary\",Post>0,SUM(J7:J18)>Background!G22),1.3,\"\")","v":""},{"$f":"IF(AND(Activity=\"Voluntary\",Post>0,SUM(K7:K18)>Background!H22),1.5,\"\")","v":""},null,null,null,null,null,null,null,null,null,{"$f":"SUM(H23:K23)","v":0}]
[null,null,null,{"$f":"COUNTA(D7:D18)","v":0},null,{"$f":"COUNTA(F7:F18)","v":0},{"$f":"D24+F24","v":0},{"$f":"D24-F24","v":0}]
[null,null,null,{"$f":"COUNTIF($D$7:$D$18,\"Tree Planting and Preservation\")>0","v":false},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,{"$f":"COUNTIF($D$7:$D$18,\"Impervious Surface Disconnection\")>0","v":false},null,null,null,{"$f":"IF(U21=1,\"Natural area CDA exceeds post-project land cover information.\",IF(U21=1.1,\"Compacted area CDA exceeds post-project land cover information.\",IF(U21=1.3,\"Impervious area CDA exceeds post-project land cover information.\",IF(U21=1.5,\"BMP area CDA exceeds post-project land cover information.\",IF(U21=2.1,\"Natural and compacted area CDAs exceed post-project land cover information.\",IF(U21=2.3,\"Natural and impervious area CDAs exceed post-project land cover information.\",IF(U21=2.5,\"Natural and BMP area CDAs exceed post-project land cover information.\",IF(U21=2.4,\"Compcated and impervious area CDAs exceed post-project land cover information.\",IF(U21=2.6,\"Compacted and BMP area CDAs exceed post-project land cover information.\",IF(U21=2.8,\"Impervious and BM area CDAs exceed post-project land cover information.\",IF(U21=3.4,\"Natural, compacted and impervious area CDAs exceed post-project land cover information.\",IF(U21=3.6,\"Natural, compacted, and BMP area CDAs exceed post-project land cover information.\",IF(U21=3.8,\"Natural, impervious, and BMP area CDAs exceed post-project land cover information.\",IF(U21=3.9,\"Compacted, impervious, and BMP area CDAs exceed post-project land cover information.\",IF(U21=4.9,\"All land cover area CDAs exceed post-project land cover information.\",\"\")))))))))))))))","v":""}]

{"sheet":"Financial Input","index":4,"n_rows":35,"n_cols":18,"rows_kept":35,"cut":false,"hidden":false,"merged":[[29,2,29,7],[27,2,27,7],[33,2,33,7],[8,16,9,16],[8,13,9,13],[8,12,9,12],[8,11,9,11],[8,14,9,14],[8,15,9,15],[20,2,20,4],[13,2,13,3],[19,2,19,4],[15,2,15,4],[16,2,16,4],[6,11,6,13],[7,11,7,13],[6,14,6,15],[7,14,7,15],[28,2,28,7],[17,2,17,4],[18,2,18,4],[7,2,7,4],[8,2,8,4],[9,2,9,4],[10,2,10,4],[12,2,12,4],[11,2,11,4],[14,3,14,4],[3,11,3,16],[2,11,2,16],[4,11,4,16],[2,2,4,7],[5,5,5,7],[5,11,5,13],[5,14,5,16]]}
[]
[]
[null,null,"Enter SRC Project Costs\nIf financial information is unavailable for a line item, leave the user input blank\nto use an assumed or calculated value.",null,null,null,null,null,null,null,null,"Enter SRC Project Revenue8"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(Activity=\"Voluntary\",Price_AWDZ=\"Yes\"),\"For the first 12 years, prices below are set according the current rates in DOEE's  SRC Price Lock Program and inflation adjusted thereafter. Alternativey, the User may input their own sale price.\",\"To claculate a possible Return on Investment, enter a SRC Sale Price for the first year.  Prices will be inflation adjusted thereafter.\")","v":"To claculate a possible Return on Investment, enter a SRC Sale Price for the first year.  Prices will be inflation adjusted thereafter."}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I8<30,\"*BMP Life Cycle beyond the Investment Period is shown in gold.\",\"\")","v":"*BMP Life Cycle beyond the Investment Period is shown in gold."}]
[null,null," Type of Project:",null,null,{"$f":"IF(Background!I5=\"MLD\",\"Major Land Disturbing\",IF(Background!I5=\"MSI\",\"Major Substantial Improvement\",IF(Background!I5=\"Voluntary\",\"Voluntary Retrofit\",\"\")))","v":"Voluntary Retrofit"},null,null,null,null,null,"Years 1-15",null,null,"Years 16-30"]
[null,null,"  Project Cost Data",null,null,"Default Value",null,"User Input","Used in Calcs",null,null,"  Project Revenue Data",null,null,"Default Value",null,"User Input"]
[null,null,"Investment Period - Years 1",null,null,12,null,null,{"$f":"IF(ISBLANK(H8),F8,H8)","v":12},null,null,"Inflation Rate of SRC Prices - Annual",null,null,1.9099999999999999E-2,null,null,{"$f":"IF(ISBLANK(Q8),O8,Q8)","v":1.9099999999999999E-2}]
[null,null,"Type of DC Water Customer 2",null,null,"Commercial",null,null,{"$f":"IF(ISBLANK(H9),F9,H9)","v":"Commercial"},null,null,"Year","Calculated SRC Price","User Input SRC Price","Year","Calculated SRC Price","User Input SRC Price"]
[null,null,"BMP Installation Cost 3",null,null,{"$f":"IF(ISBLANK('BMP Design'!D7),(References!I42*Background!H22),References!K40)","v":0},null,null,0]
[null,null,"Other Project Costs (e.g., land lease/purchase or personnel hours)",null,null,0,null,null,0,null,{"$f":"IF(ISBLANK(N11),M11,N11)","v":0},1,{"$f":"IF(AND(Price_Lock=\"Yes\",MS4_MLD=\"MS4 Tidal\",'Financial Input'!L11<=6),References!$L$25,IF(AND(Price_Lock=\"Yes\",MS4_MLD=\"MS4 Non-Tidal\",'Financial Input'!L11<=6),References!$L$26,0))","v":0},null,16,{"$f":"K25*(1+$R$8)","v":0},null,{"$f":"IF(ISBLANK(Q11),P11,Q11)","v":0}]
[null,null,"Stormwater Management Plan (SWMP) Review Fees $ 4,5",null,null,"Calculated based on the Project Information",null,{"$f":"IF(F6=\"\",0,IF(AND(F6=\"Voluntary Retrofit\",BMPCOUNT=1,BMPGRCHECK=\"Green Roof\",Background!H22>=10000),VSWMPInitial2+VSWMPFinal2,IF(AND(F6=\"Voluntary Retrofit\",BMPCOUNT=1,BMPGRCHECK=\"Green Roof\",Background!H22<10000),VSWMPInitial1+VSWMPFinal1,IF(AND(F6=\"Voluntary Retrofit\",Background!H22>=10000),(VSWMPInitial2+VSWMPFinal2+ESCInitial2+ESCFinal2),IF(AND(F6=\"Voluntary Retrofit\",Background!H22<10000),(VSWMPInitial1+VSWMPFinal1)+IF(Background!H22<=5000,ESCInitial1+ESCFinal1,ESCInitial2+ESCFinal2),IF(Background!H22>=10000,(RSWMPInitial2+RSWMPFinal2+IF(Background!H22>=5000,ESCInitial2+ESCFinal2)),(RSWMPInitial1+RSWMPFinal1+IF(Background!H22<=5000,ESCInitial1+ESCFinal1))))))))","v":1694.3},{"$f":"H12","v":1694.3},null,{"$f":"IF(ISBLANK(N12),M12,N12)","v":0},2,{"$f":"IF(AND(Price_Lock=\"Yes\",MS4_MLD=\"MS4 Tidal\",'Financial Input'!L12<=6),References!$L$25,IF(AND(Price_Lock=\"Yes\",MS4_MLD=\"MS4 Non-Tidal\",'Financial Input'!L12<=6),References!$L$26,K11*(1+$R$8)))","v":0},null,17,{"$f":"R11*(1+$R$8)","v":0},null,{"$f":"IF(ISBLANK(Q12),P12,Q12)","v":0}]
[null,null,"Cost of Engineering Services 6",null,null,{"$f":"I10*Costs!D118","v":0},null,null,{"$f":"IF(ISBLANK(H13),F13,H13)","v":0},null,0,3,{"$f":"IF(AND(Price_Lock=\"Yes\",MS4_MLD=\"MS4 Tidal\",'Financial Input'!L13<=6),References!$L$25,IF(AND(Price_Lock=\"Yes\",MS4_MLD=\"MS4 Non-Tidal\",'Financial Input'!L13<=6),References!$L$26,K12*(1+$R$8)))","v":0},null,18,0,null,0]
[null,null,"Total Capital Costs                             Please select (% or $)",null,"Percentage","The Sum of the Individual Capital Costs",null,{"$f":"I14","v":1694.3},{"$f":"SUM(I10:I13)","v":1694.3},null,0,4,{"$f":"IF(AND(Price_Lock=\"Yes\",MS4_MLD=\"MS4 Tidal\",'Financial Input'!L14<=6),References!$L$25,IF(AND(Price_Lock=\"Yes\",MS4_MLD=\"MS4 Non-Tidal\",'Financial Input'!L14<=6),References!$L$26,K13*(1+$R$8)))","v":0},null,19,0,null,0]
[null,null,{"$f":"IF(E14=\"Percentage\",\"         % Borrowed Capital\",\"         $ Borrowed Capital\")","v":"         % Borrowed Capital"},{"$f":"IF(E14=\"Percentage\", \"For percents, please enter a decimal (e.g. 90%=0.9) \",\"\")","v":"For percents, please enter a decimal (e.g. 90%=0.9) "},null,{"$f":"IF(E14=\"Percentage\",1-H17,H14-H17)","v":1},null,null,{"$f":"IF(E14=\"Dollars\",H25,F25*H14)","v":1694.3},null,0,5,{"$f":"IF(AND(Price_Lock=\"Yes\",MS4_MLD=\"MS4 Tidal\",'Financial Input'!L15<=6),References!$L$25,IF(AND(Price_Lock=\"Yes\",MS4_MLD=\"MS4 Non-Tidal\",'Financial Input'!L15<=6),References!$L$26,K14*(1+$R$8)))","v":0},null,20,0,null,0]
[null,null,{"$f":"IF(E14=\"Percentage\",\"         % Out-of-Pocket\",\"         $ Out-of-Pocket\")","v":"         % Out-of-Pocket"},null,null,{"$f":"IF(E14=\"Percentage\",\"Remaining Percentage\nof Capital Costs\",\"Remaining Portion\nof Capital Costs\")","v":"Remaining Percentage\nof Capital Costs"},null,{"$f":"IF(E14=\"Dollars\",H14-SUM(H25,H17),1-SUM(F25,H17))","v":0},{"$f":"IF(E14=\"Dollars\",H16,H16*$H$14)","v":0},null,0,6,{"$f":"IF(AND(Price_Lock=\"Yes\",MS4_MLD=\"MS4 Tidal\",'Financial Input'!L16<=6),References!$L$25,IF(AND(Price_Lock=\"Yes\",MS4_MLD=\"MS4 Non-Tidal\",'Financial Input'!L16<=6),References!$L$26,K15*(1+$R$8)))","v":0},null,21,0,null,0]
[null,null,{"$f":"IF(E14=\"Percentage\",\"         % District Government Contribution to Capital Cost\",\"         $ District Government Contribution to Capital Cost\")","v":"         % District Government Contribution to Capital Cost"},null,null,"User Input from Project Overview",null,{"$f":"IF(E14=\"Dollars\",DC_Money,DC_Money/'Financial Input'!H14)","v":0},{"$f":"IF(E14=\"Dollars\",H17,H17*$H$14)","v":0},null,0,7,{"$f":"IF(AND(Price_Lock=\"Yes\",MS4_MLD=\"MS4 Tidal\",'Financial Input'!L17<=12),References!$M$25,IF(AND(Price_Lock=\"Yes\",MS4_MLD=\"MS4 Non-Tidal\",'Financial Input'!L17<=12),References!$M$26,K16*(1+$R$8)))","v":0},null,22,0,null,0]
[null,null,"         Interest Rate on Loan for Capital Cost 7",null,null,6.25E-2,null,null,{"$f":"IF(ISBLANK(H18),F18,H18)","v":6.25E-2},null,0,8,{"$f":"IF(AND(Price_Lock=\"Yes\",MS4_MLD=\"MS4 Tidal\",'Financial Input'!L18<=12),References!$M$25,IF(AND(Price_Lock=\"Yes\",MS4_MLD=\"MS4 Non-Tidal\",'Financial Input'!L18<=12),References!$M$26,K17*(1+$R$8)))","v":0},null,23,0,null,0]
[null,null,"         Loan Repayment Period - Years",null,null,6,null,null,{"$f":"IF(ISBLANK(H19),F19,H19)","v":6},null,0,9,{"$f":"IF(AND(Price_Lock=\"Yes\",MS4_MLD=\"MS4 Tidal\",'Financial Input'!L19<=12),References!$M$25,IF(AND(Price_Lock=\"Yes\",MS4_MLD=\"MS4 Non-Tidal\",'Financial Input'!L19<=12),References!$M$26,K18*(1+$R$8)))","v":0},null,24,0,null,0]
[null,null,"Total Annual Maintenance Cost 3",null,null,{"$f":"2*Background!H22","v":0},null,null,0,null,0,10,{"$f":"IF(AND(Price_Lock=\"Yes\",MS4_MLD=\"MS4 Tidal\",'Financial Input'!L20<=12),References!$M$25,IF(AND(Price_Lock=\"Yes\",MS4_MLD=\"MS4 Non-Tidal\",'Financial Input'!L20<=12),References!$M$26,K19*(1+$R$8)))","v":0},null,25,0,null,0]
[null,null,"Other Annual Costs",null,null,{"$f":"2*Background!H23","v":0},null,null,0,null,0,11,{"$f":"IF(AND(Price_Lock=\"Yes\",MS4_MLD=\"MS4 Tidal\",'Financial Input'!L21<=12),References!$M$25,IF(AND(Price_Lock=\"Yes\",MS4_MLD=\"MS4 Non-Tidal\",'Financial Input'!L21<=12),References!$M$26,K20*(1+$R$8)))","v":0},null,26,0,null,0]
[null,null,{"$f":"IF(I19>I8,\"*Loan Repayment Period cannot exceed Investment Period\",\"\")","v":""},null,null,null,null,null,null,null,0,12,{"$f":"IF(AND(Price_Lock=\"Yes\",MS4_MLD=\"MS4 Tidal\",'Financial Input'!L22<=12),References!$M$25,IF(AND(Price_Lock=\"Yes\",MS4_MLD=\"MS4 Non-Tidal\",'Financial Input'!L22<=12),References!$M$26,K21*(1+$R$8)))","v":0},null,27,0,null,0]
[null,null,"Return to Overview",null,null,"Go Back",null,{"$f":"IF(AND(I19>=I8,H15>0),HYPERLINK(\"#'Financial Summary'!i19\",\"Continue\"),HYPERLINK(\"#'Financial Summary'!e10\",\"Continue\"))","v":"Continue"},null,null,0,13,{"$f":"K22*(1+$R$8)","v":0},null,28,0,null,0]
[null,null,null,null,null,null,null,null,null,null,0,14,{"$f":"K23*(1+$R$8)","v":0},null,29,0,null,0]
[null,null,"Visit SRC Registry",null,null,{"$f":"IF(ISBLANK(H15),F15,H15)","v":1},null,{"$f":"IF(ISBLANK(H15),F15,H15)","v":1},null,null,0,15,{"$f":"K24*(1+$R$8)","v":0},null,30,0,null,0]
[]
[]
[null,null,"1   Projects may continue to generate SRCs after the investment period, as long as they continue to meet eligibility requirements."]
[null,null,"2    DC Water uses aerial imagery to determine the number of Equivalent Residential Units (ERUs) on each property in the District. One ERU equals 1,000 ft2 of\n      impervious area. This tool calculates ERUs based on user input. Residential customers are assessed ERUs according to a six-tier rate structure\n      (see www.dcwater.com/customercare/iab.cfm).",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Financial Input'!$I$8>=L23,IF(ISBLANK(N23),M23,N23),0)","v":0}]
[null,null,"3   BMP construction and maintenance costs were derived from averaging mid-to-high costs from cnt.org, Green Values Stormwater Management\n     Calculator available at http://greenvalues.cnt.org/national/calculator.php"]
[null,null,"4    SWMP fees are calculated using the current DOEE Fee Rates and based on User defined project site information (does not include GAR fees)"]
[null,null,"5   DOEE offers discounted rates on SWMP fees for voluntary projects seeking SRC generation."]
[null,null,"6   Engineering cost estimates were derived from \"Architectural and Engineering Basic Services Fee Estimating Guidelines\" (https://uminfopoint.umsystem.edu)"]
[null,null,"7   If the user does not enter an interest rate, the rate shall be set at Prime (4.0%) + 1.5.  This was figure was established using average commercial construction\n     loan rates over twenty financial institutions current rates.  This information is available at: https://www.commercialloandirect.com/commercial-rates.php "]
[null,null,"8   Without participation in the SRC Price Lock Program, DOEE does not guarantee the sale or price of SRCs."]

{"sheet":"Financial Summary","index":5,"n_rows":33,"n_cols":13,"rows_kept":33,"cut":false,"hidden":false,"merged":[[7,2,7,3],[9,2,9,3],[11,2,11,3],[3,2,5,3],[2,2,2,7],[3,4,4,4]]}
[]
[]
[null,null,"Financial Summary\nThe values below were claculated using User inputs and default or assumed values.\nDOEE does not guarantee financial retrun, SRC eligibilty, or other results."]
[null,null,"Potential SRC Eligibility",null,"Annual",null,"Investment Period",null,"BMP Life Cycle Period"]
[null,null,null,null,null,null,{"$f":"'Financial Input'!I8&\" \"&\"Years\"","v":"12 Years"},null,"30 Years"]
[null,null,null,null,{"$f":"IF(ROUND(('BMP Design'!AG19+IF(Background!I5=\"Voluntary\",Background!H28,-Background!I28))-IF('1'!H9>0,Pre_BMP,0),0)<0,0,ROUND(('BMP Design'!AG19+IF(Background!I5=\"Voluntary\",Background!H28,-Background!I28))-IF('1'!H9>0,Pre_BMP,0),0))","v":0},null,{"$f":"E6*'Financial Input'!I8","v":0},null,{"$f":"E6*30","v":0}]
[]
[null,null," Total Revenue ",null,null,null,{"$f":"'Detailed Estimation'!F17","v":0},null,{"$f":"'Detailed Estimation'!G17","v":0}]
[]
[null,null," Net Cash Flow",null,null,null,{"$f":"'Detailed Estimation'!F19","v":-2036.1600000000003},null,{"$f":"'Detailed Estimation'!G19","v":-2036.1600000000003},null,null,null,{"$f":"IF(Background!G28=\"N/A\",0,Background!G28)","v":0}]
[]
[null,null," Return on Investment",null,null,null,{"$f":"'Detailed Estimation'!F20","v":-1},null,{"$f":"'Detailed Estimation'!G20","v":-1}]
[]
[]
[null,null,"Return to Overview",null,null,null,"Go Back",null,"Continue"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null," ",null,null,null,null," "]

{"sheet":"Detailed Estimation","index":6,"n_rows":27,"n_cols":37,"rows_kept":27,"cut":false,"hidden":false,"merged":[[26,1,26,7],[1,1,3,6],[5,2,5,4],[6,2,6,4],[7,2,7,4],[9,2,9,4],[8,2,8,4],[12,2,12,4],[11,2,11,4],[18,2,18,4],[19,2,19,4],[10,2,10,5],[17,2,17,5],[13,2,13,4],[14,2,14,4],[15,2,15,4],[16,2,16,4]]}
[]
[null,"Detailed Estimation\nDOEE does not guarantee financial retrun, SRC eligibilty, or other results."]
[]
[null,null,null,null,null,null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30]
[null,null,null,null,null,"Total Over\nInvestment\nPeriod","Total Over\nBMP Life\nCycle","Year 1","Year 2","Year 3","Year 4","Year 5","Year 6","Year 7","Year 8","Year 9","Year 10","Year 11","Year 12","Year 13","Year 14","Year 15","Year 16","Year 17","Year 18","Year 19","Year 20","Year 21","Year 22","Year 23","Year 24","Year 25","Year 26","Year 27","Year 28","Year 29","Year 30"]
[null,null,"Out-of-Pocket Costsii",null,null,{"$f":"G6","v":0},{"$f":"H6","v":0},{"$f":"-'Financial Input'!I16","v":0},{"$f":"\" \"","v":" "},{"$f":"\" \"","v":" "}," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
[null,null,"Loan Repaymentii",null,null,{"$f":"SUM(H7:AK7)","v":-2036.1600000000003},{"$f":"SUM(H7:AAK7)","v":-2036.1600000000003},{"$f":"References!L20*-1","v":-339.36},{"$f":"IF('Financial Input'!$I$19>=I4,(References!$L$20*-1),\" \")","v":-339.36},{"$f":"IF('Financial Input'!$I$19>=J4,(References!$L$20*-1),\" \")","v":-339.36},{"$f":"IF('Financial Input'!$I$19>=K4,(References!$L$20*-1),\" \")","v":-339.36},{"$f":"IF('Financial Input'!$I$19>=L4,(References!$L$20*-1),\" \")","v":-339.36},{"$f":"IF('Financial Input'!$I$19>=M4,(References!$L$20*-1),\" \")","v":-339.36},{"$f":"IF('Financial Input'!$I$19>=N4,(References!$L$20*-1),\" \")","v":" "},{"$f":"IF('Financial Input'!$I$19>=O4,(References!$L$20*-1),\" \")","v":" "},{"$f":"IF('Financial Input'!$I$19>=P4,(References!$L$20*-1),\" \")","v":" "},{"$f":"IF('Financial Input'!$I$19>=Q4,(References!$L$20*-1),\" \")","v":" "},{"$f":"IF('Financial Input'!$I$19>=R4,(References!$L$20*-1),\" \")","v":" "},{"$f":"IF('Financial Input'!$I$19>=S4,(References!$L$20*-1),\" \")","v":" "},{"$f":"IF('Financial Input'!$I$19>=T4,(References!$L$20*-1),\" \")","v":" "},{"$f":"IF('Financial Input'!$I$19>=U4,(References!$L$20*-1),\" \")","v":" "},{"$f":"IF('Financial Input'!$I$19>=V4,(References!$L$20*-1),\" \")","v":" "},{"$f":"IF('Financial Input'!$I$19>=W4,(References!$L$20*-1),\" \")","v":" "},{"$f":"IF('Financial Input'!$I$19>=X4,(References!$L$20*-1),\" \")","v":" "},{"$f":"IF('Financial Input'!$I$19>=Y4,(References!$L$20*-1),\" \")","v":" "},{"$f":"IF('Financial Input'!$I$19>=Z4,(References!$L$20*-1),\" \")","v":" "},{"$f":"IF('Financial Input'!$I$19>=AA4,(References!$L$20*-1),\" \")","v":" "},{"$f":"IF('Financial Input'!$I$19>=AB4,(References!$L$20*-1),\" \")","v":" "},{"$f":"IF('Financial Input'!$I$19>=AC4,(References!$L$20*-1),\" \")","v":" "},{"$f":"IF('Financial Input'!$I$19>=AD4,(References!$L$20*-1),\" \")","v":" "},{"$f":"IF('Financial Input'!$I$19>=AE4,(References!$L$20*-1),\" \")","v":" "},{"$f":"IF('Financial Input'!$I$19>=AF4,(References!$L$20*-1),\" \")","v":" "},{"$f":"IF('Financial Input'!$I$19>=AG4,(References!$L$20*-1),\" \")","v":" "},{"$f":"IF('Financial Input'!$I$19>=AH4,(References!$L$20*-1),\" \")","v":" "},{"$f":"IF('Financial Input'!$I$19>=AI4,(References!$L$20*-1),\" \")","v":" "},{"$f":"IF('Financial Input'!$I$19>=AJ4,(References!$L$20*-1),\" \")","v":" "},{"$f":"IF('Financial Input'!$I$19>=AK4,(References!$L$20*-1),\" \")","v":" "}]
[null,null,"Maintenance Costii",null,null,{"$f":"SUMIF(H4:AK4,\"<=\"&'Financial Input'!I8,H8:AK8)","v":0},{"$f":"SUM(H8:AAK8)","v":0},{"$f":"'Financial Input'!$I$20*-1","v":0},{"$f":"(((H8*-1)*(1+'Financial Input'!$R$8))*-1)","v":0},{"$f":"(((I8*-1)*(1+'Financial Input'!$R$8))*-1)","v":0},{"$f":"(((J8*-1)*(1+'Financial Input'!$R$8))*-1)","v":0},{"$f":"(((K8*-1)*(1+'Financial Input'!$R$8))*-1)","v":0},{"$f":"(((L8*-1)*(1+'Financial Input'!$R$8))*-1)","v":0},{"$f":"(((M8*-1)*(1+'Financial Input'!$R$8))*-1)","v":0},{"$f":"(((N8*-1)*(1+'Financial Input'!$R$8))*-1)","v":0},{"$f":"(((O8*-1)*(1+'Financial Input'!$R$8))*-1)","v":0},{"$f":"(((P8*-1)*(1+'Financial Input'!$R$8))*-1)","v":0},{"$f":"(((Q8*-1)*(1+'Financial Input'!$R$8))*-1)","v":0},{"$f":"(((R8*-1)*(1+'Financial Input'!$R$8))*-1)","v":0},{"$f":"(((S8*-1)*(1+'Financial Input'!$R$8))*-1)","v":0},{"$f":"(((T8*-1)*(1+'Financial Input'!$R$8))*-1)","v":0},{"$f":"(((U8*-1)*(1+'Financial Input'!$R$8))*-1)","v":0},{"$f":"(((V8*-1)*(1+'Financial Input'!$R$8))*-1)","v":0},{"$f":"(((W8*-1)*(1+'Financial Input'!$R$8))*-1)","v":0},{"$f":"(((X8*-1)*(1+'Financial Input'!$R$8))*-1)","v":0},{"$f":"(((Y8*-1)*(1+'Financial Input'!$R$8))*-1)","v":0},{"$f":"(((Z8*-1)*(1+'Financial Input'!$R$8))*-1)","v":0},{"$f":"(((AA8*-1)*(1+'Financial Input'!$R$8))*-1)","v":0},{"$f":"(((AB8*-1)*(1+'Financial Input'!$R$8))*-1)","v":0},{"$f":"(((AC8*-1)*(1+'Financial Input'!$R$8))*-1)","v":0},{"$f":"(((AD8*-1)*(1+'Financial Input'!$R$8))*-1)","v":0},{"$f":"(((AE8*-1)*(1+'Financial Input'!$R$8))*-1)","v":0},{"$f":"(((AF8*-1)*(1+'Financial Input'!$R$8))*-1)","v":0},{"$f":"(((AG8*-1)*(1+'Financial Input'!$R$8))*-1)","v":0},{"$f":"(((AH8*-1)*(1+'Financial Input'!$R$8))*-1)","v":0},{"$f":"(((AI8*-1)*(1+'Financial Input'!$R$8))*-1)","v":0},{"$f":"(((AJ8*-1)*(1+'Financial Input'!$R$8))*-1)","v":0}]
[null,null,"Other Annual Costsii",null,null,{"$f":"SUMIF(H4:AK4,\"<=\"&'Financial Input'!I8,H9:AK9)","v":0},0,{"$f":"'Financial Input'!$I$21*-1","v":0},{"$f":"(((H9*-1)*(1+'Financial Input'!$R$8))*-1)","v":0},{"$f":"(((I9*-1)*(1+'Financial Input'!$R$8))*-1)","v":0},{"$f":"(((J9*-1)*(1+'Financial Input'!$R$8))*-1)","v":0},{"$f":"(((K9*-1)*(1+'Financial Input'!$R$8))*-1)","v":0},{"$f":"(((L9*-1)*(1+'Financial Input'!$R$8))*-1)","v":0},{"$f":"(((M9*-1)*(1+'Financial Input'!$R$8))*-1)","v":0},{"$f":"(((N9*-1)*(1+'Financial Input'!$R$8))*-1)","v":0},{"$f":"(((O9*-1)*(1+'Financial Input'!$R$8))*-1)","v":0},{"$f":"(((P9*-1)*(1+'Financial Input'!$R$8))*-1)","v":0},{"$f":"(((Q9*-1)*(1+'Financial Input'!$R$8))*-1)","v":0},{"$f":"(((R9*-1)*(1+'Financial Input'!$R$8))*-1)","v":0},{"$f":"(((S9*-1)*(1+'Financial Input'!$R$8))*-1)","v":0},{"$f":"(((T9*-1)*(1+'Financial Input'!$R$8))*-1)","v":0},{"$f":"(((U9*-1)*(1+'Financial Input'!$R$8))*-1)","v":0},{"$f":"(((V9*-1)*(1+'Financial Input'!$R$8))*-1)","v":0},{"$f":"(((W9*-1)*(1+'Financial Input'!$R$8))*-1)","v":0},{"$f":"(((X9*-1)*(1+'Financial Input'!$R$8))*-1)","v":0},{"$f":"(((Y9*-1)*(1+'Financial Input'!$R$8))*-1)","v":0},{"$f":"(((Z9*-1)*(1+'Financial Input'!$R$8))*-1)","v":0},{"$f":"(((AA9*-1)*(1+'Financial Input'!$R$8))*-1)","v":0},{"$f":"(((AB9*-1)*(1+'Financial Input'!$R$8))*-1)","v":0},{"$f":"(((AC9*-1)*(1+'Financial Input'!$R$8))*-1)","v":0},{"$f":"(((AD9*-1)*(1+'Financial Input'!$R$8))*-1)","v":0},{"$f":"(((AE9*-1)*(1+'Financial Input'!$R$8))*-1)","v":0},{"$f":"(((AF9*-1)*(1+'Financial Input'!$R$8))*-1)","v":0},{"$f":"(((AG9*-1)*(1+'Financial Input'!$R$8))*-1)","v":0},{"$f":"(((AH9*-1)*(1+'Financial Input'!$R$8))*-1)","v":0},{"$f":"(((AI9*-1)*(1+'Financial Input'!$R$8))*-1)","v":0},{"$f":"(((AJ9*-1)*(1+'Financial Input'!$R$8))*-1)","v":0}]
[null,null,"Total Costii",null,null,{"$f":"SUM(F6:F9)","v":-2036.1600000000003},{"$f":"SUM(G6:G9)","v":-2036.1600000000003},{"$f":"SUM(H6:H8)","v":-339.36},{"$f":"SUM(I6:I8)","v":-339.36},-339.36,-339.36,-339.36,-339.36,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(AB6:AB8)","v":0},0,0,0,0,0,0,0,0,0]
[]
[null,null,"SRC Price        ",null,null,null,null,{"$f":"'Financial Input'!K11","v":0},{"$f":"'Financial Input'!$K12","v":0},{"$f":"'Financial Input'!$K13","v":0},{"$f":"'Financial Input'!$K14","v":0},{"$f":"'Financial Input'!$K15","v":0},{"$f":"'Financial Input'!$K16","v":0},{"$f":"'Financial Input'!$K17","v":0},{"$f":"'Financial Input'!$K18","v":0},{"$f":"'Financial Input'!$K19","v":0},{"$f":"'Financial Input'!$K20","v":0},{"$f":"'Financial Input'!$K21","v":0},{"$f":"'Financial Input'!$K22","v":0},{"$f":"'Financial Input'!$K23","v":0},{"$f":"'Financial Input'!$K24","v":0},{"$f":"'Financial Input'!$K25","v":0},{"$f":"'Financial Input'!R11","v":0},{"$f":"'Financial Input'!$R12","v":0},{"$f":"'Financial Input'!$R13","v":0},{"$f":"'Financial Input'!$R14","v":0},{"$f":"'Financial Input'!$R15","v":0},{"$f":"'Financial Input'!$R16","v":0},{"$f":"'Financial Input'!$R17","v":0},{"$f":"'Financial Input'!$R18","v":0},{"$f":"'Financial Input'!$R19","v":0},{"$f":"'Financial Input'!$R20","v":0},{"$f":"'Financial Input'!$R21","v":0},{"$f":"'Financial Input'!$R22","v":0},{"$f":"'Financial Input'!$R23","v":0},{"$f":"'Financial Input'!$R24","v":0},{"$f":"'Financial Input'!$R25","v":0}]
[null,null,"Value of SRCsii",null,null,{"$f":"SUMIF($H$4:$AK$4,\"<=\"&'Financial Input'!$I$8,H13:AK13)","v":0},{"$f":"SUM(H13:AK13)","v":0},{"$f":"IF(References!C59>0,References!$B$51*H12,References!C56)","v":0},{"$f":"IF(References!C59>0,References!$B$51*I12,References!D56)","v":0},{"$f":"IF(References!D59>0,References!$B$51*J12,References!E56)","v":0},{"$f":"IF(References!E59>0,References!$B$51*K12,References!F56)","v":0},{"$f":"IF(References!F59>0,References!$B$51*L12,References!G56)","v":0},{"$f":"IF(References!G59>0,References!$B$51*M12,References!H56)","v":0},{"$f":"IF(References!H59>0,References!$B$51*N12,References!I56)","v":0},{"$f":"IF(References!I59>0,References!$B$51*O12,References!J56)","v":0},{"$f":"IF(References!J59>0,References!$B$51*P12,References!K56)","v":0},{"$f":"IF(References!K59>0,References!$B$51*Q12,References!L56)","v":0},{"$f":"IF(References!L59>0,References!$B$51*R12,References!M56)","v":0},{"$f":"IF(References!M59>0,References!$B$51*S12,References!N56)","v":0},{"$f":"IF(References!N59>0,References!$B$51*T12,References!O56)","v":0},{"$f":"IF(References!O59>0,References!$B$51*U12,References!P56)","v":0},{"$f":"IF(References!P59>0,References!$B$51*V12,References!Q56)","v":0},{"$f":"IF(References!Q59>0,References!$B$51*W12,References!R56)","v":0},{"$f":"IF(References!R59>0,References!$B$51*X12,References!S56)","v":0},{"$f":"IF(References!S59>0,References!$B$51*Y12,References!T56)","v":0},{"$f":"IF(References!T59>0,References!$B$51*Z12,References!U56)","v":0},{"$f":"IF(References!U59>0,References!$B$51*AA12,References!V56)","v":0},{"$f":"IF(References!V59>0,References!$B$51*AB12,References!W56)","v":0},{"$f":"IF(References!W59>0,References!$B$51*AC12,References!X56)","v":0},{"$f":"IF(References!X59>0,References!$B$51*AD12,References!Y56)","v":0},{"$f":"IF(References!Y59>0,References!$B$51*AE12,References!Z56)","v":0},{"$f":"IF(References!Z59>0,References!$B$51*AF12,References!AA56)","v":0},{"$f":"IF(References!AA59>0,References!$B$51*AG12,References!AB56)","v":0},{"$f":"IF(References!AB59>0,References!$B$51*AH12,References!AC56)","v":0},{"$f":"IF(References!AC59>0,References!$B$51*AI12,References!AD56)","v":0},{"$f":"IF(References!AD59>0,References!$B$51*AJ12,References!AE56)","v":0},{"$f":"IF(References!AE59>0,References!$B$51*AK12,References!AF56)","v":0}]
[null,null,"Discount on Impervious Area Charge 9",null,null,{"$f":"SUMIF($H$4:$AK$4,\"<=\"&'Financial Input'!$I$8,H14:AK14)","v":0},{"$f":"SUM(H14:AK14)","v":0},{"$f":"IF('Financial Input'!$I$8>=1,(References!C54*-1*References!$B$46/1.2*1.2),0)","v":0},{"$f":"IF('Financial Input'!$I$8>=1,(References!D54*-1*References!$B$46/1.2*1.2),0)","v":0},{"$f":"IF('Financial Input'!$I$8>=1,(References!E54*-1*References!$B$46/1.2*1.2),0)","v":0},{"$f":"IF('Financial Input'!$I$8>=1,(References!F54*-1*References!$B$46/1.2*1.2),0)","v":0},{"$f":"IF('Financial Input'!$I$8>=1,(References!G54*-1*References!$B$46/1.2*1.2),0)","v":0},{"$f":"IF('Financial Input'!$I$8>=1,(References!H54*-1*References!$B$46/1.2*1.2),0)","v":0},{"$f":"IF('Financial Input'!$I$8>=1,(References!I54*-1*References!$B$46/1.2*1.2),0)","v":0},{"$f":"IF('Financial Input'!$I$8>=1,(References!J54*-1*References!$B$46/1.2*1.2),0)","v":0},{"$f":"IF('Financial Input'!$I$8>=1,(References!K54*-1*References!$B$46/1.2*1.2),0)","v":0},{"$f":"IF('Financial Input'!$I$8>=1,(References!L54*-1*References!$B$46/1.2*1.2),0)","v":0},{"$f":"IF('Financial Input'!$I$8>=1,(References!M54*-1*References!$B$46/1.2*1.2),0)","v":0},{"$f":"IF('Financial Input'!$I$8>=1,(References!N54*-1*References!$B$46/1.2*1.2),0)","v":0},{"$f":"References!O54*-1*References!$B$46/1.2*1.2","v":0},{"$f":"IF('Financial Input'!$I$8>=1,(References!P54*-1*References!$B$46/1.2*1.2),0)","v":0},{"$f":"IF('Financial Input'!$I$8>=1,(References!Q54*-1*References!$B$46/1.2*1.2),0)","v":0},{"$f":"IF('Financial Input'!$I$8>=1,(References!R54*-1*References!$B$46/1.2*1.2),0)","v":0},{"$f":"IF('Financial Input'!$I$8>=1,(References!S54*-1*References!$B$46/1.2*1.2),0)","v":0},{"$f":"IF('Financial Input'!$I$8>=1,(References!T54*-1*References!$B$46/1.2*1.2),0)","v":0},{"$f":"IF('Financial Input'!$I$8>=1,(References!U54*-1*References!$B$46/1.2*1.2),0)","v":0},{"$f":"IF('Financial Input'!$I$8>=1,(References!V54*-1*References!$B$46/1.2*1.2),0)","v":0},{"$f":"IF('Financial Input'!$I$8>=1,(References!W54*-1*References!$B$46/1.2*1.2),0)","v":0},{"$f":"IF('Financial Input'!$I$8>=1,(References!X54*-1*References!$B$46/1.2*1.2),0)","v":0},{"$f":"IF('Financial Input'!$I$8>=1,(References!Y54*-1*References!$B$46/1.2*1.2),0)","v":0},{"$f":"IF('Financial Input'!$I$8>=1,(References!Z54*-1*References!$B$46/1.2*1.2),0)","v":0},{"$f":"IF('Financial Input'!$I$8>=1,(References!AA54*-1*References!$B$46/1.2*1.2),0)","v":0},{"$f":"IF('Financial Input'!$I$8>=1,(References!AB54*-1*References!$B$46/1.2*1.2),0)","v":0},{"$f":"IF('Financial Input'!$I$8>=1,(References!AC54*-1*References!$B$46/1.2*1.2),0)","v":0},{"$f":"IF('Financial Input'!$I$8>=1,(References!AD54*-1*References!$B$46/1.2*1.2),0)","v":0},{"$f":"IF('Financial Input'!$I$8>=1,(References!AE54*-1*References!$B$46/1.2*1.2),0)","v":0},{"$f":"IF('Financial Input'!$I$8>=1,(References!AF54*-1*References!$B$46/1.2*1.2),0)","v":0}]
[null,null,"Discount on Stormwater Fee 9",null,null,{"$f":"SUMIF($H$4:$AK$4,\"<=\"&'Financial Input'!$I$8,H15:AK15)","v":0},0,{"$f":"IF('Financial Input'!$I$8>=1,(References!C55*-1*References!$B$47/1.2*1.2),0)","v":0},{"$f":"IF('Financial Input'!$I$8>=1,(References!D55*-1*References!$B$47/1.2*1.2),0)","v":0},{"$f":"IF('Financial Input'!$I$8>=1,(References!E55*-1*References!$B$47/1.2*1.2),0)","v":0},{"$f":"IF('Financial Input'!$I$8>=1,(References!F55*-1*References!$B$47/1.2*1.2),0)","v":0},{"$f":"IF('Financial Input'!$I$8>=1,(References!G55*-1*References!$B$47/1.2*1.2),0)","v":0},{"$f":"IF('Financial Input'!$I$8>=1,(References!H55*-1*References!$B$47/1.2*1.2),0)","v":0},{"$f":"IF('Financial Input'!$I$8>=1,(References!I55*-1*References!$B$47/1.2*1.2),0)","v":0},{"$f":"IF('Financial Input'!$I$8>=1,(References!J55*-1*References!$B$47/1.2*1.2),0)","v":0},{"$f":"IF('Financial Input'!$I$8>=1,(References!K55*-1*References!$B$47/1.2*1.2),0)","v":0},{"$f":"IF('Financial Input'!$I$8>=1,(References!L55*-1*References!$B$47/1.2*1.2),0)","v":0},{"$f":"IF('Financial Input'!$I$8>=1,(References!M55*-1*References!$B$47/1.2*1.2),0)","v":0},{"$f":"IF('Financial Input'!$I$8>=1,(References!N55*-1*References!$B$47/1.2*1.2),0)","v":0},{"$f":"IF('Financial Input'!$I$8>=1,(References!O55*-1*References!$B$47/1.2*1.2),0)","v":0},{"$f":"IF('Financial Input'!$I$8>=1,(References!P55*-1*References!$B$47/1.2*1.2),0)","v":0},{"$f":"IF('Financial Input'!$I$8>=1,(References!Q55*-1*References!$B$47/1.2*1.2),0)","v":0},{"$f":"IF('Financial Input'!$I$8>=1,(References!R55*-1*References!$B$47/1.2*1.2),0)","v":0},{"$f":"IF('Financial Input'!$I$8>=1,(References!S55*-1*References!$B$47/1.2*1.2),0)","v":0},{"$f":"IF('Financial Input'!$I$8>=1,(References!T55*-1*References!$B$47/1.2*1.2),0)","v":0},{"$f":"IF('Financial Input'!$I$8>=1,(References!U55*-1*References!$B$47/1.2*1.2),0)","v":0},{"$f":"IF('Financial Input'!$I$8>=1,(References!V55*-1*References!$B$47/1.2*1.2),0)","v":0},{"$f":"IF('Financial Input'!$I$8>=1,(References!W55*-1*References!$B$47/1.2*1.2),0)","v":0},{"$f":"IF('Financial Input'!$I$8>=1,(References!X55*-1*References!$B$47/1.2*1.2),0)","v":0},{"$f":"IF('Financial Input'!$I$8>=1,(References!Y55*-1*References!$B$47/1.2*1.2),0)","v":0},{"$f":"IF('Financial Input'!$I$8>=1,(References!Z55*-1*References!$B$47/1.2*1.2),0)","v":0},{"$f":"IF('Financial Input'!$I$8>=1,(References!AA55*-1*References!$B$47/1.2*1.2),0)","v":0},{"$f":"IF('Financial Input'!$I$8>=1,(References!AB55*-1*References!$B$47/1.2*1.2),0)","v":0},{"$f":"IF('Financial Input'!$I$8>=1,(References!AC55*-1*References!$B$47/1.2*1.2),0)","v":0},{"$f":"IF('Financial Input'!$I$8>=1,(References!AD55*-1*References!$B$47/1.2*1.2),0)","v":0},{"$f":"IF('Financial Input'!$I$8>=1,(References!AE55*-1*References!$B$47/1.2*1.2),0)","v":0},{"$f":"IF('Financial Input'!$I$8>=1,(References!AF55*-1*References!$B$47/1.2*1.2),0)","v":0}]
[null,null,"Savings from Removing Impervious Areaii",null,null,{"$f":"SUMIF($H$4:$AK$4,\"<=\"&'Financial Input'!$I$8,H16:AK16)","v":0},0,{"$f":"IF('Financial Input'!$I$8>=H4,IF('Financial Input'!$I$9=\"Residential\",(References!$B$52-References!$B$53)*(References!C46*12+References!C47*12),((SUM(Background!$G$23:$H$23)-SUM(Background!$G$22:$H$22))/1000)*(References!C46*12+References!C47*12)),0)","v":0},{"$f":"IF('Financial Input'!$I$8>=I4,IF('Financial Input'!$I$9=\"Residential\",(References!$B$52-References!$B$53)*(References!D46*12+References!D47*12),((SUM(Background!$G$23:$H$23)-SUM(Background!$G$22:$H$22))/1000)*(References!D46*12+References!D47*12)),0)","v":0},{"$f":"IF('Financial Input'!$I$8>=J4,IF('Financial Input'!$I$9=\"Residential\",(References!$B$52-References!$B$53)*(References!E46*12+References!E47*12),((SUM(Background!$G$23:$H$23)-SUM(Background!$G$22:$H$22))/1000)*(References!E46*12+References!E47*12)),0)","v":0},{"$f":"IF('Financial Input'!$I$8>=K4,IF('Financial Input'!$I$9=\"Residential\",(References!$B$52-References!$B$53)*(References!F46*12+References!F47*12),((SUM(Background!$G$23:$H$23)-SUM(Background!$G$22:$H$22))/1000)*(References!F46*12+References!F47*12)),0)","v":0},{"$f":"IF('Financial Input'!$I$8>=L4,IF('Financial Input'!$I$9=\"Residential\",(References!$B$52-References!$B$53)*(References!G46*12+References!G47*12),((SUM(Background!$G$23:$H$23)-SUM(Background!$G$22:$H$22))/1000)*(References!G46*12+References!G47*12)),0)","v":0},{"$f":"IF('Financial Input'!$I$8>=M4,IF('Financial Input'!$I$9=\"Residential\",(References!$B$52-References!$B$53)*(References!H46*12+References!H47*12),((SUM(Background!$G$23:$H$23)-SUM(Background!$G$22:$H$22))/1000)*(References!H46*12+References!H47*12)),0)","v":0},{"$f":"IF('Financial Input'!$I$8>=N4,IF('Financial Input'!$I$9=\"Residential\",(References!$B$52-References!$B$53)*(References!I46*12+References!I47*12),((SUM(Background!$G$23:$H$23)-SUM(Background!$G$22:$H$22))/1000)*(References!I46*12+References!I47*12)),0)","v":0},{"$f":"IF('Financial Input'!$I$8>=O4,IF('Financial Input'!$I$9=\"Residential\",(References!$B$52-References!$B$53)*(References!J46*12+References!J47*12),((SUM(Background!$G$23:$H$23)-SUM(Background!$G$22:$H$22))/1000)*(References!J46*12+References!J47*12)),0)","v":0},{"$f":"IF('Financial Input'!$I$8>=P4,IF('Financial Input'!$I$9=\"Residential\",(References!$B$52-References!$B$53)*(References!K46*12+References!K47*12),((SUM(Background!$G$23:$H$23)-SUM(Background!$G$22:$H$22))/1000)*(References!K46*12+References!K47*12)),0)","v":0},{"$f":"IF('Financial Input'!$I$8>=Q4,IF('Financial Input'!$I$9=\"Residential\",(References!$B$52-References!$B$53)*(References!L46*12+References!L47*12),((SUM(Background!$G$23:$H$23)-SUM(Background!$G$22:$H$22))/1000)*(References!L46*12+References!L47*12)),0)","v":0},{"$f":"IF('Financial Input'!$I$8>=R4,IF('Financial Input'!$I$9=\"Residential\",(References!$B$52-References!$B$53)*(References!M46*12+References!M47*12),((SUM(Background!$G$23:$H$23)-SUM(Background!$G$22:$H$22))/1000)*(References!M46*12+References!M47*12)),0)","v":0},{"$f":"IF('Financial Input'!$I$8>=S4,IF('Financial Input'!$I$9=\"Residential\",(References!$B$52-References!$B$53)*(References!N46*12+References!N47*12),((SUM(Background!$G$23:$H$23)-SUM(Background!$G$22:$H$22))/1000)*(References!N46*12+References!N47*12)),0)","v":0},{"$f":"IF('Financial Input'!$I$8>=T4,IF('Financial Input'!$I$9=\"Residential\",(References!$B$52-References!$B$53)*(References!O46*12+References!O47*12),((SUM(Background!$G$23:$H$23)-SUM(Background!$G$22:$H$22))/1000)*(References!O46*12+References!O47*12)),0)","v":0},{"$f":"IF('Financial Input'!$I$8>=U4,IF('Financial Input'!$I$9=\"Residential\",(References!$B$52-References!$B$53)*(References!P46*12+References!P47*12),((SUM(Background!$G$23:$H$23)-SUM(Background!$G$22:$H$22))/1000)*(References!P46*12+References!P47*12)),0)","v":0},{"$f":"IF('Financial Input'!$I$8>=V4,IF('Financial Input'!$I$9=\"Residential\",(References!$B$52-References!$B$53)*(References!Q46*12+References!Q47*12),((SUM(Background!$G$23:$H$23)-SUM(Background!$G$22:$H$22))/1000)*(References!Q46*12+References!Q47*12)),0)","v":0},{"$f":"IF('Financial Input'!$I$8>=W4,IF('Financial Input'!$I$9=\"Residential\",(References!$B$52-References!$B$53)*(References!R46*12+References!R47*12),((SUM(Background!$G$23:$H$23)-SUM(Background!$G$22:$H$22))/1000)*(References!R46*12+References!R47*12)),0)","v":0},{"$f":"IF('Financial Input'!$I$8>=X4,IF('Financial Input'!$I$9=\"Residential\",(References!$B$52-References!$B$53)*(References!S46*12+References!S47*12),((SUM(Background!$G$23:$H$23)-SUM(Background!$G$22:$H$22))/1000)*(References!S46*12+References!S47*12)),0)","v":0},{"$f":"IF('Financial Input'!$I$8>=Y4,IF('Financial Input'!$I$9=\"Residential\",(References!$B$52-References!$B$53)*(References!T46*12+References!T47*12),((SUM(Background!$G$23:$H$23)-SUM(Background!$G$22:$H$22))/1000)*(References!T46*12+References!T47*12)),0)","v":0},{"$f":"IF('Financial Input'!$I$8>=Z4,IF('Financial Input'!$I$9=\"Residential\",(References!$B$52-References!$B$53)*(References!U46*12+References!U47*12),((SUM(Background!$G$23:$H$23)-SUM(Background!$G$22:$H$22))/1000)*(References!U46*12+References!U47*12)),0)","v":0},{"$f":"IF('Financial Input'!$I$8>=AA4,IF('Financial Input'!$I$9=\"Residential\",(References!$B$52-References!$B$53)*(References!V46*12+References!V47*12),((SUM(Background!$G$23:$H$23)-SUM(Background!$G$22:$H$22))/1000)*(References!V46*12+References!V47*12)),0)","v":0},{"$f":"IF('Financial Input'!$I$8>=AB4,IF('Financial Input'!$I$9=\"Residential\",(References!$B$52-References!$B$53)*(References!W46*12+References!W47*12),((SUM(Background!$G$23:$H$23)-SUM(Background!$G$22:$H$22))/1000)*(References!W46*12+References!W47*12)),0)","v":0},{"$f":"IF('Financial Input'!$I$8>=AC4,IF('Financial Input'!$I$9=\"Residential\",(References!$B$52-References!$B$53)*(References!X46*12+References!X47*12),((SUM(Background!$G$23:$H$23)-SUM(Background!$G$22:$H$22))/1000)*(References!X46*12+References!X47*12)),0)","v":0},{"$f":"IF('Financial Input'!$I$8>=AD4,IF('Financial Input'!$I$9=\"Residential\",(References!$B$52-References!$B$53)*(References!Y46*12+References!Y47*12),((SUM(Background!$G$23:$H$23)-SUM(Background!$G$22:$H$22))/1000)*(References!Y46*12+References!Y47*12)),0)","v":0},{"$f":"IF('Financial Input'!$I$8>=AE4,IF('Financial Input'!$I$9=\"Residential\",(References!$B$52-References!$B$53)*(References!Z46*12+References!Z47*12),((SUM(Background!$G$23:$H$23)-SUM(Background!$G$22:$H$22))/1000)*(References!Z46*12+References!Z47*12)),0)","v":0},{"$f":"IF('Financial Input'!$I$8>=AF4,IF('Financial Input'!$I$9=\"Residential\",(References!$B$52-References!$B$53)*(References!AA46*12+References!AA47*12),((SUM(Background!$G$23:$H$23)-SUM(Background!$G$22:$H$22))/1000)*(References!AA46*12+References!AA47*12)),0)","v":0},{"$f":"IF('Financial Input'!$I$8>=AG4,IF('Financial Input'!$I$9=\"Residential\",(References!$B$52-References!$B$53)*(References!AB46*12+References!AB47*12),((SUM(Background!$G$23:$H$23)-SUM(Background!$G$22:$H$22))/1000)*(References!AB46*12+References!AB47*12)),0)","v":0},{"$f":"IF('Financial Input'!$I$8>=AH4,IF('Financial Input'!$I$9=\"Residential\",(References!$B$52-References!$B$53)*(References!AC46*12+References!AC47*12),((SUM(Background!$G$23:$H$23)-SUM(Background!$G$22:$H$22))/1000)*(References!AC46*12+References!AC47*12)),0)","v":0},{"$f":"IF('Financial Input'!$I$8>=AI4,IF('Financial Input'!$I$9=\"Residential\",(References!$B$52-References!$B$53)*(References!AD46*12+References!AD47*12),((SUM(Background!$G$23:$H$23)-SUM(Background!$G$22:$H$22))/1000)*(References!AD46*12+References!AD47*12)),0)","v":0},{"$f":"IF('Financial Input'!$I$8>=AJ4,IF('Financial Input'!$I$9=\"Residential\",(References!$B$52-References!$B$53)*(References!AE46*12+References!AE47*12),((SUM(Background!$G$23:$H$23)-SUM(Background!$G$22:$H$22))/1000)*(References!AE46*12+References!AE47*12)),0)","v":0},{"$f":"IF('Financial Input'!$I$8>=AK4,IF('Financial Input'!$I$9=\"Residential\",(References!$B$52-References!$B$53)*(References!AF46*12+References!AF47*12),((SUM(Background!$G$23:$H$23)-SUM(Background!$G$22:$H$22))/1000)*(References!AF46*12+References!AF47*12)),0)","v":0}]
[null,null,"Total Revenue ",null,null,{"$f":"SUM(F13:F16)","v":0},{"$f":"SUM(G13:G16)","v":0},{"$f":"SUM(H13:H16)","v":0},0,0,0,0,0,0,{"$f":"SUM(O13:O16)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(AB13:AB16)","v":0},0,0,0,0,0,0,0,0,0]
[]
[null,null,"Net Cash Flowii",null,null,{"$f":"F17+F10","v":-2036.1600000000003},{"$f":"G17+G10","v":-2036.1600000000003},{"$f":"H17+H10","v":-339.36},{"$f":"I17+I10","v":-339.36},-339.36,-339.36,-339.36,-339.36,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Return on Investmentii",null,null,{"$f":"IFERROR((F17+F10)/(F10*-1),\" \")","v":-1},{"$f":"IFERROR((G17+G10)/(G10*-1),\" \")","v":-1}]
[]
[null,null,"Return to Overview",null,null,null,"Go Back"]
[]
[null,null,"Visit SRC registry"]
[]
[]
[null,"9   CRIAC and DC Government Stormwater Fees are based off approved and proposed Fiscal Year rates and capped at the last proposed rate."]

{"sheet":"Background","index":7,"n_rows":29,"n_cols":9,"rows_kept":29,"cut":false,"hidden":true,"merged":[[2,2,2,7],[5,2,6,6],[28,2,29,6],[8,2,9,6],[27,2,27,4],[26,2,26,4],[25,2,25,8],[20,2,20,3],[21,2,21,3],[22,2,22,3]]}
[]
[]
[null,null,"Stormwater Retention Credit (SRC)\nFinancial Return Calculator\nRegulatory Review Division"]
[]
[null,null,"1. Is the project a voluntary or a regulated activity?",null,null,null,null,"Please Select  ",{"$f":"IF(Activity=\"Voluntary\",\"Voluntary\",IF(MS4_MLD=\"MSI\",\"MSI\",IF(MS4_MLD=\"MLD\",\"MLD\",\"\")))","v":"Voluntary"}]
[null,null,"    *If regulated, please distinguish between Major Land Disturbing\n      (MLD) activity or Major Substantial Improvement (MSI) activity.\n      The definition for these activities can be found in Appendix U of\n         the DOEE Stormwater Management Guidebook."]
[]
[]
[null,null,"2. Is the project an Anacostia Waterfront Development\n    Zone (AWDZ) Site?",null,null,null,null,"Please Select  ",{"$f":"IF(Overview!I16=\"Voluntary\",\"No\",Price_AWDZ)","v":"No"}]
[]
[]
[null,null,"3. Regulatory Rainfall Event for SWRv (inches)",null,null,null,null,null,{"$f":"IF(I5=\"Voluntary\",\"N/A\",IF(I5=\"\",\"\",IF(AND(I9=\"Yes\",I5=\"MSI\"),1,IF(AND(I9=\"No\",I5=\"MSI\"),0.8,1.2))))","v":"N/A"}]
[]
[null,null,"4. Water Quality Treatment Volume (gallons)",null,null,null,null,null,{"$f":"IF(I5=\"Voluntary\",\"N/A\",((1.7/12*((0.25*'2'!F8)+(0.75*('2'!G8+'2'!H8))))*7.48)-G28)","v":"N/A"}]
[]
[]
[]
[]
[null,null,"Project Site Information"]
[null,null,{"$f":"IF(SUM(E22:H22)=SUM(E23:H23),\" \",\"ERROR: Pre and post-project land cover square footage must be equivalent\")","v":" "}]
[null,null,"Land Cover Type:",null,"Natural","Compacted","Impervious","BMP","Total"]
[null,null,"Post-project  (ft2)",null,{"$f":"IF(Overview!$I$16=\"Voluntary\",'1'!E8,'2'!E8)","v":0},{"$f":"IF(Overview!$I$16=\"Voluntary\",'1'!F8,'2'!F8)","v":0},{"$f":"IF(Overview!$I$16=\"Voluntary\",'1'!G13,'2'!G17)","v":0},{"$f":"IF(Overview!$I$16=\"Voluntary\",'1'!H13,'2'!H17)","v":0},{"$f":"SUM(E22:H22)","v":0}]
[null,null,"Pre-project   (ft2)",null,{"$f":"IF(Overview!$I$16=\"Voluntary\",'1'!E9,'2'!E9)","v":0},{"$f":"IF(Overview!$I$16=\"Voluntary\",'1'!F9,'2'!F9)","v":0},{"$f":"IF(Overview!$I$16=\"Voluntary\",'1'!G12,'2'!G16)","v":0},{"$f":"IF(Overview!$I$16=\"Voluntary\",'1'!H12,'2'!H16)","v":0},{"$f":"SUM(E23:H23)","v":0}]
[null,null,null,null,null,null,{"$f":"IFERROR(IF(H22/I22>0.9,\"BMP has little to no additional CDA\",\" \"),\" \")","v":" "}]
[null,null,"Stormwater Retention Volume (SWRv) Requirement"]
[null,null,"*This is a regulatory requirement and not applicable to voluntary projects.  SRC generation is\n  calculated for regulated projects for retention volume achieved beyond the regulatory\n  requirement, up to a 1.7 inch rainfall event."]
[null,null,"SWRv",null,null,"ft3","gal","Land Cover Change","Regulatory\nRequirement"]
[null,null,{"$f":"IF(Background!I5=\"MLD\",\"Major Land Disturbing\",IF(Background!I5=\"MSI\",\"Major Substantial Improvement\",IF(Background!I5=\"Voluntary\",\"Voluntary Retrofit\",\"\")))","v":"Voluntary Retrofit"},null,null,{"$f":"IFERROR(I12/12*((E22*References!B16)+(F22*References!B17)+(G22*References!B18)+(H22*References!B18)),\"N/A\")","v":"N/A"},{"$f":"IFERROR(F28*7.48,\"N/A\")","v":"N/A"},{"$f":"(IF(I5=\"Voluntary\",(1.7/12*(E22*1+F22*0.75+G22*0.05+H22*0.05)*7.48)-(1.7/12*(E23*1+F23*0.75+G23*0.05+H23*0.05)*7.48)))","v":0},{"$f":"IF(I5<>\"Voluntary\",G28,0)+IF(I9=\"Yes\",'2'!F16,0)","v":0}]
[null,null,"*For MSI activities, the Stormwater Retention Volume (SWRv) requirement is based on the 1.0-inch storm event. For MLD activities the SWRv requirement is based on the 1.2-inch storm event.  All AWDZ sites must meet a Water Quality Treatment Volume (WQTv) that is based on a 1.7-inch storm event."]

{"sheet":"References","index":8,"n_rows":216,"n_cols":32,"rows_kept":216,"cut":false,"hidden":true,"merged":[[59,0,59,1],[60,0,60,1]]}
["Green Roof","Extensive green roof","Intensive green roof",null,null,null,1,1,null,null,null,null,null,null,null,null,null,null,null,null,"Green Roof"]
["Rainwater Harvesting","Rainwater harvesting",null,null,2,"Rv to Sv Coversion factor",1,null,null,null,null,null,null,null,"Return to Instructions",null,"Continue",null,null,null,"Rainwater Harvesting"]
["Impervious Surface Disconnection","Disconnection to a pervious area","Disconnection to a conservation area","Disconnection to amended soils",null,null,{"$f":"(VLOOKUP(B3,BMPData,21,FALSE)/100)*2","v":{"$error":"#N/A"}},{"$f":"(VLOOKUP(C3,BMPData,21,FALSE)/100)*6","v":{"$error":"#N/A"}},{"$f":"(VLOOKUP(D3,BMPData,21,FALSE)/100)*4","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,"Appendix U",null,null,"Permeable Pavement"]
["Permeable Pavement","Permeable pavement - Enhanced","Permeable pavement - Standard",null,null,null,1,{"$f":"(VLOOKUP(C4,PP,6,FALSE)/100)*5","v":{"$error":"#N/A"}},null,null,null,null,null,null,"Visit SRC Registry",null,"Go Back",null,"SRC Purchase Agreement",null,"Bioretention"]
["Bioretention","Bioretention - Enhanced","Bioretention - Standard",null,null,null,1,0.6,null,null,null,null,null,null,null,null,null,"AWDZ Map",null,null,"Infiltration"]
["Infiltration","Infiltration trench","Infiltration basin",null,null,null,1,1,null,null,null,null,null,null,"Visit SRC Homepage",null,"MS4 Map",null,null,null,"Open Channel"]
["Open Channel","Grass channel","Grass channel - amended soils","Dry swale","Wet swale",null,0.1,0.3,0.6,0.1,null,null,null,null,null,null,null,null,null,null,"Ponds"]
["Ponds","Micropool ED pond","Wet pond","Wet ED pond",null,null,0.1,0.1,0.1,null,null,null,null,null,"Match",null,"Match1",null,null,null,"Wetlands"]
["Wetlands","Shallow wetland","ED shallow wetland",null,null,null,0.1,0.1,null,null,null,null,null,null,"Green Roof","A","Extensive green roof","A"]
["Tree Planting and Preservation","Tree preservation","Tree planting",null,null,null,{"$f":"VLOOKUP(B10,BMPData,24,0)*20","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C10,BMPData,24,0)*10","v":{"$error":"#N/A"}},null,null,null,null,null,null,"Rainwater Harvesting","B","Intensive green roof","A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Impervious Surface Disconnection","C","Rainwater harvesting","B"]
["Yes",null,null,null,null,null,null,null,null,null,null,null,null,null,"Permeable Pavement","D","Simple disconnection to a pervious area","C"]
["No",null,null,null,null,null,null,null,null,null,null,null,null,null,"Bioretention","E","Simple disconnection to a conservation area","C"]
[null,null,{"$f":"IFERROR(VLOOKUP(F18,BMPData,6,FALSE),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,"Infiltration","F","Simple disconnection to amended soils","C"]
["Land Cover Type","Rv","Costs","ft2 or count","ft2 or count","Lookup Values","$/ft2","Inflation","$",null,"Amortization Schedule",{"$f":"'Financial Input'!I15","v":1694.3},null,null,"Open Channel","G","Permeable pavement - Enhanced","D"]
["Natural Cover",0,{"$f":"'BMP Design'!F7","v":0},{"$f":"IF(C16=\"Tree planting\",'BMP Design'!AC7,IF(C16=\"Rainwater harvesting\",'BMP Design'!V7,IF(C16=\"Simple disconnection to amended soils\",'BMP Design'!AA7,IF(C16=\"Simple disconnection to a pervious area\",'BMP Design'!AA7,IF(C16=\"Simple disconnection to conservation area\",'BMP Design'!AA7,'BMP Design'!S7)))))","v":0},null,"Extensive green roof",24,{"$f":"G16*1.5","v":36},{"$f":"IFERROR((VLOOKUP(C16,BMPCost,3,0)*D16)*('BMP Design'!V7/'BMP Design'!X7),0)","v":0},null,"Loan $",{"$f":"IF(L15=722.58,0,L15)","v":1694.3},null,null,"Ponds","H","Permeable pavement - Standard","D"]
["Compacted Cover",0.25,{"$f":"'BMP Design'!F8","v":0},{"$f":"IF(C17=\"Tree planting\",'BMP Design'!AC8,IF(C17=\"Rainwater harvesting\",'BMP Design'!V8,IF(C17=\"Simple disconnection to amended soils\",'BMP Design'!AA8,IF(C17=\"Simple disconnection to a pervious area\",'BMP Design'!AA8,IF(C17=\"Simple disconnection to conservation area\",'BMP Design'!AA8,'BMP Design'!S8)))))","v":0},null,"Intensive green roof",36,{"$f":"G17*1.5","v":54},{"$f":"IFERROR((VLOOKUP(C17,BMPCost,3,0)*D17)*('BMP Design'!V8/'BMP Design'!X8),0)","v":0},null,"Interest %",{"$f":"'Financial Input'!I18","v":6.25E-2},null,null,"Wetlands","I","Bioretention - Enhanced","E"]
["Impervious Cover",0.95,{"$f":"'BMP Design'!F9","v":0},{"$f":"IF(C18=\"Tree planting\",'BMP Design'!AC9,IF(C18=\"Rainwater harvesting\",'BMP Design'!V9,IF(C18=\"Simple disconnection to amended soils\",'BMP Design'!AA9,IF(C18=\"Simple disconnection to a pervious area\",'BMP Design'!AA9,IF(C18=\"Simple disconnection to conservation area\",'BMP Design'!AA9,'BMP Design'!S9)))))","v":0},null,"Rainwater harvesting",10.65,15.975000000000001,{"$f":"IFERROR((VLOOKUP(C18,BMPCost,3,0)*D18)*('BMP Design'!V9/'BMP Design'!X9),0)","v":0},null,"Loan Term",{"$f":"'Financial Input'!I19*12","v":72},null,null,"Tree Planting and Preservation","J","Bioretention - Standard","E"]
[null,null,{"$f":"'BMP Design'!F10","v":0},{"$f":"IF(C19=\"Tree planting\",'BMP Design'!AC10,IF(C19=\"Rainwater harvesting\",'BMP Design'!V10,IF(C19=\"Simple disconnection to amended soils\",'BMP Design'!AA10,IF(C19=\"Simple disconnection to a pervious area\",'BMP Design'!AA10,IF(C19=\"Simple disconnection to conservation area\",'BMP Design'!AA10,'BMP Design'!S10)))))","v":0},null,"Simple disconnection to a pervious area",{"$f":"95.5/1000","v":9.5500000000000002E-2},0.14324999999999999,{"$f":"IFERROR((VLOOKUP(C19,BMPCost,3,0)*D19)*('BMP Design'!V10/'BMP Design'!X10),0)","v":0},null,"Payments",{"$f":"ROUND(PMT(L17/12,L18,-L16,0),2)","v":28.28},null,null,null,null,"Infiltration trench","F"]
["Review Fees",null,{"$f":"'BMP Design'!F11","v":0},{"$f":"IF(C20=\"Tree planting\",'BMP Design'!AC11,IF(C20=\"Rainwater harvesting\",'BMP Design'!V11,IF(C20=\"Simple disconnection to amended soils\",'BMP Design'!AA11,IF(C20=\"Simple disconnection to a pervious area\",'BMP Design'!AA11,IF(C20=\"Simple disconnection to conservation area\",'BMP Design'!AA11,'BMP Design'!S11)))))","v":0},null,"Simple disconnection to a conservation area",{"$f":"95.5/1000","v":9.5500000000000002E-2},0.14324999999999999,{"$f":"IFERROR((VLOOKUP(C20,BMPCost,3,0)*D20)*('BMP Design'!V11/'BMP Design'!X11),0)","v":0},null,"Annual",{"$f":"L19*12","v":339.36},{"$f":"L20*'Financial Input'!I8","v":4072.32},null,null,null,"Infiltration basin","F"]
[null,null,{"$f":"'BMP Design'!F12","v":0},{"$f":"IF(C21=\"Tree planting\",'BMP Design'!AC12,IF(C21=\"Rainwater harvesting\",'BMP Design'!V12,IF(C21=\"Simple disconnection to amended soils\",'BMP Design'!AA12,IF(C21=\"Simple disconnection to a pervious area\",'BMP Design'!AA12,IF(C21=\"Simple disconnection to conservation area\",'BMP Design'!AA12,'BMP Design'!S12)))))","v":0},null,"Simple disconnection to amended soils",{"$f":"(50+1667)/1000","v":1.7170000000000001},2.5754999999999999,{"$f":"IFERROR((VLOOKUP(C21,BMPCost,3,0)*D21)*('BMP Design'!V12/'BMP Design'!X12),0)","v":0},null,null,null,null,null,null,null,"Grass channel","G"]
[null,null,{"$f":"'BMP Design'!F13","v":0},{"$f":"IF(C22=\"Tree planting\",'BMP Design'!AC13,IF(C22=\"Rainwater harvesting\",'BMP Design'!V13,IF(C22=\"Simple disconnection to amended soils\",'BMP Design'!AA13,IF(C22=\"Simple disconnection to a pervious area\",'BMP Design'!AA13,IF(C22=\"Simple disconnection to conservation area\",'BMP Design'!AA13,'BMP Design'!S13)))))","v":0},null,"Permeable pavement - Standard",7,10.5,{"$f":"IFERROR((VLOOKUP(C22,BMPCost,3,0)*D22)*('BMP Design'!V13/'BMP Design'!X13),0)","v":0},null,null,null,null,null,null,null,"Grass channel - amended soils","G"]
["ESC",null,{"$f":"'BMP Design'!F14","v":0},{"$f":"IF(C23=\"Tree planting\",'BMP Design'!AC14,IF(C23=\"Rainwater harvesting\",'BMP Design'!V14,IF(C23=\"Simple disconnection to amended soils\",'BMP Design'!AA14,IF(C23=\"Simple disconnection to a pervious area\",'BMP Design'!AA14,IF(C23=\"Simple disconnection to conservation area\",'BMP Design'!AA14,'BMP Design'!S14)))))","v":0},null,"Permeable pavement - Enhanced",12,18,{"$f":"IFERROR((VLOOKUP(C23,BMPCost,3,0)*D23)*('BMP Design'!V14/'BMP Design'!X14),0)","v":0},null,null,null,null,null,null,null,"Dry swale","G"]
["50-5000","5000+",{"$f":"'BMP Design'!F15","v":0},{"$f":"IF(C24=\"Tree planting\",'BMP Design'!AC15,IF(C24=\"Rainwater harvesting\",'BMP Design'!V15,IF(C24=\"Simple disconnection to amended soils\",'BMP Design'!AA15,IF(C24=\"Simple disconnection to a pervious area\",'BMP Design'!AA15,IF(C24=\"Simple disconnection to conservation area\",'BMP Design'!AA15,'BMP Design'!S15)))))","v":0},null,"Bioretention - Standard",15,22.5,{"$f":"IFERROR((VLOOKUP(C24,BMPCost,3,0)*D24)*('BMP Design'!V15/'BMP Design'!X15),0)","v":0},null,null,"Years 1-6","Years 7-12",null,null,null,"Wet swale","G"]
["Initial",null,{"$f":"'BMP Design'!F16","v":0},{"$f":"IF(C25=\"Tree planting\",'BMP Design'!AC16,IF(C25=\"Rainwater harvesting\",'BMP Design'!V16,IF(C25=\"Simple disconnection to amended soils\",'BMP Design'!AA16,IF(C25=\"Simple disconnection to a pervious area\",'BMP Design'!AA16,IF(C25=\"Simple disconnection to conservation area\",'BMP Design'!AA16,'BMP Design'!S16)))))","v":0},null,"Bioretention - Enhanced",24,36,{"$f":"IFERROR((VLOOKUP(C25,BMPCost,3,0)*D25)*('BMP Design'!V16/'BMP Design'!X16),0)","v":0},null,"MS4 Tidal",1.77,0.42,null,null,null,"Micropool ED pond","H"]
[469.44,1154.7,{"$f":"'BMP Design'!F17","v":0},{"$f":"IF(C26=\"Tree planting\",'BMP Design'!AC17,IF(C26=\"Rainwater harvesting\",'BMP Design'!V17,IF(C26=\"Simple disconnection to amended soils\",'BMP Design'!AA17,IF(C26=\"Simple disconnection to a pervious area\",'BMP Design'!AA17,IF(C26=\"Simple disconnection to conservation area\",'BMP Design'!AA17,'BMP Design'!S17)))))","v":0},null,"Infiltration basin",24,36,{"$f":"IFERROR((VLOOKUP(C26,BMPCost,3,0)*D26)*('BMP Design'!V17/'BMP Design'!X17),0)","v":0},null,"MS4 Non-Tidal",2.0299999999999998,0.42,null,null,null,"Wet pond","H"]
["Final",null,{"$f":"'BMP Design'!F18","v":0},{"$f":"IF(C27=\"Tree planting\",'BMP Design'!AC18,IF(C27=\"Rainwater harvesting\",'BMP Design'!V18,IF(C27=\"Simple disconnection to amended soils\",'BMP Design'!AA18,IF(C27=\"Simple disconnection to a pervious area\",'BMP Design'!AA18,IF(C27=\"Simple disconnection to conservation area\",'BMP Design'!AA18,'BMP Design'!S18)))))","v":0},null,"Infiltration trench",15,22.5,{"$f":"IFERROR((VLOOKUP(C27,BMPCost,3,0)*D27)*('BMP Design'!V18/'BMP Design'!X18),0)","v":0},null,null,null,null,null,null,null,"Wet ED pond","H"]
[469.44,469.44,null,{"$f":"SUM(D16:D27)","v":0},null,"Grass channel",10,15,{"$f":"(IFERROR(VLOOKUP(C28,BMPCost,3,0),0))*D28","v":0},null,null,null,null,null,null,null,"Shallow wetland","I"]
["V-SWMP",null,null,{"$f":"Background!H22-References!D28","v":0},null,"Grass channel - amended soils",25,37.5,0,null,null,null,null,null,null,null,"ED shallow wetland","I"]
["<10000",">10000",null,null,null,"Dry swale",24,36,0,null,null,null,null,null,null,null,"Tree preservation","J"]
["Initial",null,null,null,null,"Wet Swale",15,22.5,0,null,null,null,null,null,null,null,"Tree planting","J"]
[620.52,917.29,null,null,null,"Wet pond",15,22.5,0]
["Final",null,null,null,null,"Micropool ED pond",24,36,0]
[134.9,215.83,null,null,null,"Wet ED pond",15,22.5,0]
["R-SWMP",null,null,null,null,"Shallow wetland",15,22.5,0]
["<10000",">10000",null,null,null,"ED shallow wetland",20,30,0]
["Initial",null,null,null,null,"Tree preservation",null,null,{"$f":"IFERROR(D37*H37,0)","v":0}]
[3561.24,6582.9,null,null,null,"Tree planting",325,487.5,0,null,"+ Unaccounted"]
["Final",null,null,null,null,null,null,null,{"$f":"SUM(I16:I27)","v":0},{"$f":"IF(D29>0,D29*I41,0)","v":0},{"$f":"I39+J39","v":0}]
[1618.75,2589.9899999999998,null,null,null,null,"Avg/ ft2","Inflation Rate","Inflation adjusted","10% DC Increase",{"$f":"K39*1.1","v":0}]
[null,null,null,null,null,null,{"$f":"AVERAGE(G16:G17,G22:G36)","v":18.823529411764707},{"$f":"(I41-G41)/G41","v":0.13159999999999988},{"$f":"G41*1.1316","v":21.30070588235294}]
[null,null,null,null,null,null,null,"10% DC Increase",{"$f":"I41*1.1","v":23.430776470588235}]
["Detailed Estimation Lookup Values"]
["Previous Year Average Sale Price of SRCs",null,2.02,{"$f":"IF(AND($C$44>=0.01,'Financial Input'!$I$8>=2),C$44*(1+'Financial Input'!$R$8),0)","v":2.0585819999999999},{"$f":"IF(AND($C$44>=0.01,'Financial Input'!$I$8>=3),D$44*(1+'Financial Input'!$R$8),0)","v":2.0979009161999995},{"$f":"IF(AND($C$44>=0.01,'Financial Input'!$I$8>=4),E$44*(1+'Financial Input'!$R$8),0)","v":2.1379708236994195},{"$f":"IF(AND($C$44>=0.01,'Financial Input'!$I$8>=5),F$44*(1+'Financial Input'!$R$8),0)","v":2.1788060664320783},{"$f":"IF(AND($C$44>=0.01,'Financial Input'!$I$8>=6),G$44*(1+'Financial Input'!$R$8),0)","v":2.2204212623009307},{"$f":"IF(AND($C$44>=0.01,'Financial Input'!$I$8>=7),H$44*(1+'Financial Input'!$R$8),0)","v":2.2628313084108784},{"$f":"IF(AND($C$44>=0.01,'Financial Input'!$I$8>=8),I$44*(1+'Financial Input'!$R$8),0)","v":2.306051386401526},{"$f":"IF(AND($C$44>=0.01,'Financial Input'!$I$8>=9),J$44*(1+'Financial Input'!$R$8),0)","v":2.3500969678817949},{"$f":"IF(AND($C$44>=0.01,'Financial Input'!$I$8>=10),K$44*(1+'Financial Input'!$R$8),0)","v":2.3949838199683371},{"$f":"IF(AND($C$44>=0.01,'Financial Input'!$I$8>=11),L$44*(1+'Financial Input'!$R$8),0)","v":2.4407280109297322},{"$f":"IF(AND($C$44>=0.01,'Financial Input'!$I$8>=12),M$44*(1+'Financial Input'!$R$8),0)","v":2.4873459159384899},{"$f":"IF(AND($C$44>=0.01,'Financial Input'!$I$8>=13),N$44*(1+'Financial Input'!$R$8),0)","v":0},{"$f":"IF(AND($C$44>=0.01,'Financial Input'!$I$8>=14),O$44*(1+'Financial Input'!$R$8),0)","v":0},{"$f":"IF(AND($C$44>=0.01,'Financial Input'!$I$8>=15),P$44*(1+'Financial Input'!$R$8),0)","v":0},{"$f":"IF(AND($C$44>=0.01,'Financial Input'!$I$8>=16),Q$44*(1+'Financial Input'!$R$8),0)","v":0},{"$f":"IF(AND($C$44>=0.01,'Financial Input'!$I$8>=17),R$44*(1+'Financial Input'!$R$8),0)","v":0},{"$f":"IF(AND($C$44>=0.01,'Financial Input'!$I$8>=18),S$44*(1+'Financial Input'!$R$8),0)","v":0},{"$f":"IF(AND($C$44>=0.01,'Financial Input'!$I$8>=19),T$44*(1+'Financial Input'!$R$8),0)","v":0},{"$f":"IF(AND($C$44>=0.01,'Financial Input'!$I$8>=20),U$44*(1+'Financial Input'!$R$8),0)","v":0},{"$f":"IF(AND($C$44>=0.01,'Financial Input'!$I$8>=20),V$44*(1+'Financial Input'!$R$8),0)","v":0},{"$f":"IF(AND($C$44>=0.01,'Financial Input'!$I$8>=20),W$44*(1+'Financial Input'!$R$8),0)","v":0},{"$f":"IF(AND($C$44>=0.01,'Financial Input'!$I$8>=20),X$44*(1+'Financial Input'!$R$8),0)","v":0},{"$f":"IF(AND($C$44>=0.01,'Financial Input'!$I$8>=20),Y$44*(1+'Financial Input'!$R$8),0)","v":0},{"$f":"IF(AND($C$44>=0.01,'Financial Input'!$I$8>=20),Z$44*(1+'Financial Input'!$R$8),0)","v":0},{"$f":"IF(AND($C$44>=0.01,'Financial Input'!$I$8>=20),AA$44*(1+'Financial Input'!$R$8),0)","v":0},{"$f":"IF(AND($C$44>=0.01,'Financial Input'!$I$8>=20),AB$44*(1+'Financial Input'!$R$8),0)","v":0},{"$f":"IF(AND($C$44>=0.01,'Financial Input'!$I$8>=20),AC$44*(1+'Financial Input'!$R$8),0)","v":0},{"$f":"IF(AND($C$44>=0.01,'Financial Input'!$I$8>=20),AD$44*(1+'Financial Input'!$R$8),0)","v":0},{"$f":"IF(AND($C$44>=0.01,'Financial Input'!$I$8>=20),AE$44*(1+'Financial Input'!$R$8),0)","v":0}]
[null,null,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046,2047]
["Maximum Discount on IAC",0.04,25.18,23,20.94,19.52,18.399999999999999,{"$f":"G46*1.1","v":20.239999999999998},{"$f":"H46*1.1","v":22.263999999999999},24.490400000000001,26.939440000000005,26.939440000000005,26.939440000000005,26.939440000000005,26.939440000000005,26.939440000000005,26.939440000000005,26.939440000000005,26.939440000000005,26.939440000000005,26.939440000000005,26.939440000000005,26.939440000000005,26.939440000000005,26.939440000000005,26.939440000000005,26.939440000000005,26.939440000000005,26.939440000000005,26.939440000000005,26.939440000000005,26.939440000000005]
["Maximum SW Fee Discount",0.55000000000000004,2.67,2.67,2.67,2.67,2.67,2.67,2.67,2.67,2.67,2.67,2.67,2.67,2.67,2.67,2.67,2.67,2.67,2.67,2.67,2.67,2.67,2.67,2.67,2.67,2.67,2.67,2.67,2.67,2.67,2.67]
["ILF",3.61,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30]
[null,null,"Yes","No",null,"Commercial","Multi-family","Residential"]
["GI Retention (gallons)",{"$f":"IF(ISBLANK('Financial Summary'!E6),1.7*((0.95*SUM(Background!G22:H22)+(0.25*Background!F22))*7.48/12),ROUND('Financial Summary'!E6,0))","v":0}]
["One-Half of GI Retention (gallons)",{"$f":"B50*0.5","v":0}]
["Pre-Project Residential Equivalent Residential Units (ERUs)",{"$f":"IF((SUM(Background!H23:'Background'!G23))/1000>11.1,13.5,IF((SUM(Background!H23:'Background'!G23))/1000>7.1,8.6,IF((SUM(Background!H23:'Background'!G23))/1000>3.1,3.8,IF((SUM(Background!H23:'Background'!G23))/1000>2.1,2.4,IF((SUM(Background!H23:'Background'!G23))/1000>0.7,1,0.6)))))","v":0.6}]
["Post-Project Residential ERUs",{"$f":"IF((SUM(Background!H22:'Background'!G22))/1000>11.1,13.5,IF((SUM(Background!H22:'Background'!G22))/1000>7.1,8.6,IF((SUM(Background!H22:'Background'!G22))/1000>3.1,3.8,IF((SUM(Background!H22:'Background'!G22))/1000>2.1,2.4,IF((SUM(Background!H22:'Background'!G22))/1000>0.7,1,0.6)))))","v":0.6}]
["DC Water IAC",null,{"$f":"IF('Financial Input'!$I$9=\"Residential\",C46*$B$53*12*-1,C46*(SUM(Background!$G$23:$H$23)/1000)*12*-1)","v":0},{"$f":"IF('Financial Input'!$I$9=\"Residential\",D46*$B$53*12*-1,D46*(SUM(Background!$G$23:$H$23)/1000)*12*-1)","v":0},{"$f":"IF('Financial Input'!$I$9=\"Residential\",E46*$B$53*12*-1,E46*(SUM(Background!$G$23:$H$23)/1000)*12*-1)","v":0},{"$f":"IF('Financial Input'!$I$9=\"Residential\",F46*$B$53*12*-1,F46*(SUM(Background!$G$23:$H$23)/1000)*12*-1)","v":0},{"$f":"IF('Financial Input'!$I$9=\"Residential\",G46*$B$53*12*-1,G46*(SUM(Background!$G$23:$H$23)/1000)*12*-1)","v":0},{"$f":"IF('Financial Input'!$I$9=\"Residential\",H46*$B$53*12*-1,H46*(SUM(Background!$G$23:$H$23)/1000)*12*-1)","v":0},{"$f":"IF('Financial Input'!$I$9=\"Residential\",I46*$B$53*12*-1,I46*(SUM(Background!$G$23:$H$23)/1000)*12*-1)","v":0},{"$f":"IF('Financial Input'!$I$9=\"Residential\",J46*$B$53*12*-1,J46*(SUM(Background!$G$23:$H$23)/1000)*12*-1)","v":0},{"$f":"IF('Financial Input'!$I$9=\"Residential\",K46*$B$53*12*-1,K46*(SUM(Background!$G$23:$H$23)/1000)*12*-1)","v":0},{"$f":"IF('Financial Input'!$I$9=\"Residential\",L46*$B$53*12*-1,L46*(SUM(Background!$G$23:$H$23)/1000)*12*-1)","v":0},{"$f":"IF('Financial Input'!$I$9=\"Residential\",M46*$B$53*12*-1,M46*(SUM(Background!$G$23:$H$23)/1000)*12*-1)","v":0},{"$f":"IF('Financial Input'!$I$9=\"Residential\",N46*$B$53*12*-1,N46*(SUM(Background!$G$23:$H$23)/1000)*12*-1)","v":0},{"$f":"IF('Financial Input'!$I$9=\"Residential\",O46*$B$53*12*-1,O46*(SUM(Background!$G$23:$H$23)/1000)*12*-1)","v":0},{"$f":"IF('Financial Input'!$I$9=\"Residential\",P46*$B$53*12*-1,P46*(SUM(Background!$G$23:$H$23)/1000)*12*-1)","v":0},{"$f":"IF('Financial Input'!$I$9=\"Residential\",Q46*$B$53*12*-1,Q46*(SUM(Background!$G$23:$H$23)/1000)*12*-1)","v":0},{"$f":"IF('Financial Input'!$I$9=\"Residential\",R46*$B$53*12*-1,R46*(SUM(Background!$G$23:$H$23)/1000)*12*-1)","v":0},{"$f":"IF('Financial Input'!$I$9=\"Residential\",S46*$B$53*12*-1,S46*(SUM(Background!$G$23:$H$23)/1000)*12*-1)","v":0},{"$f":"IF('Financial Input'!$I$9=\"Residential\",T46*$B$53*12*-1,T46*(SUM(Background!$G$23:$H$23)/1000)*12*-1)","v":0},{"$f":"IF('Financial Input'!$I$9=\"Residential\",U46*$B$53*12*-1,U46*(SUM(Background!$G$23:$H$23)/1000)*12*-1)","v":0},{"$f":"IF('Financial Input'!$I$9=\"Residential\",V46*$B$53*12*-1,V46*(SUM(Background!$G$23:$H$23)/1000)*12*-1)","v":0},{"$f":"IF('Financial Input'!$I$9=\"Residential\",W46*$B$53*12*-1,W46*(SUM(Background!$G$23:$H$23)/1000)*12*-1)","v":0},{"$f":"IF('Financial Input'!$I$9=\"Residential\",X46*$B$53*12*-1,X46*(SUM(Background!$G$23:$H$23)/1000)*12*-1)","v":0},{"$f":"IF('Financial Input'!$I$9=\"Residential\",Y46*$B$53*12*-1,Y46*(SUM(Background!$G$23:$H$23)/1000)*12*-1)","v":0},{"$f":"IF('Financial Input'!$I$9=\"Residential\",Z46*$B$53*12*-1,Z46*(SUM(Background!$G$23:$H$23)/1000)*12*-1)","v":0},{"$f":"IF('Financial Input'!$I$9=\"Residential\",AA46*$B$53*12*-1,AA46*(SUM(Background!$G$23:$H$23)/1000)*12*-1)","v":0},{"$f":"IF('Financial Input'!$I$9=\"Residential\",AB46*$B$53*12*-1,AB46*(SUM(Background!$G$23:$H$23)/1000)*12*-1)","v":0},{"$f":"IF('Financial Input'!$I$9=\"Residential\",AC46*$B$53*12*-1,AC46*(SUM(Background!$G$23:$H$23)/1000)*12*-1)","v":0},{"$f":"IF('Financial Input'!$I$9=\"Residential\",AD46*$B$53*12*-1,AD46*(SUM(Background!$G$23:$H$23)/1000)*12*-1)","v":0},{"$f":"IF('Financial Input'!$I$9=\"Residential\",AE46*$B$53*12*-1,AE46*(SUM(Background!$G$23:$H$23)/1000)*12*-1)","v":0},{"$f":"IF('Financial Input'!$I$9=\"Residential\",AF46*$B$53*12*-1,AF46*(SUM(Background!$G$23:$H$23)/1000)*12*-1)","v":0}]
["SW Fee",null,{"$f":"IF('Financial Input'!$I$9=\"Residential\",C47*$B$53*12*-1,C47*(SUM(Background!$G$23:$H$23)/1000)*12*-1)","v":0},{"$f":"IF('Financial Input'!$I$9=\"Residential\",D47*$B$53*12*-1,D47*(SUM(Background!$G$23:$H$23)/1000)*12*-1)","v":0},{"$f":"IF('Financial Input'!$I$9=\"Residential\",E47*$B$53*12*-1,E47*(SUM(Background!$G$23:$H$23)/1000)*12*-1)","v":0},{"$f":"IF('Financial Input'!$I$9=\"Residential\",F47*$B$53*12*-1,F47*(SUM(Background!$G$23:$H$23)/1000)*12*-1)","v":0},{"$f":"IF('Financial Input'!$I$9=\"Residential\",G47*$B$53*12*-1,G47*(SUM(Background!$G$23:$H$23)/1000)*12*-1)","v":0},{"$f":"IF('Financial Input'!$I$9=\"Residential\",H47*$B$53*12*-1,H47*(SUM(Background!$G$23:$H$23)/1000)*12*-1)","v":0},{"$f":"IF('Financial Input'!$I$9=\"Residential\",I47*$B$53*12*-1,I47*(SUM(Background!$G$23:$H$23)/1000)*12*-1)","v":0},{"$f":"IF('Financial Input'!$I$9=\"Residential\",J47*$B$53*12*-1,J47*(SUM(Background!$G$23:$H$23)/1000)*12*-1)","v":0},{"$f":"IF('Financial Input'!$I$9=\"Residential\",K47*$B$53*12*-1,K47*(SUM(Background!$G$23:$H$23)/1000)*12*-1)","v":0},{"$f":"IF('Financial Input'!$I$9=\"Residential\",L47*$B$53*12*-1,L47*(SUM(Background!$G$23:$H$23)/1000)*12*-1)","v":0},{"$f":"IF('Financial Input'!$I$9=\"Residential\",M47*$B$53*12*-1,M47*(SUM(Background!$G$23:$H$23)/1000)*12*-1)","v":0},{"$f":"IF('Financial Input'!$I$9=\"Residential\",N47*$B$53*12*-1,N47*(SUM(Background!$G$23:$H$23)/1000)*12*-1)","v":0},{"$f":"IF('Financial Input'!$I$9=\"Residential\",O47*$B$53*12*-1,O47*(SUM(Background!$G$23:$H$23)/1000)*12*-1)","v":0},{"$f":"IF('Financial Input'!$I$9=\"Residential\",P47*$B$53*12*-1,P47*(SUM(Background!$G$23:$H$23)/1000)*12*-1)","v":0},{"$f":"IF('Financial Input'!$I$9=\"Residential\",Q47*$B$53*12*-1,Q47*(SUM(Background!$G$23:$H$23)/1000)*12*-1)","v":0},{"$f":"IF('Financial Input'!$I$9=\"Residential\",R47*$B$53*12*-1,R47*(SUM(Background!$G$23:$H$23)/1000)*12*-1)","v":0},{"$f":"IF('Financial Input'!$I$9=\"Residential\",S47*$B$53*12*-1,S47*(SUM(Background!$G$23:$H$23)/1000)*12*-1)","v":0},{"$f":"IF('Financial Input'!$I$9=\"Residential\",T47*$B$53*12*-1,T47*(SUM(Background!$G$23:$H$23)/1000)*12*-1)","v":0},{"$f":"IF('Financial Input'!$I$9=\"Residential\",U47*$B$53*12*-1,U47*(SUM(Background!$G$23:$H$23)/1000)*12*-1)","v":0},{"$f":"IF('Financial Input'!$I$9=\"Residential\",V47*$B$53*12*-1,V47*(SUM(Background!$G$23:$H$23)/1000)*12*-1)","v":0},{"$f":"IF('Financial Input'!$I$9=\"Residential\",W47*$B$53*12*-1,W47*(SUM(Background!$G$23:$H$23)/1000)*12*-1)","v":0},{"$f":"IF('Financial Input'!$I$9=\"Residential\",X47*$B$53*12*-1,X47*(SUM(Background!$G$23:$H$23)/1000)*12*-1)","v":0},{"$f":"IF('Financial Input'!$I$9=\"Residential\",Y47*$B$53*12*-1,Y47*(SUM(Background!$G$23:$H$23)/1000)*12*-1)","v":0},{"$f":"IF('Financial Input'!$I$9=\"Residential\",Z47*$B$53*12*-1,Z47*(SUM(Background!$G$23:$H$23)/1000)*12*-1)","v":0},{"$f":"IF('Financial Input'!$I$9=\"Residential\",AA47*$B$53*12*-1,AA47*(SUM(Background!$G$23:$H$23)/1000)*12*-1)","v":0},{"$f":"IF('Financial Input'!$I$9=\"Residential\",AB47*$B$53*12*-1,AB47*(SUM(Background!$G$23:$H$23)/1000)*12*-1)","v":0},{"$f":"IF('Financial Input'!$I$9=\"Residential\",AC47*$B$53*12*-1,AC47*(SUM(Background!$G$23:$H$23)/1000)*12*-1)","v":0},{"$f":"IF('Financial Input'!$I$9=\"Residential\",AD47*$B$53*12*-1,AD47*(SUM(Background!$G$23:$H$23)/1000)*12*-1)","v":0},{"$f":"IF('Financial Input'!$I$9=\"Residential\",AE47*$B$53*12*-1,AE47*(SUM(Background!$G$23:$H$23)/1000)*12*-1)","v":0},{"$f":"IF('Financial Input'!$I$9=\"Residential\",AF47*$B$53*12*-1,AF47*(SUM(Background!$G$23:$H$23)/1000)*12*-1)","v":0}]
["Value of SRC-Eligible Retention Based on Selling Price",null,{"$f":"$B$50*'Detailed Estimation'!H12","v":0},{"$f":"$B$50*'Detailed Estimation'!I12","v":0},{"$f":"$B$50*'Detailed Estimation'!J12","v":0},{"$f":"$B$50*'Detailed Estimation'!K12","v":0},{"$f":"$B$50*'Detailed Estimation'!L12","v":0},{"$f":"$B$50*'Detailed Estimation'!M12","v":0},{"$f":"$B$50*'Detailed Estimation'!N12","v":0},{"$f":"$B$50*'Detailed Estimation'!O12","v":0},{"$f":"$B$50*'Detailed Estimation'!P12","v":0},{"$f":"$B$50*'Detailed Estimation'!Q12","v":0},{"$f":"$B$50*'Detailed Estimation'!R12","v":0},{"$f":"$B$50*'Detailed Estimation'!S12","v":0},{"$f":"$B$50*'Detailed Estimation'!T12","v":0},{"$f":"$B$50*'Detailed Estimation'!U12","v":0},{"$f":"$B$50*'Detailed Estimation'!V12","v":0},{"$f":"$B$50*'Detailed Estimation'!W12","v":0},{"$f":"$B$50*'Detailed Estimation'!X12","v":0},{"$f":"$B$50*'Detailed Estimation'!Y12","v":0},{"$f":"$B$50*'Detailed Estimation'!Z12","v":0},{"$f":"$B$50*'Detailed Estimation'!AA12","v":0},{"$f":"$B$50*'Detailed Estimation'!AB12","v":0},{"$f":"$B$50*'Detailed Estimation'!AC12","v":0},{"$f":"$B$50*'Detailed Estimation'!AD12","v":0},{"$f":"$B$50*'Detailed Estimation'!AE12","v":0},{"$f":"$B$50*'Detailed Estimation'!AF12","v":0},{"$f":"$B$50*'Detailed Estimation'!AG12","v":0},{"$f":"$B$50*'Detailed Estimation'!AH12","v":0},{"$f":"$B$50*'Detailed Estimation'!AI12","v":0},{"$f":"$B$50*'Detailed Estimation'!AJ12","v":0},{"$f":"$B$50*'Detailed Estimation'!AK12","v":0}]
["Value of GI Retention Based on Avg Price",null,{"$f":"$B$50*C44","v":0},{"$f":"$B$50*D44","v":0},0,{"$f":"$B$50*F44","v":0},0,0,0,0,0,0,0,0,{"$f":"$B$50*O44","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Value of One-Half of GI Retention Based on Avg Price",null,{"$f":"C57*0.5","v":0},{"$f":"D57*0.5","v":0},0,{"$f":"F57*0.5","v":0},0,0,0,0,0,0,0,0,{"$f":"O57*0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Remaining Obligation to DDOE",null,{"$f":"IF('Financial Input'!$I$17-C58>=0,'Financial Input'!$I$17-C58,0)","v":0},{"$f":"IF(C59-D58>=0,C59-D58,0)","v":0},{"$f":"IF(D59-E58>=0,D59-E58,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Cumulative Costs",null,{"$f":"'Detailed Estimation'!H10","v":-339.36},{"$f":"SUM('Detailed Estimation'!$H$10:I10)","v":-678.72},{"$f":"SUM('Detailed Estimation'!$H$10:J10)","v":-1018.08},{"$f":"SUM('Detailed Estimation'!$H$10:K10)","v":-1357.44},{"$f":"SUM('Detailed Estimation'!$H$10:L10)","v":-1696.8000000000002},{"$f":"SUM('Detailed Estimation'!$H$10:M10)","v":-2036.1600000000003},{"$f":"SUM('Detailed Estimation'!$H$10:N10)","v":-2036.1600000000003},{"$f":"SUM('Detailed Estimation'!$H$10:O10)","v":-2036.1600000000003},{"$f":"SUM('Detailed Estimation'!$H$10:P10)","v":-2036.1600000000003},{"$f":"SUM('Detailed Estimation'!$H$10:Q10)","v":-2036.1600000000003},{"$f":"SUM('Detailed Estimation'!$H$10:R10)","v":-2036.1600000000003},{"$f":"SUM('Detailed Estimation'!$H$10:S10)","v":-2036.1600000000003},{"$f":"SUM('Detailed Estimation'!$H$10:T10)","v":-2036.1600000000003},{"$f":"SUM('Detailed Estimation'!$H$10:U10)","v":-2036.1600000000003},{"$f":"SUM('Detailed Estimation'!$H$10:V10)","v":-2036.1600000000003},{"$f":"SUM('Detailed Estimation'!$H$10:W10)","v":-2036.1600000000003},{"$f":"SUM('Detailed Estimation'!$H$10:X10)","v":-2036.1600000000003},{"$f":"SUM('Detailed Estimation'!$H$10:Y10)","v":-2036.1600000000003},{"$f":"SUM('Detailed Estimation'!$H$10:Z10)","v":-2036.1600000000003},{"$f":"SUM('Detailed Estimation'!$H$10:AA10)","v":-2036.1600000000003},{"$f":"SUM('Detailed Estimation'!$H$10:AB10)","v":-2036.1600000000003},{"$f":"SUM('Detailed Estimation'!$H$10:AC10)","v":-2036.1600000000003},{"$f":"SUM('Detailed Estimation'!$H$10:AD10)","v":-2036.1600000000003},{"$f":"SUM('Detailed Estimation'!$H$10:AE10)","v":-2036.1600000000003},{"$f":"SUM('Detailed Estimation'!$H$10:AF10)","v":-2036.1600000000003},{"$f":"SUM('Detailed Estimation'!$H$10:AG10)","v":-2036.1600000000003},{"$f":"SUM('Detailed Estimation'!$H$10:AH10)","v":-2036.1600000000003},{"$f":"SUM('Detailed Estimation'!$H$10:AI10)","v":-2036.1600000000003},{"$f":"SUM('Detailed Estimation'!$H$10:AJ10)","v":-2036.1600000000003},{"$f":"SUM('Detailed Estimation'!$H$10:AK10)","v":-2036.1600000000003}]
["Cumulative Revenue",null,{"$f":"'Detailed Estimation'!H17","v":0},{"$f":"SUM('Detailed Estimation'!$H$17:I17)","v":0},{"$f":"SUM('Detailed Estimation'!$H$17:J17)","v":0},{"$f":"SUM('Detailed Estimation'!$H$17:K17)","v":0},{"$f":"SUM('Detailed Estimation'!$H$17:L17)","v":0},{"$f":"SUM('Detailed Estimation'!$H$17:M17)","v":0},{"$f":"SUM('Detailed Estimation'!$H$17:N17)","v":0},{"$f":"SUM('Detailed Estimation'!$H$17:O17)","v":0},{"$f":"SUM('Detailed Estimation'!$H$17:P17)","v":0},{"$f":"SUM('Detailed Estimation'!$H$17:Q17)","v":0},{"$f":"SUM('Detailed Estimation'!$H$17:R17)","v":0},{"$f":"SUM('Detailed Estimation'!$H$17:S17)","v":0},{"$f":"SUM('Detailed Estimation'!$H$17:T17)","v":0},{"$f":"SUM('Detailed Estimation'!$H$17:U17)","v":0},{"$f":"SUM('Detailed Estimation'!$H$17:V17)","v":0},{"$f":"SUM('Detailed Estimation'!$H$17:W17)","v":0},{"$f":"SUM('Detailed Estimation'!$H$17:X17)","v":0},{"$f":"SUM('Detailed Estimation'!$H$17:Y17)","v":0},{"$f":"SUM('Detailed Estimation'!$H$17:Z17)","v":0},{"$f":"SUM('Detailed Estimation'!$H$17:AA17)","v":0},{"$f":"SUM('Detailed Estimation'!$H$17:AB17)","v":0},{"$f":"SUM('Detailed Estimation'!$H$17:AC17)","v":0},{"$f":"SUM('Detailed Estimation'!$H$17:AD17)","v":0},{"$f":"SUM('Detailed Estimation'!$H$17:AE17)","v":0},{"$f":"SUM('Detailed Estimation'!$H$17:AF17)","v":0},{"$f":"SUM('Detailed Estimation'!$H$17:AG17)","v":0},{"$f":"SUM('Detailed Estimation'!$H$17:AH17)","v":0},{"$f":"SUM('Detailed Estimation'!$H$17:AI17)","v":0},{"$f":"SUM('Detailed Estimation'!$H$17:AJ17)","v":0},{"$f":"SUM('Detailed Estimation'!$H$17:AK17)","v":0}]
["Year",{"$f":"IF('Financial Summary'!$M$3=\"ROI vs. SRC Price\",\"Price\",\"Cost\")","v":"Cost"},{"$f":"IF('Financial Summary'!$M$3=\"ROI vs. SRC Price\",\"IRR\",\"Revenue\")","v":"Revenue"},null,"Cost","Revenue"]
[{"$f":"IF(AND(B63>0,B63<>\"\"),D63,\"\")","v":""},{"$f":"IF('Financial Summary'!$M$3=\"Cost vs. Revenue\",IF(References!E63>0,E63,\"\"),IF(References!E94>0,E94,\"\"))","v":""},{"$f":"IF('Financial Summary'!$M$3=\"Cost vs. Revenue\",IF(References!F63>0,F63,\"\"),IF(References!F94>0,F94,\"\"))","v":{"$error":"#NUM!"}},2018,{"$f":"-('Detailed Estimation'!$H$10)","v":339.36},{"$f":"('Detailed Estimation'!$H$17)","v":0},{"$f":"-E63","v":-339.36},{"$f":"F63","v":0},null,"Year","Detailed Est Data","Detailed Est Data","Cost - BMP LC","Revenue - BMP LC","Cost - IP","Revenue - IP","Year","Year","Investment Period Costs","Investment Period Revenue","BMP Life Cycle Costs","BMP Life Cycle Revenue"]
[{"$f":"IF(AND(B64>0,B64<>\"\"),D64,\"\")","v":""},{"$f":"IF('Financial Summary'!$M$3=\"Cost vs. Revenue\",IF(References!E64>0,E64,\"\"),IF(References!E95>0,E95,\"\"))","v":""},{"$f":"IF('Financial Summary'!$M$3=\"Cost vs. Revenue\",IF(References!F64>0,F64,\"\"),IF(References!F95>0,F95,\"\"))","v":{"$error":"#NUM!"}},2019,{"$f":"-('Detailed Estimation'!$H$10)","v":339.36},{"$f":"IF('Financial Input'!H8>=References!D48,SUM('Detailed Estimation'!$H$17:$I$17),0)","v":0},{"$f":"-E64","v":-339.36},{"$f":"F64","v":0},null,0,{"$f":"'Detailed Estimation'!H6*-1","v":0},null,{"$f":"K64","v":0},null,{"$f":"K64","v":0},null,0,0,{"$f":"K64","v":0},null,{"$f":"K64","v":0},null,0]
["",{"$f":"IF('Financial Summary'!$M$3=\"Cost vs. Revenue\",IF(References!E65>0,E65,\"\"),IF(References!E96>0,E96,\"\"))","v":""},{"$f":"IF('Financial Summary'!$M$3=\"Cost vs. Revenue\",IF(References!F65>0,F65,\"\"),IF(References!F96>0,F96,\"\"))","v":{"$error":"#NUM!"}},2020,{"$f":"-('Detailed Estimation'!$H$10)","v":339.36},{"$f":"IF('Financial Input'!H8>=References!E48,SUM('Detailed Estimation'!$H$17:$J$17),0)","v":0},-339.36,0,{"$f":"IF(J65<='Financial Input'!$I$8,J65,'Financial Input'!$I$8)","v":1},1,{"$f":"(SUMIF('Detailed Estimation'!$H$4:$AK$4,\"<=\"&I65,'Detailed Estimation'!$H$10:$AK$10))*-1","v":339.36},{"$f":"SUMIF('Detailed Estimation'!$H$4:$AK$4,\"<=\"&I65,'Detailed Estimation'!$H$17:$AK$17)","v":0},{"$f":"(SUMIF('Detailed Estimation'!$H$4:$AK$4,\"<=\"&J65,'Detailed Estimation'!$H$10:$AK$10))*-1","v":339.36},{"$f":"SUMIF('Detailed Estimation'!$H$4:$AK$4,\"<=\"&J65,'Detailed Estimation'!$H$17:$AK$17)","v":0},{"$f":"IF(K65>0,K65,0)","v":339.36},{"$f":"IF(L65>0,L65,0)","v":0},1,1,{"$f":"VLOOKUP(R65,$J$64:$O$94,6,0)","v":339.36},{"$f":"P67","v":0},{"$f":"VLOOKUP(R65,$J$64:$M$94,4,0)","v":339.36},{"$f":"N67","v":0},1]
["",{"$f":"IF('Financial Summary'!$M$3=\"Cost vs. Revenue\",IF(References!E66>0,E66,\"\"),IF(References!E97>0,E97,\"\"))","v":""},{"$f":"IF('Financial Summary'!$M$3=\"Cost vs. Revenue\",IF(References!F66>0,F66,\"\"),IF(References!F97>0,F97,\"\"))","v":{"$error":"#NUM!"}},2021,{"$f":"-('Detailed Estimation'!$H$10)","v":339.36},{"$f":"IF('Financial Input'!H8>=References!F48,SUM('Detailed Estimation'!$H$17:$K$17),0)","v":0},-339.36,0,{"$f":"IF(J66<='Financial Input'!$I$8,J66,'Financial Input'!$I$8)","v":2},2,{"$f":"(SUMIF('Detailed Estimation'!$H$4:$AK$4,\"<=\"&I66,'Detailed Estimation'!$H$10:$AK$10))*-1","v":678.72},{"$f":"SUMIF('Detailed Estimation'!$H$4:$AK$4,\"<=\"&I66,'Detailed Estimation'!$H$17:$AK$17)","v":0},{"$f":"(SUMIF('Detailed Estimation'!$H$4:$AK$4,\"<=\"&J66,'Detailed Estimation'!$H$10:$AK$10))*-1","v":678.72},{"$f":"SUMIF('Detailed Estimation'!$H$4:$AK$4,\"<=\"&J66,'Detailed Estimation'!$H$17:$AK$17)","v":0},{"$f":"IF(J66=I66,K66,\"\")","v":678.72},{"$f":"IF(I66=J66,L66,\"\")","v":0},2,2,{"$f":"VLOOKUP(R66,$J$64:$O$94,6,0)","v":678.72},{"$f":"T65","v":0},{"$f":"VLOOKUP(R66,$J$64:$M$94,4,0)","v":678.72},{"$f":"V65","v":0},4]
["",{"$f":"IF('Financial Summary'!$M$3=\"Cost vs. Revenue\",IF(References!E67>0,E67,\"\"),IF(References!E98>0,E98,\"\"))","v":""},{"$f":"IF('Financial Summary'!$M$3=\"Cost vs. Revenue\",IF(References!F67>0,F67,\"\"),IF(References!F98>0,F98,\"\"))","v":{"$error":"#NUM!"}},2022,{"$f":"-('Detailed Estimation'!$H$10)","v":339.36},{"$f":"IF('Financial Input'!H8>=References!G48,SUM('Detailed Estimation'!$H$17:$L$17),0)","v":0},-339.36,0,{"$f":"IF(J67<='Financial Input'!$I$8,J67,'Financial Input'!$I$8)","v":3},3,{"$f":"(SUMIF('Detailed Estimation'!$H$4:$AK$4,\"<=\"&I67,'Detailed Estimation'!$H$10:$AK$10))*-1","v":1018.08},{"$f":"SUMIF('Detailed Estimation'!$H$4:$AK$4,\"<=\"&I67,'Detailed Estimation'!$H$17:$AK$17)","v":0},{"$f":"(SUMIF('Detailed Estimation'!$H$4:$AK$4,\"<=\"&J67,'Detailed Estimation'!$H$10:$AK$10))*-1","v":1018.08},{"$f":"SUMIF('Detailed Estimation'!$H$4:$AK$4,\"<=\"&J67,'Detailed Estimation'!$H$17:$AK$17)","v":0},1018.08,0,3,3,1018.08,{"$f":"T66","v":0},1018.08,{"$f":"V66","v":0},7]
["",{"$f":"IF('Financial Summary'!$M$3=\"Cost vs. Revenue\",IF(References!E68>0,E68,\"\"),IF(References!E99>0,E99,\"\"))","v":""},{"$f":"IF('Financial Summary'!$M$3=\"Cost vs. Revenue\",IF(References!F68>0,F68,\"\"),IF(References!F99>0,F99,\"\"))","v":{"$error":"#NUM!"}},2023,{"$f":"-('Detailed Estimation'!$H$10)","v":339.36},{"$f":"IF('Financial Input'!H8>=References!H48,SUM('Detailed Estimation'!$H$17:$M$17),0)","v":0},-339.36,0,{"$f":"IF(J68<='Financial Input'!$I$8,J68,'Financial Input'!$I$8)","v":4},4,{"$f":"(SUMIF('Detailed Estimation'!$H$4:$AK$4,\"<=\"&I68,'Detailed Estimation'!$H$10:$AK$10))*-1","v":1357.44},{"$f":"SUMIF('Detailed Estimation'!$H$4:$AK$4,\"<=\"&I68,'Detailed Estimation'!$H$17:$AK$17)","v":0},{"$f":"(SUMIF('Detailed Estimation'!$H$4:$AK$4,\"<=\"&J68,'Detailed Estimation'!$H$10:$AK$10))*-1","v":1357.44},{"$f":"SUMIF('Detailed Estimation'!$H$4:$AK$4,\"<=\"&J68,'Detailed Estimation'!$H$17:$AK$17)","v":0},1357.44,0,4,4,{"$f":"S69","v":1357.44},{"$f":"P67","v":0},{"$f":"U69","v":1357.44},{"$f":"N67","v":0},10]
["",{"$f":"IF('Financial Summary'!$M$3=\"Cost vs. Revenue\",IF(References!E69>0,E69,\"\"),IF(References!E100>0,E100,\"\"))","v":""},{"$f":"IF('Financial Summary'!$M$3=\"Cost vs. Revenue\",IF(References!F69>0,F69,\"\"),IF(References!F100>0,F100,\"\"))","v":{"$error":"#NUM!"}},2024,{"$f":"-('Detailed Estimation'!$H$10)","v":339.36},{"$f":"IF('Financial Input'!H8>=References!I48,SUM('Detailed Estimation'!$H$17:$N$17),0)","v":0},-339.36,0,{"$f":"IF(J69<='Financial Input'!$I$8,J69,'Financial Input'!$I$8)","v":5},5,{"$f":"(SUMIF('Detailed Estimation'!$H$4:$AK$4,\"<=\"&I69,'Detailed Estimation'!$H$10:$AK$10))*-1","v":1696.8000000000002},{"$f":"SUMIF('Detailed Estimation'!$H$4:$AK$4,\"<=\"&I69,'Detailed Estimation'!$H$17:$AK$17)","v":0},{"$f":"(SUMIF('Detailed Estimation'!$H$4:$AK$4,\"<=\"&J69,'Detailed Estimation'!$H$10:$AK$10))*-1","v":1696.8000000000002},{"$f":"SUMIF('Detailed Estimation'!$H$4:$AK$4,\"<=\"&J69,'Detailed Estimation'!$H$17:$AK$17)","v":0},1696.8000000000002,0,5,4,{"$f":"VLOOKUP(R69,$J$64:$O$94,6,0)","v":1357.44},{"$f":"P70","v":0},{"$f":"VLOOKUP(R69,$J$64:$M$94,4,0)","v":1357.44},{"$f":"N70","v":0},13]
["",{"$f":"IF('Financial Summary'!$M$3=\"Cost vs. Revenue\",IF(References!E70>0,E70,\"\"),IF(References!E101>0,E101,\"\"))","v":""},{"$f":"IF('Financial Summary'!$M$3=\"Cost vs. Revenue\",IF(References!F70>0,F70,\"\"),IF(References!F101>0,F101,\"\"))","v":{"$error":"#NUM!"}},2025,{"$f":"-('Detailed Estimation'!$H$10)","v":339.36},{"$f":"IF('Financial Input'!H8>=References!J48,SUM('Detailed Estimation'!$H$17:$O$17),0)","v":0},-339.36,0,{"$f":"IF(J70<='Financial Input'!$I$8,J70,'Financial Input'!$I$8)","v":6},6,{"$f":"(SUMIF('Detailed Estimation'!$H$4:$AK$4,\"<=\"&I70,'Detailed Estimation'!$H$10:$AK$10))*-1","v":2036.1600000000003},{"$f":"SUMIF('Detailed Estimation'!$H$4:$AK$4,\"<=\"&I70,'Detailed Estimation'!$H$17:$AK$17)","v":0},{"$f":"(SUMIF('Detailed Estimation'!$H$4:$AK$4,\"<=\"&J70,'Detailed Estimation'!$H$10:$AK$10))*-1","v":2036.1600000000003},{"$f":"SUMIF('Detailed Estimation'!$H$4:$AK$4,\"<=\"&J70,'Detailed Estimation'!$H$17:$AK$17)","v":0},2036.1600000000003,0,6,5,{"$f":"VLOOKUP(R70,$J$65:$O$94,6,0)","v":1696.8000000000002},{"$f":"T69","v":0},{"$f":"VLOOKUP(R70,$J$64:$M$94,4,0)","v":1696.8000000000002},{"$f":"V69","v":0},16]
["",{"$f":"IF('Financial Summary'!$M$3=\"Cost vs. Revenue\",IF(References!E71>0,E71,\"\"),IF(References!E102>0,E102,\"\"))","v":""},{"$f":"IF('Financial Summary'!$M$3=\"Cost vs. Revenue\",IF(References!F71>0,F71,\"\"),IF(References!F102>0,F102,\"\"))","v":{"$error":"#NUM!"}},2026,{"$f":"-('Detailed Estimation'!$H$10)","v":339.36},{"$f":"IF('Financial Input'!H8>=References!K48,SUM('Detailed Estimation'!$H$17:$P$17),0)","v":0},-339.36,0,{"$f":"IF(J71<='Financial Input'!$I$8,J71,'Financial Input'!$I$8)","v":7},7,{"$f":"(SUMIF('Detailed Estimation'!$H$4:$AK$4,\"<=\"&I71,'Detailed Estimation'!$H$10:$AK$10))*-1","v":2036.1600000000003},{"$f":"SUMIF('Detailed Estimation'!$H$4:$AK$4,\"<=\"&I71,'Detailed Estimation'!$H$17:$AK$17)","v":0},{"$f":"(SUMIF('Detailed Estimation'!$H$4:$AK$4,\"<=\"&J71,'Detailed Estimation'!$H$10:$AK$10))*-1","v":2036.1600000000003},{"$f":"SUMIF('Detailed Estimation'!$H$4:$AK$4,\"<=\"&J71,'Detailed Estimation'!$H$17:$AK$17)","v":0},2036.1600000000003,0,7,6,{"$f":"VLOOKUP(R71,$J$65:$O$94,6,0)","v":2036.1600000000003},{"$f":"T70","v":0},{"$f":"VLOOKUP(R71,$J$64:$M$94,4,0)","v":2036.1600000000003},{"$f":"V70","v":0},19]
["",{"$f":"IF('Financial Summary'!$M$3=\"Cost vs. Revenue\",IF(References!E72>0,E72,\"\"),IF(References!E103>0,E103,\"\"))","v":""},{"$f":"IF('Financial Summary'!$M$3=\"Cost vs. Revenue\",IF(References!F72>0,F72,\"\"),IF(References!F103>0,F103,\"\"))","v":{"$error":"#NUM!"}},2027,{"$f":"-('Detailed Estimation'!$H$10)","v":339.36},{"$f":"IF('Financial Input'!H8>=References!L48,SUM('Detailed Estimation'!$H$17:$Q$17),0)","v":0},-339.36,0,{"$f":"IF(J72<='Financial Input'!$I$8,J72,'Financial Input'!$I$8)","v":8},8,{"$f":"(SUMIF('Detailed Estimation'!$H$4:$AK$4,\"<=\"&I72,'Detailed Estimation'!$H$10:$AK$10))*-1","v":2036.1600000000003},{"$f":"SUMIF('Detailed Estimation'!$H$4:$AK$4,\"<=\"&I72,'Detailed Estimation'!$H$17:$AK$17)","v":0},{"$f":"(SUMIF('Detailed Estimation'!$H$4:$AK$4,\"<=\"&J72,'Detailed Estimation'!$H$10:$AK$10))*-1","v":2036.1600000000003},{"$f":"SUMIF('Detailed Estimation'!$H$4:$AK$4,\"<=\"&J72,'Detailed Estimation'!$H$17:$AK$17)","v":0},2036.1600000000003,0,8,7,{"$f":"S73","v":2036.1600000000003},{"$f":"P70","v":0},{"$f":"U73","v":2036.1600000000003},{"$f":"N70","v":0},22]
["",{"$f":"IF('Financial Summary'!$M$3=\"Cost vs. Revenue\",IF(References!E73>0,E73,\"\"),IF(References!E104>0,E104,\"\"))","v":""},{"$f":"IF('Financial Summary'!$M$3=\"Cost vs. Revenue\",IF(References!F73>0,F73,\"\"),IF(References!F104>0,F104,\"\"))","v":{"$error":"#NUM!"}},2028,{"$f":"-('Detailed Estimation'!$H$10)","v":339.36},{"$f":"IF('Financial Input'!H8>=References!M48,SUM('Detailed Estimation'!$H$17:$R$17),0)","v":0},-339.36,0,{"$f":"IF(J73<='Financial Input'!$I$8,J73,'Financial Input'!$I$8)","v":9},9,{"$f":"(SUMIF('Detailed Estimation'!$H$4:$AK$4,\"<=\"&I73,'Detailed Estimation'!$H$10:$AK$10))*-1","v":2036.1600000000003},{"$f":"SUMIF('Detailed Estimation'!$H$4:$AK$4,\"<=\"&I73,'Detailed Estimation'!$H$17:$AK$17)","v":0},{"$f":"(SUMIF('Detailed Estimation'!$H$4:$AK$4,\"<=\"&J73,'Detailed Estimation'!$H$10:$AK$10))*-1","v":2036.1600000000003},{"$f":"SUMIF('Detailed Estimation'!$H$4:$AK$4,\"<=\"&J73,'Detailed Estimation'!$H$17:$AK$17)","v":0},2036.1600000000003,0,9,7,{"$f":"VLOOKUP(R73,$J$65:$O$94,6,0)","v":2036.1600000000003},{"$f":"P73","v":0},{"$f":"VLOOKUP(R73,$J$64:$M$94,4,0)","v":2036.1600000000003},{"$f":"N73","v":0},25]
["",{"$f":"IF('Financial Summary'!$M$3=\"Cost vs. Revenue\",IF(References!E74>0,E74,\"\"),IF(References!E105>0,E105,\"\"))","v":""},{"$f":"IF('Financial Summary'!$M$3=\"Cost vs. Revenue\",IF(References!F74>0,F74,\"\"),IF(References!F105>0,F105,\"\"))","v":{"$error":"#NUM!"}},2029,{"$f":"-('Detailed Estimation'!$H$10)","v":339.36},{"$f":"IF('Financial Input'!H8>=References!N48,SUM('Detailed Estimation'!$H$17:$S$17),0)","v":0},-339.36,0,{"$f":"IF(J74<='Financial Input'!$I$8,J74,'Financial Input'!$I$8)","v":10},10,{"$f":"(SUMIF('Detailed Estimation'!$H$4:$AK$4,\"<=\"&I74,'Detailed Estimation'!$H$10:$AK$10))*-1","v":2036.1600000000003},{"$f":"SUMIF('Detailed Estimation'!$H$4:$AK$4,\"<=\"&I74,'Detailed Estimation'!$H$17:$AK$17)","v":0},{"$f":"(SUMIF('Detailed Estimation'!$H$4:$AK$4,\"<=\"&J74,'Detailed Estimation'!$H$10:$AK$10))*-1","v":2036.1600000000003},{"$f":"SUMIF('Detailed Estimation'!$H$4:$AK$4,\"<=\"&J74,'Detailed Estimation'!$H$17:$AK$17)","v":0},2036.1600000000003,0,10,8,{"$f":"VLOOKUP(R74,$J$65:$O$94,6,0)","v":2036.1600000000003},{"$f":"T73","v":0},{"$f":"VLOOKUP(R74,$J$64:$M$94,4,0)","v":2036.1600000000003},{"$f":"V73","v":0},28]
["",{"$f":"IF('Financial Summary'!$M$3=\"Cost vs. Revenue\",IF(References!E75>0,E75,\"\"),IF(References!E106>0,E106,\"\"))","v":""},{"$f":"IF('Financial Summary'!$M$3=\"Cost vs. Revenue\",IF(References!F75>0,F75,\"\"),IF(References!F106>0,F106,\"\"))","v":{"$error":"#NUM!"}},2030,{"$f":"-('Detailed Estimation'!$H$10)","v":339.36},{"$f":"IF('Financial Input'!H8>=References!O48,SUM('Detailed Estimation'!$H$17:$T$17),0)","v":0},-339.36,0,{"$f":"IF(J75<='Financial Input'!$I$8,J75,'Financial Input'!$I$8)","v":11},11,{"$f":"(SUMIF('Detailed Estimation'!$H$4:$AK$4,\"<=\"&I75,'Detailed Estimation'!$H$10:$AK$10))*-1","v":2036.1600000000003},{"$f":"SUMIF('Detailed Estimation'!$H$4:$AK$4,\"<=\"&I75,'Detailed Estimation'!$H$17:$AK$17)","v":0},{"$f":"(SUMIF('Detailed Estimation'!$H$4:$AK$4,\"<=\"&J75,'Detailed Estimation'!$H$10:$AK$10))*-1","v":2036.1600000000003},{"$f":"SUMIF('Detailed Estimation'!$H$4:$AK$4,\"<=\"&J75,'Detailed Estimation'!$H$17:$AK$17)","v":0},2036.1600000000003,0,11,9,{"$f":"VLOOKUP(R75,$J$65:$O$94,6,0)","v":2036.1600000000003},{"$f":"T74","v":0},{"$f":"VLOOKUP(R75,$J$64:$M$94,4,0)","v":2036.1600000000003},{"$f":"V74","v":0}]
["",{"$f":"IF('Financial Summary'!$M$3=\"Cost vs. Revenue\",IF(References!E76>0,E76,\"\"),IF(References!E107>0,E107,\"\"))","v":""},{"$f":"IF('Financial Summary'!$M$3=\"Cost vs. Revenue\",IF(References!F76>0,F76,\"\"),IF(References!F107>0,F107,\"\"))","v":{"$error":"#NUM!"}},2031,{"$f":"-('Detailed Estimation'!$H$10)","v":339.36},{"$f":"IF('Financial Input'!H8>=References!P48,SUM('Detailed Estimation'!$H$17:$U$17),0)","v":0},-339.36,0,{"$f":"IF(J76<='Financial Input'!$I$8,J76,'Financial Input'!$I$8)","v":12},12,{"$f":"(SUMIF('Detailed Estimation'!$H$4:$AK$4,\"<=\"&I76,'Detailed Estimation'!$H$10:$AK$10))*-1","v":2036.1600000000003},{"$f":"SUMIF('Detailed Estimation'!$H$4:$AK$4,\"<=\"&I76,'Detailed Estimation'!$H$17:$AK$17)","v":0},{"$f":"(SUMIF('Detailed Estimation'!$H$4:$AK$4,\"<=\"&J76,'Detailed Estimation'!$H$10:$AK$10))*-1","v":2036.1600000000003},{"$f":"SUMIF('Detailed Estimation'!$H$4:$AK$4,\"<=\"&J76,'Detailed Estimation'!$H$17:$AK$17)","v":0},2036.1600000000003,0,12,10,{"$f":"S77","v":2036.1600000000003},{"$f":"P73","v":0},{"$f":"U77","v":2036.1600000000003},{"$f":"N73","v":0}]
["",{"$f":"IF('Financial Summary'!$M$3=\"Cost vs. Revenue\",IF(References!E77>0,E77,\"\"),IF(References!E108>0,E108,\"\"))","v":""},{"$f":"IF('Financial Summary'!$M$3=\"Cost vs. Revenue\",IF(References!F77>0,F77,\"\"),IF(References!F108>0,F108,\"\"))","v":{"$error":"#NUM!"}},2032,{"$f":"-('Detailed Estimation'!$H$10)","v":339.36},{"$f":"IF('Financial Input'!H8>=References!Q48,SUM('Detailed Estimation'!$H$17:$V$17),0)","v":0},-339.36,0,{"$f":"IF(J77<='Financial Input'!$I$8,J77,'Financial Input'!$I$8)","v":12},13,{"$f":"(SUMIF('Detailed Estimation'!$H$4:$AK$4,\"<=\"&I77,'Detailed Estimation'!$H$10:$AK$10))*-1","v":2036.1600000000003},{"$f":"SUMIF('Detailed Estimation'!$H$4:$AK$4,\"<=\"&I77,'Detailed Estimation'!$H$17:$AK$17)","v":0},{"$f":"(SUMIF('Detailed Estimation'!$H$4:$AK$4,\"<=\"&J77,'Detailed Estimation'!$H$10:$AK$10))*-1","v":2036.1600000000003},{"$f":"SUMIF('Detailed Estimation'!$H$4:$AK$4,\"<=\"&J77,'Detailed Estimation'!$H$17:$AK$17)","v":0},"","",13,10,{"$f":"VLOOKUP(R77,$J$65:$O$94,6,0)","v":2036.1600000000003},{"$f":"P76","v":0},{"$f":"VLOOKUP(R77,$J$64:$M$94,4,0)","v":2036.1600000000003},{"$f":"N76","v":0}]
["",{"$f":"IF('Financial Summary'!$M$3=\"Cost vs. Revenue\",IF(References!E78>0,E78,\"\"),IF(References!E109>0,E109,\"\"))","v":""},{"$f":"IF('Financial Summary'!$M$3=\"Cost vs. Revenue\",IF(References!F78>0,F78,\"\"),IF(References!F109>0,F109,\"\"))","v":{"$error":"#NUM!"}},2033,{"$f":"-('Detailed Estimation'!$H$10)","v":339.36},{"$f":"IF('Financial Input'!H8>=References!R48,SUM('Detailed Estimation'!$H$17:$W$17),0)","v":0},-339.36,0,{"$f":"IF(J78<='Financial Input'!$I$8,J78,'Financial Input'!$I$8)","v":12},14,{"$f":"(SUMIF('Detailed Estimation'!$H$4:$AK$4,\"<=\"&I78,'Detailed Estimation'!$H$10:$AK$10))*-1","v":2036.1600000000003},{"$f":"SUMIF('Detailed Estimation'!$H$4:$AK$4,\"<=\"&I78,'Detailed Estimation'!$H$17:$AK$17)","v":0},{"$f":"(SUMIF('Detailed Estimation'!$H$4:$AK$4,\"<=\"&J78,'Detailed Estimation'!$H$10:$AK$10))*-1","v":2036.1600000000003},{"$f":"SUMIF('Detailed Estimation'!$H$4:$AK$4,\"<=\"&J78,'Detailed Estimation'!$H$17:$AK$17)","v":0},"","",14,11,{"$f":"VLOOKUP(R78,$J$65:$O$94,6,0)","v":2036.1600000000003},{"$f":"T77","v":0},{"$f":"VLOOKUP(R78,$J$64:$M$94,4,0)","v":2036.1600000000003},{"$f":"V77","v":0}]
["",{"$f":"IF('Financial Summary'!$M$3=\"Cost vs. Revenue\",IF(References!E79>0,E79,\"\"),IF(References!E110>0,E110,\"\"))","v":""},{"$f":"IF('Financial Summary'!$M$3=\"Cost vs. Revenue\",IF(References!F79>0,F79,\"\"),IF(References!F110>0,F110,\"\"))","v":{"$error":"#NUM!"}},2034,{"$f":"-('Detailed Estimation'!$H$10)","v":339.36},{"$f":"IF('Financial Input'!H8>=References!S48,SUM('Detailed Estimation'!$H$17:$X$17),0)","v":0},-339.36,0,{"$f":"IF(J79<='Financial Input'!$I$8,J79,'Financial Input'!$I$8)","v":12},15,{"$f":"(SUMIF('Detailed Estimation'!$H$4:$AK$4,\"<=\"&I79,'Detailed Estimation'!$H$10:$AK$10))*-1","v":2036.1600000000003},{"$f":"SUMIF('Detailed Estimation'!$H$4:$AK$4,\"<=\"&I79,'Detailed Estimation'!$H$17:$AK$17)","v":0},{"$f":"(SUMIF('Detailed Estimation'!$H$4:$AK$4,\"<=\"&J79,'Detailed Estimation'!$H$10:$AK$10))*-1","v":2036.1600000000003},{"$f":"SUMIF('Detailed Estimation'!$H$4:$AK$4,\"<=\"&J79,'Detailed Estimation'!$H$17:$AK$17)","v":0},"","",15,12,{"$f":"VLOOKUP(R79,$J$65:$O$94,6,0)","v":2036.1600000000003},{"$f":"T78","v":0},{"$f":"VLOOKUP(R79,$J$64:$M$94,4,0)","v":2036.1600000000003},{"$f":"V78","v":0}]
["",{"$f":"IF('Financial Summary'!$M$3=\"Cost vs. Revenue\",IF(References!E80>0,E80,\"\"),IF(References!E111>0,E111,\"\"))","v":""},{"$f":"IF('Financial Summary'!$M$3=\"Cost vs. Revenue\",IF(References!F80>0,F80,\"\"),IF(References!F111>0,F111,\"\"))","v":{"$error":"#NUM!"}},2035,{"$f":"-('Detailed Estimation'!$H$10)","v":339.36},{"$f":"IF('Financial Input'!H8>=References!T48,SUM('Detailed Estimation'!$H$17:$Y$17),0)","v":0},-339.36,0,{"$f":"IF(J80<='Financial Input'!$I$8,J80,'Financial Input'!$I$8)","v":12},16,{"$f":"(SUMIF('Detailed Estimation'!$H$4:$AK$4,\"<=\"&I80,'Detailed Estimation'!$H$10:$AK$10))*-1","v":2036.1600000000003},{"$f":"SUMIF('Detailed Estimation'!$H$4:$AK$4,\"<=\"&I80,'Detailed Estimation'!$H$17:$AK$17)","v":0},{"$f":"(SUMIF('Detailed Estimation'!$H$4:$AK$4,\"<=\"&J80,'Detailed Estimation'!$H$10:$AK$10))*-1","v":2036.1600000000003},{"$f":"SUMIF('Detailed Estimation'!$H$4:$AK$4,\"<=\"&J80,'Detailed Estimation'!$H$17:$AK$17)","v":0},"","",16,12,{"$f":"S81","v":""},{"$f":"P76","v":0},{"$f":"U81","v":2036.1600000000003},{"$f":"N76","v":0}]
["",{"$f":"IF('Financial Summary'!$M$3=\"Cost vs. Revenue\",IF(References!E81>0,E81,\"\"),IF(References!E112>0,E112,\"\"))","v":""},{"$f":"IF('Financial Summary'!$M$3=\"Cost vs. Revenue\",IF(References!F81>0,F81,\"\"),IF(References!F112>0,F112,\"\"))","v":{"$error":"#NUM!"}},2036,{"$f":"-('Detailed Estimation'!$H$10)","v":339.36},{"$f":"IF('Financial Input'!H8>=References!U48,SUM('Detailed Estimation'!$H$17:$Z$17),0)","v":0},-339.36,0,{"$f":"IF(J81<='Financial Input'!$I$8,J81,'Financial Input'!$I$8)","v":12},17,{"$f":"(SUMIF('Detailed Estimation'!$H$4:$AK$4,\"<=\"&I81,'Detailed Estimation'!$H$10:$AK$10))*-1","v":2036.1600000000003},{"$f":"SUMIF('Detailed Estimation'!$H$4:$AK$4,\"<=\"&I81,'Detailed Estimation'!$H$17:$AK$17)","v":0},{"$f":"(SUMIF('Detailed Estimation'!$H$4:$AK$4,\"<=\"&J81,'Detailed Estimation'!$H$10:$AK$10))*-1","v":2036.1600000000003},{"$f":"SUMIF('Detailed Estimation'!$H$4:$AK$4,\"<=\"&J81,'Detailed Estimation'!$H$17:$AK$17)","v":0},"","",17,13,{"$f":"VLOOKUP(R81,$J$65:$O$94,6,0)","v":""},{"$f":"P79","v":""},{"$f":"VLOOKUP(R81,$J$64:$M$94,4,0)","v":2036.1600000000003},{"$f":"N79","v":0}]
["",{"$f":"IF('Financial Summary'!$M$3=\"Cost vs. Revenue\",IF(References!E82>0,E82,\"\"),IF(References!E113>0,E113,\"\"))","v":""},{"$f":"IF('Financial Summary'!$M$3=\"Cost vs. Revenue\",IF(References!F82>0,F82,\"\"),IF(References!F113>0,F113,\"\"))","v":{"$error":"#NUM!"}},2037,{"$f":"-('Detailed Estimation'!$H$10)","v":339.36},{"$f":"IF('Financial Input'!H8>=References!V48,SUM('Detailed Estimation'!$H$17:$AA$17),0)","v":0},-339.36,0,{"$f":"IF(J82<='Financial Input'!$I$8,J82,'Financial Input'!$I$8)","v":12},18,{"$f":"(SUMIF('Detailed Estimation'!$H$4:$AK$4,\"<=\"&I82,'Detailed Estimation'!$H$10:$AK$10))*-1","v":2036.1600000000003},{"$f":"SUMIF('Detailed Estimation'!$H$4:$AK$4,\"<=\"&I82,'Detailed Estimation'!$H$17:$AK$17)","v":0},{"$f":"(SUMIF('Detailed Estimation'!$H$4:$AK$4,\"<=\"&J82,'Detailed Estimation'!$H$10:$AK$10))*-1","v":2036.1600000000003},{"$f":"SUMIF('Detailed Estimation'!$H$4:$AK$4,\"<=\"&J82,'Detailed Estimation'!$H$17:$AK$17)","v":0},"","",18,14,{"$f":"VLOOKUP(R82,$J$64:$O$94,6,0)","v":""},{"$f":"T81","v":""},{"$f":"VLOOKUP(R82,$J$64:$M$94,4,0)","v":2036.1600000000003},{"$f":"V81","v":0}]
["",{"$f":"IF('Financial Summary'!$M$3=\"Cost vs. Revenue\",IF(References!E83>0,E83,\"\"),IF(References!E114>0,E114,\"\"))","v":""},null,2038,{"$f":"-('Detailed Estimation'!$H$10)","v":339.36},{"$f":"('Detailed Estimation'!$H$17)","v":0},-339.36,0,{"$f":"IF(J83<='Financial Input'!$I$8,J83,'Financial Input'!$I$8)","v":12},19,{"$f":"(SUMIF('Detailed Estimation'!$H$4:$AK$4,\"<=\"&I83,'Detailed Estimation'!$H$10:$AK$10))*-1","v":2036.1600000000003},{"$f":"SUMIF('Detailed Estimation'!$H$4:$AK$4,\"<=\"&I83,'Detailed Estimation'!$H$17:$AK$17)","v":0},{"$f":"(SUMIF('Detailed Estimation'!$H$4:$AK$4,\"<=\"&J83,'Detailed Estimation'!$H$10:$AK$10))*-1","v":2036.1600000000003},{"$f":"SUMIF('Detailed Estimation'!$H$4:$AK$4,\"<=\"&J83,'Detailed Estimation'!$H$17:$AK$17)","v":0},"","",19,15,{"$f":"VLOOKUP(R83,$J$64:$O$94,6,0)","v":""},{"$f":"T82","v":""},{"$f":"VLOOKUP(R83,$J$64:$M$94,4,0)","v":2036.1600000000003},{"$f":"V82","v":0}]
["",{"$f":"IF('Financial Summary'!$M$3=\"Cost vs. Revenue\",IF(References!E84>0,E84,\"\"),IF(References!E115>0,E115,\"\"))","v":""},null,2039,{"$f":"-('Detailed Estimation'!$H$10)","v":339.36},{"$f":"IF('Financial Input'!H24>=References!D68,SUM('Detailed Estimation'!$H$17:$I$17),0)","v":0},-339.36,0,{"$f":"IF(J84<='Financial Input'!$I$8,J84,'Financial Input'!$I$8)","v":12},20,{"$f":"(SUMIF('Detailed Estimation'!$H$4:$AK$4,\"<=\"&I84,'Detailed Estimation'!$H$10:$AK$10))*-1","v":2036.1600000000003},{"$f":"SUMIF('Detailed Estimation'!$H$4:$AK$4,\"<=\"&I84,'Detailed Estimation'!$H$17:$AK$17)","v":0},{"$f":"(SUMIF('Detailed Estimation'!$H$4:$AK$4,\"<=\"&J84,'Detailed Estimation'!$H$10:$AK$10))*-1","v":2036.1600000000003},{"$f":"SUMIF('Detailed Estimation'!$H$4:$AK$4,\"<=\"&J84,'Detailed Estimation'!$H$17:$AK$17)","v":0},"","",20,16,{"$f":"S85","v":""},{"$f":"P79","v":""},{"$f":"U85","v":2036.1600000000003},{"$f":"N79","v":0}]
["",{"$f":"IF('Financial Summary'!$M$3=\"Cost vs. Revenue\",IF(References!E85>0,E85,\"\"),IF(References!E116>0,E116,\"\"))","v":""},null,2040,{"$f":"-('Detailed Estimation'!$H$10)","v":339.36},{"$f":"IF('Financial Input'!H24>=References!E68,SUM('Detailed Estimation'!$H$17:$J$17),0)","v":0},-339.36,0,{"$f":"IF(J85<='Financial Input'!$I$8,J85,'Financial Input'!$I$8)","v":12},21,{"$f":"(SUMIF('Detailed Estimation'!$H$4:$AK$4,\"<=\"&I85,'Detailed Estimation'!$H$10:$AK$10))*-1","v":2036.1600000000003},{"$f":"SUMIF('Detailed Estimation'!$H$4:$AK$4,\"<=\"&I85,'Detailed Estimation'!$H$17:$AK$17)","v":0},{"$f":"(SUMIF('Detailed Estimation'!$H$4:$AK$4,\"<=\"&J85,'Detailed Estimation'!$H$10:$AK$10))*-1","v":2036.1600000000003},{"$f":"SUMIF('Detailed Estimation'!$H$4:$AK$4,\"<=\"&J85,'Detailed Estimation'!$H$17:$AK$17)","v":0},"","",21,16,{"$f":"VLOOKUP(R85,$J$64:$O$94,6,0)","v":""},{"$f":"P82","v":""},{"$f":"VLOOKUP(R85,$J$64:$M$94,4,0)","v":2036.1600000000003},{"$f":"N82","v":0}]
["",{"$f":"IF('Financial Summary'!$M$3=\"Cost vs. Revenue\",IF(References!E86>0,E86,\"\"),IF(References!E117>0,E117,\"\"))","v":""},null,2041,{"$f":"-('Detailed Estimation'!$H$10)","v":339.36},{"$f":"IF('Financial Input'!H24>=References!F68,SUM('Detailed Estimation'!$H$17:$K$17),0)","v":0},-339.36,0,{"$f":"IF(J86<='Financial Input'!$I$8,J86,'Financial Input'!$I$8)","v":12},22,{"$f":"(SUMIF('Detailed Estimation'!$H$4:$AK$4,\"<=\"&I86,'Detailed Estimation'!$H$10:$AK$10))*-1","v":2036.1600000000003},{"$f":"SUMIF('Detailed Estimation'!$H$4:$AK$4,\"<=\"&I86,'Detailed Estimation'!$H$17:$AK$17)","v":0},{"$f":"(SUMIF('Detailed Estimation'!$H$4:$AK$4,\"<=\"&J86,'Detailed Estimation'!$H$10:$AK$10))*-1","v":2036.1600000000003},{"$f":"SUMIF('Detailed Estimation'!$H$4:$AK$4,\"<=\"&J86,'Detailed Estimation'!$H$17:$AK$17)","v":0},"","",22,17,{"$f":"VLOOKUP(R86,$J$64:$O$94,6,0)","v":""},{"$f":"T85","v":""},{"$f":"VLOOKUP(R86,$J$64:$M$94,4,0)","v":2036.1600000000003},{"$f":"V85","v":0}]
["",{"$f":"IF('Financial Summary'!$M$3=\"Cost vs. Revenue\",IF(References!E87>0,E87,\"\"),IF(References!E118>0,E118,\"\"))","v":""},null,2042,{"$f":"-('Detailed Estimation'!$H$10)","v":339.36},{"$f":"IF('Financial Input'!H24>=References!G68,SUM('Detailed Estimation'!$H$17:$L$17),0)","v":0},-339.36,0,{"$f":"IF(J87<='Financial Input'!$I$8,J87,'Financial Input'!$I$8)","v":12},23,{"$f":"(SUMIF('Detailed Estimation'!$H$4:$AK$4,\"<=\"&I87,'Detailed Estimation'!$H$10:$AK$10))*-1","v":2036.1600000000003},{"$f":"SUMIF('Detailed Estimation'!$H$4:$AK$4,\"<=\"&I87,'Detailed Estimation'!$H$17:$AK$17)","v":0},{"$f":"(SUMIF('Detailed Estimation'!$H$4:$AK$4,\"<=\"&J87,'Detailed Estimation'!$H$10:$AK$10))*-1","v":2036.1600000000003},{"$f":"SUMIF('Detailed Estimation'!$H$4:$AK$4,\"<=\"&J87,'Detailed Estimation'!$H$17:$AK$17)","v":0},"","",23,18,{"$f":"VLOOKUP(R87,$J$64:$O$94,6,0)","v":""},{"$f":"T86","v":""},{"$f":"VLOOKUP(R87,$J$64:$M$94,4,0)","v":2036.1600000000003},{"$f":"V86","v":0}]
["",{"$f":"IF('Financial Summary'!$M$3=\"Cost vs. Revenue\",IF(References!E88>0,E88,\"\"),IF(References!E119>0,E119,\"\"))","v":""},null,2043,{"$f":"-('Detailed Estimation'!$H$10)","v":339.36},{"$f":"IF('Financial Input'!H24>=References!H68,SUM('Detailed Estimation'!$H$17:$M$17),0)","v":0},-339.36,0,{"$f":"IF(J88<='Financial Input'!$I$8,J88,'Financial Input'!$I$8)","v":12},24,{"$f":"(SUMIF('Detailed Estimation'!$H$4:$AK$4,\"<=\"&I88,'Detailed Estimation'!$H$10:$AK$10))*-1","v":2036.1600000000003},{"$f":"SUMIF('Detailed Estimation'!$H$4:$AK$4,\"<=\"&I88,'Detailed Estimation'!$H$17:$AK$17)","v":0},{"$f":"(SUMIF('Detailed Estimation'!$H$4:$AK$4,\"<=\"&J88,'Detailed Estimation'!$H$10:$AK$10))*-1","v":2036.1600000000003},{"$f":"SUMIF('Detailed Estimation'!$H$4:$AK$4,\"<=\"&J88,'Detailed Estimation'!$H$17:$AK$17)","v":0},"","",24,19,{"$f":"S89","v":""},{"$f":"P82","v":""},{"$f":"U89","v":2036.1600000000003},{"$f":"N82","v":0}]
["",{"$f":"IF('Financial Summary'!$M$3=\"Cost vs. Revenue\",IF(References!E89>0,E89,\"\"),IF(References!E120>0,E120,\"\"))","v":""},null,2044,{"$f":"-('Detailed Estimation'!$H$10)","v":339.36},{"$f":"IF('Financial Input'!H24>=References!I68,SUM('Detailed Estimation'!$H$17:$N$17),0)","v":0},-339.36,0,{"$f":"IF(J89<='Financial Input'!$I$8,J89,'Financial Input'!$I$8)","v":12},25,{"$f":"(SUMIF('Detailed Estimation'!$H$4:$AK$4,\"<=\"&I89,'Detailed Estimation'!$H$10:$AK$10))*-1","v":2036.1600000000003},{"$f":"SUMIF('Detailed Estimation'!$H$4:$AK$4,\"<=\"&I89,'Detailed Estimation'!$H$17:$AK$17)","v":0},{"$f":"(SUMIF('Detailed Estimation'!$H$4:$AK$4,\"<=\"&J89,'Detailed Estimation'!$H$10:$AK$10))*-1","v":2036.1600000000003},{"$f":"SUMIF('Detailed Estimation'!$H$4:$AK$4,\"<=\"&J89,'Detailed Estimation'!$H$17:$AK$17)","v":0},"","",25,19,{"$f":"VLOOKUP(R89,$J$64:$O$94,6,0)","v":""},{"$f":"P85","v":""},{"$f":"VLOOKUP(R89,$J$64:$M$94,4,0)","v":2036.1600000000003},{"$f":"N85","v":0}]
["",{"$f":"IF('Financial Summary'!$M$3=\"Cost vs. Revenue\",IF(References!E90>0,E90,\"\"),IF(References!E121>0,E121,\"\"))","v":""},null,2045,{"$f":"-('Detailed Estimation'!$H$10)","v":339.36},{"$f":"IF('Financial Input'!H24>=References!K68,SUM('Detailed Estimation'!$H$17:$O$17),0)","v":0},-339.36,0,{"$f":"IF(J90<='Financial Input'!$I$8,J90,'Financial Input'!$I$8)","v":12},26,{"$f":"(SUMIF('Detailed Estimation'!$H$4:$AK$4,\"<=\"&I90,'Detailed Estimation'!$H$10:$AK$10))*-1","v":2036.1600000000003},{"$f":"SUMIF('Detailed Estimation'!$H$4:$AK$4,\"<=\"&I90,'Detailed Estimation'!$H$17:$AK$17)","v":0},{"$f":"(SUMIF('Detailed Estimation'!$H$4:$AK$4,\"<=\"&J90,'Detailed Estimation'!$H$10:$AK$10))*-1","v":2036.1600000000003},{"$f":"SUMIF('Detailed Estimation'!$H$4:$AK$4,\"<=\"&J90,'Detailed Estimation'!$H$17:$AK$17)","v":0},"","",26,20,{"$f":"VLOOKUP(R90,$J$64:$O$94,6,0)","v":""},{"$f":"T89","v":""},{"$f":"VLOOKUP(R90,$J$64:$M$94,4,0)","v":2036.1600000000003},{"$f":"V89","v":0}]
["",{"$f":"IF('Financial Summary'!$M$3=\"Cost vs. Revenue\",IF(References!E91>0,E91,\"\"),IF(References!E122>0,E122,\"\"))","v":""},null,2046,{"$f":"-('Detailed Estimation'!$H$10)","v":339.36},{"$f":"IF('Financial Input'!H24>=References!L68,SUM('Detailed Estimation'!$H$17:$P$17),0)","v":0},-339.36,0,{"$f":"IF(J91<='Financial Input'!$I$8,J91,'Financial Input'!$I$8)","v":12},27,{"$f":"(SUMIF('Detailed Estimation'!$H$4:$AK$4,\"<=\"&I91,'Detailed Estimation'!$H$10:$AK$10))*-1","v":2036.1600000000003},{"$f":"SUMIF('Detailed Estimation'!$H$4:$AK$4,\"<=\"&I91,'Detailed Estimation'!$H$17:$AK$17)","v":0},{"$f":"(SUMIF('Detailed Estimation'!$H$4:$AK$4,\"<=\"&J91,'Detailed Estimation'!$H$10:$AK$10))*-1","v":2036.1600000000003},{"$f":"SUMIF('Detailed Estimation'!$H$4:$AK$4,\"<=\"&J91,'Detailed Estimation'!$H$17:$AK$17)","v":0},"","",27,21,{"$f":"VLOOKUP(R91,$J$64:$O$94,6,0)","v":""},{"$f":"T90","v":""},{"$f":"VLOOKUP(R91,$J$64:$M$94,4,0)","v":2036.1600000000003},{"$f":"V90","v":0}]
["",null,null,2047,{"$f":"-('Detailed Estimation'!$H$10)","v":339.36},{"$f":"IF('Financial Input'!H24>=References!#REF!,SUM('Detailed Estimation'!$H$17:$Q$17),0)","v":{"$error":"#REF!"}},-339.36,{"$error":"#REF!"},{"$f":"IF(J92<='Financial Input'!$I$8,J92,'Financial Input'!$I$8)","v":12},28,{"$f":"(SUMIF('Detailed Estimation'!$H$4:$AK$4,\"<=\"&I92,'Detailed Estimation'!$H$10:$AK$10))*-1","v":2036.1600000000003},{"$f":"SUMIF('Detailed Estimation'!$H$4:$AK$4,\"<=\"&I92,'Detailed Estimation'!$H$17:$AK$17)","v":0},{"$f":"(SUMIF('Detailed Estimation'!$H$4:$AK$4,\"<=\"&J92,'Detailed Estimation'!$H$10:$AK$10))*-1","v":2036.1600000000003},{"$f":"SUMIF('Detailed Estimation'!$H$4:$AK$4,\"<=\"&J92,'Detailed Estimation'!$H$17:$AK$17)","v":0},"","",28,22,{"$f":"S93","v":""},{"$f":"P85","v":""},{"$f":"U93","v":2036.1600000000003},{"$f":"N85","v":0}]
["",null,null,null,null,null,null,null,{"$f":"IF(J93<='Financial Input'!$I$8,J93,'Financial Input'!$I$8)","v":12},29,{"$f":"(SUMIF('Detailed Estimation'!$H$4:$AK$4,\"<=\"&I93,'Detailed Estimation'!$H$10:$AK$10))*-1","v":2036.1600000000003},{"$f":"SUMIF('Detailed Estimation'!$H$4:$AK$4,\"<=\"&I93,'Detailed Estimation'!$H$17:$AK$17)","v":0},{"$f":"(SUMIF('Detailed Estimation'!$H$4:$AK$4,\"<=\"&J93,'Detailed Estimation'!$H$10:$AK$10))*-1","v":2036.1600000000003},{"$f":"SUMIF('Detailed Estimation'!$H$4:$AK$4,\"<=\"&J93,'Detailed Estimation'!$H$17:$AK$17)","v":0},"","",29,22,{"$f":"VLOOKUP(R93,$J$64:$O$94,6,0)","v":""},{"$f":"P88","v":""},{"$f":"VLOOKUP(R93,$J$64:$M$94,4,0)","v":2036.1600000000003},{"$f":"N88","v":0}]
[null,null,null,2018,{"$f":"SUMIF('Detailed Estimation'!H4:AK4,\"<=\"&'Financial Input'!$I$8,'Detailed Estimation'!H10:AK10)","v":-2036.1600000000003},{"$f":"IRR(G63:H63)","v":{"$error":"#NUM!"}},null,null,{"$f":"IF(J94<='Financial Input'!$I$8,J94,'Financial Input'!$I$8)","v":12},30,{"$f":"(SUMIF('Detailed Estimation'!$H$4:$AK$4,\"<=\"&I94,'Detailed Estimation'!$H$10:$AK$10))*-1","v":2036.1600000000003},{"$f":"SUMIF('Detailed Estimation'!$H$4:$AK$4,\"<=\"&I94,'Detailed Estimation'!$H$17:$AK$17)","v":0},{"$f":"(SUMIF('Detailed Estimation'!$H$4:$AK$4,\"<=\"&J94,'Detailed Estimation'!$H$10:$AK$10))*-1","v":2036.1600000000003},{"$f":"SUMIF('Detailed Estimation'!$H$4:$AK$4,\"<=\"&J94,'Detailed Estimation'!$H$17:$AK$17)","v":0},"","",30,23,{"$f":"VLOOKUP(R94,$J$64:$O$94,6,0)","v":""},{"$f":"T93","v":""},{"$f":"VLOOKUP(R94,$J$64:$M$94,4,0)","v":2036.1600000000003},{"$f":"V93","v":0}]
[null,null,null,2019,{"$f":"'Financial Input'!K12","v":0},{"$error":"#NUM!"},null,null,null,null,null,null,null,null,null,null,null,24,{"$f":"VLOOKUP(R95,$J$64:$O$94,6,0)","v":""},{"$f":"T94","v":""},{"$f":"VLOOKUP(R95,$J$64:$M$94,4,0)","v":2036.1600000000003},{"$f":"V94","v":0}]
[null,null,null,2020,{"$f":"'Financial Input'!K13","v":0},{"$error":"#NUM!"},null,null,null,null,null,null,null,null,null,null,null,25,{"$f":"S97","v":""},{"$f":"P88","v":""},{"$f":"U97","v":2036.1600000000003},{"$f":"N88","v":0}]
[null,null,null,2021,{"$f":"'Financial Input'!K14","v":0},{"$error":"#NUM!"},null,null,null,null,null,null,null,null,null,null,null,25,{"$f":"VLOOKUP(R97,$J$64:$O$94,6,0)","v":""},{"$f":"P91","v":""},{"$f":"VLOOKUP(R97,$J$64:$M$94,4,0)","v":2036.1600000000003},{"$f":"N91","v":0}]
[null,null,null,2022,{"$f":"'Financial Input'!K15","v":0},{"$error":"#NUM!"},null,null,null,null,null,null,null,null,null,null,null,26,{"$f":"VLOOKUP(R98,$J$64:$O$94,6,0)","v":""},{"$f":"T97","v":""},{"$f":"VLOOKUP(R98,$J$64:$M$94,4,0)","v":2036.1600000000003},{"$f":"V97","v":0}]
[null,null,null,2023,{"$f":"'Financial Input'!K16","v":0},{"$error":"#NUM!"},null,null,null,null,null,null,null,null,null,null,null,27,{"$f":"VLOOKUP(R99,$J$64:$O$94,6,0)","v":""},{"$f":"T98","v":""},{"$f":"VLOOKUP(R99,$J$64:$M$94,4,0)","v":2036.1600000000003},{"$f":"V98","v":0}]
[null,null,null,2024,{"$f":"'Financial Input'!K17","v":0},{"$error":"#NUM!"},null,null,null,null,null,null,null,null,null,null,null,28,{"$f":"S101","v":""},{"$f":"P91","v":""},{"$f":"U101","v":2036.1600000000003},{"$f":"N91","v":0}]
[null,null,null,2025,{"$f":"'Financial Input'!K18","v":0},{"$error":"#NUM!"},null,null,null,null,null,null,null,null,null,null,null,28,{"$f":"VLOOKUP(R101,$J$64:$O$94,6,0)","v":""},{"$f":"P94","v":""},{"$f":"VLOOKUP(R101,$J$64:$M$94,4,0)","v":2036.1600000000003},{"$f":"N94","v":0}]
[null,null,null,2026,{"$f":"'Financial Input'!K19","v":0},{"$error":"#NUM!"},null,null,null,null,null,null,null,null,null,null,null,29,{"$f":"VLOOKUP(R102,$J$64:$O$94,6,0)","v":""},{"$f":"T101","v":""},{"$f":"VLOOKUP(R102,$J$64:$M$94,4,0)","v":2036.1600000000003},{"$f":"V101","v":0}]
[null,null,null,2027,{"$f":"'Financial Input'!K20","v":0},{"$error":"#NUM!"},null,null,null,null,null,null,null,null,null,null,null,30,{"$f":"VLOOKUP(R103,$J$64:$O$94,6,0)","v":""},{"$f":"T102","v":""},{"$f":"VLOOKUP(R103,$J$64:$M$94,4,0)","v":2036.1600000000003},{"$f":"N94","v":0}]
[null,null,null,2028,{"$f":"'Financial Input'!K21","v":0},{"$error":"#NUM!"}]
[null,null,null,2029,{"$f":"'Financial Input'!K22","v":0},{"$error":"#NUM!"}]
["Investment Period",null,null,2030,{"$f":"'Financial Input'!K23","v":0},{"$error":"#NUM!"}]
[1,null,null,2031,{"$f":"'Financial Input'!K24","v":0},{"$error":"#NUM!"}]
[2,null,null,2032,{"$f":"'Financial Input'!K25","v":0},{"$error":"#NUM!"}]
[3,null,null,2033,{"$f":"'Financial Input'!R11","v":0},{"$error":"#NUM!"}]
[4,null,null,2034,{"$f":"'Financial Input'!R12","v":0},{"$error":"#NUM!"}]
[5,null,null,2035,{"$f":"'Financial Input'!R13","v":0},{"$error":"#NUM!"}]
[6,null,null,2036,{"$f":"'Financial Input'!R14","v":0},{"$error":"#NUM!"}]
[7,null,null,2037,{"$f":"'Financial Input'!R15","v":0},{"$error":"#NUM!"}]
[8,null,null,2038,{"$f":"'Financial Input'!K29","v":0},{"$error":"#NUM!"}]
[9,null,null,2039,{"$f":"'Financial Input'!K30","v":0},{"$error":"#NUM!"}]
[10,null,null,2040,{"$f":"'Financial Input'!K31","v":0},{"$error":"#NUM!"}]
[11,null,null,2041,{"$f":"'Financial Input'!K32","v":0},{"$error":"#NUM!"}]
[12,null,null,2042,{"$f":"'Financial Input'!K33","v":0},{"$error":"#NUM!"}]
[13,null,null,2043,{"$f":"'Financial Input'!K34","v":0},{"$error":"#NUM!"}]
[14,null,null,2044,{"$f":"'Financial Input'!K35","v":0},{"$error":"#NUM!"}]
[15,null,null,2045,{"$f":"'Financial Input'!K36","v":0},{"$error":"#NUM!"}]
[16,null,null,2046,{"$f":"'Financial Input'!K37","v":0},{"$error":"#NUM!"}]
[17,null,null,2047,{"$f":"'Financial Input'!K38","v":0},{"$error":"#VALUE!"}]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[]
[]
[]
[]
[]
[]
[]
[]
[null,123456,"-Pre and post-project land cover square footage must be equivalent.\n-Total project Area does not match Pre and/or post project totals.\n-Retrofitting natural Area does not result in SRC eligibility.\n-Retrofitting compacted area results in less SRC eligibility than retrofitting impervious area.\n-BMP has little to no additional CDA.\n-Project may trigger stormwater regulations."]
[null,12345,"-Pre and post-project land cover square footage must be equivalent.\n-Total project Area does not match Pre and/or post project totals.\n-Retrofitting natural Area does not result in SRC eligibility.\n-Retrofitting compacted area results in less SRC eligibility than retrofitting impervious area.\n-BMP has little to no additional CDA."]
[null,12346,"-Pre and post-project land cover square footage must be equivalent.\n-Total project Area does not match Pre and/or post project totals.\n-Retrofitting natural Area does not result in SRC eligibility.\n-Retrofitting compacted area results in less SRC eligibility than retrofitting impervious area.\n-Project may trigger stormwater regulations."]
[null,12356,"-Pre and post-project land cover square footage must be equivalent.\n-Total project Area does not match Pre and/or post project totals.\n-Retrofitting natural Area does not result in SRC eligibility.\n-BMP has little to no additional CDA.\n-Project may trigger stormwater regulations."]
[null,12456,"-Pre and post-project land cover square footage must be equivalent.\n-Total project Area does not match Pre and/or post project totals.\n-Retrofitting compacted area results in less SRC eligibility than retrofitting impervious area.\n-BMP has little to no additional CDA.\n-Project may trigger stormwater regulations."]
[null,13456,"-Pre and post-project land cover square footage must be equivalent.\n-Retrofitting natural Area does not result in SRC eligibility.\n-Retrofitting compacted area results in less SRC eligibility than retrofitting impervious area.\n-BMP has little to no additional CDA.\n-Project may trigger stormwater regulations."]
[null,23456,"-Total project Area does not match Pre and/or post project totals.\n-Retrofitting natural Area does not result in SRC eligibility.\n-Retrofitting compacted area results in less SRC eligibility than retrofitting impervious area.\n-BMP has little to no additional CDA.\n-Project may trigger stormwater regulations."]
[null,1234,"-Pre and post-project land cover square footage must be equivalent.\n-Total project Area does not match Pre and/or post project totals.\n-Retrofitting natural Area does not result in SRC eligibility.\n-Retrofitting compacted area results in less SRC eligibility than retrofitting impervious area."]
[null,1235,"-Pre and post-project land cover square footage must be equivalent.\n-Total project Area does not match Pre and/or post project totals.\n-Retrofitting natural Area does not result in SRC eligibility.\n-BMP has little to no additional CDA."]
[null,1236,"-Pre and post-project land cover square footage must be equivalent.\n-Total project Area does not match Pre and/or post project totals.\n-Retrofitting natural Area does not result in SRC eligibility.\n-Project may trigger stormwater regulations."]
[null,1245,"-Pre and post-project land cover square footage must be equivalent.\n-Total project Area does not match Pre and/or post project totals.\n-Retrofitting compacted area results in less SRC eligibility than retrofitting impervious area.\n-BMP has little to no additional CDA."]
[null,1246,"-Pre and post-project land cover square footage must be equivalent.\n-Total project Area does not match Pre and/or post project totals.\n-Retrofitting compacted area results in less SRC eligibility than retrofitting impervious area.\n-Project may trigger stormwater regulations."]
[null,1256,"-Pre and post-project land cover square footage must be equivalent.\n-Total project Area does not match Pre and/or post project totals.\n-BMP has little to no additional CDA.\n-Project may trigger stormwater regulations."]
[null,1345,"-Pre and post-project land cover square footage must be equivalent.\n-Retrofitting natural Area does not result in SRC eligibility.\n-Retrofitting compacted area results in less SRC eligibility than retrofitting impervious area.\n-BMP has little to no additional CDA."]
[null,1346,"-Pre and post-project land cover square footage must be equivalent.\n-Retrofitting natural Area does not result in SRC eligibility.\n-Retrofitting compacted area results in less SRC eligibility than retrofitting impervious area.\n-Project may trigger stormwater regulations."]
[null,1356,"-Pre and post-project land cover square footage must be equivalent.\n-Retrofitting natural Area does not result in SRC eligibility.\n-BMP has little to no additional CDA.\n-Project may trigger stormwater regulations."]
[null,1456,"-Pre and post-project land cover square footage must be equivalent.\n-Retrofitting compacted area results in less SRC eligibility than retrofitting impervious area.\n-BMP has little to no additional CDA.\n-Project may trigger stormwater regulations."]
[null,2345,"-Total project Area does not match Pre and/or post project totals.\n-Retrofitting natural Area does not result in SRC eligibility.\n-Retrofitting compacted area results in less SRC eligibility than retrofitting impervious area.\n-BMP has little to no additional CDA."]
[null,2346,"-Total project Area does not match Pre and/or post project totals.\n-Retrofitting natural Area does not result in SRC eligibility.\n-Retrofitting compacted area results in less SRC eligibility than retrofitting impervious area.\n-Project may trigger stormwater regulations."]
[null,2456,"-Total project Area does not match Pre and/or post project totals.\n-Retrofitting compacted area results in less SRC eligibility than retrofitting impervious area.\n-BMP has little to no additional CDA.\n-Project may trigger stormwater regulations."]
[null,3456,"-Retrofitting natural Area does not result in SRC eligibility.\n-Retrofitting compacted area results in less SRC eligibility than retrofitting impervious area.\n-BMP has little to no additional CDA.\n-Project may trigger stormwater regulations."]
[null,123,"-Pre and post-project land cover square footage must be equivalent.\n-Total project Area does not match Pre and/or post project totals.\n-Retrofitting natural Area does not result in SRC eligibility."]
[null,124,"-Pre and post-project land cover square footage must be equivalent.\n-Total project Area does not match Pre and/or post project totals.\n-Retrofitting compacted area results in less SRC eligibility than retrofitting impervious area."]
[null,125,"-Pre and post-project land cover square footage must be equivalent.\n-Total project Area does not match Pre and/or post project totals.\n-BMP has little to no additional CDA."]
[null,126,"-Pre and post-project land cover square footage must be equivalent.\n-Total project Area does not match Pre and/or post project totals.\n-Project may trigger stormwater regulations."]
[null,134,"-Pre and post-project land cover square footage must be equivalent.\n-Retrofitting natural Area does not result in SRC eligibility.\n-Retrofitting compacted area results in less SRC eligibility than retrofitting impervious area."]
[null,135,"-Pre and post-project land cover square footage must be equivalent.\n-Retrofitting natural Area does not result in SRC eligibility.\n-BMP has little to no additional CDA."]
[null,136,"-Pre and post-project land cover square footage must be equivalent.\n-Retrofitting natural Area does not result in SRC eligibility.\n-Project may trigger stormwater regulations."]
[null,145,"-Pre and post-project land cover square footage must be equivalent.\n-Retrofitting compacted area results in less SRC eligibility than retrofitting impervious area.\n-BMP has little to no additional CDA."]
[null,146,"-Pre and post-project land cover square footage must be equivalent.\n-Retrofitting compacted area results in less SRC eligibility than retrofitting impervious area.\n-Project may trigger stormwater regulations."]
[null,234,"-Total project Area does not match Pre and/or post project totals.\n-Retrofitting natural Area does not result in SRC eligibility.\n-Retrofitting compacted area results in less SRC eligibility than retrofitting impervious area."]
[null,235,"-Total project Area does not match Pre and/or post project totals.\n-Retrofitting natural Area does not result in SRC eligibility.\n-BMP has little to no additional CDA."]
[null,236,"-Total project Area does not match Pre and/or post project totals.\n-Retrofitting natural Area does not result in SRC eligibility.\n-Project may trigger stormwater regulations."]
[null,245,"-Total project Area does not match Pre and/or post project totals.\n-Retrofitting compacted area results in less SRC eligibility than retrofitting impervious area.\n-BMP has little to no additional CDA."]
[null,246,"-Total project Area does not match Pre and/or post project totals.\n-Retrofitting compacted area results in less SRC eligibility than retrofitting impervious area.\n-Project may trigger stormwater regulations."]
[null,256,"-Total project Area does not match Pre and/or post project totals.\n-BMP has little to no additional CDA.\n-Project may trigger stormwater regulations."]
[null,345,"-Retrofitting natural Area does not result in SRC eligibility.\n-Retrofitting compacted area results in less SRC eligibility than retrofitting impervious area.\n-BMP has little to no additional CDA."]
[null,346,"-Retrofitting natural Area does not result in SRC eligibility.\n-Retrofitting compacted area results in less SRC eligibility than retrofitting impervious area.\n-Project may trigger stormwater regulations."]
[null,456,"-Retrofitting compacted area results in less SRC eligibility than retrofitting impervious area.\n-BMP has little to no additional CDA.\n-Project may trigger stormwater regulations."]
[null,12,"-Pre and post-project land cover square footage must be equivalent.\n-Total project Area does not match Pre and/or post project totals."]
[null,13,"-Pre and post-project land cover square footage must be equivalent.\n-Retrofitting natural Area does not result in SRC eligibility."]
[null,14,"-Pre and post-project land cover square footage must be equivalent.\n-Retrofitting compacted area results in less SRC eligibility than retrofitting impervious area."]
[null,15,"-Pre and post-project land cover square footage must be equivalent.\n-BMP has little to no additional CDA."]
[null,16,"-Pre and post-project land cover square footage must be equivalent.\n-Project may trigger stormwater regulations."]
[null,23,"-Total project Area does not match Pre and/or post project totals.\n-Retrofitting natural Area does not result in SRC eligibility."]
[null,24,"-Total project Area does not match Pre and/or post project totals.\n-Retrofitting compacted area results in less SRC eligibility than retrofitting impervious area."]
[null,25,"-Total project Area does not match Pre and/or post project totals.\n-BMP has little to no additional CDA."]
[null,26,"-Total project Area does not match Pre and/or post project totals.\n-Project may trigger stormwater regulations."]
[null,34,"-Retrofitting natural Area does not result in SRC eligibility.\n-Retrofitting compacted area results in less SRC eligibility than retrofitting impervious area."]
[null,35,"-Retrofitting natural Area does not result in SRC eligibility.\n-BMP has little to no additional CDA."]
[null,36,"-Retrofitting natural Area does not result in SRC eligibility.\n-Project may trigger stormwater regulations."]
[null,45,"-Retrofitting compacted area results in less SRC eligibility than retrofitting impervious area.\n-BMP has little to no additional CDA."]
[null,46,"-Retrofitting compacted area results in less SRC eligibility than retrofitting impervious area.\n-Project may trigger stormwater regulations."]
[null,56,"-BMP has little to no additional CDA.\n-Project may trigger stormwater regulations."]
[null,1,"-Pre and post-project land cover square footage must be equivalent."]
[null,2,"-Total project Area does not match Pre and/or post project totals."]
[null,3,"-Retrofitting natural Area does not result in SRC eligibility."]
[null,4,"-Retrofitting compacted area results in less SRC eligibility than retrofitting impervious area."]
[null,5,"-BMP has little to no additional CDA."]
[null,6,"-Project may trigger stormwater regulations."]
[]
[]
[]
[]
[]
[]
[null,1,"Pre and post-project land cover square footage must be equivalent."]
[null,2,"Total Project Area does not match pre and/or post project totals."]
[null,3,"Retrofitting natural area does not result in SRC eligibility."]
[null,4,"Retrofitting compacted area results in less SRC eligibility than retrofitting impervious area."]
[null,5,"BMP has little to no additional CDA."]
[null,6,"Project may trigger stromwater regulations"]

{"sheet":"Costs","index":9,"n_rows":118,"n_cols":20,"rows_kept":118,"cut":false,"hidden":true,"merged":[[116,1,116,2],[115,0,115,2],[113,0,113,2],[60,3,61,3],[60,1,60,2],[60,12,60,13],[60,10,60,11],[60,8,60,9],[60,6,60,7],[60,4,60,5]]}
["Source: cnet.org"]
["Cost Sheet"]
[null,"Construction Cost",null,null,null,null,"Maintenance Cost",null,null,"Component Lifespan"]
["Component","Range","Cost",null,"Source",null,"Range","Cost","Source","Range","Life","Source"]
["Green Roof","Low",8.75,"sq. ft.","Water Environment Research Federation Low Impact Development Best Management Practices Whole Life Cost Model 2007",null,"Low",null,"City of Portland, Bureau of Environmental Services Cost Benefit Evaluation of Ecoroofs 2008","Long","50.0 years","Water Environment Research Federation Low Impact Development Best Management Practices Whole Life Cost Model 2007"]
[null,"Mid",15.75,"sq. ft.","City of Portland, Bureau of Environmental Services Cost Benefit Evaluation of Ecoroofs 2008",null,"Mid","$0.025/sq. ft.","Low Impact Development Center, Inc.; Low Impact Development for Big Box Manufacturers November 2005 ","Mid","40.0 years","PlaNYC 2030 Sustainable Stormwater Management Plan Accessed March 2009 "]
[null,"High",31.8,"sq. ft.","Wetland Studies and Solutions, Inc.; Virginia LID at WSSI 2007 ",null,"High","$0.412/sq. ft.","Water Environment Research Federation Low Impact Development Best Management Practices Whole Life Cost Model 2007","Short","25.0 years","Low Impact Development Center, Inc.; Low Impact Development for Big Box Manufacturers November 2005 "]
["Permeable Pavement- Pavers","Low",5.3,"sq. ft.","Sikich, Andrew J. and Patrick D. Kelsey. \"The Morton Arboretum's \"Green\" Parking Lot.\" Accessed July 2005.",null,"Low",null,"Pelkonen, Peg. The Morton Arboretum Permeable Parking Lot Presentation at the US Cellular Field Lot L Paver Symposium April 8th, 2008","Long","50.0 years","Pelkonen, Peg. The Morton Arboretum Permeable Parking Lot Presentation at the US Cellular Field Lot L Paver Symposium April 8th, 2008"]
[null,"Mid",7.1,"sq. ft.","Wetland Studies and Solutions, Inc.; Virginia LID at WSSI 2007 ",null,"Mid","$0.036/sq. ft.","Southeast Wisconsin Regional Planning Commission. \"Costs of Urban Nonpoint Source Water Pollution Control Measures.\" Technical Report Number 31. June 1991. ","Mid","25.0 years","Low Impact Development Center, Inc.; Low Impact Development for Big Box Manufacturers November 2005 "]
[null,"High",12,"sq. ft.","Rose Paving, email message to CNT, November 13th 2008",null,"High","$0.230/sq. ft.","Low Impact Development Center, Inc.; Low Impact Development for Big Box Manufacturers November 2005 ","Short","15.0 years","U.S. Department of Transportation, Federal Highway Administration. \"Stormwater Best Management Practices in an Ultra-Urban Setting: Selection and Monitoring.\" Accessed July 2005. "]
["Rain Garden","Low",5.15,"sq. ft.","Water Environment Research Federation Low Impact Development Best Management Practices Whole Life Cost Model 2007 (Self-install)",null,"Low",null,"City of Portland, Bureau of Environmental Services, Willamette Watershed Program - Task Memorandum 4.1 August 2005","Long","50.0 years","Seattle Public Utilities, Decentralized Stormwater Control Unit Cost Model November 2008"]
[null,"Mid",7,"sq. ft.","Center for Neighborhood Technology, \"Green Infrastructure Data Quantification and Assessment on Chicago’s Far North Side\" Accessed January 2009 ",null,"Mid","$0.340/sq. ft.","U.S. Environmental Protection Agency. \"Urban Stormwater Best Management Practices Study.\" EPA-821-R-99-012. August 1999. ","Mid","30.0 years","City of Portland, Bureau of Environmental Services, Willamette Watershed Program - Task Memorandum 4.1 August 2005"]
[null,"High",16.05,"sq. ft.","Water Environment Research Federation Low Impact Development Best Management Practices Whole Life Cost Model 2007 (Professional)",null,"High","$0.610/sq. ft.","Low Impact Development Center, Inc.; Low Impact Development for Big Box Manufacturers November 2005 ","Short","25.0 years","Low Impact Development Center, Inc.; Low Impact Development for Big Box Manufacturers November 2005 "]
["Bioswales (Parking Lot and Roadside)","Low",5.5,"sq. ft.","City of Portland, Bureau of Environmental Services, Willamette Watershed Program - Task Memorandum 4.1 August 2005",null,"Low",null,"Costs of Urban Nonpoint Source Water Pollution Control Measures ","Long","50.0 years","Seattle Public Utilities, Decentralized Stormwater Control Unit Cost Model November 2008"]
[null,"Mid",15,"sq. ft.","Water Environment Research Federation Low Impact Development Best Management Practices Whole Life Cost Model 2007",null,"Mid","$0.120/sq. ft.","Water Environment Research Federation Low Impact Development Best Management Practices Whole Life Cost Model 2007","Mid","30.0 years","City of Portland, Bureau of Environmental Services, Willamette Watershed Program - Task Memorandum 4.1 August 2005"]
[null,"High",24,"sq. ft.","Center for Neighborhood Technology, \"Green Infrastructure Data Quantification and Assessment In the Calumet Region\" Accessed January 2009 ",null,"High","$0.210/sq. ft.","City of Portland, Bureau of Environmental Services, Willamette Watershed Program - Task Memorandum 4.1 August 2005","Short","20.0 years","PlaNYC 2030 Sustainable Stormwater Management Plan Accessed March 2009 "]
["Downspout Disconnection","Low",9,"downspout","Southwest Florida Water Management District, Downspout Disconnection Report Accessed March 2009 ",null,"Low",null,"City of Portland, Bureau of Environmental Services, Willamette Watershed Program - Task Memorandum 4.1 August 2005","Long","100.0 years","Seattle Public Utilities, Decentralized Stormwater Control Unit Cost Model November 2008"]
[null,"Mid",35,"downspout","Milwaukee Metropolitan Sewerage District Stormwater Runoff Reduction Program December 2005",null,"Mid",null,"Seattle Public Utilities, Decentralized Stormwater Control Unit Cost Model November 2008","Mid","50.0 years","CNT Estimate"]
[null,"High",156,"downspout","Milwaukee Metropolitan Sewerage District Stormwater Runoff Reduction Program December 2005",null,"High",null,"Seattle Public Utilities, Decentralized Stormwater Control Unit Cost Model November 2008","Short","30.0 years","City of Portland, Bureau of Environmental Services, Downspout Disconnection Factsheet July 2006 "]
["Planter Boxes","Low",0.55000000000000004,"sq. ft.","New York Stormwater Management Design Manual Accessed March 2009 ",null,"Low",null,"New York Stormwater Management Design Manual Accessed March 2009 ","Long","30.0 years","CNT Estimate"]
[null,"Mid",8,"sq. ft.","Low Impact Development Center, Inc.; Low Impact Development for Big Box Manufacturers November 2005 ",null,"Mid","$0.800/sq. ft.","Low Impact Development Center, Inc.; Low Impact Development for Big Box Manufacturers November 2005 ","Mid","25.0 years","Low Impact Development Center, Inc.; Low Impact Development for Big Box Manufacturers November 2005 "]
[null,"High",24.52,"sq. ft.","PlaNYC 2030 Sustainable Stormwater Management Plan Accessed March 2009 ",null,"High","$1.000/sq. ft.","Charles River Watershed Association, Low Impact Best Management Practice (BMP) Information Sheet September 2008 ","Short","20.0 years","PlaNYC 2030 Sustainable Stormwater Management Plan Accessed March 2009 "]
["Rain Barrels","Low",0.72,"gallon","Metropolitan Water Reclamation District of Greater Chicago Accessed March 2009 ",null,"Low",null,"PlaNYC 2030 Sustainable Stormwater Management Plan Accessed March 2009 ","Long","20.0 years","PlaNYC 2030 Sustainable Stormwater Management Plan Accessed March 2009 "]
[null,"Mid",1.0900000000000001,"gallon","Milwaukee Metropolitan Sewerage District Stormwater Runoff Reduction Program December 2005",null,"Mid",null,"PlaNYC 2030 Sustainable Stormwater Management Plan Accessed March 2009 ","Mid","20.0 years","PlaNYC 2030 Sustainable Stormwater Management Plan Accessed March 2009 "]
[null,"High",2.54,"gallon","Milwaukee Metropolitan Sewerage District Stormwater Runoff Reduction Program December 2005",null,"High",null,"PlaNYC 2030 Sustainable Stormwater Management Plan Accessed March 2009 ","Short","20.0 years","PlaNYC 2030 Sustainable Stormwater Management Plan Accessed March 2009 "]
["Cisterns","Low",0.61,"gallon","Low Impact Development Center, Inc.; Low Impact Development for Big Box Manufacturers November 2005 ",null,"Low",null,"PlaNYC 2030 Sustainable Stormwater Management Plan Accessed March 2009 ","Long","50.0 years","City of Portland, Bureau of Environmental Services, Cisterns Factsheet July 2006 "]
[null,"Mid",1.45,"gallon","Water Environment Research Federation Low Impact Development Best Management Practices Whole Life Cost Model 2007",null,"Mid","$0.070/gallon","Water Environment Research Federation Low Impact Development Best Management Practices Whole Life Cost Model 2007","Mid","25.0 years","Seattle Public Utilities, Decentralized Stormwater Control Unit Cost Model November 2008"]
[null,"High",2.88,"gallon","Wetland Studies and Solutions, Inc.; Virginia LID at WSSI 2007",null,"High","$0.070/gallon","Water Environment Research Federation Low Impact Development Best Management Practices Whole Life Cost Model 2007","Short","20.0 years","PlaNYC 2030 Sustainable Stormwater Management Plan Accessed March 2009 "]
["Vegetated Filter Strips","Low",0.03," sq. ft.","USEPA, Office of Water National Management Measures to Control Non Point Source Pollution from Urban Areas November 2005 ",null,"Low","$0.070/ sq. ft.","Low Impact Development Center, Inc.; Low Impact Development for Big Box Manufacturers November 2005 ","Long","50.0 years","CNT Estimate"]
[null,"Mid",1.45," sq. ft.","USEPA, Office of Water National Management Measures to Control Non Point Source Pollution from Urban Areas November 2005 ",null,"Mid","$0.070/ sq. ft.","Low Impact Development Center, Inc.; Low Impact Development for Big Box Manufacturers November 2005 ","Mid","25.0 years","Low Impact Development Center, Inc.; Low Impact Development for Big Box Manufacturers November 2005 "]
[null,"High",3.33," sq. ft.","Low Impact Development Center, Inc.; Low Impact Development for Big Box Manufacturers November 2005 ",null,"High",null,"Low Impact Development Center, Inc.; Low Impact Development for Big Box Manufacturers November 2005 ","Short","20.0 years","CNT Estimate"]
["Amended Soil","Low",{"$f":"15/27","v":0.55555555555555558}," cubic foot","Low Impact Development Center, Inc.; Low Impact Development for Big Box Manufacturers November 2005 ",null,"Low",null,"City of Virginia, Fairfax County; LID BMP Factsheet - Soil Amendments February 2005 ","Long","50.0 years","CNT Estimate"]
[null,"Mid",{"$f":"30/27","v":1.1111111111111112}," cubic foot","Water Environment Research Federation Low Impact Development Best Management Practices Whole Life Cost Model 2007",null,"Mid",null,"City of Virginia, Fairfax County; LID BMP Factsheet - Soil Amendments February 2006 ","Mid","30.0 years","CNT Estimate"]
[null,"High",{"$f":"60/27","v":2.2222222222222223}," cubic foot","Low Impact Development Center, Inc.; Low Impact Development for Big Box Manufacturers ",null,"High",null,"City of Virginia, Fairfax County; LID BMP Factsheet - Soil Amendments February 2006 ","Short","25.0 years","City of Virginia, Fairfax County; LID BMP Factsheet - Soil Amendments February 2005 "]
[null,{"$f":"C35*1000","v":1666.6666666666667},{"$f":"AVERAGE(C33:C34)","v":1.6666666666666667},null,null,null,null,"$.29/sq. ft."]
["Extensive green roof",null,null,null,null,null,null,{"$f":"0.29*1.1316","v":0.32816399999999996},"Inflation adjusted via RSMeans"]
["Intensive green roof"]
["Rainwater harvesting"]
["Simple disconnection to a pervious area"]
["Simple disconnection to a conservation area"]
["Simple disconnection to amended soils",null,null,null,"A",180.1,0.28999999999999998]
["Permeable pavement - Standard",null,null,null,"B",208.5,null,{"$f":"(F42/F41)*G41","v":0.33573014991671296}]
["Permeable pavement - Enhanced"]
["Bioretention - Standard"]
["Bioretention - Enhanced"]
["Infiltration basin"]
["Infiltration trench"]
["Grass channel"]
["Grass channel - amended soils"]
["Dry swale"]
["Wet Swale"]
["Wet pond"]
["Micropool ED pond"]
["Wet ED pond"]
["Shallow wetland"]
["ED shallow wetland"]
["Tree preservation"]
["Tree planting"]
[]
["source: https://uminfopoint.umsystem.edu"]
["Amount Available for Construction","TYPE I\nConsiderably less than average complexity",null,"Average of TYPE I & II","TYPE II\nLess than average complexity",null,"TYPE III\nAverage Complexity",null,"TYPE IV\nMore than average complexity",null,"TYPE V\nConsiderably more than average complexity",null,"TYPE VI\nEngineering Projects",null,"I","II","III","IV","V","VI"]
["($)","New %","Reno. %",null,"New %","Reno. %","New %","Reno. %","New %","Reno. %","New %","Reno. %","New %","Reno. %",{"$f":"AVERAGE(B63:C76)","v":7.5310399356740847},{"$f":"AVERAGE(E63:F76)","v":7.6666409809702492},{"$f":"AVERAGE(G63:H76)","v":8.514765143393193},{"$f":"AVERAGE(G63:H76)","v":8.514765143393193},{"$f":"AVERAGE(K63:L76)","v":10.220069016349504},{"$f":"AVERAGE(M63:N77)","v":9.504948717948718}]
[10000,6.2170075046904296,10.65,{"$f":"(AVERAGE(E63:F63)+ AVERAGE(B63:C63))/2","v":8.1647232645403385},7.0110881801125702,8.7807973733583502,7.7865103189493396,9.7550562851782399,8.5607129455909892,10.7265290806754,9.3520825515947497,11.693198874296399,8.7479362101313303,10.9101407129456]
[25000,6.1784990619137004,10.4,{"$f":"(AVERAGE(E64:F64)+ AVERAGE(B64:C64))/2","v":8.0678470919324603},6.9673639774859302,8.7255253283302103,7.7379362101313296,9.6937429643527206,8.50741088180113,10.659183864915599,9.2934896810506604,11.6202251407129,8.6927579737335794,10.841857410881801]
[50000,6.1399906191369604,10.15,7.9709709193245804,6.9236397748592902,8.6702532833020705,7.6893621013133204,9.6324296435272103,8.4541088180112602,10.591838649155701,9.2348968105065694,11.547251407129499,8.6375797373358303,10.773574108818]
[100000,6.1014821763602303,9.9,7.8740947467167004,6.8799155722326502,8.6149812382739199,7.6407879924953104,9.5711163227016893,8.4008067542213904,10.5244934333959,9.1763039399624802,11.474277673546,8.5824015009380901,10.705290806754199]
[150000,6.0629737335834903,9.65,7.7772185741088178,6.8361913696060004,8.5597091932457801,7.5922138836773003,9.5098030018761701,8.3475046904315207,10.457148217636,9.1177110694183892,11.401303939962499,8.5272232645403392,10.6370075046904]
[200000,6.0244652908067504,9.4,7.6803424015009378,6.7924671669793604,8.5044371482176402,7.5436397748592903,9.4484896810506598,8.2942026266416509,10.389803001876199,9.0591181988742999,11.328330206379,8.4720450281425901,10.5687242026266]
[250000,5.9859568480300203,9.15,7.583466228893057,6.7487429643527204,8.4491651031894897,7.4950656660412696,9.3871763602251406,8.2409005628517793,10.322457786116299,9.0005253283302107,11.2553564727955,8.4168667917448392,10.5004409005629]
[300000,5.9474484052532803,8.9,7.4865900562851779,6.7050187617260804,8.3938930581613498,7.4464915572232604,9.3258630393996302,8.1875984990619095,10.2551125703565,8.9419324577861197,11.182382739212001,8.3616885553470901,10.432157598499099]
[350000,5.9089399624765502,8.65,7.3897138836773006,6.6612945590994403,8.3386210131332099,7.3979174484052503,9.2645497185741092,8.1342964352720504,10.1877673545966,8.8833395872420304,11.1094090056285,8.3065103189493392,10.3638742964353]
[400000,5.8704315196998103,8.4,7.2928377110694207,6.6175703564728003,8.28334896810507,7.3493433395872403,9.20323639774859,8.0809943714821806,10.120422138836799,8.8247467166979394,11.036435272045001,8.2513320825515901,10.2955909943715]
[450000,5.8319230769230801,8.15,{"$f":"(AVERAGE(E73:F73)+ AVERAGE(B73:C73))/2","v":7.1959615384615372},6.5738461538461497,8.2280769230769195,7.3007692307692302,9.1419230769230797,8.0276923076923108,10.053076923076899,8.7661538461538502,10.9634615384615,8.1961538461538499,10.227307692307701]
[500000,6.4,8,7.65,7.2,9,8,10,8.8000000000000007,11,9.6,12,9,11.2]
[750000,6.1,7.6,7.2749999999999995,6.8,8.6,7.6,9.5,8.4,10.5,9.1,11.4,8.5,10.6]
[1000000,5.8,7.3,6.9749999999999996,6.6,8.1999999999999993,7.3,9.1,8,10,8.8000000000000007,11,8.1999999999999993,10.199999999999999]
[1250000,5.7,7.1,6.8000000000000007,6.4,8,7.1,8.9,7.8,9.8000000000000007,8.5,10.7,8,10]
[1500000,5.6,7,6.6999999999999993,6.3,7.9,7,8.8000000000000007,7.7,9.6999999999999993,8.4,10.5,7.9,9.8000000000000007]
[1750000,5.5,6.9,6.6,6.2,7.8,6.9,8.6999999999999993,7.6,9.5,8.3000000000000007,10.4,7.8,9.6999999999999993]
[2000000,5.5,6.9,6.5750000000000002,6.2,7.7,6.9,8.6,7.5,9.4,8.1999999999999993,10.3,7.7,9.6]
[2250000,5.4,6.8,6.5,6.1,7.7,6.8,8.5,7.5,9.4,8.1999999999999993,10.199999999999999,7.6,9.5]
[2500000,5.4,6.7,6.45,6.1,7.6,6.7,8.4,7.4,9.3000000000000007,8.1,10.1,7.5,9.4]
[2750000,5.3,6.7,6.375,6,7.5,6.7,8.4,7.3,9.1999999999999993,8,10,7.5,9.4]
[3000000,5.3,6.6,6.3249999999999993,6,7.4,6.6,8.3000000000000007,7.3,9.1,7.9,9.9,7.4,9.3000000000000007]
[3500000,5.3,6.6,6.3,5.9,7.4,6.6,8.1999999999999993,7.2,9,7.9,9.9,7.4,9.1999999999999993]
[4000000,5.2,6.5,6.25,5.9,7.4,6.5,8.1999999999999993,7.2,9,7.8,9.8000000000000007,7.3,9.1999999999999993]
[4500000,5.2,6.5,6.2249999999999996,5.9,7.3,6.5,8.1,7.2,8.9,7.8,9.8000000000000007,7.3,9.1]
[5000000,5.2,6.5,6.1999999999999993,5.8,7.3,6.5,8.1,7.1,8.9,7.8,9.6999999999999993,7.2,9]
[6000000,5.0999999999999996,6.4,6.125,5.8,7.2,6.4,8,7.1,8.8000000000000007,7.7,9.6,7.2,9]
[7000000,5.0999999999999996,6.4,6.1,5.7,7.2,6.4,8,7,8.8000000000000007,7.7,9.6,7.1,8.9]
[8000000,5.0999999999999996,6.3,6.05,5.7,7.1,6.3,7.9,7,8.6999999999999993,7.6,9.5,7.1,8.9]
[9000000,5,6.3,6.0250000000000004,5.7,7.1,6.3,7.9,6.9,8.6999999999999993,7.6,9.5,7.1,8.8000000000000007]
[10000000,5,6.3,5.9749999999999996,5.6,7,6.3,7.8,6.9,8.6,7.5,9.4,7,8.8000000000000007]
[11000000,5,6.2,5.9499999999999993,5.6,7,6.2,7.8,6.8,8.6,7.5,9.3000000000000007,7,8.6999999999999993]
[12000000,4.9000000000000004,6.2,5.9250000000000007,5.6,7,6.2,7.7,6.8,8.5,7.4,9.3000000000000007,6.9,8.6999999999999993]
[13000000,4.9000000000000004,6.1,5.85,5.5,6.9,6.1,7.7,6.8,8.4,7.4,9.1999999999999993,6.9,8.6]
[14000000,4.9000000000000004,6.1,5.85,5.5,6.9,6.1,7.6,6.7,8.4,7.3,9.1999999999999993,6.8,8.5]
[15000000,4.8,6.1,5.8,5.5,6.8,6.1,7.6,6.7,8.3000000000000007,7.3,9.1,6.8,8.5]
[16000000,4.8,6,5.75,5.4,6.8,6,7.5,6.6,8.3000000000000007,7.2,9,6.7,8.4]
[17000000,4.8,6,5.7250000000000005,5.4,6.7,6,7.5,6.6,8.1999999999999993,7.2,9,6.7,8.4]
[18000000,4.8,5.9,5.6749999999999998,5.3,6.7,5.9,7.4,6.5,8.1999999999999993,7.1,8.9,6.7,8.3000000000000007]
[19000000,4.7,5.9,5.625,5.3,6.6,5.9,7.4,6.5,8.1,7.1,8.9,6.6,8.3000000000000007]
[20000000,4.7,5.9,5.625,5.3,6.6,5.9,7.3,6.4,8.1,7,8.8000000000000007,6.6,8.1999999999999993]
[21000000,4.7,5.8,5.55,5.2,6.5,5.8,7.3,6.4,8,7,8.6999999999999993,6.5,8.1]
[22000000,4.5999999999999996,5.8,{"$f":"(AVERAGE(E105:F105)+ AVERAGE(B105:C105))/2","v":5.5249999999999995},5.2,6.5,5.8,7.2,6.4,7.9,6.9,8.6999999999999993,6.5,8.1]
[23000000,4.5999999999999996,5.7,5.5,5.2,6.5,5.7,7.2,6.3,7.9,6.9,8.6,6.4,8]
[24000000,4.5999999999999996,5.7,5.45,5.0999999999999996,6.4,5.7,7.1,6.3,7.8,6.8,8.6,6.4,8]
[25000000,4.5,5.7,5.4249999999999998,5.0999999999999996,6.4,5.7,7.1,6.2,7.8,6.8,8.5,6.3,7.9]
[26000000,4.5,5.6,5.375,5.0999999999999996,6.3,5.6,7,6.2,7.7,6.7,8.4,6.3,7.9]
[27000000,4.5,5.6,5.35,5,6.3,5.6,7,6.1,7.7,6.7,8.4,6.2,7.8]
[28000000,4.4000000000000004,5.5,5.2750000000000004,5,6.2,5.5,6.9,6.1,7.6,6.6,8.3000000000000007,6.2,7.8]
[29000000,4.4000000000000004,5.5,5.2750000000000004,5,6.2,5.5,6.9,6.1,7.6,6.6,8.3000000000000007,6.2,7.7]
[30000000,4.4000000000000004,5.5,{"$f":"(AVERAGE(E113:F113)+ AVERAGE(B113:C113))/2","v":5.2249999999999996},4.9000000000000004,6.1,5.5,6.8,6,7.5,6.6,8.1999999999999993,6.1,7.6]
["Avg of projects less than $1,000,000",null,null,{"$f":"AVERAGE(D63:D76)/100","v":7.5988404583221661E-2}]
[null,null,"2 rounds of design",{"$f":"D114*2","v":0.15197680916644332}]
["Added field and Survey work",null,null,{"$f":"D115*0.4","v":6.0790723666577333E-2}]
[null,"Added Permitting",null,{"$f":"D115*0.25","v":3.799420229161083E-2}]
[null,null,"DC Local",{"$f":"SUM(D115:D117)*1.1","v":0.27583790863709468}]