{"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":5,"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 (Fall 2022)"]
["Amendments:",2]
[]
[]
["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",10]
["Standard deviation of Position Delivery Error (s)",null,null,null,"s",18]
["Probability of Violation",null,null,null,"Pv",5]
["Cumulative Normal at Pv",null,null,null,"qv",{"$f":"qv_computation(F12)","v":1.65}]
["Buffer for departure-departure (seconds)",null,null,null,null,10]
[null,"H","G","F","B","A"]
["ROT (s)",47,48,50,60,70,null,{"$f":"B16*B17/100+C16*C17/100+D16*D17/100+E16*E17/100+F16*F17/100","v":49.45},"E(ROT)"]
["Percent Mix (%)",5,45,45,5,0,null,{"$f":"B17+C17+D17+E17+F17","v":100},"Total %"]
["Vapproach (knots)",127,134,140,150,150]
[]
["Minimum Separation Matrix (nm)",null,null,"Arrivals-Arrivals"]
[null,null,"Trailing Aircraft (Header Columns)"]
["Lead (column 1)",{"$f":"B15","v":"H"},{"$f":"C15","v":"G"},{"$f":"D15","v":"F"},{"$f":"E15","v":"B"},{"$f":"F15","v":"A"}]
[{"$f":"B22","v":"H"},2.5,2.5,2.5,2.5]
[{"$f":"C22","v":"G"},2.5,2.5,2.5,2.5]
[{"$f":"D22","v":"F"},2.5,2.5,2.5,2.5]
[{"$f":"E22","v":"B"},5,5,5,2.5]
[{"$f":"F22","v":"A"}]
[]
["Error Free Separation Matrix (Tij)"]
[null,null,"Trailing Aircraft (Header Columns)"]
["Lead (column 1)",{"$f":"B22","v":"H"},{"$f":"C22","v":"G"},"F",{"$f":"E22","v":"B"},{"$f":"F22","v":"A"},null,"Expected Value"]
[{"$f":"A23","v":"H"},{"$f":"B23/B$18*3600","v":70.866141732283467},{"$f":"C23/C$18*3600","v":67.164179104477611},{"$f":"D23/D$18*3600","v":64.285714285714278},{"$f":"E23/E$18*3600","v":60},null,null,"E(Tij)"]
[{"$f":"A24","v":"G"},{"$f":"(B24/B$18+$F$10*(1/B$18-1/C$18))*3600","v":85.673992243506873},{"$f":"C24/C$18*3600","v":67.164179104477611},{"$f":"D24/D$18*3600","v":64.285714285714278},{"$f":"E24/E$18*3600","v":60},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":73.183813357285558}]
["F",{"$f":"(B25/B$18+$F$10*(1/B$18-1/D$18))*3600","v":97.187851518560194},{"$f":"(C25/C$18+$F$10*(1/C$18-1/D$18))*3600","v":78.678038379530918},{"$f":"D25/D$18*3600","v":64.285714285714278},{"$f":"E25/E$18*3600","v":60}]
[{"$f":"E31","v":"B"},{"$f":"(B26/B$18+$F$10*(1/B$18-1/D$18))*3600","v":168.05399325084366},{"$f":"(C26/C$18+$F$10*(1/C$18-1/E$18))*3600","v":162.98507462686564},{"$f":"(D26/D$18+$F$10*(1/D$18-1/E$18))*3600","v":145.71428571428569},{"$f":"E26/E$18*3600","v":60}]
[{"$f":"F31","v":"A"}]
[]
["Pij Matrix"]
[null,null,"Trailing Aircraft (Header Columns)"]
["Lead (column 1)",{"$f":"B31","v":"H"},{"$f":"C31","v":"G"},"F","B","A",null,"Sum of Pij"]
[{"$f":"A32","v":"H"},{"$f":"B17/100*B17/100","v":2.5000000000000001E-3},{"$f":"B17/100*C17/100","v":2.2499999999999999E-2},{"$f":"B17/100*D17/100","v":2.2499999999999999E-2},{"$f":"B17/100*E17/100","v":2.5000000000000001E-3},null,null,{"$f":"SUM(B41:F41)","v":0.05}]
[{"$f":"A33","v":"G"},{"$f":"B17/100*C17/100","v":2.2499999999999999E-2},{"$f":"C17/100*C17/100","v":0.20250000000000001},{"$f":"C17/100*D17/100","v":0.20250000000000001},{"$f":"C17/100*E17/100","v":2.2499999999999999E-2},null,null,{"$f":"SUM(B42:F42)","v":0.45}]
["F",{"$f":"B17/100*D17/100","v":2.2499999999999999E-2},{"$f":"C17/100*D17/100","v":0.20250000000000001},{"$f":"D17/100*D17/100","v":0.20250000000000001},{"$f":"D17/100*E17/100","v":2.2499999999999999E-2},null,null,{"$f":"SUM(B43:F43)","v":0.45}]
[{"$f":"E40","v":"B"},{"$f":"B17/100*E17/100","v":2.5000000000000001E-3},{"$f":"C17/100*E17/100","v":2.2499999999999999E-2},{"$f":"D17/100*E17/100","v":2.2499999999999999E-2},{"$f":"E17/100*E17/100","v":2.5000000000000001E-3},null,null,{"$f":"SUM(B44:F44)","v":0.05}]
[{"$f":"F40","v":"A"},null,null,null,null,null,null,{"$f":"SUM(B45:F45)","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(H41:H45)","v":1}]
["Buffer Matrix (Bij)"]
[null,null,"Trailing Aircraft (Header Columns)"]
["Lead (column 1)",{"$f":"B40","v":"H"},{"$f":"C40","v":"G"},"F","B","A",null,"Expected Value"]
[{"$f":"B49","v":"H"},{"$f":"$F$13*$F$11","v":29.7},{"$f":"$F$13*$F$11","v":29.7},{"$f":"$F$13*$F$11","v":29.7},{"$f":"$F$13*$F$11","v":29.7},null,null,"B(Tij)"]
[{"$f":"C49","v":"G"},{"$f":"MAX(0,($F$13*$F$11)-(B24*(1/B$18-1/C$18)*3600))","v":25.998037372194148},{"$f":"$F$13*$F$11","v":29.7},{"$f":"$F$13*$F$11","v":29.7},{"$f":"$F$13*$F$11","v":29.7},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":28.33760975773551}]
[{"$f":"D49","v":"F"},{"$f":"MAX(0,$F$13*$F$11-B25*(1/B$18-1/D$18)*3600)","v":23.119572553430821},{"$f":"MAX(0,$F$13*$F$11-C25*(1/C$18-1/D$18)*3600)","v":26.821535181236673},{"$f":"$F$13*$F$11","v":29.7},29.7]
[{"$f":"E49","v":"B"},{"$f":"MAX(0,$F$13*$F$11-B26*(1/B$18-1/D$18)*3600)","v":16.539145106861639},{"$f":"MAX(0,$F$13*$F$11-C26*(1/C$18-1/E$18)*3600)","v":15.371641791044786},21.128571428571441,29.7]
[{"$f":"F49","v":"A"}]
[]
["Augmented Matrix (Tij + Bij)"]
[null,null,"Trailing Aircraft (Header Columns)"]
["Lead (column 1)",{"$f":"B49","v":"H"},{"$f":"C49","v":"G"},"F","B","A",null,"Expected Value"]
[{"$f":"B58","v":"H"},{"$f":"B50+B32","v":100.56614173228347},96.864179104477614,93.98571428571428,89.7,null,null,"E(Tij) + B(Tij)"]
[{"$f":"C58","v":"G"},111.67202961570102,96.864179104477614,{"$f":"D51+D33","v":93.98571428571428},89.7,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":101.52142311502107}]
[{"$f":"D58","v":"F"},120.30742407199102,105.49957356076759,{"$f":"D52+D34","v":93.98571428571428},89.7]
[{"$f":"E58","v":"B"},184.5931383577053,178.35671641791043,{"$f":"D53+D35","v":166.84285714285713},89.7]
[{"$f":"F58","v":"A"}]
[]
["Arrivals Only Capacity (per hour)",null,null,{"$f":"3600/H60","v":35.460495819895037}]
[]
[]
["Minimum Departure-Departure Separation Matrix (seconds)"]
[null,null,"Trailing Aircraft (Header Columns)"]
["Lead (column 1)",{"$f":"B58","v":"H"},{"$f":"C58","v":"G"},"F","B","A",null,"Expected Value"]
[{"$f":"B70","v":"H"},60,60,60,60,null,null,"E(Td)"]
[{"$f":"C70","v":"G"},60,60,60,60]
[{"$f":"D70","v":"F"},60,60,60,60,null,null,{"$f":"B71*$B$41+C71*$C$41+D71*$D$41+E71*$E$41+F41*$F$71+B72*$B$42+C72*$C$42+D72*$D$42+E72*$E$42+F72*$F$42+B73*$B$43+C73*$C$43+D73*$D$43+E73*$E$43+F73*$F$43+B74*$B$44+C74*$C$44+D74*$D$44+E74*$E$44+F74*$F$44+$B$45*B75+$C$45*C75+$D$45*D75+$E$45*E75+$F$45*F75","v":63}]
[{"$f":"E70","v":"B"},120,120,120,120]
[{"$f":"F70","v":"A"}]
[]
["Departures Only Capacity (per hour) without buffers",null,null,{"$f":"3600/H73","v":57.142857142857146}]
[]
["Departure-Departure Separation Matrix with Departure Buffers (seconds)"]
[null,null,"Trailing Aircraft (Header Columns)"]
["Lead (column 1)",{"$f":"B70","v":"H"},{"$f":"C70","v":"G"},"F","B","A",null,"Expected Value"]
[{"$f":"B81","v":"H"},{"$f":"B71+$F$14","v":70},{"$f":"C71+$F$14","v":70},70,70,null,null,"E(Td)"]
[{"$f":"C81","v":"G"},{"$f":"B72+$F$14","v":70},70,70,70]
[{"$f":"D81","v":"F"},{"$f":"B73+$F$14","v":70},70,70,70,null,null,{"$f":"B82*$B$41+C82*$C$41+D82*$D$41+E82*$E$41+F52*$F$71+B83*$B$42+C83*$C$42+D83*$D$42+E83*$E$42+F83*$F$42+B84*$B$43+C84*$C$43+D84*$D$43+E84*$E$43+F84*$F$43+B85*$B$44+C85*$C$44+D85*$D$44+E85*$E$44+F85*$F$44+$B$45*B86+$C$45*C86+$D$45*D86+$E$45*E86+$F$45*F86","v":73}]
[{"$f":"E81","v":"B"},{"$f":"B74+$F$14","v":130},130,130,130]
[{"$f":"F81","v":"A"}]
[]
["Departures Only Capacity (per hour) - includes departure buffers",null,null,{"$f":"3600/H84","v":49.315068493150683}]
[]
[]
["Estimation of Critical Departure Gaps"]
[null,null,null,null,"E(ROT)",{"$f":"H16","v":49.45}]
["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":52.556607289760407}]
[1,null,{"$f":"$F$92+$F$93+$F$94+(A94-1)*$H$73","v":112.00660728976041},null,"Clear to Roll Time",10]
[2,null,{"$f":"$F$92+$F$93+$F$94+(A95-1)*$H$73","v":175.00660728976041}]
[3,null,{"$f":"$F$92+$F$93+$F$94+(A96-1)*$H$73","v":238.00660728976041}]
[4,null,{"$f":"$F$92+$F$93+$F$94+(A97-1)*$H$73","v":301.00660728976038}]
[5,null,{"$f":"$F$92+$F$93+$F$94+(A98-1)*$H$73","v":364.00660728976038}]
[]
[]
["Departures per Gap"]
[null,null,"Trailing Aircraft (Header Columns)"]
["Lead (column 1)",{"$f":"B81","v":"H"},{"$f":"C81","v":"G"},"F"]
[{"$f":"B103","v":"H"},{"$f":"no_of_departures(B59,$C$94,$C$95,$C$96,$C$97)","v":0},0,0,0,0]
[{"$f":"C103","v":"G"},0,0,0,0,0]
[{"$f":"D103","v":"F"},1,0,0,0,0]
[null,2,2,1,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":"H"},{"$f":"C103","v":"G"},"F",null,null,"Sum"]
[{"$f":"B113","v":"H"},{"$f":"B104*($D$65-1)*B41","v":0},0,0,0,0,{"$f":"B114+C114+D114+E114+F114","v":0}]
[{"$f":"C113","v":"G"},0,0,0,0,0,{"$f":"B115+C115+D115+E115+F115","v":0}]
[{"$f":"D113","v":"F"},0.77536115594763833,0,0,0,0,{"$f":"B116+C116+D116+E116+F116","v":0.77536115594763833}]
[null,0.17230247909947519,1.5507223118952767,0.77536115594763833,0,0,{"$f":"B117+C117+D117+E117+F117","v":2.4983859469423901}]
[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":3.2737471028900282},"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":35.460495819895037},0,null,"Arrivals Only",null,null,"Baseline"]
[{"$f":"A123","v":35.460495819895037},{"$f":"G119","v":3.2737471028900282},null,"100% Arrivals + Departures",null,null,"Baseline"]
[{"$f":"'Comp 2'!D65","v":23.151728601166859},{"$f":"'Comp 2'!G119","v":24.256142818277713},null,null,null,null,"Comp 2"]
[0,{"$f":"D88","v":49.315068493150683},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",{"$f":"'Computations Base'!F9","v":2}]
["Common Approach Length (nm)",null,null,null,"g",{"$f":"'Computations Base'!F10","v":10}]
["Standard deviation of Position Delivery Error (s)",null,null,null,"s",{"$f":"'Computations Base'!F11","v":18}]
["Probability of Violation",null,null,null,"Pv",{"$f":"'Computations Base'!F12","v":5},null,"Clear to roll"]
["Cumulative Normal at Pv",null,null,null,"qv",{"$f":"'Computations Base'!F13","v":1.65},null,10]
["Buffer for departure-departure (seconds)",null,null,null,null,{"$f":"'Computations Base'!F14","v":10}]
[null,"H","G","F","B","A"]
["ROT (s)",{"$f":"'Computations Base'!B16","v":47},{"$f":"'Computations Base'!C16","v":48},{"$f":"'Computations Base'!D16","v":50},{"$f":"'Computations Base'!E16","v":60},{"$f":"'Computations Base'!F16","v":70},null,{"$f":"B16*B17/100+C16*C17/100+D16*D17/100+E16*E17/100+F16*F17/100","v":49.45},"E(ROT)"]
["Percent Mix (%)",{"$f":"'Computations Base'!B17","v":5},{"$f":"'Computations Base'!C17","v":45},{"$f":"'Computations Base'!D17","v":45},{"$f":"'Computations Base'!E17","v":5},{"$f":"'Computations Base'!F17","v":0},null,{"$f":"B17+C17+D17+E17+F17","v":100},"Total %"]
["Vapproach (knots)",{"$f":"'Computations Base'!B18","v":127},{"$f":"'Computations Base'!C18","v":134},{"$f":"'Computations Base'!D18","v":140},{"$f":"'Computations Base'!E18","v":150},{"$f":"'Computations Base'!F18","v":150}]
[]
["Minimum Separation Matrix (nm)",null,null,"Arrivals-Arrivals",null,null,null,"Multiplier"]
[null,null,"Trailing Aircraft (Header Columns)",null,null,null,null,1.8]
["Lead (column 1)",{"$f":"B15","v":"H"},{"$f":"C15","v":"G"},{"$f":"D15","v":"F"},{"$f":"E15","v":"B"},{"$f":"F15","v":"A"}]
[{"$f":"B22","v":"H"},{"$f":"'Computations Base'!B23*'Comp 2'!$H$21","v":4.5},{"$f":"'Computations Base'!C23*'Comp 2'!$H$21","v":4.5},{"$f":"'Computations Base'!D23*'Comp 2'!$H$21","v":4.5},{"$f":"'Computations Base'!E23*'Comp 2'!$H$21","v":4.5},{"$f":"'Computations Base'!F23*'Comp 2'!$H$21","v":0}]
[{"$f":"C22","v":"G"},{"$f":"'Computations Base'!B24*'Comp 2'!$H$21","v":4.5},{"$f":"'Computations Base'!C24*'Comp 2'!$H$21","v":4.5},{"$f":"'Computations Base'!D24*'Comp 2'!$H$21","v":4.5},{"$f":"'Computations Base'!E24*'Comp 2'!$H$21","v":4.5},{"$f":"'Computations Base'!F24*'Comp 2'!$H$21","v":0}]
[{"$f":"D22","v":"F"},{"$f":"'Computations Base'!B25*'Comp 2'!$H$21","v":4.5},{"$f":"'Computations Base'!C25*'Comp 2'!$H$21","v":4.5},{"$f":"'Computations Base'!D25*'Comp 2'!$H$21","v":4.5},{"$f":"'Computations Base'!E25*'Comp 2'!$H$21","v":4.5},{"$f":"'Computations Base'!F25*'Comp 2'!$H$21","v":0}]
[{"$f":"E22","v":"B"},{"$f":"'Computations Base'!B26*'Comp 2'!$H$21","v":9},{"$f":"'Computations Base'!C26*'Comp 2'!$H$21","v":9},{"$f":"'Computations Base'!D26*'Comp 2'!$H$21","v":9},{"$f":"'Computations Base'!E26*'Comp 2'!$H$21","v":4.5},{"$f":"'Computations Base'!F26*'Comp 2'!$H$21","v":0}]
[{"$f":"F22","v":"A"},{"$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":"H"},{"$f":"C22","v":"G"},"F","B","A",null,"Expected Value"]
[{"$f":"B31","v":"H"},{"$f":"B23/B$18*3600","v":127.55905511811024},{"$f":"C23/C$18*3600","v":120.8955223880597},{"$f":"D23/D$18*3600","v":115.71428571428571},{"$f":"E23/E$18*3600","v":108},null,null,"E(Tij)"]
[{"$f":"C31","v":"G"},{"$f":"(B24/B$18+$F$10*(1/B$18-1/C$18))*3600","v":142.36690562933364},{"$f":"C24/C$18*3600","v":120.8955223880597},{"$f":"D24/D$18*3600","v":115.71428571428571},{"$f":"E24/E$18*3600","v":108},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":128.24825101153399}]
[{"$f":"D31","v":"F"},{"$f":"(B25/B$18+$F$10*(1/B$18-1/D$18))*3600","v":153.88076490438695},{"$f":"(C25/C$18+$F$10*(1/C$18-1/D$18))*3600","v":132.40938166311301},{"$f":"D25/D$18*3600","v":115.71428571428571},{"$f":"E25/E$18*3600","v":108}]
[{"$f":"E31","v":"B"},{"$f":"(B26/B$18+$F$10*(1/B$18-1/D$18))*3600","v":281.4398200224972},{"$f":"(C26/C$18+$F$10*(1/C$18-1/E$18))*3600","v":270.44776119402985},{"$f":"(D26/D$18+$F$10*(1/D$18-1/E$18))*3600","v":248.57142857142853},{"$f":"E26/E$18*3600","v":108}]
[{"$f":"F31","v":"A"}]
[]
["Pij Matrix"]
[null,null,"Trailing Aircraft (Header Columns)"]
["Lead (column 1)",{"$f":"B31","v":"H"},{"$f":"C31","v":"G"},"F","B","A",null,"Sum of Pij"]
[{"$f":"B40","v":"H"},{"$f":"B17/100*B17/100","v":2.5000000000000001E-3},{"$f":"B17/100*C17/100","v":2.2499999999999999E-2},{"$f":"B17/100*D17/100","v":2.2499999999999999E-2},{"$f":"B17/100*E17/100","v":2.5000000000000001E-3},null,null,{"$f":"SUM(B41:F41)","v":0.05}]
[{"$f":"C40","v":"G"},{"$f":"B17/100*C17/100","v":2.2499999999999999E-2},{"$f":"C17/100*C17/100","v":0.20250000000000001},{"$f":"C17/100*D17/100","v":0.20250000000000001},{"$f":"C17/100*E17/100","v":2.2499999999999999E-2},null,null,{"$f":"SUM(B42:F42)","v":0.45}]
[{"$f":"D40","v":"F"},{"$f":"B17/100*D17/100","v":2.2499999999999999E-2},{"$f":"C17/100*D17/100","v":0.20250000000000001},{"$f":"D17/100*D17/100","v":0.20250000000000001},{"$f":"D17/100*E17/100","v":2.2499999999999999E-2},null,null,{"$f":"SUM(B43:F43)","v":0.45}]
[{"$f":"E40","v":"B"},{"$f":"B17/100*E17/100","v":2.5000000000000001E-3},{"$f":"C17/100*E17/100","v":2.2499999999999999E-2},{"$f":"D17/100*E17/100","v":2.2499999999999999E-2},{"$f":"E17/100*E17/100","v":2.5000000000000001E-3},null,null,{"$f":"SUM(B44:F44)","v":0.05}]
[{"$f":"F40","v":"A"},null,null,null,null,null,null,{"$f":"SUM(B45:F45)","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(H41:H45)","v":1}]
["Buffer Matrix (Bij)"]
[null,null,"Trailing Aircraft (Header Columns)"]
["Lead (column 1)",{"$f":"B40","v":"H"},{"$f":"C40","v":"G"},"F","B","A",null,"Expected Value"]
[{"$f":"B49","v":"H"},{"$f":"$F$13*$F$11","v":29.7},{"$f":"$F$13*$F$11","v":29.7},{"$f":"$F$13*$F$11","v":29.7},{"$f":"$F$13*$F$11","v":29.7},null,null,"B(Tij)"]
[{"$f":"C49","v":"G"},{"$f":"MAX(0,($F$13*$F$11)-(B24*(1/B$18-1/C$18)*3600))","v":23.036467269949462},{"$f":"$F$13*$F$11","v":29.7},{"$f":"$F$13*$F$11","v":29.7},{"$f":"$F$13*$F$11","v":29.7},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":27.247697563923914}]
[{"$f":"D49","v":"F"},{"$f":"MAX(0,$F$13*$F$11-B25*(1/B$18-1/D$18)*3600)","v":17.855230596175474},{"$f":"MAX(0,$F$13*$F$11-C25*(1/C$18-1/D$18)*3600)","v":24.518763326226011},{"$f":"$F$13*$F$11","v":29.7},29.7]
[{"$f":"E49","v":"B"},{"$f":"MAX(0,$F$13*$F$11-B26*(1/B$18-1/D$18)*3600)","v":6.0104611923509523},{"$f":"MAX(0,$F$13*$F$11-C26*(1/C$18-1/E$18)*3600)","v":3.9089552238806142},14.271428571428592,29.7]
[{"$f":"F49","v":"A"}]
[]
["Augmented Matrix (Tij + Bij)"]
[null,null,"Trailing Aircraft (Header Columns)"]
["Lead (column 1)",{"$f":"B49","v":"H"},{"$f":"C49","v":"G"},{"$f":"D49","v":"F"},{"$f":"E49","v":"B"},"A",null,"Expected Value"]
[{"$f":"B58","v":"H"},{"$f":"B50+B32","v":157.25905511811024},150.59552238805969,145.41428571428571,137.69999999999999,null,null,"E(Tij) + B(Tij)"]
[{"$f":"C58","v":"G"},165.40337289928311,150.59552238805969,145.41428571428571,137.69999999999999,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":155.4959485754579}]
[{"$f":"D58","v":"F"},171.73599550056241,156.92814498933902,145.41428571428571,137.69999999999999]
[{"$f":"E58","v":"B"},287.45028121484813,274.35671641791049,262.8428571428571,137.69999999999999]
[{"$f":"F58","v":"A"}]
[]
["Arrivals Only Capacity (per hour)",null,null,{"$f":"3600/H60","v":23.151728601166859}]
[]
[]
["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":"H"},{"$f":"C58","v":"G"},{"$f":"D58","v":"F"},{"$f":"E58","v":"B"},"A",null,"Expected Value",null,null,"Small","Large","B757","Heavy","S-Heavy","Expected Value"]
[{"$f":"B70","v":"H"},{"$f":"'Computations Base'!B71","v":60},{"$f":"'Computations Base'!C71","v":60},{"$f":"'Computations Base'!D71","v":60},{"$f":"'Computations Base'!E71","v":60},{"$f":"'Computations Base'!F71","v":0},null,"E(Td)",null,null,10,10,10,10,10,"E(Td)"]
[{"$f":"C70","v":"G"},{"$f":"'Computations Base'!B72","v":60},{"$f":"'Computations Base'!C72","v":60},{"$f":"'Computations Base'!D72","v":60},{"$f":"'Computations Base'!E72","v":60},{"$f":"'Computations Base'!F72","v":0},null,null,null,null,10,10,10,10,10]
[{"$f":"D70","v":"F"},{"$f":"'Computations Base'!B73","v":60},{"$f":"'Computations Base'!C73","v":60},{"$f":"'Computations Base'!D73","v":60},{"$f":"'Computations Base'!E73","v":60},{"$f":"'Computations Base'!F73","v":0},null,{"$f":"B71*$B$41+C71*$C$41+D71*$D$41+E71*$E$41+F41*$F$71+B72*$B$42+C72*$C$42+D72*$D$42+E72*$E$42+F72*$F$42+B73*$B$43+C73*$C$43+D73*$D$43+E73*$E$43+F73*$F$43+B74*$B$44+C74*$C$44+D74*$D$44+E74*$E$44+F74*$F$44+$B$45*B75+$C$45*C75+$D$45*D75+$E$45*E75+$F$45*F75","v":63},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}]
[{"$f":"E70","v":"B"},{"$f":"'Computations Base'!B74","v":120},{"$f":"'Computations Base'!C74","v":120},{"$f":"'Computations Base'!D74","v":120},{"$f":"'Computations Base'!E74","v":120},{"$f":"'Computations Base'!F74","v":0},null,null,null,null,10,10,10,10,10]
[{"$f":"F70","v":"A"},{"$f":"'Computations Base'!B75","v":0},{"$f":"'Computations Base'!C75","v":0},{"$f":"'Computations Base'!D75","v":0},{"$f":"'Computations Base'!E75","v":0},{"$f":"'Computations Base'!F75","v":0},null,null,null,null,10,10,10,10,10]
[]
["Departures Only Capacity (per hour) without buffers",null,null,{"$f":"3600/H73","v":57.142857142857146}]
[]
["Departure-Departure Separation Matrix with Buffers (seconds)"]
[null,null,"Trailing Aircraft (Header Columns)"]
["Lead (column 1)",{"$f":"B70","v":"H"},{"$f":"C70","v":"G"},"F","B","A",null,"Expected Value"]
[{"$f":"B81","v":"H"},{"$f":"'Computations Base'!B82","v":70},{"$f":"'Computations Base'!C82","v":70},{"$f":"'Computations Base'!D82","v":70},{"$f":"'Computations Base'!E82","v":70},{"$f":"'Computations Base'!F82","v":0},null,"E(Td)"]
[{"$f":"C81","v":"G"},{"$f":"'Computations Base'!B83","v":70},{"$f":"'Computations Base'!C83","v":70},{"$f":"'Computations Base'!D83","v":70},{"$f":"'Computations Base'!E83","v":70},{"$f":"'Computations Base'!F83","v":0}]
[{"$f":"D81","v":"F"},{"$f":"'Computations Base'!B84","v":70},{"$f":"'Computations Base'!C84","v":70},{"$f":"'Computations Base'!D84","v":70},{"$f":"'Computations Base'!E84","v":70},{"$f":"'Computations Base'!F84","v":0},null,{"$f":"B82*$B$41+C82*$C$41+D82*$D$41+E82*$E$41+F52*$F$71+B83*$B$42+C83*$C$42+D83*$D$42+E83*$E$42+F83*$F$42+B84*$B$43+C84*$C$43+D84*$D$43+E84*$E$43+F84*$F$43+B85*$B$44+C85*$C$44+D85*$D$44+E85*$E$44+F85*$F$44+$B$45*B86+$C$45*C86+$D$45*D86+$E$45*E86+$F$45*F86","v":73}]
[{"$f":"E81","v":"B"},{"$f":"'Computations Base'!B85","v":130},{"$f":"'Computations Base'!C85","v":130},{"$f":"'Computations Base'!D85","v":130},{"$f":"'Computations Base'!E85","v":130},{"$f":"'Computations Base'!F85","v":0}]
[{"$f":"F81","v":"A"},{"$f":"'Computations Base'!B86","v":0},{"$f":"'Computations Base'!C86","v":0},{"$f":"'Computations Base'!D86","v":0},{"$f":"'Computations Base'!E86","v":0},{"$f":"'Computations Base'!F86","v":0}]
[]
["Departures Only Capacity (per hour) - includes departure buffers",null,null,{"$f":"3600/H84","v":49.315068493150683}]
[]
[]
["Estimation of Critical Departure Gaps"]
[null,null,null,null,"E(ROT)",{"$f":"H16","v":49.45}]
["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":52.556607289760407}]
[1,null,{"$f":"$F$92+$F$93+$F$94+(A94-1)*$H$73","v":112.00660728976041},null,null,{"$f":"H13","v":10}]
[2,null,{"$f":"$F$92+$F$93+$F$94+(A95-1)*$H$73","v":175.00660728976041}]
[3,null,{"$f":"$F$92+$F$93+$F$94+(A96-1)*$H$73","v":238.00660728976041}]
[4,null,{"$f":"$F$92+$F$93+$F$94+(A97-1)*$H$73","v":301.00660728976038}]
[5,null,{"$f":"$F$92+$F$93+$F$94+(A98-1)*$H$73","v":364.00660728976038}]
[]
[]
["Departures per Gap"]
[null,null,"Trailing Aircraft (Header Columns)"]
["Lead (column 1)",{"$f":"B81","v":"H"},{"$f":"C81","v":"G"},"F","B","A"]
[{"$f":"B103","v":"H"},{"$f":"no_of_departures(B59,$C$94,$C$95,$C$96,$C$97)","v":1},1,1,{"$f":"no_of_departures(E59,$C$94,$C$95,$C$96,$C$97)","v":1},0]
[{"$f":"C103","v":"G"},1,1,1,1,0]
[{"$f":"D103","v":"F"},1,1,1,1,0]
[{"$f":"E103","v":"B"},3,3,3,1,0]
[{"$f":"F103","v":"A"},0,0,0,0,0]
[]
["Departures per hour with 100% Arrival Priority"]
[]
[null,null,"Trailing Aircraft (Header Columns)"]
["Lead (column 1)",{"$f":"B103","v":"H"},{"$f":"C103","v":"G"},"F","B","A","Sum"]
[{"$f":"B113","v":"H"},{"$f":"B104*($D$65-1)*B41","v":5.5379321502917148E-2},0.49841389352625431,0.49841389352625431,5.5379321502917148E-2,0,{"$f":"B114+C114+D114+E114+F114","v":1.1075864300583429}]
[{"$f":"C113","v":"G"},0.49841389352625431,4.4857250417362895,4.4857250417362895,0.49841389352625431,0,{"$f":"B115+C115+D115+E115+F115","v":9.968277870525089}]
[{"$f":"D113","v":"F"},0.49841389352625431,4.4857250417362895,4.4857250417362895,0.49841389352625431,0,{"$f":"B116+C116+D116+E116+F116","v":9.968277870525089}]
[{"$f":"E113","v":"B"},0.16613796450875143,1.4952416805787627,1.4952416805787627,5.5379321502917148E-2,0,{"$f":"B117+C117+D117+E117+F117","v":3.212000647169194}]
[{"$f":"F113","v":"A"},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.256142818277713},"Total Departures"]
["Summary for Arrival - Departure Diagram",null,null,null,null,null,null,"with 100% arrival priority"]