{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["travel accounting form","per diems","Ark3"],"not_rendered":{"images":2},"read":"whole","date_system":"1900"}

{"sheet":"travel accounting form","index":0,"n_rows":80,"n_cols":11,"rows_kept":80,"merged":[[0,0,0,10],[1,0,1,10],[2,0,2,10],[4,9,4,10],[11,5,11,7],[12,5,12,7]]}
["FIG Travel Accounting Form"]
["This form can be found electronically on FIG Web site in the most recent version:"]
["http://fig.net/about/office/index.asp"]
[]
["General information",{"$nulls":8},"Updated: 17-01-2023"]
["Name: ",{"$nulls":3},"Position: "]
["Visit to: ",{"$nulls":3},"Departure date & time: *"]
["Purpose: ",{"$nulls":3},"Return date & time*:"]
[{"$nulls":4},"*Please state dates and times for correct per diem calculation"]
["Expenses:"]
["Column no."]
[1,null,2,3,4,5,null,null,6,7,8]
[{"$nulls":5},"Paid by FIG credit card (amount)",null,null,"Paid with own cash or creditcard (amount):"]
["Topic",null,"Description","Date","Voucher#","Amount","Currency",null,"Amount","Currency","Amount in EUR"]
["Airfares:"]
[]
[]
[]
[]
["Use of own car:"]
["3,73 DKK per km"]
[]
[]
["Local transport:"]
[]
[]
[]
[]
["Accommodation:"]
[]
[]
[]
[]
["Entertainment:"]
[]
[]
[]
["Other reimbursable "]
["expenses (not  "]
["covered by per diems):"]
[]
[]
[null,null,"Total by FIG card",null,null,{"$f":"SUM(F15:F42)","v":{"v":0,"d":"0.00"}},null,{"$f":"SUM(H15:H42)","v":{"v":0,"d":"€ 0.00"}}]
["TOTAL cash EUR",{"$nulls":9},{"$f":"SUM(K15:K43)","v":{"v":0,"d":"€ 0.00"}}]
["TOTAL cash currency",{"$nulls":7},{"$f":"SUM(I15:I43)","v":{"v":0,"d":"0.00"}}]
["Total Per Diems",{"$nulls":7},{"$f":"C57","v":{"v":0,"d":"DKK 0.00"}},null,{"$f":"I46/7.44","v":{"v":0,"d":"€ 0.00"}}]
["Total to be paid by FIG",{"$nulls":9},{"$f":"SUM(K44:K46)","v":{"v":0,"d":"€ 0.00"}}]
[]
["Per Diems:"]
["Days:","      @"]
[null,{"$f":"K57","v":{"v":555,"d":"555.00"}},{"$f":"A51*B51","v":{"v":0,"d":"DKK 0.00"}}]
[null,{"$f":"K58","v":471.75},{"$f":"A52*B52","v":{"v":0,"d":"DKK 0.00"}}]
[null,{"$f":"K59","v":{"v":388.5,"d":"388.50"}},{"$f":"A53*B53","v":{"v":0,"d":"DKK 0.00"}}]
[null,{"$f":"K61","v":305.25},{"v":0,"d":"DKK 0.00"}]
[null,{"$f":"K63","v":{"v":222,"d":"222.00"}},{"v":0,"d":"DKK 0.00"}]
[null,{"$f":"K64","v":138.75},{"v":0,"d":"DKK 0.00"},null,{"$f":"'per diems'!A1","v":"Category"},{"$f":"'per diems'!B1","v":"Meals provided        "},{"$f":"'per diems'!C1","v":"Meals bought "},null,{"$f":"'per diems'!E1","v":"Deduction"},{"$f":"'per diems'!F1","v":"Deduction amount"},{"$f":"'per diems'!G1","v":"Per diem "}]
[{"$f":"SUM(A51:A56)","v":0},null,{"$f":"SUM(C51:C56)","v":{"v":0,"d":"DKK 0.00"}},null,{"$f":"'per diems'!A2","v":1},{"$f":"'per diems'!B2","v":"None"},{"$f":"'per diems'!C2","v":"Breakfast + lunch + dinner "},null,{"$f":"'per diems'!E2","v":{"v":0,"d":"0%"}},{"$f":"'per diems'!F2","v":{"v":0,"d":"0.00"}},{"$f":"'per diems'!G2","v":{"v":555,"d":"555.00"}}]
[{"$nulls":4},{"$f":"'per diems'!A3","v":2},{"$f":"'per diems'!B3","v":"Breakfast"},{"$f":"'per diems'!C3","v":"Lunch + dinner"},null,{"$f":"'per diems'!E3","v":{"v":0.15,"d":"15%"}},{"$f":"'per diems'!F3","v":83.25},{"$f":"'per diems'!G3","v":471.75}]
[{"$nulls":4},{"$f":"'per diems'!A4","v":3},{"$f":"'per diems'!B4","v":"Lunch"},{"$f":"'per diems'!C4","v":"Breakfast + dinner"},null,{"$f":"'per diems'!E4","v":{"v":0.3,"d":"30%"}},{"$f":"'per diems'!F4","v":{"v":166.5,"d":"166.50"}},{"$f":"'per diems'!G4","v":{"v":388.5,"d":"388.50"}}]
[{"$nulls":4},{"$f":"'per diems'!A5","v":4},{"$f":"'per diems'!B5","v":"Dinner"},{"$f":"'per diems'!C5","v":"Breakfast + lunch"},null,{"$f":"'per diems'!E5","v":{"v":0.3,"d":"30%"}},{"$f":"'per diems'!F5","v":{"v":166.5,"d":"166.50"}},{"$f":"'per diems'!G5","v":{"v":388.5,"d":"388.50"}}]
["Account information:",{"$nulls":3},{"$f":"'per diems'!A6","v":5},{"$f":"'per diems'!B6","v":"Breakfast + lunch"},{"$f":"'per diems'!C6","v":"Dinner"},null,{"$f":"'per diems'!E6","v":{"v":0.45,"d":"45%"}},{"$f":"'per diems'!F6","v":249.75},{"$f":"'per diems'!G6","v":305.25}]
["Bank:",{"$nulls":3},{"$f":"'per diems'!A7","v":6},{"$f":"'per diems'!B7","v":"Breakfast + dinner"},{"$f":"'per diems'!C7","v":"Lunch"},null,{"$f":"'per diems'!E7","v":{"v":0.45,"d":"45%"}},{"$f":"'per diems'!F7","v":249.75},{"$f":"'per diems'!G7","v":305.25}]
[{"$nulls":4},{"$f":"'per diems'!A8","v":7},{"$f":"'per diems'!B8","v":"Lunch + dinner"},{"$f":"'per diems'!C8","v":"Breakfast"},null,{"$f":"'per diems'!E8","v":{"v":0.6,"d":"60%"}},{"$f":"'per diems'!F8","v":{"v":333,"d":"333.00"}},{"$f":"'per diems'!G8","v":{"v":222,"d":"222.00"}}]
["Branch:",{"$nulls":3},{"$f":"'per diems'!A9","v":8},{"$f":"'per diems'!B9","v":"Breakfast + lunch + dinner "},{"$f":"'per diems'!C9","v":"None"},null,{"$f":"'per diems'!E9","v":{"v":0.75,"d":"75%"}},{"$f":"'per diems'!F9","v":416.25},{"$f":"'per diems'!G9","v":138.75}]
[]
["Account no./IBAN: "]
[]
["Name of account:"]
[]
["SWIFT Code: "]
[]
["Name of account "]
["holder:"]
[]
[]
[]
["Signature:",{"$nulls":4},"FIG payment"]
[{"$nulls":5},"authorisation:"]
[]
["Date:",{"$nulls":4},"Date:"]

