{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Exp Claim Form (Sample)","Exp Claim Form"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":6,"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":"Exp Claim Form (Sample)","index":0,"n_rows":59,"n_cols":16,"rows_kept":59,"cut":false,"hidden":false,"merged":[[32,8,34,10],[32,12,34,12],[41,1,41,3],[2,0,2,1],[2,2,2,10],[2,11,2,12],[5,10,5,11],[30,0,31,5],[30,8,30,10],[31,8,31,10]]}
[null,null,null,null,null,null,{"$f":"$O1","v":1},null,null,null,null,null,null,null,1]
["NAME",null,null,null,null,null,null,null,null,null,null,"PROJECT :",null,null,"Claim No."]
["Claimant Name",null,"Ham United Group CIC",null,null,null,null,null,null,null,null,null,null,null,1]
[]
["EXPENSES CLAIM FORM"]
["DATE","DETAILS","Event Costs","Equipment &  Materials","Advertising","Events Venues","Building Maint. & Repairs","Insurance ","IT Costs","Canteen Supplies","Other  Costs",null,"TOTAL",null,"Enter Amount"]
[null,null,"       £","£","       £","£","£","£","£","£","£","Exp. A/c","£",null,""]
["d/mm","Supplier's Name, Exp. Description",null,null,null,null,{"$f":"O8","v":192.11},null,null,null,null,null,{"$f":"SUM(C8:K8)","v":192.11},null,192.11,{"$f":"IF(O8-M8=0,\"Ok\",O8-M8)","v":"Ok"}]
["d/mm","Supplier's Name, Exp. Description",{"$f":"$O9","v":20.190000000000001},null,null,null,null,null,null,null,null,null,{"$f":"SUM(C9:K9)","v":20.190000000000001},null,20.190000000000001,{"$f":"IF(O9-M9=0,\"Ok\",O9-M9)","v":"Ok"}]
["d/mm","Supplier's Name, Exp. Description",null,null,null,null,null,{"$f":"$O10","v":6.98},null,null,null,null,6.98,null,6.98,"Ok"]
["d/mm","Supplier's Name, Exp. Description",null,null,null,{"$f":"$O11","v":8.8000000000000007},null,null,null,null,null,null,8.8000000000000007,null,8.8000000000000007,{"$f":"IF(O11-M11=0,\"Ok\",O11-M11)","v":"Ok"}]
["d/mm","Supplier's Name, Exp. Description",null,null,null,null,null,null,{"$f":"$O12","v":3.99},null,null,null,3.99,null,3.99,"Ok"]
["d/mm","Supplier's Name, Exp. Description",null,{"$f":"$O13","v":42.22},null,null,null,null,null,null,null,null,42.22,null,42.22,"Ok"]
["d/mm","Supplier's Name, Exp. Description",null,null,null,null,null,null,null,null,{"$f":"$O14","v":15.4},"Equipment Hire",15.4,null,15.4,{"$f":"IF(O14-M14=0,\"Ok\",O14-M14)","v":"Ok"}]
["d/mm","Supplier's Name, Exp. Description",null,null,null,null,null,{"$f":"$O15","v":192.11},null,null,null,null,192.11,null,192.11,"Ok"]
["d/mm","Supplier's Name, Exp. Description",null,null,null,null,null,null,null,{"$f":"$O16","v":4.75},null,null,4.75,null,4.75,"Ok"]
["d/mm","Supplier's Name, Exp. Description",null,null,{"$f":"$O17","v":7.92},null,null,null,null,null,null,null,7.92,null,7.92,"Ok"]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Ok"]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Ok"]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Ok"]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Ok"]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Ok"]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Ok"]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Ok"]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Ok"]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Ok"]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Ok"]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Ok"]
[null,"TOTAL /C/Fwd",{"$f":"SUBTOTAL(9,C8:C28)","v":20.190000000000001},42.22,7.92,8.8000000000000007,192.11,199.09,3.99,4.75,15.4,0,{"$f":"SUBTOTAL(9,M8:M28)","v":494.47},null,{"$f":"SUBTOTAL(9,O8:O28)","v":494.47},"Ok"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(O29-I33=0,\"Agreed\",O29-I33)","v":"Agreed"}]
["THREE HUNDRED, SIXTY SEVEN POUNDS AND 56p",null,null,null,null,null,null,null,"TOTAL",null,null,null,"CLAIM"]
[null,null,null,null,null,null,null,null,"CLAIMED",null,null,null,"NUMBER"]
["SIGNED",null,"AUTHORISED",null,"RECEIVED",null,null,null,{"$f":"SUM(C29:K29)","v":494.47},null,null,null,{"$f":"O3","v":1}]
[]
["DATE","d/mm","DATE",null,"DATE",null,null,null,null,null,null,null,null,null,{"$f":"IF(I33-M29=0,\"Agreed\",I33-M29)","v":"Agreed"}]
[]
[]
[]
[]
["Instructions:"]
[]
[null,"Please take a couple of minutes and read the following:"]
[]
[null,"DO NOT ENTER or DELETE VALUES IN SHADED FIELDS"]
[1,"Enter \"NAME\" and  Claim No. in the Purple Box"]
[2,"Enter the receit's \"DATE\""]
[3,"Enter  \"DETAILS\" \"Supplier's Name, Exp. Description\" and, "]
[4,"Enter the receipt's Amount in the Purple Column"]
[5,"Enter Claim's Date (as d/mm) at the bottom of the form"]
[6,"SAVE CLAIM AS \"Claimant's Name - Exp. Claim yyyy-mm-dd\""]
[null,"ANALYSIS:"]
[7,"Copy Cell \"G1\" and Paste Special Formulas in the appropiate Expense columns "]
[8,"On completion, Purple Column Total should equal TOTAL CLAIMED"]
[9,"Print \"Preview\" to check/adjust printing setting, Print and Sign Claim."]
[null,"Use it again DELITING UNSHADED fields."]
[]
[null,null,null,null,"Thank you."]
[]
[null,"Use Blank Exp. Form on Next Tab"]

