{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Computations","Program Description","Other Calculations"],"not_rendered":{"charts":2,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":"1904"}

{"sheet":"Computations","index":0,"n_rows":106,"n_cols":11,"rows_kept":106,"cut":false,"hidden":false,"merged":[]}
["Runway Saturation Capacity Estimation"]
["Using the Analyical Model of Harris"]
[]
["Programmer: A. Trani (Jan 2002)"]
["Amendments:",1,"2003-04-07",null,"Corrected formula to estimate E(delta j)"]
[null,2,"2010-10-01",null,"Added units to each block of calculations"]
[]
["Technical Parameters (inputs)",null,null,null,"Parameter","Values","Units","Notes"]
["Dep-Arrival Separation (nm)",null,null,null,"d",2,"nm","arrival-departure separation"]
["Common Approach Length (nm)",null,null,null,"g",7,"nm","common approach length"]
["Standard deviation of Position Delivery Error (s)",null,null,null,"s",16,"seconds","standard deviation of in-trail delivery error"]
["Probability of Violation",null,null,null,"Pv",5,"dim","probability of violation"]
["Cumulative Normal at Pv",null,null,null,"qv",{"$f":"qv_computation(F12)","v":1.65},"dim","cumulative normal at Pv"]
[null,null,null,null,"e",10,"seconds","clear for takeoff time lag"]
[null,"Small","Large ","Heavy"]
["ROT (s)",48,55,62,{"$f":"B16*B17/100+C16*C17/100+D16*D17/100","v":56.05},"E(ROT)"]
["Percent Mix",10,65,25,{"$f":"B17+C17+D17","v":100},"Total %"]
["Vapproach (knots)",125,145,155]
[]
["Minimum Separation Matrix (nm)",null,null,"Arrivals-Arrivals",null,"Airport Type"]
[null,null,"Trailing",null,null,"Small"]
[null,"Small","Large","Heavy"]
["Small",{"$f":"IF($F$21=\"large\",2.5,3)*$F$27","v":3},{"$f":"IF($F$21=\"large\",2.5,3)*$F$27","v":3},{"$f":"IF($F$21=\"large\",2.5,3)*$F$27","v":3},null,"Weather Conditions"]
["Large",{"$f":"IF($F$21=\"large\",4,5)*$F$27","v":5},{"$f":"IF($F$21=\"large\",2.5,3)*$F$27","v":3},{"$f":"IF($F$21=\"large\",2.5,3)*$F$27","v":3},null,"IFR"]
["Heavy",6,{"$f":"IF($F$21=\"large\",5,5)*$F$27","v":5},3,null,null,null,null,null,"Weather Condition","Separation Multiplier"]
[null,null,null,null,null,"Separation Multiplier for Weather Conditions",null,null,null,"IFR",1]
[null,null,null,null,null,{"$f":"INDEX(weather_multiplier,MATCH(F24,weather,0))","v":1},null,null,null,"VFR",0.8]
["Error Free Separation Matrix (seconds)"]
[null,null,"Trailing"]
[null,"Small","Large","Heavy",null,"Expected Value"]
["Small",{"$f":"B23/B$18*3600","v":86.4},{"$f":"C23/C$18*3600","v":74.482758620689651},{"$f":"D23/D$18*3600","v":69.677419354838719},null,"E(Tij)"]
["Large",{"$f":"(B24/B$18+$F$10*(1/B$18-1/C$18))*3600","v":171.80689655172415},{"$f":"C24/C$18*3600","v":74.482758620689651},{"$f":"D24/D$18*3600","v":69.677419354838719},null,{"$f":"B31*B38+C31*C38+D31*D38+B32*B39+C32*C39+D32*D39+B33*B40+C33*C40+D33*D40","v":93.05107007786431}]
["Heavy",{"$f":"(B25/B$18+$F$10*(1/B$18-1/D$18))*3600","v":211.8193548387097},{"$f":"(C25/C$18+$F$10*(1/C$18-1/D$18))*3600","v":135.3503893214683},{"$f":"D25/D$18*3600","v":69.677419354838719}]
[]
["Pij Matrix (dim)"]
[null,null,"Trailing"]
[null,"Small","Large","Heavy",null,"Sum of Pij"]
["Small",{"$f":"B17/100*B17/100","v":0.01},{"$f":"B17/100*C17/100","v":6.5000000000000002E-2},{"$f":"B17/100*D17/100","v":2.5000000000000001E-2},null,{"$f":"B38+C38+D38","v":0.1}]
["Large",{"$f":"B17/100*C17/100","v":6.5000000000000002E-2},{"$f":"C17/100*C17/100","v":0.42249999999999999},{"$f":"C17/100*D17/100","v":0.16250000000000001},null,{"$f":"B39+C39+D39","v":0.65}]
["Heavy",{"$f":"B17/100*D17/100","v":2.5000000000000001E-2},{"$f":"C17/100*D17/100","v":0.16250000000000001},{"$f":"D17/100*D17/100","v":6.25E-2},null,{"$f":"B40+C40+D40","v":0.25}]
[null,null,null,null,null,{"$f":"F40+F39+F38","v":1}]
["Buffer Matrix (seconds)"]
[null,null,"Trailing"]
[null,"Small","Large","Heavy",null,"Expected Value"]
["Small",{"$f":"$F$13*$F$11","v":26.4},{"$f":"$F$13*$F$11","v":26.4},{"$f":"$F$13*$F$11","v":26.4},null,"B(Tij)"]
["Large",{"$f":"MAX(0,$F$13*$F$11-B24*(1/B$18-1/C$18)*3600)","v":6.537931034482753},{"$f":"$F$13*$F$11","v":26.4},{"$f":"$F$13*$F$11","v":26.4},null,{"$f":"B38*B45+C45*C38+D38*D45+B39*B46+C39*C46+D39*D46+B40*B47+C40*C47+D40*D47","v":23.147519466073412}]
["Heavy",{"$f":"MAX(0,$F$13*$F$11-B25*(1/B$18-1/D$18)*3600)","v":0},{"$f":"MAX(0,$F$13*$F$11-C25*(1/C$18-1/D$18)*3600)","v":18.391101223581757},{"$f":"$F$13*$F$11","v":26.4}]
[]
[]
["Augmented Matrix (Tij + Bij) (seconds)"]
[null,null,"Trailing"]
[null,"Small","Large","Heavy",null,"Expected Value"]
["Small",{"$f":"B45+B31","v":112.80000000000001},{"$f":"C45+C31","v":100.88275862068966},{"$f":"D45+D31","v":96.077419354838725},null,"E(Tij) + B(Tij)"]
["Large",{"$f":"B46+B32","v":178.34482758620692},100.88275862068966,96.077419354838725,null,{"$f":"B38*B53+C38*C53+D38*D53+B39*B54+C39*C54+D39*D54+B40*B55+C40*C55+D40*D55","v":116.19858954393771}]
["Heavy",211.8193548387097,153.74149054505006,96.077419354838725]
[]
["Arrivals Only Capacity (per hour)",null,null,{"$f":"3600/F54","v":30.981443183858495}]
[]
[]
["Departure-Departure Separation Matrix (seconds)"]
[null,null,"Trailing"]
[null,"Small","Large","Heavy",null,"Expected Value"]
["Small",60,{"$f":"B63","v":60},{"$f":"C63","v":60},null,"E(Td)"]
["Large",60,60,90,null,{"$f":"(B63*B38+C38*C63+D63*D38+B39*B64+C64*C39+D39*D64+B65*B40+C40*C65+D65*D40)","v":79.875}]
["Heavy",120,120,120]
[]
["Departures Only Capacity (per hour)",null,null,{"$f":"3600/F64","v":45.070422535211264}]
[]
["Estimation of Critical Departure Gaps (seconds)"]
[null,null,null,null,"E(ROT)",{"$f":"E16","v":56.05},"seconds"]
["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)*3600","v":49.64876529477197},"seconds"]
[1,null,{"$f":"$F$70+$F$71+$F$72+(A72-1)*$F$64","v":115.69876529477196},"seconds","sg*qv or e",{"$f":"F14","v":10},"seconds"]
[2,null,195.57376529477196,"seconds"]
[3,null,275.44876529477199,"seconds"]
[4,null,355.32376529477199,"seconds"]
[5,null,435.19876529477199,"seconds"]
[6,null,515.07376529477199,"seconds"]
[7,null,594.94876529477199,"seconds"]
[8,null,674.82376529477199,"seconds"]
[9,null,754.69876529477199,"seconds"]
[10,null,834.57376529477199,"seconds"]
[11,null,914.44876529477199,"seconds"]
[]
["Departures per Gap"]
[null,null,"Trailing"]
[null,"Small","Large","Heavy"]
["Small",{"$f":"no_of_departures(B53,$C$72,$C$73,$C$74,$C$75)","v":0},0,0]
["Large",1,0,0]
["Heavy",2,1,0]
[]
["Departures per hour with 100% Arrival Priority"]
[]
[null,null,"Trailing"]
[null,"Small","Large","Heavy",null,"Expected Value"]
["Small",{"$f":"B87*($D$57-1)*B38","v":0},0,0,null,{"$f":"B95+C95+D95","v":0}]
["Large",1.9487938069508022,0,0,null,{"$f":"B96+C96+D96","v":1.9487938069508022}]
["Heavy",1.4990721591929248,4.8719845173770056,0,null,{"$f":"B97+C97+D97","v":6.3710566765699301}]
[null,null,null,null,null,{"$f":"SUM(F95:F97)","v":8.3198504835207316},"Total Departures"]
[null,null,null,null,null,null,"with 100% arrival priority"]
["Summary for Arrival - Departure Diagram"]
[]
["Arrivals","Departures",null,"Operation Pattern",null,null,"Arrivals","Departures"]
[{"$f":"D57","v":30.981443183858495},0,null,"Arrivals Only",null,null,{"$f":"A103*2","v":61.96288636771699},{"$f":"2*B103","v":0}]
[{"$f":"A103","v":30.981443183858495},{"$f":"F98","v":8.3198504835207316},null,"100% Arrivals + Departures",null,null,{"$f":"G103","v":61.96288636771699},{"$f":"2*B104","v":16.639700967041463}]
[{"$f":"'Other Calculations'!D57","v":24.03845442517428},{"$f":"'Other Calculations'!F98","v":25.111915323439966},null,null,null,null,{"$f":"2*A105","v":48.076908850348559},{"$f":"2*B105","v":50.223830646879932}]
[0,{"$f":"D67","v":45.070422535211264},null,"Departures Only",null,null,0,{"$f":"2*B106","v":90.140845070422529}]

