{"text_format":"1","workbook":"xlsx","n_sheets":22,"sheets":["Instructions","Vision","Summary","Main_BGT","S1","S2","S3","S4","S5","S6","S7","S8","S9","S10","Module1","S11","S12","S13","S14","Module2","Blank","Module4"],"not_rendered":{"charts":1,"images":1,"macros":1,"external_links":0,"defined_names":76,"comments":11,"pivot_tables":0},"unopened":[{"sheet":"Module1","index":14,"reason":"part_missing"},{"sheet":"Module2","index":19,"reason":"part_missing"},{"sheet":"Blank","index":20,"reason":"part_missing"},{"sheet":"Module4","index":21,"reason":"part_missing"}],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":32,"n_cols":2,"rows_kept":32,"cut":false,"hidden":false,"merged":[[0,0,0,8],[6,0,6,8],[1,0,1,8],[2,0,2,8],[7,1,8,8],[29,0,29,8],[15,1,16,8],[18,1,19,8],[21,1,21,8],[10,1,14,8]]}
["InterAct Ministries of Canada"]
["2023-2024 Budget"]
[{"$f":"TODAY()","v":"2024-06-20"}]
[]
[]
[]
["Instructions"]
["Step 1","To display individual budgt pages, on the Main Budget worksheet click the GoTo button below the name of the budget you want to open."]
[]
[]
["Step 2","Enter each segment of a project on a separate line according to the account description. When you enter an account number the account description will fill in automatically. It is not necessary to enter the items in any particular sequence, but if you start each line of a project with the same word they can be sorted accordingly (such as Conf. Travel, Conf. Food, Conf. Speaker, etc.)"]
[]
[]
[]
[]
[null,"Current data on the form is for illustration only. You can delete any data you don't need. For additional lines you may use open lines at the bottom or insert new lines into the form."]
[]
[]
["Step 3","Enter a detailed description of each item (how many at how much each). Use as many lines as necessary to descript each item."]
[]
[]
["Step 4","Enter the amount of income or cost for each line"]
[]
["Click the GoTo Main BGT button below to continue"]
[]
[]
[]
[]
[]
["Notes"]
[]
["1. Lodging calculated at $125 per night"]

{"sheet":"Vision","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Summary","index":2,"n_rows":18,"n_cols":9,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[null,"USE OF FUNDS - SUMMARY"]
["2023-2024","2024-2025",null,null,null,null,null,null,"2023-2024"]
[null,"Expenses by Department"]
[1132769,{"$f":"'S1'!E3","v":1162738.5},null,"Native Ministries"]
[12150,{"$f":"'S2'!E3","v":11750},null,"EnGage!"]
[98343,{"$f":"'S3'!E3","v":102590},null,"Muslim Ministries"]
[117588,{"$f":"'S4'!E3","v":111240},null,"East Indian Ministries"]
[38057,{"$f":"'S5'!E3","v":28249},null,"Anchored Warriors"]
[130688,{"$f":"'S6'!E3","v":64158.5},null,"Native Bible Centre"]
[118385,{"$f":"'S7'!E3","v":116160},null,"Collaborative Ministries"]
[107177,{"$f":"'S8'!E3","v":104703},null,"Member Care"]
[463574,{"$f":"'S9'!E3","v":290647.5},null,"Admin & General*"]
[21743,{"$f":"'S10'!E3","v":22075},null,"Mobilization"]
[803625,{"$f":"'S11'!E3","v":660050},null,"Midway Ministries"]
[22500,{"$f":"'S12'!E3","v":20000},null,"Development"]
[15880,{"$f":"'S13'!E3","v":11450},null,"Urban Fire"]
[89900,{"$f":"'S14'!E3","v":89712},null,"Restora"]
[{"$f":"SUM(A4:A17)","v":3172379},{"$f":"SUM(B4:B17)","v":2795523.5},null,"Total"]

{"sheet":"Main_BGT","index":3,"n_rows":65,"n_cols":20,"rows_kept":65,"cut":false,"hidden":false,"merged":[[0,17,0,19],[1,17,1,18],[0,14,0,16],[0,5,0,10],[1,5,1,10]]}
[null,null,null,null,null,"Program Ministries",null,null,null,null,null,null,null,null,"Program Ministries",null,null,"Management & General"]
[null,null,null,null,null,"Church Planting & Evangelism",null,null,null,null,null,null,null,null,"Schools","Other Programs","Support","Operations",null,"Fund Raising"]
[null,null,"InterAct Canada","Total","Total",{"$f":"'S1'!$C$1","v":50},{"$f":"'S2'!$C$1","v":40},{"$f":"'S3'!$C$1","v":85},{"$f":"'S4'!$C$1","v":20},{"$f":"'S5'!$C$1","v":15},51,52,53,null,{"$f":"'S6'!$C$1","v":10},{"$f":"'S7'!$C$1","v":60},{"$f":"'S8'!$C$1","v":30},{"$f":"'S9'!$C$1","v":70},{"$f":"'S10'!$C$1","v":80},{"$f":"'S12'!$C$1","v":81}]
[null,null,null,"Canada","Canada",{"$f":"'S1'!$B$1","v":"Native Ministries"},{"$f":"'S2'!$B$1","v":"EnGage!"},{"$f":"'S3'!$B$1","v":"Muslim Ministries"},{"$f":"'S4'!$B$1","v":"East Indian"},{"$f":"'S5'!$B$1","v":"Anchored Warriors"},{"$f":"'S11'!$B$1","v":"Midway Ministries"},{"$f":"'S13'!$B$1","v":"Urban Fire"},{"$f":"'S14'!B1","v":"Restora Property Care"},null,{"$f":"'S6'!$B$1","v":"Native Bible Centre"},{"$f":"'S7'!$A$1","v":"Collaborative Ministries"},{"$f":"'S8'!$B$1","v":"Member Care"},{"$f":"'S9'!$B$1","v":"Admin & General"},{"$f":"'S10'!$B$1","v":"Mobilization"},{"$f":"'S12'!$B$1","v":"Development"}]
["US No","Acct",null,"2023-2024","2024-2025"]
[null,null,"Total Income",3291667.5,{"$f":"SUM(F6:T6)","v":3087800},{"$f":"'S1'!$E$2","v":1169990.5},{"$f":"'S2'!$E$2","v":12150},{"$f":"'S3'!$E$2","v":102560},{"$f":"'S4'!$E$2","v":110984},{"$f":"'S5'!$E$2","v":29138},{"$f":"'S11'!$E$2","v":859800},{"$f":"'S13'!$E$2","v":23400},{"$f":"'S14'!E2","v":108620},{"$f":"C6","v":"Total Income"},{"$f":"'S6'!$E$2","v":87881},{"$f":"'S7'!$E$2","v":115000},{"$f":"'S8'!$E$2","v":106158},{"$f":"'S9'!$E$2","v":360318.5},{"$f":"'S10'!$E$2","v":1800},{"$f":"'S12'!$E$2","v":0}]
[null,null,"Total Expense",3172379,{"$f":"SUM(F7:T7)","v":2795523.5},{"$f":"'S1'!$E$3","v":1162738.5},{"$f":"'S2'!$E$3","v":11750},{"$f":"'S3'!$E$3","v":102590},{"$f":"'S4'!$E$3","v":111240},{"$f":"'S5'!$E$3","v":28249},{"$f":"'S11'!$E$3","v":660050},{"$f":"'S13'!$E$3","v":11450},{"$f":"'S14'!E3","v":89712},{"$f":"C7","v":"Total Expense"},{"$f":"'S6'!$E$3","v":64158.5},{"$f":"'S7'!$E$3","v":116160},{"$f":"'S8'!$E$3","v":104703},{"$f":"'S9'!$E$3","v":290647.5},{"$f":"'S10'!$E$3","v":22075},{"$f":"'S12'!$E$3","v":20000}]
[]
[null,null,"Excess (Deficit)",119288.5,{"$f":"E6-E7","v":292276.5},7252,400,-30,-256,889,{"$f":"K6-K7","v":199750},{"$f":"L6-L7","v":11950},{"$f":"M6-M7","v":18908},{"$f":"C9","v":"Excess (Deficit)"},{"$f":"O6-O7","v":23722.5},-1160,1455,69671,-20275,-20000]
[]
[502,null,"<--Highest or last Income",null,null,null,null,null,null,null,null,null,null,{"$f":"C11","v":"<--Highest or last Income"}]
[null,null,"Account No",null,null,null,null,null,null,null,null,null,null,"Account No"]
[1000,101,"Cash in Bank",0,{"$f":"SUM(F13:T13)","v":0},{"$f":"SUM(IF(S1AccNO=B13,IF(S1FieldRank<=S1Choice,S1Amount,0),0))","v":0},{"$f":"SUM(IF(S_2AccNO=$B13,IF(S_2FieldRank<=S_2Choice,S_2Amount,0),0))","v":0},{"$f":"SUM(IF(S_3AccNO=$B13,IF(S_3FieldRank<=S_3Choice,S_3Amount,0),0))","v":0},{"$f":"SUM(IF(S_4AccNO=$B13,IF(S_4FieldRank<=S_4Choice,S_4Amount,0),0))","v":0},{"$f":"SUM(IF(S_5AccNO=$B13,IF(S_5FieldRank<=S_5Choice,S_5Amount,0),0))","v":0},{"$f":"SUM(IF(S_5AccNO=$B13,IF(S_5FieldRank<=S_5Choice,S_5Amount,0),0))","v":0},{"$f":"SUM(IF(S_5AccNO=$B13,IF(S_5FieldRank<=S_5Choice,S_5Amount,0),0))","v":0},null,"Cash in Bank",{"$f":"SUM(IF(S_6AccNO=$B13,IF(S_6FieldRank<=S_6Choice,S_6Amount,0),0))","v":0},{"$f":"SUM(IF(S_7AccNO=$B13,IF(S_7FieldRank<=S_7Choice,S_7Amount,0),0))","v":0},{"$f":"SUM(IF(S_8AccNO=$B13,IF(S_8FieldRank<=S_8Choice,S_8Amount,0),0))","v":0},{"$f":"SUM(IF(S_9AccNO=$B13,IF(S_9FieldRank<=S_9Choice,S_9Amount,0),0))","v":0},{"$f":"SUM(IF(S_10AccNO=$B13,IF(S_10FieldRank<=S_10Choice,S_10Amount,0),0))","v":0},{"$f":"SUM(IF(S_12AccNO=$B13,IF(S_12FieldRank<=S_12Choice,S_12Amount,0),0))","v":0}]
[1000,103,"Cash on Hand",0,0,{"$f":"SUM(IF(S1AccNO=B14,IF(S1FieldRank<=S1Choice,S1Amount,0),0))","v":0},{"$f":"SUM(IF(S_2AccNO=$B14,IF(S_2FieldRank<=S_2Choice,S_2Amount,0),0))","v":0},{"$f":"SUM(IF(S_3AccNO=$B14,IF(S_3FieldRank<=S_3Choice,S_3Amount,0),0))","v":0},{"$f":"SUM(IF(S_4AccNO=$B14,IF(S_4FieldRank<=S_4Choice,S_4Amount,0),0))","v":0},{"$f":"SUM(IF(S_5AccNO=$B14,IF(S_5FieldRank<=S_5Choice,S_5Amount,0),0))","v":0},{"$f":"SUM(IF(S_5AccNO=$B14,IF(S_5FieldRank<=S_5Choice,S_5Amount,0),0))","v":0},{"$f":"SUM(IF(S_5AccNO=$B14,IF(S_5FieldRank<=S_5Choice,S_5Amount,0),0))","v":0},null,"Cash on Hand",{"$f":"SUM(IF(S_6AccNO=$B14,IF(S_6FieldRank<=S_6Choice,S_6Amount,0),0))","v":0},{"$f":"SUM(IF(S_7AccNO=$B14,IF(S_7FieldRank<=S_7Choice,S_7Amount,0),0))","v":0},{"$f":"SUM(IF(S_8AccNO=$B14,IF(S_8FieldRank<=S_8Choice,S_8Amount,0),0))","v":0},{"$f":"SUM(IF(S_9AccNO=$B14,IF(S_9FieldRank<=S_9Choice,S_9Amount,0),0))","v":0},{"$f":"SUM(IF(S_10AccNO=$B14,IF(S_10FieldRank<=S_10Choice,S_10Amount,0),0))","v":0},{"$f":"SUM(IF(S_12AccNO=$B14,IF(S_12FieldRank<=S_12Choice,S_12Amount,0),0))","v":0}]
[1200,110,"Accounts Receivable",0,0,{"$f":"SUM(IF(S1AccNO=B15,IF(S1FieldRank<=S1Choice,S1Amount,0),0))","v":0},{"$f":"SUM(IF(S_2AccNO=$B15,IF(S_2FieldRank<=S_2Choice,S_2Amount,0),0))","v":0},{"$f":"SUM(IF(S_3AccNO=$B15,IF(S_3FieldRank<=S_3Choice,S_3Amount,0),0))","v":0},{"$f":"SUM(IF(S_4AccNO=$B15,IF(S_4FieldRank<=S_4Choice,S_4Amount,0),0))","v":0},{"$f":"SUM(IF(S_5AccNO=$B15,IF(S_5FieldRank<=S_5Choice,S_5Amount,0),0))","v":0},{"$f":"SUM(IF(S_5AccNO=$B15,IF(S_5FieldRank<=S_5Choice,S_5Amount,0),0))","v":0},{"$f":"SUM(IF(S_5AccNO=$B15,IF(S_5FieldRank<=S_5Choice,S_5Amount,0),0))","v":0},null,"Accounts Receivable",{"$f":"SUM(IF(S_6AccNO=$B15,IF(S_6FieldRank<=S_6Choice,S_6Amount,0),0))","v":0},{"$f":"SUM(IF(S_7AccNO=$B15,IF(S_7FieldRank<=S_7Choice,S_7Amount,0),0))","v":0},{"$f":"SUM(IF(S_8AccNO=$B15,IF(S_8FieldRank<=S_8Choice,S_8Amount,0),0))","v":0},{"$f":"SUM(IF(S_9AccNO=$B15,IF(S_9FieldRank<=S_9Choice,S_9Amount,0),0))","v":0},{"$f":"SUM(IF(S_10AccNO=$B15,IF(S_10FieldRank<=S_10Choice,S_10Amount,0),0))","v":0},{"$f":"SUM(IF(S_12AccNO=$B15,IF(S_12FieldRank<=S_12Choice,S_12Amount,0),0))","v":0}]
[null,null,null,0,0,{"$f":"SUM(IF(S1AccNO=B16,IF(S1FieldRank<=S1Choice,S1Amount,0),0))","v":0},{"$f":"SUM(IF(S_2AccNO=$B16,IF(S_2FieldRank<=S_2Choice,S_2Amount,0),0))","v":0},{"$f":"SUM(IF(S_3AccNO=$B16,IF(S_3FieldRank<=S_3Choice,S_3Amount,0),0))","v":0},{"$f":"SUM(IF(S_4AccNO=$B16,IF(S_4FieldRank<=S_4Choice,S_4Amount,0),0))","v":0},{"$f":"SUM(IF(S_5AccNO=$B16,IF(S_5FieldRank<=S_5Choice,S_5Amount,0),0))","v":0},null,{"$f":"SUM(IF(S_5AccNO=$B16,IF(S_5FieldRank<=S_5Choice,S_5Amount,0),0))","v":0},null,0,{"$f":"SUM(IF(S_6AccNO=$B16,IF(S_6FieldRank<=S_6Choice,S_6Amount,0),0))","v":0},{"$f":"SUM(IF(S_7AccNO=$B16,IF(S_7FieldRank<=S_7Choice,S_7Amount,0),0))","v":0},{"$f":"SUM(IF(S_8AccNO=$B16,IF(S_8FieldRank<=S_8Choice,S_8Amount,0),0))","v":0},{"$f":"SUM(IF(S_9AccNO=$B16,IF(S_9FieldRank<=S_9Choice,S_9Amount,0),0))","v":0},{"$f":"SUM(IF(S_10AccNO=$B16,IF(S_10FieldRank<=S_10Choice,S_10Amount,0),0))","v":0},{"$f":"SUM(IF(S_12AccNO=$B16,IF(S_12FieldRank<=S_12Choice,S_12Amount,0),0))","v":0}]
[null,400,"Gifts in hand",433595,544125,{"$f":"SUM(IF(S1AccNO=B17,IF(S1FieldRank<=S1Choice,S1Amount,0),0))","v":9550},{"$f":"SUM(IF(S_2AccNO=$B17,IF(S_2FieldRank<=S_2Choice,S_2Amount,0),0))","v":0},{"$f":"SUM(IF(S_3AccNO=$B17,IF(S_3FieldRank<=S_3Choice,S_3Amount,0),0))","v":0},{"$f":"SUM(IF(S_4AccNO=$B17,IF(S_4FieldRank<=S_4Choice,S_4Amount,0),0))","v":13405},{"$f":"SUM(IF(S_5AccNO=$B17,IF(S_5FieldRank<=S_5Choice,S_5Amount,0),0))","v":14090},{"$f":"SUM(IF(S_11AccNO=$B17,IF(S_11FieldRank<=S_11Choice,S_11Amount,0),0))","v":389400},{"$f":"SUM(IF(S_13AccNO=$B17,IF(S_13FieldRank<=S_13Choice,S_13Amount,0),0))","v":18000},{"$f":"SUM(IF(S_14AccNO=$B17,IF(S_14FieldRank<=S_14Choice,S_14Amount,0),0))","v":13500},"Gifts in hand",{"$f":"SUM(IF(S_6AccNO=$B17,IF(S_6FieldRank<=S_6Choice,S_6Amount,0),0))","v":11000},{"$f":"SUM(IF(S_7AccNO=$B17,IF(S_7FieldRank<=S_7Choice,S_7Amount,0),0))","v":0},{"$f":"SUM(IF(S_8AccNO=$B17,IF(S_8FieldRank<=S_8Choice,S_8Amount,0),0))","v":75180},{"$f":"SUM(IF(S_9AccNO=$B17,IF(S_9FieldRank<=S_9Choice,S_9Amount,0),0))","v":0},{"$f":"SUM(IF(S_10AccNO=$B17,IF(S_10FieldRank<=S_10Choice,S_10Amount,0),0))","v":0},{"$f":"SUM(IF(S_12AccNO=$B17,IF(S_12FieldRank<=S_12Choice,S_12Amount,0),0))","v":0}]
[null,410,"Canadian Gifts-Staff",1130975,1020475,{"$f":"SUM(IF(S1AccNO=B18,IF(S1FieldRank<=S1Choice,S1Amount,0),0))","v":679030},{"$f":"SUM(IF(S_2AccNO=$B18,IF(S_2FieldRank<=S_2Choice,S_2Amount,0),0))","v":0},{"$f":"SUM(IF(S_3AccNO=$B18,IF(S_3FieldRank<=S_3Choice,S_3Amount,0),0))","v":59840},{"$f":"SUM(IF(S_4AccNO=$B18,IF(S_4FieldRank<=S_4Choice,S_4Amount,0),0))","v":79975},{"$f":"SUM(IF(S_5AccNO=$B18,IF(S_5FieldRank<=S_5Choice,S_5Amount,0),0))","v":0},{"$f":"SUM(IF(S_11AccNO=$B18,IF(S_11FieldRank<=S_11Choice,S_11Amount,0),0))","v":0},{"$f":"SUM(IF(S_13AccNO=$B18,IF(S_13FieldRank<=S_13Choice,S_13Amount,0),0))","v":0},{"$f":"SUM(IF(S_14AccNO=$B18,IF(S_14FieldRank<=S_14Choice,S_14Amount,0),0))","v":0},"Canadian Gifts-Staff",{"$f":"SUM(IF(S_6AccNO=$B18,IF(S_6FieldRank<=S_6Choice,S_6Amount,0),0))","v":31015},{"$f":"SUM(IF(S_7AccNO=$B18,IF(S_7FieldRank<=S_7Choice,S_7Amount,0),0))","v":115000},{"$f":"SUM(IF(S_8AccNO=$B18,IF(S_8FieldRank<=S_8Choice,S_8Amount,0),0))","v":16700},{"$f":"SUM(IF(S_9AccNO=$B18,IF(S_9FieldRank<=S_9Choice,S_9Amount,0),0))","v":38915},{"$f":"SUM(IF(S_10AccNO=$B18,IF(S_10FieldRank<=S_10Choice,S_10Amount,0),0))","v":0},{"$f":"SUM(IF(S_12AccNO=$B18,IF(S_12FieldRank<=S_12Choice,S_12Amount,0),0))","v":0}]
[5001,430,"US Gifts",747495,739565,{"$f":"SUM(IF(S1AccNO=B19,IF(S1FieldRank<=S1Choice,S1Amount,0),0))","v":555235},{"$f":"SUM(IF(S_2AccNO=$B19,IF(S_2FieldRank<=S_2Choice,S_2Amount,0),0))","v":0},{"$f":"SUM(IF(S_3AccNO=$B19,IF(S_3FieldRank<=S_3Choice,S_3Amount,0),0))","v":49560},{"$f":"SUM(IF(S_4AccNO=$B19,IF(S_4FieldRank<=S_4Choice,S_4Amount,0),0))","v":21250},{"$f":"SUM(IF(S_5AccNO=$B19,IF(S_5FieldRank<=S_5Choice,S_5Amount,0),0))","v":0},{"$f":"SUM(IF(S_11AccNO=$B19,IF(S_11FieldRank<=S_11Choice,S_11Amount,0),0))","v":0},{"$f":"SUM(IF(S_13AccNO=$B19,IF(S_13FieldRank<=S_13Choice,S_13Amount,0),0))","v":0},{"$f":"SUM(IF(S_14AccNO=$B19,IF(S_14FieldRank<=S_14Choice,S_14Amount,0),0))","v":0},"US Gifts",{"$f":"SUM(IF(S_6AccNO=$B19,IF(S_6FieldRank<=S_6Choice,S_6Amount,0),0))","v":49750},{"$f":"SUM(IF(S_7AccNO=$B19,IF(S_7FieldRank<=S_7Choice,S_7Amount,0),0))","v":0},{"$f":"SUM(IF(S_8AccNO=$B19,IF(S_8FieldRank<=S_8Choice,S_8Amount,0),0))","v":16520},{"$f":"SUM(IF(S_9AccNO=$B19,IF(S_9FieldRank<=S_9Choice,S_9Amount,0),0))","v":47250},{"$f":"SUM(IF(S_10AccNO=$B19,IF(S_10FieldRank<=S_10Choice,S_10Amount,0),0))","v":0},{"$f":"SUM(IF(S_12AccNO=$B19,IF(S_12FieldRank<=S_12Choice,S_12Amount,0),0))","v":0}]
[null,440,"Project Income - CND Ind",284460,210060,{"$f":"SUM(IF(S1AccNO=B20,IF(S1FieldRank<=S1Choice,S1Amount,0),0))","v":4500},{"$f":"SUM(IF(S_2AccNO=$B20,IF(S_2FieldRank<=S_2Choice,S_2Amount,0),0))","v":0},{"$f":"SUM(IF(S_3AccNO=$B20,IF(S_3FieldRank<=S_3Choice,S_3Amount,0),0))","v":1400},{"$f":"SUM(IF(S_4AccNO=$B20,IF(S_4FieldRank<=S_4Choice,S_4Amount,0),0))","v":7260},{"$f":"SUM(IF(S_5AccNO=$B20,IF(S_5FieldRank<=S_5Choice,S_5Amount,0),0))","v":7500},{"$f":"SUM(IF(S_11AccNO=$B20,IF(S_11FieldRank<=S_11Choice,S_11Amount,0),0))","v":117000},{"$f":"SUM(IF(S_13AccNO=$B20,IF(S_13FieldRank<=S_13Choice,S_13Amount,0),0))","v":3000},{"$f":"SUM(IF(S_14AccNO=$B20,IF(S_14FieldRank<=S_14Choice,S_14Amount,0),0))","v":1600},"Project Income - CND Ind",{"$f":"SUM(IF(S_6AccNO=$B20,IF(S_6FieldRank<=S_6Choice,S_6Amount,0),0))","v":600},{"$f":"SUM(IF(S_7AccNO=$B20,IF(S_7FieldRank<=S_7Choice,S_7Amount,0),0))","v":0},{"$f":"SUM(IF(S_8AccNO=$B20,IF(S_8FieldRank<=S_8Choice,S_8Amount,0),0))","v":1200},{"$f":"SUM(IF(S_9AccNO=$B20,IF(S_9FieldRank<=S_9Choice,S_9Amount,0),0))","v":65000},{"$f":"SUM(IF(S_10AccNO=$B20,IF(S_10FieldRank<=S_10Choice,S_10Amount,0),0))","v":1000},{"$f":"SUM(IF(S_12AccNO=$B20,IF(S_12FieldRank<=S_12Choice,S_12Amount,0),0))","v":0}]
[null,441,"Project Income - CDN Churches",291467,234900,{"$f":"SUM(IF(S1AccNO=B21,IF(S1FieldRank<=S1Choice,S1Amount,0),0))","v":5000},{"$f":"SUM(IF(S_2AccNO=$B21,IF(S_2FieldRank<=S_2Choice,S_2Amount,0),0))","v":13500},{"$f":"SUM(IF(S_3AccNO=$B21,IF(S_3FieldRank<=S_3Choice,S_3Amount,0),0))","v":800},{"$f":"SUM(IF(S_4AccNO=$B21,IF(S_4FieldRank<=S_4Choice,S_4Amount,0),0))","v":0},{"$f":"SUM(IF(S_5AccNO=$B21,IF(S_5FieldRank<=S_5Choice,S_5Amount,0),0))","v":7700},{"$f":"SUM(IF(S_11AccNO=$B21,IF(S_11FieldRank<=S_11Choice,S_11Amount,0),0))","v":187000},{"$f":"SUM(IF(S_13AccNO=$B21,IF(S_13FieldRank<=S_13Choice,S_13Amount,0),0))","v":3000},{"$f":"SUM(IF(S_14AccNO=$B21,IF(S_14FieldRank<=S_14Choice,S_14Amount,0),0))","v":1600},"Project Income - CDN Churches",{"$f":"SUM(IF(S_6AccNO=$B21,IF(S_6FieldRank<=S_6Choice,S_6Amount,0),0))","v":300},{"$f":"SUM(IF(S_7AccNO=$B21,IF(S_7FieldRank<=S_7Choice,S_7Amount,0),0))","v":0},{"$f":"SUM(IF(S_8AccNO=$B21,IF(S_8FieldRank<=S_8Choice,S_8Amount,0),0))","v":0},{"$f":"SUM(IF(S_9AccNO=$B21,IF(S_9FieldRank<=S_9Choice,S_9Amount,0),0))","v":15000},{"$f":"SUM(IF(S_10AccNO=$B21,IF(S_10FieldRank<=S_10Choice,S_10Amount,0),0))","v":1000},{"$f":"SUM(IF(S_12AccNO=$B21,IF(S_12FieldRank<=S_12Choice,S_12Amount,0),0))","v":0}]
[null,442,"Project Income - US",53975,13600,{"$f":"SUM(IF(S1AccNO=B22,IF(S1FieldRank<=S1Choice,S1Amount,0),0))","v":0},{"$f":"SUM(IF(S_2AccNO=$B22,IF(S_2FieldRank<=S_2Choice,S_2Amount,0),0))","v":0},{"$f":"SUM(IF(S_3AccNO=$B22,IF(S_3FieldRank<=S_3Choice,S_3Amount,0),0))","v":0},{"$f":"SUM(IF(S_4AccNO=$B22,IF(S_4FieldRank<=S_4Choice,S_4Amount,0),0))","v":0},{"$f":"SUM(IF(S_5AccNO=$B22,IF(S_5FieldRank<=S_5Choice,S_5Amount,0),0))","v":0},{"$f":"SUM(IF(S_11AccNO=$B22,IF(S_11FieldRank<=S_11Choice,S_11Amount,0),0))","v":2000},{"$f":"SUM(IF(S_13AccNO=$B22,IF(S_13FieldRank<=S_13Choice,S_13Amount,0),0))","v":0},{"$f":"SUM(IF(S_14AccNO=$B22,IF(S_14FieldRank<=S_14Choice,S_14Amount,0),0))","v":1600},"Project Income - US",{"$f":"SUM(IF(S_6AccNO=$B22,IF(S_6FieldRank<=S_6Choice,S_6Amount,0),0))","v":0},{"$f":"SUM(IF(S_7AccNO=$B22,IF(S_7FieldRank<=S_7Choice,S_7Amount,0),0))","v":0},{"$f":"SUM(IF(S_8AccNO=$B22,IF(S_8FieldRank<=S_8Choice,S_8Amount,0),0))","v":0},{"$f":"SUM(IF(S_9AccNO=$B22,IF(S_9FieldRank<=S_9Choice,S_9Amount,0),0))","v":10000},{"$f":"SUM(IF(S_10AccNO=$B22,IF(S_10FieldRank<=S_10Choice,S_10Amount,0),0))","v":0},{"$f":"SUM(IF(S_12AccNO=$B22,IF(S_12FieldRank<=S_12Choice,S_12Amount,0),0))","v":0}]
[6200,445,"Tuition Income",50,50,{"$f":"SUM(IF(S1AccNO=B23,IF(S1FieldRank<=S1Choice,S1Amount,0),0))","v":0},{"$f":"SUM(IF(S_2AccNO=$B23,IF(S_2FieldRank<=S_2Choice,S_2Amount,0),0))","v":0},{"$f":"SUM(IF(S_3AccNO=$B23,IF(S_3FieldRank<=S_3Choice,S_3Amount,0),0))","v":0},{"$f":"SUM(IF(S_4AccNO=$B23,IF(S_4FieldRank<=S_4Choice,S_4Amount,0),0))","v":0},{"$f":"SUM(IF(S_5AccNO=$B23,IF(S_5FieldRank<=S_5Choice,S_5Amount,0),0))","v":0},{"$f":"SUM(IF(S_11AccNO=$B23,IF(S_11FieldRank<=S_11Choice,S_11Amount,0),0))","v":0},{"$f":"SUM(IF(S_13AccNO=$B23,IF(S_13FieldRank<=S_13Choice,S_13Amount,0),0))","v":0},{"$f":"SUM(IF(S_14AccNO=$B23,IF(S_14FieldRank<=S_14Choice,S_14Amount,0),0))","v":0},"Tuition Income",{"$f":"SUM(IF(S_6AccNO=$B23,IF(S_6FieldRank<=S_6Choice,S_6Amount,0),0))","v":50},{"$f":"SUM(IF(S_7AccNO=$B23,IF(S_7FieldRank<=S_7Choice,S_7Amount,0),0))","v":0},{"$f":"SUM(IF(S_8AccNO=$B23,IF(S_8FieldRank<=S_8Choice,S_8Amount,0),0))","v":0},{"$f":"SUM(IF(S_9AccNO=$B23,IF(S_9FieldRank<=S_9Choice,S_9Amount,0),0))","v":0},{"$f":"SUM(IF(S_10AccNO=$B23,IF(S_10FieldRank<=S_10Choice,S_10Amount,0),0))","v":0},{"$f":"SUM(IF(S_12AccNO=$B23,IF(S_12FieldRank<=S_12Choice,S_12Amount,0),0))","v":0}]
[6500,450,"Interest Income",400,400,{"$f":"SUM(IF(S1AccNO=B24,IF(S1FieldRank<=S1Choice,S1Amount,0),0))","v":0},{"$f":"SUM(IF(S_2AccNO=$B24,IF(S_2FieldRank<=S_2Choice,S_2Amount,0),0))","v":0},{"$f":"SUM(IF(S_3AccNO=$B24,IF(S_3FieldRank<=S_3Choice,S_3Amount,0),0))","v":0},{"$f":"SUM(IF(S_4AccNO=$B24,IF(S_4FieldRank<=S_4Choice,S_4Amount,0),0))","v":0},{"$f":"SUM(IF(S_5AccNO=$B24,IF(S_5FieldRank<=S_5Choice,S_5Amount,0),0))","v":0},{"$f":"SUM(IF(S_11AccNO=$B24,IF(S_11FieldRank<=S_11Choice,S_11Amount,0),0))","v":0},{"$f":"SUM(IF(S_13AccNO=$B24,IF(S_13FieldRank<=S_13Choice,S_13Amount,0),0))","v":0},{"$f":"SUM(IF(S_14AccNO=$B24,IF(S_14FieldRank<=S_14Choice,S_14Amount,0),0))","v":0},"Interest Income",{"$f":"SUM(IF(S_6AccNO=$B24,IF(S_6FieldRank<=S_6Choice,S_6Amount,0),0))","v":0},{"$f":"SUM(IF(S_7AccNO=$B24,IF(S_7FieldRank<=S_7Choice,S_7Amount,0),0))","v":0},{"$f":"SUM(IF(S_8AccNO=$B24,IF(S_8FieldRank<=S_8Choice,S_8Amount,0),0))","v":0},{"$f":"SUM(IF(S_9AccNO=$B24,IF(S_9FieldRank<=S_9Choice,S_9Amount,0),0))","v":400},{"$f":"SUM(IF(S_10AccNO=$B24,IF(S_10FieldRank<=S_10Choice,S_10Amount,0),0))","v":0},{"$f":"SUM(IF(S_12AccNO=$B24,IF(S_12FieldRank<=S_12Choice,S_12Amount,0),0))","v":0}]
[null,460,"Sales",90200,90700,{"$f":"SUM(IF(S1AccNO=B25,IF(S1FieldRank<=S1Choice,S1Amount,0),0))","v":0},{"$f":"SUM(IF(S_2AccNO=$B25,IF(S_2FieldRank<=S_2Choice,S_2Amount,0),0))","v":0},{"$f":"SUM(IF(S_3AccNO=$B25,IF(S_3FieldRank<=S_3Choice,S_3Amount,0),0))","v":0},{"$f":"SUM(IF(S_4AccNO=$B25,IF(S_4FieldRank<=S_4Choice,S_4Amount,0),0))","v":0},{"$f":"SUM(IF(S_5AccNO=$B25,IF(S_5FieldRank<=S_5Choice,S_5Amount,0),0))","v":0},{"$f":"SUM(IF(S_11AccNO=$B25,IF(S_11FieldRank<=S_11Choice,S_11Amount,0),0))","v":0},{"$f":"SUM(IF(S_13AccNO=$B25,IF(S_13FieldRank<=S_13Choice,S_13Amount,0),0))","v":0},{"$f":"SUM(IF(S_14AccNO=$B25,IF(S_14FieldRank<=S_14Choice,S_14Amount,0),0))","v":90000},"Sales",{"$f":"SUM(IF(S_6AccNO=$B25,IF(S_6FieldRank<=S_6Choice,S_6Amount,0),0))","v":700},{"$f":"SUM(IF(S_7AccNO=$B25,IF(S_7FieldRank<=S_7Choice,S_7Amount,0),0))","v":0},{"$f":"SUM(IF(S_8AccNO=$B25,IF(S_8FieldRank<=S_8Choice,S_8Amount,0),0))","v":0},{"$f":"SUM(IF(S_9AccNO=$B25,IF(S_9FieldRank<=S_9Choice,S_9Amount,0),0))","v":0},{"$f":"SUM(IF(S_10AccNO=$B25,IF(S_10FieldRank<=S_10Choice,S_10Amount,0),0))","v":0},{"$f":"SUM(IF(S_12AccNO=$B25,IF(S_12FieldRank<=S_12Choice,S_12Amount,0),0))","v":0}]
[6900,455,"Other income",259050,233925,{"$f":"SUM(IF(S1AccNO=B26,IF(S1FieldRank<=S1Choice,S1Amount,0),0))","v":31125},{"$f":"SUM(IF(S_2AccNO=$B26,IF(S_2FieldRank<=S_2Choice,S_2Amount,0),0))","v":0},{"$f":"SUM(IF(S_3AccNO=$B26,IF(S_3FieldRank<=S_3Choice,S_3Amount,0),0))","v":0},{"$f":"SUM(IF(S_4AccNO=$B26,IF(S_4FieldRank<=S_4Choice,S_4Amount,0),0))","v":0},{"$f":"SUM(IF(S_5AccNO=$B26,IF(S_5FieldRank<=S_5Choice,S_5Amount,0),0))","v":0},{"$f":"SUM(IF(S_11AccNO=$B26,IF(S_11FieldRank<=S_11Choice,S_11Amount,0),0))","v":195000},{"$f":"SUM(IF(S_13AccNO=$B26,IF(S_13FieldRank<=S_13Choice,S_13Amount,0),0))","v":0},{"$f":"SUM(IF(S_14AccNO=$B26,IF(S_14FieldRank<=S_14Choice,S_14Amount,0),0))","v":800},"Other income",{"$f":"SUM(IF(S_6AccNO=$B26,IF(S_6FieldRank<=S_6Choice,S_6Amount,0),0))","v":0},{"$f":"SUM(IF(S_7AccNO=$B26,IF(S_7FieldRank<=S_7Choice,S_7Amount,0),0))","v":0},{"$f":"SUM(IF(S_8AccNO=$B26,IF(S_8FieldRank<=S_8Choice,S_8Amount,0),0))","v":0},{"$f":"SUM(IF(S_9AccNO=$B26,IF(S_9FieldRank<=S_9Choice,S_9Amount,0),0))","v":7000},{"$f":"SUM(IF(S_10AccNO=$B26,IF(S_10FieldRank<=S_10Choice,S_10Amount,0),0))","v":0},{"$f":"SUM(IF(S_12AccNO=$B26,IF(S_12FieldRank<=S_12Choice,S_12Amount,0),0))","v":0}]
[null,484,"Operations Assessment",0.5,0,{"$f":"SUM(IF(S1AccNO=B27,IF(S1FieldRank<=S1Choice,S1Amount,0),0))","v":-114449.5},{"$f":"SUM(IF(S_2AccNO=$B27,IF(S_2FieldRank<=S_2Choice,S_2Amount,0),0))","v":-1350},{"$f":"SUM(IF(S_3AccNO=$B27,IF(S_3FieldRank<=S_3Choice,S_3Amount,0),0))","v":-9040},{"$f":"SUM(IF(S_4AccNO=$B27,IF(S_4FieldRank<=S_4Choice,S_4Amount,0),0))","v":-10906},{"$f":"SUM(IF(S_5AccNO=$B27,IF(S_5FieldRank<=S_5Choice,S_5Amount,0),0))","v":-152},{"$f":"SUM(IF(S_11AccNO=$B27,IF(S_11FieldRank<=S_11Choice,S_11Amount,0),0))","v":-30600},{"$f":"SUM(IF(S_13AccNO=$B27,IF(S_13FieldRank<=S_13Choice,S_13Amount,0),0))","v":-600},{"$f":"SUM(IF(S_14AccNO=$B27,IF(S_14FieldRank<=S_14Choice,S_14Amount,0),0))","v":-480},"Operations Assessment",{"$f":"SUM(IF(S_6AccNO=$B27,IF(S_6FieldRank<=S_6Choice,S_6Amount,0),0))","v":-5534},{"$f":"SUM(IF(S_7AccNO=$B27,IF(S_7FieldRank<=S_7Choice,S_7Amount,0),0))","v":0},{"$f":"SUM(IF(S_8AccNO=$B27,IF(S_8FieldRank<=S_8Choice,S_8Amount,0),0))","v":-3442},{"$f":"SUM(IF(S_9AccNO=$B27,IF(S_9FieldRank<=S_9Choice,S_9Amount,0),0))","v":176753.5},{"$f":"SUM(IF(S_10AccNO=$B27,IF(S_10FieldRank<=S_10Choice,S_10Amount,0),0))","v":-200},{"$f":"SUM(IF(S_12AccNO=$B27,IF(S_12FieldRank<=S_12Choice,S_12Amount,0),0))","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IF(S_11AccNO=$B28,IF(S_11FieldRank<=S_11Choice,S_11Amount,0),0))","v":0},null,{"$f":"SUM(IF(S_14AccNO=$B28,IF(S_14FieldRank<=S_14Choice,S_14Amount,0),0))","v":0}]
[8608,503,"Advertising",2390,{"$f":"SUM(F29:T29)","v":2800},{"$f":"SUM(IF(S1AccNO=B29,IF(S1FieldRank<=S1Choice,S1Amount,0),0))","v":0},{"$f":"SUM(IF(S_2AccNO=$B29,IF(S_2FieldRank<=S_2Choice,S_2Amount,0),0))","v":0},{"$f":"SUM(IF(S_3AccNO=$B29,IF(S_3FieldRank<=S_3Choice,S_3Amount,0),0))","v":0},{"$f":"SUM(IF(S_4AccNO=$B29,IF(S_4FieldRank<=S_4Choice,S_4Amount,0),0))","v":0},{"$f":"SUM(IF(S_5AccNO=$B29,IF(S_5FieldRank<=S_5Choice,S_5Amount,0),0))","v":100},{"$f":"SUM(IF(S_11AccNO=$B29,IF(S_11FieldRank<=S_11Choice,S_11Amount,0),0))","v":2600},{"$f":"SUM(IF(S_13AccNO=$B29,IF(S_13FieldRank<=S_13Choice,S_13Amount,0),0))","v":0},{"$f":"SUM(IF(S_14AccNO=$B29,IF(S_14FieldRank<=S_14Choice,S_14Amount,0),0))","v":0},{"$f":"C29","v":"Advertising"},{"$f":"SUM(IF(S_6AccNO=$B29,IF(S_6FieldRank<=S_6Choice,S_6Amount,0),0))","v":0},{"$f":"SUM(IF(S_7AccNO=$B29,IF(S_7FieldRank<=S_7Choice,S_7Amount,0),0))","v":0},{"$f":"SUM(IF(S_8AccNO=$B29,IF(S_8FieldRank<=S_8Choice,S_8Amount,0),0))","v":0},{"$f":"SUM(IF(S_9AccNO=$B29,IF(S_9FieldRank<=S_9Choice,S_9Amount,0),0))","v":0},{"$f":"SUM(IF(S_10AccNO=$B29,IF(S_10FieldRank<=S_10Choice,S_10Amount,0),0))","v":100},{"$f":"SUM(IF(S_12AccNO=$B29,IF(S_12FieldRank<=S_12Choice,S_12Amount,0),0))","v":0}]
[8975,508,"Depreciation Expense",0,0,{"$f":"SUM(IF(S1AccNO=B30,IF(S1FieldRank<=S1Choice,S1Amount,0),0))","v":0},{"$f":"SUM(IF(S_2AccNO=$B30,IF(S_2FieldRank<=S_2Choice,S_2Amount,0),0))","v":0},{"$f":"SUM(IF(S_3AccNO=$B30,IF(S_3FieldRank<=S_3Choice,S_3Amount,0),0))","v":0},{"$f":"SUM(IF(S_4AccNO=$B30,IF(S_4FieldRank<=S_4Choice,S_4Amount,0),0))","v":0},{"$f":"SUM(IF(S_5AccNO=$B30,IF(S_5FieldRank<=S_5Choice,S_5Amount,0),0))","v":0},{"$f":"SUM(IF(S_11AccNO=$B30,IF(S_11FieldRank<=S_11Choice,S_11Amount,0),0))","v":0},{"$f":"SUM(IF(S_13AccNO=$B30,IF(S_13FieldRank<=S_13Choice,S_13Amount,0),0))","v":0},{"$f":"SUM(IF(S_14AccNO=$B30,IF(S_14FieldRank<=S_14Choice,S_14Amount,0),0))","v":0},"Depreciation Expense",{"$f":"SUM(IF(S_6AccNO=$B30,IF(S_6FieldRank<=S_6Choice,S_6Amount,0),0))","v":0},{"$f":"SUM(IF(S_7AccNO=$B30,IF(S_7FieldRank<=S_7Choice,S_7Amount,0),0))","v":0},{"$f":"SUM(IF(S_8AccNO=$B30,IF(S_8FieldRank<=S_8Choice,S_8Amount,0),0))","v":0},{"$f":"SUM(IF(S_9AccNO=$B30,IF(S_9FieldRank<=S_9Choice,S_9Amount,0),0))","v":0},{"$f":"SUM(IF(S_10AccNO=$B30,IF(S_10FieldRank<=S_10Choice,S_10Amount,0),0))","v":0},{"$f":"SUM(IF(S_12AccNO=$B30,IF(S_12FieldRank<=S_12Choice,S_12Amount,0),0))","v":0}]
[8510,511,"Small Equip. Purchase",15600,14200,{"$f":"SUM(IF(S1AccNO=B31,IF(S1FieldRank<=S1Choice,S1Amount,0),0))","v":0},{"$f":"SUM(IF(S_2AccNO=$B31,IF(S_2FieldRank<=S_2Choice,S_2Amount,0),0))","v":0},{"$f":"SUM(IF(S_3AccNO=$B31,IF(S_3FieldRank<=S_3Choice,S_3Amount,0),0))","v":0},{"$f":"SUM(IF(S_4AccNO=$B31,IF(S_4FieldRank<=S_4Choice,S_4Amount,0),0))","v":0},{"$f":"SUM(IF(S_5AccNO=$B31,IF(S_5FieldRank<=S_5Choice,S_5Amount,0),0))","v":0},{"$f":"SUM(IF(S_11AccNO=$B31,IF(S_11FieldRank<=S_11Choice,S_11Amount,0),0))","v":3200},{"$f":"SUM(IF(S_13AccNO=$B31,IF(S_13FieldRank<=S_13Choice,S_13Amount,0),0))","v":0},{"$f":"SUM(IF(S_14AccNO=$B31,IF(S_14FieldRank<=S_14Choice,S_14Amount,0),0))","v":0},"Small Equip. Purchase",{"$f":"SUM(IF(S_6AccNO=$B31,IF(S_6FieldRank<=S_6Choice,S_6Amount,0),0))","v":0},{"$f":"SUM(IF(S_7AccNO=$B31,IF(S_7FieldRank<=S_7Choice,S_7Amount,0),0))","v":0},{"$f":"SUM(IF(S_8AccNO=$B31,IF(S_8FieldRank<=S_8Choice,S_8Amount,0),0))","v":0},{"$f":"SUM(IF(S_9AccNO=$B31,IF(S_9FieldRank<=S_9Choice,S_9Amount,0),0))","v":11000},{"$f":"SUM(IF(S_10AccNO=$B31,IF(S_10FieldRank<=S_10Choice,S_10Amount,0),0))","v":0},{"$f":"SUM(IF(S_12AccNO=$B31,IF(S_12FieldRank<=S_12Choice,S_12Amount,0),0))","v":0}]
[8803,515,"Food for Outreach/Meetings",28765,44314,{"$f":"SUM(IF(S1AccNO=B32,IF(S1FieldRank<=S1Choice,S1Amount,0),0))","v":0},{"$f":"SUM(IF(S_2AccNO=$B32,IF(S_2FieldRank<=S_2Choice,S_2Amount,0),0))","v":0},{"$f":"SUM(IF(S_3AccNO=$B32,IF(S_3FieldRank<=S_3Choice,S_3Amount,0),0))","v":0},{"$f":"SUM(IF(S_4AccNO=$B32,IF(S_4FieldRank<=S_4Choice,S_4Amount,0),0))","v":0},{"$f":"SUM(IF(S_5AccNO=$B32,IF(S_5FieldRank<=S_5Choice,S_5Amount,0),0))","v":1964},{"$f":"SUM(IF(S_11AccNO=$B32,IF(S_11FieldRank<=S_11Choice,S_11Amount,0),0))","v":39000},{"$f":"SUM(IF(S_13AccNO=$B32,IF(S_13FieldRank<=S_13Choice,S_13Amount,0),0))","v":0},{"$f":"SUM(IF(S_14AccNO=$B32,IF(S_14FieldRank<=S_14Choice,S_14Amount,0),0))","v":0},"Food for Outreach/Meetings",{"$f":"SUM(IF(S_6AccNO=$B32,IF(S_6FieldRank<=S_6Choice,S_6Amount,0),0))","v":0},{"$f":"SUM(IF(S_7AccNO=$B32,IF(S_7FieldRank<=S_7Choice,S_7Amount,0),0))","v":0},{"$f":"SUM(IF(S_8AccNO=$B32,IF(S_8FieldRank<=S_8Choice,S_8Amount,0),0))","v":900},{"$f":"SUM(IF(S_9AccNO=$B32,IF(S_9FieldRank<=S_9Choice,S_9Amount,0),0))","v":2350},{"$f":"SUM(IF(S_10AccNO=$B32,IF(S_10FieldRank<=S_10Choice,S_10Amount,0),0))","v":100},{"$f":"SUM(IF(S_12AccNO=$B32,IF(S_12FieldRank<=S_12Choice,S_12Amount,0),0))","v":0}]
[8951,517,"Gifts to Affiliated Org.",288490,124800,{"$f":"SUM(IF(S1AccNO=B33,IF(S1FieldRank<=S1Choice,S1Amount,0),0))","v":0},{"$f":"SUM(IF(S_2AccNO=$B33,IF(S_2FieldRank<=S_2Choice,S_2Amount,0),0))","v":0},{"$f":"SUM(IF(S_3AccNO=$B33,IF(S_3FieldRank<=S_3Choice,S_3Amount,0),0))","v":0},{"$f":"SUM(IF(S_4AccNO=$B33,IF(S_4FieldRank<=S_4Choice,S_4Amount,0),0))","v":0},{"$f":"SUM(IF(S_5AccNO=$B33,IF(S_5FieldRank<=S_5Choice,S_5Amount,0),0))","v":0},{"$f":"SUM(IF(S_11AccNO=$B33,IF(S_11FieldRank<=S_11Choice,S_11Amount,0),0))","v":0},{"$f":"SUM(IF(S_13AccNO=$B33,IF(S_13FieldRank<=S_13Choice,S_13Amount,0),0))","v":0},{"$f":"SUM(IF(S_14AccNO=$B33,IF(S_14FieldRank<=S_14Choice,S_14Amount,0),0))","v":0},"Gifts to Affiliated Org.",{"$f":"SUM(IF(S_6AccNO=$B33,IF(S_6FieldRank<=S_6Choice,S_6Amount,0),0))","v":0},{"$f":"SUM(IF(S_7AccNO=$B33,IF(S_7FieldRank<=S_7Choice,S_7Amount,0),0))","v":115000},{"$f":"SUM(IF(S_8AccNO=$B33,IF(S_8FieldRank<=S_8Choice,S_8Amount,0),0))","v":0},{"$f":"SUM(IF(S_9AccNO=$B33,IF(S_9FieldRank<=S_9Choice,S_9Amount,0),0))","v":0},{"$f":"SUM(IF(S_10AccNO=$B33,IF(S_10FieldRank<=S_10Choice,S_10Amount,0),0))","v":9800},{"$f":"SUM(IF(S_12AccNO=$B33,IF(S_12FieldRank<=S_12Choice,S_12Amount,0),0))","v":0}]
[8403,519,"Bldg, Equip & Liab. Ins.",32745,31465,{"$f":"SUM(IF(S1AccNO=B34,IF(S1FieldRank<=S1Choice,S1Amount,0),0))","v":1500},{"$f":"SUM(IF(S_2AccNO=$B34,IF(S_2FieldRank<=S_2Choice,S_2Amount,0),0))","v":150},{"$f":"SUM(IF(S_3AccNO=$B34,IF(S_3FieldRank<=S_3Choice,S_3Amount,0),0))","v":0},{"$f":"SUM(IF(S_4AccNO=$B34,IF(S_4FieldRank<=S_4Choice,S_4Amount,0),0))","v":0},{"$f":"SUM(IF(S_5AccNO=$B34,IF(S_5FieldRank<=S_5Choice,S_5Amount,0),0))","v":2575},{"$f":"SUM(IF(S_11AccNO=$B34,IF(S_11FieldRank<=S_11Choice,S_11Amount,0),0))","v":17000},{"$f":"SUM(IF(S_13AccNO=$B34,IF(S_13FieldRank<=S_13Choice,S_13Amount,0),0))","v":750},{"$f":"SUM(IF(S_14AccNO=$B34,IF(S_14FieldRank<=S_14Choice,S_14Amount,0),0))","v":2440},"Bldg, Equip & Liab. Ins.",{"$f":"SUM(IF(S_6AccNO=$B34,IF(S_6FieldRank<=S_6Choice,S_6Amount,0),0))","v":0},{"$f":"SUM(IF(S_7AccNO=$B34,IF(S_7FieldRank<=S_7Choice,S_7Amount,0),0))","v":0},{"$f":"SUM(IF(S_8AccNO=$B34,IF(S_8FieldRank<=S_8Choice,S_8Amount,0),0))","v":0},{"$f":"SUM(IF(S_9AccNO=$B34,IF(S_9FieldRank<=S_9Choice,S_9Amount,0),0))","v":7050},{"$f":"SUM(IF(S_10AccNO=$B34,IF(S_10FieldRank<=S_10Choice,S_10Amount,0),0))","v":0},{"$f":"SUM(IF(S_12AccNO=$B34,IF(S_12FieldRank<=S_12Choice,S_12Amount,0),0))","v":0}]
[8008,521,"Audit & Legal Fees",15300,15300,{"$f":"SUM(IF(S1AccNO=B35,IF(S1FieldRank<=S1Choice,S1Amount,0),0))","v":0},{"$f":"SUM(IF(S_2AccNO=$B35,IF(S_2FieldRank<=S_2Choice,S_2Amount,0),0))","v":0},{"$f":"SUM(IF(S_3AccNO=$B35,IF(S_3FieldRank<=S_3Choice,S_3Amount,0),0))","v":0},{"$f":"SUM(IF(S_4AccNO=$B35,IF(S_4FieldRank<=S_4Choice,S_4Amount,0),0))","v":0},{"$f":"SUM(IF(S_5AccNO=$B35,IF(S_5FieldRank<=S_5Choice,S_5Amount,0),0))","v":0},{"$f":"SUM(IF(S_11AccNO=$B35,IF(S_11FieldRank<=S_11Choice,S_11Amount,0),0))","v":0},{"$f":"SUM(IF(S_13AccNO=$B35,IF(S_13FieldRank<=S_13Choice,S_13Amount,0),0))","v":0},{"$f":"SUM(IF(S_14AccNO=$B35,IF(S_14FieldRank<=S_14Choice,S_14Amount,0),0))","v":0},"Audit & Legal Fees",{"$f":"SUM(IF(S_6AccNO=$B35,IF(S_6FieldRank<=S_6Choice,S_6Amount,0),0))","v":0},{"$f":"SUM(IF(S_7AccNO=$B35,IF(S_7FieldRank<=S_7Choice,S_7Amount,0),0))","v":0},{"$f":"SUM(IF(S_8AccNO=$B35,IF(S_8FieldRank<=S_8Choice,S_8Amount,0),0))","v":0},{"$f":"SUM(IF(S_9AccNO=$B35,IF(S_9FieldRank<=S_9Choice,S_9Amount,0),0))","v":15000},{"$f":"SUM(IF(S_10AccNO=$B35,IF(S_10FieldRank<=S_10Choice,S_10Amount,0),0))","v":300},{"$f":"SUM(IF(S_12AccNO=$B35,IF(S_12FieldRank<=S_12Choice,S_12Amount,0),0))","v":0}]
[8606,523,"Subscription & Perd.",0,0,{"$f":"SUM(IF(S1AccNO=B36,IF(S1FieldRank<=S1Choice,S1Amount,0),0))","v":0},{"$f":"SUM(IF(S_2AccNO=$B36,IF(S_2FieldRank<=S_2Choice,S_2Amount,0),0))","v":0},{"$f":"SUM(IF(S_3AccNO=$B36,IF(S_3FieldRank<=S_3Choice,S_3Amount,0),0))","v":0},{"$f":"SUM(IF(S_4AccNO=$B36,IF(S_4FieldRank<=S_4Choice,S_4Amount,0),0))","v":0},{"$f":"SUM(IF(S_5AccNO=$B36,IF(S_5FieldRank<=S_5Choice,S_5Amount,0),0))","v":0},{"$f":"SUM(IF(S_11AccNO=$B36,IF(S_11FieldRank<=S_11Choice,S_11Amount,0),0))","v":0},{"$f":"SUM(IF(S_13AccNO=$B36,IF(S_13FieldRank<=S_13Choice,S_13Amount,0),0))","v":0},{"$f":"SUM(IF(S_14AccNO=$B36,IF(S_14FieldRank<=S_14Choice,S_14Amount,0),0))","v":0},"Subscription & Perd.",{"$f":"SUM(IF(S_6AccNO=$B36,IF(S_6FieldRank<=S_6Choice,S_6Amount,0),0))","v":0},{"$f":"SUM(IF(S_7AccNO=$B36,IF(S_7FieldRank<=S_7Choice,S_7Amount,0),0))","v":0},{"$f":"SUM(IF(S_8AccNO=$B36,IF(S_8FieldRank<=S_8Choice,S_8Amount,0),0))","v":0},{"$f":"SUM(IF(S_9AccNO=$B36,IF(S_9FieldRank<=S_9Choice,S_9Amount,0),0))","v":0},{"$f":"SUM(IF(S_10AccNO=$B36,IF(S_10FieldRank<=S_10Choice,S_10Amount,0),0))","v":0},{"$f":"SUM(IF(S_12AccNO=$B36,IF(S_12FieldRank<=S_12Choice,S_12Amount,0),0))","v":0}]
[8413,525,"Bldg. Maint.",8300,6800,{"$f":"SUM(IF(S1AccNO=B37,IF(S1FieldRank<=S1Choice,S1Amount,0),0))","v":0},{"$f":"SUM(IF(S_2AccNO=$B37,IF(S_2FieldRank<=S_2Choice,S_2Amount,0),0))","v":0},{"$f":"SUM(IF(S_3AccNO=$B37,IF(S_3FieldRank<=S_3Choice,S_3Amount,0),0))","v":0},{"$f":"SUM(IF(S_4AccNO=$B37,IF(S_4FieldRank<=S_4Choice,S_4Amount,0),0))","v":0},{"$f":"SUM(IF(S_5AccNO=$B37,IF(S_5FieldRank<=S_5Choice,S_5Amount,0),0))","v":0},{"$f":"SUM(IF(S_11AccNO=$B37,IF(S_11FieldRank<=S_11Choice,S_11Amount,0),0))","v":4000},{"$f":"SUM(IF(S_13AccNO=$B37,IF(S_13FieldRank<=S_13Choice,S_13Amount,0),0))","v":0},{"$f":"SUM(IF(S_14AccNO=$B37,IF(S_14FieldRank<=S_14Choice,S_14Amount,0),0))","v":0},"Bldg. Maint.",{"$f":"SUM(IF(S_6AccNO=$B37,IF(S_6FieldRank<=S_6Choice,S_6Amount,0),0))","v":0},{"$f":"SUM(IF(S_7AccNO=$B37,IF(S_7FieldRank<=S_7Choice,S_7Amount,0),0))","v":0},{"$f":"SUM(IF(S_8AccNO=$B37,IF(S_8FieldRank<=S_8Choice,S_8Amount,0),0))","v":0},{"$f":"SUM(IF(S_9AccNO=$B37,IF(S_9FieldRank<=S_9Choice,S_9Amount,0),0))","v":2800},{"$f":"SUM(IF(S_10AccNO=$B37,IF(S_10FieldRank<=S_10Choice,S_10Amount,0),0))","v":0},{"$f":"SUM(IF(S_12AccNO=$B37,IF(S_12FieldRank<=S_12Choice,S_12Amount,0),0))","v":0}]
[8502,527,"Equip. Maint.",7770,8470,{"$f":"SUM(IF(S1AccNO=B38,IF(S1FieldRank<=S1Choice,S1Amount,0),0))","v":0},{"$f":"SUM(IF(S_2AccNO=$B38,IF(S_2FieldRank<=S_2Choice,S_2Amount,0),0))","v":70},{"$f":"SUM(IF(S_3AccNO=$B38,IF(S_3FieldRank<=S_3Choice,S_3Amount,0),0))","v":0},{"$f":"SUM(IF(S_4AccNO=$B38,IF(S_4FieldRank<=S_4Choice,S_4Amount,0),0))","v":0},{"$f":"SUM(IF(S_5AccNO=$B38,IF(S_5FieldRank<=S_5Choice,S_5Amount,0),0))","v":0},{"$f":"SUM(IF(S_11AccNO=$B38,IF(S_11FieldRank<=S_11Choice,S_11Amount,0),0))","v":2000},{"$f":"SUM(IF(S_13AccNO=$B38,IF(S_13FieldRank<=S_13Choice,S_13Amount,0),0))","v":0},{"$f":"SUM(IF(S_14AccNO=$B38,IF(S_14FieldRank<=S_14Choice,S_14Amount,0),0))","v":0},"Equip. Maint.",{"$f":"SUM(IF(S_6AccNO=$B38,IF(S_6FieldRank<=S_6Choice,S_6Amount,0),0))","v":400},{"$f":"SUM(IF(S_7AccNO=$B38,IF(S_7FieldRank<=S_7Choice,S_7Amount,0),0))","v":0},{"$f":"SUM(IF(S_8AccNO=$B38,IF(S_8FieldRank<=S_8Choice,S_8Amount,0),0))","v":0},{"$f":"SUM(IF(S_9AccNO=$B38,IF(S_9FieldRank<=S_9Choice,S_9Amount,0),0))","v":6000},{"$f":"SUM(IF(S_10AccNO=$B38,IF(S_10FieldRank<=S_10Choice,S_10Amount,0),0))","v":0},{"$f":"SUM(IF(S_12AccNO=$B38,IF(S_12FieldRank<=S_12Choice,S_12Amount,0),0))","v":0}]
[8941,529,"Banking Charges",10200,1600,{"$f":"SUM(IF(S1AccNO=B39,IF(S1FieldRank<=S1Choice,S1Amount,0),0))","v":0},{"$f":"SUM(IF(S_2AccNO=$B39,IF(S_2FieldRank<=S_2Choice,S_2Amount,0),0))","v":0},{"$f":"SUM(IF(S_3AccNO=$B39,IF(S_3FieldRank<=S_3Choice,S_3Amount,0),0))","v":0},{"$f":"SUM(IF(S_4AccNO=$B39,IF(S_4FieldRank<=S_4Choice,S_4Amount,0),0))","v":0},{"$f":"SUM(IF(S_5AccNO=$B39,IF(S_5FieldRank<=S_5Choice,S_5Amount,0),0))","v":0},{"$f":"SUM(IF(S_11AccNO=$B39,IF(S_11FieldRank<=S_11Choice,S_11Amount,0),0))","v":250},{"$f":"SUM(IF(S_13AccNO=$B39,IF(S_13FieldRank<=S_13Choice,S_13Amount,0),0))","v":0},{"$f":"SUM(IF(S_14AccNO=$B39,IF(S_14FieldRank<=S_14Choice,S_14Amount,0),0))","v":0},"Banking Charges",{"$f":"SUM(IF(S_6AccNO=$B39,IF(S_6FieldRank<=S_6Choice,S_6Amount,0),0))","v":0},{"$f":"SUM(IF(S_7AccNO=$B39,IF(S_7FieldRank<=S_7Choice,S_7Amount,0),0))","v":0},{"$f":"SUM(IF(S_8AccNO=$B39,IF(S_8FieldRank<=S_8Choice,S_8Amount,0),0))","v":0},{"$f":"SUM(IF(S_9AccNO=$B39,IF(S_9FieldRank<=S_9Choice,S_9Amount,0),0))","v":1350},{"$f":"SUM(IF(S_10AccNO=$B39,IF(S_10FieldRank<=S_10Choice,S_10Amount,0),0))","v":0},{"$f":"SUM(IF(S_12AccNO=$B39,IF(S_12FieldRank<=S_12Choice,S_12Amount,0),0))","v":0}]
[8902,530,"Royalties/Fees",8725,6615,{"$f":"SUM(IF(S1AccNO=B40,IF(S1FieldRank<=S1Choice,S1Amount,0),0))","v":50},{"$f":"SUM(IF(S_2AccNO=$B40,IF(S_2FieldRank<=S_2Choice,S_2Amount,0),0))","v":280},{"$f":"SUM(IF(S_3AccNO=$B40,IF(S_3FieldRank<=S_3Choice,S_3Amount,0),0))","v":0},{"$f":"SUM(IF(S_4AccNO=$B40,IF(S_4FieldRank<=S_4Choice,S_4Amount,0),0))","v":0},{"$f":"SUM(IF(S_5AccNO=$B40,IF(S_5FieldRank<=S_5Choice,S_5Amount,0),0))","v":2685},{"$f":"SUM(IF(S_11AccNO=$B40,IF(S_11FieldRank<=S_11Choice,S_11Amount,0),0))","v":200},{"$f":"SUM(IF(S_13AccNO=$B40,IF(S_13FieldRank<=S_13Choice,S_13Amount,0),0))","v":0},{"$f":"SUM(IF(S_14AccNO=$B40,IF(S_14FieldRank<=S_14Choice,S_14Amount,0),0))","v":0},"Royalties/Fees",{"$f":"SUM(IF(S_6AccNO=$B40,IF(S_6FieldRank<=S_6Choice,S_6Amount,0),0))","v":150},{"$f":"SUM(IF(S_7AccNO=$B40,IF(S_7FieldRank<=S_7Choice,S_7Amount,0),0))","v":0},{"$f":"SUM(IF(S_8AccNO=$B40,IF(S_8FieldRank<=S_8Choice,S_8Amount,0),0))","v":0},{"$f":"SUM(IF(S_9AccNO=$B40,IF(S_9FieldRank<=S_9Choice,S_9Amount,0),0))","v":3150},{"$f":"SUM(IF(S_10AccNO=$B40,IF(S_10FieldRank<=S_10Choice,S_10Amount,0),0))","v":100},{"$f":"SUM(IF(S_12AccNO=$B40,IF(S_12FieldRank<=S_12Choice,S_12Amount,0),0))","v":0}]
[8940,531,"Moving Expense",0,0,{"$f":"SUM(IF(S1AccNO=B41,IF(S1FieldRank<=S1Choice,S1Amount,0),0))","v":0},{"$f":"SUM(IF(S_2AccNO=$B41,IF(S_2FieldRank<=S_2Choice,S_2Amount,0),0))","v":0},{"$f":"SUM(IF(S_3AccNO=$B41,IF(S_3FieldRank<=S_3Choice,S_3Amount,0),0))","v":0},{"$f":"SUM(IF(S_4AccNO=$B41,IF(S_4FieldRank<=S_4Choice,S_4Amount,0),0))","v":0},{"$f":"SUM(IF(S_5AccNO=$B41,IF(S_5FieldRank<=S_5Choice,S_5Amount,0),0))","v":0},{"$f":"SUM(IF(S_11AccNO=$B41,IF(S_11FieldRank<=S_11Choice,S_11Amount,0),0))","v":0},{"$f":"SUM(IF(S_13AccNO=$B41,IF(S_13FieldRank<=S_13Choice,S_13Amount,0),0))","v":0},{"$f":"SUM(IF(S_14AccNO=$B41,IF(S_14FieldRank<=S_14Choice,S_14Amount,0),0))","v":0},"Moving Expense",{"$f":"SUM(IF(S_6AccNO=$B41,IF(S_6FieldRank<=S_6Choice,S_6Amount,0),0))","v":0},{"$f":"SUM(IF(S_7AccNO=$B41,IF(S_7FieldRank<=S_7Choice,S_7Amount,0),0))","v":0},{"$f":"SUM(IF(S_8AccNO=$B41,IF(S_8FieldRank<=S_8Choice,S_8Amount,0),0))","v":0},{"$f":"SUM(IF(S_9AccNO=$B41,IF(S_9FieldRank<=S_9Choice,S_9Amount,0),0))","v":0},{"$f":"SUM(IF(S_10AccNO=$B41,IF(S_10FieldRank<=S_10Choice,S_10Amount,0),0))","v":0},{"$f":"SUM(IF(S_12AccNO=$B41,IF(S_12FieldRank<=S_12Choice,S_12Amount,0),0))","v":0}]
[8106,532,"Office Supply",4300,3350,{"$f":"SUM(IF(S1AccNO=B42,IF(S1FieldRank<=S1Choice,S1Amount,0),0))","v":0},{"$f":"SUM(IF(S_2AccNO=$B42,IF(S_2FieldRank<=S_2Choice,S_2Amount,0),0))","v":0},{"$f":"SUM(IF(S_3AccNO=$B42,IF(S_3FieldRank<=S_3Choice,S_3Amount,0),0))","v":0},{"$f":"SUM(IF(S_4AccNO=$B42,IF(S_4FieldRank<=S_4Choice,S_4Amount,0),0))","v":0},{"$f":"SUM(IF(S_5AccNO=$B42,IF(S_5FieldRank<=S_5Choice,S_5Amount,0),0))","v":50},{"$f":"SUM(IF(S_11AccNO=$B42,IF(S_11FieldRank<=S_11Choice,S_11Amount,0),0))","v":1000},{"$f":"SUM(IF(S_13AccNO=$B42,IF(S_13FieldRank<=S_13Choice,S_13Amount,0),0))","v":0},{"$f":"SUM(IF(S_14AccNO=$B42,IF(S_14FieldRank<=S_14Choice,S_14Amount,0),0))","v":0},"Office Supply",{"$f":"SUM(IF(S_6AccNO=$B42,IF(S_6FieldRank<=S_6Choice,S_6Amount,0),0))","v":600},{"$f":"SUM(IF(S_7AccNO=$B42,IF(S_7FieldRank<=S_7Choice,S_7Amount,0),0))","v":0},{"$f":"SUM(IF(S_8AccNO=$B42,IF(S_8FieldRank<=S_8Choice,S_8Amount,0),0))","v":0},{"$f":"SUM(IF(S_9AccNO=$B42,IF(S_9FieldRank<=S_9Choice,S_9Amount,0),0))","v":1700},{"$f":"SUM(IF(S_10AccNO=$B42,IF(S_10FieldRank<=S_10Choice,S_10Amount,0),0))","v":0},{"$f":"SUM(IF(S_12AccNO=$B42,IF(S_12FieldRank<=S_12Choice,S_12Amount,0),0))","v":0}]
[8301,533,"Postage & Parcels",23370,{"$f":"SUM(F43:T43)","v":24400},{"$f":"SUM(IF(S1AccNO=B43,IF(S1FieldRank<=S1Choice,S1Amount,0),0))","v":0},{"$f":"SUM(IF(S_2AccNO=$B43,IF(S_2FieldRank<=S_2Choice,S_2Amount,0),0))","v":0},{"$f":"SUM(IF(S_3AccNO=$B43,IF(S_3FieldRank<=S_3Choice,S_3Amount,0),0))","v":0},{"$f":"SUM(IF(S_4AccNO=$B43,IF(S_4FieldRank<=S_4Choice,S_4Amount,0),0))","v":0},{"$f":"SUM(IF(S_5AccNO=$B43,IF(S_5FieldRank<=S_5Choice,S_5Amount,0),0))","v":0},{"$f":"SUM(IF(S_11AccNO=$B43,IF(S_11FieldRank<=S_11Choice,S_11Amount,0),0))","v":1350},{"$f":"SUM(IF(S_13AccNO=$B43,IF(S_13FieldRank<=S_13Choice,S_13Amount,0),0))","v":0},{"$f":"SUM(IF(S_14AccNO=$B43,IF(S_14FieldRank<=S_14Choice,S_14Amount,0),0))","v":0},"Postage & Parcels",{"$f":"SUM(IF(S_6AccNO=$B43,IF(S_6FieldRank<=S_6Choice,S_6Amount,0),0))","v":450},{"$f":"SUM(IF(S_7AccNO=$B43,IF(S_7FieldRank<=S_7Choice,S_7Amount,0),0))","v":0},{"$f":"SUM(IF(S_8AccNO=$B43,IF(S_8FieldRank<=S_8Choice,S_8Amount,0),0))","v":0},{"$f":"SUM(IF(S_9AccNO=$B43,IF(S_9FieldRank<=S_9Choice,S_9Amount,0),0))","v":2500},{"$f":"SUM(IF(S_10AccNO=$B43,IF(S_10FieldRank<=S_10Choice,S_10Amount,0),0))","v":100},{"$f":"SUM(IF(S_12AccNO=$B43,IF(S_12FieldRank<=S_12Choice,S_12Amount,0),0))","v":20000}]
[8803,537,"Staff Training",16795,16920,{"$f":"SUM(IF(S1AccNO=B44,IF(S1FieldRank<=S1Choice,S1Amount,0),0))","v":540},{"$f":"SUM(IF(S_2AccNO=$B44,IF(S_2FieldRank<=S_2Choice,S_2Amount,0),0))","v":900},{"$f":"SUM(IF(S_3AccNO=$B44,IF(S_3FieldRank<=S_3Choice,S_3Amount,0),0))","v":60},{"$f":"SUM(IF(S_4AccNO=$B44,IF(S_4FieldRank<=S_4Choice,S_4Amount,0),0))","v":120},{"$f":"SUM(IF(S_5AccNO=$B44,IF(S_5FieldRank<=S_5Choice,S_5Amount,0),0))","v":0},{"$f":"SUM(IF(S_11AccNO=$B44,IF(S_11FieldRank<=S_11Choice,S_11Amount,0),0))","v":800},{"$f":"SUM(IF(S_13AccNO=$B44,IF(S_13FieldRank<=S_13Choice,S_13Amount,0),0))","v":0},{"$f":"SUM(IF(S_14AccNO=$B44,IF(S_14FieldRank<=S_14Choice,S_14Amount,0),0))","v":0},"Staff Training",{"$f":"SUM(IF(S_6AccNO=$B44,IF(S_6FieldRank<=S_6Choice,S_6Amount,0),0))","v":40},{"$f":"SUM(IF(S_7AccNO=$B44,IF(S_7FieldRank<=S_7Choice,S_7Amount,0),0))","v":0},{"$f":"SUM(IF(S_8AccNO=$B44,IF(S_8FieldRank<=S_8Choice,S_8Amount,0),0))","v":12000},{"$f":"SUM(IF(S_9AccNO=$B44,IF(S_9FieldRank<=S_9Choice,S_9Amount,0),0))","v":2330},{"$f":"SUM(IF(S_10AccNO=$B44,IF(S_10FieldRank<=S_10Choice,S_10Amount,0),0))","v":130},{"$f":"SUM(IF(S_12AccNO=$B44,IF(S_12FieldRank<=S_12Choice,S_12Amount,0),0))","v":0}]
[8806,538,"Seminars & Registration",1050,950,{"$f":"SUM(IF(S1AccNO=B45,IF(S1FieldRank<=S1Choice,S1Amount,0),0))","v":0},{"$f":"SUM(IF(S_2AccNO=$B45,IF(S_2FieldRank<=S_2Choice,S_2Amount,0),0))","v":0},{"$f":"SUM(IF(S_3AccNO=$B45,IF(S_3FieldRank<=S_3Choice,S_3Amount,0),0))","v":0},{"$f":"SUM(IF(S_4AccNO=$B45,IF(S_4FieldRank<=S_4Choice,S_4Amount,0),0))","v":0},{"$f":"SUM(IF(S_5AccNO=$B45,IF(S_5FieldRank<=S_5Choice,S_5Amount,0),0))","v":0},{"$f":"SUM(IF(S_11AccNO=$B45,IF(S_11FieldRank<=S_11Choice,S_11Amount,0),0))","v":0},{"$f":"SUM(IF(S_13AccNO=$B45,IF(S_13FieldRank<=S_13Choice,S_13Amount,0),0))","v":0},{"$f":"SUM(IF(S_14AccNO=$B45,IF(S_14FieldRank<=S_14Choice,S_14Amount,0),0))","v":0},"Seminars & Registration",{"$f":"SUM(IF(S_6AccNO=$B45,IF(S_6FieldRank<=S_6Choice,S_6Amount,0),0))","v":100},{"$f":"SUM(IF(S_7AccNO=$B45,IF(S_7FieldRank<=S_7Choice,S_7Amount,0),0))","v":0},{"$f":"SUM(IF(S_8AccNO=$B45,IF(S_8FieldRank<=S_8Choice,S_8Amount,0),0))","v":0},{"$f":"SUM(IF(S_9AccNO=$B45,IF(S_9FieldRank<=S_9Choice,S_9Amount,0),0))","v":850},{"$f":"SUM(IF(S_10AccNO=$B45,IF(S_10FieldRank<=S_10Choice,S_10Amount,0),0))","v":0},{"$f":"SUM(IF(S_12AccNO=$B45,IF(S_12FieldRank<=S_12Choice,S_12Amount,0),0))","v":0}]
[8004,542,"Member Care",2300,2300,{"$f":"SUM(IF(S1AccNO=B46,IF(S1FieldRank<=S1Choice,S1Amount,0),0))","v":0},{"$f":"SUM(IF(S_2AccNO=$B46,IF(S_2FieldRank<=S_2Choice,S_2Amount,0),0))","v":0},{"$f":"SUM(IF(S_3AccNO=$B46,IF(S_3FieldRank<=S_3Choice,S_3Amount,0),0))","v":0},{"$f":"SUM(IF(S_4AccNO=$B46,IF(S_4FieldRank<=S_4Choice,S_4Amount,0),0))","v":0},{"$f":"SUM(IF(S_5AccNO=$B46,IF(S_5FieldRank<=S_5Choice,S_5Amount,0),0))","v":0},{"$f":"SUM(IF(S_11AccNO=$B46,IF(S_11FieldRank<=S_11Choice,S_11Amount,0),0))","v":0},{"$f":"SUM(IF(S_13AccNO=$B46,IF(S_13FieldRank<=S_13Choice,S_13Amount,0),0))","v":0},{"$f":"SUM(IF(S_14AccNO=$B46,IF(S_14FieldRank<=S_14Choice,S_14Amount,0),0))","v":0},"Member Care",{"$f":"SUM(IF(S_6AccNO=$B46,IF(S_6FieldRank<=S_6Choice,S_6Amount,0),0))","v":0},{"$f":"SUM(IF(S_7AccNO=$B46,IF(S_7FieldRank<=S_7Choice,S_7Amount,0),0))","v":0},{"$f":"SUM(IF(S_8AccNO=$B46,IF(S_8FieldRank<=S_8Choice,S_8Amount,0),0))","v":2300},{"$f":"SUM(IF(S_9AccNO=$B46,IF(S_9FieldRank<=S_9Choice,S_9Amount,0),0))","v":0},{"$f":"SUM(IF(S_10AccNO=$B46,IF(S_10FieldRank<=S_10Choice,S_10Amount,0),0))","v":0},{"$f":"SUM(IF(S_12AccNO=$B46,IF(S_12FieldRank<=S_12Choice,S_12Amount,0),0))","v":0}]
[8402,543,"Rent Expense",20625,19700,{"$f":"SUM(IF(S1AccNO=B47,IF(S1FieldRank<=S1Choice,S1Amount,0),0))","v":0},{"$f":"SUM(IF(S_2AccNO=$B47,IF(S_2FieldRank<=S_2Choice,S_2Amount,0),0))","v":0},{"$f":"SUM(IF(S_3AccNO=$B47,IF(S_3FieldRank<=S_3Choice,S_3Amount,0),0))","v":0},{"$f":"SUM(IF(S_4AccNO=$B47,IF(S_4FieldRank<=S_4Choice,S_4Amount,0),0))","v":0},{"$f":"SUM(IF(S_5AccNO=$B47,IF(S_5FieldRank<=S_5Choice,S_5Amount,0),0))","v":0},{"$f":"SUM(IF(S_11AccNO=$B47,IF(S_11FieldRank<=S_11Choice,S_11Amount,0),0))","v":7000},{"$f":"SUM(IF(S_13AccNO=$B47,IF(S_13FieldRank<=S_13Choice,S_13Amount,0),0))","v":0},{"$f":"SUM(IF(S_14AccNO=$B47,IF(S_14FieldRank<=S_14Choice,S_14Amount,0),0))","v":0},"Rent Expense",{"$f":"SUM(IF(S_6AccNO=$B47,IF(S_6FieldRank<=S_6Choice,S_6Amount,0),0))","v":0},{"$f":"SUM(IF(S_7AccNO=$B47,IF(S_7FieldRank<=S_7Choice,S_7Amount,0),0))","v":0},{"$f":"SUM(IF(S_8AccNO=$B47,IF(S_8FieldRank<=S_8Choice,S_8Amount,0),0))","v":0},{"$f":"SUM(IF(S_9AccNO=$B47,IF(S_9FieldRank<=S_9Choice,S_9Amount,0),0))","v":12700},{"$f":"SUM(IF(S_10AccNO=$B47,IF(S_10FieldRank<=S_10Choice,S_10Amount,0),0))","v":0},{"$f":"SUM(IF(S_12AccNO=$B47,IF(S_12FieldRank<=S_12Choice,S_12Amount,0),0))","v":0}]
[8108,545,"General Supply & Service",60575,64380,{"$f":"SUM(IF(S1AccNO=B48,IF(S1FieldRank<=S1Choice,S1Amount,0),0))","v":2150},{"$f":"SUM(IF(S_2AccNO=$B48,IF(S_2FieldRank<=S_2Choice,S_2Amount,0),0))","v":500},{"$f":"SUM(IF(S_3AccNO=$B48,IF(S_3FieldRank<=S_3Choice,S_3Amount,0),0))","v":150},{"$f":"SUM(IF(S_4AccNO=$B48,IF(S_4FieldRank<=S_4Choice,S_4Amount,0),0))","v":0},{"$f":"SUM(IF(S_5AccNO=$B48,IF(S_5FieldRank<=S_5Choice,S_5Amount,0),0))","v":2150},{"$f":"SUM(IF(S_11AccNO=$B48,IF(S_11FieldRank<=S_11Choice,S_11Amount,0),0))","v":14050},{"$f":"SUM(IF(S_13AccNO=$B48,IF(S_13FieldRank<=S_13Choice,S_13Amount,0),0))","v":0},{"$f":"SUM(IF(S_14AccNO=$B48,IF(S_14FieldRank<=S_14Choice,S_14Amount,0),0))","v":44880},"General Supply & Service",{"$f":"SUM(IF(S_6AccNO=$B48,IF(S_6FieldRank<=S_6Choice,S_6Amount,0),0))","v":200},{"$f":"SUM(IF(S_7AccNO=$B48,IF(S_7FieldRank<=S_7Choice,S_7Amount,0),0))","v":0},{"$f":"SUM(IF(S_8AccNO=$B48,IF(S_8FieldRank<=S_8Choice,S_8Amount,0),0))","v":0},{"$f":"SUM(IF(S_9AccNO=$B48,IF(S_9FieldRank<=S_9Choice,S_9Amount,0),0))","v":200},{"$f":"SUM(IF(S_10AccNO=$B48,IF(S_10FieldRank<=S_10Choice,S_10Amount,0),0))","v":100},{"$f":"SUM(IF(S_12AccNO=$B48,IF(S_12FieldRank<=S_12Choice,S_12Amount,0),0))","v":0}]
[8711,546,"Motel/Hotel",22735,16280,{"$f":"SUM(IF(S1AccNO=B49,IF(S1FieldRank<=S1Choice,S1Amount,0),0))","v":750},{"$f":"SUM(IF(S_2AccNO=$B49,IF(S_2FieldRank<=S_2Choice,S_2Amount,0),0))","v":250},{"$f":"SUM(IF(S_3AccNO=$B49,IF(S_3FieldRank<=S_3Choice,S_3Amount,0),0))","v":0},{"$f":"SUM(IF(S_4AccNO=$B49,IF(S_4FieldRank<=S_4Choice,S_4Amount,0),0))","v":250},{"$f":"SUM(IF(S_5AccNO=$B49,IF(S_5FieldRank<=S_5Choice,S_5Amount,0),0))","v":0},{"$f":"SUM(IF(S_11AccNO=$B49,IF(S_11FieldRank<=S_11Choice,S_11Amount,0),0))","v":300},{"$f":"SUM(IF(S_13AccNO=$B49,IF(S_13FieldRank<=S_13Choice,S_13Amount,0),0))","v":0},{"$f":"SUM(IF(S_14AccNO=$B49,IF(S_14FieldRank<=S_14Choice,S_14Amount,0),0))","v":0},"Motel/Hotel",{"$f":"SUM(IF(S_6AccNO=$B49,IF(S_6FieldRank<=S_6Choice,S_6Amount,0),0))","v":500},{"$f":"SUM(IF(S_7AccNO=$B49,IF(S_7FieldRank<=S_7Choice,S_7Amount,0),0))","v":160},{"$f":"SUM(IF(S_8AccNO=$B49,IF(S_8FieldRank<=S_8Choice,S_8Amount,0),0))","v":250},{"$f":"SUM(IF(S_9AccNO=$B49,IF(S_9FieldRank<=S_9Choice,S_9Amount,0),0))","v":8350},{"$f":"SUM(IF(S_10AccNO=$B49,IF(S_10FieldRank<=S_10Choice,S_10Amount,0),0))","v":5470},{"$f":"SUM(IF(S_12AccNO=$B49,IF(S_12FieldRank<=S_12Choice,S_12Amount,0),0))","v":0}]
[8201,547,"Telephone",3980,4200,{"$f":"SUM(IF(S1AccNO=B50,IF(S1FieldRank<=S1Choice,S1Amount,0),0))","v":0},{"$f":"SUM(IF(S_2AccNO=$B50,IF(S_2FieldRank<=S_2Choice,S_2Amount,0),0))","v":0},{"$f":"SUM(IF(S_3AccNO=$B50,IF(S_3FieldRank<=S_3Choice,S_3Amount,0),0))","v":0},{"$f":"SUM(IF(S_4AccNO=$B50,IF(S_4FieldRank<=S_4Choice,S_4Amount,0),0))","v":0},{"$f":"SUM(IF(S_5AccNO=$B50,IF(S_5FieldRank<=S_5Choice,S_5Amount,0),0))","v":0},{"$f":"SUM(IF(S_11AccNO=$B50,IF(S_11FieldRank<=S_11Choice,S_11Amount,0),0))","v":2200},{"$f":"SUM(IF(S_13AccNO=$B50,IF(S_13FieldRank<=S_13Choice,S_13Amount,0),0))","v":0},{"$f":"SUM(IF(S_14AccNO=$B50,IF(S_14FieldRank<=S_14Choice,S_14Amount,0),0))","v":0},"Telephone",{"$f":"SUM(IF(S_6AccNO=$B50,IF(S_6FieldRank<=S_6Choice,S_6Amount,0),0))","v":25},{"$f":"SUM(IF(S_7AccNO=$B50,IF(S_7FieldRank<=S_7Choice,S_7Amount,0),0))","v":0},{"$f":"SUM(IF(S_8AccNO=$B50,IF(S_8FieldRank<=S_8Choice,S_8Amount,0),0))","v":0},{"$f":"SUM(IF(S_9AccNO=$B50,IF(S_9FieldRank<=S_9Choice,S_9Amount,0),0))","v":1975},{"$f":"SUM(IF(S_10AccNO=$B50,IF(S_10FieldRank<=S_10Choice,S_10Amount,0),0))","v":0},{"$f":"SUM(IF(S_12AccNO=$B50,IF(S_12FieldRank<=S_12Choice,S_12Amount,0),0))","v":0}]
[null,548,"Field Director Expense Reimb",0,{"$f":"SUM(F51:T51)","v":0},{"$f":"SUM(IF(S1AccNO=B51,IF(S1FieldRank<=S1Choice,S1Amount,0),0))","v":0},{"$f":"SUM(IF(S_2AccNO=$B51,IF(S_2FieldRank<=S_2Choice,S_2Amount,0),0))","v":0},{"$f":"SUM(IF(S_3AccNO=$B51,IF(S_3FieldRank<=S_3Choice,S_3Amount,0),0))","v":0},{"$f":"SUM(IF(S_4AccNO=$B51,IF(S_4FieldRank<=S_4Choice,S_4Amount,0),0))","v":0},{"$f":"SUM(IF(S_5AccNO=$B51,IF(S_5FieldRank<=S_5Choice,S_5Amount,0),0))","v":0},{"$f":"SUM(IF(S_11AccNO=$B51,IF(S_11FieldRank<=S_11Choice,S_11Amount,0),0))","v":0},{"$f":"SUM(IF(S_13AccNO=$B51,IF(S_13FieldRank<=S_13Choice,S_13Amount,0),0))","v":0},{"$f":"SUM(IF(S_14AccNO=$B51,IF(S_14FieldRank<=S_14Choice,S_14Amount,0),0))","v":0},"Field Director Expense Reimb",{"$f":"SUM(IF(S_6AccNO=$B51,IF(S_6FieldRank<=S_6Choice,S_6Amount,0),0))","v":0},{"$f":"SUM(IF(S_7AccNO=$B51,IF(S_7FieldRank<=S_7Choice,S_7Amount,0),0))","v":0},{"$f":"SUM(IF(S_8AccNO=$B51,IF(S_8FieldRank<=S_8Choice,S_8Amount,0),0))","v":0},{"$f":"SUM(IF(S_9AccNO=$B51,IF(S_9FieldRank<=S_9Choice,S_9Amount,0),0))","v":0},{"$f":"SUM(IF(S_10AccNO=$B51,IF(S_10FieldRank<=S_10Choice,S_10Amount,0),0))","v":0},{"$f":"SUM(IF(S_12AccNO=$B51,IF(S_12FieldRank<=S_12Choice,S_12Amount,0),0))","v":0}]
[8702,549,"Gas & Oil Auto",31880,42240,{"$f":"SUM(IF(S1AccNO=B52,IF(S1FieldRank<=S1Choice,S1Amount,0),0))","v":2725},{"$f":"SUM(IF(S_2AccNO=$B52,IF(S_2FieldRank<=S_2Choice,S_2Amount,0),0))","v":1600},{"$f":"SUM(IF(S_3AccNO=$B52,IF(S_3FieldRank<=S_3Choice,S_3Amount,0),0))","v":0},{"$f":"SUM(IF(S_4AccNO=$B52,IF(S_4FieldRank<=S_4Choice,S_4Amount,0),0))","v":750},{"$f":"SUM(IF(S_5AccNO=$B52,IF(S_5FieldRank<=S_5Choice,S_5Amount,0),0))","v":1840},{"$f":"SUM(IF(S_11AccNO=$B52,IF(S_11FieldRank<=S_11Choice,S_11Amount,0),0))","v":28500},{"$f":"SUM(IF(S_13AccNO=$B52,IF(S_13FieldRank<=S_13Choice,S_13Amount,0),0))","v":0},{"$f":"SUM(IF(S_14AccNO=$B52,IF(S_14FieldRank<=S_14Choice,S_14Amount,0),0))","v":0},"Gas & Oil Auto",{"$f":"SUM(IF(S_6AccNO=$B52,IF(S_6FieldRank<=S_6Choice,S_6Amount,0),0))","v":340},{"$f":"SUM(IF(S_7AccNO=$B52,IF(S_7FieldRank<=S_7Choice,S_7Amount,0),0))","v":500},{"$f":"SUM(IF(S_8AccNO=$B52,IF(S_8FieldRank<=S_8Choice,S_8Amount,0),0))","v":825},{"$f":"SUM(IF(S_9AccNO=$B52,IF(S_9FieldRank<=S_9Choice,S_9Amount,0),0))","v":1850},{"$f":"SUM(IF(S_10AccNO=$B52,IF(S_10FieldRank<=S_10Choice,S_10Amount,0),0))","v":3310},{"$f":"SUM(IF(S_12AccNO=$B52,IF(S_12FieldRank<=S_12Choice,S_12Amount,0),0))","v":0}]
[null,550,"Auto Maintenance",11100,{"$f":"SUM(F53:T53)","v":8600},{"$f":"SUM(IF(S1AccNO=B53,IF(S1FieldRank<=S1Choice,S1Amount,0),0))","v":0},{"$f":"SUM(IF(S_2AccNO=$B53,IF(S_2FieldRank<=S_2Choice,S_2Amount,0),0))","v":0},{"$f":"SUM(IF(S_3AccNO=$B53,IF(S_3FieldRank<=S_3Choice,S_3Amount,0),0))","v":0},{"$f":"SUM(IF(S_4AccNO=$B53,IF(S_4FieldRank<=S_4Choice,S_4Amount,0),0))","v":0},{"$f":"SUM(IF(S_5AccNO=$B53,IF(S_5FieldRank<=S_5Choice,S_5Amount,0),0))","v":5600},{"$f":"SUM(IF(S_11AccNO=$B53,IF(S_11FieldRank<=S_11Choice,S_11Amount,0),0))","v":3000},{"$f":"SUM(IF(S_13AccNO=$B53,IF(S_13FieldRank<=S_13Choice,S_13Amount,0),0))","v":0},{"$f":"SUM(IF(S_14AccNO=$B53,IF(S_14FieldRank<=S_14Choice,S_14Amount,0),0))","v":0},"Auto Maintenance",{"$f":"SUM(IF(S_6AccNO=$B53,IF(S_6FieldRank<=S_6Choice,S_6Amount,0),0))","v":0},{"$f":"SUM(IF(S_7AccNO=$B53,IF(S_7FieldRank<=S_7Choice,S_7Amount,0),0))","v":0},{"$f":"SUM(IF(S_8AccNO=$B53,IF(S_8FieldRank<=S_8Choice,S_8Amount,0),0))","v":0},{"$f":"SUM(IF(S_9AccNO=$B53,IF(S_9FieldRank<=S_9Choice,S_9Amount,0),0))","v":0},{"$f":"SUM(IF(S_10AccNO=$B53,IF(S_10FieldRank<=S_10Choice,S_10Amount,0),0))","v":0},{"$f":"SUM(IF(S_12AccNO=$B53,IF(S_12FieldRank<=S_12Choice,S_12Amount,0),0))","v":0}]
[8710,551,"Commercial Travel",15600,14695,{"$f":"SUM(IF(S1AccNO=B54,IF(S1FieldRank<=S1Choice,S1Amount,0),0))","v":1300},{"$f":"SUM(IF(S_2AccNO=$B54,IF(S_2FieldRank<=S_2Choice,S_2Amount,0),0))","v":600},{"$f":"SUM(IF(S_3AccNO=$B54,IF(S_3FieldRank<=S_3Choice,S_3Amount,0),0))","v":0},{"$f":"SUM(IF(S_4AccNO=$B54,IF(S_4FieldRank<=S_4Choice,S_4Amount,0),0))","v":650},{"$f":"SUM(IF(S_5AccNO=$B54,IF(S_5FieldRank<=S_5Choice,S_5Amount,0),0))","v":0},{"$f":"SUM(IF(S_11AccNO=$B54,IF(S_11FieldRank<=S_11Choice,S_11Amount,0),0))","v":0},{"$f":"SUM(IF(S_13AccNO=$B54,IF(S_13FieldRank<=S_13Choice,S_13Amount,0),0))","v":0},{"$f":"SUM(IF(S_14AccNO=$B54,IF(S_14FieldRank<=S_14Choice,S_14Amount,0),0))","v":0},"Commercial Travel",{"$f":"SUM(IF(S_6AccNO=$B54,IF(S_6FieldRank<=S_6Choice,S_6Amount,0),0))","v":0},{"$f":"SUM(IF(S_7AccNO=$B54,IF(S_7FieldRank<=S_7Choice,S_7Amount,0),0))","v":0},{"$f":"SUM(IF(S_8AccNO=$B54,IF(S_8FieldRank<=S_8Choice,S_8Amount,0),0))","v":4500},{"$f":"SUM(IF(S_9AccNO=$B54,IF(S_9FieldRank<=S_9Choice,S_9Amount,0),0))","v":6600},{"$f":"SUM(IF(S_10AccNO=$B54,IF(S_10FieldRank<=S_10Choice,S_10Amount,0),0))","v":1045},{"$f":"SUM(IF(S_12AccNO=$B54,IF(S_12FieldRank<=S_12Choice,S_12Amount,0),0))","v":0}]
[8709,553,"Meal & Entertainment",6918,8280,{"$f":"SUM(IF(S1AccNO=B55,IF(S1FieldRank<=S1Choice,S1Amount,0),0))","v":1760},{"$f":"SUM(IF(S_2AccNO=$B55,IF(S_2FieldRank<=S_2Choice,S_2Amount,0),0))","v":5600},{"$f":"SUM(IF(S_3AccNO=$B55,IF(S_3FieldRank<=S_3Choice,S_3Amount,0),0))","v":0},{"$f":"SUM(IF(S_4AccNO=$B55,IF(S_4FieldRank<=S_4Choice,S_4Amount,0),0))","v":0},{"$f":"SUM(IF(S_5AccNO=$B55,IF(S_5FieldRank<=S_5Choice,S_5Amount,0),0))","v":0},{"$f":"SUM(IF(S_11AccNO=$B55,IF(S_11FieldRank<=S_11Choice,S_11Amount,0),0))","v":0},{"$f":"SUM(IF(S_13AccNO=$B55,IF(S_13FieldRank<=S_13Choice,S_13Amount,0),0))","v":0},{"$f":"SUM(IF(S_14AccNO=$B55,IF(S_14FieldRank<=S_14Choice,S_14Amount,0),0))","v":0},"Meal & Entertainment",{"$f":"SUM(IF(S_6AccNO=$B55,IF(S_6FieldRank<=S_6Choice,S_6Amount,0),0))","v":0},{"$f":"SUM(IF(S_7AccNO=$B55,IF(S_7FieldRank<=S_7Choice,S_7Amount,0),0))","v":0},{"$f":"SUM(IF(S_8AccNO=$B55,IF(S_8FieldRank<=S_8Choice,S_8Amount,0),0))","v":0},{"$f":"SUM(IF(S_9AccNO=$B55,IF(S_9FieldRank<=S_9Choice,S_9Amount,0),0))","v":500},{"$f":"SUM(IF(S_10AccNO=$B55,IF(S_10FieldRank<=S_10Choice,S_10Amount,0),0))","v":420},{"$f":"SUM(IF(S_12AccNO=$B55,IF(S_12FieldRank<=S_12Choice,S_12Amount,0),0))","v":0}]
[8805,557,"Missionary Conference",46750,42350,{"$f":"SUM(IF(S1AccNO=B56,IF(S1FieldRank<=S1Choice,S1Amount,0),0))","v":0},{"$f":"SUM(IF(S_2AccNO=$B56,IF(S_2FieldRank<=S_2Choice,S_2Amount,0),0))","v":0},{"$f":"SUM(IF(S_3AccNO=$B56,IF(S_3FieldRank<=S_3Choice,S_3Amount,0),0))","v":0},{"$f":"SUM(IF(S_4AccNO=$B56,IF(S_4FieldRank<=S_4Choice,S_4Amount,0),0))","v":0},{"$f":"SUM(IF(S_5AccNO=$B56,IF(S_5FieldRank<=S_5Choice,S_5Amount,0),0))","v":0},{"$f":"SUM(IF(S_11AccNO=$B56,IF(S_11FieldRank<=S_11Choice,S_11Amount,0),0))","v":0},{"$f":"SUM(IF(S_13AccNO=$B56,IF(S_13FieldRank<=S_13Choice,S_13Amount,0),0))","v":0},{"$f":"SUM(IF(S_14AccNO=$B56,IF(S_14FieldRank<=S_14Choice,S_14Amount,0),0))","v":0},"Missionary Conference",{"$f":"SUM(IF(S_6AccNO=$B56,IF(S_6FieldRank<=S_6Choice,S_6Amount,0),0))","v":0},{"$f":"SUM(IF(S_7AccNO=$B56,IF(S_7FieldRank<=S_7Choice,S_7Amount,0),0))","v":0},{"$f":"SUM(IF(S_8AccNO=$B56,IF(S_8FieldRank<=S_8Choice,S_8Amount,0),0))","v":42350},{"$f":"SUM(IF(S_9AccNO=$B56,IF(S_9FieldRank<=S_9Choice,S_9Amount,0),0))","v":0},{"$f":"SUM(IF(S_10AccNO=$B56,IF(S_10FieldRank<=S_10Choice,S_10Amount,0),0))","v":0},{"$f":"SUM(IF(S_12AccNO=$B56,IF(S_12FieldRank<=S_12Choice,S_12Amount,0),0))","v":0}]
[8804,559,"Speaker Honorarium",3570,5900,{"$f":"SUM(IF(S1AccNO=B57,IF(S1FieldRank<=S1Choice,S1Amount,0),0))","v":3400},{"$f":"SUM(IF(S_2AccNO=$B57,IF(S_2FieldRank<=S_2Choice,S_2Amount,0),0))","v":0},{"$f":"SUM(IF(S_3AccNO=$B57,IF(S_3FieldRank<=S_3Choice,S_3Amount,0),0))","v":0},{"$f":"SUM(IF(S_4AccNO=$B57,IF(S_4FieldRank<=S_4Choice,S_4Amount,0),0))","v":0},{"$f":"SUM(IF(S_5AccNO=$B57,IF(S_5FieldRank<=S_5Choice,S_5Amount,0),0))","v":0},{"$f":"SUM(IF(S_11AccNO=$B57,IF(S_11FieldRank<=S_11Choice,S_11Amount,0),0))","v":2500},{"$f":"SUM(IF(S_13AccNO=$B57,IF(S_13FieldRank<=S_13Choice,S_13Amount,0),0))","v":0},{"$f":"SUM(IF(S_14AccNO=$B57,IF(S_14FieldRank<=S_14Choice,S_14Amount,0),0))","v":0},"Speaker Honorarium",{"$f":"SUM(IF(S_6AccNO=$B57,IF(S_6FieldRank<=S_6Choice,S_6Amount,0),0))","v":0},{"$f":"SUM(IF(S_7AccNO=$B57,IF(S_7FieldRank<=S_7Choice,S_7Amount,0),0))","v":0},{"$f":"SUM(IF(S_8AccNO=$B57,IF(S_8FieldRank<=S_8Choice,S_8Amount,0),0))","v":0},{"$f":"SUM(IF(S_9AccNO=$B57,IF(S_9FieldRank<=S_9Choice,S_9Amount,0),0))","v":0},{"$f":"SUM(IF(S_10AccNO=$B57,IF(S_10FieldRank<=S_10Choice,S_10Amount,0),0))","v":0},{"$f":"SUM(IF(S_12AccNO=$B57,IF(S_12FieldRank<=S_12Choice,S_12Amount,0),0))","v":0}]
[8707,563,"Auto Reimbursement",11860,15625,{"$f":"SUM(IF(S1AccNO=B58,IF(S1FieldRank<=S1Choice,S1Amount,0),0))","v":350},{"$f":"SUM(IF(S_2AccNO=$B58,IF(S_2FieldRank<=S_2Choice,S_2Amount,0),0))","v":300},{"$f":"SUM(IF(S_3AccNO=$B58,IF(S_3FieldRank<=S_3Choice,S_3Amount,0),0))","v":0},{"$f":"SUM(IF(S_4AccNO=$B58,IF(S_4FieldRank<=S_4Choice,S_4Amount,0),0))","v":250},{"$f":"SUM(IF(S_5AccNO=$B58,IF(S_5FieldRank<=S_5Choice,S_5Amount,0),0))","v":8735},{"$f":"SUM(IF(S_11AccNO=$B58,IF(S_11FieldRank<=S_11Choice,S_11Amount,0),0))","v":5500},{"$f":"SUM(IF(S_13AccNO=$B58,IF(S_13FieldRank<=S_13Choice,S_13Amount,0),0))","v":0},{"$f":"SUM(IF(S_14AccNO=$B58,IF(S_14FieldRank<=S_14Choice,S_14Amount,0),0))","v":0},"Auto Reimbursement",{"$f":"SUM(IF(S_6AccNO=$B58,IF(S_6FieldRank<=S_6Choice,S_6Amount,0),0))","v":0},{"$f":"SUM(IF(S_7AccNO=$B58,IF(S_7FieldRank<=S_7Choice,S_7Amount,0),0))","v":0},{"$f":"SUM(IF(S_8AccNO=$B58,IF(S_8FieldRank<=S_8Choice,S_8Amount,0),0))","v":0},{"$f":"SUM(IF(S_9AccNO=$B58,IF(S_9FieldRank<=S_9Choice,S_9Amount,0),0))","v":490},{"$f":"SUM(IF(S_10AccNO=$B58,IF(S_10FieldRank<=S_10Choice,S_10Amount,0),0))","v":0},{"$f":"SUM(IF(S_12AccNO=$B58,IF(S_12FieldRank<=S_12Choice,S_12Amount,0),0))","v":0}]
[8999,580,"Special Projects",770177,597580,{"$f":"SUM(IF(S1AccNO=B59,IF(S1FieldRank<=S1Choice,S1Amount,0),0))","v":34025},{"$f":"SUM(IF(S_2AccNO=$B59,IF(S_2FieldRank<=S_2Choice,S_2Amount,0),0))","v":1500},{"$f":"SUM(IF(S_3AccNO=$B59,IF(S_3FieldRank<=S_3Choice,S_3Amount,0),0))","v":1800},{"$f":"SUM(IF(S_4AccNO=$B59,IF(S_4FieldRank<=S_4Choice,S_4Amount,0),0))","v":18175},{"$f":"SUM(IF(S_5AccNO=$B59,IF(S_5FieldRank<=S_5Choice,S_5Amount,0),0))","v":2550},{"$f":"SUM(IF(S_11AccNO=$B59,IF(S_11FieldRank<=S_11Choice,S_11Amount,0),0))","v":510600},{"$f":"SUM(IF(S_13AccNO=$B59,IF(S_13FieldRank<=S_13Choice,S_13Amount,0),0))","v":10700},{"$f":"SUM(IF(S_14AccNO=$B59,IF(S_14FieldRank<=S_14Choice,S_14Amount,0),0))","v":4200},"Special Projects",{"$f":"SUM(IF(S_6AccNO=$B59,IF(S_6FieldRank<=S_6Choice,S_6Amount,0),0))","v":0},{"$f":"SUM(IF(S_7AccNO=$B59,IF(S_7FieldRank<=S_7Choice,S_7Amount,0),0))","v":500},{"$f":"SUM(IF(S_8AccNO=$B59,IF(S_8FieldRank<=S_8Choice,S_8Amount,0),0))","v":11680},{"$f":"SUM(IF(S_9AccNO=$B59,IF(S_9FieldRank<=S_9Choice,S_9Amount,0),0))","v":750},{"$f":"SUM(IF(S_10AccNO=$B59,IF(S_10FieldRank<=S_10Choice,S_10Amount,0),0))","v":1100},{"$f":"SUM(IF(S_12AccNO=$B59,IF(S_12FieldRank<=S_12Choice,S_12Amount,0),0))","v":0}]
[null,585,"Canada Pension Plan",3814,3531,{"$f":"SUM(IF(S1AccNO=B60,IF(S1FieldRank<=S1Choice,S1Amount,0),0))","v":0},{"$f":"SUM(IF(S_2AccNO=$B60,IF(S_2FieldRank<=S_2Choice,S_2Amount,0),0))","v":0},{"$f":"SUM(IF(S_3AccNO=$B60,IF(S_3FieldRank<=S_3Choice,S_3Amount,0),0))","v":0},{"$f":"SUM(IF(S_4AccNO=$B60,IF(S_4FieldRank<=S_4Choice,S_4Amount,0),0))","v":0},{"$f":"SUM(IF(S_5AccNO=$B60,IF(S_5FieldRank<=S_5Choice,S_5Amount,0),0))","v":0},{"$f":"SUM(IF(S_11AccNO=$B60,IF(S_11FieldRank<=S_11Choice,S_11Amount,0),0))","v":0},{"$f":"SUM(IF(S_13AccNO=$B60,IF(S_13FieldRank<=S_13Choice,S_13Amount,0),0))","v":0},{"$f":"SUM(IF(S_14AccNO=$B60,IF(S_14FieldRank<=S_14Choice,S_14Amount,0),0))","v":0},"Canada Pension Plan",{"$f":"SUM(IF(S_6AccNO=$B60,IF(S_6FieldRank<=S_6Choice,S_6Amount,0),0))","v":0},{"$f":"SUM(IF(S_7AccNO=$B60,IF(S_7FieldRank<=S_7Choice,S_7Amount,0),0))","v":0},{"$f":"SUM(IF(S_8AccNO=$B60,IF(S_8FieldRank<=S_8Choice,S_8Amount,0),0))","v":0},{"$f":"SUM(IF(S_9AccNO=$B60,IF(S_9FieldRank<=S_9Choice,S_9Amount,0),0))","v":3531},{"$f":"SUM(IF(S_10AccNO=$B60,IF(S_10FieldRank<=S_10Choice,S_10Amount,0),0))","v":0},{"$f":"SUM(IF(S_12AccNO=$B60,IF(S_12FieldRank<=S_12Choice,S_12Amount,0),0))","v":0}]
[null,586,"Employment Insurance",31622,29525,{"$f":"SUM(IF(S1AccNO=B61,IF(S1FieldRank<=S1Choice,S1Amount,0),0))","v":0},{"$f":"SUM(IF(S_2AccNO=$B61,IF(S_2FieldRank<=S_2Choice,S_2Amount,0),0))","v":0},{"$f":"SUM(IF(S_3AccNO=$B61,IF(S_3FieldRank<=S_3Choice,S_3Amount,0),0))","v":0},{"$f":"SUM(IF(S_4AccNO=$B61,IF(S_4FieldRank<=S_4Choice,S_4Amount,0),0))","v":0},{"$f":"SUM(IF(S_5AccNO=$B61,IF(S_5FieldRank<=S_5Choice,S_5Amount,0),0))","v":0},{"$f":"SUM(IF(S_11AccNO=$B61,IF(S_11FieldRank<=S_11Choice,S_11Amount,0),0))","v":0},{"$f":"SUM(IF(S_13AccNO=$B61,IF(S_13FieldRank<=S_13Choice,S_13Amount,0),0))","v":0},{"$f":"SUM(IF(S_14AccNO=$B61,IF(S_14FieldRank<=S_14Choice,S_14Amount,0),0))","v":0},"Employment Insurance",{"$f":"SUM(IF(S_6AccNO=$B61,IF(S_6FieldRank<=S_6Choice,S_6Amount,0),0))","v":0},{"$f":"SUM(IF(S_7AccNO=$B61,IF(S_7FieldRank<=S_7Choice,S_7Amount,0),0))","v":0},{"$f":"SUM(IF(S_8AccNO=$B61,IF(S_8FieldRank<=S_8Choice,S_8Amount,0),0))","v":0},{"$f":"SUM(IF(S_9AccNO=$B61,IF(S_9FieldRank<=S_9Choice,S_9Amount,0),0))","v":29525},{"$f":"SUM(IF(S_10AccNO=$B61,IF(S_10FieldRank<=S_10Choice,S_10Amount,0),0))","v":0},{"$f":"SUM(IF(S_12AccNO=$B61,IF(S_12FieldRank<=S_12Choice,S_12Amount,0),0))","v":0}]
[null,587,"Ministry Expense",189240,145535,{"$f":"SUM(IF(S1AccNO=B62,IF(S1FieldRank<=S1Choice,S1Amount,0),0))","v":120985},{"$f":"SUM(IF(S_2AccNO=$B62,IF(S_2FieldRank<=S_2Choice,S_2Amount,0),0))","v":0},{"$f":"SUM(IF(S_3AccNO=$B62,IF(S_3FieldRank<=S_3Choice,S_3Amount,0),0))","v":500},{"$f":"SUM(IF(S_4AccNO=$B62,IF(S_4FieldRank<=S_4Choice,S_4Amount,0),0))","v":4550},{"$f":"SUM(IF(S_5AccNO=$B62,IF(S_5FieldRank<=S_5Choice,S_5Amount,0),0))","v":0},{"$f":"SUM(IF(S_11AccNO=$B62,IF(S_11FieldRank<=S_11Choice,S_11Amount,0),0))","v":0},{"$f":"SUM(IF(S_13AccNO=$B62,IF(S_13FieldRank<=S_13Choice,S_13Amount,0),0))","v":0},{"$f":"SUM(IF(S_14AccNO=$B62,IF(S_14FieldRank<=S_14Choice,S_14Amount,0),0))","v":0},"Ministry Expense",{"$f":"SUM(IF(S_6AccNO=$B62,IF(S_6FieldRank<=S_6Choice,S_6Amount,0),0))","v":0},{"$f":"SUM(IF(S_7AccNO=$B62,IF(S_7FieldRank<=S_7Choice,S_7Amount,0),0))","v":0},{"$f":"SUM(IF(S_8AccNO=$B62,IF(S_8FieldRank<=S_8Choice,S_8Amount,0),0))","v":0},{"$f":"SUM(IF(S_9AccNO=$B62,IF(S_9FieldRank<=S_9Choice,S_9Amount,0),0))","v":19500},{"$f":"SUM(IF(S_10AccNO=$B62,IF(S_10FieldRank<=S_10Choice,S_10Amount,0),0))","v":0},{"$f":"SUM(IF(S_12AccNO=$B62,IF(S_12FieldRank<=S_12Choice,S_12Amount,0),0))","v":0}]
[null,591,"Salary Expense",1377515.5,1194600.5,{"$f":"SUM(IF(S1AccNO=B63,IF(S1FieldRank<=S1Choice,S1Amount,0),0))","v":877088.5},{"$f":"SUM(IF(S_2AccNO=$B63,IF(S_2FieldRank<=S_2Choice,S_2Amount,0),0))","v":0},{"$f":"SUM(IF(S_3AccNO=$B63,IF(S_3FieldRank<=S_3Choice,S_3Amount,0),0))","v":59800},{"$f":"SUM(IF(S_4AccNO=$B63,IF(S_4FieldRank<=S_4Choice,S_4Amount,0),0))","v":86495},{"$f":"SUM(IF(S_5AccNO=$B63,IF(S_5FieldRank<=S_5Choice,S_5Amount,0),0))","v":0},{"$f":"SUM(IF(S_11AccNO=$B63,IF(S_11FieldRank<=S_11Choice,S_11Amount,0),0))","v":15000},{"$f":"SUM(IF(S_13AccNO=$B63,IF(S_13FieldRank<=S_13Choice,S_13Amount,0),0))","v":0},{"$f":"SUM(IF(S_14AccNO=$B63,IF(S_14FieldRank<=S_14Choice,S_14Amount,0),0))","v":38192},"Salary Expense",{"$f":"SUM(IF(S_6AccNO=$B63,IF(S_6FieldRank<=S_6Choice,S_6Amount,0),0))","v":25078.5},{"$f":"SUM(IF(S_7AccNO=$B63,IF(S_7FieldRank<=S_7Choice,S_7Amount,0),0))","v":0},{"$f":"SUM(IF(S_8AccNO=$B63,IF(S_8FieldRank<=S_8Choice,S_8Amount,0),0))","v":29898},{"$f":"SUM(IF(S_9AccNO=$B63,IF(S_9FieldRank<=S_9Choice,S_9Amount,0),0))","v":63048.5},{"$f":"SUM(IF(S_10AccNO=$B63,IF(S_10FieldRank<=S_10Choice,S_10Amount,0),0))","v":0},{"$f":"SUM(IF(S_12AccNO=$B63,IF(S_12FieldRank<=S_12Choice,S_12Amount,0),0))","v":0}]
[null,592,"Executive Salaries",90290,97548,{"$f":"SUM(IF(S1AccNO=B64,IF(S1FieldRank<=S1Choice,S1Amount,0),0))","v":12000},{"$f":"SUM(IF(S_2AccNO=$B64,IF(S_2FieldRank<=S_2Choice,S_2Amount,0),0))","v":0},{"$f":"SUM(IF(S_3AccNO=$B64,IF(S_3FieldRank<=S_3Choice,S_3Amount,0),0))","v":0},{"$f":"SUM(IF(S_4AccNO=$B64,IF(S_4FieldRank<=S_4Choice,S_4Amount,0),0))","v":0},{"$f":"SUM(IF(S_5AccNO=$B64,IF(S_5FieldRank<=S_5Choice,S_5Amount,0),0))","v":0},{"$f":"SUM(IF(S_11AccNO=$B64,IF(S_11FieldRank<=S_11Choice,S_11Amount,0),0))","v":0},{"$f":"SUM(IF(S_13AccNO=$B64,IF(S_13FieldRank<=S_13Choice,S_13Amount,0),0))","v":0},{"$f":"SUM(IF(S_14AccNO=$B64,IF(S_14FieldRank<=S_14Choice,S_14Amount,0),0))","v":0},"Executive Salaries",{"$f":"SUM(IF(S_6AccNO=$B64,IF(S_6FieldRank<=S_6Choice,S_6Amount,0),0))","v":0},{"$f":"SUM(IF(S_7AccNO=$B64,IF(S_7FieldRank<=S_7Choice,S_7Amount,0),0))","v":0},{"$f":"SUM(IF(S_8AccNO=$B64,IF(S_8FieldRank<=S_8Choice,S_8Amount,0),0))","v":0},{"$f":"SUM(IF(S_9AccNO=$B64,IF(S_9FieldRank<=S_9Choice,S_9Amount,0),0))","v":85548},{"$f":"SUM(IF(S_10AccNO=$B64,IF(S_10FieldRank<=S_10Choice,S_10Amount,0),0))","v":0},{"$f":"SUM(IF(S_12AccNO=$B64,IF(S_12FieldRank<=S_12Choice,S_12Amount,0),0))","v":0}]
[null,593,"Retirement Allowance",8027.5,180670,{"$f":"SUM(IF(S1AccNO=B65,IF(S1FieldRank<=S1Choice,S1Amount,0),0))","v":104115},{"$f":"SUM(IF(S_2AccNO=$B65,IF(S_2FieldRank<=S_2Choice,S_2Amount,0),0))","v":0},{"$f":"SUM(IF(S_3AccNO=$B65,IF(S_3FieldRank<=S_3Choice,S_3Amount,0),0))","v":40280},{"$f":"SUM(IF(S_4AccNO=$B65,IF(S_4FieldRank<=S_4Choice,S_4Amount,0),0))","v":0},{"$f":"SUM(IF(S_5AccNO=$B65,IF(S_5FieldRank<=S_5Choice,S_5Amount,0),0))","v":0},{"$f":"SUM(IF(S_11AccNO=$B65,IF(S_11FieldRank<=S_11Choice,S_11Amount,0),0))","v":0},{"$f":"SUM(IF(S_13AccNO=$B65,IF(S_13FieldRank<=S_13Choice,S_13Amount,0),0))","v":0},{"$f":"SUM(IF(S_14AccNO=$B65,IF(S_14FieldRank<=S_14Choice,S_14Amount,0),0))","v":0},"Retirement Allowance",{"$f":"SUM(IF(S_6AccNO=$B65,IF(S_6FieldRank<=S_6Choice,S_6Amount,0),0))","v":36275},{"$f":"SUM(IF(S_7AccNO=$B65,IF(S_7FieldRank<=S_7Choice,S_7Amount,0),0))","v":0},{"$f":"SUM(IF(S_8AccNO=$B65,IF(S_8FieldRank<=S_8Choice,S_8Amount,0),0))","v":0},{"$f":"SUM(IF(S_9AccNO=$B65,IF(S_9FieldRank<=S_9Choice,S_9Amount,0),0))","v":0},{"$f":"SUM(IF(S_10AccNO=$B65,IF(S_10FieldRank<=S_10Choice,S_10Amount,0),0))","v":0},{"$f":"SUM(IF(S_12AccNO=$B65,IF(S_12FieldRank<=S_12Choice,S_12Amount,0),0))","v":0}]

{"sheet":"S1","index":4,"n_rows":118,"n_cols":12,"rows_kept":118,"cut":false,"hidden":false,"merged":[[0,8,5,8],[0,9,5,9]]}
[null,"Native Ministries",50,"Choose Rank Number -------->",null,null,10,null,"Amount of 23/24 budget spent by Oct 31","Total From Last 12 Months - Nov22-Oct23","Last Budget"]
[null,null,null,"Total Income",{"$f":"SUM(IF(S1FieldRank<=S1Choice,IF(S1AccNO<=LastIncome,S1Amount,0),0))","v":1169990.5},null,null,null,null,null,"23/24"]
[null,null,null,"Total Expense",{"$f":"SUM(IF(S1FieldRank<=S1Choice,IF(S1AccNO>LastIncome,S1Amount,0),0))","v":1162738.5}]
[null,null,null,"Difference",{"$f":"E2-E3","v":7252}]
["Line","Account Description","Acc_NO","Field Detail","Amount"]
[null,{"$f":"IF(C6<1,\" \",VLOOKUP(C6,MainAccountNO:MainAccounts,2,FALSE))","v":" "}]
[1,null,null,"Supervision and Misc."]
[2,{"$f":"IF(C8<1,\" \",VLOOKUP(C8,MainAccountNO:MainAccounts,2,FALSE))","v":"Staff Training"},537,"staff training - resources (27 @ $20)",540,null,null,{"$f":"IF(G8<=$G$1,\"\",\"OUT\")","v":""},null,null,435]
[3,{"$f":"IF(C9<1,\" \",VLOOKUP(C9,MainAccountNO:MainAccounts,2,FALSE))","v":"Commercial Travel"},551,"supervision visits - 2 flights @ $650",1300,null,null,"",null,null,1000]
[4,{"$f":"IF(C10<1,\" \",VLOOKUP(C10,MainAccountNO:MainAccounts,2,FALSE))","v":"Meal & Entertainment"},553,"staff visits",600,null,null,"",null,583,250]
[5,{"$f":"IF(C11<1,\" \",VLOOKUP(C11,MainAccountNO:MainAccounts,2,FALSE))","v":"Motel/Hotel"},546,"staff visits - 4 nights x $125",500,null,null,"",null,null,500]
[6,{"$f":"IF(C12<1,\" \",VLOOKUP(C12,MainAccountNO:MainAccounts,2,FALSE))","v":"Gas & Oil Auto"},549,"BC 2500km, YT 4500km, SK 1500km, MB 3000km; (500km/tank, $100/tank)",2500,null,null,"",null,1013,2500]
[7,{"$f":"IF(C13<1,\" \",VLOOKUP(C13,MainAccountNO:MainAccounts,2,FALSE))","v":"Auto Reimbursement"},563,"car rental - supervision",350,null,null,"",null,null,350]
[8,{"$f":"IF(C14<1,\" \",VLOOKUP(C14,MainAccountNO:MainAccounts,2,FALSE))","v":"Royalties/Fees"},530,"background checks - teams to Canada",50,null,null,"",null,null,150]
[9,{"$f":"IF(C15<1,\" \",VLOOKUP(C15,MainAccountNO:MainAccounts,2,FALSE))","v":"Special Projects"},580,"native church development (BC, AB, SK, MB, YT)",1500,null,null,{"$f":"IF(G15<=$G$1,\"\",\"OUT\")","v":""},null,null,1500]
[10]
[11,null,null,"Native Youth Conference (950)"]
[12,{"$f":"IF(C18<1,\" \",VLOOKUP(C18,MainAccountNO:MainAccounts,2,FALSE))","v":"Project Income - CND Ind"},440,"CAN individuals",2000,null,null,{"$f":"IF(G18<=$G$1,\"\",\"OUT\")","v":""},2058,2058,1500]
[13,{"$f":"IF(C19<1,\" \",VLOOKUP(C19,MainAccountNO:MainAccounts,2,FALSE))","v":"Project Income - CDN Churches"},441,"CAN Churches",3500,null,null,"",3500,3500,2500]
[14,{"$f":"IF(C20<1,\" \",VLOOKUP(C20,MainAccountNO:MainAccounts,2,FALSE))","v":"Operations Assessment"},484,"assessment on donations",-550,null,null,"",null,null,-400]
[15,{"$f":"IF(C21<1,\" \",VLOOKUP(C21,MainAccountNO:MainAccounts,2,FALSE))","v":"Special Projects"},580,"Native Youth Conference",4200,null,null,"",560,560,3600]
[16,{"$f":"IF(C22<1,\" \",VLOOKUP(C22,MainAccountNO:MainAccounts,2,FALSE))","v":"Bldg, Equip & Liab. Ins."},519,"Insurance for special events",750]
[17,null,null,null,null,null,null,""]
[18,null,null,"WayMaker Conference (954)",null,null,null,""]
[19,{"$f":"IF(C25<1,\" \",VLOOKUP(C25,MainAccountNO:MainAccounts,2,FALSE))","v":"Gifts in hand"},400,"apx balance on hand @ 03/31/2024",9550]
[20,{"$f":"IF(C26<1,\" \",VLOOKUP(C26,MainAccountNO:MainAccounts,2,FALSE))","v":"Project Income - CND Ind"},440,"CAN Individuals",2500,null,null,null,null,null,600]
[21,{"$f":"IF(C27<1,\" \",VLOOKUP(C27,MainAccountNO:MainAccounts,2,FALSE))","v":"Project Income - CDN Churches"},441,"CAN churches",1500,null,null,null,null,1409,200]
[22,{"$f":"IF(C28<1,\" \",VLOOKUP(C28,MainAccountNO:MainAccounts,2,FALSE))","v":"Operations Assessment"},484,"Assessment on donations",{"$f":"-0.1*(E26+E27)","v":-400},null,null,null,null,null,-80]
[23,{"$f":"IF(C29<1,,VLOOKUP(C29,MainAccountNO:MainAccounts,2,FALSE))","v":"Other income"},455,"Registrations ",30625,null,null,"",21510,29870,13950]
[24,{"$f":"IF(C30<1,,VLOOKUP(C30,MainAccountNO:MainAccounts,2,FALSE))","v":"Other income"},455,"Merchandise sales",500,null,null,"",null,null,5800]
[25,{"$f":"IF(C31<1,,VLOOKUP(C31,MainAccountNO:MainAccounts,2,FALSE))","v":"Special Projects"},580,"Facility rental (Meals and Accomodations)",27125,null,null,"",14567,22202,16650]
[26,{"$f":"IF(C32<1,,VLOOKUP(C32,MainAccountNO:MainAccounts,2,FALSE))","v":"Special Projects"},580,"Facility rental(Speaker meals/accomodations)",700,null,null,"",null,null,275]
[27,{"$f":"IF(C33<1,,VLOOKUP(C33,MainAccountNO:MainAccounts,2,FALSE))","v":"Speaker Honorarium"},559,"Speaker/Entertainment (honoraiums)",3000,null,null,"",1475,1475,2000]
[28,{"$f":"IF(C34<1,,VLOOKUP(C34,MainAccountNO:MainAccounts,2,FALSE))","v":"Speaker Honorarium"},559,"Honorarium/elder gift",400,null,null,"",null,null,200]
[29,{"$f":"IF(C35<1,,VLOOKUP(C35,MainAccountNO:MainAccounts,2,FALSE))","v":"General Supply & Service"},545,"Activities ",550,null,null,"",null,null,675]
[30,{"$f":"IF(C36<1,,VLOOKUP(C36,MainAccountNO:MainAccounts,2,FALSE))","v":"General Supply & Service"},545,"Game supplies",300,null,null,"",null,null,150]
[31,{"$f":"IF(C37<1,,VLOOKUP(C37,MainAccountNO:MainAccounts,2,FALSE))","v":"Meal & Entertainment"},553,"Friday supper",1000]
[32,{"$f":"IF(C38<1,,VLOOKUP(C38,MainAccountNO:MainAccounts,2,FALSE))","v":"General Supply & Service"},545,"Merchandise, Prizes and MISC",1300,null,null,"",null,null,300]
[33,{"$f":"IF(C39<1,,VLOOKUP(C39,MainAccountNO:MainAccounts,2,FALSE))","v":"Bldg, Equip & Liab. Ins."},519,"Insurance for special events",750,null,null,null,null,null,150]
[34,null,null,null,null,null,null,{"$f":"IF(G40<=$G$1,\"\",\"OUT\")","v":""}]
[35,null,null,"Community Research/Relational Development (942)",null,null,null,""]
[36,{"$f":"IF(C42<1,\" \",VLOOKUP(C42,MainAccountNO:MainAccounts,2,FALSE))","v":"Gas & Oil Auto"},549,"apx. 1500 km",225,null,null,"",null,null,225]
[37,{"$f":"IF(C43<1,\" \",VLOOKUP(C43,MainAccountNO:MainAccounts,2,FALSE))","v":"Motel/Hotel"},546,"2 nights x $125",250,null,null,"",null,null,250]
[38,{"$f":"IF(C44<1,\" \",VLOOKUP(C44,MainAccountNO:MainAccounts,2,FALSE))","v":"Meal & Entertainment"},553,"4 meals ($20/meal) relationship development x 2",160,null,null,"",null,null,160]
[39,{"$f":"IF(C45<1,\" \",VLOOKUP(C45,MainAccountNO:MainAccounts,2,FALSE))","v":"Special Projects"},580,"value added for believers/community (training, events, scholarships, etc.)",300,null,null,"",null,null,300]
[40,{"$f":"IF(C46<1,\" \",VLOOKUP(C46,MainAccountNO:MainAccounts,2,FALSE))","v":"Special Projects"},580,"community resourcing",200,null,null,"",null,null,200]
[41]
[42,null,null,"Native Ministry Staffing"]
[43,{"$f":"IF(C49<1,\" \",VLOOKUP(C49,MainAccountNO:MainAccounts,2,FALSE))","v":"US Gifts"},430,"Beutler US support",0,null,null,{"$f":"IF(G49<=$G$1,\"\",\"OUT\")","v":""},null,null,1050]
[44,{"$f":"IF(C50<1,\" \",VLOOKUP(C50,MainAccountNO:MainAccounts,2,FALSE))","v":"Canadian Gifts-Staff"},410,"Beutler CDN support",107100,null,null,"",null,null,86075]
[45,{"$f":"IF(C51<1,\" \",VLOOKUP(C51,MainAccountNO:MainAccounts,2,FALSE))","v":"Ministry Expense"},587,"Beutler MER",11250,null,null,"",null,null,10000]
[46,{"$f":"IF(C52<1,\" \",VLOOKUP(C52,MainAccountNO:MainAccounts,2,FALSE))","v":"Salary Expense"},591,"Beutler salary",{"$f":"0.9*(E49+E50)-E51","v":85140},null,null,"",null,null,68412.5]
[47,{"$f":"IF(C53<1,\" \",VLOOKUP(C53,MainAccountNO:MainAccounts,2,FALSE))","v":"US Gifts"},430,"Browning, Dick US Support",38150,null,null,"",null,null,34180]
[48,{"$f":"IF(C54<1,\" \",VLOOKUP(C54,MainAccountNO:MainAccounts,2,FALSE))","v":"Canadian Gifts-Staff"},410,"Browning, Dick CDN Support",20850,null,null,"",null,null,21850]
[49,{"$f":"IF(C55<1,\" \",VLOOKUP(C55,MainAccountNO:MainAccounts,2,FALSE))","v":"Ministry Expense"},587,"Browning, Dick MER",0,null,null,"",null,null,0]
[50,{"$f":"IF(C56<1,\" \",VLOOKUP(C56,MainAccountNO:MainAccounts,2,FALSE))","v":"Salary Expense"},591,"Browning, Dick Salary",{"$f":"0.9*(E53+E54)-E55","v":53100},null,null,"",null,null,50427]
[51,{"$f":"IF(C57<1,\" \",VLOOKUP(C57,MainAccountNO:MainAccounts,2,FALSE))","v":"US Gifts"},430,"Chinn US Support",83250,null,null,null,null,null,70000]
[52,{"$f":"IF(C58<1,\" \",VLOOKUP(C58,MainAccountNO:MainAccounts,2,FALSE))","v":"Canadian Gifts-Staff"},410,"Chinn CDN Support",1950,null,null,null,null,null,0]
[53,{"$f":"IF(C59<1,\" \",VLOOKUP(C59,MainAccountNO:MainAccounts,2,FALSE))","v":"Ministry Expense"},587,"Chinn MER",11000,null,null,null,null,null,7200]
[54,{"$f":"IF(C60<1,\" \",VLOOKUP(C60,MainAccountNO:MainAccounts,2,FALSE))","v":"Salary Expense"},591,"Chinn Salary",48375,null,null,null,null,null,38450]
[55,{"$f":"IF(C61<1,\" \",VLOOKUP(C61,MainAccountNO:MainAccounts,2,FALSE))","v":"US Gifts"},430,"Colwell US support",134625,null,null,null,null,null,107240]
[56,{"$f":"IF(C62<1,\" \",VLOOKUP(C62,MainAccountNO:MainAccounts,2,FALSE))","v":"Canadian Gifts-Staff"},410,"Colwell CDN suport",17800,null,null,null,null,null,22415]
[57,{"$f":"IF(C63<1,\" \",VLOOKUP(C63,MainAccountNO:MainAccounts,2,FALSE))","v":"Ministry Expense"},587,"Colwell MER",7000,null,null,null,null,null,7200]
[58,{"$f":"IF(C64<1,\" \",VLOOKUP(C64,MainAccountNO:MainAccounts,2,FALSE))","v":"Salary Expense"},591,"Colwell salary",{"$f":"0.9*(E61+E62)-E63","v":130182.5},null,null,null,null,null,109489.5]
[59,{"$f":"IF(C65<1,\" \",VLOOKUP(C65,MainAccountNO:MainAccounts,2,FALSE))","v":"US Gifts"},430,"Cross US support",15500,null,null,null,null,null,8630]
[60,{"$f":"IF(C66<1,,VLOOKUP(C66,MainAccountNO:MainAccounts,2,FALSE))","v":"Canadian Gifts-Staff"},410,"Cross CDN Support",22275,null,null,"",null,null,30065]
[61,{"$f":"IF(C67<1,,VLOOKUP(C67,MainAccountNO:MainAccounts,2,FALSE))","v":"Ministry Expense"},587,"Cross MER",550,null,null,"",null,null,6800]
[62,{"$f":"IF(C68<1,,VLOOKUP(C68,MainAccountNO:MainAccounts,2,FALSE))","v":"Salary Expense"},591,"Cross Salary",{"$f":"0.9*(E66+E65)-E67","v":33447.5},null,null,"",null,null,28025.5]
[63,{"$f":"IF(C69<1,\" \",VLOOKUP(C69,MainAccountNO:MainAccounts,2,FALSE))","v":"US Gifts"},430,"Kasten US Support",42400,null,null,"",null,null,38340]
[64,{"$f":"IF(C70<1,\" \",VLOOKUP(C70,MainAccountNO:MainAccounts,2,FALSE))","v":"Canadian Gifts-Staff"},410,"Kasten CDN Support",500,null,null,"",null,null,0]
[65,{"$f":"IF(C71<1,\" \",VLOOKUP(C71,MainAccountNO:MainAccounts,2,FALSE))","v":"Ministry Expense"},587,"Kasten MER",3500,null,null,"",null,null,4500]
[66,{"$f":"IF(C72<1,\" \",VLOOKUP(C72,MainAccountNO:MainAccounts,2,FALSE))","v":"Salary Expense"},591,"Kasten Salary",{"$f":"0.95*(E69+E70)-E71","v":37255},null,null,"",null,null,31923]
[67,{"$f":"IF(C73<1,\" \",VLOOKUP(C73,MainAccountNO:MainAccounts,2,FALSE))","v":"Canadian Gifts-Staff"},410,"Mayerle CDN Support",55450,null,null,null,null,null,53465]
[68,{"$f":"IF(C74<1,\" \",VLOOKUP(C74,MainAccountNO:MainAccounts,2,FALSE))","v":"US Gifts"},430,"Mayerle US Support",24750,null,null,null,null,null,19820]
[69,{"$f":"IF(C75<1,\" \",VLOOKUP(C75,MainAccountNO:MainAccounts,2,FALSE))","v":"Ministry Expense"},587,"Mayerle MER",33450,null,null,null,null,null,23600]
[70,{"$f":"IF(C76<1,\" \",VLOOKUP(C76,MainAccountNO:MainAccounts,2,FALSE))","v":"Salary Expense"},591,"Mayerle Salary",{"$f":"0.9*(E73+E74)-E75","v":38730},null,null,null,null,null,42356.5]
[71,{"$f":"IF(C77<1,\" \",VLOOKUP(C77,MainAccountNO:MainAccounts,2,FALSE))","v":"US Gifts"},430,"Olney US Support",0,null,null,{"$f":"IF(G77<=$G$1,\"\",\"OUT\")","v":""},null,null,0]
[72,{"$f":"IF(C78<1,\" \",VLOOKUP(C78,MainAccountNO:MainAccounts,2,FALSE))","v":"Canadian Gifts-Staff"},410,"Olney CDN Support",82450,null,null,"",null,null,81400]
[73,{"$f":"IF(C79<1,\" \",VLOOKUP(C79,MainAccountNO:MainAccounts,2,FALSE))","v":"Ministry Expense"},587,"Olney MER",2700,null,null,"",null,null,3800]
[74,{"$f":"IF(C80<1,\" \",VLOOKUP(C80,MainAccountNO:MainAccounts,2,FALSE))","v":"Salary Expense"},591,"Olney Salary",{"$f":"0.9*(E77+E78)-E79","v":71505},null,null,"",null,null,69460]
[75,{"$f":"IF(C81<1,\" \",VLOOKUP(C81,MainAccountNO:MainAccounts,2,FALSE))","v":"US Gifts"},430,"Plett US Support",175,null,null,"",null,null,255]
[76,{"$f":"IF(C82<1,\" \",VLOOKUP(C82,MainAccountNO:MainAccounts,2,FALSE))","v":"Canadian Gifts-Staff"},410,"Plett CDN Support",64225,null,null,"",null,null,55825]
[77,{"$f":"IF(C83<1,\" \",VLOOKUP(C83,MainAccountNO:MainAccounts,2,FALSE))","v":"Ministry Expense"},587,"Plett MER",8300,null,null,"",null,null,8300]
[78,{"$f":"IF(C84<1,\" \",VLOOKUP(C84,MainAccountNO:MainAccounts,2,FALSE))","v":"Salary Expense"},591,"Plett Salary",{"$f":"0.9*(E81+E82)-E83","v":49660},null,null,"",null,null,42172]
[79,{"$f":"IF(C85<1,\" \",VLOOKUP(C85,MainAccountNO:MainAccounts,2,FALSE))","v":"US Gifts"},430,"Sayer US support",0,null,null,"",null,null,7215]
[80,{"$f":"IF(C86<1,\" \",VLOOKUP(C86,MainAccountNO:MainAccounts,2,FALSE))","v":"Canadian Gifts-Staff"},410,"Sayer CDN support",88825,null,null,"",null,null,82935]
[81,{"$f":"IF(C87<1,\" \",VLOOKUP(C87,MainAccountNO:MainAccounts,2,FALSE))","v":"Ministry Expense"},587,"Sayer MER",11800,null,null,"",null,null,16480]
[82,{"$f":"IF(C88<1,\" \",VLOOKUP(C88,MainAccountNO:MainAccounts,2,FALSE))","v":"Salary Expense"},591,"Sayer Salary",{"$f":"0.9*(E85+E86)-E87","v":68142.5},null,null,"",null,null,64655]
[83,{"$f":"IF(C89<1,\" \",VLOOKUP(C89,MainAccountNO:MainAccounts,2,FALSE))","v":"US Gifts"},430,"Schulz US Support",11200,null,null,"",null,null,10690]
[84,{"$f":"IF(C90<1,\" \",VLOOKUP(C90,MainAccountNO:MainAccounts,2,FALSE))","v":"Canadian Gifts-Staff"},410,"Schulz CDN Support",60165,null,null,"",null,null,55450]
[85,{"$f":"IF(C91<1,\" \",VLOOKUP(C91,MainAccountNO:MainAccounts,2,FALSE))","v":"Executive Salaries"},592,"Schulz - subsidy (12x$1000)",12000,null,null,null,null,null,null,"From Restora Profits"]
[86,{"$f":"IF(C92<1,\" \",VLOOKUP(C92,MainAccountNO:MainAccounts,2,FALSE))","v":"Ministry Expense"},587,"Schulz MER",12060,null,null,"",null,null,9750]
[87,{"$f":"IF(C93<1,\" \",VLOOKUP(C93,MainAccountNO:MainAccounts,2,FALSE))","v":"Salary Expense"},591,"Schulz Salary",{"$f":"0.9*(E89+E90)-E92","v":52168.5},null,null,"",null,null,49776]
[88,{"$f":"IF(C94<1,\" \",VLOOKUP(C94,MainAccountNO:MainAccounts,2,FALSE))","v":"US Gifts"},430,"Sebald US support",99485,null,null,"",null,null,80035]
[89,{"$f":"IF(C95<1,\" \",VLOOKUP(C95,MainAccountNO:MainAccounts,2,FALSE))","v":"Canadian Gifts-Staff"},410,"Sebald CDN support",3265,null,null,"",null,null,3380]
[90,{"$f":"IF(C96<1,\" \",VLOOKUP(C96,MainAccountNO:MainAccounts,2,FALSE))","v":"Ministry Expense"},587,"Sebald MER",9400,null,null,"",null,null,22400]
[91,{"$f":"IF(C97<1,\" \",VLOOKUP(C97,MainAccountNO:MainAccounts,2,FALSE))","v":"Salary Expense"},591,"Sebald salary",{"$f":"0.9*(E94+E95)-E96","v":83075},null,null,"",null,null,52673.5]
[92,{"$f":"IF(C98<1,\" \",VLOOKUP(C98,MainAccountNO:MainAccounts,2,FALSE))","v":"US Gifts"},430,"Serger US Support",0,null,null,"",null,null,0]
[93,{"$f":"IF(C99<1,\" \",VLOOKUP(C99,MainAccountNO:MainAccounts,2,FALSE))","v":"Canadian Gifts-Staff"},410,"Serger CDN Support",88060,null,null,"",null,null,86170]
[94,{"$f":"IF(C100<1,\" \",VLOOKUP(C100,MainAccountNO:MainAccounts,2,FALSE))","v":"Ministry Expense"},587,"Serger MER",9475,null,null,"",null,null,14400]
[95,{"$f":"IF(C101<1,\" \",VLOOKUP(C101,MainAccountNO:MainAccounts,2,FALSE))","v":"Salary Expense"},591,"Serger Salary",{"$f":"0.9*(E98+E99)-E100","v":69779},null,null,"",null,null,63153]
[96,{"$f":"IF(C102<1,\" \",VLOOKUP(C102,MainAccountNO:MainAccounts,2,FALSE))","v":"US Gifts"},430,"Straley US Support",35350,null,null,{"$f":"IF(G102<=$G$1,\"\",\"OUT\")","v":""},null,null,37800]
[97,{"$f":"IF(C103<1,\" \",VLOOKUP(C103,MainAccountNO:MainAccounts,2,FALSE))","v":"Canadian Gifts-Staff"},410,"Straley CDN Support",28015,null,null,"",null,null,26675]
[98,{"$f":"IF(C104<1,\" \",VLOOKUP(C104,MainAccountNO:MainAccounts,2,FALSE))","v":"Ministry Expense"},587,"Straley MER",500,null,null,"",null,null,6000]
[99,{"$f":"IF(C105<1,\" \",VLOOKUP(C105,MainAccountNO:MainAccounts,2,FALSE))","v":"Salary Expense"},591,"Straley Salary",{"$f":"0.9*(E102+E103)-E104","v":56528.5},null,null,"",null,null,52027.5]
[100,{"$f":"IF(C106<1,\" \",VLOOKUP(C106,MainAccountNO:MainAccounts,2,FALSE))","v":"Operations Assessment"},484,"operations assessment",{"$f":"-0.1*(E49+E50+E53+E54+E57+E58+E61+E62+E65+E66+E73+E74+E77+E78+E81+E82+E85+E86+E89+E90+E94+E95+E98+E99+E102+E103-2145)","v":-108077},null,null,"",null,null,-121233.5]
[101,null,null,null,null,null,null,""]
[102,null,null,"Retired Staff (5% assessment)",null,null,null,""]
[103,{"$f":"IF(C109<1,\" \",VLOOKUP(C109,MainAccountNO:MainAccounts,2,FALSE))","v":"Canadian Gifts-Staff"},410,"Hamilton, J CDN Support",16850]
[104,{"$f":"IF(C110<1,\" \",VLOOKUP(C110,MainAccountNO:MainAccounts,2,FALSE))","v":"US Gifts"},430,"Hamilton, J US Support",37325]
[105,{"$f":"IF(C111<1,\" \",VLOOKUP(C111,MainAccountNO:MainAccounts,2,FALSE))","v":"Retirement Allowance"},593,"Hamilton, J Salary",45360]
[106,{"$f":"IF(C112<1,,VLOOKUP(C112,MainAccountNO:MainAccounts,2,FALSE))","v":"Canadian Gifts-Staff"},410,"Kees CDN Support",3200,null,null,{"$f":"IF(G112<=$G$1,\"\",\"OUT\")","v":""},null,null,100]
[107,{"$f":"IF(C113<1,,VLOOKUP(C113,MainAccountNO:MainAccounts,2,FALSE))","v":"US Gifts"},430,"Kees US Support",10900,{"$f":"0.05*(E113+E112)","v":705},null,{"$f":"IF(G113<=$G$1,\"\",\"OUT\")","v":""},null,null,8350]
[108,{"$f":"IF(C114<1,,VLOOKUP(C114,MainAccountNO:MainAccounts,2,FALSE))","v":"Retirement Allowance"},593,"Kees Salary",{"$f":"0.95*(E112+E113)","v":13395},null,null,{"$f":"IF(G114<=$G$1,\"\",\"OUT\")","v":""},null,null,8027.5]
[109,{"$f":"IF(C115<1,,VLOOKUP(C115,MainAccountNO:MainAccounts,2,FALSE))","v":"Canadian Gifts-Staff"},410,"Kenyon CDN Support",18050]
[110,{"$f":"IF(C116<1,,VLOOKUP(C116,MainAccountNO:MainAccounts,2,FALSE))","v":"US Gifts"},430,"Kenyon US Support",22125]
[111,{"$f":"IF(C117<1,,VLOOKUP(C117,MainAccountNO:MainAccounts,2,FALSE))","v":"Retirement Allowance"},593,"Kenyon Salary",45360]
[112,{"$f":"IF(C118<1,,VLOOKUP(C118,MainAccountNO:MainAccounts,2,FALSE))","v":"Operations Assessment"},484,"operations assessment",{"$f":"-0.05*(E109+E110+E112+E113+E115+E116)","v":-5422.5},null,null,{"$f":"IF(G118<=$G$1,\"\",\"OUT\")","v":""},null,null,-422.5]

{"sheet":"S2","index":5,"n_rows":31,"n_cols":8,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[null,"EnGage!",40,"Choose Rank Number -------->",null,null,10]
[null,null,null,"Total Income",{"$f":"SUM(IF(S_2FieldRank<=S_2Choice,IF(S_2AccNO<=LastIncome,S_2Amount,0),0))","v":12150}]
[null,null,null,"Total Expense",{"$f":"SUM(IF(S_2FieldRank<=S_2Choice,IF(S_2AccNO>LastIncome,S_2Amount,0),0))","v":11750}]
[null,null,null,"Difference",{"$f":"E2-E3","v":400}]
["Line","Account Description","Acc_NO","Field Detail","Amount"]
[]
[1,{"$f":"IF(C7<1,\" \",VLOOKUP(C7,MainAccountNO:MainAccounts,2,FALSE))","v":"Project Income - CDN Churches"},441,"6 participants @ $1350 less scholarships",8100,null,null,{"$f":"IF(G7<=$G$1,\"\",\"OUT\")","v":""}]
[2,{"$f":"IF(C8<1,\" \",VLOOKUP(C8,MainAccountNO:MainAccounts,2,FALSE))","v":"Special Projects"},580,"mobilization scholarships",1500,null,null,""]
[3,{"$f":"IF(C9<1,\" \",VLOOKUP(C9,MainAccountNO:MainAccounts,2,FALSE))","v":"Operations Assessment"},484,"assessment on fees",-810,null,null,""]
[4,{"$f":"IF(C10<1,\" \",VLOOKUP(C10,MainAccountNO:MainAccounts,2,FALSE))","v":"Project Income - CDN Churches"},441,"4 participants ESL EnGage! @ $1350",5400,null,null,""]
[5,{"$f":"IF(C11<1,\" \",VLOOKUP(C11,MainAccountNO:MainAccounts,2,FALSE))","v":"Operations Assessment"},484,"assessment on fees",-540,null,null,""]
[6,{"$f":"IF(C12<1,\" \",VLOOKUP(C12,MainAccountNO:MainAccounts,2,FALSE))","v":"Bldg, Equip & Liab. Ins."},519,"liability insurance",150,null,null,""]
[7,null,null,null,null,null,null,""]
[8,null,null,"First Nations EnGage!",null,null,null,""]
[9,{"$f":"IF(C15<1,\" \",VLOOKUP(C15,MainAccountNO:MainAccounts,2,FALSE))","v":"Royalties/Fees"},530,"background checks",170,null,null,""]
[10,{"$f":"IF(C16<1,\" \",VLOOKUP(C16,MainAccountNO:MainAccounts,2,FALSE))","v":"Equip. Maint."},527,"printing",50,null,null,""]
[11,{"$f":"IF(C17<1,\" \",VLOOKUP(C17,MainAccountNO:MainAccounts,2,FALSE))","v":"Staff Training"},537,"training materials and supplies",500,null,null,""]
[12,{"$f":"IF(C18<1,\" \",VLOOKUP(C18,MainAccountNO:MainAccounts,2,FALSE))","v":"General Supply & Service"},545,"ministry supplies",300,null,null,""]
[13,{"$f":"IF(C19<1,\" \",VLOOKUP(C19,MainAccountNO:MainAccounts,2,FALSE))","v":"Meal & Entertainment"},553,"food & living expenses",3400,null,null,""]
[14,{"$f":"IF(C20<1,\" \",VLOOKUP(C20,MainAccountNO:MainAccounts,2,FALSE))","v":"Gas & Oil Auto"},549,"travel re. supervision",750,null,null,""]
[15,null,null,null,null,null,null,""]
[16,null,null,"ESL EnGage!",null,null,null,""]
[17,{"$f":"IF(C23<1,\" \",VLOOKUP(C23,MainAccountNO:MainAccounts,2,FALSE))","v":"Royalties/Fees"},530,"background checks",110,null,null,""]
[18,{"$f":"IF(C24<1,\" \",VLOOKUP(C24,MainAccountNO:MainAccounts,2,FALSE))","v":"Equip. Maint."},527,"printing",20]
[19,{"$f":"IF(C25<1,\" \",VLOOKUP(C25,MainAccountNO:MainAccounts,2,FALSE))","v":"Staff Training"},537,"training materials and supplies",400,null,null,""]
[20,{"$f":"IF(C26<1,\" \",VLOOKUP(C26,MainAccountNO:MainAccounts,2,FALSE))","v":"General Supply & Service"},545,"ministry supplies",200,null,null,""]
[21,{"$f":"IF(C27<1,\" \",VLOOKUP(C27,MainAccountNO:MainAccounts,2,FALSE))","v":"Motel/Hotel"},546,"hotel re. supervision",250]
[22,{"$f":"IF(C28<1,\" \",VLOOKUP(C28,MainAccountNO:MainAccounts,2,FALSE))","v":"Meal & Entertainment"},553,"food & living expenses",2200,null,null,""]
[23,{"$f":"IF(C29<1,\" \",VLOOKUP(C29,MainAccountNO:MainAccounts,2,FALSE))","v":"Gas & Oil Auto"},549,"travel re. supervision",850,null,null,""]
[24,{"$f":"IF(C30<1,\" \",VLOOKUP(C30,MainAccountNO:MainAccounts,2,FALSE))","v":"Commercial Travel"},551,"travel re. orientation",600,null,null,""]
[25,{"$f":"IF(C31<1,\" \",VLOOKUP(C31,MainAccountNO:MainAccounts,2,FALSE))","v":"Auto Reimbursement"},563,"car rental re. supervision",300,null,null,""]

{"sheet":"S3","index":6,"n_rows":33,"n_cols":11,"rows_kept":33,"cut":false,"hidden":false,"merged":[[0,8,5,8],[0,9,5,9]]}
[null,"Muslim Ministries",85,"Choose Rank Number -------->",null,null,10,null,"Amount of 23/24 budget spent by Oct 31","Total From Last 12 Months - Nov22-Oct23","Last Budget"]
[null,null,null,"Total Income",{"$f":"SUM(IF(S_3FieldRank<=S_3Choice,IF(S_3AccNO<=LastIncome,S_3Amount,0),0))","v":102560},null,null,null,null,null,"23/24"]
[null,null,null,"Total Expense",{"$f":"SUM(IF(S_3FieldRank<=S_3Choice,IF(S_3AccNO>LastIncome,S_3Amount,0),0))","v":102590}]
[null,null,null,"Difference",{"$f":"E2-E3","v":-30}]
["Line","Account Description","Acc_NO","Field Detail","Amount"]
[null,{"$f":"IF(C6<1,\" \",VLOOKUP(C6,MainAccountNO:MainAccounts,2,FALSE))","v":" "},null,null,null,null,null,{"$f":"IF(G6<=$G$1,\"\",\"OUT\")","v":""}]
[1,{"$f":"IF(C7<1,\" \",VLOOKUP(C7,MainAccountNO:MainAccounts,2,FALSE))","v":"Project Income - CDN Churches"},441,"donations",200,null,null,"",null,null,200]
[2,{"$f":"IF(C8<1,\" \",VLOOKUP(C8,MainAccountNO:MainAccounts,2,FALSE))","v":"Operations Assessment"},484,"assessment on donations",-20,null,null,"",null,null,-20]
[3,{"$f":"IF(C9<1,\" \",VLOOKUP(C9,MainAccountNO:MainAccounts,2,FALSE))","v":"Staff Training"},537,"staff training - resources (3 @ $20)",60,null,null,"",null,null,75]
[5,{"$f":"IF(C10<1,\" \",VLOOKUP(C10,MainAccountNO:MainAccounts,2,FALSE))","v":"General Supply & Service"},545,"Scripture, DVDs, literature, etc. to give away",150,null,null,"",null,null,150]
[6]
[7,null,null,"Fundraising Project for Arabic Bibles"]
[8,{"$f":"IF(C13<1,\" \",VLOOKUP(C13,MainAccountNO:MainAccounts,2,FALSE))","v":"Project Income - CND Ind"},440,"donations",1400,null,null,null,null,null,1400]
[9,{"$f":"IF(C14<1,\" \",VLOOKUP(C14,MainAccountNO:MainAccounts,2,FALSE))","v":"Project Income - CDN Churches"},441,"donations",600,null,null,null,null,null,600]
[10,{"$f":"IF(C15<1,\" \",VLOOKUP(C15,MainAccountNO:MainAccounts,2,FALSE))","v":"Operations Assessment"},484,"assessment on donations",-200,null,null,null,null,null,-200]
[11,{"$f":"IF(C16<1,\" \",VLOOKUP(C16,MainAccountNO:MainAccounts,2,FALSE))","v":"Special Projects"},580,"Bibles",1800,null,null,null,null,null,1800]
[12,null,null,null,null,null,null,""]
[13,null,null,"MM Staffing",null,null,null,""]
[14,{"$f":"IF(C19<1,\" \",VLOOKUP(C19,MainAccountNO:MainAccounts,2,FALSE))","v":"US Gifts"},430,"Narooz US Support",450,null,null,"",null,null,100]
[15,{"$f":"IF(C20<1,\" \",VLOOKUP(C20,MainAccountNO:MainAccounts,2,FALSE))","v":"Canadian Gifts-Staff"},410,"Narooz CDN Support",19800,null,null,"",null,null,18825]
[16,{"$f":"IF(C21<1,\" \",VLOOKUP(C21,MainAccountNO:MainAccounts,2,FALSE))","v":"Ministry Expense"},587,"Narooz MER",0,null,null,"",null,null,0]
[17,{"$f":"IF(C22<1,\" \",VLOOKUP(C22,MainAccountNO:MainAccounts,2,FALSE))","v":"Salary Expense"},591,"Narooz Salary",{"$f":"0.9*(E19+E20)-E21","v":18225},null,null,"",null,null,17032.5]
[18,{"$f":"IF(C23<1,\" \",VLOOKUP(C23,MainAccountNO:MainAccounts,2,FALSE))","v":"US Gifts"},430,"Wortham US Support",44610,null,null,"",null,null,35025]
[19,{"$f":"IF(C24<1,\" \",VLOOKUP(C24,MainAccountNO:MainAccounts,2,FALSE))","v":"Canadian Gifts-Staff"},410,"Wortham CDN Support",2140,null,null,"",null,null,1500]
[20,{"$f":"IF(C25<1,\" \",VLOOKUP(C25,MainAccountNO:MainAccounts,2,FALSE))","v":"Ministry Expense"},587,"Wortham MER",500,null,null,"",null,null,1000]
[21,{"$f":"IF(C26<1,\" \",VLOOKUP(C26,MainAccountNO:MainAccounts,2,FALSE))","v":"Salary Expense"},591,"Wortham Salary",{"$f":"0.9*(E23+E24)-E25","v":41575},null,null,"",null,null,31872.5]
[22,{"$f":"IF(C27<1,\" \",VLOOKUP(C27,MainAccountNO:MainAccounts,2,FALSE))","v":"Operations Assessment"},484,"operations assessment",{"$f":"-0.1*(E19+E20+E23+E24)","v":-6700},null,null,"",null,null,-10702]
[23,{"$f":"IF(C28<1,\" \",VLOOKUP(C28,MainAccountNO:MainAccounts,2,FALSE))","v":" "},null,null,null,null,null,""]
[24,{"$f":"IF(C29<1,\" \",VLOOKUP(C29,MainAccountNO:MainAccounts,2,FALSE))","v":" "},null,"Retired Staff (5% assessment)",null,null,null,""]
[25,{"$f":"IF(C30<1,\" \",VLOOKUP(C30,MainAccountNO:MainAccounts,2,FALSE))","v":"US Gifts"},430,"Nelson US Support",4500,null,null,""]
[26,{"$f":"IF(C31<1,\" \",VLOOKUP(C31,MainAccountNO:MainAccounts,2,FALSE))","v":"Canadian Gifts-Staff"},410,"Nelson CDN Support",37900,null,null,""]
[27,{"$f":"IF(C32<1,\" \",VLOOKUP(C32,MainAccountNO:MainAccounts,2,FALSE))","v":"Retirement Allowance"},593,"Nelson Salary",{"$f":"0.95*(E30+E31)","v":40280},null,null,""]
[28,{"$f":"IF(C33<1,\" \",VLOOKUP(C33,MainAccountNO:MainAccounts,2,FALSE))","v":"Operations Assessment"},484,"operations assessment",{"$f":"-0.05*(E30+E31)","v":-2120},null,null,""]

{"sheet":"S4","index":7,"n_rows":40,"n_cols":11,"rows_kept":40,"cut":false,"hidden":false,"merged":[[0,8,5,8],[0,9,5,9]]}
[null,"East Indian",20,"Choose Rank Number -------->",null,null,10,null,"Amount of 23/24 budget spent by Oct 31","Total From Last 12 Months - Nov22-Oct23","Last Budget"]
[null,null,null,"Total Income",{"$f":"SUM(IF(S_4FieldRank<=S_4Choice,IF(S_4AccNO<=LastIncome,S_4Amount,0),0))","v":110984},null,null,null,null,null,"23/24"]
[null,null,null,"Total Expense",{"$f":"SUM(IF(S_4FieldRank<=S_4Choice,IF(S_4AccNO>LastIncome,S_4Amount,0),0))","v":111240}]
[null,null,null,"Total Expense",{"$f":"E2-E3","v":-256}]
["Line","Account Description","Acc_NO","Field Detail","Amount"]
[null,{"$f":"IF(C6<1,\" \",VLOOKUP(C6,MainAccountNO:MainAccounts,2,FALSE))","v":" "},null,null,null,null,null,{"$f":"IF(G6<=$G$1,\"\",\"OUT\")","v":""}]
[1,null,null,"Supervision & Misc."]
[2,{"$f":"IF(C8<1,\" \",VLOOKUP(C8,MainAccountNO:MainAccounts,2,FALSE))","v":"Motel/Hotel"},546,"supervisor travel 2 nights @ $125",250,null,null,"",null,null,250]
[3,{"$f":"IF(C9<1,\" \",VLOOKUP(C9,MainAccountNO:MainAccounts,2,FALSE))","v":"Gas & Oil Auto"},549,"supervisor travel - 1 visit BC & MB - 5000km",750,null,null,"",null,null,750]
[4,{"$f":"IF(C10<1,\" \",VLOOKUP(C10,MainAccountNO:MainAccounts,2,FALSE))","v":"Commercial Travel"},551,"supervisor/coach travel - 1 flight as needed",650,null,null,"",null,null,400]
[5,{"$f":"IF(C11<1,\" \",VLOOKUP(C11,MainAccountNO:MainAccounts,2,FALSE))","v":"Auto Reimbursement"},563,"car rental",250,null,null,"",null,null,250]
[6,{"$f":"IF(C12<1,\" \",VLOOKUP(C12,MainAccountNO:MainAccounts,2,FALSE))","v":"Staff Training"},537,"staff training - resources (6 @ $20)",120,null,null,"",null,null,90]
[7,null,null,null,null,null,null,""]
[8,null,null,"Punjabi Outreach (929)",null,null,null,""]
[9,{"$f":"IF(C15<1,\" \",VLOOKUP(C15,MainAccountNO:MainAccounts,2,FALSE))","v":"Gifts in hand"},400,"apx balance on hand @ 03/31/2024",30,null,null,"",null,null,30]
[10,{"$f":"IF(C16<1,\" \",VLOOKUP(C16,MainAccountNO:MainAccounts,2,FALSE))","v":"Project Income - CND Ind"},440,"For Punjabi outreach (fundraising by missionary)",7260,null,null,"",null,null,7260]
[11,{"$f":"IF(C17<1,\" \",VLOOKUP(C17,MainAccountNO:MainAccounts,2,FALSE))","v":"Project Income - US"},442,"For Punjabi outreach (fundraising by missionary)",0,null,null,"",null,null,0]
[12,{"$f":"IF(C18<1,\" \",VLOOKUP(C18,MainAccountNO:MainAccounts,2,FALSE))","v":"Special Projects"},580,"Christmas celebrations/outreach",1800,null,null,"",null,null,1800]
[13,{"$f":"IF(C19<1,\" \",VLOOKUP(C19,MainAccountNO:MainAccounts,2,FALSE))","v":"Special Projects"},580,"Other Punjabi outreach (i.e. ESL)",1500,null,null,"",null,null,1500]
[14,{"$f":"IF(C20<1,\" \",VLOOKUP(C20,MainAccountNO:MainAccounts,2,FALSE))","v":"Special Projects"},580,"Punjabi church development",1500,null,null,null,null,null,1500]
[15,{"$f":"IF(C21<1,\" \",VLOOKUP(C21,MainAccountNO:MainAccounts,2,FALSE))","v":"Operations Assessment"},484,"operations assessment",-726,null,null,"",null,null,-726]
[16,null,null,null,null,null,null,""]
[17,null,null,"Punjabi Literature (928)",null,null,null,""]
[18,{"$f":"IF(C24<1,\" \",VLOOKUP(C24,MainAccountNO:MainAccounts,2,FALSE))","v":"Gifts in hand"},400,"apx balance on hand @ 03/31/2024",13375,null,null,"",null,null,13375]
[19,{"$f":"IF(C25<1,\" \",VLOOKUP(C25,MainAccountNO:MainAccounts,2,FALSE))","v":"Special Projects"},580,"Punjabi Literature",13375,null,null,"",null,null,13375]
[20,null,null,null,null,null,null,""]
[21,null,null,"EIM Staffing",null,null,null,""]
[22,{"$f":"IF(C28<1,\" \",VLOOKUP(C28,MainAccountNO:MainAccounts,2,FALSE))","v":"US Gifts"},430,"Erastus US support",600,null,null,"",null,null,600]
[23,{"$f":"IF(C29<1,\" \",VLOOKUP(C29,MainAccountNO:MainAccounts,2,FALSE))","v":"Canadian Gifts-Staff"},410,"Erastus CDN support",40825,null,null,"",null,null,51400]
[24,{"$f":"IF(C30<1,\" \",VLOOKUP(C30,MainAccountNO:MainAccounts,2,FALSE))","v":"Ministry Expense"},587,"Erastus MER",0,null,null,"",null,null,0]
[25,{"$f":"IF(C31<1,\" \",VLOOKUP(C31,MainAccountNO:MainAccounts,2,FALSE))","v":"Salary Expense"},591,"Erastus salary",{"$f":"0.9*(E28+E29)-E30","v":37282.5},null,null,"",null,null,46800]
[26,{"$f":"IF(C32<1,\" \",VLOOKUP(C32,MainAccountNO:MainAccounts,2,FALSE))","v":"US Gifts"},430,"Paras US Support",0,null,null,"",null,null,0]
[27,{"$f":"IF(C33<1,\" \",VLOOKUP(C33,MainAccountNO:MainAccounts,2,FALSE))","v":"Canadian Gifts-Staff"},410,"Paras CDN Support",14425,null,null,"",null,null,11270]
[28,{"$f":"IF(C34<1,\" \",VLOOKUP(C34,MainAccountNO:MainAccounts,2,FALSE))","v":"Ministry Expense"},587,"Paras MER",4550,null,null,"",null,null,3100]
[29,{"$f":"IF(C35<1,\" \",VLOOKUP(C35,MainAccountNO:MainAccounts,2,FALSE))","v":"Salary Expense"},591,"Paras Salary",{"$f":"(E32+E33)-E34-1500","v":8375},null,null,"",null,null,6670]
[30,{"$f":"IF(C36<1,\" \",VLOOKUP(C36,MainAccountNO:MainAccounts,2,FALSE))","v":"US Gifts"},430,"Tobin US Support",20650,null,null,"",null,null,12455]
[31,{"$f":"IF(C37<1,\" \",VLOOKUP(C37,MainAccountNO:MainAccounts,2,FALSE))","v":"Canadian Gifts-Staff"},410,"Tobin CDN Support",24725,null,null,"",null,null,33215]
[32,{"$f":"IF(C38<1,\" \",VLOOKUP(C38,MainAccountNO:MainAccounts,2,FALSE))","v":"Ministry Expense"},587,"Tobin MER",0,null,null,"",null,null,0]
[33,{"$f":"IF(C39<1,\" \",VLOOKUP(C39,MainAccountNO:MainAccounts,2,FALSE))","v":"Salary Expense"},591,"Tobin Salary",{"$f":"0.9*(E36+E37)-E38","v":40837.5},null,null,"",null,null,41103]
[34,{"$f":"IF(C40<1,\" \",VLOOKUP(C40,MainAccountNO:MainAccounts,2,FALSE))","v":"Operations Assessment"},484,"operations assessment",{"$f":"-0.1*(E28+E29+E36+E37)-1500","v":-10180},null,null,"",null,null,-11267]

{"sheet":"S5","index":8,"n_rows":72,"n_cols":11,"rows_kept":72,"cut":false,"hidden":false,"merged":[[0,8,5,8],[0,9,5,9]]}
[null,"Anchored Warriors",15,"Choose Rank Number -------->",null,null,10,null,"Amount of 23/24 budget spent by Oct 31","Total From Last 12 Months - Nov22-Oct23","Last Budget"]
[null,null,null,"Total Income",{"$f":"SUM(IF(S_5FieldRank<=S_5Choice,IF(S_5AccNO<=LastIncome,S_5Amount,0),0))","v":29138},null,null,null,null,null,"23/24"]
[null,null,null,"Total Expense",{"$f":"SUM(IF(S_5FieldRank<=S_5Choice,IF(S_5AccNO>LastIncome,S_5Amount,0),0))","v":28249}]
[null,null,null,"Difference",{"$f":"E2-E3","v":889}]
["Line","Account Description","Acc_NO","Field Detail","Amount","Month","Rank","Out"]
[]
[1,null,null,"AW Ministry (957)"]
[2,{"$f":"IF(C8<1,\" \",VLOOKUP(C8,MainAccountNO:MainAccounts,2,FALSE))","v":"Gifts in hand"},400,"apx balance on hand @ 03/31/2024",5000,null,null,{"$f":"IF(G8<=$G$1,\"\",\"OUT\")","v":""},null,null,16500]
[3,{"$f":"IF(C9<1,\" \",VLOOKUP(C9,MainAccountNO:MainAccounts,2,FALSE))","v":"Project Income - CND Ind"},440,"CAN individuals",2500,null,null,{"$f":"IF(G9<=$G$1,\"\",\"OUT\")","v":""},null,2369.4499999999998,7000]
[4,{"$f":"IF(C10<1,\" \",VLOOKUP(C10,MainAccountNO:MainAccounts,2,FALSE))","v":"Project Income - CDN Churches"},441,"CAN churches",2500,null,null,{"$f":"IF(G10<=$G$1,\"\",\"OUT\")","v":""},null,285,9500]
[5,{"$f":"IF(C11<1,\" \",VLOOKUP(C11,MainAccountNO:MainAccounts,2,FALSE))","v":"Operations Assessment"},484,"assessment on donations",-50,null,null,{"$f":"IF(G11<=$G$1,\"\",\"OUT\")","v":""},null,null,-1685]
[6,{"$f":"IF(C12<1,\" \",VLOOKUP(C12,MainAccountNO:MainAccounts,2,FALSE))","v":" "}]
[7,{"$f":"IF(C13<1,\" \",VLOOKUP(C13,MainAccountNO:MainAccounts,2,FALSE))","v":" "},null,"Admin"]
[8,{"$f":"IF(C14<1,\" \",VLOOKUP(C14,MainAccountNO:MainAccounts,2,FALSE))","v":"Royalties/Fees"},530,"domain & web page",100,null,null,null,77,77,350]
[9,{"$f":"IF(C15<1,\" \",VLOOKUP(C15,MainAccountNO:MainAccounts,2,FALSE))","v":"Royalties/Fees"},530,"Police checks",55,null,null,null,55,55,45]
[10,{"$f":"IF(C16<1,\" \",VLOOKUP(C16,MainAccountNO:MainAccounts,2,FALSE))","v":"Advertising"},503,"general advertising",100,null,null,null,null,null,150]
[11,{"$f":"IF(C17<1,\" \",VLOOKUP(C17,MainAccountNO:MainAccounts,2,FALSE))","v":"Office Supply"},532,"office supplies",50,null,null,null,null,null,50]
[12,{"$f":"IF(C18<1,\" \",VLOOKUP(C18,MainAccountNO:MainAccounts,2,FALSE))","v":"General Supply & Service"},545,"general supplies",500,null,null,null,null,null,500]
[13,{"$f":"IF(C19<1,\" \",VLOOKUP(C19,MainAccountNO:MainAccounts,2,FALSE))","v":"Bldg, Equip & Liab. Ins."},519,"insurance for events",750]
[14,{"$f":"IF(C20<1,\" \",VLOOKUP(C20,MainAccountNO:MainAccounts,2,FALSE))","v":" "}]
[15,{"$f":"IF(C21<1,\" \",VLOOKUP(C21,MainAccountNO:MainAccounts,2,FALSE))","v":" "},null,"AW Van Lease",null,null,null,{"$f":"IF(G21<=$G$1,\"\",\"OUT\")","v":""}]
[16,{"$f":"IF(C22<1,\" \",VLOOKUP(C22,MainAccountNO:MainAccounts,2,FALSE))","v":"Auto Maintenance"},550,"Vehicle repairs and maintenance",5000,null,null,""]
[17,{"$f":"IF(C23<1,\" \",VLOOKUP(C23,MainAccountNO:MainAccounts,2,FALSE))","v":"Bldg, Equip & Liab. Ins."},519,"Insurance for Van",1825,null,null,""]
[18,{"$f":"IF(C24<1,\" \",VLOOKUP(C24,MainAccountNO:MainAccounts,2,FALSE))","v":"Auto Maintenance"},550,"B.C Safety Inspection",600,null,null,""]
[19]
[20,{"$f":"IF(C26<1,\" \",VLOOKUP(C26,MainAccountNO:MainAccounts,2,FALSE))","v":" "},null,"AW Network Training ",null,null,null,""]
[21,{"$f":"IF(C27<1,\" \",VLOOKUP(C27,MainAccountNO:MainAccounts,2,FALSE))","v":"Food for Outreach/Meetings"},515,"Food",null,null,null,"",null,171]
[22,{"$f":"IF(C28<1,\" \",VLOOKUP(C28,MainAccountNO:MainAccounts,2,FALSE))","v":"Special Projects"},580,"facility rental",null,null,null,""]
[23,{"$f":"IF(C29<1,\" \",VLOOKUP(C29,MainAccountNO:MainAccounts,2,FALSE))","v":"General Supply & Service"},545,"Supplies",null,null,null,"",null,307]
[24,{"$f":"IF(C30<1,\" \",VLOOKUP(C30,MainAccountNO:MainAccounts,2,FALSE))","v":"Gas & Oil Auto"},549,"Gas",null,null,null,"",null,121]
[25,{"$f":"IF(C31<1,\" \",VLOOKUP(C31,MainAccountNO:MainAccounts,2,FALSE))","v":"Food for Outreach/Meetings"},515,"Food",null,null,null,null,null,150]
[26,{"$f":"IF(C32<1,\" \",VLOOKUP(C32,MainAccountNO:MainAccounts,2,FALSE))","v":" "}]
[27,{"$f":"IF(C33<1,\" \",VLOOKUP(C33,MainAccountNO:MainAccounts,2,FALSE))","v":" "},null,"Regular Community Outreach"]
[28,{"$f":"IF(C34<1,\" \",VLOOKUP(C34,MainAccountNO:MainAccounts,2,FALSE))","v":" "},null,"Eden Valley (965)"]
[29,{"$f":"IF(C35<1,\" \",VLOOKUP(C35,MainAccountNO:MainAccounts,2,FALSE))","v":"Gifts in hand"},400,"Transfer from Restora Project",4200]
[30,{"$f":"IF(C36<1,\" \",VLOOKUP(C36,MainAccountNO:MainAccounts,2,FALSE))","v":"Gifts in hand"},400,"apx balance on hand @ 03/31/2024",0]
[31,{"$f":"IF(C37<1,\" \",VLOOKUP(C37,MainAccountNO:MainAccounts,2,FALSE))","v":"Project Income - CND Ind"},440,"CAN individuals",5000]
[32,{"$f":"IF(C38<1,\" \",VLOOKUP(C38,MainAccountNO:MainAccounts,2,FALSE))","v":"Project Income - CDN Churches"},441,"CAN churches",5200]
[33,{"$f":"IF(C39<1,\" \",VLOOKUP(C39,MainAccountNO:MainAccounts,2,FALSE))","v":"Operations Assessment"},484,"assessment on donations",-102]
[34,{"$f":"IF(C40<1,\" \",VLOOKUP(C40,MainAccountNO:MainAccounts,2,FALSE))","v":"Auto Reimbursement"},563,"Vehicle rental ",3740,null,null,{"$f":"IF(G40<=$G$1,\"\",\"OUT\")","v":""},3270,5920]
[35,{"$f":"IF(C41<1,\" \",VLOOKUP(C41,MainAccountNO:MainAccounts,2,FALSE))","v":"Gas & Oil Auto"},549,"Fuel rental vehicles",870,null,null,{"$f":"IF(G41<=$G$1,\"\",\"OUT\")","v":""},485,725]
[36,{"$f":"IF(C42<1,\" \",VLOOKUP(C42,MainAccountNO:MainAccounts,2,FALSE))","v":"Food for Outreach/Meetings"},515,"snacks (12 x $75)",1080,null,null,{"$f":"IF(G42<=$G$1,\"\",\"OUT\")","v":""},650,882]
[37,{"$f":"IF(C43<1,\" \",VLOOKUP(C43,MainAccountNO:MainAccounts,2,FALSE))","v":"General Supply & Service"},545,"misc resources",1650,null,null,"",128,{"$f":"50+420","v":470}]
[38,{"$f":"IF(C44<1,\" \",VLOOKUP(C44,MainAccountNO:MainAccounts,2,FALSE))","v":"Royalties/Fees"},530,"$120 x 21 participant fees (balance from fundraising/band)",2530,null,null,"",null,280]
[39,{"$f":"IF(C45<1,\" \",VLOOKUP(C45,MainAccountNO:MainAccounts,2,FALSE))","v":"Food for Outreach/Meetings"},515,"Youth Conference trip - meals",884,null,null,""]
[40,{"$f":"IF(C46<1,\" \",VLOOKUP(C46,MainAccountNO:MainAccounts,2,FALSE))","v":"Auto Reimbursement"},563,"Youth Conference trip - van rental",4995,null,null,""]
[41,{"$f":"IF(C47<1,\" \",VLOOKUP(C47,MainAccountNO:MainAccounts,2,FALSE))","v":"Gas & Oil Auto"},549,"Youth Conference trip - gas",970,null,null,""]
[42,{"$f":"IF(C48<1,\" \",VLOOKUP(C48,MainAccountNO:MainAccounts,2,FALSE))","v":" "}]
[43,{"$f":"IF(C49<1,\" \",VLOOKUP(C49,MainAccountNO:MainAccounts,2,FALSE))","v":" "},null,"Kamloops "]
[44,{"$f":"IF(C50<1,\" \",VLOOKUP(C50,MainAccountNO:MainAccounts,2,FALSE))","v":"Gifts in hand"},400,"apx balance on hand @ 03/31/2024"]
[45,{"$f":"IF(C51<1,\" \",VLOOKUP(C51,MainAccountNO:MainAccounts,2,FALSE))","v":"Project Income - CND Ind"},440,"CAN individuals"]
[46,{"$f":"IF(C52<1,\" \",VLOOKUP(C52,MainAccountNO:MainAccounts,2,FALSE))","v":"Project Income - CDN Churches"},441,"CAN churches"]
[47,{"$f":"IF(C53<1,\" \",VLOOKUP(C53,MainAccountNO:MainAccounts,2,FALSE))","v":"Operations Assessment"},484,"assessment on donations"]
[48,{"$f":"IF(C54<1,\" \",VLOOKUP(C54,MainAccountNO:MainAccounts,2,FALSE))","v":"Gas & Oil Auto"},549,"Youth Conference trip - gas",null,null,null,null,null,{"$f":"50+255","v":305}]
[49,{"$f":"IF(C55<1,\" \",VLOOKUP(C55,MainAccountNO:MainAccounts,2,FALSE))","v":"Food for Outreach/Meetings"},515,"Youth Conference trip - meals",null,null,null,null,null,{"$f":"162+80","v":242}]
[50,{"$f":"IF(C56<1,\" \",VLOOKUP(C56,MainAccountNO:MainAccounts,2,FALSE))","v":"Auto Reimbursement"},563,"Youth Conference trip - vehicle rental"]
[51,{"$f":"IF(C57<1,\" \",VLOOKUP(C57,MainAccountNO:MainAccounts,2,FALSE))","v":"Special Projects"},580,"Youth Conference trip- facility rental"]
[52,{"$f":"IF(C58<1,\" \",VLOOKUP(C58,MainAccountNO:MainAccounts,2,FALSE))","v":"Special Projects"},580,"Winter retreat",550,null,null,null,1800,1800]
[53,{"$f":"IF(C59<1,\" \",VLOOKUP(C59,MainAccountNO:MainAccounts,2,FALSE))","v":" "}]
[54,{"$f":"IF(C60<1,\" \",VLOOKUP(C60,MainAccountNO:MainAccounts,2,FALSE))","v":" "},null,"Lethbridge"]
[55,{"$f":"IF(C61<1,\" \",VLOOKUP(C61,MainAccountNO:MainAccounts,2,FALSE))","v":"Gifts in hand"},400,"apx balance on hand @ 03/31/2024"]
[56,{"$f":"IF(C62<1,\" \",VLOOKUP(C62,MainAccountNO:MainAccounts,2,FALSE))","v":"Project Income - CND Ind"},440,"CAN individuals"]
[57,{"$f":"IF(C63<1,\" \",VLOOKUP(C63,MainAccountNO:MainAccounts,2,FALSE))","v":"Project Income - CDN Churches"},441,"CAN churches"]
[58,{"$f":"IF(C64<1,\" \",VLOOKUP(C64,MainAccountNO:MainAccounts,2,FALSE))","v":"Operations Assessment"},484,"assessment on donations"]
[59,{"$f":"IF(C65<1,\" \",VLOOKUP(C65,MainAccountNO:MainAccounts,2,FALSE))","v":"Gas & Oil Auto"},549,"Youth Conference trip- gas"]
[60,{"$f":"IF(C66<1,\" \",VLOOKUP(C66,MainAccountNO:MainAccounts,2,FALSE))","v":"Auto Reimbursement"},563,"Youth Conference trip - vehicle rental"]
[61,{"$f":"IF(C67<1,\" \",VLOOKUP(C67,MainAccountNO:MainAccounts,2,FALSE))","v":"Royalties/Fees"},530,"Participant fees"]
[62,{"$f":"IF(C68<1,\" \",VLOOKUP(C68,MainAccountNO:MainAccounts,2,FALSE))","v":"General Supply & Service"},545,"General youth supplies",null,null,null,""]
[63,{"$f":"IF(C69<1,\" \",VLOOKUP(C69,MainAccountNO:MainAccounts,2,FALSE))","v":" "}]
[64,{"$f":"IF(C70<1,\" \",VLOOKUP(C70,MainAccountNO:MainAccounts,2,FALSE))","v":" "},null,"Mentoring Trips (963)"]
[65,{"$f":"IF(C71<1,\" \",VLOOKUP(C71,MainAccountNO:MainAccounts,2,FALSE))","v":"Gifts in hand"},400,"apx balance on hand @ 03/31/2024",4890,null,null,""]
[66,{"$f":"IF(C72<1,\" \",VLOOKUP(C72,MainAccountNO:MainAccounts,2,FALSE))","v":"Special Projects"},580,"Youth conference trip",2000,null,null,{"$f":"IF(G72<=$G$1,\"\",\"OUT\")","v":""}]

{"sheet":"S6","index":9,"n_rows":39,"n_cols":11,"rows_kept":39,"cut":false,"hidden":false,"merged":[[0,8,5,8],[0,9,5,9]]}
[null,"Native Bible Centre",10,"Choose Rank Number -------->",null,null,10,null,"Amount of 23/24 budget spent by Oct 31","Total From Last 12 Months - Nov22-Oct23","Last Budget"]
[null,null,null,"Total Income",{"$f":"SUM(IF(S_6FieldRank<=S_6Choice,IF(S_6AccNO<=LastIncome,S_6Amount,0),0))","v":87881},null,null,null,null,null,"23/24"]
[null,null,null,"Total Expense",{"$f":"SUM(IF(S_6FieldRank<=S_6Choice,IF(S_6AccNO>LastIncome,S_6Amount,0),0))","v":64158.5}]
[null,null,null,"Difference",{"$f":"E2-E3","v":23722.5}]
["Line","Account Description","Acc_NO","Field Detail","Amount"]
[]
[1,{"$f":"IF(C7<1,\" \",VLOOKUP(C7,MainAccountNO:MainAccounts,2,FALSE))","v":"Gifts in hand"},400,"apx balance on hand @ 03/31/2024",11000,null,null,{"$f":"IF(G7<=$G$1,\"\",\"OUT\")","v":""}]
[2,{"$f":"IF(C8<1,\" \",VLOOKUP(C8,MainAccountNO:MainAccounts,2,FALSE))","v":"Project Income - CND Ind"},440,"Canadian donations",600,null,null,{"$f":"IF(G8<=$G$1,\"\",\"OUT\")","v":""},null,600,600]
[3,{"$f":"IF(C9<1,\" \",VLOOKUP(C9,MainAccountNO:MainAccounts,2,FALSE))","v":"Project Income - CDN Churches"},441,"Canadian donations",300,null,null,null,null,271,500]
[4,{"$f":"IF(C10<1,\" \",VLOOKUP(C10,MainAccountNO:MainAccounts,2,FALSE))","v":"US Gifts"},430,"US donations",250,null,null,"",null,335,200]
[5,{"$f":"IF(C11<1,\" \",VLOOKUP(C11,MainAccountNO:MainAccounts,2,FALSE))","v":"Tuition Income"},445,"student tuition fees",50,null,null,"",null,null,50]
[6,{"$f":"IF(C12<1,\" \",VLOOKUP(C12,MainAccountNO:MainAccounts,2,FALSE))","v":"Operations Assessment"},484,"operations assessment",-115,null,null,"",null,null,-130]
[7,{"$f":"IF(C13<1,\" \",VLOOKUP(C13,MainAccountNO:MainAccounts,2,FALSE))","v":"Sales"},460,"course sales",700,null,null,"",null,893,200]
[8,{"$f":"IF(C14<1,\" \",VLOOKUP(C14,MainAccountNO:MainAccounts,2,FALSE))","v":"Gas & Oil Auto"},549,"supervision/staff visits (2 visits)",100,null,null,"",null,null,100]
[9,{"$f":"IF(C15<1,\" \",VLOOKUP(C15,MainAccountNO:MainAccounts,2,FALSE))","v":"Staff Training"},537,"staff training (2 @ $20)",40,null,null,"",null,null,45]
[10]
[11,null,null,"NBC Operation (010)",null,null,null,""]
[12,{"$f":"IF(C18<1,\" \",VLOOKUP(C18,MainAccountNO:MainAccounts,2,FALSE))","v":"Equip. Maint."},527,"copier costs",400,null,null,"",null,312,850]
[13,{"$f":"IF(C19<1,\" \",VLOOKUP(C19,MainAccountNO:MainAccounts,2,FALSE))","v":"Royalties/Fees"},530,"domain renewal",150,null,null,"",null,138.69,150]
[14,{"$f":"IF(C20<1,\" \",VLOOKUP(C20,MainAccountNO:MainAccounts,2,FALSE))","v":"Office Supply"},532,"paper, binding materials, etc.",600,null,null,"",null,626,1000]
[15,{"$f":"IF(C21<1,\" \",VLOOKUP(C21,MainAccountNO:MainAccounts,2,FALSE))","v":"Postage & Parcels"},533,"Mailing books to students",450,null,null,"",null,371,250]
[16,{"$f":"IF(C22<1,\" \",VLOOKUP(C22,MainAccountNO:MainAccounts,2,FALSE))","v":"Seminars & Registration"},538,"representation & fundraising",100,null,null,"",null,null,200]
[17,{"$f":"IF(C23<1,\" \",VLOOKUP(C23,MainAccountNO:MainAccounts,2,FALSE))","v":"General Supply & Service"},545,"texts, commentaries",200,null,null,"",null,53,600]
[18,{"$f":"IF(C24<1,\" \",VLOOKUP(C24,MainAccountNO:MainAccounts,2,FALSE))","v":"Motel/Hotel"},546,"representation & fundraising travel (8 nights @ $125)",500,null,null,"",null,null,1000]
[19,{"$f":"IF(C25<1,\" \",VLOOKUP(C25,MainAccountNO:MainAccounts,2,FALSE))","v":"Telephone"},547,"telephone",25,null,null,"",null,null,25]
[20,{"$f":"IF(C26<1,\" \",VLOOKUP(C26,MainAccountNO:MainAccounts,2,FALSE))","v":"Gas & Oil Auto"},549,"representation & fundraising (apx 6000 km)",240,null,null,"",null,null,720]
[21,null,null,null,null,null,null,""]
[22,null,null,"NBC Staffing",null,null,null,""]
[23,{"$f":"IF(C29<1,\" \",VLOOKUP(C29,MainAccountNO:MainAccounts,2,FALSE))","v":"US Gifts"},430,"Dabrowski US Support",4050,null,null,"",null,null,4000]
[24,{"$f":"IF(C30<1,\" \",VLOOKUP(C30,MainAccountNO:MainAccounts,2,FALSE))","v":"Canadian Gifts-Staff"},410,"Dabrowski CDN Support",23815,{"$f":"0.1*(E29+E30)","v":2786.5},null,"",null,null,22250]
[25,{"$f":"IF(C31<1,\" \",VLOOKUP(C31,MainAccountNO:MainAccounts,2,FALSE))","v":"Ministry Expense"},587,"Dabrowski MER",0,null,null,"",null,null,0]
[26,{"$f":"IF(C32<1,\" \",VLOOKUP(C32,MainAccountNO:MainAccounts,2,FALSE))","v":"Salary Expense"},591,"Dabrowski Salary",{"$f":"0.9*(E29+E30)-E31","v":25078.5},null,null,"",null,null,23625]
[27,{"$f":"IF(C33<1,\" \",VLOOKUP(C33,MainAccountNO:MainAccounts,2,FALSE))","v":"Operations Assessment"},484,"operations assessment",{"$f":"-0.1*(E29+E30)","v":-2786.5},null,null,"",null,null,-13972]
[28,{"$f":"IF(C34<1,\" \",VLOOKUP(C34,MainAccountNO:MainAccounts,2,FALSE))","v":" "},null,null,null,null,null,""]
[29,{"$f":"IF(C35<1,\" \",VLOOKUP(C35,MainAccountNO:MainAccounts,2,FALSE))","v":" "},null,"Retired Staff (5% assessment)",null,null,null,""]
[30,{"$f":"IF(C36<1,\" \",VLOOKUP(C36,MainAccountNO:MainAccounts,2,FALSE))","v":"US Gifts"},430,"Houston US Support",45450,null,null,""]
[31,{"$f":"IF(C37<1,\" \",VLOOKUP(C37,MainAccountNO:MainAccounts,2,FALSE))","v":"Canadian Gifts-Staff"},410,"Houston CDN Support",7200,null,null,""]
[32,{"$f":"IF(C38<1,\" \",VLOOKUP(C38,MainAccountNO:MainAccounts,2,FALSE))","v":"Retirement Allowance"},593,"Houston Salary",36275,null,null,""]
[33,{"$f":"IF(C39<1,\" \",VLOOKUP(C39,MainAccountNO:MainAccounts,2,FALSE))","v":"Operations Assessment"},484,"operations assessment",{"$f":"-0.05*(E36+E37)","v":-2632.5},null,null,""]

{"sheet":"S7","index":10,"n_rows":23,"n_cols":12,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,0,0,1],[0,8,5,8],[0,9,5,9]]}
["Collaborative Ministries",null,60,"Choose Rank Number -------->",null,null,10,null,"Amount of 23/24 budget spent by Oct 31","Total From Last 12 Months - Nov22-Oct23","Last Budget"]
[null,null,null,"Total Income",{"$f":"SUM(IF(S_7FieldRank<=S_7Choice,IF(S_7AccNO<=LastIncome,S_7Amount,0),0))","v":115000},null,null,null,null,null,"23/24"]
[null,null,null,"Total Expense",{"$f":"SUM(IF(S_7FieldRank<=S_7Choice,IF(S_7AccNO>LastIncome,S_7Amount,0),0))","v":116160}]
[null,null,null,"Difference",{"$f":"E2-E3","v":-1160}]
["Line","Account Description","Acc_NO","Field Detail","Amount"]
[]
[1,null,null,"Opportunity Development (942)",null,null,null,{"$f":"IF(G7<=$G$1,\"\",\"OUT\")","v":""}]
[2,{"$f":"IF(C8<1,\" \",VLOOKUP(C8,MainAccountNO:MainAccounts,2,FALSE))","v":"Special Projects"},580,"new ministry research & development",500,null,null,"",null,null,500]
[3,null,null,null,null,null,null,""]
[4,null,null,"Native Ministry Networking (951)",null,null,null,""]
[5,{"$f":"IF(C11<1,\" \",VLOOKUP(C11,MainAccountNO:MainAccounts,2,FALSE))","v":"Motel/Hotel"},546,"Registrations - Field Director",160,null,null,"",null,null,160]
[6,{"$f":"IF(C12<1,\" \",VLOOKUP(C12,MainAccountNO:MainAccounts,2,FALSE))","v":"Gas & Oil Auto"},549,"2600 km (Houston, BC)",500,null,null,{"$f":"IF(G12<=$G$1,\"\",\"OUT\")","v":""},null,null,500]
[7,null,null,null,null,null,null,""]
[8,null,null,"Centre for Intercultural Training (CIT)",null,null,null,""]
[9,{"$f":"IF(C15<1,\" \",VLOOKUP(C15,MainAccountNO:MainAccounts,2,FALSE))","v":"Commercial Travel"},551,"IMC leadership - travel to CIT",null,null,null,"",null,null,750]
[10,{"$f":"IF(C16<1,\" \",VLOOKUP(C16,MainAccountNO:MainAccounts,2,FALSE))","v":"Auto Reimbursement"},563,"vehicle rental",null,null,null,"",null,null,400]
[11,{"$f":"IF(C17<1,\" \",VLOOKUP(C17,MainAccountNO:MainAccounts,2,FALSE))","v":"Royalties/Fees"},530,"annual member fee",null,null,null,"",null,503,800,"Did we end our membership? Yes, we are no longer members."]
[12,{"$f":"IF(C18<1,\" \",VLOOKUP(C18,MainAccountNO:MainAccounts,2,FALSE))","v":"Gas & Oil Auto"},549,"gas for rental vehicle",null,null,null,"",null,null,150]
[13,{"$f":"IF(C19<1,\" \",VLOOKUP(C19,MainAccountNO:MainAccounts,2,FALSE))","v":"Motel/Hotel"},546,"1 night",null,null,null,null,null,null,125]
[14,null,null,null,null,null,null,""]
[15,null,null,"Joint Ministries Agreement (dept 90)",null,null,null,""]
[16,{"$f":"IF(C22<1,\" \",VLOOKUP(C22,MainAccountNO:MainAccounts,2,FALSE))","v":"Canadian Gifts-Staff"},410,"gifts for IMI personnel",115000,null,null,"",null,null,115000,"based on the 12 months of 2023, including Smith CAD donations"]
[17,{"$f":"IF(C23<1,\" \",VLOOKUP(C23,MainAccountNO:MainAccounts,2,FALSE))","v":"Gifts to Affiliated Org."},517,"to IMI for joint ministries",115000,null,null,"",null,null,115000]

{"sheet":"S8","index":11,"n_rows":47,"n_cols":11,"rows_kept":47,"cut":false,"hidden":false,"merged":[[0,8,5,8],[0,9,5,9]]}
[null,"Member Care",30,"Choose Rank Number -------->",null,null,10,null,"Amount of 23/24 budget spent by Oct 31","Total From Last 12 Months - Nov22-Oct23","Last Budget"]
[null,null,null,"Total Income",{"$f":"SUM(IF(S_8FieldRank<=S_8Choice,IF(S_8AccNO<=LastIncome,S_8Amount,0),0))","v":106158},null,null,null,null,null,"23/24"]
[null,null,null,"Total Expense",{"$f":"SUM(IF(S_8FieldRank<=S_8Choice,IF(S_8AccNO>LastIncome,S_8Amount,0),0))","v":104703}]
[null,null,null,"Difference",{"$f":"E2-E3","v":1455}]
["Line","Account Description","Acc_NO","Field Detail","Amount",null,"Rank","Out"]
[null,{"$f":"IF(C6<1,\" \",VLOOKUP(C6,MainAccountNO:MainAccounts,2,FALSE))","v":" "},null,null,null,null,null,{"$f":"IF(G6<=$G$1,\"\",\"OUT\")","v":""}]
[1,{"$f":"IF(C7<1,\" \",VLOOKUP(C7,MainAccountNO:MainAccounts,2,FALSE))","v":"Member Care"},542,"cards, flowers, etc - bereavement & birthdays",600,null,null,{"$f":"IF(G7<=$G$1,\"\",\"OUT\")","v":""},80,80,600]
[2,{"$f":"IF(C8<1,\" \",VLOOKUP(C8,MainAccountNO:MainAccounts,2,FALSE))","v":"Member Care"},542,"member care as needed ED or FD emergency travel etc.",600,null,null,"",null,null,600]
[3,{"$f":"IF(C9<1,\" \",VLOOKUP(C9,MainAccountNO:MainAccounts,2,FALSE))","v":"Member Care"},542,"FD random acts of kindness",400,null,null,"",null,null,400]
[4,{"$f":"IF(C10<1,\" \",VLOOKUP(C10,MainAccountNO:MainAccounts,2,FALSE))","v":"Member Care"},542,"ED random acts of kindness",400,null,null,"",null,null,400]
[5,{"$f":"IF(C11<1,\" \",VLOOKUP(C11,MainAccountNO:MainAccounts,2,FALSE))","v":"Motel/Hotel"},546,"2 nights lodging",250,null,null,"",null,null,250]
[6,{"$f":"IF(C12<1,\" \",VLOOKUP(C12,MainAccountNO:MainAccounts,2,FALSE))","v":"Gas & Oil Auto"},549,"gas reimbursement (apx. 1500 km)",225,null,null,"",null,null,225]
[7,{"$f":"IF(C13<1,\" \",VLOOKUP(C13,MainAccountNO:MainAccounts,2,FALSE))","v":"Member Care"},542,"Mentoring expenses at ED & FD joint decision",300,null,null,null,null,null,300]
[8,{"$f":"IF(C14<1,\" \",VLOOKUP(C14,MainAccountNO:MainAccounts,2,FALSE))","v":"Gifts in hand"},400,"Memorial Fund (apx balance on hand @ 03/31/2024)",1200,null,null,"",null,null,1200]
[9,{"$f":"IF(C15<1,\" \",VLOOKUP(C15,MainAccountNO:MainAccounts,2,FALSE))","v":"Special Projects"},580,"Memorial Fund expenses",1200,null,null,"",null,null,1200]
[10,{"$f":"IF(C16<1,\" \",VLOOKUP(C16,MainAccountNO:MainAccounts,2,FALSE))","v":"Gifts in hand"},400,"Staff Assistance Fund (apx balance on hand @ 03/31/2024)",8980,null,null,"",null,null,8980]
[11,{"$f":"IF(C17<1,\" \",VLOOKUP(C17,MainAccountNO:MainAccounts,2,FALSE))","v":"Special Projects"},580,"Staff Assistance Fund expenses",8980,null,null,"",null,null,8980]
[12,null,null,null,null,null,null,""]
[13,null,null,"Annual Conference (979)",null,null,null,""]
[14,{"$f":"IF(C20<1,\" \",VLOOKUP(C20,MainAccountNO:MainAccounts,2,FALSE))","v":"Project Income - CND Ind"},440,"Conference offering",1200,null,null,"",1460,1460,1200]
[15,{"$f":"IF(C21<1,\" \",VLOOKUP(C21,MainAccountNO:MainAccounts,2,FALSE))","v":"Operations Assessment"},484,"operations assessment",-120,null,null,"",null,null,-120]
[16,{"$f":"IF(C22<1,\" \",VLOOKUP(C22,MainAccountNO:MainAccounts,2,FALSE))","v":"Missionary Conference"},557,"fee payments for conference",-2000,null,null,"",-8515,-8515,-2000]
[17,{"$f":"IF(C23<1,\" \",VLOOKUP(C23,MainAccountNO:MainAccounts,2,FALSE))","v":"Missionary Conference"},557,"conference speaker travel",1000,null,null,"",885,885,1000]
[18,{"$f":"IF(C24<1,\" \",VLOOKUP(C24,MainAccountNO:MainAccounts,2,FALSE))","v":"Missionary Conference"},557,"conference travel",8500,null,null,"",6358,6358,10000]
[19,{"$f":"IF(C25<1,\" \",VLOOKUP(C25,MainAccountNO:MainAccounts,2,FALSE))","v":"Missionary Conference"},557,"conference facility fees - staff/speaker/board/child care/other",30000,null,null,"",{"$f":"25753+500+2000","v":28253},28253,32000]
[20,{"$f":"IF(C26<1,\" \",VLOOKUP(C26,MainAccountNO:MainAccounts,2,FALSE))","v":"Missionary Conference"},557,"speaker honorarium",1500,null,null,"",1491,1491,1500]
[21,{"$f":"IF(C27<1,\" \",VLOOKUP(C27,MainAccountNO:MainAccounts,2,FALSE))","v":"Missionary Conference"},557,"child & youth care expenses & honorarium",2150,null,null,"",{"$f":"1788","v":1788},1788,3500]
[22,{"$f":"IF(C28<1,\" \",VLOOKUP(C28,MainAccountNO:MainAccounts,2,FALSE))","v":"Missionary Conference"},557,"other conference expenses",1200,null,null,"",1847,{"$f":"1847-305","v":1542},750]
[23,null,null," Retreat",null,null,null,""]
[24,{"$f":"IF(C30<1,\" \",VLOOKUP(C30,MainAccountNO:MainAccounts,2,FALSE))","v":"Special Projects"},580,"Staff Retreat",1500,null,null,"",null,null,1500]
[25]
[26,null,null,"Advanced Ministry Training (962)",null,null,null,""]
[27,{"$f":"IF(C33<1,\" \",VLOOKUP(C33,MainAccountNO:MainAccounts,2,FALSE))","v":"Gifts in hand"},400,"Aproximate funds in hand (Sewell residual)",65000,null,null,null,null,null,65000]
[28,{"$f":"IF(C34<1,\" \",VLOOKUP(C34,MainAccountNO:MainAccounts,2,FALSE))","v":"Commercial Travel"},551,"travel for leadership development",1500,null,null,"",null,null,1500]
[29,{"$f":"IF(C35<1,\" \",VLOOKUP(C35,MainAccountNO:MainAccounts,2,FALSE))","v":"Staff Training"},537,"Leadership Development",2500,null,null,"",null,null,2500]
[30,{"$f":"IF(C36<1,\" \",VLOOKUP(C36,MainAccountNO:MainAccounts,2,FALSE))","v":"Staff Training"},537,"General missionary training",4500,null,null,"",null,250,4500]
[31,{"$f":"IF(C37<1,\" \",VLOOKUP(C37,MainAccountNO:MainAccounts,2,FALSE))","v":"Staff Training"},537,"staff training scholarships (1 course/unit, max $500)",5000,null,null,"",null,null,5000]
[32,{"$f":"IF(C38<1,\" \",VLOOKUP(C38,MainAccountNO:MainAccounts,2,FALSE))","v":"Commercial Travel"},551,"Worldview Training",3000,null,null,"",null,null,3000]
[33,{"$f":"IF(C39<1,\" \",VLOOKUP(C39,MainAccountNO:MainAccounts,2,FALSE))","v":"Gas & Oil Auto"},549,"Gas - Worldview Training",600,null,null,"",null,null,600]
[34,{"$f":"IF(C40<1,\" \",VLOOKUP(C40,MainAccountNO:MainAccounts,2,FALSE))","v":"Food for Outreach/Meetings"},515,"Food for meetings - Worldview Training",900,null,null,"",null,null,900]
[35]
[36,null,null,"Member Care Staffing",null,null,null,""]
[37,{"$f":"IF(C43<1,\" \",VLOOKUP(C43,MainAccountNO:MainAccounts,2,FALSE))","v":"Canadian Gifts-Staff"},410,"Gonzales CDN Support",16700,null,null,"",null,null,15250]
[38,{"$f":"IF(C44<1,\" \",VLOOKUP(C44,MainAccountNO:MainAccounts,2,FALSE))","v":"US Gifts"},430,"Gonzales US Support",16520,null,null,"",null,null,15830]
[39,{"$f":"IF(C45<1,\" \",VLOOKUP(C45,MainAccountNO:MainAccounts,2,FALSE))","v":"Ministry Expense"},587,"Gonzales MER",0,null,null,"",null,null,0]
[40,{"$f":"IF(C46<1,\" \",VLOOKUP(C46,MainAccountNO:MainAccounts,2,FALSE))","v":"Salary Expense"},591,"Gonzales Salary",{"$f":"0.9*(E43+E44)-E45","v":29898},null,null,"",null,null,27972]
[41,{"$f":"IF(C47<1,\" \",VLOOKUP(C47,MainAccountNO:MainAccounts,2,FALSE))","v":"Operations Assessment"},484,"operations assessment",{"$f":"-0.1*(E43+E44)","v":-3322},null,null,"",null,null,-3108]

{"sheet":"S9","index":12,"n_rows":100,"n_cols":12,"rows_kept":100,"cut":false,"hidden":false,"merged":[[32,9,33,9],[25,11,26,11],[0,8,5,8],[0,9,5,9],[20,9,21,9],[20,8,21,8]]}
[null,"Admin & General",70,"Choose Rank Number -------->",null,null,10,null,"Amount of 23/24 budget spent by Oct 31","Total From Last 12 Months - Nov22-Oct23","Last Budget"]
[null,null,null,"Total Income",{"$f":"SUM(IF(S_9FieldRank<=S_9Choice,IF(S_9AccNO<=LastIncome,S_9Amount,0),0))","v":360318.5},null,null,null,null,null,"23/24"]
[null,null,null,"Total Expense",{"$f":"SUM(IF(S_9FieldRank<=S_9Choice,IF(S_9AccNO>LastIncome,S_9Amount,0),0))","v":290647.5}]
[null,null,null,"Difference",{"$f":"E2-E3","v":69671}]
["Line","Account Description","Acc_NO","Field Detail","Amount"]
[]
[1,{"$f":"IF(C7<1,\" \",VLOOKUP(C7,MainAccountNO:MainAccounts,2,FALSE))","v":"Project Income - CND Ind"},440,"CDN gifts",65000,null,null,{"$f":"IF(G7<=$G$1,\"\",\"OUT\")","v":""},null,70037,60000]
[2,{"$f":"IF(C8<1,\" \",VLOOKUP(C8,MainAccountNO:MainAccounts,2,FALSE))","v":"Project Income - CDN Churches"},441,"CDN gifts - churches",15000,null,null,"",null,19923,10000]
[3,{"$f":"IF(C9<1,\" \",VLOOKUP(C9,MainAccountNO:MainAccounts,2,FALSE))","v":"Project Income - US"},442,"US gifts",10000,null,null,"",null,15957,3000]
[4,{"$f":"IF(C10<1,\" \",VLOOKUP(C10,MainAccountNO:MainAccounts,2,FALSE))","v":"Interest Income"},450,"gain on investments",400,null,null,"",null,{"$f":"99+22970","v":23069},400]
[5,{"$f":"IF(C11<1,\" \",VLOOKUP(C11,MainAccountNO:MainAccounts,2,FALSE))","v":"Other income"},455,"gasoline tax refund",500,null,null,"",null,311,500]
[6,{"$f":"IF(C12<1,\" \",VLOOKUP(C12,MainAccountNO:MainAccounts,2,FALSE))","v":"Other income"},455,"GST refund",6500,null,null,"",null,7700,6500]
[7,{"$f":"IF(C13<1,\" \",VLOOKUP(C13,MainAccountNO:MainAccounts,2,FALSE))","v":"Operations Assessment"},484,"assessment transfer",185370,null,null,"",null,null,224263]
[8,null,null,null,null,null,null,""]
[9,{"$f":"IF(C15<1,\" \",VLOOKUP(C15,MainAccountNO:MainAccounts,2,FALSE))","v":"Small Equip. Purchase"},511,"technology hardware",4500,null,null,"",995,995,4500]
[10,{"$f":"IF(C16<1,\" \",VLOOKUP(C16,MainAccountNO:MainAccounts,2,FALSE))","v":"Small Equip. Purchase"},511,"software licenses - Sage,Office 365 (admin)",3000,null,null,"",85,1990,3000]
[11,{"$f":"IF(C17<1,\" \",VLOOKUP(C17,MainAccountNO:MainAccounts,2,FALSE))","v":"Small Equip. Purchase"},511,"Donor Perfect installation, training, fee",3500,null,null,null,1945,3402,2800]
[12,{"$f":"IF(C18<1,\" \",VLOOKUP(C18,MainAccountNO:MainAccounts,2,FALSE))","v":"Food for Outreach/Meetings"},515,"water, coffee, food supplies for office",200,null,null,"",7,13,200]
[13,{"$f":"IF(C19<1,\" \",VLOOKUP(C19,MainAccountNO:MainAccounts,2,FALSE))","v":"Bldg, Equip & Liab. Ins."},519,"board & staff liability, officer facilities (package)",7050,null,null,"",null,10577,9700]
[14,{"$f":"IF(C20<1,\" \",VLOOKUP(C20,MainAccountNO:MainAccounts,2,FALSE))","v":"Audit & Legal Fees"},521,"audit @ $13K",15000,null,null,"",14606,14606,15000]
[15,{"$f":"IF(C21<1,\" \",VLOOKUP(C21,MainAccountNO:MainAccounts,2,FALSE))","v":"Bldg. Maint."},525,"office cleaning & maintenance",1800,null,null,"",725,1550,1800]
[16,{"$f":"IF(C22<1,\" \",VLOOKUP(C22,MainAccountNO:MainAccounts,2,FALSE))","v":"Bldg. Maint."},525,"yard maintenance (mowing, snow removal)",1000,null,null,"",null,null,1000]
[17,{"$f":"IF(C23<1,\" \",VLOOKUP(C23,MainAccountNO:MainAccounts,2,FALSE))","v":"Equip. Maint."},527,"copier contract ($177/month plus printer fees)",2600,null,null,"",1006,1739,1800]
[18,{"$f":"IF(C24<1,\" \",VLOOKUP(C24,MainAccountNO:MainAccounts,2,FALSE))","v":"Equip. Maint."},527,"technology maintenance/repairs, security camera fee",2600,null,null,"",920,2100,1000]
[19,{"$f":"IF(C25<1,\" \",VLOOKUP(C25,MainAccountNO:MainAccounts,2,FALSE))","v":"Equip. Maint."},527,"yard equipment repair",500,null,null,"",null,0,500]
[20,{"$f":"IF(C26<1,\" \",VLOOKUP(C26,MainAccountNO:MainAccounts,2,FALSE))","v":"Banking Charges"},529,"bank charges",600,null,null,"",332,483,600]
[21,{"$f":"IF(C27<1,\" \",VLOOKUP(C27,MainAccountNO:MainAccounts,2,FALSE))","v":"Banking Charges"},529,"Paysafe charges (debit and credit card)",750,null,null,null,520,4638,9600]
[22,{"$f":"IF(C28<1,\" \",VLOOKUP(C28,MainAccountNO:MainAccounts,2,FALSE))","v":"Royalties/Fees"},530,"background checks for members",150,null,null,"",null,null,150]
[23,{"$f":"IF(C29<1,\" \",VLOOKUP(C29,MainAccountNO:MainAccounts,2,FALSE))","v":"Royalties/Fees"},530,"CCCC dues - Certified Membership, Steer Membership",2000,null,null,"",null,1830,2000]
[24,{"$f":"IF(C30<1,\" \",VLOOKUP(C30,MainAccountNO:MainAccounts,2,FALSE))","v":"Royalties/Fees"},530,"Missio Nexus dues split 50/50 with IMI",675]
[25,{"$f":"IF(C31<1,\" \",VLOOKUP(C31,MainAccountNO:MainAccounts,2,FALSE))","v":"Royalties/Fees"},530,"annual government summary, registry",150,null,null,"",40,145,150]
[26,{"$f":"IF(C32<1,\" \",VLOOKUP(C32,MainAccountNO:MainAccounts,2,FALSE))","v":"Royalties/Fees"},530,"CCLI License",175,null,null,null,null,165,175]
[27,{"$f":"IF(C33<1,\" \",VLOOKUP(C33,MainAccountNO:MainAccounts,2,FALSE))","v":"Office Supply"},532,"paper supplies, envelopes, etc.",1000,null,null,"",893,1136,1500]
[28,{"$f":"IF(C34<1,\" \",VLOOKUP(C34,MainAccountNO:MainAccounts,2,FALSE))","v":"Office Supply"},532,"general supplies",500,null,null,"",167,null,500]
[29,{"$f":"IF(C35<1,\" \",VLOOKUP(C35,MainAccountNO:MainAccounts,2,FALSE))","v":"Postage & Parcels"},533,"receipts & staff mailings",2500,null,null,"",1400,2775,3500]
[30,{"$f":"IF(C36<1,\" \",VLOOKUP(C36,MainAccountNO:MainAccounts,2,FALSE))","v":"Staff Training"},537,"staff training (4 @ $20)",80,null,null,"",null,null,30]
[31,{"$f":"IF(C37<1,\" \",VLOOKUP(C37,MainAccountNO:MainAccounts,2,FALSE))","v":"Staff Training"},537,"Plan to Protect membership",500,null,null,"",453,453,350]
[32,{"$f":"IF(C38<1,\" \",VLOOKUP(C38,MainAccountNO:MainAccounts,2,FALSE))","v":"Seminars & Registration"},538,"bookkeeping/admin seminars",500,null,null,"",null,null,500,"Training in DP?"]
[33,{"$f":"IF(C39<1,\" \",VLOOKUP(C39,MainAccountNO:MainAccounts,2,FALSE))","v":"Rent Expense"},543,"12 @ 600 - lease",7200,null,null,"",4200,7200,7200]
[34,{"$f":"IF(C40<1,\" \",VLOOKUP(C40,MainAccountNO:MainAccounts,2,FALSE))","v":"Rent Expense"},543,"utilities",5500,null,null,"",2440,4203,5500]
[35,{"$f":"IF(C41<1,\" \",VLOOKUP(C41,MainAccountNO:MainAccounts,2,FALSE))","v":"Telephone"},547,"telephone/Internet",1500,null,null,"",730,1314,1500]
[36,{"$f":"IF(C42<1,\" \",VLOOKUP(C42,MainAccountNO:MainAccounts,2,FALSE))","v":"Telephone"},547,"MyFax - internet - 1 year ",175,null,null,"",null,164,155]
[37,{"$f":"IF(C43<1,\" \",VLOOKUP(C43,MainAccountNO:MainAccounts,2,FALSE))","v":"Employment Insurance"},586,"employer portion of employment insurance",28000,null,null,"",null,32200,30000,"consider base salary increase, decrease for retirees"]
[38,{"$f":"IF(C44<1,\" \",VLOOKUP(C44,MainAccountNO:MainAccounts,2,FALSE))","v":"Executive Salaries"},592,"Finance Assistant salary",39890,null,null,"",23267,38180,39890]
[39,{"$f":"IF(C45<1,\" \",VLOOKUP(C45,MainAccountNO:MainAccounts,2,FALSE))","v":"Canada Pension Plan"},585,"Finance Assistant employer CPP",2166,null,null,"",null,null,2166]
[40,{"$f":"IF(C46<1,\" \",VLOOKUP(C46,MainAccountNO:MainAccounts,2,FALSE))","v":"Employment Insurance"},586,"Finance Assistant employer EI",910,null,null,"",null,null,910]
[41,{"$f":"IF(C47<1,\" \",VLOOKUP(C47,MainAccountNO:MainAccounts,2,FALSE))","v":"Auto Reimbursement"},563,"Finance Assistant mileage reimbursement",90,null,null,null,40,70,125]
[42,{"$f":"IF(C48<1,\" \",VLOOKUP(C48,MainAccountNO:MainAccounts,2,FALSE))","v":"Executive Salaries"},592,"NEW Position salary  (Part time Admin 24 hours x $20)",26458,null,null,null,null,null,31200]
[43,{"$f":"IF(C49<1,\" \",VLOOKUP(C49,MainAccountNO:MainAccounts,2,FALSE))","v":"Canada Pension Plan"},585,"New Postion employer CPP",1365,null,null,null,null,null,1648]
[44,{"$f":"IF(C50<1,\" \",VLOOKUP(C50,MainAccountNO:MainAccounts,2,FALSE))","v":"Employment Insurance"},586,"New Position employer EI",615,null,null,null,null,null,712]
[46,null,null,null,null,null,null,""]
[47,null,null,"Office Renovations (974)",null,null,null,""]
[48,{"$f":"IF(C53<1,\" \",VLOOKUP(C53,MainAccountNO:MainAccounts,2,FALSE))","v":"Special Projects"},580,"renovations",500,null,null,"",null,null,500]
[49,{"$f":"IF(C54<1,\" \",VLOOKUP(C54,MainAccountNO:MainAccounts,2,FALSE))","v":"Special Projects"},580,"yard enhancement",250,null,null,"",null,null,250]
[50]
[51,null,null,"CLT (978)",null,null,null,""]
[52,{"$f":"IF(C57<1,\" \",VLOOKUP(C57,MainAccountNO:MainAccounts,2,FALSE))","v":"Food for Outreach/Meetings"},515,"CLT - food - Face to face Meetings x2 ",750,null,null,"",200,343,750]
[53,{"$f":"IF(C58<1,\" \",VLOOKUP(C58,MainAccountNO:MainAccounts,2,FALSE))","v":"Staff Training"},537,"CLT - leadership development",500,null,null,"",null,null,500]
[54,{"$f":"IF(C59<1,\" \",VLOOKUP(C59,MainAccountNO:MainAccounts,2,FALSE))","v":"Motel/Hotel"},546,"CLT - lodging",1200,null,null,"",null,null,1200]
[55,{"$f":"IF(C60<1,\" \",VLOOKUP(C60,MainAccountNO:MainAccounts,2,FALSE))","v":"Gas & Oil Auto"},549,"CLT - gas",500,null,null,"",null,160,500]
[56,{"$f":"IF(C61<1,\" \",VLOOKUP(C61,MainAccountNO:MainAccounts,2,FALSE))","v":"Commercial Travel"},551,"CLT - travel",1500,null,null,"",null,273,1500]
[57,{"$f":"IF(C62<1,\" \",VLOOKUP(C62,MainAccountNO:MainAccounts,2,FALSE))","v":"Motel/Hotel"},546,"CLT - facility costs",100,null,null,"",null,null,100]
[58]
[59,null,null,"ELT",null,null,null,""]
[60,{"$f":"IF(C65<1,\" \",VLOOKUP(C65,MainAccountNO:MainAccounts,2,FALSE))","v":"Food for Outreach/Meetings"},515,"ELT - food",400,null,null,"",null,null,400]
[61,{"$f":"IF(C66<1,\" \",VLOOKUP(C66,MainAccountNO:MainAccounts,2,FALSE))","v":"Gas & Oil Auto"},549,"ELT - car travel - 2600 km x $24/100km",700,null,null,"",null,null,700]
[62,{"$f":"IF(C67<1,\" \",VLOOKUP(C67,MainAccountNO:MainAccounts,2,FALSE))","v":"Commercial Travel"},551,"ELT airfare to US",650,null,null,null,null,null,650]
[63,{"$f":"IF(C68<1,\" \",VLOOKUP(C68,MainAccountNO:MainAccounts,2,FALSE))","v":"Motel/Hotel"},546,"ELT - car travel 2 nights motel",250,null,null,"",null,null,250]
[64,null,null,null,null,null,null,""]
[65,null,null,"Field Director (975)",null,null,null,""]
[66,{"$f":"IF(C71<1,\" \",VLOOKUP(C71,MainAccountNO:MainAccounts,2,FALSE))","v":"Commercial Travel"},551,"FD airfare to US - Board meeting",650,null,null,"",null,null,650]
[67,null,null,null,null,null,null,""]
[68,null,null,"Executive Director (980)",null,null,null,""]
[69,{"$f":"IF(C74<1,\" \",VLOOKUP(C74,MainAccountNO:MainAccounts,2,FALSE))","v":"Equip. Maint."},527,"ED technology needs",300,null,null,"",null,null,300]
[70,{"$f":"IF(C75<1,\" \",VLOOKUP(C75,MainAccountNO:MainAccounts,2,FALSE))","v":"Gas & Oil Auto"},549,"ED travel",150,null,null,"",null,null,150]
[71,{"$f":"IF(C76<1,\" \",VLOOKUP(C76,MainAccountNO:MainAccounts,2,FALSE))","v":"Telephone"},547,"ED phone",300,null,null,"",260,560,300]
[72,{"$f":"IF(C77<1,\" \",VLOOKUP(C77,MainAccountNO:MainAccounts,2,FALSE))","v":"Meal & Entertainment"},553,"ED meals while traveling",500,null,null,"",545,780,500]
[73,{"$f":"IF(C78<1,\" \",VLOOKUP(C78,MainAccountNO:MainAccounts,2,FALSE))","v":"Commercial Travel"},551,"ED commercial travel",2000,null,null,"",null,null,2000]
[74,{"$f":"IF(C79<1,\" \",VLOOKUP(C79,MainAccountNO:MainAccounts,2,FALSE))","v":"Motel/Hotel"},546,"ED hotels",1600,null,null,"",270,820,1600]
[75,{"$f":"IF(C80<1,\" \",VLOOKUP(C80,MainAccountNO:MainAccounts,2,FALSE))","v":"Auto Reimbursement"},563,"ED car rental",400,null,null,"",null,78,400]
[76,{"$f":"IF(C81<1,\" \",VLOOKUP(C81,MainAccountNO:MainAccounts,2,FALSE))","v":"Ministry Expense"},587,"ED ministry expenses inc. mileage reimbursement",5000,null,null,"",3675,5580,5000]
[77,{"$f":"IF(C82<1,\" \",VLOOKUP(C82,MainAccountNO:MainAccounts,2,FALSE))","v":"Staff Training"},537,"ED training resources",900,null,null,"",42,140,900]
[78,{"$f":"IF(C83<1,\" \",VLOOKUP(C83,MainAccountNO:MainAccounts,2,FALSE))","v":"Office Supply"},532,"ED general supplies",200,null,null,"",40,270,200]
[79,{"$f":"IF(C84<1,\" \",VLOOKUP(C84,MainAccountNO:MainAccounts,2,FALSE))","v":"Seminars & Registration"},538,"ED Missio Nexus",350,null,null,null,null,null,350]
[80,null,null,null,null,null,null,""]
[81,null,null,"Board of Directors (977)",null,null,null,{"$f":"IF(G86<=$G$1,\"\",\"OUT\")","v":""}]
[82,{"$f":"IF(C87<1,\" \",VLOOKUP(C87,MainAccountNO:MainAccounts,2,FALSE))","v":"Food for Outreach/Meetings"},515,"food for board meetings",1000,null,null,"",490,1213,1000]
[83,{"$f":"IF(C88<1,\" \",VLOOKUP(C88,MainAccountNO:MainAccounts,2,FALSE))","v":"Staff Training"},537,"training materials for board",350,null,null,"",170,320,350]
[84,{"$f":"IF(C89<1,\" \",VLOOKUP(C89,MainAccountNO:MainAccounts,2,FALSE))","v":"Motel/Hotel"},546,"board lodging (Aug & Feb)",5200,null,null,"",2480,5260,5200]
[85,{"$f":"IF(C90<1,\" \",VLOOKUP(C90,MainAccountNO:MainAccounts,2,FALSE))","v":"Gas & Oil Auto"},549,"board gas reimbursement",500,null,null,"",null,412,500]
[86,{"$f":"IF(C91<1,\" \",VLOOKUP(C91,MainAccountNO:MainAccounts,2,FALSE))","v":"Commercial Travel"},551,"airfare",1800,null,null,"",1187,1187,1800]
[87,{"$f":"IF(C92<1,\" \",VLOOKUP(C92,MainAccountNO:MainAccounts,2,FALSE))","v":"General Supply & Service"},545,"supplies/resources",200,null,null,"",null,null,200]
[88,null,null,null,null,null,null,""]
[89,null,null,"Admin Staffing",null,null,null,""]
[90,{"$f":"IF(C95<1,\" \",VLOOKUP(C95,MainAccountNO:MainAccounts,2,FALSE))","v":"Canadian Gifts-Staff"},410,"G Hamilton CDN Support",38915,null,null,"",null,null,37070]
[91,{"$f":"IF(C96<1,\" \",VLOOKUP(C96,MainAccountNO:MainAccounts,2,FALSE))","v":"US Gifts"},430,"G Hamilton US Support",47250,null,null,"",null,null,41400]
[92,{"$f":"IF(C97<1,\" \",VLOOKUP(C97,MainAccountNO:MainAccounts,2,FALSE))","v":"Executive Salaries"},592,"G Hamilton Executive Salary (12 @ $1600)",19200,null,null,"",null,null,19200]
[93,{"$f":"IF(C98<1,\" \",VLOOKUP(C98,MainAccountNO:MainAccounts,2,FALSE))","v":"Ministry Expense"},587,"G Hamilton MER",14500,null,null,"",null,null,13500]
[94,{"$f":"IF(C99<1,\" \",VLOOKUP(C99,MainAccountNO:MainAccounts,2,FALSE))","v":"Salary Expense"},591,"G Hamilton Salary",{"$f":"0.9*(E95+E96)-E98","v":63048.5},null,null,"",null,null,57123]
[95,{"$f":"IF(C100<1,\" \",VLOOKUP(C100,MainAccountNO:MainAccounts,2,FALSE))","v":"Operations Assessment"},484,"operations assessments",{"$f":"-0.1*(E95+E96)","v":-8616.5},null,null,"",null,null,-7847]

{"sheet":"S10","index":13,"n_rows":48,"n_cols":11,"rows_kept":48,"cut":false,"hidden":false,"merged":[[0,10,5,10],[0,8,5,8],[0,9,5,9]]}
[null,"Mobilization",80,"Choose Rank Number -------->",null,null,4,null,"Amount of 23/24 budget spent by Oct 31","Total From Last 12 Months - Nov22-Oct23","Last Budget 23/24"]
[null,null,null,"Total Income",{"$f":"SUM(IF(S_10FieldRank<=S_10Choice,IF(S_10AccNO<=LastIncome,S_10Amount,0),0))","v":1800}]
[null,null,null,"Total Expense",{"$f":"SUM(IF(S_10FieldRank<=S_10Choice,IF(S_10AccNO>LastIncome,S_10Amount,0),0))","v":22075}]
[null,null,null,"Difference",{"$f":"E2-E3","v":-20275}]
["Line","Account Description","Acc_NO","Field Detail","Amount"]
[]
[1,null,null,"Canada Field Mobilization"]
[2,{"$f":"IF(C8<1,\" \",VLOOKUP(C8,MainAccountNO:MainAccounts,2,FALSE))","v":"Gifts to Affiliated Org."},517,"scholarships Prairie, Millar, Steinbach, Nipawin $750 each",3000,null,null,{"$f":"IF(G8<=$G$1,\"\",\"OUT\")","v":""},2000,null,3000]
[3,{"$f":"IF(C9<1,\" \",VLOOKUP(C9,MainAccountNO:MainAccounts,2,FALSE))","v":"Postage & Parcels"},533,"shipping displays",100,null,null,"",null,57,100]
[4,{"$f":"IF(C10<1,\" \",VLOOKUP(C10,MainAccountNO:MainAccounts,2,FALSE))","v":"Royalties/Fees"},530,"repping fee",100,null,null,"",null,null,150]
[5,{"$f":"IF(C11<1,\" \",VLOOKUP(C11,MainAccountNO:MainAccounts,2,FALSE))","v":"General Supply & Service"},545,"supplies for displays",100,null,null,null,null,31]
[6,{"$f":"IF(C12<1,\" \",VLOOKUP(C12,MainAccountNO:MainAccounts,2,FALSE))","v":"Food for Outreach/Meetings"},515,"Food re interviews/orientation",100,null,null,"",null,null,100]
[7,{"$f":"IF(C13<1,\" \",VLOOKUP(C13,MainAccountNO:MainAccounts,2,FALSE))","v":"Gas & Oil Auto"},549,"gas re ongoing connection with Cnd candidates/appointees",150,null,null,"",null,null,150]
[8,{"$f":"IF(C14<1,\" \",VLOOKUP(C14,MainAccountNO:MainAccounts,2,FALSE))","v":"Audit & Legal Fees"},521,"legal consultation re. immigration",300,null,null,"",null,null,300]
[9]
[10,null,null,"US Mobilization"]
[11,{"$f":"IF(C17<1,\" \",VLOOKUP(C17,MainAccountNO:MainAccounts,2,FALSE))","v":"Gifts to Affiliated Org."},517,"US mobilization parity payment",6800,null,null,"",6790,13582,6800]
[12]
[13,{"$f":"IF(C19<1,\" \",VLOOKUP(C19,MainAccountNO:MainAccounts,2,FALSE))","v":" "},null,"Canada Field Recruitment",null,null,null,""]
[14,"Meals & Entertainment",553,"Colleges, otther recrutiment",300]
[15,"Gas & Oil Auto",549,"Steinbach; Millar Winnipeg (Morgan X2)",630]
[16,"Gas & Oil Auto",549,"Nipawin Bible College (Morgan X2)",1260]
[17,"Motel/Hotel",546,"Nipawin Bible College (Morgan X2)",230]
[18,"Gas & Oil Auto",549,"Millar SK (Josh X2)",220]
[19,"Gas & Oil Auto",549,"Millar BC (Greg/Byron X2)",440]
[20,"Motel/Hotel",546,"Millar BC (Greg/Byron X2)",280]
[21,{"$f":"IF(C27<1,\" \",VLOOKUP(C27,MainAccountNO:MainAccounts,2,FALSE))","v":" "},null,null,null,null,null,""]
[22,{"$f":"IF(C28<1,\" \",VLOOKUP(C28,MainAccountNO:MainAccounts,2,FALSE))","v":" "},null,"EnGage! ",null,null,null,""]
[23,{"$f":"IF(C29<1,\" \",VLOOKUP(C29,MainAccountNO:MainAccounts,2,FALSE))","v":"Special Projects"},580,"scholarship for EnGage! Alaska or Russia",500,null,null,"",null,null,500]
[24,{"$f":"IF(C30<1,\" \",VLOOKUP(C30,MainAccountNO:MainAccounts,2,FALSE))","v":"Advertising"},503,"recruitment for EnGage!",100]
[25,null,null,null,null,null,null,""]
[26,{"$f":"IF(C32<1,\" \",VLOOKUP(C32,MainAccountNO:MainAccounts,2,FALSE))","v":" "},null,"Mobilization Follow-up",null,null,null,""]
[27,{"$f":"IF(C33<1,\" \",VLOOKUP(C33,MainAccountNO:MainAccounts,2,FALSE))","v":"Special Projects"},580,"Mobilization Follow-up",600,null,null,"",null,null,600]
[28,{"$f":"IF(C34<1,\" \",VLOOKUP(C34,MainAccountNO:MainAccounts,2,FALSE))","v":" "}]
[29,{"$f":"IF(C35<1,\" \",VLOOKUP(C35,MainAccountNO:MainAccounts,2,FALSE))","v":" "},null,"Mobilization Pipeline Mentoring"]
[30,{"$f":"IF(C36<1,\" \",VLOOKUP(C36,MainAccountNO:MainAccounts,2,FALSE))","v":"Gas & Oil Auto"},549,"follow up connection with appointees",110,null,null,null,null,null,100]
[31,{"$f":"IF(C37<1,\" \",VLOOKUP(C37,MainAccountNO:MainAccounts,2,FALSE))","v":"Commercial Travel"},551,"flight/car rental",1045,null,null,"",null,null,950]
[32,{"$f":"IF(C38<1,\" \",VLOOKUP(C38,MainAccountNO:MainAccounts,2,FALSE))","v":"Motel/Hotel"},546,"motel",560,null,null,null,null,null,450]
[33]
[34,{"$f":"IF(C40<1,\" \",VLOOKUP(C40,MainAccountNO:MainAccounts,2,FALSE))","v":" "},null,"Internship (925)"]
[35,{"$f":"IF(C41<1,\" \",VLOOKUP(C41,MainAccountNO:MainAccounts,2,FALSE))","v":"Project Income - CND Ind"},440,"CAN individuals",1000,null,null,null,null,null,1000]
[36,{"$f":"IF(C42<1,\" \",VLOOKUP(C42,MainAccountNO:MainAccounts,2,FALSE))","v":"Project Income - CDN Churches"},441,"CAN churches",1000,null,null,null,null,null,1000]
[37,{"$f":"IF(C43<1,\" \",VLOOKUP(C43,MainAccountNO:MainAccounts,2,FALSE))","v":"Operations Assessment"},484,"assessment on donations",-200,null,null,null,null,null,-200]
[38,{"$f":"IF(C44<1,\" \",VLOOKUP(C44,MainAccountNO:MainAccounts,2,FALSE))","v":"Motel/Hotel"},546,"1 - 8 months living expenses @ $550/m",4400,null,null,null,null,null,4000]
[39,{"$f":"IF(C45<1,\" \",VLOOKUP(C45,MainAccountNO:MainAccounts,2,FALSE))","v":"Gas & Oil Auto"},549,"supervision visits - gas - apx 1500 km",250,null,null,null,null,null,220]
[40,{"$f":"IF(C46<1,\" \",VLOOKUP(C46,MainAccountNO:MainAccounts,2,FALSE))","v":"Gas & Oil Auto"},549,"1 training session or retreat - gas",250,null,null,null,null,null,220]
[41,{"$f":"IF(C47<1,\" \",VLOOKUP(C47,MainAccountNO:MainAccounts,2,FALSE))","v":"Staff Training"},537,"training expenses (i.e. resources)",130,null,null,null,null,null,120]
[42,{"$f":"IF(C48<1,\" \",VLOOKUP(C48,MainAccountNO:MainAccounts,2,FALSE))","v":"Meal & Entertainment"},553,"6 meals training session ($20/meal)",120,null,null,null,null,null,108]

{"sheet":"S11","index":15,"n_rows":87,"n_cols":12,"rows_kept":87,"cut":false,"hidden":false,"merged":[[0,8,6,8],[0,9,6,9]]}
[null,"Midway Ministries",51,"Choose Rank Number -------->",null,null,10,null,"Amount of 23/24 budget spent by Oct 31","Total From Last 12 Months - Nov22-Oct23","Last Budget"]
[null,null,null,"Total Income",{"$f":"SUM(IF(S_11FieldRank<=S_11Choice,IF(S_11AccNO<=LastIncome,S_11Amount,0),0))","v":859800},null,null,null,null,null,"23/24"]
[null,null,null,"Total Expense",{"$f":"SUM(IF(S_11FieldRank<=S_11Choice,IF(S_11AccNO>LastIncome,S_11Amount,0),0))","v":660050}]
[null,null,null,"Difference",{"$f":"E2-E3","v":199750}]
["Line","Account Description","Acc_NO","Field Detail","Amount"]
[]
[1,null,null,"Midway Bible Camp & Office (946)",null,null,null,{"$f":"IF(G7<=$G$1,\"\",\"OUT\")","v":""}]
[2]
[3,{"$f":"IF(C9<1,\" \",VLOOKUP(C9,MainAccountNO:MainAccounts,2,FALSE))","v":"Gifts in hand"},400,"apx balance on hand @ 03/31/2024",125000,null,null,"",null,null,100000]
[4,{"$f":"IF(C10<1,\" \",VLOOKUP(C10,MainAccountNO:MainAccounts,2,FALSE))","v":"Project Income - CND Ind"},440,"CDN gifts",52000,null,null,"",null,51460,56000]
[5,{"$f":"IF(C11<1,\" \",VLOOKUP(C11,MainAccountNO:MainAccounts,2,FALSE))","v":"Project Income - CDN Churches"},441,"CDN gifts",82000,null,null,"",null,81697,100000]
[6,{"$f":"IF(C12<1,\" \",VLOOKUP(C12,MainAccountNO:MainAccounts,2,FALSE))","v":"Other income"},455,"camp registrations",20000,null,null,"",null,17695,50000]
[7,{"$f":"IF(C13<1,\" \",VLOOKUP(C13,MainAccountNO:MainAccounts,2,FALSE))","v":"Operations Assessment"},484,"Operations assessment",{"$f":"-0.1*(E10+E11)","v":-13400},null,null,"",null,null,-15600]
[8,{"$f":"IF(C14<1,\" \",VLOOKUP(C14,MainAccountNO:MainAccounts,2,FALSE))","v":"Advertising"},503,"camp promotion",2500,null,null,"",533,2285,1500]
[9,{"$f":"IF(C15<1,\" \",VLOOKUP(C15,MainAccountNO:MainAccounts,2,FALSE))","v":"Small Equip. Purchase"},511,"office sports & camp equipment, tools, generator",2000,null,null,null,365,2235.8200000000002,100]
[10,{"$f":"IF(C16<1,\" \",VLOOKUP(C16,MainAccountNO:MainAccounts,2,FALSE))","v":"Food for Outreach/Meetings"},515,"food & kitchen supplies",30000,null,null,"",27394,29189,20000]
[11,{"$f":"IF(C17<1,\" \",VLOOKUP(C17,MainAccountNO:MainAccounts,2,FALSE))","v":"Bldg, Equip & Liab. Ins."},519,"insurance for vehicles",4000,null,null,"",{"$f":"142+723+2566","v":3431},{"$f":"142","v":142},6000]
[12,{"$f":"IF(C18<1,\" \",VLOOKUP(C18,MainAccountNO:MainAccounts,2,FALSE))","v":"Bldg, Equip & Liab. Ins."},519,"insurance for camp and facilities & office at house",12000,null,null,"",null,{"$f":"11226+12","v":11238},11350]
[13,{"$f":"IF(C19<1,\" \",VLOOKUP(C19,MainAccountNO:MainAccounts,2,FALSE))","v":"Bldg. Maint."},525,"maintenance",4000,null,null,null,2894,4070,500]
[14,{"$f":"IF(C20<1,\" \",VLOOKUP(C20,MainAccountNO:MainAccounts,2,FALSE))","v":"Equip. Maint."},527,"equipment maintenance",2000,null,null,"",{"$f":"1512+145","v":1657},1579,3000]
[15,{"$f":"IF(C21<1,\" \",VLOOKUP(C21,MainAccountNO:MainAccounts,2,FALSE))","v":"Banking Charges"},529,"donation processing fees",250,null,null,null,197]
[16,{"$f":"IF(C22<1,\" \",VLOOKUP(C22,MainAccountNO:MainAccounts,2,FALSE))","v":"Royalties/Fees"},530,"background checks",0,null,null,"",null,0,200]
[17,{"$f":"IF(C23<1,\" \",VLOOKUP(C23,MainAccountNO:MainAccounts,2,FALSE))","v":"Royalties/Fees"},530,"domain fee",100,null,null,"",52,52,40]
[18,{"$f":"IF(C24<1,\" \",VLOOKUP(C24,MainAccountNO:MainAccounts,2,FALSE))","v":"Royalties/Fees"},530,"Manitoba Annual return",100,null,null,null,60,60,280]
[19,{"$f":"IF(C25<1,\" \",VLOOKUP(C25,MainAccountNO:MainAccounts,2,FALSE))","v":"Office Supply"},532,"office supplies",1000,null,null,"",613,1094,1050]
[20,{"$f":"IF(C26<1,\" \",VLOOKUP(C26,MainAccountNO:MainAccounts,2,FALSE))","v":"Postage & Parcels"},533,"postage",1200,null,null,"",39,937,1400]
[21,{"$f":"IF(C27<1,\" \",VLOOKUP(C27,MainAccountNO:MainAccounts,2,FALSE))","v":"Staff Training"},537,"staff education & training resources",800,null,null,"",170,690,1000]
[22,{"$f":"IF(C28<1,\" \",VLOOKUP(C28,MainAccountNO:MainAccounts,2,FALSE))","v":"Rent Expense"},543,"house utilities & property taxes",7000,null,null,null,4891,{"$f":"5890.61+794.71","v":6685.32},7900]
[23,{"$f":"IF(C29<1,\" \",VLOOKUP(C29,MainAccountNO:MainAccounts,2,FALSE))","v":"General Supply & Service"},545,"camp program supplies",8000,null,null,"",9945,10204,9000]
[24,{"$f":"IF(C30<1,\" \",VLOOKUP(C30,MainAccountNO:MainAccounts,2,FALSE))","v":"Telephone"},547,"cell phone, fax",2200,null,null,"",646,2421,2000]
[25,{"$f":"IF(C31<1,\" \",VLOOKUP(C31,MainAccountNO:MainAccounts,2,FALSE))","v":"Gas & Oil Auto"},549,"public relations, camp vehicles, generators",19000,null,null,"",10684,13475,12000]
[26,{"$f":"IF(C32<1,\" \",VLOOKUP(C32,MainAccountNO:MainAccounts,2,FALSE))","v":"Auto Maintenance"},550,"camp vehicle registration & maintenance",4000,null,null,"",{"$f":"136+400","v":536},3091,5500]
[27,{"$f":"IF(C33<1,\" \",VLOOKUP(C33,MainAccountNO:MainAccounts,2,FALSE))","v":"Motel/Hotel"},546,"camp public relations & recruitment - hotels",0,null,null,{"$f":"IF(G33<=$G$1,\"\",\"OUT\")","v":""},null,99,6250]
[28,{"$f":"IF(C34<1,\" \",VLOOKUP(C34,MainAccountNO:MainAccounts,2,FALSE))","v":"Commercial Travel"},551,"camp public relations & recruitment - flight",0,null,null,"",null,0,800]
[29,{"$f":"IF(C35<1,\" \",VLOOKUP(C35,MainAccountNO:MainAccounts,2,FALSE))","v":"Auto Reimbursement"},563,"camp public relations & recruitment - car rental",1500,null,null,{"$f":"IF(G35<=$G$1,\"\",\"OUT\")","v":""},null,2481,300]
[30,{"$f":"IF(C36<1,\" \",VLOOKUP(C36,MainAccountNO:MainAccounts,2,FALSE))","v":"Speaker Honorarium"},559,"speaker honorariums",2000,null,null,"",null,1824,1120]
[31,{"$f":"IF(C37<1,\" \",VLOOKUP(C37,MainAccountNO:MainAccounts,2,FALSE))","v":"Auto Reimbursement"},563,"mileage use of Suburban",4000,null,null,null,3828,null,1000]
[32,{"$f":"IF(C38<1,\" \",VLOOKUP(C38,MainAccountNO:MainAccounts,2,FALSE))","v":"Salary Expense"},591,"salary for program director & admin director",15000,null,null,"",14750,{"$f":"13884+317+549","v":14750},12000]
[33,{"$f":"IF(C39<1,\" \",VLOOKUP(C39,MainAccountNO:MainAccounts,2,FALSE))","v":"Special Projects"},580,"Bus purchase",13600]
[34,{"$f":"IF(C40<1,\" \",VLOOKUP(C40,MainAccountNO:MainAccounts,2,FALSE))","v":"Special Projects"},580,"NYC reg/van use/meals",null,null,null,null,null,2748,1500]
[35,{"$f":"IF(C41<1,\" \",VLOOKUP(C41,MainAccountNO:MainAccounts,2,FALSE))","v":"Special Projects"},580,"SALT Split Lake fuel/snacks",null,null,null,null,null,null,6400]
[36,{"$f":"IF(C42<1,\" \",VLOOKUP(C42,MainAccountNO:MainAccounts,2,FALSE))","v":"Special Projects"},580,"SALT Nelson House fuel/snacks",null,null,null,null,null,null,4600]
[37,{"$f":"IF(C43<1,\" \",VLOOKUP(C43,MainAccountNO:MainAccounts,2,FALSE))","v":"Special Projects"},580,"SALT Thompson fuel/snacks",null,null,null,null,null,null,1100]
[38,{"$f":"IF(C44<1,\" \",VLOOKUP(C44,MainAccountNO:MainAccounts,2,FALSE))","v":"Special Projects"},580,"Youth Conference (Steinbach Bible College)",null,null,null,null,null,null,800]
[39]
[40,null,null,"MBC Site 6 Development (943)"]
[41,{"$f":"IF(C47<1,\" \",VLOOKUP(C47,MainAccountNO:MainAccounts,2,FALSE))","v":"Gifts in hand"},400,"apx balance on hand @ 03/31/2024",233000,null,null,null,null,null,157820]
[42,{"$f":"IF(C48<1,\" \",VLOOKUP(C48,MainAccountNO:MainAccounts,2,FALSE))","v":"Project Income - CND Ind"},440,"CDN gifts",50000,null,null,null,null,43376,125000]
[43,{"$f":"IF(C49<1,\" \",VLOOKUP(C49,MainAccountNO:MainAccounts,2,FALSE))","v":"Project Income - CDN Churches"},441,"CDN gifts",100000,null,null,null,null,81698,125000]
[44,{"$f":"IF(C50<1,\" \",VLOOKUP(C50,MainAccountNO:MainAccounts,2,FALSE))","v":"Project Income - US"},442,"US gifts",2000,null,null,null,null,1215,50000]
[45,{"$f":"IF(C51<1,\" \",VLOOKUP(C51,MainAccountNO:MainAccounts,2,FALSE))","v":"Operations Assessment"},484,"Operations assessment",{"$f":"-0.1*(E48+E49+E50)","v":-15200},null,null,null,null,null,-30000]
[46,{"$f":"IF(C52<1,\" \",VLOOKUP(C52,MainAccountNO:MainAccounts,2,FALSE))","v":"Other income"},455,"Sale of 151 Deerwood",175000,null,null,null,null,null,175000]
[47,{"$f":"IF(C53<1,\" \",VLOOKUP(C53,MainAccountNO:MainAccounts,2,FALSE))","v":"Special Projects"},580,"Site Prep",45000,null,null,null,null,null,45000]
[48,{"$f":"IF(C54<1,\" \",VLOOKUP(C54,MainAccountNO:MainAccounts,2,FALSE))","v":"Special Projects"},580,"Access Road",null,null,null,null,null,null,180000]
[49,{"$f":"IF(C55<1,\" \",VLOOKUP(C55,MainAccountNO:MainAccounts,2,FALSE))","v":"Special Projects"},580,"Aggregate",20000,null,null,null,null,null,20000]
[50,{"$f":"IF(C56<1,\" \",VLOOKUP(C56,MainAccountNO:MainAccounts,2,FALSE))","v":"Special Projects"},580,"foundations, outhouses, floating dock",220000,null,null,null,null,null,220000]
[51,{"$f":"IF(C57<1,\" \",VLOOKUP(C57,MainAccountNO:MainAccounts,2,FALSE))","v":"Special Projects"},580,"close in buildings, platforms, tents",100000,null,null,null,null,null,175000]
[52,{"$f":"IF(C58<1,\" \",VLOOKUP(C58,MainAccountNO:MainAccounts,2,FALSE))","v":"Special Projects"},580,"insulating, wiring, plumbing",82000,null,null,null,null,null,20000]
[53,{"$f":"IF(C59<1,\" \",VLOOKUP(C59,MainAccountNO:MainAccounts,2,FALSE))","v":"Special Projects"},580,"cabin tents",20000,null,null,null,null,null,10000]
[54,{"$f":"IF(C60<1,\" \",VLOOKUP(C60,MainAccountNO:MainAccounts,2,FALSE))","v":"Special Projects"},580,"outhouses",10000]
[55,{"$f":"IF(C61<1,\" \",VLOOKUP(C61,MainAccountNO:MainAccounts,2,FALSE))","v":" "}]
[56,{"$f":"IF(C62<1,\" \",VLOOKUP(C62,MainAccountNO:MainAccounts,2,FALSE))","v":" "},null,"MBC Suburban (944)"]
[57,{"$f":"IF(C63<1,\" \",VLOOKUP(C63,MainAccountNO:MainAccounts,2,FALSE))","v":"Gifts in hand"},400,"apx balance on hand",12400]
[58,{"$f":"IF(C64<1,\" \",VLOOKUP(C64,MainAccountNO:MainAccounts,2,FALSE))","v":"Auto Maintenance"},550,"maintenance",4000,null,null,null,{"$f":"1702+113","v":1815},2470]
[59,{"$f":"IF(C65<1,\" \",VLOOKUP(C65,MainAccountNO:MainAccounts,2,FALSE))","v":"Auto Maintenance"},550,"transfers from camp & staff for usuage",-5000,null,null,null,{"$f":"-3828-452.8-398.6","v":-4679.4000000000005}]
[60,{"$f":"IF(C66<1,\" \",VLOOKUP(C66,MainAccountNO:MainAccounts,2,FALSE))","v":" "}]
[61]
[62,null,null,"Berge Lake Bible Camp (948)",null,null,null,"",null,null,null,"Budgeting for two weeks in 2024; cost overuns from 2 weeks operations in 2023"]
[63,{"$f":"IF(C69<1,\" \",VLOOKUP(C69,MainAccountNO:MainAccounts,2,FALSE))","v":"Gifts in hand"},400,"apx balance on hand @ 03/31/2024",19000,null,null,"",null,null,20600]
[64,{"$f":"IF(C70<1,\" \",VLOOKUP(C70,MainAccountNO:MainAccounts,2,FALSE))","v":"Project Income - CND Ind"},440,"CDN gifts",15000,null,null,"",null,19990,4000]
[65,{"$f":"IF(C71<1,\" \",VLOOKUP(C71,MainAccountNO:MainAccounts,2,FALSE))","v":"Project Income - CDN Churches"},441,"CDN gifts",5000,null,null,"",null,3433,3500]
[66,{"$f":"IF(C72<1,\" \",VLOOKUP(C72,MainAccountNO:MainAccounts,2,FALSE))","v":"Other income"},455,"camp registrations",0,null,null,"",null,null,3000]
[67,{"$f":"IF(C73<1,\" \",VLOOKUP(C73,MainAccountNO:MainAccounts,2,FALSE))","v":"Operations Assessment"},484,"Operations assessment",{"$f":"-0.1*(E70+E71)","v":-2000},null,null,"",null,null,-750]
[68,{"$f":"IF(C74<1,\" \",VLOOKUP(C74,MainAccountNO:MainAccounts,2,FALSE))","v":"Food for Outreach/Meetings"},515,"Kitchen/grocery expense",9000,null,null,{"$f":"IF(G74<=$G$1,\"\",\"OUT\")","v":""},5793,5913,2000]
[69,{"$f":"IF(C75<1,\" \",VLOOKUP(C75,MainAccountNO:MainAccounts,2,FALSE))","v":"Bldg, Equip & Liab. Ins."},519,"insurance for camp and facilities",1000,null,null,{"$f":"IF(G75<=$G$1,\"\",\"OUT\")","v":""},null,null,250]
[70,{"$f":"IF(C76<1,\" \",VLOOKUP(C76,MainAccountNO:MainAccounts,2,FALSE))","v":"General Supply & Service"},545,"camp program supplies",5200,null,null,{"$f":"IF(G76<=$G$1,\"\",\"OUT\")","v":""},5461,7355,1200]
[71,{"$f":"IF(C77<1,\" \",VLOOKUP(C77,MainAccountNO:MainAccounts,2,FALSE))","v":"Gas & Oil Auto"},549,"propane/fuel/oil for camp use",800]
[72,{"$f":"IF(C78<1,\" \",VLOOKUP(C78,MainAccountNO:MainAccounts,2,FALSE))","v":"Gas & Oil Auto"},549,"gas reimbursement for Roberts",1350]
[73,{"$f":"IF(C79<1,\" \",VLOOKUP(C79,MainAccountNO:MainAccounts,2,FALSE))","v":"Gas & Oil Auto"},549,"travel reimbursement for volunteers",6000,null,null,{"$f":"IF(G79<=$G$1,\"\",\"OUT\")","v":""},{"$f":"2078+5985","v":8063},2300,3300]
[74,{"$f":"IF(C80<1,\" \",VLOOKUP(C80,MainAccountNO:MainAccounts,2,FALSE))","v":"Speaker Honorarium"},559,"speaker honorariums",500,null,null,{"$f":"IF(G80<=$G$1,\"\",\"OUT\")","v":""},null,400,250]
[75,{"$f":"IF(C81<1,\" \",VLOOKUP(C81,MainAccountNO:MainAccounts,2,FALSE))","v":"Small Equip. Purchase"},511,"pump/equip replacement",1200,null,null,{"$f":"IF(G81<=$G$1,\"\",\"OUT\")","v":""},null,null,500]
[76,{"$f":"IF(C82<1,\" \",VLOOKUP(C82,MainAccountNO:MainAccounts,2,FALSE))","v":"Advertising"},503,"camp promotion - printing & pictures",100,null,null,"",null,null,140]
[77,{"$f":"IF(C83<1,\" \",VLOOKUP(C83,MainAccountNO:MainAccounts,2,FALSE))","v":"Postage & Parcels"},533,"For thank you cards",150,null,null,"",null,"?",120]
[78,{"$f":"IF(C84<1,\" \",VLOOKUP(C84,MainAccountNO:MainAccounts,2,FALSE))","v":"General Supply & Service"},545,"camp program supplies, Bibles",500,null,null,"",432,432,400]
[79,{"$f":"IF(C85<1,\" \",VLOOKUP(C85,MainAccountNO:MainAccounts,2,FALSE))","v":"Gas & Oil Auto"},549,"Follow up outreach ",1350,null,null,"",null,null,250]
[80,{"$f":"IF(C86<1,\" \",VLOOKUP(C86,MainAccountNO:MainAccounts,2,FALSE))","v":"Motel/Hotel"},546,"Follow up outreach (2 rooms)",300,null,null,"",null,null,300]
[81,{"$f":"IF(C87<1,\" \",VLOOKUP(C87,MainAccountNO:MainAccounts,2,FALSE))","v":"General Supply & Service"},545,"Follow up outreach  (Food & building rental)",350,null,null,"",null,null,350]

{"sheet":"S12","index":16,"n_rows":12,"n_cols":11,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,8,5,8],[0,9,5,9]]}
[null,"Development",81,"Choose Rank Number -------->",null,null,10,null,"Amount of 23/24 budget spent by Oct 31","Total From Last 12 Months - Nov22-Oct23","Last Budget"]
[null,null,null,"Total Income",{"$f":"SUM(IF(S_12FieldRank<=S_12Choice,IF(S_12AccNO<=LastIncome,S_12Amount,0),0))","v":0},null,null,null,null,null,"23/24"]
[null,null,null,"Total Expense",{"$f":"SUM(IF(S_12FieldRank<=S_12Choice,IF(S_12AccNO>LastIncome,S_12Amount,0),0))","v":20000}]
[null,null,null,"Difference",{"$f":"E2-E3","v":-20000}]
["Line","Account Description","Acc_NO","Field Detail","Amount","Month","Rank","Out"]
[null,null,null,null,null,null,null,{"$f":"IF(G6<=$G$1,\"\",\"OUT\")","v":""}]
[1,null,null,"Mailings",null,null,null,""]
[2,{"$f":"IF(C8<1,\" \",VLOOKUP(C8,MainAccountNO:MainAccounts,2,FALSE))","v":"Project Income - CND Ind"},440,"CDN gifts",0,null,null,"",null,null,0]
[3,{"$f":"IF(C9<1,\" \",VLOOKUP(C9,MainAccountNO:MainAccounts,2,FALSE))","v":"Project Income - CDN Churches"},441,"CDN giffs",0,null,null,"",null,null,0]
[4,{"$f":"IF(C10<1,\" \",VLOOKUP(C10,MainAccountNO:MainAccounts,2,FALSE))","v":"Operations Assessment"},484,"assessment on donations",{"$f":"SUM(E8:E9)*-0.1","v":0},null,null,"",null,null,0]
[6,{"$f":"IF(C11<1,\" \",VLOOKUP(C11,MainAccountNO:MainAccounts,2,FALSE))","v":"Postage & Parcels"},533,"appeal letter postage (2 mailings)",10000,null,null,"",null,null,9000]
[7,{"$f":"IF(C12<1,\" \",VLOOKUP(C12,MainAccountNO:MainAccounts,2,FALSE))","v":"Postage & Parcels"},533,"Quarterly InterActions (4 mailings)",10000,null,null,"",null,null,9000]

