{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Instructions","Voucher","Voucher 2","EntertainmentHosting","Missing Receipt","-","- (2)"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":5,"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":"Instructions","index":0,"n_rows":49,"n_cols":4,"rows_kept":49,"cut":false,"hidden":false,"merged":[[1,0,1,5],[0,0,0,5],[34,0,34,5],[25,0,25,5],[17,0,17,5],[4,0,4,5],[6,0,6,5],[7,0,7,5],[18,0,18,5],[26,0,26,5],[29,2,29,5],[23,0,23,2],[24,0,24,2],[30,2,30,5],[32,0,32,1],[33,0,33,1],[48,0,48,5],[45,0,45,5],[37,0,37,5],[35,0,35,5],[36,0,36,5],[46,0,46,5],[47,0,47,5],[42,0,42,1],[43,0,43,1],[44,0,44,1],[43,2,43,5],[44,2,44,5],[38,0,38,1],[39,0,39,1],[40,0,40,1],[41,0,41,1],[42,2,42,5],[40,2,40,5],[41,2,41,5],[38,2,38,5],[2,0,2,5],[3,0,3,5],[5,0,5,5],[27,0,27,5],[21,3,21,5],[23,3,23,5],[22,3,22,5],[8,3,8,5],[9,3,9,5],[10,3,10,5],[39,2,39,5],[28,2,28,5],[32,2,32,5],[33,2,33,5],[11,0,12,0],[11,1,12,1],[12,3,12,5],[13,3,13,5],[14,3,14,5],[31,2,31,5],[24,3,24,5],[28,0,28,1],[11,3,11,5],[31,0,31,1],[29,0,29,1],[30,0,30,1],[19,0,19,2],[15,3,15,5],[16,3,16,5],[21,0,21,2],[20,0,20,2],[22,0,22,1],[19,3,19,5],[20,3,20,5]]}
["Central Michigan University Employee Reimbursement Instructions"]
["A - CONTACT"]
["Enter identification information (employee name, campus ID number, office address, phone number, department name)."]
["Officially working out of home: If you permanently work from home, check the box."]
["B – DAILY TRAVEL EXPENSES"]
["Enter each date of travel where daily expenses occurred.  If there are more than seven days, use more than one voucher and submit together."]
["Enter the departure and return times under the applicable dates."]
["Circle all meals claimed for each day.  If individual travel meals are claimed without an overnight stay, the meals will be taxable.  If the overnight stay was free of charge, indicate where you stayed to avoid taxation of meals."]
[null,"Expense","Reimbursement Rate","Documentation"]
[1,"Employee Travel Meals","Per diem","No receipt required"]
[2,"Lodging","Actual cost (single rate)","Original itemized receipt required"]
[3,"Lodging Tips","Baggage $10.00 first and last day","No receipt required"]
[null,null,"Housekeeping $5.00 each night"]
[4,"Taxi, Bus","Lowest possible cost","Original itemized receipt required"]
[5,"Parking, Tolls","Actual cost","Original itemized receipt required"]
[6,"Rental Car Expense","Actual cost (economy class)","Original itemized receipt required"]
[7,"Other expenses","Actual cost","Original receipt required.  Identify type of expense."]
["C – TRANSPORTATION"]
["Original receipts are required for all types of transportation except reimbursement for personal vehicle mileage."]
["Column",null,null,"Description"]
["Type of Transportation",null,null,"Indicate personal car, train, plane, bus, etc."]
["Departure",null,null,"Indicate departure date and location."]
["Arrival",null,null,"Indicate arrival date and location."]
["Personal Car Mileage",null,null,"Only indicate mileage if using personal car.  The total mileage will calculate in the last field of this column.  If completing the voucher by hand, add the total mileage and enter in the last field of this column.  Leave this blank for all other types of transportation.  (See https://centrallink.cmich.edu/services/business_facilityservices/financialservices_reporting/financial_services/TravelServices/Employee_Reimbursement/Pages/Mileage_Reimbursement.aspx for rate.)."]
["Total",null,null,"Indicate actual cost of transportation.  Leave blank if using personal car.  The mileage reimbursement total will calculate automatically in the last field of this column.  If completing the voucher by hand, multiply the total mileage in the Personal Car Mileage column by the current mileage rate (See https://centrallink.cmich.edu/services/business_facilityservices/financialservices_reporting/financial_services/TravelServices/Employee_Reimbursement/Pages/Mileage_Reimbursement.aspx for rate.)."]
["D – EXPENDITURES"]
["Original receipts are required for all expenditures."]
["Entertainment, business meals and hosting activities require additional documentation.  Complete the Entertainment/Hosting Activities Supplemental Attachment for these expenses."]
["Column",null,"Description"]
["Expenditure",null,"Describe expense."]
["Attachment #",null,"Complete Entertainment/Hosting Activities Supplemental Attachment.  Designate an attachment number (1, 2, 3, etc.) on the form and in this column only if this is a business meal, entertainment or a hosting activity."]
["Date",null,"Indicate date of expense."]
["Comment",null,"Use this to explain any unusual circumstances or to give more detail to expense."]
["Amount",null,"Indicate actual amount paid.  Attach original receipt."]
["E – COMMENTS Use this section to give further explanation or details."]
["F – APPROVAL"]
["Both the employee and the employee’s supervisor/dept. chair must sign the voucher. Employee’s supervisor/dept. chair must also print their name. Additional signatures may be needed if reimbursing from a grant."]
["G - FINANCIAL"]
["Column",null,"Description"]
["CostCtr/WBS Name",null,"Indicate the name of each cost center or WBS that should be charged for the reimbursement."]
["CostCtr/WBS Number",null,"Indicate the corresponding cost center # (5 digits) or WBS # (6 digits) that should be charged."]
["Internal Order (optional)",null,"Indicate the internal order number.  This field is optional."]
["G/L",null,"Indicate the general ledger account number to be charged (6 digits)."]
["Amount",null,"Indicate the amount to be charged to each cost center or WBS."]
["Description",null,"This information shows on financial reports.  Use a maximum of 50 characters."]
["H – TOTAL EXPENSES This is the total of all the expenses from Sections B – D."]
["I – LESS EXPENSES NOT REIMBURSABLE Indicate the total amount to be subtracted from the total expenses.  This includes amounts greater than the approved funds, amounts already reimbursed, non-allowable expenses, etc."]
["J – REIMBURSEMENT CLAIM This is the total expenses (H) minus the expenses to be subtracted (I).  It is the amount to be reimbursed to the employee and should match the total of all line items in Section G."]
["K – EXCHANGE RATE Indicate the currency and exchange rate if traveled to a foreign country."]

