{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["1 page claim form"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":13,"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":"1 page claim form","index":0,"n_rows":58,"n_cols":29,"rows_kept":58,"cut":false,"hidden":false,"merged":[[48,2,48,4],[37,7,37,11],[38,7,38,11],[45,7,45,12],[46,2,46,4],[47,2,47,4],[11,5,11,6],[30,7,30,12],[31,7,31,11],[32,7,32,11],[33,7,33,11],[6,0,6,1],[6,2,6,3],[6,5,6,6],[7,10,7,12],[8,1,8,2],[8,10,8,12],[0,0,0,12],[42,2,42,3],[2,1,2,3],[2,5,2,9],[2,10,3,11],[2,12,3,12],[3,1,3,3],[3,5,3,9],[4,10,4,12],[5,0,5,1],[5,2,5,3],[5,5,5,6],[5,8,6,8],[5,9,6,9],[5,10,6,11],[5,12,6,12]]}
[" ACCOUNT OF TRAVEL & SUBSISTENCE: (IRELAND)",null,null,null,null,null,null,null,null,null,null,null,null,null,"Distance Bands\nCut-Off points","Engine Capacity up to 1200CC","Engine Capacity 1201cc to 1500cc","Engine Capacity 1501cc and over",null,null,null,"Yes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1500,37.950000000000003,39.86,44.79,null,null,null,"No"]
["Name:",null,null,null,"Home Address",null,null,null,null,null,null,null,null,null,1501,70,73.209999999999994,83.53]
["Personnel No",null,null,null,"Work Address",null,null,null,null,null,null,null,null,null,5501,27.55,29.03,32.21]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,25001,21.36,22.23,25.85]
["Car Reg No:",null,null,null,null,"Cubic Capacity : Engine Capacity cc",null,null,"Month"]
["Insurance Expiry Date",null,null,null,null,"Engine Capacity up to 1,200cc"]
[]
["Cost Centre",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Comments"]
[]
["Please submit (a) VEHICLE LICENSING CERTIFICATE - on making first claim or on change of car;   (b)  INSURANCE CERTIFICATE - on making first claim or on renewal of insurance.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5 hours but less than 10 hours",14.01,"No change from 01.10.18"]
["Date Left","Time left","Time Returned","Date Returned","Time away from HQ","Journey",null,"Return Journey","Distance","Subsistence Category","Amounts","Other, Parking, Tolls Receipts attached)","Bus/Train/Taxi/ other (Receipts attached)","Summary of work carried out",null,null,null,null,null,null,null,null,null,null,"10 hours or more",33.61,"No change from 01.10.18"]
[null,"From","To ",null,null,"From ","To","Y/N",{"$f":"D9","v":0},null,"Subsistence","€","€",null,null,null,null,null,null,null,null,null,null,null,"Normal Overnight Rate",147,"Changed from 01.10.2018 (old  €133.73)"]
[null,null,null,null,{"$f":"+C14-B14","v":"00:00:00"},null,null,null,null,null,{"$f":"IF(J14=\"\",0,VLOOKUP(J14,subsall,2,FALSE))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"Vouched Overnight",147,"Changed from 01.10.2018 (old  €133.73)"]
[null,null,null,null,{"$f":"+C15-B15","v":"00:00:00"},null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,"Detention Rate",73.5,"Changed from 01.10.2018 (old  €66.87)"]
[null,null,null,null,"00:00:00",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reduced Overnight Rate",132.30000000000001,"Changed from 01.10.2018 (old  €120.36))"]
[null,null,null,null,"00:00:00",null,null,null,null,null,0]
[null,null,null,null,"00:00:00",null,null,null,null,null,0]
[null,null,null,null,"00:00:00",null,null,null,null,null,0]
[null,null,null,null,"00:00:00",null,null,null,null,null,0]
[null,null,null,null,"00:00:00",null,null,null,null,null,0]
[null,null,null,null,"00:00:00",null,null,null,null,null,0]
[null,null,null,null,"00:00:00",null,null,null,null,null,0]
[null,null,null,null,"00:00:00",null,null,null,null,null,0]
[null,null,null,null,"00:00:00",null,null,null,null,null,0]
[null,null,null,null,"00:00:00",null,null,null,null,null,0]
[null,null,null,null,"00:00:00",null,null,null,null,null,0]
[null,null,null,null,"00:00:00",null,null,null,null,null,0]
[null,null,null,null,{"$f":"SUM(E14:E28)","v":"00:00:00"},null,"Totals:",null,{"$f":"SUM(I14:I28)","v":0},null,{"$f":"SUM(K14:K28)","v":0},{"$f":"SUM(L14:L28)","v":0},{"$f":"SUM(M14:M28)","v":0}]
[]
[null,null,"Official motor travel in a calendar year",0,"in Kms",null,null,"Certification "]
[null,null,"Year to date subsistence claims ",0,null,null,null,"     I certify that (a) the allowances claimed in this account are in strict accordance with the scales sanctioned; (b) the expenses "]
[null,null,"Year to date other travel costs claimed",0,null,null,null,"     charged have been actually and necessarily disbursed solely in relation to the public service on which I am engaged, and"]
[null,null,"Totals for this Claim:",null,null,null,null,"     (c) the particulars furnished herein are in all respects true."]
[null,"Total Subsistence claimed",null,{"$f":"K29","v":0},"do not edit/insert values"]
[null,"Total Mileage Claimed",null,0,"do not edit/insert values",null,null,"     Signed:   .........……………………….",null,null,"Date:…..………………..",null,"Phone : ………………………………"]
[null,"Total Parking Tolls Claimed",null,{"$f":"L29","v":0},"do not edit/insert values",null,null,null,"Claimant"]
[null,"Bus/Train/Taxi/Other Claimed",null,{"$f":"M29","v":0},"do not edit/insert values",null,null,"     I hereby certify that I have examined this claim for expenses; I am satisfied that the journeys set out were necessarily  "]
[null,null,null,null,null,null,null,"     performed in the discharge of the officer's duties and that the mileages shown are correct."]
[null,null,"Overall total",{"$f":"IF(D31=\"\",\"Error please check 'Official motor travel in a calander year'\",SUM(D35:D38))","v":0}]
[null,null,null,null,null,null,null,"     Signed: ……………………………………………………………………..",null,null,"Date:…..………………..",null,"Initals (Block Capitals) …………………"]
[null,"Number of Kms",null,{"$f":"I29","v":0},null,null,null,null,"Certifying Officer"]
[null,"Rate",null,null,"Cent per Km",null,null,"     (c) the particulars furnished herein are in all respects true."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Engine Capacity up to 1,200cc"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Engine Capacity 1,201cc to 1,500cc"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Engine Capacity 1,501cc and over"]