{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Read me","Tab 1 - Assumptions","Tab 2 - Rate Summary","Tab 3 - Unlevied Land","Tab 4 - Infrastructure","Tab 5 - Benefit Allocation","Tab 6 - Financial Model","Tab 7 - Bylaw Continuity","Tab 8 - Population Forecast","Tab 9 - Existing Capacity"],"not_rendered":{"charts":1,"images":2,"macros":1,"external_links":1,"defined_names":35,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Read me","index":0,"n_rows":15,"n_cols":3,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,0,2,2]]}
["HOW TO USE THIS DOCUMENT"]
["Welcome to the model used to determine the police levy rate for the 2024 Off-site Levies Bylaw.\nNote: This model is in DRAFT form for discussion purposes, using the latest information and assumptions available. \n"]
[]
["Last Updated:","July 2023"]
["Police Levy Tabs 1 - 9"]
["Tab number","Title","Description "]
["Tab 1","Assumptions","This tab entails the assumptions and steps to create the financial model. It also provides some details to clarify questions around the assumptions. "]
["Tab 2","Rate Summary","This tab provides a high level summary of the steps that are taken to determine the police levy rate calculation, and provides a look at the proposed levy rate. "]
["Tab 3","Unlevied Land","This tab describes the remaining unlevied land that is included in the model."]
["Tab 4","Infrastructure","This tab provides details on police projects that need to be built over the model period to support the growth of communities in Greenfield Area within Calgary city limits."]
["Tab 5","Benefit Allocation","This tab provides the benefit rate allocation that considers the land that will benefit from infrastructure and then ties back to the future residents/jobs in that land. "]
["Tab 6","Financial Model","This tab provides the financial modelling and a detailed calculation of the proposed levy rate."]
["Tab 7","Bylaw Continuity","This tab shows a breakdown of spending from funds collected under the 2016 bylaw, funds to be collected under the 2024 bylaw, and funds from other sources, until funds from the 2016 bylaw have been depleted."]
["Tab 8","Population Forecast","This tab shows forecasted greenfield full buildout population distribution."]
["Tab 9","Existing Capacity","This tab shows total capacity of existing and funded facilities in the Greenfield Area."]

{"sheet":"Tab 1 - Assumptions","index":1,"n_rows":15,"n_cols":2,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,0,1,1],[2,0,2,1],[5,0,5,1]]}
["Police - Assumptions"]
["Summary","Frequently Asked Questions"]
["The City will use this financial model to calculate a police off-site levy rate per hectare that incorporates investment income, capital cost escalations, and the timing of expenditures and developer contributions through the model period. The levy rate calculated ensures that the off-site levy balance at the end of the model period is zero (i.e., revenues have matched expenditures). It also incorporates, if necessary, any interest costs incurred from the use of alternative funding sources required to deliver infrastructure in a timely manner."]
[]
[]
["Assumptions"]
["Escalation rate","The escalation factor of 3.58% is a five-year smoothed average, determined using Non-Residential Building Construction Price Index (CPI) for Calgary."]
["Discount rate","The discount rate of 4.29% is based on the asset mix of investments held in The City's capital deposits, and the Long term Capital Market assumptions that The City uses in projecting returns from investment portfolios."]
["Gross developable land","Gross developable lands are calculated starting with the gross land area and deducting non-developable lands."]
["Unlevied land","Unlevied land includes all gross developable lands outside the off-site levy Established Area boundary that do not have executed development agreements. This was 14,211.1 hectares at the end of 2022, and is forecast to be 13,921.1 hectares at the end of 2023."]
["Land absorption","• All remaining unlevied hectares will sign development agreements within the forecast period (ending 2055).\n• The land absorption from 2023 to 2027 is based on the fall 2022 forecast by Corporate Economics. \n• Remaining unlevied hectares in current and future Area Structure Plans are assumed to follow a decreasing trend over the forecast period, on the expectation of higher densities supporting the same number of people."]
["Benefit allocation","Benefit allocation considers the land that will benefit from future infrastructure and relates to the forecast residents and jobs in that land. "]
["Payment schedule","This financial model incorporates the current levy payment schedule, where 100% of police levies are paid in year three after the development agreement is signed."]
["Investment income on future value of cash flows","Investment income is earned on the off-site levy beginning account balance, plus collections and minus spending through the year. Investment income on collections and spending is multiplied by a cashflow timing factor of 0.5 to reflect the fact that the timing of collection and spending varies throughout the year. If the balance of the off-site levy goes negative then interest is charged on the balance of the shortfall."]
["Expenditures","Expenditures include all currently planned infrastructure for the next 32 years. This list may change as further information becomes available."]

