{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["1st Cert","1st Detail","1st Summary","1st MYP","Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":8,"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":"1st Cert","index":0,"n_rows":50,"n_cols":13,"rows_kept":50,"cut":false,"hidden":false,"merged":[[41,11,41,14],[48,11,48,12],[48,4,48,7],[39,4,39,7],[39,11,39,14],[41,4,41,7],[37,4,37,7],[37,11,37,14],[11,0,11,8],[17,5,17,9],[17,12,17,14],[11,9,11,12],[35,11,35,14],[35,4,35,7],[29,5,29,9],[29,12,29,14],[7,9,7,12],[8,9,8,12],[20,12,20,14],[26,5,26,9],[26,12,26,14],[9,0,9,8],[7,0,7,8],[8,0,8,8],[20,5,20,9],[10,0,10,8],[9,9,9,12],[10,9,10,12],[6,9,6,12],[0,0,0,15],[1,0,1,15],[3,0,3,15],[5,0,5,8],[2,0,2,15],[5,9,5,12]]}
["CHARTER SCHOOL"]
["INTERIM FINANCIAL REPORT - ALTERNATIVE FORM"]
["First Interim Report Certification"]
[]
[]
["Charter School Name:",null,null,null,null,null,null,null,null,"Magnolia Science Academy "]
[null,null,null,null,null,null,null,null,"(continued)","Santa Ana"]
["CDS #:",null,null,null,null,null,null,null,null,"30-76893-0130765"]
["Charter Approving Entity:",null,null,null,null,null,null,null,null,"State Board of Education"]
["County:",null,null,null,null,null,null,null,null,"Orange"]
["Charter #:",null,null,null,null,null,null,null,null,1686]
["Fiscal Year:",null,null,null,null,null,null,null,null,{"$f":"IF('1st Detail'!G12=\"\",\"\",'1st Detail'!G12)","v":"2016/17"}]
[]
[]
[null,null,null,null,"To the entity that approved the charter school:"]
["(","x",")",null,{"$f":"IF('1st Detail'!$G$12=\"\",\"\",'1st Detail'!$G$12)","v":"2016/17"},"CHARTER SCHOOL FIRST INTERIM FINANCIAL REPORT -- ALTERNATIVE FORM:  This report"]
[null,null,null,null,"has been approved, and is hereby filed by the charter school pursuant to Education Code Section 47604.33."]
[null,null,null,null,"Signed:",null,null,null,null,null,null,"      Date:"]
[null,null,null,null,null,"Charter School Official"]
[null,null,null,null,null,"(Original signature required)"]
[null,null,null,null,"Print\nName:","Caprice Young",null,null,null,null,null,"       Title:","CEO"]
[]
[]
[null,null,null,null,"To the County Superintendent of Schools:"]
["(","x",")",null,{"$f":"IF('1st Detail'!$G$12=\"\",\"\",'1st Detail'!$G$12)","v":"2016/17"},{"$f":"F16","v":"CHARTER SCHOOL FIRST INTERIM FINANCIAL REPORT -- ALTERNATIVE FORM:  This report"}]
[null,null,null,null,"is hereby filed with the County Superintendent pursuant to Education Code Section 47604.33."]
[null,null,null,null,"Signed:",null,null,null,null,null,null,"      Date:"]
[null,null,null,null,null,"Authorized Representative of\nCharter Approving Entity"]
[null,null,null,null,null,"(Original signature required)"]
[null,null,null,null,"Print\nName:",null,null,null,null,null,null,"       Title:"]
[]
[]
[null,null,null,null,"For additional information on the First Interim Report, please contact:"]
[]
[null,null,null,null,"For Approving Entity:",null,null,null,null,null,null,"For Charter School:"]
[null,null,null,null,"Kylie Kwok",null,null,null,null,null,null,"Brock Atar"]
[null,null,null,null,"Name",null,null,null,null,null,null,"Name"]
[null,null,null,null,"Educational Fiscal Services Consultant",null,null,null,null,null,null,"Senior Financial Analyst"]
[null,null,null,null,"Title",null,null,null,null,null,null,"Title"]
[null,null,null,null,"(916) 319-0498",null,null,null,null,null,null,"(213) 628-3634"]
[null,null,null,null,"Phone",null,null,null,null,null,null,"Phone"]
[null,null,null,null,"kkwok@cde.ca.gov",null,null,null,null,null,null,"batar@magnoliapublicschools.org"]
[null,null,null,null,"E-mail",null,null,null,null,null,null,"E-mail"]
[]
[]
[null,null,null,null,"This report has been verified for mathematical accuracy by the County Superintendent of Schools,"]
[null,null,null,null,"pursuant to Education Code Section 47604.33."]
[]
[]
[null,null,null,null,"District Advisor",null,null,null,null,null,null,"Date"]

{"sheet":"1st Detail","index":1,"n_rows":161,"n_cols":14,"rows_kept":161,"cut":false,"hidden":false,"merged":[[18,5,18,7],[18,8,18,10],[18,11,18,13],[8,6,8,7],[9,6,9,7],[10,6,10,7],[11,6,11,7],[7,6,7,7],[6,6,6,7],[2,0,2,13],[0,0,0,13],[1,0,1,13],[3,0,3,13],[5,6,5,7]]}
["CHARTER SCHOOL "]
["INTERIM FINANCIAL REPORT - ALTERNATIVE FORM"]
["First Interim Report - Detail"]
[]
[]
[null,null,null,null,null,"Charter School Name:","Magnolia Science Academy"]
[null,null,null,null,null,"(continued)","Santa Ana"]
[null,null,null,null,null,"CDS #:","30-76893-0130765"]
[null,null,null,null,null,"Charter Approving Entity:","State Board of Education"]
[null,null,null,null,null,"County:","Orange"]
[null,null,null,null,null,"Charter #:","1686"]
[null,null,null,null,null,"Fiscal Year:","2016/17"]
[]
["This charter school uses the following basis of accounting:"]
[null,"X","   Accrual Basis (Applicable Capital Assets / Interest on Long-Term Debt / Long-Term Liabilities objects are 6900, 7438, 9400-9499, and 9660-9669)"]
[]
[null,null,"   Modified Accrual Basis (Applicable Capital Outlay / Debt Service objects are 6100-6170, 6200-6500, 7438, and 7439)"]
[]
[null,null,null,null,null," Adopted Budget - July 1",null,null,"Actuals thru 10/31",null,null,"1st Interim Budget"]
[null,null,null,"              Description","Object Code","Unrestricted","Restricted","Total","Unrestricted","Restricted","Total","Unrestricted","Restricted","Total"]
["A.","REVENUES",null,null," "]
[null,"1.","LCFF/Revenue Limit Sources",null," "]
[null,null,null,"State Aid - Current Year",8011,3517160.0564999999,0,{"$f":"SUM(F23:G23)","v":3517160.0564999999},430852.6,null,{"$f":"SUM(I23:J23)","v":430852.6},4208989.2838000013,null,{"$f":"SUM(L23:M23)","v":4208989.2838000013}]
[null,null,null,"Education Protection Account State Aid - Current Year",8012,102290,0,{"$f":"SUM(F24:G24)","v":102290},7167,null,{"$f":"SUM(I24:J24)","v":7167},121204,null,{"$f":"SUM(L24:M24)","v":121204}]
[null,null,null,"Charter Schools Gen. Purpose Entitlement - State Aid",8015,0,0,0,null,null,0,null,null,0]
[null,null,null,"State Aid - Prior Years",8019,0,0,0,0,null,0,0,null,0]
[null,null,null,"Tax Relief Subventions ","8020-8039",0,0,0,null,null,0,null,null,0]
[null,null,null,"County and District Taxes ","8040-8079",0,0,0,null,null,0,null,null,0]
[null,null,null,"Miscellaneous Funds","8080-8089",0,0,0,null,null,0,null,null,0]
[null,null,null,"LCFF/Revenue Limit Transfers:"]
[null,null,null,"    PERS Reduction Transfer",8092,0,0,{"$f":"SUM(F31:G31)","v":0},null,null,{"$f":"SUM(I31:J31)","v":0},null,null,{"$f":"SUM(L31:M31)","v":0}]
[null," ",null,"    Charter Schools Funding in lieu of Property Taxes",8096,975861.94349999994,0,{"$f":"SUM(F32:G32)","v":975861.94349999994},66886,null,{"$f":"SUM(I32:J32)","v":66886},1147080.7161999999,null,{"$f":"SUM(L32:M32)","v":1147080.7161999999}]
[null,null,null,"    Other LCFF/Revenue Limit Transfers","8091, 8097",0,0,{"$f":"SUM(F33:G33)","v":0},null,null,{"$f":"SUM(I33:J33)","v":0},null,null,{"$f":"SUM(L33:M33)","v":0}]
[null,null,null,"          Total, LCFF/Revenue Limit Sources"," ",{"$f":"SUM((F23:F29),(F31:F33))","v":4595312},0,4595312,504905.6,0,504905.6,5477274.0000000009,0,5477274.0000000009]
[null,null,null,null," "]
[null,"2.","Federal Revenues",null," "]
[null,null,null,"No Child Left Behind",8290,0,0,{"$f":"SUM(F37:G37)","v":0},null,8155,{"$f":"SUM(I37:J37)","v":8155},0,136851.29,{"$f":"SUM(L37:M37)","v":136851.29}]
[null,null,null,"Special Education - Federal","8181, 8182",0,17061.286550000001,{"$f":"SUM(F38:G38)","v":17061.286550000001},null,3590.4,{"$f":"SUM(I38:J38)","v":3590.4},0,18000,{"$f":"SUM(L38:M38)","v":18000}]
[null,null,null,"Child Nutrition - Federal",8220,0,183549.59999999998,{"$f":"SUM(F39:G39)","v":183549.59999999998},null,0,{"$f":"SUM(I39:J39)","v":0},0,227287.0998892308,{"$f":"SUM(L39:M39)","v":227287.0998892308}]
[null,null,null,"Donated Food Commodities",8221,0]
[null,null,null,"Other Federal Revenues","8110, 8260-8299",null,193916.1904761905,{"$f":"SUM(F41:G41)","v":193916.1904761905},null,162,{"$f":"SUM(I41:J41)","v":162},54562,261354.76,{"$f":"SUM(L41:M41)","v":315916.76}]
[null,null,null,"          Total, Federal Revenues "," ",{"$f":"SUM(F37:F41)","v":0},{"$f":"SUM(G37:G41)","v":394527.07702619047},{"$f":"SUM(H37:H41)","v":394527.07702619047},{"$f":"SUM(I37:I41)","v":0},{"$f":"SUM(J37:J41)","v":11907.4},{"$f":"SUM(K37:K41)","v":11907.4},{"$f":"SUM(L37:L41)","v":54562},{"$f":"SUM(M37:M41)","v":643493.14988923084},698055.14988923084]
[null,null,null,null," "]
[null,"3.","Other State Revenues",null," "]
[null,null,null,"Charter Schools Categorical Block Grant (8480 N/A thru 14/15-SBX3-4)","N/A thru 14/15",null,null,{"$f":"SUM(F45:G45)","v":0},null,null,{"$f":"SUM(I45:J45)","v":0},null,null,{"$f":"SUM(L45:M45)","v":0}]
[null,null,null,"Special Education - State","StateRevSE",0,245368.13749999998,{"$f":"SUM(F46:G46)","v":245368.13749999998},null,19851,{"$f":"SUM(I46:J46)","v":19851},0,304828.06,{"$f":"SUM(L46:M46)","v":304828.06}]
[null,null,null,"All Other State Revenues","StateRevAO",93154.248499999987,7395.7714285714319,{"$f":"SUM(F47:G47)","v":100550.01992857142},4877.6499999999996,0,{"$f":"SUM(I47:J47)","v":4877.6499999999996},147808.49320720357,100945.02198895026,{"$f":"SUM(L47:M47)","v":248753.51519615384}]
[null,null,null,"         Total, Other State Revenues"," ",{"$f":"SUM(F45:F47)","v":93154.248499999987},{"$f":"SUM(G45:G47)","v":252763.90892857141},{"$f":"SUM(H45:H47)","v":345918.15742857137},{"$f":"SUM(I45:I47)","v":4877.6499999999996},19851,24728.65,147808.49320720357,405773.08198895026,553581.57519615383]
[null,null,null,null," "]
[null,"4.","Other Local Revenues",null," "]
[null,null,null,"All Other Local Revenues","LocalRevAO",22604.503000000001,15900,{"$f":"SUM(F51:G51)","v":38504.502999999997},18335.52,2514,{"$f":"SUM(I51:J51)","v":20849.52},39235.103000000003,0,{"$f":"SUM(L51:M51)","v":39235.103000000003}]
[null,null,null,"          Total, Local Revenues"," ",{"$f":"SUM(F51:F51)","v":22604.503000000001},{"$f":"SUM(G51:G51)","v":15900},{"$f":"SUM(H51:H51)","v":38504.502999999997},18335.52,2514,20849.52,39235.103000000003,0,39235.103000000003]
[null,null," "," "," "]
[null,"5.","TOTAL REVENUES",null," ",{"$f":"SUM(F34,F42,F48,F52)","v":4711070.7514999993},663190.98595476185,5374261.7374547608,528118.77,34272.400000000001,562391.17000000004,5718879.5962072043,1049266.231878181,6768145.8280853853]
[null,null,null,null," "]
["B.","EXPENDITURES",null,null," "]
[null,"1.","Certificated Salaries",null," "]
[null,null,null,"Certificated Teachers' Salaries",1100,1697370.1511790995,89729.848820900545,{"$f":"SUM(F58:G58)","v":1787100},474883.56,67386.600000000006,{"$f":"SUM(I58:J58)","v":542270.16},1781679.3255197015,263977.43448029866,{"$f":"SUM(L58:M58)","v":2045656.7600000002}]
[null,null,null,"Certificated Pupil Support Salaries",1200,0,0,{"$f":"SUM(F59:G59)","v":0},0,0,{"$f":"SUM(I59:J59)","v":0},0,0,{"$f":"SUM(L59:M59)","v":0}]
[null,null,null,"Certificated Supervisors' and Administrators' Salaries",1300,360450,0,{"$f":"SUM(F60:G60)","v":360450},116857.09,19910,{"$f":"SUM(I60:J60)","v":136767.09},360063.15638138348,135605.92361861648,{"$f":"SUM(L60:M60)","v":495669.07999999996}]
[null,null,null,"Other Certificated Salaries",1900,0,0,{"$f":"SUM(F61:G61)","v":0},0,0,{"$f":"SUM(I61:J61)","v":0},0,0,{"$f":"SUM(L61:M61)","v":0}]
[null,null,null,"          Total, Certificated Salaries"," ",{"$f":"SUM(F58:F61)","v":2057820.1511790995},{"$f":"SUM(G58:G61)","v":89729.848820900545},{"$f":"SUM(H58:H61)","v":2147550},{"$f":"SUM(I58:I61)","v":591740.65},87296.6,679037.25,2141742.481901085,399583.35809891514,2541325.8400000003]
[null,null,null,null," "]
[null,"2.","Non-certificated Salaries",null," "]
[null,null,null,"Non-certificated Instructional Aides' Salaries",2100,0,0,{"$f":"SUM(F65:G65)","v":0},0,0,{"$f":"SUM(I65:J65)","v":0},0,0,{"$f":"SUM(L65:M65)","v":0}]
[null,null,null,"Non-certificated Support Salaries",2200,0,0,{"$f":"SUM(F66:G66)","v":0},0,0,{"$f":"SUM(I66:J66)","v":0},0,0,{"$f":"SUM(L66:M66)","v":0}]
[null,null,null,"Non-certificated Supervisors' and Administrators' Sal.",2300,0,0,{"$f":"SUM(F67:G67)","v":0},0,0,{"$f":"SUM(I67:J67)","v":0},0,0,{"$f":"SUM(L67:M67)","v":0}]
[null,null,null,"Clerical and Office Salaries",2400,70000.000000000015,0,{"$f":"SUM(F68:G68)","v":70000.000000000015},46046.78,0,{"$f":"SUM(I68:J68)","v":46046.78},380571.07,92760,{"$f":"SUM(L68:M68)","v":473331.07}]
[null,null,null,"Other Non-certificated Salaries",2900,165580,0,{"$f":"SUM(F69:G69)","v":165580},37910.43,13317.55,{"$f":"SUM(I69:J69)","v":51227.979999999996},0,0,{"$f":"SUM(L69:M69)","v":0}]
[null,null,null,"          Total, Non-certificated Salaries"," ",{"$f":"SUM(F65:F69)","v":235580},{"$f":"SUM(G65:G69)","v":0},{"$f":"SUM(H65:H69)","v":235580},{"$f":"SUM(I65:I69)","v":83957.209999999992},13317.55,97274.76,380571.07,92760,473331.07]
[]
[null,"3.","Employee Benefits",null," "]
[null,null,null,"STRS","3101-3102",237981.65869544042,11926.331304559604,{"$f":"SUM(F73:G73)","v":249907.99000000002},76723.56,152.12,{"$f":"SUM(I73:J73)","v":76875.679999999993},252025.77674616818,49194.207895831816,{"$f":"SUM(L73:M73)","v":301219.984642}]
[null,null,null,"PERS","3201-3202",8025.4962843363919,402.19371566360854,8427.69,4144.79,603.70000000000005,4748.49,9413.4273616250703,1837.4553135749279,11250.882675199999]
[null,null,null,"OASDI / Medicare / Alternative","3301-3302",56209.33122917563,2816.9024046714107,59026.233633847041,21532.29,38.950000000000003,21571.24,69209.830394191726,13509.42284080826,82719.253234999982]
[null,null,null,"Health and Welfare Benefits","3401-3402",316251.22851316509,15848.771486834996,332100.00000000006,84941.58,0,84941.58,286561.80662924988,55935.473237416802,342497.27986666671]
[null,null,null,"Unemployment Insurance","3501-3502",1134.7000755895499,56.864924410450286,1191.5650000000003,-329,0,-329,3771.2071337881957,736.12132121180412,4507.3284549999998]
[null,null,null,"Workers' Compensation Insurance","3601-3602",22694.001511790993,1137.2984882090057,23831.3,4283,0,4283,28401.250594406207,5543.7862121937842,33945.036806599994]
[null,null,null,"OPEB, Allocated","3701-3702",0,0,0,0,0,0,0,0,0]
[null,null,null,"OPEB, Active Employees","3751-3752",0,0,0,null,null,0,null,null,0]
[null,null,null,"PERS Reduction (for revenue limit funded schools)","3801-3802",0,0,0,0,0,0,0,0,0]
[null,null,null,"Other Employee Benefits","3901-3902",2039.7775714399261,102.22242856007392,2142,0,0,0,0,0,0]
[null,null,null,"          Total, Employee Benefits"," ",{"$f":"SUM(F73:F82)","v":644336.19388093811},32290.584752909148,676626.77863384713,191296.21999999997,794.7700000000001,192090.99,649383.29885942908,126756.46682103738,776139.76568046655]
[null,null,null,null," "]
[null,"4.","Books and Supplies",null," "]
[null,null,null,"Approved Textbooks and Core Curricula Materials",4100,235150,0,{"$f":"SUM(F86:G86)","v":235150},10265.42,207889.42,{"$f":"SUM(I86:J86)","v":218154.84000000003},31614.760000000009,208385.24,{"$f":"SUM(L86:M86)","v":240000}]
[null,null,null,"Books and Other Reference Materials",4200,32334.857142857145,2665.1428571428569,{"$f":"SUM(F87:G87)","v":35000},1668.7,0,{"$f":"SUM(I87:J87)","v":1668.7},20000,0,{"$f":"SUM(L87:M87)","v":20000}]
[null,null,null,"Materials and Supplies",4300,103884.8275862069,0,{"$f":"SUM(F88:G88)","v":103884.8275862069},45493.55,2341.7199999999998,{"$f":"SUM(I88:J88)","v":47835.270000000004},110221.27801104973,25970.451988950277,{"$f":"SUM(L88:M88)","v":136191.73000000001}]
[null,null,null,"Noncapitalized Equipment",4400,54450,54400,{"$f":"SUM(F89:G89)","v":108850},21481.54,52944.09,{"$f":"SUM(I89:J89)","v":74425.63},141798.72999999998,52944.09,{"$f":"SUM(L89:M89)","v":194742.81999999998}]
[null,null,null,"Food",4700,2000,206845.37142857141,{"$f":"SUM(F90:G90)","v":208845.37142857141},1588.4799999999998,50704.6,{"$f":"SUM(I90:J90)","v":52293.08},5000,270190.77722215391,{"$f":"SUM(L90:M90)","v":275190.77722215391}]
[null,null,null,"          Total, Books and Supplies"," ",{"$f":"SUM(F86:F90)","v":427819.68472906406},{"$f":"SUM(G86:G90)","v":263910.51428571425},{"$f":"SUM(H86:H90)","v":691730.19901477825},{"$f":"SUM(I86:I90)","v":80497.69},313879.82999999996,394377.52000000008,308634.76801104972,557490.55921110418,866125.32722215378]
[null,null,null,null," "]
[null,"5.","Services and Other Operating Expenditures",null," "]
[null,null,null,"Subagreements for Services",5100,1005424.1962239109,0,{"$f":"SUM(F94:G94)","v":1005424.1962239109},324063.88,0,{"$f":"SUM(I94:J94)","v":324063.88},1088790.4515428888,0,{"$f":"SUM(L94:M94)","v":1088790.4515428888}]
[null,null,null,"Travel and Conferences",5200,28809.090909090912,0,{"$f":"SUM(F95:G95)","v":28809.090909090912},1602.41,310,{"$f":"SUM(I95:J95)","v":1912.41},18809.090909090912,0,{"$f":"SUM(L95:M95)","v":18809.090909090912}]
[null,null,null,"Dues and Memberships",5300,6000,0,6000,1820,0,1820,6000,0,6000]
[null,null,null,"Insurance","5400",32415.12165517241,0,32415.12165517241,6654,0,6654,21456,0,21456]
[null,null,null,"Operations and Housekeeping Services",5500,63500,0,63500,40981.79,0,40981.79,169772.38,0,169772.38]
[null,null,null,"Rentals, Leases, Repairs, and Noncap. Improvements",5600,50344,0,50344,44650.59,0,44650.59,88839.43,0,88839.43]
[null,null,null,"Professional/Consulting Services and Operating Expend.",5800,308965.44214025972,267712.03809523809,576677.48023549782,53098.329999999994,334,53432.329999999994,651975.70240000007,20362.29,672337.9924000001]
[null,null,null,"Communications",5900,12598.695599999999,0,12598.695599999999,6002.18,0,6002.18,24798.695599999999,0,24798.695599999999]
[null,null,null,"          Total, Services and Other Operating Expenditures"," ",{"$f":"SUM(F94:F101)","v":1508056.5465284339},{"$f":"SUM(G94:G101)","v":267712.03809523809},1775768.5846236718,478873.17999999993,644,479517.17999999993,2070441.7504519795,20362.29,2090804.0404519795]
[null,null," ",null," "]
[null,"6.","Capital Outlay  (Objects 6100-6170, 6200-6500 for modified accrual basis only)",null," "]
[null,null,null,"Land and Land Improvements","6100-6170",0,0,{"$f":"SUM(F105:G105)","v":0},0,0,{"$f":"SUM(I105:J105)","v":0},null,null,{"$f":"SUM(L105:M105)","v":0}]
[null,null,null,"Buildings and Improvements of Buildings",6200,0,0,{"$f":"SUM(F106:G106)","v":0},0,0,{"$f":"SUM(I106:J106)","v":0},null,null,{"$f":"SUM(L106:M106)","v":0}]
[null,null,null,"Books and Media for New School Libraries or Major"," "]
[null,null,null,"     Expansion of School Libraries",6300,0,0,{"$f":"SUM(F108:G108)","v":0},0,0,{"$f":"SUM(I108:J108)","v":0},null,null,{"$f":"SUM(L108:M108)","v":0}]
[null,null,null,"Equipment ",6400,0,0,{"$f":"SUM(F109:G109)","v":0},0,0,{"$f":"SUM(I109:J109)","v":0},null,null,{"$f":"SUM(L109:M109)","v":0}]
[null,null,null,"Equipment Replacement",6500,0,0,{"$f":"SUM(F110:G110)","v":0},0,0,{"$f":"SUM(I110:J110)","v":0},null,null,{"$f":"SUM(L110:M110)","v":0}]
[null,null,null,"Depreciation Expense (for accrual basis only)",6900,55373.333333333314,341860.53846153844,{"$f":"SUM(F111:G111)","v":397233.87179487175},132411.32,0,{"$f":"SUM(I111:J111)","v":132411.32},363466.42330891336,0,{"$f":"SUM(L111:M111)","v":363466.42330891336}]
[null,null," ","          Total, Capital Outlay"," ",{"$f":"SUM(F105:F106)+SUM(F108:F111)","v":55373.333333333314},{"$f":"SUM(G105:G106)+SUM(G108:G111)","v":341860.53846153844},{"$f":"SUM(H105:H106)+SUM(H108:H111)","v":397233.87179487175},{"$f":"SUM(I105:I106)+SUM(I108:I111)","v":132411.32},0,132411.32,363466.42330891336,0,363466.42330891336]
[null,null,null,null," "]
[null,"7.","Other Outgo ",null," "]
[null," ",null,"Tuition to Other Schools","7110-7143",0,0,{"$f":"SUM(F115:G115)","v":0},null,null,{"$f":"SUM(I115:J115)","v":0},null,null,{"$f":"SUM(L115:M115)","v":0}]
[null,null,null,"Transfers of Pass-through Revenues to Other LEAs","7211-7213",0,0,{"$f":"SUM(F116:G116)","v":0},null,null,{"$f":"SUM(I116:J116)","v":0},null,null,{"$f":"SUM(L116:M116)","v":0}]
[null,null,null,"Transfers of Apportionments to Other LEAs - Spec. Ed.","7221-7223SE",0,0,{"$f":"SUM(F117:G117)","v":0},null,null,{"$f":"SUM(I117:J117)","v":0},null,null,{"$f":"SUM(L117:M117)","v":0}]
[null,null,null,"Transfers of Apportionments to Other LEAs - All Other","7221-7223AO",0,0,{"$f":"SUM(F118:G118)","v":0},null,null,{"$f":"SUM(I118:J118)","v":0},null,null,{"$f":"SUM(L118:M118)","v":0}]
[null,null,null,"All Other Transfers","7281-7299",0,0,{"$f":"SUM(F119:G119)","v":0},0,0,{"$f":"SUM(I119:J119)","v":0},null,null,{"$f":"SUM(L119:M119)","v":0}]
[null,null,null,"Debt Service:"," "]
[null,null,null,"     Interest",7438,0,0,{"$f":"SUM(F121:G121)","v":0},0,0,{"$f":"SUM(I121:J121)","v":0},null,null,{"$f":"SUM(L121:M121)","v":0}]
[null,null,null,"     Principal (for modified accrual basis only)",7439,0,0,{"$f":"SUM(F122:G122)","v":0},0,0,{"$f":"SUM(I122:J122)","v":0},null,null,{"$f":"SUM(L122:M122)","v":0}]
[null,null,null,"          Total, Other Outgo"," ",{"$f":"SUM(F115:F119,F121:F122)","v":0},0,0,0,0,0,0,0,0]
[null,null,null,null," "]
[null,"8.","TOTAL EXPENDITURES",null," ",{"$f":"SUM(F62,F70,F83,F91,F102,F112,F123)","v":4928985.9096508687},995503.52441630047,5924489.4340671692,1558776.27,415932.75,1974709.02,{"$f":"SUM(L62,L70,L83,L91,L102,L112,L123)","v":5914239.792532457},1196952.6741310568,7111192.4666635133]
[null,null,null,null," "]
["C.","EXCESS (DEFICIENCY) OF REVENUES OVER EXPEND.",null,null," "]
[null,"BEFORE OTHER FINANCING SOURCES AND USES (A5-B8)",null,null," ",{"$f":"SUM(F54-F125)","v":-217915.15815086942},-332312.53846153861,-550227.69661240838,-1030657.5,-381660.35,-1412317.85,-195360.19632525276,-147686.44225287577,-343046.63857812807]
[]
["D.","OTHER FINANCING SOURCES / USES",null,null," "]
[null,"1.","Other Sources",null,"8930-8979",0,0,{"$f":"SUM(F131:G131)","v":0},null,null,{"$f":"SUM(I131:J131)","v":0},null,null,{"$f":"SUM(L131:M131)","v":0}]
[null,"2.","Less:  Other Uses",null,"7630-7699",0,0,{"$f":"SUM(F132:G132)","v":0},null,null,{"$f":"SUM(I132:J132)","v":0},null,null,{"$f":"SUM(L132:M132)","v":0}]
[null,"3.","Contributions Between Unrestricted and Restricted Accounts"]
[null,null,"(must net to zero)",null,"8980-8999",0,0,{"$f":"SUM(F134:G134)","v":0},null,null,{"$f":"SUM(I134:J134)","v":0},null,null,{"$f":"SUM(L134:M134)","v":0}]
[null," ",null,null," "]
[null,"4.","TOTAL OTHER FINANCING SOURCES / USES",null," ",{"$f":"SUM(+F131-F132+F134)","v":0},{"$f":"SUM(+G131-G132+G134)","v":0},{"$f":"SUM(+H131-H132+H134)","v":0},{"$f":"SUM(+I131-I132+I134)","v":0},0,0,0,0,0]
[null,null,null,null," "]
["E.","NET INCREASE (DECREASE) IN FUND BALANCE (C + D4) ",null,null," ",{"$f":"SUM(F128,F136)","v":-217915.15815086942},{"$f":"SUM(G128,G136)","v":-332312.53846153861},{"$f":"SUM(H128,H136)","v":-550227.69661240838},{"$f":"SUM(I128,I136)","v":-1030657.5},-381660.35,-1412317.85,-195360.19632525276,-147686.44225287577,-343046.63857812807]
[null," ",null,null," "]
["F.","FUND BALANCE, RESERVES",null,null," "]
[null,"1.","Beginning Fund Balance"]
[null,null,"a.","As of July 1",9791,1572747.1303964006,6640139.4003111515,{"$f":"SUM(F142:G142)","v":8212886.5307075521},1092100.01,7199001.3700000001,{"$f":"SUM(I142:J142)","v":8291101.3799999999},1092100.01,7199001.3700000001,{"$f":"SUM(L142:M142)","v":8291101.3799999999}]
[" ",null,"b.","Adjustments to Beginning Balance","9793, 9795",0,0,{"$f":"SUM(F143:G143)","v":0},1363833.9899999993,-1356014.37,{"$f":"SUM(I143:J143)","v":7819.6199999991804},1363833.9899999993,-1356014.37,{"$f":"SUM(L143:M143)","v":7819.6199999991804}]
[null,null,"c.","Adjusted Beginning Balance"," ",{"$f":"SUM(F142:F143)","v":1572747.1303964006},{"$f":"SUM(G142:G143)","v":6640139.4003111515},{"$f":"SUM(H142:H143)","v":8212886.5307075521},{"$f":"SUM(I142:I143)","v":2455933.9999999991},5842987,8298920.9999999991,2455933.9999999991,5842987,8298920.9999999991]
[null,"2.","Ending Fund Balance, June 30 (E + F.1.c.)",null," ",{"$f":"SUM(F138,F144)","v":1354831.9722455312},{"$f":"SUM(G138,G144)","v":6307826.8618496126},{"$f":"SUM(H138,H144)","v":7662658.8340951437},{"$f":"SUM(I138,I144)","v":1425276.4999999991},5461326.6500000004,6886603.1499999985,2260573.8036747463,5695300.5577471238,7955874.361421871]
[]
[null,null,"Components of Ending Fund Balance :",null," "]
[null,null,"a. ","Nonspendable"]
[null,null,null,"Revolving Cash (equals object 9130)",9711,0,null,{"$f":"SUM(F149:G149)","v":0},null,null,{"$f":"SUM(I149:J149)","v":0},null,null,{"$f":"SUM(L149:M149)","v":0}]
[null,null,null,"Stores (equals object 9320)",9712,0,0,0,null,null,0,null,null,0]
[null,null,null,"Prepaid Expenditures (equals object 9330)",9713,0,0,0,null,null,0,null,null,0]
[null,null,null,"All Others",9719,0,0,0,null,null,0,null,null,0]
[null,null,"b","Restricted",9740,null,6307826.8600000003,6307826.8600000003,null,6817341.0200000005,6817341.0200000005,null,7051314.9277471248,7051314.9277471248]
[null,null,"c.","Committed"]
[null,null,null,"Stabilization Arrangements",9750,0,null,0,null,null,0,null,null,0]
[null,null,null,"Other Commitments",9760,0,null,0,null,null,0,null,null,0]
[null,null,"d.","Assigned",null,null,null,0,null,null,0,null,null,0]
[null,null,null,"Other Assignments",9780,0,null,0,null,null,0,null,null,0]
[null,null,"e","Unassigned/Unappropriated",null,null,null,0,null,null,0,null,null,0]
[null,null,null,"Reserve for Economic Uncertainities",9789,0,0,0,null,null,0,null,null,0]
[null,null,null,"Unassigned/Unappropriated Amount",9790,1354831.9722455312,1.849612221121788E-3,1354831.9740951434,69262.130000000121,0,69262.130000000121,903684.43490189151,0,903684.43490189151]

{"sheet":"1st Summary","index":2,"n_rows":158,"n_cols":10,"rows_kept":158,"cut":false,"hidden":false,"merged":[[0,0,0,9],[1,0,1,9],[3,0,3,9],[2,0,2,9],[8,0,8,3],[5,4,5,5],[7,0,7,3],[6,4,6,5],[5,0,5,3],[7,4,7,5],[8,4,8,5],[14,8,14,9],[9,0,9,3],[10,0,10,3],[11,0,11,3],[13,8,13,9],[9,4,9,5],[10,4,10,5],[11,4,11,5]]}
["CHARTER SCHOOL "]
["INTERIM FINANCIAL REPORT - ALTERNATIVE FORM"]
["First Interim Report - Summary"]
[]
[]
["Charter School Name:",null,null,null,{"$f":"IF('1st Detail'!G6=\"\",\"\",'1st Detail'!G6)","v":"Magnolia Science Academy"}]
[null,null,null,"(continued)",{"$f":"IF('1st Detail'!G7=\"\",\"\",'1st Detail'!G7)","v":"Santa Ana"}]
["CDS #:",null,null,null,{"$f":"IF('1st Detail'!G8=\"\",\"\",'1st Detail'!G8)","v":"30-76893-0130765"}]
["Charter Approving Entity:",null,null,null,{"$f":"IF('1st Detail'!G9=\"\",\"\",'1st Detail'!G9)","v":"State Board of Education"}]
["County:",null,null,null,{"$f":"IF('1st Detail'!G10=\"\",\"\",'1st Detail'!G10)","v":"Orange"}]
["Charter #:",null,null,null,{"$f":"IF('1st Detail'!G11=\"\",\"\",'1st Detail'!G11)","v":"1686"}]
["Fiscal Year:",null,null,null,{"$f":"IF('1st Detail'!G12=\"\",\"\",'1st Detail'!G12)","v":"2016/17"}]
[]
[null,null,null,null,null,null,null,null,"1st Interim vs. Adopted"]
[null,null,null,null,null,null,null,null,"Increase, (Decrease)"]
[null,null,null,null,null,"7/1 Adopted","Actuals thru","1st Interim","$ Difference","% Change"]
[null,null,null,"              Description","Object Code","Budget (X)","10/31 (Y)","Budget (Z)","(Z) vs. (X)","(Z) vs. (X)"]
["A.","REVENUES",null,null," "]
[null,"1.","LCFF/Revenue Limit Sources",null," "]
[null,null,null,"State Aid - Current Year",8011,{"$f":"'1st Detail'!H23","v":3517160.0564999999},{"$f":"'1st Detail'!K23","v":430852.6},{"$f":"'1st Detail'!N23","v":4208989.2838000013},{"$f":"H20-F20","v":691829.22730000131},{"$f":"IF(AND(F20=0,H20=0),\"\",(IF(F20=\"\",\"\",(IF(F20=0,\"New\",(IF(H20=0,\"(100%)\",((H20/F20)-1))))))))","v":0.19670109298024241}]
[null,null,null,"Education Protection Account State Aid - Current Year",8012,{"$f":"'1st Detail'!H24","v":102290},{"$f":"'1st Detail'!K24","v":7167},{"$f":"'1st Detail'!N24","v":121204},{"$f":"H21-F21","v":18914},{"$f":"IF(AND(F21=0,H21=0),\"\",(IF(F21=\"\",\"\",(IF(F21=0,\"New\",(IF(H21=0,\"(100%)\",((H21/F21)-1))))))))","v":0.18490566037735845}]
[null,null,null,"Charter Schools Gen. Purpose Entitlement - State Aid",8015,{"$f":"'1st Detail'!H25","v":0},{"$f":"'1st Detail'!K25","v":0},{"$f":"'1st Detail'!N25","v":0},{"$f":"H22-F22","v":0},{"$f":"IF(AND(F22=0,H22=0),\"\",(IF(F22=\"\",\"\",(IF(F22=0,\"New\",(IF(H22=0,\"(100%)\",((H22/F22)-1))))))))","v":""}]
[null,null,null,"State Aid - Prior Years",8019,{"$f":"'1st Detail'!H26","v":0},{"$f":"'1st Detail'!K26","v":0},{"$f":"'1st Detail'!N26","v":0},0,{"$f":"IF(AND(F23=0,H23=0),\"\",(IF(F23=\"\",\"\",(IF(F23=0,\"New\",(IF(H23=0,\"(100%)\",((H23/F23)-1))))))))","v":""}]
[null,null,null,"Tax Relief Subventions ","8020-8039",{"$f":"'1st Detail'!H27","v":0},{"$f":"'1st Detail'!K27","v":0},{"$f":"'1st Detail'!N27","v":0},0,{"$f":"IF(AND(F24=0,H24=0),\"\",(IF(F24=\"\",\"\",(IF(F24=0,\"New\",(IF(H24=0,\"(100%)\",((H24/F24)-1))))))))","v":""}]
[null,null,null,"County and District Taxes ","8040-8079",{"$f":"'1st Detail'!H28","v":0},{"$f":"'1st Detail'!K28","v":0},{"$f":"'1st Detail'!N28","v":0},0,""]
[null,null,null,"Miscellaneous Funds","8080-8089",{"$f":"'1st Detail'!H29","v":0},{"$f":"'1st Detail'!K29","v":0},{"$f":"'1st Detail'!N29","v":0},0,""]
[null,null,null,"LCFF/Revenue Limit Transfers:"]
[null,null,null,"    PERS Reduction Transfer",8092,{"$f":"'1st Detail'!H31","v":0},{"$f":"'1st Detail'!K31","v":0},{"$f":"'1st Detail'!N31","v":0},0,""]
[null," ",null,"    Charter Schools Funding in lieu of Property Taxes",8096,{"$f":"'1st Detail'!H32","v":975861.94349999994},{"$f":"'1st Detail'!K32","v":66886},{"$f":"'1st Detail'!N32","v":1147080.7161999999},{"$f":"H29-F29","v":171218.77269999997},{"$f":"IF(AND(F29=0,H29=0),\"\",(IF(F29=\"\",\"\",(IF(F29=0,\"New\",(IF(H29=0,\"(100%)\",((H29/F29)-1))))))))","v":0.17545388857558208}]
[null,null,null,"    Other LCFF/Revenue Limit Transfers","8091, 8097",{"$f":"'1st Detail'!H33","v":0},{"$f":"'1st Detail'!K33","v":0},{"$f":"'1st Detail'!N33","v":0},0,""]
[null,null,null,"          Total, LCFF/Revenue Limit Sources"," ",{"$f":"SUM((F20:F26),(F28:F30))","v":4595312},{"$f":"SUM((G20:G26),(G28:G30))","v":504905.6},{"$f":"SUM((H20:H26),(H28:H30))","v":5477274.0000000009},{"$f":"SUM((I20:I26),(I28:I30))","v":881962.00000000128},{"$f":"IF(F31=0,\"\",(IF(H31=0,0,((H31/F31)-1))))","v":0.19192646766966015}]
[null,null,null,null," "]
[null,"2.","Federal Revenues",null," "]
[null,null,null,"No Child Left Behind  (Include ARRA)",8290,{"$f":"'1st Detail'!H37","v":0},{"$f":"'1st Detail'!K37","v":8155},{"$f":"'1st Detail'!N37","v":136851.29},{"$f":"H34-F34","v":136851.29},{"$f":"IF(AND(F34=0,H34=0),\"\",(IF(F34=\"\",\"\",(IF(F34=0,\"New\",(IF(H34=0,\"(100%)\",((H34/F34)-1))))))))","v":"New"}]
[null,null,null,"Special Education - Federal","8181, 8182",{"$f":"'1st Detail'!H38","v":17061.286550000001},{"$f":"'1st Detail'!K38","v":3590.4},{"$f":"'1st Detail'!N38","v":18000},{"$f":"H35-F35","v":938.71344999999928},{"$f":"IF(AND(F35=0,H35=0),\"\",(IF(F35=\"\",\"\",(IF(F35=0,\"New\",(IF(H35=0,\"(100%)\",((H35/F35)-1))))))))","v":5.5020085809413866E-2}]
[null,null,null,"Child Nutrition - Federal",8220,{"$f":"'1st Detail'!H39","v":183549.59999999998},{"$f":"'1st Detail'!K39","v":0},{"$f":"'1st Detail'!N39","v":227287.0998892308},{"$f":"H36-F36","v":43737.499889230821},{"$f":"IF(AND(F36=0,H36=0),\"\",(IF(F36=\"\",\"\",(IF(F36=0,\"New\",(IF(H36=0,\"(100%)\",((H36/F36)-1))))))))","v":0.23828708909870033}]
[null,null,null,"Donated Food Commodities",8221,{"$f":"'1st Detail'!H40","v":0},{"$f":"'1st Detail'!K40","v":0},{"$f":"'1st Detail'!N40","v":0},{"$f":"H37-F37","v":0},{"$f":"IF(AND(F37=0,H37=0),\"\",(IF(F37=\"\",\"\",(IF(F37=0,\"New\",(IF(H37=0,\"(100%)\",((H37/F37)-1))))))))","v":""}]
[null,null,null,"Other Federal Revenues (Include ARRA)","8110, 8260-8299",{"$f":"'1st Detail'!H41","v":193916.1904761905},{"$f":"'1st Detail'!K41","v":162},{"$f":"'1st Detail'!N41","v":315916.76},{"$f":"H38-F38","v":122000.56952380951},{"$f":"IF(AND(F38=0,H38=0),\"\",(IF(F38=\"\",\"\",(IF(F38=0,\"New\",(IF(H38=0,\"(100%)\",((H38/F38)-1))))))))","v":0.62914070879908834}]
[null,null,null,"          Total, Federal Revenues "," ",{"$f":"SUM(F34:F38)","v":394527.07702619047},{"$f":"SUM(G34:G38)","v":11907.4},{"$f":"SUM(H34:H38)","v":698055.14988923084},{"$f":"SUM(I34:I38)","v":303528.07286304038},{"$f":"IF(AND(F39=0,H39=0),\"\",(IF(F39=\"\",\"\",(IF(F39=0,\"New\",(IF(H39=0,\"(100%)\",((H39/F39)-1))))))))","v":0.76934661912416935}]
[null,null,null,null," "]
[null,"3.","Other State Revenues",null," "]
[null,null,null,"Charter Schools Categorical Block Grant ","N/A thru 14/15",{"$f":"'1st Detail'!H45","v":0},{"$f":"'1st Detail'!K45","v":0},{"$f":"'1st Detail'!N45","v":0},{"$f":"H42-F42","v":0},{"$f":"IF(AND(F42=0,H42=0),\"\",(IF(F42=\"\",\"\",(IF(F42=0,\"New\",(IF(H42=0,\"(100%)\",((H42/F42)-1))))))))","v":""}]
[null,null,null,"Special Education - State","StateRevSE",{"$f":"'1st Detail'!H46","v":245368.13749999998},{"$f":"'1st Detail'!K46","v":19851},{"$f":"'1st Detail'!N46","v":304828.06},{"$f":"H43-F43","v":59459.922500000015},{"$f":"IF(AND(F43=0,H43=0),\"\",(IF(F43=\"\",\"\",(IF(F43=0,\"New\",(IF(H43=0,\"(100%)\",((H43/F43)-1))))))))","v":0.24232943651862704}]
[null,null,null,"All Other State Revenues","StateRevAO",{"$f":"'1st Detail'!H47","v":100550.01992857142},{"$f":"'1st Detail'!K47","v":4877.6499999999996},{"$f":"'1st Detail'!N47","v":248753.51519615384},{"$f":"H44-F44","v":148203.49526758242},{"$f":"IF(AND(F44=0,H44=0),\"\",(IF(F44=\"\",\"\",(IF(F44=0,\"New\",(IF(H44=0,\"(100%)\",((H44/F44)-1))))))))","v":1.4739280546424856}]
[null,null,null,"         Total, Other State Revenues"," ",{"$f":"SUM(F42:F44)","v":345918.15742857137},{"$f":"SUM(G42:G44)","v":24728.65},{"$f":"SUM(H42:H44)","v":553581.57519615383},{"$f":"SUM(I42:I44)","v":207663.41776758243},{"$f":"IF(AND(F45=0,H45=0),\"\",(IF(F45=\"\",\"\",(IF(F45=0,\"New\",(IF(H45=0,\"(100%)\",((H45/F45)-1))))))))","v":0.60032528882344915}]
[null,null,null,null," "]
[null,"4.","Other Local Revenues",null," "]
[null,null,null,"All Other Local Revenues","LocalRevAO",{"$f":"'1st Detail'!H51","v":38504.502999999997},{"$f":"'1st Detail'!K51","v":20849.52},{"$f":"'1st Detail'!N51","v":39235.103000000003},{"$f":"H48-F48","v":730.60000000000582},{"$f":"IF(AND(F48=0,H48=0),\"\",(IF(F48=\"\",\"\",(IF(F48=0,\"New\",(IF(H48=0,\"(100%)\",((H48/F48)-1))))))))","v":1.8974404110605025E-2}]
[null,null,null,"          Total, Local Revenues"," ",{"$f":"SUM(F48:F48)","v":38504.502999999997},{"$f":"SUM(G48:G48)","v":20849.52},{"$f":"SUM(H48:H48)","v":39235.103000000003},{"$f":"SUM(I48:I48)","v":730.60000000000582},{"$f":"IF(AND(F49=0,H49=0),\"\",(IF(F49=\"\",\"\",(IF(F49=0,\"New\",(IF(H49=0,\"(100%)\",((H49/F49)-1))))))))","v":1.8974404110605025E-2}]
[null,null," "," "," "]
[null,"5.","TOTAL REVENUES",null," ",{"$f":"SUM(F31,F39,F45,F49)","v":5374261.7374547608},{"$f":"SUM(G31,G39,G45,G49)","v":562391.17000000004},{"$f":"SUM(H31,H39,H45,H49)","v":6768145.8280853853},{"$f":"SUM(I31,I39,I45,I49)","v":1393884.0906306242},{"$f":"IF(AND(F51=0,H51=0),\"\",(IF(F51=\"\",\"\",(IF(F51=0,\"New\",(IF(H51=0,\"(100%)\",((H51/F51)-1))))))))","v":0.25936289647306321}]
[null,null,null,null," "]
["B.","EXPENDITURES",null,null," "]
[null,"1.","Certificated Salaries",null," "]
[null,null,null,"Certificated Teachers' Salaries",1100,{"$f":"'1st Detail'!H58","v":1787100},{"$f":"'1st Detail'!K58","v":542270.16},{"$f":"'1st Detail'!N58","v":2045656.7600000002},{"$f":"H55-F55","v":258556.76000000024},{"$f":"IF(AND(F55=0,H55=0),\"\",(IF(F55=\"\",\"\",(IF(F55=0,\"New\",(IF(H55=0,\"(100%)\",((H55/F55)-1))))))))","v":0.14467951429690573}]
[null,null,null,"Certificated Pupil Support Salaries",1200,{"$f":"'1st Detail'!H59","v":0},{"$f":"'1st Detail'!K59","v":0},{"$f":"'1st Detail'!N59","v":0},{"$f":"H56-F56","v":0},{"$f":"IF(AND(F56=0,H56=0),\"\",(IF(F56=\"\",\"\",(IF(F56=0,\"New\",(IF(H56=0,\"(100%)\",((H56/F56)-1))))))))","v":""}]
[null,null,null,"Certificated Supervisors' and Administrators' Salaries",1300,{"$f":"'1st Detail'!H60","v":360450},{"$f":"'1st Detail'!K60","v":136767.09},{"$f":"'1st Detail'!N60","v":495669.07999999996},{"$f":"H57-F57","v":135219.07999999996},{"$f":"IF(AND(F57=0,H57=0),\"\",(IF(F57=\"\",\"\",(IF(F57=0,\"New\",(IF(H57=0,\"(100%)\",((H57/F57)-1))))))))","v":0.37513963101678449}]
[null,null,null,"Other Certificated Salaries",1900,{"$f":"'1st Detail'!H61","v":0},{"$f":"'1st Detail'!K61","v":0},{"$f":"'1st Detail'!N61","v":0},{"$f":"H58-F58","v":0},{"$f":"IF(AND(F58=0,H58=0),\"\",(IF(F58=\"\",\"\",(IF(F58=0,\"New\",(IF(H58=0,\"(100%)\",((H58/F58)-1))))))))","v":""}]
[null,null,null,"          Total, Certificated Salaries"," ",{"$f":"SUM(F55:F58)","v":2147550},{"$f":"SUM(G55:G58)","v":679037.25},{"$f":"SUM(H55:H58)","v":2541325.8400000003},{"$f":"SUM(I55:I58)","v":393775.8400000002},{"$f":"IF(AND(F59=0,H59=0),\"\",(IF(F59=\"\",\"\",(IF(F59=0,\"New\",(IF(H59=0,\"(100%)\",((H59/F59)-1))))))))","v":0.18336049917347697}]
[null,null,null,null," "]
[null,"2.","Non-certificated Salaries",null," "]
[null,null,null,"Non-certificated Instructional Aides' Salaries",2100,{"$f":"'1st Detail'!H65","v":0},{"$f":"'1st Detail'!K65","v":0},{"$f":"'1st Detail'!N65","v":0},{"$f":"H62-F62","v":0},{"$f":"IF(AND(F62=0,H62=0),\"\",(IF(F62=\"\",\"\",(IF(F62=0,\"New\",(IF(H62=0,\"(100%)\",((H62/F62)-1))))))))","v":""}]
[null,null,null,"Non-certificated Support Salaries",2200,{"$f":"'1st Detail'!H66","v":0},{"$f":"'1st Detail'!K66","v":0},{"$f":"'1st Detail'!N66","v":0},{"$f":"H63-F63","v":0},""]
[null,null,null,"Non-certificated Supervisors' and Administrators' Sal.",2300,{"$f":"'1st Detail'!H67","v":0},{"$f":"'1st Detail'!K67","v":0},{"$f":"'1st Detail'!N67","v":0},{"$f":"H64-F64","v":0},""]
[null,null,null,"Clerical and Office Salaries",2400,{"$f":"'1st Detail'!H68","v":70000.000000000015},{"$f":"'1st Detail'!K68","v":46046.78},{"$f":"'1st Detail'!N68","v":473331.07},{"$f":"H65-F65","v":403331.07},5.7618724285714276]
[null,null,null,"Other Non-certificated Salaries",2900,{"$f":"'1st Detail'!H69","v":165580},{"$f":"'1st Detail'!K69","v":51227.979999999996},{"$f":"'1st Detail'!N69","v":0},{"$f":"H66-F66","v":-165580},"(100%)"]
[null,null,null,"          Total, Non-certificated Salaries"," ",{"$f":"SUM(F62:F66)","v":235580},{"$f":"SUM(G62:G66)","v":97274.76},{"$f":"SUM(H62:H66)","v":473331.07},{"$f":"SUM(I62:I66)","v":237751.07},1.0092158502419561]
[]
[null,"3.","Employee Benefits",null," "]
[null,null,null,"STRS","3101-3102",{"$f":"'1st Detail'!H73","v":249907.99000000002},{"$f":"'1st Detail'!K73","v":76875.679999999993},{"$f":"'1st Detail'!N73","v":301219.984642},{"$f":"H70-F70","v":51311.994641999976},{"$f":"IF(AND(F70=0,H70=0),\"\",(IF(F70=\"\",\"\",(IF(F70=0,\"New\",(IF(H70=0,\"(100%)\",((H70/F70)-1))))))))","v":0.20532354584581292}]
[null,null,null,"PERS","3201-3202",{"$f":"'1st Detail'!H74","v":8427.69},{"$f":"'1st Detail'!K74","v":4748.49},{"$f":"'1st Detail'!N74","v":11250.882675199999},2823.1926751999981,0.33499009517435963]
[null,null,null,"OASDI / Medicare / Alternative","3301-3302",{"$f":"'1st Detail'!H75","v":59026.233633847041},{"$f":"'1st Detail'!K75","v":21571.24},{"$f":"'1st Detail'!N75","v":82719.253234999982},23693.019601152941,0.40139812660462204]
[null,null,null,"Health and Welfare Benefits","3401-3402",{"$f":"'1st Detail'!H76","v":332100.00000000006},{"$f":"'1st Detail'!K76","v":84941.58},{"$f":"'1st Detail'!N76","v":342497.27986666671},10397.279866666649,3.1307678008631878E-2]
[null,null,null,"Unemployment Insurance","3501-3502",{"$f":"'1st Detail'!H77","v":1191.5650000000003},{"$f":"'1st Detail'!K77","v":-329},{"$f":"'1st Detail'!N77","v":4507.3284549999998},3315.7634549999993,2.7826962482113848]
[null,null,null,"Workers' Compensation Insurance","3601-3602",{"$f":"'1st Detail'!H78","v":23831.3},{"$f":"'1st Detail'!K78","v":4283},{"$f":"'1st Detail'!N78","v":33945.036806599994},10113.736806599994,0.42438879988082867]
[null,null,null,"OPEB, Allocated","3701-3702",{"$f":"'1st Detail'!H79","v":0},{"$f":"'1st Detail'!K79","v":0},{"$f":"'1st Detail'!N79","v":0},0,""]
[null,null,null,"OPEB, Active Employees","3751-3752",{"$f":"'1st Detail'!H80","v":0},{"$f":"'1st Detail'!K80","v":0},{"$f":"'1st Detail'!N80","v":0},0,""]
[null,null,null,"PERS Reduction (for revenue limit funded schools)","3801-3802",{"$f":"'1st Detail'!H81","v":0},{"$f":"'1st Detail'!K81","v":0},{"$f":"'1st Detail'!N81","v":0},0,""]
[null,null,null,"Other Employee Benefits","3901-3902",{"$f":"'1st Detail'!H82","v":2142},{"$f":"'1st Detail'!K82","v":0},{"$f":"'1st Detail'!N82","v":0},-2142,"(100%)"]
[null,null,null,"          Total, Employee Benefits"," ",{"$f":"SUM(F70:F79)","v":676626.77863384713},{"$f":"SUM(G70:G79)","v":192090.99},{"$f":"SUM(H70:H79)","v":776139.76568046655},{"$f":"SUM(I70:I79)","v":99512.987046619557},0.14707219724224108]
[null,null,null,null," "]
[null,"4.","Books and Supplies",null," "]
[null,null,null,"Approved Textbooks and Core Curricula Materials",4100,{"$f":"'1st Detail'!H86","v":235150},{"$f":"'1st Detail'!K86","v":218154.84000000003},{"$f":"'1st Detail'!N86","v":240000},{"$f":"H83-F83","v":4850},{"$f":"IF(AND(F83=0,H83=0),\"\",(IF(F83=\"\",\"\",(IF(F83=0,\"New\",(IF(H83=0,\"(100%)\",((H83/F83)-1))))))))","v":2.0625132893897558E-2}]
[null,null,null,"Books and Other Reference Materials",4200,{"$f":"'1st Detail'!H87","v":35000},{"$f":"'1st Detail'!K87","v":1668.7},{"$f":"'1st Detail'!N87","v":20000},{"$f":"H84-F84","v":-15000},-0.4285714285714286]
[null,null,null,"Materials and Supplies",4300,{"$f":"'1st Detail'!H88","v":103884.8275862069},{"$f":"'1st Detail'!K88","v":47835.270000000004},{"$f":"'1st Detail'!N88","v":136191.73000000001},{"$f":"H85-F85","v":32306.902413793112},0.31098768862068749]
[null,null,null,"Noncapitalized Equipment",4400,{"$f":"'1st Detail'!H89","v":108850},{"$f":"'1st Detail'!K89","v":74425.63},{"$f":"'1st Detail'!N89","v":194742.81999999998},{"$f":"H86-F86","v":85892.819999999978},0.78909343132751464]
[null,null,null,"Food",4700,{"$f":"'1st Detail'!H90","v":208845.37142857141},{"$f":"'1st Detail'!K90","v":52293.08},{"$f":"'1st Detail'!N90","v":275190.77722215391},{"$f":"H87-F87","v":66345.405793582497},0.31767716631571963]
[null,null,null,"          Total, Books and Supplies"," ",{"$f":"SUM(F83:F87)","v":691730.19901477825},{"$f":"SUM(G83:G87)","v":394377.52000000008},{"$f":"SUM(H83:H87)","v":866125.32722215378},{"$f":"SUM(I83:I87)","v":174395.12820737559},0.25211437704435058]
[]
[null,"5.","Services and Other Operating Expenditures",null," "]
[null,null,null,"Subagreements for Services",5100,{"$f":"'1st Detail'!H94","v":1005424.1962239109},{"$f":"'1st Detail'!K94","v":324063.88},{"$f":"'1st Detail'!N94","v":1088790.4515428888},{"$f":"H91-F91","v":83366.25531897787},{"$f":"IF(AND(F91=0,H91=0),\"\",(IF(F91=\"\",\"\",(IF(F91=0,\"New\",(IF(H91=0,\"(100%)\",((H91/F91)-1))))))))","v":8.2916499953032741E-2}]
[null,null,null,"Travel and Conferences",5200,{"$f":"'1st Detail'!H95","v":28809.090909090912},{"$f":"'1st Detail'!K95","v":1912.41},{"$f":"'1st Detail'!N95","v":18809.090909090912},{"$f":"H92-F92","v":-10000},{"$f":"IF(AND(F92=0,H92=0),\"\",(IF(F92=\"\",\"\",(IF(F92=0,\"New\",(IF(H92=0,\"(100%)\",((H92/F92)-1))))))))","v":-0.34711265383401702}]
[null,null,null,"Dues and Memberships",5300,{"$f":"'1st Detail'!H96","v":6000},{"$f":"'1st Detail'!K96","v":1820},{"$f":"'1st Detail'!N96","v":6000},0,0]
[null,null,null,"Insurance","5400",{"$f":"'1st Detail'!H97","v":32415.12165517241},{"$f":"'1st Detail'!K97","v":6654},{"$f":"'1st Detail'!N97","v":21456},-10959.12165517241,-0.33808670446324507]
[null,null,null,"Operations and Housekeeping Services",5500,{"$f":"'1st Detail'!H98","v":63500},{"$f":"'1st Detail'!K98","v":40981.79},{"$f":"'1st Detail'!N98","v":169772.38},106272.38,1.6735807874015749]
[null,null,null,"Rentals, Leases, Repairs, and Noncap. Improvements",5600,{"$f":"'1st Detail'!H99","v":50344},{"$f":"'1st Detail'!K99","v":44650.59},{"$f":"'1st Detail'!N99","v":88839.43},38495.429999999993,0.7646478229779119]
[null,null,null,"Professional/Consulting Services and Operating Expend.",5800,{"$f":"'1st Detail'!H100","v":576677.48023549782},{"$f":"'1st Detail'!K100","v":53432.329999999994},{"$f":"'1st Detail'!N100","v":672337.9924000001},95660.512164502288,0.16588217061196397]
[null,null,null,"Communications",5900,{"$f":"'1st Detail'!H101","v":12598.695599999999},{"$f":"'1st Detail'!K101","v":6002.18},{"$f":"'1st Detail'!N101","v":24798.695599999999},12200,0.96835421597137405]
[null,null,null,"          Total, Services and Other Operating Expenditures"," ",{"$f":"SUM(F91:F98)","v":1775768.5846236718},{"$f":"SUM(G91:G98)","v":479517.17999999993},{"$f":"SUM(H91:H98)","v":2090804.0404519795},{"$f":"SUM(I91:I98)","v":315035.45582830778},0.17740794524477477]
[null,null," ","          "," "]
[null,"6.","Capital Outlay (Objects 6100-6170, 6200-6500 modified accrual basis only)",null," "]
[null,null,null,"Land and Land Improvements","6100-6170",{"$f":"'1st Detail'!H105","v":0},{"$f":"'1st Detail'!K105","v":0},{"$f":"'1st Detail'!N105","v":0},{"$f":"H102-F102","v":0},{"$f":"IF(AND(F102=0,H102=0),\"\",(IF(F102=\"\",\"\",(IF(F102=0,\"New\",(IF(H102=0,\"(100%)\",((H102/F102)-1))))))))","v":""}]
[null,null,null,"Buildings and Improvements of Buildings",6200,{"$f":"'1st Detail'!H106","v":0},{"$f":"'1st Detail'!K106","v":0},{"$f":"'1st Detail'!N106","v":0},{"$f":"H103-F103","v":0},{"$f":"IF(AND(F103=0,H103=0),\"\",(IF(F103=\"\",\"\",(IF(F103=0,\"New\",(IF(H103=0,\"(100%)\",((H103/F103)-1))))))))","v":""}]
[null,null,null,"Books and Media for New School Libraries or Major"," "]
[null,null,null,"     Expansion of School Libraries",6300,{"$f":"'1st Detail'!H108","v":0},{"$f":"'1st Detail'!K108","v":0},{"$f":"'1st Detail'!N108","v":0},{"$f":"H105-F105","v":0},{"$f":"IF(AND(F105=0,H105=0),\"\",(IF(F105=\"\",\"\",(IF(F105=0,\"New\",(IF(H105=0,\"(100%)\",((H105/F105)-1))))))))","v":""}]
[null,null,null,"Equipment ",6400,{"$f":"'1st Detail'!H109","v":0},{"$f":"'1st Detail'!K109","v":0},{"$f":"'1st Detail'!N109","v":0},{"$f":"H106-F106","v":0},{"$f":"IF(AND(F106=0,H106=0),\"\",(IF(F106=\"\",\"\",(IF(F106=0,\"New\",(IF(H106=0,\"(100%)\",((H106/F106)-1))))))))","v":""}]
[null,null,null,"Equipment Replacement",6500,{"$f":"'1st Detail'!H110","v":0},{"$f":"'1st Detail'!K110","v":0},{"$f":"'1st Detail'!N110","v":0},{"$f":"H107-F107","v":0},{"$f":"IF(AND(F107=0,H107=0),\"\",(IF(F107=\"\",\"\",(IF(F107=0,\"New\",(IF(H107=0,\"(100%)\",((H107/F107)-1))))))))","v":""}]
[null,null,null,"Depreciation Expense (for accrual basis only)",6900,{"$f":"'1st Detail'!H111","v":397233.87179487175},{"$f":"'1st Detail'!K111","v":132411.32},{"$f":"'1st Detail'!N111","v":363466.42330891336},{"$f":"H108-F108","v":-33767.44848595839},{"$f":"IF(AND(F108=0,H108=0),\"\",(IF(F108=\"\",\"\",(IF(F108=0,\"New\",(IF(H108=0,\"(100%)\",((H108/F108)-1))))))))","v":-8.5006468188079443E-2}]
[null,null," ","          Total, Capital Outlay"," ",{"$f":"SUM(F102:F103)+SUM(F105:F108)","v":397233.87179487175},{"$f":"SUM(G102:G103)+SUM(G105:G108)","v":132411.32},{"$f":"SUM(H102:H103)+SUM(H105:H108)","v":363466.42330891336},{"$f":"SUM(I102:I103)+SUM(I105:I108)","v":-33767.44848595839},{"$f":"IF(AND(F109=0,H109=0),\"\",(IF(F109=\"\",\"\",(IF(F109=0,\"New\",(IF(H109=0,\"(100%)\",((H109/F109)-1))))))))","v":-8.5006468188079443E-2}]
[null,null,null,null," "]
[null,"7.","Other Outgo ",null," "]
[null," ",null,"Tuition to Other Schools","7110-7143",{"$f":"'1st Detail'!H115","v":0},{"$f":"'1st Detail'!K115","v":0},{"$f":"'1st Detail'!N115","v":0},{"$f":"H112-F112","v":0},{"$f":"IF(AND(F112=0,H112=0),\"\",(IF(F112=\"\",\"\",(IF(F112=0,\"New\",(IF(H112=0,\"(100%)\",((H112/F112)-1))))))))","v":""}]
[null,null,null,"Transfers of Pass-through Revenues to Other LEAs","7211-7213",{"$f":"'1st Detail'!H116","v":0},{"$f":"'1st Detail'!K116","v":0},{"$f":"'1st Detail'!N116","v":0},{"$f":"H113-F113","v":0},""]
[null,null,null,"Transfers of Apportionments to Other LEAs - Spec. Ed.","7221-7223SE",{"$f":"'1st Detail'!H117","v":0},{"$f":"'1st Detail'!K117","v":0},{"$f":"'1st Detail'!N117","v":0},{"$f":"H114-F114","v":0},""]
[null,null,null,"Transfers of Apportionments to Other LEAs - All Other","7221-7223AO",{"$f":"'1st Detail'!H118","v":0},{"$f":"'1st Detail'!K118","v":0},{"$f":"'1st Detail'!N118","v":0},{"$f":"H115-F115","v":0},""]
[null,null,null,"All Other Transfers","7281-7299",{"$f":"'1st Detail'!H119","v":0},{"$f":"'1st Detail'!K119","v":0},{"$f":"'1st Detail'!N119","v":0},{"$f":"H116-F116","v":0},""]
[null,null,null,"Debt Service:"," ",null,null,null,null,""]
[null,null,null,"     Interest",7438,{"$f":"'1st Detail'!H121","v":0},{"$f":"'1st Detail'!K121","v":0},{"$f":"'1st Detail'!N121","v":0},{"$f":"H118-F118","v":0},""]
[null,null,null,"     Principal (for modified accrual basis only)",7439,{"$f":"'1st Detail'!H122","v":0},{"$f":"'1st Detail'!K122","v":0},{"$f":"'1st Detail'!N122","v":0},{"$f":"H119-F119","v":0},""]
[null,null,null,"          Total, Other Outgo"," ",{"$f":"SUM(F112:F116,F118:F119)","v":0},{"$f":"SUM(G112:G116,G118:G119)","v":0},{"$f":"SUM(H112:H116,H118:H119)","v":0},{"$f":"SUM(I112:I116,I118:I119)","v":0},""]
[null,null,null,null," "]
[null,"8.","TOTAL EXPENDITURES",null," ",{"$f":"SUM(F59,F67,F80,F88,F99,F109,F120)","v":5924489.4340671692},{"$f":"SUM(G59,G67,G80,G88,G99,G109,G120)","v":1974709.02},{"$f":"SUM(H59,H67,H80,H88,H99,H109,H120)","v":7111192.4666635133},{"$f":"SUM(I59,I67,I80,I88,I99,I109,I120)","v":1186703.0325963446},{"$f":"IF(AND(F122=0,H122=0),\"\",(IF(F122=\"\",\"\",(IF(F122=0,\"New\",(IF(H122=0,\"(100%)\",((H122/F122)-1))))))))","v":0.20030469221069591}]
[null,null,null,null," "]
["C.","EXCESS (DEFICIENCY) OF REVENUES OVER EXPEND.",null,null," "]
[null,"BEFORE OTHER FINANCING SOURCES AND USES (A5-B8)",null,null," ",{"$f":"SUM(F51-F122)","v":-550227.69661240838},{"$f":"SUM(G51-G122)","v":-1412317.85},{"$f":"SUM(H51-H122)","v":-343046.63857812807},{"$f":"SUM(I51-I122)","v":207181.05803427962},{"$f":"IF(AND(F125=0,H125=0),\"\",(IF(F125=\"\",\"\",(IF(F125=0,\"New\",(IF(H125=0,\"(100%)\",((H125/F125)-1))))))))","v":-0.37653694881198041}]
[]
["D.","OTHER FINANCING SOURCES / USES",null,null," "]
[null,"1.","Other Sources",null,"8930-8979",{"$f":"'1st Detail'!H131","v":0},{"$f":"'1st Detail'!K131","v":0},{"$f":"'1st Detail'!N131","v":0},{"$f":"H128-F128","v":0},{"$f":"IF(AND(F128=0,H128=0),\"\",(IF(F128=\"\",\"\",(IF(F128=0,\"New\",(IF(H128=0,\"(100%)\",((H128/F128)-1))))))))","v":""}]
[null,"2.","Less:  Other Uses",null,"7630-7699",{"$f":"'1st Detail'!H132","v":0},{"$f":"'1st Detail'!K132","v":0},{"$f":"'1st Detail'!N132","v":0},{"$f":"H129-F129","v":0},{"$f":"IF(AND(F129=0,H129=0),\"\",(IF(F129=\"\",\"\",(IF(F129=0,\"New\",(IF(H129=0,\"(100%)\",((H129/F129)-1))))))))","v":""}]
[null,"3.","Contributions Between Unrestricted and Restricted Accounts"]
[null,null,"(must net to zero)",null,"8980-8999",{"$f":"'1st Detail'!H134","v":0},{"$f":"'1st Detail'!K134","v":0},{"$f":"'1st Detail'!N134","v":0},{"$f":"H131-F131","v":0},{"$f":"IF(AND(F131=0,H131=0),\"\",(IF(F131=\"\",\"\",(IF(F131=0,\"New\",(IF(H131=0,\"(100%)\",((H131/F131)-1))))))))","v":""}]
[null," ",null,null," "]
[null,"4.","TOTAL OTHER FINANCING SOURCES / USES",null," ",{"$f":"SUM(+F128-F129+F131)","v":0},{"$f":"SUM(+G128-G129+G131)","v":0},{"$f":"SUM(+H128-H129+H131)","v":0},{"$f":"SUM(+I128-I129+I131)","v":0},{"$f":"IF(AND(F133=0,H133=0),\"\",(IF(F133=\"\",\"\",(IF(F133=0,\"New\",(IF(H133=0,\"(100%)\",((H133/F133)-1))))))))","v":""}]
[null,null,null,null," "]
["E.","NET INCREASE (DECREASE) IN FUND BALANCE (C + D4) ",null,null," ",{"$f":"SUM(F125,F133)","v":-550227.69661240838},{"$f":"SUM(G125,G133)","v":-1412317.85},{"$f":"SUM(H125,H133)","v":-343046.63857812807},{"$f":"SUM(I125,I133)","v":207181.05803427962},{"$f":"IF(AND(F135=0,H135=0),\"\",(IF(F135=\"\",\"\",(IF(F135=0,\"New\",(IF(H135=0,\"(100%)\",((H135/F135)-1))))))))","v":-0.37653694881198041}]
[null," ",null,null," "]
["F.","FUND BALANCE, RESERVES",null,null," "]
[null,"1.","Beginning Fund Balance"]
[null,null,"a.","As of July 1",9791,{"$f":"'1st Detail'!H142","v":8212886.5307075521},{"$f":"'1st Detail'!K142","v":8291101.3799999999},{"$f":"'1st Detail'!N142","v":8291101.3799999999},{"$f":"H139-F139","v":78214.849292447791},{"$f":"IF(AND(F139=0,H139=0),\"\",(IF(F139=\"\",\"\",(IF(F139=0,\"New\",(IF(H139=0,\"(100%)\",((H139/F139)-1))))))))","v":9.5234299171194081E-3}]
[" ",null,"b.","Adjustments to Beginning Balance","9793, 9795",{"$f":"'1st Detail'!H143","v":0},{"$f":"'1st Detail'!K143","v":7819.6199999991804},{"$f":"'1st Detail'!N143","v":7819.6199999991804},{"$f":"H140-F140","v":7819.6199999991804},{"$f":"IF(AND(F140=0,H140=0),\"\",(IF(F140=\"\",\"\",(IF(F140=0,\"New\",(IF(H140=0,\"(100%)\",((H140/F140)-1))))))))","v":"New"}]
[null,null,"c.","Adjusted Beginning Balance"," ",{"$f":"SUM(F139:F140)","v":8212886.5307075521},{"$f":"SUM(G139:G140)","v":8298920.9999999991},{"$f":"SUM(H139:H140)","v":8298920.9999999991}]
[null,"2.","Ending Fund Balance, June 30 (E + F.1.c.)",null," ",{"$f":"SUM(F135,F141)","v":7662658.8340951437},{"$f":"SUM(G135,G141)","v":6886603.1499999985},{"$f":"SUM(H135,H141)","v":7955874.361421871}]
[null,null,null,null," "]
[null,null,"Components of Ending Fund Balance :",null," "]
[null,null,"a. ","Nonspendable",null,null,null,null,null,{"$f":"IF(AND(F145=0,H145=0),\"\",(IF(F145=\"\",\"\",(IF(F145=0,\"New\",(IF(H145=0,\"(100%)\",((H145/F145)-1))))))))","v":""}]
[null,null,null,"Revolving Cash (equals object 9130)",9711,{"$f":"'1st Detail'!H149","v":0},{"$f":"'1st Detail'!K149","v":0},{"$f":"'1st Detail'!N149","v":0},{"$f":"H146-F146","v":0},{"$f":"IF(AND(F146=0,H146=0),\"\",(IF(F146=\"\",\"\",(IF(F146=0,\"New\",(IF(H146=0,\"(100%)\",((H146/F146)-1))))))))","v":""}]
[null,null,null,"Stores (equals object 9320)",9712,{"$f":"'1st Detail'!H150","v":0},{"$f":"'1st Detail'!K150","v":0},{"$f":"'1st Detail'!N150","v":0},{"$f":"H147-F147","v":0},""]
[null,null,null,"Prepaid Expenditures (equals object 9330)",9713,{"$f":"'1st Detail'!H151","v":0},{"$f":"'1st Detail'!K151","v":0},{"$f":"'1st Detail'!N151","v":0},{"$f":"H148-F148","v":0},""]
[null,null,null,"All Others",9719,{"$f":"'1st Detail'!H152","v":0},{"$f":"'1st Detail'!K152","v":0},{"$f":"'1st Detail'!N152","v":0},{"$f":"H149-F149","v":0},""]
[null,null,"b.","Restricted",9740,{"$f":"'1st Detail'!H153","v":6307826.8600000003},{"$f":"'1st Detail'!K153","v":6817341.0200000005},{"$f":"'1st Detail'!N153","v":7051314.9277471248},{"$f":"H150-F150","v":743488.06774712447},0.11786754523365661]
[null,null,"c","Committed"]
[null,null,null,"Stabilization Arrangements",9750,{"$f":"'1st Detail'!H155","v":0},{"$f":"'1st Detail'!K155","v":0},{"$f":"'1st Detail'!N155","v":0},{"$f":"H152-F152","v":0},{"$f":"IF(AND(F152=0,H152=0),\"\",(IF(F152=\"\",\"\",(IF(F152=0,\"New\",(IF(H152=0,\"(100%)\",((H152/F152)-1))))))))","v":""}]
[null,null,null,"Other Commitments",9760,{"$f":"'1st Detail'!H156","v":0},{"$f":"'1st Detail'!K156","v":0},{"$f":"'1st Detail'!N156","v":0},0,""]
[null,null,"d","Assigned",null,null,null,null,null,""]
[null,null,null,"Other Assignments",9780,{"$f":"'1st Detail'!H158","v":0},{"$f":"'1st Detail'!K158","v":0},{"$f":"'1st Detail'!N158","v":0},0,""]
[null,null,"e.","Unassigned/Unappropriated",null,null,null,null,null,""]
[null,null,null,"Reserve for Economic Uncertainties",9789,{"$f":"'1st Detail'!H160","v":0},{"$f":"'1st Detail'!K160","v":0},{"$f":"'1st Detail'!N160","v":0},0,""]
[null,null,null,"Unassigned/Unappropriated Amount",9790,{"$f":"'1st Detail'!H161","v":1354831.9740951434},{"$f":"'1st Detail'!K161","v":69262.130000000121},{"$f":"'1st Detail'!N161","v":903684.43490189151},-451147.53919325187,-0.33299150582459602]

{"sheet":"1st MYP","index":3,"n_rows":165,"n_cols":16,"rows_kept":165,"cut":false,"hidden":false,"merged":[[131,5,131,7],[11,0,11,3],[18,5,18,7],[71,5,71,7],[11,4,11,5],[9,0,9,3],[10,0,10,3],[9,4,9,5],[10,4,10,5],[8,0,8,3],[8,4,8,5],[7,0,7,3],[6,4,6,5],[7,4,7,5],[0,0,0,9],[1,0,1,9],[5,0,5,3],[2,0,2,9],[5,4,5,5]]}
["CHARTER SCHOOL "]
["MULTI-YEAR PROJECTION - ALTERNATIVE FORM"]
["First Interim Report - MYP"]
[]
[]
["Charter School Name:",null,null,null,{"$f":"IF('1st Detail'!G6=\"\",\"\",'1st Detail'!G6)","v":"Magnolia Science Academy"}]
[null,null,null,"(continued)",{"$f":"IF('1st Detail'!G7=\"\",\"\",'1st Detail'!G7)","v":"Santa Ana"}]
["CDS #:",null,null,null,{"$f":"IF('1st Detail'!G8=\"\",\"\",'1st Detail'!G8)","v":"30-76893-0130765"}]
["Charter Approving Entity:",null,null,null,{"$f":"IF('1st Detail'!G9=\"\",\"\",'1st Detail'!G9)","v":"State Board of Education"}]
["County:",null,null,null,{"$f":"IF('1st Detail'!G10=\"\",\"\",'1st Detail'!G10)","v":"Orange"}]
["Charter #:",null,null,null,{"$f":"IF('1st Detail'!G11=\"\",\"\",'1st Detail'!G11)","v":"1686"}]
["Fiscal Year:",null,null,null,{"$f":"IF('1st Detail'!G12=\"\",\"\",'1st Detail'!G12)","v":"2016/17"}]
[]
["This charter school uses the following basis of accounting:"]
[null,"X","   Accrual Basis (Applicable Capital Assets / Interest on Long-Term Debt / Long-Term Liabilities objects are 6900, 7438, 9400-9499, and 9660-9669)"]
[]
[null,null,"   Modified Accrual Basis (Applicable Capital Outlay / Debt Service objects are 6100-6170, 6200-6500, 7438, and 7439)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Look-up Table - Do Not Delete"]
[null,null,null,null,null,{"$f":"CONCATENATE(\"FY \",E12)","v":"FY 2016/17"},null,null,"Totals for","Totals for",null,null,null,"2016/17","2017/18","2018/19"]
[null,null,null,"              Description","Object Code","Unrestricted","Restricted","Total",{"$f":"IF(E12=\"\",\"\",((VLOOKUP(E12,Fiscal_Year,2,FALSE))))","v":"2017/18"},{"$f":"IF(E12=\"\",\"\",((VLOOKUP(E12,Fiscal_Year,3,FALSE))))","v":"2018/19"},null,null,null,"2017/18","2018/19","2019/20"]
["A.","REVENUES",null,null," ",null,null,null,null,null,null,null,null,"2018/19","2019/20","2020/21"]
[null,"1.","LCFF/Revenue Limit Sources",null," ",null,null,null,null,null,null,null,null,"2019/20","2020/21","2021/22"]
[null,null,null,"State Aid - Current Year",8011,{"$f":"'1st Detail'!L23","v":4208989.2838000013},{"$f":"'1st Detail'!M23","v":0},{"$f":"F23+G23","v":4208989.2838000013},6174653.5018499997,6631547.3372999988,null,null,null,"2020/21","2021/22","2022/23"]
[null,null,null,"Education Protection Account State Aid - Current Year",8012,{"$f":"'1st Detail'!L24","v":121204},{"$f":"'1st Detail'!M24","v":0},{"$f":"F24+G24","v":121204},156523,161734,null,null,null,"2021/22","2022/23","2023/24"]
[null,null,null,"Charter Schools Gen. Purpose Entitlement - State Aid",8015,{"$f":"'1st Detail'!L25","v":0},{"$f":"'1st Detail'!M25","v":0},{"$f":"F25+G25","v":0},null,null,null,null,null,"2022/23","2023/24","2024/25"]
[null,null,null,"State Aid - Prior Years",8019,{"$f":"'1st Detail'!L26","v":0},{"$f":"'1st Detail'!M26","v":0},{"$f":"F26+G26","v":0},0,0,null,null,null,"2023/24","2024/25","2025/26"]
[null,null,null,"Tax Relief Subventions ","8020-8039",{"$f":"'1st Detail'!L27","v":0},{"$f":"'1st Detail'!M27","v":0},0,null,null,null,null,null,"2024/25","2025/26","2026/27"]
[null,null,null,"County and District Taxes ","8040-8079",{"$f":"'1st Detail'!L28","v":0},{"$f":"'1st Detail'!M28","v":0},0,null,null,null,null,null,"2025/26","2026/27","2027/28"]
[null,null,null,"Miscellaneous Funds","8080-8089",{"$f":"'1st Detail'!L29","v":0},{"$f":"'1st Detail'!M29","v":0},0,null,null,null,null,null,"2026/27","2027/28","2028/29"]
[null,null,null,"LCFF/Revenue Limit Transfers:"]
[null,null,null,"    PERS Reduction Transfer",8092,{"$f":"'1st Detail'!L31","v":0},{"$f":"'1st Detail'!M31","v":0},{"$f":"F31+G31","v":0}]
[null,null,null,"    Charter Schools Funding in lieu of Property Taxes",8096,{"$f":"'1st Detail'!L32","v":1147080.7161999999},{"$f":"'1st Detail'!M32","v":0},{"$f":"F32+G32","v":1147080.7161999999},1481341.4981499999,1530658.6627]
[null,null,null,"    Other LCFF/Revenue Limit Transfers","8091, 8097",{"$f":"'1st Detail'!L33","v":0},{"$f":"'1st Detail'!M33","v":0},{"$f":"F33+G33","v":0}]
[null,null,null,"          Total, LCFF/Revenue Limit Sources"," ",{"$f":"SUM((F23:F29),(F31:F33))","v":5477274.0000000009},{"$f":"SUM((G23:G29),(G31:G33))","v":0},{"$f":"F34+G34","v":5477274.0000000009},{"$f":"SUM((I23:I29),(I31:I33))","v":7812518},{"$f":"SUM((J23:J29),(J31:J33))","v":8323939.9999999991}]
[null,null,null,null," "]
[null,"2.","Federal Revenues ",null," "]
[null,null,null,"No Child Left Behind ",8290,{"$f":"'1st Detail'!L37","v":0},{"$f":"'1st Detail'!M37","v":136851.29},{"$f":"F37+G37","v":136851.29},182716.82518796992,191166.19924812031]
[null,null,null,"Special Education - Federal","8181, 8182",{"$f":"'1st Detail'!L38","v":0},{"$f":"'1st Detail'!M38","v":18000},18000,78500,101375]
[null,null,null,"Child Nutrition - Federal",8220,{"$f":"'1st Detail'!L39","v":0},{"$f":"'1st Detail'!M39","v":227287.0998892308},227287.0998892308,293507.96545846155,303334.28744615382]
[null,null,null,"Donated Food Commodities",8221,{"$f":"'1st Detail'!L40","v":0},{"$f":"'1st Detail'!M40","v":0},0]
[null,null,null,"Other Federal Revenues","8110, 8260-8299",{"$f":"'1st Detail'!L41","v":54562},{"$f":"'1st Detail'!M41","v":261354.76},315916.76,56198.86,57884.825799999999]
[null,null,null,"          Total, Federal Revenues "," ",{"$f":"SUM(F37:F41)","v":54562},{"$f":"SUM(G37:G41)","v":643493.14988923084},698055.14988923084,{"$f":"SUM(I37:I41)","v":610923.65064643149},{"$f":"SUM(J37:J41)","v":653760.31249427411}]
[null,null,null,null," "]
[null,"3.","Other State Revenues",null," "]
[null,null,null,"Charter Schools Categorical Block Grant ","N/A thru 14/15"]
[null,null,null,"Special Education - State","StateRevSE",{"$f":"'1st Detail'!L46","v":0},{"$f":"'1st Detail'!M46","v":304828.06},{"$f":"F46+G46","v":304828.06},345049.99040464003,456381.46869401698]
[null,null,null,"All Other State Revenues","StateRevAO",{"$f":"'1st Detail'!L47","v":147808.49320720357},{"$f":"'1st Detail'!M47","v":100945.02198895026},{"$f":"F47+G47","v":248753.51519615384},195776.40632829006,207130.17312949797]
[null,null,null,"         Total, Other State Revenues"," ",{"$f":"SUM(F45:F47)","v":147808.49320720357},{"$f":"SUM(G45:G47)","v":405773.08198895026},{"$f":"F48+G48","v":553581.57519615383},{"$f":"SUM(I45:I47)","v":540826.39673293009},{"$f":"SUM(J45:J47)","v":663511.64182351495}]
[null,null,null,null," "]
[null,"4.","Other Local Revenues",null," "]
[null,null,null,"All Other Local Revenues","LocalRevAO",{"$f":"'1st Detail'!L51","v":39235.103000000003},{"$f":"'1st Detail'!M51","v":0},{"$f":"F51+G51","v":39235.103000000003},44035.156090000004,44756.210772699997]
[null,null,null,"          Total, Local Revenues"," ",{"$f":"SUM(F51:F51)","v":39235.103000000003},{"$f":"SUM(G51:G51)","v":0},{"$f":"F52+G52","v":39235.103000000003},{"$f":"SUM(I51:I51)","v":44035.156090000004},{"$f":"SUM(J51:J51)","v":44756.210772699997}]
[null,null," "," "," "]
[null,"5.","TOTAL REVENUES",null," ",{"$f":"SUM(F34,F42,F48,F52)","v":5718879.5962072043},{"$f":"SUM(G34,G42,G48,G52)","v":1049266.231878181},{"$f":"F54+G54","v":6768145.8280853853},{"$f":"SUM(I34,I42,I48,I52)","v":9008303.2034693621},{"$f":"SUM(J34,J42,J48,J52)","v":9685968.1650904883}]
[null,null,null,null," "]
["B.","EXPENDITURES",null,null," "]
[null,"1.","Certificated Salaries",null," "]
[null,null,null,"Certificated Teachers' Salaries",1100,{"$f":"'1st Detail'!L58","v":1781679.3255197015},{"$f":"'1st Detail'!M58","v":263977.43448029866},{"$f":"F58+G58","v":2045656.7600000002},2378091.8099999996,2624483.0643000007]
[null,null,null,"Certificated Pupil Support Salaries",1200,{"$f":"'1st Detail'!L59","v":0},{"$f":"'1st Detail'!M59","v":0},{"$f":"F59+G59","v":0},0,0]
[null,null,null,"Certificated Supervisors' and Administrators' Salaries",1300,{"$f":"'1st Detail'!L60","v":360063.15638138348},{"$f":"'1st Detail'!M60","v":135605.92361861648},{"$f":"F60+G60","v":495669.07999999996},586114.53720000002,704483.47331600008]
[null,null,null,"Other Certificated Salaries",1900,{"$f":"'1st Detail'!L61","v":0},{"$f":"'1st Detail'!M61","v":0},{"$f":"F61+G61","v":0},0,0]
[null,null,null,"          Total, Certificated Salaries"," ",{"$f":"SUM(F58:F61)","v":2141742.481901085},{"$f":"SUM(G58:G61)","v":399583.35809891514},{"$f":"F62+G62","v":2541325.8400000003},{"$f":"SUM(I58:I61)","v":2964206.3471999997},{"$f":"SUM(J58:J61)","v":3328966.5376160005}]
[null,null,null,null," "]
[null,"2.","Non-certificated Salaries",null," "]
[null,null,null,"Non-certificated Instructional Aides' Salaries",2100,{"$f":"'1st Detail'!L65","v":0},{"$f":"'1st Detail'!M65","v":0},{"$f":"F65+G65","v":0},0,0]
[null,null,null,"Non-certificated Support Salaries",2200,{"$f":"'1st Detail'!L66","v":0},{"$f":"'1st Detail'!M66","v":0},0,0,0]
[null,null,null,"Non-certificated Supervisors' and Administrators' Sal.",2300,{"$f":"'1st Detail'!L67","v":0},{"$f":"'1st Detail'!M67","v":0},0,0,0]
[null,null,null,"Clerical and Office Salaries",2400,{"$f":"'1st Detail'!L68","v":380571.07},{"$f":"'1st Detail'!M68","v":92760},473331.07,620092.20809999993,734175.97434300021]
[null,null,null,"Other Non-certificated Salaries",2900,{"$f":"'1st Detail'!L69","v":0},{"$f":"'1st Detail'!M69","v":0},0,0,0]
[null,null,null,"          Total, Non-certificated Salaries"," ",{"$f":"SUM(F65:F69)","v":380571.07},{"$f":"SUM(G65:G69)","v":92760},473331.07,{"$f":"SUM(I65:I69)","v":620092.20809999993},{"$f":"SUM(J65:J69)","v":734175.97434300021}]
[]
[null,null,null,null,null,{"$f":"F19","v":"FY 2016/17"},null,null,"Totals for","Totals for",null,null,null,"2006/07","2007/08","2008/09"]
[null,null,null,"              Description","Object Code","Unrestricted","Restricted","Total",{"$f":"I20","v":"2017/18"},{"$f":"J20","v":"2018/19"},null,null,null,"2007/08","2008/09","2009/10"]
[null,"3.","Employee Benefits",null," "]
[null,null,null,"STRS","3101-3102",{"$f":"'1st Detail'!L73","v":252025.77674616818},{"$f":"'1st Detail'!M73","v":49194.207895831816},{"$f":"F75+G75","v":301219.984642},405341.3536192801,515933.21484168636]
[null,null,null,"PERS","3201-3202",{"$f":"'1st Detail'!L74","v":9413.4273616250703},{"$f":"'1st Detail'!M74","v":1837.4553135749279},11250.882675199999,12933.492361000001,31023.870416406007]
[null,null,null,"OASDI / Medicare / Alternative","3301-3302",{"$f":"'1st Detail'!L75","v":69209.830394191726},{"$f":"'1st Detail'!M75","v":13509.42284080826},82719.253234999982,100585.69932525,114911.77980500749]
[null,null,null,"Health and Welfare Benefits","3401-3402",{"$f":"'1st Detail'!L76","v":286561.80662924988},{"$f":"'1st Detail'!M76","v":55935.473237416802},342497.27986666671,394956,473260.31999999989]
[null,null,null,"Unemployment Insurance","3501-3502",{"$f":"'1st Detail'!L77","v":3771.2071337881957},{"$f":"'1st Detail'!M77","v":736.12132121180412},4507.3284549999998,1792.1492776500004,2031.5712559795002]
[null,null,null,"Workers' Compensation Insurance","3601-3602",{"$f":"'1st Detail'!L78","v":28401.250594406207},{"$f":"'1st Detail'!M78","v":5543.7862121937842},33945.036806599994,40359.20173267799,45750.984684658353]
[null,null,null,"OPEB, Allocated","3701-3702",{"$f":"'1st Detail'!L79","v":0},{"$f":"'1st Detail'!M79","v":0},0,0,0]
[null,null,null,"OPEB, Active Employees","3751-3752",{"$f":"'1st Detail'!L80","v":0},{"$f":"'1st Detail'!M80","v":0},0]
[null,null,null,"PERS Reduction (for revenue limit funded schools)","3801-3802",{"$f":"'1st Detail'!L81","v":0},{"$f":"'1st Detail'!M81","v":0},0,0,0]
[null,null,null,"Other Employee Benefits","3901-3902",{"$f":"'1st Detail'!L82","v":0},{"$f":"'1st Detail'!M82","v":0},0,0,0]
[null,null,null,"          Total, Employee Benefits"," ",{"$f":"SUM(F75:F84)","v":649383.29885942908},{"$f":"SUM(G75:G84)","v":126756.46682103738},776139.76568046643,{"$f":"SUM(I75:I84)","v":955967.89631585812},{"$f":"SUM(J75:J84)","v":1182911.7410037378}]
[null,null,null,null," "]
[null,"4.","Books and Supplies",null," "]
[null,null,null,"Approved Textbooks and Core Curricula Materials",4100,{"$f":"'1st Detail'!L86","v":31614.760000000009},{"$f":"'1st Detail'!M86","v":208385.24},{"$f":"F88+G88","v":240000},240000,240000]
[null,null,null,"Books and Other Reference Materials",4200,{"$f":"'1st Detail'!L87","v":20000},{"$f":"'1st Detail'!M87","v":0},20000,53886.792452830181,55503.39622641509]
[null,null,null,"Materials and Supplies",4300,{"$f":"'1st Detail'!L88","v":110221.27801104973},{"$f":"'1st Detail'!M88","v":25970.451988950277},136191.73000000001,145112.57441892967,153552.45165149757]
[null,null,null,"Noncapitalized Equipment",4400,{"$f":"'1st Detail'!L89","v":141798.72999999998},{"$f":"'1st Detail'!M89","v":52944.09},194742.81999999998,70000,64300]
[null,null,null,"Food",4700,{"$f":"'1st Detail'!L90","v":5000},{"$f":"'1st Detail'!M90","v":270190.77722215391},275190.77722215391,370453.19949138467,382100.32261846151]
[null,null,null,"          Total, Books and Supplies"," ",{"$f":"SUM(F88:F92)","v":308634.76801104972},{"$f":"SUM(G88:G92)","v":557490.55921110418},866125.32722215389,{"$f":"SUM(I88:I92)","v":879452.56636314455},{"$f":"SUM(J88:J92)","v":895456.17049637414}]
[null,null,null,null," "]
[null,"5.","Services and Other Operating Expenditures",null," "]
[null,null,null,"Subagreements for Services",5100,{"$f":"'1st Detail'!L94","v":1088790.4515428888},{"$f":"'1st Detail'!M94","v":0},{"$f":"F96+G96","v":1088790.4515428888},936441.9477870625,939884.74182067439]
[null,null,null,"Travel and Conferences",5200,{"$f":"'1st Detail'!L95","v":18809.090909090912},{"$f":"'1st Detail'!M95","v":0},{"$f":"F97+G97","v":18809.090909090912},19373.36363636364,19954.564545454545]
[null,null,null,"Dues and Memberships",5300,{"$f":"'1st Detail'!L96","v":6000},{"$f":"'1st Detail'!M96","v":0},6000,6180,6365.4000000000005]
[null,null,null,"Insurance","5400",{"$f":"'1st Detail'!L97","v":21456},{"$f":"'1st Detail'!M97","v":0},21456,44892.929942068971,46239.717840331039]
[null,null,null,"Operations and Housekeeping Services",5500,{"$f":"'1st Detail'!L98","v":169772.38},{"$f":"'1st Detail'!M98","v":0},169772.38,166455.5514,171449.21794200002]
[null,null,null,"Rentals, Leases, Repairs, and Noncap. Improvements",5600,{"$f":"'1st Detail'!L99","v":88839.43},{"$f":"'1st Detail'!M99","v":0},88839.43,97344,100264.32000000001]
[null,null,null,"Professional/Consulting Services and Operating Expend.",5800,{"$f":"'1st Detail'!L100","v":651975.70240000007},{"$f":"'1st Detail'!M100","v":20362.29},672337.9924000001,1149459.3402881855,1159663.0830207069]
[null,null,null,"Communications",5900,{"$f":"'1st Detail'!L101","v":24798.695599999999},{"$f":"'1st Detail'!M101","v":0},24798.695599999999,17500,18025]
[null,null,null,"          Total, Services and Other Operating Expenditures"," ",{"$f":"SUM(F96:F103)","v":2070441.7504519795},{"$f":"SUM(G96:G103)","v":20362.29},2090804.0404519795,{"$f":"SUM(I96:I103)","v":2437647.1330536809},{"$f":"SUM(J96:J103)","v":2461846.0451691672}]
[null,null," ",null," "]
[null,"6.","Capital Outlay (Obj. 6100-6170, 6200-6500 for mod. accr. basis only)",null," "]
[null,null,null,"Land and Land Improvements","6100-6170",{"$f":"'1st Detail'!L105","v":0},{"$f":"'1st Detail'!M105","v":0},{"$f":"F107+G107","v":0}]
[null,null,null,"Buildings and Improvements of Buildings",6200,{"$f":"'1st Detail'!L106","v":0},{"$f":"'1st Detail'!M106","v":0},{"$f":"F108+G108","v":0}]
[null,null,null,"Books and Media for New School Libraries or Major"," "]
[null,null,null,"     Expansion of School Libraries",6300,{"$f":"'1st Detail'!L108","v":0},{"$f":"'1st Detail'!M108","v":0},{"$f":"F110+G110","v":0}]
[null,null,null,"Equipment ",6400,{"$f":"'1st Detail'!L109","v":0},{"$f":"'1st Detail'!M109","v":0},{"$f":"F111+G111","v":0}]
[null,null,null,"Equipment Replacement",6500,{"$f":"'1st Detail'!L110","v":0},{"$f":"'1st Detail'!M110","v":0},{"$f":"F112+G112","v":0}]
[null,null,null,"Depreciation Expense (for accrual basis only)",6900,{"$f":"'1st Detail'!L111","v":363466.42330891336},{"$f":"'1st Detail'!M111","v":0},{"$f":"F113+G113","v":363466.42330891336},538821.83917358576,516859.134401099]
[null,null," ","          Total, Capital Outlay"," ",{"$f":"SUM(F107:F108)+SUM(F110:F113)","v":363466.42330891336},{"$f":"SUM(G107:G108)+SUM(G110:G113)","v":0},{"$f":"F114+G114","v":363466.42330891336},{"$f":"SUM(I107:I108)+SUM(I110:I113)","v":538821.83917358576},{"$f":"SUM(J107:J108)+SUM(J110:J113)","v":516859.134401099}]
[null,null,null,null," "]
[null,"7.","Other Outgo ",null," "]
[null," ",null,"Tuition to Other Schools","7110-7143",{"$f":"'1st Detail'!L115","v":0},{"$f":"'1st Detail'!M115","v":0},{"$f":"F117+G117","v":0}]
[null,null,null,"Transfers of Pass-through Revenues to Other LEAs","7211-7213",{"$f":"'1st Detail'!L116","v":0},{"$f":"'1st Detail'!M116","v":0},0]
[null,null,null,"Transfers of Apportionments to Other LEAs - Spec. Ed.","7221-7223SE",{"$f":"'1st Detail'!L117","v":0},{"$f":"'1st Detail'!M117","v":0},0]
[null,null,null,"Transfers of Apportionments to Other LEAs - All Other","7221-7223AO",{"$f":"'1st Detail'!L118","v":0},{"$f":"'1st Detail'!M118","v":0},0]
[null,null,null,"All Other Transfers","7280-7299",{"$f":"'1st Detail'!L119","v":0},{"$f":"'1st Detail'!M119","v":0},0]
[null,null,null,"Debt Service:"," "]
[null,null,null,"     Interest",7438,{"$f":"'1st Detail'!L121","v":0},{"$f":"'1st Detail'!M121","v":0},0]
[null,null,null,"     Principal (for modified accrual basis only)",7439,{"$f":"'1st Detail'!L122","v":0},{"$f":"'1st Detail'!M122","v":0},0]
[null,null,null,"          Total, Other Outgo"," ",{"$f":"SUM(F117:F121,F123:F124)","v":0},{"$f":"SUM(G117:G121,G123:G124)","v":0},0,{"$f":"SUM(I117:I121,I123:I124)","v":0},{"$f":"SUM(J117:J121,J123:J124)","v":0}]
[null,null,null,null," "]
[null,"8.","TOTAL EXPENDITURES",null," ",{"$f":"SUM(F62,F70,F85,F93,F104,F114,F125)","v":5914239.792532457},{"$f":"SUM(G62,G70,G85,G93,G104,G114,G125)","v":1196952.6741310568},7111192.4666635133,{"$f":"SUM(I62,I70,I85,I93,I104,I114,I125)","v":8396187.9902062695},{"$f":"SUM(J62,J70,J85,J93,J104,J114,J125)","v":9120215.6030293796}]
[null,null,null,null," "]
["C.","EXCESS (DEFICIENCY) OF REVENUES OVER EXPEND.",null,null," "]
[null,"BEFORE OTHER FINANCING SOURCES AND USES (A5-B8)",null,null," ",{"$f":"SUM(F54-F127)","v":-195360.19632525276},{"$f":"SUM(G54-G127)","v":-147686.44225287577},{"$f":"F130+G130","v":-343046.63857812854},{"$f":"SUM(I54-I127)","v":612115.21326309256},{"$f":"SUM(J54-J127)","v":565752.56206110865}]
[]
[null,null,null,null,null,{"$f":"F19","v":"FY 2016/17"},null,null,"Totals for","Totals for",null,null,null,"2006/07","2007/08","2008/09"]
[null,null,null,"              Description","Object Code","Unrestricted","Restricted","Total",{"$f":"I20","v":"2017/18"},{"$f":"J20","v":"2018/19"},null,null,null,"2007/08","2008/09","2009/10"]
["D.","OTHER FINANCING SOURCES / USES",null,null," "]
[null,"1.","Other Sources",null,"8930-8979",{"$f":"'1st Detail'!L131","v":0},{"$f":"'1st Detail'!M131","v":0},{"$f":"F135+G135","v":0}]
[null,"2.","Less:  Other Uses",null,"7630-7699",{"$f":"'1st Detail'!L132","v":0},{"$f":"'1st Detail'!M132","v":0},{"$f":"F136+G136","v":0}]
[null,"3.","Contributions Between Unrestricted and Restricted Accounts"]
[null,null,"(must net to zero)",null,"8980-8999",{"$f":"'1st Detail'!L134","v":0},{"$f":"'1st Detail'!M134","v":0},{"$f":"F138+G138","v":0}]
[null," ",null,null," "]
[null,"4.","TOTAL OTHER FINANCING SOURCES / USES",null," ",{"$f":"SUM(+F135-F136+F138)","v":0},{"$f":"SUM(+G135-G136+G138)","v":0},{"$f":"F140+G140","v":0},{"$f":"SUM(+I135-I136+I138)","v":0},{"$f":"SUM(+J135-J136+J138)","v":0}]
[null,null,null,null," "]
["E.","NET INCREASE (DECREASE) IN FUND BALANCE (C + D4) ",null,null," ",{"$f":"SUM(F130,F140)","v":-195360.19632525276},{"$f":"SUM(G130,G140)","v":-147686.44225287577},{"$f":"F142+G142","v":-343046.63857812854},{"$f":"SUM(I130,I140)","v":612115.21326309256},{"$f":"SUM(J130,J140)","v":565752.56206110865}]
[null," ",null,null," "]
["F.","FUND BALANCE, RESERVES",null,null," "]
[null,"1.","Beginning Fund Balance"]
[null,null,"a.","As of July 1",9791,{"$f":"'1st Detail'!L142","v":1092100.01},{"$f":"'1st Detail'!M142","v":7199001.3700000001},{"$f":"F146+G146","v":8291101.3799999999},{"$f":"H149","v":7955874.3614218701},{"$f":"I149","v":8567989.5746849626}]
[" ",null,"b.","Adjustments to Beginning Balance","9793, 9795",{"$f":"'1st Detail'!L143","v":1363833.9899999993},{"$f":"'1st Detail'!M143","v":-1356014.37},{"$f":"F147+G147","v":7819.6199999991804}]
[null,null,"c.","Adjusted Beginning Balance"," ",{"$f":"SUM(F146:F147)","v":2455933.9999999991},{"$f":"SUM(G146:G147)","v":5842987},{"$f":"F148+G148","v":8298920.9999999991},{"$f":"SUM(I146:I147)","v":7955874.3614218701},{"$f":"SUM(J146:J147)","v":8567989.5746849626}]
[null,"2.","Ending Fund Balance, June 30 (E + F.1.c.)",null," ",{"$f":"SUM(F142,F148)","v":2260573.8036747463},{"$f":"SUM(G142,G148)","v":5695300.5577471238},{"$f":"F149+G149","v":7955874.3614218701},{"$f":"SUM(I142,I148)","v":8567989.5746849626},{"$f":"SUM(J142,J148)","v":9133742.1367460713}]
[]
[null,null,"Components of Ending Fund Balance:",null," "]
[null,null,"a. ","Nonspendable"]
[null,null,null,"Revolving Cash (equals object 9130) ",9711,{"$f":"'1st Detail'!L149","v":0},{"$f":"'1st Detail'!M149","v":0},{"$f":"F153+G153","v":0}]
[null,null,null,"Stores (equals object 9320)",9712,{"$f":"'1st Detail'!L150","v":0},{"$f":"'1st Detail'!M150","v":0},{"$f":"F154+G154","v":0}]
[null,null,null,"Prepaid Expenditures (equals object 9330)",9713,{"$f":"'1st Detail'!L151","v":0},{"$f":"'1st Detail'!M151","v":0},{"$f":"F155+G155","v":0}]
[null,null,null,"All Others",9719,{"$f":"'1st Detail'!L152","v":0},{"$f":"'1st Detail'!M152","v":0},{"$f":"F156+G156","v":0}]
[null,null,"b. Restricted",null,9740,{"$f":"'1st Detail'!L153","v":0},{"$f":"'1st Detail'!M153","v":7051314.9277471248},{"$f":"F157+G157","v":7051314.9277471248}]
[null,null,"c.","Committed"]
[null,null,null,"Stabilization Arrangements",9750,{"$f":"'1st Detail'!L155","v":0},{"$f":"'1st Detail'!M155","v":0},{"$f":"F159+G159","v":0}]
[null,null,null,"Other Commitments",9760,{"$f":"'1st Detail'!L155","v":0},{"$f":"'1st Detail'!M156","v":0},{"$f":"F160+G160","v":0}]
[null,null,"d","Assigned"]
[null,null,null,"Other Assignments",9780,{"$f":"'1st Detail'!L158","v":0},{"$f":"'1st Detail'!M158","v":0},{"$f":"F162+G162","v":0}]
[null,null,"e. ","Unassigned/Unappropriated"]
[null,null,null,"Reserve for Economic Uncertainties",9789,{"$f":"'1st Detail'!L160","v":0},{"$f":"'1st Detail'!M160","v":0},{"$f":"F164+G164","v":0}]
[null,null,null,"Unassigned/Unappropriated Amount",9790,{"$f":"'1st Detail'!L161","v":903684.43490189151},{"$f":"'1st Detail'!M161","v":0},{"$f":"F165+G165","v":903684.43490189151},8567114.5759121086,9132867.1379732173]

{"sheet":"Sheet1","index":4,"n_rows":146,"n_cols":14,"rows_kept":146,"cut":false,"hidden":true,"merged":[]}
["Name","EdTec Description","Restricted for State Reporting Purposes?"]
["Name","EdTec Description","No"]
["- No Resource-Year -","No Resource Code","No"]
["0000-0","No Resource Code","No"]
["0000-7","No resource; FY0607","No"]
["0001-0","Gala {LCCS}","No"]
["3010-0","NCLB-Title I, Part A, Basic Grants Low Income and Neglected","Yes"]
["3011-0","NCLB: ARRA Title I, Part A, Basic Grants Low Income and Neglected [8299]","Yes"]
["3030-0","NCLB-Title I Part B, Reading First Program","Yes"]
["3171-0","NCLB: Title I Program Improvement & School Choice","Yes"]
["3200-0","ARRA: State Fiscal Stabilization Fund (Backfill) [8299]","Yes"]
["3205-0","ARRA: Education Jobs and Medicaid Assistance Act Funds","Yes"]
["3310-0","Special Ed: IDEA Basic Local Assistance Entitlement, Part B, Sec 611 (formerly PL 94-142)","Yes"]
["3313-0","Special Ed: ARRA IDEA Part B, Sec 611, Basic Local Assistance","Yes"]
["3710-0","NCLB: Title IV, Part A, Drug Free Schools","Yes"]
["4035-0","NCLB: Title II, Part A, Teacher Quality","Yes"]
["4036-0","NCLB: Title II, Part A, Principal Training","Yes"]
["4045-0","NCLB: Title II, Part D, Enhancing Education Through Technology, Formula Grants","Yes"]
["4048-0",null,"Yes"]
["4110-0","NCLB: Title V, Part A: Innovative Education Strategies","Yes"]
["4124-0","ASSETS {LCCS}","Yes"]
["4201-0","NCLB: Title III, Immigrant Education Program","Yes"]
["4203-0","NCLB: Title III, Limited English Proficiency (LEP) Student Program","Yes"]
["4610-0","PCSGP (startup, implementation, dissemination)","Yes"]
["5210-0","Head Start","Yes"]
["5310-0","Child Nutrition: School Programs (e.g. School Lunch, School Breakfast, Milk, Pregnant & Lactating Students","Yes"]
["5315-0","Child Nutrition: ARRA Equipment Assistance Grants","Yes"]
["5370-0","Child Nutrition: Fresh Fruit and Vegetable Program (D)","Yes"]
["5380-0","Child Nutrition: School Breakfast Startup (state/8520)","Yes"]
["5815-0","CSFIP (Charter School Facility Incentive Grant Program) [8299]","Yes"]
["5820-0","FLAP Grant","Yes"]
["6010-0","ASES related expenses","Yes"]
["6020-0","CSIS (BP Cohort, etc.) use with account 8590","No"]
["6030-0","CSFP (Charter School Facilities Grant) [8545]","No"]
["6050-0","Prekindergarten and Family Literacy {RES}","No"]
["6258-0","PE Grant Revenue  [8590]","No"]
["6267-0","National Board Certification Teacher Incentive Grant","No"]
["6275-0","Teacher Recruitment and Retention","No"]
["6285-0","Community Based Tutoring Program","No"]
["6286-0","English Language Acquisition Program, Teacher Training & Student Assistance","Yes"]
["6300-0","Lottery:  Instructional Materials (restricted Prop 20)","No"]
["6340-0","Nell Soto - improving academic achievement through home visits and/or community meetings","No"]
["6386-0","California Parternership Academies (CPA): Green and Clean Academies (D)","No"]
["6500-0","Special Education","Yes"]
["6512-0","Special Education - State Mental Health","Yes"]
["6760-0","Arts and Music Block Grant  [Object 8590]","No"]
["6761-0","Art, Music, and Physical Education Supplies and Equipment","No"]
["7026-0","Instructional School Gardens","No"]
["7055-0","Ca HS Exit Examination Intensive Instruction and Services  [8590]","No"]
["7056-0","California High School Exit Exam Individualized Materials","No"]
["7080-0","Middle & HS Supplemental Counseling Program  [8590]","No"]
["7091-0","Economic Impact Aid: Limited English Proficiency (LEP)","No"]
["7126-0","CA K-12 High School Network","No"]
["7258-0","High Priority Schools Grants Program","No"]
["7260-0","School Improvement Program (SIP)","No"]
["7276-0","Certificated Staff Mentoring Program (08-09)","No"]
["7280-0","Staff Development:Beginning Teacher Support/Assessment (BTSA)","No"]
["7392-0","Teacher Credentialing Block Grant","No"]
["7396-0","Discretionary Block Grant - School Site","No"]
["7397-0","Discretionary Block Grant - School District","No"]
["7398-0","Instructional Materials, Library Materials and Education Technology","No"]
["7710-0","State School Facilities Projects","No"]
["8001-0","Teacher Appreciation Funds {ECHS}","No"]
["8111-0","Allowance {ECHS}","No"]
["8220-0","Kaiser Grant {GVCS, Oasis}","No"]
["9001-7","Fund-a-Need Grant 2007 {SBS}","No"]
["9001-8","Fund-a-Need Grant 2008 {SBS}","No"]
["9002-7","CP Community Projects {SBS}","No"]
["9003-0","Gasser Grant - Profitt {SBS}","No"]
["9004-0","Gasser Grant - Nelson {SBS}","No"]
["9005-0","Gasser Grant â€“ Lorraine {SBS}","No"]
["9006-0","Kiwanis Club Grant {SBS only}","No"]
["9007-0","Waldorf Collaborative Fund of RSF Social Finance {SBS}","No"]
["9008-0","Napa Downtown Gran Prix/Cycle Circus {SBS}","No"]
["9009-0","Alex Graf {LCCS}","No"]
["9010-0","New Leaders, Inc {LCCS}","No"]
["9010-9","Gasser Grant 1 - FY08/09 {SBS}","No"]
["9011-9","Gasser Grant 2 - FY08/09 {SBS}","No"]
["9012-0","Donations - Individual {LCSS}{SBS}","No"]
["9013-0","Donations - Corporations {LCCS}{SBS}","No"]
["9014-0","Donations - Foundations {LCCS}","No"]
["9015-0","Donations - Gifts in Kind","No"]
["9103-0","CMS Foundation","No"]
["9104-0","Alameda County Public Health","No"]
["9106-0","Bayes","No"]
["9120-0","Comprehensive School Reform (related to High Priority Grants) {ECHS}","No"]
["9121-0","Greenworks Grant {ECHS}","No"]
["9122-0","Youth Policy Institute Grant {ECHS}","No"]
["9123-0","Lowe's Grant [ECHS}","No"]
["9124-0","Beach Rotary Grant {ECHS}","No"]
["9125-0","Library Grant {ECHS}","No"]
["9126-0","Fundraising - to track expenses or revenues","No"]
["9130-0","Bullis Foundation - Gifts","No"]
["9131-0","Boosters Club (Bullis, UPA, Cornerstone, OAHS)","No"]
["9135-0","Books {VPA}, ACLC {NEA},Cafeteria Fundraising (VASA), Scrip (SOAR), Graduation (OAHS), Parent Club (Bayshore), Graphic Design Course-Art (UPA), Hot lunch program (GVCS), RTTT (ECHS), Ingenium (H.Off), Prop H (ES), Chevron Grant (ECR), SPED (Excel)","No"]
["9136-0","Lunch Program (VPA), Drama (UPA), Fundraising - Sports (OAHS), Carnival (VASA)","No"]
["9137-0","Program 3 (VPA) (Sycamore) (VASA) (RGTC - Natl Gateway), UPA-Science FR","No"]
["9138-0","Program 4 (VPA) (VASA) (Sycamore), Band (UPA)","No"]
["9139-0","Program 5 (VPA) (SB) (VASA) (Sycarmore - Water Grant), Language Arts (UPA)","No"]
["9140-0","Program 6 (FKCS, VPA)(VASA){SBS}, Social Science (UPA), Scribes Grant(Sycamore)","No"]
["9141-0","Program 7 (FKCS, EP), Math (UPA)","No"]
["9150-0","Couric Grant","No"]
["9151-0","District - TRESD Inst Matl {SBS}","No"]
["9152-0","Edvision","No"]
["9153-0","Cycles for Change","No"]
["9154-0","After Care {GVCS} {SBS}{VASA}{CACS}{Walden}","No"]
["9156-0","Program Site Council {Disco}","No"]
["9176-0","Genentech","No"]
["9196-0","Irwin Foundation","No"]
["9220-0","Kaiser Foundation","No"]
["9221-0","Foundation-Grant 1 (Oasis, EP, VPA, NCTT, SBP-Restr Donation, ES-3CS grant, CSCE - Stuart))","No"]
["9222-0","Foundation-Grant 2 (Oasis, EP, NCTT, ES)","No"]
["9223-0","Foundation-Grant 3 (Oasis, NCTT, ECS, LCCS)","No",null,null,null,null,null,null,null,null,null,null,{"$f":"vloo","v":{"$error":"#NAME?"}}]
["9224-0","Foundation-Grant 4 (Oasis, NCTT)","No"]
["9225-0","Foundation-Grant 5 (Oasis, NCTT, Envision, LCCS)","No"]
["9226-0","Foundation-Grant 6 (Oasis, NCTT)","No"]
["9227-0","Foundation-Grant 7 (Oasis, NCTT)","No"]
["9228-0","Foundation-Grant 8 (Oasis)","No"]
["9229-0","Foundation-Grant 9 (Oasis)","No"]
["9230-0","Foundation-Grant 10 (Oasis, EP)","No"]
["9236-0","Moore Grant","No"]
["9255-0","Oakland Fund for the Arts","No"]
["9256-0","Oakland Fund for Children Youth","No"]
["9260-0","Other Foundation Contributions","No"]
["9280-0","Rogers Foundation","No"]
["9296-0","San Francisco Foundation","No"]
["9332-0","Walton Foundation 1 {SBS}, Excel, CAPS","No"]
["9333-0","Walton Grant 2 {SBS}","No"]
["9333-3","Walton Grant 2003 {SBS}","No"]
["9333-6","Walton Grant 2006 {SBS}","No"]
["9341-0","Outdoor Fund {Sunrise}","No"]
["9351-0","Stone Grant {SBS}","No"]
["9352-0","YAYI {SBS}","No"]
["9353-0","{LCCS}","No"]
["9354-0","Y&H Soda {OASIS}","No"]
["9355-0","Fundraising - Anonymous","No"]
["9360-0","ASB","No"]
["9361-0","Bonner Grant {VASA}","No"]
["9362-0","Cultural Art Grant {VASA}","No"]
["9363-0","Northwestern Mutual {VASA}","No"]
["9401-0","Hewlett COP","No"]
["9402-0","Hewlett General","No"]
["9403-0","DLSAS","No"]
["9501-0","Hawaii - Kamaile","No"]
["9502-0","Hawaii - Hoâ€›okÄ\u0081koâ€›o","No"]
["APXX-0","Resource Code To Be Determined","No"]