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

{"sheet":"Expense Form","index":0,"n_rows":229,"n_cols":22,"rows_kept":229,"merged":[[12,3,12,6],[123,3,125,3],[123,5,123,13],[124,5,124,8],[124,10,124,13],[125,5,125,13],[125,15,125,17],[125,19,125,21],[126,3,126,13],[126,21,228,21],[129,3,129,6],[129,8,129,9],[129,10,129,11],[130,3,130,9],[130,11,131,13],[131,3,131,9],[132,0,132,1],[132,4,132,7],[132,9,135,9],[132,10,135,10],[132,11,135,11],[132,12,132,13],[133,3,136,3],[133,4,133,7],[133,12,133,13],[134,4,134,7],[134,12,134,13],[135,4,135,8],[135,12,135,13],[136,4,136,7],[136,12,136,13],[137,3,140,3],[137,4,137,7],[137,9,139,9],[137,10,139,10],[137,11,139,11],[137,12,137,13],[138,4,138,7],[138,12,138,13],[139,4,139,8],[139,12,139,13],[140,4,140,7],[140,12,140,13],[141,3,143,3],[141,4,141,7],[141,12,141,13],[142,4,142,8],[142,12,142,13],[143,4,143,7],[143,12,143,13],[144,3,146,3],[144,4,144,7],[144,12,144,13],[145,4,145,8],[145,12,145,13],[146,4,146,7],[146,12,146,13],[147,3,149,3],[147,4,147,7],[147,12,147,13],[148,4,148,8],[148,12,148,13],[149,4,149,7],[149,12,149,13],[150,3,152,3],[150,4,150,7],[150,12,150,13],[151,4,151,8],[151,12,151,13],[152,4,152,7],[152,12,152,13],[153,3,155,3],[153,4,153,7],[153,12,153,13],[154,4,154,8],[154,12,155,13],[155,4,155,7],[156,4,156,10],[156,12,157,13],[157,4,157,10],[158,4,158,10],[159,4,159,10],[160,4,160,10],[160,12,160,13],[161,4,161,10],[161,12,162,13],[162,4,162,10],[163,5,163,10],[163,12,164,13],[164,5,164,10],[165,5,165,10],[165,12,165,13],[166,4,166,10],[166,12,167,13],[167,4,167,10],[168,4,168,10],[169,4,169,10],[170,4,170,10],[170,12,170,13],[171,4,171,10],[171,12,172,13],[172,4,172,10],[173,3,173,11],[174,7,174,8],[174,9,177,11],[175,7,175,8],[176,7,176,8],[177,7,177,8],[178,7,178,8],[179,7,179,8],[180,7,180,8],[181,7,181,8],[182,7,182,8],[183,7,183,8],[184,7,184,8],[184,12,184,13],[185,7,185,8],[185,12,187,13],[186,9,187,11],[187,7,187,8],[188,3,188,11],[188,12,195,13],[189,3,189,11],[190,3,190,11],[191,5,191,11],[192,3,192,11],[193,4,193,11],[194,3,194,4],[194,6,195,11],[195,3,195,5],[196,3,197,7],[196,8,197,11],[196,12,197,13],[199,3,199,13],[200,3,200,4],[200,5,200,10],[200,12,201,13],[201,3,201,4],[201,5,201,10],[202,3,202,4],[202,5,202,10],[202,12,203,13],[203,3,203,4],[203,5,203,10],[204,3,204,4],[204,5,204,10],[204,12,205,13],[205,3,205,4],[205,5,205,10],[207,3,208,4],[207,5,208,10],[207,11,208,11],[207,12,208,13],[209,3,210,4],[209,5,210,10],[211,3,212,4],[211,5,212,10],[211,11,212,11],[211,12,212,13],[213,3,214,10],[213,11,214,11],[213,12,214,13],[215,3,215,13],[216,3,216,13],[217,3,220,4],[217,5,220,8],[217,9,220,13]]}
[{"$nulls":15},"DO NOT DELETE VALIDATION LIST INFO BELOW"]
[{"$nulls":15},"Yes"]
[{"$nulls":15},"No"]
[{"$nulls":15},"Mileage is not payable for this meeting type."]
[{"$nulls":15},"Trip to Location: Would this have been a WCB in-office day for you?  →"]
[{"$nulls":4},"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?"]
[{"$nulls":3},"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)←"]
[{"$nulls":4},"Included w/Hotel or Event","Included w/Hotel or Event","Included w/Hotel or Event","No Overnight=No Incidental"]
[{"$nulls":4},"Replacement Meal Pay't",{"$f":"+E9","v":"Replacement Meal Pay't"},{"$f":"+F9","v":"Replacement Meal Pay't"},{"$nulls":8},"→RETURN TRIP Enter Addresses e.g. Conference (101 Picket Fence Rd) to Home (1122 Boogie Ave)←"]
[{"$nulls":15},"↓Enter 2nd Line below to deduct normal Home/Office Commute for workday travel↓"]
[{"$nulls":15},"→ Enter Normal Commute Addresses in this box e.g. Home (1122 Boogie Ave) to Your WCB Office/SDL←"]
[{"$nulls":3},"Answer 1 - 3 Below",{"$nulls":11},"Did you have additional union-related mileage before returning home?→"]
[{"$nulls":3},"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":11},"↓Enter addition Line below detailing that union travel↓"]
[{"$nulls":3},"Please confirm the 1 to 3 below:",{"$nulls":11},"Did you have additional union-related mileage before returning home?→"]
[{"$nulls":3},"1. Please confirm you have either a food allergy, a medical condition, or religious reason which prevented you from eating the provided meal.",{"$nulls":11},"→ Enter Addresses e.g. Hotel (with address) to CEU Office (13775 Commerce Pkwy) ←"]
[{"$nulls":3},"2. Please detail how the provided meal was contrary to the above.",{"$nulls":11},"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":3},"3. Did you purchase a replacement meal?",null,"Yes","No","No Replacement Meal Purchased"]
[{"$nulls":5},"Yes, I do.","No, I do not.","Does not meet criteria #1",{"$nulls":7},"Classifcation Breakdown Complete"]
[{"$nulls":15},"Classifcation Breakdown INCOMPLETE"]
[{"$nulls":15},"CLASSIFICATION LISTS"]
[{"$nulls":15},"STATIONERY AND OFFICE EXPENSE:"]
[{"$nulls":15},"5640.01 Office Supplies/Snacks"]
[{"$nulls":15},"5640.02 Office Assets/Furniture"]
[{"$nulls":15},"5640.03 Office Services (e.g. security, fire, etc)"]
[{"$nulls":15},"5640.04 CEU Swag"]
[{"$nulls":15},"5640.99 Other"]
[{"$nulls":15},"LEGAL DEFENSE/MEDICAL REVIEW COMMITTEE:"]
[{"$nulls":15},"5479.01 Legal Defense Budget"]
[{"$nulls":15},"5479.02 Medical Review Committee"]
[{"$nulls":15},"LEGAL - GENERAL:"]
[{"$nulls":15},"5480.01 Research Costs by 3rd Parties - Legal/Lay Expert"]
[{"$nulls":15},"5480.02 CEU Internal Investigations/Facilitations"]
[{"$nulls":15},"5480.99 Other"]
[{"$nulls":15},"TRAVEL - CEU STAFF:"]
[{"$nulls":15},"5440.01 CEU Conference (e.g. Staff travel to steward conference)"]
[{"$nulls":15},"5440.02 Exec Meeting/Planning Sessions"]
[{"$nulls":15},"5440.03 Travel to CEU Area Office"]
[{"$nulls":15},"5440.99 Other"]
[{"$nulls":15},"EMPLOYEE BENEFITS:"]
[{"$nulls":15},"5692.01 Extended Dental/HCB and Disability/Life Insurance"]
[{"$nulls":15},"5692.02 Other Benefits (e.g. CLRO Law Society)"]
[{"$nulls":15},"5692.03 Retirement/Severance Benefits"]
[{"$nulls":15},"MEETINGS"]
[{"$nulls":15},"5500.01 Meeting Rooms"]
[{"$nulls":15},"5500.99 Other"]
[{"$nulls":15},"COURSES:"]
[{"$nulls":15},"5535.01.02 BCFed Convention"]
[{"$nulls":15},"5535.01.99 BCFed Other"]
[{"$nulls":15},"5535.02.01 CLC Winter School"]
[{"$nulls":15},"5535.02.02 CLC National Convention"]
[{"$nulls":15},"5535.02.99 CLC Other"]
[{"$nulls":15},"5535.03 NUPGE Convention"]
[{"$nulls":15},"5535.04.01 BCGEU Regional Seminar"]
[{"$nulls":15},"5535.04.99 BCGEU Other"]
[{"$nulls":15},"5535.05 OH&S BCGEU/CEU Conference"]
[{"$nulls":15},"5535.06 Summer Institute for Union Women (SIUW)"]
[{"$nulls":15},"5535.07 Share Investor Summit"]
[{"$nulls":15},"5535.99 Courses Other"]
[{"$nulls":15},"TRAVEL EXEC + STEWARDS"]
[{"$nulls":15},"INTERNAL:"]
[{"$nulls":15},"5540.01.1 Exec Meeting"]
[{"$nulls":15},"5540.01.2 Exec Planning Session"]
[{"$nulls":15},"5540.01.3 Travel to CEU Area Office"]
[{"$nulls":15},"5540.01.99 Internal - Other"]
[{"$nulls":15},"EXTERNAL:"]
[{"$nulls":15},"5540.02.1 BCFed Conferences/Conventions"]
[{"$nulls":15},"5540.02.2 BCFed Committee work (Executive Council & other BCFed Committees)"]
[{"$nulls":15},"5540.02.3 CLC Conferences/Conventions"]
[{"$nulls":15},"5540.02.4 NUPGE Conference and/or NUPGE Committee work"]
[{"$nulls":15},"5540.02.5 WCUC"]
[{"$nulls":15},"5540.02.99 External - Other"]
[{"$nulls":15},"SHOP STEWARDS COMMITTEE:"]
[{"$nulls":15},"5550.01 Steward Conferences/Seminars/Schools"]
[{"$nulls":15},"5550.02 New Steward Training"]
[{"$nulls":15},"5550.03 Travel to CEU Area Office"]
[{"$nulls":15},"5550.04 Steward Swag"]
[{"$nulls":15},"5550.99 Other"]
[{"$nulls":15},"MEMBERSHIP ENGAGEMENT:"]
[{"$nulls":15},"5552.01 Member Conference (One Day)"]
[{"$nulls":15},"5552.02 Member Engagement Recognition (6 Draw prizes)"]
[{"$nulls":15},"5552.99 Other"]
[{"$nulls":15},"SOLIDARITY:"]
[{"$nulls":15},"5555.01 Bursaries"]
[{"$nulls":15},"5555.02 Jointly Funded Charities"]
[{"$nulls":15},"5555.03 Women's Centers and Groups"]
[{"$nulls":15},"5555.04 Youth Related Groups and Charities"]
[{"$nulls":15},"5555.05 Helping Hands"]
[{"$nulls":15},"5555.06 Labour Events"]
[{"$nulls":15},"5555.07 General Health and OH&S"]
[{"$nulls":15},"5555.08 Promotional"]
[{"$nulls":15},"5555.09 Special Events"]
[{"$nulls":15},"5555.09.01 Special Events Abbotsford"]
[{"$nulls":15},"5555.09.02 Special Events Burnaby"]
[{"$nulls":15},"5555.09.03 Special Events Courtenay"]
[{"$nulls":15},"5555.09.04  Special Events Cranbrook"]
[{"$nulls":15},"5555.09.05 Special Events Fort St John"]
[{"$nulls":15},"5555.09.06 Special Events Kamloops"]
[{"$nulls":15},"5555.09.07 Special Events Kelowna"]
[{"$nulls":15},"5555.09.08 Special Events Nanaimo"]
[{"$nulls":15},"5555.09.09 Special Events Nelson"]
[{"$nulls":15},"5555.09.10 Special Events Port Moody"]
[{"$nulls":15},"5555.09.11 Special Events Prince George"]
[{"$nulls":15},"5555.09.12.1 Special Events Richmond - Quadrent 1"]
[{"$nulls":15},"5555.09.12.2 Special Events Richmond - Quadrent 2"]
[{"$nulls":15},"5555.09.12.3 Special Events Richmond - Quadrent 3"]
[{"$nulls":15},"5555.09.12.4 Special Events Richmond - Quadrent 4"]
[{"$nulls":15},"5555.09.13 Special Events Surrey"]
[{"$nulls":15},"5555.09.14 Special Events Terrace"]
[{"$nulls":15},"5555.09.15 Special Events Victoria"]
[{"$nulls":15},"5555.09.16 Special Events Williams Lake"]
[{"$nulls":15},"5555.09.99 Special Events Other"]
[{"$nulls":15},"5555.10 Yearly Memberships"]
[{"$nulls":15},"5555.11 Non-recurring Donation"]
{"$rows_empty":10}
[{"$nulls":4},"All Yellow boxes below \nare mandatory.","CEU AIRFARE EQUIVALENT EXPENSE FORM                              (2024-05-31 Update)   "]
[{"$nulls":4},"Name: ",{"$nulls":4},"Office:  "]
[{"$nulls":4},"Reason for Travel:",{"$nulls":10},"Classification Breakdown",{"$nulls":3},"CLASSIFICATION SUB-TOTALS"]
[{"$nulls":3},"SECTION A - AIRFARE EQUIVLANT RATES FI-0012 allows for reimbursement of \"… the lesser of the actual cost of the trip ... or the equivalent value established by the Executive Board….\"",{"$nulls":15},"TOTAL: ",{"$f":"SUM(U128:U229)","v":0},{"$f":"IF(U127='Expense Form'!M208,'Expense Form'!P18,'Expense Form'!P19)","v":"Classifcation Breakdown Complete"}]
[{"$nulls":3},{"$f":"CONCATENATE(+A134,\" $\",B134)","v":"Fort St. John $540"},{"$f":"CONCATENATE(+A135,\" $\",B135)","v":"Kamloops $555"},{"$f":"CONCATENATE(+A136,\" $\",B136)","v":"Kelowna $605"},{"$f":"CONCATENATE(+A137,\" $\",B137)","v":"Nelson (Castlegar)* $675"},{"$f":"CONCATENATE(+A138,\" $\",B138)","v":"Prince George $460"},{"$nulls":11},"STATIONERY AND OFFICE EXPENSE:",{"$f":"SUMIF('Expense Form'!$P$128:$P$206,'Expense Form'!T128,'Expense Form'!$Q$128:$Q$206)","v":0}]
[{"$nulls":3},{"$f":"CONCATENATE(+A139,\" $\",B139)","v":"Terrace $510"},{"$f":"CONCATENATE(+A140,\" $\",B140)","v":"Williams Lake $755"},{"$f":"CONCATENATE(+A141,\" $\",B141)","v":"Nanaimo $440"},{"$f":"CONCATENATE(+A142,\" $\",B142)","v":"Victoria $475"},{"$f":"CONCATENATE(+A143,\" $\",B143)","v":"Courtenay (Comox) $625"},{"$nulls":11},"5640.01 Office Supplies/Snacks",{"$f":"SUMIF('Expense Form'!$P$128:$P$206,'Expense Form'!T129,'Expense Form'!$Q$128:$Q$206)","v":0}]
[{"$nulls":3},"SECTION A.1 - MILEAGE (",{"$nulls":3},{"v":0.7,"d":"$0.70"},"per Km)",{"$nulls":10},"5640.02 Office Assets/Furniture",{"$f":"SUMIF('Expense Form'!$P$128:$P$206,'Expense Form'!T130,'Expense Form'!$Q$128:$Q$206)","v":0}]
[{"$nulls":3},"Are you applying for expense reimbursement related to Mileage? →",{"$nulls":6},"Yes",{"$f":"IF(K132=P2,P4,\"\")","v":""},{"$nulls":7},"5640.03 Office Services (e.g. security, fire, etc)",{"$f":"SUMIF('Expense Form'!$P$128:$P$206,'Expense Form'!T131,'Expense Form'!$Q$128:$Q$206)","v":0}]
[{"$nulls":3},"Was this a CEU general meeting (including an AGM, or a local update meeting in your normal work community)? →",{"$nulls":6},"No",{"$nulls":8},"5640.04 CEU Swag",{"$f":"SUMIF('Expense Form'!$P$128:$P$206,'Expense Form'!T132,'Expense Form'!$Q$128:$Q$206)","v":0}]
["Current Amounts",null,null,"Date:\nYYYY-MM-DD","Above mileage/km for the first 5,000 kilometres driven per year at milage rate above. 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","In-Office Day Difference Between CEU trip \nand Commute to Work",null,"Payable\nAmount",{"$f":"IF($L$131=$P$4,\"↓\",\"\")","v":""},{"$nulls":6},"5640.99 Other",{"$f":"SUMIF('Expense Form'!$P$128:$P$206,'Expense Form'!T133,'Expense Form'!$Q$128:$Q$206)","v":0}]
["Fort St. John",{"v":540,"d":"$540"},null,null,{"$f":"IF(K132=P3,P5,\"\")","v":"Trip to Location: Would this have been a WCB in-office day for you?  →"},{"$nulls":7},{"$f":"IF($L$131=$P$4,\"↓\",\"\")","v":""},{"$nulls":6},"LEGAL DEFENSE/MEDICAL REVIEW COMMITTEE:",{"$f":"SUMIF('Expense Form'!$P$128:$P$206,'Expense Form'!T134,'Expense Form'!$Q$128:$Q$206)","v":0}]
["Kamloops",{"v":555,"d":"$555"},null,null,{"$f":"IF(K132=P3,P7,\"\")","v":"→TRIP to LOCATION: Enter Addresses e.g. Home (1122 Boogie Ave) to Conference (101 Picket Fence Rd)←"},{"$nulls":7},{"$f":"IF($L$131=$P$4,\"↓\",\"\")","v":""},{"$nulls":6},"5479.01 Legal Defense Budget",{"$f":"SUMIF('Expense Form'!$P$128:$P$206,'Expense Form'!T135,'Expense Form'!$Q$128:$Q$206)","v":0}]
["Kelowna",{"v":605,"d":"$605"},null,null,{"$f":"IF(I134=P2,P10,\"\")","v":""},{"$nulls":7},{"$f":"IF($L$131=$P$4,\"↓\",\"\")","v":""},{"$nulls":6},"5479.02 Medical Review Committee",{"$f":"SUMIF('Expense Form'!$P$128:$P$206,'Expense Form'!T136,'Expense Form'!$Q$128:$Q$206)","v":0}]
["Nelson (Castlegar)*",{"v":675,"d":"$675"},null,null,{"$f":"IF(I134=P2,P11,\"\")","v":""},{"$nulls":4},{"$f":"IF(I134=P2,I135-I137,IF(I134=P3,I135,\"\"))","v":""},null,{"$f":"MAX(J137:K137)*H130","v":{"v":0,"d":"$0.00"}},{"$f":"IF($L$131=$P$4,\"↓\",\"\")","v":""},{"$nulls":3},{"$f":"+L137","v":0},null,null,"LEGAL - GENERAL:",{"$f":"SUMIF('Expense Form'!$P$128:$P$206,'Expense Form'!T137,'Expense Form'!$Q$128:$Q$206)","v":0}]
["Prince George",{"v":460,"d":"$460"},null,null,{"$f":"IF(K132=P3,P6,\"\")","v":"Return trip from Location: Would this have been a WCB in-office day for you?"},{"$nulls":4},"Diff'nce",null,"Payable\nAmount",{"$f":"IF($L$131=$P$4,\"↓\",\"\")","v":""},{"$nulls":6},"5480.01 Research Costs by 3rd Parties - Legal/Lay Expert",{"$f":"SUMIF('Expense Form'!$P$128:$P$206,'Expense Form'!T138,'Expense Form'!$Q$128:$Q$206)","v":0}]
["Terrace",{"v":510,"d":"$510"},null,null,{"$f":"IF(K132=P3,P9,\"\")","v":"→RETURN TRIP Enter Addresses e.g. Conference (101 Picket Fence Rd) to Home (1122 Boogie Ave)←"},{"$nulls":7},{"$f":"IF($L$131=$P$4,\"↓\",\"\")","v":""},{"$nulls":6},"5480.02 CEU Internal Investigations/Facilitations",{"$f":"SUMIF('Expense Form'!$P$128:$P$206,'Expense Form'!T139,'Expense Form'!$Q$128:$Q$206)","v":0}]
["Williams Lake",{"v":755,"d":"$755"},null,null,{"$f":"IF(I138=P2,P10,\"\")","v":""},{"$nulls":7},{"$f":"IF($L$131=$P$4,\"↓\",\"\")","v":""},{"$nulls":6},"5480.99 Other",{"$f":"SUMIF('Expense Form'!$P$128:$P$206,'Expense Form'!T140,'Expense Form'!$Q$128:$Q$206)","v":0}]
["Nanaimo",{"v":440,"d":"$440"},null,null,{"$f":"IF(I138=P2,P11,\"\")","v":""},{"$nulls":4},{"$f":"IF(I138=P2,I139-I141,IF(I138=P3,I139,\"\"))","v":""},null,{"$f":"MAX(J141:K141)*H130","v":{"v":0,"d":"$0.00"}},{"$f":"IF($L$131=$P$4,\"↓\",\"\")","v":""},{"$nulls":3},{"$f":"+L141","v":0},null,null,"TRAVEL - CEU STAFF:",{"$f":"SUMIF('Expense Form'!$P$128:$P$206,'Expense Form'!T141,'Expense Form'!$Q$128:$Q$206)","v":0}]
["Victoria",{"v":475,"d":"$475"},null,null,{"$f":"IF(K132=P3,P12,\"\")","v":"Did you have additional union-related mileage before returning home?→"},{"$nulls":7},{"$f":"IF($L$131=$P$4,\"↓\",\"\")","v":""},{"$nulls":6},"5440.01 CEU Conference (e.g. Staff travel to steward conference)",{"$f":"SUMIF('Expense Form'!$P$128:$P$206,'Expense Form'!T142,'Expense Form'!$Q$128:$Q$206)","v":0}]
["Courtenay (Comox)",{"v":625,"d":"$625"},null,null,{"$f":"IF(I142=$P$2,$P$13,\"\")","v":""},{"$nulls":7},{"$f":"IF($L$131=$P$4,\"↓\",\"\")","v":""},{"$nulls":6},"5440.02 Exec Meeting/Planning Sessions",{"$f":"SUMIF('Expense Form'!$P$128:$P$206,'Expense Form'!T143,'Expense Form'!$Q$128:$Q$206)","v":0}]
[{"$nulls":4},{"$f":"IF(I142=$P$2,$P$15,\"\")","v":""},{"$nulls":4},{"$f":"+I144","v":{"v":0,"d":"0.0"}},null,{"$f":"+J144*$H$130","v":{"v":0,"d":"$0.00"}},{"$f":"IF($L$131=$P$4,\"↓\",\"\")","v":""},{"$nulls":3},{"$f":"+L144","v":0},null,null,"5440.03 Travel to CEU Area Office",{"$f":"SUMIF('Expense Form'!$P$128:$P$206,'Expense Form'!T144,'Expense Form'!$Q$128:$Q$206)","v":0}]
[{"$nulls":4},{"$f":"IF(I142=P2,P14,\"\")","v":""},{"$nulls":7},{"$f":"IF($L$131=$P$4,\"↓\",\"\")","v":""},{"$nulls":6},"5440.99 Other",{"$f":"SUMIF('Expense Form'!$P$128:$P$206,'Expense Form'!T145,'Expense Form'!$Q$128:$Q$206)","v":0}]
[{"$nulls":4},{"$f":"IF(I145=$P$2,$P$13,\"\")","v":""},{"$nulls":7},{"$f":"IF($L$131=$P$4,\"↓\",\"\")","v":""},{"$nulls":6},"EMPLOYEE BENEFITS:",{"$f":"SUMIF('Expense Form'!$P$128:$P$206,'Expense Form'!T146,'Expense Form'!$Q$128:$Q$206)","v":0}]
[{"$nulls":4},{"$f":"IF(I145=$P$2,$P$15,\"\")","v":""},{"$nulls":4},{"$f":"+I147","v":{"v":0,"d":"0.0"}},null,{"$f":"+J147*$H$130","v":{"v":0,"d":"$0.00"}},{"$f":"IF($L$131=$P$4,\"↓\",\"\")","v":""},{"$nulls":3},{"$f":"+L147","v":0},null,null,"5692.01 Extended Dental/HCB and Disability/Life Insurance",{"$f":"SUMIF('Expense Form'!$P$128:$P$206,'Expense Form'!T147,'Expense Form'!$Q$128:$Q$206)","v":0}]
[{"$nulls":4},{"$f":"IF(I145=P2,P14,\"\")","v":""},{"$nulls":7},{"$f":"IF($L$131=$P$4,\"↓\",\"\")","v":""},{"$nulls":6},"5692.02 Other Benefits (e.g. CLRO Law Society)",{"$f":"SUMIF('Expense Form'!$P$128:$P$206,'Expense Form'!T148,'Expense Form'!$Q$128:$Q$206)","v":0}]
[{"$nulls":4},{"$f":"IF(I148=$P$2,$P$13,\"\")","v":""},{"$nulls":7},{"$f":"IF($L$131=$P$4,\"↓\",\"\")","v":""},{"$nulls":6},"5692.03 Retirement/Severance Benefits",{"$f":"SUMIF('Expense Form'!$P$128:$P$206,'Expense Form'!T149,'Expense Form'!$Q$128:$Q$206)","v":0}]
[{"$nulls":4},{"$f":"IF(I148=$P$2,$P$15,\"\")","v":""},{"$nulls":4},{"$f":"+I150","v":{"v":0,"d":"0.0"}},null,{"$f":"+J150*$H$130","v":{"v":0,"d":"$0.00"}},{"$f":"IF($L$131=$P$4,\"↓\",\"\")","v":""},{"$nulls":3},{"$f":"+L150","v":0},null,null,"MEETINGS",{"$f":"SUMIF('Expense Form'!$P$128:$P$206,'Expense Form'!T150,'Expense Form'!$Q$128:$Q$206)","v":0}]
[{"$nulls":4},{"$f":"IF(I148=P2,P14,\"\")","v":""},{"$nulls":7},{"$f":"IF($L$131=$P$4,\"↓\",\"\")","v":""},{"$nulls":6},"5500.01 Meeting Rooms",{"$f":"SUMIF('Expense Form'!$P$128:$P$206,'Expense Form'!T151,'Expense Form'!$Q$128:$Q$206)","v":0}]
[{"$nulls":4},{"$f":"IF(I151=$P$2,$P$13,\"\")","v":""},{"$nulls":7},{"$f":"IF($L$131=$P$4,\"↓\",\"\")","v":""},{"$nulls":6},"5500.99 Other",{"$f":"SUMIF('Expense Form'!$P$128:$P$206,'Expense Form'!T152,'Expense Form'!$Q$128:$Q$206)","v":0}]
[{"$nulls":4},{"$f":"IF(I151=$P$2,$P$15,\"\")","v":""},{"$nulls":4},{"$f":"+I153","v":{"v":0,"d":"0.0"}},null,{"$f":"+J153*$H$130","v":{"v":0,"d":"$0.00"}},{"$f":"IF($L$131=$P$4,\"↓\",\"\")","v":""},{"$nulls":3},{"$f":"+L153","v":0},null,null,"COURSES:",{"$f":"SUMIF('Expense Form'!$P$128:$P$206,'Expense Form'!T153,'Expense Form'!$Q$128:$Q$206)","v":0}]
[{"$nulls":4},{"$f":"IF(I151=P2,P14,\"\")","v":""},{"$nulls":7},"A.1 Sub-Total",{"$nulls":6},"5535.01.02 BCFed Convention",{"$f":"SUMIF('Expense Form'!$P$128:$P$206,'Expense Form'!T154,'Expense Form'!$Q$128:$Q$206)","v":0}]
[{"$nulls":4},{"$f":"IF(I154=$P$2,$P$13,\"\")","v":""},{"$nulls":7},{"$f":"IF(L131=P4,0,SUM(L137:L156))","v":{"v":0,"d":"$0.00"}},{"$nulls":6},"5535.01.99 BCFed Other",{"$f":"SUMIF('Expense Form'!$P$128:$P$206,'Expense Form'!T155,'Expense Form'!$Q$128:$Q$206)","v":0}]
[{"$nulls":4},{"$f":"IF(I154=$P$2,$P$15,\"\")","v":""},{"$nulls":4},{"$f":"+I156","v":{"v":0,"d":"0.0"}},null,{"$f":"+J156*$H$130","v":{"v":0,"d":"$0.00"}},{"$nulls":4},{"$f":"+L156","v":0},null,null,"5535.02.01 CLC Winter School",{"$f":"SUMIF('Expense Form'!$P$128:$P$206,'Expense Form'!T156,'Expense Form'!$Q$128:$Q$206)","v":0}]
[{"$nulls":3},"Date (YYYY-MM-DD)","SECTION A.2 - OTHER AIRFARE EQUIVALENT VEHICLE EXPENSES (e.g. Tolls, Ferries, Parking)",{"$nulls":6},"Amount",{"$nulls":7},"5535.02.02 CLC National Convention",{"$f":"SUMIF('Expense Form'!$P$128:$P$206,'Expense Form'!T157,'Expense Form'!$Q$128:$Q$206)","v":0}]
[{"$nulls":3}," ",{"$nulls":12},{"$f":"+L158","v":0},null,null,"5535.02.99 CLC Other",{"$f":"SUMIF('Expense Form'!$P$128:$P$206,'Expense Form'!T158,'Expense Form'!$Q$128:$Q$206)","v":0}]
[{"$nulls":16},{"$f":"+L159","v":0},null,null,"5535.03 NUPGE Convention",{"$f":"SUMIF('Expense Form'!$P$128:$P$206,'Expense Form'!T159,'Expense Form'!$Q$128:$Q$206)","v":0}]
[{"$nulls":16},0,null,null,"5535.04.01 BCGEU Regional Seminar",{"$f":"SUMIF('Expense Form'!$P$128:$P$206,'Expense Form'!T160,'Expense Form'!$Q$128:$Q$206)","v":0}]
[{"$nulls":3}," ",{"$nulls":8},"A.2 Sub-Total",{"$nulls":3},0,null,null,"5535.04.99 BCGEU Other",{"$f":"SUMIF('Expense Form'!$P$128:$P$206,'Expense Form'!T161,'Expense Form'!$Q$128:$Q$206)","v":0}]
[{"$nulls":12},{"$f":"SUM(L158:L163)","v":{"v":0,"d":"$0.00"}},{"$nulls":3},0,null,null,"5535.05 OH&S BCGEU/CEU Conference",{"$f":"SUMIF('Expense Form'!$P$128:$P$206,'Expense Form'!T162,'Expense Form'!$Q$128:$Q$206)","v":0}]
[{"$nulls":16},0,null,null,"5535.06 Summer Institute for Union Women (SIUW)",{"$f":"SUMIF('Expense Form'!$P$128:$P$206,'Expense Form'!T163,'Expense Form'!$Q$128:$Q$206)","v":0}]
[{"$nulls":5},"A.1 + A.2 = Total Actual Expenses related to Airfare Equivalent:",{"$nulls":5},{"$f":"+M155+M162","v":{"v":0,"d":"$0.00"}},"REIMBURSABLE\nAMOUNT for \nSECTION A",{"$nulls":6},"5535.07 Share Investor Summit",{"$f":"SUMIF('Expense Form'!$P$128:$P$206,'Expense Form'!T164,'Expense Form'!$Q$128:$Q$206)","v":0}]
[{"$nulls":5},"ENTER Your Office Location (Use drop down list)    ",{"$nulls":13},"5535.99 Courses Other",{"$f":"SUMIF('Expense Form'!$P$128:$P$206,'Expense Form'!T165,'Expense Form'!$Q$128:$Q$206)","v":0}]
[{"$nulls":5},"Maximum Payable from your Office Location: \n(This is autofilled based on your office selection)                      .    ",{"$nulls":5},{"$f":"IFERROR(VLOOKUP(L165,A134:B143,2,FALSE),0)","v":{"v":0,"d":"$0.00"}},{"$f":"MIN(L164,L166)","v":{"v":0,"d":"$0.00"}},{"$nulls":5},{"$f":"SUM(Q137:Q166)","v":{"v":0,"d":"$0.00"}},"TRAVEL EXEC + STEWARDS",{"$f":"SUMIF('Expense Form'!$P$128:$P$206,'Expense Form'!T166,'Expense Form'!$Q$128:$Q$206)","v":0}]
[{"$nulls":3},"Date (YYYY-MM-DD)","SECTION B.1 - MISCELLANEOUS EXPENSES - NOT RELATED TO VEHICLE (e.g. Childcare)",{"$nulls":6},"Amount",{"$nulls":7},"INTERNAL:",{"$f":"SUMIF('Expense Form'!$P$128:$P$206,'Expense Form'!T167,'Expense Form'!$Q$128:$Q$206)","v":0}]
[{"$nulls":3}," ",{"$nulls":12},{"$f":"+L168","v":0},null,null,"5540.01.1 Exec Meeting",{"$f":"SUMIF('Expense Form'!$P$128:$P$206,'Expense Form'!T168,'Expense Form'!$Q$128:$Q$206)","v":0}]
[{"$nulls":16},0,null,null,"5540.01.2 Exec Planning Session",{"$f":"SUMIF('Expense Form'!$P$128:$P$206,'Expense Form'!T169,'Expense Form'!$Q$128:$Q$206)","v":0}]
[{"$nulls":3}," ",{"$nulls":12},0,null,null,"5540.01.3 Travel to CEU Area Office",{"$f":"SUMIF('Expense Form'!$P$128:$P$206,'Expense Form'!T170,'Expense Form'!$Q$128:$Q$206)","v":0}]
[{"$nulls":3}," ",{"$nulls":8},"TOTAL B.1",{"$nulls":3},0,null,null,"5540.01.99 Internal - Other",{"$f":"SUMIF('Expense Form'!$P$128:$P$206,'Expense Form'!T171,'Expense Form'!$Q$128:$Q$206)","v":0}]
[{"$nulls":12},{"$f":"SUM(L168:L173)","v":{"v":0,"d":"$0.00"}},{"$nulls":3},0,null,null,"EXTERNAL:",{"$f":"SUMIF('Expense Form'!$P$128:$P$206,'Expense Form'!T172,'Expense Form'!$Q$128:$Q$206)","v":0}]
[{"$nulls":16},0,null,{"$f":"SUM(Q168:Q173)","v":0},"5540.02.1 BCFed Conferences/Conventions",{"$f":"SUMIF('Expense Form'!$P$128:$P$206,'Expense Form'!T173,'Expense Form'!$Q$128:$Q$206)","v":0}]
[{"$nulls":3},"SECTION B.2 - MEALS/INCIDENTALS",{"$nulls":15},"5540.02.2 BCFed Committee work (Executive Council & other BCFed Committees)",{"$f":"SUMIF('Expense Form'!$P$128:$P$206,'Expense Form'!T174,'Expense Form'!$Q$128:$Q$206)","v":0}]
[{"$nulls":3},"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",{"$nulls":9},"5540.02.3 CLC Conferences/Conventions",{"$f":"SUMIF('Expense Form'!$P$128:$P$206,'Expense Form'!T175,'Expense Form'!$Q$128:$Q$206)","v":0}]
[{"$nulls":3},"Not Payable when:  ",{"$f":"+E6","v":"No Breakfast$>6:30am Start"},{"$f":"+F6","v":"No Lunch$>12:0pm Start"},{"$f":"+G6","v":"No Dinner$ Home < 6:30 pm"},{"$nulls":12},"5540.02.4 NUPGE Conference and/or NUPGE Committee work",{"$f":"SUMIF('Expense Form'!$P$128:$P$206,'Expense Form'!T176,'Expense Form'!$Q$128:$Q$206)","v":0}]
[{"$nulls":3},{"$f":"+D7","v":"Effective April 1, 2022: "},{"$f":"+E7","v":{"v":16,"d":"$16.00"}},{"$f":"+F7","v":{"v":18,"d":"$18.00"}},{"$f":"+G7","v":{"v":30,"d":"$30.00"}},{"$f":"+H7","v":{"v":10,"d":"$10.00"}},{"$f":"+I7","v":0},{"$nulls":10},"5540.02.5 WCUC",{"$f":"SUMIF('Expense Form'!$P$128:$P$206,'Expense Form'!T177,'Expense Form'!$Q$128:$Q$206)","v":0}]
[{"$nulls":3},"Not Payable when:  ",{"$f":"+E9","v":"Replacement Meal Pay't"},{"$f":"+F9","v":"Replacement Meal Pay't"},{"$f":"+G9","v":"Replacement Meal Pay't"},{"$f":"+H9","v":{"v":0,"d":"$0.00"}},{"$f":"+I9","v":0},{"$nulls":10},"5540.02.99 External - Other",{"$f":"SUMIF('Expense Form'!$P$128:$P$206,'Expense Form'!T178,'Expense Form'!$Q$128:$Q$206)","v":0}]
[{"$nulls":16},{"$f":"SUM(E179:I179)","v":0},null,null,"SHOP STEWARDS COMMITTEE:",{"$f":"SUMIF('Expense Form'!$P$128:$P$206,'Expense Form'!T179,'Expense Form'!$Q$128:$Q$206)","v":0}]
[{"$nulls":16},{"$f":"SUM(E180:I180)","v":0},null,null,"5550.01 Steward Conferences/Seminars/Schools",{"$f":"SUMIF('Expense Form'!$P$128:$P$206,'Expense Form'!T180,'Expense Form'!$Q$128:$Q$206)","v":0}]
[{"$nulls":16},0,null,null,"5550.02 New Steward Training",{"$f":"SUMIF('Expense Form'!$P$128:$P$206,'Expense Form'!T181,'Expense Form'!$Q$128:$Q$206)","v":0}]
[{"$nulls":16},0,null,null,"5550.03 Travel to CEU Area Office",{"$f":"SUMIF('Expense Form'!$P$128:$P$206,'Expense Form'!T182,'Expense Form'!$Q$128:$Q$206)","v":0}]
[{"$nulls":16},0,null,null,"5550.04 Steward Swag",{"$f":"SUMIF('Expense Form'!$P$128:$P$206,'Expense Form'!T183,'Expense Form'!$Q$128:$Q$206)","v":0}]
[{"$nulls":16},0,null,null,"5550.99 Other",{"$f":"SUMIF('Expense Form'!$P$128:$P$206,'Expense Form'!T184,'Expense Form'!$Q$128:$Q$206)","v":0}]
[{"$nulls":12},"TOTAL B.2",{"$nulls":3},0,null,null,"MEMBERSHIP ENGAGEMENT:",{"$f":"SUMIF('Expense Form'!$P$128:$P$206,'Expense Form'!T185,'Expense Form'!$Q$128:$Q$206)","v":0}]
[{"$nulls":12},{"$f":"SUM(E187:I188)","v":{"v":0,"d":"$0.00"}},{"$nulls":3},0,null,{"$f":"SUM(Q179:Q186)","v":0},"5552.01 Member Conference (One Day)",{"$f":"SUMIF('Expense Form'!$P$128:$P$206,'Expense Form'!T186,'Expense Form'!$Q$128:$Q$206)","v":0}]
[{"$nulls":3},"Sub-Totals:",{"$f":"SUM(E179:E186)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(F179:F186)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(G179:G186)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(H179:H186)","v":{"v":0,"d":"$0.00"}},{"$nulls":11},"5552.02 Member Engagement Recognition (6 Draw prizes)",{"$f":"SUMIF('Expense Form'!$P$128:$P$206,'Expense Form'!T187,'Expense Form'!$Q$128:$Q$206)","v":0}]
[{"$nulls":3},{"$f":"IF(COUNTIF(E179:G186,$E$9)>0,CONCATENATE(E9,\":\"),\"\")","v":""},{"$f":"IF($E$192=$G$18,$H$18, IF($F$195=$G$17,\"No Replacement Meal Purchased\", IF(COUNTIF(E179:E186,$E$9)>0, IF($E$192>0, IF($E$194>0, IF($F$195=$F$17, COUNTIF(E179:E186,$E$9)*E177,$D$12),$D$12),$D$12),\"\")))","v":""},{"$f":"IF($E$192=$G$18,$H$18, IF($F$195=$G$17,\"No Replacement Meal Purchased\", IF(COUNTIF(F179:F186,$E$9)>0, IF($E$192>0, IF($E$194>0, IF($F$195=$F$17, COUNTIF(F179:F186,$E$9)*F177,$D$12),$D$12),$D$12),\"\")))","v":""},{"$f":"IF($E$192=$G$18,$H$18, IF($F$195=$G$17,\"No Replacement Meal Purchased\", IF(COUNTIF(G179:G186,$E$9)>0, IF($E$192>0, IF($E$194>0, IF($F$195=$F$17, COUNTIF(G179:G186,$E$9)*G177,$D$12),$D$12),$D$12),\"\")))","v":""},{"$nulls":12},"5552.99 Other",{"$f":"SUMIF('Expense Form'!$P$128:$P$206,'Expense Form'!T188,'Expense Form'!$Q$128:$Q$206)","v":0}]
[{"$nulls":3},{"$f":"IF(COUNTIF(E179:G186,E9)>0,D13,\"\")","v":""},{"$nulls":15},"SOLIDARITY:",{"$f":"SUMIF('Expense Form'!$P$128:$P$206,'Expense Form'!T189,'Expense Form'!$Q$128:$Q$206)","v":0}]
[{"$nulls":3},{"$f":"IF($D$189=$D$13,D14,\"\")","v":""},{"$nulls":15},"5555.01 Bursaries",{"$f":"SUMIF('Expense Form'!$P$128:$P$206,'Expense Form'!T190,'Expense Form'!$Q$128:$Q$206)","v":0}]
[{"$nulls":3},{"$f":"IF($D$189=$D$13,D15,\"\")","v":""},{"$nulls":15},"5555.02 Jointly Funded Charities",{"$f":"SUMIF('Expense Form'!$P$128:$P$206,'Expense Form'!T191,'Expense Form'!$Q$128:$Q$206)","v":0}]
[{"$nulls":19},"5555.03 Women's Centers and Groups",{"$f":"SUMIF('Expense Form'!$P$128:$P$206,'Expense Form'!T192,'Expense Form'!$Q$128:$Q$206)","v":0}]
[{"$nulls":3},{"$f":"IF($D$189=$D$13,D16,\"\")","v":""},{"$nulls":15},"5555.04 Youth Related Groups and Charities",{"$f":"SUMIF('Expense Form'!$P$128:$P$206,'Expense Form'!T193,'Expense Form'!$Q$128:$Q$206)","v":0}]
[{"$nulls":19},"5555.05 Helping Hands",{"$f":"SUMIF('Expense Form'!$P$128:$P$206,'Expense Form'!T194,'Expense Form'!$Q$128:$Q$206)","v":0}]
[{"$nulls":3},{"$f":"IF($D$189=$D$13,D17,\"\")","v":""},{"$nulls":15},"5555.06 Labour Events",{"$f":"SUMIF('Expense Form'!$P$128:$P$206,'Expense Form'!T195,'Expense Form'!$Q$128:$Q$206)","v":0}]
[{"$nulls":19},"5555.07 General Health and OH&S",{"$f":"SUMIF('Expense Form'!$P$128:$P$206,'Expense Form'!T196,'Expense Form'!$Q$128:$Q$206)","v":0}]
[{"$nulls":3},"SUB-TOTAL A to E:",{"$nulls":4},{"$f":"+M166+M172+M186","v":{"v":0,"d":"$0.00"}},{"$nulls":3},"SUB-TOTAL \nA to E",{"$nulls":6},"5555.08 Promotional",{"$f":"SUMIF('Expense Form'!$P$128:$P$206,'Expense Form'!T197,'Expense Form'!$Q$128:$Q$206)","v":0}]
[{"$nulls":19},"5555.09 Special Events",{"$f":"SUMIF('Expense Form'!$P$128:$P$206,'Expense Form'!T198,'Expense Form'!$Q$128:$Q$206)","v":0}]
[{"$nulls":19},"5555.09.01 Special Events Abbotsford",{"$f":"SUMIF('Expense Form'!$P$128:$P$206,'Expense Form'!T199,'Expense Form'!$Q$128:$Q$206)","v":0}]
[{"$nulls":3},"SECTION F - ACCOMMODATIONS / ACCOMMODATION EQUIVALENT                                                                                                                .",{"$nulls":15},"5555.09.02 Special Events Burnaby",{"$f":"SUMIF('Expense Form'!$P$128:$P$206,'Expense Form'!T200,'Expense Form'!$Q$128:$Q$206)","v":0}]
[{"$nulls":3},"Date(s) from/to (YYYY-MM-DD to YYYY-MM-DD)",null,"Hotel Name or Enter \"Hotel Equivalent\"",{"$nulls":5},"Amount",{"$nulls":7},"5555.09.03 Special Events Courtenay",{"$f":"SUMIF('Expense Form'!$P$128:$P$206,'Expense Form'!T201,'Expense Form'!$Q$128:$Q$206)","v":0}]
[{"$nulls":16},{"$f":"+L202","v":0},null,null,"5555.09.04  Special Events Cranbrook",{"$f":"SUMIF('Expense Form'!$P$128:$P$206,'Expense Form'!T202,'Expense Form'!$Q$128:$Q$206)","v":0}]
[{"$nulls":12},"TOTAL C",{"$nulls":3},0,null,null,"5555.09.05 Special Events Fort St John",{"$f":"SUMIF('Expense Form'!$P$128:$P$206,'Expense Form'!T203,'Expense Form'!$Q$128:$Q$206)","v":0}]
[{"$nulls":16},0,null,null,"5555.09.06 Special Events Kamloops",{"$f":"SUMIF('Expense Form'!$P$128:$P$206,'Expense Form'!T204,'Expense Form'!$Q$128:$Q$206)","v":0}]
[{"$nulls":12},{"$f":"SUM(L202:L206)","v":{"v":0,"d":"$0.00"}},{"$nulls":3},0,null,null,"5555.09.07 Special Events Kelowna",{"$f":"SUMIF('Expense Form'!$P$128:$P$206,'Expense Form'!T205,'Expense Form'!$Q$128:$Q$206)","v":0}]
[{"$nulls":16},0,null,{"$f":"SUM(Q202:Q206)","v":0},"5555.09.08 Special Events Nanaimo",{"$f":"SUMIF('Expense Form'!$P$128:$P$206,'Expense Form'!T206,'Expense Form'!$Q$128:$Q$206)","v":0}]
[{"$nulls":19},"5555.09.09 Special Events Nelson",{"$f":"SUMIF('Expense Form'!$P$128:$P$206,'Expense Form'!T207,'Expense Form'!$Q$128:$Q$206)","v":0}]
[{"$nulls":3},"Date Signed/Submitted: ",{"$nulls":7},"TOTAL: A to C",{"$f":"+I197+M205","v":{"v":0,"d":"$0.00"}},{"$nulls":6},"5555.09.10 Special Events Port Moody",{"$f":"SUMIF('Expense Form'!$P$128:$P$206,'Expense Form'!T208,'Expense Form'!$Q$128:$Q$206)","v":0}]
[{"$nulls":19},"5555.09.11 Special Events Prince George",{"$f":"SUMIF('Expense Form'!$P$128:$P$206,'Expense Form'!T209,'Expense Form'!$Q$128:$Q$206)","v":0}]
[{"$nulls":3},"Please clarify the payment method \n1. Direct Deposit                                                         --->\n2. Cheque (we need your mailing address)",null,{"$f":"+P16","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)."},{"$nulls":13},"5555.09.12.1 Special Events Richmond - Quadrent 1",{"$f":"SUMIF('Expense Form'!$P$128:$P$206,'Expense Form'!T210,'Expense Form'!$Q$128:$Q$206)","v":0}]
[{"$nulls":19},"5555.09.12.2 Special Events Richmond - Quadrent 2",{"$f":"SUMIF('Expense Form'!$P$128:$P$206,'Expense Form'!T211,'Expense Form'!$Q$128:$Q$206)","v":0}]
[{"$nulls":3},"Signature:\nOr indicate it has been submitted by email",{"$nulls":7},"LESS\nADVANCE(S)",{"v":0,"d":"$0.00"},{"$nulls":6},"5555.09.12.3 Special Events Richmond - Quadrent 3",{"$f":"SUMIF('Expense Form'!$P$128:$P$206,'Expense Form'!T212,'Expense Form'!$Q$128:$Q$206)","v":0}]
[{"$nulls":19},"5555.09.12.4 Special Events Richmond - Quadrent 4",{"$f":"SUMIF('Expense Form'!$P$128:$P$206,'Expense Form'!T213,'Expense Form'!$Q$128:$Q$206)","v":0}]
[{"$nulls":3},"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":"M208-M212","v":{"v":0,"d":"$0.00"}},{"$nulls":6},"5555.09.13 Special Events Surrey",{"$f":"SUMIF('Expense Form'!$P$128:$P$206,'Expense Form'!T214,'Expense Form'!$Q$128:$Q$206)","v":0}]
[{"$nulls":16},{"$f":"SUM(Q128:Q214)","v":0},"TOTAL",{"$f":"SUM(S166:S213)","v":{"v":0,"d":"$0.00"}},"5555.09.14 Special Events Terrace",{"$f":"SUMIF('Expense Form'!$P$128:$P$206,'Expense Form'!T215,'Expense Form'!$Q$128:$Q$206)","v":0}]
[{"$nulls":3},"OFFICE USE ONLY",{"$nulls":15},"5555.09.15 Special Events Victoria",{"$f":"SUMIF('Expense Form'!$P$128:$P$206,'Expense Form'!T216,'Expense Form'!$Q$128:$Q$206)","v":0}]
[{"$nulls":3},"Notes: When approving travel, please confirm to Bookkeeper the account/classification:",{"$nulls":15},"5555.09.16 Special Events Williams Lake",{"$f":"SUMIF('Expense Form'!$P$128:$P$206,'Expense Form'!T217,'Expense Form'!$Q$128:$Q$206)","v":0}]
[{"$nulls":3},"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\n5552 Membership Engagement\n5552.01 Member Conference (One Day)\n5552.02 Member Engagement Recognition (6 Draw prizes)\n5552.99 Other",{"$nulls":9},"5555.09.99 Special Events Other",{"$f":"SUMIF('Expense Form'!$P$128:$P$206,'Expense Form'!T218,'Expense Form'!$Q$128:$Q$206)","v":0}]
[{"$nulls":19},"5555.10 Yearly Memberships",{"$f":"SUMIF('Expense Form'!$P$128:$P$206,'Expense Form'!T219,'Expense Form'!$Q$128:$Q$206)","v":0}]
[{"$nulls":19},"5555.11 Non-recurring Donation",{"$f":"SUMIF('Expense Form'!$P$128:$P$206,'Expense Form'!T220,'Expense Form'!$Q$128:$Q$206)","v":0}]
[{"$nulls":20},{"$f":"SUMIF('Expense Form'!$P$128:$P$206,'Expense Form'!T221,'Expense Form'!$Q$128:$Q$206)","v":0}]
[{"$nulls":20},{"$f":"SUMIF('Expense Form'!$P$128:$P$206,'Expense Form'!T222,'Expense Form'!$Q$128:$Q$206)","v":0}]
[{"$nulls":20},{"$f":"SUMIF('Expense Form'!$P$128:$P$206,'Expense Form'!T223,'Expense Form'!$Q$128:$Q$206)","v":0}]
[{"$nulls":20},{"$f":"SUMIF('Expense Form'!$P$128:$P$206,'Expense Form'!T224,'Expense Form'!$Q$128:$Q$206)","v":0}]
[{"$nulls":19},{"$f":"+'Expense Form'!P114","v":0},{"$f":"SUMIF('Expense Form'!$P$128:$P$206,'Expense Form'!T225,'Expense Form'!$Q$128:$Q$206)","v":0}]
[{"$nulls":19},{"$f":"+'Expense Form'!P115","v":0},{"$f":"SUMIF('Expense Form'!$P$128:$P$206,'Expense Form'!T226,'Expense Form'!$Q$128:$Q$206)","v":0}]
[{"$nulls":19},{"$f":"+'Expense Form'!P116","v":0},{"$f":"SUMIF('Expense Form'!$P$128:$P$206,'Expense Form'!T227,'Expense Form'!$Q$128:$Q$206)","v":0}]
[{"$nulls":19},{"$f":"+'Expense Form'!P117","v":0},{"$f":"SUMIF('Expense Form'!$P$128:$P$206,'Expense Form'!T228,'Expense Form'!$Q$128:$Q$206)","v":0}]
[{"$nulls":19},{"$f":"+'Expense Form'!P118","v":0},{"$f":"SUMIF('Expense Form'!$P$128:$P$206,'Expense Form'!T229,'Expense Form'!$Q$128:$Q$206)","v":0}]