{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Calculate Fees","Fees","Fees & Levies Schedule 2023","Sheet1"],"not_rendered":{"charts":0,"images":5,"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]]}
["2023 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 11. 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}]
[null,"Add additional costs if applicable"]
[null,"Total Fees ",{"$f":"C11+C10","v":0}]
[null,"Start Date","2023-01-27"]
[null,"End Date","2023-10-27"]
[]
["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":17,"rows_kept":33,"cut":false,"hidden":true,"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"]
["Year 12",{"$f":"+I6","v":5387},{"$f":"+Fees!$J6*(1-$I$24)+SUM(Fees!$M6:$Q6)","v":3170.5749999999998},{"$f":"+Fees!$J6*(1-$I$25)+SUM(Fees!$M6:$Q6)","v":2846.1949999999997},{"$f":"+Fees!$J6*(1-$I$26)+SUM(Fees!$M6:$Q6)","v":2533.4},{"$f":"+Fees!$J6*(1-$I$27)+SUM(Fees!$M6:$Q6)","v":2070},null,"Year 12",{"$f":"SUM(Fees!$J6:$Q6)","v":5387},2317,900,100,1520,null,null,550]
["Year 11",5737,{"$f":"+Fees!$J7*(1-$I$24)+SUM(Fees!$M7:$Q7)","v":3520.5749999999998},{"$f":"+Fees!$J7*(1-$I$25)+SUM(Fees!$M7:$Q7)","v":3196.1949999999997},{"$f":"+Fees!$J7*(1-$I$26)+SUM(Fees!$M7:$Q7)","v":2883.4},{"$f":"+Fees!$J7*(1-$I$27)+SUM(Fees!$M7:$Q7)","v":2420},null,"Year 11",{"$f":"SUM(Fees!$J7:$Q7)","v":5737},2317,900,100,1520,350,null,550]
["Year 10",5387,{"$f":"+Fees!$J8*(1-$I$24)+SUM(Fees!$M8:$Q8)","v":3170.5749999999998},{"$f":"+Fees!$J8*(1-$I$25)+SUM(Fees!$M8:$Q8)","v":2846.1949999999997},{"$f":"+Fees!$J8*(1-$I$26)+SUM(Fees!$M8:$Q8)","v":2533.4},{"$f":"+Fees!$J8*(1-$I$27)+SUM(Fees!$M8:$Q8)","v":2070},null,"Year 10",{"$f":"SUM(Fees!$J8:$Q8)","v":5387},2317,900,100,1520,0,null,550]
["Year 9",4870,{"$f":"+Fees!$J9*(1-$I$24)+SUM(Fees!$M9:$Q9)","v":2788.5},{"$f":"+Fees!$J9*(1-$I$25)+SUM(Fees!$M9:$Q9)","v":2500.1},{"$f":"+Fees!$J9*(1-$I$26)+SUM(Fees!$M9:$Q9)","v":2222},{"$f":"+Fees!$J9*(1-$I$27)+SUM(Fees!$M9:$Q9)","v":1810},null,"Year 9",{"$f":"SUM(Fees!$J9:$Q9)","v":4870},2060,900,100,1100,500,null,210]
["Year 8",4755,{"$f":"+Fees!$J10*(1-$I$24)+SUM(Fees!$M10:$Q10)","v":2673.5},{"$f":"+Fees!$J10*(1-$I$25)+SUM(Fees!$M10:$Q10)","v":2385.1},{"$f":"+Fees!$J10*(1-$I$26)+SUM(Fees!$M10:$Q10)","v":2107},{"$f":"+Fees!$J10*(1-$I$27)+SUM(Fees!$M10:$Q10)","v":1695},null,"Year 8",{"$f":"SUM(Fees!$J10:$Q10)","v":4755},2060,900,100,1100,385,null,210]
["Year 7",4695,{"$f":"+Fees!$J11*(1-$I$24)+SUM(Fees!$M11:$Q11)","v":2613.5},{"$f":"+Fees!$J11*(1-$I$25)+SUM(Fees!$M11:$Q11)","v":2325.1},{"$f":"+Fees!$J11*(1-$I$26)+SUM(Fees!$M11:$Q11)","v":2047},{"$f":"+Fees!$J11*(1-$I$27)+SUM(Fees!$M11:$Q11)","v":1635},null,"Year 7",{"$f":"SUM(Fees!$J11:$Q11)","v":4695},2060,900,100,1100,325,null,210]
["Year 6",4384,{"$f":"+Fees!$J12*(1-$I$24)+SUM(Fees!$M12:$Q12)","v":2681.0250000000001},{"$f":"+Fees!$J12*(1-$I$25)+SUM(Fees!$M12:$Q12)","v":2493.5650000000001},{"$f":"+Fees!$J12*(1-$I$26)+SUM(Fees!$M12:$Q12)","v":2312.8000000000002},{"$f":"+Fees!$J12*(1-$I$27)+SUM(Fees!$M12:$Q12)","v":2045},null,"Year 6",{"$f":"SUM(Fees!$J12:$Q12)","v":4384},1339,900,100,880,850,null,210,105]
["Year 5",3819,{"$f":"+Fees!$J13*(1-$I$24)+SUM(Fees!$M13:$Q13)","v":2116.0250000000001},{"$f":"+Fees!$J13*(1-$I$25)+SUM(Fees!$M13:$Q13)","v":1928.5650000000001},{"$f":"+Fees!$J13*(1-$I$26)+SUM(Fees!$M13:$Q13)","v":1747.8},{"$f":"+Fees!$J13*(1-$I$27)+SUM(Fees!$M13:$Q13)","v":1480},null,"Year 5",{"$f":"SUM(Fees!$J13:$Q13)","v":3819},1339,900,100,880,285,null,210,105]
["Year 4",3534,{"$f":"+Fees!$J14*(1-$I$24)+SUM(Fees!$M14:$Q14)","v":1831.0250000000001},{"$f":"+Fees!$J14*(1-$I$25)+SUM(Fees!$M14:$Q14)","v":1643.5650000000001},{"$f":"+Fees!$J14*(1-$I$26)+SUM(Fees!$M14:$Q14)","v":1462.8},{"$f":"+Fees!$J14*(1-$I$27)+SUM(Fees!$M14:$Q14)","v":1195},null,"Year 4",{"$f":"SUM(Fees!$J14:$Q14)","v":3534},1339,900,100,880,null,null,210,105]
["Year 3",3244,{"$f":"+Fees!$J15*(1-$I$24)+SUM(Fees!$M15:$Q15)","v":1541.0250000000001},{"$f":"+Fees!$J15*(1-$I$25)+SUM(Fees!$M15:$Q15)","v":1353.5650000000001},{"$f":"+Fees!$J15*(1-$I$26)+SUM(Fees!$M15:$Q15)","v":1172.8},{"$f":"+Fees!$J15*(1-$I$27)+SUM(Fees!$M15:$Q15)","v":905},null,"Year 3",{"$f":"SUM(Fees!$J15:$Q15)","v":3244},1339,900,100,800,null,null,null,105]
["Year 2",3244,{"$f":"+Fees!$J16*(1-$I$24)+SUM(Fees!$M16:$Q16)","v":1541.0250000000001},{"$f":"+Fees!$J16*(1-$I$25)+SUM(Fees!$M16:$Q16)","v":1353.5650000000001},{"$f":"+Fees!$J16*(1-$I$26)+SUM(Fees!$M16:$Q16)","v":1172.8},{"$f":"+Fees!$J16*(1-$I$27)+SUM(Fees!$M16:$Q16)","v":905},null,"Year 2",{"$f":"SUM(Fees!$J16:$Q16)","v":3244},1339,900,100,800,null,null,null,105]
["Year 1",3244,{"$f":"+Fees!$J17*(1-$I$24)+SUM(Fees!$M17:$Q17)","v":1541.0250000000001},{"$f":"+Fees!$J17*(1-$I$25)+SUM(Fees!$M17:$Q17)","v":1353.5650000000001},{"$f":"+Fees!$J17*(1-$I$26)+SUM(Fees!$M17:$Q17)","v":1172.8},{"$f":"+Fees!$J17*(1-$I$27)+SUM(Fees!$M17:$Q17)","v":905},null,"Year 1",{"$f":"SUM(Fees!$J17:$Q17)","v":3244},1339,900,100,800,null,null,null,105]
["Prep",{"$f":"+I18","v":3244},{"$f":"+Fees!$J18*(1-$I$24)+SUM(Fees!$M18:$Q18)","v":1541.0250000000001},{"$f":"+Fees!$J18*(1-$I$25)+SUM(Fees!$M18:$Q18)","v":1353.5650000000001},{"$f":"+Fees!$J18*(1-$I$26)+SUM(Fees!$M18:$Q18)","v":1172.8},{"$f":"+Fees!$J18*(1-$I$27)+SUM(Fees!$M18:$Q18)","v":905},null,"Prep",{"$f":"SUM(Fees!$J18:$Q18)","v":3244},1339,900,100,800,null,null,null,105]
[]
["Weekly"]
["Fortnightly"]
["Monthly",null,null,null,null,null,null,"School Fee"]
["Quarterly",null,null,null,null,null,null,"Family Discounts",2023]
[null,null,null,null,null,null,null,"2nd Child",0.52500000000000002]
[null,null,null,null,null,null,null,"3rd Child",0.66500000000000004]
[null,null,null,null,null,null,null,"4th Child",0.8]
[null,null,null,null,null,null,null,"5th Child",1]
["Start Date","2023-01-27"]
["End Date","2023-10-27"]
[]
["Weeks between dates",null,40]
["Fortnights between dates",null,20]
["Months between dates",null,10]

{"sheet":"Fees & Levies Schedule 2023","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":[]}