{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Sheet1","Input","Calculations","Output"],"not_rendered":{"charts":0,"images":2,"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":"Sheet1","index":0,"n_rows":17,"n_cols":2,"rows_kept":17,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Availability of Baseline/No-Build Data Related to Crash and Roadway (Good, Sufficient, Limited):"]
[null,"Good"]
[null,"Sufficient"]
[null,"Limited"]
[]
[null,"Complexity of Geometry (Simple, Complex):"]
[null,"Simple"]
[null,"Complex"]
[]
[null,"Type of Alternatives Analysis (CMFs, Predictive Method):"]
[null,"CMFs"]
[null,"Predictive Method"]
[]
[null,"Project Team Experience (Some, Considerable):"]
[null,"Some"]
[null,"Considerable"]

{"sheet":"Input","index":1,"n_rows":25,"n_cols":5,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[null,"Safety Analysis Costing Tool","Developed for:"]
[]
[]
[]
[]
[]
[]
[null,"Summary of User Inputs:"]
[]
[1,"Name of Study Area:","Test"]
[2,"Number of Intersections:",4]
[3,"Number of Ramp Terminal Intersections:",2]
[4,"Number of Roadway/Freeway Segments:",4]
[5,"Number of Ramp Segments:",2]
[6,"Availability of Baseline/No-Build Data Related to Crash and Roadway (Good, Sufficient, Limited):","Sufficient"]
[7,"Number of Analysis Years:",3]
[8,"Complexity of Geometry (Simple, Complex):","Simple"]
[9,"Type of Alternatives Analysis (Crash Modification Factors (CMFs), Predictive Method):","CMFs"]
[10,"Project Team Experience (Some, Considerable):","Some"]
[]
[]
[null,"Note: This Safety Analysis Costing Tool is provided \"as is\" without warranty of any kind, or maintenance agreement."]
[]
[]
[null,null,null,null,5]

{"sheet":"Calculations","index":2,"n_rows":208,"n_cols":10,"rows_kept":208,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"Input!B1","v":"Safety Analysis Costing Tool"},null,null,"Developed for:"]
["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":"Input!C10","v":"Test"}]
[null,{"$f":"Input!B11","v":"Number of Intersections:"},{"$f":"Input!C11","v":4}]
[null,{"$f":"Input!B12","v":"Number of Ramp Terminal Intersections:"},{"$f":"Input!C12","v":2}]
[null,{"$f":"Input!B13","v":"Number of Roadway/Freeway Segments:"},{"$f":"Input!C13","v":4}]
[null,{"$f":"Input!B14","v":"Number of Ramp Segments:"},{"$f":"Input!C14","v":2}]
[null,{"$f":"Input!B15","v":"Availability of Baseline/No-Build Data Related to Crash and Roadway (Good, Sufficient, Limited):"},{"$f":"Input!C15","v":"Sufficient"}]
[null,{"$f":"Input!B16","v":"Number of Analysis Years:"},{"$f":"Input!C16","v":3}]
[null,{"$f":"Input!B17","v":"Complexity of Geometry (Simple, Complex):"},{"$f":"Input!C17","v":"Simple"}]
[null,{"$f":"Input!B18","v":"Type of Alternatives Analysis (Crash Modification Factors (CMFs), Predictive Method):"},{"$f":"Input!C18","v":"CMFs"}]
[null,{"$f":"Input!B19","v":"Project Team Experience (Some, Considerable):"},{"$f":"Input!C19","v":"Some"}]
[]
["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"]
[null,"1. Develop workplan, analysis plan, and project management",0.75,1,null,{"$f":"SUM(C23:E23)","v":1.75},{"$f":"C23/F23","v":0.42857142857142855},{"$f":"D23/F23","v":0.5714285714285714},{"$f":"E23/F23","v":0},{"$f":"SUM(G23:I23)","v":1}]
[null,"2. Data Collection and Processing (compiling, gathering and organizing data)",0.25,1,1.5,{"$f":"SUM(C24:E24)","v":2.75},{"$f":"C24/F24","v":9.0909090909090912E-2},{"$f":"D24/F24","v":0.36363636363636365},{"$f":"E24/F24","v":0.54545454545454541},{"$f":"SUM(G24:I24)","v":1}]
[null,"3. Existing Conditions Analysis",0.5,1.25,2,{"$f":"SUM(C25:E25)","v":3.75},{"$f":"C25/F25","v":0.13333333333333333},{"$f":"D25/F25","v":0.33333333333333331},{"$f":"E25/F25","v":0.53333333333333333},{"$f":"SUM(G25:I25)","v":1}]
[null,"4a.Alternatives Evaluation (CMFs) - Research, select and approval of apporpriate CMFs",0.5,1,1,2.5,0.2,0.4,0.4,1]
[null,"4a. Alternatives Evaluation (CMFs) - Apply CMFs and evaluate outcomes",0.5,1,1.5,{"$f":"SUM(C27:E27)","v":3},{"$f":"C27/F27","v":0.16666666666666666},{"$f":"D27/F27","v":0.33333333333333331},{"$f":"E27/F27","v":0.5},{"$f":"SUM(G27:I27)","v":1}]
[null,"4b. Alternatives Evaluation (Predictive) - Study area segmentation",null,null,null,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"4b. Alternatives Evaluation (Predictive) - Identify and Apply SPFs, CMFs and Local Calibration Factors",0.5,1,1.5,3,{"$f":"C29/F29","v":0.16666666666666666},{"$f":"D29/F29","v":0.33333333333333331},{"$f":"E29/F29","v":0.5},1]
[null,"4b. Alternatives Evaluation (Predictive) - Evaluate Results",0.75,1.5,1.5,3.75,0.2,0.4,0.4,1]
[null,"5. Documentation",0.5,1,1.5,3,0.16666666666666666,0.33333333333333331,0.5,1]
[null,"Total Labor Hours",{"$f":"SUM(C23:C31)","v":4.25},{"$f":"SUM(D23:D31)","v":8.75},{"$f":"SUM(E23:E31)","v":10.5},23.5,0.18085106382978725,0.37234042553191488,0.44680851063829785,1]
[]
["Number of labor hours per average ramp terminal 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"]
[null,"1. Develop workplan, analysis plan, and project management",0.75,1,null,{"$f":"SUM(C37:E37)","v":1.75},{"$f":"C37/F37","v":0.42857142857142855},{"$f":"D37/F37","v":0.5714285714285714},{"$f":"E37/F37","v":0},{"$f":"SUM(G37:I37)","v":1}]
[null,"2. Data Collection and Processing (compiling, gathering and organizing data)",0.25,1,1.5,{"$f":"SUM(C38:E38)","v":2.75},{"$f":"C38/F38","v":9.0909090909090912E-2},{"$f":"D38/F38","v":0.36363636363636365},{"$f":"E38/F38","v":0.54545454545454541},{"$f":"SUM(G38:I38)","v":1}]
[null,"3. Existing Conditions Analysis",0.5,1.25,2,{"$f":"SUM(C39:E39)","v":3.75},{"$f":"C39/F39","v":0.13333333333333333},{"$f":"D39/F39","v":0.33333333333333331},{"$f":"E39/F39","v":0.53333333333333333},{"$f":"SUM(G39:I39)","v":1}]
[null,"4a.Alternatives Evaluation (CMFs) - Research, select and approval of apporpriate CMFs",0.5,1,1,{"$f":"SUM(C40:E40)","v":2.5},{"$f":"C40/F40","v":0.2},{"$f":"D40/F40","v":0.4},{"$f":"E40/F40","v":0.4},{"$f":"SUM(G40:I40)","v":1}]
[null,"4a. Alternatives Evaluation (CMFs) - Apply CMFs and evaluate outcomes",0.5,1,1.5,3,0.16666666666666666,0.33333333333333331,0.5,1]
[null,"4b. Alternatives Evaluation (Predictive) - Study area segmentation",null,null,null,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"4b. Alternatives Evaluation (Predictive) - Identify and Apply SPFs, CMFs and Local Calibration Factors",0.5,1,1.5,3,0.16666666666666666,0.33333333333333331,0.5,1]
[null,"4b. Alternatives Evaluation (Predictive) - Evaluate Results",0.75,1.5,1.5,3.75,0.2,0.4,0.4,1]
[null,"5. Documentation",0.5,1,1.5,3,0.16666666666666666,0.33333333333333331,0.5,1]
[null,"Total Labor Hours",{"$f":"SUM(C37:C45)","v":4.25},{"$f":"SUM(D37:D45)","v":8.75},{"$f":"SUM(E37:E45)","v":10.5},23.5,0.18085106382978725,0.37234042553191488,0.44680851063829785,1]
[]
["Number of labor hours per average roadway/freeway segment:",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"]
[null,"1. Develop workplan, analysis plan, and project management",0.75,1,null,{"$f":"SUM(C51:E51)","v":1.75},{"$f":"C51/F51","v":0.42857142857142855},{"$f":"D51/F51","v":0.5714285714285714},{"$f":"E51/F51","v":0},{"$f":"SUM(G51:I51)","v":1}]
[null,"2. Data Collection and Processing (compiling, gathering and organizing data)",0.25,1.5,2,{"$f":"SUM(C52:E52)","v":3.75},{"$f":"C52/F52","v":6.6666666666666666E-2},{"$f":"D52/F52","v":0.4},{"$f":"E52/F52","v":0.53333333333333333},{"$f":"SUM(G52:I52)","v":1}]
[null,"3. Existing Conditions Analysis",0.5,1.25,2,{"$f":"SUM(C53:E53)","v":3.75},{"$f":"C53/F53","v":0.13333333333333333},{"$f":"D53/F53","v":0.33333333333333331},{"$f":"E53/F53","v":0.53333333333333333},{"$f":"SUM(G53:I53)","v":1}]
[null,"4a.Alternatives Evaluation (CMFs) - Research, select and approval of apporpriate CMFs",0.5,1,1,{"$f":"SUM(C54:E54)","v":2.5},{"$f":"C54/F54","v":0.2},{"$f":"D54/F54","v":0.4},{"$f":"E54/F54","v":0.4},{"$f":"SUM(G54:I54)","v":1}]
[null,"4a. Alternatives Evaluation (CMFs) - Apply CMFs and evaluate outcomes",0.5,1,1.5,3,0.16666666666666666,0.33333333333333331,0.5,1]
[null,"4b. Alternatives Evaluation (Predictive) - Study area segmentation",1,2,2.5,5.5,0.18181818181818182,0.36363636363636365,0.45454545454545453,1]
[null,"4b. Alternatives Evaluation (Predictive) - Identify and Apply SPFs, CMFs and Local Calibration Factors",0.5,1,1.5,3,0.16666666666666666,0.33333333333333331,0.5,1]
[null,"4b. Alternatives Evaluation (Predictive) - Evaluate Results",0.75,1.5,1.5,3.75,0.2,0.4,0.4,1]
[null,"5. Documentation",0.5,1,1.5,3,0.16666666666666666,0.33333333333333331,0.5,1]
[null,"Total Labor Hours",{"$f":"SUM(C51:C59)","v":5.25},{"$f":"SUM(D51:D59)","v":11.25},{"$f":"SUM(E51:E59)","v":13.5},30,0.17499999999999999,0.375,0.45,1]
[]
["Number of labor hours per average ramp segment:",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"]
[null,"1. Develop workplan, analysis plan, and project management",0.75,1,null,{"$f":"SUM(C65:E65)","v":1.75},{"$f":"C65/F65","v":0.42857142857142855},{"$f":"D65/F65","v":0.5714285714285714},{"$f":"E65/F65","v":0},{"$f":"SUM(G65:I65)","v":1}]
[null,"2. Data Collection and Processing (compiling, gathering and organizing data)",0.25,1,1.25,{"$f":"SUM(C66:E66)","v":2.5},{"$f":"C66/F66","v":0.1},{"$f":"D66/F66","v":0.4},{"$f":"E66/F66","v":0.5},{"$f":"SUM(G66:I66)","v":1}]
[null,"3. Existing Conditions Analysis",0.5,1.25,2,{"$f":"SUM(C67:E67)","v":3.75},{"$f":"C67/F67","v":0.13333333333333333},{"$f":"D67/F67","v":0.33333333333333331},{"$f":"E67/F67","v":0.53333333333333333},{"$f":"SUM(G67:I67)","v":1}]
[null,"4a.Alternatives Evaluation (CMFs) - Research, select and approval of apporpriate CMFs",0.5,1,1,{"$f":"SUM(C68:E68)","v":2.5},{"$f":"C68/F68","v":0.2},{"$f":"D68/F68","v":0.4},{"$f":"E68/F68","v":0.4},{"$f":"SUM(G68:I68)","v":1}]
[null,"4a. Alternatives Evaluation (CMFs) - Apply CMFs and evaluate outcomes",0.5,1,1.5,3,0.16666666666666666,0.33333333333333331,0.5,1]
[null,"4b. Alternatives Evaluation (Predictive) - Study area segmentation",0.5,1.25,1.5,3.25,0.15384615384615385,0.38461538461538464,0.46153846153846156,1]
[null,"4b. Alternatives Evaluation (Predictive) - Identify and Apply SPFs, CMFs and Local Calibration Factors",0.25,0.75,1,2,0.125,0.375,0.5,1]
[null,"4b. Alternatives Evaluation (Predictive) - Evaluate Results",0.75,1.5,1.5,3.75,0.2,0.4,0.4,1]
[null,"5. Documentation",0.5,1,1.5,3,0.16666666666666666,0.33333333333333331,0.5,1]
[null,"Total Labor Hours",{"$f":"SUM(C65:C73)","v":4.5},{"$f":"SUM(D65:D73)","v":9.75},{"$f":"SUM(E65:E73)","v":11.25},25.5,0.17647058823529413,0.38235294117647056,0.44117647058823528,1]
[]
[{"$f":"B13","v":"Availability of Baseline/No-Build Data Related to Crash and Roadway (Good, Sufficient, Limited):"}]
[null,"Good",0.8,"for Tasks 2, 3, 4a, 4b"]
[null,"Sufficient",1.2,"for Tasks 2, 3, 4a, 4b"]
[null,"Limited",1.4,"for Tasks 2, 3, 4a, 4b"]
[]
[{"$f":"B15","v":"Complexity of Geometry (Simple, Complex):"}]
[null,"Simple",1,"for all Tasks 1, 2, 3, 4"]
[null,"Complex",1.2,"for all Tasks 1, 2, 3, 4"]
[]
[{"$f":"B17","v":"Project Team Experience (Some, Considerable):"}]
[null,"Some",1.2,"for all Tasks"]
[null,"Considerable",0.9,"for all Tasks"]
[]
["Range"]
["Determine the range for the results on the final output table",null,0.1,"To determine lower/upper bounds of project activities"]
[]
["CALCULATIONS"]
["Total number of labor hours for intersections:",null,null,"Engineer/"]
[null,null,"Manager","Planner","Technician","Total"]
["Project Task",null,"Hours","Hours","Hours","Hours"]
[null,"1. Develop workplan, analysis plan, and project management",{"$f":"$C$9*C23","v":3},4,0,{"$f":"SUM(C96:E96)","v":7}]
[null,"2. Data Collection and Processing (compiling, gathering and organizing data)",1,4,6,{"$f":"SUM(C97:E97)","v":11}]
[null,"3. Existing Conditions Analysis",2,5,8,{"$f":"SUM(C98:E98)","v":15}]
[null,"4a.Alternatives Evaluation (CMFs) - Research, select and approval of apporpriate CMFs",2,4,4,{"$f":"SUM(C99:E99)","v":10}]
[null,"4a. Alternatives Evaluation (CMFs) - Apply CMFs and evaluate outcomes",2,4,6,12]
[null,"4b. Alternatives Evaluation (Predictive) - Study area segmentation",0,0,0,0]
[null,"4b. Alternatives Evaluation (Predictive) - Identify and Apply SPFs, CMFs and Local Calibration Factors",2,4,6,12]
[null,"4b. Alternatives Evaluation (Predictive) - Evaluate Results",3,6,6,15]
[null,"5. Documentation",2,4,6,12]
[null,"Total Labor Hours",{"$f":"SUM(C96:C104)","v":17},{"$f":"SUM(D96:D104)","v":35},{"$f":"SUM(E96:E104)","v":42},94]
[]
["Total number of labor hours for ramp terminal intersections:",null,null,"Engineer/"]
[null,null,"Manager","Planner","Technician","Total"]
["Project Task",null,"Hours","Hours","Hours","Hours"]
[null,"1. Develop workplan, analysis plan, and project management",{"$f":"$C$10*C37","v":1.5},2,0,{"$f":"SUM(C110:E110)","v":3.5}]
[null,"2. Data Collection and Processing (compiling, gathering and organizing data)",0.5,2,3,{"$f":"SUM(C111:E111)","v":5.5}]
[null,"3. Existing Conditions Analysis",1,2.5,4,{"$f":"SUM(C112:E112)","v":7.5}]
[null,"4a.Alternatives Evaluation (CMFs) - Research, select and approval of apporpriate CMFs",1,2,2,{"$f":"SUM(C113:E113)","v":5}]
[null,"4a. Alternatives Evaluation (CMFs) - Apply CMFs and evaluate outcomes",1,2,3,6]
[null,"4b. Alternatives Evaluation (Predictive) - Study area segmentation",0,0,0,0]
[null,"4b. Alternatives Evaluation (Predictive) - Identify and Apply SPFs, CMFs and Local Calibration Factors",1,2,3,6]
[null,"4b. Alternatives Evaluation (Predictive) - Evaluate Results",1.5,3,3,7.5]
[null,"5. Documentation",1,2,3,6]
[null,"Total Labor Hours",{"$f":"SUM(C110:C118)","v":8.5},{"$f":"SUM(D110:D118)","v":17.5},{"$f":"SUM(E110:E118)","v":21},47]
[]
["Total number of labor hours for roadway/freeway segments:",null,null,"Engineer/"]
[null,null,"Manager","Planner","Technician","Total"]
["Project Task",null,"Hours","Hours","Hours","Hours"]
[null,"1. Develop workplan, analysis plan, and project management",{"$f":"$C$11*C51","v":3},4,0,{"$f":"SUM(C124:E124)","v":7}]
[null,"2. Data Collection and Processing (compiling, gathering and organizing data)",1,6,8,{"$f":"SUM(C125:E125)","v":15}]
[null,"3. Existing Conditions Analysis",2,5,8,{"$f":"SUM(C126:E126)","v":15}]
[null,"4a.Alternatives Evaluation (CMFs) - Research, select and approval of apporpriate CMFs",2,4,4,{"$f":"SUM(C127:E127)","v":10}]
[null,"4a. Alternatives Evaluation (CMFs) - Apply CMFs and evaluate outcomes",2,4,6,12]
[null,"4b. Alternatives Evaluation (Predictive) - Study area segmentation",4,8,10,22]
[null,"4b. Alternatives Evaluation (Predictive) - Identify and Apply SPFs, CMFs and Local Calibration Factors",2,4,6,12]
[null,"4b. Alternatives Evaluation (Predictive) - Evaluate Results",3,6,6,15]
[null,"5. Documentation",2,4,6,12]
[null,"Total Labor Hours",{"$f":"SUM(C124:C132)","v":21},{"$f":"SUM(D124:D132)","v":45},{"$f":"SUM(E124:E132)","v":54},120]
[]
["Total number of labor hours for ramp segments:",null,null,"Engineer/"]
[null,null,"Manager","Planner","Technician","Total"]
["Project Task",null,"Hours","Hours","Hours","Hours"]
[null,"1. Develop workplan, analysis plan, and project management",{"$f":"$C$12*C65","v":1.5},2,0,{"$f":"SUM(C138:E138)","v":3.5}]
[null,"2. Data Collection and Processing (compiling, gathering and organizing data)",0.5,2,2.5,{"$f":"SUM(C139:E139)","v":5}]
[null,"3. Existing Conditions Analysis",1,2.5,4,{"$f":"SUM(C140:E140)","v":7.5}]
[null,"4a.Alternatives Evaluation (CMFs) - Research, select and approval of apporpriate CMFs",1,2,2,{"$f":"SUM(C141:E141)","v":5}]
[null,"4a. Alternatives Evaluation (CMFs) - Apply CMFs and evaluate outcomes",1,2,3,6]
[null,"4b. Alternatives Evaluation (Predictive) - Study area segmentation",1,2.5,3,6.5]
[null,"4b. Alternatives Evaluation (Predictive) - Identify and Apply SPFs, CMFs and Local Calibration Factors",0.5,1.5,2,4]
[null,"4b. Alternatives Evaluation (Predictive) - Evaluate Results",1.5,3,3,7.5]
[null,"5. Documentation",1,2,3,6]
[null,"Total Labor Hours",{"$f":"SUM(C138:C146)","v":9},{"$f":"SUM(D138:D146)","v":19.5},{"$f":"SUM(E138:E146)","v":22.5},51]
[]
["Total number of labor hours (Intersections + Ramp Terminal Intersections + Roadway/Freeway Segments + Ramp Segments):",null,null,"Engineer/"]
[null,null,"Manager","Planner","Technician","Total"]
["Project Task",null,"Hours","Hours","Hours","Hours"]
[null,"1. Develop workplan, analysis plan, and project management",{"$f":"C96+C110+C124+C138","v":9},{"$f":"D96+D110+D124+D138","v":12},0,{"$f":"SUM(C152:E152)","v":21}]
[null,"2. Data Collection and Processing (compiling, gathering and organizing data)",{"$f":"C97+C111+C125+C139","v":3},14,19.5,{"$f":"SUM(C153:E153)","v":36.5}]
[null,"3. Existing Conditions Analysis",{"$f":"C98+C112+C126+C140","v":6},15,24,{"$f":"SUM(C154:E154)","v":45}]
[null,"4a.Alternatives Evaluation (CMFs) - Research, select and approval of apporpriate CMFs",{"$f":"C99+C113+C127+C141","v":6},12,12,{"$f":"SUM(C155:E155)","v":30}]
[null,"4a. Alternatives Evaluation (CMFs) - Apply CMFs and evaluate outcomes",{"$f":"C100+C114+C128+C142","v":6},12,18,36]
[null,"4b. Alternatives Evaluation (Predictive) - Study area segmentation",{"$f":"C101+C115+C129+C143","v":5},10.5,13,28.5]
[null,"4b. Alternatives Evaluation (Predictive) - Identify and Apply SPFs, CMFs and Local Calibration Factors",{"$f":"C102+C116+C130+C144","v":5.5},11.5,17,34]
[null,"4b. Alternatives Evaluation (Predictive) - Evaluate Results",{"$f":"C103+C117+C131+C145","v":9},18,18,45]
[null,"5. Documentation",{"$f":"C104+C118+C132+C146","v":6},12,18,36]
[null,"Total Labor Hours",{"$f":"SUM(C152:C160)","v":55.5},{"$f":"SUM(D152:D160)","v":117},{"$f":"SUM(E152:E160)","v":139.5},312]
[]
["Adjustment for Availability of Baseline/No-Build Data Related to Crash and Roadway:",null,null,"Engineer/"]
[null,null,"Manager","Planner","Technician","Total"]
["Project Task",null,"Hours","Hours","Hours","Hours"]
[null,"2. Data Collection and Processing (compiling, gathering and organizing data)",{"$f":"(VLOOKUP($C$13,$B$77:$C$79,2,FALSE)-1)*C153","v":0.59999999999999987},{"$f":"(VLOOKUP($C$13,$B$77:$C$79,2,FALSE)-1)*D153","v":2.7999999999999994},3.899999999999999,{"$f":"SUM(C166:E166)","v":7.2999999999999989}]
[null,{"$f":"B25","v":"3. Existing Conditions Analysis"},{"$f":"(VLOOKUP($C$13,$B$77:$C$79,2,FALSE)-1)*C154","v":1.1999999999999997},{"$f":"(VLOOKUP($C$13,$B$77:$C$79,2,FALSE)-1)*D154","v":2.9999999999999991},4.7999999999999989,{"$f":"SUM(C167:E167)","v":8.9999999999999982}]
[null,"4a.Alternatives Evaluation (CMFs) - Research, select and approval of apporpriate CMFs",{"$f":"(VLOOKUP($C$13,$B$77:$C$79,2,FALSE)-1)*C155","v":1.1999999999999997},{"$f":"(VLOOKUP($C$13,$B$77:$C$79,2,FALSE)-1)*D155","v":2.3999999999999995},2.3999999999999995,{"$f":"SUM(C168:E168)","v":5.9999999999999982}]
[null,"4b. Alternatives Evaluation (Predictive) - Study area segmentation",{"$f":"(VLOOKUP($C$13,$B$77:$C$79,2,FALSE)-1)*C157","v":0.99999999999999978},{"$f":"(VLOOKUP($C$13,$B$77:$C$79,2,FALSE)-1)*D157","v":2.0999999999999996},2.5999999999999996,5.6999999999999993]
[]
["Adjustment for Complexity of Geometry:",null,null,"Engineer/"]
[null,null,"Manager","Planner","Technician","Total"]
["Project Task",null,"Hours","Hours","Hours","Hours"]
[null,"1. Develop workplan, analysis plan, and project management",{"$f":"(VLOOKUP($C$15,$B$82:$C$83,2,FALSE)-1)*C152","v":0},{"$f":"(VLOOKUP($C$15,$B$82:$C$83,2,FALSE)-1)*D152","v":0},0,{"$f":"SUM(C174:E174)","v":0}]
[null,"2. Data Collection and Processing (compiling, gathering and organizing data)",{"$f":"(VLOOKUP($C$15,$B$82:$C$83,2,FALSE)-1)*C153","v":0},0,0,{"$f":"SUM(C175:E175)","v":0}]
[null,"3. Existing Conditions Analysis",{"$f":"(VLOOKUP($C$15,$B$82:$C$83,2,FALSE)-1)*C154","v":0},{"$f":"(VLOOKUP($C$15,$B$82:$C$83,2,FALSE)-1)*D154","v":0},0,{"$f":"SUM(C176:E176)","v":0}]
[null,"4a.Alternatives Evaluation (CMFs) - Research, select and approval of apporpriate CMFs",0,{"$f":"(VLOOKUP($C$15,$B$82:$C$83,2,FALSE)-1)*D155","v":0},0,0]
[null,"4a. Alternatives Evaluation (CMFs) - Apply CMFs and evaluate outcomes",0,0,0,0]
[null,"4b. Alternatives Evaluation (Predictive) - Study area segmentation",0,0,0,0]
[null,"4b. Alternatives Evaluation (Predictive) - Identify and Apply SPFs, CMFs and Local Calibration Factors",0,0,0,0]
[null,"4b. Alternatives Evaluation (Predictive) - Evaluate Results",0,0,0,0]
[]
["Adjustment for Analyst Experience:",null,null,"Engineer/"]
[null,null,"Manager","Planner","Technician","Total"]
["Project Task",null,"Hours","Hours","Hours","Hours"]
[null,"1. Develop workplan, analysis plan, and project management",{"$f":"(VLOOKUP($C$17,$B$86:$C$87,2,FALSE)-1)*C152","v":1.7999999999999996},2.3999999999999995,0,{"$f":"SUM(C186:E186)","v":4.1999999999999993}]
[null,"2. Data Collection and Processing (compiling, gathering and organizing data)",0.59999999999999987,2.7999999999999994,3.899999999999999,{"$f":"SUM(C187:E187)","v":7.2999999999999989}]
[null,"3. Existing Conditions Analysis",1.1999999999999997,2.9999999999999991,4.7999999999999989,{"$f":"SUM(C188:E188)","v":8.9999999999999982}]
[null,"4a.Alternatives Evaluation (CMFs) - Research, select and approval of apporpriate CMFs",1.1999999999999997,2.3999999999999995,2.3999999999999995,{"$f":"SUM(C189:E189)","v":5.9999999999999982}]
[null,"4a. Alternatives Evaluation (CMFs) - Apply CMFs and evaluate outcomes",1.1999999999999997,2.3999999999999995,3.5999999999999992,7.1999999999999984]
[null,"4b. Alternatives Evaluation (Predictive) - Study area segmentation",0.99999999999999978,2.0999999999999996,2.5999999999999996,5.6999999999999993]
[null,"4b. Alternatives Evaluation (Predictive) - Identify and Apply SPFs, CMFs and Local Calibration Factors",1.0999999999999996,2.2999999999999994,3.3999999999999995,6.7999999999999989]
[null,"4b. Alternatives Evaluation (Predictive) - Evaluate Results",1.7999999999999996,3.5999999999999992,3.5999999999999992,8.9999999999999982]
[null,"5. Documentation",1.1999999999999997,2.3999999999999995,3.5999999999999992,7.1999999999999984]
[]
["Project specific total number of labor hours",null,null,"Engineer/"]
[null,null,"Manager","Planner","Technician","Total"]
["Project Task",null,"Hours","Hours","Hours","Hours"]
[null,"1. Develop workplan, analysis plan, and project management",{"$f":"C152+C174+C186","v":10.799999999999999},14.399999999999999,0,{"$f":"SUM(C199:E199)","v":25.199999999999996},{"$f":"F199*(1-$C$90)","v":22.679999999999996},{"$f":"F199*(1+$C$90)","v":27.72}]
[null,"2. Data Collection and Processing (compiling, gathering and organizing data)",3.5999999999999996,16.8,23.4,{"$f":"SUM(C200:E200)","v":43.8},{"$f":"F200*(1-$C$90)","v":39.42},{"$f":"F200*(1+$C$90)","v":48.18}]
[null,"3. Existing Conditions Analysis",{"$f":"C154+C167+C188","v":8.3999999999999986},{"$f":"D154+D167+D188","v":21},{"$f":"E154+E167+E188","v":33.599999999999994},{"$f":"SUM(C201:E201)","v":62.999999999999993},56.699999999999996,69.3]
[null,"4a.Alternatives Evaluation (CMFs) - Research, select and approval of apporpriate CMFs",{"$f":"IF($C$16=\"CMFs\",C155+C177+C189,0)*$C$14","v":21.599999999999998},{"$f":"IF($C$16=\"CMFs\",D155+D177+D189,0)*$C$14","v":43.199999999999996},43.199999999999996,{"$f":"SUM(C202:E202)","v":108},97.2,118.80000000000001]
[null,"4a. Alternatives Evaluation (CMFs) - Apply CMFs and evaluate outcomes",{"$f":"IF($C$16=\"CMFs\",C156+C178+C190,0)*$C$14","v":21.599999999999998},43.199999999999996,64.8,129.6,116.64,142.56]
[null,"4b. Alternatives Evaluation (Predictive) - Study area segmentation",{"$f":"IF($C$16=\"Predictive Method\",C157+C179+C191,0)*$C$14","v":0},{"$f":"IF($C$16=\"Predictive Method\",D157+D179+D191,0)*$C$14","v":0},0,{"$f":"SUM(C204:E204)","v":0},0,0]
[null,"4b. Alternatives Evaluation (Predictive) - Identify and Apply SPFs, CMFs and Local Calibration Factors",{"$f":"IF($C$16=\"Predictive Method\",C158+C180+C192,0)*$C$14","v":0},0,0,0,0,0]
[null,"4b. Alternatives Evaluation (Predictive) - Evaluate Results",{"$f":"IF($C$16=\"Predictive Method\",C159+C181+C193,0)*$C$14","v":0},0,0,0,0,0]
[null,"5. Documentation",{"$f":"C160+C194","v":7.1999999999999993},{"$f":"D160+D194","v":14.399999999999999},{"$f":"E160+E194","v":21.599999999999998},43.199999999999996,38.879999999999995,47.519999999999996]
[null,"Total Labor Hours",{"$f":"SUM(C199:C207)","v":73.199999999999989},{"$f":"SUM(D199:D207)","v":153},{"$f":"SUM(E199:E207)","v":186.6},412.79999999999995,371.52,454.08]

{"sheet":"Output","index":3,"n_rows":16,"n_cols":8,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"Input!B1","v":"Safety Analysis Costing Tool"},null,null,null,"Developed for :"]
[]
["OUTPUT REPORT"]
["Estimate of Labor Hours Required to Complete the Analysis of:"]
[null,{"$f":"Input!$C$10","v":"Test"}]
[]
["Task specific number of labor hours"]
[null,null,null,"Engineer/"]
[null,null,"Manager","Planner","Technician","Total","Lower","Upper"]
[null,null,"Hours","Hours","Hours","Hours","Bound","Bound"]
[null,"1 - Develop workplan, analysis plan, and project management",{"$f":"Calculations!C199","v":10.799999999999999},{"$f":"Calculations!D199","v":14.399999999999999},{"$f":"Calculations!E199","v":0},{"$f":"Calculations!F199","v":25.199999999999996},{"$f":"Calculations!G199","v":22.679999999999996},{"$f":"Calculations!H199","v":27.72}]
[null,"2 - Data collection and processing",{"$f":"Calculations!C200","v":3.5999999999999996},{"$f":"Calculations!D200","v":16.8},{"$f":"Calculations!E200","v":23.4},{"$f":"Calculations!F200","v":43.8},{"$f":"Calculations!G200","v":39.42},{"$f":"Calculations!H200","v":48.18}]
[null,"3 - Analysis - Existing Conditions",{"$f":"Calculations!C201","v":8.3999999999999986},{"$f":"Calculations!D201","v":21},{"$f":"Calculations!E201","v":33.599999999999994},{"$f":"Calculations!F201","v":62.999999999999993},{"$f":"Calculations!G201","v":56.699999999999996},{"$f":"Calculations!H201","v":69.3}]
[null,"4 - Analysis - Alternatives",{"$f":"SUM(Calculations!C202:C206)","v":43.199999999999996},{"$f":"SUM(Calculations!D202:D206)","v":86.399999999999991},{"$f":"SUM(Calculations!E202:E206)","v":108},{"$f":"SUM(Calculations!F202:F206)","v":237.6},{"$f":"SUM(Calculations!G202:G206)","v":213.84},{"$f":"SUM(Calculations!H202:H206)","v":261.36}]
[null,"5 - Documentation",{"$f":"Calculations!C207","v":7.1999999999999993},{"$f":"Calculations!D207","v":14.399999999999999},{"$f":"Calculations!E207","v":21.599999999999998},{"$f":"Calculations!F207","v":43.199999999999996},{"$f":"Calculations!G207","v":38.879999999999995},{"$f":"Calculations!H207","v":47.519999999999996}]
[null,"Total Labor Hours",{"$f":"SUM(C11:C15)","v":73.2},{"$f":"SUM(D11:D15)","v":153},186.6,412.8,371.52,454.08]