{"sheet":"S13","index":17,"n_rows":24,"n_cols":11,"rows_kept":24,"cut":false,"hidden":false,"merged":[[0,8,5,8],[0,9,5,9]]}
[null,"Urban Fire",52,"Choose Rank Number -------->",null,null,10,null,"Amount of 23/24 budget spent by Oct 31","Total From Last 12 Months - Nov22-Oct23","Last Budget"]
[null,null,null,"Total Income",{"$f":"SUM(IF(S_13FieldRank<=S_13Choice,IF(S_13AccNO<=LastIncome,S_13Amount,0),0))","v":23400},null,null,null,null,null,"23/24"]
[null,null,null,"Total Expense",{"$f":"SUM(IF(S_13FieldRank<=S_13Choice,IF(S_13AccNO>LastIncome,S_13Amount,0),0))","v":11450}]
[null,null,null,"Difference",{"$f":"E2-E3","v":11950}]
["Line","Account Description","Acc_NO","Field Detail","Amount","Month","Rank","Out"]
[null,null,null,"Community"]
[1,{"$f":"IF(C7<1,\" \",VLOOKUP(C7,MainAccountNO:MainAccounts,2,FALSE))","v":"Gifts in hand"},400,"apx balance on hand @ 03/31/2024",18000,null,null,{"$f":"IF(G7<=$G$1,\"\",\"OUT\")","v":""},null,null,17840]
[2,{"$f":"IF(C8<1,\" \",VLOOKUP(C8,MainAccountNO:MainAccounts,2,FALSE))","v":"Project Income - CND Ind"},440,"CAN individuals",3000,null,null,"",1750,3700,4000]
[3,{"$f":"IF(C9<1,\" \",VLOOKUP(C9,MainAccountNO:MainAccounts,2,FALSE))","v":"Project Income - CDN Churches"},441,"CAN churches",3000,null,null,"",2200,3360,8500]
[4,{"$f":"IF(C10<1,\" \",VLOOKUP(C10,MainAccountNO:MainAccounts,2,FALSE))","v":"Project Income - US"},442,"US gifts and grants",0,null,null,"",null,null,0]
[5,{"$f":"IF(C11<1,\" \",VLOOKUP(C11,MainAccountNO:MainAccounts,2,FALSE))","v":"Operations Assessment"},484,"operations assessement",-600,null,null,"",null,null,-1250]
[6,{"$f":"IF(C12<1,\" \",VLOOKUP(C12,MainAccountNO:MainAccounts,2,FALSE))","v":" "},null,null,null,null,null,""]
[7,{"$f":"IF(C13<1,\" \",VLOOKUP(C13,MainAccountNO:MainAccounts,2,FALSE))","v":" "},null,"Community Housing",null,null,null,""]
[8,{"$f":"IF(C14<1,\" \",VLOOKUP(C14,MainAccountNO:MainAccounts,2,FALSE))","v":"Other income"},455,"Guys House rent and baseline utilities (paid by full time staff)",0,null,null,"",null,null,0]
[9,{"$f":"IF(C15<1,\" \",VLOOKUP(C15,MainAccountNO:MainAccounts,2,FALSE))","v":"Rent Expense"},543,"Rent and Utilites Guys House",0,null,null,"",null,null,0]
[10,{"$f":"IF(C16<1,\" \",VLOOKUP(C16,MainAccountNO:MainAccounts,2,FALSE))","v":"Food for Outreach/Meetings"},515,"Living expenses (Cost for 5 people 2 Leads, 3 youth)",0,null,null,"",null,null,0]
[11,{"$f":"IF(C17<1,\" \",VLOOKUP(C17,MainAccountNO:MainAccounts,2,FALSE))","v":"Speaker Honorarium"},559,"Stipend for part time house leads (2)",0,null,null,"",null,null,0]
[12,{"$f":"IF(C18<1,\" \",VLOOKUP(C18,MainAccountNO:MainAccounts,2,FALSE))","v":"Special Projects"},580,"Transfer from Restora profit",0,null,null,"",null,null,0]
[13,{"$f":"IF(C19<1,\" \",VLOOKUP(C19,MainAccountNO:MainAccounts,2,FALSE))","v":" "},null,null,null,null,null,""]
[14,{"$f":"IF(C20<1,\" \",VLOOKUP(C20,MainAccountNO:MainAccounts,2,FALSE))","v":" "},null,"Urban Fire Program",null,null,null,""]
[15,{"$f":"IF(C21<1,\" \",VLOOKUP(C21,MainAccountNO:MainAccounts,2,FALSE))","v":"Special Projects"},580,"Housing supplement for youth in home",6600,null,null,"",null,null,9120]
[16,{"$f":"IF(C22<1,\" \",VLOOKUP(C22,MainAccountNO:MainAccounts,2,FALSE))","v":"Staff Training"},537,"Staff Training for volunteers",0,null,null,"",null,null,0]
[17,{"$f":"IF(C23<1,\" \",VLOOKUP(C23,MainAccountNO:MainAccounts,2,FALSE))","v":"Special Projects"},580,"Events, Retreats, Community Life",4100,null,null,"",{"$f":"2204+300","v":2504},{"$f":"2391+300","v":2691},4760]
[18,{"$f":"IF(C24<1,\" \",VLOOKUP(C24,MainAccountNO:MainAccounts,2,FALSE))","v":"Bldg, Equip & Liab. Ins."},519,"Liability Insurance",750,null,null,"",null,null,2000]

