{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Overview","Transactions","Assets","Expenses (Budgets)","WordTable","ListData"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":22,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Overview","index":0,"n_rows":36,"n_cols":5,"rows_kept":36,"cut":false,"hidden":false,"merged":[[30,0,30,1],[2,0,2,4],[26,0,26,1],[27,0,27,1],[28,0,28,1],[29,0,29,1],[21,0,21,4],[22,0,22,1],[23,0,23,1],[24,0,24,1],[25,0,25,1],[3,0,3,1],[13,0,13,1],[35,0,35,1],[35,2,35,4],[0,0,0,4],[17,0,17,1],[15,0,15,1],[16,0,16,1],[18,0,18,1],[8,0,8,1],[12,0,12,4],[14,0,14,1],[4,0,4,1],[5,0,5,1],[6,0,6,1],[7,0,7,1],[9,0,9,1],[32,0,32,1]]}
["Overview"]
[]
["Assets (900)"]
["Source",null,"Total","Available Funds","Pending Funds"]
[{"$f":"\"Starting balance (900) (\"&Assets!E2&\" \"&Assets!F2&\")\"","v":"Starting balance (900) (Fall 2016)"},null,{"$f":"Assets!E5","v":0},{"$f":"C5","v":0},{"$f":"IF(C5-D5 < 0, 0, C5-D5)","v":0}]
[{"$f":"Assets!A14&\" (\"&Assets!B16&\")\"","v":"Membership Dues (Fall 2016)"},null,{"$f":"Assets!E23+Assets!F23","v":0},{"$f":"Assets!F23","v":0},0]
[{"$f":"Assets!A14&\" (\"&Assets!B25&\")\"","v":"Membership Dues (Spring 2017)"},null,{"$f":"Assets!E32+Assets!F32","v":0},{"$f":"Assets!F32","v":0},0]
[{"$f":"Assets!B7","v":"Emergency Reserve"},null,{"$f":"-(Assets!E7)","v":0},{"$f":"C8","v":0},{"$f":"IF(C8-D8 < 0, 0, C8-D8)","v":0}]
[]
["TOTAL",null,{"$f":"SUM(C5:C9)","v":0},{"$f":"SUM(D5:D9)","v":0},{"$f":"SUM(E5:E9)","v":0}]
[]
[]
["Assets (300)"]
["Source",null,"Total","Available Funds","Pending Funds"]
[{"$f":"\"Starting balance (300) (\"&Assets!E2&\" \"&Assets!F2&\")\"","v":"Starting balance (300) (Fall 2016)"},null,{"$f":"Assets!E6","v":0},{"$f":"C15","v":0},{"$f":"IF(C15-D15 < 0, 0, C15-D15)","v":0}]
[{"$f":"Assets!B40","v":"Senate Finance Committee"},null,{"$f":"Assets!E46","v":0},{"$f":"Assets!F46","v":0},{"$f":"IF(C16-D16 < 0, 0, C16-D16)","v":0}]
[{"$f":"Assets!B48","v":"Other"},null,{"$f":"Assets!F54","v":0},{"$f":"Assets!F54","v":0},{"$f":"IF(C17-D17 < 0, 0, C17-D17)","v":0}]
[]
["TOTAL",null,{"$f":"SUM(C15:C18)","v":0},{"$f":"SUM(D15:D18)","v":0},{"$f":"SUM(E15:E18)","v":0}]
[]
[]
["Expenses (Budgets)"]
["Source",null,"Total","Spent","Pending"]
[{"$f":"'Expenses (Budgets)'!A3","v":"Position"},null,{"$f":"'Expenses (Budgets)'!B11","v":0},{"$f":"'Expenses (Budgets)'!C11","v":0},{"$f":"IF(C24-D24 < 0, \"OVER DRAWN\", C24-D24)","v":0}]
[{"$f":"'Expenses (Budgets)'!A14","v":"Position"},null,{"$f":"'Expenses (Budgets)'!B23","v":0},{"$f":"'Expenses (Budgets)'!C23","v":0},0]
[{"$f":"'Expenses (Budgets)'!A26","v":"Position"},null,{"$f":"'Expenses (Budgets)'!B37","v":0},{"$f":"'Expenses (Budgets)'!C37","v":0},0]
[{"$f":"'Expenses (Budgets)'!A40","v":"Position"},null,{"$f":"'Expenses (Budgets)'!B50","v":0},{"$f":"'Expenses (Budgets)'!C50","v":0},0]
[{"$f":"'Expenses (Budgets)'!A53","v":"Position"},null,{"$f":"'Expenses (Budgets)'!B63","v":0},{"$f":"'Expenses (Budgets)'!C63","v":0},0]
[{"$f":"'Expenses (Budgets)'!A66","v":"Position"},null,{"$f":"'Expenses (Budgets)'!B76","v":0},{"$f":"'Expenses (Budgets)'!C76","v":0},{"$f":"IF(C29-D29 < 0, \"OVER DRAWN\", C29-D29)","v":0}]
[{"$f":"'Expenses (Budgets)'!A79","v":"300 Account"},null,{"$f":"'Expenses (Budgets)'!B89","v":0},{"$f":"'Expenses (Budgets)'!C89","v":0},0]
[{"$f":"'Expenses (Budgets)'!A92","v":"Other"},null,{"$f":"'Expenses (Budgets)'!B102","v":0},{"$f":"'Expenses (Budgets)'!C102","v":0},0]
[]
["TOTAL",null,{"$f":"IF(SUM(C24:C30) = D33, \" \", SUM(C24:C30))","v":" "},{"$f":"SUM(D24:D30)","v":0},{"$f":"SUM(E24:E31)","v":0}]
[]
[]
["Available Balance",null,{"$f":"D10+D19-D33","v":0}]

{"sheet":"Transactions","index":1,"n_rows":39,"n_cols":7,"rows_kept":39,"cut":false,"hidden":false,"merged":[[0,0,0,6]]}
["Transactions"]
["Date","Category","Line item","Description","Debit","Credit","Posted?"]
["2016-08-01","Starting balance",null,null,null,null,{"$f":"IF(AND(Transactions[[#This Row],[Date]]<>\"\", OR(Transactions[[#This Row],[Debit]]<>\"\",Transactions[[#This Row],[Credit]]<>\"\")),\"Y\",\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(Transactions[[#This Row],[Date]]<>\"\", OR(Transactions[[#This Row],[Debit]]<>\"\",Transactions[[#This Row],[Credit]]<>\"\")),\"Y\",\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(Transactions[[#This Row],[Date]]<>\"\", OR(Transactions[[#This Row],[Debit]]<>\"\",Transactions[[#This Row],[Credit]]<>\"\")),\"Y\",\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(Transactions[[#This Row],[Date]]<>\"\", OR(Transactions[[#This Row],[Debit]]<>\"\",Transactions[[#This Row],[Credit]]<>\"\")),\"Y\",\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(Transactions[[#This Row],[Date]]<>\"\", OR(Transactions[[#This Row],[Debit]]<>\"\",Transactions[[#This Row],[Credit]]<>\"\")),\"Y\",\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(Transactions[[#This Row],[Date]]<>\"\", OR(Transactions[[#This Row],[Debit]]<>\"\",Transactions[[#This Row],[Credit]]<>\"\")),\"Y\",\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(Transactions[[#This Row],[Date]]<>\"\", OR(Transactions[[#This Row],[Debit]]<>\"\",Transactions[[#This Row],[Credit]]<>\"\")),\"Y\",\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(Transactions[[#This Row],[Date]]<>\"\", OR(Transactions[[#This Row],[Debit]]<>\"\",Transactions[[#This Row],[Credit]]<>\"\")),\"Y\",\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(Transactions[[#This Row],[Date]]<>\"\", OR(Transactions[[#This Row],[Debit]]<>\"\",Transactions[[#This Row],[Credit]]<>\"\")),\"Y\",\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(Transactions[[#This Row],[Date]]<>\"\", OR(Transactions[[#This Row],[Debit]]<>\"\",Transactions[[#This Row],[Credit]]<>\"\")),\"Y\",\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(Transactions[[#This Row],[Date]]<>\"\", OR(Transactions[[#This Row],[Debit]]<>\"\",Transactions[[#This Row],[Credit]]<>\"\")),\"Y\",\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(Transactions[[#This Row],[Date]]<>\"\", OR(Transactions[[#This Row],[Debit]]<>\"\",Transactions[[#This Row],[Credit]]<>\"\")),\"Y\",\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(Transactions[[#This Row],[Date]]<>\"\", OR(Transactions[[#This Row],[Debit]]<>\"\",Transactions[[#This Row],[Credit]]<>\"\")),\"Y\",\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(Transactions[[#This Row],[Date]]<>\"\", OR(Transactions[[#This Row],[Debit]]<>\"\",Transactions[[#This Row],[Credit]]<>\"\")),\"Y\",\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(Transactions[[#This Row],[Date]]<>\"\", OR(Transactions[[#This Row],[Debit]]<>\"\",Transactions[[#This Row],[Credit]]<>\"\")),\"Y\",\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(Transactions[[#This Row],[Date]]<>\"\", OR(Transactions[[#This Row],[Debit]]<>\"\",Transactions[[#This Row],[Credit]]<>\"\")),\"Y\",\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(Transactions[[#This Row],[Date]]<>\"\", OR(Transactions[[#This Row],[Debit]]<>\"\",Transactions[[#This Row],[Credit]]<>\"\")),\"Y\",\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(Transactions[[#This Row],[Date]]<>\"\", OR(Transactions[[#This Row],[Debit]]<>\"\",Transactions[[#This Row],[Credit]]<>\"\")),\"Y\",\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(Transactions[[#This Row],[Date]]<>\"\", OR(Transactions[[#This Row],[Debit]]<>\"\",Transactions[[#This Row],[Credit]]<>\"\")),\"Y\",\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(Transactions[[#This Row],[Date]]<>\"\", OR(Transactions[[#This Row],[Debit]]<>\"\",Transactions[[#This Row],[Credit]]<>\"\")),\"Y\",\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(Transactions[[#This Row],[Date]]<>\"\", OR(Transactions[[#This Row],[Debit]]<>\"\",Transactions[[#This Row],[Credit]]<>\"\")),\"Y\",\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(Transactions[[#This Row],[Date]]<>\"\", OR(Transactions[[#This Row],[Debit]]<>\"\",Transactions[[#This Row],[Credit]]<>\"\")),\"Y\",\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(Transactions[[#This Row],[Date]]<>\"\", OR(Transactions[[#This Row],[Debit]]<>\"\",Transactions[[#This Row],[Credit]]<>\"\")),\"Y\",\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(Transactions[[#This Row],[Date]]<>\"\", OR(Transactions[[#This Row],[Debit]]<>\"\",Transactions[[#This Row],[Credit]]<>\"\")),\"Y\",\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(Transactions[[#This Row],[Date]]<>\"\", OR(Transactions[[#This Row],[Debit]]<>\"\",Transactions[[#This Row],[Credit]]<>\"\")),\"Y\",\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(Transactions[[#This Row],[Date]]<>\"\", OR(Transactions[[#This Row],[Debit]]<>\"\",Transactions[[#This Row],[Credit]]<>\"\")),\"Y\",\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(Transactions[[#This Row],[Date]]<>\"\", OR(Transactions[[#This Row],[Debit]]<>\"\",Transactions[[#This Row],[Credit]]<>\"\")),\"Y\",\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(Transactions[[#This Row],[Date]]<>\"\", OR(Transactions[[#This Row],[Debit]]<>\"\",Transactions[[#This Row],[Credit]]<>\"\")),\"Y\",\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(Transactions[[#This Row],[Date]]<>\"\", OR(Transactions[[#This Row],[Debit]]<>\"\",Transactions[[#This Row],[Credit]]<>\"\")),\"Y\",\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(Transactions[[#This Row],[Date]]<>\"\", OR(Transactions[[#This Row],[Debit]]<>\"\",Transactions[[#This Row],[Credit]]<>\"\")),\"Y\",\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(Transactions[[#This Row],[Date]]<>\"\", OR(Transactions[[#This Row],[Debit]]<>\"\",Transactions[[#This Row],[Credit]]<>\"\")),\"Y\",\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(Transactions[[#This Row],[Date]]<>\"\", OR(Transactions[[#This Row],[Debit]]<>\"\",Transactions[[#This Row],[Credit]]<>\"\")),\"Y\",\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(Transactions[[#This Row],[Date]]<>\"\", OR(Transactions[[#This Row],[Debit]]<>\"\",Transactions[[#This Row],[Credit]]<>\"\")),\"Y\",\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(Transactions[[#This Row],[Date]]<>\"\", OR(Transactions[[#This Row],[Debit]]<>\"\",Transactions[[#This Row],[Credit]]<>\"\")),\"Y\",\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(Transactions[[#This Row],[Date]]<>\"\", OR(Transactions[[#This Row],[Debit]]<>\"\",Transactions[[#This Row],[Credit]]<>\"\")),\"Y\",\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(Transactions[[#This Row],[Date]]<>\"\", OR(Transactions[[#This Row],[Debit]]<>\"\",Transactions[[#This Row],[Credit]]<>\"\")),\"Y\",\"\")","v":""}]
[null,null,null,"TOTAL",{"$f":"IF(SUMIF(Transactions[Posted?], \"Y\", Transactions[Debit])-SUMIF(Transactions[Posted?], \"Y\", Transactions[Credit]) >= 0, SUMIF(Transactions[Posted?], \"Y\", Transactions[Debit])-SUMIF(Transactions[Posted?], \"Y\", Transactions[Credit]), \"\")","v":0},{"$f":"IF(SUMIF(Transactions[Posted?], \"Y\", Transactions[Debit])-SUMIF(Transactions[Posted?], \"Y\", Transactions[Credit]) < 0, SUMIF(Transactions[Posted?], \"Y\", Transactions[Debit])-SUMIF(Transactions[Posted?], \"Y\", Transactions[Credit]), \"\")","v":""}]

{"sheet":"Assets","index":2,"n_rows":57,"n_cols":6,"rows_kept":57,"cut":false,"hidden":false,"merged":[[9,1,9,2],[56,1,56,2],[40,1,40,3],[41,1,41,3],[55,1,55,5],[47,1,47,5],[48,1,48,3],[42,1,42,3],[43,1,43,3],[44,1,44,3],[45,1,45,3],[53,1,53,3],[54,1,54,5],[52,1,52,3],[49,1,49,3],[37,0,37,6],[33,1,33,2],[13,0,13,6],[50,1,50,3],[51,1,51,3],[39,1,39,5],[46,1,46,5],[0,0,0,6],[32,1,32,5],[23,1,23,5],[24,1,24,5],[15,1,15,5],[1,0,1,3],[3,1,3,3],[3,4,3,5],[4,1,4,3],[4,4,4,5],[5,1,5,3],[6,1,6,3],[9,4,9,5],[5,4,5,5],[6,4,6,5],[7,1,7,5]]}
["Assets"]
["Starting Balances for",null,null,null,"Fall",2016]
[]
[null,"Account",null,null,"Balance"]
[null,"900 Account"]
[null,"300 Account"]
[null,"Emergency Reserve"]
[]
[]
[null,"TOTAL",null,null,{"$f":"SUM(E5:F6)-E7","v":0}]
[]
[]
[]
["Membership Dues"]
[]
[null,{"$f":"E2&\" \"&F2","v":"Fall 2016"}]
[null,"Name","Qty","$ per mem.","Total owed","Total paid"]
[null,null,null,null,{"$f":"IF(C18=\"\", 0, (C18*D18)-F18)","v":0}]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,{"$f":"IF(C21=\"\", 0, (C21*D21)-F21)","v":0}]
[]
[null,"Sub-total",{"$f":"SUM(C18:C21)","v":0},null,{"$f":"SUM(E18:E21)","v":0},{"$f":"SUM(F18:F21)","v":0}]
[]
[null,{"$f":"SUBSTITUTE(B16, B16, CONCATENATE(\"Spring \", RIGHT(B16, 4)+1))","v":"Spring 2017"}]
[null,"Name","Qty","$ per mem.","Total owed","Total paid"]
[null,null,null,null,{"$f":"IF(C27=\"\", 0, (C27*D27)-F27)","v":0},{"$f":"IF(C27=\"\",0,SUMIFS(Transactions!$E$4:$E$38,Transactions!$B$4:$B$38,CONCATENATE(Assets!$A$14,\" - \",LEFT(Assets!$B$25,LEN(Assets!$B$25)-5)),Transactions!$C$4:$C$38,\"=\"&Assets!$B27))","v":0}]
[null,null,null,null,{"$f":"IF(C28=\"\", 0, (C28*D28)-F28)","v":0},{"$f":"IF(C28=\"\",0,SUMIFS(Transactions!$E$4:$E$38,Transactions!$B$4:$B$38,CONCATENATE(Assets!$A$14,\" - \",LEFT(Assets!$B$25,LEN(Assets!$B$25)-5)),Transactions!$C$4:$C$38,\"=\"&Assets!$B28))","v":0}]
[null,null,null,null,0,{"$f":"IF(C29=\"\",0,SUMIFS(Transactions!$E$4:$E$38,Transactions!$B$4:$B$38,CONCATENATE(Assets!$A$14,\" - \",LEFT(Assets!$B$25,LEN(Assets!$B$25)-5)),Transactions!$C$4:$C$38,\"=\"&Assets!$B29))","v":0}]
[null,null,null,null,0,{"$f":"IF(C30=\"\",0,SUMIFS(Transactions!$E$4:$E$38,Transactions!$B$4:$B$38,CONCATENATE(Assets!$A$14,\" - \",LEFT(Assets!$B$25,LEN(Assets!$B$25)-5)),Transactions!$C$4:$C$38,\"=\"&Assets!$B30))","v":0}]
[]
[null,"Sub-total",{"$f":"SUM(C27:C30)","v":0},null,{"$f":"SUM(E27:E30)","v":0},{"$f":"SUM(F27:F30)","v":0}]
[]
[null,"TOTAL",null,null,{"$f":"SUM(E23,E32)","v":0},{"$f":"SUM(F23,F32)","v":0}]
[]
[]
[]
["300 Account"]
[]
[null,"Senate Finance Committee"]
[null,"Name",null,null,"Allocated","Received"]
[null,"Reserve Request: Free Balance",null,null,{"$f":"SUMIFS(Transactions!$E$4:$E$38,Transactions!$B$4:$B$38,\"=\"&Assets!$B$40,Transactions!$C$4:$C$38,\"=\"&Assets!$B42)","v":0},{"$f":"SUMIFS(Transactions!$E$4:$E$38,Transactions!$B$4:$B$38,\"=\"&Assets!$B$40,Transactions!$C$4:$C$38,\"=\"&Assets!$B42, Transactions!$G$4:$G$38, \"Y\")","v":0}]
[null,"Reserve Request: Equipment",null,null,{"$f":"SUMIFS(Transactions!$E$4:$E$38,Transactions!$B$4:$B$38,\"=\"&Assets!$B$40,Transactions!$C$4:$C$38,\"=\"&Assets!$B43)","v":0},{"$f":"SUMIFS(Transactions!$E$4:$E$38,Transactions!$B$4:$B$38,\"=\"&Assets!$B$40,Transactions!$C$4:$C$38,\"=\"&Assets!$B43, Transactions!$G$4:$G$38, \"Y\")","v":0}]
[null,"Reserve Request: Speaker",null,null,{"$f":"SUMIFS(Transactions!$E$4:$E$38,Transactions!$B$4:$B$38,\"=\"&Assets!$B$40,Transactions!$C$4:$C$38,\"=\"&Assets!$B44)","v":0},{"$f":"SUMIFS(Transactions!$E$4:$E$38,Transactions!$B$4:$B$38,\"=\"&Assets!$B$40,Transactions!$C$4:$C$38,\"=\"&Assets!$B44, Transactions!$G$4:$G$38, \"Y\")","v":0}]
[null,"Reserve Request: Interpreter",null,null,{"$f":"SUMIFS(Transactions!$E$4:$E$38,Transactions!$B$4:$B$38,\"=\"&Assets!$B$40,Transactions!$C$4:$C$38,\"=\"&Assets!$B45)","v":0},{"$f":"SUMIFS(Transactions!$E$4:$E$38,Transactions!$B$4:$B$38,\"=\"&Assets!$B$40,Transactions!$C$4:$C$38,\"=\"&Assets!$B45, Transactions!$G$4:$G$38, \"Y\")","v":0}]
[null,"Sub-total",null,null,{"$f":"SUM(E42:E45)","v":0},{"$f":"SUM(F42:F45)","v":0}]
[]
[null,"Other"]
[null,"Name",null,null,"Allocated","Received"]
[null,"Untied Funds",null,null,{"$f":"SUMIF(Transactions[Line item], \"Reserve Request\", Transactions[Debit])","v":0},0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,"Sub-total"]
[]
[]
[null,"TOTAL",null,null,{"$f":"SUM(E46,E54)","v":0},{"$f":"SUM(F46,F54)","v":0}]

