{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Instructions","Header Info","Bridge Header Info","Templates","Summary","Owners Manual","Base"],"not_rendered":{"charts":0,"images":161,"macros":1,"external_links":0,"defined_names":5,"comments":1,"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":"Instructions","index":0,"n_rows":37,"n_cols":1,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
["Schedule Initiation form "]
["Updated November 5, 2014"]
["Note:  Please make sure you are using the most updated form on the website as the templates will be subject to revisions."]
[]
["How to use Schedule Initiation Form:"]
["1.  Complete the top portion of the Header Info tab.  The \"For CO Office Use Only\" section should be left blank. "]
[]
["The following must be included:"]
["          - PUMA Bundle number"]
["          - PUMA Element number"]
["          - State Project number"]
["          - Project Description"]
["          - SWIFT Project ID (also known as the Job Number)"]
["          - Letting Date"]
["          - District"]
["          - Project Manager"]
["          - Project Manager Contact Information (phone/e-mail)"]
[]
["2.  Complete the Bridge Header Info tab only if there is work to be done on a bridge by the MnDOT Bridge Office. \n     If the type of work package is unknown, insert the New Bridge work package."]
[]
["3.  On the Templates tab, select the template that best fits your project.  The spreadsheet will check the boxes of the deliverables/work packages that are in that template."]
[]
["4.  You may add any deliverable/work packages on the Templates tab by checking the box next to the name of the deliverable/work package."]
["     You may remove any deliverable/work packages from the Templates tab by unchecking the box next to the name of the deliverable/work package."]
[]
["5.  When finished adding/removing work packages, you may click \"Create Summary\" and go to the Summary tab to view what items will be included (optional)."]
[]
["6.  Upon completing the form, submit by performing the following:"]
["          - Save the Excel file under the following naming convention:  \"SP ____-___ Schedule Initiation Form\""]
["          - E-mail the form in .xls format to your SSC representative (Metro - Wendy Kufner, North -  Michelle Rognerud,  South - Tim Zamzow)"]
[]
[]
["Note to the SSC:"]
["When adding and removing work packages the best practice is to add and tie each work package one at a time and then dissolve unneeded activities and work packages.  "]
[]
[]
["`"]

{"sheet":"Header Info","index":1,"n_rows":58,"n_cols":24,"rows_kept":58,"cut":false,"hidden":false,"merged":[[53,0,53,1],[0,0,0,1],[41,0,41,1],[46,0,46,1],[29,0,30,0],[29,1,30,1]]}
["Project Header Information"]
["Person filling out these forms :"]
["Date filled out:"]
[]
["PUMA Bundle:",null,null,null,null,null,"District ","Route Type","Work Responsibility ","Primary Work Type ","Responsible Government Unit & Letting Organization"," Letting Process Type","Project Status ","Completion Type ","Machine Control ","Machine Control Reason","District","SSC Lead","Schedulers","Other ","Program","ATP District ","YES","Delivery Type"]
["PUMA Element:",null,null,null,null,null,"D1","CR, County Road","MnDOT","Bridge Rehabilitation (BRRH)","MnDOT","Process A (A)","Planned","MnDOT Let (MnL)","N/A","Consultant Design ","D1","Michelle Rognerud","Alex Schulz",null,"Agreements, Municipal (AM)","01","NO","Design Build (DB)"]
["PUMA Prime SP:",null,null,null,null,null,"D2","CSAH, County State Aid Highway","Contractors","Preservation / Maintenance (PRMN)","County ","Agreement Letting (AGR)","Programmed","Local Let (LcL)","Use (Machine control will be used)","Inadequate Design Information ","D2","Michelle Rognerud","Steve Voight",null,"Agreements, Rail (AR)","02","TBD","Design Bid Build (DBB)"]
["PUMA SP:",null,null,null,null,null,"D3","FH, Forest Highway","County","Traffic Control Devices (TRCD)","City ","Process B (B)","Let","Right-of-Way Only (ROW)","Don't Use (Machine control will not be used)","Local Project ","D3","Michelle Rognerud","Darren Jensen",null,"Agreements, Utility (AU)","03","NA","Contract Manager General Contractor (CMGC)"]
["Work location and description of work. Write a short description of the project location, city names, etc. and type of construction work.",null,null,null,null,null,"D4","I, Interstate","City","Appurtenances (APPU)","Undetermined","Complex B (B+)","Inactive","Agreements Only (AgO)",null,"Minimal Grading","D4","Tim Zamzow","Dan Swanson, Darren Jensen ",null,"Bridge Improvement and Repair (BI)","04",null,"Indefinite Delivery Indefinite Quantity (IDIQ)"]
["SWIFT Project ID (formerly Job number or T-number, if known) :",null,null,null,null,null,"DM","IRR, Indian Reservation Road","Undetermined","Bridge Replace or Construction (BRPC)",null,"Design Build (DB)","Dropped","Other (OTR)",null,"No Base Mapping ","DM","Wendy Kufner","Ross Jentink, Kyajes Shakya, Robert Hartman, Tom Hilla & Curt Sohn","Jerome Adams, Tim Clyne, Rick Dalton, Mike Gerbensky, Brigid Gombold, Judi Holloway, John Isackson, Beth Neuwndorf, Dale Nikkola, Scott Pederson, Mike J. Reynolds, DaveTorfin, Josie Teyse & Jim Nelson","Bridge Replacement (BR)","06",null,"Undetermined (UND)"]
["Let Date (non-funded projects are listed with a 2049 letting):",null,null,null,null,null,"D6","MSAS, Municipal State Aid Street","Consultant","Grade and Surface (GRSU)",null,"Full Federal Oversight (FFO)","Done","Not Applicable (NA)",null,"Not Applicable to Project ","D6","Tim Zamzow","Dan Swanson & Ryan Johnson","Kjersti Anderson, Richard Augustine, Jake Gasper, Chad Hanson, Jai Kelsay, Mike Kempinger, Kyle Lake, Heather Lukes, David Tsang, Tony Wagner","Bike Trail (BT)","07",null,"Not Applicable (NA)"]
["District:",null,null,null,null,null,"D7 ","MS, Municipal Street","Not Applicable","Grade, Surface, and Bridge (GSBR)",null,"Let by other (LBO)","Test","To Be Determined (TBD)",null,"Other ","D7 ","Tim Zamzow","Dan Swanson","Chris Bower, Glen Coudron & Robert Jones","Consultant Agreements (CA)","08",null,"To Be Determined (TBD)"]
["Project Manager:",null,null,null,null,null,"D8","TH, Trunk Highway","To Be Determined","Pavement Resurfacing and Rehabilitation (PVTR)",null,"No Letting (None)","NA",null,null,"Poor GPS Control ","D8","Tim Zamzow","Dan Swanson",null,"Detour Agreement (DA)","M"]
["Project Manager Contact Information (phone/e-mail):",null,null,null,null,null,null,"TR, Township Road",null,"Planning (PLAN)",null,"Not Applicable (NA)","TBD",null,null,null,null,null,null,null,"Enhancement (EN)","TBD"]
["Route Type:",null,null,null,null,null,null,"CP, City Project",null,"Intelligent Transportation Systems (ITS)",null,"Contract Manager General Contractor (CMGC)",null,null,null,null,null,null,null,null,"Indian Reservation Roads (IR)","NA"]
["Route Number:",null,null,null,null,null,null,"CMAQ, Congestion Mitigation & Air Quality",null,"Transit (TRAN)",null,"To Be Determined (TBD)",null,null,null,null,null,null,null,null,"Miscellaneous Agreements (MA)"]
["ATP District:",null,null,null,null,null,null,"DA, Disability Act",null,"Right of Way (ROW)",null,null,null,null,null,null,null,null,null,null,"Major Construction (MC)"]
["Work Responsibility:",null,null,null,null,null,null,"EN, Enhancement",null,"Not Applicable (NA)",null,null,null,null,null,null,null,null,null,null,"Noise Walls (NO)"]
["Does the project have Federal Funding :",null,null,null,null,null,null,"ITS, Intelligent Transportation Systems",null,"To Be Determined (TBD)",null,null,null,null,null,null,null,null,null,null,"Planning (PL)"]
["What is the Primary Work Type for the project:",null,null,null,null,null,null,"PBP/T, Pedestrian or Bike Path/Trail",null,null,null,null,null,null,null,null,null,null,null,null,"Preventative Maintenance (PM)"]
["Program:",null,null,null,null,null,null,"P, Planning",null,null,null,null,null,null,null,null,null,null,null,null,"Rest Area/Beautification (RB)"]
["Responsible Government Unit (RGU):",null,null,null,null,null,null,"RR, Railroad",null,null,null,null,null,null,null,null,null,null,null,null,"Reconstruction (RC)"]
["Letting Organization:",null,null,null,null,null,null,"SP, State Project (Non Roadway Association)",null,null,null,null,null,null,null,null,null,null,null,null,"Resurfacing (RS)"]
["County:",null,null,null,null,null,null,"TRANS, Transit",null,null,null,null,null,null,null,null,null,null,null,null,"Right of Way (RW)"]
["Ancestor SP: (the originally programmed SP from which this project evolved) (often the SP with the low SP number??)",null,null,null,null,null,null,"MN, MN",null,null,null,null,null,null,null,null,null,null,null,null,"Road Repair (RX)"]
["Program Category:",null,null,null,null,null,null,"US, US",null,null,null,null,null,null,null,null,null,null,null,null,"Supplemental Agreement and Cost Overrun (SA)"]
["Source of funding: (Examples: HPP, SetAside, Preservation, BARC, etc.):",null,null,null,null,null,null,"CMR, Commuter Rail",null,null,null,null,null,null,null,null,null,null,null,null,"Safety Improvements - no HSIP Funding (SC)"]
["Total Construction Cost Estimate: (This does not include R/W. It is the estimate that goes to OIM and includes all construction elements; bridge, grading & surfacing, signals, utilities, etc.):",null,null,null,null,null,null,"NA, Not Applicable",null,null,null,null,null,null,null,null,null,null,null,null,"Safety Improvements - HSIP Funding (SH)"]
["Grade & Surface Construction Cost Estimate. What is the estimated construction cost for the grading and surfacing portion of the project:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Safety Rail (SR)"]
["Process Letting Type: (Click here for process definitions)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reconditioning (RD)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Emergency Repair (ER)"]
["In what fiscal year is the funding anticipated or desired: (The fiscal year when the project is to be funded)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DR (DR)"]
["PLANS READY DATE: The Plans Ready date is a way to show a plan activity being completed early.  This date is placed as an imposed Late Finish date on the plan activity (Road, Signal, Landscape, Bridge, etc.). It should be based on when the District Management wants to get the plans ready if additional funds become available. An earlier letting date then might be possible. This target date for plan completion should only be used, or set, for higher priority projects identified by the District. The Project Manager must be careful about requesting this early date; it should be discussed with and approved by all Functional Groups that will be affected. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Jurisdictional Transfer (JT)"]
["Project Status:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Jump Start (JS)"]
["Project Completion Type:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ABC/RW (TR)"]
["Project Manager for Preliminary Design phase:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Miscellaneous Program (XX)"]
["Project Manager for Final Design phase:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"State Trail (ST)"]
["Business Liaison:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Preliminary Engineering (PE)"]
["Design Engineer:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Interstate Preservation (IP)"]
["Construction Resident Engineer:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bridge Preservation (BP)"]
["Length of project (in miles):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Not Applicable (NA)"]
["The Reference points are the location of the project beginning and ending points in relation to the mile posts. The GIS points are the true mileage points used for GIS mapping of the project. This information is on the TDA website at http://www.dot.state.mn.us/tda/reports/thlogpoint.html# . The Reference points are in the \"REF-POINT\" column, GIS points are listed in the \"ACCUM\" column. Interpolate between points as needed. See the Attribute Manual (Informational Attributes, Beginning & Ending Ref Points) for more info.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"To Be Determined (TBD)"]
["Reference Begin: Enter the begin reference point for the entire project length in the format xxx+yy.zzz"]
["Reference End: Enter the end reference point for the entire project length in the format xxx+yy.zzz"]
["GIS Begin: Enter the GIS begin point for the entire project length in the format xxx.yyy"]
["GIS End: Enter the GIS end point for the entire project length in the format xxx.yyy"]
["Project Segments: If you wish to divide the project up into segments, go to the \"Project Segments\" tab in this file and fill in the form there. Then continue filling in the remaining pages. "]
["Associated SP's (List them if they are known or put \"yes they will be needed\" or \"NA\".)"]
["Tied SP's (List them if they are known or put \"NA\")"]
["Will \"Machine Control\" be used during the construction of project:"]
["Machine Control: If you chose \"Don't Use\" in the row above, what is the reason:"]
["Header Notes or Comments:"]
["Activity Notes or Comments:"]
["FOR CO OFFICE USE ONLY"]
["ACCESS REQUIRED (LIST NAMES)"]
["SHARED SERVICE CENTER LEAD:     ",{"$f":"IF(B12=\"\",\"\",IF(VLOOKUP(B12,Q5:T13,2,FALSE)=\"\",\"\",VLOOKUP(B12,Q5:T13,2,FALSE)))","v":""}]
["SCHEDULER:     ",{"$f":"IF(B12=\"\",\"\",IF(VLOOKUP(B12,Q5:T13,3,FALSE)=\"\",\"\",VLOOKUP(B12,Q5:T13,3,FALSE)))","v":""}]
["OTHER:     ",{"$f":"IF(B12=\"\",\"\",IF(VLOOKUP(B12,Q5:T13,4,FALSE)=\"\",\"\",VLOOKUP(B12,Q5:T13,4,FALSE)))","v":""}]

{"sheet":"Bridge Header Info","index":2,"n_rows":109,"n_cols":11,"rows_kept":109,"cut":false,"hidden":false,"merged":[[14,0,14,1],[0,0,0,1],[13,0,13,1],[5,3,7,3],[1,0,2,1]]}
["Bridge Header Information"]
[null,null,null,"How to use the Bridge Header Information tab :",null,null,"Consultant"]
[null,null,null,"1. Fill out the header information in blue.",null,null,"MnDOT","District","SSC Lead","Schedulers","Other "]
["Person filling out these forms :",null,null,null,null,null,null,"D1","Michelle Rognerud","Alex Schulz"]
["Date filled out:",null,null,"2. After you have filled out the header information in blue, press the Create Bridge Fields button. ",null,null,null,"D2","Michelle Rognerud","Steve Voight"]
["District:",null,null,"This will create bridge information fields for each bridge based off of the number given in \"Number of Bridges\" field. Note you can always add more bridge fields by increasing the number of bridges and clicking the Create Bridge Fields button. ",null,null,null,"D3","Michelle Rognerud","Darren Jensen"]
["PUMA Bundle:",null,null,null,null,null,"MnDOT Bridge Work Type","D4","Tim Zamzow","Dan Swanson, Darren Jensen "]
["Prime SP:",null,null,null,null,null,"Three Sided Bridge (New Bridge)","DM","Wendy Kufner"," Ross Jentink, Kyajes Shakya, Robert Hartman, Tom Hilla & Curt Sohn","Jerome Adams, Tim Clyne, Rick Dalton, Mike Gerbensky, Brigid Gombold, Judi Holloway, John Isackson, Beth Neuwndorf, Dale Nikkola, Scott Pederson, Mike J. Reynolds, DaveTorfin, Josie Teyse & Jim Nelson"]
["Let Date",null,null,null,null,null,"Bridge Length/Short","D6","Tim Zamzow","Dan Swanson & Ryan Johnson","Kjersti Anderson, Richard Augustine, Jake Gasper, Chad Hanson, Jai Kelsay, Mike Kempinger, Kyle Lake, Heather Lukes, David Tsang, Tony Wagner"]
["Route Number",null,null,"3. Fill out the added bridge fields ",null,null,"Bridge Painting","D7","Tim Zamzow","Dan Swanson","Chris Bower, Glen Coudron & Robert Jones"]
["Project Manager:",null,null,null,null,null,"Bridge Scoping","D8","Tim Zamzow","Dan Swanson"]
["Project Manager Contact Information (phone/e-mail):",null,null,"Note:  If you need to clear the bridge fields the Clear Bridge Fields button will clear ALL bridge fields",null,null,"Bridge Study"]
["Number of Bridges :",null,null,"and data. You can not undo this action. ",null,null,"Concrete Arch"]
["FOR CO OFFICE USE ONLY",null,null,null,null,null,"Culvert"]
["ACCESS REQUIRED (LIST NAMES)",null,null,null,null,null,"Culvert Extension"]
["SHARED SERVICE CENTER LEAD:     ",{"$f":"IF(B6=\"\",\"\",IF(VLOOKUP(B6,H3:K11,2,FALSE)=\"\",\"\",VLOOKUP(B6,H3:K11,2,FALSE)))","v":""},null,null,null,null,"Deck Overlay, Paint, & Repair Railing or Median Barrier"]
["SCHEDULER:     ",{"$f":"IF(B6=\"\",\"\",IF(VLOOKUP(B6,H3:K11,3,FALSE)=\"\",\"\",VLOOKUP(B6,H3:K11,3,FALSE)))","v":""},null,null,null,null,"Deck Overlay & Repair Railing or Median Barrier"]
["OTHER:     ",{"$f":"IF(B6=\"\",\"\",IF(VLOOKUP(B6,H3:K11,4,FALSE)=\"\",\"\",VLOOKUP(B6,H3:K11,4,FALSE)))","v":""},null,null,null,null,"Deck Overlay & Replace Railing or Median Barrier"]
["Bridge 1",null,null,null,null,null,"Deck Overlay & Other Minor Work"]
["Bridge PUMA Element:",null,null,null,null,null,"Deck Overlay & Paint"]
["PUMA SP (as appears on bridge header in PPMS)",null,null,null,null,null,"Deck Repair & Replace Joints"]
["Bridge Job Number (if known)",null,null,null,null,null,"Deck Repair - Rail Rehab"]
["Current/New Bridge Number",null,null,null,null,null,"Deck Overlay & Replace Joints"]
["Old Bridge Number",null,null,null,null,null,"Deck Overlay"]
["Bridge Route Number",null,null,null,null,null,"Minor Work (Deck Repair, Paint, & Repair Railing or Median Barrier)"]
["Bridge Pre-Design Group as listed in PPMS",null,null,null,null,null,"Miscellaneous"]
["Bridge Design Group as listed in PPMS",null,null,null,null,null,"Miscellaneous Major"]
["Bridge Work Type",null,null,null,null,null,"New Bridge (Phase 1)(Early Steel or Stage Const)"]
["Bridge Cost Estimate as Listed in PPMS",null,null,null,null,null,"Not Applicable"]
["Bridge Project Description as listed in PPMS",null,null,null,null,null,"New Bridge"]
["Bridge Work Package",null,null,null,null,null,"New Bridge (Phase 2)"]
["Bridge Work Responsibility",null,null,null,null,null,"Deck Overlay & Repair Railing or Median Barrier & Replace Joints"]
[null,null,null,null,null,null,"Deck Overlay & Replace Railing or Median Barrier & Paint"]
[null,null,null,null,null,null,"Paint & Replace Joints"]
[null,null,null,null,null,null,"Paint & Other Minor Work"]
[null,null,null,null,null,null,"Parking Garage"]
[null,null,null,null,null,null,"Pedestrian Bridge"]
[null,null,null,null,null,null,"Probably Bridge"]
[null,null,null,null,null,null,"Probably Culvert"]
[null,null,null,null,null,null,"Raise Bridge"]
[null,null,null,null,null,null,"Rehab or Replace"]
[null,null,null,null,null,null,"Remove Bridge"]
[null,null,null,null,null,null,"Renovation"]
[null,null,null,null,null,null,"Replace Railing or Median Barrier & Paint"]
[null,null,null,null,null,null,"Repair Railing or Median Barrier"]
[null,null,null,null,null,null,"Repair Concrete Arch"]
[null,null,null,null,null,null,"Replace Railing or Median Barrier & Replace Joints"]
[null,null,null,null,null,null,"Replace Railing or Median Barrier"]
[null,null,null,null,null,null,"Replace Superstructure - No Prelim Required"]
[null,null,null,null,null,null,"Replace Deck"]
[null,null,null,null,null,null,"Replace Deck & Paint"]
[null,null,null,null,null,null,"Replace Joints"]
[null,null,null,null,null,null,"Retaining Wall"]
[null,null,null,null,null,null,"Riprap"]
[null,null,null,null,null,null,"Replace Deck & Other Minor Work"]
[null,null,null,null,null,null,"Replace Railing or Median Barrier & Other Minor Work"]
[null,null,null,null,null,null,"Repair Railing or Median Barrier & Replace Joints"]
[null,null,null,null,null,null,"Railroad Bridge (New Bridge)"]
[null,null,null,null,null,null,"Substructure Repair"]
[null,null,null,null,null,null,"To Be Determined"]
[null,null,null,null,null,null,"Temporary Bridge"]
[null,null,null,null,null,null,"Temporary Widening"]
[null,null,null,null,null,null,"Widen With Substructure Work & Replace Railing or Median Barrier"]
[null,null,null,null,null,null,"Widen w/Substructure Work (Phase 1)(Early Steel or Stage Const)"]
[null,null,null,null,null,null,"Widen With Substructure Work & Deck Overlay"]
[null,null,null,null,null,null,"Widen With Substructure Work (Phase 2)"]
[null,null,null,null,null,null,"Widen Without Substructure Work & Other Minor Work"]
[null,null,null,null,null,null,"Widen Without Substructure Work & Replace Deck"]
[null,null,null,null,null,null,"Widen Without Substructure Work & Paint"]
[null,null,null,null,null,null,"Widen Without Substructure Work & Deck Overlay"]
[null,null,null,null,null,null,"Widen Without Substructure Work & Deck Overlay & Paint"]
[null,null,null,null,null,null,"Widen With Substructure Work & Paint"]
[null,null,null,null,null,null,"Widen With Substructure Work & Replace Deck"]
[null,null,null,null,null,null,"Widen With Substructure Work & Deck Overlay & Paint"]
[null,null,null,null,null,null,"Widen With Substructure Work & Replace Substructure"]
[null,null,null,null,null,null,"Widen Without Substructure Work, Replace Deck & Paint"]
[null,null,null,null,null,null,"Widen w/Substructure Work"]
[]
[]
[]
[]
[null,null,null,null,null,null,"Drop down list \"districts\""]
[null,null,null,null,null,null,"District 1"]
[null,null,null,null,null,null,"District 2"]
[null,null,null,null,null,null,"District 3"]
[null,null,null,null,null,null,"District 4"]
[null,null,null,null,null,null,"District Metro"]
[null,null,null,null,null,null,"District 6"]
[null,null,null,null,null,null,"District 7"]
[null,null,null,null,null,null,"District 8"]
[null,null,null,null,null,null,"Work Responsibility "]
[null,null,null,null,null,null,"MNDOT "]
[null,null,null,null,null,null,"Consultant "]
[null,null,null,null,null,null,"Bridge Work packages"]
[null,null,null,null,null,null,"New Bridge Template"]
[null,null,null,null,null,null,"Culvert  "]
[null,null,null,null,null,null,"Bridge Preservation"]
[null,null,null,null,null,null,"Bridge Redeck"]
[null,null,null,null,null,null,"Consultant Bridge Design (Prelim & Final Consultant)"]
[null,null,null,null,null,null,"Consultant Bridge Design (Final Only Consultant)"]
[null,null,null,null,null,null,"Bridge Substructure Widening"]
[null,null,null,null,null,null,"Delivery Type"]
[null,null,null,null,null,null,"Design Build (DB)"]
[null,null,null,null,null,null,"Design Bid Build (DBB)"]
[null,null,null,null,null,null,"Contract Manager General Contractor (CMGC)"]
[null,null,null,null,null,null,"Indefinite Delivery Indefinite Quantity (IDIQ)"]
[null,null,null,null,null,null,"Undetermined (UND)"]
[null,null,null,null,null,null,"Not Applicable (NA)"]
[null,null,null,null,null,null,"To Be Determined (TBD)"]

{"sheet":"Templates","index":3,"n_rows":8,"n_cols":7,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,2,1,3],[2,2,2,3],[3,2,3,3],[4,2,4,3]]}
[null,null,null,null,null,null,"See Work Package Dictionary for threshold criteria, deliverables, and a sample Gantt charts."]
[null,"Puma Bundle:",{"$f":"'Header Info'!B5","v":0}]
[null,"Puma Element:",{"$f":"'Header Info'!B6","v":0}]
[null,"SP#:",{"$f":"'Header Info'!B7","v":0}]
[null,"Project Description:",{"$f":"'Header Info'!B9","v":0}]
[null,"Templates",null,null,null,null,"Notes "]
[null,null,null,null,null,null,"- Denotes selectable activity"]
[null,null,null,null,null,null,"* Denotes project-specific or to-be-developed work package"]

{"sheet":"Summary","index":4,"n_rows":83,"n_cols":2,"rows_kept":83,"cut":false,"hidden":false,"merged":[]}
["Puma Bundle:",0]
["Puma Element:",0]
["SP#:",0]
["Project Description:",0]
[]
["Schedule Type:","Project Template"]
[]
["Milestones"]
[null,"Milestones (Design)"]
[]
["Scoping Work Package"]
[]
["Project Management Work Package"]
[null,"Ongoing Project Management"]
[]
["Environmental Work Packages"]
[null,"Early Notification Memo"]
[null,"   - Review & Respond to ENM by CRU"]
[null,"   - Review & Respond to ENM by CMMT"]
[null,"   - Review & Respond to ENM by Regulated Materials"]
[null,"   - Review & Respond to ENM by DNR"]
[null,"   - Review & Respond to ENM by EMTU"]
[null,"   - Review & Respond to ENM by T&ES"]
[null,"   - Review & Respond to ENM by Vegetation"]
[null,"   - Review & Respond to ENM by Bike/Ped"]
[null,"   - Review & Respond to ENM by Aeronautics"]
[null,"   - Review & Respond to ENM by Rail Office"]
[null,"   - Review & Respond to ENM by Value Engineering"]
[null,"   - Review & Respond to ENM by COE"]
[null,"Cultural Resources - Work Package 2 FHWA Funds"]
[null,"Environmental Due Diligence 1"]
[null,"Environmental Due Diligence 2"]
[null,"Environmental Site Assessment (Phase I & II) Early Acquisition"]
[null,"Environmental Site Assessment (Phase I & II) Acquisition"]
[null,"Section 7 Determination  [T&ES]- No Effect "]
[null,"Section 7 Determination  [T&ES]- May Affect"]
[null,"Wetland Delineations"]
[null,"Categorical Exclusion (Programmatic)"]
[null,"NPDES Stormwater Discharge Permit"]
[null,"Wetland/WCA & Aquatic Resources (404/401/Section 10)"]
[null,"DNR Public Waters Permit"]
[null,"Watershed District Permit"]
[]
["Road Design Work Packages"]
[null,"District Land Surveys"]
[null,"Design Surveys"]
[null,"Traffic Forecasts"]
[null,"Intersection Control Evaluation"]
[null,"Transportation Management Plan"]
[null,"Interstate Access Request"]
[null,"Staff Approved Layout"]
[null,"Design Memo / Design Exceptions"]
[null,"RW Construction Limits"]
[null,"Municipal Consent"]
[null,"Municipal Consent (Appeal Process)"]
[null,"Material Design Recommendation (MDR)"]
[null,"*Hydraulics Design Recommendations "]
[null,"ADA Recommendations"]
[null,"Stormwater Treatment Design"]
[null,"Road Plans"]
[null,"Hydraulics / WRE Plans"]
[null,"Traffic Control/Detour/Staging Plan"]
[null,"Pavement Marking Plan"]
[null,"Signing Plan"]
[null,"Signal Plan"]
[null,"Lighting Plan"]
[null,"TMS Plan"]
[null,"Time and Traffic"]
[null,"Special Provisions"]
[null,"Project Turn In"]
[null,"Utility Coordination"]
[]
["Agreements Work Packages"]
[null,"Utility Agreements"]
[null,"Cooperative Construction Agreements"]
[null,"Detour Agreements"]
[]
["Letting Work Packages"]
[null,"Process B"]
[]
["Right of Way Work Packages"]
[]
["Bridge Design Work Package"]

{"sheet":"Owners Manual","index":5,"n_rows":11,"n_cols":1,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
["Schedule Initiation Form Instructions:"]
["Protection Password: "]
["p6password"]
[]
["Changes to the pull down lists\nAll lists are hidden in the sheet the pull down is located. (AKA unhide columns starting at column g)\n"]
[]
["How to add a Work Package\n\n1.  Unhide the base tab\n2.  Add a row under the section of the WBS that the work need be be located\n3.  Add the work package name in column B of the new row\n4.  Add \"X\" to the template you need the work package to auto populate in.\n5.  Click the  delete check boxes button\n6.  Click the recreate check boxes button\n7.  Save and test"]
[]
["How to add Standard Templates\n'A standard template is a template that is in the authoritative node in P6 and does not have to be revised or altered when it is copied into a project shell.\n\n1.  Unhide the base tab\n2.  In the last unused column add the name of the new template in the first row\n3.  Mark with an \"X\" all work packages in the new template column in need rows\n4.  Go to the \"Templates Tab\"\n5.  Switch the spreadsheet to design mode\n6.  On the templates table add an option button and name it\n7.  Right click on the option button and go to view code\n8.  Copy the code in option button2 and past it into the new option button code location.\n9.  Change the  \"base_column\" to match the column the new template is located in the base tab\n10. Switch the spreadsheet out of design mode, Save and test\n"]
[]
["How to add a Reduction Template\n'A Reduction Template is a template that is formed by dissolves work packages or activities from a standard template.\n\n'1.  Unhide the base tab\n'2.   In the last unused column add \"Uncheck Column for  (name of template)\"  in the first row\n'3.  Mark with an \"X\" all work packages that need to be dissolved in the new uncheck column\n'4.  Go to the \"Templates Tab\"\n'5.  Switch the spreadsheet to design mode\n'6.  On the templates tab add an option button and name it\n'7.  Right click on the option button and go to view code\n'8.  Copy the code in option button1 and past it into the new option button code location.\n'9.  Change the  \"base_column\" to match the standard templates column that is base for the Reduction Template\n'10. Change the  \"uncheck_column\" to match the new uncheck column for the Reduction Template\n'11. Go to the section of the code called \"change_schedule_Type\"\n'12. Copy one of the ElseIf statements past in a new ElseIf\n'13. Change the name (what's between the \"__\") in  first line to the name of the option button\n'14.  Change the name (what's between the \"__\") in  Second line to the message you want the scheduler to see\n'15. Switch the spreadsheet out of design mode, Save and test"]

{"sheet":"Base","index":6,"n_rows":161,"n_cols":11,"rows_kept":161,"cut":false,"hidden":true,"merged":[[26,1,26,2]]}
[null,null,null,"Holding Column","Project Template","Minor Template","Scoping Template","Landscape Standalone Project Template","Uncheck Column for Lighting Standalone Template","Uncheck Column for Signal Standalone Template","Uncheck Column for Signing Standalone Template"]
["Milestones"]
[null,"Milestones (Scoping)",null,null,null,null,"X"]
[null,"Milestones (Design)",null,null,"X","X"]
[null,"Milestones (Landscape)",null,null,null,null,null,"X"]
["Scoping Work Package"]
[null,"*Scoping Document ",null,null,null,null,"X"]
[null,"*Project Baseline",null,null,null,null,"X"]
["Project Management Work Package"]
[null,null,"*Functional Group Schedule Acceptance"]
[null,"Ongoing Project Management",null,null,"X"]
[null,"*Public Involvement"]
["Environmental Work Packages"]
[null,"Early Notification Memo",null,null,"X"]
[null,"   - Review & Respond to ENM by CRU",null,null,"X","X"]
[null,"   - Review & Respond to ENM by CMMT",null,null,"X","X"]
[null,"   - Review & Respond to ENM by Regulated Materials",null,null,"X"]
[null,"   - Review & Respond to ENM by DNR",null,null,"X"]
[null,"   - Review & Respond to ENM by EMTU",null,null,"X"]
[null,"   - Review & Respond to ENM by T&ES",null,null,"X"]
[null,"   - Review & Respond to ENM by Vegetation",null,null,"X"]
[null,"   - Review & Respond to ENM by Bike/Ped",null,null,"X","X"]
[null,"   - Review & Respond to ENM by Aeronautics",null,null,"X"]
[null,"   - Review & Respond to ENM by Rail Office",null,null,"X"]
[null,"   - Review & Respond to ENM by Value Engineering",null,null,"X"]
[null,"   - Review & Respond to ENM by COE",null,null,"X"]
[null,"Cultural Resources - Work Package 1 Full Section 106 Review - All Federal Agencies"]
[null,"Cultural Resources - Work Package 2 FHWA Funds",null,null,{"$f":"IF('Header Info'!B19=\"No\",\"\",\"X\")","v":"X"}]
[null,"Cultural Resources - Work Package 3 State Level Review (State Funds Only)",null,null,{"$f":"IF('Header Info'!B19=\"No\",\"X\",\"\")","v":""},"X"]
[null,"Regulatory File Review",null,null,null,"X"]
[null,"Environmental Due Diligence 1",null,null,"X"]
[null,"Environmental Due Diligence 2",null,null,"X"]
[null,"Environmental Due Diligence 3"]
[null,"Environmental Site Assessment (Phase I & II) No Acquisition"]
[null,"Environmental Site Assessment (Phase I & II) Early Acquisition",null,null,"X"]
[null,"Environmental Site Assessment (Phase I & II) Acquisition",null,null,"X"]
[null,"Phase I Update"]
[null,"Phase II Update"]
[null,"No Association Determination"]
[null,"Response Action Plans"]
[null,"Contaminated Materials Management Special Provisions"]
[null,"Regulated Materials Buildings"]
[null,"Regulated Materials Bridge"]
[null,"Noise Analysis"]
[null,"Air Quality Analysis"]
[null,"Section 7 Determination  [T&ES]- No Effect ",null,null,{"$f":"IF('Header Info'!B19=\"No\",\"\",\"X\")","v":"X"}]
[null,"Section 7 Determination  [T&ES]- May Affect",null,null,"X"]
[null,"Section 7 Determination  [T&ES]- Formal Consultation "]
[null,"Mussel Survey"]
[null,"Vegetation Review"]
[null,"Wetland Delineations",null,null,"X"]
[null,"*Wetland Delineations (Metro)"]
[null,"*Floodplain Assessment"]
[null,"*Wild & Scenic River Coordination"]
[null,"*Groundwater Impact Study"]
[null,"Section 6(f) Coordination"]
[null,"*Environmental Justice Analysis"]
[null,"Visual Impact Assessment"]
[null,"*Earthborn Vibrations Study"]
[null,"*Geotechnical Study"]
[null,"*Farmland Conversion Impact Rating (Form AD 1006)"]
[null,"*Energy Analysis"]
[null,"*Other Environmental Studies"]
[null,"Section 4(f) Coordination"]
[null,"*LOMAR/CLOMAR"]
[null,"*Environmental Document Exemption"]
[null,"Categorical Exclusion (Non-Programmatic)"]
[null,"Categorical Exclusion (Programmatic)",null,null,"X","X"]
[null,"Environmental Assessment/Environmental Assessment Worksheet"]
[null,"Environmental Assessment Worksheet (EAW) State"]
[null,"Environmental Impact Statement (EIS)"]
[null,"*EIS Re-Evaluation"]
[null,"*Supplemental EIS"]
[null,"NPDES Stormwater Discharge Permit",null,null,"X",null,null,"X"]
[null,"Wetland/WCA & Aquatic Resources (404/401/Section 10)",null,null,"X"]
[null,"DNR Public Waters Permit",null,null,"X"]
[null,"Watershed District Permit",null,null,"X",null,null,"X"]
[null,"Section 9 (Coast Guard) Permit"]
["Road Design Work Packages"]
[null,"Geodetic Control Surveys"]
[null,"Project Control Surveys"]
[null,"District Land Surveys",null,null,"X"]
[null,"Design Surveys",null,null,"X","X",null,"X"]
[null,"Photogrammetric Basemap"]
[null,"Traffic Counts"]
[null,"Traffic Forecasts",null,null,"X"]
[null,"*Traffic Modeling"]
[null,"*Crash Analysis"]
[null,"Intersection Control Evaluation",null,null,"X"]
[null,"Transportation Management Plan",null,null,"X","X",null,"X"]
[null,"Interstate Access Request",null,null,"X"]
[null,"Staff Approved Layout",null,null,"X"]
[null,"Design Memo / Design Exceptions",null,null,"X"]
[null,"RW Construction Limits",null,null,"X"]
[null,"Value Engineering"]
[null,"Municipal Consent",null,null,"X"]
[null,"Municipal Consent (Appeal Process)",null,null,"X"]
[null,"Foundation Recommendations"]
[null,"Material Design Recommendation (MDR)",null,null,"X"]
[null,"*Traffic Recommendations"]
[null,"*Hydraulics Design Recommendations ",null,null,"X"]
[null,"ADA Recommendations",null,null,"X","X"]
[null,"*Bike/Pedestrian Recommendations"]
[null,"Stormwater Treatment Design",null,null,"X"]
[null,"Visual Quality Management Plan"]
[null,"*Drain Tile Design"]
[null,"Road Plans",null,null,"X","X",null,null,"X","X","X"]
[null,"Hydraulics / WRE Plans",null,null,"X"]
[null,"Traffic Control/Detour/Staging Plan",null,null,"X","X"]
[null,"Pavement Marking Plan",null,null,"X","X"]
[null,"Signing Plan",null,null,"X","X",null,null,"X"]
[null,"Signal Plan",null,null,"X","X",null,null,"X",null,"X"]
[null,"Lighting Plan",null,null,"X","X",null,null,null,"X","X"]
[null,"TMS Plan",null,null,"X","X",null,null,null,null,"X"]
[null,"Time and Traffic",null,null,"X","X",null,"X"]
[null,"Special Provisions",null,null,"X","X",null,"X","X","X","X"]
[null,"Project Turn In",null,null,"X","X",null,"X"]
[null,"Living Snow Fence Partnership"]
[null,"Landscape Plans ",null,null,null,null,null,"X"]
[null,"Subsurface Utility Engineering"]
[null,"Utility Coordination",null,null,"X",null,null,"X"]
[null,"Blowing and Drifting Snow "]
[null,null,null,"Bridge Design Work Packages"]
[null,null,null,"New Bridge Template"]
[null,null,null,"Culvert  "]
[null,null,null,"Bridge Preservation"]
[null,null,null,"Bridge Redeck"]
[null,null,null,"Consultant Bridge Design (Prelim & Final Consultant)"]
[null,null,null,"Consultant Bridge Design (Final Only Consultant)"]
[null,null,null,"Bridge Substructure Widening"]
[]
["Agreements Work Packages"]
[null,"*Informal Agreements"]
[null,"Lighting Agreements",null,null,null,"X"]
[null,"Signal Agreements",null,null,null,"X"]
[null,"Utility Agreements",null,null,"X"]
[null,"Cooperative Construction Agreements",null,null,"X"]
[null,"Detour Agreements",null,null,"X"]
[null,"Railroad Flagging Agreements"]
[null,"Railroad Bridge Agreements"]
[null,"Railroad Track Relocation Agreements"]
[null,"*Turnback Agreements"]
[null,"*Joint Powers Agreements"]
[]
["Letting Work Packages"]
[null,"Process A"]
[null,"Process B",null,null,"X","X",null,"x"]
[null,"Complex Process B"]
[null,"PODI Process B"]
[null,"Prequalification (Tech Proposal)"]
[null,"Letting By Others"]
[null,"Negotiated Contracts"]
[null,"Design Build"]
[null,"*Construction Manager/General Contractor (CMGC)"]
[]
["Right of Way Work Packages"]
[null,"Fee Acquisition"]
[null,"Acquisition (Metro)"]
[null,"Temporary Right to Construct "]
[null,"Commissioner's Orders"]
[null,"*Property Conveyance"]