{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Data1","Data","Scope","Menu","Modèle Crew","Modèle DSA","Sitrep","Modèle Crew1","Impressions"],"not_rendered":{"charts":0,"images":19,"macros":1,"external_links":0,"defined_names":19,"comments":0,"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":"Data1","index":0,"n_rows":20,"n_cols":23,"rows_kept":20,"cut":false,"hidden":true,"merged":[[0,0,0,22],[4,0,4,2],[8,0,8,2],[1,10,1,11],[2,0,2,1],[2,5,2,6],[2,7,2,8],[4,11,4,12],[2,12,2,13],[2,2,2,3],[2,18,2,19],[2,20,2,21],[12,0,12,2],[13,0,14,3],[17,0,17,3],[4,5,4,6],[4,7,4,8]]}
["CONTRACTOR EMPLOYEES & RELEVANT CERTIFICATE INFORMATION"]
[]
["NAME OF CARRIER: ",null,"AIRAVENIR",null,null,"MAIN BASE / CURRENT LOCATION:",null,"PARADISO",null,null,null,"UNO CALL SIGN : ","AV555",null,null,null,null,null,"CHARTER AGREEMENT NUMBER: ",null,12345]
[]
["CURRENT CREW     ",null,null,null,null,"Telephone number:",null,"xxx23xxx45xxx",null,null,"email:","xxxxxx@yyyyy.com ",null,null,null,"Date:",{"$f":"TODAY()","v":"2015-10-03"}]
["Title","First Name","Surname","Citizenship","Date of Birth","Passport \nNumber","Expiration \nof Passport","License Number","Expiration of\nLicense","Medical \nCertificate \nNumber","Expiration \nof Medical \nCertificate","Dangerous Goods \nCertificate Number","Expiration of \nDG Certificate","Total FH / \nFH on this A/C\nType & with this Title","FH on this A/C Type & with this Title ","Previous UN \nExperience (Y/N)","Arrival Date","Date on Duty","Estimated \nRotation Date","UNAMID \nID Card","Expiration of \nID Card","Briefing \ncompletion date","Sudan \nValidation Expiration"]
[]
[]
["NEXT ROTATION    "]
["Title","First Name","Surname","Citizenship","Date of Birth","Passport \nNumber","Expiration \nof Passport","License Number","Expiration of\nLicense","Medical \nCertificate \nNumber","Expiration \nof Medical \nCertificate","Dangerous Goods \nCertificate Number","Expiration of \nDG Certificate","Total FH / \nFH on this A/C\nType & with this Title","FH on this A/C Type & with this Title ","Previous UN \nExperience (Y/N)","Arrival Date","Date on Duty","Estimated \nRotation Date","UNAMID \nID Card","Expiration of \nID Card","Briefing \ncompletion date","Sudan Validation Expiration"]
[]
[]
["STAFF PER CONTRACT"]
["Number and type of Personel who would provide Operational and Groud Support of the Aircraft:",null,null,null,"By contract","Actual"]
[null,null,null,null,{"$f":"SUM(E16:E20)","v":7},{"$f":"SUM(F16:F20)","v":0}]
["a) Captain",null,null,null,1]
["b) Co-Pilot",null,null,null,1]
["c) Flight Attendants",null,null,null,2]
["d) Engineers",null,null,null,2]
["e) Site Manager",null,null,null,1]

{"sheet":"Data","index":1,"n_rows":13,"n_cols":11,"rows_kept":13,"cut":false,"hidden":true,"merged":[]}
["Documents",null,"Month",null,"Year",null,"Title","Title"]
["Crew Attendance Record",null,"2014-01-01",{"$f":"C2","v":"2014-01-01"},2014,null,"Site Manager","SITES MANAGERS",null,{"$f":"TEXT(K2,\"[$-409]mmmm;@\")","v":"January"},"2014-01-01"]
["DSA",null,"2014-02-01",{"$f":"C3","v":"2014-02-01"},2015,null,"Site Manager Assistant","SITE MANAGER ASSISTANTS",null,"February","2014-02-01"]
[null,null,"2014-03-01","2014-03-01",2016,null,"Captain","CAPTAINS",null,"March","2014-03-01"]
[null,null,"2014-04-01","2014-04-01",2017,null,"First Officer","FIRST OFFICERS",null,"April","2014-04-01"]
[null,null,"2014-05-01","2014-05-01",2018,null,"Cabin Chief","CABIN CHIEFS",null,"May","2014-05-01"]
[null,null,"2014-06-01","2014-06-01",2019,null,"Flight Attendant","FLIGHT ATTENDANTS",null,"June","2014-06-01"]
[null,null,"2014-07-01","2014-07-01",2020,null,"Engineer","ENGINEERS",null,"July","2014-07-01"]
[null,null,"2014-08-01","2014-08-01",2021,null,"Driver","DRIVERS",null,"August","2014-08-01"]
[null,null,"2014-09-01","2014-09-01",2022,null,"Cleaner","CLEANERS",null,"September","2014-09-01"]
[null,null,"2014-10-01","2014-10-01",2023,null,null,null,null,"October","2014-10-01"]
[null,null,"2014-11-01","2014-11-01",2024,null,null,null,null,"November","2014-11-01"]
[null,null,"2014-12-01","2014-12-01",2025,null,null,null,null,"December","2014-12-01"]

{"sheet":"Scope","index":2,"n_rows":28,"n_cols":50,"rows_kept":28,"cut":false,"hidden":false,"merged":[[1,42,1,44],[1,37,1,40],[1,5,1,6],[1,8,1,12],[1,13,1,14],[1,15,1,17],[1,27,1,30],[1,24,1,26],[1,18,1,19],[1,31,1,36],[1,22,1,23],[1,20,1,21]]}
[null,null,null,null,null,null,null,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]
[null,null,null,null,"UN","CHECK IN/OUT",null,null,"PASSPORT/ID",null,null,null,null,"RESIDENT VISA",null,"JAR LICENCE",null,null,"TYPE RATING",null,"SCAA Validation",null,"CRM",null,"DANGEROUS GOODS",null,null,"MEDICAL",null,null,null,"FLIGHT HOURS",null,null,null,null,null,"UN ID CARD",null,null,null,"UN DRIV","AIRPORT PASS",null,null,"BRIEFING","ENGLISH","LPC","OPC","ISO"]
["Last Name","First Name","Title","Location","Experience","In","Out","Nationality","Birth Date","Number","Issued","Expiry","Days","Expiry","Status","Licence N°","Expiry","Days","Expiry","Days","Expiry","Days","N°","Expiry","N°","Expiry","Days","N°","Class","Expiry","Days","Total","Total as PIC","PIC on Type","On Type","Instruments","At Night","Status","Expiry","Days","N°","LIC N°","N°","Expiry","Days","Date","Proficiency","Date","Date","Staff Name"]
["SITES MANAGERS","Colonne1","Colonne2","Colonne3","Colonne4","Colonne5","Colonne6","Colonne7","Colonne8","Colonne9","Colonne10","Colonne11","Colonne12","Colonne13","Colonne14","Colonne15","Colonne16","Colonne17","Colonne18","Colonne19","Colonne193","Colonne192","Colonne1923","Colonne1922","Colonne20","Colonne21","Colonne22","Colonne23","Colonne24","Colonne25","Colonne26","Colonne27","Colonne273","Colonne272","Colonne28","Colonne43","Colonne29","Colonne30","Colonne31","Colonne32","Colonne33","Colonne34","Colonne35","Colonne36","Colonne37","Colonne38","Colonne39","Colonne40","Colonne41","Colonne42"]
["PAPA","Pat","Site Manager","VY","Y","2015-04-22","2015-10-10","Congolese","1984-09-18","OB073","2014-12-26","2019-12-25",{"$f":"L5-TODAY()","v":1544},"09-Sep-15","NO","N/A","N/A",{"$f":"IF(Q5=\"N/A\",\"N/A\",IF(Q5=\"Unlimited\",\"N/A\",Q5-TODAY()))","v":"N/A"},"N/A","N/A",null,null,"",null,"221029","2015-11-30",{"$f":"IF(Y5=\"N/A\",\"N/A\",(Z5-TODAY()))","v":58},"N/A","N/A","N/A",{"$f":"IF(AB5=\"N/A\",\"N/A\",(AD5-TODAY()))","v":"N/A"},"N/A","N/A","N/A","N/A","N/A","N/A","Staff","2016-01-01",{"$f":"IF(AO5=\"N/A\",\"N/A\",(AM5-TODAY()))","v":90},4295,"","337","2015-09-22",{"$f":"IF(AT5=\"N/A\",\"N/A\",(AR5-TODAY()))","v":-11},"2015-09-07","N/A","N/A","N/A","DIALO "]
["SITE MANAGER ASSISTANTS","Colonne2","Colonne3","Colonne4","Colonne5","Colonne6","Colonne7","Colonne8","Colonne9","Colonne10","Colonne11","Colonne12","Colonne13","Colonne14","Colonne15","Colonne16","Colonne17","Colonne18","Colonne19","Colonne20","Colonne203","Colonne202","Colonne2023","Colonne2022","Colonne21","Colonne22","Colonne23","Colonne24","Colonne25","Colonne26","Colonne27","Colonne28","Colonne283","Colonne282","Colonne29","Colonne1","Colonne30","Colonne31","Colonne32","Colonne33","Colonne34","Colonne35","Colonne36","Colonne37","Colonne38","Colonne39","Colonne40","Colonne41","Colonne42","Colonne43"]
[]
["CAPTAINS","Colonne2","Colonne3","Colonne4","Colonne5","Colonne6","Colonne7","Colonne8","Colonne9","Colonne10","Colonne11","Colonne12","Colonne13","Colonne14","Colonne15","Colonne16","Colonne17","Colonne18","Colonne19","Colonne20","Colonne203","Colonne202","Colonne2023","Colonne2022","Colonne21","Colonne22","Colonne23","Colonne24","Colonne25","Colonne26","Colonne27","Colonne28","Colonne283","Colonne282","Colonne29","Colonne1","Colonne30","Colonne31","Colonne32","Colonne33","Colonne34","Colonne35","Colonne36","Colonne37","Colonne38","Colonne39","Colonne40","Colonne41","Colonne42","Colonne43"]
["XXXXX","Antonio","Captain","VY","Y","2015-10-14","2015-11-18","Spanish","1982-02-24","17189","2012-08-27","2016-11-14",670,"N/A","ID","6855","2015-05-31",{"$f":"IF(Q9=\"N/A\",\"N/A\",IF(Q9=\"Unlimited\",\"N/A\",Q9-TODAY()))","v":-125},"2015-05-31",{"$f":"IF(S9=\"N/A\",\"N/A\",IF(S9=\"Unlimited\",\"N/A\",S9-TODAY()))","v":-125},"",null,"",null,"22-Mar-1900","2016-09-13",-119,"8654","1","2015-09-19",{"$f":"IF(AB9=\"N/A\",\"N/A\",(AD9-TODAY()))","v":-14},"5947:38'","4447:38'","1423:20'","1575:05","N/A","1585:28'","TCU","2015-06-03",{"$f":"IF(AO9=\"N/A\",\"N/A\",(AM9-TODAY()))","v":-122},"699","N/A","N/A","N/A",{"$f":"IF(AQ9=\"N/A\",\"N/A\",(AR9-TODAY()))","v":"N/A"},"2014-07-22","2017-02-18","2014-03-01","2014-09-24"," DA CRUZ "]
["YYYYY","Carlos","Captain","VY","Y","2015-09-24","2015-12-31","Spanish","1978-01-22","362648","2011-04-01","2021-04-01",{"$f":"L10-TODAY()","v":2007},"N/A","ID","8643","Unlimited","N/A","2016-01-31",17,"2015-01-25","1900-04-23","",null,"0777","2017-01-31",{"$f":"IF(Y10=\"N/A\",\"N/A\",(Z10-TODAY()))","v":486},"5471","1","2015-07-20",{"$f":"IF(AB10=\"N/A\",\"N/A\",(AD10-TODAY()))","v":-75},"4355:14'","2656:6","1716:08'","4155:14'","4155:14'","1795:02'","Staff","2015-03-09",54,"592","956","N/A","N/A","N/A","2014-03-06","2018-01-31","2014-01-24","2015-01-13"," COLUBI "]
["ZZZZZ","Daniel","Captain","VY","Y","2014-08-14","2016-10-19","Deutch","1971-04-28","35349","2006-12-29","2016-12-28",714,"N/A","ID","01090","Unlimited","N/A","2014-10-31",-75,"2015-09-10",342,"",null,"1460","2015-09-18",247,"23818","1","2015-02-06",23,"6369:41'","","","3870:23'","N/A","129:43'","TCU","2014-10-12",-94,"268","220","N/A","N/A","N/A","2014-08-25","Unlimited","2013-09-16","2013-09-16"," Angel"]
["FIRST OFFICERS","Colonne2","Colonne3","Colonne4","Colonne5","Colonne6","Colonne7","Colonne8","Colonne9","Colonne10","Colonne11","Colonne12","Colonne13","Colonne14","Colonne15","Colonne16","Colonne17","Colonne18","Colonne19","Colonne20","Colonne203","Colonne202","Colonne2023","Colonne2022","Colonne21","Colonne22","Colonne23","Colonne24","Colonne25","Colonne26","Colonne27","Colonne28","Colonne283","Colonne282","Colonne29","Colonne1","Colonne30","Colonne31","Colonne32","Colonne33","Colonne34","Colonne35","Colonne36","Colonne37","Colonne38","Colonne39","Colonne40","Colonne41","Colonne42","Colonne43"]
["AAAA","Ismael","First Officer","NB","Y","2015-08-07","2015-11-18","Spanish","1974-11-23","79923","2015-01-28","2018-02-12",{"$f":"L13-TODAY()","v":863},"07-Sep-15","NO","01991","2016-05-31",null,"2016-05-31",null,"",null,"",null,"656","2017-04-30",null,"15995","2","2016-02-02",null,"2249:26","2556:10","N/A","1142:1","","","Staff","2016-02-06",{"$f":"IF(AO13=\"N/A\",\"N/A\",(AM13-TODAY()))","v":126},"283","N/A","","2015-09-24",null,"2015-08-17","","2015-04-25","2015-04-25",""]
["BBBBB","Jordi","First Officer","BU","N","2015-03-25","2015-10-14","Spanish","1982-09-16","111N","2013-05-06","2023-05-06",{"$f":"L14-TODAY()","v":2772},"N/A","ID","2308","Unlimited",{"$f":"IF(Q14=\"N/A\",\"N/A\",IF(Q14=\"Unlimited\",\"N/A\",Q14-TODAY()))","v":"N/A"},"2015-05-31",{"$f":"IF(S14=\"N/A\",\"N/A\",IF(S14=\"Unlimited\",\"N/A\",S14-TODAY()))","v":-125},"",null,"",null,"1676","2017-02-17",{"$f":"IF(Y14=\"N/A\",\"N/A\",(Z14-TODAY()))","v":503},"302","1","2015-04-11",{"$f":"IF(AB14=\"N/A\",\"N/A\",(AD14-TODAY()))","v":-175},"1889:45'","336:30","N/A","675:30'","","","","2015-05-17",{"$f":"IF(AO14=\"N/A\",\"N/A\",(AM14-TODAY()))","v":-139},"344","N/A","N/A","N/A",{"$f":"IF(AQ14=\"N/A\",\"N/A\",(AR14-TODAY()))","v":"N/A"},"2015-03-26","2017-03-31","2014-04-03","2014-10-15"," DIAZ "]
["CABIN CHIEFS","Colonne2","Colonne3","Colonne4","Colonne5","Colonne6","Colonne7","Colonne8","Colonne9","Colonne10","Colonne11","Colonne12","Colonne13","Colonne14","Colonne15","Colonne16","Colonne17","Colonne18","Colonne19","Colonne20","Colonne203","Colonne202","Colonne2023","Colonne2022","Colonne21","Colonne22","Colonne23","Colonne24","Colonne25","Colonne26","Colonne27","Colonne28","Colonne283","Colonne282","Colonne29","Colonne1","Colonne30","Colonne31","Colonne32","Colonne33","Colonne34","Colonne35","Colonne36","Colonne37","Colonne38","Colonne39","Colonne40","Colonne41","Colonne42","Colonne43"]
["ROMEO","Ruben","Cabin Chief","NY","Y","2015-09-22","2015-11-20","Spanish","1980-08-05","89","2013-09-05","2023-09-05",{"$f":"L16-TODAY()","v":2894},"N/A","OK","003","2017-04-08",815,"2016-06-30",533,"",null,"",null,970,"2015-03-31",{"$f":"IF(Y16=\"N/A\",\"N/A\",(Z16-TODAY()))","v":-186},1,"2","2016-03-21",{"$f":"IF(AB16=\"N/A\",\"N/A\",(AD16-TODAY()))","v":170},"N/A","N/A","N/A","N/A","N/A","N/A","Staff","2015-10-20",{"$f":"IF(AO16=\"N/A\",\"N/A\",(AM16-TODAY()))","v":17},4173,"N/A","N/A","N/A",{"$f":"IF(AQ16=\"N/A\",\"N/A\",(AR16-TODAY()))","v":"N/A"},"2015-09-22","N/A","N/A","N/A"," SANTANA"]
["FLIGHT ATTENDANTS","Colonne2","Colonne3","Colonne4","Colonne5","Colonne6","Colonne7","Colonne8","Colonne9","Colonne10","Colonne11","Colonne12","Colonne13","Colonne14","Colonne15","Colonne16","Colonne17","Colonne18","Colonne19","Colonne20","Colonne203","Colonne202","Colonne2023","Colonne2022","Colonne21","Colonne22","Colonne23","Colonne24","Colonne25","Colonne26","Colonne27","Colonne28","Colonne283","Colonne282","Colonne29","Colonne1","Colonne30","Colonne31","Colonne32","Colonne33","Colonne34","Colonne35","Colonne36","Colonne37","Colonne38","Colonne39","Colonne40","Colonne41","Colonne42","Colonne43"]
["CASTILLO GIRALDO","McGiver","Flight Attendant","BU","Y","2015-03-05","2015-05-22","Spanish","1990-10-19","60440","2013-08-07","07/08/2018",{"$f":"L18-TODAY()","v":1039},"N/A","ID","8560","Unlimited",{"$f":"IF(Q18=\"N/A\",\"N/A\",IF(Q18=\"Unlimited\",\"N/A\",Q18-TODAY()))","v":"N/A"},"N/A",{"$f":"IF(S18=\"N/A\",\"N/A\",IF(S18=\"Unlimited\",\"N/A\",S18-TODAY()))","v":"N/A"},"",null,"",null,"135","30/11/2016",null,590,2,"26/11/2019",null,"N/A","N/A","N/A","N/A","N/A","N/A",null,"2015-05-29",{"$f":"IF(AO18=\"N/A\",\"N/A\",(AM18-TODAY()))","v":-127},892,"N/A","N/A","N/A",{"$f":"IF(AQ18=\"N/A\",\"N/A\",(AR18-TODAY()))","v":"N/A"},null,"N/A","N/A","N/A","MORGAN"]
["TORREJON AQUINO","Magali","Flight Attendant","BU","N","2015-04-23","2015-07-23","Spanish","1990-01-10","6669","2013-03-06","2018-03-06",{"$f":"L19-TODAY()","v":885},"N/A","ID","3375","2015-04-22",null,"31-Mar-16",null,"N/A",null,"",null,"987","2017-05-31",null,64,"2","2016-12-19",null,"N/A","N/A","","N/A","N/A","N/A","","",null,"","N/A","N/A","N/A",null,"","N/A","N/A",null,"Kelian"]
["ENGINEERS","Colonne2","Colonne3","Colonne4","Colonne5","Colonne6","Colonne7","Colonne8","Colonne9","Colonne10","Colonne11","Colonne12","Colonne13","Colonne14","Colonne15","Colonne16","Colonne17","Colonne18","Colonne19","Colonne20","Colonne203","Colonne202","Colonne2023","Colonne2022","Colonne21","Colonne22","Colonne23","Colonne24","Colonne25","Colonne26","Colonne27","Colonne28","Colonne283","Colonne282","Colonne29","Colonne1","Colonne30","Colonne31","Colonne32","Colonne33","Colonne34","Colonne35","Colonne36","Colonne37","Colonne38","Colonne39","Colonne40","Colonne41","Colonne42","Colonne43"]
["JULIETTE","Juan ","Ground Engineer","VY","Y","2015-10-03","2015-12-31","Colombian","1975-01-18","18","2013-10-04","2024-10-04",{"$f":"L21-TODAY()","v":3289},"N/A","ID","68","2015-07-12",{"$f":"IF(Q21=\"N/A\",\"N/A\",IF(Q21=\"Unlimited\",\"N/A\",Q21-TODAY()))","v":-83},"N/A",{"$f":"IF(S21=\"N/A\",\"N/A\",IF(S21=\"Unlimited\",\"N/A\",S21-TODAY()))","v":"N/A"},"",null,"",null,"N/A","N/A",{"$f":"IF(Y21=\"N/A\",\"N/A\",(Z21-TODAY()))","v":"N/A"},"N/A","N/A","N/A",{"$f":"IF(AB21=\"N/A\",\"N/A\",(AD21-TODAY()))","v":"N/A"},"N/A","","","N/A","N/A","N/A","Staff","2015-06-24",{"$f":"IF(AO21=\"N/A\",\"N/A\",(AM21-TODAY()))","v":-101},739,1310,"143-J","2014-12-31",{"$f":"IF(AQ21=\"N/A\",\"N/A\",(AR21-TODAY()))","v":-276},"2014-10-06","N/A","N/A","N/A","Osca "]
["CICCIOLI","Alberto Mario","Maint Coord","BU","N",null,null,"Italian","1975-12-25","51096","2007-01-09","2017-01-08",463,"OK",null,"N/A","N/A","N/A","N/A","N/A",null,null,null,null,"N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A",null,null,"N/A","N/A","N/A",null,null,-42280,null,"N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","EXTRA STAFF"]
["DRIVERS","Colonne2","Colonne3","Colonne4","Colonne5","Colonne6","Colonne7","Colonne8","Colonne9","Colonne10","CRIMINAL","RECORD","Colonne13","Colonne14","Colonne15","Colonne16","Colonne17","Colonne18","Colonne19","Colonne20","Colonne203","Colonne202","Colonne2023","Colonne2022","Colonne21","Colonne22","Colonne23","Colonne24","Colonne25","Colonne26","Colonne27","Colonne28","Colonne283","Colonne282","Colonne29","Colonne1","Colonne30","Colonne31","Colonne32","Colonne33","Colonne34","Colonne35","Colonne36","Colonne37","Colonne38","Colonne39","Colonne40","Colonne41","Colonne42","Colonne43"]
["JACKSON ","Joseph","Driver","BU","N/A","N/A","2015-08-07","South Sudanese","1987-02-03","239","2015-04-20","2015-07-20",{"$f":"L24-TODAY()","v":-75},"N/A","N/A","N/A","N/A",{"$f":"IF(Q24=\"N/A\",\"N/A\",IF(Q24=\"Unlimited\",\"N/A\",Q24-TODAY()))","v":"N/A"},"N/A",{"$f":"IF(S24=\"N/A\",\"N/A\",IF(S24=\"Unlimited\",\"N/A\",S24-TODAY()))","v":"N/A"},"",null,null,null,"N/A","N/A",{"$f":"IF(Y24=\"N/A\",\"N/A\",(Z24-TODAY()))","v":"N/A"},"N/A","N/A","N/A",{"$f":"IF(AB24=\"N/A\",\"N/A\",(AD24-TODAY()))","v":"N/A"},"N/A",null,null,"N/A","N/A","N/A",null,"2015-08-10",{"$f":"IF(AO24=\"N/A\",\"N/A\",(AM24-TODAY()))","v":-54},917,"N/A","45-J","2014-12-31",{"$f":"IF(AQ24=\"N/A\",\"N/A\",(AR24-TODAY()))","v":-276},"N/A","N/A","N/A","N/A","N/A"]
["JOHN","Benoit","Driver","BU","N/A","N/A","2015-08-07","South Sudanese","1986-12-31","442","2015-04-14","2015-07-14",{"$f":"L25-TODAY()","v":-81},"N/A","N/A","N/A","N/A",{"$f":"IF(Q25=\"N/A\",\"N/A\",IF(Q25=\"Unlimited\",\"N/A\",Q25-TODAY()))","v":"N/A"},"N/A",{"$f":"IF(S25=\"N/A\",\"N/A\",IF(S25=\"Unlimited\",\"N/A\",S25-TODAY()))","v":"N/A"},"",null,"",null,"N/A","N/A",{"$f":"IF(Y25=\"N/A\",\"N/A\",(Z25-TODAY()))","v":"N/A"},"N/A","N/A","N/A",{"$f":"IF(AB25=\"N/A\",\"N/A\",(AD25-TODAY()))","v":"N/A"},"N/A",null,null,"N/A","N/A","N/A","STAFF","2015-08-10",{"$f":"IF(AO25=\"N/A\",\"N/A\",(AM25-TODAY()))","v":-54},749,"N/A","148-J","2014-12-31",{"$f":"IF(AQ25=\"N/A\",\"N/A\",(AR25-TODAY()))","v":-276},"N/A","N/A","N/A","N/A","N/A"]
["CLEANERS","Colonne2","Colonne3","Colonne4","Colonne5","Colonne6","Colonne7","Colonne8","Colonne9","Colonne10","Colonne11","Colonne12","Colonne13","Colonne14","Colonne15","Colonne16","Colonne17","Colonne18","Colonne19","Colonne20","Colonne203","Colonne202","Colonne2023","Colonne2022","Colonne21","Colonne22","Colonne23","Colonne24","Colonne25","Colonne26","Colonne27","Colonne28","Colonne29","Colonne1","Colonne30","Colonne31","Colonne32","Colonne33","Colonne34","Colonne35","Colonne36","Colonne37","Colonne38","Colonne39","Colonne40","Colonne41","Colonne42","Colonne43","Colonne44","Colonne45"]
["BIOR","Daniel","Cleaner","BU","N/A","N/A","2014-08-31","South Sudanese","1981-05-01","0909","2014-08-01","2014-11-30",{"$f":"L27-TODAY()","v":-307},"N/A","N/A","N/A","N/A",{"$f":"IF(Q27=\"N/A\",\"N/A\",IF(Q27=\"Unlimited\",\"N/A\",Q27-TODAY()))","v":"N/A"},"N/A",{"$f":"IF(S27=\"N/A\",\"N/A\",IF(S27=\"Unlimited\",\"N/A\",S27-TODAY()))","v":"N/A"},null,null,null,null,"N/A","N/A",{"$f":"IF(Y27=\"N/A\",\"N/A\",(Z27-TODAY()))","v":"N/A"},"N/A","N/A","N/A",{"$f":"IF(AB27=\"N/A\",\"N/A\",(AD27-TODAY()))","v":"N/A"},"N/A","N/A","N/A","N/A","JUB","2014-08-31",{"$f":"IF(AM27=\"N/A\",\"N/A\",(AK27-TODAY()))","v":-398},"740","N/A","011",3014,{"$f":"IF(AO27=\"N/A\",\"N/A\",(AP27-TODAY()))","v":-39266},"N/A","N/A","N/A","N/A","N/A"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"L28-TODAY()","v":-42280},null,null,null,null,{"$f":"IF(Q28=\"N/A\",\"N/A\",IF(Q28=\"Unlimited\",\"N/A\",Q28-TODAY()))","v":-42280},null,{"$f":"IF(S28=\"N/A\",\"N/A\",IF(S28=\"Unlimited\",\"N/A\",S28-TODAY()))","v":-42280},null,null,null,null,null,null,{"$f":"IF(Y28=\"N/A\",\"N/A\",(Z28-TODAY()))","v":-42280},null,null,null,{"$f":"IF(AB28=\"N/A\",\"N/A\",(AD28-TODAY()))","v":-42280},null,null,null,null,null,null,{"$f":"IF(AM28=\"N/A\",\"N/A\",(AK28-TODAY()))","v":-42280},null,null,null,null,{"$f":"IF(AO28=\"N/A\",\"N/A\",(AP28-TODAY()))","v":-42280}]