{"sheet":"Expenses (Budgets)","index":3,"n_rows":102,"n_cols":4,"rows_kept":102,"cut":false,"hidden":false,"merged":[[52,0,52,3],[65,0,65,3],[91,0,91,3],[2,0,2,3],[0,0,0,3],[13,0,13,3],[25,0,25,3],[39,0,39,3],[78,0,78,3]]}
[" Budget: 2016-2017"]
[]
["Position"]
["Name","Budget","Spent","Over/Under"]
[]
[]
[]
[]
[null,null,{"$f":"IF(A9=\"\", \"\", SUMIFS(Transactions!$F$4:$F$38,Transactions!$B$4:$B$38,\"=\"&'Expenses (Budgets)'!$A$3,Transactions!$C$4:$C$38,\"=\"&'Expenses (Budgets)'!A9, Transactions!$G$4:$G$38, \"Y\"))","v":""}]
[null,null,{"$f":"IF(A10=\"\", \"\", SUMIFS(Transactions!$F$4:$F$38,Transactions!$B$4:$B$38,\"=\"&'Expenses (Budgets)'!$A$3,Transactions!$C$4:$C$38,\"=\"&'Expenses (Budgets)'!A10, Transactions!$G$4:$G$38, \"Y\"))","v":""},{"$f":"IF(A10=\"\",\"\",B10-C10)","v":""}]
["TOTAL",{"$f":"SUM(B5:B10)","v":0},{"$f":"SUM(C5:C8)","v":0},{"$f":"SUM(D5:D10)","v":0}]
[]
[]
["Position"]
["Name","Budget","Spent","Over/Under"]
[]
[null,null,null,{"$f":"IF(A17=\"\",\"\",B17-C17)","v":""}]
[null,null,{"$f":"IF(A18=\"\", \"\", SUMIFS(Transactions!$F$4:$F$38,Transactions!$B$4:$B$38,\"=\"&'Expenses (Budgets)'!$A$14,Transactions!$C$4:$C$38,\"=\"&'Expenses (Budgets)'!A18, Transactions!$G$4:$G$38, \"Y\"))","v":""},""]
[null,null,{"$f":"IF(A19=\"\", \"\", SUMIFS(Transactions!$F$4:$F$38,Transactions!$B$4:$B$38,\"=\"&'Expenses (Budgets)'!$A$14,Transactions!$C$4:$C$38,\"=\"&'Expenses (Budgets)'!A19, Transactions!$G$4:$G$38, \"Y\"))","v":""},""]
[null,null,{"$f":"IF(A20=\"\", \"\", SUMIFS(Transactions!$F$4:$F$38,Transactions!$B$4:$B$38,\"=\"&'Expenses (Budgets)'!$A$14,Transactions!$C$4:$C$38,\"=\"&'Expenses (Budgets)'!A20, Transactions!$G$4:$G$38, \"Y\"))","v":""},""]
[null,null,{"$f":"IF(A21=\"\", \"\", SUMIFS(Transactions!$F$4:$F$38,Transactions!$B$4:$B$38,\"=\"&'Expenses (Budgets)'!$A$14,Transactions!$C$4:$C$38,\"=\"&'Expenses (Budgets)'!A21, Transactions!$G$4:$G$38, \"Y\"))","v":""},""]
[null,null,{"$f":"IF(A22=\"\", \"\", SUMIFS(Transactions!$F$4:$F$38,Transactions!$B$4:$B$38,\"=\"&'Expenses (Budgets)'!$A$14,Transactions!$C$4:$C$38,\"=\"&'Expenses (Budgets)'!A22, Transactions!$G$4:$G$38, \"Y\"))","v":""},{"$f":"IF(A22=\"\",\"\",B22-C22)","v":""}]
["TOTAL",{"$f":"SUM(B16:B22)","v":0},{"$f":"SUM(C16:C17)","v":0},{"$f":"SUM(D16:D22)","v":0}]
[]
[]
["Position"]
["Name","Budget","Spent","Over/Under"]
[]
[]
[]
[]
[]
[null,null,{"$f":"IF(A33=\"\", \"\", SUMIFS(Transactions!$F$4:$F$38,Transactions!$B$4:$B$38,\"=\"&'Expenses (Budgets)'!$A$26,Transactions!$C$4:$C$38,\"=\"&'Expenses (Budgets)'!A33, Transactions!$G$4:$G$38, \"Y\"))","v":""},{"$f":"IF(A33=\"\",\"\",B33-C33)","v":""}]
[null,null,{"$f":"IF(A34=\"\", \"\", SUMIFS(Transactions!$F$4:$F$38,Transactions!$B$4:$B$38,\"=\"&'Expenses (Budgets)'!$A$26,Transactions!$C$4:$C$38,\"=\"&'Expenses (Budgets)'!A34, Transactions!$G$4:$G$38, \"Y\"))","v":""},""]
[null,null,{"$f":"IF(A35=\"\", \"\", SUMIFS(Transactions!$F$4:$F$38,Transactions!$B$4:$B$38,\"=\"&'Expenses (Budgets)'!$A$26,Transactions!$C$4:$C$38,\"=\"&'Expenses (Budgets)'!A35, Transactions!$G$4:$G$38, \"Y\"))","v":""},""]
[null,null,{"$f":"IF(A36=\"\", \"\", SUMIFS(Transactions!$F$4:$F$38,Transactions!$B$4:$B$38,\"=\"&'Expenses (Budgets)'!$A$26,Transactions!$C$4:$C$38,\"=\"&'Expenses (Budgets)'!A36, Transactions!$G$4:$G$38, \"Y\"))","v":""},{"$f":"IF(A36=\"\",\"\",B36-C36)","v":""}]
["TOTAL",{"$f":"SUM(B28:B36)","v":0},{"$f":"SUM(C28:C32)","v":0},{"$f":"SUM(D28:D36)","v":0}]
[]
[]
["Position"]
["Name","Budget","Spent","Over/Under"]
[]
[]
[]
[]
[]
[]
[]
[]
["TOTAL",{"$f":"SUM(B42:B49)","v":0},{"$f":"SUM(C42:C48)","v":0},{"$f":"SUM(D42:D49)","v":0}]
[]
[]
["Position"]
["Name","Budget","Spent","Over/Under"]
[null,null,{"$f":"IF(A55=\"\", \"\", SUMIFS(Transactions!$F$4:$F$38,Transactions!$B$4:$B$38,\"=\"&'Expenses (Budgets)'!$A$53,Transactions!$C$4:$C$38,\"=\"&'Expenses (Budgets)'!A55, Transactions!$G$4:$G$38, \"Y\"))","v":""},{"$f":"IF(A55=\"\",\"\",B55-C55)","v":""}]
[null,null,{"$f":"IF(A56=\"\", \"\", SUMIFS(Transactions!$F$4:$F$38,Transactions!$B$4:$B$38,\"=\"&'Expenses (Budgets)'!$A$53,Transactions!$C$4:$C$38,\"=\"&'Expenses (Budgets)'!A56, Transactions!$G$4:$G$38, \"Y\"))","v":""},{"$f":"IF(A56=\"\",\"\",B56-C56)","v":""}]
[null,null,{"$f":"IF(A57=\"\", \"\", SUMIFS(Transactions!$F$4:$F$38,Transactions!$B$4:$B$38,\"=\"&'Expenses (Budgets)'!$A$53,Transactions!$C$4:$C$38,\"=\"&'Expenses (Budgets)'!A57, Transactions!$G$4:$G$38, \"Y\"))","v":""}]
[null,null,{"$f":"IF(A58=\"\", \"\", SUMIFS(Transactions!$F$4:$F$38,Transactions!$B$4:$B$38,\"=\"&'Expenses (Budgets)'!$A$53,Transactions!$C$4:$C$38,\"=\"&'Expenses (Budgets)'!A58, Transactions!$G$4:$G$38, \"Y\"))","v":""},{"$f":"IF(A58=\"\",\"\",B58-C58)","v":""}]
[null,null,{"$f":"IF(A59=\"\", \"\", SUMIFS(Transactions!$F$4:$F$38,Transactions!$B$4:$B$38,\"=\"&'Expenses (Budgets)'!$A$53,Transactions!$C$4:$C$38,\"=\"&'Expenses (Budgets)'!A59, Transactions!$G$4:$G$38, \"Y\"))","v":""},{"$f":"IF(A59=\"\",\"\",B59-C59)","v":""}]
[null,null,{"$f":"IF(A60=\"\", \"\", SUMIFS(Transactions!$F$4:$F$38,Transactions!$B$4:$B$38,\"=\"&'Expenses (Budgets)'!$A$53,Transactions!$C$4:$C$38,\"=\"&'Expenses (Budgets)'!A60, Transactions!$G$4:$G$38, \"Y\"))","v":""},{"$f":"IF(A60=\"\",\"\",B60-C60)","v":""}]
[null,null,{"$f":"IF(A61=\"\", \"\", SUMIFS(Transactions!$F$4:$F$38,Transactions!$B$4:$B$38,\"=\"&'Expenses (Budgets)'!$A$53,Transactions!$C$4:$C$38,\"=\"&'Expenses (Budgets)'!A61, Transactions!$G$4:$G$38, \"Y\"))","v":""},{"$f":"IF(A61=\"\",\"\",B61-C61)","v":""}]
[null,null,{"$f":"IF(A62=\"\", \"\", SUMIFS(Transactions!$F$4:$F$38,Transactions!$B$4:$B$38,\"=\"&'Expenses (Budgets)'!$A$53,Transactions!$C$4:$C$38,\"=\"&'Expenses (Budgets)'!A62, Transactions!$G$4:$G$38, \"Y\"))","v":""},{"$f":"IF(A62=\"\",\"\",B62-C62)","v":""}]
["TOTAL",{"$f":"SUM(B55:B62)","v":0},{"$f":"SUM(C55:C55)","v":0},{"$f":"SUM(D55:D62)","v":0}]
[]
[]
["Position"]
["Name","Budget","Spent","Over/Under"]
["Office Supplies",0,{"$f":"IF(A68=\"\", \"\", SUMIFS(Transactions!$F$4:$F$38,Transactions!$B$4:$B$38,\"=\"&'Expenses (Budgets)'!$A$66,Transactions!$C$4:$C$38,\"=\"&'Expenses (Budgets)'!A68, Transactions!$G$4:$G$38, \"Y\"))","v":0},{"$f":"IF(A68=\"\",\"\",B68-C68)","v":0}]
[]
[null,null,{"$f":"IF(A70=\"\", \"\", SUMIFS(Transactions!$F$4:$F$38,Transactions!$B$4:$B$38,\"=\"&'Expenses (Budgets)'!$A$66,Transactions!$C$4:$C$38,\"=\"&'Expenses (Budgets)'!A70, Transactions!$G$4:$G$38, \"Y\"))","v":""},{"$f":"IF(A70=\"\",\"\",B70-C70)","v":""}]
[null,null,{"$f":"IF(A71=\"\", \"\", SUMIFS(Transactions!$F$4:$F$38,Transactions!$B$4:$B$38,\"=\"&'Expenses (Budgets)'!$A$66,Transactions!$C$4:$C$38,\"=\"&'Expenses (Budgets)'!A71, Transactions!$G$4:$G$38, \"Y\"))","v":""},{"$f":"IF(A71=\"\",\"\",B71-C71)","v":""}]
[null,null,{"$f":"IF(A72=\"\", \"\", SUMIFS(Transactions!$F$4:$F$38,Transactions!$B$4:$B$38,\"=\"&'Expenses (Budgets)'!$A$66,Transactions!$C$4:$C$38,\"=\"&'Expenses (Budgets)'!A72, Transactions!$G$4:$G$38, \"Y\"))","v":""}]
[null,null,{"$f":"IF(A73=\"\", \"\", SUMIFS(Transactions!$F$4:$F$38,Transactions!$B$4:$B$38,\"=\"&'Expenses (Budgets)'!$A$66,Transactions!$C$4:$C$38,\"=\"&'Expenses (Budgets)'!A73, Transactions!$G$4:$G$38, \"Y\"))","v":""},{"$f":"IF(A73=\"\",\"\",B73-C73)","v":""}]
[null,null,{"$f":"IF(A74=\"\", \"\", SUMIFS(Transactions!$F$4:$F$38,Transactions!$B$4:$B$38,\"=\"&'Expenses (Budgets)'!$A$66,Transactions!$C$4:$C$38,\"=\"&'Expenses (Budgets)'!A74, Transactions!$G$4:$G$38, \"Y\"))","v":""},{"$f":"IF(A74=\"\",\"\",B74-C74)","v":""}]
[null,null,{"$f":"IF(A75=\"\", \"\", SUMIFS(Transactions!$F$4:$F$38,Transactions!$B$4:$B$38,\"=\"&'Expenses (Budgets)'!$A$66,Transactions!$C$4:$C$38,\"=\"&'Expenses (Budgets)'!A75, Transactions!$G$4:$G$38, \"Y\"))","v":""},{"$f":"IF(A75=\"\",\"\",B75-C75)","v":""}]
["TOTAL",{"$f":"SUM(B68:B75)","v":0},{"$f":"SUM(C68:C68)","v":0},{"$f":"SUM(D68:D75)","v":0}]
[]
[]
["300 Account"]
["Name","Budget","Spent","Over/Under"]
["Reserve Request: Free Balance",{"$f":"IF(Assets!F42<>0, Assets!F42, \"\")","v":""},{"$f":"IF(OR(A81=\"\", B81=\"\"), \"\", SUMIFS(Transactions!$F$4:$F$38,Transactions!$B$4:$B$38,\"=\"&'Expenses (Budgets)'!$A$79,Transactions!$C$4:$C$38,\"=\"&'Expenses (Budgets)'!A81, Transactions!$G$4:$G$38, \"Y\"))","v":""},{"$f":"IF(OR(A81=\"\", B81=\"\"),\"\",B81-C81)","v":""}]
["Reserve Request: Equipment",{"$f":"IF(Assets!F43<>0, Assets!F43, \"\")","v":""},{"$f":"IF(OR(A82=\"\", B82=\"\"), \"\", SUMIFS(Transactions!$F$4:$F$38,Transactions!$B$4:$B$38,\"=\"&'Expenses (Budgets)'!$A$79,Transactions!$C$4:$C$38,\"=\"&'Expenses (Budgets)'!A82, Transactions!$G$4:$G$38, \"Y\"))","v":""},""]
["Reserve Request: Speaker",{"$f":"IF(Assets!F44<>0, Assets!F44, \"\")","v":""},{"$f":"IF(OR(A83=\"\", B83=\"\"), \"\", SUMIFS(Transactions!$F$4:$F$38,Transactions!$B$4:$B$38,\"=\"&'Expenses (Budgets)'!$A$79,Transactions!$C$4:$C$38,\"=\"&'Expenses (Budgets)'!A83, Transactions!$G$4:$G$38, \"Y\"))","v":""},""]
["Reserve Request: Interpreter",{"$f":"IF(Assets!F45<>0, Assets!F45, \"\")","v":""},{"$f":"IF(OR(A84=\"\", B84=\"\"), \"\", SUMIFS(Transactions!$F$4:$F$38,Transactions!$B$4:$B$38,\"=\"&'Expenses (Budgets)'!$A$79,Transactions!$C$4:$C$38,\"=\"&'Expenses (Budgets)'!A84, Transactions!$G$4:$G$38, \"Y\"))","v":""},""]
[null,null,{"$f":"IF(OR(A85=\"\", B85=\"\"), \"\", SUMIFS(Transactions!$F$4:$F$38,Transactions!$B$4:$B$38,\"=\"&'Expenses (Budgets)'!$A$79,Transactions!$C$4:$C$38,\"=\"&'Expenses (Budgets)'!A85, Transactions!$G$4:$G$38, \"Y\"))","v":""},""]
[null,null,{"$f":"IF(OR(A86=\"\", B86=\"\"), \"\", SUMIFS(Transactions!$F$4:$F$38,Transactions!$B$4:$B$38,\"=\"&'Expenses (Budgets)'!$A$79,Transactions!$C$4:$C$38,\"=\"&'Expenses (Budgets)'!A86, Transactions!$G$4:$G$38, \"Y\"))","v":""},""]
[null,null,{"$f":"IF(OR(A87=\"\", B87=\"\"), \"\", SUMIFS(Transactions!$F$4:$F$38,Transactions!$B$4:$B$38,\"=\"&'Expenses (Budgets)'!$A$79,Transactions!$C$4:$C$38,\"=\"&'Expenses (Budgets)'!A87, Transactions!$G$4:$G$38, \"Y\"))","v":""},""]
[null,null,{"$f":"IF(OR(A88=\"\", B88=\"\"), \"\", SUMIFS(Transactions!$F$4:$F$38,Transactions!$B$4:$B$38,\"=\"&'Expenses (Budgets)'!$A$79,Transactions!$C$4:$C$38,\"=\"&'Expenses (Budgets)'!A88, Transactions!$G$4:$G$38, \"Y\"))","v":""},""]
["TOTAL",{"$f":"SUM(B81:B85)","v":0},{"$f":"SUM(C81:C85)","v":0},{"$f":"SUM(D81:D88)","v":0}]
[]
[]
["Other"]
["Name","Budget","Spent","Over/Under"]
[]
[null,null,{"$f":"IF(A95=\"\", \"\", SUMIFS(Transactions!$F$4:$F$38,Transactions!$B$4:$B$38,\"=\"&'Expenses (Budgets)'!$A$92,Transactions!$C$4:$C$38,\"=\"&'Expenses (Budgets)'!A95, Transactions!$G$4:$G$38, \"Y\"))","v":""},{"$f":"IF(A95=\"\",\"\",B95-C95)","v":""}]
[null,null,{"$f":"IF(A96=\"\", \"\", SUMIFS(Transactions!$F$4:$F$38,Transactions!$B$4:$B$38,\"=\"&'Expenses (Budgets)'!$A$92,Transactions!$C$4:$C$38,\"=\"&'Expenses (Budgets)'!A96, Transactions!$G$4:$G$38, \"Y\"))","v":""},{"$f":"IF(A96=\"\",\"\",B96-C96)","v":""}]
[null,null,{"$f":"IF(A97=\"\", \"\", SUMIFS(Transactions!$F$4:$F$38,Transactions!$B$4:$B$38,\"=\"&'Expenses (Budgets)'!$A$92,Transactions!$C$4:$C$38,\"=\"&'Expenses (Budgets)'!A97, Transactions!$G$4:$G$38, \"Y\"))","v":""},{"$f":"IF(A97=\"\",\"\",B97-C97)","v":""}]
[null,null,{"$f":"IF(A98=\"\", \"\", SUMIFS(Transactions!$F$4:$F$38,Transactions!$B$4:$B$38,\"=\"&'Expenses (Budgets)'!$A$92,Transactions!$C$4:$C$38,\"=\"&'Expenses (Budgets)'!A98, Transactions!$G$4:$G$38, \"Y\"))","v":""}]
[null,null,{"$f":"IF(A99=\"\", \"\", SUMIFS(Transactions!$F$4:$F$38,Transactions!$B$4:$B$38,\"=\"&'Expenses (Budgets)'!$A$92,Transactions!$C$4:$C$38,\"=\"&'Expenses (Budgets)'!A99, Transactions!$G$4:$G$38, \"Y\"))","v":""},{"$f":"IF(A99=\"\",\"\",B99-C99)","v":""}]
[null,null,{"$f":"IF(A100=\"\", \"\", SUMIFS(Transactions!$F$4:$F$38,Transactions!$B$4:$B$38,\"=\"&'Expenses (Budgets)'!$A$92,Transactions!$C$4:$C$38,\"=\"&'Expenses (Budgets)'!A100, Transactions!$G$4:$G$38, \"Y\"))","v":""},{"$f":"IF(A100=\"\",\"\",B100-C100)","v":""}]
[null,null,{"$f":"IF(A101=\"\", \"\", SUMIFS(Transactions!$F$4:$F$38,Transactions!$B$4:$B$38,\"=\"&'Expenses (Budgets)'!$A$92,Transactions!$C$4:$C$38,\"=\"&'Expenses (Budgets)'!A101, Transactions!$G$4:$G$38, \"Y\"))","v":""},{"$f":"IF(A101=\"\",\"\",B101-C101)","v":""}]
["TOTAL",{"$f":"SUM(B94:B101)","v":0},{"$f":"SUM(C94:C94)","v":0},{"$f":"SUM(D94:D101)","v":0}]

