{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["CBA","Aircrafts","Costs","Safety statistics"],"not_rendered":{"charts":0,"images":9,"macros":1,"external_links":1,"defined_names":11,"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":"CBA","index":0,"n_rows":64,"n_cols":23,"rows_kept":64,"cut":false,"hidden":false,"merged":[[61,2,61,4],[0,1,1,10],[17,2,17,4],[18,2,18,4],[19,2,19,4],[20,2,20,4],[34,2,34,4],[35,2,35,4],[36,2,36,4],[60,2,60,4],[23,2,23,4],[24,2,24,4],[25,2,25,4],[30,2,30,4],[31,2,31,4],[26,2,26,4]]}
[null,"COST BENEFIT ANALYSIS"]
[]
[]
["PRELIMINARY NOTES"]
[null,"1)","Please enable Macros on the Excel file. "]
[]
[null,"2) ",null,null,"Green color cells can be filled by the reader"]
[]
[null,"3) ",null,null,"Yellow color cells are drop-down lists that can be selected by the reader"]
[]
[]
[]
[]
["ASSUMPTIONS"]
[]
[]
[null,"GENERAL ASSUMPTIONS"]
[null,null,"Fleet",null,null,"Number of aircrafts",2]
[null,null,"Aircraft type",null,null,null,"Bombardier CRJ-200ER"]
[null,null,"QAR already installed",null,null,null,"No",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G21=\"Yes\",\"Yes\",\"\")","v":"Yes"},{"$f":"IF(G20=\"Yes\",\"\",\"Yes\")","v":"Yes"}]
[null,null,{"$f":"IF(G20=\"Yes\",\"\",\"Airline desires to run the FDAP only through the FDR\")","v":"Airline desires to run the FDAP only through the FDR"},null,null,null,"Yes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G21=\"Yes\",\"No\",\"\")","v":"No"},{"$f":"IF(G20=\"Yes\",\"\",\"No\")","v":"No"}]
[]
[null,"PURCHASE AND INSTALLATION (HARDWARE AND PAPERWORK)"]
[null,null,"QAR purchasing cost",null,null,"Dollars/Aircraft",15000]
[null,null,"STC cost",null,null,"Dollars",{"$f":"IF($G$24=10000,Costs!D5,IF($G$24=5000,Costs!D6,0))","v":0}]
[null,null,"QAR installation time",null,null,"Hours",12]
[null,null,{"$f":"IF(G21=\"Yes\",\"FDR is accessible\",\"\")","v":"FDR is accessible"},null,null,null,"Yes"]
[]
[]
[null,"FLIGHT DATA ANALYSIS SERVICE COST"]
[null,null,"Total flights per fleet per month",null,null,"Total flights/Month",100]
[null,null,"FDM Service cost type",null,null,null,"Flat fee per number of aircrafts"]
[]
[null,"BENEFITS - AVOIDED AIRCRAFT ON GROUND"]
[null,null,"Costs of having an aircraft on ground (AOG)",null,null,"Costs/Day",1500]
[null,null,"Avoided days of Aircraft on Ground (AOG)",null,null,"Days/Year",5]
[null,null,"Number of aircrafts that benefited from avoided AOG",null,null,"Number of aircrafts",{"$f":"fleet","v":2}]
[]
[null,"BENEFITS - AVOIDED AIRCRAFT HULL LOSS",null,null,null,null,"No"]
[]
[]
[]
[]
["COST BENEFIT ANALYSIS"]
[]
[]
[null,null,null,null,null,null,null,"Year 1","Year 2","Year 3","Year 4","Year 5","Year 6","Year 7","Year 8","Year 9","Year 10"]
[null,"COST",null,null,null,null,null,{"$f":"H49+H56","v":9000},{"$f":"I49+I56","v":9000},9000,9000,9000,9000,9000,9000,9000,9000]
[null,null,"Investment cost (Hardware and paperwork)",null,null,null,null,{"$f":"+SUM(H50:H53)","v":0},{"$f":"+SUM(I50:I53)","v":0},0,0,0,0,0,0,0,0]
[null,null,null,"QAR Purchase",null,"USD",null,{"$f":"IF(AND(G20=\"No\",G21<>\"Yes\"),G24*fleet,0)","v":0}]
[null,null,null,"QAR Installation",null,"USD",null,{"$f":"IF(AND(G20=\"No\",G21<>\"Yes\"),$G$26*Costs!$E$7,0)","v":0}]
[null,null,null,"STC cost",null,"USD",null,{"$f":"IF(AND(G20=\"No\",G21<>\"Yes\"),$G$25,0)","v":0}]
[null,null,null,"Handhell Multipurpose Interface cost",null,"USD",null,{"$f":"IF(G27=\"No\",Costs!$C$21,\"\")","v":""}]
[]
[]
[null,null,"Flight Data Analysis Service cost",null,null,null,null,{"$f":"+H57","v":9000},{"$f":"+I57","v":9000},{"$f":"+J57","v":9000},9000,9000,9000,9000,9000,9000,9000]
[null,null,null,null,"FDM service cost","USD",null,{"$f":"IF(G32=\"Flat fee per number of aircrafts\",Costs!$G$16*fleet,IF(G32=\"Fee per total flights\",Costs!$C$12*fleet+12*IF(CBA!G31<=100,Costs!$E$12,IF(AND(CBA!G31>100,CBA!G31<=1000),Costs!$E$12+Costs!$F$13*(CBA!G31-100),IF(AND(CBA!G31>1000,CBA!G31<=10000),Costs!$E$12+Costs!$F$13*(1000-100)+Costs!$F$14*(CBA!$G$31-1000),IF(CBA!G31>10000,Costs!$E$12+Costs!$F$13*(1000-100)+Costs!$F$14*(10000-1000)+Costs!$F$15*(CBA!G31-10000),\"\"))))))","v":9000},{"$f":"IF($G$32=\"Flat fee per number of aircrafts\",Costs!$G$16*fleet,IF($G$32=\"Fee per total flights\",12*IF(CBA!$G$31<=100,Costs!$E$12,IF(AND(CBA!$G$31>100,CBA!$G$31<=1000),Costs!$E$12+Costs!$F$13*(CBA!$G$31-100),IF(AND(CBA!$G$31>1000,CBA!$G$31<=10000),Costs!$E$12+Costs!$F$13*(1000-100)+Costs!$F$14*(CBA!G$31-1000),IF(CBA!$G$31>10000,Costs!$E$12+Costs!$F$13*(1000-100)+Costs!$F$14*(10000-1000)+Costs!$F$15*(CBA!$G$31-10000),\"\"))))))","v":9000},{"$f":"IF($G$32=\"Flat fee per number of aircrafts\",Costs!$G$16*fleet,IF($G$32=\"Fee per total flights\",12*IF(CBA!$G$31<=100,Costs!$E$12,IF(AND(CBA!$G$31>100,CBA!$G$31<=1000),Costs!$E$12+Costs!$F$13*(CBA!$G$31-100),IF(AND(CBA!$G$31>1000,CBA!$G$31<=10000),Costs!$E$12+Costs!$F$13*(1000-100)+Costs!$F$14*(CBA!G$31-1000),IF(CBA!$G$31>10000,Costs!$E$12+Costs!$F$13*(1000-100)+Costs!$F$14*(10000-1000)+Costs!$F$15*(CBA!$G$31-10000),\"\"))))))","v":9000},{"$f":"IF($G$32=\"Flat fee per number of aircrafts\",Costs!$G$16*fleet,IF($G$32=\"Fee per total flights\",12*IF(CBA!$G$31<=100,Costs!$E$12,IF(AND(CBA!$G$31>100,CBA!$G$31<=1000),Costs!$E$12+Costs!$F$13*(CBA!$G$31-100),IF(AND(CBA!$G$31>1000,CBA!$G$31<=10000),Costs!$E$12+Costs!$F$13*(1000-100)+Costs!$F$14*(CBA!G$31-1000),IF(CBA!$G$31>10000,Costs!$E$12+Costs!$F$13*(1000-100)+Costs!$F$14*(10000-1000)+Costs!$F$15*(CBA!$G$31-10000),\"\"))))))","v":9000},{"$f":"IF($G$32=\"Flat fee per number of aircrafts\",Costs!$G$16*fleet,IF($G$32=\"Fee per total flights\",12*IF(CBA!$G$31<=100,Costs!$E$12,IF(AND(CBA!$G$31>100,CBA!$G$31<=1000),Costs!$E$12+Costs!$F$13*(CBA!$G$31-100),IF(AND(CBA!$G$31>1000,CBA!$G$31<=10000),Costs!$E$12+Costs!$F$13*(1000-100)+Costs!$F$14*(CBA!G$31-1000),IF(CBA!$G$31>10000,Costs!$E$12+Costs!$F$13*(1000-100)+Costs!$F$14*(10000-1000)+Costs!$F$15*(CBA!$G$31-10000),\"\"))))))","v":9000},{"$f":"IF($G$32=\"Flat fee per number of aircrafts\",Costs!$G$16*fleet,IF($G$32=\"Fee per total flights\",12*IF(CBA!$G$31<=100,Costs!$E$12,IF(AND(CBA!$G$31>100,CBA!$G$31<=1000),Costs!$E$12+Costs!$F$13*(CBA!$G$31-100),IF(AND(CBA!$G$31>1000,CBA!$G$31<=10000),Costs!$E$12+Costs!$F$13*(1000-100)+Costs!$F$14*(CBA!G$31-1000),IF(CBA!$G$31>10000,Costs!$E$12+Costs!$F$13*(1000-100)+Costs!$F$14*(10000-1000)+Costs!$F$15*(CBA!$G$31-10000),\"\"))))))","v":9000},{"$f":"IF($G$32=\"Flat fee per number of aircrafts\",Costs!$G$16*fleet,IF($G$32=\"Fee per total flights\",12*IF(CBA!$G$31<=100,Costs!$E$12,IF(AND(CBA!$G$31>100,CBA!$G$31<=1000),Costs!$E$12+Costs!$F$13*(CBA!$G$31-100),IF(AND(CBA!$G$31>1000,CBA!$G$31<=10000),Costs!$E$12+Costs!$F$13*(1000-100)+Costs!$F$14*(CBA!G$31-1000),IF(CBA!$G$31>10000,Costs!$E$12+Costs!$F$13*(1000-100)+Costs!$F$14*(10000-1000)+Costs!$F$15*(CBA!$G$31-10000),\"\"))))))","v":9000},{"$f":"IF($G$32=\"Flat fee per number of aircrafts\",Costs!$G$16*fleet,IF($G$32=\"Fee per total flights\",12*IF(CBA!$G$31<=100,Costs!$E$12,IF(AND(CBA!$G$31>100,CBA!$G$31<=1000),Costs!$E$12+Costs!$F$13*(CBA!$G$31-100),IF(AND(CBA!$G$31>1000,CBA!$G$31<=10000),Costs!$E$12+Costs!$F$13*(1000-100)+Costs!$F$14*(CBA!H$31-1000),IF(CBA!$G$31>10000,Costs!$E$12+Costs!$F$13*(1000-100)+Costs!$F$14*(10000-1000)+Costs!$F$15*(CBA!$G$31-10000),\"\"))))))","v":9000},{"$f":"IF($G$32=\"Flat fee per number of aircrafts\",Costs!$G$16*fleet,IF($G$32=\"Fee per total flights\",12*IF(CBA!$G$31<=100,Costs!$E$12,IF(AND(CBA!$G$31>100,CBA!$G$31<=1000),Costs!$E$12+Costs!$F$13*(CBA!$G$31-100),IF(AND(CBA!$G$31>1000,CBA!$G$31<=10000),Costs!$E$12+Costs!$F$13*(1000-100)+Costs!$F$14*(CBA!I$31-1000),IF(CBA!$G$31>10000,Costs!$E$12+Costs!$F$13*(1000-100)+Costs!$F$14*(10000-1000)+Costs!$F$15*(CBA!$G$31-10000),\"\"))))))","v":9000},{"$f":"IF($G$32=\"Flat fee per number of aircrafts\",Costs!$G$16*fleet,IF($G$32=\"Fee per total flights\",12*IF(CBA!$G$31<=100,Costs!$E$12,IF(AND(CBA!$G$31>100,CBA!$G$31<=1000),Costs!$E$12+Costs!$F$13*(CBA!$G$31-100),IF(AND(CBA!$G$31>1000,CBA!$G$31<=10000),Costs!$E$12+Costs!$F$13*(1000-100)+Costs!$F$14*(CBA!J$31-1000),IF(CBA!$G$31>10000,Costs!$E$12+Costs!$F$13*(1000-100)+Costs!$F$14*(10000-1000)+Costs!$F$15*(CBA!$G$31-10000),\"\"))))))","v":9000}]
[]
[]
[null,"BENEFITS",null,null,null,null,null,{"$f":"SUM(H61:H62)","v":15000},15000,15000,15000,15000,15000,15000,15000,15000,{"$f":"SUM(Q61:Q62)","v":15000}]
[null,null,"Avoided days of Aircraft on Ground",null,null,"USD",null,{"$f":"$G$37*$G$35*$G$36","v":15000},{"$f":"$G$37*$G$35*$G$36","v":15000},15000,15000,15000,15000,15000,15000,15000,15000]
[null,null,"Avoided aircraft hull loss",null,null,"USD",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G39=\"No\",\"\",1000000*INDEX(Aircrafts!$C$17:$C$24,MATCH(CBA!$G$19,Aircrafts!$B$17:$B$24,0)))","v":""}]
[]
[null,"BENEFIT-COST RATIO",null,null,null,null,null,{"$f":"H60/H48","v":1.6666666666666667},{"$f":"I60/I48","v":1.6666666666666667},1.6666666666666667,1.6666666666666667,1.6666666666666667,1.6666666666666667,1.6666666666666667,1.6666666666666667,1.6666666666666667,1.6666666666666667]