{"sheet":"Voucher","index":1,"n_rows":56,"n_cols":17,"rows_kept":56,"cut":false,"hidden":false,"merged":[[9,9,10,9],[9,7,10,7],[9,6,10,6],[9,8,10,8],[32,2,32,12],[38,4,38,6],[33,4,33,6],[35,4,35,6],[36,4,36,6],[33,7,33,10],[34,7,34,10],[35,7,35,10],[36,7,36,10],[37,7,37,10],[34,4,34,6],[3,0,5,0],[9,1,10,4],[7,5,8,5],[0,11,0,12],[1,11,1,12],[2,11,2,12],[6,12,10,12],[4,1,5,12],[9,10,10,10],[7,9,8,9],[7,8,8,8],[7,11,8,11],[2,7,2,9],[0,7,0,9],[1,7,1,9],[3,1,3,12],[7,1,8,4],[0,0,0,5],[2,1,2,4],[7,10,8,10],[1,0,1,5],[7,0,8,0],[9,0,20,0],[15,2,15,4],[54,9,54,12],[38,7,38,10],[30,9,30,10],[39,4,39,6],[21,10,22,11],[23,10,23,11],[24,10,24,11],[28,6,29,7],[7,6,8,6],[7,7,8,7],[14,2,14,4],[13,2,13,4],[9,5,10,5],[12,2,12,4],[37,4,37,6],[28,5,29,5],[28,1,29,4],[30,6,30,7],[21,3,22,3],[31,1,31,12],[20,2,20,4],[19,2,19,4],[11,1,11,4],[9,11,10,11],[50,5,50,6],[46,1,46,4],[42,10,43,11],[50,9,50,12],[49,1,49,3],[21,12,22,12],[16,2,16,4],[17,2,17,4],[18,2,18,4],[28,11,30,12],[21,1,22,2],[28,8,29,8],[27,10,27,11],[23,4,23,5],[23,6,23,7],[41,1,43,9],[40,3,40,9],[54,1,54,6],[42,12,43,12],[49,9,49,12],[48,9,48,12],[27,0,27,7],[24,6,24,7],[25,4,25,5],[25,6,25,7],[26,4,26,5],[26,6,26,7],[49,0,55,0],[48,5,48,6],[53,9,53,12],[50,1,50,3],[53,5,53,6],[53,1,53,3],[45,12,46,12],[40,10,40,11],[41,10,41,11],[39,7,39,10],[40,1,40,2],[28,9,29,10],[55,8,55,12],[49,5,49,6],[26,10,26,11],[25,10,25,11],[24,4,24,5],[21,4,22,5],[21,6,22,7],[21,8,22,8],[21,9,22,9],[47,0,48,0],[48,1,48,3],[31,0,32,0],[33,0,39,0],[22,0,26,0],[28,0,30,0],[45,0,46,0],[40,0,43,0]]}
["Central Michigan University",null,null,null,null,null,"Employee"]
["Employee Reimbursement Voucher",null,null,null,null,null,"Office Addr",null,null,null,"Campus ID"]
["A","Officially working out of home:",null,null,null,null,"Dept Name",null,null,null,"Phone #"]
["CONTACT","Narrative:  Describe the general business purpose of your expenses.  If expenses are related to a trip, also include destination and names of others on trip."]
[]
[]
["B","Date of Travel",null,null,null,null,null,null,null,null,null,null,"Total"]
[null,"Time of Departure",null,null,null,"Click Here","Click Here","Click Here","Click Here","Click Here","Click Here","Click Here",null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
["DAILY TRAVEL EXPENSES","Time of Return",null,null,null,"Click Here","Click Here","Click Here","Click Here","Click Here","Click Here","Click Here"]
[]
[null,"1. Employee Travel Meals: \na. Select meals claimed (B, L, D).  \nb.  Select if High Cost City at time of meal",null,null,null," "," "," "," "," "," "," "]
[null,2,"Employee Travel Meals subtotaled by day*",null,null,{"$f":"IF(('-'!C13)=0, \" \", ('-'!C13))","v":" "},{"$f":"IF(('-'!G13)=0, \" \", ('-'!G13))","v":" "},{"$f":"IF(('-'!K13)=0, \" \", ('-'!K13))","v":" "},{"$f":"IF(('-'!O13)=0, \" \", ('-'!O13))","v":" "},{"$f":"IF(('-'!S13)=0, \" \", ('-'!S13))","v":" "},{"$f":"IF(('-'!W13)=0, \" \", ('-'!W13))","v":" "},{"$f":"IF(('-'!AA13)=0, \" \", ('-'!AA13))","v":" "},{"$f":"SUM(F13:L13)","v":0}]
[null,3," Lodging*",null,null,null,null,null,null,null,null,null,{"$f":"SUM(F14:L14)","v":0},null,null,null," "]
[null,4," Lodging Tips",null,null,null,null,null,null,null,null,null,0,null,null,null," "]
[null,5," Taxi, Bus*",null,null,null,null,null,null,null,null,null,0]
[null,6," Parking, Tolls*",null,null,null,null,null,null,null,null,null,0]
[null,7," Rental Car Expense*",null,null,null,null,null,null,null,null,null,0]
[null,8," Conference Fees",null,null,null,null,null,null,null,null,null,0]
[null,9," Business Calls (non-personal)",null,null,null,null,null,null,null,null,null,0]
[null,10,null,null,null,null,null,null,null,null,null,null,0]
["C","Mode of Transportation",null,"Date","Departure Location",null,"Arrival Location",null,"Personal Car Mileage","Sum of Mileage","Sum of Expenses Paid",null,"Total"]
["TRANSPORT"]
[null,1,"Click Here",null,null,null,null,null,null,{"$f":"IF(I24*0.7=0,\" \",(I24*0.7))","v":" "},null,null,{"$f":"IF(I24*0.7+K24-L24=0, \" \", I24*0.7+K24-L24)","v":" "}," ",{"$f":"IF(ISNUMBER(N24),IF(ISNUMBER(#REF!),\"Only enter an mileage or dollar amount.\",\"\"),\"\")","v":""},{"$f":"IF(ISNUMBER(O24),IF(ISNUMBER(#REF!),\"Only enter an mileage or dollar amount.\",\"\"),\"\")","v":""}]
[null,2,"Click Here",null,null,null,null,null,null,{"$f":"IF(I25*0.7=0,\" \",(I25*0.7))","v":" "},null,null,{"$f":"IF(I25*0.7+K25-L25=0, \" \", I25*0.7+K25-L25)","v":" "}]
[null,3,"Click Here",null,null,null,null,null,null,{"$f":"IF(I26*0.7=0,\" \",(I26*0.7))","v":" "},null,null,{"$f":"IF(I26*0.7+K26-L26=0, \" \", I26*0.7+K26-L26)","v":" "}]
[null,4,"Click Here",null,null,null,null,null,null,{"$f":"IF(I27*0.7=0,\" \",(I27*0.7))","v":" "},null,null,{"$f":"IF(I27*0.7+K27-L27=0, \" \", I27*0.7+K27-L27)","v":" "}," "]
["Transportation Total:",null,null,null,null,null,null,null,{"$f":"IF(SUM(I24:I27)=0,\" \",(SUM(I24:I27)))","v":" "},{"$f":"(SUM(J24:J27))","v":0},{"$f":"(SUM(K24:K27))","v":0},null,{"$f":"IF(SUM(M24:M27)=0, \" \", (SUM(M24:M27)))","v":" "}]
["BILLING","Did you already receive reimbursement for these?",null,null,null,"1.Conference Fees",null,null,"2. Airfare",null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,"    If \"Yes\", what month was it charged to?",null,null,null,"Date","Click here",null,"Date","Click here"]
["D","EXPENDITURES TO BE IDENTIFIED"]
[null,null,"Expenditure (When submitting entertainment expenses, please complete and attach an Entertainment/Hosting Activities form.  Use a separate attachment # per event.)"]
["EXPENDITURES",null,"Expense Type","Date","Vendor",null,null,"Description",null,null,null,"Entertain./ Hosting Attachment","Amount"]
[null,1,"Click Here",null,null,null,null,null,null,null,null,"#"]
[null,2,"Click Here",null,null,null,null,null,null,null,null,"#"]
[null,3,"Click Here",null,null,null,null,null,null,null,null,"#"]
[null,4,"Click Here",null,null,null,null,null,null,null,null,"#"]
[null,5,"Click Here",null,null,null,null,null,null,null,null,"#"]
[null,6,"Click Here",null,null,null,null,null,null,null,null,"#"]
["E","COMMENTS",null," ",null,null,null,null,null,null,"H Total Expenses",null,{"$f":"SUM(M35:M40,M28,M13:M21)+'Voucher 2'!M32+'Voucher 2'!M65","v":0}]
[null,null,null,null,null,null,null,null,null,null,"I  Total Amount NOT being reimbursed by Department "]
[null,null,null,null,null,null,null,null,null,null,"J Reimbursement Claim (Taxable meals will be included on paycheck.)",null,{"$f":"+M41-M42","v":0}]
[]
["F","EMPLOYEE'S SIGNATURE (REQUIRED)**",null,null,null,"DATE","SENIOR ADMINISTRATOR SIGNATURE (REQUIRED)**",null,null,"DATE","K Exchange Rate"]
["APPROVAL"]
[null,"ADDITIONAL SIGNATURE (IF APPLICABLE)**",null,null,null,null,"SENIOR ADMINISTRATOR PRINT NAME  (REQUIRED)**"]
["G","DEPARTMENT ACCOUNTING ALLOCATIONS (Debit = Department will be charged, Credit = Department Refund Amount)"]
[null,"COST CENTER (or WBS) NAME",null,null,"CostCtr/WBS #","INTERNAL ORDER",null,"G/L","AMOUNT","DESCRIPTION (50 Characters Per Line)"]
["FINANCIAL"]
[]
[]
[]
[]
[null,"* RECEIPTS TO BE ATTACHED",null,null,null,null,null,"TOTAL",{"$f":"SUM(I50:I54)","v":0},"Submit all forms to WA204 774-3525 or 774-6944"]
[null,"** IT IS RECOMMENDED THAT SIGNATURES ARE IN BLUE INK"]

{"sheet":"Voucher 2","index":2,"n_rows":65,"n_cols":13,"rows_kept":65,"cut":false,"hidden":false,"merged":[[2,1,2,4],[2,7,2,9],[2,11,2,12],[3,0,5,0],[3,1,3,12],[4,1,5,12],[0,0,0,5],[0,7,0,9],[0,11,0,12],[1,0,1,5],[1,7,1,9],[1,11,1,12],[6,12,10,12],[7,0,8,0],[7,1,8,4],[7,5,8,5],[7,6,8,6],[7,7,8,7],[7,8,8,8],[7,9,8,9],[7,10,8,10],[7,11,8,11],[9,9,10,9],[9,10,10,10],[9,11,10,11],[11,1,11,4],[12,2,12,4],[13,2,13,4],[9,0,20,0],[9,1,10,4],[9,5,10,5],[9,6,10,6],[9,7,10,7],[9,8,10,8],[14,2,14,4],[15,2,15,4],[16,2,16,4],[17,2,17,4],[21,12,22,12],[22,0,26,0],[23,4,23,5],[23,6,23,7],[23,10,23,11],[24,4,24,5],[18,2,18,4],[19,2,19,4],[20,2,20,4],[21,1,22,2],[21,3,22,3],[21,4,22,5],[24,6,24,7],[24,10,24,11],[25,4,25,5],[25,6,25,7],[25,10,25,11],[26,4,26,5],[26,6,26,7],[26,10,26,11],[21,6,22,7],[21,8,22,8],[21,9,22,9],[21,10,22,11],[30,9,30,10],[31,0,31,11],[33,0,33,5],[33,7,33,9],[33,11,33,12],[27,0,27,7],[27,10,27,11],[28,0,30,0],[28,1,29,4],[28,5,29,5],[28,6,29,7],[28,8,29,8],[28,9,29,10],[28,11,30,12],[30,6,30,7],[34,0,34,5],[34,7,34,9],[34,11,34,12],[35,11,35,12],[36,0,38,0],[36,1,36,12],[37,1,38,12],[42,10,43,10],[42,11,43,11],[40,8,41,8],[35,1,35,4],[35,7,35,9],[42,7,43,7],[42,8,43,8],[42,9,43,9],[39,12,43,12],[40,0,41,0],[40,1,41,4],[40,5,41,5],[40,6,41,6],[40,7,41,7],[40,9,41,9],[40,10,41,10],[40,11,41,11],[42,0,53,0],[44,1,44,4],[45,2,45,4],[46,2,46,4],[47,2,47,4],[48,2,48,4],[49,2,49,4],[42,1,43,4],[42,5,43,5],[42,6,43,6],[54,12,55,12],[55,0,59,0],[56,4,56,5],[56,6,56,7],[56,10,56,11],[57,4,57,5],[50,2,50,4],[51,2,51,4],[52,2,52,4],[53,2,53,4],[54,1,55,2],[54,3,55,3],[54,4,55,5],[57,6,57,7],[57,10,57,11],[58,4,58,5],[58,6,58,7],[58,10,58,11],[59,4,59,5],[59,6,59,7],[59,10,59,11],[54,6,55,7],[54,8,55,8],[54,9,55,9],[54,10,55,11],[63,9,63,10],[64,0,64,11],[60,0,60,7],[60,10,60,11],[61,0,63,0],[61,1,62,4],[61,5,62,5],[61,6,62,7],[61,8,62,8],[61,9,62,10],[61,11,63,12],[63,6,63,7]]}
["Central Michigan University",null,null,null,null,null,"Employee",{"$f":"IF(ISBLANK(Voucher!H1:J1),\" \",(Voucher!H1:J1))","v":" "}]
["Employee Reimbursement Voucher",null,null,null,null,null,"Office Addr",{"$f":"IF(ISBLANK(Voucher!H2:J2),\" \",(Voucher!H2:J2))","v":" "},null,null,"Campus ID",{"$f":"IF(ISBLANK(Voucher!L2:M2),\" \",(Voucher!L2:M2))","v":" "}]
["A","Officially working out of home:",null,null,null,null,"Dept Name",{"$f":"IF(ISBLANK(Voucher!H3:J3),\" \",(Voucher!H3:J3))","v":" "},null,null,"Phone #",{"$f":"IF(ISBLANK(Voucher!L3:M3),\" \",(Voucher!L3:M3))","v":" "}]
["CONTACT","Narrative:  Describe the general business purpose of your expenses.  If expenses are related to a trip, also include destination and names of others on trip."]
[]
[]
["B","Date of Travel",null,null,null,null,null,null,null,null,null,null,"Total"]
[null,"Time of Departure",null,null,null,"Click Here","Click Here","Click Here","Click Here","Click Here","Click Here","Click Here"]
[]
["DAILY TRAVEL EXPENSES","Time of Return",null,null,null,"Click Here","Click Here","Click Here","Click Here","Click Here","Click Here","Click Here"]
[]
[null,"1. Employee Travel Meals: \na. Select meals claimed (B, L, D).  \nb.  Select if High Cost City at time of meal",null,null,null," "," "," "," "," "," "," "]
[null,2,"Employee Travel Meals subtotaled by day*",null,null,{"$f":"IF(('-'!C35)=0, \" \", ('-'!C35))","v":" "},{"$f":"IF(('-'!G35)=0, \" \", ('-'!G35))","v":" "},{"$f":"IF(('-'!K35)=0, \" \", ('-'!K35))","v":" "},{"$f":"IF(('-'!O35)=0, \" \", ('-'!O35))","v":" "},{"$f":"IF(('-'!S35)=0, \" \", ('-'!S35))","v":" "},{"$f":"IF(('-'!W35)=0, \" \", ('-'!W35))","v":" "},{"$f":"IF(('-'!AA35)=0, \" \", ('-'!AA35))","v":" "},{"$f":"SUM(F13:L13)","v":0}]
[null,3," Lodging*",null,null,null,null,null,null,null,null,null,{"$f":"SUM(F14:L14)","v":0}]
[null,4," Lodging Tips",null,null,null,null,null,null,null,null,null,0]
[null,5," Taxi, Bus*",null,null,null,null,null,null,null,null,null,0]
[null,6," Parking, Tolls*",null,null,null,null,null,null,null,null,null,0]
[null,7," Rental Car Expense*",null,null,null,null,null,null,null,null,null,0]
[null,8," Conference Fees",null,null,null,null,null,null,null,null,null,0]
[null,9," Business Calls (non-personal)",null,null,null,null,null,null,null,null,null,0]
[null,10,null,null,null,null,null,null,null,null,null,null,0]
["C","Mode of Transportation",null,"Date","Departure Location",null,"Arrival Location",null,"Personal Car Mileage","Sum of Mileage","Sum of Expenses Paid",null,"Total"]
["TRANSPORT"]
[null,1,"Click Here",null,null,null,null,null,null,{"$f":"IF(I24*0.7=0,\" \",(I24*0.7))","v":" "},null,null,{"$f":"IF(I24*0.7+K24-L24=0, \" \", I24*0.7+K24-L24)","v":" "}]
[null,2,"Click Here",null,null,null,null,null,null,{"$f":"IF(I25*0.7=0,\" \",(I25*0.7))","v":" "},null,null,{"$f":"IF(I25*0.7+K25-L25=0, \" \", I25*0.7+K25-L25)","v":" "}]
[null,3,"Click Here",null,null,null,null,null,null,{"$f":"IF(I26*0.7=0,\" \",(I26*0.7))","v":" "},null,null,{"$f":"IF(I26*0.7+K26-L26=0, \" \", I26*0.7+K26-L26)","v":" "}]
[null,4,"Click Here",null,null,null,null,null,null,{"$f":"IF(I27*0.7=0,\" \",(I27*0.7))","v":" "},null,null,{"$f":"IF(I27*0.7+K27-L27=0, \" \", I27*0.7+K27-L27)","v":" "}]
["Transportation Total:",null,null,null,null,null,null,null,{"$f":"IF(SUM(I24:I27)=0,\" \",(SUM(I24:I27)))","v":" "},{"$f":"(SUM(J24:J27))","v":0},{"$f":"(SUM(K24:K27))","v":0},null,{"$f":"IF(SUM(M24:M27)=0, \" \", (SUM(M24:M27)))","v":" "}]
["BILLING","Did you already receive reimbursement for these?",null,null,null,"1.Conference Fees",null,null,"2. Airfare"]
[]
[null,"    If \"Yes\", what month was it charged to?",null,null,null,"Date","Click Here",null,"Date","Click Here"]
[" H) Total Additional Expenses",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M13:M21,M28)","v":0}]
[]
["Central Michigan University",null,null,null,null,null,"Employee"]
["Employee Reimbursement Voucher",null,null,null,null,null,"Office Addr",null,null,null,"Campus ID"]
["A","Officially working out of home:",null,null,null,null,"Dept Name",null,null,null,"Phone #"]
["CONTACT","Narrative:  Describe the general business purpose of your expenses.  If expenses are related to a trip, also include destination and names of others on trip."]
[]
[]
["B","Date of Travel",null,null,null,null,null,null,null,null,null,null,"Total"]
[null,"Time of Departure",null,null,null,"Click Here","Click Here","Click Here","Click Here","Click Here","Click Here","Click Here"]
[]
["DAILY TRAVEL EXPENSES","Time of Return",null,null,null,"Click Here","Click Here","Click Here","Click Here","Click Here","Click Here","Click Here"]
[]
[null,"1. Employee Travel Meals: \na. Select meals claimed (B, L, D).  \nb.  Select if High Cost City at time of meal",null,null,null," "," "," "," "," "," "," "]
[null,2,"Employee Travel Meals subtotaled by day*",null,null,{"$f":"IF(('-'!C58)=0,\" \",('-'!C58))","v":" "},{"$f":"IF(('-'!G58)=0,\" \",('-'!G58))","v":" "},{"$f":"IF(('-'!K58)=0,\" \",('-'!K58))","v":" "},{"$f":"IF(('-'!O58)=0,\" \",('-'!O58))","v":" "},{"$f":"IF(('-'!S58)=0,\" \",('-'!S58))","v":" "},{"$f":"IF(('-'!W58)=0,\" \",('-'!W58))","v":" "},{"$f":"IF(('-'!AA58)=0,\" \",('-'!AA58))","v":" "},{"$f":"SUM(F46:L46)","v":0}]
[null,3," Lodging*",null,null,null,null,null,null,null,null,null,{"$f":"SUM(F47:L47)","v":0}]
[null,4," Lodging Tips",null,null,null,null,null,null,null,null,null,0]
[null,5," Taxi, Bus*",null,null,null,null,null,null,null,null,null,0]
[null,6," Parking, Tolls*",null,null,null,null,null,null,null,null,null,0]
[null,7," Rental Car Expense*",null,null,null,null,null,null,null,null,null,0]
[null,8," Conference Fees",null,null,null,null,null,null,null,null,null,0]
[null,9," Business Calls (non-personal)",null,null,null,null,null,null,null,null,null,0]
[null,10,null,null,null,null,null,null,null,null,null,null,0]
["C","Mode of Transportation",null,"Date","Departure Location",null,"Arrival Location",null,"Personal Car Mileage","Sum of Mileage","Sum of Expenses Paid",null,"Total"]
["TRANSPORT"]
[null,1,"Click Here",null,null,null,null,null,null,{"$f":"IF(I57*0.7=0,\" \",(I57*0.7))","v":" "},null,null,{"$f":"IF(I57*0.7+K57-L57=0, \" \", I57*0.7+K57-L57)","v":" "}]
[null,2,"Click Here",null,null,null,null,null,null,{"$f":"IF(I58*0.7=0,\" \",(I58*0.7))","v":" "},null,null,{"$f":"IF(I58*0.7+K58-L58=0, \" \", I58*0.7+K58-L58)","v":" "}]
[null,3,"Click Here",null,null,null,null,null,null,{"$f":"IF(I59*0.7=0,\" \",(I59*0.7))","v":" "},null,null,{"$f":"IF(I59*0.7+K59-L59=0, \" \", I59*0.7+K59-L59)","v":" "}]
[null,4,"Click Here",null,null,null,null,null,null,{"$f":"IF(I60*0.7=0,\" \",(I60*0.7))","v":" "},null,null,{"$f":"IF(I60*0.7+K60-L60=0, \" \", I60*0.7+K60-L60)","v":" "}]
["Transportation Total:",null,null,null,null,null,null,null,null,{"$f":"(SUM(J57:J60))","v":0},{"$f":"(SUM(K57:K60))","v":0},null,{"$f":"IF(SUM(M57:M60)=0, \" \", (SUM(M57:M60)))","v":" "}]
["BILLING","Did you already receive reimbursement for these?",null,null,null,"1.Conference Fees",null,null,"2. Airfare"]
[]
[null,"    If \"Yes\", what month was it charged to?",null,null,null,"Date","Click Here",null,"Date","Click Here"]
[" H) Total Additional Expenses",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M46:M54,M61)","v":0}]

{"sheet":"EntertainmentHosting","index":3,"n_rows":52,"n_cols":10,"rows_kept":52,"cut":false,"hidden":false,"merged":[[47,0,47,4],[47,5,47,7],[47,8,47,11],[50,0,50,4],[50,5,50,7],[50,8,50,11],[51,0,51,11],[48,0,48,4],[48,5,48,7],[48,8,48,11],[49,0,49,4],[49,5,49,7],[49,8,49,11],[44,0,44,4],[44,5,44,7],[44,8,44,11],[45,0,45,4],[45,5,45,7],[45,8,45,11],[46,0,46,4],[46,5,46,7],[46,8,46,11],[41,0,41,3],[41,4,41,11],[42,0,42,3],[42,4,42,5],[42,6,42,8],[42,9,42,11],[43,0,43,4],[43,5,43,7],[43,8,43,11],[35,0,35,4],[35,6,35,8],[35,9,35,10],[36,0,36,4],[36,5,37,11],[37,0,37,4],[38,0,38,3],[38,4,38,11],[39,0,40,3],[39,4,39,11],[40,4,40,11],[31,0,31,4],[31,5,31,7],[31,8,31,11],[32,0,32,4],[32,5,32,7],[32,8,32,11],[33,0,33,4],[33,5,33,7],[33,8,33,11],[28,0,28,4],[28,5,28,7],[28,8,28,11],[29,0,29,4],[29,5,29,7],[29,8,29,11],[30,0,30,4],[30,5,30,7],[30,8,30,11],[25,0,25,3],[25,4,25,5],[25,6,25,8],[25,9,25,11],[26,0,26,4],[26,5,26,7],[26,8,26,11],[27,0,27,4],[27,5,27,7],[27,8,27,11],[19,0,19,4],[19,5,20,11],[20,0,20,4],[21,0,21,3],[21,4,21,11],[22,0,23,3],[22,4,22,11],[23,4,23,11],[24,0,24,3],[24,4,24,11],[15,0,15,4],[15,5,15,7],[15,8,15,11],[16,0,16,4],[16,5,16,7],[16,8,16,11],[18,0,18,4],[18,6,18,8],[18,9,18,10],[12,0,12,4],[12,5,12,7],[12,8,12,11],[13,0,13,4],[13,5,13,7],[13,8,13,11],[14,0,14,4],[14,5,14,7],[14,8,14,11],[9,0,9,4],[9,5,9,7],[9,8,9,11],[10,0,10,4],[10,5,10,7],[10,8,10,11],[11,0,11,4],[11,5,11,7],[11,8,11,11],[5,0,6,3],[5,4,5,11],[6,4,6,11],[7,0,7,3],[7,4,7,11],[8,0,8,3],[8,4,8,5],[8,6,8,8],[8,9,8,11],[0,0,0,11],[1,0,1,4],[1,6,1,8],[1,9,1,10],[2,0,2,4],[2,5,3,11],[3,0,3,4],[4,0,4,3],[4,4,4,11]]}
[]
["Central Michigan University",null,null,null,null,"Employee",null,null,null,"Attachment #"]
["Entertainment/Hosting Activities",null,null,null,null,"This form is to be used when an employee is seeking reimbursement for entertainment and hosting activities.  It should be completed with the Employee Reimbursement Voucher."]
["Supplemental Attachment"]
["Name of Event"]
["Business Purpose"]
[]
["Place, City, State"]
["Date of Event",null,null,null,null,null,"Total Expenditures for Event"]
["Attendee/Guest",null,null,null,null,"Business/Affiliation",null,null,"Relationship to CMU"]
[]
[]
[]
[]
[]
[]
[]
[]
["Central Michigan University",null,null,null,null,"Employee",null,null,null,"Attachment #"]
["Entertainment/Hosting Activities",null,null,null,null,"This form is to be used when an employee is seeking reimbursement for entertainment and hosting activities.  It should be completed with the Employee Reimbursement Voucher."]
["Supplemental Attachment"]
["Name of Event"]
["Business Purpose"]
[]
["Place, City, State"]
["Date of Event",null,null,null,null,null,"Total Expenditures for Event"]
["Attendee/Guest",null,null,null,null,"Business/Affiliation",null,null,"Relationship to CMU"]
[]
[]
[]
[]
[]
[]
[]
[]
["Central Michigan University",null,null,null,null,"Employee",null,null,null,"Attachment #"]
["Entertainment/Hosting Activities",null,null,null,null,"This form is to be used when an employee is seeking reimbursement for entertainment and hosting activities.  It should be completed with the Employee Reimbursement Voucher."]
["Supplemental Attachment"]
["Name of Event"]
["Business Purpose"]
[]
["Place, City, State"]
["Date of Event",null,null,null,null,null,"Total Expenditures for Event"]
["Attendee/Guest",null,null,null,null,"Business/Affiliation",null,null,"Relationship to CMU"]
[]
[]
[]
[]
[]
[]
[]
["Attach this form to the applicable Employee Reimbursement Voucher and submit to Payroll/Travel, Warriner 204."]

{"sheet":"Missing Receipt","index":4,"n_rows":18,"n_cols":6,"rows_kept":18,"cut":false,"hidden":false,"merged":[[8,0,8,11],[9,4,9,11],[11,4,11,11],[12,0,12,3],[4,4,4,11],[0,0,0,11],[7,4,7,11],[1,0,1,4],[4,0,4,3],[7,0,7,3],[2,0,2,4],[3,0,3,4],[2,5,3,11],[1,6,1,11],[5,4,5,11],[16,4,16,11],[17,0,17,3],[19,0,19,11],[9,0,9,3],[13,0,13,11],[14,0,14,3],[14,4,14,11],[12,4,12,11],[17,4,17,11],[18,0,18,11],[10,4,10,11],[15,4,15,11]]}
[]
["Central Michigan University",null,null,null,null,"Employee"]
["Missing Receipt Form",null,null,null,null,"Individuals must attempt to obtain a copy of the original receipt from the vendor.  In the event that the receipt is unobtainable, this form must be filled out with a complete explanation of the expense.  Print this form and attach to your reconciliation form."]
["Supplemental Attachment"]
["Vendor"]
["Date"]
["Amount of Receipt"]
["Explanation"]
[]
["Vendor"]
["Date"]
["Amount of Receipt"]
["Explanation "]
[]
["Vendor"]
["Date"]
["Amount of Receipt"]
["Explanation "]

{"sheet":"-","index":5,"n_rows":132,"n_cols":29,"rows_kept":132,"cut":false,"hidden":false,"merged":[[1,28,10,28],[23,28,32,28],[46,28,55,28]]}
["Page 1 Meal Math"]
["Day1, Meal Breakdown",null," ",null,"Day2, Meal Breakdown",2," ",null,"Day3, Meal Breakdown",null," ",null,"Day4, Meal Breakdown",null," ",null,"Day5, Meal Breakdown",null," ",null,"Day5, Meal Breakdown",null," ",null,"Day5, Meal Breakdown",null," ",null,"Combined Meals Grand Total"]
["B - Normal",false,{"$f":"IF(B3=TRUE,11,IF(B3=FALSE,0,\" \"))","v":0},null,"B - Normal",false,{"$f":"IF(F3=TRUE,11,IF(F3=FALSE,0,\" \"))","v":0},null,"B - Normal",false,{"$f":"IF(J3=TRUE,11,IF(J3=FALSE,0,\" \"))","v":0},null,"B - Normal",false,{"$f":"IF(N3=TRUE,11,IF(N3=FALSE,0,\" \"))","v":0},null,"B - Normal",false,{"$f":"IF(R3=TRUE,11,IF(R3=FALSE,0,\" \"))","v":0},null,"B - Normal",false,{"$f":"IF(V3=TRUE,11,IF(V3=FALSE,0,\" \"))","v":0},null,"B - Normal",false,{"$f":"IF(Z3=TRUE,11,IF(Z3=FALSE,0,\" \"))","v":0}]
["L - Normal",false,{"$f":"IF(B4=TRUE,17,IF(B4=FALSE,0,\" \"))","v":0},null,"L - Normal",false,{"$f":"IF(F4=TRUE,17,IF(F4=FALSE,0,\" \"))","v":0},null,"L - Normal",false,{"$f":"IF(J4=TRUE,17,IF(J4=FALSE,0,\" \"))","v":0},null,"L - Normal",false,{"$f":"IF(N4=TRUE,17,IF(N4=FALSE,0,\" \"))","v":0},null,"L - Normal",false,{"$f":"IF(R4=TRUE,17,IF(R4=FALSE,0,\" \"))","v":0},null,"L - Normal",false,{"$f":"IF(V4=TRUE,17,IF(V4=FALSE,0,\" \"))","v":0},null,"L - Normal",false,{"$f":"IF(Z4=TRUE,17,IF(Z4=FALSE,0,\" \"))","v":0}]
["D - Normal",false,{"$f":"IF(B5=TRUE,28,IF(B5=FALSE,0,\" \"))","v":0},null,"D - Normal",false,{"$f":"IF(F5=TRUE,28,IF(F5=FALSE,0,\" \"))","v":0},null,"D - Normal",false,{"$f":"IF(J5=TRUE,28,IF(J5=FALSE,0,\" \"))","v":0},null,"D - Normal",false,{"$f":"IF(N5=TRUE,28,IF(N5=FALSE,0,\" \"))","v":0},null,"D - Normal",false,{"$f":"IF(R5=TRUE,28,IF(R5=FALSE,0,\" \"))","v":0},null,"D - Normal",false,{"$f":"IF(V5=TRUE,28,IF(V5=FALSE,0,\" \"))","v":0},null,"D - Normal",false,{"$f":"IF(Z5=TRUE,28,IF(Z5=FALSE,0,\" \"))","v":0}]
["Day1, Meals SubTotal",null,{"$f":"SUM(C3:C5)","v":0},null,"Day2, Meals SubTotal",null,{"$f":"SUM(G3:G5)","v":0},null,"Day3, Meals SubTotal",null,{"$f":"SUM(K3:K5)","v":0},null,"Day4, Meals SubTotal",null,{"$f":"SUM(O3:O5)","v":0},null,"Day5, Meals SubTotal",null,{"$f":"SUM(S3:S5)","v":0},null,"Day5, Meals SubTotal",null,{"$f":"SUM(W3:W5)","v":0},null,"Day5, Meals SubTotal",null,{"$f":"SUM(AA3:AA5)","v":0}]
[]
["B - H/C",false,{"$f":"IF(B8=TRUE,2,IF(B8=FALSE,0,\" \"))","v":0},null,"B - H/C",false,{"$f":"IF(F8=TRUE,2,IF(F8=FALSE,0,\" \"))","v":0},null,"B - H/C",false,{"$f":"IF(J8=TRUE,2,IF(J8=FALSE,0,\" \"))","v":0},null,"B - H/C",false,{"$f":"IF(N8=TRUE,2,IF(N8=FALSE,0,\" \"))","v":0},null,"B - H/C",false,{"$f":"IF(R8=TRUE,2,IF(R8=FALSE,0,\" \"))","v":0},null,"B - H/C",false,{"$f":"IF(V8=TRUE,2,IF(V8=FALSE,0,\" \"))","v":0},null,"B - H/C",false,{"$f":"IF(Z8=TRUE,2,IF(Z8=FALSE,0,\" \"))","v":0}]
["L - H/C",false,{"$f":"IF(B9=TRUE,3,IF(B9=FALSE,0,\" \"))","v":0},null,"L - H/C",false,{"$f":"IF(F9=TRUE,3,IF(F9=FALSE,0,\" \"))","v":0},null,"L - H/C",false,{"$f":"IF(J9=TRUE,3,IF(J9=FALSE,0,\" \"))","v":0},null,"L - H/C",false,{"$f":"IF(N9=TRUE,3,IF(N9=FALSE,0,\" \"))","v":0},null,"L - H/C",false,{"$f":"IF(R9=TRUE,3,IF(R9=FALSE,0,\" \"))","v":0},null,"L - H/C",false,{"$f":"IF(V9=TRUE,3,IF(V9=FALSE,0,\" \"))","v":0},null,"L - H/C",false,{"$f":"IF(Z9=TRUE,3,IF(Z9=FALSE,0,\" \"))","v":0}]
["D - H/C",false,{"$f":"IF(B10=TRUE,5,IF(B10=FALSE,0,\" \"))","v":0},null,"D - H/C",false,{"$f":"IF(F10=TRUE,5,IF(F10=FALSE,0,\" \"))","v":0},null,"D - H/C",false,{"$f":"IF(J10=TRUE,5,IF(J10=FALSE,0,\" \"))","v":0},null,"D - H/C",false,{"$f":"IF(N10=TRUE,5,IF(N10=FALSE,0,\" \"))","v":0},null,"D - H/C",false,{"$f":"IF(R10=TRUE,5,IF(R10=FALSE,0,\" \"))","v":0},null,"D - H/C",false,{"$f":"IF(V10=TRUE,5,IF(V10=FALSE,0,\" \"))","v":0},null,"D - H/C",false,{"$f":"IF(Z10=TRUE,5,IF(Z10=FALSE,0,\" \"))","v":0}]
["Day1, H/C SubTotal",null,{"$f":"SUM(C8:C10)","v":0},null,"Day2, H/C SubTotal",null,{"$f":"SUM(G8:G10)","v":0},null,"Day3, H/C SubTotal",null,{"$f":"SUM(K8:K10)","v":0},null,"Day4, H/C SubTotal",null,{"$f":"SUM(O8:O10)","v":0},null,"Day5, H/C SubTotal",null,{"$f":"SUM(S8:S10)","v":0},null,"Day5, H/C SubTotal",null,{"$f":"SUM(W8:W10)","v":0},null,"Day5, H/C SubTotal",null,{"$f":"SUM(AA8:AA10)","v":0}]
[]
["Day1, Grand Total",null,{"$f":"SUM(C6+C11)","v":0},null,"Day2, Grand Total",null,{"$f":"SUM(G6+G11)","v":0},null,"Day3, Grand Total",null,{"$f":"SUM(K6+K11)","v":0},null,"Day4, Grand Total",null,{"$f":"SUM(O6+O11)","v":0},null,"Day5, Grand Total",null,{"$f":"SUM(S6+S11)","v":0},null,"Day5, Grand Total",null,{"$f":"SUM(W6+W11)","v":0},null,"Day5, Grand Total",null,{"$f":"SUM(AA6+AA11)","v":0},null,{"$f":"SUM(+S13+O13+K13+G13+C13+W13+AA13)","v":0}]
[]
[]
[]
[]
[null,"Conference Fees, Page 1",null,null,null,"Airline, Page 1"]
[null,"True / False Results",null,null,null,"True / False Results"]
[]
[null,2,null,null,null,2]
[]
["Page 2a Meal Math"]
["Day1, Meal Breakdown",null," ",null,"Day2, Meal Breakdown",null," ",null,"Day3, Meal Breakdown",null," ",null,"Day4, Meal Breakdown",null," ",null,"Day5, Meal Breakdown",null," ",null,"Day5, Meal Breakdown",null," ",null,"Day5, Meal Breakdown",null," ",null,"Combined Meals Grand Total"]
["B - Normal",false,{"$f":"IF(B25=TRUE,11,IF(B25=FALSE,0,\" \"))","v":0},null,"B - Normal",false,{"$f":"IF(F25=TRUE,11,IF(F25=FALSE,0,\" \"))","v":0},null,"B - Normal",false,{"$f":"IF(J25=TRUE,11,IF(J25=FALSE,0,\" \"))","v":0},null,"B - Normal",false,{"$f":"IF(N25=TRUE,11,IF(N25=FALSE,0,\" \"))","v":0},null,"B - Normal",false,{"$f":"IF(R25=TRUE,11,IF(R25=FALSE,0,\" \"))","v":0},null,"B - Normal",false,{"$f":"IF(V25=TRUE,11,IF(V25=FALSE,0,\" \"))","v":0},null,"B - Normal",false,{"$f":"IF(Z25=TRUE,11,IF(Z25=FALSE,0,\" \"))","v":0}]
["L - Normal",false,{"$f":"IF(B26=TRUE,17,IF(B26=FALSE,0,\" \"))","v":0},null,"L - Normal",false,{"$f":"IF(F26=TRUE,17,IF(F26=FALSE,0,\" \"))","v":0},null,"L - Normal",false,{"$f":"IF(J26=TRUE,17,IF(J26=FALSE,0,\" \"))","v":0},null,"L - Normal",false,{"$f":"IF(N26=TRUE,17,IF(N26=FALSE,0,\" \"))","v":0},null,"L - Normal",false,{"$f":"IF(R26=TRUE,17,IF(R26=FALSE,0,\" \"))","v":0},null,"L - Normal",false,{"$f":"IF(V26=TRUE,17,IF(V26=FALSE,0,\" \"))","v":0},null,"L - Normal",false,{"$f":"IF(Z26=TRUE,17,IF(Z26=FALSE,0,\" \"))","v":0}]
["D - Normal",false,{"$f":"IF(B27=TRUE,28,IF(B27=FALSE,0,\" \"))","v":0},null,"D - Normal",false,{"$f":"IF(F27=TRUE,28,IF(F27=FALSE,0,\" \"))","v":0},null,"D - Normal",false,{"$f":"IF(J27=TRUE,28,IF(J27=FALSE,0,\" \"))","v":0},null,"D - Normal",false,{"$f":"IF(N27=TRUE,28,IF(N27=FALSE,0,\" \"))","v":0},null,"D - Normal",false,{"$f":"IF(R27=TRUE,28,IF(R27=FALSE,0,\" \"))","v":0},null,"D - Normal",false,{"$f":"IF(V27=TRUE,28,IF(V27=FALSE,0,\" \"))","v":0},null,"D - Normal",false,{"$f":"IF(Z27=TRUE,28,IF(Z27=FALSE,0,\" \"))","v":0}]
["Day1, Meals SubTotal",null,{"$f":"SUM(C25:C27)","v":0},null,"Day2, Meals SubTotal",null,{"$f":"SUM(G25:G27)","v":0},null,"Day3, Meals SubTotal",null,{"$f":"SUM(K25:K27)","v":0},null,"Day4, Meals SubTotal",null,{"$f":"SUM(O25:O27)","v":0},null,"Day5, Meals SubTotal",null,{"$f":"SUM(S25:S27)","v":0},null,"Day5, Meals SubTotal",null,{"$f":"SUM(W25:W27)","v":0},null,"Day5, Meals SubTotal",null,{"$f":"SUM(AA25:AA27)","v":0}]
[]
["B - H/C",false,{"$f":"IF(B30=TRUE,2,IF(B30=FALSE,0,\" \"))","v":0},null,"B - H/C",false,{"$f":"IF(F30=TRUE,2,IF(F30=FALSE,0,\" \"))","v":0},null,"B - H/C",false,{"$f":"IF(J30=TRUE,2,IF(J30=FALSE,0,\" \"))","v":0},null,"B - H/C",false,{"$f":"IF(N30=TRUE,2,IF(N30=FALSE,0,\" \"))","v":0},null,"B - H/C",false,{"$f":"IF(R30=TRUE,2,IF(R30=FALSE,0,\" \"))","v":0},null,"B - H/C",false,{"$f":"IF(V30=TRUE,2,IF(V30=FALSE,0,\" \"))","v":0},null,"B - H/C",false,{"$f":"IF(Z30=TRUE,2,IF(Z30=FALSE,0,\" \"))","v":0}]
["L - H/C",false,{"$f":"IF(B31=TRUE,3,IF(B31=FALSE,0,\" \"))","v":0},null,"L - H/C",false,{"$f":"IF(F31=TRUE,3,IF(F31=FALSE,0,\" \"))","v":0},null,"L - H/C",false,{"$f":"IF(J31=TRUE,3,IF(J31=FALSE,0,\" \"))","v":0},null,"L - H/C",false,{"$f":"IF(N31=TRUE,3,IF(N31=FALSE,0,\" \"))","v":0},null,"L - H/C",false,{"$f":"IF(R31=TRUE,3,IF(R31=FALSE,0,\" \"))","v":0},null,"L - H/C",false,{"$f":"IF(V31=TRUE,3,IF(V31=FALSE,0,\" \"))","v":0},null,"L - H/C",false,{"$f":"IF(Z31=TRUE,3,IF(Z31=FALSE,0,\" \"))","v":0}]
["D - H/C",false,{"$f":"IF(B32=TRUE,5,IF(B32=FALSE,0,\" \"))","v":0},null,"D - H/C",false,{"$f":"IF(F32=TRUE,5,IF(F32=FALSE,0,\" \"))","v":0},null,"D - H/C",false,{"$f":"IF(J32=TRUE,5,IF(J32=FALSE,0,\" \"))","v":0},null,"D - H/C",false,{"$f":"IF(N32=TRUE,5,IF(N32=FALSE,0,\" \"))","v":0},null,"D - H/C",false,{"$f":"IF(R32=TRUE,5,IF(R32=FALSE,0,\" \"))","v":0},null,"D - H/C",false,{"$f":"IF(V32=TRUE,5,IF(V32=FALSE,0,\" \"))","v":0},null,"D - H/C",false,{"$f":"IF(Z32=TRUE,5,IF(Z32=FALSE,0,\" \"))","v":0}]
["Day1, H/C SubTotal",null,{"$f":"SUM(C30:C32)","v":0},null,"Day2, H/C SubTotal",null,{"$f":"SUM(G30:G32)","v":0},null,"Day3, H/C SubTotal",null,{"$f":"SUM(K30:K32)","v":0},null,"Day4, H/C SubTotal",null,{"$f":"SUM(O30:O32)","v":0},null,"Day5, H/C SubTotal",null,{"$f":"SUM(S30:S32)","v":0},null,"Day5, H/C SubTotal",null,{"$f":"SUM(W30:W32)","v":0},null,"Day5, H/C SubTotal",null,{"$f":"SUM(AA30:AA32)","v":0}]
[]
["Day1, Grand Total",null,{"$f":"SUM(C28+C33)","v":0},null,"Day2, Grand Total",null,{"$f":"SUM(G28+G33)","v":0},null,"Day3, Grand Total",null,{"$f":"SUM(K28+K33)","v":0},null,"Day4, Grand Total",null,{"$f":"SUM(O28+O33)","v":0},null,"Day5, Grand Total",null,{"$f":"SUM(S28+S33)","v":0},null,"Day5, Grand Total",null,{"$f":"SUM(W28+W33)","v":0},null,"Day5, Grand Total",null,{"$f":"SUM(AA28+AA33)","v":0},null,{"$f":"SUM(+S35+O35+K35+G35+C35+W35+AA35)","v":0}]
[]
[]
[]
[]
[null,"Conference Fees, Page 1",null,null,null,"Airline, Page 1"]
[null,"True / False Results",null,null,null,"True / False Results"]
[]
[null,2,null,null,null,2]
[]
[]
["Page 2b Meal Math"]
["Day1, Meal Breakdown",null," ",null,"Day2, Meal Breakdown",null," ",null,"Day3, Meal Breakdown",null," ",null,"Day4, Meal Breakdown",null," ",null,"Day5, Meal Breakdown",null," ",null,"Day5, Meal Breakdown",null," ",null,"Day5, Meal Breakdown",null," ",null,"Combined Meals Grand Total"]
["B - Normal",false,{"$f":"IF(B48=TRUE,11,IF(B48=FALSE,0,\" \"))","v":0},null,"B - Normal",false,{"$f":"IF(F48=TRUE,11,IF(F48=FALSE,0,\" \"))","v":0},null,"B - Normal",false,{"$f":"IF(J48=TRUE,11,IF(J48=FALSE,0,\" \"))","v":0},null,"B - Normal",false,{"$f":"IF(N48=TRUE,11,IF(N48=FALSE,0,\" \"))","v":0},null,"B - Normal",false,{"$f":"IF(R48=TRUE,11,IF(R48=FALSE,0,\" \"))","v":0},null,"B - Normal",false,{"$f":"IF(V48=TRUE,11,IF(V48=FALSE,0,\" \"))","v":0},null,"B - Normal",false,{"$f":"IF(Z48=TRUE,11,IF(Z48=FALSE,0,\" \"))","v":0}]
["L - Normal",false,{"$f":"IF(B49=TRUE,17,IF(B49=FALSE,0,\" \"))","v":0},null,"L - Normal",false,{"$f":"IF(F49=TRUE,17,IF(F49=FALSE,0,\" \"))","v":0},null,"L - Normal",false,{"$f":"IF(J49=TRUE,17,IF(J49=FALSE,0,\" \"))","v":0},null,"L - Normal",false,{"$f":"IF(N49=TRUE,17,IF(N49=FALSE,0,\" \"))","v":0},null,"L - Normal",false,{"$f":"IF(R49=TRUE,17,IF(R49=FALSE,0,\" \"))","v":0},null,"L - Normal",false,{"$f":"IF(V49=TRUE,17,IF(V49=FALSE,0,\" \"))","v":0},null,"L - Normal",false,{"$f":"IF(Z49=TRUE,17,IF(Z49=FALSE,0,\" \"))","v":0}]
["D - Normal",false,{"$f":"IF(B50=TRUE,28,IF(B50=FALSE,0,\" \"))","v":0},null,"D - Normal",false,{"$f":"IF(F50=TRUE,28,IF(F50=FALSE,0,\" \"))","v":0},null,"D - Normal",false,{"$f":"IF(J50=TRUE,28,IF(J50=FALSE,0,\" \"))","v":0},null,"D - Normal",false,{"$f":"IF(N50=TRUE,28,IF(N50=FALSE,0,\" \"))","v":0},null,"D - Normal",false,{"$f":"IF(R50=TRUE,28,IF(R50=FALSE,0,\" \"))","v":0},null,"D - Normal",false,{"$f":"IF(V50=TRUE,28,IF(V50=FALSE,0,\" \"))","v":0},null,"D - Normal",false,{"$f":"IF(Z50=TRUE,28,IF(Z50=FALSE,0,\" \"))","v":0}]
["Day1, Meals SubTotal",null,{"$f":"SUM(C48:C50)","v":0},null,"Day2, Meals SubTotal",null,{"$f":"SUM(G48:G50)","v":0},null,"Day3, Meals SubTotal",null,{"$f":"SUM(K48:K50)","v":0},null,"Day4, Meals SubTotal",null,{"$f":"SUM(O48:O50)","v":0},null,"Day5, Meals SubTotal",null,{"$f":"SUM(S48:S50)","v":0},null,"Day5, Meals SubTotal",null,{"$f":"SUM(W48:W50)","v":0},null,"Day5, Meals SubTotal",null,{"$f":"SUM(AA48:AA50)","v":0}]
[]
["B - H/C",false,{"$f":"IF(B53=TRUE,2,IF(B53=FALSE,0,\" \"))","v":0},null,"B - H/C",false,{"$f":"IF(F53=TRUE,2,IF(F53=FALSE,0,\" \"))","v":0},null,"B - H/C",false,{"$f":"IF(J53=TRUE,2,IF(J53=FALSE,0,\" \"))","v":0},null,"B - H/C",false,{"$f":"IF(N53=TRUE,2,IF(N53=FALSE,0,\" \"))","v":0},null,"B - H/C",false,{"$f":"IF(R53=TRUE,2,IF(R53=FALSE,0,\" \"))","v":0},null,"B - H/C",false,{"$f":"IF(V53=TRUE,2,IF(V53=FALSE,0,\" \"))","v":0},null,"B - H/C",false,{"$f":"IF(Z53=TRUE,2,IF(Z53=FALSE,0,\" \"))","v":0}]
["L - H/C",false,{"$f":"IF(B54=TRUE,3,IF(B54=FALSE,0,\" \"))","v":0},null,"L - H/C",false,{"$f":"IF(F54=TRUE,3,IF(F54=FALSE,0,\" \"))","v":0},null,"L - H/C",false,{"$f":"IF(J54=TRUE,3,IF(J54=FALSE,0,\" \"))","v":0},null,"L - H/C",false,{"$f":"IF(N54=TRUE,3,IF(N54=FALSE,0,\" \"))","v":0},null,"L - H/C",false,{"$f":"IF(R54=TRUE,3,IF(R54=FALSE,0,\" \"))","v":0},null,"L - H/C",false,{"$f":"IF(V54=TRUE,3,IF(V54=FALSE,0,\" \"))","v":0},null,"L - H/C",false,{"$f":"IF(Z54=TRUE,3,IF(Z54=FALSE,0,\" \"))","v":0}]
["D - H/C",false,{"$f":"IF(B55=TRUE,5,IF(B55=FALSE,0,\" \"))","v":0},null,"D - H/C",false,{"$f":"IF(F55=TRUE,5,IF(F55=FALSE,0,\" \"))","v":0},null,"D - H/C",false,{"$f":"IF(J55=TRUE,5,IF(J55=FALSE,0,\" \"))","v":0},null,"D - H/C",false,{"$f":"IF(N55=TRUE,5,IF(N55=FALSE,0,\" \"))","v":0},null,"D - H/C",false,{"$f":"IF(R55=TRUE,5,IF(R55=FALSE,0,\" \"))","v":0},null,"D - H/C",false,{"$f":"IF(V55=TRUE,5,IF(V55=FALSE,0,\" \"))","v":0},null,"D - H/C",false,{"$f":"IF(Z55=TRUE,5,IF(Z55=FALSE,0,\" \"))","v":0}]
["Day1, H/C SubTotal",null,{"$f":"SUM(C53:C55)","v":0},null,"Day2, H/C SubTotal",null,{"$f":"SUM(G53:G55)","v":0},null,"Day3, H/C SubTotal",null,{"$f":"SUM(K53:K55)","v":0},null,"Day4, H/C SubTotal",null,{"$f":"SUM(O53:O55)","v":0},null,"Day5, H/C SubTotal",null,{"$f":"SUM(S53:S55)","v":0},null,"Day5, H/C SubTotal",null,{"$f":"SUM(W53:W55)","v":0},null,"Day5, H/C SubTotal",null,{"$f":"SUM(AA53:AA55)","v":0}]
[]
["Day1, Grand Total",null,{"$f":"SUM(C51+C56)","v":0},null,"Day2, Grand Total",null,{"$f":"SUM(G51+G56)","v":0},null,"Day3, Grand Total",null,{"$f":"SUM(K51+K56)","v":0},null,"Day4, Grand Total",null,{"$f":"SUM(O51+O56)","v":0},null,"Day5, Grand Total",null,{"$f":"SUM(S51+S56)","v":0},null,"Day5, Grand Total",null,{"$f":"SUM(W51+W56)","v":0},null,"Day5, Grand Total",null,{"$f":"SUM(AA51+AA56)","v":0},null,{"$f":"SUM(+S58+O58+K58+G58+C58+W58+AA58)","v":0}]
[]
[]
[]
[]
[null,"Conference Fees, Page 1",null,null,null,"Airline, Page 1"]
[null,"True / False Results",null,null,null,"True / False Results"]
[]
[null,2,null,null,null,2]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,false]

