{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Computations Base","Program Description","Comp 2"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":4,"comments":2,"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":"Computations Base","index":0,"n_rows":168,"n_cols":9,"rows_kept":168,"cut":false,"hidden":false,"merged":[]}
["Runway Saturation Capacity Estimation"]
["Using the Analyical Model for Runway Capacity"]
[]
["Programmer: A. Trani (August 2019)"]
["Amendments:",1]
[]
[]
["Technical Parameters (inputs)",null,null,null,"Parameter","Values"]
["Dep-Arrival Separation (nm)",null,null,null,"d",2]
["Common Approach Length (nm)",null,null,null,"g",12]
["Standard deviation of Position Delivery Error (s)",null,null,null,"s",20]
["Probability of Violation",null,null,null,"Pv",5,null,"Clear to roll"]
["Cumulative Normal at Pv",null,null,null,"qv",{"$f":"qv_computation(F12)","v":1.65},null,10]
["Buffer for departure-departure (seconds)",null,null,null,null,10]
[null,"F","E","B"]
["ROT (s)",51,54,65,70,70,null,{"$f":"B16*B17/100+C16*C17/100+D16*D17/100+E16*E17/100+F16*F17/100","v":52.42},"E(ROT)"]
["Percent Mix (%)",82,10,8,0,0,null,{"$f":"B17+C17+D17+E17+F17","v":100},"Total %"]
["Vapproach (knots)",132,137,151,150,150]
[]
["Minimum Separation Matrix (nm)",null,null,"Arrivals-Arrivals"]
[null,null,"Trailing Aircraft (Header Columns)"]
["Lead (column 1)","F","E","B"]
[{"$f":"B22","v":"F"},3,3,3]
[{"$f":"C22","v":"E"},3,3,3]
[{"$f":"D22","v":"B"},5,5,3]
[]
[]
[]
["Error Free Separation Matrix"]
[null,null,"Trailing Aircraft (Header Columns)"]
["Lead (column 1)",{"$f":"B22","v":"F"},{"$f":"C22","v":"E"},"B",null,null,null,"Expected Value"]
[{"$f":"A23","v":"F"},{"$f":"B23/B$18*3600","v":81.818181818181827},{"$f":"C23/C$18*3600","v":78.832116788321173},{"$f":"D23/D$18*3600","v":71.523178807947019},null,null,null,"E(Tij)"]
[{"$f":"A24","v":"E"},{"$f":"(B24/B$18+$F$10*(1/B$18-1/C$18))*3600","v":93.762441937624445},{"$f":"C24/C$18*3600","v":78.832116788321173},{"$f":"D24/D$18*3600","v":71.523178807947019},null,null,null,{"$f":"B32*B41+C32*C41+D32*D41+E32*E41+B33*B42+C33*C42+D33*D42+E33*E42+B34*B43+C34*C43+D34*D43+E34*E43+B35*B44+C35*C44+D35*D44+E35*E44+F32*F41+F33*F42+F34*F43+F35*F44+B36*B45+C36*C45+D36*D45+E36*E45+F36*F45","v":88.609318983815044}]
["B",{"$f":"(B25/B$18+$F$10*(1/B$18-1/D$18))*3600","v":177.54364840457558},{"$f":"(C25/C$18+$F$10*(1/C$18-1/D$18))*3600","v":160.62261323536521},{"$f":"D25/D$18*3600","v":71.523178807947019}]
[]
[]
[]
["Pij Matrix"]
[null,null,"Trailing Aircraft (Header Columns)"]
["Lead (column 1)",{"$f":"B31","v":"F"},{"$f":"C31","v":"E"},"B",null,null,null,"Sum of Pij"]
[{"$f":"A32","v":"F"},{"$f":"B17/100*B17/100","v":0.6724},{"$f":"B17/100*C17/100","v":8.199999999999999E-2},{"$f":"B17/100*D17/100","v":6.5599999999999992E-2},null,null,null,{"$f":"SUM(B41:F41)","v":0.82}]
[{"$f":"A33","v":"E"},{"$f":"B17/100*C17/100","v":8.199999999999999E-2},{"$f":"C17/100*C17/100","v":0.01},{"$f":"C17/100*D17/100","v":8.0000000000000002E-3},null,null,null,{"$f":"SUM(B42:F42)","v":9.9999999999999978E-2}]
["B",{"$f":"B17/100*D17/100","v":6.5599999999999992E-2},{"$f":"C17/100*D17/100","v":8.0000000000000002E-3},{"$f":"D17/100*D17/100","v":6.4000000000000003E-3},null,null,null,{"$f":"SUM(B43:F43)","v":0.08}]
[null,null,null,null,null,null,null,{"$f":"SUM(B44:F44)","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(B45:F45)","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(H41:H45)","v":0.99999999999999989}]
["Buffer Matrix (Bij)"]
[null,null,"Trailing Aircraft (Header Columns)"]
["Lead (column 1)",{"$f":"B40","v":"F"},{"$f":"C40","v":"E"},"B",null,null,null,"Expected Value"]
[{"$f":"B49","v":"F"},{"$f":"$F$13*$F$11","v":33},{"$f":"$F$13*$F$11","v":33},{"$f":"$F$13*$F$11","v":33},null,null,null,"B(Tij)"]
[{"$f":"C49","v":"E"},{"$f":"MAX(0,($F$13*$F$11)-(B24*(1/B$18-1/C$18)*3600))","v":30.013934970139346},{"$f":"$F$13*$F$11","v":33},{"$f":"$F$13*$F$11","v":33},null,null,null,{"$f":"B41*B50+C50*C41+D41*D50+E41*E50+B42*B51+C42*C51+D42*D51+E42*E51+B43*B52+C43*C52+D43*D52+E43*E52+B44*B53+C44*C53+D44*D53+E44*E53+(F41*F50)+(F42*F51)+(F43*F52)+(F44*F53)+(B45*B54)+(C45*C54)+(D45*D54)+(E45*E54)+(F45*F54)","v":31.532103165360763}]
[{"$f":"D49","v":"B"},{"$f":"MAX(0,$F$13*$F$11-B25*(1/B$18-1/D$18)*3600)","v":15.841661649608664},{"$f":"MAX(0,$F$13*$F$11-C25*(1/C$18-1/D$18)*3600)","v":20.818436699376424},{"$f":"$F$13*$F$11","v":33}]
[]
[]
[]
["Augmented Matrix (Tij + Bij)"]
[null,null,"Trailing Aircraft (Header Columns)"]
["Lead (column 1)",{"$f":"B49","v":"F"},{"$f":"C49","v":"E"},"B",null,null,null,"Expected Value"]
[{"$f":"B58","v":"F"},{"$f":"B50+B32","v":114.81818181818183},111.83211678832117,104.52317880794702,null,null,null,"E(Tij) + B(Tij)"]
[{"$f":"C58","v":"E"},123.77637690776379,111.83211678832117,104.52317880794702,null,null,null,{"$f":"B59*B41+C59*C41+D59*D41+E59*E41+B60*B42+C60*C42+D60*D42+E60*E42+B61*B43+C61*C43+D61*D43+E61*E43+B62*B44+C62*C44+D62*D44+E62*E44+B45*B63+C45*C63+D45*D63+E45*E63+F41*F59+F42*F60+F43*F61+F44*F62+F45*F63","v":120.14142214917581}]
[{"$f":"D58","v":"B"},193.38531005418423,181.44104993474164,104.52317880794702]
[]
[]
[]
["Arrivals Only Capacity (per hour)",null,null,{"$f":"3600/H60","v":29.964686080792298}]
[]
[]
["Departure-Departure Separation Matrix (seconds)"]
[null,null,"Trailing Aircraft (Header Columns)"]
["Lead (column 1)",{"$f":"B58","v":"F"},{"$f":"C58","v":"E"},"B",null,null,null,"Expected Value"]
[{"$f":"B70","v":"F"},60,60,60,null,null,null,"E(Td)"]
[{"$f":"C70","v":"E"},60,60,60]
[{"$f":"D70","v":"B"},120,120,120,null,null,null,{"$f":"B71*B41+C71*C41+D71*D41+E71*E41+B72*B42+C72*C42+D72*D42+E72*E42+B73*B43+C73*C43+D73*D43+E73*E43+B74*B44+C74*C44+D74*D44+E74*E44+B45*B75+C45*C75+D45*D75+E45*E75+F41*F71+F42*F72+F43*F73+F44*F74+F45*F75","v":64.8}]
[]
[]
[]
["Departures Only Capacity (per hour) without buffers",null,null,{"$f":"3600/H73","v":55.555555555555557}]
[]
["Departure-Departure Separation Matrix with Buffers (seconds)"]
[null,null,"Trailing Aircraft (Header Columns)"]
["Lead (column 1)",{"$f":"B70","v":"F"},{"$f":"C70","v":"E"},"B",null,null,null,"Expected Value"]
[{"$f":"B81","v":"F"},{"$f":"B71+$F$14","v":70},{"$f":"C71+$F$14","v":70},70,null,null,null,"E(Td)"]
[{"$f":"C81","v":"E"},{"$f":"B72+$F$14","v":70},70,70]
[{"$f":"D81","v":"B"},130,130,130,null,null,null,{"$f":"B82*B41+C82*C41+D82*D41+E82*E41+F82*F41+B83*B42+C83*C42+D83*D42+E83*E42+F83*F42+B84*B43+C84*C43+D84*D43+E84*E43+F84*F43+B85*B44+C85*C44+D85*D44+E85*E44+F85*F44+B45*B86+C45*C86+D45*D86+E45*E86+F45*F86","v":74.8}]
[]
[]
[]
["Departures Only Capacity (per hour) - includes departure buffers",null,null,{"$f":"3600/H84","v":48.128342245989309}]
[]
[]
["Estimation of Critical Departure Gaps"]
[null,null,null,null,"E(ROT)",{"$f":"H16","v":52.42}]
["Departures",null,"Gap (EDTij)",null,"E(d/Vj)",{"$f":"($F$9/B$18*B17/100+$F$9/C$18*C17/100+F$9/D$18*D17/100+F$9/E$18*E17/100+F$9/F$18*F17/100)*3600","v":53.797316716251309}]
[1,null,{"$f":"$F$92+$F$93+$F$94+(A94-1)*$H$73","v":116.2173167162513},null,null,{"$f":"H13","v":10}]
[2,null,{"$f":"$F$92+$F$93+$F$94+(A95-1)*$H$73","v":181.01731671625129}]
[3,null,{"$f":"$F$92+$F$93+$F$94+(A96-1)*$H$73","v":245.8173167162513}]
[4,null,{"$f":"$F$92+$F$93+$F$94+(A97-1)*$H$73","v":310.61731671625125}]
[5,null,{"$f":"$F$92+$F$93+$F$94+(A98-1)*$H$73","v":375.41731671625132}]
[]
[]
["Departures per Gap"]
[null,null,"Trailing Aircraft (Header Columns)"]
["Lead (column 1)",{"$f":"B81","v":"F"},{"$f":"C81","v":"E"},"B"]
[{"$f":"B103","v":"F"},{"$f":"no_of_departures(B59,$C$94,$C$95,$C$96,$C$97)","v":0},0,0,0,0]
[{"$f":"C103","v":"E"},1,0,0,0,0]
[{"$f":"D103","v":"B"},2,2,0,0,0]
[null,0,0,0,0,0]
[null,0,0,0,0,0]
[]
["Departures per hour with 100% Arrival Priority"]
[]
[null,null,"Trailing Aircraft (Header Columns)"]
["Lead (column 1)",{"$f":"B103","v":"F"},{"$f":"C103","v":"E"},"B",null,null,"Sum"]
[{"$f":"B113","v":"F"},{"$f":"B104*($D$65-1)*B41","v":0},0,0,0,0,{"$f":"B114+C114+D114+E114+F114","v":0}]
[{"$f":"C113","v":"E"},2.375104258624968,0,0,0,0,{"$f":"B115+C115+D115+E115+F115","v":2.375104258624968}]
[{"$f":"D113","v":"B"},3.8001668137999491,0.4634349772926768,0,0,0,{"$f":"B116+C116+D116+E116+F116","v":4.2636017910926256}]
[null,0,0,0,0,0,{"$f":"B117+C117+D117+E117+F117","v":0}]
[null,0,0,0,0,0,{"$f":"B118+C118+D118+E118+F118","v":0}]
[null,null,null,null,null,null,{"$f":"SUM(G114:G118)","v":6.6387060497175936},"Total Departures"]
["Summary for Arrival - Departure Diagram",null,null,null,null,null,null,"with 100% arrival priority"]
[]
["Arrivals","Departures",null,"Operation Pattern"]
[{"$f":"D65","v":29.964686080792298},0,null,"Arrivals Only",null,null,"Baseline"]
[{"$f":"A123","v":29.964686080792298},{"$f":"G119","v":6.6387060497175936},null,"100% Arrivals + Departures",null,null,"Baseline"]
[{"$f":"'Comp 2'!D65","v":22.843590986636908},{"$f":"'Comp 2'!G119","v":24.884218851976762},null,null,null,null,"Comp 2"]
[0,{"$f":"D88","v":48.128342245989309},null,"Departures Only",null,null,"Baseline"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[45,0]
[45,4.84]
[45,20.128899999999998]
[45,58.310454578585485]
[0,58.31]

{"sheet":"Program Description","index":1,"n_rows":26,"n_cols":1,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["Simple Runway Saturation Capacity Program"]
[]
["Implements the analyical procedure developed"]
["by W.  Harris (at the MITRE Corporation) "]
["to estimate a single runway saturation capacity."]
[]
["This analytical procedure does not compute"]
["runway delay so another suitable method should be employed to"]
["estimate delay. A complementary approach to estimate"]
["delay would be to use queueing theory (see course notes)."]
[]
["NOTE: This program only computes the saturation"]
["capacity for one runway. If multiple runways exist"]
["you can use a variation of the method to estimate"]
["the saturation capacity of the entire airport as follows:"]
[]
["a) If runways are independent (check mimimum separation"]
["criteria) then the saturation capacity is just a multiple of the single runway capacity"]
[]
["b) If runway operations are dependent (check separation criteria)"]
["then select a primary runway and estimate the capacity of this facility."]
["Then select each remaining runway and iteratively create a feasible"]
["operations diagram so that time gaps left empty in the first runway"]
["are used by aircraft operating from other runways. This process"]
["requires some thinking and perhaps some local knowledge of how"]
["the airport is operated. Consult the ATC facility to get this information."]

{"sheet":"Comp 2","index":2,"n_rows":120,"n_cols":16,"rows_kept":120,"cut":false,"hidden":false,"merged":[]}
["Runway Saturation Capacity Estimation"]
["Using the Analyical Model for Runway Capacity"]
[]
["Programmer: A. Trani (August 2019)"]
["Amendments:",1]
[]
[]
["Technical Parameters (inputs)",null,null,null,"Parameter","Values"]
["Dep-Arrival Separation (nm)",null,null,null,"d",2]
["Common Approach Length (nm)",null,null,null,"g",12]
["Standard deviation of Position Delivery Error (s)",null,null,null,"s",20]
["Probability of Violation",null,null,null,"Pv",5,null,"Clear to roll"]
["Cumulative Normal at Pv",null,null,null,"qv",{"$f":"qv_computation(F12)","v":1.65},null,10]
["Buffer for departure-departure (seconds)",null,null,null,null,10]
[null,"F","E","B"]
["ROT (s)",51,54,65,70,70,null,{"$f":"B16*B17/100+C16*C17/100+D16*D17/100+E16*E17/100+F16*F17/100","v":52.42},"E(ROT)"]
["Percent Mix (%)",82,10,8,0,0,null,{"$f":"B17+C17+D17+E17+F17","v":100},"Total %"]
["Vapproach (knots)",132,137,151,150,150]
[]
["Minimum Separation Matrix (nm)",null,null,"Arrivals-Arrivals",null,null,null,"Multiplier"]
[null,null,"Trailing Aircraft (Header Columns)",null,null,null,null,1.45]
["Lead (column 1)","F","E","B"]
[{"$f":"B22","v":"F"},{"$f":"'Computations Base'!B23*'Comp 2'!$H$21","v":4.3499999999999996},{"$f":"'Computations Base'!C23*'Comp 2'!$H$21","v":4.3499999999999996},{"$f":"'Computations Base'!D23*'Comp 2'!$H$21","v":4.3499999999999996},{"$f":"'Computations Base'!E23*'Comp 2'!$H$21","v":0},{"$f":"'Computations Base'!F23*'Comp 2'!$H$21","v":0}]
[{"$f":"C22","v":"E"},{"$f":"'Computations Base'!B24*'Comp 2'!$H$21","v":4.3499999999999996},{"$f":"'Computations Base'!C24*'Comp 2'!$H$21","v":4.3499999999999996},{"$f":"'Computations Base'!D24*'Comp 2'!$H$21","v":4.3499999999999996},{"$f":"'Computations Base'!E24*'Comp 2'!$H$21","v":0},{"$f":"'Computations Base'!F24*'Comp 2'!$H$21","v":0}]
[{"$f":"D22","v":"B"},{"$f":"'Computations Base'!B25*'Comp 2'!$H$21","v":7.25},{"$f":"'Computations Base'!C25*'Comp 2'!$H$21","v":7.25},{"$f":"'Computations Base'!D25*'Comp 2'!$H$21","v":4.3499999999999996},{"$f":"'Computations Base'!E25*'Comp 2'!$H$21","v":0},{"$f":"'Computations Base'!F25*'Comp 2'!$H$21","v":0}]
[null,{"$f":"'Computations Base'!B26*'Comp 2'!$H$21","v":0},{"$f":"'Computations Base'!C26*'Comp 2'!$H$21","v":0},{"$f":"'Computations Base'!D26*'Comp 2'!$H$21","v":0},{"$f":"'Computations Base'!E26*'Comp 2'!$H$21","v":0},{"$f":"'Computations Base'!F26*'Comp 2'!$H$21","v":0}]
[null,{"$f":"'Computations Base'!B27*'Comp 2'!$H$21","v":0},{"$f":"'Computations Base'!C27*'Comp 2'!$H$21","v":0},{"$f":"'Computations Base'!D27*'Comp 2'!$H$21","v":0},{"$f":"'Computations Base'!E27*'Comp 2'!$H$21","v":0},{"$f":"'Computations Base'!F27*'Comp 2'!$H$21","v":0}]
[]
["Error Free Separation Matrix"]
[null,null,"Trailing Aircraft (Header Columns)"]
["Lead (column 1)",{"$f":"B22","v":"F"},{"$f":"C22","v":"E"},"B",null,null,null,"Expected Value"]
[{"$f":"A23","v":"F"},{"$f":"B23/B$18*3600","v":118.63636363636363},{"$f":"C23/C$18*3600","v":114.30656934306569},{"$f":"D23/D$18*3600","v":103.70860927152317},null,null,null,"E(Tij)"]
[{"$f":"A24","v":"E"},{"$f":"(B24/B$18+$F$10*(1/B$18-1/C$18))*3600","v":130.58062375580624},{"$f":"C24/C$18*3600","v":114.30656934306569},{"$f":"D24/D$18*3600","v":103.70860927152317},null,null,null,{"$f":"B32*B41+C32*C41+D32*D41+E32*E41+B33*B42+C33*C42+D33*D42+E33*E42+B34*B43+C34*C43+D34*D43+E34*E43+B35*B44+C35*C44+D35*D44+E35*E44+F32*F41+F33*F42+F34*F43+F35*F44+B36*B45+C36*C45+D36*D45+E36*E45+F36*F45","v":126.72188666575846}]
["B",{"$f":"(B25/B$18+$F$10*(1/B$18-1/D$18))*3600","v":238.90728476821195},{"$f":"(C25/C$18+$F$10*(1/C$18-1/D$18))*3600","v":219.74670082660606},{"$f":"D25/D$18*3600","v":103.70860927152317}]
[]
[]
[]
["Pij Matrix"]
[null,null,"Trailing Aircraft (Header Columns)"]
["Lead (column 1)",{"$f":"B31","v":"F"},{"$f":"C31","v":"E"},"B",null,null,null,"Sum of Pij"]
[{"$f":"A32","v":"F"},{"$f":"B17/100*B17/100","v":0.6724},{"$f":"B17/100*C17/100","v":8.199999999999999E-2},{"$f":"B17/100*D17/100","v":6.5599999999999992E-2},null,null,null,{"$f":"SUM(B41:F41)","v":0.82}]
[{"$f":"A33","v":"E"},{"$f":"B17/100*C17/100","v":8.199999999999999E-2},{"$f":"C17/100*C17/100","v":0.01},{"$f":"C17/100*D17/100","v":8.0000000000000002E-3},null,null,null,{"$f":"SUM(B42:F42)","v":9.9999999999999978E-2}]
["B",{"$f":"B17/100*D17/100","v":6.5599999999999992E-2},{"$f":"C17/100*D17/100","v":8.0000000000000002E-3},{"$f":"D17/100*D17/100","v":6.4000000000000003E-3},null,null,null,{"$f":"SUM(B43:F43)","v":0.08}]
[null,null,null,null,null,null,null,{"$f":"SUM(B44:F44)","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(B45:F45)","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(H41:H45)","v":0.99999999999999989}]
["Buffer Matrix (Bij)"]
[null,null,"Trailing Aircraft (Header Columns)"]
["Lead (column 1)",{"$f":"B40","v":"F"},{"$f":"C40","v":"E"},"B",null,null,null,"Expected Value"]
[{"$f":"B49","v":"F"},{"$f":"$F$13*$F$11","v":33},{"$f":"$F$13*$F$11","v":33},{"$f":"$F$13*$F$11","v":33},null,null,null,"B(Tij)"]
[{"$f":"C49","v":"E"},{"$f":"MAX(0,($F$13*$F$11)-(B24*(1/B$18-1/C$18)*3600))","v":28.670205706702049},{"$f":"$F$13*$F$11","v":33},{"$f":"$F$13*$F$11","v":33},null,null,null,{"$f":"B41*B50+C50*C41+D41*D50+E41*E50+B42*B51+C42*C51+D42*D51+E42*E51+B43*B52+C43*C52+D43*D52+E43*E52+B44*B53+C44*C53+D44*D53+E44*E53+(F41*F50)+(F42*F51)+(F43*F52)+(F44*F53)+(B45*B54)+(C45*C54)+(D45*D54)+(E45*E54)+(F45*F54)","v":30.871549589773107}]
[{"$f":"D49","v":"B"},{"$f":"MAX(0,$F$13*$F$11-B25*(1/B$18-1/D$18)*3600)","v":8.1204093919325651},{"$f":"MAX(0,$F$13*$F$11-C25*(1/C$18-1/D$18)*3600)","v":15.336733214095815},{"$f":"$F$13*$F$11","v":33}]
[]
[]
[]
["Augmented Matrix (Tij + Bij)"]
[null,null,"Trailing Aircraft (Header Columns)"]
["Lead (column 1)",{"$f":"B49","v":"F"},{"$f":"C49","v":"E"},"B",null,null,null,"Expected Value"]
[{"$f":"B58","v":"F"},{"$f":"B50+B32","v":151.63636363636363},147.30656934306569,136.70860927152319,null,null,null,"E(Tij) + B(Tij)"]
[{"$f":"C58","v":"E"},159.25082946250831,147.30656934306569,136.70860927152319,null,null,null,{"$f":"B59*B41+C59*C41+D59*D41+E59*E41+B60*B42+C60*C42+D60*D42+E60*E42+B61*B43+C61*C43+D61*D43+E61*E43+B62*B44+C62*C44+D62*D44+E62*E44+B45*B63+C45*C63+D45*D63+E45*E63+F41*F59+F42*F60+F43*F61+F44*F62+F45*F63","v":157.5934362555316}]
[{"$f":"D58","v":"B"},247.02769416014451,235.08343404070189,136.70860927152319]
[]
[]
[]
["Arrivals Only Capacity (per hour)",null,null,{"$f":"3600/H60","v":22.843590986636908}]
[]
[]
["Departure-Departure Separation Matrix (seconds)"]
[null,null,"Trailing Aircraft (Header Columns)",null,null,null,null,null,null,null,null,"Trailing"]
["Lead (column 1)",{"$f":"B58","v":"F"},{"$f":"C58","v":"E"},"B",null,null,null,"Expected Value",null,null,"Small","Large","B757","Heavy","S-Heavy","Expected Value"]
[{"$f":"B70","v":"F"},60,60,60,null,null,null,"E(Td)",null,null,10,10,10,10,10,"E(Td)"]
[{"$f":"C70","v":"E"},60,60,60,null,null,null,null,null,null,10,10,10,10,10]
[{"$f":"D70","v":"B"},120,120,120,null,null,null,{"$f":"B71*B41+C71*C41+D71*D41+E71*E41+B72*B42+C72*C42+D72*D42+E72*E42+B73*B43+C73*C43+D73*D43+E73*E43+B74*B44+C74*C44+D74*D44+E74*E44+B45*B75+C45*C75+D45*D75+E45*E75+F41*F71+F42*F72+F43*F73+F44*F74+F45*F75","v":64.8},null,null,10,10,10,10,10,{"$f":"K71*I41+L71*J41+M71*K41+N71*L41+K72*I42+L72*J42+M72*K42+N72*L42+K73*I43+L73*J43+M73*K43+N73*L43+K74*I44+L74*J44+M74*K44+N74*L44","v":0}]
[null,null,null,null,null,null,null,null,null,null,10,10,10,10,10]
[null,null,null,null,null,null,null,null,null,null,10,10,10,10,10]
[]
["Departures Only Capacity (per hour) without buffers",null,null,{"$f":"3600/H73","v":55.555555555555557}]
[]
["Departure-Departure Separation Matrix with Buffers (seconds)"]
[null,null,"Trailing Aircraft (Header Columns)"]
["Lead (column 1)",{"$f":"B70","v":"F"},{"$f":"C70","v":"E"},"B",null,null,null,"Expected Value"]
[{"$f":"B81","v":"F"},{"$f":"B71+$F$14","v":70},{"$f":"C71+$F$14","v":70},70,null,null,null,"E(Td)"]
[{"$f":"C81","v":"E"},{"$f":"B72+$F$14","v":70},70,70]
[{"$f":"D81","v":"B"},130,130,130,null,null,null,{"$f":"B82*B41+C82*C41+D82*D41+E82*E41+F82*F41+B83*B42+C83*B42+D83*D42+E83*E42+F83*F42+B84*B43+C84*C43+D84*D43+E84*E43+F84*F43+B85*B44+C85*C44+D85*D44+E85*E44+F85*F44+B45*B86+C45*C86+D45*D86+E45*E86+F45*F86","v":79.839999999999989}]
[]
[]
[]
["Departures Only Capacity (per hour) - includes departure buffers",null,null,{"$f":"3600/H84","v":45.090180360721448}]
[]
[]
["Estimation of Critical Departure Gaps"]
[null,null,null,null,"E(ROT)",{"$f":"H16","v":52.42}]
["Departures",null,"Gap (EDTij)",null,"E(d/Vj)",{"$f":"($F$9/B$18*B17/100+$F$9/C$18*C17/100+F$9/D$18*D17/100+F$9/E$18*E17/100+F$9/F$18*F17/100)*3600","v":53.797316716251309}]
[1,null,{"$f":"$F$92+$F$93+$F$94+(A94-1)*$H$73","v":116.2173167162513},null,null,{"$f":"H13","v":10}]
[2,null,{"$f":"$F$92+$F$93+$F$94+(A95-1)*$H$73","v":181.01731671625129}]
[3,null,{"$f":"$F$92+$F$93+$F$94+(A96-1)*$H$73","v":245.8173167162513}]
[4,null,{"$f":"$F$92+$F$93+$F$94+(A97-1)*$H$73","v":310.61731671625125}]
[5,null,{"$f":"$F$92+$F$93+$F$94+(A98-1)*$H$73","v":375.41731671625132}]
[]
[]
["Departures per Gap"]
[null,null,"Trailing Aircraft (Header Columns)"]
["Lead (column 1)",{"$f":"B81","v":"F"},{"$f":"C81","v":"E"},"B"]
[{"$f":"B103","v":"F"},{"$f":"no_of_departures(B59,$C$94,$C$95,$C$96,$C$97)","v":1},1,1,0,0]
[{"$f":"C103","v":"E"},1,1,1,0,0]
[{"$f":"D103","v":"B"},3,2,1,0,0]
[null,0,0,0,0,0]
[null,0,0,0,0,0]
[]
["Departures per hour with 100% Arrival Priority"]
[]
[null,null,"Trailing Aircraft (Header Columns)"]
["Lead (column 1)",{"$f":"B103","v":"F"},{"$f":"C103","v":"E"},"B",null,null,"Sum"]
[{"$f":"B113","v":"F"},{"$f":"B104*($D$65-1)*B41","v":14.687630579414657},1.7911744609042262,1.432939568723381,0,0,{"$f":"B114+C114+D114+E114+F114","v":17.911744609042263}]
[{"$f":"C113","v":"E"},1.7911744609042262,0.21843590986636907,0.17474872789309526,0,0,{"$f":"B115+C115+D115+E115+F115","v":2.1843590986636903}]
[{"$f":"D113","v":"B"},4.2988187061701426,0.34949745578619051,0.13979898231447621,0,0,{"$f":"B116+C116+D116+E116+F116","v":4.788115144270809}]
[null,0,0,0,0,0,{"$f":"B117+C117+D117+E117+F117","v":0}]
[null,0,0,0,0,0,{"$f":"B118+C118+D118+E118+F118","v":0}]
[null,null,null,null,null,null,{"$f":"SUM(G114:G118)","v":24.884218851976762},"Total Departures"]
["Summary for Arrival - Departure Diagram",null,null,null,null,null,null,"with 100% arrival priority"]