{"sheet":"Aircrafts","index":1,"n_rows":24,"n_cols":10,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Aircraft type","MTOW (kg.)","Source"]
[null,"Bombardier CRJ-200ER",23133,null,null,null,null,null,null,"Yes"]
[null,"ATR 72-600",23000,null,null,null,null,null,null,"No"]
[null,"ATR 72-500",22800]
[null,"Embraer ERJ-145LR",22000]
[null,"Bombardier CRJ-200LR",24041]
[null,"Embraer ERJ-145XR",24100]
[null,"Saab 340B",13155]
[null,"Embraer EMB-135BJ Legacy 600",22500]
[]
[]
[]
[]
[null,"Aircraft type","COST (Million USD/aircraft)","Source"]
[null,"Bombardier CRJ-200ER",24.375,"Fly radius"]
[null,"ATR 72-600",26,"Flight Global"]
[null,"ATR 72-500",19.39,"VirtAirLines"]
[null,"Embraer ERJ-145LR",21,"Aircraft compare"]
[null,"Bombardier CRJ-200LR",24.375,"Fly radius"]
[null,"Embraer ERJ-145XR",24,"Aircraft Compare"]
[null,"Saab 340B",10,"Aircraft compare"]
[null,"Embraer EMB-135BJ Legacy 600",25,"Aircraft compare"]

{"sheet":"Costs","index":2,"n_rows":29,"n_cols":12,"rows_kept":29,"cut":false,"hidden":false,"merged":[[9,1,9,6],[2,1,2,4],[25,1,25,4],[18,1,18,2],[11,1,14,1]]}
[]
[]
[null,"QAR"]
[null,"Source","QAR cost (USD/Aircraft)","STC cost (USD)","Installation cost (USD/Hours)",null,null,null,null,null,null,"FDM Service cost type"]
[null,"Company 1",10000,5000,null,null,null,null,null,null,null,"Fee per total flights"]
[null,"Company 2",5000,1500,null,null,null,null,null,null,null,"Flat fee per number of aircrafts"]
[null,"Company 3",15000,0,80]
[]
[]
[null,"Flight Data Monitoring service"]
[null,"Source","Fixed cost (USD)/Aircraft","Flights uploaded per month","Monthly charge (USD/month)","Additional charge (USD/flight)","Annual fee (USD/aircraft/year)"]
[null,"Company 1",{"$f":"4500/1.1171","v":4028.2875302121565},"< 100",{"$f":"1000/1.1171","v":895.17500671381254},0]
[null,null,null,"101 - 1000",null,3]
[null,null,null,"1001 - 10000",null,1.5]
[null,null,null,"> 10,000",null,1]
[null,"Company 2",null,null,null,null,4500]
[]
[]
[null,"Handhell Multipurpose Interface"]
[null,"Source","Cost (USD)"]
[null,"Company 1",10000]
[]
[]
[]
[]
[null,"Costs of having an aicraft on ground"]
[null,"Source","Min. Cost (USD/Day)","Max. Cost (USD/Day)","Average cost (USD/Day)"]
[null,"Company 2",1500,1500,{"$f":"AVERAGE(C28:D28)","v":1500}]
[null,"Company 3",5000,20000,{"$f":"AVERAGE(C29:D29)","v":12500}]

{"sheet":"Safety statistics","index":3,"n_rows":4,"n_cols":4,"rows_kept":4,"cut":false,"hidden":false,"merged":[[2,3,3,3]]}
[]
[null,2015,2016,"Source"]
["Hull loss accident rate (Number of accidents per 1 million flights)",0.32,0.39,"IATA"]
["All accident rate (Number of accidents per 1 million flights)",1.79,1.61]