{"text_format":"3","workbook":"xls","n_sheets":3,"sheets":["SA No. 2 FC & ROW","SA No. 3 Final Plans","SA No. 4 Bid & Constr"],"not_rendered":{"external_links":1,"defined_names":6},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"SA No. 2 FC & ROW","index":0,"n_rows":313,"n_cols":11,"rows_kept":313,"merged":[[1,12,1,16],[1,18,1,22],[1,24,1,28],[1,30,1,34],[1,36,1,40],[1,42,1,46],[1,48,1,52],[1,54,1,58],[45,4,45,5],[46,4,46,5],[47,4,47,5],[48,4,48,5],[49,4,49,5],[52,4,52,5],[55,4,55,5],[60,4,60,5],[61,4,61,5],[62,4,62,5],[63,4,63,5],[104,13,104,14],[140,4,140,5],[190,4,190,5],[191,4,191,5],[192,4,192,5],[193,4,193,5],[194,4,194,5],[199,4,199,5],[243,4,243,5],[244,4,244,5],[249,4,249,5],[250,4,250,5],[251,4,251,5],[252,4,252,5],[253,4,253,5],[254,4,254,5],[255,4,255,5],[256,4,256,5],[257,4,257,5],[258,4,258,5],[259,4,259,5],[264,4,264,5],[265,4,265,5],[266,4,266,5],[267,4,267,5],[268,4,268,5],[269,4,269,5],[270,4,270,5],[271,4,271,5],[272,4,272,5],[273,4,273,5],[274,4,274,5],[275,4,275,5],[298,2,298,5],[299,2,299,5],[300,2,300,5]],"flags":["formulas_cached_only"]}
[]
[]
[{"$nulls":5},"                Item of Work","Project Manager","Senior Engineer/ Planner","Engineer/ Planner","Technician","Total"]
[null,"Phase 1 - Preliminary Design"]
[{"$nulls":6},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[]
[null,"Phase 2 - Field Check/Right of Way Plans"]
[{"$nulls":3},"2.1 Data Collection"]
[{"$nulls":3},"2.1.1",null,"Perform GPS and Total Station surveys within the design corridor of:"]
[{"$nulls":5},"     g. Flag locations of up to 10 soil borings and return to survey actual locations "]
[{"$nulls":5},"     h. stake centerline of 159th Street for use by utilities doing relocations"]
[{"$nulls":5},"     i. flag proposed ROW and Esmts (assume 15) for use by appraisers and owners"]
[{"$nulls":5},"     j. miscellaneous pick-up surveys"]
[{"$nulls":3},"2.1.2",null,"Prepare COGO file calculating location of proposed right of way and construction easements"]
[{"$nulls":3},"2.1.3",null,"Prepare and check legal descriptions and tract map exhibits for right of way acquisition process"]
[{"$nulls":3},"2.1.4",null,"Assist with preparation of Survey Reference Sheet and review plansheets for completeness and accuracy"]
[{"$nulls":3},"2.1.5",null,"Prepare 3 sets of KDOT field books"]
[]
[]
[]
[null,null,"2.1 Traffic Simulation "]
[{"$nulls":3},"2.1.1",null,"Develop/Run Existing Conditions Simulation Model "]
[{"$nulls":3},"2.1.2",null,"Develop/Run Future Build & No-build Conditions Simulation Model "]
[{"$nulls":3},"2.1.3",null,"Model Results - Operational Analysis"]
[{"$nulls":3},"2.1.4",null,"Revise Operational Analysis"]
[{"$nulls":3},"2.1.5",null,"Prepare Traffic Memorandum"]
[]
[null,null,"2.2 Interchange Geometrics "]
[{"$nulls":3},"2.2.1",null,"Refine Preliminary Horizontal/Vertical Geometrics"]
[{"$nulls":3},"2.2.2",null,"Revise Preliminary Horizontal/Vertical Geometrics"]
[{"$nulls":3},"2.2.3",null,"Develop Preliminary Cross Sections"]
[{"$nulls":3},"2.2.4",null,"Determine Preliminary ROW requirements"]
[]
[null,null,"2.3 Break-in-Access Request "]
[{"$nulls":3},"2.3.1",null,"Develop Break-in-Access Request"]
[]
[null,null,"2.4 Cost Estimate "]
[{"$nulls":3},"2.4.1",null,"Determine preliminary project cost estimate "]
[]
[null,null,"2.5 Meetings"]
[{"$nulls":3},"2.5.1",null,"Review Agency Meetings  (attend and prepare for 2 assumed)"]
[{"$nulls":3},"2.5.2",null,"Stakeholder Meetings  (attend and prepare for 1 assumed)"]
[{"$nulls":3},"2.5.3",null,"Council Presentations  (attend and prepare for 1 assumed)"]
[]
[null,null,"2.1  Data Collection"]
[{"$nulls":3},"2.1.1","Assist with preparation of Survey Reference Sheet and review plan sheets for completeness and accuracy"]
[{"$nulls":3},"2.1.2","Perform miscellaneous pick-up surveys and process"]
[{"$nulls":3},"2.1.3","Obtain ownership information. The Consulting Engineer shall assist the City in contracting with an approved title company for ownership information investigations. The costs associated with ownership information investigations shall be paid by the City."]
[{"$nulls":3},"2.1.4","Review ownership and encumbrance reports from the title company and develop list of comments for possible changes. "]
[{"$nulls":3},"2.1.5","Perform GPS and Total Station surveys within the design corridor of:"]
[{"$nulls":3},"2.1.5.1",null,"Visible utilities and marked out buried utilities"]
[{"$nulls":3},"2.1.5.2",null,"Determine and stake locations of soil borings for bridges and retaining walls (Assume 12 borings).  GPS survey will be used to collect locations of roadway soil borings (Assume 129 borings to be located after all borings are completed)."]
[{"$nulls":3},"2.1.6","Property Corner Restoration"]
[{"$nulls":3},"2.1.6.1",null,"Find, flag and describe all property corners along 159th Street which may be impacted by construction (assume 30)."]
[{"$nulls":3},"2.1.6.2",null,"Field survey their location and prepare a Preliminary Monumentation Survey map documenting the type of monument found and the coordinates of each. Submit the map to the City and County Public Works Departments."]
[{"$nulls":3},"2.1.7","Quality Assurance"]
[]
[{"$nulls":5},"Subtotal"]
[]
[null,null,"2.2  Traffic"]
[{"$nulls":3},"2.2.1","Peak Hour Signal Warrant Analysis"]
[{"$nulls":3},"2.2.2","Perform PM peak hour turn lane storage length calculations along 159th Street (7 Intersections plus approach to Antioch).  Synchro signal timings will be used in the VISSIM model."]
[{"$nulls":3},"2.2.3","Internal Team Meetings (2 assumed)"]
[{"$nulls":3},"2.2.4","Meetings with Client (1 assumed)"]
[{"$nulls":3},"2.2.5","Quality Assurance"]
[]
[{"$nulls":5},"Subtotal"]
[null,null,"2.3  Roadway"]
[{"$nulls":3},"2.3.1","Typical Sections"]
[{"$nulls":3},"2.3.1.1",null,"Develop US 69 typical sections, interim and ultimate"]
[{"$nulls":3},"2.3.1.2",null,"Create Ramp typical sections"]
[{"$nulls":3},"2.3.1.3",null,"Create 159th St and side road typical sections"]
[{"$nulls":3},"2.3.1.4",null,"Develop miscellaneous typical sections"]
[]
[{"$nulls":3},"2.3.2","Horizontal/Vertical Geometrics"]
[{"$nulls":3},"2.3.2.1",null,"Develop horizontal alignments and superelevation calculations for 159th St interchange ramps"]
[{"$nulls":3},"2.3.2.2",null,"Develop horizontal alignments and superelevation calculations for Ramp 69S-167th St and 69N-151st St"]
[{"$nulls":3},"2.3.2.3",null,"Create vertical alignments for 159th St interchange ramps"]
[{"$nulls":3},"2.3.2.4",null,"Create vertical alignments for Ramps 69S-167th St and 69N-151st St"]
[{"$nulls":3},"2.3.2.5",null,"Create vertical alignment for 159th St"]
[{"$nulls":3},"2.3.2.6",null,"Develop geometrics for side roads and entrances "]
[{"$nulls":3},"2.3.2.7",null,"Coordinate design of west end of 159th St. with Affinis"]
[{"$nulls":3},"2.3.2.8",null,"Design horizontal alignments for Hike/Bike trails"]
[{"$nulls":3},"2.3.2.9",null,"Design vertical alignments for Hike/Bike trails"]
[{"$nulls":3},"2.3.2.10",null,"Design pavement edges for US 69 and ramps"]
[{"$nulls":3},"2.3.2.11",null,"Design pavement edges and curb layouts for 159th St., side roads, and entrances"]
[{"$nulls":3},"2.3.2.12",null,"Perform clear zone analysis"]
[{"$nulls":3},"2.3.2.13",null,"Design safety barriers, impact protection, and determine guardrail locations"]
[{"$nulls":3},"2.3.2.14",null,"Review intersection sight distance"]
[{"$nulls":3},"2.3.2.15",null,"Develop intersection details"]
[{"$nulls":3},"2.3.2.16",null,"Develop preliminary joint layout"]
[]
[{"$nulls":3},"2.3.3","Retaining Walls"]
[{"$nulls":3},"2.3.3.1",null,"Develop retaining wall typical sections"]
[{"$nulls":3},"2.3.3.2",null,"Determine locations and horizontal alignments for up to 6 walls"]
[{"$nulls":3},"2.3.3.3",null,"Design vertical alignments for up to 6 walls"]
[{"$nulls":3},"2.3.3.4",null,"Create preliminary retaining wall plan/profile sheets"]
[]
[{"$nulls":3},"2.3.4","Right-of-Way"]
[{"$nulls":3},"2.3.4.1",null,"Prepare COGO file calculating location of proposed right-of-way and construction easements"]
[{"$nulls":3},"2.3.4.2",null,"Create right-of-way strip map for US 69"]
[{"$nulls":3},"2.3.4.3",null,"Determine construction limits, right-of-way/easement requirements, and develop right-of-way plans"]
[{"$nulls":3},"2.3.4.4",null,"Coordinate right-of-way processing with KDOT and the City of Overland Park"]
[{"$nulls":3},"2.3.4.5",null,"Develop fencing layout in coordination with KDOT district"]
[{"$nulls":3},"2.3.4.6",null,"Contact homes associations and/or property owners to field locate all existing irrigation systems and to obtain “as-built” plans where available.  Assumes no more than 8 systems."]
[]
[{"$nulls":3},"2.3.5","Traffic Engineering"]
[{"$nulls":3},"2.3.5.1",null,"Create preliminary KDOT lighting plans (U.S. 69 ramp lighting)"]
[{"$nulls":3},"2.3.5.2",null,"Develop City Lighting Plans (159th Street Lighting)"]
[{"$nulls":3},"2.3.5.3",null,"Create preliminary traffic signal plans (6 new signals, 1 modification)"]
[{"$nulls":3},"2.3.5.4",null,"Develop Fiber Optic Interconnect Layout"]
[{"$nulls":3},"2.3.5.5",null,"Create DMS Message Sign Layout"]
[{"$nulls":3},"2.3.5.6",null,"Develop preliminary pavement marking layout"]
[{"$nulls":3},"2.3.5.7",null,"Create preliminary signing layout "]
[{"$nulls":3},"2.3.5.8",null,"Develop general sequencing concept"]
[{"$nulls":3},"2.3.5.9",null,"Develop preliminary traffic control typical sections"]
[{"$nulls":3},"2.3.5.10",null,"Develop preliminary sequencing/traffic control plans"]
[]
[{"$nulls":3},"2.3.6","Cross Sections"]
[{"$nulls":3},"2.3.6.1",null,"Develop proposed surface model for US 69"]
[{"$nulls":3},"2.3.6.2",null,"Develop proposed surface model for all ramps"]
[{"$nulls":3},"2.3.6.3",null,"Develop proposed surface model for 159th St and side roads"]
[{"$nulls":3},"2.3.6.4",null,"Develop cross sections for US 69"]
[{"$nulls":3},"2.3.6.5",null,"Develop cross sections for 159th St interchange ramps"]
[{"$nulls":3},"2.3.6.6",null,"Develop cross sections for Ramps 69S-167th St and 69N-151st St"]
[{"$nulls":3},"2.3.6.7",null,"Develop cross sections for 159th St and side roads"]
[{"$nulls":3},"2.3.6.8",null,"Incorporate results of geologic investigation into cross sections for US 69 and interchange ramps with specific focus on areas that will affect ROW."]
[]
[{"$nulls":3},"2.3.7","Landscaping"]
[{"$nulls":3},"2.3.7.1",null,"Review the goals and expectations for the landscape planting treatments within the intersection of 159th St. and 69 Highway with City of Overland Park staff, the project engineer and KDOT staff."]
[{"$nulls":3},"2.3.7.2",null,"Site visit along  proposed roadway alignment to review and document existing conditions.  "]
[{"$nulls":3},"2.3.7.3",null,"Prepare two alternative design concepts for landscape enhancement treatments within the interchange of 159th Street and 69 Highway. These designs will explore ideas for complementing and enhancing existing features adjacent to the proposed interchange as well as the proposed landscaping along 159th Street. "]
[{"$nulls":3},"2.3.7.4",null,"Attend a concept review meeting with the City and the project engineer to review the alternative design concepts described above."]
[{"$nulls":3},"2.3.7.5",null,"Prepare a landscape plan for landscape enhancements for the 159th Street and 69 Highway interchange based on input received from the concept review meeting."]
[{"$nulls":3},"2.3.7.6",null,"Prepare landscape base plan and detail sheet formatting"]
[]
[{"$nulls":3},"2.3.8","Create Title Sheet"]
[{"$nulls":3},"2.3.9","Create General Notes Sheet"]
[{"$nulls":3},"2.3.10","Develop Survey Reference Sheet"]
[{"$nulls":3},"2.3.11","Assist with meeting preparation for public involvement"]
[{"$nulls":3},"2.3.12","Coordination of future US 69 design elements (Noise walls, future reconstruction, grading, site development)"]
[{"$nulls":3},"2.3.13","Create exhibits for design and coordination meetings (Assumes 8 exhibits)"]
[{"$nulls":3},"2.3.14","Calculate quantities and develop field check cost estimate"]
[{"$nulls":3},"2.3.15","Perform constructability review"]
[{"$nulls":3},"2.3.16","Address Field Check/Right-of-Way comments"]
[{"$nulls":3},"2.3.17","Quality Assurance"]
[]
[{"$nulls":5},"Subtotal"]
[null,null,"2.4  Drainage"]
[{"$nulls":3},"2.4.1","Bridge Analysis"]
[{"$nulls":3},"2.4.1.1",null,"Deck drainage (2 bridges on 159th St)"]
[]
[{"$nulls":3},"2.4.2","Culvert Design (159th St: 2, US 69: 4)"]
[{"$nulls":3},"2.4.2.1",null,"Delineate drainage areas for inlets and culverts and prepare Drainage Area Map Sheets. "]
[{"$nulls":3},"2.4.2.2",null,"Refine design discharges from concept design for culverts smaller than 500 series pipe culverts (5)"]
[{"$nulls":3},"2.4.2.3",null,"Refine existing conditions HEC-RAS model for culvert at Negro Creek (1)"]
[{"$nulls":3},"2.4.2.4",null,"Develop proposed conditions HEC-RAS model for culvert at Negro Creek (1)"]
[{"$nulls":3},"2.4.2.5",null,"Perform culvert design for smaller than 500-series culverts, including type, size, and elevation (5)"]
[{"$nulls":3},"2.4.2.6",null,"Culvert Profiles (6)"]
[{"$nulls":3},"2.4.2.7",null,"Perform outlet protection calculations (6)"]
[{"$nulls":3},"2.4.2.8",null,"Develop temporary traffic control drainage "]
[{"$nulls":3},"2.4.2.9",null,"Provide drainage details and construction information on roadway plan sheets"]
[]
[{"$nulls":3},"2.4.3","Enclosed System"]
[{"$nulls":3},"2.4.3.1",null,"Develop inlet layout"]
[{"$nulls":3},"2.4.3.2",null,"Perform spread calculations and determine top elevations"]
[{"$nulls":3},"2.4.3.3",null,"Create shoulder inlet layout in ramp areas and along CSB on main line US 69"]
[{"$nulls":3},"2.4.3.4",null,"Develop median inlet layout between NB/SB US 69"]
[{"$nulls":3},"2.4.3.5",null,"Perform pipe design calculations"]
[{"$nulls":3},"2.4.3.6",null,"Create pipe profiles"]
[{"$nulls":3},"2.4.3.7",null,"Create plan sheet construction notes"]
[{"$nulls":3},"2.4.3.8",null,"Create pipe calculation sheet"]
[]
[{"$nulls":3},"2.4.4","Ditch Design"]
[{"$nulls":3},"2.4.4.1",null,"Perform ditch design and develop ditch profiles"]
[{"$nulls":3},"2.4.4.2",null,"Determine permanent erosion protection for ditches"]
[]
[{"$nulls":3},"2.4.5","Quality Assurance"]
[]
[{"$nulls":5},"Subtotal"]
[null,null,"2.5  Sanitary"]
[{"$nulls":3},"2.5.1","Sanitary Sewer relocation layout"]
[{"$nulls":3},"2.5.2","Review with JCW"]
[{"$nulls":3},"2.5.3","Perform pipe design calculations"]
[{"$nulls":3},"2.5.4","Develop pipe profiles"]
[{"$nulls":3},"2.5.5","Develop plan sheet construction notes"]
[{"$nulls":3},"2.5.6","Quality Assurance"]
[]
[{"$nulls":5},"Subtotal"]
[null,null,"2.6  Erosion Control"]
[{"$nulls":3},"2.6.1","Visit site for design investigation and verification of existing conditions."]
[{"$nulls":3},"2.6.2","Discuss BMP's and strategies for ESC efforts particular to this project.  Create marked up plan sheets that parallel the traffic control phasing for 159th, establishing the original layout of the phased erosion control plans.  Create unphased marked up plan sheets for US 69."]
[{"$nulls":3},"2.6.3","Meet with City staff to review cursory marked up ESC plan sheets, discuss strategies, and set direction for further development of the phased ESC plans.  Assumes 2 people for 4 hours with meeting minutes prepared and distributed."]
[{"$nulls":3},"2.6.4","Adjust and develop phased ESC plans according to strategies discussed with City at meeting.  Convert marked up plans to electronic plans, create construction notes for placement on ESC plan sheets.  "]
[{"$nulls":3},"2.6.5","Create preliminary detail sheets (assumes application of standard City details)"]
[{"$nulls":3},"2.6.6","Quality Assurance"]
[]
[{"$nulls":5},"Subtotal"]
[null,null,"2.7 Environmental"]
[{"$nulls":3},"2.7.1","KDOT will conduct all necessary Environmental Investigations and develop a summary report. HNTB will review the KDOT Environmental Summary Document. Preliminary development of project permits and meetings with reviewing agencies (assume 3 meetings)."]
[{"$nulls":3},"2.7.2","Delineate wetlands for Corps of Engineers 404 permit"]
[{"$nulls":3},"2.7.3","Quality Assurance"]
[]
[{"$nulls":5},"Subtotal"]
[null,null,"2.8 Geotechnical"]
[{"$nulls":3},"2.8.1","Assist in Historical Data Search"]
[{"$nulls":3},"2.8.2","Assist PM with Management of Geotechnical Subconsultant"]
[{"$nulls":3},"2.8.3","Review of Geotechnical Subconsultant Field Investigations and Reports"]
[{"$nulls":3},"2.8.4","Prepare Subsurface Digital Terrain Models"]
[{"$nulls":3},"2.8.5","Mainline Roadway Graphic Geologic Display"]
[{"$nulls":3},"2.8.6","Quality Assurance"]
[]
[{"$nulls":5},"Subtotal"]
[null,null,"2.9 Structural"]
[{"$nulls":3},"2.9.1","159th Street Bridges"]
[{"$nulls":3},"2.9.1.1",null,"Attend design team kickoff meeting and initialize work plan for bridge design tasks."]
[{"$nulls":3},"2.9.1.2",null,"Prepare Typical Bridge Roadway Section for each bridge."]
[{"$nulls":3},"2.9.1.3",null,"Perform geometric studies to evaluate alternate bridge layout configurations and determine clearances."]
[{"$nulls":3},"2.9.1.4",null,"Bridge Architect to develop aesthetic concepts for bridge piers and pedestrian handrails."]
[{"$nulls":3},"2.9.1.5",null,"Perform preliminary structural design as required to support structure type and size decisions."]
[{"$nulls":3},"2.9.1.6",null,"Create a Construction Layout drawing for each bridge."]
[{"$nulls":3},"2.9.1.7",null,"Study construction phasing options and recommend project specific staging sequence for construction of proposed bridges."]
[{"$nulls":3},"2.9.1.8",null,"Develop preliminary details for pier configuration."]
[{"$nulls":3},"2.9.1.9",null,"Create one Contour Map for 159th Street / US 69 interchange."]
[{"$nulls":3},"2.9.1.10",null,"Develop Bridge Design Criteria specific for this project."]
[]
[{"$nulls":3},"2.9.2","Retaining Walls"]
[{"$nulls":3},"2.9.2.1",null,"Develop design guidelines for retaining walls and noise walls."]
[{"$nulls":3},"2.9.2.2",null,"Provide structural engineering support to roadway designers and geotechnical engineers during concept development for walls."]
[{"$nulls":3},"2.9.2.3",null,"Prepare structural details for retaining wall systems selected for the project - typical wall sections and common details."]
[{"$nulls":3},"2.9.2.4",null,"Coordinate with proprietary retaining wall manufacturers to research solutions to project-specific design challenges."]
[{"$nulls":3},"2.9.2.5",null,"Perform feasibility study for construction of future noise walls within project limits.  Develop concept recommendation and constructability considerations that could impact this project."]
[]
[{"$nulls":3},"2.9.3","Drainage Structures and Roadside Safety Structures"]
[{"$nulls":3},"2.9.3.1",null,"Conduct site visit and perform inspection of existing reinforced concrete box structures. Document field observations and recommendations for repairs or structure modifications."]
[{"$nulls":3},"2.9.3.2",null,"Coordinate transfer of survey, grading and hydraulic design information from other team members."]
[{"$nulls":3},"2.9.3.3",null,"Initialize structure geometrics for RCB barrel lengths, headwall configurations, and culvert profiles."]
[{"$nulls":3},"2.9.3.4",null,"Assist with concept illustration for concrete traffic barriers."]
[]
[{"$nulls":3},"2.9.4","Quality Assurance"]
[]
[{"$nulls":5},"Subtotal"]
[null,null,"2.10 Public Involvement"]
[{"$nulls":3},"2.10.1","Prep for and attend one open house public meeting. Prep includes drafting display information, handouts, comment forms, sign in sheets, securing location and set up for the meeting. One 11x17 color newsletter handout will be created for the meeting and sent out to area residents and business owners along the corridor.  Up to 2 display boards will be developed along with aerial map of project area."]
[{"$nulls":3},"2.10.2","Comment Log Development--manage and track all incoming comments and arrange systematically for ease of tracking and responses.  Organize in an electronic file as well as a hard copy.  "]
[{"$nulls":3},"2.10.3","Quality Assurance"]
[]
[{"$nulls":5},"Subtotal"]
[null,null,"2.11 Utility Coordination"]
[{"$nulls":3},"2.11.1","Develop “List of Utilities and Status” (1304) form","Develop “List of Utilities and Status” (1304) form"]
[{"$nulls":3},"2.11.2","Meet with utilities to identify and discuss conflicts (Assume 2 Utility Meetings @ 3 hours each)","Meet with utilities to identify and discuss conflicts (Assume 2 Utility Meetings @ 3 hours each)"]
[{"$nulls":3},"2.11.3","Identify any permitting requirements (i.e. KDOT permit, stream crossings)","Identify any permitting requirements (i.e. KDOT permit, stream crossings)"]
[{"$nulls":3},"2.11.4","Update electronic files and review for conflicts","Update electronic files and review for conflicts"]
[{"$nulls":3},"2.11.5","Identify any additional potholing required","Identify any additional potholing required"]
[{"$nulls":3},"2.11.6","Setup additional individual meetings based on pothole information – resolve any issues and determine solutions","Setup additional individual meetings based on pothole information – resolve any issues and determine solutions"]
[{"$nulls":3},"2.11.7","Coordinate and incorporate utility owner review comments into base mapping for utilities and easements","Coordinate and incorporate utility owner review comments into base mapping for utilities and easements"]
[{"$nulls":3},"2.11.8","Resubmit updated electronic files to utilities – ask utilities to review and confirm (Assume 10 occurrences)","Resubmit updated electronic files to utilities – ask utilities to review and confirm (Assume 10 occurances)"]
[{"$nulls":3},"2.11.9","Follow-up meeting with utilities (Assume 2 Utility Meetings @ 3 hours each)","Follow-up meeting with utilities (Assume 2 Utility Meetings @ 3 hours each)"]
[{"$nulls":3},"2.11.10","Review drafts of utility agreements for KDOT Right of Way","Review drafts of utility agreements for KDOT Right of Way"]
[{"$nulls":3},"2.11.11","Solidify necessary utility easements","Solidify necessary utility easements"]
[{"$nulls":3},"2.11.12","Quality Assurance"]
[]
[{"$nulls":5},"Subtotal"]
[null,null,"2.12 Administration/Meetings"]
[{"$nulls":3},"2.12.1","Attend pre-design meeting. (Assume 3 people for 2 hours with meeting minutes prepared and distributed)"]
[{"$nulls":3},"2.12.2","Attend OP/KDOT coordination meeting."]
[{"$nulls":3},"2.12.3","Attend OP/KDOT Metro utility coordination meeting.","Attend OP/KDOT Metro coordination meeting."]
[{"$nulls":3},"2.12.4","Correspondence with developers and property owners on project related items via phone, fax, email and mail (assumes average 2 hours per week for 10 months)."]
[{"$nulls":3},"2.12.5","Develop a MS Project design schedule. Schedule to include: Surveys complete, Data collection complete, Preliminary plans complete, Preliminary Plans to utilities, Field check plans complete, Right of Way plans complete, and Public Meetings. Update at major milestones (assumes 4 updates)."]
[{"$nulls":3},"2.12.6","Preparation and attendance at periodic review meetings with the City and KDOT (Assume 4)"]
[{"$nulls":3},"2.12.7","Project Coordination with the City and others. Assume two people attending a meeting with the City each month (2 staff @ 2 hours = 4 hours). Also assumes weekly calls with KDOT and the City (2 staff @ 0.5 hours with KDOT and the City = 2 hours per week) plus one hour for developing meeting/phone minutes."]
[{"$nulls":3},"2.12.8","Prepare monthly progress reports and submit bi-weekly email describing completed work, upcoming work, and action items."]
[{"$nulls":3},"2.12.9","Submit Field Check Plans (assume 1 plan submittal)"]
[{"$nulls":3},"2.12.10","Prepare for and attend Field Check meeting"]
[{"$nulls":3},"2.12.11","Submit Plans to Utilities (assume 1 plan submittal)"]
[{"$nulls":3},"2.12.12","Submit R/W Plans (assume 1 plan submittal)"]
[]
[{"$nulls":5},"Subtotal"]
[null,"Phase 2 - Field Check/Right of Way Plans"]
[null,"Phase 2 Fee Summary"]
[{"$nulls":5},"Labor:",null,null,"Project Manager @ $58/hour",0]
[{"$nulls":8},"Sr. Engineer @ $41/hour",0]
[{"$nulls":8},"Engineer @ $33/hour",0]
[{"$nulls":8},"Technician @ $28.5/hour",0]
[{"$nulls":8},"Direct Payroll:",0]
[]
[{"$nulls":8},"Multiplier (3.0)",0]
[]
[{"$nulls":5},"Labor Division",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
[{"$nulls":5},"Expenses:",null,null,"Printing/Plotting ="]
[{"$nulls":8},"Travel ="]
[{"$nulls":8},"Misc. ="]
[{"$nulls":8},"Total Expense"]
[]
[]
[{"$nulls":5},"Subconsultants:",null,null,"Vacuum Excavation ="]
[{"$nulls":8},"Terracon (Design Services) ="]
[null,"1.","Vacuum excavation assumes 20 hours at $150/hour and includes backfill and street repair as required.",{"$nulls":5},"The Technology Group ="]
[null,"2.","Two retaining wall subconsultants will be retained for the design support.",{"$nulls":5},"Retaining Wall Design Support = "]
[{"$nulls":8},"Total Subconsultant Expense"]
[]
[]
[{"$nulls":5},"Remaining unused fee from Original Contract :",null,null,"Original Contract Fee (Unused) ="]
[{"$nulls":8},"Total Fee SA No. 2 (Net Increase) ="]
[]
[{"$nulls":8},"SA No. 1 ="]
[{"$nulls":5},"Supplemental Agreement No. 1 (Utility Coordination) Termination:",null,null,"Termination of SA No. 1 ="]
[]
[]
[{"$nulls":8},"Original Contract Amount ="]
[]
[{"$nulls":8},"New Upper Limit Amount ="]

{"sheet":"SA No. 3 Final Plans","index":1,"n_rows":362,"n_cols":11,"rows_kept":362,"merged":[[1,12,1,16],[1,18,1,22],[1,24,1,28],[1,30,1,34],[1,36,1,40],[1,42,1,46],[1,48,1,52],[1,54,1,58],[42,4,42,5],[43,4,43,5],[44,4,44,5],[45,4,45,5],[46,4,46,5],[47,4,47,5],[48,4,48,5],[49,4,49,5],[50,4,50,5],[51,4,51,5],[52,4,52,5],[125,4,125,5],[130,4,130,5],[195,4,195,5],[196,4,196,5],[197,4,197,5],[198,4,198,5],[199,4,199,5],[200,4,200,5],[205,4,205,5],[291,4,291,5],[292,4,292,5],[297,4,297,5],[298,4,298,5],[299,4,299,5],[300,4,300,5],[301,4,301,5],[302,4,302,5],[303,4,303,5],[304,4,304,5],[322,4,322,5],[323,4,323,5],[324,4,324,5],[325,4,325,5],[326,4,326,5],[327,4,327,5],[328,4,328,5],[329,4,329,5],[330,4,330,5],[331,4,331,5],[332,4,332,5],[333,4,333,5],[334,4,334,5],[335,4,335,5],[357,2,357,5],[358,2,358,5],[359,2,359,5]],"flags":["formulas_cached_only"]}
[]
[]
[{"$nulls":5},"                Item of Work","Project Manager","Senior Engineer/ Planner","Engineer/ Planner","Technician","Total"]
[null,"Phase 3 - Final Plans"]
[{"$nulls":3},"2.1 Data Collection"]
[{"$nulls":3},"2.1.1",null,"Perform GPS and Total Station surveys within the design corridor of:"]
[{"$nulls":5},"     g. Flag locations of up to 10 soil borings and return to survey actual locations "]
[{"$nulls":5},"     h. stake centerline of 159th Street for use by utilities doing relocations"]
[{"$nulls":5},"     i. flag proposed ROW and Esmts (assume 15) for use by appraisers and owners"]
[{"$nulls":5},"     j. miscellaneous pick-up surveys"]
[{"$nulls":3},"2.1.2",null,"Prepare COGO file calculating location of proposed right of way and construction easements"]
[{"$nulls":3},"2.1.3",null,"Prepare and check legal descriptions and tract map exhibits for right of way acquisition process"]
[{"$nulls":3},"2.1.4",null,"Assist with preparation of Survey Reference Sheet and review plan sheets for completeness and accuracy"]
[{"$nulls":3},"2.1.5",null,"Prepare 3 sets of KDOT field books"]
[]
[]
[]
[null,null,"2.1 Traffic Simulation "]
[{"$nulls":3},"2.1.1",null,"Develop/Run Existing Conditions Simulation Model "]
[{"$nulls":3},"2.1.2",null,"Develop/Run Future Build & No-build Conditions Simulation Model "]
[{"$nulls":3},"2.1.3",null,"Model Results - Operational Analysis"]
[{"$nulls":3},"2.1.4",null,"Revise Operational Analysis"]
[{"$nulls":3},"2.1.5",null,"Prepare Traffic Memorandum"]
[]
[null,null,"2.2 Interchange Geometrics "]
[{"$nulls":3},"2.2.1",null,"Refine Preliminary Horizontal/Vertical Geometrics"]
[{"$nulls":3},"2.2.2",null,"Revise Preliminary Horizontal/Vertical Geometrics"]
[{"$nulls":3},"2.2.3",null,"Develop Preliminary Cross Sections"]
[{"$nulls":3},"2.2.4",null,"Determine Preliminary ROW requirements"]
[]
[null,null,"2.3 Break-in-Access Request "]
[{"$nulls":3},"2.3.1",null,"Develop Break-in-Access Request"]
[]
[null,null,"2.4 Cost Estimate "]
[{"$nulls":3},"2.4.1",null,"Determine preliminary project cost estimate "]
[]
[null,null,"2.5 Meetings"]
[{"$nulls":3},"2.5.1",null,"Review Agency Meetings  (attend and prepare for 2 assumed)"]
[{"$nulls":3},"2.5.2",null,"Stakeholder Meetings  (attend and prepare for 1 assumed)"]
[{"$nulls":3},"2.5.3",null,"Council Presentations  (attend and prepare for 1 assumed)"]
[]
[null,null,"3.1  Data Collection"]
[{"$nulls":3},"3.1.1","Prepare and check legal descriptions and tract map exhibits for right of way acquisition process (Assumes 30 tracts)"]
[{"$nulls":3},"3.1.2","Update legal descriptions per right-of-way plan comments"]
[{"$nulls":3},"3.1.3","Create renderings of improvements at up to 10 impacted properties"]
[{"$nulls":3},"3.1.4","Prepare color drawings showing takings for each ownership tract (Assumes 30 tracts)"]
[{"$nulls":3},"3.1.5","Field staking of rights-of-way and easements for up to 30 tracts"]
[{"$nulls":3},"3.1.6","Prepare color drawings showing takings for each ownership tract (Assumes 30 tracts)"]
[{"$nulls":3},"3.1.7","Review and update title work and develop list of comments for possible changes. "]
[{"$nulls":3},"3.1.8","Review and update title work as necessary during right-of-way acquisition"]
[{"$nulls":3},"3.1.9","Determine and stake locations of soil borings for bridges, culverts, sign structures, lights and retaining walls per Geotechnical Scope (assume 69 borings). Pickup borings after geotechnical investigations are complete (assume 69)."]
[{"$nulls":3},"3.1.10","Re-survey areas within project limits that changes (due to development, etc.) during the design process.  "]
[{"$nulls":3},"3.1.11","Quality Assurance"]
[]
[{"$nulls":5},"Subtotal"]
[null,null,"3.2  Traffic"]
[{"$nulls":5},"Subtotal"]
[null,null,"3.3  Roadway"]
[{"$nulls":3},"3.3.1","Typical Sections"]
[{"$nulls":3},"3.3.1.1",null,"Finalize US 69 Typical Sections"]
[{"$nulls":3},"3.3.1.2",null,"Finalize Ramp Typical Sections"]
[{"$nulls":3},"3.3.1.3",null,"Finalize 159th St and side road Typical Sections"]
[{"$nulls":3},"3.3.1.4",null,"Finalize Miscellaneous Typical Sections"]
[]
[{"$nulls":3},"3.3.2","Geometrics"]
[{"$nulls":3},"3.3.2.1",null,"Finalize pavement edges"]
[{"$nulls":3},"3.3.2.2",null,"Update safety barrier layouts and develop special details  "]
[{"$nulls":3},"3.3.2.3",null,"Develop guardrail design and create layout sheets"]
[{"$nulls":3},"3.3.2.4",null,"Finalize curb return profiles (Assumes 28 curb returns)"]
[{"$nulls":3},"3.3.2.5",null,"Complete intersection details"]
[{"$nulls":3},"3.3.2.6",null,"Develop ADA sidewalk ramp layouts (15)"]
[{"$nulls":3},"3.3.2.7",null,"Coordinate design with Affinis"]
[{"$nulls":3},"3.3.2.8",null,"Create joint layouts and develop joint plans"]
[{"$nulls":3},"3.3.2.9",null,"Update fencing plans"]
[]
[{"$nulls":3},"3.3.3","Retaining Walls"]
[{"$nulls":3},"3.3.3.1",null,"Finalize retaining wall typical sections"]
[{"$nulls":3},"3.3.3.2",null,"Revise horizontal alignments for up to 6 walls"]
[{"$nulls":3},"3.3.3.3",null,"Revise vertical alignments for up to 6 walls"]
[]
[{"$nulls":3},"3.3.4","Right of Way"]
[{"$nulls":3},"3.3.4.1",null,"Update tract numbers and ownership information based on title report updates"]
[{"$nulls":3},"3.3.4.2",null,"Update existing and proposed easements and approximate construction limits based on development, review comments, and title report updates."]
[{"$nulls":3},"3.3.4.3",null,"Attend right-of-way debriefing meeting with City and the acquisition agent."]
[]
[{"$nulls":3},"3.3.5","Traffic Engineering"]
[{"$nulls":3},"3.3.5.1",null,"Complete KDOT lighting plans (U.S. 69 ramp lighting)"]
[{"$nulls":3},"3.3.5.2",null,"Complete final City lighting plans"]
[{"$nulls":3},"3.3.5.3",null,"Finalize traffic signal plans (6 new signals, 1 modification)"]
[{"$nulls":3},"3.3.5.4",null,"Complete lighting circuit design"]
[{"$nulls":3},"3.3.5.5",null,"Complete traffic signal wiring"]
[{"$nulls":3},"3.3.5.6",null,"Finalize DMS plans and details"]
[{"$nulls":3},"3.3.5.7",null,"Complete fiber optic interconnect design"]
[{"$nulls":3},"3.3.5.8",null,"Finalize signing plans"]
[{"$nulls":3},"3.3.5.9",null,"Finalize overhead sign panel layouts and details"]
[{"$nulls":3},"3.3.5.10",null,"Complete KDOT signing standards"]
[{"$nulls":3},"3.3.5.11",null,"Finalize pavement marking plans"]
[{"$nulls":3},"3.3.5.12",null,"Complete sequencing/traffic control plans"]
[{"$nulls":3},"3.3.5.13",null,"Complete traffic control and detour route signing"]
[{"$nulls":3},"3.3.5.14",null,"Complete traffic control standards and quantities"]
[{"$nulls":3},"3.3.5.15",null,"Prepare plan and profiles for temporary ramps (151st Street and US 69 and 167th Street and US 69). Assumes two ramps with two phases each. "]
[]
[{"$nulls":3},"3.3.6","Cross Sections"]
[{"$nulls":3},"3.3.6.1",null,"Finalize and phase proposed surface model for US 69"]
[{"$nulls":3},"3.3.6.2",null,"Finalize and phase proposed surface model for all ramps"]
[{"$nulls":3},"3.3.6.3",null,"Finalize and phase proposed surface model for 159th St and side roads"]
[{"$nulls":3},"3.3.6.4",null,"Incorporate revised retaining wall design into cross sections"]
[{"$nulls":3},"3.3.6.5",null,"Incorporate revised drainage design into cross sections"]
[{"$nulls":3},"3.3.6.6",null,"Update cross section layout"]
[{"$nulls":3},"3.3.6.7",null,"Develop phased cross sections for earthwork calculation purposes only.  Develop phased cross sections for incorporation into the plans only in areas necessary to properly illustrate the intention of the construction sequence.  "]
[]
[{"$nulls":3},"3.3.7","Landscaping"]
[{"$nulls":3},"3.3.7.1",null,"Finalize the \"Field Check\" landscape plan based on review comments, and prepare landscaping plans and specifications as necessary to facilitate construction."]
[{"$nulls":3},"3.3.7.2",null,"Attend review meetings with the project team and the City."]
[{"$nulls":3},"3.3.7.3",null,"Prepare final quantity take-offs and an opinion of probable construction cost for landscape plantings."]
[]
[{"$nulls":3},"3.3.8","Create Irrigation (lawn sprinkler) restoration plans for up to 6 systems"]
[{"$nulls":3},"3.3.8.1",null,"Meet with owners irrigation consultants"]
[{"$nulls":3},"3.3.8.2",null,"Conduct field check survey of existing irrigation systems"]
[{"$nulls":3},"3.3.8.3",null,"Prepare interim irrigation layout plan "]
[{"$nulls":3},"3.3.8.4",null,"Prepare final irrigation layout plan "]
[{"$nulls":3},"3.3.8.5",null,"Coordinate design with owners/city"]
[{"$nulls":3},"3.3.8.6",null,"Create general irrigation construction notes"]
[{"$nulls":3},"3.3.8.7",null,"Prepare irrigation specifications"]
[]
[{"$nulls":3},"3.3.9","Incorporate changes into plans, specifications, quantities, etc."]
[{"$nulls":3},"3.3.10","Create development monument restoration plans and details"]
[{"$nulls":3},"3.3.11","Create tree and shrub replacement schedule"]
[{"$nulls":3},"3.3.12","Develop special provisions"]
[{"$nulls":3},"3.3.13","Compile standards, details, and specifications"]
[{"$nulls":3},"3.3.14","Coordination of future design elements (Noise walls, future reconstruction, grading, site development)"]
[{"$nulls":3},"3.3.15","Calculate final quantities and create quantity summaries"]
[{"$nulls":3},"3.3.16","Attend design and coordination meetings"]
[{"$nulls":3},"3.3.17","Create exhibits for design and coordination meetings"]
[{"$nulls":3},"3.3.18","Develop final cost estimate"]
[]
[{"$nulls":3},"3.3.19","Address Final Plan Comments"]
[{"$nulls":3},"3.3.20","Address Traffic Engineering Comments"]
[{"$nulls":3},"3.3.21","Quality Assurance"]
[]
[{"$nulls":5},"Subtotal"]
[null,null,"3.4  Drainage"]
[{"$nulls":3},"3.4.1","Bridge Analysis"]
[{"$nulls":3},"3.4.1.1",null,"Update deck drainage (1 bridge on 159th)"]
[]
[{"$nulls":3},"3.4.2","Culvert Design (159th: 2, US 69: 4)"]
[{"$nulls":3},"3.4.2.1",null,"Update proposed conditions HEC-RAS model for culvert at Negro Creek (1)"]
[{"$nulls":3},"3.4.2.2",null,"Update culvert hydraulics"]
[{"$nulls":3},"3.4.2.3",null,"Update culvert profiles"]
[{"$nulls":3},"3.4.2.4",null,"Update outlet protection calculations (1)"]
[{"$nulls":3},"3.4.2.5",null,"Update temporary traffic control drainage "]
[{"$nulls":3},"3.4.2.6",null,"Update drainage details and construction information on roadway plan sheets"]
[{"$nulls":3},"3.4.2.7",null,"Update quantity spreadsheet drainage items"]
[]
[{"$nulls":3},"3.4.3","Prepare FEMA CLOMR and LOMR Submittal"]
[{"$nulls":3},"3.4.3.1",null,"Prepare effective 4-frequency & floodway models"]
[{"$nulls":3},"3.4.3.2",null,"Run duplicate effective 4-frequency & floodway models"]
[{"$nulls":3},"3.4.3.3",null,"Prepare & run corrected effective 4-frequency & floodway models"]
[{"$nulls":3},"3.4.3.4",null,"Run existing/pre-project 4-frequency & floodway models"]
[{"$nulls":3},"3.4.3.5",null,"Run revised/project 4-frequency & floodway models"]
[{"$nulls":3},"3.4.3.6",null,"Prepare Floodplain & floodway maps with BFE's for City review"]
[{"$nulls":3},"3.4.3.7",null,"Prepare map revision forms"]
[{"$nulls":3},"3.4.3.8",null,"Prepare final revised floodplain/floodway maps"]
[{"$nulls":3},"3.4.3.9",null,"Prepare revised profiles and data tables"]
[{"$nulls":3},"3.4.3.10",null,"Develop response to FEMA"]
[]
[{"$nulls":3},"3.4.4","Enclosed System"]
[{"$nulls":3},"3.4.4.1",null,"Update inlet layout"]
[{"$nulls":3},"3.4.4.2",null,"Update spread calculations and top elevations"]
[{"$nulls":3},"3.4.4.3",null,"Update shoulder inlet layout in ramp areas and along CSB on US 69"]
[{"$nulls":3},"3.4.4.4",null,"Update median inlet layout between NB/SB US 69"]
[{"$nulls":3},"3.4.4.5",null,"Update pipe design"]
[{"$nulls":3},"3.4.4.6",null,"Update pipe profiles"]
[{"$nulls":3},"3.4.4.7",null,"Update plan sheets/construction notes"]
[{"$nulls":3},"3.4.4.8",null,"Update pipe schedule/summary tables"]
[{"$nulls":3},"3.4.4.9",null,"Coordinate retaining wall perforated pipes"]
[]
[{"$nulls":3},"3.4.5","Ditch Design"]
[{"$nulls":3},"3.4.5.1",null,"Update ditch design and ditch profiles"]
[{"$nulls":3},"3.4.5.2",null,"Determine permanent erosion protection for ditches"]
[]
[{"$nulls":3},"3.4.6","Quality Assurance"]
[]
[{"$nulls":5},"Subtotal"]
[null,null,"3.5  Sanitary"]
[{"$nulls":3},"3.5.1","Update Sanitary Sewer relocation layout"]
[{"$nulls":3},"3.5.2","Update Pipe design"]
[{"$nulls":3},"3.5.3","Update Pipe Profiles"]
[{"$nulls":3},"3.5.4","Update Plan sheets/construction notes"]
[{"$nulls":3},"3.5.5","Conduct final review with JCW"]
[{"$nulls":3},"3.5.6","Develop Project Specifications"]
[{"$nulls":3},"3.5.7","Quality Assurance"]
[]
[{"$nulls":5},"Subtotal"]
[null,null,"3.6  Erosion Control"]
[{"$nulls":3},"3.6.1","Create narrative explanations for US 69 plan and each phase of 159th St ESC plan."]
[{"$nulls":3},"3.6.2","Check design for 2-year return interval (hydraulic analysis)."]
[{"$nulls":3},"3.6.3","Develop details of non-standard BMPs included in this plan."]
[{"$nulls":3},"3.6.4","Develop ESC quantities for US 69 and phased ESC quantities for 159th St.  Include summary table of these for each phase."]
[{"$nulls":3},"3.6.5","Create ESC special provisions for contract documents."]
[{"$nulls":3},"3.6.6","Review design with City staff and make requested revisions."]
[{"$nulls":3},"3.6.7","Quality assurance"]
[]
[{"$nulls":5},"Subtotal"]
[null,null,"3.7 Environmental"]
[{"$nulls":3},"3.7.1","Prepare the necessary plans and applications for permit submission to and approval of: Develop and submit permits: NPDES, COE 404 Nationwide, DWR Stream Obstruction"]
[{"$nulls":3},"3.7.1.1",null,"Division of Water Resources (DWR) Stream Obstruction"]
[{"$nulls":3},"3.7.1.2",null,"US Army Corps of Engineers (COE) 404 Nationwide"]
[{"$nulls":3},"3.7.1.3",null,"NPDES"]
[{"$nulls":3},"3.7.1.4",null,"City of Overland Park Floodplain Development"]
[{"$nulls":3},"3.7.2","Quality Assurance"]
[]
[{"$nulls":5},"Subtotal"]
[null,null,"3.8 Geotechnical"]
[{"$nulls":3},"3.8.1","Prepare Additional Roadway Profile and Utility Graphic Geologic Display"]
[{"$nulls":3},"3.8.2","Prepare Bridge Engineering Geology Drawing (1 sheet)"]
[{"$nulls":3},"3.8.3","Apply Geotechnical Report Data to Design and Plans"]
[{"$nulls":3},"3.8.4","Assist with Cost Estimates for Earthwork and Structures"]
[{"$nulls":3},"3.8.5","Conduct Final plan review "]
[{"$nulls":3},"3.8.6","Review of special provisions"]
[{"$nulls":3},"3.8.7","Team Meetings"]
[{"$nulls":3},"3.8.8","Quality Assurance"]
[]
[{"$nulls":5},"Subtotal"]
[null,null,"3.9 Structural"]
[{"$nulls":3},"3.9.1","159th Street Bridges"]
[{"$nulls":3},"3.9.1.1",null,"Prepare common General Notes sheet for both bridges."]
[{"$nulls":3},"3.9.1.2",null,"Create common quantity summary for all bridge pay items."]
[{"$nulls":3},"3.9.1.3",null,"Refine and complete Contour Map and Construction Layout drawings initiated in the field check phase."]
[{"$nulls":3},"3.9.1.4",null,"Create one Engineering Geology sheet for each bridge."]
[{"$nulls":3},"3.9.1.5",null,"Include design by Bridge Architect to refine and expand on aesthetic features for bridge piers and pedestrian treatments."]
[{"$nulls":3},"3.9.1.6",null,"Complete design calculations for abutments and wingwalls."]
[{"$nulls":3},"3.9.1.7",null,"Complete design of pier columns and capbeams and perform lateral earth interaction analysis for drilled shafts."]
[{"$nulls":3},"3.9.1.8",null,"Create final plans for abutments and wingwalls."]
[{"$nulls":3},"3.9.1.9",null,"Create final plans for center piers and crash protection walls."]
[{"$nulls":3},"3.9.1.10",null,"Prepare design and details for elastomeric bearing devices."]
[{"$nulls":3},"3.9.1.11",null,"Design framing scheme for bridge girders and diaphragms and prepare details for framing plans."]
[{"$nulls":3},"3.9.1.12",null,"Design bridge girders, splices, diaphragms and attachments."]
[{"$nulls":3},"3.9.1.13",null,"Develop details for girders, splices, and diaphragms."]
[{"$nulls":3},"3.9.1.14",null,"Design concrete deck slab components:  deck, traffic barriers, sidewalks, raised median, and expansion joints."]
[{"$nulls":3},"3.9.1.15",null,"Prepare slab plans, deck sections, and concrete placing details."]
[{"$nulls":3},"3.9.1.16",null,"Create details for traffic barriers, sidewalks, raised medians, and attachments."]
[{"$nulls":3},"3.9.1.17",null,"Design pedestrian handrail configuration and prepare details for rail, fabrication requirements, and attachments."]
[{"$nulls":3},"3.9.1.18",null,"Create details for strip seal expansion joints at each abutment."]
[{"$nulls":3},"3.9.1.19",null,"Provide accommodation for electrical conduit and support blisters for roadway light standards mounted on bridges."]
[{"$nulls":3},"3.9.1.20",null,"Allow access on bridge for carrying minor utility conduits."]
[{"$nulls":3},"3.9.1.21",null,"Provide tabular summary of pavement elevations and dead load girder deflections at span tenth points."]
[{"$nulls":3},"3.9.1.22",null,"Provide tabular summary of all reinforcing steel."]
[{"$nulls":3},"3.9.1.23",null,"Perform calculations for estimated quantities for all pay items."]
[{"$nulls":3},"3.9.1.24",null,"Adapt KDOT standard drawings for site specific applications."]
[{"$nulls":3},"3.9.1.25",null,"Assist with project construction sequence strategies including removal of existing four span bridge over US 69."]
[{"$nulls":3},"3.9.1.26",null,"Prepare project special provisions for unique structural items not addressed by KDOT standard specifications."]
[{"$nulls":3},"3.9.1.27",null,"Estimate probable construction costs based on final quantities."]
[{"$nulls":3},"3.9.1.28",null,"Prepare for and attend design meetings with City and KDOT."]
[]
[{"$nulls":3},"3.9.2","Retaining Walls"]
[{"$nulls":3},"3.9.2.1",null,"Coordinate with geotechnical subconsultant to evaluate project impacts for various retaining wall solutions."]
[{"$nulls":3},"3.9.2.2",null,"Identify and recommend solutions for construction conflicts between retaining wall components and drainage structures, buried utilities, and foundations for bridges, noise walls and signs."]
[{"$nulls":3},"3.9.2.3",null,"Research design and construction solutions to unusual applications directly with MSE wall manufacturers during the design phase."]
[{"$nulls":3},"3.9.2.4",null,"Include design by Bridge Architect to refine and expand on aesthetic features for retaining wall faces, copings, handrails, etc."]
[{"$nulls":3},"3.9.2.5",null,"Develop final Plan & Profile details for each retaining wall to illustrate horizontal and vertical geometry, including top of wall, existing ground, finished ground, and minimum embedment.  Each P&P sheet will cover up to a maximum of 300 feet of wall length."]
[{"$nulls":3},"3.9.2.6",null,"Develop typical section details for each individual retaining wall - assume one sheet per wall."]
[{"$nulls":3},"3.9.2.7",null,"Prepare general notes for the entire group of retaining walls.  Define general requirements for the project and specific design and construction requirements unique to individual wall locations."]
[{"$nulls":3},"3.9.2.8",null,"Compile summary of retaining wall design parameters from geology reports and tabulate in comprehensive summary table."]
[{"$nulls":3},"3.9.2.9",null,"Develop special details as needed for site specific conflicts with underground structures and utilities."]
[{"$nulls":3},"3.9.2.10",null,"Prepare details for special coping and retaining wall interface applications at bridge abutments and wall terminations."]
[{"$nulls":3},"3.9.2.11",null,"Develop details and notes for temporary retaining wall system needed for phased construction near each bridge abutment."]
[{"$nulls":3},"3.9.2.12",null,"Include details for two integral sidewalk retaining walls."]
[{"$nulls":3},"3.9.2.13",null,"Create details for metal pedestrian railings and their attachment where required along tops of retaining walls."]
[{"$nulls":3},"3.9.2.14",null,"Perform calculations for all estimated retaining wall quantities and tabulate in comprehensive summary of quantities."]
[{"$nulls":3},"3.9.2.15",null,"Prepare intermediate and final construction cost estimates."]
[{"$nulls":3},"3.9.2.16",null,"Modify existing special provisions to accommodate retaining wall applications unique to this project."]
[]
[{"$nulls":3},"3.9.3","Drainage Structures and Roadside Safety Structures"]
[{"$nulls":3},"3.9.3.1",null,"Finalize structure geometrics for barrel lengths, headwall configurations, and culvert profiles."]
[{"$nulls":3},"3.9.3.2",null,"Order available KDOT standard drawings for conventional R.C. box culverts and determine scope of additional structural details."]
[{"$nulls":3},"3.9.3.3",null,"Prepare auxiliary details to accommodate special conditions for culverts - bends, pipe junctions, entrance treatments."]
[{"$nulls":3},"3.9.3.4",null,"Coordinate with hydraulic design engineer to finalize site plan, scour and erosion protection, and preparation of Hydraulic Assessment Checklists."]
[{"$nulls":3},"3.9.3.5",null,"Finalize structural details for RCB barrels and headwalls."]
[{"$nulls":3},"3.9.3.6",null,"Prepare metal handrail details for top of headwalls."]
[{"$nulls":3},"3.9.3.7",null,"Prepare quantity calculations for RCB contract pay items and estimate of construction costs."]
[{"$nulls":3},"3.9.3.8",null,"Develop details for concrete bridge approach pavement for the 159th Street bridges.  Accommodate unique interchange joint patterning and construction phasing requirements."]
[{"$nulls":3},"3.9.3.9",null,"Create details for vertical transitions of concrete safety barriers and unique details for non-standard CSB applications."]
[{"$nulls":3},"3.9.3.10",null,"Perform design for non-standard storm inlets and manholes."]
[{"$nulls":3},"3.9.3.11",null,"Prepare details for concrete pads and backup support walls for impact attenuators."]
[{"$nulls":3},"3.9.3.12",null,"Detail attachments for minor sign supports."]
[]
[{"$nulls":3},"3.9.4","Quality Assurance"]
[]
[{"$nulls":5},"Subtotal"]
[null,null,"3.10 Public Involvement"]
[{"$nulls":3},"3.10.1","Prep for and attend two open house public meetings. Prep includes drafting display information, handouts, comment forms, sign in sheets, securing location and set up for the meetings. One 11x17 color newsletter handout will be created for each meeting and sent out to area residents and business owners along the corridor.  Up to 2 display boards will be developed along with aerial map of project area."]
[{"$nulls":3},"3.10.2","Comment Log Development--manage and track all incoming comments and arrange systematically for ease of tracking and responses.  Organize in a electronic file as well as a hard copy.  "]
[{"$nulls":3},"3.10.3","Quality Assurance"]
[]
[{"$nulls":5},"Subtotal"]
[null,null,"3.11 Utility Coordination"]
[{"$nulls":3},"3.11.1","Distribute Updated plans","Distribute Updated plans"]
[{"$nulls":3},"3.11.2","Meetings to review any final conflicts","Meetings to review any final conflicts"]
[{"$nulls":3},"3.11.3","Request final relocation plans from utilities and update electronic files (Assume 10 occurrences)","Request final relocation plans from utilities and update electronic files (Assume 10 occurances)"]
[{"$nulls":3},"3.11.4","Send copies to utilities and set up meeting to review any final conflicts","Send copies to utilities and set up meeting to review any final conflicts"]
[{"$nulls":3},"3.11.5","Utility Review Coordination Meeting","Utility Review Coordination Meeting"]
[{"$nulls":3},"3.11.6","Review final utility agreements for KDOT Right of Way","Review final utility agreements for KDOT Right of Way"]
[{"$nulls":3},"3.11.7","Update “List of Utilities and Status” (1304) form","Finalize “List of Utilities and Status” (1304) form"]
[{"$nulls":3},"3.11.8","Meetings to review status of utility relocation design (Assume 2 meetings)","Meetings to review status of utility relocation design (Assume 2 meetings)"]
[]
[{"$nulls":3},"3.11.9","Utility Relocation Stage - 159th Street Corridor"]
[{"$nulls":3},"3.11.9.1",null,"Verify required permitting has been completed and approved"]
[{"$nulls":3},"3.11.9.2",null,"Coordinate Staking effort"]
[{"$nulls":3},"3.11.9.3",null,"Prepare survey plan and stake necessary features for utility relocations - Actual TBD  Preliminary assumption 2 per person per occurrence @ 1 1/2 days per occurrence 10 occurrences"]
[{"$nulls":3},"3.11.9.4",null,"Update “List of Utilities and Status” (1304) form"]
[]
[{"$nulls":3},"3.11.10","Utility Relocation Stage - US 69 Corridor"]
[{"$nulls":3},"3.11.10.1",null,"Verify required permitting has been completed and approved"]
[{"$nulls":3},"3.11.10.2",null,"Coordinate Staking effort"]
[{"$nulls":3},"3.11.10.3",null,"Prepare survey plan and stake necessary features for utility relocations - Actual TBD  Preliminary assumption 2 per person per occurrence @ 1 1/2 days per occurrence 2 occurrences"]
[{"$nulls":3},"3.11.10.4",null,"Update “List of Utilities and Status” (1304) form"]
[]
[{"$nulls":3},"3.11.11","Quality Assurance"]
[]
[{"$nulls":5},"Subtotal"]
[null,null,"3.12 Administration/Meetings"]
[{"$nulls":3},"3.12.1","Attend OP/KDOT coordination meeting."]
[{"$nulls":3},"3.12.2","Attend City meetings. (Assumes 2 meetings with meeting minutes prepared and distributed)","Attend City meetings. (Assumes 2 meetings with meeting minutes prepared and distributed)"]
[{"$nulls":3},"3.12.3","Attend OP/KDOT Metro coordination meeting.","Attend OP/KDOT Metro coordination meeting."]
[{"$nulls":3},"3.12.4","Contingency Utility Coordination Meetings (Assumes delay between FC and Final Plan Development)","Contingency Utility Coordination Meetings (Assumes delay between FC and Final Plan Development)"]
[{"$nulls":3},"3.12.5","Develop and maintain a MS Project design schedule.  Schedule to include: Surveys complete, Data collection complete, Preliminary plans complete, Preliminary Plans to utilities, Field check plans complete, Legal descriptions to City, First public meeting, Agency permits submitted, Final Plans complete, and Project ready to bid.  Submit copy to City and provide updates at scheduled progress meetings if necessary."]
[{"$nulls":3},"3.12.6","Preparation and attendance at periodic review meetings with the City and KDOT (Assume 4)"]
[{"$nulls":3},"3.12.7","Project Coordination with the City and others (Assume monthly meetings or conference calls)"]
[{"$nulls":3},"3.12.8","Appear at eminent domain or appraiser's hearings necessary to acquire easements and right-of-way for the project."]
[{"$nulls":3},"3.12.9","Prepare monthly progress reports"]
[{"$nulls":3},"3.12.10","Submit Traffic Engineering Plans"]
[{"$nulls":3},"3.12.11","Prepare for and attend Traffic Engineering meeting"]
[{"$nulls":3},"3.12.12","Submit Final Plans"]
[{"$nulls":3},"3.12.13","Prepare for and attend Final Plan review meeting"]
[{"$nulls":3},"3.12.14","Submit Final/Final Plans and Bid Documents"]
[]
[{"$nulls":5},"Subtotal"]
[null,"Phase 3 - Final Plans"]
[null,"Phase 3 Fee Summary"]
[{"$nulls":5},"Labor:",null,null,"Project Manager @ $58/hour",0]
[{"$nulls":8},"Sr. Engineer @ $41/hour",0]
[{"$nulls":8},"Engineer @ $33/hour",0]
[{"$nulls":8},"Technician @ $28.5/hour",0]
[{"$nulls":8},"Direct Payroll:",0]
[]
[{"$nulls":8},"Multiplier (3.0)",0]
[{"$nulls":5},"Labor Division",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
[{"$nulls":5},"Expenses:",null,null,"Printing/Plotting ="]
[{"$nulls":8},"Travel ="]
[{"$nulls":8},"Misc. ="]
[{"$nulls":8},"Total Expense"]
[]
[{"$nulls":5},"Subconsultants:",null,null,"Vacuum Excavation ="]
[{"$nulls":8},"Donoho  Appraisals Inc. ="]
[{"$nulls":8},"Terracon (Design Services) ="]
[null,"1.","Vacuum excavation assumes 10 hours at $150/hour and includes backfill and street repair as required.",{"$nulls":5},"EcoSystems ="]
[null,"2.","Two retaining wall subconsultants will be retained for the design support.",{"$nulls":5},"Retaining Wall Design Support ="]
[{"$nulls":8},"Total Subconsultant Expense"]
[]
[{"$nulls":8},"Total Fee ="]

{"sheet":"SA No. 4 Bid & Constr","index":2,"n_rows":187,"n_cols":11,"rows_kept":187,"merged":[[1,12,1,16],[1,18,1,22],[1,24,1,28],[1,30,1,34],[1,36,1,40],[1,42,1,46],[1,48,1,52],[1,54,1,58],[5,4,5,5],[6,4,6,5],[7,4,7,5],[8,4,8,5],[9,4,9,5],[10,4,10,5],[11,4,11,5],[12,4,12,5],[13,4,13,5],[14,4,14,5],[15,4,15,5],[16,4,16,5],[17,4,17,5],[83,4,83,5],[115,4,115,5],[116,4,116,5],[117,4,117,5],[118,4,118,5],[119,4,119,5],[120,4,120,5],[121,4,121,5],[122,4,122,5],[123,4,123,5],[124,4,124,5],[125,4,125,5],[126,4,126,5],[127,4,127,5],[128,4,128,5],[129,4,129,5],[130,4,130,5],[131,4,131,5],[149,4,149,5],[150,4,150,5],[151,4,151,5],[152,4,152,5],[153,4,153,5],[154,4,154,5],[155,4,155,5],[156,4,156,5],[157,4,157,5]],"flags":["formulas_cached_only"]}
[]
[]
[{"$nulls":5},"                Item of Work","Project Manager","Senior Engineer/ Planner","Engineer/ Planner","Technician","Total"]
[null,"Phase 4 - Bidding Phase"]
[]
[{"$nulls":3},"4.1.1","Prepare and provide plans and specifications in either or both hard copy and electronic (.pdf) formats to bidders at cost to recover expenses of duplication and handling."]
[{"$nulls":3},"4.1.2","Supply plans and specifications in both hard copy and electronic (.pdf) formats to Plan Rooms.  Assumes up to 5 sets of full size plans will be provided at no cost."]
[{"$nulls":3},"4.1.3","Maintain bid holders list and attend bid letting."]
[{"$nulls":3},"4.1.4","Consult with and advise the City as to the acceptability of substitute materials and equipment when substitution prior to the award of the contract is allowed in the bidding documents.  Does not include any significant changes to plans or specification such as a concrete alternate pavement section.  Any significant changes shall be negotiated as additional services in a supplemental agreement."]
[{"$nulls":3},"4.1.5","Consult with and advise the City as to the acceptability of subcontractors and others proposed to do work by the general contractor."]
[{"$nulls":3},"4.1.6","Prepare written addenda to the bidding documents as required and/or requested.  Assumes only minor plan or specification revisions.  Any significant changes shall be negotiated as additional services in a separate supplemental agreement."]
[{"$nulls":3},"4.1.7","Assist the City in analyzing bids and making recommendation for award of the construction contract."]
[{"$nulls":3},"4.1.8","Prepare report for City identifying why bids exceeded estimate (if applicable)."]
[{"$nulls":3},"4.1.9","Prepare a bid tabulation in printed and MS Excel format."]
[{"$nulls":3},"4.1.10","Arrange for, attend, and prepare meeting minutes for a pre-bid conference."]
[{"$nulls":3},"4.1.11","Provide up to 5 sets of half size (11”x17”) color utility relocation plans to the Contractor."]
[{"$nulls":3},"4.1.12","Provide up to 10 sets of full (6 sets) and half size (11”x17”) (4 sets) final bid plans and contract documents to the Contractor."]
[{"$nulls":3},"4.1.13","Provide CAD drawings, TIFF images, and shape files to the City"]
[]
[null,"Phase 4 - Bidding Phase"]
[null,"Phase 4 Fee Summary"]
[{"$nulls":5},"Labor:"]
[{"$nulls":8},"Project Manager @ $58/hour",0]
[{"$nulls":8},"Sr. Engineer @ $41/hour",0]
[{"$nulls":8},"Engineer @ $33/hour",0]
[{"$nulls":8},"Technician @ $28.5/hour",0]
[{"$nulls":8},"Direct Payroll:",0]
[]
[{"$nulls":8},"Multiplier (3.0)",0]
[]
[{"$nulls":5},"Labor Division",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Phase 5 - Construction Services Phase"]
[{"$nulls":3},"2.1 Data Collection"]
[{"$nulls":3},"2.1.1",null,"Perform GPS and Total Station surveys within the design corridor of:"]
[{"$nulls":5},"     g. Flag locations of up to 10 soil borings and return to survey actual locations "]
[{"$nulls":5},"     h. stake centerline of 159th Street for use by utilities doing relocations"]
[{"$nulls":5},"     i. flag proposed ROW and Esmts (assume 15) for use by appraisers and owners"]
[{"$nulls":5},"     j. miscellaneous pick-up surveys"]
[{"$nulls":3},"2.1.2",null,"Prepare COGO file calculating location of proposed right of way and construction easements"]
[{"$nulls":3},"2.1.3",null,"Prepare and check legal descriptions and tract map exhibits for right of way acquisition process"]
[{"$nulls":3},"2.1.4",null,"Assist with preparation of Survey Reference Sheet and review plan sheets for completeness and accuracy"]
[{"$nulls":3},"2.1.5",null,"Prepare 3 sets of KDOT field books"]
[]
[]
[]
[null,null,"2.1 Traffic Simulation "]
[{"$nulls":3},"2.1.1",null,"Develop/Run Existing Conditions Simulation Model "]
[{"$nulls":3},"2.1.2",null,"Develop/Run Future Build & No-build Conditions Simulation Model "]
[{"$nulls":3},"2.1.3",null,"Model Results - Operational Analysis"]
[{"$nulls":3},"2.1.4",null,"Revise Operational Analysis"]
[{"$nulls":3},"2.1.5",null,"Prepare Traffic Memorandum"]
[]
[null,null,"2.2 Interchange Geometrics "]
[{"$nulls":3},"2.2.1",null,"Refine Preliminary Horizontal/Vertical Geometrics"]
[{"$nulls":3},"2.2.2",null,"Revise Preliminary Horizontal/Vertical Geometrics"]
[{"$nulls":3},"2.2.3",null,"Develop Preliminary Cross Sections"]
[{"$nulls":3},"2.2.4",null,"Determine Preliminary ROW requirements"]
[]
[null,null,"2.3 Break-in-Access Request "]
[{"$nulls":3},"2.3.1",null,"Develop Break-in-Access Request"]
[]
[null,null,"2.4 Cost Estimate "]
[{"$nulls":3},"2.4.1",null,"Determine preliminary project cost estimate "]
[]
[null,null,"2.5 Meetings"]
[{"$nulls":3},"2.5.1",null,"Review Agency Meetings  (attend and prepare for 2 assumed)"]
[{"$nulls":3},"2.5.2",null,"Stakeholder Meetings  (attend and prepare for 1 assumed)"]
[{"$nulls":3},"2.5.3",null,"Council Presentations  (attend and prepare for 1 assumed)"]
[]
[null,null,"5.1  Data Collection"]
[{"$nulls":3},"5.1.1","Property Corner Restoration",null,0,0,0,0,0]
[{"$nulls":3},"5.1.1.1",null,"Find, flag and describe all property corners along 159th Street which may be impacted by construction (assume 30)."]
[{"$nulls":3},"5.1.1.2",null,"After construction is complete, determine condition of each property corner. Replace those which were damaged or destroyed at the location of the original monument."]
[{"$nulls":3},"5.1.1.3",null,"Update the Monumentation Map showing all original, undisturbed property corners and those reset due to construction activities. Submit final copies to the City and County for inclusion in their project files."]
[{"$nulls":3},"5.1.2","Quality Assurance"]
[]
[{"$nulls":5},"Subtotal"]
[null,null,"5.2  Traffic"]
[{"$nulls":5},"Subtotal"]
[null,null,"5.3  Roadway"]
[{"$nulls":3},"5.3.1","Provide assistance with plan interpretation"]
[{"$nulls":3},"5.3.2","Create and produce revised plans"]
[{"$nulls":3},"5.3.3","Review sprinkler system design for up to 6 systems"]
[{"$nulls":3},"5.3.4","Prepare one set of final record drawings which reflect all change orders, minor design changes, changes made in the field by City representatives and are clearly marked on the construction plan set."]
[]
[{"$nulls":5},"Subtotal"]
[null,null,"5.4  Drainage"]
[{"$nulls":3},"5.4.1","Perform storm drainage shop drawing review and coordination"]
[{"$nulls":3},"5.4.2","Storm Drainage structures and pipe certifications"]
[{"$nulls":3},"5.4.3","Bridge coordination on RCB extension"]
[{"$nulls":3},"5.4.4","Review subsurface drains behind retaining walls"]
[{"$nulls":3},"5.4.5","Evaluate misc. drainage items (underdrains, etc.)"]
[{"$nulls":3},"5.4.6","Provide construction consultation"]
[]
[{"$nulls":5},"Subtotal"]
[null,null,"5.5  Sanitary"]
[{"$nulls":3},"5.5.1","Sanitary Sewer - Shop drawing review and coordination"]
[{"$nulls":3},"5.5.2","Provide minor plan and quantity revisions due to construction changes"]
[{"$nulls":3},"5.5.3","Sanitary Sewer Inspection (Assumes 1 inspector for 120 days)"]
[]
[{"$nulls":5},"Subtotal"]
[null,null,"5.6  Erosion Control"]
[{"$nulls":5},"Subtotal"]
[null,null,"5.7 Environmental"]
[{"$nulls":5},"Subtotal"]
[null,null,"5.8 Geotechnical"]
[{"$nulls":3},"5.8.1","Bridge Foundation Verification Assistance"]
[{"$nulls":3},"5.8.2","Retaining Wall Foundation Verification Assistance"]
[{"$nulls":3},"5.8.3","Geotechnical Review of RFI's"]
[{"$nulls":3},"5.8.4","Geotechnical Review of Contractor Design Submittals"]
[{"$nulls":3},"5.8.5","Roadway Cut and Subgrade Verification Assistance"]
[{"$nulls":3},"5.8.6","Meetings"]
[]
[{"$nulls":5},"Subtotal"]
[null,null,"5.9 Structural"]
[{"$nulls":3},"5.9.1","Review and recommend approval of shop drawings for bridge superstructure components:  girders, diaphragms, splices and miscellaneous attachments."]
[{"$nulls":3},"5.9.2","Review manufacturer's shop drawings for bridge bearing devices."]
[{"$nulls":3},"5.9.3","Review fabricator's shop drawings for metal handrails on bridges."]
[{"$nulls":3},"5.9.4","Review contractor's design and details for bridge formwork for deck slab, including evaluation of overhang brackets and construction loads."]
[{"$nulls":3},"5.9.5","Review fabricator's shop drawings for bridge deck expansion joint assemblies."]
[{"$nulls":3},"5.9.6","Review catalog cuts for miscellaneous bridge attachments including drain systems, electrical conduit, lighting, and utilities."]
[{"$nulls":3},"5.9.7","Review contractor's proposed method for removal of the existing four span bridge over US 69."]
[{"$nulls":3},"5.9.8","Review retaining wall manufacturer's design calculations for proprietary system for conformance to project design parameters."]
[{"$nulls":3},"5.9.9","Review and recommend approval of retaining wall manufacturer's detailed construction drawings for segmental wall systems."]
[{"$nulls":3},"5.9.10","Review fabricator's shop drawings for metal handrails attached to top, or positioned immediately behind retaining walls."]
[{"$nulls":3},"5.9.11","Review contractor's details for temporary retaining walls and excavation shoring systems."]
[{"$nulls":3},"5.9.12","Assist with retaining wall modifications required when unexpected geologic conditions are encountered or adjustments become necessary to avoid underground obstructions."]
[{"$nulls":3},"5.9.13","Allow for approximately five field visits to observe sample panels, answer design questions, and help solve problems."]
[{"$nulls":3},"5.9.14","Produce revised plan sheets or new plan sheets for owner approved and directed design changes."]
[{"$nulls":3},"5.9.15","Perform administrative tasks, including document management, mailings, meeting minutes, and phone records for all construction services."]
[{"$nulls":3},"5.9.16","Provide general consultation services for bridges and retaining walls. Be available to construction engineering personnel to interpret or clarify bridge and retaining wall design details, specifications, or quantity estimates."]
[{"$nulls":3},"5.9.17","Bridge Inspection Form - SINA"]
[]
[{"$nulls":5},"Subtotal"]
[null,null,"5.10 Public Involvement"]
[{"$nulls":5},"Subtotal"]
[null,null,"5.11 Utility Coordination"]
[{"$nulls":3},"5.11.1","159th Street Corridor"]
[{"$nulls":3},"5.11.1.1",null,"Update “List of Utilities and Status” (1304) form"]
[{"$nulls":3},"5.11.1.2",null,"Review updated utility drawings"]
[{"$nulls":3},"5.11.1.3",null,"Coordination with project contractor to review utility information"]
[]
[{"$nulls":3},"5.11.2","US 69 Corridor"]
[{"$nulls":3},"5.11.2.1",null,"Update “List of Utilities and Status” (1304) form"]
[{"$nulls":3},"5.11.2.2",null,"Review updated utility drawings"]
[{"$nulls":3},"5.11.2.3",null,"Coordination with contractor to review utility information"]
[]
[{"$nulls":5},"Subtotal"]
[null,null,"5.12 Administration/Meetings"]
[{"$nulls":3},"5.12.1","Attend preconstruction meeting"]
[{"$nulls":3},"5.12.2","Attend weekly progress meetings as directed by the City. Assumes attending 50% of meetings at 2 hours each for 24 months during construction."]
[{"$nulls":3},"5.12.3","Attend pre-design meetings. (Assumes 4 people for 2 hours with meeting minutes prepared and distributed)"]
[{"$nulls":3},"5.12.4","Assist with review of utility agreements (Assume 10 @ 4 hours each)"]
[{"$nulls":3},"5.12.5","Participate in final walk-through inspection"]
[{"$nulls":3},"5.12.6","Attend OP/KDOT Metro coordination meeting."]
[{"$nulls":3},"5.12.7","Attend utility review meetings with City and KDOT (Assume 4)"]
[{"$nulls":3},"5.12.8","Prepare monthly progress reports"]
[{"$nulls":3},"5.12.9","Stakeholder Meetings (Assume 4)"]
[]
[{"$nulls":5},"Subtotal"]
[null,"Phase 5 - Construction Phase"]
[null,"Phase 4 and 5 Fee Summary"]
[{"$nulls":5},"Phase 4:",null,null,"Phase 4 Subtotal =",0]
[]
[{"$nulls":5},"Phase 5 Labor:",null,null,"Project Manager @ $58/hour",0]
[{"$nulls":8},"Sr. Engineer @ $41/hour",0]
[{"$nulls":8},"Engineer @ $33/hour",0]
[{"$nulls":8},"Technician @ $28.5/hour",0]
[{"$nulls":8},"Direct Payroll:",0]
[]
[{"$nulls":8},"Multiplier (3.0)",0]
[]
[]
[{"$nulls":5},"Field Inspection and Construction Observation:",null,null,"To Be Negotiated at beginning",0]
[{"$nulls":8},"of Construction Phase"]
[]
[{"$nulls":5},"Labor Division",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[{"$nulls":5},"Expenses:",null,null,"Printing/Plotting ="]
[{"$nulls":8},"Travel ="]
[{"$nulls":8},"Misc. ="]
[{"$nulls":8},"Total Expense"]
[]
[]
[{"$nulls":5},"Subconsultants:",null,null,"Eco Systems"]
[{"$nulls":8},"Total Subconsultant Expense"]
[]
[{"$nulls":8},"Total Fee ="]