{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["lookups","CIP Database Info","CIP Database","Proj. Dev. Worksheet","Sheet1"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":1,"defined_names":18,"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":"lookups","index":0,"n_rows":6,"n_cols":2,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
[]
["Project Name:",{"$f":"+#REF!","v":{"$error":"#REF!"}}]
["Department:",{"$f":"+#REF!","v":{"$error":"#REF!"}}]
["Project Type:",{"$f":"+#REF!","v":{"$error":"#REF!"}}]
["Project Manager:",{"$f":"+#REF!","v":{"$error":"#REF!"}}]
["Phone/Extension:",{"$f":"+#REF!","v":{"$error":"#REF!"}}]

{"sheet":"CIP Database Info","index":1,"n_rows":17,"n_cols":32,"rows_kept":17,"cut":false,"hidden":true,"merged":[]}
["1.  Copy and paste into CIP Project Info"]
[]
[]
["Auto Number","ControlNo","ProjName","Project Type","Department","Division","FundingS","Impact Zone","Budget Unit","Location","Ward","GeneralType","Special Type","Priority","RankD","Future Revenue","Annual Amount","Impact on Budget","Description","Justification","Fund#","Fund","CPC Rank","DeptName","Start Date","Estimated Completion Date","Future Revenue Impact on Budget","Project Total","Maint Expenses Impact","Operational Expenses Impact","Maint Evpense","Operational Expense"]
[null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"LEFT(I5,3)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(LEFT($I$5,3),,2,TRUE)","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[]
[]
[]
[]
["2.  Copy and paste to CIP Project Cost "]
[]
[null,"ControlNo","Year","Construction - 8202","Construction City Depts - 8203","Contingency - 8204","Design Fees - 8206","FFE - 8208","Hazmat - 8210","Land/Bldg/Demo - 8212","Legal Publications - 8214","Miscellaneous - 8216","Misc Design - 8218","Moving - 8220","Operating Supplies - 8224","Off-Site - 8222","Permit/Fees Etc - 8226","Printing - 8228","Professional Services - 8229","Project Management - 8232","Repair/Maint Suppl - 8234","Soil Investigate - 8236","Survey - 8238","Test/Inspect - 8240","Utility - 8242","Capital - 8244","Arts - 9001/9404","Yearly Totals:"]
[null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]

{"sheet":"CIP Database","index":2,"n_rows":42,"n_cols":14,"rows_kept":42,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,"Funding Sources","Impact Zones","General Type: Select One","Special Type: Select One","Location","Priority"]
["CITY OF GREELEY - NEW CAPITAL IMPROVEMENT PROJECTS",null,null,null,"Bond Savings","Transportation - Zone 1","New/Enhancement","Building","0 City Wide","Priority 1 - Imperative (Must Do)"]
["Control Number: (Budget will assign #)",{"$f":"+#REF!","v":{"$error":"#REF!"}},null,null,"Bonds / External Loans","Transportation - Zone 2","Repair/Rehabilitation","Concrete","1 East of US 85 Bypass","Priority 2 - Essential (Should Do)"]
["Ward Code:",{"$f":"+#REF!","v":{"$error":"#REF!"}},null,null,"Fire Development Fees","Transportation - Zone 3","New/Enhancement & Repair/Rehabilitation (Write in percentages in the Project Description Field)","Drainage","2 N of 10th St - W of HWY 85 - E of 35th Ave","Priority 3 - Important (Could Do)",null," "]
["Project Name:",{"$f":"+#REF!","v":{"$error":"#REF!"}},null,null,"General Fund Contribution","Neighborhood Park East Zone",null,"Land","3 S of 10th St - W of HWY 85 - E of 35th Ave",null,null," ",null,"0  MULTIPLE WARDS"]
["Department Name:",{"$f":"+#REF!","v":{"$error":"#REF!"}},null,null,"Miscellaneous","Neighborhood Park West Zone",null,"Other","4 S of 10th St - E of 71st Ave - W of 35th Ave",null,null," ",null,"1  16 ST NORTH/ 35 AVE EAST"]
["Division:",{"$f":"+#REF!","v":{"$error":"#REF!"}},null,null,"Park Development Fees *","Community Park",null,"Park","5 N of 10th St - E of 71st Ave - W of 35th Ave",null,null," ",null,"2  16 ST SOUTH/ 23 AVE EAST"]
["Funding Source: (See List)",{"$f":"+#REF!","v":{"$error":"#REF!"}},null,null,"Police Development Fees","Stormwater - Sheepdraw",null,"Street","6 N of 10th St - W of 71st Ave",null,null," ",null,"3  10 ST SOUTH/ 23 AVE WEST"]
["Impact Zone: (See List)",{"$f":"+#REF!","v":{"$error":"#REF!"}},null,null,"Quality of Life","Stormwater - Country Club",null,"Transmission Lines","7 S of 10th St - W of 71st Ave",null,null," ",null,"4  10 ST NORTH/ 23 AVE WEST"]
["Budget Unit Number:",{"$f":"+#REF!","v":{"$error":"#REF!"}},null,null,"Raw Water Sales / Rent","Stormwater - Grapevine",null,null,"8 Outside City",null,null," ",null,"5  OUTSIDE CITY "]
["Location Code: (See List)",{"$f":"+#REF!","v":{"$error":"#REF!"}},null,null,"Sales Tax on Food","Stormwater - Downtown North",null,null,null,null,null," "]
["General Type: (See List)",{"$f":"+#REF!","v":{"$error":"#REF!"}},null,null,"Sewer Plant Investment Fees","Stormwater - 28th Avenue",null,null,null,null,null," "]
["Special Type: (See List)",{"$f":"+#REF!","v":{"$error":"#REF!"}},null,null,"Sewer Funded Depreciation","Stormwater - Ashcroft"]
["Priority: (See List)",{"$f":"+#REF!","v":{"$error":"#REF!"}},null,null,"Stormwater Management Fees *","Stormwater - South"]
["Department Rank: ",{"$f":"+#REF!","v":{"$error":"#REF!"}},null,null,"Trail Development Fees","Stormwater - East Greeley"]
["Will project generate future revenue? Yes or No",{"$f":"IF(B37>0,\"Yes\",\"No\")","v":"No"},null,null,"Transportation Development Fees *","Stormwater - Central"]
["If Above Is Yes, List Annual Amount: ",{"$f":"+#REF!","v":{"$error":"#REF!"}},null,null,null,"Not Applicable"]
[null,null,null,null,"Water Plant Investment Fees"]
["Future Year Impact On Budget:",{"$f":"+#REF!+#REF!-#REF!","v":{"$error":"#REF!"}},null,null,"Water Funded Depreciation"]
["Description:",{"$f":"+#REF!","v":{"$error":"#REF!"}}]
["Justification:",{"$f":"+#REF!","v":{"$error":"#REF!"}}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"*Each of these funding sources requires that an Impact Zone be listed."]

{"sheet":"Proj. Dev. Worksheet","index":3,"n_rows":49,"n_cols":2,"rows_kept":49,"cut":false,"hidden":false,"merged":[[0,0,0,1],[1,0,1,1],[44,0,44,1],[41,0,41,1],[2,0,2,1],[11,0,11,1],[24,0,24,1],[35,0,35,1],[9,0,9,1],[30,0,30,1]]}
["Project Development "]
["Worksheet"]
["Project Information"]
["Project Name:","Terry Ranch Water Supply Pipeline"]
["Initiating Department:","Water and Sewer"]
["Date:","2021-09-30"]
["Project Owner:","City of Greeley"]
["Project Manager:","Peter Champion"]
["Phone Number:",9703509319]
["Project Description"]
["Description:"]
["Project Planning"]
["Purpose of the Project:","Design and construction of treated water transmission pipeline"]
["Project Location:","Weld County between Carr and Windsor"]
["Applicable Design Standards:"]
["Alternative Evaluation Needs:"]
["Land Acquisition/Right of Way Needs:","Permanent and temporary construction easements"]
["Environmental Assessment Needs:"]
["Feasibility Study Needs:","N/A"]
["Outside Funding Opportunities:","N/A"]
["Special Physical Constraints:","N/A"]
["Associated Proj. Coordination Needs:","N/A"]
["Art Enhancement Potential:","No"]
["Operation/Maintenance Needs:","N/A"]
[]
["Project Development/Funding:"]
["Design/Approval:"]
["Construction (Entire Project):","2022-2035"]
["Project Closeout:"]
["Warranty Tracking Period:","2 years each phase"]
["Contract Processing Information"]
["Pre-Proposal/Bid Meeting Date:"]
["Pre-Proposal/Bid Meeting Time:"]
["Proposal/Bid Due:"]
["Number of Calendar Days to Complete:"]
["Resources"]
["Project Team:","Peter Champion"]
["Engineer's Estimate:"]
["Funding ($'s):"]
["Budget Unit #(s):"]
["Inspection Services:"]
["Action Plan"]
["Describe Plan:"]
["Is a Quality Assurance Plan needed?:"]
["Authorization Signatures"]
["Approved for Design by CPC:"]
["Approved for Construction by EDR: "]
["Approved for Construction by CPC:"]
["Approved by Department Budget:"]

{"sheet":"Sheet1","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}