{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Submission Form","Naming Conventions","Project Types","Capitalization Policy"],"not_rendered":{"images":32,"defined_names":8},"read":"whole","date_system":"1900"}

{"sheet":"Submission Form","index":0,"n_rows":317,"n_cols":9,"rows_kept":317,"merged":[[0,0,3,2],[0,3,0,5],[0,8,3,8],[4,0,4,5],[5,1,5,2],[5,8,46,8],[46,1,46,5],[62,1,62,2],[62,8,64,8],[63,1,63,5],[169,1,169,2],[177,1,177,2],[177,8,180,8],[178,1,178,5],[213,1,213,5],[214,1,214,5],[216,0,216,5],[220,1,220,5],[235,1,235,2],[235,8,238,8],[237,1,237,2],[239,1,239,2],[240,1,240,5],[240,8,242,8],[258,1,258,5],[262,1,262,5],[264,1,264,2],[264,8,267,8],[266,1,266,2],[268,1,268,2],[269,1,269,5],[269,8,271,8],[287,1,287,5],[291,1,291,5],[293,1,293,2],[293,8,296,8],[295,1,295,2],[297,1,297,2],[298,1,298,5],[298,8,300,8],[316,1,316,5]]}
["City of Cedar Rapids\nCapital Project Request",null,null,"This section will be completed by Finance:",{"$nulls":4},"Instructions or help for data entry"]
[{"$nulls":4},"Main Project #:"]
[{"$nulls":4},"Related Project #'s:"]
[{"$nulls":4},"Forwarded for Timesheet Entry:"]
["** Complete All Cells Highlighted in Blue **"]
["Submitted By:",{"$nulls":3},"Date Submitted:","<mm/dd/yyyy>",null,null,"Project Title is limited to 30 characters/spaces; if project is TIF funded - title must start with TIF; if project is Assessment funded - it must start with ASD; if both, project must start with ASD TIF; See Naming Conventions tab for help in providing project title"]
[]
[{"$nulls":5},"select from drop down list"]
[{"$nulls":5},"065 - Joint Comm Construction"]
[{"$nulls":5},"075 - Fleet Svc Construction"]
[{"$nulls":5},"085 - PWF Construction"]
[{"$nulls":5},"301 - Street"]
[{"$nulls":5},"304 - Storm Sewer"]
[{"$nulls":5},"305 - Bridge"]
[{"$nulls":5},"306 - Traffic"]
[{"$nulls":5},"307 - Parks"]
[{"$nulls":5},"308 - Fire"]
[{"$nulls":5},"309 - Forestry"]
[{"$nulls":5},"310 - Police"]
[{"$nulls":5},"311 - Recreation"]
[{"$nulls":5},"312 - Riverfront"]
[{"$nulls":5},"313 - Ushers Ferry"]
[{"$nulls":5},"314 - Vets Stadium"]
[{"$nulls":5},"315 - Vets Memorial Bldg"]
[{"$nulls":5},"316 - Public Library"]
[{"$nulls":5},"317 - Animal Control"]
[{"$nulls":5},"321 - Downtown"]
[{"$nulls":5},"324 - Aquatic"]
[{"$nulls":5},"325 - Trail"]
[{"$nulls":5},"330 - 2008 Flood Recovery"]
[{"$nulls":5},"351 - FMIS (PeopleSoft)"]
[{"$nulls":5},"353 - Miscellaneous"]
[{"$nulls":5},"354 - Information Technology"]
[{"$nulls":5},"355 - Building Demolitions"]
[{"$nulls":5},"360 - Facility Maintenance"]
[{"$nulls":5},"535 - US Cellular Construction"]
[{"$nulls":5},"545 - Paramount Construction"]
[{"$nulls":5},"555 - Ice Arena Construction"]
[{"$nulls":5},"575 - Double Tree by Hilton"]
[{"$nulls":5},"615 - WPC Construction"]
[{"$nulls":5},"625 - Water Construction"]
[{"$nulls":5},"655 - Sanitary Sewer"]
[{"$nulls":5},"665 - Transit Construction"]
[{"$nulls":5},"695 - Golf Construction"]
["Main CIP Project Information",{"$nulls":3},"Fund & Fund Description:","select from drop down list"]
[]
["Project Title:"]
[]
[null,"select from drop down list"]
[null,"Central (Downtown)"]
[null,"Consolidated Central"]
[null,"Consolidated SW"]
[null,"Council Street"]
[null,"Diamond V"]
[null,"Ingleside"]
[null,"Mid-Town"]
[null,"OSADA"]
[null,"Prairie Ridge"]
[null,"Raining Rose"]
[null,"River Ridge North"]
[null,"Village"]
[null,"Tech Park"]
["TIF District (if applicable):","select from drop down list",{"$nulls":6},"Sub TIF District -Consolidated TIF districts need to be broken done by sub tif and % of project in each.  This is so time and bond issuance can be done accurately."]
["Sub TIF District & %:"]
[]
[null,"select from drop down list"]
[null,"ACH - ACC Rehabilitation"]
[null,"ACP - ACC Replacement"]
[null,"ACR - ACC Repair"]
[null,"ACS - ACC Surfacing"]
[null,"ACW - ACC Widening"]
[null,"ACX - ACC Extension"]
[null,"ALR - Ash Lagoon Rpr/Liners"]
[null,"ASP - Swimming Pools"]
[null,"ASW - Splash Pads - Wading Pools"]
[null,"ATH - ACC Trail Rehabilitation"]
[null,"ATP - ACC Trail Replacement"]
[null,"ATS - ACC Trail Resurfacing"]
[null,"ATX - ACC Trail Extension"]
[null,"BCP - Box Culvert Replacement"]
[null,"BCR - Box Culvert Repair"]
[null,"BCX - Box Culvert Extension"]
[null,"BRN - New Bridge"]
[null,"BRP - Bridge Replacement"]
[null,"BRW - Bridge Widening"]
[null,"CAG - Curb and Gutter Repair"]
[null,"CAS - Cracking and Seating"]
[null,"CHE - Computer Hardware & Rel Per Eq"]
[null,"CIM - Channel Improvement"]
[null,"DAS - Desktop Application Software"]
[null,"DET - Detention Basin"]
[null,"DIT - Development - IT"]
[null,"DKP - Deck Replacement"]
[null,"DKR - Deck Repair"]
[null,"DRT - Drain Tiles"]
[null,"DRW - Drainage Way"]
[null,"ECI - Exterior Concrete Improvement"]
[null,"ELR - Interior Electrical Renovations"]
[null,"ENB - Exterior New Building"]
[null,"ERN - Erosion Repair"]
[null,"ESL - Enterprise Software (large)"]
[null,"EWI - Exterior Window Improvement"]
[null,"EXB - Exterior Brick"]
[null,"EXE - Exterior Electrical - Building"]
[null,"EXI - Exterior Improvement"]
[null,"EXP - Exterior Portable Structure"]
[null,"EXR - Exterior Roof Replacement"]
[null,"GCC - Golf Course Concrete Install"]
[null,"GDR - Driving Range Improvements"]
[null,"GIS - GIS Mapping"]
[null,"GLS - Gate Lock System"]
[null,"GRD - Guard Rail"]
[null,"GST - Storage/Grnd Storg Tank Reno/Rehab"]
[null,"HIR - Hydrant Install & Rplc"]
[null,"HVR - HVAC Renovations"]
[null,"IIT - Infrastructure - IT"]
[null,"IMP - Impact Attenuators"]
[null,"INI - Interior Improvement"]
[null,"LAS - Landscape Improvements"]
[null,"LSN - Lift Station"]
[null,"MER - Interior Mechanical Renovation"]
[null,"MHR - Manhole Rehabilitation"]
[null,"NA - No Category"]
[null,"NPD - NPDES Improvements"]
[null,"OFE - Office Furn, Fixtures, Equip"]
[null,"PAF - Athletic Facility"]
[null,"PCH - PCC Rehabilitation"]
[null,"PCJ - PCC Joint Repair"]
[null,"PCP - PCC Replacement"]
[null,"PCR - PCC Repair"]
[null,"PCW - PCC Widening"]
[null,"PCX - PCC Extension"]
[null,"PLA - Parking Lot - Asphalt"]
[null,"PLC - Parking Lot - Concrete"]
[null,"PLR - Plumbing Renovations"]
[null,"PPE - Playground Equipment"]
[null,"PSC - Basketball-Tennis Courts"]
[null,"PTC - Protective Coating"]
[null,"PTH - PCC Trail Rehabilitation"]
[null,"PTP - PCC Trail Replacement"]
[null,"PTX - PCC Trail Extension"]
[null,"RCI - Railroad Crossing Improv"]
[null,"RTW - Retaining Wall"]
[null,"SBR - Sub Structure Repair"]
[null,"SIG - Signal Installation"]
[null,"SPR - Super Structure Repair"]
[null,"SSL - Sanitary Sewer Lining"]
[null,"SSP - Sanitary Sewer Replacement"]
[null,"SSR - Sanitary Sewer Repair"]
[null,"SST - Slope Stabilization"]
[null,"SSX - Sanitary Sewer Extension"]
[null,"STE - Streetscape Enhancements"]
[null,"STP - Storm Sewer Replacement"]
[null,"STR - Storm Sewer Repair"]
[null,"STS - Streetscape Improvements"]
[null,"STX - Storm Sewer Extension"]
[null,"STY - Study"]
[null,"SUG - Signal Upgrading"]
[null,"SWP - Sidewalk Replacement"]
[null,"SWR - Sidewalk Repair"]
[null,"SWX - Sidewalk Extension"]
[null,"THE - Telephone Hardware"]
[null,"UFI - Urban Fishery Infrastructure"]
[null,"VCW - Vertical & Collector Wells",{"$nulls":3},"select from drop down list"]
[null,"VLV - Valves",{"$nulls":3},"NE"]
[null,"WEQ - WPC Plant Equipment",{"$nulls":3},"NW"]
[null,"WFE - Well Field Electrical",{"$nulls":3},"SE"]
[null,"WMD - Water Main Distribution System",{"$nulls":3},"SW"]
[null,"WTE - Water Treatment Plant Equip",{"$nulls":3},"Multiple"]
["Project Type:","select from drop down list",null,null,"Quadrant of town:","select from drop down list",null,null,"See Project Types tab for help with useful lives selections available"]
[]
[null,"select from drop down list"]
[null,"NEW - New Asset"]
[null,"ADD - Addition",{"$nulls":3},"select from drop down list"]
[null,"EFF - Improved Efficiency",{"$nulls":3},"Maintenance"]
[null,"EXL - Extended Life",{"$nulls":3},"Development"]
[null,"NON - Non-capital",{"$nulls":3},"Fed/State Regulated"]
["Asset Capitalization","select from drop down list",null,null,"Project Category:","select from drop down list",null,null,"Why you picked the capitalization type that you did. I.E. = reinstall/replace water or sewer mains that extend life you  (EXL).  We need to know it is extending the life.  See Capitalization Policy tab for more examples"]
["Capitalization Description:"]
[]
[null,"Fiscal Year","Fiscal Year","Fiscal Year","Fiscal Year"]
["Revenues & Expenditures","enter current ","enter next","enter future","enter future2","Total Project Estimate",null,null,"Update fiscal year dates that apply to your project, in blue highlighted cells"]
["Project Funding Sources (Revenues)"]
["select from drop down list"]
["421003 - Federal Capital Grant"]
["422002 - State Capital Grant"]
["423000 - Local Agency Grant"]
["481003 - Capital Contribution"]
["471008 - Special Assessment"]
["483001 - Road Use Tax"]
["483001 - Transfer In from another FUND"]
["483002 - Transfers-In within fund"]
["485000 - External Loans"]
["485003 - Revenue Bonds"]
["485001 - General Obligation Bonds"]
["485008 - GOB- TIF Supported"]
["485009 - State Revolving Proceeds"]
["COH - Cash on Hand"]
["select from drop down list",{"$nulls":4},{"$f":"SUM(B199:E199)","v":0}]
["select from drop down list",{"$nulls":4},0]
["select from drop down list",{"$nulls":4},{"$f":"SUM(B201:E201)","v":0}]
["select from drop down list",{"$nulls":4},{"$f":"SUM(B202:E202)","v":0}]
[]
["Total",{"$f":"B199+B200+B201+B202","v":0},{"$f":"C199+C200+C201+C202","v":0},0,0,{"$f":"SUM(F199:F202)","v":0}]
[]
["Project Expenditures"]
["select from drop down list"]
["55X000 - Improvements"]
["5XX000 - Expensed"]
["select from drop down list",{"$nulls":4},{"$f":"SUM(B210:E210)","v":0}]
["select from drop down list",{"$nulls":4},{"$f":"SUM(B211:E211)","v":0}]
[]
["Total",{"$f":"B210+B211","v":0},{"$f":"C210+C211","v":0},0,0,{"$f":"SUM(F208:F211)","v":0}]
["Comments:",{"$nulls":7},"Comments - if there is any unique about the project set up you are requesting"]
["Funding Source Transfers-In:",{"$nulls":7},"Transfer - where the funds are coming from and how much from each fund/project."]
[]
["A SEPARATE SECTION SHOULD BE COMPLETED BELOW FOR EACH SEPARATE PROJECT TO BE CONSTRUCTED WITH THE MAIN PROJECT (if more than 3 add't projects needed - contact your Analyst)"]
[]
["2nd CIP Project  (if applicable)",{"$nulls":3},"Fund & Fund Description:","select from drop down list"]
[]
["Project Title:",{"$f":"B47","v":0}]
[null,"Central (Downtown)"]
[null,"Consolidated Central"]
[null,"Consolidated SW"]
[null,"Council Street"]
[null,"Diamond V"]
[null,"Ingleside"]
[null,"Mid-Town"]
[null,"OSADA"]
[null,"Prairie Ridge"]
[null,"Raining Rose"]
[null,"River Ridge North"]
[null,"Village"]
[null,"Tech Park"]
[]
["Project Type:","select from drop down list"]
[]
["Project Category:","select from drop down list"]
[]
["Asset Capitalization","select from drop down list",{"$nulls":3}," "]
["Capitalization Description:"]
[]
[null,"Fiscal Year","Fiscal Year","Fiscal Year","Fiscal Year"]
["Revenues & Expenditures","enter current ","enter next","enter future","enter future2","Total Project Estimate"]
["Project Funding Sources (Revenues)"]
["select from drop down list",{"$nulls":4},{"$f":"SUM(B246:E246)","v":0}]
["select from drop down list",{"$nulls":4},0]
["select from drop down list",{"$nulls":4},{"$f":"SUM(B248:E248)","v":0}]
["select from drop down list",{"$nulls":4},{"$f":"SUM(B249:E249)","v":0}]
[]
["Total",{"$f":"B246+B247+B248+B249","v":0},{"$f":"C246+C247+C248+C249","v":0},0,0,{"$f":"SUM(F246:F249)","v":0}]
[]
["Project Expenditures"]
["select from drop down list",{"$nulls":4},{"$f":"SUM(B254:E254)","v":0}]
["select from drop down list",{"$nulls":4},{"$f":"SUM(B255:E255)","v":0}]
[]
["Total",{"$f":"B254+B255","v":0},{"$f":"C254+C255","v":0},0,0,{"$f":"SUM(F254:F255)","v":0}]
[]
["Funding Source Transfers-In:"]
[]
["3rd CIP Project  (if applicable)",{"$nulls":3},"Fund & Fund Description:","select from drop down list"]
[]
["Project Title:",{"$f":"B47","v":0}]
[]
["Project Type:","select from drop down list"]
[]
["Project Category:","select from drop down list"]
[]
["Asset Capitalization","select from drop down list",{"$nulls":3}," "]
["Capitalization Description:"]
[]
[null,"Fiscal Year","Fiscal Year","Fiscal Year","Fiscal Year"]
["Revenues & Expenditures","enter current ","enter next","enter future","enter future2","Total Project Estimate"]
["Project Funding Sources (Revenues)"]
["select from drop down list",{"$nulls":4},{"$f":"SUM(B275:E275)","v":0}]
["select from drop down list",{"$nulls":4},0]
["select from drop down list",{"$nulls":4},{"$f":"SUM(B277:E277)","v":0}]
["select from drop down list",{"$nulls":4},{"$f":"SUM(B278:E278)","v":0}]
[]
["Total",{"$f":"B275+B276+B277+B278","v":0},{"$f":"C275+C276+C277+C278","v":0},0,0,{"$f":"SUM(F275:F278)","v":0}]
[]
["Project Expenditures"]
["select from drop down list",{"$nulls":4},{"$f":"SUM(B283:E283)","v":0}]
["select from drop down list",{"$nulls":4},{"$f":"SUM(B284:E284)","v":0}]
[]
["Total",{"$f":"B283+B284","v":0},{"$f":"C283+C284","v":0},0,0,{"$f":"SUM(F283:F284)","v":0}]
[]
["Funding Source Transfers-In:"]
[]
["4th CIP Project  (if applicable)",{"$nulls":3},"Fund & Fund Description:","select from drop down list"]
[]
["Project Title:",{"$f":"B47","v":0}]
[]
["Project Type:","select from drop down list"]
[]
["Project Category:","select from drop down list"]
[]
["Asset Capitalization","select from drop down list",{"$nulls":3}," "]
["Capitalization Description:"]
[]
[null,"Fiscal Year","Fiscal Year","Fiscal Year","Fiscal Year"]
["Revenues & Expenditures","enter current ","enter next","enter future","enter future2","Total Project Estimate"]
["Project Funding Sources (Revenues)"]
["select from drop down list",{"$nulls":4},{"$f":"SUM(B304:E304)","v":0}]
["select from drop down list",{"$nulls":4},0]
["select from drop down list",{"$nulls":4},{"$f":"SUM(B306:E306)","v":0}]
["select from drop down list",{"$nulls":4},{"$f":"SUM(B307:E307)","v":0}]
[]
["Total",{"$f":"B304+B305+B306+B307","v":0},{"$f":"C304+C305+C306+C307","v":0},0,0,{"$f":"SUM(F304:F307)","v":0}]
[]
["Project Expenditures"]
["select from drop down list",{"$nulls":4},{"$f":"SUM(B312:E312)","v":0}]
["select from drop down list",{"$nulls":4},{"$f":"SUM(B313:E313)","v":0}]
[]
["Total",{"$f":"B312+B313","v":0},{"$f":"C312+C313","v":0},0,0,{"$f":"SUM(F312:F313)","v":0}]
[]
["Funding Source Transfers-In:"]

{"sheet":"Naming Conventions","index":1,"n_rows":39,"n_cols":6,"rows_kept":39,"merged":[[13,0,13,6]]}
[{"$nulls":3},"PROJECT NAME DESIGNATIONS FOR CAPITAL IMPROVEMENT PROJECTS"]
[]
["Procedure - A capital improvement project is set up in PeopleSoft Financials with the following descriptors:"]
[]
[null,"Ø  Project Number - Assigned by the appropriate Finance Analyst"]
[null,"Ø  Project Title - Named by the individual opening the project using the instructions below"]
[null,"Ø  TIF District – to ensure TIF projects are segregated from regular bonded projects"]
[null,"Ø  Project Type – Determined by the individual opening the project (see list) "]
[null,"Ø  City Quadrant - Indicated by the individual opening the project"]
[null,"Ø  Asset Capitalization – To determine useful life of an asset if it can be capitalized"]
[null,"Ø  Project Category - Determined by the individual opening the project "]
[]
["Project Name "]
["Up to 30 spaces can be accommodated within the text fields.  Standard abbreviations are used to ensure the project name fits within the 30 spaces.  A standard format for project naming has been developed to provide consistency and to clearly indicate the project scope.  "]
[]
[null,"Examples:","3rd Ave Fr 3rd-7th St"]
[null,null,"42nd St W/o Seminole Valley"]
[null,null,"6th St over Prairie Crk"]
[null,null,"TIF Wright Bros E/o Tissel Hol"]
[null,null,"ASD TIF C Av Fr 74th-Sheffield"]
[]
[]
[null,"ABBREVIATION","DESIGNATION",null,"ABBREVIATION","DESIGNATION"]
[null,"@","At",null,"NB","Northbound"]
[null,"Aly","Alley",null,"O/P","Overpass"]
[null,"Asph","Asphalt or Asphaltic",null,"Ped","Pedestrian"]
[null,"Av or Ave","Avenue",null,"Pntg","Painting"]
[null,"Bl or Blvd","Boulevard",null,"Prkwy","Parkway"]
[null,"Blk","Block",null,"Prog","Program"]
[null,"Btwn","Between",null,"Rd","Road"]
[null,"Crk","Creek",null,"Rt","Route"]
[null,"Ct","Court",null,"Rvr","River"]
[null,"Dr","Drive",null,"S/o","South of"]
[null,"E/o","East of",null,"SB","Southbound"]
[null,"EB","Eastbound",null,"St","Street"]
[null,"I&I","Inflow and Infiltration",null,"Tr","Trail"]
[null,"Ln","Lane",null,"Vly","Valley"]
[null,"Misc","Miscellaneous",null,"W/o","West of"]
[null,"N/o","North of",null,"WB","Westbound"]

{"sheet":"Project Types","index":2,"n_rows":91,"n_cols":11,"rows_kept":91,"merged":[[0,0,0,10],[87,0,87,10]]}
["PROJECT TYPES FOR NAMING CIP PROJECTS"]
[null,null,"Abbreviation","Estimated Life           (in years)",{"$nulls":5},"Abbreviation","Estimated Life          (in years)"]
[]
["Street Construction (301XXXX CIP Projects):",{"$nulls":6},"Streetscape Improvements (321XXX CIP Projects):"]
[null,"Asphalt Surface",null,10,{"$nulls":4},"Streetscape Improvements",null,15]
[null,"ACC Surfacing","ACS",{"$nulls":5},"Streetscape Improvements","STS"]
[null,"Asphalt Base",null,15,{"$nulls":4},"Streetscape Enhancements","STE"]
[null,"Cracking and Seating","CAS"]
[null,"Asphalt Pavements",null,20,{"$nulls":3},"Trails (325XXX CIP Projects):"]
[null,"ACC Extension","ACX",{"$nulls":5},"Asphalt Overlay Trails",null,10]
[null,"ACC Rehabilitation","ACH",{"$nulls":5},"ACC Trail Resurfacing","ATS"]
[null,"ACC Replacement","ACP",{"$nulls":5},"Asphalt Trails",null,20]
[null,"ACC Repair","ACR",{"$nulls":5},"ACC Trail Extension","ATX"]
[null,"ACC Widening","ACW",{"$nulls":5},"ACC Trail Rehabilitation","ATH"]
[null,"Concrete Pavements Repair",null,15,{"$nulls":4},"ACC Trail Replacement","ATP"]
[null,"PCC Joint Repair","PCJ",{"$nulls":5},"Concrete Trails",null,30]
[null,"PCC Rehabilitation","PCH",{"$nulls":5},"PCC Trail Extension","PTX"]
[null,"PCC Repair","PCR",{"$nulls":5},"PCC Trail Rehabilitation","PTH"]
[null,"Concrete Pavements New",null,40,{"$nulls":4},"PCC Trail Replacement","PTP"]
[null,"Curb and Gutter Repair","CAG",{"$nulls":5},"Landscape Improvements",null,15]
[null,"PCC Extension","PCX",{"$nulls":5},"Landscape Improvements","LAS"]
[null,"PCC Replacement","PCP"]
[null,"PCC Widening","PCW",{"$nulls":4},"Miscellaneous (353XXX CIP Projects):"]
[null,"Sidewalk",null,40,{"$nulls":4},"Urban Fishery","UFI",40]
[null,"Sidewalk Repair","SWR"]
[null,"Sidewalk Extension","SWX",{"$nulls":4},"Information Technology (354XXX CIP Projects):"]
[null,"Sidewalk Replacement","SWP",{"$nulls":5},"Major Infrastructure - IT","IIT",40]
[null,"Retaining Wall","RTW",40,{"$nulls":4},"Telephone Hardware","THE",10]
[null,"Railroad Crossing Improvements","RCI",20,{"$nulls":4},"Enterprise Software (large)","ESL",10]
[{"$nulls":8},"Development IT","DIT",5]
["Storm Sewers: (304XXXX CIP Projects):",{"$nulls":7},"Computer Hardware & Rel Equip","CHE",5]
[null,"Drain Tiles","DRT",40,{"$nulls":4},"Desktop Application Software","DAS",3]
[null,"Storm Sewers/Structures",null,80]
[null,"Storm Sewer Extension","STX",{"$nulls":4},"Facilities Maintenance: (360XXXX CIP Projects):"]
[null,"Storm Sewer Replacement","STP",{"$nulls":5},"Exterior New Building","ENB",50]
[null,"Storm Sewer Repair","STR",{"$nulls":5},"Exterior Facility Improv",null,20]
[null,"Box Culverts",null,80,{"$nulls":4},"Exterior Improvements","EXI"]
[null,"Box Culvert Extension","BCX",{"$nulls":5},"Concrete Improv","ECI"]
[null,"Box Culvert Replacement","BCP",{"$nulls":5},"Window Improv","EWI"]
[null,"Box Culvert Repair","BCR",{"$nulls":5},"Brick","EXB"]
[null,"Drainage Improvements",null,25,{"$nulls":4},"Electrical - Building","EXE"]
[null,"Detention Basin","DET",{"$nulls":5},"Portable Structure","EXP"]
[null,"Drainage Way","DRW",{"$nulls":5},"Roof Replacement","EXR"]
[null,"Erosion Repair","ERN",{"$nulls":5},"Interior Facility Improv",null,20]
[null,"NPDES Improvements","NPD",{"$nulls":5},"Electrical Renovations","ELR"]
[null,"Slope Stabilization","SST",{"$nulls":5},"HVAC Renovations","HVR"]
[null,"Channel Improvements","CIM",{"$nulls":5},"Plumbing Renovations","PLR"]
[{"$nulls":8},"Mechanial Renovations","MER"]
["Bridges (305XXXX CIP Projects):"]
[null,"Bridge Repair",null,40,{"$nulls":3},"WPC (615XXXX CIP Projects):"]
[null,"Deck Repair","DKR",{"$nulls":5},"WPC Equipment",null,20]
[null,"Deck Replacement","DKP",{"$nulls":5},"WPC Plant Equipment","WEQ"]
[null,"Super Structure Repair","SPR",{"$nulls":5},"Lift Station","LSN"]
[null,"Sub Structure Repair","SBR",{"$nulls":5},"Ash Lagoon Repair/Liners","ALR"]
[null,"Bridge Widening","BRW"]
[null,"New Bridge",null,70,{"$nulls":3},"Water (625XXXX CIP Projects):"]
[null,"Bridge Replacement","BRP",{"$nulls":5},"Water Main Distribution Sys","WMD",80]
[null,"New Bridge ","BRN",{"$nulls":5},"Hydrant Install & Rplc","HIR",50]
[null,"Guard Rail","GRD",15,{"$nulls":4},"Valves","VLV",50]
[null,"Impact Attenuators","IMP",15,{"$nulls":4},"Well Field Electrical Power ","WFE",30]
[null,"Protective Coating","PTC",15,{"$nulls":4},"Vertical & Collector Wells","VCW",20]
[{"$nulls":8},"Water Treatment Plant Equp","WTE",20]
["Traffic Construction (306XXXX CIP Projects):",{"$nulls":7},"Storage/Ground Tank Reno","GST",15]
[null,"Signals",null,25]
[null,"Signal Installation","SIG",{"$nulls":4},"Sanitary Sewers (655XXXX CIP Projects):"]
[null,"Signal Upgrade","SUG",{"$nulls":5},"Sewer Main",null,80]
[{"$nulls":8},"Sewer Extension","SSX"]
["Parks: (307XXXX CIP Projects):",{"$nulls":7},"Sewer Replacement","SSP"]
[null,"Major Infrastructure",null,40,{"$nulls":4},"Sewer Repair","SSR"]
[null,"Swimming Pools","ASP",{"$nulls":5},"Manhole",null,50]
[null,"Athletic Facility","PAF",{"$nulls":5},"MH Rehabilitation","MHR"]
[null,"General Park Improv",null,15,{"$nulls":4},"Lining","SSL",50]
[null,"Splash Pads / Wading","ASW"]
[null,"Playground Equipment","PPE",{"$nulls":4},"Golf (695XXXX CIP Projects):"]
[null,"Basketball -Tennis Courts","PSC",{"$nulls":5},"Golf Course Concrete Install","GCC",30]
[null,"Parking Lots - Asphalt","PLA",{"$nulls":5},"Driving Range Improv","GDR",20]
[null,"Concrete",null,25]
[null,"Parking Lots - Concrete","PLC",{"$nulls":4},"Other:"]
[{"$nulls":8},"Gate Lock System","GLS",0]
[{"$nulls":8},"Study","STY",0]
[{"$nulls":8},"No Category","NA",0]
[{"$nulls":8},"Office Furniture, Fixtures, Equip","OFE",7]
[]
[]
[]
[]
[]
["PROJECT CATEGORIES FOR DEFINING CIP PROJECTS"]
["Maintenance – Projects to maintain infrastructure"]
["Development – New installation or extension of roads, bridges, sidewalks etc.  The infrastructure must not have existed before."]
["Federal/State Regulated – Project mandated by federal/state regulations.  "]

{"sheet":"Capitalization Policy","index":3,"n_rows":30,"n_cols":6,"rows_kept":30,"merged":[[2,0,2,11],[16,0,16,11],[18,2,18,11],[26,0,26,11],[27,0,27,11],[28,0,28,11]]}
[{"$nulls":5},"City Capitalization Policy For Capital Improvement Projects"]
[]
["Capitalization changes say that if an expenditure is a new asset, improves the efficiency, or materially extends the useful life of an asset it should be capitalized if the cost is $5K or greater.    If at least 1 of these criteria are not met or if the asset cost is not met, the expenditures should not be capitalized.  "]
[]
["These capitalization changes DO NOT AFFECT what can be bonded for."]
[]
["Examples of what the City WILL capitalize:"]
["Ø  New asset or addition"]
[null,null,"§  New building"]
[null,null,"§  Addition to existing asset (addition to building)"]
[null,null,"§  New security system"]
[null,null,"§  New sprinkler system"]
[null,null,"§  New sound system"]
[null,null,"§  Street widening or extension"]
[null,null,"§  Sewer extension "]
[null,null,"§  Water main extension"]
["Ø  More efficient, reduced cost, extended life – must extend life of an asset or increase the service level, CAN NOT be a change that just avoids shortening an assets life"]
[null,null,"§  Reconstruction/replacing an asphalt road with concrete road"]
[null,null,"§  New roof that extends the life (IE a building has a useful life of 80 years and at 70 years it is deemed if the roof is replaced, the buildings life will be extended to 90 years)"]
[null,null,"§  Windows that extend the life"]
[null,null,"§  Tuck pointing"]
[null,null,"§  Reinstall/replace water or sewer mains that extends life"]
[]
["Examples of what the City CAN NOT capitalize:"]
["Ø  Costs that maintain existing life or avoid shortening an assets life"]
["Ø  Asphalt overlays"]
["Ø  New roof where a building has a life of 80 years and after the first 40 years the roof needs replaced to make the building last until its 80 year life.  This is maintenance not a capitalizable repair."]
["Ø  Preventative maintenance, normal periodic repairs, replacement of parts, structural components and other activities needed to maintain the asset so that it continues to provide normal service"]
["Ø  Infrastructure repairs needed to maintain the asset so that it continues to provide normal service - asphalt overlays, crack & joint repairs, or sealing. "]
["Ø  Other ordinary repairs to maintain the asset"]