{"sheet":"Exp Claim Form","index":1,"n_rows":59,"n_cols":16,"rows_kept":59,"cut":false,"hidden":false,"merged":[[41,1,41,3],[30,0,31,5],[2,11,2,12],[32,12,34,12],[2,0,2,1],[2,2,2,10],[30,8,30,10],[31,8,31,10],[32,8,34,10],[5,10,5,11]]}
[null,null,null,null,null,null,{"$f":"$O1","v":1},null,null,null,null,null,null,null,1]
["NAME",null,null,null,null,null,null,null,null,null,null,"PROJECT :",null,null,"Claim No."]
[null,null,"Ham United Group CIC"]
[]
["EXPENSES CLAIM FORM"]
["DATE","DETAILS","Event Costs","Equipment &  Materials","Advertising","Events Venues","Building Maint. & Repairs","Insurance ","IT Costs","Canteen Supplies","Other  Costs",null,"TOTAL",null,"Enter Amount"]
[null,null,"       £","£","       £","£","£","£","£","£","£","Exp. A/c","£",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C8:K8)","v":0},null,null,{"$f":"IF(O8-M8=0,\"Ok\",O8-M8)","v":"Ok"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C9:K9)","v":0},null,null,{"$f":"IF(O9-M9=0,\"Ok\",O9-M9)","v":"Ok"}]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Ok"]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Ok"]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Ok"]
[null,null,null,{"$f":"$O13","v":0},null,null,null,null,null,null,null,null,0,null,null,"Ok"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"$O14","v":0},null,0,null,null,"Ok"]
[null,null,null,null,null,null,null,{"$f":"$O15","v":0},null,null,null,null,0,null,null,"Ok"]
[null,null,null,null,null,null,null,null,null,{"$f":"$O16","v":0},null,null,0,null,null,"Ok"]
[null,null,null,null,{"$f":"$O17","v":0},null,null,null,null,null,null,null,0,null,null,"Ok"]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Ok"]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Ok"]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Ok"]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Ok"]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Ok"]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Ok"]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Ok"]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Ok"]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Ok"]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Ok"]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Ok"]
[null,"TOTAL /C/Fwd",{"$f":"SUBTOTAL(9,C8:C28)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUBTOTAL(9,M8:M28)","v":0},null,{"$f":"SUBTOTAL(9,O8:O28)","v":0},"Ok"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(O29-I33=0,\"Agreed\",O29-I33)","v":"Agreed"}]
["AMOUNT IN WORDS",null,null,null,null,null,null,null,"TOTAL",null,null,null,"CLAIM"]
[null,null,null,null,null,null,null,null,"CLAIMED",null,null,null,"NUMBER"]
["SIGNED",null,"AUTHORISED",null,"RECEIVED",null,null,null,{"$f":"SUM(C29:K29)","v":0},null,null,null,{"$f":"O3","v":0}]
[]
["DATE","d/mm","DATE",null,"DATE",null,null,null,null,null,null,null,null,null,{"$f":"IF(I33-M29=0,\"Agreed\",I33-M29)","v":"Agreed"}]
[]
[]
[]
[]
["Instructions:"]
[]
[null,"Please take a couple of minutes and read the following:"]
[]
[null,"DO NOT ENTER or DELETE VALUES IN SHADED FIELDS"]
[1,"Enter \"NAME\" and  Claim No. in the Purple Box"]
[2,"Enter the receit's \"DATE\""]
[3,"Enter  \"DETAILS\" \"Supplier's Name, Exp. Description\" and, "]
[4,"Enter the receipt's Amount in the Purple Column"]
[5,"Enter Claim's Date (as d/mm) at the bottom of the form"]
[6,"SAVE CLAIM AS \"Claimant's Name - Exp. Claim yyyy-mm-dd\""]
[null,"ANALYSIS:"]
[7,"Copy Cell \"G1\" and Paste Special Formulas in the appropiate Expense columns "]
[8,"On completion, Purple Column Total should equal TOTAL CLAIMED"]
[9,"Print \"Preview\" to check/adjust printing setting, Print and Sign Claim."]
[null,"Use it again DELITING UNSHADED fields."]
[]
[null,null,null,null,"Thank you."]
[]
[null,"See Previous Tab for ilustration"]