{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["1. Instructions","2. Fee Calculation","Sheet1","Workings"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":7,"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":"1. Instructions","index":0,"n_rows":21,"n_cols":1,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Instructions for Use of Worksheet"]
[]
["The intention of this worksheet is to assist with the calculation of the yearly school fees and the set up of automatic payments - i.e. Direct Debits, Bpoint. "]
[]
["To begin, click on the  worksheet tab \"2. Fee Calculation\" and complete the form using the following instructions."]
[]
["1. Complete the student details section - Use the drop down box to select the grade. Fill this out for each student."]
[]
["2. Applying relevant fees and charges. In the cells shaded green, click on the cell to use the drop down option feature to select fees and charges applicable to your student/s. e.g. Select 1 for one student ect. "]
[]
["3. In the \"Payment Options\" section, use the tickbox feature to select a payment frequency. "]
[]
["4. Under the Voluntary Contributions section, use the tickbox feature to choose to make Voluntary Contributions"]
[]
["5. Choose a payment method ie. Direct Debit or Bpoint"]
[]
["5. The amount at the bottom of the worksheet is the calculated payment amount based on your charges and payment frequency. Use these details when filling out your Bpoint or Direct Debit forms."]
[]
["6. If paying by Direct Debit or Bpoint, use the print funciton to print this worksheet and return it with the relevant Direct Debit/Bpoint forms to the school office"]
[]
["7. If paying by Bpay there is no need to return this form but please advise the school if making Building Fund and Library Fund contributions."]

{"sheet":"2. Fee Calculation","index":1,"n_rows":47,"n_cols":9,"rows_kept":47,"cut":false,"hidden":false,"merged":[[46,1,46,5],[33,1,33,2],[34,1,34,2],[35,1,35,2],[29,1,29,4],[32,1,32,2],[43,1,44,1],[40,2,40,3],[41,2,41,3],[37,1,37,5],[38,1,38,2],[39,1,39,2],[30,1,30,5],[36,1,36,2],[0,1,0,5],[1,1,1,5],[23,1,23,2],[16,1,16,2],[9,1,10,2],[12,1,12,2],[11,1,11,2],[14,1,15,2],[17,1,17,2],[22,1,22,2],[3,1,3,5],[21,1,21,2],[18,1,18,2],[19,1,19,2],[25,1,25,2],[26,1,26,2],[31,1,31,5],[27,1,27,2],[24,1,24,2]]}
[null,"St Andrew's School"]
[null," Fee & Payment Calculation Worksheet - 2020"]
[]
[null,"                                "]
[null,null,"Student #1","Student #2","Student #3","Student #4"]
[null,"Student's First Name:"]
[null,"Student's Surname:"]
[null,"Grade 2020"]
[]
[null,"FIXED FEES PER ANNUM",null,"Fee Schedule\n(Annual)","Number of Students","$"]
[]
[]
[null,"2019 School Fees (inc. Fees, Capital Levy & Grounds Levy)",null,null,null,{"$f":"IF(E13=1, Workings!F3, \"0\")+IF(E13=2, Workings!F4, \"0\")+IF(OR(E13=3,E13=4), Workings!F5, \"0\")","v":0}]
[]
[null,"Additional Charges & Levies",null,"Fee Schedule\n(Annual)",null,"$"]
[]
[null,"(only select charges applicable to your child/children)"]
["   ","Prep Resource Levy - per child in prep",null,270,null,{"$f":"D18*SUM(E18:E18)","v":0}]
[null,"Year 1 Resource Levy - per child in Year 1",null,90,null,{"$f":"D19*SUM(E19:E19)","v":0}]
[null,"Year 2 Resource Levy - per child in Year 2",null,90,null,0]
[null,"Year 3 Resource Levy - per child in Year 3",null,90,null,0]
[null,"Technology Device Levies"]
[null,"        Year 6 iPad Levy - (do not tick if levies were paid upfront)",null,316.8,null,{"$f":"D23*SUM(E23:E23)","v":0}]
[null,"        Year 5 iPad Levy - (do not tick if levies were paid upfront)",null,321.2,null,{"$f":"D24*SUM(E24:E24)","v":0}]
[null,"        Year 4 Device Levy",null,321.2,null,{"$f":"D25*SUM(E25:E25)","v":0}]
[null,"Gala Sports Levy - per child in Year's 3-6                       ",null,40,null,{"$f":"D26*SUM(E26:E26)","v":0}]
[null,"School Camps - Year 5 & 6 - Students only",null,240,null,{"$f":"D27*SUM(E27:E27)","v":0}]
[null,"Instrumental Music Program - (Places offered from Yr 4)",null,800,null,0]
[null,"Adjustment for IMP Deposit (only tick if deposit was paid)",null,-80,null,{"$f":"(D29*E28)*Workings!E29","v":0}]
[null,null,null,null,null,{"$f":"SUM(F13:F29)","v":0}]
[]
[null,"PAYMENT OPTIONS"]
[null,"DIRECT DEBIT OR BPOINT PAYMENTS - Authority must be held by the school",null,null,"Please select one payment option"]
[null,"Payment Frequency - Monthly - February to November",null,10,null,{"$f":"(F30/D34+SUM(F39:F40)/10)*Workings!A24","v":0}]
[null,"Payment Frequency - Quarterly - 5 Feb, 5 May, 5 Aug, 5 Nov",null,4,null,{"$f":"(F30/D35+SUM(F39:F40)/4)*Workings!A25","v":0}]
[null,"Payment Frequency - other (please contact School Office)",null,1,null,{"$f":"(F30/D36+SUM(F39:F40)/D36)*Workings!A32","v":0}]
[null,"ALL OTHER OPTIONS - FEES TO BE PAID IN FULL EACH TERM",null,4,null,{"$f":"(F30/D37+SUM(F39:F40)/4)*Workings!A33","v":0}]
[null,"Tax-deductible Voluntary Contributions - optional"]
[null,"Building Fund Contribution - annually",null,160,null,{"$f":"Workings!A28*D39","v":0}]
[null,"Library Fund Contribution - annually",null,160,null,{"$f":"Workings!A29*D40","v":0}]
[]
[null,"I expect to pay by (please make selection):",null,null,null,null,null,null,""]
[]
[null,"Amount calculated from Payment Options section above",{"$f":"F34","v":0},"Monthly (x10)","Direct debit & Bpoint only"]
[null,null,{"$f":"F35","v":0},"Quarterly (x4)"]
[null,null,{"$f":"F36","v":0},"Other (please contact school office)"]
[null,"If you have any questions regarding this form, please do not hesitate to contact the school office."]

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

{"sheet":"Workings","index":3,"n_rows":33,"n_cols":6,"rows_kept":33,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,null,null,"No. of Students","Fee"]
[null,null,null,null,1,2949]
[null,null,null,null,2,4304]
[null,null,null,null,3,5545]
[null,null,null,null,4,5545]
[]
[null,"Year Levels"]
[null,"Prep"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[]
[]
[null,null,null,null,null,"Payment Options"]
[null,null,null,null,null,"Direct Debit"]
[null,null,null,null,null,"Bpoint-Authority held"]
[]
[]
[]
[false]
[false]
[]
[]
[false]
[false,null,null,null,false]
[]
[]
[false]
[false]