{"text_format":"1","workbook":"xlsx","n_sheets":21,"sheets":["INDEX","Stage 1.1","Stage 1.2","Stage 2.1","Stage 2.2","Stage 2.3","Stage 2.4","Stage 2.5 Std","Stage 2.5 QS","Stage 2.6","Stage 2.7","Stage 2.8","Stage 2.9","Stage 3.1","Stage 3.2","Stage 3.3","Stage 3.4","Stage 3.5","Stage 4.1","Stage 4.2","Definitions"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":2,"defined_names":64,"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":"INDEX","index":0,"n_rows":28,"n_cols":8,"rows_kept":28,"cut":false,"hidden":false,"merged":[[0,1,0,4],[1,1,1,4]]}
[null,"SOUTH AUSTRALIA INDEPENDENT SCHOOLS BLOCK GRANT AUTHORITY"]
[null,"Round 2025 SAIS BGA Application for Capital Funding"]
[]
[null,null,"Application Help Notes"]
[]
[null,null,"STAGE 1 - NOTICE OF INTENT",null,null,null,null,"STAGE 3 FINANCIAL INFORMATION"]
[null,1.1000000000000001,"School/Campus Details",null,null,null,3.1,"Project Information and Financial Information (Refer 2.8 & 2.9)"]
[null,1.2,"Project Summary",null,null,null,3.2,"Debt Profile"]
[null,null,null,null,null,null,3.3,"Debt Details"]
[null,null,"STAGE 1 COMPLETED Upload via the BGA website ",null,null,null,3.4,"Other Balance Sheet Details"]
[null,null,"Go to MAKE AN APPLICATION and select Stage 1",null,null,null,3.5,"Enrolment Update (Refer 2.2) and Summary Ratios"]
[null,null,"Please save the worksheet using the following format SCHOOL NAME Stage 1.xlxm"]
[null,null,null,null,null,null,null,"STAGE 3 COMPLETED Upload via the BGA website "]
[null,null,"STAGE 2 - INITIAL APPLICATION",null,null,null,null,"Go to MAKE AN APPLICATION and select Stage 3"]
[null,2.1,"Project Details",null,null,null,null,"Please save the worksheet using the following format SCHOOL NAME Stage 3.xlxm"]
[null,2.2000000000000002,"Enrolments"]
[null,2.2999999999999998,"Enrolment Summary",null,null,null,null,"STAGE 4 FINAL DOCUMENTATION"]
[null,2.4,"Existing & Future Facilities",null,null,null,4.0999999999999996,"Update of Proposed Project Schedule and Funding"]
[null,"2.5 Std","Proposed Project 2.5 Std (Standard Costs)",null,null,null,4.2,"Final Documentation "]
[null,"2.5 QS","Proposed Project 2.5 QS (QS or Quotation Costs)"]
[null,2.6,"Project Funding "]
[null,2.7,"Area Summary",null,null,null,null,"STAGE 4 COMPLETED Upload via the BGA website "]
[null,2.8,"Capex Budget",null,null,null,null,"Go to MAKE AN APPLICATION and select Stage 4"]
[null,2.9,"Financial Forecast",null,null,null,null,"Please save the worksheet using the following format SCHOOL NAME Stage 4.xlxm"]
[]
[null,null,"STAGE 2 COMPLETED Upload via the BGA website "]
[null,null,"Go to MAKE AN APPLICATION and select Stage 2"]
[null,null,"Please save the worksheet using the following format SCHOOL NAME Stage 2.xlxm"]

{"sheet":"Stage 1.1","index":1,"n_rows":73,"n_cols":3,"rows_kept":73,"cut":false,"hidden":false,"merged":[[51,1,51,2],[72,1,72,2],[71,1,71,2],[70,1,70,2],[66,1,66,2]]}
[null,"SOUTH AUSTRALIA INDEPENDENT SCHOOLS BLOCK GRANT AUTHORITY"]
[null,"Stage 1 NOTICE OF INTENT "]
[]
[null,"1.1 Application School/Campus Detail"]
[]
[null,"Details of the School or Campus where the project will be undertaken.  "]
[null,"A) School Information"]
[null,"Australian Government Education ID (AGEID):"]
[null,"School Name:"]
[null,"Street Address:"]
[null,"Suburb/Town/City:"]
[null,"Postcode:"]
[null,"Telephone:"]
[null,"Postal Street Address:"]
[null,"Postal Suburb/Town/City:"]
[null,"Postal Postcode:"]
[null,"Principal:"]
[null,"Principal Email Address:"]
[null,"Year School Commenced:"]
[]
[null,"B) Main Contact Information for Project"]
[null,"Applicant School Main Contact Person:"]
[null,"Position:"]
[null,"Telephone:"]
[null,"Mobile Phone:"]
[null,"Email:"]
[]
[null,"C) School Type (select all that apply)"]
[null,"Early Learning Centre:","Select from list"]
[null,"Reception:","Select from list"]
[null,"Primary (1-6):","Select from list"]
[null,"Secondary (7-12):","Select from list"]
[null,"Boys Only:","Select from list"]
[null,"Girls Only:","Select from list"]
[null,"Co-Educational:","Select from list"]
[null,"Overseas Students:","Select from list"]
[null,"Boarding:","Select from list"]
[null,"Special Assistance School:","Select from list"]
[null,"MATSIS:","Select from list"]
[null,"Special School:","Select from list"]
[]
[null,"D) Direct Measure of Income (DMI)"]
[null,"DMI: "]
[]
[null,"E) Property Ownership/Leasing Arrangements for the project site"]
[null,"Is the site owned by the school or Approved Authoity or leased?"]
[null,"If leased, please state the name of the owner:"]
[null,"If owned, please state the name of the owner:"]
[null,"Area of site (in hectares):"]
[null,"If leased, lease expiry year:"]
[]
[null,"Please note a school must have a Master Plan or in the process of preparing a Master Plan prior to applying for Capital Grant funding. "]
[null,"F) Master Plan"]
[null,"Do you have a Master Plan? "]
[null,"If yes, what year was the plan prepared?"]
[null,"If yes, is the plan still current and does it fit with the schools future planning?"]
[null,"If no, are you in the process of having a Master Plan prepared?","Yes"]
[null,"If yes, provide name of firm contracted to prepare the updated/new Master Plan?"]
[]
[null,"G) General Questions"]
[null,"Name of School Insurer:"]
[null,"Is the school registered with the Education Standards Board?"]
[null,"Does your school receive recurrent funding from the Australian Government?"]
[null,"Does the school have a Facilities (Asset) Management Plan?"]
[null,"Is there a local council limitation on student numbers on your site?"]
[]
[null,"H) NCCD Students - in the current year, how many students at the school are considered:"]
[null,"Supplementary - enter number:"]
[null,"Substantial - enter number:"]
[null,"Extensive - enter number:"]
[null,"Has there been significant changes in the number of students with diverse needs over the past 12 months that this project will accommodate.  Briefly provide detail below. "]
[]
[null,"The school will be asked to provide the visiting BGA Panel a copy of the Facilities Management Plan during the school visit in Feb-Mar. "]

{"sheet":"Stage 1.2","index":2,"n_rows":74,"n_cols":5,"rows_kept":74,"cut":false,"hidden":false,"merged":[[2,2,2,3],[73,1,73,3],[66,1,66,2],[67,1,67,2],[68,1,68,2],[69,1,69,2],[70,1,70,2],[60,1,60,2],[62,1,62,3],[63,1,63,2],[64,1,64,2],[65,1,65,2],[55,1,55,2],[9,2,9,3],[10,2,10,3],[11,2,11,3],[74,1,74,3],[12,2,12,3],[23,1,23,2],[24,1,24,2],[52,1,52,3],[53,1,53,2],[54,1,54,2],[56,1,56,2],[57,1,57,2],[58,1,58,2],[59,1,59,2],[71,1,71,2],[72,1,72,2]]}
[null,"SOUTH AUSTRALIA INDEPENDENT SCHOOLS BLOCK GRANT AUTHORITY"]
[null,"Stage 1 NOTICE OF INTENT "]
[null,"School Name",{"$f":"'Stage 1.1'!SchoolName","v":0}]
[null,"AGEID",{"$f":"'Stage 1.1'!ageid","v":0}]
[null,"1.2 Project Details "]
[]
[null,"A) Brief Description of Proposed Project  Please refer to the Help Notes for an example \"Project Description\". "]
[null,"The details shown in the description below are automatically included in StagesE 2.1, 3.1 & 4.1. Use the buttons to view the details on those sheets. "]
[null,"Type of work involved","Describe what will be achieved"]
[]
[]
[]
[]
[null,"B) Indicate if any of the following will be applicable to the project"]
[null,"Demolition:",null,"Select from list"]
[null,"Siteworks:",null,"Select from list"]
[null,"Furniture:",null,"Select from list"]
[null,"Equipment:",null,"Select from list"]
[null,"Professional Fees:",null,"Select from list"]
[null,"Air-Conditioning",null,"Select from list"]
[null,"C) Provide Details of Proposed Project & Location"]
[null,"Project Location:",null,{"$f":"SITESUB","v":0}]
[null,"AGEID:",null,{"$f":"'Stage 1.1'!ageid","v":0}]
[null,"Will the project impact on previous projects funded by the BGA (Capital, BER, TTC etc):",null,"Select from list"]
[null,"Will it affect the national estate value of a place in the Register  of the National Estate:",null,"Select from list"]
[null,"D) Facilities are for (select all that apply)"]
[null,"ELC:"]
[null,"Primary R-6:"]
[null,"Junior Secondary 7-9:"]
[null,"Senior Secondary 10-12:"]
[null,"Combined:"]
[null,"2025 Enrolments:"]
[null,"E) Proposed Construction Schedule"]
[null,"Construction to commence:"]
[null,"Construction to finish:"]
[null,"F) Estimated Costing"]
[null,"Please show ESTIMATED costing for the project. Whole dollars only."]
[null,"Construction Cost:   (Include demolition, siteworks etc)"]
[null,"Refurbishment Cost:"]
[null,"Estimated Furniture & Equipment Cost:"]
[null,"Professional Fees:"]
[null,"Air-Conditioning:"]
[null,"Other Costs:"]
[null,null,"ESTIMATED TOTAL PROJECT COST",{"$f":"SUM(D38:D43)","v":0}]
[]
[null,null,"THE SCHOOL'S PROPOSED BGA CONTRIBUTION"]
[null,null,"Percentage of Project Cost ",{"$f":"D46/D44*100","v":{"$error":"#DIV/0!"}},"%"]
[]
[null,null,"PROPOSED SCHOOL CONTRIBUTION",{"$f":"D44-D46","v":0}]
[null,null,"Percentage of Project Cost ",{"$f":"D49/D44*100","v":{"$error":"#DIV/0!"}},"%"]
[null,"1.2 Project Details "]
[null,"G) Justification"]
[null,"Education need for eligible projects can extend from one or more of the following reasons.  Please select \"Yes\" in the drop down menu to indicated the primary justification  for your proposed project:"]
[null,"1. School growth leading to need for additional (new) facilities"]
[null,"2. Curriculum or syllabus change requiring different physical facilities"]
[null,"3. Curriculum expansion resulting from strategic decision making and/or student demand leading to need for different or additional facilities"]
[null,"4. Facilities reaching end of life - that is, are no longer fit for purpose"]
[null,"5. Facilities no longer fit for purpose but not at end of life"]
[null,"6. Pedagogical change within the school leading to a need for different and/or additional facilities"]
[null,"7. Changes in student characteristics leading to required changes in curriculum "]
[null,"8. Well-informed changes in community expectations about facility standards, characteristics and physical environments."]
[]
[null,"Schools are required to identify one or more of the following expected outcomes:"]
[null,"a) providing a better learning environment"]
[null,"b) addressing and area of particular educational disadvantage"]
[null,"c) responding to new demographic or enrolment trends "]
[null,"d) supporting quality teaching"]
[null,"e) supporting parental and community engagement"]
[null,"f) supporting safety for the school community"]
[null,"g) supporting the curriculum"]
[null,"h) supporting educational opportunities for indigenous students"]
[null,"I) supporting educational opportunities for students with special learning needs"]
[]
[null,"Please detail your justification in the area below.  To assist you to write the justification please consult the Help Notes. "]

{"sheet":"Stage 2.1","index":3,"n_rows":27,"n_cols":3,"rows_kept":27,"cut":false,"hidden":false,"merged":[[2,2,2,3],[23,2,23,3],[8,2,8,3],[7,1,7,2]]}
[null,"SOUTH AUSTRALIA INDEPENDENT SCHOOLS BLOCK GRANT AUTHORITY"]
[null,"Stage 2 INITIAL APPLICATION"]
[null,"School Name",{"$f":"'Stage 1.1'!SchoolName","v":0}]
[null,"AGEID",{"$f":"'Stage 1.1'!ageid","v":0}]
[null,"2.1 Project Details"]
[]
[null,"A) Update the brief description of Proposed Project.  Please refer to the Help Notes for an example \"Project Description\". "]
[null,"Update the project description via Stage 1.2"]
[null,"Brief Description of project \n(from Stage 1.2)  Please update on 1.2 if necessary.",{"$f":"_xlfn.UNIQUE('Stage 1.2'!B10&\" \"&'Stage 1.2'!C10&\" \"&'Stage 1.2'!B11&\" \"&'Stage 1.2'!C11&\" \"&'Stage 1.2'!B12&\" \"&'Stage 1.2'!C12&\" \"&'Stage 1.2'!B13&\" \"&'Stage 1.2'!C13)","v":"       "}]
[null,"B) Select the Facility Types that best describe  the project (more than one can be selected)"]
[null,"General Learning Areas includes: Classrooms"]
[null,"Multi Purpose Hall includes: Classrooms"]
[null,"Library includes: Classrooms"]
[null,"Subject specific includes: Science language, performing arts, technology, IT"]
[null,"Administration includes: Sick bay, meeting rooms, staff room"]
[null,"Vocational Teaching to Certificate Level"]
[null,"COLA permanent covered outdoor learning area"]
[null,"Boarding includes: Dormitory, kitchen, live-in staff accommodation"]
[null,"Special Needs includes: disability focus, for example lift, ramp"]
[null,"Grounds includes: shade, car park, bus bay, playground"]
[null,"Security includes: fencing, lighting:"]
[null,"Ancillary includes: amenities (toilets), pedestrian walkways, storage"]
[null,"Asbestos removal includes any additional costs/structural issues due to the presence of asbestos"]
[null,"Other (enter is space provided)"]
[]
[null,"C) Facilities are for which year Levels?"]
[null,"Please state what year levels the improved facilities would support?  E.g Years R-5, Years 11-12 etc"]

{"sheet":"Stage 2.2","index":4,"n_rows":43,"n_cols":19,"rows_kept":43,"cut":false,"hidden":false,"merged":[[2,3,2,11],[3,3,3,4]]}
[null,"SOUTH AUSTRALIA INDEPENDENT SCHOOLS BLOCK GRANT AUTHORITY"]
[null,"Stage 2 INITIAL APPLICATION"]
[null,"School Name",null,{"$f":"'Stage 1.1'!SchoolName","v":0}]
[null,"AGEID",null,{"$f":"'Stage 1.1'!ageid","v":0}]
[null,"2.2 Enrolment Information"]
[]
[null,"A) School enrolment figures - enter data in this table"]
[null,"Year",null,"Rec",1,2,3,4,5,6,7,8,9,10,11,12,"Boarding","FFPOS","R-12"]
[null,2021,"FTE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D9:P9)","v":0}]
[null,"(Census)","Streams",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D10:P10)","v":0}]
[null,2022,"FTE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"(Census)","Streams",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,2023,"FTE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D13:R13)","v":0}]
[null,"(Census)","Streams",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,2024,"FTE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"(Budgeted)","Streams",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,2025,"FTE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"(Projected)","Streams",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,2026,"FTE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"(Projected)","Streams",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,2027,"FTE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"(Projected)","Streams",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,2028,"FTE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"(Projected)","Streams",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
[null,"B) Progression Rate from year to year"]
[null,"Year",null,"Rec",1,2,3,4,5,6,7,8,9,10,11,12,"Pri","Sec","Combined"]
[null,2021,"FTE",{"$f":"D9","v":0}]
[null,"(Census)","Streams",0]
[null,2022,"FTE",0,{"$f":"E11-D9","v":0},0,0,0,0,0,{"$f":"K11-J9","v":0},{"$f":"L11-K9","v":0},0,0,0,0,{"$f":"SUM(E30:J30)","v":0},{"$f":"SUM(L30:P30)","v":0},{"$f":"SUM(E30:P30)","v":0}]
[null,"(Census)","Streams",0,{"$f":"E12-D10","v":0},{"$f":"F12-E10","v":0},0,0,0,0,0,{"$f":"L12-K10","v":0},0,0,0,0]
[null,2023,"FTE",0,0,{"$f":"F13-E11","v":0},0,0,0,0,{"$f":"K13-J11","v":0},{"$f":"L13-K11","v":0},{"$f":"M13-L11","v":0},0,0,0,{"$f":"SUM(E32:J32)","v":0},{"$f":"SUM(L32:P32)","v":0},{"$f":"SUM(E32:P32)","v":0}]
[null,"(Census)","Streams",0,0,{"$f":"F14-E12","v":0},0,0,0,0,0,0,0,0,0,0]
[null,2024,"FTE",0,0,{"$f":"F15-E13","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(E34:J34)","v":0},{"$f":"SUM(L34:P34)","v":0},{"$f":"SUM(E34:P34)","v":0}]
[null,"(Budgeted)","Streams",0,0,{"$f":"F16-E14","v":0},0,0,0,0,0,0,0,0,0,0]
[null,2025,"FTE",0,0,{"$f":"F17-E15","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(E36:J36)","v":0},{"$f":"SUM(L36:P36)","v":0},{"$f":"SUM(E36:P36)","v":0}]
[null,"(Projected)","Streams",0,0,{"$f":"F18-E16","v":0},0,0,0,0,0,0,0,0,0,0]
[null,2026,"FTE",0,0,{"$f":"F19-E17","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(E38:J38)","v":0},{"$f":"SUM(L38:P38)","v":0},{"$f":"SUM(E38:P38)","v":0}]
[null,"(Projected)","Streams",0,0,{"$f":"F20-E18","v":0},0,0,0,0,0,0,0,0,0,0]
[null,2027,"FTE",0,0,{"$f":"F21-E19","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(E40:J40)","v":0},{"$f":"SUM(L40:P40)","v":0},{"$f":"SUM(E40:P40)","v":0}]
[null,"(Projected)","Streams",0,0,{"$f":"F22-E20","v":0},0,0,0,0,0,0,0,0,0,0]
[null,2028,"FTE",0,0,{"$f":"F23-E21","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(E42:J42)","v":0},{"$f":"SUM(L42:P42)","v":0},{"$f":"SUM(E42:P42)","v":0}]
[null,"(Projected)","Streams",0,0,{"$f":"F24-E22","v":0},0,0,0,0,0,0,0,0,0,0]

{"sheet":"Stage 2.3","index":5,"n_rows":31,"n_cols":18,"rows_kept":31,"cut":false,"hidden":false,"merged":[[2,3,2,11],[3,3,3,4],[31,1,40,17]]}
[null,"SOUTH AUSTRALIA INDEPENDENT SCHOOLS BLOCK GRANT AUTHORITY"]
[null,"Stage 2 INITIAL APPLICATION"]
[null,"School Name",null,{"$f":"'Stage 1.1'!SchoolName","v":0}]
[null,"AGEID",null,{"$f":"'Stage 1.1'!ageid","v":0}]
[null,"2.3 Enrolment Summary"]
[]
[null,"A) Enrolment Totals",null,null,null,null,null,null,null,null,null,"Progression Rate"]
[null,"Year",null,"Primary","Jnr Sec","Snr Sec","Sec","Total ","Boarding","FFPOS",null,null,null,"Primary","Jnr Sec","Snr Sec","Sec","Total "]
[null,2021,"FTE",{"$f":"'Stage 2.2'!D9+'Stage 2.2'!E9+'Stage 2.2'!F9+'Stage 2.2'!G9+'Stage 2.2'!H9+'Stage 2.2'!I9+'Stage 2.2'!J9","v":0},{"$f":"'Stage 2.2'!K9+'Stage 2.2'!L9+'Stage 2.2'!M9+'Stage 2.2'!N9","v":0},{"$f":"'Stage 2.2'!O9+'Stage 2.2'!P9","v":0},{"$f":"SUM(E9:F9)","v":0},{"$f":"D9+G9","v":0},{"$f":"'Stage 2.2'!Q9","v":0},{"$f":"'Stage 2.2'!R9","v":0}]
[null,"(Census)","Streams",{"$f":"'Stage 2.2'!D10+'Stage 2.2'!E10+'Stage 2.2'!F10+'Stage 2.2'!G10+'Stage 2.2'!H10+'Stage 2.2'!I10+'Stage 2.2'!J10","v":0},{"$f":"'Stage 2.2'!K10+'Stage 2.2'!L10+'Stage 2.2'!M10+'Stage 2.2'!N10","v":0},{"$f":"'Stage 2.2'!O10+'Stage 2.2'!P10","v":0},{"$f":"SUM(E10:F10)","v":0},{"$f":"D10+G10","v":0}]
[null,2022,"FTE",{"$f":"'Stage 2.2'!D11+'Stage 2.2'!E11+'Stage 2.2'!F11+'Stage 2.2'!G11+'Stage 2.2'!H11+'Stage 2.2'!I11+'Stage 2.2'!J11","v":0},{"$f":"'Stage 2.2'!K11+'Stage 2.2'!L11+'Stage 2.2'!M11+'Stage 2.2'!N11","v":0},{"$f":"'Stage 2.2'!O11+'Stage 2.2'!P11","v":0},0,0,{"$f":"'Stage 2.2'!Q11","v":0},{"$f":"'Stage 2.2'!R11","v":0},null,2022,"FTE",{"$f":"D11-D9","v":0},{"$f":"E11-E9","v":0},{"$f":"F11-F9","v":0},{"$f":"G11-G9","v":0},{"$f":"H11-H9","v":0}]
[null,"(Census)","Streams",{"$f":"'Stage 2.2'!D12+'Stage 2.2'!E12+'Stage 2.2'!F12+'Stage 2.2'!G12+'Stage 2.2'!H12+'Stage 2.2'!I12+'Stage 2.2'!J12","v":0},{"$f":"'Stage 2.2'!K12+'Stage 2.2'!L12+'Stage 2.2'!M12+'Stage 2.2'!N12","v":0},{"$f":"'Stage 2.2'!O12+'Stage 2.2'!P12","v":0},0,0,null,null,null,"(Census)","Streams",0,0,0,0,0]
[null,2023,"FTE",{"$f":"'Stage 2.2'!D13+'Stage 2.2'!E13+'Stage 2.2'!F13+'Stage 2.2'!G13+'Stage 2.2'!H13+'Stage 2.2'!I13+'Stage 2.2'!J13","v":0},{"$f":"'Stage 2.2'!K13+'Stage 2.2'!L13+'Stage 2.2'!M13+'Stage 2.2'!N13","v":0},{"$f":"'Stage 2.2'!O13+'Stage 2.2'!P13","v":0},0,0,{"$f":"'Stage 2.2'!Q13","v":0},{"$f":"'Stage 2.2'!R13","v":0},null,2023,"FTE",0,0,0,0,0]
[null,"(Census)","Streams",{"$f":"'Stage 2.2'!D14+'Stage 2.2'!E14+'Stage 2.2'!F14+'Stage 2.2'!G14+'Stage 2.2'!H14+'Stage 2.2'!I14+'Stage 2.2'!J14","v":0},{"$f":"'Stage 2.2'!K14+'Stage 2.2'!L14+'Stage 2.2'!M14+'Stage 2.2'!N14","v":0},{"$f":"'Stage 2.2'!O14+'Stage 2.2'!P14","v":0},0,0,null,null,null,"(Census)","Streams",0,0,0,0,0]
[null,2024,"FTE",{"$f":"'Stage 2.2'!D15+'Stage 2.2'!E15+'Stage 2.2'!F15+'Stage 2.2'!G15+'Stage 2.2'!H15+'Stage 2.2'!I15+'Stage 2.2'!J15","v":0},{"$f":"'Stage 2.2'!K15+'Stage 2.2'!L15+'Stage 2.2'!M15+'Stage 2.2'!N15","v":0},{"$f":"'Stage 2.2'!O15+'Stage 2.2'!P15","v":0},0,0,{"$f":"'Stage 2.2'!Q15","v":0},{"$f":"'Stage 2.2'!R15","v":0},null,2024,"FTE",0,0,0,0,0]
[null,"(Budgeted)","Streams",{"$f":"'Stage 2.2'!D16+'Stage 2.2'!E16+'Stage 2.2'!F16+'Stage 2.2'!G16+'Stage 2.2'!H16+'Stage 2.2'!I16+'Stage 2.2'!J16","v":0},{"$f":"'Stage 2.2'!K16+'Stage 2.2'!L16+'Stage 2.2'!M16+'Stage 2.2'!N16","v":0},{"$f":"'Stage 2.2'!O16+'Stage 2.2'!P16","v":0},0,0,null,null,null,"(Budgeted)","Streams",0,0,0,0,0]
[null,2025,"FTE",{"$f":"'Stage 2.2'!D17+'Stage 2.2'!E17+'Stage 2.2'!F17+'Stage 2.2'!G17+'Stage 2.2'!H17+'Stage 2.2'!I17+'Stage 2.2'!J17","v":0},{"$f":"'Stage 2.2'!K17+'Stage 2.2'!L17+'Stage 2.2'!M17+'Stage 2.2'!N17","v":0},{"$f":"'Stage 2.2'!O17+'Stage 2.2'!P17","v":0},0,0,{"$f":"'Stage 2.2'!Q17","v":0},{"$f":"'Stage 2.2'!R17","v":0},null,2025,"FTE",0,0,0,0,0]
[null,"(Projected)","Streams",{"$f":"'Stage 2.2'!D18+'Stage 2.2'!E18+'Stage 2.2'!F18+'Stage 2.2'!G18+'Stage 2.2'!H18+'Stage 2.2'!I18+'Stage 2.2'!J18","v":0},{"$f":"'Stage 2.2'!K18+'Stage 2.2'!L18+'Stage 2.2'!M18+'Stage 2.2'!N18","v":0},{"$f":"'Stage 2.2'!O18+'Stage 2.2'!P18","v":0},0,0,null,null,null,"(Projected)","Streams",0,0,0,0,0]
[null,2026,"FTE",{"$f":"'Stage 2.2'!D19+'Stage 2.2'!E19+'Stage 2.2'!F19+'Stage 2.2'!G19+'Stage 2.2'!H19+'Stage 2.2'!I19+'Stage 2.2'!J19","v":0},{"$f":"'Stage 2.2'!K19+'Stage 2.2'!L19+'Stage 2.2'!M19+'Stage 2.2'!N19","v":0},{"$f":"'Stage 2.2'!O19+'Stage 2.2'!P19","v":0},0,0,{"$f":"'Stage 2.2'!Q19","v":0},{"$f":"'Stage 2.2'!R19","v":0},null,2026,"FTE",0,0,0,0,0]
[null,"(Projected)","Streams",{"$f":"'Stage 2.2'!D20+'Stage 2.2'!E20+'Stage 2.2'!F20+'Stage 2.2'!G20+'Stage 2.2'!H20+'Stage 2.2'!I20+'Stage 2.2'!J20","v":0},{"$f":"'Stage 2.2'!K20+'Stage 2.2'!L20+'Stage 2.2'!M20+'Stage 2.2'!N20","v":0},{"$f":"'Stage 2.2'!O20+'Stage 2.2'!P20","v":0},0,0,null,null,null,"(Projected)","Streams",0,0,0,0,0]
[null,2027,"FTE",{"$f":"'Stage 2.2'!D21+'Stage 2.2'!E21+'Stage 2.2'!F21+'Stage 2.2'!G21+'Stage 2.2'!H21+'Stage 2.2'!I21+'Stage 2.2'!J21","v":0},{"$f":"'Stage 2.2'!K21+'Stage 2.2'!L21+'Stage 2.2'!M21+'Stage 2.2'!N21","v":0},{"$f":"'Stage 2.2'!O21+'Stage 2.2'!P21","v":0},0,0,{"$f":"'Stage 2.2'!Q21","v":0},{"$f":"'Stage 2.2'!R21","v":0},null,2027,"FTE",0,0,0,0,0]
[null,"(Projected)","Streams",{"$f":"'Stage 2.2'!D22+'Stage 2.2'!E22+'Stage 2.2'!F22+'Stage 2.2'!G22+'Stage 2.2'!H22+'Stage 2.2'!I22+'Stage 2.2'!J22","v":0},{"$f":"'Stage 2.2'!K22+'Stage 2.2'!L22+'Stage 2.2'!M22+'Stage 2.2'!N22","v":0},{"$f":"'Stage 2.2'!O22+'Stage 2.2'!P22","v":0},0,0,null,null,null,"(Projected)","Streams",0,0,0,0,0]
[null,2028,"FTE",{"$f":"'Stage 2.2'!D23+'Stage 2.2'!E23+'Stage 2.2'!F23+'Stage 2.2'!G23+'Stage 2.2'!H23+'Stage 2.2'!I23+'Stage 2.2'!J23","v":0},{"$f":"'Stage 2.2'!K23+'Stage 2.2'!L23+'Stage 2.2'!M23+'Stage 2.2'!N23","v":0},{"$f":"'Stage 2.2'!O23+'Stage 2.2'!P23","v":0},0,0,{"$f":"'Stage 2.2'!Q23","v":0},{"$f":"'Stage 2.2'!R23","v":0},null,2028,"FTE",0,0,0,0,0]
[null,"(Projected)","Streams",{"$f":"'Stage 2.2'!D24+'Stage 2.2'!E24+'Stage 2.2'!F24+'Stage 2.2'!G24+'Stage 2.2'!H24+'Stage 2.2'!I24+'Stage 2.2'!J24","v":0},{"$f":"'Stage 2.2'!K24+'Stage 2.2'!L24+'Stage 2.2'!M24+'Stage 2.2'!N24","v":0},{"$f":"'Stage 2.2'!O24+'Stage 2.2'!P24","v":0},0,0,null,null,null,"(Projected)","Streams",0,0,0,0,0]
[]
[null,"B) Early Learning Centre"]
[null,"Is an ELC attached to your School?"]
[null,"If no, do you have an arrangement with a local ELC as a feeder for your school?"]
[null,"What is the expected conversion from ELC to Reception in 2024?"]
[]
[null,"B) Outline the basis of enrolment projections (e.g. based on deposits paid, birth rates, population growth etc)"]

{"sheet":"Stage 2.4","index":6,"n_rows":93,"n_cols":14,"rows_kept":93,"cut":false,"hidden":false,"merged":[[95,1,95,2],[95,4,95,7],[92,1,92,2],[93,1,93,2],[94,1,94,2],[92,11,92,13],[93,11,93,13],[94,11,94,13],[95,11,95,13],[101,5,101,9],[93,4,93,7],[94,4,94,7],[93,8,93,10],[94,8,94,10],[95,8,95,10],[92,4,92,7],[92,8,92,10],[5,1,5,14],[91,1,91,2],[86,1,86,14],[87,1,87,13],[88,1,88,13],[90,1,90,13],[91,11,91,13],[7,2,7,13],[91,4,91,7],[91,8,91,10]]}
[null,"SOUTH AUSTRALIA INDEPENDENT SCHOOLS BLOCK GRANT AUTHORITY"]
[null,"Stage 2 INITIAL APPLICATION"]
[null,"School Name",null,{"$f":"'Stage 1.1'!SchoolName","v":0}]
[null,"AGEID",null,{"$f":"'Stage 1.1'!ageid","v":0}]
[null,"2.4 Existing Facilities & Future Facilities"]
[]
[null,"A) Existing Facilities & Future Facilities"]
[null," ","PLEASE NOTE:  Do not include the proposed project if it is for New Construction, however areas that are currently being used but are to be refurbished as part of the Proposed Project MUST be included below."]
[]
[null,null,"Facility Description","Facility ID Code","Nature of Facility","Sector","No of Units","Total Area (m2)","Condition of facilities","BER","Is facility to be used in 2024","Is facility to be used in 2026","Counted Area 2024 (m2)","Counted Area 2026 (m2)"]
[null,1,null,"-NONE-","-NONE-","-NONE-",null,null,"-NONE-","-NONE-","-NONE-","-NONE-",{"$f":"IF($K11=\"No\",0,IF(OR($J11=\"yes\",$D11=Definitions!$B$25,$D11=Definitions!$B$28,$D11=Definitions!$B$30,$D11=Definitions!$B$31,$D11=Definitions!$B$33),('Stage 2.4'!$H11*0),$H11))","v":0},{"$f":"IF($L11=\"No\",0,IF(OR($J11=\"yes\",$D11=Definitions!$B$25,$D11=Definitions!$B$28,$D11=Definitions!$B$30,$D11=Definitions!$B$31,$D11=Definitions!$B$33),('Stage 2.4'!$H11*0),$H11))","v":0}]
[null,2,null,"-NONE-","-NONE-","-NONE-",null,null,"-NONE-","-NONE-","-NONE-","-NONE-",{"$f":"IF($K12=\"No\",0,IF(OR($J12=\"yes\",$D12=Definitions!$B$25,$D12=Definitions!$B$28,$D12=Definitions!$B$30,$D12=Definitions!$B$31,$D12=Definitions!$B$33),('Stage 2.4'!$H12*0),$H12))","v":0},{"$f":"IF($L12=\"No\",0,IF(OR($J12=\"yes\",$D12=Definitions!$B$25,$D12=Definitions!$B$28,$D12=Definitions!$B$30,$D12=Definitions!$B$31,$D12=Definitions!$B$33),('Stage 2.4'!$H12*0),$H12))","v":0}]
[null,3,null,"-NONE-","-NONE-","-NONE-",null,null,"-NONE-","-NONE-","-NONE-","-NONE-",{"$f":"IF($K13=\"No\",0,IF(OR($J13=\"yes\",$D13=Definitions!$B$25,$D13=Definitions!$B$28,$D13=Definitions!$B$30,$D13=Definitions!$B$31,$D13=Definitions!$B$33),('Stage 2.4'!$H13*0),$H13))","v":0},{"$f":"IF($L13=\"No\",0,IF(OR($J13=\"yes\",$D13=Definitions!$B$25,$D13=Definitions!$B$28,$D13=Definitions!$B$30,$D13=Definitions!$B$31,$D13=Definitions!$B$33),('Stage 2.4'!$H13*0),$H13))","v":0}]
[null,4,null,"-NONE-","-NONE-","-NONE-",null,null,"-NONE-","-NONE-","-NONE-","-NONE-",{"$f":"IF($K14=\"No\",0,IF(OR($J14=\"yes\",$D14=Definitions!$B$25,$D14=Definitions!$B$28,$D14=Definitions!$B$30,$D14=Definitions!$B$31,$D14=Definitions!$B$33),('Stage 2.4'!$H14*0),$H14))","v":0},{"$f":"IF($L14=\"No\",0,IF(OR($J14=\"yes\",$D14=Definitions!$B$25,$D14=Definitions!$B$28,$D14=Definitions!$B$30,$D14=Definitions!$B$31,$D14=Definitions!$B$33),('Stage 2.4'!$H14*0),$H14))","v":0}]
[null,5,null,"-NONE-","-NONE-","-NONE-",null,null,"-NONE-","-NONE-","-NONE-","-NONE-",{"$f":"IF($K15=\"No\",0,IF(OR($J15=\"yes\",$D15=Definitions!$B$25,$D15=Definitions!$B$28,$D15=Definitions!$B$30,$D15=Definitions!$B$31,$D15=Definitions!$B$33),('Stage 2.4'!$H15*0),$H15))","v":0},{"$f":"IF($L15=\"No\",0,IF(OR($J15=\"yes\",$D15=Definitions!$B$25,$D15=Definitions!$B$28,$D15=Definitions!$B$30,$D15=Definitions!$B$31,$D15=Definitions!$B$33),('Stage 2.4'!$H15*0),$H15))","v":0}]
[null,6,null,"-NONE-","-NONE-","-NONE-",null,null,"-NONE-","-NONE-","-NONE-","-NONE-",{"$f":"IF($K16=\"No\",0,IF(OR($J16=\"yes\",$D16=Definitions!$B$25,$D16=Definitions!$B$28,$D16=Definitions!$B$30,$D16=Definitions!$B$31,$D16=Definitions!$B$33),('Stage 2.4'!$H16*0),$H16))","v":0},{"$f":"IF($L16=\"No\",0,IF(OR($J16=\"yes\",$D16=Definitions!$B$25,$D16=Definitions!$B$28,$D16=Definitions!$B$30,$D16=Definitions!$B$31,$D16=Definitions!$B$33),('Stage 2.4'!$H16*0),$H16))","v":0}]
[null,7,null,"-NONE-","-NONE-","-NONE-",null,null,"-NONE-","-NONE-","-NONE-","-NONE-",{"$f":"IF($K17=\"No\",0,IF(OR($J17=\"yes\",$D17=Definitions!$B$25,$D17=Definitions!$B$28,$D17=Definitions!$B$30,$D17=Definitions!$B$31,$D17=Definitions!$B$33),('Stage 2.4'!$H17*0),$H17))","v":0},{"$f":"IF($L17=\"No\",0,IF(OR($J17=\"yes\",$D17=Definitions!$B$25,$D17=Definitions!$B$28,$D17=Definitions!$B$30,$D17=Definitions!$B$31,$D17=Definitions!$B$33),('Stage 2.4'!$H17*0),$H17))","v":0}]
[null,8,null,"-NONE-","-NONE-","-NONE-",null,null,"-NONE-","-NONE-","-NONE-","-NONE-",{"$f":"IF($K18=\"No\",0,IF(OR($J18=\"yes\",$D18=Definitions!$B$25,$D18=Definitions!$B$28,$D18=Definitions!$B$30,$D18=Definitions!$B$31,$D18=Definitions!$B$33),('Stage 2.4'!$H18*0),$H18))","v":0},{"$f":"IF($L18=\"No\",0,IF(OR($J18=\"yes\",$D18=Definitions!$B$25,$D18=Definitions!$B$28,$D18=Definitions!$B$30,$D18=Definitions!$B$31,$D18=Definitions!$B$33),('Stage 2.4'!$H18*0),$H18))","v":0}]
[null,9,null,"-NONE-","-NONE-","-NONE-",null,null,"-NONE-","-NONE-","-NONE-","-NONE-",{"$f":"IF($K19=\"No\",0,IF(OR($J19=\"yes\",$D19=Definitions!$B$25,$D19=Definitions!$B$28,$D19=Definitions!$B$30,$D19=Definitions!$B$31,$D19=Definitions!$B$33),('Stage 2.4'!$H19*0),$H19))","v":0},{"$f":"IF($L19=\"No\",0,IF(OR($J19=\"yes\",$D19=Definitions!$B$25,$D19=Definitions!$B$28,$D19=Definitions!$B$30,$D19=Definitions!$B$31,$D19=Definitions!$B$33),('Stage 2.4'!$H19*0),$H19))","v":0}]
[null,10,null,"-NONE-","-NONE-","-NONE-",null,null,"-NONE-","-NONE-","-NONE-","-NONE-",{"$f":"IF($K20=\"No\",0,IF(OR($J20=\"yes\",$D20=Definitions!$B$25,$D20=Definitions!$B$28,$D20=Definitions!$B$30,$D20=Definitions!$B$31,$D20=Definitions!$B$33),('Stage 2.4'!$H20*0),$H20))","v":0},{"$f":"IF($L20=\"No\",0,IF(OR($J20=\"yes\",$D20=Definitions!$B$25,$D20=Definitions!$B$28,$D20=Definitions!$B$30,$D20=Definitions!$B$31,$D20=Definitions!$B$33),('Stage 2.4'!$H20*0),$H20))","v":0}]
[null,11,null,"-NONE-","-NONE-","-NONE-",null,null,"-NONE-","-NONE-","-NONE-","-NONE-",{"$f":"IF($K21=\"No\",0,IF(OR($J21=\"yes\",$D21=Definitions!$B$25,$D21=Definitions!$B$28,$D21=Definitions!$B$30,$D21=Definitions!$B$31,$D21=Definitions!$B$33),('Stage 2.4'!$H21*0),$H21))","v":0},{"$f":"IF($L21=\"No\",0,IF(OR($J21=\"yes\",$D21=Definitions!$B$25,$D21=Definitions!$B$28,$D21=Definitions!$B$30,$D21=Definitions!$B$31,$D21=Definitions!$B$33),('Stage 2.4'!$H21*0),$H21))","v":0}]
[null,12,null,"-NONE-","-NONE-","-NONE-",null,null,"-NONE-","-NONE-","-NONE-","-NONE-",{"$f":"IF($K22=\"No\",0,IF(OR($J22=\"yes\",$D22=Definitions!$B$25,$D22=Definitions!$B$28,$D22=Definitions!$B$30,$D22=Definitions!$B$31,$D22=Definitions!$B$33),('Stage 2.4'!$H22*0),$H22))","v":0},{"$f":"IF($L22=\"No\",0,IF(OR($J22=\"yes\",$D22=Definitions!$B$25,$D22=Definitions!$B$28,$D22=Definitions!$B$30,$D22=Definitions!$B$31,$D22=Definitions!$B$33),('Stage 2.4'!$H22*0),$H22))","v":0}]
[null,13,null,"-NONE-","-NONE-","-NONE-",null,null,"-NONE-","-NONE-","-NONE-","-NONE-",{"$f":"IF($K23=\"No\",0,IF(OR($J23=\"yes\",$D23=Definitions!$B$25,$D23=Definitions!$B$28,$D23=Definitions!$B$30,$D23=Definitions!$B$31,$D23=Definitions!$B$33),('Stage 2.4'!$H23*0),$H23))","v":0},{"$f":"IF($L23=\"No\",0,IF(OR($J23=\"yes\",$D23=Definitions!$B$25,$D23=Definitions!$B$28,$D23=Definitions!$B$30,$D23=Definitions!$B$31,$D23=Definitions!$B$33),('Stage 2.4'!$H23*0),$H23))","v":0}]
[null,14,null,"-NONE-","-NONE-","-NONE-",null,null,"-NONE-","-NONE-","-NONE-","-NONE-",{"$f":"IF($K24=\"No\",0,IF(OR($J24=\"yes\",$D24=Definitions!$B$25,$D24=Definitions!$B$28,$D24=Definitions!$B$30,$D24=Definitions!$B$31,$D24=Definitions!$B$33),('Stage 2.4'!$H24*0),$H24))","v":0},{"$f":"IF($L24=\"No\",0,IF(OR($J24=\"yes\",$D24=Definitions!$B$25,$D24=Definitions!$B$28,$D24=Definitions!$B$30,$D24=Definitions!$B$31,$D24=Definitions!$B$33),('Stage 2.4'!$H24*0),$H24))","v":0}]
[null,15,null,"-NONE-","-NONE-","-NONE-",null,null,"-NONE-","-NONE-","-NONE-","-NONE-",{"$f":"IF($K25=\"No\",0,IF(OR($J25=\"yes\",$D25=Definitions!$B$25,$D25=Definitions!$B$28,$D25=Definitions!$B$30,$D25=Definitions!$B$31,$D25=Definitions!$B$33),('Stage 2.4'!$H25*0),$H25))","v":0},{"$f":"IF($L25=\"No\",0,IF(OR($J25=\"yes\",$D25=Definitions!$B$25,$D25=Definitions!$B$28,$D25=Definitions!$B$30,$D25=Definitions!$B$31,$D25=Definitions!$B$33),('Stage 2.4'!$H25*0),$H25))","v":0}]
[null,16,null,"-NONE-","-NONE-","-NONE-",null,null,"-NONE-","-NONE-","-NONE-","-NONE-",{"$f":"IF($K26=\"No\",0,IF(OR($J26=\"yes\",$D26=Definitions!$B$25,$D26=Definitions!$B$28,$D26=Definitions!$B$30,$D26=Definitions!$B$31,$D26=Definitions!$B$33),('Stage 2.4'!$H26*0),$H26))","v":0},{"$f":"IF($L26=\"No\",0,IF(OR($J26=\"yes\",$D26=Definitions!$B$25,$D26=Definitions!$B$28,$D26=Definitions!$B$30,$D26=Definitions!$B$31,$D26=Definitions!$B$33),('Stage 2.4'!$H26*0),$H26))","v":0}]
[null,17,null,"-NONE-","-NONE-","-NONE-",null,null,"-NONE-","-NONE-","-NONE-","-NONE-",{"$f":"IF($K27=\"No\",0,IF(OR($J27=\"yes\",$D27=Definitions!$B$25,$D27=Definitions!$B$28,$D27=Definitions!$B$30,$D27=Definitions!$B$31,$D27=Definitions!$B$33),('Stage 2.4'!$H27*0),$H27))","v":0},{"$f":"IF($L27=\"No\",0,IF(OR($J27=\"yes\",$D27=Definitions!$B$25,$D27=Definitions!$B$28,$D27=Definitions!$B$30,$D27=Definitions!$B$31,$D27=Definitions!$B$33),('Stage 2.4'!$H27*0),$H27))","v":0}]
[null,18,null,"-NONE-","-NONE-","-NONE-",null,null,"-NONE-","-NONE-","-NONE-","-NONE-",{"$f":"IF($K28=\"No\",0,IF(OR($J28=\"yes\",$D28=Definitions!$B$25,$D28=Definitions!$B$28,$D28=Definitions!$B$30,$D28=Definitions!$B$31,$D28=Definitions!$B$33),('Stage 2.4'!$H28*0),$H28))","v":0},{"$f":"IF($L28=\"No\",0,IF(OR($J28=\"yes\",$D28=Definitions!$B$25,$D28=Definitions!$B$28,$D28=Definitions!$B$30,$D28=Definitions!$B$31,$D28=Definitions!$B$33),('Stage 2.4'!$H28*0),$H28))","v":0}]
[null,19,null,"-NONE-","-NONE-","-NONE-",null,null,"-NONE-","-NONE-","-NONE-","-NONE-",{"$f":"IF($K29=\"No\",0,IF(OR($J29=\"yes\",$D29=Definitions!$B$25,$D29=Definitions!$B$28,$D29=Definitions!$B$30,$D29=Definitions!$B$31,$D29=Definitions!$B$33),('Stage 2.4'!$H29*0),$H29))","v":0},{"$f":"IF($L29=\"No\",0,IF(OR($J29=\"yes\",$D29=Definitions!$B$25,$D29=Definitions!$B$28,$D29=Definitions!$B$30,$D29=Definitions!$B$31,$D29=Definitions!$B$33),('Stage 2.4'!$H29*0),$H29))","v":0}]
[null,20,null,"-NONE-","-NONE-","-NONE-",null,null,"-NONE-","-NONE-","-NONE-","-NONE-",{"$f":"IF($K30=\"No\",0,IF(OR($J30=\"yes\",$D30=Definitions!$B$25,$D30=Definitions!$B$28,$D30=Definitions!$B$30,$D30=Definitions!$B$31,$D30=Definitions!$B$33),('Stage 2.4'!$H30*0),$H30))","v":0},{"$f":"IF($L30=\"No\",0,IF(OR($J30=\"yes\",$D30=Definitions!$B$25,$D30=Definitions!$B$28,$D30=Definitions!$B$30,$D30=Definitions!$B$31,$D30=Definitions!$B$33),('Stage 2.4'!$H30*0),$H30))","v":0}]
[null,21,null,"-NONE-","-NONE-","-NONE-",null,null,"-NONE-","-NONE-","-NONE-","-NONE-",{"$f":"IF($K31=\"No\",0,IF(OR($J31=\"yes\",$D31=Definitions!$B$25,$D31=Definitions!$B$28,$D31=Definitions!$B$30,$D31=Definitions!$B$31,$D31=Definitions!$B$33),('Stage 2.4'!$H31*0),$H31))","v":0},{"$f":"IF($L31=\"No\",0,IF(OR($J31=\"yes\",$D31=Definitions!$B$25,$D31=Definitions!$B$28,$D31=Definitions!$B$30,$D31=Definitions!$B$31,$D31=Definitions!$B$33),('Stage 2.4'!$H31*0),$H31))","v":0}]
[null,22,null,"-NONE-","-NONE-","-NONE-",null,null,"-NONE-","-NONE-","-NONE-","-NONE-",{"$f":"IF($K32=\"No\",0,IF(OR($J32=\"yes\",$D32=Definitions!$B$25,$D32=Definitions!$B$28,$D32=Definitions!$B$30,$D32=Definitions!$B$31,$D32=Definitions!$B$33),('Stage 2.4'!$H32*0),$H32))","v":0},{"$f":"IF($L32=\"No\",0,IF(OR($J32=\"yes\",$D32=Definitions!$B$25,$D32=Definitions!$B$28,$D32=Definitions!$B$30,$D32=Definitions!$B$31,$D32=Definitions!$B$33),('Stage 2.4'!$H32*0),$H32))","v":0}]
[null,23,null,"-NONE-","-NONE-","-NONE-",null,null,"-NONE-","-NONE-","-NONE-","-NONE-",{"$f":"IF($K33=\"No\",0,IF(OR($J33=\"yes\",$D33=Definitions!$B$25,$D33=Definitions!$B$28,$D33=Definitions!$B$30,$D33=Definitions!$B$31,$D33=Definitions!$B$33),('Stage 2.4'!$H33*0),$H33))","v":0},{"$f":"IF($L33=\"No\",0,IF(OR($J33=\"yes\",$D33=Definitions!$B$25,$D33=Definitions!$B$28,$D33=Definitions!$B$30,$D33=Definitions!$B$31,$D33=Definitions!$B$33),('Stage 2.4'!$H33*0),$H33))","v":0}]
[null,24,null,"-NONE-","-NONE-","-NONE-",null,null,"-NONE-","-NONE-","-NONE-","-NONE-",{"$f":"IF($K34=\"No\",0,IF(OR($J34=\"yes\",$D34=Definitions!$B$25,$D34=Definitions!$B$28,$D34=Definitions!$B$30,$D34=Definitions!$B$31,$D34=Definitions!$B$33),('Stage 2.4'!$H34*0),$H34))","v":0},{"$f":"IF($L34=\"No\",0,IF(OR($J34=\"yes\",$D34=Definitions!$B$25,$D34=Definitions!$B$28,$D34=Definitions!$B$30,$D34=Definitions!$B$31,$D34=Definitions!$B$33),('Stage 2.4'!$H34*0),$H34))","v":0}]
[null,25,null,"-NONE-","-NONE-","-NONE-",null,null,"-NONE-","-NONE-","-NONE-","-NONE-",{"$f":"IF($K35=\"No\",0,IF(OR($J35=\"yes\",$D35=Definitions!$B$25,$D35=Definitions!$B$28,$D35=Definitions!$B$30,$D35=Definitions!$B$31,$D35=Definitions!$B$33),('Stage 2.4'!$H35*0),$H35))","v":0},{"$f":"IF($L35=\"No\",0,IF(OR($J35=\"yes\",$D35=Definitions!$B$25,$D35=Definitions!$B$28,$D35=Definitions!$B$30,$D35=Definitions!$B$31,$D35=Definitions!$B$33),('Stage 2.4'!$H35*0),$H35))","v":0}]
[null,26,null,"-NONE-","-NONE-","-NONE-",null,null,"-NONE-","-NONE-","-NONE-","-NONE-",{"$f":"IF($K36=\"No\",0,IF(OR($J36=\"yes\",$D36=Definitions!$B$25,$D36=Definitions!$B$28,$D36=Definitions!$B$30,$D36=Definitions!$B$31,$D36=Definitions!$B$33),('Stage 2.4'!$H36*0),$H36))","v":0},{"$f":"IF($L36=\"No\",0,IF(OR($J36=\"yes\",$D36=Definitions!$B$25,$D36=Definitions!$B$28,$D36=Definitions!$B$30,$D36=Definitions!$B$31,$D36=Definitions!$B$33),('Stage 2.4'!$H36*0),$H36))","v":0}]
[null,27,null,"-NONE-","-NONE-","-NONE-",null,null,"-NONE-","-NONE-","-NONE-","-NONE-",{"$f":"IF($K37=\"No\",0,IF(OR($J37=\"yes\",$D37=Definitions!$B$25,$D37=Definitions!$B$28,$D37=Definitions!$B$30,$D37=Definitions!$B$31,$D37=Definitions!$B$33),('Stage 2.4'!$H37*0),$H37))","v":0},{"$f":"IF($L37=\"No\",0,IF(OR($J37=\"yes\",$D37=Definitions!$B$25,$D37=Definitions!$B$28,$D37=Definitions!$B$30,$D37=Definitions!$B$31,$D37=Definitions!$B$33),('Stage 2.4'!$H37*0),$H37))","v":0}]
[null,28,null,"-NONE-","-NONE-","-NONE-",null,null,"-NONE-","-NONE-","-NONE-","-NONE-",{"$f":"IF($K38=\"No\",0,IF(OR($J38=\"yes\",$D38=Definitions!$B$25,$D38=Definitions!$B$28,$D38=Definitions!$B$30,$D38=Definitions!$B$31,$D38=Definitions!$B$33),('Stage 2.4'!$H38*0),$H38))","v":0},{"$f":"IF($L38=\"No\",0,IF(OR($J38=\"yes\",$D38=Definitions!$B$25,$D38=Definitions!$B$28,$D38=Definitions!$B$30,$D38=Definitions!$B$31,$D38=Definitions!$B$33),('Stage 2.4'!$H38*0),$H38))","v":0}]
[null,29,null,"-NONE-","-NONE-","-NONE-",null,null,"-NONE-","-NONE-","-NONE-","-NONE-",{"$f":"IF($K39=\"No\",0,IF(OR($J39=\"yes\",$D39=Definitions!$B$25,$D39=Definitions!$B$28,$D39=Definitions!$B$30,$D39=Definitions!$B$31,$D39=Definitions!$B$33),('Stage 2.4'!$H39*0),$H39))","v":0},{"$f":"IF($L39=\"No\",0,IF(OR($J39=\"yes\",$D39=Definitions!$B$25,$D39=Definitions!$B$28,$D39=Definitions!$B$30,$D39=Definitions!$B$31,$D39=Definitions!$B$33),('Stage 2.4'!$H39*0),$H39))","v":0}]
[null,30,null,"-NONE-","-NONE-","-NONE-",null,null,"-NONE-","-NONE-","-NONE-","-NONE-",{"$f":"IF($K40=\"No\",0,IF(OR($J40=\"yes\",$D40=Definitions!$B$25,$D40=Definitions!$B$28,$D40=Definitions!$B$30,$D40=Definitions!$B$31,$D40=Definitions!$B$33),('Stage 2.4'!$H40*0),$H40))","v":0},{"$f":"IF($L40=\"No\",0,IF(OR($J40=\"yes\",$D40=Definitions!$B$25,$D40=Definitions!$B$28,$D40=Definitions!$B$30,$D40=Definitions!$B$31,$D40=Definitions!$B$33),('Stage 2.4'!$H40*0),$H40))","v":0}]
[null,31,null,"-NONE-","-NONE-","-NONE-",null,null,"-NONE-","-NONE-","-NONE-","-NONE-",{"$f":"IF($K41=\"No\",0,IF(OR($J41=\"yes\",$D41=Definitions!$B$25,$D41=Definitions!$B$28,$D41=Definitions!$B$30,$D41=Definitions!$B$31,$D41=Definitions!$B$33),('Stage 2.4'!$H41*0),$H41))","v":0},{"$f":"IF($L41=\"No\",0,IF(OR($J41=\"yes\",$D41=Definitions!$B$25,$D41=Definitions!$B$28,$D41=Definitions!$B$30,$D41=Definitions!$B$31,$D41=Definitions!$B$33),('Stage 2.4'!$H41*0),$H41))","v":0}]
[null,32,null,"-NONE-","-NONE-","-NONE-",null,null,"-NONE-","-NONE-","-NONE-","-NONE-",{"$f":"IF($K42=\"No\",0,IF(OR($J42=\"yes\",$D42=Definitions!$B$25,$D42=Definitions!$B$28,$D42=Definitions!$B$30,$D42=Definitions!$B$31,$D42=Definitions!$B$33),('Stage 2.4'!$H42*0),$H42))","v":0},{"$f":"IF($L42=\"No\",0,IF(OR($J42=\"yes\",$D42=Definitions!$B$25,$D42=Definitions!$B$28,$D42=Definitions!$B$30,$D42=Definitions!$B$31,$D42=Definitions!$B$33),('Stage 2.4'!$H42*0),$H42))","v":0}]
[null,33,null,"-NONE-","-NONE-","-NONE-",null,null,"-NONE-","-NONE-","-NONE-","-NONE-",{"$f":"IF($K43=\"No\",0,IF(OR($J43=\"yes\",$D43=Definitions!$B$25,$D43=Definitions!$B$28,$D43=Definitions!$B$30,$D43=Definitions!$B$31,$D43=Definitions!$B$33),('Stage 2.4'!$H43*0),$H43))","v":0},{"$f":"IF($L43=\"No\",0,IF(OR($J43=\"yes\",$D43=Definitions!$B$25,$D43=Definitions!$B$28,$D43=Definitions!$B$30,$D43=Definitions!$B$31,$D43=Definitions!$B$33),('Stage 2.4'!$H43*0),$H43))","v":0}]
[null,34,null,"-NONE-","-NONE-","-NONE-",null,null,"-NONE-","-NONE-","-NONE-","-NONE-",{"$f":"IF($K44=\"No\",0,IF(OR($J44=\"yes\",$D44=Definitions!$B$25,$D44=Definitions!$B$28,$D44=Definitions!$B$30,$D44=Definitions!$B$31,$D44=Definitions!$B$33),('Stage 2.4'!$H44*0),$H44))","v":0},{"$f":"IF($L44=\"No\",0,IF(OR($J44=\"yes\",$D44=Definitions!$B$25,$D44=Definitions!$B$28,$D44=Definitions!$B$30,$D44=Definitions!$B$31,$D44=Definitions!$B$33),('Stage 2.4'!$H44*0),$H44))","v":0}]
[null,35,null,"-NONE-","-NONE-","-NONE-",null,null,"-NONE-","-NONE-","-NONE-","-NONE-",{"$f":"IF($K45=\"No\",0,IF(OR($J45=\"yes\",$D45=Definitions!$B$25,$D45=Definitions!$B$28,$D45=Definitions!$B$30,$D45=Definitions!$B$31,$D45=Definitions!$B$33),('Stage 2.4'!$H45*0),$H45))","v":0},{"$f":"IF($L45=\"No\",0,IF(OR($J45=\"yes\",$D45=Definitions!$B$25,$D45=Definitions!$B$28,$D45=Definitions!$B$30,$D45=Definitions!$B$31,$D45=Definitions!$B$33),('Stage 2.4'!$H45*0),$H45))","v":0}]
[null,36,null,"-NONE-","-NONE-","-NONE-",null,null,"-NONE-","-NONE-","-NONE-","-NONE-",{"$f":"IF($K46=\"No\",0,IF(OR($J46=\"yes\",$D46=Definitions!$B$25,$D46=Definitions!$B$28,$D46=Definitions!$B$30,$D46=Definitions!$B$31,$D46=Definitions!$B$33),('Stage 2.4'!$H46*0),$H46))","v":0},{"$f":"IF($L46=\"No\",0,IF(OR($J46=\"yes\",$D46=Definitions!$B$25,$D46=Definitions!$B$28,$D46=Definitions!$B$30,$D46=Definitions!$B$31,$D46=Definitions!$B$33),('Stage 2.4'!$H46*0),$H46))","v":0}]
[null,37,null,"-NONE-","-NONE-","-NONE-",null,null,"-NONE-","-NONE-","-NONE-","-NONE-",{"$f":"IF($K47=\"No\",0,IF(OR($J47=\"yes\",$D47=Definitions!$B$25,$D47=Definitions!$B$28,$D47=Definitions!$B$30,$D47=Definitions!$B$31,$D47=Definitions!$B$33),('Stage 2.4'!$H47*0),$H47))","v":0},{"$f":"IF($L47=\"No\",0,IF(OR($J47=\"yes\",$D47=Definitions!$B$25,$D47=Definitions!$B$28,$D47=Definitions!$B$30,$D47=Definitions!$B$31,$D47=Definitions!$B$33),('Stage 2.4'!$H47*0),$H47))","v":0}]
[null,38,null,"-NONE-","-NONE-","-NONE-",null,null,"-NONE-","-NONE-","-NONE-","-NONE-",{"$f":"IF($K48=\"No\",0,IF(OR($J48=\"yes\",$D48=Definitions!$B$25,$D48=Definitions!$B$28,$D48=Definitions!$B$30,$D48=Definitions!$B$31,$D48=Definitions!$B$33),('Stage 2.4'!$H48*0),$H48))","v":0},{"$f":"IF($L48=\"No\",0,IF(OR($J48=\"yes\",$D48=Definitions!$B$25,$D48=Definitions!$B$28,$D48=Definitions!$B$30,$D48=Definitions!$B$31,$D48=Definitions!$B$33),('Stage 2.4'!$H48*0),$H48))","v":0}]
[null,39,null,"-NONE-","-NONE-","-NONE-",null,null,"-NONE-","-NONE-","-NONE-","-NONE-",{"$f":"IF($K49=\"No\",0,IF(OR($J49=\"yes\",$D49=Definitions!$B$25,$D49=Definitions!$B$28,$D49=Definitions!$B$30,$D49=Definitions!$B$31,$D49=Definitions!$B$33),('Stage 2.4'!$H49*0),$H49))","v":0},{"$f":"IF($L49=\"No\",0,IF(OR($J49=\"yes\",$D49=Definitions!$B$25,$D49=Definitions!$B$28,$D49=Definitions!$B$30,$D49=Definitions!$B$31,$D49=Definitions!$B$33),('Stage 2.4'!$H49*0),$H49))","v":0}]
[null,40,null,"-NONE-","-NONE-","-NONE-",null,null,"-NONE-","-NONE-","-NONE-","-NONE-",{"$f":"IF($K50=\"No\",0,IF(OR($J50=\"yes\",$D50=Definitions!$B$25,$D50=Definitions!$B$28,$D50=Definitions!$B$30,$D50=Definitions!$B$31,$D50=Definitions!$B$33),('Stage 2.4'!$H50*0),$H50))","v":0},{"$f":"IF($L50=\"No\",0,IF(OR($J50=\"yes\",$D50=Definitions!$B$25,$D50=Definitions!$B$28,$D50=Definitions!$B$30,$D50=Definitions!$B$31,$D50=Definitions!$B$33),('Stage 2.4'!$H50*0),$H50))","v":0}]
[null,41,null,"-NONE-","-NONE-","-NONE-",null,null,"-NONE-","-NONE-","-NONE-","-NONE-",{"$f":"IF($K51=\"No\",0,IF(OR($J51=\"yes\",$D51=Definitions!$B$25,$D51=Definitions!$B$28,$D51=Definitions!$B$30,$D51=Definitions!$B$31,$D51=Definitions!$B$33),('Stage 2.4'!$H51*0),$H51))","v":0},{"$f":"IF($L51=\"No\",0,IF(OR($J51=\"yes\",$D51=Definitions!$B$25,$D51=Definitions!$B$28,$D51=Definitions!$B$30,$D51=Definitions!$B$31,$D51=Definitions!$B$33),('Stage 2.4'!$H51*0),$H51))","v":0}]
[null,42,null,"-NONE-","-NONE-","-NONE-",null,null,"-NONE-","-NONE-","-NONE-","-NONE-",{"$f":"IF($K52=\"No\",0,IF(OR($J52=\"yes\",$D52=Definitions!$B$25,$D52=Definitions!$B$28,$D52=Definitions!$B$30,$D52=Definitions!$B$31,$D52=Definitions!$B$33),('Stage 2.4'!$H52*0),$H52))","v":0},{"$f":"IF($L52=\"No\",0,IF(OR($J52=\"yes\",$D52=Definitions!$B$25,$D52=Definitions!$B$28,$D52=Definitions!$B$30,$D52=Definitions!$B$31,$D52=Definitions!$B$33),('Stage 2.4'!$H52*0),$H52))","v":0}]
[null,43,null,"-NONE-","-NONE-","-NONE-",null,null,"-NONE-","-NONE-","-NONE-","-NONE-",{"$f":"IF($K53=\"No\",0,IF(OR($J53=\"yes\",$D53=Definitions!$B$25,$D53=Definitions!$B$28,$D53=Definitions!$B$30,$D53=Definitions!$B$31,$D53=Definitions!$B$33),('Stage 2.4'!$H53*0),$H53))","v":0},{"$f":"IF($L53=\"No\",0,IF(OR($J53=\"yes\",$D53=Definitions!$B$25,$D53=Definitions!$B$28,$D53=Definitions!$B$30,$D53=Definitions!$B$31,$D53=Definitions!$B$33),('Stage 2.4'!$H53*0),$H53))","v":0}]
[null,44,null,"-NONE-","-NONE-","-NONE-",null,null,"-NONE-","-NONE-","-NONE-","-NONE-",{"$f":"IF($K54=\"No\",0,IF(OR($J54=\"yes\",$D54=Definitions!$B$25,$D54=Definitions!$B$28,$D54=Definitions!$B$30,$D54=Definitions!$B$31,$D54=Definitions!$B$33),('Stage 2.4'!$H54*0),$H54))","v":0},{"$f":"IF($L54=\"No\",0,IF(OR($J54=\"yes\",$D54=Definitions!$B$25,$D54=Definitions!$B$28,$D54=Definitions!$B$30,$D54=Definitions!$B$31,$D54=Definitions!$B$33),('Stage 2.4'!$H54*0),$H54))","v":0}]
[null,45,null,"-NONE-","-NONE-","-NONE-",null,null,"-NONE-","-NONE-","-NONE-","-NONE-",{"$f":"IF($K55=\"No\",0,IF(OR($J55=\"yes\",$D55=Definitions!$B$25,$D55=Definitions!$B$28,$D55=Definitions!$B$30,$D55=Definitions!$B$31,$D55=Definitions!$B$33),('Stage 2.4'!$H55*0),$H55))","v":0},{"$f":"IF($L55=\"No\",0,IF(OR($J55=\"yes\",$D55=Definitions!$B$25,$D55=Definitions!$B$28,$D55=Definitions!$B$30,$D55=Definitions!$B$31,$D55=Definitions!$B$33),('Stage 2.4'!$H55*0),$H55))","v":0}]
[null,46,null,"-NONE-","-NONE-","-NONE-",null,null,"-NONE-","-NONE-","-NONE-","-NONE-",{"$f":"IF($K56=\"No\",0,IF(OR($J56=\"yes\",$D56=Definitions!$B$25,$D56=Definitions!$B$28,$D56=Definitions!$B$30,$D56=Definitions!$B$31,$D56=Definitions!$B$33),('Stage 2.4'!$H56*0),$H56))","v":0},{"$f":"IF($L56=\"No\",0,IF(OR($J56=\"yes\",$D56=Definitions!$B$25,$D56=Definitions!$B$28,$D56=Definitions!$B$30,$D56=Definitions!$B$31,$D56=Definitions!$B$33),('Stage 2.4'!$H56*0),$H56))","v":0}]
[null,47,null,"-NONE-","-NONE-","-NONE-",null,null,"-NONE-","-NONE-","-NONE-","-NONE-",{"$f":"IF($K57=\"No\",0,IF(OR($J57=\"yes\",$D57=Definitions!$B$25,$D57=Definitions!$B$28,$D57=Definitions!$B$30,$D57=Definitions!$B$31,$D57=Definitions!$B$33),('Stage 2.4'!$H57*0),$H57))","v":0},{"$f":"IF($L57=\"No\",0,IF(OR($J57=\"yes\",$D57=Definitions!$B$25,$D57=Definitions!$B$28,$D57=Definitions!$B$30,$D57=Definitions!$B$31,$D57=Definitions!$B$33),('Stage 2.4'!$H57*0),$H57))","v":0}]
[null,48,null,"-NONE-","-NONE-","-NONE-",null,null,"-NONE-","-NONE-","-NONE-","-NONE-",{"$f":"IF($K58=\"No\",0,IF(OR($J58=\"yes\",$D58=Definitions!$B$25,$D58=Definitions!$B$28,$D58=Definitions!$B$30,$D58=Definitions!$B$31,$D58=Definitions!$B$33),('Stage 2.4'!$H58*0),$H58))","v":0},{"$f":"IF($L58=\"No\",0,IF(OR($J58=\"yes\",$D58=Definitions!$B$25,$D58=Definitions!$B$28,$D58=Definitions!$B$30,$D58=Definitions!$B$31,$D58=Definitions!$B$33),('Stage 2.4'!$H58*0),$H58))","v":0}]
[null,49,null,"-NONE-","-NONE-","-NONE-",null,null,"-NONE-","-NONE-","-NONE-","-NONE-",{"$f":"IF($K59=\"No\",0,IF(OR($J59=\"yes\",$D59=Definitions!$B$25,$D59=Definitions!$B$28,$D59=Definitions!$B$30,$D59=Definitions!$B$31,$D59=Definitions!$B$33),('Stage 2.4'!$H59*0),$H59))","v":0},{"$f":"IF($L59=\"No\",0,IF(OR($J59=\"yes\",$D59=Definitions!$B$25,$D59=Definitions!$B$28,$D59=Definitions!$B$30,$D59=Definitions!$B$31,$D59=Definitions!$B$33),('Stage 2.4'!$H59*0),$H59))","v":0}]
[null,50,null,"-NONE-","-NONE-","-NONE-",null,null,"-NONE-","-NONE-","-NONE-","-NONE-",{"$f":"IF($K60=\"No\",0,IF(OR($J60=\"yes\",$D60=Definitions!$B$25,$D60=Definitions!$B$28,$D60=Definitions!$B$30,$D60=Definitions!$B$31,$D60=Definitions!$B$33),('Stage 2.4'!$H60*0),$H60))","v":0},{"$f":"IF($L60=\"No\",0,IF(OR($J60=\"yes\",$D60=Definitions!$B$25,$D60=Definitions!$B$28,$D60=Definitions!$B$30,$D60=Definitions!$B$31,$D60=Definitions!$B$33),('Stage 2.4'!$H60*0),$H60))","v":0}]
[null,51,null,"-NONE-","-NONE-","-NONE-",null,null,"-NONE-","-NONE-","-NONE-","-NONE-",{"$f":"IF($K61=\"No\",0,IF(OR($J61=\"yes\",$D61=Definitions!$B$25,$D61=Definitions!$B$28,$D61=Definitions!$B$30,$D61=Definitions!$B$31,$D61=Definitions!$B$33),('Stage 2.4'!$H61*0),$H61))","v":0},{"$f":"IF($L61=\"No\",0,IF(OR($J61=\"yes\",$D61=Definitions!$B$25,$D61=Definitions!$B$28,$D61=Definitions!$B$30,$D61=Definitions!$B$31,$D61=Definitions!$B$33),('Stage 2.4'!$H61*0),$H61))","v":0}]
[null,52,null,"-NONE-","-NONE-","-NONE-",null,null,"-NONE-","-NONE-","-NONE-","-NONE-",{"$f":"IF($K62=\"No\",0,IF(OR($J62=\"yes\",$D62=Definitions!$B$25,$D62=Definitions!$B$28,$D62=Definitions!$B$30,$D62=Definitions!$B$31,$D62=Definitions!$B$33),('Stage 2.4'!$H62*0),$H62))","v":0},{"$f":"IF($L62=\"No\",0,IF(OR($J62=\"yes\",$D62=Definitions!$B$25,$D62=Definitions!$B$28,$D62=Definitions!$B$30,$D62=Definitions!$B$31,$D62=Definitions!$B$33),('Stage 2.4'!$H62*0),$H62))","v":0}]
[null,53,null,"-NONE-","-NONE-","-NONE-",null,null,"-NONE-","-NONE-","-NONE-","-NONE-",{"$f":"IF($K63=\"No\",0,IF(OR($J63=\"yes\",$D63=Definitions!$B$25,$D63=Definitions!$B$28,$D63=Definitions!$B$30,$D63=Definitions!$B$31,$D63=Definitions!$B$33),('Stage 2.4'!$H63*0),$H63))","v":0},{"$f":"IF($L63=\"No\",0,IF(OR($J63=\"yes\",$D63=Definitions!$B$25,$D63=Definitions!$B$28,$D63=Definitions!$B$30,$D63=Definitions!$B$31,$D63=Definitions!$B$33),('Stage 2.4'!$H63*0),$H63))","v":0}]
[null,54,null,"-NONE-","-NONE-","-NONE-",null,null,"-NONE-","-NONE-","-NONE-","-NONE-",{"$f":"IF($K64=\"No\",0,IF(OR($J64=\"yes\",$D64=Definitions!$B$25,$D64=Definitions!$B$28,$D64=Definitions!$B$30,$D64=Definitions!$B$31,$D64=Definitions!$B$33),('Stage 2.4'!$H64*0),$H64))","v":0},{"$f":"IF($L64=\"No\",0,IF(OR($J64=\"yes\",$D64=Definitions!$B$25,$D64=Definitions!$B$28,$D64=Definitions!$B$30,$D64=Definitions!$B$31,$D64=Definitions!$B$33),('Stage 2.4'!$H64*0),$H64))","v":0}]
[null,55,null,"-NONE-","-NONE-","-NONE-",null,null,"-NONE-","-NONE-","-NONE-","-NONE-",{"$f":"IF($K65=\"No\",0,IF(OR($J65=\"yes\",$D65=Definitions!$B$25,$D65=Definitions!$B$28,$D65=Definitions!$B$30,$D65=Definitions!$B$31,$D65=Definitions!$B$33),('Stage 2.4'!$H65*0),$H65))","v":0},{"$f":"IF($L65=\"No\",0,IF(OR($J65=\"yes\",$D65=Definitions!$B$25,$D65=Definitions!$B$28,$D65=Definitions!$B$30,$D65=Definitions!$B$31,$D65=Definitions!$B$33),('Stage 2.4'!$H65*0),$H65))","v":0}]
[null,56,null,"-NONE-","-NONE-","-NONE-",null,null,"-NONE-","-NONE-","-NONE-","-NONE-",{"$f":"IF($K66=\"No\",0,IF(OR($J66=\"yes\",$D66=Definitions!$B$25,$D66=Definitions!$B$28,$D66=Definitions!$B$30,$D66=Definitions!$B$31,$D66=Definitions!$B$33),('Stage 2.4'!$H66*0),$H66))","v":0},{"$f":"IF($L66=\"No\",0,IF(OR($J66=\"yes\",$D66=Definitions!$B$25,$D66=Definitions!$B$28,$D66=Definitions!$B$30,$D66=Definitions!$B$31,$D66=Definitions!$B$33),('Stage 2.4'!$H66*0),$H66))","v":0}]
[null,57,null,"-NONE-","-NONE-","-NONE-",null,null,"-NONE-","-NONE-","-NONE-","-NONE-",{"$f":"IF($K67=\"No\",0,IF(OR($J67=\"yes\",$D67=Definitions!$B$25,$D67=Definitions!$B$28,$D67=Definitions!$B$30,$D67=Definitions!$B$31,$D67=Definitions!$B$33),('Stage 2.4'!$H67*0),$H67))","v":0},{"$f":"IF($L67=\"No\",0,IF(OR($J67=\"yes\",$D67=Definitions!$B$25,$D67=Definitions!$B$28,$D67=Definitions!$B$30,$D67=Definitions!$B$31,$D67=Definitions!$B$33),('Stage 2.4'!$H67*0),$H67))","v":0}]
[null,58,null,"-NONE-","-NONE-","-NONE-",null,null,"-NONE-","-NONE-","-NONE-","-NONE-",{"$f":"IF($K68=\"No\",0,IF(OR($J68=\"yes\",$D68=Definitions!$B$25,$D68=Definitions!$B$28,$D68=Definitions!$B$30,$D68=Definitions!$B$31,$D68=Definitions!$B$33),('Stage 2.4'!$H68*0),$H68))","v":0},{"$f":"IF($L68=\"No\",0,IF(OR($J68=\"yes\",$D68=Definitions!$B$25,$D68=Definitions!$B$28,$D68=Definitions!$B$30,$D68=Definitions!$B$31,$D68=Definitions!$B$33),('Stage 2.4'!$H68*0),$H68))","v":0}]
[null,59,null,"-NONE-","-NONE-","-NONE-",null,null,"-NONE-","-NONE-","-NONE-","-NONE-",{"$f":"IF($K69=\"No\",0,IF(OR($J69=\"yes\",$D69=Definitions!$B$25,$D69=Definitions!$B$28,$D69=Definitions!$B$30,$D69=Definitions!$B$31,$D69=Definitions!$B$33),('Stage 2.4'!$H69*0),$H69))","v":0},{"$f":"IF($L69=\"No\",0,IF(OR($J69=\"yes\",$D69=Definitions!$B$25,$D69=Definitions!$B$28,$D69=Definitions!$B$30,$D69=Definitions!$B$31,$D69=Definitions!$B$33),('Stage 2.4'!$H69*0),$H69))","v":0}]
[null,60,null,"-NONE-","-NONE-","-NONE-",null,null,"-NONE-","-NONE-","-NONE-","-NONE-",{"$f":"IF($K70=\"No\",0,IF(OR($J70=\"yes\",$D70=Definitions!$B$25,$D70=Definitions!$B$28,$D70=Definitions!$B$30,$D70=Definitions!$B$31,$D70=Definitions!$B$33),('Stage 2.4'!$H70*0),$H70))","v":0},{"$f":"IF($L70=\"No\",0,IF(OR($J70=\"yes\",$D70=Definitions!$B$25,$D70=Definitions!$B$28,$D70=Definitions!$B$30,$D70=Definitions!$B$31,$D70=Definitions!$B$33),('Stage 2.4'!$H70*0),$H70))","v":0}]
[null,61,null,"-NONE-","-NONE-","-NONE-",null,null,"-NONE-","-NONE-","-NONE-","-NONE-",{"$f":"IF($K71=\"No\",0,IF(OR($J71=\"yes\",$D71=Definitions!$B$25,$D71=Definitions!$B$28,$D71=Definitions!$B$30,$D71=Definitions!$B$31,$D71=Definitions!$B$33),('Stage 2.4'!$H71*0),$H71))","v":0},{"$f":"IF($L71=\"No\",0,IF(OR($J71=\"yes\",$D71=Definitions!$B$25,$D71=Definitions!$B$28,$D71=Definitions!$B$30,$D71=Definitions!$B$31,$D71=Definitions!$B$33),('Stage 2.4'!$H71*0),$H71))","v":0}]
[null,62,null,"-NONE-","-NONE-","-NONE-",null,null,"-NONE-","-NONE-","-NONE-","-NONE-",{"$f":"IF($K72=\"No\",0,IF(OR($J72=\"yes\",$D72=Definitions!$B$25,$D72=Definitions!$B$28,$D72=Definitions!$B$30,$D72=Definitions!$B$31,$D72=Definitions!$B$33),('Stage 2.4'!$H72*0),$H72))","v":0},{"$f":"IF($L72=\"No\",0,IF(OR($J72=\"yes\",$D72=Definitions!$B$25,$D72=Definitions!$B$28,$D72=Definitions!$B$30,$D72=Definitions!$B$31,$D72=Definitions!$B$33),('Stage 2.4'!$H72*0),$H72))","v":0}]
[null,63,null,"-NONE-","-NONE-","-NONE-",null,null,"-NONE-","-NONE-","-NONE-","-NONE-",{"$f":"IF($K73=\"No\",0,IF(OR($J73=\"yes\",$D73=Definitions!$B$25,$D73=Definitions!$B$28,$D73=Definitions!$B$30,$D73=Definitions!$B$31,$D73=Definitions!$B$33),('Stage 2.4'!$H73*0),$H73))","v":0},{"$f":"IF($L73=\"No\",0,IF(OR($J73=\"yes\",$D73=Definitions!$B$25,$D73=Definitions!$B$28,$D73=Definitions!$B$30,$D73=Definitions!$B$31,$D73=Definitions!$B$33),('Stage 2.4'!$H73*0),$H73))","v":0}]
[null,64,null,"-NONE-","-NONE-","-NONE-",null,null,"-NONE-","-NONE-","-NONE-","-NONE-",{"$f":"IF($K74=\"No\",0,IF(OR($J74=\"yes\",$D74=Definitions!$B$25,$D74=Definitions!$B$28,$D74=Definitions!$B$30,$D74=Definitions!$B$31,$D74=Definitions!$B$33),('Stage 2.4'!$H74*0),$H74))","v":0},{"$f":"IF($L74=\"No\",0,IF(OR($J74=\"yes\",$D74=Definitions!$B$25,$D74=Definitions!$B$28,$D74=Definitions!$B$30,$D74=Definitions!$B$31,$D74=Definitions!$B$33),('Stage 2.4'!$H74*0),$H74))","v":0}]
[null,65,null,"-NONE-","-NONE-","-NONE-",null,null,"-NONE-","-NONE-","-NONE-","-NONE-",{"$f":"IF($K75=\"No\",0,IF(OR($J75=\"yes\",$D75=Definitions!$B$25,$D75=Definitions!$B$28,$D75=Definitions!$B$30,$D75=Definitions!$B$31,$D75=Definitions!$B$33),('Stage 2.4'!$H75*0),$H75))","v":0},{"$f":"IF($L75=\"No\",0,IF(OR($J75=\"yes\",$D75=Definitions!$B$25,$D75=Definitions!$B$28,$D75=Definitions!$B$30,$D75=Definitions!$B$31,$D75=Definitions!$B$33),('Stage 2.4'!$H75*0),$H75))","v":0}]
[null,66,null,"-NONE-","-NONE-","-NONE-",null,null,"-NONE-","-NONE-","-NONE-","-NONE-",{"$f":"IF($K76=\"No\",0,IF(OR($J76=\"yes\",$D76=Definitions!$B$25,$D76=Definitions!$B$28,$D76=Definitions!$B$30,$D76=Definitions!$B$31,$D76=Definitions!$B$33),('Stage 2.4'!$H76*0),$H76))","v":0},{"$f":"IF($L76=\"No\",0,IF(OR($J76=\"yes\",$D76=Definitions!$B$25,$D76=Definitions!$B$28,$D76=Definitions!$B$30,$D76=Definitions!$B$31,$D76=Definitions!$B$33),('Stage 2.4'!$H76*0),$H76))","v":0}]
[null,67,null,"-NONE-","-NONE-","-NONE-",null,null,"-NONE-","-NONE-","-NONE-","-NONE-",{"$f":"IF($K77=\"No\",0,IF(OR($J77=\"yes\",$D77=Definitions!$B$25,$D77=Definitions!$B$28,$D77=Definitions!$B$30,$D77=Definitions!$B$31,$D77=Definitions!$B$33),('Stage 2.4'!$H77*0),$H77))","v":0},{"$f":"IF($L77=\"No\",0,IF(OR($J77=\"yes\",$D77=Definitions!$B$25,$D77=Definitions!$B$28,$D77=Definitions!$B$30,$D77=Definitions!$B$31,$D77=Definitions!$B$33),('Stage 2.4'!$H77*0),$H77))","v":0}]
[null,68,null,"-NONE-","-NONE-","-NONE-",null,null,"-NONE-","-NONE-","-NONE-","-NONE-",{"$f":"IF($K78=\"No\",0,IF(OR($J78=\"yes\",$D78=Definitions!$B$25,$D78=Definitions!$B$28,$D78=Definitions!$B$30,$D78=Definitions!$B$31,$D78=Definitions!$B$33),('Stage 2.4'!$H78*0),$H78))","v":0},{"$f":"IF($L78=\"No\",0,IF(OR($J78=\"yes\",$D78=Definitions!$B$25,$D78=Definitions!$B$28,$D78=Definitions!$B$30,$D78=Definitions!$B$31,$D78=Definitions!$B$33),('Stage 2.4'!$H78*0),$H78))","v":0}]
[null,69,null,"-NONE-","-NONE-","-NONE-",null,null,"-NONE-","-NONE-","-NONE-","-NONE-",{"$f":"IF($K79=\"No\",0,IF(OR($J79=\"yes\",$D79=Definitions!$B$25,$D79=Definitions!$B$28,$D79=Definitions!$B$30,$D79=Definitions!$B$31,$D79=Definitions!$B$33),('Stage 2.4'!$H79*0),$H79))","v":0},{"$f":"IF($L79=\"No\",0,IF(OR($J79=\"yes\",$D79=Definitions!$B$25,$D79=Definitions!$B$28,$D79=Definitions!$B$30,$D79=Definitions!$B$31,$D79=Definitions!$B$33),('Stage 2.4'!$H79*0),$H79))","v":0}]
[null,70,null,"-NONE-","-NONE-","-NONE-",null,null,"-NONE-","-NONE-","-NONE-","-NONE-",{"$f":"IF($K80=\"No\",0,IF(OR($J80=\"yes\",$D80=Definitions!$B$25,$D80=Definitions!$B$28,$D80=Definitions!$B$30,$D80=Definitions!$B$31,$D80=Definitions!$B$33),('Stage 2.4'!$H80*0),$H80))","v":0},{"$f":"IF($L80=\"No\",0,IF(OR($J80=\"yes\",$D80=Definitions!$B$25,$D80=Definitions!$B$28,$D80=Definitions!$B$30,$D80=Definitions!$B$31,$D80=Definitions!$B$33),('Stage 2.4'!$H80*0),$H80))","v":0}]
[null,71,null,"-NONE-","-NONE-","-NONE-",null,null,"-NONE-","-NONE-","-NONE-","-NONE-",{"$f":"IF($K81=\"No\",0,IF(OR($J81=\"yes\",$D81=Definitions!$B$25,$D81=Definitions!$B$28,$D81=Definitions!$B$30,$D81=Definitions!$B$31,$D81=Definitions!$B$33),('Stage 2.4'!$H81*0),$H81))","v":0},{"$f":"IF($L81=\"No\",0,IF(OR($J81=\"yes\",$D81=Definitions!$B$25,$D81=Definitions!$B$28,$D81=Definitions!$B$30,$D81=Definitions!$B$31,$D81=Definitions!$B$33),('Stage 2.4'!$H81*0),$H81))","v":0}]
[null,72,null,"-NONE-","-NONE-","-NONE-",null,null,"-NONE-","-NONE-","-NONE-","-NONE-",{"$f":"IF($K82=\"No\",0,IF(OR($J82=\"yes\",$D82=Definitions!$B$25,$D82=Definitions!$B$28,$D82=Definitions!$B$30,$D82=Definitions!$B$31,$D82=Definitions!$B$33),('Stage 2.4'!$H82*0),$H82))","v":0},{"$f":"IF($L82=\"No\",0,IF(OR($J82=\"yes\",$D82=Definitions!$B$25,$D82=Definitions!$B$28,$D82=Definitions!$B$30,$D82=Definitions!$B$31,$D82=Definitions!$B$33),('Stage 2.4'!$H82*0),$H82))","v":0}]
[null,73,null,"-NONE-","-NONE-","-NONE-",null,null,"-NONE-","-NONE-","-NONE-","-NONE-",{"$f":"IF($K83=\"No\",0,IF(OR($J83=\"yes\",$D83=Definitions!$B$25,$D83=Definitions!$B$28,$D83=Definitions!$B$30,$D83=Definitions!$B$31,$D83=Definitions!$B$33),('Stage 2.4'!$H83*0),$H83))","v":0},{"$f":"IF($L83=\"No\",0,IF(OR($J83=\"yes\",$D83=Definitions!$B$25,$D83=Definitions!$B$28,$D83=Definitions!$B$30,$D83=Definitions!$B$31,$D83=Definitions!$B$33),('Stage 2.4'!$H83*0),$H83))","v":0}]
[null,74,null,"-NONE-","-NONE-","-NONE-",null,null,"-NONE-","-NONE-","-NONE-","-NONE-",{"$f":"IF($K84=\"No\",0,IF(OR($J84=\"yes\",$D84=Definitions!$B$25,$D84=Definitions!$B$28,$D84=Definitions!$B$30,$D84=Definitions!$B$31,$D84=Definitions!$B$33),('Stage 2.4'!$H84*0),$H84))","v":0},{"$f":"IF($L84=\"No\",0,IF(OR($J84=\"yes\",$D84=Definitions!$B$25,$D84=Definitions!$B$28,$D84=Definitions!$B$30,$D84=Definitions!$B$31,$D84=Definitions!$B$33),('Stage 2.4'!$H84*0),$H84))","v":0}]
[null,75,null,"-NONE-","-NONE-","-NONE-",null,null,"-NONE-","-NONE-","-NONE-","-NONE-",{"$f":"IF($K85=\"No\",0,IF(OR($J85=\"yes\",$D85=Definitions!$B$25,$D85=Definitions!$B$28,$D85=Definitions!$B$30,$D85=Definitions!$B$31,$D85=Definitions!$B$33),('Stage 2.4'!$H85*0),$H85))","v":0},{"$f":"IF($L85=\"No\",0,IF(OR($J85=\"yes\",$D85=Definitions!$B$25,$D85=Definitions!$B$28,$D85=Definitions!$B$30,$D85=Definitions!$B$31,$D85=Definitions!$B$33),('Stage 2.4'!$H85*0),$H85))","v":0}]
[null,null,null,null,null,null,{"$f":"SUM(G11:G85)","v":0},{"$f":"SUM(H11:H85)","v":0},null,null,null,null,{"$f":"SUM(M11:M85)","v":0},{"$f":"SUM(N11:N85)","v":0}]
[null,"B) Request for Areas NOT to be counted"]
[null,"This section is optional.  Please refer to the BGA document Procedural Guidelines: Area Discounting before completing this section.  List  spaces from the above list that you believe should be discounted because they were not purpose built for school purposes, or that were built to older, less efficient design standards. "]
[]
[null,"C) External Facilities"]
[null,"\"External\" facilities are facilities used by the school where the school's access is controlled by someone other than the school e.g. a nearby church, or a community gymnasium that is hired by the school.  If the school uses \"external\" facilities, list the type of facility, the purpose for which it is used and the area of the facility that the school would require if it no longer had access to the \"external\" facilities"]
[null,"External Facility",null,"Floor Area (m2)","School use of facilities",null,null,null,"Terms of use",null,null,"Equivalent area required if facilities no longer available to school (m2)"]
[null,"Example: Gym",null,400,"Physcal education years 7-12",null,null,null,"Annual Lease, 10 hours per week",null,null,400]

{"sheet":"Stage 2.5 Std","index":7,"n_rows":111,"n_cols":12,"rows_kept":111,"cut":false,"hidden":false,"merged":[[99,2,99,8],[100,2,100,8],[101,2,101,8],[95,2,95,4],[95,5,95,8],[96,2,96,4],[96,5,96,8],[97,2,97,8],[98,2,98,8],[92,2,92,4],[92,5,92,8],[93,2,93,4],[93,5,93,8],[94,2,94,4],[94,5,94,8],[89,2,89,4],[89,5,89,8],[90,2,90,4],[90,5,90,8],[91,2,91,4],[91,5,91,8],[85,2,85,4],[86,2,86,4],[86,5,86,8],[87,2,87,4],[88,2,88,4],[88,5,88,8],[82,2,82,4],[82,5,82,8],[83,2,83,4],[83,5,83,8],[84,2,84,4],[84,5,84,8],[79,2,79,4],[79,5,79,8],[80,2,80,4],[80,5,80,8],[81,2,81,4],[81,5,81,8],[78,2,78,11],[2,3,2,11],[3,3,3,4],[5,1,5,11],[10,2,10,11],[42,2,42,11]]}
[null,"SOUTH AUSTRALIA INDEPENDENT SCHOOLS BLOCK GRANT AUTHORITY"]
[null,"PROPOSED PROJECT AT STANDARD COST"]
[null,"School Name",null,{"$f":"'Stage 1.1'!SchoolName","v":0}]
[null,"AGEID",null,{"$f":"'Stage 1.1'!ageid","v":0}]
[]
[]
[]
[null,"A) Proposed Project - Non Teaching Spaces and Teaching Spaces for new project"]
[]
[null,"Please note:  Enter details for each facility in the relevant section e.g. Type of Work Construction or Refurbishment"]
[]
[null,"TYPE OF WORK - CONSTRUCTION"]
[null,null,"Facility Description","Facility ID Code","Sector","Size chosen per unit \n(m2)","No of Units","Total Area (m2)","Standard cost per \n(m2)","\n\n\nConstruction cost per m2\n($)","Counted Area  (m2)"]
[]
[null,1,null,"-NONE-","-NONE-",null,null,{"$f":"G15*F15","v":0},{"$f":"_xlfn.XLOOKUP(D15,Definitions!$B$10:$B$33,Definitions!$D$10:$D$33)","v":0},{"$f":"H15*I15","v":0},{"$f":"IF(OR(D15=Definitions!$B$25,D15=Definitions!$B$28,D15=Definitions!$B$30,D15=Definitions!$B$31,D15=Definitions!$B$33,D15=Definitions!$B$23,D15=Definitions!$B$24),('Stage 2.5 Std'!H15*0),H15)","v":0}]
[null,2,null,"-NONE-","-NONE-",null,null,0,{"$f":"_xlfn.XLOOKUP(D16,Definitions!$B$10:$B$33,Definitions!$D$10:$D$33)","v":0},0,{"$f":"IF(OR(D16=Definitions!$B$25,D16=Definitions!$B$28,D16=Definitions!$B$30,D16=Definitions!$B$31,D16=Definitions!$B$33,D16=Definitions!$B$23,D16=Definitions!$B$24),('Stage 2.5 Std'!H16*0),H16)","v":0}]
[null,3,null,"-NONE-","-NONE-",null,null,0,{"$f":"_xlfn.XLOOKUP(D17,Definitions!$B$10:$B$33,Definitions!$D$10:$D$33)","v":0},0,{"$f":"IF(OR(D17=Definitions!$B$25,D17=Definitions!$B$28,D17=Definitions!$B$30,D17=Definitions!$B$31,D17=Definitions!$B$33,D17=Definitions!$B$23,D17=Definitions!$B$24),('Stage 2.5 Std'!H17*0),H17)","v":0}]
[null,4,null,"-NONE-","-NONE-",null,null,0,{"$f":"_xlfn.XLOOKUP(D18,Definitions!$B$10:$B$33,Definitions!$D$10:$D$33)","v":0},0,{"$f":"IF(OR(D18=Definitions!$B$25,D18=Definitions!$B$28,D18=Definitions!$B$30,D18=Definitions!$B$31,D18=Definitions!$B$33,D18=Definitions!$B$23,D18=Definitions!$B$24),('Stage 2.5 Std'!H18*0),H18)","v":0}]
[null,5,null,"-NONE-","-NONE-",null,null,0,{"$f":"_xlfn.XLOOKUP(D19,Definitions!$B$10:$B$33,Definitions!$D$10:$D$33)","v":0},0,{"$f":"IF(OR(D19=Definitions!$B$25,D19=Definitions!$B$28,D19=Definitions!$B$30,D19=Definitions!$B$31,D19=Definitions!$B$33,D19=Definitions!$B$23,D19=Definitions!$B$24),('Stage 2.5 Std'!H19*0),H19)","v":0}]
[null,6,null,"-NONE-","-NONE-",null,null,0,{"$f":"_xlfn.XLOOKUP(D20,Definitions!$B$10:$B$33,Definitions!$D$10:$D$33)","v":0},0,{"$f":"IF(OR(D20=Definitions!$B$25,D20=Definitions!$B$28,D20=Definitions!$B$30,D20=Definitions!$B$31,D20=Definitions!$B$33,D20=Definitions!$B$23,D20=Definitions!$B$24),('Stage 2.5 Std'!H20*0),H20)","v":0}]
[null,7,null,"-NONE-","-NONE-",null,null,0,{"$f":"_xlfn.XLOOKUP(D21,Definitions!$B$10:$B$33,Definitions!$D$10:$D$33)","v":0},0,{"$f":"IF(OR(D21=Definitions!$B$25,D21=Definitions!$B$28,D21=Definitions!$B$30,D21=Definitions!$B$31,D21=Definitions!$B$33,D21=Definitions!$B$23,D21=Definitions!$B$24),('Stage 2.5 Std'!H21*0),H21)","v":0}]
[null,8,null,"-NONE-","-NONE-",null,null,0,{"$f":"_xlfn.XLOOKUP(D22,Definitions!$B$10:$B$33,Definitions!$D$10:$D$33)","v":0},0,{"$f":"IF(OR(D22=Definitions!$B$25,D22=Definitions!$B$28,D22=Definitions!$B$30,D22=Definitions!$B$31,D22=Definitions!$B$33,D22=Definitions!$B$23,D22=Definitions!$B$24),('Stage 2.5 Std'!H22*0),H22)","v":0}]
[null,9,null,"-NONE-","-NONE-",null,null,0,{"$f":"_xlfn.XLOOKUP(D23,Definitions!$B$10:$B$33,Definitions!$D$10:$D$33)","v":0},0,{"$f":"IF(OR(D23=Definitions!$B$25,D23=Definitions!$B$28,D23=Definitions!$B$30,D23=Definitions!$B$31,D23=Definitions!$B$33,D23=Definitions!$B$23,D23=Definitions!$B$24),('Stage 2.5 Std'!H23*0),H23)","v":0}]
[null,10,null,"-NONE-","-NONE-",null,null,0,{"$f":"_xlfn.XLOOKUP(D24,Definitions!$B$10:$B$33,Definitions!$D$10:$D$33)","v":0},0,{"$f":"IF(OR(D24=Definitions!$B$25,D24=Definitions!$B$28,D24=Definitions!$B$30,D24=Definitions!$B$31,D24=Definitions!$B$33,D24=Definitions!$B$23,D24=Definitions!$B$24),('Stage 2.5 Std'!H24*0),H24)","v":0}]
[null,11,null,"-NONE-","-NONE-",null,null,0,{"$f":"_xlfn.XLOOKUP(D25,Definitions!$B$10:$B$33,Definitions!$D$10:$D$33)","v":0},0,{"$f":"IF(OR(D25=Definitions!$B$25,D25=Definitions!$B$28,D25=Definitions!$B$30,D25=Definitions!$B$31,D25=Definitions!$B$33,D25=Definitions!$B$23,D25=Definitions!$B$24),('Stage 2.5 Std'!H25*0),H25)","v":0}]
[null,12,null,"-NONE-","-NONE-",null,null,0,{"$f":"_xlfn.XLOOKUP(D26,Definitions!$B$10:$B$33,Definitions!$D$10:$D$33)","v":0},0,{"$f":"IF(OR(D26=Definitions!$B$25,D26=Definitions!$B$28,D26=Definitions!$B$30,D26=Definitions!$B$31,D26=Definitions!$B$33,D26=Definitions!$B$23,D26=Definitions!$B$24),('Stage 2.5 Std'!H26*0),H26)","v":0}]
[null,13,null,"-NONE-","-NONE-",null,null,0,{"$f":"_xlfn.XLOOKUP(D27,Definitions!$B$10:$B$33,Definitions!$D$10:$D$33)","v":0},0,{"$f":"IF(OR(D27=Definitions!$B$25,D27=Definitions!$B$28,D27=Definitions!$B$30,D27=Definitions!$B$31,D27=Definitions!$B$33,D27=Definitions!$B$23,D27=Definitions!$B$24),('Stage 2.5 Std'!H27*0),H27)","v":0}]
[null,14,null,"-NONE-","-NONE-",null,null,0,{"$f":"_xlfn.XLOOKUP(D28,Definitions!$B$10:$B$33,Definitions!$D$10:$D$33)","v":0},0,{"$f":"IF(OR(D28=Definitions!$B$25,D28=Definitions!$B$28,D28=Definitions!$B$30,D28=Definitions!$B$31,D28=Definitions!$B$33,D28=Definitions!$B$23,D28=Definitions!$B$24),('Stage 2.5 Std'!H28*0),H28)","v":0}]
[null,15,null,"-NONE-","-NONE-",null,null,0,{"$f":"_xlfn.XLOOKUP(D29,Definitions!$B$10:$B$33,Definitions!$D$10:$D$33)","v":0},0,{"$f":"IF(OR(D29=Definitions!$B$25,D29=Definitions!$B$28,D29=Definitions!$B$30,D29=Definitions!$B$31,D29=Definitions!$B$33,D29=Definitions!$B$23,D29=Definitions!$B$24),('Stage 2.5 Std'!H29*0),H29)","v":0}]
[null,16,null,"-NONE-","-NONE-",null,null,0,{"$f":"_xlfn.XLOOKUP(D30,Definitions!$B$10:$B$33,Definitions!$D$10:$D$33)","v":0},0,{"$f":"IF(OR(D30=Definitions!$B$25,D30=Definitions!$B$28,D30=Definitions!$B$30,D30=Definitions!$B$31,D30=Definitions!$B$33,D30=Definitions!$B$23,D30=Definitions!$B$24),('Stage 2.5 Std'!H30*0),H30)","v":0}]
[null,17,null,"-NONE-","-NONE-",null,null,0,{"$f":"_xlfn.XLOOKUP(D31,Definitions!$B$10:$B$33,Definitions!$D$10:$D$33)","v":0},0,{"$f":"IF(OR(D31=Definitions!$B$25,D31=Definitions!$B$28,D31=Definitions!$B$30,D31=Definitions!$B$31,D31=Definitions!$B$33,D31=Definitions!$B$23,D31=Definitions!$B$24),('Stage 2.5 Std'!H31*0),H31)","v":0}]
[null,18,null,"-NONE-","-NONE-",null,null,0,{"$f":"_xlfn.XLOOKUP(D32,Definitions!$B$10:$B$33,Definitions!$D$10:$D$33)","v":0},0,{"$f":"IF(OR(D32=Definitions!$B$25,D32=Definitions!$B$28,D32=Definitions!$B$30,D32=Definitions!$B$31,D32=Definitions!$B$33,D32=Definitions!$B$23,D32=Definitions!$B$24),('Stage 2.5 Std'!H32*0),H32)","v":0}]
[null,19,null,"-NONE-","-NONE-",null,null,0,{"$f":"_xlfn.XLOOKUP(D33,Definitions!$B$10:$B$33,Definitions!$D$10:$D$33)","v":0},0,{"$f":"IF(OR(D33=Definitions!$B$25,D33=Definitions!$B$28,D33=Definitions!$B$30,D33=Definitions!$B$31,D33=Definitions!$B$33,D33=Definitions!$B$23,D33=Definitions!$B$24),('Stage 2.5 Std'!H33*0),H33)","v":0}]
[null,20,null,"-NONE-","-NONE-",null,null,0,{"$f":"_xlfn.XLOOKUP(D34,Definitions!$B$10:$B$33,Definitions!$D$10:$D$33)","v":0},0,{"$f":"IF(OR(D34=Definitions!$B$25,D34=Definitions!$B$28,D34=Definitions!$B$30,D34=Definitions!$B$31,D34=Definitions!$B$33,D34=Definitions!$B$23,D34=Definitions!$B$24),('Stage 2.5 Std'!H34*0),H34)","v":0}]
[null,21,null,"-NONE-","-NONE-",null,null,0,{"$f":"_xlfn.XLOOKUP(D35,Definitions!$B$10:$B$33,Definitions!$D$10:$D$33)","v":0},0,{"$f":"IF(OR(D35=Definitions!$B$25,D35=Definitions!$B$28,D35=Definitions!$B$30,D35=Definitions!$B$31,D35=Definitions!$B$33,D35=Definitions!$B$23,D35=Definitions!$B$24),('Stage 2.5 Std'!H35*0),H35)","v":0}]
[null,22,null,"-NONE-","-NONE-",null,null,0,{"$f":"_xlfn.XLOOKUP(D36,Definitions!$B$10:$B$33,Definitions!$D$10:$D$33)","v":0},0,{"$f":"IF(OR(D36=Definitions!$B$25,D36=Definitions!$B$28,D36=Definitions!$B$30,D36=Definitions!$B$31,D36=Definitions!$B$33,D36=Definitions!$B$23,D36=Definitions!$B$24),('Stage 2.5 Std'!H36*0),H36)","v":0}]
[null,23,null,"-NONE-","-NONE-",null,null,0,{"$f":"_xlfn.XLOOKUP(D37,Definitions!$B$10:$B$33,Definitions!$D$10:$D$33)","v":0},0,{"$f":"IF(OR(D37=Definitions!$B$25,D37=Definitions!$B$28,D37=Definitions!$B$30,D37=Definitions!$B$31,D37=Definitions!$B$33,D37=Definitions!$B$23,D37=Definitions!$B$24),('Stage 2.5 Std'!H37*0),H37)","v":0}]
[null,24,null,"-NONE-","-NONE-",null,null,0,{"$f":"_xlfn.XLOOKUP(D38,Definitions!$B$10:$B$33,Definitions!$D$10:$D$33)","v":0},0,{"$f":"IF(OR(D38=Definitions!$B$25,D38=Definitions!$B$28,D38=Definitions!$B$30,D38=Definitions!$B$31,D38=Definitions!$B$33,D38=Definitions!$B$23,D38=Definitions!$B$24),('Stage 2.5 Std'!H38*0),H38)","v":0}]
[null,25,null,"-NONE-","-NONE-",null,null,0,{"$f":"_xlfn.XLOOKUP(D39,Definitions!$B$10:$B$33,Definitions!$D$10:$D$33)","v":0},0,{"$f":"IF(OR(D39=Definitions!$B$25,D39=Definitions!$B$28,D39=Definitions!$B$30,D39=Definitions!$B$31,D39=Definitions!$B$33,D39=Definitions!$B$23,D39=Definitions!$B$24),('Stage 2.5 Std'!H39*0),H39)","v":0}]
[]
[null,null,null,null,null,null,"SUB TOTAL FOR CONSTRUCTION",{"$f":"SUM(H15:H40)","v":0},null,{"$f":"SUM(J15:J40)","v":0},{"$f":"SUM(K15:K40)","v":0}]
[]
[]
[null,"TYPE OF WORK - REFURBISHMENT (70% OF STANDARD CONSTRUCTION COSTS)"]
[null,null,"Facility Description","Facility ID Code","Sector","Size chosen per unit \n(m2)","No of Units","Total Area (m2)","Refurbishment Cost per \n(m2) ","Refurbishment"]
[]
[null,21,null,"-NONE-","-NONE-",null,null,0,{"$f":"_xlfn.XLOOKUP(D47,Definitions!$B$10:$B$33,Definitions!$F$10:$F$33)","v":0},{"$f":"H47*I47","v":0}]
[null,22,null,"-NONE-","-NONE-",null,null,0,{"$f":"_xlfn.XLOOKUP(D48,Definitions!$B$10:$B$33,Definitions!$F$10:$F$33)","v":0},0]
[null,23,null,"-NONE-","-NONE-",null,null,0,{"$f":"_xlfn.XLOOKUP(D49,Definitions!$B$10:$B$33,Definitions!$F$10:$F$33)","v":0},0]
[null,24,null,"-NONE-","-NONE-",null,null,0,{"$f":"_xlfn.XLOOKUP(D50,Definitions!$B$10:$B$33,Definitions!$F$10:$F$33)","v":0},0]
[null,25,null,"-NONE-","-NONE-",null,null,0,{"$f":"_xlfn.XLOOKUP(D51,Definitions!$B$10:$B$33,Definitions!$F$10:$F$33)","v":0},0]
[null,26,null,"-NONE-","-NONE-",null,null,0,{"$f":"_xlfn.XLOOKUP(D52,Definitions!$B$10:$B$33,Definitions!$F$10:$F$33)","v":0},0]
[null,27,null,"-NONE-","-NONE-",null,null,0,{"$f":"_xlfn.XLOOKUP(D53,Definitions!$B$10:$B$33,Definitions!$F$10:$F$33)","v":0},0]
[null,28,null,"-NONE-","-NONE-",null,null,0,{"$f":"_xlfn.XLOOKUP(D54,Definitions!$B$10:$B$33,Definitions!$F$10:$F$33)","v":0},0]
[null,29,null,"-NONE-","-NONE-",null,null,0,{"$f":"_xlfn.XLOOKUP(D55,Definitions!$B$10:$B$33,Definitions!$F$10:$F$33)","v":0},0]
[null,30,null,"-NONE-","-NONE-",null,null,0,{"$f":"_xlfn.XLOOKUP(D56,Definitions!$B$10:$B$33,Definitions!$F$10:$F$33)","v":0},0]
[null,31,null,"-NONE-","-NONE-",null,null,0,{"$f":"_xlfn.XLOOKUP(D57,Definitions!$B$10:$B$33,Definitions!$F$10:$F$33)","v":0},0]
[null,32,null,"-NONE-","-NONE-",null,null,0,{"$f":"_xlfn.XLOOKUP(D58,Definitions!$B$10:$B$33,Definitions!$F$10:$F$33)","v":0},0]
[null,33,null,"-NONE-","-NONE-",null,null,0,{"$f":"_xlfn.XLOOKUP(D59,Definitions!$B$10:$B$33,Definitions!$F$10:$F$33)","v":0},0]
[null,34,null,"-NONE-","-NONE-",null,null,0,{"$f":"_xlfn.XLOOKUP(D60,Definitions!$B$10:$B$33,Definitions!$F$10:$F$33)","v":0},0]
[null,35,null,"-NONE-","-NONE-",null,null,0,{"$f":"_xlfn.XLOOKUP(D61,Definitions!$B$10:$B$33,Definitions!$F$10:$F$33)","v":0},0]
[null,36,null,"-NONE-","-NONE-",null,null,0,{"$f":"_xlfn.XLOOKUP(D62,Definitions!$B$10:$B$33,Definitions!$F$10:$F$33)","v":0},0]
[null,37,null,"-NONE-","-NONE-",null,null,0,{"$f":"_xlfn.XLOOKUP(D63,Definitions!$B$10:$B$33,Definitions!$F$10:$F$33)","v":0},0]
[null,38,null,"-NONE-","-NONE-",null,null,0,{"$f":"_xlfn.XLOOKUP(D64,Definitions!$B$10:$B$33,Definitions!$F$10:$F$33)","v":0},0]
[null,39,null,"-NONE-","-NONE-",null,null,0,{"$f":"_xlfn.XLOOKUP(D65,Definitions!$B$10:$B$33,Definitions!$F$10:$F$33)","v":0},0]
[null,40,null,"-NONE-","-NONE-",null,null,0,{"$f":"_xlfn.XLOOKUP(D66,Definitions!$B$10:$B$33,Definitions!$F$10:$F$33)","v":0},0]
[null,36,null,"-NONE-","-NONE-",null,null,0,{"$f":"_xlfn.XLOOKUP(D67,Definitions!$B$10:$B$33,Definitions!$F$10:$F$33)","v":0},0]
[null,37,null,"-NONE-","-NONE-",null,null,0,{"$f":"_xlfn.XLOOKUP(D68,Definitions!$B$10:$B$33,Definitions!$F$10:$F$33)","v":0},0]
[null,38,null,"-NONE-","-NONE-",null,null,0,{"$f":"_xlfn.XLOOKUP(D69,Definitions!$B$10:$B$33,Definitions!$F$10:$F$33)","v":0},0]
[null,39,null,"-NONE-","-NONE-",null,null,0,{"$f":"_xlfn.XLOOKUP(D70,Definitions!$B$10:$B$33,Definitions!$F$10:$F$33)","v":0},0]
[null,40,null,"-NONE-","-NONE-",null,null,0,{"$f":"_xlfn.XLOOKUP(D71,Definitions!$B$10:$B$33,Definitions!$F$10:$F$33)","v":0},0]
[]
[null,null,null,null,null,null,"SUB TOTAL FOR REFURBISHMENT",{"$f":"SUM(H47:H72)","v":0},null,{"$f":"SUM(J47:J72)","v":0}]
[]
[null,null,null,null,null,null,"TOTAL PROJECT COST",{"$f":"H41+H73","v":0},"Total A",{"$f":"J41+J73","v":0},{"$f":"K41","v":0}]
[]
[null,"B) Estimated Associated Costs for Proposed Project. "]
[]
[null,null,"Do not include Construction, Design or Country Loading Contingencies in this section. "]
[null,null,"Select from the list below to enter Estimated Associated Costs",null,null,"Additional Details",null,null,null,"Amount $","% of Total Project Cost"]
[null,null,"Select from list",null,null,null,null,null,null,0,{"$f":"IF($J$75=0,0,J81/$J$75)","v":0},{"$f":"IF(K81>15%,\"Check costs\",\"OK\")","v":"OK"}]
[null,null,"Select from list",null,null,null,null,null,null,0,0,{"$f":"IF(K82>15%,\"Check costs\",\"OK\")","v":"OK"}]
[null,null,"Select from list",null,null,null,null,null,null,0,0,"OK"]
[null,null,"Select from list",null,null,null,null,null,null,0,0,"OK"]
[null,null,"Select from list",null,null,null,null,null,null,0,0,"OK"]
[null,null,"Select from list",null,null,null,null,null,null,0,0,"OK"]
[null,null,"Select from list",null,null,null,null,null,null,0,0,"OK"]
[null,null,"Select from list",null,null,null,null,null,null,0,0,"OK"]
[null,null,"Select from list",null,null,null,null,null,null,0,0,"OK"]
[null,null,"Select from list",null,null,null,null,null,null,0,0,"OK"]
[null,null,"Select from list",null,null,null,null,null,null,0,0,"OK"]
[null,null,"Select from list",null,null,null,null,null,null,0,0,"OK"]
[null,null,"Select from list",null,null,null,null,null,null,0,0,"OK"]
[null,null,"Select from list",null,null,null,null,null,null,0,0,"OK"]
[null,null,"Select from list",null,null,null,null,null,null,0,0,"OK"]
[null,null,"Select from list",null,null,null,null,null,null,0,0,"OK"]
[null,null,"Select from list",null,null,null,null,null,null,0,0,"OK"]
[null,null,null,null,null,null,null,null,null,0,0,"OK"]
[null,null,null,null,null,null,null,null,null,0,0,"OK"]
[null,null,null,null,null,null,null,null,null,0,0,"OK"]
[null,null,null,null,null,null,null,null,null,0,0,"OK"]
[null,null,null,null,null,null,null,null,null,0,0,"OK"]
[null,null,null,null,null,null,null,null,"Total B",{"$f":"SUM(J81:J102)","v":0},0]
[]
[null,"C) Total Project Costs based on STANDARD COSTS"]
[]
[null,"Proposed Project at STANDARD/REFURBISHMENT cost as per above"]
[null,null,null,null,null,null,null,null,null,"Estimation $"]
[null,null,"Building Construction/Refurbishment Costs",null,null,null,null,null,"Total A",{"$f":"J75","v":0}]
[null,null,"Estimated Associated Costs",null,null,null,null,null,"Total B",{"$f":"J103","v":0}]
[null,null,"PROJECT AT STANDARD COST EXCLUDING CONTINGENCIES",null,null,null,null,null,null,{"$f":"SUM(J109:J110)","v":0}]

{"sheet":"Stage 2.5 QS","index":8,"n_rows":54,"n_cols":11,"rows_kept":54,"cut":false,"hidden":false,"merged":[[54,2,59,11],[46,2,46,7],[47,2,47,7],[23,2,23,7],[24,2,24,7],[32,2,32,7],[33,2,33,7],[36,2,36,7],[37,2,37,7],[45,2,45,7],[22,2,22,7],[31,2,31,7],[44,2,44,7],[38,2,38,7],[2,3,2,11],[3,3,3,4],[5,1,5,11],[42,2,42,7]]}
[null,"SOUTH AUSTRALIA INDEPENDENT SCHOOLS BLOCK GRANT AUTHORITY"]
[null,"PROPOSED PROJECT AS PER COST ESTIMATE BY QUANTITY SURVEYOR"]
[null,"School Name",null,{"$f":"'Stage 1.1'!SchoolName","v":0}]
[null,"AGEID",null,{"$f":"'Stage 1.1'!ageid","v":0}]
[]
[]
[]
[null,"A) Project Costs based on QS or Quotation."]
[]
[null,null,"When a QS or Quotation is available please update the section below.  Please note that a QS is Mandatory at Stage 3."]
[null,null,null,null,null,null,null,null,null,"Cost $"]
[null,null,null,null,null,null,null,null," PROJECT COST EXC GST  (Includes Contingencies)",null,"As per the QS"]
[null,null,"DEDUCT the Contingencies as per QS "]
[null,null,"Construction Contingencies"]
[null,null,"Design Contingencies",null,null,null,null,null,0]
[null,null,"Country loading",null,null,null,null,null,0,{"$f":"SUM(I14:I16)","v":0}]
[]
[null,null,null,null,null,null,null,null," PROJECT COST EXC GST  (Excluding Contingencies)",{"$f":"J12-J16","v":0}]
[]
[null,null,"ADJUSTMENTS If adjustments to the QS are required by the school, please complete the sections below as required. "]
[]
[null,null,"ADD ITEMS not included in QS (e.g. relocation of transportable, loose furniture etc)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(I23:I34)","v":0}]
[]
[null,null,"DEDUCT ITEMS included in QS not  applicable to this application (e.g. loose furniture, demolition, etc)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(I37:I48)","v":0}]
[]
[null,null,null,null,null,null,null,null," FINAL PROJECT COST EXC GST  (Excluding Contingencies)",{"$f":"J18+J34-J48","v":0}]
[]
[null,null,null,null,null,null,null,null,"MARGIN BETWEEN STANDARD COST & QS",{"$f":"J50-'Stage 2.5 Std'!J111","v":0},{"$f":"IF(J52>0,\"Over Standard Cost\",\"Under Standard Cost\")","v":"Under Standard Cost"}]
[]
[null,null,"** Additional explanation re adjustments to QS or Quotation made by the school below. The QS or Quotation MUST be submitted when lodging application"]

