{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Changes","BCR Report","Supplemental"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":46,"comments":1,"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":"Changes","index":0,"n_rows":4,"n_cols":4,"rows_kept":4,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["Changes"]
["Date","Report","Column/Row/Line","Change"]
["2017-03-10","Supplemental","E50","Changed formula from \"=E17+E12\" to \"=E17-E12\""]
["2017-03-10","Supplemental","B17","Deleted \"Surplus/Fund Balance\"; Added \"Net Change\""]

{"sheet":"BCR Report","index":1,"n_rows":919,"n_cols":10,"rows_kept":919,"cut":false,"hidden":false,"merged":[[156,6,157,6],[685,1,685,2],[116,2,118,2],[156,4,157,4],[845,5,845,7],[156,5,157,5],[156,1,157,1],[156,2,157,2],[156,3,157,3],[116,6,118,6],[110,6,112,6],[114,6,115,6],[15,1,15,2],[16,1,16,2],[23,1,23,2]]}
["%,LACTUALS,S2YEAR",null,null,"%,QBOR_BCR_LEDGER_NVS,CA.POSTED_TOTAL_AMT,S2YEAR","%,LBCRADJ,UPOSTED_TOTAL_AMT,S2YEAR"]
[null,"Balance Sheet","See “Instructions and Query for the Balance Sheet Section”"]
[null,null,null,null,null,null,null,{"$f":"\"As of Date: \" &ASD","v":"As of Date: 2016-06-30"}]
[null,"Revenues","See “Instructions and Query for the Rev and Exp Section”",null,null,null,null,{"$f":"\"Report ID: \" &RID","v":"Report ID: BCRPT"}]
[null,"Expenditures",null,null,null,null,null,{"$f":"\"Layout Name: \" &LYN","v":"Layout Name: BUDGET_COMPLIANCE"}]
[null,null,null,null,null,null,null,{"$f":"\"Operator: \" &OPR","v":"Operator: JBFREEMAN"}]
[null,{"$f":"\"Fund Balance July 1, \" &  (TEXT(ASD,\"YYYY\") - 1)","v":"Fund Balance July 1, 2015"},{"$f":"\"See \" & \"“Instructions and Queries for the fund balance July 1, \" & (TEXT(ASD,\"YYYY\") - 1) & \"” section\"","v":"See “Instructions and Queries for the fund balance July 1, 2015” section"},null,null,null,null,{"$f":"\"Run Date: \"&TEXT(NvsEndTime, \"mmmm dd, yyyy\")","v":"Run Date: March 10, 2017"}]
[]
[null,{"$f":"\"Adjustments and Fund Balance June 30, \"& TEXT(ASD, \"YYYY\")","v":"Adjustments and Fund Balance June 30, 2016"},{"$f":"\"See \" & \"“Instuctions and Query for Budget Basis Adjustments and Fund Balance June 30, \" & TEXT(ASD, \"YYYY\") & \"” section\"","v":"See “Instuctions and Query for Budget Basis Adjustments and Fund Balance June 30, 2016” section"}]
[]
[null,null,"Do Not Type in Red Area or in Cells with Formulas"]
[]
[null,null,"Manual Entry Required"]
[]
[]
[null,"Kennesaw State University"]
[null,{"$f":"\"Budget to Actuals Report - FY \" & TEXT(ASD, \"YYYY\")","v":"Budget to Actuals Report - FY 2016"}]
[null,null,null,"A","B","C"]
[null,null,null,"ACTUALS and DETAIL_EN Ledgers","BCRADJ Ledger"]
[null,null,null,null,"Budget Basis Adjustments"]
[null,null,null,{"$f":"\"June 30, \" & TEXT(ASD, \"YYYY\")","v":"June 30, 2016"},null,"TOTAL",null,"Mapping (For Column A)",null,"Formula Criteria Details"]
[null,"BALANCE SHEET section of worksheet:"]
[]
[null,"ASSETS"]
["%,FACCOUNT,TBTA_ACCOUNTS,NCASH,FFUND_CODE,TREPORT_FUNDS,NBTA_FUNDS","BS1","Cash and Cash Equivalents",49053295.759000003,0,{"$f":"D25+E25","v":49053295.759000003},null,"Acct 11xxxx (Excluding 1198xx), 158xxx"]
["%,FACCOUNT,TBTA_ACCOUNTS,NSHORTTERM INVESTMENT,FFUND_CODE,TREPORT_FUNDS,NBTA_FUNDS","BS2","Investments",90842.880000000005,0,{"$f":"D26+E26","v":90842.880000000005},null,"Acct 1198xx, 15xxxx (Excluding 158xxx)"]
[null,"BS3","Accounts Receivable"]
["%,FACCOUNT,TBTA_ACCOUNTS,NACCTS REC - STATE,FFUND_CODE,TREPORT_FUNDS,NBTA_FUNDS","BS4","     State Appropriation",0,0,{"$f":"D28+E28","v":0},null,"Acct 123xxx"]
["%,FACCOUNT,TBTA_ACCOUNTS,NACCOUNTS REC - FED,FFUND_CODE,TREPORT_FUNDS,NBTA_FUNDS","BS5","     Federal Financial Assistance",2576536.4900000002,0,2576536.4900000002,null,"Acct 124xxx"]
["%,FACCOUNT,TBTA_ACCOUNTS,NACCTS REC - OTHER,FFUND_CODE,TREPORT_FUNDS,NBTA_FUNDS","BS6","     Other",4374512.28,3024097.34,7398609.6200000001,null,"Acct 12xxxx (Excluding 123xxx, 124xxx, 126xxx)"]
[null,"BS7","     Margin Allocation",null,null,0]
["%,FACCOUNT,TBTA_ACCOUNTS,NPREPAID,FFUND_CODE,TREPORT_FUNDS,NBTA_FUNDS","BS8","Prepaid Expenditures",348284.44,0,348284.44,null,"Acct 13xxxx"]
["%,FACCOUNT,TBTA_ACCOUNTS,NINVENTORY,FFUND_CODE,TREPORT_FUNDS,NBTA_FUNDS","BS9","Inventories",26680.48,0,26680.48,null,"Acct 14xxxx"]
["%,FACCOUNT,TBTA_ACCOUNTS,N\"OTHER ASSETS\",N\"CAPITAL ASSETS\",FFUND_CODE,TREPORT_FUNDS,NBTA_FUNDS","BS10","Other Assets",28327.8,0,28327.8,null,"Acct 126xxx",null,"Acct 16xxxx"]
[]
[null,"BS11","TOTAL ASSETS",{"$f":"SUM(D24:D35)","v":56498480.129000001},{"$f":"SUM(E24:E35)","v":3024097.34},{"$f":"D36+E36","v":59522577.468999997}]
[]
[null,null,"LIABILITIES AND FUND BALANCE"]
[]
[null,null,"Liabilities:"]
[null,"BS12","Cash Overdraft",null,null,{"$f":"D41+E41","v":0},null,"Acct 11xxxx (Excluding 1198xx), 158xxx  IF THE TOTAL AMOUNT FOR THIS LINE IS NEGATIVE"]
["%,FACCOUNT,TBTA_ACCOUNTS,NCONTRACTS PAYABLE,FFUND_CODE,TREPORT_FUNDS,NBTA_FUNDS","BS13","Contracts Payable",0,0,0,null,"Acct 2119xx"]
[null,"BS14","Grants Payable",null,null,0,null,"Do Not Use - Contact Claire Arnold at claire.arnold@usg.edu if you have a balance to report on this line.  Note: Include Restricted Fund 20000 payables on Accounts Payable or Accrued Payroll lines."]
["%,FACCOUNT,TBTA_ACCOUNTS,NSALARIES PAYABLE,FFUND_CODE,TREPORT_FUNDS,NBTA_FUNDS","BS15","Accrued Payroll",-883234.6,0,-883234.6,null,"Acct 2121xx"]
[null,"BS16","Payroll Withholdings",null,null,0,null,"Do Not Use - Contact Claire Arnold at claire.arnold@usg.edu if you have a balance to report on this line."]
["%,FACCOUNT,TBTA_ACCOUNTS,NACCOUNTS PAYABLE,FFUND_CODE,TREPORT_FUNDS,NBTA_FUNDS","BS17","Accounts Payable",-1011239.41,0,-1011239.41,null,"Acct 211xxx (Excluding 2119xx), 2122xx, 213xxx, 214xxx, 215xxx, 218xxx, 2198xx, 2199xx, 221xxx-228xxx, 231xxx-235xxx"]
["%,FACCOUNT,V381100,FLEDGER,VENCUMB,FFUND_CODE,TREPORT_FUNDS,NBTA_FUNDS_WO_SR","BS18","Encumbrance Payable",-26872998.02,0,-26872998.02,null,"Acct 381100"]
[null,"BS19","Benefits Payable",null,null,0,null,"USO Only"]
["%,FACCOUNT,TBTA_ACCOUNTS,NDEFERRED REVENUE,FFUND_CODE,TREPORT_FUNDS,NBTA_FUNDS","BS20","Deferred Revenue",-12682322.08,0,-12682322.08,null,"Acct 216xxx, 217xxx, 2913xx, 2914xx"]
["%,FACCOUNT,TBTA_ACCOUNTS,NDEPOSITS FOR OTHERS,FFUND_CODE,TREPORT_FUNDS,NBTA_FUNDS","BS21","Funds Held for Others",0,0,0,null,"Acct 24xxxx, 25xxxx"]
["%,FACCOUNT,TBTA_ACCOUNTS,NOTHER LIABILITIES,FFUND_CODE,TREPORT_FUNDS,NBTA_FUNDS","BS22","Other Liabilities",-128000,0,-128000,null,"Acct 219xxx (Excluding 2199xx), 2911xx, 2912xx"]
[]
[null,"BS23","Total Liabilities",{"$f":"SUM(D40:D52)","v":-41577794.109999999},{"$f":"SUM(E40:E52)","v":0},{"$f":"D53+E53","v":-41577794.109999999}]
[]
[null,null,"Fund Balances:"]
[]
[null,"BS24","Reserved"]
[null,"BS25","Capital Outlay",null,null,{"$f":"F830","v":0}]
[null,"BS26","Departmental Sales and Services",null,null,{"$f":"F831","v":-7064707.6800000016}]
[null,"BS27","Indirect Cost Recoveries",null,null,{"$f":"F832","v":-2145716.79}]
[null,"BS28","Technology Fees",null,null,-848087.96000000066]
[null,"BS29","Restricted Funds",null,null,-284972.39999999851]
[null,"BS30","Uncollectible Accounts Receivable",null,null,0]
[null,"BS31","Inventories",null,null,0]
[null,"BS32","Carry-Over \"Per OPB\"",null,null,0]
[null,"BS33","Early Retirement Program",null,null,0]
[null,"BS34","Tuition Carry Forward",null,null,{"$f":"F839","v":0}]
[null,"BS35","Undesignated"]
[null,"BS36","Surplus"]
[null,"BS37","     Regular",null,null,{"$f":"F840","v":-7601301.5400000103}]
[null,"BS38","     Tobacco Settlement Funds"]
[]
[null,"BS39","Total Fund Balances ",{"$f":"SUM(D55:D72)","v":0},{"$f":"SUM(E55:E72)","v":0},{"$f":"SUM(F55:F72)","v":-17944786.370000012}]
[]
[null,"BS40","TOTAL LIABILITIES AND FUND BALANCES",{"$f":"D73+D53","v":-41577794.109999999},{"$f":"E73+E53","v":0},{"$f":"F73+F53","v":-59522580.480000012}]
[]
[]
[null,"REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE section of worksheet:"]
[]
[null,null,"Teaching-Revenue"]
[]
[null,1,"General Funds (excluding PSI's)"]
["%,FACCOUNT,TBTA_ACCOUNTS,NTUITION,NSURPLUS_RETURN,FFUND_CODE,V10500",2,"Tuition Revenues",-168476005.99000001,5968256.2199999997,{"$f":"D83+E83","v":-162507749.77000001},null,"Fund 10500 -  Acct 401xxx-402xxx, 480100, 409998.  NOTE: Fund 10500 should not have any other revenue accounts other than Tuition Accts 401xxx-402xxx and 409998."]
["%,FACCOUNT,TBTA_ACCOUNTS,NALL REV ACCTS,FFUND_CODE,V16000",3,"Technology Fees ",-4124894.72,0,-4124894.72,null,"Fund 16000 -  Acct 4xxxxx"]
["%,FACCOUNT,TBTA_ACCOUNTS,NALL REV ACCTS,FFUND_CODE,V15000",4,"Indirect Cost Recoveries ",-551584.57999999996,0,-551584.57999999996,null,"Fund 15000 -  Acct 4xxxxx"]
["%,FACCOUNT,TBTA_ACCOUNTS,NFINES AND FORFEITS,FFUND_CODE,V10600","5a","Other Revenue - Fines and forfeits",-9319.73,0,-9319.73,null,"Fund 10600 Acct 442xxx"]
["%,FACCOUNT,TBTA_ACCOUNTS,NRENTS AND ROYALTIES,FFUND_CODE,V10600","5b","Other Revenue - Rents and Royalties",-314326,0,-314326,null,"Fund 10600 -  Acct 451xxx"]
["%,FACCOUNT,TBTA_ACCOUNTS,N\"OTHER FEES\",FFUND_CODE,V10600","5c","Other Revenue - Other fees (eg. Application)",-25897350.93,6898016.5700000003,-18999334.359999999,null,"Fund 10600 -  Acct 403xxx-409xxx"]
["%,FACCOUNT,TBTA_ACCOUNTS,NINVESTMENT INCOME,FFUND_CODE,V10600","5d","Other Revenue - Interest and other investment income",-113696.04,113696.04000000001,0,null,"Fund 10600 -  Acct 481xxx, 486xxx, 487xxx, 488xxx, 489xxx, 490xxx, 4932xx, 495xxx"]
["%,FACCOUNT,TBTA_ACCOUNTS,NGIFTS,FFUND_CODE,V10600,FCLASS_FLD,TBTA_CLASS,NCAP_OUTLAY_OTHR_SOUR","5e","Other Revenue - Gifts, donations and contributions",-26250,0,-26250,null,"Fund 10600 -  Acct 485xxx (excluding any amounts that are determined to be Capital Outlay)"]
["%,FACCOUNT,TBTA_ACCOUNTS,N\"OTHER REVENUE\",FFUND_CODE,V10000,V11810","5f","Other Revenue - Other State Appropriation",0,0]
["%,FACCOUNT,TBTA_ACCOUNTS,N\"OTHER REVENUE\",N\"STATE APPROP\",FFUND_CODE,V10600","5g","Other Revenue - Other General",-1594183.03,703551.44000000006,-890631.59,null,"Fund 10600 -  Acct 41xxxx (excluding 414998), 441xxx, 449xxx, 452xxx, 47xxxx, 492xxx, 4931xx, 4933xx, 498998"]
["%,FACCOUNT,TBTA_ACCOUNTS,N\"STATE APPROP\",FFUND_CODE,V10000,FCLASS_FLD,TBTA_CLASS,NBTA_NON_SFI_RESEARC",7,"State Appropriations-State Appropriations ",-115173690.05,-8684.94,-115182374.98999999,null,"Fund 10000 -  Acct 480xxx, 414998 (Excluding Class 12000, 13000, 17000, Public Service Institutes Revenue, Office of Minority Business Revenue, and any amounts budgeted as Capital Outlay which was recorded in Fund 10000).  NOTE:  State Appropriations MUST tie to the Final Budget amount on the website.",null,"Class 11xxx, 14xxx"]
[null,8,"Total General Funds ",{"$f":"SUM(D80:D93)","v":-316281301.06999999},{"$f":"SUM(E80:E93)","v":13674835.329999998},{"$f":"SUM(F80:F93)","v":-302606465.74000001}]
[]
[null,null,"Departmental Sales and Services"]
["%,FACCOUNT,TBTA_ACCOUNTS,NALL REV ACCTS,FFUND_CODE,V14000",9,"DSS Revenues",-14256574.109999999,0,{"$f":"D97+E97","v":-14256574.109999999},null,"Fund 14000 -  Acct 4xxxxx"]
[]
[null,"9a","Total General Funds and DSS Revenues",null,null,{"$f":"F94+F97","v":-316863039.85000002}]
[]
[null,null,"Restricted"]
["%,FACCOUNT,TBTA_ACCOUNTS,N\"SPON FEDERAL REV\",FFUND_CODE,V20000,FCLASS_FLD,TBTA_CLASS,NSPONSORED_FEDERAL","10a","Restricted - Federal",-57570809.399999999,0,{"$f":"D102+E102","v":-57570809.399999999},null,"Fund 2xxxx -  Acct 421xxx, 425998, 4721xx, 4911xx, and all other 4xxxxx accts related to Federal Projects (ie Interest Income); Exclude Class FSxxx",null,"Fund 20000, Class 411000-411199, 424xxx, 4721xx, 61xxx"]
["%,FACCOUNT,TBTA_ACCOUNTS,N\"ALL REV ACCTS\",FFUND_CODE,V20000,FCLASS_FLD,TBTA_CLASS,NSPONSORED_FED_STIM","10aa","Restricted - Federal - Federal Stimulus",0,0,0,null,"Fund 2xxxx, Class FSxxx",null,"Fund 20000, Acct 4xxxxx - Class FSxxx"]
["%,FACCOUNT,TBTA_ACCOUNTS,N\"ALL REV ACCTS\",FFUND_CODE,V20000,FCLASS_FLD,TBTA_CLASS,NSPONSORED_STATE","10b","Restricted - State",-1024813.66,0,-1024813.66,null,"Fund 2xxxx -  Acct 422xxx, 4722xx, 4912xx, and all other 4xxxxx accts related to State Projects (ie. Interest Income)",null,"Fund 20000, Acct 4xxxxx - Class 62xxx"]
["%,FACCOUNT,TBTA_ACCOUNTS,N\"ALL REV ACCTS\",FFUND_CODE,V20000,FCLASS_FLD,TBTA_CLASS,NSPONSORED_LOCAL","10c","Restricted - Local",-22513.32,0,-22513.32,null,"Fund 2xxxx -  Acct 423xxx, 4723xx, 4913xx, and all other 4xxxxx accts related to Local Projects (ie. Interest Income)",null,"Fund 20000, Acct 4xxxxx - Class 63xxx"]
["%,FACCOUNT,TBTA_ACCOUNTS,N\"ALL REV ACCTS\",FFUND_CODE,V20000,FCLASS_FLD,TBTA_CLASS,NSPONSORED_PRIVATE","10d","Restricted - Private",-4701606.75,0,-4701606.75,null,"Fund 2xxxx -  Acct 424xxx, 4724xx, 4914xx, and all other 4xxxxx accts related to Private Projects (ie. Interest Income)",null,"Fund 20000, Acct 4xxxxx - Class 64xxx"]
["%,FACCOUNT,TBTA_ACCOUNTS,N\"ALL REV ACCTS\",FFUND_CODE,V20000,V21810,FCLASS_FLD,TBTA_CLASS,NSPONSORED_ENDOWMENTS","10e","Restricted - Endowment",-104438.11,0,-104438.11,null,"Fund 2xxxx -  Fund 20000;Acct 424xxx, 4724xx, 4914xx, and all other 4xxxxx accts related to Private Projects (ie. Interest Income) - Class 65000",null,"Fund 20000, Acct 4xxxxx - Class 65xxx"]
[null,"10e","Total Restricted Revenue ",{"$f":"SUM(D101:D107)","v":-63424181.239999995},{"$f":"SUM(E101:E107)","v":0},{"$f":"SUM(F101:F107)","v":-63424181.239999995}]
[]
[null,null,"Capital Outlay"]
["%,FACCOUNT,TBTA_ACCOUNTS,NSTATE APPROP,FFUND_CODE,TREPORT_FUNDS,NUNEXPENDED_PLANT","11a","State Appropriations Fund 50000",747.5,-747.5,{"$f":"D111+E111","v":0},null,"Fund 50000 -  Acct 480xxx, 414998"]
[null,"11b","State Appropriations Fund 10000",null,null,0,null,"Fund 10000 -  Institution specific analysis.  Any amounts budgeted as Capital Outlay recorded in Fund 10000 (ie. Class 16xxx).",null,"Account 414998, 480xxx"]
[null,null,null,null,null,null,null,"NOTE: State Appropriations MUST tie to the Final Budget amount on the website."]
["%,FACCOUNT,TBTA_ACCOUNTS,NCAPITAL INCOME,FFUND_CODE,TREPORT_FUNDS,NUNEXPENDED_PLANT","12a","Investment Income",0,-113696.04000000001,-113696.04000000001,null,"Fund 50000 -  Acct 486xxx, 487xxx, 488xxx, 489xxx, 490xxx, 495xxx"]
["%,FACCOUNT,TBTA_ACCOUNTS,NOTHER_STATE_GIFTS,NGIFTS,FFUND_CODE,TREPORT_FUNDS,NUNEXPENDED_PLANT","12b","Bond funds (through GSFIC) Fund 50000",0,0,0,null,"Fund 50000 -  Acct 485xxx.  Institution specific analysis for amts budgeted as Bond (review Final Budget amounts on website)",null,"Acct 4229xx"]
["%,FACCOUNT,TBTA_ACCOUNTS,NOTHER_STATE_GIFTS,NGIFTS,FFUND_CODE,V10000","12bb","Bond funds (through GSFIC) Fund 10000",0,0,0,null,"Fund 10000 -  Acct 485xxx.  Institutions specific analysis for amounts determined to be Capital Outlay recorded in Fund 10000",null,"Acct 4229xx"]
[null,"12c","Other",null,null,0,null,"Not mapped - Fund 50000 -  Acct 485xxx.  Institution specific analysis for amounts budgeted as Other (review Final Budget amounts on website)"]
["%,FACCOUNT,TBTA_ACCOUNTS,NGIFTS,FFUND_CODE,V10000,V10600,FCLASS_FLD,TBTA_CLASS,NCAPITAL_OUTLAY","12cc",null,-5810105.2199999997,0,-5810105.2199999997,null,"Funds 10000 and 10600 -  Acct 485xxx.  Institutions specific analysis for amounts determined to be Capital Outlay recorded in Fund 1xxxx",null,"Class 16000 - 16500"]
["%,FACCOUNT,TBTA_ACCOUNTS,NTUITION,N\"FINES AND FORFEITS\",N\"RENTS AND ROYALTIES\",N\"OTHER FEES\",N\"OTHER REVENUE\",N\"SPON FEDERAL REV\",FFUND_CODE,TREPORT_FUNDS,NUNEXPENDED_PLANT","12ccc",null,0,-13671630.84,-13671630.84,null,"Fund 50000 -  All other 4xxxxx accts not already mapped on Capital Outlay lines",null,"All other 4xxxxx accts (401xxx - 402xxx, 409998, 442xxx, 403xxx - 409xxx, 41xxxx - 4148xx, 415xxx - 419xxx, 441xxx, 449xxx - 449x, 452xxx, 47xxxx, 492xxx, 4931xx, 4933xx, 498998, 4110xx - 4111xx, 421xxx, 424xxx, 425998, 4721xx, 4911xx, 451xxx)"]
[null,15,"Total Capital Outlay ",{"$f":"SUM(D110:D119)","v":-5809357.7199999997},{"$f":"SUM(E110:E119)","v":-13786074.379999999},{"$f":"SUM(F110:F119)","v":-19595432.100000001}]
[]
[null,16,"Total Teaching Revenue",{"$f":"D94+D97+D108+D120","v":-399771414.14000005},{"$f":"E94+E97+E108+E120","v":-111239.05000000075},{"$f":"F94+F97+F108+F120","v":-399882653.19000006}]
[]
[null,null,"Public Service Institutes-Revenue"]
[null,17,"State Funds",null,null,{"$f":"D125+E125","v":0},null,"Institution specific analysis.  NOTE: State Appropriations MUST tie to the Final Budget amount on the website."]
[null,"18a","Other Revenue - Rents and Royalties",null,null,0]
[null,"18b","Other Revenue - Other fees",null,null,0]
[null,"18c","Other Revenue - Interest and other investment income",null,null,0]
[null,"18d","Other Revenue - Gifts, donations and contributions",null,null,0]
[null,"18e","Other Revenue - Other",null,null,0]
[null,19,"DSS Funds",null,null,0]
[null,"20a","Restricted - Federal",null,null,0]
[null,"20b","Restricted - State",null,null,0]
[null,"20c","Restricted - Local",null,null,0]
[null,"20d","Restricted - Private",null,null,0]
[null,21,"Total Public Service Institutes Revenue",{"$f":"SUM(D124:D135)","v":0},{"$f":"SUM(E124:E135)","v":0},{"$f":"SUM(F124:F135)","v":0}]
[]
[null,22,"Total Teaching Revenue",{"$f":"D122+D136","v":-399771414.14000005},{"$f":"E122+E136","v":-111239.05000000075},{"$f":"F122+F136","v":-399882653.19000006}]
[]
[null,null,"Teaching-Expenditures"]
["%,FACCOUNT,TBTA_ACCOUNTS,NPER_SERVS,FFUND_CODE,V10500,FCLASS_FLD,TBTA_CLASS,NTUITION_OTHER_GEN",23,"Tuition Fund - Personal Services",125185926.58,0,{"$f":"D141+E141","v":125185926.58},null,"Fund 10500 -  Acct 5xxxxx (Excluding Class 12000 & 13000)",null,"Class 00000 - 11999, 14000 - 99999"]
["%,FACCOUNT,TBTA_ACCOUNTS,NNON_PER_SERVS,FFUND_CODE,V10500,FCLASS_FLD,TBTA_CLASS,NTUITION_OTHER_GEN",24,"Tuition Fund - Operating Expenses",43487273.158,-5792758.0899999999,37694515.068000004,null,"Fund 10500 -  Acct 6xxxxx-9xxxxx (Excluding Class 12000 & 13000)",null,"Acct 6xxxxx-980xxx, 999950, 982xxx - 991500, Class 00000 - 11999, 14000 - 99999"]
["%,FACCOUNT,TBTA_ACCOUNTS,NPER_SERVS,FFUND_CODE,V10000,FCLASS_FLD,TBTA_CLASS,NTUITION_OTHER_GEN",25,"State Appropriations - Personal Services",109289886.93000001,0,109289886.93000001,null,"Fund 10000 -  Acct 5xxxxx (Excluding Class 12000 & 13000)",null,"Class 00000 - 11999, 14000 - 99999"]
["%,FACCOUNT,TBTA_ACCOUNTS,NNON_PER_SERVS,FFUND_CODE,V10000,FCLASS_FLD,TBTA_CLASS,NTUITION_OTHER_GEN",26,"State Appropriations - Operating Expenses",5848741.0460000001,43744.020000000004,5892485.0659999996,null,"Fund 10000 -  Acct 6xxxxx-9xxxxx (Excluding Class 12000 & 13000)",null,"Acct 6xxxxx-980xxx, 999950, 982xxx - 991500, Class 00000 - 11999, 14000 - 99999"]
["%,FACCOUNT,TBTA_ACCOUNTS,NPER_SERVS,FFUND_CODE,V10600,FCLASS_FLD,TBTA_CLASS,NTUITION_OTHER_GEN",27,"Other General Funds - Personal Services",5026403.51,0,5026403.51,null,"Fund 10600 -  Acct 5xxxxx (Excluding Class 12000 & 13000)",null,"Class 00000 - 11999, 14000 - 99999"]
["%,FACCOUNT,TBTA_ACCOUNTS,NNON_PER_SERVS,FFUND_CODE,V10600,FCLASS_FLD,TBTA_CLASS,NTUITION_OTHER_GEN",28,"Other General Funds - Operating Expenses",28736420.074999999,-13217257.73,15519162.344999999,null,"Fund 10600 -  Acct 6xxxxx-9xxxxx (Excluding Class 12000 & 13000)",null,"Acct 6xxxxx-980xxx, 999950, 982xxx - 991500, Class 00000 - 11999, 14000 - 99999"]
["%,FACCOUNT,TBTA_ACCOUNTS,NPER_SERVS,FFUND_CODE,V14000",29,"Departmental - Personal Services ",4908827.67,0,4908827.67,null,"Fund 14000 -  Acct 5xxxxx"]
["%,FACCOUNT,TBTA_ACCOUNTS,NNON_PER_SERVS,FFUND_CODE,V14000",30,"Departmental -Operating Expenses ",7518203.1799999997,0,7518203.1799999997,null,"Fund 14000 -  Acct 6xxxxx-9xxxxx",null,"Acct 6xxxxx - 980xxx, 999950, 982xxx - 991500"]
["%,FACCOUNT,TBTA_ACCOUNTS,NPER_SERVS,FFUND_CODE,V16000",31,"Technology Fee-Personal Services",2489448.0499999998,0,2489448.0499999998,null,"Fund 16000 -  Acct 5xxxxx"]
["%,FACCOUNT,TBTA_ACCOUNTS,NNON_PER_SERVS,FFUND_CODE,V16000",32,"Technology Fee-Operating Expenses",1809455.89,0,1809455.89,null,"Fund 16000 -  Acct 6xxxxx-9xxxxx",null,"Acct 6xxxxx - 980xxx, 999950, 982xxx - 991500"]
["%,FACCOUNT,TBTA_ACCOUNTS,NPER_SERVS,FFUND_CODE,V15000",33,"Indirect Cost Recoveries-Personal Services",263493.8,0,263493.8,null,"Fund 15000 -  Acct 5xxxxx"]
["%,FACCOUNT,TBTA_ACCOUNTS,NNON_PER_SERVS,FFUND_CODE,V15000",34,"Indirect Cost Recoveries-Operating Expenses",136379.70000000001,0,136379.70000000001,null,"Fund 15000 -  Acct 6xxxxx-9xxxxx",null,"Acct 6xxxxx - 980xxx, 999950, 982xxx - 991500"]
["%,FACCOUNT,TBTA_ACCOUNTS,NPER_SERVS,FFUND_CODE,V20000,FCLASS_FLD,TBTA_CLASS,NNON_STIMULUS_SPON",35,"Restricted -Personal Services ",5309714.8,0,5309714.8,null,"Fund 2xxxx -  Acct 5xxxxx, Exclude Class FSxxx",null,"Class 61xx-65xxx, "]
["%,FACCOUNT,TBTA_ACCOUNTS,NNON_PER_SERVS,FFUND_CODE,V20000,FCLASS_FLD,TBTA_CLASS,NNON_STIMULUS_SPON",36,"Restricted-Operating Expenses",58142535.530000001,0,58142535.530000001,null,"Fund 2xxxx -  Acct 6xxxxx-9xxxxx, Exclude Class FSxxx",null,"Acct 6xxxxx - 980xxx, 999950, 982xxx - 991500, Class 61xx-65xxx, "]
["%,FACCOUNT,TBTA_ACCOUNTS,NPER_SERVS,FFUND_CODE,V20000,FCLASS_FLD,TBTA_CLASS,NSPONSORED_FED_STIM","35a","Restricted - Federal Stimulus - Personal Services",0,0,0,null,"Fund 2xxxx -  Acct 5xxxxx, Class FSxxx"]
["%,FACCOUNT,TBTA_ACCOUNTS,NNON_PER_SERVS,FFUND_CODE,V20000,FCLASS_FLD,TBTA_CLASS,NSPONSORED_FED_STIM","36a","Restricted - Federal Stimulus - Operating Expenses",0,0,0,null,"Fund 2xxxx -  Acct 6xxxxx-9xxxxx, Class FSxxx",null,"Acct 6xxxxx - 980xxx, 999950, 982xxx - 991500"]
["%,FACCOUNT,TBTA_ACCOUNTS,NPER_SERVS,NNON_PER_SERVS,FFUND_CODE,V50000",37,"Capital Outlay ",0,19595432.100000001,19595432.100000001,null,"Fund 50000 -  Acct 5xxxxx-9xxxxx",null,"Acct 5xxxxx - 980xxx, 999950, 982xxx - 991500"]
[null,null,null,null,null,0,null,"Fund 10000 -  Any amts determined to be Capital Outlay recorded in Fund 10000 (i.e Class 16xxx)",null,"Keep Merged with above, no formula all Institution specific analysis"]
[null,38,"Total Teaching Expenditures",{"$f":"SUM(D141:D158)","v":398152709.91900003},{"$f":"SUM(E141:E158)","v":629160.30000000075},{"$f":"SUM(F141:F158)","v":398781870.21899998}]
[]
[null,null,"Public Service Institutes-Expenditures",null,null,null,null,"Institution specific analysis.  NOTE: State Appropriations MUST tie to the Final Budget amount on the website."]
[null,39,"State Funds",null,null,{"$f":"D162+E162","v":0}]
[null,40,"Other Funds",null,null,{"$f":"D163+E163","v":0}]
[null,41,"DSS Funds",null,null,{"$f":"D164+E164","v":0}]
[null,42,"Restricted Funds",null,null,{"$f":"D165+E165","v":0}]
[null,43,"Total Public Service Institutes Expenditure",{"$f":"SUM(D161:D165)","v":0},{"$f":"SUM(E161:E165)","v":0},{"$f":"SUM(F161:F165)","v":0}]
[]
[null,44,"Total Teaching Expenditures",{"$f":"D159+D166","v":398152709.91900003},{"$f":"E159+E166","v":629160.30000000075},{"$f":"F159+F166","v":398781870.21899998}]
[]
[null,null,"Special Funding Initiatives Revenue"]
["%,FACCOUNT,TBTA_ACCOUNTS,NALL REV ACCTS,FFUND_CODE,V10000,FCLASS_FLD,TBTA_CLASS,NGEN_OPNS_SPEC_INIT",45,"State Funds",-540000,0,{"$f":"D171+E171","v":-540000},null,"Fund 10000 -  Class 13xxx  Acct 4xxxxx"]
[null,46,"Tobacco Funds",null,null,{"$f":"D172+E172","v":0}]
[null,47,"Total Special Funding Initiatives Revenue",{"$f":"SUM(D170:D172)","v":-540000},{"$f":"SUM(E170:E172)","v":0},{"$f":"SUM(F170:F172)","v":-540000}]
[]
[null,null,"Special Funding Initiatives Expenditure"]
["%,FACCOUNT,TBTA_ACCOUNTS,NNON_PER_SERVS,NPER_SERVS,FFUND_CODE,V10000,FCLASS_FLD,TBTA_CLASS,NGEN_OPNS_SPEC_INIT",48,"State Funds",540000,0,{"$f":"D176+E176","v":540000},null,"Fund 10000 -  Class 13xxx  Acct 5xxxxx-9xxxxx",null,"Acct 5xxxxx - 980xxx, 999950, 982xxx - 991500"]
[null,49,"Tobacco Funds",null,null,{"$f":"D177+E177","v":0},null,"Georgia State University"]
[null,50,"Total Special Funding Initiatives Expenditure",{"$f":"SUM(D175:D177)","v":540000},{"$f":"SUM(E175:E177)","v":0},{"$f":"SUM(F175:F177)","v":540000}]
[]
[null,null,"Research Consortium Revenue"]
["%,FACCOUNT,TBTA_ACCOUNTS,NALL REV ACCTS,FFUND_CODE,V10000,FCLASS_FLD,TBTA_CLASS,NGEN_OPNS_RESEARCH",51,"State Funds",0,0,{"$f":"D181+E181","v":0},null,"Fund 10000 -  Class 12xxx  Acct 4xxxxx"]
[null,52,"Tobacco Funds",null,null,{"$f":"D182+E182","v":0},null,"Georgia State University"]
[null,53,"Total Research Consortium Revenue",{"$f":"SUM(D180:D182)","v":0},{"$f":"SUM(E180:E182)","v":0},{"$f":"SUM(F180:F182)","v":0}]
[]
[null,null,"Research Consortium-Expenditure"]
["%,FACCOUNT,TBTA_ACCOUNTS,NNON_PER_SERVS,NPER_SERVS,FFUND_CODE,V10000,FCLASS_FLD,TBTA_CLASS,NGEN_OPNS_RESEARCH",54,"State Funds",0,0,{"$f":"D186+E186","v":0},null,"Fund 10000 -  Class 12xxx  Acct 5xxxxx-9xxxxx",null,"Acct 5xxxxx - 980xxx, 999950, 982xxx - 991500"]
[null,55,"Tobacco Funds",null,null,{"$f":"D187+E187","v":0},null,"Georgia State University"]
[null,56,"Total Research Consortium Expenditure",{"$f":"SUM(D185:D187)","v":0},{"$f":"SUM(E185:E187)","v":0},{"$f":"SUM(F185:F187)","v":0}]
[]
[null,null,"Office of Minority Business - Revenue"]
[null,57,"State Funds",null,null,{"$f":"D191+E191","v":0},null,"Institution specific analysis.  NOTE: State Appropriations MUST tie to the Final Budget amount on the website."]
[null,58,"Indirect Cost Recoveries",null,null,0]
[null,59,"Departmental Sales & Services",null,null,0]
[null,"59a","Restricted - Federal",null,null,0]
[null,"59b","Restricted - State",null,null,0]
[null,"59c","Restricted - Local",null,null,0]
[null,"59d","Restricted - Private",null,null,0]
[null,"59e","Other Revenue - Rents and Royalties",null,null,0]
[null,"59f","Other Revenue - Other fees",null,null,0]
[null,"59g","Other Revenue - Interest and other investment income",null,null,0]
[null,"59h","Other Revenue - Gifts, donations and contributions",null,null,0]
[null,"59i","Other Revenue - Other",null,null,0]
[null,59,"Total Office of Minority Business Revenue",{"$f":"SUM(D190:D202)","v":0},{"$f":"SUM(E190:E202)","v":0},{"$f":"SUM(F190:F202)","v":0}]
[null,null,null,null,null,null,null,"Institution specific analysis.  NOTE: State Appropriations MUST tie to the Final Budget amount on the website."]
[null,null,"Office of Minority Business - Expenditures"]
[null,60,"State Funds",null,null,{"$f":"D206+E206","v":0}]
[null,{"$f":"+B206+1","v":61},"Indirect Cost Recoveries",null,null,{"$f":"D207+E207","v":0}]
[null,{"$f":"+B207+1","v":62},"Departmental Sales & Services",null,null,{"$f":"D208+E208","v":0}]
[null,{"$f":"+B208+1","v":63},"Restricted",null,null,{"$f":"D209+E209","v":0}]
[null,{"$f":"+B209+1","v":64},"Other",null,null,{"$f":"D210+E210","v":0}]
[null,{"$f":"+B210+1","v":65},"Total Office of Minority Business Expenditures",{"$f":"SUM(D205:D210)","v":0},{"$f":"SUM(E205:E210)","v":0},{"$f":"SUM(F205:F210)","v":0}]
[]
[null,null,"UGA - Forestry Research - Revenue",null,null,null,null,"UGA Only"]
[null,66,"State Funds",null,null,{"$f":"D214+E214","v":0}]
[null,{"$f":"+B214+1","v":67},"Indirect Cost Recoveries",null,null,{"$f":"D215+E215","v":0}]
[null,{"$f":"+B215+1","v":68},"Departmental Sales & Services",null,null,0]
[null,"68a","Sponsored Funds - Federal",null,null,0]
[null,"68b","Sponsored Funds - State",null,null,0]
[null,"68c","Sponsored Funds - Local",null,null,0]
[null,"68d","Sponsored Funds - Private",null,null,0]
[null,"68e","Sponsored Funds - Federal - Federal Stimulus"]
[null,"69a","Other Revenue - Rents and Royalties",null,null,0]
[null,"69b","Other Revenue - Other fees",null,null,0]
[null,"69c","Other Revenue - Interest and other investment income",null,null,0]
[null,"69d","Other Revenue - Gifts, donations and contributions",null,null,0]
[null,"69e","Other Revenue - Other",null,null,0]
[null,70,"Total UGA Forestry Research Revenue",{"$f":"SUM(D213:D226)","v":0},{"$f":"SUM(E213:E226)","v":0},{"$f":"SUM(F213:F226)","v":0}]
[]
[null,null,"UGA - Forestry Research- Expenditures"]
[null,71,"State Funds",null,null,{"$f":"D230+E230","v":0}]
[null,{"$f":"+B230+1","v":72},"Indirect Cost Recoveries",null,null,{"$f":"D231+E231","v":0}]
[null,{"$f":"+B231+1","v":73},"Departmental Sales & Services",null,null,{"$f":"D232+E232","v":0}]
[null,{"$f":"+B232+1","v":74},"Sponsored Funds",null,null,{"$f":"D233+E233","v":0}]
[null,"74a","Sponsored Funds - Federal - Federal Stimulus"]
[null,{"$f":"+B233+1","v":75},"Other",null,null,{"$f":"D235+E235","v":0}]
[null,{"$f":"+B235+1","v":76},"Total UGA Forestry Research Expenditures",{"$f":"SUM(D229:D235)","v":0},{"$f":"SUM(E229:E235)","v":0},{"$f":"SUM(F229:F235)","v":0}]
[]
[null,null,"GRU - Student Education Enrichment Program - Revenue",null,null,null,null,"GRU Only"]
[null,77,"State Funds",null,null,{"$f":"D239+E239","v":0}]
[null,{"$f":"+B239+1","v":78},"Indirect Cost Recoveries",null,null,0]
[null,{"$f":"+B240+1","v":79},"Departmental Sales & Services",null,null,0]
[null,"80a","Sponsored Funds - Federal",null,null,0]
[null,"80b","Sponsored Funds - State",null,null,0]
[null,"80c","Sponsored Funds - Local",null,null,0]
[null,"80d","Sponsored Funds - Private",null,null,0]
[null,"80e","Sponsored Funds - Federal - Federal Stimulus"]
[null,"81a","Other Revenue - Rents and Royalties",null,null,0]
[null,"81b","Other Revenue - Other fees",null,null,0]
[null,"81c","Other Revenue - Interest and other investment income",null,null,0]
[null,"81d","Other Revenue - Gifts, donations and contributions",null,null,0]
[null,"81e","Other Revenue - Other",null,null,0]
[null,82,"Total GRU Student Education Enrichment Program Revenue",{"$f":"SUM(D238:D251)","v":0},{"$f":"SUM(E238:E251)","v":0},{"$f":"SUM(F238:F251)","v":0}]
[]
[null,null,"GRU - Student Education Enrichment Program - Expenditures"]
[null,83,"State Funds",null,null,{"$f":"D255+E255","v":0}]
[null,{"$f":"+B255+1","v":84},"Indirect Cost Recoveries",null,null,{"$f":"D256+E256","v":0}]
[null,{"$f":"+B256+1","v":85},"Departmental Sales & Services",null,null,{"$f":"D257+E257","v":0}]
[null,{"$f":"+B257+1","v":86},"Sponsored Funds",null,null,{"$f":"D258+E258","v":0}]
[null,"86a","Sponsored Funds - Federal - Federal Stimulus"]
[null,{"$f":"+B258+1","v":87},"Other",null,null,{"$f":"D260+E260","v":0}]
[null,{"$f":"+B260+1","v":88},"Total GRU Student Education Enrichment Program Expenditures",{"$f":"SUM(D254:D260)","v":0},{"$f":"SUM(E254:E260)","v":0},{"$f":"SUM(F254:F260)","v":0}]
[]
[null,null,"GT - Advanced Technology Development Center/EDI - Revenue",null,null,null,null,"Georgia Tech Only"]
[null,89,"State Funds",null,null,{"$f":"D264+E264","v":0}]
[null,{"$f":"+B264+1","v":90},"Indirect Cost Recoveries",null,null,0]
[null,{"$f":"+B265+1","v":91},"Departmental Sales & Services",null,null,0]
[null,"92a","Sponsored Funds - Federal",null,null,0]
[null,"92b","Sponsored Funds - State",null,null,0]
[null,"92c","Sponsored Funds - Local",null,null,0]
[null,"92d","Sponsored Funds - Private",null,null,0]
[null,"92e","Sponsored Funds - Federal - Federal Stimulus"]
[null,"93a","Other Revenue - Rents and Royalties",null,null,0]
[null,"93b","Other Revenue - Other fees",null,null,0]
[null,"93c","Other Revenue - Interest and other investment income",null,null,0]
[null,"93d","Other Revenue - Gifts, donations and contributions",null,null,0]
[null,"93e","Other Revenue - Other",null,null,0]
[null,94,"Total GT Advanced Technology Development Center/EDI Revenue",{"$f":"SUM(D263:D276)","v":0},{"$f":"SUM(E263:E276)","v":0},{"$f":"SUM(F263:F276)","v":0}]
[]
[null,null,"GT - Advanced Technology Development Center/EDI - Expenditures"]
[null,95,"State Funds",null,null,{"$f":"D280+E280","v":0}]
[null,{"$f":"+B280+1","v":96},"Indirect Cost Recoveries",null,null,{"$f":"D281+E281","v":0}]
[null,{"$f":"+B281+1","v":97},"Departmental Sales & Services",null,null,{"$f":"D282+E282","v":0}]
[null,{"$f":"+B282+1","v":98},"Sponsored Funds",null,null,{"$f":"D283+E283","v":0}]
[null,"98a","Sponsored Funds - Federal - Federal Stimulus"]
[null,{"$f":"+B283+1","v":99},"Other",null,null,{"$f":"D285+E285","v":0}]
[null,{"$f":"+B285+1","v":100},"Total GT Advanced Technology Development Center/EDI Expenditures",{"$f":"SUM(D279:D285)","v":0},{"$f":"SUM(E279:E285)","v":0},{"$f":"SUM(F279:F285)","v":0}]
[]
[null,null,"UGA - Agricultural Experiment Station - Revenues",null,null,null,null,"UGA Only"]
[null,101,"State Funds",null,null,{"$f":"D289+E289","v":0}]
[null,{"$f":"+B289+1","v":102},"Indirect Cost Recoveries",null,null,0]
[null,{"$f":"+B290+1","v":103},"Departmental Sales & Services",null,null,0]
[null,"104a","Sponsored Funds - Federal",null,null,0]
[null,"104b","Sponsored Funds - State",null,null,0]
[null,"104c","Sponsored Funds - Local",null,null,0]
[null,"104d","Sponsored Funds - Private",null,null,0]
[null,"104e","Sponsored Funds - Federal - Federal Stimulus"]
[null,"105a","Other Revenue - Rents and Royalties",null,null,0]
[null,"105b","Other Revenue - Other fees",null,null,0]
[null,"105c","Other Revenue - Interest and other investment income",null,null,0]
[null,"105d","Other Revenue - Gifts, donations and contributions",null,null,0]
[null,"105e","Other Revenue - Other",null,null,0]
[null,106,"Total UGA Agricultural Experiment Station Revenue",{"$f":"SUM(D288:D301)","v":0},{"$f":"SUM(E288:E301)","v":0},{"$f":"SUM(F288:F301)","v":0}]
[]
[null,null,"UGA - Agricultural Experiment Station - Expenditures"]
[null,107,"State Funds",null,null,{"$f":"D305+E305","v":0}]
[null,{"$f":"+B305+1","v":108},"Indirect Cost Recoveries",null,null,{"$f":"D306+E306","v":0}]
[null,{"$f":"+B306+1","v":109},"Departmental Sales & Services",null,null,{"$f":"D307+E307","v":0}]
[null,{"$f":"+B307+1","v":110},"Sponsored Funds",null,null,{"$f":"D308+E308","v":0}]
[null,"110a","Sponsored Funds - Federal - Federal Stimulus"]
[null,{"$f":"+B308+1","v":111},"Other",null,null,{"$f":"D310+E310","v":0}]
[null,{"$f":"+B310+1","v":112},"Total UGA Agricultural Experiment Station Expenditures",{"$f":"SUM(D304:D310)","v":0},{"$f":"SUM(E304:E310)","v":0},{"$f":"SUM(F304:F310)","v":0}]
[]
[null,null,"UGA - Athens Tifton Vet Labs - Revenue"]
[null,113,"State Funds",null,null,{"$f":"D314+E314","v":0}]
[null,{"$f":"+B314+1","v":114},"Indirect Cost Recoveries",null,null,0]
[null,{"$f":"+B315+1","v":115},"Departmental Sales & Services",null,null,0]
[null,"116a","Sponsored Funds - Federal",null,null,0]
[null,"116b","Sponsored Funds - State",null,null,0]
[null,"116c","Sponsored Funds - Local",null,null,0]
[null,"116d","Sponsored Funds - Private",null,null,0]
[null,"116e","Sponsored Funds - Federal - Federal Stimulus"]
[null,"117a","Other Revenue - Rents and Royalties",null,null,0]
[null,"117b","Other Revenue - Other fees",null,null,0]
[null,"117c","Other Revenue - Interest and other investment income",null,null,0]
[null,"117d","Other Revenue - Gifts, donations and contributions",null,null,0]
[null,"117e","Other Revenue - Other",null,null,0]
[null,118,"Total UGA Athens Tifton Vet Labs Revenue",{"$f":"SUM(D313:D326)","v":0},{"$f":"SUM(E313:E326)","v":0},{"$f":"SUM(F313:F326)","v":0}]
[]
[null,null,"UGA - Athens Tifton Vet Labs - Expenditures"]
[null,119,"State Funds",null,null,{"$f":"D330+E330","v":0}]
[null,{"$f":"+B330+1","v":120},"Indirect Cost Recoveries",null,null,{"$f":"D331+E331","v":0}]
[null,{"$f":"+B331+1","v":121},"Departmental Sales & Services",null,null,{"$f":"D332+E332","v":0}]
[null,{"$f":"+B332+1","v":122},"Sponsored Funds",null,null,{"$f":"D333+E333","v":0}]
[null,"122a","Sponsored Funds - Federal - Federal Stimulus"]
[null,{"$f":"+B333+1","v":123},"Other",null,null,{"$f":"D335+E335","v":0}]
[null,{"$f":"+B335+1","v":124},"Total UGA Athens Tifton Vet Labs Expenditures",{"$f":"SUM(D329:D335)","v":0},{"$f":"SUM(E329:E335)","v":0},{"$f":"SUM(F329:F335)","v":0}]
[]
[null,null,"GT - Center for Assistive Technology & Environmental Access - Revenues",null,null,null,null,"Georgia Tech Only"]
[null,125,"State Funds",null,null,{"$f":"D339+E339","v":0}]
[null,{"$f":"+B339+1","v":126},"Indirect Cost Recoveries",null,null,0]
[null,{"$f":"+B340+1","v":127},"Departmental Sales & Services",null,null,0]
[null,"128a","Sponsored Funds - Federal",null,null,0]
[null,"128b","Sponsored Funds - State",null,null,0]
[null,"128c","Sponsored Funds - Local",null,null,0]
[null,"128d","Sponsored Funds - Private",null,null,0]
[null,"128e","Sponsored Funds - Federal - Federal Stimulus"]
[null,"129a","Other Revenue - Rents and Royalties",null,null,0]
[null,"129b","Other Revenue - Other fees",null,null,0]
[null,"129c","Other Revenue - Interest and other investment income",null,null,0]
[null,"129d","Other Revenue - Gifts, donations and contributions",null,null,0]
[null,"129e","Other Revenue - Other",null,null,0]
[null,130,"Total GT Center for Assistive Technology & Environmental Access Revenue",{"$f":"SUM(D338:D351)","v":0},{"$f":"SUM(E338:E351)","v":0},{"$f":"SUM(F338:F351)","v":0}]
[]
[null,null,"GT - Center for Assistive Tech & Environmental Access - Expenditures"]
[null,131,"State Funds",null,null,{"$f":"D355+E355","v":0}]
[null,{"$f":"+B355+1","v":132},"Indirect Cost Recoveries",null,null,{"$f":"D356+E356","v":0}]
[null,{"$f":"+B356+1","v":133},"Departmental Sales & Services",null,null,{"$f":"D357+E357","v":0}]
[null,{"$f":"+B357+1","v":134},"Sponsored Funds",null,null,{"$f":"D358+E358","v":0}]
[null,"134a","Sponsored Funds - Federal - Federal Stimulus"]
[null,{"$f":"+B358+1","v":135},"Other",null,null,{"$f":"D360+E360","v":0}]
[null,{"$f":"+B360+1","v":136},"Total GT Center for Assistive Tech & Environmental Access Expenditures",{"$f":"SUM(D354:D360)","v":0},{"$f":"SUM(E354:E360)","v":0},{"$f":"SUM(F354:F360)","v":0}]
[]
[null,null,"UGA - Cooperative Extension Service - Revenue",null,null,null,null,"UGA Only"]
[null,137,"State Funds",null,null,{"$f":"D364+E364","v":0}]
[null,{"$f":"+B364+1","v":138},"Indirect Cost Recoveries",null,null,0]
[null,{"$f":"+B365+1","v":139},"Departmental Sales & Services",null,null,0]
[null,"140a","Sponsored Funds - Federal",null,null,0]
[null,"140b","Sponsored Funds - State",null,null,0]
[null,"140c","Sponsored Funds - Local",null,null,0]
[null,"140d","Sponsored Funds - Private",null,null,0]
[null,"140e","Sponsored Funds - Federal - Federal Stimulus"]
[null,"141a","Other Revenue - Rents and Royalties",null,null,0]
[null,"141b","Other Revenue - Other fees",null,null,0]
[null,"141c","Other Revenue - Interest and other investment income",null,null,0]
[null,"141d","Other Revenue - Gifts, donations and contributions",null,null,0]
[null,"141e","Other Revenue - Other",null,null,0]
[null,142,"Total UGA Cooperative Extension Service Revenue",{"$f":"SUM(D363:D376)","v":0},{"$f":"SUM(E363:E376)","v":0},{"$f":"SUM(F363:F376)","v":0}]
[]
[null,null,"UGA - Cooperative Extension Service - Expenditures"]
[null,143,"State Funds",null,null,{"$f":"D380+E380","v":0}]
[null,{"$f":"+B380+1","v":144},"Indirect Cost Recoveries",null,null,{"$f":"D381+E381","v":0}]
[null,{"$f":"+B381+1","v":145},"Departmental Sales & Services",null,null,{"$f":"D382+E382","v":0}]
[null,{"$f":"+B382+1","v":146},"Sponsored Funds",null,null,{"$f":"D383+E383","v":0}]
[null,"146a","Sponsored Funds - Federal - Federal Stimulus"]
[null,{"$f":"+B383+1","v":147},"Other",null,null,{"$f":"D385+E385","v":0}]
[null,{"$f":"+B385+1","v":148},"Total UGA Cooperative Extension Service Expenditures",{"$f":"SUM(D379:D385)","v":0},{"$f":"SUM(E379:E385)","v":0},{"$f":"SUM(F379:F385)","v":0}]
[]
[null,null,"UGA - Forestry Cooperative Extension - Revenue"]
[null,149,"State Funds",null,null,{"$f":"D389+E389","v":0}]
[null,{"$f":"+B389+1","v":150},"Indirect Cost Recoveries",null,null,0]
[null,{"$f":"+B390+1","v":151},"Departmental Sales & Services",null,null,0]
[null,"152a","Sponsored Funds - Federal",null,null,0]
[null,"152b","Sponsored Funds - State",null,null,0]
[null,"152c","Sponsored Funds - Local",null,null,0]
[null,"152d","Sponsored Funds - Private",null,null,0]
[null,"152e","Sponsored Funds - Federal - Federal Stimulus"]
[null,"153a","Other Revenue - Rents and Royalties",null,null,0]
[null,"153b","Other Revenue - Other fees",null,null,0]
[null,"153c","Other Revenue - Interest and other investment income",null,null,0]
[null,"153d","Other Revenue - Gifts, donations and contributions",null,null,0]
[null,"153e","Other Revenue - Other",null,null,0]
[null,154,"Total UGA Forestry Cooperative Extension Revenue",{"$f":"SUM(D388:D401)","v":0},{"$f":"SUM(E388:E401)","v":0},{"$f":"SUM(F388:F401)","v":0}]
[]
[null,null,"UGA - Forestry Cooperative Extension - Expenditures"]
[null,155,"State Funds",null,null,{"$f":"D405+E405","v":0}]
[null,{"$f":"+B405+1","v":156},"Indirect Cost Recoveries",null,null,{"$f":"D406+E406","v":0}]
[null,{"$f":"+B406+1","v":157},"Departmental Sales & Services",null,null,{"$f":"D407+E407","v":0}]
[null,{"$f":"+B407+1","v":158},"Sponsored Funds",null,null,{"$f":"D408+E408","v":0}]
[null,"158a","Sponsored Funds - Federal - Federal Stimulus"]
[null,{"$f":"+B408+1","v":159},"Other",null,null,{"$f":"D410+E410","v":0}]
[null,{"$f":"+B410+1","v":160},"Total UGA Forestry Cooperative Extension Expenditures",{"$f":"SUM(D404:D410)","v":0},{"$f":"SUM(E404:E410)","v":0},{"$f":"SUM(F404:F410)","v":0}]
[]
[null,null,"GRU - Georgia Radiation Therapy Center - Revenue",null,null,null,null,"GRU Only"]
[null,161,"State Funds",null,null,{"$f":"D414+E414","v":0}]
[null,{"$f":"+B414+1","v":162},"Indirect Cost Recoveries",null,null,0]
[null,{"$f":"+B415+1","v":163},"Departmental Sales & Services",null,null,0]
[null,"164a","Sponsored Funds - Federal",null,null,0]
[null,"164b","Sponsored Funds - State",null,null,0]
[null,"164c","Sponsored Funds - Local",null,null,0]
[null,"164d","Sponsored Funds - Private",null,null,0]
[null,"164e","Sponsored Funds - Federal - Federal Stimulus"]
[null,"165a","Other Revenue - Rents and Royalties",null,null,0]
[null,"165b","Other Revenue - Other fees",null,null,0]
[null,"165c","Other Revenue - Interest and other investment income",null,null,0]
[null,"165d","Other Revenue - Gifts, donations and contributions",null,null,0]
[null,"165e","Other Revenue - Other",null,null,0]
[null,166,"Total GRU Georgia Radiation Therapy Center Revenue",{"$f":"SUM(D413:D426)","v":0},{"$f":"SUM(E413:E426)","v":0},{"$f":"SUM(F413:F426)","v":0}]
[]
[null,null,"GRU - Georgia Radiation Therapy Center - Expenditures"]
[null,167,"State Funds",null,null,{"$f":"D430+E430","v":0}]
[null,{"$f":"+B430+1","v":168},"Indirect Cost Recoveries",null,null,{"$f":"D431+E431","v":0}]
[null,{"$f":"+B431+1","v":169},"Departmental Sales & Services",null,null,{"$f":"D432+E432","v":0}]
[null,{"$f":"+B432+1","v":170},"Sponsored Funds",null,null,{"$f":"D433+E433","v":0}]
[null,"170a","Sponsored Funds - Federal - Federal Stimulus"]
[null,{"$f":"+B433+1","v":171},"Other",null,null,{"$f":"D435+E435","v":0}]
[null,{"$f":"+B435+1","v":172},"Total GRU Georgia Radiation Therapy Center Expenditures",{"$f":"SUM(D429:D435)","v":0},{"$f":"SUM(E429:E435)","v":0},{"$f":"SUM(F429:F435)","v":0}]
[]
[null,null,"GT - Georgia Tech Research Institute- Revenue",null,null,null,null,"Georgia Tech Only"]
[null,173,"State Funds",null,null,{"$f":"D439+E439","v":0}]
[null,{"$f":"+B439+1","v":174},"Indirect Cost Recoveries",null,null,0]
[null,{"$f":"+B440+1","v":175},"Departmental Sales & Services",null,null,0]
[null,"176a","Sponsored Funds - Federal",null,null,0]
[null,"176b","Sponsored Funds - State",null,null,0]
[null,"176c","Sponsored Funds - Local",null,null,0]
[null,"176d","Sponsored Funds - Private",null,null,0]
[null,"176e","Sponsored Funds - Federal - Federal Stimulus"]
[null,"177a","Other Revenue - Rents and Royalties",null,null,0]
[null,"177b","Other Revenue - Other fees",null,null,0]
[null,"177c","Other Revenue - Interest and other investment income",null,null,0]
[null,"177d","Other Revenue - Gifts, donations and contributions",null,null,0]
[null,"177e","Other Revenue - Other",null,null,0]
[null,178,"Total GT Georgia Tech Research Institute Revenue",{"$f":"SUM(D438:D451)","v":0},{"$f":"SUM(E438:E451)","v":0},{"$f":"SUM(F438:F451)","v":0}]
[]
[null,null,"GT - Georgia Tech Research Institute- Expenditures"]
[null,179,"State Funds",null,null,{"$f":"D455+E455","v":0}]
[null,{"$f":"+B455+1","v":180},"Indirect Cost Recoveries",null,null,{"$f":"D456+E456","v":0}]
[null,{"$f":"+B456+1","v":181},"Departmental Sales & Services",null,null,{"$f":"D457+E457","v":0}]
[null,{"$f":"+B457+1","v":182},"Sponsored Funds",null,null,{"$f":"D458+E458","v":0}]
[null,"182a","Sponsored Funds - Federal - Federal Stimulus"]
[null,{"$f":"+B458+1","v":183},"Other",null,null,{"$f":"D460+E460","v":0}]
[null,{"$f":"+B460+1","v":184},"Total GT Georgia Tech Research Institute Expenditures",{"$f":"SUM(D454:D460)","v":0},{"$f":"SUM(E454:E460)","v":0},{"$f":"SUM(F454:F460)","v":0}]
[]
[null,null,"UGA - Marine Institute- Revenue",null,null,null,null,"UGA Only"]
[null,185,"State Funds",null,null,{"$f":"D464+E464","v":0}]
[null,{"$f":"+B464+1","v":186},"Indirect Cost Recoveries",null,null,0]
[null,{"$f":"+B465+1","v":187},"Departmental Sales & Services",null,null,0]
[null,"188a","Sponsored Funds - Federal",null,null,0]
[null,"188b","Sponsored Funds - State",null,null,0]
[null,"188c","Sponsored Funds - Local",null,null,0]
[null,"188d","Sponsored Funds - Private",null,null,0]
[null,"188e","Sponsored Funds - Federal - Federal Stimulus"]
[null,"189a","Other Revenue - Rents and Royalties",null,null,0]
[null,"189b","Other Revenue - Other fees",null,null,0]
[null,"189c","Other Revenue - Interest and other investment income",null,null,0]
[null,"189d","Other Revenue - Gifts, donations and contributions",null,null,0]
[null,"189e","Other Revenue - Other",null,null,0]
[null,190,"Total UGA Marine Institute Revenue",{"$f":"SUM(D463:D476)","v":0},{"$f":"SUM(E463:E476)","v":0},{"$f":"SUM(F463:F476)","v":0}]
[]
[null,null,"UGA - Marine Institute - Expenditures"]
[null,191,"State Funds",null,null,{"$f":"D480+E480","v":0}]
[null,{"$f":"+B480+1","v":192},"Indirect Cost Recoveries",null,null,{"$f":"D481+E481","v":0}]
[null,{"$f":"+B481+1","v":193},"Departmental Sales & Services",null,null,{"$f":"D482+E482","v":0}]
[null,{"$f":"+B482+1","v":194},"Sponsored Funds",null,null,{"$f":"D483+E483","v":0}]
[null,"194a","Sponsored Funds - Federal - Federal Stimulus"]
[null,{"$f":"+B483+1","v":195},"Other",null,null,{"$f":"D485+E485","v":0}]
[null,{"$f":"+B485+1","v":196},"Total UGA Marine Institute Expenditures",{"$f":"SUM(D479:D485)","v":0},{"$f":"SUM(E479:E485)","v":0},{"$f":"SUM(F479:F485)","v":0}]
[]
[null,null,"UGA - Marine Resources Extension Center - Revenue"]
[null,197,"State Funds",null,null,{"$f":"D489+E489","v":0}]
[null,{"$f":"+B489+1","v":198},"Indirect Cost Recoveries",null,null,0]
[null,{"$f":"+B490+1","v":199},"Departmental Sales & Services",null,null,0]
[null,"200a","Sponsored Funds - Federal",null,null,0]
[null,"200b","Sponsored Funds - State",null,null,0]
[null,"200c","Sponsored Funds - Local",null,null,0]
[null,"200d","Sponsored Funds - Private",null,null,0]
[null,"200e","Sponsored Funds - Federal - Federal Stimulus"]
[null,"201a","Other Revenue - Rents and Royalties",null,null,0]
[null,"201b","Other Revenue - Other fees",null,null,0]
[null,"201c","Other Revenue - Interest and other investment income",null,null,0]
[null,"201d","Other Revenue - Gifts, donations and contributions",null,null,0]
[null,"201e","Other Revenue - Other",null,null,0]
[null,202,"Total UGA Marine Resources Extension Center Revenue",{"$f":"SUM(D488:D501)","v":0},{"$f":"SUM(E488:E501)","v":0},{"$f":"SUM(F488:F501)","v":0}]
[]
[null,null,"UGA - Marine Resources Extension Center - Expenditures"]
[null,203,"State Funds",null,null,{"$f":"D505+E505","v":0}]
[null,{"$f":"+B505+1","v":204},"Indirect Cost Recoveries",null,null,{"$f":"D506+E506","v":0}]
[null,{"$f":"+B506+1","v":205},"Departmental Sales & Services",null,null,{"$f":"D507+E507","v":0}]
[null,{"$f":"+B507+1","v":206},"Sponsored Funds",null,null,{"$f":"D508+E508","v":0}]
[null,"206a","Sponsored Funds - Federal - Federal Stimulus"]
[null,{"$f":"+B508+1","v":207},"Other",null,null,{"$f":"D510+E510","v":0}]
[null,{"$f":"+B510+1","v":208},"Total  UGA Marine Resources Extension Center Expenditures",{"$f":"SUM(D504:D510)","v":0},{"$f":"SUM(E504:E510)","v":0},{"$f":"SUM(F504:F510)","v":0}]
[]
[null,null,"GRU Hospitals and Clinics - Revenue",null,null,null,null,"USO Only"]
[null,209,"State Funds",null,null,{"$f":"D514+E514","v":0}]
[null,{"$f":"+B514+1","v":210},"Indirect Cost Recoveries",null,null,0]
[null,{"$f":"+B515+1","v":211},"Departmental Sales & Services",null,null,0]
[null,"212a","Sponsored Funds - Federal",null,null,0]
[null,"212b","Sponsored Funds - State",null,null,0]
[null,"212c","Sponsored Funds - Local",null,null,0]
[null,"212d","Sponsored Funds - Private",null,null,0]
[null,"212e","Sponsored Funds - Federal - Federal Stimulus"]
[null,"213a","Other Revenue - Rents and Royalties",null,null,0]
[null,"213b","Other Revenue - Other fees",null,null,0]
[null,"213c","Other Revenue - Interest and other investment income",null,null,0]
[null,"213d","Other Revenue - Gifts, donations and contributions",null,null,0]
[null,"213e","Other Revenue - Other",null,null,0]
[null,214,"Total GRU Hospitals and Clinics Revenue",{"$f":"SUM(D513:D526)","v":0},{"$f":"SUM(E513:E526)","v":0},{"$f":"SUM(F513:F526)","v":0}]
[]
[null,null,"GRU Hospitals and Clinics - Expenditures"]
[null,215,"State Funds",null,null,{"$f":"D530+E530","v":0}]
[null,{"$f":"+B530+1","v":216},"Indirect Cost Recoveries",null,null,{"$f":"D531+E531","v":0}]
[null,{"$f":"+B531+1","v":217},"Departmental Sales & Services",null,null,{"$f":"D532+E532","v":0}]
[null,{"$f":"+B532+1","v":218},"Sponsored Funds",null,null,{"$f":"D533+E533","v":0}]
[null,"218a","Sponsored Funds - Federal - Federal Stimulus"]
[null,{"$f":"+B533+1","v":219},"Other",null,null,{"$f":"D535+E535","v":0}]
[null,{"$f":"+B535+1","v":220},"Total GRU Hospitals and Clinics Expenditures",{"$f":"SUM(D529:D535)","v":0},{"$f":"SUM(E529:E535)","v":0},{"$f":"SUM(F529:F535)","v":0}]
[]
[null,null,"USO -Public Libraries - Revenue"]
["%,FACCOUNT,TBTA_ACCOUNTS,N\"ALL REV ACCTS\",FFUND_CODE,V11930,V11940",221,"State Funds",0,0,{"$f":"D539+E539","v":0},null,"Fund 11930, 11940 Acct 4xxxxx"]
[null,{"$f":"+B539+1","v":222},"Indirect Cost Recoveries",null,null,0]
[null,{"$f":"+B540+1","v":223},"Departmental Sales & Services",null,null,0]
[null,"224a","Restricted - Federal",null,null,0]
[null,"224b","Restricted - State",null,null,0]
[null,"224c","Restricted - Local",null,null,0]
[null,"224d","Restricted - Private",null,null,0]
[null,"224e","Restricted - Federal - Federal Stimulus"]
[null,"225a","Other Revenue - Rents and Royalties",null,null,0]
[null,"225b","Other Revenue - Other fees",null,null,0]
[null,"225c","Other Revenue - Interest and other investment income",null,null,0]
[null,"225d","Other Revenue - Gifts, donations and contributions",null,null,0]
[null,"225e","Other Revenue - Other",null,null,0]
[null,null,null,null,null,0]
[null,226,"Total USO Public Libraries Revenue",{"$f":"SUM(D538:D552)","v":0},{"$f":"SUM(E538:E552)","v":0},{"$f":"SUM(F538:F552)","v":0}]
[]
[null,null,"USO - Public Libraries - Expenditures"]
["%,FACCOUNT,TBTA_ACCOUNTS,NPER_SERVS,NNON_PER_SERVS,FFUND_CODE,V11930,V11940",227,"State Funds",0,0,{"$f":"D556+E556","v":0},null,"Fund 11930, 11940 Acct 5xxxxx - 9xxxxx  ",null,"Acct 5xxxxx - 980xxx, 999950, 982xxx - 991500"]
[null,{"$f":"+B556+1","v":228},"Indirect Cost Recoveries",null,null,{"$f":"D557+E557","v":0}]
[null,{"$f":"+B557+1","v":229},"Departmental Sales & Services",null,null,{"$f":"D558+E558","v":0}]
[null,{"$f":"+B558+1","v":230},"Restricted",null,null,{"$f":"D559+E559","v":0}]
[null,"230a","Restricted - Federal - Federal Stimulus"]
[null,{"$f":"+B559+1","v":231},"Other",null,null,{"$f":"D561+E561","v":0}]
[null,{"$f":"+B561+1","v":232},"Total USO Public Libraries Expenditures",{"$f":"SUM(D555:D561)","v":0},{"$f":"SUM(E555:E561)","v":0},{"$f":"SUM(F555:F561)","v":0}]
[]
[null,null,"USO - Regents Central Office - Revenue"]
["%,FACCOUNT,TBTA_ACCOUNTS,N\"ALL REV ACCTS\",FFUND_CODE,V11920",233,"State Funds",0,0,{"$f":"D565+E565","v":0},null,"Fund 11920 Acct 4xxxxx"]
[null,{"$f":"+B565+1","v":234},"Indirect Cost Recoveries",null,null,0]
[null,{"$f":"+B566+1","v":235},"Departmental Sales & Services",null,null,0]
[null,"236a","Restricted - Federal",null,null,0]
[null,"236b","Restricted - State",null,null,0]
[null,"236c","Restricted - Local",null,null,0]
["%,FACCOUNT,TBTA_ACCOUNTS,N\"ALL REV ACCTS\",FFUND_CODE,V21920,FCLASS_FLD,TBTA_CLASS,NSPONSORED_PRIVATE","236d","Restricted - Private",0,0,0,null,"Fund 21920 -  Acct 424xxx, 4724xx, 4914xx, and all other 4xxxxx accts related to Private Projects (ie. Interest Income)"]
[null,"236e","Restricted - Federal - Federal Stimulus"]
["%,FACCOUNT,TBTA_ACCOUNTS,NPER_SERVS,FFUND_CODE,V21920,FCLASS_FLD,TBTA_CLASS,NNON_STIMULUS_SPON","236f","Restricted -Personal Services ",0,0,0,null,"Fund 21920 -  Acct 5xxxxx, Exclude Class FSxxx"]
["%,FACCOUNT,TBTA_ACCOUNTS,NNON_PER_SERVS,FFUND_CODE,V21920,FCLASS_FLD,TBTA_CLASS,NNON_STIMULUS_SPON","236h","Restricted-Operating Expenses",0,0,0,null,"Fund 21920 -  Acct 6xxxxx-9xxxxx, Exclude Class FSxxx"]
["%,FACCOUNT,TBTA_ACCOUNTS,NPER_SERVS,FFUND_CODE,V21920,FCLASS_FLD,TBTA_CLASS,NSPONSORED_FED_STIM","236i","Restricted - Federal Stimulus - Personal Services",0,0,null,null,"Fund 21920 -  Acct 5xxxxx, Class FSxxx"]
["%,FACCOUNT,TBTA_ACCOUNTS,NNON_PER_SERVS,FFUND_CODE,V21920,FCLASS_FLD,TBTA_CLASS,NSPONSORED_FED_STIM","236j","Restricted - Federal Stimulus - Operating Expenses",0,0,null,null,"Fund 21920 -  Acct 6xxxxx-9xxxxx, Class FSxxx"]
[null,"237a","Other Revenue - Rents and Royalties",null,null,0]
[null,"237b","Other Revenue - Other fees",null,null,0]
[null,"237c","Other Revenue - Interest and other investment income",null,null,0]
[null,"237d","Other Revenue - Gifts, donations and contributions",null,null,0]
[null,"237e","Other Revenue - Other",null,null,0]
[null,238,"Total USO Regents Central Office Revenue",{"$f":"SUM(D564:D581)","v":0},{"$f":"SUM(E564:E581)","v":0},{"$f":"SUM(F564:F581)","v":0}]
[]
[null,null,"USO - Regents Central Office - Expenditures"]
["%,FACCOUNT,TBTA_ACCOUNTS,NPER_SERVS,NNON_PER_SERVS,FFUND_CODE,V11920",239,"State Funds",0,0,{"$f":"D585+E585","v":0},null,"Fund 11920 Acct 5xxxxx - 9xxxxx",null,"Acct 5xxxxx - 980xxx, 999950, 982xxx - 991500"]
[null,{"$f":"+B585+1","v":240},"Indirect Cost Recoveries",null,null,0]
[null,{"$f":"+B586+1","v":241},"Departmental Sales & Services",null,null,0]
[null,{"$f":"+B587+1","v":242},"Restricted",null,null,0]
[null,"242a","Restricted - Federal - Federal Stimulus",null,null,0]
[null,{"$f":"+B588+1","v":243},"Other",null,null,0]
[null,{"$f":"+B590+1","v":244},"Total USO Regents Central Office Expenditures",{"$f":"SUM(D584:D590)","v":0},{"$f":"SUM(E584:E590)","v":0},{"$f":"SUM(F584:F590)","v":0}]
[]
[null,null,"Skidaway Institute of Oceanography - Revenue",null,null,null,null,"Skidaway Only"]
["%,FACCOUNT,TBTA_ACCOUNTS,N\"ALL REV ACCTS\",FFUND_CODE,V11810",245,"State Funds",0,0,{"$f":"D594+E594","v":0},null,"Fund 11810 Acct 4xxxxx"]
[null,{"$f":"+B594+1","v":246},"Indirect Cost Recoveries",null,null,0]
[null,{"$f":"+B595+1","v":247},"Departmental Sales & Services",null,null,0]
["%,FACCOUNT,TBTA_ACCOUNTS,N\"SPON FEDERAL REV\",FFUND_CODE,V21810,FCLASS_FLD,TBTA_CLASS,NSPONSORED_FEDERAL","248a","Restricted - Federal",0,0,0,null,"Fund 21810 -  Acct 421xxx, 425998, 4721xx, 4911xx, and all other 4xxxxx accts related to Federal Projects (ie Interest Income); Exclude Class FSxxx"]
["%,FACCOUNT,TBTA_ACCOUNTS,N\"ALL REV ACCTS\",FFUND_CODE,V21810,FCLASS_FLD,TBTA_CLASS,NSPONSORED_STATE","248b","Restricted - State",0,0,0,null,"Fund 21810 -  Acct 422xxx, 4722xx, 4912xx, and all other 4xxxxx accts related to State Projects (ie. Interest Income)"]
["%,FACCOUNT,TBTA_ACCOUNTS,N\"ALL REV ACCTS\",FFUND_CODE,V21810,FCLASS_FLD,TBTA_CLASS,NSPONSORED_LOCAL","248c","Restricted - Local",0,0,0,null,"Fund 21810 -  Acct 423xxx, 4723xx, 4913xx, and all other 4xxxxx accts related to Local Projects (ie. Interest Income)"]
["%,FACCOUNT,TBTA_ACCOUNTS,N\"ALL REV ACCTS\",FFUND_CODE,V21810,FCLASS_FLD,TBTA_CLASS,NSPONSORED_PRIVATE","248d","Restricted - Private",0,0,0,null,"Fund 21810 -  Acct 424xxx, 4724xx, 4914xx, and all other 4xxxxx accts related to Private Projects (ie. Interest Income)"]
["%,FACCOUNT,TBTA_ACCOUNTS,N\"ALL REV ACCTS\",FFUND_CODE,V21810,FCLASS_FLD,TBTA_CLASS,NSPONSORED_FED_STIM","248e","Restricted - Federal - Federal Stimulus",0,0,null,null,"Fund 21810 Class FSxxx"]
["%,FACCOUNT,TBTA_ACCOUNTS,N\"ALL REV ACCTS\",FFUND_CODE,V21810,FCLASS_FLD,TBTA_CLASS,NSPONSORED_ENDOWMENTS","248f","Restricted - Endowment",0,0,0,null,"Fund 21810 -  Acct 424xxx, 4724xx, 4914xx, and all other 4xxxxx accts related to Private Projects (ie. Interest Income) - Class 65000"]
[null,"249a","Other Revenue - Rents and Royalties",null,null,0]
[null,"249b","Other Revenue - Other fees",null,null,0]
[null,"249c","Other Revenue - Interest and other investment income",null,null,0]
[null,"249d","Other Revenue - Gifts, donations and contributions",null,null,0]
[null,"249e","Other Revenue - Other",null,null,0]
[null,250,"Total Skidaway Institute of Oceanography Revenue",{"$f":"SUM(D593:D607)","v":0},{"$f":"SUM(E593:E607)","v":0},{"$f":"SUM(F593:F607)","v":0}]
[]
[null,null,"Skidaway Institute of Oceanography - Expenditures"]
["%,FACCOUNT,TBTA_ACCOUNTS,NPER_SERVS,NNON_PER_SERVS,FFUND_CODE,V11810",251,"State Funds",0,0,{"$f":"D611+E611","v":0},null,"Fund 11810 Acct 5xxxxx - 9xxxxx",null,"Acct 5xxxxx - 980xxx, 999950, 982xxx - 991500"]
[null,{"$f":"+B611+1","v":252},"Indirect Cost Recoveries",null,null,{"$f":"D612+E612","v":0}]
[null,{"$f":"+B612+1","v":253},"Departmental Sales & Services",null,null,{"$f":"D613+E613","v":0}]
[null,{"$f":"+B613+1","v":254},"Restricted",null,null,{"$f":"D614+E614","v":0}]
[null,"254a","Restricted - Federal - Federal Stimulus"]
["%,FACCOUNT,TBTA_ACCOUNTS,NPER_SERVS,FFUND_CODE,V21810,FCLASS_FLD,TBTA_CLASS,NNON_STIMULUS_SPON","254b","Restricted -Personal Services ",0,0,{"$f":"D616+E616","v":0},null,"Fund 21810 -  Acct 5xxxxx, Exclude Class FSxxx"]
["%,FACCOUNT,TBTA_ACCOUNTS,NNON_PER_SERVS,FFUND_CODE,V21810,FCLASS_FLD,TBTA_CLASS,NNON_STIMULUS_SPON","254c","Restricted-Operating Expenses",0,0,{"$f":"D617+E617","v":0},null,"Fund 21810 -  Acct 6xxxxx-9xxxxx, Exclude Class FSxxx"]
["%,FACCOUNT,TBTA_ACCOUNTS,NPER_SERVS,FFUND_CODE,V21810,FCLASS_FLD,TBTA_CLASS,NSPONSORED_FED_STIM","254d","Restricted - Federal Stimulus - Personal Services",0,0,null,null,"Fund 21810 -  Acct 5xxxxx, Class FSxxx"]
["%,FACCOUNT,TBTA_ACCOUNTS,NNON_PER_SERVS,FFUND_CODE,V21810,FCLASS_FLD,TBTA_CLASS,NSPONSORED_FED_STIM","254e","Restricted - Federal Stimulus - Operating Expenses",0,0,null,null,"Fund 21810 -  Acct 6xxxxx-9xxxxx, Class FSxxx"]
[null,{"$f":"+B614+1","v":255},"Other",null,null,{"$f":"D620+E620","v":0}]
[null,{"$f":"+B620+1","v":256},"Total Skidaway Institute of Oceanography Expenditures",{"$f":"SUM(D610:D620)","v":0},{"$f":"SUM(E610:E620)","v":0},{"$f":"SUM(F610:F620)","v":0}]
[]
[null,null,"UGA - Veterinary Medicine Experiment Station - Revenue",null,null,null,null,"UGA Only"]
[null,257,"State Funds",null,null,{"$f":"D624+E624","v":0}]
[null,{"$f":"+B624+1","v":258},"Indirect Cost Recoveries",null,null,0]
[null,{"$f":"+B625+1","v":259},"Departmental Sales & Services",null,null,0]
[null,"260a","Sponsored Funds - Federal",null,null,0]
[null,"260b","Sponsored Funds - State",null,null,0]
[null,"260c","Sponsored Funds - Local",null,null,0]
[null,"260d","Sponsored Funds - Private",null,null,0]
[null,"260e","Sponsored Funds - Federal - Federal Stimulus"]
[null,"261a","Other Revenue - Rents and Royalties",null,null,0]
[null,"261b","Other Revenue - Other fees",null,null,0]
[null,"261c","Other Revenue - Interest and other investment income",null,null,0]
[null,"261d","Other Revenue - Gifts, donations and contributions",null,null,0]
[null,"261e","Other Revenue - Other",null,null,0]
[null,262,"Total UGA Veterinary Medicine Experiment Station Revenue",{"$f":"SUM(D623:D636)","v":0},{"$f":"SUM(E623:E636)","v":0},{"$f":"SUM(F623:F636)","v":0}]
[]
[null,null,"UGA - Veterinary Medicine Experiment Station - Expenditures"]
[null,263,"State Funds",null,null,{"$f":"D640+E640","v":0}]
[null,{"$f":"+B640+1","v":264},"Indirect Cost Recoveries",null,null,{"$f":"D641+E641","v":0}]
[null,{"$f":"+B641+1","v":265},"Departmental Sales & Services",null,null,{"$f":"D642+E642","v":0}]
[null,{"$f":"+B642+1","v":266},"Sponsored Funds",null,null,{"$f":"D643+E643","v":0}]
[null,"266a","Sponsored Funds - Federal - Federal Stimulus"]
[null,{"$f":"+B643+1","v":267},"Other",null,null,{"$f":"D645+E645","v":0}]
[null,{"$f":"+B645+1","v":268},"Total UGA Veterinary Medicine Experiment Station Expenditures",{"$f":"SUM(D639:D645)","v":0},{"$f":"SUM(E639:E645)","v":0},{"$f":"SUM(F639:F645)","v":0}]
[]
[null,null,"UGA - Veterinary Medicine Teaching Hospital - Revenue"]
[null,269,"State Funds",null,null,{"$f":"D649+E649","v":0}]
[null,{"$f":"+B649+1","v":270},"Indirect Cost Recoveries",null,null,0]
[null,{"$f":"+B650+1","v":271},"Departmental Sales & Services",null,null,0]
[null,"272a","Sponsored Funds - Federal",null,null,0]
[null,"272b","Sponsored Funds - State",null,null,0]
[null,"272c","Sponsored Funds - Local",null,null,0]
[null,"272d","Sponsored Funds - Private",null,null,0]
[null,"272e","Sponsored Funds - Federal - Federal Stimulus"]
[null,"273a","Other Revenue - Rents and Royalties",null,null,0]
[null,"273b","Other Revenue - Other fees",null,null,0]
[null,"273c","Other Revenue - Interest and other investment income",null,null,0]
[null,"273d","Other Revenue - Gifts, donations and contributions",null,null,0]
[null,"273e","Other Revenue - Other",null,null,0]
[null,274,"Total UGA Veterinary Medicine Teaching Hospital Revenue",{"$f":"SUM(D648:D661)","v":0},{"$f":"SUM(E648:E661)","v":0},{"$f":"SUM(F648:F661)","v":0}]
[]
[null,null,"UGA - Veterinary Medicine Teaching Hospital - Expenditures"]
[null,275,"State Funds",null,null,{"$f":"D665+E665","v":0}]
[null,{"$f":"+B665+1","v":276},"Indirect Cost Recoveries",null,null,{"$f":"D666+E666","v":0}]
[null,{"$f":"+B666+1","v":277},"Departmental Sales & Services",null,null,{"$f":"D667+E667","v":0}]
[null,{"$f":"+B667+1","v":278},"Sponsored Funds",null,null,{"$f":"D668+E668","v":0}]
[null,"278a","Sponsored Funds - Federal - Federal Stimulus"]
[null,{"$f":"+B668+1","v":279},"Other",null,null,{"$f":"D670+E670","v":0}]
[null,{"$f":"+B670+1","v":280},"Total UGA Veterinary Medicine Teaching Hospital Expenditures",{"$f":"SUM(D664:D670)","v":0},{"$f":"SUM(E664:E670)","v":0},{"$f":"SUM(F664:F670)","v":0}]
[]
[null,null,"USO - Pass Through Payments",null,null,null,null,"USO Only"]
[null,281,"Georgia Military College - State Funds - Revenues",null,null,{"$f":"D674+E674","v":0}]
[null,{"$f":"+B674+1","v":282},"Georgia Military College - State Funds - Expenditures",null,null,{"$f":"D675+E675","v":0}]
[]
[null,283,"Georgia Public Telecommunications - State Funds - Revenues",null,null,{"$f":"D677+E677","v":0}]
[null,{"$f":"+B677+1","v":284},"Georgia Public Telecommunications - State Funds - Expenditures",null,null,{"$f":"D678+E678","v":0}]
[]
[null,338,"Payments to Georgia Cancer Coalition - Tobacco Revenue (Georgia State University)",null,null,{"$f":"SUM(D680+E680)","v":0}]
[null,339,"Payments to Georgia Cancer Coalition - Tobacco Expenditures",null,null,{"$f":"SUM(D681+E681)","v":0}]
[]
[null,340,"Georgia Eminent Scholar Endowment Trust Fund - State funds - Revenue (Georgia College and State University)",null,null,{"$f":"SUM(D683+E683)","v":0}]
[null,341,"Georgia Eminent Scholar Endowment Trust Fund - State funds - Expenditures",null,null,{"$f":"SUM(D684+E684)","v":0}]
[]
[null,"SUMMARY OF REVENUES AND EXPENDITURES - ALL PROGRAMS"]
[null,285,"Total State Funds"]
[null,"285a","Total Tuition"]
[null,"285b","Total Federal Stimulus Funds (ARRA)"]
[null,{"$f":"+B687+1","v":286},"Total Tobacco Funds"]
[null,{"$f":"+B690+1","v":287},"Total Technology Fee"]
[null,{"$f":"+B691+1","v":288},"Total Indirect Cost Recoveries"]
[null,{"$f":"+B692+1","v":289},"Total DS&S"]
[null,"290a","Total Sponsored Funds - federal"]
[null,"290b","Total Sponsored Funds - state"]
[null,"290c","Total Sponsored Funds - Local"]
[null,"290d","Total Sponsored Funds - Private"]
[null,"291a","Total Capital Outlay (Interest income)"]
[null,"291b","Total Capital Outlay (all other non-state funds)"]
[null,"292a","Other Revenue - Fines and forfeits"]
[null,"292b","Other Revenue - Rents and Royalties"]
[null,"292c","Other Revenue - Other fees"]
[null,"292d","Other Revenue - Interest and other investment income"]
[null,"292e","Other Revenue - Gifts, donations and contributions"]
[null,"292f","Other Revenue - Miscellaneous"]
[null,293,"TOTAL REVENUES"]
[]
[null,{"$f":"+B706+1","v":294},"Total General Funds Expenditures","exclude line 94 and 201"]
[null,"294a","Total Federal Stimulus (ARRA) Expenditures"]
[null,{"$f":"+B708+1","v":295},"Total Tobacco Funds"]
[null,{"$f":"+B710+1","v":296},"Total Technology Fee Expenditures"]
[null,297,"Total Indirect Cost Recoveries Expenditures"]
[null,298,"Total DS&S Expenditures"]
[null,299,"Total Sponsored Expenditures"]
[null,300,"Total Capital Outlay"]
[null,301,"TOTAL EXPENDITURES"]
[null,302,"Excess of Funds Available over Expenditures",{"$f":"D138+D168+D173+D178+D183+D188+D203+D211+D227+D236+D252+D261+D277+D286+D302+D311+D327+D336+D352+D361+D377+D386+D402+D411+D427+D436+D452+D461+D477+D486+D502+D511+D527+D536+D553+D562+D582+D591+D608+D621+D637+D646+D662+D671+D673+D674+D675+D677+D678+D680+D681+D683+D684","v":-1618704.2210000157},{"$f":"E138+E168+E173+E178+E183+E188+E203+E211+E227+E236+E252+E261+E277+E286+E302+E311+E327+E336+E352+E361+E377+E386+E402+E411+E427+E436+E452+E461+E477+E486+E502+E511+E527+E536+E553+E562+E582+E591+E608+E621+E637+E646+E662+E671+E673+E674+E675+E677+E678+E680+E681+E683+E684","v":517921.25},{"$f":"D717+E717","v":-1100782.9710000157}]
[]
[null,303,{"$f":"\"Fund Balance July 1, \" &  (TEXT(ASD,\"YYYY\") - 1)","v":"Fund Balance July 1, 2015"}]
[null,null,"Reserved"]
[null,304,"     Capital Outlay",null,null,{"$f":"SUM(D721+E721)","v":0},null,"Institution Specific Analysis"]
["%,FACCOUNT,TBTA_ACCOUNTS,NBTA_NET_ASSETS,N\"RESERVE INVENTORY\",FFUND_CODE,V14000",305,"     Departmental Sales and Services",-5235164.42,0,{"$f":"SUM(D722+E722)","v":-5235164.42},null,"Fund 14000 -  Acct 3xxxxx (excluding Acct 381xxx)",null,"Acct 300xxx-321xxx, 322xxx, 323xxx - 379xxx"]
["%,FACCOUNT,TBTA_ACCOUNTS,NBTA_NET_ASSETS,NRESERVE INVENTORY,FFUND_CODE,V15000",{"$f":"+B722+1","v":306},"     Indirect Cost Recoveries",-1994005.71,0,-1994005.71,null,"Fund 15000 -  Acct 3xxxxx (excluding Acct 381xxx)",null,"Acct 300xxx-321xxx, 322xxx, 323xxx - 379xxx"]
["%,FACCOUNT,TBTA_ACCOUNTS,NBTA_NET_ASSETS,NRESERVE INVENTORY,FFUND_CODE,V16000",307,"     Technology Fees",-1022097.18,0,-1022097.18,null,"Fund 16000 -  Acct 3xxxxx (excluding Acct 381xxx)",null,"Acct 300xxx-321xxx, 322xxx, 323xxx - 379xxx"]
["%,FACCOUNT,TBTA_ACCOUNTS,NBTA_NET_ASSETS,N\"RESERVE INVENTORY\",FFUND_CODE,TREPORT_FUNDS,NRESTRICTED_SPONSORED",308,"     Restricted Funds",-313041.49,0,-313041.49,null,"Fund 20000 -  Acct 3xxxxx (excluding Acct 381xxx)",null,"Fund 2xxxx - Acct 300xxx-321xxx, 322xxx, 323xxx - 379xxx"]
["%,FACCOUNT,V981250",309,"     Uncollectible Accounts Receivable",0,-3347789.19,-3347789.19,null,"Acct 981250 - Appropriate Fund"]
["%,FACCOUNT,TBTA_ACCOUNTS,N\"RESERVE INVENTORY\",FFUND_CODE,V10000,V50000,V10500",310,"     Inventories",0,0,0,null,"Fund 10000, 10500, & 50000 -  Acct 322xxx"]
["%,FACCOUNT,V981910",311,"     Carry-Over \"Per State Accounting Office\"",0,0,0,null,"Acct 981910 - Appropriate Fund"]
[null,312,"     Early Retirement Program",null,null,0,null,"Institution Specific Analysis"]
["%,FACCOUNT,TBTA_ACCOUNTS,NBTA_NET_ASSETS,FFUND_CODE,V10500,FBUDGET_REF,V2000,V2001,V2002,V2003,V2004,V2005,V2006,V2007,V2008,V2009,V2010,V2011,V2012,V2013,V2014,V2015","312a","    Tuition Carry Forward",-4707981.0080000004,0,-4707981.0080000004,null,"Fund 10500 - Tuition Carry-Forward from FY11 -  Acct 3xxxxx (excluding Acct 381xxx)",null,"Acct 300xxx-321xxx, 322xxx, 323xxx - 379xxx"]
["%,FACCOUNT,TBTA_ACCOUNTS,NBTA_NET_ASSETS,FFUND_CODE,V10000,FBUDGET_REF,V2000,V2001,V2002,V2003,V2004,V2005,V2006,V2007,V2008,V2009,V2010,V2011,V2012,V2013,V2014,V2015","313a","Unreserved (Surplus) - Unrestricted",-8681.9500000000007,0,-8681.9500000000007,null,"Fund 10000  -  Acct 3xxxxx (excluding Acct 322xxx, 381xxx and any Institution Specific Analysis amts)",null,"Acct 300xxx-321xxx, 322xxx, 323xxx - 379xxx"]
[null,"313b","Unreserved (Surplus) - Unrestricted",null,null,{"$f":"D732+E732","v":0},null,"Fund 10500 Not Mapped, requires Institution Analysis"]
["%,FACCOUNT,TBTA_ACCOUNTS,NBTA_NET_ASSETS,FFUND_CODE,V10600,FBUDGET_REF,V2000,V2001,V2002,V2003,V2004,V2005,V2006,V2007,V2008,V2009,V2010,V2011,V2012,V2013,V2014,V2015","313c","Unreserved (Surplus) - Unrestricted",-20262.550999999999,0,-20262.550999999999,null,"Fund 10600  -  Acct 3xxxxx (excluding Acct 322xxx, 381xxx and any Institution Specific Analysis amts)",null,"Acct 300xxx-321xxx, 322xxx, 323xxx - 379xxx"]
["%,FACCOUNT,TBTA_ACCOUNTS,NBTA_NET_ASSETS,FFUND_CODE,V11810,FBUDGET_REF,V2000,V2001,V2002,V2003,V2004,V2005,V2006,V2007,V2008,V2009,V2010,V2011,V2012,V2013,V2014,V2015","313d","Unreserved (Surplus) - Unrestricted",0,0,0,null,"Fund 11810 -  Acct 3xxxxx (excluding Acct 322xxx, 381xxx and any Institution Specific Analysis amts)",null,"Acct 300xxx-321xxx, 322xxx, 323xxx - 379xxx"]
["%,FACCOUNT,TBTA_ACCOUNTS,NBTA_NET_ASSETS,FFUND_CODE,V11920,FBUDGET_REF,V2000,V2001,V2002,V2003,V2004,V2005,V2006,V2007,V2008,V2009,V2010,V2011,V2012,V2013,V2014,V2015","313e","Unreserved (Surplus) - Unrestricted",0,0,0,null,"Fund 11920 -  Acct 3xxxxx (excluding Acct 322xxx, 381xxx and any Institution Specific Analysis amts)",null,"Acct 300xxx-321xxx, 322xxx, 323xxx - 379xxx"]
["%,FACCOUNT,TBTA_ACCOUNTS,NBTA_NET_ASSETS,FFUND_CODE,V11930,FBUDGET_REF,V2000,V2001,V2002,V2003,V2004,V2005,V2006,V2007,V2008,V2009,V2010,V2011,V2012,V2013,V2014,V2015","313f","Unreserved (Surplus) - Unrestricted",0,0,0,null,"Fund 11930 -  Acct 3xxxxx (excluding Acct 322xxx, 381xxx and any Institution Specific Analysis amts)",null,"Acct 300xxx-321xxx, 322xxx, 323xxx - 379xxx"]
["%,FACCOUNT,TBTA_ACCOUNTS,NBTA_NET_ASSETS,FFUND_CODE,V11940,FBUDGET_REF,V2000,V2001,V2002,V2003,V2004,V2005,V2006,V2007,V2008,V2009,V2010,V2011,V2012,V2013,V2014,V2015","313g","Unreserved (Surplus) - Unrestricted",0,0,0,null,"Fund 11940 -  Acct 3xxxxx (excluding Acct 322xxx, 381xxx and any Institution Specific Analysis amts)",null,"Acct 300xxx-321xxx, 322xxx, 323xxx - 379xxx"]
["%,FACCOUNT,TBTA_ACCOUNTS,NBTA_NET_ASSETS,FFUND_CODE,V50000,FBUDGET_REF,V2000,V2001,V2002,V2003,V2004,V2005,V2006,V2007,V2008,V2009,V2010,V2011,V2012,V2013,V2014,V2015","313h","Unreserved (Surplus) - Unrestricted",-747.5,0,-747.5,null,"Fund 50000 -  Acct 3xxxxx (excluding Acct 322xxx, 381xxx and any Institution Specific Analysis amts)",null,"Acct 300xxx-321xxx, 322xxx, 323xxx - 379xxx"]
[null,null,"Unreserved (Surplus) - Restricted"]
[]
[null,"313a","Total Prior Year Fund Balance",null,null,{"$f":"SUM(F721:F738)","v":-16649770.999}]
[null,"313b","Total Prior Year Reserve Fund Balance (Exclude Surplus)",null,null,{"$f":"SUM(F721:F730)","v":-16620078.998}]
["%,FACCOUNT,TBTA_ACCOUNTS,NALL REV ACCTS,FFUND_CODE,V10000,FCLASS_FLD,TBTA_CLASS,NGEN_OPNS_SPEC_INIT","313c","Total Prior Year Reserve Fund Balance Available for Expenditure",-540000,0,{"$f":"F742-F726-F727-F729","v":-13272289.808}]
[null,314,"Check Figure - Column \"A\" formula should total Zero",{"$f":"D36+D53+D73+SUM(D717:D740)","v":-1.10000129789114E-2},null,null,null,"Amounts in Column D must agree to Lines 327-336 on LAST YEAR's worksheet."]
[]
[null,null,"Adjustments"]
[null,null,"Prior Year Payables/Expenditures"]
["%,FACCOUNT,V981100,FFUND_CODE,V10000,FCLASS_FLD,TBTA_CLASS,NBTA_NON_SFI_RESEARC","315a","   State Appropriation (w/o SFI)",0,-35062.080000000002,{"$f":"E748","v":-35062.080000000002},null,"Acct 981100 - Fund 10000 w/o SFI"]
["%,FACCOUNT,V981100,FFUND_CODE,V10000,FCLASS_FLD,TBTA_CLASS,NGEN_OPNS_SPEC_INIT","315aa","   SFI",0,0,{"$f":"E749","v":0},null,"Acct 981100 - Fund 10000 with SFI (Class 13XXX)"]
["%,FACCOUNT,V981100,FFUND_CODE,V10500","315b","   Tuition",0,-124931.73,-124931.73,null,"Acct 981100 - Fund 10500"]
["%,FACCOUNT,V981100,FFUND_CODE,V10600","315c","   Other General",0,-22669.920000000002,-22669.920000000002,null,"Acct 981100 - Fund 10600"]
["%,FACCOUNT,V981100,FFUND_CODE,V11810","315e","   Skidaway",0,0,0,null,"Acct 981100 - Fund 11810"]
["%,FACCOUNT,V981100,FFUND_CODE,V11920","315f","   USO",0,0,0,null,"Acct 981100 - Fund 11920"]
["%,FACCOUNT,V981100,FFUND_CODE,V11930,V11940","315g","   Public Libraries",0,0,0,null,"Acct 981100 - Fund 11930 & 11940"]
["%,FACCOUNT,V981100,FFUND_CODE,V50000","315h","   Capital Outlay",0,0,0,null,"Acct 981100 - Fund 50000"]
["%,FACCOUNT,V981100,FFUND_CODE,V14000","315i","   Departmental Sales and Services",0,0,0,null,"Acct 981100 - Fund 14000"]
["%,FACCOUNT,V981100,FFUND_CODE,V15000","315j","   Indirect Cost Recoveries",0,0,0,null,"Acct 981100 - Fund 15000"]
["%,FACCOUNT,V981100,FFUND_CODE,V16000","315k","   Technology Fees",0,0,0,null,"Acct 981100 - Fund 16000"]
["%,FACCOUNT,V981100,FFUND_CODE,V20000","315l","   Restricted Funds",0,0,0,null,"Acct 981100 - Fund 20000"]
[null,null,"Prior Year Receivables/Revenues",null,null,null,null," "]
["%,FACCOUNT,V981200,FFUND_CODE,V10000,FCLASS_FLD,TBTA_CLASS,NBTA_NON_SFI_RESEARC","316a","   State Appropriation (w/o SFI)",0,0,{"$f":"E761","v":0},null,"Acct 981200 - Fund 10000 w/o SFI"]
["%,FACCOUNT,V981200,FFUND_CODE,V10000,FCLASS_FLD,TBTA_CLASS,NGEN_OPNS_SPEC_INIT","316aa","   SFI",0,0,0,null,"Acct 981200 - Fund 10000 with SFI (Class 13XXX)"]
["%,FACCOUNT,V981200,FFUND_CODE,V10500","316b","   Tuition",0,421423.04000000004,421423.04000000004,null,"Acct 981200 - Fund 10500"]
["%,FACCOUNT,V981200,FFUND_CODE,V10600","316c","   Other General",0,269812.23,269812.23,null,"Acct 981200 - Fund 10600"]
["%,FACCOUNT,V981200,FFUND_CODE,V11810","316e",{"$f":"C$752","v":"   Skidaway"},0,0,0,null,"Acct 981200 - Fund 11810"]
["%,FACCOUNT,V981200,FFUND_CODE,V11920","316f",{"$f":"C$753","v":"   USO"},0,0,0,null,"Acct 981200 - Fund 11920"]
["%,FACCOUNT,V981200,FFUND_CODE,V11930,V11940","316g",{"$f":"C$754","v":"   Public Libraries"},0,0,0,null,"Acct 981200 - Fund 11930 & 11940"]
["%,FACCOUNT,V981200,FFUND_CODE,V50000","316h","   Capital Outlay",0,0,0,null,"Acct 981200 - Fund 50000"]
["%,FACCOUNT,V981200,FFUND_CODE,V14000","316i","   Departmental Sales and Services",0,0,0,null,"Acct 981200 - Fund 14000"]
["%,FACCOUNT,V981200,FFUND_CODE,V15000","316j","   Indirect Cost Recoveries",0,0,0,null,"Acct 981200 - Fund 15000"]
["%,FACCOUNT,V981200,FFUND_CODE,V16000","316k","   Technology Fees",0,0,0,null,"Acct 981200 - Fund 16000"]
["%,FACCOUNT,V981200,FFUND_CODE,V20000","316l","   Restricted Funds",0,0,0,null,"Acct 981200 - Fund 20000"]
[null,"318","Unreserved Fund Balance (Surplus) Returned to Office of Treasury & Fiscal Services",null,null,null,null," "]
[null," ",{"$f":"\"Year Ended June 30, \" &  (TEXT(ASD,\"YYYY\") - 1)","v":"Year Ended June 30, 2015"},null,null,null,null," "]
["%,FACCOUNT,V981500,FFUND_CODE,V10000,FCLASS_FLD,TBTA_CLASS,NBTA_NON_SFI_RESEARC","319a","   State Appropriation (w/o SFI)",0,0,{"$f":"E775","v":0},null,"Acct 981500 - Fund 10000 w/o SFI"]
["%,FACCOUNT,V981500,FFUND_CODE,V10000,FCLASS_FLD,TBTA_CLASS,NGEN_OPNS_SPEC_INIT","319aa","   SFI",0,0,0,null,"Acct 981500 - Fund 10000 with SFI (Class 13XXX)"]
["%,FACCOUNT,V981500,FFUND_CODE,V10500","319b","   Tuition",0,0,0,null,"Acct 981500 - Fund 10500"]
["%,FACCOUNT,V981500,FFUND_CODE,V10600","319c","   Other General",0,20262.560000000001,20262.560000000001,null,"Acct 981500 - Fund 10600"]
["%,FACCOUNT,V981500,FFUND_CODE,V11810","319e",{"$f":"C$752","v":"   Skidaway"},0,0,0,null,"Acct 981500 - Fund 11810"]
["%,FACCOUNT,V981500,FFUND_CODE,V11920","319f",{"$f":"C$753","v":"   USO"},0,0,0,null,"Acct 981500 - Fund 11920"]
["%,FACCOUNT,V981500,FFUND_CODE,V11930,V11940","319g",{"$f":"C$754","v":"   Public Libraries"},0,0,0,null,"Acct 981500 - Fund 11930 & 11940"]
["%,FACCOUNT,V981500,FFUND_CODE,V50000","319h","   Capital Outlay",0,747.5,747.5,null,"Acct 981500 - Fund 50000"]
[null," ",{"$f":"\"Year Ended June 30, \"& TEXT(ASD, \"YYYY\")","v":"Year Ended June 30, 2016"},null,null,null,null," "]
["%,FACCOUNT,V981550,FFUND_CODE,V10000,FCLASS_FLD,TBTA_CLASS,NBTA_NON_SFI_RESEARC","320a","   State Appropriation (w/o SFI)",0,0,{"$f":"E784","v":0},null,"Acct 981550 - Fund 10000 w/o SFI"]
["%,FACCOUNT,V981550,FFUND_CODE,V10000,FCLASS_FLD,TBTA_CLASS,NGEN_OPNS_SPEC_INIT","320aa","   SFI",0,0,0,null,"Acct 981550 - Fund 10000 with SFI (Class 13XXX)"]
["%,FACCOUNT,V981550,FFUND_CODE,V10500","320b","   Tuition",0,0,0,null,"Acct 981550 - Fund 10500"]
["%,FACCOUNT,V981550,FFUND_CODE,V10600","320c","   Other General",0,0,0,null,"Acct 981550 - Fund 10600"]
["%,FACCOUNT,V981550,FFUND_CODE,V11810","320e",{"$f":"C$752","v":"   Skidaway"},0,0,0,null,"Acct 981550 - Fund 11810"]
["%,FACCOUNT,V981550,FFUND_CODE,V11920","320f",{"$f":"C$753","v":"   USO"},0,0,0,null,"Acct 981550 - Fund 11920"]
["%,FACCOUNT,V981550,FFUND_CODE,V11930,V11940","320g",{"$f":"C$754","v":"   Public Libraries"},0,0,0,null,"Acct 981550 - Fund 11930 & 11940"]
["%,FACCOUNT,V981550,FFUND_CODE,V50000","320h","   Capital Outlay",0,0,0,null,"Acct 981550 - Fund 50000"]
[null," ","Prior Year Reserved Fund Balance Included in Funds Available",null,null,null,null," "]
["%,FACCOUNT,V981600,FFUND_CODE,V10000,FCLASS_FLD,TBTA_CLASS,NBTA_NON_SFI_RESEARC","321a","   State Appropriation (w/o SFI)",0,0,{"$f":"E793","v":0},null,"Acct 981600 - Fund 10000 w/o SFI"]
["%,FACCOUNT,V981600,FFUND_CODE,V10000,FCLASS_FLD,TBTA_CLASS,NGEN_OPNS_SPEC_INIT","321aa","   SFI",0,0,0,null,"Acct 981600 - Fund 10000 with SFI (Class 13XXX)"]
["%,FACCOUNT,V981600,FFUND_CODE,V10500","321b","   Tuition",0,0,0,null,"Acct 981600 - Fund 10500"]
["%,FACCOUNT,V981600,FFUND_CODE,V10600","321c","   Other General",0,0,0,null,"Acct 981600 - Fund 10600"]
["%,FACCOUNT,V981600,FFUND_CODE,V11810","321e",{"$f":"C$752","v":"   Skidaway"},0,0,0,null,"Acct 981600 - Fund 11810"]
["%,FACCOUNT,V981600,FFUND_CODE,V11920","321f",{"$f":"C$753","v":"   USO"},0,0,0,null,"Acct 981600 - Fund 11920"]
["%,FACCOUNT,V981600,FFUND_CODE,V11930,V11940","321g",{"$f":"C$754","v":"   Public Libraries"},0,0,0,null,"Acct 981600 - Fund 11930 & 11940"]
["%,FACCOUNT,V981600,FFUND_CODE,V50000","321h","   Capital Outlay",0,0,0,null,"Acct 981600 - Fund 50000"]
[null," ","Mandatory Transfers",null,null,null,null," "]
["%,FACCOUNT,V981700,FFUND_CODE,V10000,FCLASS_FLD,TBTA_CLASS,NBTA_NON_SFI_RESEARC","322a","   State Appropriation (w/o SFI)",0,0,{"$f":"E802","v":0},null,"Acct 981700 - Fund 10000 w/o SFI"]
["%,FACCOUNT,V981700,FFUND_CODE,V10000,FCLASS_FLD,TBTA_CLASS,NGEN_OPNS_SPEC_INIT","322aa","   SFI",0,0,0,null,"Acct 981700 - Fund 10000 with SFI (Class 13XXX)"]
["%,FACCOUNT,V981700,FFUND_CODE,V10500","322b","   Tuition",0,0,0,null,"Acct 981700 - Fund 10500"]
["%,FACCOUNT,V981700,FFUND_CODE,V10600","322c","   Other General",0,0,0,null,"Acct 981700 - Fund 10600"]
["%,FACCOUNT,V981700,FFUND_CODE,V11810","322e",{"$f":"C$752","v":"   Skidaway"},0,0,0,null,"Acct 981700 - Fund 11810"]
["%,FACCOUNT,V981700,FFUND_CODE,V11920","322f",{"$f":"C$753","v":"   USO"},0,0,0,null,"Acct 981700 - Fund 11920"]
["%,FACCOUNT,V981700,FFUND_CODE,V11930,V11940","322g",{"$f":"C$754","v":"   Public Libraries"},0,0,0,null,"Acct 981700 - Fund 11930 & 11940"]
["%,FACCOUNT,V981700,FFUND_CODE,V50000","322h","   Capital Outlay",0,0,0,null,"Acct 981700 - Fund 50000"]
["%,FACCOUNT,V981700,FFUND_CODE,V14000","322i","   Departmental Sales and Services",0,0,0,null,"Acct 981700 - Fund 14000"]
["%,FACCOUNT,V981700,FFUND_CODE,V15000","322j","   Indirect Cost Recoveries",0,0,0,null,"Acct 981700 - Fund 15000"]
["%,FACCOUNT,V981700,FFUND_CODE,V16000","322k","   Technology Fees",0,0,0,null,"Acct 981700 - Fund 16000"]
["%,FACCOUNT,V981700,FFUND_CODE,V20000","322l","   Restricted Funds",0,0,0,null,"Acct 981700 - Fund 20000"]
[null," ","Non-Mandatory Transfers",null,null,null,null," "]
["%,FACCOUNT,V981800,FFUND_CODE,V10000,FCLASS_FLD,TBTA_CLASS,NBTA_NON_SFI_RESEARC","323a","   State Appropriation (w/o SFI)",0,0,{"$f":"E815","v":0},null,"Acct 981800 - Fund 10000 w/o SFI"]
["%,FACCOUNT,V981800,FFUND_CODE,V10000,FCLASS_FLD,TBTA_CLASS,NGEN_OPNS_SPEC_INIT","323aa","   SFI",0,0,0,null,"Acct 981800 - Fund 10000 with SFI (Class 13XXX)"]
["%,FACCOUNT,V981800,FFUND_CODE,V10500","323b","   Tuition",0,0,0,null,"Acct 981800 - Fund 10500"]
["%,FACCOUNT,V981800,FFUND_CODE,V10600","323c","   Other General",0,-723814,-723814,null,"Acct 981800 - Fund 10600"]
["%,FACCOUNT,V981800,FFUND_CODE,V11810","323e",{"$f":"C$752","v":"   Skidaway"},0,0,0,null,"Acct 981800 - Fund 11810"]
["%,FACCOUNT,V981800,FFUND_CODE,V11920","323f",{"$f":"C$753","v":"   USO"},0,0,0,null,"Acct 981800 - Fund 11920"]
["%,FACCOUNT,V981800,FFUND_CODE,V11930,V11940","323g",{"$f":"C$754","v":"   Public Libraries"},0,0,0,null,"Acct 981800 - Fund 11930 & 11940"]
["%,FACCOUNT,V981800,FFUND_CODE,V50000","323h","   Capital Outlay",0,0,0,null,"Acct 981800 - Fund 50000"]
["%,FACCOUNT,V981800,FFUND_CODE,V14000","323i","   Departmental Sales and Services",0,0,0,null,"Acct 981800 - Fund 14000"]
["%,FACCOUNT,V981800,FFUND_CODE,V15000","323j","   Indirect Cost Recoveries",0,0,0,null,"Acct 981800 - Fund 15000"]
["%,FACCOUNT,V981800,FFUND_CODE,V16000","323k","   Technology Fees",0,0,0,null,"Acct 981800 - Fund 16000"]
["%,FACCOUNT,V981800,FFUND_CODE,V20000","323l","   Restricted Funds",0,0,0,null,"Acct 981800 - Fund 20000"]
[]
[null,{"$f":"325","v":325},{"$f":"\"Fund Balance June 30, \" & TEXT(ASD, \"YYYY\")","v":"Fund Balance June 30, 2016"},null,null,{"$f":" SUM(F717:F740) + SUM(F744:F827)","v":-17944786.370000012}]
[null,{"$f":"+B828+1","v":326},"Reserved"]
[null,327,"     Capital Outlay"]
[null,328,"     Departmental Sales and Services",null,null,{"$f":"F722+F97+F147+F148+F810+F823","v":-7064707.6800000016}]
[null,329,"     Indirect Cost Recoveries",null,null,{"$f":"F723+F85+F151+F152+F811+F824","v":-2145716.79}]
[null,330,"     Technology Fees",null,null,{"$f":"F724+F84+F149+F150+F812+F825","v":-848087.96000000066}]
[null,331,"     Restricted Funds",null,null,{"$f":"F725+F108+F153+F154+F217+F218+F219+F220+F233+F242+F243+F244+F245+F258+F267+F268+F269+F270+F283+F292+F293+F294+F295+F308+F317+F318+F319+F320+F333+F342+F343+F344+F345+F358+F367+F368+F369+F370+F383+F392+F393+F394+F395+F408+F417+F418+F419+F420+F433+F442+F443+F444+F445+F458+F467+F468+F469+F470+F483+F492+F493+F494+F495+F508+F517+F518+F519+F520+F533+F542+F543+F544+F545+F559+F568+F569+F570+F571+F588+F597+F598+F599+F600+F614+F627+F628+F629+F630+F643+F652+F653+F654+F655+F668+F155+F156+F813+F826","v":-284972.39999999851}]
[null,332,"     Uncollectible Accounts Receivable"]
[null,333,"     Inventories"]
[null,334,"     Carry-Over \"Per OPB\" (SEE NOTE BELOW)"]
[null,335,"     Early Retirement Program"]
[null,336,"     Tuition Carry Forward",null,null,null,null,"See NOTE below regarding Reserve for Tuition Carry forward"]
[null,337,"Unreserved (Surplus)",null,null,{"$f":"+F828-F830-F831-F832-F833-F834-F835-F836-F837-F838-F839","v":-7601301.5400000103},null,"See Further Analysis Below"]
[null,338,{"$f":"\"Total Fund Balance June 30, \" & TEXT(ASD, \"YYYY\")","v":"Total Fund Balance June 30, 2016"},null,null,{"$f":"SUM(F829:F840)","v":-17944786.370000012}]
[null,"338a","Total Current Year Reserve Fund Balance (excludes Surplus)",null,null,{"$f":"SUM(F830:F839)","v":-10343484.830000002}]
[null,"338b","Total Current Year Reserve Fund Balance Available for \nExpenditure",null,null,{"$f":"F842-F835-F836-F838","v":-10343484.830000002}]
[]
[]
[null,null,null,null,null,{"$f":"\"Analysis of June 30, \" & TEXT(ASD, \"YYYY\") & \"   Surplus between Current Year activity versus Prior Year activity:\"","v":"Analysis of June 30, 2016   Surplus between Current Year activity versus Prior Year activity:"}]
[]
[null,null,null,null,null,{"$f":"SUM(F748:F755) + SUM(F784:F791)","v":-182663.73},null,"Prior Year Payables/Expenditures"]
[null,null,null,null,null,{"$f":"SUM(F761:F768)","v":691235.27},null,"Prior Year Receivables/Revenue"]
[null,null,null,null,null,{"$f":"SUM(F848:F849)","v":508571.54000000004},"X","(Surplus)/Deficit related to Prior Year Activity  (PLEASE SEE NOTE BELOW)"]
[]
[null,null,null,null,null,{"$f":"F717","v":-1100782.9710000157},null,"Current Year Excess of Funds Available over Expenditures"]
[null,null,null,null,null,{"$f":"F721+F722+F723+F724+F725+F726+F727+F728+F729+F730-F830-F831-F832-F833-F834-F835-F836-F837-F838-F839","v":-6276594.1679999987},null,"Current Year Change in Reserves"]
[null,null,null,null,null,{"$f":"SUM(F802:F813)+SUM(F815:F826)","v":-723814},null,"Other Fund Balance Adjustments"]
[null,null,null,null,null,{"$f":"SUM(F852:F854)","v":-8101191.1390000144},"Y","(Surplus)/Deficit related to Current Year Activity  (PLEASE SEE NOTE BELOW)"]
[]
[null,null,null,null,null,{"$f":"F850+F855","v":-7592619.5990000144},"Z","(Surplus)/Deficit Total  (PLEASE SEE NOTE BELOW)"]
[]
[null,null,null,null,null,null,null,"NOTE:  If Line X is a Surplus and Line Y is a Deficit, please contact Claire Arnold at claire.arnold@usg.edu"]
[null,null,null,null,null,null,null,"NOTE:  If Line Z is a Deficit, please contact Claire Arnold at claire.arnold@usg.edu"]
[]
[]
[]
[]
[]
[]
[]
[null,null,"BCRPT"]
[null,null,"BUDGET_COMPLIANCE"]
[null,null,"JBFREEMAN"]
[null,null,"2016-06-30"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Report Fiscal Year:","Prior Year Start"]
[null,null,"Version",5.16,2016,2000]
[null,null,null,null,"Report Fiscal Year must be updated each year; can't use %ASD% in VB code used to populate cell range: row 730 (pyfndbal_Fund_10500) - row 738 (pyfndbal_Fund_50000)"]
[null,null,"Change Information",null,null,null,null,{"$f":"\"CHECK FIGURES:\" & CHAR(10) & CHAR(10)","v":"CHECK FIGURES:\n\n"}]
[null,null,"6/7/2011, validate the results",null,null,null,null,{"$f":"\"Fund Balance June 30, \" & TEXT(ASD, \"YYYY\") & \" Line 325 Column D must equal Total Fund Balance June 30, \" & (TEXT(ASD, \"YYYY\") - 1) & \" Line 338 Column D\" & CHAR(10) & CHAR(10)","v":"Fund Balance June 30, 2016 Line 325 Column D must equal Total Fund Balance June 30, 2015 Line 338 Column D\n\n"}]
[null,null,"7/18/2011, Mapping Changes to BCR nVision Report",null,null,null,null,{"$f":"\"Total Fund Balance June 30, \" & TEXT(ASD, \"YYYY\") & \" Line 338 Column D must equal Total Fund Balances Line BS39 Column D\"","v":"Total Fund Balance June 30, 2016 Line 338 Column D must equal Total Fund Balances Line BS39 Column D"}]
[null,null,"7/27/2011, Update formulas on BCR rpt",null,null,null,null,{"$f":"CONCATENATE(H905,H906,H907)","v":"CHECK FIGURES:\n\nFund Balance June 30, 2016 Line 325 Column D must equal Total Fund Balance June 30, 2015 Line 338 Column D\n\nTotal Fund Balance June 30, 2016 Line 338 Column D must equal Total Fund Balances Line BS39 Column D"}]
[null,null,"5/22/2012-8/01/2012, Add Various new sections and formulas"]
[null,null,"2013/04/15, Update formula, formatting, remove section",2.7,"RMullinix"]
[null,null,"2013/07/26, add new Tree Node SURPLUS_RETURN to row 83, BCR Line 2. Row 111 & 119 will report properly with Tree changes.",2.71,"RMullinix"]
[null,null,"2014/04/28, Changes to Supplemental tab",3.2,"RMullinix"]
[null,null,"2014/06/06, Changes to Supplemental tab",3.21,"Yvonne Howington"]
[null,null,"1/12/2015, 9.2 Upgrade",4.0999999999999996,"Robert Prescott"]
[null,null,"5/19/2015 - Update formula on supplemental tab, change contact details to Claire Arnold",4.3,"Julie Thompson/Robin Mullinix"]
[null,null,"7/21/2015 - Update mapping",4.4000000000000004,"Julie Thompson/Robert Prescott"]
[null,null,"2015-09-30 - prepare for switch to unix processing",5,"RMullinix","TSK26266"]
[null,null,"5/27/2016 - Update cell formulas per OFA",5.14,"Mpaktinat","tsk27872"]
[null,null,"7/14/2016 - Update Report Fiscal Year",5.16,"Robert Prescott","TSK28273"]

{"sheet":"Supplemental","index":2,"n_rows":75,"n_cols":14,"rows_kept":75,"cut":false,"hidden":false,"merged":[[55,5,55,13]]}
[]
["Budgetary Compliance Report"]
["Supplemental"]
[]
[]
[null,"Account Classification","10000 \nexcluding SFI","SFI","10500","10600","11810","11920","11930 & \n11940","50000","14000","15000","16000","20000"]
[]
[null,"Revenue",{"$f":"'BCR Report'!F93","v":-115182374.98999999},{"$f":"'BCR Report'!F173","v":-540000},{"$f":"'BCR Report'!F83","v":-162507749.77000001},{"$f":"SUM('BCR Report'!F86:'BCR Report'!F92)","v":-20239861.68},{"$f":"'BCR Report'!F594","v":0},{"$f":"'BCR Report'!F565","v":0},{"$f":"'BCR Report'!F539","v":0},{"$f":"'BCR Report'!F120","v":-19595432.100000001},{"$f":"'BCR Report'!F97","v":-14256574.109999999},{"$f":"'BCR Report'!F85","v":-551584.57999999996},{"$f":"'BCR Report'!F84","v":-4124894.72},{"$f":"'BCR Report'!F108","v":-63424181.239999995}]
[null,"Expenditures",{"$f":"SUM('BCR Report'!F143:F144)","v":115182371.99600001},{"$f":"'BCR Report'!F178","v":540000},{"$f":"SUM('BCR Report'!F141:F142)","v":162880441.648},{"$f":"SUM('BCR Report'!F145:F146)","v":20545565.854999997},{"$f":"'BCR Report'!F611","v":0},{"$f":"'BCR Report'!F585","v":0},{"$f":"'BCR Report'!F556","v":0},{"$f":"SUM('BCR Report'!F157)","v":19595432.100000001},{"$f":"SUM('BCR Report'!F147:F148)","v":12427030.85},{"$f":"SUM('BCR Report'!F151:F152)","v":399873.5},{"$f":"SUM('BCR Report'!F149:F150)","v":4298903.9399999995},{"$f":"SUM('BCR Report'!F153:F156)","v":63452250.329999998}]
[null,"Prior Year Payables/Expenditures",{"$f":"'BCR Report'!F748","v":-35062.080000000002},{"$f":"'BCR Report'!F749","v":0},{"$f":"'BCR Report'!F750","v":-124931.73},{"$f":"'BCR Report'!F751","v":-22669.920000000002},{"$f":"'BCR Report'!F752","v":0},{"$f":"'BCR Report'!F753","v":0},{"$f":"'BCR Report'!F754","v":0},{"$f":"'BCR Report'!F755","v":0},{"$f":"'BCR Report'!F756","v":0},{"$f":"'BCR Report'!F757","v":0},{"$f":"'BCR Report'!F758","v":0},{"$f":"'BCR Report'!F759","v":0}]
[null,"Prior Year Receivables/Revenues",{"$f":"'BCR Report'!F761","v":0},{"$f":"'BCR Report'!F762","v":0},{"$f":"'BCR Report'!F763","v":421423.04000000004},{"$f":"'BCR Report'!F764","v":269812.23},{"$f":"'BCR Report'!F765","v":0},{"$f":"'BCR Report'!F766","v":0},{"$f":"'BCR Report'!F767","v":0},{"$f":"'BCR Report'!F768","v":0},{"$f":"'BCR Report'!F769","v":0},{"$f":"'BCR Report'!F770","v":0},{"$f":"'BCR Report'!F771","v":0},{"$f":"'BCR Report'!F772","v":0}]
[null,"Return of PY Surplus",{"$f":"'BCR Report'!F775","v":0},{"$f":"'BCR Report'!F776","v":0},{"$f":"'BCR Report'!F777","v":0},{"$f":"'BCR Report'!F778","v":20262.560000000001},{"$f":"'BCR Report'!F779","v":0},{"$f":"'BCR Report'!F780","v":0},{"$f":"'BCR Report'!F781","v":0},{"$f":"'BCR Report'!F782","v":747.5}]
[null,"Early Surplus return",{"$f":"'BCR Report'!$F784","v":0},{"$f":"'BCR Report'!$F785","v":0},{"$f":"'BCR Report'!$F786","v":0},{"$f":"'BCR Report'!$F787","v":0},{"$f":"'BCR Report'!$F788","v":0},{"$f":"'BCR Report'!$F789","v":0},{"$f":"'BCR Report'!$F790","v":0},{"$f":"'BCR Report'!$F791","v":0}]
[null,"Prior Year Reserved Fund Balance\nIncluded in Funds Available",{"$f":"'BCR Report'!F793","v":0},{"$f":"'BCR Report'!F794","v":0},{"$f":"'BCR Report'!F795","v":0},{"$f":"'BCR Report'!F796","v":0},{"$f":"'BCR Report'!F797","v":0},{"$f":"'BCR Report'!F798","v":0},{"$f":"'BCR Report'!F799","v":0},{"$f":"'BCR Report'!F800","v":0}]
[null,"Mandatory Transfers",{"$f":"'BCR Report'!F802","v":0},{"$f":"'BCR Report'!F803","v":0},{"$f":"'BCR Report'!F804","v":0},{"$f":"'BCR Report'!F805","v":0},{"$f":"'BCR Report'!F806","v":0},{"$f":"'BCR Report'!F807","v":0},{"$f":"'BCR Report'!F808","v":0},{"$f":"'BCR Report'!F809","v":0},{"$f":"'BCR Report'!F810","v":0},{"$f":"'BCR Report'!F811","v":0},{"$f":"'BCR Report'!F812","v":0},{"$f":"'BCR Report'!F813","v":0}]
[null,"Non-Mandatory Transfers",{"$f":"'BCR Report'!F815","v":0},{"$f":"'BCR Report'!F816","v":0},{"$f":"'BCR Report'!F817","v":0},{"$f":"'BCR Report'!F818","v":-723814},{"$f":"'BCR Report'!F819","v":0},{"$f":"'BCR Report'!F820","v":0},{"$f":"'BCR Report'!F821","v":0},{"$f":"'BCR Report'!F822","v":0},{"$f":"'BCR Report'!F823","v":0},{"$f":"'BCR Report'!F824","v":0},{"$f":"'BCR Report'!F825","v":0},{"$f":"'BCR Report'!F826","v":0}]
[null,"Surplus/Fund Balance  Net Change",{"$f":"SUM(C8:C16)","v":-35065.073999987842},0,669183.18799999123,-150704.95500000287,0,0,0,747.5,-1829543.2599999998,-151711.07999999996,174009.21999999927,28069.090000003576]
[]
[]
[]
[null,"Adjustments to Reserves"]
[null,"  Uncollectibles"]
[null,"  Inventory"]
[null,"Net changes to reserves",{"$f":"SUM(C22:C23)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null," "]
[null,"Beginning Reserve Balances "]
[null,"  Inventories"]
[null,"  Uncollectibles"]
[]
[null,"Ending Reserve Balances ",{"$f":"SUM(C24:C29)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[null,"Funds available for surplus or carryforward"]
[null,"after reserve calculations",{"$f":"C17-C24","v":-35065.073999987842},{"$f":"D17-D24","v":0},669183.18799999123,-150704.95500000287,0,0,0,747.5,-1829543.2599999998,-151711.07999999996,174009.21999999927,28069.090000003576]
[null,"Less:PY Surplus & Tuition Carry-Forward or Plus: PY Reserve (for Funds 14000, 15000, 16000, 20000)",{"$f":"+'BCR Report'!F731","v":-8681.9500000000007},null,{"$f":"'BCR Report'!F730+'BCR Report'!F732","v":-4707981.0080000004},{"$f":"+'BCR Report'!F733","v":-20262.550999999999},{"$f":"'BCR Report'!F734","v":0},{"$f":"'BCR Report'!F735","v":0},{"$f":"('BCR Report'!F736+'BCR Report'!F737)","v":0},{"$f":"+'BCR Report'!F738","v":-747.5},{"$f":"'BCR Report'!F722","v":-5235164.42},{"$f":"'BCR Report'!F723","v":-1994005.71},{"$f":"'BCR Report'!F724","v":-1022097.18},{"$f":"'BCR Report'!F725","v":-313041.49}]
[]
[null,"Net Surplus/Carryforward/Fund Balance"]
[null,"(Carryforward subject to 3% rule)",{"$f":"SUM(C34:C37)","v":-43747.023999987839},0,-4038797.8200000091,-170967.50600000288,0,0,0,0,-7064707.6799999997,-2145716.79,-848087.96000000078,-284972.39999999641]
[null,"Maximum reserve allowed",null,null,{"$f":"IF(E54>E38,E54,E38)","v":-4038797.8200000091}]
[null,"  Net Surplus/Fund Balance",{"$f":"SUM(C38:C39)","v":-43747.023999987839},0,{"$f":"+E38-E39","v":0},-170967.50600000288,0,0,0,0,-7064707.6799999997,-2145716.79,-848087.96000000078,-284972.39999999641]
[null,"Non Mandatory transfer to cover deficit"]
[]
[null,"Net (Surplus) Deficit or Reserve excluding Tuition Carry-Over",{"$f":"SUM(C40:C42)","v":-43747.023999987839},0,0,-170967.50600000288,0,0,0,0,-7064707.6799999997,-2145716.79,-848087.96000000078,-284972.39999999641]
[]
[]
[]
[null,"10500 - Tuition Carry-Forward & Surplus Calculation"]
[null,"Tuition Carry Forward Reserve"]
[null,"Prior Year Tuition Carry Forward",null,null,{"$f":"'BCR Report'!F730","v":-4707981.0080000004}]
[null,"Current Year Surplus (net of PY surplus return)",null,null,{"$f":"E17-E12","v":669183.18799999123}]
[null,"Inc (Dec) in Inv & Uncoll A/R)",null,null,{"$f":"-E24","v":0}]
[null,"Subtotal",null,null,{"$f":"SUM(E49:E51)","v":-4038797.8200000091}]
[]
[null,"Carry Forward Calculation (3%)",null,null,{"$f":"E8*0.03","v":-4875232.4931000005}]
[null,"Surplus",null,null,{"$f":"IF(E52<E54,E52-E54,0)","v":0}]
[null,"Carry Forward",null,null,{"$f":"IF(E54>=E52,E54,E52)","v":-4038797.8200000091},"   Exception: Amount cannot be carried forward if there is a deficit on another budgetary fund"]
[]
[]
[null,"Check for Surplus"]
[null,"Unreserved from BCR Report Line 337, col F",{"$f":"'BCR Report'!F840","v":-7601301.5400000103}]
[]
[null,"Surplus"]
[null,"Fund 10000 (non SFI)",{"$f":"C43","v":-43747.023999987839}]
[null,"SFI",{"$f":"D43","v":0}]
[null,"Fund 10500",{"$f":"E43","v":0}]
[null,"Fund 10600",{"$f":"F43","v":-170967.50600000288}]
[null,"Fund 11810",{"$f":"G43","v":0}]
[null,"Fund 11920",{"$f":"H43","v":0}]
[null,"Fund 11930 & 11940",{"$f":"I43","v":0}]
[null,"Fund 50000",{"$f":"J43","v":0}]
[null,null,{"$f":"SUM(C63:C70)","v":-214714.52999999071}]
[]
[null,"Check, should be zero",{"$f":"C60-C71","v":-7386587.0100000193}]
[]
[null,"Manual Entry Required"]