{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Calculate Fees","Fees","Fees & Levies Schedule 2025","Sheet1"],"not_rendered":{"charts":0,"images":4,"macros":0,"external_links":0,"defined_names":0,"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 Fees","index":0,"n_rows":118,"n_cols":3,"rows_kept":118,"cut":false,"hidden":false,"merged":[[1,0,1,2],[19,0,19,2],[20,0,20,2],[0,0,0,2],[2,0,2,2],[10,0,10,1]]}
["2025 GSCC Fee Calculator"]
["The GSCC Fee Calculator assists families to establish a payment arrangement to pay their school fees. GSCC will send an annual statement at the beginning of the year. Fees can be paid weekly, fortnightly, monthly, quarterly or annually in advance.   Please ensure that regular payments are made and that the school fees are finalised by the last Friday in October annually. The figures below include camp costs for Year 5 to Year 12. Please contact us with any enquiries by email sblifinance@bne.catholic.edu.au or Ph: 5374 8840.                                                                              "]
[" N.B. Complete pink fields to determine payment amount."]
["N.B. Fee discounts are calculated in chronological order from eldest to youngest student.","Click on cell to select Year Level (via drop down box)","Annual Fees Payable"]
["Eldest child",null,{"$f":"IFERROR(VLOOKUP('Calculate Fees'!B5,Fees!$A$6:$F$18,2,FALSE),\"\")","v":""}]
["Second eldest child",null,{"$f":"IFERROR(VLOOKUP('Calculate Fees'!B6,Fees!$A$6:$F$18,3,FALSE),\"\")","v":""}]
["Third eldest child",null,{"$f":"IFERROR(VLOOKUP('Calculate Fees'!B7,Fees!$A$6:$F$18,4,FALSE),\"\")","v":""}]
["Fourth eldest child",null,{"$f":"IFERROR(VLOOKUP('Calculate Fees'!B8,Fees!$A$6:$F$18,5,FALSE),\"\")","v":""}]
["Fifth eldest child",null,{"$f":"IFERROR(VLOOKUP('Calculate Fees'!B9,Fees!$A$6:$F$18,6,FALSE),\"\")","v":""}]
[null,"Sub-Total",{"$f":"SUM(C5:C9)","v":0}]
["Add Certificate Course(s) cost"]
[null,"Total Fees ",{"$f":"C10+C11","v":0}]
[null,"Start Date","2025-02-07"]
[null,"End Date","2025-11-07"]
[]
["Weeks between dates",{"$f":"(DATEDIF(C13,C14,\"d\")/7)+1","v":40},{"$f":"IFERROR($C$12/B16,0)","v":0}]
["Fortnights between dates",{"$f":"B16/2","v":20},{"$f":"IFERROR($C$12/B17,0)","v":0}]
["Months between dates",{"$f":"DATEDIF(C13,C14,\"m\")+1","v":10},{"$f":"IFERROR($C$12/B18,0)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Year 12"]
["Year 11"]
["Year 10"]
["Year 9"]
["Year 8"]
["Year 7"]
["Year 6"]
["Year 5"]
["Year 4"]
["Year 3"]
["Year 2"]
["Year 1"]
["Prep"]

{"sheet":"Fees","index":1,"n_rows":33,"n_cols":21,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
[]
[null,"LOOKUP TABLE FOR FEE CALCULATOR",null,null,null,null,null,null,null,null,"FEE BUILDUP CALCUATIONS"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Additional Fees"]
["Year Level","Fees Child 1","Fees Child 2","Fees Child 3","Fees Child 4","Fees Child 5",null,"Year Level","TOTAL","School Fee","Capital Levy","Parents & Community Levy","Resource Levy","Camp","Prep Levy","IT Levy","Book Levy","Certificate III in Business","Certificate II Sport & Recreation/Certificate III in Fitness","Certificate II in Hospitality","Certificate III in Aviation"]
["Year 12",{"$f":"+I6","v":5899},{"$f":"+Fees!$J6*(1-$I$24)+SUM(Fees!$M6:$Q6)","v":3860.3999999999996},{"$f":"+Fees!$J6*(1-$I$25)+SUM(Fees!$M6:$Q6)","v":3368.6},{"$f":"+Fees!$J6*(1-$I$26)+SUM(Fees!$M6:$Q6)","v":2876.7999999999997},{"$f":"+Fees!$J6*(1-$I$27)+SUM(Fees!$M6:$Q6)","v":2385},null,"Year 12",{"$f":"SUM(Fees!$J6:$Q6)","v":5899},2459,955,100,1550,255,null,580]
["Year 11",6144,{"$f":"+Fees!$J7*(1-$I$24)+SUM(Fees!$M7:$Q7)","v":4105.3999999999996},{"$f":"+Fees!$J7*(1-$I$25)+SUM(Fees!$M7:$Q7)","v":3613.6},{"$f":"+Fees!$J7*(1-$I$26)+SUM(Fees!$M7:$Q7)","v":3121.7999999999997},{"$f":"+Fees!$J7*(1-$I$27)+SUM(Fees!$M7:$Q7)","v":2630},null,"Year 11",{"$f":"SUM(Fees!$J7:$Q7)","v":6144},2459,955,100,1550,500,null,580,null,265,420,800,3330]
["Year 10",5644,{"$f":"+Fees!$J8*(1-$I$24)+SUM(Fees!$M8:$Q8)","v":3605.3999999999996},{"$f":"+Fees!$J8*(1-$I$25)+SUM(Fees!$M8:$Q8)","v":3113.6},{"$f":"+Fees!$J8*(1-$I$26)+SUM(Fees!$M8:$Q8)","v":2621.7999999999997},{"$f":"+Fees!$J8*(1-$I$27)+SUM(Fees!$M8:$Q8)","v":2130},null,"Year 10",{"$f":"SUM(Fees!$J8:$Q8)","v":5644},2459,955,100,1550,0,null,580]
["Year 9",5196,{"$f":"+Fees!$J9*(1-$I$24)+SUM(Fees!$M9:$Q9)","v":3266.6},{"$f":"+Fees!$J9*(1-$I$25)+SUM(Fees!$M9:$Q9)","v":2829.4},{"$f":"+Fees!$J9*(1-$I$26)+SUM(Fees!$M9:$Q9)","v":2392.1999999999998},{"$f":"+Fees!$J9*(1-$I$27)+SUM(Fees!$M9:$Q9)","v":1955},null,"Year 9",{"$f":"SUM(Fees!$J9:$Q9)","v":5196},2186,955,100,1130,590,null,235]
["Year 8",5086,{"$f":"+Fees!$J10*(1-$I$24)+SUM(Fees!$M10:$Q10)","v":3156.6},{"$f":"+Fees!$J10*(1-$I$25)+SUM(Fees!$M10:$Q10)","v":2719.4},{"$f":"+Fees!$J10*(1-$I$26)+SUM(Fees!$M10:$Q10)","v":2282.1999999999998},{"$f":"+Fees!$J10*(1-$I$27)+SUM(Fees!$M10:$Q10)","v":1845},null,"Year 8",{"$f":"SUM(Fees!$J10:$Q10)","v":5086},2186,955,100,1130,480,null,235]
["Year 7",5051,{"$f":"+Fees!$J11*(1-$I$24)+SUM(Fees!$M11:$Q11)","v":3121.6},{"$f":"+Fees!$J11*(1-$I$25)+SUM(Fees!$M11:$Q11)","v":2684.4},{"$f":"+Fees!$J11*(1-$I$26)+SUM(Fees!$M11:$Q11)","v":2247.1999999999998},{"$f":"+Fees!$J11*(1-$I$27)+SUM(Fees!$M11:$Q11)","v":1810},null,"Year 7",{"$f":"SUM(Fees!$J11:$Q11)","v":5051},2186,955,100,1130,445,null,235]
["Year 6",4210,{"$f":"+Fees!$J12*(1-$I$24)+SUM(Fees!$M12:$Q12)","v":2587},{"$f":"+Fees!$J12*(1-$I$25)+SUM(Fees!$M12:$Q12)","v":2303},{"$f":"+Fees!$J12*(1-$I$26)+SUM(Fees!$M12:$Q12)","v":2019},{"$f":"+Fees!$J12*(1-$I$27)+SUM(Fees!$M12:$Q12)","v":1735},null,"Year 6",{"$f":"SUM(Fees!$J12:$Q12)","v":4210},1420,955,100,900,495,null,235,105]
["Year 5",3940,{"$f":"+Fees!$J13*(1-$I$24)+SUM(Fees!$M13:$Q13)","v":2317},{"$f":"+Fees!$J13*(1-$I$25)+SUM(Fees!$M13:$Q13)","v":2033},{"$f":"+Fees!$J13*(1-$I$26)+SUM(Fees!$M13:$Q13)","v":1749},{"$f":"+Fees!$J13*(1-$I$27)+SUM(Fees!$M13:$Q13)","v":1465},null,"Year 5",{"$f":"SUM(Fees!$J13:$Q13)","v":3940},1420,955,100,900,225,null,235,105]
["Year 4",3715,{"$f":"+Fees!$J14*(1-$I$24)+SUM(Fees!$M14:$Q14)","v":2092},{"$f":"+Fees!$J14*(1-$I$25)+SUM(Fees!$M14:$Q14)","v":1808},{"$f":"+Fees!$J14*(1-$I$26)+SUM(Fees!$M14:$Q14)","v":1524},{"$f":"+Fees!$J14*(1-$I$27)+SUM(Fees!$M14:$Q14)","v":1240},null,"Year 4",{"$f":"SUM(Fees!$J14:$Q14)","v":3715},1420,955,100,900,null,null,235,105]
["Year 3",3400,{"$f":"+Fees!$J15*(1-$I$24)+SUM(Fees!$M15:$Q15)","v":1777},{"$f":"+Fees!$J15*(1-$I$25)+SUM(Fees!$M15:$Q15)","v":1493},{"$f":"+Fees!$J15*(1-$I$26)+SUM(Fees!$M15:$Q15)","v":1209},{"$f":"+Fees!$J15*(1-$I$27)+SUM(Fees!$M15:$Q15)","v":925},null,"Year 3",{"$f":"SUM(Fees!$J15:$Q15)","v":3400},1420,955,100,820,null,null,null,105]
["Year 2",3400,{"$f":"+Fees!$J16*(1-$I$24)+SUM(Fees!$M16:$Q16)","v":1777},{"$f":"+Fees!$J16*(1-$I$25)+SUM(Fees!$M16:$Q16)","v":1493},{"$f":"+Fees!$J16*(1-$I$26)+SUM(Fees!$M16:$Q16)","v":1209},{"$f":"+Fees!$J16*(1-$I$27)+SUM(Fees!$M16:$Q16)","v":925},null,"Year 2",{"$f":"SUM(Fees!$J16:$Q16)","v":3400},1420,955,100,820,null,null,null,105]
["Year 1",3400,{"$f":"+Fees!$J17*(1-$I$24)+SUM(Fees!$M17:$Q17)","v":1777},{"$f":"+Fees!$J17*(1-$I$25)+SUM(Fees!$M17:$Q17)","v":1493},{"$f":"+Fees!$J17*(1-$I$26)+SUM(Fees!$M17:$Q17)","v":1209},{"$f":"+Fees!$J17*(1-$I$27)+SUM(Fees!$M17:$Q17)","v":925},null,"Year 1",{"$f":"SUM(Fees!$J17:$Q17)","v":3400},1420,955,100,820,null,null,null,105]
["Prep",{"$f":"+I18","v":3400},{"$f":"+Fees!$J18*(1-$I$24)+SUM(Fees!$M18:$Q18)","v":1777},{"$f":"+Fees!$J18*(1-$I$25)+SUM(Fees!$M18:$Q18)","v":1493},{"$f":"+Fees!$J18*(1-$I$26)+SUM(Fees!$M18:$Q18)","v":1209},{"$f":"+Fees!$J18*(1-$I$27)+SUM(Fees!$M18:$Q18)","v":925},null,"Prep",{"$f":"SUM(Fees!$J18:$Q18)","v":3400},1420,955,100,820,null,null,null,105]
[]
["Weekly"]
["Fortnightly"]
["Monthly",null,null,null,null,null,null,"School Fee"]
["Quarterly",null,null,null,null,null,null,"Family Discounts",2025]
[null,null,null,null,null,null,null,"2nd Child",0.4]
[null,null,null,null,null,null,null,"3rd Child",0.6]
[null,null,null,null,null,null,null,"4th Child",0.8]
[null,null,null,null,null,null,null,"5th Child",1]
["Start Date","2025-02-07"]
["End Date","2025-11-07"]
[]
["Weeks between dates",null,40]
["Fortnights between dates",null,20]
["Months between dates",null,10]

{"sheet":"Fees & Levies Schedule 2025","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Sheet1","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}