{"sheet":"Stage 2.6","index":9,"n_rows":32,"n_cols":13,"rows_kept":32,"cut":false,"hidden":false,"merged":[[2,3,2,11],[3,3,3,4],[5,1,5,13],[6,2,6,12],[21,2,21,5],[10,2,10,5],[13,2,13,5],[14,2,14,5],[15,2,15,5],[16,2,16,5],[18,2,18,5],[16,10,16,11],[11,2,11,5],[10,10,10,11],[11,10,11,11],[13,10,13,11],[14,10,14,11],[12,2,12,5],[32,2,32,12],[23,2,23,5],[24,2,24,5],[25,2,25,5],[26,2,26,5],[28,2,28,5],[30,2,30,5],[30,7,30,13],[22,2,22,5]]}
[null,"SOUTH AUSTRALIA INDEPENDENT SCHOOLS BLOCK GRANT AUTHORITY"]
[null,"Stage 2 INITIAL APPLICATION"]
[null,"School Name",null,{"$f":"'Stage 1.1'!SchoolName","v":0}]
[null,"AGEID",null,{"$f":"'Stage 1.1'!ageid","v":0}]
[null,"2.6 Project Funding "]
[]
[null,null,"More detail will be required from applicants invited to proceed with final project documentation.  The BGA must assess all sources of funds available to the school and requires the school to make the maximum contribution possible, including loans, without preventing the provision of an adequate level of recurrent resources or jeopardising the school's financial viability."]
[]
[null,null,"Amounts prefilled from Stage 2.5 Proposed Project",null,null,null,"QS/School Cost",null,"Standard Cost (inc Assoc Costs)",null,null,"Difference"]
[]
[null,null,"TOTAL COST OF PROJECT (Inc Contingencies)",null,null,null,{"$f":"'Stage 2.5 QS'!J12","v":0}]
[null,null,"Add Items not shown on QS",null,null,null,{"$f":"'Stage 2.5 QS'!J34","v":0}]
[null,null,"Less Items removed from QS",null,null,null,{"$f":"'Stage 2.5 QS'!J48","v":0}]
[null,null,"Less Construction Contingencies",null,null,null,{"$f":"'Stage 2.5 QS'!I14","v":0}]
[null,null,"Less Design Contingencies",null,null,null,{"$f":"'Stage 2.5 QS'!I15","v":0}]
[null,null,"Less Country Loading",null,null,null,{"$f":"'Stage 2.5 QS'!I16","v":0}]
[null,null,"TOTAL RECOMMENDED PROJECT COST (Exc Contingencies)",null,null,null,{"$f":"G11+G12-G13-G14-G15-G16","v":0},null,{"$f":"'Stage 2.5 Std'!J111","v":0},null,{"$f":"G17-I17","v":0},null,{"$f":"IF(K17>0,\"Over Standard Cost\",\"Under Standard Cost\")","v":"Under Standard Cost"}]
[]
[null,null,"BGA GRANT REQUESTED/INDICATIVE GRANT",null,null,null,0,{"$f":"G19/G17","v":{"$error":"#DIV/0!"}},"Please note the BGA will not consider a grant > $1.250m"]
[]
[null,null,"SCHOOL CONTRIBUTION - HOW FUNDED"]
[null,null,"School Building Fund/Levy on Fees",null,null,null,0]
[null,null,"Donations/Fundraising (e.g. Parent Bodies)",null,null,null,0]
[null,null,"Other cash sources (please specify below)",null,null,null,0]
[null,null,"Contributed services (approximate value)",null,null,null,0]
[null,null,"Anticipated loans including those from System Authorities",null,null,null,0]
[null,null,"TOTAL FUNDS TO BE CONTRIBUTED",null,null,null,{"$f":"SUM(G22:G26)","v":0},{"$f":"G27/G17","v":{"$error":"#DIV/0!"}}]
[]
[null,null,"SCHOOL CONTRIBUTION REQUIRED ",null,null,null,{"$f":"G17-G19","v":0}]
[]
[null,null,"Balance to be allocated",null,null,null,{"$f":"G29-G27","v":0},"If \"Balance to be allocated\" is not = to zero, check \nallocations of School Contribution above. "]
[null,null,"Any additional comments:"]

