{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Summary","List of Expenses","Categories"],"not_rendered":{"images":1,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Summary","index":0,"n_rows":50,"n_cols":6,"rows_kept":50,"merged":[[4,1,4,2],[4,3,4,5],[5,1,5,2],[5,3,5,5],[6,1,6,2],[6,3,6,5],[8,1,8,2],[8,4,8,5],[9,1,45,2],[18,5,19,5]]}
[{"$nulls":5},"EVANGELISM SUBSIDY"]
[{"$nulls":5}," EXPENSE REPORT"]
[{"$nulls":5},"Last Updated Jan 18, 2018"]
[]
[null,"Name of Church"]
[null,"Date oF Event"]
[null,"Speaker"]
[]
[null,"Notes",null,null,"Expenses by Category"]
[null," - This completed form should be submitted to the Conference within 60 days of the Evangelistic Event ending.\n - Please submit this for to: accountspayable@albertaadventist.ca\n - Electronic Scan/Photocopies of the receipts showing actual amounts spent must accompany this form (please include a copy of the actual Invoice...Credit Card statements or VISA/Debit slips are not sufficient)\n - Enter the Total of each Receipt in the List of Expenses and fill in the Category.\n - Requests for a new year will not be approved until previous year's Evangelism Subsidy is accounted for\n - Conference portion is 65% up to Approved maximum amount for series\n - Computers and electronic equipment are ineligble for reimbursement",null,"Evangelist(s)",{"$f":"SUMIF(Table1[Category],Summary!D10,Table1[Total])","v":0},"Honorariums"]
[{"$nulls":3},"Musician(s)",{"$f":"SUMIF(Table1[Category],Summary!D11,Table1[Total])","v":0}]
[{"$nulls":3},"Volunteer(s)",{"$f":"SUMIF(Table1[Category],Summary!D12,Table1[Total])","v":0}]
[]
[{"$nulls":3},"Flights",{"$f":"SUMIF(Table1[Category],Summary!D14,Table1[Total])","v":0},"Travel costs"]
[{"$nulls":3},"Car Rental",{"$f":"SUMIF(Table1[Category],Summary!D15,Table1[Total])","v":0}]
[{"$nulls":3},"Accommodations",{"$f":"SUMIF(Table1[Category],Summary!D16,Table1[Total])","v":0}]
[{"$nulls":3},"Per Diem or Meals",{"$f":"SUMIF(Table1[Category],Summary!D17,Table1[Total])","v":0}]
[]
[{"$nulls":3},"Hall Rental",{"$f":"SUMIF(Table1[Category],Summary!D19,Table1[Total])","v":0},"Facility & Equipment Rental"]
[{"$nulls":3},"A/V Rental",{"$f":"SUMIF(Table1[Category],Summary!D20,Table1[Total])","v":0}]
[{"$nulls":3},"Decorating",{"$f":"SUMIF(Table1[Category],Summary!D21,Table1[Total])","v":0}]
[{"$nulls":3},"Guest Services",{"$f":"SUMIF(Table1[Category],Summary!D22,Table1[Total])","v":0},"Parking, Refreshments"]
[{"$nulls":3},"Other meeting hall costs",{"$f":"SUMIF(Table1[Category],Summary!D23,Table1[Total])","v":0},"Chairs, Tables, Piano Rentals"]
[]
[{"$nulls":3},"Children’s Program",{"$f":"SUMIF(Table1[Category],Summary!D25,Table1[Total])","v":0},"Programming"]
[]
[{"$nulls":3},"Bibles & Books",{"$f":"SUMIF(Table1[Category],Summary!D27,Table1[Total])","v":0},"Materials"]
[{"$nulls":3},"Gifts & Giveaways",{"$f":"SUMIF(Table1[Category],Summary!D28,Table1[Total])","v":0}]
[{"$nulls":3},"Sermon Outlines",{"$f":"SUMIF(Table1[Category],Summary!D29,Table1[Total])","v":0}]
[{"$nulls":3},"Offering Envelopes",{"$f":"SUMIF(Table1[Category],Summary!D30,Table1[Total])","v":0}]
[{"$nulls":3},"CDs/DVDs",{"$f":"SUMIF(Table1[Category],Summary!D31,Table1[Total])","v":0}]
[{"$nulls":3},"Office Supplies",{"$f":"SUMIF(Table1[Category],Summary!D32,Table1[Total])","v":0},"Pencils, Stationery"]
[]
[{"$nulls":3},"Mailing/Shipping",{"$f":"SUMIF(Table1[Category],Summary!D34,Table1[Total])","v":0},"Advertising"]
[{"$nulls":3},"Handbills (printing)",{"$f":"SUMIF(Table1[Category],Summary!D35,Table1[Total])","v":0}]
[{"$nulls":3},"Website",{"$f":"SUMIF(Table1[Category],Summary!D36,Table1[Total])","v":0}]
[{"$nulls":3},"Internet Ads",{"$f":"SUMIF(Table1[Category],Summary!D37,Table1[Total])","v":0}]
[{"$nulls":3},"Newspaper ads",{"$f":"SUMIF(Table1[Category],Summary!D38,Table1[Total])","v":0}]
[{"$nulls":3},"Radio ads",{"$f":"SUMIF(Table1[Category],Summary!D39,Table1[Total])","v":0}]
[{"$nulls":3},"TV ads",{"$f":"SUMIF(Table1[Category],Summary!D40,Table1[Total])","v":0}]
[{"$nulls":3},"Billboards",{"$f":"SUMIF(Table1[Category],Summary!D41,Table1[Total])","v":0}]
[]
[{"$nulls":3},"Miscellaneous",{"$f":"SUMIF(Table1[Category],Summary!D43,Table1[Total])","v":0},"Other"]
[{"$nulls":3},"Contingency",{"$f":"SUMIF(Table1[Category],Summary!D44,Table1[Total])","v":0}]
[{"$nulls":3},"Uncategorized",{"$f":"SUMIF(Table1[Category],\"\",Table1[Total])","v":0}]
[{"$nulls":3},"Unapproved",{"$f":"SUMIF(Table1[[#All],[Category]], \"Unapproved\",Table1[[#All],[Total]])","v":0}]
[]
[{"$nulls":4},"Total Expenses",{"$f":"SUM(E10:E45)","v":0}]
[{"$nulls":4},"Church Portion (35%)",{"$f":"F48*0.35","v":0}]
[{"$nulls":4},"Conference Portion (65%)",{"$f":"F48*0.65","v":0}]

