{"text_format":"3","workbook":"xlsx","n_sheets":6,"sheets":["EDGE Instructions & Disclaimer","EDGE Project Information","EDGE Client Information","EDGE Standard Details","EDGE Unit Details","EDGE Case Study Summary"],"not_rendered":{"images":5,"macros":1,"defined_names":8},"read":"whole","date_system":"1900"}

{"sheet":"EDGE Instructions & Disclaimer","index":0,"n_rows":23,"n_cols":11,"rows_kept":23,"merged":[[0,0,0,10],[2,1,6,9],[8,1,8,9],[9,1,12,9],[14,1,14,9],[15,1,15,5],[15,6,15,9],[16,1,21,9],[22,1,22,2],[22,3,22,5]]}
["EDGE \nProject information \nand \nCase Study information \nrequest disclaimer"]
[]
[null,"This documents is for the Project Team to confirm details regarding a project to allow the Green Building Council of South Africa (GBCSA) to undertake, on behalf of EDGE, the producing of Certificates and Case Studies in the instance of the project being approved and achieving EDGE Standard. The below instructions are to be followed and once this document is complete, the below disclaimer is to be signed.  Please return this document thereafter. "]
[]
[]
[]
[]
[]
[null,"INSTRUCTIONS"]
[null,"1. Complete all sheets contained in this document\n2. Complete all required cells - marked with an  * \n3. Grey cells are locked and not for inputs\n4. Please follow additional instuction found with in each sheet where applicable"]
[]
[]
[]
[]
[null,"DISCLAIMER"]
[null,"On behalf of the project owner stated above, I _________________________________ ",{"$nulls":8},"*"]
[null,"confirm that the information contained in this form is accurate and free from misrepresentation, to the best of my knowledge. I acknowledge that the Green Building Council of South Africa will use this information for any marketing related purposes and any changes to the infromation contained herein, will be made available to the Green Building Council of South Africa as soon as such information becomes available."]
[]
[]
[]
[]
[]
[null,"Todays date:",{"$nulls":4},"*"]

{"sheet":"EDGE Project Information","index":1,"n_rows":61,"n_cols":11,"rows_kept":61,"merged":[[0,1,2,10],[3,1,7,9],[9,1,9,10],[11,1,11,3],[11,4,11,8],[13,1,13,3],[14,1,14,3],[14,4,14,8],[16,1,16,3],[16,4,16,8],[18,1,18,3],[18,4,18,8],[20,1,20,3],[20,4,20,8],[22,1,22,3],[22,4,22,8],[24,1,24,3],[24,4,24,8],[27,1,27,3],[27,4,27,5],[29,1,30,3],[29,4,29,5],[29,7,29,8],[32,1,32,3],[32,4,32,8],[34,1,34,3],[34,4,34,8],[36,1,36,3],[36,4,36,8],[38,1,38,3],[38,4,38,8],[40,1,41,3],[40,4,40,8],[40,10,44,10],[42,1,43,3],[42,4,42,8],[44,1,45,3],[44,4,44,8],[48,1,48,10],[49,4,49,7],[50,1,50,2],[50,3,50,5],[50,6,50,8],[50,9,50,10],[51,1,51,2],[51,3,51,5],[51,6,51,8],[51,9,51,10],[52,1,52,2],[52,3,52,5],[52,6,52,8],[52,9,52,10],[53,1,53,2],[53,3,53,5],[53,6,53,8],[53,9,53,10],[54,1,54,2],[54,3,54,5],[54,6,54,8],[54,9,54,10],[55,1,55,2],[55,3,55,5],[55,6,55,8],[55,9,55,10],[56,1,56,2],[56,3,56,5],[58,1,58,10],[60,1,66,10]]}
[null,"EDGE \nProject Information \nConfirmation"]
[]
[]
[null,"\nIn order for the GBCSA to issue certificates with the correct information at the end of the assessment process, the Case Manager requires the project team to fill in the below information relating to the specific project. "]
[]
[]
[]
[]
[]
[null,"PROJECT INFORMATION REQUIRED"]
[]
[null,"Project Name:",{"$nulls":7},"*"]
[{"$nulls":4},"eg. Black River Park"]
[null,"Project Address"]
[null,"Address line 1:",{"$nulls":7},"*"]
[{"$nulls":4},"eg. 2 Fir St"]
[null,"Address line 2:",{"$nulls":7},"*"]
[{"$nulls":4},"eg. Observatory"]
[null,"City:",{"$nulls":7},"*"]
[{"$nulls":4},"eg. Cape Town"]
[null,"Province:",{"$nulls":7},"*"]
[{"$nulls":4},"eg. Western Cape"]
[null,"Postal Code:",{"$nulls":7},"*"]
[{"$nulls":4},"eg. 7925"]
[null,"Country:",{"$nulls":7},"*"]
[{"$nulls":4},"eg. South Africa"]
[]
[null,"Project certification stage:",null,null,"Preliminary",null,null,"Final",null,"*"]
[]
[null,"Are the units free standing or Sectional Title?",null,null,"Sectional Title",null,null,"Free Standing",null,"*"]
[]
[]
[null,"Name of Auditor/AP:",{"$nulls":7},"*"]
[]
[null,"Email:",{"$nulls":7},"*"]
[]
[null,"Work:",{"$nulls":7},"*"]
[]
[null,"Mobile:",{"$nulls":7},"*"]
[]
[null,"Total No. of Units:\n(entire development pursing certification)",{"$nulls":7},"*","These values should reflect what was registered with the GBCSA "]
[]
[null,"Total No. of Units:\n(for the phase being certified)",{"$nulls":7},"*"]
[]
[null,"Total m² being certified:\n(unit area x total no. of units - phase)",{"$nulls":7},"*"]
[]
[]
[]
[null,"PROJECT TEAM INFORMATION REQUIRED *"]
[{"$nulls":4},"complete where applicable"]
[null,"Client",{"$nulls":4},"Mechanical Engineer"]
[null,"Architect",{"$nulls":4},"Quantity Surveyor"]
[null,"Disability Specialist",{"$nulls":4},"Structural Engineer"]
[null,"Electrical Engineer",{"$nulls":4},"Wet Services"]
[null,"Fire Engineer",{"$nulls":4},"Main Contractor"]
[null,"Lift Engineer",{"$nulls":4},"Project Manager"]
[null,"Sustainability Specialist"]
[]
[null,"UNIT DETAILS"]
[]
[null,"Please complete the sheet \"EDGE Unit Details\" to inform the GBCSA which Typology each unit falls under. Every unit that is being considered for certification must be included. \nThe unit number is to be as per how the client would like to see the unit number reflect on the certificate (eg: Unit 1 or Unit A1)\nPlease ensure these details are correct, as the case manager will assume information is correct and issue certificates as per this information. Unit number, typology and erf numbers are mandatory for both at the Prelimary and Final stage of certification."]

