{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Input","Calculations","Output"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":15,"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":"Input","index":0,"n_rows":26,"n_cols":3,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[null,"Transportation Analysis Project Costing Tool"]
[]
[]
[]
[]
[]
[]
[null,"Summary of User Inputs:"]
[]
[1,"Name of Study Area:","I-4 Test"]
[2,"Number of Intersections:",6]
[3,"Number of Freeway Ramps:",10]
[4,"Base Model Availability:","No"]
[5,"Is the Base Model Calibrated:","No"]
[6,"Number of Analysis Horizons:",3]
[7,"Number of Alternatives:",2]
[8,"Number of Representative Days:",1]
[9,"Number of Peak Periods",2]
[10,"Data Processing Requirements:","Low"]
[11,"Complexity of Analysis Scenarios:","Complex"]
[12,"Complexity of Methodology:","Stochastic/Dynamic"]
[13,"Complexity of Outputs:","Simple"]
[14,"Analyst Experience:","Considerable"]
[]
[]
[null,"Note: This Transportation Analysis Costing Tool is provided \"as is\" without warranty of any kind, and without any documentation, user's guide, or maintenance agreement"]

{"sheet":"Calculations","index":1,"n_rows":267,"n_cols":20,"rows_kept":267,"cut":false,"hidden":false,"merged":[[83,9,83,10],[87,1,92,1],[83,12,83,13]]}
[null,{"$f":"Input!B1","v":"Transportation Analysis Project Costing Tool"}]
["INPUT DATA"]
[]
[null,"Blue cells indicate numeric values that can be modified by the user."]
[]
["Summary of User Inputs:"]
[]
[null,{"$f":"Input!B10","v":"Name of Study Area:"},{"$f":"Study_Area","v":"I-4 Test"}]
[null,{"$f":"Input!B11","v":"Number of Intersections:"},{"$f":"Intersections","v":6}]
[null,{"$f":"Input!B12","v":"Number of Freeway Ramps:"},{"$f":"Ramps","v":10}]
[null,{"$f":"Input!B13","v":"Base Model Availability:"},{"$f":"BM_Avail","v":"No"}]
[null,{"$f":"Input!B14","v":"Is the Base Model Calibrated:"},{"$f":"BM_Calib","v":"No"}]
[null,{"$f":"Input!B15","v":"Number of Analysis Horizons:"},{"$f":"Time_Horizons","v":3}]
[null,{"$f":"Input!B16","v":"Number of Alternatives:"},{"$f":"Alternatives","v":2}]
[null,{"$f":"Input!B17","v":"Number of Representative Days:"},{"$f":"Op_Cond","v":1}]
[null,{"$f":"Input!B18","v":"Number of Peak Periods"},{"$f":"Peak_Periods","v":2}]
[null,{"$f":"Input!B19","v":"Data Processing Requirements:"},{"$f":"Data_Collect","v":"Low"}]
[null,{"$f":"Input!B20","v":"Complexity of Analysis Scenarios:"},{"$f":"Complex_Scen","v":"Complex"}]
[null,{"$f":"Input!B21","v":"Complexity of Methodology:"},{"$f":"Complex_Meth","v":"Stochastic/Dynamic"}]
[null,{"$f":"Input!B22","v":"Complexity of Outputs:"},{"$f":"Complex_Output","v":"Simple"}]
[null,{"$f":"Input!B23","v":"Analyst Experience:"},{"$f":"Analyst_Exp","v":"Considerable"}]
[]
[" ASSUMPTIONS"]
["Number of labor hours per average intersection:",null,null,"Engineer/",null,null,null,"Engineer/"]
[null,null,"Manager","Planner","Technician","Total","Manager","Planner","Technician","Total"]
["Project Task",null,"Hours","Hours","Hours","Hours","% of total","% of total","% of total","Percent"]
[1,"Develop workplan, analysis plan, and project management",2,2,1,{"$f":"SUM(C27:E27)","v":5},{"$f":"C27/F27","v":0.4},{"$f":"D27/F27","v":0.4},{"$f":"E27/F27","v":0.2},{"$f":"SUM(G27:I27)","v":1}]
[2,"Select analysis tool",1,1,0,{"$f":"SUM(C28:E28)","v":2},{"$f":"C28/F28","v":0.5},{"$f":"D28/F28","v":0.5},{"$f":"E28/F28","v":0},{"$f":"SUM(G28:I28)","v":1}]
[3,"Develop data plan and process data",0,0,3,{"$f":"SUM(C29:E29)","v":3},{"$f":"C29/F29","v":0},{"$f":"D29/F29","v":0},{"$f":"E29/F29","v":1},{"$f":"SUM(G29:I29)","v":1}]
[4,"Define clusters and representative days",1,2,0,{"$f":"SUM(C30:E30)","v":3},{"$f":"C30/F30","v":0.33333333333333331},{"$f":"D30/F30","v":0.66666666666666663},{"$f":"E30/F30","v":0},{"$f":"SUM(G30:I30)","v":1}]
[5,"Develop and calibrate baseline model(s)",0.5,1,1,2.5,0.2,0.4,0.4,1]
[6,"Develop future baseline model(s)",0.5,0.5,0.5,1.5,0.33333333333333331,0.33333333333333331,0.33333333333333331,1]
[7,"Analyze alternatives",0.2,1,0.5,1.7,0.11764705882352942,0.58823529411764708,0.29411764705882354,1]
[8,"Reports and presentations",2,2,1,5,0.4,0.4,0.2,1]
[null,"Total Labor Hours",{"$f":"SUM(C27:C34)","v":7.2},{"$f":"SUM(D27:D34)","v":9.5},{"$f":"SUM(E27:E34)","v":7},23.7,0.30379746835443039,0.40084388185654007,0.29535864978902954,1]
[]
["Number of labor hours per average freeway ramp:",null,null,"Engineer/",null,null,null,"Engineer/"]
[null,null,"Manager","Planner","Technician","Total","Manager","Planner","Technician","Total"]
["Project Task",null,"Hours","Hours","Hours","Hours","% of total","% of total","% of total","Percent"]
[1,{"$f":"$B$27","v":"Develop workplan, analysis plan, and project management"},2,2,1,{"$f":"SUM(C40:E40)","v":5},{"$f":"C40/F40","v":0.4},{"$f":"D40/F40","v":0.4},{"$f":"E40/F40","v":0.2},{"$f":"SUM(G40:I40)","v":1}]
[2,{"$f":"$B$28","v":"Select analysis tool"},1,1,0,{"$f":"SUM(C41:E41)","v":2},{"$f":"C41/F41","v":0.5},{"$f":"D41/F41","v":0.5},{"$f":"E41/F41","v":0},{"$f":"SUM(G41:I41)","v":1}]
[3,{"$f":"B29","v":"Develop data plan and process data"},0,0,3,3,0,0,1,1]
[4,"Define clusters and representative days",1,2,0,{"$f":"SUM(C43:E43)","v":3},{"$f":"C43/F43","v":0.33333333333333331},{"$f":"D43/F43","v":0.66666666666666663},{"$f":"E43/F43","v":0},{"$f":"SUM(G43:I43)","v":1}]
[5,{"$f":"$B$31","v":"Develop and calibrate baseline model(s)"},0.5,1,2,3.5,0.14285714285714285,0.2857142857142857,0.5714285714285714,1]
[6,{"$f":"$B$32","v":"Develop future baseline model(s)"},0.5,0.5,0.5,1.5,0.33333333333333331,0.33333333333333331,0.33333333333333331,1]
[7,{"$f":"$B$33","v":"Analyze alternatives"},0.5,1,0.5,2,0.25,0.5,0.25,1]
[8,{"$f":"$B$34","v":"Reports and presentations"},2,2,1,5,0.4,0.4,0.2,1]
[null,"Total Labor Hours",{"$f":"SUM(C40:C47)","v":7.5},{"$f":"SUM(D40:D47)","v":9.5},{"$f":"SUM(E40:E47)","v":8},25,0.3,0.38,0.32,1]
[]
["Baseline model availability factor"]
["If a baseline model is available and calibrated"]
[null,"YesYes",0.5,"for Task 5"]
[null,"YesNo",0.8,"for Task 5"]
[null,"Partially",0.9,"for Task 5"]
[null,"No",1,"for Task 5"]
[]
["Complexity factor for different data processing requirements:"]
["Depending on the effort level for data processing"]
[null,"Low",0.25,"for Task 4"]
[null,"Medium",0.5,"for Task 4"]
[null,"High",1,"for Task 4"]
[]
["Complexity factor for different scenarios/alternatives:"]
[]
[null,"Simple",1,"for all Tasks"]
[null,"Complex",1.2,"for all Tasks"]
[]
[]
["Complexity factor for different methodologies:"]
[]
[null,"Deterministic",1,"for Tasks 5, 6, 7"]
[null,"Stochastic/Dynamic",1.3,"for Tasks 5, 6, 7"]
[]
["Complexity factor for different types of outputs"]
[]
[null,"Simple",0.9,"for Task 7"]
[null,"Comprehensive",1.1000000000000001,"for Task 7"]
[]
["Complexity factor for different profesional experience profiles"]
[]
[null,"Some",1.2,"for all Tasks"]
[null,"Considerable",0.9,"for all Tasks"]
[]
["Economies of scale effect",null,null,null,null,null,null,null,"Data Processing","Calibration",null,"Future Scenarios","Alternatives Analysis"]
["Economies of scale effect due to multiple model runs",null,null,null,null,null,null,null,"Task 3 - Extra data processing efforts due to Operational Conditions","Task 5 - Base Model Calibration","Task 5 - Operational Condition Model Calibration","Task 6 - Develop Future Scenarios","Task 7 - Base Model Analysis","Task 7 - Operational Condition Analysis"]
[null,null,null,null,null,null,null,null,"# of Operational Conditions x # of Peak Periods","# of Peak Periods","# of Operational Conditions x # of Peak Periods","# of Peak Periods x # of Analysis Horizons","# of Alternatives x # of Peak Periods x # of Analysis Horizons","# of Alternatives x # of Peak Periods x # of Analysis Horizons x # of Operational Conditions"]
[null,null,"Task 3 - Extra data processing efforts due to Operational Conditions","Task 5 - Base Model Calibration","Task 5 - Operational Condition Model Calibration","Task 6 - Develop Future Scenarios","Task 7 - Base Model Analysis","Task 7 - Operational Condition Analysis",{"$f":"C15*C16","v":2},{"$f":"C16","v":2},{"$f":"C15*C16","v":2},{"$f":"C16*C13","v":6},{"$f":"C16*C14*C13","v":12},{"$f":"C16*C15*C14*C13","v":12},"x1,2","x1,2","x1,2","x1,2","x1,2","x1,2"]
[null,"Tresholds to determine economies of scale",2,1,2,2,2,4,1,1,1,1,1,1,{"$f":"C88","v":2},{"$f":"D88","v":1},2,2,2,4]
[null,null,4,2,4,4,4,8,0.99,0.99,0.8,0.95,0.8,0.8,{"$f":"C89","v":4},2,4,4,4,8]
[null,null,8,3,8,6,6,16,0.97,0.97,0.5,0.8,0.5,0.5,{"$f":"C90","v":8},3,8,6,6,16]
[null,null,16,4,16,8,8,32,0.9,0.9,0.35,0.6,0.35,0.35,{"$f":"C91","v":16},4,16,8,8,32]
[null,null,32,5,32,10,10,64,0.8,0.8,0.3,0.4,0.3,0.3,{"$f":"C92","v":32},5,32,10,10,64]
[null,null,"More","More","More","More","More","More",0.7,0.7,0.25,0.2,0.25,0.25,64,20,64,20,20,128]
[]
[null,null,"Model Adjustment Factor, y2","Operational Condition Adjustment Factor, y2","Model Adjustment Factor, y1","Operational Condition Adjustment Factor, y1","Model Adjustment Factor, Linear Interpolation","Operational Condition Adjustment Factor, Linear Interpolation","Multiplication factor"]
[null,"Economies of Scale Multiplication factor for Task 3",null,{"$f":"IF(I87<=C88,I88,IF(I87<=C89,I89,IF(I87<=C90,I90,IF(I87<=C91,I91,IF(I87<=C92,I92,I93)))))","v":1},null,{"$f":"IF(D96=1,1,IF(D96=I89,I88,IF(D96=I90,I89,IF(D96=I91,I90,IF(D96=I92,I91,I92)))))","v":1},null,{"$f":"IF(D96=F96,1,((I87-VLOOKUP(F96,I88:O93,7,FALSE))/(VLOOKUP(D96,I88:O93,7,FALSE)-VLOOKUP(F96,I88:O93,7,FALSE)))*(D96-F96)+F96)","v":1},{"$f":"H96*I87","v":2}]
[null,"Economies of Scale Multiplication factor for Task 5",{"$f":"IF(J87<=D88,J88,IF(J87<=D89,J89,IF(J87<=D90,J90,IF(J87<=D91,J91,IF(J87<=D92,J92,J93)))))","v":0.99},{"$f":"IF(K87<=E88,K88,IF(K87<=E89,K89,IF(K87<=E90,K90,IF(K87<=E91,K91,IF(K87<=E92,K92,K93)))))","v":1},{"$f":"IF(C97=1,1,IF(C97=J89,J88,IF(C97=J90,J89,IF(C97=J91,J90,IF(C97=J92,J91,J92)))))","v":1},{"$f":"IF(D97=1,1,IF(D97=K89,K88,IF(D97=K90,K89,IF(D97=K91,K90,IF(D97=K92,K91,K92)))))","v":1},{"$f":"IF(C97=E97,1,((J87-VLOOKUP(E97,J88:P93,7,FALSE))/(VLOOKUP(C97,J88:P93,7,FALSE)-VLOOKUP(E97,J88:P93,7,FALSE)))*(C97-E97)+E97)","v":0.99},{"$f":"IF(D97=F97,1,((K87-VLOOKUP(F97,K88:Q93,7,FALSE))/(VLOOKUP(D97,K88:Q93,7,FALSE)-VLOOKUP(F97,K88:Q93,7,FALSE)))*(D97-F97)+F97)","v":1},{"$f":"J87*G97+K87*H97","v":3.98}]
[null,"Economies of Scale Multiplication factor for Task 6",{"$f":"IF(L87<=F88,L88,IF(L87<=F89,L89,IF(L87<=F90,L90,IF(L87<=F91,L91,IF(L87<=F92,L92,L93)))))","v":0.8},null,{"$f":"IF(C98=1,1,IF(C98=L89,L88,IF(C98=L90,L89,IF(C98=L91,L90,IF(C98=L92,L91,L92)))))","v":0.95},null,{"$f":"IF(C98=E98,1,((L87-VLOOKUP(E98,L88:R93,7,FALSE))/(VLOOKUP(C98,L88:R93,7,FALSE)-VLOOKUP(E98,L88:R93,7,FALSE)))*(C98-E98)+E98)","v":0.8},null,{"$f":"L87*G98","v":4.8000000000000007}]
[null,"Economies of Scale Multiplication factor for Task 7",{"$f":"IF(M87<=G88,M88,IF(M87<=G89,M89,IF(M87<=G90,M90,IF(M87<=G91,M91,IF(M87<=G92,M92,M93)))))","v":0.25},{"$f":"IF(N87<=H88,N88,IF(N87<=H89,N89,IF(N87<=H90,N90,IF(N87<=H91,N91,IF(N87<=H92,N92,N93)))))","v":0.5},{"$f":"IF(C99=1,1,IF(C99=M89,M88,IF(C99=M90,M89,IF(C99=M91,M90,IF(C99=M92,M91,M92)))))","v":0.3},{"$f":"IF(D99=1,1,IF(D99=N89,N88,IF(D99=N90,N89,IF(D99=N91,N90,IF(D99=N92,N91,N92)))))","v":0.8},{"$f":"IF(C99=E99,1,((M87-VLOOKUP(E99,M88:S93,7,FALSE))/(VLOOKUP(C99,M88:S93,7,FALSE)-VLOOKUP(E99,M88:S93,7,FALSE)))*(C99-E99)+E99)","v":0.28999999999999998},{"$f":"IF(D99=F99,1,((N87-VLOOKUP(F99,N88:T93,7,FALSE))/(VLOOKUP(D99,N88:T93,7,FALSE)-VLOOKUP(F99,N88:T93,7,FALSE)))*(D99-F99)+F99)","v":0.65},{"$f":"M87*G99+N87*H99","v":11.280000000000001}]
[]
["Range"]
["Determine the range for the results on the final output table"]
[null,null,0.1,"To determine lower/upper bounds of project activities"]
[null,null,0.3,"To determine upper bound of Task 5 (Calibration)"]
[]
[]
["CALCULATIONS"]
["Total number of labor hours for Intersections:",null,null,"Engineer/"]
[null,null,"Manager","Planner","Technician","Total"]
["Project Task",null,"Hours","Hours","Hours","Hours"]
[1,"Develop workplan, analysis plan, and project management",{"$f":"C27*$C$9","v":12},12,6,{"$f":"SUM(C111:E111)","v":30}]
[2,"Select analysis tool",6,6,0,{"$f":"F28*$C$9","v":12}]
[3,"Develop data plan and process data",0,0,18,{"$f":"F29*$C$9","v":18}]
[4,"Define clusters and representative days",6,12,0,{"$f":"SUM(C114:E114)","v":18}]
[5,"Develop and calibrate baseline model(s)",3,6,6,15]
[6,"Develop future baseline model(s)",3,3,3,9]
[7,"Analyze alternatives",1.2000000000000002,6,3,10.199999999999999]
[8,"Reports and presentations",12,12,6,30]
[null,"Total Labor Hours",{"$f":"SUM(C111:C118)","v":43.2},{"$f":"SUM(D111:D118)","v":57},{"$f":"SUM(E111:E118)","v":42},142.19999999999999]
[]
[]
["Total number of labor hours for Freeway Ramps:",null,null,"Engineer/"]
[null,null,"Manager","Planner","Technician","Total"]
["Project Task",null,"Hours","Hours","Hours","Hours"]
[1,"Develop workplan, analysis plan, and project management",{"$f":"C40*$C$10","v":20},20,10,{"$f":"SUM(C125:E125)","v":50}]
[2,"Select analysis tool",10,10,0,{"$f":"SUM(C126:E126)","v":20}]
[3,"Develop data plan and process data",0,0,30,{"$f":"SUM(C127:E127)","v":30}]
[4,"Define clusters and representative days",10,20,0,30]
[5,"Develop and calibrate baseline model(s)",5,10,20,35]
[6,"Develop future baseline model(s)",5,5,5,15]
[7,"Analyze alternatives",5,10,5,20]
[8,"Reports and presentations",20,20,10,50]
[null,"Total Labor Hours",{"$f":"SUM(C125:C132)","v":75},{"$f":"SUM(D125:D132)","v":95},{"$f":"SUM(E125:E132)","v":80},{"$f":"SUM(C133:E133)","v":250}]
[]
[]
["Total number of labor hours (Intersections + Ramps):",null,null,"Engineer/"]
[null,null,"Manager","Planner","Technician","Total"]
["Project Task",null,"Hours","Hours","Hours","Hours"]
[1,"Develop workplan, analysis plan, and project management",{"$f":"C111+C125","v":32},32,16,{"$f":"SUM(C139:E139)","v":80}]
[2,"Select analysis tool",16,16,0,{"$f":"SUM(C140:E140)","v":32}]
[3,"Develop data plan and process data",0,0,48,{"$f":"SUM(C141:E141)","v":48}]
[4,"Define clusters and representative days",16,32,0,{"$f":"SUM(C142:E142)","v":48}]
[5,"Develop and calibrate baseline model(s)",8,16,26,50]
[6,"Develop future baseline model(s)",8,8,8,24]
[7,"Analyze alternatives",6.2,16,8,30.2]
[8,"Reports and presentations",32,32,16,80]
[null,"Total Labor Hours",118.2,152,122,392.2]
[]
["Adjustmentof data clustering for number of representative days:",null,null,"Engineer/"]
[null,null,"Manager","Planner","Technician","Total"]
["Project Task",null,"Hours","Hours","Hours","Hours"]
[4,"Define clusters and representative days (additional)",{"$f":"C142*$C$15","v":16},{"$f":"D142*$C$15","v":32},{"$f":"E142*$C$15","v":0},{"$f":"SUM(C152:E152)","v":48}]
[4,"Define clusters and representative days (total)",{"$f":"C152","v":16},{"$f":"D152","v":32},{"$f":"E152","v":0},{"$f":"SUM(C153:E153)","v":48}]
[]
[]
["Adjustment for different data processing types:",null,null,"Engineer/"]
[null,null,"Manager","Planner","Technician","Total"]
["Project Task",null,"Hours","Hours","Hours","Hours"]
[3,"Develop data plan and process data (additional)",{"$f":"VLOOKUP($C$17,$B$59:$C$61,2,FALSE)*C141*$I$96","v":0},{"$f":"VLOOKUP($C$17,$B$59:$C$61,2,FALSE)*D141*$I$96","v":0},{"$f":"VLOOKUP($C$17,$B$59:$C$61,2,FALSE)*E141*$I$96","v":24},{"$f":"SUM(C159:E159)","v":24}]
[3,"Develop data plan and process data (total)",{"$f":"C159","v":0},{"$f":"D159","v":0},{"$f":"E159","v":24},{"$f":"SUM(C160:E160)","v":24}]
[]
["Adjustment for Baseline model availability:",null,null,"Engineer/"]
[null,null,"Manager","Planner","Technician","Total"]
["Project Task",null,"Hours","Hours","Hours","Hours"]
[5,"Develop and calibrate baseline model(s) (additional)",{"$f":"(IF($C$11=\"Yes\",VLOOKUP($C$11&$C$12,$B$52:$C$53,2,FALSE),VLOOKUP($C$11,$B$54:$C$55,2,FALSE))-1)*C143","v":0},{"$f":"(IF($C$11=\"Yes\",VLOOKUP($C$11&$C$12,$B$52:$C$53,2,FALSE),VLOOKUP($C$11,$B$54:$C$55,2,FALSE))-1)*D143","v":0},{"$f":"(IF($C$11=\"Yes\",VLOOKUP($C$11&$C$12,$B$52:$C$53,2,FALSE),VLOOKUP($C$11,$B$54:$C$55,2,FALSE))-1)*E143","v":0},{"$f":"SUM(C165:E165)","v":0}]
[5,"Develop and calibrate baseline model(s) (total)",{"$f":"C143+C165","v":8},{"$f":"D143+D165","v":16},{"$f":"E143+E165","v":26},{"$f":"SUM(C166:E166)","v":50}]
[]
["Adjustment for number of peak periods",null,null,"Engineer/"]
[null,null,"Manager","Planner","Technician","Total"]
["Project Task",null,"Hours","Hours","Hours","Hours"]
[5,"Develop and calibrate baseline model(s) (additional)",{"$f":"$I$97*C166","v":31.84},{"$f":"$I$97*D166","v":63.68},{"$f":"$I$97*E166","v":103.48},{"$f":"SUM(C171:E171)","v":199}]
[5,"Develop and calibrate baseline model(s) (total)",{"$f":"C166+C171","v":39.840000000000003},{"$f":"D166+D171","v":79.680000000000007},{"$f":"E166+E171","v":129.48000000000002},{"$f":"SUM(C172:E172)","v":249.00000000000003}]
[]
["Adjustment for complexity of alternatives:",null,null,"Engineer/"]
[null,null,"Manager","Planner","Technician","Total"]
["Project Task",null,"Hours","Hours","Hours","Hours"]
[1,"Develop workplan, analysis plan, and project management (additional)",{"$f":"(VLOOKUP($C$18,$B$65:$C$66,2,FALSE)-1)*C139","v":6.3999999999999986},6.3999999999999986,3.1999999999999993,{"$f":"SUM(C177:E177)","v":15.999999999999996}]
[2,"Select analysis tool (additional)",3.1999999999999993,3.1999999999999993,0,{"$f":"SUM(C178:E178)","v":6.3999999999999986}]
[3,"Develop data plan and process data (additional)",{"$f":"(VLOOKUP($C$18,$B$65:$C$66,2,FALSE)-1)*C160","v":0},{"$f":"(VLOOKUP($C$18,$B$65:$C$66,2,FALSE)-1)*D160","v":0},{"$f":"(VLOOKUP($C$18,$B$65:$C$66,2,FALSE)-1)*E160","v":4.7999999999999989},{"$f":"SUM(C179:E179)","v":4.7999999999999989}]
[4,"Define clusters and representative days (additional)",{"$f":"(VLOOKUP($C$18,$B$65:$C$66,2,FALSE)-1)*C153","v":3.1999999999999993},{"$f":"(VLOOKUP($C$18,$B$65:$C$66,2,FALSE)-1)*D153","v":6.3999999999999986},{"$f":"(VLOOKUP($C$18,$B$65:$C$66,2,FALSE)-1)*E153","v":0},9.5999999999999979]
[5,"Develop and calibrate baseline model(s) (additional)",{"$f":"(VLOOKUP($C$18,$B$65:$C$66,2,FALSE)-1)*C172","v":7.9679999999999991},{"$f":"(VLOOKUP($C$18,$B$65:$C$66,2,FALSE)-1)*D172","v":15.935999999999998},{"$f":"(VLOOKUP($C$18,$B$65:$C$66,2,FALSE)-1)*E172","v":25.895999999999997},49.8]
[6,"Develop future baseline model(s) (additional)",{"$f":"(VLOOKUP($C$18,$B$65:$C$66,2,FALSE)-1)*C144","v":1.5999999999999996},1.5999999999999996,1.5999999999999996,4.7999999999999989]
[7,"Analyze alternatives (additional)",1.2399999999999998,3.1999999999999993,1.5999999999999996,6.0399999999999991]
[8,"Reports and presentations (additional)",6.3999999999999986,6.3999999999999986,3.1999999999999993,15.999999999999996]
[1,"Develop workplan, analysis plan, and project management (total)",{"$f":"C139+C177","v":38.4},38.4,19.2,{"$f":"SUM(C185:E185)","v":96}]
[2,"Select analysis tool (total)",19.2,19.2,0,{"$f":"SUM(C186:E186)","v":38.4}]
[3,"Develop data plan and process data (total)",{"$f":"C160+C179","v":0},{"$f":"D160+D179","v":0},{"$f":"E160+E179","v":28.799999999999997},{"$f":"SUM(C187:E187)","v":28.799999999999997}]
[4,"Define clusters and representative days (total)",{"$f":"C153+C180","v":19.2},{"$f":"D153+D180","v":38.4},{"$f":"E153+E180","v":0},57.599999999999994]
[5,"Develop and calibrate baseline model(s) (total)",{"$f":"C172+C181","v":47.808},{"$f":"D172+D181","v":95.616},{"$f":"E172+E181","v":155.376},298.8]
[6,"Develop future baseline model(s) (total)",{"$f":"C144+C182","v":9.6},9.6,9.6,28.799999999999997]
[7,"Analyze alternatives (total)",7.4399999999999995,19.2,9.6,36.24]
[8,"Reports and presentations (total)",38.4,38.4,19.2,96]
[]
["Adjustment for complexity of methodologies",null,null,"Engineer/"]
[null,null,"Manager","Planner","Technician","Total"]
["Project Task",null,"Hours","Hours","Hours","Hours"]
[5,"Develop and calibrate baseline model(s) (additional)",{"$f":"(VLOOKUP($C$19,$B$71:$C$72,2,FALSE)-1)*C189","v":14.342400000000001},28.684800000000003,46.612800000000007,{"$f":"SUM(C197:E197)","v":89.640000000000015}]
[6,"Develop future baseline model(s) (additional)",2.8800000000000003,2.8800000000000003,2.8800000000000003,8.64]
[7,"Analyze alternatives (additional)",2.2320000000000002,5.7600000000000007,2.8800000000000003,10.872000000000002]
[5,"Develop and calibrate baseline model(s) (total)",{"$f":"C189+C197","v":62.150400000000005},{"$f":"D189+D197","v":124.30080000000001},201.98880000000003,388.44000000000005]
[6,"Develop future baseline model(s) (total)",{"$f":"C190+C198","v":12.48},12.48,12.48,37.44]
[7,"Analyze alternatives (total)",9.6720000000000006,24.96,12.48,47.112000000000009]
[]
["Adjustment for number of future scenarios and alternatives",null,null,"Engineer/"]
[null,null,"Manager","Planner","Technician","Total"]
["Project Task",null,"Hours","Hours","Hours","Hours"]
[6,"Develop future baseline model(s) (additional)",{"$f":"$I$98*C201","v":59.904000000000011},{"$f":"$I$98*D201","v":59.904000000000011},{"$f":"$I$98*E201","v":59.904000000000011},{"$f":"SUM(C207:E207)","v":179.71200000000005}]
[6,"Develop future baseline model(s) (total)",{"$f":"C201+C207","v":72.384000000000015},{"$f":"D201+D207","v":72.384000000000015},{"$f":"E201+E207","v":72.384000000000015},{"$f":"SUM(C208:E208)","v":217.15200000000004}]
[]
["Adjustment for number of operational conditions",null,null,"Engineer/"]
[null,null,"Manager","Planner","Technician","Total"]
["Project Task",null,"Hours","Hours","Hours","Hours"]
[7,"Analyze alternatives (additional)",{"$f":"$I$99*C202","v":109.10016000000002},{"$f":"$I$99*D202","v":281.54880000000003},{"$f":"$I$99*E202","v":140.77440000000001},{"$f":"SUM(C213:E213)","v":531.42336}]
[7,"Analyze alternatives (total)",{"$f":"C202+C213","v":118.77216000000001},{"$f":"D202+D213","v":306.50880000000001},{"$f":"E202+E213","v":153.2544},{"$f":"SUM(C214:E214)","v":578.53536000000008}]
[]
["Adjustment for complexity of different types of outputs",null,null,"Engineer/"]
[null,null,"Manager","Planner","Technician","Total"]
["Project Task",null,"Hours","Hours","Hours","Hours"]
[7,"Analyze alternatives (additional)",{"$f":"(VLOOKUP($C$20,$B$76:$C$77,2,FALSE)-1)*C214","v":-11.877215999999999},{"$f":"(VLOOKUP($C$20,$B$76:$C$77,2,FALSE)-1)*D214","v":-30.650879999999994},{"$f":"(VLOOKUP($C$20,$B$76:$C$77,2,FALSE)-1)*E214","v":-15.325439999999997},{"$f":"SUM(C219:E219)","v":-57.853535999999991}]
[7,"Analyze alternatives (total)",{"$f":"C219+C214","v":106.89494400000001},{"$f":"D219+D214","v":275.85792000000004},{"$f":"E219+E214","v":137.92896000000002},{"$f":"SUM(C220:E220)","v":520.68182400000001}]
[]
["Adjustment for professional experience",null,null,"Engineer/"]
[null,null,"Manager","Planner","Technician","Total"]
["Project Task",null,"Hours","Hours","Hours","Hours"]
[1,"Develop workplan, analysis plan, and project management (additional)",{"$f":"(VLOOKUP($C$21,$B$81:$C$82,2,FALSE)-1)*C185","v":-3.839999999999999},-3.839999999999999,-1.9199999999999995,{"$f":"SUM(C225:E225)","v":-9.5999999999999979}]
[2,"Select analysis tool (additional)",-1.9199999999999995,-1.9199999999999995,0,{"$f":"SUM(C226:E226)","v":-3.839999999999999}]
[3,"Develop data plan and process data (additional)",0,0,-2.879999999999999,{"$f":"SUM(C227:E227)","v":-2.879999999999999}]
[4,"Define clusters and representative days (additional)",-1.9199999999999995,-3.839999999999999,0,-5.759999999999998]
[5,"Develop and calibrate baseline model(s) (additional)",{"$f":"(VLOOKUP($C$21,$B$81:$C$82,2,FALSE)-1)*C200","v":-6.2150399999999992},{"$f":"(VLOOKUP($C$21,$B$81:$C$82,2,FALSE)-1)*D200","v":-12.430079999999998},{"$f":"(VLOOKUP($C$21,$B$81:$C$82,2,FALSE)-1)*E200","v":-20.198879999999999},-38.843999999999994]
[6,"Develop future baseline model(s) (additional)",{"$f":"(VLOOKUP($C$21,$B$81:$C$82,2,FALSE)-1)*C208","v":-7.2383999999999995},{"$f":"(VLOOKUP($C$21,$B$81:$C$82,2,FALSE)-1)*D208","v":-7.2383999999999995},{"$f":"(VLOOKUP($C$21,$B$81:$C$82,2,FALSE)-1)*E208","v":-7.2383999999999995},-21.715199999999999]
[7,"Analyze alternatives (additional)",{"$f":"(VLOOKUP($C$21,$B$81:$C$82,2,FALSE)-1)*C220","v":-10.689494399999999},{"$f":"(VLOOKUP($C$21,$B$81:$C$82,2,FALSE)-1)*D220","v":-27.585791999999998},{"$f":"(VLOOKUP($C$21,$B$81:$C$82,2,FALSE)-1)*E220","v":-13.792895999999999},-52.068182399999998]
[8,"Reports and presentations (additional)",{"$f":"(VLOOKUP($C$21,$B$81:$C$82,2,FALSE)-1)*C192","v":-3.839999999999999},{"$f":"(VLOOKUP($C$21,$B$81:$C$82,2,FALSE)-1)*D192","v":-3.839999999999999},{"$f":"(VLOOKUP($C$21,$B$81:$C$82,2,FALSE)-1)*E192","v":-1.9199999999999995},-9.5999999999999979]
[1,"Develop workplan, analysis plan, and project management (total)",{"$f":"C225+C185","v":34.56},34.56,17.28,{"$f":"SUM(C233:E233)","v":86.4}]
[2,"Select analysis tool (total)",17.28,17.28,0,{"$f":"SUM(C234:E234)","v":34.56}]
[3,"Develop data plan and process data (total)",0,0,25.919999999999998,{"$f":"SUM(C235:E235)","v":25.919999999999998}]
[4,"Define clusters and representative days (total)",17.28,34.56,0,51.84]
[5,"Develop and calibrate baseline model(s) (total)",{"$f":"C229+C200","v":55.935360000000003},{"$f":"D229+D200","v":111.87072000000001},{"$f":"E229+E200","v":181.78992000000002},349.596]
[6,"Develop future baseline model(s) (total)",{"$f":"C230+C208","v":65.145600000000016},{"$f":"D230+D208","v":65.145600000000016},{"$f":"E230+E208","v":65.145600000000016},195.43680000000006]
[7,"Analyze alternatives (total)",{"$f":"C231+C220","v":96.205449600000009},{"$f":"D231+D220","v":248.27212800000004},{"$f":"E231+E220","v":124.13606400000002},468.61364160000005]
[8,"Reports and presentations (total)",{"$f":"C232+C146","v":28.16},{"$f":"D232+D146","v":28.16},{"$f":"E232+E146","v":14.08},70.400000000000006]
[]
[]
["Project specific total number of labor hours",null,null,"Engineer/"]
[null,null,"Manager","Planner","Technician","Total"]
["Project Task",null,"Hours","Hours","Hours","Hours"]
[1,{"$f":"$B27","v":"Develop workplan, analysis plan, and project management"},{"$f":"C233","v":34.56},34.56,17.28,{"$f":"SUM(C246:E246)","v":86.4}]
[2,{"$f":"$B28","v":"Select analysis tool"},17.28,17.28,0,{"$f":"SUM(C247:E247)","v":34.56}]
[3,"Develop data plan and process data",0,0,25.919999999999998,{"$f":"SUM(C248:E248)","v":25.919999999999998}]
[4,"Define clusters and representative days",17.28,34.56,0,51.84]
[5,"Develop and calibrate baseline model(s)",{"$f":"C237","v":55.935360000000003},111.87072000000001,181.78992000000002,349.596]
[6,"Develop future baseline model(s)",65.145600000000016,65.145600000000016,65.145600000000016,195.43680000000006]
[7,"Analyze alternatives",96.205449600000009,248.27212800000004,124.13606400000002,468.61364160000005]
[8,"Reports and presentations",28.16,28.16,14.08,70.400000000000006]
[null,"Total Labor Hours",{"$f":"SUM(C246:C253)","v":314.56640960000004},{"$f":"SUM(D246:D253)","v":539.84844800000008},{"$f":"SUM(E246:E253)","v":428.35158400000006},1282.7664416000002]
[]
["Project specific rounded number of labor hours",null,null,"Engineer/"]
[null,null,"Manager","Planner","Technician","Total","Lower","Upper"]
["Project Task",null,"Hours","Hours","Hours","Hours","Bound","Bound"]
[1,{"$f":"$B40","v":"Develop workplan, analysis plan, and project management"},{"$f":"ROUND(C246,-1)","v":30},30,20,{"$f":"SUM(C259:E259)","v":80},{"$f":"ROUND(F259*(1-$C$103),-1)","v":70},{"$f":"ROUND(F259*(1+$C$103),-1)","v":90}]
[2,{"$f":"$B41","v":"Select analysis tool"},20,20,0,{"$f":"SUM(C260:E260)","v":40},40,{"$f":"ROUND(F260*(1+$C$103),-1)","v":40}]
[3,"Develop data plan and process data",0,0,30,{"$f":"SUM(C261:E261)","v":30},{"$f":"ROUND(F261*(1-$C$103),-1)","v":30},{"$f":"ROUND(F261*(1+$C$103),-1)","v":30}]
[4,"Define clusters and representative days",20,30,0,{"$f":"SUM(C262:E262)","v":50},{"$f":"ROUND(F262*(1-$C$103),-1)","v":50},{"$f":"ROUND(F262*(1+$C$103),-1)","v":60}]
[5,"Develop and calibrate baseline model(s)",60,110,180,350,320,{"$f":"ROUND(F263*(1+$C$104),-1)","v":460}]
[6,"Develop future baseline model(s)",70,70,70,210,190,{"$f":"ROUND(F264*(1+$C$103),-1)","v":230}]
[7,"Analyze alternatives",100,250,120,470,420,{"$f":"ROUND(F265*(1+$C$103),-1)","v":520}]
[8,"Reports and presentations",30,30,10,70,60,{"$f":"ROUND(F266*(1+$C$103),-1)","v":80}]
[null,"Total Labor Hours",{"$f":"SUM(C259:C266)","v":330},540,430,1300,1180,1510]

{"sheet":"Output","index":2,"n_rows":17,"n_cols":8,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"Input!B1","v":"Transportation Analysis Project Costing Tool"}]
[]
[" OUTPUT REPORT"]
["Estimate of Labor Hours Required to Complete the Analysis of:"]
[null,{"$f":"Study_Area","v":"I-4 Test"}]
[null,null,null,"Engineer/"]
[null,null,"Manager","Planner","Technician","Total","Lower","Upper"]
[null,"Project Task","Hours","Hours","Hours","Hours","Bound","Bound"]
[1,{"$f":"Calculations!B259","v":"Develop workplan, analysis plan, and project management"},{"$f":"Calculations!C259","v":30},{"$f":"Calculations!D259","v":30},{"$f":"Calculations!E259","v":20},{"$f":"SUM(C9:E9)","v":80},{"$f":"Calculations!G259","v":70},{"$f":"Calculations!H259","v":90}]
[2,{"$f":"Calculations!B260","v":"Select analysis tool"},{"$f":"Calculations!C260","v":20},{"$f":"Calculations!D260","v":20},{"$f":"Calculations!E260","v":0},{"$f":"SUM(C10:E10)","v":40},{"$f":"Calculations!G260","v":40},{"$f":"Calculations!H260","v":40}]
[3,{"$f":"Calculations!B261","v":"Develop data plan and process data"},{"$f":"Calculations!C261","v":0},{"$f":"Calculations!D261","v":0},{"$f":"Calculations!E261","v":30},{"$f":"SUM(C11:E11)","v":30},{"$f":"Calculations!G261","v":30},{"$f":"Calculations!H261","v":30}]
[4,{"$f":"Calculations!B262","v":"Define clusters and representative days"},{"$f":"Calculations!C262","v":20},{"$f":"Calculations!D262","v":30},{"$f":"Calculations!E262","v":0},{"$f":"SUM(C12:E12)","v":50},{"$f":"Calculations!G262","v":50},{"$f":"Calculations!H262","v":60}]
[5,{"$f":"Calculations!B263","v":"Develop and calibrate baseline model(s)"},{"$f":"Calculations!C263","v":60},{"$f":"Calculations!D263","v":110},{"$f":"Calculations!E263","v":180},350,{"$f":"Calculations!G263","v":320},{"$f":"Calculations!H263","v":460}]
[6,{"$f":"Calculations!B264","v":"Develop future baseline model(s)"},{"$f":"Calculations!C264","v":70},{"$f":"Calculations!D264","v":70},{"$f":"Calculations!E264","v":70},210,{"$f":"Calculations!G264","v":190},{"$f":"Calculations!H264","v":230}]
[7,{"$f":"Calculations!B265","v":"Analyze alternatives"},{"$f":"Calculations!C265","v":100},{"$f":"Calculations!D265","v":250},{"$f":"Calculations!E265","v":120},470,{"$f":"Calculations!G265","v":420},{"$f":"Calculations!H265","v":520}]
[8,{"$f":"Calculations!B266","v":"Reports and presentations"},{"$f":"Calculations!C266","v":30},{"$f":"Calculations!D266","v":30},{"$f":"Calculations!E266","v":10},70,{"$f":"Calculations!G266","v":60},{"$f":"Calculations!H266","v":80}]
[null,"Total Labor Hours",{"$f":"SUM(C9:C16)","v":330},540,430,1300,1180,1510]