{"sheet":"List of Expenses","index":1,"n_rows":69,"n_cols":11,"rows_kept":69,"merged":[[0,0,0,7],[0,9,0,10],[8,9,9,9],[8,10,9,10]]}
[{"$f":"CONCATENATE(Summary!D5, \" Evangelism Expenses \")","v":" Evangelism Expenses "},{"$nulls":8},"Event Summary"]
["Item","Amount","CAD/USD","Category","Month/Year","Adjustment Factor","Total","Comments",null,"Category Summary","Amount"]
[null,null,{"$f":"\"CAD\"","v":"CAD"},null,null,{"$f":"1","v":1},{"$f":"Table1[[#This Row],[Amount]]*Table1[[#This Row],[Adjustment Factor]]","v":0},null,null,"Total Expenses",{"$f":"SUM(Table1[Total])","v":0}]
[null,null,"CAD",null,null,{"$f":"1","v":1},{"$f":"Table1[[#This Row],[Amount]]*Table1[[#This Row],[Adjustment Factor]]","v":0},null,null,"Unapproved",{"$f":"SUMIF(Table1[[#All],[Category]], \"Unapproved\",Table1[[#All],[Amount]])","v":0}]
[null,null,"CAD",null,null,{"$f":"1","v":1},{"$f":"Table1[[#This Row],[Amount]]*Table1[[#This Row],[Adjustment Factor]]","v":0},null,null,"Total @ 65%",{"$f":"(K3-K4)*0.65","v":0}]
[null,null,"CAD",null,null,{"$f":"1","v":1},{"$f":"Table1[[#This Row],[Amount]]*Table1[[#This Row],[Adjustment Factor]]","v":0},null,null,"\t"]
[null,null,"CAD",null,null,{"$f":"1","v":1},{"$f":"Table1[[#This Row],[Amount]]*Table1[[#This Row],[Adjustment Factor]]","v":0},null,null,"Advanced"]
[null,null,"CAD",null,null,{"$f":"1","v":1},{"$f":"Table1[[#This Row],[Amount]]*Table1[[#This Row],[Adjustment Factor]]","v":0},null,null,"Approved Max"]
[null,null,"CAD",null,null,{"$f":"1","v":1},{"$f":"Table1[[#This Row],[Amount]]*Table1[[#This Row],[Adjustment Factor]]","v":0},null,null,{"$f":"IF(K9<0,\"Amout of Advance to Return to Conference\",\"Total Reimbursement\")","v":"Total Reimbursement"},{"$f":"IF(K8<K5,K8-K7,K5-K7)","v":0}]
[null,null,"CAD",null,null,{"$f":"1","v":1},{"$f":"Table1[[#This Row],[Amount]]*Table1[[#This Row],[Adjustment Factor]]","v":0}]
[null,null,"CAD",null,null,{"$f":"1","v":1},{"$f":"Table1[[#This Row],[Amount]]*Table1[[#This Row],[Adjustment Factor]]","v":0}]
[null,null,"CAD",null,null,{"$f":"1","v":1},{"$f":"Table1[[#This Row],[Amount]]*Table1[[#This Row],[Adjustment Factor]]","v":0},null,null,"CHQ #"]
[null,null,"CAD",null,null,{"$f":"1","v":1},{"$f":"Table1[[#This Row],[Amount]]*Table1[[#This Row],[Adjustment Factor]]","v":0},null,null,{"$f":"IF(K9<0,\"Date Returned\", \"Date Sent\")","v":"Date Sent"}]
[null,null,"CAD",null,null,{"$f":"1","v":1},{"$f":"Table1[[#This Row],[Amount]]*Table1[[#This Row],[Adjustment Factor]]","v":0}]
[null,null,"CAD",null,null,{"$f":"1","v":1},{"$f":"Table1[[#This Row],[Amount]]*Table1[[#This Row],[Adjustment Factor]]","v":0}]
[null,null,"CAD",null,null,{"$f":"1","v":1},{"$f":"Table1[[#This Row],[Amount]]*Table1[[#This Row],[Adjustment Factor]]","v":0}]
[null,null,"CAD",null,null,{"$f":"1","v":1},{"$f":"Table1[[#This Row],[Amount]]*Table1[[#This Row],[Adjustment Factor]]","v":0}]
[null,null,"CAD",null,null,{"$f":"1","v":1},{"$f":"Table1[[#This Row],[Amount]]*Table1[[#This Row],[Adjustment Factor]]","v":0}]
[null,null,"CAD",null,null,{"$f":"1","v":1},{"$f":"Table1[[#This Row],[Amount]]*Table1[[#This Row],[Adjustment Factor]]","v":0}]
[null,null,"CAD",null,null,{"$f":"1","v":1},{"$f":"Table1[[#This Row],[Amount]]*Table1[[#This Row],[Adjustment Factor]]","v":0}]
[null,null,"CAD",null,null,{"$f":"1","v":1},{"$f":"Table1[[#This Row],[Amount]]*Table1[[#This Row],[Adjustment Factor]]","v":0}]
[null,null,"CAD",null,null,{"$f":"1","v":1},{"$f":"Table1[[#This Row],[Amount]]*Table1[[#This Row],[Adjustment Factor]]","v":0}]
[null,null,"CAD",null,null,{"$f":"1","v":1},{"$f":"Table1[[#This Row],[Amount]]*Table1[[#This Row],[Adjustment Factor]]","v":0}]
[null,null,"CAD",null,null,{"$f":"1","v":1},{"$f":"Table1[[#This Row],[Amount]]*Table1[[#This Row],[Adjustment Factor]]","v":0}]
[null,null,"CAD",null,null,{"$f":"1","v":1},{"$f":"Table1[[#This Row],[Amount]]*Table1[[#This Row],[Adjustment Factor]]","v":0}]
[null,null,"CAD",null,null,{"$f":"1","v":1},{"$f":"Table1[[#This Row],[Amount]]*Table1[[#This Row],[Adjustment Factor]]","v":0}]
[null,null,"CAD",null,null,{"$f":"1","v":1},{"$f":"Table1[[#This Row],[Amount]]*Table1[[#This Row],[Adjustment Factor]]","v":0}]
[null,null,"CAD",null,null,{"$f":"1","v":1},{"$f":"Table1[[#This Row],[Amount]]*Table1[[#This Row],[Adjustment Factor]]","v":0}]
[null,null,"CAD",null,null,{"$f":"1","v":1},{"$f":"Table1[[#This Row],[Amount]]*Table1[[#This Row],[Adjustment Factor]]","v":0}]
[null,null,"CAD",null,null,{"$f":"1","v":1},{"$f":"Table1[[#This Row],[Amount]]*Table1[[#This Row],[Adjustment Factor]]","v":0}]
[null,null,"CAD",null,null,{"$f":"1","v":1},{"$f":"Table1[[#This Row],[Amount]]*Table1[[#This Row],[Adjustment Factor]]","v":0}]
[null,null,"CAD",null,null,{"$f":"1","v":1},{"$f":"Table1[[#This Row],[Amount]]*Table1[[#This Row],[Adjustment Factor]]","v":0}]
[null,null,"CAD",null,null,{"$f":"1","v":1},{"$f":"Table1[[#This Row],[Amount]]*Table1[[#This Row],[Adjustment Factor]]","v":0}]
[null,null,"CAD",null,null,{"$f":"1","v":1},{"$f":"Table1[[#This Row],[Amount]]*Table1[[#This Row],[Adjustment Factor]]","v":0}]
[null,null,{"$f":"\"CAD\"","v":"CAD"},null,null,{"$f":"1","v":1},{"$f":"Table1[[#This Row],[Amount]]*Table1[[#This Row],[Adjustment Factor]]","v":0}]
[null,null,"CAD",null,null,{"$f":"1","v":1},{"$f":"Table1[[#This Row],[Amount]]*Table1[[#This Row],[Adjustment Factor]]","v":0}]
[null,null,"CAD",null,null,{"$f":"1","v":1},{"$f":"Table1[[#This Row],[Amount]]*Table1[[#This Row],[Adjustment Factor]]","v":0}]
[null,null,"CAD",null,null,{"$f":"1","v":1},{"$f":"Table1[[#This Row],[Amount]]*Table1[[#This Row],[Adjustment Factor]]","v":0}]
[null,null,"CAD",null,null,{"$f":"1","v":1},{"$f":"Table1[[#This Row],[Amount]]*Table1[[#This Row],[Adjustment Factor]]","v":0}]
[null,null,"CAD",null,null,{"$f":"1","v":1},{"$f":"Table1[[#This Row],[Amount]]*Table1[[#This Row],[Adjustment Factor]]","v":0}]
[null,null,"CAD",null,null,{"$f":"1","v":1},{"$f":"Table1[[#This Row],[Amount]]*Table1[[#This Row],[Adjustment Factor]]","v":0}]
[null,null,"CAD",null,null,{"$f":"1","v":1},{"$f":"Table1[[#This Row],[Amount]]*Table1[[#This Row],[Adjustment Factor]]","v":0}]
[null,null,"CAD",null,null,{"$f":"1","v":1},{"$f":"Table1[[#This Row],[Amount]]*Table1[[#This Row],[Adjustment Factor]]","v":0}]
[null,null,"CAD",null,null,{"$f":"1","v":1},{"$f":"Table1[[#This Row],[Amount]]*Table1[[#This Row],[Adjustment Factor]]","v":0}]
[null,null,"CAD",null,null,{"$f":"1","v":1},{"$f":"Table1[[#This Row],[Amount]]*Table1[[#This Row],[Adjustment Factor]]","v":0}]
[null,null,"CAD",null,null,{"$f":"1","v":1},{"$f":"Table1[[#This Row],[Amount]]*Table1[[#This Row],[Adjustment Factor]]","v":0}]
[null,null,"CAD",null,null,{"$f":"1","v":1},{"$f":"Table1[[#This Row],[Amount]]*Table1[[#This Row],[Adjustment Factor]]","v":0}]
[null,null,"CAD",null,null,{"$f":"1","v":1},{"$f":"Table1[[#This Row],[Amount]]*Table1[[#This Row],[Adjustment Factor]]","v":0}]
[null,null,"CAD",null,null,{"$f":"1","v":1},{"$f":"Table1[[#This Row],[Amount]]*Table1[[#This Row],[Adjustment Factor]]","v":0}]
[null,null,"CAD",null,null,{"$f":"1","v":1},{"$f":"Table1[[#This Row],[Amount]]*Table1[[#This Row],[Adjustment Factor]]","v":0}]
[null,null,"CAD",null,null,{"$f":"1","v":1},{"$f":"Table1[[#This Row],[Amount]]*Table1[[#This Row],[Adjustment Factor]]","v":0}]
[null,null,"CAD",null,null,{"$f":"1","v":1},{"$f":"Table1[[#This Row],[Amount]]*Table1[[#This Row],[Adjustment Factor]]","v":0}]
[null,null,"CAD",null,null,{"$f":"1","v":1},{"$f":"Table1[[#This Row],[Amount]]*Table1[[#This Row],[Adjustment Factor]]","v":0}]
[null,null,"CAD",null,null,{"$f":"1","v":1},{"$f":"Table1[[#This Row],[Amount]]*Table1[[#This Row],[Adjustment Factor]]","v":0}]
[null,null,"CAD",null,null,{"$f":"1","v":1},{"$f":"Table1[[#This Row],[Amount]]*Table1[[#This Row],[Adjustment Factor]]","v":0}]
[null,null,"CAD",null,null,{"$f":"1","v":1},{"$f":"Table1[[#This Row],[Amount]]*Table1[[#This Row],[Adjustment Factor]]","v":0}]
[null,null,"CAD",null,null,{"$f":"1","v":1},{"$f":"Table1[[#This Row],[Amount]]*Table1[[#This Row],[Adjustment Factor]]","v":0}]
[null,null,"CAD",null,null,{"$f":"1","v":1},{"$f":"Table1[[#This Row],[Amount]]*Table1[[#This Row],[Adjustment Factor]]","v":0}]
[null,null,"CAD",null,null,{"$f":"1","v":1},{"$f":"Table1[[#This Row],[Amount]]*Table1[[#This Row],[Adjustment Factor]]","v":0}]
[null,null,"CAD",null,null,{"$f":"1","v":1},{"$f":"Table1[[#This Row],[Amount]]*Table1[[#This Row],[Adjustment Factor]]","v":0}]
[null,null,"CAD",null,null,{"$f":"1","v":1},{"$f":"Table1[[#This Row],[Amount]]*Table1[[#This Row],[Adjustment Factor]]","v":0}]
[null,null,"CAD",null,null,{"$f":"1","v":1},{"$f":"Table1[[#This Row],[Amount]]*Table1[[#This Row],[Adjustment Factor]]","v":0}]
[null,null,"CAD",null,null,{"$f":"1","v":1},{"$f":"Table1[[#This Row],[Amount]]*Table1[[#This Row],[Adjustment Factor]]","v":0}]
[null,null,"CAD",null,null,{"$f":"1","v":1},{"$f":"Table1[[#This Row],[Amount]]*Table1[[#This Row],[Adjustment Factor]]","v":0}]
[null,null,"CAD",null,null,{"$f":"1","v":1},{"$f":"Table1[[#This Row],[Amount]]*Table1[[#This Row],[Adjustment Factor]]","v":0}]
[null,null,"CAD",null,null,{"$f":"1","v":1},{"$f":"Table1[[#This Row],[Amount]]*Table1[[#This Row],[Adjustment Factor]]","v":0}]
[null,null,{"$f":"\"CAD\"","v":"CAD"},null,null,{"$f":"1","v":1},{"$f":"Table1[[#This Row],[Amount]]*Table1[[#This Row],[Adjustment Factor]]","v":0}]
[null,null,"CAD",null,null,{"$f":"1","v":1},{"$f":"Table1[[#This Row],[Amount]]*Table1[[#This Row],[Adjustment Factor]]","v":0}]
[null,null,"CAD",null,null,{"$f":"1","v":1},{"$f":"Table1[[#This Row],[Amount]]*Table1[[#This Row],[Adjustment Factor]]","v":0}]

{"sheet":"Categories","index":2,"n_rows":32,"n_cols":2,"rows_kept":32,"hidden":true}
[]
[null,"Categories"]
[null,"Evangelist(s)"]
[null,"Musician(s)"]
[null,"Volunteer(s)"]
[null,"Flights"]
[null,"Car Rental"]
[null,"Accommodations"]
[null,"Per Diem or Meals"]
[null,"Hall Rental"]
[null,"A/V Rental"]
[null,"Decorating"]
[null,"Guest Services"]
[null,"Other meeting hall costs"]
[null,"Children’s Program"]
[null,"Bibles & Books"]
[null,"Gifts & Giveaways"]
[null,"Sermon Outlines"]
[null,"Offering Envelopes"]
[null,"CDs/DVDs"]
[null,"Office Supplies"]
[null,"Mailing/Shipping"]
[null,"Handbills (printing)"]
[null,"Website"]
[null,"Internet ads"]
[null,"Newspaper ads"]
[null,"Radio ads"]
[null,"TV ads"]
[null,"Billboards"]
[null,"Miscellaneous"]
[null,"Contingency"]
[null,"Unapproved"]