{"sheet":"EDGE Client Information","index":2,"n_rows":47,"n_cols":10,"rows_kept":47,"merged":[[0,1,2,9],[3,1,7,9],[9,4,9,6],[11,1,11,3],[11,4,11,8],[12,1,12,3],[13,1,13,3],[13,4,13,8],[14,1,14,3],[15,1,15,3],[15,4,15,8],[17,1,17,3],[17,4,17,8],[19,1,19,3],[19,4,19,8],[21,1,21,3],[22,1,22,3],[22,4,22,8],[24,1,24,3],[24,4,24,8],[26,1,26,3],[26,4,26,8],[28,1,28,3],[28,4,28,8],[30,1,30,3],[30,4,30,8],[32,1,32,3],[32,4,32,8],[34,1,34,3],[35,1,35,3],[35,4,35,8],[37,1,37,3],[37,4,37,8],[39,1,39,3],[39,4,39,8],[41,1,41,3],[41,4,41,8],[43,1,43,3],[43,4,43,8],[45,1,45,3],[45,4,45,8],[47,1,47,3]]}
[null,"EDGE \nClient Information \nConfirmation"]
[]
[]
[null,"\nIn order for the GBCSA to issue certificates with the correct information at the end of the assessment process, the Case Manager requires the project team to fill in the below information relating to the specific project. "]
[]
[]
[]
[]
[]
[{"$nulls":4},"INFORMATION REQUIRED"]
[]
[null,"Client:",null,null,{"$f":"IF('EDGE Project Information'!D51=0,\"\",'EDGE Project Information'!D51)","v":""}]
[{"$nulls":4},"eg. Green Building Council of South Africa"]
[null,"Client Representitive:",{"$nulls":7},"*"]
[{"$nulls":4},"eg. Joe Bloggs"]
[null,"Email:",{"$nulls":7},"*"]
[]
[null,"Work:",{"$nulls":7},"*"]
[]
[null,"Mobile:",{"$nulls":7},"*"]
[]
[null,"Client Address"]
[null,"Address line 1:",{"$nulls":7},"*"]
[{"$nulls":4},"eg. 2 Fir St"]
[null,"Address line 2:",{"$nulls":7},"*"]
[{"$nulls":4},"eg. Observatory"]
[null,"City:",{"$nulls":7},"*"]
[{"$nulls":4},"eg. Cape Town"]
[null,"Province:",{"$nulls":7},"*"]
[{"$nulls":4},"eg. Western Cape"]
[null,"Postal Code:",{"$nulls":7},"*"]
[{"$nulls":4},"eg. 7925"]
[null,"Country:",{"$nulls":7},"*"]
[{"$nulls":4},"eg. South Africa"]
[null,"Client Postal Address"]
[null,"Address line 1:",{"$nulls":7},"*"]
[{"$nulls":4},"eg. 2 Fir St"]
[null,"Address line 2:",{"$nulls":7},"*"]
[{"$nulls":4},"eg. Observatory"]
[null,"City:",{"$nulls":7},"*"]
[{"$nulls":4},"eg. Cape Town"]
[null,"Province:",{"$nulls":7},"*"]
[{"$nulls":4},"eg. Western Cape"]
[null,"Postal Code:",{"$nulls":7},"*"]
[{"$nulls":4},"eg. 7925"]
[null,"Country:",{"$nulls":7},"*"]
[{"$nulls":4},"eg. South Africa"]

