{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Calculate Bachelor Tuition","S&A Fees","2025-26 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 2025-26"]
[]
["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":8,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[" "]
["S&A Fees (your college)",null,null,null,"SBCTC S&A Fees"]
["For Academic Year 2025-26",null,null,null,"For Academic Year 2025-26"]
["CR","S&A",null,null,"CR","S&A"]
[1,null,null,null,1,13.57,null,{"$f":"E5*13.57","v":13.57}]
[2,null,null,null,2,27.14,null,{"$f":"E6*13.57","v":27.14}]
[3,null,null,null,3,40.71,null,40.71]
[4,null,null,null,4,54.28,null,54.28]
[5,null,null,null,5,67.849999999999994,null,67.849999999999994]
[6,null,null,null,6,81.42,null,81.42]
[{"$f":"+A10+1","v":7},null,null,null,{"$f":"+E10+1","v":7},94.990000000000009,null,94.990000000000009]
[{"$f":"+A11+1","v":8},null,null,null,{"$f":"+E11+1","v":8},108.56,null,108.56]
[9,null,null,null,9,122.13,null,122.13]
[10,null,null,null,10,135.69999999999999,null,135.69999999999999]
[11,null,null,null,11,143.54999999999998,null,{"$f":"135.7+(E15-10)*7.85","v":143.54999999999998}]
[12,null,null,null,12,151.39999999999998,null,{"$f":"135.7+(E16-10)*7.85","v":151.39999999999998}]
[13,null,null,null,13,159.25,null,159.25]
[14,null,null,null,14,167.1,null,167.1]
[15,null,null,null,15,174.95,null,174.95]
[16,null,null,null,16,182.79999999999998,null,182.79999999999998]
[17,null,null,null,17,190.64999999999998,null,190.64999999999998]
[18,null,null,null,18,198.5,null,198.5]
[19,null,null,null,19,198.5,null,198.5]
[20,null,null,null,20,198.5,null,198.5]
[21,null,null,null,21,198.5,null,198.5]
[22,null,null,null,22,198.5,null,198.5]
[23,null,null,null,23,198.5,null,198.5]
[24,null,null,null,24,198.5,null,198.5]
[25,null,null,null,25,198.5,null,198.5]

{"sheet":"2025-26 Tuition Schedule","index":2,"n_rows":32,"n_cols":26,"rows_kept":32,"cut":false,"hidden":false,"merged":[[0,0,0,9],[1,0,1,9],[2,0,2,9],[3,0,3,9],[5,1,5,4],[5,6,5,9],[0,10,0,19],[1,10,1,19],[2,10,2,19],[3,10,3,19],[5,11,5,14],[5,16,5,19]]}
["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,"2025-26 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,"FY2025-26 Resident",null,null,null,null,"FY2025-26 Nonresident",null,null,null,null,"FY2025-26 Resident",null,null,null,null,"FY2025-26 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,102.95,15.44,{"$f":"'S&A Fees'!$B5","v":0},{"$f":"SUM(B8:D8)","v":118.39},1,291.31,34.42,{"$f":"'S&A Fees'!$B5","v":0},{"$f":"SUM(G8:I8)","v":325.73},1,226.93,15.44,{"$f":"'S&A Fees'!$B5","v":0},{"$f":"SUM(L8:N8)","v":242.37},1,670.89,34.42,{"$f":"'S&A Fees'!$B5","v":0},{"$f":"SUM(Q8:S8)","v":705.31},null,102.95,291.31,1,226.93,670.89]
[2,205.9,30.88,{"$f":"'S&A Fees'!$B6","v":0},{"$f":"SUM(B9:D9)","v":236.78},2,582.62,68.84,{"$f":"'S&A Fees'!$B6","v":0},{"$f":"SUM(G9:I9)","v":651.46},2,453.86,30.88,{"$f":"'S&A Fees'!$B6","v":0},{"$f":"SUM(L9:N9)","v":484.74},2,1341.78,68.84,{"$f":"'S&A Fees'!$B6","v":0},{"$f":"SUM(Q9:S9)","v":1410.62},null,205.9,582.62,2,453.86,1341.78]
[3,308.85000000000002,46.32,{"$f":"'S&A Fees'!$B7","v":0},355.17,3,873.93000000000006,103.26,{"$f":"'S&A Fees'!$B7","v":0},977.19,3,680.79,46.32,{"$f":"'S&A Fees'!$B7","v":0},727.11,3,2012.67,103.26,{"$f":"'S&A Fees'!$B7","v":0},2115.9300000000003,null,308.85000000000002,873.93000000000006,3,680.79,2012.67]
[4,411.8,61.76,{"$f":"'S&A Fees'!$B8","v":0},473.56,4,1165.24,137.68,{"$f":"'S&A Fees'!$B8","v":0},1302.92,4,907.72,61.76,{"$f":"'S&A Fees'!$B8","v":0},969.48,4,2683.56,137.68,{"$f":"'S&A Fees'!$B8","v":0},2821.24,null,411.8,1165.24,4,907.72,2683.56]
[5,514.75,77.2,{"$f":"'S&A Fees'!$B9","v":0},591.95000000000005,5,1456.55,172.10000000000002,{"$f":"'S&A Fees'!$B9","v":0},1628.65,5,1134.6500000000001,77.2,{"$f":"'S&A Fees'!$B9","v":0},1211.8500000000001,5,3354.45,172.10000000000002,{"$f":"'S&A Fees'!$B9","v":0},3526.5499999999997,null,514.75,1456.55,5,1134.6500000000001,3354.45]
[6,617.70000000000005,92.64,{"$f":"'S&A Fees'!$B10","v":0},710.34,6,1747.86,206.52000000000004,{"$f":"'S&A Fees'!$B10","v":0},1954.3799999999999,6,1361.5800000000002,92.64,{"$f":"'S&A Fees'!$B10","v":0},1454.2200000000003,6,4025.3399999999997,206.52000000000004,{"$f":"'S&A Fees'!$B10","v":0},4231.8599999999997,null,617.70000000000005,1747.86,6,1361.5800000000002,4025.3399999999997]
[7,720.65000000000009,108.08,{"$f":"'S&A Fees'!$B11","v":0},828.73000000000013,7,2039.1699999999998,240.94000000000005,{"$f":"'S&A Fees'!$B11","v":0},2280.1099999999997,7,1588.5100000000002,108.08,{"$f":"'S&A Fees'!$B11","v":0},1696.5900000000001,7,4696.2299999999996,240.94000000000005,{"$f":"'S&A Fees'!$B11","v":0},4937.17,null,720.65000000000009,2039.1699999999998,7,1588.5100000000002,4696.2299999999996]
[8,823.60000000000014,123.52,{"$f":"'S&A Fees'!$B12","v":0},947.12000000000012,8,2330.48,275.36000000000007,{"$f":"'S&A Fees'!$B12","v":0},2605.84,8,1815.4400000000003,123.52,{"$f":"'S&A Fees'!$B12","v":0},1938.9600000000003,8,5367.12,275.36000000000007,{"$f":"'S&A Fees'!$B12","v":0},5642.48,null,823.60000000000014,2330.48,8,1815.4400000000003,5367.12]
[9,926.55000000000018,138.96,{"$f":"'S&A Fees'!$B13","v":0},1065.5100000000002,9,2621.79,309.78000000000009,{"$f":"'S&A Fees'!$B13","v":0},2931.57,9,2042.3700000000003,138.96,{"$f":"'S&A Fees'!$B13","v":0},2181.3300000000004,9,6038.01,309.78000000000009,{"$f":"'S&A Fees'!$B13","v":0},6347.79,null,926.55000000000018,2621.79,9,2042.3700000000003,6038.01]
[10,1029.5000000000002,154.4,{"$f":"'S&A Fees'!$B14","v":0},1183.9000000000003,10,2913.1,344.2000000000001,{"$f":"'S&A Fees'!$B14","v":0},3257.3,10,2269.3000000000002,154.4,{"$f":"'S&A Fees'!$B14","v":0},2423.7000000000003,10,6708.9000000000005,344.2000000000001,{"$f":"'S&A Fees'!$B14","v":0},7053.1,null,1029.5000000000002,2913.1,10,2269.3000000000002,6708.9000000000005]
[11,1081.3000000000002,159.84,{"$f":"'S&A Fees'!$B15","v":0},1241.1400000000001,11,2972.37,350.65000000000009,{"$f":"'S&A Fees'!$B15","v":0},3323.02,11,2269.3000000000002,159.84,{"$f":"'S&A Fees'!$B15","v":0},2429.1400000000003,11,6708.9000000000005,350.65000000000009,{"$f":"'S&A Fees'!$B15","v":0},7059.5500000000011,null,1081.3000000000002,2972.37,11,2269.3000000000002,6708.9000000000005]
[12,1133.1000000000001,165.28,{"$f":"'S&A Fees'!$B16","v":0},1298.3800000000001,12,3031.64,357.10000000000008,{"$f":"'S&A Fees'!$B16","v":0},3388.74,12,2269.3000000000002,165.28,{"$f":"'S&A Fees'!$B16","v":0},2434.5800000000004,12,6708.9000000000005,357.10000000000008,{"$f":"'S&A Fees'!$B16","v":0},7066.0000000000009,null,1133.1000000000001,3031.64,12,2269.3000000000002,6708.9000000000005]
[13,1184.9000000000001,170.72,{"$f":"'S&A Fees'!$B17","v":0},1355.6200000000001,13,3090.91,363.55000000000007,{"$f":"'S&A Fees'!$B17","v":0},3454.46,13,2269.3000000000002,170.72,{"$f":"'S&A Fees'!$B17","v":0},2440.02,13,6708.9000000000005,363.55000000000007,{"$f":"'S&A Fees'!$B17","v":0},7072.4500000000007,null,1184.9000000000001,3090.91,13,2269.3000000000002,6708.9000000000005]
[14,1236.7,176.16,{"$f":"'S&A Fees'!$B18","v":0},1412.8600000000001,14,3150.18,370.00000000000006,{"$f":"'S&A Fees'!$B18","v":0},3520.18,14,2269.3000000000002,176.16,{"$f":"'S&A Fees'!$B18","v":0},2445.46,14,6708.9000000000005,370.00000000000006,{"$f":"'S&A Fees'!$B18","v":0},7078.9000000000005,null,1236.7,3150.18,14,2269.3000000000002,6708.9000000000005]
[15,1288.5,181.6,{"$f":"'S&A Fees'!$B19","v":0},1470.1,15,3209.45,376.45000000000005,{"$f":"'S&A Fees'!$B19","v":0},3585.8999999999996,15,2269.3000000000002,181.6,{"$f":"'S&A Fees'!$B19","v":0},2450.9,15,6708.9000000000005,376.45000000000005,{"$f":"'S&A Fees'!$B19","v":0},7085.35,null,1288.5,3209.45,15,2269.3000000000002,6708.9000000000005]
[16,1340.3,187.04,{"$f":"'S&A Fees'!$B20","v":0},1527.34,16,3268.72,382.90000000000003,{"$f":"'S&A Fees'!$B20","v":0},3651.62,16,2269.3000000000002,187.04,{"$f":"'S&A Fees'!$B20","v":0},2456.34,16,6708.9000000000005,382.90000000000003,{"$f":"'S&A Fees'!$B20","v":0},7091.8,null,1340.3,3268.72,16,2269.3000000000002,6708.9000000000005]
[17,1392.1,192.48,{"$f":"'S&A Fees'!$B21","v":0},1584.58,17,3327.99,389.35,{"$f":"'S&A Fees'!$B21","v":0},3717.3399999999997,17,2269.3000000000002,192.48,{"$f":"'S&A Fees'!$B21","v":0},2461.7800000000002,17,6708.9000000000005,389.35,{"$f":"'S&A Fees'!$B21","v":0},7098.2500000000009,null,1392.1,3327.99,17,2269.3000000000002,6708.9000000000005]
[18,1443.8999999999999,197.92,{"$f":"'S&A Fees'!$B22","v":0},1641.82,18,3387.2599999999998,395.8,{"$f":"'S&A Fees'!$B22","v":0},3783.06,18,2269.3000000000002,197.92,{"$f":"'S&A Fees'!$B22","v":0},2467.2200000000003,18,6708.9000000000005,395.8,{"$f":"'S&A Fees'!$B22","v":0},7104.7000000000007,null,1443.8999999999999,3387.2599999999998,18,2269.3000000000002,6708.9000000000005]
[19,1562.29,197.92,{"$f":"'S&A Fees'!$B23","v":0},1760.21,19,3712.99,395.8,{"$f":"'S&A Fees'!$B23","v":0},4108.79,19,2511.67,197.92,{"$f":"'S&A Fees'!$B23","v":0},2709.59,19,7414.2100000000009,395.8,{"$f":"'S&A Fees'!$B23","v":0},7810.0100000000011,null,1562.29,3712.99,19,2511.67,7414.2100000000009]
[20,1680.68,197.92,{"$f":"'S&A Fees'!$B24","v":0},1878.6000000000001,20,4038.72,395.8,{"$f":"'S&A Fees'!$B24","v":0},4434.5199999999995,20,2754.04,197.92,{"$f":"'S&A Fees'!$B24","v":0},2951.96,20,8119.52,395.8,{"$f":"'S&A Fees'!$B24","v":0},8515.32,null,1680.68,4038.72,20,2754.04,8119.52]
[21,1799.0700000000002,197.92,{"$f":"'S&A Fees'!$B25","v":0},1996.9900000000002,21,4364.45,395.8,{"$f":"'S&A Fees'!$B25","v":0},4760.25,21,2996.41,197.92,{"$f":"'S&A Fees'!$B25","v":0},3194.33,21,8824.83,395.8,{"$f":"'S&A Fees'!$B25","v":0},9220.6299999999992,null,1799.0700000000002,4364.45,21,2996.41,8824.83]
[22,1917.4600000000003,197.92,{"$f":"'S&A Fees'!$B26","v":0},2115.38,22,4690.18,395.8,{"$f":"'S&A Fees'!$B26","v":0},5085.9800000000005,22,3238.7799999999997,197.92,{"$f":"'S&A Fees'!$B26","v":0},3436.7,22,9530.14,395.8,{"$f":"'S&A Fees'!$B26","v":0},9925.9399999999987,null,1917.4600000000003,4690.18,22,3238.7799999999997,9530.14]
[23,2035.8500000000004,197.92,{"$f":"'S&A Fees'!$B27","v":0},2233.7700000000004,23,5015.91,395.8,{"$f":"'S&A Fees'!$B27","v":0},5411.71,23,3481.1499999999996,197.92,{"$f":"'S&A Fees'!$B27","v":0},3679.0699999999997,23,10235.449999999999,395.8,{"$f":"'S&A Fees'!$B27","v":0},10631.249999999998,null,2035.8500000000004,5015.91,23,3481.1499999999996,10235.449999999999]
[24,2154.2400000000002,197.92,{"$f":"'S&A Fees'!$B28","v":0},2352.1600000000003,24,5341.6399999999994,395.8,{"$f":"'S&A Fees'!$B28","v":0},5737.44,24,3723.5199999999995,197.92,{"$f":"'S&A Fees'!$B28","v":0},3921.4399999999996,24,10940.759999999998,395.8,{"$f":"'S&A Fees'!$B28","v":0},11336.559999999998,null,2154.2400000000002,5341.6399999999994,24,3723.5199999999995,10940.759999999998]
[25,2272.63,197.92,{"$f":"'S&A Fees'!$B29","v":0},2470.5500000000002,25,5667.369999999999,395.8,{"$f":"'S&A Fees'!$B29","v":0},6063.1699999999992,25,3965.8899999999994,197.92,{"$f":"'S&A Fees'!$B29","v":0},4163.8099999999995,25,11646.069999999998,395.8,{"$f":"'S&A Fees'!$B29","v":0},12041.869999999997,null,2272.63,5667.369999999999,25,3965.8899999999994,11646.069999999998]

{"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"]