{"sheet":"Stage 2.7","index":10,"n_rows":31,"n_cols":11,"rows_kept":31,"cut":false,"hidden":false,"merged":[[3,3,3,4],[1,1,1,11],[0,1,0,11],[2,3,2,10],[4,1,4,11],[14,9,14,10],[14,7,14,8],[6,6,6,8],[13,9,13,10],[13,7,13,8]]}
[null,"SOUTH AUSTRALIA INDEPENDENT SCHOOLS BLOCK GRANT AUTHORITY"]
[null,"Stage 2 INITIAL APPLICATION"]
[null,"School Name",null,{"$f":"'Stage 1.1'!SchoolName","v":0}]
[null,"AGEID",null,{"$f":"'Stage 1.1'!ageid","v":0}]
[null,"2.7 Area Summary"]
[]
[null,null,"Teaching Space Area"]
[null,null,"Not including proposed project",2024,2026,null,"Proposed Project(s) Teaching Space","Project"]
[null,null,"Primary",{"$f":"SUMIF('Stage 2.4'!$F$11:$F$85,\"Primary\",'Stage 2.4'!$M$11:$M$85)","v":0},{"$f":"SUMIF('Stage 2.4'!$F$11:$F$85,\"Primary\",'Stage 2.4'!$N$11:$N$85)","v":0},null,"Primary",{"$f":"SUMIF('Stage 2.5 Std'!E15:E39,\"Primary\",'Stage 2.5 Std'!K15:K39)","v":0}]
[null,null,"Secondary",{"$f":"SUMIF('Stage 2.4'!$F$11:$F$85,\"Secondary\",'Stage 2.4'!$M$11:$M$85)","v":0},{"$f":"SUMIF('Stage 2.4'!$F$11:$F85,\"Secondary\",'Stage 2.4'!$N$11:$N$85)","v":0},null,"Secondary",{"$f":"SUMIF('Stage 2.5 Std'!E15:E39,\"Secondary\",'Stage 2.5 Std'!K15:K39)","v":0}]
[null,null,"Combined",{"$f":"SUMIF('Stage 2.4'!$F$11:$F$85,\"Combined\",'Stage 2.4'!$M$11:$M$85)","v":0},{"$f":"SUMIF('Stage 2.4'!$F$11:$F$85,\"Combined\",'Stage 2.4'!$N$11:$N$85)","v":0},null,"Combined",{"$f":"SUMIF('Stage 2.5 Std'!E15:E39,\"Combined\",'Stage 2.5 Std'!K15:K39)","v":0}]
[null,null,"Total Teaching Space",{"$f":"SUM(D9:D11)","v":0},{"$f":"SUM(E9:E11)","v":0},null,"Total Teaching Space",{"$f":"SUM(H9:H11)","v":0}]
[]
[null,null,"Teaching Space Area",null,null,null,null,"Before proposed project",null,"After project completed"]
[null,null,"Including the proposed project",2024,2026,null,"Enrolments",2024,null,2026]
[null,null,"Primary",{"$f":"D9","v":0},{"$f":"E9+H9","v":0},null,"Primary",{"$f":"'Stage 2.3'!D15","v":0},{"$f":"H16/H18","v":{"$error":"#DIV/0!"}},{"$f":"'Stage 2.3'!D19","v":0},{"$f":"J16/J18","v":{"$error":"#DIV/0!"}}]
[null,null,"Secondary",{"$f":"D10","v":0},{"$f":"E10+H10","v":0},null,"Secondary",{"$f":"'Stage 2.3'!G15","v":0},{"$f":"H17/H18","v":{"$error":"#DIV/0!"}},{"$f":"'Stage 2.3'!G19","v":0},{"$f":"J17/J18","v":{"$error":"#DIV/0!"}}]
[null,null,"Combined",{"$f":"D11","v":0},{"$f":"E11+H11","v":0},null,"Total Students",{"$f":"SUM(H16:H17)","v":0},{"$f":"SUM(I16:I17)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(J16:J17)","v":0},{"$f":"SUM(K16:K17)","v":{"$error":"#DIV/0!"}}]
[null,null,"Total Teaching Space",{"$f":"SUM(D16:D18)","v":0},{"$f":"SUM(E16:E18)","v":0}]
[]
[null,null,"Combined Area Split by %",2024,2026,null,"Area per Student","Standard",2024]
[null,null,"Primary proportion of combined",{"$f":"D18*I16","v":{"$error":"#DIV/0!"}},{"$f":"E18*K16","v":{"$error":"#DIV/0!"}},null,"Primary",7.5,{"$f":"IF(H16,D28/H16,0)","v":0},{"$f":"IF(I22>7.5,\"Over Standard Area Guidelines!\",\"OK\")","v":"OK"}]
[null,null,"Secondary proportion of combined",{"$f":"D18*I17","v":{"$error":"#DIV/0!"}},{"$f":"E18*K17","v":{"$error":"#DIV/0!"}},null,"Secondary",12,{"$f":"IF(H17,D29/H17,0)","v":0},{"$f":"IF(I23>12,\"Over Standard Area Guidelines!\",\"OK\")","v":"OK"}]
[]
[null,null,"Total of Combined Area",{"$f":"SUM(D22:D23)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E22:E23)","v":{"$error":"#DIV/0!"}},null,"Area per Student","Standard",2026]
[null,null,null,null,null,null,"Primary",7.5,{"$f":"IF(J16,E28/J16,0)","v":0},{"$f":"IF(I26>7.5,\"Over Standard Area Guidelines!\",\"OK\")","v":"OK"}]
[null,null,"Total Area",2024,2026,null,"Secondary",12,{"$f":"IF(J17,E29/J17,0)","v":0},{"$f":"IF(I27>12,\"Over Standard Area Guidelines!\",\"OK\")","v":"OK"}]
[null,null,"Primary including Split of Combined",{"$f":"D16+D22","v":{"$error":"#DIV/0!"}},{"$f":"E16+E22","v":{"$error":"#DIV/0!"}}]
[null,null,"Secondary including Split of Combined",{"$f":"D17+D23","v":{"$error":"#DIV/0!"}},{"$f":"E17+E23","v":{"$error":"#DIV/0!"}}]
[]
[null,null,"Total of Combined Area",{"$f":"SUM(D28:D29)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E28:E29)","v":{"$error":"#DIV/0!"}}]

