{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Instrument Worksheet","Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":1,"comments":1,"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":"Instrument Worksheet","index":0,"n_rows":42,"n_cols":23,"rows_kept":42,"cut":false,"hidden":false,"merged":[[39,10,39,11],[9,1,11,2],[19,1,19,2],[17,1,17,2],[21,1,21,2],[22,1,22,2],[23,1,23,2],[33,6,33,7],[34,1,34,3],[10,13,11,13],[9,9,9,11],[9,3,9,8],[10,3,10,4],[10,5,10,6],[10,7,10,8],[28,0,31,0],[33,0,36,0],[32,0,32,12],[28,9,29,9],[30,9,31,9],[28,1,29,1],[30,1,31,1],[28,3,29,3],[33,10,33,11],[29,5,30,5],[20,0,26,0],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[12,0,18,0],[24,1,24,2],[25,1,25,2],[5,9,5,11],[5,3,5,5],[7,3,7,4],[29,8,30,8],[30,3,31,3],[28,6,29,6],[30,6,31,6]]}
[]
[]
[]
[]
[]
[null,null,"Pilots Name:","LT First Last",null,null,null,null,null,"DATE OF CHECK RIDE"]
[null,null,null,null,null,null,null,null,null,"Month","Day","Year"]
[null,null,"Date Prepared:","2014-08-28",null,null,null,null,null,8,29,14]
[]
[null,"MONTH",null,"AIRCRAFT",null,null,null,null,null,"SIMULATOR"]
[null,null,null,"Hours",null,"Precision",null,"Non-Precision",null,"Hours","Precision","Non"]
[null,null,null,"Actual","Sim",1,"A",2,"B","SIM","A","B"]
[null,{"$f":"IF(K8 > 2,DATE(L8,J8,K8-SUM(K8-1)),\"NA\")","v":"1914-08-01"},{"$f":"IF(K8 > 1,DATE(L8,J8,K8-1),\"NA\")","v":"1914-08-28"},null,6.3,null,6,null,10,7.8,4,12]
[null,{"$f":"DATE(L8,J8-1,K8-SUM(K8-1))","v":"1914-07-01"},null,null,2.1,null,null,null,1,2.6,null,1]
[null,{"$f":"DATE(L8,J8-2,K8-SUM(K8-1))","v":"1914-06-01"}]
[null,{"$f":"DATE(L8,J8-3,K8-SUM(K8-1))","v":"1914-05-01"}]
[null,{"$f":"DATE(L8,J8-4,K8-SUM(K8-1))","v":"1914-04-01"},null,1.5,null,null,null,null,null,0.5,1]
[null,{"$f":"DATE(L8,J8-5,K8-SUM(K8-1))","v":"1914-03-01"}]
[null,{"$f":"DATE(L8,J8-6,K8)","v":"1914-03-01"},{"$f":"DATE(L8,J8-5,K8-K8)","v":"1914-02-28"}]
[]
[null,{"$f":"IF(K8 > 1,DATE(L8,J8-6,K8-SUM(K8-1)),\"NA\")","v":"1914-02-01"},{"$f":"DATE(L8,SUM(J8-6),K8 - 1)","v":"1914-02-28"},null,1,null,1,null,1,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D6:E6)","v":0}]
[null,{"$f":"DATE(L8,J8-7,K8-SUM(K8-1))","v":"1914-01-01"},null,3]
[null,{"$f":"DATE(L8,J8-8,K8-SUM(K8-1))","v":"1913-12-01"},null,7.6,2,1,8,null,6,null,null,null,null,null,null,null,null,null,null,null,"50% Rule for calcs"]
[null,{"$f":"DATE(L8,J8-9,K8-SUM(K8-1))","v":"1913-11-01"},null,2.5,0.1,1,null,null,null,3.5,null,null,null,null,null,null,"Sim's","Hours","Pre -A ","Non - B","HRS","PRE A","Non B"]
[null,{"$f":"DATE(L8,J8-10,K8-SUM(K8-1))","v":"1913-10-01"},null,1,0.4,null,null,null,null,1,null,null,null,null,null,null,"L6",{"$f":"SUM(J13:J19)","v":10.9},{"$f":"SUM(K13:K19)","v":5},{"$f":"SUM(L13:L19)","v":13},{"$f":"IF(R25>2.99,3,R25)","v":3},{"$f":"IF(S25>2.99,3,S25)","v":3},{"$f":"IF(T25>2.99,3,T25)","v":3}]
[null,{"$f":"DATE(L8,J8-11,K8-SUM(K8-1))","v":"1913-09-01"},null,4.5999999999999996,0.7,null,null,null,null,null,null,null,null,null,null,null,"L12",{"$f":"SUM(J13:J27)","v":15.4},{"$f":"SUM(K13:K27)","v":5},{"$f":"SUM(L13:L27)","v":13},{"$f":"IF(R26>5.99,6,R26)","v":6},{"$f":"IF(S26>5.99,6,S26)","v":5},{"$f":"IF(T26>2.99,3,T26)","v":3}]
[null,{"$f":"DATE(L8,J8-12,K8)","v":"1913-08-29"},{"$f":"DATE(L8,J8-11,K8-K8)","v":"1913-08-31"},0.1]
[]
["Checks","Last 6 Months","ACFT","Instrument",{"$f":"SUM(D13:D19,E13:E19)","v":9.9},"x => 3.0","Precision",{"$f":"SUM(F13:F19,G13:G19)","v":6},"x => 3","Non-Precision",{"$f":"SUM(H13:H19,I13:I19)","v":11},"x => 3"]
[null,null,"ACFT + Simulator",null,{"$f":"SUM(D13:D19,E13:E19,J13:J19)","v":20.8},"x => 6.0",null,{"$f":"SUM(F13:F19,G13:G19,K13:K19)","v":11},"x => 6",null,{"$f":"SUM(H13:H19,I13:I19,L13:L19)","v":24},"x => 6"]
[null,"Last 12 Months","ACFT","Hours",{"$f":"SUM(D13:D27,E13:E27)","v":32.900000000000006},null,"Approaches",{"$f":"SUM(F13:F27,G13:G27)","v":17},null,"Approaches",{"$f":"SUM(H13:H27,I13:I27)","v":18},"x => 3"]
[null,null,"ACFT + Simulator",null,{"$f":"SUM(D13:D27,E13:E27,J13:J27)","v":48.300000000000004},"x => 12",null,{"$f":"SUM(F13:F27,G13:G27,K13:K27)","v":22},"x => 12",null,{"$f":"SUM(H13:H27,I13:I27,L13:L27)","v":31},"x => 6"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"50% Rule for Calcs"]
[null,null,null,null,null,null,"LAST",null,null,null,"LAST",null,null,null,null,null,null,null,null,null,"Last  12","Last   6"]
[null,"Instrument Rating Requirements",null,null,null,"Approaches","6 Months","12 Months",null,"INST Time","12 Months","6 Months",null,null,null,null,null,null,null,null,{"$f":"SUM(D13:E27)","v":32.900000000000006},{"$f":"SUM(D13:E19)","v":9.9},{"$f":"SUM(U35:V35)","v":42.800000000000004}]
[null,null,null,null,null,"Prec ",{"$f":"IF(AND(H29>2.99, H30>5.99),H30,\"SHORT\")","v":11},{"$f":"IF(AND(H31>5.99, H32>11.99), H32, \"SHORT\")","v":22},null,"Actual",{"$f":"SUM(D13:D27)","v":20.3},{"$f":"SUM(D13:D19)","v":1.5},null,null,null,null,null,null,null,"Actual",{"$f":"IF(K36>5.99,6,K36)","v":6},{"$f":"IF(L36>2.99,3,L36)","v":1.5}]
[null,null,"Last 6","Last 12 ",null,"Non-Prec",{"$f":"IF(AND(K29>2.99,K30>5.99),K30,\"SHORT\")","v":24},{"$f":"IF(AND(K31>2.99, K32>5.99), K32, \"SHORT\")","v":31},null,"Simulated",{"$f":"SUM(E13:E27,J13:J27)","v":28},{"$f":"SUM(E13:E19,J13:J19)","v":19.3},null,null,null,null,null,null,null,"Sim",{"$f":"IF(K37>5.99,6,K37)","v":6},{"$f":"IF(L37>2.99,3,L37)","v":3}]
[null,"Hours",6,12,null,null,null,null,null,null,{"$f":"IF(U26+E31>11.99,K36+K37,\"SHORT\")","v":48.3},{"$f":"IF(U25+E29>5.99,L36+L37,\"SHORT\")","v":20.8},null,null,null,null,null,null,null,"Total",{"$f":"SUM(U36:U37)","v":12},{"$f":"SUM(V36:V37)","v":4.5}]
[null,"Precision",6,12,null,"Still Need","LAST"]
[null,"Non-Precision",6,6,null,"Approaches","6 Months","12 Months",null,"Still Need","LAST"]
[null,null,null,null,null,"Prec ",{"$f":"IF(G36=\"SHORT\",6-H29-V25,\"None\")","v":"None"},{"$f":"IF(H36=\"SHORT\",12-H31-V26,\"None\")","v":"None"},null,"INST Time","12 Months","6 Months"]
[null,null,null,null,null,"Non-Prec",{"$f":"IF(G37=\"SHORT\",6-K29-W25,\"None\")","v":"None"},{"$f":"IF(H37=\"SHORT\",6-K31-W26,\"None\")","v":"None"},null,"Still Need",{"$f":"IF(K38=\"SHORT\",12-(U35+U26),\"None\")","v":"None"},{"$f":"IF(L38=\"SHORT\",6-(U25+V35),\"None\")","v":"None"}]

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