{"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":"Other Calculations","index":2,"n_rows":99,"n_cols":11,"rows_kept":99,"cut":false,"hidden":false,"merged":[]}
["This section of the program calculates new points in the"]
["Pareto diagram. These calculations vary the arrival-arrival"]
["separations (see cell H21) and then recalculates the new capacity"]
["of the runway. This mimics a controller that alows "]
["arrivals to be spread more and thus allow more departures"]
["on the same runway."]
[]
["Technical Parameters (inputs)",null,null,null,"Parameter","Values"]
["Dep-Arrival Separation (nm)",null,null,null,"d",{"$f":"Computations!F9","v":2}]
["Common Approach Length (nm)",null,null,null,"g",{"$f":"Computations!F10","v":7}]
["Standard deviation of Position Delivery Error (s)",null,null,null,"s",{"$f":"Computations!F11","v":16}]
["Probability of Violation",null,null,null,"Pv",{"$f":"Computations!F12","v":5},null,"Number of Runways",null,"Runway Occupancy"]
["Cumulative Normal at Pv",null,null,null,"qv",{"$f":"Computations!F13","v":1.65},null,2]
[]
[null,"TERP A","TERP B","TERP C"]
["ROT (s)",{"$f":"Computations!B16","v":48},{"$f":"Computations!C16","v":55},{"$f":"Computations!D16","v":62},{"$f":"B16*B17/100+C16*C17/100+D16*D17/100","v":56.05},"E(ROT)"]
["Percent Mix",{"$f":"Computations!B17","v":10},{"$f":"Computations!C17","v":65},{"$f":"Computations!D17","v":25},{"$f":"B17+C17+D17","v":100},"Total %"]
["Vapproach (knots)",{"$f":"Computations!B18","v":125},{"$f":"Computations!C18","v":145},{"$f":"Computations!D18","v":155}]
[]
["Separation Matrix (nm)",null,null,"Arrivals-Arrivals",null,"Airport Type",null,"Multiplier for new Arrival Separation Matrix"]
[null,null,"Trailing",null,null,{"$f":"Computations!F21","v":"Small"},null,1.39]
[null,"TERP A","TERP B","TERP C"]
["Small",{"$f":"Computations!B23*$H$21","v":4.17},{"$f":"Computations!C23*$H$21","v":4.17},{"$f":"Computations!D23*$H$21","v":4.17},null,"Weather Conditions"]
["Large",{"$f":"Computations!B24*$H$21","v":6.9499999999999993},{"$f":"Computations!C24*$H$21","v":4.17},{"$f":"Computations!D24*$H$21","v":4.17},null,{"$f":"Computations!F24","v":"IFR"}]
["Heavy",{"$f":"Computations!B25*$H$21","v":8.34},{"$f":"Computations!C25*$H$21","v":6.9499999999999993},{"$f":"Computations!D25*$H$21","v":4.17},null,null,null,null,null,"Weather Condition","Separation Multiplier"]
[null,null,null,null,null,"Separation Multiplier for Weather Conditions",null,null,null,"IFR",1]
[null,null,null,null,null,{"$f":"Computations!F27","v":1},null,null,null,"VFR",0.8]
[{"$f":"Computations!A28","v":"Error Free Separation Matrix (seconds)"}]
[null,null,"Trailing"]
[null,"Small","Large","Heavy",null,"Expected Value"]
["Small",{"$f":"B23/B$18*3600","v":120.096},{"$f":"C23/C$18*3600","v":103.53103448275861},{"$f":"D23/D$18*3600","v":96.851612903225814},null,"E(Tij)"]
["Large",{"$f":"(B24/B$18+$F$10*(1/B$18-1/C$18))*3600","v":227.96689655172412},{"$f":"C24/C$18*3600","v":103.53103448275861},{"$f":"D24/D$18*3600","v":96.851612903225814},null,{"$f":"B31*B38+C31*C38+D31*D38+B32*B39+C32*C39+D39*D32+B33*B40+C33*C40+D33*D40","v":127.54505432703}]
["Heavy",{"$f":"(B25/B$18+$F$10*(1/B$18-1/D$18))*3600","v":279.21135483870972},{"$f":"(C25/C$18+$F$10*(1/C$18-1/D$18))*3600","v":183.76418242491656},{"$f":"D25/D$18*3600","v":96.851612903225814}]
[]
[{"$f":"Computations!A35","v":"Pij Matrix (dim)"}]
[null,null,"Trailing"]
[null,"Small","Large","Heavy",null,"Sum of Pij"]
["Small",{"$f":"B17/100*B17/100","v":0.01},{"$f":"B17/100*C17/100","v":6.5000000000000002E-2},{"$f":"B17/100*D17/100","v":2.5000000000000001E-2},null,{"$f":"B38+C38+D38","v":0.1}]
["Large",{"$f":"B17/100*C17/100","v":6.5000000000000002E-2},{"$f":"C17/100*C17/100","v":0.42249999999999999},{"$f":"C17/100*D17/100","v":0.16250000000000001},null,{"$f":"B39+C39+D39","v":0.65}]
["Heavy",{"$f":"B17/100*D17/100","v":2.5000000000000001E-2},{"$f":"C17/100*D17/100","v":0.16250000000000001},{"$f":"D17/100*D17/100","v":6.25E-2},null,{"$f":"B40+C40+D40","v":0.25}]
[null,null,null,null,null,{"$f":"F40+F39+F38","v":1}]
[{"$f":"Computations!A42","v":"Buffer Matrix (seconds)"}]
[null,null,"Trailing"]
[null,"Small","Large","Heavy",null,"Expected Value"]
["Small",{"$f":"$F$13*$F$11","v":26.4},{"$f":"$F$13*$F$11","v":26.4},{"$f":"$F$13*$F$11","v":26.4},null,"B(Tij)"]
["Large",{"$f":"MAX(0,$F$13*$F$11-B24*(1/B$18-1/C$18)*3600)","v":0},{"$f":"$F$13*$F$11","v":26.4},{"$f":"$F$13*$F$11","v":26.4},null,{"$f":"B38*B45+C45*C38+D38*D45+B39*B46+C39*C46+D39*D46+B40*B47+C40*C47+D40*D47","v":22.214989988876528}]
["Heavy",{"$f":"MAX(0,$F$13*$F$11-B25*(1/B$18-1/D$18)*3600)","v":0},{"$f":"MAX(0,$F$13*$F$11-C25*(1/C$18-1/D$18)*3600)","v":15.267630700778644},{"$f":"$F$13*$F$11","v":26.4}]
[]
[]
[{"$f":"Computations!A50","v":"Augmented Matrix (Tij + Bij) (seconds)"}]
[null,null,"Trailing"]
[null,"Small","Large","Heavy",null,"Expected Value"]
["Small",{"$f":"B45+B31","v":146.49600000000001},{"$f":"C45+C31","v":129.93103448275861},{"$f":"D45+D31","v":123.2516129032258},null,"E(Tij) + B(Tij)"]
["Large",{"$f":"B46+B32","v":227.96689655172412},129.93103448275861,123.2516129032258,null,{"$f":"B38*B53+C38*C53+D38*D53+B39*B54+C39*C54+D39*D54+B40*B55+C40*C55+D40*D55","v":149.76004431590655}]
["Heavy",279.21135483870972,199.03181312569521,123.2516129032258]
[]
["Arrivals Only Capacity (per hour)",null,null,{"$f":"3600/F54","v":24.03845442517428}]
[]
[]
[{"$f":"Computations!A60","v":"Departure-Departure Separation Matrix (seconds)"}]
[null,null,"Trailing"]
[null,"Small","Large","Heavy",null,"Expected Value"]
["Small",60,{"$f":"B63","v":60},{"$f":"C63","v":60},null,"E(Td)"]
["Large",90,90,90,null,{"$f":"(B63*B38+C38*C63+D63*D38+B39*B64+C64*C39+D39*D64+B65*B40+C40*C65+D65*D40)","v":94.5}]
["Heavy",120,120,120]
[]
["Departures Only Capacity (per hour)",null,null,{"$f":"3600/F64","v":38.095238095238095}]
[]
[{"$f":"Computations!A69","v":"Estimation of Critical Departure Gaps (seconds)"}]
[null,null,null,null,"E(ROT)",{"$f":"E16","v":56.05}]
["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)*3600","v":49.64876529477197}]
[1,null,{"$f":"$F$70+$F$71+$F$72+(A72-1)*$F$64","v":115.69876529477196},null,"sg*qv",{"$f":"Computations!F72","v":10}]
[2,null,210.19876529477196]
[3,null,304.69876529477199]
[4,null,399.19876529477199]
[5,null,493.69876529477199]
[6,null,588.19876529477199]
[7,null,682.69876529477199]
[8,null,777.19876529477199]
[9,null,871.69876529477199]
[10,null,966.19876529477199]
[11,null,1060.6987652947719]
[]
["Departures per Gap"]
[null,null,"Trailing"]
[null,"Small","Large","Heavy"]
["Small",{"$f":"no_of_departures(B53,$C$72,$C$73,$C$74,$C$75)","v":1},1,1]
["Large",2,1,1]
["Heavy",2,1,1]
[]
["Departures per hour with 100% Arrival Priority"]
[]
[null,null,"Trailing"]
[null,"Small","Large","Heavy",null,"Expected Value"]
["Small",{"$f":"B87*($D$57-1)*B38","v":0.23038454425174279},1.4974995376363283,0.57596136062935699,null,{"$f":"B95+C95+D95","v":2.303845442517428}]
["Large",2.9949990752726565,9.7337469946361335,3.7437488440908204,null,{"$f":"B96+C96+D96","v":16.472494913999611}]
["Heavy",1.151922721258714,3.7437488440908204,1.4399034015733925,null,{"$f":"B97+C97+D97","v":6.3355749669229269}]
[null,null,null,null,null,{"$f":"SUM(F95:F97)","v":25.111915323439966},"Total Departures"]
[null,null,null,null,null,null,"with 100% arrival priority"]