{"sheet":"Stage 2.8","index":11,"n_rows":69,"n_cols":10,"rows_kept":69,"cut":false,"hidden":false,"merged":[[69,2,69,9],[8,2,8,3],[4,1,4,10],[6,1,6,9],[0,1,0,11],[1,1,1,11],[2,3,2,10],[3,3,3,4]]}
[null,"SOUTH AUSTRALIA INDEPENDENT SCHOOLS BLOCK GRANT AUTHORITY"]
[null,"Stage 2 INITIAL APPLICATION"]
[null,"School Name",null,{"$f":"'Stage 1.1'!SchoolName","v":0}]
[null,"AGEID",null,{"$f":"'Stage 1.1'!ageid","v":0}]
[null,"2.8 Capex Budget"]
[]
[null,"Please detail your Capex Budget, by over-typing with your own descriptions in column B.  Mark the items with an X that are part of your Master Plan. The Totals on this page flow automatically to the Stage 2.9 Financial Forecast tab. "]
[null,null,null,null,null,null,"** can be adjusted on Stage 2.5"]
[null,null,"Is this part of Master Plan",null,"2023 Actual","2024 Budget","2025 Forecast","2026 Forecast","2027 Forecast","2028 Forecast"]
[]
[null,"This PROPOSED BGA project (total Cost)"]
[null,null,"Project","No ",null,null,{"$f":"'Stage 2.6'!G17","v":0},"**"]
[]
[null,"Other CAPITAL Expenditure"]
[null,null,"Land"]
[null,null,"Description #1","No "]
[null,null,"Description #2","No "]
[null,null,"Description #3","No "]
[null,null,null,null,{"$f":"SUM(E16:E18)","v":0},0,0,0,0,0]
[null,null,"Buildings"]
[null,null,"Description #1","No "]
[null,null,"Description #2","No "]
[null,null,"Description #3","No "]
[null,null,"Description #4","No "]
[null,null,"Description #5","No "]
[null,null,"Description #6","No "]
[null,null,"Description #7","No "]
[null,null,"Description #8","No "]
[null,null,"Description #9","No "]
[null,null,"Description #10","No "]
[null,null,null,null,{"$f":"SUM(E21:E30)","v":0},0,0,0,0,0]
[null,null,"Site Improvements"]
[null,null,"Description #1","No "]
[null,null,"Description #2","No "]
[null,null,"Description #3","No "]
[null,null,"Description #4","No "]
[null,null,"Description #5","No "]
[null,null,"Description #6","No "]
[null,null,"Description #7","No "]
[null,null,"Description #8","No "]
[null,null,"Description #9","No "]
[null,null,"Description #10","No "]
[null,null,null,null,{"$f":"SUM(E33:E42)","v":0},0,0,0,0,0]
[null,null,"Furniture/Equipment/Plant/Machinery"]
[null,null,"Description #1","No "]
[null,null,"Description #2","No "]
[null,null,"Description #3","No "]
[null,null,"Description #4","No "]
[null,null,"Description #5","No "]
[null,null,"Description #6","No "]
[null,null,"Description #7","No "]
[null,null,"Description #8","No "]
[null,null,"Description #9","No "]
[null,null,"Description #10","No "]
[null,null,null,null,{"$f":"SUM(E45:E54)","v":0},0,0,0,0,0]
[null,"LOAN REPAYMENTS (Principal only)"]
[null,null,"Description #1","No "]
[null,null,"Description #2","No "]
[null,null,"Description #3","No "]
[null,null,"Description #4","No "]
[null,null,"Description #5","No "]
[null,null,"Description #6","No "]
[null,null,"Description #7","No "]
[null,null,"Description #8","No "]
[null,null,"Description #9","No "]
[null,null,"Description #10","No "]
[null,null,null,null,{"$f":"SUM(E57:E66)","v":0},0,0,0,0,0]
[]
[null,null,"Any additional comments either at Stage 2 or Stage 3:"]

