{"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":2.4000000000000004},{"$f":"IF($F$21=\"large\",2.5,3)*$F$27","v":2.4000000000000004},{"$f":"IF($F$21=\"large\",2.5,3)*$F$27","v":2.4000000000000004},null,"Weather Conditions"]
["Large",5,{"$f":"IF($F$21=\"large\",2.5,3)*$F$27","v":2.4000000000000004},{"$f":"IF($F$21=\"large\",2.5,3)*$F$27","v":2.4000000000000004},null,"VFR"]
["Heavy",6,{"$f":"IF($F$21=\"large\",5,5)*$F$27","v":4},2.7,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":0.8},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":69.12},{"$f":"C23/C$18*3600","v":59.586206896551737},{"$f":"D23/D$18*3600","v":55.741935483870975},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":59.586206896551737},{"$f":"D24/D$18*3600","v":55.741935483870975},null,{"$f":"B31*B38+C31*C38+D31*D38+B32*B39+C32*C39+D32*D39+B33*B40+C33*C40+D33*D40","v":78.533331256952181}]
["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":110.52280311457174},{"$f":"D25/D$18*3600","v":62.709677419354847}]
[]
["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.407808676307006}]
["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":19.992880978865408},{"$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":95.52000000000001},{"$f":"C45+C31","v":85.986206896551735},{"$f":"D45+D31","v":82.141935483870981},null,"E(Tij) + B(Tij)"]
["Large",{"$f":"B46+B32","v":178.34482758620692},85.986206896551735,82.141935483870981,null,{"$f":"B38*B53+C38*C53+D38*D53+B39*B54+C39*C54+D39*D54+B40*B55+C40*C55+D40*D55","v":101.94113993325919}]
["Heavy",211.8193548387097,130.51568409343716,89.109677419354853]
[]
["Arrivals Only Capacity (per hour)",null,null,{"$f":"3600/F54","v":35.31449621180338}]
[]
[]
["Departure-Departure Separation Matrix (seconds)"]
[null,null,"Trailing"]
[null,"Small","Large","Heavy",null,"Expected Value"]
["Small",50,{"$f":"B63","v":50},{"$f":"C63","v":50},null,"E(Td)"]
["Large",50,50,75,null,{"$f":"(B63*B38+C38*C63+D63*D38+B39*B64+C64*C39+D39*D64+B65*B40+C40*C65+D65*D40)","v":64.0625}]
["Heavy",90,90,90]
[]
["Departures Only Capacity (per hour)",null,null,{"$f":"3600/F64","v":56.195121951219512}]
[]
["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,179.76126529477196,"seconds"]
[3,null,243.82376529477196,"seconds"]
[4,null,307.88626529477199,"seconds"]
[5,null,371.94876529477199,"seconds"]
[6,null,436.01126529477199,"seconds"]
[7,null,500.07376529477199,"seconds"]
[8,null,564.13626529477199,"seconds"]
[9,null,628.19876529477199,"seconds"]
[10,null,692.26126529477199,"seconds"]
[11,null,756.32376529477199,"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",2.2304422537672197,0,0,null,{"$f":"B96+C96+D96","v":2.2304422537672197}]
["Heavy",1.715724810590169,5.5761056344180497,0,null,{"$f":"B97+C97+D97","v":7.2918304450082188}]
[null,null,null,null,null,{"$f":"SUM(F95:F97)","v":9.5222726987754385},"Total Departures"]
[null,null,null,null,null,null,"with 100% arrival priority"]
["Summary for Arrival - Departure Diagram"]
[null,null,null,null,null,null,"For 2 parallel runways"]
["Arrivals","Departures",null,"Operation Pattern",null,null,"Arrivals","Departures"]
[{"$f":"D57","v":35.31449621180338},0,null,"Arrivals Only",null,null,{"$f":"A103*2","v":70.628992423606761},{"$f":"2*B103","v":0}]
[{"$f":"A103","v":35.31449621180338},{"$f":"F98","v":9.5222726987754385},null,"100% Arrivals + Departures",null,null,{"$f":"G103","v":70.628992423606761},{"$f":"2*B104","v":19.044545397550877}]
[{"$f":"'Other Calculations'!D57","v":24.297401193860392},{"$f":"'Other Calculations'!F98","v":25.976602331154336},null,null,null,null,{"$f":"2*A105","v":48.594802387720783},{"$f":"2*B105","v":51.953204662308671}]
[0,{"$f":"D67","v":56.195121951219512},null,"Departures Only",null,null,0,{"$f":"2*B106","v":112.39024390243902}]

{"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.64]
[null,"TERP A","TERP B","TERP C"]
["Small",{"$f":"Computations!B23*$H$21","v":3.9360000000000004},{"$f":"Computations!C23*$H$21","v":3.9360000000000004},{"$f":"Computations!D23*$H$21","v":3.9360000000000004},null,"Weather Conditions"]
["Large",{"$f":"Computations!B24*$H$21","v":8.1999999999999993},{"$f":"Computations!C24*$H$21","v":3.9360000000000004},{"$f":"Computations!D24*$H$21","v":3.9360000000000004},null,{"$f":"Computations!F24","v":"VFR"}]
["Heavy",{"$f":"Computations!B25*$H$21","v":9.84},{"$f":"Computations!C25*$H$21","v":6.56},{"$f":"Computations!D25*$H$21","v":4.4279999999999999},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":0.8},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":113.35680000000001},{"$f":"C23/C$18*3600","v":97.72137931034483},{"$f":"D23/D$18*3600","v":91.416774193548392},null,"E(Tij)"]
["Large",{"$f":"(B24/B$18+$F$10*(1/B$18-1/C$18))*3600","v":263.96689655172412},{"$f":"C24/C$18*3600","v":97.72137931034483},{"$f":"D24/D$18*3600","v":91.416774193548392},null,{"$f":"B31*B38+C31*C38+D31*D38+B32*B39+C32*C39+D39*D32+B33*B40+C33*C40+D33*D40","v":125.84749102558398}]
["Heavy",{"$f":"(B25/B$18+$F$10*(1/B$18-1/D$18))*3600","v":322.41135483870971},{"$f":"(C25/C$18+$F$10*(1/C$18-1/D$18))*3600","v":174.08142380422692},{"$f":"D25/D$18*3600","v":102.84387096774194}]
[]
[{"$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.31650278086763}]
["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.892324805339268},{"$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":139.7568},{"$f":"C45+C31","v":124.12137931034482},{"$f":"D45+D31","v":117.81677419354838},null,"E(Tij) + B(Tij)"]
["Large",{"$f":"B46+B32","v":263.96689655172412},124.12137931034482,117.81677419354838,null,{"$f":"B38*B53+C38*C53+D38*D53+B39*B54+C39*C54+D39*D54+B40*B55+C40*C55+D40*D55","v":148.16399380645157}]
["Heavy",322.41135483870971,189.97374860956617,129.24387096774194]
[]
["Arrivals Only Capacity (per hour)",null,null,{"$f":"3600/F54","v":24.297401193860392}]
[]
[]
[{"$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",3,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.23297401193860393},1.5143310776009256,0.58243502984650986,null,{"$f":"B95+C95+D95","v":2.3297401193860394}]
["Large",3.0286621552018511,9.843152004406015,3.7858276940023137,null,{"$f":"B96+C96+D96","v":16.65764185361018}]
["Heavy",1.7473050895395295,3.7858276940023137,1.4560875746162745,null,{"$f":"B97+C97+D97","v":6.9892203581581178}]
[null,null,null,null,null,{"$f":"SUM(F95:F97)","v":25.976602331154336},"Total Departures"]
[null,null,null,null,null,null,"with 100% arrival priority"]