{"sheet":"EDGE Standard Details","index":3,"n_rows":22,"n_cols":9,"rows_kept":22,"merged":[[0,0,0,10],[2,1,5,9],[6,1,6,3],[6,4,6,5],[6,6,6,7],[6,8,6,9],[7,1,7,3],[7,4,7,5],[7,6,7,7],[7,8,7,9],[8,1,8,3],[8,4,8,5],[8,6,8,7],[8,8,8,9],[9,1,9,3],[9,4,9,5],[9,6,9,7],[9,8,9,9],[10,1,10,3],[10,4,10,5],[10,6,10,7],[10,8,10,9],[11,1,11,3],[11,4,11,5],[11,6,11,7],[11,8,11,9],[12,1,12,3],[12,4,12,5],[12,6,12,7],[12,8,12,9],[13,1,13,3],[13,4,13,5],[13,6,13,7],[13,8,13,9],[14,1,14,3],[14,4,14,5],[14,6,14,7],[14,8,14,9],[15,1,15,3],[15,4,15,5],[15,6,15,7],[15,8,15,9],[16,1,16,3],[16,4,16,5],[16,6,16,7],[16,8,16,9],[17,1,17,3],[17,4,17,5],[17,6,17,7],[17,8,17,9],[19,1,19,3],[19,4,19,5],[21,1,22,9]]}
["EDGE \nProject information \nand \nCase Study information \nrequest disclaimer"]
[]
[null,"Please enter the typology and the offical certified percentage of reduction achieved thereof as confirmed by the EDGE Tool Report. If typologies are rationalised, please indicate which typologies are included in such a rationalised grouping *"]
[]
[]
[]
[null,"TYPOLOGY",null,null,"ENGERY ",null,"WATER",null,"MATERIALS"]
[null,"eg. Typology A",null,null,{"v":0.25,"d":"25%"},null,{"v":0.32,"d":"32%"},null,{"v":0.27,"d":"27%"}]
{"$rows_empty":11}
[null,"EDGE Software version:",null,null,"v 2.1.5",null,"*"]
[]
[null,"Please attach the projects up to date Final Report as issued from the online software when returning this document to the GBCSA"]