{"sheet":"Stage 2.9","index":12,"n_rows":64,"n_cols":10,"rows_kept":64,"cut":false,"hidden":false,"merged":[[7,2,7,3],[64,2,64,9],[0,1,0,10],[1,1,1,10],[2,3,2,9],[3,3,3,4],[4,1,4,10],[6,1,6,9]]}
[null,"SOUTH AUSTRALIA INDEPENDENT SCHOOLS BLOCK GRANT AUTHORITY"]
[null,"Stage 2 INITIAL APPLICATION"]
[null,"School Name",null,{"$f":"'Stage 1.1'!SchoolName","v":0}]
[null,"AGEID",null,{"$f":"'Stage 1.1'!ageid","v":0}]
[null,"2.9 Financial Forecast"]
[]
[null,"Please enter data in the grey cells only.  White cells will calculate automatically.  The Capital Expenditure comes from 2.8 Capex Budget"]
[null,null,null,null,"2023 Actual","2024 Budget","2025 Forecast","2026 Forecast","2027 Forecast","2028 Forecast"]
[null,"Operations"]
[null,null,"Income"]
[null,null,"Fee income - tuition (gross)"]
[null,null,"Fee remissions (enter as negative)"]
[null,null,"Fee income - other"]
[null,null,"Recurrent government grants"]
[null,null,"Interest"]
[null,null,"Other income"]
[null,null,"Trading operations (nett)"]
[null,null,null,"Total Operating Income",{"$f":"SUM(E11:E17)","v":0},0,{"$f":"SUM(G11:G17)","v":0},{"$f":"SUM(H11:H17)","v":0},0,0]
[null,null,"Expenditure"]
[null,null,"Salaries and oncosts"]
[null,null,"Leave provisions"]
[null,null,"Education resources (inc excursions)"]
[null,null,"Administration costs"]
[null,null,"Property costs"]
[null,null,"Rent/Lease"]
[null,null,"Interest"]
[null,null,"Bad debt provision"]
[null,null,"Other Expenditure"]
[null,null,"Depreciation/Amortisation"]
[null,null,null,"Total Operating Expenditure",{"$f":"SUM(E20:E29)","v":0},0,0,0,0,0]
[]
[null,null,null,"Operating Surplus (Deficit)",{"$f":"E18-E30","v":0},0,0,0,0,0]
[null,"Capital"]
[null,null,"Income"]
[null,null,"Levies"]
[null,null,"Donations - Building Fund & other"]
[null,null,"State Government Capital Grants"]
[null,null,"BGA Grants - approved"]
[null,null,"BGA Grant - requested from Stage 2.6",null,null,null,{"$f":"'Stage 2.6'!G19","v":0}]
[null,null,"Loan drawdowns"]
[null,null,"Asset sales"]
[null,null,"Possible future BGA Grant"]
[null,null,"Total Capital Income",null,{"$f":"SUM(E35:E42)","v":0},0,0,0,0,0]
[null,null,"Expenditure"]
[null,null,"This BGA Project - total cost (can be adjusted on Stage 2.5)",null,null,null,{"$f":"'Stage 2.8'!G12","v":0}]
[null,null,"Land",null,{"$f":"'Stage 2.8'!E19","v":0},{"$f":"'Stage 2.8'!F19","v":0},{"$f":"'Stage 2.8'!G19","v":0},{"$f":"'Stage 2.8'!H19","v":0},{"$f":"'Stage 2.8'!I19","v":0},{"$f":"'Stage 2.8'!J19","v":0}]
[null,null,"Buildings",null,{"$f":"'Stage 2.8'!E31","v":0},{"$f":"'Stage 2.8'!F31","v":0},{"$f":"'Stage 2.8'!G31","v":0},{"$f":"'Stage 2.8'!H31","v":0},{"$f":"'Stage 2.8'!I31","v":0},{"$f":"'Stage 2.8'!J31","v":0}]
[null,null,"Site improvements",null,{"$f":"'Stage 2.8'!E43","v":0},{"$f":"'Stage 2.8'!F43","v":0},{"$f":"'Stage 2.8'!G43","v":0},{"$f":"'Stage 2.8'!H43","v":0},{"$f":"'Stage 2.8'!I43","v":0},{"$f":"'Stage 2.8'!J43","v":0}]
[null,null,"Furniture/Equipment/Plant/Machinery",null,{"$f":"'Stage 2.8'!E55","v":0},{"$f":"'Stage 2.8'!F55","v":0},{"$f":"'Stage 2.8'!G55","v":0},{"$f":"'Stage 2.8'!H55","v":0},{"$f":"'Stage 2.8'!I55","v":0},{"$f":"'Stage 2.8'!J55","v":0}]
[null,null,"Loan repayments (principal only)",null,{"$f":"'Stage 2.8'!E67","v":0},{"$f":"'Stage 2.8'!F67","v":0},{"$f":"'Stage 2.8'!G67","v":0},{"$f":"'Stage 2.8'!H67","v":0},{"$f":"'Stage 2.8'!I67","v":0},{"$f":"'Stage 2.8'!J67","v":0}]
[null,null,null,"Total Capital Expenditure",{"$f":"SUM(E45:E50)","v":0},0,0,0,0,0]
[]
[null,null,null,"Capital Surplus (Deficit)",{"$f":"E43-E51","v":0},0,0,0,0,0]
[]
[null,null,null,"Add back Depreciation & Amortisation, Provisions",{"$f":"E21+E27+E29","v":0},0,0,0,0,0]
[]
[null,null,null,"Nett Cash Surplus (Deficit)",{"$f":"E32+E53+E55","v":0},0,0,0,0,0]
[]
[null,null,null,"Opening Balance Cash at Bank",null,{"$f":"E60","v":0},{"$f":"F60","v":0},{"$f":"G60","v":0},{"$f":"H60","v":0},{"$f":"I60","v":0}]
[null,null,null,"Closing Balance Cash at Bank*",null,{"$f":"F57+F59","v":0},{"$f":"G57+G59","v":0},{"$f":"H57+H59","v":0},{"$f":"I57+I59","v":0},{"$f":"J57+J59","v":0}]
[]
[null,"* Enter ONLY the Closing Balance Cash at Bank for 2023. "]
[]
[null,null,"Any additional comments either at Stage 2 or Stage 3:"]

