{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Voucher","One Dept Mileage Detail","Multiple Dept Mileage Detail","Formulas"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":"Voucher","index":0,"n_rows":46,"n_cols":11,"rows_kept":46,"cut":false,"hidden":false,"merged":[[0,0,0,6],[37,4,37,6],[3,3,3,4]]}
["HILLTOP COMMUNITY RESOURCES, INC.",null,null,null,null,null,null,"See Instructions -------->",null,null,"Instructions"]
["EXPENSE VOUCHER",null,null,null,null,null,null,null,null,null,"Please Click \"Enable Editing & Content\" for this spreadsheet to work."]
[]
["Employee:",null,"Home Dept",null,null,"Date:",null,null,null,null,"If you are using mileage for only one department click \"One Dept. Mileage\" Then"]
[null,null,null,null,null,null,null,null,null,null,"Fill out information on the \"One Dept Mileage Detail\" Tab"]
[]
[null,null,null,null,null,"Mileage",null,null,null,null,"If you are claiming mileage for multiple departments click \"Multiple Dept.\" then"]
["Date","Description of Expense","Dept #","Acct #","Miles","Rate","Total",null,null,null,"Fill out information on the \"Multiple Dept Mileage Detail\" Tab"]
[null,null,null,null,null,{"$f":"IF(E9=0,\"\", 0.48)","v":""}]
[null,null,null,null,null,{"$f":"IF(E10=0,\"\", 0.48)","v":""},null,null,null,null,"To Reset this form."]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,{"$f":"IF(E13=\"\",\"\",0.48)","v":""}]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,{"$f":"IF(E16=\"\",\"\",0.48)","v":""}]
[null,null,null,null,null,{"$f":"IF(E17=\"\",\"\",0.48)","v":""}]
[null,null,null,null,null,{"$f":"IF(E18=\"\",\"\",0.48)","v":""}]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,{"$f":"IF(E21=\"\",\"\",0.48)","v":""}]
[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,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,null,null,null,null,""]
[null,null,null,"TOTAL EXPENSES",null,null,{"$f":"IF(SUM(G9:G33)=0,\"\",SUM(G9:G33))","v":""}]
["ALL COSTS NEED ATTACHED RECEIPTS"]
["MILEAGE RATE = $0.48/mile",null,null,"Accounting approval:"]
[]
[null,null,null,null,"SUMMARY"]
[null,null,null,null,"Dept. #","Acct. #","Amount",null,null,null,"Once you are done filling out the voucher please click this button to summarize"]
["Employee Signature",null,null,null,null,null,{"$f":"IF(E40=\"\",\"\",SUMIF(Formulas!$E$17:$E$41,Voucher!E40,Formulas!$H$17:$H$41))","v":""},null,null,null,"Accounts and amounts.  If you have more than 7 accounts you will need to add the"]
[null,null,null,null,null,null,{"$f":"IF(E41=\"\",\"\",SUMIF(Formulas!$E$17:$E$41,Voucher!E41,Formulas!$H$17:$H$41))","v":""},null,null,null,"Others manually."]
[null,null,null,null,null,null,{"$f":"IF(E42=\"\",\"\",SUMIF(Formulas!$E$17:$E$41,Voucher!E42,Formulas!$H$17:$H$41))","v":""}]
["Supervisor Signature",null,null,null,null,null,{"$f":"IF(E43=\"\",\"\",SUMIF(Formulas!$E$17:$E$41,Voucher!E43,Formulas!$H$17:$H$41))","v":""},null,null,null,"Print, Sign and forward this sheet along with documentation, and detailed Mileage tabs "]
[null,null,null,null,null,null,{"$f":"IF(E44=\"\",\"\",SUMIF(Formulas!$E$17:$E$41,Voucher!E44,Formulas!$H$17:$H$41))","v":""},null,null,null,"(if you used them) to your supervisor.  Following approval, the Supervisor then sends to "]
[null,null,null,null,null,null,{"$f":"IF(E45=\"\",\"\",SUMIF(Formulas!$E$17:$E$41,Voucher!E45,Formulas!$H$17:$H$41))","v":""},null,null,null,"Accounts Payable for payment."]
[null,null,null,null,null,null,{"$f":"IF(E46=\"\",\"\",SUMIF(Formulas!$E$17:$E$41,Voucher!E46,Formulas!$H$17:$H$41))","v":""}]