{"sheet":"Tab 2 - Rate Summary","index":2,"n_rows":29,"n_cols":9,"rows_kept":29,"cut":false,"hidden":false,"merged":[[3,1,20,4]]}
["Police - Rate Summary"]
["Proposed 2024 Levy Rate",null,null,null,null,"Figure 1. Off-site levy rate calculation"]
[]
[null,"The levy rate calculation is being adjusted from the simple formula of Costs x Benefit / Land to the model described in Figure 1 to the right, and in the text below. \n\nThis financial model uses the following inputs: \n• Total unlevied land, and annual land absorption.\n• The off-site levy payment schedule.\n• Total capital costs of new infrastructure being levied for, with the benefit allocations to determine total unlevied costs.\n• Annual expenditures.\n• An escalation factor to calculate the future value of project costs.\n• A discount factor to calculate the discounted value of project costs, future revenue from developer contributions, and annual investment income or interest expense.\n\nThe levy rate is then calculated using Excel's Goal Seek function to find the levy rate that balances all expenditures and revenues over the course of the model to result in an off-site levy balance of $0.\n"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Step 1","Step 2","Step 3","Step 4","Step 5","Step 6","Step 7","Step 8"]
[null,"Total capital costs","Leviable capital cost","Future value","Discounted value","Unlevied land absorption","Developer contributions","Investment income","Levy rate"]
[null,"Identify the total capital costs for projects that benefit unlevied lands. Details can be found in Tab 4.","Leviable capital cost: \n• Apply benefit rates to the capital costs of each project to determine the developer share of costs.","Calculate the future value of capital costs over the model period. Details for this step can be found in Tab 6.","Calculate the discounted value of the capital costs over the model period. Details for this step can be found in Tab 6.","Details on unlevied lands can be found in Tab 3. Remaining unlevied lands are assumed to be fully absorbed within the model period, in the slowly decreasing trend shown on Tab 6.","The levy rate is multiplied by the hectares that are forecast to sign development agreements each year to calculate the yearly contributions from the developers.","The annual investment income is calculated by multiplying the balance of spending and contributions each year by the investment rate of return.","Use Excel's Goal Seek function to calculate the police off-site levy rate which ensures that developer contributions plus investment income are equal to the future value of capital cost/cash outflows by end of the model period."]
[null,"A","B","C","D","E","F","G","H"]
[null,{"$f":"SUM('Tab 6 - Financial Model'!D15:D22)","v":297297000},{"$f":"SUM('Tab 6 - Financial Model'!G15:G21)","v":130810680},{"$f":"'Tab 6 - Financial Model'!I23","v":143725050.67556286},{"$f":"'Tab 6 - Financial Model'!I24","v":57025102.11102929},{"$f":"'Tab 6 - Financial Model'!E36","v":9069},{"$f":"'Tab 6 - Financial Model'!I34","v":133459365.46925327},{"$f":"'Tab 6 - Financial Model'!I40","v":10265685.488524117},{"$f":"'Tab 6 - Financial Model'!F3","v":7438.1619199162542}]
[null,"Dollars","Dollars","Dollars","Dollars","Hectares","Dollars","Dollars","Dollars"]

{"sheet":"Tab 3 - Unlevied Land","index":3,"n_rows":5,"n_cols":17,"rows_kept":5,"cut":false,"hidden":false,"merged":[[1,0,3,13],[4,0,19,13]]}
["Police - Unlevied Land"]
["This tab provides background on different benefiting areas: the Established Area, unlevied land, and land that has already been levied.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Map 1. Off-site levy Established Area boundary and unlevied lands as of the end of 2022"]
[]
[]
["Map 1 to the right illustrates The City's Established Area, and Greenfield Area.\n\nThe Established Area boundary was identified in the 2016 Off-site Levy Bylaw and contains lands that are fully developed, or have executed development agreement to allow future development. The purpose of the boundary is to determine benefiting areas in support of levy rate calculations (established or greenfield) for different parts of the city.\n\nLand shown in green includes both greenfield lands that have already been levied, unlevied, and non-developable land. Non-developable land is excluded from the determination of the number of hectares that have been levied or unlevied. This includes, for example:\n\t• The Transportation Utility Corridor (TUC), or road right-of-way for provincial expressways.\n\t• Environmental Reserve (slopes with a grade greater than 15%, natural water bodies, areas impacted by a 1:100 year flood).\n\t• Landfills.\n\t• Cemeteries."]

{"sheet":"Tab 4 - Infrastructure","index":4,"n_rows":30,"n_cols":9,"rows_kept":30,"cut":false,"hidden":false,"merged":[[4,2,4,5],[5,2,5,5],[6,2,6,5]]}
[null,"Police - Infrastructure"]
[]
[null,"This tab shows the basis of the calculation and assumptions used in assessing infrastructure allocation."]
[]
[null,"Per facility capacity","The service level for the greenfield is comparable with the service level in the Established Area (one facility is needed to service future 149,000 population needs)."]
[null,"Capacity allocation","Future greenfield population will be 100% benefitting with existing and future recreation facilities in the green area"]
[null,"Construction year","Determined based on when the new facility will be required as related to the pace of population growth"]
[]
[null,"Future need of facility and cost analysis"]
[]
[null,"Facility type","Total greenfield ASP population (full buildout)\nSee Tab 8","Existing/funded facility capacity in greenfield  (people)\nSee Tab 9","Additional facility capacity needed at full buildout (people)","Per facility capacity (people)","Number of facilities needed","Per facility cost ($)","Total cost ($)"]
[null,"Police District Office",{"$f":"'Tab 8 - Population Forecast'!P13","v":946835.32608248352},{"$f":"'Tab 9 - Existing Capacity'!B3","v":372500},{"$f":"C12-D12","v":574335.32608248352},149000,{"$f":"E12/F12","v":3.8545995039092853},{"$f":"C29","v":38610000},{"$f":"G12*H12","v":148826086.84593749}]
[]
[null,"Project name","Construction completion date"]
[null,"Police District Office- 1",2029]
[null,"Police District Office- 2",2040]
[null,"Police District Office- 3",2049]
[null,"Police District Office- 4",2058]
[]
[null,"Police infrastructure cost estimates, 2023"]
[null,"Component","                          Cost","Size","Units","Cost per unit"]
[null,"Construction",26100000,45000,"sq. ft.",{"$f":"C22/D22","v":580}]
[null,"Consulting",2000000]
[null,"Site Development",2000000,5,"acres",{"$f":"C24/D24","v":400000}]
[null,"Contingency (10%)",3010000]
[null,"Land",5500000,5,"acres",1100000]
[null,"Public Art",{"$f":"1%*SUM(C22:C26)","v":386100}]
[]
[null,"Total levy eligible cost",{"$f":"SUM(C22:C26)","v":38610000}]
[null,"Total cost",{"$f":"C29+C27","v":38996100}]

{"sheet":"Tab 5 - Benefit Allocation","index":5,"n_rows":18,"n_cols":6,"rows_kept":18,"cut":false,"hidden":false,"merged":[[8,0,12,0],[8,1,12,4],[0,15,0,27],[1,19,1,25],[4,1,4,4],[5,1,5,4],[6,1,6,4],[7,1,7,4]]}
["Police - Benefit Allocation"]
[]
["This tab provides details on the benefit methodology. It shows the basis of the calculation and assumptions used in assessing benefit allocation."]
[]
["Benefit measurement","Police benefit is measured using the share of population in benefiting areas."]
["Benefiting areas","Greenfield only: projects that support Area Structure Plans (ASPs) outside the Established Area boundary.  The service level for the Greenfield Area is comparable with the service level in the Established Area. 100% of benefit is assigned to the greenfield ASP lands, and is split based on the forecast population in lands that have already signed development agreements and paid off-site levies (levied lands), and lands that have not yet signed development agreements and paid off-site levies (unlevied lands)."]
["Data source","Source: Calgary Next 20: Population, Employment and Housing Projections, 2021, by Applications Management Consulting Ltd.\nA buildout forecast of population based on current growth trends."]
["Source data details and assumptions","• The forecast period ends in 2058.\n• Population forecast is assessed by Transportation Zones (TZs). Transportation Zones provide a useful and reasonable geographic division for forecasting.\n• Population densities are assumed to be even throughout TZs (e.g., where part of a TZ has paid levies, and part has not)."]
["Benefit allocation calculation"," Benefit = (Sum of forecast population in all unlevied lands)/(Sum of forecast population in all greenfield lands)."]
[]
[]
[]
[]
[]
["Benefit share calculation"]
[]
["Facility type","Total greenfield ASP population (full buildout)\nSee Tab 8","Total levied population\nSee Tab 8","ASP unlevied population","Benefit share of ASP unlevied population","Costs to be levied for"]
["Police District Office",{"$f":"'Tab 8 - Population Forecast'!P13","v":946835.32608248352},{"$f":"'Tab 8 - Population Forecast'!P11","v":529843.88820802805},{"$f":"'Tab 8 - Population Forecast'!P12","v":416991.43787445547},{"$f":"ROUND(D18/B18,2)","v":0.44},{"$f":"E18*'Tab 4 - Infrastructure'!C29","v":16988400}]

{"sheet":"Tab 6 - Financial Model","index":6,"n_rows":52,"n_cols":47,"rows_kept":52,"cut":false,"hidden":false,"merged":[[10,1,10,8],[35,6,38,6],[46,2,48,4],[3,1,8,8],[39,2,44,2]]}
[null,"Police OSL Financial Rate Model"]
[]
[null,"Police Levy Rate",null,null,null,7438.1619199162542,"End Value (CELL AU42):",null,{"$f":"AU42","v":0}]
[null,"How to calculate the levy rate: Once all variables have been set, the levy rate can be recalculated by running Excel's Goal Seek function (Data --> What-If Analysis --> Goal Seek) to calculate the levy rate in cell F3 by setting cell AU42 to 0 by changing the levy rate in cell F3. The model applies the value in cell F3 to the land absorption in row 29, to ensure that contributions from Development Agreements (in row 34) plus earned investment income offset total spending and ensure that the ending balance is zero (cell AU42), i.e., all revenues and spending have balanced. \nVariables impacting this calculation include: annual expenditures, land absorption rate, payment schedule (cells I36 to I39), and the escalation and discount rates (cells E25 and E26)."]
[]
[]
[]
[]
[]
[null,"Section 1: Expenditures"]
[]
[null,null,"Project name","Capital cost ","Benefit type","Benefit % ","Unlevied cost","Previously levied/City share of cost ","Year projected project built ",null,null,0,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,31,32,33,34,35]
[null,null,null,null,null,null,null,null,null,null,null,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,2048,2049,2050,2051,2052,2053,2054,2055,2056,2057,2058]
[]
[null,null,{"$f":"'Tab 4 - Infrastructure'!B15","v":"Police District Office- 1"},38610000,"Greenfield",{"$f":"'Tab 5 - Benefit Allocation'!$E$18","v":0.44},{"$f":"D15*F15","v":16988400},{"$f":"D15-G15","v":21621600},{"$f":"('Tab 4 - Infrastructure'!C15-'Tab 6 - Financial Model'!$M$13)+1","v":6},null,null,null,{"$f":"IF($I15=M$12,$G15,0)*(1+$E$25)^M$12","v":0},0,0,0,0,20980117.599189755,0,0,0,0,{"$f":"IF($I15=W$12,$G15,0)*(1+$E$25)^W$12","v":0},0,0,0,0,0,0,0,0,0,{"$f":"IF($I15=AG$12,$G15,0)*(1+$E$25)^AG$12","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"'Tab 4 - Infrastructure'!B16","v":"Police District Office- 2"},38610000,"Greenfield",{"$f":"'Tab 5 - Benefit Allocation'!$E$18","v":0.44},{"$f":"D16*F16","v":16988400},21621600,{"$f":"('Tab 4 - Infrastructure'!C16-'Tab 6 - Financial Model'!$M$13)+1","v":17},null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,30891777.041792519,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"'Tab 4 - Infrastructure'!B17","v":"Police District Office- 3"},38610000,"Greenfield",{"$f":"'Tab 5 - Benefit Allocation'!$E$18","v":0.44},16988400,21621600,{"$f":"('Tab 4 - Infrastructure'!C17-'Tab 6 - Financial Model'!$M$13)+1","v":26},null,null,null,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,42396114.055581674,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"'Tab 4 - Infrastructure'!B18","v":"Police District Office- 4"},{"$f":"38610000*0.85","v":32818500},"Greenfield",{"$f":"'Tab 5 - Benefit Allocation'!$E$18","v":0.44},14440140,18378360,{"$f":"('Tab 4 - Infrastructure'!C18-'Tab 6 - Financial Model'!$M$13)+1","v":35},null,null,null,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,0,0,0,0,0,0,49457041.978998899]
[null,null,null,null,null,null,null,null,null,null,null,null,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,0,0,0,0,0,0,0]
[null,null,"Total",{"$f":"SUM(D15:D18)","v":148648500},null,null,{"$f":"SUM(G15:G18)","v":65405340},{"$f":"SUM(H15:H18)","v":83243160},null,null,null,null,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,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,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,0,0,0,0,0,0,0]
[]
[null,null,null,null,null,null,null,"Future value of unlevied cost",{"$f":"SUM(M23:AU23)","v":143725050.67556286},null,null,null,{"$f":"SUM(M15:M21)","v":0},0,0,0,0,20980117.599189755,0,0,0,0,0,0,0,0,0,0,30891777.041792519,0,0,0,0,0,0,0,0,42396114.055581674,0,0,0,0,0,0,0,0,49457041.978998899]
[null,null,"Rates used to calculate future value and present value of unlevied cost:",null,null,null,null,"Discounted value of unlevied cost",{"$f":"SUM(M24:AU24)","v":57025102.11102929},null,null,null,{"$f":"(SUM(M15:M21))/((1+$E$26)^M12)","v":0},0,0,0,0,16306168.036500502,0,0,0,0,0,0,0,0,0,0,15125771.832622252,0,0,0,0,0,0,0,0,14223834.744579144,0,0,0,0,0,0,0,0,11369327.497327395]
[null,null,"Table: Escalation and Discount Rates","Escalation Rate",3.5799999999999998E-2]
[null,null,"Source: City Treasury, March 2023","Discount Rate",4.2900000000000001E-2]
[]
[null,"Section 2: Land Absorption and Yearly Cash Flows"]
[null,null,null,null,null,null,null,"Hectares that sign development agreements (DAs)",null,null,null,290,309,327,321,321,318.48089795918366,315.96179591836733,313.44269387755099,310.92359183673466,308.40448979591832,305.88538775510199,303.36628571428565,300.84718367346932,298.32808163265298,295.80897959183665,293.28987755102031,290.77077551020398,288.25167346938764,285.7325714285713,283.21346938775497,280.69436734693863,278.1752653061223,275.65616326530596,273.13706122448963,270.61795918367329,268.09885714285696,265.57975510204062,263.06065306122429,225.741551020408,223.222448979592,220.70334693877498,218.18424489795899,215.665142857143]
[null,null,null,null,null,null,null,"Cumulative hectares",null,null,null,null,{"$f":"M29","v":309},{"$f":"M30+N29","v":636},{"$f":"N30+O29","v":957},{"$f":"O30+P29","v":1278},1596.4808979591837,1912.4426938775509,2225.8853877551019,2536.8089795918368,2845.2134693877551,3151.098857142857,3454.4651428571428,3755.3123265306122,4053.640408163265,4349.4493877551013,4642.7392653061215,4933.5100408163253,5221.7617142857125,5507.4942857142842,5790.7077551020393,6071.4021224489779,6349.5773877551001,6625.2335510204057,6898.3706122448957,7168.9885714285692,7437.0874285714262,7702.6671836734668,7965.7278367346908,8191.469387755099,8414.6918367346916,8635.3951836734668,8853.5794285714255,9069.2445714285677,9069.2445714285677,9069.2445714285677,9069.2445714285677]
[]
[]
[null,null,null,"Year","Unlevied hectares",null,null,"Yearly cash-flow analysis ($):"]
[null,null,"Unlevied hectares at Jan 1, 2023","Subtotal",{"$f":"9069+290","v":9359},null,null,"Contributions from signed DAs",{"$f":"SUM(K34:AU34)","v":133459365.46925327},null,null,null,{"$f":"($F$3*M29)*(1+$E$26)^L12","v":2298392.0332541224},2536623.7146737762,2596904.5991519368,2708311.8064555544,2802332.6519843414,2899436.0819277796,2999713.5451243264,3103258.6635035966,3210167.2502342248,3320537.3254294428,3434469.1291674073,3552065.1315669953,3673430.0396424565,3798670.8006420056,3927896.601556058,4061218.8644603258,4198751.2373373099,4340609.5799967991,4486911.9446917633,4637778.551000434,4793331.7545182584,4953696.0088748652,5118997.8205609359,5289365.6960179787,5464930.0804102952,5645823.2874628659,5832179.4197112601,5219503.0322458018,5382675.3360972898,5550241.7980436347,5722279.1329096975,5898862.5505997306,0,0,0]
[null,null,"Forecast hectares in executed DAs",2023,290,null,null,"Beginning account balance, $",null,null,null,null,{"$f":"L42","v":0},{"$f":"M42","v":0},0,0,2347692.5423674234,5039442.8457885142,-13521897.975015787,-11335582.303439939,-8959436.0968881063,-6382166.919559475,-3591904.4797413335,-576173.62008648808,2678133.8693635501,6184788.6634191517,9958254.5890678819,14013720.639578002,18367134.369008683,-8519168.9365840368,-4872491.3003040561,-933189.16798410041,3315591.4680875768,7891545.9975562645,12813249.526756831,18100196.832374092,23772843.997135617,29852651.792877965,-6943379.8234694973,-1838428.2276987743,3664856.0319680446,9589004.5527184177,15957652.516294105,21973697.181530595,28414502.512674835,35302779.155080259,42662290.401143819]
[null,null,"Denominator: Unlevied hectares at Jan 1, 2024","Subtotal",{"$f":"E34-E35","v":9069},null,"Levy payment schedule after a DA is signed.","Year 0",0,null,null,null,{"$f":"M34*$I$36","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,0,0,0,0,0,0,0]
[null,null,"Forecast hectares in executed DAs",2024,309,null,null,"Year 1",0,null,null,null,null,{"$f":"M34*$I$37","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,0,0,0,0,0,0]
[null,null,"Forecast hectares in executed DAs",2025,327,null,null,"Year 2",0,null,null,null,null,null,{"$f":"M34*$I$38","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,0,0,0,0,0]
[null,null,"Forecast hectares in executed DAs","2026 & 2027",321,null,null,"Year 3",1,null,null,null,null,null,null,{"$f":"M34*$I$39","v":2298392.0332541224},2536623.7146737762,2596904.5991519368,2708311.8064555544,2802332.6519843414,2899436.0819277796,2999713.5451243264,3103258.6635035966,3210167.2502342248,3320537.3254294428,3434469.1291674073,3552065.1315669953,3673430.0396424565,3798670.8006420056,3927896.601556058,4061218.8644603258,4198751.2373373099,4340609.5799967991,4486911.9446917633,4637778.551000434,4793331.7545182584,4953696.0088748652,5118997.8205609359,5289365.6960179787,5464930.0804102952,5645823.2874628659,5832179.4197112601,5219503.0322458018,5382675.3360972898,5550241.7980436347,5722279.1329096975,5898862.5505997306]
[null,null,"Hectares in executed DAs from 2023 to 2027 are per Corporate Economics Fall 2022 forecast. The remaining 7,791 hectares of unlevied land are assumed to be absorbed in a slowly decreasing trend, with approximately 2.54 ha fewer per year. This starts from 318.5 hectares in 2028 and finishes with 216 hectares in 2055.","2028 - 2055","Declining",null,null,"Investment income (interest expense), $",{"$f":"SUM(P40:AU40)","v":10265685.488524117},null,null,null,null,null,null,{"$f":"(P35+(SUM(P36:P39)*$E$50))*$E$26-(P23*$E$50*$E$26)","v":49300.509113300926},155126.58874731496,-178127.8207664839,-521996.13487970561,-426186.4454325093,-322166.9045991489,-209451.10530618471,-87527.803848751064,44140.239215813788,186117.46862615785,338996.7964813225,503400.91894312418,679983.68978822697,206802.93555779394,-281218.96527607774,-121916.73214037002,50029.398734367387,235344.94947188839,434791.5845088021,649168.75461682735,879315.4102432651,1126111.7868674838,481084.61867326975,-184414.10024725579,38354.179256523414,278325.23328750761,536468.54386442667,796541.6329906896,1058129.9950469495,1338034.8443617863,1637232.1131538562,895889.30946990754]
[null,null,null,null,null,null,null,"Future value of cash inflows, $",{"$f":"SUM(I34:I40)","v":143725051.95777738}]
[null,null,null,null,null,null,null,"Ending account Balance, $",null,null,null,null,{"$f":"M35+M36+M37+M38+M39+M40-M23","v":0},0,0,{"$f":"P35+P36+P37+P38+P39+P40-P23","v":2347692.5423674234},{"$f":"Q35+Q36+Q37+Q38+Q39+Q40-Q23","v":5039442.8457885142},-13521897.975015787,-11335582.303439939,-8959436.0968881063,-6382166.919559475,-3591904.4797413335,-576173.62008648808,2678133.8693635501,6184788.6634191517,9958254.5890678819,14013720.639578002,18367134.369008683,-8519168.9365840368,-4872491.3003040561,-933189.16798410041,3315591.4680875768,7891545.9975562645,12813249.526756831,18100196.832374092,23772843.997135617,29852651.792877965,-6943379.8234694973,-1838428.2276987743,3664856.0319680446,9589004.5527184177,15957652.516294105,21973697.181530595,28414502.512674835,35302779.155080259,42662290.401143819,{"$f":"ROUND((AU35+AU36+AU37+AU38+AU39+AU40-AU23),0)","v":0}]
[]
[]
[]
[]
[null,null,"Note: Cash flow timing is for inflows, 1=beginning of year; 0.5 is straight line; 0.0 is end of year. This is used to calculate investment income on expenditures within a given year."]
[]
[]
[null,null,"Cashflow timing factor",null,0.5]
[]
["End of WP"]

{"sheet":"Tab 7 - Bylaw Continuity","index":7,"n_rows":73,"n_cols":43,"rows_kept":73,"cut":false,"hidden":false,"merged":[[68,0,69,0],[71,0,72,0],[2,0,4,1],[5,0,5,1],[6,0,6,1],[54,0,57,0],[60,0,61,0],[63,0,66,0]]}
["Police OSL Continuity"]
[]
["This sheet is for information purposes only. It shows the continuity of expenditures, developer contributions, investment income, and fund balances for both the 2016 and 2024 Off-site Levies Bylaws. Any final investment income earned in the final year will be applied to expenditures in that year."]
[]
[]
["Light green references the 2016 bylaw"]
["Light orange references the 2024 bylaw"]
[]
["2024 Levy Rate",null,null,"Year #",null,null,null,0,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,31,32,33,34,35]
[{"$f":"'Tab 6 - Financial Model'!F3","v":7438.1619199162542},null,null,"Year",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,2048,2049,2050,2051,2052,2053,2054,2055,2056,2057,2058]
[]
["Expenditures ($)"]
["Supports projects in progress.","Committed OSL expenditures (2016 Bylaw)",null,null,null,null,null,null,null,null,null,32500000]
[]
[1,{"$f":"'Tab 6 - Financial Model'!C15","v":"Police District Office- 1"},null,{"$f":"SUMIF('Tab 6 - Financial Model'!$C$15:$C$18,'Tab 7 - Bylaw Continuity'!B15,'Tab 6 - Financial Model'!$I$15:$I$18)","v":6},{"$f":"IF(AND($D15=E$9,$B15='Tab 6 - Financial Model'!$C15),('Tab 6 - Financial Model'!$D15*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!E$9),0)","v":0},{"$f":"IF(AND($D15=F$9,$B15='Tab 6 - Financial Model'!$C15),('Tab 6 - Financial Model'!$D15*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!F$9),0)","v":0},{"$f":"IF(AND($D15=G$9,$B15='Tab 6 - Financial Model'!$C15),('Tab 6 - Financial Model'!$D15*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!G$9),0)","v":0},{"$f":"IF(AND($D15=H$9,$B15='Tab 6 - Financial Model'!$C15),('Tab 6 - Financial Model'!$D15*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!H$9),0)","v":0},{"$f":"IF(AND($D15=I$9,$B15='Tab 6 - Financial Model'!$C15),('Tab 6 - Financial Model'!$D15*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!I$9),0)","v":0},{"$f":"IF(AND($D15=J$9,$B15='Tab 6 - Financial Model'!$C15),('Tab 6 - Financial Model'!$D15*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!J$9),0)","v":0},{"$f":"IF(AND($D15=K$9,$B15='Tab 6 - Financial Model'!$C15),('Tab 6 - Financial Model'!$D15*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!K$9),0)","v":0},{"$f":"IF(AND($D15=L$9,$B15='Tab 6 - Financial Model'!$C15),('Tab 6 - Financial Model'!$D15*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!L$9),0)","v":0},{"$f":"IF(AND($D15=M$9,$B15='Tab 6 - Financial Model'!$C15),('Tab 6 - Financial Model'!$D15*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!M$9),0)","v":0},{"$f":"IF(AND($D15=N$9,$B15='Tab 6 - Financial Model'!$C15),('Tab 6 - Financial Model'!$D15*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!N$9),0)","v":47682085.45270399},{"$f":"IF(AND($D15=O$9,$B15='Tab 6 - Financial Model'!$C15),('Tab 6 - Financial Model'!$D15*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!O$9),0)","v":0},{"$f":"IF(AND($D15=P$9,$B15='Tab 6 - Financial Model'!$C15),('Tab 6 - Financial Model'!$D15*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!P$9),0)","v":0},{"$f":"IF(AND($D15=Q$9,$B15='Tab 6 - Financial Model'!$C15),('Tab 6 - Financial Model'!$D15*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!Q$9),0)","v":0},{"$f":"IF(AND($D15=R$9,$B15='Tab 6 - Financial Model'!$C15),('Tab 6 - Financial Model'!$D15*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!R$9),0)","v":0},{"$f":"IF(AND($D15=S$9,$B15='Tab 6 - Financial Model'!$C15),('Tab 6 - Financial Model'!$D15*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!S$9),0)","v":0},{"$f":"IF(AND($D15=T$9,$B15='Tab 6 - Financial Model'!$C15),('Tab 6 - Financial Model'!$D15*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!T$9),0)","v":0},{"$f":"IF(AND($D15=U$9,$B15='Tab 6 - Financial Model'!$C15),('Tab 6 - Financial Model'!$D15*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!U$9),0)","v":0},{"$f":"IF(AND($D15=V$9,$B15='Tab 6 - Financial Model'!$C15),('Tab 6 - Financial Model'!$D15*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!V$9),0)","v":0},{"$f":"IF(AND($D15=W$9,$B15='Tab 6 - Financial Model'!$C15),('Tab 6 - Financial Model'!$D15*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!W$9),0)","v":0},{"$f":"IF(AND($D15=X$9,$B15='Tab 6 - Financial Model'!$C15),('Tab 6 - Financial Model'!$D15*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!X$9),0)","v":0},{"$f":"IF(AND($D15=Y$9,$B15='Tab 6 - Financial Model'!$C15),('Tab 6 - Financial Model'!$D15*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!Y$9),0)","v":0},{"$f":"IF(AND($D15=Z$9,$B15='Tab 6 - Financial Model'!$C15),('Tab 6 - Financial Model'!$D15*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!Z$9),0)","v":0},{"$f":"IF(AND($D15=AA$9,$B15='Tab 6 - Financial Model'!$C15),('Tab 6 - Financial Model'!$D15*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AA$9),0)","v":0},{"$f":"IF(AND($D15=AB$9,$B15='Tab 6 - Financial Model'!$C15),('Tab 6 - Financial Model'!$D15*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AB$9),0)","v":0},{"$f":"IF(AND($D15=AC$9,$B15='Tab 6 - Financial Model'!$C15),('Tab 6 - Financial Model'!$D15*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AC$9),0)","v":0},{"$f":"IF(AND($D15=AD$9,$B15='Tab 6 - Financial Model'!$C15),('Tab 6 - Financial Model'!$D15*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AD$9),0)","v":0},{"$f":"IF(AND($D15=AE$9,$B15='Tab 6 - Financial Model'!$C15),('Tab 6 - Financial Model'!$D15*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AE$9),0)","v":0},{"$f":"IF(AND($D15=AF$9,$B15='Tab 6 - Financial Model'!$C15),('Tab 6 - Financial Model'!$D15*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AF$9),0)","v":0},{"$f":"IF(AND($D15=AG$9,$B15='Tab 6 - Financial Model'!$C15),('Tab 6 - Financial Model'!$D15*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AG$9),0)","v":0},{"$f":"IF(AND($D15=AH$9,$B15='Tab 6 - Financial Model'!$C15),('Tab 6 - Financial Model'!$D15*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AH$9),0)","v":0},{"$f":"IF(AND($D15=AI$9,$B15='Tab 6 - Financial Model'!$C15),('Tab 6 - Financial Model'!$D15*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AI$9),0)","v":0},{"$f":"IF(AND($D15=AJ$9,$B15='Tab 6 - Financial Model'!$C15),('Tab 6 - Financial Model'!$D15*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AJ$9),0)","v":0},{"$f":"IF(AND($D15=AK$9,$B15='Tab 6 - Financial Model'!$C15),('Tab 6 - Financial Model'!$D15*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AK$9),0)","v":0},{"$f":"IF(AND($D15=AL$9,$B15='Tab 6 - Financial Model'!$C15),('Tab 6 - Financial Model'!$D15*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AL$9),0)","v":0},{"$f":"IF(AND($D15=AM$9,$B15='Tab 6 - Financial Model'!$C15),('Tab 6 - Financial Model'!$D15*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AM$9),0)","v":0},{"$f":"IF(AND($D15=AN$9,$B15='Tab 6 - Financial Model'!$C15),('Tab 6 - Financial Model'!$D15*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AN$9),0)","v":0},{"$f":"IF(AND($D15=AO$9,$B15='Tab 6 - Financial Model'!$C15),('Tab 6 - Financial Model'!$D15*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AO$9),0)","v":0},{"$f":"IF(AND($D15=AP$9,$B15='Tab 6 - Financial Model'!$C15),('Tab 6 - Financial Model'!$D15*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AP$9),0)","v":0},{"$f":"IF(AND($D15=AQ$9,$B15='Tab 6 - Financial Model'!$C15),('Tab 6 - Financial Model'!$D15*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AQ$9),0)","v":0}]
[null,"Expenditures from 2024 Bylaw",null,{"$f":"SUMIF('Tab 6 - Financial Model'!$C$15:$C$18,'Tab 7 - Bylaw Continuity'!B15,'Tab 6 - Financial Model'!$F$15:$F$18)","v":0.44},{"$f":"E15*$D16","v":0},{"$f":"F15*$D16","v":0},0,0,0,0,0,0,0,20980117.599189755,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,0]
[null,"Remainder: needed from other sources",null,null,{"$f":"E15-E16","v":0},{"$f":"F15-F16","v":0},0,0,0,0,0,0,0,26701967.853514235,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,0]
[2,{"$f":"'Tab 6 - Financial Model'!C16","v":"Police District Office- 2"},null,{"$f":"SUMIF('Tab 6 - Financial Model'!$C$15:$C$18,'Tab 7 - Bylaw Continuity'!B18,'Tab 6 - Financial Model'!$I$15:$I$18)","v":17},{"$f":"IF(AND($D18=E$9,$B18='Tab 6 - Financial Model'!$C16),('Tab 6 - Financial Model'!$D16*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!E$9),0)","v":0},{"$f":"IF(AND($D18=F$9,$B18='Tab 6 - Financial Model'!$C16),('Tab 6 - Financial Model'!$D16*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!F$9),0)","v":0},{"$f":"IF(AND($D18=G$9,$B18='Tab 6 - Financial Model'!$C16),('Tab 6 - Financial Model'!$D16*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!G$9),0)","v":0},{"$f":"IF(AND($D18=H$9,$B18='Tab 6 - Financial Model'!$C16),('Tab 6 - Financial Model'!$D16*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!H$9),0)","v":0},{"$f":"IF(AND($D18=I$9,$B18='Tab 6 - Financial Model'!$C16),('Tab 6 - Financial Model'!$D16*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!I$9),0)","v":0},{"$f":"IF(AND($D18=J$9,$B18='Tab 6 - Financial Model'!$C16),('Tab 6 - Financial Model'!$D16*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!J$9),0)","v":0},{"$f":"IF(AND($D18=K$9,$B18='Tab 6 - Financial Model'!$C16),('Tab 6 - Financial Model'!$D16*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!K$9),0)","v":0},{"$f":"IF(AND($D18=L$9,$B18='Tab 6 - Financial Model'!$C16),('Tab 6 - Financial Model'!$D16*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!L$9),0)","v":0},{"$f":"IF(AND($D18=M$9,$B18='Tab 6 - Financial Model'!$C16),('Tab 6 - Financial Model'!$D16*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!M$9),0)","v":0},{"$f":"IF(AND($D18=N$9,$B18='Tab 6 - Financial Model'!$C16),('Tab 6 - Financial Model'!$D16*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!N$9),0)","v":0},{"$f":"IF(AND($D18=O$9,$B18='Tab 6 - Financial Model'!$C16),('Tab 6 - Financial Model'!$D16*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!O$9),0)","v":0},{"$f":"IF(AND($D18=P$9,$B18='Tab 6 - Financial Model'!$C16),('Tab 6 - Financial Model'!$D16*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!P$9),0)","v":0},{"$f":"IF(AND($D18=Q$9,$B18='Tab 6 - Financial Model'!$C16),('Tab 6 - Financial Model'!$D16*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!Q$9),0)","v":0},{"$f":"IF(AND($D18=R$9,$B18='Tab 6 - Financial Model'!$C16),('Tab 6 - Financial Model'!$D16*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!R$9),0)","v":0},{"$f":"IF(AND($D18=S$9,$B18='Tab 6 - Financial Model'!$C16),('Tab 6 - Financial Model'!$D16*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!S$9),0)","v":0},{"$f":"IF(AND($D18=T$9,$B18='Tab 6 - Financial Model'!$C16),('Tab 6 - Financial Model'!$D16*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!T$9),0)","v":0},{"$f":"IF(AND($D18=U$9,$B18='Tab 6 - Financial Model'!$C16),('Tab 6 - Financial Model'!$D16*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!U$9),0)","v":0},{"$f":"IF(AND($D18=V$9,$B18='Tab 6 - Financial Model'!$C16),('Tab 6 - Financial Model'!$D16*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!V$9),0)","v":0},{"$f":"IF(AND($D18=W$9,$B18='Tab 6 - Financial Model'!$C16),('Tab 6 - Financial Model'!$D16*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!W$9),0)","v":0},{"$f":"IF(AND($D18=X$9,$B18='Tab 6 - Financial Model'!$C16),('Tab 6 - Financial Model'!$D16*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!X$9),0)","v":0},{"$f":"IF(AND($D18=Y$9,$B18='Tab 6 - Financial Model'!$C16),('Tab 6 - Financial Model'!$D16*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!Y$9),0)","v":70208584.18589209},{"$f":"IF(AND($D18=Z$9,$B18='Tab 6 - Financial Model'!$C16),('Tab 6 - Financial Model'!$D16*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!Z$9),0)","v":0},{"$f":"IF(AND($D18=AA$9,$B18='Tab 6 - Financial Model'!$C16),('Tab 6 - Financial Model'!$D16*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AA$9),0)","v":0},{"$f":"IF(AND($D18=AB$9,$B18='Tab 6 - Financial Model'!$C16),('Tab 6 - Financial Model'!$D16*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AB$9),0)","v":0},{"$f":"IF(AND($D18=AC$9,$B18='Tab 6 - Financial Model'!$C16),('Tab 6 - Financial Model'!$D16*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AC$9),0)","v":0},{"$f":"IF(AND($D18=AD$9,$B18='Tab 6 - Financial Model'!$C16),('Tab 6 - Financial Model'!$D16*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AD$9),0)","v":0},{"$f":"IF(AND($D18=AE$9,$B18='Tab 6 - Financial Model'!$C16),('Tab 6 - Financial Model'!$D16*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AE$9),0)","v":0},{"$f":"IF(AND($D18=AF$9,$B18='Tab 6 - Financial Model'!$C16),('Tab 6 - Financial Model'!$D16*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AF$9),0)","v":0},{"$f":"IF(AND($D18=AG$9,$B18='Tab 6 - Financial Model'!$C16),('Tab 6 - Financial Model'!$D16*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AG$9),0)","v":0},{"$f":"IF(AND($D18=AH$9,$B18='Tab 6 - Financial Model'!$C16),('Tab 6 - Financial Model'!$D16*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AH$9),0)","v":0},{"$f":"IF(AND($D18=AI$9,$B18='Tab 6 - Financial Model'!$C16),('Tab 6 - Financial Model'!$D16*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AI$9),0)","v":0},{"$f":"IF(AND($D18=AJ$9,$B18='Tab 6 - Financial Model'!$C16),('Tab 6 - Financial Model'!$D16*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AJ$9),0)","v":0},{"$f":"IF(AND($D18=AK$9,$B18='Tab 6 - Financial Model'!$C16),('Tab 6 - Financial Model'!$D16*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AK$9),0)","v":0},{"$f":"IF(AND($D18=AL$9,$B18='Tab 6 - Financial Model'!$C16),('Tab 6 - Financial Model'!$D16*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AL$9),0)","v":0},{"$f":"IF(AND($D18=AM$9,$B18='Tab 6 - Financial Model'!$C16),('Tab 6 - Financial Model'!$D16*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AM$9),0)","v":0},{"$f":"IF(AND($D18=AN$9,$B18='Tab 6 - Financial Model'!$C16),('Tab 6 - Financial Model'!$D16*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AN$9),0)","v":0},{"$f":"IF(AND($D18=AO$9,$B18='Tab 6 - Financial Model'!$C16),('Tab 6 - Financial Model'!$D16*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AO$9),0)","v":0},{"$f":"IF(AND($D18=AP$9,$B18='Tab 6 - Financial Model'!$C16),('Tab 6 - Financial Model'!$D16*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AP$9),0)","v":0},{"$f":"IF(AND($D18=AQ$9,$B18='Tab 6 - Financial Model'!$C16),('Tab 6 - Financial Model'!$D16*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AQ$9),0)","v":0}]
[null,"Expenditures from 2024 Bylaw",null,{"$f":"SUMIF('Tab 6 - Financial Model'!$C$15:$C$18,'Tab 7 - Bylaw Continuity'!B18,'Tab 6 - Financial Model'!$F$15:$F$18)","v":0.44},{"$f":"E18*$D19","v":0},{"$f":"F18*$D19","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,30891777.041792519,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Remainder: needed from other sources",null,null,{"$f":"E18-E19","v":0},{"$f":"F18-F19","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,39316807.144099571,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[3,{"$f":"'Tab 6 - Financial Model'!C17","v":"Police District Office- 3"},null,{"$f":"SUMIF('Tab 6 - Financial Model'!$C$15:$C$18,'Tab 7 - Bylaw Continuity'!B21,'Tab 6 - Financial Model'!$I$15:$I$18)","v":26},{"$f":"IF(AND($D21=E$9,$B21='Tab 6 - Financial Model'!$C17),('Tab 6 - Financial Model'!$D17*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!E$9),0)","v":0},{"$f":"IF(AND($D21=F$9,$B21='Tab 6 - Financial Model'!$C17),('Tab 6 - Financial Model'!$D17*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!F$9),0)","v":0},{"$f":"IF(AND($D21=G$9,$B21='Tab 6 - Financial Model'!$C17),('Tab 6 - Financial Model'!$D17*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!G$9),0)","v":0},{"$f":"IF(AND($D21=H$9,$B21='Tab 6 - Financial Model'!$C17),('Tab 6 - Financial Model'!$D17*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!H$9),0)","v":0},{"$f":"IF(AND($D21=I$9,$B21='Tab 6 - Financial Model'!$C17),('Tab 6 - Financial Model'!$D17*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!I$9),0)","v":0},{"$f":"IF(AND($D21=J$9,$B21='Tab 6 - Financial Model'!$C17),('Tab 6 - Financial Model'!$D17*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!J$9),0)","v":0},{"$f":"IF(AND($D21=K$9,$B21='Tab 6 - Financial Model'!$C17),('Tab 6 - Financial Model'!$D17*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!K$9),0)","v":0},{"$f":"IF(AND($D21=L$9,$B21='Tab 6 - Financial Model'!$C17),('Tab 6 - Financial Model'!$D17*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!L$9),0)","v":0},{"$f":"IF(AND($D21=M$9,$B21='Tab 6 - Financial Model'!$C17),('Tab 6 - Financial Model'!$D17*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!M$9),0)","v":0},{"$f":"IF(AND($D21=N$9,$B21='Tab 6 - Financial Model'!$C17),('Tab 6 - Financial Model'!$D17*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!N$9),0)","v":0},{"$f":"IF(AND($D21=O$9,$B21='Tab 6 - Financial Model'!$C17),('Tab 6 - Financial Model'!$D17*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!O$9),0)","v":0},{"$f":"IF(AND($D21=P$9,$B21='Tab 6 - Financial Model'!$C17),('Tab 6 - Financial Model'!$D17*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!P$9),0)","v":0},{"$f":"IF(AND($D21=Q$9,$B21='Tab 6 - Financial Model'!$C17),('Tab 6 - Financial Model'!$D17*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!Q$9),0)","v":0},{"$f":"IF(AND($D21=R$9,$B21='Tab 6 - Financial Model'!$C17),('Tab 6 - Financial Model'!$D17*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!R$9),0)","v":0},{"$f":"IF(AND($D21=S$9,$B21='Tab 6 - Financial Model'!$C17),('Tab 6 - Financial Model'!$D17*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!S$9),0)","v":0},{"$f":"IF(AND($D21=T$9,$B21='Tab 6 - Financial Model'!$C17),('Tab 6 - Financial Model'!$D17*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!T$9),0)","v":0},{"$f":"IF(AND($D21=U$9,$B21='Tab 6 - Financial Model'!$C17),('Tab 6 - Financial Model'!$D17*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!U$9),0)","v":0},{"$f":"IF(AND($D21=V$9,$B21='Tab 6 - Financial Model'!$C17),('Tab 6 - Financial Model'!$D17*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!V$9),0)","v":0},{"$f":"IF(AND($D21=W$9,$B21='Tab 6 - Financial Model'!$C17),('Tab 6 - Financial Model'!$D17*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!W$9),0)","v":0},{"$f":"IF(AND($D21=X$9,$B21='Tab 6 - Financial Model'!$C17),('Tab 6 - Financial Model'!$D17*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!X$9),0)","v":0},{"$f":"IF(AND($D21=Y$9,$B21='Tab 6 - Financial Model'!$C17),('Tab 6 - Financial Model'!$D17*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!Y$9),0)","v":0},{"$f":"IF(AND($D21=Z$9,$B21='Tab 6 - Financial Model'!$C17),('Tab 6 - Financial Model'!$D17*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!Z$9),0)","v":0},{"$f":"IF(AND($D21=AA$9,$B21='Tab 6 - Financial Model'!$C17),('Tab 6 - Financial Model'!$D17*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AA$9),0)","v":0},{"$f":"IF(AND($D21=AB$9,$B21='Tab 6 - Financial Model'!$C17),('Tab 6 - Financial Model'!$D17*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AB$9),0)","v":0},{"$f":"IF(AND($D21=AC$9,$B21='Tab 6 - Financial Model'!$C17),('Tab 6 - Financial Model'!$D17*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AC$9),0)","v":0},{"$f":"IF(AND($D21=AD$9,$B21='Tab 6 - Financial Model'!$C17),('Tab 6 - Financial Model'!$D17*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AD$9),0)","v":0},{"$f":"IF(AND($D21=AE$9,$B21='Tab 6 - Financial Model'!$C17),('Tab 6 - Financial Model'!$D17*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AE$9),0)","v":0},{"$f":"IF(AND($D21=AF$9,$B21='Tab 6 - Financial Model'!$C17),('Tab 6 - Financial Model'!$D17*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AF$9),0)","v":0},{"$f":"IF(AND($D21=AG$9,$B21='Tab 6 - Financial Model'!$C17),('Tab 6 - Financial Model'!$D17*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AG$9),0)","v":0},{"$f":"IF(AND($D21=AH$9,$B21='Tab 6 - Financial Model'!$C17),('Tab 6 - Financial Model'!$D17*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AH$9),0)","v":96354804.671776533},{"$f":"IF(AND($D21=AI$9,$B21='Tab 6 - Financial Model'!$C17),('Tab 6 - Financial Model'!$D17*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AI$9),0)","v":0},{"$f":"IF(AND($D21=AJ$9,$B21='Tab 6 - Financial Model'!$C17),('Tab 6 - Financial Model'!$D17*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AJ$9),0)","v":0},{"$f":"IF(AND($D21=AK$9,$B21='Tab 6 - Financial Model'!$C17),('Tab 6 - Financial Model'!$D17*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AK$9),0)","v":0},{"$f":"IF(AND($D21=AL$9,$B21='Tab 6 - Financial Model'!$C17),('Tab 6 - Financial Model'!$D17*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AL$9),0)","v":0},{"$f":"IF(AND($D21=AM$9,$B21='Tab 6 - Financial Model'!$C17),('Tab 6 - Financial Model'!$D17*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AM$9),0)","v":0},{"$f":"IF(AND($D21=AN$9,$B21='Tab 6 - Financial Model'!$C17),('Tab 6 - Financial Model'!$D17*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AN$9),0)","v":0},{"$f":"IF(AND($D21=AO$9,$B21='Tab 6 - Financial Model'!$C17),('Tab 6 - Financial Model'!$D17*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AO$9),0)","v":0},{"$f":"IF(AND($D21=AP$9,$B21='Tab 6 - Financial Model'!$C17),('Tab 6 - Financial Model'!$D17*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AP$9),0)","v":0},{"$f":"IF(AND($D21=AQ$9,$B21='Tab 6 - Financial Model'!$C17),('Tab 6 - Financial Model'!$D17*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AQ$9),0)","v":0}]
[null,"Expenditures from 2024 Bylaw",null,{"$f":"SUMIF('Tab 6 - Financial Model'!$C$15:$C$18,'Tab 7 - Bylaw Continuity'!B21,'Tab 6 - Financial Model'!$F$15:$F$18)","v":0.44},{"$f":"E21*$D22","v":0},{"$f":"F21*$D22","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,42396114.055581674,0,0,0,0,0,0,0,0,0]
[null,"Remainder: needed from other sources",null,null,{"$f":"E21-E22","v":0},{"$f":"F21-F22","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,53958690.616194859,0,0,0,0,0,0,0,0,0]
[4,{"$f":"'Tab 6 - Financial Model'!C18","v":"Police District Office- 4"},null,{"$f":"SUMIF('Tab 6 - Financial Model'!$C$15:$C$18,'Tab 7 - Bylaw Continuity'!B24,'Tab 6 - Financial Model'!$I$15:$I$18)","v":35},{"$f":"IF(AND($D24=E$9,$B24='Tab 6 - Financial Model'!$C18),('Tab 6 - Financial Model'!$D18*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!E$9),0)","v":0},{"$f":"IF(AND($D24=F$9,$B24='Tab 6 - Financial Model'!$C18),('Tab 6 - Financial Model'!$D18*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!F$9),0)","v":0},{"$f":"IF(AND($D24=G$9,$B24='Tab 6 - Financial Model'!$C18),('Tab 6 - Financial Model'!$D18*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!G$9),0)","v":0},{"$f":"IF(AND($D24=H$9,$B24='Tab 6 - Financial Model'!$C18),('Tab 6 - Financial Model'!$D18*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!H$9),0)","v":0},{"$f":"IF(AND($D24=I$9,$B24='Tab 6 - Financial Model'!$C18),('Tab 6 - Financial Model'!$D18*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!I$9),0)","v":0},{"$f":"IF(AND($D24=J$9,$B24='Tab 6 - Financial Model'!$C18),('Tab 6 - Financial Model'!$D18*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!J$9),0)","v":0},{"$f":"IF(AND($D24=K$9,$B24='Tab 6 - Financial Model'!$C18),('Tab 6 - Financial Model'!$D18*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!K$9),0)","v":0},{"$f":"IF(AND($D24=L$9,$B24='Tab 6 - Financial Model'!$C18),('Tab 6 - Financial Model'!$D18*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!L$9),0)","v":0},{"$f":"IF(AND($D24=M$9,$B24='Tab 6 - Financial Model'!$C18),('Tab 6 - Financial Model'!$D18*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!M$9),0)","v":0},{"$f":"IF(AND($D24=N$9,$B24='Tab 6 - Financial Model'!$C18),('Tab 6 - Financial Model'!$D18*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!N$9),0)","v":0},{"$f":"IF(AND($D24=O$9,$B24='Tab 6 - Financial Model'!$C18),('Tab 6 - Financial Model'!$D18*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!O$9),0)","v":0},{"$f":"IF(AND($D24=P$9,$B24='Tab 6 - Financial Model'!$C18),('Tab 6 - Financial Model'!$D18*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!P$9),0)","v":0},{"$f":"IF(AND($D24=Q$9,$B24='Tab 6 - Financial Model'!$C18),('Tab 6 - Financial Model'!$D18*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!Q$9),0)","v":0},{"$f":"IF(AND($D24=R$9,$B24='Tab 6 - Financial Model'!$C18),('Tab 6 - Financial Model'!$D18*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!R$9),0)","v":0},{"$f":"IF(AND($D24=S$9,$B24='Tab 6 - Financial Model'!$C18),('Tab 6 - Financial Model'!$D18*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!S$9),0)","v":0},{"$f":"IF(AND($D24=T$9,$B24='Tab 6 - Financial Model'!$C18),('Tab 6 - Financial Model'!$D18*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!T$9),0)","v":0},{"$f":"IF(AND($D24=U$9,$B24='Tab 6 - Financial Model'!$C18),('Tab 6 - Financial Model'!$D18*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!U$9),0)","v":0},{"$f":"IF(AND($D24=V$9,$B24='Tab 6 - Financial Model'!$C18),('Tab 6 - Financial Model'!$D18*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!V$9),0)","v":0},{"$f":"IF(AND($D24=W$9,$B24='Tab 6 - Financial Model'!$C18),('Tab 6 - Financial Model'!$D18*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!W$9),0)","v":0},{"$f":"IF(AND($D24=X$9,$B24='Tab 6 - Financial Model'!$C18),('Tab 6 - Financial Model'!$D18*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!X$9),0)","v":0},{"$f":"IF(AND($D24=Y$9,$B24='Tab 6 - Financial Model'!$C18),('Tab 6 - Financial Model'!$D18*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!Y$9),0)","v":0},{"$f":"IF(AND($D24=Z$9,$B24='Tab 6 - Financial Model'!$C18),('Tab 6 - Financial Model'!$D18*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!Z$9),0)","v":0},{"$f":"IF(AND($D24=AA$9,$B24='Tab 6 - Financial Model'!$C18),('Tab 6 - Financial Model'!$D18*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AA$9),0)","v":0},{"$f":"IF(AND($D24=AB$9,$B24='Tab 6 - Financial Model'!$C18),('Tab 6 - Financial Model'!$D18*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AB$9),0)","v":0},{"$f":"IF(AND($D24=AC$9,$B24='Tab 6 - Financial Model'!$C18),('Tab 6 - Financial Model'!$D18*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AC$9),0)","v":0},{"$f":"IF(AND($D24=AD$9,$B24='Tab 6 - Financial Model'!$C18),('Tab 6 - Financial Model'!$D18*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AD$9),0)","v":0},{"$f":"IF(AND($D24=AE$9,$B24='Tab 6 - Financial Model'!$C18),('Tab 6 - Financial Model'!$D18*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AE$9),0)","v":0},{"$f":"IF(AND($D24=AF$9,$B24='Tab 6 - Financial Model'!$C18),('Tab 6 - Financial Model'!$D18*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AF$9),0)","v":0},{"$f":"IF(AND($D24=AG$9,$B24='Tab 6 - Financial Model'!$C18),('Tab 6 - Financial Model'!$D18*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AG$9),0)","v":0},{"$f":"IF(AND($D24=AH$9,$B24='Tab 6 - Financial Model'!$C18),('Tab 6 - Financial Model'!$D18*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AH$9),0)","v":0},{"$f":"IF(AND($D24=AI$9,$B24='Tab 6 - Financial Model'!$C18),('Tab 6 - Financial Model'!$D18*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AI$9),0)","v":0},{"$f":"IF(AND($D24=AJ$9,$B24='Tab 6 - Financial Model'!$C18),('Tab 6 - Financial Model'!$D18*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AJ$9),0)","v":0},{"$f":"IF(AND($D24=AK$9,$B24='Tab 6 - Financial Model'!$C18),('Tab 6 - Financial Model'!$D18*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AK$9),0)","v":0},{"$f":"IF(AND($D24=AL$9,$B24='Tab 6 - Financial Model'!$C18),('Tab 6 - Financial Model'!$D18*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AL$9),0)","v":0},{"$f":"IF(AND($D24=AM$9,$B24='Tab 6 - Financial Model'!$C18),('Tab 6 - Financial Model'!$D18*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AM$9),0)","v":0},{"$f":"IF(AND($D24=AN$9,$B24='Tab 6 - Financial Model'!$C18),('Tab 6 - Financial Model'!$D18*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AN$9),0)","v":0},{"$f":"IF(AND($D24=AO$9,$B24='Tab 6 - Financial Model'!$C18),('Tab 6 - Financial Model'!$D18*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AO$9),0)","v":0},{"$f":"IF(AND($D24=AP$9,$B24='Tab 6 - Financial Model'!$C18),('Tab 6 - Financial Model'!$D18*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AP$9),0)","v":0},{"$f":"IF(AND($D24=AQ$9,$B24='Tab 6 - Financial Model'!$C18),('Tab 6 - Financial Model'!$D18*(1+'Tab 6 - Financial Model'!$E$25)^'Tab 7 - Bylaw Continuity'!AQ$9),0)","v":112402368.13408841}]
[null,"Expenditures from 2024 Bylaw",null,{"$f":"SUMIF('Tab 6 - Financial Model'!$C$15:$C$18,'Tab 7 - Bylaw Continuity'!B24,'Tab 6 - Financial Model'!$F$15:$F$18)","v":0.44},{"$f":"E24*$D25","v":0},{"$f":"F24*$D25","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,0,0,0,0,0,0,0,0,0,49457041.978998899]
[null,"Remainder: needed from other sources",null,null,{"$f":"E24-E25","v":0},{"$f":"F24-F25","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,0,0,0,0,0,0,0,0,0,62945326.155089512]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"TOTAL:"]
[null,"Expenditures from 2024 Bylaw",null,null,{"$f":"E16+E19+E22+E25","v":0},{"$f":"F16+F19+F22+F25","v":0},0,0,0,0,0,0,0,20980117.599189755,0,0,0,0,0,0,0,0,0,0,30891777.041792519,0,0,0,0,0,0,0,0,42396114.055581674,0,0,0,0,0,0,0,0,49457041.978998899]
[null,"Remainder: needed from other sources",null,null,{"$f":"E17+E20+E23+E26","v":0},{"$f":"F17+F20+F23+F26","v":0},0,0,0,0,0,0,{"$f":"M17+M20+M23+M26","v":0},26701967.853514235,0,0,0,0,0,0,0,0,0,0,39316807.144099571,0,0,0,0,0,0,0,0,53958690.616194859,0,0,0,0,0,0,0,0,62945326.155089512]
[null,"Expenditures from 2M2016 Bylaw Balance",null,null,{"$f":"IF(E61=0,0,IF(D72>E50,E50,D72))","v":0},{"$f":"IF(F61=0,0,IF(E72>F50,F50,E72))","v":0},{"$f":"IF(G61=0,0,IF(F72>G50,G50,F72))","v":0},{"$f":"IF(H61=0,0,IF(G72>H50,H50,G72))","v":0},{"$f":"IF(I61=0,0,IF(H72>I50,I50,H72))","v":0},{"$f":"IF(J61=0,0,IF(I72>J50,J50,I72))","v":0},{"$f":"IF(K61=0,0,IF(J72>K50,K50,J72))","v":0},{"$f":"IF(L61=0,0,IF(K72>L50,L50,K72))","v":0},{"$f":"IF(M61=0,0,IF(L72>M50,M50,L72))","v":0},26701967.853514235,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(Y61=0,0,IF(X72>Y50,Y50,X72+Y69))","v":18360968.280803155},{"$f":"IF(Z61=0,0,IF(Y72>Z50,Z50,Y72))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Expenditures from Non-OSL City Funding Sources",null,null,{"$f":"(E49+E50)-E49-E51","v":0},0,0,0,0,0,0,0,0,{"$f":"(N49+N50)-N49-N51","v":0},0,0,0,{"$f":"(R49+R50)-R49-R51","v":0},0,0,0,0,0,0,20955838.863296416,0,0,0,0,0,0,0,0,53958690.616194859,0,0,0,0,0,0,0,0,62945326.155089512]
[]
["Land absorption (hectares) and DA contributions ($)"]
["Land absorption forecast and developer contributions under each bylaw. The contribution values feed into the payment schedule below.",null,null,"Land Absorption (ha)",262,367,506,{"$f":"'Tab 6 - Financial Model'!L29","v":290},{"$f":"'Tab 6 - Financial Model'!M29","v":309},{"$f":"'Tab 6 - Financial Model'!N29","v":327},{"$f":"'Tab 6 - Financial Model'!O29","v":321},{"$f":"'Tab 6 - Financial Model'!P29","v":321},{"$f":"'Tab 6 - Financial Model'!Q29","v":318.48089795918366},{"$f":"'Tab 6 - Financial Model'!R29","v":315.96179591836733},{"$f":"'Tab 6 - Financial Model'!S29","v":313.44269387755099},{"$f":"'Tab 6 - Financial Model'!T29","v":310.92359183673466},{"$f":"'Tab 6 - Financial Model'!U29","v":308.40448979591832},{"$f":"'Tab 6 - Financial Model'!V29","v":305.88538775510199},{"$f":"'Tab 6 - Financial Model'!W29","v":303.36628571428565},{"$f":"'Tab 6 - Financial Model'!X29","v":300.84718367346932},{"$f":"'Tab 6 - Financial Model'!Y29","v":298.32808163265298},{"$f":"'Tab 6 - Financial Model'!Z29","v":295.80897959183665},{"$f":"'Tab 6 - Financial Model'!AA29","v":293.28987755102031},{"$f":"'Tab 6 - Financial Model'!AB29","v":290.77077551020398},{"$f":"'Tab 6 - Financial Model'!AC29","v":288.25167346938764},{"$f":"'Tab 6 - Financial Model'!AD29","v":285.7325714285713},{"$f":"'Tab 6 - Financial Model'!AE29","v":283.21346938775497},{"$f":"'Tab 6 - Financial Model'!AF29","v":280.69436734693863},{"$f":"'Tab 6 - Financial Model'!AG29","v":278.1752653061223},{"$f":"'Tab 6 - Financial Model'!AH29","v":275.65616326530596},{"$f":"'Tab 6 - Financial Model'!AI29","v":273.13706122448963},{"$f":"'Tab 6 - Financial Model'!AJ29","v":270.61795918367329},{"$f":"'Tab 6 - Financial Model'!AK29","v":268.09885714285696},{"$f":"'Tab 6 - Financial Model'!AL29","v":265.57975510204062},{"$f":"'Tab 6 - Financial Model'!AM29","v":263.06065306122429},{"$f":"'Tab 6 - Financial Model'!AN29","v":225.741551020408},{"$f":"'Tab 6 - Financial Model'!AO29","v":223.222448979592},{"$f":"'Tab 6 - Financial Model'!AP29","v":220.70334693877498},{"$f":"'Tab 6 - Financial Model'!AQ29","v":218.18424489795899},{"$f":"'Tab 6 - Financial Model'!AR29","v":215.665142857143},{"$f":"'Tab 6 - Financial Model'!AS29","v":0},{"$f":"'Tab 6 - Financial Model'!AT29","v":0},{"$f":"'Tab 6 - Financial Model'!AU29","v":0}]
[null,null,null,"Levy Rates under the 2016 bylaw",7801,7848,8025,8749]
[null,null,null,"Contributions from signed DAs - 2016 Levy",{"$f":"E55*E56","v":2043862},{"$f":"F55*F56","v":2880216},4060650,2537210]
[null,null,null,"Contributions from signed DAs - 2024 Levy",0,0,0,0,{"$f":"'Tab 6 - Financial Model'!M34","v":2298392.0332541224},{"$f":"'Tab 6 - Financial Model'!N34","v":2536623.7146737762},{"$f":"'Tab 6 - Financial Model'!O34","v":2596904.5991519368},{"$f":"'Tab 6 - Financial Model'!P34","v":2708311.8064555544},{"$f":"'Tab 6 - Financial Model'!Q34","v":2802332.6519843414},{"$f":"'Tab 6 - Financial Model'!R34","v":2899436.0819277796},{"$f":"'Tab 6 - Financial Model'!S34","v":2999713.5451243264},{"$f":"'Tab 6 - Financial Model'!T34","v":3103258.6635035966},{"$f":"'Tab 6 - Financial Model'!U34","v":3210167.2502342248},{"$f":"'Tab 6 - Financial Model'!V34","v":3320537.3254294428},{"$f":"'Tab 6 - Financial Model'!W34","v":3434469.1291674073},{"$f":"'Tab 6 - Financial Model'!X34","v":3552065.1315669953},{"$f":"'Tab 6 - Financial Model'!Y34","v":3673430.0396424565},{"$f":"'Tab 6 - Financial Model'!Z34","v":3798670.8006420056},{"$f":"'Tab 6 - Financial Model'!AA34","v":3927896.601556058},{"$f":"'Tab 6 - Financial Model'!AB34","v":4061218.8644603258},{"$f":"'Tab 6 - Financial Model'!AC34","v":4198751.2373373099},{"$f":"'Tab 6 - Financial Model'!AD34","v":4340609.5799967991},{"$f":"'Tab 6 - Financial Model'!AE34","v":4486911.9446917633},{"$f":"'Tab 6 - Financial Model'!AF34","v":4637778.551000434},{"$f":"'Tab 6 - Financial Model'!AG34","v":4793331.7545182584},{"$f":"'Tab 6 - Financial Model'!AH34","v":4953696.0088748652},{"$f":"'Tab 6 - Financial Model'!AI34","v":5118997.8205609359},{"$f":"'Tab 6 - Financial Model'!AJ34","v":5289365.6960179787},{"$f":"'Tab 6 - Financial Model'!AK34","v":5464930.0804102952},{"$f":"'Tab 6 - Financial Model'!AL34","v":5645823.2874628659},{"$f":"'Tab 6 - Financial Model'!AM34","v":5832179.4197112601},{"$f":"'Tab 6 - Financial Model'!AN34","v":5219503.0322458018},{"$f":"'Tab 6 - Financial Model'!AO34","v":5382675.3360972898},{"$f":"'Tab 6 - Financial Model'!AP34","v":5550241.7980436347},{"$f":"'Tab 6 - Financial Model'!AQ34","v":5722279.1329096975},{"$f":"'Tab 6 - Financial Model'!AR34","v":5898862.5505997306},{"$f":"'Tab 6 - Financial Model'!AS34","v":0},{"$f":"'Tab 6 - Financial Model'!AT34","v":0},{"$f":"'Tab 6 - Financial Model'!AU34","v":0}]
[]
["Yearly cash flows ($)"]
["The opening balance takes the closing balance from the prior year.",null,null,"Opening Balance - 2016 Bylaw",null,null,null,{"$f":"G72","v":45482019},{"$f":"H72","v":49520900.454999998},{"$f":"I72","v":54587343.717719495},61076891.705709666,66288723.514384612,{"$f":"L72","v":35935384.753151715},37477012.759061925,11810051.542453568,12316702.753624827,12845089.301755331,13396143.632800635,13970838.194647782,14570187.153198171,15195248.182070373,15847124.329081191,16526965.962798774,17235972.802602842,17975396.035834506,{"$f":"Y72","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AO72","v":0},0]
[null,null,null,"Opening Balance - 2024 Bylaw",null,null,null,0,{"$f":"H73","v":0},0,0,{"$f":"K73","v":0},2347692.5423674234,5039442.8457885142,-13521897.975015787,-11335582.303439939,-8959436.0968881063,-6382166.919559475,-3591904.4797413335,-576173.62008648808,2678133.8693635501,6184788.6634191517,9958254.5890678819,14013720.639578002,18367134.369008683,-8519168.9365840368,-4872491.3003040561,-933189.16798410041,3315591.4680875768,7891545.9975562645,12813249.526756831,18100196.832374092,23772843.997135617,29852651.792877965,-6943379.8234694973,-1838428.2276987743,3664856.0319680446,9589004.5527184177,15957652.516294105,21973697.181530595,28414502.512674835,35302779.155080259,42662290.401143819]
[]
["Payment schedule from signed DAs. Payments from DAs signed under the 2016 bylaw are shown in green, from the 2024 bylaw in orange.","Year 0",null,0,null,null,null,{"$f":"$D64*H56*H55","v":0},{"$f":"$D64*A10*I55","v":0},{"$f":"$D64*J58*J55","v":0},{"$f":"$D64*K56*K55","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,0,0,0,0,0]
[null,"Year 1",null,0,null,null,null,{"$f":"$D65*G56*G55","v":0},{"$f":"$D65*H56*H55","v":0},{"$f":"$D65*A10*I55","v":0},{"$f":"$D65*J58*J55","v":0},{"$f":"$D65*K56*K55","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,0,0,0,0]
[null,"Year 2",null,0,null,null,null,{"$f":"$D66*F57","v":0},{"$f":"$D66*G57","v":0},{"$f":"$D66*H57","v":0},{"$f":"$D66*I58","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,0,0,0,0,0]
[null,"Year 3",null,1,null,null,null,{"$f":"$D67*E57","v":2043862},{"$f":"$D67*F57","v":2880216},{"$f":"$D67*G57","v":4060650},{"$f":"$D67*H57","v":2537210},{"$f":"$D67*I58","v":2298392.0332541224},2536623.7146737762,2596904.5991519368,2708311.8064555544,2802332.6519843414,2899436.0819277796,2999713.5451243264,3103258.6635035966,3210167.2502342248,3320537.3254294428,3434469.1291674073,3552065.1315669953,3673430.0396424565,3798670.8006420056,3927896.601556058,4061218.8644603258,4198751.2373373099,4340609.5799967991,4486911.9446917633,4637778.551000434,4793331.7545182584,4953696.0088748652,5118997.8205609359,5289365.6960179787,5464930.0804102952,5645823.2874628659,5832179.4197112601,5219503.0322458018,5382675.3360972898,5550241.7980436347,5722279.1329096975,5898862.5505997306]
[]
["Investment income: shown for each bylaw separately.",null,null,"Investment Income - 2016 Bylaw",null,null,null,{"$f":"((H61+(SUM(H64:H67)*0.5))-((H51+H13)*0.5))*'Tab 6 - Financial Model'!E26","v":1995019.4550000001},{"$f":"((I61+(SUM(I65:I67)*0.5))-((I51+I13)*0.5))*'Tab 6 - Financial Model'!E26","v":2186227.2627194999},{"$f":"((J61+(SUM(J66:J67)*0.5))-((J51+J13)*0.5))*'Tab 6 - Financial Model'!E26","v":2428897.9879901665},{"$f":"((K61+(SUM(K67)*0.5))-((K51+K13)*0.5))*'Tab 6 - Financial Model'!E26","v":2674621.8086749446},{"$f":"(L61-((L51+L13)*0.5))*'Tab 6 - Financial Model'!$E$26","v":2146661.2387671},{"$f":"(M61-((M51+M13)*0.5))*'Tab 6 - Financial Model'!$E$26","v":1541628.0059102087},{"$f":"(N61-((N51+N13)*0.5))*'Tab 6 - Financial Model'!$E$26","v":1035006.6369058762},{"$f":"(O61-((O51+O13)*0.5))*'Tab 6 - Financial Model'!$E$26","v":506651.21117125807},{"$f":"(P61-((P51+P13)*0.5))*'Tab 6 - Financial Model'!$E$26","v":528386.54813050502},{"$f":"(Q61-((Q51+Q13)*0.5))*'Tab 6 - Financial Model'!$E$26","v":551054.33104530373},{"$f":"(R61-((R51+R13)*0.5))*'Tab 6 - Financial Model'!$E$26","v":574694.5618471473},{"$f":"(S61-((S51+S13)*0.5))*'Tab 6 - Financial Model'!$E$26","v":599348.95855038986},{"$f":"(T61-((T51+T13)*0.5))*'Tab 6 - Financial Model'!$E$26","v":625061.02887220157},{"$f":"(U61-((U51+U13)*0.5))*'Tab 6 - Financial Model'!$E$26","v":651876.14701081894},{"$f":"(V61-((V51+V13)*0.5))*'Tab 6 - Financial Model'!$E$26","v":679841.63371758314},{"$f":"(W61-((W51+W13)*0.5))*'Tab 6 - Financial Model'!$E$26","v":709006.83980406739},{"$f":"(X61-((X51+X13)*0.5))*'Tab 6 - Financial Model'!$E$26","v":739423.23323166196},{"$f":"(Y61-(Y61*0.5))*'Tab 6 - Financial Model'!$E$26","v":385572.24496865016},{"$f":"(Z61-((Z51+Z13)*0.5))*'Tab 6 - Financial Model'!$E$26","v":0},{"$f":"(AA61-((AA51+AA13)*0.5))*'Tab 6 - Financial Model'!$E$26","v":0},{"$f":"(AB61-((AB51+AB13)*0.5))*'Tab 6 - Financial Model'!$E$26","v":0},{"$f":"(AC61-((AC51+AC13)*0.5))*'Tab 6 - Financial Model'!$E$26","v":0},{"$f":"(AD61-((AD51+AD13)*0.5))*'Tab 6 - Financial Model'!$E$26","v":0},{"$f":"(AE61-((AE51+AE13)*0.5))*'Tab 6 - Financial Model'!$E$26","v":0},{"$f":"(AF61-((AF51+AF13)*0.5))*'Tab 6 - Financial Model'!$E$26","v":0},{"$f":"(AG61-((AG51+AG13)*0.5))*'Tab 6 - Financial Model'!$E$26","v":0},{"$f":"(AH61-((AH51+AH13)*0.5))*'Tab 6 - Financial Model'!$E$26","v":0},{"$f":"(AI61-((AI51+AI13)*0.5))*'Tab 6 - Financial Model'!$E$26","v":0},{"$f":"(AJ61-((AJ51+AJ13)*0.5))*'Tab 6 - Financial Model'!$E$26","v":0},{"$f":"(AK61-((AK51+AK13)*0.5))*'Tab 6 - Financial Model'!$E$26","v":0},{"$f":"(AL61-((AL51+AL13)*0.5))*'Tab 6 - Financial Model'!$E$26","v":0},{"$f":"(AM61-((AM51+AM13)*0.5))*'Tab 6 - Financial Model'!$E$26","v":0},{"$f":"(AN61-((AN51+AN13)*0.5))*'Tab 6 - Financial Model'!$E$26","v":0},{"$f":"(AO61-((AO51+AO13)*0.5))*'Tab 6 - Financial Model'!$E$26","v":0},{"$f":"(AP61-((AP51+AP13)*0.5))*'Tab 6 - Financial Model'!$E$26","v":0},{"$f":"(AQ61-((AQ51+AQ13)*0.5))*'Tab 6 - Financial Model'!$E$26","v":0}]
[null,null,null,"Investment Income - 2024 Bylaw",null,null,null,{"$f":"(H62-(H49*0.5))*'Tab 6 - Financial Model'!E26","v":0},{"$f":"((I62+(SUM(I64)*0.5))-(I49*0.5))*'Tab 6 - Financial Model'!E26","v":0},{"$f":"((J62+(SUM(J64:J65)*0.5))-(J49*0.5))*'Tab 6 - Financial Model'!E26","v":0},{"$f":"((K62+(SUM(K64:K66)*0.5))-(K49*0.5))*'Tab 6 - Financial Model'!E26","v":0},{"$f":"((L62+(SUM(L64:L67)*0.5))-(L49*0.5))*'Tab 6 - Financial Model'!$E$26","v":49300.509113300926},{"$f":"((M62+(SUM(M64:M67)*0.5))-(M49*0.5))*'Tab 6 - Financial Model'!$E$26","v":155126.58874731496},{"$f":"((N62+(SUM(N64:N67)*0.5))-(N49*0.5))*'Tab 6 - Financial Model'!$E$26","v":-178127.82076648393},{"$f":"((O62+(SUM(O64:O67)*0.5))-(O49*0.5))*'Tab 6 - Financial Model'!$E$26","v":-521996.13487970561},{"$f":"((P62+(SUM(P64:P67)*0.5))-(P49*0.5))*'Tab 6 - Financial Model'!$E$26","v":-426186.4454325093},{"$f":"((Q62+(SUM(Q64:Q67)*0.5))-(Q49*0.5))*'Tab 6 - Financial Model'!$E$26","v":-322166.9045991489},{"$f":"((R62+(SUM(R64:R67)*0.5))-(R49*0.5))*'Tab 6 - Financial Model'!$E$26","v":-209451.10530618471},{"$f":"((S62+(SUM(S64:S67)*0.5))-(S49*0.5))*'Tab 6 - Financial Model'!$E$26","v":-87527.803848751064},{"$f":"((T62+(SUM(T64:T67)*0.5))-(T49*0.5))*'Tab 6 - Financial Model'!$E$26","v":44140.239215813788},{"$f":"((U62+(SUM(U64:U67)*0.5))-(U49*0.5))*'Tab 6 - Financial Model'!$E$26","v":186117.46862615785},{"$f":"((V62+(SUM(V64:V67)*0.5))-(V49*0.5))*'Tab 6 - Financial Model'!$E$26","v":338996.7964813225},{"$f":"((W62+(SUM(W64:W67)*0.5))-(W49*0.5))*'Tab 6 - Financial Model'!$E$26","v":503400.91894312418},{"$f":"((X62+(SUM(X64:X67)*0.5))-(X49*0.5))*'Tab 6 - Financial Model'!$E$26","v":679983.68978822697},{"$f":"((Y62+(SUM(Y64:Y67)*0.5))-(Y49*0.5))*'Tab 6 - Financial Model'!$E$26","v":206802.93555779397},{"$f":"((Z62+(SUM(Z64:Z67)*0.5))-(Z49*0.5))*'Tab 6 - Financial Model'!$E$26","v":-281218.96527607774},{"$f":"((AA62+(SUM(AA64:AA67)*0.5))-(AA49*0.5))*'Tab 6 - Financial Model'!$E$26","v":-121916.73214037002},{"$f":"((AB62+(SUM(AB64:AB67)*0.5))-(AB49*0.5))*'Tab 6 - Financial Model'!$E$26","v":50029.398734367387},{"$f":"((AC62+(SUM(AC64:AC67)*0.5))-(AC49*0.5))*'Tab 6 - Financial Model'!$E$26","v":235344.94947188839},{"$f":"((AD62+(SUM(AD64:AD67)*0.5))-(AD49*0.5))*'Tab 6 - Financial Model'!$E$26","v":434791.5845088021},{"$f":"((AE62+(SUM(AE64:AE67)*0.5))-(AE49*0.5))*'Tab 6 - Financial Model'!$E$26","v":649168.75461682735},{"$f":"((AF62+(SUM(AF64:AF67)*0.5))-(AF49*0.5))*'Tab 6 - Financial Model'!$E$26","v":879315.4102432651},{"$f":"((AG62+(SUM(AG64:AG67)*0.5))-(AG49*0.5))*'Tab 6 - Financial Model'!$E$26","v":1126111.7868674838},{"$f":"((AH62+(SUM(AH64:AH67)*0.5))-(AH49*0.5))*'Tab 6 - Financial Model'!$E$26","v":481084.61867326975},{"$f":"((AI62+(SUM(AI64:AI67)*0.5))-(AI49*0.5))*'Tab 6 - Financial Model'!$E$26","v":-184414.10024725579},{"$f":"((AJ62+(SUM(AJ64:AJ67)*0.5))-(AJ49*0.5))*'Tab 6 - Financial Model'!$E$26","v":38354.179256523414},{"$f":"((AK62+(SUM(AK64:AK67)*0.5))-(AK49*0.5))*'Tab 6 - Financial Model'!$E$26","v":278325.23328750761},{"$f":"((AL62+(SUM(AL64:AL67)*0.5))-(AL49*0.5))*'Tab 6 - Financial Model'!$E$26","v":536468.54386442667},{"$f":"((AM62+(SUM(AM64:AM67)*0.5))-(AM49*0.5))*'Tab 6 - Financial Model'!$E$26","v":796541.6329906896},{"$f":"((AN62+(SUM(AN64:AN67)*0.5))-(AN49*0.5))*'Tab 6 - Financial Model'!$E$26","v":1058129.9950469495},{"$f":"((AO62+(SUM(AO64:AO67)*0.5))-(AO49*0.5))*'Tab 6 - Financial Model'!$E$26","v":1338034.8443617863},{"$f":"((AP62+(SUM(AP64:AP67)*0.5))-(AP49*0.5))*'Tab 6 - Financial Model'!$E$26","v":1637232.1131538562},{"$f":"((AQ62+(SUM(AQ64:AQ67)*0.5))-(AQ49*0.5))*'Tab 6 - Financial Model'!$E$26","v":895889.30946990754}]
[]
["Closing balances = Starting balance + contributions + investment income - expenditures",null,null,"Closing Balance - 2016 Bylaw",null,null,45482019,{"$f":"H61+SUM(H64:H69)-H51-H13","v":49520900.454999998},{"$f":"I61+SUM(I65:I69)-I51-I13","v":54587343.717719495},{"$f":"J61+SUM(J66:J69)-J51-J13","v":61076891.705709666},{"$f":"K61+SUM(K67:K69)-K51-K13","v":66288723.514384612},{"$f":"IF(L61-L51-L13>0,L61+L69-L51-L13,0)","v":35935384.753151715},{"$f":"IF(M61-M51-M13>0,M61+M69-M51-M13,0)","v":37477012.759061925},{"$f":"IF(N61-N51-N13>0,N61+N69-N51-N13,0)","v":11810051.542453568},12316702.753624827,12845089.301755331,13396143.632800635,13970838.194647782,14570187.153198171,15195248.182070373,15847124.329081191,16526965.962798774,17235972.802602842,17975396.035834506,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Closing Balance - 2024 Bylaw",null,null,null,{"$f":"SUM(H62:H66,H70)-H49","v":0},0,0,{"$f":"SUM(K62:K66,K70)-K49","v":0},{"$f":"SUM(L62:L67,L70)-L49","v":2347692.5423674234},{"$f":"SUM(M62:M67,M70)-M49","v":5039442.8457885142},{"$f":"SUM(N62:N67,N70)-N49","v":-13521897.975015787},-11335582.303439939,-8959436.0968881063,-6382166.919559475,-3591904.4797413335,-576173.62008648808,2678133.8693635501,6184788.6634191517,9958254.5890678819,14013720.639578002,18367134.369008683,-8519168.9365840368,-4872491.3003040561,-933189.16798410041,3315591.4680875768,7891545.9975562645,12813249.526756831,18100196.832374092,23772843.997135617,29852651.792877965,-6943379.8234694973,-1838428.2276987743,3664856.0319680446,9589004.5527184177,15957652.516294105,21973697.181530595,28414502.512674835,35302779.155080259,42662290.401143819,{"$f":"SUM(AQ62:AQ67,AQ70)-AQ49","v":0.28221455961465836}]

{"sheet":"Tab 8 - Population Forecast","index":8,"n_rows":461,"n_cols":17,"rows_kept":461,"cut":false,"hidden":false,"merged":[]}
["Police - Benefit Share Details"]
[]
["TZ1919","Location","Levied land (ha)","Unlevied land (ha)","Total land (ha)","Benefit share (levied land)","Benefit share (unlevied land)","Total share","Total population","Plan type","Levied","Unlevied",null,null,"Row Labels","Sum of Levied","Sum of Leviable"]
[501,"Outside_levy_boundary",57.0636011709,4.5788297042E-4,57.064059053870423,0.99999197598316669,8.0240168332179604E-6,0.99999999999999989,{"$f":"VLOOKUP($A4,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":2577.8124827000001},{"$f":"VLOOKUP($A4,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Buildout"},{"$f":"$I4*F4","v":2577.7917982892459},{"$f":"$I4*G4","v":2.0684410754064183E-2},null,null,"Area Structure Plan",448287.9088240494,416991.43787445547]
[502,"Outside_levy_boundary",46.063400876899998,0,46.063400876899998,1,0,1,{"$f":"VLOOKUP($A5,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":2188.8626342100001},{"$f":"VLOOKUP($A5,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Buildout"},{"$f":"$I5*F5","v":2188.8626342100001},0,null,null,"Buildout",37643.396969918045,17.976383964498833]
[503,"Outside_levy_boundary",26.249627691099999,0,26.249627691099999,1,0,1,{"$f":"VLOOKUP($A6,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":799.17687227600004},{"$f":"VLOOKUP($A6,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Buildout"},799.17687227600004,0,null,null,"Community Plan",43894.606030096096,9.9560903907057269E-2]
[504,"Outside_levy_boundary",63.281117571000003,0,63.281117571000003,1,0,1,{"$f":"VLOOKUP($A7,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":2690.096043},{"$f":"VLOOKUP($A7,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Buildout"},2690.096043,0,null,null,"Unplanned",601.55756605499857,271005.67363714508]
[505,"Outside_levy_boundary",13.288854669899999,0,13.288854669899999,1,0,1,{"$f":"VLOOKUP($A8,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":294.71664025799998},{"$f":"VLOOKUP($A8,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Buildout"},294.71664025799998,0,null,null,"Grand Total",530427.46939011849,688015.18745646894]
[506,"Outside_levy_boundary",38.278899068199998,0,38.278899068199998,1,0,1,{"$f":"VLOOKUP($A9,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":1469.2807668600001},{"$f":"VLOOKUP($A9,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Buildout"},1469.2807668600001,0]
[507,"Outside_levy_boundary",69.92959046,0,69.92959046,1,0,1,{"$f":"VLOOKUP($A10,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":2106.0408049399998},{"$f":"VLOOKUP($A10,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Buildout"},2106.0408049399998,0,null,null,"Greenfield  ASP population "]
[508,"Outside_levy_boundary",24.939951793799999,0,24.939951793799999,1,0,1,{"$f":"VLOOKUP($A11,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":1004.6180342},{"$f":"VLOOKUP($A11,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Buildout"},1004.6180342,0,null,null,"Planned (levied)",{"$f":"P4+P5+P6+Q5","v":529843.88820802805}]
[509,"Outside_levy_boundary",39.900709289300003,0,39.900709289300003,1,0,1,{"$f":"VLOOKUP($A12,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":1334.8297443500001},{"$f":"VLOOKUP($A12,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Buildout"},1334.8297443500001,0,null,null,"Planned (unlevied)",{"$f":"Q4","v":416991.43787445547}]
[512,"Outside_levy_boundary",31.377038626499999,0,31.377038626499999,1,0,1,{"$f":"VLOOKUP($A13,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":1338.46802435},{"$f":"VLOOKUP($A13,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Buildout"},1338.46802435,0,null,null,"Total Planned (levied + unlevied)",{"$f":"P11+P12","v":946835.32608248352}]
[513,"Outside_levy_boundary",41.367644278999997,0,41.367644278999997,1,0,1,{"$f":"VLOOKUP($A14,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":1657.5121980500001},{"$f":"VLOOKUP($A14,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Buildout"},1657.5121980500001,0,null,null,"Unplanned",{"$f":"P7+Q7","v":271607.23120320006}]
[514,"Outside_levy_boundary",98.308361614299997,0,98.308361614299997,1,0,1,{"$f":"VLOOKUP($A15,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":3717.3018521200001},{"$f":"VLOOKUP($A15,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Buildout"},3717.3018521200001,0]
[515,"Outside_levy_boundary",24.389566589099999,0,24.389566589099999,1,0,1,{"$f":"VLOOKUP($A16,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":0},{"$f":"VLOOKUP($A16,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Buildout"},0,0]
[516,"Outside_levy_boundary",63.539492959900002,0,63.539492959900002,1,0,1,{"$f":"VLOOKUP($A17,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":2281.3649386900001},{"$f":"VLOOKUP($A17,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Buildout"},2281.3649386900001,0]
[517,"Outside_levy_boundary",64.591204891900006,0,64.591204891900006,1,0,1,{"$f":"VLOOKUP($A18,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":3152.6075588099998},{"$f":"VLOOKUP($A18,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Buildout"},3152.6075588099998,0]
[518,"Outside_levy_boundary",14.996589118499999,0,14.996589118499999,1,0,1,{"$f":"VLOOKUP($A19,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":0},{"$f":"VLOOKUP($A19,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Buildout"},0,0]
[559,"Outside_levy_boundary",20.7982231035,0,20.7982231035,1,0,1,{"$f":"VLOOKUP($A20,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":954.06445082100004},{"$f":"VLOOKUP($A20,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Buildout"},954.06445082100004,0]
[560,"Outside_levy_boundary",7.1610392091400001,0,7.1610392091400001,1,0,1,{"$f":"VLOOKUP($A21,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":235.86966605000001},{"$f":"VLOOKUP($A21,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Buildout"},235.86966605000001,0]
[561,"Outside_levy_boundary",29.431048417,0,29.431048417,1,0,1,{"$f":"VLOOKUP($A22,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":1196.07628858},{"$f":"VLOOKUP($A22,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Buildout"},1196.07628858,0]
[562,"Outside_levy_boundary",19.579814364899999,0,19.579814364899999,1,0,1,{"$f":"VLOOKUP($A23,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":836.823159895},{"$f":"VLOOKUP($A23,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Buildout"},836.823159895,0]
[601,"Outside_levy_boundary",75.623756657200005,4.3941113834599997E-2,75.667697771034611,0.99941928834722094,5.807116527790084E-4,0.99999999999999989,{"$f":"VLOOKUP($A24,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":2648.6280000000002},{"$f":"VLOOKUP($A24,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},2647.0899108565231,1.5380891434767596]
[612,"Outside_levy_boundary",0,66.494144104499995,66.494144104499995,0,1,1,{"$f":"VLOOKUP($A25,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":3748.28},{"$f":"VLOOKUP($A25,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},0,3748.28]
[613,"Outside_levy_boundary",104.61016690300001,0,104.61016690300001,1,0,1,{"$f":"VLOOKUP($A26,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":4075.28015177},{"$f":"VLOOKUP($A26,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},4075.28015177,0]
[614,"Outside_levy_boundary",13.0516150381,0,13.0516150381,1,0,1,{"$f":"VLOOKUP($A27,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":259.404},{"$f":"VLOOKUP($A27,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},259.404,0]
[615,"Outside_levy_boundary",27.1789800359,41.031585214300001,68.210565250200005,0.39845704160647322,0.60154295839352667,0.99999999999999989,{"$f":"VLOOKUP($A28,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":2204.0839999999998},{"$f":"VLOOKUP($A28,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},878.23279009216185,1325.8512099078378]
[616,"Outside_levy_boundary",4.7635083660799999,0,4.7635083660799999,1,0,1,{"$f":"VLOOKUP($A29,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":0},{"$f":"VLOOKUP($A29,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},0,0]
[617,"Outside_levy_boundary",0,0,0,0,0,0,{"$f":"VLOOKUP($A30,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":0},{"$f":"VLOOKUP($A30,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Buildout"},0,0]
[618,"Outside_levy_boundary",52.247034023799998,0,52.247034023799998,1,0,1,{"$f":"VLOOKUP($A31,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":2557},{"$f":"VLOOKUP($A31,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},2557,0]
[619,"Outside_levy_boundary",63.951207935399999,2.68972914146,66.640937076859998,0.95963848559995768,4.0361514400042334E-2,1,{"$f":"VLOOKUP($A32,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":1649.67},{"$f":"VLOOKUP($A32,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},1583.0868205396823,66.583179460317837]
[620,"Outside_levy_boundary",63.147412271299999,4.2572319498700004,67.404644221170003,0.93684067323460596,6.3159326765393972E-2,0.99999999999999989,{"$f":"VLOOKUP($A33,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":2472.4250000000002},{"$f":"VLOOKUP($A33,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},2316.2683015220709,156.15669847792921]
[621,"Outside_levy_boundary",53.894653155599997,0,53.894653155599997,1,0,1,{"$f":"VLOOKUP($A34,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":1975},{"$f":"VLOOKUP($A34,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},1975,0]
[622,"Outside_levy_boundary",3.16423542212,0,3.16423542212,1,0,1,{"$f":"VLOOKUP($A35,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":21},{"$f":"VLOOKUP($A35,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Buildout"},21,0]
[623,"Outside_levy_boundary",53.611131980400003,3.0084400777599999E-2,53.641216381177607,0.99943915513466697,5.6084486533300242E-4,1,{"$f":"VLOOKUP($A36,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":2687},{"$f":"VLOOKUP($A36,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},2685.4930098468503,1.5069901531497776]
[624,"Outside_levy_boundary",63.0560694244,0,63.0560694244,1,0,1,{"$f":"VLOOKUP($A37,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":1914.0864845200001},{"$f":"VLOOKUP($A37,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},1914.0864845200001,0]
[625,"Outside_levy_boundary",105.52515203,9.0021797236199994,114.52733175362,0.92139710595034041,7.8602894049659519E-2,0.99999999999999989,{"$f":"VLOOKUP($A38,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":5115.933},{"$f":"VLOOKUP($A38,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},4713.805860435843,402.12713956415678]
[626,"Outside_levy_boundary",93.564260028500001,27.559989018469999,121.12424904696999,0.7724651402562448,0.22753485974375526,1,{"$f":"VLOOKUP($A39,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":8038.8140000000003},{"$f":"VLOOKUP($A39,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},6209.7035840038643,1829.1104159961362]
[627,"Outside_levy_boundary",94.5035975662,7.4439885090600004,101.94758607526001,0.92698219942584337,7.3017800574156605E-2,1,{"$f":"VLOOKUP($A40,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":3924.3820000000001},{"$f":"VLOOKUP($A40,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},3637.8322577471899,286.54974225280984]
[628,"Outside_levy_boundary",11.650410881599999,0,11.650410881599999,1,0,1,{"$f":"VLOOKUP($A41,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":15},{"$f":"VLOOKUP($A41,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},15,0]
[629,"Outside_levy_boundary",2.02944873538E-2,77.227839480399993,77.248133967753787,2.6271815656118844E-4,0.99973728184343891,1,{"$f":"VLOOKUP($A42,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":4268.7022400899996},{"$f":"VLOOKUP($A42,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},1.1214655834250604,4267.5807745065749]
[630,"Outside_levy_boundary",0,0,0,0,0,0,{"$f":"VLOOKUP($A43,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":0},{"$f":"VLOOKUP($A43,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},0,0]
[631,"Outside_levy_boundary",62.676627444200001,0,62.676627444200001,1,0,1,{"$f":"VLOOKUP($A44,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":2840},{"$f":"VLOOKUP($A44,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},2840,0]
[632,"Outside_levy_boundary",72.137253600500003,9.5978637958600004,81.73511739636001,0.88257356077049642,0.11742643922950347,0.99999999999999989,{"$f":"VLOOKUP($A45,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":3348},{"$f":"VLOOKUP($A45,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},2954.8562814596221,393.14371854037762]
[633,"Outside_levy_boundary",84.789015050000003,1.35673793486E-5,84.789028617379358,0.99999983998661646,1.6001338345111162E-7,0.99999999999999989,{"$f":"VLOOKUP($A46,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":813},{"$f":"VLOOKUP($A46,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},812.99986990911918,1.3009088074575375E-4]
[634,"Outside_levy_boundary",10.999150341,0,10.999150341,1,0,1,{"$f":"VLOOKUP($A47,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":280},{"$f":"VLOOKUP($A47,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},280,0]
[635,"Outside_levy_boundary",22.470901537500001,0,22.470901537500001,1,0,1,{"$f":"VLOOKUP($A48,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":1008},{"$f":"VLOOKUP($A48,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},1008,0]
[636,"Outside_levy_boundary",32.2962999497,3.6805018728100001E-3,32.299980451572807,0.99988605250463458,1.1394749536545873E-4,1,{"$f":"VLOOKUP($A49,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":1634.1389999999999},{"$f":"VLOOKUP($A49,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},1633.9527939538709,0.18620604612901537]
[637,"Outside_levy_boundary",21.402537743900002,11.601850627999999,33.004388371899999,0.64847551491431865,0.35152448508568146,1,{"$f":"VLOOKUP($A50,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":921.90499999999997},{"$f":"VLOOKUP($A50,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},597.83281957708493,324.07218042291515]
[638,"Outside_levy_boundary",37.9320693385,5.60487927457,43.536948613070003,0.87126155017470863,0.12873844982529134,1,{"$f":"VLOOKUP($A51,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":1304.2270000000001},{"$f":"VLOOKUP($A51,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},1136.3228377997098,167.90416220029027]
[639,"Outside_levy_boundary",29.176483276999999,21.981367988300001,51.157851265299996,0.57032268860733404,0.42967731139266602,1,{"$f":"VLOOKUP($A52,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":3904.776104},{"$f":"VLOOKUP($A52,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},2226.982406042951,1677.7936979570493]
[640,"Outside_levy_boundary",42.983492474099997,3.2506742056400002,46.234166679739999,0.92969108261089384,7.0308917389106065E-2,0.99999999999999989,{"$f":"VLOOKUP($A53,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":2162.5540000000001},{"$f":"VLOOKUP($A53,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},2010.5071694645189,152.04683053548089]
[641,"Outside_levy_boundary",19.628163319399999,0.62658628057599997,20.254749599975998,0.96906472343767003,3.0935276562329975E-2,1,{"$f":"VLOOKUP($A54,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":276.83499999999998},{"$f":"VLOOKUP($A54,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},268.27103271286734,8.563967287132618]
[642,"Outside_levy_boundary",32.575274133500002,1.688382316,34.263656449500004,0.9507238137736862,4.9276186226313794E-2,1,{"$f":"VLOOKUP($A55,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":822.755},{"$f":"VLOOKUP($A55,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},782.2127714013692,40.542228598630807]
[643,"Outside_levy_boundary",31.095116439600002,0,31.095116439600002,1,0,1,{"$f":"VLOOKUP($A56,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":1411},{"$f":"VLOOKUP($A56,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},1411,0]
[644,"Outside_levy_boundary",33.972510640099998,0,33.972510640099998,1,0,1,{"$f":"VLOOKUP($A57,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":1451},{"$f":"VLOOKUP($A57,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},1451,0]
[1001,"Outside_levy_boundary",0,126.73017510299999,126.73017510299999,0,1,1,{"$f":"VLOOKUP($A58,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":8178.1670077700001},{"$f":"VLOOKUP($A58,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Unplanned"},0,8178.1670077700001]
[1002,"Outside_levy_boundary",0,118.09008555299999,118.09008555299999,0,1,1,{"$f":"VLOOKUP($A59,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":6949.1415481900003},{"$f":"VLOOKUP($A59,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Unplanned"},0,6949.1415481900003]
[1003,"Outside_levy_boundary",0,121.326432192,121.326432192,0,1,1,{"$f":"VLOOKUP($A60,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":7211.0383142399996},{"$f":"VLOOKUP($A60,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Unplanned"},0,7211.0383142399996]
[1004,"Outside_levy_boundary",0,114.02507927800001,114.02507927800001,0,1,1,{"$f":"VLOOKUP($A61,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":7789.0605664499999},{"$f":"VLOOKUP($A61,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Unplanned"},0,7789.0605664499999]
[1005,"Outside_levy_boundary",0,34.759155930354872,34.759155930354872,0,1,1,{"$f":"VLOOKUP($A62,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":2490.1303059799998},{"$f":"VLOOKUP($A62,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Unplanned"},0,2490.1303059799998]
[1006,"Outside_levy_boundary",0,27.808718550365242,27.808718550365242,0,1,1,{"$f":"VLOOKUP($A63,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":2693.3582974400001},{"$f":"VLOOKUP($A63,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},0,2693.3582974400001]
[1007,"Outside_levy_boundary",0,31.193446517371825,31.193446517371825,0,1,1,{"$f":"VLOOKUP($A64,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":2263.2337212699999},{"$f":"VLOOKUP($A64,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},0,2263.2337212699999]
[1008,"Outside_levy_boundary",0,134.44353079836728,134.44353079836728,0,1,1,{"$f":"VLOOKUP($A65,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":7893.2528830299998},{"$f":"VLOOKUP($A65,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Unplanned"},0,7893.2528830299998]
[1009,"Outside_levy_boundary",0,32.691503054423194,32.691503054423194,0,1,1,{"$f":"VLOOKUP($A66,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":0},{"$f":"VLOOKUP($A66,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},0,0]
[1010,"Outside_levy_boundary",0,82.76385998341641,82.76385998341641,0,1,1,{"$f":"VLOOKUP($A67,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":7062.0197725600001},{"$f":"VLOOKUP($A67,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},0,7062.0197725600001]
[1011,"Outside_levy_boundary",0,46.704274734799995,46.704274734799995,0,1,1,{"$f":"VLOOKUP($A68,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":3},{"$f":"VLOOKUP($A68,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},0,3]
[1012,"Outside_levy_boundary",0,88.011230889227036,88.011230889227036,0,1,1,{"$f":"VLOOKUP($A69,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":6897.3171867900001},{"$f":"VLOOKUP($A69,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},{"$f":"$I69*F69","v":0},6897.3171867900001]
[1013,"Outside_levy_boundary",0,0,0,0,0,0,{"$f":"VLOOKUP($A70,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":3},{"$f":"VLOOKUP($A70,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Buildout"},0,0]
[1014,"Outside_levy_boundary",0,55.159640707000001,55.159640707000001,0,1,1,{"$f":"VLOOKUP($A71,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":2},{"$f":"VLOOKUP($A71,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},0,2]
[1015,"Outside_levy_boundary",0,78.571244165293834,78.571244165293834,0,1,1,{"$f":"VLOOKUP($A72,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":4},{"$f":"VLOOKUP($A72,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},0,4]
[1016,"Outside_levy_boundary",36.782636614899999,52.060596593360003,88.843233208260003,0.41401731214212739,0.58598268785787266,1,{"$f":"VLOOKUP($A73,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":4848.9318219999996},{"$f":"VLOOKUP($A73,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},2007.5417197048682,2841.3901022951313]
[1036,"Outside_levy_boundary",0,65.647427018656089,65.647427018656089,0,1,1,{"$f":"VLOOKUP($A74,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":5820.1306206099998},{"$f":"VLOOKUP($A74,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},0,5820.1306206099998]
[1068,"Outside_levy_boundary",0,39.197993055600001,39.197993055600001,0,1,1,{"$f":"VLOOKUP($A75,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":2676.8427518200001},{"$f":"VLOOKUP($A75,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Unplanned"},0,2676.8427518200001]
[1101,"Outside_levy_boundary",115.567849958,14.926095478000001,130.49394543599999,0.88561848269565568,0.11438151730434436,1,{"$f":"VLOOKUP($A76,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":2189},{"$f":"VLOOKUP($A76,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},1938.6188586207902,250.38114137920979]
[1102,"Outside_levy_boundary",38.066285442500003,0,38.066285442500003,1,0,1,{"$f":"VLOOKUP($A77,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":1681},{"$f":"VLOOKUP($A77,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},1681,0]
[1103,"Outside_levy_boundary",45.657651241700002,0,45.657651241700002,1,0,1,{"$f":"VLOOKUP($A78,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":1702},{"$f":"VLOOKUP($A78,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},1702,0]
[1104,"Outside_levy_boundary",69.646123585500007,0,69.646123585500007,1,0,1,{"$f":"VLOOKUP($A79,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":3232},{"$f":"VLOOKUP($A79,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},3232,0]
[1105,"Outside_levy_boundary",59.529220851399998,0,59.529220851399998,1,0,1,{"$f":"VLOOKUP($A80,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":2412},{"$f":"VLOOKUP($A80,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},2412,0]
[1106,"Outside_levy_boundary",24.877641025999999,0,24.877641025999999,1,0,1,{"$f":"VLOOKUP($A81,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":1438},{"$f":"VLOOKUP($A81,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},1438,0]
[1107,"Outside_levy_boundary",1.12589904633,2.3117743146199999E-5,1.1259221640731463,0.99997946772531543,2.0532274684574144E-5,1,{"$f":"VLOOKUP($A82,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":0},{"$f":"VLOOKUP($A82,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},0,0]
[1108,"Outside_levy_boundary",113.049420621,0,113.049420621,1,0,1,{"$f":"VLOOKUP($A83,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":5237.0940000000001},{"$f":"VLOOKUP($A83,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},5237.0940000000001,0]
[1109,"Outside_levy_boundary",46.6148227073,116.601553075,163.21637578229999,0.28560138334082008,0.71439861665918003,1,{"$f":"VLOOKUP($A84,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":9877.4795028200006},{"$f":"VLOOKUP($A84,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},2821.0218099259878,7056.4576928940141]
[1110,"Outside_levy_boundary",2.1037637409899999,4.3203267171478901,6.4240904581378899,0.32748040437771242,0.67251959562228758,1,{"$f":"VLOOKUP($A85,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":0},{"$f":"VLOOKUP($A85,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},0,0]
[1111,"Outside_levy_boundary",96.674831606400005,0,96.674831606400005,1,0,1,{"$f":"VLOOKUP($A86,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":7726.1840000000002},{"$f":"VLOOKUP($A86,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},7726.1840000000002,0]
[1117,"Outside_levy_boundary",32.438802515799999,0,32.438802515799999,1,0,1,{"$f":"VLOOKUP($A87,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":1337.6},{"$f":"VLOOKUP($A87,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},1337.6,0]
[1118,"Outside_levy_boundary",72.782532392899995,2.9207461855500001,75.703278578449996,0.96141849811004843,3.8581501889951589E-2,1,{"$f":"VLOOKUP($A88,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":4919.93},{"$f":"VLOOKUP($A88,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},4730.111711406571,189.81828859342954]
[1119,"Outside_levy_boundary",87.301256403400004,60.110761243399999,147.4120176468,0.59222618207814159,0.40777381792185841,1,{"$f":"VLOOKUP($A89,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":6901.3692930200004},{"$f":"VLOOKUP($A89,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},4087.1715875165582,2814.1977055034422]
[1120,"Outside_levy_boundary",12.2017190744,0,12.2017190744,1,0,1,{"$f":"VLOOKUP($A90,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":606.1},{"$f":"VLOOKUP($A90,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},606.1,0]
[1121,"Outside_levy_boundary",0,51.541175123544001,51.541175123544001,0,1,1,{"$f":"VLOOKUP($A91,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":3163.3687524299999},{"$f":"VLOOKUP($A91,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Unplanned"},0,3163.3687524299999]
[1122,"Outside_levy_boundary",0,101.8494232537718,101.8494232537718,0,1,1,{"$f":"VLOOKUP($A92,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":6552.4740798599996},{"$f":"VLOOKUP($A92,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Unplanned"},0,6552.4740798599996]
[1123,"Outside_levy_boundary",0,91.418503521800091,91.418503521800091,0,1,1,{"$f":"VLOOKUP($A93,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":8043.1709067199999},{"$f":"VLOOKUP($A93,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},0,8043.1709067199999]
[1124,"Outside_levy_boundary",20.5535357312,47.323467423700002,67.877003154899995,0.30280558622034942,0.69719441377965063,1,{"$f":"VLOOKUP($A94,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":3449.4986752300001},{"$f":"VLOOKUP($A94,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},1044.527468519339,2404.9712067106616]
[1201,"Outside_levy_boundary",76.834233414899998,11.033412884800001,87.867646299699999,0.87443145060279515,0.12556854939720483,1,{"$f":"VLOOKUP($A95,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":4348.7139999999999},{"$f":"VLOOKUP($A95,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},3802.6522912766836,546.0617087233162]
[1202,"Outside_levy_boundary",0,19.523862195500001,19.523862195500001,0,1,1,{"$f":"VLOOKUP($A96,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":0},{"$f":"VLOOKUP($A96,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},0,0]
[1203,"Outside_levy_boundary",0,37.7662644993,37.7662644993,0,1,1,{"$f":"VLOOKUP($A97,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":0},{"$f":"VLOOKUP($A97,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},0,0]
[1204,"Outside_levy_boundary",0,40.137233795999997,40.137233795999997,0,1,1,{"$f":"VLOOKUP($A98,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":6978.1060155699997},{"$f":"VLOOKUP($A98,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},0,6978.1060155699997]
[1205,"Outside_levy_boundary",109.19481596200001,1.07639219364E-2,109.20557988393641,0.99990143432278977,9.8565677210266057E-5,1,{"$f":"VLOOKUP($A99,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":5043},{"$f":"VLOOKUP($A99,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},5042.5029332898284,0.49706671017137172]
[1210,"Outside_levy_boundary",9.9506051411200003E-2,60.013466897500003,60.112972948911199,1.6553174220108558E-3,0.99834468257798914,1,{"$f":"VLOOKUP($A100,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":3026.5980849500002},{"$f":"VLOOKUP($A100,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},5.0099805394424273,3021.5881044105577]
[1211,"Outside_levy_boundary",3.1353356808499999,60.414407368900001,63.549743049749999,4.9336716883268877E-2,0.95066328311673109,1,{"$f":"VLOOKUP($A101,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":4777.7523518999997},{"$f":"VLOOKUP($A101,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},235.7186151240623,4542.0337367759375]
[1212,"Outside_levy_boundary",55.606148364100001,10.6219369518,66.228085315900003,0.83961582308872984,0.16038417691127016,1,{"$f":"VLOOKUP($A102,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":3245.2695274600001},{"$f":"VLOOKUP($A102,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},2724.7796454431013,520.48988201689872]
[1213,"Outside_levy_boundary",0,50.2104249012,50.2104249012,0,1,1,{"$f":"VLOOKUP($A103,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":0},{"$f":"VLOOKUP($A103,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},0,0]
[1214,"Outside_levy_boundary",0,63.670430359599997,63.670430359599997,0,1,1,{"$f":"VLOOKUP($A104,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":44},{"$f":"VLOOKUP($A104,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Unplanned"},0,44]
[1216,"Outside_levy_boundary",71.035140682399998,126.408909936,197.44405061840001,0.35977351791515649,0.64022648208484345,1,{"$f":"VLOOKUP($A105,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":12037.424291400001},{"$f":"VLOOKUP($A105,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},4330.7464839543381,7706.6778074456615]
[1241,"Outside_levy_boundary",0,49.006498201900001,49.006498201900001,0,1,1,{"$f":"VLOOKUP($A106,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":0},{"$f":"VLOOKUP($A106,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Unplanned"},0,0]
[1242,"Outside_levy_boundary",0,20.317184665916688,20.317184665916688,0,1,1,{"$f":"VLOOKUP($A107,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":2199.30886599},{"$f":"VLOOKUP($A107,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},0,2199.30886599]
[1243,"Outside_levy_boundary",0,10.683219879882801,10.683219879882801,0,1,1,{"$f":"VLOOKUP($A108,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":1148.3463068200001},{"$f":"VLOOKUP($A108,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},0,1148.3463068200001]
[1244,"Outside_levy_boundary",0,24.580969979900001,24.580969979900001,0,1,1,{"$f":"VLOOKUP($A109,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":0},{"$f":"VLOOKUP($A109,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},0,0]
[1245,"Outside_levy_boundary",9.3432724926000006,16.8673239349,26.210596427500001,0.35646928212580065,0.64353071787419935,1,{"$f":"VLOOKUP($A110,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":1000.49692309},{"$f":"VLOOKUP($A110,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},356.64641994296466,643.85050314703528]
[1246,"Outside_levy_boundary",1.9611117014099999,38.067440946799998,40.028552648209995,4.8992820665917765E-2,0.9510071793340823,1,{"$f":"VLOOKUP($A111,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":1783.4128333900001},{"$f":"VLOOKUP($A111,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},87.37442511957255,1696.0384082704277]
[1247,"Outside_levy_boundary",0.55320214525699996,17.114560592299998,17.667762737556998,3.1311386363653063E-2,0.96868861363634695,1,{"$f":"VLOOKUP($A112,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":2368.88},{"$f":"VLOOKUP($A112,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},74.172916929130466,2294.7070830708699]
[1248,"Outside_levy_boundary",0,67.908205870299994,67.908205870299994,0,1,1,{"$f":"VLOOKUP($A113,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":6},{"$f":"VLOOKUP($A113,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Unplanned"},0,6]
[1249,"Outside_levy_boundary",24.072788224500002,29.141045375200001,53.213833599700003,0.45237838727401353,0.54762161272598642,1,{"$f":"VLOOKUP($A114,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":2822.6876514099999},{"$f":"VLOOKUP($A114,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},1276.9228875231286,1545.7647638868712]
[1250,"Outside_levy_boundary",0,50.112485419599999,50.112485419599999,0,1,1,{"$f":"VLOOKUP($A115,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":2115.4259059800002},{"$f":"VLOOKUP($A115,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},0,2115.4259059800002]
[1251,"Outside_levy_boundary",1.68664790904E-2,52.897019325599999,52.913885804690402,3.1875336377025103E-4,0.9996812466362297,1,{"$f":"VLOOKUP($A116,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":3473.7878128799998},{"$f":"VLOOKUP($A116,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},1.1072815503796032,3472.68053132962]
[1252,"Outside_levy_boundary",41.5147252115,19.9613330896,61.476058301099997,0.6752990734729194,0.32470092652708071,1,{"$f":"VLOOKUP($A117,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":3515.2001840200001},{"$f":"VLOOKUP($A117,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},2373.8114273405417,1141.3887566794585]
[1301,"Outside_levy_boundary",0,250.84056015900001,250.84056015900001,0,1,1,{"$f":"VLOOKUP($A118,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":16627.647043199999},{"$f":"VLOOKUP($A118,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Unplanned"},0,16627.647043199999]
[1302,"Outside_levy_boundary",0,215.06941924099999,215.06941924099999,0,1,1,{"$f":"VLOOKUP($A119,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":17749.9397341},{"$f":"VLOOKUP($A119,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Unplanned"},0,17749.9397341]
[1303,"Outside_levy_boundary",117.755836755,0,117.755836755,1,0,1,{"$f":"VLOOKUP($A120,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":6545.5339999999997},{"$f":"VLOOKUP($A120,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},6545.5339999999997,0]
[1304,"Outside_levy_boundary",88.052147026900002,2.6220856436600002,90.674232670560002,0.97108235089028405,2.8917649109715993E-2,1,{"$f":"VLOOKUP($A121,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":4505.6149638099996},{"$f":"VLOOKUP($A121,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},4375.3231712630568,130.2917925469433]
[1305,"Outside_levy_boundary",48.243120087999998,0,48.243120087999998,1,0,1,{"$f":"VLOOKUP($A122,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":2954},{"$f":"VLOOKUP($A122,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},2954,0]
[1306,"Outside_levy_boundary",94.9187206231,0,94.9187206231,1,0,1,{"$f":"VLOOKUP($A123,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":4694},{"$f":"VLOOKUP($A123,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},4694,0]
[1307,"Outside_levy_boundary",53.595931355899999,0,53.595931355899999,1,0,1,{"$f":"VLOOKUP($A124,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":2970},{"$f":"VLOOKUP($A124,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Community Plan"},2970,0]
[1308,"Outside_levy_boundary",102.102777719,0,102.102777719,1,0,1,{"$f":"VLOOKUP($A125,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":4806},{"$f":"VLOOKUP($A125,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Buildout"},4806,0]
[1309,"Outside_levy_boundary",92.689544139000006,0,92.689544139000006,1,0,1,{"$f":"VLOOKUP($A126,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":3992},{"$f":"VLOOKUP($A126,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Community Plan"},3992,0]
[1310,"Outside_levy_boundary",26.7599144693,0,26.7599144693,1,0,1,{"$f":"VLOOKUP($A127,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":1329},{"$f":"VLOOKUP($A127,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},1329,0]
[1311,"Outside_levy_boundary",35.536859581000002,0,35.536859581000002,1,0,1,{"$f":"VLOOKUP($A128,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":1621},{"$f":"VLOOKUP($A128,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},1621,0]
[1312,"Outside_levy_boundary",30.654854408999999,14.746601741699999,45.4014561507,0.6751954013820185,0.32480459861798144,1,{"$f":"VLOOKUP($A129,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":2856.8490000000002},{"$f":"VLOOKUP($A129,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},1928.9313072428183,927.91769275718173]
[1313,"Outside_levy_boundary",43.592435524700001,45.644933021699998,89.237368546400006,0.48849978697022656,0.51150021302977333,0.99999999999999989,{"$f":"VLOOKUP($A130,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":4414.0559102200004},{"$f":"VLOOKUP($A130,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},2156.2653718171396,2257.7905384028604]
[1314,"Outside_levy_boundary",0,243.43522793,243.43522793,0,1,1,{"$f":"VLOOKUP($A131,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":16250.01058},{"$f":"VLOOKUP($A131,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Unplanned"},0,16250.01058]
[1315,"Outside_levy_boundary",0,248.83778175349465,248.83778175349465,0,1,1,{"$f":"VLOOKUP($A132,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":16823.872077600001},{"$f":"VLOOKUP($A132,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Unplanned"},0,16823.872077600001]
[1316,"Outside_levy_boundary",94.8529603546,42.238867276800001,137.09182763140001,0.69189361607777222,0.30810638392222772,1,{"$f":"VLOOKUP($A133,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":7282.08120383},{"$f":"VLOOKUP($A133,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},{"$f":"$I133*F133","v":5038.4254966899152},2243.6557071400844]
[1317,"Outside_levy_boundary",14.1637213079,49.759826877489999,63.923548185389997,0.22157282738471609,0.77842717261528394,1,{"$f":"VLOOKUP($A134,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":4532.0604425399997},{"$f":"VLOOKUP($A134,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},1004.1814461320154,3527.8789964079842]
[1318,"Outside_levy_boundary",66.309897896400003,1.5968342373539002,67.906732133753906,0.97648489056712862,2.3515109432871287E-2,0.99999999999999989,{"$f":"VLOOKUP($A135,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":815},{"$f":"VLOOKUP($A135,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},795.83518581220983,19.1648141877901]
[1319,"Outside_levy_boundary",0.72252032317799997,61.494228586139997,62.216748909318,1.1612955286864731E-2,0.98838704471313521,0.99999999999999989,{"$f":"VLOOKUP($A136,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":3736.3777244799999},{"$f":"VLOOKUP($A136,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},43.390387449223631,3692.987337030776]
[1320,"Outside_levy_boundary",22.422929123399999,0,22.422929123399999,1,0,1,{"$f":"VLOOKUP($A137,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":39},{"$f":"VLOOKUP($A137,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},39,0]
[1321,"Outside_levy_boundary",20.330064750599998,0,20.330064750599998,1,0,1,{"$f":"VLOOKUP($A138,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":0},{"$f":"VLOOKUP($A138,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},0,0]
[1322,"Outside_levy_boundary",121.032758539,0,121.032758539,1,0,1,{"$f":"VLOOKUP($A139,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":6415.04},{"$f":"VLOOKUP($A139,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Community Plan"},6415.04,0]
[1323,"Outside_levy_boundary",21.048318570999999,36.646971162269999,57.695289733270002,0.36481866489115627,0.63518133510884367,1,{"$f":"VLOOKUP($A140,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":3760.9270200699998},{"$f":"VLOOKUP($A140,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},1372.0563742150123,2388.8706458549873]
[1324,"Outside_levy_boundary",107.980244188,2.2361857638900002E-3,107.98248037376389,0.9999792912169071,2.0708783092866593E-5,1,{"$f":"VLOOKUP($A141,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":4807.6655909999999},{"$f":"VLOOKUP($A141,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Community Plan"},4807.5660300960926,9.9560903907057269E-2]
[1325,"Outside_levy_boundary",41.239248908999997,7.6309250678399998,48.870173976839993,0.84385312253121181,0.15614687746878828,1,{"$f":"VLOOKUP($A142,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":2621.3549835399999},{"$f":"VLOOKUP($A142,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},2212.0385881229822,409.31639541701787]
[1326,"Outside_levy_boundary",25.114906020199999,107.62747998499999,132.74238600519999,0.18920035096563775,0.8107996490343623,1,{"$f":"VLOOKUP($A143,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":8458.5453855300002},{"$f":"VLOOKUP($A143,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},1600.3597556010518,6858.1856299289493]
[1327,"Outside_levy_boundary",7.1949740259999997,206.71162140800001,213.90659543400002,3.3636055080031313E-2,0.96636394491996869,1,{"$f":"VLOOKUP($A144,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":13029.540824},{"$f":"VLOOKUP($A144,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},438.26235282358056,12591.27847117642]
[1328,"Outside_levy_boundary",0,77.767859544000004,77.767859544000004,0,1,1,{"$f":"VLOOKUP($A145,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":4297.6914483299997},{"$f":"VLOOKUP($A145,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},0,4297.6914483299997]
[1329,"Outside_levy_boundary",2.3105106466400001,127.804248072316,130.11475871895601,1.7757483235477031E-2,0.9822425167645229,0.99999999999999989,{"$f":"VLOOKUP($A146,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":6997.4784658299995},{"$f":"VLOOKUP($A146,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},124.25760654758776,6873.2208592824118]
[1330,"Outside_levy_boundary",16.453162934600002,119.24379240967893,135.69695534427893,0.1212493153796739,0.87875068462032613,1,{"$f":"VLOOKUP($A147,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":7401.8569570700001},{"$f":"VLOOKUP($A147,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},897.47008858301388,6504.3868684869867]
[1331,"Outside_levy_boundary",0,275.9182959518111,275.9182959518111,0,1,1,{"$f":"VLOOKUP($A148,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":17909.870354300001},{"$f":"VLOOKUP($A148,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Unplanned"},0,17909.870354300001]
[1332,"Outside_levy_boundary",0,215.69678854899999,215.69678854899999,0,1,1,{"$f":"VLOOKUP($A149,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":13824.979799700001},{"$f":"VLOOKUP($A149,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Unplanned"},0,13824.979799700001]
[1333,"Outside_levy_boundary",36.2408396911,0,36.2408396911,1,0,1,{"$f":"VLOOKUP($A150,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":2919.9552972800002},{"$f":"VLOOKUP($A150,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},2919.9552972800002,0]
[1334,"Outside_levy_boundary",22.6512932445,27.688095988699999,50.339389233199995,0.44997155487061308,0.55002844512938698,1,{"$f":"VLOOKUP($A151,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":3731.2268577300001},{"$f":"VLOOKUP($A151,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},1678.94595074776,2052.2809069822401]
[1335,"Outside_levy_boundary",23.274861417499999,10.5244692628,33.799330680300002,0.68861900366168471,0.31138099633831523,1,{"$f":"VLOOKUP($A152,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":0},{"$f":"VLOOKUP($A152,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},0,0]
[1336,"Outside_levy_boundary",29.3399704353,0,29.3399704353,1,0,1,{"$f":"VLOOKUP($A153,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":1576.87},{"$f":"VLOOKUP($A153,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},1576.87,0]
[1337,"Outside_levy_boundary",30.1921790504,0,30.1921790504,1,0,1,{"$f":"VLOOKUP($A154,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":1163},{"$f":"VLOOKUP($A154,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},1163,0]
[1338,"Outside_levy_boundary",31.366308323999998,0,31.366308323999998,1,0,1,{"$f":"VLOOKUP($A155,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":1450.9780000000001},{"$f":"VLOOKUP($A155,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},1450.9780000000001,0]
[1339,"Outside_levy_boundary",33.902837544800001,0,33.902837544800001,1,0,1,{"$f":"VLOOKUP($A156,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":2795},{"$f":"VLOOKUP($A156,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},2795,0]
[1421,"Outside_levy_boundary",45.380567166500001,0,45.380567166500001,1,0,1,{"$f":"VLOOKUP($A157,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":2614},{"$f":"VLOOKUP($A157,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},2614,0]
[1422,"Outside_levy_boundary",18.792167969099999,0,18.792167969099999,1,0,1,{"$f":"VLOOKUP($A158,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":1019},{"$f":"VLOOKUP($A158,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},1019,0]
[1423,"Outside_levy_boundary",65.181391845199997,0,65.181391845199997,1,0,1,{"$f":"VLOOKUP($A159,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":2608},{"$f":"VLOOKUP($A159,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},2608,0]
[1424,"Outside_levy_boundary",30.181270995599998,0,30.181270995599998,1,0,1,{"$f":"VLOOKUP($A160,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":1995},{"$f":"VLOOKUP($A160,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},1995,0]
[1425,"Outside_levy_boundary",32.535656857699998,0,32.535656857699998,1,0,1,{"$f":"VLOOKUP($A161,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":2221},{"$f":"VLOOKUP($A161,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},2221,0]
[1426,"Outside_levy_boundary",94.695128171099995,0,94.695128171099995,1,0,1,{"$f":"VLOOKUP($A162,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":4352.1480000000001},{"$f":"VLOOKUP($A162,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},4352.1480000000001,0]
[1427,"Outside_levy_boundary",23.5120517943,0,23.5120517943,1,0,1,{"$f":"VLOOKUP($A163,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":1207},{"$f":"VLOOKUP($A163,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},1207,0]
[1428,"Outside_levy_boundary",17.2774533274,0,17.2774533274,1,0,1,{"$f":"VLOOKUP($A164,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":410.24200000000002},{"$f":"VLOOKUP($A164,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Buildout"},410.24200000000002,0]
[1429,"Outside_levy_boundary",57.091269178399997,0,57.091269178399997,1,0,1,{"$f":"VLOOKUP($A165,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":3617},{"$f":"VLOOKUP($A165,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},3617,0]
[1430,"Outside_levy_boundary",51.700773731600002,0,51.700773731600002,1,0,1,{"$f":"VLOOKUP($A166,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":3143},{"$f":"VLOOKUP($A166,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},3143,0]
[1431,"Outside_levy_boundary",8.9910431052299997E-2,123.568286102,123.6581965330523,7.2708832550592839E-4,0.99927291167449406,1,{"$f":"VLOOKUP($A167,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":4227.4943999999996},{"$f":"VLOOKUP($A167,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},3.0737618243816893,4224.4206381756176]
[1432,"Outside_levy_boundary",13.3818458349,179.9680487139444,193.34989454884439,6.9210515299864592E-2,0.93078948470013545,1,{"$f":"VLOOKUP($A168,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":12559.0202715},{"$f":"VLOOKUP($A168,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},869.21626465196027,11689.80400684804]
[1433,"Outside_levy_boundary",0,219.5956971486824,219.5956971486824,0,1,1,{"$f":"VLOOKUP($A169,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":15747.3095125},{"$f":"VLOOKUP($A169,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Unplanned"},0,15747.3095125]
[1435,"Outside_levy_boundary",0.114527570868,7.0381138198600004,7.1526413907280002,1.6011926868927412E-2,0.98398807313107262,1,{"$f":"VLOOKUP($A170,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":0},{"$f":"VLOOKUP($A170,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Buildout"},0,0]
[1436,"Outside_levy_boundary",18.287580663,0,18.287580663,1,0,1,{"$f":"VLOOKUP($A171,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":0},{"$f":"VLOOKUP($A171,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},0,0]
[1440,"Outside_levy_boundary",25.766943992400002,0,25.766943992400002,1,0,1,{"$f":"VLOOKUP($A172,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":1190},{"$f":"VLOOKUP($A172,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},1190,0]
[1442,"Outside_levy_boundary",27.262053201099999,0,27.262053201099999,1,0,1,{"$f":"VLOOKUP($A173,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":1645},{"$f":"VLOOKUP($A173,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},1645,0]
[1443,"Outside_levy_boundary",16.6090510123,0,16.6090510123,1,0,1,{"$f":"VLOOKUP($A174,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":0},{"$f":"VLOOKUP($A174,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},0,0]
[1444,"Outside_levy_boundary",13.3102059922,0,13.3102059922,1,0,1,{"$f":"VLOOKUP($A175,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":1001},{"$f":"VLOOKUP($A175,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},1001,0]
[1529,"Outside_levy_boundary",59.775843811900003,0,59.775843811900003,1,0,1,{"$f":"VLOOKUP($A176,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":135.32482661099999},{"$f":"VLOOKUP($A176,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},135.32482661099999,0]
[1530,"Outside_levy_boundary",16.864115900800002,36.929726819199999,53.793842720000001,0.31349528213811906,0.68650471786188094,1,{"$f":"VLOOKUP($A177,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":0},{"$f":"VLOOKUP($A177,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},0,0]
[1531,"Outside_levy_boundary",1.24885844804,9.4309777348400008,10.679836182880001,0.11693610525992393,0.88306389474007607,1,{"$f":"VLOOKUP($A178,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":0},{"$f":"VLOOKUP($A178,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},0,0]
[1532,"Outside_levy_boundary",32.766865381199999,16.29112150976,49.057986890959995,0.66792111657639197,0.33207888342360814,1,{"$f":"VLOOKUP($A179,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":172.06459854100001},{"$f":"VLOOKUP($A179,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},114.92557878077335,57.139019760226674]
[1533,"Outside_levy_boundary",62.018003842100001,2.6831770708899998,64.701180912989997,0.9585297048210244,4.1470295178975637E-2,1,{"$f":"VLOOKUP($A180,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":0},{"$f":"VLOOKUP($A180,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},0,0]
[1534,"Outside_levy_boundary",42.245602218999998,16.3260590587,58.571661277700002,0.72126351374438769,0.2787364862556122,0.99999999999999989,{"$f":"VLOOKUP($A181,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":0},{"$f":"VLOOKUP($A181,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},0,0]
[1536,"Outside_levy_boundary",87.134217896699994,2.04742580595E-4,87.134422639280587,0.99999765026754761,2.3497324523810082E-6,1,{"$f":"VLOOKUP($A182,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":0},{"$f":"VLOOKUP($A182,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},0,0]
[1537,"Outside_levy_boundary",0.47091765800000002,0,0.47091765800000002,1,0,1,{"$f":"VLOOKUP($A183,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":0},{"$f":"VLOOKUP($A183,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},0,0]
[1538,"Outside_levy_boundary",1.20111593196,19.547464795,20.74858072696,5.7889064691509756E-2,0.94211093530849022,1,{"$f":"VLOOKUP($A184,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":0},{"$f":"VLOOKUP($A184,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Buildout"},0,0]
[1539,"Outside_levy_boundary",80.718576435100005,3.5938304181,84.312406853200002,0.9573748330496914,4.2625166950308685E-2,1,{"$f":"VLOOKUP($A185,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":0},{"$f":"VLOOKUP($A185,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},0,0]
[1540,"Outside_levy_boundary",73.453449762399998,0,73.453449762399998,1,0,1,{"$f":"VLOOKUP($A186,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":0},{"$f":"VLOOKUP($A186,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},0,0]
[1541,"Outside_levy_boundary",12.618328588900001,9.0079321105299996,21.626260699429999,0.58347250892210789,0.41652749107789222,1,{"$f":"VLOOKUP($A187,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":0},{"$f":"VLOOKUP($A187,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},0,0]
[1542,"Outside_levy_boundary",0.26505201526599997,0,0.26505201526599997,1,0,1,{"$f":"VLOOKUP($A188,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":0},{"$f":"VLOOKUP($A188,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},0,0]
[1544,"Outside_levy_boundary",0,12.214097542599999,12.214097542599999,0,1,1,{"$f":"VLOOKUP($A189,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":0},{"$f":"VLOOKUP($A189,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Buildout"},0,0]
[1545,"Outside_levy_boundary",0,27.735705138699998,27.735705138699998,0,1,1,{"$f":"VLOOKUP($A190,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":0},{"$f":"VLOOKUP($A190,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},0,0]
[1546,"Outside_levy_boundary",0,19.4989674626,19.4989674626,0,1,1,{"$f":"VLOOKUP($A191,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":2},{"$f":"VLOOKUP($A191,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},0,2]
[1547,"Outside_levy_boundary",0,5.7708457963939992,5.7708457963939992,0,1,1,{"$f":"VLOOKUP($A192,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":0},{"$f":"VLOOKUP($A192,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},0,0]
[1548,"Outside_levy_boundary",0,71.120435508220012,71.120435508220012,0,1,1,{"$f":"VLOOKUP($A193,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":2973.5243999999998},{"$f":"VLOOKUP($A193,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},0,2973.5243999999998]
[1632,"Outside_levy_boundary",8.2635924622400001,0.74416534941300005,9.0077578116530006,0.91738617256668453,8.261382743331544E-2,1,{"$f":"VLOOKUP($A194,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":178.187893863},{"$f":"VLOOKUP($A194,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Buildout"},163.46710994869619,14.720783914303809]
[1633,"Outside_levy_boundary",35.0059889662,0,35.0059889662,1,0,1,{"$f":"VLOOKUP($A195,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":0},{"$f":"VLOOKUP($A195,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},0,0]
[1634,"Outside_levy_boundary",0.59368369217500006,0,0.59368369217500006,1,0,1,{"$f":"VLOOKUP($A196,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":0},{"$f":"VLOOKUP($A196,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},0,0]
[1635,"Outside_levy_boundary",2.2515448193099998,17.5816098529504,19.833154672260399,0.11352429084108936,0.88647570915891072,1,{"$f":"VLOOKUP($A197,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":0},{"$f":"VLOOKUP($A197,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},{"$f":"$I197*F197","v":0},0]
[1636,"Outside_levy_boundary",0,0,0,0,0,0,{"$f":"VLOOKUP($A198,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":0},{"$f":"VLOOKUP($A198,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},0,0]
[1637,"Outside_levy_boundary",7.2847974038299999,38.323882673599996,45.608680077429995,0.15972392517087924,0.84027607482912081,1,{"$f":"VLOOKUP($A199,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":0},{"$f":"VLOOKUP($A199,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},0,0]
[1638,"Outside_levy_boundary",0,38.494183925682186,38.494183925682186,0,1,1,{"$f":"VLOOKUP($A200,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":0},{"$f":"VLOOKUP($A200,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},0,0]
[1639,"Outside_levy_boundary",0,25.332377650960002,25.332377650960002,0,1,1,{"$f":"VLOOKUP($A201,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":0},{"$f":"VLOOKUP($A201,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},0,0]
[1640,"Outside_levy_boundary",22.106147070799999,4.23659069164,26.342737762439999,0.83917424491540071,0.16082575508459929,1,{"$f":"VLOOKUP($A202,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":85.726134504699999},{"$f":"VLOOKUP($A202,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},71.939164192497699,13.786970312202298]
[1641,"Outside_levy_boundary",40.828435892500003,0,40.828435892500003,1,0,1,{"$f":"VLOOKUP($A203,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":68.580907603699998},{"$f":"VLOOKUP($A203,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},68.580907603699998,0]
[1642,"Outside_levy_boundary",0.44021564446099998,30.420951802699999,30.861167447160998,1.4264387282649497E-2,0.98573561271735055,1,{"$f":"VLOOKUP($A204,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":0},{"$f":"VLOOKUP($A204,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},0,0]
[1643,"Outside_levy_boundary",0.73544768693600004,25.590867752800001,26.326315439736,2.7935838139580352E-2,0.97206416186041966,1,{"$f":"VLOOKUP($A205,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":0},{"$f":"VLOOKUP($A205,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},0,0]
[1644,"Outside_levy_boundary",38.163090931200003,0,38.163090931200003,1,0,1,{"$f":"VLOOKUP($A206,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":92.461759358600005},{"$f":"VLOOKUP($A206,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},92.461759358600005,0]
[1645,"Outside_levy_boundary",40.969331502599999,0,40.969331502599999,1,0,1,{"$f":"VLOOKUP($A207,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":121.853576903},{"$f":"VLOOKUP($A207,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},121.853576903,0]
[1646,"Outside_levy_boundary",42.059960571200001,0,42.059960571200001,1,0,1,{"$f":"VLOOKUP($A208,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":0},{"$f":"VLOOKUP($A208,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},0,0]
[1647,"Outside_levy_boundary",39.234116478300002,0,39.234116478300002,1,0,1,{"$f":"VLOOKUP($A209,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":0},{"$f":"VLOOKUP($A209,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},0,0]
[1648,"Outside_levy_boundary",39.9096265477,0,39.9096265477,1,0,1,{"$f":"VLOOKUP($A210,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":112.056304388},{"$f":"VLOOKUP($A210,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},112.056304388,0]
[1649,"Outside_levy_boundary",46.407144200200001,0,46.407144200200001,1,0,1,{"$f":"VLOOKUP($A211,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":0},{"$f":"VLOOKUP($A211,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},0,0]
[1650,"Outside_levy_boundary",45.627795302899997,0,45.627795302899997,1,0,1,{"$f":"VLOOKUP($A212,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":0},{"$f":"VLOOKUP($A212,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},0,0]
[1651,"Outside_levy_boundary",0,102.9724603402,102.9724603402,0,1,1,{"$f":"VLOOKUP($A213,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":0},{"$f":"VLOOKUP($A213,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},0,0]
[1653,"Outside_levy_boundary",0,109.79602322935644,109.79602322935644,0,1,1,{"$f":"VLOOKUP($A214,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":3.9443995172199999},{"$f":"VLOOKUP($A214,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},0,3.9443995172199999]
[1654,"Outside_levy_boundary",0,35.384805478899999,35.384805478899999,0,1,1,{"$f":"VLOOKUP($A215,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":0},{"$f":"VLOOKUP($A215,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},0,0]
[1655,"Outside_levy_boundary",0,0,0,0,0,0,{"$f":"VLOOKUP($A216,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":0},{"$f":"VLOOKUP($A216,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Buildout"},0,0]
[1656,"Outside_levy_boundary",0,0,0,0,0,0,{"$f":"VLOOKUP($A217,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":0},{"$f":"VLOOKUP($A217,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Buildout"},0,0]
[1657,"Outside_levy_boundary",2.7888245066400001,195.5768707116074,198.3656952182474,1.4059006037166148E-2,0.98594099396283386,1,{"$f":"12876.9798258/2","v":6438.4899128999996},"Area Structure Plan",90.518768555694436,6347.9711443443048]
[1658,"Outside_levy_boundary",0,122.642820625,122.642820625,0,1,1,{"$f":"9756.51250599999*0.5","v":4878.256252999995},{"$f":"VLOOKUP($A219,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},0,4878.256252999995]
[1663,"Outside_levy_boundary",9.3713530082100007,88.978279921072129,98.349632929282137,9.5286100507852731E-2,0.9047138994921472,0.99999999999999989,{"$f":"VLOOKUP($A220,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":6309.5169990000004},{"$f":"VLOOKUP($A220,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Unplanned"},601.20927092271938,5708.3077280772804]
[1664,"Outside_levy_boundary",0,20.030475067681,20.030475067681,0,1,1,{"$f":"VLOOKUP($A221,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":0},{"$f":"VLOOKUP($A221,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},0,0]
[1665,"Outside_levy_boundary",0,31.8590647430659,31.8590647430659,0,1,1,{"$f":"VLOOKUP($A222,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":2},{"$f":"VLOOKUP($A222,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},0,2]
[1666,"Outside_levy_boundary",0,50.598166827340378,50.598166827340378,0,1,1,{"$f":"VLOOKUP($A223,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":0},{"$f":"VLOOKUP($A223,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},0,0]
[1738,"Outside_levy_boundary",15.926705226799999,17.193141358275,33.119846585074995,0.48088100848803905,0.51911899151196106,1,{"$f":"VLOOKUP($A224,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":969.87194645900001},{"$f":"VLOOKUP($A224,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},466.39299971746135,503.47894674153878]
[1742,"Outside_levy_boundary",22.3927904958,157.49297770382415,179.88576819962415,0.12448339143177857,0.87551660856822144,1,{"$f":"VLOOKUP($A225,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":12814.181884199999},{"$f":"VLOOKUP($A225,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},1595.1528193688744,11219.029064831126]
[1743,"Outside_levy_boundary",37.358437668900002,33.66030484759137,71.018742516491372,0.52603631583908916,0.47396368416091089,1,{"$f":"VLOOKUP($A226,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":2005.7489705099999},{"$f":"VLOOKUP($A226,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},1055.0967989451262,950.65217156487381]
[1744,"Outside_levy_boundary",5.3460644644399997E-3,30.683277734434,30.68862379889844,1.7420346052245898E-4,0.99982579653947756,1,{"$f":"VLOOKUP($A227,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":2476.5934987599999},{"$f":"VLOOKUP($A227,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},0.43143115779141622,2476.1620676022085]
[1745,"Outside_levy_boundary",0,124.32471633508499,124.32471633508499,0,1,1,{"$f":"VLOOKUP($A228,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":5447.79422815},{"$f":"VLOOKUP($A228,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},0,5447.79422815]
[1824,"Outside_levy_boundary",0,53.5813728603,53.5813728603,0,1,1,{"$f":"VLOOKUP($A229,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":6387.65},{"$f":"VLOOKUP($A229,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Unplanned"},0,6387.65]
[1825,"Outside_levy_boundary",0,41.862492913200001,41.862492913200001,0,1,1,{"$f":"VLOOKUP($A230,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":4990.6000000000004},{"$f":"VLOOKUP($A230,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Unplanned"},0,4990.6000000000004]
[2001,"Outside_levy_boundary",7.1823257398599996,0,7.1823257398599996,1,0,1,{"$f":"VLOOKUP($A231,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":0},{"$f":"VLOOKUP($A231,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Buildout"},0,0]
[2002,"Outside_levy_boundary",3.8608373129000002,0,3.8608373129000002,1,0,1,{"$f":"VLOOKUP($A232,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":0},{"$f":"VLOOKUP($A232,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Buildout"},0,0]
[2003,"Outside_levy_boundary",24.1273661944,0,24.1273661944,1,0,1,{"$f":"VLOOKUP($A233,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":0},{"$f":"VLOOKUP($A233,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Buildout"},0,0]
[2004,"Outside_levy_boundary",39.026978266999997,0,39.026978266999997,1,0,1,{"$f":"VLOOKUP($A234,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":0},{"$f":"VLOOKUP($A234,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Buildout"},0,0]
[2005,"Outside_levy_boundary",20.1060504589,0,20.1060504589,1,0,1,{"$f":"VLOOKUP($A235,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":0},{"$f":"VLOOKUP($A235,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Buildout"},0,0]
[2006,"Outside_levy_boundary",5.0079210590500001,0,5.0079210590500001,1,0,1,{"$f":"VLOOKUP($A236,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":0},{"$f":"VLOOKUP($A236,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Buildout"},0,0]
[2007,"Outside_levy_boundary",34.613731911099997,0,34.613731911099997,1,0,1,{"$f":"VLOOKUP($A237,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":0},{"$f":"VLOOKUP($A237,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Buildout"},0,0]
[2008,"Outside_levy_boundary",45.7936870849,0,45.7936870849,1,0,1,{"$f":"VLOOKUP($A238,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":0},{"$f":"VLOOKUP($A238,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Buildout"},0,0]
[2009,"Outside_levy_boundary",9.9418879283399999,0,9.9418879283399999,1,0,1,{"$f":"VLOOKUP($A239,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":0},{"$f":"VLOOKUP($A239,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Buildout"},0,0]
[2010,"Outside_levy_boundary",3.0689790821399998,0,3.0689790821399998,1,0,1,{"$f":"VLOOKUP($A240,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":0},{"$f":"VLOOKUP($A240,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Buildout"},0,0]
[2011,"Outside_levy_boundary",21.0647868611,0,21.0647868611,1,0,1,{"$f":"VLOOKUP($A241,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":0},{"$f":"VLOOKUP($A241,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Buildout"},0,0]
[2012,"Outside_levy_boundary",17.853336870700002,0,17.853336870700002,1,0,1,{"$f":"VLOOKUP($A242,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":1.2246590643499999},{"$f":"VLOOKUP($A242,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Buildout"},1.2246590643499999,0]
[2013,"Outside_levy_boundary",0.58748477803599997,0,0.58748477803599997,1,0,1,{"$f":"VLOOKUP($A243,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":0},{"$f":"VLOOKUP($A243,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Buildout"},0,0]
[2014,"Outside_levy_boundary",34.217712268600003,0,34.217712268600003,1,0,1,{"$f":"VLOOKUP($A244,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":0},{"$f":"VLOOKUP($A244,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Buildout"},0,0]
[2015,"Outside_levy_boundary",186.147028621,0,186.147028621,1,0,1,{"$f":"VLOOKUP($A245,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":1.8369885965299999},{"$f":"VLOOKUP($A245,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Buildout"},1.8369885965299999,0]
[2016,"Outside_levy_boundary",18.101610003400001,0,18.101610003400001,1,0,1,{"$f":"VLOOKUP($A246,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":0},{"$f":"VLOOKUP($A246,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Buildout"},0,0]
[2017,"Outside_levy_boundary",30.9482207573,22.482498742899999,53.430719500199999,0.5792214861936148,0.4207785138063852,1,{"$f":"VLOOKUP($A247,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":2.4493181286999999},{"$f":"VLOOKUP($A247,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},1.4186976866665775,1.0306204420334224]
[2018,"Outside_levy_boundary",83.614313007999996,5.2544640416499998E-3,83.619567472041652,0.99993716226715224,6.2837732847719394E-5,1,{"$f":"VLOOKUP($A248,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":7.3479543861099996},{"$f":"VLOOKUP($A248,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},7.3474926573153079,4.617287946916081E-4]
[2019,"Outside_levy_boundary",39.368712984699997,2.1581567052600001,41.526869689959995,0.94802987267345662,5.1970127326543485E-2,1,{"$f":"VLOOKUP($A249,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":0},{"$f":"VLOOKUP($A249,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},0,0]
[2020,"Outside_levy_boundary",61.699524736599997,1.5489827825500001E-4,61.699679634878251,0.99999748948002376,2.5105199763053138E-6,1,{"$f":"VLOOKUP($A250,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":1.8369885965299999},{"$f":"VLOOKUP($A250,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},1.8369839847334322,4.6117965678336274E-6]
[2021,"Outside_levy_boundary",42.109774961200003,55.102256557499999,97.212031518700002,0.43317451866130008,0.56682548133869992,1,{"$f":"VLOOKUP($A251,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":0},{"$f":"VLOOKUP($A251,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},0,0]
[2022,"Outside_levy_boundary",55.071588146000003,1.1873715611300001E-3,55.072775517561134,0.99997843995422475,2.1560045775273868E-5,1,{"$f":"VLOOKUP($A252,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":0},{"$f":"VLOOKUP($A252,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},0,0]
[2023,"Outside_levy_boundary",30.997478194199999,30.255975633599999,61.253453827800001,0.50605274081919172,0.49394725918080823,1,{"$f":"VLOOKUP($A253,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":0},{"$f":"VLOOKUP($A253,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},0,0]
[2024,"Outside_levy_boundary",0.29781161453299998,23.130042991700002,23.427854606233002,1.271186028505431E-2,0.98728813971494567,1,{"$f":"VLOOKUP($A254,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":0},{"$f":"VLOOKUP($A254,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},0,0]
[2025,"Outside_levy_boundary",1.4439409490999999,27.445589635299999,28.889530584399999,4.9981461099949845E-2,0.95001853890005017,1,{"$f":"VLOOKUP($A255,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":0},{"$f":"VLOOKUP($A255,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},0,0]
[2026,"Outside_levy_boundary",1.5436464650899999,52.590483433300001,54.13412989839,2.851521707262001E-2,0.97148478292738005,1,{"$f":"VLOOKUP($A256,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":0},{"$f":"VLOOKUP($A256,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},0,0]
[2027,"Outside_levy_boundary",53.363855394200002,0.11287361088,53.476729005080003,0.99788929478335742,2.1107052166425065E-3,0.99999999999999989,{"$f":"VLOOKUP($A257,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":0},{"$f":"VLOOKUP($A257,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},0,0]
[2028,"Outside_levy_boundary",2.1152290310400002,43.542589679499997,45.657818710539999,4.6327859954284338E-2,0.95367214004571565,1,{"$f":"VLOOKUP($A258,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":0},{"$f":"VLOOKUP($A258,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},0,0]
[2029,"Outside_levy_boundary",1.8981800861,30.5600055281,32.458185614199998,5.8480782279757899E-2,0.94151921772024216,1,{"$f":"VLOOKUP($A259,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":0},{"$f":"VLOOKUP($A259,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},0,0]
[2030,"Outside_levy_boundary",52.575254801100002,0.13128734165299999,52.706542142753001,0.99750908831587903,2.4909116841210122E-3,1,{"$f":"VLOOKUP($A260,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":0},{"$f":"VLOOKUP($A260,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},0,0]
[2031,"Outside_levy_boundary",42.475104174400002,8.9875439232600005,51.462648097660001,0.82535791966623151,0.17464208033376857,1,{"$f":"VLOOKUP($A261,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":0},{"$f":"VLOOKUP($A261,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},{"$f":"$I261*F261","v":0},0]
[2032,"Outside_levy_boundary",4.9563870685199998,0,4.9563870685199998,1,0,1,{"$f":"VLOOKUP($A262,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":0.61232953217599995},{"$f":"VLOOKUP($A262,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Buildout"},0.61232953217599995,0]
[2033,"Outside_levy_boundary",0.58699368125100004,28.757487573999999,29.344481255250997,2.0003546020973244E-2,0.97999645397902679,1,{"$f":"VLOOKUP($A263,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":30.164232532900002},{"$f":"VLOOKUP($A263,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},0.60339161365920357,29.5608409192408]
[2035,"Outside_levy_boundary",19.202235720600001,1.6293174023400001,20.831553122940001,0.92178608130059336,7.8213918699406665E-2,1,{"$f":"VLOOKUP($A264,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":7.96028391829},{"$f":"VLOOKUP($A264,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Buildout"},7.3376789190806715,0.62260499920932844]
[2036,"Outside_levy_boundary",11.0396776761,0,11.0396776761,1,0,1,{"$f":"VLOOKUP($A265,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":0},{"$f":"VLOOKUP($A265,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Buildout"},0,0]
[2037,"Outside_levy_boundary",40.220350844199999,0,40.220350844199999,1,0,1,{"$f":"VLOOKUP($A266,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":0},{"$f":"VLOOKUP($A266,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},0,0]
[2038,"Outside_levy_boundary",14.279735775500001,36.651081654800002,50.930817430300003,0.28037515390445378,0.71962484609554622,1,{"$f":"VLOOKUP($A267,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":0},{"$f":"VLOOKUP($A267,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},0,0]
[2039,"Outside_levy_boundary",0.30124587950499998,21.8676544486,22.168900328105,1.3588670391696894E-2,0.98641132960830313,1,{"$f":"VLOOKUP($A268,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":20.527997621800001},{"$f":"VLOOKUP($A268,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},0.27894819348417793,20.249049428315825]
[2040,"Outside_levy_boundary",16.863448641600002,0,16.863448641600002,1,0,1,{"$f":"VLOOKUP($A269,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":0},{"$f":"VLOOKUP($A269,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Buildout"},0,0]
[2041,"Outside_levy_boundary",25.994297447699999,0,25.994297447699999,1,0,1,{"$f":"VLOOKUP($A270,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":0},{"$f":"VLOOKUP($A270,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Buildout"},0,0]
[2042,"Outside_levy_boundary",17.6655816504,0,17.6655816504,1,0,1,{"$f":"VLOOKUP($A271,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":35.515112866199999},{"$f":"VLOOKUP($A271,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Buildout"},35.515112866199999,0]
[2103,"Outside_levy_boundary",0,97.478247676799995,97.478247676799995,0,1,1,{"$f":"VLOOKUP($A272,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":6},{"$f":"VLOOKUP($A272,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Unplanned"},0,6]
[2104,"Outside_levy_boundary",3.5304419879100002,67.424020549800005,70.95446253771,4.9756447468454638E-2,0.95024355253154547,1,{"$f":"VLOOKUP($A273,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":7},{"$f":"VLOOKUP($A273,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Unplanned"},0.34829513227918246,6.6517048677208184]
[2105,"Outside_levy_boundary",108.38271105299999,0,108.38271105299999,1,0,1,{"$f":"VLOOKUP($A274,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":6946.54},{"$f":"VLOOKUP($A274,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},6946.54,0]
[2106,"Outside_levy_boundary",22.963379616299999,0,22.963379616299999,1,0,1,{"$f":"VLOOKUP($A275,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":1800},{"$f":"VLOOKUP($A275,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},1800,0]
[2107,"Outside_levy_boundary",39.353564656300001,0,39.353564656300001,1,0,1,{"$f":"VLOOKUP($A276,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":4720.3},{"$f":"VLOOKUP($A276,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},4720.3,0]
[2108,"Outside_levy_boundary",31.5327389837,0,31.5327389837,1,0,1,{"$f":"VLOOKUP($A277,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":1321.91},{"$f":"VLOOKUP($A277,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},1321.91,0]
[2109,"Outside_levy_boundary",59.169829051699999,0,59.169829051699999,1,0,1,{"$f":"VLOOKUP($A278,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":5053},{"$f":"VLOOKUP($A278,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},5053,0]
[2110,"Outside_levy_boundary",49.447227728900003,0.294086539797,49.741314268697003,0.99408768055044994,5.9123194495500761E-3,1,{"$f":"VLOOKUP($A279,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":3391.9},{"$f":"VLOOKUP($A279,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},3371.8460036590714,20.053996340928904]
[2111,"Outside_levy_boundary",14.742359362,33.072473359900002,47.814832721900004,0.30832188513017111,0.69167811486982889,1,{"$f":"VLOOKUP($A280,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":2442.5688068099998},{"$f":"VLOOKUP($A280,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},753.0974190758119,1689.4713877341881]
[2112,"Outside_levy_boundary",10.730253751399999,21.379619453299998,32.109873204699994,0.33417303403830906,0.665826965961691,1,{"$f":"VLOOKUP($A281,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":1771.4326779600001},{"$f":"VLOOKUP($A281,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},591.96503258850009,1179.4676453715001]
[2113,"Outside_levy_boundary",28.550810432700001,22.189904887299999,50.74071532,0.56268048750677335,0.4373195124932267,1,{"$f":"VLOOKUP($A282,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":3176.1869122200001},{"$f":"VLOOKUP($A282,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},1787.1784001805827,1389.0085120394174]
[2114,"Outside_levy_boundary",55.598340039,0,55.598340039,1,0,1,{"$f":"VLOOKUP($A283,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":3353.0026119300001},{"$f":"VLOOKUP($A283,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},3353.0026119300001,0]
[2115,"Outside_levy_boundary",39.000715204899997,11.171385885599999,50.172101090499993,0.77733868738227352,0.22266131261772656,1,{"$f":"VLOOKUP($A284,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":3383.1615850799999},{"$f":"VLOOKUP($A284,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},2629.8623857482189,753.29919933178121]
[2137,"Outside_levy_boundary",40.098465491799999,0.760462588542,40.858928080341997,0.98138809253520598,1.8611907464794041E-2,1,{"$f":"VLOOKUP($A285,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":4183.1660000000002},{"$f":"VLOOKUP($A285,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},4105.3093014981278,77.856698501872629]
[2138,"Outside_levy_boundary",60.033814053299999,3.6550151905600001E-2,60.0703642052056,0.99939154435986532,6.0845564013465106E-4,1,{"$f":"VLOOKUP($A286,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":4560},{"$f":"VLOOKUP($A286,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},4557.2254422809856,2.7745577190140089]
[2139,"Outside_levy_boundary",25.2259943912,0,25.2259943912,1,0,1,{"$f":"VLOOKUP($A287,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":1691.1123704700001},{"$f":"VLOOKUP($A287,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},1691.1123704700001,0]
[2140,"Outside_levy_boundary",56.430816865600001,4.9853726935199997E-4,56.431315402869352,0.99999116559190948,8.8344080904881925E-6,1,{"$f":"VLOOKUP($A288,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":4642},{"$f":"VLOOKUP($A288,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},4641.9589906776437,4.1009322356046186E-2]
[2141,"Outside_levy_boundary",1.0563013594199999,56.732770546700003,57.78907190612,1.8278565904916964E-2,0.98172143409508306,1,{"$f":"VLOOKUP($A289,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":2892.5227102200001},{"$f":"VLOOKUP($A289,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},52.871166990225305,2839.6515432297747]
[2142,"Outside_levy_boundary",0,58.547678799181071,58.547678799181071,0,1,1,{"$f":"VLOOKUP($A290,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":3673.6462991799999},{"$f":"VLOOKUP($A290,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},0,3673.6462991799999]
[2143,"Outside_levy_boundary",66.885078463900001,0.15027672632799999,67.035355190228003,0.99775824673559854,2.2417532644013853E-3,0.99999999999999989,{"$f":"VLOOKUP($A291,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":4253.9841527999997},{"$f":"VLOOKUP($A291,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},4244.447769938748,9.5363828612511607]
[2144,"Outside_levy_boundary",15.3725756775,29.9327530439,45.305328721400002,0.3393105427406104,0.66068945725938955,1,{"$f":"VLOOKUP($A292,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":2113.5593983499998},{"$f":"VLOOKUP($A292,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},717.15298656865639,1396.4064117813432]
[2145,"Outside_levy_boundary",42.730509003100003,0,42.730509003100003,1,0,1,{"$f":"VLOOKUP($A293,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":2854.14},{"$f":"VLOOKUP($A293,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},2854.14,0]
[2146,"Outside_levy_boundary",0.37451137317099997,34.178569721400002,34.553081094571006,1.0838725847514748E-2,0.98916127415248511,0.99999999999999989,{"$f":"VLOOKUP($A294,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":2436.7325252700002},{"$f":"VLOOKUP($A294,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},26.411075805123836,2410.321449464876]
[2147,"Outside_levy_boundary",2.8634264742099999E-2,37.323489920999997,37.352124185742099,7.666033824397637E-4,0.99923339661756017,0.99999999999999989,{"$f":"VLOOKUP($A295,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":2461.1508537999998},{"$f":"VLOOKUP($A295,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},1.8867265692175923,2459.2641272307819]
[2148,"Outside_levy_boundary",54.954127418600002,3.3136039834600002,58.267731402060001,0.94313140560432307,5.6868594395676965E-2,1,{"$f":"VLOOKUP($A296,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":3361.1450360899998},{"$f":"VLOOKUP($A296,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},3170.0014423275547,191.14359376244522]
[2149,"Outside_levy_boundary",0,28.433745242000001,28.433745242000001,0,1,1,{"$f":"VLOOKUP($A297,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":0},{"$f":"VLOOKUP($A297,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Unplanned"},0,0]
[2150,"Outside_levy_boundary",0,38.532793256799998,38.532793256799998,0,1,1,{"$f":"VLOOKUP($A298,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":0},{"$f":"VLOOKUP($A298,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Buildout"},0,0]
[2155,"Outside_levy_boundary",23.3555480799,3.54505646418,26.90060454408,0.86821647601372742,0.13178352398627258,1,{"$f":"VLOOKUP($A299,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":2684.6400927},{"$f":"VLOOKUP($A299,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},2330.8487606491603,353.79133205083946]
[2156,"Outside_levy_boundary",25.826036663299998,0,25.826036663299998,1,0,1,{"$f":"VLOOKUP($A300,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":1924.72},{"$f":"VLOOKUP($A300,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},1924.72,0]
[2158,"Outside_levy_boundary",0,52.48700556749602,52.48700556749602,0,1,1,{"$f":"VLOOKUP($A301,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":6257.14},{"$f":"VLOOKUP($A301,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Unplanned"},0,6257.14]
[2159,"Outside_levy_boundary",0,67.469459533087701,67.469459533087701,0,1,1,{"$f":"VLOOKUP($A302,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":8036.76},{"$f":"VLOOKUP($A302,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Unplanned"},0,8036.76]
[2160,"Outside_levy_boundary",0,37.451030561079897,37.451030561079897,0,1,1,{"$f":"VLOOKUP($A303,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":2669.5627286899999},{"$f":"VLOOKUP($A303,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},0,2669.5627286899999]
[2161,"Outside_levy_boundary",35.412470599199999,25.19862238723519,60.611092986435189,0.58425725150881769,0.41574274849118231,1,{"$f":"VLOOKUP($A304,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":4633.0137809999997},{"$f":"VLOOKUP($A304,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},2706.8718978895354,1926.1418831104645]
[2162,"Outside_levy_boundary",0,41.513902440300001,41.513902440300001,0,1,1,{"$f":"VLOOKUP($A305,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":4949.04},{"$f":"VLOOKUP($A305,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Unplanned"},0,4949.04]
[2166,"Outside_levy_boundary",28.118484444300002,0,28.118484444300002,1,0,1,{"$f":"VLOOKUP($A306,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":1456.09},{"$f":"VLOOKUP($A306,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},1456.09,0]
[2167,"Outside_levy_boundary",21.266299951899999,0,21.266299951899999,1,0,1,{"$f":"VLOOKUP($A307,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":1113.79},{"$f":"VLOOKUP($A307,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},1113.79,0]
[2168,"Outside_levy_boundary",17.003131723500001,0,17.003131723500001,1,0,1,{"$f":"VLOOKUP($A308,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":1056.6600000000001},{"$f":"VLOOKUP($A308,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},1056.6600000000001,0]
[2169,"Outside_levy_boundary",14.8718109413,9.9799255974900003,24.85173653879,0.59842139876572542,0.40157860123427458,1,{"$f":"VLOOKUP($A309,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":1718.36977871},{"$f":"VLOOKUP($A309,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},1028.3092465723882,690.06053213761174]
[2170,"Outside_levy_boundary",32.8753016884,5.7108891928099996E-7,32.875302259488919,0.99999998262863365,1.7371366345876393E-8,1,{"$f":"VLOOKUP($A310,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":3271.0189976000001},{"$f":"VLOOKUP($A310,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},3271.0189407779308,5.6822069331630978E-5]
[2171,"Outside_levy_boundary",33.8993643425,0,33.8993643425,1,0,1,{"$f":"VLOOKUP($A311,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":2154},{"$f":"VLOOKUP($A311,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},2154,0]
[2172,"Outside_levy_boundary",36.587330161200001,0,36.587330161200001,1,0,1,{"$f":"VLOOKUP($A312,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":2869},{"$f":"VLOOKUP($A312,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},2869,0]
[2180,"Outside_levy_boundary",59.221367044600001,5.9889034357300002,65.210270480329996,0.90816011969254928,9.1839880307450814E-2,1,{"$f":"VLOOKUP($A313,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":3755.6761163800002},{"$f":"VLOOKUP($A313,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},3410.7552713781097,344.92084500189094]
[2803,"Outside_levy_boundary",8.23113142208E-2,0,8.23113142208E-2,1,0,1,{"$f":"VLOOKUP($A314,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":306},{"$f":"VLOOKUP($A314,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Buildout"},306,0]
[2804,"Outside_levy_boundary",67.246385039200007,99.0534418031,166.29982684230001,0.40436834070169475,0.5956316592983053,1,{"$f":"VLOOKUP($A315,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":10531.618348800001},{"$f":"VLOOKUP($A315,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},4258.6530366077786,6272.9653121922229]
[2805,"Outside_levy_boundary",78.722893642700001,0,78.722893642700001,1,0,1,{"$f":"VLOOKUP($A316,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":2576.9791917699999},{"$f":"VLOOKUP($A316,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},2576.9791917699999,0]
[2806,"Outside_levy_boundary",47.829449132299999,0,47.829449132299999,1,0,1,{"$f":"VLOOKUP($A317,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":1582.68332227},{"$f":"VLOOKUP($A317,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},1582.68332227,0]
[2807,"Outside_levy_boundary",15.893380736399999,0,15.893380736399999,1,0,1,{"$f":"VLOOKUP($A318,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":522.16231912199999},{"$f":"VLOOKUP($A318,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},522.16231912199999,0]
[2808,"Outside_levy_boundary",21.060809872099998,0.81571963831500005,21.876529510414997,0.96271256654641446,3.7287433453585567E-2,1,{"$f":"VLOOKUP($A319,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":1},{"$f":"VLOOKUP($A319,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},0.96271256654641446,3.7287433453585567E-2]
[2809,"Outside_levy_boundary",108.92613328,0,108.92613328,1,0,1,{"$f":"VLOOKUP($A320,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":4709},{"$f":"VLOOKUP($A320,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},4709,0]
[2810,"Outside_levy_boundary",93.770710497099998,0,93.770710497099998,1,0,1,{"$f":"VLOOKUP($A321,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":4166},{"$f":"VLOOKUP($A321,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},4166,0]
[2811,"Outside_levy_boundary",61.171900163899998,0,61.171900163899998,1,0,1,{"$f":"VLOOKUP($A322,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":3244},{"$f":"VLOOKUP($A322,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},3244,0]
[2812,"Outside_levy_boundary",35.746966866800001,0,35.746966866800001,1,0,1,{"$f":"VLOOKUP($A323,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":1497},{"$f":"VLOOKUP($A323,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},1497,0]
[2813,"Outside_levy_boundary",33.056764781600002,0,33.056764781600002,1,0,1,{"$f":"VLOOKUP($A324,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":1568},{"$f":"VLOOKUP($A324,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},1568,0]
[2815,"Outside_levy_boundary",0,45.839078477375935,45.839078477375935,0,1,1,{"$f":"VLOOKUP($A325,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":5078},{"$f":"VLOOKUP($A325,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},{"$f":"$I325*F325","v":0},5078]
[2816,"Outside_levy_boundary",0.42557275618399998,82.538255767500004,82.963828523684001,5.1296180969096685E-3,0.99487038190309041,1,{"$f":"VLOOKUP($A326,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":5397.4502802099996},{"$f":"VLOOKUP($A326,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},27.686858634535376,5369.7634215754642]
[2817,"Outside_levy_boundary",14.7330829722,0,14.7330829722,1,0,1,{"$f":"VLOOKUP($A327,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":978},{"$f":"VLOOKUP($A327,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Buildout"},978,0]
[2818,"Outside_levy_boundary",23.0866424118,0,23.0866424118,1,0,1,{"$f":"VLOOKUP($A328,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":1251},{"$f":"VLOOKUP($A328,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},1251,0]
[2819,"Outside_levy_boundary",60.123564704800003,0,60.123564704800003,1,0,1,{"$f":"VLOOKUP($A329,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":2471},{"$f":"VLOOKUP($A329,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},2471,0]
[2901,"Outside_levy_boundary",93.702913712500006,0,93.702913712500006,1,0,1,{"$f":"VLOOKUP($A330,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":2622},{"$f":"VLOOKUP($A330,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},2622,0]
[2902,"Outside_levy_boundary",102.41923215600001,0,102.41923215600001,1,0,1,{"$f":"VLOOKUP($A331,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":4460},{"$f":"VLOOKUP($A331,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},4460,0]
[2903,"Outside_levy_boundary",0,8.8804968440399996,8.8804968440399996,0,1,1,{"$f":"VLOOKUP($A332,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":970.2},{"$f":"VLOOKUP($A332,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},0,970.2]
[2904,"Outside_levy_boundary",74.610991331500003,0,74.610991331500003,1,0,1,{"$f":"VLOOKUP($A333,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":3580},{"$f":"VLOOKUP($A333,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},3580,0]
[2905,"Outside_levy_boundary",117.046953837,0,117.046953837,1,0,1,{"$f":"VLOOKUP($A334,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":5972},{"$f":"VLOOKUP($A334,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},5972,0]
[2906,"Outside_levy_boundary",21.2453230554,0,21.2453230554,1,0,1,{"$f":"VLOOKUP($A335,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":0},{"$f":"VLOOKUP($A335,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},0,0]
[2907,"Outside_levy_boundary",21.058880306199999,0,21.058880306199999,1,0,1,{"$f":"VLOOKUP($A336,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":5},{"$f":"VLOOKUP($A336,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},5,0]
[2908,"Outside_levy_boundary",0,123.886434823,123.886434823,0,1,1,{"$f":"VLOOKUP($A337,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":0},{"$f":"VLOOKUP($A337,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},0,0]
[2911,"Outside_levy_boundary",0,65.964274630199995,65.964274630199995,0,1,1,{"$f":"VLOOKUP($A338,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":4191.5449188100001},{"$f":"VLOOKUP($A338,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},0,4191.5449188100001]
[2912,"Outside_levy_boundary",0,61.457412855199998,61.457412855199998,0,1,1,{"$f":"VLOOKUP($A339,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":3867.2987134999998},{"$f":"VLOOKUP($A339,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},0,3867.2987134999998]
[2913,"Outside_levy_boundary",9.4736814688899997,63.835125416216606,73.308806885106605,0.12922978658945641,0.87077021341054361,1,{"$f":"VLOOKUP($A340,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":3},{"$f":"VLOOKUP($A340,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Buildout"},0.38768935976836927,2.6123106402316307]
[2914,"Outside_levy_boundary",17.4549373306,5.3440858588699998,22.799023189469999,0.76560022705980546,0.23439977294019462,1,0,{"$f":"VLOOKUP($A341,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Buildout"},0,0]
[2915,"Outside_levy_boundary",62.3897156572,0,62.3897156572,1,0,1,{"$f":"VLOOKUP($A342,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":2},{"$f":"VLOOKUP($A342,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Buildout"},2,0]
[2916,"Outside_levy_boundary",34.175868128799998,0,34.175868128799998,1,0,1,{"$f":"VLOOKUP($A343,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":0},{"$f":"VLOOKUP($A343,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},0,0]
[2917,"Outside_levy_boundary",114.057325574,0,114.057325574,1,0,1,{"$f":"VLOOKUP($A344,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":6246},{"$f":"VLOOKUP($A344,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},6246,0]
[2918,"Outside_levy_boundary",74.041870609599997,0,74.041870609599997,1,0,1,{"$f":"VLOOKUP($A345,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":3756},{"$f":"VLOOKUP($A345,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},3756,0]
[2919,"Outside_levy_boundary",48.905100028,5.2016561903799996,54.106756218379999,0.90386309300476964,9.6136906995230351E-2,1,{"$f":"VLOOKUP($A346,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":7066.9740000000002},{"$f":"VLOOKUP($A346,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},6387.5769778242893,679.39702217571107]
[2920,"Outside_levy_boundary",19.7842388386,0,19.7842388386,1,0,1,{"$f":"VLOOKUP($A347,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":0},{"$f":"VLOOKUP($A347,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},0,0]
[2921,"Outside_levy_boundary",78.963737413499999,0.60338193766500003,79.567119351165005,0.99241669244047892,7.5833075595210103E-3,0.99999999999999989,{"$f":"VLOOKUP($A348,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":4147.59},{"$f":"VLOOKUP($A348,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},4116.1375493992064,31.45245060079375]
[2922,"Outside_levy_boundary",56.589408295299997,8.0112689634899998E-3,56.59741956426349,0.99985845169222964,1.4154830777035005E-4,1,{"$f":"VLOOKUP($A349,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":2094.1799999999998},{"$f":"VLOOKUP($A349,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},2093.8835723648335,0.29642763516651166]
[2923,"Outside_levy_boundary",168.861137206,0,168.861137206,1,0,1,{"$f":"VLOOKUP($A350,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":9084.6440000000002},{"$f":"VLOOKUP($A350,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},9084.6440000000002,0]
[2924,"Outside_levy_boundary",0.151259438696,88.319172268200006,88.470431706896008,1.7097174251067861E-3,0.99829028257489316,1,{"$f":"VLOOKUP($A351,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":8503.6697225600001},{"$f":"VLOOKUP($A351,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},14.538872302013822,8489.130850257985]
[2925,"Outside_levy_boundary",3.3651252243899998,38.179065127160001,41.54419035155,8.100110258291382E-2,0.91899889741708618,1,{"$f":"VLOOKUP($A352,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":1607.66644006},{"$f":"VLOOKUP($A352,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},130.22275423040793,1477.4436858295921]
[2926,"Outside_levy_boundary",7.5346879256999996E-2,65.232215804299997,65.307562683556995,1.1537236448723063E-3,0.99884627635512768,1,{"$f":"VLOOKUP($A353,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":4476.2651367899998},{"$f":"VLOOKUP($A353,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},5.1643729290321918,4471.1007638609672]
[2931,"Outside_levy_boundary",48.878552863000003,1.35608338236,50.234636245360001,0.97300501240346382,2.699498759653618E-2,1,{"$f":"VLOOKUP($A354,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":2403.7052330000001},{"$f":"VLOOKUP($A354,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},2338.8172400494359,64.887992950564112]
[2932,"Outside_levy_boundary",42.574219045299998,0,42.574219045299998,1,0,1,{"$f":"VLOOKUP($A355,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":1945},{"$f":"VLOOKUP($A355,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},1945,0]
[2933,"Outside_levy_boundary",9.8911904300100009,0,9.8911904300100009,1,0,1,{"$f":"VLOOKUP($A356,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":209},{"$f":"VLOOKUP($A356,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},209,0]
[2934,"Outside_levy_boundary",20.7125153442,0,20.7125153442,1,0,1,{"$f":"VLOOKUP($A357,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":1316},{"$f":"VLOOKUP($A357,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},1316,0]
[2935,"Outside_levy_boundary",68.528048181100004,17.682823774599999,86.2108719557,0.79488870285772739,0.20511129714227261,1,{"$f":"VLOOKUP($A358,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":6611.3710000000001},{"$f":"VLOOKUP($A358,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},5255.3041183011965,1356.0668816988041]
[2936,"Outside_levy_boundary",0,62.092698138199999,62.092698138199999,0,1,1,{"$f":"VLOOKUP($A359,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":3746.4447632500001},{"$f":"VLOOKUP($A359,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},0,3746.4447632500001]
[2937,"Outside_levy_boundary",38.439669797900002,72.586504856100007,111.02617465400002,0.34622168977444012,0.65377831022555977,0.99999999999999989,{"$f":"VLOOKUP($A360,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":7320.1451872199996},{"$f":"VLOOKUP($A360,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},2534.3930361135435,4785.7521511064551]
[2938,"Outside_levy_boundary",0,52.897291517900001,52.897291517900001,0,1,1,{"$f":"VLOOKUP($A361,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":3547.0505343200002},{"$f":"VLOOKUP($A361,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},0,3547.0505343200002]
[2939,"Outside_levy_boundary",0,52.3822249081,52.3822249081,0,1,1,{"$f":"VLOOKUP($A362,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":2896.4733584999999},{"$f":"VLOOKUP($A362,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},0,2896.4733584999999]
[3105,"Outside_levy_boundary",47.883482706300001,0,47.883482706300001,1,0,1,{"$f":"VLOOKUP($A363,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":2046.30873129},{"$f":"VLOOKUP($A363,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},2046.30873129,0]
[3137,"Outside_levy_boundary",13.324591209699999,0,13.324591209699999,1,0,1,{"$f":"VLOOKUP($A364,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":345.245046704},{"$f":"VLOOKUP($A364,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Buildout"},345.245046704,0]
[3201,"Outside_levy_boundary",99.302460952999994,0,99.302460952999994,1,0,1,{"$f":"VLOOKUP($A365,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":6747},{"$f":"VLOOKUP($A365,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Community Plan"},6747,0]
[3202,"Outside_levy_boundary",120.123002124,0,120.123002124,1,0,1,{"$f":"VLOOKUP($A366,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":6534},{"$f":"VLOOKUP($A366,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Community Plan"},6534,0]
[3203,"Outside_levy_boundary",67.014543211100005,0,67.014543211100005,1,0,1,{"$f":"VLOOKUP($A367,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":3980},{"$f":"VLOOKUP($A367,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Community Plan"},3980,0]
[3204,"Outside_levy_boundary",28.069795675999998,0,28.069795675999998,1,0,1,{"$f":"VLOOKUP($A368,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":885},{"$f":"VLOOKUP($A368,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Community Plan"},885,0]
[3205,"Outside_levy_boundary",109.755388525,0,109.755388525,1,0,1,{"$f":"VLOOKUP($A369,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":4678},{"$f":"VLOOKUP($A369,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Community Plan"},4678,0]
[3206,"Outside_levy_boundary",27.788035772499999,0,27.788035772499999,1,0,1,{"$f":"VLOOKUP($A370,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":915.36803773400004},{"$f":"VLOOKUP($A370,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},915.36803773400004,0]
[3207,"Outside_levy_boundary",32.138079764099999,0,32.138079764099999,1,0,1,{"$f":"VLOOKUP($A371,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":1161.71370217},{"$f":"VLOOKUP($A371,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},1161.71370217,0]
[3208,"Outside_levy_boundary",30.988212747799999,0,30.988212747799999,1,0,1,{"$f":"VLOOKUP($A372,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":729.02687917799994},{"$f":"VLOOKUP($A372,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Buildout"},729.02687917799994,0]
[3209,"Outside_levy_boundary",8.80631297483,9.6181607830699996,18.4244737579,0.47796822262313199,0.52203177737686801,1,{"$f":"VLOOKUP($A373,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":0},{"$f":"VLOOKUP($A373,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},0,0]
[3210,"Outside_levy_boundary",7.9750462391600001,19.631197062399998,27.606243301559999,0.28888560287046877,0.71111439712953117,1,{"$f":"VLOOKUP($A374,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":0},{"$f":"VLOOKUP($A374,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},0,0]
[3211,"Outside_levy_boundary",4.9764382994000003E-2,17.026195973099998,17.075960356093997,2.9142948306412706E-3,0.99708570516935879,1,{"$f":"VLOOKUP($A375,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":0},{"$f":"VLOOKUP($A375,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},0,0]
[3212,"Outside_levy_boundary",0,3.0341112809199999,3.0341112809199999,0,1,1,{"$f":"VLOOKUP($A376,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":0},{"$f":"VLOOKUP($A376,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},0,0]
[3213,"Outside_levy_boundary",0,13.497197478,13.497197478,0,1,1,{"$f":"VLOOKUP($A377,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":63.069941814099998},{"$f":"VLOOKUP($A377,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},0,63.069941814099998]
[3214,"Outside_levy_boundary",1.06856635451E-2,19.717655984700002,19.728341648245102,5.4164023188692711E-4,0.99945835976811304,1,{"$f":"VLOOKUP($A378,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":106.545338599},{"$f":"VLOOKUP($A378,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},5.7709241905233528E-2,106.48762935709476]
[3215,"Outside_levy_boundary",26.966637407299999,5.0381072280300002E-5,26.96668778837228,0.99999813172931451,1.868270685509391E-6,1,{"$f":"VLOOKUP($A379,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":995.87738153600003},{"$f":"VLOOKUP($A379,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},995.87552096748175,1.8605685182855602E-3]
[3216,"Outside_levy_boundary",70.099428216099994,0,70.099428216099994,1,0,1,{"$f":"VLOOKUP($A380,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":2101.5753755800001},{"$f":"VLOOKUP($A380,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},2101.5753755800001,0]
[3217,"Outside_levy_boundary",21.961662240799999,0,21.961662240799999,1,0,1,{"$f":"VLOOKUP($A381,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":866.70061431099998},{"$f":"VLOOKUP($A381,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},866.70061431099998,0]
[3218,"Outside_levy_boundary",34.985301205399999,0,34.985301205399999,1,0,1,{"$f":"VLOOKUP($A382,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":1232.1619798700001},{"$f":"VLOOKUP($A382,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},1232.1619798700001,0]
[3219,"Outside_levy_boundary",14.727320307499999,0,14.727320307499999,1,0,1,{"$f":"VLOOKUP($A383,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":0},{"$f":"VLOOKUP($A383,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},0,0]
[3220,"Outside_levy_boundary",13.6649259032,0,13.6649259032,1,0,1,{"$f":"VLOOKUP($A384,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":0},{"$f":"VLOOKUP($A384,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},0,0]
[3221,"Outside_levy_boundary",31.544296793699999,0,31.544296793699999,1,0,1,{"$f":"VLOOKUP($A385,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":227},{"$f":"VLOOKUP($A385,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},227,0]
[3222,"Outside_levy_boundary",24.8068244653,0,24.8068244653,1,0,1,{"$f":"VLOOKUP($A386,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":2370},{"$f":"VLOOKUP($A386,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},2370,0]
[3223,"Outside_levy_boundary",60.595342190399997,6.6022003978000003E-5,60.595408212403974,0.99999891044542932,1.0895545706462489E-6,1,{"$f":"VLOOKUP($A387,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":2728},{"$f":"VLOOKUP($A387,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},2727.9970276951312,2.9723048687229671E-3]
[3224,"Outside_levy_boundary",61.537704246899999,0,61.537704246899999,1,0,1,{"$f":"VLOOKUP($A388,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":2899},{"$f":"VLOOKUP($A388,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},2899,0]
[3225,"Outside_levy_boundary",91.222611902699995,0,91.222611902699995,1,0,1,{"$f":"VLOOKUP($A389,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":4709},{"$f":"VLOOKUP($A389,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},{"$f":"$I389*F389","v":4709},0]
[3226,"Outside_levy_boundary",87.785075520899994,0,87.785075520899994,1,0,1,{"$f":"VLOOKUP($A390,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":4802},{"$f":"VLOOKUP($A390,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},4802,0]
[3227,"Outside_levy_boundary",48.284246255600003,8.9619572629100005E-5,48.28433587517263,0.99999814392036257,1.8560796375203243E-6,1,{"$f":"VLOOKUP($A391,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":2529},{"$f":"VLOOKUP($A391,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},2528.9953059745972,4.6940254032889006E-3]
[3228,"Outside_levy_boundary",7.39539140899E-2,34.931774846559996,35.005728760649895,2.1126231822098771E-3,0.99788737681779016,1,{"$f":"VLOOKUP($A392,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":0},{"$f":"VLOOKUP($A392,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},0,0]
[3229,"Outside_levy_boundary",0,63.439353190299997,63.439353190299997,0,1,1,{"$f":"VLOOKUP($A393,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":0},{"$f":"VLOOKUP($A393,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},0,0]
[3230,"Outside_levy_boundary",89.328976881100004,72.739974121240493,162.0689510023405,0.55117884288527275,0.44882115711472725,1,{"$f":"VLOOKUP($A394,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":0},{"$f":"VLOOKUP($A394,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},0,0]
[3231,"Outside_levy_boundary",1.30778284268,71.9929170419,73.300699884579998,1.7841341825374762E-2,0.98215865817462522,1,{"$f":"VLOOKUP($A395,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":7.96028391829},{"$f":"VLOOKUP($A395,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},0.14202214641324548,7.8182617718767542]
[3232,"Outside_levy_boundary",40.550274064699998,14.786698360899999,55.336972425599996,0.73278808520324157,0.26721191479675849,1,{"$f":"VLOOKUP($A396,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":1.8369885965299999},{"$f":"VLOOKUP($A396,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},1.3461233561914088,0.4908652403385913]
[3234,"Outside_levy_boundary",0,8.7921187208900005,8.7921187208900005,0,1,1,{"$f":"VLOOKUP($A397,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":0},{"$f":"VLOOKUP($A397,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},0,0]
[3235,"Outside_levy_boundary",6.0569033369799996,19.808675359199999,25.865578696179998,0.23416848345537011,0.76583151654462989,1,{"$f":"VLOOKUP($A398,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":0},{"$f":"VLOOKUP($A398,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},0,0]
[3236,"Outside_levy_boundary",38.378554273399999,0,38.378554273399999,1,0,1,{"$f":"VLOOKUP($A399,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":1839},{"$f":"VLOOKUP($A399,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Community Plan"},1839,0]
[3237,"Outside_levy_boundary",26.442943437899999,0,26.442943437899999,1,0,1,{"$f":"VLOOKUP($A400,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":1052.52888132},{"$f":"VLOOKUP($A400,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},1052.52888132,0]
[3238,"Outside_levy_boundary",22.4128033786,0,22.4128033786,1,0,1,{"$f":"VLOOKUP($A401,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":1047},{"$f":"VLOOKUP($A401,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Community Plan"},1047,0]
[3239,"Outside_levy_boundary",10.3137466198,0,10.3137466198,1,0,1,{"$f":"VLOOKUP($A402,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":0},{"$f":"VLOOKUP($A402,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},0,0]
[3240,"Outside_levy_boundary",26.760242758099999,4.9650227188900002,31.72526547699,0.84349941145516716,0.15650058854483279,1,{"$f":"VLOOKUP($A403,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":37.011524655300001},{"$f":"VLOOKUP($A403,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},31.219199263803958,5.7923253914960391]
[3309,"Outside_levy_boundary",0,175.72200101799999,175.72200101799999,0,1,1,{"$f":"VLOOKUP($A404,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":10554.0535495},{"$f":"VLOOKUP($A404,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},0,10554.0535495]
[3310,"Outside_levy_boundary",0,72.833503593675005,72.833503593675005,0,1,1,{"$f":"VLOOKUP($A405,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":3736.5013728499998},{"$f":"VLOOKUP($A405,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},0,3736.5013728499998]
[3312,"Outside_levy_boundary",80.4540321068,0,80.4540321068,1,0,1,{"$f":"VLOOKUP($A406,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":4198},{"$f":"VLOOKUP($A406,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},4198,0]
[3313,"Outside_levy_boundary",71.913922306399996,0,71.913922306399996,1,0,1,{"$f":"VLOOKUP($A407,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":3604.85},{"$f":"VLOOKUP($A407,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},3604.85,0]
[3314,"Outside_levy_boundary",142.139975553,4.8722020026E-3,142.14484775500259,0.99996572368200787,3.4276317992176612E-5,1,{"$f":"VLOOKUP($A408,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":6732.8620000000001},{"$f":"VLOOKUP($A408,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},6732.6312222810911,0.23077771890944221]
[3315,"Outside_levy_boundary",34.281891117199997,27.289702089045701,61.571593206245694,0.55678096557232681,0.44321903442767324,1,{"$f":"VLOOKUP($A409,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":5511.8523282300002},{"$f":"VLOOKUP($A409,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},3068.8944614039769,2442.9578668260233]
[3316,"Outside_levy_boundary",1.14408864924E-4,63.9673346975,63.967449106364924,1.7885481838389585E-6,0.99999821145181611,1,{"$f":"VLOOKUP($A410,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":3315.3431887299998},{"$f":"VLOOKUP($A410,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},5.9296510390059029E-3,3315.3372590789609]
[3317,"Outside_levy_boundary",0,129.02715559399999,129.02715559399999,0,1,1,{"$f":"VLOOKUP($A411,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":9456.7902357500006},{"$f":"VLOOKUP($A411,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Unplanned"},0,9456.7902357500006]
[3318,"Outside_levy_boundary",0,130.51035573199999,130.51035573199999,0,1,1,{"$f":"VLOOKUP($A412,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":6563.1138613200001},{"$f":"VLOOKUP($A412,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Unplanned"},0,6563.1138613200001]
[3323,"Outside_levy_boundary",0,130.51851934000001,130.51851934000001,0,1,1,{"$f":"VLOOKUP($A413,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":7300.5629676600001},{"$f":"VLOOKUP($A413,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Unplanned"},0,7300.5629676600001]
[3324,"Outside_levy_boundary",0,124.254000375012,124.254000375012,0,1,1,{"$f":"VLOOKUP($A414,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":9437.1225421599993},{"$f":"VLOOKUP($A414,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Unplanned"},0,9437.1225421599993]
[3325,"Outside_levy_boundary",19.108277066599999,108.61486369768301,127.723140764283,0.14960700897470816,0.85039299102529187,1,{"$f":"VLOOKUP($A415,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":8593.05431082},{"$f":"VLOOKUP($A415,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},1285.5811533990025,7307.4731574209982]
[3326,"Outside_levy_boundary",90.694207540099995,15.538570944099879,106.23277848419987,0.85373091840565063,0.14626908159434943,1,{"$f":"VLOOKUP($A416,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":6390.4210281400001},{"$f":"VLOOKUP($A416,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},5455.7000133527445,934.72101478725597]
[3327,"Outside_levy_boundary",6.9668167667200001,107.22005612547694,114.18687289219694,6.1012414039022897E-2,0.93898758596097709,1,{"$f":"VLOOKUP($A417,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":9066.6320518199991},{"$f":"VLOOKUP($A417,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},553.17710868511745,8513.4549431348823]
[3328,"Outside_levy_boundary",33.429625496200003,20.086333837906,53.515959334106,0.62466647168735567,0.37533352831264438,1,{"$f":"VLOOKUP($A418,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":5667.4199781799998},{"$f":"VLOOKUP($A418,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},3540.2472413401306,2127.1727368398692]
[3329,"Outside_levy_boundary",2.5404337933200001,123.3152133072317,125.85564710055171,2.0185298410093064E-2,0.97981470158990691,1,{"$f":"VLOOKUP($A419,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":7984.9029403200002},{"$f":"VLOOKUP($A419,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},161.17764862598872,7823.7252916940115]
[3330,"Outside_levy_boundary",0,130.39293738699999,130.39293738699999,0,1,1,{"$f":"VLOOKUP($A420,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":7374.81554203},{"$f":"VLOOKUP($A420,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Unplanned"},0,7374.81554203]
[3335,"Outside_levy_boundary",0,130.74441540233684,130.74441540233684,0,1,1,{"$f":"VLOOKUP($A421,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":9396.0122465900004},{"$f":"VLOOKUP($A421,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Unplanned"},0,9396.0122465900004]
[3336,"Outside_levy_boundary",1.83801326699E-4,64.960705544539991,64.96088934586669,2.8294151842718709E-6,0.99999717058481574,1,{"$f":"VLOOKUP($A422,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":3901.3929266},{"$f":"VLOOKUP($A422,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},1.1038660386332912E-2,3901.3818879396135]
[3337,"Outside_levy_boundary",3.3837590674400002,54.333935590366458,57.717694657806462,5.8626025996038951E-2,0.94137397400396094,0.99999999999999989,{"$f":"VLOOKUP($A423,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":4041.2516528400001},{"$f":"VLOOKUP($A423,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},236.92252445593323,3804.3291283840663]
[3338,"Outside_levy_boundary",0,43.187178849086337,43.187178849086337,0,1,1,{"$f":"VLOOKUP($A424,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":2619.7237675400002},{"$f":"VLOOKUP($A424,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},0,2619.7237675400002]
[3339,"Outside_levy_boundary",0,74.892832901524343,74.892832901524343,0,1,1,{"$f":"VLOOKUP($A425,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":0},{"$f":"VLOOKUP($A425,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},0,0]
[3340,"Outside_levy_boundary",1.81234657696E-3,282.06421591396258,282.06602826053955,6.4252564838682612E-6,0.99999357474351613,1,{"$f":"VLOOKUP($A426,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":3255.2192969299999},{"$f":"VLOOKUP($A426,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},2.0915618894012566E-2,3255.198381311106]
[3341,"Outside_levy_boundary",0,248.82169640943647,248.82169640943647,0,1,1,{"$f":"VLOOKUP($A427,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":10438.4981178},{"$f":"VLOOKUP($A427,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},0,10438.4981178]
[3344,"Outside_levy_boundary",0,25.618583541900001,25.618583541900001,0,1,1,{"$f":"VLOOKUP($A428,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":6},{"$f":"VLOOKUP($A428,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},0,6]
[3345,"Outside_levy_boundary",0,14.293266626099999,14.293266626099999,0,1,1,{"$f":"VLOOKUP($A429,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":0},{"$f":"VLOOKUP($A429,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Buildout"},0,0]
[3347,"Outside_levy_boundary",0,64.182550786899995,64.182550786899995,0,1,1,{"$f":"VLOOKUP($A430,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":4731.3579707700001},{"$f":"VLOOKUP($A430,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Unplanned"},0,4731.3579707700001]
[3348,"Outside_levy_boundary",0,65.0645065577,65.0645065577,0,1,1,{"$f":"VLOOKUP($A431,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":3267.5442437900001},{"$f":"VLOOKUP($A431,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Unplanned"},0,3267.5442437900001]
[3349,"Outside_levy_boundary",66.519608356800006,10.757953480899999,77.277561837700006,0.8607881353258261,0.1392118646741739,1,{"$f":"VLOOKUP($A432,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":3981.5259999999998},{"$f":"VLOOKUP($A432,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},3427.2503412912947,554.2756587087049]
[3350,"Outside_levy_boundary",54.801091663000001,7.8931614163199999,62.694253079319999,0.87410071850870175,0.12589928149129823,1,{"$f":"VLOOKUP($A433,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":3653.62233694},{"$f":"VLOOKUP($A433,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},3193.6339098786962,459.98842706130392]
[3351,"Outside_levy_boundary",26.172088832099998,29.054390704050704,55.226479536150705,0.47390471114437066,0.52609528885562928,1,{"$f":"VLOOKUP($A434,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":2614.4943249200001},{"$f":"VLOOKUP($A434,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},1239.0211778398091,1375.473147080191]
[3352,"Outside_levy_boundary",0,126.98085934028499,126.98085934028499,0,1,1,{"$f":"VLOOKUP($A435,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":9249.09928296},{"$f":"VLOOKUP($A435,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Unplanned"},0,9249.09928296]
[3353,"Outside_levy_boundary",6.2402461946500003E-2,45.028145420820799,45.090547882767297,1.3839366536140265E-3,0.99861606334638597,1,{"$f":"VLOOKUP($A436,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":4634.9408879299999},{"$f":"VLOOKUP($A436,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},6.4144645821406687,4628.5264233478592]
[3354,"Outside_levy_boundary",0,64.890785598799994,64.890785598799994,0,1,1,{"$f":"VLOOKUP($A437,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":4754.7871338499999},{"$f":"VLOOKUP($A437,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},0,4754.7871338499999]
[3517,"Outside_levy_boundary",0,256.17772839236761,256.17772839236761,0,1,1,{"$f":"VLOOKUP($A438,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":18027.582312800001},{"$f":"VLOOKUP($A438,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},0,18027.582312800001]
[3518,"Outside_levy_boundary",188.54285001400001,77.151227448399993,265.6940774624,0.70962383435393617,0.29037616564606389,1,{"$f":"VLOOKUP($A439,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":4},{"$f":"VLOOKUP($A439,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},2.8384953374157447,1.1615046625842556]
[3520,"Outside_levy_boundary",0,28.744290697146099,28.744290697146099,0,1,1,{"$f":"VLOOKUP($A440,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":2228.6167999999998},{"$f":"VLOOKUP($A440,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},0,2228.6167999999998]
[3521,"Outside_levy_boundary",0,76.738083082100005,76.738083082100005,0,1,1,{"$f":"VLOOKUP($A441,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":3307.5868},{"$f":"VLOOKUP($A441,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},0,3307.5868]
[3548,"Outside_levy_boundary",0,162.10281595790002,162.10281595790002,0,1,1,{"$f":"VLOOKUP($A442,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":3791.7860000000001},{"$f":"VLOOKUP($A442,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},0,3791.7860000000001]
[3549,"Outside_levy_boundary",0,102.0027303,102.0027303,0,1,1,{"$f":"VLOOKUP($A443,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":3},{"$f":"VLOOKUP($A443,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},0,3]
[3550,"Outside_levy_boundary",2.6081623298799999,107.893716256,110.50187858588001,2.3602877736173367E-2,0.97639712226382658,1,{"$f":"VLOOKUP($A444,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":2},{"$f":"VLOOKUP($A444,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},4.7205755472346733E-2,1.9527942445276532]
[3551,"Outside_levy_boundary",1.3819317609099999,153.335630036,154.71756179690999,8.9319644445017346E-3,0.99106803555549827,1,{"$f":"VLOOKUP($A445,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":0},{"$f":"VLOOKUP($A445,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},0,0]
[3560,"Outside_levy_boundary",0,374.80637174663224,374.80637174663224,0,1,1,{"$f":"29375.89343/3","v":9791.9644766666661},"Area Structure Plan",0,9791.9644766666661]
[3567,"Outside_levy_boundary",0,123.357994517348,123.357994517348,0,1,1,{"$f":"VLOOKUP($A447,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":7264.4040000000005},{"$f":"VLOOKUP($A447,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},0,7264.4040000000005]
[4201,"Outside_levy_boundary",0.83508022698899997,0,0.83508022698899997,1,0,1,{"$f":"VLOOKUP($A448,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":0},{"$f":"VLOOKUP($A448,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},0,0]
[4202,"Outside_levy_boundary",2.5090751152699999,0,2.5090751152699999,1,0,1,{"$f":"VLOOKUP($A449,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":0},{"$f":"VLOOKUP($A449,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},0,0]
[4225,"Outside_levy_boundary",3.6771030147999998E-6,0,3.6771030147999998E-6,1,0,1,{"$f":"VLOOKUP($A450,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":0},{"$f":"VLOOKUP($A450,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Buildout"},0,0]
[4226,"Outside_levy_boundary",1.83984636351,0,1.83984636351,1,0,1,{"$f":"VLOOKUP($A451,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":0},{"$f":"VLOOKUP($A451,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Buildout"},0,0]
[4236,"Outside_levy_boundary",1.5000143640700001,0,1.5000143640700001,1,0,1,{"$f":"VLOOKUP($A452,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":168},{"$f":"VLOOKUP($A452,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},168,0]
[4237,"Outside_levy_boundary",1.72092483903,0,1.72092483903,1,0,1,{"$f":"VLOOKUP($A453,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":0},{"$f":"VLOOKUP($A453,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},{"$f":"$I453*F453","v":0},0]
[4238,"Outside_levy_boundary",0.22149024917499999,3.2822836127200001,3.5037738618950001,6.3214767249621523E-2,0.9367852327503785,1,{"$f":"VLOOKUP($A454,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":0},{"$f":"VLOOKUP($A454,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},0,0]
[4239,"Outside_levy_boundary",0.19312556064799999,0,0.19312556064799999,1,0,1,{"$f":"VLOOKUP($A455,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":0},{"$f":"VLOOKUP($A455,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},0,0]
[4240,"Outside_levy_boundary",1.29046883468,0,1.29046883468,1,0,1,{"$f":"VLOOKUP($A456,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":0},{"$f":"VLOOKUP($A456,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},0,0]
[4241,"Outside_levy_boundary",3.0907124690100001,0,3.0907124690100001,1,0,1,{"$f":"VLOOKUP($A457,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":4801.3786461299997},{"$f":"VLOOKUP($A457,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},4801.3786461299997,0]
[3311,"Outside_levy_boundary",77.974829214400003,1.2775847641,79.252413978500002,0.98387954763817553,1.6120452361824456E-2,1,{"$f":"VLOOKUP($A458,[1]allTZs!$B$1:$Y$1402,17,FALSE)","v":4994.03},{"$f":"VLOOKUP($A458,[1]allTZs!$B$1:$Y$1402,23,FALSE)","v":"Area Structure Plan"},4913.5239772914774,80.506022708522181]
[]
[]
[null,"AREA",{"$f":"SUM(C4:C458)","v":13146.751307130098},{"$f":"SUM(D4:D458)","v":14211.103115394673},{"$f":"C461+D461-4000","v":23357.854422524772}]

{"sheet":"Tab 9 - Existing Capacity","index":9,"n_rows":8,"n_cols":2,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Police - Existing Facilities Capacity"]
[]
["Total existing and funded police district office capacity in the Greenfield Area (people)",{"$f":"SUM(B6:B8)","v":372500}]
[]
["Facility ","Capacity (population)"]
["Police District Office 5",{"$f":"149000/2","v":74500}]
["Police District Office 7",149000]
["Police District Office 9",149000]