{"sheet":"Stage 3.1","index":13,"n_rows":79,"n_cols":10,"rows_kept":79,"cut":false,"hidden":false,"merged":[[0,1,0,10],[1,1,1,10],[2,3,2,9],[3,3,3,4],[4,1,4,10],[7,5,7,6],[11,6,11,7],[45,1,45,9],[49,1,49,2],[53,1,53,9],[8,2,8,8],[50,1,50,2],[48,3,48,9],[48,1,48,2],[13,8,13,9],[60,1,60,9],[57,1,57,9],[64,1,64,5],[65,1,65,5],[66,1,66,5],[68,8,68,9],[63,8,63,9],[63,6,63,7],[73,1,73,9],[76,7,76,9],[67,1,67,5],[64,6,64,7],[65,6,65,7],[66,6,66,7],[67,6,67,7],[64,8,64,9],[65,8,65,9],[66,8,66,9],[67,8,67,9]]}
[null,"SOUTH AUSTRALIA INDEPENDENT SCHOOLS BLOCK GRANT AUTHORITY"]
[null,"Stage 3 FINANCIAL INFORMATION"]
[null,"School Name",null,{"$f":"'Stage 1.1'!SchoolName","v":0}]
[null,"AGEID",null,{"$f":"'Stage 1.1'!ageid","v":0}]
[null,"3.1 Project  & Financial Information"]
[]
[null,"A) Update Project Description"]
[null,null,"Has the project description changed? ",null,null,"Select from list"]
[null,"Project",{"$f":"_xlfn.UNIQUE('Stage 1.2'!$B$10&\" \"&'Stage 1.2'!$C$10&\" \"&'Stage 1.2'!$B$11&\" \"&'Stage 1.2'!$C$11&\" \"&'Stage 1.2'!$B$12&\" \"&'Stage 1.2'!$C$12&\" \"&'Stage 1.2'!$B$13&\" \"&'Stage 1.2'!$C$13)","v":"       "},null,null,null,null,null,null,"UPDATE HERE"]
[]
[null,"B) Update Capex Budget and Financial Forecast"]
[null,"Has the Capex Budget and/or Financial Forecast changed?  ",null,null,null,null,"Select from list"]
[null,"Capex Budget","UPDATE HERE",null,null,"Financial Forecast","UPDATE HERE"]
[null,"The source of the information contained in this Return are from ",null,null,null,null,"Select one",2022,"Financial Statements"]
[null,"Please upload a copy of the Audited or Draft Financials when lodging the application. "]
[]
[null,"C) Update Project Costings"]
[]
[null,"Has the design of the project changed?",null,null,"Yes",{"$f":"IF(E19=\"Yes\",\"Go to the Proposed Project Standard Cost and update the facilities\",\"Go to next question\")","v":"Go to the Proposed Project Standard Cost and update the facilities"}]
[null,null,null,null,null,"CLICK HERE"]
[null,"A QS or quotation is mandatory at this Stage."]
[null,"Has the school obtained a QS?",null,null,"Yes",{"$f":"IF(E22=\"Yes\",\"Go to the Proposed Project QS Cost and update the costings\",\"Please source a QS or quotation to complete the next question\")","v":"Go to the Proposed Project QS Cost and update the costings"}]
[null,null,null,null,null,"CLICK HERE"]
[]
[null,"Total Project Cost (not inc Contingencies )",null,null,null,{"$f":"'Stage 2.6'!$G$17","v":0}]
[null,"School Contribution",null,null,null,{"$f":"F25-F27","v":0}]
[null,"Grant",null,null,null,{"$f":"'Stage 2.6'!G19","v":0}]
[]
[null,"For information purposes only"]
[null,"Contingencies Construct'n",null,null,null,{"$f":"(('Stage 2.6'!$G$14))","v":0}]
[null,"Contingencies Design",null,null,null,{"$f":"(('Stage 2.6'!$G$15))","v":0}]
[null,"Country Loading",null,null,null,{"$f":"(('Stage 2.6'!$G$16))","v":0}]
[null,null,null,null,null,{"$f":"SUM(F30:F32)","v":0}]
[]
[null,"D) Detail of Funding Sources for School Contribution"]
[null,"Please show type of funds to be used to fund each project.  The total of Cash + Borrowings MUST equal the School Contribution. "]
[null,null,null,null,null,"PROJECT"]
[null,"School Contribution",null,null,null,{"$f":"F26","v":0}]
[null,"Cash",null,null,null,0]
[null,"Borrowings"]
[]
[null,"Proof (This should be zero)",null,null,null,{"$f":"F38-F39-F40","v":0},{"$f":"IF(F42=0,\"Move to next field\",\"This field must be Zero.  Please correct figures above\")","v":"Move to next field"}]
[]
[null,"Details of cash contribution"]
[null,"Provide a brief summary detailing what cash sources will be used:"]
[]
[]
[null,"Details of borrowings"]
[null,"Name of lending authority"]
[null,"Amount",null,null,"Interest Rate",null,"Term "]
[null,"Annual Repayments"]
[]
[null,"What discussions, if any, have been held with lending authorities about the proposed loan(s)"]
[]
[]
[null,"Have the proposed borrowings been approved?"]
[null,"If not, what evidence is there that they will be approved?"]
[]
[]
[null,"E) Supporting Organisations"]
[null,"A 'supporting organisation' is an associated organisation which does not conduct its operations through the school's accounts but which commits or intends to commit funds for the provision of services, material, equipment or facilities for school use.\n\nExamples might be system authorities, the school community, a Foundation, development funds, parents and friends organisations, community associations, church/parish."]
[null,"Does your school have any supporting organisations?"]
[null,"If yes, please list these supporting organisations, and their contributions, to the Proposed Project. "]
[null,"Name of supporting organisation",null,null,null,null,"Year(s) of Support",null,"Amount $"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"TOTAL",{"$f":"SUM(I65:J68)","v":0}]
[null,"F) Financial Planning"]
[null,"Does your school have a financial plan that has been approved by your loan provider?",null,null,null,null,null,null,null,"If NO, CLICK HERE"]
[null,"If yes, what is the period covered by the plan? Enter start year and finish year",null,null,null,null,"From ",null,"To"]
[null,"What does your loan provider require you to report? (e.g. quarterly accounts, annual budgets etc)"]
[]
[null,"Does the plan make provision for the Proposed Project?"]
[null,"Do you have an external Financial Adviser?"]
[null,"If yes, who is the Adviser "]
[null,"Did the school participate in the ASBA/Somerset Financial Performance Survey last financial year"]
[null,"If yes, please upload the Summary Ratio Sheet that compares your ratios with benchmark ratios when lodging Stage 3. "]

