{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Instructions","Outcomes","Dynamic Formula","Printable Summary","Weights","Historical Trends","FAQs","Working"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":8,"comments":2,"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":"Instructions","index":0,"n_rows":40,"n_cols":11,"rows_kept":40,"cut":false,"hidden":false,"merged":[[83,8,83,9],[0,1,0,13],[1,1,1,13],[79,2,79,11],[80,2,80,11],[82,8,82,9]]}
[null,"Tennessee Higher Education Commission"]
[null,"Outcomes-Based Funding Dynamic Simulation Instructions"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,102,null,null,null,101,null,null,null,100]
[]
[null,null,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01]
[null,null,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01]
[null,null,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01]
[null,null,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01]
[null,null,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01]
[null,null,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01]
[null,null,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01]
[null,null,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01]
[null,null,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01]
[null,null,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01]
[null,null,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01]
[null,null,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01]
[]
[null,null,113,null,null,null,100,null,null,null,100]
[]
[]
[]
[]
[null,null,100,null,null,null,100,null,null,null,100]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,100]

{"sheet":"Outcomes","index":1,"n_rows":306,"n_cols":47,"rows_kept":306,"cut":false,"hidden":false,"merged":[[0,1,0,14],[1,1,1,14],[2,2,2,3],[3,9,3,11],[4,9,4,11],[197,1,197,2],[249,25,249,29],[301,2,301,10],[5,20,5,22],[7,13,7,14],[28,11,28,12],[40,11,40,12],[110,18,110,22],[176,2,176,14],[5,9,5,11]]}
[null,"Tennessee Higher Education Commission"]
[null,"Estimated Changes in FY 2015-16 Formula Outcomes"]
[null,null,"Select institutions:"]
[null,null,"Chattanooga","APSU","All CC","All 4yr","All TCAT","Total",null,"14-15 Appropriations",null,null,{"$f":"'Printable Summary'!C6","v":827231300}]
[null,"Change in Est. Funding",{"$f":"VLOOKUP(C4,'Printable Summary'!F6:H30,2,0)","v":0},{"$f":"VLOOKUP(D4,'Printable Summary'!F6:H31,2,0)","v":0},{"$f":"'Printable Summary'!G27","v":0},{"$f":"'Printable Summary'!G12+'Printable Summary'!G32","v":0},{"$f":"'Printable Summary'!G34","v":0},{"$f":"'Printable Summary'!G36","v":0},null,"Estimated 15-16 Appropriations",null,null,{"$f":"'Printable Summary'!C7","v":827231300}]
[null,"Percent Change in Est. Funding",{"$f":"VLOOKUP(C4,'Printable Summary'!F6:H30,3,0)","v":0},{"$f":"VLOOKUP(D4,'Printable Summary'!F6:H31,3,0)","v":0},{"$f":"'Printable Summary'!H27","v":0},{"$f":"SUM('Printable Summary'!G12,'Printable Summary'!G32)/(SUM(Working!C13,Working!C33))","v":0},{"$f":"'Printable Summary'!H34","v":0},{"$f":"'Printable Summary'!H36","v":0},null,"Change",null,null,{"$f":"'Printable Summary'!C9","v":0},{"$f":"'Printable Summary'!C8","v":0},null,null,null,null,null,null,"WORKING AREA------"]
[null,"Change in Weighted Outcomes ",{"$f":"HLOOKUP($C$4,$R$135:$AE$139,5,0)","v":0},{"$f":"HLOOKUP($D$4,$R$276:$Z$281,5,0)","v":0},{"$f":"AE139","v":0},{"$f":"AA280","v":0},"n/a",{"$f":"AE139+AA280","v":0}]
[null,"Change in Weighted Outcomes ",{"$f":"HLOOKUP(C4, R135:AE140, 6,0)","v":0},{"$f":"HLOOKUP($D$4,$R$276:$Z$281,6,0)","v":0},{"$f":"E7/AE136","v":0},{"$f":"F7/AA277","v":0},"n/a",{"$f":"H7/(AE136+AA277)","v":0}]
[]
[]
[null,"CC Outcomes Annual Changes","Chattanooga","Cleveland","Columbia","Dyersburg","Jackson","Motlow","Nashville","Northeast","Pellissippi","Roane","Southwest","Volunteer","Walters",null,null,null,null,null,{"$f":"C4","v":"Chattanooga"},null,"Avg CC Change",null,null,null,null,"Change in Weighted Outcomes ",3.3333333333331705E-3,3.3333333333332793E-3,6.6666666666667564E-3,5.7130810667704738E-3]
[null,"Students Accumulating 12 hrs",0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,{"$f":"HLOOKUP($U$11,$C$11:$O$25,2)","v":0},null,{"$f":"AVERAGE(C12:O12)","v":0},{"$f":"13*W12","v":0},null,null,null,null,{"$f":"C4","v":"Chattanooga"},{"$f":"E4","v":"All CC"},{"$f":"F4","v":"All 4yr"},{"$f":"H4","v":"Total"}]
[null,"Students Accumulating 24 hrs",0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,{"$f":"HLOOKUP($U$11,$C$11:$O$25,3)","v":0},null,{"$f":"AVERAGE(C13:O13)","v":0},0,null,null,null,"Change in Appropriations",{"$f":"C6","v":0},{"$f":"E6","v":0},{"$f":"F6","v":0},{"$f":"H6","v":0}]
[null,"Students Accumulating 36 hrs",0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,{"$f":"HLOOKUP($U$11,$C$11:$O$25,4)","v":0},null,0,0,null,null,null,"Change in Weighted Outcomes ",{"$f":"C8","v":0},{"$f":"E8","v":0},{"$f":"F8","v":0},{"$f":"H8","v":0}]
[null,"Dual Enrollment",0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,{"$f":"HLOOKUP($U$11,$C$11:$O$25,5)","v":0},null,0,0]
[null,"Associates",0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,{"$f":"HLOOKUP($U$11,$C$11:$O$25,6)","v":0},null,0,0]
[null,"Certificates 1-2 Years",0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,{"$f":"HLOOKUP($U$11,$C$11:$O$25,7)","v":0},null,0,0]
[null,"Certificates Less Than 1 Year",0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,{"$f":"HLOOKUP($U$11,$C$11:$O$25,8)","v":0},null,0,0]
[null,"Job Placements",0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,{"$f":"HLOOKUP($U$11,$C$11:$O$25,9)","v":0},null,0,0]
[null,"R & D Success",0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,{"$f":"HLOOKUP($U$11,$C$11:$O$25,10)","v":0},null,0,0]
[null,"Transfers Out with 12 hrs",0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,{"$f":"HLOOKUP($U$11,$C$11:$O$25,11)","v":0},null,0,0]
[null,"Workforce Training",0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,{"$f":"HLOOKUP($U$11,$C$11:$O$25,12)","v":0},null,0,0]
[null,"Awards per 100 FTE",0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,{"$f":"HLOOKUP($U$11,$C$11:$O$25,13)","v":0},null,0,0]
[null,"Sub-population Adult",0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,{"$f":"HLOOKUP($U$11,$C$11:$O$25,14)","v":0},null,0,0]
[null,"Sub-population Pell",0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,{"$f":"HLOOKUP($U$11,$C$11:$O$25,15)","v":0},null,0,0]
[null,"Percent Change in Est. Funding",{"$f":"'Printable Summary'!$H14","v":0},{"$f":"'Printable Summary'!$H15","v":0},{"$f":"'Printable Summary'!$H16","v":0},{"$f":"'Printable Summary'!$H17","v":0},{"$f":"'Printable Summary'!$H18","v":0},{"$f":"'Printable Summary'!$H19","v":0},{"$f":"'Printable Summary'!$H20","v":0},{"$f":"'Printable Summary'!$H21","v":0},{"$f":"'Printable Summary'!$H22","v":0},{"$f":"'Printable Summary'!$H23","v":0},{"$f":"'Printable Summary'!$H24","v":0},{"$f":"'Printable Summary'!$H25","v":0},{"$f":"'Printable Summary'!$H26","v":0}]
[null,"Change in Est. Funding ($1K)",{"$f":"Working!$N15/1000","v":0},{"$f":"Working!$N16/1000","v":0},{"$f":"Working!$N17/1000","v":0},{"$f":"Working!$N18/1000","v":0},{"$f":"Working!$N19/1000","v":0},{"$f":"Working!$N20/1000","v":0},{"$f":"Working!$N21/1000","v":0},{"$f":"Working!$N22/1000","v":0},{"$f":"Working!$N23/1000","v":0},{"$f":"Working!$N24/1000","v":0},{"$f":"Working!$N25/1000","v":0},{"$f":"Working!$N26/1000","v":0},{"$f":"Working!$N27/1000","v":0}]
[]
[null,"Univ Outcomes Annual Changes","UTM","APSU","TTU","UTC","MTSU","ETSU","TSU","UM","UTK","CC",null,"4 Yr",null,null,null,null,null,null,{"$f":"D4","v":"APSU"},null,"Avg 4yr Change"]
[null,"Students Accumulating 24 hrs",0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,{"$f":"HLOOKUP($U$29,$C$29:$K$41,2,0)","v":0},null,{"$f":"AVERAGE(C30:K30)","v":0}]
[null,"Students Accumulating 48 hrs",0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,{"$f":"HLOOKUP($U$29,$C$29:$K$41,3,0)","v":0},null,{"$f":"AVERAGE(C31:K31)","v":0}]
[null,"Students Accumulating 72 hrs",0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,{"$f":"HLOOKUP($U$29,$C$29:$K$41,4,0)","v":0},null,0]
[null,"Bachelors and Associates",0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,{"$f":"HLOOKUP($U$29,$C$29:$K$41,5,0)","v":0},null,0]
[null,"Masters/Ed Specialist Degrees",0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,{"$f":"HLOOKUP($U$29,$C$29:$K$41,6,0)","v":0},null,0]
[null,"Doctoral / Law Degrees",0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,{"$f":"HLOOKUP($U$29,$C$29:$K$41,7,0)","v":0},null,0]
[" ","Research and Service",0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,{"$f":"HLOOKUP($U$29,$C$29:$K$41,8,0)","v":0},null,0]
[null,"Transfers Out with 12 hrs",0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,{"$f":"HLOOKUP($U$29,$C$29:$K$41,9,0)","v":0},null,0]
[null,"Degrees per 100 FTE",0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,{"$f":"HLOOKUP($U$29,$C$29:$K$41,10,0)","v":0},null,0]
[null,"Six-Year Graduation Rate",0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,{"$f":"HLOOKUP($U$29,$C$29:$K$41,11,0)","v":0},null,0]
[null,"Sub-population Adults",0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,{"$f":"HLOOKUP($U$29,$C$29:$K$41,12,0)","v":0},null,0]
[null,"Sub-population Pell",0,0,0,0,0,0,0,0,0,{"$f":"C4","v":"Chattanooga"},null,{"$f":"D4","v":"APSU"},null,null,null,null,null,null,{"$f":"HLOOKUP($U$29,$C$29:$K$41,13,0)","v":0},null,0]
[null,"Percent Change in Est. Funding",{"$f":"'Printable Summary'!H31","v":0},{"$f":"'Printable Summary'!H6","v":0},{"$f":"'Printable Summary'!H10","v":0},{"$f":"'Printable Summary'!H29","v":0},{"$f":"'Printable Summary'!H8","v":0},{"$f":"'Printable Summary'!H7","v":0},{"$f":"'Printable Summary'!H9","v":0},{"$f":"'Printable Summary'!H11","v":0},{"$f":"'Printable Summary'!H30","v":0}]
[null,"Change in Est. Funding ($1K)",{"$f":"Working!N32/1000","v":0},{"$f":"Working!N7/1000","v":0},{"$f":"Working!N11/1000","v":0},{"$f":"Working!N30/1000","v":0},{"$f":"Working!N9/1000","v":0},{"$f":"Working!N8/1000","v":0},{"$f":"Working!N10/1000","v":0},{"$f":"Working!N12/1000","v":0},{"$f":"Working!N31/1000","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"WORKING AREA------ CC"]
[null,null,"Chattanooga","Cleveland","Columbia","Dyersburg","Jackson","Motlow","Nashville","Northeast","Pellissippi","Roane","Southwest","Volunteer","Walters","All CC"]
[null,"Total Formula Calculation",{"$f":"ROUND(C166, -2)","v":64059300},{"$f":"ROUND(D166, -2)","v":20984000},29171800,17282300,26204100,25277200,37617700,30932100,55920100,41232600,58403900,38449500,48135000,{"$f":"ROUND(P166, -2)","v":493669700}]
[]
[null,"Total",{"$f":"C57","v":64059300},{"$f":"D57","v":20984000},29171800,17282300,26204100,25277200,37617700,30932100,55920100,41232600,58403900,38449500,48135000,{"$f":"SUM(C59:O59)","v":493669600}]
[null,"2014-15 Phase-In Factor",1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[null,"2015-16 Total Need Recommendation",{"$f":"C59*C60","v":64059300},{"$f":"D59*D60","v":20984000},29171800,17282300,26204100,25277200,37617700,30932100,55920100,41232600,58403900,38449500,48135000,{"$f":"SUM(C61:O61)","v":493669600}]
[null,"2014-15 Total Need Recommendation",65212000,21864000,30501700,18083000,27431000,26361000,39262000,32598000,58073000,43069000,61028000,40145000,50358000,{"$f":"SUM(C62:O62)","v":513985700}]
[null,"% Change",{"$f":"C61/C62-1","v":-1.7676194565417358E-2},{"$f":"D61/D62-1","v":-4.0248810830589066E-2},-4.3600848477297949E-2,-4.4279157219487941E-2,-4.472676898399619E-2,-4.1113766549068731E-2,-4.1880189496204978E-2,-5.1104362230811717E-2,-3.7072305546467343E-2,-4.2638556734542199E-2,-4.2998295864193459E-2,-4.2234400298916452E-2,-4.4143929465030429E-2,{"$f":"P61/P62","v":0.96047341394906516},null,null,"Three Years of the Three-Year Average:"]
[]
[null,"Subsidy/Fee Policy",{"$f":"2/3","v":0.66666666666666663},0.66666666666666663,0.66666666666666663,0.66666666666666663,0.66666666666666663,0.66666666666666663,0.66666666666666663,0.66666666666666663,0.66666666666666663,0.66666666666666663,0.66666666666666663,0.66666666666666663,0.66666666666666663,0.66666666666666663]
[null,"Out of State Tuition Deduct",{"$f":"C181","v":2121291.5021079709},131370.0031294869,195262.99961567344,89561.373291518117,164202.74351126212,187599.73906419225,327213.36395952111,18689.0860773022,620291.43132788653,489419.20195340685,410573.93771615421,340160.67682636541,380029.24308144074,{"$f":"SUM(C66:O66)","v":5475665.3016621806}]
[null,"Legislative Initiatives",0,0,72700,0,0,0,0,0,0,150000,0,0,0,{"$f":"SUM(C67:O67)","v":222700},null,null,null,"Chattanooga","Cleveland","Columbia","Dyersburg","Jackson","Motlow","Nashville","Northeast","Pellissippi","Roane","Southwest","Volunteer","Walters",null,"sub pops","Chattanooga","Cleveland","Columbia","Dyersburg","Jackson","Motlow","Nashville","Northeast","Pellissippi","Roane","Southwest","Volunteer","Walters"]
[null,"2015-16 Recommendation",{"$f":"ROUND(((C166*C60*C65-C66)*(1+0.0545*C168/100)), -3)+C67","v":42730000},{"$f":"ROUND(((D166*D60*D65-D66)*(1+0.0545*D168/100)), -3)+D67","v":14530000},20290700,12024000,18229000,17508000,26060000,21726000,38498000,28591000,40541000,26644000,33438000,null,null,null,"Students Accumulating 12 hrs",2461.6666666666665,1121.6666666666667,1572,1040,1224,1410,2339.3333333333335,1631,2922.3333333333335,1704.3333333333333,3667,2212.6666666666665,1963.6666666666667,null,"Adults Accumulating 12 hrs",748,362,341.66666666666669,303.66666666666669,317.33333333333331,307.66666666666669,1030,531.33333333333337,694.66666666666663,433.33333333333331,1242.6666666666667,560.33333333333337,475]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Students Accumulating 24 hrs",1880.6666666666667,810,1333.3333333333333,704,943.33333333333337,1105.3333333333333,1936.3333333333333,1384.6666666666667,2395.3333333333335,1313,2901.3333333333335,1687.3333333333333,1392.6666666666667,null,"Adults Accumulating 24 hrs",760.33333333333337,319.66666666666669,384.33333333333331,269,323.33333333333331,301,928.33333333333337,544,709.66666666666663,399,1210.3333333333333,560.66666666666663,394.33333333333331]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Students Accumulating 36 hrs",1628,669.33333333333337,1067.3333333333333,538,773.33333333333337,952,1666.3333333333333,1201.3333333333333,2017,1135.6666666666667,2206.3333333333335,1433.6666666666667,1204.6666666666667,null,"Adults Accumulating 36 hrs",736.33333333333337,299,358,237.33333333333334,290.33333333333331,294.33333333333331,870,522.66666666666663,718,386.66666666666669,1084.3333333333333,526,399.66666666666669]
[null,"Est. Outcomes (10-11 to 12-13 Data)","Chattanooga","Cleveland","Columbia","Dyersburg","Jackson","Motlow","Nashville","Northeast","Pellissippi","Roane","Southwest","Volunteer","Walters","All CC",null,null,"Dual Enrollment",1167.6666666666667,622.66666666666663,769.33333333333337,818.33333333333337,862,833.33333333333337,1069.3333333333333,624.66666666666663,1327.6666666666667,1553,394.33333333333331,1625.6666666666667,1226.3333333333333,null,"Adult Associates",572,208.66666666666666,281,171,305.33333333333331,266.33333333333331,443.33333333333331,406,554.66666666666663,425.33333333333331,607.66666666666663,429,371.66666666666669]
[null,"Students Accumulating 12 hrs",{"$f":"(AVERAGE(T96,T82,(T68*(1+C12))))","v":2461.6666666666665},{"$f":"(AVERAGE(U96,U82,(U68*(1+D12))))","v":1121.6666666666667},1572,1040,1224,1410,2339.3333333333335,1631,2922.3333333333335,1704.3333333333333,3667,2212.6666666666665,1963.6666666666667,{"$f":"SUM(C72:O72)","v":25269.666666666668},null,null,"Associates",913.33333333333337,365.33333333333331,583.33333333333337,280,546.33333333333337,573.66666666666663,624.33333333333337,726.66666666666663,1097,787.33333333333337,848.66666666666663,757.66666666666663,783,null,"Adult 1-2 Year Certificates",104.66666666666667,29.333333333333332,32.333333333333336,17,11,0.33333333333333331,64.333333333333329,69.666666666666671,0,55.333333333333336,41,56.666666666666664,11.333333333333334]
[null,"Students Accumulating 24 hrs",{"$f":"(AVERAGE(T97,T83,(T69*(1+C13))))","v":1880.6666666666667},810,1333.3333333333333,704,943.33333333333337,1105.3333333333333,1936.3333333333333,1384.6666666666667,2395.3333333333335,1313,2901.3333333333335,1687.3333333333333,1392.6666666666667,19787.333333333332,null,null,"Certificates 1-2 Years",166,39,50,24.333333333333332,22.666666666666668,0.33333333333333331,83.333333333333329,115.33333333333333,0,76,58.333333333333336,81,16,null," Adult <1yr Certificates",71,90,1.6666666666666667,6,14.666666666666666,27.333333333333332,122.66666666666667,8,207.66666666666666,16.333333333333332,210.66666666666666,180.33333333333334,158.66666666666666]
[null,"Students Accumulating 36 hrs",1628,669.33333333333337,1067.3333333333333,538,773.33333333333337,952,1666.3333333333333,1201.3333333333333,2017,1135.6666666666667,2206.3333333333335,1433.6666666666667,1204.6666666666667,16493,null,null,"Certificates < 1 Year",109,154.66666666666666,1.6666666666666667,10,29.333333333333332,31.666666666666668,152.33333333333334,12.666666666666666,448.33333333333331,20.666666666666668,329.33333333333331,304.66666666666669,249,null,"Low-income Accumulating 12 hrs",1393.6666666666667,704.33333333333337,860,674.66666666666663,849.66666666666663,777,1610,1059,1563,1060.3333333333333,2568,1226,1220]
[null,"Dual Enrollment",1167.6666666666667,622.66666666666663,769.33333333333337,818.33333333333337,862,833.33333333333337,1069.3333333333333,624.66666666666663,1327.6666666666667,1553,394.33333333333331,1625.6666666666667,1226.3333333333333,12894.333333333334,null,null,"Job Placements",405.66666666666669,202,228.66666666666666,106.66666666666667,306.66666666666669,82.666666666666671,320.33333333333331,261.66666666666669,298,402.33333333333331,429,371,506,null,"Low-income Accumulating 24 hrs",1169,551,775,511.33333333333331,707,659.66666666666663,1341.3333333333333,954.66666666666663,1368,902.66666666666663,2049.3333333333335,1056,948]
[null,"Associates",{"$f":"(AVERAGE(T100,T86,(T72*(1+C16))))","v":913.33333333333337},365.33333333333331,583.33333333333337,280,546.33333333333337,573.66666666666663,624.33333333333337,726.66666666666663,1097,787.33333333333337,848.66666666666663,757.66666666666663,783,8886.6666666666679,null,null,"Remedial & Developmental Success",2627.6666666666665,934.33333333333337,1422,1070.6666666666667,1338,1584,2889,1819.6666666666667,2628.6666666666665,1586.3333333333333,4446.333333333333,2240.3333333333335,1736,null,"Low-income Accumulating 36 hrs",1018.6666666666666,465.66666666666669,631.66666666666663,404,578.33333333333337,581.33333333333337,1171.3333333333333,841.66666666666663,1205.3333333333333,803.33333333333337,1605,911.33333333333337,839.33333333333337]
[null,"Certificates 1-2 Years",166,39,50,24.333333333333332,22.666666666666668,0.33333333333333331,83.333333333333329,115.33333333333333,0,76,58.333333333333336,81,16,732.33333333333337,null,null,"Transfers Out with 12 hrs",510.66666666666669,214,424,216.66666666666666,287.33333333333331,515.66666666666663,621.66666666666663,383,730,448,740.66666666666663,582.66666666666663,424.33333333333331,null,"Low-income Associates",550.33333333333337,251.66666666666666,350,204.66666666666666,379.33333333333331,350.33333333333331,418.33333333333331,495,683.33333333333337,522,597.66666666666663,477.33333333333331,529.33333333333337]
[null,"Certificates < 1 Year",109,154.66666666666666,1.6666666666666667,10,29.333333333333332,31.666666666666668,152.33333333333334,12.666666666666666,448.33333333333331,20.666666666666668,329.33333333333331,304.66666666666669,249,1853.3333333333333,null,null,"Workforce Training (Contact Hours)",185122.33333333334,6295.333333333333,61429.666666666664,6350,16351.166666666666,6603,36158.666666666664,6182.5,51527.6,97898.166666666672,67463.896666666507,80459.016666666663,173663.66666666666,null,"Low-income 1-2 Year Certificates",80,27,21.333333333333332,17,15.333333333333334,0,44.333333333333336,73.333333333333329,0,48.333333333333336,30.333333333333332,44.666666666666664,9]
[null,"Job Placements",405.66666666666669,202,228.66666666666666,106.66666666666667,306.66666666666669,82.666666666666671,320.33333333333331,261.66666666666669,298,402.33333333333331,429,371,506,3920.666666666667,null,null,"Awards per 100 FTE",15.289461588386908,15.387595731290846,17.395808799552093,13.108668392468303,17.149832911834618,17.676498840258365,10.930151074286307,17.891491472659876,14.281697415038996,19.329257519420363,10.113291516519242,14.592630097086074,17.175626753053212,null,"Low-income <1yr Certificates",62,91,1.3333333333333333,6.333333333333333,19,13.666666666666666,75,9,257.33333333333331,12.333333333333334,208.66666666666666,162,143]
[null,"Remedial & Developmental Success",2627.6666666666665,934.33333333333337,1422,1070.6666666666667,1338,1584,2889,1819.6666666666667,2628.6666666666665,1586.3333333333333,4446.333333333333,2240.3333333333335,1736,26322.999999999996]
[null,"Transfers Out with 12 hrs",510.66666666666669,214,424,216.66666666666666,287.33333333333331,515.66666666666663,621.66666666666663,383,730,448,740.66666666666663,582.66666666666663,424.33333333333331,6098.666666666667,null,null,null,"Chattanooga","Cleveland","Columbia","Dyersburg","Jackson","Motlow","Nashville","Northeast","Pellissippi","Roane","Southwest","Volunteer","Walters",null,"sub pops","Chattanooga","Cleveland","Columbia","Dyersburg","Jackson","Motlow","Nashville","Northeast","Pellissippi","Roane","Southwest","Volunteer","Walters"]
[null,"Workforce Training (Contact Hours)",185122.33333333334,6295.333333333333,61429.666666666664,6350,16351.166666666666,6603,36158.666666666664,6182.5,51527.6,97898.166666666672,67463.896666666507,80459.016666666663,173663.66666666666,795505.01333333307,null,null,"Students Accumulating 12 hrs",2461.6666666666665,1121.6666666666667,1572,1040,1224,1410,2339.3333333333335,1631,2922.3333333333335,1704.3333333333333,3667,2212.6666666666665,1963.6666666666667,null,"Adults Accumulating 12 hrs",748,362,341.66666666666669,303.66666666666669,317.33333333333331,307.66666666666669,1030,531.33333333333337,694.66666666666663,433.33333333333331,1242.6666666666667,560.33333333333337,475]
[null,"Awards per 100 FTE",15.289461588386908,15.387595731290846,17.395808799552093,13.108668392468303,17.149832911834618,17.676498840258365,10.930151074286307,17.891491472659876,14.281697415038996,19.329257519420363,10.113291516519242,14.592630097086074,17.175626753053212,200.3220121118552,null,null,"Students Accumulating 24 hrs",1880.6666666666667,810,1333.3333333333333,704,943.33333333333337,1105.3333333333333,1936.3333333333333,1384.6666666666667,2395.3333333333335,1313,2901.3333333333335,1687.3333333333333,1392.6666666666667,null,"Adults Accumulating 24 hrs",760.33333333333337,319.66666666666669,384.33333333333331,269,323.33333333333331,301,928.33333333333337,544,709.66666666666663,399,1210.3333333333333,560.66666666666663,394.33333333333331]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Students Accumulating 36 hrs",1628,669.33333333333337,1067.3333333333333,538,773.33333333333337,952,1666.3333333333333,1201.3333333333333,2017,1135.6666666666667,2206.3333333333335,1433.6666666666667,1204.6666666666667,null,"Adults Accumulating 36 hrs",736.33333333333337,299,358,237.33333333333334,290.33333333333331,294.33333333333331,870,522.66666666666663,718,386.66666666666669,1084.3333333333333,526,399.66666666666669]
[null,"Est. Sub-population Outcomes (10-11 to 12-13 Data)","Chattanooga","Cleveland","Columbia","Dyersburg","Jackson","Motlow","Nashville","Northeast","Pellissippi","Roane","Southwest","Volunteer","Walters","All CC",null,null,"Dual Enrollment",1167.6666666666667,622.66666666666663,769.33333333333337,818.33333333333337,862,833.33333333333337,1069.3333333333333,624.66666666666663,1327.6666666666667,1553,394.33333333333331,1625.6666666666667,1226.3333333333333,null,"Adult Associates",572,208.66666666666666,281,171,305.33333333333331,266.33333333333331,443.33333333333331,406,554.66666666666663,425.33333333333331,607.66666666666663,429,371.66666666666669]
[null,"Adults Accumulating 12 hrs",{"$f":"(AVERAGE(AI96,AI82,AI68*(1+C$24)))","v":748},362,341.66666666666669,303.66666666666669,317.33333333333331,307.66666666666669,1030,531.33333333333337,694.66666666666663,433.33333333333331,1242.6666666666667,560.33333333333337,475,{"$f":"SUM(C86:O86)","v":7347.666666666667},null,null,"Associates",913.33333333333337,365.33333333333331,583.33333333333337,280,546.33333333333337,573.66666666666663,624.33333333333337,726.66666666666663,1097,787.33333333333337,848.66666666666663,757.66666666666663,783,null,"Adult 1-2 Year Certificates",104.66666666666667,29.333333333333332,32.333333333333336,17,11,0.33333333333333331,64.333333333333329,69.666666666666671,0,55.333333333333336,41,56.666666666666664,11.333333333333334]
[null,"Adults Accumulating 24 hrs",760.33333333333337,319.66666666666669,384.33333333333331,269,323.33333333333331,301,928.33333333333337,544,709.66666666666663,399,1210.3333333333333,560.66666666666663,394.33333333333331,{"$f":"SUM(C87:O87)","v":7104},null,null,"Certificates 1-2 Years",166,39,50,24.333333333333332,22.666666666666668,0.33333333333333331,83.333333333333329,115.33333333333333,0,76,58.333333333333336,81,16,null," Adult <1yr Certificates",71,90,1.6666666666666667,6,14.666666666666666,27.333333333333332,122.66666666666667,8,207.66666666666666,16.333333333333332,210.66666666666666,180.33333333333334,158.66666666666666]
[null,"Adults Accumulating 36 hrs",736.33333333333337,299,358,237.33333333333334,290.33333333333331,294.33333333333331,870,522.66666666666663,718,386.66666666666669,1084.3333333333333,526,399.66666666666669,{"$f":"SUM(C88:O88)","v":6722.666666666667},null,null,"Certificates < 1 Year",109,154.66666666666666,1.6666666666666667,10,29.333333333333332,31.666666666666668,152.33333333333334,12.666666666666666,448.33333333333331,20.666666666666668,329.33333333333331,304.66666666666669,249,null,"Low-income Accumulating 12 hrs",1393.6666666666667,704.33333333333337,860,674.66666666666663,849.66666666666663,777,1610,1059,1563,1060.3333333333333,2568,1226,1220]
[null,"Adult Associates",572,208.66666666666666,281,171,305.33333333333331,266.33333333333331,443.33333333333331,406,554.66666666666663,425.33333333333331,607.66666666666663,429,371.66666666666669,{"$f":"SUM(C89:O89)","v":5042},null,null,"Job Placements",405.66666666666669,202,228.66666666666666,106.66666666666667,306.66666666666669,82.666666666666671,320.33333333333331,261.66666666666669,298,402.33333333333331,429,371,506,null,"Low-income Accumulating 24 hrs",1169,551,775,511.33333333333331,707,659.66666666666663,1341.3333333333333,954.66666666666663,1368,902.66666666666663,2049.3333333333335,1056,948]
[null,"Adult Certificates 1-2 Years",104.66666666666667,29.333333333333332,32.333333333333336,17,11,0.33333333333333331,64.333333333333329,69.666666666666671,0,55.333333333333336,41,56.666666666666664,11.333333333333334,{"$f":"SUM(C90:O90)","v":493},null,null,"Remedial & Developmental Success",2627.6666666666665,934.33333333333337,1422,1070.6666666666667,1338,1584,2889,1819.6666666666667,2628.6666666666665,1586.3333333333333,4446.333333333333,2240.3333333333335,1736,null,"Low-income Accumulating 36 hrs",1018.6666666666666,465.66666666666669,631.66666666666663,404,578.33333333333337,581.33333333333337,1171.3333333333333,841.66666666666663,1205.3333333333333,803.33333333333337,1605,911.33333333333337,839.33333333333337]
[null,"Adult Certificates < 1 Year",71,90,1.6666666666666667,6,14.666666666666666,27.333333333333332,122.66666666666667,8,207.66666666666666,16.333333333333332,210.66666666666666,180.33333333333334,158.66666666666666,{"$f":"SUM(C91:O91)","v":1115},null,null,"Transfers Out with 12 hrs",510.66666666666669,214,424,216.66666666666666,287.33333333333331,515.66666666666663,621.66666666666663,383,730,448,740.66666666666663,582.66666666666663,424.33333333333331,null,"Low-income Associates",550.33333333333337,251.66666666666666,350,204.66666666666666,379.33333333333331,350.33333333333331,418.33333333333331,495,683.33333333333337,522,597.66666666666663,477.33333333333331,529.33333333333337]
[null,"Low-income Accumulating 12 hrs",{"$f":"(AVERAGE(AI102,AI88,AI74*(1+C$25)))","v":1393.6666666666667},704.33333333333337,860,674.66666666666663,849.66666666666663,777,1610,1059,1563,1060.3333333333333,2568,1226,1220,15565.666666666666,null,null,"Workforce Training (Contact Hours)",185122.33333333334,6295.333333333333,61429.666666666664,6350,16351.166666666666,6603,36158.666666666664,6182.5,51527.6,97898.166666666672,67463.896666666507,80459.016666666663,173663.66666666666,null,"Low-income 1-2 Year Certificates",80,27,21.333333333333332,17,15.333333333333334,0,44.333333333333336,73.333333333333329,0,48.333333333333336,30.333333333333332,44.666666666666664,9]
[null,"Low-income Accumulating 24 hrs",1169,551,775,511.33333333333331,707,659.66666666666663,1341.3333333333333,954.66666666666663,1368,902.66666666666663,2049.3333333333335,1056,948,12993,null,null,"Awards per 100 FTE",15.289461588386908,15.387595731290846,17.395808799552093,13.108668392468303,17.149832911834618,17.676498840258365,10.930151074286307,17.891491472659876,14.281697415038996,19.329257519420363,10.113291516519242,14.592630097086074,17.175626753053212,null,"Low-income <1yr Certificates",62,91,1.3333333333333333,6.333333333333333,19,13.666666666666666,75,9,257.33333333333331,12.333333333333334,208.66666666666666,162,143]
[null,"Low-income Accumulating 36 hrs",1018.6666666666666,465.66666666666669,631.66666666666663,404,578.33333333333337,581.33333333333337,1171.3333333333333,841.66666666666663,1205.3333333333333,803.33333333333337,1605,911.33333333333337,839.33333333333337,11057]
[null,"Low-income Associates",550.33333333333337,251.66666666666666,350,204.66666666666666,379.33333333333331,350.33333333333331,418.33333333333331,495,683.33333333333337,522,597.66666666666663,477.33333333333331,529.33333333333337,5809.333333333333,null,null,null,"Chattanooga","Cleveland","Columbia","Dyersburg","Jackson","Motlow","Nashville","Northeast","Pellissippi","Roane","Southwest","Volunteer","Walters",null,"sub pops","Chattanooga","Cleveland","Columbia","Dyersburg","Jackson","Motlow","Nashville","Northeast","Pellissippi","Roane","Southwest","Volunteer","Walters"]
[null,"Low-income Certificates 1-2 Years",80,27,21.333333333333332,17,15.333333333333334,0,44.333333333333336,73.333333333333329,0,48.333333333333336,30.333333333333332,44.666666666666664,9,410.66666666666669,null,null,"Students Accumulating 12 hrs",2461.6666666666665,1121.6666666666667,1572,1040,1224,1410,2339.3333333333335,1631,2922.3333333333335,1704.3333333333333,3667,2212.6666666666665,1963.6666666666667,null,"Adults Accumulating 12 hrs",748,362,341.66666666666669,303.66666666666669,317.33333333333331,307.66666666666669,1030,531.33333333333337,694.66666666666663,433.33333333333331,1242.6666666666667,560.33333333333337,475]
[null,"Low-income Certificates < 1 Year",62,91,1.3333333333333333,6.333333333333333,19,13.666666666666666,75,9,257.33333333333331,12.333333333333334,208.66666666666666,162,143,1060.6666666666667,null,null,"Students Accumulating 24 hrs",1880.6666666666667,810,1333.3333333333333,704,943.33333333333337,1105.3333333333333,1936.3333333333333,1384.6666666666667,2395.3333333333335,1313,2901.3333333333335,1687.3333333333333,1392.6666666666667,null,"Adults Accumulating 24 hrs",760.33333333333337,319.66666666666669,384.33333333333331,269,323.33333333333331,301,928.33333333333337,544,709.66666666666663,399,1210.3333333333333,560.66666666666663,394.33333333333331]
[null,"Sub-population Premium = 40%",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Students Accumulating 36 hrs",1628,669.33333333333337,1067.3333333333333,538,773.33333333333337,952,1666.3333333333333,1201.3333333333333,2017,1135.6666666666667,2206.3333333333335,1433.6666666666667,1204.6666666666667,null,"Adults Accumulating 36 hrs",736.33333333333337,299,358,237.33333333333334,290.33333333333331,294.33333333333331,870,522.66666666666663,718,386.66666666666669,1084.3333333333333,526,399.66666666666669]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dual Enrollment",1167.6666666666667,622.66666666666663,769.33333333333337,818.33333333333337,862,833.33333333333337,1069.3333333333333,624.66666666666663,1327.6666666666667,1553,394.33333333333331,1625.6666666666667,1226.3333333333333,null,"Adult Associates",572,208.66666666666666,281,171,305.33333333333331,266.33333333333331,443.33333333333331,406,554.66666666666663,425.33333333333331,607.66666666666663,429,371.66666666666669]
["Scale","Est. Scaled Outcomes (10-11 to 12-13 Data)","Chattanooga","Cleveland","Columbia","Dyersburg","Jackson","Motlow","Nashville","Northeast","Pellissippi","Roane","Southwest","Volunteer","Walters","All CC",null,null,"Associates",913.33333333333337,365.33333333333331,583.33333333333337,280,546.33333333333337,573.66666666666663,624.33333333333337,726.66666666666663,1097,787.33333333333337,848.66666666666663,757.66666666666663,783,null,"Adult 1-2 Year Certificates",104.66666666666667,29.333333333333332,32.333333333333336,17,11,0.33333333333333331,64.333333333333329,69.666666666666671,0,55.333333333333336,41,56.666666666666664,11.333333333333334]
[2,"Students Accumulating 12 hrs (Scale=2)",{"$f":"C72/$A101","v":1230.8333333333333},{"$f":"D72/$A101","v":560.83333333333337},786,520,612,705,1169.6666666666667,815.5,1461.1666666666667,852.16666666666663,1833.5,1106.3333333333333,981.83333333333337,{"$f":"SUM(C101:O101)","v":12634.833333333334},null,null,"Certificates 1-2 Years",166,39,50,24.333333333333332,22.666666666666668,0.33333333333333331,83.333333333333329,115.33333333333333,0,76,58.333333333333336,81,16,null," Adult <1yr Certificates",71,90,1.6666666666666667,6,14.666666666666666,27.333333333333332,122.66666666666667,8,207.66666666666666,16.333333333333332,210.66666666666666,180.33333333333334,158.66666666666666]
[2,"Students Accumulating 24 hrs(Scale=2)",940.33333333333337,405,666.66666666666663,352,471.66666666666669,552.66666666666663,968.16666666666663,692.33333333333337,1197.6666666666667,656.5,1450.6666666666667,843.66666666666663,696.33333333333337,9893.6666666666661,null,null,"Certificates < 1 Year",109,154.66666666666666,1.6666666666666667,10,29.333333333333332,31.666666666666668,152.33333333333334,12.666666666666666,448.33333333333331,20.666666666666668,329.33333333333331,304.66666666666669,249,null,"Low-income Accumulating 12 hrs",1393.6666666666667,704.33333333333337,860,674.66666666666663,849.66666666666663,777,1610,1059,1563,1060.3333333333333,2568,1226,1220]
[2,"Students Accumulating 36 hrs (Scale=2)",814,334.66666666666669,533.66666666666663,269,386.66666666666669,476,833.16666666666663,600.66666666666663,1008.5,567.83333333333337,1103.1666666666667,716.83333333333337,602.33333333333337,8246.5,null,null,"Job Placements",405.66666666666669,202,228.66666666666666,106.66666666666667,306.66666666666669,82.666666666666671,320.33333333333331,261.66666666666669,298,402.33333333333331,429,371,506,null,"Low-income Accumulating 24 hrs",1169,551,775,511.33333333333331,707,659.66666666666663,1341.3333333333333,954.66666666666663,1368,902.66666666666663,2049.3333333333335,1056,948]
[2,"Dual Enrollment (Scale=2)",583.83333333333337,311.33333333333331,384.66666666666669,409.16666666666669,431,416.66666666666669,534.66666666666663,312.33333333333331,663.83333333333337,776.5,197.16666666666666,812.83333333333337,613.16666666666663,6447.166666666667,null,null,"Remedial & Developmental Success",2627.6666666666665,934.33333333333337,1422,1070.6666666666667,1338,1584,2889,1819.6666666666667,2628.6666666666665,1586.3333333333333,4446.333333333333,2240.3333333333335,1736,null,"Low-income Accumulating 36 hrs",1018.6666666666666,465.66666666666669,631.66666666666663,404,578.33333333333337,581.33333333333337,1171.3333333333333,841.66666666666663,1205.3333333333333,803.33333333333337,1605,911.33333333333337,839.33333333333337]
[1.5,"Associates (Scale=1.5)",608.88888888888891,243.55555555555554,388.88888888888891,186.66666666666666,364.22222222222223,382.4444444444444,416.22222222222223,484.4444444444444,731.33333333333337,524.88888888888891,565.77777777777771,505.11111111111109,522,5924.4444444444443,null,null,"Transfers Out with 12 hrs",510.66666666666669,214,424,216.66666666666666,287.33333333333331,515.66666666666663,621.66666666666663,383,730,448,740.66666666666663,582.66666666666663,424.33333333333331,null,"Low-income Associates",550.33333333333337,251.66666666666666,350,204.66666666666666,379.33333333333331,350.33333333333331,418.33333333333331,495,683.33333333333337,522,597.66666666666663,477.33333333333331,529.33333333333337]
[1.5,"Certificates 1-2 Years(Scale=1.5)",110.66666666666667,26,33.333333333333336,16.222222222222221,15.111111111111112,0.22222222222222221,55.55555555555555,76.888888888888886,0,50.666666666666664,38.888888888888893,54,10.666666666666666,488.22222222222229,null,null,"Workforce Training (Contact Hours)",185122.33333333334,6295.333333333333,61429.666666666664,6350,16351.166666666666,6603,36158.666666666664,6182.5,51527.6,97898.166666666672,67463.896666666507,80459.016666666663,173663.66666666666,null,"Low-income 1-2 Year Certificates",80,27,21.333333333333332,17,15.333333333333334,0,44.333333333333336,73.333333333333329,0,48.333333333333336,30.333333333333332,44.666666666666664,9]
[1.5,"Certificates < 1 Year (Scale=1.5)",72.666666666666671,103.1111111111111,1.1111111111111112,6.666666666666667,19.555555555555554,21.111111111111111,101.55555555555556,8.4444444444444446,298.88888888888886,13.777777777777779,219.55555555555554,203.11111111111111,166,1235.5555555555557,null,null,"Awards per 100 FTE",15.289461588386908,15.387595731290846,17.395808799552093,13.108668392468303,17.149832911834618,17.676498840258365,10.930151074286307,17.891491472659876,14.281697415038996,19.329257519420363,10.113291516519242,14.592630097086074,17.175626753053212,null,"Low-income <1yr Certificates",62,91,1.3333333333333333,6.333333333333333,19,13.666666666666666,75,9,257.33333333333331,12.333333333333334,208.66666666666666,162,143]
[0.5,"Job Placements (Scale=0.5)",811.33333333333337,404,457.33333333333331,213.33333333333334,613.33333333333337,165.33333333333334,640.66666666666663,523.33333333333337,596,804.66666666666663,858,742,1012,7841.3333333333339]
[5,"Remedial & Developmental Success (Scale=5)",525.5333333333333,186.86666666666667,284.39999999999998,214.13333333333335,267.60000000000002,316.8,577.79999999999995,363.93333333333334,525.73333333333335,317.26666666666665,889.26666666666665,448.06666666666672,347.2,5264.5999999999995]
[2,"Transfers Out with 12 hrs (Scale=2)",255.33333333333334,107,212,108.33333333333333,143.66666666666666,257.83333333333331,310.83333333333331,191.5,365,224,370.33333333333331,291.33333333333331,212.16666666666666,3049.3333333333335]
[50,"Workforce Training (Contact Hours) (Scale=50)",3702.4466666666667,125.90666666666667,1228.5933333333332,127,327.02333333333331,132.06,723.17333333333329,123.65,1030.5519999999999,1957.9633333333334,1349.2779333333301,1609.1803333333332,3473.2733333333331,15910.100266666663]
[0.05,"Awards per 100 FTE (Scale=0.05)",305.78923176773816,307.75191462581688,347.91617599104183,262.17336784936606,342.99665823669233,353.52997680516728,218.60302148572615,357.82982945319748,285.63394830077993,386.58515038840721,202.26583033038483,291.85260194172145,343.51253506106423,4006.4402422371036,"Sub-pop premium"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.4]
[null,"Est. Scaled Sub-pop Outcomes (10-11 to 12-13 Data)","Chattanooga","Cleveland","Columbia","Dyersburg","Jackson","Motlow","Nashville","Northeast","Pellissippi","Roane","Southwest","Volunteer","Walters","All CC"]
[null,"Adults Accumulating 12 hrs",{"$f":"(C86/$A101)*$Q$113","v":149.6},72.400000000000006,68.333333333333343,60.733333333333341,63.466666666666669,61.533333333333339,206,106.26666666666668,138.93333333333334,86.666666666666671,248.53333333333336,112.06666666666668,95,{"$f":"SUM(C115:O115)","v":1469.5333333333335}]
[null,"Adults Accumulating 24 hrs",152.06666666666669,63.933333333333337,76.866666666666674,53.800000000000004,64.666666666666671,60.2,185.66666666666669,108.80000000000001,141.93333333333334,79.800000000000011,242.06666666666666,112.13333333333333,78.866666666666674,1420.8000000000002]
[null,"Adults Accumulating 36 hrs",147.26666666666668,59.800000000000004,71.600000000000009,47.466666666666669,58.066666666666663,58.866666666666667,174,104.53333333333333,143.6,77.333333333333343,216.86666666666667,105.2,79.933333333333337,1344.5333333333335]
[null,"Adult Associates",{"$f":"(C89/$A105)*$Q$113","v":152.53333333333333},55.644444444444446,74.933333333333337,45.6,81.422222222222217,71.022222222222226,118.22222222222223,108.26666666666668,147.91111111111113,113.42222222222222,162.04444444444445,114.4,99.111111111111128,1344.5333333333333]
[null,"Adult Certificates 1-2 Years",27.911111111111115,7.822222222222222,8.6222222222222236,4.5333333333333341,2.9333333333333336,8.8888888888888892E-2,17.155555555555555,18.577777777777779,0,14.755555555555558,10.933333333333334,15.111111111111112,3.0222222222222226,131.46666666666667]
[null,"Adult Certificates < 1 Year",18.933333333333334,24,0.44444444444444448,1.6,3.911111111111111,7.2888888888888888,32.711111111111116,2.1333333333333333,55.377777777777773,4.3555555555555552,56.177777777777777,48.088888888888896,42.31111111111111,297.33333333333337]
[null,"Low-income Accumulating 12 hrs",{"$f":"(C92/$A101)*$Q$113","v":278.73333333333335},140.86666666666667,172,134.93333333333334,169.93333333333334,155.4,322,211.8,312.60000000000002,212.06666666666666,513.6,245.20000000000002,244,3113.1333333333332]
[null,"Low-income Accumulating 24 hrs",233.8,110.2,155,102.26666666666667,141.4,131.93333333333334,268.26666666666665,190.93333333333334,273.60000000000002,180.53333333333333,409.86666666666673,211.20000000000002,189.60000000000002,2598.6]
[null,"Low-income Accumulating 36 hrs",203.73333333333335,93.13333333333334,126.33333333333333,80.800000000000011,115.66666666666669,116.26666666666668,234.26666666666665,168.33333333333334,241.06666666666666,160.66666666666669,321,182.26666666666668,167.86666666666667,2211.4]
[null,"Low-income Associates",{"$f":"(C95/$A105)*$Q$113","v":146.75555555555556},67.111111111111114,93.333333333333343,54.577777777777776,101.15555555555557,93.422222222222217,111.55555555555554,132,182.22222222222226,139.20000000000002,159.37777777777777,127.28888888888889,141.15555555555557,1549.1555555555556]
[null,"Low-income Certificates 1-2 Years",21.333333333333336,7.2,5.6888888888888891,4.5333333333333341,4.0888888888888895,0,11.822222222222223,19.555555555555557,0,12.888888888888889,8.0888888888888886,11.911111111111111,2.4000000000000004,109.51111111111112]
[null,"Low-income Certificates < 1 Year",16.533333333333335,24.266666666666666,0.35555555555555557,1.6888888888888891,5.0666666666666664,3.6444444444444444,20,2.4000000000000004,68.62222222222222,3.2888888888888896,55.644444444444446,43.2,38.133333333333333,282.84444444444443]
[]
[null,"Weights Based on Institutional Mission","Chattanooga","Cleveland","Columbia","Dyersburg","Jackson","Motlow","Nashville","Northeast","Pellissippi","Roane","Southwest","Volunteer","Walters","Average"]
[null,"Students Accumulating 12 hrs",0.06,0.06,0.04,0.06,0.06,0.06,0.04,0.04,0.06,0.02,0.04,0.02,0.04,{"$f":"AVERAGE(C129:O129)","v":4.6153846153846163E-2}]
[null,"Students Accumulating 24 hrs",7.0000000000000007E-2,7.0000000000000007E-2,0.05,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,0.05,0.05,7.0000000000000007E-2,0.03,0.05,0.03,0.05,{"$f":"AVERAGE(C130:O130)","v":5.6153846153846172E-2}]
[null,"Students Accumulating 36 hrs",7.0000000000000007E-2,7.0000000000000007E-2,0.06,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,0.06,0.06,7.0000000000000007E-2,0.05,0.06,0.05,0.06,6.30769230769231E-2]
[null,"Dual Enrollment",0.05,0.1,0.1,0.05,0.05,0.05,0.05,0.05,0.1,0.1,0.05,0.1,0.1,7.3076923076923067E-2]
[null,"Associates",0.05,0.15,0.1,0.1,0.2,0.1,0.2,0.2,0.2,0.2,0.1,0.2,0.2,0.15384615384615385]
[null,"Certificates 1-2 Years",0.05,0.01,0.04,0.02,0.03,0,7.0000000000000007E-2,0.17,0,0.06,0.02,0.04,0.01,0.04,null,"Original Weighted Outcomes"]
[null,"Certificates < 1 Year",0.05,0.09,0.01,0.08,7.0000000000000007E-2,0.05,0.13,0.03,0.05,0.14000000000000001,0.18,0.16,0.19,9.4615384615384615E-2,null,"Chattanooga","Cleveland","Columbia","Dyersburg","Jackson","Motlow","Nashville","Northeast","Pellissippi","Roane","Southwest","Volunteer","Walters","All CC"]
[null,"Job Placements",0.2,0.05,0.05,0.1,0.05,0.1,0.1,0.1,0.1,0.15,0.1,0.05,0.05,9.2307692307692327E-2,null,1000.5909060328313,311.18781795351305,450.70267964265292,256.62700172580162,406.78883249033589,389.56827429855286,595.42181774095309,459.50548294531978,883.00234185948352,607.85542418608713,836.66236858859395,616.14353565264162,710.21262675305331,{"$f":"SUM(R136:AD136)","v":7524.2691098698206}]
[null,"Remedial & Developmental Success",0.1,0.2,0.1,0.2,0.15,0.1,0.1,0.05,0.05,0.05,0.2,0.1,0.1,0.1153846153846154]
[null,"Transfers Out with 12 hrs",0.15,0.1,0.2,0.15,0.1,0.2,0.1,0.1,0.15,0.1,0.05,0.15,0.1,0.12692307692307692,null,"Change in Weighted Outcomes"]
[null,"Workforce Training (Contact Hours)",0.1,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.1,0.05,0.05,0.05,0.05,5.7692307692307702E-2,null,{"$f":"C156-R136","v":0},{"$f":"D156-S136","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Awards per 100 FTE",0.05,0.05,0.2,0.05,0.1,0.15,0.05,0.1,0.05,0.05,0.1,0.05,0.05,8.0769230769230788E-2,null,{"$f":"R139/R136","v":0},{"$f":"S139/S136","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"SUM(C129:C140)","v":1},1,1,1,1.0000000000000002,1,1,1.0000000000000002,1,1.0000000000000002,1.0000000000000002,1,1,{"$f":"(SUM(P129:P140))","v":1}]
[]
[null,"Weighted Outcomes","Chattanooga","Cleveland","Columbia","Dyersburg","Jackson","Motlow","Nashville","Northeast","Pellissippi","Roane","Southwest","Volunteer","Walters","All CC"]
[null,"Students Accumulating 12 hrs",{"$f":"IF(C101=\"NA\",0, ((C101+C115+C121)*C129))","v":99.549999999999983},{"$f":"IF(D101=\"NA\",0, ((D101+D115+D121)*D129))","v":46.445999999999998},41.053333333333342,42.940000000000005,50.724000000000004,55.315999999999995,67.906666666666666,45.342666666666666,114.76200000000001,23.017999999999997,103.82533333333333,29.271999999999998,52.833333333333343,{"$f":"SUM(C144:O144)","v":772.98933333333343}]
[null,"Students Accumulating 24 hrs",92.834000000000017,40.539333333333339,44.926666666666669,35.564666666666668,47.44133333333334,52.136000000000003,71.105000000000004,49.603333333333346,112.92400000000004,27.504999999999995,105.13,35.01,48.240000000000009,762.95933333333346,null,null,"For Dynamic Formula Tab Display:"]
[null,"Students Accumulating 36 hrs",81.550000000000011,34.132000000000005,43.896000000000001,27.808666666666671,39.228000000000009,45.579333333333338,74.486000000000004,52.411999999999999,97.521666666666661,40.291666666666679,98.461999999999989,50.215000000000003,51.007999999999996,736.59033333333343,null,null,"2015-16","2015-16","Percent "]
[null,"Dual Enrollment",{"$f":"C104*C132","v":29.19166666666667},31.133333333333333,38.466666666666669,20.458333333333336,21.55,20.833333333333336,26.733333333333334,15.616666666666667,66.38333333333334,77.650000000000006,9.8583333333333343,81.283333333333346,61.316666666666663,500.47500000000002,null,null,"Formula Calculation","State Appr*","Funded"]
[null,"Associates",{"$f":"IF(C105=\"NA\",0, ((C105+C118+C124)*C133))","v":45.408888888888896},54.946666666666665,55.715555555555561,28.684444444444445,109.36,54.688888888888897,129.20000000000002,144.94222222222223,212.29333333333335,155.50222222222226,88.72,149.35999999999999,152.45333333333335,1381.2755555555555,null,"Chattanooga",{"$f":"Working!J15","v":42730000},{"$f":"ROUND(Working!K15,-2)","v":26034800},{"$f":"Working!L15","v":0.60928674901547053}]
[null,"Certificates 1-2 Years",7.9955555555555566,0.41022222222222227,1.9057777777777782,0.50577777777777788,0.66399999999999992,0,5.9173333333333336,19.553777777777778,0,4.6986666666666661,1.1582222222222223,3.2408888888888892,0.16088888888888889,46.211111111111123,null,"Cleveland",{"$f":"Working!J16","v":14530000},{"$f":"ROUND(Working!K16,-2)","v":8852900},{"$f":"Working!L16","v":0.60928674901547053}]
[null,"Certificates < 1 Year",5.4066666666666672,13.623999999999999,1.9111111111111113E-2,0.79644444444444451,1.9973333333333334,1.6022222222222222,20.05466666666667,0.38933333333333331,21.144444444444446,2.9991111111111115,59.648000000000003,47.104000000000006,46.824444444444445,221.60977777777779,null,"Columbia",{"$f":"Working!J17","v":20290700},{"$f":"ROUND(Working!K17,-2)","v":12362900},{"$f":"Working!L17","v":0.60928674901547053}]
[null,"Job Placements",{"$f":"C108*C136","v":162.26666666666668},20.200000000000003,22.866666666666667,21.333333333333336,30.666666666666671,16.533333333333335,64.066666666666663,52.333333333333343,59.6,120.69999999999999,85.800000000000011,37.1,50.6,744.06666666666683,null,"Dyersburg",{"$f":"Working!J18","v":12024000},{"$f":"ROUND(Working!K18,-2)","v":7326100},{"$f":"Working!L18","v":0.60928674901547053}]
[null,"Remedial & Developmental Success",{"$f":"C109*C137","v":52.553333333333335},37.373333333333335,28.439999999999998,42.826666666666675,40.14,31.680000000000003,57.78,18.196666666666669,26.286666666666669,15.863333333333333,177.85333333333335,44.806666666666672,34.72,608.52000000000021,null,"Jackson",{"$f":"Working!J19","v":18229000},{"$f":"ROUND(Working!K19,-2)","v":11106700},{"$f":"Working!L19","v":0.60928674901547053}]
[null,"Transfers Out with 12 hrs",{"$f":"C110*C138","v":38.299999999999997},10.700000000000001,42.400000000000006,16.25,14.366666666666667,51.566666666666663,31.083333333333332,19.150000000000002,54.75,22.400000000000002,18.516666666666666,43.699999999999996,21.216666666666669,384.4,null,"Motlow",{"$f":"Working!J20","v":17508000},{"$f":"ROUND(Working!K20,-2)","v":10667400},{"$f":"Working!L20","v":0.60928674901547053}]
[null,"Workforce Training (Contact Hours)",370.24466666666672,6.2953333333333337,61.429666666666662,6.3500000000000005,16.351166666666668,6.6030000000000006,36.158666666666669,6.182500000000001,103.0552,97.898166666666668,67.463896666666514,80.45901666666667,173.66366666666667,1032.1549466666665,null,"Nashville",{"$f":"Working!J21","v":26060000},{"$f":"ROUND(Working!K21,-2)","v":15878000},{"$f":"Working!L21","v":0.60928674901547053}]
[null,"Awards per 100 FTE",15.289461588386908,15.387595731290844,69.583235198208371,13.108668392468303,34.299665823669237,53.029496520775091,10.930151074286307,35.782982945319752,14.281697415038998,19.329257519420363,20.226583033038484,14.592630097086072,17.175626753053212,333.01705209204198,null,"Northeast ",{"$f":"Working!J22","v":21726000},{"$f":"ROUND(Working!K22,-2)","v":13237400},{"$f":"Working!L22","v":0.60928674901547053}]
[null,"Total",{"$f":"SUM(C144:C155)","v":1000.5909060328313},311.18781795351305,450.70267964265292,256.62700172580162,406.78883249033589,389.56827429855286,595.42181774095309,459.50548294531978,883.00234185948352,607.85542418608713,836.66236858859395,{"$f":"SUM(N144:N155)","v":616.14353565264162},{"$f":"SUM(O144:O155)","v":710.21262675305331},7524.2691098698187,null,"Pellissippi",{"$f":"Working!J23","v":38498000},{"$f":"ROUND(Working!K23,-2)","v":23456300},{"$f":"Working!L23","v":0.60928674901547053}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Roane",{"$f":"Working!J24","v":28591000},{"$f":"ROUND(Working!K24,-2)","v":17420100},{"$f":"Working!L24","v":0.60928674901547053}]
[null,"SREB Avg Salary",54621.269166583021,54621.269166583021,54621.269166583021,54621.269166583021,54621.269166583021,54621.269166583021,54621.269166583021,54621.269166583021,54621.269166583021,54621.269166583021,54621.269166583021,54621.269166583021,54621.269166583021,54621.269166583021,null,"Southwest",{"$f":"Working!J25","v":40541000},{"$f":"ROUND(Working!K25,-2)","v":24701100},{"$f":"Working!L25","v":0.60928674901547053}]
[null,"Outcome Based Performance",{"$f":"C156*C158","v":54653545.20405446},{"$f":"D156*D158","v":16997473.565800473},24617952.378861584,14017292.536678176,22219322.313414689,21278713.569222502,32522695.374484736,25098772.667477034,48230708.589430004,33201834.738835763,45699560.436228484,33654541.906133078,38792715.051384486,{"$f":"P156*P158","v":410985128.33200538},null,"Volunteer",{"$f":"Working!J26","v":26644000},{"$f":"ROUND(Working!K26,-2)","v":16233800},{"$f":"Working!L26","v":0.60928674901547053}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Walters",{"$f":"Working!J27","v":33438000},{"$f":"ROUND(Working!K27,-2)","v":20373300},{"$f":"Working!L27","v":0.60928674901547053}]
[null,"Fixed Costs"]
[null,"M&O & Utilities",8180769.1816084106,3592951.0519396998,4150871.7746485099,3083398.7010536743,3449965.5053191753,3731132.8215527548,4630556.8206150653,4986303.0359896682,6589231.2697143247,7526313.9457875397,11455378.364055503,4183166.5457383092,8690385.2818589192,{"$f":"SUM(C162:O162)","v":74250424.299881563}]
[null,"Equipment Replacement",1224978.2640000002,393577.59100000001,402964.92599999998,181622.23300000001,534831.07299999997,267371.99400000001,464424.87699999998,847046.83600000001,1100183.99,504453.12100000004,1249002.6570000001,611813.21100000001,651870.42599999998,{"$f":"SUM(C163:O163)","v":8434141.199000001},"PF Percentage"]
[null,"Fixed Costs Subtotal",{"$f":"SUM(C162:C163)","v":9405747.445608411},3986528.6429396998,4553836.7006485099,3265020.9340536743,3984796.5783191752,3998504.8155527548,5094981.6976150656,5833349.8719896683,7689415.259714325,8030767.06678754,12704381.021055503,4794979.7567383088,9342255.7078589201,82684565.498881564,5.45E-2]
[]
[null,"Formula Subtotal",{"$f":"C164+C159","v":64059292.649662867},{"$f":"D164+D159","v":20984002.208740175},29171789.079510093,17282313.470731851,26204118.891733862,25277218.384775259,37617677.072099805,30932122.539466701,55920123.849144332,41232601.8056233,58403941.457283989,38449521.662871391,48134970.759243406,493669693.83088696]
[]
[null,"Performance Funding: Quality Assurance Score",97,89,92,95,98,93,97,100,92,98,96,98,100,{"$f":"AVERAGE(C168:O168)","v":95.769230769230774}]
[null,"Performance Funding: Quality Assurance Amount",{"$f":"$Q$164*C168/100*C166","v":3386494.5059244274},{"$f":"$Q$164*D168/100*D166","v":1017829.0271349421},1462673.5044466362,894791.77994714165,1399561.9900075055,1281175.813832334,1988658.4984165563,1685800.6784009351,2803835.0097960969,2202233.2624383406,3055694.2170450985,2053588.952013961,2623355.9063787656]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Out of State Tuition Calculation:"]
[null,"2012-13 FTE",6905.333333333333,2523.7666666666669,3479.3,2216.9666666666667,2978.9,3042.1333333333332,6449.4666666666662,4487.1333333333332,7444.5,4268.5666666666666,8063.9666666666662,5375.3666666666668,4399.3666666666668]
[null,"per FTE subsidy",{"$f":"C166*C65/C178","v":6184.5233297608474},5543.0381067294056,5589.5896836547745,5196.9849105329658,5864.3836968307896,5539.3623739426848,3888.4535229889611,4595.6769042546393,5007.7349138419258,6439.7263414921954,4828.3881346470507,4768.6076190611975,7294.2273144230467]
[null,"OSFTE",343,23.7,34.93333333333333,17.233333333333334,28,33.866666666666667,84.15,4.0666666666666664,123.86666666666666,76,85.033333333333331,71.333333333333329,52.1]
[null,"OS tuit est.",{"$f":"C180*C179","v":2121291.5021079709},{"$f":"D180*D179","v":131370.0031294869},195262.99961567344,89561.373291518117,164202.74351126212,187599.73906419225,327213.36395952111,18689.0860773022,620291.43132788653,489419.20195340685,410573.93771615421,340160.67682636541,380029.24308144074]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"WORKING AREA------ 4yr"]
[null,null,"UTM","APSU","TTU","UTC","MTSU","ETSU","TSU","UM","UTK"]
[null,"Total Formula Calculation",{"$f":"ROUND(C297,-2)","v":78186000},{"$f":"ROUND(D297,-2)","v":100566000},116354000,112626300,243958200,157169000,111147400,281184100,539380400]
[]
[null,"Total",{"$f":"C200","v":78186000},{"$f":"D200","v":100566000},116354000,112626300,243958200,157169000,111147400,281184100,539380400]
[null,"2014-15 Phase-In Factor",1,1,1,1,1,1,1,1,1]
[null,"2015-16 Total Need Recommendation",{"$f":"C203*C202","v":78186000},{"$f":"D203*D202","v":100566000},116354000,112626300,243958200,157169000,111147400,281184100,539380400]
[null,"2014-15 Total Need Recommendation",79634000,103685000,118101900,114818000,251465500,152953000,105052300,279474000,544461000]
[null,"% Change",{"$f":"C204/C205-1","v":-1.8183188085491131E-2},{"$f":"D204/D205-1","v":-3.0081496841394606E-2},-1.4799931245814024E-2,-1.9088470448884287E-2,-2.9854194710606463E-2,2.7564022935149923E-2,5.8019672106179421E-2,6.1189949691204948E-3,-9.331430534051055E-3,null,null,null,"Three Years of the Three-Year Average:"]
[]
[null,"Subsidy/Fee Policy",0.55000000000000004,0.55000000000000004,0.55000000000000004,0.55000000000000004,0.55000000000000004,0.55000000000000004,0.55000000000000004,0.55000000000000004,0.55000000000000004]
[null,"Out of State Tuition Deduct",{"$f":"C306","v":2649833.778884022},1780364.4850798789,4876519.7058751946,3516899.7214287347,5707116.9382303664,11632122.750284461,11934150.989564242,15254061.780314319,21989434.418986734]
[null,"Legislative Initiatives",310000,0,700900,0,489500,0,1026300,65000,0]
[null,"2015-16 Recommendation",{"$f":"ROUND(((C297*C203*C208-C209)*(1+0.0545*C299/100)), -3)+C210","v":42686000},{"$f":"ROUND(((D297*D203*D208-D209)*(1+0.0545*D299/100)), -3)+D210","v":56186000},{"$f":"ROUND(((E297*E203*E208-E209)*(1+0.0545*E299/100)), -3)+E210","v":62960900},61485000,135820500,78623000,52609300,146528000,289041000,null,null,null,null,"UTM","APSU","TTU","UTC","MTSU","ETSU","TSU","UM","UTK",null,"sub pops","UTM","APSU","TTU","UTC","MTSU","ETSU","TSU","UM","UTK"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Students Accumulating 24 hrs",1276.3333333333333,1515.6666666666667,1688,1880.3333333333333,3175.3333333333335,1801,989.66666666666663,2233.3333333333335,3483,null,"Adults Accumulating 24 hrs",113.66666666666667,250,60,34.666666666666664,217.33333333333334,152,78,150,32.333333333333336]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Students Accumulating 48 hrs",1200.3333333333333,1421,1555.3333333333333,1604,3349.6666666666665,1723.3333333333333,867,2314.3333333333335,3877.6666666666665,null,"Adults Accumulating 48 hrs",151.66666666666666,352,94.666666666666671,53.333333333333336,337.33333333333331,192.33333333333334,123.66666666666667,296.66666666666669,82.333333333333329]
[null,"Outcomes (10-11 to 12-13 Data)","UTM","APSU","TTU","UTC","MTSU","ETSU","TSU","UM","UTK",null,null,null,"Students Accumulating 72 hrs",1236,1387,1641.6666666666667,1654.3333333333333,3775.3333333333335,1946,889.33333333333337,2534,4151,null,"Adults Accumulating 72 hrs",199.66666666666666,455.33333333333331,183.66666666666666,149.66666666666666,625.66666666666663,314.33333333333331,183.66666666666666,525.66666666666663,208.66666666666666]
[null,"Students Accumulating 24 hrs",{"$f":"(AVERAGE(P238,P225,(P212*(1+C30))))","v":1276.3333333333333},{"$f":"(AVERAGE(Q238,Q225,(Q212*(1+D30))))","v":1515.6666666666667},{"$f":"(AVERAGE(R238,R225,(R212*(1+E30))))","v":1688},{"$f":"(AVERAGE(S238,S225,(S212*(1+F30))))","v":1880.3333333333333},3175.3333333333335,1801,989.66666666666663,2233.3333333333335,3483,null,null,null,"Bachelors and Associates",1133.6666666666667,1582,1709.6666666666667,1490.6666666666667,3979.3333333333335,2162.6666666666665,1081.6666666666667,2763,4426,null,"Adults Bachelors and Associates",355,905.66666666666663,480.66666666666669,460.66666666666669,1518.6666666666667,836,546.33333333333337,1304.6666666666667,718.33333333333337]
[null,"Students Accumulating 48 hrs",{"$f":"(AVERAGE(P239,P226,(P213*(1+C31))))","v":1200.3333333333333},1421,1555.3333333333333,1604,3349.6666666666665,1723.3333333333333,867,2314.3333333333335,3877.6666666666665,null,null,null,"Masters/Ed Specialist Degrees",128.33333333333334,308.66666666666669,488,456,952.66666666666663,605,409.33333333333331,1038.3333333333333,1568.3333333333333,null,"Low-income Accumulating 24 hrs",702.66666666666663,851.33333333333337,680.33333333333337,733,1667.6666666666667,836,579.33333333333337,1186.6666666666667,1123.3333333333333]
[null,"Students Accumulating 72 hrs",1236,1387,1641.6666666666667,1654.3333333333333,3775.3333333333335,1946,889.33333333333337,2534,4151,null,null,null,"Doctoral / Law Degrees",0,0,17,60.666666666666664,21,82.666666666666671,68.333333333333329,262,539,null,"Low-income Accumulating 48 hrs",689.33333333333337,840,700.66666666666663,663.66666666666663,1765.6666666666667,828.33333333333337,524,1262,1276.3333333333333]
[null,"Bachelors and Associates",1133.6666666666667,1582,1709.6666666666667,1490.6666666666667,3979.3333333333335,2162.6666666666665,1081.6666666666667,2763,4426,null,null,null,"Research and Service",2895192.8166666664,3234935.4933333336,9618701.7599999998,10734921.923333334,24168097.459999997,23360636.333333332,32085374.333333332,56665628.666666664,151648065.61333331,null,"Low-income Accumulating 72 hrs",707,798.66666666666663,803,733,1997.6666666666667,965.33333333333337,558,1403.3333333333333,1447]
[null,"Masters/Ed Specialist Degrees",128.33333333333334,308.66666666666669,488,456,952.66666666666663,605,409.33333333333331,1038.3333333333333,1568.3333333333333,null,null,null,"Transfers Out with 12 hrs",249,206.33333333333334,321.33333333333331,536,624.66666666666663,382,213.66666666666666,425.33333333333331,550.66666666666663,null," Low-income Bachelors and Associates",628,877,879,694,2044.3333333333333,1061.6666666666667,687.33333333333337,1507.3333333333333,1540.3333333333333]
[null,"Doctoral / Law Degrees",0,0,17,60.666666666666664,21,82.666666666666671,68.333333333333329,262,539,null,null,null,"Degrees per 100 FTE",16.631487705368027,18.890211592409369,19.338162643264155,16.742126955388009,19.47340623013206,19.415232708891907,17.790710825410322,18.495829451301251,22.689954344121475]
[null,"Research and Service",2895192.8166666664,3234935.4933333336,9618701.7599999998,10734921.923333334,24168097.459999997,23360636.333333332,32085374.333333332,56665628.666666664,151648065.61333331,null,null,null,"Six-Year Graduation Rate",{"$f":"56.1292708817688/100","v":0.561292708817688},{"$f":"42.8055833770528/100","v":0.42805583377052797},{"$f":"56.3690318908031/100","v":0.56369031890803101},{"$f":"50.9250007513611/100","v":0.50925000751361094},{"$f":"52.126345800615/100","v":0.52126345800615004},{"$f":"49.1855925203052/100","v":0.49185592520305199},{"$f":"36.5671016390221/100","v":0.36567101639022098},{"$f":"45.5149886505684/100","v":0.455149886505684},{"$f":"71.5424817621804/100","v":0.71542481762180399}]
[null,"Transfers Out with 12 hrs",249,206.33333333333334,321.33333333333331,536,624.66666666666663,382,213.66666666666666,425.33333333333331,550.66666666666663]
[null,"Degrees per 100 FTE",16.631487705368027,18.890211592409369,19.338162643264155,16.742126955388009,19.47340623013206,19.415232708891907,17.790710825410322,18.495829451301251,22.689954344121475]
[null,"Six-Year Graduation Rate",{"$f":"(AVERAGE(P247,P234,(P221*(1+C39))))*100","v":56.129270881768804},{"$f":"(AVERAGE(Q247,Q234,(Q221*(1+D39))))*100","v":42.805583377052798},{"$f":"(AVERAGE(R247,R234,(R221*(1+E39))))*100","v":56.3690318908031},50.925000751361097,52.126345800615006,49.185592520305192,36.567101639022098,45.514988650568398,71.542481762180401,null,null,null,null,"UTM","APSU","TTU","UTC","MTSU","ETSU","TSU","UM","UTK",null,"sub pops","UTM","APSU","TTU","UTC","MTSU","ETSU","TSU","UM","UTK"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Students Accumulating 24 hrs",1276.3333333333333,1515.6666666666667,1688,1880.3333333333333,3175.3333333333335,1801,989.66666666666663,2233.3333333333335,3483,null,"Adults Accumulating 24 hrs",113.66666666666667,250,60,34.666666666666664,217.33333333333334,152,78,150,32.333333333333336]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Students Accumulating 48 hrs",1200.3333333333333,1421,1555.3333333333333,1604,3349.6666666666665,1723.3333333333333,867,2314.3333333333335,3877.6666666666665,null,"Adults Accumulating 48 hrs",151.66666666666666,352,94.666666666666671,53.333333333333336,337.33333333333331,192.33333333333334,123.66666666666667,296.66666666666669,82.333333333333329]
[null,"Sub-population Outcomes (10-11 to 12-13 Data)","UTM","APSU","TTU","UTC","MTSU","ETSU","TSU","UM","UTK",null,null,null,"Students Accumulating 72 hrs",1236,1387,1641.6666666666667,1654.3333333333333,3775.3333333333335,1946,889.33333333333337,2534,4151,null,"Adults Accumulating 72 hrs",199.66666666666666,455.33333333333331,183.66666666666666,149.66666666666666,625.66666666666663,314.33333333333331,183.66666666666666,525.66666666666663,208.66666666666666]
[null,"Adults Accumulating 24 hrs",{"$f":"(AVERAGE(AA238,AA225,(AA212*(1+C$40))))","v":113.66666666666667},{"$f":"(AVERAGE(AB238,AB225,(AB212*(1+D$40))))","v":250},60,34.666666666666664,217.33333333333334,152,78,150,32.333333333333336,null,null,null,"Bachelors and Associates",1133.6666666666667,1582,1709.6666666666667,1490.6666666666667,3979.3333333333335,2162.6666666666665,1081.6666666666667,2763,4426,null,"Adults Bachelors and Associates",355,905.66666666666663,480.66666666666669,460.66666666666669,1518.6666666666667,836,546.33333333333337,1304.6666666666667,718.33333333333337]
[null,"Adults Accumulating 48 hrs",{"$f":"(AVERAGE(AA239,AA226,(AA213*(1+C$40))))","v":151.66666666666666},352,94.666666666666671,53.333333333333336,337.33333333333331,192.33333333333334,123.66666666666667,296.66666666666669,82.333333333333329,null,null,null,"Masters/Ed Specialist Degrees",128.33333333333334,308.66666666666669,488,456,952.66666666666663,605,409.33333333333331,1038.3333333333333,1568.3333333333333,null,"Low-income Accumulating 24 hrs",702.66666666666663,851.33333333333337,680.33333333333337,733,1667.6666666666667,836,579.33333333333337,1186.6666666666667,1123.3333333333333]
[null,"Adults Accumulating 72 hrs",{"$f":"(AVERAGE(AA240,AA227,(AA214*(1+C$40))))","v":199.66666666666666},455.33333333333331,183.66666666666666,149.66666666666666,625.66666666666663,314.33333333333331,183.66666666666666,525.66666666666663,208.66666666666666,null,null,null,"Doctoral / Law Degrees",0,0,17,60.666666666666664,21,82.666666666666671,68.333333333333329,262,539,null,"Low-income Accumulating 48 hrs",689.33333333333337,840,700.66666666666663,663.66666666666663,1765.6666666666667,828.33333333333337,524,1262,1276.3333333333333]
[null,"Adults Bachelors and Associates",{"$f":"(AVERAGE(AA241,AA228,(AA215*(1+C$40))))","v":355},905.66666666666663,480.66666666666669,460.66666666666669,1518.6666666666667,836,546.33333333333337,1304.6666666666667,718.33333333333337,null,null,null,"Research and Service",2895192.8166666664,3234935.4933333336,9618701.7599999998,10734921.923333334,24168097.459999997,23360636.333333332,32085374.333333332,56665628.666666664,151648065.61333331,null,"Low-income Accumulating 72 hrs",707,798.66666666666663,803,733,1997.6666666666667,965.33333333333337,558,1403.3333333333333,1447]
[null,"Low-income Accumulating 24 hrs",{"$f":"(AVERAGE(AA242,AA229,(AA216*(1+C$41))))","v":702.66666666666663},{"$f":"(AVERAGE(AB242,AB229,(AB216*(1+D$41))))","v":851.33333333333337},680.33333333333337,733,1667.6666666666667,836,579.33333333333337,1186.6666666666667,1123.3333333333333,null,null,null,"Transfers Out with 12 hrs",249,206.33333333333334,321.33333333333331,536,624.66666666666663,382,213.66666666666666,425.33333333333331,550.66666666666663,null," Low-income Bachelors and Associates",628,877,879,694,2044.3333333333333,1061.6666666666667,687.33333333333337,1507.3333333333333,1540.3333333333333]
[null,"Low-income Accumulating 48 hrs",{"$f":"(AVERAGE(AA243,AA230,(AA217*(1+C$41))))","v":689.33333333333337},840,700.66666666666663,663.66666666666663,1765.6666666666667,828.33333333333337,524,1262,1276.3333333333333,null,null,null,"Degrees per 100 FTE",16.631487705368027,18.890211592409369,19.338162643264155,16.742126955388009,19.47340623013206,19.415232708891907,17.790710825410322,18.495829451301251,22.689954344121475]
[null,"Low-income Accumulating 72 hrs",{"$f":"(AVERAGE(AA244,AA231,(AA218*(1+C$41))))","v":707},798.66666666666663,803,733,1997.6666666666667,965.33333333333337,558,1403.3333333333333,1447,null,null,null,"Six-Year Graduation Rate",{"$f":"56.1292708817688/100","v":0.561292708817688},{"$f":"42.8055833770528/100","v":0.42805583377052797},{"$f":"56.3690318908031/100","v":0.56369031890803101},{"$f":"50.9250007513611/100","v":0.50925000751361094},{"$f":"52.126345800615/100","v":0.52126345800615004},{"$f":"49.1855925203052/100","v":0.49185592520305199},{"$f":"36.5671016390221/100","v":0.36567101639022098},{"$f":"45.5149886505684/100","v":0.455149886505684},{"$f":"71.5424817621804/100","v":0.71542481762180399}]
[null," Low-income Bachelors and Associates",{"$f":"(AVERAGE(AA245,AA232,(AA219*(1+C$41))))","v":628},877,879,694,2044.3333333333333,1061.6666666666667,687.33333333333337,1507.3333333333333,1540.3333333333333]
[null,"Sub-population Premium = 40%"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UTM","APSU","TTU","UTC","MTSU","ETSU","TSU","UM","UTK",null,"sub pops","UTM","APSU","TTU","UTC","MTSU","ETSU","TSU","UM","UTK"]
["Scale","Scaled Outcomes (10-11 to 12-13 Data)","UTM","APSU","TTU","UTC","MTSU","ETSU","TSU","UM","UTK",null,null,null,"Students Accumulating 24 hrs",1276.3333333333333,1515.6666666666667,1688,1880.3333333333333,3175.3333333333335,1801,989.66666666666663,2233.3333333333335,3483,null,"Adults Accumulating 24 hrs",113.66666666666667,250,60,34.666666666666664,217.33333333333334,152,78,150,32.333333333333336]
[1,"Students Accumulating 24 hrs (Scale=1)",{"$f":"C215/$A239","v":1276.3333333333333},{"$f":"D215/$A239","v":1515.6666666666667},1688,1880.3333333333333,3175.3333333333335,1801,989.66666666666663,2233.3333333333335,3483,null,null,null,"Students Accumulating 48 hrs",1200.3333333333333,1421,1555.3333333333333,1604,3349.6666666666665,1723.3333333333333,867,2314.3333333333335,3877.6666666666665,null,"Adults Accumulating 48 hrs",151.66666666666666,352,94.666666666666671,53.333333333333336,337.33333333333331,192.33333333333334,123.66666666666667,296.66666666666669,82.333333333333329]
[1,"Students Accumulating 48 hrs (Scale=1)",1200.3333333333333,1421,1555.3333333333333,1604,3349.6666666666665,1723.3333333333333,867,2314.3333333333335,3877.6666666666665,null,null,null,"Students Accumulating 72 hrs",1236,1387,1641.6666666666667,1654.3333333333333,3775.3333333333335,1946,889.33333333333337,2534,4151,null,"Adults Accumulating 72 hrs",199.66666666666666,455.33333333333331,183.66666666666666,149.66666666666666,625.66666666666663,314.33333333333331,183.66666666666666,525.66666666666663,208.66666666666666]
[1,"Students Accumulating 72 hrs (Scale=1)",1236,1387,1641.6666666666667,1654.3333333333333,3775.3333333333335,1946,889.33333333333337,2534,4151,null,null,null,"Bachelors and Associates",1133.6666666666667,1582,1709.6666666666667,1490.6666666666667,3979.3333333333335,2162.6666666666665,1081.6666666666667,2763,4426,null,"Adults Bachelors and Associates",355,905.66666666666663,480.66666666666669,460.66666666666669,1518.6666666666667,836,546.33333333333337,1304.6666666666667,718.33333333333337]
[1,"Bachelors and Associates (Scale=1)",1133.6666666666667,1582,1709.6666666666667,1490.6666666666667,3979.3333333333335,2162.6666666666665,1081.6666666666667,2763,4426,null,null,null,"Masters/Ed Specialist Degrees",128.33333333333334,308.66666666666669,488,456,952.66666666666663,605,409.33333333333331,1038.3333333333333,1568.3333333333333,null,"Low-income Accumulating 24 hrs",702.66666666666663,851.33333333333337,680.33333333333337,733,1667.6666666666667,836,579.33333333333337,1186.6666666666667,1123.3333333333333]
[0.3,"Masters/Ed Specialist Degrees (Scale=0.3)",427.77777777777783,1028.8888888888889,1626.6666666666667,1520,3175.5555555555557,2016.6666666666667,1364.4444444444443,3461.1111111111109,5227.7777777777774,null,null,null,"Doctoral / Law Degrees",0,0,17,60.666666666666664,21,82.666666666666671,68.333333333333329,262,539,null,"Low-income Accumulating 48 hrs",689.33333333333337,840,700.66666666666663,663.66666666666663,1765.6666666666667,828.33333333333337,524,1262,1276.3333333333333]
[0.05,"Doctoral / Law Degrees (Scale=.05)",0,0,340,1213.3333333333333,420,1653.3333333333333,1366.6666666666665,5240,10780,null,null,null,"Research and Service",2895192.8166666664,3234935.4933333336,9618701.7599999998,10734921.923333334,24168097.459999997,23360636.333333332,32085374.333333332,56665628.666666664,151648065.61333331,null,"Low-income Accumulating 72 hrs",707,798.66666666666663,803,733,1997.6666666666667,965.33333333333337,558,1403.3333333333333,1447]
[20000,"Research and Service (Scale=20,000)",144.75964083333332,161.74677466666668,480.93508800000001,536.74609616666669,1208.404873,1168.0318166666666,1604.2687166666667,2833.2814333333331,7582.4032806666655,null,null,null,"Transfers Out with 12 hrs",249,206.33333333333334,321.33333333333331,536,624.66666666666663,382,213.66666666666666,425.33333333333331,550.66666666666663,null," Low-income Bachelors and Associates",628,877,879,694,2044.3333333333333,1061.6666666666667,687.33333333333337,1507.3333333333333,1540.3333333333333]
[1,"Transfers Out with 12 hrs (Scale=1)",249,206.33333333333334,321.33333333333331,536,624.66666666666663,382,213.66666666666666,425.33333333333331,550.66666666666663,null,null,null,"Degrees per 100 FTE",16.631487705368027,18.890211592409369,19.338162643264155,16.742126955388009,19.47340623013206,19.415232708891907,17.790710825410322,18.495829451301251,22.689954344121475]
[0.02,"Degrees per 100 FTE (Scale=.02)",831.57438526840133,944.51057962046843,966.90813216320771,837.10634776940049,973.67031150660296,970.7616354445953,889.53554127051609,924.79147256506258,1134.4977172060737,null,null,null,"Six-Year Graduation Rate",{"$f":"56.1292708817688/100","v":0.561292708817688},{"$f":"42.8055833770528/100","v":0.42805583377052797},{"$f":"56.3690318908031/100","v":0.56369031890803101},{"$f":"50.9250007513611/100","v":0.50925000751361094},{"$f":"52.126345800615/100","v":0.52126345800615004},{"$f":"49.1855925203052/100","v":0.49185592520305199},{"$f":"36.5671016390221/100","v":0.36567101639022098},{"$f":"45.5149886505684/100","v":0.455149886505684},{"$f":"71.5424817621804/100","v":0.71542481762180399}]
[0.04,"Six-Year Graduation Rate (Scale=.04)",{"$f":"C224/$A248","v":1403.23177204422},{"$f":"D224/$A248","v":1070.13958442632},1409.2257972700775,1273.1250187840274,1303.1586450153752,1229.6398130076298,914.17754097555246,1137.8747162642098,1788.5620440545099]
[]
[]
[null,"Scaled Sub-pop Outcomes (10-11 to 12-13 Data)","UTM","APSU","TTU","UTC","MTSU","ETSU","TSU","UM","UTK",null,null,"Sub-pop premium"]
[null,"Adults Accumulating 24 hrs",{"$f":"(C228/$A239)*$N$252","v":45.466666666666669},{"$f":"(D228/$A239)*$N$252","v":100},24,13.866666666666667,86.933333333333337,60.800000000000004,31.200000000000003,60,12.933333333333335,null,null,0.4]
[null,"Adults Accumulating 48 hrs",{"$f":"(C229/$A240)*$N$252","v":60.666666666666664},140.80000000000001,37.866666666666667,21.333333333333336,134.93333333333334,76.933333333333337,49.466666666666669,118.66666666666669,32.93333333333333]
[null,"Adults Accumulating 72 hrs",{"$f":"(C230/$A241)*$N$252","v":79.866666666666674},182.13333333333333,73.466666666666669,59.866666666666667,250.26666666666665,125.73333333333333,73.466666666666669,210.26666666666665,83.466666666666669]
[null,"Adults Bachelors and Associates",{"$f":"(C231/$A242)*$N$252","v":142},362.26666666666665,192.26666666666668,184.26666666666668,607.4666666666667,334.40000000000003,218.53333333333336,521.86666666666667,287.33333333333337]
[null,"Low-income Accumulating 24 hrs",{"$f":"(C232/$A239)*$N$252","v":281.06666666666666},{"$f":"(D232/$A239)*$N$252","v":340.53333333333336},272.13333333333338,293.2,667.06666666666672,334.40000000000003,231.73333333333335,474.66666666666674,449.33333333333331]
[null,"Low-income Accumulating 48 hrs",{"$f":"(C233/$A240)*$N$252","v":275.73333333333335},336,280.26666666666665,265.46666666666664,706.26666666666677,331.33333333333337,209.60000000000002,504.8,510.5333333333333]
[null,"Low-income Accumulating 72 hrs",282.8,319.4666666666667,321.20000000000005,293.2,799.06666666666672,386.13333333333338,223.20000000000002,561.33333333333337,578.80000000000007]
[null," Low-income Bachelors and Associates",{"$f":"(C235/$A242)*$N$252","v":251.20000000000002},350.8,351.6,277.60000000000002,817.73333333333335,424.66666666666674,274.93333333333334,602.93333333333328,616.13333333333333]
[]
[]
[null,"Weights Based on Institutional Mission","UTM","APSU","TTU","UTC","MTSU","ETSU","TSU","UM","UTK"]
[null,"Students Accumulating 24 hrs",0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.02,0.02]
[null,"Students Accumulating 48 hrs",0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.03,0.03]
[null,"Students Accumulating 72 hrs",7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,0.05,0.05]
[null,"Bachelors and Associates",0.3,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.15]
[null,"Masters/Ed Specialist Degrees",0.15,0.2,0.15,0.15,0.15,0.15,0.15,0.15,0.15]
[null,"Doctoral / Law Degrees",0,0,0.05,0.05,7.4999999999999997E-2,7.4999999999999997E-2,7.4999999999999997E-2,0.1,0.1]
[null,"Research and Service",0.1,0.1,0.1,0.1,0.125,0.125,0.125,0.125,0.15]
[null,"Transfers Out with 12 hrs",0.1,0.1,0.1,0.1,0.05,0.05,0.05,0.05,0.05]
[null,"Degrees per 100 FTE",0.15,0.1,0.1,0.1,0.1,0.1,0.1,7.4999999999999997E-2,0.1]
[null,"Six-Year Graduation Rate",0.05,0.1,0.1,0.1,0.1,0.1,0.1,0.15,0.2]
[null,null,{"$f":"SUM(C263:C272)","v":1},1,1,1,1,1,1,1,1]
[]
[]
[null,"Weighted Outcomes","UTM","APSU","TTU","UTC","MTSU","ETSU","TSU","UM","UTK",null,null,null,null,null,"Original Weighted Outcomes","UTM","APSU","TTU","UTC","MTSU","ETSU","TSU","UM","UTK","All 4yr"]
[null,"Students Accumulating 24 hrs",{"$f":"IF(C239=\"NA\",0, ((C239+C252+C256)*C263))","v":48.085999999999999},{"$f":"IF(D239=\"NA\",0, ((D239+D252+D256)*D263))","v":58.686},59.524000000000001,65.621999999999986,117.88,65.885999999999996,37.577999999999996,55.36,78.905333333333346,null,null,null,null,null,null,993.3297104758044,1303.5954716491235,1437.9642350766621,1395.7777462720094,2934.0835047771975,1886.594121928556,1269.4395644746069,2939.3580803820114,4749.8453392981764,{"$f":"SUM(R277:Z277)","v":18909.987774334149}]
[null,"Students Accumulating 48 hrs",{"$f":"IF(C240=\"NA\",0, ((C240+C253+C257)*C264))","v":76.836666666666673},94.89,93.673333333333332,94.54,209.54333333333335,106.58,56.303333333333335,88.134,132.63399999999999]
[null,"Students Accumulating 72 hrs",111.90666666666668,132.202,142.54333333333335,140.518,337.72666666666674,172.05066666666667,83.02000000000001,165.28,240.66333333333333,null,null,null,null,null,"Change in Weighted Outcomes"]
[null,"Bachelors and Associates",458.06,573.76666666666665,563.38333333333333,488.13333333333333,1351.1333333333334,730.43333333333339,393.78333333333336,971.95,799.42,null,null,null,null,null,null,{"$f":"C287-R277","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(C287:K287)-AA277","v":0}]
[null,"Masters / Ed Specialists",{"$f":"IF(C243=\"NA\",0, (C243*C267))","v":64.166666666666671},205.7777777777778,244,228,476.33333333333331,302.5,204.66666666666666,519.16666666666663,784.16666666666663,null,null,null,null,null,"% Change",{"$f":"R280/R277","v":0},{"$f":"S280/S277","v":0},0,0,0,0,0,0,0,0]
[null,"Doctoral / Law Degree",0,0,17,60.666666666666664,31.5,123.99999999999999,102.49999999999999,524,1078]
[null,"Research and Service",14.475964083333333,16.174677466666669,48.093508800000002,53.674609616666672,151.05060912499999,146.00397708333333,200.53358958333334,354.16017916666664,1137.3604920999999]
[null,"Transfers Out with 12 hrs",24.900000000000002,20.633333333333336,32.133333333333333,53.6,31.233333333333334,19.100000000000001,10.683333333333334,21.266666666666666,27.533333333333331,null,null,null,null,"For Dynamic Formula Tab Display:"]
[null,"Degrees per 100 FTE",124.73615779026019,94.451057962046846,96.690813216320777,83.710634776940054,97.367031150660296,97.076163544459533,88.953554127051618,69.359360442379696,113.44977172060737,null,null,null,null,null,null,"2015-16","2015-16","Percent "]
[null,"Six-Year Graduation Rate",{"$f":"IF(C248=\"NA\",0, (C248*C272))","v":70.161588602210998},107.013958442632,140.92257972700776,127.31250187840274,130.31586450153753,122.96398130076298,91.417754097555246,170.68120743963146,357.71240881090199,null,null,null,null,null,null,"Formula Calculation","State Appr*","Funded"]
[null,"Total",{"$f":"SUM(C277:C286)","v":993.3297104758044},{"$f":"SUM(D277:D286)","v":1303.5954716491235},1437.9642350766621,1395.7777462720094,2934.0835047771975,1886.594121928556,1269.4395644746069,2939.3580803820114,4749.8453392981764,null,null,null,null,"APSU","Austin Peay",{"$f":"Working!J7","v":56186000},{"$f":"ROUND(Working!K7,-2)","v":34233400},{"$f":"Working!L7","v":0.60928674901547053}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ETSU","East Tennessee",{"$f":"Working!J8","v":78623000},{"$f":"ROUND(Working!K8,-2)","v":47904000},{"$f":"Working!L8","v":0.60928674901547053}]
[null,"SREB Carnegie Type Avg Salary",61858.269275593222,65482.911172296044,65482.911172296044,65482.911172296044,69347.676923514882,69347.676923514882,69347.676923514882,79367.395413045801,91780.889883072232,null,null,null,null,"MTSU","Middle Tennessee",{"$f":"Working!J9","v":135820500},{"$f":"ROUND(Working!K9,-2)","v":82753600},{"$f":"Working!L9","v":0.60928674901547053}]
[null,"Outcome Based Performance",{"$f":"C287*C289","v":61445656.71005936},{"$f":"D287*D289","v":85363226.474606916},94162084.274463698,91399590.17539756,203471874.95590332,130830919.65330374,88032684.791112483,233289195.02621037,435945032.04774982,null,null,null,null,"TSU","Tennessee State",{"$f":"Working!J10","v":52609300},{"$f":"ROUND(Working!K10,-2)","v":32054100},{"$f":"Working!L10","v":0.60928674901547053}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TTU","Tennessee Tech",{"$f":"Working!J11","v":62960900},{"$f":"ROUND(Working!K11,-2)","v":38361200},{"$f":"Working!L11","v":0.60928674901547053}]
[null,"Fixed Costs",null,null,null,null,null,null,null,null,null,null,null,null,null,"UM","University of Memphis",{"$f":"Working!J12","v":146528000},{"$f":"ROUND(Working!K12,-2)","v":89277600},{"$f":"Working!L12","v":0.60928674901547053}]
[null,"M&O & Utilities",15484799.048250489,13720362.082691187,19728153.823673002,19722554.366509184,35364208.872575894,23722279.968339846,20375857.93091527,44092105.565087676,80256243.700847551,null,null,null,null,"UTC","UT Chattanooga",{"$f":"Working!J30","v":61485000},{"$f":"ROUND(Working!K30,-2)","v":37462000},{"$f":"Working!L30","v":0.60928674901547053}]
[null,"Equipment Replacement",1255571.2388920004,1482432.5619999999,2463766.94,1504179.3180250002,5122114.5530000003,2615770.7510000002,2738855.0700000003,3802761.6370000001,23179143.263426006,null,null,null,null,"UTK","UT Knoxville",{"$f":"Working!J31","v":289041000},{"$f":"ROUND(Working!K31,-2)","v":176108900},{"$f":"Working!L31","v":0.60928674901547053}]
[null,"Fixed Costs Subtotal",{"$f":"SUM(C293:C294)","v":16740370.287142489},15202794.644691188,22191920.763673004,21226733.684534185,40486323.425575897,26338050.719339848,23114713.00091527,47894867.202087678,103435386.96427356,null,null,null,null,"UTM","UT Martin",{"$f":"Working!J32","v":42686000},{"$f":"ROUND(Working!K32,-2)","v":26008000},{"$f":"Working!L32","v":0.60928674901547053}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,"Formula Subtotal",{"$f":"C295+C290","v":78186026.997201845},{"$f":"D295+D290","v":100566021.1192981},116354005.03813671,112626323.85993174,243958198.3814792,157168970.37264359,111147397.79202776,281184062.22829807,539380419.01202333]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"PF Percentage"]
[null,"Performance Funding: Quality Assurance Score",92,91,97.5,96,98,93.5,89,93,96,null,null,5.45E-2]
[]
[]
[null,null,"Out of State Tuition Calculation:"]
[null,"2012-13 FTE",7016.3083333333334,9067.7999999999993,9792.9499999999989,10299.275000000001,21694.483333333334,12835.758333333333,7385.0833333333339,18164.991666666669,24280.633333333335]
[null,"per FTE subsidy",{"$f":"C297*C208/C303","v":6128.9089369354042},{"$f":"D297*D208/D303","v":6099.749841815431},{"$f":"E297*E208/E303","v":6534.7727468204375},{"$f":"F297*F208/F303","v":6014.4503494626997},{"$f":"G297*G208/G303","v":6184.8446468255861},6734.5404502100437,8277.6410267022857,8513.6969541997551,12217.936261545054]
[null,"OSFTE",432.35,291.875,746.24166666666667,584.74166666666667,922.75833333333333,1727.2333333333333,1441.7333333333333,1791.7083333333333,1799.7666666666667]
[null,"OS tuit est.",{"$f":"C305*C304","v":2649833.778884022},{"$f":"D305*D304","v":1780364.4850798789},4876519.7058751946,3516899.7214287347,5707116.9382303664,11632122.750284461,11934150.989564242,15254061.780314319,21989434.418986734]

{"sheet":"Dynamic Formula","index":2,"n_rows":128,"n_cols":40,"rows_kept":128,"cut":false,"hidden":false,"merged":[[3,1,30,1],[3,2,3,12],[3,14,5,16],[3,17,5,18],[6,5,29,5],[6,6,8,6],[6,7,29,7],[6,9,29,9],[6,10,8,10],[6,11,29,11],[6,12,8,12],[6,15,6,16],[6,17,6,18],[7,15,7,16],[7,17,7,18],[8,15,8,16],[8,17,8,18],[27,14,27,16],[12,6,14,6],[12,10,14,10],[12,12,14,12],[12,15,12,16],[12,17,12,18],[13,17,13,18],[14,17,15,18],[9,6,11,6],[9,10,11,10],[9,12,11,12],[10,15,10,16],[9,17,9,18],[10,17,10,18],[11,15,11,16],[11,17,11,18],[9,15,9,16],[22,6,24,6],[22,10,24,10],[22,12,24,12],[22,14,24,16],[22,17,24,18],[25,14,26,14],[25,15,26,16],[25,17,26,18],[16,6,18,6],[16,10,18,10],[16,12,18,12],[16,17,16,18],[17,17,17,18],[19,6,21,6],[19,10,21,10],[19,12,21,12],[27,17,30,18],[28,14,28,16],[29,14,29,16],[32,1,53,1],[32,2,32,12],[32,14,34,16],[32,17,34,18],[35,5,52,5],[35,6,37,6],[35,7,52,7],[38,6,40,6],[38,10,40,10],[38,12,40,12],[39,15,39,16],[38,17,38,18],[39,17,39,18],[40,15,40,16],[40,17,40,18],[35,9,52,9],[35,10,37,10],[35,11,52,11],[35,12,37,12],[35,15,35,16],[35,17,35,18],[36,15,36,16],[36,17,36,18],[37,15,37,16],[37,17,37,18],[45,17,45,18],[46,17,46,18],[47,14,47,16],[47,17,48,18],[48,14,48,16],[38,15,38,16],[49,15,49,16],[49,17,49,18],[41,6,43,6],[41,10,43,10],[41,12,43,12],[41,15,41,16],[41,17,41,18],[42,17,42,18],[43,17,44,18],[44,6,46,6],[44,10,46,10],[44,12,46,12],[95,38,97,38],[95,39,97,39],[104,24,105,28],[107,24,107,27],[88,27,90,27],[88,28,90,28],[92,27,94,27],[92,28,94,28],[92,38,94,38],[92,39,94,39],[0,1,0,18],[1,1,1,18],[118,27,120,27],[118,28,120,28],[109,27,111,27],[109,28,111,28],[112,27,114,27],[112,28,114,28],[115,27,117,27],[115,28,117,28],[95,27,97,27],[95,28,97,28],[77,24,78,28],[80,24,80,27],[82,27,84,27],[82,28,84,28],[85,27,87,27],[85,28,87,28],[50,17,53,18],[51,14,51,16],[52,14,52,16],[57,1,57,18],[67,1,72,9],[76,24,76,26]]}
[null,"Tennessee Higher Education Commission"]
[null,"Estimated Changes in FY 2015-16 Formula Recommendation and Appropriations*"]
[]
[null,"Community Colleges",{"$f":"Outcomes!C4","v":"Chattanooga"},null,null,null,null,null,null,null,null,null,null,null,"Total Weighted Outcomes",null,null,{"$f":"M31","v":1000.5909060328313}]
[null,null,null,"Estimated","Sub-pop",null,null,null,null,null,"Mission-Based",null,"Weighted"]
[null,null,"Outcomes","Data","x","/","Scales","=","Scaled Data","x","Weights","=","Outcomes"]
[null,null,"Students Accumulating 12 hrs",{"$f":"HLOOKUP($C$4,Outcomes!$C$71:$O$83,2,0)","v":2461.6666666666665},null,"/",{"$f":"Outcomes!A101","v":2},"=",{"$f":"HLOOKUP($C$4,Outcomes!$C$100:$O$112,2,0)","v":1230.8333333333333},"X",{"$f":"HLOOKUP($C$4,Outcomes!$C$128:$O$140,2,0)","v":0.06},"=",{"$f":"HLOOKUP($C$4,Outcomes!$C$143:$O$155,2,0)","v":99.549999999999983},null,"X","Salary Multiplier",null,{"$f":"HLOOKUP($C$4,Outcomes!C143:O158,16,0)","v":54621.269166583021}]
[null,null,"Sub-population Adults",{"$f":"HLOOKUP($C$4,Outcomes!$C$85:$O$96,2,0)","v":748},0.4,null,null,null,{"$f":"HLOOKUP($C$4,Outcomes!$C$114:$O$125,2,0)","v":149.6},null,null,null,null,null,null,"=    Outcomes Based Subtotal",null,{"$f":"HLOOKUP($C$4,Outcomes!C143:O160,17,0)","v":54653545.20405446}]
[null,null,"Sub-population Pell",{"$f":"HLOOKUP($C$4,Outcomes!$C$85:$O$96,8,0)","v":1393.6666666666667},0.4,null,null,null,{"$f":"HLOOKUP($C$4,Outcomes!$C$114:$O$125,8,0)","v":278.73333333333335},null,null,null,null,null,"+","M&O & Utilities",null,{"$f":"HLOOKUP($C$4,Outcomes!C143:O163,20,0)","v":8180769.1816084106}]
[null,null,"Students Accumulating 24 hrs",{"$f":"HLOOKUP($C$4,Outcomes!$C$71:$O$83,3,0)","v":1880.6666666666667},null,null,{"$f":"Outcomes!A102","v":2},null,{"$f":"HLOOKUP($C$4,Outcomes!$C$100:$O$112,3,0)","v":940.33333333333337},null,{"$f":"HLOOKUP($C$4,Outcomes!$C$128:$O$140,3,0)","v":7.0000000000000007E-2},null,{"$f":"HLOOKUP($C$4,Outcomes!$C$143:$O$155,3,0)","v":92.834000000000017},null,"+"," Equipment",null,{"$f":"HLOOKUP($C$4,Outcomes!C143:O164,21,0)","v":1224978.2640000002}]
[null,null,"Sub-population Adults",{"$f":"HLOOKUP($C$4,Outcomes!$C$85:$O$96,3,0)","v":760.33333333333337},0.4,null,null,null,{"$f":"HLOOKUP($C$4,Outcomes!$C$114:$O$125,3,0)","v":152.06666666666669},null,null,null,null,null,"x","Three-Year Formula Phase In",null,{"$f":"HLOOKUP($C$4,Outcomes!$C$56:$O$60,5,0)","v":1}]
[null,null,"Sub-population Pell",{"$f":"HLOOKUP($C$4,Outcomes!$C$85:$O$96,9,0)","v":1169},0.4,null,null,null,{"$f":"HLOOKUP($C$4,Outcomes!$C$114:$O$125,9,0)","v":233.8},null,null,null,null,null,null,"=    Estimated Need",null,{"$f":"(R8+R9+R10)*R11","v":64059292.649662867}]
[null,null,"Students Accumulating 36 hrs",{"$f":"HLOOKUP($C$4,Outcomes!$C$71:$O$83,4,0)","v":1628},null,null,{"$f":"Outcomes!A103","v":2},null,{"$f":"HLOOKUP($C$4,Outcomes!$C$100:$O$112,4,0)","v":814},null,{"$f":"HLOOKUP($C$4,Outcomes!$C$128:$O$140,4,0)","v":7.0000000000000007E-2},null,{"$f":"HLOOKUP($C$4,Outcomes!$C$143:$O$155,4,0)","v":81.550000000000011},null,"X","Subsidy/Fee Policy",null,0.66669999999999996]
[null,null,"Sub-population Adults",{"$f":"HLOOKUP($C$4,Outcomes!$C$85:$O$96,4,0)","v":736.33333333333337},0.4,null,null,null,{"$f":"HLOOKUP($C$4,Outcomes!$C$114:$O$125,4,0)","v":147.26666666666668},null,null,null,null,null,"-","Out of State Tuition Revenue",null,{"$f":"HLOOKUP($C$4,Outcomes!C56:O66,11,0)","v":2121291.5021079709}]
[null,null,"Sub-population Pell",{"$f":"HLOOKUP($C$4,Outcomes!$C$85:$O$96,10,0)","v":1018.6666666666666},0.4,null,null,null,{"$f":"HLOOKUP($C$4,Outcomes!$C$114:$O$125,10,0)","v":203.73333333333335},null,null,null,null,null,"+","Performance Funding:",null,{"$f":"(R12*R13-R14)*((0.0545*R17)/100)","v":2145633.8118408779}]
[null,null,"Dual Enrollment",{"$f":"HLOOKUP($C$4,Outcomes!$C$71:$O$83,5,0)","v":1167.6666666666667},null,null,{"$f":"Outcomes!A104","v":2},null,{"$f":"HLOOKUP($C$4,Outcomes!$C$100:$O$112,5,0)","v":583.83333333333337},null,{"$f":"HLOOKUP($C$4,Outcomes!$C$128:$O$140,5,0)","v":0.05},null,{"$f":"HLOOKUP($C$4,Outcomes!$C$143:$O$155,5,0)","v":29.19166666666667},null,null,"    Quality Assurance Amount"]
[null,null,"Associates",{"$f":"HLOOKUP($C$4,Outcomes!$C$71:$O$83,6,0)","v":913.33333333333337},null,null,{"$f":"Outcomes!A105","v":1.5},null,{"$f":"HLOOKUP($C$4,Outcomes!$C$100:$O$112,6,0)","v":608.88888888888891},null,{"$f":"HLOOKUP($C$4,Outcomes!$C$128:$O$140,6,0)","v":0.05},null,{"$f":"HLOOKUP($C$4,Outcomes!$C$143:$O$155,6,0)","v":45.408888888888896},null,null,"    (Quality Assurance Score)",null,{"$f":"HLOOKUP($C$4,Outcomes!C143:O169,26,0)","v":97}]
[null,null,"Sub-population Adults",{"$f":"HLOOKUP($C$4,Outcomes!$C$85:$O$96,5,0)","v":572},0.4,null,null,null,{"$f":"HLOOKUP($C$4,Outcomes!$C$114:$O$125,5,0)","v":152.53333333333333},null,null,null,null,null,"+","Legislative Initiatives",null,{"$f":"HLOOKUP($C$4,Outcomes!C56:O67,12,0)","v":0}]
[null,null,"Sub-population Pell",{"$f":"HLOOKUP($C$4,Outcomes!$C$85:$O$96,11,0)","v":550.33333333333337},0.4,null,null,null,{"$f":"HLOOKUP($C$4,Outcomes!$C$114:$O$125,11,0)","v":146.75555555555556}]
[null,null,"Certificates 1-2 Years",{"$f":"HLOOKUP($C$4,Outcomes!$C$71:$O$83,7,0)","v":166},null,null,{"$f":"Outcomes!A106","v":1.5},null,{"$f":"HLOOKUP($C$4,Outcomes!$C$100:$O$112,7,0)","v":110.66666666666667},null,{"$f":"HLOOKUP($C$4,Outcomes!$C$128:$O$140,7,0)","v":0.05},null,{"$f":"HLOOKUP($C$4,Outcomes!$C$143:$O$155,7,0)","v":7.9955555555555566}]
[null,null,"Sub-population Adults",{"$f":"HLOOKUP($C$4,Outcomes!$C$85:$O$96,6,0)","v":104.66666666666667},0.4,null,null,null,{"$f":"HLOOKUP($C$4,Outcomes!$C$114:$O$125,6,0)","v":27.911111111111115}]
[null,null,"Sub-population Pell",{"$f":"HLOOKUP($C$4,Outcomes!$C$85:$O$96,12,0)","v":80},0.4,null,null,null,{"$f":"HLOOKUP($C$4,Outcomes!$C$114:$O$125,12,0)","v":21.333333333333336}]
[null,null,"Certificates Less Than 1 Year",{"$f":"HLOOKUP($C$4,Outcomes!$C$71:$O$83,8,0)","v":109},null,null,{"$f":"Outcomes!A107","v":1.5},null,{"$f":"HLOOKUP($C$4,Outcomes!$C$100:$O$112,8,0)","v":72.666666666666671},null,{"$f":"HLOOKUP($C$4,Outcomes!$C$128:$O$140,8,0)","v":0.05},null,{"$f":"HLOOKUP($C$4,Outcomes!$C$143:$O$155,8,0)","v":5.4066666666666672},null,"Estimated 2015-16                THEC Recommendation",null,null,{"$f":"HLOOKUP($C$4,Outcomes!C56:O68,13,0)","v":42730000}]
[null,null,"Sub-population Adults",{"$f":"HLOOKUP($C$4,Outcomes!$C$85:$O$96,7,0)","v":71},0.4,null,null,null,{"$f":"HLOOKUP($C$4,Outcomes!$C$114:$O$125,7,0)","v":18.933333333333334}]
[null,null,"Sub-population Pell",{"$f":"HLOOKUP($C$4,Outcomes!$C$85:$O$97,13,0)","v":62},0.4,null,null,null,{"$f":"HLOOKUP($C$4,Outcomes!$C$114:$O$126,13,0)","v":16.533333333333335}]
[null,null,"Job Placements",{"$f":"HLOOKUP($C$4,Outcomes!$C$71:$O$83,9,0)","v":405.66666666666669},null,null,{"$f":"Outcomes!A108","v":0.5},null,{"$f":"HLOOKUP($C$4,Outcomes!$C$100:$O$112,9,0)","v":811.33333333333337},null,{"$f":"HLOOKUP($C$4,Outcomes!$C$128:$O$140,9,0)","v":0.2},null,{"$f":"HLOOKUP($C$4,Outcomes!$C$143:$O$155,9,0)","v":162.26666666666668},null,"X","Percent Funded",null,{"$f":"Working!L39","v":0.60928674901547053}]
[null,null,"R & D Success",{"$f":"HLOOKUP($C$4,Outcomes!$C$71:$O$83,10,0)","v":2627.6666666666665},null,null,{"$f":"Outcomes!A109","v":5},null,{"$f":"HLOOKUP($C$4,Outcomes!$C$100:$O$112,10,0)","v":525.5333333333333},null,{"$f":"HLOOKUP($C$4,Outcomes!$C$128:$O$140,10,0)","v":0.1},null,{"$f":"HLOOKUP($C$4,Outcomes!$C$143:$O$155,10,0)","v":52.553333333333335}]
[null,null,"Transfers Out with 12 hrs",{"$f":"HLOOKUP($C$4,Outcomes!$C$71:$O$83,11,0)","v":510.66666666666669},null,null,{"$f":"Outcomes!A110","v":2},null,{"$f":"HLOOKUP($C$4,Outcomes!$C$100:$O$112,11,0)","v":255.33333333333334},null,{"$f":"HLOOKUP($C$4,Outcomes!$C$128:$O$140,11,0)","v":0.15},null,{"$f":"HLOOKUP($C$4,Outcomes!$C$143:$O$155,11,0)","v":38.299999999999997},null,null,null,null,{"$f":"VLOOKUP(C4,Outcomes!$R$148:$U$160,3,0)","v":26034800}]
[null,null,"Workforce Training",{"$f":"HLOOKUP($C$4,Outcomes!$C$71:$O$83,12,0)","v":185122.33333333334},null,null,{"$f":"Outcomes!A111","v":50},null,{"$f":"HLOOKUP($C$4,Outcomes!$C$100:$O$112,12,0)","v":3702.4466666666667},null,{"$f":"HLOOKUP($C$4,Outcomes!$C$128:$O$140,12,0)","v":0.1},null,{"$f":"HLOOKUP($C$4,Outcomes!$C$143:$O$155,12,0)","v":370.24466666666672},null,"Estimated 2015-16                THEC Recommendation"]
[null,null,"Awards per 100 FTE",{"$f":"HLOOKUP($C$4,Outcomes!$C$71:$O$83,13,0)","v":15.289461588386908},null,null,{"$f":"Outcomes!A112","v":0.05},null,{"$f":"HLOOKUP($C$4,Outcomes!$C$100:$O$112,13,0)","v":305.78923176773816},null,{"$f":"HLOOKUP($C$4,Outcomes!$C$128:$O$141,13,0)","v":0.05},null,{"$f":"HLOOKUP($C$4,Outcomes!$C$143:$O$155,13,0)","v":15.289461588386908},null,"Recurring Appropriations"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M7:M30)","v":1000.5909060328313}]
[]
[null,"Universities",{"$f":"Outcomes!D4","v":"APSU"},null,null,null,null,null,null,null,null,null,null,null,"Total Weighted Outcomes",null,null,{"$f":"M54","v":1303.5954716491235}]
[null,null,null,"Estimated","Sub-pop",null,null,null,null,null,"Mission-Based",null,"Weighted"]
[null,null,"Outcomes","Data","x","/","Scales","=","Scaled Data","x","Weights","=","Outcomes"]
[null,null,"Students Accumulating 24 hrs",{"$f":"HLOOKUP($C$33,Outcomes!$C$214:$K$224,2,0)","v":1515.6666666666667},null,"/",{"$f":"Outcomes!A239","v":1},"=",{"$f":"HLOOKUP($C$33,Outcomes!$C$238:$K$248,2,0)","v":1515.6666666666667},"X",{"$f":"HLOOKUP($C$33,Outcomes!$C$262:$K$272,2,0)","v":0.03},"=",{"$f":"HLOOKUP($C$33,Outcomes!$C$276:$K$286,2,0)","v":58.686},null,"X","Salary Multiplier",null,{"$f":"HLOOKUP($C$33,Outcomes!$C$276:$K$289,14,0)","v":65482.911172296044}]
[null,null,"Sub-population Adults",{"$f":"HLOOKUP($C$33,Outcomes!$C$227:$K$235,2,0)","v":250},0.4,null,null,null,{"$f":"HLOOKUP($C$33,Outcomes!$C$251:$K$259,2,0)","v":100},null,null,null,null,null,null,"=    Outcomes Based Subtotal",null,{"$f":"HLOOKUP($C$33,Outcomes!$C$276:$K$290,15,0)","v":85363226.474606916}]
[null,null,"Sub-population Pell",{"$f":"HLOOKUP($C$33,Outcomes!$C$227:$K$235,6,0)","v":851.33333333333337},0.4,null,null,null,{"$f":"HLOOKUP($C$33,Outcomes!$C$251:$K$259,6,0)","v":340.53333333333336},null,null,null,null,null,"+","M&O & Utilities",null,{"$f":"HLOOKUP($C$33,Outcomes!$C$276:$K$293,18,0)","v":13720362.082691187}]
[null,null,"Students Accumulating 48 hrs",{"$f":"HLOOKUP($C$33,Outcomes!$C$214:$K$224,3,0)","v":1421},null,null,{"$f":"Outcomes!A240","v":1},null,{"$f":"HLOOKUP($C$33,Outcomes!$C$238:$K$248,3,0)","v":1421},null,{"$f":"HLOOKUP($C$33,Outcomes!$C$262:$K$272,3,0)","v":0.05},null,{"$f":"HLOOKUP($C$33,Outcomes!$C$276:$K$286,3,0)","v":94.89},null,"+"," Equipment",null,{"$f":"HLOOKUP($C$33,Outcomes!$C$276:$K$294,19,0)","v":1482432.5619999999}]
[null,null,"Sub-population Adults",{"$f":"HLOOKUP($C$33,Outcomes!$C$227:$K$235,3,0)","v":352},0.4,null,null,null,{"$f":"HLOOKUP($C$33,Outcomes!$C$251:$K$259,3,0)","v":140.80000000000001},null,null,null,null,null,"x","Three-year Formula Phase In",null,{"$f":"HLOOKUP($C$33,Outcomes!$C$199:$K$211,5,0)","v":1}]
[null,null,"Sub-population Pell",{"$f":"HLOOKUP($C$33,Outcomes!$C$227:$K$235,7,0)","v":840},0.4,null,null,null,{"$f":"HLOOKUP($C$33,Outcomes!$C$251:$K$259,7,0)","v":336},null,null,null,null,null,null,"=    Estimated Need",null,{"$f":"(R37+R38+R39)","v":100566021.11929812}]
[null,null,"Students Accumulating 72 hrs",{"$f":"HLOOKUP($C$33,Outcomes!$C$214:$K$224,4,0)","v":1387},null,null,{"$f":"Outcomes!A241","v":1},null,{"$f":"HLOOKUP($C$33,Outcomes!$C$238:$K$248,4,0)","v":1387},null,{"$f":"HLOOKUP($C$33,Outcomes!$C$262:$K$272,4,0)","v":7.0000000000000007E-2},null,{"$f":"HLOOKUP($C$33,Outcomes!$C$276:$K$286,4,0)","v":132.202},null,"X","Subsidy/Fee Policy",null,0.55000000000000004]
[null,null,"Sub-population Adults",{"$f":"HLOOKUP($C$33,Outcomes!$C$227:$K$235,4,0)","v":455.33333333333331},0.4,null,null,null,{"$f":"HLOOKUP($C$33,Outcomes!$C$251:$K$259,4,0)","v":182.13333333333333},null,null,null,null,null,"-","Out of State Tuition Revenue",null,{"$f":"HLOOKUP($C$33,Outcomes!$C$199:$K$211,11,0)","v":1780364.4850798789}]
[null,null,"Sub-population Pell",{"$f":"HLOOKUP($C$33,Outcomes!$C$227:$K$235,8,0)","v":798.66666666666663},0.4,null,null,null,{"$f":"HLOOKUP($C$33,Outcomes!$C$251:$K$259,8,0)","v":319.4666666666667},null,null,null,null,null,"+","Performance Funding:",null,{"$f":"(R41*R42-R43)*((0.0545*R46)/100)","v":2654867.322938838}]
[null,null,"Bachelors and Associates",{"$f":"HLOOKUP($C$33,Outcomes!$C$214:$K$224,5,0)","v":1582},null,null,{"$f":"Outcomes!A242","v":1},null,{"$f":"HLOOKUP($C$33,Outcomes!$C$238:$K$248,5,0)","v":1582},null,{"$f":"HLOOKUP($C$33,Outcomes!$C$262:$K$272,5,0)","v":0.25},null,{"$f":"HLOOKUP($C$33,Outcomes!$C$276:$K$286,5,0)","v":573.76666666666665},null,null,"    Quality Assurance Amount"]
[null,null,"Sub-population Adults",{"$f":"HLOOKUP($C$33,Outcomes!$C$227:$K$235,5,0)","v":905.66666666666663},0.4,null,null,null,{"$f":"HLOOKUP($C$33,Outcomes!$C$251:$K$259,5,0)","v":362.26666666666665},null,null,null,null,null,null,"    (Quality Assurance Score)",null,{"$f":"HLOOKUP($C$33,Outcomes!$C$276:$K$299,24,0)","v":91}]
[null,null,"Sub-population Pell",{"$f":"HLOOKUP($C$33,Outcomes!$C$227:$K$235,9,0)","v":877},0.4,null,null,null,{"$f":"HLOOKUP($C$33,Outcomes!$C$251:$K$259,9,0)","v":350.8},null,null,null,null,null,"+","Legislative Initiatives",null,{"$f":"HLOOKUP($C$33,Outcomes!$C$199:$K$211,12,0)","v":0}]
[null,null,"Masters/Ed Specialist Degrees",{"$f":"HLOOKUP($C$33,Outcomes!$C$214:$K$224,6,0)","v":308.66666666666669},null,null,{"$f":"Outcomes!A243","v":0.3},null,{"$f":"HLOOKUP($C$33,Outcomes!$C$238:$K$248,6,0)","v":1028.8888888888889},null,{"$f":"HLOOKUP($C$33,Outcomes!$C$262:$K$272,6,0)","v":0.2},null,{"$f":"HLOOKUP($C$33,Outcomes!$C$276:$K$286,6,0)","v":205.7777777777778},null,"Estimated 2015-16",null,null,{"$f":"HLOOKUP($C$33,Outcomes!$C$199:$K$211,13,0)","v":56186000}]
[null,null,"Doctoral / Law Degrees",{"$f":"HLOOKUP($C$33,Outcomes!$C$214:$K$224,7,0)","v":0},null,null,{"$f":"Outcomes!A244","v":0.05},null,{"$f":"HLOOKUP($C$33,Outcomes!$C$238:$K$248,7,0)","v":0},null,{"$f":"HLOOKUP($C$33,Outcomes!$C$262:$K$272,7,0)","v":0},null,{"$f":"HLOOKUP($C$33,Outcomes!$C$276:$K$286,7,0)","v":0},null,"THEC Recommendation"]
[null,null,"Research and Service",{"$f":"HLOOKUP($C$33,Outcomes!$C$214:$K$224,8,0)","v":3234935.4933333336},null,null,{"$f":"Outcomes!A245","v":20000},null,{"$f":"HLOOKUP($C$33,Outcomes!$C$238:$K$248,8,0)","v":161.74677466666668},null,{"$f":"HLOOKUP($C$33,Outcomes!$C$262:$K$272,8,0)","v":0.1},null,{"$f":"HLOOKUP($C$33,Outcomes!$C$276:$K$286,8,0)","v":16.174677466666669},null,"X","Percent Funded",null,{"$f":"Working!L39","v":0.60928674901547053}]
[null,null,"Transfers Out with 12 hrs",{"$f":"HLOOKUP($C$33,Outcomes!$C$214:$K$224,9,0)","v":206.33333333333334},null,null,{"$f":"Outcomes!A246","v":1},null,{"$f":"HLOOKUP($C$33,Outcomes!$C$238:$K$248,9,0)","v":206.33333333333334},null,{"$f":"HLOOKUP($C$33,Outcomes!$C$262:$K$272,9,0)","v":0.1},null,{"$f":"HLOOKUP($C$33,Outcomes!$C$276:$K$286,9,0)","v":20.633333333333336},null,null,null,null,{"$f":"VLOOKUP(C33,Outcomes!P287:T295,4,0)","v":34233400}]
[null,null,"Degrees per 100 FTE",{"$f":"HLOOKUP($C$33,Outcomes!$C$214:$K$224,10,0)","v":18.890211592409369},null,null,{"$f":"Outcomes!A247","v":0.02},null,{"$f":"HLOOKUP($C$33,Outcomes!$C$238:$K$248,10,0)","v":944.51057962046843},null,{"$f":"HLOOKUP($C$33,Outcomes!$C$262:$K$272,10,0)","v":0.1},null,{"$f":"HLOOKUP($C$33,Outcomes!$C$276:$K$286,10,0)","v":94.451057962046846},null,"Estimated 2015-16"]
[null,null,"Six-Year Graduation Rate",{"$f":"HLOOKUP($C$33,Outcomes!$C$214:$K$224,11,0)","v":42.805583377052798},null,null,{"$f":"Outcomes!A248","v":0.04},null,{"$f":"HLOOKUP($C$33,Outcomes!$C$238:$K$248,11,0)","v":1070.13958442632},null,{"$f":"HLOOKUP($C$33,Outcomes!$C$262:$K$272,11,0)","v":0.1},null,{"$f":"HLOOKUP($C$33,Outcomes!$C$276:$K$286,11,0)","v":107.013958442632},null,"Recurring Appropriations"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M36:M53)","v":1303.5954716491235}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"*Estimated projections based on outcomes from previous years, on the FY 2014-15 Budget, and on alterations to outcomes and funding level made on other tabs in this file . Outcome data that has been altered on the Outcomes tab in a positive direction will appear blue while outcome data altered in a negative direction will appear red. The phasing out of the Hold Harmless Provision was completed in FY 2013-14."]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WORKING AREA------"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"For Conditional Formatting Purposes:"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C4","v":"Chattanooga"},null,null,null,"Weighted"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Outcome","Data","Scaled Data","Weight","Outcomes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Students Accumulating 12 hrs",{"$f":"HLOOKUP($C$4,Outcomes!$T$67:$AF$79,2,0)","v":2461.6666666666665},{"$f":"Z83/Outcomes!A101","v":1230.8333333333333},{"$f":"HLOOKUP($C$4,Outcomes!$C$128:$O$140,2,0)","v":0.06},{"$f":"(AA83+AA84+AA85)*AB83","v":99.549999999999983}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sub-population Adults",{"$f":"AVERAGE(HLOOKUP($C$4,Outcomes!$AI$67:$AU$78,2,0),HLOOKUP($C$4,Outcomes!$AI$81:$AU$92,2,0),HLOOKUP($C$4,Outcomes!$AI$95:$AU$106,2,0))","v":748},{"$f":"Z84/Outcomes!A101*Outcomes!$Q$113","v":149.6}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sub-population Pell",{"$f":"HLOOKUP($C$4,Outcomes!$AI$67:$AU$78,8,0)","v":1393.6666666666667},{"$f":"Z85/Outcomes!A101*Outcomes!$Q$113","v":278.73333333333335}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Students Accumulating 24 hrs",{"$f":"AVERAGE(HLOOKUP($C$4,Outcomes!$T$67:$AF$79,3,0),HLOOKUP($C$4,Outcomes!$T$81:$AF$93,3,0),HLOOKUP($C$4,Outcomes!$T$95:$AF$107,3,0))","v":1880.6666666666667},{"$f":"Z86/Outcomes!A102","v":940.33333333333337},{"$f":"HLOOKUP($C$4,Outcomes!$C$128:$O$140,3,0)","v":7.0000000000000007E-2},{"$f":"(AA86+AA87+AA88)*AB86","v":92.834000000000017}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sub-population Adults",{"$f":"AVERAGE(HLOOKUP($C$4,Outcomes!$AI$67:$AU$78,3,0),HLOOKUP($C$4,Outcomes!$AI$81:$AU$92,3,0),HLOOKUP($C$4,Outcomes!$AI$95:$AU$106,3,0))","v":760.33333333333337},{"$f":"Z87/Outcomes!A102*Outcomes!$Q$113","v":152.06666666666669}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sub-population Pell",{"$f":"HLOOKUP($C$4,Outcomes!$AI$67:$AU$78,9,0)","v":1169},{"$f":"Z88/Outcomes!A102*Outcomes!$Q$113","v":233.8}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Students Accumulating 36 hrs",{"$f":"AVERAGE(HLOOKUP($C$4,Outcomes!$T$67:$AF$79,4,0),HLOOKUP($C$4,Outcomes!$T$81:$AF$93,4,0),HLOOKUP($C$4,Outcomes!$T$95:$AF$107,4,0))","v":1628},{"$f":"Z89/Outcomes!A103","v":814},{"$f":"HLOOKUP($C$4,Outcomes!$C$128:$O$140,4,0)","v":7.0000000000000007E-2},{"$f":"(AA89+AA90+AA91)*AB89","v":81.550000000000011}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sub-population Adults",{"$f":"AVERAGE(HLOOKUP($C$4,Outcomes!$AI$67:$AU$78,4,0),HLOOKUP($C$4,Outcomes!$AI$81:$AU$92,4,0),HLOOKUP($C$4,Outcomes!$AI$95:$AU$106,4,0))","v":736.33333333333337},{"$f":"Z90/Outcomes!A103*Outcomes!$Q$113","v":147.26666666666668}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sub-population Pell",{"$f":"HLOOKUP($C$4,Outcomes!$AI$67:$AU$78,10,0)","v":1018.6666666666666},{"$f":"Z91/Outcomes!A103*Outcomes!$Q$113","v":203.73333333333335}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dual Enrollment",{"$f":"AVERAGE(HLOOKUP($C$4,Outcomes!$T$67:$AF$79,5,0),HLOOKUP($C$4,Outcomes!$T$81:$AF$93,5,0),HLOOKUP($C$4,Outcomes!$T$95:$AF$107,5,0))","v":1167.6666666666667},{"$f":"Z92/Outcomes!A104","v":583.83333333333337},{"$f":"HLOOKUP($C$4,Outcomes!$C$128:$O$140,5,0)","v":0.05},{"$f":"AA92*AB92","v":29.19166666666667}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Associates",{"$f":"AVERAGE(HLOOKUP($C$4,Outcomes!$T$67:$AF$79,6,0),HLOOKUP($C$4,Outcomes!$T$81:$AF$93,6,0),HLOOKUP($C$4,Outcomes!$T$95:$AF$107,6,0))","v":913.33333333333337},{"$f":"Z93/Outcomes!A105","v":608.88888888888891},{"$f":"HLOOKUP($C$4,Outcomes!$C$128:$O$140,6,0)","v":0.05},{"$f":"(AA93+AA94+AA95)*AB93","v":45.408888888888896},null,null,null,null,null,null,"Cert 1-2",{"$f":"AVERAGE(HLOOKUP($C$4,Outcomes!$T$67:$AF$79,7,0),HLOOKUP($C$4,Outcomes!$T$81:$AF$93,7,0),HLOOKUP($C$4,Outcomes!$T$95:$AF$107,7,0))","v":166},{"$f":"AK93/Outcomes!A106","v":110.66666666666667},{"$f":"HLOOKUP($C$4,Outcomes!$C$128:$O$140,7,0)","v":0.05},{"$f":"(AL93+AL94+AL95)*AM93","v":7.9955555555555566}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sub-population Adults",{"$f":"AVERAGE(HLOOKUP($C$4,Outcomes!$AI$67:$AU$78,5,0),HLOOKUP($C$4,Outcomes!$AI$81:$AU$92,5,0),HLOOKUP($C$4,Outcomes!$AI$95:$AU$106,5,0))","v":572},{"$f":"Z94/Outcomes!A105*Outcomes!$Q$113","v":152.53333333333333},null,null,null,null,null,null,null,null,"Sub-population Adults",{"$f":"AVERAGE(HLOOKUP($C$4,Outcomes!$AI$67:$AU$78,6,0),HLOOKUP($C$4,Outcomes!$AI$81:$AU$92,6,0),HLOOKUP($C$4,Outcomes!$AI$95:$AU$106,6,0))","v":104.66666666666667},{"$f":"AK94/Outcomes!A106*Outcomes!$Q$113","v":27.911111111111115}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sub-population Pell",{"$f":"HLOOKUP($C$4,Outcomes!$AI$67:$AU$78,11,0)","v":550.33333333333337},{"$f":"Z95/Outcomes!A105*Outcomes!$Q$113","v":146.75555555555556},null,null,null,null,null,null,null,null,"Sub-population Pell",{"$f":"HLOOKUP($C$4,Outcomes!$AI$67:$AU$78,12,0)","v":80},{"$f":"AK95/Outcomes!A106*Outcomes!$Q$113","v":21.333333333333336}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Certificates",{"$f":"HLOOKUP($C$4,Outcomes!$T$67:$AF$79,7,0)+HLOOKUP($C$4,Outcomes!$T$67:$AF$79,8,0)","v":275},{"$f":"Z96/Outcomes!A106","v":183.33333333333334},null,{"$f":"AE97+AF97","v":13.402222222222223},null,"1-2 Yr","< 1 Yr",null,null,null,"Cert less than 1 yr",{"$f":"AVERAGE(HLOOKUP($C$4,Outcomes!$T$67:$AF$79,8,0),HLOOKUP($C$4,Outcomes!$T$81:$AF$93,8,0),HLOOKUP($C$4,Outcomes!$T$95:$AF$107,8,0))","v":109},{"$f":"AK96/Outcomes!A107","v":72.666666666666671},{"$f":"HLOOKUP($C$4,Outcomes!$C$128:$O$140,8,0)","v":0.05},{"$f":"(AL96+AL97+AL98)*AM96","v":5.4066666666666672}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sub-population Adults",{"$f":"HLOOKUP($C$4,Outcomes!$AI$67:$AU$78,6,0)+HLOOKUP($C$4,Outcomes!$AI$67:$AU$78,7,0)","v":175.66666666666669},{"$f":"Z97/Outcomes!A105*Outcomes!$Q$113","v":46.844444444444456},null,null,null,{"$f":"((HLOOKUP($C$4,Outcomes!$T$67:$AF$79,7,0)+0.4*(HLOOKUP($C$4,Outcomes!$AI$67:$AU$78,6,0)+HLOOKUP($C$4,Outcomes!$AI$67:$AU$79,12,0)))/Outcomes!A106)*HLOOKUP($C$4,Outcomes!$C$128:$O$140,7,0)","v":7.9955555555555566},{"$f":"((HLOOKUP($C$4,Outcomes!$T$67:$AF$79,8,0)+0.4*(HLOOKUP($C$4,Outcomes!$AI$67:$AU$78,7,0)+HLOOKUP($C$4,Outcomes!$AI$67:$AU$79,13,0)))/Outcomes!A107)*HLOOKUP($C$4,Outcomes!$C$128:$O$140,8,0)","v":5.4066666666666663},null,null,null,"Sub-population Adults",{"$f":"AVERAGE(HLOOKUP($C$4,Outcomes!$AI$67:$AU$78,7,0),HLOOKUP($C$4,Outcomes!$AI$81:$AU$92,7,0),HLOOKUP($C$4,Outcomes!$AI$95:$AU$106,7,0))","v":71},{"$f":"AK97/Outcomes!A107*Outcomes!$Q$113","v":18.933333333333334}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sub-population Pell",{"$f":"HLOOKUP($C$4,Outcomes!$AI$67:$AU$79,13,0)+HLOOKUP($C$4,Outcomes!$AI$67:$AU$78,12,0)","v":142},{"$f":"Z98/Outcomes!A105*Outcomes!$Q$113","v":37.866666666666667},null,null,null,null,null,null,null,null,"Sub-population Pell",{"$f":"HLOOKUP($C$4,Outcomes!$AI$67:$AU$79,13,0)","v":62},{"$f":"AK98/Outcomes!A107*Outcomes!$Q$113","v":16.533333333333335}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Job Placements",{"$f":"HLOOKUP($C$4,Outcomes!$T$67:$AF$79,9,0)","v":405.66666666666669},{"$f":"Z99/Outcomes!A108","v":811.33333333333337},{"$f":"HLOOKUP($C$4,Outcomes!$C$128:$O$140,9,0)","v":0.2},{"$f":"AA99*AB99","v":162.26666666666668}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"R & D Success",{"$f":"HLOOKUP($C$4,Outcomes!$T$67:$AF$79,10,0)","v":2627.6666666666665},{"$f":"Z100/Outcomes!A109","v":525.5333333333333},{"$f":"HLOOKUP($C$4,Outcomes!$C$128:$O$140,10,0)","v":0.1},{"$f":"AA100*AB100","v":52.553333333333335}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Transfers Out with 12 hrs",{"$f":"HLOOKUP($C$4,Outcomes!$T$67:$AF$79,11,0)","v":510.66666666666669},{"$f":"Z101/Outcomes!A110","v":255.33333333333334},{"$f":"HLOOKUP($C$4,Outcomes!$C$128:$O$140,11,0)","v":0.15},{"$f":"AA101*AB101","v":38.299999999999997}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Workforce Training",{"$f":"HLOOKUP($C$4,Outcomes!$T$67:$AF$79,12,0)","v":185122.33333333334},{"$f":"Z102/Outcomes!A111","v":3702.4466666666667},{"$f":"HLOOKUP($C$4,Outcomes!$C$128:$O$140,12,0)","v":0.1},{"$f":"AA102*AB102","v":370.24466666666672}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Awards per 100 FTE",{"$f":"HLOOKUP($C$4,Outcomes!$T$67:$AF$80,13,0)","v":15.289461588386908},{"$f":"Z103/Outcomes!A112","v":305.78923176773816},{"$f":"HLOOKUP($C$4,Outcomes!$C$128:$O$141,13,0)","v":0.05},{"$f":"AA103*AB103","v":15.289461588386908}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AC83:AC103)","v":1000.5909060328313}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"For Conditional Formatting Purposes:"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C33","v":"APSU"},null,null,null,"Weighted"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Outcome","Data","Scaled Data","Weight","Outcomes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Students Accumulating 24 hrs",{"$f":"AVERAGE(HLOOKUP(C33,Outcomes!$P$211:$X$221,2,0),HLOOKUP(C33,Outcomes!$P$224:$X$234,2,0),HLOOKUP(C33,Outcomes!$P$237:$X$247,2,0))","v":1515.6666666666667},{"$f":"Z110","v":1515.6666666666667},{"$f":"HLOOKUP(C33,Outcomes!$C$262:$K$272,2,0)","v":0.03},{"$f":"(AA110+AA111+AA112)*AB110","v":58.686}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sub-population Adults",{"$f":"AVERAGE(HLOOKUP(C33,Outcomes!$AA$211:$AI$219,2,0),HLOOKUP(C33,Outcomes!$AA$224:$AI$232,2,0),HLOOKUP(C33,Outcomes!$AA$237:$AI$245,2,0))","v":250},{"$f":"Z111*Outcomes!$N$252","v":100}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sub-population Pell",{"$f":"AVERAGE(HLOOKUP(C33,Outcomes!$AA$211:$AI$219,6,0),HLOOKUP(C33,Outcomes!$AA$224:$AI$232,6,0),HLOOKUP(C33,Outcomes!$AA$237:$AI$245,6,0))","v":851.33333333333337},{"$f":"Z112*Outcomes!$N$252","v":340.53333333333336}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Students Accumulating 48 hrs",{"$f":"AVERAGE(HLOOKUP(C33,Outcomes!$P$211:$X$221,3,0),HLOOKUP(C33,Outcomes!$P$224:$X$234,3,0),HLOOKUP(C33,Outcomes!$P$237:$X$247,3,0))","v":1421},{"$f":"Z113","v":1421},{"$f":"HLOOKUP(C33,Outcomes!$C$262:$K$272,3,0)","v":0.05},{"$f":"(AA113+AA114+AA115)*AB113","v":94.89}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sub-population Adults",{"$f":"AVERAGE(HLOOKUP(C33,Outcomes!$AA$211:$AI$219,3,0),HLOOKUP(C33,Outcomes!$AA$224:$AI$232,3,0),HLOOKUP(C33,Outcomes!$AA$237:$AI$245,3,0))","v":352},{"$f":"Z114*Outcomes!$N$252","v":140.80000000000001}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sub-population Pell",{"$f":"AVERAGE(HLOOKUP(C33,Outcomes!$AA$211:$AI$219,7,0),HLOOKUP(C33,Outcomes!$AA$224:$AI$232,7,0),HLOOKUP(C33,Outcomes!$AA$237:$AI$245,7,0))","v":840},{"$f":"Z115*Outcomes!$N$252","v":336}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Students Accumulating 72 hrs",{"$f":"AVERAGE(HLOOKUP(C33,Outcomes!$P$211:$X$221,4,0),HLOOKUP(C33,Outcomes!$P$224:$X$234,4,0),HLOOKUP(C33,Outcomes!$P$237:$X$247,4,0))","v":1387},{"$f":"Z116","v":1387},{"$f":"HLOOKUP(C33,Outcomes!$C$262:$K$272,4,0)","v":7.0000000000000007E-2},{"$f":"(AA116+AA117+AA118)*AB116","v":132.202}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sub-population Adults",{"$f":"AVERAGE(HLOOKUP(C33,Outcomes!$AA$211:$AI$219,4,0),HLOOKUP(C33,Outcomes!$AA$224:$AI$232,4,0),HLOOKUP(C33,Outcomes!$AA$237:$AI$245,4,0))","v":455.33333333333331},{"$f":"Z117*Outcomes!$N$252","v":182.13333333333333}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sub-population Pell",{"$f":"AVERAGE(HLOOKUP(C33,Outcomes!$AA$211:$AI$219,8,0),HLOOKUP(C33,Outcomes!$AA$224:$AI$232,8,0),HLOOKUP(C33,Outcomes!$AA$237:$AI$245,8,0))","v":798.66666666666663},{"$f":"Z118*Outcomes!$N$252","v":319.4666666666667}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bachelors and Associates",{"$f":"AVERAGE(HLOOKUP(C33,Outcomes!$P$211:$X$221,5,0),HLOOKUP(C33,Outcomes!$P$224:$X$234,5,0),HLOOKUP(C33,Outcomes!$P$237:$X$247,5,0))","v":1582},{"$f":"Z119","v":1582},{"$f":"HLOOKUP(C33,Outcomes!$C$262:$K$272,5,0)","v":0.25},{"$f":"(AA119+AA120+AA121)*AB119","v":573.76666666666665}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sub-population Adults",{"$f":"AVERAGE(HLOOKUP(C33,Outcomes!$AA$211:$AI$219,5,0),HLOOKUP(C33,Outcomes!$AA$224:$AI$232,5,0),HLOOKUP(C33,Outcomes!$AA$237:$AI$245,5,0))","v":905.66666666666663},{"$f":"Z120*Outcomes!$N$252","v":362.26666666666665}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sub-population Pell",{"$f":"AVERAGE(HLOOKUP(C33,Outcomes!$AA$211:$AI$219,9,0),HLOOKUP(C33,Outcomes!$AA$224:$AI$232,9,0),HLOOKUP(C33,Outcomes!$AA$237:$AI$245,9,0))","v":877},{"$f":"Z121*Outcomes!$N$252","v":350.8}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Masters/Ed Specialist Degrees",{"$f":"AVERAGE(HLOOKUP(C33,Outcomes!$P$211:$X$221,6,0),HLOOKUP(C33,Outcomes!$P$224:$X$234,6,0),HLOOKUP(C33,Outcomes!$P$237:$X$247,6,0))","v":308.66666666666669},{"$f":"Z122/Outcomes!A243","v":1028.8888888888889},{"$f":"HLOOKUP(C33,Outcomes!$C$262:$K$272,6,0)","v":0.2},{"$f":"AA122*AB122","v":205.7777777777778}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Doctoral / Law Degrees",{"$f":"AVERAGE(HLOOKUP(C33,Outcomes!$P$211:$X$221,7,0),HLOOKUP(C33,Outcomes!$P$224:$X$234,7,0),HLOOKUP(C33,Outcomes!$P$237:$X$247,7,0))","v":0},{"$f":"Z123/Outcomes!A244","v":0},{"$f":"HLOOKUP(C33,Outcomes!$C$262:$K$272,7,0)","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Research and Service",{"$f":"AVERAGE(HLOOKUP(C33,Outcomes!$P$211:$X$221,8,0),HLOOKUP(C33,Outcomes!$P$224:$X$234,8,0),HLOOKUP(C33,Outcomes!$P$237:$X$247,8,0))","v":3234935.4933333336},{"$f":"Z124/Outcomes!A245","v":161.74677466666668},{"$f":"HLOOKUP(C33,Outcomes!$C$262:$K$272,8,0)","v":0.1},16.174677466666669]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Transfers Out with 12 hrs",{"$f":"AVERAGE(HLOOKUP(C33,Outcomes!$P$211:$X$221,9,0),HLOOKUP(C33,Outcomes!$P$224:$X$234,9,0),HLOOKUP(C33,Outcomes!$P$237:$X$247,9,0))","v":206.33333333333334},{"$f":"Z125/Outcomes!A246","v":206.33333333333334},{"$f":"HLOOKUP(C33,Outcomes!$C$262:$K$272,9,0)","v":0.1},20.633333333333336]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Degrees per 100 FTE",{"$f":"AVERAGE(HLOOKUP(C33,Outcomes!$P$211:$X$221,10,0),HLOOKUP(C33,Outcomes!$P$224:$X$234,10,0),HLOOKUP(C33,Outcomes!$P$237:$X$247,10,0))","v":18.890211592409369},{"$f":"Z126/Outcomes!A247","v":944.51057962046843},{"$f":"HLOOKUP(C33,Outcomes!$C$262:$K$272,10,0)","v":0.1},94.451057962046846]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Six-Year Graduation Rate",{"$f":"AVERAGE(HLOOKUP(C33,Outcomes!$P$211:$X$221,11,0),HLOOKUP(C33,Outcomes!$P$224:$X$234,11,0),HLOOKUP(C33,Outcomes!$P$237:$X$247,11,0))*100","v":42.805583377052798},{"$f":"Z127/Outcomes!A248","v":1070.13958442632},{"$f":"HLOOKUP(C33,Outcomes!$C$262:$K$272,11,0)","v":0.1},107.013958442632]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AC110:AC127)","v":1303.5954716491235}]

{"sheet":"Printable Summary","index":3,"n_rows":40,"n_cols":8,"rows_kept":40,"cut":false,"hidden":false,"merged":[[43,5,43,7],[0,1,0,7],[1,1,1,7],[4,1,4,3],[39,5,39,7],[36,5,38,7]]}
[null,"Tennessee Higher Education Commission"]
[null,"Summary of Changes in FY 2015-16 Formula Outcomes and Estimated State Appropriations"]
[]
[null,null,null,null,null,null,"Est. Change Due to","Percent Change Due to "]
[null,"Assumptions",null,null,null,null,"Outcomes and Funding*","Outcomes and Funding*"]
[null,"2014-15 State Appropriations",{"$f":"Working!G39","v":827231300},null,null,"APSU",{"$f":"Working!N7","v":0},{"$f":"G6/Working!C7","v":0}]
[null,"Est 2015-16 State Appropriations",{"$f":"ROUND(((1+C8)*C6), -2)","v":827231300},null,null,"ETSU",{"$f":"Working!N8","v":0},{"$f":"G7/Working!C8","v":0}]
[null,"Percentage Change from 2014-15",{"$f":"((D8-100)/2)/100","v":0},100,null,"MTSU",{"$f":"Working!N9","v":0},{"$f":"G8/Working!C9","v":0}]
[null,"Dollar Change from 2014-15",{"$f":"C7-C6","v":0},null,null,"TSU",{"$f":"Working!N10","v":0},{"$f":"G9/Working!C10","v":0}]
[null,"Percent of THEC Rec. Funded",{"$f":"Working!L39","v":0.60928674901547053},null,null,"TTU",{"$f":"Working!N11","v":0},{"$f":"G10/Working!C11","v":0}]
[null,null,null,null,null,"UM",{"$f":"Working!N12","v":0},{"$f":"G11/Working!C12","v":0}]
[null,"University Outcomes**",{"$f":"Outcomes!D4","v":"APSU"},"Avg Univ Change",null,"TBR Univ. Subtotal ",{"$f":"SUM(G6:G11)","v":0},{"$f":"G12/Working!C13","v":0}]
[null,"Students Accumulating 24 hours",{"$f":"HLOOKUP($C$12,Outcomes!$C$29:$K$41,2,0)","v":0},{"$f":"Outcomes!W30","v":0}]
[null,"Students Accumulating 48 hours",{"$f":"HLOOKUP($C$12,Outcomes!$C$29:$K$41,3,0)","v":0},{"$f":"Outcomes!W31","v":0},null,"Chattanooga",{"$f":"Working!N15","v":0},{"$f":"G14/Working!C15","v":0}]
[null,"Students Accumulating 72 hours",{"$f":"HLOOKUP($C$12,Outcomes!$C$29:$K$41,4,0)","v":0},{"$f":"Outcomes!W32","v":0},null,"Cleveland",{"$f":"Working!N16","v":0},{"$f":"G15/Working!C16","v":0}]
[null,"Bachelors and Associates",{"$f":"HLOOKUP($C$12,Outcomes!$C$29:$K$41,5,0)","v":0},{"$f":"Outcomes!W33","v":0},null,"Columbia",{"$f":"Working!N17","v":0},{"$f":"G16/Working!C17","v":0}]
[null,"Masters/Ed Specialist Degrees",{"$f":"HLOOKUP($C$12,Outcomes!$C$29:$K$41,6,0)","v":0},{"$f":"Outcomes!W34","v":0},null,"Dyersburg",{"$f":"Working!N18","v":0},{"$f":"G17/Working!C18","v":0}]
[null,"Doctoral / Law Degrees",{"$f":"HLOOKUP($C$12,Outcomes!$C$29:$K$41,7,0)","v":0},{"$f":"Outcomes!W35","v":0},null,"Jackson",{"$f":"Working!N19","v":0},{"$f":"G18/Working!C19","v":0}]
[null,"Research and Service",{"$f":"HLOOKUP($C$12,Outcomes!$C$29:$K$41,8,0)","v":0},{"$f":"Outcomes!W36","v":0},null,"Motlow",{"$f":"Working!N20","v":0},{"$f":"G19/Working!C20","v":0}]
[null,"Transfers Out with 12 hours",{"$f":"HLOOKUP($C$12,Outcomes!$C$29:$K$41,9,0)","v":0},{"$f":"Outcomes!W37","v":0},null,"Nashville",{"$f":"Working!N21","v":0},{"$f":"G20/Working!C21","v":0}]
[null,"Degrees per 100 FTE",{"$f":"HLOOKUP($C$12,Outcomes!$C$29:$K$41,10,0)","v":0},{"$f":"Outcomes!W38","v":0},null,"Northeast",{"$f":"Working!N22","v":0},{"$f":"G21/Working!C22","v":0}]
[null,"Six-Year Graduation Rate",{"$f":"HLOOKUP($C$12,Outcomes!$C$29:$K$41,11,0)","v":0},{"$f":"Outcomes!W39","v":0},null,"Pellissippi",{"$f":"Working!N23","v":0},{"$f":"G22/Working!C23","v":0}]
[null,"Sub-population Adults",{"$f":"HLOOKUP($C$12,Outcomes!$C$29:$K$41,12,0)","v":0},{"$f":"Outcomes!W40","v":0},null,"Roane",{"$f":"Working!N24","v":0},{"$f":"G23/Working!C24","v":0}]
[null,"Sub-population Pell",{"$f":"HLOOKUP($C$12,Outcomes!$C$29:$K$41,13,0)","v":0},{"$f":"Outcomes!W41","v":0},null,"Southwest",{"$f":"Working!N25","v":0},{"$f":"G24/Working!C25","v":0}]
[null,null,null,null,null,"Volunteer",{"$f":"Working!N26","v":0},{"$f":"G25/Working!C26","v":0}]
[null,"Community College Outcomes**",{"$f":"Outcomes!C4","v":"Chattanooga"},"Avg CC Change",null,"Walters",{"$f":"Working!N27","v":0},{"$f":"G26/Working!C27","v":0}]
[null,"Students Accumulating 12 hours",{"$f":"HLOOKUP($C$26,Outcomes!$C$11:$O$25,2,0)","v":0},{"$f":"Outcomes!W12","v":0},null,"CC Sector Subtotal",{"$f":"SUM(G14:G26)","v":0},{"$f":"G27/Working!C28","v":0}]
[null,"Students Accumulating 24 hours",{"$f":"HLOOKUP($C$26,Outcomes!$C$11:$O$25,3,0)","v":0},{"$f":"Outcomes!W13","v":0}]
[null,"Students Accumulating 36 hours",{"$f":"HLOOKUP($C$26,Outcomes!$C$11:$O$25,4,0)","v":0},{"$f":"Outcomes!W14","v":0},null,"UTC",{"$f":"Working!N30","v":0},{"$f":"G29/Working!C30","v":0}]
[null,"Dual Enrollment",{"$f":"HLOOKUP($C$26,Outcomes!$C$11:$O$25,5,0)","v":0},{"$f":"Outcomes!W15","v":0},null,"UTK",{"$f":"Working!N31","v":0},{"$f":"G30/Working!C31","v":0}]
[null,"Associates",{"$f":"HLOOKUP($C$26,Outcomes!$C$11:$O$25,6,0)","v":0},{"$f":"Outcomes!W16","v":0},null,"UTM",{"$f":"Working!N32","v":0},{"$f":"G31/Working!C32","v":0}]
[null,"Certificates 1-2 Years",{"$f":"HLOOKUP($C$26,Outcomes!$C$11:$O$25,7,0)","v":0},{"$f":"Outcomes!W17","v":0},null,"UT Subtotal ",{"$f":"SUM(G29:G31)","v":0},{"$f":"G32/Working!C33","v":0}]
[null,"Certificates Less Than 1 Year",{"$f":"HLOOKUP($C$26,Outcomes!$C$11:$O$25,8,0)","v":0},{"$f":"Outcomes!W18","v":0}]
[null,"Job Placements",{"$f":"HLOOKUP($C$26,Outcomes!$C$11:$O$25,9,0)","v":0},{"$f":"Outcomes!W19","v":0},null,"TCAT Subtotal",{"$f":"Working!N37","v":0},{"$f":"G34/Working!C37","v":0}]
[null,"R & D Success",{"$f":"HLOOKUP($C$26,Outcomes!$C$11:$O$25,10,0)","v":0},{"$f":"Outcomes!W20","v":0}]
[null,"Transfers Out with 12 hours",{"$f":"HLOOKUP($C$26,Outcomes!$C$11:$O$25,11,0)","v":0},{"$f":"Outcomes!W21","v":0}," ","Total",{"$f":"Working!N39","v":0},{"$f":"G36/Working!C39","v":0}]
[null,"Workforce Training",{"$f":"HLOOKUP($C$26,Outcomes!$C$11:$O$25,12,0)","v":0},{"$f":"Outcomes!W22","v":0},null,"*The estimated change in state appropriations due to changes in both formula outcomes and higher education state appropriations. "]
[null,"Awards per 100 FTE",{"$f":"HLOOKUP($C$26,Outcomes!$C$11:$O$25,13,0)","v":0},{"$f":"Outcomes!W23","v":0}]
[null,"Sub-population Adult",{"$f":"HLOOKUP($C$26,Outcomes!$C$11:$O$25,14,0)","v":0},{"$f":"Outcomes!W24","v":0}]
[null,"Sub-population Pell",{"$f":"HLOOKUP($C$26,Outcomes!$C$11:$O$26,15,0)","v":0},{"$f":"Outcomes!W25","v":0},null,"**Bolded outcome changes indicate above-average increases."]

{"sheet":"Weights","index":4,"n_rows":35,"n_cols":15,"rows_kept":35,"cut":false,"hidden":false,"merged":[[0,1,0,14],[1,1,1,14]]}
[null,"Tennessee Higher Education Commission"]
[null,"Outcomes Formula Weights - Based on Institutional Mission"]
[]
[]
[null,"Universities","UTM","APSU","TTU","UTC","MTSU","ETSU","TSU","UM","UTK"]
[null,"Students Accumulating 24 hrs",0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.02,0.02]
[null,"Students Accumulating 48 hrs",0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.03,0.03]
[null,"Students Accumulating 72 hrs",7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,0.05,0.05]
[null,"Progression",{"$f":"SUM(C6:C8)","v":0.15000000000000002},{"$f":"SUM(D6:D8)","v":0.15000000000000002},0.15000000000000002,0.15000000000000002,0.15000000000000002,0.15000000000000002,0.15000000000000002,0.1,0.1]
[null,"Bachelors and Associates",0.3,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.15]
[null,"Masters / Ed Specialist Degrees",0.15,0.2,0.15,0.15,0.15,0.15,0.15,0.15,0.15]
[null,"Doctoral / Law Degrees",0,0,0.05,0.05,7.4999999999999997E-2,7.4999999999999997E-2,7.4999999999999997E-2,0.1,0.1]
[null,"Research and Service",0.1,0.1,0.1,0.1,0.125,0.125,0.125,0.125,0.15]
[null,"Transfers Out with 12 hrs",0.1,0.1,0.1,0.1,0.05,0.05,0.05,0.05,0.05]
[null,"Degrees per 100 FTE",0.15,0.1,0.1,0.1,0.1,0.1,0.1,7.4999999999999997E-2,0.1]
[null,"Six-Year Graduation Rate",0.05,0.1,0.1,0.1,0.1,0.1,0.1,0.15,0.2]
[null,null,{"$f":"SUM(C9:C16)","v":1},{"$f":"SUM(D9:D16)","v":1},1,1,1,1,1,1,1]
[]
[]
[null,"Community Colleges","CHSCC","CLSCC","COSCC","DSCC","JSCC","MSCC","NASCC","NESCC","PSCC","RSCC","STCC","VSCC","WSCC"]
[null,"Students Accumulating 12 hrs",0.06,0.06,0.04,0.06,0.06,0.06,0.04,0.04,0.06,0.02,0.04,0.02,0.04]
[null,"Students Accumulating 24 hrs",7.0000000000000007E-2,7.0000000000000007E-2,0.05,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,0.05,0.05,7.0000000000000007E-2,0.03,0.05,0.03,0.05]
[null,"Students Accumulating 36 hrs",7.0000000000000007E-2,7.0000000000000007E-2,0.06,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,0.06,0.06,7.0000000000000007E-2,0.05,0.06,0.05,0.06]
[null,"Progression",{"$f":"SUM(C21:C23)","v":0.2},{"$f":"SUM(D21:D23)","v":0.2},0.15,0.2,0.2,0.2,0.15,0.15,0.2,0.1,0.15,0.1,0.15]
[null,"Dual Enrollment",0.05,0.1,0.1,0.05,0.05,0.05,0.05,0.05,0.1,0.1,0.05,0.1,0.1]
[null,"Associates",0.05,0.15,0.1,0.1,0.2,0.1,0.2,0.2,0.2,0.2,0.1,0.2,0.2]
[null,"Certificates 1-2 Years",0.05,0.01,0.04,0.02,0.03,0,7.0000000000000007E-2,0.17,0,0.06,0.02,0.04,0.01]
[null,"Certificates Less Than 1 Year",0.05,0.09,0.01,0.08,7.0000000000000007E-2,0.05,0.13,0.03,0.05,0.14000000000000001,0.18,0.16,0.19]
[null,"Total Certificates",{"$f":"C27+C28","v":0.1},{"$f":"D27+D28","v":9.9999999999999992E-2},0.05,0.1,0.1,0.05,0.2,0.2,0.05,0.2,0.19999999999999998,0.2,0.2]
[null,"Job Placements",0.2,0.05,0.05,0.1,0.05,0.1,0.1,0.1,0.1,0.15,0.1,0.05,0.05]
[null,"Remedial & Developmental Success",0.1,0.2,0.1,0.2,0.15,0.1,0.1,0.05,0.05,0.05,0.2,0.1,0.1]
[null,"Transfers Out with 12 hrs",0.15,0.1,0.2,0.15,0.1,0.2,0.1,0.1,0.15,0.1,0.05,0.15,0.1]
[null,"Workforce Training (Contact Hours)",0.1,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.1,0.05,0.05,0.05,0.05]
[null,"Awards per 100 FTE",0.05,0.05,0.2,0.05,0.1,0.15,0.05,0.1,0.05,0.05,0.1,0.05,0.05]
[null,null,{"$f":"SUM(C21:C23,C25:C28,C30:C34)","v":1},{"$f":"SUM(D21:D23,D25:D28,D30:D34)","v":1},1,1,1.0000000000000002,1,1,1.0000000000000002,1,1.0000000000000002,1.0000000000000002,1,1]

{"sheet":"Historical Trends","index":5,"n_rows":177,"n_cols":17,"rows_kept":177,"cut":false,"hidden":false,"merged":[[133,0,134,0],[133,9,134,9],[148,9,149,9],[148,0,149,0],[163,0,164,0],[164,9,167,16],[131,0,131,16],[41,0,41,16],[42,0,42,16],[16,0,17,0],[16,9,17,9],[29,9,30,9],[29,0,30,0],[43,0,44,0],[43,9,44,9],[56,0,57,0],[71,0,72,0],[71,9,72,9],[86,9,87,9],[0,0,0,16],[1,0,1,16],[68,0,68,16],[69,0,69,16],[130,0,130,16],[3,0,4,0],[3,9,4,9],[86,0,87,0],[101,0,102,0],[101,9,102,9],[116,9,117,9],[116,0,117,0]]}
["Tennessee Higher Education Commission"]
["Historical Trends of Outcomes Used in Funding Formula"]
[]
["UTM",null,null,null,null,null,null,"Avg. Annual",null,"ETSU",null,null,null,null,null,null,"Avg. Annual"]
[null,"2007-08","2008-09","2009-10","2010-11","2011-12","2012-13","Change",null,null,"2007-08","2008-09","2009-10","2010-11","2011-12","2012-13","Change"]
["Students Accumulating 24 hrs",1415,1514,1514,1351,1261,1217,{"$f":"((G6-B6)/B6)/5","v":-2.7985865724381626E-2},null,"Students Accumulating 24 hrs",2055,2110,2152,1816,1823,1764,{"$f":"((P6-K6)/K6)/5","v":-2.8321167883211679E-2}]
["Students Accumulating 48 hrs",1072,1158,1301,1283,1163,1155,{"$f":"((G7-B7)/B7)/5","v":1.5485074626865672E-2},null,"Students Accumulating 48 hrs",1656,1811,1949,1745,1716,1709,{"$f":"((P7-K7)/K7)/5","v":6.4009661835748802E-3}]
["Students Accumulating 72 hrs",1013,1114,1147,1299,1206,1203,3.751233958538993E-2,null,"Students Accumulating 72 hrs",1859,1840,1977,1919,2040,1879,2.1516944593867669E-3]
["Bachelors and Associates",998,1018,1017,1038,1116,1247,4.9899799599198394E-2,null,"Bachelors and Associates",1693,1878,1873,2028,2146,2314,7.3360897814530424E-2]
["Masters / Ed Specialist Degrees",140,115,129,131,132,122,-2.571428571428571E-2,null,"Masters / Ed Specialist Degrees",530,577,655,630,609,576,1.7358490566037735E-2]
["Doctoral / Law Degrees",0,0,0,0,0,0,0,null,"Doctoral / Law Degrees",69,75,57,79,83,86,4.9275362318840582E-2]
["Research and Service",4527800,4386318,4311201.5199999996,3646780.32,3036994.36,2001803.7700000003,{"$f":"((G12-B12)/B12)/5","v":-0.11157719996466273},null,"Research and Service",20082056,21215713,22883113.969999999,24085480,23159718,22836711,2.7433993810195529E-2]
["Transfers Out with 12 hrs",249,195,225,223,260,264,1.2048192771084338E-2,null,"Transfers Out with 12 hrs",312,298,321,338,391,417,{"$f":"((P13-K13)/K13)/5","v":6.7307692307692318E-2}]
["Degrees per 100 FTE",16.43,16.260000000000002,15.282125773247515,15.04217024606556,16.32955659498505,18.522736275053475,2.5474574255063609E-2,null,"Degrees per 100 FTE",17.440000000000001,18.739999999999998,17.689726169713072,18.281469729203476,18.915043894183871,21.04918450328837,4.1389730542297797E-2]
["Six-Year Graduation Rate",0.52759999999999996,0.54900000000000004,0.54437869822485208,0.58685064935064934,0.56702747710241463,0.53,9.0978013646704665E-4,null,"Six-Year Graduation Rate",0.48199999999999998,0.48720000000000002,0.4593140551445864,0.5128369704749679,0.48483080513418902,0.47789999999999999,-1.7012448132780055E-3]
[]
["APSU",null,null,null,null,null,null,"Avg. Annual",null,"TSU",null,null,null,null,null,null,"Avg. Annual"]
[null,"2007-08","2008-09","2009-10","2010-11","2011-12","2012-13","Change",null,null,"2007-08","2008-09","2009-10","2010-11","2011-12","2012-13","Change"]
["Students Accumulating 24 hrs",1580,1703,1811,1582,1502,1463,{"$f":"((G19-B19)/B19)/5","v":-1.4810126582278482E-2},null,"Students Accumulating 24 hrs",1435,1184,1360,999,976,994,{"$f":"((P19-K19)/K19)/5","v":-6.1463414634146341E-2}]
["Students Accumulating 48 hrs",1358,1448,1487,1354,1433,1476,{"$f":"((G20-B20)/B20)/5","v":1.7378497790868926E-2},null,"Students Accumulating 48 hrs",1114,983,956,861,901,839,{"$f":"((P20-K20)/K20)/5","v":-4.9371633752244168E-2}]
["Students Accumulating 72 hrs",1262,1368,1360,1309,1386,1466,3.2329635499207608E-2,null,"Students Accumulating 72 hrs",1157,1042,939,861,892,915,-4.1832324978392392E-2]
["Bachelors and Associates",1268,1319,1291,1468,1553,1725,7.2082018927444785E-2,null,"Bachelors and Associates",1144,1060,1098,1081,1098,1066,-1.3636363636363636E-2]
["Masters / Ed Specialist Degrees",222,254,271,296,326,304,7.3873873873873869E-2,null,"Masters / Ed Specialist Degrees",444,426,393,377,434,417,-1.2162162162162163E-2]
["Doctoral / Law Degrees",0,0,0,0,0,0,0,null,"Doctoral / Law Degrees",50,60,79,67,72,66,6.4000000000000001E-2]
["Research and Service",2745864,2895210,3604390.4599999995,3489372.48,3601246,2614188,-9.5908610186083501E-3,null,"Research and Service",23645198,26360601,27508381.859999999,33644726,31029229,31582168,{"$f":"((P25-K25)/K25)/5","v":6.7133884858989121E-2}]
["Transfers Out with 12 hrs",159,142,149,173,227,219,7.5471698113207558E-2,null,"Transfers Out with 12 hrs",142,145,161,178,228,235,0.13098591549295774]
["Degrees per 100 FTE",17.89,18.12,16.925598164536218,17.947599854919492,18.258702178189886,20.464332744118728,2.8779572321058999E-2,null,"Degrees per 100 FTE",17.66,18.22,18.101288081944872,17.735946053847712,17.585726412223522,18.050460010159732,4.4219706699856372E-3]
["Six-Year Graduation Rate",0.37730000000000002,0.37559999999999999,0.39324894514767933,0.43678160919540232,0.42738589211618255,0.42,2.263450834879404E-2,null,"Six-Year Graduation Rate",0.40350000000000003,0.43580000000000002,0.38833333333333331,0.38099243061396132,0.38402061855670105,0.33200000000000002,-3.5439900867410161E-2]
[]
["TTU",null,null,null,null,null,null,"Avg. Annual",null,"UM",null,null,null,null,null,null,"Avg. Annual"]
[null,"2007-08","2008-09","2009-10","2010-11","2011-12","2012-13","Change",null,null,"2007-08","2008-09","2009-10","2010-11","2011-12","2012-13","Change"]
["Students Accumulating 24 hrs",1665,1650,1871,1589,1645,1830,{"$f":"((G32-B32)/B32)/5","v":1.9819819819819819E-2},null,"Students Accumulating 24 hrs",2709,2620,2676,2241,2324,2135,{"$f":"((P32-K32)/K32)/5","v":-4.2377260981912149E-2}]
["Students Accumulating 48 hrs",1356,1469,1481,1559,1545,1562,{"$f":"((G33-B33)/B33)/5","v":3.0383480825958702E-2},null,"Students Accumulating 48 hrs",2435,2537,2489,2228,2321,2394,{"$f":"((P33-K33)/K33)/5","v":-3.367556468172485E-3}]
["Students Accumulating 72 hrs",1461,1567,1655,1592,1728,1605,1.9712525667351131E-2,null,"Students Accumulating 72 hrs",2385,2601,2790,2486,2491,2625,2.0125786163522015E-2]
["Bachelors and Associates",1445,1528,1528,1603,1696,1830,5.3287197231833908E-2,null,"Bachelors and Associates",2454,2590,2562,2678,2724,2887,3.5289323553382233E-2]
["Masters / Ed Specialist Degrees",684,804,633,644,444,376,-9.005847953216374E-2,null,"Masters / Ed Specialist Degrees",886,872,823,1042,1009,1064,4.018058690744921E-2]
["Doctoral / Law Degrees",24,17,19,21,18,12,-0.1,null,"Doctoral / Law Degrees",233,253,252,256,271,259,2.2317596566523608E-2]
["Research and Service",9274442,10266020,11039730.83,10396767.689999999,9586008.5899999999,8873329,-8.6498573175615313E-3,null,"Research and Service",59102164,58424588,68999975,62442725,55561194,51992967,-2.4057315397114733E-2]
["Transfers Out with 12 hrs",277,241,296,266,355,343,4.7653429602888084E-2,null,"Transfers Out with 12 hrs",307,314,299,263,521,492,0.12052117263843649]
["Degrees per 100 FTE",19.690000000000001,20.079999999999998,18.913622016380256,18.773789307255374,19.019778625925664,20.220919996611432,5.3927881829500309E-3,null,"Degrees per 100 FTE",18.34,19.059999999999999,18.207316090946563,17.978946237714162,17.943442585155601,19.565099531033983,1.3359864024361867E-2]
["Six-Year Graduation Rate",0.51190000000000002,0.58179999999999998,0.55964771817453962,0.56074766355140182,0.55582329317269075,0.57450000000000001,2.4457901933971474E-2,null,"Six-Year Graduation Rate",0.44400000000000001,0.42730000000000001,0.423837784371909,0.45351696999508118,0.44133268952197008,0.47060000000000002,1.1981981981981988E-2]
["Tennessee Higher Education Commission"]
["Outcomes Historical Trends"]
["UTC",null,null,null,null,null,null,"Avg. Annual",null,"UTK",null,null,null,null,null,null,"Avg. Annual"]
[null,"2007-08","2008-09","2009-10","2010-11","2011-12","2012-13","Change",null,null,"2007-08","2008-09","2009-10","2010-11","2011-12","2012-13","Change"]
["Students Accumulating 24 hrs",1813,1924,2181,1853,1721,2067,{"$f":"((G46-B46)/B46)/5","v":2.8019856591285162E-2},null,"Students Accumulating 24 hrs",4401,4239,3566,3854,3264,3331,{"$f":"((P46-K46)/K46)/5","v":-4.8625312428993414E-2}]
["Students Accumulating 48 hrs",1365,1421,1609,1712,1519,1581,{"$f":"((G47-B47)/B47)/5","v":3.1648351648351648E-2},null,"Students Accumulating 48 hrs",4395,4541,4320,3925,3844,3864,{"$f":"((P47-K47)/K47)/5","v":-2.4163822525597269E-2}]
["Students Accumulating 72 hrs",1268,1427,1522,1696,1634,1633,5.7570977917981069E-2,null,"Students Accumulating 72 hrs",4379,4473,4774,4246,4020,4187,-8.7691253710892904E-3]
["Bachelors and Associates",1258,1256,1275,1320,1514,1638,6.0413354531001592E-2,null,"Bachelors and Associates",3624,4107,4108,4332,4539,4407,4.3211920529801322E-2]
["Masters / Ed Specialist Degrees",400,404,427,432,490,446,2.3E-2,null,"Masters / Ed Specialist Degrees",1502,1645,1573,1515,1583,1607,1.3981358189081226E-2]
["Doctoral / Law Degrees",38,50,52,60,54,68,0.15789473684210525,null,"Doctoral / Law Degrees",250,416,492,481,571,565,0.252]
["Research and Service",11077571,9277657,10899108.649999999,10350478.84,11444946.98,10409339.950000001,-1.2064577153240523E-2,null,"Research and Service",141229902,141229902,132545115.68000001,151215597.03,149350434.41999999,154378165.38999999,1.8619659440109199E-2]
["Transfers Out with 12 hrs",317,389,399,429,573,606,0.18233438485804415,null,"Transfers Out with 12 hrs",560,585,629,444,599,609,1.7499999999999998E-2]
["Degrees per 100 FTE",17.28,16.260000000000002,15.265256276714201,15.376055210910167,16.90763710001638,17.942688555237481,7.6700064263597236E-3,null,"Degrees per 100 FTE",17.940000000000001,19.829999999999998,20.245761598107503,21.923213758250515,23.380436462286017,22.766212811827891,5.380393324222843E-2]
["Six-Year Graduation Rate",0.48130000000000001,0.53039999999999998,0.4976494291470786,0.51563585823488534,0.51501416430594904,0.49709999999999999,6.5655516309993684E-3,null,"Six-Year Graduation Rate",0.64649999999999996,0.6583,0.66666666666666663,0.69809097336790005,0.71628347949751126,0.7319,2.6419180201082765E-2]
[]
["MTSU",null,null,null,null,null,null,"Avg. Annual"]
[null,"2007-08","2008-09","2009-10","2010-11","2011-12","2012-13","Change"]
["Students Accumulating 24 hrs",3993,3971,4051,3430,3297,2799,{"$f":"((G59-B59)/B59)/5","v":-5.980465815176559E-2}]
["Students Accumulating 48 hrs",3568,3754,3907,3380,3458,3211,{"$f":"((G60-B60)/B60)/5","v":-2.0011210762331838E-2}]
["Students Accumulating 72 hrs",3619,3743,4065,3788,3804,3734,6.3553467808786955E-3]
["Bachelors and Associates",3549,3789,3629,3868,3911,4159,3.4375880529726684E-2]
["Masters / Ed Specialist Degrees",688,777,831,923,925,1010,9.3604651162790695E-2]
["Doctoral / Law Degrees",15,24,20,20,20,23,0.10666666666666666]
["Research and Service",27478805,29049938,27539106.420000002,28349988.18,30655961.199999999,13498343,-0.10175451225044174]
["Transfers Out with 12 hrs",505,506,576,470,726,678,6.851485148514852E-2]
["Degrees per 100 FTE",18.62,19.600000000000001,18.037616059061719,18.371544055133633,18.866104204956031,21.182570430306509,2.7524924063442618E-2]
["Six-Year Graduation Rate",0.51749999999999996,0.53490000000000004,0.53740409207161122,0.52445141065830725,0.51563896336014303,0.52370000000000005,2.3961352657005199E-3]
["Tennessee Higher Education Commission"]
["Outcomes Historical Trends"]
[]
["CHSCC",null,null,null,null,null,null,"Avg. Annual",null,"NESCC",null,null,null,null,null,null,"Avg. Annual"]
[null,"2007-08","2008-09","2009-10","2010-11","2011-12","2012-13","Change",null,null,"2007-08","2008-09","2009-10","2010-11","2011-12","2012-13","Change"]
["Students Accumulating 12 hrs",3067,3263,3482,2716,2351,2318,{"$f":"((G74-B74)/B74)/5","v":-4.8842517117704598E-2},null,"Students Accumulating 12 hrs",1890,2084,2427,1744,1485,1664,{"$f":"((P74-K74)/K74)/5","v":-2.3915343915343914E-2}]
["Students Accumulating 24 hrs",1908,2118,2454,1969,1872,1801,{"$f":"((G75-B75)/B75)/5","v":-1.1215932914046121E-2},null,"Students Accumulating 24 hrs",1458,1595,1864,1480,1326,1348,{"$f":"((P75-K75)/K75)/5","v":-1.5089163237311385E-2}]
["Students Accumulating 36 hrs",1320,1609,1959,1647,1646,1591,4.1060606060606061E-2,null,"Students Accumulating 36 hrs",1106,1170,1400,1262,1217,1125,3.4358047016274868E-3]
["Dual Enrollment",974,1060,1003,1095,1155,1253,5.7289527720739218E-2,null,"Dual Enrollment",364,402,487,566,585,723,{"$f":"((P77-K77)/K77)/5","v":0.19725274725274727}]
["Associates",652,617,745,842,896,1002,0.10736196319018405,null,"Associates",536,635,687,696,764,720,{"$f":"((P78-K78)/K78)/5","v":6.8656716417910449E-2}]
["Certificates 1-2 Years",10,3,99,123,146,229,4.38,null,"Certificates 1-2 Years",22,5,218,132,110,104,{"$f":"((P79-K79)/K79)/5","v":0.74545454545454537}]
["Certificates Less Than 1 Year",86,101,8,28,105,194,0.25116279069767444,null,"Certificates Less Than 1 Year",132,128,4,3,10,25,{"$f":"((P80-K80)/K80)/5","v":-0.16212121212121211}]
["Job Placements",424,407,381,429,407,381,-2.0283018867924531E-2,null,"Job Placements",238,248,163,249,261,275,3.1092436974789917E-2]
["Remedial & Developmental Success",2211,2149,2091,2159,2849,2875,6.0063319764812308E-2,null,"Remedial & Developmental Success",1364,1404,1352,1475,1855,2129,0.11217008797653957]
["Transfers Out with 12 hrs",405,345,360,440,531,561,7.7037037037037043E-2,null,"Transfers Out with 12 hrs",388,257,340,366,404,379,-4.6391752577319588E-3]
["Workforce Training (Contact Hours)",71596,41149,97351,163769.5,241976.5,149621,0.2179591038605509,null,"Workforce Training (Contact Hours)",4440,6011,4717,5556,6557.5,6434,8.9819819819819818E-2]
["Awards per 100 FTE",14.13,12.61,13.17343461408392,13.31769252001104,14.723891704504776,17.826800540644914,5.23255561308551E-2,null,"Awards per 100 FTE",18.579999999999998,19.649999999999999,20.06622222879189,16.661412463863382,18.649444499765284,18.363617454350958,-2.3291985538109799E-3]
[]
["CLSCC",null,null,null,null,null,null,"Avg. Annual",null,"PSCC",null,null,null,null,null,null,"Avg. Annual"]
[null,"2007-08","2008-09","2009-10","2010-11","2011-12","2012-13","Change",null,null,"2007-08","2008-09","2009-10","2010-11","2011-12","2012-13","Change"]
["Students Accumulating 12 hrs",1226,1448,1707,1141,1164,1060,{"$f":"((G89-B89)/B89)/5","v":-2.7079934747145189E-2},null,"Students Accumulating 12 hrs",3423,3689,4389,2943,3001,2823,{"$f":"((P89-K89)/K89)/5","v":-3.5056967572304996E-2}]
["Students Accumulating 24 hrs",879,894,1056,897,817,716,{"$f":"((G90-B90)/B90)/5","v":-3.7087599544937427E-2},null,"Students Accumulating 24 hrs",2262,2513,2847,2490,2350,2346,{"$f":"((P90-K90)/K90)/5","v":7.4270557029177718E-3}]
["Students Accumulating 36 hrs",669,688,769,744,659,605,-1.9133034379671152E-2,null,"Students Accumulating 36 hrs",1820,1842,2137,2092,2012,1947,1.3956043956043957E-2]
["Dual Enrollment",382,527,582,626,627,615,0.12198952879581151,null,"Dual Enrollment",675,829,1164,1245,1525,1213,0.15940740740740739]
["Associates",277,291,327,354,370,372,6.8592057761732855E-2,null,"Associates",652,670,794,932,1101,1258,{"$f":"((P93-K93)/K93)/5","v":0.18588957055214722}]
["Certificates 1-2 Years",33,35,22,39,49,29,-2.4242424242424242E-2,null,"Certificates 1-2 Years",15,17,0,0,0,0,-0.2]
["Certificates Less Than 1 Year",11,7,59,145,166,153,2.5818181818181816,null,"Certificates Less Than 1 Year",null,null,10,3,190,1152,"N/A"]
["Job Placements",125,135,124,200,216,190,0.10400000000000001,null,"Job Placements",168,190,156,189,395,310,0.16904761904761906]
["Remedial & Developmental Success",760,766,760,836,944,1023,6.9210526315789472E-2,null,"Remedial & Developmental Success",1743,1769,1926,1986,2760,3140,0.16029833620195066]
["Transfers Out with 12 hrs",187,148,183,201,236,205,1.925133689839572E-2,null,"Transfers Out with 12 hrs",665,704,720,614,736,840,5.2631578947368418E-2]
["Workforce Training (Contact Hours)",231,379,3582,7276,4014,7596,6.3766233766233764,null,"Workforce Training (Contact Hours)",22230,19668,34325,62867,46117.8,45598,0.21023841655420603]
["Awards per 100 FTE",13.81,12.95,13.456891676520488,14.53832494820953,15.735513188037503,15.888949057625506,3.0107879183569962E-2,null,"Awards per 100 FTE",11.07,10.78,11.063683528488289,11.97256074062021,13.974150149133754,16.898381355363021,0.10530047615832017]
[]
["COSCC",null,null,null,null,null,null,"Avg. Annual",null,"RSCC",null,null,null,null,null,null,"Avg. Annual"]
[null,"2007-08","2008-09","2009-10","2010-11","2011-12","2012-13","Change",null,null,"2007-08","2008-09","2009-10","2010-11","2011-12","2012-13","Change"]
["Students Accumulating 12 hrs",1920,1789,2144,1620,1558,1538,{"$f":"((G104-B104)/B104)/5","v":-3.9791666666666663E-2},null,"Students Accumulating 12 hrs",1955,2029,2494,1784,1687,1642,{"$f":"((P104-K104)/K104)/5","v":-3.2020460358056266E-2}]
["Students Accumulating 24 hrs",1357,1401,1599,1412,1304,1284,{"$f":"((G105-B105)/B105)/5","v":-1.0759027266028003E-2},null,"Students Accumulating 24 hrs",1474,1462,1696,1414,1269,1256,{"$f":"((P105-K105)/K105)/5","v":-2.9579375848032562E-2}]
["Students Accumulating 36 hrs",957,1097,1239,1140,1050,1012,1.1494252873563218E-2,null,"Students Accumulating 36 hrs",1137,1170,1230,1189,1107,1111,-4.5734388742304311E-3]
["Dual Enrollment",556,649,735,674,791,843,0.10323741007194245,null,"Dual Enrollment",552,816,1023,1372,1655,1632,0.39130434782608697]
["Associates",472,483,543,540,611,599,5.3813559322033896E-2,null,"Associates",620,617,676,771,804,787,5.3870967741935484E-2]
["Certificates 1-2 Years",null,9,63,51,47,52,"N/A",null,"Certificates 1-2 Years",33,28,28,60,91,77,0.26666666666666666]
["Certificates Less Than 1 Year",14,68,2,0,2,3,{"$f":"((G110-B110)/B110)/5","v":-0.15714285714285714},null,"Certificates Less Than 1 Year",28,9,26,31,22,9,-0.13571428571428573]
["Job Placements",222,158,218,240,234,212,-9.0090090090090089E-3,null,"Job Placements",432,375,360,427,391,389,-1.9907407407407408E-2]
["Remedial & Developmental Success",1225,1220,1184,1248,1465,1553,5.3551020408163265E-2,null,"Remedial & Developmental Success",1293,1281,1336,1342,1650,1767,7.3317865429234338E-2]
["Transfers Out with 12 hrs",384,386,359,410,449,413,1.5104166666666665E-2,null,"Transfers Out with 12 hrs",399,397,417,413,486,445,2.3057644110275687E-2]
["Workforce Training (Contact Hours)",84335,44440,71585,67122,54072,63095,-5.0370546036639596E-2,null,"Workforce Training (Contact Hours)",48554,47022,49275,94910,82249.5,116535,0.28002224327552827]
["Awards per 100 FTE",15.48,16.97,16.309174583523966,15.289755087961366,18.187011120426757,18.710660190268154,4.1739795739898625E-2,null,"Awards per 100 FTE",17.059999999999999,16.13,15.946001041926205,17.752743379216547,19.994042743316705,20.240986435727841,3.7291751884265444E-2]
[]
["DSCC",null,null,null,null,null,null,"Avg. Annual",null,"STCC",null,null,null,null,null,null,"Avg. Annual"]
[null,"2007-08","2008-09","2009-10","2010-11","2011-12","2012-13","Change",null,null,"2007-08","2008-09","2009-10","2010-11","2011-12","2012-13","Change"]
["Students Accumulating 12 hrs",1036,1208,1611,1122,1039,959,{"$f":"((G119-B119)/B119)/5","v":-1.4864864864864866E-2},null,"Students Accumulating 12 hrs",3694,5453,6666,4127,3898,2976,{"$f":"((P119-K119)/K119)/5","v":-3.8873849485652409E-2}]
["Students Accumulating 24 hrs",658,732,1028,707,780,625,{"$f":"((G120-B120)/B120)/5","v":-1.0030395136778116E-2},null,"Students Accumulating 24 hrs",3494,3650,4527,3186,3072,2446,{"$f":"((P120-K120)/K120)/5","v":-5.9988551803091018E-2}]
["Students Accumulating 36 hrs",511,502,609,530,542,542,{"$f":"((G121-B121)/B121)/5","v":1.2133072407045009E-2},null,"Students Accumulating 36 hrs",2388,2457,2933,2348,2360,1911,-3.9949748743718594E-2]
["Dual Enrollment",430,551,599,765,803,887,0.21255813953488373,null,"Dual Enrollment",143,267,421,367,409,407,0.36923076923076925]
["Associates",187,213,215,260,280,300,0.12085561497326203,null,"Associates",733,609,664,841,808,897,4.4747612551159617E-2]
["Certificates 1-2 Years",18,7,0,15,32,26,8.8888888888888878E-2,null,"Certificates 1-2 Years",307,274,58,63,49,63,-0.15895765472312703]
["Certificates Less Than 1 Year",null,null,14,2,11,17,"N/A",null,"Certificates Less Than 1 Year",46,44,300,339,305,344,1.2956521739130435]
["Job Placements",92,77,72,98,101,121,6.3043478260869562E-2,null,"Job Placements",599,435,393,366,487,434,-5.5091819699499167E-2]
["Remedial & Developmental Success",859,798,734,857,1157,1198,{"$f":"((G127-B127)/B127)/5","v":7.8928987194412104E-2},null,"Remedial & Developmental Success",4339,3982,3742,3912,4687,4740,1.8483521548743949E-2]
["Transfers Out with 12 hrs",191,170,180,190,218,242,5.3403141361256547E-2,null,"Transfers Out with 12 hrs",574,559,589,675,778,769,6.7944250871080136E-2]
["Workforce Training (Contact Hours)",6793,6373,5938,5909,6027,7114,9.4509053437361983E-3,null,"Workforce Training (Contact Hours)",58588,57015,45457,53210.899999999507,74171.790000000008,75009,5.6055847613845841E-2]
["Awards per 100 FTE",11.12,11.76,9.4078179696616093,11.281434177959497,13.339794202320213,14.704776797125202,6.4474402825992858E-2,null,"Awards per 100 FTE",10.07,8.02,7.6737487644414211,9.4016175496860921,9.0334458854076995,11.904811114463932,3.6441134348836779E-2]
["Tennessee Higher Education Commission"]
["Outcomes Historical Trends"]
[]
["JSCC",null,null,null,null,null,null,"Avg. Annual",null,"VSCC",null,null,null,null,null,null,"Avg. Annual"]
[null,"2007-08","2008-09","2009-10","2010-11","2011-12","2012-13","Change",null,null,"2007-08","2008-09","2009-10","2010-11","2011-12","2012-13","Change"]
["Students Accumulating 12 hrs",1915,1882,2375,1351,1194,1127,{"$f":"((G136-B136)/B136)/5","v":-8.2297650130548308E-2},null,"Students Accumulating 12 hrs",2916,3145,3899,2469,2132,2037,{"$f":"((P136-K136)/K136)/5","v":-6.0288065843621397E-2}]
["Students Accumulating 24 hrs",1086,1088,1314,1010,921,899,{"$f":"((G137-B137)/B137)/5","v":-3.4438305709023939E-2},null,"Students Accumulating 24 hrs",1665,1891,2262,1781,1684,1597,{"$f":"((P137-K137)/K137)/5","v":-8.1681681681681668E-3}]
["Students Accumulating 36 hrs",824,863,976,847,782,691,-3.2281553398058258E-2,null,"Students Accumulating 36 hrs",1273,1374,1540,1490,1446,1365,{"$f":"((P138-K138)/K138)/5","v":1.4454045561665357E-2}]
["Dual Enrollment",361,666,837,971,815,800,0.24321329639889194,null,"Dual Enrollment",1353,1334,1351,1519,1566,1792,6.4892830746489286E-2]
["Associates",470,462,524,576,554,509,{"$f":"((G140-B140)/B140)/5","v":1.6595744680851062E-2},null,"Associates",590,616,628,723,763,787,6.6779661016949154E-2]
["Certificates 1-2 Years",13,13,13,0,34,34,0.32307692307692309,null,"Certificates 1-2 Years",131,170,73,82,88,73,-8.8549618320610687E-2]
["Certificates Less Than 1 Year",10,20,21,22,25,41,0.62,null,"Certificates Less Than 1 Year",48,65,196,310,205,399,{"$f":"((P142-K142)/K142)/5","v":1.4624999999999999}]
["Job Placements",246,246,289,279,284,357,9.0243902439024387E-2,null,"Job Placements",344,335,392,278,387,448,6.0465116279069767E-2]
["Remedial & Developmental Success",1058,1150,1094,1171,1408,1435,7.1266540642722115E-2,null,"Remedial & Developmental Success",1982,1871,1484,1966,2329,2426,4.4803229061553984E-2]
["Transfers Out with 12 hrs",213,241,252,288,280,294,7.605633802816901E-2,null,"Transfers Out with 12 hrs",572,472,522,536,627,585,4.5454545454545452E-3]
["Workforce Training (Contact Hours)",35506,2704,21008,17182,14018.5,17853,-9.9436714921421726E-2,null,"Workforce Training (Contact Hours)",33785,56858,98468,71174,95564.05,74639,0.24184697350895368]
["Awards per 100 FTE",15.43,15.27,14.895840075450065,15.843181839019337,17.37811185435487,18.228205042129645,3.6269670021123072E-2,null,"Awards per 100 FTE",13.54,13.75,11.859847395401561,13.119794863994178,14.659186825680276,15.998908601583766,3.6320658812167908E-2]
[]
["MSCC",null,null,null,null,null,null,"Avg. Annual",null,"WSCC",null,null,null,null,null,null,"Avg. Annual"]
[null,"2007-08","2008-09","2009-10","2010-11","2011-12","2012-13","Change",null,null,"2007-08","2008-09","2009-10","2010-11","2011-12","2012-13","Change"]
["Students Accumulating 12 hrs",1830,1956,2202,1457,1410,1363,{"$f":"((G151-B151)/B151)/5","v":-5.103825136612021E-2},null,"Students Accumulating 12 hrs",2268,2444,2842,1988,1976,1927,{"$f":"((P151-K151)/K151)/5","v":-3.0070546737213405E-2}]
["Students Accumulating 24 hrs",1257,1330,1599,1139,1133,1044,{"$f":"((G152-B152)/B152)/5","v":-3.389021479713604E-2},null,"Students Accumulating 24 hrs",1564,1715,1970,1474,1393,1311,{"$f":"((P152-K152)/K152)/5","v":-3.2352941176470591E-2}]
["Students Accumulating 36 hrs",909,970,1140,993,962,901,-1.7601760176017601E-3,null,"Students Accumulating 36 hrs",1172,1342,1411,1329,1173,1112,{"$f":"((P153-K153)/K153)/5","v":-1.0238907849829351E-2}]
["Dual Enrollment",563,585,686,787,854,859,0.10515097690941386,null,"Dual Enrollment",959,801,924,1011,1261,1407,9.3430656934306563E-2]
["Associates",404,460,537,526,627,568,8.1188118811881191E-2,null,"Associates",622,558,715,720,791,838,6.9453376205787787E-2]
["Certificates 1-2 Years",7,3,0,0,0,1,-0.17142857142857143,null,"Certificates 1-2 Years",256,224,16,16,18,14,-0.18906249999999999]
["Certificates Less Than 1 Year",null,null,3,28,45,22,"N/A",null,"Certificates Less Than 1 Year",23,3,226,256,265,226,1.7652173913043476]
["Job Placements",74,74,72,70,105,73,-2.7027027027027029E-3,null,"Job Placements",508,467,507,501,544,473,-1.3779527559055118E-2]
["Remedial & Developmental Success",1055,1156,1307,1440,1692,1620,0.10710900473933649,null,"Remedial & Developmental Success",1498,1390,1422,1545,1817,1846,4.6461949265687585E-2]
["Transfers Out with 12 hrs",426,406,423,508,540,499,3.4272300469483569E-2,null,"Transfers Out with 12 hrs",399,334,383,409,479,385,-7.0175438596491221E-3]
["Workforce Training (Contact Hours)",1355,1990,12078,5513,8803,5493,0.6107749077490775,null,"Workforce Training (Contact Hours)",32371,37176,88322,129099,197866,194026,0.99876432609434374]
["Awards per 100 FTE",14.17,15.02,15.309467922340799,15.205388373370335,19.12012848401065,18.703979663394112,6.3994067232097551E-2,null,"Awards per 100 FTE",15.9,13,14.850580005552885,14.802796977762284,17.357659326434135,19.366423954963214,4.3602817043562433E-2]
[]
["NASCC",null,null,null,null,null,null,"Avg. Annual"]
[null,"2007-08","2008-09","2009-10","2010-11","2011-12","2012-13","Change",null,"Note: For the FY 2012-13 Outcomes Funding Formula, the original Community College Certificates outcome was split into two outcomes: Certificates 1-2 Years and Certificates Less Than 1 Year. As a result, the certificates classifications from the 2007-08 Data Year (which was used only in the FY 2011-12 Formula) are no longer aligned with the four most recent Data Years."]
["Students Accumulating 12 hrs",2510,2837,3509,2375,2305,2338,{"$f":"((G166-B166)/B166)/5","v":-1.3705179282868527E-2}]
["Students Accumulating 24 hrs",1812,1973,2554,2048,1937,1824,{"$f":"((G167-B167)/B167)/5","v":1.3245033112582781E-3}]
["Students Accumulating 36 hrs",1468,1586,1903,1671,1717,1611,1.9482288828337874E-2]
["Dual Enrollment",322,790,926,1092,997,1119,0.49503105590062113]
["Associates",501,529,481,531,718,624,{"$f":"((G170-B170)/B170)/5","v":4.9101796407185629E-2}]
["Certificates 1-2 Years",47,40,41,38,113,99,0.22127659574468087]
["Certificates Less Than 1 Year",70,73,48,107,117,233,0.46571428571428575]
["Job Placements",312,268,258,263,335,363,3.2692307692307694E-2]
["Remedial & Developmental Success",2316,2248,2182,2491,3024,3152,7.219343696027633E-2]
["Transfers Out with 12 hrs",472,466,533,552,675,638,7.0338983050847459E-2]
["Workforce Training (Contact Hours)",71959,110590,67613,32948,39563,35965,-0.10004030072680277]
["Awards per 100 FTE",12.79,12.09,8.7489454894884169,8.9240203574313259,12.656203595823909,11.210229269603689,-2.4703217050763261E-2]

{"sheet":"FAQs","index":6,"n_rows":2,"n_cols":1,"rows_kept":2,"cut":false,"hidden":false,"merged":[[0,0,0,19],[1,0,1,19]]}
["Tennessee Higher Education Commission"]
["Outcomes Funding Dynamic Simulation"]

{"sheet":"Working","index":7,"n_rows":98,"n_cols":14,"rows_kept":98,"cut":false,"hidden":false,"merged":[[2,5,2,7],[2,9,2,11],[71,9,71,10]]}
[]
[]
[null,null,null,null,null,"Technical Corrections",null,null,null,"Total New Model"]
[null,"2014-15","2014-15","Percent ",null,"2015-16","2015-16","Percent ",null,"2015-16","2015-16","Percent ",null,"Change Due to "]
["Academic Formula Units","Formula Calculation","State Appr**","Funded",null,"Formula Calculation","Est State Appr*","Funded",null,"Formula Calculation","State Appr*","Funded",null,"Funding and Outcomes"]
["TBR Universities"]
["Austin Peay",56186000,34229500,{"$f":"C7/B7","v":0.60921759869006509},null,{"$f":"B7","v":56186000},{"$f":"F7*($C$39/$B$39)","v":34233385.280183226},{"$f":"G7/F7","v":0.60928674901547053},null,{"$f":"Outcomes!D211","v":56186000},{"$f":"J7*('Printable Summary'!$C$7/$J$39)","v":34233385.280183226},{"$f":"K7/J7","v":0.60928674901547053},null,{"$f":"ROUND((K7-G7), -2)","v":0}]
["East Tennessee",78623000,48031700,{"$f":"C8/B8","v":0.6109115653180367},null,{"$f":"B8","v":78623000},{"$f":"F8*($C$39/$B$39)","v":47903952.06784334},{"$f":"G8/F8","v":0.60928674901547053},null,{"$f":"Outcomes!H211","v":78623000},{"$f":"J8*('Printable Summary'!$C$7/$J$39)","v":47903952.06784334},{"$f":"K8/J8","v":0.60928674901547053},null,{"$f":"ROUND((K8-G8), -2)","v":0}]
["Middle Tennessee",135820500,82793000,0.60957661030551358,null,135820500,82753630.894655719,0.60928674901547053,null,{"$f":"Outcomes!G211","v":135820500},{"$f":"J9*('Printable Summary'!$C$7/$J$39)","v":82753630.894655719},0.60928674901547053,null,0]
["Tennessee State",52609300,32094700,0.61005753735556256,null,52609300,32054149.364979595,0.60928674901547053,null,{"$f":"Outcomes!I211","v":52609300},{"$f":"J10*('Printable Summary'!$C$7/$J$39)","v":32054149.364979595},0.60928674901547053,null,0]
["Tennessee Tech",62960900,38383300,0.60963709222708062,null,62960900,38361242.076088138,0.60928674901547053,null,{"$f":"Outcomes!E211","v":62960900},{"$f":"J11*('Printable Summary'!$C$7/$J$39)","v":38361242.076088138},0.60928674901547053,null,0]
["University of Memphis",146528000,89314500,0.60953879122079058,null,146528000,89277568.759738863,0.60928674901547053,null,{"$f":"Outcomes!J211","v":146528000},{"$f":"J12*('Printable Summary'!$C$7/$J$39)","v":89277568.759738863},0.60928674901547053,null,0]
["Subtotal ",{"$f":"SUM(B7:B12)","v":532727700},{"$f":"SUM(C7:C12)","v":324846700},0.60978000580784519,null,{"$f":"SUM(F7:F12)","v":532727700},{"$f":"SUM(G7:G12)","v":324583928.44348884},0.60928674901547042,null,{"$f":"SUM(J7:J12)","v":532727700},{"$f":"SUM(K7:K12)","v":324583928.44348884},0.60928674901547042,null,{"$f":"SUM(N7:N12)","v":0}]
["Two-Year Colleges*"]
["Chattanooga",42730000,{"$f":"B15*($C$28/$B$28)","v":26017879.951773673},{"$f":"C15/B15","v":0.6088902399198145},null,{"$f":"B15","v":42730000},{"$f":"F15*($C$39/$B$39)","v":26034822.785431057},0.60928674901547053,null,{"$f":"Outcomes!$C$68","v":42730000},{"$f":"J15*('Printable Summary'!$C$7/$J$39)","v":26034822.785431057},0.60928674901547053,null,{"$f":"ROUND((K15-G15), -2)","v":0}]
["Cleveland",14530000,{"$f":"B16*($C$28/$B$28)","v":8847175.1860349048},0.6088902399198145,null,{"$f":"B16","v":14530000},{"$f":"F16*($C$39/$B$39)","v":8852936.4631947875},0.60928674901547053,null,{"$f":"Outcomes!$D$68","v":14530000},{"$f":"J16*('Printable Summary'!$C$7/$J$39)","v":8852936.4631947875},0.60928674901547053,null,{"$f":"ROUND((K16-G16), -2)","v":0}]
["Columbia",20290700,12354809.19114098,0.6088902399198145,null,20290700,12362854.638248207,0.60928674901547053,null,{"$f":"Outcomes!$E$68","v":20290700},{"$f":"J17*('Printable Summary'!$C$7/$J$39)","v":12362854.638248207},0.60928674901547053,null,0]
["Dyersburg",12024000,7321296.2447958495,0.6088902399198145,null,12024000,7326063.8701620176,0.60928674901547053,null,{"$f":"Outcomes!$F$68","v":12024000},{"$f":"J18*('Printable Summary'!$C$7/$J$39)","v":7326063.8701620176},0.60928674901547053,null,0]
["Jackson",18229000,11099460.183498299,0.6088902399198145,null,18229000,11106688.147803012,0.60928674901547053,null,{"$f":"Outcomes!$G$68","v":18229000},{"$f":"J19*('Printable Summary'!$C$7/$J$39)","v":11106688.147803012},{"$f":"K19/J19","v":0.60928674901547053},null,0]
["Motlow",17508000,10660450.320516113,0.6088902399198145,null,17508000,10667392.401762858,0.60928674901547053,null,{"$f":"Outcomes!$H$68","v":17508000},{"$f":"J20*('Printable Summary'!$C$7/$J$39)","v":10667392.401762858},0.60928674901547053,null,0]
["Nashville",26060000,15867679.652310366,0.6088902399198145,null,26060000,15878012.679343162,0.60928674901547053,null,{"$f":"Outcomes!$I$68","v":26060000},{"$f":"J21*('Printable Summary'!$C$7/$J$39)","v":15878012.679343162},0.60928674901547053,null,0]
["Northeast ",21726000,13228749.352497891,0.6088902399198145,null,21726000,13237363.909110112,0.60928674901547053,null,{"$f":"Outcomes!$J$68","v":21726000},{"$f":"J22*('Printable Summary'!$C$7/$J$39)","v":13237363.909110112},0.60928674901547053,null,0]
["Pellissippi",38498000,23441056.456433021,0.6088902399198145,null,38498000,23456321.263597585,0.60928674901547053,null,{"$f":"Outcomes!$K$68","v":38498000},{"$f":"J23*('Printable Summary'!$C$7/$J$39)","v":23456321.263597585},0.60928674901547053,null,0]
["Roane",28591000,17408780.849547416,0.6088902399198145,null,28591000,17420117.441101316,0.60928674901547053,null,{"$f":"Outcomes!$L$68","v":28591000},{"$f":"J24*('Printable Summary'!$C$7/$J$39)","v":17420117.441101316},0.60928674901547053,null,0]
["Southwest",40541000,24685019.216589201,0.6088902399198145,null,40541000,24701094.091836192,0.60928674901547053,null,{"$f":"Outcomes!$M$68","v":40541000},{"$f":"J25*('Printable Summary'!$C$7/$J$39)","v":24701094.091836192},0.60928674901547053,null,0]
["Volunteer",26644000,16223271.552423537,0.6088902399198145,null,26644000,16233836.140768196,0.60928674901547053,null,{"$f":"Outcomes!$N$68","v":26644000},{"$f":"J26*('Printable Summary'!$C$7/$J$39)","v":16233836.140768196},0.60928674901547053,null,0]
["Walters",33438000,20360071.842438757,0.6088902399198145,null,33438000,20373330.313579302,0.60928674901547053,null,{"$f":"Outcomes!$O$68","v":33438000},{"$f":"J27*('Printable Summary'!$C$7/$J$39)","v":20373330.313579302},0.60928674901547053,null,0]
["Subtotal",{"$f":"SUM(B15:B27)","v":340809700},207515700,0.6088902399198145,null,{"$f":"SUM(F15:F27)","v":340809700},{"$f":"SUM(G15:G27)","v":207650834.1459378},0.60928674901547053,null,{"$f":"SUM(J15:J27)","v":340809700},{"$f":"SUM(K15:K27)","v":207650834.1459378},0.60928674901547053,null,{"$f":"SUM(N15:N27)","v":0}]
["UT Universities"]
["UT Chattanooga",61485000,{"$f":"37505300","v":37505300},{"$f":"C30/B30","v":0.60999105472879567},null,{"$f":"B30","v":61485000},{"$f":"F30*($C$39/$B$39)","v":37461995.763216205},0.60928674901547053,null,{"$f":"Outcomes!F211","v":61485000},{"$f":"J30*('Printable Summary'!$C$7/$J$39)","v":37461995.763216205},0.60928674901547053,null,{"$f":"ROUND((K30-G30), -2)","v":0}]
["UT Knoxville",289041000,{"$f":"179010600-3000000","v":176010600},{"$f":"C31/B31","v":0.60894682761269159},null,{"$f":"B31","v":289041000},{"$f":"F31*($C$39/$B$39)","v":176108851.2221806},0.60928674901547053,null,{"$f":"Outcomes!K211","v":289041000},{"$f":"J31*('Printable Summary'!$C$7/$J$39)","v":176108851.2221806},0.60928674901547053,null,{"$f":"ROUND((K31-G31), -2)","v":0}]
["UT Martin",42686000,{"$f":"26248400-200000","v":26048400},{"$f":"C32/B32","v":0.61023286323384718},null,42686000,26008014.168474376,0.60928674901547053,null,{"$f":"Outcomes!C211","v":42686000},{"$f":"J32*('Printable Summary'!$C$7/$J$39)","v":26008014.168474376},0.60928674901547053,null,0]
["Subtotal ",{"$f":"SUM(B30:B32)","v":393212000},{"$f":"SUM(C30:C32)","v":239564300},{"$f":"C33/B33","v":0.60924971770953074},null,{"$f":"SUM(F30:F32)","v":393212000},{"$f":"SUM(G30:G32)","v":239578861.15387118},0.60928674901547053,null,{"$f":"SUM(J30:J32)","v":393212000},{"$f":"SUM(K30:K32)","v":239578861.15387118},0.60928674901547053,null,{"$f":"SUM(N30:N32)","v":0}]
[]
["Total Colleges and Universities",{"$f":"B33+B28+B13","v":1266749400},{"$f":"C33+C28+C13","v":771926700},{"$f":"C35/B35","v":0.60937601391403862},null,{"$f":"F33+F28+F13","v":1266749400},{"$f":"G33+G28+G13","v":771813623.74329782},0.60928674901547053,null,{"$f":"J33+J28+J13","v":1266749400},{"$f":"K33+K28+K13","v":771813623.74329782},0.60928674901547053,null,{"$f":"ROUND((K35-G35), -2)","v":0}]
[]
["TN Colleges of Applied Technology",90955000,55304600,{"$f":"C37/B37","v":0.60804353801330324},null,{"$f":"B37","v":90955000},{"$f":"F37*($C$39/$B$39)","v":55417676.256702125},0.60928674901547053,null,{"$f":"B37*((J28+J13+J33)/(B28+B13+B33))","v":90955000},{"$f":"J37*('Printable Summary'!$C$7/$J$39)","v":55417676.256702125},{"$f":"K37/J37","v":0.60928674901547053},null,{"$f":"ROUND((K37-G37), -2)","v":0}]
[]
["Total Academic Formula Units",{"$f":"B37+B35","v":1357704400},{"$f":"C37+C35","v":827231300},{"$f":"C39/B39","v":0.60928674901547053},null,{"$f":"F37+F35","v":1357704400},{"$f":"G37+G35","v":827231300},0.60928674901547053,null,{"$f":"J37+J35","v":1357704400},{"$f":"K37+K35","v":827231300},0.60928674901547053,null,{"$f":"K39-G39","v":0}]
[]
["* Two-Year College Appropriations estimated using Governor's recommended overall recurring appropriation for two-year colleges and the THEC recommended distribution rates."]
["**Includes insurance increase of $4.8 million for formula units - Legislative Action"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Static 2014-15","Rec Changes Due to","Percent ",null,"Appr Change Due to"]
["Academic Formula Units","Formula Calculation","Outcome Changes","Funded",null,"Outcomes Changes"]
["TBR Universities"]
["Austin Peay",{"$f":"B7","v":56186000},{"$f":"J7-B66","v":0},{"$f":"K7/J7","v":0.60928674901547053},null,{"$f":"ROUND(B66*L$39,-2)","v":34233400}]
["East Tennessee",{"$f":"B8","v":78623000},0,0.60928674901547053,null,{"$f":"ROUND(B67*L$39,-2)","v":47904000}]
["Middle Tennessee",135820500,0,0.60928674901547053,null,82753600]
["Tennessee State",52609300,0,0.60928674901547053,null,32054100]
["Tennessee Tech",62960900,0,0.60928674901547053,null,38361200]
["University of Memphis",146528000,0,0.60928674901547053,null,89277600]
["Subtotal ",{"$f":"SUM(B66:B71)","v":532727700},0,0.60928674901547042,null,324583900,null,null,null,"Community College Distribution"]
["Two-Year Colleges",null,null,null,null,null,null,null,null,"2014-15 THEC Rec","2014-15 Gov's Rec"]
["Chattanooga",{"$f":"B15","v":42730000},{"$f":"J15-B74","v":0},{"$f":"K15/J15","v":0.60928674901547053},null,{"$f":"ROUND(B74*L$39,-2)","v":26034800},null,null,null,26816300,{"$f":"ROUND($K$87*(J74/$J$87),-2)","v":26017800}]
["Cleveland",{"$f":"B16","v":14530000},0,0.60928674901547053,null,8852900,null,null,null,9118700,{"$f":"ROUND($K$87*(J75/$J$87),-2)","v":8847200}]
["Columbia",20290700,0,0.60928674901547053,null,12362900,null,null,null,12734000,12354800]
["Dyersburg",12024000,0,0.60928674901547053,null,7326100,null,null,null,7545900,7321200]
["Jackson",18229000,0,0.60928674901547053,null,11106700,null,null,null,11440100,11099500]
["Motlow",17508000,0,0.60928674901547053,null,10667400,null,null,null,10987600,10660400]
["Nashville",26060000,0,0.60928674901547053,null,15878000,null,null,null,16354600,15867600]
["Northeast ",21726000,0,0.60928674901547053,null,13237400,null,null,null,13634800,13228800]
["Pellissippi",38498000,0,0.60928674901547053,null,23456300,null,null,null,24160400,23441000]
["Roane",28591000,0,0.60928674901547053,null,17420100,null,null,null,17943000,17408700]
["Southwest",40541000,0,0.60928674901547053,null,24701100,null,null,null,25442600,24685000]
["Volunteer",26644000,0,0.60928674901547053,null,16233800,null,null,null,16721200,16223300]
["Walters",33438000,0,0.60928674901547053,null,20373300,null,null,null,20984900,20360100]
["Subtotal",{"$f":"SUM(B74:B86)","v":340809700},0,0.60928674901547053,null,207650800,null,null,null,{"$f":"SUM(J74:J86)","v":213884100},{"$f":"C28","v":207515700}]
["UT Universities"]
["UT Chattanooga",{"$f":"B30","v":61485000},{"$f":"J30-B89","v":0},{"$f":"K30/J30","v":0.60928674901547053},null,{"$f":"ROUND(B89*L$39,-2)","v":37462000}]
["UT Knoxville",{"$f":"B31","v":289041000},{"$f":"J31-B90","v":0},{"$f":"K31/J31","v":0.60928674901547053},null,{"$f":"ROUND(B90*L$39,-2)","v":176108900}]
["UT Martin",42686000,{"$f":"J32-B91","v":0},{"$f":"K32/J32","v":0.60928674901547053},null,{"$f":"ROUND(B91*L$39,-2)","v":26008000}]
["Subtotal ",{"$f":"SUM(B89:B91)","v":393212000},{"$f":"J33-B92","v":0},{"$f":"K33/J33","v":0.60928674901547053},null,{"$f":"ROUND(B92*L$39,-2)","v":239578900}]
[]
["Total Colleges and Universities",{"$f":"B92+B87+B72","v":1266749400},{"$f":"J35-B94","v":0},{"$f":"K35/J35","v":0.60928674901547053},null,{"$f":"ROUND(B94*L$39,-2)","v":771813600}]
[]
["TN Colleges of Applied Technology",{"$f":"B37","v":90955000},{"$f":"J37-B96","v":0},{"$f":"K37/J37","v":0.60928674901547053},null,{"$f":"ROUND(B96*L$39,-2)","v":55417700}]
[]
["Total Academic Formula Units",{"$f":"B96+B94","v":1357704400},{"$f":"J39-B98","v":0},{"$f":"K39/J39","v":0.60928674901547053},null,{"$f":"ROUND(B98*L$39,-2)","v":827231300}]