{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Scope Inputs","Sheet1","Estimate"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Scope Inputs","index":0,"n_rows":239,"n_cols":23,"rows_kept":239,"cut":false,"hidden":false,"merged":[[30,3,30,4],[44,3,44,4],[98,3,98,4]]}
["Last Updated: 06/19/2019"]
[null,"Level of Complexity",null,"1 - Simple",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1 - Simple",1,"1 - Isolated (1)",1]
[null,"Size of Existing Network (# of signalized intersections)",null,"1 - Isolated (1)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2 - Low",2,"2 - Small (2-4)",2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3 - Moderate",3,"3 - Medium (5-9)",3]
[null,"Estimation Index (1-10)",null,{"$f":"T7+V7","v":2},null,"Unit Cost","Unit Cost","Total","Total",null,null,null,null,null,null,null,null,null,null,"4 - High",4,"4 - Large (10-17)",4]
[null,null,null,null,null,"Mandays","Mandays","Mandays","Mandays",null,null,null,null,null,null,null,null,null,null,"5 - Very Complex",5,"5 - Very Large (18+)",5]
[1,"Project Management, Coordination and Administration",null,null,null,"(Low)","(High)","(Low)","(High)",null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(D2,T2:U6,2,TRUE)","v":1},null,{"$f":"VLOOKUP(D3,V2:W6,2,TRUE)","v":1}]
[1.1000000000000001,"Project Management and Administration",18,0,null,0.75,1.5,{"$f":"D8*F8","v":0},{"$f":"D8*G8","v":0},null,"Based on complexity of project and how much coordination is needed.  If part of a contract from another branch, should be removed or only 1 month allowed.  If standalone project may be toward higher end."]
[null,null,null,null,null,null,null,{"$f":"SUM(H18:H239)*0.1","v":0},{"$f":"SUM(I18:I239)*0.1","v":0},null,"Cap of 10% of Mandays to complete analysis"]
[1.2,"Project Coordination",19,0,null,0.25,0.75,{"$f":"D10*F10","v":0},{"$f":"D10*G10","v":0},null,"Based on complexity of project and how much coordination is needed with other groups or branches",null,null,null,null,null,null,null,null,null,"Non-Calibrated"]
[null,null,null,null,null,null,null,{"$f":"SUM(H18:H239)*0.05","v":0},{"$f":"SUM(I18:I239)*0.05","v":0},null,"Cap of 5% of Mandays to complete analysis"]
[null,"Meetings","020/021",0,0,0.5,0.5,{"$f":"D12*E12*F12","v":0},{"$f":"D12*E12*G12","v":0},null,"Depending on likely length of meetings.  Includes travel and prep time",null,null,null,null,null,null,null,null,null,"Calibrated to Forecast"]
[null,"Additional travel time (beyond 1 hour assumed for local meetings)",null,0,{"$f":"E12*D12","v":0},0.125,0.125,{"$f":"D13*E13*F13","v":0},{"$f":"D13*E13*G13","v":0},null,"Add additional travel time for meetings not local to attendees (column E is number of meeting * attendees from line above.  If not all meetings are out of town overwrite with number of person-meetings requiring additional travel.)",null,null,null,null,null,null,null,null,null,"Calibrated to Field Counts"]
[1.3,"Consultant Coordination",null,0,0,0.25,0.75,{"$f":"D14*E14*F14","v":0},{"$f":"D14*E14*G14","v":0},null,"Based on complexity of project and how much coordination is needed with prime or sub consultants.  Enter number of consultants that require substantial coordination"]
[null,null,null,null,null,null,null,{"$f":"SUM(H18:H239)*0.05","v":0},{"$f":"SUM(I18:I239)*0.05","v":0},null,"Cap of 5% of Mandays to complete analysis"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Required"]
[2,"Data Collection and Field Visit",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Not Required"]
[2.1,"Data Collection (0 or 1 only)",null,0,null,0.5,2,{"$f":"D18*F18","v":0},{"$f":"D18*G18","v":0},null,"Depend on size of network and how much data is needed"]
[]
[2.2000000000000002,"Field Visit",null,"Not Required"]
[null,"Field Visit - Preparation",null,1,null,0.25,0.75,{"$f":"IF($D$20=\"Required\",($D21*F21),0)","v":0},{"$f":"IF($D$20=\"Required\",($D21*G21),0)","v":0},null,"Depends on how large the study is"]
[null,"Field Visit Travel - One Way",22,0,2,0.125,0.125,{"$f":"IF($D$20=\"Required\",(D22*E22*F22*2),0)","v":0},{"$f":"IF($D$20=\"Required\",(D22*E22*G22*2),0)","v":0},null,"Travel time to project "]
[null,"Field Visit Observation",null,0,2,0.125,0.125,{"$f":"IF($D$20=\"Required\",(D23*E23*F23),0)","v":0},{"$f":"IF($D$20=\"Required\",(D23*E23*G23),0)","v":0},null,"Assume only observing 1 peak and field review"]
[]
[3,"Traffic Volume Development ",null,"Not Required"]
[]
[3.1,"Convert Forecast to Peak Hour Volumes","023/024",0,0,0.03,0.03,{"$f":"IF(($D$25=\"Required\"),(D27*E27*F27),0)","v":0},{"$f":"IF(($D$25=\"Required\"),(D27*E27*G27),0)","v":0},null,"15 minutes per intersection per scenario"]
[null,"Breakouts for interchanges/alternative designs","025/026",0,0,0.03,0.06,{"$f":"IF(($D$25=\"Required\"),(D28*E28*F28),0)","v":0},{"$f":"IF(($D$25=\"Required\"),(D28*E28*G28),0)","v":0},null,"15-30 minutes  per breakout to interchange or alternative intersection"]
[3.2,"Balance Peak Hour Volumes","023/024",0,0,0.02,0.03,0,0,null,"10-15 minutes per intersection to balance.  This is essentially developing a spreadsheet that may be more for a single scenario, but is much lower for additional scenarios as it is already setup"]
[]
[3.3,"OD Matrix Development",null,{"$f":"IF((SUM(J32:J37)>1),\"Please Choose Only 1 OD Method\",\"\")","v":""}]
[null,"Method 1: Corridor Turn Proportions",null,0,0,4.1700000000000001E-2,4.1700000000000001E-2,{"$f":"IF(($D$25=\"Required\"),(D32*E32*F32),0)","v":0},{"$f":"IF(($D$25=\"Required\"),(D32*E32*G32),0)","v":0},{"$f":"IF((I32>0),1,0)","v":0},"20 minutes per intersection to input data into spreadsheet"]
[null,"Method 2: Engineering Judgment/Manual Balancing",null,0,0,6.25E-2,8.3299999999999999E-2,0,0,{"$f":"IF((I33>0),1,0)","v":0},"30-40 minutes per intersection to develop matrix.  This is essentially developing a spreadsheet that may be more for a single scenario, but is much lower for additional scenarios as it is already setup"]
[null,"Method 3: Travel Demand Models",null,0,0,9.3799999999999994E-2,0.125,{"$f":"IF(($D$25=\"Required\"),(IF((D34=0),0,(0.5+(AVERAGEA(D34:E34))*F34))),0)","v":0},{"$f":"IF(($D$25=\"Required\"),(IF((D34=0),0,(0.5+(AVERAGEA(D34:E34))*G34))),0)","v":0},0,"4 hours + 45-60 minutes per intersection to develop matrix.  This includes running the travel demand model.  If extensive work on the travel demand model is required it should be scoped separately"]
[null,"Method 4: OD Data Collection",null,0,0,3.1300000000000001E-2,3.1300000000000001E-2,{"$f":"IF(($D$25=\"Required\"),(IF((D35=0),0,(0.375+(AVERAGEA(D35:E35))*F35))),0)","v":0},{"$f":"IF(($D$25=\"Required\"),(IF((D35=0),0,(0.375+(AVERAGEA(D35:E35))*G35))),0)","v":0},null,"3 hours + 15 minutes per intersection to run the StreetLight Data Insight data"]
[null,null,null,0,0,3.1300000000000001E-2,4.1700000000000001E-2,{"$f":"IF(($D$25=\"Required\"),(D36*E36*F36),0)","v":0},{"$f":"IF(($D$25=\"Required\"),(D36*E36*G36),0)","v":0},0,"15-20 minutes per intersection to develop matrix.  This is essentially developing a spreadsheet that may be more for a single scenario, but is much lower for additional scenarios as it is already setup"]
[null,"Method 5: Turning Movement Based Simulation Output",null,0,0,3.1300000000000001E-2,3.1300000000000001E-2,{"$f":"IF(($D$25=\"Required\"),(IF((D37=0),0,(0.5+(AVERAGEA(D37:E37))*F37))),0)","v":0},{"$f":"IF(($D$25=\"Required\"),(IF((D37=0),0,(0.5+(AVERAGEA(D37:E37))*G37))),0)","v":0},0,"4 hours + 15 minutes per intersection to run TransModeler and average the outputs"]
[]
[3.4,"Origin Destination Matrix Estimation (ODME) Development",null,0]
[null,null,null,0,0,2.0799999999999999E-2,2.0799999999999999E-2,{"$f":"IF(($D$25=\"Required\"),(IF((D40=0),0,((0.375*D39)+(AVERAGEA(D40:E40))*D39*F40))),0)","v":0},{"$f":"IF(($D$25=\"Required\"),(IF((D40=0),0,((0.5*D39)+(AVERAGEA(D40:E40))*D39*G40))),0)","v":0},null,"3-4 hours per scenario + 10 minutes per origin or destination"]
[]
[3.5,"Class Based OD Matrix Development",null,0]
[null,null,null,0,0,2.0799999999999999E-2,2.0799999999999999E-2,{"$f":"IF(($D$25=\"Required\"),(IF((D43=0),0,(0.375+(AVERAGEA(D43:E43))*D42*F43))),0)","v":0},{"$f":"IF(($D$25=\"Required\"),(IF((D43=0),0,(0.375+(AVERAGEA(D43:E43))*D42*G43))),0)","v":0},null,"3 hours + 10 minutes per origin or destination"]
[]
[3.6,"Multi-hour Simulation OD Matrix Development",null,{"$f":"IF((SUM(J46:J47)>1),\"Please Choose Only 1 OD Method\",IF((0>E46<3),\"Minimum Number of Hours is 3\",\"\"))","v":""}]
[null,"Option 1: Scaling Factor and Loading Curve",null,null,0,6.25E-2,6.25E-2,{"$f":"IF(($D$25=\"Required\"),(IF((E46=0),0,(0.375+((E46-2)*F46)))),0)","v":0},{"$f":"IF(($D$25=\"Required\"),(IF((E46=0),0,(0.375+((E46-2)*G46)))),0)","v":0},{"$f":"IF((I46>0),1,0)","v":0},"2 hours + 30 minutes for each hour greater than standard 2 hours"]
[null,"Option 2: Individual OD matrices for each hour",null,0,0,null,null,{"$f":"IF(($D$25=\"Required\"),(SUM(H32:H37)*(0.5+(0.125*(E47-4)))),0)","v":0},{"$f":"IF(($D$25=\"Required\"),(SUM(I32:I37)*(0.5+(0.125*(E47-4)))),0)","v":0},{"$f":"IF((I47>0),1,0)","v":0},"total time to develop 2 peak hour matrices (Section 3.3) multiplied by 50% for 4 hours and 12.5% for each hour beyond 4"]
[]
[3.7,"Add Origin Destination Matrices in TransModeler",null,{"$f":"IF((SUM(D32:D34,D36:D37)>0),1,0)","v":0},null,null,null,{"$f":"IF(($D$25=\"Required\"),(MAX((D32:D34,D36,D37))*(0.25+(0.0313*(MAX(E46:E47))))),0)","v":0},{"$f":"IF(($D$25=\"Required\"),(MAX((D32:D34,D36,D37))*(0.25+(0.0313*(MAX(E46:E47))))),0)","v":0},null,"2 hours + 15 minutes for each hourly matrix"]
[]
[4,"201X Base Year Model",null,"Not Required"]
[]
[4,"201X Base Year Model"]
[4.0999999999999996,"Model Development"]
["4.1.1","Initial Model Setup"]
[null,"Develop Default File/Reference Aerial Photography",null,1,null,0.25,0.5,{"$f":"IF($D$51=\"Required\",($D56*F56),0)","v":0},{"$f":"IF($D$51=\"Required\",($D56*G56),0)","v":0},null,"2-4 hours"]
[null,"Merge Existing Models into Network",27,0,null,0.25,0.5,{"$f":"IF($D$51=\"Required\",($D57*F57),0)","v":0},{"$f":"IF($D$51=\"Required\",($D57*G57),0)","v":0},null,"2-4 hours per model - Depending on size and quality of model"]
[]
["4.1.2","Develop Base Year Model in TransModeler"]
[null,"Freeway Coding",28,0,null,0.15625,0.1875,{"$f":"IF($D$51=\"Required\",($D60*F60),0)","v":0},{"$f":"IF($D$51=\"Required\",($D60*G60),0)","v":0},null,"75-90 minutes per mile"]
[null,"Arterial/Collector/Local Coding",29,0,null,0.1875,0.25,0,0,null,"90-120 minutes per mile"]
[null,"System Interchange (Standard)",31,0,null,0.5,0.75,0,0,null,"4-6 hours per interchange"]
[null,"System Interchange (Complex)",31,0,null,1.5,2,0,0,null,"12-16 hours per interchange"]
[null,"Service Interchange (Standard)*",33,0,null,0.375,0.5,0,0,null,"3-4 hours per interchange"]
[null,"Service Interchange (DDI)*",34,0,null,0.5,1,0,0,null,"4-8 hours per interchange"]
[null,"Unsignalized Intersection",35,0,null,4.1669999999999999E-2,8.3330000000000001E-2,0,0,null,"20-40 minutes per intersection"]
[null,"Unsignalized  Superstreet (includes main intersection and 2 u-turns)",null,0,null,0.25,0.5,{"$f":"IF($D$51=\"Required\",($D67*F67),0)","v":0},{"$f":"IF($D$51=\"Required\",($D67*G67),0)","v":0},null,"2-4 hours per intersection"]
[null,"Single Lane Roundabout",null,0,null,0.125,0.1875,0,0,null,"60-90 minutes per intersection"]
[null,"Dual Lane Roundabout",null,0,null,0.25,0.375,0,0,null,"2-3 hours per intersection"]
[null,"Signalized Intersection (Simple)",36,0,null,0.1875,0.41670000000000001,0,0,null,"120-200 minutes per intersection"]
[null,"Signalized Intersection (Complex)",38,0,null,0.3125,0.5,0,0,null,"180-240 minutes per intersection"]
[null,"Signalized Intersection (Unconventional)",39,0,null,0.5,0.75,0,0,null,"4-6 hours per intersection"]
[null,"Signalized Intersection (Superstreet) (includes main intersection and 2 u-turns",40,0,null,0.5,1,0,0,null,"4-8 hours per intersection"]
[null,"Adding Z-Elevations (0 or 1 only)",null,0,null,0.25,0.75,0,0,null,"Depending on size of model and number of bridges that require hand manipulating elevations"]
[]
["4.1.3","Adding Volume Data to Model "]
[null,"Add Peak Hour Volumes - Balanced",41,0,null,1.042E-2,2.0830000000000001E-2,{"$f":"IF($D$51=\"Required\",($D77*F77*2),0)","v":0},{"$f":"IF($D$51=\"Required\",($D77*G77*2),0)","v":0},null,"5-10 minutes per intersection to add volumes to intersection in TransModeler - multiplied by 2 for AM and PM Peaks"]
[]
[null,"Add vehicle composition data or heavy vehicle data",null,0,null,0.25,0.5,{"$f":"IF($D$51=\"Required\",($D79*F79),0)","v":0},{"$f":"IF($D$51=\"Required\",($D79*G79),0)","v":0},null,"1-2 hours per model (unless class based matrices are being utilized)"]
[]
["4.1.4","Optimize Signalized Intersections",42,0,0,{"$f":"90/480","v":0.1875},0.25,{"$f":"IF($D$51=\"Required\",(($D81*F81)+(0.0313*E81)),0)","v":0},{"$f":"IF($D$51=\"Required\",(($D81*G81)+(0.0625*E81)),0)","v":0},null,"90-120 minutes per corridor + 15-30 minutes per signal"]
[null,null,43,0,null,6.25E-2,0.125,{"$f":"IF($D$51=\"Required\",($D82*F82),0)","v":0},{"$f":"IF($D$51=\"Required\",($D82*G82),0)","v":0},null,"30-60 minutes per intersection"]
[]
["4.1.5","Dynamic Traffic Assignment",null,0,0,{"$f":"1/480","v":2.0833333333333333E-3},{"$f":"2/480","v":4.1666666666666666E-3},{"$f":"IF($D$51=\"Required\",(D84*0.5)+(D84*E84*F84),0)","v":0},{"$f":"IF($D$51=\"Required\",(D84*0.5)+(D84*E84*G84),0)","v":0},null,"4 hours + 1-2 minutes per iteration"]
[{"$f":"SUM(D66:D73)","v":0},{"$f":"IF((A85=0),\"\",\"Recommended Iterations = \"&IF((A85<9),25,IF((A85<16),50,IF((A85<31),100,\"> 100\"))))","v":""},null,0,null,{"$f":"10/480","v":2.0833333333333332E-2},{"$f":"20/480","v":4.1666666666666664E-2},{"$f":"IF($D$51=\"Required\",D84*D85*F85,0)","v":0},{"$f":"IF($D$51=\"Required\",D84*D85*G85,0)","v":0},null,"10-20 minutes per intersection"]
[]
["4.1.6","Code Measures of Effectiveness",null,1,null,6.25E-2,0.25,{"$f":"IF($D$51=\"Required\",($D87*F87),0)","v":0},0,null,"30-120 minutes per model"]
[null,"Develop Output Spreadsheet",44]
[null,"Intersections",45,0,null,6.25E-2,6.25E-2,0,{"$f":"IF($D$51=\"Required\",($D89*G89),0)","v":0},null,"30 minutes per intersection"]
[null,"Freeway Segments",null,0,null,{"$f":"20/480","v":4.1666666666666664E-2},{"$f":"20/480","v":4.1666666666666664E-2},0,{"$f":"IF($D$51=\"Required\",($D90*G90),0)","v":0},null,"20 minutes per analysis point"]
[null,"Multi-lane Segments",null,0,null,{"$f":"20/480","v":4.1666666666666664E-2},4.1666666666666664E-2,{"$f":"IF($D$51=\"Required\",($D91*F91),0)","v":0},{"$f":"IF($D$51=\"Required\",($D91*G91),0)","v":0},null,"20 minutes per analysis point"]
[null,"Two-Lane Segments",null,0,null,4.1666666666666664E-2,4.1666666666666664E-2,0,0,null,"20 minutes per analysis point"]
[null,"Corridor Heat Maps",null,0,null,0.25,0.5,{"$f":"IF($D$51=\"Required\",($D93*F93),0)","v":0},{"$f":"IF($D$51=\"Required\",($D93*G93),0)","v":0},null,"2-4 hours per corridor"]
[null,"Corridor/Route MOE's (0 or 1 only)",null,0,null,{"$f":"3/8","v":0.375},{"$f":"6/8","v":0.75},{"$f":"IF($D$51=\"Required\",($D94*F94),0)","v":0},0,null,"3-6 hours"]
[]
["4.1.7","Error Check/Visual Audit/Quality Control",null,1,null,0.08,0.1,{"$f":"IF($D$51=\"Required\",(SUM(H84:H85,H60:H74,H77:H77,H81:H82,H87:H94,H79))*F96,0)","v":0},{"$f":"IF($D$51=\"Required\",(SUM(I84:I85,I60:I74,I77:I77,I81:I82,I87:I94,I79))*G96,0)","v":0},null,"8-10% of model development time"]
[]
[]
["4.1.8","Default Values/Visual Validation/Calibration",null,{"$f":"IF((A100=0),\"Add 1 each to one of the categories below\",IF((A100>1),\"Only choose one of the below types\",IF((D102=1),\"Add custom scope in Section 10\",\"\")))","v":"Add 1 each to one of the categories below"}]
[{"$f":"SUM(D100:D102)","v":0},"Default Values",null,0,null,0,0,{"$f":"IF($D$51=\"Required\",($D94*F94),0)","v":0},{"$f":"IF($D$51=\"Required\",($D94*F94),0)","v":0},null,"No effort required"]
[null,"Visual Validation",null,0,null,0.04,7.4999999999999997E-2,{"$f":"IF(D51=\"Required\",(SUM(H84:H85,H60:H74,H77:H77,H81:H82,H87:H94,H79))*F101,0)","v":0},{"$f":"IF(D51=\"Required\",(SUM(I84:I85,I60:I74,I77:I77,I81:I82,I87:I94,I79))*G101,0)","v":0},null,"4-7.5% of model development time"]
[null,"Calibration",null,0,null,0,0,{"$f":"IF($D$51=\"Required\",($D94*F94),0)","v":0},{"$f":"IF($D$51=\"Required\",($D94*F94),0)","v":0},null,"Develop Custom Scope in Section 10"]
[]
[]
["4.1.9","Run Model/Extract Outputs - Setup Run Controls/Run Simulation",null,1,null,0.25,0.75,{"$f":"IF($D$51=\"Required\",($D105*F105),0)","v":0},{"$f":"IF($D$51=\"Required\",($D105*G105),0)","v":0},null,"2-6 hours per model"]
[]
[]
["4.1.10","Multi-hour Simulation Adjustment",null,0,null,{"$f":"IF((D108=0),0,IF((D108<2.1),0,IF((D108<5),0.1,IF((D108<7),0.15,IF((D108>6),0.2,0)))))","v":0},{"$f":"IF((D108=0),0,IF((D108<2.1),0,IF((D108<5),0.2,IF((D108<7),0.25,IF((D108>6),0.3,0)))))","v":0},{"$f":"IF($D$51=\"Required\",(SUM(H84:H85,H60:H74,H77:H77,H81:H82,H87:H94,H79,H56:H57,H96,H100:H102,H105))*F108,0)","v":0},{"$f":"IF($D$51=\"Required\",(SUM(I84:I85,I60:I74,I77:I77,I81:I82,I87:I94,I79,I56:I57,I96,I100:I102,I105))*G108,0)","v":0},null,"10-30% of sections 4.1.1 through 4.1.9"]
[]
[]
[5,"204X No-Build Analysis",null,"Not Required"]
[]
[5.0999999999999996,"Model Development"]
["5.1.1","Develop Future Year No-Build Model"]
[null,"Freeway Coding",28,0,null,0.15625,0.1875,{"$f":"IF($D$111=\"Required\",($D115*F115),0)","v":0},{"$f":"IF($D$111=\"Required\",($D115*G115),0)","v":0},null,"75-90 minutes per mile"]
[null,"Arterial/Collector/Local Coding",29,0,null,0.1875,0.25,0,0,null,"90-120 minutes per mile"]
[null,"System Interchange (Standard)",31,0,null,0.5,0.75,0,0,null,"4-6 hours per interchange"]
[null,"System Interchange (Complex)",31,0,null,1.5,2,0,0,null,"12-16 hours per interchange"]
[null,"Service Interchange (Standard)*",33,0,null,0.375,0.5,0,0,null,"3-4 hours per interchange"]
[null,"Service Interchange (DDI)*",34,0,null,0.5,1,0,0,null,"4-8 hours per interchange"]
[null,"Unsignalized Intersection",35,0,null,4.1669999999999999E-2,8.3330000000000001E-2,0,0,null,"20-40 minutes per intersection"]
[null,"Unsignalized  Superstreet (includes main intersection and 2 u-turns)",null,0,null,0.25,0.5,0,0,null,"2-4 hours per intersection"]
[null,"Single Lane Roundabout",null,0,null,0.125,0.1875,0,0,null,"60-90 minutes per intersection"]
[null,"Dual Lane Roundabout",null,0,null,0.25,0.375,0,0,null,"2-3 hours per intersection"]
[null,"Signalized Intersection (Simple)",36,0,null,0.1875,0.41670000000000001,0,0,null,"120-200 minutes per intersection"]
[null,"Signalized Intersection (Complex)",38,0,null,0.3125,0.5,0,0,null,"180-240 minutes per intersection"]
[null,"Signalized Intersection (Unconventional)",39,0,null,0.5,0.75,0,0,null,"4-6 hours per intersection"]
[null,"Signalized Intersection (Superstreet) (includes main intersection and 2 u-turns",40,0,null,0.5,1,0,0,null,"4-8 hours per intersection"]
[null,"Adding Z-Elevations (0 or 1 only)",null,0,null,0.25,0.75,0,0,null,"Depending on size of model and number of bridges that require hand manipulating elevations"]
[]
["5.1.2","Adding Volume Data to Model"]
[null,"Add Peak Hour Volumes",null,0,null,1.042E-2,2.0830000000000001E-2,{"$f":"IF($D$111=\"Required\",($D132*F132*2),0)","v":0},{"$f":"IF($D$111=\"Required\",($D132*G132*2),0)","v":0},null,"5-10 minutes per intersection to add volumes to intersection in TransModeler - multiplied by 2 for AM and PM Peaks"]
[]
[null,"Add vehicle composition data or heavy vehicle data",null,0,null,{"$f":"F79/4","v":6.25E-2},{"$f":"G79/4","v":0.125},{"$f":"IF($D$111=\"Required\",($D134*F134),0)","v":0},{"$f":"IF($D$111=\"Required\",($D134*G134),0)","v":0},null,"25% of Base Year"]
[]
["5.1.3","Optimize Signalized Intersections",42,0,0,{"$f":"90/480","v":0.1875},0.25,{"$f":"IF($D$111=\"Required\",(($D136*F136)+(0.0313*E136)),0)","v":0},{"$f":"IF($D$111=\"Required\",(($D136*G136)+(0.0625*E136)),0)","v":0},null,"90-120 minutes per corridor + 15-30 minutes per signal"]
[null,null,43,0,null,6.25E-2,0.125,{"$f":"IF($D$111=\"Required\",($D137*F137),0)","v":0},{"$f":"IF($D$111=\"Required\",($D137*G137),0)","v":0},null,"30-60 minutes per intersection"]
[]
["5.1.4","Dynamic Traffic Assignment",null,0,0,{"$f":"1/480","v":2.0833333333333333E-3},{"$f":"2/480","v":4.1666666666666666E-3},{"$f":"IF($D$111=\"Required\",(D139*0.5)+(D139*E139*F139),0)","v":0},{"$f":"IF($D$111=\"Required\",(D139*0.5)+(D139*E139*G139),0)","v":0},null,"4 hours + 1-2 minutes per iteration"]
[{"$f":"SUM(D121:D128)","v":0},{"$f":"IF((A140=0),\"\",\"Recommended Iterations = \"&IF((A140<9),25,IF((A140<16),50,IF((A140<31),100,\"> 100\"))))","v":""},null,0,null,{"$f":"10/480","v":2.0833333333333332E-2},{"$f":"20/480","v":4.1666666666666664E-2},{"$f":"IF($D$111=\"Required\",D139*D140*F140,0)","v":0},{"$f":"IF($D$111=\"Required\",D139*D140*G140,0)","v":0},null,"10-20 minutes per intersection"]
[]
["5.1.5","Code Measures of Effectiveness",null,1,null,{"$f":"F87/2","v":3.125E-2},{"$f":"G87/2","v":0.125},{"$f":"IF($D$111=\"Required\",($D142*F142),0)","v":0},{"$f":"IF($D$111=\"Required\",($D142*G142),0)","v":0},null,"50% of Base Year"]
[null,"Develop Output Spreadsheet",44]
[null,"Intersections",45,0,null,6.25E-2,6.25E-2,{"$f":"IF($D$111=\"Required\",($D144*F144),0)","v":0},0,null,"30 minutes per intersection"]
[null,"Freeway Segments",null,0,null,{"$f":"20/480","v":4.1666666666666664E-2},{"$f":"20/480","v":4.1666666666666664E-2},0,0,null,"20 minutes per analysis point"]
[null,"Multi-lane Segments",null,0,null,{"$f":"20/480","v":4.1666666666666664E-2},4.1666666666666664E-2,0,0,null,"20 minutes per analysis point"]
[null,"Two-Lane Segments",null,0,null,4.1666666666666664E-2,4.1666666666666664E-2,0,0,null,"20 minutes per analysis point"]
[null,"Corridor Heat Maps",null,0,null,0.25,0.5,0,0,null,"2-4 hours per corridor"]
[null,"Corridor/Route MOE's (0 or 1 only)",null,0,null,{"$f":"3/8","v":0.375},{"$f":"6/8","v":0.75},0,0,null,"3-6 hours"]
[null,"(Only new intersections/analysis points not in BY Model)"]
[]
["5.1.6","Error Check/Visual Audit/Quality Control",null,1,null,0.1,0.1,{"$f":"(SUM(H115:H129,H132:H134,H136:H137,H142:H149,H139:H140))*F152","v":0},{"$f":"(SUM(I115:I129,I132:I134,I136:I137,I142:I149,I139:I140))*G152","v":0},null,"10% of model development time"]
[]
["5.1.7","Run Model/Extract Outputs - Setup Run Controls/Run Simulation",null,1,null,0.25,0.75,{"$f":"IF($D$111=\"Required\",($D154*F154),0)","v":0},{"$f":"IF($D$111=\"Required\",($D154*G154),0)","v":0},null,"2-6 hours per model"]
[]
[]
["5.1.8","Multi-hour Simulation Adjustment",null,0,null,{"$f":"IF((D157=0),0,IF((D157<2.1),0,IF((D157<5),0.1,IF((D157<7),0.15,IF((D157>6),0.2,0)))))","v":0},{"$f":"IF((D157=0),0,IF((D157<2.1),0,IF((D157<5),0.2,IF((D157<7),0.25,IF((D157>6),0.3,0)))))","v":0},{"$f":"IF($D$111=\"Required\",(SUM(H115:H154))*F157,0)","v":0},{"$f":"IF($D$111=\"Required\",(SUM(I115:J154))*G157,0)","v":0},null,"10-30% of sections 4.1.1 through 4.1.9"]
[]
[]
[6,"204X Build Analysis",null,"Not Required"]
[]
[6.1,"Model Development"]
["6.1.1","Develop Future Year Build Model (Add totals for all alternatives and enter below)"]
[null,"Freeway Coding",28,0,null,0.15625,0.1875,{"$f":"IF($D$160=\"Required\",($D164*F164),0)","v":0},{"$f":"IF($D$160=\"Required\",($D164*G164),0)","v":0},null,"75-90 minutes per mile"]
[null,"Arterial/Collector/Local Coding",29,0,null,0.1875,0.25,0,0,null,"90-120 minutes per mile"]
[null,"System Interchange (Standard)",31,0,null,0.5,0.75,0,0,null,"4-6 hours per interchange"]
[null,"System Interchange (Complex)",31,0,null,1.5,2,0,0,null,"12-16 hours per interchange"]
[null,"Service Interchange (Standard)*",33,0,null,0.375,0.5,0,0,null,"3-4 hours per interchange"]
[null,"Service Interchange (DDI)*",34,0,null,0.5,1,0,0,null,"4-8 hours per interchange"]
[null,"Unsignalized Intersection",35,0,null,4.1669999999999999E-2,8.3330000000000001E-2,0,0,null,"20-40 minutes per intersection"]
[null,"Unsignalized  Superstreet (includes main intersection and 2 u-turns)",null,0,null,0.25,0.5,0,0,null,"2-4 hours per intersection"]
[null,"Single Lane Roundabout",null,0,null,0.125,0.1875,0,0,null,"60-90 minutes per intersection"]
[null,"Dual Lane Roundabout",null,0,null,0.25,0.375,0,0,null,"2-3 hours per intersection"]
[null,"Signalized Intersection (Simple)",36,0,null,0.1875,0.41670000000000001,0,0,null,"120-200 minutes per intersection"]
[null,"Signalized Intersection (Complex)",38,0,null,0.3125,0.5,0,0,null,"180-240 minutes per intersection"]
[null,"Signalized Intersection (Unconventional)",39,0,null,0.5,0.75,0,0,null,"4-6 hours per intersection"]
[null,"Signalized Intersection (Superstreet) (includes main intersection and 2 u-turns",40,0,null,0.5,1,0,0,null,"4-8 hours per intersection"]
[null,"Adding Z-Elevations ",null,0,null,0.25,0.75,0,0,null,"Depending on size of model and number of bridges that require hand manipulating elevations"]
[]
["6.1.2","Adding Volume Data to Model "]
[null,"Add Peak Hour Volumes",null,0,null,1.042E-2,2.0830000000000001E-2,{"$f":"IF($D$160=\"Required\",($D181*F181*2),0)","v":0},{"$f":"IF($D$160=\"Required\",($D181*G181*2),0)","v":0},null,"5-10 minutes per intersection to add volumes to intersection in TransModeler - multiplied by 2 for AM and PM Peaks"]
[]
[null,"Add vehicle composition data or heavy vehicle data",null,0,null,{"$f":"F79/2","v":0.125},{"$f":"G79/2","v":0.25},{"$f":"IF($D$160=\"Required\",($D183*F183),0)","v":0},{"$f":"IF($D$160=\"Required\",($D183*G183),0)","v":0},null,"50% of Base Year"]
[]
["6.1.3","Optimize Signalized Intersections",null,0,0,{"$f":"90/480","v":0.1875},0.25,{"$f":"IF($D$160=\"Required\",(($D185*F185)+(0.0313*E185)),0)","v":0},{"$f":"IF($D$160=\"Required\",(($D185*G185)+(0.0625*E185)),0)","v":0},null,"90-120 minutes per corridor + 15-30 minutes per signal"]
[null,null,null,0,null,6.25E-2,0.125,{"$f":"IF($D$160=\"Required\",($D186*F186),0)","v":0},{"$f":"IF($D$160=\"Required\",($D186*G186),0)","v":0},null,"30-60 minutes per intersection"]
[]
["6.1.4","Dynamic Traffic Assignment",null,0,0,{"$f":"1/480","v":2.0833333333333333E-3},{"$f":"2/480","v":4.1666666666666666E-3},{"$f":"IF($D$160=\"Required\",(D188*0.5)+(D188*E188*F188),0)","v":0},{"$f":"IF($D$160=\"Required\",(D188*0.5)+(D188*E188*G188),0)","v":0},null,"4 hours + 1-2 minutes per iteration"]
[{"$f":"SUM(D170:D177)","v":0},{"$f":"IF((A189=0),\"\",\"Recommended Iterations = \"&IF((A189<9),25,IF((A189<16),50,IF((A189<31),100,\"> 100\"))))","v":""},null,0,null,{"$f":"10/480","v":2.0833333333333332E-2},{"$f":"20/480","v":4.1666666666666664E-2},{"$f":"IF($D$160=\"Required\",D188*D189*F189,0)","v":0},{"$f":"IF($D$160=\"Required\",D188*D189*G189,0)","v":0},null,"10-20 minutes per intersection"]
[]
["6.1.5","Code Measures of Effectiveness",null,0,null,6.25E-2,0.125,{"$f":"IF($D$160=\"Required\",($D191*F191),0)","v":0},{"$f":"IF($D$160=\"Required\",($D191*G191),0)","v":0},null,"30-60 minutes per model"]
[null,"Develop Output Spreadsheet",44]
[null,"Intersections",45,0,null,6.25E-2,6.25E-2,{"$f":"IF($D$160=\"Required\",($D193*F193),0)","v":0},0,null,"30 minutes per intersection"]
[null,"Freeway Segments",null,0,null,{"$f":"20/480","v":4.1666666666666664E-2},{"$f":"20/480","v":4.1666666666666664E-2},0,0,null,"20 minutes per analysis point"]
[null,"Multi-lane Segments",null,0,null,{"$f":"20/480","v":4.1666666666666664E-2},4.1666666666666664E-2,0,0,null,"20 minutes per analysis point"]
[null,"Two-Lane Segments",null,0,null,4.1666666666666664E-2,4.1666666666666664E-2,0,0,null,"20 minutes per analysis point"]
[null,"Corridor Heat Maps",null,0,null,0.25,0.5,0,0,null,"2-4 hours per corridor"]
[null,"Corridor/Route MOE's (0 or 1 only)",null,0,null,{"$f":"3/8","v":0.375},{"$f":"6/8","v":0.75},0,0,null,"3-6 hours"]
[null,"(Only new intersections/analysis points not in BY or FYNB Model)"]
[]
["6.1.6","Error Check/Visual Audit/Quality Control",null,1,null,0.1,0.15,{"$f":"(SUM(H164:H178,H181:H181,H185:H186,H191:H198,H188:H189,H183))*F201","v":0},{"$f":"(SUM(I164:I178,I181:I181,I185:I186,I191:I198,I188:I189,I183))*G201","v":0},null,"10-15% of model development time"]
[]
["6.1.7","Run Model/Extract Outputs - Setup Run Controls/Run Simulation",null,1,null,0.25,0.75,{"$f":"IF($D$160=\"Required\",($D203*F203),0)","v":0},{"$f":"IF($D$160=\"Required\",($D203*G203),0)","v":0},null,"2-6 hours per model for each scenario"]
[]
[]
["6.1.8","Multi-hour Simulation Adjustment",null,0,null,{"$f":"IF((D206=0),0,IF((D206<2.1),0,IF((D206<5),0.1,IF((D206<7),0.15,IF((D206>6),0.2,0)))))","v":0},{"$f":"IF((D206=0),0,IF((D206<2.1),0,IF((D206<5),0.2,IF((D206<7),0.25,IF((D206>6),0.3,0)))))","v":0},{"$f":"IF($D$160=\"Required\",(SUM(H164:H203))*F206,0)","v":0},{"$f":"IF($D$160=\"Required\",(SUM(I164:J203))*G206,0)","v":0},null,"10-30% of sections 4.1.1 through 4.1.9"]
[]
["6.1.9","Design Iterations (Determine Based on Complexity and Level of Design)",null,0,null,null,null,{"$f":"D208","v":0},{"$f":"D208","v":0}]
[]
[]
[7,"201X Build Analysis",null,"Not Required"]
[7.1,"Model Development"]
[]
["7.1.1","Adding Volume Data to Model "]
[null,"Add Peak Hour Volumes",null,0,null,1.042E-2,2.0830000000000001E-2,{"$f":"IF($D$211=\"Required\",($D215*F215*2),0)","v":0},{"$f":"IF($D$211=\"Required\",($D215*G215*2),0)","v":0},null,"5-10 minutes per intersection to add volumes to intersection in TransModeler - multiplied by 2 for AM and PM Peaks"]
[]
["7.1.2","Optimize Signalized Intersections",null,0,0,{"$f":"90/480","v":0.1875},0.25,{"$f":"IF($D$211=\"Required\",(($D217*F217)+(0.0313*E217)),0)","v":0},{"$f":"IF($D$211=\"Required\",(($D217*G217)+(0.0625*E217)),0)","v":0},null,"90-120 minutes per corridor + 15-30 minutes per signal"]
[null,null,null,0,null,6.25E-2,0.125,{"$f":"IF($D$211=\"Required\",($D218*F218),0)","v":0},{"$f":"IF($D$211=\"Required\",($D218*G218),0)","v":0},null,"30-60 minutes per intersection"]
[]
["7.1.3","Dynamic Traffic Assignment",null,0,0,{"$f":"1/480","v":2.0833333333333333E-3},{"$f":"2/480","v":4.1666666666666666E-3},{"$f":"IF($D$211=\"Required\",(D220*0.5)+(D220*E220*F220),0)","v":0},{"$f":"IF($D$211=\"Required\",(D220*0.5)+(D220*E220*G220),0)","v":0},null,"4 hours + 1-2 minutes per iteration"]
[{"$f":"A189","v":0},{"$f":"IF((A221=0),\"\",\"Recommended Iterations = \"&IF((A221<9),25,IF((A221<16),50,IF((A221<31),100,\"> 100\"))))","v":""},null,0,null,{"$f":"10/480","v":2.0833333333333332E-2},{"$f":"20/480","v":4.1666666666666664E-2},{"$f":"IF($D$211=\"Required\",D220*D221*F221,0)","v":0},{"$f":"IF($D$211=\"Required\",D220*D221*G221,0)","v":0},null,"10-20 minutes per intersection"]
[]
["7.1.4","Run Model/Extract Outputs - Setup Run Controls/Run Simulation",null,1,null,0.25,0.75,{"$f":"IF($D$211=\"Required\",($D223*F223),0)","v":0},{"$f":"IF($D$211=\"Required\",($D223*G223),0)","v":0},null,"2-6 hours per model"]
[]
[]
[]
[8,"Documentation"]
[8.1,"Traffic Operations Analysis Technical Memorandum"]
[null,"Exec Summary, Background, Methodology, Conclusions, etc.",null,{"$f":"IF((SUM(D230:D234)>0),1,0)","v":0},null,0.375,1,{"$f":"D229*F229","v":0},{"$f":"G229*D229","v":0},null,"3-8 hours to develop text and supporting data"]
[null,{"$f":"B25","v":"Traffic Volume Development "},null,{"$f":"IF(($D$25=\"Required\"),1,0)","v":0},null,0.375,1,0,0,null,"3-8 hours to document procedure for volume development and add OD matrices to Appendix"]
[null,{"$f":"B51","v":"201X Base Year Model"},null,{"$f":"IF(($D$51=\"Required\"),1,0)","v":0},null,0.5,2,0,0,null,"4-16 hours to document base year analysis and develop supporting figures"]
[null,{"$f":"B111","v":"204X No-Build Analysis"},null,{"$f":"IF(($D$111=\"Required\"),1,0)","v":0},null,0.5,1.5,0,0,null,"4-12 hours to document future year no-build analysis and develop supporting figures"]
[null,{"$f":"B160","v":"204X Build Analysis"},null,{"$f":"IF(($D$160=\"Required\"),D203,0)","v":0},null,0.5,1.5,0,0,null,"4-12 hours per alternative to document future year build analysis and develop supporting figures"]
[null,{"$f":"B211","v":"201X Build Analysis"},null,{"$f":"IF(($D$211=\"Required\"),1,0)","v":0},null,0.375,0.75,{"$f":"D234*F234","v":0},{"$f":"G234*D234","v":0},null,"3-6 hours to document base year build analysis and develop supporting figures"]
[]
[8.1999999999999993,"Interchange Access Report",null,0,null,1.5,4,{"$f":"D236*F236","v":0},{"$f":"G236*D236","v":0},null,"12-32 hours to develop Policy Point discussion and coordinate w/ NCDOT/FHWA"]
[]
[11,"Additional Scope Items"]
[null,"Insert Additional Scope Items TOTAL Mandays Here:",null,0,null,null,null,{"$f":"D239","v":0},{"$f":"D239","v":0},null,"Insert Number of Mandays Here for inclusion in calculation of project management time"]

{"sheet":"Sheet1","index":1,"n_rows":103,"n_cols":86,"rows_kept":103,"cut":false,"hidden":true,"merged":[]}
["Run Macro with cell A2 selected"]
[1,"Insert Project Description","Insert County Name","Insert STIP No.","Insert WBS No.","Insert Private Engineering Firm Name","Month 2016-Month 2016","Insert Initial Development Date.","Insert Finalized Date","insert Contract Type/Mechanism.","insert PEF Name","insert Task Order #","insert #","Insert Project/Study Overview","Insert #","Insert other units/agencies","insert #","insert #","insert #","insert #","insert # ","insert #","insert # ","insert #","insert #","Insert #","##","##","##","##","##","##","##","##","##","##","##","##","##","insert #","insert #","insert #","insert #","insert #","##","##","##","##","##","##","##","##","##","##","##","##","##","insert #","insert #","insert #","insert #","insert #","##","##","##","##","##","##","##","##","##","##","##","##","##","insert #","insert #","insert #","insert #","insert #","insert #","insert #","insert #","insert #","insert #","##"]
[]
[1,{"$f":"A2","v":1}]
[2,{"$f":"B2","v":"Insert Project Description"}]
[3,{"$f":"C2","v":"Insert County Name"}]
[4,{"$f":"D2","v":"Insert STIP No."}]
[5,{"$f":"E2","v":"Insert WBS No."}]
[6,{"$f":"F2","v":"Insert Private Engineering Firm Name"}]
[7,{"$f":"G2","v":"Month 2016-Month 2016"}]
[8,{"$f":"H2","v":"Insert Initial Development Date."}]
[9,{"$f":"I2","v":"Insert Finalized Date"}]
[10,{"$f":"J2","v":"insert Contract Type/Mechanism."}]
[11,{"$f":"K2","v":"insert PEF Name"}]
[12,{"$f":"L2","v":"insert Task Order #"}]
[13,{"$f":"M2","v":"insert #"}]
[14,{"$f":"N2","v":"Insert Project/Study Overview"}]
[15,{"$f":"O2","v":"Insert #"}]
[16,{"$f":"P2","v":"Insert other units/agencies"}]
[17,{"$f":"Q2","v":"insert #"}]
[18,{"$f":"R2","v":"insert #"}]
[19,{"$f":"S2","v":"insert #"}]
[20,{"$f":"T2","v":"insert #"}]
[21,{"$f":"U2","v":"insert # "}]
[22,{"$f":"V2","v":"insert #"}]
[23,{"$f":"W2","v":"insert # "}]
[24,{"$f":"X2","v":"insert #"}]
[25,{"$f":"Y2","v":"insert #"}]
[26,{"$f":"Z2","v":"Insert #"}]
[27,{"$f":"AA2","v":"##"}]
[28,{"$f":"AB2","v":"##"}]
[29,{"$f":"AC2","v":"##"}]
[30,{"$f":"AD2","v":"##"}]
[31,{"$f":"AE2","v":"##"}]
[32,{"$f":"AF2","v":"##"}]
[33,{"$f":"AG2","v":"##"}]
[34,{"$f":"AH2","v":"##"}]
[35,{"$f":"AI2","v":"##"}]
[36,{"$f":"AJ2","v":"##"}]
[37,{"$f":"AK2","v":"##"}]
[38,{"$f":"AL2","v":"##"}]
[39,{"$f":"AM2","v":"##"}]
[40,{"$f":"AN2","v":"insert #"}]
[41,{"$f":"AO2","v":"insert #"}]
[42,{"$f":"AP2","v":"insert #"}]
[43,{"$f":"AQ2","v":"insert #"}]
[44,{"$f":"AR2","v":"insert #"}]
[45,{"$f":"AS2","v":"##"}]
[46,{"$f":"AT2","v":"##"}]
[47,{"$f":"AU2","v":"##"}]
[48,{"$f":"AV2","v":"##"}]
[49,{"$f":"AW2","v":"##"}]
[50,{"$f":"AX2","v":"##"}]
[51,{"$f":"AY2","v":"##"}]
[52,{"$f":"AZ2","v":"##"}]
[53,{"$f":"BA2","v":"##"}]
[54,{"$f":"BB2","v":"##"}]
[55,{"$f":"BC2","v":"##"}]
[56,{"$f":"BD2","v":"##"}]
[57,{"$f":"BE2","v":"##"}]
[58,{"$f":"BF2","v":"insert #"}]
[59,{"$f":"BG2","v":"insert #"}]
[60,{"$f":"BH2","v":"insert #"}]
[61,{"$f":"BI2","v":"insert #"}]
[62,{"$f":"BJ2","v":"insert #"}]
[63,{"$f":"BK2","v":"##"}]
[64,{"$f":"BL2","v":"##"}]
[65,{"$f":"BM2","v":"##"}]
[66,{"$f":"BN2","v":"##"}]
[67,{"$f":"BO2","v":"##"}]
[68,{"$f":"BP2","v":"##"}]
[69,{"$f":"BQ2","v":"##"}]
[70,{"$f":"BR2","v":"##"}]
[71,{"$f":"BS2","v":"##"}]
[72,{"$f":"BT2","v":"##"}]
[73,{"$f":"BU2","v":"##"}]
[74,{"$f":"BV2","v":"##"}]
[75,{"$f":"BW2","v":"##"}]
[76,{"$f":"BX2","v":"insert #"}]
[77,{"$f":"BY2","v":"insert #"}]
[78,{"$f":"BZ2","v":"insert #"}]
[79,{"$f":"CA2","v":"insert #"}]
[80,{"$f":"CB2","v":"insert #"}]
[81,{"$f":"CC2","v":"insert #"}]
[82,{"$f":"CD2","v":"insert #"}]
[83,{"$f":"CE2","v":"insert #"}]
[84,{"$f":"CF2","v":"insert #"}]
[85,{"$f":"CG2","v":"insert #"}]
[86,{"$f":"CH2","v":"##"}]
[87]
[88]
[89]
[90]
[91]
[92]
[93]
[94]
[95]
[96]
[97]
[98]
[99]
[100]

{"sheet":"Estimate","index":2,"n_rows":196,"n_cols":18,"rows_kept":196,"cut":false,"hidden":false,"merged":[[126,2,127,4],[126,5,127,5],[143,2,144,2],[143,3,147,3],[143,4,147,4],[143,5,147,5],[143,6,147,6],[143,7,147,7],[143,8,147,8],[123,1,124,1],[123,3,124,4],[107,12,107,13],[101,12,101,13],[102,12,102,13],[103,12,103,13],[104,12,104,13],[105,12,105,13],[106,12,106,13],[95,12,95,13],[96,12,96,13],[97,12,97,13],[98,12,98,13],[99,12,99,13],[100,12,100,13],[90,12,90,13],[91,12,91,13],[92,12,92,13],[93,12,93,13],[94,12,94,13],[84,12,84,13],[85,12,85,13],[86,12,86,13],[87,12,87,13],[88,12,88,13],[89,12,89,13],[78,12,78,13],[79,12,79,13],[80,12,80,13],[81,12,81,13],[82,12,82,13],[83,12,83,13],[72,12,72,13],[73,12,73,13],[74,12,74,13],[75,12,75,13],[76,12,76,13],[77,12,77,13],[66,12,66,13],[67,12,67,13],[68,12,68,13],[69,12,69,13],[70,12,70,13],[71,12,71,13],[59,12,59,13],[61,12,61,13],[62,12,62,13],[63,12,63,13],[64,12,64,13],[65,12,65,13],[53,12,53,13],[54,12,54,13],[55,12,55,13],[56,12,56,13],[57,12,57,13],[58,12,58,13],[49,12,49,13],[50,12,50,13],[51,12,51,13],[52,12,52,13],[40,12,40,13],[42,12,42,13],[43,12,43,13],[45,12,45,13],[46,12,46,13],[44,12,44,13],[47,12,47,13],[48,12,48,13],[41,12,41,13],[13,12,13,13],[14,12,14,13],[15,12,15,13],[28,12,28,13],[29,12,29,13],[30,12,30,13],[31,12,31,13],[32,12,32,13],[33,12,33,13],[22,12,22,13],[23,12,23,13],[24,12,24,13],[25,12,25,13],[26,12,26,13],[27,12,27,13],[34,12,34,13],[35,12,35,13],[36,12,36,13],[37,12,37,13],[38,12,38,13],[39,12,39,13],[16,12,16,13],[17,12,17,13],[18,12,18,13],[19,12,19,13],[20,12,20,13],[21,12,21,13],[0,0,1,13],[2,1,2,4],[2,6,2,7],[2,9,2,10],[2,11,3,13],[9,12,9,13],[6,3,10,3],[6,4,10,4],[6,5,10,5],[6,6,10,6],[6,7,10,7],[6,8,10,8],[3,1,3,4],[3,6,3,7],[5,2,6,2],[3,9,3,10],[4,3,4,8],[11,12,11,13],[12,12,12,13]]}
["CONGESTION MANAGEMENT DESIGN BREAKDOWN WORKSHEET"]
[]
["PROJECT DESCRIPTION: ",null,null,null,null,"FIRM:  ","NCDOT In-House",null,"TIP NUMBER:",null,null,{"$f":"IF(SUM($D$110:$I$110)=0,\"Fill-in Rates First\",\"\")","v":"Fill-in Rates First"}]
["PREPARED BY:  ",null,null,null,null,"Task Order No.",null,null,"WBS NUMBER:"]
[null,null,null,"ESTIMATED MAN DAYS"]
[null,null,"NCDOT Percent by Classification",{"$f":"IF(SUM($D$110:$I$110)=0,\"Fill-in Rates\",D196)","v":"Fill-in Rates"},{"$f":"IF(SUM($D$110:$I$110)=0,\"Fill-in Rates\",E196)","v":"Fill-in Rates"},"Fill-in Rates","Fill-in Rates","Fill-in Rates","Fill-in Rates"]
[null,null,null,"Traffic Unit Head (TM-1)","Project Engineer Sup. (TES-3)","Project Engineer Sup. (TES-2)","Project Engineer (TE-3)","Project Engineer (TE-2)","Project Engineer (TE-1)"]
[null,null,null,null,null,null,null,null,null,"SUB-","%","PEF"]
[null,null,null,null,null,null,null,null,null,"TOTAL","OF","ESTIMATE"]
["TASK","TASK DESCRIPTION",null,null,null,null,null,null,null,null,"PROJECT",null,"COMMENTS"]
["NO.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Low","High"]
[1,"Project Management, Coordination and Administration"]
[1.1000000000000001,"Project Management and Administration",null,{"$f":"IF($E$6=0,IFERROR((MROUND((Estimate!R13-E13-F13-G13-H13-I13),0.125)),0),MROUND((Estimate!R13*$D$6),0.125))","v":{"$error":"#VALUE!"}},{"$f":"IF($E$6>0,IFERROR((MROUND((Estimate!R13-D13-F13-G13-H13-I13),0.125)),0),0)","v":0},{"$f":"MROUND((Estimate!R13*$F$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R13*$G$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R13*$H$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R13*$I$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"SUM(D13:I13)","v":{"$error":"#VALUE!"}},{"$f":"J13/$J$109","v":{"$error":"#VALUE!"}},null,null,null,null,{"$f":"MIN('Scope Inputs'!H8:H9)","v":0},{"$f":"MIN('Scope Inputs'!I8:I9)","v":0},{"$f":"P13+(('Scope Inputs'!$D$5/10)*(Q13-P13))","v":0}]
[1.2,"Project Coordination",null,{"$f":"IF($E$6=0,IFERROR((MROUND((Estimate!R14-E14-F14-G14-H14-I14),0.125)),0),MROUND((Estimate!R14*$D$6),0.125))","v":{"$error":"#VALUE!"}},{"$f":"IF($E$6>0,IFERROR((MROUND((Estimate!R14-D14-F14-G14-H14-I14),0.125)),0),0)","v":0},{"$f":"MROUND((Estimate!R14*$F$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R14*$G$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R14*$H$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R14*$I$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"SUM(D14:I14)","v":{"$error":"#VALUE!"}},{"$f":"J14/$J$109","v":{"$error":"#VALUE!"}},null,null,null,null,{"$f":"MIN('Scope Inputs'!H10:H11)+'Scope Inputs'!H12+'Scope Inputs'!H13","v":0},{"$f":"MIN('Scope Inputs'!I10:I11)+'Scope Inputs'!I12+'Scope Inputs'!I13","v":0},{"$f":"P14+(('Scope Inputs'!$D$5/10)*(Q14-P14))","v":0}]
[1.3,"Consultant Coordination",null,{"$f":"IF($E$6=0,IFERROR((MROUND((Estimate!R15-E15-F15-G15-H15-I15),0.125)),0),MROUND((Estimate!R15*$D$6),0.125))","v":{"$error":"#VALUE!"}},{"$f":"IF($E$6>0,IFERROR((MROUND((Estimate!R15-D15-F15-G15-H15-I15),0.125)),0),0)","v":0},{"$f":"MROUND((Estimate!R15*$F$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R15*$G$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R15*$H$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R15*$I$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"SUM(D15:I15)","v":{"$error":"#VALUE!"}},{"$f":"J15/$J$109","v":{"$error":"#VALUE!"}},null,null,null,null,{"$f":"MIN('Scope Inputs'!H14:H15)","v":0},{"$f":"MIN('Scope Inputs'!I14:I15)","v":0},{"$f":"P15+(('Scope Inputs'!$D$5/10)*(Q15-P15))","v":0}]
[2,"Data Collection and Field Visit"]
[2.1,"Data Collection ",null,{"$f":"IF($E$6=0,IFERROR((MROUND((Estimate!R17-E17-F17-G17-H17-I17),0.125)),0),MROUND((Estimate!R17*$D$6),0.125))","v":{"$error":"#VALUE!"}},{"$f":"IF($E$6>0,IFERROR((MROUND((Estimate!R17-D17-F17-G17-H17-I17),0.125)),0),0)","v":0},{"$f":"MROUND((Estimate!R17*$F$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R17*$G$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R17*$H$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R17*$I$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"SUM(D17:I17)","v":{"$error":"#VALUE!"}},{"$f":"J17/$J$109","v":{"$error":"#VALUE!"}},null,null,null,null,{"$f":"'Scope Inputs'!H18","v":0},{"$f":"'Scope Inputs'!I18","v":0},{"$f":"P17+(('Scope Inputs'!$D$5/10)*(Q17-P17))","v":0}]
[2.2000000000000002,"Field Visit",null,{"$f":"IF($E$6=0,IFERROR((MROUND((Estimate!R18-E18-F18-G18-H18-I18),0.125)),0),MROUND((Estimate!R18*$D$6),0.125))","v":{"$error":"#VALUE!"}},{"$f":"IF($E$6>0,IFERROR((MROUND((Estimate!R18-D18-F18-G18-H18-I18),0.125)),0),0)","v":0},{"$f":"MROUND((Estimate!R18*$F$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R18*$G$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R18*$H$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R18*$I$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"SUM(D18:I18)","v":{"$error":"#VALUE!"}},{"$f":"J18/$J$109","v":{"$error":"#VALUE!"}},null,null,null,null,{"$f":"'Scope Inputs'!H21+'Scope Inputs'!H22+'Scope Inputs'!H23","v":0},{"$f":"'Scope Inputs'!I21+'Scope Inputs'!I22+'Scope Inputs'!I23","v":0},{"$f":"P18+(('Scope Inputs'!$D$5/10)*(Q18-P18))","v":0}]
[3,"Traffic Volume Development "]
[3.1,"Convert Forecast to Peak Hour Volumes",null,{"$f":"IF($E$6=0,IFERROR((MROUND((Estimate!R20-E20-F20-G20-H20-I20),0.125)),0),MROUND((Estimate!R20*$D$6),0.125))","v":{"$error":"#VALUE!"}},{"$f":"IF($E$6>0,IFERROR((MROUND((Estimate!R20-D20-F20-G20-H20-I20),0.125)),0),0)","v":0},{"$f":"MROUND((Estimate!R20*$F$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R20*$G$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R20*$H$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R20*$I$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"SUM(D20:I20)","v":{"$error":"#VALUE!"}},{"$f":"J20/$J$109","v":{"$error":"#VALUE!"}},null,null,null,null,{"$f":"'Scope Inputs'!H27+'Scope Inputs'!H28","v":0},{"$f":"'Scope Inputs'!I27+'Scope Inputs'!I28","v":0},{"$f":"P20+(('Scope Inputs'!$D$5/10)*(Q20-P20))","v":0}]
[3.2,"Balance Peak Hour Volumes",null,{"$f":"IF($E$6=0,IFERROR((MROUND((Estimate!R21-E21-F21-G21-H21-I21),0.125)),0),MROUND((Estimate!R21*$D$6),0.125))","v":{"$error":"#VALUE!"}},{"$f":"IF($E$6>0,IFERROR((MROUND((Estimate!R21-D21-F21-G21-H21-I21),0.125)),0),0)","v":0},{"$f":"MROUND((Estimate!R21*$F$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R21*$G$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R21*$H$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R21*$I$6),0.125)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,null,null,{"$f":"'Scope Inputs'!H29","v":0},{"$f":"'Scope Inputs'!I29","v":0},{"$f":"P21+(('Scope Inputs'!$D$5/10)*(Q21-P21))","v":0}]
[3.3,"OD Matrix Development",null,{"$f":"IF($E$6=0,IFERROR((MROUND((Estimate!R22-E22-F22-G22-H22-I22),0.125)),0),MROUND((Estimate!R22*$D$6),0.125))","v":{"$error":"#VALUE!"}},{"$f":"IF($E$6>0,IFERROR((MROUND((Estimate!R22-D22-F22-G22-H22-I22),0.125)),0),0)","v":0},{"$f":"MROUND((Estimate!R22*$F$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R22*$G$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R22*$H$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R22*$I$6),0.125)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,null,null,{"$f":"'Scope Inputs'!H32+'Scope Inputs'!H33+'Scope Inputs'!H34+'Scope Inputs'!H35+'Scope Inputs'!H36+'Scope Inputs'!H37","v":0},{"$f":"'Scope Inputs'!I32+'Scope Inputs'!I33+'Scope Inputs'!I34+'Scope Inputs'!I35+'Scope Inputs'!I36+'Scope Inputs'!I37","v":0},{"$f":"P22+(('Scope Inputs'!$D$5/10)*(Q22-P22))","v":0}]
[3.4,"Origin Destination Matrix Estimation (ODME) Development",null,{"$f":"IF($E$6=0,IFERROR((MROUND((Estimate!R23-E23-F23-G23-H23-I23),0.125)),0),MROUND((Estimate!R23*$D$6),0.125))","v":{"$error":"#VALUE!"}},{"$f":"IF($E$6>0,IFERROR((MROUND((Estimate!R23-D23-F23-G23-H23-I23),0.125)),0),0)","v":0},{"$f":"MROUND((Estimate!R23*$F$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R23*$G$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R23*$H$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R23*$I$6),0.125)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,null,null,{"$f":"'Scope Inputs'!H40","v":0},{"$f":"'Scope Inputs'!I40","v":0},{"$f":"P23+(('Scope Inputs'!$D$5/10)*(Q23-P23))","v":0}]
[3.5,"Class Based OD Matrix Development",null,{"$f":"IF($E$6=0,IFERROR((MROUND((Estimate!R24-E24-F24-G24-H24-I24),0.125)),0),MROUND((Estimate!R24*$D$6),0.125))","v":{"$error":"#VALUE!"}},{"$f":"IF($E$6>0,IFERROR((MROUND((Estimate!R24-D24-F24-G24-H24-I24),0.125)),0),0)","v":0},{"$f":"MROUND((Estimate!R24*$F$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R24*$G$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R24*$H$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R24*$I$6),0.125)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,null,null,{"$f":"'Scope Inputs'!H43","v":0},{"$f":"'Scope Inputs'!I43","v":0},{"$f":"P24+(('Scope Inputs'!$D$5/10)*(Q24-P24))","v":0}]
[3.6,"Multi-hour Simulation OD Matrix Development",null,{"$f":"IF($E$6=0,IFERROR((MROUND((Estimate!R25-E25-F25-G25-H25-I25),0.125)),0),MROUND((Estimate!R25*$D$6),0.125))","v":{"$error":"#VALUE!"}},{"$f":"IF($E$6>0,IFERROR((MROUND((Estimate!R25-D25-F25-G25-H25-I25),0.125)),0),0)","v":0},{"$f":"MROUND((Estimate!R25*$F$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R25*$G$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R25*$H$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R25*$I$6),0.125)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,null,null,{"$f":"'Scope Inputs'!H46+'Scope Inputs'!H47","v":0},{"$f":"'Scope Inputs'!I46+'Scope Inputs'!I47","v":0},{"$f":"P25+(('Scope Inputs'!$D$5/10)*(Q25-P25))","v":0}]
[3.7,"Add Origin Destination Matrices in TransModeler",null,{"$f":"IF($E$6=0,IFERROR((MROUND((Estimate!R26-E26-F26-G26-H26-I26),0.125)),0),MROUND((Estimate!R26*$D$6),0.125))","v":{"$error":"#VALUE!"}},{"$f":"IF($E$6>0,IFERROR((MROUND((Estimate!R26-D26-F26-G26-H26-I26),0.125)),0),0)","v":0},{"$f":"MROUND((Estimate!R26*$F$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R26*$G$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R26*$H$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R26*$I$6),0.125)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,null,null,{"$f":"'Scope Inputs'!H49","v":0},{"$f":"'Scope Inputs'!I49","v":0},{"$f":"P26+(('Scope Inputs'!$D$5/10)*(Q26-P26))","v":0}]
[4,"201X Base Year Model"]
[4.0999999999999996,"Model Development"]
["4.1.1","Initial Model Setup",null,{"$f":"IF($E$6=0,IFERROR((MROUND((Estimate!R29-E29-F29-G29-H29-I29),0.125)),0),MROUND((Estimate!R29*$D$6),0.125))","v":{"$error":"#VALUE!"}},{"$f":"IF($E$6>0,IFERROR((MROUND((Estimate!R29-D29-F29-G29-H29-I29),0.125)),0),0)","v":0},{"$f":"MROUND((Estimate!R29*$F$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R29*$G$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R29*$H$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R29*$I$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"SUM(D29:I29)","v":{"$error":"#VALUE!"}},{"$f":"J29/$J$109","v":{"$error":"#VALUE!"}},null,null,null,null,{"$f":"'Scope Inputs'!H56+'Scope Inputs'!H57","v":0},{"$f":"'Scope Inputs'!I56+'Scope Inputs'!I57","v":0},{"$f":"P29+(('Scope Inputs'!$D$5/10)*(Q29-P29))","v":0}]
["4.1.2","Develop Base Year Model in TransModeler",null,{"$f":"IF($E$6=0,IFERROR((MROUND((Estimate!R30-E30-F30-G30-H30-I30),0.125)),0),MROUND((Estimate!R30*$D$6),0.125))","v":{"$error":"#VALUE!"}},{"$f":"IF($E$6>0,IFERROR((MROUND((Estimate!R30-D30-F30-G30-H30-I30),0.125)),0),0)","v":0},{"$f":"MROUND((Estimate!R30*$F$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R30*$G$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R30*$H$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R30*$I$6),0.125)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,null,null,{"$f":"SUM('Scope Inputs'!H60:H74)","v":0},{"$f":"SUM('Scope Inputs'!I60:I74)","v":0},{"$f":"P30+(('Scope Inputs'!$D$5/10)*(Q30-P30))","v":0}]
["4.1.3","Adding Volume Data to Model ",null,{"$f":"IF($E$6=0,IFERROR((MROUND((Estimate!R31-E31-F31-G31-H31-I31),0.125)),0),MROUND((Estimate!R31*$D$6),0.125))","v":{"$error":"#VALUE!"}},{"$f":"IF($E$6>0,IFERROR((MROUND((Estimate!R31-D31-F31-G31-H31-I31),0.125)),0),0)","v":0},{"$f":"MROUND((Estimate!R31*$F$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R31*$G$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R31*$H$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R31*$I$6),0.125)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,null,null,{"$f":"'Scope Inputs'!H77+'Scope Inputs'!H79","v":0},{"$f":"'Scope Inputs'!I77+'Scope Inputs'!I79","v":0},{"$f":"P31+(('Scope Inputs'!$D$5/10)*(Q31-P31))","v":0}]
["4.1.4","Optimize Signalized Intersections",null,{"$f":"IF($E$6=0,IFERROR((MROUND((Estimate!R32-E32-F32-G32-H32-I32),0.125)),0),MROUND((Estimate!R32*$D$6),0.125))","v":{"$error":"#VALUE!"}},{"$f":"IF($E$6>0,IFERROR((MROUND((Estimate!R32-D32-F32-G32-H32-I32),0.125)),0),0)","v":0},{"$f":"MROUND((Estimate!R32*$F$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R32*$G$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R32*$H$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R32*$I$6),0.125)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,null,null,{"$f":"'Scope Inputs'!H81+'Scope Inputs'!H82","v":0},{"$f":"'Scope Inputs'!I81+'Scope Inputs'!I82","v":0},{"$f":"P32+(('Scope Inputs'!$D$5/10)*(Q32-P32))","v":0}]
["4.1.5","Dynamic Traffic Assignment",null,{"$f":"IF($E$6=0,IFERROR((MROUND((Estimate!R33-E33-F33-G33-H33-I33),0.125)),0),MROUND((Estimate!R33*$D$6),0.125))","v":{"$error":"#VALUE!"}},{"$f":"IF($E$6>0,IFERROR((MROUND((Estimate!R33-D33-F33-G33-H33-I33),0.125)),0),0)","v":0},{"$f":"MROUND((Estimate!R33*$F$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R33*$G$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R33*$H$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R33*$I$6),0.125)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,null,null,{"$f":"'Scope Inputs'!H84+'Scope Inputs'!H85","v":0},{"$f":"'Scope Inputs'!I84+'Scope Inputs'!I85","v":0},{"$f":"P33+(('Scope Inputs'!$D$5/10)*(Q33-P33))","v":0}]
["4.1.6","Code Measures of Effectiveness",null,{"$f":"IF($E$6=0,IFERROR((MROUND((Estimate!R34-E34-F34-G34-H34-I34),0.125)),0),MROUND((Estimate!R34*$D$6),0.125))","v":{"$error":"#VALUE!"}},{"$f":"IF($E$6>0,IFERROR((MROUND((Estimate!R34-D34-F34-G34-H34-I34),0.125)),0),0)","v":0},{"$f":"MROUND((Estimate!R34*$F$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R34*$G$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R34*$H$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R34*$I$6),0.125)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,null,null,{"$f":"SUM('Scope Inputs'!H87:H94)","v":0},{"$f":"SUM('Scope Inputs'!I87:I94)","v":0},{"$f":"P34+(('Scope Inputs'!$D$5/10)*(Q34-P34))","v":0}]
["4.1.7","Error Check/Visual Audit/Quality Control",null,{"$f":"IF($E$6=0,IFERROR((MROUND((Estimate!R35-E35-F35-G35-H35-I35),0.125)),0),MROUND((Estimate!R35*$D$6),0.125))","v":{"$error":"#VALUE!"}},{"$f":"IF($E$6>0,IFERROR((MROUND((Estimate!R35-D35-F35-G35-H35-I35),0.125)),0),0)","v":0},{"$f":"MROUND((Estimate!R35*$F$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R35*$G$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R35*$H$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R35*$I$6),0.125)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,null,null,{"$f":"'Scope Inputs'!H96","v":0},{"$f":"'Scope Inputs'!I96","v":0},{"$f":"P35+(('Scope Inputs'!$D$5/10)*(Q35-P35))","v":0}]
["4.1.8","Default Values/Visual Validation/Calibration",null,{"$f":"IF($E$6=0,IFERROR((MROUND((Estimate!R36-E36-F36-G36-H36-I36),0.125)),0),MROUND((Estimate!R36*$D$6),0.125))","v":{"$error":"#VALUE!"}},{"$f":"IF($E$6>0,IFERROR((MROUND((Estimate!R36-D36-F36-G36-H36-I36),0.125)),0),0)","v":0},{"$f":"MROUND((Estimate!R36*$F$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R36*$G$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R36*$H$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R36*$I$6),0.125)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,null,null,{"$f":"'Scope Inputs'!H100+'Scope Inputs'!H101+'Scope Inputs'!H102","v":0},{"$f":"'Scope Inputs'!I100+'Scope Inputs'!I101+'Scope Inputs'!I102","v":0},{"$f":"P36+(('Scope Inputs'!$D$5/10)*(Q36-P36))","v":0}]
["4.1.9","Run Model/Extract Outputs - Setup Run Controls/Run Simulation",null,{"$f":"IF($E$6=0,IFERROR((MROUND((Estimate!R37-E37-F37-G37-H37-I37),0.125)),0),MROUND((Estimate!R37*$D$6),0.125))","v":{"$error":"#VALUE!"}},{"$f":"IF($E$6>0,IFERROR((MROUND((Estimate!R37-D37-F37-G37-H37-I37),0.125)),0),0)","v":0},{"$f":"MROUND((Estimate!R37*$F$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R37*$G$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R37*$H$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R37*$I$6),0.125)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,null,null,{"$f":"'Scope Inputs'!H105","v":0},{"$f":"'Scope Inputs'!I105","v":0},{"$f":"P37+(('Scope Inputs'!$D$5/10)*(Q37-P37))","v":0}]
["4.1.10","Multi-hour Simulation Adjustment",null,{"$f":"IF($E$6=0,IFERROR((MROUND((Estimate!R38-E38-F38-G38-H38-I38),0.125)),0),MROUND((Estimate!R38*$D$6),0.125))","v":{"$error":"#VALUE!"}},{"$f":"IF($E$6>0,IFERROR((MROUND((Estimate!R38-D38-F38-G38-H38-I38),0.125)),0),0)","v":0},{"$f":"MROUND((Estimate!R38*$F$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R38*$G$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R38*$H$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R38*$I$6),0.125)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,null,null,{"$f":"'Scope Inputs'!H108","v":0},{"$f":"'Scope Inputs'!I108","v":0},{"$f":"P38+(('Scope Inputs'!$D$5/10)*(Q38-P38))","v":0}]
[5,"204X No-Build Analysis"]
[5.0999999999999996,"Model Development"]
["5.1.1","Develop Future Year No-Build Model",null,{"$f":"IF($E$6=0,IFERROR((MROUND((Estimate!R41-E41-F41-G41-H41-I41),0.125)),0),MROUND((Estimate!R41*$D$6),0.125))","v":{"$error":"#VALUE!"}},{"$f":"IF($E$6>0,IFERROR((MROUND((Estimate!R41-D41-F41-G41-H41-I41),0.125)),0),0)","v":0},{"$f":"MROUND((Estimate!R41*$F$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R41*$G$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R41*$H$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R41*$I$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"SUM(D41:I41)","v":{"$error":"#VALUE!"}},{"$f":"J41/$J$109","v":{"$error":"#VALUE!"}},null,null,null,null,{"$f":"SUM('Scope Inputs'!H115:H129)","v":0},{"$f":"SUM('Scope Inputs'!I115:I129)","v":0},{"$f":"P41+(('Scope Inputs'!$D$5/10)*(Q41-P41))","v":0}]
["5.1.2","Adding Volume Data to Model",null,{"$f":"IF($E$6=0,IFERROR((MROUND((Estimate!R42-E42-F42-G42-H42-I42),0.125)),0),MROUND((Estimate!R42*$D$6),0.125))","v":{"$error":"#VALUE!"}},{"$f":"IF($E$6>0,IFERROR((MROUND((Estimate!R42-D42-F42-G42-H42-I42),0.125)),0),0)","v":0},{"$f":"MROUND((Estimate!R42*$F$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R42*$G$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R42*$H$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R42*$I$6),0.125)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,null,null,{"$f":"'Scope Inputs'!H132+'Scope Inputs'!H134","v":0},{"$f":"'Scope Inputs'!I132+'Scope Inputs'!I134","v":0},{"$f":"P42+(('Scope Inputs'!$D$5/10)*(Q42-P42))","v":0}]
["5.1.3","Optimize Signalized Intersections",null,{"$f":"IF($E$6=0,IFERROR((MROUND((Estimate!R43-E43-F43-G43-H43-I43),0.125)),0),MROUND((Estimate!R43*$D$6),0.125))","v":{"$error":"#VALUE!"}},{"$f":"IF($E$6>0,IFERROR((MROUND((Estimate!R43-D43-F43-G43-H43-I43),0.125)),0),0)","v":0},{"$f":"MROUND((Estimate!R43*$F$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R43*$G$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R43*$H$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R43*$I$6),0.125)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,null,null,{"$f":"'Scope Inputs'!H136+'Scope Inputs'!H137","v":0},{"$f":"'Scope Inputs'!I136+'Scope Inputs'!I137","v":0},{"$f":"P43+(('Scope Inputs'!$D$5/10)*(Q43-P43))","v":0}]
["5.1.4","Dynamic Traffic Assignment",null,{"$f":"IF($E$6=0,IFERROR((MROUND((Estimate!R44-E44-F44-G44-H44-I44),0.125)),0),MROUND((Estimate!R44*$D$6),0.125))","v":{"$error":"#VALUE!"}},{"$f":"IF($E$6>0,IFERROR((MROUND((Estimate!R44-D44-F44-G44-H44-I44),0.125)),0),0)","v":0},{"$f":"MROUND((Estimate!R44*$F$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R44*$G$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R44*$H$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R44*$I$6),0.125)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,null,null,{"$f":"'Scope Inputs'!H139+'Scope Inputs'!H140","v":0},{"$f":"'Scope Inputs'!I139+'Scope Inputs'!I140","v":0},{"$f":"P44+(('Scope Inputs'!$D$5/10)*(Q44-P44))","v":0}]
["5.1.5","Code Measures of Effectiveness",null,{"$f":"IF($E$6=0,IFERROR((MROUND((Estimate!R45-E45-F45-G45-H45-I45),0.125)),0),MROUND((Estimate!R45*$D$6),0.125))","v":{"$error":"#VALUE!"}},{"$f":"IF($E$6>0,IFERROR((MROUND((Estimate!R45-D45-F45-G45-H45-I45),0.125)),0),0)","v":0},{"$f":"MROUND((Estimate!R45*$F$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R45*$G$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R45*$H$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R45*$I$6),0.125)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,null,null,{"$f":"SUM('Scope Inputs'!H142:H149)","v":0},{"$f":"SUM('Scope Inputs'!I142:I149)","v":0},{"$f":"P45+(('Scope Inputs'!$D$5/10)*(Q45-P45))","v":0}]
["5.1.6","Error Check/Visual Audit/Quality Control",null,{"$f":"IF($E$6=0,IFERROR((MROUND((Estimate!R46-E46-F46-G46-H46-I46),0.125)),0),MROUND((Estimate!R46*$D$6),0.125))","v":{"$error":"#VALUE!"}},{"$f":"IF($E$6>0,IFERROR((MROUND((Estimate!R46-D46-F46-G46-H46-I46),0.125)),0),0)","v":0},{"$f":"MROUND((Estimate!R46*$F$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R46*$G$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R46*$H$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R46*$I$6),0.125)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,null,null,{"$f":"'Scope Inputs'!H152","v":0},{"$f":"'Scope Inputs'!I152","v":0},{"$f":"P46+(('Scope Inputs'!$D$5/10)*(Q46-P46))","v":0}]
["5.1.7","Run Model/Extract Outputs - Setup Run Controls/Run Simulation",null,{"$f":"IF($E$6=0,IFERROR((MROUND((Estimate!R47-E47-F47-G47-H47-I47),0.125)),0),MROUND((Estimate!R47*$D$6),0.125))","v":{"$error":"#VALUE!"}},{"$f":"IF($E$6>0,IFERROR((MROUND((Estimate!R47-D47-F47-G47-H47-I47),0.125)),0),0)","v":0},{"$f":"MROUND((Estimate!R47*$F$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R47*$G$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R47*$H$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R47*$I$6),0.125)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,null,null,{"$f":"'Scope Inputs'!H154","v":0},{"$f":"'Scope Inputs'!I154","v":0},{"$f":"P47+(('Scope Inputs'!$D$5/10)*(Q47-P47))","v":0}]
["5.1.8","Multi-hour Simulation Adjustment",null,{"$f":"IF($E$6=0,IFERROR((MROUND((Estimate!R48-E48-F48-G48-H48-I48),0.125)),0),MROUND((Estimate!R48*$D$6),0.125))","v":{"$error":"#VALUE!"}},{"$f":"IF($E$6>0,IFERROR((MROUND((Estimate!R48-D48-F48-G48-H48-I48),0.125)),0),0)","v":0},{"$f":"MROUND((Estimate!R48*$F$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R48*$G$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R48*$H$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R48*$I$6),0.125)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,null,null,{"$f":"'Scope Inputs'!H157","v":0},{"$f":"'Scope Inputs'!I157","v":0},{"$f":"P48+(('Scope Inputs'!$D$5/10)*(Q48-P48))","v":0}]
[6,"204X Build Analysis"]
[6.1,"Model Development"]
["6.1.1","Develop Future Year Build Model ",null,{"$f":"IF($E$6=0,IFERROR((MROUND((Estimate!R51-E51-F51-G51-H51-I51),0.125)),0),MROUND((Estimate!R51*$D$6),0.125))","v":{"$error":"#VALUE!"}},{"$f":"IF($E$6>0,IFERROR((MROUND((Estimate!R51-D51-F51-G51-H51-I51),0.125)),0),0)","v":0},{"$f":"MROUND((Estimate!R51*$F$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R51*$G$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R51*$H$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R51*$I$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"SUM(D51:I51)","v":{"$error":"#VALUE!"}},{"$f":"J51/$J$109","v":{"$error":"#VALUE!"}},null,null,null,null,{"$f":"SUM('Scope Inputs'!H164:H178)","v":0},{"$f":"SUM('Scope Inputs'!I164:I178)","v":0},{"$f":"P51+(('Scope Inputs'!$D$5/10)*(Q51-P51))","v":0}]
["6.1.2","Adding Volume Data to Model ",null,{"$f":"IF($E$6=0,IFERROR((MROUND((Estimate!R52-E52-F52-G52-H52-I52),0.125)),0),MROUND((Estimate!R52*$D$6),0.125))","v":{"$error":"#VALUE!"}},{"$f":"IF($E$6>0,IFERROR((MROUND((Estimate!R52-D52-F52-G52-H52-I52),0.125)),0),0)","v":0},{"$f":"MROUND((Estimate!R52*$F$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R52*$G$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R52*$H$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R52*$I$6),0.125)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,null,null,{"$f":"'Scope Inputs'!H181+'Scope Inputs'!H183","v":0},{"$f":"'Scope Inputs'!I181+'Scope Inputs'!I183","v":0},{"$f":"P52+(('Scope Inputs'!$D$5/10)*(Q52-P52))","v":0}]
["6.1.3","Optimize Signalized Intersections",null,{"$f":"IF($E$6=0,IFERROR((MROUND((Estimate!R53-E53-F53-G53-H53-I53),0.125)),0),MROUND((Estimate!R53*$D$6),0.125))","v":{"$error":"#VALUE!"}},{"$f":"IF($E$6>0,IFERROR((MROUND((Estimate!R53-D53-F53-G53-H53-I53),0.125)),0),0)","v":0},{"$f":"MROUND((Estimate!R53*$F$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R53*$G$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R53*$H$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R53*$I$6),0.125)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,null,null,{"$f":"'Scope Inputs'!H185+'Scope Inputs'!H186","v":0},{"$f":"'Scope Inputs'!I185+'Scope Inputs'!I186","v":0},{"$f":"P53+(('Scope Inputs'!$D$5/10)*(Q53-P53))","v":0}]
["6.1.4","Dynamic Traffic Assignment",null,{"$f":"IF($E$6=0,IFERROR((MROUND((Estimate!R54-E54-F54-G54-H54-I54),0.125)),0),MROUND((Estimate!R54*$D$6),0.125))","v":{"$error":"#VALUE!"}},{"$f":"IF($E$6>0,IFERROR((MROUND((Estimate!R54-D54-F54-G54-H54-I54),0.125)),0),0)","v":0},{"$f":"MROUND((Estimate!R54*$F$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R54*$G$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R54*$H$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R54*$I$6),0.125)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,null,null,{"$f":"'Scope Inputs'!H188+'Scope Inputs'!H189","v":0},{"$f":"'Scope Inputs'!I188+'Scope Inputs'!I189","v":0},{"$f":"P54+(('Scope Inputs'!$D$5/10)*(Q54-P54))","v":0}]
["6.1.5","Code Measures of Effectiveness",null,{"$f":"IF($E$6=0,IFERROR((MROUND((Estimate!R55-E55-F55-G55-H55-I55),0.125)),0),MROUND((Estimate!R55*$D$6),0.125))","v":{"$error":"#VALUE!"}},{"$f":"IF($E$6>0,IFERROR((MROUND((Estimate!R55-D55-F55-G55-H55-I55),0.125)),0),0)","v":0},{"$f":"MROUND((Estimate!R55*$F$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R55*$G$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R55*$H$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R55*$I$6),0.125)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,null,null,{"$f":"SUM('Scope Inputs'!H191:H198)","v":0},{"$f":"SUM('Scope Inputs'!I191:I198)","v":0},{"$f":"P55+(('Scope Inputs'!$D$5/10)*(Q55-P55))","v":0}]
["6.1.6","Error Check/Visual Audit/Quality Control",null,{"$f":"IF($E$6=0,IFERROR((MROUND((Estimate!R56-E56-F56-G56-H56-I56),0.125)),0),MROUND((Estimate!R56*$D$6),0.125))","v":{"$error":"#VALUE!"}},{"$f":"IF($E$6>0,IFERROR((MROUND((Estimate!R56-D56-F56-G56-H56-I56),0.125)),0),0)","v":0},{"$f":"MROUND((Estimate!R56*$F$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R56*$G$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R56*$H$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R56*$I$6),0.125)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,null,null,{"$f":"'Scope Inputs'!H201","v":0},{"$f":"'Scope Inputs'!I201","v":0},{"$f":"P56+(('Scope Inputs'!$D$5/10)*(Q56-P56))","v":0}]
["6.1.7","Run Model/Extract Outputs - Setup Run Controls/Run Simulation",null,{"$f":"IF($E$6=0,IFERROR((MROUND((Estimate!R57-E57-F57-G57-H57-I57),0.125)),0),MROUND((Estimate!R57*$D$6),0.125))","v":{"$error":"#VALUE!"}},{"$f":"IF($E$6>0,IFERROR((MROUND((Estimate!R57-D57-F57-G57-H57-I57),0.125)),0),0)","v":0},{"$f":"MROUND((Estimate!R57*$F$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R57*$G$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R57*$H$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R57*$I$6),0.125)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,null,null,{"$f":"'Scope Inputs'!H203","v":0},{"$f":"'Scope Inputs'!I203","v":0},{"$f":"P57+(('Scope Inputs'!$D$5/10)*(Q57-P57))","v":0}]
["6.1.8","Multi-hour Simulation Adjustment",null,{"$f":"IF($E$6=0,IFERROR((MROUND((Estimate!R58-E58-F58-G58-H58-I58),0.125)),0),MROUND((Estimate!R58*$D$6),0.125))","v":{"$error":"#VALUE!"}},{"$f":"IF($E$6>0,IFERROR((MROUND((Estimate!R58-D58-F58-G58-H58-I58),0.125)),0),0)","v":0},{"$f":"MROUND((Estimate!R58*$F$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R58*$G$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R58*$H$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R58*$I$6),0.125)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,null,null,{"$f":"'Scope Inputs'!H206","v":0},{"$f":"'Scope Inputs'!I206","v":0},{"$f":"P58+(('Scope Inputs'!$D$5/10)*(Q58-P58))","v":0}]
["6.1.9","Design Iterations ",null,{"$f":"IF($E$6=0,IFERROR((MROUND((Estimate!R59-E59-F59-G59-H59-I59),0.125)),0),MROUND((Estimate!R59*$D$6),0.125))","v":{"$error":"#VALUE!"}},{"$f":"IF($E$6>0,IFERROR((MROUND((Estimate!R59-D59-F59-G59-H59-I59),0.125)),0),0)","v":0},{"$f":"MROUND((Estimate!R59*$F$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R59*$G$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R59*$H$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R59*$I$6),0.125)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,null,null,{"$f":"'Scope Inputs'!H208","v":0},{"$f":"'Scope Inputs'!I208","v":0},{"$f":"P59+(('Scope Inputs'!$D$5/10)*(Q59-P59))","v":0}]
[7,"201X Build Analysis"]
[7.1,"Model Development"]
["7.1.1","Adding Volume Data to Model ",null,{"$f":"IF($E$6=0,IFERROR((MROUND((Estimate!R62-E62-F62-G62-H62-I62),0.125)),0),MROUND((Estimate!R62*$D$6),0.125))","v":{"$error":"#VALUE!"}},{"$f":"IF($E$6>0,IFERROR((MROUND((Estimate!R62-D62-F62-G62-H62-I62),0.125)),0),0)","v":0},{"$f":"MROUND((Estimate!R62*$F$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R62*$G$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R62*$H$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R62*$I$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"SUM(D62:I62)","v":{"$error":"#VALUE!"}},{"$f":"J62/$J$109","v":{"$error":"#VALUE!"}},null,null,null,null,{"$f":"'Scope Inputs'!H215","v":0},{"$f":"'Scope Inputs'!I215","v":0},{"$f":"P62+(('Scope Inputs'!$D$5/10)*(Q62-P62))","v":0}]
["7.1.2","Optimize Signalized Intersections",null,{"$f":"IF($E$6=0,IFERROR((MROUND((Estimate!R63-E63-F63-G63-H63-I63),0.125)),0),MROUND((Estimate!R63*$D$6),0.125))","v":{"$error":"#VALUE!"}},{"$f":"IF($E$6>0,IFERROR((MROUND((Estimate!R63-D63-F63-G63-H63-I63),0.125)),0),0)","v":0},{"$f":"MROUND((Estimate!R63*$F$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R63*$G$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R63*$H$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R63*$I$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"SUM(D63:I63)","v":{"$error":"#VALUE!"}},{"$f":"J63/$J$109","v":{"$error":"#VALUE!"}},null,null,null,null,{"$f":"'Scope Inputs'!H217+'Scope Inputs'!H218","v":0},{"$f":"'Scope Inputs'!I217+'Scope Inputs'!I218","v":0},{"$f":"P63+(('Scope Inputs'!$D$5/10)*(Q63-P63))","v":0}]
["7.1.3","Dynamic Traffic Assignment",null,{"$f":"IF($E$6=0,IFERROR((MROUND((Estimate!R64-E64-F64-G64-H64-I64),0.125)),0),MROUND((Estimate!R64*$D$6),0.125))","v":{"$error":"#VALUE!"}},{"$f":"IF($E$6>0,IFERROR((MROUND((Estimate!R64-D64-F64-G64-H64-I64),0.125)),0),0)","v":0},{"$f":"MROUND((Estimate!R64*$F$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R64*$G$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R64*$H$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R64*$I$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"SUM(D64:I64)","v":{"$error":"#VALUE!"}},{"$f":"J64/$J$109","v":{"$error":"#VALUE!"}},null,null,null,null,{"$f":"'Scope Inputs'!H220+'Scope Inputs'!H221","v":0},{"$f":"'Scope Inputs'!I220+'Scope Inputs'!I221","v":0},{"$f":"P64+(('Scope Inputs'!$D$5/10)*(Q64-P64))","v":0}]
["7.1.4","Run Model/Extract Outputs - Setup Run Controls/Run Simulation",null,{"$f":"IF($E$6=0,IFERROR((MROUND((Estimate!R65-E65-F65-G65-H65-I65),0.125)),0),MROUND((Estimate!R65*$D$6),0.125))","v":{"$error":"#VALUE!"}},{"$f":"IF($E$6>0,IFERROR((MROUND((Estimate!R65-D65-F65-G65-H65-I65),0.125)),0),0)","v":0},{"$f":"MROUND((Estimate!R65*$F$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R65*$G$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R65*$H$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R65*$I$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"SUM(D65:I65)","v":{"$error":"#VALUE!"}},{"$f":"J65/$J$109","v":{"$error":"#VALUE!"}},null,null,null,null,{"$f":"'Scope Inputs'!H223","v":0},{"$f":"'Scope Inputs'!I223","v":0},{"$f":"P65+(('Scope Inputs'!$D$5/10)*(Q65-P65))","v":0}]
[8,"Documentation"]
[8.1,"Traffic Operations Analysis Technical Memorandum",null,{"$f":"IF($E$6=0,IFERROR((MROUND((Estimate!R67-E67-F67-G67-H67-I67),0.125)),0),MROUND((Estimate!R67*$D$6),0.125))","v":{"$error":"#VALUE!"}},{"$f":"IF($E$6>0,IFERROR((MROUND((Estimate!R67-D67-F67-G67-H67-I67),0.125)),0),0)","v":0},{"$f":"MROUND((Estimate!R67*$F$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R67*$G$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R67*$H$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R67*$I$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"SUM(D67:I67)","v":{"$error":"#VALUE!"}},{"$f":"J67/$J$109","v":{"$error":"#VALUE!"}},null,null,null,null,{"$f":"SUM('Scope Inputs'!H229:H234)","v":0},{"$f":"SUM('Scope Inputs'!I229:I234)","v":0},{"$f":"P67+(('Scope Inputs'!$D$5/10)*(Q67-P67))","v":0}]
[8.1999999999999993,"Interchange Access Report",null,{"$f":"IF($E$6=0,IFERROR((MROUND((Estimate!R68-E68-F68-G68-H68-I68),0.125)),0),MROUND((Estimate!R68*$D$6),0.125))","v":{"$error":"#VALUE!"}},{"$f":"IF($E$6>0,IFERROR((MROUND((Estimate!R68-D68-F68-G68-H68-I68),0.125)),0),0)","v":0},{"$f":"MROUND((Estimate!R68*$F$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R68*$G$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R68*$H$6),0.125)","v":{"$error":"#VALUE!"}},{"$f":"MROUND((Estimate!R68*$I$6),0.125)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,null,null,{"$f":"'Scope Inputs'!H236","v":0},{"$f":"'Scope Inputs'!I236","v":0},{"$f":"P68+(('Scope Inputs'!$D$5/10)*(Q68-P68))","v":0}]
[null,null,null,null,null,null,null,null,null,0,{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,0,{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,0,{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,0,{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,0,{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,0,{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,0,{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,0,{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,0,{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,0,{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,0,{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,0,{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,0,{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,0,{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,0,{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,0,{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,0,{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,0,{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,0,{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,0,{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,0,{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,0,{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,0,{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,0,{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,0,{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,0,{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,0,{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,0,{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,0,{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,0,{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,0,{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,0,{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,0,{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,0,{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,0,{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,0,{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,0,{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,0,{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,0,{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,0,{"$error":"#VALUE!"}]
[null,"TOTAL WORKDAYS/CATEGORY:",null,{"$f":"SUM(D12:D108)","v":{"$error":"#VALUE!"}},0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0]
[{"$f":"IF(SUM($D$110:$I$110)=0,\"Fill-in Rates First\",\"\")","v":"Fill-in Rates First"},"PEF HOURLY SALARY RATE:",null,0,0,0,0,0,0]
[null,null,null,{"$f":"IF(D110>0,1,0)","v":0},{"$f":"IF(E110>0,1,0)","v":0},0,0,0,0,{"$f":"1&E111&F111&G111&H111&I111","v":"100000"}]
[null,"RATES PER DAY:",null,{"$f":"D110*8","v":0},0,0,0,0,0]
[null,"PAYROLL BURDEN:",null,{"$f":"D109*D112","v":{"$error":"#VALUE!"}},0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,"TOTAL WORKDAYS:",null,{"$f":"SUM(D109:I109)","v":{"$error":"#VALUE!"}}]
[null,"TOTAL PAYROLL BURDEN:",null,{"$f":"SUM(D113:I113)","v":{"$error":"#VALUE!"}}]
[null,"AVERAGE COST PER HOUR:",null,{"$f":"SUM(D115/(D114*8))","v":{"$error":"#VALUE!"}}]
[null,"GENERAL OVERHEAD:",1,{"$f":"SUM(D115*C117)","v":{"$error":"#VALUE!"}}]
[null,"SUBTOTAL:",null,{"$f":"SUM(D115+D117)","v":{"$error":"#VALUE!"}}]
[null,"COMPARATIVE FEE:",0.09,{"$f":"SUM(D118*C119)","v":{"$error":"#VALUE!"}}]
[null,"FACILITIES COST OF CAPITAL:",0,{"$f":"SUM(D115*C120)","v":{"$error":"#VALUE!"}}]
[null,"TOTAL:",null,{"$f":"SUM(D118:D120)","v":{"$error":"#VALUE!"}}]
[null,"DIRECT EXPENSES:",null,0]
[null,"SUBCONSULTANT FEES (IF NO SEPARATE ESTIMATE):",null,0]
[null,"OTHER GRAND TOTAL:",null,{"$f":"D121+D122+D123","v":{"$error":"#VALUE!"}}]
[]
[]
[null,null,"Total Mandays*",null,null,{"$f":"D114","v":{"$error":"#VALUE!"}}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,4,"Traffic Unit Head (TM-1)","Project Engineer Sup. (TES-3)","Project Engineer Sup. (TES-2)","Project Engineer (TE-3)","Project Engineer (TE-2)","Project Engineer (TE-1)"]
[]
[]
[null,null,"Complexity"]
[null,null,"Index"]
[null,null,2,0.12,0.17,0.1,0.1,0.42,0.09]
[null,null,3,0.13,0.18,0.1,0.1,0.41,0.08]
[null,null,4,0.14000000000000001,0.19,0.1,0.1,0.39,0.08]
[null,null,5,0.15,0.2,0.125,0.125,0.33,7.0000000000000007E-2]
[null,null,6,0.16,0.21,0.125,0.125,0.31,7.0000000000000007E-2]
[null,null,7,0.17,0.22,0.125,0.125,0.3,0.06]
[null,null,8,0.18,0.23,0.15,0.15,0.23,0.06]
[null,null,9,0.19,0.24,0.15,0.15,0.22,0.05]
[null,null,10,0.2,0.25,0.15,0.15,0.2,0.05]
[]
[null,null,{"$f":"'Scope Inputs'!D5","v":2},{"$f":"VLOOKUP($C$159,$C$149:I157,2)","v":0.12},{"$f":"VLOOKUP($C$159,$C$149:J157,3)","v":0.17},{"$f":"VLOOKUP($C$159,$C$149:K157,4)","v":0.1},{"$f":"VLOOKUP($C$159,$C$149:L157,5)","v":0.1},{"$f":"VLOOKUP($C$159,$C$149:M157,6)","v":0.42},{"$f":"VLOOKUP($C$159,$C$149:N157,7)","v":0.09}]
[]
[null,null,null,{"$f":"D159","v":0.12},{"$f":"E159","v":0.17},0.1,0.1,0.42,0.09]
[null,null,100000,{"$f":"$D$161+$E$161+$F$161+$G$161+$H$161+$I$161","v":0.99999999999999989},0,0,0,0,0]
[null,null,100001,{"$f":"$D$161+$E$161+$F$161+$G$161","v":0.49},0,0,0,0,{"$f":"$H$161+$I$161","v":0.51}]
[null,null,100010,{"$f":"$D$161+$E$161+$F$161","v":0.39},0,0,0,{"$f":"$G$161+$H$161+$I$161","v":0.61},0]
[null,null,100011,{"$f":"$D$161+$E$161+$F$161","v":0.39},0,0,0,{"$f":"$G$161+($H$161*0.7)","v":0.39400000000000002},{"$f":"$I$161+($H$161*0.3)","v":0.216}]
[null,null,100100,{"$f":"$D$161+$E$161","v":0.29000000000000004},0,0,{"$f":"$F$161+$G$161+$H$161+$I$161","v":0.71},0,0]
[null,null,100101,0.29000000000000004,0,0,{"$f":"$F$161+$G$161+($H$161*0.3)","v":0.32600000000000001},0,{"$f":"($H$161*0.7)+$I$161","v":0.38400000000000001}]
[null,null,100110,0.29000000000000004,0,0,{"$f":"$G$161+$F$161","v":0.2},{"$f":"$H$161+$I$161","v":0.51},0]
[null,null,100111,0.29000000000000004,0,0,{"$f":"$F$161+$G$161","v":0.2},{"$f":"$H$161","v":0.42},{"$f":"$I$161","v":0.09}]
[null,null,101000,0.29000000000000004,0,{"$f":"$F$161+$G$161+$H$161+$I$161","v":0.71},0,0,0]
[null,null,101001,0.29000000000000004,0,{"$f":"$F$161+$G$161+($H$161*0.3)","v":0.32600000000000001},0,0,{"$f":"($H$161*0.7)+$I$161","v":0.38400000000000001}]
[null,null,101010,0.29000000000000004,0,{"$f":"$F$161+$G$161","v":0.2},0,{"$f":"$H$161+$I$161","v":0.51},0]
[null,null,101011,0.29000000000000004,0,{"$f":"$F$161+$G$161","v":0.2},0,{"$f":"$H$161","v":0.42},{"$f":"$I$161","v":0.09}]
[null,null,101100,{"$f":"$D$161","v":0.12},0,{"$f":"$E$161+$F$161+$G$161","v":0.37},{"$f":"$H$161+$I$161","v":0.51},0,0]
[null,null,101101,{"$f":"$D$161+$E$161","v":0.29000000000000004},0,{"$f":"$F$161","v":0.1},{"$f":"$G$161+($H$161*0.5)","v":0.31},0,{"$f":"$I$161+($H$161*0.5)","v":0.3}]
[null,null,101110,{"$f":"$D$161+$E$161","v":0.29000000000000004},0,{"$f":"$F$161","v":0.1},{"$f":"$G$161","v":0.1},{"$f":"$H$161+$I$161","v":0.51},0]
[null,null,101111,{"$f":"$D$161+$E$161","v":0.29000000000000004},0,{"$f":"$F$161","v":0.1},{"$f":"$G$161","v":0.1},{"$f":"$H$161","v":0.42},{"$f":"$I$161","v":0.09}]
[null,null,110000,{"$f":"$D$161","v":0.12},{"$f":"$E$161+$F$161+$G$161+$H$161+$I$161","v":0.88},0,0,0,0]
[null,null,110001,{"$f":"$D$161+$E$161","v":0.29000000000000004},{"$f":"$F$161+$G$161","v":0.2},0,0,0,{"$f":"$H$161+$I$161","v":0.51}]
[null,null,110010,{"$f":"$D$161+$E$161","v":0.29000000000000004},{"$f":"$F$161+$G$161","v":0.2},0,0,{"$f":"$H$161+$I$161","v":0.51},0]
[null,null,110011,{"$f":"$D$161","v":0.12},{"$f":"$E$161+$F$161","v":0.27},0,0,{"$f":"$H$161+$G$161","v":0.52},{"$f":"$I$161","v":0.09}]
[null,null,110100,0.12,{"$f":"$E$161+$F$161","v":0.27},0,{"$f":"$G$161+$H$161+$I$161","v":0.61},0,0]
[null,null,110101,0.12,{"$f":"$E$161+$F$161","v":0.27},0,{"$f":"$G$161+($H$161*0.5)","v":0.31},0,{"$f":"$I$161+($H$161*0.5)","v":0.3}]
[null,null,110110,0.12,{"$f":"$E$161+$F$161","v":0.27},0,{"$f":"$G$161","v":0.1},{"$f":"$H$161+$I$161","v":0.51},0]
[null,null,110111,0.12,{"$f":"$E$161+$F$161","v":0.27},0,{"$f":"$G$161","v":0.1},{"$f":"$H$161","v":0.42},{"$f":"$I$161","v":0.09}]
[null,null,111000,0.12,{"$f":"$E$161","v":0.17},{"$f":"$F$161+$G$161+$H$161+$I$161","v":0.71},0,0,0]
[null,null,111001,0.12,{"$f":"$E$161+$F$161","v":0.27},{"$f":"$G$161+($H$161*0.5)","v":0.31},0,0,{"$f":"$I$161+($H$161*0.5)","v":0.3}]
[null,null,111010,0.12,{"$f":"$E$161","v":0.17},{"$f":"$F$161+$G$161","v":0.2},0,{"$f":"$H$161+$I$161","v":0.51},0]
[null,null,111011,0.12,0.17,{"$f":"$F$161+$G$161","v":0.2},0,{"$f":"$H$161","v":0.42},{"$f":"$I$161","v":0.09}]
[null,null,111100,0.12,0.17,{"$f":"$F$161+$G$161","v":0.2},{"$f":"$H$161+$I$161","v":0.51},0,0]
[null,null,111101,0.12,0.17,{"$f":"$F$161","v":0.1},{"$f":"$G$161+($H$161*0.5)","v":0.31},0,{"$f":"$I$161+($H$161*0.5)","v":0.3}]
[null,null,111110,0.12,0.17,{"$f":"$F$161","v":0.1},{"$f":"$G$161","v":0.1},{"$f":"$H$161+$I$161","v":0.51},0]
[null,null,111111,0.12,0.17,{"$f":"$F$161","v":0.1},{"$f":"$G$161","v":0.1},{"$f":"$H$161","v":0.42},{"$f":"$I$161","v":0.09}]
[]
[null,null,{"$f":"J111*1","v":100000},{"$f":"VLOOKUP($C$195,$C$162:$I$193,2,FALSE)","v":0.99999999999999989},{"$f":"VLOOKUP($C$195,$C$162:$I$193,3,FALSE)","v":0},{"$f":"VLOOKUP($C$195,$C$162:$I$193,4,FALSE)","v":0},{"$f":"VLOOKUP($C$195,$C$162:$I$193,5,FALSE)","v":0},{"$f":"VLOOKUP($C$195,$C$162:$I$193,6,FALSE)","v":0},{"$f":"VLOOKUP($C$195,$C$162:$I$193,7,FALSE)","v":0}]
[null,null,null,{"$f":"IF($D$110=0,0,D195)","v":0},{"$f":"IF($D$110=0,(D195+E195),E195)","v":0.99999999999999989},{"$f":"F195","v":0},{"$f":"G195","v":0},{"$f":"H195","v":0},{"$f":"I195","v":0}]