{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Calculate Bachelor Tuition","S&A Fees","2023-24 Tuition Schedule","lookups"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":9,"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":"Calculate Bachelor Tuition","index":0,"n_rows":29,"n_cols":8,"rows_kept":29,"cut":false,"hidden":false,"merged":[[7,1,7,4],[4,0,4,4],[5,0,5,4],[11,2,11,3],[9,1,9,4]]}
["Applied Baccalaureate Tuition Calculator",null,{"$f":"COUNT('S&A Fees'!B5:'S&A Fees'!B29)","v":0},false]
["for Academic Year 2024-25"]
[]
["How to charge tuition:"]
["Usually, a student is charged  lower division rates for lower division courses and upper division rates for upper division courses.  Under certain upper/lower division credit load combinations, this would result in a student paying more than if the student were charged for all credits based only on the upper division schedule.  When this combination occurs, a student should  should be charged for all credits based on the upper division schedule."]
["Use this calculator to determine whether to use both upper and lower division tuition schedules, or just upper division tuition schedules."]
[]
["My college uses the SBCTC \nTuition Schedule S&A fees values:","If your S&A fees are the same as the SBCTC schedule, check the box to the left.  If your S&A fees vary from the schedule, leave the box to the left unchecked and enter the S&A fees into column B of the \"S&A Fees\" worksheet."]
[]
["My college waives all the Op Fee\nDifferential for Non-Residents","If your college waives ALL the NR Op Fee Differential, then check the box. If you use the standard NR Op Fee rates, then leave the box unchecked."]
[]
["Select Resident or Non-Resident Tuition:",null,null,null,null,null,"Resident Lookup",1]
["Enter the Number of Lower Division Credits:",null,null,null,null,null,"Named ranges:",{"$f":"IF(H12=1,\"LowerDivision\",\"LowerNonRes\")","v":"LowerDivision"}]
["Enter the Number of Upper Division Credits:",null,null,null,null,null,null,{"$f":"IF(H12=1,\"UpperDivision\",\"UpperNonRes\" )","v":"UpperDivision"}]
[null,null,null,null,null,null,"SBCTC S&A Fees",true]
["How to Charge This Student:"]
["If the student was charged a combination\nof lower and upper division tuition, they would pay:",{"$f":"E25","v":0}]
["If the student was charged only upper division tuition, they would pay:",{"$f":"E27","v":0}]
["Therefore, the correct method of tuition calculation is:",{"$f":"IF(B18+B17=0,\"\",IF(B18<B17,\"Upper Division Only\",  IF(B13=0,\"Upper Division Only\", IF(B14=0,\"Lower Division Only\",IF(LowerDivCredits>0,\"A combination of lower and upper division tuition.\")))))","v":""}]
[" Rate changes required?",{"$f":"IF(UpperDivCredits>0,IF(LowerDivCredits>0, IF(B19=\"Upper Division Only\",IF(H12=1,\"Lower Division courses should be charged at Upper Division rates.\",\"Lower Division courses should be charged at Upper Division rates.\"),\"No\"),\"No\"),\"\")","v":""}]
[]
["Here are the calculations:","Operating Fee ","Building Fees","S&A Fees","Total"]
["Lower Division Tutition:",{"$f":"IF(ISNA(VLOOKUP(LowerDivCredits,INDIRECT($H$13),2,FALSE)),0,VLOOKUP(LowerDivCredits,INDIRECT($H$13),2,FALSE))","v":0},{"$f":"IF(ISNA(VLOOKUP(LowerDivCredits,INDIRECT($H$13),3,FALSE)),0,VLOOKUP(LowerDivCredits,INDIRECT($H$13),3,FALSE))","v":0},{"$f":"IF(ISNA(VLOOKUP(LowerDivCredits,INDIRECT($H$13),4,FALSE)),0,VLOOKUP(LowerDivCredits,INDIRECT($H$13),4,FALSE))","v":0},{"$f":"SUM(B23:D23)","v":0}]
["Upper Division Tuition:",{"$f":"IF(ISNA(VLOOKUP(UpperDivCredits,INDIRECT($H$14), 2, FALSE)),0,VLOOKUP(UpperDivCredits, INDIRECT($H$14), 2, FALSE))","v":0},{"$f":"IF(ISNA(VLOOKUP( UpperDivCredits, INDIRECT($H$14), 3, FALSE)),0,VLOOKUP(UpperDivCredits, INDIRECT($H$14), 3, FALSE))","v":0},{"$f":"IF(ISNA(VLOOKUP( UpperDivCredits, INDIRECT($H$14), 4, FALSE)),0,VLOOKUP(UpperDivCredits, INDIRECT($H$14), 4, FALSE))","v":0},{"$f":"SUM(B24:D24)","v":0}]
["Total:",{"$f":"SUM(B23:B24)","v":0},{"$f":"SUM(C23:C24)","v":0},{"$f":"SUM(D23:D24)","v":0},{"$f":"SUM(B25:D25)","v":0}]
[]
["Max Tuition Allowable:",{"$f":"IF(ISNA(VLOOKUP(LowerDivCredits + UpperDivCredits, INDIRECT($H$14), 2, FALSE)),0,VLOOKUP(LowerDivCredits + UpperDivCredits, INDIRECT($H$14),2, FALSE))","v":0},{"$f":"IF(ISNA(VLOOKUP(LowerDivCredits + UpperDivCredits, INDIRECT($H$14), 3, FALSE)),0,VLOOKUP(LowerDivCredits + UpperDivCredits, INDIRECT($H$14), 3, FALSE))","v":0},{"$f":"IF(ISNA(VLOOKUP(LowerDivCredits + UpperDivCredits, INDIRECT($H$14), 4, FALSE)),0,VLOOKUP(LowerDivCredits + UpperDivCredits, INDIRECT($H$14), 4, FALSE))","v":0},{"$f":"IF(ISNA(VLOOKUP(LowerDivCredits + UpperDivCredits, INDIRECT($H$14), 5, FALSE)),0,VLOOKUP(LowerDivCredits + UpperDivCredits, INDIRECT($H$14), 5, FALSE))","v":0}]
[]
["Amount over/under the maximum allowed",{"$f":"B25-B27","v":0},{"$f":"C25-C27","v":0},{"$f":"D25-D27","v":0},{"$f":"E25-E27","v":0}]

