{"text_format":"1","workbook":"xlsx","n_sheets":16,"sheets":[" Green Star SA SEC PILOT","Introduction","Disclaimer","Change Log","R1 Pre-Submission Checklist","R2 Pre-Submission Checklist","Applicant Declaration","Building Input","SEC PILOT Credit Summary ","Labour Intensive Calculator","Skills Dev Calculator","Diversity Index Calculator","Rainfall data","Rainfall data_old","Calculation","Calculation1"],"not_rendered":{"charts":0,"images":9,"macros":1,"external_links":4,"defined_names":321,"comments":1,"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 SEC PILOT","index":0,"n_rows":20,"n_cols":2,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"The Green Star SA - Socio-Economic Catetory PILOT recognises the socio-economic initiatives of new buildings or base building refurbishments which are being rated under any of the existing Green Star SA tools - Office v1; Retail Center v1; Multi Unit Residential v1, Public & Education Building v1 and Interiors PILOT.  The Socio-Economic Category (SEC) PILOT is being launched as a separate optional category, with a minimum score requirement. After the PILOT phase, a decision will be made about fully integrating the SEC into Green Star SA tools, alongside the existing categories.  "]
[]
[null,"You are invited to use Green Star SA - Socio-Economic Category 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.  The GBCSA offers a formal certification process for ratings of Four Stars and above.  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 - Socio-Economic Category 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: 28 February 2014"]

{"sheet":"Introduction","index":1,"n_rows":88,"n_cols":2,"rows_kept":88,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Green Star SA - Socio-Economic Category PILOT"]
[]
[]
[]
[null,"Introduction to Green Star SA - Socio-Economic Category PILOT"]
[]
[]
[]
[null,"What is Green Star SA?"]
[]
[null,"What does Green Star SA - Socio-Economic Category PILOT do?"]
[]
[null,"Who can use Green Star SA - Socio-Economic Category PILOT?"]
[]
[null,"What do Green Star SA ratings mean?"]
[]
[null,"Minimum score for achieving Socio-Economic Category PILOT rating"]
[]
[null,"Opportunity for earning Innovation points"]
[]
[null,"Acknowledgements"]
[]
[]
[]
[null,{"$f":"$B$11","v":"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,{"$f":"$B$13","v":"What does Green Star SA - Socio-Economic Category PILOT do?"}]
[]
[null,"Green Star SA - Socio-Economic Category PILOT assesses the socio-economic initiatives of new or base building refurbishments which are being rated under the following Green Star SA tools - Office v1; Retail Center v1; Multi Unit Residential v1, Public & Education Building v1 and Interiors PILOT.  The Socio-Economic Category (SEC) PILOT is being launched as a separate optional category, with a minimum score requirement. After the PILOT phase, a decision will be made about fully integrating the SEC into Green Star SA tools, alongside the existing categories. The Green Star SA – Socio-Economic Category PILOT provides for both Green Star SA – Socio-Economic Category 'Design' and Green Star SA – Socio-Economic Category Building 'As Built' certification criteria. All credits are the same for both ratings, although the documentation requirements differ."]
[]
[]
[]
[]
[null,{"$f":"$B$15","v":"Who can use Green Star SA - Socio-Economic Category PILOT?"}]
[null,"The GBCSA encourages all interested parties to use Green Star SA - Socio-Economic Category PILOT to validate the socio-economic initiatives of new or base building refurbishments. The use of Green Star SA - Socio-Economic Category PILOT is encouraged on all such projects to assess and improve their socio-economic attributes, mainly in the design and construction phases.  "]
[]
[null,"The use of Green Star SA - Socio-Economic Category 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,{"$f":"$B$17","v":"What do Green Star SA ratings mean?"}]
[null,"Green Star SA rating tools use six stars to measure performance.  Projects that obtain a predicted rating of one, two or three stars are not eligible for formal certification.  Projects that obtain a predicted 4 Star rating or above are eligible to apply for formal certification, whereby a:"]
[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,"Minimum score for Socio-Economic Category PILOT rating"]
[]
[null,"The Socio-Economic Category PILOT is being launched as a separate optional category. Projects that achieve a rating for the SEC PILOT will get additional recognition for this, alongside their Green Star SA rating. On the Green Star SA certificate and on the plaque for the building, the words ‘Plus Socio-Economic Category PILOT’ will be added. It applies for both 'Design' and 'As Built' certification criteria. All credits are the same for both ratings, although the documentation requirements differ. The following minimum score requirement will apply for achieving the SEC PILOT rating: \n• For Office v1; Retail Center v1, Public & Education Buildings v1 and Interiors PILOT, out of a possible maximum of 13 points (for the 6 applicable credits in the SEC), achievement of at least 6 points is required to be awarded the Socio-. Economic Category PILOT rating along with the project’s Green Star SA rating. \n• For Multi-Unit Residential v1: There are 7 applicable credits in the SEC, which includes an additional ‘Mixed Income Housing’ credit which doesn’t apply to the other tools. Out of a possible maximum of 15 points, achievement of at least 7 points is required to be awarded the Socio-Economic Category PILOT rating along with the project’s Green Star SA rating.\n\nAfter the PILOT phase, a decision will be made about fully integrating the SEC into Green Star SA tools, alongside the existing categories. "]
[]
[]
[]
[null,"Opportunity for earning Innovation points "]
[]
[null,"Any points achieved above the  minimum requirement score are also eligible to count towards the achievement of 0.5 points in the Innovation Category of the applicable Green Star SA rating being sought (for the ‘main’ tool), up to a maximum number of Innovation points. The following scoring system applies for points achieved above the minimum requirement:\n\n• For Office v1; Retail Center v1, Public & Education Buildings v1 and Interiors PILOT, each additional SEC PILOT point achieved above the minimum of 6 will earn 0.5 Innovation points, up to a maximum of 3.5 Innovation points. Therefore:  \n       o achieving a total of 8 points will earn 1 Innovation point\n       o achieving a total of 10 points will earn 2 Innovation points\n       o achieving a total of 12 points will earn 3 Innovation points \n       o and points achieved between these also apply on an incremental basis e.g. achieving 9 points will earn 1.5 Innovation points, or achieving 11 points would earn 2.5 Innovation points etc.\n\n• For Multi-Unit Residential v1, each additional SEC PILOT point will earn 0.5 of an Innovation point, up to a maximum of 4 Innovation points. Therefore:  \n     o achieving 9 points will earn 1 Innovation point\n     o achieving 11 points will earn 2 Innovation points\n     o achieving 13 points will earn 3 Innovation points\n     o achieving 15 points will earn 4 full Innovation points\n     o and points achieved between these also apply on an incremental basis e.g. achieving 8 points will earn 0.5 Innovation points, or achieving 10 points would earn 1.5 Innovation points etc.\n\nThose projects which do not target a SEC PILOT rating, but achieve SEC PILOT credit points below the minimum requirement will be allowed to target Innovation points at the same rate of 0.5 Innovation points per SEC PILOT point earned. "]
[]
[null,"Again, the use of Green Star SA - Socio-Economic Category 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,{"$f":"$B$23","v":"Acknowledgements"}]
[null,"The Green Building Council of South Africa (GBCSA) would like to acknowledge all parties that worked on and supported the development of the Green Star SA – Socio-Economic Category PILOT. "]
[]
[null,"The GBCSA thanks all those individuals and organisations who provided feedback and expertise to the technical development of the Green Star SA – Socio-Economic Category PILOT. In particular, the GBCSA would like to thank all Technical Working Group and Peer Review members (listed in detail in the Technical Manual), as well as technical consultants Aurecon. The GBCSA also acknowledges the support of the Green Building Council of Australia."]
[]
[null,"Old Mutual Property is the primary sponsor of the Socio-Economic Category PILOT, and this financial support is acknowledged and appreciated by the GBCSA"]
[]
[null,"Green Star SA - Socio-Economic Category PILOT Sponsor:"]

{"sheet":"Disclaimer","index":2,"n_rows":29,"n_cols":2,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Green Star SA - Socio-Economic Category 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 – Socio-Economic Category PILOT” have been developed by the Green Building Council of South Africa (“GBCSA”).  Green Star SA – Socio-Economic Category PILOT is intended for use by project teams, contractors and other interested parties to validate the socio-economic initiatives of the design phase of new building construction or base building refurbishment; construction and procurement phase of a building; and/or to validate that socio-economic initiatives proposed in the design phase have been implemented by the building contractor.  As with all Green Star SA rating tools, Green Star SA - Socio-Economic Category PILOT may be subject to further development in the future."]
[]
[null,"Green Star SA and Green Star SA - Socio-Economic Category 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 - Socio-Economic Category 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 - Socio-Economic Category 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 - Socio-Economic Category 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 – Socio-Economic Category 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 - Socio-Economic Category 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 – Socio-Economic Category PILOT."]
[]
[null,"The GBCSA does not endorse or otherwise acknowledge the Green Star SA rating achieved by the use of Green Star SA – Socio-Economic Category PILOT. The GBCSA offers a formal certification process for ratings of Four Stars and above.  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 - Socio-Economic Category 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 - Socio-Economic Category PILOT to all  building projects is encouraged to assess and improve their socio-economic attributes.  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, and use of this service shall not constitute such a certification process."]
[]
[null,"You are only authorised to proceed to use Green Star SA and Green Star SA – Socio-Economic Category PILOT on this basis."]
[]
[null,"© 2013 Green Building Council of South Africa.  All rights reserved."]

{"sheet":"Change Log","index":3,"n_rows":18,"n_cols":3,"rows_kept":18,"cut":false,"hidden":false,"merged":[[15,1,15,2]]}
[]
[]
[null,"Green Star SA - Socio-Economic Category PILOT"]
[]
[]
[]
[null,"Change Log"]
[]
[null,"Green Star SA - Socio-Economic Category PILOT Release Date"]
[null,"2013-10-17"]
[]
[]
[]
[null,"Changes & Amendments"]
[]
[null,"The GBCSA  reserves the right to correct errors and omissions in the Green Star SA - Socio-Economic Category PILOT rating tool as necessary. The changes noted in this change log do not reflect Technical Clarifications or Credit Interpretation Request rulings. Project teams are advised to check the GBCSA website for the latest TC and CIR rulings. The changes noted in this change log also do not represent changes to points awarded for credits, or changes to credit critera. The changes noted below are those of minor nature related to the operation of the rating tool and associated calculators.  "]
[]
[null,"Reissue Date","Changes"]

{"sheet":"R1 Pre-Submission Checklist","index":4,"n_rows":48,"n_cols":7,"rows_kept":48,"cut":false,"hidden":false,"merged":[[7,1,7,4],[43,1,43,4],[45,1,45,4],[47,1,47,4],[54,1,54,4]]}
[]
[]
[null,"Green Star SA - Socio-Economic Category PILOT"]
[]
[]
[]
[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,null,"Please Confirm"]
[null,3,"No Credit Interpretation Requests or Technical Clarifications are outstanding","Please Confirm",null,null,"YES"]
[null,4,"The latest version of the GSSA rating tool has been used","Please Confirm",null,null,"NO"]
[]
[null," ","Submission content and presentation"]
[null,9,"All files are in PDF format only and unlocked, in one layer.","Please Confirm"]
[null,10,"Within the 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 "]
[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. ","Please Confirm"]
[null,15,"A completed Green Star SA Excel spreadsheet for the Socio-Economic Category 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/ Contract\", \"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.","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” (not applicable) 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 Socio-Economic Category, 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 Socio-Economic categoy and are in the correct order, following the order of the 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":5,"n_rows":46,"n_cols":7,"rows_kept":46,"cut":false,"hidden":false,"merged":[[7,1,7,4],[41,1,41,4],[43,1,43,4],[45,1,45,4]]}
[]
[]
[null,"Green Star SA - Socio-Economic Category PILOT"]
[]
[]
[]
[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,"Please Confirm"]
[null,null,null,null,null,null,"YES"]
[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 the 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 "]
[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. ","Please Confirm"]
[null,9,"A completed Green Star SA Excel spreadsheet for the Socio-Economic Category 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/Contract\", \"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. ","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” (not applicable) 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 Socio-Economic Category, 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 category and are in the correct order, following the order of the 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":6,"n_rows":11,"n_cols":2,"rows_kept":11,"cut":false,"hidden":false,"merged":[[10,1,22,1]]}
[]
[]
[null,"Green Star SA - Socio-Economic Category PILOT"]
[]
[]
[]
[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":7,"n_rows":131,"n_cols":6,"rows_kept":131,"cut":false,"hidden":false,"merged":[[5,1,7,1],[15,2,15,4],[16,2,16,4],[17,2,17,4],[18,2,18,4],[11,2,11,4],[12,2,12,4],[9,2,9,4],[4,2,4,4],[5,2,5,4],[6,2,6,4],[7,2,7,4],[8,2,8,4],[19,2,19,4],[20,2,20,4],[21,2,21,4],[22,2,22,4],[23,2,23,4],[24,2,24,4],[40,2,40,4],[42,1,42,4],[35,2,35,4],[36,2,36,4],[37,2,37,4],[38,2,38,4],[39,2,39,4],[31,2,31,4],[32,2,32,4],[25,2,25,4],[26,2,26,4],[27,2,27,4],[28,2,28,4],[29,2,29,4]]}
[null,"Green Star SA - Socio-Economic Category PILOT","Building Input Worksheet"]
[null,"New or Refurbished Building:"]
[null,"Type of Rating"]
[]
[null,"Name of Building:"]
[null,"Address of Building:",null,null,null,"New Building"]
[null,null,null,null,null,"Refurbishment"]
[null,null,null,null,null,1]
[null,"Postcode:"]
[null,"Province:",null,null,null,"Design Rating"]
[null,null,null,null,null,"As Built Rating"]
[null,"Applicant:",null,null,null,1]
[null,"Contact Person:"]
[]
[null,"Green Star SA Accredited Professional(s):"]
[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,"Other consultant:"]
[null,"Other consultant:"]
[null,"Building Surveyor:"]
[null,"Main Contractor:"]
[null,"Local Planning Authority:"]
[]
[null,"Type of Building"]
[null,"Total Building Gross Floor Area (GFA) in m² excluding car parks and external areas: (i)"]
[]
[]
[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 - Socio-Economic Category PILOT may predict a rating that differs from that achieved via formal Green Star SA certification."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Drop Down Lists"]
[]
[null,"Building Type List"]
[null,"A1: Casino"]
[null,"A1: Community/ day centre"]
[null,"A1: Restaurant/ public house"]
[null,"A2: Sports centre/ leisure centre"]
[null,"A2: Theatres/ cinemas/ and music halls"]
[null,"A3: Primary school"]
[null,"A3: Secondary school"]
[null,"A3: Higher Education"]
[null,"A4: Worship"]
[null,"C1: Convention Centre and Exhibition Hall"]
[null,"C2: Libraries/ museums/ and galleries"]
[null,"Airport terminals"]
[null,"Public transport terminals"]
[null,"Courts"]
[null,"Fire station/Police station "]
[]
[null,"Common Space Types"]
[null,"Cellular office"]
[null,"Changing facilities"]
[null,"Circulation area (corridors and stairways) - non public"]
[null,"Common room/staff room/lounge"]
[null,"Eating/drinking"]
[null,"Food preparation"]
[null,"Hall/lecture theatre/assembly"]
[null,"High density IT work space"]
[null,"IT equipment"]
[null,"Meeting room"]
[null,"Open plan office"]
[null,"Plant room"]
[null,"Public circulation"]
[null,"Reception"]
[null,"Storage"]
[null,"Tea Kitchen"]
[null,"Toilet"]
[null,"Internal Covered Vehicle Parking Area (B1, ground and above ground)"]
[null,"Sub-basement Vehicle Parking Area (B2 and below)"]
[null,"External Area (including external Car Parking)"]
[]
[null,"Uncommon Space Types"]
[null,"Baggage Reclaim"]
[null,"Cell (police/prison)"]
[null,"Check in"]
[null,"Classroom"]
[null,"Consulting room"]
[null,"Display"]
[null,"Dry sports hall"]
[null,"Fitness Studio"]
[null,"Fitness suite/gym"]
[null,"Ice rink"]
[null,"Laboratory"]
[null,"Laundry"]
[null,"Performance area (stage)"]
[null,"Sales area - chilled"]
[null,"Sales area - general"]
[null,"Security check"]
[null,"Storage area - chilled"]
[null,"Storage area - cold room (<0degC)"]
[null,"Swimming pool"]
[null,"Workshop - small scale"]
[]
[null,"Space Conditioning Type"]
[null,"Air Conditioned"]
[null,"Mechanically Ventilated"]
[null,"Naturally Ventilated"]
[]
[]
[null,"Calculations"]
[]
[null,"Breakdowb of areas supporting the primary function"]
[null,"Air conditioned space area",{"$f":"#REF!","v":{"$error":"#REF!"}},null,"m²"]
[null,"Mechanically ventilated space area",{"$f":"#REF!","v":{"$error":"#REF!"}},null,"m²"]
[null,"Naturally ventilated space area",{"$f":"#REF!","v":{"$error":"#REF!"}},null,"m²"]
[null,"Total",{"$f":"SUM(C128:C130)","v":{"$error":"#REF!"}},null,"m²"]

{"sheet":"SEC PILOT Credit Summary ","index":8,"n_rows":48,"n_cols":8,"rows_kept":48,"cut":false,"hidden":false,"merged":[[35,7,38,7],[36,3,38,3],[30,0,31,0],[30,1,31,1],[30,2,31,2],[30,4,31,4],[30,5,31,5],[35,0,38,0],[35,1,38,1],[35,2,38,2],[35,4,38,4],[35,5,38,5],[22,2,24,2],[22,4,24,4],[22,5,24,5],[35,6,38,6],[22,6,24,6],[0,6,2,7],[30,6,31,6],[22,7,24,7],[23,3,24,3],[8,0,8,3],[30,7,31,7],[25,0,28,0],[25,1,28,1],[25,2,28,2],[25,7,28,7],[26,3,28,3],[26,4,28,4],[26,5,28,5],[26,6,28,6],[22,0,24,0],[22,1,24,1]]}
["Green Star SA - Socio-Economic Category PILOT ",null,null,null,"COMMENTS:"]
["CREDIT SUMMARY"]
[]
["MINIMUM SCORE FOR SEC RATING:"]
["* 6 out of 13 possible points is minimum score for Socio-Economic Category PILOT rating for projects registering for: Office v1; Retail Center v1, Public & Education Building v1 and Interiors PILOT "]
["* 7 out of 15 possible points is minimum score for Socio-Economic Category PILOT rating for projects registering for: Multi-Unit Residential v1 "]
[]
[]
[0,null,null,null,"No. of Points Available","No. of Points to be Confirmed","No. of Points Achieved"]
[null,null,null,"Category Summary for Green Star SA - Office v1, Retail v1, Public & Education v1 and Interiors PILOT projects :",{"$f":"SUM(E23:E34)","v":13},{"$f":"SUM(F23:F34)","v":0},{"$f":"SUM(G23:G34)","v":0},{"$f":"IF(G10=6,\"Socio-Economic Category PILOT rating achieved\",IF(G10<=5,\"Inadequate points achieved for SEC rating, but Innovation points may be possible (see below)\",IF(G10>=7,\"Socio-Economic Category PILOT rating achieved, and eligible for earning additional Innovation points\")))","v":"Inadequate points achieved for SEC rating, but Innovation points may be possible (see below)"}]
[null,null,null,"Category Summary for Green Star SA - Multi Unit Residential projects:",{"$f":"SUM(E23:E39)","v":15},{"$f":"SUM(F23:F39)","v":0},0,{"$f":"IF(G11>=7,\"Socio-Economic Category PILOT rating achieved\",IF(G11<=6,\"Inadequate points achieved for SEC rating, but Innovation points may be possible(see below)\"))","v":"Inadequate points achieved for SEC rating, but Innovation points may be possible(see below)"}]
["ELIGIBIILTY FOR EARNING INNOVATION POINTS: "]
["Points for Innovation Category in the 'main' Green Star SA tool applicable can also be earned for scores above this minimum, and if insufficient points are achieved for a SEC rating."]
[" * For Office v1; Retail Center v1, Public & Education Buildings v1 and Interiors PILOT, each additional SEC PILOT point achieved above minimum of 6 will earn 0.5 Innovation points, up to maximum of 3.5 Innovation points. "]
[" * For Multi-Unit Residential v1, each additional SEC PILOT point will earn 0.5 of an Innovation point, up to a maximum of 4 Innovation points"]
["Projects which don’t target a SEC PILOT rating, but achieve points below minimum requirement will be allowed to target Innovation points at same rate of 0.5 Innovation points per SEC PILOT point earned.  "]
[]
[null,null,null,null,"Based on Points Achieved","Innovation Points Eligible For"]
[null,null,null,"For Green Star SA - Office v1, Retail v1, Public & Education v1 and Interiors PILOT projects :",{"$f":"G10","v":0},{"$f":"IF(G10=0,\"0\",IF(G10=1,\"0.5\",IF(G10=2,\"1\",IF(G10=3,\"1.5\",IF(G10=4,\"2\",IF(G10=5,\"2.5\",IF(G10=6,\"0\",IF(G10=7,\"0.5\",IF(G10=8,\"1\",IF(G10=9,\"1.5\",IF(G10=10,\"2\",IF(G10=11,\"2.5\",IF(G10=12,\"3\",IF(G10=13,\"3.5\"))))))))))))))","v":"0"}]
[null,null,null,"For Green Star SA - Multi Unit Residential projects:",{"$f":"G11","v":0},{"$f":"IF(G11=0,\"0\",IF(G11=1,\"0.5\",IF(G11=2,\"1\",IF(G11=3,\"1.5\",IF(G11=4,\"2\",IF(G11=5,\"2.5\",IF(G11=6,\"3\",IF(G11=7,\"0\",IF(G11=8,\"0.5\",IF(G11=9,\"1\",IF(G11=10,\"1.5\",IF(G11=11,\"2\",IF(G11=12,\"2.5\",IF(G11=13,\"3\",IF(G11=14,\"3.5\",IF(G11=15,\"4\"))))))))))))))))","v":"0"}]
["Credit Summary For:"]
["Ref No.","Title","Aim of Credit","Credit Criteria Summary","No. of Points Available","No. of Points to be Confirmed","No. of Points Achieved","Comments"]
["Sec-1","Employment creation","Employment creation through design decisions and construction practices which include facilities for micro enterprises, targeted employment and labour-intensive construction methodologies.","Up to two points are awarded as follows:\n\nPART 1\nOne point is awarded where Option A, B, C or D is achieved:\nOption A – Employment generation results\nThe total labour cost (including subcontractors) of the Contract Value of the building exceeds: \no    30% of the Contract Value for a building of one or two storeys.\no    25% of the Contract Value for a building that is three or more storeys high.\nOR\nOption B – Employment generation process\nEmployment is created through the implementation of labour-intensive construction methods which are identified on a project for specific activities (using a prescribed process). At least 75% of the identified activities are implemented, and these implemented activities collectively form at least 1.5% of the total labour cost of the project.\nOR\nOption C –Compliance with SANS 1914-5 standard for targeted labour participation. \nOR\nOption D – Targeted employment for priority disadvantaged groups\nAt least 10% or more of the total labour (including subcontractors) employed during construction are disadvantaged persons who are collectively from the target groups of youth, women or disabled persons, as measured by % of the labour cost of the Contract Value. ",2,0,0]
[null,null,null,"PART 2 - Facility provided for micro-enterprise employment opportunties\nOne point is awarded where: \nA minimum of 50m² is provided for a facility to be used for employment creation for individuals and micro enterprises e.g. food kiosks, market space for informal traders or shoe polishing services etc. The space for this facility can be provided in the finished building, or on the Project Site area or on the pavement/ public area adjoining the site."]
[]
["Sec-2","Economic opportunity","Growth and development of small, micro and medium-sized enterprises (SMMEs) through interventions in the design, construction and operational phases of a building, including procurement of goods and services and enterprise development support programmes","Four points in total are available as follows:\n\nPART 1\nTwo points will be awarded where:\nOption A - Enterprise development support for small and medium enterprises\nWhere the value of enterprise development expenditure on small and medium sized enterprises  by the project exceeds a certain percentage of the total Contract Value plus Design Team costs as follows:\n- 0.1% spent on supporting black women-owned enterprises\n- 0.15% spent on black-owned enterprises\n- 0.13% spent on any combination of the two categories above\n- 0.2% spent on any kind of small business (with any combination of ownership regardless of race and gender).\nWhere Contract Value exceeds R200 million, the enterprise development  must meet the requirements of the 2009 BBBEE Codes of Good Practice, but in a minimum of 2 rather than 3 areas of support. For Contract Value of less than R200 million, the type of enterprise development is at the discretion of the project (no compliance with any Codes is required).\nOption B - Compliance with CIDB standard for enterprise development. \nThe project complies with the CIDB 2013 'Standard for Indirect Targeting for Enterprise Development Through Construction Works Contracts', with a minimum of 5% of project value spent on joint-venture or sub-contracts where the developing contractors are also beneficiaries of enterprise development support from the main contractor.",2,0,0]
[null,null,null,"PART 2\nTwo points are available for adherence to any two of the following three interventions:\nOption A - Procurement from small, medium and micro sized enterprises (SMMEs) during construction as follows:\n- 25% of Contract Value for black-owned or black women-owned SMMEs\n- 30% of Contract Value for any SMME business.\nOR\nOption B - Procurement of local content during the construction phase, at a minimum of 70% of the Contract Value.\nOR\nOption C - Procurement of services during operation phase from SMMEs at a minimum of 50% of the Contract Value.",2,0,0]
[]
[]
["Sec-3","Skills development and training","Skills development, training and provision of practical work experience opportunities for people employed in the categories of unskilled, semi-skilled, skilled, supervisory, technical and Design Teams who are part of the design and construction project.","Up to three points are awarded for:\nOption A - Cost of skills development as % of total employment\nExpenditure on skills development exceeds the following % of employment payroll:\n- one point for exceeding 2%\n- two points for exceeding 2.5%\n- three points for exceeding 3%\nand the outcomes of the expenditure and skills development are demonstrated.\nOR \nThee points are awarded for:\nOption B - Compliance with CIDB standard for developing skills.\nProject complies with the CIDB 2013 'Standard for Developing Skills Through Infrastructure Contracts. For most public sector 'general building' projects this would mean a 'Contract Skills Development Goal' of:\n- Professional design services expressed in hours, not less than professional fees in millions of Rand multiplied by 150\n- Skills development expenditure in construction to value of 0.5% of contract works, measured according to a set of notional costs provided, and at least 67% for 'unemployed learners'.  ",3,0,0]
["Sec-4","Community benefit","Facilities provided for community or public benefit which respond to the socio-economic needs or assets of identified communities or stakeholders.","Up to 2 points are awarded as follows:\nOption A - Space for community/ public benefit facility within building of at least 50m² (of usable area)\nOR\nOption B - Space for community/ public benefit facility on site of at least 50m², as per Eco-8 in Public & Education Building Tool ",2,0,0]
[null,null,null,"One point is awarded for achieving one of the below options, and two points are awarded for achieving both options:\nOption C - Part-time use of facility for public benefit activities\nMulti-purpose facility inside building of at least 50 m² of the usable area for part time community benefit activities or public use\nOR\nOption D - Facility built off-site in an identified community\n Public benefit facility built in identified community of at least 50m² of the usable area (i.e not on the project site)\nTo achieve points for any of above options, community consultation and needs/ asset assessment is required, and where a project is a public or education building in a rural area then community consultation is required with regard to the building as a whole and not just for the community/ public benefit facility. "]
["Sec-5","Empowerment","Recognition for projects which are committed to and have made achievements in implementing the principles of Broad-Based Black Economic Empowerment (BBBEE).","One point is awarded where:\n95% of the project, measured as a % of Contract Value plus Design Team fees, is executed by companies which are Level 1, 2 or 3 BEE contributors or are Exempted Micro Enterprises (EMEs), as per the Construction Sector Charter BBBEE Codes of Good Practice (2009).",1,0,0]
["Sec-6","Safety and Health","Action taken to improve the primary health of construction workers, and to promote better safety practices and understanding in the construction industry and among Design Teams. ","One point is awarded where:\nA primary health programme for construction site employees has been implemented at a minimum value of R500 per unskilled/generall, semi-skilled or skilled employee involved in construction.\n\nIn order to achieve the above point, the following must be adhered to:\nCompliance with the 1993 Occupational Health & Safety Act, including a design-stage Hazard Identification Risk Assessment (HIRA) conducted by Design Team & Contractor and prevention measures taken, and compliance with the 2003 Construction Regulations.",1,0,0]
["For Green Star SA - Multi Unit Residential Projects only:"]
["Sec-7","Mixed income housing","Creation of mixed income housing options (Applicable to MURT only).","Two points are awarded as follows:\n\nPART 1\nOne point is awarded where:\nOption A: 10% of housing units provided at 25% of the value of an average unit in the development (sale or rental options).\nOR\nOption B:\no     10% of units provided at maximum of 75% of the average purchase or rental value.\no     10% of units provided at maximum of 60% of the average purchase or rental value\no     10% of units provided at maximum of 45% of the average purchase or rental value\nOR\nOption C: A variety of housing sizes and types are included in the project so that the total variety of housing within the project achieves at least 0.5 on the Simpson Diversity Index.",2,0,0]
[null,null,null,"PART 2\nOne point is awarded where: \n10% additional staff accommodation units or sleep-over facilities are provided for low-income staff who have to travel far or work outside ‘normal’ work hours. At least 16m2 of space allocation per 2-person unit should be allowed for."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null," "]

{"sheet":"Labour Intensive Calculator","index":9,"n_rows":37,"n_cols":12,"rows_kept":37,"cut":false,"hidden":false,"merged":[[3,3,3,5],[5,6,5,8]]}
[null,"Green Star SA - Socio-Economic Category PILOT"]
[null,"Calculator for Labour-Intensive Method",null,"For SEC 1, Part 1, Option B"]
[]
[null,null,null,"Points Achieved:",null,null,{"$f":"IF(AND(D34>=0.75, E35>=0.015),1,0)","v":{"$error":"#DIV/0!"}}]
[null,"Notes & Instructions:"]
[null,"1. User must enter values into white cells ONLY. Embedded formulas will make the calculations needed."]
[null,"2. In Column D select YES or NO, to indicate if the labour-intensive method listed is to be actually implemented"]
[null,"3. Refer to the Technical Manual for additional instructions in terms of definitions and compliance requirements."]
[]
[null,"A)","STRUCTURED SKILLS DEVELOPMENT AND TRAINING EXPENDITURE BY EACH PROJECT PLAYER: "]
[null,null,"See Additional Guidance section in Technical Manual for qualifying expenditure, and complaince parameters applicable.","(PLANNED OR ACHIEVED)"]
[null,null,"POSSIBLE LABOUR-INTENSIVE METHODS IDENTIFIED FOR THIS PROJECT (List here)","Methods to be or actually implemented (YES/ NO)","Additional labour % from each method above the 'conventional baseline' case"]
[null,1,null,"NO",null,null,null,null,null,null,null,"YES"]
[null,2,null,"NO",null,null,null,null,null,null,null,"NO"]
[null,3,null,"NO"]
[null,4,null,"NO"]
[null,5,null,"NO"]
[null,6,null,"NO"]
[null,7,null,"NO"]
[null,8,null,"NO"]
[null,9,null,"NO"]
[null,10,null,"NO"]
[null,11,null,"NO"]
[null,12,null,"NO"]
[null,13,null,"NO"]
[null,14,null,"NO"]
[null,15,null,"NO"]
[null,16,null,"NO"]
[null,17,null,"NO"]
[null,18,null,"NO"]
[null,19,null,"NO"]
[null,20,null,"NO"]
[null,null,"Total number of methods (to be) implemented:",{"$f":"COUNTIF(D13:D32,\"YES\")","v":0}]
[null,null,"Percentage of methods implemented:",{"$f":"D33/L34","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,{"$f":"COUNTIF(C13:C32,\"*\")","v":0}]
[null,null,"Total additional labour contribution generated by all implemented methods:",null,{"$f":"SUM(E13:E32)","v":0}]
[]
[null,"NOTE : If more than 20 methods are identified, contact greenstarsa@gbcsa.org.za and a version with a greater number of options will be provided"]

{"sheet":"Skills Dev Calculator","index":10,"n_rows":45,"n_cols":6,"rows_kept":45,"cut":false,"hidden":false,"merged":[[3,3,3,4],[5,5,5,6]]}
[null,"Green Star SA - Socio-Economic Category PILOT"]
[null,"Skills Development Expenditure Calculator ",null,"For SEC 3, Option A"]
[]
[null,null,null,"Points Achieved:",null,{"$f":"IF(AND(D45>0,D45<=0.02),0,IF(AND(D45>0.02,D45<=0.025),1,IF(AND(D45>0.025,D45<=0.03),2,IF(AND(D45>0.03),3))))","v":{"$error":"#DIV/0!"}}]
[null,"Notes & Instructions:"]
[null,"1. User must enter values into white cells ONLY. Embedded formulas will make the calculations needed."]
[null,"2. Refer to the Technical Manual for additional instructions in terms of definitions and compliance requirements."]
[]
[null,"A)","STRUCTURED SKILLS DEVELOPMENT AND TRAINING EXPENDITURE BY EACH PROJECT PLAYER: "]
[null,null,"See Additional Guidance section in Technical Manual for qualifying expenditure, and complaince parameters applicable.","(PLANNED / ACHIEVED)"]
[]
[null,null,"FOR THE DEVELOPER: "]
[null,null,"Total expenditure on skills development and training (in Rands)"]
[null,null,"Proportion spent on skills development and providing practical workplace learning opportunities (as a %)",null,"Minimum of 75% required for total expenditure to qualify"]
[null,null,"Proportion spent on time cost of mentorship (as a %)",null,"Maximum of 30% required for total expenditure to qualify"]
[null,null,"Total expenditure which qualifies (based on two above parameters) ",{"$f":"IF(AND(D14>=0.75,D15<=0.3),$D13,0)","v":0}]
[]
[null,null,"FOR THE DESIGN TEAM (COLLECTIVELY):"]
[null,null,"Total expenditure on skills development and training (in Rands)"]
[null,null,"Proportion spent on skills development and providing practical workplace learning opportunities (as a %)",null,"Minimum of 75% required for total expenditure to qualify"]
[null,null,"Proportion spent on time cost of mentorship (as a %)",null,"Maximum of 30% required for total expenditure to qualify"]
[null,null,"Total expenditure which qualifies (based on two above parameters) ",{"$f":"IF(AND(D20>=0.75,D21<=0.3),$D19,0)","v":0}]
[]
[null,null,"FOR THE MAIN CONSTRUCTION CONTRACTOR (AND INCL ANY SUB-CONTRACTORS STAFF DEVELOPED):"]
[null,null,"Total expenditure on skills development and training (in Rands)"]
[null,null,"Proportion spent on skills development and providing practical workplace learning opportunities (as a %)",null,"Minimum of 75% required for total expenditure to qualify"]
[null,null,"Proportion spent on time cost of mentorship (as a %)",null,"Maximum of 30% required for total expenditure to qualify"]
[null,null,"Total expenditure which qualifies (based on two above parameters) ",{"$f":"IF(AND(D26>=0.75,D27<=0.3),$D25,0)","v":0}]
[]
[null,null,"TOTAL SKILLS DEVELOPMENT & TRAINING EXPENDITURE BY ALL KEY PROJECT PLAYERS :",{"$f":"D28+D22+D16","v":0}]
[]
[null,"B)","EMPLOYMENT PAYROLL VALUES FROM EACH OF THE KEY PROJECT PLAYERS (in Rands):"]
[null,null,"See Additional Guidance section of the Technical Manual for what qualifies for as 'Employment Payroll' expenditure.","(PLANNED / ACHIEVED)"]
[]
[null,null,"Developer's employment payroll amount"]
[null,null,"Design Team's collective employment payroll amount"]
[null,null,"Main construction contractor & sub-contractors employment payroll amount"]
[null,null,"TOTAL PROJECT EMPLOYMENT PAYROLL AMOUNT ",{"$f":"SUM(D35:D37)","v":0}]
[]
[null,"C)","SKILLS DEVELOPMENT & TRAINING EXPENDITURE AS A % OF TOTAL PAYROLL VALUE "]
[]
[null,null,"Developer's expenditure as % of Developer's payroll",{"$f":"D16/D35","v":{"$error":"#DIV/0!"}}]
[null,null,"Design Team's (combined) expenditure as % of Design Team payroll",{"$f":"D22/D36","v":{"$error":"#DIV/0!"}}]
[null,null,"Construction contractor's expenditure as % of payroll for Contractor and Sub-contractors",{"$f":"D28/D37","v":{"$error":"#DIV/0!"}}]
[null,null,"COMBINED AVERAGE ACROSS ALL KEY PLAYERS",{"$f":"D30/D38","v":{"$error":"#DIV/0!"}}]

{"sheet":"Diversity Index Calculator","index":11,"n_rows":32,"n_cols":5,"rows_kept":32,"cut":false,"hidden":false,"merged":[[3,2,3,3],[5,4,5,6]]}
[null,"Green Star SA - Socio-Economic Category PILOT"]
[null,"Simpson Diversity Index Calculator ","For SEC 7, Option C"]
[]
[null,null,"Points Achieved:",null,{"$f":"IF((D25>=0.5),1,0)","v":{"$error":"#DIV/0!"}}]
[null,"Notes & Instructions:"]
[null,"1. User must enter values into white cells ONLY. Embedded formulas will make the calculations needed."]
[null,"2. Refer to the Technical Manual for additional instructions."]
[]
[null,"HOUSING CATEGORIES (WHERE APPLICABLE) ","NUMBER OF DWELLINGS IN EACH CATEGORY (PLANNED OR COMPLETED) ","SIMPSON DIVERSITY INDEX"]
[null,"Detached residential – large (greater than 300m2);",0,{"$f":"(C10/C23)*(C10/C23)","v":{"$error":"#DIV/0!"}}]
[null,"Detached residential – small (less than 300m2)",0,{"$f":"(C11/C23)*(C11/C23)","v":{"$error":"#DIV/0!"}}]
[null,"Townhouse (including duplexes) - large (greater than 150 m2)",null,{"$f":"(C12/C23)*(C12/C23)","v":{"$error":"#DIV/0!"}}]
[null,"Townhouse (including duplexes) - small (less than 150 m2",0,{"$f":"(C13/C23)*(C13/C23)","v":{"$error":"#DIV/0!"}}]
[null,"Apartment building – very large unit (greater than 230m2)",0,{"$f":"(C14/C23)*(C14/C23)","v":{"$error":"#DIV/0!"}}]
[null,"Apartment building - large unit (between 130m2and 230 m2 )",0,{"$f":"(C15/C23)*(C15/C23)","v":{"$error":"#DIV/0!"}}]
[null,"Apartment building – medium sized unit (between 70m2 and 130 m2)",0,{"$f":"(C16/C23)*(C16/C23)","v":{"$error":"#DIV/0!"}}]
[null,"Apartment building - small unit (between 50m2 and 70m2)",0,{"$f":"(C17/C23)*(C17/C23)","v":{"$error":"#DIV/0!"}}]
[null,"Apartment building - small unit (less than 50 m2)",0,{"$f":"(C18/C23)*(C18/C23)","v":{"$error":"#DIV/0!"}}]
[null,"Live/work large (greater than 70 m2)",0,{"$f":"(C19/C23)*(C19/C23)","v":{"$error":"#DIV/0!"}}]
[null,"Live/work small (less than 70 m2",0,{"$f":"(C20/C23)*(C20/C23)","v":{"$error":"#DIV/0!"}}]
[null,"Accessory Unit (e.g. granny flat) large (greater than 70 m2)",0,{"$f":"(C21/C23)*(C21/C23)","v":{"$error":"#DIV/0!"}}]
[null,"Accessory Unit (e.g. granny flat) small (less than 70 m2)",0,{"$f":"(C22/C23)*(C22/C23)","v":{"$error":"#DIV/0!"}}]
[null,"Total number of dwellings (planned or completed):",{"$f":"SUM(C10:C22)","v":0}]
[]
[null,"TOTAL SIMPSON DIVERSITY INDEX CALCULATION:",null,{"$f":"1-SUM(D10:D22)","v":{"$error":"#DIV/0!"}}]
[]
[null,"The aim is to create a sufficient variety of housing sizes and types in the project so that the total variety of housing achieves at least 0.5 on the Simpson Diversity Index using the housing categories above."]
[]
[null,"The Simpson Diversity Index score is calculated with the following equation, which is integrated into the above spreadsheet:"]
[null,"Score = 1- Σ (n/N)2 where"]
[null,"-  n = the total number of dwellings in a single category, and"]
[null,"-  N = the total number of dwellings in all categories."]

{"sheet":"Rainfall data","index":12,"n_rows":74,"n_cols":31,"rows_kept":74,"cut":false,"hidden":true,"merged":[[35,8,35,12]]}
[null,"Precipitation Average Monthly (mm)"]
[null,null,null,"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec","TOTAL","SANS 204 REGION","Diversity Factor for irrigation"]
[2,"<Please select>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"January","February","March","April","May","June","July","August","September","October","November","December ","Total"]
[3,"Beaufort West","Precip (mm)",35,30,30,20,11,8,9,14,12,21,27,19,236,{"$f":"R6","v":"Zone 1 - Cold Interior"},"Climatic Zone"]
[5,"Bela-Bela","Precip (mm)",120,84,74,37,7,6,2,5,16,58,101,124,634,{"$f":"R7","v":"Zone 2 - Temperate Interior"}]
[7,"Belfast","Precip (mm)",170,101,83,53,16,7,5,9,33,93,156,152,878,{"$f":"R6","v":"Zone 1 - Cold Interior"},"Zone 1 - Cold Interior",0.5,0.5,0.5,1,1,1,1,1,1,0.5,0.5,0.5,{"$f":"SUM(S6:AD6)","v":9}]
[9,"Bethal","Precip (mm)",146,75,61,48,14,7,6,13,28,78,129,106,711,{"$f":"R6","v":"Zone 1 - Cold Interior"},"Zone 2 - Temperate Interior",0.5,0.5,0.5,1,1,1,1,1,1,0.5,0.5,0.5,9]
[11,"Bethlehem","Precip (mm)",96,77,94,58,9,12,7,27,35,83,96,86,680,{"$f":"R6","v":"Zone 1 - Cold Interior"},"Zone 3 - Hot Interior",0.5,0.5,0.5,1,1,1,1,1,1,0.5,0.5,0.5,9]
[13,"Bloemfontein","Precip (mm)",83,111,72,56,17,12,8,15,24,43,58,60,559,{"$f":"R6","v":"Zone 1 - Cold Interior"},"Zone 4 - Temperate Coastal",1,1,1,1,0.5,0.5,0.5,0.5,1,1,1,1,10]
[null,"Calvinia","Precip (mm)",14,12,26,27,22,34,23,24,13,11,13,9,228,{"$f":"R7","v":"Zone 2 - Temperate Interior"},"Zone 5 - Sub-tropical Coastal",0.5,0.5,0.5,0.5,1,1,1,1,0.5,0.5,0.5,0.5,8]
[15,"Cape Town","Precip (mm)",15,17,20,41,69,93,82,77,40,30,14,17,515,{"$f":"R9","v":"Zone 4 - Temperate Coastal"},"Zone 6 - Arid Interior",1,0.5,1,1,1,1,1,1,1,1,1,1,11.5]
[null,"De Aar","Precip (mm)",36,60,52,41,16,13,13,15,11,26,30,23,336,{"$f":"R6","v":"Zone 1 - Cold Interior"}]
[17,"Durban","Precip (mm)",134,113,120,73,59,28,39,62,73,98,108,102,1009,{"$f":"R10","v":"Zone 5 - Sub-tropical Coastal"},"Evapo-Transpiration","(mm/m2/day)"]
[null,"East London","Precip (mm)",69,92,105,83,52,40,47,78,80,102,110,63,921,{"$f":"R10","v":"Zone 5 - Sub-tropical Coastal"}]
[19,"George","Precip (mm)",63,59,69,71,53,45,43,68,60,64,61,59,715,{"$f":"R9","v":"Zone 4 - Temperate Coastal"},"Zone 1 - Cold Interior",3.806225806451613,3.4066423357664224,2.9907407407407414,2.7884333333333342,2.4160429447852758,2.1003951367781148,2.260615835777124,2.8588554216867506,3.8035759493670875,3.9543870967741941,3.9602000000000004,4.2623870967741944]
[null,"Johannesburg","Precip (mm)",125,90,91,54,13,9,4,6,27,72,117,105,713,{"$f":"R6","v":"Zone 1 - Cold Interior"},"Zone 2 - Temperate Interior",3.7554435483870949,4.091733333333333,3.5426724137931034,2.7748095238095241,2.4348815165876765,2.116683673469387,2.2805069124423984,3.0173469387755087,3.9972131147540995,4.2165040650406516,4.2215481171548142,4.392608695652175]
[21,"Kimberley","Precip (mm)",57,76,65,49,16,7,7,7,12,30,42,46,414,{"$f":"R11","v":"Zone 6 - Arid Interior"},"Zone 3 - Hot Interior",4.3964896755162224,4.521136363636364,3.898299120234602,3.0510914454277285,2.7455795148247986,2.3705586592178762,2.6089218328840977,3.1344892473118255,3.8409565217391326,3.7052492668621682,3.8690273556231007,4.3316715542521989]
[null,"Ladysmith","Precip (mm)",145,106,90,39,14,6,5,26,38,77,91,112,749,{"$f":"R6","v":"Zone 1 - Cold Interior"},"Zone 4 - Temperate Coastal",4.9205555555555511,4.4256175298804763,3.6798207885304688,2.4538289962825286,1.5961151079136684,1.3571268656716418,1.5577978339350191,1.80426523297491,2.3880232558139531,3.3779032258064539,4.225882352941178,4.1666129032258041]
[23,"Langebaan","Precip (mm)",8,4,11,24,40,41,47,45,24,12,12,10,278,{"$f":"R9","v":"Zone 4 - Temperate Coastal"},"Zone 5 - Sub-tropical Coastal",3.4533870967741946,4.0634146341463397,3.4147096774193546,2.5414666666666674,2.1489473684210521,1.7232666666666656,1.9119354838709675,2.2841549295774657,2.7084166666666656,2.6895967741935483,3.0700833333333346,3.4445161290322583]
[null,"Musina","Precip (mm)",58,57,39,27,10,4,1,1,12,24,49,57,339,{"$f":"R8","v":"Zone 3 - Hot Interior"},"Zone 6 - Arid Interior",5.3647311827956985,5.0459643916913937,4.3616935483870964,3.2627118644067798,2.5418328840970359,2.1014722222222249,2.3212096774193558,3.1018548387096763,4.1831321839080493,5.0443695014662788,5.7252664576802532,6.3455718475073342]
[25,"Nelspruit","Precip (mm)",127,108,90,51,15,9,10,10,26,75,115,131,767,{"$f":"R8","v":"Zone 3 - Hot Interior"}]
[null,"Nmmabatho","Precip (mm)",117,83,74,57,14,5,3,5,13,37,64,67,539,{"$f":"R7","v":"Zone 2 - Temperate Interior"},"A-pan Evaporation data"]
[27,"Pietermaritzburg","Precip (mm)",141,117,113,48,24,13,11,31,60,74,104,108,844,{"$f":"R10","v":"Zone 5 - Sub-tropical Coastal"},"Cape Town",194,195,168,111,73,55,57,71,98,168,198,219,{"$f":"SUM(S23:AD23)","v":1607}]
[null,"Pilansberg","Precip (mm)",78,71,58,38,6,12,3,5,25,57,61,105,519,{"$f":"R7","v":"Zone 2 - Temperate Interior"}]
[29,"Polokwane","Precip (mm)",82,60,52,33,11,5,3,6,17,43,85,81,478,{"$f":"R7","v":"Zone 2 - Temperate Interior"}]
[null,"Port Elizabeth","Precip (mm)",36,40,54,58,59,62,47,64,62,59,49,34,624,{"$f":"R9","v":"Zone 4 - Temperate Coastal"}]
[31,"Pretoria","Precip (mm)",136,75,82,51,13,7,3,6,22,71,98,110,674,{"$f":"R7","v":"Zone 2 - Temperate Interior"}]
[null,"Richards Bay","Precip (mm)",172,167,107,109,109,57,60,65,77,105,114,86,1228,{"$f":"R10","v":"Zone 5 - Sub-tropical Coastal"}]
[33,"Skukuza","Precip (mm)",94,96,66,38,14,11,11,8,28,40,63,92,561,{"$f":"R8","v":"Zone 3 - Hot Interior"}]
[null,"Thohoyandou","Precip (mm)",74,108,75,47,15,17,14,11,39,93,76,128,697,{"$f":"R8","v":"Zone 3 - Hot Interior"}]
[35,"Tstsikama","Precip (mm)",77,70,81,80,86,75,78,111,66,83,78,60,945,{"$f":"R9","v":"Zone 4 - Temperate Coastal"}]
[null,"Umtata","Precip (mm)",87,89,83,58,18,11,18,15,35,73,75,88,650,{"$f":"R10","v":"Zone 5 - Sub-tropical Coastal"}]
[37,"Upington","Precip (mm)",24,35,37,26,10,4,2,4,4,9,17,17,189,{"$f":"R11","v":"Zone 6 - Arid Interior"}]
[]
[null,"For graph",null,2,3,4,5,6,7,8,9,10,11,12,13,14]
[null,"Select city",null,"Beaufort West",null,"Select SANS 204 Climatic Zone",null,null,"Zone 4 - Temperate Coastal"]
[null,"Rainfall",null,{"$f":"VLOOKUP($D$36,$B$4:$P$6,D35,FALSE)","v":"Precip (mm)"},35,30,30,20,11,8,9,14,12,21,27,{"$f":"SUM(D37:O37)","v":217}]
[null,"Diversity Factor",null,1,0.3,1,1,1,1,1,1,1,1,1,1,{"$f":"SUM(D38:O38)","v":11.3}]
[]
[null,null,null,125,90,91,54,13,9,4,6,27,72,117,105,713]
[null,null,null,0.3,0.3,0.3,1,1,1,1,1,1,0.3,0.3,0.3,7.8]
[]
[null,"Rainy days per month"]
[null,null,null,"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec","TOTAL"]
[null,{"$f":"B4","v":"Beaufort West"},"Number of rainy days",6,6,5,3,2,2,2,2,2,4,5,4,43]
[null,{"$f":"B5","v":"Bela-Bela"},"Number of rainy days",14,10,8,4,1,1,0,1,2,7,12,14,74]
[null,"Belfast","Number of rainy days",16,10,8,5,2,1,0,1,3,8,15,14,83]
[null,"Bethal","Number of rainy days",19,9,8,6,2,1,1,2,3,10,16,13,90]
[null,"Bethlehem","Number of rainy days",14,11,14,8,1,2,1,4,5,12,14,12,98]
[null,"Bloemfontein","Number of rainy days",13,16,11,8,3,2,1,2,4,6,9,9,84]
[null,"Calvinia","Number of rainy days",3,3,6,5,5,8,5,5,3,2,3,2,50]
[null,"Cape Town","Number of rainy days",3,4,4,8,14,19,16,15,8,6,3,3,103]
[null,"De Aar","Number of rainy days",6,10,8,6,3,2,2,3,2,4,5,4,55]
[null,"Durban","Number of rainy days",17,15,15,9,8,4,5,8,9,13,14,13,130]
[null,"East London","Number of rainy days",9,12,14,11,7,5,6,10,11,13,15,8,121]
[null,"George","Number of rainy days",10,10,12,12,9,8,7,12,10,11,10,10,121]
[null,"Johannesburg","Number of rainy days",17,13,13,7,2,1,1,1,4,10,15,15,99]
[null,"Kimberley","Number of rainy days",10,13,11,8,3,1,2,1,2,5,7,8,71]
[null,"Ladysmith","Number of rainy days",18,13,11,5,2,1,0,3,5,10,11,14,93]
[null,"Langebaan","Number of rainy days",2,1,3,7,11,11,13,12,7,3,3,3,76]
[null,"Musina","Number of rainy days",7,7,5,3,1,1,0,0,2,3,6,7,42]
[null,"Nelspruit","Number of rainy days",17,14,12,7,2,1,1,2,3,10,14,17,100]
[null,"Nmmabatho","Number of rainy days",16,11,10,7,2,1,0,1,2,5,8,9,72]
[null,"Pietermaritzburg","Number of rainy days",23,19,18,8,4,2,2,5,10,12,17,18,138]
[null,"Pilansberg","Number of rainy days",10,9,8,5,1,2,0,1,3,8,8,14,69]
[null,"Polokwane","Number of rainy days",11,8,7,4,2,1,0,1,2,6,12,11,65]
[null,"Port Elizabeth","Number of rainy days",7,7,10,10,11,11,8,12,11,10,9,6,112]
[null,"Pretoria","Number of rainy days",18,10,10,6,2,1,1,1,3,9,12,14,87]
[null,"Richards Bay","Number of rainy days",16,15,10,10,10,5,6,6,7,10,10,8,113]
[null,"Skukuza","Number of rainy days",12,12,8,5,2,1,1,1,4,5,8,12,71]
[null,"Thohoyandou","Number of rainy days",10,15,10,6,2,2,2,2,5,13,10,17,94]
[null,"Tstsikama","Number of rainy days",7,7,8,8,8,7,8,10,6,8,8,6,91]
[null,"Umtata","Number of rainy days",15,16,14,10,3,2,3,3,6,13,13,15,113]
[null,"Upington","Number of rainy days",5,7,7,5,2,1,0,1,1,2,3,3,37]

{"sheet":"Rainfall data_old","index":13,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Calculation","index":14,"n_rows":80,"n_cols":18,"rows_kept":80,"cut":false,"hidden":true,"merged":[[26,11,26,12],[30,10,30,11]]}
[null,"Green Star SA - Office v1",null,null,null,null,{"$f":"N25","v":"New Building"}]
[null,"Credit Summary for:",{"$f":"IF(#REF!=0,\"\",#REF!)","v":{"$error":"#REF!"}}]
[]
[]
[]
["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 - Office Design v1"]
[null,null,null,null,null,null,null,null,null,null,null,2,"Green Star SA - Office Design v1","Green Star SA - Office Design v1"]
[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 - Office As Built v1","Green Star SA - Office As Built v1"]
[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 - Office Design v1"}]
["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",{"$f":"VLOOKUP(B34,A9:K9,$M$18+2)","v":0.09},{"$f":"C34*100","v":9},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"F34/E34","v":{"$error":"#REF!"}},{"$f":"C34*G34*100","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"I34/E34","v":{"$error":"#REF!"}},{"$f":"C34*J34*100","v":{"$error":"#REF!"}},{"$f":"F34+I34","v":{"$error":"#REF!"}},{"$f":"L34/E34","v":{"$error":"#REF!"}},{"$f":"C34*M34*100","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"Indoor Environment Quality",0.15,15,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"Energy",0.25,25,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"Transport",0.09,9,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"Water",0.14000000000000001,14.000000000000002,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"Materials",0.13,13,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"Land use & Ecology",7.0000000000000007E-2,7.0000000000000009,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"Emissions",0.08,8,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"Total",{"$f":"SUM(C34:C41)","v":0.99999999999999989},{"$f":"SUM(D34:D41)","v":100},{"$f":"SUM(E34:E41)","v":{"$error":"#REF!"}},{"$f":"SUM(F34:F41)","v":{"$error":"#REF!"}},null,{"$f":"SUM(H34:H41)","v":{"$error":"#REF!"}},{"$f":"SUM(I34:I41)","v":{"$error":"#REF!"}},null,{"$f":"SUM(K34:K41)","v":{"$error":"#REF!"}},{"$f":"SUM(L34:L41)","v":{"$error":"#REF!"}},null,{"$f":"SUM(N34:N41)","v":{"$error":"#REF!"}}]
[null,"Innovation",null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"F43","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"I43","v":{"$error":"#REF!"}},{"$f":"F43+I43","v":{"$error":"#REF!"}},null,{"$f":"L43","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"Overall Score",null,null,null,null,null,{"$f":"H42+H43","v":{"$error":"#REF!"}},null,null,{"$f":"K42+K43","v":{"$error":"#REF!"}},{"$f":"L42+L43","v":{"$error":"#REF!"}},null,{"$f":"N42+N43","v":{"$error":"#REF!"}},{"$f":"SUM(O34:O43)","v":{"$error":"#REF!"}}]
[]
[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":{"$error":"#REF!"}}]
[null,null,20,"Two Star",null,null,null,"Available","Achieved","tbc",null,"One Star",10,{"$error":"#REF!"}]
[null,null,30,"Three Star",null,null,{"$f":"B34","v":"Management"},1,{"$f":"G34","v":{"$error":"#REF!"}},{"$f":"J34","v":{"$error":"#REF!"}},null,"Two Star",10,{"$error":"#REF!"}]
[null,null,45,"Four Star",null,null,"Indoor Environment Quality",1,{"$error":"#REF!"},{"$error":"#REF!"},null,"Three Star",15,{"$error":"#REF!"}]
[null,null,60,"Five Star",null,null,"Energy",1,{"$error":"#REF!"},{"$error":"#REF!"},null,"Four Star",15,{"$error":"#REF!"}]
[null,null,75,"Six Star",null,null,"Transport",1,{"$error":"#REF!"},{"$error":"#REF!"},null,"Five Star",15,{"$error":"#REF!"}]
[null,"Warning text",null,null,null,null,"Water",1,{"$error":"#REF!"},{"$error":"#REF!"},null,"Six Stars",{"$f":"100-C53","v":25},{"$error":"#REF!"}]
[null,"Error Message = ",{"$f":"IF(O44>0,\"ERROR - Check category sheets\",\"\")","v":{"$error":"#REF!"}},null,null,null,"Materials",1,{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,"Land use & Ecology",1,{"$error":"#REF!"},{"$error":"#REF!"},null,"Potential",null,{"$f":"$K$44","v":{"$error":"#REF!"}}]
[null,"Mandatory Requirements Message",null,null,null,null,"Emissions",1,{"$error":"#REF!"},{"$error":"#REF!"}]
[null,{"$f":"IF(B30=\"Yes\",\"\",\"Mandatory Requirements not met, Green Star Certified Rating not possible\")","v":""}]
[]
[null,"Rating"]
[null,"Achieved Rating",{"$f":"VLOOKUP($H$44,$C$47:$D$53,2)","v":{"$error":"#REF!"}},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":{"$error":"#REF!"}},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(ISBLANK(#REF!), ISBLANK(#REF!)),\"Conditional requirements not met.\",IF(H44<C51,\"Minimal standards for Green Star SA certification not met.\",\"Once certified, this score would equate to a \" & C61 & \" rating.\"))","v":{"$error":"#REF!"}},null,null,null,null,{"$f":"B34","v":"Management"},{"$f":"E34","v":{"$error":"#REF!"}},null,null,null,null,{"$f":"B34","v":"Management"}]
[null,null,null,null,null,null,null,null,{"$f":"F34","v":{"$error":"#REF!"}},{"$f":"I34","v":{"$error":"#REF!"}},null,null,null,{"$f":"D34","v":9},{"$f":"H34","v":{"$error":"#REF!"}},{"$f":"K34","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,"IEQ",{"$f":"E35","v":{"$error":"#REF!"}},null,null,null,null,"IEQ"]
[null,null,null,null,null,null,null,null,{"$f":"F35","v":{"$error":"#REF!"}},{"$f":"I35","v":{"$error":"#REF!"}},null,null,null,{"$f":"D35","v":15},{"$f":"H35","v":{"$error":"#REF!"}},{"$f":"K35","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,{"$f":"B36","v":"Energy"},{"$f":"E36","v":{"$error":"#REF!"}},null,null,null,null,{"$f":"B36","v":"Energy"}]
[null,"Conditional Requirements",null,null,null,null,null,null,{"$f":"F36","v":{"$error":"#REF!"}},{"$f":"I36","v":{"$error":"#REF!"}},null,null,null,{"$f":"D36","v":25},{"$f":"H36","v":{"$error":"#REF!"}},{"$f":"K36","v":{"$error":"#REF!"}}]
[null,"Ene",{"$f":"IF(ISBLANK(#REF!),\"Not met\",\"Met\")","v":"Met"},null,null,null,{"$f":"B37","v":"Transport"},{"$f":"E37","v":{"$error":"#REF!"}},null,null,null,null,{"$f":"B37","v":"Transport"}]
[null,"Eco",{"$f":"IF(ISBLANK(#REF!),\"Not met\",\"Met\")","v":"Met"},null,null,null,null,null,{"$f":"F37","v":{"$error":"#REF!"}},{"$f":"I37","v":{"$error":"#REF!"}},null,null,null,{"$f":"D37","v":9},{"$f":"H37","v":{"$error":"#REF!"}},{"$f":"K37","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,{"$f":"B38","v":"Water"},{"$f":"E38","v":{"$error":"#REF!"}},null,null,null,null,{"$f":"B38","v":"Water"}]
[null,null,null,null,null,null,null,null,{"$f":"F38","v":{"$error":"#REF!"}},{"$f":"I38","v":{"$error":"#REF!"}},null,null,null,{"$f":"D38","v":14.000000000000002},{"$f":"H38","v":{"$error":"#REF!"}},{"$f":"K38","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,{"$f":"B39","v":"Materials"},{"$f":"E39","v":{"$error":"#REF!"}},null,null,null,null,{"$f":"B39","v":"Materials"}]
[null,null,null,null,null,null,null,null,{"$f":"F39","v":{"$error":"#REF!"}},{"$f":"I39","v":{"$error":"#REF!"}},null,null,null,{"$f":"D39","v":13},{"$f":"H39","v":{"$error":"#REF!"}},{"$f":"K39","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,{"$f":"B40","v":"Land use & Ecology"},{"$f":"E40","v":{"$error":"#REF!"}},null,null,null,null,{"$f":"B40","v":"Land use & Ecology"}]
[null,null,null,null,null,null,null,null,{"$f":"F40","v":{"$error":"#REF!"}},{"$f":"I40","v":{"$error":"#REF!"}},null,null,null,{"$f":"D40","v":7.0000000000000009},{"$f":"H40","v":{"$error":"#REF!"}},{"$f":"K40","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,{"$f":"B41","v":"Emissions"},{"$f":"E41","v":{"$error":"#REF!"}},null,null,null,null,{"$f":"B41","v":"Emissions"}]
[null,null,null,null,null,null,null,null,{"$f":"F41","v":{"$error":"#REF!"}},{"$f":"I41","v":{"$error":"#REF!"}},null,null,null,{"$f":"D41","v":8},{"$f":"H41","v":{"$error":"#REF!"}},{"$f":"K41","v":{"$error":"#REF!"}}]

{"sheet":"Calculation1","index":15,"n_rows":99,"n_cols":18,"rows_kept":99,"cut":false,"hidden":true,"merged":[[26,11,26,12],[30,10,30,11]]}
[{"$f":"'Building Input'!B1","v":"Green Star SA - Socio-Economic Category PILOT"},null,null,null,null,null,{"$f":"N25","v":"New Building"}]
["Credit Summary for:",null,{"$f":"IF('Building Input'!C5=0,\"\",'Building Input'!C5)","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",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"B9","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},1,"Gauteng"]
["Indoor Environment Quality",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"B10","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},2,"W Cape"]
["Energy",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"B11","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"D11","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},3,"E Cape"]
["Transport",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"D12","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},4,"N Cape"]
["Water",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"D13","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},5,"KZN"]
["Materials",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"D14","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},6,"Limpopo"]
["Land use & Ecology",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"D15","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},7,"N West"]
["Emissions",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"D16","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},8,"Free State"]
[null,null,null,null,null,null,null,null,null,null,null,9,"Mpumalanga"]
[null,{"$f":"SUM(B9:B16)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"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 - Public Building Design"]
[null,null,null,null,null,null,null,null,null,null,null,2,"Green Star SA - Public Building Design","Green Star SA - Public Building Design"]
[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 - Public Building As Built","Green Star SA - Public Building As Built"]
[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 - Public Building Design"}]
["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",{"$f":"VLOOKUP(B34,A9:K9,$M$18+2)","v":{"$error":"#REF!"}},{"$f":"C34*100","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"F34/E34","v":{"$error":"#REF!"}},{"$f":"C34*G34*100","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"I34/E34","v":{"$error":"#REF!"}},{"$f":"C34*J34*100","v":{"$error":"#REF!"}},{"$f":"F34+I34","v":{"$error":"#REF!"}},{"$f":"L34/E34","v":{"$error":"#REF!"}},{"$f":"C34*M34*100","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"Indoor Environment Quality",{"$f":"VLOOKUP(B35,A10:K10,$M$18+2)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"Energy",{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"Transport",{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"Water",{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"Materials",{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"Land use & Ecology",{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"Emissions",{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"Total",{"$f":"SUM(C34:C41)","v":{"$error":"#REF!"}},{"$f":"SUM(D34:D41)","v":{"$error":"#REF!"}},{"$f":"SUM(E34:E41)","v":{"$error":"#REF!"}},{"$f":"SUM(F34:F41)","v":{"$error":"#REF!"}},null,{"$f":"SUM(H34:H41)","v":{"$error":"#REF!"}},{"$f":"SUM(I34:I41)","v":{"$error":"#REF!"}},null,{"$f":"SUM(K34:K41)","v":{"$error":"#REF!"}},{"$f":"SUM(L34:L41)","v":{"$error":"#REF!"}},null,{"$f":"SUM(N34:N41)","v":{"$error":"#REF!"}}]
[null,"Innovation",null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"F43","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"I43","v":{"$error":"#REF!"}},{"$f":"F43+I43","v":{"$error":"#REF!"}},null,{"$f":"L43","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"Overall Score",null,null,null,null,null,{"$f":"H42+H43","v":{"$error":"#REF!"}},null,null,{"$f":"K42+K43","v":{"$error":"#REF!"}},{"$f":"L42+L43","v":{"$error":"#REF!"}},null,{"$f":"N42+N43","v":{"$error":"#REF!"}},{"$f":"SUM(O34:O43)","v":{"$error":"#REF!"}}]
[]
[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":{"$error":"#REF!"}}]
[null,null,20,"Two Star",null,null,null,"Available","Achieved","tbc",null,"One Star",10,{"$error":"#REF!"}]
[null,null,30,"Three Star",null,null,{"$f":"B34","v":"Management"},1,{"$f":"G34","v":{"$error":"#REF!"}},{"$f":"J34","v":{"$error":"#REF!"}},null,"Two Star",10,{"$error":"#REF!"}]
[null,null,45,"Four Star",null,null,"Indoor Environment Quality",1,{"$error":"#REF!"},{"$error":"#REF!"},null,"Three Star",15,{"$error":"#REF!"}]
[null,null,60,"Five Star",null,null,"Energy",1,{"$error":"#REF!"},{"$error":"#REF!"},null,"Four Star",15,{"$error":"#REF!"}]
[null,null,75,"Six Star",null,null,"Transport",1,{"$error":"#REF!"},{"$error":"#REF!"},null,"Five Star",15,{"$error":"#REF!"}]
[null,"Warning text",null,null,null,null,"Water",1,{"$error":"#REF!"},{"$error":"#REF!"},null,"Six Stars",{"$f":"100-C53","v":25},{"$error":"#REF!"}]
[null,"Error Message = ",{"$f":"IF(O44>0,\"ERROR - Check category sheets\",\"\")","v":{"$error":"#REF!"}},null,null,null,"Materials",1,{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,"Land use & Ecology",1,{"$error":"#REF!"},{"$error":"#REF!"},null,"Potential",null,{"$f":"$K$44","v":{"$error":"#REF!"}}]
[null,"Mandatory Requirements Message",null,null,null,null,"Emissions",1,{"$error":"#REF!"},{"$error":"#REF!"}]
[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":{"$error":"#REF!"}},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":{"$error":"#REF!"}},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(ISBLANK(#REF!), ISBLANK(#REF!)),\"Conditional requirements not met.\",IF(H44<C51,\"Minimal standards for Green Star SA certification not met.\",\"Once certified, this score would equate to a \" & C61 & \" rating.\"))","v":{"$error":"#REF!"}},null,null,null,null,{"$f":"B34","v":"Management"},{"$f":"E34","v":{"$error":"#REF!"}},null,null,null,null,{"$f":"B34","v":"Management"}]
[null,null,null,null,null,null,null,null,{"$f":"F34","v":{"$error":"#REF!"}},{"$f":"I34","v":{"$error":"#REF!"}},null,null,null,{"$f":"D34","v":{"$error":"#REF!"}},{"$f":"H34","v":{"$error":"#REF!"}},{"$f":"K34","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,"IEQ",{"$f":"E35","v":{"$error":"#REF!"}},null,null,null,null,"IEQ"]
[null,null,null,null,null,null,null,null,{"$f":"F35","v":{"$error":"#REF!"}},{"$f":"I35","v":{"$error":"#REF!"}},null,null,null,{"$f":"D35","v":{"$error":"#REF!"}},{"$f":"H35","v":{"$error":"#REF!"}},{"$f":"K35","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,{"$f":"B36","v":"Energy"},{"$f":"E36","v":{"$error":"#REF!"}},null,null,null,null,{"$f":"B36","v":"Energy"}]
[null,"Conditional Requirements",null,null,null,null,null,null,{"$f":"F36","v":{"$error":"#REF!"}},{"$f":"I36","v":{"$error":"#REF!"}},null,null,null,{"$f":"D36","v":{"$error":"#REF!"}},{"$f":"H36","v":{"$error":"#REF!"}},{"$f":"K36","v":{"$error":"#REF!"}}]
[null,"Ene",{"$f":"IF(ISBLANK(#REF!),\"Not met\",\"Met\")","v":"Met"},null,null,null,{"$f":"B37","v":"Transport"},{"$f":"E37","v":{"$error":"#REF!"}},null,null,null,null,{"$f":"B37","v":"Transport"}]
[null,"Eco",{"$f":"IF(ISBLANK(#REF!),\"Not met\",\"Met\")","v":"Met"},null,null,null,null,null,{"$f":"F37","v":{"$error":"#REF!"}},{"$f":"I37","v":{"$error":"#REF!"}},null,null,null,{"$f":"D37","v":{"$error":"#REF!"}},{"$f":"H37","v":{"$error":"#REF!"}},{"$f":"K37","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,{"$f":"B38","v":"Water"},{"$f":"E38","v":{"$error":"#REF!"}},null,null,null,null,{"$f":"B38","v":"Water"}]
[null,null,null,null,null,null,null,null,{"$f":"F38","v":{"$error":"#REF!"}},{"$f":"I38","v":{"$error":"#REF!"}},null,null,null,{"$f":"D38","v":{"$error":"#REF!"}},{"$f":"H38","v":{"$error":"#REF!"}},{"$f":"K38","v":{"$error":"#REF!"}}]
[null,"Ene-0 Conditional Requirement",null,null,null,null,{"$f":"B39","v":"Materials"},{"$f":"E39","v":{"$error":"#REF!"}},null,null,null,null,{"$f":"B39","v":"Materials"}]
[null,"Yes- Compliance Route 1",null,null,null,null,null,null,{"$f":"F39","v":{"$error":"#REF!"}},{"$f":"I39","v":{"$error":"#REF!"}},null,null,null,{"$f":"D39","v":{"$error":"#REF!"}},{"$f":"H39","v":{"$error":"#REF!"}},{"$f":"K39","v":{"$error":"#REF!"}}]
[null,"Yes- Compliance Route 2",null,null,null,null,{"$f":"B40","v":"Land use & Ecology"},{"$f":"E40","v":{"$error":"#REF!"}},null,null,null,null,{"$f":"B40","v":"Land use & Ecology"}]
[null,"No- Not Met",null,null,null,null,null,null,{"$f":"F40","v":{"$error":"#REF!"}},{"$f":"I40","v":{"$error":"#REF!"}},null,null,null,{"$f":"D40","v":{"$error":"#REF!"}},{"$f":"H40","v":{"$error":"#REF!"}},{"$f":"K40","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,{"$f":"B41","v":"Emissions"},{"$f":"E41","v":{"$error":"#REF!"}},null,null,null,null,{"$f":"B41","v":"Emissions"}]
[null,null,null,null,null,null,null,null,{"$f":"F41","v":{"$error":"#REF!"}},{"$f":"I41","v":{"$error":"#REF!"}},null,null,null,{"$f":"D41","v":{"$error":"#REF!"}},{"$f":"H41","v":{"$error":"#REF!"}},{"$f":"K41","v":{"$error":"#REF!"}}]
[]
[]
[null,"ERROR MESSAGES"]
[1,"ERROR, sum of no. of points achieved and points to be confirmed exceeds the total no. of available points"]
[2,"ERROR, Value entered in 'No. of points achieved' must be a number or 'na'"]
[3,"[ERROR: Please check for error message in worksheet]"]
[4,"ERROR, text not valid!"]
[]
[null,"Reminder Note for TCs & CIRs"]
[]
[]
[]
[1,"Project Teams are to refer to the Green Star SA Public Building PILOT Technical Manual for explicit credit criteria and documentation requirements."]
[2,"The Green Star Technical Clarifications (TC) and Credit Interpretation Request (CIR) rulings provide an essential source of information to all"]
[3,"projects undertaking Green Star assessment. They are available on the GBCSA website http://www.gbcsa.org.za . Technical Clarifications"]
[4,"often represent the GBCSA answers to technical queries and complement Green Star SA Technical Manuals. They do not amend but clarify "]
[5,"Credit Criteria or Compliance Requirements. They are an extension of the Technical Manual; it is the responsibility of the project teams to stay "]
[6,"up-to-date with this section of the GBCSA website. The CIR rulings offer alternative compliance options whenever those have been deemed "]
[7,"equivalent in meeting the Aim of Credit."]