{"text_format":"1","workbook":"xlsx","n_sheets":17,"sheets":["Subject Organisation","Use of aerodiagnostic","Safety management","Risk Management","Learning from experience","Organisation of activities I","Organisation of activities 2","Training","Aircraft availability 1","Aircraft availability 2","Environment and safety 1","Environment and safety 2","Action Plan","Affiliations","Overall","Formulas","Sheet1"],"not_rendered":{"charts":26,"images":2,"macros":1,"external_links":0,"defined_names":12,"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":"Subject Organisation","index":0,"n_rows":32,"n_cols":9,"rows_kept":32,"cut":false,"hidden":false,"merged":[[4,4,4,5]]}
[]
[]
[]
[]
[null,null,null,null,"AERODIAGNOSTIC"]
[]
[]
[]
[null,"Region :"]
[]
[null,"Regional safety officer :"]
[]
[]
[null,"Club/organisation :",null,null,null,null,null,null,"Date"]
[]
[null,"ATO N° :"]
[]
[null,"Address :",null,null,null,null,null,"Description "]
[null,"Telephone :",null,null,null,null,null,"Total members:"]
[null,"Fax :",null,null,null,null,null,"Pilots :"]
[null,"E mail :"]
[]
[null,"Activity :"]
[null,"Annual flying hours"]
[null,"Number of aircraft :"]
[]
[null,"Safety Working Group (led by Accountable Manager)"]
[null,"Accountable Manager:"]
[null,"Permanent members :"]
[]
[]
[null,"Invited experts "]

{"sheet":"Use of aerodiagnostic","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Safety management","index":2,"n_rows":24,"n_cols":10,"rows_kept":24,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"I- SAFETY MANAGEMENT "]
[]
[null,"QUESTION","Assessment","Observation","Weight",null,"Value"]
[null,"Management Structure"]
[null,"The Accountable Manager is responsible for safety management","Absent",null,5,{"$f":"IF(C6=\"Not applicable\",0,E6)","v":5},{"$f":"VLOOKUP(C6,Notes,2,0)*F6","v":0},null,null,{"$f":"IF(C6=\"Not applicable\",\"\",VLOOKUP(C6,Notes,2,0))","v":0}]
[null,"All pilots have been made aware of the Accountable Manager and his/her function","Absent",null,4,{"$f":"IF(C7=\"Not applicable\",0,E7)","v":4},{"$f":"VLOOKUP(C7,Notes,2,0)*E7","v":0},null,null,{"$f":"IF(C7=\"Not applicable\",\"\",VLOOKUP(C7,Notes,2,0))","v":0}]
[null,"The Head of Training is involved with safety management","Absent",null,3,3,{"$f":"VLOOKUP(C8,Notes,2,0)*E8","v":0},null,null,{"$f":"IF(C8=\"Not applicable\",\"\",VLOOKUP(C8,Notes,2,0))","v":0}]
[null,"His involvement in the safety management system is likewise known","Absent",null,5,5,0,null,null,{"$f":"IF(C9=\"Not applicable\",\"\",VLOOKUP(C9,Notes,2,0))","v":0}]
[null,"The Safety Manager is part of the Management Team","Absent",null,3,3,0,null,null,{"$f":"IF(C10=\"Not applicable\",\"\",VLOOKUP(C10,Notes,2,0))","v":0}]
[null,"His involvement in the safety management system is likewise known","Absent",null,5,5,0,null,null,{"$f":"IF(C11=\"Not applicable\",\"\",VLOOKUP(C11,Notes,2,0))","v":0}]
[null,"All pilots are aware of the management structure","Absent",null,6,6,0,null,null,{"$f":"IF(C12=\"Not applicable\",\"\",VLOOKUP(C12,Notes,2,0))","v":0}]
[null,"Result",{"$f":"+AVERAGE(J6:J12)/3","v":0},null,null,null,{"$f":"(SUM(G6:G12)/SUM(F6:F12))/3*20","v":0}]
[]
[null,"QUESTION","Assessment","Observation","Weight",null,"Value"]
[null,"Management responsibilities"]
[null,"There is an Accountable Manager’s statement","Absent",null,4,{"$f":"IF(C17=\"Not applicable\",0,E17)","v":4},{"$f":"VLOOKUP(C17,Notes,2,0)*F17","v":0},null,null,{"$f":"IF(C17=\"Not applicable\",\"\",VLOOKUP(C17,Notes,2,0))","v":0}]
[null,"The statement has been brought to the attention of all pilots","Absent",null,3,{"$f":"IF(C18=\"Not applicable\",0,E18)","v":3},{"$f":"VLOOKUP(C18,Notes,2,0)*F18","v":0},null,null,{"$f":"IF(C18=\"Not applicable\",\"\",VLOOKUP(C18,Notes,2,0))","v":0}]
[null,"The function of the Head of Training is written down","Absent",null,3,3,{"$f":"VLOOKUP(C19,Notes,2,0)*F19","v":0},null,null,{"$f":"IF(C19=\"Not applicable\",\"\",VLOOKUP(C19,Notes,2,0))","v":0}]
[null,"The function of the Safety Manager is written down and available to all pilots","Absent",null,3,3,{"$f":"VLOOKUP(C20,Notes,2,0)*F20","v":0},null,null,{"$f":"IF(C20=\"Not applicable\",\"\",VLOOKUP(C20,Notes,2,0))","v":0}]
[null,"The organisation has its own safety committee","Absent",null,4,4,{"$f":"VLOOKUP(C21,Notes,2,0)*F21","v":0},null,null,{"$f":"IF(C21=\"Not applicable\",\"\",VLOOKUP(C21,Notes,2,0))","v":0}]
[null,"Result",{"$f":"+AVERAGE(J17:J21)/3","v":0},null,null,null,{"$f":"+(SUM(G17:G21)/SUM(F17:F21))/3*20","v":0}]
[]
[null,"Average assessment on Safety Management: Value/20",{"$f":"+AVERAGE(G22,G13)","v":0}]

{"sheet":"Risk Management","index":3,"n_rows":34,"n_cols":10,"rows_kept":34,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Risk Management"]
[]
[null,"QUESTION","Assessment","Observation","Weight",null,"Value"]
[null,"Risk analysis"]
[null,"The club uses the aerodiagnostic risk survey","Absent",null,3,{"$f":"IF(C6=\"Not applicable\",0,E6)","v":3},{"$f":"VLOOKUP(C6,Notes,2,0)*F6","v":0},null,null,{"$f":"IF(C6=\"Not applicable\",\"\",VLOOKUP(C6,Notes,2,0))","v":0}]
[null,"The club has completed the survey or adapted it to be relevant to itself","Absent",null,3,{"$f":"IF(C7=\"Not applicable\",0,E7)","v":3},{"$f":"VLOOKUP(C7,Notes,2,0)*E7","v":0},null,null,{"$f":"IF(C7=\"Not applicable\",\"\",VLOOKUP(C7,Notes,2,0))","v":0}]
[null,"The results of the survey initiate actions for improvement","Absent",null,4,4,{"$f":"VLOOKUP(C8,Notes,2,0)*E8","v":0},null,null,{"$f":"IF(C8=\"Not applicable\",\"\",VLOOKUP(C8,Notes,2,0))","v":0}]
[null,"The survey is completed initially then at least annually","Absent",null,4,4,{"$f":"VLOOKUP(C9,Notes,2,0)*E9","v":0},null,null,{"$f":"IF(C9=\"Not applicable\",\"\",VLOOKUP(C9,Notes,2,0))","v":0}]
[null,"Result",{"$f":"+AVERAGE(J6:J9)/3","v":0},null,null,null,{"$f":"SUM(G6:G9)/SUM(F6:F9)/3*20","v":0}]
[]
[null,"Application on the aerodrome"]
[null,"Correct collective protection measures are present (barriers, pilot gates)","Absent",null,5,{"$f":"IF(C13=\"Not applicable\",0,E13)","v":5},{"$f":"VLOOKUP(C13,Notes,2,0)*F13","v":0},null,null,{"$f":"IF(C13=\"Not applicable\",\"\",VLOOKUP(C13,Notes,2,0))","v":0}]
[null,"They are correctly used","Absent",null,4,{"$f":"IF(C14=\"Not applicable\",0,E14)","v":4},0,null,null,{"$f":"IF(C14=\"Not applicable\",\"\",VLOOKUP(C14,Notes,2,0))","v":0}]
[null,"Individual protective measures are present (e.g. high visibility jackets, ear defenders)","Absent",null,4,4,0,null,null,{"$f":"IF(C15=\"Not applicable\",\"\",VLOOKUP(C15,Notes,2,0))","v":0}]
[null,"They are correctly used","Absent",null,3,3,0,null,null,{"$f":"IF(C16=\"Not applicable\",\"\",VLOOKUP(C16,Notes,2,0))","v":0}]
[null,"Measures are in place to restrict the use of the aircraft to authorised pilots only","Absent",null,4,4,0,null,null,{"$f":"IF(C17=\"Not applicable\",\"\",VLOOKUP(C17,Notes,2,0))","v":0}]
[null,"Members respect the rules","Absent",null,4,4,0,null,null,{"$f":"IF(C18=\"Not applicable\",\"\",VLOOKUP(C18,Notes,2,0))","v":0}]
[null,"They respect the safety policy","Absent",null,4,4,0,null,null,{"$f":"IF(C19=\"Not applicable\",\"\",VLOOKUP(C19,Notes,2,0))","v":0}]
[null,"Result",{"$f":"+AVERAGE(J13:J19)/3","v":0},null,null,null,{"$f":"+SUM(G13:G19)/SUM(F13:F19)/3*20","v":0}]
[]
[null,"Pilots’ risk perception"]
[null,"Pilots carry out proper pre-flight planning","Absent",null,5,{"$f":"IF(C23=\"Not applicable\",0,E23)","v":5},{"$f":"VLOOKUP(C23,Notes,2,0)*F23","v":0},null,null,{"$f":"IF(C23=\"Not applicable\",\"\",VLOOKUP(C23,Notes,2,0))","v":0}]
[null,"They have appropriate qualifications and abilities","Absent",null,6,{"$f":"IF(C24=\"Not applicable\",0,E24)","v":6},{"$f":"VLOOKUP(C24,Notes,2,0)*F24","v":0},null,null,{"$f":"IF(C24=\"Not applicable\",\"\",VLOOKUP(C24,Notes,2,0))","v":0}]
[null,"Pilots respect the flight envelope","Absent",null,5,5,0,null,null,{"$f":"IF(C25=\"Not applicable\",\"\",VLOOKUP(C25,Notes,2,0))","v":0}]
[null,"They consult the appropriate pre-flight information","Absent",null,5,5,0,null,null,{"$f":"IF(C26=\"Not applicable\",\"\",VLOOKUP(C26,Notes,2,0))","v":0}]
[null,"Pilots consider problems and errors of which they are aware","Absent",null,4,4,0,null,null,{"$f":"IF(C27=\"Not applicable\",\"\",VLOOKUP(C27,Notes,2,0))","v":0}]
[null,"They participate in safety improvements","Absent",null,4,4,0,null,null,{"$f":"IF(C28=\"Not applicable\",\"\",VLOOKUP(C28,Notes,2,0))","v":0}]
[null,"They respect the rules and regulations of the aviation authorities","Absent",null,4,4,0,null,null,{"$f":"IF(C29=\"Sans objet\",\"\",VLOOKUP(C29,Notes,2,0))","v":0}]
[null,"They respect the provisions contained in the safety management system","Absent",null,4,4,0,null,null,0]
[null,"Result",{"$f":"+AVERAGE(J23:J30)/3","v":0},null,null,null,{"$f":"+SUM(G23:G30)/SUM(F23:F30)/3*20","v":0}]
[]
[]
[null,"Assessment of risk mnagement:  x/20",{"$f":"+AVERAGE(G10,G20,G31)","v":0}]

{"sheet":"Learning from experience","index":4,"n_rows":25,"n_cols":10,"rows_kept":25,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"II- Learning from Experience"]
[]
[null,"QUESTION","Assessment","Observation","Weight",null,"Value"]
[null,"Management of accidents and incidents"]
[null,"Accidents and incidents relevant to the club are reported","Absent",null,4,{"$f":"IF(C6=\"Not applicable\",0,E6)","v":4},{"$f":"VLOOKUP(C6,Notes,2,0)*F6","v":0},null,null,{"$f":"IF(C6=\"Not applicable\",\"\",VLOOKUP(C6,Notes,2,0))","v":0}]
[null,"Reports are investigated to ascertain the causes","Absent",null,4,{"$f":"IF(C7=\"Not applicable\",0,E7)","v":4},{"$f":"VLOOKUP(C7,Notes,2,0)*E7","v":0},null,null,{"$f":"IF(C7=\"Not applicable\",\"\",VLOOKUP(C7,Notes,2,0))","v":0}]
[null,"Findings are used in accident prevention","Absent",null,3,3,0,null,null,{"$f":"IF(C8=\"Not applicable\",\"\",VLOOKUP(C8,Notes,2,0))","v":0}]
[null,"Findings are promulgated to the pilots","Absent",null,3,3,0,null,null,{"$f":"IF(C9=\"Not applicable\",\"\",VLOOKUP(C9,Notes,2,0))","v":0}]
[null,"Required details of flights are collected","Absent",null,3,3,0,null,null,{"$f":"IF(C10=\"Not applicable\",\"\",VLOOKUP(C10,Notes,2,0))","v":0}]
[null,"Incidents are correctly accessed (including those reported in the tech log)","Absent",null,5,5,0,null,null,{"$f":"IF(C11=\"Not applicable\",\"\",VLOOKUP(C11,Notes,2,0))","v":0}]
[null,"A working group is formed to resolve identified issues","Absent",null,3,3,0,null,null,{"$f":"IF(C12=\"Not applicable\",\"\",VLOOKUP(C12,Notes,2,0))","v":0}]
[null,"Result",{"$f":"+AVERAGE(J6:J12)/3","v":0},null,null,null,{"$f":"SUM(G6:G12)/SUM(F6:F12)/3*20","v":0}]
[]
[null,"QUESTION","Assessment","Observation","Weight",null,"Value"]
[null,"Analysis of findings"]
[null,"The collection of a maximum number of errors/observed mistakes is organised","Absent",null,4,{"$f":"IF(C17=\"Not applicable\",0,E17)","v":4},{"$f":"VLOOKUP(C17,Notes,2,0)*F17","v":0},null,null,{"$f":"IF(C17=\"Not applicable\",\"\",VLOOKUP(C17,Notes,2,0))","v":0}]
[null,"Pilots are informed of the advantage of this approach","Absent",null,3,{"$f":"IF(C18=\"Not applicable\",0,E18)","v":3},0,null,null,{"$f":"IF(C18=\"Not applicable\",\"\",VLOOKUP(C18,Notes,2,0))","v":0}]
[null,"A reporting system is established","Absent",null,4,4,0,null,null,{"$f":"IF(C19=\"Not applicable\",\"\",VLOOKUP(C19,Notes,2,0))","v":0}]
[null,"Pilots are aware that anonymous reporting is possible","Absent",null,3,3,0,null,null,{"$f":"IF(C20=\"Not applicable\",\"\",VLOOKUP(C20,Notes,2,0))","v":0}]
[null,"The internal no-blame culture is respected","Absent",null,4,4,0,null,null,{"$f":"IF(C21=\"Not applicable\",\"\",VLOOKUP(C21,Notes,2,0))","v":0}]
[null,"A higher level safety officer can be involved if required","Absent",null,4,4,0,null,null,{"$f":"IF(C22=\"Not applicable\",\"\",VLOOKUP(C22,Notes,2,0))","v":0}]
[null,"Result",{"$f":"+AVERAGE(J17:J22)/3","v":0},null,null,null,{"$f":"+SUM(G17:G22)/SUM(F17:F22)/3*20","v":0}]
[]
[null,"Average assessment of learning from experience:  x/20",{"$f":"+AVERAGE(G13,G23)","v":0}]

{"sheet":"Organisation of activities I","index":5,"n_rows":33,"n_cols":10,"rows_kept":33,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"IV- Organisation of activities I"]
[]
[null,"QUESTION","Assessment","Observation","Weight",null,"Value"]
[null," A T O Structure"]
[null,"The organisation has approval as an ATO","Absent",null,5,{"$f":"IF(C6=\"Sans objet\",0,E6)","v":5},{"$f":"VLOOKUP(C6,Notes,2,0)*F6","v":0},null,null,{"$f":"IF(C6=\"Sans objet\",\"\",VLOOKUP(C6,Notes,2,0))","v":0}]
[null,"The approved (or deposited) Operations Manual is followed","Absent",null,4,4,{"$f":"VLOOKUP(C7,Notes,2,0)*E7","v":0},null,null,0]
[null,"The approved (or deposited) Management Manual is followed","Absent",null,3,3,0,null,null,0]
[null,"The approved (or deposited) Safety Manual is followed","Absent",null,4,4,0,null,null,0]
[null,"Updating these manuals is organised and carried out","Absent",null,3,3,0,null,null,0]
[null,"The manuals are available to the pilots","Absent",null,4,4,0,null,null,0]
[null,"The pilots are informed about the updates","Absent",null,4,4,0,null,null,0]
[null,"Manuals are stored suitably and logically","Absent",null,4,4,0,null,null,0]
[null,"Result",{"$f":"+AVERAGE(J6:J13)/3","v":0},null,null,null,{"$f":"SUM(G6:G13)/SUM(F6:F13)/3*20","v":0}]
[]
[null,"Basic Training "]
[null,"A Head of Training is nominated","Absent",null,5,{"$f":"IF(C17=\"Not applicable\",0,E17)","v":5},{"$f":"VLOOKUP(C17,Notes,2,0)*F17","v":0},null,null,{"$f":"IF(C17=\"Not applicable\",\"\",VLOOKUP(C17,Notes,2,0))","v":0}]
[null,"The complete theoretical training programme is organised","Absent",null,6,{"$f":"IF(C18=\"Not applicable\",0,E18)","v":6},{"$f":"VLOOKUP(C18,Notes,2,0)*F18","v":0},null,null,{"$f":"IF(C18=\"Not applicable\",\"\",VLOOKUP(C18,Notes,2,0))","v":0}]
[null,"The organisation employs competent theoretical trainers","Absent",null,5,5,0,null,null,{"$f":"IF(C19=\"Not applicable\",\"\",VLOOKUP(C19,Notes,2,0))","v":0}]
[null,"The organisation possesses facilities suitable for this training","Absent",null,4,4,0,null,null,{"$f":"IF(C20=\"Not applicable\",\"\",VLOOKUP(C20,Notes,2,0))","v":0}]
[null,"The complete practical training programme is organised","Absent",null,5,5,0,null,null,{"$f":"IF(C21=\"Not applicable\",\"\",VLOOKUP(C21,Notes,2,0))","v":0}]
[null,"The organisation employs competent instructors for this training","Absent",null,5,5,0,null,null,{"$f":"IF(C22=\"Not applicable\",\"\",VLOOKUP(C22,Notes,2,0))","v":0}]
[null,"The training records cover both practical and theoretical training","Absent",null,4,4,0,null,null,{"$f":"IF(C23=\"Not applicable\",\"\",VLOOKUP(C23,Notes,2,0))","v":0}]
[null,"The results of examinations are followed up","Absent",null,3,3,0,null,null,{"$f":"IF(C24=\"Not applicable\",\"\",VLOOKUP(C24,Notes,2,0))","v":0}]
[null,"Result",{"$f":"+AVERAGE(J17:J24)/3","v":0},null,null,null,{"$f":"+SUM(G17:G24)/SUM(F17:F24)/3*20","v":0}]
[]
[null,"Use of aircraft by licensed pilots",null,null,null,{"$f":"IF(C27=\"Not applicable\",0,E27)","v":0}]
[null,"Continuation training is organised to maintain competence","Absent",null,4,4,{"$f":"VLOOKUP(C28,Notes,2,0)*F28","v":0},null,null,{"$f":"IF(C28=\"Not applicable\",\"\",VLOOKUP(C28,Notes,2,0))","v":0}]
[null,"Aircraft booking is organised by a suitable system","Absent",null,4,4,{"$f":"VLOOKUP(C29,Notes,2,0)*F29","v":0},null,null,{"$f":"IF(C29=\"Not applicable\",\"\",VLOOKUP(C29,Notes,2,0))","v":0}]
[null,"Pilots respect the booking system","Absent",null,4,4,{"$f":"VLOOKUP(C30,Notes,2,0)*F30","v":0},null,null,{"$f":"IF(C30=\"Not applicable\",\"\",VLOOKUP(C30,Notes,2,0))","v":0}]
[null,"Pilots are informed about unserviceabilities","Absent",null,4,4,{"$f":"VLOOKUP(C31,Notes,2,0)*F31","v":0},null,null,{"$f":"IF(C31=\"Not applicable\",\"\",VLOOKUP(C31,Notes,2,0))","v":0}]
[null,"There is easy access to pre-flight planning information (met, NOTAM)","Absent",null,3,{"$f":"IF(C32=\"Not applicable\",0,E32)","v":3},{"$f":"VLOOKUP(C32,Notes,2,0)*F32","v":0},null,null,{"$f":"IF(C32=\"Not applicable\",\"\",VLOOKUP(C32,Notes,2,0))","v":0}]
[null,"Result",{"$f":"+AVERAGE(J28:J32)/3","v":0},null,null,null,{"$f":"+SUM(G28:G32)/SUM(F28:F32)/3*20","v":0}]

{"sheet":"Organisation of activities 2","index":6,"n_rows":30,"n_cols":17,"rows_kept":30,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"IV- Organisation of activities 2"]
[]
[null,"QUESTION","Assessment","Observation","Weight",null,"Value"]
[null,"Pilot improvement training "]
[null,"There is specific familiarisation training for converting to a new aircraft","Absent",null,4,{"$f":"IF(C6=\"Not applicable\",0,E6)","v":4},{"$f":"VLOOKUP(C6,Notes,2,0)*F6","v":0},null,null,{"$f":"IF(C6=\"Not applicable\",\"\",VLOOKUP(C6,Notes,2,0))","v":0}]
[null,"There is specific familiarisation training for converting to a new instrument fit","Absent",null,4,{"$f":"IF(C7=\"Not applicable\",0,E7)","v":4},{"$f":"VLOOKUP(C7,Notes,2,0)*F7","v":0},null,null,{"$f":"IF(C7=\"Not applicable\",\"\",VLOOKUP(C7,Notes,2,0))","v":0}]
[null,"Information about new regulations is promulgated to pilots","Absent",null,4,4,0,null,null,{"$f":"IF(C8=\"Not applicable\",\"\",VLOOKUP(C8,Notes,2,0))","v":0}]
[null,"Currency/continuation training flights are encouraged","Absent",null,5,5,0,null,null,{"$f":"IF(C9=\"Not applicable\",\"\",VLOOKUP(C9,Notes,2,0))","v":0}]
[null,"Aerobatic training is encouraged","Absent",null,3,3,0,null,null,{"$f":"IF(C10=\"Not applicable\",\"\",VLOOKUP(C10,Notes,2,0))","v":0}]
[null,"Rallys and flyouts are encouraged","Absent",null,4,4,0,null,null,{"$f":"IF(C11=\"Not applicable\",\"\",VLOOKUP(C11,Notes,2,0))","v":0}]
[null,"Precision flying and competitions are encouraged","Absent",null,4,4,0,null,null,{"$f":"IF(C12=\"Not applicable\",\"\",VLOOKUP(C12,Notes,2,0))","v":0}]
[null,"Result",{"$f":"+AVERAGE(J6:J12)/3","v":0},null,null,null,{"$f":"SUM(G6:G12)/SUM(F6:F12)/3*20","v":0},null,null,null,null,null,null,null,null,{"$f":"'Organisation of activities I'!B16","v":"Basic Training "},{"$f":"'Organisation of activities I'!G25","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Organisation of activities I'!B27","v":"Use of aircraft by licensed pilots"},{"$f":"'Organisation of activities I'!G33","v":0}]
[null,"QUESTION","Assessment","Observation","Weight",null,"Value"]
[null,"Introductory flights and open days"]
[null,"There is a specific organisation for these","Absent",null,5,{"$f":"IF(C17=\"Not applicable\",0,E17)","v":5},{"$f":"VLOOKUP(C17,Notes,2,0)*F17","v":0},null,null,{"$f":"IF(C17=\"Not applicable\",\"\",VLOOKUP(C17,Notes,2,0))","v":0}]
[null,"An individual is nominated to be responsible for them","Absent",null,4,{"$f":"IF(C18=\"Not applicable\",0,E18)","v":4},0,null,null,{"$f":"IF(C18=\"Not applicable\",\"\",VLOOKUP(C18,Notes,2,0))","v":0}]
[null,"A list of pilots authorised to carry out these flights is published and up-to-date","Absent",null,3,3,0,null,null,{"$f":"IF(C19=\"Not applicable\",\"\",VLOOKUP(C19,Notes,2,0))","v":0}]
[null,"Passengers and visitors are looked after by trained members","Absent",null,5,5,0,null,null,{"$f":"IF(C20=\"Not applicable\",\"\",VLOOKUP(C20,Notes,2,0))","v":0}]
[null,"Pilots respect the rules in this matter","Absent",null,4,4,0,null,null,{"$f":"IF(C21=\"Not applicable\",\"\",VLOOKUP(C21,Notes,2,0))","v":0}]
[null,"There is a regular check carried out to identify any deviations from the system","Absent",null,3,3,0,null,null,{"$f":"IF(C22=\"Not applicable\",\"\",VLOOKUP(C22,Notes,2,0))","v":0}]
[null,"Result",{"$f":"+AVERAGE(J17:J22)/3","v":0},null,null,null,{"$f":"+SUM(G17:G22)/SUM(F17:F22)/3*20","v":0}]
[]
[null,"Average assessment of organisation of activities   x/20",{"$f":"+AVERAGE('Organisation of activities I'!$G$14,'Organisation of activities I'!$G$25,'Organisation of activities I'!$G$33,'Organisation of activities 2'!G13,'Organisation of activities 2'!G23)","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"+'Organisation of activities I'!B5","v":" A T O Structure"},{"$f":"+'Organisation of activities I'!G14","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"+'Organisation of activities I'!B16","v":"Basic Training "},{"$f":"+'Organisation of activities I'!G25","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"+'Organisation of activities I'!B27","v":"Use of aircraft by licensed pilots"},{"$f":"+'Organisation of activities I'!G33","v":0}]

{"sheet":"Training","index":7,"n_rows":33,"n_cols":10,"rows_kept":33,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"V- Training"]
[]
[null,"QUESTION","Assessment","Observation","Weight",null,"Value"]
[null,"Basic Training"]
[null,"The  theoretical training syllabus is written and up-to-date","Absent",null,5,{"$f":"IF(C6=\"Not applicable\",0,E6)","v":5},{"$f":"VLOOKUP(C6,Notes,2,0)*F6","v":0},null,null,{"$f":"IF(C6=\"Not applicable\",\"\",VLOOKUP(C6,Notes,2,0))","v":0}]
[null,"The course is issued to the students","Absent",null,4,{"$f":"IF(C7=\"Not applicable\",0,E7)","v":4},{"$f":"VLOOKUP(C7,Notes,2,0)*F7","v":0},null,null,{"$f":"IF(C7=\"Not applicable\",\"\",VLOOKUP(C7,Notes,2,0))","v":0}]
[null,"It is followed by all instructors","Absent",null,4,4,0,null,null,{"$f":"IF(C8=\"Not applicable\",\"\",VLOOKUP(C8,Notes,2,0))","v":0}]
[null,"The training manual is available and up-to-date","Absent",null,5,5,0,null,null,{"$f":"IF(C9=\"Not applicable\",\"\",VLOOKUP(C9,Notes,2,0))","v":0}]
[null,"The course is issued to the individual student and respected by the instructors","Absent",null,4,4,0,null,null,{"$f":"IF(C10=\"Not applicable\",\"\",VLOOKUP(C10,Notes,2,0))","v":0}]
[null,"Competencies are validated in writing","Absent",null,5,5,0,null,null,{"$f":"IF(C11=\"Not applicable\",\"\",VLOOKUP(C11,Notes,2,0))","v":0}]
[null,"Checks are carried out by the Head of Training","Absent",null,4,4,0,null,null,{"$f":"IF(C12=\"Not applicable\",\"\",VLOOKUP(C12,Notes,2,0))","v":0}]
[null,"A folder is updated daily for each student","Absent",null,4,4,0,null,null,{"$f":"IF(C13=\"Not applicable\",\"\",VLOOKUP(C13,Notes,2,0))","v":0}]
[null,"Result",{"$f":"+AVERAGE(J6:J13)/3","v":0},null,null,null,{"$f":"+SUM(G6:G13)/SUM(F6:F13)/3*20","v":0}]
[]
[null,"Revalidation and currency for licensed pilots"]
[null,"There is a system for providing continuation training for pilots who fly little","Absent",null,4,{"$f":"IF(C17=\"Not applicable\",0,E17)","v":4},{"$f":"VLOOKUP(C17,Notes,2,0)*F17","v":0},null,null,{"$f":"IF(C17=\"Not applicable\",\"\",VLOOKUP(C17,Notes,2,0))","v":0}]
[null,"There is a system to refresh pilots before revalidation or renewal ","Absent",null,3,{"$f":"IF(C18=\"Not applicable\",0,E18)","v":3},{"$f":"VLOOKUP(C18,Notes,2,0)*F18","v":0},null,null,{"$f":"IF(C18=\"Not applicable\",\"\",VLOOKUP(C18,Notes,2,0))","v":0}]
[null,"Ground training refresher sessions are organised ","Absent",null,3,3,{"$f":"VLOOKUP(C19,Notes,2,0)*F19","v":0},null,null,{"$f":"IF(C19=\"Not applicable\",\"\",VLOOKUP(C19,Notes,2,0))","v":0}]
[null,"A Flight Examiner is available to carry out revalidations","Absent",null,4,4,{"$f":"VLOOKUP(C20,Notes,2,0)*F20","v":0},null,null,{"$f":"IF(C20=\"Not applicable\",\"\",VLOOKUP(C20,Notes,2,0))","v":0}]
[null,"Result",{"$f":"+AVERAGE(J17:J20)/3","v":0},null,null,null,{"$f":"+SUM(G17:G20)/SUM(F17:F20)/3*20","v":0}]
[]
[null,"Improving skills"]
[null,"Advanced training is available for private pilots","Absent",null,1,{"$f":"IF(C24=\"Not applicable\",0,E24)","v":1},{"$f":"VLOOKUP(C24,Notes,2,0)*F24","v":0},null,null,{"$f":"IF(C24=\"Not applicable\",\"\",VLOOKUP(C24,Notes,2,0))","v":0}]
[null,"Upset recovery training is organised","Absent",null,2,{"$f":"IF(C25=\"Not applicable\",0,E25)","v":2},0,null,null,{"$f":"IF(C25=\"Not applicable\",\"\",VLOOKUP(C25,Notes,2,0))","v":0}]
[null,"Bad weather training is carried out in accordance with applicable regulations","Absent",null,3,3,0,null,null,{"$f":"IF(C26=\"Not applicable\",\"\",VLOOKUP(C26,Notes,2,0))","v":0}]
[null,"VFR Night flying training is carried out","Absent",null,4,4,0,null,null,{"$f":"IF(C27=\"Not applicable\",\"\",VLOOKUP(C27,Notes,2,0))","v":0}]
[null,"A written syllabus is used","Absent",null,4,4,0,null,null,{"$f":"IF(C28=\"Not applicable\",\"\",VLOOKUP(C28,Notes,2,0))","v":0}]
[null,"The aerodrome is suitable for night training","Absent",null,4,4,0,null,null,{"$f":"IF(C29=\"Not applicable\",\"\",VLOOKUP(C29,Notes,2,0))","v":0}]
[null,"Result",{"$f":"+AVERAGE(J24:J29)/3","v":0},null,null,null,{"$f":"+SUM(G24:G29)/SUM(F24:F29)/3*20","v":0}]
[]
[]
[null,"Assessment of training;  x/20",{"$f":"+AVERAGE(G14,G21,G30)","v":0}]

{"sheet":"Aircraft availability 1","index":8,"n_rows":30,"n_cols":10,"rows_kept":30,"cut":false,"hidden":false,"merged":[[2,1,2,6]]}
[]
[]
[null,"VI- Aircraft availability 1 "]
[]
[null,"QUESTION","Assessment","Observation","Weight",null,"Value"]
[null,"Aircraft for instruction "]
[null,"An adequate number of suitable aircraft is available","Absent",null,5,{"$f":"IF(C7=\"Not applicable\",0,E7)","v":5},{"$f":"VLOOKUP(C7,Notes,2,0)*F7","v":0},null,null,{"$f":"IF(C7=\"Not applicable\",\"\",VLOOKUP(C7,Notes,2,0))","v":0}]
[null,"Their equipment is suitable for the required instruction","Absent",null,4,{"$f":"IF(C8=\"Not applicable\",0,E8)","v":4},{"$f":"VLOOKUP(C8,Notes,2,0)*F8","v":0},null,null,{"$f":"IF(C8=\"Not applicable\",\"\",VLOOKUP(C8,Notes,2,0))","v":0}]
[null,"The fleet can provide all LAPL or PPL training","Absent",null,5,5,{"$f":"VLOOKUP(C9,Notes,2,0)*F9","v":0},null,null,{"$f":"IF(C9=\"Not applicable\",\"\",VLOOKUP(C9,Notes,2,0))","v":0}]
[null,"Aircraft are available to train for IFR, and for VFR at night","Absent",null,6,6,{"$f":"VLOOKUP(C10,Notes,2,0)*F10","v":0},null,null,{"$f":"IF(C10=\"Not applicable\",\"\",VLOOKUP(C10,Notes,2,0))","v":0}]
[null,"Result",{"$f":"+AVERAGE(J7:J10)/3","v":0},null,null,null,{"$f":"+SUM(G7:G10)/SUM(F7:F10)/3*20","v":0}]
[]
[null,"QUESTION","Assessment","Observation","Weight",null,"Value"]
[null,"Cruising aircraft"]
[null,"An adequate number of suitable aircraft is available","Absent",null,4,{"$f":"IF(C15=\"Not applicable\",0,E15)","v":4},{"$f":"VLOOKUP(C15,Notes,2,0)*F15","v":0},null,null,{"$f":"IF(C15=\"Not applicable\",\"\",VLOOKUP(C15,Notes,2,0))","v":0}]
[null,"Their equipment complies with needs and requests","Absent",null,4,{"$f":"IF(C16=\"Not applicable\",0,E16)","v":4},{"$f":"VLOOKUP(C16,Notes,2,0)*F16","v":0},null,null,{"$f":"IF(C16=\"Not applicable\",\"\",VLOOKUP(C16,Notes,2,0))","v":0}]
[null,"Their equipment is suitable and practical for planned activities","Absent",null,4,4,{"$f":"VLOOKUP(C17,Notes,2,0)*F17","v":0},null,null,{"$f":"IF(C17=\"Not applicable\",\"\",VLOOKUP(C17,Notes,2,0))","v":0}]
[null,"Result",{"$f":"+AVERAGE(J15:J17)/3","v":0},null,null,null,{"$f":"+SUM(G15:G17)/SUM(F15:F17)/3*20","v":0}]
[]
[]
[null,"QUESTION","Assessment","Observation","Weight",null,"Value"]
[null,"Provision and availability of ancillary equipment"]
[null,"Essentials for the pilot – helmets","Absent",null,4,{"$f":"IF(C23=\"Not applicable\",0,E23)","v":4},{"$f":"VLOOKUP(C23,Notes,2,0)*F23","v":0},null,null,{"$f":"IF(C23=\"Not applicable\",\"\",VLOOKUP(C23,Notes,2,0))","v":0}]
[null,"Necessities for aircraft preparation – tie-downs, cleaning materials etc","Absent",null,4,{"$f":"IF(C24=\"Not applicable\",0,E24)","v":4},0,null,null,{"$f":"IF(C24=\"Not applicable\",\"\",VLOOKUP(C24,Notes,2,0))","v":0}]
[null,"Necessities for flight – LSJs, high visibility jackets","Absent",null,4,4,0,null,null,{"$f":"IF(C25=\"Not applicable\",\"\",VLOOKUP(C25,Notes,2,0))","v":0}]
[null,"Oils are available and identified","Absent",null,4,4,0,null,null,{"$f":"IF(C26=\"Not applicable\",\"\",VLOOKUP(C26,Notes,2,0))","v":0}]
[null,"Keys are only available to authorised pilots","Absent",null,4,4,0,null,null,{"$f":"IF(C27=\"Not applicable\",\"\",VLOOKUP(C27,Notes,2,0))","v":0}]
[null,"Hangars are suitable","Absent",null,4,4,0,null,null,{"$f":"IF(C28=\"Not applicable\",\"\",VLOOKUP(C28,Notes,2,0))","v":0}]
[null,"Parking spaces are marked if required","Absent",null,3,3,0,null,null,{"$f":"IF(C29=\"Not applicable\",\"\",VLOOKUP(C29,Notes,2,0))","v":0}]
[null,"Result",{"$f":"+AVERAGE(J23:J29)/3","v":0},null,null,null,{"$f":"+SUM(G23:G29)/SUM(F23:F29)/3*20","v":0}]

{"sheet":"Aircraft availability 2","index":9,"n_rows":23,"n_cols":15,"rows_kept":23,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"VI- Aircraft availability 2"]
[]
[null,"QUESTION","Assessment","Observation","Weight",null,"Value"]
[null,"Workshop and maintenance"]
[null,"Aircraft maintenance is organised","Absent",null,5,{"$f":"IF(C6=\"Not applicable\",0,E6)","v":5},{"$f":"VLOOKUP(C6,Notes,2,0)*F6","v":0},null,null,{"$f":"IF(C6=\"Not applicable\",\"\",VLOOKUP(C6,Notes,2,0))","v":0}]
[null,"The competent engineer is available to the pilots","absent",null,4,{"$f":"IF(C7=\"Not applicable\",0,E7)","v":4},{"$f":"VLOOKUP(C7,Notes,2,0)*E7","v":0},null,null,{"$f":"IF(C7=\"Not applicable\",\"\",VLOOKUP(C7,Notes,2,0))","v":0}]
[null,"The workshop is separate from the hangar","absent",null,3,3,0,null,null,{"$f":"IF(C8=\"Not applicable\",\"\",VLOOKUP(C8,Notes,2,0))","v":0}]
[null,"Access is restricted to authorised persons","absent",null,5,5,0,null,null,{"$f":"IF(C9=\"Not applicable\",\"\",VLOOKUP(C9,Notes,2,0))","v":0}]
[null,"A competent person certifies release to service","absent",null,5,5,0,null,null,{"$f":"IF(C10=\"Not applicable\",\"\",VLOOKUP(C10,Notes,2,0))","v":0}]
[null,"The workshop is properly protected against risks","Absent",null,4,4,0,null,null,{"$f":"IF(C11=\"Not applicable\",\"\",VLOOKUP(C11,Notes,2,0))","v":0}]
[null,"The engineers have suitable equipment","Absent",null,3,3,0,null,null,{"$f":"IF(C12=\"Not applicable\",\"\",VLOOKUP(C12,Notes,2,0))","v":0},null,null,null,{"$f":"'Aircraft availability 1'!B6","v":"Aircraft for instruction "},{"$f":"'Aircraft availability 1'!G11","v":0}]
[null,"Result",{"$f":"+AVERAGE(J6:J12)/3","v":0},null,null,null,{"$f":"+SUM(G6:G12)/SUM(F6:F12)/3*20","v":0},null,null,null,null,null,null,{"$f":"+'Aircraft availability 1'!B14","v":"Cruising aircraft"},{"$f":"+'Aircraft availability 1'!G18","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Aircraft availability 1'!B22","v":"Provision and availability of ancillary equipment"},{"$f":"'Aircraft availability 1'!G30","v":0}]
[]
[null,"Average assessment of aircraft availability: x/20",{"$f":"+AVERAGE('Aircraft availability 1'!G30,'Aircraft availability 1'!G18,'Aircraft availability 1'!G11)","v":0}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"L'ADEQUATION DES AVIONS DESTINES A L'INSTRUCTION",{"$f":"+'Aircraft availability 1'!G11","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"L'ADEQUATION DES AVIONS DE VOYAGE",{"$f":"+'Aircraft availability 1'!G18","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"DISPONIBILITE ET ADEQUATION DES ACCESSOIRES LIES AUX AVIONS",{"$f":"+'Aircraft availability 1'!G30","v":0}]

{"sheet":"Environment and safety 1","index":10,"n_rows":32,"n_cols":10,"rows_kept":32,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"VII- Environment and safety"]
[]
[null,"QUESTION","Assessment","Observation","Weight",null,"Value"]
[null,"Fire precautions"]
[null,"Airfield fire precautions are known by the pilots, especially refuelling precautions","Absent",null,4,{"$f":"IF(C6=\"Not applicable\",0,E6)","v":4},{"$f":"VLOOKUP(C6,Notes,2,0)*F6","v":0},null,null,{"$f":"IF(C6=\"Not applicable\",\"\",VLOOKUP(C6,Notes,2,0))","v":0}]
[null,"Extinguishers are available","Absent",null,4,{"$f":"IF(C7=\"Not applicable\",0,E7)","v":4},{"$f":"VLOOKUP(C7,Notes,2,0)*F7","v":0},null,null,{"$f":"IF(C7=\"Not applicable\",\"\",VLOOKUP(C7,Notes,2,0))","v":0}]
[null,"They are of a suitable type and checked regularly","Absent",null,4,4,0,null,null,{"$f":"IF(C8=\"Not applicable\",\"\",VLOOKUP(C8,Notes,2,0))","v":0}]
[null,"Pilots know how to use them","Absent",null,3,3,0,null,null,{"$f":"IF(C9=\"Not applicable\",\"\",VLOOKUP(C9,Notes,2,0))","v":0}]
[null,"Inflammable materials are isolated","Absent",null,5,5,0,null,null,{"$f":"IF(C10=\"Not applicable\",\"\",VLOOKUP(C10,Notes,2,0))","v":0}]
[null,"Smoking prohibitions are defined, advertised, and complied with","Absent",null,4,4,0,null,null,{"$f":"IF(C11=\"Not applicable\",\"\",VLOOKUP(C11,Notes,2,0))","v":0}]
[null,"Each aircraft has a fire extinguisher","Absent",null,3,3,0,null,null,{"$f":"IF(C12=\"Not applicable\",\"\",VLOOKUP(C12,Notes,2,0))","v":0}]
[null,"These are suitable, and pilots know how to use them","Absent",null,3,3,0,null,null,{"$f":"IF(C13=\"Not applicable\",\"\",VLOOKUP(C13,Notes,2,0))","v":0}]
[null,"Result",{"$f":"+AVERAGE(J6:J13)/3","v":0},null,null,null,{"$f":"+SUM(G6:G13)/SUM(F6:F13)/3*20","v":0}]
[]
[null,"Accident procedures"]
[null,"Every member knows the airfield accident procedures","Absent",null,5,{"$f":"IF(C17=\"Not applicable\",0,E17)","v":5},{"$f":"VLOOKUP(C17,Notes,2,0)*F17","v":0},null,null,{"$f":"IF(C17=\"Not applicable\",\"\",VLOOKUP(C17,Notes,2,0))","v":0}]
[null,"The telephone numbers for emergency services are displayed","Absent",null,5,{"$f":"IF(C18=\"Not applicable\",0,E18)","v":5},0,null,null,{"$f":"IF(C18=\"Not applicable\",\"\",VLOOKUP(C18,Notes,2,0))","v":0}]
[null,"Pilots are encouraged to become first aiders","Absent",null,3,3,0,null,null,{"$f":"IF(C19=\"Not applicable\",\"\",VLOOKUP(C19,Notes,2,0))","v":0}]
[null,"A suitable first-aid box is easily available","Absent",null,5,5,0,null,null,{"$f":"IF(C20=\"Not applicable\",\"\",VLOOKUP(C20,Notes,2,0))","v":0}]
[null,"The procedure for off-aerodrome accidents is known","Absent",null,5,5,0,null,null,{"$f":"IF(C21=\"Not applicable\",\"\",VLOOKUP(C21,Notes,2,0))","v":0}]
[null,"Emergency numbers are included in the accident checklist","Absent",null,4,4,0,null,null,{"$f":"IF(C22=\"Not applicable\",\"\",VLOOKUP(C22,Notes,2,0))","v":0}]
[null,"Result",{"$f":"+AVERAGE(J17:J22)/3","v":0},null,null,null,{"$f":"+SUM(G17:G22)/SUM(F17:F22)/3*20","v":0}]
[]
[null,"Hazardous items"]
[null,"Hazardous items, such as fuel, are identified","Absent",null,4,{"$f":"IF(C26=\"Not applicable\",0,E26)","v":4},{"$f":"VLOOKUP(C26,Notes,2,0)*F26","v":0},null,null,{"$f":"IF(C26=\"Not applicable\",\"\",VLOOKUP(C26,Notes,2,0))","v":0}]
[null,"The risks are identified","Absent",null,4,{"$f":"IF(C27=\"Not applicable\",0,E27)","v":4},0,null,null,{"$f":"IF(C27=\"Not applicable\",\"\",VLOOKUP(C27,Notes,2,0))","v":0}]
[null,"Consideration is given to less hazardous alternative items","Absent",null,3,3,0,null,null,{"$f":"IF(C28=\"Not applicable\",\"\",VLOOKUP(C28,Notes,2,0))","v":0}]
[null,"Quantities of hazardous items held are controlled","Absent",null,3,3,0,null,null,{"$f":"IF(C29=\"Not applicable\",\"\",VLOOKUP(C29,Notes,2,0))","v":0}]
[null,"Provision is made for leakage control","Absent",null,3,3,0,null,null,{"$f":"IF(C30=\"Not applicable\",\"\",VLOOKUP(C30,Notes,2,0))","v":0}]
[null,"There is a procedure for disposal of used hazardous items ","Absent",null,4,4,0,null,null,{"$f":"IF(C31=\"Not applicable\",\"\",VLOOKUP(C31,Notes,2,0))","v":0}]
[null,"Result",{"$f":"+AVERAGE(J26:J31)/3","v":0},null,null,null,{"$f":"+SUM(G26:G31)/SUM(F26:F31)/3*20","v":0}]

{"sheet":"Environment and safety 2","index":11,"n_rows":28,"n_cols":16,"rows_kept":28,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"VII- Environment and safety 2"]
[]
[null,"QUESTION","Assessment","Observation","Weight",null,"Value"]
[null,"Environmental Considerations"]
[null,"Environmental consequences are constantly considered during club operations","Absent",null,5,{"$f":"IF(C6=\"Not applicable\",0,E6)","v":5},{"$f":"VLOOKUP(C6,Notes,2,0)*F6","v":0},null,null,{"$f":"IF(C6=\"Not applicable\",\"\",VLOOKUP(C6,Notes,2,0))","v":0}]
[null,"Noise abatement tracks are respected, especially on departure and arrival","Absent",null,4,{"$f":"IF(C7=\"Not applicable\",0,E7)","v":4},{"$f":"VLOOKUP(C7,Notes,2,0)*F7","v":0},null,null,{"$f":"IF(C7=\"Not applicable\",\"\",VLOOKUP(C7,Notes,2,0))","v":0}]
[null,"Environmental considerations are taken into account in the choice of aircraft","Absent",null,3,3,{"$f":"VLOOKUP(C8,Notes,2,0)*F8","v":0},null,null,{"$f":"IF(C8=\"Not applicable\",\"\",VLOOKUP(C8,Notes,2,0))","v":0}]
[null,"Result",{"$f":"+AVERAGE(J6:J8)/3","v":0},null,null,null,{"$f":"SUM(G6:G8)/SUM(F6:F8)/3*20","v":0}]
[]
[null,"QUESTION","Assessment","Observation","Weight",null,"Value"]
[null,"Traffic"]
[null,"Vehicular traffic can move safely around the organisation","Absent",null,4,{"$f":"IF(C13=\"Not applicable\",0,E13)","v":4},{"$f":"VLOOKUP(C13,Notes,2,0)*F13","v":0},null,null,{"$f":"IF(C13=\"Not applicable\",\"\",VLOOKUP(C13,Notes,2,0))","v":0}]
[null,"Parking areas are clearly marked","Absent",null,3,{"$f":"IF(C14=\"Not applicable\",0,E14)","v":3},{"$f":"VLOOKUP(C14,Notes,2,0)*F14","v":0},null,null,{"$f":"IF(C14=\"Not applicable\",\"\",VLOOKUP(C14,Notes,2,0))","v":0}]
[null,"Pedestrians can move safely around the organisation's area","Absent",null,5,5,{"$f":"VLOOKUP(C15,Notes,2,0)*F15","v":0},null,null,{"$f":"IF(C15=\"Not applicable\",\"\",VLOOKUP(C15,Notes,2,0))","v":0}]
[null,"Pedestrian movement within the organisation's area is obvious","Absent",null,4,4,{"$f":"VLOOKUP(C16,Notes,2,0)*F16","v":0},null,null,{"$f":"IF(C16=\"Not applicable\",\"\",VLOOKUP(C16,Notes,2,0))","v":0}]
[null,"Areas are cleaned to prevent personal accidents ","Absent",null,4,4,{"$f":"VLOOKUP(C17,Notes,2,0)*F17","v":0},null,null,{"$f":"IF(C17=\"Not applicable\",\"\",VLOOKUP(C17,Notes,2,0))","v":0},null,null,{"$f":"'Environment and safety 1'!B5","v":"Fire precautions"},{"$f":"'Environment and safety 1'!G14","v":0}]
[null,"Result",{"$f":"+AVERAGE(J13:J17)/3","v":0},null,null,null,{"$f":"+SUM(G13:G17)/SUM(F13:F17)/3*20","v":0}]
[]
[]
[null,"Average assessment : Environment and safety x/20",{"$f":"+AVERAGE(G18,G9,'Environment and safety 1'!G14,'Environment and safety 1'!G23,'Environment and safety 1'!G32)","v":0}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"+'Environment and safety 1'!B5","v":"Fire precautions"},null,null,null,null,{"$f":"+'Environment and safety 1'!B5","v":"Fire precautions"},{"$f":"+'Environment and safety 1'!G14","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"+'Environment and safety 1'!B16","v":"Accident procedures"},null,null,null,null,{"$f":"+'Environment and safety 1'!B16","v":"Accident procedures"},{"$f":"+'Environment and safety 1'!G23","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"+'Environment and safety 1'!B25","v":"Hazardous items"},null,null,null,null,{"$f":"+'Environment and safety 1'!B25","v":"Hazardous items"},{"$f":"+'Environment and safety 1'!G32","v":0}]

{"sheet":"Action Plan","index":12,"n_rows":15,"n_cols":10,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"VIII - Action Plan"]
[]
[null,"QUESTION","Assessment","Observation","Weight",null,"Value"]
[null,"Action Plan"]
[null,"There is an action plan within the organisation","Absent",null,5,{"$f":"IF(C6=\"Not applicable\",0,E6)","v":5},{"$f":"VLOOKUP(C6,Notes,2,0)*F6","v":0},null,null,{"$f":"IF(C6=\"Not applicable\",\"\",VLOOKUP(C6,Notes,2,0))","v":0}]
[null,"The Plan is available to all pilots","Absent",null,4,{"$f":"IF(C7=\"Not applicable\",0,E7)","v":4},{"$f":"VLOOKUP(C7,Notes,2,0)*E7","v":0},null,null,{"$f":"IF(C7=\"Not applicable\",\"\",VLOOKUP(C7,Notes,2,0))","v":0}]
[null,"Findings are fed into the Plan to influence it","Absent",null,3,3,0,null,null,{"$f":"IF(C8=\"Not applicable\",\"\",VLOOKUP(C8,Notes,2,0))","v":0}]
[null,"The Accountable Manager has validated the Plan","Absent",null,5,5,0,null,null,{"$f":"IF(C9=\"Not applicable\",\"\",VLOOKUP(C9,Notes,2,0))","v":0}]
[null,"Persons allocated individual actions are defined","Absent",null,4,4,{"$f":"VLOOKUP(C10,Notes,2,0)*E10","v":0},null,null,{"$f":"IF(C10=\"Not applicable\",\"\",VLOOKUP(C10,Notes,2,0))","v":0}]
[null,"Its progress is assessed regularly ","Absent",null,4,4,0,null,null,{"$f":"IF(C11=\"Not applicable\",\"\",VLOOKUP(C11,Notes,2,0))","v":0}]
[null,"The club makes the investments required by their risk analysis","Absent",null,5,5,0,null,null,{"$f":"IF(C12=\"Not applicable\",\"\",VLOOKUP(C12,Notes,2,0))","v":0}]
[null,"Result",{"$f":"+AVERAGE(J6:J12)/3","v":0},null,null,null,{"$f":"SUM(G6:G12)/SUM(F6:F12)/3*20","v":0}]
[]
[null,"Average assessment : Action Plan  x/20",{"$f":"+AVERAGE(G13)","v":0}]

{"sheet":"Affiliations","index":13,"n_rows":26,"n_cols":10,"rows_kept":26,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"IX- Club affiliations"]
[]
[null,"QUESTION","Assessment","Observation","Weight",null,"Value"]
[null,"Club structure"]
[null,"Elected representatives are involved in the Safety Management System","absent",null,5,{"$f":"IF(C6=\"Not Applicable\",0,E6)","v":5},{"$f":"VLOOKUP(C6,Notes,2,0)*F6","v":0},null,null,{"$f":"IF(C6=\"Not Applicable\",\"\",VLOOKUP(C6,Notes,2,0))","v":0}]
[null,"The SMS is re-evaluated routinely by the club management","absent",null,4,{"$f":"IF(C7=\"Not Applicable\",0,E7)","v":4},0,null,null,{"$f":"IF(C7=\"Not Applicable\",\"\",VLOOKUP(C7,Notes,2,0))","v":0}]
[null,"The SMS complies with the club's constitution","absent",null,4,4,0,null,null,{"$f":"IF(C8=\"Not Applicable\",\"\",VLOOKUP(C8,Notes,2,0))","v":0}]
[null,"Regulations are brought to the attention of all pilots","Absent",null,5,5,0,null,null,{"$f":"IF(C9=\"Not Applicable\",\"\",VLOOKUP(C9,Notes,2,0))","v":0}]
[null,"The SMS complies with the club's by-laws","Absent",null,4,4,0,null,null,{"$f":"IF(C10=\"Not Applicable\",\"\",VLOOKUP(C10,Notes,2,0))","v":0}]
[null,"Club by-laws are brought to the attention of all club pilots","Absent",null,5,5,0,null,null,{"$f":"IF(C11=\"Not Applicable\",\"\",VLOOKUP(C11,Notes,2,0))","v":0}]
[null,"There is a formal procedure for welcoming new members","Absent",null,4,4,0,null,null,{"$f":"IF(C12=\"Not Applicable\",\"\",VLOOKUP(C12,Notes,2,0))","v":0}]
[null,"The welcome procedure is carried out by competent and knowledgeable persons","Absent",null,4,4,0,null,null,{"$f":"IF(C13=\"Not Applicable\",\"\",VLOOKUP(C13,Notes,2,0))","v":0}]
[null,"Result",{"$f":"+AVERAGE(J6:J13)/3","v":0},null,null,null,{"$f":"+SUM(G6:G13)/SUM(F6:F13)/3*20","v":0}]
[]
[]
[null,"Relations with National bodies"]
[null,"The organisation receives safety information from external safety bodies","well",null,1,{"$f":"IF(C18=\"Not applicable\",0,E18)","v":1},{"$f":"VLOOKUP(C18,Notes,2,0)*F18","v":3},null,null,{"$f":"IF(C18=\"Not applicable\",\"\",VLOOKUP(C18,Notes,2,0))","v":3}]
[null,"The organisation makes use of that safety information","Absent",null,2,{"$f":"IF(C19=\"Not applicable\",0,E19)","v":2},{"$f":"VLOOKUP(C19,Notes,2,0)*F19","v":0},null,null,{"$f":"IF(C19=\"Not applicable\",\"\",VLOOKUP(C19,Notes,2,0))","v":0}]
[null,"The organisation has access to safety information from regulators and appropriate bodies","Absent",null,3,3,{"$f":"VLOOKUP(C20,Notes,2,0)*F20","v":0},null,null,{"$f":"IF(C20=\"Not applicable\",\"\",VLOOKUP(C20,Notes,2,0))","v":0}]
[null,"The organisation makes use of that information","not applicable",null,4,0,{"$f":"VLOOKUP(C21,Notes,2,0)*F21","v":0},null,null,{"$f":"IF(C21=\"Not applicable\",\"\",VLOOKUP(C21,Notes,2,0))","v":""}]
[null,"The organisation stays in contact with the national or regional safety officer","Absent",null,4,4,{"$f":"VLOOKUP(C22,Notes,2,0)*F22","v":0},null,null,{"$f":"IF(C22=\"Not applicable\",\"\",VLOOKUP(C22,Notes,2,0))","v":0}]
[null,"Result",{"$f":"+AVERAGE(J18:J22)/3","v":0.25},null,null,null,{"$f":"+SUM(G18:G22)/SUM(F18:F22)/3*20","v":1.9999999999999998}]
[]
[]
[null,"Average assessment : Club affiliations  x/20",{"$f":"+AVERAGE(G14,G23)","v":0.99999999999999989}]

{"sheet":"Overall","index":14,"n_rows":30,"n_cols":4,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Average assessment of \"Safety Management \" : x/20",null,"Average assessment of Aircraft availability : x/20"]
[]
[]
[]
[]
[]
[]
[null,"Average assessment of \"Learning from experience\" :  x/20",null,"Average assessment of : Environment and safety x/20"]
[]
[]
[]
[]
[]
[]
[null,"Average assessment of \"Risk management\" :  x/20",null,"Average assessment of : Action Plan  x/20"]
[]
[]
[]
[]
[]
[]
[null,"Average assessment of  \"Organisation of activities\" : x/20",null,"Average assessment of : Club affiliations  x/20"]
[]
[]
[]
[]
[]
[]
[null,"Average assessment of \"Training\" : x/20"]

{"sheet":"Formulas","index":15,"n_rows":7,"n_cols":2,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
["Appreciation","Note"]
["Not Applicable",0]
["Absent",0]
["Average",1]
["Quite well",2]
["Well",3]

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