{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Program Information","Tuition","Textbook","Monthly","Milestone","Success Coaching-Advising","Other","Summary Report","Annual Costs","Links","DataValidation"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":130,"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":"Program Information","index":0,"n_rows":34,"n_cols":10,"rows_kept":34,"cut":false,"hidden":false,"merged":[[31,6,31,8],[29,6,29,8]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Students served per cohort ",500,null,"Program length (years)",null,null,3]
[]
[null,null,null,"Year 2 retention rate",0.6,null,"Year 3 retention rate",null,null,0.5]
[]
[null,null,null,"Summer enrollment rate",0.2]

{"sheet":"Tuition","index":1,"n_rows":27,"n_cols":5,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,null,null,"Students served",{"$f":"'Program Information'!E30","v":500}]
[]
[null,null,null,"Avg. tuition coverage per semester ($)",1250]
[]
[null,null,null,"Fees covered?","Yes"]
[]
[null,null,null,"Average semester fees ($)",250]
[]
[null,null,null,"Summer coverage offered?","Yes"]
[]
[null,null,null,"Summer enrollment rate",{"$f":"'Program Information'!E34","v":0.2}]
[]
[null,null,null,"Avg. summer tuition coverage ($)",1250]
[]
[null,null,null,"First-year total tuition coverage cost",{"$f":"IF(FeesCovered=\"Yes\",IF(SummerCoverage2=\"Yes\",((StudentsServed2*Tuition)*2)+(SummerEnroll*StudentsServed2*SummerTuition)+((StudentsServed2*Fees)*2)+(StudentsServed2*SummerEnroll*Fees),((StudentsServed2*Tuition)*2)+((StudentsServed2*Fees)*2)),IF(SummerCoverage2=\"Yes\",((StudentsServed2*Tuition)*2)+(SummerEnroll*StudentsServed2*SummerTuition),((StudentsServed2*Tuition)*2)))","v":1650000}]
[]
[null,null,null,"Year 2 retention rate",{"$f":"IF(OR('Program Information'!J30=2,'Program Information'!J30=3),'Program Information'!E32,\"1-Year Program\")","v":0.6}]
[]
[null,null,null,"Year 3 retention rate",{"$f":"IF('Program Information'!J30=3,'Program Information'!J32,IF('Program Information'!J30=2,\"2-Year Program\",\"1-Year Program\"))","v":0.5}]
[]
[null,null,null,{"$f":"\"Total tuition coverage cost (\"&'Program Information'!J30&IF('Program Information'!J30=1,\" year)\",\" years)\")","v":"Total tuition coverage cost (3 years)"},{"$f":"'Annual Costs'!B6","v":3465000}]

{"sheet":"Textbook","index":2,"n_rows":23,"n_cols":5,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,null,null,"Students served",{"$f":"'Program Information'!E30","v":500}]
[]
[null,null,null,"Textbook stipend per semester ($)",400]
[]
[null,null,null,"Summer textbook coverage offered?","Yes"]
[]
[null,null,null,"Summer enrollment rate",{"$f":"'Program Information'!E34","v":0.2}]
[]
[null,null,null,"Summer textbook stipend ($)",200]
[]
[null,null,null,"First-year total textbook stipend cost",{"$f":"IF(SummerCoverage=\"Yes\",((StudentsServed*SemBookCost)*2)+(SummerBookCost*StudentsServed*SummerEnrollText),(StudentsServed*SemBookCost*2))","v":420000}]
[]
[null,null,null,"Year 2 retention rate",{"$f":"IF(OR('Program Information'!J30=2,'Program Information'!J30=3),'Program Information'!E32,\"1-Year Program\")","v":0.6}]
[]
[null,null,null,"Year 3 retention rate",{"$f":"IF('Program Information'!J30=3,'Program Information'!J32,IF('Program Information'!J30=2,\"2-Year Program\",\"1-Year Program\"))","v":0.5}]
[]
[null,null,null,{"$f":"\"Total textbook stipend cost (\"&'Program Information'!J30&IF('Program Information'!J30=1,\" year)\",\" years)\")","v":"Total textbook stipend cost (3 years)"},{"$f":"'Annual Costs'!C6","v":882000}]

{"sheet":"Monthly","index":3,"n_rows":26,"n_cols":5,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,null,null,"Students served",{"$f":"'Program Information'!E30","v":500}]
[]
[null,null,null,"Monthly incentive value ($)",50]
[]
[null,null,null,"Monthly incentive take-up rate",0.7]
[]
[null,null,null,"Monthly incentive cost",{"$f":"StudentsServed*PctIncentive*IncentiveValue","v":17500}]
[]
[null,null,null,"Summer incentive offered?","Yes"]
[]
[null,null,null,"Summer enrollment rate",{"$f":"'Program Information'!E34","v":0.2}]
[]
[null,null,null,"Summer incentive take-up rate",0.4]
[]
[null,null,null,"First-year monthly incentive cost",{"$f":"IF(SummerCoverage=\"Yes\",(StudentsServed*PctIncentive*IncentiveValue*8)+(StudentsServed*SummerEnrollMonth*SumPctIncentive*IncentiveValue*3),(StudentsServed*PctIncentive*IncentiveValue*8))","v":146000}]
[]
[null,null,null,"Year 2 retention rate",{"$f":"IF(OR('Program Information'!J30=2,'Program Information'!J30=3),'Program Information'!E32,\"1-Year Program\")","v":0.6}]
[]
[null,null,null,"Year 3 retention rate",{"$f":"IF('Program Information'!J30=3,'Program Information'!J32,IF('Program Information'!J30=2,\"2-Year Program\",\"1-Year Program\"))","v":0.5}]
[]
[null,null,null,{"$f":"\"Total monthly incentive cost (\"&'Program Information'!J30&IF('Program Information'!J30=1,\" year)\",\" years)\")","v":"Total monthly incentive cost (3 years)"},{"$f":"'Annual Costs'!D6","v":306600}]

{"sheet":"Milestone","index":4,"n_rows":33,"n_cols":11,"rows_kept":33,"cut":false,"hidden":false,"merged":[[8,4,12,4],[14,4,16,4],[18,4,20,4],[22,4,24,4],[26,4,28,4],[8,3,12,3],[14,3,16,3],[18,3,20,3],[22,3,24,3],[26,3,28,3],[30,5,30,6],[32,5,32,6],[8,5,12,5],[14,5,16,5],[18,5,20,5],[22,5,24,5],[26,5,28,5],[8,6,9,6],[10,6,11,6]]}
[]
[]
[]
[]
[]
[]
[null,null,null,"Milestone #","Description","Milestone year",null,"Cost Estimate"]
[]
[null,null,null,1,"(Fill in description)",1,"Incentive ($)",0,null,"Students served",{"$f":"'Program Information'!E30","v":500}]
[]
[null,null,null,null,null,null,"Percentage completed",1,null,"Year 2 retention rate",{"$f":"IF(OR('Program Information'!J30=2,'Program Information'!J30=3),'Program Information'!E32,\"1-Year Program\")","v":0.6}]
[]
[null,null,null,null,null,null,"Milestone #1 Cost",{"$f":"IF(OR(MlstnYr1=1,MlstnYr1=\"Annual\"),MlstnStudents*Mlstn1Cost*Mlstn1Pct,IF(AND(MlstnYr1=2,'Program Information'!J30>=2),MlstnStudents*Yr2RetRate*Mlstn1Cost*Mlstn1Pct,IF(AND(MlstnYr1=3,'Program Information'!J30=3),MlstnStudents*Yr3RetRate*Mlstn1Cost*Mlstn1Pct,\"NA\")))","v":0},null,"Year 3 retention rate",{"$f":"IF('Program Information'!J30=3,'Program Information'!J32,IF('Program Information'!J30=2,\"2-Year Program\",\"1-Year Program\"))","v":0.5}]
[]
[null,null,null,2,"(Fill in description)","Annual","Incentive ($)",0]
[null,null,null,null,null,null,"Percentage completed",1]
[null,null,null,null,null,null,"Milestone #2 Cost",{"$f":"IF(OR(MlstnYr2=1,MlstnYr2=\"Annual\"),MlstnStudents*Mlstn2Cost*Mlstn2Pct,IF(AND(MlstnYr2=2,'Program Information'!J30>=2),MlstnStudents*Yr2RetRate*Mlstn2Cost*Mlstn2Pct,IF(AND(MlstnYr2=3,'Program Information'!J30=3),MlstnStudents*Yr3RetRate*Mlstn2Cost*Mlstn2Pct,\"NA\")))","v":0}]
[]
[null,null,null,3,"(Fill in description)",2,"Incentive ($)",0]
[null,null,null,null,null,null,"Percentage completed",1]
[null,null,null,null,null,null,"Milestone #3 Cost",{"$f":"IF(OR(MlstnYr3=1,MlstnYr3=\"Annual\"),MlstnStudents*Mlstn3Cost*Mlstn3Pct,IF(AND(MlstnYr3=2,'Program Information'!J30>=2),MlstnStudents*Yr2RetRate*Mlstn3Cost*Mlstn3Pct,IF(AND(MlstnYr3=3,'Program Information'!J30=3),MlstnStudents*Yr3RetRate*Mlstn3Cost*Mlstn3Pct,\"NA\")))","v":0}]
[]
[null,null,null,4,"(Fill in description)",3,"Incentive ($)",0]
[null,null,null,null,null,null,"Percentage completed",1]
[null,null,null,null,null,null,"Milestone #4 Cost",{"$f":"IF(OR(MlstnYr4=1,MlstnYr4=\"Annual\"),MlstnStudents*Mlstn4Cost*Mlstn4Pct,IF(AND(MlstnYr4=2,'Program Information'!J30>=2),MlstnStudents*Yr2RetRate*Mlstn4Cost*Mlstn4Pct,IF(AND(MlstnYr4=3,'Program Information'!J30=3),MlstnStudents*Yr3RetRate*Mlstn4Cost*Mlstn4Pct,\"NA\")))","v":0}]
[]
[null,null,null,5,"(Fill in description)",3,"Incentive ($)",0]
[null,null,null,null,null,null,"Percentage completed",1]
[null,null,null,null,null,null,"Milestone #5 Cost",{"$f":"IF(OR(MlstnYr5=1,MlstnYr5=\"Annual\"),MlstnStudents*Mlstn5Cost*Mlstn5Pct,IF(AND(MlstnYr5=2,'Program Information'!J30>=2),MlstnStudents*Yr2RetRate*Mlstn5Cost*Mlstn5Pct,IF(AND(MlstnYr5=3,'Program Information'!J30=3),MlstnStudents*Yr3RetRate*Mlstn5Cost*Mlstn5Pct,\"NA\")))","v":0}]
[]
[null,null,null,null,null,"First-year milestone incentive cost",null,{"$f":"SUM(IF(OR(MlstnYr1=1,MlstnYr1=\"Annual\"),Mlstn1Total,0),IF(OR(MlstnYr2=1,MlstnYr2=\"Annual\"),Mlstn2Total,0),IF(OR(MlstnYr3=1,MlstnYr3=\"Annual\"),Mlstn3Total,0),IF(OR(MlstnYr4=1,MlstnYr4=\"Annual\"),Mlstn4Total,0),IF(OR(MlstnYr5=1,MlstnYr5=\"Annual\"),Mlstn5Total,0))","v":0}]
[]
[null,null,null,null,null,{"$f":"\"Total milestone incentive cost (\"&'Program Information'!J30&IF('Program Information'!J30=1,\" year)\",\" years)\")","v":"Total milestone incentive cost (3 years)"},null,{"$f":"'Annual Costs'!E6","v":0}]

{"sheet":"Success Coaching-Advising","index":5,"n_rows":30,"n_cols":5,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,null,null,"Students served",{"$f":"'Program Information'!E30","v":500}]
[]
[null,null,null,"Coach/adviser-to-student ratio","1 : 200"]
[]
[null,null,null,"Avg. coach/adviser salary",40000]
[]
[null,null,null,"Avg. coach/adviser emp. benefit pct.",0.2]
[]
[null,null,null,"First-year coaches/advisers required",{"$f":"ROUNDUP(StudentsServed/VALUE(RIGHT(CoachRatio,3)),0)","v":3}]
[]
[null,null,null,"First-year coaches/advisers cost",{"$f":"FirstYrCoach*(CoachSalary+(CoachSalary*CoachBenefit))","v":144000}]
[]
[null,null,null,"Year 2 retention rate",{"$f":"IF(OR('Program Information'!J30=2,'Program Information'!J30=3),'Program Information'!E32,\"1-Year Program\")","v":0.6}]
[]
[null,null,null,"Second-year coaches/advisers required",{"$f":"IF('Program Information'!J30=1,\"1-Year Program\",ROUNDUP((StudentsServed*Yr2RetRt)/VALUE(RIGHT(CoachRatio,3)),0))","v":2}]
[]
[null,null,null,"Second-year coaches/advisers cost",{"$f":"IF('Program Information'!J30=1,\"1-Year Program\",SecondYrCoach*(CoachSalary+(CoachSalary*CoachBenefit)))","v":96000}]
[]
[null,null,null,"Year 3 retention rate",{"$f":"IF('Program Information'!J30=3,'Program Information'!J32,IF('Program Information'!J30=2,\"2-Year Program\",\"1-Year Program\"))","v":0.5}]
[]
[null,null,null,"Third-year coaches/advisers required",{"$f":"IF('Program Information'!J30=1,\"1-Year Program\",IF('Program Information'!J30=2,\"2-Year Program\",ROUNDUP((StudentsServed*Yr3RetRt)/VALUE(RIGHT(CoachRatio,3)),0)))","v":2}]
[]
[null,null,null,"Third-year coaches/advisers cost",{"$f":"IF('Program Information'!J30=1,\"1-Year Program\",IF('Program Information'!J30=2,\"2-Year Program\",ThirdYrCoach*(CoachSalary+(CoachSalary*CoachBenefit))))","v":96000}]
[]
[null,null,null,{"$f":"\"Total coaches/advisers cost (\"&'Program Information'!J30&IF('Program Information'!J30=1,\" year)\",\" years)\")","v":"Total coaches/advisers cost (3 years)"},{"$f":"'Annual Costs'!F6","v":336000}]

{"sheet":"Other","index":6,"n_rows":33,"n_cols":11,"rows_kept":33,"cut":false,"hidden":false,"merged":[[8,6,9,6],[10,6,11,6],[18,3,20,3],[18,4,20,4],[18,5,20,5],[14,3,16,3],[14,4,16,4],[14,5,16,5],[8,3,12,3],[8,4,12,4],[8,5,12,5],[30,5,30,6],[32,5,32,6],[22,3,24,3],[22,4,24,4],[22,5,24,5],[26,3,28,3],[26,4,28,4],[26,5,28,5]]}
[]
[]
[]
[]
[]
[]
[null,null,null,"Cost #","Description","Cost Year",null,"Cost Estimate"]
[]
[null,null,null,1,"(Fill in description)","Annual","Cost type","Per Student",null,"Students served",{"$f":"'Program Information'!E30","v":500}]
[]
[null,null,null,null,null,null,"Cost amount",0,null,"Year 2 retention rate",{"$f":"IF(OR('Program Information'!J30=2,'Program Information'!J30=3),'Program Information'!E32,\"1-Year Program\")","v":0.6}]
[]
[null,null,null,null,null,null,"Other Cost #1",{"$f":"IF(Other1Type=\"Total\",IF(OR(OtherYr1=1,OtherYr1=\"Annual\"),Other1Amt,IF(AND(OtherYr1=2,'Program Information'!J30>=2),Other1Amt,IF(AND(OtherYr1=3,'Program Information'!J30=3),Other1Amt,\"N/A\"))),IF(OR(OtherYr1=1,OtherYr1=\"Annual\"),(Other1Amt*OtherStudents),IF(AND(OtherYr1=2,'Program Information'!J30>=2),(OtherStudents*Yr2RetRate*Other1Amt),IF(AND(OtherYr1=3,'Program Information'!J30=3),(OtherStudents*Yr3RetRate*Other1Amt),\"N/A\"))))","v":0},null,"Year 3 retention rate",{"$f":"IF('Program Information'!J30=3,'Program Information'!J32,IF('Program Information'!J30=2,\"2-Year Program\",\"1-Year Program\"))","v":0.5}]
[]
[null,null,null,2,"(Fill in description)","Annual","Cost type","Total"]
[null,null,null,null,null,null,"Cost amount",0]
[null,null,null,null,null,null,"Other Cost #2",{"$f":"IF(Other2Type=\"Total\",IF(OR(OtherYr2=1,OtherYr2=\"Annual\"),Other2Cost,IF(AND(OtherYr2=2,'Program Information'!J30>=2),Other2Cost,IF(AND(OtherYr2=3,'Program Information'!J30=3),Other2Cost,\"N/A\"))),IF(OR(OtherYr2=1,OtherYr2=\"Annual\"),(Other2Cost*OtherStudents),IF(AND(OtherYr2=2,'Program Information'!J30>=2),(OtherStudents*Yr2RetRate*Other2Cost),IF(AND(OtherYr2=3,'Program Information'!J30=3),(OtherStudents*Yr3RetRate*Other2Cost),\"N/A\"))))","v":0}]
[]
[null,null,null,3,"(Fill in description)",2,"Cost type","Total"]
[null,null,null,null,null,null,"Cost amount",0]
[null,null,null,null,null,null,"Other Cost #3",{"$f":"IF(Other3Type=\"Total\",IF(OR(OtherYr3=1,OtherYr3=\"Annual\"),Other3Cost,IF(AND(OtherYr3=2,'Program Information'!J30>=2),Other3Cost,IF(AND(OtherYr3=3,'Program Information'!J30=3),Other3Cost,\"N/A\"))),IF(OR(OtherYr3=1,OtherYr3=\"Annual\"),(Other3Cost*OtherStudents),IF(AND(OtherYr3=2,'Program Information'!J30>=2),(OtherStudents*Yr2RetRate*Other3Cost),IF(AND(OtherYr3=3,'Program Information'!J30=3),(OtherStudents*Yr3RetRate*Other3Cost),\"N/A\"))))","v":0}]
[]
[null,null,null,4,"(Fill in description)",3,"Cost type","Per Student"]
[null,null,null,null,null,null,"Cost amount",0]
[null,null,null,null,null,null,"Other Cost #4",{"$f":"IF(Other4Type=\"Total\",IF(OR(OtherYr4=1,OtherYr4=\"Annual\"),Other4Cost,IF(AND(OtherYr4=2,'Program Information'!J30>=2),Other4Cost,IF(AND(OtherYr4=3,'Program Information'!J30=3),Other4Cost,\"N/A\"))),IF(OR(OtherYr4=1,OtherYr4=\"Annual\"),(Other4Cost*OtherStudents),IF(AND(OtherYr4=2,'Program Information'!J30>=2),(OtherStudents*Yr2RetRate*Other4Cost),IF(AND(OtherYr4=3,'Program Information'!J30=3),(OtherStudents*Yr3RetRate*Other4Cost),\"N/A\"))))","v":0}]
[]
[null,null,null,5,"(Fill in description)",3,"Cost type","Total"]
[null,null,null,null,null,null,"Cost amount",0]
[null,null,null,null,null,null,"Other Cost #5",{"$f":"IF(Other5Type=\"Total\",IF(OR(OtherYr5=1,OtherYr5=\"Annual\"),Other5Cost,IF(AND(OtherYr5=2,'Program Information'!J30>=2),Other5Cost,IF(AND(OtherYr5=3,'Program Information'!J30=3),Other5Cost,\"N/A\"))),IF(OR(OtherYr5=1,OtherYr5=\"Annual\"),(Other5Cost*OtherStudents),IF(AND(OtherYr5=2,'Program Information'!J30>=2),(OtherStudents*Yr2RetRate*Other5Cost),IF(AND(OtherYr5=3,'Program Information'!J30=3),(OtherStudents*Yr3RetRate*Other5Cost),\"N/A\"))))","v":0}]
[]
[null,null,null,null,null,"First-year other cost",null,{"$f":"SUM(IF(OR(OtherYr1=1,OtherYr1=\"Annual\"),Other1Total,0),IF(OR(OtherYr2=1,OtherYr2=\"Annual\"),Other2Total,0),IF(OR(OtherYr3=1,OtherYr3=\"Annual\"),Other3Total,0),IF(OR(OtherYr4=1,OtherYr4=\"Annual\"),Other4Total,0),IF(OR(OtherYr5=1,OtherYr5=\"Annual\"),Other5Total,0))","v":0}]
[]
[null,null,null,null,null,{"$f":"\"Total other cost (\"&'Program Information'!J30&IF('Program Information'!J30=1,\" year)\",\" years)\")","v":"Total other cost (3 years)"},null,{"$f":"'Annual Costs'!G6","v":0}]

{"sheet":"Summary Report","index":7,"n_rows":46,"n_cols":11,"rows_kept":46,"cut":false,"hidden":false,"merged":[[45,3,45,7],[27,3,27,4],[27,6,27,7],[2,9,3,12],[9,3,9,7],[11,3,11,4],[11,6,11,7],[43,3,43,7]]}
[]
[]
[null,null,null,null,null,null,null,null,null,"Change Students Served"]
[]
[]
[null,null,null,"Students served",{"$f":"'Program Information'!E30","v":500},null,"Year 2 retention rate",{"$f":"IF(OR('Program Information'!J30=2,'Program Information'!J30=3),'Program Information'!E32,\"1-Year Program\")","v":0.6}]
[]
[null,null,null,null,null,null,"Year 3 retention rate",{"$f":"IF('Program Information'!J30=3,'Program Information'!J32,IF('Program Information'!J30=2,\"2-Year Program\",\"1-Year Program\"))","v":0.5}]
[]
[null,null,null,"Program Costs",null,null,null,null,null,"Students served per cohort ",500]
[]
[null,null,null,"First Year Costs",null,null,"Second Year Costs"]
[]
[null,null,null,"Tuition coverage",{"$f":"IF(Links!B1=TRUE,'Annual Costs'!B3,\"Not Selected\")","v":1650000},null,"Tuition coverage",{"$f":"IF(Links!B1=TRUE,IF('Program Information'!J30=1,\"1-Year Program\",'Annual Costs'!B4),\"Not Selected\")","v":990000}]
[]
[null,null,null,"Textbook stipend",{"$f":"IF(Links!B2=FALSE, \"Not Selected\",'Annual Costs'!C3)","v":420000},null,"Textbook stipend",{"$f":"IF(Links!B2=TRUE,IF('Program Information'!J30=1,\"1-Year Program\",'Annual Costs'!C4),\"Not Selected\")","v":252000}]
[]
[null,null,null,"Monthly incentive",{"$f":"IF(Links!B3=FALSE, \"Not Selected\",'Annual Costs'!D3)","v":146000},null,"Monthly incentive",{"$f":"IF(Links!B3=TRUE,IF('Program Information'!J30=1,\"1-Year Program\",'Annual Costs'!D4), \"Not Selected\")","v":87600}]
[]
[null,null,null,"Milestone incentive",{"$f":"IF(Links!B4=FALSE, \"Not Selected\", 'Annual Costs'!E3)","v":0},null,"Milestone incentive",{"$f":"IF(Links!B4=TRUE, IF('Program Information'!J30=1,\"1-Year Program\",'Annual Costs'!E4), \"Not Selected\")","v":0}]
[]
[null,null,null,"Coach/adviser(s)",{"$f":"IF(Links!B5=FALSE, \"Not Selected\",'Annual Costs'!F3)","v":144000},null,"Coach/adviser(s)",{"$f":"IF(Links!B5=TRUE,IF('Program Information'!J30=1,\"1-Year Program\",'Annual Costs'!F4), \"Not Selected\")","v":96000}]
[]
[null,null,null,"Other costs",{"$f":"'Annual Costs'!G3","v":0},null,"Other costs",{"$f":"IF('Program Information'!J30=1,\"1-Year Program\",'Annual Costs'!G4)","v":0}]
[]
[null,null,null,"First-year total",{"$f":"SUM(E14,E16,E18,E20,E22,E24)","v":2360000},null,"Second-year total",{"$f":"IF('Program Information'!J30=1,\"1-Year Program\",SUM(H14,H16,H18,H20,H22,H24))","v":1425600}]
[]
[null,null,null,"Third Year Costs",null,null,"Total Program Cost"]
[]
[null,null,null,"Tuition coverage",{"$f":"IF(Links!B1=TRUE,IF('Program Information'!J30=1,\"1-Year Program\",IF('Program Information'!J30=2,\"2-Year Program\",'Annual Costs'!B5)),\"Not Selected\")","v":825000},null,"Tuition coverage",{"$f":"IF(Links!B1=TRUE,'Annual Costs'!B6,\"Not Selected\")","v":3465000}]
[]
[null,null,null,"Textbook stipend",{"$f":"IF(Links!B2=TRUE,IF('Program Information'!J30=1,\"1-Year Program\",IF('Program Information'!J30=2,\"2-Year Program\",'Annual Costs'!C5)), \"Not Selected\")","v":210000},null,"Textbook stipend",{"$f":"IF(Links!B2=FALSE, \"Not Selected\",'Annual Costs'!C6)","v":882000}]
[]
[null,null,null,"Monthly incentive",{"$f":"IF(Links!B3=TRUE,IF('Program Information'!J30=1,\"1-Year Program\",IF('Program Information'!J30=2,\"2-Year Program\",'Annual Costs'!D5)), \"Not Selected\")","v":73000},null,"Monthly incentive",{"$f":"IF(Links!B3=FALSE, \"Not Selected\",'Annual Costs'!D6)","v":306600}]
[]
[null,null,null,"Milestone incentive",{"$f":"IF(Links!B4=TRUE,IF('Program Information'!J30=1,\"1-Year Program\",IF('Program Information'!J30=2,\"2-Year Program\", 'Annual Costs'!E5)), \"Not Selected\")","v":0},null,"Milestone incentive",{"$f":"IF(Links!B4=FALSE, \"Not Selected\", 'Annual Costs'!E6)","v":0}]
[]
[null,null,null,"Coach/adviser(s)",{"$f":"IF(Links!B5=TRUE,IF('Program Information'!J30=1,\"1-Year Program\",IF('Program Information'!J30=2,\"2-Year Program\",'Annual Costs'!F5)), \"Not Selected\")","v":96000},null,"Coach/adviser(s)",{"$f":"IF(Links!B5=FALSE, \"Not Selected\",'Annual Costs'!F6)","v":336000}]
[]
[null,null,null,"Other costs",{"$f":"IF('Program Information'!J30=1,\"1-Year Program\",IF('Program Information'!J30=2,\"2-Year Program\",'Annual Costs'!G5))","v":0},null,"Other costs",{"$f":"'Annual Costs'!G6","v":0}]
[]
[null,null,null,"Third-year total",{"$f":"IF('Program Information'!J30=1,\"1-Year Program\",IF('Program Information'!J30=2,\"2-Year Program\",SUM(E30,E32,E34,E36,E38,E40)))","v":1204000},null,"Total program cost",{"$f":"SUM(H30,H32,H34,H36,H38,H40)","v":4989600}]
[]
[null,null,null,"Comments"]
[]
[null,null,null,"(Type comments here)"]

{"sheet":"Annual Costs","index":8,"n_rows":6,"n_cols":7,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Tuition","Textbook","Monthly","Milestone","Coaching","Other"]
["Year 1",{"$f":"IF(FeesCovered=\"Yes\",IF(SummerCoverage2=\"Yes\",((StudentsServed2*Tuition)*2)+(SummerEnroll*StudentsServed2*SummerTuition)+((StudentsServed2*Fees)*2)+(StudentsServed2*SummerEnroll*Fees),((StudentsServed2*Tuition)*2)+((StudentsServed2*Fees)*2)),IF(SummerCoverage2=\"Yes\",((StudentsServed2*Tuition)*2)+(SummerEnroll*StudentsServed2*SummerTuition),((StudentsServed2*Tuition)*2)))","v":1650000},{"$f":"IF(Textbook!SummerCoverage=\"Yes\",((Textbook!StudentsServed*SemBookCost)*2)+(SummerBookCost*Textbook!StudentsServed*SummerEnrollText),(Textbook!StudentsServed*SemBookCost*2))","v":420000},{"$f":"IF(Monthly!SummerCoverage=\"Yes\",(Monthly!StudentsServed*PctIncentive*IncentiveValue*8)+(Monthly!StudentsServed*SummerEnrollMonth*SumPctIncentive*IncentiveValue*3),(Monthly!StudentsServed*PctIncentive*IncentiveValue*8))","v":146000},{"$f":"SUM(IF(OR(MlstnYr1=1,MlstnYr1=\"Annual\"),Mlstn1Total,0),IF(OR(MlstnYr2=1,MlstnYr2=\"Annual\"),Mlstn2Total,0),IF(OR(MlstnYr3=1,MlstnYr3=\"Annual\"),Mlstn3Total,0),IF(OR(MlstnYr4=1,MlstnYr4=\"Annual\"),Mlstn4Total,0),IF(OR(MlstnYr5=1,MlstnYr5=\"Annual\"),Mlstn5Total,0))","v":0},{"$f":"'Success Coaching-Advising'!E16","v":144000},{"$f":"SUM(IF(OR(Other!OtherYr1=1,Other!OtherYr1=\"Annual\"),Other!Other1Total,0),IF(OR(Other!OtherYr2=1,Other!OtherYr2=\"Annual\"),Other!Other2Total,0),IF(OR(Other!OtherYr3=1,Other!OtherYr3=\"Annual\"),Other!Other3Total,0),IF(OR(Other!OtherYr4=1,Other!OtherYr4=\"Annual\"),Other!Other4Total,0),IF(OR(Other!OtherYr5=1,Other!OtherYr5=\"Annual\"),Other!Other5Total,0))","v":0}]
["Year 2",{"$f":"IF(FeesCovered=\"Yes\",IF(SummerCoverage2=\"Yes\",(((StudentsServed2*Year2RetRate)*Tuition)*2)+(SummerEnroll*(StudentsServed2*Year2RetRate)*SummerTuition)+(((StudentsServed2*Year2RetRate)*Fees)*2)+((StudentsServed2*Year2RetRate)*SummerEnroll*Fees),(((StudentsServed2*Year2RetRate)*Tuition)*2)+(((StudentsServed2*Year2RetRate)*Fees)*2)),IF(SummerCoverage2=\"Yes\",(((StudentsServed2*Year2RetRate)*Tuition)*2)+(SummerEnroll*(StudentsServed2*Year2RetRate)*SummerTuition),(((StudentsServed2*Year2RetRate)*Tuition)*2)))","v":990000},{"$f":"IF(Textbook!SummerCoverage=\"Yes\",(((Textbook!StudentsServed*Year2RetRate)*SemBookCost)*2)+(SummerBookCost*(Textbook!StudentsServed*Year2RetRate*SummerEnrollText)),((Textbook!StudentsServed*Year2RetRate)*SemBookCost*2))","v":252000},{"$f":"IF(Monthly!SummerCoverage=\"Yes\",((Monthly!StudentsServed*Year2RetRate)*PctIncentive*IncentiveValue*8)+((Monthly!StudentsServed*Year2RetRate*SummerEnrollMonth)*SumPctIncentive*IncentiveValue*3),((Monthly!StudentsServed*Year2RetRate)*PctIncentive*IncentiveValue*8))","v":87600},{"$f":"SUM(IF(MlstnYr1=\"Annual\",(Mlstn1Total*Year2RetRate),IF(MlstnYr1=2,Mlstn1Total,0)),IF(MlstnYr2=\"Annual\",(Mlstn2Total*Year2RetRate),IF(MlstnYr2=2,Mlstn2Total,0)),IF(MlstnYr3=\"Annual\",(Mlstn3Total*Year2RetRate),IF(MlstnYr3=2,Mlstn3Total,0)),IF(MlstnYr4=\"Annual\",(Mlstn4Total*Year2RetRate),IF(MlstnYr4=2,Mlstn4Total,0)),IF(MlstnYr5=\"Annual\",(Mlstn5Total*Year2RetRate),IF(MlstnYr5=2,Mlstn5Total,0)))","v":0},{"$f":"'Success Coaching-Advising'!E22","v":96000},{"$f":"SUM(IF(Other!OtherYr1=\"Annual\",IF(Other!Other1Type=\"Total\",Other!Other1Amt,(Other!Other1Total*Year2RetRate)),IF(Other!OtherYr1=2,Other!Other1Total,0)),IF(Other!OtherYr2=\"Annual\",IF(Other!Other2Type=\"Total\",Other!Other2Cost,(Other!Other2Total*Year2RetRate)),IF(Other!OtherYr2=2,Other!Other2Total,0)),IF(Other!OtherYr3=\"Annual\",IF(Other!Other3Type=\"Total\",Other!Other3Cost,(Other!Other3Total*Year2RetRate)),IF(Other!OtherYr3=2,Other!Other3Total,0)),IF(Other!OtherYr4=\"Annual\",IF(Other!Other4Type=\"Total\",Other!Other4Cost,(Other!Other4Total*Year2RetRate)),IF(Other!OtherYr4=2,Other!Other4Total,0)),IF(Other!OtherYr5=\"Annual\",IF(Other!Other5Type=\"Total\",Other!Other5Cost,(Other!Other5Total*Year2RetRate)),IF(Other!OtherYr5=2,Other!Other5Total,0)))","v":0}]
["Year 3",{"$f":"IF(FeesCovered=\"Yes\",IF(SummerCoverage2=\"Yes\",(((StudentsServed2*Year3RetRate)*Tuition)*2)+(SummerEnroll*(StudentsServed2*Year3RetRate)*SummerTuition)+(((StudentsServed2*Year3RetRate)*Fees)*2)+((StudentsServed2*Year3RetRate)*SummerEnroll*Fees),(((StudentsServed2*Year3RetRate)*Tuition)*2)+(((StudentsServed2*Year3RetRate)*Fees)*2)),IF(SummerCoverage2=\"Yes\",(((StudentsServed2*Year3RetRate)*Tuition)*2)+(SummerEnroll*(StudentsServed2*Year3RetRate)*SummerTuition),(((StudentsServed2*Year3RetRate)*Tuition)*2)))","v":825000},{"$f":"IF(Textbook!SummerCoverage=\"Yes\",(((Textbook!StudentsServed*Year3RetRate)*SemBookCost)*2)+(SummerBookCost*(Textbook!StudentsServed*Year3RetRate*SummerEnrollText)),((Textbook!StudentsServed*Year3RetRate)*SemBookCost*2))","v":210000},{"$f":"IF(Monthly!SummerCoverage=\"Yes\",((Monthly!StudentsServed*Year3RetRate)*PctIncentive*IncentiveValue*8)+((Monthly!StudentsServed*Year3RetRate*SummerEnrollMonth)*SumPctIncentive*IncentiveValue*3),((Monthly!StudentsServed*Year3RetRate)*PctIncentive*IncentiveValue*8))","v":73000},{"$f":"SUM(IF(MlstnYr1=\"Annual\",(Mlstn1Total*Year3RetRate),IF(MlstnYr1=3,Mlstn1Total,0)),IF(MlstnYr2=\"Annual\",(Mlstn2Total*Year3RetRate),IF(MlstnYr2=3,Mlstn2Total,0)),IF(MlstnYr3=\"Annual\",(Mlstn3Total*Year3RetRate),IF(MlstnYr3=3,Mlstn3Total,0)),IF(MlstnYr4=\"Annual\",(Mlstn4Total*Year3RetRate),IF(MlstnYr4=3,Mlstn4Total,0)),IF(MlstnYr5=\"Annual\",(Mlstn5Total*Year3RetRate),IF(MlstnYr5=3,Mlstn5Total,0)))","v":0},{"$f":"'Success Coaching-Advising'!E28","v":96000},{"$f":"SUM(IF(Other!OtherYr1=\"Annual\",IF(Other!Other1Type=\"Total\",Other!Other1Amt,(Other!Other1Total*Year3RetRate)),IF(Other!OtherYr1=3,Other!Other1Total,0)),IF(Other!OtherYr2=\"Annual\",IF(Other!Other2Type=\"Total\",Other!Other2Cost,(Other!Other2Total*Year3RetRate)),IF(Other!OtherYr2=3,Other!Other2Total,0)),IF(Other!OtherYr3=\"Annual\",IF(Other!Other3Type=\"Total\",Other!Other3Cost,(Other!Other3Total*Year3RetRate)),IF(Other!OtherYr3=3,Other!Other3Total,0)),IF(Other!OtherYr4=\"Annual\",IF(Other!Other4Type=\"Total\",Other!Other4Cost,(Other!Other4Total*Year3RetRate)),IF(Other!OtherYr4=3,Other!Other4Total,0)),IF(Other!OtherYr5=\"Annual\",IF(Other!Other5Type=\"Total\",Other!Other5Cost,(Other!Other5Total*Year3RetRate)),IF(Other!OtherYr5=3,Other!Other5Total,0)))","v":0}]
["Total",{"$f":"IF('Program Information'!$J30=1,B3,IF('Program Information'!$J30=2,SUM(B3,B4),SUM(B3,B4,B5)))","v":3465000},{"$f":"IF('Program Information'!$J30=1,C3,IF('Program Information'!$J30=2,SUM(C3,C4),SUM(C3,C4,C5)))","v":882000},{"$f":"IF('Program Information'!$J30=1,D3,IF('Program Information'!$J30=2,SUM(D3,D4),SUM(D3,D4,D5)))","v":306600},{"$f":"IF('Program Information'!$J30=1,E3,IF('Program Information'!$J30=2,SUM(E3,E4),SUM(E3,E4,E5)))","v":0},{"$f":"IF('Program Information'!$J30=1,F3,IF('Program Information'!$J30=2,SUM(F3,F4),SUM(F3,F4,F5)))","v":336000},{"$f":"IF('Program Information'!$J30=1,G3,IF('Program Information'!$J30=2,SUM(G3,G4),SUM(G3,G4,G5)))","v":0}]

{"sheet":"Links","index":9,"n_rows":5,"n_cols":2,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Tuition",true]
["Textbook",true]
["Monthly",true]
["Milestone",true]
["Coaching",true]

{"sheet":"DataValidation","index":10,"n_rows":24,"n_cols":33,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["Students","Incentive","Percentage","Coach-to-student ratio","Credits","Yes/No","Milestone year","Coach/Advisor Salary","Tuition","Cost type",null,{"$f":"IF(Year2RetRate=0,\"ZERO\",IF(Year2RetRate=0.05,\"FIVE\",IF(Year2RetRate=0.1,\"TEN\",IF(Year2RetRate=0.15,\"FIFTEEN\",IF(Year2RetRate=0.2,\"TWENTY\",IF(Year2RetRate=0.25,\"TWENTYFIVE\",IF(Year2RetRate=0.3,\"THIRTY\",IF(Year2RetRate=0.35,\"THIRTYFIVE\",IF(Year2RetRate=0.4,\"FORTY\",IF(Year2RetRate=0.45,\"FORTYFIVE\",IF(Year2RetRate=0.5,\"FIFTY\",IF(Year2RetRate=0.55,\"FIFTYFIVE\",IF(Year2RetRate=0.6,\"SIXTY\",IF(Year2RetRate=0.65,\"SIXTYFIVE\",IF(Year2RetRate=0.7,\"SEVENTY\",IF(Year2RetRate=0.75,\"SEVENTYFIVE\",IF(Year2RetRate=0.8,\"EIGHTY\",IF(Year2RetRate=0.85,\"EIGHTYFIVE\",IF(Year2RetRate=0.9,\"NINETY\",IF(Year2RetRate=0.95,\"NINETYFIVE\",IF(Year2RetRate=1,\"HUNDRED\",\"N/A\")))))))))))))))))))))","v":"SIXTY"},"0%","5%","10%","15%","20%","25%","30%","35%","40%","45%","50%","55%","60%","65%","70%","75%","80%","85%","90%","95%","100%"]
[0,0,0,"1 : 50",null,"Yes","Annual",0,0,"Total",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[50,25,0.05,"1 : 75",0,"No",1,5000,250,"Per Student",null,null,null,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05]
[100,50,0.1,"1 : 100",1,null,2,10000,500,null,null,null,null,null,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1]
[150,75,0.15,"1 : 125",2,null,3,15000,750,null,null,null,null,null,null,0.15,0.15,0.15,0.15,0.15,0.15,0.15,0.15,0.15,0.15,0.15,0.15,0.15,0.15,0.15,0.15,0.15,0.15]
[200,100,0.2,"1 : 150",3,null,null,20000,1000,null,null,null,null,null,null,null,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2]
[250,125,0.25,"1 : 200",4,null,null,25000,1250,null,null,null,null,null,null,null,null,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25]
[300,150,0.3,"1 : 300",5,null,null,30000,1500,null,null,null,null,null,null,null,null,null,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3]
[350,175,0.35,"1 : 400",6,null,null,35000,1750,null,null,null,null,null,null,null,null,null,null,0.35,0.35,0.35,0.35,0.35,0.35,0.35,0.35,0.35,0.35,0.35,0.35,0.35,0.35]
[400,200,0.4,"1 : 500",7,null,null,40000,2000,null,null,null,null,null,null,null,null,null,null,null,0.4,0.4,0.4,0.4,0.4,0.4,0.4,0.4,0.4,0.4,0.4,0.4,0.4]
[450,225,0.45,"1 : 600",8,null,null,45000,2250,null,null,null,null,null,null,null,null,null,null,null,null,0.45,0.45,0.45,0.45,0.45,0.45,0.45,0.45,0.45,0.45,0.45,0.45]
[500,250,0.5,"1 : 700",9,null,null,50000,2500,null,null,null,null,null,null,null,null,null,null,null,null,null,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5]
[550,275,0.55000000000000004,"1 : 800",10,null,null,55000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.55000000000000004,0.55000000000000004,0.55000000000000004,0.55000000000000004,0.55000000000000004,0.55000000000000004,0.55000000000000004,0.55000000000000004,0.55000000000000004,0.55000000000000004]
[600,300,0.6,null,11,null,null,60000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6]
[650,325,0.65,null,12,null,null,65000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.65,0.65,0.65,0.65,0.65,0.65,0.65,0.65]
[700,350,0.7,null,13,null,null,70000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.7,0.7,0.7,0.7,0.7,0.7,0.7]
[750,375,0.75,null,14,null,null,75000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.75,0.75,0.75,0.75,0.75,0.75]
[800,400,0.8,null,15,null,null,80000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.8,0.8,0.8,0.8,0.8]
[850,425,0.85,null,null,null,null,85000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.85,0.85,0.85,0.85]
[900,450,0.9,null,null,null,null,90000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.9,0.9,0.9]
[950,475,0.95,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,0.95,0.95]
[1000,500,1,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,null,1]
[1050]
[1100]