{"sheet":"One Dept Mileage Detail","index":1,"n_rows":42,"n_cols":7,"rows_kept":42,"cut":false,"hidden":false,"merged":[[20,1,20,5],[4,5,4,6],[14,1,14,5],[15,1,15,5],[16,1,16,5],[12,1,12,5],[7,1,7,4],[8,1,8,5],[9,1,9,5],[10,1,10,5],[11,1,11,5],[13,1,13,5],[17,1,17,5],[18,1,18,5],[19,1,19,5],[28,1,28,5],[29,1,29,5],[36,1,36,5],[30,1,30,5],[31,1,31,5],[38,1,38,5],[39,1,39,5],[25,1,25,5],[0,0,0,6],[1,0,1,6],[32,1,32,5],[33,1,33,5],[34,1,34,5],[35,1,35,5],[21,1,21,5],[22,1,22,5],[37,1,37,5],[23,1,23,5],[24,1,24,5],[26,1,26,5],[27,1,27,5]]}
["HILLTOP "]
["EXPENSE VOUCHER MILEAGE DETAIL - Automatically Updates"]
[]
[null,null,null,null,"Month /"]
["Employee:",{"$f":"IF(Voucher!B4=\"\",\"\",Voucher!B4)","v":""},"Department",{"$f":"IF(Voucher!D4=\"\",\"\",Voucher!D4)","v":""},"Year",{"$f":"IF(Voucher!G4=\"\",Formulas!$K$1,Voucher!$G$4)","v":"2018-01-18T09:52:55.940"}]
[]
[]
["Date","Purpose",null,null,null,null,"Miles"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Total Miles ",null,{"$f":"SUM(G9:G40)","v":0}]
["Note:","Click on the One Department Mileage Button "]

{"sheet":"Multiple Dept Mileage Detail","index":2,"n_rows":41,"n_cols":8,"rows_kept":41,"cut":false,"hidden":false,"merged":[[17,1,17,6],[24,1,24,6],[19,1,19,6],[21,1,21,6],[23,1,23,6],[11,1,11,6],[12,1,12,6],[13,1,13,6],[15,1,15,6],[16,1,16,6],[0,0,0,7],[1,0,1,7],[22,2,22,5],[30,2,30,5],[6,1,6,5],[7,1,7,6],[8,1,8,6],[9,1,9,6],[10,1,10,6],[18,1,18,6],[4,3,4,4],[25,1,25,6],[26,1,26,6],[27,1,27,6],[4,6,4,7],[14,2,14,5],[38,2,38,5],[20,1,20,6],[29,1,29,6],[35,1,35,6],[36,1,36,6],[37,1,37,6],[32,1,32,6],[33,1,33,6],[34,1,34,6],[31,1,31,6],[28,1,28,6]]}
["HILLTOP "]
["EXPENSE VOUCHER MILEAGE DETAIL - Multiple Departments"]
[]
[null,null,null,null,null,"Month /"]
["Employee:",{"$f":"IF(Voucher!B4=\"\",\"\",Voucher!B4)","v":""},"Department",{"$f":"IF(Voucher!D4=\"\",\"\",Voucher!D4)","v":""},null,"Year",{"$f":"IF(Voucher!H4=\"\",Formulas!$K$1,Voucher!$G$4)","v":"2018-01-18T09:52:55.940"}]
[]
["Date","Purpose",null,null,null,null,null,"Miles"]
[]
[]
[]
[]
[]
[]
[]
[null,"Charges above for department:",null,null,null,null,"TOTAL",{"$f":"SUM(H8:H14)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[null,"Charges above for department:",null,null,null,null,"TOTAL",{"$f":"SUM(H16:H22)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[null,"Charges above for department:",null,null,null,null,"TOTAL",{"$f":"SUM(H24:H30)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[null,"Charges above for department:",null,null,null,null,"TOTAL",{"$f":"SUM(H32:H38)","v":0}]
[]
["Note:","Please click on the Multiple Department Mileage Button on the Voucher"]

{"sheet":"Formulas","index":3,"n_rows":41,"n_cols":11,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
["For One Department",null,null,null,null,null,null,null,null,"Date",{"$f":"NOW()","v":"2018-01-18T09:52:55.940"}]
["Date","Description of Expense","Dept #","Acct #","Miles","Rate","Total"]
[null,"Automatic summary from mileage detail sheet.",{"$f":"IF('One Dept Mileage Detail'!$D$5=\"\",\"\",'One Dept Mileage Detail'!$D$5)","v":""},6200,{"$f":"'One Dept Mileage Detail'!$G$41","v":0},{"$f":"IF(E3=0,\"\", 0.48)","v":""},{"$f":"IF(F3=\"\",F3,ROUND(E3*F3,2))","v":""}]
[null,null,null,null,null,{"$f":"IF(E4=\"\",\"\",0.48)","v":""},{"$f":"IF(E4=\"\",F4,ROUND(E4*F4,2))","v":""}]
[null,null,null,null,null,"",{"$f":"IF(E5=\"\",F5,ROUND(E5*F5,2))","v":""}]
[null,null,null,null,null,"",{"$f":"IF(E6=\"\",F6,ROUND(E6*F6,2))","v":""}]
[]
["For Multiple Departments"]
["Date","Description of Expense","Dept #","Acct #","Miles","Rate","Total"]
[null,"Automatic summary from mileage detail sheet.",{"$f":"IF('Multiple Dept Mileage Detail'!$C$15=\"\",\"\",'Multiple Dept Mileage Detail'!$C$15)","v":""},6200,{"$f":"'Multiple Dept Mileage Detail'!$H$15","v":0},{"$f":"IF(E10=0,\"\", 0.48)","v":""},{"$f":"IF(F10=\"\",F10,ROUND(E10*F10,2))","v":""}]
[null,"Automatic summary from mileage detail sheet.",{"$f":"IF('Multiple Dept Mileage Detail'!$C$23=\"\",\"\",'Multiple Dept Mileage Detail'!$C$23)","v":""},6200,{"$f":"'Multiple Dept Mileage Detail'!$H$23","v":0},{"$f":"IF(E11=0,\"\", 0.48)","v":""},{"$f":"IF(F11=\"\",F11,ROUND(E11*F11,2))","v":""}]
[null,"Automatic summary from mileage detail sheet.",{"$f":"IF('Multiple Dept Mileage Detail'!$C$31=\"\",\"\",'Multiple Dept Mileage Detail'!$C$31)","v":""},6200,{"$f":"'Multiple Dept Mileage Detail'!$H$31","v":0},"",""]
[null,"Automatic summary from mileage detail sheet.",{"$f":"IF('Multiple Dept Mileage Detail'!$C$39=\"\",\"\",'Multiple Dept Mileage Detail'!$C$39)","v":""},6200,{"$f":"'Multiple Dept Mileage Detail'!$H$39","v":0},"",""]
[]
[]
[null,null,"Dept","Acct",null,null,null,"Amounts"]
[null,null,{"$f":"Voucher!C9","v":0},{"$f":"Voucher!D9","v":0},{"$f":"CONCATENATE(C17,\"-\",D17)","v":"0-0"},"0-0",null,{"$f":"Voucher!G9","v":0}]
[null,null,{"$f":"Voucher!C10","v":0},{"$f":"Voucher!D10","v":0},{"$f":"CONCATENATE(C18,\"-\",D18)","v":"0-0"},null,null,{"$f":"Voucher!G10","v":0}]
[null,null,{"$f":"Voucher!C11","v":0},{"$f":"Voucher!D11","v":0},"0-0",null,null,{"$f":"Voucher!G11","v":0}]
[null,null,{"$f":"Voucher!C12","v":0},{"$f":"Voucher!D12","v":0},"0-0",null,null,{"$f":"Voucher!G12","v":0}]
[null,null,{"$f":"Voucher!C13","v":0},{"$f":"Voucher!D13","v":0},"0-0",null,null,{"$f":"Voucher!G13","v":0}]
[null,null,{"$f":"Voucher!C14","v":0},{"$f":"Voucher!D14","v":0},"0-0",null,null,{"$f":"Voucher!G14","v":0}]
[null,null,{"$f":"Voucher!C15","v":0},{"$f":"Voucher!D15","v":0},"0-0",null,null,{"$f":"Voucher!G15","v":0}]
[null,null,{"$f":"Voucher!C16","v":0},{"$f":"Voucher!D16","v":0},"0-0",null,null,{"$f":"Voucher!G16","v":0}]
[null,null,{"$f":"Voucher!C17","v":0},{"$f":"Voucher!D17","v":0},"0-0",null,null,{"$f":"Voucher!G17","v":0}]
[null,null,{"$f":"Voucher!C18","v":0},{"$f":"Voucher!D18","v":0},"0-0",null,null,{"$f":"Voucher!G18","v":0}]
[null,null,{"$f":"Voucher!C19","v":0},{"$f":"Voucher!D19","v":0},"0-0",null,null,{"$f":"Voucher!G19","v":0}]
[null,null,{"$f":"Voucher!C20","v":0},{"$f":"Voucher!D20","v":0},"0-0",null,null,{"$f":"Voucher!G20","v":0}]
[null,null,{"$f":"Voucher!C21","v":0},{"$f":"Voucher!D21","v":0},"0-0",null,null,{"$f":"Voucher!G21","v":0}]
[null,null,{"$f":"Voucher!C22","v":0},{"$f":"Voucher!D22","v":0},"0-0",null,null,{"$f":"Voucher!G22","v":0}]
[null,null,{"$f":"Voucher!C23","v":0},{"$f":"Voucher!D23","v":0},"0-0",null,null,{"$f":"Voucher!G23","v":0}]
[null,null,{"$f":"Voucher!C24","v":0},{"$f":"Voucher!D24","v":0},"0-0",null,null,{"$f":"Voucher!G24","v":0}]
[null,null,{"$f":"Voucher!C25","v":0},{"$f":"Voucher!D25","v":0},"0-0",null,null,{"$f":"Voucher!G25","v":0}]
[null,null,{"$f":"Voucher!C26","v":0},{"$f":"Voucher!D26","v":0},"0-0",null,null,{"$f":"Voucher!G26","v":0}]
[null,null,{"$f":"Voucher!C27","v":0},{"$f":"Voucher!D27","v":0},"0-0",null,null,{"$f":"Voucher!G27","v":0}]
[null,null,{"$f":"Voucher!C28","v":0},{"$f":"Voucher!D28","v":0},"0-0",null,null,{"$f":"Voucher!G28","v":0}]
[null,null,{"$f":"Voucher!C29","v":0},{"$f":"Voucher!D29","v":0},"0-0",null,null,{"$f":"Voucher!G29","v":0}]
[null,null,{"$f":"Voucher!C30","v":0},{"$f":"Voucher!D30","v":0},"0-0",null,null,{"$f":"Voucher!G30","v":0}]
[null,null,{"$f":"Voucher!C31","v":0},{"$f":"Voucher!D31","v":0},"0-0",null,null,{"$f":"Voucher!G31","v":0}]
[null,null,{"$f":"Voucher!C32","v":0},{"$f":"Voucher!D32","v":0},"0-0",null,null,{"$f":"Voucher!G32","v":0}]
[null,null,{"$f":"Voucher!C33","v":0},{"$f":"Voucher!D33","v":0},"0-0",null,null,{"$f":"Voucher!G33","v":0}]