{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Expense Form","Sample"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":4,"comments":0,"pivot_tables":2},"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":"Expense Form","index":0,"n_rows":34,"n_cols":11,"rows_kept":34,"cut":false,"hidden":false,"merged":[[24,1,24,4],[17,1,17,4],[18,1,18,4],[19,1,19,4],[0,2,0,10],[25,1,25,4],[17,6,17,9],[19,6,19,9],[18,6,18,9],[21,6,22,9],[24,6,24,9],[20,6,20,9],[23,6,23,9],[25,6,25,9],[20,1,20,4],[21,1,22,4],[23,1,23,4]]}
[null,null,"Valard Business Expense Claim Form"]
[]
["Date\nmm/dd/yyyy","Payee","Description","Job / Business Unit #","Cost Type / Object Acct","Cost Code\n(Req’d for jobs only)","JDE Work Order\n(if applicable)","Net Expense","GST/ HST","PST","Total Invoice Amount"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Employee Name (First, Middle, and Last Name)",null,null,null,null,"Approver's Name (First, Middle, and Last Name)"]
[]
[null,"JDE Employee Number",null,null,null,null,"Approver's JDE Employee Number"]
[]
[]
[null,"Employee Signature",null,null,null,null,"Approver's Signature"]
[]
[null,"Date (mm/dd/yyyy)",null,null,null,null,"Date (mm/dd/yyyy)"]
[]
[]
[]
["Job / Business Unit #","Cost Type / Object Acct","Cost Code","JDE Work Order","Sum of PST","Sum of Net Expense"]
["(blank)","(blank)","(blank)","(blank)",null,549.92999999999995,null,"Total Net Expense",{"$f":"SUBTOTAL(9,H12)","v":0}]
["(blank) Total",null,null,null,null,549.92999999999995,null,"Total GST / HST",{"$f":"SUBTOTAL(9,I12)","v":0}]
["Grand Total",null,null,null,null,549.92999999999995,null,"Total PST",{"$f":"J12","v":0}]
[null,null,null,null,null,null,null,"Total",{"$f":"SUM(I31:I32)","v":0}]

{"sheet":"Sample","index":1,"n_rows":40,"n_cols":11,"rows_kept":40,"cut":false,"hidden":false,"merged":[[26,1,26,4],[26,6,26,9],[27,1,27,4],[27,6,27,9],[22,1,22,4],[22,6,22,9],[23,1,24,4],[23,6,24,9],[25,1,25,4],[25,6,25,9],[21,1,21,4],[21,6,21,9],[0,2,0,10],[19,1,19,4],[19,6,19,9],[20,1,20,4],[20,6,20,9]]}
[null,null,"Valard Business Expense Claim Form"]
[]
["Date\nmm/dd/yyyy","Payee","Description","Job / Business Unit #","Cost Type / Object Acct","Cost Code\n(Req’d for jobs only)\n","JDE Work Order\n(if applicable)","Net Expense","GST/ HST","PST","Total Invoice Amount"]
["2019-09-20","Acklands Grainger","10mm Bolts - urgent Item","67759025908","531100","22411000",960360,81.36,4.07,null,{"$f":"SUM(Table16[[#This Row],[Net Expense]:[PST]])","v":85.43}]
["2019-09-22","Co-Op","Gasoline for truck","67537710","641210",null,null,60,3,null,{"$f":"SUM(Table16[[#This Row],[Net Expense]:[PST]])","v":63}]
["2019-09-24","Staples","Plotter Paper ","67797140","731100",null,null,150,7.5,null,{"$f":"SUM(Table16[[#This Row],[Net Expense]:[PST]])","v":157.5}]
["2019-09-20","Acklands Grainger","10mm Bolts - urgent Item","67759025908","531100","22411000","950001",81.36,4.07,null,{"$f":"SUM(Table16[[#This Row],[Net Expense]:[PST]])","v":85.43}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table16[[#This Row],[Net Expense]:[PST]])","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table16[[#This Row],[Net Expense]:[PST]])","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table16[[#This Row],[Net Expense]:[PST]])","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table16[[#This Row],[Net Expense]:[PST]])","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table16[[#This Row],[Net Expense]:[PST]])","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table16[[#This Row],[Net Expense]:[PST]])","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table16[[#This Row],[Net Expense]:[PST]])","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table16[[#This Row],[Net Expense]:[PST]])","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table16[[#This Row],[Net Expense]:[PST]])","v":0}]
[null,null,null,null,null,null,"Total",{"$f":"SUM(H4:H17)","v":372.72},{"$f":"SUM(I4:I17)","v":18.64},{"$f":"SUM(J4:J17)","v":0},{"$f":"SUM(K4:K17)","v":391.36}]
[]
[null,"JANE ANN DOE"]
[null,"Employee Name (First, Middle, and Last Name)",null,null,null,null,"Approver's Name (First, Middle, and Last Name)"]
[null,123456]
[null,"JDE Employee Number",null,null,null,null,"Approver's JDE Employee Number"]
[]
[]
[null,"Employee Signature",null,null,null,null,"Approver's Signature"]
[null,"2019-10-09"]
[null,"Date (mm/dd/yyyy)",null,null,null,null,"Date (mm/dd/yyyy)"]
[]
[]
[]
["Job / Business Unit #","Cost Type / Object Acct","Cost Code","JDE Work Order","Sum of PST","Sum of Net Expense"]
["67759025908","531100","22411000",960360,null,81.36,null,"Total Net Expense",{"$f":"SUBTOTAL(9,H18)","v":372.72}]
["67759025908","531100","22411000","950001",null,81.36,null,"Total GST / HST",{"$f":"SUBTOTAL(9,I18)","v":18.64}]
["67759025908","531100","22411000 Total",null,null,162.72,null,"Total PST",{"$f":"J18","v":0}]
["67537710","641210","(blank)","(blank)",null,60,null,"Total",{"$f":"SUM(I33:I34)","v":391.36}]
["67537710","641210","(blank) Total",null,null,60]
["67797140","731100","(blank)","(blank)",null,150]
["67797140","731100","(blank) Total",null,null,150]
["Grand Total",null,null,null,null,372.72]