{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"macros":1},"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":42,"n_cols":10,"rows_kept":42,"merged":[[0,0,0,5],[2,0,2,5],[24,0,25,5],[41,0,41,5]]}
["2022-2023 Tuition Calculator"]
[]
["The green cells are the only cells you need to fill in!\nAfter entering number, press <Enter> or click anywhere else on the worksheet."]
[]
[null,"Dancer #1",null,"Additional Child #1",null,"Additional Child #2",null,null,"Single-class monthly tuition"]
[]
[" # of 30-minute classes:",{"$nulls":7},{"v":50,"d":"$50.00"}]
[]
[" # of 45-minute classes:",{"$nulls":7},{"v":65,"d":"$65.00"}]
[]
[" # of 60-minute classes:",{"$nulls":7},{"v":75,"d":"$75.00"}]
[]
[" # of 75-minute classes:",{"$nulls":7},{"v":85,"d":"$85.00"}]
[]
[" # of 90-minute classes:",{"$nulls":7},{"v":95,"d":"$95.00"}]
[]
[]
["Monthly Tuition:",{"$f":"MIN(ROUND(SUM(B35,D35,F35),0),B29)","v":0}]
[]
["Yearly Prepayment Option:",{"$f":"ROUND(B18*9*95%,0)","v":0},{"$f":"CONCATENATE( \" (Savings of: \",    TEXT(B18*9-B20,\"$#,###\"),        \")\")","v":" (Savings of: $)"}]
["Prepay tuition for the entire year at the time of registration & receive 5% off"]
["If choose Yearly Prepayment Option, payment must be by check."]
[]
[]
["Note - Monthly and Yearly Tuition amounts have been rounded to the nearest dollar after applying any applicable discounts."]
[]
["Calculation Formulas…"]
["$ Cap per child:",{"v":315,"d":"$315.00"},{"$nulls":6},"Multi-Class Discounts"]
["$ Cap per family:",{"v":600,"d":"$600.00"}]
[null,"Dancer #1",null,"Additional Child #1",null,"Additional Child #2"]
["Sum",{"$f":"IF(SUM(B7:B15)=1,(100%*(SUM(B7*$I$7)+(B9*$I$9)+(B11*$I$11)+(B13*$I$13)+(B15*$I$15))),IF(SUM(B7:B15)=2,((100%-$J$31)*(SUM(B7*$I$7)+(B9*$I$9)+(B11*$I$11)+(B13*$I$13)+(B15*$I$15))),IF(SUM(B7:B15)=3,((100%-$J$32)*(SUM(B7*$I$7)+(B9*$I$9)+(B11*$I$11)+(B13*$I$13)+(B15*$I$15))),IF(SUM(B7:B15)=4,((100%-$J$33)*(SUM(B7*$I$7)+(B9*$I$9)+(B11*$I$11)+(B13*$I$13)+(B15*$I$15))),IF(SUM(B7:B15)>4,((100%-$J$34)*(SUM(B7*$I$7)+(B9*$I$9)+(B11*$I$11)+(B13*$I$13)+(B15*$I$15))),)))))","v":0},null,{"$f":"IF(SUM(D7:D15)=1,(100%*(SUM(D7*$I$7)+(D9*$I$9)+(D11*$I$11)+(D13*$I$13)+(D15*$I$15))),IF(SUM(D7:D15)=2,((100%-$J$31)*(SUM(D7*$I$7)+(D9*$I$9)+(D11*$I$11)+(D13*$I$13)+(D15*$I$15))),IF(SUM(D7:D15)=3,((100%-$J$32)*(SUM(D7*$I$7)+(D9*$I$9)+(D11*$I$11)+(D13*$I$13)+(D15*$I$15))),IF(SUM(D7:D15)=4,((100%-$J$33)*(SUM(D7*$I$7)+(D9*$I$9)+(D11*$I$11)+(D13*$I$13)+(D15*$I$15))),IF(SUM(D7:D15)>4,((100%-$J$34)*(SUM(D7*$I$7)+(D9*$I$9)+(D11*$I$11)+(D13*$I$13)+(D15*$I$15))),)))))","v":0},null,{"$f":"IF(SUM(F7:F15)=1,(100%*(SUM(F7*$I$7)+(F9*$I$9)+(F11*$I$11)+(F13*$I$13)+(F15*$I$15))),IF(SUM(F7:F15)=2,((100%-$J$31)*(SUM(F7*$I$7)+(F9*$I$9)+(F11*$I$11)+(F13*$I$13)+(F15*$I$15))),IF(SUM(F7:F15)=3,((100%-$J$32)*(SUM(F7*$I$7)+(F9*$I$9)+(F11*$I$11)+(F13*$I$13)+(F15*$I$15))),IF(SUM(F7:F15)=4,((100%-$J$33)*(SUM(F7*$I$7)+(F9*$I$9)+(F11*$I$11)+(F13*$I$13)+(F15*$I$15))),IF(SUM(F7:F15)>4,((100%-$J$34)*(SUM(F7*$I$7)+(F9*$I$9)+(F11*$I$11)+(F13*$I$13)+(F15*$I$15))),)))))","v":0},null,null,"2 classes",{"v":0.05,"d":"5%"}]
["Capped Sum",{"$f":"MIN(B31,$B$28)","v":0},null,{"$f":"MIN(D31,$B$28)","v":0},null,{"$f":"MIN(F31,$B$28)","v":0},null,null,"3 classes",{"v":0.1,"d":"10%"}]
["Tuition $ Order",{"$f":"_xlfn.RANK.EQ(B32,$B32:$F32,0)+COUNTIF($B32:B32,B32)-1","v":1},null,{"$f":"_xlfn.RANK.EQ(D32,$B32:$F32,0)+COUNTIF($B32:D32,D32)-1","v":2},null,{"$f":"_xlfn.RANK.EQ(F32,$B32:$F32,0)+COUNTIF($B32:F32,F32)-1","v":3},null,null,"4 classes",{"v":0.15,"d":"15%"}]
[{"$nulls":8},"5+ classes",{"v":0.2,"d":"20%"}]
["Multi-child Discounted Tuition Amount",{"$f":"IF(B33=1,         B32,       ROUND(80%*B32,2)                )","v":0},null,{"$f":"IF(D33=1,         D32,       ROUND(80%*D32,2)                )","v":0},null,{"$f":"IF(F33=1,         F32,       ROUND(80%*F32,2)                )","v":0}]
[]
[]
["Note - worksheet is password protected to prevent erroneous editing errors by users."]
["To unprotect, select \"Review\", then \"Unprotect Sheet\".  Password is… password "]
["To protect, select \"Review\", then \"Protect Sheet\" and enter password of… password"]
[]
["Note - the password cannot be changed to anything other than \"password\".  Otherwise, the Visual Basic macro that runs when \"Clear Form\" is pressed will automatically protect the worksheet with \"password\" as the password."]