{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Candidate Travel","E X A M P L E"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"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":"Candidate Travel","index":0,"n_rows":48,"n_cols":9,"rows_kept":48,"cut":false,"hidden":false,"merged":[[15,1,25,1],[1,0,1,8],[13,3,14,7]]}
[]
["CANDIDATE TRAVEL EXPENSES"]
[]
["candidate complete name"]
["candidate home street"]
["candidate city, state, zip"]
["SSN"]
["J"]
[]
["Candidate for "]
["mm/dd/yy-mm/dd/yy"]
[]
["Description","Mileage","Mileage Rate","Prepayments","2018-05-01","2018-05-02","2018-05-03","2018-05-04","Total"]
["Mileage from home/airport to JCC",null,0.57999999999999996,null,null,null,null,null,{"$f":"ROUND(B14*C14,2)","v":0}]
["Mileage from JCC to home/airport",null,0.57999999999999996,null,null,null,null,null,{"$f":"ROUND(B15*C15,2)","v":0}]
["Taxi to/from airport",null,null,null,null,null,null,null,{"$f":"SUM(E16:H16)","v":0}]
["Airfare ",null,null,null,null,null,null,null,{"$f":"SUM(E17:H17)","v":0}]
["Tolls - NYS Thruway",null,null,null,null,null,null,null,{"$f":"SUM(E18:H18)","v":0}]
["Rental Car",null,null,null,null,null,null,null,{"$f":"SUM(E19:H19)","v":0}]
["Gasoline for Rental Car",null,null,null,null,null,null,null,{"$f":"SUM(E20:H20)","v":0}]
["Hotel ",null,null,null,null,null,null,null,{"$f":"SUM(E21:H21)","v":0}]
["Hotel "]
["Meal",null,null,null,null,null,null,null,{"$f":"SUM(E23:H23)","v":0}]
["Meal",null,null,null,null,null,null,null,{"$f":"SUM(E24:H24)","v":0}]
["Meal",null,null,null,null,null,null,null,{"$f":"SUM(E25:H25)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(E26:H26)","v":0}]
[null,{"$f":"SUM(B14:B26)","v":0},null,null,null,"Total expenses",null,null,{"$f":"SUM(I14:I26)","v":0}]
[null,null,null,null,null,"100% of first $500",null,null,{"$f":"IF(I27<500,I27,500)","v":0}]
[null,null,null,null,null,"50% of remaining expenses",null,null,{"$f":"(I27-I28)*0.5","v":0}]
[null,null,null,null,null,"Covered expenses",null,null,{"$f":"SUM(I28:I29)","v":0}]
[]
[null,null,null,null,null,"LESS: JCC Paid AmEx - Airfare",null,null,0]
[null,null,null,null,null,"LESS: JCC Paid AmEx - Hotel",null,null,0]
[null,null,null,null,null,"Balance owed to EE",null,null,{"$f":"I30-I32-I33","v":0}]
[]
[null,null,null,null,null,"HR Candidate Travel",null,"1000-1714-7412",{"$f":"I34","v":0}]
[]
[]
["NYS Hotel tax is not reimbursed.  Use a NYS ST-129 Form."]
["Attach IRS W9 form."]
["Attach original receipts for all expenses, including those paid by JCC credit card."]
[]
["Approval by Chair of Search Committee:"]
[]
[]
[]
[]
["Approval by Director of Human Resources:"]

{"sheet":"E X A M P L E","index":1,"n_rows":47,"n_cols":8,"rows_kept":47,"cut":false,"hidden":false,"merged":[[1,0,1,7],[13,3,13,6],[14,3,14,6]]}
[]
["CANDIDATE TRAVEL EXPENSES"]
[]
["Jane Doe"]
["123 Main St"]
["Anytown, CA 12345"]
["123-45-6789"]
["J"]
[]
["Candidate for Chemistry Instuctor"]
["05/01/18-05/02/18"]
[]
["Description","Mileage","Mileage Rate","2018-05-01","2018-05-02","2018-05-03","2018-05-04","Total"]
["Mileage from home/airport to JCC",30,0.57999999999999996,null,null,null,null,{"$f":"ROUND(B14*C14,2)","v":17.399999999999999}]
["Mileage from JCC to home/airport",30,0.57999999999999996,null,null,null,null,{"$f":"ROUND(B15*C15,2)","v":17.399999999999999}]
["Taxi to/from airport",0,null,null,null,null,null,{"$f":"SUM(D16:G16)","v":0}]
["Airfare -",null,null,401.7,null,null,null,{"$f":"SUM(D17:G17)","v":401.7}]
["Tolls - NYS Thruway",0,null,null,3.6,null,null,{"$f":"SUM(D18:G18)","v":3.6}]
["Rental Car",null,null,null,67,null,null,{"$f":"SUM(D19:G19)","v":67}]
["Gasoline for Rental Car",null,null,null,15,null,null,{"$f":"SUM(D20:G20)","v":15}]
["Hotel - Comfort Inn Jamestown",0,null,84,null,null,null,{"$f":"SUM(D21:G21)","v":84}]
["Meals",0,null,25,null,null,null,{"$f":"SUM(D22:G22)","v":25}]
[" ",null,null,null,null,null,null,{"$f":"SUM(D23:G23)","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(D24:G24)","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(D25:G25)","v":0}]
[null,{"$f":"SUM(B14:B25)","v":60},null,null,"Total expenses",null,null,{"$f":"SUM(H14:H25)","v":631.1}]
[null,null,null,null,"100% of first $500",null,null,{"$f":"IF(H26<500,H26,500)","v":500}]
[null,null,null,null,"50% of remaining expenses",null,null,{"$f":"(H26-H27)*0.5","v":65.550000000000011}]
[null,null,null,null,"Covered expenses",null,null,{"$f":"SUM(H27:H28)","v":565.54999999999995}]
[]
[null,null,null,null,"LESS: JCC Paid AmEx - Airfare",null,null,0]
[null,null,null,null,"LESS: JCC Paid AmEx - Hotel",null,null,84]
[null,null,null,null,"Balance owed to EE",null,null,{"$f":"H29-H31-H32","v":481.54999999999995}]
[]
[null,null,null,null,"HR Candidate Travel",null,"1000-1714-7412",{"$f":"H33","v":481.54999999999995}]
[]
[]
["NYS Hotel tax is not reimbursed.  Use a NYS ST-129 Form."]
["Attach IRS W9 form."]
["Attach original receipts for all expenses, including those paid by JCC credit card."]
[]
["Approval by Chair of Search Committee:"]
[]
[]
[]
[]
["Approval by Director of Human Resources:"]