{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Notes","Game","Paramters"],"not_rendered":{"charts":1,"images":10,"macros":1,"external_links":0,"defined_names":37,"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":"Notes","index":0,"n_rows":22,"n_cols":2,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["How to protect a student from dropping out game."]
[]
[null,"Yellow cells on the Game tab may be used to change inputs."]
[null,"The Roll Dice button is used to solicit an outcome. Outcomes depend on probability. Probabilities are shown in violet cells at the top."]
[null,"   A roll of the dice may result in graduation, or it may result in dropping out."]
[null,"   The more protection a student has from dropping out, the less likely will that outcome be."]
[null,"All students have a certain likelihood of dropping out each semester. (See the parameter tab for the probability.)"]
[null,"The longer in school, the more likely a drop out."]
[null,"The more developmental coursework is needed, the longer in school."]
[null,"The more a student studies, the better the grade and the faster accumulation of credits, speeding time to graduation."]
[null,"The more credits taken, the fewer hours it may be possible to study for each course."]
[null,"A week has only so many hours."]
[null,"The maximum credit load is determined by the number of hours left in the week to attend class."]
[]
[]
[null,"This workbook contains a few Visual Basic commands. If you get an error, save your parameters and restart. It's cranky."]
[]
[]
[null,"The parameters are partially based on actual LaGuardia data from 2012, and partially on simulation data that matched actual outcomes."]
[null,"12 semesters of probabilities can be found beginning in cell F100 on the Game tab. It's hidden only because of the complexity."]
[]
[null,"Acknowlegement: Sam Michalowski did the interviews and reporting on students who changed registration intensity that set up the theory for this work."]

{"sheet":"Game","index":1,"n_rows":379,"n_cols":27,"rows_kept":379,"cut":false,"hidden":false,"merged":[[306,5,311,5],[200,7,200,11],[201,7,201,10],[201,11,201,12],[166,7,166,10],[166,11,166,12],[184,7,184,11],[185,7,185,10],[185,11,185,12],[323,9,323,10],[107,8,107,11],[107,12,107,13],[165,7,165,11],[106,7,106,12]]}
["College Success Game"]
[null,"Results:"]
["Probability of dropping out before graduation",{"$f":"Game!N107","v":0.19754595250436158}]
["Expected lifetime earnings",{"$f":"Game!M108","v":2106568.6832118863}]
["Probable graduation semester",{"$f":"MATCH(gradcred,Game!H103:S103,0)","v":4}]
["Percentage of courses passed",{"$f":"(minpass+(MIN(Game!I119,maxstudy)/maxstudy)*(maxpass-minpass))","v":0.9},null,"FOR ANY GIVEN STUDENT, THIS MEANS…"]
[]
["Input","Input",null,"Roll the dice to see what the probabilities actually mean!"]
["What was your HS GPA?",4]
["Into which developmental course levels did you place?"]
[null,null,null,{"$f":"Game!S303&\" in semester \"&TEXT(IFERROR(MATCH(\"Continue\",Game!H303:S303,1),0)+1,0)","v":"Graduation in semester 4"},null,null,null,false]
[null,null,null,"(Actual results may vary.)",null,null,null,false]
[null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,false]
[null,null,null,"Notes:",null,null,null,false]
["How many hours do you sleep each night?",6,null,{"$f":"\"Fewer than \"&minsleep&\" lowers drop-out protection\"","v":"Fewer than 6 lowers drop-out protection"},null,null,null,false,null,null,6]
["How long do you need each day to eat, dress, get ready?",4,null,null,null,null,null,false,null,null,4]
["How many hours do you spend commuting each weekday?",2,null,null,null,null,null,false,null,null,2]
["How much time do you spend with your family each day?",0,null,null,null,null,null,null,null,null,0]
["How many hours will you work each week?",0,null,null,null,null,null,null,null,null,0]
["How many nights each week will you go out?",0,null,{"$f":"\"Each night uses up \"&party&\" hours\"","v":"Each night uses up 6 hours"},null,null,null,null,null,null,0]
["How many hours per week will you engage in support activities?",10,null,{"$f":"\"Maximum of \"&maxsup&\" (seeing advisors, math lab, etc.)\"","v":"Maximum of 10 (seeing advisors, math lab, etc.)"},null,null,null,null,null,null,10]
["How many hours per week will you study?",54,null,{"$f":"\"Probability of passing with 0 hours \"& minpass*100&\"%\"","v":"Probability of passing with 0 hours 63%"},null,null,null,null,null,null,54]
[null,null,null,{"$f":"\"Probability of passing with \"&B25*3&\" hours: \"&maxpass*100&\"%\"","v":"Probability of passing with 54 hours: 90%"}]
["Planned credit load",18,{"$f":"ROUNDDOWN((Corcred*(Game!$G$113-Game!H116*7-Game!H117*7-Game!H120-Game!H121-Game!$H$126-B23))/(Corhrs),0)","v":18},"= current maximum credit load",null,null,null,null,null,null,18]
["Available hours per week:",{"$f":"H114","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"A Model of the Path to Graduation--Life Happens, Some Students Have Better Protection Against It"]
[null,null,null,null,null,null,"Initial",{"$f":"\"Term \"& TEXT(H154,Paramters!$C$1)","v":"Term 1"},{"$f":"\"Term \"& TEXT(I154,Paramters!$C$1)","v":"Term 2"},{"$f":"\"Term \"& TEXT(J154,Paramters!$C$1)","v":"Term 3"},{"$f":"\"Term \"& TEXT(K154,Paramters!$C$1)","v":"Term 4"},{"$f":"\"Term \"& TEXT(L154,Paramters!$C$1)","v":"Term 5"},{"$f":"\"Term \"& TEXT(M154,Paramters!$C$1)","v":"Term 6"},{"$f":"\"Term \"& TEXT(N154,Paramters!$C$1)","v":"Term 7"},{"$f":"\"Term \"& TEXT(O154,Paramters!$C$1)","v":"Term 8"},{"$f":"\"Term \"& TEXT(P154,Paramters!$C$1)","v":"Term 9"},{"$f":"\"Term \"& TEXT(Q154,Paramters!$C$1)","v":"Term 10"},{"$f":"\"Term \"& TEXT(R154,Paramters!$C$1)","v":"Term 11"},{"$f":"\"Term \"& TEXT(S154,Paramters!$C$1)","v":"Term 12"}]
[null,null,null,null,null,"Graduation semester, if any",null,{"$f":"IF(H103>=gradcred,\"Graduation\",\"\")","v":""},"","","Graduation","Graduation","Graduation","Graduation","Graduation","Graduation","Graduation","Graduation","Graduation"]
[null,null,null,null,null,"Credits toward graduation, term end",{"$f":"-G111*3","v":0},{"$f":"ROUNDDOWN(IF(G103+(H118*Corcred)*(minpass+(MIN(H119,maxstudy)/maxstudy)*(maxpass-minpass))-IF(AND(H122=1,G103>0),majloss*G103,0)>=gradcred,gradcred,G103+(H118*Corcred)*(minpass+(MIN(H119,maxstudy)/maxstudy)*(maxpass-minpass))-IF(AND(H122=1,G103>0),majloss*G103,0)),0)","v":16},32,48,60,60,60,60,60,60,60,60,60]
[null,null,null,null,null,"Protection",null,{"$f":"(1-((minprot+(maxprot-H134))/maxprot))^profac","v":0.41770643360935739},0.71980676948463718,0.84359843533857093,0.92888310360781357,0.9783178815603143,0.9783178815603143,0.9783178815603143,0.9783178815603143,0.9783178815603143,0.9783178815603143,0.9783178815603143,0.9783178815603143,null,{"$f":"Game!H11","v":false}]
[null,null,null,null,null,{"$f":"F137","v":"Cumulative probability of dropping out"},null,{"$f":"H137","v":0.11645871327812851},0.16372962491806592,0.1875817620125389,0.19754595250436158,0.19754595250436158,0.19754595250436158,0.19754595250436158,0.19754595250436158,0.19754595250436158,0.19754595250436158,0.19754595250436158,0.19754595250436158,null,{"$f":"Game!H12","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Game!H13","v":false}]
[null,null,null,null,null,null,null,"Cumulative probability of dropping out:",null,null,null,null,null,{"$f":"S137","v":0.19754595250436158},null,null,null,null,null,null,{"$f":"Game!H14","v":false}]
[null,null,null,null,null,null,null,null,"Expected lifetime earnings:",null,null,null,{"$f":"X161","v":2106568.6832118863},null,null,null,null,null,null,null,{"$f":"Game!H15","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Game!H16","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Game!H17","v":false}]
[null,null,null,null,null,{"$f":"\"Developmental Courses Needed (0-\"&maxdev&\")\"","v":"Developmental Courses Needed (0-7)"},{"$f":"U114","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Game!H18","v":false}]
[null,null,null,null,null,"High School Performance (0.00 - 4.00)",{"$f":"Game!B9","v":4}]
[null,null,null,null,null,"Time Distribution--Total Hours per week",{"$f":"7*24","v":168}]
[null,null,null,null,null,"  Fun, hours per week (computed)",null,{"$f":"IF(($G$113-H116*7-H117*7-H118*(Corhrs+Corcred*(H119))-H120-H121-$H$126)<0,\"Error\",($G$113-H116*7-H117*7-H118*(Corhrs+Corcred*(H119))-H120-H121)-$H$126)","v":0},0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"IF(U111,3,IF(U110,2,IF(OR(U109,U104),1,0)))+IF(U105,2,IF(U106,1,0))+IF(U107,2,IF(U108,1,0))","v":0},2]
[null,null,null,null,null,"Input variables: "]
[null,null,null,null,null,"  Sleep, eat, commute: hours per day",null,{"$f":"H123+H124+H125","v":11.428571428571429},{"$f":"H116","v":11.428571428571429},11.428571428571429,11.428571428571429,11.428571428571429,11.428571428571429,11.428571428571429,11.428571428571429,11.428571428571429,11.428571428571429,11.428571428571429,11.428571428571429]
[null,null,null,null,null,"  Family: hours per day",null,{"$f":"Game!B19","v":0},{"$f":"H117","v":0},0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,{"$f":"IF(AA118<Y118,\"Error Make Last Sem Higher\",\"\")","v":""}]
[null,null,null,null,null,{"$f":"\"  Courses (\"&Corcred&\" credits/course)\"","v":"  Courses (3 credits/course)"},null,{"$f":"Game!B25/Corcred","v":6},{"$f":"H118","v":6},6,6,6,6,6,6,6,6,6,6,null,null,null,null,null,1,null,8]
[null,null,null,null,null,{"$f":"\"  Hours of study/course credit (max. \"&maxstudy&\")\"","v":"  Hours of study/course credit (max. 3)"},null,{"$f":"H127","v":3},{"$f":"H119","v":3},3,3,3,3,3,3,3,3,3,3]
[null,null,null,null,null,{"$f":"\"  Support activities: hours per week (max. \"&maxsup&\")\"","v":"  Support activities: hours per week (max. 10)"},null,{"$f":"Game!B22","v":10},{"$f":"H120","v":10},10,10,10,10,10,10,10,10,10,10,null,null,null,"  Courses (3 credits/course)"]
[null,null,null,null,null,"  Work: hours per week",null,{"$f":"Game!B20","v":0},{"$f":"H121","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,"  Change major (1=yes)",null,0,0,0,0,1,0,0,0,0,0,0,0,null,null,null,null,{"$f":"MATCH(W120,F116:F122,0)","v":3}]
[null,null,null,null,null,"Sleep",null,{"$f":"Game!B16","v":6},null,null,null,null,null,{"$f":"X135","v":""}]
[null,null,null,null,null,"Eat, dress, get ready",null,{"$f":"Game!B17","v":4}]
[null,null,null,null,null,"Commute",null,{"$f":"Game!B18*5/7","v":1.4285714285714286}]
[null,null,null,null,null,"Hours partying",null,{"$f":"party*Game!B21","v":0}]
[null,null,null,null,null,"Study hours converted",null,{"$f":"Game!B23/(Game!B25)","v":3}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Value",null,"Error List"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VALUE(W128)","v":5},null,{"$f":"IF(W130<0,-1,IF(AND(OR(X122=1,X122=2),W130>=24),-1,IF(AND(X122=4,W130>3),-1,IF(AND(X122=5,W130>10),-1,IF(AND(X122=6,W130>50),-1,IF(AND(X122=7,W130>1),-1,0))))))","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AND(X122=4,W130>3)","v":false}]
[]
[null,null,null,null,null,"Protection Level",null,{"$f":"((maxdev-G111)*devfac+G112*hsgrdfac)+1","v":67},{"$f":"0*H114+H134+IF(H103>=gradcred,0,-IF($H$123<minsleep,minsleep-$H$123,0)*sleepfac+MIN(H120,maxsup)*Supfac)+MIN(H119,maxstudy)*(H103-G103)*Grdfac+(H103-G103)*credfac","v":583},1099,1615,1987,1987,1987,1987,1987,1987,1987,1987]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(W130<0,\"No negatives, please\",IF(AND(OR(X122=1,X122=2),W130>=24),\"Only 24 hrs in a day\",IF(AND(X122=4,W130>3),\"Maximum of 3\",IF(AND(X122=5,W130>10),\"Maximum of 10\",IF(AND(X122=6,W130>50),\"Maximum of 50\",IF(AND(X122=7,W130>1),\"0 or 1 please\",\"\"))))))","v":""}]
[null,null,null,null,null,"Probability of dropping out",null,{"$f":"(1-H104)*badfac","v":0.11645871327812851},5.6038646103072569E-2,3.1280312932285816E-2,1.4223379278437288E-2,4.3364236879371411E-3,4.3364236879371411E-3,4.3364236879371411E-3,4.3364236879371411E-3,4.3364236879371411E-3,4.3364236879371411E-3,4.3364236879371411E-3,4.3364236879371411E-3]
[null,null,null,null,null,"Cumulative probability of dropping out",null,{"$f":"H136","v":0.11645871327812851},{"$f":"H137+(I136*(1-(H$139+H$137+H$148)))","v":0.16372962491806592},0.1875817620125389,0.19754595250436158,0.19754595250436158,0.19754595250436158,0.19754595250436158,0.19754595250436158,0.19754595250436158,0.19754595250436158,0.19754595250436158,0.19754595250436158,null,null,"The probability of a life event times the probability of impact, considering protection."]
[null,null,null,null,null,"Probability of transfer",null,0.04,0.04,0.05,0.08,7.0000000000000007E-2,0.06,0.06,0.06,5.536332179930796E-2,0.06,0.06,6.2015503875968991E-2,null,null,"The previous semesters probability of leaving plus 1 minus that probability (the probability of not having left) times this semesters probability of leaving, up to earning graduation level credits."]
[null,null,null,null,null,"Cumulative probability of transfer",null,{"$f":"H138","v":0.04},{"$f":"H139+(I138*(1-(H$139+H$137+H$148)))","v":7.3741651468874861E-2},0.11186808764952783,0.16791209967656248,0.16791209967656248,0.16791209967656248,0.16791209967656248,0.16791209967656248,0.16791209967656248,0.16791209967656248,0.16791209967656248,0.16791209967656248]
[null,null,null,null,null,"Cumulative probability of leaving",null,{"$f":"H137+H139+H148","v":0.15645871327812852},0.23747127638694077,0.29944984966206672,1,1,1,1,1,1,1,1,1]
[null,null,null,null,null,"Probability of transfer","Actual",4.3245653143111906E-2,5.1733626857457346E-2,4.5637583892617448E-2,0.1135091926458833,7.9958463136033234E-2,6.5217391304347824E-2,7.4803149606299218E-2,6.5217391304347824E-2,5.536332179930796E-2,6.6964285714285712E-2,7.5144508670520235E-2,6.2015503875968991E-2]
[null,null,null,null,null,"Cum Probability of transfer","Actual",{"$f":"H141","v":4.3245653143111906E-2},{"$f":"H142+(I141*(1-(H$146+H$144+H$142)))","v":8.5153811859117245E-2},0.1154703522068658,0.17877842175657602,0.21310744538564425,0.23316986179224256,0.25011145786892558,0.260811413285778,0.26794471689701294,0.27463218903254571,0.28042799821667413,0.28399465002229163]
[null,null,null,null,null,"Probability of dropping out","Actual",0.14355773517610343,0.12493120528343424,7.5167785234899323E-2,4.6362909672262191E-2,6.9574247144340601E-2,7.6811594202898556E-2,6.2992125984251968E-2,7.6086956521739135E-2,8.3044982698961933E-2,6.25E-2,0.10404624277456648,9.3023255813953487E-2]
[null,null,null,null,null,"Cum Probability of dropping out","Actual",{"$f":"H143","v":0.14355773517610343},{"$f":"H144+(I143*(1-(H$146+H$144+H$142)))","v":0.24476148016049934},0.294694605439144,0.3205528310298707,0.35042353990191705,0.37405260811413282,0.38831921533660274,0.40080249665626388,0.41150245207311631,0.41774409273294688,0.42576905929558617,0.43111903700401238]
[null,null,null,null,null,"Probability of graduating","Actual",3.120820329915292E-3,3.3021463951568518E-3,3.9597315436241613E-2,7.034372501998401E-2,0.13395638629283488,0.12173913043478261,0.13779527559055119,7.3369565217391311E-2,8.6505190311418678E-2,9.8214285714285712E-2,7.5144508670520235E-2,6.9767441860465115E-2]
[null,null,null,null,null,"Cum Probability of graduating","Actual",{"$f":"H145","v":3.120820329915292E-3},{"$f":"H146+(I145*(1-(H$146+H$144+H$142)))","v":5.795809184128399E-3},3.2099866250557288E-2,7.1333036112349535E-2,0.12884529647793133,0.16629514043691485,0.19750334373606776,0.20954079358002675,0.22068658047258138,0.23049487293802945,0.23629068212215784,0.24030316540347749]
[null,null,null,null,null,"Probability of graduating","Calculated",0,{"$f":"IF(I103>=gradcred,IF(SUM($H147:H147)>0,0,1-I136-I138),0)","v":0},{"$f":"IF(J103>=gradcred,IF(SUM($H147:I147)>0,0,1-J136-J138),0)","v":0},{"$f":"IF(K103>=gradcred,IF(SUM($H147:J147)>0,0,1-K136-K138),0)","v":0.90577662072156273},{"$f":"IF(L103>=gradcred,IF(SUM($H147:K147)>0,0,1-L136-L138),0)","v":0},{"$f":"IF(M103>=gradcred,IF(SUM($H147:L147)>0,0,1-M136-M138),0)","v":0},{"$f":"IF(N103>=gradcred,IF(SUM($H147:M147)>0,0,1-N136-N138),0)","v":0},{"$f":"IF(O103>=gradcred,IF(SUM($H147:N147)>0,0,1-O136-O138),0)","v":0},{"$f":"IF(P103>=gradcred,IF(SUM($H147:O147)>0,0,1-P136-P138),0)","v":0},{"$f":"IF(Q103>=gradcred,IF(SUM($H147:P147)>0,0,1-Q136-Q138),0)","v":0},{"$f":"IF(R103>=gradcred,IF(SUM($H147:Q147)>0,0,1-R136-R138),0)","v":0},{"$f":"IF(S103>=gradcred,IF(SUM($H147:R147)>0,0,1-S136-S138),0)","v":0}]
[null,null,null,null,null,"Cumulative probability of graduating","Calculated",{"$f":"H147","v":0},{"$f":"H148+(I147*(1-(H$139+H$137+H$148)))","v":0},0,0.63454194781907591,0.63454194781907591,0.63454194781907591,0.63454194781907591,0.63454194781907591,0.63454194781907591,0.63454194781907591,0.63454194781907591,0.63454194781907591]
[null,null,null,null,null,"Sum of cumulative leaving probabilities",null,{"$f":"H139+H137+H148","v":0.15645871327812852},0.23747127638694077,0.29944984966206672,1,1,1,1,1,1,1,1,1]
[null,null,null,null,null,"Probability of continuing after this year",null,{"$f":"1-H140","v":0.84354128672187145},0.76252872361305923,0.70055015033793322,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,"Probability of DO after this year",null,{"$f":"H136","v":0.11645871327812851},{"$f":"I136*H150","v":4.7270911639937421E-2},2.3852137094472974E-2,9.9641904918226862E-3,0,0,0,0,0,0,0,0,null,null,{"$f":"SUM(H151:S151)","v":0.19754595250436158}]
[null,null,null,null,null,"Probability of Transfer after this year",null,{"$f":"H138","v":0.04},{"$f":"I138*H150","v":3.374165146887486E-2},3.8126436180652964E-2,5.6044012027034656E-2,0,0,0,0,0,0,0,0,null,null,{"$f":"SUM(H152:S152)","v":0.16791209967656248}]
[null,null,null,null,null,"Probability of Grad after this year",null,{"$f":"H147","v":0},{"$f":"I147*H150","v":0},0,0.63454194781907591,0,0,0,0,0,0,0,0,null,null,{"$f":"SUM(H153:S153)","v":0.63454194781907591}]
[null,null,null,null,null,"Semester",null,1,{"$f":"H154+1","v":2},3,4,5,6,7,8,9,10,11,12]
[null,null,null,null,null,"Transfer years of BA earnings",null,{"$f":"career-(H154*0.5)-tranyrba","v":38.5},38,37.5,37,36.5,36,35.5,35,34.5,34,33.5,33,null,null,{"$f":"SUM(V151:V153)","v":1}]
[null,null,null,null,null,"Grad years of BA earnings",null,{"$f":"career-(H154*0.5)-gradyrba","v":39.5},39,38.5,38,37.5,37,36.5,36,35.5,35,34.5,34]
[null,null,null,null,null,"Exp. annual continuation earnings",null,{"$f":"0.5*H121/40*somecol","v":0},{"$f":"0.5*I121*(1-H140)*somecol/40","v":0},0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"0.5*V121*(1-S140)*somecol/40","v":0},null,{"$f":"SUM(H157:W157)","v":0}]
[null,null,null,null,null,"Exp. annual drop out earnings plus lump",null,0,{"$f":"H151*somecol","v":5376.6658746246376},2182.4034485926309,1101.2054653776283,460.02674662646979,0,0,0,0,0,0,0,null,null,{"$f":"S151*somecol","v":0},{"$f":"(career-6)*V151*somecol","v":337451.15680319053},{"$f":"SUM(H158:W158)","v":346571.45833841187}]
[null,null,null,null,null,"Exp. transfer grad earnings",null,0,{"$f":"H152*((tranyrba*somecol*0.5+earlybagrad*ba*(career-0.5*Game!H154-tranyrba)+(1-earlybagrad)*somecol*(career-0.5*H154-tranyrba)))","v":92996.615808000002},{"$f":"I152*((tranyrba*somecol*0.5+earlybagrad*ba*(career-0.5*Game!I154-tranyrba)+(1-earlybagrad)*somecol*(career-0.5*I154-tranyrba)))","v":77468.161377259457},{"$f":"J152*((tranyrba*somecol*0.5+earlybagrad*ba*(career-0.5*Game!J154-tranyrba)+(1-earlybagrad)*somecol*(career-0.5*J154-tranyrba)))","v":86429.821665722469},{"$f":"K152*((tranyrba*somecol*0.5+earlybagrad*ba*(career-0.5*Game!K154-tranyrba)+(1-earlybagrad)*somecol*(career-0.5*K154-tranyrba)))","v":125422.67572850871},{"$f":"L152*((tranyrba*somecol*0.5+earlybagrad*ba*(career-0.5*Game!L154-tranyrba)+(1-earlybagrad)*somecol*(career-0.5*L154-tranyrba)))","v":0},{"$f":"M152*((tranyrba*somecol*0.5+earlybagrad*ba*(career-0.5*Game!M154-tranyrba)+(1-earlybagrad)*somecol*(career-0.5*M154-tranyrba)))","v":0},{"$f":"N152*((tranyrba*somecol*0.5+earlybagrad*ba*(career-0.5*Game!N154-tranyrba)+(1-earlybagrad)*somecol*(career-0.5*N154-tranyrba)))","v":0},{"$f":"O152*((tranyrba*somecol*0.5+earlybagrad*ba*(career-0.5*Game!O154-tranyrba)+(1-earlybagrad)*somecol*(career-0.5*O154-tranyrba)))","v":0},{"$f":"P152*((tranyrba*somecol*0.5+earlybagrad*ba*(career-0.5*Game!P154-tranyrba)+(1-earlybagrad)*somecol*(career-0.5*P154-tranyrba)))","v":0},{"$f":"Q152*((tranyrba*somecol*0.5+earlybagrad*ba*(career-0.5*Game!Q154-tranyrba)+(1-earlybagrad)*somecol*(career-0.5*Q154-tranyrba)))","v":0},{"$f":"R152*((tranyrba*somecol*0.5+earlybagrad*ba*(career-0.5*Game!R154-tranyrba)+(1-earlybagrad)*somecol*(career-0.5*R154-tranyrba)))","v":0},null,null,{"$f":"S152*((tranyrba*somecol*0.5+earlybagrad*ba*(career-0.5*Game!S154-tranyrba)+(1-earlybagrad)*somecol*(career-0.5*S154-tranyrba)))","v":0},0,{"$f":"SUM(H159:W159)","v":382317.27457949065}]
[null,null,null,null,null,"Exp. grad earnings",null,"-",{"$f":"H153*((gradyrba*aa*0.5)+(career-0.5*H154-gradyrba)*(ba*(aabagrad*aatran)+aa*(((1-aabagrad)*aatran)+(1-aatran))))","v":0},0,0,1377679.9502939836,0,0,0,0,0,0,0,null,null,{"$f":"S153*((gradyrba*aa*0.5)+(career-0.5*S154-gradyrba)*(ba*(aabagrad*aatran)+aa*(((1-aabagrad)*aatran)+(1-aatran))))","v":0},null,{"$f":"SUM(H160:W160)","v":1377679.9502939836}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"sum",{"$f":"SUM(X157:X160)","v":2106568.6832118863}]
[]
[]
[]
[null,null,null,null,null,"Average"]
[null,null,null,null,null,{"$f":"\"Developmental Courses Needed (0-\"&maxdev&\")\"","v":"Developmental Courses Needed (0-7)"},1,"Cumulative probability of dropping out:",null,null,null,null,{"$f":"S191","v":3}]
[null,null,null,null,null,"High School Performance (0.00 - 4.00)",3,"Expected lifetime earnings:",null,null,null,{"$f":"X215","v":0}]
[null,null,null,null,null,null,{"$f":"7*24","v":168}]
[null,null,null,null,null,"  Fun, hours per week (computed)",null,{"$f":"IF(($G$113-H171*7-H172*7-H173*(Corhrs+Corcred*(H174))-H175-H176)<0,\"Error\",($G$113-H171*7-H172*7-H173*(Corhrs+Corcred*(H174))-H175-H176))","v":21},21,23,5,8,9,17,17,18,18,18,18]
[null,null,null,null,null,"Input variables: Average Student"]
[null,null,null,null,null,"  Sleep, eat, commute: hours per day",null,12,12,12,11,12,11,11,11,11,11,11,11]
[null,null,null,null,null,"  Family: hours per day",null,3,3,3,3,3,3,3,3,3,3,3,3]
[null,null,null,null,null,{"$f":"\"  Courses (\"&Corcred&\" credits/course)\"","v":"  Courses (3 credits/course)"},null,6,6,0,6,6,5,3,3,3,3,3,3]
[null,null,null,null,null,{"$f":"\"  Hours of study/course credit (max. \"&maxstudy&\")\"","v":"  Hours of study/course credit (max. 3)"},null,1,1,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,{"$f":"\"  Support activities: hours per week (max. \"&maxsup&\")\"","v":"  Support activities: hours per week (max. 10)"},null,0,0,0,1,1,1,1,1,0,0,0,0]
[null,null,null,null,null,"  Work: hours per week",null,0,0,40,40,30,40,40,40,40,40,40,40]
[null,null,null,null,null,"  Change major (1=yes)",null,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,null,null,"Above 3.00"]
[null,null,null,null,null,null,null,1,{"$f":"H180+1","v":2},3,4,5,6,7,8,9,10,11,12]
[null,null,null,null,null,"Cum P DO",null,9.3587521663778164E-2,0.15424610051993068,0.17157712305025996,0.18890814558058924,0.21143847487001732,0.22183708838821489,0.23223570190641246,0.23916811091854417,0.24090121317157709,0.24436741767764295,0.24610051993067589,0.24956672443674174]
[null,null,null,null,null,"Cum P T",null,3.292894280762565E-2,7.452339688041594E-2,0.10398613518197573,0.15771230502599654,0.1733102253032929,0.19410745233968804,0.20103986135181975,0.20797227036395147,0.21317157712305024,0.21317157712305024,0.21490467937608318,0.21837088388214904]
[null,null,null,null,null,"Cum P G",null,0,1.0398613518197573E-2,1.2131715771230501E-2,8.1455805892547653E-2,0.17677642980935876,0.29289428076256502,0.36048526863084923,0.41074523396880419,0.43847487001733104,0.46273830155979206,0.47660311958405549,0.48180242634315429]
[null,null,null,null,null,"Above 3.00"]
[null,null,null,null,null,{"$f":"\"Developmental Courses Needed (0-\"&maxdev&\")\"","v":"Developmental Courses Needed (0-7)"},0,"Cumulative probability of dropping out:",null,null,null,null,{"$f":"S210","v":0}]
[null,null,null,null,null,"High School Performance (0.00 - 4.00)",3.75,"Expected lifetime earnings:",null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,{"$f":"7*24","v":168}]
[null,null,null,null,null,"  Fun, hours per week (computed)",null,{"$f":"IF(($G$113-H190*7-H191*7-H192*(Corhrs+Corcred*(H193))-H194-H195)<0,\"Error\",($G$113-H190*7-H191*7-H192*(Corhrs+Corcred*(H193))-H194-H195))","v":2},2,2,2,2,28,28,28,28,28,28,28]
[null,null,null,null,null,"Input variables: Good Student"]
[null,null,null,null,null,"  Sleep, eat, commute: hours per day",null,10,10,10,10,10,10,10,10,10,10,10,10]
[null,null,null,null,null,"  Family: hours per day",null,3,3,3,3,3,3,3,3,3,3,3,3]
[null,null,null,null,null,{"$f":"\"  Courses (\"&Corcred&\" credits/course)\"","v":"  Courses (3 credits/course)"},null,5,5,5,5,5,3,3,3,3,3,3,3]
[null,null,null,null,null,{"$f":"\"  Hours of study/course credit (max. \"&maxstudy&\")\"","v":"  Hours of study/course credit (max. 3)"},null,3,3,3,3,3,3,3,3,3,3,3,3]
[null,null,null,null,null,{"$f":"\"  Support activities: hours per week (max. \"&maxsup&\")\"","v":"  Support activities: hours per week (max. 10)"},null,10,10,10,10,10,10,10,10,10,10,10,10]
[null,null,null,null,null,"  Work: hours per week",null,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,"  Change major (1=yes)",null,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[]
[null,null,null,null,null,"Not Good"]
[null,null,null,null,null,{"$f":"\"Developmental Courses Needed (0-\"&maxdev&\")\"","v":"Developmental Courses Needed (0-7)"},7,"Cumulative probability of dropping out:",null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,"High School Performance (0.00 - 4.00)",0,"Expected lifetime earnings:",null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,{"$f":"7*24","v":168}]
[null,null,null,null,null,"  Fun, hours per week (computed)",null,{"$f":"IF(($G$113-H206*7-H207*7-H208*(Corhrs+Corcred*(H209))-H210-H211)<0,\"Error\",($G$113-H206*7-H207*7-H208*(Corhrs+Corcred*(H209))-H210-H211))","v":33},38,37,39,43,51,43,43,51,43,43,43]
[null,null,null,null,null,"Input variables: Weak Student"]
[null,null,null,null,null,"  Sleep, eat, commute: hours per day",null,8,8,8,8,8,8,8,8,8,8,8,8]
[null,null,null,null,null,"  Family: hours per day",null,5,5,5,3,3,3,3,3,3,3,3,3]
[null,null,null,null,null,{"$f":"\"  Courses (\"&Corcred&\" credits/course)\"","v":"  Courses (3 credits/course)"},null,3,2,0,3,2,0,2,2,0,2,2,2]
[null,null,null,null,null,{"$f":"\"  Hours of study/course credit (max. \"&maxstudy&\")\"","v":"  Hours of study/course credit (max. 3)"},null,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,{"$f":"\"  Support activities: hours per week (max. \"&maxsup&\")\"","v":"  Support activities: hours per week (max. 10)"},null,2,1,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,"  Work: hours per week",null,30,30,40,40,40,40,40,40,40,40,40,40]
[null,null,null,null,null,"  Change major (1=yes)",null,0,0,0,0,1,0,0,0,0,0,0,0]
[]
[null,null,null,null,null,"<2.5 Cum GPA final"]
[null,null,null,null,null,"Cum P DO",null,0.19935948759007205,0.33226581265012012,0.40352281825460368,0.43714971977582062,0.47237790232185745,0.50040032025620496,0.51881505204163325,0.5340272217774219,0.55004003202562046,0.55964771817453962,0.57165732586068851,0.57966373098478785]
[null,null,null,null,null,"Cum P T",null,5.9247397918334666E-2,0.10168134507606084,0.13290632506004804,0.20016012810248196,0.24179343474779821,0.25620496397117692,0.27862289831865489,0.29143314651721375,0.29783827061649315,0.30584467574059243,0.3130504403522818,0.31545236188951159]
[null,null,null,null,null,"Cum P G",null,0,0,0,4.0032025620496394E-3,8.8070456365092076E-3,2.5620496397117699E-2,3.5228182546036838E-2,5.1240992794235399E-2,5.5244195356285039E-2,6.0048038430744612E-2,6.4851881505204184E-2,6.9655724579663764E-2]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"A Model of the Path to Graduation--Life Happens, Some Students Have Better Protection Against It"]
[null,null,null,null,null,null,"Initial",{"$f":"\"Term \"& TEXT(H355,Paramters!$C$1)","v":"Term 1"},{"$f":"\"Term \"& TEXT(I355,Paramters!$C$1)","v":"Term 2"},{"$f":"\"Term \"& TEXT(J355,Paramters!$C$1)","v":"Term 3"},{"$f":"\"Term \"& TEXT(K355,Paramters!$C$1)","v":"Term 4"},{"$f":"\"Term \"& TEXT(L355,Paramters!$C$1)","v":"Term 5"},{"$f":"\"Term \"& TEXT(M355,Paramters!$C$1)","v":"Term 6"},{"$f":"\"Term \"& TEXT(N355,Paramters!$C$1)","v":"Term 7"},{"$f":"\"Term \"& TEXT(O355,Paramters!$C$1)","v":"Term 8"},{"$f":"\"Term \"& TEXT(P355,Paramters!$C$1)","v":"Term 9"},{"$f":"\"Term \"& TEXT(Q355,Paramters!$C$1)","v":"Term 10"},{"$f":"\"Term \"& TEXT(R355,Paramters!$C$1)","v":"Term 11"},{"$f":"\"Term \"& TEXT(S355,Paramters!$C$1)","v":"Term 12"}]
[null,null,null,null,null,"Protection Level",null,{"$f":"((maxdev-G323)*devfac+G324*hsgrdfac)+2","v":68},{"$f":"0*H326+H302+IF(H304>=gradcred,0,-IF(H328<minsleep,minsleep-H328,0)*sleepfac+MIN(H332,maxsup)*Supfac)+MIN(H331,maxstudy)*(H304-G304)*Grdfac+(H304-G304)*credfac","v":553},1131,1616,1988,1988,1988,1988,1988,1988,1988,1988]
[null,null,null,null,null,"Outcome, after end of semester",null,{"$f":"VLOOKUP(H368,state,2)","v":"Continue"},"Continue","Continue","Graduation","Graduation","Graduation","Graduation","Graduation","Graduation","Graduation","Graduation","Graduation",{"$f":"MATCH(\"Continue\",Game!H303:S303,1)","v":3}]
[null,null,null,null,null,"Credits toward graduation, term end",{"$f":"-G323*3","v":0},{"$f":"ROUNDDOWN(IF(G304+H353-IF(AND(H334=1,G304>0),majloss*G304,0)>=gradcred,gradcred,G304+H353-IF(AND(H334=1,G304>0),majloss*G304,0)),0)","v":15},33,48,60,60,60,60,60,60,60,60,60]
[null,null,null,null,null,null,90,{"$f":"100*(H$338)","v":41.927974369257242},{"$f":"100*(I$338)","v":71.034601750026425},84.967881746341163,92.902694923405448,97.84410101111834,97.84410101111834,97.84410101111834,97.84410101111834,97.84410101111834,97.84410101111834,97.84410101111834,97.84410101111834]
[null,null,null,null,null,null,{"$f":"G305-10","v":80},41.927974369257242,71.034601750026425,84.967881746341163,92.902694923405448,97.84410101111834,97.84410101111834,97.84410101111834,97.84410101111834,97.84410101111834,97.84410101111834,97.84410101111834,97.84410101111834]
[null,null,null,null,null,"Wall of Protection",70,41.927974369257242,71.034601750026425,84.967881746341163,92.902694923405448,97.84410101111834,97.84410101111834,97.84410101111834,97.84410101111834,97.84410101111834,97.84410101111834,97.84410101111834,97.84410101111834]
[null,null,null,null,null,null,60,41.927974369257242,71.034601750026425,84.967881746341163,92.902694923405448,97.84410101111834,97.84410101111834,97.84410101111834,97.84410101111834,97.84410101111834,97.84410101111834,97.84410101111834,97.84410101111834]
[null,null,null,null,null,null,50,41.927974369257242,71.034601750026425,84.967881746341163,92.902694923405448,97.84410101111834,97.84410101111834,97.84410101111834,97.84410101111834,97.84410101111834,97.84410101111834,97.84410101111834,97.84410101111834]
[null,null,null,null,null,null,40,41.927974369257242,71.034601750026425,84.967881746341163,92.902694923405448,97.84410101111834,97.84410101111834,97.84410101111834,97.84410101111834,97.84410101111834,97.84410101111834,97.84410101111834,97.84410101111834]
[null,null,null,null,null,null,30,41.927974369257242,71.034601750026425,84.967881746341163,92.902694923405448,97.84410101111834,97.84410101111834,97.84410101111834,97.84410101111834,97.84410101111834,97.84410101111834,97.84410101111834,97.84410101111834]
[null,null,null,null,null,null,20,41.927974369257242,71.034601750026425,84.967881746341163,92.902694923405448,97.84410101111834,97.84410101111834,97.84410101111834,97.84410101111834,97.84410101111834,97.84410101111834,97.84410101111834,97.84410101111834]
[null,null,null,null,null,null,10,41.927974369257242,71.034601750026425,84.967881746341163,92.902694923405448,97.84410101111834,97.84410101111834,97.84410101111834,97.84410101111834,97.84410101111834,97.84410101111834,97.84410101111834,97.84410101111834]
[null,null,null,null,null,null,0,41.927974369257242,71.034601750026425,84.967881746341163,92.902694923405448,97.84410101111834,97.84410101111834,97.84410101111834,97.84410101111834,97.84410101111834,97.84410101111834,97.84410101111834,97.84410101111834]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,{"$f":"\"Developmental Courses Needed (0-\"&maxdev&\")\"","v":"Developmental Courses Needed (0-7)"},{"$f":"Game!G111","v":0},"Student:",{"$f":"VLOOKUP((RAND()+1/142)*142,Names,2)&\", \"&VLOOKUP((RAND()+1/142)*142,Names,3)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,"High School Performance (0.00 - 4.00)",{"$f":"Game!G112","v":4},"Lifetime salary",null,{"$f":"U379","v":2525873.9}]
[null,null,null,null,null,"Time Distribution--Hours per week",{"$f":"7*24","v":168}]
[null,null,null,null,null,"  Fun, hours per week (computed)",null,{"$f":"Game!H114","v":0},{"$f":"Game!I114","v":0},{"$f":"Game!J114","v":0},{"$f":"Game!K114","v":0},{"$f":"Game!L114","v":0},{"$f":"Game!M114","v":0},{"$f":"Game!N114","v":0},{"$f":"Game!O114","v":0},{"$f":"Game!P114","v":0},{"$f":"Game!Q114","v":0},{"$f":"Game!R114","v":0},{"$f":"Game!S114","v":0}]
[null,null,null,null,null,"Input variables"]
[null,null,null,null,null,"  Sleep, eat, commute: hours per day",null,{"$f":"Game!H116","v":11.428571428571429},{"$f":"Game!I116","v":11.428571428571429},{"$f":"Game!J116","v":11.428571428571429},{"$f":"Game!K116","v":11.428571428571429},{"$f":"Game!L116","v":11.428571428571429},{"$f":"Game!M116","v":11.428571428571429},{"$f":"Game!N116","v":11.428571428571429},{"$f":"Game!O116","v":11.428571428571429},{"$f":"Game!P116","v":11.428571428571429},{"$f":"Game!Q116","v":11.428571428571429},{"$f":"Game!R116","v":11.428571428571429},{"$f":"Game!S116","v":11.428571428571429}]
[null,null,null,null,null,"  Family: hours per day",null,{"$f":"Game!H117","v":0},{"$f":"Game!I117","v":0},{"$f":"Game!J117","v":0},{"$f":"Game!K117","v":0},{"$f":"Game!L117","v":0},{"$f":"Game!M117","v":0},{"$f":"Game!N117","v":0},{"$f":"Game!O117","v":0},{"$f":"Game!P117","v":0},{"$f":"Game!Q117","v":0},{"$f":"Game!R117","v":0},{"$f":"Game!S117","v":0}]
[null,null,null,null,null,{"$f":"\"  Courses (\"&Corcred&\" credits/course)\"","v":"  Courses (3 credits/course)"},null,{"$f":"Game!H118","v":6},{"$f":"Game!I118","v":6},{"$f":"Game!J118","v":6},{"$f":"Game!K118","v":6},{"$f":"Game!L118","v":6},{"$f":"Game!M118","v":6},{"$f":"Game!N118","v":6},{"$f":"Game!O118","v":6},{"$f":"Game!P118","v":6},{"$f":"Game!Q118","v":6},{"$f":"Game!R118","v":6},{"$f":"Game!S118","v":6}]
[null,null,null,null,null,{"$f":"\"  Hours of study/course credit (max. \"&maxstudy&\")\"","v":"  Hours of study/course credit (max. 3)"},null,{"$f":"Game!H119","v":3},{"$f":"Game!I119","v":3},{"$f":"Game!J119","v":3},{"$f":"Game!K119","v":3},{"$f":"Game!L119","v":3},{"$f":"Game!M119","v":3},{"$f":"Game!N119","v":3},{"$f":"Game!O119","v":3},{"$f":"Game!P119","v":3},{"$f":"Game!Q119","v":3},{"$f":"Game!R119","v":3},{"$f":"Game!S119","v":3}]
[null,null,null,null,null,{"$f":"\"  Support activities: hours per week (max. \"&maxsup&\")\"","v":"  Support activities: hours per week (max. 10)"},null,{"$f":"Game!H120","v":10},{"$f":"Game!I120","v":10},{"$f":"Game!J120","v":10},{"$f":"Game!K120","v":10},{"$f":"Game!L120","v":10},{"$f":"Game!M120","v":10},{"$f":"Game!N120","v":10},{"$f":"Game!O120","v":10},{"$f":"Game!P120","v":10},{"$f":"Game!Q120","v":10},{"$f":"Game!R120","v":10},{"$f":"Game!S120","v":10}]
[null,null,null,null,null,"  Work: hours per week",null,{"$f":"Game!H121","v":0},{"$f":"Game!I121","v":0},{"$f":"Game!J121","v":0},{"$f":"Game!K121","v":0},{"$f":"Game!L121","v":0},{"$f":"Game!M121","v":0},{"$f":"Game!N121","v":0},{"$f":"Game!O121","v":0},{"$f":"Game!P121","v":0},{"$f":"Game!Q121","v":0},{"$f":"Game!R121","v":0},{"$f":"Game!S121","v":0}]
[null,null,null,null,null,"  Change major (1=yes)",null,{"$f":"Game!H122","v":0},{"$f":"Game!I122","v":0},{"$f":"Game!J122","v":0},{"$f":"Game!K122","v":0},{"$f":"Game!L122","v":1},{"$f":"Game!M122","v":0},{"$f":"Game!N122","v":0},{"$f":"Game!O122","v":0},{"$f":"Game!P122","v":0},{"$f":"Game!Q122","v":0},{"$f":"Game!R122","v":0},{"$f":"Game!S122","v":0}]
[]
[]
[]
[null,null,null,null,null,"Protection",null,{"$f":"(1-((minprot+(maxprot-H302))/maxprot))^profac","v":0.41927974369257243},0.71034601750026427,0.84967881746341156,0.92902694923405449,0.97844101011118334,0.97844101011118334,0.97844101011118334,0.97844101011118334,0.97844101011118334,0.97844101011118334,0.97844101011118334,0.97844101011118334]
[null,null,null,null,null,"Probability of dropping out",null,{"$f":"(1-H338)*badfac","v":0.11614405126148553},5.7930796499947146E-2,3.0064236507317689E-2,1.4194610153189104E-2,4.3117979777633321E-3,4.3117979777633321E-3,4.3117979777633321E-3,4.3117979777633321E-3,4.3117979777633321E-3,4.3117979777633321E-3,4.3117979777633321E-3,4.3117979777633321E-3,"From the protection table"]
[null,null,null,null,null,"Cumulative probability of dropping out",null,{"$f":"H339","v":0.11614405126148553},{"$f":"H340+(I339*(1-(H$342+H$340+H$365)))","v":0.16502929850312623},0.18766099144826742,0.19749086282586692,0.20019555391912738,0.20259106691054279,0.20259106691054279,0.20259106691054279,0.20259106691054279,0.20259106691054279,0.20259106691054279,0.20259106691054279,"The probability of a life event times the probability of impact, considering protection."]
[null,null,null,null,null,"Probability of transfer",null,0.04,0.05,0.05,0.08,0.11,7.0000000000000007E-2,7.0000000000000007E-2,0.06,0.06,0.06,0.06,0.06,"The previous semesters probability of leaving plus 1 minus that probability (the probability of not having left) times this semesters probability of leaving, up to earning graduation level credits."]
[null,null,null,null,null,"Cumulative probability of transfer",null,{"$f":"H341","v":0.04},{"$f":"H342+(I341*(1-(H$342+H$363+H$365)))","v":8.219279743692573E-2},0.11983169263992313,0.17523227791286788,0.24423273243160704,0.28312275238705564,0.28312275238705564,0.28312275238705564,0.28312275238705564,0.28312275238705564,0.28312275238705564,0.28312275238705564]
[null,null,null,null,null,"Cumulative probability of leaving",null,{"$f":"H340+H342+H365","v":0.15614405126148553},0.24722209594005196,0.30749268408819053,0.3727231407387348,0.44442828635073439,1,1,1,1,1,1,1]
[null,null,null,null,null,"Course pass probability",null,{"$f":"(minpass+(MIN(H331,maxstudy)/maxstudy)*(maxpass-minpass))","v":0.9},0.9,0.9,0.9,0.9,0.9,0.9,0.9,0.9,0.9,0.9,0.9]
[null,null,null,null,null,"Random course outcome",1,{"$f":"RAND()","v":0.98471410407398952},0.68646245187526378,0.53473065533276376,0.2497459431960819,0.98655804468589203,0.60030390703907011,0.7429362138826473,0.30842444394725876,0.97218281887319047,0.37356161758293349,0.23062898632561291,0.98723245306466867]
[null,null,null,null,null,"Random course outcome",{"$f":"G345+1","v":2},0.51275282101453523,0.81688792592324433,0.71891959888634027,8.2123464069980945E-2,3.0010444195606945E-2,0.48756862370125031,0.66168482916295879,0.83182718263523259,0.26506042062875901,0.24589258780818135,0.30406425080422661,0.25939852246394701]
[null,null,null,null,null,"Random course outcome",3,0.47887228240409307,0.34598101239809032,0.18649475204308474,0.383154189992014,0.54887319822650293,0.9129286823432603,0.26872777890373112,0.88280561889585007,0.98841437186973458,0.18984559095022635,0.8082520677579752,0.80373827979934109]
[null,null,null,null,null,"Random course outcome",4,0.8168273042381613,0.55273458417753885,0.54920355121203213,0.34359524489236615,0.8502291867811288,0.30782499034002742,0.85729275071434385,0.75865452021535285,0.54100008144882505,0.50941512590131721,0.12786785043208915,0.20373441204409315]
[null,null,null,null,null,"Random course outcome",5,0.58960846271792444,0.28630602152325668,0.37412089667260762,0.37734173015549155,0.77274080801829348,0.19522679819434452,0.44221505129703198,1.1334912751733817E-2,0.25462375209009358,1.018623573296118E-2,0.41133366930987925,0.95964858035783018]
[null,null,null,null,null,"Random course outcome",6,0.41222626411187546,0.11195316235978914,0.98787915363360124,0.72226413774918952,0.66958204626921269,0.89865335485132569,2.05555988200673E-2,0.39835999133027511,0.95455956337123804,0.93661021500043085,0.44727886744940448,0.10680673460278489]
[null,null,null,null,null,"Random course outcome",7,0.9336101645467535,9.8808663118260198E-2,0.42495625414034766,0.95699683943615199,3.9998676776402564E-2,0.39053204430594157,0.50414264308018186,0.83604033773159769,8.3087894820266239E-3,0.58744187112715973,0.33375138605505628,0.79925252089090693]
[null,null,null,null,null,"Random course outcome",8,6.637135311795439E-3,0.90724694033351727,3.7492848790213973E-2,0.13245986202383175,0.21811827360213765,0.76473621820593007,0.72797576479005777,0.7543621010670627,8.6688627918972139E-2,0.27575382559624129,0.31424166340385085,0.5063641977689658]
[null,null,null,null,null,"Credits earned",{"$f":"-G323*3","v":0},{"$f":"Corcred*(IF(H345>H$344,0,1)*(H330>=1)+IF(H346>H$344,0,1)*(H330>=2)+IF(H347>H$344,0,1)*(H330>=3)+IF(H348>H$344,0,1)*(H330>=4)+IF(H349>H$344,0,1)*(H330>=5)+IF(H350>H$344,0,1)*(H330>=6)+IF(H351>H$344,0,1)*(H330>=7)+IF(H352>H$344,0,1)*(H330>=8))","v":15},18,15,18,15,15,18,18,9,15,18,12]
[null,null,null,null,null,"Cumulative credits earned, raw",{"$f":"G353","v":0},{"$f":"ROUNDDOWN(G354+H353,0)","v":15},33,48,66,81,96,114,132,141,156,174,186]
[null,null,null,null,null,"Semester",null,1,{"$f":"H355+1","v":2},3,4,5,6,7,8,9,10,11,12]
[null,null,null,null,null,"Probability of transfer","Actual",4.3245653143111906E-2,5.1733626857457346E-2,4.5637583892617448E-2,0.1135091926458833,7.9958463136033234E-2,6.5217391304347824E-2,7.4803149606299218E-2,6.5217391304347824E-2,5.536332179930796E-2,6.6964285714285712E-2,7.5144508670520235E-2,6.2015503875968991E-2]
[null,null,null,null,null,"Cum Probability of transfer","Actual",{"$f":"H356","v":4.3245653143111906E-2},{"$f":"H357+(I356*(1-(H$361+H$359+H$357)))","v":8.5153811859117245E-2},0.1154703522068658,0.17877842175657602,0.21310744538564425,0.23316986179224256,0.25011145786892558,0.260811413285778,0.26794471689701294,0.27463218903254571,0.28042799821667413,0.28399465002229163]
[null,null,null,null,null,"Probability of dropping out","Actual",0.14355773517610343,0.12493120528343424,7.5167785234899323E-2,4.6362909672262191E-2,6.9574247144340601E-2,7.6811594202898556E-2,6.2992125984251968E-2,7.6086956521739135E-2,8.3044982698961933E-2,6.25E-2,0.10404624277456648,9.3023255813953487E-2]
[null,null,null,null,null,"Cum Probability of dropping out","Actual",{"$f":"H358","v":0.14355773517610343},{"$f":"H359+(I358*(1-(H$361+H$359+H$357)))","v":0.24476148016049934},0.294694605439144,0.3205528310298707,0.35042353990191705,0.37405260811413282,0.38831921533660274,0.40080249665626388,0.41150245207311631,0.41774409273294688,0.42576905929558617,0.43111903700401238]
[null,null,null,null,null,"Probability of graduating","Actual",3.120820329915292E-3,3.3021463951568518E-3,3.9597315436241613E-2,7.034372501998401E-2,0.13395638629283488,0.12173913043478261,0.13779527559055119,7.3369565217391311E-2,8.6505190311418678E-2,9.8214285714285712E-2,7.5144508670520235E-2,6.9767441860465115E-2]
[null,null,null,null,null,"Cum Probability of graduating","Actual",{"$f":"H360","v":3.120820329915292E-3},{"$f":"H361+(I360*(1-(H$361+H$359+H$357)))","v":5.795809184128399E-3},3.2099866250557288E-2,7.1333036112349535E-2,0.12884529647793133,0.16629514043691485,0.19750334373606776,0.20954079358002675,0.22068658047258138,0.23049487293802945,0.23629068212215784,0.24030316540347749]
[null,null,null,null,null,"Probability of dropping out","Calculated",{"$f":"H339","v":0.11614405126148553},5.7930796499947146E-2,3.0064236507317689E-2,1.4194610153189104E-2,4.3117979777633321E-3,4.3117979777633321E-3,4.3117979777633321E-3,4.3117979777633321E-3,4.3117979777633321E-3,4.3117979777633321E-3,4.3117979777633321E-3,4.3117979777633321E-3]
[null,null,null,null,null,"Cum Probability of dropping out","Calculated",{"$f":"H362","v":0.11614405126148553},{"$f":"H363+(I362*(1-(H$342+H$363+H$365)))","v":0.16502929850312623},0.18766099144826742,0.19749086282586692,0.20019555391912738,0.20259106691054279,0.20259106691054279,0.20259106691054279,0.20259106691054279,0.20259106691054279,0.20259106691054279,0.20259106691054279]
[null,null,null,null,null,"Probability of graduating","Calculated",0,{"$f":"IF(G304>=gradcred,IF(SUM($H364:H364)>0,0,1-I339-I341),0)","v":0},{"$f":"IF(H304>=gradcred,IF(SUM($H364:I364)>0,0,1-J339-J341),0)","v":0},{"$f":"IF(I304>=gradcred,IF(SUM($H364:J364)>0,0,1-K339-K341),0)","v":0},{"$f":"IF(J304>=gradcred,IF(SUM($H364:K364)>0,0,1-L339-L341),0)","v":0},{"$f":"IF(K304>=gradcred,IF(SUM($H364:L364)>0,0,1-M339-M341),0)","v":0.92568820202223656},{"$f":"IF(L304>=gradcred,IF(SUM($H364:M364)>0,0,1-N339-N341),0)","v":0},{"$f":"IF(M304>=gradcred,IF(SUM($H364:N364)>0,0,1-O339-O341),0)","v":0},{"$f":"IF(N304>=gradcred,IF(SUM($H364:O364)>0,0,1-P339-P341),0)","v":0},{"$f":"IF(O304>=gradcred,IF(SUM($H364:P364)>0,0,1-Q339-Q341),0)","v":0},{"$f":"IF(P304>=gradcred,IF(SUM($H364:Q364)>0,0,1-R339-R341),0)","v":0},{"$f":"IF(Q304>=gradcred,IF(SUM($H364:R364)>0,0,1-S339-S341),0)","v":0}]
[null,null,null,null,null,"Cumulative probability of graduating","Calculated",{"$f":"H364","v":0},{"$f":"H365+(I364*(1-(H$342+H$363+H$365)))","v":0},0,0,0,0.51428618070240151,0.51428618070240151,0.51428618070240151,0.51428618070240151,0.51428618070240151,0.51428618070240151,0.51428618070240151]
[null,null,null,null,null,null,null,{"$f":"H342+H363+H365","v":0.15614405126148553},0.24722209594005196,0.30749268408819053,0.3727231407387348,0.44442828635073439,1,1,1,1,1,1,1]
[null,null,null,null,null,"Life Outcome",null,{"$f":"RAND()","v":0.59207052902809199},0.53552153500481114,0.76094008995971352,0.54587500582367909,0.27257127096994582,0.90960085121103884,0.77534848442330095,0.39368296629585331,0.14576297157989537,0.18427618641642474,0.51098696555880918,0.10141769678660939]
[null,null,null,null,null,"4=grad, 3= DO, 2=Trans, 1=Cont.",1,{"$f":"IF(G304>=gradcred,4,IF(H367<H339,3,IF(H367<(H339+H341),2,1)))","v":1},{"$f":"IF(H368>1,H368,IF(I304>=gradcred,4,IF(I367<I339,3,IF(I367<(I339+I341),2,1))))","v":1},1,4,4,4,4,4,4,4,4,4]
[null,null,null,null,null,"Graph variables"]
[null,null,null,null,null,{"$f":"F340","v":"Cumulative probability of dropping out"},null,{"$f":"IF(G368=1,H340,IF(G368=3,1,0))","v":0.11614405126148553},0.16502929850312623,0.18766099144826742,0.19749086282586692,0,0,0,0,0,0,0,0]
[null,null,null,null,null,{"$f":"F342","v":"Cumulative probability of transfer"},null,{"$f":"IF(G368=1,H342,IF(G368=2,1,0))","v":0.04},8.219279743692573E-2,0.11983169263992313,0.17523227791286788,0,0,0,0,0,0,0,0]
[null,null,null,null,null,{"$f":"F365","v":"Cumulative probability of graduating"},null,{"$f":"IF(G368=1,H365,IF(G368=4,1,0))","v":0},0,0,0,1,1,1,1,1,1,1,1]
[null,null,null,null,null,{"$f":"F343","v":"Cumulative probability of leaving"},null,{"$f":"IF(G368=1,H343,1)","v":0.15614405126148553},0.24722209594005196,0.30749268408819053,0.3727231407387348,1,1,1,1,1,1,1,1]
[null,null,null,null,null,"Salary calculations"]
[null,null,null,null,null,"Salary in school",null,{"$f":"IF(H368=1,H333*0.5*somecol/40,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(S368=1,(career-6)*somecol,0)","v":0},{"$f":"SUM(H375:T375)","v":0}]
[null,null,null,null,null,"Salary if drop out",null,{"$f":"IF(AND(G368=1,H368=3),(career-H355/0.5)*somecol,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(AND(S368=1,T371=3),(career-T359/0.5)*somecol,0)","v":0},{"$f":"SUM(H376:T376)","v":0}]
[null,null,null,null,null,"Salary if transfer",null,{"$f":"IF(AND(G368=1,H368=2),((1-earlybagrad)*(career-H355/2)*aa)+(earlybagrad*(ba*(career-tranyrba-H355/2)+(aa*tranyrba))),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(AND(S368=1,T371=2),((1-earlybagrad)*(career-T359/2)*aa)+(earlybagrad*(ba*(career-tranyrba-T359/2)+(aa*tranyrba))),0)","v":0},{"$f":"SUM(H377:T377)","v":0}]
[null,null,null,null,null,"Salary if grad",null,{"$f":"IF(AND(G368=1,H368=4),(aatran*((career-H355/2-gradyrba)*ba)+(gradyrba*aa))+((1-aatran)*(career-H355/2)*aa),0)","v":0},0,0,2525873.9,0,0,0,0,0,0,0,0,{"$f":"IF(AND(S368=1,T371=4),(aatran*((career-T359/2-gradyrba)*ba)+(gradyrba*aa))+((1-aatran)*(career-T359/2)*aa),0)","v":0},{"$f":"SUM(H378:T378)","v":2525873.9}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(U375:U378)","v":2525873.9}]

{"sheet":"Paramters","index":2,"n_rows":45,"n_cols":11,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
[null,"Parameters",0,null,null,null,"Test Status","Need","%","Num."]
["badfac","Probability of a bad thing in life",0.2,"The probability of something bad enough happening each semester that without sufficient protection the student will leave.",null,null,"Passed All",0,0.25,693,{"$f":"I2*H2","v":0}]
["Supfac","Support Factor (protection points per hour)",2,"This is multiplied times the hours spent in support activities to increase protection points.",null,null,"Passed Two",1,0.28999999999999998,811,{"$f":"I3*H3","v":0.28999999999999998}]
["credfac","Credit factor",1,"This is multiplied times the number of credits earned to increase protection points.",null,null,"Passed One",2,0.28000000000000003,807,{"$f":"I4*H4","v":0.56000000000000005}]
["Grdfac","Grades additional multiplier",10,"This is the % added for each hour of study for each course in the increase to protection points.",null,null,"Passed None",3,0.18,517,0.54]
["minpass","Minimum probability of  passing course with 0 hours of study",0.63,"If good grades are turned off, this is the proportion of credits earned.",null,null,null,null,null,{"$f":"SUM(J2:J5)","v":2828},{"$f":"SUM(K2:K5)","v":1.3900000000000001}]
["maxpass",{"$f":"\"Maximum probability of passing course with \"&maxstudy&\" hours of study\"","v":"Maximum probability of passing course with 3 hours of study"},0.9,"If good grades are turned on, this is the proportion of credits earned."]
["gradcred","Credits for graduation",60]
["majloss","% loss of earned credits for major change",0.2,"This is the proportion of accumulated credits lost whenever a major is changed."]
["Corcred","Credits per course",3]
["Corhrs","Course hours per week",4,"The cost of each course in hours per week."]
["minsleep","Minimum hours of sleep, eat & commute before protection penalty",6]
["maxstudy","Maximum number of hours that study is useful per course credit",3]
["maxdev","Developmental Courses Needed Max",7]
[null,"High School Performance Min",0]
["minprot","Minimum Protection Points",{"$f":"((maxdev-C14)*devfac+C15*hsgrdfac)+1","v":1}]
["maxprot","Maximum Protection points",{"$f":"maxdev*devfac+4*hsgrdfac+2+12*(maxsup*Supfac)+maxstudy*gradcred*Grdfac+gradcred*credfac","v":2168},{"$f":"hsgrdfac","v":6}]
[null,"Sleep min.",0]
["maxsup","Support activities, max.",10]
[null,"Good grades, max.",1]
[null,"Courses, max.",8]
["sleepfac","The impact on points for each hour of sleep below minimum.",1]
["devfac","The weight per dev course needed in negative protection points",6]
["hsgrdfac","The weight per point in high school grade point to give to protection",6]
["profac","protection curve exponential factor",0.25]
[1,"Continue"]
[2,"Early Transfer"]
[3,"Drop Out"]
[4,"Graduation"]
["somecol","Annual earnings, some college",46168,{"$f":"somecol*career","v":1985224},"*"]
["aa","Annual earnings, associate's",48534,{"$f":"aa*career","v":2086962},"*"]
["ba","Annual earnings, BA",71044,{"$f":"ba*career","v":3054892},"*"]
["aatran","Prob of AA grad transferring",0.55000000000000004]
["aabagrad","Prob of AA grad transfer grad BA",0.54]
["earlybagrad","Prob of early transfer grad BA",{"$f":"C34*(1-0.12)","v":0.47520000000000001}]
["gradyrba","Number of years to BA degree post grd",3]
["tranyrba","Number of years to BA degree early trn",4]
["career","Number of earning years at entry",43]
[null,null,null,"Fun is the number of hours remaining in the week after all else is deducted. If it is negative, an error occurs."]
[null,null,null,"Each developmental course adds three credits toward graduation (by starting the accumulation in the negative.)"]
[null,null,null,"The probability of leaving does not increase after the semester when the student might have graduated."]
["Party","Hours spent in one night's partying",6]
[]
[null,"*Source: Bureau of the Census; Bureau of Labor Statistics"]
[null,"http://www.census.gov/hhes/cpstables/032009/perinc/new03-010.htm"]