{"sheet":"S&A Fees","index":1,"n_rows":29,"n_cols":6,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[" "]
["S&A Fees (your college)",null,null,null,"SBCTC S&A Fees"]
["For Academic Year 2024-25",null,null,null,"For Academic Year 2024-25"]
["CR","S&A",null,null,"CR","S&A"]
[1,null,null,null,1,13.12]
[2,null,null,null,2,26.24]
[3,null,null,null,3,39.36]
[4,null,null,null,4,52.48]
[5,null,null,null,5,65.599999999999994]
[6,null,null,null,6,78.72]
[{"$f":"+A10+1","v":7},null,null,null,{"$f":"+E10+1","v":7},91.84]
[{"$f":"+A11+1","v":8},null,null,null,{"$f":"+E11+1","v":8},104.96000000000001]
[9,null,null,null,9,118.08000000000001]
[10,null,null,null,10,131.20000000000002]
[11,null,null,null,11,138.79000000000002]
[12,null,null,null,12,146.38000000000002]
[13,null,null,null,13,153.97000000000003]
[14,null,null,null,14,161.56000000000003]
[15,null,null,null,15,169.15000000000003]
[16,null,null,null,16,176.74000000000004]
[17,null,null,null,17,184.33000000000004]
[18,null,null,null,18,191.92000000000004]
[19,null,null,null,19,191.92000000000004]
[20,null,null,null,20,191.92000000000004]
[21,null,null,null,21,191.92000000000004]
[22,null,null,null,22,191.92000000000004]
[23,null,null,null,23,191.92000000000004]
[24,null,null,null,24,191.92000000000004]
[25,null,null,null,25,191.92000000000004]

{"sheet":"2023-24 Tuition Schedule","index":2,"n_rows":32,"n_cols":26,"rows_kept":32,"cut":false,"hidden":true,"merged":[[0,10,0,19],[1,10,1,19],[2,10,2,19],[3,10,3,19],[5,11,5,14],[5,16,5,19],[0,0,0,9],[1,0,1,9],[2,0,2,9],[3,0,3,9],[5,1,5,4],[5,6,5,9]]}
["Washington State Community Colleges",null,null,null,null,null,null,null,null,null,"Washington State Community Colleges"]
["Lower Division",null,null,null,null,null,null,null,null,null,"Upper Division"]
["2024-25 Tuition Schedule ",null,null,null,null,null,null,null,null,null,"2024-25 Tuition Schedule "]
["(per quarter)",null,null,null,null,null,null,null,null,null,"(per quarter)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lower","Division",null,"Upper","Division"]
[null,"FY2024-25 Resident",null,null,null,null,"FY2024-25 Nonresident",null,null,null,null,"FY2024-25 Resident",null,null,null,null,"FY2024-25 Nonresident",null,null,null,null,"NR","NR",null,"NR","NR"]
["Credits","Operating Fee","Building Fee","Maximum S&A Fee","Tuition and Fees",null,"Operating Fee","Building Fee","Maximum S&A Fee","Tuition and Fees","Credits","Operating Fee","Building Fee","Maximum S&A Fee","Tuition and Fees",null,"Operating Fee","Building Fee","Maximum S&A Fee","Tuition and Fees",null,"Op Fee Waiver","Op Fee Standard",null,"Op Fee Waiver","Op Fee Standard"]
[1,99.66,14.81,{"$f":"'S&A Fees'!$B5","v":0},{"$f":"SUM(B8:D8)","v":114.47},1,282,33.01,{"$f":"'S&A Fees'!$B5","v":0},{"$f":"SUM(G8:I8)","v":315.01},1,219.68,14.81,{"$f":"'S&A Fees'!$B5","v":0},{"$f":"SUM(L8:N8)","v":234.49},1,649.46,33.01,{"$f":"'S&A Fees'!$B5","v":0},{"$f":"SUM(Q8:S8)","v":682.47},null,99.66,282,1,219.68,649.46]
[2,199.32,29.62,{"$f":"'S&A Fees'!$B6","v":0},{"$f":"SUM(B9:D9)","v":228.94},2,564,66.02,{"$f":"'S&A Fees'!$B6","v":0},{"$f":"SUM(G9:I9)","v":630.02},2,439.36,29.62,{"$f":"'S&A Fees'!$B6","v":0},{"$f":"SUM(L9:N9)","v":468.98},2,1298.92,66.02,{"$f":"'S&A Fees'!$B6","v":0},{"$f":"SUM(Q9:S9)","v":1364.94},null,199.32,564,2,439.36,1298.92]
[3,298.98,44.43,{"$f":"'S&A Fees'!$B7","v":0},343.41,3,846,99.03,{"$f":"'S&A Fees'!$B7","v":0},945.03,3,659.04,44.43,{"$f":"'S&A Fees'!$B7","v":0},703.46999999999991,3,1948.38,99.03,{"$f":"'S&A Fees'!$B7","v":0},2047.41,null,298.98,846,3,659.04,1948.38]
[4,398.64,59.24,{"$f":"'S&A Fees'!$B8","v":0},457.88,4,1128,132.04,{"$f":"'S&A Fees'!$B8","v":0},1260.04,4,878.72,59.24,{"$f":"'S&A Fees'!$B8","v":0},937.96,4,2597.84,132.04,{"$f":"'S&A Fees'!$B8","v":0},2729.88,null,398.64,1128,4,878.72,2597.84]
[5,498.29999999999995,74.05,{"$f":"'S&A Fees'!$B9","v":0},572.34999999999991,5,1410,165.04999999999998,{"$f":"'S&A Fees'!$B9","v":0},1575.05,5,1098.4000000000001,74.05,{"$f":"'S&A Fees'!$B9","v":0},1172.45,5,3247.3,165.04999999999998,{"$f":"'S&A Fees'!$B9","v":0},3412.3500000000004,null,498.29999999999995,1410,5,1098.4000000000001,3247.3]
[6,597.95999999999992,88.86,{"$f":"'S&A Fees'!$B10","v":0},686.81999999999994,6,1692,198.05999999999997,{"$f":"'S&A Fees'!$B10","v":0},1890.06,6,1318.0800000000002,88.86,{"$f":"'S&A Fees'!$B10","v":0},1406.94,6,3896.76,198.05999999999997,{"$f":"'S&A Fees'!$B10","v":0},4094.82,null,597.95999999999992,1692,6,1318.0800000000002,3896.76]
[7,697.61999999999989,103.67,{"$f":"'S&A Fees'!$B11","v":0},801.28999999999985,7,1974,231.06999999999996,{"$f":"'S&A Fees'!$B11","v":0},2205.0700000000002,7,1537.7600000000002,103.67,{"$f":"'S&A Fees'!$B11","v":0},1641.4300000000003,7,4546.22,231.06999999999996,{"$f":"'S&A Fees'!$B11","v":0},4777.29,null,697.61999999999989,1974,7,1537.7600000000002,4546.22]
[8,797.27999999999986,118.48,{"$f":"'S&A Fees'!$B12","v":0},915.75999999999988,8,2256,264.08,{"$f":"'S&A Fees'!$B12","v":0},2520.08,8,1757.4400000000003,118.48,{"$f":"'S&A Fees'!$B12","v":0},1875.9200000000003,8,5195.68,264.08,{"$f":"'S&A Fees'!$B12","v":0},5459.76,null,797.27999999999986,2256,8,1757.4400000000003,5195.68]
[9,896.93999999999983,133.29,{"$f":"'S&A Fees'!$B13","v":0},1030.2299999999998,9,2538,297.08999999999997,{"$f":"'S&A Fees'!$B13","v":0},2835.09,9,1977.1200000000003,133.29,{"$f":"'S&A Fees'!$B13","v":0},2110.4100000000003,9,5845.14,297.08999999999997,{"$f":"'S&A Fees'!$B13","v":0},6142.2300000000005,null,896.93999999999983,2538,9,1977.1200000000003,5845.14]
[10,996.5999999999998,148.1,{"$f":"'S&A Fees'!$B14","v":0},1144.6999999999998,10,2820,330.09999999999997,{"$f":"'S&A Fees'!$B14","v":0},3150.1,10,2196.8000000000002,148.1,{"$f":"'S&A Fees'!$B14","v":0},2344.9,10,6494.6,330.09999999999997,{"$f":"'S&A Fees'!$B14","v":0},6824.7000000000007,null,996.5999999999998,2820,10,2196.8000000000002,6494.6]
[11,1046.7499999999998,153.32,{"$f":"'S&A Fees'!$B15","v":0},1200.0699999999997,11,2877.38,336.28999999999996,{"$f":"'S&A Fees'!$B15","v":0},3213.67,11,2196.8000000000002,153.32,{"$f":"'S&A Fees'!$B15","v":0},2350.1200000000003,11,6494.6,336.28999999999996,{"$f":"'S&A Fees'!$B15","v":0},6830.89,null,1046.7499999999998,2877.38,11,2196.8000000000002,6494.6]
[12,1096.8999999999999,158.54,{"$f":"'S&A Fees'!$B16","v":0},1255.4399999999998,12,2934.76,342.47999999999996,{"$f":"'S&A Fees'!$B16","v":0},3277.2400000000002,12,2196.8000000000002,158.54,{"$f":"'S&A Fees'!$B16","v":0},2355.34,12,6494.6,342.47999999999996,{"$f":"'S&A Fees'!$B16","v":0},6837.08,null,1096.8999999999999,2934.76,12,2196.8000000000002,6494.6]
[13,1147.05,163.76,{"$f":"'S&A Fees'!$B17","v":0},1310.81,13,2992.1400000000003,348.66999999999996,{"$f":"'S&A Fees'!$B17","v":0},3340.8100000000004,13,2196.8000000000002,163.76,{"$f":"'S&A Fees'!$B17","v":0},2360.5600000000004,13,6494.6,348.66999999999996,{"$f":"'S&A Fees'!$B17","v":0},6843.27,null,1147.05,2992.1400000000003,13,2196.8000000000002,6494.6]
[14,1197.2,168.98,{"$f":"'S&A Fees'!$B18","v":0},1366.18,14,3049.5200000000004,354.85999999999996,{"$f":"'S&A Fees'!$B18","v":0},3404.3800000000006,14,2196.8000000000002,168.98,{"$f":"'S&A Fees'!$B18","v":0},2365.7800000000002,14,6494.6,354.85999999999996,{"$f":"'S&A Fees'!$B18","v":0},6849.46,null,1197.2,3049.5200000000004,14,2196.8000000000002,6494.6]
[15,1247.3500000000001,174.2,{"$f":"'S&A Fees'!$B19","v":0},1421.5500000000002,15,3106.9000000000005,361.04999999999995,{"$f":"'S&A Fees'!$B19","v":0},3467.9500000000007,15,2196.8000000000002,174.2,{"$f":"'S&A Fees'!$B19","v":0},2371,15,6494.6,361.04999999999995,{"$f":"'S&A Fees'!$B19","v":0},6855.6500000000005,null,1247.3500000000001,3106.9000000000005,15,2196.8000000000002,6494.6]
[16,1297.5000000000002,179.42,{"$f":"'S&A Fees'!$B20","v":0},1476.9200000000003,16,3164.2800000000007,367.23999999999995,{"$f":"'S&A Fees'!$B20","v":0},3531.5200000000004,16,2196.8000000000002,179.42,{"$f":"'S&A Fees'!$B20","v":0},2376.2200000000003,16,6494.6,367.23999999999995,{"$f":"'S&A Fees'!$B20","v":0},6861.84,null,1297.5000000000002,3164.2800000000007,16,2196.8000000000002,6494.6]
[17,1347.6500000000003,184.64,{"$f":"'S&A Fees'!$B21","v":0},1532.2900000000004,17,3221.6600000000008,373.42999999999995,{"$f":"'S&A Fees'!$B21","v":0},3595.0900000000006,17,2196.8000000000002,184.64,{"$f":"'S&A Fees'!$B21","v":0},2381.44,17,6494.6,373.42999999999995,{"$f":"'S&A Fees'!$B21","v":0},6868.0300000000007,null,1347.6500000000003,3221.6600000000008,17,2196.8000000000002,6494.6]
[18,1397.8000000000004,189.85999999999999,{"$f":"'S&A Fees'!$B22","v":0},1587.6600000000003,18,3279.0400000000009,379.61999999999995,{"$f":"'S&A Fees'!$B22","v":0},3658.6600000000008,18,2196.8000000000002,189.85999999999999,{"$f":"'S&A Fees'!$B22","v":0},2386.6600000000003,18,6494.6,379.61999999999995,{"$f":"'S&A Fees'!$B22","v":0},6874.22,null,1397.8000000000004,3279.0400000000009,18,2196.8000000000002,6494.6]
[19,1512.2700000000004,189.85999999999999,{"$f":"'S&A Fees'!$B23","v":0},1702.1300000000003,19,3594.0500000000011,379.61999999999995,{"$f":"'S&A Fees'!$B23","v":0},3973.670000000001,19,2431.29,189.85999999999999,{"$f":"'S&A Fees'!$B23","v":0},2621.15,19,7177.0700000000006,379.61999999999995,{"$f":"'S&A Fees'!$B23","v":0},7556.6900000000005,null,1512.2700000000004,3594.0500000000011,19,2431.29,7177.0700000000006]
[20,1626.7400000000005,189.85999999999999,{"$f":"'S&A Fees'!$B24","v":0},1816.6000000000004,20,3909.0600000000013,379.61999999999995,{"$f":"'S&A Fees'!$B24","v":0},4288.6800000000012,20,2665.7799999999997,189.85999999999999,{"$f":"'S&A Fees'!$B24","v":0},2855.64,20,7859.5400000000009,379.61999999999995,{"$f":"'S&A Fees'!$B24","v":0},8239.1600000000017,null,1626.7400000000005,3909.0600000000013,20,2665.7799999999997,7859.5400000000009]
[21,1741.2100000000005,189.85999999999999,{"$f":"'S&A Fees'!$B25","v":0},1931.0700000000004,21,4224.0700000000015,379.61999999999995,{"$f":"'S&A Fees'!$B25","v":0},4603.6900000000014,21,2900.2699999999995,189.85999999999999,{"$f":"'S&A Fees'!$B25","v":0},3090.1299999999997,21,8542.01,379.61999999999995,{"$f":"'S&A Fees'!$B25","v":0},8921.630000000001,null,1741.2100000000005,4224.0700000000015,21,2900.2699999999995,8542.01]
[22,1855.6800000000005,189.85999999999999,{"$f":"'S&A Fees'!$B26","v":0},2045.5400000000004,22,4539.0800000000017,379.61999999999995,{"$f":"'S&A Fees'!$B26","v":0},4918.7000000000016,22,3134.7599999999993,189.85999999999999,{"$f":"'S&A Fees'!$B26","v":0},3324.6199999999994,22,9224.48,379.61999999999995,{"$f":"'S&A Fees'!$B26","v":0},9604.1,null,1855.6800000000005,4539.0800000000017,22,3134.7599999999993,9224.48]
[23,1970.1500000000005,189.85999999999999,{"$f":"'S&A Fees'!$B27","v":0},2160.0100000000007,23,4854.090000000002,379.61999999999995,{"$f":"'S&A Fees'!$B27","v":0},5233.7100000000019,23,3369.2499999999991,189.85999999999999,{"$f":"'S&A Fees'!$B27","v":0},3559.1099999999992,23,9906.9499999999989,379.61999999999995,{"$f":"'S&A Fees'!$B27","v":0},10286.57,null,1970.1500000000005,4854.090000000002,23,3369.2499999999991,9906.9499999999989]
[24,2084.6200000000003,189.85999999999999,{"$f":"'S&A Fees'!$B28","v":0},2274.4800000000005,24,5169.1000000000022,379.61999999999995,{"$f":"'S&A Fees'!$B28","v":0},5548.7200000000021,24,3603.7399999999989,189.85999999999999,{"$f":"'S&A Fees'!$B28","v":0},3793.599999999999,24,10589.419999999998,379.61999999999995,{"$f":"'S&A Fees'!$B28","v":0},10969.039999999999,null,2084.6200000000003,5169.1000000000022,24,3603.7399999999989,10589.419999999998]
[25,2199.09,189.85999999999999,{"$f":"'S&A Fees'!$B29","v":0},2388.9500000000003,25,5484.1100000000024,379.61999999999995,{"$f":"'S&A Fees'!$B29","v":0},5863.7300000000023,25,3838.2299999999987,189.85999999999999,{"$f":"'S&A Fees'!$B29","v":0},4028.0899999999988,25,11271.889999999998,379.61999999999995,{"$f":"'S&A Fees'!$B29","v":0},11651.509999999998,null,2199.09,5484.1100000000024,25,3838.2299999999987,11271.889999999998]

{"sheet":"lookups","index":3,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
["Code","AYR","Abbreviated"]
[1,"2010-11",1011]
[2,"2011-12",1112]
[3,"2012-13",1213]
[]
["Code","Type","Abbreviated"]
[1,"Resident","Res"]
[2,"Non-Resident","NonRes"]