{"sheet":"EDGE Unit Details","index":4,"n_rows":1503,"n_cols":13,"rows_kept":1503,"merged":[[0,1,0,3],[0,5,0,11],[1,5,14,11],[1,12,14,18]]}
[null,"EDGE \nUnit Details\nConfirmation",{"$nulls":3},"EDGE UNIT DETAILS INSTRUCTIONS:\nUnit number, typology and erf numbers are mandatory for both at the Prelimary and Final stage of certification.\n\nThe default way in which the GBCSA requires unit details for certification purposes is as per the following example:"]
[null,"Unit Number","Typology","Erf Number","*",{"$nulls":7},"TAKE NOTE OF THE FOLLOWING:\n1) If the projects units do not group as per the default way, the project team is at the liberty to list units in a way that works best for their specific project.\nIf more rows are needed, use the \"Add Extra Row\" button to add a new line below the existing table\n\n2) It is at the discrestion of the project team if Title deeds are to be provided and so is voluntary. If they are provided, they can be used on the certificates as additional iformation. If the project team does wish to provide seperate title deeds due to sectional title, add the \"Title Deed Number\" column by clicking the \" Add Title Deed Column\" above"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
{"$rows_empty":1495}
[null,"Add Row"]

{"sheet":"EDGE Case Study Summary","index":5,"n_rows":32,"n_cols":14,"rows_kept":32,"merged":[[0,0,0,13],[3,5,3,13],[4,8,4,11],[5,5,5,6],[5,7,5,9],[5,10,5,12],[6,5,6,6],[6,7,6,9],[6,10,6,12],[7,1,8,1],[7,5,7,6],[7,7,7,9],[7,10,7,12],[8,5,8,6],[8,7,8,9],[8,10,8,12],[9,5,9,6],[9,7,9,9],[9,10,9,12],[10,1,13,1],[10,5,10,6],[10,7,10,9],[10,10,10,12],[11,5,11,6],[11,7,11,9],[21,1,22,1],[31,1,32,3]]}
["EDGE \nCase Study Information\nConfirmation"]
[null,"EDGE CASE STUDY"]
[{"$nulls":5},"For GBCSA purpose only:"]
[null,"Step 1: Indicate the name of the project.",null,{"$f":"IF('EDGE Project Information'!E12=0,\"\",'EDGE Project Information'!E12)","v":""},null,"PROJECT TEAM INFORMATION REQUIRED *"]
[]
[{"$nulls":3},"GBCSA to complete this step",null,"Client",null,{"$f":"IF('EDGE Project Information'!D51=0,\"\",'EDGE Project Information'!D51)","v":""},null,null,"Mechanical Engineer",null,null,{"$f":"IF('EDGE Project Information'!J51=0,\"\",'EDGE Project Information'!J51)","v":""}]
[{"$nulls":5},"Architect",null,{"$f":"IF('EDGE Project Information'!D52=0,\"\",'EDGE Project Information'!D52)","v":""},null,null,"Quantity Surveyor",null,null,{"$f":"IF('EDGE Project Information'!J52=0,\"\",'EDGE Project Information'!J52)","v":""}]
[null,"Step 2: Attach the final downloadable pdf(s) for the project from the EDGE software.",{"$nulls":3},"Disability Specialist",null,{"$f":"IF('EDGE Project Information'!D53=0,\"\",'EDGE Project Information'!D53)","v":""},null,null,"Structural Engineer",null,null,{"$f":"IF('EDGE Project Information'!J53=0,\"\",'EDGE Project Information'!J53)","v":""}]
[{"$nulls":5},"Electrical Engineer",null,{"$f":"IF('EDGE Project Information'!D54=0,\"\",'EDGE Project Information'!D54)","v":""},null,null,"Wet Services",null,null,{"$f":"IF('EDGE Project Information'!J54=0,\"\",'EDGE Project Information'!J54)","v":""}]
[{"$nulls":5},"Fire Engineer",null,{"$f":"IF('EDGE Project Information'!D55=0,\"\",'EDGE Project Information'!D55)","v":""},null,null,"Main Contractor",null,null,{"$f":"IF('EDGE Project Information'!J55=0,\"\",'EDGE Project Information'!J55)","v":""}]
[null,"Step 3: Provide at least two hi-res images for the project (preferably at least one interior and one exterior image that are horizontal in shape and 1 MB or higher in size; models and drawings are fine but no construction images can be utilized).",{"$nulls":3},"Lift Engineer",null,{"$f":"IF('EDGE Project Information'!D56=0,\"\",'EDGE Project Information'!D56)","v":""},null,null,"Project Manager",null,null,{"$f":"IF('EDGE Project Information'!J56=0,\"\",'EDGE Project Information'!J56)","v":""}]
[{"$nulls":5},"Sustainability Specialist",null,{"$f":"IF('EDGE Project Information'!D57=0,\"\",'EDGE Project Information'!D57)","v":""}]
[]
[]
[null,"Step 4: Identify the name of the project architect, if possible.",null,{"$f":"IF('EDGE Project Information'!D52=0,\"\",'EDGE Project Information'!D52:F52)","v":""}]
[]
[null,"Step 5: Indicate your website (of the project developer).",null,null,"*"]
[]
[null,"Step 6: Provide interesting information about the your company's sustainability goals, intentions to use EDGE in the future, other sustainable practices that you plan to implement (such as waste management or positioning the building close to public transportation) and anything interesting about the project in order to tell its unique story. Note that there is a conscious decision not to indicate \"firsts,\" such as \"first hotel to be EDGE certified in China.\"",null,null,"*"]
[{"$nulls":3},"GBCSA to complete this step"]
[]
[null,"Step 7: Provide the total number of units and the total area thereof being certified under the EDGE Standard"]
[]
[null,"Development Total:",null,{"$f":"IF('EDGE Project Information'!E41=0,\"\",'EDGE Project Information'!E41)","v":""}]
[null,"Phase Total:",null,{"$f":"IF('EDGE Project Information'!E43=0,\"\",'EDGE Project Information'!E43)","v":""}]
[null,"Total m² :",null,{"$f":"IF('EDGE Project Information'!E45=0,\"\",'EDGE Project Information'!E45)","v":""}]
[]
[]
[null,"Today's Date:",null,{"$f":"IF('EDGE Instructions & Disclaimer'!D23:F23=0,\"\",'EDGE Instructions & Disclaimer'!D23:F23)","v":""}]
[]
[]
[null,"Thank you for taking the time to help us ensure that you receive recognition for your decision to build and brand green.\nPlease request an EDGE Project Study at https://edgebuildings.com/project-study/ . Social media coverage will be provided as soon as the case study is posted. A case study is promised to clients for each EDGE-certified project."]