{"sheet":"S14","index":18,"n_rows":31,"n_cols":12,"rows_kept":31,"cut":false,"hidden":false,"merged":[[19,9,23,9],[19,8,23,8],[0,8,5,8],[0,9,5,9]]}
[null,"Restora Property Care",53,"Choose Rank Number -------->",null,null,10,null,"Amount of 23/24 budget spent by Oct 31","Total From Last 12 Months - Nov22-Oct23","Last Budget"]
[null,null,null,"Total Income",{"$f":"SUM(IF(S_14FieldRank<=S_14Choice,IF(S_14AccNO<=LastIncome,S_14Amount,0),0))","v":108620},null,null,null,null,null,"23/24"]
[null,null,null,"Total Expense",{"$f":"SUM(IF(S_14FieldRank<=S_14Choice,IF(S_14AccNO>LastIncome,S_14Amount,0),0))","v":89712}]
[null,null,null,"Difference",{"$f":"E2-E3","v":18908}]
["Line","Account Description","Acc_NO","Field Detail","Amount","Month","Rank","Out"]
[]
[1,{"$f":"IF(C7<1,\" \",VLOOKUP(C7,MainAccountNO:MainAccounts,2,FALSE))","v":"Gifts in hand"},400,"apx balance on hand @ 03/31/2024",13500,null,null,{"$f":"IF(G7<=$G$1,\"\",\"OUT\")","v":""}]
[2,{"$f":"IF(C8<1,\" \",VLOOKUP(C8,MainAccountNO:MainAccounts,2,FALSE))","v":"Sales"},460,"Sales Revenue",90000,null,null,{"$f":"IF(G8<=$G$1,\"\",\"OUT\")","v":""},27749,45462,90000,"Large increase?"]
[3,{"$f":"IF(C9<1,\" \",VLOOKUP(C9,MainAccountNO:MainAccounts,2,FALSE))","v":"Project Income - CND Ind"},440,"CAN individuals",1600,null,null,{"$f":"IF(G9<=$G$1,\"\",\"OUT\")","v":""},null,null,2000]
[4,{"$f":"IF(C10<1,\" \",VLOOKUP(C10,MainAccountNO:MainAccounts,2,FALSE))","v":"Project Income - CDN Churches"},441,"CAN churches",1600,null,null,{"$f":"IF(G10<=$G$1,\"\",\"OUT\")","v":""},null,null,1000]
[5,{"$f":"IF(C11<1,\" \",VLOOKUP(C11,MainAccountNO:MainAccounts,2,FALSE))","v":"Project Income - US"},442,"US gifts and grants",1600,null,null,{"$f":"IF(G11<=$G$1,\"\",\"OUT\")","v":""},null,133,500]
[6,{"$f":"IF(C12<1,\" \",VLOOKUP(C12,MainAccountNO:MainAccounts,2,FALSE))","v":"Other income"},455,"GST Rebate",800,null,null,null,null,null,800]
[7,{"$f":"IF(C13<1,\" \",VLOOKUP(C13,MainAccountNO:MainAccounts,2,FALSE))","v":"Operations Assessment"},484,"operations assessement",{"$f":"SUM(E9:E11)*-0.1","v":-480},null,null,{"$f":"IF(G13<=$G$1,\"\",\"OUT\")","v":""},null,null,-350]
[8,{"$f":"IF(C14<1,\" \",VLOOKUP(C14,MainAccountNO:MainAccounts,2,FALSE))","v":"Special Projects"},580,"Anchored Warriors (youth nights)",4200,null,null,null,null,null,4200]
[9,{"$f":"IF(C15<1,\" \",VLOOKUP(C15,MainAccountNO:MainAccounts,2,FALSE))","v":" "}]
[10,{"$f":"IF(C16<1,\" \",VLOOKUP(C16,MainAccountNO:MainAccounts,2,FALSE))","v":" "},null,"Restora Fixed Expenses"]
[11,{"$f":"IF(C17<1,\" \",VLOOKUP(C17,MainAccountNO:MainAccounts,2,FALSE))","v":"Salary Expense"},591,"Salary wages",24000,null,null,null,null,null,24000,"Plan to transfer internally to staff accounts"]
[12,{"$f":"IF(C18<1,\" \",VLOOKUP(C18,MainAccountNO:MainAccounts,2,FALSE))","v":"Salary Expense"},591,"Payroll Costs (after wages)",4000,null,null,null,null,null,4000]
[13,{"$f":"IF(C19<1,\" \",VLOOKUP(C19,MainAccountNO:MainAccounts,2,FALSE))","v":"Bldg, Equip & Liab. Ins."},519,"Vehicle Insurance",1440,null,null,null,null,1785,1800]
[14,{"$f":"IF(C20<1,\" \",VLOOKUP(C20,MainAccountNO:MainAccounts,2,FALSE))","v":"General Supply & Service"},545,"Transportation (Fuel, maintenance)",2960,null,null,{"$f":"IF(G20<=$G$1,\"\",\"OUT\")","v":""},13944,37069,3700]
[15,{"$f":"IF(C21<1,\" \",VLOOKUP(C21,MainAccountNO:MainAccounts,2,FALSE))","v":"General Supply & Service"},545,"Marketing & Advertising",1200,null,null,{"$f":"IF(G21<=$G$1,\"\",\"OUT\")","v":""},null,null,1500]
[16,{"$f":"IF(C22<1,\" \",VLOOKUP(C22,MainAccountNO:MainAccounts,2,FALSE))","v":"General Supply & Service"},545,"Operations (Supplies;Software;Garage Rent; Rental Equip; Permits; Phone)",13080,null,null,null,null,null,16350]
[17,{"$f":"IF(C23<1,\" \",VLOOKUP(C23,MainAccountNO:MainAccounts,2,FALSE))","v":"General Supply & Service"},545,"Staff & HR (Training, Development, events)",800,null,null,{"$f":"IF(G23<=$G$1,\"\",\"OUT\")","v":""},null,null,1000]
[18,{"$f":"IF(C24<1,\" \",VLOOKUP(C24,MainAccountNO:MainAccounts,2,FALSE))","v":"General Supply & Service"},545,"Finance (GST, depreciation)",1480,null,null,{"$f":"IF(G24<=$G$1,\"\",\"OUT\")","v":""},null,null,1850]
[19,{"$f":"IF(C25<1,\" \",VLOOKUP(C25,MainAccountNO:MainAccounts,2,FALSE))","v":"Bldg, Equip & Liab. Ins."},519,"Insurance for liability & garage rental",1000]
[20,{"$f":"IF(C26<1,\" \",VLOOKUP(C26,MainAccountNO:MainAccounts,2,FALSE))","v":" "},null,null,null,null,null,{"$f":"IF(G26<=$G$1,\"\",\"OUT\")","v":""}]
[21,{"$f":"IF(C27<1,\" \",VLOOKUP(C27,MainAccountNO:MainAccounts,2,FALSE))","v":" "},null,"Restora Variable Expenses",null,null,null,{"$f":"IF(G27<=$G$1,\"\",\"OUT\")","v":""}]
[22,{"$f":"IF(C28<1,\" \",VLOOKUP(C28,MainAccountNO:MainAccounts,2,FALSE))","v":"General Supply & Service"},545,"Materials & Supplies (Cost of Goods Sold)",8000,null,null,{"$f":"IF(G28<=$G$1,\"\",\"OUT\")","v":""},null,null,6000]
[23,{"$f":"IF(C29<1,\" \",VLOOKUP(C29,MainAccountNO:MainAccounts,2,FALSE))","v":"General Supply & Service"},545,"Subcontractor Cost (Cost of Goods Sold)",17360,null,null,null,null,null,15000]
[24,{"$f":"IF(C30<1,\" \",VLOOKUP(C30,MainAccountNO:MainAccounts,2,FALSE))","v":"Salary Expense"},591,"Wages ( hourly)",9792,null,null,null,585,598,10000]
[25,{"$f":"IF(C31<1,\" \",VLOOKUP(C31,MainAccountNO:MainAccounts,2,FALSE))","v":"Salary Expense"},591,"Payroll Costs (after wages)",400,null,null,null,30,30,500]