{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["User Guide","Elements","Summary"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":0,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"User Guide","index":0,"n_rows":27,"n_cols":3,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[null,null,"36 Pallinghurst Road "]
[null,null,"Westcliff"]
[null,null,"Johannesburg"]
[null,null,2193]
[null,null,"0116468331"]
[null,null,"info@demisize.co.za"]
[]
[null,"Step 1: Enter the Percentage for Each Element"]
[null,"Within the calculator interface, locate the B-BBEE elements (e.g., Ownership, Management Control, Skills Development) and their corresponding \"Actual\" fields. Enter the percentage values for each element based on your B-BBEE compliance level."]
[]
[null,"Step 2: Calculate the Score"]
[null,"Once you have entered the percentages for all the relevant elements, the calculator will automatically calculate the score based on the provided data."]
[]
[null,"Step 3: View the Summary"]
[null,"To view your overall B-BBEE score, look for a \"Summary\" button or link on the calculator interface. Click on it to access the summary of your score."]
[]
[null,"Step 4: Interpret the Results"]
[null,"Review the summary to see your B-BBEE score, which reflects your level of compliance based on the percentages entered for each element. The score will give you an indication of your overall B-BBEE compliance."]
[]
[]
[null,"Note: Demisize's B-BBEE Calculator may have variations in its user interface and design. This guide focuses on clicking the \"Summary\" button or link to view your B-BBEE score after entering the percentages for each element. For more comprehensive guidance and any specific instructions, it's advisable to refer to the tool's documentation or user guide."]
[]
[null,"For more in-depth scorecard analysis and assistance, you can contact Demisize at info@demisize.co.za. Their team can provide you with further information and support to help you understand and navigate the complexities of B-BBEE compliance."]
[]
[null,"Disclaimer: This guide is a hypothetical scenario created by the AI language model and does not reflect the actual features or functionality of any existing B-BBEE calculator. Always refer to the specific tool's instructions for accurate usage guidance. Additionally, it's important to seek professional advice and consult with legal and business experts for comprehensive and accurate interpretations of B-BBEE policies and regulations."]
[]
[null,"It's important to note that the scorecard and any results generated using Demisize's B-BBEE Calculator remain the property of Demisize Pty Ltd. "]

{"sheet":"Elements","index":1,"n_rows":56,"n_cols":9,"rows_kept":56,"cut":false,"hidden":false,"merged":[[30,1,32,1],[39,1,44,1],[47,1,48,1],[2,1,3,1],[4,1,7,1],[13,1,16,1],[17,1,18,1],[19,1,20,1],[21,1,22,1],[23,1,24,1]]}
[null,"Ownership"]
[null,"Indicator","Description","Points","Compliance Target","Actual","Points","Comment","Notes"]
[null,"Voting rights","Black voting rights",4,0.25,0,{"$f":"IF(F3>=E3,D3,F3/E3*D3)","v":0},"+ 1 vote"]
[null,null,"Black women voting rights",2,0.1,0,0]
[null,"Economic interest","Black economic interest (share or earnings)",4,0.25,0,0]
[null,null,"Black women economic interest (share or earnings)",2,0.1,0,0]
[null,null,"Black designated groups",3,0.03,0,0]
[null,null,"New Entrants",2,0.02,0,0]
[null,"Realisation","Net Value",8,0.25,0,0]
[null,null,null,{"$f":"SUM(D3:D9)","v":25},null,{"$f":"B1","v":"Ownership"},{"$f":"SUM(G3:G9)","v":0}]
[]
[null,"Management Control"]
[null,"Indicator","Description","Points","Compliance Target","Actual","Points","Comment","Notes"]
[null,"Board participation","Black board members voting rights %",2,0.5,0,{"$f":"MIN(D14,F14/E14*D14)","v":0}]
[null,null,"Black woman board members voting rights %",1,0.25,0,0]
[null,null,"Black executive directors portion",2,0.5,0,0]
[null,null,"Black women exeutive directors portion",1,0.25,0,0]
[null,"Other executive management","Black executive management (not on the board) as % of all executive directors",2,0.6,0,0,"Alternative treatment if senior managment and other executives are not distinguished (points are 2 or 3)"]
[null,null,"Black women executive management (not on the board) as % of all executive directors",1,0.3,0,0,"(points are 1 or 2)"]
[null,"Senior management","Black employees in senior management as % of all senior management",2,0.6,0,0,"(points are 2 or 0)"]
[null,null,"Black women employees in senior management as % of all senior management",1,0.3,0,0,"(points are 2 or 0)"]
[null,"Middle management","Black employees in middle management as % of all middle management",2,0.75,0,0]
[null,null,"Black women employees in middle management as % of all middle management",1,0.38,0,0]
[null,"Junior management","Black employees in junior management as % of all junior management",1,0.88,0,0]
[null,null,"Black women employees in junior management as % of all junior management",1,0.44,0,0]
[null,"Employees with disabilities","Black employees with disabilities as % of all employees",2,0.02,0,0]
[null,null,null,{"$f":"SUM(D14:D26)","v":19},null,{"$f":"B12","v":"Management Control"},{"$f":"SUM(G14:G26)","v":0}]
[]
[null,"Skills Development"]
[null,"Indicator","Description","Points","Compliance Target","Actual","Points","Comment","Notes"]
[null,"Expenditure","Portion of Leviable Amount spent on skills development of blacks",6,3.5000000000000003E-2,0,{"$f":"MIN(D31,F31/E31*D31)","v":0},"of leviable amount"]
[null,null,"Expenditure on bursaries for Black students",4,2.5000000000000001E-2,0,0]
[null,null,"Portion of Leviable Amount spent on skills development of black employees with disabilities",4,3.0000000000000001E-3,0,0,"of leviable amount"]
[null,"Learnerships, apprenticeships & internships","Number of black people participating in Learnerships, Apprenticeships and internships as a percentage of total employees.",6,0.05,0,0]
[null,"Bonus Points","Number of Black people absorbed by the Measured Entity and Industry Entity at the end of the Learnership Programme",5,1,0,0]
[null,null,null,{"$f":"SUM(D31:D35)","v":25},null,{"$f":"B29","v":"Skills Development"},{"$f":"SUM(G31:G35)","v":0}]
[]
[null,"Enterprise and Supplier Development"]
[null,"Indicator","Description","Points","Compliance Target","Actual","Points","Comment","Notes"]
[null,"Preferential procurement","Procurement spend from all 'empowering suppliers' as % of total spend",5,0.8,0,{"$f":"MIN(D40,F40/E40*D40)","v":0},"of total spend"]
[null,null,"Procurement spend from 'empowering suppliers' that are QSEs as % of total spend",3,0.15,0,0,"of total spend"]
[null,null,"Procurement spend from all EMEs as % of total spend",4,0.15,0,0,"of total spend"]
[null,null,"Procurement spend from all 'empowering suppliers' that are at least 51% black owned, as % of total spend",11,0.5,0,0,"of total spend"]
[null,null,"Procurement spend from all 'empowering suppliers' that are at least 30% black women owned, as % of total spend",4,0.12,0,0,"of total spend"]
[null,null,"Bonus Points: Procurement spend from 'Designated Group' suppliers' that are at least 51% black owned, as % of total spend",2,0.02,0,0,"of total spend"]
[null,"Supplier Development","Annual value of Supplier Development Contributions as % of the target",10,0.02,0,0,"of NPAT"]
[null,"Enterprise Development","Annual value of Enterprise Development Contributions as % of the target",5,0.01,0,0,"of NPAT"]
[null,"Bonus Points","One or more ED beneficiaries becomes a supplier",1,null,null,0]
[null,null,"One or more jobs created by ED or SD",1,null,null,0]
[{"$nulls":5},{"$f":"B38","v":"Enterprise and Supplier Development"},{"$f":"SUM(G40:G49)","v":0}]
[null,null,null,{"$f":"SUM(D40:D49)","v":46}]
[null,"Socio-economic Development"]
[null,"Indicator","Description","Points","Compliance Target","Actual","Points","Comment","Notes"]
[null,"Contributions","Annual value of socio-economic development contributions, if 75% benefits blacks",5,0.01,0,{"$f":"MIN(D54,F54/E54*D54)","v":0},"of NPAT"]
[{"$nulls":5},{"$f":"B52","v":"Socio-economic Development"},{"$f":"G54","v":0}]
[null,null,null,5]

{"sheet":"Summary","index":2,"n_rows":12,"n_cols":11,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"BEE Score Estimate",{"$nulls":6},"BEE Status","Procurement Recognition Level","Points"]
[]
[null,{"$f":"Elements!F10","v":"Ownership"},{"$f":"Elements!G10","v":0},{"$nulls":5},"Level 1",1.35,"100+"]
[null,{"$f":"Elements!F27","v":"Management Control"},{"$f":"Elements!G27","v":0},{"$nulls":5},"Level 2",1.25,"95-100"]
[null,{"$f":"Elements!F36","v":"Skills Development"},{"$f":"Elements!G36","v":0},{"$nulls":5},"Level 3",1.1000000000000001,"90-95"]
[null,{"$f":"Elements!F50","v":"Enterprise and Supplier Development"},{"$f":"Elements!G50","v":0},{"$nulls":5},"Level 4",1,"80-90"]
[null,{"$f":"Elements!F55","v":"Socio-economic Development"},{"$f":"Elements!G55","v":0},{"$nulls":5},"Level 5",0.8,"75-80"]
[null,"Total Score",{"$f":"SUM(C4:C8)","v":0},{"$nulls":5},"Level 6",0.6,"70-75"]
[{"$nulls":8},"Level 7",0.5,"55-70"]
[{"$nulls":8},"Level 8",0.1,"40-55"]
[{"$nulls":8},"Non- Compliant",0,"<40"]