{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Fee Calculation - 2024"],"not_rendered":{"charts":0,"images":1,"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":"Fee Calculation - 2024","index":0,"n_rows":60,"n_cols":5,"rows_kept":60,"cut":false,"hidden":false,"merged":[[55,1,55,4],[1,1,1,4],[0,1,0,4],[54,1,54,3],[2,1,2,4]]}
[null,"ST JOSEPH'S PRIMARY SCHOOL"]
[null,"2024 - FEE CALCULATION WORKSHEET"]
[null,"Enter data in the blue sections ONLY.  Once complete, please save worksheet as a Excel document using your surname as the document name, and e-mail back to -  pkanfinance@bne.catholic.edu.au"]
[null,"Family Details","Student Name","Year Level"]
[null,"Student 1"]
[null,"Student 2 "]
[null,"Student 3 "]
[null,"Student 4 "]
["Fee Category","Description","Fee Schedule (charged per annum)","Number of Students","Annual Fee"]
["Tuition Fees","1 Child",2120,0,{"$f":"SUM(C10*D10)","v":0}]
[null,"2 Children",3392,0,{"$f":"SUM(C11*D11)","v":0}]
[null,"3 Children",4240,0,{"$f":"SUM(C12*D12)","v":0}]
[null,"4 Children or more",4664,0,{"$f":"SUM(C13*D13)","v":0}]
[]
["Capital Levy","Per Family ",620,1,{"$f":"SUM(C15*D15)","v":620}]
["P&F Levy","Per Family ",350,1,{"$f":"SUM(C16*D16)","v":350}]
[]
["Levies & Charges","Per Student"]
[null,"Resource Levy",300,0,{"$f":"SUM(C19*D19)","v":0}]
[null,"Sports Levy",150,0,0]
[null,"IT Levy - Prep To Year 6",150,0,0]
[null,"Excursion/Incursion Levy",190,0,0]
[]
["Prep ","Prep Levy",350,0,{"$f":"SUM(C24*D24)","v":0}]
["Additional Charges"]
["Inclusive Music Program","Prep to Year 2",100,0,{"$f":"SUM(C26*D26)","v":0}]
[null,"Year 3 to Year 6",120,0,0]
["1:1 Laptop/Ipad Program "]
["1:1 Laptop/Ipad Program ","Prep  ",250,0,{"$f":"SUM(C29*D29)","v":0}]
["1:1 Laptop/Ipad Program ","Year 1",250,0,0]
["1:1 Laptop/Ipad Program ","Year 2",250,0,0]
["1:1 Laptop/Ipad Program ","Year 3",300,0,0]
["1:1 Laptop/Ipad Program ","Year 4",370,0,0]
["1:1 Laptop Program","Year 5",495,0,0]
["1:1 Laptop Program ","Year 6",495,0,0]
[]
["Camps","Year 4 - Camp",220,0,{"$f":"SUM(C37*D37)","v":0}]
[null,"Year 5 - Camp",350,0,0]
[null,"Year 6 - Camp",350,0,0]
[]
["Instrumental Music Program","Please follow the enrolment process and complete enrolment"]
["Lessons - 35 Weeks for 2024","forms, submitting via email (as per Instrumental Music "]
[null,"Handbook)"]
[]
["35 Weeks","20 Minute Private Prep and Year 1 (Only) $32.00 per lesson",1120,0,{"$f":"SUM(C45*D45)","v":0}]
[null,"30 Minute - $42.00 per lesson",1470,0,{"$f":"SUM(C46*D46)","v":0}]
[null,"45 Minute - $57.00 per lesson",1938,0,{"$f":"SUM(C47*D47)","v":0}]
[null,"Group Lessons - 34 Weeks"]
[null,"Student Group - $37.00 per lesson",1258,0,{"$f":"SUM(C49*D49)","v":0}]
["Music Instrument Hire","$110 per Term ",440,0,{"$f":"SUM(C50*D50)","v":0}]
["Ensembles","Year 3-6 Choir - $20 per term",80,0,{"$f":"SUM(C51*D51)","v":0}]
[null,"All other Ensembles - $40 per term",160,0,{"$f":"SUM(C52*D52)","v":0}]
[]
[]
[null,"ANNUAL TOTAL FOR 2024",null,null,{"$f":"SUM(E10:E50)","v":970}]
[null,"Payment Schedule"]
[null,"Payment Frequency - Weekly (February to November)",null,"÷ 44 pmts",{"$f":"SUM(E55/44)","v":22.045454545454547}]
[null,"Payment Frequency - Fortnightly (February to November)",null,"÷ 22 pmts",{"$f":"SUM(E55/22)","v":44.090909090909093}]
[null,"Payment Frequency - Monthly  (February to November)",null,"÷  10  pmts",{"$f":"SUM(E55/10)","v":97}]
[null,"Payment Frequency - Term - 1st day of each term",null,"÷   4 pmts",{"$f":"SUM(E55/4)","v":242.5}]