{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Form 750-020-08b - Field Data ","Form 750-020-08b - Analysis"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":2,"defined_names":32,"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":"Form 750-020-08b - Field Data ","index":0,"n_rows":67,"n_cols":61,"rows_kept":67,"cut":false,"hidden":false,"merged":[[60,0,63,0],[60,1,61,2],[62,1,63,2],[44,0,47,0],[48,0,51,0],[52,0,55,0],[56,0,59,0],[56,1,57,2],[58,1,59,2],[10,3,10,23],[11,3,11,23],[52,1,53,2],[54,1,55,2],[42,1,43,2],[44,1,45,2],[46,1,47,2],[48,1,49,2],[50,1,51,2],[16,0,19,0],[32,0,35,0],[32,1,33,2],[34,1,35,2],[36,0,39,0],[40,0,43,0],[40,1,41,2],[20,1,21,2],[22,1,23,2],[24,1,25,2],[36,1,37,2],[38,1,39,2],[28,1,29,2],[30,1,31,2],[26,1,27,2],[30,53,31,58],[0,0,0,58],[1,0,1,58],[2,0,2,58],[16,53,17,58],[18,53,19,58],[20,0,23,0],[24,0,27,0],[16,1,17,2],[18,1,19,2],[28,0,31,0],[20,53,21,58],[22,53,23,58],[24,53,25,58],[26,53,27,58],[28,53,29,58],[50,53,51,58],[32,53,33,58],[34,53,35,58],[36,53,37,58],[38,53,39,58],[40,53,41,58],[62,53,63,58],[13,0,13,58],[65,37,65,40],[65,14,65,36],[66,37,66,40],[66,14,66,36],[64,0,64,58],[52,53,53,58],[54,53,55,58],[56,53,57,58],[58,53,59,58],[60,53,61,58],[42,53,43,58],[44,53,45,58],[46,53,47,58],[48,53,49,58],[7,12,7,17],[3,26,3,58],[3,0,3,25],[6,3,6,23],[7,18,7,23],[7,3,7,11],[5,37,5,57],[6,37,6,57],[7,37,7,57],[14,53,15,58],[14,3,15,52],[14,0,15,0],[14,1,15,2],[11,42,11,53],[8,46,8,47],[8,37,8,45],[8,48,8,57],[9,3,9,11],[9,12,9,17],[9,18,9,23],[9,37,9,57],[8,3,8,23]]}
[]
["State of Florida Department of Transportation"]
["VEHICULAR GAP STUDY -  FIELD DATA"]
["SITE INFORMATION",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STUDY INFORMATION"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"="]
["Study Location",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Agency/Company"]
["Major Street",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Analyst "]
["   Roadway ID",null,null,null,null,null,null,null,null,null,null,null,"Milepost",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date Performed",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
["Minor Street",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Analysis Period",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"To: "]
["   Roadway ID",null,null,null,null,null,null,null,null,null,null,null,"Milepost",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Posted Speed Limit"]
["City",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
["County ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gap Interval (in seconds)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[]
["FIELD DATA COLLECTION"]
["GAP SIZE (SEC)",null,null,"NUMBER OF GAPS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SUM"]
[]
[1,"Accept",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D17:BA18)","v":0}]
[]
[null,"Reject",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D19:BA20)","v":0}]
[]
[{"$f":"A17+$AQ$12","v":2},"Accept",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D21:BA22)","v":0}]
[]
[null,"Reject",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D23:BA24)","v":0}]
[]
[{"$f":"A21+$AQ$12","v":3},"Accept",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D25:BA26)","v":0}]
[]
[null,"Reject",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D27:BA28)","v":0}]
[]
[{"$f":"A25+$AQ$12","v":4},"Accept",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D29:BA30)","v":0}]
[]
[null,"Reject",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D31:BA32)","v":0}]
[]
[{"$f":"A29+$AQ$12","v":5},"Accept",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D33:BA34)","v":0}]
[]
[null,"Reject",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D35:BA36)","v":0}]
[]
[{"$f":"A33+$AQ$12","v":6},"Accept",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D37:BA38)","v":0}]
[]
[null,"Reject",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D39:BA40)","v":0}]
[]
[{"$f":"A37+$AQ$12","v":7},"Accept",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D41:BA42)","v":0}]
[]
[null,"Reject",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D43:BA44)","v":0}]
[]
[{"$f":"A41+$AQ$12","v":8},"Accept",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D45:BA46)","v":0}]
[]
[null,"Reject",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D47:BA48)","v":0}]
[]
[{"$f":"A45+$AQ$12","v":9},"Accept",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D49:BA50)","v":0}]
[]
[null,"Reject",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D51:BA52)","v":0}]
[]
[{"$f":"A49+$AQ$12","v":10},"Accept",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D53:BA54)","v":0}]
[]
[null,"Reject",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D55:BA56)","v":0}]
[]
[{"$f":"A53+$AQ$12","v":11},"Accept",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D57:BA58)","v":0}]
[]
[null,"Reject",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D59:BA60)","v":0}]
[]
[{"$f":"A57+$AQ$12","v":12},"Accept",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D61:BA62)","v":0}]
[]
[null,"Reject",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D63:BA64)","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL ACCEPTED GAPS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(BB17,BB21,BB25,BB29,BB33,BB37,BB41,BB45,BB49,BB53,BB57,BB61)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL REJECTED GAPS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(BB19,BB23,BB27,BB31,BB35,BB39,BB43,BB47,BB51,BB55,BB59,BB63)","v":0}]

{"sheet":"Form 750-020-08b - Analysis","index":1,"n_rows":58,"n_cols":41,"rows_kept":58,"cut":false,"hidden":false,"merged":[[19,37,19,38],[57,0,58,0],[57,1,58,34],[3,0,3,13],[3,16,3,38],[7,1,7,4],[13,0,13,38],[11,28,11,34],[8,25,8,28],[11,1,11,13],[5,25,5,37],[6,25,6,37],[7,25,7,37],[10,1,10,13],[9,1,9,4],[9,10,9,13],[0,0,0,38],[1,0,1,38],[2,0,2,38],[9,25,9,37],[8,34,8,37],[6,1,6,13],[7,10,7,13],[8,1,8,13]]}
[]
["State of Florida Department of Transportation"]
["VEHICULAR GAP STUDY -  ANALYSIS SHEET"]
["SITE INFORMATION",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STUDY INFORMATION"]
[]
["Study Location",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date Performed",null,null,null,null,null,null,null,null,{"$f":"'Form 750-020-08b - Field Data '!AL6","v":"00:00:00"}]
["Major Street",{"$f":"'Form 750-020-08b - Field Data '!D7","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Analyst",null,null,null,null,null,null,null,null,{"$f":"'Form 750-020-08b - Field Data '!AL7","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
["   Roadway ID",{"$f":"'Form 750-020-08b - Field Data '!D8","v":0},null,null,null,null,null,"Milepost",null,null,{"$f":"'Form 750-020-08b - Field Data '!S8","v":0},null,null,null,null,null,"Agency/Company",null,null,null,null,null,null,null,null,{"$f":"'Form 750-020-08b - Field Data '!AL8","v":0}]
["Minor Street",{"$f":"'Form 750-020-08b - Field Data '!D9","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Analysis Period",null,null,null,null,null,null,null,null,{"$f":"'Form 750-020-08b - Field Data '!AL9","v":"00:00:00"},null,null,null,null,null,"To:",null,null,{"$f":"'Form 750-020-08b - Field Data '!AW9","v":"00:00:00"}]
["   Roadway ID",{"$f":"'Form 750-020-08b - Field Data '!D10","v":0},null,null,null,null,null,"Milepost",null,null,{"$f":"'Form 750-020-08b - Field Data '!S10","v":0},null,null,null,null,null,"Posted Speed Limit",null,null,null,null,null,null,null,null,{"$f":"'Form 750-020-08b - Field Data '!AL10","v":0}]
["City",{"$f":"'Form 750-020-08b - Field Data '!D11","v":0}]
["County ",{"$f":"'Form 750-020-08b - Field Data '!D12","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gap Interval (in seconds)",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Form 750-020-08b - Field Data '!AQ12","v":1}]
[]
["CRITICAL GAP CALCULATIONS"]
["Gap Size (sec) ",{"$f":"'Form 750-020-08b - Field Data '!A17","v":1},null,null,{"$f":"'Form 750-020-08b - Field Data '!A21","v":2},null,null,{"$f":"'Form 750-020-08b - Field Data '!A25","v":3},null,null,{"$f":"'Form 750-020-08b - Field Data '!A29","v":4},null,null,{"$f":"'Form 750-020-08b - Field Data '!A33","v":5},null,null,{"$f":"'Form 750-020-08b - Field Data '!A37","v":6},null,null,{"$f":"'Form 750-020-08b - Field Data '!A41","v":7},null,null,{"$f":"'Form 750-020-08b - Field Data '!A45","v":8},null,null,{"$f":"'Form 750-020-08b - Field Data '!A49","v":9},null,null,{"$f":"'Form 750-020-08b - Field Data '!A53","v":10},null,null,{"$f":"'Form 750-020-08b - Field Data '!A57","v":11},null,null,{"$f":"'Form 750-020-08b - Field Data '!A61","v":12},null,null,"TOTAL"]
["Number of Accepted Gaps",{"$f":"'Form 750-020-08b - Field Data '!BB17","v":0},null,null,{"$f":"'Form 750-020-08b - Field Data '!BB21","v":0},null,null,{"$f":"'Form 750-020-08b - Field Data '!BB25","v":0},null,null,{"$f":"'Form 750-020-08b - Field Data '!BB29","v":0},null,null,{"$f":"'Form 750-020-08b - Field Data '!BB33","v":0},null,null,{"$f":"'Form 750-020-08b - Field Data '!BB37","v":0},null,null,{"$f":"'Form 750-020-08b - Field Data '!BB41","v":0},null,null,{"$f":"'Form 750-020-08b - Field Data '!BB45","v":0},null,null,{"$f":"'Form 750-020-08b - Field Data '!BB49","v":0},null,null,{"$f":"'Form 750-020-08b - Field Data '!BB53","v":0},null,null,{"$f":"'Form 750-020-08b - Field Data '!BB57","v":0},null,null,{"$f":"'Form 750-020-08b - Field Data '!BB61","v":0},null,null,{"$f":"SUM(B16:AI16)","v":0}]
["Number of Rejected Gaps",{"$f":"'Form 750-020-08b - Field Data '!BB19","v":0},null,null,{"$f":"'Form 750-020-08b - Field Data '!BB23","v":0},null,null,{"$f":"'Form 750-020-08b - Field Data '!BB27","v":0},null,null,{"$f":"'Form 750-020-08b - Field Data '!BB31","v":0},null,null,{"$f":"'Form 750-020-08b - Field Data '!BB35","v":0},null,null,{"$f":"'Form 750-020-08b - Field Data '!BB39","v":0},null,null,{"$f":"'Form 750-020-08b - Field Data '!BB43","v":0},null,null,{"$f":"'Form 750-020-08b - Field Data '!BB47","v":0},null,null,{"$f":"'Form 750-020-08b - Field Data '!BB51","v":0},null,null,{"$f":"'Form 750-020-08b - Field Data '!BB55","v":0},null,null,{"$f":"'Form 750-020-08b - Field Data '!BB59","v":0},null,null,{"$f":"'Form 750-020-08b - Field Data '!BB63","v":0},null,null,{"$f":"SUM(B17:AI17)","v":0}]
["Total Recorded Gaps (Accepted + Rejected)",{"$f":"SUM(B16:B17)","v":0},null,null,{"$f":"SUM(E16:E17)","v":0},null,null,{"$f":"SUM(H16:H17)","v":0},null,null,{"$f":"SUM(K16:K17)","v":0},null,null,{"$f":"SUM(N16:N17)","v":0},null,null,{"$f":"SUM(Q16:Q17)","v":0},null,null,{"$f":"SUM(T16:T17)","v":0},null,null,{"$f":"SUM(W16:W17)","v":0},null,null,{"$f":"SUM(Z16:Z17)","v":0},null,null,{"$f":"SUM(AC16:AC17)","v":0},null,null,{"$f":"SUM(AF16:AF17)","v":0},null,null,{"$f":"SUM(AI16:AI17)","v":0},null,null,{"$f":"SUM(AL16:AL17)","v":0}]
[]
["Increasing Proportion Check",{"$f":"IF(B18>0,B16/B18,)","v":0},null,null,{"$f":"IF(E18>0,E16/E18,)","v":0},null,null,{"$f":"IF(H18>0,H16/H18,)","v":0},null,null,{"$f":"IF(K18>0,K16/K18,)","v":0},null,null,{"$f":"IF(N18>0,N16/N18,)","v":0},null,null,{"$f":"IF(Q18>0,Q16/Q18,)","v":0},null,null,{"$f":"IF(T18>0,T16/T18,)","v":0},null,null,{"$f":"IF(W18>0,W16/W18,)","v":0},null,null,{"$f":"IF(Z18>0,Z16/Z18,)","v":0},null,null,{"$f":"IF(AC18>0,AC16/AC18,)","v":0},null,null,{"$f":"IF(AF18>0,AF16/AF18,)","v":0},null,null,{"$f":"IF(AI18>0,AI16/AI18,)","v":0},null,null,{"$f":"IF(A21>0,\"NO\",\"YES\")","v":"YES"}]
[{"$f":"COUNTIF(B21:AF21,\"<0\")","v":0},{"$f":"IF(E18>0,E20-B20,IF(H18>0,H20-B20,IF(K18>0,K20-B20,IF(N18>0,N20-B20,IF(Q18>0,Q20-B20,IF(T18>0,T20-B20,IF(W18>0,W20-B20,IF(Z18>0,Z20-B20,IF(AC18>0,AC20-B20,IF(AF18>0,AF20-B20,IF(AI18>0,AI20-B20,0)))))))))))","v":0},null,null,{"$f":"IF(H18>0,H20-E20,IF(K18>0,K20-E20,IF(N18>0,N20-E20,IF(Q18>0,Q20-E20,IF(T18>0,T20-E20,IF(W18>0,W20-E20,IF(Z18>0,Z20-E20,IF(AC18>0,AC20-E20,IF(AF18>0,AF20-E20,IF(AI18>0,AI20-E20,0))))))))))","v":0},null,null,{"$f":"IF(K18>0,K20-H20,IF(N18>0,N20-H20,IF(Q18>0,Q20-H20,IF(T18>0,T20-H20,IF(W18>0,W20-H20,IF(Z18>0,Z20-H20,IF(AC18>0,AC20-H20,IF(AF18>0,AF20-H20,IF(AI18>0,AI20-H20,0)))))))))","v":0},null,null,{"$f":"IF(N18>0,N20-K20,IF(Q18>0,Q20-K20,IF(T18>0,T20-K20,IF(W18>0,W20-K20,IF(Z18>0,Z20-K20,IF(AC18>0,AC20-K20,IF(AF18>0,AF20-K20,IF(AI18>0,AI20-K20,0))))))))","v":0},null,null,{"$f":"IF(Q18>0,Q20-N20,IF(T18>0,T20-N20,IF(W18>0,W20-N20,IF(Z18>0,Z20-N20,IF(AC18>0,AC20-N20,IF(AF18>0,AF20-N20,IF(AI18>0,AI20-N20,0)))))))","v":0},null,null,{"$f":"IF(T18>0,T20-Q20,IF(W18>0,W20-Q20,IF(Z18>0,Z20-Q20,IF(AC18>0,AC20-Q20,IF(AF18>0,AF20-Q20,IF(AI18>0,AI20-Q20,0))))))","v":0},null,null,{"$f":"IF(W18>0,W20-T20,IF(Z18>0,Z20-T20,IF(AC18>0,AC20-T20,IF(AF18>0,AF20-T20,IF(AI18>0,AI20-T20,0)))))","v":0},null,null,{"$f":"IF(Z18>0,Z20-W20,IF(AC18>0,AC20-W20,IF(AF18>0,AF20-W20,IF(AI18>0,AI20-W20,0))))","v":0},null,null,{"$f":"IF(AC18>0,AC20-Z20,IF(AF18>0,AF20-Z20,IF(AI18>0,AI20-Z20,0)))","v":0},null,null,{"$f":"IF(AF18>0,AF20-AC20,IF(AI18>0,AI20-AC20,0))","v":0},null,null,{"$f":"IF(AI18>0,AI20-AF20,0)","v":0}]
[]
["Selected Gap Interval (sec)",{"$f":"'Form 750-020-08b - Field Data '!AQ12","v":1}]
[null,"A",null,null,"B",null,null,"C",null,null,"D",null,null,"E",null,null,"F",null,null,"G",null,null,"H",null,null,"I",null,null,"J",null,null,"K",null,null,"L"]
["Critical Gap (sec)",0,null,null,{"$f":"B25+$B$23","v":1},null,null,{"$f":"E25+$B$23","v":2},null,null,{"$f":"H25+$B$23","v":3},null,null,{"$f":"K25+$B$23","v":4},null,null,{"$f":"N25+$B$23","v":5},null,null,{"$f":"Q25+$B$23","v":6},null,null,{"$f":"T25+$B$23","v":7},null,null,{"$f":"W25+$B$23","v":8},null,null,{"$f":"Z25+$B$23","v":9},null,null,{"$f":"AC25+$B$23","v":10},null,null,{"$f":"AF25+$B$23","v":11}]
["Accepted Gap (sec)"]
[{"$f":"B15","v":1},{"$f":"IFERROR(B$18/$AL$18*100,0)","v":0},{"$f":"IF($A27>B$25,1,0)","v":1},{"$f":"IF(C27=0,$B27,)","v":0},{"$f":"IFERROR(IF(F27=0,0,$B27/(100-SUM(G$27:G$38))*100),0)","v":0},{"$f":"IF($A27>E$25,1,0)","v":0},{"$f":"IF(F27=0,$B27,)","v":0},{"$f":"IFERROR(IF(I27=0,0,$B27/(100-SUM(J$27:J$38))*100),0)","v":0},{"$f":"IF($A27>H$25,1,0)","v":0},{"$f":"IF(I27=0,$B27,)","v":0},{"$f":"IFERROR(IF(L27=0,0,$B27/(100-SUM(M$27:M$38))*100),0)","v":0},{"$f":"IF($A27>K$25,1,0)","v":0},{"$f":"IF(L27=0,$B27,)","v":0},{"$f":"IFERROR(IF(O27=0,0,$B27/(100-SUM(P$27:P$38))*100),0)","v":0},{"$f":"IF($A27>N$25,1,0)","v":0},{"$f":"IF(O27=0,$B27,)","v":0},{"$f":"IFERROR(IF(R27=0,0,$B27/(100-SUM(S$27:S$38))*100),0)","v":0},{"$f":"IF($A27>Q$25,1,0)","v":0},{"$f":"IF(R27=0,$B27,)","v":0},{"$f":"IFERROR(IF(U27=0,0,$B27/(100-SUM(V$27:V$38))*100),0)","v":0},{"$f":"IF($A27>T$25,1,0)","v":0},{"$f":"IF(U27=0,$B27,)","v":0},{"$f":"IFERROR(IF(X27=0,0,$B27/(100-SUM(Y$27:Y$38))*100),0)","v":0},{"$f":"IF($A27>W$25,1,0)","v":0},{"$f":"IF(X27=0,$B27,)","v":0},{"$f":"IFERROR(IF(AA27=0,0,$B27/(100-SUM(AB$27:AB$38))*100),0)","v":0},{"$f":"IF($A27>Z$25,1,0)","v":0},{"$f":"IF(AA27=0,$B27,)","v":0},{"$f":"IFERROR(IF(AD27=0,0,$B27/(100-SUM(AE$27:AE$38))*100),0)","v":0},{"$f":"IF($A27>AC$25,1,0)","v":0},{"$f":"IF(AD27=0,$B27,)","v":0},{"$f":"IFERROR(IF(AG27=0,0,$B27/(100-SUM(AH$27:AH$38))*100),0)","v":0},{"$f":"IF($A27>AF$25,1,0)","v":0},{"$f":"IF(AG27=0,$B27,)","v":0},{"$f":"IFERROR(IF(AJ27=0,0,$B27/(100-SUM(AK$27:AK$38))*100),0)","v":0},{"$f":"IF($A27>AI$25,1,0)","v":0},{"$f":"IF(AJ27=0,$B27,)","v":0}]
[{"$f":"E15","v":2},{"$f":"IFERROR(E$18/$AL$18*100,0)","v":0},1,{"$f":"IF(C28=0,$B28,)","v":0},{"$f":"IFERROR(IF(F28=0,0,$B28/(100-SUM(G$27:G$38))*100),0)","v":0},1,0,{"$f":"IFERROR(IF(I28=0,0,$B28/(100-SUM(J$27:J$38))*100),0)","v":0},0,0,{"$f":"IFERROR(IF(L28=0,0,$B28/(100-SUM(M$27:M$38))*100),0)","v":0},0,0,{"$f":"IFERROR(IF(O28=0,0,$B28/(100-SUM(P$27:P$38))*100),0)","v":0},0,0,{"$f":"IFERROR(IF(R28=0,0,$B28/(100-SUM(S$27:S$38))*100),0)","v":0},0,0,{"$f":"IFERROR(IF(U28=0,0,$B28/(100-SUM(V$27:V$38))*100),0)","v":0},0,0,{"$f":"IFERROR(IF(X28=0,0,$B28/(100-SUM(Y$27:Y$38))*100),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"H15","v":3},{"$f":"IFERROR(H$18/$AL$18*100,0)","v":0},1,0,0,1,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"K15","v":4},{"$f":"IFERROR(K$18/$AL$18*100,0)","v":0},1,0,0,1,0,0,1,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"N15","v":5},{"$f":"IFERROR(N$18/$AL$18*100,0)","v":0},1,0,0,1,0,0,1,0,0,1,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"Q15","v":6},{"$f":"IFERROR(Q$18/$AL$18*100,0)","v":0},1,0,0,1,0,0,1,0,0,1,0,0,1,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"T15","v":7},{"$f":"IFERROR(T$18/$AL$18*100,0)","v":0},1,0,0,1,0,0,1,0,0,1,0,0,1,0,0,1,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"W15","v":8},{"$f":"IFERROR(W$18/$AL$18*100,0)","v":0},1,0,0,1,0,0,1,0,0,1,0,0,1,0,0,1,0,0,1,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"Z15","v":9},{"$f":"IFERROR(Z$18/$AL$18*100,0)","v":0},1,0,0,1,0,0,1,0,0,1,0,0,1,0,0,1,0,0,1,0,0,1,0,0,1,0,0,0,0,0,0,0,0,0,0]
[{"$f":"AC15","v":10},{"$f":"IFERROR(AC$18/$AL$18*100,0)","v":0},1,0,0,1,0,0,1,0,0,1,0,0,1,0,0,1,0,0,1,0,0,1,0,0,1,0,0,1,0,0,0,0,0,0,0]
[{"$f":"AF15","v":11},{"$f":"IFERROR(AF$18/$AL$18*100,0)","v":0},1,0,0,1,0,0,1,0,0,1,0,0,1,0,0,1,0,0,1,0,0,1,0,0,1,0,0,1,0,0,1,0,0,0,0]
[{"$f":"AI15","v":12},{"$f":"IFERROR(AI$18/$AL$18*100,0)","v":0},1,0,0,1,0,0,1,0,0,1,0,0,1,0,0,1,0,0,1,0,0,1,0,{"$f":"IFERROR(IF(AA38=0,0,$B38/(100-SUM(AB$27:AB$38))*100),0)","v":0},1,0,{"$f":"IFERROR(IF(AD38=0,0,$B38/(100-SUM(AE$27:AE$38))*100),0)","v":0},1,0,{"$f":"IFERROR(IF(AG38=0,0,$B38/(100-SUM(AH$27:AH$38))*100),0)","v":0},1,0,{"$f":"IFERROR(IF(AJ38=0,0,$B38/(100-SUM(AK$27:AK$38))*100),0)","v":0},1,0]
["TOTAL (%)",{"$f":"SUM(B27:B38)","v":0},null,null,{"$f":"SUM(E27:E38)","v":0},null,null,{"$f":"SUM(H27:H38)","v":0},null,null,{"$f":"SUM(K27:K38)","v":0},null,null,{"$f":"SUM(N27:N38)","v":0},null,null,{"$f":"SUM(Q27:Q38)","v":0},null,null,{"$f":"SUM(T27:T38)","v":0},null,null,{"$f":"SUM(W27:W38)","v":0},null,null,{"$f":"SUM(Z27:Z38)","v":0},null,null,{"$f":"SUM(AC27:AC38)","v":0},null,null,{"$f":"SUM(AF27:AF38)","v":0},null,null,{"$f":"SUM(AI27:AI38)","v":0}]
[]
[]
[null,"A",null,null,"B",null,null,"C",null,null,"D",null,null,"E",null,null,"F",null,null,"G",null,null,"H",null,null,"I",null,null,"J",null,null,"K",null,null,"L"]
["Critical Gap (sec)",{"$f":"E25","v":1},null,null,{"$f":"H25","v":2},null,null,{"$f":"K25","v":3},null,null,{"$f":"N25","v":4},null,null,{"$f":"Q25","v":5},null,null,{"$f":"T25","v":6},null,null,{"$f":"W25","v":7},null,null,{"$f":"Z25","v":8},null,null,{"$f":"AC25","v":9},null,null,{"$f":"AF25","v":10},null,null,{"$f":"AI25","v":11},null,null,"TOTAL"]
["Accepted Gap (sec)"]
[{"$f":"A28","v":2},{"$f":"E16","v":0},{"$f":"IF($A45>B$43,1,0)","v":1},null,{"$f":"IF(F45=0,0,$AI45-B45)","v":0},{"$f":"IF($A45>E$43,1,0)","v":0},null,{"$f":"IF(I45=0,0,$AI45-E45-B45)","v":0},{"$f":"IF($A45>H$43,1,0)","v":0},null,{"$f":"IF(L45=0,0,$AI45-H45-E45-B45)","v":0},{"$f":"IF($A45>K$43,1,0)","v":0},null,{"$f":"IF(O45=0,0,$AI45-K45-H45-E45-B45)","v":0},{"$f":"IF($A45>N$43,1,0)","v":0},null,{"$f":"IF(R45=0,0,$AI45-N45-K45-H45-E45-B45)","v":0},{"$f":"IF($A45>Q$43,1,0)","v":0},null,{"$f":"IF(U45=0,0,$AI45-Q45-N45-K45-H45-E45-B45)","v":0},{"$f":"IF($A45>T$43,1,0)","v":0},null,{"$f":"IF(X45=0,0,$AI45-T45-Q45-N45-K45-H45-E45-B45)","v":0},{"$f":"IF($A45>W$43,1,0)","v":0},null,{"$f":"IF(AA45=0,0,$AI45-W45-T45-Q45-N45-K45-H45-E45-B45)","v":0},{"$f":"IF($A45>Z$43,1,0)","v":0},null,{"$f":"IF(AD45=0,0,$AI45-Z45-W45-T45-Q45-N45-K45-H45-E45-B45)","v":0},{"$f":"IF($A45>AC$43,1,0)","v":0},null,{"$f":"IF(AG45=0,0,$AI45-AC45-Z45-W45-T45-Q45-N45-K45-H45-E45-B45)","v":0},{"$f":"IF($A45>AF$43,1,0)","v":0},null,{"$f":"E16","v":0}]
[3,{"$f":"IFERROR(E29/100*B$56,0)","v":0},1,null,{"$f":"IF(F46=0,0,$AI46-B46)","v":0},{"$f":"IF($A46>E$43,1,0)","v":1},null,{"$f":"IF(I46=0,0,$AI46-E46-B46)","v":0},{"$f":"IF($A46>H$43,1,0)","v":0},null,{"$f":"IF(L46=0,0,$AI46-H46-E46-B46)","v":0},{"$f":"IF($A46>K$43,1,0)","v":0},null,{"$f":"IF(O46=0,0,$AI46-K46-H46-E46-B46)","v":0},{"$f":"IF($A46>N$43,1,0)","v":0},null,{"$f":"IF(R46=0,0,$AI46-N46-K46-H46-E46-B46)","v":0},{"$f":"IF($A46>Q$43,1,0)","v":0},null,{"$f":"IF(U46=0,0,$AI46-Q46-N46-K46-H46-E46-B46)","v":0},{"$f":"IF($A46>T$43,1,0)","v":0},null,{"$f":"IF(X46=0,0,$AI46-T46-Q46-N46-K46-H46-E46-B46)","v":0},{"$f":"IF($A46>W$43,1,0)","v":0},null,{"$f":"IF(AA46=0,0,$AI46-W46-T46-Q46-N46-K46-H46-E46-B46)","v":0},{"$f":"IF($A46>Z$43,1,0)","v":0},null,{"$f":"IF(AD46=0,0,$AI46-Z46-W46-T46-Q46-N46-K46-H46-E46-B46)","v":0},{"$f":"IF($A46>AC$43,1,0)","v":0},null,{"$f":"IF(AG46=0,0,$AI46-AC46-Z46-W46-T46-Q46-N46-K46-H46-E46-B46)","v":0},{"$f":"IF($A46>AF$43,1,0)","v":0},null,{"$f":"H16","v":0}]
[4,0,1,null,{"$f":"H30/100*E$56","v":0},1,null,{"$f":"IF(I47=0,0,$AI47-E47-B47)","v":0},1,null,{"$f":"IF(L47=0,0,$AI47-H47-E47-B47)","v":0},0,null,0,0,null,{"$f":"IF(R47=0,0,$AI47-N47-K47-H47-E47-B47)","v":0},0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,{"$f":"K16","v":0}]
[5,0,1,null,0,1,null,{"$f":"K31/100*H$56","v":0},1,null,{"$f":"IF(L48=0,0,$AI48-H48-E48-B48)","v":0},1,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,{"$f":"N16","v":0}]
[6,0,1,null,0,1,null,0,1,null,{"$f":"N32/100*K$56","v":0},1,null,0,1,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,{"$f":"Q16","v":0}]
[7,0,1,null,0,1,null,0,1,null,0,1,null,{"$f":"Q33/100*N$56","v":0},1,null,0,1,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,{"$f":"T16","v":0}]
[8,0,1,null,0,1,null,0,1,null,0,1,null,0,1,null,{"$f":"T34/100*Q$56","v":0},1,null,0,1,null,0,0,null,0,0,null,0,0,null,0,0,null,{"$f":"W16","v":0}]
[9,0,1,null,0,1,null,0,1,null,0,1,null,0,1,null,{"$f":"T35/100*Q$56","v":0},1,null,{"$f":"W35/100*T$56","v":0},1,null,0,1,null,0,0,null,0,0,null,0,0,null,{"$f":"Z16","v":0}]
[10,0,1,null,0,1,null,0,1,null,0,1,null,0,1,null,{"$f":"T36/100*Q$56","v":0},1,null,{"$f":"W36/100*T$56","v":0},1,null,{"$f":"Z36/100*W$56","v":0},1,null,0,1,null,0,0,null,0,0,null,{"$f":"AC16","v":0}]
[11,0,1,null,0,1,null,0,1,null,0,1,null,0,1,null,{"$f":"T37/100*Q$56","v":0},1,null,{"$f":"W37/100*T$56","v":0},1,null,{"$f":"Z37/100*W$56","v":0},1,null,{"$f":"AC37/100*Z$56","v":0},1,null,0,1,null,0,0,null,{"$f":"AF16","v":0}]
[12,0,1,null,0,1,null,0,1,null,0,1,null,0,1,null,{"$f":"T38/100*Q$56","v":0},1,null,{"$f":"W38/100*T$56","v":0},1,null,{"$f":"Z38/100*W$56","v":0},1,null,{"$f":"AC38/100*Z$56","v":0},1,null,{"$f":"AF38/100*AC$56","v":0},1,null,{"$f":"IFERROR(IF(AG55=0,0,$AI55-AC55-Z55-W55-T55-Q55-N55-K55-H55-E55-B55),0)","v":0},1,null,{"$f":"AI16","v":0}]
["TOTAL",{"$f":"IFERROR(B45*100/E28,0)","v":0},null,null,{"$f":"IFERROR(E46*100/H29,0)","v":0},null,null,{"$f":"IFERROR(H47*100/K30,0)","v":0},null,null,{"$f":"IFERROR(K48*100/N31,0)","v":0},null,null,{"$f":"IFERROR(N49*100/Q32,0)","v":0},null,null,{"$f":"IFERROR(Q50*100/T33,0)","v":0},null,null,{"$f":"IFERROR(T51*100/W34,0)","v":0},null,null,{"$f":"IFERROR(W52*100/Z35,0)","v":0},null,null,{"$f":"IFERROR(Z53*100/AC36,0)","v":0},null,null,{"$f":"IFERROR(AC54*100/AF37,0)","v":0},null,null,{"$f":"IFERROR(AF54*100/AI38,0)","v":0},null,null,{"$f":"SUM(AI45:AI55)","v":0}]
["Critical Gap %",{"$f":"IFERROR(B56/$AI$56,0)","v":0},{"$f":"IF(SUM(G27:G38)<100,B56,0)","v":0},null,{"$f":"IFERROR(E56/$AI$56,0)","v":0},{"$f":"IF(SUM(J27:J38)<100,E56,0)","v":0},null,{"$f":"IFERROR(H56/$AI$56,0)","v":0},{"$f":"IF(SUM(M27:M38)<100,H56,0)","v":0},null,{"$f":"IFERROR(K56/$AI$56,0)","v":0},{"$f":"IF(SUM(P27:P38)<100,K56,0)","v":0},{"$f":"IF(L57>0,1,0)","v":0},{"$f":"IFERROR(N56/$AI$56,0)","v":0},{"$f":"IF(SUM(S27:S38)<100,N56,0)","v":0},null,{"$f":"IFERROR(Q56/$AI$56,0)","v":0},{"$f":"IF(SUM(V27:V38)<100,Q56,0)","v":0},null,{"$f":"IFERROR(T56/$AI$56,0)","v":0},{"$f":"IF(SUM(Y27:Y38)<100,T56,0)","v":0},null,{"$f":"IFERROR(W56/$AI$56,0)","v":0},{"$f":"IF(SUM(AB27:AB38)<100,W56,0)","v":0},null,{"$f":"IFERROR(Z56/$AI$56,0)","v":0},{"$f":"IF(SUM(AE27:AE38)<100,Z56,0)","v":0},null,{"$f":"IFERROR(AC56/$AI$56,0)","v":0},{"$f":"IF(SUM(AH27:AH38)<100,AC56,0)","v":0},null,{"$f":"IFERROR(AF56/$AI$56,0)","v":0},{"$f":"IF(SUM(AK27:AK38)<100,AF56,0)","v":0},null,{"$f":"IFERROR(AI56/$AI$56,0)","v":0}]
["Mean Critical Gap (sec)",{"$f":"(B43*C57+E43*F57+H43*I57+K43*L57+N43*O57+Q43*R57+T43*U57+W43*X57+Z43*AA57+AC43*AD57+AF43*AG57)/AI56","v":{"$error":"#DIV/0!"}}]