{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Dashboard","Applied Projections"],"not_rendered":{"charts":1,"images":1,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Dashboard","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Applied Projections","index":1,"n_rows":31,"n_cols":27,"rows_kept":31,"cut":false,"hidden":true,"merged":[[0,0,0,4],[0,6,0,10],[0,12,0,16],[0,18,0,22]]}
["Two Most Competitive",null,null,null,null,null,"Direct Competitors",null,null,null,null,null,"All Other Schools",null,null,null,null,null,"Binomial Enroll (1=UM Need Inverse for comp)"]
["Characteristic","Parameter Estimate","Dialog Input","Equation Estimate","Results",null,"Characteristic","Parameter Estimate","Dialog Input","Equation Estimate","Results",null,"Characteristic","Parameter Estimate","Dialog Input","Equation Estimate","Results",null,"Characteristic","Parameter Estimate","Dialog Input","Equation Estimate","Results"]
[]
["Female",0.13,1,{"$f":"B4*C4","v":0.13},{"$f":"(B18^D17)/(1+B18^D17)","v":0.55675431504573247},null,"Female",0.15,1,{"$f":"H4*I4","v":0.15},{"$f":"(H18^J17)/(1+H18^J17)","v":0.49000133984387201},null,"Female",0.24,1,{"$f":"N4*O4","v":0.24},{"$f":"(N18^P17)/(1+N18^P17)","v":4.9266099342731733E-2},null,"Female",-0.22,1,{"$f":"T4*U4","v":-0.22},{"$f":"(T18^V17)/(1+T18^V17)","v":0.52896750558949723},null,null,null,1]
["URM",0.82,1,{"$f":"B5*C5","v":0.82},null,null,"URM",0.76,1,{"$f":"H5*I5","v":0.76},null,null,"URM",0.45,1,{"$f":"N5*O5","v":0.45},null,null,"URM",-0.8,1,{"$f":"T5*U5","v":-0.8},null,null,null,null,1]
["Undergraduate GPA",1.48,3.6,5.3280000000000003,null,null,"Undergraduate GPA",0.55000000000000004,3.6,1.9800000000000002,null,null,"Undergraduate GPA",0.2,3.6,0.72000000000000008,null,null,"Undergraduate GPA",-1.69,3.6,-6.0839999999999996,null,null,null,null,3.6]
["MCAT Average",0.89,13,11.57,null,null,"MCAT Average",0.66,13,8.58,null,null,"MCAT Average",0.42,13,5.46,null,null,"MCAT Average",-0.5,13,-6.5,null,null,null,null,13]
["In-state Resident",-1.58,1,-1.58,null,null,"In-state Resident",-1.82,1,-1.82,null,null,"In-state Resident",-2.04,1,-2.04,null,null,"In-state Resident",1.83,1,1.83,null,null,null,null,1]
["Less than 10K",-0.75,0,0,null,null,"Less than 10K",-1.68,0,0,null,null,"Less than 10K",-1.33,0,0,null,null,"Less than 10K",1.05,0,0,null,null,null,null,0]
["10K-20K",-0.75,0,0,null,null,"10K-20K",-0.95,0,0,null,null,"10K-20K",-1.79,0,0,null,null,"10K-20K",0.59,0,0,null,null,null,null,0]
["20K-<30K",0.04,0,0,null,null,"20K-<30K",-0.31,0,0,null,null,"20K-<30K",-0.05,0,0,null,null,"20K-<30K",0.8,0,0,null,null,null,null,0]
["30K-46K",1.01,0,0,null,null,"30K-46K",0.47,0,0,null,null,"30K-46K",-0.23,0,0,null,null,"30K-46K",-0.43,0,0,null,null,null,null,0]
["Full Ride",0.23,1,0.23,null,null,"Full Ride",-0.5,1,-0.5,null,null,"Full Ride",-1.55,1,-1.55,null,null,"Full Ride",0.43,1,0.43,null,null,null,null,1]
["Other Named Scholarship",-12.16,0,0,null,null,"Other Named Scholarship",-0.6,0,0,null,null,"Other Named Scholarship",-12.67,0,0,null,null,"Other Named Scholarship",1.84,0,0,null,null,null,null,0]
["Admissions Committee Rating",0.33,48,15.84,null,null,"Admissions Committee Rating",0.18,48,8.64,null,null,"Admissions Committee Rating",0.04,48,1.92,null,null,"Admissions Committee Rating",-0.21,48,-10.08,null,null,null,null,48]
["Regression Constant",-32.11,1,-32.11,null,null,"Regression Constant",-17.829999999999998,1,-17.829999999999998,null,null,"Regression Constant",-8.16,1,-8.16,null,null,"Regression Constant",21.54,1,21.54]
[null,null,null,{"$f":"SUM(D4:D16)","v":0.22800000000000153},null,null,null,null,null,{"$f":"SUM(J4:J16)","v":-3.9999999999999147E-2},null,null,null,null,null,{"$f":"SUM(P4:P16)","v":-2.96},null,null,null,null,null,{"$f":"SUM(V4:V16)","v":0.11599999999999966}]
["e",2.71828,null,null,null,null,"e",2.71828,null,null,null,null,"e",2.71828,null,null,null,null,"e",2.71828]
[]
[]
["Two Most Competitive",{"$f":"E4","v":0.55675431504573247},{"$f":"1-(B21)","v":0.44324568495426753}]
["Direct Competitors",{"$f":"K4","v":0.49000133984387201},{"$f":"1-(B22)","v":0.50999866015612794}]
["All Other Schools",{"$f":"Q4","v":4.9266099342731733E-2},{"$f":"1-(B23)","v":0.95073390065726826}]
[]
[null,"Enroll Elsewhere","Enroll Here"]
["Other",{"$f":"B23","v":4.9266099342731733E-2},{"$f":"C23","v":0.95073390065726826}]
["Direct Competitors",{"$f":"B22","v":0.49000133984387201},{"$f":"C22","v":0.50999866015612794}]
["Two Most Competitive",{"$f":"B21","v":0.55675431504573247},{"$f":"C21","v":0.44324568495426753}]
["Overall, Larger Set",{"$f":"(1-W4)","v":0.47103249441050277},{"$f":"(1-B29)","v":0.52896750558949723}]
[]
["Enroll at UM",{"$f":"W4","v":0.52896750558949723}]