{"text_format":"1","workbook":"xlsx","n_sheets":22,"sheets":["Green Star SA","Introduction","How to Use","Disclaimer","Change Log","R1 Pre-Submission Checklist","R2 Pre-Submission Checklist","Applicant Declaration","Building Input","Management","IEQ","Energy","Transport","Water","Materials","Land Use & Ecology","Emissions","Innovation","Credit Summary","Graphical Summary","Calculation","Rainfall data"],"not_rendered":{"charts":3,"images":6,"macros":1,"external_links":2,"defined_names":297,"comments":9,"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":"Green Star SA","index":0,"n_rows":17,"n_cols":2,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Green Star SA - Existing Building Performance PILOT validates the environmental performance of existing buildings in operation.  "]
[]
[null,"You are invited to use Green Star SA - Existing Building Performance PILOT to predict a Green Star SA rating.  The Green Building Council of South Africa (GBCSA) does not endorse any self-assessed rating and you are prohibited from presenting self-assessment results in the public domain.  This service provides for independent third party review of points claimed to ensure all points can be demonstrated to be achieved by the provision of the necessary documentary evidence.  The use of Green Star SA -  Performance PILOT without formal certification by the GBCSA does not entitle the user or any other party to promote a Green Star SA rating publicly.  "]
[]
[null,"Use the tabs at the bottom of the pages to navigate."]
[]
[null,"© Green Building Council of South Africa "]
[null,"Last Modified: 27 June 2014"]
[null,"                                                                                                   Sponsored by:"]

{"sheet":"Introduction","index":1,"n_rows":76,"n_cols":2,"rows_kept":76,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Green Star SA - Existing Building Performance PILOT"]
[]
[]
[]
[null,"Introduction to Green Star SA - Existing Building Performance PILOT"]
[]
[]
[]
[null,"What is Green Star SA?"]
[]
[null,"What does Green Star SA - Existing Building Performance PILOT do?"]
[]
[null,"Who can use Green Star SA - Existing Building Performance PILOT?"]
[]
[null,"What do Green Star SA - Existing Building Performance ratings mean?"]
[]
[null,"Acknowledgements"]
[]
[]
[]
[]
[]
[null,"What is Green Star SA?"]
[null,"The Green Star SA environmental rating system for buildings was developed by the Green Building Council of South Africa (GBCSA).  Green Star SA is a comprehensive rating system for evaluating the environmental design and performance of South African buildings based on a number of criteria, including energy and water efficiency, indoor environment quality and resource conservation. "]
[]
[null,"The Green Star SA environmental rating system is based upon the Australian Green Star system and has been customised for the South African environment by the GBCSA, under licence from the Green Building Council of Australia."]
[null,"Green Star SA has built on existing systems and tools in overseas markets, primarily the Australian Green Star system, but also including the British Building Research Establishment Environmental Assessment Method (BREEAM) system and the North American Leadership in Energy and Environmental Design (LEED) system.  Environmental measurement criteria relevant to the South African marketplace and environmental context have been created."]
[]
[null,"The Green Star rating system was created to:"]
[]
[null,"•  establish a common language and standard of measurement for green buildings; "]
[null,"•  promote integrated, whole-building design; "]
[null,"•  raise awareness of green building benefits;"]
[null,"•  recognise and reward environmental leadership; and "]
[null,"•  reduce the environmental impact of development. "]
[]
[]
[]
[null,"What does Green Star SA - Existing Building Performance PILOT do?"]
[]
[null,"Green Star SA - Existing Building Performance PILOT validates the environmental performance of existing buildings in operation.  "]
[]
[]
[]
[null,"Who can use Green Star SA - Existing Building Performance PILOT?"]
[null,"The GBCSA encourages all interested parties to use Green Star SA - Existing Building Performance PILOT to validate the environmental performance of existing buildings. The use of Green Star SA - Existing Building Performance PILOT is encouraged on all such projects to assess and improve their environmental performance.  "]
[]
[null,"The use of Green Star SA - Existing Building Performance PILOT without formal certification by the GBCSA does not entitle the user or any other party to promote the Green Star rating achieved.  No fee is payable to the GBCSA for such use, however formal recognition of the Green Star SA rating - and the right to promote the same - requires undertaking the formal certification process offered by the GBCSA."]
[]
[]
[]
[null,"What do Green Star SA Existing Building Performance ratings mean?"]
[null,"Green Star SA rating tools use six stars to measure performance. Star ratings are represented as follows under the rating tool:"]
[null,"•  1-3 Star Green Star Certified Rating acknowledges \"Commitment to Performance\";  "]
[null,"•  4 Star Green Star Certified Rating recognises and rewards \"Best Practice\";  "]
[null,"•  5 Star Green Star Certified Rating recognises and rewards \"South African Excellence\"; and "]
[null,"•  6 Star Green Star Certified Rating recognises and rewards \"World Leadership\".  "]
[]
[]
[null,"Again, the use of Green Star SA - Existing Building Performance PILOT without formal certification by the GBCSA does not entitle the user or any other party to promote a Green Star SA rating publicly."]
[]
[]
[]
[]
[null,"Acknowledgements"]
[null,"The Green Building Council would like to acknowledge all parties that worked on and supported the development of the Green Star SA – Existing Building Performance PILOT rating tool. "]
[]
[null,"The GBCSA thanks all those individuals and organisations who provided feedback and expertise to the technical development of the Green Star SA – Existing Building Performance PILOT rating tool.  In particular, the GBCSA would like to thank all Technical Steering Committee and Technical Working Group members, as well as technical consultants Royal HaskoningDHV and Ecocentric.  The GBCSA also acknowledges the support of the Green Building Council of Australia."]
[]
[null,"The Green Star SA - Existing Building Performance PILOT tool sponsor Nedbank Corporate, provided much-needed financial support to develop the rating tool.  "]
[]
[null,"Green Star SA – Existing Building Performance Pilot is based on national and international guidelines, including primarily the Australian Green Star system, as well as the US LEED Green Building Rating System and UK's BREEAM Environmental Assessment Method."]
[]
[null,"Green Star SA - Existing Building Performance PILOT Tool Sponsor:"]

{"sheet":"How to Use","index":2,"n_rows":21,"n_cols":2,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Green Star SA - Existing Building Performance PILOT"]
[]
[]
[]
[null,"How to use this tool"]
[]
[]
["1.","Complete the worksheets by reviewing each credit in each category and entering the number of points you predict the building will achieve in the 'No. of Points Achieved' column."]
[]
["2.","Enter any points that may be achieved but need to be confirmed in the 'Points to be Confirmed' column."]
[]
["3.","Enter any comments required in the 'Comments' column."]
[]
["4.","The predicted rating is shown in the Summary worksheet.  More detail on point scores (both achieved and those to be confirmed) are shown in the Credit Summary and Graphical Summary worksheets at the end of the tool.  "]
[]
[null,"NOTE: The Green Star SA - Existing Building Performance PILOT should be used together with the Green Star SA - Existing Building Performance PILOT Technical Manual and the definitions contained therein. "]
[null,"Limitations"]
[null,"The GBCSA does not endorse any self-assessed rating achieved by the use of Green Star - SA Existing Building Performance PILOT.  This service provides for independent third party review of points claimed to ensure all points can be demonstrated to be achieved by the provision of the necessary documentary evidence.  The use of Green Star SA - Existing Building Performance PILOT without formal certification does not entitle the user or any other party to promote the Green Star SA rating achieved."]
[null,"The application of Green Star SA - Existing Building Performance PILOT to all existing buildings is encouraged to assess and improve their environmental performance.  No fee is payable to the GBCSA for such use, however formal recognition of the Green Star SA rating - and the right to promote the same - requires undertaking the formal certification process offered by the GBCSA."]

{"sheet":"Disclaimer","index":3,"n_rows":30,"n_cols":2,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Green Star SA - Existing Building Performance PILOT"]
[]
[]
[]
[null,"Disclaimer"]
[]
[]
[null,"Authorisation, Acknowledgement and Disclaimer"]
[null,"The Green Star SA environmental rating system for buildings (“Green Star SA”) and the Green Star SA – Existing Building Performance rating tool (“Green Star SA – Existing Building Performance”) have been developed by the Green Building Council of South Africa (“GBCSA”).  Green Star SA – Existing Building Performance PILOT is intended for use by building owners, managers and other interested parties to validate the environmental performance of buildings in operation.  As with all Green Star SA rating tools, Green Star SA - Existing Building Performance PILOT may be subject to further development in the future."]
[]
[null,"Green Star SA and Green Star SA - Existing Building Performance PILOT have been developed with the assistance and participation of representatives from many organisations. The views and opinions expressed have been determined upon by the GBCSA and its Committees."]
[]
[null,"The GBCSA authorises you to view and use Green Star SA - Existing Building Performance PILOT for information purposes only.  In exchange for this authorisation, you agree that the GBCSA retains all copyright and other proprietary rights contained in and in relation to Green Star SA - Existing Building Performance PILOT and agree not to sell, let, distribute, modify, or use for another purpose the tool or to reproduce, display or distribute the tool in any way for any public or commercial purpose, including display on a website or in a networked environment. Unauthorised use of Green Star SA and/or Green Star SA - Existing Building Performance PILOT will violate copyright and other laws, and is prohibited.  All text, graphics, layout and other elements of content contained in Green Star SA and its rating tools are owned by the GBCSA and are protected by copyright, trade mark and other laws."]
[]
[null,"The GBCSA does not accept responsibility, including for negligence, for any inaccuracy, error or omission within Green Star SA and/or its rating tools and makes no warranty, expressed or implied, including the warranties of merchantability and fitness for a particular purpose, nor assumes any legal liability or responsibility to you or any third parties for the accuracy, completeness, use of or reliance on any information contained in Green Star SA and/or Green Star SA – Existing Building Performance PILOT, or for any injuries, losses or damages (including, without limitation, equitable relief and economic loss) arising out of such use or reliance."]
[]
[]
[null,"Green Star SA and Green Star SA - Existing Building Performance PILOT are not substitutes for professional advice, nor do they purport to be a professional service.  You should seek your own professional and other appropriate advice on the matters addressed by them."]
[]
[null,"As a condition of use, you undertake not to institute legal proceedings in whatever form against the trade mark and copyright proprietor, and agree to waive and release the GBCSA, its officers, agents, employees and its members from any and all claims, demands and causes of action for any injury, loss, destruction or damage (including, without limitation, equitable relief and economic loss) that you may now or hereafter have a right to assert against such parties as a result of your use of, or reliance on, Green Star SA and/or Green Star SA – Existing Building Performance PILOT."]
[]
[null,"The GBCSA does not endorse or otherwise acknowledge the Green Star SA rating achieved by the use of Green Star SA – Existing Building Performance PILOT.  The service provides for independent third party review of points claimed to ensure all credits can be demonstrated to be achieved by the provision of the necessary documentary evidence.  The use of Green Star SA - Existing Building Performance PILOT without formal certification by the GBCSA does not entitle the user or any other party to promote the achieved Green Star SA rating or make use of the Green Star trade marks in whatever manner or form. "]
[]
[null,"The application of Green Star SA - Existing Building Performance PILOT to all existing buildings is encouraged to assess and improve their environmental performance.  No fee is payable to the GBCSA for such use, however formal recognition of the Green Star SA rating - and the right to promote the same - requires undertaking the formal certification process offered by the GBCSA."]
[]
[null,"You are only authorised to proceed to use Green Star SA and Green Star SA – Existing Building Performance PILOT on this basis."]
[]
[null,"© 2008 Green Building Council of South Africa.  All rights reserved."]

{"sheet":"Change Log","index":4,"n_rows":28,"n_cols":3,"rows_kept":28,"cut":false,"hidden":false,"merged":[[17,1,17,2]]}
[]
[]
[null,"Green Star SA - Existing Building Performance PILOT"]
[]
[]
[]
[null,"Change Log"]
[]
[]
[null,"Green Star SA Existing Building Performance PILOT Tool Release Date:"]
[]
[null,"2013-10-16"]
[]
[]
[]
[null,"Changes & Amendments"]
[]
[null,"The GBCSA  reserves the right to correct errors and omissions in the Green Star SA - Existing Building Performance PILOT rating tool as necessary. The changes noted in this change log also do not represent changes to points awarded for credits, or changes to credit criteria. The changes noted below are those of minor nature related to the operation of the rating tool and associated calculators.  "]
[]
[null,"Reissue Date","Changes"]
[null,"2013-10-24","Minor formatting changes made"]
[null,"2013-10-28","Errors corrected in Credit Summary and Graphical Summary"]
[null,"2014-01-16","Corrected the link to the Category scores"]
[null,"2014-03-11","Man-1 - Design ratings incorporated. Criteria for performance as per design removed. (2 points to 1 point)\nMan-5 - Minor criteria adjustments\nIEQ-5 - Minor criteria adjustments\nIEQ-7 - Exhaust Riser criteria removed (3 points to 2 points)\nTRA-1 - Minor criteria adjustments\nMAT-2 - Points increased (4 to 6)"]
[null,"2014-04-07","Man-4 -  Erratum - Points for Policy & Programme updated from 1 to 1.5."]
[null,"2014-05-19","Mat-1 & Mat-2 credit adjusted to allow for 'na''s to be claimed\nMan-1 & IEQ-7 - minor errors corrected in points available text"]
[null,"2014-06-27","All credits adjusted to allow for ''na's\" to be claimed\nCalculations in 'Credit summary' corrected\nInstered credit names in 'Credit summary' tab"]
[null,"2015-02-11","Mat-1 & Mat-2 credit adjusted to allow for 'na''s to be claimed in the points to be confirmed \nECO-1  credit adjusted to allow for 'na''s to be claimed in the points to be confirmed \nTRA-1 Improved Transportation Modes Performance, credit adjusted to allow for 'na''s to be claimed in the points to be confirmed\nCalculations 'Credit Summary' adding sub totals points achieved and point to be confirmed\nMAN-3 points allocated corrected "]

{"sheet":"R1 Pre-Submission Checklist","index":5,"n_rows":55,"n_cols":4,"rows_kept":55,"cut":false,"hidden":true,"merged":[[61,1,61,4],[7,1,7,4],[50,1,50,4],[52,1,52,4],[54,1,54,4]]}
[]
[]
[null,"Green Star SA - Office v1"]
[]
[]
[]
[null,"Round 1 Pre-Submission Checklist"]
[null,"Please complete the white cells only below, and submit the completed submission only if all aspects have been addressed."]
[]
[]
[null,null,"Administration"]
[null,1,"Signed Certification Agreement has been received by the GBCSA","Please Confirm"]
[null,2,"The correct and full assessment fee has been received by the GBCSA","Please Confirm"]
[null,3,"No Credit Interpretation Requests or Technical Clarifications are outstanding","Please Confirm"]
[null,4,"The latest version of the GSSA rating tool has been used","Please Confirm"]
[]
[null,null,"Eligibility"]
[null,null,"In the projects opinion, the project meets the following Eligibility Criteria:"]
[null,5,"Eligibility Criteria 1: Spatial differentiation","Please Confirm"]
[null,6,"Eligibility Criteria 2: Space use","Please Confirm"]
[null,7,"Eligibility Criteria 3: Conditional requirements (project meets Ene-0 and Eco-0 conditional requirements)","Please Confirm"]
[null,8,"Eligibility Criteria 4: Timing of Certification (project must be certified within 24 months of practical completion)","Please Confirm"]
[null," "]
[null," ","Submission content and presentation"]
[null,9,"All files are in PDF format only and unlocked, in one layer.","Please Confirm"]
[null,10,"Within each category folder, one merged PDF file is provided for each credit targetted","Please Confirm"]
[null,11,"Bookmarks have been added for each documentation requirement in the individual credit pdf files","Please Confirm"]
[null,12,"Each page of all documents must be marked by use of a label indicating what Documentation Requirement it is supporting ","Please Confirm"]
[null,13,"Relevant sections of the documentation and drawings have been highlighted to draw the assessors attention to relevant information","Please Confirm"]
[null,14,"A general section is included to provide an overview of the project. (It should include architectural drawings, elevations, site plans and complete area summary table for GFA and UA)","Please Confirm"]
[null,15,"A completed Green Star SA Excel spreadsheet (for the relevant tool) is included","Please Confirm"]
[null,16,"Credit cover sheets (based on the template provided) are included for each credit","Please Confirm"]
[null,17,"All reports, letters and drawings referring to the project are on a letterhead and signed where stipulated or where they confirm a commitment","Please Confirm"]
[null,18,"Drawings are not in draft form and where applicable carry the \"Tender\", \"For Construction\" or “As Built’ stamp/status","Please Confirm"]
[null,19,"Specifications are not in draft format","Please Confirm"]
[null,20,"All relevant information is included within the credit it supports. (Appendices for each credit can be included, but they must be within the credit itself, clearly referenced within the documentation and have relevant sections highlighted.)","Please Confirm"]
[null,21,"All relevant communication with the GBCSA is included (including CIR Rulings and Technical Clarifications relevant to this project) ","Please Confirm"]
[null,22,"All drawings are still legible after scaling (especially small stamps, monitors/sensors etc.)","Please Confirm"]
[null,23,"All inputs are consistent throughout the submission. (E.g. the fresh air rates claimed in IEQ-1 Ventilation Rates are consistent with Energy modelling in Ene-1. Assessors will not award points and will require conformation where there are inconsistencies.)","Please Confirm"]
[null,24,"Submission for each credit includes all documentation stipulated in the Technical Manual and the TC/CIR portal on the GBCSA website","Please Confirm"]
[null,25,"All credits claiming “na” have the required supporting documentation","Please Confirm"]
[null,26,"CD/DVD cover and CD/DVD, communicates the official project name, project reference number, project address, Green Star SA Tool, contact person’s details, submission round and date. ","Please Confirm"]
[null,27,"Folders are included within the digital submission (CD’s) and correspond to the Green Star SA categories and are in the correct order, following the categories and credits. ","Please Confirm"]
[null,28,"All documents are orientated in the same direction","Please Confirm"]
[null,29,"The AP declaration has been signed and submitted with the submission","Please Confirm"]
[]
[null,null,"Submission delivery"]
[null,30,"Four digital copies (four CDs) have been prepared for the submission","Please Confirm"]
[]
[]
[null,"Name: ___________________________________      Company: ___________________________________    "]
[]
[null,"Signature of Applicant: ___________________________________                        "]
[]
[null,"Note: If any of the above have not been complied with, the GBCSA reserves the right to return submission documentation to the project for re-submission and compliance with the above."]

{"sheet":"R2 Pre-Submission Checklist","index":6,"n_rows":49,"n_cols":4,"rows_kept":49,"cut":false,"hidden":true,"merged":[[48,1,48,4],[7,1,7,4],[44,1,44,4],[46,1,46,4]]}
[]
[]
[null,"Green Star SA - Office v1"]
[]
[]
[]
[null,"Round 2 Pre-Submission Checklist"]
[null,"Please complete the white cells only below, and submit the completed submission only if all aspects have been addressed."]
[]
[]
[null,null,"Administration"]
[null,1,"No Credit Interpretation Requests or Technical Clarifications are outstanding","Please Confirm"]
[]
[null,null,"Eligibility"]
[null,2,"Eligibility has been established and all conditional requirements have been met OR any eligibility issues raised in Round 1 have been addressed","Please Confirm"]
[]
[null,null,"Submission content and presentation"]
[null,3,"All files are in PDF format only and unlocked, in one layer.","Please Confirm"]
[null,4,"Within each category folder, one merged PDF file is provided for each credit targetted","Please Confirm"]
[null,5,"Bookmarks have been added for each documentation requirement in the individual credit pdf files","Please Confirm"]
[null,6,"Each page of all documents must be marked by use of a label indicating what Documentation Requirement it is supporting ","Please Confirm"]
[null,7,"Relevant sections of the documentation and drawings have been highlighted to draw the assessors attention to relevant information","Please Confirm"]
[null,8,"A general section is included to provide an overview of the project. (It should include architectural drawings, elevations, site plans, complete area summary table for GFA and UA, and 2 x images/renderings of the project)","Please Confirm"]
[null,9,"A completed Green Star SA Excel spreadsheet (for the relevant tool) is included","Please Confirm"]
[null,10,"Credit cover sheets (based on the template provided) are included for each credit","Please Confirm"]
[null,11,"All reports, letters and drawings referring to the project are on a letterhead and signed where stipulated or where they confirm a commitment","Please Confirm"]
[null,12,"Drawings are not in draft form and where applicable carry the \"Tender\", \"For Construction\" or “As Built’ stamp/status","Please Confirm"]
[null,13,"Specifications are not in draft format","Please Confirm"]
[null,14,"All relevant information is included within the credit it supports. (Appendices for each credit can be included, but they must be within the credit itself, clearly referenced within the documentation and have relevant sections highlighted.)","Please Confirm"]
[null,15,"All relevant communication with the GBCSA is included (including CIR Rulings and Technical Clarifications relevant to this project) ","Please Confirm"]
[null,16,"All drawings are still legible after scaling (especially small stamps, monitors/sensors etc.)","Please Confirm"]
[null,17,"All inputs are consistent throughout the submission. (E.g. the fresh air rates claimed in IEQ-1 Ventilation Rates are consistent with Energy modelling in Ene-1. Assessors will not award points and will require conformation where there are inconsistencies.)","Please Confirm"]
[null,18,"Submission for each credit includes all documentation stipulated in the Technical Manual and the TC/CIR portal on the GBCSA website","Please Confirm"]
[null,19,"All credits claiming “na” have the required supporting documentation","Please Confirm"]
[null,20,"CD/DVD cover and CD/DVD, communicates the official project name, project reference number, project address, Green Star SA Tool, contact person’s details, submission round and date. ","Please Confirm"]
[null,21,"Folders are included within the digital submission (CD’s) and correspond to the Green Star SA categories and are in the correct order, following the categories and credits. ","Please Confirm"]
[null,22,"All documents are orientated in the same direction","Please Confirm"]
[null,23,"All comments from Round 1 have been clearly addressed; new information and/or new credits are highlighted. ","Please Confirm"]
[null,24,"The AP declaration has been signed and submitted with the submission","Please Confirm"]
[]
[null,null,"Submission delivery"]
[null,25,"Four digital copies (four CDs) have been prepared for the submission","Please Confirm"]
[]
[]
[null,"Name: ___________________________________      Company: ___________________________________    "]
[]
[null,"Signature of Applicant: ___________________________________                        "]
[]
[null,"Note: If any of the above have not been complied with, the GBCSA reserves the right to return submission documentation to the project for re-submission and compliance with the above."]

{"sheet":"Applicant Declaration","index":7,"n_rows":11,"n_cols":2,"rows_kept":11,"cut":false,"hidden":true,"merged":[[10,1,22,1]]}
[]
[]
[null,"Green Star SA - Office v1"]
[]
[]
[]
[null,"Green Star SA Project Submission - Applicant Declaration"]
[null,"*This page must be printed and signed by the project applicant, and included in the general section of the project submission for Round 1 and Round 2."]
[]
[]
[null,"The Green Building Council of South Africa (GBCSA) aims to ensure that every Green Star SA submission is of a good quality and reflects the appropriate correct and true contractual documents on the project (whether they are Design or As Built project contractual documents). In this regard, the GBCSA requires that all Green Star SA project applicants sign this acknowledgement and declaration letter. \n\nAcknowledgement and declaration by the Green Star SA project applicant:\n\nI/We,___________________________________________________, the person/s responsible for compiling the Green Star SA submission on behalf of ________________________________________________ (the Applicant), confirm that I/we have taken due care, and acknowledge and declare that (to the best of my/our knowledge):\n\n1. I/We have read and understood the relevant technical manual, the conditions of certification and any relevant Technical Clarifications, Errata and Credit Interpretation Requests. \n2. All documentation submitted by me/us on behalf of the Applicant towards this Green Star SA submission has been verified by the appropriate professional/s as being true, correct and accurate.\n3. All documentation submitted by me/us on behalf of the Applicant complies with all applicable legislation.\n4. All documents and reports submitted to me/us by the Applicant's project team are true and correct and accurately reflect the project’s contractual documentation (whether for a Design or As Built submission).\n5. All documents and reports which I/we have prepared for the submission are true and correct and accurately reflect the project’s contractual documentation (whether for a Design or As Built submission).\n6. I/We have disclosed all applicable information relevant to the Application and undertake to disclose any further information that may influence the Application.\n\nWhere the GBCSA identifies any serious or systematic non-conformances on project documentation in a submission from the Applicant, the GBCSA has the right to query such non-conformance/s with the Applicant, at which point the Applicant is required to investigate this further with its project team, and provide a written response to the GBCSA by no later than 7 (seven) business days from the date on which the query was made to the Applicant by the GBCSA. If the response from the Applicant confirms that the information provided was incorrect, the Applicant's project team can:\n\na) For a Round 1 submission re-submit the correct information in Round 2 (as per assessor comments) or clarify that the information is not available and concede the point in Round 2\nb) For a Round 2 submission, confirm to the GBCSA the incorrect nature of the information submitted, in which event the incorrect information will be excluded from the submission documents counted in the Round 2 results.\n\nIf the response from the Applicant confirms that the information provided was correct, the Applicant's project team can, on behalf of the Applicant:\n\nc) In a Round 1 submission re-submit the correct information in Round 2.\nd) In a Round 2 submission, notify the GBCSA that such information was in fact correct, in which event the GBCSA will run this by the assessors for a final review before the results are published. \n\nWhere these processes are not followed and the relevant submission documents remain under question, the GBCSA will notify the Applicant, and the credit/s to which this information relates will be unobtainable. Where this incomplete process occurs more than once, with the Applicant, the GBCSA reserves the right not to accept any further submissions from this Applicant in future. At the first instance where this incomplete process occurs, the Applicant will be placed on twelve (12) months’ probation, during which time any similar infringement would allow the GBCSA to exercise its right to not accept any further submissions from the Applicant. Further to this, where the Applicant is a Green Star SA Accredited Professional (GSSA AP), the GBCSA reserves the right to remove the Applicant’s GSSA AP qualification and remove them from the GSSA AP registry on the GBCSA’s website. \n\nSignature: ___________________________________    Date: ___________________________________     \n\nName: ___________________________________      Company: ___________________________________    \n\nSignature of Applicant’s line manager warranting that s/he is duly authorised: ___________________________________                        \n\nName of Applicant’s line manager warranting that s/he is duly authorised: ___________________________________       \n"]

{"sheet":"Building Input","index":8,"n_rows":50,"n_cols":3,"rows_kept":50,"cut":false,"hidden":true,"merged":[[5,1,7,1],[49,1,49,2]]}
[null,{"$f":"Calculation!N31","v":"Green Star SA - Existing Building Performance PILOT"},"Building Input Worksheet"]
[null,"New or Refurbished Building:"]
[null,"Type of Rating"]
[]
[null,"Name of Building:"]
[null,"Address of Building:"]
[]
[]
[null,"Postcode:"]
[null,"Province:"]
[]
[null,"Applicant:"]
[null,"Contact Person:"]
[]
[null,"Green Star SA Accredited Professional:"]
[null,"Project Manager:"]
[null,"Architect:"]
[null,"Structural/Civil Engineer:"]
[null,"Mechanical Engineer:"]
[null,"Electrical Engineer:"]
[null,"Wet Services Engineer:"]
[null,"Fire Systems Engineer:"]
[null,"Quantity Surveyor:"]
[null,"Acoustic Consultant:"]
[null,"Landscaping Consultant:"]
[null,"Building Surveyor:"]
[null,"Main Contractor:"]
[null,"Local Planning Authority:"]
[]
[null,"Total Gross Floor Area (GFA) in m²:"]
[null,"Total Commercial Office GFA in m²:"]
[null,"Total Commercial Office Usable Area (UA) in m²:"]
[null,"Total Car Parking Area in m²:"]
[null,"Sub basement Parking Area (B2 and below) in m²:"]
[null,"External Areas (excluding Car Parking) in m²:"]
[null,"% of Commercial Office Space:",{"$f":"IF(C31>0,C31/C30,)","v":0}]
[null,"Eligibility for Assessment",{"$f":"IF(C36>=80%,\"The project meets area compliance for Green Star SA assessment.\",\"Area compliance not met. To be eligible for Green Star SA assessment, Commercial Office GFA must account for at least 80% of the total GFA.\")","v":"Area compliance not met. To be eligible for Green Star SA assessment, Commercial Office GFA must account for at least 80% of the total GFA."}]
[]
[null,"Building Description:\n(Orientation, Form, Structure, Façade, etc.)"]
[]
[null,"Building Services:\n(Heating, Cooling, Ventilation, Lighting, Lifts, Domestic Hot Water)"]
[]
[null,"Todays Date:"]
[null,"Current Project Phase:"]
[null,"Fully Registered Date:"]
[null,"Site Handover Date:"]
[null,"Construction Commencement Date:"]
[null,"Practical Completion Date:"]
[]
[null,"NOTE: Use of Green Star SA - Office v1 may predict a rating that differs from that achieved via formal Green Star SA certification. Detailed guidance on credit compliance criteria is contained in the Green Star SA - Office v1 Technical Manual."]

{"sheet":"Management","index":9,"n_rows":19,"n_cols":11,"rows_kept":19,"cut":false,"hidden":false,"merged":[[3,0,3,1]]}
["Green Star SA - Existing Building Performance PILOT",null,null,null,null,null,null,null,null,"Category Score"]
["Management",null,null,null,"Category Summary:  ",{"$f":"F15","v":18.5},{"$f":"G15","v":18.5},{"$f":"H15","v":0},{"$f":"I15","v":0},{"$f":"'Credit Summary'!I12","v":0}]
["Credit Summary for:",null,null,{"$f":"IF('Building Input'!$C$5=0,\"\",'Building Input'!$C$5)","v":""},null,null,null,{"$f":"IF(OR((K3=Calculation!$D$97),(K3=Calculation!$D$98),((H2+I2)>G2)),Calculation!$D$99,\"\")","v":""},null,null,{"$f":"T(K5:K14)","v":""}]
["Ref No.",null,"Title","Aim of Credit","Credit Criteria Summary","No. of Points Available","No. of Points Available","No. of Points Achieved","Points to be Confirmed"," Comments"," Comments"]
["EB-","Man-1","Certified Buildings","To reward buildings that have shown previous environmental achievement through As Built Green Star SA ratings and have mainained this performance in operation.","1 point is available as follows:                                 \n                                                                                                                                                                                                    \nCertified Buildings                                                                                                                                                       \n1 point is awarded if the building has a Green Star SA - Design/As-Built certification.\n",1,{"$f":"IF(H5=\"na\",0,F5)","v":1}]
["EB-","Man-2","Accredited Professional","To encourage and recognise the involvement of qualified individuals who can assist the owner/ facilities management team with the integration of Green Star SA aims and processes throughout the assessment of baselines, targeted improvements and interventions before and during the performance period to application, submission and certification.","1 point is awarded if a principal participant in the existing building team is a Green Star SA Existing Buildings Accredited Professional \n\nAND\n\nHas been employed or engaged by the building owner to provide support and encourage the operations, maintenance, and upgrade team integration required for Performance Rating implementation. Also, to streamline the application and certification process.\n\nThis credit can be claimed as ‘Not Applicable’ for PILOT projects. Enter \"na\" in the 'No. of Points Achieved' column.\n",1,{"$f":"IF(OR((H6=\"na\"),(I6=\"na\")),0,F6)","v":1}]
["EB-","Man-3","Building Management","To recognise management and operating processes and procedures used to optimise building environmental performance.","5 points are available as follows:                                 \n                                                                                                                                                                                              \nBuilding Operations Manual                                                                                   \n1 point is awarded where a Building Operations Manual has been implemented and is actively used as a guide for operating building systems efficiently and managing resources effectively.\n\n*Note – for PILOT Projects, the Building Operations Manual need not be implemented throughout the performance period, but the manual must have been produced.\n                                                                                                                                                   Building Users’ Guide                                                                                            \n1 point is awarded where a simple and easy-to-use Building Users’ Guide is available and is used as part of building management, for the purpose of  providing relevant building information to users, occupants and tenants.       \n\nIf the requirement for a Building Users’ Guide has been satisfied under the Green Star SA Design / As-Built certification, this point will be automatically be awarded.                                 \n                                                                                                                                            \nMaintenance Management                                                                                   \n1 point is awarded where there is evidence of operational maintenance planning and scheduling for Building assets and equipment.\n\n1 additional point will be awarded where the building owner demonstrates that 75% of the planned maintenance activities have been executed and that the corresponding budget expenditure has been met during the performance period. \n\nA total of two points can be awarded here, the second and third points being dependent on achieving of the first.\n                                                                                                                                                                       ",4,{"$f":"IF(H7=\"na\",0,F7)","v":4}]
[null,null,null,null,"Life Cycle Maintenance                                                                                       \n1 point will be awarded where there is a programme of life cycle maintenance or replacement of key building components, which is actively used in optimising the building’s environmental performance.",1,1]
["EB-","Man-4","Green Cleaning Performance","To encourage high performance cleaning practices, which reduce the exposure of building occupants and maintenance personnel to potentially hazardous chemical, biological and particulate contaminants that compromise indoor environmental quality, human health, building fabric and the natural environment. ","3.5 points are available as follows                                     \n                      \nGreen Cleaning Policy & High Performance Green Cleaning Programme\n1.5 points are awarded where:\n\n• The applicant develops and implements* a compliant Green Cleaning Policy during the performance period. This Green Cleaning Policy must be in line with the Green Star SA Policy Model (available from the GBCSA on request).\n\n• A high performance Ggreen Ccleaning Pprogramme is in place and actively and measurably implemented during the performance period*.\n\n*Note – For PILOT projects only, implementation of the Green Cleaning Policy and Green Cleaning  Programme may be waivered, however the Policy and Programme must have been developed.",1.5,{"$f":"IF(H9=\"na\",0,F9)","v":1.5}]
[null,null,null,null,"Purchase of Green Cleaning Consumables \nUp to 1  Point is awarded as follows:\n\n0.5 points are awarded where 20% by cost of total cleaning consumables purchased during the performance period* meet the sustainability criteria for their product category.\n\n0.5 additional points are awarded where 40% by cost of total cleaning consumables purchased during the performance period* meet the sustainability criteria for their product category.\n\n\n",1,{"$f":"IF(H10=\"na\",0,F10)","v":1}]
[null,null,null,null,"Purchase of Green Cleaning Equipment\n0.5 points are awarded where 60% of all new purchases of cleaning equipment meet the sustainability criteria outlined under the Compliance Requirements. A phase-out plan for existing equipment that is non-compliant has to be submitted.",0.5,{"$f":"IF(H11=\"na\",0,F11)","v":0.5}]
[null,null,null,null,"Cleaning Audit\n0.5 points are awarded where a cleaning audit is carried out in accordance with the stipulated guidelines and a score of 3 or less is obtained.\n\nFor all Multi-tenanted Buildings, the following applies:\n\nWhere the landlord-occupied areas (landlord-tenanted space and common areas) comprise more than 10% of the GLA, half of the points available can be achieved for landlord compliance only.\n\nThe remaining 50% of the points are awarded where tenants have committed to specific Tenant Criteria clauses requiring them to implement the targeted criteria as set out within the credit. The number of tenants who have committed to these clauses must be such that a minimum of 75%  of the building GLA is compliant with the credit criteria (either through landlord or tenant commitment). See Technical Manual for Further Details\n",0.5,{"$f":"IF(H12=\"na\",0,F12)","v":0.5}]
["EB-","Man-5","Green Leasing","To recognise and encourage collaboration between the building owner and tenants in order to manage and operate the building along environmentally sustainable principles whilst realising mutual benefit. ","6 points are available as follows:                                  \n                                                                                    \nTenancy fit-out and alterations                                                                              A maximum of 2 points can be awarded where a signed agreement is in place between building owner and tenant during the performance period, in order to ensure that fit-out design and construction for the occupied rentable space meets the intended sustainability objectives.\n\nPoints are adjusted depending on the type of agreement signed (Memorandum of Agreement, Mutual Disclosure or Performance agreement) as well as the percentage of tenanted area covered by a green lease. See table in Technical Manual for further guidance.\n\n                                                                                                                                                                              Management and operations                                                                          \nA maximum of 4 points can be awarded where the building owner has a signed agreement with the tenant during the performance period, in order to ensure that occupied rentable space is operated and managed in compliance with the Green Star SA Existing Building Performance checklist.\n\nPoints are adjusted depending on the type of agreement signed (Memorandum of Agreement, Mutual Disclosure or Performance agreement) as well as the percentage of tenanted area covered by a green lease. See table in Technical Manual for further guidance.\n\nWhere no leasing arrangement exists for the building (e.g. owner-tenanted buildings), or where areas under a lease agreement make up less than 30% of the building GLA, this credit can be claimed as ‘Not Applicable’.  Enter \"na\" in the 'No. of Points Achieved' column.\n\n\n",6,{"$f":"IF(OR((H13=\"na\"),(I13=\"na\")),0,F13)","v":6}]
["EB-","Man-6","Ongoing Monitoring and Metering","To recognize operational practices which facilitate effective ongoing monitoring and metering of water and energy consumption.","2 points are available as follows:                                          \n                                       \nBasic Monitoring Strategy                                                                                        0.5 points are awarded where metering is provided for major energy consumption of the building for the performance period AND \nThere is an effective mechanism for monitoring the consumption data.\n\n0.5 points are awarded where metering is provided for major water consumption of the building for the performance period AND \nThere is an effective mechanism for monitoring the consumption data.\n\n                                                                                                                                                                                            Advanced Monitoring Strategy                                                                                                                        0.5 points for water and 0.5 points for energy are awarded where:\n• The point above is achieved, AND\n• Installed meters are online and live monitoring is implemented, AND \n• There is an effective automated mechanism for monitoring the consumption data (trending, logging, etc)  \n",2,2]
[null,null,null,null,"Total Points:",{"$f":"SUM(F5:F14)","v":18.5},{"$f":"SUM(G5:G14)","v":18.5},{"$f":"SUM(H5:H14)","v":0},{"$f":"SUM(I5:I14)","v":0}]
[]
[]
[]
[{"$f":"Calculation!$C$86","v":"Applicants are to refer to the Green Star SA - Existing Building Performance PILOT Technical Manual for explicit credit criteria and documentation requirements."}]

{"sheet":"IEQ","index":10,"n_rows":22,"n_cols":12,"rows_kept":22,"cut":false,"hidden":false,"merged":[[3,0,3,1]]}
["Green Star SA - Existing Building Performance PILOT",null,null,null,null,null,null,null,null,null,"Category Score"]
["Indoor Environment Quality",null,null,null,"Category Summary:  ",{"$f":"F18","v":17},{"$f":"G18","v":17},{"$f":"H18","v":15.5},{"$f":"I18","v":0},{"$f":"J18","v":0},{"$f":"'Credit Summary'!I22","v":0}]
["Credit Summary for:",null,null,{"$f":"IF('Building Input'!$C$5=0,\"\",'Building Input'!$C$5)","v":""},null,null,null,null,{"$f":"IF(OR((L3=Calculation!$D$97),(L3=Calculation!$D$98),((I2+J2)>H2)),Calculation!$D$99,\"\")","v":""},null,null,{"$f":"T(L5:L16)","v":""}]
["Ref No.",null,"Title","Aim of Credit","Credit Criteria Summary","No. of Points Available","No. of Points Available","No. of Points Available","No. of Points Achieved","Points to be Confirmed"," Comments"," Comments"]
["EB-","IEQ-1","Indoor Air Quality","To recognize air management system attributes that provide occupants with high quality indoor air. ","3 points are available as follows:                                                                                       \n        \nFresh Air\nUp to 2 points are awarded where it is demonstrated that for 95% of the Nominated Area, outside air is provided at rates greater than the l/s per person requirements of SANS 10400-O:2011, or naturally ventilated \n\n• 10% improvement for one point;\n• 33% improvement for two points;  \n\nSystem performance\n1 point is awarded where it is demonstrated that:\n\n• Appropriate filters are installed in all duct systems to avoid any dust infiltration through the air inlets.\n\n• A positive pressure is maintained in the occupied spaces to ensure no dust infiltration takes place through the building envelope\n\n• Fresh air intakes are positioned in locations in order to avoid the intake of outdoor pollutants.\n\n• The air distribution system is sufficiently circulating outdoor air to all occupied spaces.\n\n\n",3,{"$f":"IF(I5=\"na\",0,F5)","v":3},{"$f":"IF(I5=\"na\",0,G5)","v":3}]
["EB-","IEQ-2","Lighting Comfort","To recognize operational practices that provide occupants with a high degree of lighting comfort.","2 points are available as follows:\n\nLuminaire ballasts \n1 point is awarded where high frequency electronic ballasts are employed in all flourescent luminaires in regular occupied spaces AND 95% of the Building’s usable area (UA) \n\nOR \n\na Magnetic ballast replacement program is in place and being implemented within a 12 month period\n\nLighting comfort\n1 point is awarded where there is a process in place to monitor and measure lighting lux levels and achieve the performance parameters set out in this credit  in regularly occupied spaces during the performance period, ensuring that lighting lux levels are appropriate to the tasks performed in each space.\n\n\nFor all Multi-tenanted Buildings, the following applies:\n\nWhere the landlord-occupied areas (landlord-tenanted space and common areas) comprise more than 10% of the GLA, half of the points available can be achieved for landlord compliance only.\n\nThe remaining 50% of the points are awarded where tenants have committed to specific Tenant Criteria clauses requiring them to implement the targeted criteria as set out within the credit. The number of tenants who have committed to these clauses must be such that a minimum of 75%  of the building GLA is compliant with the credit criteria (either through landlord or tenant commitment). See Technical Manual for Further Details",2,{"$f":"IF(I6=\"na\",0,F6)","v":2},{"$f":"IF(I6=\"na\",0,G6)","v":2}]
["EB-","IEQ-3","Thermal Comfort","To recognize operational practices that monitor and maintain a high level of thermal comfort for building occupants.","3 points are available as follows:\n\nMechanically Ventilated spaces\n1 point is awarded where there is a process in place to \n• Periodically measure temperature in occupied spaces.\n\n1 point is awarded where there is a process in place to\n• Periodically measure humidity in occupied spaces.\n• Periodically assess air speed and radiant heat in occupied spaces through a high-level audit.\n• Gather occupant feedback through a thermal comfort survey feedback form.\n\n1 additional point is awarded when the above is achieved and the predicted mean vote (PMV) levels, calculated in accordance with ISO7730 tables E.1 to E.9 using standard clothing and metabolic rates values, are within the following limits for at least 98% of occupied hours: \n\n• PMV levels between -1.0 and + 1.0 (inclusive)\n\nNaturally Ventilated spaces\n\n1 point is awarded where there is a process in place to \n• Periodically measure temperature in occupied spaces.\n\n1 point is awarded where there is a process in place to\n• Gather occupant feedback through a thermal comfort survey feedback form.\n\n1 point is awarded when the above is achieved and the internal operative temperatures are within the ASHRAE Standard 55-2004 80% Acceptability Limits:",3,{"$f":"IF(I7=\"na\",0,F7)","v":3},3]
[null,null,null,null,"For all Multi-tenanted Buildings, the following applies:\n\nWhere the landlord-occupied areas (landlord-tenanted space and common areas) comprise more than 10% of the GLA, half of the points available can be achieved for landlord compliance only.\n\nThe remaining 50% of the points are awarded where tenants have committed to specific Tenant Criteria clauses requiring them to implement the targeted criteria as set out within the credit. The number of tenants who have committed to these clauses must be such that a minimum of 75%  of the building GLA is compliant with the credit criteria (either through landlord or tenant commitment). See Technical Manual for Further Details"]
["EB-","IEQ-4","Occupant Survey","To encourage the assessment of building occupants’ satisfaction as it relates to comfort and other building services performance issues.","2 points are available as follows:                                                                                       \n                                                                                                                                                                                            Occupant Survey                        \n1 point is awarded where at least one occupant survey is conducted during the performance period.                                                      \n                                                                                                                                                                                            Occupant Satisfaction Levels                        \nPoints will be awarded for a survey conducted during the measurement period, according to the below:\nSurvey Outcome \nAt least 80% of respondents indicate they are ‘Satisfied’, Points: 1                                       At least 60% of respondents indicate they are ‘Satisfied’, Points: 0.5\n\nOR\n\n0.5 points are awarded where performance improvement of 5% or more is achieved from the previous survey.  \n0.5 additional points will be granted where a corrective action plan is in place to improve performance.\n",2,{"$f":"IF(I9=\"na\",0,F9)","v":2},2]
["EB-","IEQ-5","Acoustic Quality","To encourage operational practices that monitor and maintain ambient noise indoor-levels from building interior and all outside sources at an appropriate and comfortable level, solve problems created by transference of sound to adjacent spaces and avoid excessive noise from the operations of the existing building to the immediate surrounding environment.","3 points are available as follows:                                                                                       \n              \nNoise Levels- Internal and External sources                        \nTesting\n0.5 points are awarded where there is a process in place to monitor and measure noise from building services and other interior and exterior sources during the performance period.\n\nPerformance:\n0.5 points are rewarded for maintaining acoustic comfort at acceptable levels for its particular space type and/or activity as defined inSANS10103:2008.\n\nWhere noise levels are not in accordance with SANS10103:2008, the 0.5 points (for performance) are not achieved and a corrective action plan must be in place to achieve the required noise levels.\n\n                                                                            \n",1,{"$f":"IF(I10=\"na\",0,F10)","v":1},1]
[null,null,null,null,"Reverberation\n1 Point is awarded as follows;\nTesting\nWhere there is a process in place to monitor and measure the reverberation times in the nominated area during the performance period.\n\nPerformance\nProjects are required to meet the specified criteria described below (AS/NZS 2107), or where the specified criteria are not achieved, a corrective action plan must be in place to achieve the required performance.\n                             \n                                                                                                                              ",1,{"$f":"IF(I11=\"na\",0,F11)","v":1},1]
[null,null,null,null,"Transference of Sound to adjacent space                           \n\n0.5 points are awarded as follows:\n\nTesting\nWhere there is a process in place to monitor, measure and mitigate problems caused by transference of noise and speech between nominated areas during the performance period, for its particular space type and/or activity, such as described below. (EN ISO 3382-3 and SANS10218:2012 Part 1).\n\nPerformance\nWhere the required performance as per these standards are not achieved, a corrective action plan must be in place to align with required performance levels.\n",0.5,{"$f":"IF(I12=\"na\",0,F12)","v":0.5},0.5]
[null,null,null,null,"Noise from the existing building operations                              \n0.5 points are awarded as follows;\n\nTesting\nWhere there is a process in place to monitor, measure and maintain acceptable levels of noise caused by the building’s operations to the surrounding environment during the performance period. (Local Noise Control Regulations). Compliance with Local Noise Control regulations must be achieved to receive points under this criteria (no points rewarded for having corrective action plan in place).\n",0.5,{"$f":"IF(I13=\"na\",0,F13)","v":0.5}]
[null,null,null,null,"For all Multi-tenanted Buildings, the following applies:\n\nWhere the landlord-occupied areas (landlord-tenanted space and common areas) comprise more than 10% of the GLA, half of the points available can be achieved for landlord compliance only.\n\nThe remaining 50% of the points are awarded where tenants have committed to specific Tenant Criteria clauses requiring them to implement the targeted criteria as set out within the credit. The number of tenants who have committed to these clauses must be such that a minimum of 75%  of the building GLA is compliant with the credit criteria (either through landlord or tenant commitment). See Technical Manual for Further Details"]
["EB-","IEQ-6","Daylight and Views","To recognize the introduction of naturally lit spaces which provide occupants in regular occupied spaces with access to appropriate daylight and quality views for the activities being performed during the performance period.","2 points are available as follows:                                                                                       \n \nDaylight Access and Glare Control                   \n1 point is awarded where occupants in 60% of regularly occupied spaces have access to appropriate amounts of daylight, as measured or as calculated for the occupied space during the performance period.                                                      \n                                   \nA further 0.5 points are awarded where occupants in regularly occupied spaces have deemed to comply by showing proof of installed operational features. that reduce the discomfort of glare from natural light                              \n                                       \nViews and Lines of Sight                               \n0.5 points are awarded where occupants in 60% of regularly occupied spaces have a clear line of sight to high quality internal (day-lit atrium) or external views, providing a connection between indoor space and the outdoors, as measured from a deemed to satisfy approach.",2,{"$f":"IF(I15=\"na\",0,F15)","v":2},2]
["EB-","IEQ-7","Indoor Pollutant Management","To prevent pollutants coming from VOC’s, CO CO2 and printer pollutants built up by managing the pollutant source to help sustain the comfort and well-being of building occupants.  ","2 points are available as follows:\n                                                                                                                                            \nIndoor Air Quality (IAQ) manager                    \n1 point is awarded where an IAQ management plan is in place to optimise practices to prevent the pollutant built up in buildings for the well-being of the occupants, and where a specific IAQ manager responibility has been allocated.                                   \n",1,{"$f":"IF(I16=\"na\",0,F16)","v":1},{"$f":"IF(I16=\"na\",0,G16)","v":1}]
[null,null,null,null,"Regular Indoor Air Quality testing                \n  \n1 point is awarded where annual testing of indoor air is carried out in regular occupied spaces and parking areas for carbon monoxide and carbon dioxide and where it exceeds limits a correction program needs to be implemented.                                                                                                                                                                          \n",1,{"$f":"IF(I17=\"na\",0,F17)","v":1}]
[null,null,null,null,"Total Points:",{"$f":"+SUM(F5:F17)","v":17},{"$f":"SUM(G5:G17)","v":17},{"$f":"SUM(H5:H16)","v":15.5},{"$f":"SUM(I5:I17)","v":0},{"$f":"SUM(J5:J17)","v":0}]
[]
[]
[]
[{"$f":"Calculation!$C$86","v":"Applicants are to refer to the Green Star SA - Existing Building Performance PILOT Technical Manual for explicit credit criteria and documentation requirements."}]

{"sheet":"Energy","index":11,"n_rows":13,"n_cols":11,"rows_kept":13,"cut":false,"hidden":false,"merged":[[4,10,5,10],[6,10,7,10],[6,2,7,2],[6,3,7,3],[6,9,7,9],[4,2,5,2],[4,3,5,3],[4,9,5,9],[3,0,3,1],[4,1,5,1],[6,1,7,1],[4,0,5,0],[6,0,7,0]]}
["Green Star SA - Existing Building Performance PILOT",null,null,null,null,null,null,null,null,"Category Score"]
["Energy",null,null,null,"Category Summary:  ",{"$f":"F9","v":27},{"$f":"G9","v":27},{"$f":"H9","v":0},{"$f":"I9","v":0},{"$f":"'Credit Summary'!I27","v":0}]
["Credit Summary for:",null,null,{"$f":"IF('Building Input'!$C$5=0,\"\",'Building Input'!$C$5)","v":""},null,null,null,{"$f":"IF(OR((K3=Calculation!$D$97),(K3=Calculation!$D$98),((H2+I2)>G2)),Calculation!$D$99,\"\")","v":""},null,null,{"$f":"T(K5:K8)","v":""}]
["Ref No.",null,"Title","Aim of Credit","Credit Criteria Summary","No. of Points Available","No. of Points Available","No. of Points Achieved","Points to be Confirmed","Comments","Comments"]
["EB-","Ene-1","Energy Consumption (GHGE)","To encourage the reduction of greenhouse gas emissions associated with the use of energy in building operations.","25 points are available as follows:                                                                                                                                    \nMinimum Requirements\nTo be eligible for any points in this credit, an energy consumption baseline must be  established.                                                       \n                                                                                                                                                                                                                                "]
[null,null,null,null,"peak Electricity Demand performance                                                                                     \nA total of 2 points may be awarded where it is demonstrated that the building’s Peak Demand Performance meets the required benchmarks ",25,{"$f":"IF(H6=\"na\",0,F6)","v":25}]
["EB-","Ene-2","Peak Electricity Demand","To recognize operational practices that reduce peak demand on electricity supply infrastructure.","2 points are awarded as follows:\n\nMinimum Requirement: Peak Electricity Demand Baseline.               \nTo be eligible for any points in this credit, a peak electricity demand baseline must be established. \n"]
[null,null,null,null,"Peak Electricity Demand performance                                                                                     \nA total of 2 points may be awarded where it is demonstrated that the building’s Peak Demand Performance meets the required benchmarks set out in the credit (improvement on SANS 10400-XA where applicable, or improvement on a historical baseline where not). See Technical Manual for further details.",2,{"$f":"IF(H8=\"na\",0,F8)","v":2}]
[null,null,null,null,"Total Points:",{"$f":"SUM(F5:F8)","v":27},{"$f":"SUM(G5:G8)","v":27},{"$f":"SUM(H5:H8)","v":0},{"$f":"SUM(I5:I8)","v":0}]
[]
[]
[]
[{"$f":"Calculation!$C$86","v":"Applicants are to refer to the Green Star SA - Existing Building Performance PILOT Technical Manual for explicit credit criteria and documentation requirements."}]

{"sheet":"Transport","index":12,"n_rows":11,"n_cols":11,"rows_kept":11,"cut":false,"hidden":false,"merged":[[3,0,3,1]]}
["Green Star SA - Existing Building Performance PILOT",null,null,null,null,null,null,null,null,"Category Score"]
["Transport",null,null,null,"Category Summary:  ",{"$f":"F7","v":4},{"$f":"G7","v":4},{"$f":"H7","v":0},{"$f":"I7","v":0},{"$f":"'Credit Summary'!I31","v":0}]
["Credit Summary for:",null,null,{"$f":"IF('Building Input'!$C$5=0,\"\",'Building Input'!$C$5)","v":""},null,null,null,{"$f":"IF(OR((K3=Calculation!$D$97),(K3=Calculation!$D$98),((H2+I2)>G2)),Calculation!$D$99,\"\")","v":""},null,null,{"$f":"T(K5:K5)","v":""}]
["Ref No.",null,"Title","Aim of Credit","Credit Criteria Summary","No. of Points Available","No. of Points Available","No. of Points Achieved","Points to be Confirmed","Comments","Comments"]
["EB-","Tra-1","Alternative Transportation","To measure and promote/encourage the use of alternative transportation modes for commuting and as a result reduce pollution and land development impacts from automobile use. ","Four points are available as follows:                                                                                        \nTransportation Modes Survey                                                                                  \n1 point is awarded where a Transportation Modes Survey, aimed at the regular occupants of the building(s), is delivered during the performance period.\n\nTransient occupants/visitors must be surveyed if either the typical peak or daily average is greater than the number of regular building occupants. \n                                                                                       \nGreen Travel Plan – Regular Occupants and Visitors \n2 points are awarded where an Alternative Transportation Programme that addresses regular occupants, of the project building(s), is in place and operational during the performance period.\n\nTransient occupants/visitors must be surveyed if either the typical peak or daily average is greater than the number of regular building occupants.                        \n\n",3,{"$f":"IF(H5=\"na\",0,F5)","v":3}]
[null,null,null,null,"Improved Transportation Modes Performance\n1 additional point is awarded where there has been a follow-up Transportation Modes Survey Conducted which shows at least 10% reduction in single occupant car drivers.\n                                                                                                                                                                                                   ",1,{"$f":"IF(OR((H6=\"na\"),(I6=\"na\")),0,F6)","v":1}]
[null,null,null,null,"Total Points:",{"$f":"SUM(F5:F6)","v":4},{"$f":"SUM(G5:G6)","v":4},{"$f":"SUM(H5:H6)","v":0},{"$f":"SUM(I5:I6)","v":0}]
[]
[]
[]
[{"$f":"Calculation!$C$86","v":"Applicants are to refer to the Green Star SA - Existing Building Performance PILOT Technical Manual for explicit credit criteria and documentation requirements."}]

{"sheet":"Water","index":13,"n_rows":10,"n_cols":11,"rows_kept":10,"cut":false,"hidden":false,"merged":[[3,0,3,1]]}
["Green Star SA - Existing Building Performance PILOT",null,null,null,null,null,null,null,null,"Category Score"]
["Water",null,null,null,"Category Summary:  ",{"$f":"F6","v":12},{"$f":"G6","v":12},{"$f":"H6","v":0},{"$f":"I6","v":0},{"$f":"'Credit Summary'!I35","v":0}]
["Credit Summary for:",null,null,{"$f":"IF('Building Input'!$C$5=0,\"\",'Building Input'!$C$5)","v":""},null,null,null,{"$f":"IF(OR((K3=Calculation!$D$97),(K3=Calculation!$D$98),((H2+I2)>G2)),Calculation!$D$99,\"\")","v":""},null,null,{"$f":"T(K5:K5)","v":""}]
["Ref No.",null,"Title","Aim of Credit","Credit Criteria Summary","No. of Points Available","No. of Points Available","No. of Points Achieved","Points to be Confirmed","Comments","Comments"]
["EB-","Wat-1","Potable Water","To recognise efficient potable water use associated with building operations thus reducing the burden on potable water supply and wastewater systems. ","12 points are awarded as follows:\n\nPotable Water Performance\nA total of 12 points may be awarded where percentage reductions in potable water use associated with operations are achieved during the performance period.\n\nPoints are awarded for improvement in water efficiency compared to either an industry benchmark (see GSSA Energy & Water Benchmarking Tool for Office buildings) or a notional benchmark calculated using the Potable Water Calculator up to a maximum of 12 points. \n\nAND\n\n1 point is awarded where there is proven water saving during the last 6 months of the performance period compared to same period in previous year if the total potential points are not fully targeted in water efficiency.\n\nA further 1 point is rewarded where this water saving exceeds 10%.\n\n",12,{"$f":"IF(H5=\"na\",0,F5)","v":12}]
[null,null,null,null,"Total Points:",{"$f":"SUM(F5:F5)","v":12},{"$f":"SUM(G5:G5)","v":12},{"$f":"SUM(H5:H5)","v":0},{"$f":"SUM(I5:I5)","v":0}]
[]
[]
[]
[{"$f":"Calculation!$C$86","v":"Applicants are to refer to the Green Star SA - Existing Building Performance PILOT Technical Manual for explicit credit criteria and documentation requirements."}]

{"sheet":"Materials","index":14,"n_rows":18,"n_cols":11,"rows_kept":18,"cut":false,"hidden":false,"merged":[[9,0,12,0],[9,2,12,2],[9,3,12,3],[9,1,12,1]]}
["Green Star SA - Existing Building Performance PILOT",null,null,null,null,null,null,null,null,"Category Score"]
["Materials",null,null,null,"Category Summary:  ",{"$f":"F14","v":12},{"$f":"G14","v":12},{"$f":"H14","v":0},{"$f":"I14","v":0},{"$f":"'Credit Summary'!I40","v":0}]
["Credit Summary for:",null,null,{"$f":"IF('Building Input'!$C$5=0,\"\",'Building Input'!$C$5)","v":""},null,null,null,{"$f":"IF(OR((K3=Calculation!$D$97),(K3=Calculation!$D$98),((H2+I2)>G2)),Calculation!$D$99,\"\")","v":""},null,null,{"$f":"T(K5:K13)","v":""}]
["Ref No.",null,"Title","Aim of Credit","Credit Criteria Summary","No. of Points Available","No. of Points Available","No. of Points Achieved","Points to be Confirmed","Comments","Comments"]
["EB-","Mat-1","Procurement and Purchasing","To recognise procurement and purchasing practices which encourage use of products that are environmentally preferable.","Up to 6 points are awarded as follows:\n\nSustainable Procurement Policy                                              \n1 point will be awarded where there is evidence of a sustainable procurement policy that has been put in place during the performance period.",1,{"$f":"IF(H5=\"na\",0,F5)","v":1}]
[null,null,null,null,"Sustainable Procurement: Operational Consumables                                                                                                         \nPoints will be awarded under this credit where total operational consumables by cost, during the performance period, meet the stipulated sustainability criteria and according to below.                                              \n                                                                                                         \nPortion of operational consumables meeting sustainability criteria:\n20% for 0.5 Points\n40% for 1 Point\n60% for 1.5 Points.\n\n\n                                                                                \n ",1.5,{"$f":"IF(H6=\"na\",0,F6)","v":1.5}]
[null,null,null,null,"Sustainable Procurement of construction materials building refurbishment, alteration and extension (if applicable)\nPoints will be awarded where total construction materials purchased during the performance period by cost meet sustainability criteria stipulated under the Compliance Requirements section of this credit.                                                                                                                                          \nPortion of operational consumables meeting sustainability criteria:\n20% for 0.5 Points\n40% for 1 Point\n60% for 1.5 Points.                                                              \n",1.5,{"$f":"IF(OR((H7=\"na\"),(I7=\"na\")),0,F7)","v":1.5}]
[null,null,null,null,"Sustainable Procurement: Furniture and Movable Equipment                                                                                                      Points will be awarded under this credit where total furniture and movable equipment purchases by cost, during the performance period, meet the stipulated sustainability criteria and according to below.                                             \n                                                                                                         \nPortion of furniture and movable equipment meeting sustainability criteria:\n50% for 0.5 Points\n75% for 1 Point",1,{"$f":"IF(OR((H8=\"na\"),(I8=\"na\")),0,F8)","v":1}]
[null,null,null,null,"Life Cycle Assessment \n\n1 point can be awarded where there is evidence that procurement decision made incorporate life cycle analysis.                                                                                           \n              \nFor all Multi-tenanted Buildings, the following applies:\n\nWhere the landlord-occupied areas (landlord-tenanted space and common areas) comprise more than 10% of the GLA, half of the points available can be achieved for landlord compliance only.\n\nThe remaining 50% of the points are awarded where tenants have committed to specific Tenant Criteria clauses requiring them to implement the targeted criteria as set out within the credit. The number of tenants who have committed to these clauses must be such that a minimum of 75%  of the building GLA is compliant with the credit criteria (either through landlord or tenant commitment). See Technical Manual for Further Details",1,{"$f":"IF(OR((H9=\"na\"),(I9=\"na\")),0,F9)","v":1}]
["EB-","Mat-2","Solid Waste Management","To reward operational practices which reduce the amount of solid waste going to landfill. Such waste may be from typical building operations, including ongoing and durable goods, and from refurbishments, construction or demolition works.","Up to 6 points are awarded as follows:\n\nSolid Waste Management Policy                                                                                 \n1 Point is awarded where a compliant Solid Waste Management Policy for Ongoing Consumables, Hazardous Materials, Movable and Electronic Goods and Construction Waste from Churn and Alterations has to be in place during the performance period.\n\n*Note – for PILOT projects only, the Waste and Materials Management Policy need not be implemented in the performance period, but must have been produced.\n\nWaste Stream Audit of Ongoing Consumables and development of an Operational Waste Management Plan                                                                                       \n1 point is awarded where a building carries out a waste stream audit of the building’s entire ongoing consumable waste stream to establish a baseline that identifies the types and amounts of waste making up the waste stream, thereby identifying opportunities for increased waste minimisation, recycling and waste diversion.\n\nAn operational waste management plan (OWMP) must be developed on the basis of this audit and to outline clearly opportunities for waste minimisation.\n\n",2,{"$f":"IF(H10=\"na\",0,F10)","v":2}]
[null,null,null,null,"Waste to Landfill Diversion: Operational Waste               \n2 points are awarded where the following percentages of operational waste are diverted from landfill during the performance period:\n25% = 1 point\n50% = 1.5 points\n75% = 2 points\n\nand where no hazardous waste (e.g. CFL lamps) and batteries enter the operational waste stream and are collected through a separate and documented process. \n\n1  point is awarded where overall operational waste generated (volume) has been reduced by at least 10% over a 12 months period when compared to the baseline month at the beginning of the performance period.  ",3,{"$f":"IF(H11=\"na\",0,F11)","v":3}]
[null,null,null,null,"Waste to Landfill Diversion: Movable and/or Electronic Goods                                                                          \n0.5 points are awarded where 75% of all movable goods waste is diverted from landfill during the performance period and where no electronic goods enter the movable goods waste stream and are collected and responsibly managed through a separate and documented collection process. \n",0.5,{"$f":"IF(OR((H12=\"na\"),(I12=\"na\")),0,F12)","v":0.5}]
[null,null,null,null,"Waste to Landfill Diversion: Construction Waste–Churn and Alterations            \n0.5  points are awarded where 50% of total construction waste from churn and alterations generated during the performance period is diverted from landfill during the performance period. This credit is N/A if no churn or alterations took place during the performance period.",0.5,{"$f":"IF(OR((H13=\"na\"),(I13=\"na\")),0,F13)","v":0.5}]
[null,null,null,null,"Total Points:",{"$f":"SUM(F5:F13)","v":12},{"$f":"SUM(G5:G13)","v":12},{"$f":"SUM(H5:H13)","v":0},{"$f":"SUM(I5:I13)","v":0}]
[]
[]
[]
[{"$f":"Calculation!$C$86","v":"Applicants are to refer to the Green Star SA - Existing Building Performance PILOT Technical Manual for explicit credit criteria and documentation requirements."}]

{"sheet":"Land Use & Ecology","index":15,"n_rows":25,"n_cols":18,"rows_kept":25,"cut":false,"hidden":false,"merged":[[4,0,5,0],[4,2,5,2],[4,3,5,3],[4,1,5,1],[6,1,8,1],[6,0,8,0]]}
["Green Star SA - Existing Building Performance PILOT",null,null,null,null,null,null,null,null,"Category Score"]
["Land Use & Ecology",null,null,null,"Category Summary:  ",{"$f":"F10","v":5},{"$f":"G10","v":5},{"$f":"H10","v":0},{"$f":"I10","v":0},{"$f":"'Credit Summary'!I45","v":0}]
["Credit Summary for:",null,null,{"$f":"IF('Building Input'!$C$5=0,\"\",'Building Input'!$C$5)","v":""},null,null,null,{"$f":"IF(OR((K3=Calculation!$D$97),(K3=Calculation!$D$98),((H2+I2)>G2)),Calculation!$D$99,\"\")","v":""},null,null,{"$f":"T(K5:K9)","v":""}]
["Ref No.",null,"Title","Aim of Credit","Credit Criteria Summary","No. of Points Available","No. of Points Available","No. of Points Achieved","Points to be Confirmed","Comments","Comments"]
["EB-","Eco-1","Ecological and Site Management","To recognise and encourage practices which maintain the ecological value, reduce negative environmental impact and enhance the provision of ecological services of the site. ","Ecological Assessment – Minimum Requirement \nAn Ecological Assessment of the site must be undertaken.\n"]
[null,null,null,null,"Ecological Policy & Management Plan                     \n2 points are awarded if an Ecological Management Plan is in place for continuous management and enhancement of ecosystem services of the site. The Ecological Management Plan must include a Policy statement regarding the overall intentions for ecological management of the site. The Management Plan should be actively implemented and monitored during the performance period.\n\nThis Credit can be claimed as 'Not Applicable' where less than 25% of the site area (excluding building footprint), or 5% of the total site area (including the building footprint)—whichever is greater, is made up of natural vegetation. Enter \"na\" in the 'No. of Points Achieved' column.",2,{"$f":"IF(H6=\"na\",0,F6)","v":2}]
["EB-","Eco-2","Groundskeeping Practices","To encourage environmentally sensitive landscape, hard surfaces and building exterior maintenance practices that reduce the environmental impact and improve ecological value.","3 points are available as follows:                                                                                       \n                                                  \nSite Maintenance – Landscape Management and Maintenance Plan\n1 point is awarded where a plan is in place that details the site management of landscaped areas according to leading practice methods and is actively implemented and monitored during the performance period                                                                                                                                                                                         \n\nWhere the building location or the building type does not allow for or include landscaped areas, the Landscape Management Plan'  point can be claimed as 'Not Applicable'. Enter \"na\" in the 'No. of Points Achieved' column.",1,{"$f":"IF(H7=\"na\",0,F7)","v":1}]
[null,null,null,null,"Site Maintenance – Hard Surfaces and Building Exterior Management Plan             \n1 point is awarded where a plan is in place that details the management of hard surfaces and the building exterior according to leading practice  methods and is actively implemented and monitored during the performance period                                                                       \n                                                                                                                                                                                                                                                                                                                ",1,{"$f":"IF(H8=\"na\",0,F8)","v":1}]
[null,null,null,null,"Site Maintenance – Integrated Pest Management Plan                                   \n1 point is awarded where an Integrated Pest Management Plan for indoor and outdoor pest management is in place and actively implemented and monitored during the performance period.                                                                                                                                                                                                                                                                                                                        ",1,{"$f":"IF(H9=\"na\",0,F9)","v":1}]
[null,null,null,null,"Total Points:",{"$f":"SUM(F5:F9)","v":5},{"$f":"SUM(G5:G9)","v":5},{"$f":"SUM(H5:H9)","v":0},{"$f":"SUM(I5:I9)","v":0}]
[]
[]
[]
[{"$f":"Calculation!$C$86","v":"Applicants are to refer to the Green Star SA - Existing Building Performance PILOT Technical Manual for explicit credit criteria and documentation requirements."}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Options",null,"Result","Yes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eco- Conditional Requirement met"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eco- Conditional Requirement NOT met"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"The project team acknowledges that the design meets the conditional requirements as stipulated in the Green Star SA Existing Building Performance PILOT Technical Manual. Green Star SA projects are only eligible for formal certification by the GBCSA when ALL Eligibility Criterion (and Conditional Requirements) are met. Please refer to the Technical Manual for further information. "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"The project team acknowledges that the design does NOT meet the conditional requirements as stipulated in the Green Star SA Existing Building Performance PILOT Technical Manual. This Green Star SA project is therefore NOT eligible for formal certification by the GBCSA. Please refer to the Technical Manual for further information."]

{"sheet":"Emissions","index":16,"n_rows":14,"n_cols":11,"rows_kept":14,"cut":false,"hidden":false,"merged":[[4,0,5,0],[4,2,5,2],[4,3,5,3],[4,1,5,1],[6,0,7,0]]}
["Green Star SA - Existing Building Performance PILOT",null,null,null,null,null,null,null,null,"Category Score"]
["Emissions",null,null,null,"Category Summary:  ",{"$f":"F10","v":4.5},{"$f":"G10","v":4.5},{"$f":"H10","v":0},{"$f":"I10","v":0},{"$f":"'Credit Summary'!I51","v":0}]
["Credit Summary for:",null,null,{"$f":"IF('Building Input'!$C$5=0,\"\",'Building Input'!$C$5)","v":""},null,null,null,{"$f":"IF(OR((K3=Calculation!$D$97),(K3=Calculation!$D$98),((H2+I2)>G2)),Calculation!$D$99,\"\")","v":""},null,null,{"$f":"T(K5:K8)","v":""}]
["Ref No.",null,"Title","Aim of Credit","Credit Criteria Summary","No. of Points Available","No. of Points Available","No. of Points Achieved","Points to be Confirmed","Comments","Comments"]
["EB-","Emi-1","Refrigerants","To encourage operational practices that minimise the environmental impacts of refrigeration equipment.","Minimum Requirements                                \nA gradual replacement policy shall be in place to replace all equipment with low Ozone Depletion Potential (ODP) refrigerant equipment."]
[null,null,null,null,"Refrigerants Impacts                   \n1 point is awarded where at least 80% of total refrigerant mass serving the building is low ozone depletion potential (ODP) refrigerants.\n\nAND\n\nThe remaining or all of the refrigerant mass is subject to leak auditing and leak testing or a continuous leak detection system during the performance period.\n\nAn additional 1 point is awarded where at least 80% of the total refrigerant mass serving the building is low global warming potential (GWP) refrigerants. \n\nWhere no refrigerants are used in the building, both points above are awarded.",2,{"$f":"IF(H6=\"na\",0,F6)","v":2}]
["EB-","Emi-2","Legionella","To recognise and encourage building management systems which effectively manage the risk of Legionnaires’ disease.","1 point is available as follows:\n\nRisk Management\n0.5 points are awarded where there is a process to manage overall risk presented by Legionnaires’ disease during the performance period. Furthermore, it should be demonstrated that such a risk management process is monitored and reviewed regularly as per SANS 893 Part 1.\n                                                                                                                                                                                     Control of Legionella in water systems                            \n0.5 points are awarded where there is an effective programme for treatment and control of Legionnaires’ disease in water systems during the performance period as per SANS 893 Part 2.",1,{"$f":"IF(H7=\"na\",0,F7)","v":1}]
[null,"Emi-3","Stormwater","To recognize site-related practices which limit the disruption of natural hydrology, minimize pollution and site deterioration.","1.5 points are awarded as follows:\n\nStormwater Run-off Management\n0.5 points are awarded if a Storm Water Run-Off Management plan is implemented that ensures that the site and hard surfaces are managed by infiltration, collecting and re-using storm water runoff of the precipitation falling on site (including the roof area) as well as filtering pollutants to reduce or eliminate contamination of ground water, streams and rivers. \n\n\n\nStormwater Quantity\n0.5 additional points are awarded where implementation of an annual inspection program of all storm water facilities to confirm continued performance, was done, where peak storm water flows are calculated and disclosed for the performance period and required maintenance that was assessed was implemented",1,{"$f":"IF(H8=\"na\",0,F8)","v":1}]
[null,null,null,null,"Stormwater Run-off Reduction\n0.5 additional points are awarded when the following strategies for 15% portion of the site hard surfaces are applied:\nReducing Paving Surfaces and increasing maintained landscaping or modify areas to open-grid pavement system (which is at least 50% pervious) OR if the existing site has hard surfaces (hardscapes) that account for less than 5% of the site (excluding building footprint).",0.5,{"$f":"IF(H9=\"na\",0,0.5)","v":0.5}]
[null,null,null,null,"Total Points:",{"$f":"SUM(F5:F9)","v":4.5},{"$f":"SUM(G5:G9)","v":4.5},{"$f":"SUM(H5:H9)","v":0},{"$f":"SUM(I5:I9)","v":0}]
[]
[]
[]
[{"$f":"Calculation!$C$86","v":"Applicants are to refer to the Green Star SA - Existing Building Performance PILOT Technical Manual for explicit credit criteria and documentation requirements."}]

{"sheet":"Innovation","index":17,"n_rows":12,"n_cols":10,"rows_kept":12,"cut":false,"hidden":false,"merged":[[4,5,6,5],[7,9,18,9],[3,0,3,1]]}
["Green Star SA - Existing Building Performance PILOT",null,null,null,null,null,null,null,"Category Score"]
["Innovation",null,null,null,"Category Summary:  ",{"$f":"F8","v":10},{"$f":"G8","v":0},{"$f":"H8","v":0},{"$f":"'Credit Summary'!I58","v":0}]
["Credit Summary for:",null,null,{"$f":"IF('Building Input'!$C$5=0,\"\",'Building Input'!$C$5)","v":""},null,null,{"$f":"IF(OR((J3=Calculation!$D$97),(J3=Calculation!$D$98),((G2+H2)>F2)),Calculation!$D$99,\"\")","v":""},null,null,{"$f":"T(K5:K17)","v":""}]
["Ref No.",null,"Title","Aim of Credit","Credit Criteria Summary","No. of Points Available","No. of Points Achieved","Points to be Confirmed","Comments"]
["EB-","Inn-1","Innovative Strategies & Technologies","To encourage and recognise pioneering initiatives, processes or strategies in sustainable building management and operations.","Up to two points are awarded for an innovation initiative where:\n\n• The initiative improving environmental performance is a technology or process that is considered a ‘first’ in South Africa or in the World; \nOR \n• The initiative substantially contributes to the broader market transformation towards sustainable development in South Africa or in the World.\n\nPoints are awarded as follows:\n• One point is awarded when either of the above is true for the South African market; \nOR\n• Two points are awarded when either of the above is true for the Global market\n\nUp to ten innovation initiatives can be awarded points under this credit, but no individual initiative can achieve more than two points in this credit. Qualifying initiatives may achieve additional points in other Innovation Credits, however the maximum points available for any one building assessment under Inn-1, Inn-2 and Inn-3 is ten (in total).\n",10,null,null,null,{"$f":"IF(OR(ISTEXT(G5)=TRUE,ISTEXT(H5)=TRUE),Calculation!$D$100,IF(G5+H5>10,Calculation!$D$97,\"\"))","v":""}]
["EB-","Inn-2","Exceeding Green Star SA Benchmarks","To encourage and recognise projects that achieve environmental benefits in excess of the current Green Star SA benchmarks.","Up to two points are awarded where there has been a substantial improvement on an existing Green Star SA credit, as follows:\n\n• One point for a solution that results in the elimination of the specific negative environmental impact of the project targeted by an existing credit; and\n• Two points for a solution that results in a substantial (e.g. 5% or greater above ‘neutral’) restorative environmental impact targeted by an existing credit.\n\nUp to ten innovation initiatives can be awarded points under this credit, but no individual initiative can achieve more than two points in this credit. Qualifying initiatives may achieve additional points in other Innovation Credits, however the maximum points available for any one building assessment under Inn-1, Inn-2 and Inn-3 is ten (in total).\n",null,null,null,null,{"$f":"IF(OR(ISTEXT(G6)=TRUE,ISTEXT(H6)=TRUE),Calculation!$D$100,IF(G6+H6>10,Calculation!$D$97,\"\"))","v":""}]
["EB-","Inn-3","Environmental Initiatives ","To encourage and recognise sustainable building initiatives, processes or strategies that are currently outside of the scope of this Green Star SA rating tool but which have a substantial or significant environmental benefit.","One point is awarded where:\n\n• An initiative implemented in the building viably addresses a valid environmental concern outside of the current scope of this Green Star SA tool.\n\nUp to ten innovation initiatives can be awarded points under this credit, but no individual initiative can achieve more than one point in this credit. Qualifying initiatives may achieve additional points in other Innovation Credits, however the maximum points available for any one building assessment under Inn-1, Inn-2 and Inn-3 is ten (in total).\n\n",null,null,null,null,{"$f":"IF(OR(ISTEXT(G7)=TRUE,ISTEXT(H7)=TRUE),Calculation!$D$100,IF(G7+H7>10,Calculation!$D$97,\"\"))","v":""}]
[null,null,null,null,"Total Points:",{"$f":"SUM(F5:F7)","v":10},{"$f":"SUM(G5:G7)","v":0},{"$f":"SUM(H5:H7)","v":0}]
[]
[]
[]
[{"$f":"Calculation!$C$86","v":"Applicants are to refer to the Green Star SA - Existing Building Performance PILOT Technical Manual for explicit credit criteria and documentation requirements."}]

{"sheet":"Credit Summary","index":18,"n_rows":72,"n_cols":10,"rows_kept":72,"cut":false,"hidden":false,"merged":[[64,0,74,6],[64,8,65,8],[64,9,65,9]]}
["Green Star SA - Existing Building Performance PILOT",null,null,null,null,null,null,null,"Credit Summary"]
[{"$f":"IF('Building Input'!$C$5=0,\"\",'Building Input'!$C$5)","v":""}]
["Category","Title","Credit No.","Points Available","Points Achieved",null,"Points to be Confirmed",null,"Percent of Available Points Achieved"]
[]
["Management"]
[null,{"$f":"Management!C5","v":"Certified Buildings"},"Man-1",{"$f":"Management!G5","v":1},{"$f":"Management!H5","v":0},null,{"$f":"Management!I5","v":0},{"$f":"Management!K5","v":0}]
[null,{"$f":"Management!C6","v":"Accredited Professional"},"Man-2",{"$f":"Management!G6","v":1},{"$f":"Management!H6","v":0},null,{"$f":"Management!I6","v":0},{"$f":"IF(OR(Management!K6=\"ERROR\", Management!#REF!=\"ERROR\"),\"ERROR\",\"\")","v":{"$error":"#REF!"}}]
[null,{"$f":"Management!C7","v":"Building Management"},"Man-3",{"$f":"SUM(Management!G7:G8)","v":5},{"$f":"SUM(Management!H7:H8)","v":0},null,{"$f":"SUM(Management!I7:I8)","v":0},{"$f":"Management!K7","v":0}]
[null,{"$f":"Management!C9","v":"Green Cleaning Performance"},"Man-4",{"$f":"SUM(Management!G9:G12)","v":3.5},{"$f":"SUM(Management!H9:H12)","v":0},null,{"$f":"Management!I9","v":0},{"$f":"Management!K9","v":0}]
[null,{"$f":"Management!C13","v":"Green Leasing"},"Man-5",{"$f":"Management!G13","v":6},{"$f":"Management!H13","v":0},null,{"$f":"Management!I13","v":0},{"$f":"Management!K13","v":0}]
[null,{"$f":"Management!C14","v":"Ongoing Monitoring and Metering"},"Man-6",{"$f":"Management!G14","v":2},{"$f":"Management!H14","v":0},null,{"$f":"Management!I14","v":0},{"$f":"Management!K14","v":0}]
[null,null,"TOTAL",{"$f":"Management!G15","v":18.5},{"$f":"Management!H15","v":0},null,{"$f":"Management!I15","v":0},null,{"$f":"IF(D12=0, 0, E12/D12)","v":0}]
[]
["Indoor Environment Quality"]
[null,{"$f":"IEQ!C5","v":"Indoor Air Quality"},"IEQ-1",{"$f":"IEQ!H5","v":3},{"$f":"IEQ!I5","v":0},null,{"$f":"IEQ!J5","v":0},{"$f":"IEQ!L5","v":0}]
[null,{"$f":"IEQ!C6","v":"Lighting Comfort"},"IEQ-2",{"$f":"IEQ!H6","v":2},{"$f":"IEQ!I6","v":0},null,{"$f":"IEQ!J6","v":0},{"$f":"IEQ!L6","v":0}]
[null,{"$f":"IEQ!C7","v":"Thermal Comfort"},"IEQ-3",{"$f":"IEQ!H7","v":3},{"$f":"IEQ!I7","v":0},null,{"$f":"IEQ!J7","v":0},{"$f":"IEQ!L7","v":0}]
[null,{"$f":"IEQ!C9","v":"Occupant Survey"},"IEQ-4",{"$f":"IEQ!H9","v":2},{"$f":"IEQ!I9","v":0},null,{"$f":"IEQ!J9","v":0},{"$f":"IEQ!L9","v":0}]
[null,{"$f":"IEQ!C10","v":"Acoustic Quality"},"IEQ-5",3,{"$f":"SUM(IEQ!I10:I14)","v":0},null,{"$f":"SUM(IEQ!J10:J14)","v":0},{"$f":"IEQ!L10","v":0}]
[null,{"$f":"IEQ!C15","v":"Daylight and Views"},"IEQ-6",{"$f":"IEQ!H15","v":2},{"$f":"IEQ!I15","v":0},null,{"$f":"IEQ!J15","v":0},{"$f":"IEQ!L15","v":0}]
[null,{"$f":"IEQ!C16","v":"Indoor Pollutant Management"},"IEQ-7",2,{"$f":"SUM(IEQ!I16:I17)","v":0},null,{"$f":"SUM(IEQ!J16:J17)","v":0},{"$f":"IEQ!L16","v":0}]
[null,null,"TOTAL",{"$f":"IEQ!G18","v":17},{"$f":"IEQ!I18","v":0},null,{"$f":"IEQ!J18","v":0},null,{"$f":"IF(D22=0, 0, E22/D22)","v":0}]
[]
["Energy"]
[null,{"$f":"Energy!C5","v":"Energy Consumption (GHGE)"},"Ene-1",{"$f":"Energy!G5+Energy!G6","v":25},{"$f":"(Energy!H6)","v":0},null,{"$f":"Energy!I5+Energy!I6","v":0},{"$f":"IF(OR(Energy!K5=\"ERROR\",Energy!K6=\"ERROR\"),\"ERROR\",\"\")","v":""}]
[null,{"$f":"Energy!C7","v":"Peak Electricity Demand"},"Ene-2",{"$f":"Energy!G7+Energy!G8","v":2},{"$f":"Energy!H8","v":0},null,{"$f":"Energy!I7+Energy!I8","v":0},{"$f":"IF(OR(Energy!K7=\"ERROR\",Energy!K8=\"ERROR\"),\"ERROR\",\"\")","v":""}]
[null,null,"TOTAL",{"$f":"Energy!G9","v":27},{"$f":"Energy!H9","v":0},null,{"$f":"Energy!I9","v":0},null,{"$f":"IF(D27=0, 0, E27/D27)","v":0}]
[]
["Transport"]
[null,{"$f":"Transport!C5","v":"Alternative Transportation"},"Tra-1",4,{"$f":"SUM(Transport!H5:H6)","v":0},null,{"$f":"SUM(Transport!I5:I6)","v":0},{"$f":"Transport!K5","v":0}]
[null,null,"TOTAL",{"$f":"Transport!G7","v":4},{"$f":"Transport!H7","v":0},null,{"$f":"Transport!I7","v":0},null,{"$f":"IF(D31=0, 0, E31/D31)","v":0}]
[]
["Water"]
[null,{"$f":"Water!C5","v":"Potable Water"},"Wat-2",{"$f":"Water!G5","v":12},{"$f":"Water!H5","v":0},null,{"$f":"Water!I5","v":0},{"$f":"Water!#REF!","v":{"$error":"#REF!"}}]
[null,null,"TOTAL",{"$f":"Water!G6","v":12},{"$f":"Water!H6","v":0},null,{"$f":"Water!I6","v":0},null,{"$f":"IF(D35=0, 0, E35/D35)","v":0}]
[]
["Materials"]
[null,{"$f":"Materials!C5","v":"Procurement and Purchasing"},"Mat-1",6,{"$f":"SUM(Materials!H5:H9)","v":0},null,{"$f":"SUM(Materials!I5:I9)","v":0},{"$f":"Materials!K5","v":0}]
[null,{"$f":"Materials!C10","v":"Solid Waste Management"},"Mat-2",6,{"$f":"SUM(Materials!H10:H13)","v":0},null,{"$f":"SUM(Materials!I10:I13)","v":0},{"$f":"Materials!K10","v":0}]
[null,null,"TOTAL",{"$f":"Materials!G14","v":12},{"$f":"Materials!H14","v":0},null,{"$f":"Materials!I14","v":0},null,{"$f":"IF(D40=0, 0, E40/D40)","v":0}]
[]
["Land Use & Ecology"]
[null,{"$f":"'Land Use & Ecology'!C5","v":"Ecological and Site Management"},"Eco-1",{"$f":"('Land Use & Ecology'!G5+'Land Use & Ecology'!G6)","v":2},{"$f":"SUM('Land Use & Ecology'!H5:H6)","v":0},null,{"$f":"'Land Use & Ecology'!I5","v":0},{"$f":"'Land Use & Ecology'!K5","v":0}]
[null,"Grounds-keeping Practices","Eco-2",3,{"$f":"SUM('Land Use & Ecology'!H7:H9)","v":0},null,{"$f":"'Land Use & Ecology'!I9","v":0},{"$f":"'Land Use & Ecology'!K9","v":0}]
[null,null,"TOTAL",{"$f":"'Land Use & Ecology'!G10","v":5},{"$f":"'Land Use & Ecology'!H10","v":0},null,{"$f":"'Land Use & Ecology'!I10","v":0},null,{"$f":"IF(D45=0, 0, E45/D45)","v":0}]
[]
["Emissions"]
[null,{"$f":"Emissions!C5","v":"Refrigerants"},"Emi-1",{"$f":"(Emissions!G6)","v":2},{"$f":"SUM(Emissions!H5:H6)","v":0},null,{"$f":"Emissions!I5+Emissions!I6","v":0},{"$f":"Emissions!K5","v":0}]
[null,{"$f":"Emissions!C7","v":"Legionella"},"Emi-2",{"$f":"(Emissions!G7)","v":1},{"$f":"Emissions!H7","v":0},null,{"$f":"Emissions!I7","v":0}]
[null,{"$f":"Emissions!C8","v":"Stormwater"},"Emi-3",1.5,{"$f":"SUM(Emissions!H8:H9)","v":0},null,{"$f":"SUM(Emissions!I8:I9)","v":0},{"$f":"IF(OR(Emissions!K8=\"ERROR\",Emissions!#REF!=\"ERROR\"),\"ERROR\",\"\")","v":{"$error":"#REF!"}}]
[null,null,"TOTAL",{"$f":"Emissions!G10","v":4.5},{"$f":"Emissions!H10","v":0},null,{"$f":"Emissions!I10","v":0},null,{"$f":"IF(D51=0, 0, E51/D51)","v":0}]
[null,"Total Points Available:",{"$f":"SUM(D12,D22,D27,D31,D35,D40,D45,D51)","v":100},null,null,null,null,null,"Score Achieved (Excl Inn):",{"$f":"C53/C52*100","v":0}]
[null,"Total Points Achieved:",{"$f":"SUM(E12,E22,E27,E31,E35,E40,E45,E51)","v":0}]
["Innovation"]
[null,{"$f":"Innovation!C5","v":"Innovative Strategies & Technologies"},{"$f":"Innovation!A5","v":"EB-"},{"$f":"Innovation!F5","v":10},{"$f":"Innovation!G5","v":0},null,{"$f":"Innovation!H5","v":0},{"$f":"Innovation!J5","v":""}]
[null,{"$f":"Innovation!C6","v":"Exceeding Green Star SA Benchmarks"},{"$f":"Innovation!A6","v":"EB-"},10,{"$f":"Innovation!G6","v":0},null,{"$f":"Innovation!H6","v":0},{"$f":"Innovation!J6","v":""}]
[null,{"$f":"Innovation!C7","v":"Environmental Initiatives "},{"$f":"Innovation!A7","v":"EB-"},10,{"$f":"Innovation!G7","v":0},null,{"$f":"Innovation!H7","v":0},{"$f":"Innovation!J7","v":""}]
[null,null,"TOTAL",{"$f":"Innovation!F8","v":10},{"$f":"Innovation!G8","v":0},{"$f":"Innovation!J7","v":""},{"$f":"Innovation!H8","v":0},null,{"$f":"E58","v":0}]
[]
[null,null,null,null,null,null,null,null,"Total Score Achieved:",{"$f":"J52+E58","v":0}]
[]
[]
[]
[]
["The GBCSA does not endorse any self-assessed rating achieved by the use of Green Star SA - Existing Building Performance PILOT. This service provides for independent third party review of points claimed to ensure all points can be demonstrated to be achieved by the provision of the necessary documentary evidence.  The use of Green Star SA - Existing Building Performance PILOT without formal certification by the GBCSA does not entitle the user or any other party to promote the Green Star SA rating achieved.",null,null,null,null,null,null,null,"Weighted Score","Rating"]
[]
[null,null,null,null,null,null,null,null,"10-19","One Star"]
[null,null,null,null,null,null,null,null,"20-29","Two Star"]
[null,null,null,null,null,null,null,null,"30-44","Three Star"]
[null,null,null,null,null,null,null,null,"45-59","Four Star"]
[null,null,null,null,null,null,null,null,"60-74","Five Star"]
[null,null,null,null,null,null,null,null,"75+","Six Star"]

{"sheet":"Graphical Summary","index":19,"n_rows":30,"n_cols":4,"rows_kept":30,"cut":false,"hidden":false,"merged":[[4,1,4,8]]}
[null,{"$f":"Calculation!N31","v":"Green Star SA - Existing Building Performance PILOT"}]
[]
[null,"Summary for:",null,{"$f":"IF('Building Input'!$C$5=0,\"\",'Building Input'!$C$5)","v":""}]
[]
[null,{"$f":"IF('Credit Summary'!J60<10,\"No official GBCSA rating possible. Minimum total score of 10 points required for certification\",\"The number of points inputted would equate to a \"&Calculation!C61&\" rating, once certified.\")","v":"No official GBCSA rating possible. Minimum total score of 10 points required for certification"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"Calculation!C55","v":""}]
[null,null,{"$f":"Calculation!B58","v":""}]

{"sheet":"Calculation","index":20,"n_rows":100,"n_cols":18,"rows_kept":100,"cut":false,"hidden":true,"merged":[[26,11,26,12],[30,10,30,11]]}
[null,"Green Star SA - Existing Building Performance PILOT",null,null,null,null,{"$f":"N25","v":"New Building"}]
[null,"Credit Summary for:",{"$f":"IF('Building Input'!$C$5=0,\"\",'Building Input'!$C$5)","v":""}]
[]
[]
[]
["Category Weightings"]
[null,null,"STATE BASED WEIGHTING FACTORS"]
[null,"Baseline","Gauteng","W Cape","E Cape","N Cape","KZN","Limpopo","N West","Free State","Mpumalanga","State list"]
["Management",0.09,0.09,0.09,0.09,0.09,0.09,0.09,0.09,0.09,0.09,1,"Gauteng"]
["Indoor Environment Quality",0.15,0.15,0.15,0.15,0.15,0.15,0.15,0.15,0.15,0.15,2,"W Cape"]
["Energy",0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,3,"E Cape"]
["Transport",0.09,0.09,0.09,0.09,0.09,0.09,0.09,0.09,0.09,0.09,4,"N Cape"]
["Water",0.14000000000000001,0.14000000000000001,0.14000000000000001,0.14000000000000001,0.14000000000000001,0.14000000000000001,0.14000000000000001,0.14000000000000001,0.14000000000000001,0.14000000000000001,5,"KZN"]
["Materials",0.13,0.13,0.13,0.13,0.13,0.13,0.13,0.13,0.13,0.13,6,"Limpopo"]
["Land use & Ecology",7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,7,"N West"]
["Emissions",0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,8,"Free State"]
[null,null,null,null,null,null,null,null,null,null,null,9,"Mpumalanga"]
[null,{"$f":"SUM(B9:B16)","v":0.99999999999999989},{"$f":"SUM(C9:C16)","v":0.99999999999999989},0.99999999999999989,0.99999999999999989,0.99999999999999989,0.99999999999999989,0.99999999999999989,0.99999999999999989,0.99999999999999989,{"$f":"SUM(K9:K16)","v":0.99999999999999989},"State selected = ",1,{"$f":"VLOOKUP(M18,L9:M17,2)","v":"Gauteng"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"note:"]
[null,null,null,null,null,null,null,null,null,null,null,"Type of assessment",null,null,"Green cells update with changes to Building Input Sheet"]
[null,null,null,null,null,null,null,null,null,null,null,1,"New Building"]
[null,null,null,null,null,null,null,null,null,null,null,2,"Refurbished Building"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Type selected = ",1,{"$f":"VLOOKUP(M25,L22:M23,2)","v":"New Building"}]
[null,"Mandatory requirements"]
[null,null,null,null,null,null,null,null,null,null,null,"Type of Rating",null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,1,null,"Green Star SA - Existing Building Performance PILOT"]
[null,null,null,null,null,null,null,null,null,null,null,2,"Green Star SA - Existing Building Performance PILOT","Green Star SA - Existing Building Performance PILOT"]
[null,"Yes","If there are mandatory requirements then this cell to the left",null,null,null,null,null,null,null,null,3,"Green Star SA - Existing Building Performance PILOT","Green Star SA - Existing Building Performance PILOT"]
[null,null,"needs to read yes ONLY if they have been met.",null,null,null,null,null,null,null,"Type Selected =",null,1,{"$f":"VLOOKUP(M31,L28:N30,3,)","v":"Green Star SA - Existing Building Performance PILOT"}]
["Points Calculation"]
[null,"Category","Weighting","Max Score per category","Total of credits available","Points achieved","% of points achieved","Weighted Score (achieved)","Credits tbc","% of credits tbc","Weighted Score \ntbc","Achieved + tbc credits","% of achieved + tbc","Potential weighted score","Error check"]
[null,"Management",1,{"$f":"E34*C34","v":18.5},{"$f":"Management!G15","v":18.5},{"$f":"Management!H15","v":0},{"$f":"IF(E34=0,0,F34/E34)","v":0},{"$f":"F34","v":0},{"$f":"Management!I15","v":0},{"$f":"I34/E34","v":0},{"$f":"I34","v":0},{"$f":"F34+I34","v":0},{"$f":"L34/E34","v":0},{"$f":"L34","v":0},{"$f":"Management!K15","v":0}]
[null,"Indoor Environment Quality",1,{"$f":"E35*C35","v":15.5},{"$f":"IEQ!H18","v":15.5},{"$f":"IEQ!I18","v":0},{"$f":"IF(E35=0,0,F35/E35)","v":0},{"$f":"F35","v":0},{"$f":"IEQ!J18","v":0},0,{"$f":"I35","v":0},0,0,{"$f":"L35","v":0},{"$f":"IEQ!L18","v":0}]
[null,"Energy",1,27,{"$f":"Energy!G9","v":27},{"$f":"Energy!H9","v":0},{"$f":"IF(E36=0,0,F36/E36)","v":0},0,{"$f":"Energy!I9","v":0},0,0,0,0,0,{"$f":"Energy!K9","v":0}]
[null,"Transport",1,4,{"$f":"Transport!G7","v":4},{"$f":"Transport!H7","v":0},{"$f":"IF(E37=0,0,F37/E37)","v":0},0,{"$f":"Transport!I7","v":0},0,0,0,0,0,{"$f":"Transport!K7","v":0}]
[null,"Water",1,12,{"$f":"Water!G6","v":12},{"$f":"Water!H6","v":0},{"$f":"IF(E38=0,0,F38/E38)","v":0},0,{"$f":"Water!I6","v":0},0,0,0,0,0,{"$f":"Water!K6","v":0}]
[null,"Materials",1,12,{"$f":"Materials!G14","v":12},{"$f":"Materials!H14","v":0},{"$f":"F39/E39","v":0},0,{"$f":"Materials!I14","v":0},0,0,0,0,0,{"$f":"Materials!K14","v":0}]
[null,"Land use & Ecology",1,5,{"$f":"'Land Use & Ecology'!G10","v":5},{"$f":"'Land Use & Ecology'!H10","v":0},{"$f":"IF(E40=0,0,F40/E40)","v":0},0,{"$f":"'Land Use & Ecology'!I10","v":0},{"$f":"IF(E40=0,0,I40/E40)","v":0},0,0,0,0,{"$f":"'Land Use & Ecology'!K10","v":0}]
[null,"Emissions",1,4.5,{"$f":"Emissions!G10","v":4.5},{"$f":"Emissions!H10","v":0},{"$f":"IF(E41=0,0,F41/E41)","v":0},0,{"$f":"Emissions!I10","v":0},0,0,0,0,0,{"$f":"Emissions!K10","v":0}]
[null,"Total",{"$f":"SUM(C34:C41)","v":8},{"$f":"SUM(D34:D41)","v":98.5},{"$f":"SUM(E34:E41)","v":98.5},{"$f":"SUM(F34:F41)","v":0},null,{"$f":"SUM(H34:H41)/E42*100","v":0},{"$f":"SUM(I34:I41)","v":0},null,{"$f":"SUM(K34:K41)/E42*100","v":0},{"$f":"SUM(L34:L41)","v":0},null,{"$f":"H42+K42","v":0}]
[null,"Innovation",null,null,{"$f":"Innovation!F8","v":10},{"$f":"Innovation!G8","v":0},null,{"$f":"F43","v":0},{"$f":"Innovation!H8","v":0},null,{"$f":"I43","v":0},{"$f":"F43+I43","v":0},null,{"$f":"L43","v":0},{"$f":"Innovation!J7","v":""}]
[null,"Overall Score",null,null,null,null,null,{"$f":"H42+H43","v":0},null,null,{"$f":"K42+K43","v":0},{"$f":"L42+L43","v":0},null,{"$f":"N42+N43","v":0},{"$f":"SUM(O34:O43)","v":0}]
[]
[null,null,"Scores required for GBRT Ratings",null,null,"data for graphical summary page",null,null,null,null,"data for graphical summary page"]
[null,null,0,"No Rating",null,"Category Score Data",null,null,null,null,null,"Rating Chart","Green Star","Achieved"]
[null,null,10,"One Star",null,null,null,null,null,null,null,"No Rating",{"$f":"C48-C47","v":10},{"$f":"MAX(0,MIN($M48,$H$44-$C47))","v":0}]
[null,null,20,"Two Star",null,null,null,"Available","Achieved","tbc",null,"One Star",10,0]
[null,null,30,"Three Star",null,null,{"$f":"B34","v":"Management"},1,{"$f":"G34","v":0},{"$f":"J34","v":0},null,"Two Star",10,0]
[null,null,45,"Four Star",null,null,"Indoor Environment Quality",1,0,0,null,"Three Star",15,0]
[null,null,60,"Five Star",null,null,"Energy",1,0,0,null,"Four Star",15,0]
[null,null,75,"Six Star",null,null,"Transport",1,0,0,null,"Five Star",15,0]
[null,"Warning text",null,null,null,null,"Water",1,0,0,null,"Six Stars",{"$f":"100-C53","v":25},0]
[null,"Error Message = ",{"$f":"IF(O44>0,\"ERROR - Check category sheets\",\"\")","v":""},null,null,null,"Materials",1,0,0]
[null,null,null,null,null,null,"Land use & Ecology",1,0,0,null,"Potential",null,{"$f":"$K$44","v":0}]
[null,"Mandatory Requirements Message",null,null,null,null,"Emissions",1,0,0]
[null,{"$f":"IF(B30=\"Yes\",\"\",\"Mandatory Requirements not met, Green Star SA Certified Rating not possible\")","v":""}]
[]
[null,"Rating"]
[null,"Achieved Rating",{"$f":"VLOOKUP($H$44,$C$47:$D$53,2)","v":"No Rating"},null,null,"data for graphical summary page",null,null,null,null,null,"data for graphical summary page"]
[null,"Potential Rating",{"$f":"VLOOKUP($N$44,$C$47:$D$53,2)","v":"No Rating"},null,null,"Credit Graph Data",null,null,null,null,null,"Weighted Score Graph Data"]
[]
[null,"Rating message",null,null,null,null,null,"Available","Achieved","tbc",null,null,null,"Available","Achieved","tbc"]
[null,{"$f":"IF((OR((#REF!=\"Not Achieved\"), ('Land Use & Ecology'!#REF!=\"Eco- Conditional Requirement NOT met\"))),\"Conditional requirements not met.\",IF(H44<C51,\"Minimal standards for Green Star SA certification not met.\",\n\"Once certified, this score would equate to a \" & C61 & \" rating.\"))","v":{"$error":"#REF!"}},null,null,null,null,{"$f":"B34","v":"Management"},{"$f":"E34","v":18.5},null,null,null,null,{"$f":"B34","v":"Management"}]
[null,null,null,null,null,null,null,null,{"$f":"F34","v":0},{"$f":"I34","v":0},null,null,null,{"$f":"D34","v":18.5},{"$f":"H34","v":0},{"$f":"K34","v":0}]
[null,null,null,null,null,null,"IEQ",{"$f":"E35","v":15.5},null,null,null,null,"IEQ"]
[null,null,null,null,null,null,null,null,{"$f":"F35","v":0},{"$f":"I35","v":0},null,null,null,{"$f":"D35","v":15.5},{"$f":"H35","v":0},{"$f":"K35","v":0}]
[null,null,null,null,null,null,{"$f":"B36","v":"Energy"},{"$f":"E36","v":27},null,null,null,null,{"$f":"B36","v":"Energy"}]
[null,"Conditional Requirements",null,null,null,null,null,null,{"$f":"F36","v":0},{"$f":"I36","v":0},null,null,null,{"$f":"D36","v":27},{"$f":"H36","v":0},{"$f":"K36","v":0}]
[null,"Ene",{"$f":"IF(#REF!=\"Not Achieved\",\"Not met\",\"Met\")","v":{"$error":"#REF!"}},null,null,null,{"$f":"B37","v":"Transport"},{"$f":"E37","v":4},null,null,null,null,{"$f":"B37","v":"Transport"}]
[null,"Eco",{"$f":"IF('Land Use & Ecology'!#REF!=\"Eco- Conditional Requirement met\",\"Met\",\"Not met\")","v":{"$error":"#REF!"}},null,null,null,null,null,{"$f":"F37","v":0},{"$f":"I37","v":0},null,null,null,{"$f":"D37","v":4},{"$f":"H37","v":0},{"$f":"K37","v":0}]
[null,null,null,null,null,null,{"$f":"B38","v":"Water"},{"$f":"E38","v":12},null,null,null,null,{"$f":"B38","v":"Water"}]
[null,null,null,null,null,null,null,null,{"$f":"F38","v":0},{"$f":"I38","v":0},null,null,null,{"$f":"D38","v":12},{"$f":"H38","v":0},{"$f":"K38","v":0}]
[null,null,null,null,null,null,{"$f":"B39","v":"Materials"},{"$f":"E39","v":12},null,null,null,null,{"$f":"B39","v":"Materials"}]
[null,null,null,null,null,null,null,null,{"$f":"F39","v":0},{"$f":"I39","v":0},null,null,null,{"$f":"D39","v":12},{"$f":"H39","v":0},{"$f":"K39","v":0}]
[null,null,null,null,null,null,{"$f":"B40","v":"Land use & Ecology"},{"$f":"E40","v":5},null,null,null,null,{"$f":"B40","v":"Land use & Ecology"}]
[null,null,null,null,null,null,null,null,{"$f":"F40","v":0},{"$f":"I40","v":0},null,null,null,{"$f":"D40","v":5},{"$f":"H40","v":0},{"$f":"K40","v":0}]
["Please Confirm",null,null,null,null,null,{"$f":"B41","v":"Emissions"},{"$f":"E41","v":4.5},null,null,null,null,{"$f":"B41","v":"Emissions"}]
["Yes",null,null,null,null,null,null,null,{"$f":"F41","v":0},{"$f":"I41","v":0},null,null,null,{"$f":"D41","v":4.5},{"$f":"H41","v":0},{"$f":"K41","v":0}]
["No"]
[]
[]
[]
[]
[null,1,"Applicants are to refer to the Green Star SA - Existing Building Performance PILOT Technical Manual for explicit credit criteria and documentation requirements."]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[]
[]
[]
[null,null,null,"ERROR MESSAGES"]
[null,null,1,"ERROR, sum of no. of points achieved and points to be confirmed exceeds the total no. of available points"]
[null,null,2,"ERROR, Value entered in 'No. of points achieved' must be a number or 'na'"]
[null,null,3,"[ERROR: Please check for error message in worksheet]"]
[null,null,4,"ERROR, text not valid!"]

{"sheet":"Rainfall data","index":21,"n_rows":36,"n_cols":16,"rows_kept":36,"cut":false,"hidden":true,"merged":[]}
[null,"Precipitation Average Monthly (mm)"]
[null,null,"January","February","March","April","May","June","July","August","September","October","November","December ","TOTAL","annual number of rain days"]
[1]
[2,"Beaufort West",35,30,30,20,11,8,9,14,12,21,27,19,{"$f":"SUM(C4:N4)","v":236},43]
[3,"Bela-Bela",120,84,74,37,7,6,2,5,16,58,101,124,634,74]
[4,"Belfast",170,101,83,53,16,7,5,9,33,93,156,152,878,83]
[5,"Bethal",146,75,61,48,14,7,6,13,28,78,129,106,711,90]
[6,"Bethlehem",96,77,94,58,9,12,7,27,35,83,96,86,680,98]
[7,"Bloemfontein",83,111,72,56,17,12,8,15,24,43,58,60,559,84]
[8,"Calvinia",14,12,26,27,22,34,23,24,13,11,13,9,228,50]
[9,"Cape Town",15,17,20,41,69,93,82,77,40,30,14,17,515,103]
[10,"De Aar",36,60,52,41,16,13,13,15,11,26,30,23,336,55]
[11,"Durban",134,113,120,73,59,28,39,62,73,98,108,102,1009,130]
[12,"East London",69,92,105,83,52,40,47,78,80,102,110,63,921,121]
[13,"George",63,59,69,71,53,45,43,68,60,64,61,59,715,121]
[14,"Johannesburg",125,90,91,54,13,9,4,6,27,72,117,105,713,99]
[15,"Kimberley",57,76,65,49,16,7,7,7,12,30,42,46,414,71]
[16,"Ladysmith",145,106,90,39,14,6,5,26,38,77,91,112,749,93]
[17,"Langebaan",8,4,11,24,40,41,47,45,24,12,12,10,278,76]
[18,"Musina",58,57,39,27,10,4,1,1,12,24,49,57,339,42]
[19,"Nelspruit",127,108,90,51,15,9,10,10,26,75,115,131,767,100]
[20,"Nmmabatho",117,83,74,57,14,5,3,5,13,37,64,67,539,72]
[21,"Pietermaritzburg",141,117,113,48,24,13,11,31,60,74,104,108,844,138]
[22,"Pilansberg",78,71,58,38,6,12,3,5,25,57,61,105,519,69]
[23,"Polokwane",82,60,52,33,11,5,3,6,17,43,85,81,478,65]
[24,"Port Elizabeth",36,40,54,58,59,62,47,64,62,59,49,34,{"$f":"SUM(C27:N27)","v":674},112]
[25,"Pretoria",136,75,82,51,13,7,3,6,22,71,98,110,{"$f":"SUM(C27:N27)","v":674},87]
[26,"Richards Bay",172,167,107,109,109,57,60,65,77,105,114,86,1228,113]
[27,"Skukuza",94,96,66,38,14,11,11,8,28,40,63,92,561,71]
[28,"Thohoyandou",74,108,75,47,15,17,14,11,39,93,76,128,697,94]
[29,"Tstsikama",77,70,81,80,86,75,78,111,66,83,78,60,945,91]
[30,"Umtata",87,89,83,58,18,11,18,15,35,73,75,88,650,113]
[31,"Upington",24,35,37,26,10,4,2,4,4,9,17,17,189,37]
[]
[null,null,"January","February","March","April","May","June","July","August","September","October","November","December ","total","annual number of rain days >1mm"]
[null,"Pretoria",{"$f":"VLOOKUP($B$36,$B$4:$N$33,2,FALSE)","v":136},{"$f":"VLOOKUP(B36,B4:N33,3,FALSE)","v":75},{"$f":"VLOOKUP($B$36,$B$4:$N$33,4,FALSE)","v":82},{"$f":"VLOOKUP($B$36,$B$4:$N$33,5,FALSE)","v":51},{"$f":"VLOOKUP($B$36,$B$4:$N$33,6,FALSE)","v":13},{"$f":"VLOOKUP($B$36,$B$4:$N$33,7,FALSE)","v":7},{"$f":"VLOOKUP($B$36,$B$4:$N$33,8,FALSE)","v":3},{"$f":"VLOOKUP($B$36,$B$4:$N$33,9,FALSE)","v":6},{"$f":"VLOOKUP($B$36,$B$4:$N$33,10,FALSE)","v":22},{"$f":"VLOOKUP($B$36,$B$4:$N$33,11,FALSE)","v":71},{"$f":"VLOOKUP($B$36,$B$4:$N$33,12,FALSE)","v":98},{"$f":"VLOOKUP($B$36,$B$4:$N$33,13,FALSE)","v":110},{"$f":"VLOOKUP($B$36,$B$4:$P$33,14,FALSE)","v":674},{"$f":"VLOOKUP($B$36,$B$4:$P$33,15,FALSE)","v":87}]