{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["Main","CMU Bus Card Rec","Travel Expenses (2-3)","Travel Expenses (4-5)","Accounting Allocations","Doc. Form for Entertainment","Missing Receipt","S&E>500 and Entertainment Exp","Travel Expenses (6-7)","Travel Expenses (8-9)","Doc. Form for Entertainment (2)","Doc. Form for Entertainment (3)","EnableMacros","-","- (2)"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":10,"comments":1,"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":"Main","index":0,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[[1,1,1,9]]}
[]
[null,"Welcome to the CMU Business Card Reconciliation Form "]

{"sheet":"CMU Bus Card Rec","index":1,"n_rows":56,"n_cols":17,"rows_kept":56,"cut":false,"hidden":false,"merged":[[11,1,11,4],[25,6,25,7],[9,0,20,0],[27,0,27,7],[31,0,33,0],[46,1,47,4],[46,0,48,0],[41,0,44,0],[42,1,44,9],[41,3,41,9],[43,14,44,17],[36,4,36,5],[45,14,45,17],[38,4,38,5],[39,4,39,5],[40,4,40,5],[40,6,40,8],[38,6,38,8],[36,6,36,8],[11,10,11,12],[21,11,22,11],[21,10,22,10],[21,1,22,2],[15,2,15,4],[20,2,20,4],[19,2,19,4],[21,6,22,7],[21,9,22,9],[16,2,16,4],[34,0,40,0],[22,0,26,0],[28,0,30,0],[6,10,10,10],[9,9,10,9],[9,7,10,7],[9,6,10,6],[7,9,8,9],[7,8,8,8],[9,8,10,8],[0,11,0,12],[1,11,1,12],[2,11,2,12],[6,12,10,12],[6,11,10,11],[4,1,5,12],[7,5,8,5],[7,6,8,6],[7,7,8,7],[2,7,2,9],[0,7,0,9],[1,7,1,9],[3,1,3,12],[34,4,34,5],[28,5,29,5],[28,1,29,4],[30,6,30,7],[23,4,23,5],[24,4,24,5],[26,4,26,5],[41,1,41,2],[53,5,53,6],[45,1,45,9],[53,1,53,3],[51,1,51,3],[52,9,52,12],[46,5,47,5],[42,10,42,11],[46,9,47,9],[43,10,43,11],[46,6,47,8],[51,9,51,12],[50,9,50,12],[46,12,47,12],[41,10,41,11],[28,9,29,10],[45,10,45,11],[37,6,37,8],[44,10,44,11],[35,6,35,8],[51,0,55,0],[54,9,54,12],[49,0,50,0],[50,1,50,3],[54,1,54,6],[50,5,50,6],[53,9,53,12],[55,8,55,12],[21,8,22,8],[21,3,22,3],[28,6,29,7],[32,2,32,12],[21,4,22,5],[24,6,24,7],[21,12,22,12],[26,6,26,7],[0,0,0,5],[2,1,2,4],[1,0,1,5],[14,2,14,4],[7,0,8,0],[13,2,13,4],[9,5,10,5],[7,1,8,4],[3,0,5,0],[9,1,10,4],[12,2,12,4],[30,9,30,10],[52,1,52,3],[51,5,51,6],[52,5,52,6],[48,1,48,4],[39,6,39,8],[46,10,47,11],[48,10,48,12],[17,2,17,4],[18,2,18,4],[37,4,37,5],[35,4,35,5],[33,2,33,12],[31,1,31,12],[25,4,25,5],[34,6,34,8],[28,11,30,12],[28,8,29,8],[23,6,23,7]]}
["Central Michigan University's Business Card",null,null,null,null,null,"Employee"]
["Reconciliation Form",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,"Sum of Expenses","PNC Statement Amount Charged","Total"]
[null,"Time of Departure",null,null,null,"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,null,null," "]
["DAILY TRAVEL EXPENSES","Time of Return",null,null,null,"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(SUM(F13:J13)=0,\" \",(SUM(F13:J13)))","v":" "},null,{"$f":"IF(SUM(F13:J13)+L13=0,\" \",IF(SUM(F13:J13)=0,L13,K13-L13))","v":" "}]
[null,3," Lodging*",null,null,null,null,null,null,null,{"$f":"IF(SUM(F14:J14)=0,\" \",(SUM(F14:J14)))","v":" "},null,{"$f":"IF(SUM(F14:J14)+L14=0,\" \",IF(SUM(F14:J14)=0,L14,K14-L14))","v":" "},null,null,null," "]
[null,4," Lodging Tips",null,null,null,null,null,null,null,{"$f":"IF(SUM(F15:J15)=0,\" \",(SUM(F15:J15)))","v":" "},null," ",null,null,null," "]
[null,5," Taxi, Bus*",null,null,null,null,null,null,null," ",null," "]
[null,6," Parking, Tolls*",null,null,null,null,null,null,null," ",null," "]
[null,7," Rental Car Expense*",null,null,null,null,null,null,null," ",null," "]
[null,8," Conference Fees",null,null,null,null,null,null,null," ",null," "]
[null,9," Business Calls (non-personal)",null,null,null,null,null,null,null," ",null," "]
[null,10,null,null,null,null,null,null,null,null," ",null," "]
["C","Mode of Transportation",null,"Date","Departure Location",null,"Arrival Location",null,"Personal Car Mileage","Sum of Mileage","Sum of Expenses Paid","Statement Amount Charged","Total"]
["TRANSPORT"]
[null,1,"Click Here",null,null,null,null,null,null,{"$f":"IF(I24*0.255=0,\" \",(I24*0.655))","v":" "},null,null,{"$f":"IF(I24*0.655+K24-L24=0, \" \", I24*0.655+K24-L24)","v":" "}," ",{"$f":"IF(ISNUMBER(N24),IF(ISNUMBER(J24),\"Only enter an mileage or dollar amount.\",\"\"),\"\")","v":""},{"$f":"IF(ISNUMBER(O24),IF(ISNUMBER(L24),\"Only enter an mileage or dollar amount.\",\"\"),\"\")","v":""}]
[null,2,"Click Here",null,null,null,null,null,null,{"$f":"IF(I25*0.255=0,\" \",(I25*0.655))","v":" "},null,null,{"$f":"IF(I25*0.655+K25-L25=0, \" \", I25*0.655+K25-L25)","v":" "}]
[null,3,"Click Here",null,null,null,null,null,null," ",null,null," "]
[null,4,"Click Here",null,null,null,null,null,null," ",null,null," "," "]
["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},{"$f":"IF(SUM(L24:L27)=0,\" \",(SUM(L24:L27)))","v":" "},{"$f":"IF(SUM(M24:M27)=0, \" \", (SUM(M24:M27)))","v":" "}]
["BILLING","Are any charges related to this trip, billed on a prior month ?",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,1,"S&E over $500"]
[null,2,"Entertainment/Hosting Activities(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,"Description",null,null,"Entertain./ Hosting Attachment","Sum of Expenses Paid","Statement Amount Charged","Total"]
[null,1,"Click Here",null,null,null,null,null,null,"#",null,null,{"$f":"IF(K36-L36=0, \" \", (K36-L36))","v":" "}]
[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(K36:K41)+SUM(K13:K21)+J28+K28+SUM('S&E>500 and Entertainment Exp'!K10:K59)+'Travel Expenses (2-3)'!M32+'Travel Expenses (2-3)'!M65+'Travel Expenses (4-5)'!M32+'Travel Expenses (4-5)'!M65+'Travel Expenses (6-7)'!M32+'Travel Expenses (6-7)'!M65+'Travel Expenses (8-9)'!M32+'Travel Expenses (8-9)'!M65)","v":0},null,"<<Adds in Additional Travel Expense sheets"]
[null,null,null,null,null,null,null,null,null,null,"I Total Documented Credit Card Purchases",null,{"$f":"(SUM(L13:L21)+SUM(L36:L41)+SUM('S&E>500 and Entertainment Exp'!L10:L59)+SUM(L24:L27)+SUM('Travel Expenses (2-3)'!L13:L21)+SUM('Travel Expenses (2-3)'!L24:L27)+SUM('Travel Expenses (2-3)'!L46:L54)+SUM('Travel Expenses (2-3)'!L57:L60)+SUM('Travel Expenses (4-5)'!L13:L21)+SUM('Travel Expenses (4-5)'!L24:L27)+SUM('Travel Expenses (4-5)'!L46:L54)+SUM('Travel Expenses (4-5)'!L57:L60)+SUM('Travel Expenses (6-7)'!L13:L21)+SUM('Travel Expenses (6-7)'!L24:L27)+SUM('Travel Expenses (6-7)'!L46:L54)+SUM('Travel Expenses (6-7)'!L57:L60)+SUM('Travel Expenses (8-9)'!L13:L21)+SUM('Travel Expenses (8-9)'!L24:L27)+SUM('Travel Expenses (8-9)'!L46:L54)+SUM('Travel Expenses (8-9)'!L57:L60))","v":0},null,"<<Adds in Additional Travel Expense sheets"]
[null,null,null,null,null,null,null,null,null,null,"Optional - Remaining Credit Card Expenses",null,null,null,"<<Optional - Enter remaining credit card expenses that are not reported on form"]
[null,null,null,null,null,null,null,null,null,null,"Total Paid on Credit Card",null,{"$f":"IF(M44=0,,M43+M44)","v":0}]
["F","NOTE: I AGREE ANY INELIGIBLE EXPENSES WILL BE PAYROLL DEDUCTED",null,null,null,null,null,null,null,null,"J  Total Amount NOT being reimbursed by Department ",null,null,null,"<<Enter amount that Department is deducting as not a covered expense charged."]
["APPROVAL","EMPLOYEE'S SIGNATURE (REQUIRED)**",null,null,null,"DATE","SENIOR ADMINISTRATOR SIGNATURE (REQUIRED)**",null,null,"DATE","K Reimbursement Claim (Taxable meals will be included on paycheck.)",null,{"$f":"IF(ISERROR(+M42-M43-M46), \" \", (+M42-M43-M46))","v":0},null,"Form Revised 5/8/2014"]
[]
[null,"ADDITIONAL SIGNATURE (IF APPLICABLE)**",null,null,null,"DATE","SENIOR ADMINISTRATOR PRINT NAME  (REQUIRED)**",null,null,null,"Note: If above amount is positive, please indicate accounting allocations below otherwise, indicate cost center only.",null,null,null,null,null," "]
["G","DEPARTMENT ACCOUNTING ALLOCATIONS (Debit = Department will be charged, Credit = Department Refund Amount)",null,null,null,null,null,null,null,null,null,null,null,null,"CR=Employee overspent, NO REFUND"]
[null,"COST CENTER (or WBS) NAME",null,null,"CostCtr/WBS #","INT ORDER",null,"G/L","AMOUNT","DESCRIPTION (50 Characters Per Line)",null,null,null,null,"DB=Employee Reimbursement Due"]
["FINANCIAL",null,null,null,null,null,null,null,null,null,null,null,null,null,"<<Special Allocations will only be made for reimbursements (positive amounts)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"<<If Negative amount, 693300 will be charged by default"]
[]
[null,"* RECEIPTS TO BE ATTACHED",null,null,null,null,null,"TOTAL",{"$f":"IF(SUM(I52:I54)+SUM('Accounting Allocations'!I8:I25)=0,\" \",SUM(I52:I54)+SUM('Accounting Allocations'!I8:I25))","v":" "},"Submit all forms to WA204 774-3525 or 774-6944"]
[null,"** IT IS RECOMMENDED THAT SIGNATURES ARE IN BLUE INK",null,null,null,null,null,null,null,null,null,null,null,null,"This form will be submitted monthly with a copy of the credit card statement & original receipts attached."]

{"sheet":"Travel Expenses (2-3)","index":2,"n_rows":65,"n_cols":16,"rows_kept":65,"cut":false,"hidden":false,"merged":[[27,0,27,7],[60,0,60,7],[0,13,64,13],[7,0,8,0],[2,11,2,12],[16,2,16,4],[13,2,13,4],[6,12,10,12],[2,7,2,9],[3,0,5,0],[0,0,0,5],[2,1,2,4],[1,0,1,5],[3,1,3,12],[0,11,0,12],[1,11,1,12],[0,7,0,9],[1,7,1,9],[9,8,10,8],[9,9,10,9],[11,1,11,4],[9,7,10,7],[6,11,10,11],[4,1,5,12],[7,7,8,7],[12,2,12,4],[20,2,20,4],[14,2,14,4],[17,2,17,4],[18,2,18,4],[19,2,19,4],[15,2,15,4],[9,0,20,0],[21,6,22,7],[21,4,22,5],[7,8,8,8],[9,5,10,5],[9,1,10,4],[9,6,10,6],[7,1,8,4],[7,5,8,5],[7,6,8,6],[23,4,23,5],[24,4,24,5],[25,4,25,5],[6,10,10,10],[21,8,22,8],[24,6,24,7],[25,6,25,7],[21,9,22,9],[23,6,23,7],[7,9,8,9],[31,0,31,11],[11,10,11,12],[21,11,22,11],[21,10,22,10],[26,6,26,7],[26,4,26,5],[21,1,22,2],[22,0,26,0],[21,12,22,12],[28,0,30,0],[28,11,30,12],[30,6,30,7],[30,9,30,10],[28,8,29,8],[28,1,29,4],[28,5,29,5],[28,6,29,7],[28,9,29,10],[33,11,33,12],[34,0,34,5],[34,7,34,9],[34,11,34,12],[33,0,33,5],[33,7,33,9],[35,1,35,4],[35,7,35,9],[35,11,35,12],[36,0,38,0],[36,1,36,12],[37,1,38,12],[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,8,41,8],[40,9,41,9],[42,0,53,0],[42,1,43,4],[52,2,52,4],[53,2,53,4],[44,10,44,12],[45,2,45,4],[46,2,46,4],[47,2,47,4],[48,2,48,4],[49,2,49,4],[50,2,50,4],[51,2,51,4],[42,7,43,7],[42,8,43,8],[42,9,43,9],[44,1,44,4],[39,10,43,10],[39,11,43,11],[42,5,43,5],[42,6,43,6],[55,0,59,0],[56,4,56,5],[56,6,56,7],[57,4,57,5],[57,6,57,7],[58,4,58,5],[58,6,58,7],[59,4,59,5],[59,6,59,7],[54,4,55,5],[61,5,62,5],[61,6,62,7],[61,8,62,8],[54,12,55,12],[54,6,55,7],[54,8,55,8],[54,9,55,9],[54,10,55,10],[54,11,55,11],[21,3,22,3],[54,3,55,3],[64,0,64,11],[61,9,62,10],[61,11,63,12],[63,6,63,7],[63,9,63,10],[54,1,55,2],[61,0,63,0],[61,1,62,4]]}
["Central Michigan University's Business Card",null,null,null,null,null,"Employee",{"$f":"IF(ISBLANK('CMU Bus Card Rec'!H1:J1), \" \", ('CMU Bus Card Rec'!H1:J1))","v":" "},null,null,null,{"$f":"IF(ISBLANK('CMU Bus Card Rec'!L1:M1), \" \", ('CMU Bus Card Rec'!L1:M1))","v":" "},null,{"$f":"UPPER(H1) &\":\" &\"  \"&\"ADDITIONAL TRAVEL EXPENSE FORM 2 - 3\"","v":" :  ADDITIONAL TRAVEL EXPENSE FORM 2 - 3"}]
["Reconciliation Form",null,null,null,null,null,"Office Addr",{"$f":"IF(ISBLANK('CMU Bus Card Rec'!H2:J2), \" \", ('CMU Bus Card Rec'!H2:J2))","v":" "},null,null,"Campus ID",{"$f":"IF(ISBLANK('CMU Bus Card Rec'!L2:M2), \" \", ('CMU Bus Card Rec'!L2:M2))","v":" "}]
["A","Officially working out of home:",null,null,null,null,"Dept Name",{"$f":"IF(ISBLANK('CMU Bus Card Rec'!H3:J3), \" \", ('CMU Bus Card Rec'!H3:J3))","v":" "},null,null,"Phone #",{"$f":"IF(ISBLANK('CMU Bus Card Rec'!L3:M3), \" \", ('CMU Bus Card Rec'!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,"Sum of Expenses","PNC  Statement Amount Charged","Total"]
[null,"Time of Departure",null,null,null,"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"]
[]
[null,"1. Employee Travel Meals:                                                                                           a. Select meals claimed (B, L, D).                                                                            b.  Select if High Cost City ",null,null,null," "," "," "," "," "]
[null,2,"Employee Travel Meals subtotaled by day*",null,null,{"$f":"IF('-'!C28=0, \" \", ('-'!C28))","v":" "},{"$f":"IF('-'!G28=0, \" \", ('-'!G28))","v":" "},{"$f":"IF('-'!K28=0, \" \", ('-'!K28))","v":" "},{"$f":"IF('-'!O28=0, \" \", ('-'!O28))","v":" "},{"$f":"IF('-'!S28=0, \" \", ('-'!S28))","v":" "},{"$f":"IF(SUM(F13:J13)=0,\" \",(SUM(F13:J13)))","v":" "},null,{"$f":"IF(SUM(F13:J13)+L13=0,\" \",IF(SUM(F13:J13)=0,L13,K13-L13))","v":" "}]
[null,2," Lodging*",null,null,null,null,null,null,null,{"$f":"IF(SUM(F14:J14)=0,\" \",(SUM(F14:J14)))","v":" "},null,{"$f":"IF(SUM(F14:J14)+L14=0,\" \",IF(SUM(F14:J14)=0,L14,K14-L14))","v":" "}]
[null,3," Lodging Tips",null,null,null,null,null,null,null,{"$f":"IF(SUM(F15:J15)=0,\" \",(SUM(F15:J15)))","v":" "},null," "]
[null,4," Taxi, Bus*",null,null,null,null,null,null,null," ",null," "]
[null,5," Parking, Tolls*",null,null,null,null,null,null,null," ",null," "]
[null,6," Rental Car Expense*",null,null,null,null,null,null,null," ",null," "]
[null,7," Conference Fees",null,null,null,null,null,null,null," ",null," ",null,null," "]
[null,8," Business Calls (non-personal)",null,null,null,null,null,null,null," ",null," ",null,null," "]
[null,9,null,null,null,null,null,null,null,null," ",null," "]
["C","Mode of Transportation",null,"Date","Departure Location",null,"Arrival Location",null,"Personal Car Mileage","Sum of Mileage","Sum of Expenses Paid","Statement Amount Charged","Total"]
["TRANSPORT"]
[null,1,"Click Here",null,null,null,null,null,null,{"$f":"IF(I24*0.655=0,\" \",(I24*0.655))","v":" "},null,null,{"$f":"IF(I24*0.655+K24-L24=0, \" \", I24*0.655+K24-L24)","v":" "}]
[null,2,"Click Here",null,null,null,null,null,null,{"$f":"IF(I25*0.655=0,\" \",(I25*0.655))","v":" "},null,null,{"$f":"IF(I25*0.655+K25-L25=0, \" \", I25*0.655+K25-L25)","v":" "}]
[null,3,"Click Here",null,null,null,null,null,null," ",null,null," "]
[null,4,"Click Here",null,null,null,null,null,null," ",null,null," "]
["Transportation Total:",null,null,null,null,null,null,null,{"$f":"IF(SUM(I24:I27)=0,\" \",(SUM(I24:I27)))","v":" "},{"$f":"IF(SUM(J24:J27)=0, 0,(SUM(J24:J27)))","v":0},{"$f":"(SUM(K24:K27))","v":0},{"$f":"(SUM(L24:L27))","v":0},{"$f":"IF(SUM(M24:M27)=0, \" \", (SUM(M24:M27)))","v":" "}]
["BILLING","Are any charges related to this trip, billed on a prior month ?",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":"IF(ISERROR(K28+J28+SUM(K13:K21)),\"blah\",(K28+J28+SUM(K13:K21)))","v":0}]
[]
["Central Michigan University's Business Card",null,null,null,null,null,"Employee",{"$f":"IF(ISBLANK('CMU Bus Card Rec'!H1:J1), \" \", ('CMU Bus Card Rec'!H1:J1))","v":" "}]
["Reconciliation Form",null,null,null,null,null,"Office Addr",{"$f":"IF(ISBLANK('CMU Bus Card Rec'!H2:J2),\" \",('CMU Bus Card Rec'!H2:J2))","v":" "},null,null,"Campus ID",{"$f":"IF(ISBLANK('CMU Bus Card Rec'!L2:M2), \" \", ('CMU Bus Card Rec'!L2:M2))","v":" "}]
["A","Officially working out of home:",null,null,null,null,"Dept Name",{"$f":"IF(ISBLANK('CMU Bus Card Rec'!H3:J3), \" \", ('CMU Bus Card Rec'!H3:J3))","v":" "},null,null,"Phone #",{"$f":"IF(ISBLANK('CMU Bus Card Rec'!L3:M3), \" \", ('CMU Bus Card Rec'!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,"Sum of Expenses","PNC Statement Amount Charged","Total"]
[null,"Time of Departure",null,null,null,"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"]
[]
[null,"1. Employee Travel Meals:                                                                                           a. Select meals claimed (B, L, D).                                                                            b.  Select if High Cost City ",null,null,null," "," "," "," "," "]
[null,2,"Employee Travel Meals subtotaled by day*",null,null,{"$f":"IF('-'!C44=0, \" \", '-'!C44)","v":" "},{"$f":"IF('-'!G44=0, \" \", '-'!G44)","v":" "},{"$f":"IF('-'!K44=0, \" \", '-'!K44)","v":" "},{"$f":"IF('-'!O44=0, \" \", '-'!O44)","v":" "},{"$f":"IF('-'!S44=0, \" \", '-'!S44)","v":" "},{"$f":"IF(SUM(F46:J46)=0,\" \",(SUM(F46:J46)))","v":" "},null,{"$f":"IF(SUM(F46:J46)+L46=0,\" \",IF(SUM(F46:J46)=0,L46,K46-L46))","v":" "}]
[null,2," Lodging*",null,null,null,null,null,null,null,{"$f":"IF(SUM(F47:J47)=0,\" \",(SUM(F47:J47)))","v":" "},null,{"$f":"IF(SUM(F47:J47)+L47=0,\" \",IF(SUM(F47:J47)=0,L47,K47-L47))","v":" "}]
[null,3," Lodging Tips",null,null,null,null,null,null,null,{"$f":"IF(SUM(F48:J48)=0,\" \",(SUM(F48:J48)))","v":" "},null," "]
[null,4," Taxi, Bus*",null,null,null,null,null,null,null," ",null," "]
[null,5," Parking, Tolls*",null,null,null,null,null,null,null," ",null," "]
[null,6," Rental Car Expense*",null,null,null,null,null,null,null," ",null," "]
[null,7," Conference Fees",null,null,null,null,null,null,null," ",null," "]
[null,8," Business Calls (non-personal)",null,null,null,null,null,null,null," ",null," "]
[null,9,null,null,null,null,null,null,null,null," ",null," "]
["C","Mode of Transportation",null,"Date","Departure Location",null,"Arrival Location",null,"Personal Car Mileage","Sum of Mileage","Sum of Expenses Paid","Statement Amount Charged","Total"]
["TRANSPORT"]
[null,1,"Click Here",null,null,null,null,null,null,{"$f":"IF(I57*0.655=0,\" \",(I57*0.655))","v":" "},null,null,{"$f":"IF(I57*0.655+K57-L57=0, \" \", I57*0.655+K57-L57)","v":" "}]
[null,2,"Click Here",null,null,null,null,null,null,{"$f":"IF(I58*0.655=0,\" \",(I58*0.655))","v":" "},null,null,{"$f":"IF(I58*0.655+K58-L58=0, \" \", I58*0.655+K58-L58)","v":" "}]
[null,3,"Click Here",null,null,null,null,null,null," ",null,null," "]
[null,4,"Click Here",null,null,null,null,null,null," ",null,null," "]
["Transportation Total:",null,null,null,null,null,null,null,{"$f":"IF(SUM(I57:I60)=0,\" \",(SUM(I57:I60)))","v":" "},{"$f":"(SUM(J57:J60))","v":0},{"$f":"(SUM(K57:K60))","v":0},{"$f":"(SUM(L57:L60))","v":0},{"$f":"IF(SUM(M57:M60)=0, \" \", (SUM(M57:M60)))","v":" "}]
["BILLING","Are any charges related to this trip, billed on a prior month ?",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":"IF(ISERROR(K61+J61+SUM(K46:K54)),SUM(K46:K54),K61+J61+SUM(K46:K54))","v":0}]

{"sheet":"Travel Expenses (4-5)","index":3,"n_rows":65,"n_cols":14,"rows_kept":65,"cut":false,"hidden":false,"merged":[[27,0,27,7],[54,4,55,5],[54,6,55,7],[54,1,55,2],[50,2,50,4],[51,2,51,4],[52,2,52,4],[53,2,53,4],[42,5,43,5],[42,6,43,6],[54,8,55,8],[64,0,64,11],[61,9,62,10],[61,11,63,12],[63,6,63,7],[63,9,63,10],[61,0,63,0],[61,1,62,4],[61,5,62,5],[61,6,62,7],[61,8,62,8],[55,0,59,0],[56,4,56,5],[56,6,56,7],[57,4,57,5],[57,6,57,7],[58,4,58,5],[58,6,58,7],[59,4,59,5],[59,6,59,7],[54,9,55,9],[54,10,55,10],[54,11,55,11],[42,7,43,7],[42,8,43,8],[42,9,43,9],[39,10,43,10],[39,11,43,11],[44,10,44,12],[54,12,55,12],[40,8,41,8],[42,0,53,0],[48,2,48,4],[49,2,49,4],[45,2,45,4],[46,2,46,4],[47,2,47,4],[42,1,43,4],[35,7,35,9],[35,11,35,12],[44,1,44,4],[39,12,43,12],[40,9,41,9],[40,0,41,0],[40,1,41,4],[40,5,41,5],[40,6,41,6],[40,7,41,7],[36,0,38,0],[36,1,36,12],[37,1,38,12],[33,11,33,12],[34,0,34,5],[34,7,34,9],[34,11,34,12],[33,0,33,5],[33,7,33,9],[35,1,35,4],[28,0,30,0],[28,1,29,4],[28,5,29,5],[28,6,29,7],[28,9,29,10],[28,11,30,12],[30,6,30,7],[30,9,30,10],[28,8,29,8],[31,0,31,11],[11,10,11,12],[21,11,22,11],[21,10,22,10],[26,6,26,7],[26,4,26,5],[21,1,22,2],[22,0,26,0],[21,12,22,12],[23,4,23,5],[24,4,24,5],[25,4,25,5],[6,10,10,10],[21,8,22,8],[24,6,24,7],[25,6,25,7],[21,9,22,9],[23,6,23,7],[7,9,8,9],[7,7,8,7],[9,0,20,0],[21,6,22,7],[21,4,22,5],[7,8,8,8],[9,5,10,5],[9,1,10,4],[9,6,10,6],[7,1,8,4],[7,5,8,5],[7,6,8,6],[20,2,20,4],[14,2,14,4],[17,2,17,4],[18,2,18,4],[19,2,19,4],[15,2,15,4],[1,7,1,9],[9,8,10,8],[9,9,10,9],[11,1,11,4],[9,7,10,7],[12,2,12,4],[3,0,5,0],[6,11,10,11],[4,1,5,12],[0,0,0,5],[2,1,2,4],[1,0,1,5],[3,1,3,12],[0,11,0,12],[1,11,1,12],[0,7,0,9],[60,0,60,7],[54,3,55,3],[21,3,22,3],[0,13,64,13],[7,0,8,0],[2,11,2,12],[16,2,16,4],[13,2,13,4],[6,12,10,12],[2,7,2,9]]}
["Central Michigan University's Business Card",null,null,null,null,null,"Employee",{"$f":"IF(ISBLANK('CMU Bus Card Rec'!H1:J1), \" \", ('CMU Bus Card Rec'!H1:J1))","v":" "},null,null,null,{"$f":"IF(ISBLANK('CMU Bus Card Rec'!L1:M1), \" \", ('CMU Bus Card Rec'!L1:M1))","v":" "},null,{"$f":"UPPER(H1) &\":\" &\"  \"&\"ADDITIONAL TRAVEL EXPENSE FORM 4 - 5\"","v":" :  ADDITIONAL TRAVEL EXPENSE FORM 4 - 5"}]
["Reconciliation Form",null,null,null,null,null,"Office Addr",{"$f":"IF(ISBLANK('CMU Bus Card Rec'!H2:J2), \" \", ('CMU Bus Card Rec'!H2:J2))","v":" "},null,null,"Campus ID",{"$f":"IF(ISBLANK('CMU Bus Card Rec'!L2:M2), \" \", ('CMU Bus Card Rec'!L2:M2))","v":" "}]
["A","Officially working out of home:",null,null,null,null,"Dept Name",{"$f":"IF(ISBLANK('CMU Bus Card Rec'!H3:J3), \" \", ('CMU Bus Card Rec'!H3:J3))","v":" "},null,null,"Phone#",{"$f":"IF(ISBLANK('CMU Bus Card Rec'!L3:M3), \" \", ('CMU Bus Card Rec'!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,"Sum of Expenses","PNC  Statement Amount Charged","Total"]
[null,"Time of Departure",null,null,null,"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"]
[]
[null,"1. Employee Travel Meals:                                                                                           a. Select meals claimed (B, L, D).                                                                            b.  Select if High Cost City ",null,null,null," "," "," "," "," "]
[null,2,"Employee Travel Meals subtotaled by day*",null,null,{"$f":"IF('-'!C59=0, \" \",('-'!C59))","v":" "},{"$f":"IF('-'!G59=0, \" \",('-'!G59))","v":" "},{"$f":"IF('-'!K59=0, \" \",('-'!K59))","v":" "},{"$f":"IF('-'!O59=0, \" \",('-'!O59))","v":" "},{"$f":"IF('-'!S59=0, \" \",('-'!S59))","v":" "},{"$f":"IF(SUM(F13:J13)=0,\" \",(SUM(F13:J13)))","v":" "},null,{"$f":"IF(SUM(F13:J13)+L13=0,\" \",IF(SUM(F13:J13)=0,L13,K13-L13))","v":" "}]
[null,2," Lodging*",null,null,null,null,null,null,null,{"$f":"IF(SUM(F14:J14)=0,\" \",(SUM(F14:J14)))","v":" "},null,{"$f":"IF(SUM(F14:J14)+L14=0,\" \",IF(SUM(F14:J14)=0,L14,K14-L14))","v":" "}]
[null,3," Lodging Tips",null,null,null,null,null,null,null,{"$f":"IF(SUM(F15:J15)=0,\" \",(SUM(F15:J15)))","v":" "},null," "]
[null,4," Taxi, Bus*",null,null,null,null,null,null,null," ",null," "]
[null,5," Parking, Tolls*",null,null,null,null,null,null,null," ",null," "]
[null,6," Rental Car Expense*",null,null,null,null,null,null,null," ",null," "]
[null,7," Conference Fees",null,null,null,null,null,null,null," ",null," "]
[null,8," Business Calls (non-personal)",null,null,null,null,null,null,null," ",null," "]
[null,9,null,null,null,null,null,null,null,null," ",null," "]
["C","Mode of Transportation",null,"Date","Departure Location",null,"Arrival Location",null,"Personal Car Mileage","Sum of Mileage","Sum of Expenses Paid"," Statement Amount Charged","Total"]
["TRANSPORT"]
[null,1,"Click Here",null,null,null,null,null,null,{"$f":"IF(I24*0.655=0,\" \",(I24*0.655))","v":" "},null,null,{"$f":"IF(I24*0.655+K24-L24=0, \" \", I24*0.655+K24-L24)","v":" "}]
[null,2,"Click Here",null,null,null,null,null,null,{"$f":"IF(I25*0.655=0,\" \",(I25*0.655))","v":" "},null,null,{"$f":"IF(I25*0.655+K25-L25=0, \" \", I25*0.655+K25-L25)","v":" "}]
[null,3,"Click Here",null,null,null,null,null,null," ",null,null," "]
[null,4,"Click Here",null,null,null,null,null,null," ",null,null," "]
["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},{"$f":"(SUM(L24:L27))","v":0},{"$f":"IF(SUM(M24:M27)=0, \" \", (SUM(M24:M27)))","v":" "}]
["BILLING","Are any charges related to this trip, billed on a prior month ?",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":"IF(ISERROR(K28+J28+SUM(K13:K21)),SUM(K13:K21),(K28+J28+SUM(K13:K21)))","v":0}]
[]
["Central Michigan University's Business Card",null,null,null,null,null,"Employee",{"$f":"IF(ISBLANK('CMU Bus Card Rec'!H1:J1), \" \", ('CMU Bus Card Rec'!H1:J1))","v":" "},null,null,null,{"$f":"IF(ISBLANK('CMU Bus Card Rec'!L1:M1), \" \", ('CMU Bus Card Rec'!L1:M1))","v":" "}]
["Reconciliation Form",null,null,null,null,null,"Office Addr",{"$f":"IF(ISBLANK('CMU Bus Card Rec'!H2:J2),\" \",('CMU Bus Card Rec'!H2:J2))","v":" "},null,null,"Campus ID",{"$f":"IF(ISBLANK('CMU Bus Card Rec'!L2:M2), \" \", ('CMU Bus Card Rec'!L2:M2))","v":" "}]
["A","Officially working out of home:",null,null,null,null,"Dept Name",{"$f":"IF(ISBLANK('CMU Bus Card Rec'!H3:J3), \" \", ('CMU Bus Card Rec'!H3:J3))","v":" "},null,null,"Phone #",{"$f":"IF(ISBLANK('CMU Bus Card Rec'!L3:M3), \" \", ('CMU Bus Card Rec'!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,"Sum of Expenses","PNC  Statement Amount Charged","Total"]
[null,"Time of Departure",null,null,null,"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"]
[]
[null,"1. Employee Travel Meals:                                                                                           a. Select meals claimed (B, L, D).                                                                            b.  Select if High Cost City ",null,null,null," "," "," "," "," "]
[null,2,"Employee Travel Meals subtotaled by day*",null,null,{"$f":"IF('-'!C75=0, \" \", ('-'!C75))","v":" "},{"$f":"IF('-'!G75=0, \" \", ('-'!G75))","v":" "},{"$f":"IF('-'!K75=0, \" \", ('-'!K75))","v":" "},{"$f":"IF('-'!O75=0, \" \", ('-'!O75))","v":" "},{"$f":"IF('-'!S75=0, \" \", ('-'!S75))","v":" "},{"$f":"IF(SUM(F46:J46)=0,\" \",(SUM(F46:J46)))","v":" "},null,{"$f":"IF(SUM(F46:J46)+L46=0,\" \",IF(SUM(F46:J46)=0,L46,K46-L46))","v":" "}]
[null,2," Lodging*",null,null,null,null,null,null,null,{"$f":"IF(SUM(F47:J47)=0,\" \",(SUM(F47:J47)))","v":" "},null,{"$f":"IF(SUM(F47:J47)=0,\" \",(K47-L47))","v":" "}]
[null,3," Lodging Tips",null,null,null,null,null,null,null,{"$f":"IF(SUM(F48:J48)=0,\" \",(SUM(F48:J48)))","v":" "},null," "]
[null,4," Taxi, Bus*",null,null,null,null,null,null,null," ",null," "]
[null,5," Parking, Tolls*",null,null,null,null,null,null,null," ",null," "]
[null,6," Rental Car Expense*",null,null,null,null,null,null,null," ",null," "]
[null,7," Conference Fees",null,null,null,null,null,null,null," ",null," "]
[null,8," Business Calls (non-personal)",null,null,null,null,null,null,null," ",null," "]
[null,9,null,null,null,null,null,null,null,null," ",null," "]
["C","Mode of Transportation",null,"Date","Departure Location",null,"Arrival Location",null,"Personal Car Mileage","Sum of Mileage","Sum of Expenses Paid","Statement Amount Charged","Total"]
["TRANSPORT"]
[null,1,"Click Here",null,null,null,null,null,null,{"$f":"IF(I57*0.655=0,\" \",(I57*0.655))","v":" "},null,null,{"$f":"IF(I57*0.655+K57-L57=0, \" \", I57*0.655+K57-L57)","v":" "}]
[null,2,"Click Here",null,null,null,null,null,null,{"$f":"IF(I58*0.655=0,\" \",(I58*0.655))","v":" "},null,null,{"$f":"IF(I58*0.655+K58-L58=0, \" \", I58*0.655+K58-L58)","v":" "}]
[null,3,"Click Here",null,null,null,null,null,null," ",null,null," "]
[null,4,"Click Here",null,null,null,null,null,null," ",null,null," "]
["Transportation Total:",null,null,null,null,null,null,null,{"$f":"IF(SUM(I57:I60)=0,\" \",(SUM(I57:I60)))","v":" "},{"$f":"(SUM(J57:J60))","v":0},{"$f":"(SUM(K57:K60))","v":0},{"$f":"(SUM(L57:L60))","v":0},{"$f":"IF(SUM(M57:M60)=0, \" \", (SUM(M57:M60)))","v":" "}]
["BILLING","Are any charges related to this trip, billed on a prior month ?",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":"IF(ISERROR(K61+J61+SUM(K46:K54)),SUM(K46:K54),K61+J61+SUM(K46:K54))","v":0}]

{"sheet":"Accounting Allocations","index":4,"n_rows":27,"n_cols":12,"rows_kept":27,"cut":false,"hidden":false,"merged":[[2,7,2,9],[2,11,2,12],[3,0,17,0],[3,1,4,12],[2,1,2,4],[6,1,6,3],[6,5,6,6],[6,9,6,12],[7,1,7,3],[7,5,7,6],[0,0,0,5],[0,7,0,9],[0,11,0,12],[1,0,1,5],[1,7,1,9],[1,11,1,12],[7,9,7,12],[25,1,25,6],[25,9,25,12],[26,9,26,12],[23,1,23,3],[23,5,23,6],[23,9,23,12],[24,1,24,3],[24,5,24,6],[24,9,24,12]]}
["Central Michigan University's Business Card",null,null,null,null,null,"Employee",{"$f":"IF(ISBLANK('CMU Bus Card Rec'!H1:J1), \" \", ('CMU Bus Card Rec'!H1:J1))","v":" "},null,null,null,{"$f":"IF(ISBLANK('CMU Bus Card Rec'!L1:M1), \" \", ('CMU Bus Card Rec'!L1:M1))","v":" "}]
["Reconciliation Form",null,null,null,null,null,"Office Add.",{"$f":"IF(ISBLANK('CMU Bus Card Rec'!H2:J2), \" \", ('CMU Bus Card Rec'!H2:J2))","v":" "},null,null,"Campus ID",{"$f":"IF(ISBLANK('CMU Bus Card Rec'!L2:M2), \" \", ('CMU Bus Card Rec'!L2:M2))","v":" "}]
["A","Officially working out of home:",null,null,null,null,"Dept Name",{"$f":"IF(ISBLANK('CMU Bus Card Rec'!H3:J3), \" \", ('CMU Bus Card Rec'!H3:J3))","v":" "},null,null,"Phone #",{"$f":"IF(ISBLANK('CMU Bus Card Rec'!L3:M3), \" \", ('CMU Bus Card Rec'!L3:M3))","v":" "}]
[]
[]
[null,"DEPARTMENT ACCOUNTING ALLOCATIONS (Debit = Department will be charged, Credit = Department Refund Amount)"]
[null,"COST CENTER (or WBS) NAME",null,null,"CostCtr/WBS #","INT ORDER",null,"G/L","AMOUNT","DESCRIPTION (50 Characters Per Line)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"* RECEIPTS TO BE ATTACHED",null,null,null,null,null,"TOTAL",{"$f":"IF(SUM(I8:I25)=0,\" \",SUM(I8:I25))","v":" "},"Submit all forms to WA204 774-3525 or 774-6944"]
[null,"** IT IS RECOMMENDED THAT SIGNATURES ARE IN BLUE INK"]

{"sheet":"Doc. Form for Entertainment","index":5,"n_rows":52,"n_cols":10,"rows_kept":52,"cut":false,"hidden":false,"merged":[[51,0,51,11],[50,8,50,11],[50,5,50,7],[50,0,50,4],[49,8,49,11],[49,5,49,7],[49,0,49,4],[48,8,48,11],[48,5,48,7],[48,0,48,4],[47,8,47,11],[47,5,47,7],[47,0,47,4],[46,8,46,11],[46,5,46,7],[46,0,46,4],[22,4,22,11],[45,8,45,11],[45,5,45,7],[45,0,45,4],[44,8,44,11],[44,5,44,7],[44,0,44,4],[35,6,35,8],[35,9,35,10],[30,8,30,11],[30,5,30,7],[25,9,25,11],[25,6,25,8],[25,4,25,5],[35,0,35,4],[32,0,32,4],[32,5,32,7],[8,9,8,11],[43,0,43,4],[43,5,43,7],[43,8,43,11],[42,0,42,3],[42,4,42,5],[42,6,42,8],[42,9,42,11],[19,5,20,11],[36,5,37,11],[36,0,36,4],[37,0,37,4],[41,4,41,11],[41,0,41,3],[40,4,40,11],[39,4,39,11],[39,0,40,3],[38,0,38,3],[38,4,38,11],[32,8,32,11],[33,0,33,4],[33,5,33,7],[33,8,33,11],[31,0,31,4],[31,5,31,7],[31,8,31,11],[29,0,29,4],[29,5,29,7],[29,8,29,11],[30,0,30,4],[26,8,26,11],[27,0,27,4],[27,5,27,7],[27,8,27,11],[28,0,28,4],[28,5,28,7],[28,8,28,11],[16,0,16,4],[16,5,16,7],[16,8,16,11],[14,0,14,4],[14,5,14,7],[14,8,14,11],[15,0,15,4],[15,5,15,7],[15,8,15,11],[10,0,10,4],[10,5,10,7],[12,0,12,4],[12,5,12,7],[12,8,12,11],[13,0,13,4],[13,5,13,7],[13,8,13,11],[8,6,8,8],[25,0,25,3],[24,4,24,11],[24,0,24,3],[23,4,23,11],[22,0,23,3],[10,8,10,11],[11,0,11,4],[11,5,11,7],[11,8,11,11],[7,0,7,3],[21,4,21,11],[21,0,21,3],[2,0,2,4],[3,0,3,4],[2,5,3,11],[8,0,8,3],[9,0,9,4],[9,5,9,7],[8,4,8,5],[0,0,0,11],[5,4,5,11],[5,0,6,3],[6,4,6,11],[1,0,1,4],[1,6,1,8],[1,9,1,10],[4,0,4,3],[9,8,9,11],[7,4,7,11],[4,4,4,11],[26,0,26,4],[26,5,26,7],[20,0,20,4],[19,0,19,4],[18,9,18,10],[18,6,18,8],[18,0,18,4]]}
[]
["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 documenting entertainment and hosting activities."]
["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 documenting entertainment and hosting activities."]
["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 documenting entertainment and hosting activities."]
["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 and submit to Payroll/Travel, Warriner 204."]

{"sheet":"Missing Receipt","index":6,"n_rows":18,"n_cols":6,"rows_kept":18,"cut":false,"hidden":false,"merged":[[5,4,5,11],[10,4,10,11],[15,4,15,11],[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],[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]]}
[]
["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":"S&E>500 and Entertainment Exp","index":7,"n_rows":60,"n_cols":13,"rows_kept":60,"cut":false,"hidden":false,"merged":[[3,0,4,0],[57,4,57,5],[57,6,57,8],[0,11,0,12],[1,11,1,12],[2,11,2,12],[3,1,4,12],[0,0,0,5],[0,7,0,9],[1,0,1,5],[1,7,1,9],[2,1,2,4],[2,7,2,9],[54,4,54,5],[54,6,54,8],[58,4,58,5],[58,6,58,8],[55,4,55,5],[55,6,55,8],[56,4,56,5],[50,4,50,5],[50,6,50,8],[56,6,56,8],[51,4,51,5],[51,6,51,8],[52,4,52,5],[52,6,52,8],[53,4,53,5],[53,6,53,8],[47,4,47,5],[47,6,47,8],[48,4,48,5],[48,6,48,8],[49,4,49,5],[49,6,49,8],[44,4,44,5],[44,6,44,8],[45,4,45,5],[45,6,45,8],[46,4,46,5],[46,6,46,8],[41,4,41,5],[41,6,41,8],[42,4,42,5],[42,6,42,8],[43,4,43,5],[43,6,43,8],[38,4,38,5],[38,6,38,8],[39,4,39,5],[39,6,39,8],[40,4,40,5],[40,6,40,8],[35,4,35,5],[35,6,35,8],[36,4,36,5],[36,6,36,8],[37,4,37,5],[37,6,37,8],[32,4,32,5],[32,6,32,8],[33,4,33,5],[33,6,33,8],[34,4,34,5],[34,6,34,8],[29,4,29,5],[29,6,29,8],[30,4,30,5],[30,6,30,8],[31,4,31,5],[31,6,31,8],[26,4,26,5],[26,6,26,8],[27,4,27,5],[27,6,27,8],[28,4,28,5],[28,6,28,8],[23,4,23,5],[23,6,23,8],[24,4,24,5],[24,6,24,8],[25,4,25,5],[25,6,25,8],[20,4,20,5],[20,6,20,8],[21,4,21,5],[21,6,21,8],[22,4,22,5],[22,6,22,8],[17,4,17,5],[17,6,17,8],[18,4,18,5],[18,6,18,8],[19,4,19,5],[19,6,19,8],[14,4,14,5],[14,6,14,8],[12,4,12,5],[15,4,15,5],[15,6,15,8],[16,4,16,5],[16,6,16,8],[8,6,8,8],[9,4,9,5],[9,6,9,8],[12,6,12,8],[13,4,13,5],[13,6,13,8],[5,0,7,0],[5,1,5,12],[6,2,6,12],[7,2,7,12],[10,4,10,5],[10,6,10,8],[8,0,58,0],[11,4,11,5],[11,6,11,8],[8,4,8,5]]}
["Central Michigan University's Business Card",null,null,null,null,null,"Employee",{"$f":"IF(ISBLANK('CMU Bus Card Rec'!H1:J1), \" \", ('CMU Bus Card Rec'!H1:J1))","v":" "},null,null,null,{"$f":"IF(ISBLANK('CMU Bus Card Rec'!L1:M1), \" \", ('CMU Bus Card Rec'!L1:M1))","v":" "}]
["Reconciliation Form",null,null,null,null,null,"Office Addr",{"$f":"IF(ISBLANK('CMU Bus Card Rec'!H2:J2), \" \", ('CMU Bus Card Rec'!H2:J2))","v":" "},null,null,"Campus ID",{"$f":"IF(ISBLANK('CMU Bus Card Rec'!L2:M2), \" \", ('CMU Bus Card Rec'!L2:M2))","v":" "}]
["A","Officially working out of home:",null,null,null,null,"Dept Name",{"$f":"IF(ISBLANK('CMU Bus Card Rec'!H3:J3), \" \", ('CMU Bus Card Rec'!H3:J3))","v":" "},null,null,"Phone #",{"$f":"IF(ISBLANK('CMU Bus Card Rec'!L3:M3), \" \", ('CMU Bus Card Rec'!L3:M3))","v":" "}]
[]
[]
[null,"EXPENDITURES TO BE IDENTIFIED"]
[null,1,"S&E over $500"]
[null,2,"Entertainment/Hosting Activities(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,"Description",null,null,"Entertain./ Hosting Attachment","Sum of Expenses Paid","Statement Amount Charged","Total"]
[null,1,"Click Here",null,null,null,null,null,null,"#",null,null,{"$f":"IF(K10-L10=0, \" \", (K10-L10))","v":" "}]
[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," "]
[null,7,"Click Here",null,null,null,null,null,null,"#",null,null,{"$f":"IF(K16-L16=0, \" \", (K16-L16))","v":" "}]
[null,8,"Click Here",null,null,null,null,null,null,"#",null,null," "]
[null,9,"Click Here",null,null,null,null,null,null,"#",null,null," "]
[null,10,"Click Here",null,null,null,null,null,null,"#",null,null," "]
[null,11,"Click Here",null,null,null,null,null,null,"#",null,null," "]
[null,12,"Click Here",null,null,null,null,null,null,"#",null,null," "]
[null,13,"Click Here",null,null,null,null,null,null,"#",null,null," "]
[null,14,"Click Here",null,null,null,null,null,null,"#",null,null," "]
[null,15,"Click Here",null,null,null,null,null,null,"#",null,null," "]
[null,16,"Click Here",null,null,null,null,null,null,"#",null,null," "]
[null,17,"Click Here",null,null,null,null,null,null,"#",null,null," "]
[null,18,"Click Here",null,null,null,null,null,null,"#",null,null," "]
[null,19,"Click Here",null,null,null,null,null,null,"#",null,null,{"$f":"IF(K28-L28=0, \" \", (K28-L28))","v":" "}]
[null,20,"Click Here",null,null,null,null,null,null,"#",null,null," "]
[null,21,"Click Here",null,null,null,null,null,null,"#",null,null," "]
[null,22,"Click Here",null,null,null,null,null,null,"#",null,null," "]
[null,23,"Click Here",null,null,null,null,null,null,"#",null,null," "]
[null,24,"Click Here",null,null,null,null,null,null,"#",null,null," "]
[null,25,"Click Here",null,null,null,null,null,null,"#",null,null," "]
[null,26,"Click Here",null,null,null,null,null,null,"#",null,null," "]
[null,27,"Click Here",null,null,null,null,null,null,"#",null,null," "]
[null,28,"Click Here",null,null,null,null,null,null,"#",null,null," "]
[null,29,"Click Here",null,null,null,null,null,null,"#",null,null," "]
[null,30,"Click Here",null,null,null,null,null,null,"#",null,null," "]
[null,31,"Click Here",null,null,null,null,null,null,"#",null,null," "]
[null,32,"Click Here",null,null,null,null,null,null,"#",null,null," "]
[null,33,"Click Here",null,null,null,null,null,null,"#",null,null," "]
[null,34,"Click Here",null,null,null,null,null,null,"#",null,null," "]
[null,35,"Click Here",null,null,null,null,null,null,"#",null,null," "]
[null,36,"Click Here",null,null,null,null,null,null,"#",null,null," "]
[null,37,"Click Here",null,null,null,null,null,null,"#",null,null," "]
[null,38,"Click Here",null,null,null,null,null,null,"#",null,null," "]
[null,39,"Click Here",null,null,null,null,null,null,"#",null,null," "]
[null,40,"Click Here",null,null,null,null,null,null,"#",null,null," "]
[null,41,"Click Here",null,null,null,null,null,null,"#",null,null," "]
[null,42,"Click Here",null,null,null,null,null,null,"#",null,null," "]
[null,43,"Click Here",null,null,null,null,null,null,"#",null,null,{"$f":"IF(K52-L52=0, \" \", (K52-L52))","v":" "}]
[null,44,"Click Here",null,null,null,null,null,null,"#",null,null," "]
[null,45,"Click Here",null,null,null,null,null,null,"#",null,null," "]
[null,46,"Click Here",null,null,null,null,null,null,"#",null,null," "]
[null,47,"Click Here",null,null,null,null,null,null,"#",null,null," "]
[null,48,"Click Here",null,null,null,null,null,null,"#",null,null," "]
[null,49,"Click Here",null,null,null,null,null,null,"#",null,null,{"$f":"IF(K58-L58=0, \" \", (K58-L58))","v":" "}]
[null,50,"Click Here",null,null,null,null,null,null,"#",null,null,{"$f":"IF(K59-L59=0, \" \", (K59-L59))","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,"TOTAL",{"$f":"IF(SUM(M10:M59)=0,\" \",SUM(M10:M59))","v":" "}]

{"sheet":"Travel Expenses (6-7)","index":8,"n_rows":65,"n_cols":14,"rows_kept":65,"cut":false,"hidden":false,"merged":[[54,3,55,3],[21,3,22,3],[0,13,64,13],[7,0,8,0],[2,11,2,12],[16,2,16,4],[13,2,13,4],[6,12,10,12],[2,7,2,9],[3,0,5,0],[0,0,0,5],[2,1,2,4],[1,0,1,5],[3,1,3,12],[0,11,0,12],[1,11,1,12],[0,7,0,9],[1,7,1,9],[9,8,10,8],[9,9,10,9],[11,1,11,4],[9,7,10,7],[6,11,10,11],[4,1,5,12],[12,2,12,4],[20,2,20,4],[14,2,14,4],[17,2,17,4],[18,2,18,4],[19,2,19,4],[15,2,15,4],[9,0,20,0],[21,6,22,7],[21,4,22,5],[7,8,8,8],[9,5,10,5],[9,1,10,4],[9,6,10,6],[7,1,8,4],[7,5,8,5],[7,6,8,6],[24,4,24,5],[25,4,25,5],[6,10,10,10],[21,8,22,8],[24,6,24,7],[25,6,25,7],[21,9,22,9],[23,6,23,7],[7,9,8,9],[7,7,8,7],[31,0,31,11],[11,10,11,12],[21,11,22,11],[21,10,22,10],[26,6,26,7],[26,4,26,5],[21,1,22,2],[22,0,26,0],[21,12,22,12],[23,4,23,5],[28,9,29,10],[28,11,30,12],[30,6,30,7],[30,9,30,10],[28,8,29,8],[28,0,30,0],[28,1,29,4],[28,5,29,5],[28,6,29,7],[33,11,33,12],[34,0,34,5],[34,7,34,9],[34,11,34,12],[33,0,33,5],[33,7,33,9],[35,1,35,4],[35,7,35,9],[35,11,35,12],[36,0,38,0],[36,1,36,12],[37,1,38,12],[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,8,41,8],[40,9,41,9],[42,0,53,0],[42,1,43,4],[42,6,43,6],[48,2,48,4],[49,2,49,4],[45,2,45,4],[46,2,46,4],[47,2,47,4],[44,1,44,4],[54,9,55,9],[54,10,55,10],[54,11,55,11],[42,7,43,7],[42,8,43,8],[42,9,43,9],[39,10,43,10],[39,11,43,11],[44,10,44,12],[54,12,55,12],[61,8,62,8],[55,0,59,0],[56,4,56,5],[56,6,56,7],[57,4,57,5],[57,6,57,7],[58,4,58,5],[58,6,58,7],[59,4,59,5],[59,6,59,7],[54,8,55,8],[64,0,64,11],[61,9,62,10],[61,11,63,12],[63,6,63,7],[63,9,63,10],[61,0,63,0],[61,1,62,4],[61,5,62,5],[61,6,62,7],[60,0,60,7],[27,0,27,7],[54,4,55,5],[54,6,55,7],[54,1,55,2],[50,2,50,4],[51,2,51,4],[52,2,52,4],[53,2,53,4],[42,5,43,5]]}
["Central Michigan University's Business Card",null,null,null,null,null,"Employee",{"$f":"IF(ISBLANK('CMU Bus Card Rec'!H1:J1), \" \", ('CMU Bus Card Rec'!H1:J1))","v":" "},null,null,null,{"$f":"IF(ISBLANK('CMU Bus Card Rec'!L1:M1), \" \", ('CMU Bus Card Rec'!L1:M1))","v":" "},null,{"$f":"UPPER(H1) &\":\" &\"  \"&\"ADDITIONAL TRAVEL EXPENSE FORM 6 - 7\"","v":" :  ADDITIONAL TRAVEL EXPENSE FORM 6 - 7"}]
["Reconciliation Form",null,null,null,null,null,"Office Addr",{"$f":"IF(ISBLANK('CMU Bus Card Rec'!H2:J2), \" \", ('CMU Bus Card Rec'!H2:J2))","v":" "},null,null,"Campus ID",{"$f":"IF(ISBLANK('CMU Bus Card Rec'!L2:M2), \" \", ('CMU Bus Card Rec'!L2:M2))","v":" "}]
["A","Officially working out of home:",null,null,null,null,"Dept Name",{"$f":"IF(ISBLANK('CMU Bus Card Rec'!H3:J3), \" \", ('CMU Bus Card Rec'!H3:J3))","v":" "},null,null,"Phone#",{"$f":"IF(ISBLANK('CMU Bus Card Rec'!L3:M3), \" \", ('CMU Bus Card Rec'!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,"Sum of Expenses","PNC  Statement Amount Charged","Total"]
[null,"Time of Departure",null,null,null,"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"]
[]
[null,"1. Employee Travel Meals:                                                                                           a. Select meals claimed (B, L, D).                                                                            b.  Select if High Cost City ",null,null,null," "," "," "," "," "]
[null,2,"Employee Travel Meals subtotaled by day*",null,null,{"$f":"IF('-'!C90=0, \" \",('-'!C90))","v":" "},{"$f":"IF('-'!G90=0, \" \",('-'!G90))","v":" "},{"$f":"IF('-'!K90=0, \" \",('-'!K90))","v":" "},{"$f":"IF('-'!O90=0, \" \",('-'!O90))","v":" "},{"$f":"IF('-'!S90=0, \" \",('-'!S90))","v":" "},{"$f":"IF(SUM(F13:J13)=0,\" \",(SUM(F13:J13)))","v":" "},null,{"$f":"IF(SUM(F13:J13)+L13=0,\" \",IF(SUM(F13:J13)=0,L13,K13-L13))","v":" "}]
[null,2," Lodging*",null,null,null,null,null,null,null," ",null," "]
[null,3," Lodging Tips",null,null,null,null,null,null,null," ",null," "]
[null,4," Taxi, Bus*",null,null,null,null,null,null,null," ",null," "]
[null,5," Parking, Tolls*",null,null,null,null,null,null,null," ",null," "]
[null,6," Rental Car Expense*",null,null,null,null,null,null,null," ",null," "]
[null,7," Conference Fees",null,null,null,null,null,null,null," ",null," "]
[null,8," Business Calls (non-personal)",null,null,null,null,null,null,null," ",null," "]
[null,9,null,null,null,null,null,null,null,null," ",null," "]
["C","Mode of Transportation",null,"Date","Departure Location",null,"Arrival Location",null,"Personal Car Mileage","Sum of Mileage","Sum of Expenses Paid"," Statement Amount Charged","Total"]
["TRANSPORT"]
[null,1,"Click Here",null,null,null,null,null,null,{"$f":"IF(I24*0.655=0,\" \",(I24*0.655))","v":" "},null,null,{"$f":"IF(I24*0.655+K24-L24=0, \" \", I24*0.655+K24-L24)","v":" "}]
[null,2,"Click Here",null,null,null,null,null,null,{"$f":"IF(I25*0.655=0,\" \",(I25*0.655))","v":" "},null,null,{"$f":"IF(I25*0.655+K25-L25=0, \" \", I25*0.655+K25-L25)","v":" "}]
[null,3,"Click Here",null,null,null,null,null,null," ",null,null," "]
[null,4,"Click Here",null,null,null,null,null,null," ",null,null," "]
["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},{"$f":"(SUM(L24:L27))","v":0},{"$f":"IF(SUM(M24:M27)=0, \" \", (SUM(M24:M27)))","v":" "}]
["BILLING","Are any charges related to this trip, billed on a prior month ?",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":"IF(ISERROR(K28+J28+SUM(K13:K21)),SUM(K13:K21),(K28+J28+SUM(K13:K21)))","v":0}]
[]
["Central Michigan University's Business Card",null,null,null,null,null,"Employee",{"$f":"IF(ISBLANK('CMU Bus Card Rec'!H1:J1), \" \", ('CMU Bus Card Rec'!H1:J1))","v":" "},null,null,null,{"$f":"IF(ISBLANK('CMU Bus Card Rec'!L1:M1), \" \", ('CMU Bus Card Rec'!L1:M1))","v":" "}]
["Reconciliation Form",null,null,null,null,null,"Office Addr",{"$f":"IF(ISBLANK('CMU Bus Card Rec'!H2:J2),\" \",('CMU Bus Card Rec'!H2:J2))","v":" "},null,null,"Campus ID",{"$f":"IF(ISBLANK('CMU Bus Card Rec'!L2:M2), \" \", ('CMU Bus Card Rec'!L2:M2))","v":" "}]
["A","Officially working out of home:",null,null,null,null,"Dept Name",{"$f":"IF(ISBLANK('CMU Bus Card Rec'!H3:J3), \" \", ('CMU Bus Card Rec'!H3:J3))","v":" "},null,null,"Phone #",{"$f":"IF(ISBLANK('CMU Bus Card Rec'!L3:M3), \" \", ('CMU Bus Card Rec'!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,"Sum of Expenses","PNC  Statement Amount Charged","Total"]
[null,"Time of Departure",null,null,null,"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"]
[]
[null,"1. Employee Travel Meals:                                                                                           a. Select meals claimed (B, L, D).                                                                            b.  Select if High Cost City ",null,null,null," "," "," "," "," "]
[null,2,"Employee Travel Meals subtotaled by day*",null,null,{"$f":"IF('-'!C106=0, \" \", ('-'!C106))","v":" "},{"$f":"IF('-'!G106=0, \" \", ('-'!G106))","v":" "},{"$f":"IF('-'!K106=0, \" \", ('-'!K106))","v":" "},{"$f":"IF('-'!O106=0, \" \", ('-'!O106))","v":" "},{"$f":"IF('-'!S106=0, \" \", ('-'!S106))","v":" "},{"$f":"IF(SUM(F46:J46)=0,\" \",(SUM(F46:J46)))","v":" "},null,{"$f":"IF(SUM(F46:J46)+L46=0,\" \",IF(SUM(F46:J46)=0,L46,K46-L46))","v":" "}]
[null,2," Lodging*",null,null,null,null,null,null,null," ",null,{"$f":"IF(SUM(F47:J47)=0,\" \",(K47-L47))","v":" "}]
[null,3," Lodging Tips",null,null,null,null,null,null,null," ",null," "]
[null,4," Taxi, Bus*",null,null,null,null,null,null,null," ",null," "]
[null,5," Parking, Tolls*",null,null,null,null,null,null,null," ",null," "]
[null,6," Rental Car Expense*",null,null,null,null,null,null,null," ",null," "]
[null,7," Conference Fees",null,null,null,null,null,null,null," ",null," "]
[null,8," Business Calls (non-personal)",null,null,null,null,null,null,null," ",null," "]
[null,9,null,null,null,null,null,null,null,null," ",null," "]
["C","Mode of Transportation",null,"Date","Departure Location",null,"Arrival Location",null,"Personal Car Mileage","Sum of Mileage","Sum of Expenses Paid","Statement Amount Charged","Total"]
["TRANSPORT"]
[null,1,"Click Here",null,null,null,null,null,null,{"$f":"IF(I57*0.655=0,\" \",(I57*0.655))","v":" "},null,null,{"$f":"IF(I57*0.655+K57-L57=0, \" \", I57*0.655+K57-L57)","v":" "}]
[null,2,"Click Here",null,null,null,null,null,null,{"$f":"IF(I58*0.655=0,\" \",(I58*0.655))","v":" "},null,null,{"$f":"IF(I58*0.655+K58-L58=0, \" \", I58*0.655+K58-L58)","v":" "}]
[null,3,"Click Here",null,null,null,null,null,null," ",null,null," "]
[null,4,"Click Here",null,null,null,null,null,null," ",null,null," "]
["Transportation Total:",null,null,null,null,null,null,null,{"$f":"IF(SUM(I57:I60)=0,\" \",(SUM(I57:I60)))","v":" "},{"$f":"(SUM(J57:J60))","v":0},{"$f":"(SUM(K57:K60))","v":0},{"$f":"(SUM(L57:L60))","v":0},{"$f":"IF(SUM(M57:M60)=0, \" \", (SUM(M57:M60)))","v":" "}]
["BILLING","Are any charges related to this trip, billed on a prior month ?",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":"IF(ISERROR(K61+J61+SUM(K46:K54)),SUM(K46:K54),K61+J61+SUM(K46:K54))","v":0}]

{"sheet":"Travel Expenses (8-9)","index":9,"n_rows":65,"n_cols":14,"rows_kept":65,"cut":false,"hidden":false,"merged":[[27,0,27,7],[54,4,55,5],[54,6,55,7],[54,1,55,2],[50,2,50,4],[51,2,51,4],[52,2,52,4],[53,2,53,4],[42,5,43,5],[42,6,43,6],[54,8,55,8],[64,0,64,11],[61,9,62,10],[61,11,63,12],[63,6,63,7],[63,9,63,10],[61,0,63,0],[61,1,62,4],[61,5,62,5],[61,6,62,7],[61,8,62,8],[55,0,59,0],[56,4,56,5],[56,6,56,7],[57,4,57,5],[57,6,57,7],[58,4,58,5],[58,6,58,7],[59,4,59,5],[59,6,59,7],[54,9,55,9],[54,10,55,10],[54,11,55,11],[42,7,43,7],[42,8,43,8],[42,9,43,9],[39,10,43,10],[39,11,43,11],[44,10,44,12],[54,12,55,12],[40,8,41,8],[42,0,53,0],[48,2,48,4],[49,2,49,4],[45,2,45,4],[46,2,46,4],[47,2,47,4],[42,1,43,4],[35,7,35,9],[35,11,35,12],[44,1,44,4],[39,12,43,12],[40,9,41,9],[40,0,41,0],[40,1,41,4],[40,5,41,5],[40,6,41,6],[40,7,41,7],[36,0,38,0],[36,1,36,12],[37,1,38,12],[33,11,33,12],[34,0,34,5],[34,7,34,9],[34,11,34,12],[33,0,33,5],[33,7,33,9],[35,1,35,4],[28,0,30,0],[28,1,29,4],[28,5,29,5],[28,6,29,7],[28,9,29,10],[28,11,30,12],[30,6,30,7],[30,9,30,10],[28,8,29,8],[31,0,31,11],[11,10,11,12],[21,11,22,11],[21,10,22,10],[26,6,26,7],[26,4,26,5],[21,1,22,2],[22,0,26,0],[21,12,22,12],[23,4,23,5],[24,4,24,5],[25,4,25,5],[6,10,10,10],[21,8,22,8],[24,6,24,7],[25,6,25,7],[21,9,22,9],[23,6,23,7],[7,9,8,9],[7,7,8,7],[9,0,20,0],[21,6,22,7],[21,4,22,5],[7,8,8,8],[9,5,10,5],[9,1,10,4],[9,6,10,6],[7,1,8,4],[7,5,8,5],[7,6,8,6],[20,2,20,4],[14,2,14,4],[17,2,17,4],[18,2,18,4],[19,2,19,4],[15,2,15,4],[1,7,1,9],[9,8,10,8],[9,9,10,9],[11,1,11,4],[9,7,10,7],[12,2,12,4],[3,0,5,0],[6,11,10,11],[4,1,5,12],[0,0,0,5],[2,1,2,4],[1,0,1,5],[3,1,3,12],[0,11,0,12],[1,11,1,12],[0,7,0,9],[60,0,60,7],[54,3,55,3],[21,3,22,3],[0,13,64,13],[7,0,8,0],[2,11,2,12],[16,2,16,4],[13,2,13,4],[6,12,10,12],[2,7,2,9]]}
["Central Michigan University's Business Card",null,null,null,null,null,"Employee",{"$f":"IF(ISBLANK('CMU Bus Card Rec'!H1:J1), \" \", ('CMU Bus Card Rec'!H1:J1))","v":" "},null,null,null,{"$f":"IF(ISBLANK('CMU Bus Card Rec'!L1:M1), \" \", ('CMU Bus Card Rec'!L1:M1))","v":" "},null,{"$f":"UPPER(H1) &\":\" &\"  \"&\"ADDITIONAL TRAVEL EXPENSE FORM 8 - 9\"","v":" :  ADDITIONAL TRAVEL EXPENSE FORM 8 - 9"}]
["Reconciliation Form",null,null,null,null,null,"Office Addr",{"$f":"IF(ISBLANK('CMU Bus Card Rec'!H2:J2), \" \", ('CMU Bus Card Rec'!H2:J2))","v":" "},null,null,"Campus ID",{"$f":"IF(ISBLANK('CMU Bus Card Rec'!L2:M2), \" \", ('CMU Bus Card Rec'!L2:M2))","v":" "}]
["A","Officially working out of home:",null,null,null,null,"Dept Name",{"$f":"IF(ISBLANK('CMU Bus Card Rec'!H3:J3), \" \", ('CMU Bus Card Rec'!H3:J3))","v":" "},null,null,"Phone#",{"$f":"IF(ISBLANK('CMU Bus Card Rec'!L3:M3), \" \", ('CMU Bus Card Rec'!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,"Sum of Expenses","PNC  Statement Amount Charged","Total"]
[null,"Time of Departure",null,null,null,"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"]
[]
[null,"1. Employee Travel Meals:                                                                                           a. Select meals claimed (B, L, D).                                                                            b.  Select if High Cost City ",null,null,null," "," "," "," "," "]
[null,2,"Employee Travel Meals subtotaled by day*",null,null,{"$f":"IF('-'!C121=0, \" \",('-'!C121))","v":" "},{"$f":"IF('-'!G121=0, \" \",('-'!G121))","v":" "},{"$f":"IF('-'!K121=0, \" \",('-'!K121))","v":" "},{"$f":"IF('-'!O121=0, \" \",('-'!O121))","v":" "},{"$f":"IF('-'!S121=0, \" \",('-'!S121))","v":" "},{"$f":"IF(SUM(F13:J13)=0,\" \",(SUM(F13:J13)))","v":" "},null,{"$f":"IF(SUM(F13:J13)+L13=0,\" \",IF(SUM(F13:J13)=0,L13,K13-L13))","v":" "}]
[null,2," Lodging*",null,null,null,null,null,null,null," ",null," "]
[null,3," Lodging Tips",null,null,null,null,null,null,null," ",null," "]
[null,4," Taxi, Bus*",null,null,null,null,null,null,null," ",null," "]
[null,5," Parking, Tolls*",null,null,null,null,null,null,null," ",null," "]
[null,6," Rental Car Expense*",null,null,null,null,null,null,null," ",null," "]
[null,7," Conference Fees",null,null,null,null,null,null,null," ",null," "]
[null,8," Business Calls (non-personal)",null,null,null,null,null,null,null," ",null," "]
[null,9,null,null,null,null,null,null,null,null," ",null," "]
["C","Mode of Transportation",null,"Date","Departure Location",null,"Arrival Location",null,"Personal Car Mileage","Sum of Mileage","Sum of Expenses Paid"," Statement Amount Charged","Total"]
["TRANSPORT"]
[null,1,"Click Here",null,null,null,null,null,null,{"$f":"IF(I24*0.655=0,\" \",(I24*0.655))","v":" "},null,null,{"$f":"IF(I24*0.655+K24-L24=0, \" \", I24*0.655+K24-L24)","v":" "}]
[null,2,"Click Here",null,null,null,null,null,null,{"$f":"IF(I25*0.655=0,\" \",(I25*0.655))","v":" "},null,null,{"$f":"IF(I25*0.655+K25-L25=0, \" \", I25*0.655+K25-L25)","v":" "}]
[null,3,"Click Here",null,null,null,null,null,null," ",null,null," "]
[null,4,"Click Here",null,null,null,null,null,null," ",null,null," "]
["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},{"$f":"(SUM(L24:L27))","v":0},{"$f":"IF(SUM(M24:M27)=0, \" \", (SUM(M24:M27)))","v":" "}]
["BILLING","Are any charges related to this trip, billed on a prior month ?",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":"IF(ISERROR(K28+J28+SUM(K13:K21)),SUM(K13:K21),(K28+J28+SUM(K13:K21)))","v":0}]
[]
["Central Michigan University's Business Card",null,null,null,null,null,"Employee",{"$f":"IF(ISBLANK('CMU Bus Card Rec'!H1:J1), \" \", ('CMU Bus Card Rec'!H1:J1))","v":" "},null,null,null,{"$f":"IF(ISBLANK('CMU Bus Card Rec'!L1:M1), \" \", ('CMU Bus Card Rec'!L1:M1))","v":" "}]
["Reconciliation Form",null,null,null,null,null,"Office Addr",{"$f":"IF(ISBLANK('CMU Bus Card Rec'!H2:J2),\" \",('CMU Bus Card Rec'!H2:J2))","v":" "},null,null,"Campus ID",{"$f":"IF(ISBLANK('CMU Bus Card Rec'!L2:M2), \" \", ('CMU Bus Card Rec'!L2:M2))","v":" "}]
["A","Officially working out of home:",null,null,null,null,"Dept Name",{"$f":"IF(ISBLANK('CMU Bus Card Rec'!H3:J3), \" \", ('CMU Bus Card Rec'!H3:J3))","v":" "},null,null,"Phone #",{"$f":"IF(ISBLANK('CMU Bus Card Rec'!L3:M3), \" \", ('CMU Bus Card Rec'!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,"Sum of Expenses","PNC  Statement Amount Charged","Total"]
[null,"Time of Departure",null,null,null,"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"]
[]
[null,"1. Employee Travel Meals:                                                                                           a. Select meals claimed (B, L, D).                                                                            b.  Select if High Cost City ",null,null,null," "," "," "," "," "]
[null,2,"Employee Travel Meals subtotaled by day*",null,null,{"$f":"IF('-'!C137=0, \" \", ('-'!C137))","v":" "},{"$f":"IF('-'!G137=0, \" \", ('-'!G137))","v":" "},{"$f":"IF('-'!K137=0, \" \", ('-'!K137))","v":" "},{"$f":"IF('-'!O137=0, \" \", ('-'!O137))","v":" "},{"$f":"IF('-'!S137=0, \" \", ('-'!S137))","v":" "},{"$f":"IF(SUM(F46:J46)=0,\" \",(SUM(F46:J46)))","v":" "},null,{"$f":"IF(SUM(F46:J46)+L46=0,\" \",IF(SUM(F46:J46)=0,L46,K46-L46))","v":" "}]
[null,2," Lodging*",null,null,null,null,null,null,null," ",null,{"$f":"IF(SUM(F47:J47)=0,\" \",(K47-L47))","v":" "}]
[null,3," Lodging Tips",null,null,null,null,null,null,null," ",null," "]
[null,4," Taxi, Bus*",null,null,null,null,null,null,null," ",null," "]
[null,5," Parking, Tolls*",null,null,null,null,null,null,null," ",null," "]
[null,6," Rental Car Expense*",null,null,null,null,null,null,null," ",null," "]
[null,7," Conference Fees",null,null,null,null,null,null,null," ",null," "]
[null,8," Business Calls (non-personal)",null,null,null,null,null,null,null," ",null," "]
[null,9,null,null,null,null,null,null,null,null," ",null," "]
["C","Mode of Transportation",null,"Date","Departure Location",null,"Arrival Location",null,"Personal Car Mileage","Sum of Mileage","Sum of Expenses Paid","Statement Amount Charged","Total"]
["TRANSPORT"]
[null,1,"Click Here",null,null,null,null,null,null,{"$f":"IF(I57*0.655=0,\" \",(I57*0.655))","v":" "},null,null,{"$f":"IF(I57*0.655+K57-L57=0, \" \", I57*0.655+K57-L57)","v":" "}]
[null,2,"Click Here",null,null,null,null,null,null,{"$f":"IF(I58*0.655=0,\" \",(I58*0.655))","v":" "},null,null,{"$f":"IF(I58*0.655+K58-L58=0, \" \", I58*0.655+K58-L58)","v":" "}]
[null,3,"Click Here",null,null,null,null,null,null," ",null,null," "]
[null,4,"Click Here",null,null,null,null,null,null," ",null,null," "]
["Transportation Total:",null,null,null,null,null,null,null,{"$f":"IF(SUM(I57:I60)=0,\" \",(SUM(I57:I60)))","v":" "},{"$f":"(SUM(J57:J60))","v":0},{"$f":"(SUM(K57:K60))","v":0},{"$f":"(SUM(L57:L60))","v":0},{"$f":"IF(SUM(M57:M60)=0, \" \", (SUM(M57:M60)))","v":" "}]
["BILLING","Are any charges related to this trip, billed on a prior month ?",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":"IF(ISERROR(K61+J61+SUM(K46:K54)),SUM(K46:K54),K61+J61+SUM(K46:K54))","v":0}]

{"sheet":"Doc. Form for Entertainment (2)","index":10,"n_rows":52,"n_cols":10,"rows_kept":52,"cut":false,"hidden":false,"merged":[[9,8,9,11],[7,4,7,11],[4,4,4,11],[26,0,26,4],[26,5,26,7],[20,0,20,4],[19,0,19,4],[18,9,18,10],[18,6,18,8],[18,0,18,4],[0,0,0,11],[5,4,5,11],[5,0,6,3],[6,4,6,11],[1,0,1,4],[1,6,1,8],[1,9,1,10],[4,0,4,3],[7,0,7,3],[21,4,21,11],[21,0,21,3],[2,0,2,4],[3,0,3,4],[2,5,3,11],[8,0,8,3],[9,0,9,4],[9,5,9,7],[8,4,8,5],[8,6,8,8],[25,0,25,3],[24,4,24,11],[24,0,24,3],[23,4,23,11],[22,0,23,3],[10,8,10,11],[11,0,11,4],[11,5,11,7],[11,8,11,11],[12,8,12,11],[13,0,13,4],[13,5,13,7],[13,8,13,11],[10,0,10,4],[10,5,10,7],[12,0,12,4],[12,5,12,7],[14,0,14,4],[14,5,14,7],[14,8,14,11],[15,0,15,4],[15,5,15,7],[15,8,15,11],[26,8,26,11],[27,0,27,4],[27,5,27,7],[27,8,27,11],[16,0,16,4],[16,5,16,7],[16,8,16,11],[22,4,22,11],[31,5,31,7],[31,8,31,11],[29,0,29,4],[29,5,29,7],[29,8,29,11],[30,0,30,4],[40,4,40,11],[39,4,39,11],[39,0,40,3],[38,0,38,3],[38,4,38,11],[32,0,32,4],[32,5,32,7],[32,8,32,11],[33,0,33,4],[33,5,33,7],[42,4,42,5],[42,6,42,8],[42,9,42,11],[19,5,20,11],[36,5,37,11],[35,0,35,4],[36,0,36,4],[37,0,37,4],[41,4,41,11],[41,0,41,3],[35,6,35,8],[35,9,35,10],[30,8,30,11],[30,5,30,7],[8,9,8,11],[33,8,33,11],[25,9,25,11],[25,6,25,8],[25,4,25,5],[31,0,31,4],[28,0,28,4],[28,5,28,7],[28,8,28,11],[44,8,44,11],[44,5,44,7],[44,0,44,4],[43,0,43,4],[43,5,43,7],[43,8,43,11],[42,0,42,3],[46,8,46,11],[46,5,46,7],[46,0,46,4],[45,8,45,11],[45,5,45,7],[45,0,45,4],[48,8,48,11],[48,5,48,7],[48,0,48,4],[47,8,47,11],[47,5,47,7],[47,0,47,4],[51,0,51,11],[50,8,50,11],[50,5,50,7],[50,0,50,4],[49,8,49,11],[49,5,49,7],[49,0,49,4]]}
[]
["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 documenting entertainment and hosting activities."]
["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 documenting entertainment and hosting activities."]
["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 documenting entertainment and hosting activities."]
["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 and submit to Payroll/Travel, Warriner 204."]

{"sheet":"Doc. Form for Entertainment (3)","index":11,"n_rows":52,"n_cols":10,"rows_kept":52,"cut":false,"hidden":false,"merged":[[51,0,51,11],[50,8,50,11],[50,5,50,7],[50,0,50,4],[49,8,49,11],[49,5,49,7],[49,0,49,4],[48,8,48,11],[48,5,48,7],[48,0,48,4],[47,8,47,11],[47,5,47,7],[47,0,47,4],[46,8,46,11],[46,5,46,7],[46,0,46,4],[22,4,22,11],[45,8,45,11],[45,5,45,7],[45,0,45,4],[44,8,44,11],[44,5,44,7],[44,0,44,4],[35,6,35,8],[35,9,35,10],[30,8,30,11],[30,5,30,7],[25,9,25,11],[25,6,25,8],[25,4,25,5],[35,0,35,4],[32,0,32,4],[32,5,32,7],[8,9,8,11],[43,0,43,4],[43,5,43,7],[43,8,43,11],[42,0,42,3],[42,4,42,5],[42,6,42,8],[42,9,42,11],[19,5,20,11],[36,5,37,11],[36,0,36,4],[37,0,37,4],[41,4,41,11],[41,0,41,3],[40,4,40,11],[39,4,39,11],[39,0,40,3],[38,0,38,3],[38,4,38,11],[32,8,32,11],[33,0,33,4],[33,5,33,7],[33,8,33,11],[31,0,31,4],[31,5,31,7],[31,8,31,11],[29,0,29,4],[29,5,29,7],[29,8,29,11],[30,0,30,4],[26,8,26,11],[27,0,27,4],[27,5,27,7],[27,8,27,11],[28,0,28,4],[28,5,28,7],[28,8,28,11],[16,0,16,4],[16,5,16,7],[16,8,16,11],[14,0,14,4],[14,5,14,7],[14,8,14,11],[15,0,15,4],[15,5,15,7],[15,8,15,11],[10,0,10,4],[10,5,10,7],[12,0,12,4],[12,5,12,7],[12,8,12,11],[13,0,13,4],[13,5,13,7],[13,8,13,11],[8,6,8,8],[25,0,25,3],[24,4,24,11],[24,0,24,3],[23,4,23,11],[22,0,23,3],[10,8,10,11],[11,0,11,4],[11,5,11,7],[11,8,11,11],[7,0,7,3],[21,4,21,11],[21,0,21,3],[2,0,2,4],[3,0,3,4],[2,5,3,11],[8,0,8,3],[9,0,9,4],[9,5,9,7],[8,4,8,5],[0,0,0,11],[5,4,5,11],[5,0,6,3],[6,4,6,11],[1,0,1,4],[1,6,1,8],[1,9,1,10],[4,0,4,3],[9,8,9,11],[7,4,7,11],[4,4,4,11],[26,0,26,4],[26,5,26,7],[20,0,20,4],[19,0,19,4],[18,9,18,10],[18,6,18,8],[18,0,18,4]]}
[]
["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 documenting entertainment and hosting activities."]
["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 documenting entertainment and hosting activities."]
["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 documenting entertainment and hosting activities."]
["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 and submit to Payroll/Travel, Warriner 204."]

{"sheet":"EnableMacros","index":12,"n_rows":26,"n_cols":7,"rows_kept":26,"cut":false,"hidden":false,"merged":[[4,0,4,7],[13,0,13,7],[1,0,1,7],[0,6,0,7]]}
["To Enable the Macros in this workbook:",null,null,null,null,null,"Return Main Menu"]
["Option 1:  If you are prompted to Enable or Disable macros in this workbook when opening it, select ENABLE."]
[]
[]
["Option 2:  To display a warning message whenever you try to open a workbook that contains a macro;"]
[]
["1. On the Tools menu, point to Macro, and then click Security."]
[]
["2. Click the Security Level tab."]
[]
["3. Click Medium."]
[]
[]
["Option 3:  To avoid all warning messages and enable all macros to load when opening a wokbook:"]
[]
["1. On the Tools menu, point to Macro, and then click Security."]
[]
["2. Click the Security Level tab."]
[]
["3. Click Medium."]
[" "]
[]
[]
[]
[]
[" "]

{"sheet":"-","index":13,"n_rows":179,"n_cols":21,"rows_kept":179,"cut":false,"hidden":false,"merged":[[94,20,103,20],[109,20,118,20],[125,20,134,20],[63,20,72,20],[1,20,10,20],[16,20,25,20],[32,20,41,20],[47,20,56,20],[78,20,87,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,9,IF(B3=FALSE,0,\" \"))","v":0},null,"B - Normal",false,{"$f":"IF(F3=TRUE,9,IF(F3=FALSE,0,\" \"))","v":0},null,"B - Normal",false,{"$f":"IF(J3=TRUE,9,IF(J3=FALSE,0,\" \"))","v":0},null,"B - Normal",false,{"$f":"IF(N3=TRUE,9,IF(N3=FALSE,0,\" \"))","v":0},null,"B - Normal",false,{"$f":"IF(R3=TRUE,9,IF(R3=FALSE,0,\" \"))","v":0}]
["L - Normal",false,{"$f":"IF(B4=TRUE,14,IF(B4=FALSE,0,\" \"))","v":0},null,"L - Normal",false,{"$f":"IF(F4=TRUE,14,IF(F4=FALSE,0,\" \"))","v":0},null,"L - Normal",false,{"$f":"IF(J4=TRUE,14,IF(J4=FALSE,0,\" \"))","v":0},null,"L - Normal",false,{"$f":"IF(N4=TRUE,14,IF(N4=FALSE,0,\" \"))","v":0},null,"L - Normal",false,{"$f":"IF(R4=TRUE,14,IF(R4=FALSE,0,\" \"))","v":0}]
["D - Normal",false,{"$f":"IF(B5=TRUE,23,IF(B5=FALSE,0,\" \"))","v":0},null,"D - Normal",false,{"$f":"IF(F5=TRUE,23,IF(F5=FALSE,0,\" \"))","v":0},null,"D - Normal",false,{"$f":"IF(J5=TRUE,23,IF(J5=FALSE,0,\" \"))","v":0},null,"D - Normal",false,{"$f":"IF(N5=TRUE,23,IF(N5=FALSE,0,\" \"))","v":0},null,"D - Normal",false,{"$f":"IF(R5=TRUE,23,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,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}]
["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}]
["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}]
["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,9,IF(B18=FALSE,0,\" \"))","v":0},null,"B - Normal",false,{"$f":"IF(F18=TRUE,9,IF(F18=FALSE,0,\" \"))","v":0},null,"B - Normal",false,{"$f":"IF(J18=TRUE,9,IF(J18=FALSE,0,\" \"))","v":0},null,"B - Normal",false,{"$f":"IF(N18=TRUE,9,IF(N18=FALSE,0,\" \"))","v":0},null,"B - Normal",false,{"$f":"IF(R18=TRUE,9,IF(R18=FALSE,0,\" \"))","v":0}]
["L - Normal",false,{"$f":"IF(B19=TRUE,14,IF(B19=FALSE,0,\" \"))","v":0},null,"L - Normal",false,{"$f":"IF(F19=TRUE,14,IF(F19=FALSE,0,\" \"))","v":0},null,"L - Normal",false,{"$f":"IF(J19=TRUE,14,IF(J19=FALSE,0,\" \"))","v":0},null,"L - Normal",false,{"$f":"IF(N19=TRUE,14,IF(N19=FALSE,0,\" \"))","v":0},null,"L - Normal",false,{"$f":"IF(R19=TRUE,14,IF(R19=FALSE,0,\" \"))","v":0}]
["D - Normal",false,{"$f":"IF(B20=TRUE,23,IF(B20=FALSE,0,\" \"))","v":0},null,"D - Normal",false,{"$f":"IF(F20=TRUE,23,IF(F20=FALSE,0,\" \"))","v":0},null,"D - Normal",false,{"$f":"IF(J20=TRUE,23,IF(J20=FALSE,0,\" \"))","v":0},null,"D - Normal",false,{"$f":"IF(N20=TRUE,23,IF(N20=FALSE,0,\" \"))","v":0},null,"D - Normal",false,{"$f":"IF(R20=TRUE,23,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,2,IF(B23=FALSE,0,\" \"))","v":0},null,"B - H/C",false,{"$f":"IF(F23=TRUE,2,IF(F23=FALSE,0,\" \"))","v":0},null,"B - H/C",false,{"$f":"IF(J23=TRUE,2,IF(J23=FALSE,0,\" \"))","v":0},null,"B - H/C",false,{"$f":"IF(N23=TRUE,2,IF(N23=FALSE,0,\" \"))","v":0},null,"B - H/C",false,{"$f":"IF(R23=TRUE,2,IF(R23=FALSE,0,\" \"))","v":0}]
["L - H/C",false,{"$f":"IF(B24=TRUE,3,IF(B24=FALSE,0,\" \"))","v":0},null,"L - H/C",false,{"$f":"IF(F24=TRUE,3,IF(F24=FALSE,0,\" \"))","v":0},null,"L - H/C",false,{"$f":"IF(J24=TRUE,3,IF(J24=FALSE,0,\" \"))","v":0},null,"L - H/C",false,{"$f":"IF(N24=TRUE,3,IF(N24=FALSE,0,\" \"))","v":0},null,"L - H/C",false,{"$f":"IF(R24=TRUE,3,IF(R24=FALSE,0,\" \"))","v":0}]
["D - H/C",false,{"$f":"IF(B25=TRUE,5,IF(B25=FALSE,0,\" \"))","v":0},null,"D - H/C",false,{"$f":"IF(F25=TRUE,5,IF(F25=FALSE,0,\" \"))","v":0},null,"D - H/C",false,{"$f":"IF(J25=TRUE,5,IF(J25=FALSE,0,\" \"))","v":0},null,"D - H/C",false,{"$f":"IF(N25=TRUE,5,IF(N25=FALSE,0,\" \"))","v":0},null,"D - H/C",false,{"$f":"IF(R25=TRUE,5,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,9,IF(B34=FALSE,0,\" \"))","v":0},null,"B - Normal",false,{"$f":"IF(F34=TRUE,9,IF(F34=FALSE,0,\" \"))","v":0},null,"B - Normal",false,{"$f":"IF(J34=TRUE,9,IF(J34=FALSE,0,\" \"))","v":0},null,"B - Normal",false,{"$f":"IF(N34=TRUE,9,IF(N34=FALSE,0,\" \"))","v":0},null,"B - Normal",false,{"$f":"IF(R34=TRUE,9,IF(R34=FALSE,0,\" \"))","v":0}]
["L - Normal",false,{"$f":"IF(B35=TRUE,14,IF(B35=FALSE,0,\" \"))","v":0},null,"L - Normal",false,{"$f":"IF(F35=TRUE,14,IF(F35=FALSE,0,\" \"))","v":0},null,"L - Normal",false,{"$f":"IF(J35=TRUE,14,IF(J35=FALSE,0,\" \"))","v":0},null,"L - Normal",false,{"$f":"IF(N35=TRUE,14,IF(N35=FALSE,0,\" \"))","v":0},null,"L - Normal",false,{"$f":"IF(R35=TRUE,14,IF(R35=FALSE,0,\" \"))","v":0}]
["D - Normal",false,{"$f":"IF(B36=TRUE,23,IF(B36=FALSE,0,\" \"))","v":0},null,"D - Normal",false,{"$f":"IF(F36=TRUE,23,IF(F36=FALSE,0,\" \"))","v":0},null,"D - Normal",false,{"$f":"IF(J36=TRUE,23,IF(J36=FALSE,0,\" \"))","v":0},null,"D - Normal",false,{"$f":"IF(N36=TRUE,23,IF(N36=FALSE,0,\" \"))","v":0},null,"D - Normal",false,{"$f":"IF(R36=TRUE,23,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,2,IF(B39=FALSE,0,\" \"))","v":0},null,"B - H/C",false,{"$f":"IF(F39=TRUE,2,IF(F39=FALSE,0,\" \"))","v":0},null,"B - H/C",false,{"$f":"IF(J39=TRUE,2,IF(J39=FALSE,0,\" \"))","v":0},null,"B - H/C",false,{"$f":"IF(N39=TRUE,2,IF(N39=FALSE,0,\" \"))","v":0},null,"B - H/C",false,{"$f":"IF(R39=TRUE,2,IF(R39=FALSE,0,\" \"))","v":0}]
["L - H/C",false,{"$f":"IF(B40=TRUE,3,IF(B40=FALSE,0,\" \"))","v":0},null,"L - H/C",false,{"$f":"IF(F40=TRUE,3,IF(F40=FALSE,0,\" \"))","v":0},null,"L - H/C",false,{"$f":"IF(J40=TRUE,3,IF(J40=FALSE,0,\" \"))","v":0},null,"L - H/C",false,{"$f":"IF(N40=TRUE,3,IF(N40=FALSE,0,\" \"))","v":0},null,"L - H/C",false,{"$f":"IF(R40=TRUE,3,IF(R40=FALSE,0,\" \"))","v":0}]
["D - H/C",false,{"$f":"IF(B41=TRUE,5,IF(B41=FALSE,0,\" \"))","v":0},null,"D - H/C",false,{"$f":"IF(F41=TRUE,5,IF(F41=FALSE,0,\" \"))","v":0},null,"D - H/C",false,{"$f":"IF(J41=TRUE,5,IF(J41=FALSE,0,\" \"))","v":0},null,"D - H/C",false,{"$f":"IF(N41=TRUE,5,IF(N41=FALSE,0,\" \"))","v":0},null,"D - H/C",false,{"$f":"IF(R41=TRUE,5,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,9,IF(B49=FALSE,0,\" \"))","v":0},null,"B - Normal",false,{"$f":"IF(F49=TRUE,9,IF(F49=FALSE,0,\" \"))","v":0},null,"B - Normal",false,{"$f":"IF(J49=TRUE,9,IF(J49=FALSE,0,\" \"))","v":0},null,"B - Normal",false,{"$f":"IF(N49=TRUE,9,IF(N49=FALSE,0,\" \"))","v":0},null,"B - Normal",false,{"$f":"IF(R49=TRUE,9,IF(R49=FALSE,0,\" \"))","v":0}]
["L - Normal",false,{"$f":"IF(B50=TRUE,14,IF(B50=FALSE,0,\" \"))","v":0},null,"L - Normal",false,{"$f":"IF(F50=TRUE,14,IF(F50=FALSE,0,\" \"))","v":0},null,"L - Normal",false,{"$f":"IF(J50=TRUE,14,IF(J50=FALSE,0,\" \"))","v":0},null,"L - Normal",false,{"$f":"IF(N50=TRUE,14,IF(N50=FALSE,0,\" \"))","v":0},null,"L - Normal",false,{"$f":"IF(R50=TRUE,14,IF(R50=FALSE,0,\" \"))","v":0}]
["D - Normal",false,{"$f":"IF(B51=TRUE,23,IF(B51=FALSE,0,\" \"))","v":0},null,"D - Normal",false,{"$f":"IF(F51=TRUE,23,IF(F51=FALSE,0,\" \"))","v":0},null,"D - Normal",false,{"$f":"IF(J51=TRUE,23,IF(J51=FALSE,0,\" \"))","v":0},null,"D - Normal",false,{"$f":"IF(N51=TRUE,23,IF(N51=FALSE,0,\" \"))","v":0},null,"D - Normal",false,{"$f":"IF(R51=TRUE,23,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,2,IF(B54=FALSE,0,\" \"))","v":0},null,"B - H/C",false,{"$f":"IF(F54=TRUE,2,IF(F54=FALSE,0,\" \"))","v":0},null,"B - H/C",false,{"$f":"IF(J54=TRUE,2,IF(J54=FALSE,0,\" \"))","v":0},null,"B - H/C",false,{"$f":"IF(N54=TRUE,2,IF(N54=FALSE,0,\" \"))","v":0},null,"B - H/C",false,{"$f":"IF(R54=TRUE,2,IF(R54=FALSE,0,\" \"))","v":0}]
["L - H/C",false,{"$f":"IF(B55=TRUE,3,IF(B55=FALSE,0,\" \"))","v":0},null,"L - H/C",false,{"$f":"IF(F55=TRUE,3,IF(F55=FALSE,0,\" \"))","v":0},null,"L - H/C",false,{"$f":"IF(J55=TRUE,3,IF(J55=FALSE,0,\" \"))","v":0},null,"L - H/C",false,{"$f":"IF(N55=TRUE,3,IF(N55=FALSE,0,\" \"))","v":0},null,"L - H/C",false,{"$f":"IF(R55=TRUE,3,IF(R55=FALSE,0,\" \"))","v":0}]
["D - H/C",false,{"$f":"IF(B56=TRUE,5,IF(B56=FALSE,0,\" \"))","v":0},null,"D - H/C",false,{"$f":"IF(F56=TRUE,5,IF(F56=FALSE,0,\" \"))","v":0},null,"D - H/C",false,{"$f":"IF(J56=TRUE,5,IF(J56=FALSE,0,\" \"))","v":0},null,"D - H/C",false,{"$f":"IF(N56=TRUE,5,IF(N56=FALSE,0,\" \"))","v":0},null,"D - H/C",false,{"$f":"IF(R56=TRUE,5,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,9,IF(B65=FALSE,0,\" \"))","v":0},null,"B - Normal",false,{"$f":"IF(F65=TRUE,9,IF(F65=FALSE,0,\" \"))","v":0},null,"B - Normal",false,{"$f":"IF(J65=TRUE,9,IF(J65=FALSE,0,\" \"))","v":0},null,"B - Normal",false,{"$f":"IF(N65=TRUE,9,IF(N65=FALSE,0,\" \"))","v":0},null,"B - Normal",false,{"$f":"IF(R65=TRUE,9,IF(R65=FALSE,0,\" \"))","v":0}]
["L - Normal",false,{"$f":"IF(B66=TRUE,14,IF(B66=FALSE,0,\" \"))","v":0},null,"L - Normal",false,{"$f":"IF(F66=TRUE,14,IF(F66=FALSE,0,\" \"))","v":0},null,"L - Normal",false,{"$f":"IF(J66=TRUE,14,IF(J66=FALSE,0,\" \"))","v":0},null,"L - Normal",false,{"$f":"IF(N66=TRUE,14,IF(N66=FALSE,0,\" \"))","v":0},null,"L - Normal",false,{"$f":"IF(R66=TRUE,14,IF(R66=FALSE,0,\" \"))","v":0}]
["D - Normal",false,{"$f":"IF(B67=TRUE,23,IF(B67=FALSE,0,\" \"))","v":0},null,"D - Normal",false,{"$f":"IF(F67=TRUE,23,IF(F67=FALSE,0,\" \"))","v":0},null,"D - Normal",false,{"$f":"IF(J67=TRUE,23,IF(J67=FALSE,0,\" \"))","v":0},null,"D - Normal",false,{"$f":"IF(N67=TRUE,23,IF(N67=FALSE,0,\" \"))","v":0},null,"D - Normal",false,{"$f":"IF(R67=TRUE,23,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,2,IF(B70=FALSE,0,\" \"))","v":0},null,"B - H/C",false,{"$f":"IF(F70=TRUE,2,IF(F70=FALSE,0,\" \"))","v":0},null,"B - H/C",false,{"$f":"IF(J70=TRUE,2,IF(J70=FALSE,0,\" \"))","v":0},null,"B - H/C",false,{"$f":"IF(N70=TRUE,2,IF(N70=FALSE,0,\" \"))","v":0},null,"B - H/C",false,{"$f":"IF(R70=TRUE,2,IF(R70=FALSE,0,\" \"))","v":0}]
["L - H/C",false,{"$f":"IF(B71=TRUE,3,IF(B71=FALSE,0,\" \"))","v":0},null,"L - H/C",false,{"$f":"IF(F71=TRUE,3,IF(F71=FALSE,0,\" \"))","v":0},null,"L - H/C",false,{"$f":"IF(J71=TRUE,3,IF(J71=FALSE,0,\" \"))","v":0},null,"L - H/C",false,{"$f":"IF(N71=TRUE,3,IF(N71=FALSE,0,\" \"))","v":0},null,"L - H/C",false,{"$f":"IF(R71=TRUE,3,IF(R71=FALSE,0,\" \"))","v":0}]
["D - H/C",false,{"$f":"IF(B72=TRUE,5,IF(B72=FALSE,0,\" \"))","v":0},null,"D - H/C",false,{"$f":"IF(F72=TRUE,5,IF(F72=FALSE,0,\" \"))","v":0},null,"D - H/C",false,{"$f":"IF(J72=TRUE,5,IF(J72=FALSE,0,\" \"))","v":0},null,"D - H/C",false,{"$f":"IF(N72=TRUE,5,IF(N72=FALSE,0,\" \"))","v":0},null,"D - H/C",false,{"$f":"IF(R72=TRUE,5,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}]
[]
[]
["Page 4a 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(B80=TRUE,9,IF(B80=FALSE,0,\" \"))","v":0},null,"B - Normal",false,{"$f":"IF(F80=TRUE,9,IF(F80=FALSE,0,\" \"))","v":0},null,"B - Normal",false,{"$f":"IF(J80=TRUE,9,IF(J80=FALSE,0,\" \"))","v":0},null,"B - Normal",false,{"$f":"IF(N80=TRUE,9,IF(N80=FALSE,0,\" \"))","v":0},null,"B - Normal",false,{"$f":"IF(R80=TRUE,9,IF(R80=FALSE,0,\" \"))","v":0}]
["L - Normal",false,{"$f":"IF(B81=TRUE,14,IF(B81=FALSE,0,\" \"))","v":0},null,"L - Normal",false,{"$f":"IF(F81=TRUE,14,IF(F81=FALSE,0,\" \"))","v":0},null,"L - Normal",false,{"$f":"IF(J81=TRUE,14,IF(J81=FALSE,0,\" \"))","v":0},null,"L - Normal",false,{"$f":"IF(N81=TRUE,14,IF(N81=FALSE,0,\" \"))","v":0},null,"L - Normal",false,{"$f":"IF(R81=TRUE,14,IF(R81=FALSE,0,\" \"))","v":0}]
["D - Normal",false,{"$f":"IF(B82=TRUE,23,IF(B82=FALSE,0,\" \"))","v":0},null,"D - Normal",false,{"$f":"IF(F82=TRUE,23,IF(F82=FALSE,0,\" \"))","v":0},null,"D - Normal",false,{"$f":"IF(J82=TRUE,23,IF(J82=FALSE,0,\" \"))","v":0},null,"D - Normal",false,{"$f":"IF(N82=TRUE,23,IF(N82=FALSE,0,\" \"))","v":0},null,"D - Normal",false,{"$f":"IF(R82=TRUE,23,IF(R82=FALSE,0,\" \"))","v":0}]
["Day1, Meals SubTotal",null,{"$f":"SUM(C80:C82)","v":0},null,"Day2, Meals SubTotal",null,{"$f":"SUM(G80:G82)","v":0},null,"Day3, Meals SubTotal",null,{"$f":"SUM(K80:K82)","v":0},null,"Day4, Meals SubTotal",null,{"$f":"SUM(O80:O82)","v":0},null,"Day5, Meals SubTotal",null,{"$f":"SUM(S80:S82)","v":0}]
[]
["B - H/C",false,{"$f":"IF(B85=TRUE,2,IF(B85=FALSE,0,\" \"))","v":0},null,"B - H/C",false,{"$f":"IF(F85=TRUE,2,IF(F85=FALSE,0,\" \"))","v":0},null,"B - H/C",false,{"$f":"IF(J85=TRUE,2,IF(J85=FALSE,0,\" \"))","v":0},null,"B - H/C",false,{"$f":"IF(N85=TRUE,2,IF(N85=FALSE,0,\" \"))","v":0},null,"B - H/C",false,{"$f":"IF(R85=TRUE,2,IF(R85=FALSE,0,\" \"))","v":0}]
["L - H/C",false,{"$f":"IF(B86=TRUE,3,IF(B86=FALSE,0,\" \"))","v":0},null,"L - H/C",false,{"$f":"IF(F86=TRUE,3,IF(F86=FALSE,0,\" \"))","v":0},null,"L - H/C",false,{"$f":"IF(J86=TRUE,3,IF(J86=FALSE,0,\" \"))","v":0},null,"L - H/C",false,{"$f":"IF(N86=TRUE,3,IF(N86=FALSE,0,\" \"))","v":0},null,"L - H/C",false,{"$f":"IF(R86=TRUE,3,IF(R86=FALSE,0,\" \"))","v":0}]
["D - H/C",false,{"$f":"IF(B87=TRUE,5,IF(B87=FALSE,0,\" \"))","v":0},null,"D - H/C",false,{"$f":"IF(F87=TRUE,5,IF(F87=FALSE,0,\" \"))","v":0},null,"D - H/C",false,{"$f":"IF(J87=TRUE,5,IF(J87=FALSE,0,\" \"))","v":0},null,"D - H/C",false,{"$f":"IF(N87=TRUE,5,IF(N87=FALSE,0,\" \"))","v":0},null,"D - H/C",false,{"$f":"IF(R87=TRUE,5,IF(R87=FALSE,0,\" \"))","v":0}]
["Day1, H/C SubTotal",2,{"$f":"SUM(C85:C87)","v":0},null,"Day2, H/C SubTotal",2,{"$f":"SUM(G85:G87)","v":0},null,"Day3, H/C SubTotal",null,{"$f":"SUM(K85:K87)","v":0},null,"Day4, H/C SubTotal",null,{"$f":"SUM(O85:O87)","v":0},null,"Day5, H/C SubTotal",null,{"$f":"SUM(S85:S87)","v":0}]
[]
["Day1, Grand Total",2,{"$f":"SUM(C83+C88)","v":0},null,"Day2, Grand Total",2,{"$f":"SUM(G83+G88)","v":0},null,"Day3, Grand Total",null,{"$f":"SUM(K83+K88)","v":0},null,"Day4, Grand Total",null,{"$f":"SUM(O83+O88)","v":0},null,"Day5, Grand Total",null,{"$f":"SUM(S83+S88)","v":0},null,{"$f":"SUM(+S90+O90+K90+G90+C90)","v":0}]
[]
[]
[]
["Page 4b 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(B96=TRUE,9,IF(B96=FALSE,0,\" \"))","v":0},null,"B - Normal",false,{"$f":"IF(F96=TRUE,9,IF(F96=FALSE,0,\" \"))","v":0},null,"B - Normal",false,{"$f":"IF(J96=TRUE,9,IF(J96=FALSE,0,\" \"))","v":0},null,"B - Normal",false,{"$f":"IF(N96=TRUE,9,IF(N96=FALSE,0,\" \"))","v":0},null,"B - Normal",false,{"$f":"IF(R96=TRUE,9,IF(R96=FALSE,0,\" \"))","v":0}]
["L - Normal",false,{"$f":"IF(B97=TRUE,14,IF(B97=FALSE,0,\" \"))","v":0},null,"L - Normal",false,{"$f":"IF(F97=TRUE,14,IF(F97=FALSE,0,\" \"))","v":0},null,"L - Normal",false,{"$f":"IF(J97=TRUE,14,IF(J97=FALSE,0,\" \"))","v":0},null,"L - Normal",false,{"$f":"IF(N97=TRUE,14,IF(N97=FALSE,0,\" \"))","v":0},null,"L - Normal",false,{"$f":"IF(R97=TRUE,14,IF(R97=FALSE,0,\" \"))","v":0}]
["D - Normal",false,{"$f":"IF(B98=TRUE,23,IF(B98=FALSE,0,\" \"))","v":0},null,"D - Normal",false,{"$f":"IF(F98=TRUE,23,IF(F98=FALSE,0,\" \"))","v":0},null,"D - Normal",false,{"$f":"IF(J98=TRUE,23,IF(J98=FALSE,0,\" \"))","v":0},null,"D - Normal",false,{"$f":"IF(N98=TRUE,23,IF(N98=FALSE,0,\" \"))","v":0},null,"D - Normal",false,{"$f":"IF(R98=TRUE,23,IF(R98=FALSE,0,\" \"))","v":0}]
["Day1, Meals SubTotal",2,{"$f":"SUM(C96:C98)","v":0},null,"Day2, Meals SubTotal",2,{"$f":"SUM(G96:G98)","v":0},null,"Day3, Meals SubTotal",null,{"$f":"SUM(K96:K98)","v":0},null,"Day4, Meals SubTotal",null,{"$f":"SUM(O96:O98)","v":0},null,"Day5, Meals SubTotal",null,{"$f":"SUM(S96:S98)","v":0}]
[]
["B - H/C",false,{"$f":"IF(B101=TRUE,2,IF(B101=FALSE,0,\" \"))","v":0},null,"B - H/C",false,{"$f":"IF(F101=TRUE,2,IF(F101=FALSE,0,\" \"))","v":0},null,"B - H/C",false,{"$f":"IF(J101=TRUE,2,IF(J101=FALSE,0,\" \"))","v":0},null,"B - H/C",false,{"$f":"IF(N101=TRUE,2,IF(N101=FALSE,0,\" \"))","v":0},null,"B - H/C",false,{"$f":"IF(R101=TRUE,2,IF(R101=FALSE,0,\" \"))","v":0}]
["L - H/C",false,{"$f":"IF(B102=TRUE,3,IF(B102=FALSE,0,\" \"))","v":0},null,"L - H/C",false,{"$f":"IF(F102=TRUE,3,IF(F102=FALSE,0,\" \"))","v":0},null,"L - H/C",false,{"$f":"IF(J102=TRUE,3,IF(J102=FALSE,0,\" \"))","v":0},null,"L - H/C",false,{"$f":"IF(N102=TRUE,3,IF(N102=FALSE,0,\" \"))","v":0},null,"L - H/C",false,{"$f":"IF(R102=TRUE,3,IF(R102=FALSE,0,\" \"))","v":0}]
["D - H/C",false,{"$f":"IF(B103=TRUE,5,IF(B103=FALSE,0,\" \"))","v":0},null,"D - H/C",false,{"$f":"IF(F103=TRUE,5,IF(F103=FALSE,0,\" \"))","v":0},null,"D - H/C",false,{"$f":"IF(J103=TRUE,5,IF(J103=FALSE,0,\" \"))","v":0},null,"D - H/C",false,{"$f":"IF(N103=TRUE,5,IF(N103=FALSE,0,\" \"))","v":0},null,"D - H/C",false,{"$f":"IF(R103=TRUE,5,IF(R103=FALSE,0,\" \"))","v":0}]
["Day1, H/C SubTotal",null,{"$f":"SUM(C101:C103)","v":0},null,"Day2, H/C SubTotal",null,{"$f":"SUM(G101:G103)","v":0},null,"Day3, H/C SubTotal",null,{"$f":"SUM(K101:K103)","v":0},null,"Day4, H/C SubTotal",null,{"$f":"SUM(O101:O103)","v":0},null,"Day5, H/C SubTotal",null,{"$f":"SUM(S101:S103)","v":0}]
[]
["Day1, Grand Total",null,{"$f":"SUM(C99+C104)","v":0},null,"Day2, Grand Total",null,{"$f":"SUM(G99+G104)","v":0},null,"Day3, Grand Total",null,{"$f":"SUM(K99+K104)","v":0},null,"Day4, Grand Total",null,{"$f":"SUM(O99+O104)","v":0},null,"Day5, Grand Total",null,{"$f":"SUM(S99+S104)","v":0},null,{"$f":"SUM(+S106+O106+K106+G106+C106)","v":0}]
[]
[]
["Page 5a 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(B111=TRUE,9,IF(B111=FALSE,0,\" \"))","v":0},null,"B - Normal",false,{"$f":"IF(F111=TRUE,9,IF(F111=FALSE,0,\" \"))","v":0},null,"B - Normal",false,{"$f":"IF(J111=TRUE,9,IF(J111=FALSE,0,\" \"))","v":0},null,"B - Normal",false,{"$f":"IF(N111=TRUE,9,IF(N111=FALSE,0,\" \"))","v":0},null,"B - Normal",false,{"$f":"IF(R111=TRUE,9,IF(R111=FALSE,0,\" \"))","v":0}]
["L - Normal",false,{"$f":"IF(B112=TRUE,14,IF(B112=FALSE,0,\" \"))","v":0},null,"L - Normal",false,{"$f":"IF(F112=TRUE,14,IF(F112=FALSE,0,\" \"))","v":0},null,"L - Normal",false,{"$f":"IF(J112=TRUE,14,IF(J112=FALSE,0,\" \"))","v":0},null,"L - Normal",false,{"$f":"IF(N112=TRUE,14,IF(N112=FALSE,0,\" \"))","v":0},null,"L - Normal",false,{"$f":"IF(R112=TRUE,14,IF(R112=FALSE,0,\" \"))","v":0}]
["D - Normal",false,{"$f":"IF(B113=TRUE,23,IF(B113=FALSE,0,\" \"))","v":0},null,"D - Normal",false,{"$f":"IF(F113=TRUE,23,IF(F113=FALSE,0,\" \"))","v":0},null,"D - Normal",false,{"$f":"IF(J113=TRUE,23,IF(J113=FALSE,0,\" \"))","v":0},null,"D - Normal",false,{"$f":"IF(N113=TRUE,23,IF(N113=FALSE,0,\" \"))","v":0},null,"D - Normal",false,{"$f":"IF(R113=TRUE,23,IF(R113=FALSE,0,\" \"))","v":0}]
["Day1, Meals SubTotal",null,{"$f":"SUM(C111:C113)","v":0},null,"Day2, Meals SubTotal",null,{"$f":"SUM(G111:G113)","v":0},null,"Day3, Meals SubTotal",null,{"$f":"SUM(K111:K113)","v":0},null,"Day4, Meals SubTotal",null,{"$f":"SUM(O111:O113)","v":0},null,"Day5, Meals SubTotal",null,{"$f":"SUM(S111:S113)","v":0}]
[]
["B - H/C",false,{"$f":"IF(B116=TRUE,2,IF(B116=FALSE,0,\" \"))","v":0},null,"B - H/C",false,{"$f":"IF(F116=TRUE,2,IF(F116=FALSE,0,\" \"))","v":0},null,"B - H/C",false,{"$f":"IF(J116=TRUE,2,IF(J116=FALSE,0,\" \"))","v":0},null,"B - H/C",false,{"$f":"IF(N116=TRUE,2,IF(N116=FALSE,0,\" \"))","v":0},null,"B - H/C",false,{"$f":"IF(R116=TRUE,2,IF(R116=FALSE,0,\" \"))","v":0}]
["L - H/C",false,{"$f":"IF(B117=TRUE,3,IF(B117=FALSE,0,\" \"))","v":0},null,"L - H/C",false,{"$f":"IF(F117=TRUE,3,IF(F117=FALSE,0,\" \"))","v":0},null,"L - H/C",false,{"$f":"IF(J117=TRUE,3,IF(J117=FALSE,0,\" \"))","v":0},null,"L - H/C",false,{"$f":"IF(N117=TRUE,3,IF(N117=FALSE,0,\" \"))","v":0},null,"L - H/C",false,{"$f":"IF(R117=TRUE,3,IF(R117=FALSE,0,\" \"))","v":0}]
["D - H/C",false,{"$f":"IF(B118=TRUE,5,IF(B118=FALSE,0,\" \"))","v":0},null,"D - H/C",false,{"$f":"IF(F118=TRUE,5,IF(F118=FALSE,0,\" \"))","v":0},null,"D - H/C",false,{"$f":"IF(J118=TRUE,5,IF(J118=FALSE,0,\" \"))","v":0},null,"D - H/C",false,{"$f":"IF(N118=TRUE,5,IF(N118=FALSE,0,\" \"))","v":0},null,"D - H/C",false,{"$f":"IF(R118=TRUE,5,IF(R118=FALSE,0,\" \"))","v":0}]
["Day1, H/C SubTotal",null,{"$f":"SUM(C116:C118)","v":0},null,"Day2, H/C SubTotal",null,{"$f":"SUM(G116:G118)","v":0},null,"Day3, H/C SubTotal",null,{"$f":"SUM(K116:K118)","v":0},null,"Day4, H/C SubTotal",null,{"$f":"SUM(O116:O118)","v":0},null,"Day5, H/C SubTotal",null,{"$f":"SUM(S116:S118)","v":0}]
[]
["Day1, Grand Total",null,{"$f":"SUM(C114+C119)","v":0},null,"Day2, Grand Total",null,{"$f":"SUM(G114+G119)","v":0},null,"Day3, Grand Total",null,{"$f":"SUM(K114+K119)","v":0},null,"Day4, Grand Total",null,{"$f":"SUM(O114+O119)","v":0},null,"Day5, Grand Total",null,{"$f":"SUM(S114+S119)","v":0},null,{"$f":"SUM(+S121+O121+K121+G121+C121)","v":0}]
[]
[]
[]
["Page 5b 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(B127=TRUE,9,IF(B127=FALSE,0,\" \"))","v":0},null,"B - Normal",false,{"$f":"IF(F127=TRUE,9,IF(F127=FALSE,0,\" \"))","v":0},null,"B - Normal",false,{"$f":"IF(J127=TRUE,9,IF(J127=FALSE,0,\" \"))","v":0},null,"B - Normal",false,{"$f":"IF(N127=TRUE,9,IF(N127=FALSE,0,\" \"))","v":0},null,"B - Normal",false,{"$f":"IF(R127=TRUE,9,IF(R127=FALSE,0,\" \"))","v":0}]
["L - Normal",false,{"$f":"IF(B128=TRUE,14,IF(B128=FALSE,0,\" \"))","v":0},null,"L - Normal",false,{"$f":"IF(F128=TRUE,14,IF(F128=FALSE,0,\" \"))","v":0},null,"L - Normal",false,{"$f":"IF(J128=TRUE,14,IF(J128=FALSE,0,\" \"))","v":0},null,"L - Normal",false,{"$f":"IF(N128=TRUE,14,IF(N128=FALSE,0,\" \"))","v":0},null,"L - Normal",false,{"$f":"IF(R128=TRUE,14,IF(R128=FALSE,0,\" \"))","v":0}]
["D - Normal",false,{"$f":"IF(B129=TRUE,23,IF(B129=FALSE,0,\" \"))","v":0},null,"D - Normal",false,{"$f":"IF(F129=TRUE,23,IF(F129=FALSE,0,\" \"))","v":0},null,"D - Normal",false,{"$f":"IF(J129=TRUE,23,IF(J129=FALSE,0,\" \"))","v":0},null,"D - Normal",false,{"$f":"IF(N129=TRUE,23,IF(N129=FALSE,0,\" \"))","v":0},null,"D - Normal",false,{"$f":"IF(R129=TRUE,23,IF(R129=FALSE,0,\" \"))","v":0}]
["Day1, Meals SubTotal",null,{"$f":"SUM(C127:C129)","v":0},null,"Day2, Meals SubTotal",null,{"$f":"SUM(G127:G129)","v":0},null,"Day3, Meals SubTotal",null,{"$f":"SUM(K127:K129)","v":0},null,"Day4, Meals SubTotal",null,{"$f":"SUM(O127:O129)","v":0},null,"Day5, Meals SubTotal",null,{"$f":"SUM(S127:S129)","v":0}]
[]
["B - H/C",false,{"$f":"IF(B132=TRUE,2,IF(B132=FALSE,0,\" \"))","v":0},null,"B - H/C",false,{"$f":"IF(F132=TRUE,2,IF(F132=FALSE,0,\" \"))","v":0},null,"B - H/C",false,{"$f":"IF(J132=TRUE,2,IF(J132=FALSE,0,\" \"))","v":0},null,"B - H/C",false,{"$f":"IF(N132=TRUE,2,IF(N132=FALSE,0,\" \"))","v":0},null,"B - H/C",false,{"$f":"IF(R132=TRUE,2,IF(R132=FALSE,0,\" \"))","v":0}]
["L - H/C",false,{"$f":"IF(B133=TRUE,3,IF(B133=FALSE,0,\" \"))","v":0},null,"L - H/C",false,{"$f":"IF(F133=TRUE,3,IF(F133=FALSE,0,\" \"))","v":0},null,"L - H/C",false,{"$f":"IF(J133=TRUE,3,IF(J133=FALSE,0,\" \"))","v":0},null,"L - H/C",false,{"$f":"IF(N133=TRUE,3,IF(N133=FALSE,0,\" \"))","v":0},null,"L - H/C",false,{"$f":"IF(R133=TRUE,3,IF(R133=FALSE,0,\" \"))","v":0}]
["D - H/C",false,{"$f":"IF(B134=TRUE,5,IF(B134=FALSE,0,\" \"))","v":0},null,"D - H/C",false,{"$f":"IF(F134=TRUE,5,IF(F134=FALSE,0,\" \"))","v":0},null,"D - H/C",false,{"$f":"IF(J134=TRUE,5,IF(J134=FALSE,0,\" \"))","v":0},null,"D - H/C",false,{"$f":"IF(N134=TRUE,5,IF(N134=FALSE,0,\" \"))","v":0},null,"D - H/C",false,{"$f":"IF(R134=TRUE,5,IF(R134=FALSE,0,\" \"))","v":0}]
["Day1, H/C SubTotal",null,{"$f":"SUM(C132:C134)","v":0},null,"Day2, H/C SubTotal",null,{"$f":"SUM(G132:G134)","v":0},null,"Day3, H/C SubTotal",null,{"$f":"SUM(K132:K134)","v":0},null,"Day4, H/C SubTotal",null,{"$f":"SUM(O132:O134)","v":0},null,"Day5, H/C SubTotal",null,{"$f":"SUM(S132:S134)","v":0}]
[]
["Day1, Grand Total",null,{"$f":"SUM(C130+C135)","v":0},null,"Day2, Grand Total",null,{"$f":"SUM(G130+G135)","v":0},null,"Day3, Grand Total",null,{"$f":"SUM(K130+K135)","v":0},null,"Day4, Grand Total",null,{"$f":"SUM(O130+O135)","v":0},null,"Day5, Grand Total",null,{"$f":"SUM(S130+S135)","v":0},null,{"$f":"SUM(+S137+O137+K137+G137+C137)","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]
[]
[]
[null,"Conference Fees, Page 4a, b",null,null,null,"Airline, Page 4a, 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 5a, b",null,null,null,"Airline, Page 5a, b"]
[null,"True / False Results",null,null,null,"True / False Results"]
[]
[]
[null,2,null,null,null,2]
[]
[null,2,null,null,null,2]

{"sheet":"- (2)","index":14,"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]