{"sheet":"per diems","index":1,"n_rows":11,"n_cols":7,"rows_kept":11,"merged":[[0,2,0,3],[1,2,1,3],[2,2,2,3],[3,2,3,3],[4,2,4,3],[5,2,5,3],[6,2,6,3],[7,2,7,3],[8,2,8,3]]}
["Category","Meals provided        ","Meals bought ",null,"Deduction","Deduction amount","Per diem "]
[1,"None","Breakfast + lunch + dinner ",null,{"v":0,"d":"0%"},{"v":0,"d":"0.00"},{"v":555,"d":"555.00"}]
[2,"Breakfast","Lunch + dinner",null,{"v":0.15,"d":"15%"},{"$f":"G2*E3","v":83.25},{"$f":"G2-F3","v":471.75}]
[3,"Lunch","Breakfast + dinner",null,{"v":0.3,"d":"30%"},{"$f":"G2*E4","v":{"v":166.5,"d":"166.50"}},{"$f":"G2-F4","v":{"v":388.5,"d":"388.50"}}]
[4,"Dinner","Breakfast + lunch",null,{"v":0.3,"d":"30%"},{"$f":"G2*E5","v":{"v":166.5,"d":"166.50"}},{"$f":"G2-F5","v":{"v":388.5,"d":"388.50"}}]
[5,"Breakfast + lunch","Dinner",null,{"v":0.45,"d":"45%"},{"$f":"G2*E6","v":249.75},{"$f":"G2-F7","v":305.25}]
[6,"Breakfast + dinner","Lunch",null,{"v":0.45,"d":"45%"},{"$f":"G2*E7","v":249.75},{"$f":"G2-F7","v":305.25}]
[7,"Lunch + dinner","Breakfast",null,{"v":0.6,"d":"60%"},{"$f":"G2*E8","v":{"v":333,"d":"333.00"}},{"$f":"G2-F8","v":{"v":222,"d":"222.00"}}]
[8,"Breakfast + lunch + dinner ","None",null,{"v":0.75,"d":"75%"},{"$f":"G2*E9","v":416.25},{"$f":"G2-F9","v":138.75}]
[]
[null,"Accommodation",{"$nulls":4},238]

{"sheet":"Ark3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0}