{"sheet":"Stage 3.2","index":14,"n_rows":27,"n_cols":10,"rows_kept":27,"cut":false,"hidden":false,"merged":[[11,2,11,3],[17,2,17,3],[23,2,23,3],[0,1,0,10],[1,1,1,10],[2,3,2,9],[3,3,3,4],[4,1,4,10],[6,1,6,9],[7,2,7,3]]}
[null,"SOUTH AUSTRALIA INDEPENDENT SCHOOLS BLOCK GRANT AUTHORITY"]
[null,"Stage 3 FINANCIAL INFORMATION"]
[null,"School Name",null,{"$f":"'Stage 1.1'!SchoolName","v":0}]
[null,"AGEID",null,{"$f":"'Stage 1.1'!ageid","v":0}]
[null,"Stage 3.2 Debt Profile"]
[]
[null,"Please enter data in the grey cells only.  White cells will calculate automatically.  The Capital Expenditure comes from 2.8 Capex Budget"]
[null,null,null,null,2023,"2024 Budget","2025 Forecast","2026 Forecast","2027 Forecast","2028 Forecast"]
[null,"Refundable Enrolment Deposits"]
[null,"(a)","Opening balance",null,null,{"$f":"E13","v":0},{"$f":"F13","v":0},{"$f":"G13","v":0},{"$f":"H13","v":0},{"$f":"I13","v":0}]
[null,"(b)","Additional deposits during period"]
[null,"(c)","Deposits refunded during period \n(enter as positive)"]
[null,null,null,"Closing Balance  = (a) + (b) - (c)",{"$f":"E10+E11-E12","v":0},0,0,0,0,0]
[]
[null,"Recurrent Loans (including overdrafts, short-term loans from Building Funds and P&F Associations)"]
[null,"(a)","Opening balance",null,null,{"$f":"E19","v":0},{"$f":"F19","v":0},{"$f":"G19","v":0},{"$f":"H19","v":0},{"$f":"I19","v":0}]
[null,"(b)","Additional borrowing during period"]
[null,"(c)","Loans paid out during period \n(enter as positive)"]
[null,null,null,"Closing Balance  = (a) + (b) - (c)",{"$f":"E16+E17-E18","v":0},0,0,0,0,0]
[]
[null,"Capital & Bridging Loans (including loan for the proposed project)"]
[null,"(a)","Opening balance",null,null,{"$f":"E25","v":0},{"$f":"F25","v":0},{"$f":"G25","v":0},{"$f":"H25","v":0},{"$f":"I25","v":0}]
[null,"(b)","Additional borrowing during period"]
[null,"(c)","Principal repayments\n(enter as positive)",null,0]
[null,null,null,"Closing Balance  = (a) + (b) - (c) *",{"$f":"(E22+E23)-E24","v":0},{"$f":"F22+F23-F24","v":0},0,0,0,0]
[null,null,null,null,"NB: Must agree with Stage 3.3 Loans at end of this period"]
[null,"Loan for the Proposed Project (included in the figures above)"]

{"sheet":"Stage 3.3","index":15,"n_rows":39,"n_cols":11,"rows_kept":39,"cut":false,"hidden":false,"merged":[[37,3,37,4],[32,3,32,4],[33,3,33,4],[34,3,34,4],[35,3,35,4],[36,3,36,4],[25,10,26,10],[27,3,27,4],[28,3,28,4],[29,3,29,4],[30,3,30,4],[25,8,25,9],[39,1,39,10],[0,1,0,10],[1,1,1,10],[4,1,4,10],[9,10,10,10],[7,1,7,10],[9,8,9,9],[9,1,10,1],[9,2,10,2],[22,3,22,4],[9,3,10,4],[9,5,10,5],[9,6,10,6],[11,3,11,4],[12,3,12,4],[13,3,13,4],[2,2,2,8],[25,1,26,1],[25,2,26,2],[9,7,10,7],[18,3,18,4],[17,3,17,4],[25,7,26,7],[19,3,19,4],[20,3,20,4],[16,3,16,4],[14,3,14,4],[15,3,15,4],[3,2,3,3],[31,3,31,4],[24,3,24,4],[25,3,26,4],[25,5,26,5],[25,6,26,6]]}
[null,"SOUTH AUSTRALIA INDEPENDENT SCHOOLS BLOCK GRANT AUTHORITY"]
[null,"Stage 3 FINANCIAL INFORMATION"]
[null,"School Name",{"$f":"'Stage 1.1'!SchoolName","v":0}]
[null,"AGEID",{"$f":"'Stage 1.1'!ageid","v":0}]
[null,"Stage 3.3 Debt Details"]
[]
[null,"Existing Loans as at as at year ended 2023"]
[null,"Please provide details of all individual loans (including overdrafts & bridging loans) taken by the school for both operating and capital purposes. Please include SAFA Loans already approved and any applications awaiting approval. Details to include any 'back to back' loans through system offices, central funding authorities or third party financial institutions. (Insert more rows if required)"]
[null,"Please do not list any loan for the proposed project that is the subject of this grant application."]
[null,"Month & Year loan received ","Name of lending authority","Purpose to which loan has been applied",null,"Initial Loan Amount","Remaining term of loan (years)","Rate of interest %","Annual Repayment",null,"Balance outstanding"]
[null,null,null,null,null,null,null,null,"Principal","Interest"]
[null,null,null,null,null,0,null,null,0,0,0]
[null,null,null,null,null,0,null,null,0,0,0]
[null,null,null,null,null,0,null,null,0,0,0]
[null,null,null,null,null,0,null,null,0,0,0]
[null,null,null,null,null,0,null,null,0,0,0]
[null,null,null,null,null,0,null,null,0,0,0]
[null,null,null,null,null,0,null,null,0,0,0]
[null,null,null,null,null,0,null,null,0,0,0]
[null,null,null,null,null,0,null,null,0,0,0]
[null,null,null,null,null,0,null,null,0,0,0]
[null,null,null,null,null,null,null,null,"This Total must equal the 2023 TOTAL reported on Stage 3.2 *","CLICK HERE",{"$f":"SUM(K12:K21)","v":0}]
[null,null,null,null,null,null,null,null,"Proof - must be zero",null,{"$f":"K22+'Stage 3.2'!E25","v":0}]
[null,"Expected loans from 1 January 2024 onwards",null,null,null,null,null,null,null,null,{"$f":"IF(FK23=0,\"Move to next field\",\"This field must be Zero.  Please correct figures above\")","v":"Move to next field"}]
[null,"Please give details….."]
[null,"Month & Year loan received ","Name of lending authority","Purpose to which loan has been applied",null,"Initial Loan Amount",null,"Rate of interest","Annual Repayment"]
[null,null,null,null,null,null,null,null,"Principal","Interest"]
[null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,0,null,null,0,0]
[null,null,null,"Total Future Loans",null,{"$f":"SUM(F28:F37)","v":0},null,null,{"$f":"SUM(I28:I37)","v":0},{"$f":"SUM(J28:J37)","v":0}]
[null,"Any additional comments "]

{"sheet":"Stage 3.4","index":16,"n_rows":30,"n_cols":10,"rows_kept":30,"cut":false,"hidden":false,"merged":[[29,2,29,9],[22,2,22,7],[23,2,23,7],[27,2,27,7],[18,2,18,7],[19,2,19,7],[26,2,26,7],[0,1,0,10],[1,1,1,10],[4,1,4,10],[12,2,12,7],[15,2,15,7],[8,2,8,7],[2,3,2,8],[9,2,9,7],[10,2,10,7],[11,2,11,7],[7,2,7,3],[7,5,7,7],[3,3,3,4]]}
[null,"SOUTH AUSTRALIA INDEPENDENT SCHOOLS BLOCK GRANT AUTHORITY"]
[null,"Stage 3 FINANCIAL INFORMATION"]
[null,"School Name",null,{"$f":"'Stage 1.1'!SchoolName","v":0}]
[null,"AGEID",null,{"$f":"'Stage 1.1'!ageid","v":0}]
[null,"3.4  Other Balance Sheet Details"]
[]
[null,"Liquid Assets"]
[null,null,"Total of Bank Accounts",null,null,"As per Stage 2.9",null,null,{"$f":"'Stage 2.9'!E60","v":0}]
[null,null,"Cash Advances",null,null,null,null,null,0]
[null,null,"Term Deposits",null,null,null,null,null,0]
[null,null,"Shares, Debentures and similar assets",null,null,null,null,null,0]
[null,null,"Other liquid assets",null,null,null,null,null,0]
[null,null,"Building Fund(s) (possibly off Balance Sheet)",null,null,null,null,null,0]
[null,null,null,null,null,null,null,"Total",{"$f":"SUM(I8:I13)","v":0}]
[]
[null,null,"Of the total Liquid Assets, how much is held in a separate bank account(s) to cover staff leave entitlements?",null,null,null,null,null,0,{"$f":"I16/I14","v":{"$error":"#DIV/0!"}}]
[]
[null,"Debtors"]
[null,null,"Gross Fee Debtors (excluding Provision for Doubtful Debts)",null,null,null,null,null,0]
[null,null,"Non-Fee Debtors",null,null,null,null,null,0]
[]
[null,"Other Assets"]
[null,null,"Value of properties not directly used for educational purposes (eg staff housing, Principal's residence) *",null,null,null,null,null,0]
[null,null,"Endowment and Trust Funds (including any off-balance sheet items such as Foundations)",null,null,null,null,null,0]
[]
[null,"Liabilities"]
[null,null,"Tuition Fees in Advance",null,null,null,null,null,0]
[null,null,"Total Provisions for Staff Leave Entitlements",null,null,null,null,null,0]
[]
[null,null,"* Please provide a brief description and value of properties not directly used for educational purposes"]

