{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["11-12 Dept. Grants","11-12 Working Budget","10-11 Working Budget"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":3,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"1904"}

{"sheet":"11-12 Dept. Grants","index":0,"n_rows":27,"n_cols":5,"rows_kept":27,"cut":false,"hidden":false,"merged":[[0,0,0,3],[1,0,1,3]]}
["Emerson Jr. High PTA "]
["2011-2012 Budget Report -  Department Grants  5-10-12 "]
[]
[null,"Amount","Spent","Un-Spent"]
[null,"Awarded","To Date","Balance"]
["Diversity Training  for 2011-12",3000,3000,{"$f":"B6-C6","v":0}]
["Response to Intervention (RTI) Conference",530,530,0]
["9th Grade Awards",500,null,500]
["Library",861.97,{"$f":"750.8+738.24","v":1489.04},-627.06999999999994,"Approved at 4/5/12 board meeting"]
["WEB",525,null,525]
["Industrial Arts",2073.58,2151.9699999999998,-78.389999999999873]
["Special Education",312.75,{"$f":"359.66+3.09","v":362.75},-50]
["Peer-helping/Leadership",100,null,100]
["English ",900,900,0]
["Social Studies",720,{"$f":"577.9+302.53","v":880.43},-160.42999999999995]
["English/AVID/Yearbook",null,null,0]
["     Document Cameras",800,453.78,346.22]
["     Photoshop",229.9,280.58999999999997,-50.689999999999969]
["     Conference",1656,1156,500]
["     AVID Conference",700,{"$f":"669","v":669},31]
["Special  Education - Document Camera",199.95,199.95,0]
["PE Equipment",1400,{"$f":"106.67+1212.3","v":1318.97},81.029999999999973]
["Math - Document Camera for Da Vinci",400,400,0]
["Read Program",200,199.22,0.78000000000000114]
["Tax & Shipping",1890.85,null,1890.85]
["Art Dept. Ceramics Kiln Shelves & Speakers",275,{"$f":"48.48+201.56","v":250.04},24.960000000000008,"Approved at 1/12/12 board meeting"]
["TOTAL",{"$f":"SUM(B6:B26)","v":17275},{"$f":"SUM(C6:C26)","v":14241.740000000002},{"$f":"B27-C27","v":3033.2599999999984}]

{"sheet":"11-12 Working Budget","index":1,"n_rows":59,"n_cols":12,"rows_kept":59,"cut":false,"hidden":false,"merged":[[28,3,28,4],[29,3,29,5],[34,3,34,4],[35,3,35,4],[56,2,56,4],[0,0,0,11],[1,0,1,11],[45,3,45,4],[52,2,52,3],[54,2,54,3],[18,2,18,3],[20,3,20,4],[25,2,25,3],[27,2,27,3],[30,3,30,4],[31,3,31,4],[32,3,32,4],[15,3,15,4],[3,0,3,4],[33,3,33,4],[6,2,6,3],[7,3,7,4],[13,2,13,3],[14,3,14,4],[58,0,58,1],[40,2,40,3],[41,3,41,4],[42,3,42,4],[43,3,43,4],[44,3,44,4],[55,2,55,4],[57,0,57,1],[47,3,47,4],[49,3,49,4],[48,3,48,4],[36,3,36,4]]}
["Emerson Davinci Jr. Highs PTA "]
["2013-2014 Approved Budget"]
[{"$nulls":11},"NOTES"]
["Account Balance 6/30/2013",{"$nulls":5},{"$f":"29918.44+2249.31","v":32167.75}]
[]
["Income",{"$nulls":5},"Approved",null,"Actuals",null,"Difference"]
[null,null,"General Income"]
[null,null,null,"Direct Donations",null,null,11250]
[null,null,null,"Membership",null,null,3500]
[null,null,null,"Interest",null,null,2]
[]
[{"$nulls":5},"Subtotal",{"$f":"SUM(G8:G10)","v":14752}]
[]
[null,null,"Grants"]
[null,null,null,"Farm to School Garden",null,null,500]
[]
[{"$nulls":5},"Subtotal",{"$f":"SUM(G15)","v":500}]
[]
[null,null,"Fundraising"]
[null,null,null,"Logo Wear",null,null,300]
[null,null,null,"Student Directory ",null,null,3015]
[null,null,null,"Scrip",null,null,6000]
[]
[{"$nulls":5},"Subtotal",{"$f":"SUM(G20:G22)","v":9315}]
[]
[null,null,"Gross Income",null,null,null,{"$f":"G12+G17+G24","v":24567}]
["Expense",{"$nulls":5},"Approved",null,"Actuals",null,"Difference"]
[null,null,"Program Expense"]
[null,null,null,"Directory ",null,null,1300]
[null,null,null,"Hospitality/Recognition ",null,null,1000]
[null,null,null,"Principal’s Fund ",null,null,2000]
[null,null,null,"9th Grade Grad Party",null,null,750]
[null,null,null,"Parent Education ",null,null,300]
[null,null,null,"Department Grants ",null,null,15000]
[null,null,null,"Resource Fund ",null,null,350]
[null,null,null,"Emerson Impact Project ",null,null,22000]
[null,null,null,"Farm to School",null,null,1163.21]
[]
[{"$nulls":5},"Subtotal",{"$f":"SUM(G29:G37)","v":43863.21}]
[]
[null,null,"PTA Administration"]
[null,null,null,"Bank Charges",null,null,{"$f":"SUM(I51)","v":0}]
[null,null,null,"Officer Training",null,null,50]
[null,null,null,"Insurance",null,null,199]
[null,null,null,"PTA Membership Dues",null,null,1100]
[null,null,null,"Fundraising Expenses",null,null,500]
[null,null,null,"PTA Packet",null,null,950]
[null,null,null,"Administration",null,null,60]
[null,null,null,"Unfiled State Tax Fees",null,null,120]
[null,null,null,"Charitable Trust Regis Fee",null,null,25]
[{"$nulls":5},"Subtotal",{"$f":"SUM(G42:G50)","v":3004}]
[]
[null,null,"Gross Expenses",null,null,null,{"$f":"G39+G51","v":46867.21}]
[]
[null,null,"Net Income",null,null,null,{"$f":"G26-G53","v":-22300.21}]
[null,null,"Account Balance 6/30/2013",null,null,null,{"$f":"G4","v":32167.75}]
[null,null,"Account Balance 6/30/2014"]
[null,null,"Minimum Reserve Amount",null,null,null,9000]
[null,null,"2013-2014 Excess Carryover",null,null,null,{"$f":"G55+G56-G58","v":867.54000000000087}]

{"sheet":"10-11 Working Budget","index":2,"n_rows":88,"n_cols":11,"rows_kept":88,"cut":false,"hidden":false,"merged":[[83,0,83,4],[84,0,84,1],[85,0,85,1],[86,0,86,1],[87,0,87,1],[76,0,76,1],[76,2,76,4],[82,2,82,4],[77,0,77,1],[77,2,77,4],[78,0,78,1],[78,2,78,4],[79,0,79,1],[79,2,79,4],[80,0,80,1],[80,2,80,4],[81,0,81,1],[81,2,81,4],[82,0,82,1],[73,0,73,1],[73,2,73,4],[74,0,74,1],[74,2,74,4],[75,0,75,1],[75,2,75,4],[70,0,70,1],[70,2,70,4],[71,0,71,1],[71,2,71,4],[72,0,72,1],[72,2,72,4],[67,0,67,1],[67,2,67,4],[68,0,68,1],[68,2,68,4],[69,0,69,1],[69,2,69,4],[64,0,64,1],[64,2,64,4],[65,0,65,1],[65,2,65,4],[66,0,66,1],[66,2,66,4],[59,0,59,1],[60,0,60,1],[61,0,61,1],[62,0,62,1],[63,0,63,1],[50,3,50,4],[54,2,54,3],[56,2,56,3],[57,2,57,4],[58,0,58,1],[45,2,45,3],[46,3,46,4],[47,3,47,4],[48,3,48,4],[49,3,49,4],[37,3,37,4],[38,3,38,4],[39,3,39,4],[40,3,40,4],[44,2,44,3],[32,3,32,4],[33,3,33,5],[34,3,34,4],[35,3,35,4],[36,3,36,4],[16,3,16,4],[19,2,19,3],[21,3,21,4],[29,2,29,3],[31,2,31,3],[5,0,5,3],[7,2,7,3],[8,3,8,4],[14,2,14,3],[15,3,15,4],[0,0,0,10],[1,0,1,10],[2,0,2,4],[3,0,3,3],[4,0,4,3]]}
["Emerson Jr. High PTA "]
[" 2010-2011 Budget  -- ay 2011"]
["Account Balance 6/30/2010 ",{"$nulls":5},36215.519999999997]
["Minimum Reserve Amount",{"$nulls":5},12000]
[]
[{"$nulls":6},"Adopted",null,"Actuals",null,"Difference"]
["Income"]
[null,null,"General Income"]
[null,null,null,"Direct Donations",null,null,5100,null,5462.53,null,{"$f":"SUM(I9-G9)","v":362.52999999999975}]
[null,null,null,"Membership",null,null,3300,null,3470,null,{"$f":"SUM(I10-G10)","v":170}]
[]
[]
[{"$nulls":5},"Subtotal",{"$f":"G9+G10","v":8400},null,{"$f":"I9+I10+I11","v":8932.5299999999988},null,{"$f":"SUM(I13-G13)","v":532.52999999999884}]
[]
[null,null,"Grants"]
[null,null,null,"Farm to School Garden",{"$nulls":4},500]
[]
[{"$nulls":5},"Subtotal",null,null,{"$f":"SUM(I16)","v":500}]
[]
[null,null,"Fundraising"]
[null,null,null,"Logo Wear",null,null,2240,null,2426,null,{"$f":"SUM(I21-G21)","v":186}]
[null,null,null,"Student Directory "]
[{"$nulls":4},"Purchased",null,390,null,410,null,{"$f":"SUM(I23-G23)","v":20}]
[{"$nulls":4},"Ad Revenue",null,5780,null,6065,null,{"$f":"SUM(I24-G24)","v":285}]
[null,null,null,"Carnival",null,null,0,null,0]
[null,null,null,"Scrip",null,null,6000,null,2908.01,null,{"$f":"SUM(I26-G26)","v":-3091.99}]
[]
[{"$nulls":5},"Subtotal",{"$f":"G21+G23+G24+G25+G26","v":14410},null,{"$f":"I21+I23+I24+I25+I26","v":11809.01},null,{"$f":"SUM(I28-G28)","v":-2600.9899999999998}]
[]
[null,null,"Gross Income",null,null,null,{"$f":"G13+G28","v":22810},null,{"$f":"I13+I18+I28","v":21241.54},null,{"$f":"SUM(I30-G30)","v":-1568.4599999999991}]
["Expense",{"$nulls":5},"Adopted",null,"Actuals",null,"Difference"]
[null,null,"Program Expense"]
[null,null,null,"Directory ",null,null,3000,null,2306.08,null,{"$f":"SUM(G33-I33)+J3","v":693.92000000000007}]
[null,null,null,"Hospitality/Recognition ",null,null,1325,null,538.87,null,{"$f":"SUM(G34-I34)","v":786.13}]
[null,null,null,"Logo Wear",null,null,2240,null,1465.95,null,{"$f":"SUM(G35-I35)","v":774.05}]
[null,null,null,"Principal’s Fund ",null,null,3000,null,1200,null,{"$f":"SUM(G36-I36)","v":1800}]
[null,null,null,"9th Grade Grad Party",null,null,1000]
[null,null,null,"Parent Education ",null,null,500,null,275,null,{"$f":"SUM(G38-I38)","v":225}]
[null,null,null,"Department Grants ",null,null,26460,null,{"$f":"SUM(F82)","v":20572.41},null,{"$f":"SUM(G39-I39)","v":5887.59}]
[null,null,null,"Resource Fund ",null,null,1000]
[null,null,null,"Emerson Impact Project ",null,null,3000]
[]
[{"$nulls":5},"Subtotal",{"$f":"SUM(G33:G41)","v":41525},null,{"$f":"SUM(I33:I40)","v":26358.309999999998},null,{"$f":"SUM(G43-I43)","v":15166.690000000002}]
[]
["Expense",{"$nulls":5},"Adopted",null,"Actuals",null,"Difference"]
[null,null,"PTA Administration"]
[null,null,null,"Bank Charges",null,null,50,null,12,null,{"$f":"SUM(G47-I47)","v":38}]
[null,null,null,"Officer Training",null,null,200]
[null,null,null,"Insurance",null,null,225,null,196,null,{"$f":"SUM(G49-I49)","v":29}]
[null,null,null,"PTA Membership Dues",null,null,1172,null,1231.8499999999999,null,{"$f":"SUM(G50-I50)","v":-59.849999999999909}]
[null,null,null,"Fundraising Expenses",null,null,600]
[null,null,null,"PTA Packet",null,null,300]
[{"$nulls":5},"Subtotal",{"$f":"G47+G48+G49+G50+G51+G52","v":2547},null,{"$f":"I47+I48+I49+I50+I51","v":1439.85},null,{"$f":"SUM(G53-I53)","v":1107.1500000000001}]
[]
[null,null,"Gross Expenses",null,null,null,{"$f":"G43+G53","v":44072},null,{"$f":"I43+I53","v":27798.159999999996},null,{"$f":"SUM(G55-I55)","v":16273.840000000004}]
[]
[null,null,"Net Income",null,null,null,{"$f":"G30-G55","v":-21262},null,{"$f":"I30-I55","v":-6556.6199999999953}]
[null,null,"Account Balance 6/30/2010 ",{"$nulls":5},36215.519999999997]
[null,null,"Minimum Reserve Amount",null,null,null,12000,null,12000]
[null,null,"2011-2012 Excess Carryover",{"$nulls":5},{"$f":"SUM(I57+I58-I59)","v":17658.900000000001}]
["Department Grants ",{"$nulls":4},"Actuals","Adopted",null,"Difference"]
[]
[" Wolfe/Amsler",null,"WEB",null,null,714.79,714.79,null,{"$f":"SUM(G63-F63)","v":0}]
["J. Terra",null,"Diversity ",null,null,3204.28,3204.28,null,0]
["E. Jacobsen",null,"History",null,null,630,630,null,0]
["J. Terra",null,"PE",null,null,650.79,1785,null,1134.21]
["A. Kimmel",null,"Special Ed -  books",null,null,325.17,389,null,63.829999999999984]
["S.Meade Lee",null,"Spanish",null,null,387.9,387.9,null,0]
["A. Sharpe",null,"Library - books;ALA Conference",null,null,624.04,624.04,null,0]
["J. Terra",null,"Peer Helping",null,null,995,995,null,0]
["A. Cummings",null,"Site Council",null,null,8300,8500,null,200]
["J. Wolfe",null,"English/AVID/Yearbook",null,null,668.2,668.2,null,0]
["L. Gunnerson",null,"Industrial Arts/Woodshop",null,null,360,366,null,6]
["Gina Smith",null,"Drama",null,null,2000,2000,null,0]
["Matt Sonstein",null,"Art",null,null,260.83999999999997,260.83999999999997,null,0]
["S. McGrath",null,"Counselor",null,null,0,500,null,500]
["C. Hartsough",null,"Health",null,null,660,672,null,12]
["Choir Teachers",{"$nulls":4},0,900,null,900]
["Kathy Koblik",null,"English",null,null,791.4,800,null,8.6000000000000227]
["Emily Cooper",null,"Special Education",null,null,0,445.02,null,445.02]
[]
[null,null,"Total",null,null,{"$f":"SUM(F63:F80)","v":20572.41},{"$f":"SUM(G63:G81)","v":23842.07},null,{"$f":"SUM(I63:I81)","v":3269.66}]
[]
["Madeline Levine Parent Education Speaker"]
[null,null,"Income",null,null,2700]
[null,null,"Expense",null,null,2900]
[]
[null,null,"Total",null,null,{"$f":"SUM(F85-F86)","v":-200}]