{"sheet":"WordTable","index":4,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":true,"merged":[]}
["Nickname","Proper Name"]
["VP","Vice President"]
["Treas","Finance"]
["VDD","VD"]
["A","Other"]
["VP","Vice President"]
["VPP","Vice President of Programming"]
["VPF","Vice President of Finance"]
["VPR","Vice President of Recruitment"]

{"sheet":"ListData","index":5,"n_rows":15,"n_cols":8,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["Category List",null,null,null,null,null,null,"NOTE:"]
["--ASSETS--",null,null,null,null,null,null,"This page is for maintaining the lists in dropdown lists in the Transaction table."]
[{"$f":"Assets!A14&\" - \"&Assets!B16","v":"Membership Dues - Fall 2016"},null,null,null,null,null,null,"Make sure this page is always present in this sheet. Otherwise, Transactions may not work as intended."]
[{"$f":"Assets!A14&\" - \"&Assets!B25","v":"Membership Dues - Spring 2017"}]
[{"$f":"Assets!B40","v":"Senate Finance Committee"},null,null,null,null,null,null,"If you have added new categories, make sure to update this list acccordingly."]
[{"$f":"Assets!B48&\" - \"&Assets!A38","v":"Other - 300 Account"}]
["--BUDGETS--"]
[{"$f":"'Expenses (Budgets)'!A3:D3","v":"Position"}]
[{"$f":"'Expenses (Budgets)'!A14:D14","v":"Position"}]
[{"$f":"'Expenses (Budgets)'!A26:D26","v":"Position"}]
[{"$f":"'Expenses (Budgets)'!A40:D40","v":"Position"}]
[{"$f":"'Expenses (Budgets)'!A53:D53","v":"Position"}]
[{"$f":"'Expenses (Budgets)'!A66:D66","v":"Position"}]
[{"$f":"'Expenses (Budgets)'!A79:D79","v":"300 Account"}]
[{"$f":"'Expenses (Budgets)'!A92:D92","v":"Other"}]