{"sheet":"- (2)","index":6,"n_rows":99,"n_cols":21,"rows_kept":99,"cut":false,"hidden":true,"merged":[[63,20,72,20],[1,20,10,20],[16,20,25,20],[32,20,41,20],[47,20,56,20]]}
["Page 1 Meal Math"]
["Day1, Meal Breakdown",null," ",null,"Day2, Meal Breakdown",null," ",null,"Day3, Meal Breakdown",null," ",null,"Day4, Meal Breakdown",null," ",null,"Day5, Meal Breakdown",null," ",null,"Combined Meals Grand Total"]
["B - Normal",false,{"$f":"IF(B3=TRUE,6,IF(B3=FALSE,0,\" \"))","v":0},null,"B - Normal",false,{"$f":"IF(F3=TRUE,6,IF(F3=FALSE,0,\" \"))","v":0},null,"B - Normal",false,{"$f":"IF(J3=TRUE,6,IF(J3=FALSE,0,\" \"))","v":0},null,"B - Normal",false,{"$f":"IF(N3=TRUE,6,IF(N3=FALSE,0,\" \"))","v":0},null,"B - Normal",false,{"$f":"IF(R3=TRUE,6,IF(R3=FALSE,0,\" \"))","v":0}]
["L - Normal",false,{"$f":"IF(B4=TRUE,8,IF(B4=FALSE,0,\" \"))","v":0},null,"L - Normal",false,{"$f":"IF(F4=TRUE,8,IF(F4=FALSE,0,\" \"))","v":0},null,"L - Normal",false,{"$f":"IF(J4=TRUE,8,IF(J4=FALSE,0,\" \"))","v":0},null,"L - Normal",false,{"$f":"IF(N4=TRUE,8,IF(N4=FALSE,0,\" \"))","v":0},null,"L - Normal",false,{"$f":"IF(R4=TRUE,8,IF(R4=FALSE,0,\" \"))","v":0}]
["D - Normal",false,{"$f":"IF(B5=TRUE,17,IF(B5=FALSE,0,\" \"))","v":0},null,"D - Normal",false,{"$f":"IF(F5=TRUE,17,IF(F5=FALSE,0,\" \"))","v":0},null,"D - Normal",false,{"$f":"IF(J5=TRUE,17,IF(J5=FALSE,0,\" \"))","v":0},null,"D - Normal",false,{"$f":"IF(N5=TRUE,17,IF(N5=FALSE,0,\" \"))","v":0},null,"D - Normal",false,{"$f":"IF(R5=TRUE,17,IF(R5=FALSE,0,\" \"))","v":0}]
["Day1, Meals SubTotal",null,{"$f":"SUM(C3:C5)","v":0},null,"Day2, Meals SubTotal",null,{"$f":"SUM(G3:G5)","v":0},null,"Day3, Meals SubTotal",null,{"$f":"SUM(K3:K5)","v":0},null,"Day4, Meals SubTotal",null,{"$f":"SUM(O3:O5)","v":0},null,"Day5, Meals SubTotal",null,{"$f":"SUM(S3:S5)","v":0}]
[]
["B - H/C",false,{"$f":"IF(B8=TRUE,4,IF(B8=FALSE,0,\" \"))","v":0},null,"B - H/C",false,{"$f":"IF(F8=TRUE,4,IF(F8=FALSE,0,\" \"))","v":0},null,"B - H/C",false,{"$f":"IF(J8=TRUE,4,IF(J8=FALSE,0,\" \"))","v":0},null,"B - H/C",false,{"$f":"IF(N8=TRUE,4,IF(N8=FALSE,0,\" \"))","v":0},null,"B - H/C",false,{"$f":"IF(R8=TRUE,4,IF(R8=FALSE,0,\" \"))","v":0}]
["L - H/C",false,{"$f":"IF(B9=TRUE,5,IF(B9=FALSE,0,\" \"))","v":0},null,"L - H/C",false,{"$f":"IF(F9=TRUE,5,IF(F9=FALSE,0,\" \"))","v":0},null,"L - H/C",false,{"$f":"IF(J9=TRUE,5,IF(J9=FALSE,0,\" \"))","v":0},null,"L - H/C",false,{"$f":"IF(N9=TRUE,5,IF(N9=FALSE,0,\" \"))","v":0},null,"L - H/C",false,{"$f":"IF(R9=TRUE,5,IF(R9=FALSE,0,\" \"))","v":0}]
["D - H/C",false,{"$f":"IF(B10=TRUE,11,IF(B10=FALSE,0,\" \"))","v":0},null,"D - H/C",false,{"$f":"IF(F10=TRUE,11,IF(F10=FALSE,0,\" \"))","v":0},null,"D - H/C",false,{"$f":"IF(J10=TRUE,11,IF(J10=FALSE,0,\" \"))","v":0},null,"D - H/C",false,{"$f":"IF(N10=TRUE,11,IF(N10=FALSE,0,\" \"))","v":0},null,"D - H/C",false,{"$f":"IF(R10=TRUE,11,IF(R10=FALSE,0,\" \"))","v":0}]
["Day1, H/C SubTotal",null,{"$f":"SUM(C8:C10)","v":0},null,"Day2, H/C SubTotal",null,{"$f":"SUM(G8:G10)","v":0},null,"Day3, H/C SubTotal",null,{"$f":"SUM(K8:K10)","v":0},null,"Day4, H/C SubTotal",null,{"$f":"SUM(O8:O10)","v":0},null,"Day5, H/C SubTotal",null,{"$f":"SUM(S8:S10)","v":0}]
[]
["Day1, Grand Total",null,{"$f":"SUM(C6+C11)","v":0},null,"Day2, Grand Total",null,{"$f":"SUM(G6+G11)","v":0},null,"Day3, Grand Total",null,{"$f":"SUM(K6+K11)","v":0},null,"Day4, Grand Total",null,{"$f":"SUM(O6+O11)","v":0},null,"Day5, Grand Total",null,{"$f":"SUM(S6+S11)","v":0},null,{"$f":"SUM(+S13+O13+K13+G13+C13)","v":0}]
[]
[]
["Page 2a Meal Math"]
["Day1, Meal Breakdown",null," ",null,"Day2, Meal Breakdown",null," ",null,"Day3, Meal Breakdown",null," ",null,"Day4, Meal Breakdown",null," ",null,"Day5, Meal Breakdown",null," ",null,"Combined Meals Grand Total"]
["B - Normal",false,{"$f":"IF(B18=TRUE,6,IF(B18=FALSE,0,\" \"))","v":0},null,"B - Normal",false,{"$f":"IF(F18=TRUE,6,IF(F18=FALSE,0,\" \"))","v":0},null,"B - Normal",false,{"$f":"IF(J18=TRUE,6,IF(J18=FALSE,0,\" \"))","v":0},null,"B - Normal",false,{"$f":"IF(N18=TRUE,6,IF(N18=FALSE,0,\" \"))","v":0},null,"B - Normal",false,{"$f":"IF(R18=TRUE,6,IF(R18=FALSE,0,\" \"))","v":0}]
["L - Normal",false,{"$f":"IF(B19=TRUE,8,IF(B19=FALSE,0,\" \"))","v":0},null,"L - Normal",false,{"$f":"IF(F19=TRUE,8,IF(F19=FALSE,0,\" \"))","v":0},null,"L - Normal",false,{"$f":"IF(J19=TRUE,8,IF(J19=FALSE,0,\" \"))","v":0},null,"L - Normal",false,{"$f":"IF(N19=TRUE,8,IF(N19=FALSE,0,\" \"))","v":0},null,"L - Normal",false,{"$f":"IF(R19=TRUE,8,IF(R19=FALSE,0,\" \"))","v":0}]
["D - Normal",false,{"$f":"IF(B20=TRUE,17,IF(B20=FALSE,0,\" \"))","v":0},null,"D - Normal",false,{"$f":"IF(F20=TRUE,17,IF(F20=FALSE,0,\" \"))","v":0},null,"D - Normal",false,{"$f":"IF(J20=TRUE,17,IF(J20=FALSE,0,\" \"))","v":0},null,"D - Normal",false,{"$f":"IF(N20=TRUE,17,IF(N20=FALSE,0,\" \"))","v":0},null,"D - Normal",false,{"$f":"IF(R20=TRUE,17,IF(R20=FALSE,0,\" \"))","v":0}]
["Day1, Meals SubTotal",null,{"$f":"SUM(C18:C20)","v":0},null,"Day2, Meals SubTotal",null,{"$f":"SUM(G18:G20)","v":0},null,"Day3, Meals SubTotal",null,{"$f":"SUM(K18:K20)","v":0},null,"Day4, Meals SubTotal",null,{"$f":"SUM(O18:O20)","v":0},null,"Day5, Meals SubTotal",null,{"$f":"SUM(S18:S20)","v":0}]
[]
["B - H/C",false,{"$f":"IF(B23=TRUE,4,IF(B23=FALSE,0,\" \"))","v":0},null,"B - H/C",false,{"$f":"IF(F23=TRUE,4,IF(F23=FALSE,0,\" \"))","v":0},null,"B - H/C",false,{"$f":"IF(J23=TRUE,4,IF(J23=FALSE,0,\" \"))","v":0},null,"B - H/C",false,{"$f":"IF(N23=TRUE,4,IF(N23=FALSE,0,\" \"))","v":0},null,"B - H/C",false,{"$f":"IF(R23=TRUE,4,IF(R23=FALSE,0,\" \"))","v":0}]
["L - H/C",false,{"$f":"IF(B24=TRUE,5,IF(B24=FALSE,0,\" \"))","v":0},null,"L - H/C",false,{"$f":"IF(F24=TRUE,5,IF(F24=FALSE,0,\" \"))","v":0},null,"L - H/C",false,{"$f":"IF(J24=TRUE,5,IF(J24=FALSE,0,\" \"))","v":0},null,"L - H/C",false,{"$f":"IF(N24=TRUE,5,IF(N24=FALSE,0,\" \"))","v":0},null,"L - H/C",false,{"$f":"IF(R24=TRUE,5,IF(R24=FALSE,0,\" \"))","v":0}]
["D - H/C",false,{"$f":"IF(B25=TRUE,11,IF(B25=FALSE,0,\" \"))","v":0},null,"D - H/C",false,{"$f":"IF(F25=TRUE,11,IF(F25=FALSE,0,\" \"))","v":0},null,"D - H/C",false,{"$f":"IF(J25=TRUE,11,IF(J25=FALSE,0,\" \"))","v":0},null,"D - H/C",false,{"$f":"IF(N25=TRUE,11,IF(N25=FALSE,0,\" \"))","v":0},null,"D - H/C",false,{"$f":"IF(R25=TRUE,11,IF(R25=FALSE,0,\" \"))","v":0}]
["Day1, H/C SubTotal",null,{"$f":"SUM(C23:C25)","v":0},null,"Day2, H/C SubTotal",null,{"$f":"SUM(G23:G25)","v":0},null,"Day3, H/C SubTotal",null,{"$f":"SUM(K23:K25)","v":0},null,"Day4, H/C SubTotal",null,{"$f":"SUM(O23:O25)","v":0},null,"Day5, H/C SubTotal",null,{"$f":"SUM(S23:S25)","v":0}]
[]
["Day1, Grand Total",null,{"$f":"SUM(C21+C26)","v":0},null,"Day2, Grand Total",null,{"$f":"SUM(G21+G26)","v":0},null,"Day3, Grand Total",null,{"$f":"SUM(K21+K26)","v":0},null,"Day4, Grand Total",null,{"$f":"SUM(O21+O26)","v":0},null,"Day5, Grand Total",null,{"$f":"SUM(S21+S26)","v":0},null,{"$f":"SUM(+S28+O28+K28+G28+C28)","v":0}]
[]
[]
[]
["Page 2b Meal Math"]
["Day1, Meal Breakdown",null," ",null,"Day2, Meal Breakdown",null," ",null,"Day3, Meal Breakdown",null," ",null,"Day4, Meal Breakdown",null," ",null,"Day5, Meal Breakdown",null," ",null,"Combined Meals Grand Total"]
["B - Normal",false,{"$f":"IF(B34=TRUE,6,IF(B34=FALSE,0,\" \"))","v":0},null,"B - Normal",false,{"$f":"IF(F34=TRUE,6,IF(F34=FALSE,0,\" \"))","v":0},null,"B - Normal",false,{"$f":"IF(J34=TRUE,6,IF(J34=FALSE,0,\" \"))","v":0},null,"B - Normal",false,{"$f":"IF(N34=TRUE,6,IF(N34=FALSE,0,\" \"))","v":0},null,"B - Normal",false,{"$f":"IF(R34=TRUE,6,IF(R34=FALSE,0,\" \"))","v":0}]
["L - Normal",false,{"$f":"IF(B35=TRUE,8,IF(B35=FALSE,0,\" \"))","v":0},null,"L - Normal",false,{"$f":"IF(F35=TRUE,8,IF(F35=FALSE,0,\" \"))","v":0},null,"L - Normal",false,{"$f":"IF(J35=TRUE,8,IF(J35=FALSE,0,\" \"))","v":0},null,"L - Normal",false,{"$f":"IF(N35=TRUE,8,IF(N35=FALSE,0,\" \"))","v":0},null,"L - Normal",false,{"$f":"IF(R35=TRUE,8,IF(R35=FALSE,0,\" \"))","v":0}]
["D - Normal",false,{"$f":"IF(B36=TRUE,17,IF(B36=FALSE,0,\" \"))","v":0},null,"D - Normal",false,{"$f":"IF(F36=TRUE,17,IF(F36=FALSE,0,\" \"))","v":0},null,"D - Normal",false,{"$f":"IF(J36=TRUE,17,IF(J36=FALSE,0,\" \"))","v":0},null,"D - Normal",false,{"$f":"IF(N36=TRUE,17,IF(N36=FALSE,0,\" \"))","v":0},null,"D - Normal",false,{"$f":"IF(R36=TRUE,17,IF(R36=FALSE,0,\" \"))","v":0}]
["Day1, Meals SubTotal",null,{"$f":"SUM(C34:C36)","v":0},null,"Day2, Meals SubTotal",null,{"$f":"SUM(G34:G36)","v":0},null,"Day3, Meals SubTotal",null,{"$f":"SUM(K34:K36)","v":0},null,"Day4, Meals SubTotal",null,{"$f":"SUM(O34:O36)","v":0},null,"Day5, Meals SubTotal",null,{"$f":"SUM(S34:S36)","v":0}]
[]
["B - H/C",false,{"$f":"IF(B39=TRUE,4,IF(B39=FALSE,0,\" \"))","v":0},null,"B - H/C",false,{"$f":"IF(F39=TRUE,4,IF(F39=FALSE,0,\" \"))","v":0},null,"B - H/C",false,{"$f":"IF(J39=TRUE,4,IF(J39=FALSE,0,\" \"))","v":0},null,"B - H/C",false,{"$f":"IF(N39=TRUE,4,IF(N39=FALSE,0,\" \"))","v":0},null,"B - H/C",false,{"$f":"IF(R39=TRUE,4,IF(R39=FALSE,0,\" \"))","v":0}]
["L - H/C",false,{"$f":"IF(B40=TRUE,5,IF(B40=FALSE,0,\" \"))","v":0},null,"L - H/C",false,{"$f":"IF(F40=TRUE,5,IF(F40=FALSE,0,\" \"))","v":0},null,"L - H/C",false,{"$f":"IF(J40=TRUE,5,IF(J40=FALSE,0,\" \"))","v":0},null,"L - H/C",false,{"$f":"IF(N40=TRUE,5,IF(N40=FALSE,0,\" \"))","v":0},null,"L - H/C",false,{"$f":"IF(R40=TRUE,5,IF(R40=FALSE,0,\" \"))","v":0}]
["D - H/C",false,{"$f":"IF(B41=TRUE,11,IF(B41=FALSE,0,\" \"))","v":0},null,"D - H/C",false,{"$f":"IF(F41=TRUE,11,IF(F41=FALSE,0,\" \"))","v":0},null,"D - H/C",false,{"$f":"IF(J41=TRUE,11,IF(J41=FALSE,0,\" \"))","v":0},null,"D - H/C",false,{"$f":"IF(N41=TRUE,11,IF(N41=FALSE,0,\" \"))","v":0},null,"D - H/C",false,{"$f":"IF(R41=TRUE,11,IF(R41=FALSE,0,\" \"))","v":0}]
["Day1, H/C SubTotal",null,{"$f":"SUM(C39:C41)","v":0},null,"Day2, H/C SubTotal",null,{"$f":"SUM(G39:G41)","v":0},null,"Day3, H/C SubTotal",null,{"$f":"SUM(K39:K41)","v":0},null,"Day4, H/C SubTotal",null,{"$f":"SUM(O39:O41)","v":0},null,"Day5, H/C SubTotal",null,{"$f":"SUM(S39:S41)","v":0}]
[]
["Day1, Grand Total",null,{"$f":"SUM(C37+C42)","v":0},null,"Day2, Grand Total",null,{"$f":"SUM(G37+G42)","v":0},null,"Day3, Grand Total",null,{"$f":"SUM(K37+K42)","v":0},null,"Day4, Grand Total",null,{"$f":"SUM(O37+O42)","v":0},null,"Day5, Grand Total",null,{"$f":"SUM(S37+S42)","v":0},null,{"$f":"SUM(+S44+O44+K44+G44+C44)","v":0}]
[]
[]
["Page 3a Meal Math"]
["Day1, Meal Breakdown",null," ",null,"Day2, Meal Breakdown",null," ",null,"Day3, Meal Breakdown",null," ",null,"Day4, Meal Breakdown",null," ",null,"Day5, Meal Breakdown",null," ",null,"Combined Meals Grand Total"]
["B - Normal",false,{"$f":"IF(B49=TRUE,6,IF(B49=FALSE,0,\" \"))","v":0},null,"B - Normal",false,{"$f":"IF(F49=TRUE,6,IF(F49=FALSE,0,\" \"))","v":0},null,"B - Normal",false,{"$f":"IF(J49=TRUE,6,IF(J49=FALSE,0,\" \"))","v":0},null,"B - Normal",false,{"$f":"IF(N49=TRUE,6,IF(N49=FALSE,0,\" \"))","v":0},null,"B - Normal",false,{"$f":"IF(R49=TRUE,6,IF(R49=FALSE,0,\" \"))","v":0}]
["L - Normal",false,{"$f":"IF(B50=TRUE,8,IF(B50=FALSE,0,\" \"))","v":0},null,"L - Normal",false,{"$f":"IF(F50=TRUE,8,IF(F50=FALSE,0,\" \"))","v":0},null,"L - Normal",false,{"$f":"IF(J50=TRUE,8,IF(J50=FALSE,0,\" \"))","v":0},null,"L - Normal",false,{"$f":"IF(N50=TRUE,8,IF(N50=FALSE,0,\" \"))","v":0},null,"L - Normal",false,{"$f":"IF(R50=TRUE,8,IF(R50=FALSE,0,\" \"))","v":0}]
["D - Normal",false,{"$f":"IF(B51=TRUE,17,IF(B51=FALSE,0,\" \"))","v":0},null,"D - Normal",false,{"$f":"IF(F51=TRUE,17,IF(F51=FALSE,0,\" \"))","v":0},null,"D - Normal",false,{"$f":"IF(J51=TRUE,17,IF(J51=FALSE,0,\" \"))","v":0},null,"D - Normal",false,{"$f":"IF(N51=TRUE,17,IF(N51=FALSE,0,\" \"))","v":0},null,"D - Normal",false,{"$f":"IF(R51=TRUE,17,IF(R51=FALSE,0,\" \"))","v":0}]
["Day1, Meals SubTotal",null,{"$f":"SUM(C49:C51)","v":0},null,"Day2, Meals SubTotal",null,{"$f":"SUM(G49:G51)","v":0},null,"Day3, Meals SubTotal",null,{"$f":"SUM(K49:K51)","v":0},null,"Day4, Meals SubTotal",null,{"$f":"SUM(O49:O51)","v":0},null,"Day5, Meals SubTotal",null,{"$f":"SUM(S49:S51)","v":0}]
[]
["B - H/C",false,{"$f":"IF(B54=TRUE,4,IF(B54=FALSE,0,\" \"))","v":0},null,"B - H/C",false,{"$f":"IF(F54=TRUE,4,IF(F54=FALSE,0,\" \"))","v":0},null,"B - H/C",false,{"$f":"IF(J54=TRUE,4,IF(J54=FALSE,0,\" \"))","v":0},null,"B - H/C",false,{"$f":"IF(N54=TRUE,4,IF(N54=FALSE,0,\" \"))","v":0},null,"B - H/C",false,{"$f":"IF(R54=TRUE,4,IF(R54=FALSE,0,\" \"))","v":0}]
["L - H/C",false,{"$f":"IF(B55=TRUE,5,IF(B55=FALSE,0,\" \"))","v":0},null,"L - H/C",false,{"$f":"IF(F55=TRUE,5,IF(F55=FALSE,0,\" \"))","v":0},null,"L - H/C",false,{"$f":"IF(J55=TRUE,5,IF(J55=FALSE,0,\" \"))","v":0},null,"L - H/C",false,{"$f":"IF(N55=TRUE,5,IF(N55=FALSE,0,\" \"))","v":0},null,"L - H/C",false,{"$f":"IF(R55=TRUE,5,IF(R55=FALSE,0,\" \"))","v":0}]
["D - H/C",false,{"$f":"IF(B56=TRUE,11,IF(B56=FALSE,0,\" \"))","v":0},null,"D - H/C",false,{"$f":"IF(F56=TRUE,11,IF(F56=FALSE,0,\" \"))","v":0},null,"D - H/C",false,{"$f":"IF(J56=TRUE,11,IF(J56=FALSE,0,\" \"))","v":0},null,"D - H/C",false,{"$f":"IF(N56=TRUE,11,IF(N56=FALSE,0,\" \"))","v":0},null,"D - H/C",false,{"$f":"IF(R56=TRUE,11,IF(R56=FALSE,0,\" \"))","v":0}]
["Day1, H/C SubTotal",null,{"$f":"SUM(C54:C56)","v":0},null,"Day2, H/C SubTotal",null,{"$f":"SUM(G54:G56)","v":0},null,"Day3, H/C SubTotal",null,{"$f":"SUM(K54:K56)","v":0},null,"Day4, H/C SubTotal",null,{"$f":"SUM(O54:O56)","v":0},null,"Day5, H/C SubTotal",null,{"$f":"SUM(S54:S56)","v":0}]
[]
["Day1, Grand Total",null,{"$f":"SUM(C52+C57)","v":0},null,"Day2, Grand Total",null,{"$f":"SUM(G52+G57)","v":0},null,"Day3, Grand Total",null,{"$f":"SUM(K52+K57)","v":0},null,"Day4, Grand Total",null,{"$f":"SUM(O52+O57)","v":0},null,"Day5, Grand Total",null,{"$f":"SUM(S52+S57)","v":0},null,{"$f":"SUM(+S59+O59+K59+G59+C59)","v":0}]
[]
[]
[]
["Page 3b Meal Math"]
["Day1, Meal Breakdown",null," ",null,"Day2, Meal Breakdown",null," ",null,"Day3, Meal Breakdown",null," ",null,"Day4, Meal Breakdown",null," ",null,"Day5, Meal Breakdown",null," ",null,"Combined Meals Grand Total"]
["B - Normal",false,{"$f":"IF(B65=TRUE,6,IF(B65=FALSE,0,\" \"))","v":0},null,"B - Normal",false,{"$f":"IF(F65=TRUE,6,IF(F65=FALSE,0,\" \"))","v":0},null,"B - Normal",false,{"$f":"IF(J65=TRUE,6,IF(J65=FALSE,0,\" \"))","v":0},null,"B - Normal",false,{"$f":"IF(N65=TRUE,6,IF(N65=FALSE,0,\" \"))","v":0},null,"B - Normal",false,{"$f":"IF(R65=TRUE,6,IF(R65=FALSE,0,\" \"))","v":0}]
["L - Normal",false,{"$f":"IF(B66=TRUE,8,IF(B66=FALSE,0,\" \"))","v":0},null,"L - Normal",false,{"$f":"IF(F66=TRUE,8,IF(F66=FALSE,0,\" \"))","v":0},null,"L - Normal",false,{"$f":"IF(J66=TRUE,8,IF(J66=FALSE,0,\" \"))","v":0},null,"L - Normal",false,{"$f":"IF(N66=TRUE,8,IF(N66=FALSE,0,\" \"))","v":0},null,"L - Normal",false,{"$f":"IF(R66=TRUE,8,IF(R66=FALSE,0,\" \"))","v":0}]
["D - Normal",false,{"$f":"IF(B67=TRUE,17,IF(B67=FALSE,0,\" \"))","v":0},null,"D - Normal",false,{"$f":"IF(F67=TRUE,17,IF(F67=FALSE,0,\" \"))","v":0},null,"D - Normal",false,{"$f":"IF(J67=TRUE,17,IF(J67=FALSE,0,\" \"))","v":0},null,"D - Normal",false,{"$f":"IF(N67=TRUE,17,IF(N67=FALSE,0,\" \"))","v":0},null,"D - Normal",false,{"$f":"IF(R67=TRUE,17,IF(R67=FALSE,0,\" \"))","v":0}]
["Day1, Meals SubTotal",null,{"$f":"SUM(C65:C67)","v":0},null,"Day2, Meals SubTotal",null,{"$f":"SUM(G65:G67)","v":0},null,"Day3, Meals SubTotal",null,{"$f":"SUM(K65:K67)","v":0},null,"Day4, Meals SubTotal",null,{"$f":"SUM(O65:O67)","v":0},null,"Day5, Meals SubTotal",null,{"$f":"SUM(S65:S67)","v":0}]
[]
["B - H/C",false,{"$f":"IF(B70=TRUE,4,IF(B70=FALSE,0,\" \"))","v":0},null,"B - H/C",false,{"$f":"IF(F70=TRUE,4,IF(F70=FALSE,0,\" \"))","v":0},null,"B - H/C",false,{"$f":"IF(J70=TRUE,4,IF(J70=FALSE,0,\" \"))","v":0},null,"B - H/C",false,{"$f":"IF(N70=TRUE,4,IF(N70=FALSE,0,\" \"))","v":0},null,"B - H/C",false,{"$f":"IF(R70=TRUE,4,IF(R70=FALSE,0,\" \"))","v":0}]
["L - H/C",false,{"$f":"IF(B71=TRUE,5,IF(B71=FALSE,0,\" \"))","v":0},null,"L - H/C",false,{"$f":"IF(F71=TRUE,5,IF(F71=FALSE,0,\" \"))","v":0},null,"L - H/C",false,{"$f":"IF(J71=TRUE,5,IF(J71=FALSE,0,\" \"))","v":0},null,"L - H/C",false,{"$f":"IF(N71=TRUE,5,IF(N71=FALSE,0,\" \"))","v":0},null,"L - H/C",false,{"$f":"IF(R71=TRUE,5,IF(R71=FALSE,0,\" \"))","v":0}]
["D - H/C",false,{"$f":"IF(B72=TRUE,11,IF(B72=FALSE,0,\" \"))","v":0},null,"D - H/C",false,{"$f":"IF(F72=TRUE,11,IF(F72=FALSE,0,\" \"))","v":0},null,"D - H/C",false,{"$f":"IF(J72=TRUE,11,IF(J72=FALSE,0,\" \"))","v":0},null,"D - H/C",false,{"$f":"IF(N72=TRUE,11,IF(N72=FALSE,0,\" \"))","v":0},null,"D - H/C",false,{"$f":"IF(R72=TRUE,11,IF(R72=FALSE,0,\" \"))","v":0}]
["Day1, H/C SubTotal",null,{"$f":"SUM(C70:C72)","v":0},null,"Day2, H/C SubTotal",null,{"$f":"SUM(G70:G72)","v":0},null,"Day3, H/C SubTotal",null,{"$f":"SUM(K70:K72)","v":0},null,"Day4, H/C SubTotal",null,{"$f":"SUM(O70:O72)","v":0},null,"Day5, H/C SubTotal",null,{"$f":"SUM(S70:S72)","v":0}]
[]
["Day1, Grand Total",null,{"$f":"SUM(C68+C73)","v":0},null,"Day2, Grand Total",null,{"$f":"SUM(G68+G73)","v":0},null,"Day3, Grand Total",null,{"$f":"SUM(K68+K73)","v":0},null,"Day4, Grand Total",null,{"$f":"SUM(O68+O73)","v":0},null,"Day5, Grand Total",null,{"$f":"SUM(S68+S73)","v":0},null,{"$f":"SUM(+S75+O75+K75+G75+C75)","v":0}]
[]
[]
[]
[null,"Conference Fees, Page 1",null,null,null,"Airline, Page 1"]
[null,"True / False Results",null,null,null,"True / False Results"]
[]
[null,2,null,null,null,2]
[]
[]
[null,"Conference Fees, Page 2a, b",null,null,null,"Airline, Page 2a, b"]
[null,"True / False Results",null,null,null,"True / False Results"]
[]
[null,2,null,null,null,2]
[]
[null,2,null,null,null,2]
[]
[]
[null,"Conference Fees, Page 3a, b",null,null,null,"Airline, Page 3a, b"]
[null,"True / False Results",null,null,null,"True / False Results"]
[]
[]
[null,2,null,null,null,2]
[]
[null,2,null,null,null,2]