{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["SAMPLE","Water","Sewer Sanitary","Storm and Drainage","Streets","Parks","Sheet10","LIST","List 2"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":1,"defined_names":39,"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":"SAMPLE","index":0,"n_rows":79,"n_cols":12,"rows_kept":79,"cut":false,"hidden":false,"merged":[[43,1,43,3],[45,1,47,9],[49,1,49,3],[56,1,56,3],[57,1,57,3],[58,1,58,3],[59,1,61,9],[235,1,235,4],[231,1,233,10],[230,1,230,5],[229,1,229,5],[228,1,228,4],[81,1,81,4],[83,1,85,9],[87,1,87,3],[63,1,63,3],[64,1,64,3],[65,1,65,3],[66,1,68,9],[71,0,71,9],[72,1,72,5],[72,6,72,9],[73,1,73,5],[73,6,73,9],[245,5,245,10],[246,1,248,9],[257,1,257,3],[298,1,300,9],[238,1,240,10],[237,1,237,5],[295,0,295,9],[296,1,296,3],[297,1,297,3],[297,5,297,10],[256,1,256,3],[258,1,258,3],[259,1,259,3],[260,1,262,10],[265,1,265,4],[236,1,236,5],[289,1,289,4],[290,1,292,10],[278,1,278,4],[279,1,279,5],[280,1,280,5],[281,1,281,5],[282,1,284,10],[286,1,286,4],[287,1,287,4],[288,1,288,4],[266,1,266,4],[267,1,269,10],[271,1,271,4],[272,1,272,5],[273,1,273,5],[274,1,276,10],[252,1,252,2],[252,4,252,6],[254,1,254,2],[253,4,253,6],[243,0,243,9],[244,1,244,3],[245,1,245,3],[10,1,12,9],[1,5,2,6],[4,2,4,3],[7,1,7,3],[8,1,8,3],[14,1,14,2],[50,1,50,3],[51,1,51,3],[52,1,54,9],[15,1,15,2],[16,1,16,2],[17,1,19,9],[21,1,21,3],[22,1,22,3],[23,1,23,3],[24,1,26,9],[28,1,28,3],[29,1,29,3],[30,1,30,3],[31,1,33,9],[35,1,35,3],[36,1,36,3],[38,1,40,9],[42,1,42,3],[74,1,74,5],[74,6,74,9],[75,1,75,5],[75,6,75,9],[76,1,76,5],[76,6,76,9],[77,1,79,9],[114,1,116,9],[82,1,82,4],[90,1,90,3],[97,1,97,3],[106,1,108,9],[111,0,111,9],[112,1,112,3],[113,1,113,3],[113,5,113,9],[98,1,98,3],[99,1,101,9],[103,1,103,4],[104,1,104,4],[105,1,105,4],[88,1,88,3],[89,1,89,3],[91,1,93,9],[95,1,95,3],[96,1,96,3],[140,1,140,3],[141,1,141,3],[143,1,143,3],[125,1,125,4],[127,1,127,4],[128,1,130,9],[132,1,132,3],[133,1,133,3],[120,1,120,2],[120,4,120,5],[122,1,122,2],[121,4,121,5],[124,1,124,4],[173,1,173,3],[173,5,173,9],[174,1,176,9],[126,1,126,4],[134,1,134,3],[142,1,142,3],[150,1,150,4],[164,1,164,4],[165,1,165,4],[166,1,168,9],[171,0,171,9],[172,1,172,3],[156,1,156,4],[157,1,157,4],[158,1,158,4],[159,1,161,9],[163,1,163,4],[144,1,146,9],[148,1,148,4],[149,1,149,4],[151,1,151,4],[152,1,154,9],[135,1,135,3],[136,1,138,9],[185,1,185,3],[186,1,186,3],[187,1,189,10],[192,1,192,4],[193,1,193,4],[180,1,180,2],[180,4,180,6],[182,1,182,2],[181,4,181,6],[184,1,184,3],[205,1,205,4],[206,1,206,5],[207,1,207,5],[208,1,210,10],[212,1,212,4],[194,1,196,10],[198,1,198,4],[199,1,199,5],[200,1,200,5],[201,1,203,10],[222,1,222,4],[224,1,226,10],[223,1,223,4],[213,1,213,5],[215,1,215,5],[216,1,218,10],[220,1,220,4],[221,1,221,4],[214,1,214,5]]}
[]
[null,null,"Water System",null,null,"NOTE: PLEASE ONLY INCLUDE ASSETS DELIVERED BY DEVELOPER AND NOT INSTALLED BY CITY CREWS"]
["Project Name/Address:",null,"Development Permit:"]
["Substantial Completion Date:",null,"Developer Name:"]
["Drawing ID:",null,"Developer Contributed: Y [    ]   N [    ]"]
[null,null,"CNV ONLY Project Number:"]
[null,null,null,null,null,null,null,null,"* If fair value or replacement value is not available, please use construction cost or a reasonable estimate."]
["Asset Type","Location/Asset Identifier",null,null,"Valve Type","Valve Size (mm)","Manufacturer","Joint Type","Contributed Asset Fair Value (or Replacement Value)","CNV ONLY\nConstruction cost","CNV ONLY\nInfor Asset ID","CNV ONLY\nFinance AV ID"]
["Valve"]
["Valve"]
[]
["Additional Notes:"]
[]
[]
["Asset Type","Address/Asset Identifier",null,"Location (EG: 4m E of SW LC)","S/L Type","Diameter (mm)","Pipe Type","Meter","Contributed Asset Fair Value (or Replacement Value)","CNV ONLY\nConstruction cost","CNV ONLY\nInfor Asset ID","CNV ONLY\nFinance AV ID"]
["Service Line"]
["Service Line"]
[]
["Additional Notes:"]
[]
[]
["Asset Type","Location/Asset Identifier",null,null,null,null,"Manufacturer",null,"Contributed Asset Fair Value (or Replacement Value)","CNV ONLY\nConstruction cost","CNV ONLY\nInfor Asset ID","CNV ONLY\nFinance AV ID"]
["Hydrant"]
["Hydrant"]
[]
["Additional Notes:"]
[]
[null,null,null,null,null,null,null,null,null,"From & To","From & To","From & To"]
["Asset Type","Location/Asset Identifier",null,null,null,"Diameter\n(mm)","Pipe Type","Length\n(meters)","Contributed Asset Fair Value (or Replacement Value)","CNV ONLY\nConstruction cost","CNV ONLY\nInfor Asset ID","CNV ONLY\nFinance AV ID"]
["Water Main"]
["Water Main"]
[]
["Additional Notes:"]
[]
[]
["Asset Type","Location/Asset Identifier",null,null,null,"Diameter\n(mm)","Pipe Type","Length\n(meters)","Contributed Asset Fair Value (or Replacement Value)","CNV ONLY\nConstruction cost","CNV ONLY\nInfor Asset ID","CNV ONLY\nFinance AV ID"]
["Irrigation"]
["Irrigation"]
[]
["Additional Notes:"]
[]
[]
["Asset Type","Location/Asset Identifier",null,null,null,null,null,null,"Contributed Asset Fair Value (or Replacement Value)","CNV ONLY\nConstruction cost","CNV ONLY\nInfor Asset ID","CNV ONLY\nFinance AV ID"]
["PRV"]
["PRV"]
[]
["Additional Notes:"]
[]
[]
["Asset Type","Location/Asset Identifier",null,null,null,null,null,null,"Contributed Asset Fair Value (or Replacement Value)","CNV ONLY\nConstruction cost","CNV ONLY\nInfor Asset ID","CNV ONLY\nFinance AV ID"]
["PRV Station"]
["PRV Station"]
[]
["Additional Notes:"]
[]
[]
["Asset Type","Location/Asset Identifier",null,null,null,null,null,null,"Contributed Asset Fair Value (or Replacement Value)","CNV ONLY\nConstruction cost","CNV ONLY\nInfor Asset ID","CNV ONLY\nFinance AV ID"]
["Pigging Station"]
["Pigging Station"]
[]
["Additional Notes:"]
[]
[]
["Asset Type","Location/Asset Identifier",null,null,null,"Zone","Flow",null,"Contributed Asset Fair Value (or Replacement Value)","CNV ONLY\nConstruction cost","CNV ONLY\nInfor Asset ID","CNV ONLY\nFinance AV ID"]
["Sample Station"]
["Sample Station"]
[]
["Additional Notes:"]
[]
[]
[]
["Disposed Assets "]
["Asset Type","Location/Asset Identifier ",null,null,null,null,"Note"]
[]
[]
[]
[]
[]
["Additional Notes:"]

{"sheet":"Water","index":1,"n_rows":79,"n_cols":12,"rows_kept":79,"cut":false,"hidden":false,"merged":[[4,2,4,3],[1,5,2,6],[77,1,79,9],[71,0,71,9],[31,1,33,9],[43,1,43,3],[45,1,47,9],[49,1,49,3],[50,1,50,3],[64,1,64,3],[66,1,68,9],[52,1,54,9],[51,1,51,3],[58,1,58,3],[56,1,56,3],[65,1,65,3],[7,1,7,3],[21,1,21,3],[22,1,22,3],[8,1,8,3],[42,1,42,3],[24,1,26,9],[17,1,19,9],[10,1,12,9],[28,1,28,3],[29,1,29,3],[14,1,14,2],[15,1,15,2],[16,1,16,2],[30,1,30,3],[23,1,23,3],[35,1,35,3],[36,1,36,3],[38,1,40,9],[75,6,75,9],[57,1,57,3],[76,6,76,9],[59,1,61,9],[63,1,63,3],[72,1,72,5],[73,1,73,5],[74,1,74,5],[75,1,75,5],[76,1,76,5],[72,6,72,9],[74,6,74,9],[73,6,73,9]]}
[]
[null,null,"Water System",null,null,"NOTE: PLEASE ONLY INCLUDE ASSETS DELIVERED BY DEVELOPER AND NOT INSTALLED BY CITY CREWS"]
["Project Name/Address:",null,"Development Permit:"]
["Substantial Completion Date:",null,"Developer Name:"]
["Drawing ID:",null,"Developer Contributed: Y [    ]   N [  ]",null,null,"Remember to includes disposed items - bottom of sheet:  ID numbers can be found on CItyMap and StaffMap"]
["CNV only: CD#",null,"CNV ONLY Project Number:"]
[null,null,null,null,null,null,null,null,"* If fair value or replacement value is not available, please use construction cost or a reasonable estimate."]
["Asset Type","Location/Asset Identifier",null,null,"Valve Type","Valve Size (mm)","Manufacturer","Joint Type","Contributed Asset Fair Value (or Replacement Value)","CNV ONLY\nConstruction cost","CNV ONLY\nInfor Asset ID","CNV ONLY\nFinance AV ID"]
["Valve"]
["Valve"]
[]
["Additional Notes:"]
[]
[]
["Asset Type","Address/Asset Identifier",null,"Location (EG: 4m E of SW LC)","S/L Type","Diameter (mm)","Pipe Type","Meter","Contributed Asset Fair Value (or Replacement Value)","CNV ONLY\nConstruction cost","CNV ONLY\nInfor Asset ID","CNV ONLY\nFinance AV ID"]
["Service Line"]
["Service Line"]
[]
["Additional Notes:"]
[]
[]
["Asset Type","Location/Asset Identifier",null,null,null,null,"Manufacturer",null,"Contributed Asset Fair Value (or Replacement Value)","CNV ONLY\nConstruction cost","CNV ONLY\nInfor Asset ID","CNV ONLY\nFinance AV ID"]
["Hydrant"]
["Hydrant"]
[]
["Additional Notes:"]
[]
[null,null,null,null,null,null,null,null,null,"From & To","From & To","From & To"]
["Asset Type","Location/Asset Identifier",null,null,null,"Diameter\n(mm)","Pipe Type","Length\n(meters)","Contributed Asset Fair Value (or Replacement Value)","CNV ONLY\nConstruction cost","CNV ONLY\nInfor Asset ID","CNV ONLY\nFinance AV ID"]
["Water Main"]
["Water Main"]
[]
["Additional Notes:"]
[]
[]
["Asset Type","Location/Asset Identifier",null,null,null,"Diameter\n(mm)","Pipe Type","Length\n(meters)","Contributed Asset Fair Value (or Replacement Value)","CNV ONLY\nConstruction cost","CNV ONLY\nInfor Asset ID","CNV ONLY\nFinance AV ID"]
["Irrigation"]
["Irrigation"]
[]
["Additional Notes:"]
[]
[]
["Asset Type","Location/Asset Identifier",null,null,null,null,null,null,"Contributed Asset Fair Value (or Replacement Value)","CNV ONLY\nConstruction cost","CNV ONLY\nInfor Asset ID","CNV ONLY\nFinance AV ID"]
["PRV"]
["PRV"]
[]
["Additional Notes:"]
[]
[]
["Asset Type","Location/Asset Identifier",null,null,null,null,null,null,"Contributed Asset Fair Value (or Replacement Value)","CNV ONLY\nConstruction cost","CNV ONLY\nInfor Asset ID","CNV ONLY\nFinance AV ID"]
["PRV Station"]
["PRV Station"]
[]
["Additional Notes:"]
[]
[]
["Asset Type","Location/Asset Identifier",null,null,null,null,null,null,"Contributed Asset Fair Value (or Replacement Value)","CNV ONLY\nConstruction cost","CNV ONLY\nInfor Asset ID","CNV ONLY\nFinance AV ID"]
["Pigging Station"]
["Pigging Station"]
[]
["Additional Notes:"]
[]
[]
["Asset Type","Location/Asset Identifier",null,null,null,"Zone","Flow",null,"Contributed Asset Fair Value (or Replacement Value)","CNV ONLY\nConstruction cost","CNV ONLY\nInfor Asset ID","CNV ONLY\nFinance AV ID"]
["Sample Station"]
["Sample Station"]
[]
["Additional Notes:"]
[]
[]
[]
["Disposed Assets "]
["Asset Type","Location/Asset Identifier ",null,null,null,null,"Note"]
[]
[]
[]
[]
[]
["Additional Notes:"]

{"sheet":"Sewer Sanitary","index":2,"n_rows":51,"n_cols":12,"rows_kept":51,"cut":false,"hidden":false,"merged":[[37,1,37,3],[44,1,44,5],[45,1,45,5],[17,1,19,9],[43,0,43,9],[31,1,33,11],[45,6,45,9],[38,1,40,9],[23,1,23,2],[24,1,26,10],[49,1,51,9],[48,1,48,5],[46,1,46,5],[47,1,47,5],[48,6,48,9],[46,6,46,9],[47,6,47,9],[1,5,2,6],[29,1,29,2],[30,1,30,2],[35,1,35,3],[36,1,36,3],[28,1,28,2],[9,1,9,3],[7,1,7,3],[8,1,8,3],[14,1,14,2],[15,1,15,2],[16,1,16,2],[4,2,4,3],[10,1,12,9],[21,1,21,2],[22,1,22,2]]}
[]
[null,null,"Sanitary Sewer System",null,null,"NOTE: PLEASE ONLY INCLUDE ASSETS DELIVERED BY DEVELOPER AND NOT INSTALLED BY CITY CREWS"]
["Project Name/Address:",null,"Development Permit:"]
["Substantial Completion Date:",null,"Developer Name:"]
["Drawing ID:",null,"Developer Contributed: Y [    ]   N [  ]",null,null,"Remember to includes disposed items - bottom of sheet:  ID numbers can be found on CItyMap and StaffMap"]
["CNV only: CD#",null,"CNV ONLY Project Number:"]
[null,null,null,null,null,null,null,null,"* If fair value or replacement value is not available, please use construction cost or a reasonable estimate."]
["Asset Type","Location/Asset Identifier",null,null,"Diameter\n(mm)","Depth\n(meters)","Rim Elevation\n(meters)","Invert Elevation (meters)","Contributed Asset Fair Value (or Replacement Value)","CNV ONLY\nConstruction cost","CNV ONLY\nInfor Asset ID","CNV ONLY\nFinance AV ID"]
["Manhole or Cleanout"]
["Manhole"]
[]
["Additional Notes:"]
[]
[]
["Asset Type","Address/Asset Identifier",null,"Location (EG: 4m E of SW LC)","Diameter          (mm)","Pipe Type","Inspection Chamber","Invert Elevation (meters)","Contributed Asset Fair Value (or Replacement Value)","CNV ONLY\nConstruction cost","CNV ONLY\nInfor Asset ID","CNV ONLY\nFinance AV ID"]
["Service Line"]
["Service Line"]
[]
["Additional Notes:"]
[]
[]
["Asset Type","Address/Asset Identifier",null,"Location (EG: 4m E of SW LC)","Diameter          (mm)","Pipe Type",null,"Invert Elevation at Main (meters)","Contributed Asset Fair Value (or Replacement Value)","CNV ONLY\nConstruction cost","CNV ONLY\nInfor Asset ID","CNV ONLY\nFinance AV ID"]
["Service Wye"]
["Service Wye"]
[null,"*these are wyes for future services that are not connected to the property yet. Invert elevation at main required."]
["Additional Notes:"]
[]
[]
["Asset Type","Location/Asset Identifier",null,"Average DEPTH (Meters)","Pipe Type","Diameter          (mm)","Length (meters)","Percentage (%) of Grade","Contributed Asset Fair Value (or Replacement Value)","CNV ONLY\nConstruction cost","CNV ONLY\nInfor Asset ID","CNV ONLY\nFinance AV ID"]
["Sanitary Main"]
["Sanitary Main"]
[]
["Additional Notes:"]
[]
[null,null,null,null,null,null,null,null,"From & To"]
["Asset Type","Location/Asset Identifier",null,null,null,"Model (#) Number","Serial (#)              Number",null,"Contributed Asset Fair Value (or Replacement Value)","CNV ONLY\nConstruction cost","CNV ONLY\nInfor Asset ID","CNV ONLY\nFinance AV ID"]
["Lift Station "]
["Lift Station "]
[]
["Additional Notes:"]
[]
[]
[]
["Disposed Assets "]
["Asset Type","Location/Asset Identifier ",null,null,null,null,"Note"]
[]
[]
[]
[]
[]
["Additional Notes:"]

{"sheet":"Storm and Drainage","index":3,"n_rows":97,"n_cols":13,"rows_kept":97,"cut":false,"hidden":false,"merged":[[65,1,65,2],[74,1,74,2],[21,1,21,2],[22,1,22,2],[23,1,23,2],[28,1,28,2],[37,1,37,3],[24,1,26,10],[31,1,33,10],[1,5,2,7],[29,1,29,2],[30,1,30,2],[75,1,75,3],[36,1,36,3],[7,1,7,2],[35,1,35,2],[42,1,42,2],[51,1,51,2],[58,1,58,2],[43,1,43,3],[47,1,47,3],[38,1,40,10],[10,1,12,10],[4,2,4,3],[70,1,72,10],[93,1,93,5],[90,1,90,2],[74,7,74,8],[75,7,75,8],[90,7,90,10],[84,1,86,10],[77,1,79,10],[81,1,81,2],[81,7,81,8],[82,1,82,3],[82,7,82,8],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,19,10],[95,1,97,10],[61,1,63,10],[52,1,52,3],[54,1,56,10],[59,1,59,3],[53,1,53,3],[60,1,60,3],[89,0,89,10],[66,1,66,3],[69,1,69,3],[91,1,91,5],[92,1,92,5]]}
[]
[null,null,"Storm and Drainage System",null,null,"NOTE: PLEASE ONLY INCLUDE ASSETS DELIVERED BY DEVELOPER AND NOT INSTALLED BY CITY CREWS"]
["Project Name/Address:",null,"Development Permit:"]
["Substantial Completion Date:",null,"Developer Name:"]
["Drawing ID:",null,"Developer Contributed: Y [    ]   N [ ]",null,null,"Remember to includes disposed items - bottom of sheet:  ID numbers can be found on CItyMap and StaffMap"]
["CNV only: CD#",null,"CNV ONLY Project Number:"]
[null,null,null,null,null,null,null,null,null,"* If fair value or replacement value is not available, please use construction cost or a reasonable estimate."]
["Asset Type","Location/Asset Identifier",null,null,"Diameter\n(mm)","Depth\n(meters)","Storm or Cleanout","Rim Elevation\n(meters)","Invert Elevation (meters)","Contributed Asset Fair Value (or Replacement Value)","CNV ONLY\nConstruction cost","CNV ONLY\nInfor Asset ID","CNV ONLY\nFinance AV ID"]
["Manhole or Cleanout"]
["Manhole"]
[]
["Additional Notes:"]
[]
[]
["Asset Type","Address/Asset Identifier",null,"Location (EG: 4m E of SW LC)","Diameter          (mm)","Depth\n(meters)","Pipe Type","Inspection Chamber","Invert Elevation (meters)","Contributed Asset Fair Value (or Replacement Value)","CNV ONLY\nConstruction cost","CNV ONLY\nInfor Asset ID","CNV ONLY\nFinance AV ID"]
["Service Line"]
["Service Line"]
[]
["Additional Notes:"]
[]
[]
["Asset Type","Address/Asset Identifier",null,"Location (EG: 4m E of SW LC)","Diameter          (mm)",null,"Pipe Type",null,"Invert Elevation at Main (meters)","Contributed Asset Fair Value (or Replacement Value)","CNV ONLY\nConstruction cost","CNV ONLY\nInfor Asset ID","CNV ONLY\nFinance AV ID"]
["Service Wye"]
["Service Wye"]
[null,"*these are wyes for future services that are not connected to the property yet. Invert elevation at main required."]
["Additional Notes:"]
[]
[]
["Asset Type","Location/Asset Identifier",null,null,null,"Diameter          (mm)","Length (meters)","Pipe Type","Percentage (%) of Grade","Contributed Asset Fair Value (or Replacement Value)","CNV ONLY\nConstruction cost","CNV ONLY\nInfor Asset ID","CNV ONLY\nFinance AV ID"]
["Storm Main"]
["Storm Main"]
[]
["Additional Notes:"]
[]
[null,null,null,null,null,null,null,null,null,"From & To"]
["Asset Type","Location/Asset Identifier",null,null,"Lead Diameter (mm)","Lead Length (meters)","Sump or \nNon-Sump","Rim Elevation\n(meters)","Invert Elevation (meters)","Contributed Asset Fair Value (or Replacement Value)","CNV ONLY\nConstruction cost","CNV ONLY\nInfor Asset ID","CNV ONLY\nFinance AV ID"]
["Catch Basin"]
["Catch Basin"]
[null,"*Includes CB lead costs"]
["Additional Notes:"]
[]
[]
["Asset Type","Location/Asset Identifier",null,null,"Lead Diameter (mm)","Lead Length (meters) ","Type","Rim Elevation\n(meters)","Invert Elevation (meters)","Contributed Asset Fair Value (or Replacement Value)","CNV ONLY\nConstruction cost","CNV ONLY\nInfor Asset ID","CNV ONLY\nFinance AV ID"]
["Lawn Basin"]
[]
[]
[]
["Lawn Basin"]
[]
["Additional Notes:"]
[]
["Asset Type","Location/Asset Identifier",null,null,null,null,null,null,null,"Contributed Asset Fair Value (or Replacement Value)","CNV ONLY\nConstruction cost","CNV ONLY\nInfor Asset ID","CNV ONLY\nFinance AV ID"]
["Inlet"]
["Inlet"]
[]
["Additional Notes:"]
[]
[]
["Asset Type","Location/Asset Identifier",null,null,"Width (meters)","Length (m)","Depth(m)",null,null,"Contributed Asset Fair Value (or Replacement Value)","CNV ONLY\nConstruction cost","CNV ONLY\nInfor Asset ID","CNV ONLY\nFinance AV ID"]
["Swale"]
["Swale"]
[null,"NOTE: These are linear swales, concrete, grassed…  'bioswales\" with area are to bu include under Raingardens"]
["Additional Notes:"]
[]
[]
["Asset Type","Location/Asset Identifier",null,null,"Area (meters)","Length (m)",null,null,null,"Contributed Asset Fair Value (or Replacement Value)","CNV ONLY\nConstruction cost","CNV ONLY\nInfor Asset ID","CNV ONLY\nFinance AV ID"]
["Raingarden"]
["Raingarden"]
["Raingarden"]
["Raingarden"]
[null,"NOTE: these include 'Bioswales that are not just linear, they have an 'area'"]
["Additional Notes:"]
[]
[]
["Asset Type","Location/Asset Identifier",null,null,"Width (meters)","Length (meters)","Depth\n(meters)","Manufacturer",null,"Contributed Asset Fair Value (or Replacement Value)","CNV ONLY\nConstruction cost","CNV ONLY\nInfor Asset ID","CNV ONLY\nFinance AV ID"]
["Structural soil/Soil Cell"]
["Soil Cell"]
[]
["Additional Notes:"]
[]
[]
["Asset Type","Location/Asset Identifier",null,null,"Width (meters)","Length (meters)","Depth\n(meters)","Manufacturer",null,"Contributed Asset Fair Value (or Replacement Value)","CNV ONLY\nConstruction cost","CNV ONLY\nInfor Asset ID","CNV ONLY\nFinance AV ID"]
["Oil Grit Separator"]
["Oil Grit Separator"]
[]
["Additional Notes:"]
[]
[]
[]
["Disposed Assets "]
["Asset Type","Location/Asset Identifier ",null,null,null,null,"Note"]
[]
[]
[]
[]
[]
["Additional Notes:"]

{"sheet":"Streets","index":4,"n_rows":103,"n_cols":14,"rows_kept":103,"cut":false,"hidden":false,"merged":[[4,2,4,3],[46,1,46,2],[67,1,67,2],[74,1,74,2],[39,1,39,2],[42,1,44,12],[54,1,54,4],[61,1,61,4],[68,1,68,4],[60,1,60,2],[7,1,7,2],[10,1,12,12],[14,1,14,2],[15,1,15,2],[20,1,20,2],[26,1,26,2],[1,5,2,6],[101,1,103,7],[8,1,8,2],[49,1,51,12],[56,1,58,12],[62,1,62,4],[55,1,55,4],[9,1,9,2],[48,1,48,4],[40,1,40,3],[41,1,41,3],[47,1,47,4],[35,1,37,12],[21,1,21,9],[25,1,25,2],[53,1,53,2],[27,1,27,2],[22,1,22,9],[23,1,23,9],[89,0,89,7],[70,1,72,12],[69,1,69,4],[75,1,75,4],[76,1,76,4],[77,1,79,12],[84,1,84,12],[85,1,85,12],[86,1,86,12],[92,1,92,6],[96,1,96,6],[100,1,100,6],[90,7,90,12],[91,7,91,12],[92,7,92,12],[96,7,96,12],[100,7,100,12],[90,1,90,6],[91,1,91,6]]}
[]
[null,null,"Streets System",null,null,"NOTE: PLEASE ONLY INCLUDE ASSETS DELIVERED BY DEVELOPER AND NOT ASSETS INSTALLED BY CITY CREWS"]
["Project Name/Address:",null,"Development Permit:"]
["Substantial Completion Date:",null,"Developer Name:"]
["Drawing ID:",null,"Developer Contributed: Y [  x  ]   N [X ]",null,null,"Remember to include Street lights"]
["CNV only: CD#",null,"CNV ONLY Project Number:",null,null,"Note: tempoary curbs and walks are not included"]
[null,null,null,null,null,null,null,null,null,null,"* If fair value or replacement value is not available, please use construction cost or a reasonable estimate."]
["Asset Type","Location/Asset Identifier",null,null,"Surface Type",null,"Depth\n(Millimeters)","Width (Meters)","Area                            (Sq Meters)","Length               (Meters)","Contributed Asset Fair Value (or Replacement Value)","CNV ONLY\nConstruction cost","CNV ONLY\nInfor Asset ID","CNV ONLY\nFinance AV ID"]
["Street Segment"]
["Street Segment"]
[]
["Additional Notes:"]
[]
[]
["Asset Type","Location/Asset Identifier",null,"Street Side","Sidewalk Type",null," Material","Width (m)","Length (m)","Letdowns (#)","Contributed Asset Fair Value (or Replacement Value)","CNV ONLY\nConstruction cost","CNV ONLY\nInfor Asset ID","CNV ONLY\nFinance AV ID"]
["Sidewalk "]
["Sidewalk "]
["Sidewalk "]
["Sidewalk "]
[]
["Sidewalk "]
[]
["Additional Notes:"]
[]
[]
["Asset Type","Location/Asset Identifier",null,"Street Side","Length (meters)"," Material",null,null,null,null,"Contributed Asset Fair Value (or Replacement Value)","CNV ONLY\nConstruction cost","CNV ONLY\nInfor Asset ID","CNV ONLY\nFinance AV ID"]
["Curb and Gutter"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Additional Notes:"]
[]
[]
["Asset Type","Location/Asset Identifier",null,null,"Street Side","Qty","Surface Type","Extrusion Width            (Meters)",null,null,"Contributed Asset Fair Value (or Replacement Value)","CNV ONLY\nConstruction cost","CNV ONLY\nInfor Asset ID","CNV ONLY\nInfor Asset ID"]
["Curb Extension"]
["Curb Extension"]
[]
["Additional Notes:"]
[]
[]
["Asset Type","Location/Asset Identifier",null,null,null,"Material Type","Angle","Thickness           (mm)",null,"Length               (Meters)","Contributed Asset Fair Value (or Replacement Value)","CNV ONLY\nConstruction cost","CNV ONLY\nInfor Asset ID","CNV ONLY\nFinance AV ID"]
["Retaining Walls"]
["Retaining Walls"]
[]
["Additional Notes:"]
[]
[]
["Asset Type","Location/Asset Identifier",null,null,null,"Bridge Surface",null,null,null,null,"Contributed Asset Fair Value (or Replacement Value)","CNV ONLY\nConstruction cost","CNV ONLY\nInfor Asset ID","CNV ONLY\nFinance AV ID"]
["Bridges"]
["Bridges"]
[]
["Additional Notes:"]
[]
[]
["Asset Type","Location/Asset Identifier",null,null,null,"Street Light #/ID","Foundation Type","Pole Type","Paint Colour","Pole Height (meters)","Contributed Asset Fair Value (or Replacement Value)","CNV ONLY\nConstruction cost","CNV ONLY\nInfor Asset ID","CNV ONLY\nFinance AV ID"]
["Street Light ",null,null,null,null,"CNV ONLY"]
["Street Light ",null,null,null,null,"CNV ONLY"]
[]
["Additional Notes:"]
[]
[]
["Asset Type","Location/Asset Identifier",null,null,null,null,null,null,null,null,"Contributed Asset Fair Value (or Replacement Value)","CNV ONLY\nConstruction cost","CNV ONLY\nInfor Asset ID","CNV ONLY\nFinance AV ID"]
["Traffic Signals"]
["Traffic Signals"]
[]
["Additional Notes:"]
[]
[]
["Asset Type","Location/Asset Identifier",null,null,null,"Sign # ","Type ",null,null,null,"Contributed Asset Fair Value (or Replacement Value)","CNV ONLY\nConstruction cost","CNV ONLY\nInfor Asset ID","CNV ONLY\nFinance AV ID"]
["Street Sign"]
["Street Sign"]
[]
["Additional Notes:"]
[]
[]
["Asset Type","Location/Asset Identifier","Qty","Common Name ","Tree Grate","Genus","Species","Variety",null,"Caliper (cm)","Contributed Asset Fair Value","CNV ONLY\nConstruction cost","CNV ONLY\nInfor Asset ID","CNV ONLY\nInfor Asset ID"]
["Tree"]
["Tree"]
[]
["Additional Notes:"]
[]
[]
[]
["Disposed Assets "]
["Asset Type","Location/Asset Identifier ",null,null,null,null,null,"Note "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Additional Notes:"]

{"sheet":"Parks","index":5,"n_rows":84,"n_cols":14,"rows_kept":84,"cut":false,"hidden":false,"merged":[[4,2,4,3],[81,1,81,5],[81,6,81,7],[76,0,76,7],[81,10,81,11],[79,1,79,5],[77,1,77,5],[77,6,77,7],[78,1,78,5],[68,1,68,3],[69,1,69,3],[70,1,70,3],[71,1,73,7],[40,1,40,2],[41,1,41,2],[42,1,42,2],[80,1,80,5],[63,1,63,3],[82,10,84,11],[78,10,78,11],[79,10,79,11],[80,10,80,11],[78,6,78,7],[79,6,79,7],[80,6,80,7],[57,1,59,11],[47,1,47,2],[1,5,2,6],[82,1,84,7],[64,1,66,7],[7,1,7,3],[8,1,8,3],[29,1,31,7],[43,1,45,7],[48,1,48,3],[61,1,61,3],[62,1,62,3],[50,1,52,7],[49,1,49,3],[28,1,28,3],[36,1,38,7]]}
[]
[null,null,"PARKS SYSTEM",null,null,"NOTE: PLEASE ONLY INCLUDE ASSETS DELIVERED BY DEVELOPER/CONTRACTOR AND NOT INSTALLED BY CITY CREWS"]
["Project Name/Address:",null,"Development Permit:"]
["Substantial Completion Date:",null,"Developer Name:"]
["Drawing ID:",null,"Developer Contributed: Y [    ]   N [    ]"]
[null,null,"CNV ONLY Project Number:"]
[null,null,null,null,null,null,null,null,null,null,"* If fair value or replacement value is not available, please use construction cost or a reasonable estimate."]
["Park Structure\nAsset Type","Location/Asset Identifier",null,null,"Description","Quantity","Length(m)",null,null,null,"Contributed Asset Fair Value (or Replacement Value)","CNV ONLY\nConstruction cost","CNV ONLY\nInfor Asset ID","CNV ONLY\nFinance AV ID"]
["Art"]
["Bench"]
["Bridge"]
["Fountain-Decorative"]
["Fountain-Drinking"]
["Park Building"]
["Parking Lot"]
["Playstructure- Climbing Poles"]
["Playstructure- Climbing Wall"]
["Playstructure- Mixing Table"]
["Playstructure- Sandbox"]
["Playstructure- Slide"]
["Playstructure- Swing Sets"]
["Playstructure- Zipline"]
["Playstructure-Other"]
["Receptacle-Recycling"]
["Receptacle-Trash"]
["Retaining Wall"]
["Rubber Hill"]
["Signage"]
["Unlisted - Other please describe"]
[]
["Additional Notes:"]
[]
[]
["Trees\nAsset Type","Location/Asset Identifier","Qty","Common Name ","Tree Grate","Genus","Species","Variety","Caliper (cm)",null,"Contributed Asset Fair Value","CNV ONLY\nConstruction cost","CNV ONLY\nInfor Asset ID","CNV ONLY\nFinance AV ID"]
[]
[]
[]
["Additional Notes:"]
[]
[]
["Sidewalk/Trail\nAsset Type","Location/Asset Identifier",null,"Street Side","Curb Type","Sidewalk Type"," Material","Width (m)","Length (m)","Letdowns (#)","Contributed Asset Fair Value","CNV ONLY\nConstruction cost","CNV ONLY\nInfor Asset ID","CNV ONLY\nFinance AV ID"]
[]
[]
[]
["Additional Notes:"]
[]
[]
["Park Light\nAsset Type","Location/Asset Identifier",null,null,null,"Street Light #/ID","Foundation Type","Pole Type","Paint Colour","Pole Height (meters)","Contributed Asset Fair Value","CNV ONLY\nConstruction cost","CNV ONLY\nInfor Asset ID","CNV ONLY\nFinance AV ID"]
[null,null,null,null,null,"CNV ONLY"]
[null,null,null,null,null,"CNV ONLY"]
[null,"Please include Conduit and Cables ( Length and Type)"]
["Additional Notes:"]
[]
[]
["Asset Type","Location/Asset Identifier/Light #","Luminaire #","Model # ","Luminaire Type","Lamp Watts","Distribution Type","Manufacturer","Lamp Type ",null,"Contributed Asset Fair Value","CNV ONLY\nConstruction cost","CNV ONLY\nInfor Asset ID","CNV ONLY\nFinance AV ID"]
["Luminaire"]
["Luminaire"]
[]
["Additional Notes:"]
[]
[]
["\nAsset Type","Location/Asset Identifier",null,null,"Material or Manufacturer","Width (meters)","Length (m)","Depth(m)",null,null,"Contributed Asset Fair Value","CNV ONLY\nConstruction cost","CNV ONLY\nInfor Asset ID","CNV ONLY\nFinance AV ID"]
[]
[]
[]
["Additional Notes:"]
[]
[]
["\nAsset Type","Location/Asset Identifier",null,null,"Material or Manufacturer","Width (meters)","Length (m)","Depth(m)",null,null,"Contributed Asset Fair Value","CNV ONLY\nConstruction cost","CNV ONLY\nInfor Asset ID","CNV ONLY\nFinance AV ID"]
[]
[]
[]
["Additional Notes:"]
[]
[]
[]
["Disposed Assets "]
["Asset Type","Location/Asset Identifier ",null,null,null,null,"Note"]
[]
[]
[]
[]
[]
["Additional Notes:"]

{"sheet":"Sheet10","index":6,"n_rows":30,"n_cols":14,"rows_kept":30,"cut":false,"hidden":false,"merged":[[28,1,30,13],[4,1,4,4],[5,1,5,4],[7,1,9,13],[11,1,11,4],[12,1,12,4],[14,1,16,13],[18,1,18,4],[19,1,19,4],[21,1,23,13],[25,1,25,4],[26,1,26,4]]}
[null,null,null,null,null,null,"Water System"]
["Project Name:",null,null,"Development Permit"]
["Group Project #",null,null,"Developer Name"]
["Drawing ID"]
["Asset Type","Location/Asset Identifier",null,null,null,"Valve Type","Valve Size","Joint Type","Mfg","Install Date","W/O#","(A)dd   (R)eplace   (E)xpire","Existing Hansen ID                                      (for Replaced or Expired Assets)","New Hansen ID (forReplaced or Added Assets)"]
["Valve"]
["Valve"]
[]
["Additional Notes:"]
[]
[]
["Asset Type","Location/Asset Identifier",null,null,null,"S/L Type","Pipe Type","Diameter","Meter","Install Date","W/O#","(A)dd   (R)eplace   (E)xpire","Existing Hansen ID                                      (for Replaced or Expired Assets)","New Hansen ID (forReplaced or Added Assets)"]
["Service Line"]
["Service Line"]
[]
["Additional Notes:"]
[]
[]
["Asset Type","Location/Asset Identifier",null,null,null,"Hydrant Type","Paint Colour","Base Type","Year Painted","Install Date","W/O#","(A)dd   (R)eplace   (E)xpire","Existing Hansen ID                                      (for Replaced or Expired Assets)","New Hansen ID (forReplaced or Added Assets)"]
["Hydrant"]
["Hydrant"]
[]
["Additional Notes:"]
[]
[]
["Asset Type","Location/Asset Identifier",null,null,null,"Pipe Type","Diameter","Length","From ID  to ID","Install Date","W/O#","(A)dd   (R)eplace   (E)xpire","Existing Hansen ID                                      (for Replaced or Expired Assets)","New Hansen ID (forReplaced or Added Assets)"]
["Water Main"]
["Water Main"]
[]
["Additional Notes:"]

{"sheet":"LIST","index":7,"n_rows":32,"n_cols":19,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
["AIR ","COMMERCIAL","13mm","PVC","Yes","CLOW VALVE","FL X MJ","Yes","Storm","PVC","CURB","Arterial","ALUMINIUM","GRASS","REINFORCED CONCRETE","WOOD","PATH/TRAIL","NORTH","Sump"]
["BLOW OFF","DOMESTIC  ","19mm","CAST IRON","No","TERM CITY","MJ X MJ","No","Cleanout","CONCRETE","BOULEVARD","Collector","ASPHALT","GRAVEL","CONCRETE BLOCK","CONCRETE","CURB","SOUTH","Non-Sump"]
["CONNECTION","PRIVATE","25mm","COPPER","Box Only",null,"FL X FL",null,null,"CAST IRON","MONOLITHIC",null,"BARREL 45 GAL","CONCRETE","BRICK MASONARY","ASPHALT","BOULEVARD","EAST"]
["FIRE","INDUSTRIAL","38mm","DUCTILE IRON",null,null,null,null,null,"BACK OF WALK TILE","PATH/TRAIL",null,"BOARDWALK","ASPHALT","WIRE BASKET WITH ROCK FACE","OTHER",null,"WEST"]
["HYDRANT","HYDRANT","50mm","CONCRETE",null,null,null,null,null,"CULVERT","NONE",null,"BOLLARD","PAVERS","WIRE BASKET WITH VEGETATED FACE"]
["IRRIGATION","FIRE","75mm","VIT",null,null,null,null,null,"DUCTILE IRON","OTHER",null,"CHAIN","DIRT","TIMBER"]
["MAIN LINE LINEGATE","INSTITUTIONAL","100mm","HIGH DENSITY POLYETHYLENE",null,null,null,null,null,"VIT",null,null,"CHAIN LINK","WOOD","STEEL"]
["MAIN LINE EAST","IRRIGATION","150mm","STEEL",null,null,null,null,null,"STEEL",null,null,"CONCRETE","BRICKS","OTHER"]
["MAIN LINE WEST","DOMESTIC FIRE","200mm","GALVANIZED STEEL",null,null,null,null,null,"FLUME",null,null,"DROP B","OTHER"]
["MAIN LINE NORTH","UNKNOWN",null,"ARM",null,null,null,null,null,"HIGH DENSITY POLYETHYLENE",null,null,"FANCY "]
["MAIN LINE SOUTH",null,null,"ASBESTOS CONCRETE",null,null,null,null,null,"NON-CORRODE",null,null,"GRANITE"]
["METER",null,null,"OTHER",null,null,null,null,null,"NOCO",null,null,"GRAVEL"]
["PIG",null,null,null,null,null,null,null,null,"CORRUGATED IRON PIPE",null,null,"INGROUND SKOOKUM"]
["SURGE RELIEF VALVE",null,null,null,null,null,null,null,null,"CORRUGATED METAL PIPE",null,null,"LINK"]
["ZONE",null,null,null,null,null,null,null,null,"CHORINATED POLY VINYL CHLORIDE",null,null,"METAL AND WOOD"]
[null,null,null,null,null,null,null,null,null,"BIG O",null,null,"MASONRY"]
[null,null,null,null,null,null,null,null,null,"ARMCO",null,null,"MEMORIAL"]
[null,null,null,null,null,null,null,null,null,"ARM",null,null,"METAL   "]
[null,null,null,null,null,null,null,null,null,"OTHER",null,null,"MIXED MATERIAL"]
[null,null,null,null,null,null,null,null,null,"UNKNOWN",null,null,"MULCH"]
[]
["WATER VALVE TYPE","WATER service line type","size","WATER PIPE TYPE","meter","mfg","JOINT TYPE","Inspection Chamber","storm drainage","storm PIPE TYPE","SIDEWALK  ","street segment","STREET MATERIAL","SURFACE TYPE and  MATERIAL","RETAINING WALLS","BRIDGES SURFACE","CURB TYPE","STREET SIDE"]
["VALVE","SERV","SIZE","PIPETYPE","METER","MFG","JOINT","IC","manhole","STORMPIPETYPE","SIDEWALKTYPE","streetsegment","MATERIAL","SURFACE","RETAINING","BRIDGE","CURBTYPE","DIRECTION"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Assets"]

{"sheet":"List 2","index":8,"n_rows":32,"n_cols":11,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
["Pole Type","Paint Type","Foundation Type","Luminaire Type","Distribution Type","Manufacturer","Lamp Type",null,"Park Structures","Utility Asset Types","Streets"]
["14THPLAZA","BLACK","BOLLARD","COBRAHD","ARTERIAL","ARL","CFL",null,"Art","Backflow Preventer","Sidewalk"]
["BOLLARD","BLUE","MMCD_B","DECORATIVE","COLLECTOR ","ARGO","HPS",null,"Bench","Bioswale","Trail"]
[null,null,null,"OTHER","LOCAL","ARI VALVES","LED",null,"Bridge"]
[null,null,null,"PEDESTRAIN","OTHER","ARIENS","LED_DIM",null,"Fountain-Decorative"]
[null,null,null,"TUNNEL","PEDESTRAIN","ATCO","MH",null,"Fountain-Drinking"]
[null,null,null,"UNDERWATER","SPORTS","AUTOCAR","OTHER",null,"Park Building"]
[null,null,null,"WALL",null,"BARTELL",null,null,"Parking Lot"]
["ESPLANADE","GALVANIZED","MMCD_C",null,null,"BE",null,null,"Playstructure- Climbing Poles","Cleanout"]
["GREENNECK","GREEN","MMCD_CSERV",null,null,"BILLY GOAT",null,null,"Playstructure- Climbing Wall","Hydrant"]
["JACKLOUCKS","OTHER","NON_MMCD",null,null,"BLUE POINT",null,null,"Playstructure- Mixing Table","Main"]
["MARINEDR",null,"OTHER",null,null,"BOBCAT",null,null,"Playstructure- Sandbox","Manhole"]
["OCTDDAVIT",null,null,null,null,"BOSCH",null,null,"Playstructure- Slide","Meter"]
["OCTDDAVITB",null,null,null,null,null,null,null,"Playstructure- Swing Sets","Miscellaneous"]
["OCTPOSTTOP",null,null,null,null,"C.P.",null,null,"Playstructure- Zipline","Node"]
["OCTSDAVIT",null,null,null,null,null,null,null,"Playstructure-Other","Pump"]
["OCTSDAVITB",null,null,null,null,"CANOX",null,null,"Receptacle-Recycling","Rain Garden"]
["OTHER",null,null,null,null,"CARAVAN",null,null,"Receptacle-Trash","Service Line"]
[null,null,null,null,null,"CENTRAL",null,null,"Retaining Wall"]
["SQUARE",null,null,null,null,"CENTURION",null,null,"Rubber Hill","Station - Pigging"]
[null,null,null,null,null,"CHEVROLET",null,null,"Signage"]
[null,null,null,null,null,"CLOW VALVE",null,null,"Unlisted - Other please describe","Station - PRV"]
[null,null,null,null,null,"COMET",null,null,null,"Station - Water Quality"]
[null,null,null,null,null,"COOPER",null,null,null,"Station - Water Sampling"]
[null,null,null,null,null,"COOPERICON",null,null,null,"Storage Basin"]
[null,null,null,null,null,"COOPERSLID",null,null,null,"Valve"]
[null,null,null,null,null,"COOPERSTRU"]
[null,null,null,null,null,"LUMCA"]
[null,null,null,null,null,"LUMEC"]
[null,null,null,null,null,"PACE SLOOP"]
[null,null,null,null,null,"PHILIPS"]
[null,null,null,null,null,"SELUXCORRA"]