{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Fee Calculation - 2026","Sheet1"],"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 - 2026","index":0,"n_rows":67,"n_cols":5,"rows_kept":67,"cut":false,"hidden":false,"merged":[[62,1,62,4],[1,1,1,4],[0,1,0,4],[61,1,61,3],[2,1,2,4]]}
[null,"ST JOSEPH'S PRIMARY SCHOOL"]
[null,"2026 - 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"]
["School Tuition Fees","1 Child",2404,{"$f":"IFERROR(IF(COUNTA($D$5:$D$8)=1,\"1\",),)","v":0},{"$f":"SUM(C10*D10)","v":0}]
[null,"2 Children",3848,{"$f":"IFERROR(IF(COUNTA($D$5:$D$8)=2,\"1\",),)","v":0},{"$f":"SUM(C11*D11)","v":0}]
[null,"3 Children",4808,{"$f":"IFERROR(IF(COUNTA($D$5:$D$8)=3,\"1\",),)","v":0},{"$f":"SUM(C12*D12)","v":0}]
[null,"4 Children or more",5288,{"$f":"IFERROR(IF(COUNTA($D$5:$D$8)=4,\"1\",),)","v":0},{"$f":"SUM(C13*D13)","v":0}]
[]
["Capital Levy","Per Family ",660,{"$f":"IFERROR(IF(COUNTA($D$5:$D$8)>0,\"1\",),)","v":0},{"$f":"SUM(C15*D15)","v":0}]
["P&F - Special Levy Parents ","Per Family ",385,{"$f":"IFERROR(IF(COUNTA($D$5:$D$8)>0,\"1\",),)","v":0},{"$f":"SUM(C16*D16)","v":0}]
["& Community"]
[]
["Levies & Charges (Prep to Year 6)","Per Student"]
[null,"Resource Levy",330,{"$f":"IFERROR(COUNTA($D$5:$D$8),)","v":0},{"$f":"SUM(C20*D20)","v":0}]
[null,"Sports Levy",165,{"$f":"IFERROR(COUNTA($D$5:$D$8),)","v":0},0]
[null,"IT Levy - Prep To Year 6",165,0,0]
[null,"Excursion/Incursion Levy",210,0,0]
[]
["Prep ","Prep Levy",385,{"$f":"IFERROR(COUNTIF($D$5:$D$8,\"Prep\"),)","v":0},{"$f":"SUM(C25*D25)","v":0}]
["Additional Charges"]
["Classroom Music & Dance Program","Prep to Year 2",110,{"$f":"IFERROR(COUNTIF($D$5:$D$8,\"Prep\")+ COUNTIF($D$5:$D$8,\"Year 1\")+COUNTIF($D$5:$D$8,\"Year 2\"),)","v":0},{"$f":"SUM(C27*D27)","v":0}]
[null,"Year 3 to Year 6",132,{"$f":"IFERROR(COUNTIF($D$5:$D$8,\"Year 3\")+ COUNTIF($D$5:$D$8,\"Year 4\")+COUNTIF($D$5:$D$8,\"Year 5\")+COUNTIF($D$5:$D$8,\"Year 6\"),)","v":0},0]
[]
["1:1 Laptop/Ipad Program "]
["1:1 Laptop/Ipad Program ","Prep  ",275,{"$f":"IFERROR(COUNTIF($D$5:$D$8,\"Prep\"),)","v":0},0]
["1:1 Laptop/Ipad Program ","Year 1",275,{"$f":"IFERROR(COUNTIF($D$5:$D$8,B32),)","v":0},0]
["1:1 Laptop/Ipad Program ","Year 2",275,{"$f":"IFERROR(COUNTIF($D$5:$D$8,B33),)","v":0},0]
["1:1 Laptop/Ipad Program ","Year 3",330,0,0]
["1:1 Laptop/Ipad Program ","Year 4",407,0,0]
["1:1 Laptop Program","Year 5",545,0,0]
["1:1 Laptop Program ","Year 6",545,0,0]
[]
["Camps","Year 4 - Camp ",250,{"$f":"IFERROR(COUNTIF($D$5:$D$8,\"Year 4\"),)","v":0},{"$f":"SUM(C39*D39)","v":0}]
[null,"Year 5 - Camp",400,{"$f":"IFERROR(COUNTIF($D$5:$D$8,\"Year 5\"),)","v":0},0]
[null,"Year 6 - Camp",400,{"$f":"IFERROR(COUNTIF($D$5:$D$8,\"Year 6\"),)","v":0},0]
[]
["Performing Arts Program","SCHEDULE OF CHARGES 2026"]
[]
["MUSIC PROGRAM","MUSIC / Lessons - 34 Weeks for 2026"]
[]
[null,"20 Minute - Prep and Year 1 (only) $300.00 per Term",1200,null,{"$f":"SUM(C47*D47)","v":0}]
[null,"30 Minute - Prep to Year 6 / $390.00 per Term",1560,null,{"$f":"SUM(C48*D48)","v":0}]
[null,"Shared Music Group / Max - 2 Students Only"]
[null,"$300.00 per Term",1200,null,{"$f":"SUM(C50*D50)","v":0}]
[]
[null,"Music Instrument Hire /  $ 90.00 per Term",360,null,{"$f":"SUM(C52*D52)","v":0}]
[]
[null,"MUSIC Annual Levy - Students Levy $25 per Term",100,null,{"$f":"SUM(C54*D54)","v":0}]
[]
["DANCE PROGRAM","DANCE / Lessons 34 Weeks for 2026"]
[]
[null,"75 Minute group Lesson / $200 per Term",800,null,{"$f":"SUM(C58*D58)","v":0}]
[]
[null,"DANCE Annual Levy $12.50 per Term",50,null,{"$f":"SUM(C60*D60)","v":0}]
[]
[null,"ANNUAL TOTAL FOR 2026",null,null,{"$f":"SUM(E10:E60)","v":0}]
[null,"Payment Schedule"]
[null,"Payment Frequency - Weekly (February to November)",null,"÷ 44 pmts",{"$f":"SUM(E62/44)","v":0}]
[null,"Payment Frequency - Fortnightly (February to November)",null,"÷ 22 pmts",{"$f":"SUM(E62/22)","v":0}]
[null,"Payment Frequency - Monthly  (February to November)",null,"÷  10  pmts",{"$f":"SUM(E62/10)","v":0}]
[null,"Payment Frequency - Term - 1st day of each term",null,"÷   4 pmts",{"$f":"SUM(E62/4)","v":0}]

{"sheet":"Sheet1","index":1,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Prep"]
[null,"Year 1"]
[null,"Year 2"]
[null,"Year 3"]
[null,"Year 4"]
[null,"Year 5"]
[null,"Year 6"]