{"sheet":"Stage 3.5","index":17,"n_rows":29,"n_cols":9,"rows_kept":29,"cut":false,"hidden":false,"merged":[[20,1,20,2],[12,1,12,2],[13,1,13,2],[0,1,0,10],[1,1,1,10],[4,1,4,10],[14,1,14,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[3,2,3,3],[15,1,15,2]]}
[null,"SOUTH AUSTRALIA INDEPENDENT SCHOOLS BLOCK GRANT AUTHORITY"]
[null,"Stage 3 FINANCIAL INFORMATION"]
[null,"School Name",{"$f":"'Stage 1.1'!SchoolName","v":0}]
[null,"AGEID",{"$f":"'Stage 1.1'!ageid","v":0}]
[null,"3.5 Enrolment and Summary Ratios"]
[]
[]
[null,null,"Update enrolments via Stage 2.2","CLICK HERE"]
[]
[null,"Enrolments",2022,2023,"2024 Budget","2025 Forecast","2026 Forecast","2027 Forecast","2028 Forecast"]
[null,"August Census",{"$f":"'Stage 2.2'!S11","v":0},{"$f":"'Stage 2.2'!S13","v":0},{"$f":"'Stage 2.2'!S15","v":0},{"$f":"'Stage 2.2'!S17","v":0},{"$f":"'Stage 2.2'!S19","v":0},{"$f":"'Stage 2.2'!S21","v":0},{"$f":"'Stage 2.2'!S23","v":0}]
[]
[null,"Summary Ratios\n(Calculated automatically)",null,2023,"2024 Budget","2025 Forecast","2026 Forecast","2027 Forecast","2028 Forecast"]
[null,"Remissions to Gross Fees",null,{"$f":"'Stage 2.9'!E12/'Stage 2.9'!E11*-1","v":{"$error":"#DIV/0!"}},{"$f":"'Stage 2.9'!F12/'Stage 2.9'!F11*-1","v":{"$error":"#DIV/0!"}},{"$f":"'Stage 2.9'!G12/'Stage 2.9'!G11*-1","v":{"$error":"#DIV/0!"}},{"$f":"'Stage 2.9'!H12/'Stage 2.9'!H11*-1","v":{"$error":"#DIV/0!"}},{"$f":"'Stage 2.9'!I12/'Stage 2.9'!I11*-1","v":{"$error":"#DIV/0!"}},{"$f":"'Stage 2.9'!J12/'Stage 2.9'!J11*-1","v":{"$error":"#DIV/0!"}}]
[null,"Government Recurrent Grants to Total Income",null,{"$f":"'Stage 2.9'!E14/'Stage 2.9'!E18","v":{"$error":"#DIV/0!"}},{"$f":"'Stage 2.9'!F14/'Stage 2.9'!F18","v":{"$error":"#DIV/0!"}},{"$f":"'Stage 2.9'!G14/'Stage 2.9'!G18","v":{"$error":"#DIV/0!"}},{"$f":"'Stage 2.9'!H14/'Stage 2.9'!H18","v":{"$error":"#DIV/0!"}},{"$f":"'Stage 2.9'!I14/'Stage 2.9'!I18","v":{"$error":"#DIV/0!"}},{"$f":"'Stage 2.9'!J14/'Stage 2.9'!J18","v":{"$error":"#DIV/0!"}}]
[null,"Total Recurrent Income per Student",null,{"$f":"'Stage 2.9'!E18/'Stage 3.5'!D11","v":{"$error":"#DIV/0!"}},{"$f":"'Stage 2.9'!F18/'Stage 3.5'!E11","v":{"$error":"#DIV/0!"}},{"$f":"'Stage 2.9'!G18/'Stage 3.5'!F11","v":{"$error":"#DIV/0!"}},{"$f":"'Stage 2.9'!H18/'Stage 3.5'!G11","v":{"$error":"#DIV/0!"}},{"$f":"'Stage 2.9'!I18/'Stage 3.5'!H11","v":{"$error":"#DIV/0!"}},{"$f":"'Stage 2.9'!J18/'Stage 3.5'!I11","v":{"$error":"#DIV/0!"}}]
[null,"Fee Debtors to Billed Fees",null,{"$f":"'Stage 3.4'!I19/('Stage 2.9'!E11+'Stage 2.9'!E12)","v":{"$error":"#DIV/0!"}}]
[null,"Debt per Student",null,{"$f":"('Stage 3.2'!E19+'Stage 3.2'!E25)/'Stage 3.5'!D11","v":{"$error":"#DIV/0!"}},{"$f":"('Stage 3.2'!F19+'Stage 3.2'!F25)/'Stage 3.5'!E11","v":{"$error":"#DIV/0!"}},{"$f":"('Stage 3.2'!G19+'Stage 3.2'!G25)/'Stage 3.5'!F11","v":{"$error":"#DIV/0!"}},{"$f":"('Stage 3.2'!H19+'Stage 3.2'!H25)/'Stage 3.5'!G11","v":{"$error":"#DIV/0!"}},{"$f":"('Stage 3.2'!I19+'Stage 3.2'!I25)/'Stage 3.5'!H11","v":{"$error":"#DIV/0!"}},{"$f":"('Stage 3.2'!J19+'Stage 3.2'!J25)/'Stage 3.5'!I11","v":{"$error":"#DIV/0!"}}]
[null,"Interest Cover",null,{"$f":"('Stage 2.9'!E32+'Stage 2.9'!E26)/'Stage 2.9'!E26","v":{"$error":"#DIV/0!"}},{"$f":"('Stage 2.9'!F32+'Stage 2.9'!F26)/'Stage 2.9'!F26","v":{"$error":"#DIV/0!"}},{"$f":"('Stage 2.9'!G32+'Stage 2.9'!G26)/'Stage 2.9'!G26","v":{"$error":"#DIV/0!"}},{"$f":"('Stage 2.9'!H32+'Stage 2.9'!H26)/'Stage 2.9'!H26","v":{"$error":"#DIV/0!"}},{"$f":"('Stage 2.9'!I32+'Stage 2.9'!I26)/'Stage 2.9'!I26","v":{"$error":"#DIV/0!"}},{"$f":"('Stage 2.9'!J32+'Stage 2.9'!J26)/'Stage 2.9'!J26","v":{"$error":"#DIV/0!"}}]
[null,"EBIDA",null,{"$f":"('Stage 2.9'!E32+'Stage 2.9'!E26+'Stage 2.9'!E29)/'Stage 2.9'!E18","v":{"$error":"#DIV/0!"}},{"$f":"('Stage 2.9'!F32+'Stage 2.9'!F26+'Stage 2.9'!F29)/'Stage 2.9'!F18","v":{"$error":"#DIV/0!"}},{"$f":"('Stage 2.9'!G32+'Stage 2.9'!G26+'Stage 2.9'!G29)/'Stage 2.9'!G18","v":{"$error":"#DIV/0!"}},{"$f":"('Stage 2.9'!H32+'Stage 2.9'!H26+'Stage 2.9'!H29)/'Stage 2.9'!H18","v":{"$error":"#DIV/0!"}},{"$f":"('Stage 2.9'!I32+'Stage 2.9'!I26+'Stage 2.9'!I29)/'Stage 2.9'!I18","v":{"$error":"#DIV/0!"}},{"$f":"('Stage 2.9'!J32+'Stage 2.9'!J26+'Stage 2.9'!J29)/'Stage 2.9'!J18","v":{"$error":"#DIV/0!"}}]
[null,"Reinvestment",null,{"$f":"('Stage 2.9'!E51-'Stage 2.9'!E50)/('Stage 2.9'!E32+'Stage 2.9'!E29+'Stage 2.9'!E27+'Stage 2.9'!E21)","v":{"$error":"#DIV/0!"}},{"$f":"('Stage 2.9'!F51-'Stage 2.9'!F50)/('Stage 2.9'!F32+'Stage 2.9'!F29+'Stage 2.9'!F27+'Stage 2.9'!F21)","v":{"$error":"#DIV/0!"}},{"$f":"('Stage 2.9'!G51-'Stage 2.9'!G50)/('Stage 2.9'!G32+'Stage 2.9'!G29+'Stage 2.9'!G27+'Stage 2.9'!G21)","v":{"$error":"#DIV/0!"}},{"$f":"('Stage 2.9'!H51-'Stage 2.9'!H50)/('Stage 2.9'!H32+'Stage 2.9'!H29+'Stage 2.9'!H27+'Stage 2.9'!H21)","v":{"$error":"#DIV/0!"}},{"$f":"('Stage 2.9'!I51-'Stage 2.9'!I50)/('Stage 2.9'!I32+'Stage 2.9'!I29+'Stage 2.9'!I27+'Stage 2.9'!I21)","v":{"$error":"#DIV/0!"}},{"$f":"('Stage 2.9'!J51-'Stage 2.9'!J50)/('Stage 2.9'!J32+'Stage 2.9'!J29+'Stage 2.9'!J27+'Stage 2.9'!J21)","v":{"$error":"#DIV/0!"}}]
[]
[null,"Other Items"]
[null,"Loan Details",null,{"$f":"'Stage 3.2'!E19+'Stage 3.2'!E25","v":0},{"$f":"'Stage 3.2'!F19+'Stage 3.2'!F25","v":0},{"$f":"'Stage 3.2'!G19+'Stage 3.2'!G25","v":0},{"$f":"'Stage 3.2'!H19+'Stage 3.2'!H25","v":0},{"$f":"'Stage 3.2'!I19+'Stage 3.2'!I25","v":0},{"$f":"'Stage 3.2'!J19+'Stage 3.2'!J25","v":0}]
[null,"Cash at Bank ",null,{"$f":"'Stage 2.9'!E60","v":0},{"$f":"'Stage 2.9'!F60","v":0},{"$f":"'Stage 2.9'!G60","v":0},{"$f":"'Stage 2.9'!H60","v":0},{"$f":"'Stage 2.9'!I60","v":0},{"$f":"'Stage 2.9'!J60","v":0}]
[null,"Project Cost less Contingency",null,null,null,{"$f":"'Stage 2.6'!G17","v":0}]
[null,"Contingency",null,null,null,{"$f":"'Stage 2.6'!G14+'Stage 2.6'!G15+'Stage 2.6'!G16","v":0}]
[null,"Project Cost Inc Contingency",null,null,null,{"$f":"SUM(F26:F27)","v":0}]
[null,"Enrolment Change",null,{"$f":"(D11/C11)-1","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]

{"sheet":"Stage 4.1","index":18,"n_rows":52,"n_cols":10,"rows_kept":52,"cut":false,"hidden":false,"merged":[[24,2,24,6],[28,2,28,6],[12,3,14,10],[8,1,8,9],[22,2,22,5],[23,2,23,5],[19,2,19,5],[20,2,20,5],[32,2,32,5],[44,2,44,10],[33,11,33,12],[49,4,49,5],[50,4,50,5],[51,4,51,5],[48,4,48,5],[47,1,47,10],[33,2,33,5],[34,2,34,5],[35,2,35,5],[36,2,36,5],[37,2,37,5],[42,2,42,10],[45,2,45,10],[0,1,0,10],[1,1,1,10],[4,1,4,10],[18,2,18,5],[21,2,21,5],[3,2,3,3]]}
[null,"SOUTH AUSTRALIA INDEPENDENT SCHOOLS BLOCK GRANT AUTHORITY"]
[null,"Stage 4 FINAL DOCUMENTATION"]
[null,"School Name",{"$f":"'Stage 1.1'!SchoolName","v":0}]
[null,"AGEID",{"$f":"'Stage 1.1'!ageid","v":0}]
[null,"4.1 Final Project Description and Costs"]
[]
[]
[null,"UPDATE OF PROPOSED PROJECT SCHEDULE"]
[null,"Please return to Stage 2.5 and update the details of the Proposed Project to reflect the final project and costings for approval.  This is to be completed once detailed planning and designs in conjunction with your Architect, and detailed costings have been prepared.  "]
[]
[null,"Final Project Funding"]
[]
[null,"Description",null,{"$f":"_xlfn.UNIQUE('Stage 1.2'!$B$10&\" \"&'Stage 1.2'!$C$10&\" \"&'Stage 1.2'!$B$11&\" \"&'Stage 1.2'!$C$11&\" \"&'Stage 1.2'!$B$12&\" \"&'Stage 1.2'!$C$12&\" \"&'Stage 1.2'!$B$13&\" \"&'Stage 1.2'!$C$13)","v":"       "}]
[null,"UPDATE HERE"]
[]
[]
[null,"Update Project Cost",null,"CLICK HERE",null,null,null,"QS/School Cost",null,"Standard Cost"]
[]
[null,null,"TOTAL COST OF PROJECT (Inc Contingencies)",null,null,null,null,{"$f":"'Stage 2.5 QS'!J12","v":0}]
[null,null,"Add Items not shown on QS",null,null,null,null,{"$f":"'Stage 2.5 QS'!J34","v":0}]
[null,null,"Less Items removed from QS",null,null,null,null,{"$f":"'Stage 2.5 QS'!J48","v":0}]
[null,null,"Less Construction Contingencies",null,null,null,null,{"$f":"'Stage 2.5 QS'!I14","v":0}]
[null,null,"Less Design Contingencies",null,null,null,null,{"$f":"'Stage 2.5 QS'!I15","v":0}]
[null,null,"Less Country Loading",null,null,null,null,{"$f":"'Stage 2.5 QS'!I16","v":0}]
[null,null,"TOTAL RECOMMENDED PROJECT COST (Exc Contingencies)",null,null,null,null,{"$f":"H19+H20-H21-H22-H23-H24","v":0},null,{"$f":"'Stage 2.5 Std'!J111","v":0}]
[]
[null,"Please enter the Indicative Grant as per June offer and components of school contribution below:"]
[]
[null,null,"Less INDICATIVE GRANT AS PER OFFER",null,null,null,null,0,{"$f":"H29/H25","v":{"$error":"#DIV/0!"}}]
[null,null,"TOTAL SCHOOL CONTRIBUTION",null,null,null,null,{"$f":"H25-H29","v":0}]
[]
[null,null,"COMPONENTS OF SCHOOL CONTRIBUTION"]
[null,null,"School Building Fund/Levy on Fees"]
[null,null,"Donations/Fundraising (e.g. Parent Bodies)"]
[null,null,"Other cash sources (please specify below)"]
[null,null,"Contributed services (approximate value)"]
[null,null,"Anticipated loans including those from System Authorities"]
[null,null,"TOTAL FUNDS TO BE CONTRIBUTED",null,null,null,null,{"$f":"SUM(H33:H37)","v":0},{"$f":"H38/H25","v":{"$error":"#DIV/0!"}}]
[]
[null,null,"School Contribution allocation check - this figure MUST BE ZERO",null,null,null,null,{"$f":"H30-H38","v":0},{"$f":"IF(H40=0,\"Move to next field\",\"This field must be Zero.  Please correct figures above\")","v":"Move to next field"}]
[]
[null,null,"Details of other Cash and/or Loan sources including amount and term. "]
[]
[]
[null,null,"If your final Total Project Cost varies by 10% or more from the Total Project Cost in your Stage 3 Financial Application, you must explain the variation below."]
[]
[]
[null,"Please provide details below of the expected timing of the project.  These dates will be submitted to the Commonwealth if the project is recommended. "]
[null,null,null,null,"Month & Year"]
[null,"Expected commence date for build"]
[null,"Expected completion date"]
[null,"New facilities to be used in "]

{"sheet":"Stage 4.2","index":19,"n_rows":37,"n_cols":34,"rows_kept":37,"cut":false,"hidden":false,"merged":[[30,1,30,9],[31,1,31,4],[33,1,33,4],[31,6,31,9],[33,6,33,8],[18,1,18,9],[18,30,18,39],[28,1,28,9],[28,30,28,39],[12,1,12,9],[12,30,12,39],[0,1,0,9],[1,1,1,9],[4,1,4,9],[0,30,0,39],[1,30,1,39],[4,30,4,39],[2,2,2,9],[3,2,3,3]]}
[null,"SOUTH AUSTRALIA INDEPENDENT SCHOOLS BLOCK GRANT AUTHORITY",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SOUTH AUSTRALIA INDEPENDENT SCHOOLS BLOCK GRANT AUTHORITY"]
[null,"Stage 4 FINAL DOCUMENTATION ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stage 4 FINAL DOCUMENTATION"]
[null,"School Name",{"$f":"'Stage 1.1'!SchoolName","v":0}]
[null,"AGEID",{"$f":"'Stage 1.1'!ageid","v":0}]
[null,"4.2.1 Financial Information Update",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4.2 Financial Update"]
[]
[null,"Please follow the links below to update the financial information previously provided. "]
[]
[null,"CAPEX Budget",null,"CLICK HERE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Please update your CAPEX Budget ",null,null,"CLICK HERE"]
[null,"Financial Forecast",null,"CLICK HERE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Please update your FINANCIAL FORECAST",null,null,"CLICK HERE"]
[null,"4.2.2 Design Compliance",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4.2 Financial Update"]
[]
[null,"The architect has confirmed in writing that the Project Design complies with the applicable provisions of:"]
[null,"1. The Disability Discrimination Act 1992 as currently reflected in the Building Code of Australia, and"]
[null,"2. The Work Health and Safety Act 2012 and the work Health and Safety Regulations 2012."]
[]
[null,"4.2.3 Final documentation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4.2 Financial Update"]
[]
[null,"Please refer to this checklist to ensure all documentation is ready to be submitted via the website (refer INDEX PAGE)"]
[null,"F","Checked and completed all information required in Stage 4.1 and 4.2.1 above?"]
[null,"F","Scanned copy of the Quantity Surveyors Report or Quotations for the project (PDF format)"]
[null,"F","Scanned a copy of the Final Plans for the proposed project (PDF format)?"]
[null,"F","Audited Financial Statements (if not already provided at Stage 3)"]
[null,"F","PDF copy of the Design Compliance report as per 4.2.2 above."]
[null,"F","This Excel workbook with the Declaration below signed. "]
[]
[null,"4.2.4 Declaration",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4.2 Financial Update"]
[]
[null,"I understand that this Application and, should the Proposed Project and a Grant be approved by the Minister of Education, Skills and Employment, any subsequent use of an Approved Grant are subject to the terms and conditions in the SA Independent Schools Block Grant Authority’s Participation Agreement previously signed by this school, or its System office. \n\nI have taken all reasonable steps to be confident the Proposed Project will receive the required Local Government approvals. \n\nThe information provided in Stage 4.1 & 4.2, to the best of my knowledge and ability, true and correct. "]
[]
[null,"Name of person signing as Approved Authority",null,null,null,null,"*Signature"]
[]
[null,"Position of person signing as Approved Authority",null,null,null,null,"Date "]
[]
[null,"*Electronic signature preferred.  Please print this page, PDF and sign if preferred. "]

{"sheet":"Definitions","index":20,"n_rows":69,"n_cols":26,"rows_kept":69,"cut":false,"hidden":true,"merged":[[5,2,8,2],[5,3,8,3],[5,0,8,1],[5,5,8,5]]}
[null,null,"Area per student standards   Primary","m2",null,"m2"]
[null,null,"Secondary","m2",null,"m2"]
[null,null,"SEE BELOW FOR FULL DESCRIPTIONS"]
[null,null,"Area Cost Standards for January 2024 to be updated in December"]
[null,null,null,null,null,"70% of Standard Costs"]
["FUNCTIONAL AREA ID",null,"FUNCTIONAL AREA","CURRENT  COST m2 $",null,"REFURB  COST m2 $"]
[]
[]
[]
[1,"-NONE-","NONE",0,null,0,1,"-NONE-",null,null,1,"-NONE-",null,null,null,1,"-NONE-",null,null,1,"-NONE-",null,null,1,"-NONE-"]
[2,"ADMIN","ADMINISTRATION / STAFF",2900,"ADMIN",{"$f":"D11*70%","v":2029.9999999999998},2,"Primary","Primary",null,2,"Construction","Construction",null,null,2,"Permanent","Permanent",null,2,"Yes","Yes",null,2,"Poor","Poor"]
[3,"ART-PRI","ART PRIMARY",2845,"ART-PRI",{"$f":"D12*70%","v":1991.4999999999998},3,"Secondary","Secondary",null,3,"Refurbishment","Refurbishment",null,null,3,"Temporary","Temporary",null,3,"No","No",null,3,"Good","Good"]
[4,"ART-SEC","ART / DESIGN / GRAPHICS / TEXTILES",2845,"ART-SEC",1991.4999999999998,4,"Combined","Combined",null,null,null,null,null,null,4,"Future","Future",null,4,"BER Not Inc",null,null,4,"Excellent","Excellent"]
[5,"ART-IND","INDUSTRIAL ARTS / WOOD / METAIL / PLASTICS",2845,"ART-IND",1991.4999999999998,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"Planned","Planned"]
[6,"COLA","COLA (NOT ENCLOSED)",1125,"COLA",787.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"Under Const","Under Const"]
[7,"GLA","GLA FOR PRI & SEC",2730,"GLA",1910.9999999999998]
[8,"GLA-LEARN","GLA FOR LEARNING COMMON FOR PRI & SEC",2675,"GLA-LEARN",1872.4999999999998]
[9,"GLA-MULTI","GLA FOR MULTIPUPOSE LEARNING AREAS FOR PRI & SEC",3205,"GLA-MULTI",2243.5]
[10,"COMP IT","COMPUTER LAB / BUSINESS STUDIES / IT ROOM",2930,"COMP IT",2051]
[11,"HOME EC","HOME ECONOMICS",3075,"HOME EC",2152.5]
[12,"LIBRARY","LIBRARY / RESOURCE CENTRE PRI & SEC",2675,"LIBRARY",1872.4999999999998]
[13,"MUSIC-MEDIA","MUSIC / DRAMA / MEDIA / DANCE",3205,"MUSIC-MEDIA",2243.5]
[14,"PHYS ED-PRI","MULTIPUPOSE HALL PRIMARY",2320,"PHYS ED-PRI",1624]
[15,"PHYS ED-SEC","MULTIPUPOSE HALL SECONDARY",2675,"PHYS ED-SEC",1872.4999999999998]
[16,"PLANT","PLANTROOMS",2035,"PLANT",1424.5]
[17,"SCIENCE","SCIENCE LABS / ASSOC AREA",3205,"SCIENCE",2243.5]
[18,"STUD-AMEN","STUDENT AMENITIES",4580,"STUD-AMEN",3206]
[19,"STAFF-AMEN","STAFF AMENITIES",4405,"STAFF-AMEN",3083.5]
[20,"TRAV-ENC","STAIRWELLS / CORRIDORS",3190,"TRAV-ENC",2233]
[21,"TRAV-UNENC","VERANDAH / BALCONY / OURTDOOR LEARNING SPACES",875,"TRAV-UNENC",612.5]
[22,"TRAV-COVER","COVERED WALKWAYS (NOT ENCLOSED)",1060,"TRAV-COVER",742]
[23,"CANTEEN","CANTEEN TUCKSHOP",2610,"CANTEEN",1826.9999999999998]
[24,"OUT-LEARN","OUTDOOR LEARNING AREA",1515,"OUT-LEARN",1060.5]
[25,"OTHER",null,0,"OTHER",0]
[]
[null,"Select from list","Select from list"]
["Construction",2015,"Architects/Primary Consultants Fees"]
["Refurbishment",2016,"Demolition"]
["Conversion",2017,"Electrical Services"]
["Extension",2018,"Equipment (not built in)"]
["Purchase",2019,"Fire Services"]
["Relocation",2020,"Hydraulic Services"]
[null,2021,"Loose Furniture "]
["Select from list",2022,"Market Allowance"]
["Owned",2023,"Mechanical Services"]
["Leased",2024,"Preliminaries Overheads & Margin"]
[null,2025,"Professional, Council/Certification & CITB Fees"]
["Select from list",2026,"Relocation works"]
["Yes",2027,"Quantity Surveyor"]
["No",2028,"Site acquisition/property purchase "]
["Unsure",2029,"Site development costs (outside perimeter of the building)"]
[null,2030,"Site preparation"]
["Select from list"]
["Yes "]
["No",null,"Yes"]
["Other",null,"No"]
[]
["Select from list"]
["Yes "]
["No "]
["In Progress"]
[]
[]
["Not Checked"]
["Checked"]
[]
["Select one"]
["Audited"]
["Draft"]