{"sheet":"Menu","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Modèle Crew","index":4,"n_rows":26,"n_cols":24,"rows_kept":26,"cut":false,"hidden":true,"merged":[[4,0,4,3],[2,0,2,3],[0,0,0,32],[2,13,6,32],[3,0,3,12],[5,0,5,12],[1,23,1,26],[1,27,1,32],[4,4,4,12],[2,4,2,12],[6,4,6,12],[6,0,6,3],[12,0,12,1],[7,0,7,32],[8,0,8,32],[9,0,9,32],[11,0,11,1],[11,2,11,32]]}
["Crew Attendance Record"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Site Manager:"]
["Mission Name:"]
[]
["Name of Contractor:",null,null,null,"SWIFTAIR"]
[]
["Crew Attendance Record ( Month/Year):"]
[]
["                                   State the minimum autorized crew specified in the Air Charter Agreement including Site Manager"]
["2 Captains / 2 First Officers / 2 Cabin Chief / 2 Cabin Crew / 1 Engineer / 1 Site Manager"]
[]
[null,null,"Date"]
["Name"]
["SITE MANAGERS"]
[]
["SITE MANAGER ASSISTANTS"]
[]
["CAPTAINS"]
[]
["FIRST OFFICERS"]
[]
["CABIN CHIEFS"]
[]
["FLIGHT ATTENDANTS"]
[]
["ENGINEERS"]

{"sheet":"Modèle DSA","index":5,"n_rows":37,"n_cols":20,"rows_kept":37,"cut":false,"hidden":true,"merged":[[12,0,12,1],[6,4,6,12],[7,0,7,32],[8,0,8,32],[9,0,9,32],[11,0,11,1],[11,2,11,32],[0,0,0,32],[1,0,1,32],[2,0,2,3],[2,4,2,12],[2,13,6,32],[3,0,3,12],[4,0,4,3],[4,4,4,12],[5,0,5,12],[6,0,6,3]]}
[]
[]
["Mission Name:"]
[]
["Name of Contractor:",null,null,null,"SWIFTAIR"]
[]
["Crew Attendance Record ( Month/Year):"]
[]
["                                   State the minimum autorized crew specified in the Air Charter Egreement including Site Manager"]
["3 Captains / 3 First OfficerS / 3 Cabin Chief / 3 Cabin Crew"]
[]
[null,null,"Date"]
["Name"]
["SITE MANAGERS"]
[]
["SITE MANAGER ASSISTANTS"]
[]
["CAPTAINS"]
[]
["FIRST OFFICERS"]
["FERNANDEZ ESPANA","Rodolfo"]
[]
["CABIN CHIEFS"]
[]
["FLIGHT ATTENDANTS"]
[]
["ENGINEERS"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"SWT responsability",null,null,null,null,null,null,null,null,null,"A","Out of Base"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"J","JGH"]
[null,null,null,null,null,null,null,null,"RON UN Responsibility",null,null,null,null,null,null,null,null,null,"V","VH"]

{"sheet":"Sitrep","index":6,"n_rows":27,"n_cols":23,"rows_kept":27,"cut":false,"hidden":false,"merged":[[2,2,2,3],[20,0,21,3],[24,0,24,3],[14,0,14,2],[0,0,0,22],[2,18,2,19],[2,20,2,21],[19,0,19,2],[4,11,4,12],[4,0,4,2],[4,5,4,6],[4,7,4,8],[1,10,1,11],[2,0,2,1],[2,5,2,6],[2,7,2,8],[2,12,2,13]]}
["CONTRACTOR EMPLOYEES & RELEVANT CERTIFICATE INFORMATION"]
[]
["NAME OF CARRIER: ",null,"AIRAVENIR",null,null,"MAIN BASE / CURRENT LOCATION:",null,"PARADISO",null,null,null,"UNO CALL SIGN : ","AV555",null,null,null,null,null,"CHARTER AGREEMENT NUMBER: ",null,12345]
[]
["CURRENT CREW     ",null,null,null,null,"Telephone number:",null,"xxx23xxx45xxx",null,null,"email:","xxxxxx@yyyyy.com ",null,null,null,"Date:",{"$f":"TODAY()","v":"2015-10-03"}]
["Title","First Name","Surname","Citizenship","Date of Birth","Passport \nNumber","Expiration \nof Passport","License Number","Expiration of\nLicense","Medical \nCertificate \nNumber","Expiration \nof Medical \nCertificate","Dangerous Goods \nCertificate Number","Expiration of \nDG Certificate","Total FH / \nFH on this A/C\nType & with this Title","FH on this A/C Type & with this Title ","Previous UN \nExperience (Y/N)","Arrival Date","Date on Duty","Estimated \nRotation Date","UNAMID \nID Card","Expiration of \nID Card","Briefing \ncompletion date","Sudan \nValidation Expiration"]
["Site Manager","Pat","PAPA","Congolese","1984-09-18","OB073","2019-12-25","N/A","N/A","N/A","N/A",221029,"2015-11-30","N/A/N/A","N/A/N/A","Y","2015-04-22","2015-09-07","2015-10-10","1911-10-04","2016-01-01","2015-09-07"]
["Captain","Carlos","YYYYY","Spanish","1978-01-22",362648,"2021-04-01",8643,"Unlimited",5471,"2015-07-20",777,"2017-01-31","4355:14'/4155:14'","4355:14'/4155:14'","Y","2015-09-24","2014-03-06","2015-12-31","1901-08-14","2015-03-09","2014-03-06","2015-01-25"]
["Captain","Daniel","ZZZZZ","Deutch","1971-04-28",35349,"2016-12-28",1090,"Unlimited",23818,"2015-02-06",1460,"2015-09-18","6369:41'/3870:23'","6369:41'/3870:23'","Y","2014-08-14","2014-08-25","2016-10-19","1900-09-24","2014-10-12","2014-08-25","2015-09-10"]
["First Officer","Ismael","AAAA","Spanish","1974-11-23",79923,"2018-02-12",1991,"2016-05-31",15995,"2016-02-02",656,"2017-04-30","2249:26/1142:1","2249:26/1142:1","Y","2015-08-07","2015-08-17","2015-11-18","1900-10-09","2016-02-06","2015-08-17"]
["First Officer","Jordi","BBBBB","Spanish","1982-09-16","111N","2023-05-06",2308,"Unlimited",302,"2015-04-11",1676,"2017-02-17","1889:45'/675:30'","1889:45'/675:30'","N","2015-03-25","2015-03-26","2015-10-14","1900-12-09","2015-05-17","2015-03-26"]
["Cabin Chief","Ruben","ROMEO","Spanish","1980-08-05",89,"2023-09-05",3,"2017-04-08",1,"2016-03-21",970,"2015-03-31","N/A/N/A","N/A/N/A","Y","2015-09-22","2015-09-22","2015-11-20","1911-06-04","2015-10-20","2015-09-22"]
[]
[]
["NEXT ROTATION    "]
["Title","First Name","Surname","Citizenship","Date of Birth","Passport \nNumber","Expiration \nof Passport","License Number","Expiration of\nLicense","Medical \nCertificate \nNumber","Expiration \nof Medical \nCertificate","Dangerous Goods \nCertificate Number","Expiration of \nDG Certificate","Total FH / \nFH on this A/C\nType & with this Title","FH on this A/C Type & with this Title ","Previous UN \nExperience (Y/N)","Arrival Date","Date on Duty","Estimated \nRotation Date","UNAMID \nID Card","Expiration of \nID Card","Briefing \ncompletion date","Sudan Validation Expiration"]
["Captain","Antonio","XXXXX","Spanish","1982-02-24",17189,"2016-11-14",6855,"2015-05-31",8654,"2015-09-19","1900-03-22","2016-09-13","5947:38'/1575:05","5947:38'/1575:05","Y","2015-10-14","2014-07-22","2015-11-18","1901-11-29","2015-06-03","2014-07-22"]
[]
[]
["STAFF PER CONTRACT"]
["Number and type of Personel who would provide Operational and Groud Support of the Aircraft:",null,null,null,"By contract","Actual"]
[null,null,null,null,{"$f":"SUM(E23:E27)","v":7},{"$f":"SUM(F23:F27)","v":0}]
["a) Captain",null,null,null,1]
["b) Co-Pilot",null,null,null,1]
["c) Flight Attendants",null,null,null,2]
["d) Engineers",null,null,null,2]
["e) Site Manager",null,null,null,1]

{"sheet":"Modèle Crew1","index":7,"n_rows":30,"n_cols":36,"rows_kept":30,"cut":false,"hidden":true,"merged":[[1,0,1,35],[3,0,3,35],[4,0,4,35],[5,0,5,35],[9,1,9,4],[9,6,9,12],[11,1,11,34],[12,1,12,34],[7,1,7,4],[7,6,7,12],[8,1,8,4],[8,6,8,12]]}
[]
["U N I T E D  N A T I O N S                       N A T I O N S   U N I E S"]
[]
["United Nations Mission in South Sudan"]
["    UNMISS"]
["AIRCREW ATTENDANCE SHEET"]
[]
[null,"Name of Contractor:",null,null,null,null,"SWIFTAIR"]
[null,"Call Sign:",null,null,null,null,"UNO514P"]
[null,"Crew Attendance Record (Month/Year):"]
[]
[null,"State the minimum authorized crew specified in the Air Charter Agreement including site manager:"]
[null,"2 Captains / 2 First Officers / 2 Cabin Chief / 2 Cabin Crew / 1 Engineer / 1 Site Manager"]
[]
["No.","NAME","FIRST NAME","ID NO.","TITLE",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31]
[null,null,null,null,null,null," "]
[null,"Site Manager:"]
[null,null,null,"Name "]
[]
[null,"CODE:"]
[null,"P   - Present"]
[null,"F   - Flying"]
[null,"S   - Standby"]
[null,"R   - Crew Rest"]
[null,"A   - Absent"]
[null,"SL  - Sick Leave"]
[null,"OL - Official Leave"]
[]
[null,null,null,null,"Prepared by:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date:"]
[null,null,null,null,null,null,null,null,"Name/Title/Signature"]

{"sheet":"Impressions","index":8,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,null,null,null,"Nom du fichier a utiliser"]
[null,null,null,null,"Crew Details Form.doc"]
[null,null,null,null,"MOP Waiver.docx"]
[null,null,null,null,"MOP Request letter.doc"]
[null,null,null,null,"RESIDENT VISA Request letter.doc"]
[null,null,null,null,"ENTRY VISA Request letter.doc"]
[null,null,null,null,"UN ID RENEWAL REQUEST.doc"]
[null,null,null,null,"UN ID REQUEST.doc"]