{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Expense Form"],"not_rendered":{"images":1,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Expense Form","index":0,"n_rows":156,"n_cols":20,"rows_kept":156,"merged":[[11,2,11,5],[63,1,65,1],[63,3,63,11],[64,3,64,6],[64,8,64,11],[65,3,65,11],[65,13,65,15],[65,17,65,19],[66,2,66,8],[66,10,66,11],[66,19,109,19],[67,2,67,8],[67,10,69,11],[68,2,68,8],[69,2,69,8],[70,2,70,6],[70,7,70,8],[70,10,73,11],[71,2,71,6],[71,7,71,8],[72,2,72,6],[72,7,72,8],[73,2,73,6],[73,7,73,8],[74,2,74,6],[74,7,74,8],[74,10,74,11],[75,2,75,6],[75,7,75,8],[75,10,76,11],[76,2,76,6],[76,7,76,8],[77,2,77,8],[77,10,80,11],[78,2,78,8],[79,2,79,8],[80,2,80,8],[81,2,81,8],[81,10,81,11],[82,2,82,8],[82,10,83,11],[83,2,83,8],[84,1,84,4],[84,6,84,7],[84,8,84,9],[85,1,85,7],[85,9,86,11],[86,1,86,7],[87,2,87,5],[87,7,90,7],[87,8,90,8],[87,9,90,9],[87,10,107,11],[88,1,91,1],[88,2,88,5],[89,2,89,5],[90,2,90,6],[91,2,91,5],[92,1,95,1],[92,2,92,5],[92,7,94,7],[92,8,94,8],[92,9,94,9],[93,2,93,5],[94,2,94,6],[95,2,95,5],[96,1,98,1],[96,2,96,5],[97,2,97,6],[98,2,98,5],[99,1,101,1],[99,2,99,5],[100,2,100,6],[101,2,101,5],[102,1,104,1],[102,2,102,5],[103,2,103,6],[104,2,104,5],[105,1,107,1],[105,2,105,5],[106,2,106,6],[107,2,107,5],[108,1,110,1],[108,2,108,5],[108,10,108,11],[109,2,109,6],[109,10,110,11],[110,2,110,5],[111,1,111,9],[112,5,112,6],[112,7,115,9],[113,5,113,6],[114,5,114,6],[115,5,115,6],[116,5,116,6],[117,5,117,6],[118,5,118,6],[119,5,119,6],[120,5,120,6],[121,5,121,6],[122,5,122,6],[122,10,122,11],[123,5,123,6],[123,10,125,11],[124,5,124,6],[124,7,125,9],[125,5,125,6],[126,1,126,9],[126,10,133,11],[127,1,127,9],[128,1,128,9],[129,3,129,9],[130,1,130,9],[131,2,131,9],[132,1,132,2],[132,4,133,9],[133,1,133,3],[134,1,135,5],[134,6,135,9],[134,10,135,11],[137,1,137,11],[138,1,138,2],[138,3,138,8],[138,10,139,11],[139,1,139,2],[139,3,139,8],[140,1,140,2],[140,3,140,8],[140,10,141,11],[141,1,141,2],[141,3,141,8],[142,1,142,2],[142,3,142,8],[142,10,143,11],[143,1,143,2],[143,3,143,8],[145,1,146,2],[145,3,146,8],[145,9,146,9],[145,10,146,11],[147,1,148,2],[147,3,148,8],[149,1,150,2],[149,3,150,8],[149,9,150,9],[149,10,150,11],[151,1,152,8],[151,9,152,9],[151,10,152,11],[153,1,153,11],[154,1,154,11],[155,1,158,2],[155,3,158,6],[155,7,158,11]]}
[{"$nulls":13},"DO NOT DELETE VALIDATION LIST INFO BELOW"]
[{"$nulls":13},"Yes"]
[{"$nulls":13},"No"]
[{"$nulls":13},"Mileage is not payable for this meeting type."]
[{"$nulls":13},"Trip to Location: Would this have been a WCB in-office day for you?  →"]
[null,null,"No Breakfast$>6:30am Start","No Lunch$>12:0pm Start","No Dinner$ Home < 6:30 pm",{"$nulls":8},"Return trip from Location: Would this have been a WCB in-office day for you?"]
[null,"Effective April 1, 2022: ",{"v":16,"d":"16.00"},{"v":18,"d":"18.00"},{"v":30,"d":"30.00"},{"v":10,"d":"10.00"},{"$nulls":7},"→TRIP to LOCATION: Enter Addresses e.g. Home (1122 Boogie Ave) to Conference (101 Picket Fence Rd)←"]
[null,null,"Included w/Hotel or Event","Included w/Hotel or Event","Included w/Hotel or Event","No Overnight=No Incidental"]
[null,null,"Replacement Meal Pay't",{"$f":"+C9","v":"Replacement Meal Pay't"},{"$f":"+D9","v":"Replacement Meal Pay't"},{"$nulls":8},"→RETURN TRIP Enter Addresses e.g. Conference (101 Picket Fence Rd) to Home (1122 Boogie Ave)←"]
[{"$nulls":13},"↓Enter 2nd Line below to deduct normal Home/Office Commute for workday travel↓"]
[null,null,"Answer 1 - 3 Below",{"$nulls":10},"→ Enter Normal Commute Addresses in this box e.g. Home (1122 Boogie Ave) to Your WCB Office/SDL←"]
[null,null,"A Replacement Meal Payment may be paid to members where the CEU provided food but the member has:\n(1) a food allergy, or a medical condition, or a religious practice; which (2) prevented them from eating the provided meal; and (3) a the member purchased a replacement meal.",{"$nulls":10},"Did you have additional union-related mileage before returning home?→"]
[null,null,"Please confirm the 1 to 3 below:",{"$nulls":10},"↓Enter addition Line below detailing that union travel↓"]
[null,null,"1. Please confirm you have either a food allergy, a medical condition, or religious reason which prevented you from eating the provided meal.",{"$nulls":10},"Did you have additional union-related mileage before returning home?→"]
[null,null,"2. Please detail how the provided meal was contrary to the above.",{"$nulls":10},"→ Enter Addresses e.g. Hotel (with address) to CEU Office (13775 Commerce Pkwy) ←"]
[null,null,"3. Did you purchase a replacement meal?",null,"Yes","No","No Replacement Meal Purchased",{"$nulls":6},"Please indicate here either:\n1.\tThat you wish to be paid by Direct Deposit; or\n2.\tProvide your current mailing address (if you wish to be paid by cheque)."]
[{"$nulls":4},"Yes, I do.","No, I do not.","Does not meet criteria #1"]
[{"$nulls":13},"Classification Breakdown Complete"]
[{"$nulls":13},"Classification Breakdown INCOMPLETE"]
[{"$nulls":13},"CLASSIFICATION LISTS"]
[{"$nulls":13},"5500 Meetings and Accommodations:5500.01 Meeting Rooms"]
[{"$nulls":13},"5500 Meetings and Accommodations:5500.02 Accommodations"]
[{"$nulls":13},"5500 Meetings and Accommodations:5500.99 Other"]
[]
[{"$nulls":13},"5540 Travel Exec + Stewards:5540.01 Internal:5540.01.1 Exec Meeting"]
[{"$nulls":13},"5540 Travel Exec + Stewards:5540.01 Internal:5540.01.2 Exec Planning Session"]
[{"$nulls":13},"5540 Travel Exec + Stewards:5540.01 Internal:5540.01.3 Travel to CEU Area Office"]
[{"$nulls":13},"5540 Travel Exec + Stewards:5540.01 Internal:5540.01.99 Internal - Other"]
[]
[{"$nulls":13},"5540 Travel Exec + Stewards:5540.02 External:5540.02.1 BCFed Conferences/Conventions"]
[{"$nulls":13},"5540 Travel Exec + Stewards:5540.02 External:5540.02.2 BCFed Committee work (Executive Council & other BCFed Committees)"]
[{"$nulls":13},"5540 Travel Exec + Stewards:5540.02 External:5540.02.3 CLC Conferences/Conventions"]
[{"$nulls":13},"5540 Travel Exec + Stewards:5540.02 External:5540.02.4 NUPGE Conference and/or NUPGE Committee work"]
[{"$nulls":13},"5540 Travel Exec + Stewards:5540.02 External:5540.02.5 WCUC"]
[{"$nulls":13},"5540 Travel Exec + Stewards:5540.02 External:5540.02.99 External - Other"]
[]
[{"$nulls":13},"5550 Shop Stewards Committee:5550.01 Steward Conferences/Seminars/Schools"]
[{"$nulls":13},"5550 Shop Stewards Committee:5550.02 New Steward Training"]
[{"$nulls":13},"5550 Shop Stewards Committee:5550.03 Travel to CEU Area Office"]
[{"$nulls":13},"5550 Shop Stewards Committee:5550.04 CEU Swag"]
[]
[{"$nulls":13},"5555 Solidarity:5555.01 Bursaries"]
[{"$nulls":13},"5555 Solidarity:5555.02 Jointly Funded Charities"]
[{"$nulls":13},"5555 Solidarity:5555.03 Women's Centers and Groups"]
[{"$nulls":13},"5555 Solidarity:5555.04 Youth Related Groups and Charities"]
[{"$nulls":13},"5555 Solidarity:5555.05 Helping Hands"]
[{"$nulls":13},"5555 Solidarity:5555.06 Labour Events"]
[{"$nulls":13},"5555 Solidarity:5555.07 General Health and OH&S"]
[{"$nulls":13},"5555 Solidarity:5555.08 Promotional"]
[{"$nulls":13},"5555 Solidarity:5555.09 Special Events"]
[{"$nulls":13},"5555 Solidarity:5555.10 Yearly Memberships"]
[{"$nulls":13},"5555 Solidarity:5555.11 Non-recurring Donation"]
[]
[{"$nulls":13},"5640 Stationery and Office Expense:5640.01 Office Supplies/Snacks"]
[{"$nulls":13},"5640 Stationery and Office Expense:5640.02 Office Assets/Furniture"]
[{"$nulls":13},"5640 Stationery and Office Expense:5640.03 Office Services (e.g. security, fire, etc)"]
[{"$nulls":13},"5640 Stationery and Office Expense:5640.04 Swag"]
[{"$nulls":13},"5640 Stationery and Office Expense:5640.99 Other"]
[]
[]
[]
[]
[]
[null,"`","All Yellow boxes below \nare mandatory.","CEU EXPENSE FORM                                                 (2024-01-17 Update)  "]
[null,null,"Name: ",{"$nulls":4},"Office:  "]
[null,null,"Reason for Travel:",{"$nulls":10},"Classification Breakdown",{"$nulls":3},"CLASSIFICATION SUB-TOTALS"]
[null,"Date (YYYY-MM-DD)","SECTION A - AIRFARE (NOTE ROUND-TRIP)",{"$nulls":6},"Amount","TOTAL A",{"$nulls":6},"TOTAL: ",{"$f":"SUM(S69:S110)","v":0},{"$f":"IF(S67='Expense Form'!K146,'Expense Form'!N18,'Expense Form'!N19)","v":"Classification Breakdown Complete"}]
[{"$nulls":10},{"$f":"SUM(J68:J70)","v":{"v":0,"d":"$0.00"}},{"$nulls":3},{"$f":"+J68","v":0}]
[{"$nulls":14},{"$f":"+J69","v":0},null,null,{"$f":"+'Expense Form'!N21","v":"5500 Meetings and Accommodations:5500.01 Meeting Rooms"},{"$f":"SUMIF('Expense Form'!$N$68:$N$144,'Expense Form'!R69,'Expense Form'!$O$68:$O$144)","v":0}]
[null," ",{"$nulls":12},{"$f":"+J70","v":0},null,null,{"$f":"+'Expense Form'!N22","v":"5500 Meetings and Accommodations:5500.02 Accommodations"},{"$f":"SUMIF('Expense Form'!$N$68:$N$144,'Expense Form'!R70,'Expense Form'!$O$68:$O$144)","v":0}]
[null,"Date (YYYY-MM-DD)","SECTION B - OTHER TRANSPORTATION FROM/TO",{"$nulls":4},"Type (bus,taxi,ferry)",null,"Amount",{"$nulls":7},{"$f":"+'Expense Form'!N23","v":"5500 Meetings and Accommodations:5500.99 Other"},{"$f":"SUMIF('Expense Form'!$N$68:$N$144,'Expense Form'!R71,'Expense Form'!$O$68:$O$144)","v":0}]
[null," "," ",{"$nulls":11},{"$f":"+J72","v":0}]
[null,null," ",{"$nulls":11},{"$f":"+J73","v":0}]
[null,null," ",{"$nulls":11},0]
[null,null," ",{"$nulls":7},"TOTAL B",{"$nulls":3},0,null,null,{"$f":"+'Expense Form'!N25","v":"5540 Travel Exec + Stewards:5540.01 Internal:5540.01.1 Exec Meeting"},{"$f":"SUMIF('Expense Form'!$N$68:$N$144,'Expense Form'!R75,'Expense Form'!$O$68:$O$144)","v":0}]
[null,null," ",{"$nulls":7},{"$f":"SUM(J72:J77)","v":{"v":0,"d":"$0.00"}},{"$nulls":3},0,null,null,{"$f":"+'Expense Form'!N26","v":"5540 Travel Exec + Stewards:5540.01 Internal:5540.01.2 Exec Planning Session"},{"$f":"SUMIF('Expense Form'!$N$68:$N$144,'Expense Form'!R76,'Expense Form'!$O$68:$O$144)","v":0}]
[null,null," ",{"$nulls":11},0,null,null,{"$f":"+'Expense Form'!N27","v":"5540 Travel Exec + Stewards:5540.01 Internal:5540.01.3 Travel to CEU Area Office"},{"$f":"SUMIF('Expense Form'!$N$68:$N$144,'Expense Form'!R77,'Expense Form'!$O$68:$O$144)","v":0}]
[null,"Date (YYYY-MM-DD)","SECTION C - MISCELLANEOUS EXPENSES",{"$nulls":6},"Amount",{"$nulls":7},{"$f":"+'Expense Form'!N28","v":"5540 Travel Exec + Stewards:5540.01 Internal:5540.01.99 Internal - Other"},{"$f":"SUMIF('Expense Form'!$N$68:$N$144,'Expense Form'!R78,'Expense Form'!$O$68:$O$144)","v":0}]
[null," ",{"$nulls":12},{"$f":"+J79","v":0}]
[null," ",{"$nulls":12},{"$f":"+J80","v":0}]
[null," ",{"$nulls":12},0]
[null," ",{"$nulls":8},"TOTAL C",{"$nulls":3},0,null,null,{"$f":"+'Expense Form'!N30","v":"5540 Travel Exec + Stewards:5540.02 External:5540.02.1 BCFed Conferences/Conventions"},{"$f":"SUMIF('Expense Form'!$N$68:$N$144,'Expense Form'!R82,'Expense Form'!$O$68:$O$144)","v":0}]
[{"$nulls":10},{"$f":"SUM(J79:J84)","v":{"v":0,"d":"$0.00"}},{"$nulls":3},0,null,null,{"$f":"+'Expense Form'!N31","v":"5540 Travel Exec + Stewards:5540.02 External:5540.02.2 BCFed Committee work (Executive Council & other BCFed Committees)"},{"$f":"SUMIF('Expense Form'!$N$68:$N$144,'Expense Form'!R83,'Expense Form'!$O$68:$O$144)","v":0}]
[{"$nulls":14},0,null,null,{"$f":"+'Expense Form'!N32","v":"5540 Travel Exec + Stewards:5540.02 External:5540.02.3 CLC Conferences/Conventions"},{"$f":"SUMIF('Expense Form'!$N$68:$N$144,'Expense Form'!R84,'Expense Form'!$O$68:$O$144)","v":0}]
[null,"SECTION D - MILEAGE            ( ",{"$nulls":3},{"v":0.7,"d":"$0.70"},"PER KILOMETRE)",{"$nulls":10},{"$f":"+'Expense Form'!N33","v":"5540 Travel Exec + Stewards:5540.02 External:5540.02.4 NUPGE Conference and/or NUPGE Committee work"},{"$f":"SUMIF('Expense Form'!$N$68:$N$144,'Expense Form'!R85,'Expense Form'!$O$68:$O$144)","v":0}]
[null,"Are you applying for expense reimbursement related to Mileage? →",{"$nulls":7},{"$f":"IF(I87=N2,N4,\"\")","v":""},{"$nulls":7},{"$f":"+'Expense Form'!N34","v":"5540 Travel Exec + Stewards:5540.02 External:5540.02.5 WCUC"},{"$f":"SUMIF('Expense Form'!$N$68:$N$144,'Expense Form'!R86,'Expense Form'!$O$68:$O$144)","v":0}]
[null,"Was this a CEU general meeting (including an AGM, or a local update meeting in your normal work community)? →",{"$nulls":15},{"$f":"+'Expense Form'!N35","v":"5540 Travel Exec + Stewards:5540.02 External:5540.02.99 External - Other"},{"$f":"SUMIF('Expense Form'!$N$68:$N$144,'Expense Form'!R87,'Expense Form'!$O$68:$O$144)","v":0}]
[null,"Date:\nYYYY-MM-DD","Above mileage/km for the first 5,000 kilometres driven per year.  After that, it is paid at 64¢ per km.\nIt is your obligation to track this.\nStart Address to Destination Address. \nNew Block Section for each destination/direction.",{"$nulls":3},"KM","Difference Between CEU trip and\nCommute to Work",null,"Payable\nAmount",{"$f":"IF($J$86=$N$4,\"↓\",\"\")","v":""}]
[null,null,{"$f":"IF(I87=N3,N5,\"\")","v":""},{"$nulls":14},{"$f":"+'Expense Form'!N37","v":"5550 Shop Stewards Committee:5550.01 Steward Conferences/Seminars/Schools"},{"$f":"SUMIF('Expense Form'!$N$68:$N$144,'Expense Form'!R89,'Expense Form'!$O$68:$O$144)","v":0}]
[null,null,{"$f":"IF(I87=N3,N7,\"\")","v":""},{"$nulls":14},{"$f":"+'Expense Form'!N38","v":"5550 Shop Stewards Committee:5550.02 New Steward Training"},{"$f":"SUMIF('Expense Form'!$N$68:$N$144,'Expense Form'!R90,'Expense Form'!$O$68:$O$144)","v":0}]
[null,null,{"$f":"IF(G89=N2,N10,\"\")","v":""},{"$nulls":14},{"$f":"+'Expense Form'!N39","v":"5550 Shop Stewards Committee:5550.03 Travel to CEU Area Office"},{"$f":"SUMIF('Expense Form'!$N$68:$N$144,'Expense Form'!R91,'Expense Form'!$O$68:$O$144)","v":0}]
[null,null,{"$f":"IF(G89=N2,N11,\"\")","v":""},{"$nulls":4},{"$f":"IF(G90>G92,G90-G92,0)","v":{"v":0,"d":"0.0"}},null,{"$f":"+H92*$F$85","v":{"v":0,"d":"$0.00"}},{"$nulls":4},{"$f":"+J92","v":0},null,null,{"$f":"+'Expense Form'!N40","v":"5550 Shop Stewards Committee:5550.04 CEU Swag"},{"$f":"SUMIF('Expense Form'!$N$68:$N$144,'Expense Form'!R92,'Expense Form'!$O$68:$O$144)","v":0}]
[null,null,{"$f":"IF(I87=N3,N6,\"\")","v":""},{"$nulls":4},"Diff'nce",null,"Payable\nAmount"]
[null,null,{"$f":"IF(I87=N3,N9,\"\")","v":""},{"$nulls":14},{"$f":"+'Expense Form'!N42","v":"5555 Solidarity:5555.01 Bursaries"},{"$f":"SUMIF('Expense Form'!$N$68:$N$144,'Expense Form'!R94,'Expense Form'!$O$68:$O$144)","v":0}]
[null,null,{"$f":"IF(G93=N2,N10,\"\")","v":""},{"$nulls":14},{"$f":"+'Expense Form'!N43","v":"5555 Solidarity:5555.02 Jointly Funded Charities"},{"$f":"SUMIF('Expense Form'!$N$68:$N$144,'Expense Form'!R95,'Expense Form'!$O$68:$O$144)","v":0}]
[null,null,{"$f":"IF(G93=N2,N11,\"\")","v":""},{"$nulls":4},{"$f":"IF(G94>G96,G94-G96,0)","v":{"v":0,"d":"0.0"}},null,{"$f":"+H96*$F$85","v":{"v":0,"d":"$0.00"}},{"$nulls":4},{"$f":"+J96","v":0},null,null,{"$f":"+'Expense Form'!N44","v":"5555 Solidarity:5555.03 Women's Centers and Groups"},{"$f":"SUMIF('Expense Form'!$N$68:$N$144,'Expense Form'!R96,'Expense Form'!$O$68:$O$144)","v":0}]
[null,null,{"$f":"IF(I87=N3,N12,\"\")","v":""},{"$nulls":14},{"$f":"+'Expense Form'!N45","v":"5555 Solidarity:5555.04 Youth Related Groups and Charities"},{"$f":"SUMIF('Expense Form'!$N$68:$N$144,'Expense Form'!R97,'Expense Form'!$O$68:$O$144)","v":0}]
[null,null,{"$f":"IF(G97=$N$2,$N$13,\"\")","v":""},{"$nulls":14},{"$f":"+'Expense Form'!N46","v":"5555 Solidarity:5555.05 Helping Hands"},{"$f":"SUMIF('Expense Form'!$N$68:$N$144,'Expense Form'!R98,'Expense Form'!$O$68:$O$144)","v":0}]
[null,null,{"$f":"IF(G97=$N$2,$N$15,\"\")","v":""},{"$nulls":4},{"$f":"+G99","v":{"v":0,"d":"0.0"}},null,{"$f":"+H99*$F$85","v":{"v":0,"d":"$0.00"}},{"$nulls":4},{"$f":"+J99","v":0},null,null,{"$f":"+'Expense Form'!N47","v":"5555 Solidarity:5555.06 Labour Events"},{"$f":"SUMIF('Expense Form'!$N$68:$N$144,'Expense Form'!R99,'Expense Form'!$O$68:$O$144)","v":0}]
[null,null,{"$f":"IF(G97=N2,N14,\"\")","v":""},{"$nulls":14},{"$f":"+'Expense Form'!N48","v":"5555 Solidarity:5555.07 General Health and OH&S"},{"$f":"SUMIF('Expense Form'!$N$68:$N$144,'Expense Form'!R100,'Expense Form'!$O$68:$O$144)","v":0}]
[null,null,{"$f":"IF(G100=$N$2,$N$13,\"\")","v":""},{"$nulls":14},{"$f":"+'Expense Form'!N49","v":"5555 Solidarity:5555.08 Promotional"},{"$f":"SUMIF('Expense Form'!$N$68:$N$144,'Expense Form'!R101,'Expense Form'!$O$68:$O$144)","v":0}]
[null,null,{"$f":"IF(G100=$N$2,$N$15,\"\")","v":""},{"$nulls":4},{"$f":"+G102","v":{"v":0,"d":"0.0"}},null,{"$f":"+H102*$F$85","v":{"v":0,"d":"$0.00"}},{"$nulls":4},{"$f":"+J102","v":0},null,null,{"$f":"+'Expense Form'!N50","v":"5555 Solidarity:5555.09 Special Events"},{"$f":"SUMIF('Expense Form'!$N$68:$N$144,'Expense Form'!R102,'Expense Form'!$O$68:$O$144)","v":0}]
[null,null,{"$f":"IF(G100=N2,N14,\"\")","v":""},{"$nulls":14},{"$f":"+'Expense Form'!N51","v":"5555 Solidarity:5555.10 Yearly Memberships"},{"$f":"SUMIF('Expense Form'!$N$68:$N$144,'Expense Form'!R103,'Expense Form'!$O$68:$O$144)","v":0}]
[null,null,{"$f":"IF(G103=$N$2,$N$13,\"\")","v":""},{"$nulls":14},{"$f":"+'Expense Form'!N52","v":"5555 Solidarity:5555.11 Non-recurring Donation"},{"$f":"SUMIF('Expense Form'!$N$68:$N$144,'Expense Form'!R104,'Expense Form'!$O$68:$O$144)","v":0}]
[null,null,{"$f":"IF(G103=$N$2,$N$15,\"\")","v":""},{"$nulls":4},{"$f":"+G105","v":{"v":0,"d":"0.0"}},null,{"$f":"+H105*$F$85","v":{"v":0,"d":"$0.00"}},{"$nulls":4},{"$f":"+J105","v":0}]
[null,null,{"$f":"IF(G103=N2,N14,\"\")","v":""},{"$nulls":14},{"$f":"+'Expense Form'!N54","v":"5640 Stationery and Office Expense:5640.01 Office Supplies/Snacks"},{"$f":"SUMIF('Expense Form'!$N$68:$N$144,'Expense Form'!R106,'Expense Form'!$O$68:$O$144)","v":0}]
[null,null,{"$f":"IF(G106=$N$2,$N$13,\"\")","v":""},{"$nulls":14},{"$f":"+'Expense Form'!N55","v":"5640 Stationery and Office Expense:5640.02 Office Assets/Furniture"},{"$f":"SUMIF('Expense Form'!$N$68:$N$144,'Expense Form'!R107,'Expense Form'!$O$68:$O$144)","v":0}]
[null,null,{"$f":"IF(G106=$N$2,$N$15,\"\")","v":""},{"$nulls":4},{"$f":"+G108","v":{"v":0,"d":"0.0"}},null,{"$f":"+H108*$F$85","v":{"v":0,"d":"$0.00"}},{"$nulls":4},{"$f":"+J108","v":0},null,null,{"$f":"+'Expense Form'!N56","v":"5640 Stationery and Office Expense:5640.03 Office Services (e.g. security, fire, etc)"},{"$f":"SUMIF('Expense Form'!$N$68:$N$144,'Expense Form'!R108,'Expense Form'!$O$68:$O$144)","v":0}]
[null,null,{"$f":"IF(G106=N2,N14,\"\")","v":""},{"$nulls":7},"TOTAL D",{"$nulls":6},{"$f":"+'Expense Form'!N57","v":"5640 Stationery and Office Expense:5640.04 Swag"},{"$f":"SUMIF('Expense Form'!$N$68:$N$144,'Expense Form'!R109,'Expense Form'!$O$68:$O$144)","v":0}]
[null,null,{"$f":"IF(G109=$N$2,$N$13,\"\")","v":""},{"$nulls":7},{"$f":"IF(J86=N4,0,SUM(J92:J111))","v":{"v":0,"d":"$0.00"}},{"$nulls":6},{"$f":"+'Expense Form'!N58","v":"5640 Stationery and Office Expense:5640.99 Other"},{"$f":"SUMIF('Expense Form'!$N$68:$N$144,'Expense Form'!R110,'Expense Form'!$O$68:$O$144)","v":0}]
[null,null,{"$f":"IF(G109=$N$2,$N$15,\"\")","v":""},{"$nulls":4},{"$f":"+G111","v":{"v":0,"d":"0.0"}},null,{"$f":"+H111*$F$85","v":{"v":0,"d":"$0.00"}},{"$nulls":4},{"$f":"+J111","v":0}]
[null,"SECTION E - MEALS/INCIDENTALS"]
[null,"Date (YYYY-MM-DD)","BREAKFAST","LUNCH","DINNER","INCIDENTALS",null,"*Incidentals are generally payable when spending overnight\nand not for the increased travel time of Airfare Equivalent travel time"]
[null,"Not Payable when:  ",{"$f":"+C6","v":"No Breakfast$>6:30am Start"},"No Lunch$>12:0pm Start","No Dinner$ Home < 6:30 pm"]
[null,{"$f":"+B7","v":"Effective April 1, 2022: "},{"v":16,"d":"$16.00"},{"v":18,"d":"$18.00"},{"v":30,"d":"$30.00"},{"$f":"+F7","v":{"v":10,"d":"$10.00"}},{"$f":"+G7","v":0}]
[null,"Not Payable when:  ","Included w/Hotel or Event","Included w/Hotel or Event","Included w/Hotel or Event"]
[{"$nulls":14},{"$f":"SUM(C117:G117)","v":0}]
[{"$nulls":14},{"$f":"SUM(C118:G118)","v":0}]
[{"$nulls":14},0]
[{"$nulls":14},0]
[{"$nulls":14},0]
[{"$nulls":14},0]
[{"$nulls":10},"TOTAL E",{"$nulls":3},0]
[{"$nulls":10},{"$f":"SUM(C125:G126)","v":{"v":0,"d":"$0.00"}},{"$nulls":3},0]
[null,"Sub-Totals:",{"$f":"SUM(C117:C124)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(D117:D124)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(E117:E124)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(F117:F124)","v":{"v":0,"d":"$0.00"}}]
[null,{"$f":"IF(COUNTIF(C117:E124,$C$9)>0,CONCATENATE(C9,\":\"),\"\")","v":""},{"$f":"IF($C$130=$F$17,$G$17,IF($D$133=$F$16,$G$16,IF(COUNTIF(C117:C124,$C$9)>0,IF($C$130>0,IF($C$132>0,IF($D$133=$E$16,COUNTIF(C117:C124,$C$9)*C115,$C$11),$C$11),$C$11),\"\")))","v":""},{"$f":"IF($C$130=$F$17,$G$17,IF($D$133=$F$16,$G$16,IF(COUNTIF(D117:D124,$C$9)>0,IF($C$130>0,IF($C$132>0,IF($D$133=$E$16,COUNTIF(D117:D124,$C$9)*D115,$C$11),$C$11),$C$11),\"\")))","v":""},{"$f":"IF($C$130=$F$17,$G$17,IF($D$133=$F$16,$G$16,IF(COUNTIF(E117:E124,$C$9)>0,IF($C$130>0,IF($C$132>0,IF($D$133=$E$16,COUNTIF(E117:E124,$C$9)*E115,$C$11),$C$11),$C$11),\"\")))","v":""},{"$nulls":9},{"$f":"SUM(C126:G126)","v":0}]
[null,{"$f":"IF(COUNTIF(C117:E124,C9)>0,C12,\"\")","v":""}]
[null,{"$f":"IF($B$127=$C$12,C13,\"\")","v":""}]
[null,{"$f":"IF($B$127=$C$12,C14,\"\")","v":""}]
[]
[null,{"$f":"IF($B$127=$C$12,C15,\"\")","v":""}]
[]
[null,{"$f":"IF($B$127=$C$12,C16,\"\")","v":""}]
[]
[null,"SUB-TOTAL A to E:",{"$nulls":4},{"$f":"+K68+K76+K83+K110+K124","v":{"v":0,"d":"$0.00"}},{"$nulls":3},"SUB-TOTAL \nA to E"]
[]
[]
[null,"SECTION F - ACCOMMODATIONS / ACCOMMODATION EQUIVALENT                                                                                                                ."]
[null,"Date(s) from/to (YYYY-MM-DD to YYYY-MM-DD)",null,"Hotel Name or Enter \"Hotel Equivalent\"",{"$nulls":5},"Amount"]
[{"$nulls":14},{"$f":"+J140","v":0}]
[{"$nulls":10},"TOTAL F",{"$nulls":3},{"$f":"+J141","v":0}]
[{"$nulls":14},0]
[{"$nulls":10},{"$f":"SUM(J140:J144)","v":{"v":0,"d":"$0.00"}},{"$nulls":3},0]
[{"$nulls":14},0]
[]
[null,"Date Signed/Submitted: ",{"$nulls":7},"TOTAL: A to E + F",{"$f":"+G135+K143","v":{"v":0,"d":"$0.00"}}]
[]
[null,"Please clarify the payment method \n1. Direct Deposit                                                         --->\n2. Cheque (we need your mailing address)",null,{"$f":"+N16","v":"Please indicate here either:\n1.\tThat you wish to be paid by Direct Deposit; or\n2.\tProvide your current mailing address (if you wish to be paid by cheque)."}]
[]
[null,"Signature:\nOr indicate it has been submitted by email",{"$nulls":7},"LESS\nADVANCE(S)",{"v":0,"d":"$0.00"}]
[]
[null,"Expense forms are to be submitted to treasurer@ceu.bc.ca with receipts attached to your email. Thank you.\nUUP forms are to be submitted to the CEU President",{"$nulls":7},"AMOUNT\nOWING",{"$f":"K146-K150","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":14},{"$f":"SUM(O68:O152)","v":0},"TOTA"]
[null,"OFFICE USE ONLY"]
[null,"Notes: When approving travel, please confirm to Bookkeeper the account/classification:"]
[null,"5540 Travel Exec + Stewards\n5540.01 Internal\n     5540.01.1 Exec Meeting\n     5540.01.2 Exec Planning Session\n     5540.01.3 Travel to CEU Area Office\n     5540.01.99 Internal - Other",null,"5540 Travel Exec + Stewards\n5540.02 External\n     5540.02.1 BCFed Conferences/Conventions\n     5540.02.2 BCFed Committee work (Executive Council & other BCFed Committees)\n     5540.02.3 CLC Conferences/Conventions\n     5540.02.4 NUPGE Conference and/or NUPGE Committee work\n     5540.02.5 WCUC\n     5540.02.99 External - Other",{"$nulls":3},"5550 Shop Stewards Committee\n     5550.01 Steward Conferences/Seminars/Schools\n     5550.02 New Steward Training\n     5550.03 Travel to CEU Area Office"]