{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Claim","Parameters"],"not_rendered":{"images":1,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Claim","index":0,"n_rows":36,"n_cols":14,"rows_kept":36,"merged":[[1,5,2,13],[5,4,5,5],[6,4,6,6],[6,10,9,12],[7,4,7,6],[8,4,8,6],[9,4,9,6],[35,13,35,14]]}
[]
[null,null,"Stratford on Avon BSAC",null,null,"This form must be completed in full by the claimant. It must then be signed and submitted to the Club's Treasurer, accompanied by receipts demonstrating actual costs incurred. Claims must be submitted within 30 days."]
[null,null,"Instructor expenses claim form "]
[]
[]
[null,null,"Trip date",{"$nulls":7}," Instructor's signature"]
[null,null,"Instructor"]
[null,null,"Instructor grade"]
[null,null,"Supervising instructor (required for AOWI)"]
[null,null,"Dive site"]
[]
[]
[]
[null,null,"Expenses claimed",null,"Actual","Max allowed","Claimed",{"$nulls":3},"Training dives conducted",null,1]
[null,null,"Dive site entry"]
[{"$nulls":3},"Cost (supported by receipt)",null,{"$f":"IF(M14>=2,Parameters!C3,Parameters!C3*Claim!M14/2)","v":{"v":10,"d":"10.00"}},{"$f":"IF(E16=\"\",0,MIN(E16:F16))","v":{"v":0,"d":"0.00"}},{"$nulls":4},"Trainee","Training done (e.g. OO3)"]
[{"$nulls":10},"Dive 1"]
[null,null,"Air fills"]
[{"$nulls":3},"Number of fills",null,{"$f":"M14","v":1}]
[{"$nulls":3},"Total cost (supported by receipt)",null,{"$f":"MIN(E19:F19)*Parameters!C4","v":{"v":6,"d":"6.00"}},{"$f":"IF(E20=\"\",0,MIN(E20:F20))","v":{"v":0,"d":"0.00"}}]
[{"$nulls":10},"Dive 2"]
[null,null,"Mileage"]
[{"$nulls":3},"Vehicle Reg"]
[{"$nulls":3},"Miles",null,{"$f":"IF(E8 = \"Assistant Open Water Instructor\", 0, Parameters!C6)","v":71}]
[{"$nulls":3},"Cost",{"$f":"Parameters!$C$5*E24","v":{"v":0,"d":"0.00"}},{"$f":"IF(M14>=2,Parameters!$C$5*F24,Parameters!$C$5*F24*M14/2)","v":{"v":6.177,"d":"6.18"}},{"$f":"IF(M14>=2, MIN(E25:F25), MIN(M14*E25/2,F25))","v":{"v":0,"d":"0.00"}},{"$nulls":3},"Dive 3"]
[]
[]
[null,null,"Total claimed",{"$nulls":3},{"$f":"SUM(G16:G25)","v":{"v":0,"d":"0.00"}}]
[]
[]
[]
[null,"Treasurer's use"]
[]
[]
[]
[{"$nulls":13},"2024-10-12"]

{"sheet":"Parameters","index":1,"n_rows":6,"n_cols":3,"rows_kept":6,"hidden":true}
[]
[null,"Caps and rates"]
[null,"Max entry fee",20]
[null,"Max air per fill",6]
[null,"Mileage rate",0.174]
[null,"Max miles",71]