{"text_format":"1","workbook":"xlsx","n_sheets":24,"sheets":["Global Business Solutions","Sheet2","Scorecard","Targets & Inputs","Target - TMPS and NPAT","Ownership","NEI Calculator","Management","Employment Equity Worksheet","Employment Eq DATA INPUT","SD Table 1","SD Table 2","SD Table 3","SD Table 4","SD Table 5","SD Table 6","Skills Development","Procurement Recognition","Procurement Calculation","TMPS","ED & SD","Early Payments - ED","Early Payments - SD","Socio Economic Development"],"not_rendered":{"charts":0,"images":3,"macros":0,"external_links":0,"defined_names":113,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Global Business Solutions","index":0,"n_rows":46,"n_cols":4,"rows_kept":46,"cut":false,"hidden":false,"merged":[[24,1,24,4],[26,1,26,4],[28,1,28,4],[30,0,30,1],[31,0,31,1],[32,0,32,1],[33,0,33,1],[35,0,35,1],[36,0,36,1],[37,0,37,1],[45,0,45,1],[43,0,43,1],[44,0,44,1],[38,0,38,1],[39,0,39,1],[40,0,40,1],[41,0,41,1],[42,0,42,1]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Contact Details :"]
[]
["Richard Ryding"]
["Division Head"]
["richard@globalbusiness.co.za"]
[" +27 83 440 2130"]
[]
[]
["Johnny Goldberg",null,null," "]
["CEO"]
["johnny@iafrica.com"]
["+27 83 281 9571"]
[]
["DATA INPUT AREAS"]
[]
["COMPANY NAME","Test"]
[]
["FINANCIAL INFORMATION USED","2017-02-28"]
[]
["Input Information",null,"Budget","Actual"]
["Total Directors",null,null,{"$f":"Management!B53","v":0}]
["Total Executive Directors",null,null,{"$f":"Management!B56","v":0}]
["Total Other Executive Management",null,null,{"$f":"Management!B66","v":0}]
["Senior and Other Executive Management Combined (Y/N)",null,"N"]
["Senior Management",null,null,{"$f":"'Employment Equity Worksheet'!L35","v":0}]
["Middle Management",null,null,{"$f":"'Employment Equity Worksheet'!L36","v":0}]
["Junior Management",null,null,{"$f":"'Employment Equity Worksheet'!L37","v":0}]
["Payroll",null,null,{"$f":"'Skills Development'!B46","v":0}]
["Head Count",null,null,{"$f":"'Employment Equity Worksheet'!L41","v":0}]
["TMPS",null,{"$f":"+'Target - TMPS and NPAT'!D41","v":0},{"$f":"TMPS!D41","v":0}]
["Turnover",null,null,{"$f":"+C42","v":0}]
["NPAT",null,null,{"$f":"+C43","v":0}]
["Supplier Development - Early Settlement Benefit used (Y/N)",null,"N"]
["Enterprise Development - Early Settlement Benefit used (Y/N)",null,"N"]
["Stats Table used",null,"Table 3"]

{"sheet":"Sheet2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Scorecard","index":2,"n_rows":87,"n_cols":11,"rows_kept":87,"cut":false,"hidden":false,"merged":[[49,6,50,6],[4,0,4,1],[0,1,0,4],[2,1,2,4],[30,6,35,6],[37,6,47,6],[6,6,13,6],[47,0,47,1],[46,0,46,1],[34,0,34,1],[15,6,28,6],[76,0,77,0],[76,1,77,2],[76,3,77,3],[57,0,57,5],[58,0,58,5],[59,0,59,5],[60,0,60,5],[61,0,61,5],[62,0,62,5],[69,0,69,5],[73,0,73,5],[63,0,63,5],[65,0,65,5],[67,0,67,5],[71,0,71,5],[6,9,13,9],[15,9,28,9],[30,9,35,9],[37,9,47,9],[49,9,50,9],[6,10,13,10],[15,10,28,10],[30,10,35,10],[37,10,47,10],[49,10,50,10]]}
["COMPANY NAME",{"$f":"'Global Business Solutions'!B27","v":"Test"}]
[]
["FINANCIAL INFORMATION USED",{"$f":"'Global Business Solutions'!B29","v":"2017-02-28"}]
[]
["GENERIC SCORECARD",null,"Performance","Score","Compliance Target","Target Score","Element Score","Verification Agency","Diff Per Verification Agency","Total per Verification Agency","Difference"]
[]
["Ownership",null,null,null,null,null,{"$f":"SUM(D8:D14)","v":0},null,null,{"$f":"SUM(H8:H14)","v":0},{"$f":"+G7-J7","v":0}]
["Voting Rights",null,{"$f":"+Ownership!D39","v":0},{"$f":"+Ownership!E39","v":0},"25% + 1 ",4,null,0,{"$f":"H8-D8","v":0}]
["Women Voting Rights",null,{"$f":"+Ownership!D40","v":0},{"$f":"+Ownership!E40","v":0},0.1,2,null,0,{"$f":"H9-D9","v":0}]
["Economic Interest",null,{"$f":"+Ownership!D41","v":0},{"$f":"+Ownership!E41","v":0},0.25,4,null,0,0]
["Women Economic Interest",null,{"$f":"+Ownership!D42","v":0},{"$f":"+Ownership!E42","v":0},0.1,2,null,0,0]
["Broad Based",null,{"$f":"+Ownership!D43","v":0},{"$f":"+Ownership!E43","v":0},0.03,3,null,0,0]
["Net Value",null,null,{"$f":"+Ownership!E44","v":0},"Various",8,null,0,0]
["New Entrant",null,{"$f":"+Ownership!D45","v":0},{"$f":"+Ownership!E45","v":0},0.02,2,null,0,0]
[]
["Management",null,null,null,null,null,{"$f":"SUM(D17:D29)","v":0},null,null,{"$f":"SUM(H17:H29)","v":0},{"$f":"+G16-J16","v":0}]
["Board Representation - Black",null,{"$f":"Management!B37","v":0},{"$f":"IF(((C17/E17)*F17)>F17,F17,ROUND(((C17/E17)*F17),2))","v":0},0.5,2,null,0,{"$f":"H17-D17","v":0}]
["Board Representation - Black Females",null,{"$f":"Management!B38","v":0},{"$f":"IF(((C18/E18)*F18)>F18,F18,ROUND(((C18/E18)*F18),2))","v":0},0.25,1,null,0,0]
["Black Executive Directors",null,{"$f":"Management!B39","v":0},0,0.5,2,null,0,0]
["Black Executive Directors - Females",null,{"$f":"Management!B40","v":0},0,0.25,1,null,0,0]
["Black Executive Management",null,{"$f":"Management!B47","v":0},0,0.6,{"$f":"IF('Targets & Inputs'!C12=\"Y\",4,2)","v":2},null,0,0]
["Black Executive Management - Females",null,{"$f":"Management!B48","v":0},0,0.3,{"$f":"IF('Targets & Inputs'!C12=\"Y\",2,1)","v":1},null,0,0]
["Black senior management",null,{"$f":"IF(F23>0,D23/F23,0)","v":0},{"$f":"SUM('Employment Equity Worksheet'!B34:I34)","v":0},0.6,{"$f":"IF('Targets & Inputs'!C12=\"Y\",0,2)","v":2},null,0,0]
["Black senior management - Female",null,{"$f":"IF(F24>0,D24/F24,0)","v":0},{"$f":"SUM('Employment Equity Worksheet'!G41:I41)","v":0},0.3,{"$f":"IF('Targets & Inputs'!C12=\"Y\",0,1)","v":1},null,0,0]
["Black mid-management",null,{"$f":"+D25/F25","v":0},{"$f":"SUM('Employment Equity Worksheet'!B49:I49)","v":0},0.75,2,null,0,0]
["Black mid-management - Females",null,0,{"$f":"SUM('Employment Equity Worksheet'!G56:I56)","v":0},0.38,1,null,0,0]
["Black junior management",null,0,{"$f":"SUM('Employment Equity Worksheet'!B64:I64)","v":0},0.88,1,null,0,0]
["Black junior management - Females",null,0,{"$f":"SUM('Employment Equity Worksheet'!G71:I71)","v":0},0.44,1,null,0,0]
["Black disabled people",null,{"$f":"'Employment Equity Worksheet'!B115","v":0},0,0.02,2,null,0,0]
[]
["Skills Development",null,null,null,null,null,{"$f":"SUM(D32:D36)","v":0},null,null,{"$f":"SUM(H32:H36)","v":0},{"$f":"+G31-J31","v":0}]
["Score for Skills Spend",null,{"$f":"'Skills Development'!D54","v":0},{"$f":"+'Skills Development'!C54","v":0},0.06,8,null,0,{"$f":"H32-D32","v":0}]
["Score for Disabled Skills Spend",null,{"$f":"'Skills Development'!K51","v":0},{"$f":"'Skills Development'!K50","v":0},3.0000000000000001E-3,4,null,0,{"$f":"H33-D33","v":0}]
["Learners - Black ",null,{"$f":"'Skills Development'!D68","v":0},{"$f":"'Skills Development'!C68","v":0},2.5000000000000001E-2,4,null,0,{"$f":"H34-D34","v":0}]
["Black Unemployed people participating in training",null,{"$f":"'Skills Development'!J68","v":0},{"$f":"'Skills Development'!I68","v":0},2.5000000000000001E-2,4,null,0,{"$f":"H35-D35","v":0}]
["Bonus Point -  Absorption of Learners",null,{"$f":"'Skills Development'!B73","v":0},{"$f":"IF(((C36/E36)*F36)>F36,F36,((C36/E36)*F36))","v":0},1,5,null,0,{"$f":"H36-D36","v":0}]
[]
["Preferential Procurement",null,null,null,null,null,{"$f":"SUM(D39:D48)","v":0},null,null,{"$f":"SUM(H39:H48)","v":0},{"$f":"+G38-J38","v":0}]
["B-BBEE Procurement Spend from all Empowering Suppliers",null,{"$f":"'Procurement Calculation'!C17","v":0},{"$f":"'Procurement Calculation'!F17","v":0},0.8,5,null,0,{"$f":"H39-D39","v":0}]
["BEE Procurement Spend from QSE Empowering Suppliers",null,{"$f":"'Procurement Calculation'!C18","v":0},{"$f":"'Procurement Calculation'!F18","v":0},0.15,3,null,0,0]
["BEE Procurement Spend from all EME Suppliers",null,{"$f":"'Procurement Calculation'!C19","v":0},{"$f":"'Procurement Calculation'!F19","v":0},0.15,4,null,0,0]
["B-BBEE Procurement Spend from all Empowering Suppliers","Black  Owned >51%",{"$f":"'Procurement Calculation'!C20","v":0},{"$f":"'Procurement Calculation'!F20","v":0},0.4,9,null,0,0]
["B-BBEE Procurement Spend from all Empowering Suppliers",">=30% Black Women Owned",{"$f":"'Procurement Calculation'!C21","v":0},{"$f":"'Procurement Calculation'!F21","v":0},0.12,4,null,0,0]
["Bonus Point - BBBEE Spend from Designated Group Suppliers ",">=51% Black Owned",{"$f":"'Procurement Calculation'!C22","v":0},{"$f":"'Procurement Calculation'!F22","v":0},0.02,2,null,0,0]
["Annual Value of all Supplier Development Contributions",null,{"$f":"'Procurement Calculation'!C23","v":0},{"$f":"'Procurement Calculation'!F23","v":0},0.02,10,null,0,0]
["Annual Value of all Enterprise Development Contributions",null,{"$f":"'Procurement Calculation'!C24","v":0},{"$f":"'Procurement Calculation'!F24","v":0},0.01,5,null,0,0]
["Bonus Point - Graduation from Enterprise Development to Supplier Development",null,{"$f":"'Procurement Calculation'!C25","v":0},{"$f":"'Procurement Calculation'!F25+0","v":0},1,1,null,0,0]
["Bonus Point - creating one or more jobs through Enterprise Development or Supplier Development",null,{"$f":"'Procurement Calculation'!C26","v":0},{"$f":"'Procurement Calculation'!F26+0","v":0},1,1,null,0,0]
[]
["Socio Economic Development",null,null,null,null,null,{"$f":"D51","v":0},null,null,{"$f":"+H51","v":0},{"$f":"+G50-J50","v":0}]
["Spend on SED Initiatives",null,{"$f":"IFERROR('Socio Economic Development'!B32,0)","v":0},{"$f":"'Socio Economic Development'!B35","v":0},0.01,5,null,0,{"$f":"H51-D51","v":0}]
[]
["TOTAL",null,null,null,null,null,{"$f":"SUM(G7:G51)","v":0},{"$f":"SUM(H7:H51)","v":0},{"$f":"SUM(I7:I51)","v":0},{"$f":"SUM(J7:J51)","v":0},{"$f":"SUM(K7:K51)","v":0}]
["LEVEL",null,null,null,null,null,{"$f":"IF(G53>=100,1,IF(G53>=95,2,IF(G53>=90,3,IF(G53>=80,4,IF(G53>=75,5,IF(G53>=70,6,IF(G53>=55,7,IF(G53>=40,8,\"Non-Compliant\"))))))))","v":"Non-Compliant"},null,null,{"$f":"IF(J53>=100,1,IF(J53>=95,2,IF(J53>=90,3,IF(J53>=80,4,IF(J53>=75,5,IF(J53>=70,6,IF(J53>=55,7,IF(J53>=40,8,\"Non-Compliant\"))))))))","v":"Non-Compliant"}]
[]
["DISCOUNTING Level test"]
[]
["Priority Elements",null,null,null,null,null,"Submin Met",null,null,"Submin Met"]
["Ownership",null,null,null,null,null,{"$f":"IF(D13>=F13*0.4,\"Y\",\"N\")","v":"N"},null,null,{"$f":"IF(H13>=F13*0.4,\"Y\",\"N\")","v":"N"}]
["Skills Development",null,null,null,null,null,{"$f":"IF(SUM(D32:D35)>=SUM(F32:F35)*0.4,\"Y\",\"N\")","v":"N"},null,null,{"$f":"IF(SUM(H32:H35)>=SUM(F32:F35)*0.4,\"Y\",\"N\")","v":"N"}]
["Enterprise and Supplier Development",null,null,null,null,null,{"$f":"IF(OR(G62=\"N\",G63=\"N\",G64=\"N\"),\"N\",\"Y\")","v":"N"},null,null,{"$f":"IF(OR(J62=\"N\",J63=\"N\",J64=\"N\"),\"N\",\"Y\")","v":"N"}]
["Procurement",null,null,null,null,null,{"$f":"IF(SUM(D39:D43)>=SUM(F39:F43)*0.4,\"Y\",\"N\")","v":"N"},null,null,{"$f":"IF(SUM(H39:H43)>=SUM(F39:F43)*0.4,\"Y\",\"N\")","v":"N"}]
["Supplier Development",null,null,null,null,null,{"$f":"IF(D45>=F45*0.4,\"Y\",\"N\")","v":"N"},null,null,{"$f":"IF(H45>=F45*0.4,\"Y\",\"N\")","v":"N"}]
["Enterprise Development",null,null,null,null,null,{"$f":"IF(D46>=F46*0.4,\"Y\",\"N\")","v":"N"},null,null,{"$f":"IF(H46>=F46*0.4,\"Y\",\"N\")","v":"N"}]
[]
["Discount level",null,null,null,null,null,{"$f":"IF(OR(G59=\"N\",G60=\"N\",G61=\"N\"),\"Y\",\"N\")","v":"Y"},null,null,{"$f":"IF(OR(J59=\"N\",J60=\"N\",J61=\"N\"),\"Y\",\"N\")","v":"Y"}]
[]
["Level",null,null,null,null,null,{"$f":"+G54","v":"Non-Compliant"},null,null,{"$f":"+J54","v":"Non-Compliant"}]
[]
["Less: Discounted Level",null,null,null,null,null,{"$f":"IF(G66=\"Y\",1,0)","v":1},null,null,{"$f":"IF(J66=\"Y\",1,0)","v":1}]
[]
["Adjusted Level ",null,null,null,null,null,{"$f":"IF(G68=\"Non-compliant\",\"Non-Compliant\",IF(G68>0,G68+G70,\"Non-Compliant\"))","v":"Non-Compliant"},null,null,{"$f":"IF(J68=\"Non-compliant\",\"Non-Compliant\",IF(J68>0,J68+J70,\"Non-Compliant\"))","v":"Non-Compliant"}]
[]
["Recognition Level",null,null,null,null,null,{"$f":"VLOOKUP(G72,A77:D87,4)","v":"B-BBEE Procurement Recognition Level"},null,null,{"$f":"VLOOKUP(J72,A77:D877,4)","v":"B-BBEE Procurement Recognition Level"}]
[]
[]
["B-BBEE Status","Qualification points (New COGP)",null,"B-BBEE Procurement Recognition Level"]
[]
[1,100,null,1.35]
[2,95,100,1.25]
[3,90,95,1.1000000000000001]
[4,80,90,1]
[5,75,80,0.8]
[6,70,75,0.6]
[7,55,70,0.5]
[8,40,55,0.1]
[9,null,40,0]

{"sheet":"Targets & Inputs","index":3,"n_rows":182,"n_cols":10,"rows_kept":182,"cut":false,"hidden":false,"merged":[[159,0,159,1],[160,0,160,1],[161,0,161,1],[162,0,162,1],[147,0,147,1],[148,0,148,1],[158,0,158,1],[127,0,127,1],[128,0,128,1],[126,0,126,1],[16,0,16,1],[136,0,136,1],[24,0,24,1],[35,0,35,1],[36,0,36,1],[31,0,31,1],[32,0,32,1],[40,0,40,1],[12,0,12,1],[7,0,7,1],[22,0,22,1],[137,0,137,1],[132,0,132,1],[129,0,129,1],[43,0,43,1],[44,0,44,1],[46,0,46,1],[18,0,18,1],[112,0,112,1],[8,0,8,1],[9,0,9,1],[10,0,10,1],[13,0,13,1],[14,0,14,1],[0,1,0,8],[2,1,2,8],[83,0,83,1],[83,2,83,4],[83,5,83,7],[4,0,5,8],[17,0,17,1],[15,0,15,1],[19,0,19,1],[25,0,25,1],[30,2,30,4],[30,0,30,1],[30,5,30,7],[26,0,26,1],[41,0,41,1],[34,0,34,1],[112,5,112,7],[37,0,37,1],[39,0,39,1],[39,2,39,4],[112,2,112,4],[45,0,45,1],[102,0,102,1],[102,2,102,4],[102,5,102,7]]}
["COMPANY NAME",{"$f":"'Global Business Solutions'!B27","v":"Test"}]
[]
["FINANCIAL INFORMATION USED",{"$f":"'Global Business Solutions'!B29","v":"2017-02-28"}]
[]
["Targets & Input"]
[]
[]
["Input Information",null,"Budget","Actual"]
["Total Directors",null,{"$f":"'Global Business Solutions'!C32","v":0},{"$f":"Management!B30","v":0},null,null,"Input area"]
["Total Executive Directors",null,{"$f":"'Global Business Solutions'!C33","v":0},{"$f":"Management!B33","v":0},null,null,"Formula - Please do not over write"]
["Total Other Executive Management",null,{"$f":"'Global Business Solutions'!C34","v":0},{"$f":"Management!B43","v":0}]
["Senior and Other Executive Management Combined (Y/N)",null,"N"]
["Senior Management",null,{"$f":"'Global Business Solutions'!C36","v":0},{"$f":"'Employment Equity Worksheet'!L12","v":0}]
["Middle Management",null,{"$f":"'Global Business Solutions'!C37","v":0},{"$f":"'Employment Equity Worksheet'!L13","v":0}]
["Junior Management",null,{"$f":"'Global Business Solutions'!C38","v":0},{"$f":"'Employment Equity Worksheet'!L14","v":0}]
["Payroll",null,{"$f":"'Global Business Solutions'!C39","v":0},{"$f":"'Skills Development'!B23","v":0}]
["Head Count",null,{"$f":"'Global Business Solutions'!C40","v":0},{"$f":"'Employment Equity Worksheet'!L18","v":0}]
["TMPS",null,{"$f":"+'Target - TMPS and NPAT'!D18","v":0},{"$f":"TMPS!D18","v":0}]
["Turnover",null,{"$f":"'Global Business Solutions'!C42","v":0},{"$f":"+C19","v":0}]
["NPAT",null,{"$f":"'Global Business Solutions'!C43","v":0},{"$f":"+C20","v":0}]
["Supplier Development - Early Settlement Benefit used (Y/N)",null,{"$f":"'Global Business Solutions'!C44","v":"N"}]
["Enterprise Development - Early Settlement Benefit used (Y/N)",null,{"$f":"'Global Business Solutions'!C45","v":"N"}]
["Stats Table used",null,{"$f":"'Global Business Solutions'!C46","v":"Table 3"}]
[]
["EAP Target",null,"AM","IM","CM","AF","IF","CF"]
["EAP Target",null,0.42799999999999999,1.7999999999999999E-2,5.2999999999999999E-2,0.35099999999999998,0.01,4.4999999999999998E-2]
["Adjusted EAP",null,{"$f":"+C26/SUM($C$26:$H$26)","v":0.47292817679558008},1.9889502762430938E-2,5.8563535911602203E-2,0.38784530386740329,1.1049723756906077E-2,4.9723756906077346E-2]
[]
["Management Control"]
[]
["Board of Directors",null,"Directors",null,null,"Executive Directors"]
["Budget",null,"Total","B","BF","Total","B","BF"]
["Target Board",null,{"$f":"+C9","v":0},{"$f":"ROUNDUP(C33*Scorecard!E17,-0.5)","v":0},{"$f":"ROUNDUP(C33*Scorecard!E18,-0.5)","v":0},{"$f":"+C10","v":0},{"$f":"ROUNDUP(F33*Scorecard!E19,-0.5)","v":0},{"$f":"ROUNDUP(F33*Scorecard!E20,-0.5)","v":0}]
[]
["Actual against target",null,"Total","B","BF","Total","B","BF","Current Points"]
["Target Board - Actual Figures",{"$f":"D4*Scorecard!E20","v":0},{"$f":"D9","v":0},{"$f":"ROUNDUP(C36*Scorecard!E17,-0.5)","v":0},{"$f":"ROUNDUP(C36*Scorecard!E18,-0.5)","v":0},{"$f":"D10","v":0},{"$f":"ROUNDUP(F36*Scorecard!E19,-0.5)","v":0},{"$f":"ROUNDUP(F36*Scorecard!E20,-0.5)","v":0}]
["Actual Board",{"$f":"SUM(C37:H37)","v":0},{"$f":"Management!B30","v":0},{"$f":"Management!B31","v":0},{"$f":"Management!B32","v":0},{"$f":"Management!B33","v":0},{"$f":"Management!B34","v":0},{"$f":"Management!B35","v":0},{"$f":"SUM(Management!C37:C40)","v":0}]
["Required",null,{"$f":"IF(C36>=C37,C36-C37,0)","v":0},0,0,0,0,0]
[]
["Executive Management",null,"Executive Management"]
["Budget",null,"Total","B","BF"]
["Target Executive Management",null,{"$f":"C11","v":0},{"$f":"ROUNDUP(C42*Scorecard!E21,-0.5)","v":0},{"$f":"ROUNDUP(C42*Scorecard!E22,-0.5)","v":0}]
[]
["Actual against target",null,"Total","B","BF","Current Points"]
["Target Executive Management - Actual Figures",{"$f":"D13*Scorecard!E29","v":0},{"$f":"D11","v":0},{"$f":"ROUNDUP(C45*Scorecard!E21,-0.5)","v":0},{"$f":"ROUNDUP(C45*Scorecard!E22,-0.5)","v":0}]
["Actual Executive Management",{"$f":"SUM(C46:H46)","v":0},{"$f":"Management!B43","v":0},{"$f":"Management!B44","v":0},{"$f":"Management!B45","v":0},{"$f":"SUM(Management!C47:C48)","v":0}]
["Required",null,{"$f":"IF(C45>=C46,C45-C46,0)","v":0},{"$f":"IF(D45>=D46,D45-D46,0)","v":0},{"$f":"IF(E45>=E46,E45-E46,0)","v":0}]
[]
["Senior Management","Target","AM","IM","CM","AF","IF","CF"]
["Senior Management - Budgeted figures",{"$f":"C13","v":0},{"$f":"IF($B$50*Scorecard!$E$23*C27<0.5,0,ROUNDUP($B$50*Scorecard!$E$23*C27,-0.5))","v":0},{"$f":"IF($B$50*Scorecard!$E$23*D27<0.5,0,ROUNDUP($B$50*Scorecard!$E$23*D27,-0.5))","v":0},{"$f":"IF($B$50*Scorecard!$E$23*E27<0.5,0,ROUNDUP($B$50*Scorecard!$E$23*E27,-0.5))","v":0},{"$f":"IF($B$50*Scorecard!$E$23*F27<0.5,0,ROUNDUP($B$50*Scorecard!$E$23*F27,-0.5))","v":0},{"$f":"IF($B$50*Scorecard!$E$23*G27<0.5,0,ROUNDUP($B$50*Scorecard!$E$23*G27,-0.5))","v":0},{"$f":"IF($B$50*Scorecard!$E$23*H27<0.5,0,ROUNDUP($B$50*Scorecard!$E$23*H27,-0.5))","v":0}]
[]
["Actual against target","Target","AM","IM","CM","AF","IF","CF","Current Points"]
["Target Senior Management - Actual Figures",{"$f":"D13","v":0},{"$f":"IF($B$53*Scorecard!$E$23*C27<0.5,0,ROUNDUP($B$53*Scorecard!$E$23*C27,-0.5))","v":0},{"$f":"IF($B$53*Scorecard!$E$23*D27<0.5,0,ROUNDUP($B$53*Scorecard!$E$23*D27,-0.5))","v":0},{"$f":"IF($B$53*Scorecard!$E$23*E27<0.5,0,ROUNDUP($B$53*Scorecard!$E$23*E27,-0.5))","v":0},{"$f":"IF($B$53*Scorecard!$E$23*F27<0.5,0,ROUNDUP($B$53*Scorecard!$E$23*F27,-0.5))","v":0},{"$f":"IF($B$53*Scorecard!$E$23*G27<0.5,0,ROUNDUP($B$53*Scorecard!$E$23*G27,-0.5))","v":0},{"$f":"IF($B$53*Scorecard!$E$23*H27<0.5,0,ROUNDUP($B$53*Scorecard!$E$23*H27,-0.5))","v":0}]
["Actual Senior Management",{"$f":"'Employment Equity Worksheet'!L12","v":0},{"$f":"'Employment Equity Worksheet'!B12","v":0},{"$f":"'Employment Equity Worksheet'!C12","v":0},{"$f":"'Employment Equity Worksheet'!D12","v":0},{"$f":"'Employment Equity Worksheet'!G12","v":0},{"$f":"'Employment Equity Worksheet'!H12","v":0},{"$f":"'Employment Equity Worksheet'!I12","v":0},{"$f":"SUM('Employment Equity Worksheet'!B34:I34)+SUM('Employment Equity Worksheet'!G41:I41)","v":0}]
["Required",null,{"$f":"IF(C53>=C54,C53-C54,0)","v":0},0,0,0,0,0]
[]
["Middle Management","Target","AM","IM","CM","AF","IF","CF"]
["Middle Management - Budgeted figures",{"$f":"C14","v":0},{"$f":"IF($B$58*Scorecard!$E$25*C27<0.5,0,ROUNDUP($B$58*Scorecard!$E$25*C27,-0.5))","v":0},{"$f":"IF($B$58*Scorecard!$E$25*D27<0.5,0,ROUNDUP($B$58*Scorecard!$E$25*D27,-0.5))","v":0},{"$f":"IF($B$58*Scorecard!$E$25*E27<0.5,0,ROUNDUP($B$58*Scorecard!$E$25*E27,-0.5))","v":0},{"$f":"IF($B$58*Scorecard!$E$25*F27<0.5,0,ROUNDUP($B$58*Scorecard!$E$25*F27,-0.5))","v":0},{"$f":"IF($B$58*Scorecard!$E$25*G27<0.5,0,ROUNDUP($B$58*Scorecard!$E$25*G27,-0.5))","v":0},{"$f":"IF($B$58*Scorecard!$E$25*H27<0.5,0,ROUNDUP($B$58*Scorecard!$E$25*H27,-0.5))","v":0}]
[]
["Actual against target","Target","AM","IM","CM","AF","IF","CF","Current Points"]
["Target Middle Management - Actual Figures",{"$f":"D14","v":0},{"$f":"IF($B$61*Scorecard!$E$25*C27<0.5,0,ROUNDUP($B$61*Scorecard!$E$25*C27,-0.5))","v":0},{"$f":"IF($B$61*Scorecard!$E$25*D27<0.5,0,ROUNDUP($B$61*Scorecard!$E$25*D27,-0.5))","v":0},{"$f":"IF($B$61*Scorecard!$E$25*E27<0.5,0,ROUNDUP($B$61*Scorecard!$E$25*E27,-0.5))","v":0},{"$f":"IF($B$61*Scorecard!$E$25*F27<0.5,0,ROUNDUP($B$61*Scorecard!$E$25*F27,-0.5))","v":0},{"$f":"IF($B$61*Scorecard!$E$25*G27<0.5,0,ROUNDUP($B$61*Scorecard!$E$25*G27,-0.5))","v":0},{"$f":"IF($B$61*Scorecard!$E$25*H27<0.5,0,ROUNDUP($B$61*Scorecard!$E$25*H27,-0.5))","v":0}]
["Actual Middle Management",{"$f":"D14","v":0},{"$f":"'Employment Equity Worksheet'!B13","v":0},{"$f":"'Employment Equity Worksheet'!C13","v":0},{"$f":"'Employment Equity Worksheet'!D13","v":0},{"$f":"'Employment Equity Worksheet'!G13","v":0},{"$f":"'Employment Equity Worksheet'!H13","v":0},{"$f":"'Employment Equity Worksheet'!I13","v":0},{"$f":"SUM('Employment Equity Worksheet'!B49:I49)+SUM('Employment Equity Worksheet'!G56:I56)","v":0}]
["Required",null,{"$f":"IF(C61>=C62,C61-C62,0)","v":0},0,0,0,0,0]
[]
["Junior Management","Target","AM","IM","CM","AF","IF","CF"]
["Junior Management - Budgeted figures",{"$f":"C15","v":0},{"$f":"IF($B$66*Scorecard!$E$27*C27<0.5,0,ROUNDUP($B$66*Scorecard!$E$27*C27,-0.5))","v":0},{"$f":"IF($B$66*Scorecard!$E$27*D27<0.5,0,ROUNDUP($B$66*Scorecard!$E$27*D27,-0.5))","v":0},{"$f":"IF($B$66*Scorecard!$E$27*E27<0.5,0,ROUNDUP($B$66*Scorecard!$E$27*E27,-0.5))","v":0},{"$f":"IF($B$66*Scorecard!$E$27*F27<0.5,0,ROUNDUP($B$66*Scorecard!$E$27*F27,-0.5))","v":0},{"$f":"IF($B$66*Scorecard!$E$27*G27<0.5,0,ROUNDUP($B$66*Scorecard!$E$27*G27,-0.5))","v":0},{"$f":"IF($B$66*Scorecard!$E$27*H27<0.5,0,ROUNDUP($B$66*Scorecard!$E$27*H27,-0.5))","v":0}]
[]
["Actual against target","Target","AM","IM","CM","AF","IF","CF","Current Points"]
["Target Junior Management - Actual Figures",{"$f":"D15","v":0},{"$f":"IF($B$69*Scorecard!$E$27*C27<0.5,0,ROUNDUP($B$69*Scorecard!$E$27*C27,-0.5))","v":0},{"$f":"IF($B$69*Scorecard!$E$27*D27<0.5,0,ROUNDUP($B$69*Scorecard!$E$27*D27,-0.5))","v":0},{"$f":"IF($B$69*Scorecard!$E$27*E27<0.5,0,ROUNDUP($B$69*Scorecard!$E$27*E27,-0.5))","v":0},{"$f":"IF($B$69*Scorecard!$E$27*F27<0.5,0,ROUNDUP($B$69*Scorecard!$E$27*F27,-0.5))","v":0},{"$f":"IF($B$69*Scorecard!$E$27*G27<0.5,0,ROUNDUP($B$69*Scorecard!$E$27*G27,-0.5))","v":0},{"$f":"IF($B$69*Scorecard!$E$27*H27<0.5,0,ROUNDUP($B$69*Scorecard!$E$27*H27,-0.5))","v":0}]
["Actual Junior Management",{"$f":"D15","v":0},{"$f":"'Employment Equity Worksheet'!B14","v":0},{"$f":"'Employment Equity Worksheet'!C14","v":0},{"$f":"'Employment Equity Worksheet'!D14","v":0},{"$f":"'Employment Equity Worksheet'!G14","v":0},{"$f":"'Employment Equity Worksheet'!H14","v":0},{"$f":"'Employment Equity Worksheet'!I14","v":0},{"$f":"SUM('Employment Equity Worksheet'!B64:I64)+SUM('Employment Equity Worksheet'!G71:I71)","v":0}]
["Required",null,{"$f":"IF(C69>=C70,C69-C70,0)","v":0},0,0,0,0,0]
[]
["Disabled Staff"]
["Disabled Staff - Budgeted figures",{"$f":"ROUNDUP(C17*Scorecard!E29,-0.5)","v":0}]
[]
["Actual against target - Disabled","Target"]
["Disabled black staff - Actual Figures",{"$f":"ROUNDUP(D17*Scorecard!E29,-0.5)","v":0}]
["Actual Disabled Black Staff",{"$f":"SUM('Employment Eq DATA INPUT'!M33:R33)","v":0}]
["Proposed Disabled Learners"]
["Required",{"$f":"IF(B77>=B78,B77-B78-B79,0)","v":0}]
[]
["Skills Development"]
[]
["Total Skills Development Spend",null,"Amount Spent on Black Males",null,null,"Amount Spent on Black Females"]
["Budget","Target","AM","IM","CM","AF","IF","CF"]
["Target Spend on Black people - Budgeted figures",{"$f":"C16*Scorecard!$E$32","v":0},{"$f":"IF($C$16*Scorecard!$E$32*C27<0,0,$C$16*Scorecard!$E$32*C27)","v":0},{"$f":"IF($C$16*Scorecard!$E$32*D27<0,0,$C$16*Scorecard!$E$32*D27)","v":0},{"$f":"IF($C$16*Scorecard!$E$32*E27<0,0,$C$16*Scorecard!$E$32*E27)","v":0},{"$f":"IF($C$16*Scorecard!$E$32*F27<0,0,$C$16*Scorecard!$E$32*F27)","v":0},{"$f":"IF($C$16*Scorecard!$E$32*G27<0,0,$C$16*Scorecard!$E$32*G27)","v":0},{"$f":"IF($C$16*Scorecard!$E$32*H27<0,0,$C$16*Scorecard!$E$32*H27)","v":0}]
[]
["Actual against target","Target","AM","IM","CM","AF","IF","CF","Current Points"]
["Target Spend on Black people - Actual Figures",{"$f":"D16*Scorecard!E32","v":0},{"$f":"IF($D$16*Scorecard!$E$32*C27<0,0,$D$16*Scorecard!$E$32*C27)","v":0},{"$f":"IF($D$16*Scorecard!$E$32*D27<0,0,$D$16*Scorecard!$E$32*D27)","v":0},{"$f":"IF($D$16*Scorecard!$E$32*E27<0,0,$D$16*Scorecard!$E$32*E27)","v":0},{"$f":"IF($D$16*Scorecard!$E$32*F27<0,0,$D$16*Scorecard!$E$32*F27)","v":0},{"$f":"IF($D$16*Scorecard!$E$32*G27<0,0,$D$16*Scorecard!$E$32*G27)","v":0},{"$f":"IF($D$16*Scorecard!$E$32*H27<0,0,$D$16*Scorecard!$E$32*H27)","v":0}]
["Actual Spend",{"$f":"SUM(C90:H90)","v":0},{"$f":"'Skills Development'!C42","v":0},{"$f":"'Skills Development'!D42","v":0},{"$f":"'Skills Development'!E42","v":0},{"$f":"'Skills Development'!F42","v":0},{"$f":"'Skills Development'!G42","v":0},{"$f":"'Skills Development'!H42","v":0},{"$f":"+'Skills Development'!C54","v":0}]
["Proposed Disabled Learners Spend",{"$f":"SUM(C91:H91)","v":0}]
["Required",{"$f":"SUM(C92:H92)","v":0},{"$f":"IF(C89>=C90,C89-C90-C91,0)","v":0},{"$f":"IF(D89>=D90,D89-D90-D91,0)","v":0},0,0,0,0]
[]
["Total Skills Development Spend - Disabled"]
["Target Spend on Black people - Budgeted figures",{"$f":"+C16*Scorecard!E33","v":0}]
[]
["Actual against target - Disabled","Target"]
["Target Spend on Black people - Actual Figures",{"$f":"D16*Scorecard!E33","v":0}]
["Actual Spend",{"$f":"+'Skills Development'!K46","v":0}]
["Proposed Disabled Learners Spend"]
["Required",{"$f":"IF(B98>=B99,B98-B99-B100,0)","v":0}]
[]
["Total Learnerships, Apprenticeships and Internships",null,"Amount Spent on Black Males",null,null,"Amount Spent on Black Females"]
["Budget","Target","AM","IM","CM","AF","IF","CF"]
["Budgeted number of black people on B, C and D training",{"$f":"SUM(C105:H105)","v":0},{"$f":"ROUNDUP($C$17*Scorecard!$E$34*C27,-0.5)","v":0},{"$f":"ROUNDUP($C$17*Scorecard!$E$34*D27,-0.5)","v":0},{"$f":"ROUNDUP($C$17*Scorecard!$E$34*E27,-0.5)","v":0},{"$f":"ROUNDUP($C$17*Scorecard!$E$34*F27,-0.5)","v":0},{"$f":"ROUNDUP($C$17*Scorecard!$E$34*G27,-0.5)","v":0},{"$f":"ROUNDUP($C$17*Scorecard!$E$34*H27,-0.5)","v":0}]
[]
["Actual against target","Target","AM","IM","CM","AF","IF","CF","Current Points"]
["Target Black people - Actual Figures",{"$f":"SUM(C108:H108)","v":0},{"$f":"ROUNDUP($D$17*Scorecard!$E$34*C27,-0.5)","v":0},{"$f":"ROUNDUP($D$17*Scorecard!$E$34*D27,-0.5)","v":0},{"$f":"ROUNDUP($D$17*Scorecard!$E$34*E27,-0.5)","v":0},{"$f":"ROUNDUP($D$17*Scorecard!$E$34*F27,-0.5)","v":0},{"$f":"ROUNDUP($D$17*Scorecard!$E$34*G27,-0.5)","v":0},{"$f":"ROUNDUP($D$17*Scorecard!$E$34*H27,-0.5)","v":0}]
["Actual number of black people on B, C and D training",{"$f":"SUM(C109:H109)","v":0},{"$f":"'SD Table 2'!N34","v":0},{"$f":"'SD Table 2'!O34","v":0},{"$f":"'SD Table 2'!P34","v":0},{"$f":"'SD Table 2'!Q34","v":0},{"$f":"'SD Table 2'!R34","v":0},{"$f":"'SD Table 2'!S34","v":0},{"$f":"+'Skills Development'!C68","v":0}]
["Proposed Disabled Learners Spend",{"$f":"SUM(C110:H110)","v":0}]
["Required",{"$f":"SUM(C111:H111)","v":0},{"$f":"IF(C108>=C109,C108-C109-C110,0)","v":0},{"$f":"IF(D108>=D109,D108-D109-D110,0)","v":0},0,0,0,0]
[]
["Total Unemployed Training",null,"Black Males - Unemployed Training",null,null,"Black Females - Unemployed Training"]
["Budget","Target","AM","IM","CM","AF","IF","CF"]
["Budgeted number of Unemployed black people trained",{"$f":"SUM(C115:H115)","v":0},{"$f":"ROUNDUP($C$17*Scorecard!$E$35*C27,-0.5)","v":0},{"$f":"ROUNDUP($C$17*Scorecard!$E$35*D27,-0.5)","v":0},{"$f":"ROUNDUP($C$17*Scorecard!$E$35*E27,-0.5)","v":0},{"$f":"ROUNDUP($C$17*Scorecard!$E$35*F27,-0.5)","v":0},{"$f":"ROUNDUP($C$17*Scorecard!$E$35*G27,-0.5)","v":0},{"$f":"ROUNDUP($C$17*Scorecard!$E$35*H27,-0.5)","v":0}]
[]
["Actual against target","Target","AM","IM","CM","AF","IF","CF","Current Points"]
["Target Black people - Actual Figures",{"$f":"SUM(C118:H118)","v":0},{"$f":"ROUNDUP($D$17*Scorecard!$E$35*C27,-0.5)","v":0},{"$f":"ROUNDUP($D$17*Scorecard!$E$35*D27,-0.5)","v":0},{"$f":"ROUNDUP($D$17*Scorecard!$E$35*E27,-0.5)","v":0},{"$f":"ROUNDUP($D$17*Scorecard!$E$35*F27,-0.5)","v":0},{"$f":"ROUNDUP($D$17*Scorecard!$E$35*G27,-0.5)","v":0},{"$f":"ROUNDUP($D$17*Scorecard!$E$35*H27,-0.5)","v":0}]
["Actual number of unemployed black people on training",{"$f":"SUM(C119:H119)","v":0},{"$f":"'Skills Development'!I60","v":0},{"$f":"'Skills Development'!J60","v":0},{"$f":"'Skills Development'!K60","v":0},{"$f":"'Skills Development'!L60","v":0},{"$f":"'Skills Development'!M60","v":0},{"$f":"'Skills Development'!N60","v":0},{"$f":"'Skills Development'!I68","v":0}]
["Proposed Disabled Learners Spend",{"$f":"SUM(C120:H120)","v":0}]
["Required",{"$f":"SUM(C121:H121)","v":0},{"$f":"IF(C118>=C119,C118-C119-C120,0)","v":0},{"$f":"IF(D118>=D119,D118-D119-D120,0)","v":0},{"$f":"IF(E118>=E119,E118-E119-E120,0)","v":0},{"$f":"IF(F118>=F119,F118-F119-F120,0)","v":0},{"$f":"IF(G118>=G119,G118-G119-G120,0)","v":0},{"$f":"IF(H118>=H119,H118-H119-H120,0)","v":0}]
[]
["ENTERPRISE & SUPPLIER DEVELOPMENT"]
[]
["PREFERENTIAL PROCUREMENT"]
[]
["Procurement Indicator",null,"Target Spend","Target @ Actual TMPS","Actual Spend","Required","Current Points"]
["B-BBEE Procurement Spend from all Empowering Suppliers as % of Measured Spend",null,{"$f":"$C$18*Scorecard!E39","v":0},{"$f":"$D$18*Scorecard!$E39","v":0},{"$f":"'Procurement Calculation'!B8","v":0},{"$f":"IF(D128>=E128,D128-E128,0)","v":0},{"$f":"'Procurement Calculation'!F17","v":0}]
["BEE Procurement Spend from Empowering QSE Suppliers",null,{"$f":"$C$18*Scorecard!E40","v":0},{"$f":"$D$18*Scorecard!$E40","v":0},{"$f":"'Procurement Calculation'!B9","v":0},0,{"$f":"'Procurement Calculation'!F18","v":0}]
["BEE Procurement Spend from EME Suppliers",null,{"$f":"$C$18*Scorecard!E41","v":0},{"$f":"$D$18*Scorecard!$E41","v":0},{"$f":"'Procurement Calculation'!B10","v":0},0,{"$f":"'Procurement Calculation'!F19","v":0}]
["Spend from Black Owned Suppliers","Black  Owned",{"$f":"$C$18*Scorecard!E42","v":0},{"$f":"$D$18*Scorecard!$E42","v":0},{"$f":"'Procurement Calculation'!B11","v":0},0,{"$f":"'Procurement Calculation'!F20","v":0}]
["Spend from Black Owned Suppliers","Black Woman Owned",{"$f":"$C$18*Scorecard!E43","v":0},{"$f":"$D$18*Scorecard!$E43","v":0},{"$f":"'Procurement Calculation'!B12","v":0},0,{"$f":"'Procurement Calculation'!F21","v":0}]
["BBBEE Spend from Designated Group Suppliers >=51% Black Owned",null,{"$f":"$C$18*Scorecard!E44","v":0},{"$f":"$D$18*Scorecard!$E44","v":0},{"$f":"'Procurement Calculation'!B13","v":0},0,{"$f":"'Procurement Calculation'!F22","v":0}]
[]
["SUPPLIER DEVELOPMENT"]
[]
["Supplier Development",null,"Target Spend","Current Points"]
["Supplier Development",null,{"$f":"HLOOKUP($C$23,$B$179:$J$182,4)*Scorecard!E45*1","v":0}]
["Target @ Actual NPAT","Early Settlement",{"$f":"IF(AND(ROUND(HLOOKUP($C$23,'ED & SD'!$A$71:$J$74,4)*Scorecard!E45>Scorecard!F45*15%,2),$C$21=\"Y\"),ROUND(HLOOKUP($C$23,'ED & SD'!$A$71:$J$74,4)*Scorecard!E45*15%,2)*1,0)","v":0}]
["Target @ Actual NPAT","Other",{"$f":"IF(AND(ROUND(HLOOKUP($C$23,'ED & SD'!$A$71:$J$74,4)*Scorecard!E45>Scorecard!F45*85%,2),$C$21=\"Y\"),ROUND(HLOOKUP($C$23,'ED & SD'!$A$71:$J$74,4)*Scorecard!E45*85%,2)*1,(HLOOKUP($C$23,'ED & SD'!$A$71:$J$74,4)*Scorecard!E45*1))","v":0}]
["Actual Spend","Early Settlement",{"$f":"'ED & SD'!B35","v":0},{"$f":"'ED & SD'!B47","v":0}]
["Actual Spend","Other",{"$f":"'ED & SD'!L32","v":0}]
["Required","Early Settlement",{"$f":"IF(C139>=C141,C139-C141,0)","v":0}]
["Required","Other",{"$f":"IF(C140>=C142,C140-C142,0)","v":0}]
[]
["ENTERPRISE DEVELOPMENT"]
[]
["Enterprise Development",null,"Target Spend","Current Points"]
["Enterprise Development",null,{"$f":"HLOOKUP($C$23,$B$179:$J$182,4)*Scorecard!E46*1","v":0}]
["Target @ Actual NPAT","Early Settlement",{"$f":"IF(AND(ROUND(HLOOKUP($C$23,'ED & SD'!$A$71:$J$74,4)*Scorecard!E46>Scorecard!F45*15%,2),$C$22=\"Y\"),ROUND(HLOOKUP($C$23,'ED & SD'!$A$71:$J$74,4)*Scorecard!E46*15%,2)*1,0)","v":0}]
["Target @ Actual NPAT","Other",{"$f":"IF(AND(ROUND(HLOOKUP($C$23,'ED & SD'!$A$71:$J$74,4)*Scorecard!E46>Scorecard!F45*85%,2),$C$22=\"Y\"),ROUND(HLOOKUP($C$23,'ED & SD'!$A$71:$J$74,4)*Scorecard!E46*85%,2)*1,HLOOKUP($C$23,'ED & SD'!$A$71:$J$74,4)*Scorecard!E46*1)","v":0}]
["Actual Spend","Early Settlement",{"$f":"'ED & SD'!O32","v":0},{"$f":"'ED & SD'!C47","v":0}]
["Actual Spend","Other",{"$f":"'ED & SD'!M32","v":0}]
["Required","Early Settlement",{"$f":"IF(C150>=C152,C150-C152,0)","v":0}]
["Required","Other",{"$f":"IF(C151>=C153,C151-C153,0)","v":0}]
[]
["SOCIO-ECONOMIC DEVELOPMENT"]
[]
["Socio-Economic Development",null,"Target Spend","Current Points"]
["Socio-Economic Development",null,{"$f":"HLOOKUP($C$23,$B$179:$J$182,4)*Scorecard!E51*1","v":0}]
["Target @ Actual NPAT",null,{"$f":"HLOOKUP($C$23,'ED & SD'!$A$71:$J$74,4)*Scorecard!E51*1","v":0},{"$f":"'Socio Economic Development'!B35","v":0}]
["Actual Spend",null,{"$f":"'Socio Economic Development'!G29","v":0}]
["Required",null,{"$f":"IF(C161>=C162,C161-C162,0)","v":0}]
[]
[]
["2016-12-31","All Industries","Mining & Quarrying","Manufacturing","Electricity, Gas & Water Supply","Construction","Trade","Transport, Storage & Communication","Real Estate & Other Business Services","Community, Social and Personal Services"]
[null,"Table 1","Table 2","Table 3","Table 4","Table 5","Table 6","Table 7","Table 8","Table 9"]
["Stats SA Returns"]
["Turnover",2309987,158235,645643,56197,109228,810779,203834,270075,55996]
["Net profit before Tax",164904,23915,38725,-197,3713,44922,16409,35077,2340]
["Tax",31644,5820,8716,504,1497,5616,3862,4454,1175]
["Net Profit after Tax",{"$f":"+B170-B171","v":133260},{"$f":"+C170-C171","v":18095},30009,-701,2216,39306,12547,30623,{"$f":"+J170-J171","v":1165}]
["NPAT %",{"$f":"IF(B169>0,B172/B169,0)","v":5.7688636342975087E-2},{"$f":"IF(C169>0,C172/C169,0)","v":0.11435523114355231},4.6479246270771928E-2,-1.2473975479118103E-2,2.0287838283224082E-2,4.8479302004615317E-2,6.1554990825868107E-2,0.11338702212348421,{"$f":"IF(J169>0,J172/J169,0)","v":2.0805057504107435E-2}]
[0.25,{"$f":"+B173*$A$174","v":1.4422159085743772E-2},{"$f":"+C173*$A$174","v":2.8588807785888078E-2},1.1619811567692982E-2,-3.1184938697795257E-3,5.0719595708060205E-3,1.2119825501153829E-2,1.5388747706467027E-2,2.8346755530871053E-2,5.2012643760268587E-3]
[]
["Client Figures"]
["Budgeted Turnover",{"$f":"C19","v":0},{"$f":"+B177","v":0},{"$f":"+C177","v":0},0,0,0,0,0,{"$f":"+I177","v":0}]
[]
[null,"Table 1","Table 2","Table 3","Table 4","Table 5","Table 6","Table 7","Table 8","Table 9"]
["Industry Norm NPAT",{"$f":"+B177*B174","v":0},0,0,0,0,0,0,0,0]
["Budgeted NPAT",{"$f":"C20","v":0},{"$f":"+B181","v":0},{"$f":"+C181","v":0},0,0,0,0,0,{"$f":"+I181","v":0}]
["Figure Used",{"$f":"IF(B180>B181,B180,B181)","v":0},{"$f":"IF(C180>C181,C180,C181)","v":0},0,0,0,0,0,0,{"$f":"IF(J180>J181,J180,J181)","v":0}]

{"sheet":"Target - TMPS and NPAT","index":4,"n_rows":49,"n_cols":5,"rows_kept":49,"cut":false,"hidden":false,"merged":[[0,1,0,4],[2,1,2,4],[4,0,6,4]]}
["COMPANY NAME",{"$f":"'Global Business Solutions'!B27","v":"Test"}]
[]
["FINANCIAL INFORMATION USED",{"$f":"'Global Business Solutions'!B29","v":"2017-02-28"}]
[]
["Target TMPS"]
[]
[]
[]
["Budgeted figures",null,{"$f":"'Procurement Recognition'!C7","v":"2017-02-28"},"Total"]
["COS",null,null,{"$f":"SUM(C10:C10)","v":0}]
["Operational Expenditure",null,null,{"$f":"SUM(C11:C11)","v":0}]
["Capex",null,null,{"$f":"SUM(C12:C12)","v":0}]
["Interest & Finance Charges",null,null,{"$f":"SUM(C13:C13)","v":0}]
["Miscellaneous",null,null,{"$f":"SUM(C14:C14)","v":0}]
["Total Expenditure",null,{"$f":"SUM(C10:C14)","v":0},{"$f":"SUM(D10:D14)","v":0}]
["Imports and Government Suppliers per schedule",null,null,0]
["Exclusions - per Table below",null,{"$f":"+C49","v":0},{"$f":"SUM(C17:C17)","v":0}]
["TMPS",null,{"$f":"C15-C17","v":0},{"$f":"D15-D17-D16","v":0},{"$f":"+D18-TMPS!D18","v":0}]
[null,null,0]
["Exclusions"]
[]
["Bad debts",null,null,{"$f":"SUM(C22:C22)","v":0}]
["Depreciation",null,null,0]
["Donations ",null,null,0]
["Fines",null,null,0]
["Licences and levies",null,null,0]
["Loss on sale of Fixed Assets",null,null,0]
["Member's remuneration",null,null,0]
["Penalties & Interest - SARS",null,null,0]
["Rates & Taxes",null,null,0]
["Salaries & Wages",null,null,0]
["Salaries & Wages in CoS",null,null,0]
["Loss on Forex",null,null,0]
["Government or Municipal Tender Costs",null,null,0]
["Customs & Excise (freight supplier duties) ",null,null,0]
["Utilities",null,null,0]
["Workers Compensation",null,null,0]
["Miscellaneous",null,null,0]
["Miscellaneous",null,null,0]
["Miscellaneous",null,null,0]
["Miscellaneous",null,null,0]
["Miscellaneous",null,null,0]
["Miscellaneous",null,null,0]
["Miscellaneous",null,null,0]
["Miscellaneous",null,null,0]
["Miscellaneous",null,null,0]
["Miscellaneous",null,null,0]
["Miscellaneous",null,null,0]
[null,null,{"$f":"SUM(C21:C48)","v":0},{"$f":"SUM(D22:D48)","v":0}]

{"sheet":"Ownership","index":5,"n_rows":46,"n_cols":23,"rows_kept":46,"cut":false,"hidden":false,"merged":[[34,1,34,11],[0,1,0,3],[2,1,2,3],[4,0,6,22],[8,1,8,12],[33,1,33,12]]}
["COMPANY NAME",{"$f":"'Target - TMPS and NPAT'!B1:E1","v":"Test"}]
[]
["FINANCIAL INFORMATION USED",{"$f":"'Target - TMPS and NPAT'!B3:E3","v":"2017-02-28"}]
[]
["Ownership"]
[]
[]
[]
["Instructions:","Complete ALL shareholders/ members details.  If the entity is a trust, please complete with the details of the beneficiaries of the trust."]
[]
["Shareholder/ Member Name","Identity Number","RSA Citizen (Y/N)","Race (B/W)","Gender (M/F)","% Owned in Entity","% Economic Interest","% Voting Rights","Amount paid for shares/ membership","Amount outstanding for shares/ membership (to entity or 3rd party)","Current Value of Company","New Entrant (Y/N)","ESOP/ Broad-based scheme (Y/N)","Co-Coperative (Y/N)","Designated Group (Y/N)","Black Ownership","Black Women Ownership","Black Economic Interest","Black Women Economic Interest","Black Voting Rights","Black Women Voting Rights","New Entrant","Designated Group"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(C12=\"Y\",D12=\"B\"),F12,\"\")","v":""},{"$f":"IF(AND(E12=\"F\",C12=\"Y\",D12=\"B\"),F12,\"\")","v":""},{"$f":"IF(AND(C12=\"Y\",D12=\"B\"),G12,\"\")","v":""},{"$f":"IF(AND(E12=\"F\",C12=\"Y\",D12=\"B\"),G12,\"\")","v":""},{"$f":"IF(AND(C12=\"Y\",D12=\"B\"),H12,\"\")","v":""},{"$f":"IF(AND(E12=\"F\",C12=\"Y\",D12=\"B\"),H12,\"\")","v":""},{"$f":"IF(L12=\"Y\",P12,\"\")","v":""},{"$f":"IF(OR(M12=\"Y\",N12=\"Y\",O12=\"Y\"),P12,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(C16=\"Y\",D16=\"B\"),F16,\"\")","v":""},{"$f":"IF(AND(E16=\"F\",C16=\"Y\",D16=\"B\"),F16,\"\")","v":""},{"$f":"IF(AND(C16=\"Y\",D16=\"B\"),G16,\"\")","v":""},{"$f":"IF(AND(E16=\"F\",C16=\"Y\",D16=\"B\"),G16,\"\")","v":""},{"$f":"IF(AND(C16=\"Y\",D16=\"B\"),H16,\"\")","v":""},{"$f":"IF(AND(E16=\"F\",C16=\"Y\",D16=\"B\"),H16,\"\")","v":""},{"$f":"IF(L16=\"Y\",P16,\"\")","v":""},{"$f":"IF(OR(M16=\"Y\",N16=\"Y\",O16=\"Y\"),P16,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
["Total",null,null,null,null,{"$f":"SUM(F12:F30)","v":0},{"$f":"SUM(G12:G30)","v":0},{"$f":"SUM(H12:H30)","v":0},{"$f":"SUM(I12:I30)","v":0},{"$f":"SUM(J12:J30)","v":0},null,null,null,null,null,{"$f":"SUM(P12:P30)","v":0},0,0,0,0,0,0,0]
[]
["Definitions:"]
["New Entrant","Before holding rights of ownership in the entity, has not held equity instruments in any other entity which has a total value of not more than R20,000,000"]
["Designated Groups","Unemployed, Youths (between ages 18-35), person with disabilities, people living in rural areas."]
[]
[]
["Indicator","Target","Weighting Points","Company Performance","Score"]
["Black Shareholders VR",0.25,4,{"$f":"T31","v":0},{"$f":"IF(D39/B39*C39>C39,C39,ROUND(D39/B39*C39,2))","v":0}]
["Black Women Shareholders VR",0.1,2,{"$f":"U31","v":0},{"$f":"IF(D40/B40*C40>C40,C40,ROUND(D40/B40*C40,2))","v":0}]
["Black Shareholders EI",0.25,4,{"$f":"R31","v":0},0]
["Black Women Shareholders EI",0.1,2,{"$f":"S31","v":0},0]
["Black Designated Groups EI",0.03,3,{"$f":"W31","v":0},0]
["Net Value",0.25,8,null,{"$f":"'NEI Calculator'!C39","v":0}]
["Black New Entrant",0.02,2,{"$f":"V31","v":0},0]
[null,null,{"$f":"SUM(C39:C45)","v":25},null,{"$f":"SUM(E39:E45)","v":0}]

{"sheet":"NEI Calculator","index":6,"n_rows":39,"n_cols":9,"rows_kept":39,"cut":false,"hidden":false,"merged":[[8,0,8,8],[9,0,11,0],[9,3,9,8],[10,3,10,8],[11,3,11,8],[0,0,0,1],[0,2,0,5],[2,0,2,1],[2,2,2,5],[4,0,6,8],[20,3,20,8],[21,3,21,8],[15,0,15,8],[12,0,12,8],[13,3,13,8],[14,0,14,8],[16,0,21,0],[16,3,16,8],[17,3,17,8],[18,3,18,8],[19,3,19,8],[22,0,22,8],[23,3,23,8],[25,3,25,8],[26,3,26,8],[27,0,27,8],[28,3,28,8],[34,0,34,8],[35,3,35,8],[36,0,36,8],[38,0,38,1],[38,3,38,8],[33,3,33,8],[29,0,29,8],[30,0,30,8],[31,0,33,0],[31,3,31,8],[32,3,32,8]]}
["COMPANY NAME",null,{"$f":"+Ownership!B1","v":"Test"}]
[]
["FINANCIAL INFORMATION USED",null,{"$f":"+Ownership!B3","v":"2017-02-28"}]
[]
["NEI Calculator"]
[]
[]
[]
[]
["Deemed Net Value Calculation","B",{"$f":"+C12*Ownership!D41","v":0},"Value of Equity Interest at date of measurement (Black Shareholding)"]
[null,"C",{"$f":"Ownership!J31","v":0},"Value of any debt relating to acquisition debt at date of measurement."]
[null,"D",{"$f":"+Ownership!K12","v":0},"Value of ME at date of measurement (Total Value of Company)"]
[]
[null,"A",{"$f":"IF(C12>0,(C10-C11)/C12,0)","v":0}]
[]
[]
["Time Based Graduation Factors","Year 1",0.1]
[null,"Year 2",0.2]
[null,"Years 3 & 4",0.4]
[null,"Years 5 & 6",0.6]
[null,"Years 7 & 8",0.8]
[null,"Years 9 & 10",1]
[]
["Net Value (formula A) Calculation","B",{"$f":"+C14","v":0},"Deemed Net Value Above"]
[null,"C",{"$f":"VLOOKUP(I25,B17:C22,2)","v":0.8},"Time based graduation factor",null,null,"Period since B-BBEE deal",null,"Years 7 & 8"]
[null,"D",0.25,"Compliance Target"]
[null,"E",8,"Weighting Points"]
[]
[null,"A",{"$f":"IF(AND(C25>0,C26>0),IF(ROUND(C24*C27*(1/(C25*C26)),2)>C27,C27,ROUND(C24*C27*(1/(C25*C26)),2)),0)","v":0}]
[]
[]
["Net Value (formula B) Calculation","B",{"$f":"+Ownership!D41","v":0}]
[null,"C",{"$f":"C26","v":0.25}]
[null,"D",8]
[]
[null,"A",{"$f":"IF(C33>0,IF((C32/C33)*C34>C34,C34,(C32/C33)*C34),0)","v":0}]
[]
[]
["Net Equity Interest",null,{"$f":"IF(C29<C36,C29,C36)","v":0}]

{"sheet":"Management","index":7,"n_rows":64,"n_cols":28,"rows_kept":64,"cut":false,"hidden":false,"merged":[[0,1,0,4],[2,1,2,4],[8,0,9,0],[4,0,6,27],[8,12,8,19],[8,4,8,11],[8,20,8,27]]}
["  ",{"$f":"'Global Business Solutions'!B27","v":"Test"}]
[]
["FINANCIAL INFORMATION USED",{"$f":"'Global Business Solutions'!B29","v":"2017-02-28"}]
[]
["Management"]
[]
[]
[]
["Name","Race","Gender","Status","Non Executive Board Members (NED)",null,null,null,null,null,null,null,"Executive Directors (ED)",null,null,null,null,null,null,null,"Executive Committee Members (EXCO)"]
[null,"A/I/C/W - Please input Non South African as \"W\"","M/F","Non-Exec/Exec/Exco","White or NSA Male","White or NSA Female","African Male","Indian Male","Coloured Male","African Female","Indian Female","Coloured Female","White or NSA Male","White or NSA Female","African Male","Indian Male","Coloured Male","African Female","Indian Female","Coloured Female","White or NSA Male","White or NSA Female","African Male","Indian Male","Coloured Male","African Female","Indian Female","Coloured Female"]
[null,null,null,null,{"$f":"IF(AND(C11=\"M\",B11=\"W\", D11=\"Non-Exec\"),1,\"\")","v":""},{"$f":"IF(AND(C11=\"F\",B11=\"W\",D11=\"Non-Exec\"),1,\"\")","v":""},{"$f":"IF(AND(C11=\"M\",B11=\"A\",D11=\"Non-Exec\"),1,\"\")","v":""},{"$f":"IF(AND(C11=\"M\",B11=\"I\",D11=\"Non-Exec\"),1,\"\")","v":""},{"$f":"IF(AND(C11=\"M\",B11=\"C\",D11=\"Non-Exec\"),1,\"\")","v":""},{"$f":"IF(AND(C11=\"F\",B11=\"A\",D11=\"Non-Exec\"),1,\"\")","v":""},{"$f":"IF(AND(C11=\"F\",B11=\"I\",D11=\"Non-Exec\"),1,\"\")","v":""},{"$f":"IF(AND(C11=\"F\",B11=\"C\",D11=\"Non-Exec\"),1,\"\")","v":""},{"$f":"IF(AND(C11=\"M\",D11=\"Exec\",B11=\"W\"),1,\"\")","v":""},{"$f":"IF(AND(C11=\"F\",B11=\"W\",D11=\"Exec\"),1,\"\")","v":""},{"$f":"IF(AND(C11=\"M\",B11=\"A\",D11=  \"exec\"),1,\"\")","v":""},{"$f":"IF(AND(C11=\"M\",B11=\"I\",D11=\"Exec\"),1,\"\")","v":""},{"$f":"IF(AND(C11=\"M\",B11=\"C\",D11=\"Exec\"),1,\"\")","v":""},{"$f":"IF(AND(C11=\"F\",B11=\"A\",D11=\"Exec\"),1,\"\")","v":""},{"$f":"IF(AND(C11=\"F\",B11=\"I\",D11=\"Exec\"),1,\"\")","v":""},{"$f":"IF(AND(C11=\"F\",B11=\"C\",D11=\"Exec\"),1,\"\")","v":""},{"$f":"IF(AND(C11=\"M\",B11=\"W\",D11=\"Exco\"),1,\"\")","v":""},{"$f":"IF(AND(C11=\"F\",B11=\"W\",D11=\"Exco\"),1,\"\")","v":""},{"$f":"IF(AND(C11=\"M\",B11=\"A\",D11=\"Exco\"),1,\"\")","v":""},{"$f":"IF(AND(C11=\"M\",B11=\"I\",D11=\"Exco\"),1,\"\")","v":""},{"$f":"IF(AND(C11=\"M\",B11=\"C\",D11=\"Exco\"),1,\"\")","v":""},{"$f":"IF(AND(C11=\"F\",B11=\"A\",D11=\"Exco\"),1,\"\")","v":""},{"$f":"IF(AND(C11=\"F\",B11=\"I\",D11=\"Exco\"),1,\"\")","v":""},{"$f":"IF(AND(C11=\"F\",B11=\"C\",D11=\"Exco\"),1,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(AND(C12=\"M\",B12=\"W\", D12=\"Non-Exec\"),1,\"\")","v":""},{"$f":"IF(AND(C12=\"F\",B12=\"W\",D12=\"Non-Exec\"),1,\"\")","v":""},{"$f":"IF(AND(C12=\"M\",B12=\"A\",D12=\"Non-Exec\"),1,\"\")","v":""},{"$f":"IF(AND(C12=\"M\",B12=\"I\",D12=\"Non-Exec\"),1,\"\")","v":""},{"$f":"IF(AND(C12=\"M\",B12=\"C\",D12=\"Non-Exec\"),1,\"\")","v":""},{"$f":"IF(AND(C12=\"F\",B12=\"A\",D12=\"Non-Exec\"),1,\"\")","v":""},{"$f":"IF(AND(C12=\"F\",B12=\"I\",D12=\"Non-Exec\"),1,\"\")","v":""},{"$f":"IF(AND(C12=\"F\",B12=\"C\",D12=\"Non-Exec\"),1,\"\")","v":""},{"$f":"IF(AND(C12=\"M\",D12=\"Exec\",B12=\"W\"),1,\"\")","v":""},{"$f":"IF(AND(C12=\"F\",B12=\"W\",D12=\"Exec\"),1,\"\")","v":""},{"$f":"IF(AND(C12=\"M\",B12=\"A\",D12=  \"exec\"),1,\"\")","v":""},{"$f":"IF(AND(C12=\"M\",B12=\"I\",D12=\"Exec\"),1,\"\")","v":""},{"$f":"IF(AND(C12=\"M\",B12=\"C\",D12=\"Exec\"),1,\"\")","v":""},{"$f":"IF(AND(C12=\"F\",B12=\"A\",D12=\"Exec\"),1,\"\")","v":""},{"$f":"IF(AND(C12=\"F\",B12=\"I\",D12=\"Exec\"),1,\"\")","v":""},{"$f":"IF(AND(C12=\"F\",B12=\"C\",D12=\"Exec\"),1,\"\")","v":""},{"$f":"IF(AND(C12=\"M\",B12=\"W\",D12=\"Exco\"),1,\"\")","v":""},{"$f":"IF(AND(C12=\"F\",B12=\"W\",D12=\"Exco\"),1,\"\")","v":""},{"$f":"IF(AND(C12=\"M\",B12=\"A\",D12=\"Exco\"),1,\"\")","v":""},{"$f":"IF(AND(C12=\"M\",B12=\"I\",D12=\"Exco\"),1,\"\")","v":""},{"$f":"IF(AND(C12=\"M\",B12=\"C\",D12=\"Exco\"),1,\"\")","v":""},{"$f":"IF(AND(C12=\"F\",B12=\"A\",D12=\"Exco\"),1,\"\")","v":""},{"$f":"IF(AND(C12=\"F\",B12=\"I\",D12=\"Exco\"),1,\"\")","v":""},{"$f":"IF(AND(C12=\"F\",B12=\"C\",D12=\"Exco\"),1,\"\")","v":""}]
[null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,{"$f":"IF(AND(C27=\"M\",B27=\"W\", D27=\"Non-Exec\"),1,\"\")","v":""},{"$f":"IF(AND(C27=\"F\",B27=\"W\",D27=\"Non-Exec\"),1,\"\")","v":""},{"$f":"IF(AND(C27=\"M\",B27=\"A\",D27=\"Non-Exec\"),1,\"\")","v":""},{"$f":"IF(AND(C27=\"M\",B27=\"I\",D27=\"Non-Exec\"),1,\"\")","v":""},{"$f":"IF(AND(C27=\"M\",B27=\"C\",D27=\"Non-Exec\"),1,\"\")","v":""},{"$f":"IF(AND(C27=\"F\",B27=\"A\",D27=\"Non-Exec\"),1,\"\")","v":""},{"$f":"IF(AND(C27=\"F\",B27=\"I\",D27=\"Non-Exec\"),1,\"\")","v":""},{"$f":"IF(AND(C27=\"F\",B27=\"C\",D27=\"Non-Exec\"),1,\"\")","v":""},{"$f":"IF(AND(C27=\"M\",D27=\"Exec\",B27=\"W\"),1,\"\")","v":""},{"$f":"IF(AND(C27=\"F\",B27=\"W\",D27=\"Exec\"),1,\"\")","v":""},{"$f":"IF(AND(C27=\"M\",B27=\"A\",D27=  \"exec\"),1,\"\")","v":""},{"$f":"IF(AND(C27=\"M\",B27=\"I\",D27=\"Exec\"),1,\"\")","v":""},{"$f":"IF(AND(C27=\"M\",B27=\"C\",D27=\"Exec\"),1,\"\")","v":""},{"$f":"IF(AND(C27=\"F\",B27=\"A\",D27=\"Exec\"),1,\"\")","v":""},{"$f":"IF(AND(C27=\"F\",B27=\"I\",D27=\"Exec\"),1,\"\")","v":""},{"$f":"IF(AND(C27=\"F\",B27=\"C\",D27=\"Exec\"),1,\"\")","v":""},{"$f":"IF(AND(C27=\"M\",B27=\"W\",D27=\"Exco\"),1,\"\")","v":""},{"$f":"IF(AND(C27=\"F\",B27=\"W\",D27=\"Exco\"),1,\"\")","v":""},{"$f":"IF(AND(C27=\"M\",B27=\"A\",D27=\"Exco\"),1,\"\")","v":""},{"$f":"IF(AND(C27=\"M\",B27=\"I\",D27=\"Exco\"),1,\"\")","v":""},{"$f":"IF(AND(C27=\"M\",B27=\"C\",D27=\"Exco\"),1,\"\")","v":""},{"$f":"IF(AND(C27=\"F\",B27=\"A\",D27=\"Exco\"),1,\"\")","v":""},{"$f":"IF(AND(C27=\"F\",B27=\"I\",D27=\"Exco\"),1,\"\")","v":""},{"$f":"IF(AND(C27=\"F\",B27=\"C\",D27=\"Exco\"),1,\"\")","v":""}]
[null,null,null,null,{"$f":"SUM(E11:E27)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Total Directors",{"$f":"SUM(E28:T28)","v":0}]
["Total Black Directors",{"$f":"SUM(G28:L28)+SUM(O28:T28)","v":0}]
["Total Black Female Directors",{"$f":"SUM(J28:L28)+SUM(R28:T28)","v":0}]
["Total Executive Directors",{"$f":"SUM(M28:T28)","v":0}]
["Total Black Executive Directors",{"$f":"SUM(O28:T28)","v":0}]
["Total Black Female Executive Directors",{"$f":"SUM(R28:T28)","v":0}]
[]
["Board Representation - Black",{"$f":"IFERROR((B31/B30),0)","v":0},{"$f":"IF(((B37/50%)*2)>2,2,((B37/50%)*2))","v":0}]
["Board Representation - Black Female",{"$f":"IFERROR((B32/B30),0)","v":0},{"$f":"IF(((B38/25%)*1)>1,1,((B38/25%)*1))","v":0}]
["Executive Directors - Black",{"$f":"IFERROR(((B34/B33)),0)","v":0},{"$f":"IF(((B39/60%)*2)>2,2,((B39/60%)*2))","v":0}]
["Executive Directors - Black Female",{"$f":"IF(B33>0,B35/B33,0)","v":0},{"$f":"IF(((B40/30%)*1)>1,1,((B40/30%)*1))","v":0}]
[]
["Other Executive Management",null,"Senior and Exec combined",null,{"$f":"IF(AND('Targets & Inputs'!C12=\"Y\",OR(SUM(U28:AB28)=0,'Employment Equity Worksheet'!L12=0)),\"Y\",\"N\")","v":"N"}]
["Total Exco Managers",{"$f":"SUM(U28:AB28)+IF(E42=\"Y\",'Employment Equity Worksheet'!L12,0)","v":0}]
["Total Black EXCO Managers",{"$f":"SUM(W28:AB28)+IF(E42=\"Y\",'Employment Equity Worksheet'!M12,0)","v":0},null,"Total Black Management"]
["Total Black Female EXCO Managers",{"$f":"SUM(Z28:AB28)+IF(E42=\"Y\",'Employment Equity Worksheet'!N12,0)","v":0},null,"Total Black Female Management "]
[]
["Black EXCO",{"$f":"IF(B43>0,B44/B43,0)","v":0},{"$f":"IF(((B47/60%)*2)>2,2,((B47/60%)*2))","v":0}]
["Black Female EXCO",{"$f":"IF(B43>0,B45/B43,0)","v":0},{"$f":"IF(((B48/30%)*1)>1,1,((B48/30%)*1))","v":0}]
["W"]
[]
["M"]
["F"]
[]
["Non-Exec"]
["Exec"]
["Exco"]
[]
["STM"]
["OTM"]
["N/A"]
[]
["Top"]
["Senior"]
["N/A"]

{"sheet":"Employment Equity Worksheet","index":8,"n_rows":115,"n_cols":14,"rows_kept":115,"cut":false,"hidden":false,"merged":[[103,1,104,1],[8,0,9,0],[8,1,8,5],[8,6,8,10],[4,0,6,11],[0,1,0,4],[2,1,2,4],[75,1,75,6],[89,1,89,6]]}
["COMPANY NAME",{"$f":"'Global Business Solutions'!B27","v":"Test"}]
[]
["FINANCIAL INFORMATION USED",{"$f":"'Global Business Solutions'!B29","v":"2017-02-28"}]
[]
["Employment Equity "]
[]
[]
[]
["Occupational Level","Male",null,null,null,null,"Female"]
[null,"African ","Indian","Coloured","White/NSA","Sub-Total","African ","Indian","Coloured","White/NSA","Sub-Total","Total","Black","Black"]
["Top management - excluding non - executive Directors",{"$f":"'Employment Eq DATA INPUT'!V33","v":0},{"$f":"'Employment Eq DATA INPUT'!W33","v":0},{"$f":"'Employment Eq DATA INPUT'!X33","v":0},{"$f":"'Employment Eq DATA INPUT'!T33","v":0},{"$f":"SUM(B11:E11)","v":0},{"$f":"'Employment Eq DATA INPUT'!Y33","v":0},{"$f":"'Employment Eq DATA INPUT'!Z33","v":0},{"$f":"'Employment Eq DATA INPUT'!AA33","v":0},{"$f":"'Employment Eq DATA INPUT'!U33","v":0},{"$f":"SUM(G11:J11)","v":0},{"$f":"K11+F11","v":0},{"$f":"SUM(B11:D11)+N11","v":0},{"$f":"SUM(G11:I11)","v":0}]
["Senior management",{"$f":"'Employment Eq DATA INPUT'!AE33","v":0},{"$f":"'Employment Eq DATA INPUT'!AF33","v":0},{"$f":"'Employment Eq DATA INPUT'!AG33","v":0},{"$f":"'Employment Eq DATA INPUT'!AC33","v":0},{"$f":"SUM(B12:E12)","v":0},{"$f":"'Employment Eq DATA INPUT'!AH33","v":0},{"$f":"'Employment Eq DATA INPUT'!AI33","v":0},{"$f":"'Employment Eq DATA INPUT'!AJ33","v":0},{"$f":"'Employment Eq DATA INPUT'!AD33","v":0},{"$f":"SUM(G12:J12)","v":0},0,{"$f":"SUM(B12:D12)+N12","v":0},{"$f":"SUM(G12:I12)","v":0}]
["Professionally qualified and experienced specialists and mid-management",{"$f":"'Employment Eq DATA INPUT'!AN33","v":0},{"$f":"'Employment Eq DATA INPUT'!AO33","v":0},{"$f":"'Employment Eq DATA INPUT'!AP33","v":0},{"$f":"'Employment Eq DATA INPUT'!AL33","v":0},0,{"$f":"'Employment Eq DATA INPUT'!AQ33","v":0},{"$f":"'Employment Eq DATA INPUT'!AR33","v":0},{"$f":"'Employment Eq DATA INPUT'!AS33","v":0},{"$f":"'Employment Eq DATA INPUT'!AM33","v":0},0,0,0,0]
["Skilled technical and academically qualified workers, junior management, supervisors, foremen, and superintendents",{"$f":"'Employment Eq DATA INPUT'!AW33","v":0},{"$f":"'Employment Eq DATA INPUT'!AX33","v":0},{"$f":"'Employment Eq DATA INPUT'!AY33","v":0},{"$f":"'Employment Eq DATA INPUT'!AU33","v":0},0,{"$f":"'Employment Eq DATA INPUT'!AZ33","v":0},{"$f":"'Employment Eq DATA INPUT'!BA33","v":0},{"$f":"'Employment Eq DATA INPUT'!BB33","v":0},{"$f":"'Employment Eq DATA INPUT'!AV33","v":0},{"$f":"SUM(G14:J14)","v":0},0,0,0]
["Semi-skilled and discretionary decision making",{"$f":"'Employment Eq DATA INPUT'!BF33","v":0},{"$f":"'Employment Eq DATA INPUT'!BG33","v":0},{"$f":"'Employment Eq DATA INPUT'!BH33","v":0},{"$f":"'Employment Eq DATA INPUT'!BD33","v":0},0,{"$f":"'Employment Eq DATA INPUT'!BI33","v":0},{"$f":"'Employment Eq DATA INPUT'!BJ33","v":0},{"$f":"'Employment Eq DATA INPUT'!BK33","v":0},{"$f":"'Employment Eq DATA INPUT'!BE33","v":0},0,0,0,0]
["Unskilled and defined decision making",{"$f":"'Employment Eq DATA INPUT'!BO33","v":0},{"$f":"'Employment Eq DATA INPUT'!BP33","v":0},{"$f":"'Employment Eq DATA INPUT'!BQ33","v":0},{"$f":"'Employment Eq DATA INPUT'!BM33","v":0},0,{"$f":"'Employment Eq DATA INPUT'!BR33","v":0},{"$f":"'Employment Eq DATA INPUT'!BS33","v":0},{"$f":"'Employment Eq DATA INPUT'!BT33","v":0},{"$f":"'Employment Eq DATA INPUT'!BN33","v":0},0,0,0,0]
["Expats",null,null,null,null,0,null,null,null,null,{"$f":"SUM(G17:J17)","v":0},{"$f":"K17+F17","v":0},0,0]
[null,{"$f":"SUM(B11:B17)","v":0},{"$f":"SUM(C11:C17)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(L11:L17)","v":0},{"$f":"SUM(M11:M17)","v":0},{"$f":"SUM(N11:N17)","v":0}]
[]
["EAP Target",{"$f":"+'Targets & Inputs'!C26","v":0.42799999999999999},{"$f":"+'Targets & Inputs'!D26","v":1.7999999999999999E-2},{"$f":"+'Targets & Inputs'!E26","v":5.2999999999999999E-2},null,null,{"$f":"+'Targets & Inputs'!F26","v":0.35099999999999998},{"$f":"+'Targets & Inputs'!G26","v":0.01},{"$f":"+'Targets & Inputs'!H26","v":4.4999999999999998E-2}]
["Adjusted EAP",{"$f":"+'Targets & Inputs'!C27","v":0.47292817679558008},{"$f":"+'Targets & Inputs'!D27","v":1.9889502762430938E-2},{"$f":"+'Targets & Inputs'!E27","v":5.8563535911602203E-2},null,null,{"$f":"+'Targets & Inputs'!F27","v":0.38784530386740329},{"$f":"+'Targets & Inputs'!G27","v":1.1049723756906077E-2},{"$f":"+'Targets & Inputs'!H27","v":4.9723756906077346E-2}]
["Adjusted EAP - Female",null,null,null,null,null,{"$f":"ROUND(G20/SUM($G$20:$I$20),4)","v":0.86450000000000005},{"$f":"ROUND(H20/SUM($G$20:$I$20),4)","v":2.46E-2},{"$f":"ROUND(I20/SUM($G$20:$I$20),4)","v":0.1108}]
[]
[null,"Senior Management","Middle Management","Junior Management",null,null,"Senior Management","Middle Management","Junior Management"]
["Points",{"$f":"+Scorecard!F23","v":2},{"$f":"+Scorecard!F25","v":2},{"$f":"+Scorecard!F27","v":1},null,null,{"$f":"+Scorecard!F24","v":1},{"$f":"+Scorecard!F26","v":1},{"$f":"+Scorecard!F28","v":1}]
["Target",{"$f":"+Scorecard!E23","v":0.6},{"$f":"+Scorecard!E25","v":0.75},{"$f":"+Scorecard!E27","v":0.88},null,null,{"$f":"+Scorecard!E24","v":0.3},{"$f":"+Scorecard!E26","v":0.38},{"$f":"+Scorecard!E28","v":0.44}]
[]
["Senior Management"]
["Points per Category",{"$f":"ROUND(B21*$B$25,2)","v":0.95},{"$f":"ROUND(C21*$B$25,2)","v":0.04},{"$f":"ROUND(D21*$B$25,2)","v":0.12},null,null,{"$f":"ROUND(G21*$B$25,2)","v":0.78},{"$f":"ROUND(H21*$B$25,2)","v":0.02},{"$f":"ROUND(I21*$B$25,2)","v":0.1}]
["Target per category",{"$f":"ROUND($B$26*B21,4)","v":0.2838},{"$f":"ROUND($B$26*C21,4)","v":1.1900000000000001E-2},{"$f":"ROUND($B$26*D21,4)","v":3.5099999999999999E-2},null,null,{"$f":"ROUND($B$26*G21,4)","v":0.23269999999999999},{"$f":"ROUND($B$26*H21,4)","v":6.6E-3},{"$f":"ROUND($B$26*I21,4)","v":2.98E-2}]
[]
["Percentage Black",{"$f":"IF($L$12>0,B12/$L$12,0)","v":0},{"$f":"IF($L$12>0,C12/$L$12,0)","v":0},0,0,null,0,0,0,0]
["Percentage Achieved",{"$f":"+B32/B30","v":0},{"$f":"+C32/C30","v":0},0,null,null,0,0,0]
["Points",{"$f":"IF(B32/B30*B29>B29,B29,ROUND(B32/B30*B29,2))","v":0},{"$f":"IF(C32/C30*C29>C29,C29,ROUND(C32/C30*C29,2))","v":0},{"$f":"IF(D32/D30*D29>D29,D29,ROUND(D32/D30*D29,2))","v":0},null,null,{"$f":"IF(G32/G30*G29>G29,G29,ROUND(G32/G30*G29,2))","v":0},{"$f":"IF(H32/H30*H29>H29,H29,ROUND(H32/H30*H29,2))","v":0},{"$f":"IF(I32/I30*I29>I29,I29,ROUND(I32/I30*I29,2))","v":0}]
[]
["Points per Category - BF",null,null,null,null,null,{"$f":"ROUND(G22*$G$25,2)","v":0.86},{"$f":"ROUND(H22*$G$25,2)","v":0.02},{"$f":"ROUND(I22*$G$25,2)","v":0.11}]
["Target per category - BF",null,null,null,null,null,{"$f":"ROUND(G22*$G$26,4)","v":0.25940000000000002},{"$f":"ROUND(H22*$G$26,4)","v":7.4000000000000003E-3},{"$f":"ROUND(I22*$G$26,4)","v":3.32E-2}]
[]
["Percentage Black - BF",null,null,null,null,null,{"$f":"IF($L$12>0,G12/$L$12,0)","v":0},{"$f":"IF($L$12>0,H12/$L$12,0)","v":0},{"$f":"IF($L$12>0,I12/$L$12,0)","v":0},{"$f":"IF($L$12>0,J12/$L$12,0)","v":0}]
["Percentage Achieved - BF",null,null,null,null,null,{"$f":"G32/G37","v":0},{"$f":"H32/H37","v":0},{"$f":"I32/I37","v":0}]
["Points - BF",null,null,null,null,null,{"$f":"IF(G32/G37*G36>G36,G36,ROUND(G32/G37*G36,2))","v":0},{"$f":"IF(H32/H37*H36>H36,H36,ROUND(H32/H37*H36,2))","v":0},{"$f":"IF(I32/I37*I36>I36,I36,ROUND(I32/I37*I36,2))","v":0}]
[]
["Middle Management"]
["Points per Category",{"$f":"ROUND(B21*$C$25,2)","v":0.95},{"$f":"ROUND(C21*$C$25,2)","v":0.04},{"$f":"ROUND(D21*$C$25,2)","v":0.12},null,null,{"$f":"ROUND(G21*$C$25,2)","v":0.78},{"$f":"ROUND(H21*$C$25,2)","v":0.02},{"$f":"ROUND(I21*$C$25,2)","v":0.1}]
["Target per category",{"$f":"ROUND($C$26*B21,4)","v":0.35470000000000002},{"$f":"ROUND($C$26*C21,4)","v":1.49E-2},{"$f":"ROUND($C$26*D21,4)","v":4.3900000000000002E-2},null,null,{"$f":"ROUND($C$26*G21,4)","v":0.29089999999999999},{"$f":"ROUND($C$26*H21,4)","v":8.3000000000000001E-3},{"$f":"ROUND($C$26*I21,4)","v":3.73E-2}]
[]
["Percentage Black",{"$f":"IF($L$13>0,B13/$L$13,0)","v":0},{"$f":"IF($L$13>0,C13/$L$13,0)","v":0},0,0,null,0,0,0,0]
["Percentage Achieved",{"$f":"+B47/B45","v":0},{"$f":"+C47/C45","v":0},{"$f":"+D47/D45","v":0},null,null,{"$f":"+G47/G45","v":0},{"$f":"+H47/H45","v":0},{"$f":"+I47/I45","v":0}]
["Points",{"$f":"IF(B47/B45*B44>B44,B44,ROUND(B47/B45*B44,2))","v":0},{"$f":"IF(C47/C45*C44>C44,C44,ROUND(C47/C45*C44,2))","v":0},{"$f":"IF(D47/D45*D44>D44,D44,ROUND(D47/D45*D44,2))","v":0},null,null,{"$f":"IF(G47/G45*G44>G44,G44,ROUND(G47/G45*G44,2))","v":0},{"$f":"IF(H47/H45*H44>H44,H44,ROUND(H47/H45*H44,2))","v":0},{"$f":"IF(I47/I45*I44>I44,I44,ROUND(I47/I45*I44,2))","v":0}]
[]
["Points per Category",null,null,null,null,null,{"$f":"ROUND(G22*$H$25,2)","v":0.86},{"$f":"ROUND(H22*$H$25,2)","v":0.02},{"$f":"ROUND(I22*$H$25,2)","v":0.11}]
["Target per category",null,null,null,null,null,{"$f":"ROUND(G22*$H$26,4)","v":0.32850000000000001},{"$f":"ROUND(H22*$H$26,4)","v":9.2999999999999992E-3},{"$f":"ROUND(I22*$H$26,4)","v":4.2099999999999999E-2}]
[]
["Percentage Black - BF",null,null,null,null,null,{"$f":"IF($L$13>0,G13/$L$13,0)","v":0},{"$f":"IF($L$13>0,H13/$L$13,0)","v":0},{"$f":"IF($L$13>0,I13/$L$13,0)","v":0},{"$f":"IF($L$13>0,J13/$L$13,0)","v":0}]
["Percentage Achieved - BF",null,null,null,null,null,{"$f":"+G54/G52","v":0},{"$f":"+H54/H52","v":0},{"$f":"+I54/I52","v":0}]
["Points - BF",null,null,null,null,null,{"$f":"IF(G54/G52*G51>G51,G51,ROUND(G54/G52*G51,2))","v":0},{"$f":"IF(H54/H52*H51>H51,H51,ROUND(H54/H52*H51,2))","v":0},{"$f":"IF(I54/I52*I51>I51,I51,ROUND(I54/I52*I51,2))","v":0}]
[]
["Junior Management"]
["Points per Category",{"$f":"ROUND($D$25*B21,2)","v":0.47},{"$f":"ROUND($D$25*C21,2)","v":0.02},{"$f":"ROUND($D$25*D21,2)","v":0.06},null,null,{"$f":"ROUND($D$25*G21,2)","v":0.39},{"$f":"ROUND($D$25*H21,2)","v":0.01},{"$f":"ROUND($D$25*I21,2)","v":0.05}]
["Target per category",{"$f":"ROUND($D$26*B21,4)","v":0.41620000000000001},{"$f":"ROUND($D$26*C21,4)","v":1.7500000000000002E-2},{"$f":"ROUND($D$26*D21,4)","v":5.1499999999999997E-2},null,null,{"$f":"ROUND($D$26*G21,4)","v":0.34129999999999999},{"$f":"ROUND($D$26*H21,4)","v":9.7000000000000003E-3},{"$f":"ROUND($D$26*I21,4)","v":4.3799999999999999E-2}]
[]
["Percentage Black",{"$f":"IF($L$14>0,B14/$L$14,0)","v":0},{"$f":"IF($L$14>0,C14/$L$14,0)","v":0},{"$f":"IF($L$14>0,D14/$L$14,0)","v":0},{"$f":"IF($L$14>0,E14/$L$14,0)","v":0},null,{"$f":"IF($L$14>0,G14/$L$14,0)","v":0},{"$f":"IF($L$14>0,H14/$L$14,0)","v":0},{"$f":"IF($L$14>0,I14/$L$14,0)","v":0},{"$f":"IF($L$14>0,J14/$L$14,0)","v":0}]
["Percentage Achieved",{"$f":"+B62/B60","v":0},{"$f":"+C62/C60","v":0},{"$f":"+D62/D60","v":0},null,null,{"$f":"+G62/G60","v":0},{"$f":"+H62/H60","v":0},{"$f":"+I62/I60","v":0}]
["Points",{"$f":"IF(B62/B60*B59>B59,B59,ROUND(B62/B60*B59,2))","v":0},{"$f":"IF(C62/C60*C59>C59,C59,ROUND(C62/C60*C59,2))","v":0},{"$f":"IF(D62/D60*D59>D59,D59,ROUND(D62/D60*D59,2))","v":0},null,null,{"$f":"IF(G62/G60*G59>G59,G59,ROUND(G62/G60*G59,2))","v":0},{"$f":"IF(H62/H60*H59>H59,H59,ROUND(H62/H60*H59,2))","v":0},{"$f":"IF(I62/I60*I59>I59,I59,ROUND(I62/I60*I59,2))","v":0}]
[]
["Points per Category",null,null,null,null,null,{"$f":"ROUND($I$25*G22,2)","v":0.86},{"$f":"ROUND($I$25*H22,2)","v":0.02},{"$f":"ROUND($I$25*I22,2)","v":0.11}]
["Target per category",null,null,null,null,null,{"$f":"ROUND(G22*$I$26,4)","v":0.38040000000000002},{"$f":"ROUND(H22*$I$26,4)","v":1.0800000000000001E-2},{"$f":"ROUND(I22*$I$26,4)","v":4.8800000000000003E-2}]
[]
["Percentage Black",null,null,null,null,null,{"$f":"IF($L$14>0,G14/$L$14,0)","v":0},{"$f":"IF($L$14>0,H14/$L$14,0)","v":0},{"$f":"IF($L$14>0,I14/$L$14,0)","v":0},{"$f":"IF($L$14>0,J14/$L$14,0)","v":0}]
["Percentage Achieved",null,null,null,null,null,{"$f":"+G69/G67","v":0},{"$f":"+H69/H67","v":0},{"$f":"+I69/I67","v":0}]
["Points",null,null,null,null,null,{"$f":"IF(G69/G67*G66>G66,G66,ROUND(G69/G67*G66,2))","v":0},{"$f":"IF(H69/H67*H66>H66,H66,ROUND(H69/H67*H66,2))","v":0},{"$f":"IF(I69/I67*I66>I66,I66,ROUND(I69/I67*I66,2))","v":0}]
[]
[]
["Calculations"]
[]
["Occupational Level","Male"]
[null,"African","Indian","Coloured","Total Black Male","White/ NSA","Total Male"]
["Top Management",{"$f":"B11","v":0},0,0,{"$f":"SUM(B78:D78)","v":0},{"$f":"E11","v":0},{"$f":"+E78+F78","v":0}]
["Senior Management",0,0,0,0,0,0]
["Professionally Qualified and Experienced Specialist and Mid-management",0,0,0,0,0,0]
["Skilled Technical and academically qualified workers, junior management, supervisors, foremen, and superintendents",0,0,0,0,0,0]
["Semi-Skilled and discretionary decision making",0,0,0,0,0,0]
["Unskilled and defined decision making",0,0,0,0,0,0]
["Total Permanent Employees ",{"$f":"SUM(B78:B83)","v":0},0,0,0,0,0]
["Total Disabled Employees",{"$f":"'Employment Eq DATA INPUT'!M33","v":0},{"$f":"'Employment Eq DATA INPUT'!N33","v":0},{"$f":"'Employment Eq DATA INPUT'!O33","v":0},{"$f":"SUM(B85:D85)","v":0},{"$f":"'Employment Eq DATA INPUT'!K33","v":0},{"$f":"SUM(E85:F85)","v":0}]
["Top Management used in EXCO",{"$f":"Management!O29","v":0},{"$f":"Management!P29","v":0},{"$f":"Management!Q29","v":0},{"$f":"SUM(B86:D86)","v":0},{"$f":"Management!M29","v":0},{"$f":"SUM(E86:F86)","v":0}]
["Percentage Black",{"$f":"IF($L$18>0,B84/$L$18,0)","v":0},0,0,{"$f":"SUM(B87:D87)","v":0},{"$f":"IF($L$18>0,F84/$L$18,0)","v":0},{"$f":"+E87+F87","v":0}]
["Percentage Black - Disabled",0,0,0,{"$f":"SUM(B88:D88)","v":0},{"$f":"IF($L$18>0,F85/$L$18,0)","v":0},{"$f":"+E88+F88","v":0}]
[]
["Occupational Level","Female"]
[null,"African","Indian","Coloured","Total Black Female","White/ NSA","Sub-Total"]
["Top Management",{"$f":"G11","v":0},0,0,{"$f":"SUM(B92:D92)","v":0},{"$f":"J11","v":0},{"$f":"+E92+F92","v":0}]
["Senior Management",0,0,0,0,0,0]
["Professionally Qualified and Experienced Specialist and Mid-management",0,0,0,0,0,0]
["Skilled Technical and academically qualified workers, junior management, supervisors, foremen, and superintendents",0,0,0,0,0,0]
["Semi-Skilled and discretionary decision making",0,0,0,0,0,0]
["Unskilled and defined decision making",0,0,0,0,0,0]
["Total Permanent Employees ",{"$f":"SUM(B92:B97)","v":0},0,0,0,0,0]
["Total Disabled Employees",{"$f":"'Employment Eq DATA INPUT'!P33","v":0},{"$f":"'Employment Eq DATA INPUT'!Q33","v":0},{"$f":"'Employment Eq DATA INPUT'!R33","v":0},{"$f":"SUM(B99:D99)","v":0},{"$f":"'Employment Eq DATA INPUT'!L33","v":0},{"$f":"SUM(E99:F99)","v":0}]
["Top Management used in EXCO",{"$f":"Management!R29","v":0},{"$f":"Management!S29","v":0},{"$f":"Management!T29","v":0},{"$f":"SUM(B100:D100)","v":0},{"$f":"Management!N29","v":0},{"$f":"SUM(E100:F100)","v":0}]
["Percentage Black",{"$f":"IF($L$18>0,B98/$L$18,0)","v":0},0,0,{"$f":"SUM(B101:D101)","v":0},{"$f":"IF($L$18>0,F98/$L$18,0)","v":0},{"$f":"+E101+F101","v":0}]
["Percentage Black - Disabled",0,0,0,{"$f":"SUM(B102:D102)","v":0},{"$f":"IF($L$18>0,F99/$L$18,0)","v":0},{"$f":"+E102+F102","v":0}]
[]
["Occupational Level","Total"]
[]
["Top Management",{"$f":"SUM(G78+G92)","v":0}]
["Senior Management",0]
["Professionally Qualified and Experienced Specialist and Mid-management",0]
["Skilled Technical and academically qualified workers, junior management, supervisors, foremen, and superintendents",0]
["Semi-Skilled and discretionary decision making",0]
["Unskilled and defined decision making",0]
["Total Permanent Employees ",{"$f":"SUM(B106:B111)","v":0}]
["Total Disabled Employees",{"$f":"SUM(G85+G99)","v":0}]
["Top Management used in EXCO",{"$f":"G100+G86","v":0}]
["Disabled People",{"$f":"IF(B112>0,(E85+E99)/(B112),0)","v":0}]

{"sheet":"Employment Eq DATA INPUT","index":9,"n_rows":33,"n_cols":73,"rows_kept":33,"cut":false,"hidden":false,"merged":[[0,2,0,5],[2,2,2,5],[4,0,6,72],[10,64,10,72],[10,46,10,54],[10,10,10,18],[10,28,10,36],[10,37,10,45],[10,55,10,63],[10,19,10,27],[8,2,9,8]]}
["COMPANY NAME",null,{"$f":"'Global Business Solutions'!B27","v":"Test"}]
[]
["FINANCIAL INFORMATION USED",null,{"$f":"'Global Business Solutions'!B29","v":"2017-02-28"}]
[]
["Employment Equity Data"]
[]
[]
[]
["Instructions:",null,"Complete information regarding details of employees and management with the latest available data.  Only include those who are permanently employed or those who have a employment contract for longer than 3 continuous months "]
[]
[null,null,null,null,null,null,null,null,null,null,"Disabled",null,null,null,null,null,null,null,null,"Top Management (T)",null,null,null,null,null,null,null,null,"Senior Management (S)",null,null,null,null,null,null,null,null,"Middle Management (M)",null,null,null,null,null,null,null,null,"Junior Management (J)",null,null,null,null,null,null,null,null,"'Semi-Skilled' (SS)",null,null,null,null,null,null,null,null,"'Unskilled' (US)"]
["Name","EE Number","Identity Number","RSA Citizen (Y/N)","Race (A/I/C/W) - Please indicate Non SA Citizen as \"W\"","Gender (M/F)","Disabled (Y/N) - Only Input Medically certified disabilities","Nature of Disability","Position","Occupational Level (T/S/M/J/SS/US)","White or NSA Male","White or NSA Female","African Male","Indian Male","Coloured Male","African Female","Indian Female","Coloured Female","Total","White or NSA Male","White or NSA Female","African Male","Indian Male","Coloured Male","African Female","Indian Female","Coloured Female","Total","White or NSA Male","White or NSA Female","African Male","Indian Male","Coloured Male","African Female","Indian Female","Coloured Female","Total","White or NSA Male","White or NSA Female","African Male","Indian Male","Coloured Male","African Female","Indian Female","Coloured Female","Total ","White or NSA Male","White or NSA Female","African Male","Indian Male","Coloured Male","African Female","Indian Female","Coloured Female","Total","White or NSA Male","White or NSA Female","African Male","Indian Male","Coloured Male","African Female","Indian Female","Coloured Female","Total","White or NSA Male","White or NSA Female","African Male","Indian Male","Coloured Male","African Female","Indian Female","Coloured Female","Total"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(F13=\"M\",D13=\"y\",E13=\"W\",G13=\"Y\"),1,0)","v":0},{"$f":"IF(AND(F13=\"F\",D13=\"y\",E13=\"W\",G13=\"Y\"),1,0)","v":0},{"$f":"IF(AND(F13=\"M\",D13=\"y\",E13=\"A\",G13=\"Y\"),1,0)","v":0},{"$f":"IF(AND(F13=\"M\",D13=\"y\",E13=\"I\",G13=\"Y\"),1,0)","v":0},{"$f":"IF(AND(F13=\"M\",D13=\"y\",E13=\"C\",G13=\"Y\"),1,0)","v":0},{"$f":"IF(AND(F13=\"F\",D13=\"y\",E13=\"A\",G13=\"Y\"),1,0)","v":0},{"$f":"IF(AND(F13=\"F\",D13=\"y\",E13=\"I\",G13=\"Y\"),1,0)","v":0},{"$f":"IF(AND(F13=\"F\",D13=\"y\",E13=\"C\",G13=\"Y\"),1,0)","v":0},{"$f":"SUM(K13:R13)","v":0},{"$f":"IF(AND(F13=\"M\",J13=\"T\",E13=\"W\"),1,0)","v":0},{"$f":"IF(AND(F13=\"F\",J13=\"T\",E13=\"W\"),1,0)","v":0},{"$f":"IF(AND(F13=\"M\",J13=\"T\",E13=\"A\"),1,0)","v":0},{"$f":"IF(AND(F13=\"M\",J13=\"T\",E13=\"I\"),1,0)","v":0},{"$f":"IF(AND(F13=\"M\",J13=\"T\",E13=\"C\"),1,0)","v":0},{"$f":"IF(AND(F13=\"F\",J13=\"T\",E13=\"A\"),1,0)","v":0},{"$f":"IF(AND(F13=\"F\",J13=\"T\",E13=\"I\"),1,0)","v":0},{"$f":"IF(AND(F13=\"F\",J13=\"T\",E13=\"C\"),1,0)","v":0},{"$f":"SUM(T13:AA13)","v":0},{"$f":"IF(AND(F13=\"M\",J13=\"S\",E13=\"W\"),1,0)","v":0},{"$f":"IF(AND(F13=\"F\",J13=\"S\",E13=\"W\"),1,0)","v":0},{"$f":"IF(AND(F13=\"M\",J13=\"S\",E13=\"A\"),1,0)","v":0},{"$f":"IF(AND(F13=\"M\",J13=\"S\",E13=\"I\"),1,0)","v":0},{"$f":"IF(AND(F13=\"M\",J13=\"S\",E13=\"C\"),1,0)","v":0},{"$f":"IF(AND(F13=\"F\",J13=\"S\",E13=\"A\"),1,0)","v":0},{"$f":"IF(AND(F13=\"F\",J13=\"S\",E13=\"I\"),1,0)","v":0},{"$f":"IF(AND(F13=\"F\",J13=\"S\",E13=\"C\"),1,0)","v":0},{"$f":"SUM(AC13:AJ13)","v":0},{"$f":"IF(AND(F13=\"M\",J13=\"M\",E13=\"W\"),1,0)","v":0},{"$f":"IF(AND(F13=\"F\",J13=\"M\",E13=\"W\"),1,0)","v":0},{"$f":"IF(AND(F13=\"M\",J13=\"M\",E13=\"A\"),1,0)","v":0},{"$f":"IF(AND(F13=\"M\",J13=\"M\",E13=\"I\"),1,0)","v":0},{"$f":"IF(AND(F13=\"M\",J13=\"M\",E13=\"C\"),1,0)","v":0},{"$f":"IF(AND(F13=\"F\",J13=\"M\",E13=\"A\"),1,0)","v":0},{"$f":"IF(AND(F13=\"F\",J13=\"M\",E13=\"I\"),1,0)","v":0},{"$f":"IF(AND(F13=\"F\",J13=\"M\",E13=\"C\"),1,0)","v":0},{"$f":"SUM(AL13:AS13)","v":0},{"$f":"IF(AND(F13=\"M\",J13=\"J\",E13=\"W\"),1,0)","v":0},{"$f":"IF(AND(F13=\"F\",J13=\"J\",E13=\"W\"),1,0)","v":0},{"$f":"IF(AND(F13=\"M\",J13=\"J\",E13=\"A\"),1,0)","v":0},{"$f":"IF(AND(F13=\"M\",J13=\"J\",E13=\"I\"),1,0)","v":0},{"$f":"IF(AND(F13=\"M\",J13=\"J\",E13=\"C\"),1,0)","v":0},{"$f":"IF(AND(F13=\"F\",J13=\"J\",E13=\"A\"),1,0)","v":0},{"$f":"IF(AND(F13=\"F\",J13=\"J\",E13=\"I\"),1,0)","v":0},{"$f":"IF(AND(F13=\"F\",J13=\"J\",E13=\"C\"),1,0)","v":0},{"$f":"SUM(AU13:BB13)","v":0},{"$f":"IF(AND(F13=\"M\",J13=\"SS\",E13=\"W\"),1,0)","v":0},{"$f":"IF(AND(F13=\"F\",J13=\"SS\",E13=\"W\"),1,0)","v":0},{"$f":"IF(AND(F13=\"M\",J13=\"SS\",E13=\"A\"),1,0)","v":0},{"$f":"IF(AND(F13=\"M\",J13=\"SS\",E13=\"I\"),1,0)","v":0},{"$f":"IF(AND(F13=\"M\",J13=\"SS\",E13=\"C\"),1,0)","v":0},{"$f":"IF(AND(F13=\"F\",J13=\"SS\",E13=\"A\"),1,0)","v":0},{"$f":"IF(AND(F13=\"F\",J13=\"SS\",E13=\"I\"),1,0)","v":0},{"$f":"IF(AND(F13=\"F\",J13=\"SS\",E13=\"C\"),1,0)","v":0},{"$f":"SUM(BD13:BK13)","v":0},{"$f":"IF(AND(F13=\"M\",J13=\"US\",E13=\"W\"),1,0)","v":0},{"$f":"IF(AND(F13=\"F\",J13=\"US\",E13=\"W\"),1,0)","v":0},{"$f":"IF(AND(F13=\"M\",J13=\"US\",E13=\"A\"),1,0)","v":0},{"$f":"IF(AND(F13=\"M\",J13=\"US\",E13=\"I\"),1,0)","v":0},{"$f":"IF(AND(F13=\"M\",J13=\"US\",E13=\"C\"),1,0)","v":0},{"$f":"IF(AND(F13=\"F\",J13=\"US\",E13=\"A\"),1,0)","v":0},{"$f":"IF(AND(F13=\"F\",J13=\"US\",E13=\"I\"),1,0)","v":0},{"$f":"IF(AND(F13=\"F\",J13=\"US\",E13=\"C\"),1,0)","v":0},{"$f":"SUM(BM13:BT13)","v":0}]
[null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(F16=\"M\",D16=\"y\",E16=\"W\",G16=\"Y\"),1,0)","v":0},{"$f":"IF(AND(F16=\"F\",D16=\"y\",E16=\"W\",G16=\"Y\"),1,0)","v":0},{"$f":"IF(AND(F16=\"M\",D16=\"y\",E16=\"A\",G16=\"Y\"),1,0)","v":0},{"$f":"IF(AND(F16=\"M\",D16=\"y\",E16=\"I\",G16=\"Y\"),1,0)","v":0},{"$f":"IF(AND(F16=\"M\",D16=\"y\",E16=\"C\",G16=\"Y\"),1,0)","v":0},{"$f":"IF(AND(F16=\"F\",D16=\"y\",E16=\"A\",G16=\"Y\"),1,0)","v":0},{"$f":"IF(AND(F16=\"F\",D16=\"y\",E16=\"I\",G16=\"Y\"),1,0)","v":0},{"$f":"IF(AND(F16=\"F\",D16=\"y\",E16=\"C\",G16=\"Y\"),1,0)","v":0},{"$f":"SUM(K16:R16)","v":0},{"$f":"IF(AND(F16=\"M\",J16=\"T\",E16=\"W\"),1,0)","v":0},{"$f":"IF(AND(F16=\"F\",J16=\"T\",E16=\"W\"),1,0)","v":0},{"$f":"IF(AND(F16=\"M\",J16=\"T\",E16=\"A\"),1,0)","v":0},{"$f":"IF(AND(F16=\"M\",J16=\"T\",E16=\"I\"),1,0)","v":0},{"$f":"IF(AND(F16=\"M\",J16=\"T\",E16=\"C\"),1,0)","v":0},{"$f":"IF(AND(F16=\"F\",J16=\"T\",E16=\"A\"),1,0)","v":0},{"$f":"IF(AND(F16=\"F\",J16=\"T\",E16=\"I\"),1,0)","v":0},{"$f":"IF(AND(F16=\"F\",J16=\"T\",E16=\"C\"),1,0)","v":0},{"$f":"SUM(T16:AA16)","v":0},{"$f":"IF(AND(F16=\"M\",J16=\"S\",E16=\"W\"),1,0)","v":0},{"$f":"IF(AND(F16=\"F\",J16=\"S\",E16=\"W\"),1,0)","v":0},{"$f":"IF(AND(F16=\"M\",J16=\"S\",E16=\"A\"),1,0)","v":0},{"$f":"IF(AND(F16=\"M\",J16=\"S\",E16=\"I\"),1,0)","v":0},{"$f":"IF(AND(F16=\"M\",J16=\"S\",E16=\"C\"),1,0)","v":0},{"$f":"IF(AND(F16=\"F\",J16=\"S\",E16=\"A\"),1,0)","v":0},{"$f":"IF(AND(F16=\"F\",J16=\"S\",E16=\"I\"),1,0)","v":0},{"$f":"IF(AND(F16=\"F\",J16=\"S\",E16=\"C\"),1,0)","v":0},{"$f":"SUM(AC16:AJ16)","v":0},{"$f":"IF(AND(F16=\"M\",J16=\"M\",E16=\"W\"),1,0)","v":0},{"$f":"IF(AND(F16=\"F\",J16=\"M\",E16=\"W\"),1,0)","v":0},{"$f":"IF(AND(F16=\"M\",J16=\"M\",E16=\"A\"),1,0)","v":0},{"$f":"IF(AND(F16=\"M\",J16=\"M\",E16=\"I\"),1,0)","v":0},{"$f":"IF(AND(F16=\"M\",J16=\"M\",E16=\"C\"),1,0)","v":0},{"$f":"IF(AND(F16=\"F\",J16=\"M\",E16=\"A\"),1,0)","v":0},{"$f":"IF(AND(F16=\"F\",J16=\"M\",E16=\"I\"),1,0)","v":0},{"$f":"IF(AND(F16=\"F\",J16=\"M\",E16=\"C\"),1,0)","v":0},{"$f":"SUM(AL16:AS16)","v":0},{"$f":"IF(AND(F16=\"M\",J16=\"J\",E16=\"W\"),1,0)","v":0},{"$f":"IF(AND(F16=\"F\",J16=\"J\",E16=\"W\"),1,0)","v":0},{"$f":"IF(AND(F16=\"M\",J16=\"J\",E16=\"A\"),1,0)","v":0},{"$f":"IF(AND(F16=\"M\",J16=\"J\",E16=\"I\"),1,0)","v":0},{"$f":"IF(AND(F16=\"M\",J16=\"J\",E16=\"C\"),1,0)","v":0},{"$f":"IF(AND(F16=\"F\",J16=\"J\",E16=\"A\"),1,0)","v":0},{"$f":"IF(AND(F16=\"F\",J16=\"J\",E16=\"I\"),1,0)","v":0},{"$f":"IF(AND(F16=\"F\",J16=\"J\",E16=\"C\"),1,0)","v":0},{"$f":"SUM(AU16:BB16)","v":0},{"$f":"IF(AND(F16=\"M\",J16=\"SS\",E16=\"W\"),1,0)","v":0},{"$f":"IF(AND(F16=\"F\",J16=\"SS\",E16=\"W\"),1,0)","v":0},{"$f":"IF(AND(F16=\"M\",J16=\"SS\",E16=\"A\"),1,0)","v":0},{"$f":"IF(AND(F16=\"M\",J16=\"SS\",E16=\"I\"),1,0)","v":0},{"$f":"IF(AND(F16=\"M\",J16=\"SS\",E16=\"C\"),1,0)","v":0},{"$f":"IF(AND(F16=\"F\",J16=\"SS\",E16=\"A\"),1,0)","v":0},{"$f":"IF(AND(F16=\"F\",J16=\"SS\",E16=\"I\"),1,0)","v":0},{"$f":"IF(AND(F16=\"F\",J16=\"SS\",E16=\"C\"),1,0)","v":0},{"$f":"SUM(BD16:BK16)","v":0},{"$f":"IF(AND(F16=\"M\",J16=\"US\",E16=\"W\"),1,0)","v":0},{"$f":"IF(AND(F16=\"F\",J16=\"US\",E16=\"W\"),1,0)","v":0},{"$f":"IF(AND(F16=\"M\",J16=\"US\",E16=\"A\"),1,0)","v":0},{"$f":"IF(AND(F16=\"M\",J16=\"US\",E16=\"I\"),1,0)","v":0},{"$f":"IF(AND(F16=\"M\",J16=\"US\",E16=\"C\"),1,0)","v":0},{"$f":"IF(AND(F16=\"F\",J16=\"US\",E16=\"A\"),1,0)","v":0},{"$f":"IF(AND(F16=\"F\",J16=\"US\",E16=\"I\"),1,0)","v":0},{"$f":"IF(AND(F16=\"F\",J16=\"US\",E16=\"C\"),1,0)","v":0},{"$f":"SUM(BM16:BT16)","v":0}]
[null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(F31=\"M\",D31=\"y\",E31=\"W\",G31=\"Y\"),1,0)","v":0},{"$f":"IF(AND(F31=\"F\",D31=\"y\",E31=\"W\",G31=\"Y\"),1,0)","v":0},{"$f":"IF(AND(F31=\"M\",D31=\"y\",E31=\"A\",G31=\"Y\"),1,0)","v":0},{"$f":"IF(AND(F31=\"M\",D31=\"y\",E31=\"I\",G31=\"Y\"),1,0)","v":0},{"$f":"IF(AND(F31=\"M\",D31=\"y\",E31=\"C\",G31=\"Y\"),1,0)","v":0},{"$f":"IF(AND(F31=\"F\",D31=\"y\",E31=\"A\",G31=\"Y\"),1,0)","v":0},{"$f":"IF(AND(F31=\"F\",D31=\"y\",E31=\"I\",G31=\"Y\"),1,0)","v":0},{"$f":"IF(AND(F31=\"F\",D31=\"y\",E31=\"C\",G31=\"Y\"),1,0)","v":0},{"$f":"SUM(K31:R31)","v":0},{"$f":"IF(AND(F31=\"M\",J31=\"T\",E31=\"W\"),1,0)","v":0},{"$f":"IF(AND(F31=\"F\",J31=\"T\",E31=\"W\"),1,0)","v":0},{"$f":"IF(AND(F31=\"M\",J31=\"T\",E31=\"A\"),1,0)","v":0},{"$f":"IF(AND(F31=\"M\",J31=\"T\",E31=\"I\"),1,0)","v":0},{"$f":"IF(AND(F31=\"M\",J31=\"T\",E31=\"C\"),1,0)","v":0},{"$f":"IF(AND(F31=\"F\",J31=\"T\",E31=\"A\"),1,0)","v":0},{"$f":"IF(AND(F31=\"F\",J31=\"T\",E31=\"I\"),1,0)","v":0},{"$f":"IF(AND(F31=\"F\",J31=\"T\",E31=\"C\"),1,0)","v":0},{"$f":"SUM(T31:AA31)","v":0},{"$f":"IF(AND(F31=\"M\",J31=\"S\",E31=\"W\"),1,0)","v":0},{"$f":"IF(AND(F31=\"F\",J31=\"S\",E31=\"W\"),1,0)","v":0},{"$f":"IF(AND(F31=\"M\",J31=\"S\",E31=\"A\"),1,0)","v":0},{"$f":"IF(AND(F31=\"M\",J31=\"S\",E31=\"I\"),1,0)","v":0},{"$f":"IF(AND(F31=\"M\",J31=\"S\",E31=\"C\"),1,0)","v":0},{"$f":"IF(AND(F31=\"F\",J31=\"S\",E31=\"A\"),1,0)","v":0},{"$f":"IF(AND(F31=\"F\",J31=\"S\",E31=\"I\"),1,0)","v":0},{"$f":"IF(AND(F31=\"F\",J31=\"S\",E31=\"C\"),1,0)","v":0},{"$f":"SUM(AC31:AJ31)","v":0},{"$f":"IF(AND(F31=\"M\",J31=\"M\",E31=\"W\"),1,0)","v":0},{"$f":"IF(AND(F31=\"F\",J31=\"M\",E31=\"W\"),1,0)","v":0},{"$f":"IF(AND(F31=\"M\",J31=\"M\",E31=\"A\"),1,0)","v":0},{"$f":"IF(AND(F31=\"M\",J31=\"M\",E31=\"I\"),1,0)","v":0},{"$f":"IF(AND(F31=\"M\",J31=\"M\",E31=\"C\"),1,0)","v":0},{"$f":"IF(AND(F31=\"F\",J31=\"M\",E31=\"A\"),1,0)","v":0},{"$f":"IF(AND(F31=\"F\",J31=\"M\",E31=\"I\"),1,0)","v":0},{"$f":"IF(AND(F31=\"F\",J31=\"M\",E31=\"C\"),1,0)","v":0},{"$f":"SUM(AL31:AS31)","v":0},{"$f":"IF(AND(F31=\"M\",J31=\"J\",E31=\"W\"),1,0)","v":0},{"$f":"IF(AND(F31=\"F\",J31=\"J\",E31=\"W\"),1,0)","v":0},{"$f":"IF(AND(F31=\"M\",J31=\"J\",E31=\"A\"),1,0)","v":0},{"$f":"IF(AND(F31=\"M\",J31=\"J\",E31=\"I\"),1,0)","v":0},{"$f":"IF(AND(F31=\"M\",J31=\"J\",E31=\"C\"),1,0)","v":0},{"$f":"IF(AND(F31=\"F\",J31=\"J\",E31=\"A\"),1,0)","v":0},{"$f":"IF(AND(F31=\"F\",J31=\"J\",E31=\"I\"),1,0)","v":0},{"$f":"IF(AND(F31=\"F\",J31=\"J\",E31=\"C\"),1,0)","v":0},{"$f":"SUM(AU31:BB31)","v":0},{"$f":"IF(AND(F31=\"M\",J31=\"SS\",E31=\"W\"),1,0)","v":0},{"$f":"IF(AND(F31=\"F\",J31=\"SS\",E31=\"W\"),1,0)","v":0},{"$f":"IF(AND(F31=\"M\",J31=\"SS\",E31=\"A\"),1,0)","v":0},{"$f":"IF(AND(F31=\"M\",J31=\"SS\",E31=\"I\"),1,0)","v":0},{"$f":"IF(AND(F31=\"M\",J31=\"SS\",E31=\"C\"),1,0)","v":0},{"$f":"IF(AND(F31=\"F\",J31=\"SS\",E31=\"A\"),1,0)","v":0},{"$f":"IF(AND(F31=\"F\",J31=\"SS\",E31=\"I\"),1,0)","v":0},{"$f":"IF(AND(F31=\"F\",J31=\"SS\",E31=\"C\"),1,0)","v":0},{"$f":"SUM(BD31:BK31)","v":0},{"$f":"IF(AND(F31=\"M\",J31=\"US\",E31=\"W\"),1,0)","v":0},{"$f":"IF(AND(F31=\"F\",J31=\"US\",E31=\"W\"),1,0)","v":0},{"$f":"IF(AND(F31=\"M\",J31=\"US\",E31=\"A\"),1,0)","v":0},{"$f":"IF(AND(F31=\"M\",J31=\"US\",E31=\"I\"),1,0)","v":0},{"$f":"IF(AND(F31=\"M\",J31=\"US\",E31=\"C\"),1,0)","v":0},{"$f":"IF(AND(F31=\"F\",J31=\"US\",E31=\"A\"),1,0)","v":0},{"$f":"IF(AND(F31=\"F\",J31=\"US\",E31=\"I\"),1,0)","v":0},{"$f":"IF(AND(F31=\"F\",J31=\"US\",E31=\"C\"),1,0)","v":0},{"$f":"SUM(BM31:BT31)","v":0}]
[null,"Please enter new lines above here"]
[null,null,null,{"$f":"COUNTA(D13:D32)","v":0},null,null,null,null,null,null,{"$f":"SUM(K13:K32)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(AQ13:AQ32)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"SD Table 1","index":10,"n_rows":46,"n_cols":61,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
["COMPANY NAME",{"$f":"'Global Business Solutions'!B27","v":"Test"}]
[]
["FINANCIAL INFORMATION USED",{"$f":"'Global Business Solutions'!B29","v":"2017-02-28"}]
[]
["Skills Development Table 1",null,"Please only complete table with information for the periods reflected alongside",null,null,null,null,null,null,null,null,null,null,null,null,null,"Note: These training costs reflected must exclude VAT as well as the salaries of all Learners employed during the period under review. The salaries of the Learners must be completed in SD Table 2"]
[]
[]
[]
["Type of Training Courses Attended ","Learning Program Matrix Category","ABET Program? ","Total Number of Delegates Attended","Number of Black Male Delegates Attended",null,null,"Number of Black Women Attended",null,null,"Number of Black Male Delegates Attended who are also disabled",null,null,"Number of Black Delegates Attended who are also female and disabled",null,null,"Cost of Trainers (External or Internal not recovered in SD Table 4)","Cost of Training Facilities not recovered in SD Table 4","Other Costs including Training Materials, but Excluding Catering, Accommodation and Travel","Other Costs Incurred - Catering, Accommodation and Travel","Total Costs Incurred for training courses for all delegates","Reference Number","Your Comments and Notes","Cost per Delegate","Cost per Delegate","Black Male Delegates",null,null,"Black Women Delegates",null,null,"Disabled Black Male Delegates",null,null,"Disabled Black Women Delegates",null,null,"Category F or G Training - Black Male Delegates Only",null,null,"Category F or G Training - Black Female Delegates Only",null,null,"Category F or G Training - Black Male Disabled Delegates Only",null,null,"Category F or G Training - Black Female Disabled Delegates Only",null,null,"Accommodation, Travel & Catering - Black Male Delegates Only",null,null,"Accommodation, Travel & Catering - Black Female Delegates Only",null,null,"Accommodation, Travel & Catering - Black Male Disabled Delegates Only",null,null,"Accommodation, Travel & Catering - Black Female Disabled Delegates Only"]
["(excluding staff bursaries granted)","A,B,C,D,E,F or G           (See Statement 400)","(Yes or No)","(Black & White)","A","I","C","A","I","C","A","I","C","A","I","C",null,null,null,null,null,null,null,null," - Catering, Accommodation and Travel","A","I","C","A","I","C","A","I","C","A","I","C","A","I","C","A","I","C","A","I","C","A","I","C","A","I","C","A","I","C","A","I","C","A","I","C"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,{"$f":"SUM(Q11:T11)","v":0},"SD1-1",null,{"$f":"IF(D11>0,(Q11+R11+S11)/D11,0)","v":0},{"$f":"IF(D11>0,T11/D11,0)","v":0},{"$f":"($X11+$Y11)*E11","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(OR($B11=\"F\",$B11=\"G\"),E11*$X11,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF($Y11>0,E11*$Y11,0)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,{"$f":"SUM(Q12:T12)","v":0},"SD1-2",null,{"$f":"IF(D12>0,(Q12+R12+S12)/D12,0)","v":0},{"$f":"IF(D12>0,T12/D12,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,"SD1-3",null,{"$f":"IF(D13>0,(Q13+R13+S13)/D13,0)","v":0},{"$f":"IF(D13>0,T13/D13,0)","v":0},{"$f":"($X13+$Y13)*E13","v":0},{"$f":"($X13+$Y13)*F13","v":0},{"$f":"($X13+$Y13)*G13","v":0},{"$f":"($X13+$Y13)*H13","v":0},{"$f":"($X13+$Y13)*I13","v":0},{"$f":"($X13+$Y13)*J13","v":0},{"$f":"($X13+$Y13)*K13","v":0},{"$f":"($X13+$Y13)*L13","v":0},{"$f":"($X13+$Y13)*M13","v":0},{"$f":"($X13+$Y13)*N13","v":0},{"$f":"($X13+$Y13)*O13","v":0},{"$f":"($X13+$Y13)*P13","v":0},{"$f":"IF(OR($B13=\"F\",$B13=\"G\"),E13*$X13,0)","v":0},{"$f":"IF(OR($B13=\"F\",$B13=\"G\"),F13*$X13,0)","v":0},{"$f":"IF(OR($B13=\"F\",$B13=\"G\"),G13*$X13,0)","v":0},{"$f":"IF(OR($B13=\"F\",$B13=\"G\"),H13*$X13,0)","v":0},{"$f":"IF(OR($B13=\"F\",$B13=\"G\"),I13*$X13,0)","v":0},{"$f":"IF(OR($B13=\"F\",$B13=\"G\"),J13*$X13,0)","v":0},{"$f":"IF(OR($B13=\"F\",$B13=\"G\"),K13*$X13,0)","v":0},{"$f":"IF(OR($B13=\"F\",$B13=\"G\"),L13*$X13,0)","v":0},{"$f":"IF(OR($B13=\"F\",$B13=\"G\"),M13*$X13,0)","v":0},{"$f":"IF(OR($B13=\"F\",$B13=\"G\"),N13*$X13,0)","v":0},{"$f":"IF(OR($B13=\"F\",$B13=\"G\"),O13*$X13,0)","v":0},{"$f":"IF(OR($B13=\"F\",$B13=\"G\"),P13*$X13,0)","v":0},{"$f":"IF($Y13>0,E13*$Y13,0)","v":0},{"$f":"IF($Y13>0,F13*$Y13,0)","v":0},{"$f":"IF($Y13>0,G13*$Y13,0)","v":0},{"$f":"IF($Y13>0,H13*$Y13,0)","v":0},{"$f":"IF($Y13>0,I13*$Y13,0)","v":0},{"$f":"IF($Y13>0,J13*$Y13,0)","v":0},{"$f":"IF($Y13>0,K13*$Y13,0)","v":0},{"$f":"IF($Y13>0,L13*$Y13,0)","v":0},{"$f":"IF($Y13>0,M13*$Y13,0)","v":0},{"$f":"IF($Y13>0,N13*$Y13,0)","v":0},{"$f":"IF($Y13>0,O13*$Y13,0)","v":0},{"$f":"IF($Y13>0,P13*$Y13,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,"SD1-4",null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,"SD1-5",null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,"SD1-6",null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,"SD1-7",null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,"SD1-8",null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,"SD1-9",null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,"SD1-10",null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,"SD1-11",null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,"SD1-12",null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,"SD1-13",null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,"SD1-14",null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,"SD1-15",null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,"SD1-16",null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,"SD1-17",null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,"SD1-18",null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,"SD1-19",null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,"SD1-20",null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"SD1-21",null,{"$f":"IF(D31>0,(Q31+R31+S31)/D31,0)","v":0},{"$f":"IF(D31>0,T31/D31,0)","v":0},{"$f":"($X31+$Y31)*E31","v":0},{"$f":"($X31+$Y31)*F31","v":0},{"$f":"($X31+$Y31)*G31","v":0},{"$f":"($X31+$Y31)*H31","v":0},{"$f":"($X31+$Y31)*I31","v":0},{"$f":"($X31+$Y31)*J31","v":0},{"$f":"($X31+$Y31)*K31","v":0},{"$f":"($X31+$Y31)*L31","v":0},{"$f":"($X31+$Y31)*M31","v":0},{"$f":"($X31+$Y31)*N31","v":0},{"$f":"($X31+$Y31)*O31","v":0},{"$f":"($X31+$Y31)*P31","v":0},{"$f":"IF(OR($B31=\"F\",$B31=\"G\"),E31*$X31,0)","v":0},{"$f":"IF(OR($B31=\"F\",$B31=\"G\"),F31*$X31,0)","v":0},{"$f":"IF(OR($B31=\"F\",$B31=\"G\"),G31*$X31,0)","v":0},{"$f":"IF(OR($B31=\"F\",$B31=\"G\"),H31*$X31,0)","v":0},{"$f":"IF(OR($B31=\"F\",$B31=\"G\"),I31*$X31,0)","v":0},{"$f":"IF(OR($B31=\"F\",$B31=\"G\"),J31*$X31,0)","v":0},{"$f":"IF(OR($B31=\"F\",$B31=\"G\"),K31*$X31,0)","v":0},{"$f":"IF(OR($B31=\"F\",$B31=\"G\"),L31*$X31,0)","v":0},{"$f":"IF(OR($B31=\"F\",$B31=\"G\"),M31*$X31,0)","v":0},{"$f":"IF(OR($B31=\"F\",$B31=\"G\"),N31*$X31,0)","v":0},{"$f":"IF(OR($B31=\"F\",$B31=\"G\"),O31*$X31,0)","v":0},{"$f":"IF(OR($B31=\"F\",$B31=\"G\"),P31*$X31,0)","v":0},{"$f":"IF($Y31>0,E31*$Y31,0)","v":0},{"$f":"IF($Y31>0,F31*$Y31,0)","v":0},{"$f":"IF($Y31>0,G31*$Y31,0)","v":0},{"$f":"IF($Y31>0,H31*$Y31,0)","v":0},{"$f":"IF($Y31>0,I31*$Y31,0)","v":0},{"$f":"IF($Y31>0,J31*$Y31,0)","v":0},{"$f":"IF($Y31>0,K31*$Y31,0)","v":0},{"$f":"IF($Y31>0,L31*$Y31,0)","v":0},{"$f":"IF($Y31>0,M31*$Y31,0)","v":0},{"$f":"IF($Y31>0,N31*$Y31,0)","v":0},{"$f":"IF($Y31>0,O31*$Y31,0)","v":0},{"$f":"IF($Y31>0,P31*$Y31,0)","v":0}]
["Please enter new lines above here"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Training Costs",null,{"$f":"SUM(Q11:Q32)","v":0},0,0,0,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Learning Matrix"]
["A"]
["B"]
["C"]
["D"]
["E"]
["F"]
["G"]
[]
["ABET"]
["Yes"]
["No"]

{"sheet":"SD Table 2","index":11,"n_rows":35,"n_cols":25,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
["COMPANY NAME",{"$f":"'Global Business Solutions'!B27","v":"Test"}]
[]
["FINANCIAL INFORMATION USED",{"$f":"'Global Business Solutions'!B29","v":"2017-02-28"}]
[]
["Skills Development Table 2",null,"Please only complete table with actual remuneration (TCOE/TCTC) paid to the learner for the periods reflected alongside",null,null,{"$f":"IF('Skills Development'!$B11>0,'Skills Development'!$A11,\"\")","v":""},{"$f":"IF('Skills Development'!$B14>0,'Skills Development'!$A14,\"\")","v":""},{"$f":"IF('Skills Development'!$B17>0,'Skills Development'!$A17,\"\")","v":""},{"$f":"IF('Skills Development'!$B20>0,'Skills Development'!$A20,\"\")","v":""},"Please only reflect details pertaining to the Black Learners employed and/or hosted by your entity"]
[null,null,null,null,null,{"$f":"IF('Skills Development'!$B12>0,'Skills Development'!$A12,\"\")","v":""},{"$f":"IF('Skills Development'!$B15>0,'Skills Development'!$A15,\"\")","v":""},{"$f":"IF('Skills Development'!$B18>0,'Skills Development'!$A18,\"\")","v":""},{"$f":"IF('Skills Development'!$B21>0,'Skills Development'!$A21,\"\")","v":""}]
[null,null,null,null,null,{"$f":"IF('Skills Development'!$B13>0,'Skills Development'!$A13,\"\")","v":""},{"$f":"IF('Skills Development'!$B16>0,'Skills Development'!$A16,\"\")","v":""},{"$f":"IF('Skills Development'!$B19>0,'Skills Development'!$A19,\"\")","v":""},{"$f":"IF('Skills Development'!$B22>0,'Skills Development'!$A22,\"\")","v":""},"Please refer to the Learning Program Matrix  for a full explanation as to the different types of Learnerships reflected. "]
[]
["Name of Learner - Black Learners ONLY","Type of Learnership","Gender","Disabled","Population Group - Please do not input White or NSA learners","Qualifying Months for Learnership - (Period in which the learner was employed as a learner during the measurement period)",null,"Salaries/Wages Actually Paid During Skills Measurement Period Under Review","Salaries/Wages Actually Paid to Black Females During Skills Measurement Period Under Review","Salaries/Wages Actually Paid to Black Disabled During Skills Measurement Period Under Review","Salaries/Wages Actually Paid to Black Disabled Females During Skills Measurement Period Under Review","Reference Number","Your Comments and Notes","African Male","Indian Male ","Coloured Male","African Female","Indian Female","Coloured female","Disabled African Male","Disabled Indian Male ","Disabled Coloured Male","Disabled African Female","Disabled Indian Female","Disabled Coloured female"]
[]
[null,"Category B, C or D","M/F","Yes/No","A/I/C","Start Date (Month and Year) MMM-YY","End Date (Month and Year) MMM-YY"]
[null,null,null,null,null,null,null,null,{"$f":"IF(C12=\"f\",H12,0)","v":0},{"$f":"IF(D12=\"yes\",H12,0)","v":0},{"$f":"IF(AND(C12=\"F\",D12=\"Yes\"),H12,0)","v":0},"SD2-1",null,{"$f":"IF(AND(C12=\"M\",E12=\"A\"),H12,\"\")","v":""},{"$f":"IF(AND(C12=\"M\",E12=\"I\"),H12,\"\")","v":""},{"$f":"IF(AND(C12=\"M\",E12=\"C\"),H12,\"\")","v":""},{"$f":"IF(AND(C12=\"F\",E12=\"A\"),H12,\"\")","v":""},{"$f":"IF(AND(C12=\"F\",E12=\"I\"),H12,\"\")","v":""},{"$f":"IF(AND(C12=\"F\",E12=\"C\"),H12,\"\")","v":""},{"$f":"IF(AND(C12=\"M\",E12=\"A\",D12=\"Yes\"),H12,\"\")","v":""},{"$f":"IF(AND(C12=\"M\",E12=\"I\",D12=\"Yes\"),H12,\"\")","v":""},{"$f":"IF(AND(C12=\"M\",E12=\"C\",D12=\"Yes\"),H12,\"\")","v":""},{"$f":"IF(AND(C12=\"F\",E12=\"A\",D12=\"Yes\"),H12,\"\")","v":""},{"$f":"IF(AND(C12=\"F\",E12=\"I\",D12=\"Yes\"),H12,\"\")","v":""},{"$f":"IF(AND(C12=\"F\",E12=\"C\",D12=\"Yes\"),H12,\"\")","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(C13=\"f\",H13,0)","v":0},{"$f":"IF(D13=\"yes\",H13,0)","v":0},{"$f":"IF(AND(C13=\"F\",D13=\"Yes\"),H13,0)","v":0},"SD2-2",null,{"$f":"IF(AND(C13=\"M\",E13=\"A\"),H13,\"\")","v":""},{"$f":"IF(AND(C13=\"M\",E13=\"I\"),H13,\"\")","v":""},{"$f":"IF(AND(C13=\"M\",E13=\"C\"),H13,\"\")","v":""},{"$f":"IF(AND(C13=\"F\",E13=\"A\"),H13,\"\")","v":""},{"$f":"IF(AND(C13=\"F\",E13=\"I\"),H13,\"\")","v":""},{"$f":"IF(AND(C13=\"F\",E13=\"C\"),H13,\"\")","v":""},{"$f":"IF(AND(C13=\"M\",E13=\"A\",D13=\"Yes\"),H13,\"\")","v":""},{"$f":"IF(AND(C13=\"M\",E13=\"I\",D13=\"Yes\"),H13,\"\")","v":""},{"$f":"IF(AND(C13=\"M\",E13=\"C\",D13=\"Yes\"),H13,\"\")","v":""},{"$f":"IF(AND(C13=\"F\",E13=\"A\",D13=\"Yes\"),H13,\"\")","v":""},{"$f":"IF(AND(C13=\"F\",E13=\"I\",D13=\"Yes\"),H13,\"\")","v":""},{"$f":"IF(AND(C13=\"F\",E13=\"C\",D13=\"Yes\"),H13,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,0,0,"SD2-3",null,{"$f":"IF(AND(C14=\"M\",E14=\"A\"),H14,\"\")","v":""},{"$f":"IF(AND(C14=\"M\",E14=\"I\"),H14,\"\")","v":""},{"$f":"IF(AND(C14=\"M\",E14=\"C\"),H14,\"\")","v":""},{"$f":"IF(AND(C14=\"F\",E14=\"A\"),H14,\"\")","v":""},{"$f":"IF(AND(C14=\"F\",E14=\"I\"),H14,\"\")","v":""},{"$f":"IF(AND(C14=\"F\",E14=\"C\"),H14,\"\")","v":""},{"$f":"IF(AND(C14=\"M\",E14=\"A\",D14=\"Yes\"),H14,\"\")","v":""},{"$f":"IF(AND(C14=\"M\",E14=\"I\",D14=\"Yes\"),H14,\"\")","v":""},{"$f":"IF(AND(C14=\"M\",E14=\"C\",D14=\"Yes\"),H14,\"\")","v":""},{"$f":"IF(AND(C14=\"F\",E14=\"A\",D14=\"Yes\"),H14,\"\")","v":""},{"$f":"IF(AND(C14=\"F\",E14=\"I\",D14=\"Yes\"),H14,\"\")","v":""},{"$f":"IF(AND(C14=\"F\",E14=\"C\",D14=\"Yes\"),H14,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,0,0,"SD2-4",null,"","","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,0,0,0,"SD2-5",null,"","","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C17=\"f\",H17,0)","v":0},{"$f":"IF(D17=\"yes\",H17,0)","v":0},{"$f":"IF(AND(C17=\"F\",D17=\"Yes\"),H17,0)","v":0},"SD2-6",null,"","","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,0,0,0,"SD2-7",null,"","","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,0,0,0,"SD2-8",null,"","","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,0,0,0,"SD2-9",null,"","","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,0,0,0,"SD2-10",null,"","","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,0,0,0,"SD2-11",null,"","","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,0,0,0,"SD2-12",null,"","","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,0,0,0,"SD2-13",null,"","","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,0,0,0,"SD2-14",null,"","","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,0,0,0,"SD2-15",null,"","","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,0,0,0,"SD2-16",null,"","","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,0,0,0,"SD2-17",null,"","","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,0,0,0,"SD2-18",null,"","","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,0,0,0,"SD2-19",null,"","","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C31=\"f\",H31,0)","v":0},{"$f":"IF(D31=\"yes\",H31,0)","v":0},{"$f":"IF(AND(C31=\"F\",D31=\"Yes\"),H31,0)","v":0},"SD2-225",0,{"$f":"IF(AND(C31=\"M\",E31=\"A\"),H31,\"\")","v":""},{"$f":"IF(AND(C31=\"M\",E31=\"I\"),H31,\"\")","v":""},{"$f":"IF(AND(C31=\"M\",E31=\"C\"),H31,\"\")","v":""},{"$f":"IF(AND(C31=\"F\",E31=\"A\"),H31,\"\")","v":""},{"$f":"IF(AND(C31=\"F\",E31=\"I\"),H31,\"\")","v":""},{"$f":"IF(AND(C31=\"F\",E31=\"C\"),H31,\"\")","v":""},{"$f":"IF(AND(C31=\"M\",E31=\"A\",D31=\"Yes\"),H31,\"\")","v":""},{"$f":"IF(AND(C31=\"M\",E31=\"I\",D31=\"Yes\"),H31,\"\")","v":""},{"$f":"IF(AND(C31=\"M\",E31=\"C\",D31=\"Yes\"),H31,\"\")","v":""},{"$f":"IF(AND(C31=\"F\",E31=\"A\",D31=\"Yes\"),H31,\"\")","v":""},{"$f":"IF(AND(C31=\"F\",E31=\"I\",D31=\"Yes\"),H31,\"\")","v":""},{"$f":"IF(AND(C31=\"F\",E31=\"C\",D31=\"Yes\"),H31,\"\")","v":""}]
["Please enter new Lines above",null,null,null,null,null,null,null,{"$f":"IF(C32=\"f\",H32,\"\")","v":""},{"$f":"IF(D32=\"yes\",H32,\"\")","v":""},{"$f":"IF(AND(C32=\"F\",D32=\"Yes\"),H32,\"\")","v":""}]
[null,null,null,null,null,null,null,{"$f":"SUM(H12:H32)","v":0},{"$f":"SUM(I12:I32)","v":0},{"$f":"SUM(J12:J32)","v":0},{"$f":"SUM(K12:K32)","v":0},null,null,{"$f":"SUM(N12:N32)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNT(N12:N32)","v":0},0,0,0,0,0,0,0,0,0,0,0]
["Total Number of Black Learnerships",{"$f":"COUNTIFS(E12:E32,\"A\")+COUNTIFS(E12:E32,\"I\")+COUNTIFS(E12:E32,\"C\")","v":0}]

{"sheet":"SD Table 3","index":12,"n_rows":33,"n_cols":23,"rows_kept":33,"cut":false,"hidden":false,"merged":[[9,6,11,6],[9,7,11,7],[9,0,11,0],[9,1,10,1],[9,2,10,2],[9,3,10,3],[9,4,10,4],[0,1,0,4],[2,1,2,4],[9,5,11,5],[4,0,6,1],[4,2,6,4],[9,20,11,20],[9,21,11,21],[9,22,11,22],[9,11,11,11],[9,12,11,12],[9,13,11,13],[9,14,11,14],[9,15,11,15],[9,16,11,16],[9,17,11,17],[9,19,11,19],[9,18,11,18]]}
["COMPANY NAME",{"$f":"'Global Business Solutions'!B27","v":"Test"}]
[]
["FINANCIAL INFORMATION USED",{"$f":"'Global Business Solutions'!B29","v":"2017-02-28"}]
[]
["Skills Development Table 3",null,"Please only complete table with payments/disbursements during the periods reflected alongside",null,{"$f":"IF('Skills Development'!$B11>0,'Skills Development'!$A11,\"\")","v":""},{"$f":"IF('Skills Development'!$B14>0,'Skills Development'!$A14,\"\")","v":""},{"$f":"IF('Skills Development'!$B17>0,'Skills Development'!$A17,\"\")","v":""},{"$f":"IF('Skills Development'!$B20>0,'Skills Development'!$A20,\"\")","v":""},"Please only reflect details pertaining to bursary holders who are Black and who are employed by your entity"]
[null,null,null,null,{"$f":"IF('Skills Development'!$B12>0,'Skills Development'!$A12,\"\")","v":""},{"$f":"IF('Skills Development'!$B15>0,'Skills Development'!$A15,\"\")","v":""},{"$f":"IF('Skills Development'!$B18>0,'Skills Development'!$A18,\"\")","v":""},{"$f":"IF('Skills Development'!$B21>0,'Skills Development'!$A21,\"\")","v":""}]
[null,null,null,null,{"$f":"IF('Skills Development'!$B13>0,'Skills Development'!$A13,\"\")","v":""},{"$f":"IF('Skills Development'!$B16>0,'Skills Development'!$A16,\"\")","v":""},{"$f":"IF('Skills Development'!$B19>0,'Skills Development'!$A19,\"\")","v":""},{"$f":"IF('Skills Development'!$B22>0,'Skills Development'!$A22,\"\")","v":""}]
["Bursaries are defined as any tertiary studies undertaken that is subject to an agreement signed by the employee"]
[]
["Name of Bursary Holder - BLACK EMPLOYEES ONLY","Bursary Holder an Employee?","Gender","Population Group","Employee Disabled?","Total value of the bursaries actually paid to the employees during the skills development period ","Total value of the bursaries actually paid to the black female employees during the skills development period ","Total value of the bursaries actually paid to the black disabled employees during the skills development period ","Total value of the bursaries actually paid to the black female disabled employees during the skills development period ","Reference Number","Your Comments and Notes","African Male","Indian Male ","Coloured Male","African Female","Indian Female","Coloured female","Disabled African Male","Disabled Indian Male ","Disabled Coloured Male","Disabled African Female","Disabled Indian Female","Disabled Coloured female"]
[]
[null,"Yes/No","M/F","A/I/C","Yes/No"]
[null,null,null,null,null,null,{"$f":"IF(C13=\"f\",F13,0)","v":0},{"$f":"IF(E13=\"yes\",F13,0)","v":0},{"$f":"IF(AND(C13=\"f\",E13=\"yes\"),F13,0)","v":0},"SD3-1",null,{"$f":"IF(AND(C13=\"M\",D13=\"A\"),F13,0)","v":0},{"$f":"IF(AND(C13=\"M\",D13=\"I\"),F13,0)","v":0},{"$f":"IF(AND(C13=\"M\",D13=\"C\"),F13,0)","v":0},{"$f":"IF(AND(C13=\"F\",D13=\"A\"),F13,0)","v":0},{"$f":"IF(AND(C13=\"F\",D13=\"I\"),F13,0)","v":0},{"$f":"IF(AND(C13=\"F\",D13=\"C\"),F13,0)","v":0},{"$f":"IF(AND(C13=\"M\",D13=\"A\",E13=\"Yes\"),F13,0)","v":0},{"$f":"IF(AND(C13=\"M\",D13=\"I\",E13=\"Yes\"),F13,0)","v":0},{"$f":"IF(AND(C13=\"M\",D13=\"C\",E13=\"Yes\"),F13,0)","v":0},{"$f":"IF(AND(C13=\"F\",D13=\"A\",E13=\"Yes\"),F13,0)","v":0},{"$f":"IF(AND(C13=\"F\",D13=\"I\",E13=\"Yes\"),F13,0)","v":0},{"$f":"IF(AND(C13=\"F\",D13=\"C\",E13=\"Yes\"),F13,0)","v":0}]
[null,null,null,null,null,null,{"$f":"IF(C14=\"f\",F14,0)","v":0},{"$f":"IF(E14=\"yes\",F14,0)","v":0},{"$f":"IF(AND(C14=\"f\",E14=\"yes\"),F14,0)","v":0},"SD3-2",null,{"$f":"IF(AND(C14=\"M\",D14=\"A\"),F14,0)","v":0},{"$f":"IF(AND(C14=\"M\",D14=\"I\"),F14,0)","v":0},{"$f":"IF(AND(C14=\"M\",D14=\"C\"),F14,0)","v":0},{"$f":"IF(AND(C14=\"F\",D14=\"A\"),F14,0)","v":0},{"$f":"IF(AND(C14=\"F\",D14=\"I\"),F14,0)","v":0},{"$f":"IF(AND(C14=\"F\",D14=\"C\"),F14,0)","v":0},{"$f":"IF(AND(C14=\"M\",D14=\"A\",E14=\"Yes\"),F14,0)","v":0},{"$f":"IF(AND(C14=\"M\",D14=\"I\",E14=\"Yes\"),F14,0)","v":0},{"$f":"IF(AND(C14=\"M\",D14=\"C\",E14=\"Yes\"),F14,0)","v":0},{"$f":"IF(AND(C14=\"F\",D14=\"A\",E14=\"Yes\"),F14,0)","v":0},{"$f":"IF(AND(C14=\"F\",D14=\"I\",E14=\"Yes\"),F14,0)","v":0},{"$f":"IF(AND(C14=\"F\",D14=\"C\",E14=\"Yes\"),F14,0)","v":0}]
[null,null,null,null,null,null,0,0,0,"SD3-3",null,{"$f":"IF(AND(C15=\"M\",D15=\"A\"),F15,0)","v":0},{"$f":"IF(AND(C15=\"M\",D15=\"I\"),F15,0)","v":0},{"$f":"IF(AND(C15=\"M\",D15=\"C\"),F15,0)","v":0},{"$f":"IF(AND(C15=\"F\",D15=\"A\"),F15,0)","v":0},{"$f":"IF(AND(C15=\"F\",D15=\"I\"),F15,0)","v":0},{"$f":"IF(AND(C15=\"F\",D15=\"C\"),F15,0)","v":0},{"$f":"IF(AND(C15=\"M\",D15=\"A\",E15=\"Yes\"),F15,0)","v":0},{"$f":"IF(AND(C15=\"M\",D15=\"I\",E15=\"Yes\"),F15,0)","v":0},{"$f":"IF(AND(C15=\"M\",D15=\"C\",E15=\"Yes\"),F15,0)","v":0},{"$f":"IF(AND(C15=\"F\",D15=\"A\",E15=\"Yes\"),F15,0)","v":0},{"$f":"IF(AND(C15=\"F\",D15=\"I\",E15=\"Yes\"),F15,0)","v":0},{"$f":"IF(AND(C15=\"F\",D15=\"C\",E15=\"Yes\"),F15,0)","v":0}]
[null,null,null,null,null,null,0,0,0,"SD3-4",null,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,0,"SD3-5",null,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,0,"SD3-6",null,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,0,"SD3-7",null,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,0,"SD3-8",null,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,0,"SD3-9",null,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,0,"SD3-10",null,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,{"$f":"IF(C23=\"f\",F23,0)","v":0},{"$f":"IF(E23=\"yes\",F23,0)","v":0},{"$f":"IF(AND(C23=\"f\",E23=\"yes\"),F23,0)","v":0},"SD3-11",null,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,0,"SD3-12",null,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,0,"SD3-13",null,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,0,"SD3-14",null,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,0,"SD3-15",null,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,0,"SD3-16",null,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,0,"SD3-17",null,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,0,"SD3-18",null,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,0,"SD3-132",null,{"$f":"IF(AND(C31=\"M\",D31=\"A\"),F31,0)","v":0},{"$f":"IF(AND(C31=\"M\",D31=\"I\"),F31,0)","v":0},{"$f":"IF(AND(C31=\"M\",D31=\"C\"),F31,0)","v":0},{"$f":"IF(AND(C31=\"F\",D31=\"A\"),F31,0)","v":0},{"$f":"IF(AND(C31=\"F\",D31=\"I\"),F31,0)","v":0},{"$f":"IF(AND(C31=\"F\",D31=\"C\"),F31,0)","v":0},{"$f":"IF(AND(C31=\"M\",D31=\"A\",E31=\"Yes\"),F31,0)","v":0},{"$f":"IF(AND(C31=\"M\",D31=\"I\",E31=\"Yes\"),F31,0)","v":0},{"$f":"IF(AND(C31=\"M\",D31=\"C\",E31=\"Yes\"),F31,0)","v":0},{"$f":"IF(AND(C31=\"F\",D31=\"A\",E31=\"Yes\"),F31,0)","v":0},{"$f":"IF(AND(C31=\"F\",D31=\"I\",E31=\"Yes\"),F31,0)","v":0},{"$f":"IF(AND(C31=\"F\",D31=\"C\",E31=\"Yes\"),F31,0)","v":0}]
["Please enter new lines above"]
[null,null,null,null,"Total Bursary Costs",{"$f":"SUM(F13:F32)","v":0},{"$f":"SUM(G13:G32)","v":0},{"$f":"SUM(H13:H32)","v":0},{"$f":"SUM(I13:I32)","v":0},null,null,{"$f":"SUM(L13:L32)","v":0},0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"SD Table 4","index":13,"n_rows":33,"n_cols":17,"rows_kept":33,"cut":false,"hidden":false,"merged":[[18,16,18,18],[8,16,8,18],[9,16,9,18],[10,16,10,18],[11,16,11,18],[28,1,28,6],[28,7,28,12],[0,1,0,5],[2,1,2,5],[4,0,6,13],[24,1,24,6],[24,7,24,12]]}
["COMPANY NAME",{"$f":"'Global Business Solutions'!B27","v":"Test"}]
[]
["FINANCIAL INFORMATION USED",{"$f":"'Global Business Solutions'!B29","v":"2017-02-28"}]
[]
["Skills Development Table 4"]
[]
[]
[]
["Type of Training-Related Administration Cost Claimed","Rand value of expenditure - Annual","Percentage Allocation of TCTC","Category (A - G)","Contribution to Skills Development Spend - AM","Contribution to Skills Development Spend - IM","Contribution to Skills Development Spend - CM","Contribution to Skills Development Spend - AF","Contribution to Skills Development Spend - IF","Contribution to Skills Development Spend - CF","Contribution to Skills Development Spend - Disabled AM","Contribution to Skills Development Spend - Disabled IM","Contribution to Skills Development Spend - Disabled CM","Contribution to Skills Development Spend - Disabled AF","Contribution to Skills Development Spend - Disabled IF","Contribution to Skills Development Spend - Disabled CF","Notes"]
["Salary of Skills Development Facilitator(s) for the period under review",null,1,null,{"$f":"$B10*$C10*B$27","v":0},0,0,0,0,0,0,0,0,0,0,0]
["Salary of Training Manager(s) for the period under review",null,1,null,0,0,0,0,0,0,0,0,0,0,0,0]
["Salary of Mentor(s) for the period under review",null,1,null,0,0,0,0,0,0,0,0,0,0,0,0]
["Administration Cost of Disabled Learnerships",null,1]
["Other",null,1,null,{"$f":"$B14*$C14*B$27","v":0},0,0,0,0,0,0,0,0,0,0,0]
["Other",null,1,null,0,0,0,0,0,0,0,0,0,0,0,0]
["Other",null,1,null,0,0,0,0,0,0,0,0,0,0,0,0]
["Other",null,1,null,0,0,0,0,0,0,0,0,0,0,0,0]
["Other",null,1,null,0,0,0,0,0,0,0,0,0,0,0,0]
["Other Administration Costs incurred relating to Skills Development for the period under review",null,1,null,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"SUM(B10:B19)","v":0},null,null,{"$f":"SUM(E10:E19)","v":0},0,0,0,0,0,0,0,0,0,0,0]
["Note: Costs included above excludes direct training costs included in Table 4.1"]
[]
["Please provide the period for which Table 4.4 is applicable"]
[]
[null,"Able Bodied",null,null,null,null,null,"Disabled"]
[null,"AM","IM","CM","AF","IF","CF","AM","IM","CM","AF","IF","CF"]
["Percentage Allocation to Skills Development of Black People",{"$f":"'Employment Equity Worksheet'!B87","v":0},{"$f":"'Employment Equity Worksheet'!C87","v":0},{"$f":"'Employment Equity Worksheet'!D87","v":0},{"$f":"'Employment Equity Worksheet'!B101","v":0},{"$f":"'Employment Equity Worksheet'!C101","v":0},{"$f":"'Employment Equity Worksheet'!D101","v":0},{"$f":"'Employment Equity Worksheet'!B88","v":0},{"$f":"'Employment Equity Worksheet'!C88","v":0},{"$f":"'Employment Equity Worksheet'!D88","v":0},{"$f":"'Employment Equity Worksheet'!B102","v":0},{"$f":"'Employment Equity Worksheet'!C102","v":0},{"$f":"'Employment Equity Worksheet'!D102","v":0}]
[]
[null,"Able Bodied",null,null,null,null,null,"Disabled"]
["Type of Training-Related Administration Cost Claimed","AM","IM","CM","AF","IF","CF","AM","IM","CM","AF","IF","CF"]
["Category F",{"$f":"SUMIFS(E5:E19,$D$10:$D$24,\"F\")","v":0},{"$f":"SUMIFS(F5:F19,$D$10:$D$24,\"F\")","v":0},0,0,0,0,0,0,0,0,0,0]
["Category G",{"$f":"SUMIFS(E5:E19,$D$10:$D$24,\"G\")","v":0},{"$f":"SUMIFS(F5:F19,$D$10:$D$24,\"G\")","v":0},0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"SUM(B31:B32)","v":0},{"$f":"SUM(C31:C32)","v":0},0,0,0,0,0,0,0,0,0,0]

{"sheet":"SD Table 5","index":14,"n_rows":35,"n_cols":15,"rows_kept":35,"cut":false,"hidden":false,"merged":[[8,13,10,13],[8,14,10,14],[8,9,10,9],[8,10,10,10],[8,11,10,11],[8,12,10,12]]}
["COMPANY NAME",{"$f":"'Global Business Solutions'!B27","v":"Test"}]
[]
["FINANCIAL INFORMATION USED",{"$f":"'Global Business Solutions'!B29","v":"2017-02-28"}]
[]
["Skills Development Table 5"]
[]
[]
[]
["Unemployed Black People participating in training per the training matrix","Type of Training","Gender","Disabled","Population Group - Please do not input White or NSA learners","Qualifying Months for Learnership - (Period in which the learner was employed as a learner during the measurement period)",null,"Reference Number","Your Comments and Notes","African Male","Indian Male ","Coloured Male","African Female","Indian Female","Coloured female"]
[]
[null,"Category (A/B/C/D/E/F/G)","M/F","Yes/No","A/I/C","Start Date (Month and Year) MMM-YY","End Date (Month and Year) MMM-YY"]
[null,null,null,null,null,null,null,"SD5-1",null,{"$f":"IF(AND(C12=\"M\",E12=\"A\"),1,\"\")","v":""},{"$f":"IF(AND(C12=\"M\",E12=\"I\"),1,\"\")","v":""},{"$f":"IF(AND(C12=\"M\",E12=\"C\"),1,\"\")","v":""},{"$f":"IF(AND(C12=\"F\",E12=\"A\"),1,\"\")","v":""},{"$f":"IF(AND(C12=\"F\",E12=\"I\"),1,\"\")","v":""},{"$f":"IF(AND(C12=\"F\",E12=\"C\"),1,\"\")","v":""}]
[null,null,null,null,null,null,null,"SD5-2",null,{"$f":"IF(AND(C13=\"M\",E13=\"A\"),1,\"\")","v":""},{"$f":"IF(AND(C13=\"M\",E13=\"I\"),1,\"\")","v":""},{"$f":"IF(AND(C13=\"M\",E13=\"C\"),1,\"\")","v":""},{"$f":"IF(AND(C13=\"F\",E13=\"A\"),1,\"\")","v":""},{"$f":"IF(AND(C13=\"F\",E13=\"I\"),1,\"\")","v":""},{"$f":"IF(AND(C13=\"F\",E13=\"C\"),1,\"\")","v":""}]
[null,null,null,null,null,null,null,"SD5-3",null,{"$f":"IF(AND(C14=\"M\",E14=\"A\"),1,\"\")","v":""},{"$f":"IF(AND(C14=\"M\",E14=\"I\"),1,\"\")","v":""},{"$f":"IF(AND(C14=\"M\",E14=\"C\"),1,\"\")","v":""},{"$f":"IF(AND(C14=\"F\",E14=\"A\"),1,\"\")","v":""},{"$f":"IF(AND(C14=\"F\",E14=\"I\"),1,\"\")","v":""},{"$f":"IF(AND(C14=\"F\",E14=\"C\"),1,\"\")","v":""}]
[null,null,null,null,null,null,null,"SD5-4",null,"","","","","",""]
[null,null,null,null,null,null,null,"SD5-5",null,"","","","","",""]
[null,null,null,null,null,null,null,"SD5-6",null,"","","","","",""]
[null,null,null,null,null,null,null,"SD5-7",null,"","","","","",""]
[null,null,null,null,null,null,null,"SD5-8",null,"","","","","",""]
[null,null,null,null,null,null,null,"SD5-9",null,"","","","","",""]
[null,null,null,null,null,null,null,"SD5-10",null,"","","","","",""]
[null,null,null,null,null,null,null,"SD5-11",null,"","","","","",""]
[null,null,null,null,null,null,null,"SD5-12",null,"","","","","",""]
[null,null,null,null,null,null,null,"SD5-13",null,"","","","","",""]
[null,null,null,null,null,null,null,"SD5-14",null,"","","","","",""]
[null,null,null,null,null,null,null,"SD5-15",null,"","","","","",""]
[null,null,null,null,null,null,null,"SD5-16",null,"","","","","",""]
[null,null,null,null,null,null,null,"SD5-17",null,"","","","","",""]
[null,null,null,null,null,null,null,"SD5-18",null,"","","","","",""]
[null,null,null,null,null,null,null,"SD5-19",null,"","","","","",""]
[null,null,null,null,null,null,null,"SD5-20",null,{"$f":"IF(AND(C31=\"M\",E31=\"A\"),1,\"\")","v":""},{"$f":"IF(AND(C31=\"M\",E31=\"I\"),1,\"\")","v":""},{"$f":"IF(AND(C31=\"M\",E31=\"C\"),1,\"\")","v":""},{"$f":"IF(AND(C31=\"F\",E31=\"A\"),1,\"\")","v":""},{"$f":"IF(AND(C31=\"F\",E31=\"I\"),1,\"\")","v":""},{"$f":"IF(AND(C31=\"F\",E31=\"C\"),1,\"\")","v":""}]
["Please insert new lines above",null,null,null,null,null,null,null,null,{"$f":"IF(AND(C32=\"M\",E32=\"A\"),1,\"\")","v":""},{"$f":"IF(AND(C32=\"M\",E32=\"I\"),1,\"\")","v":""},{"$f":"IF(AND(C32=\"M\",E32=\"C\"),1,\"\")","v":""},{"$f":"IF(AND(C32=\"F\",E32=\"A\"),1,\"\")","v":""},{"$f":"IF(AND(C32=\"F\",E32=\"I\"),1,\"\")","v":""},{"$f":"IF(AND(C32=\"F\",E32=\"C\"),1,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J12:J32)","v":0},0,0,0,0,0]
["Total Number of Black Learnerships",{"$f":"COUNTIFS(E12:E32,\"A\")+COUNTIFS(E12:E32,\"I\")+COUNTIFS(E12:E32,\"C\")","v":0}]
["Total Number of Black Female Learnerships",{"$f":"COUNTIF(C12:C32,\"f\")","v":0}]

{"sheet":"SD Table 6","index":15,"n_rows":35,"n_cols":10,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
["COMPANY NAME",{"$f":"'Global Business Solutions'!B27","v":"Test"}]
[]
["FINANCIAL INFORMATION USED",{"$f":"'Global Business Solutions'!B29","v":"2017-02-28"}]
[]
["Skills Development Table 6"]
[]
[]
[]
["Black Learners completing their Learnerships","Type of Learnership","Gender","Disabled","Population Group - Please do not input White or NSA learners","Employed by the ME or company in the same sector (Y/N)","Reference Number","Your Comments and Notes"]
[]
[null,"Category B, C or D","M/F","Yes/No","A/I/C",null,null,null,"completion","Placed"]
[null,null,null,null,null,null,"SD6-1"]
[null,null,null,null,null,null,"SD6-2"]
[null,null,null,null,null,null,"SD6-3"]
[null,null,null,null,null,null,"SD6-4"]
[null,null,null,null,null,null,"SD6-5"]
[null,null,null,null,null,null,"SD6-6"]
[null,null,null,null,null,null,"SD6-7"]
[null,null,null,null,null,null,"SD6-8"]
[null,null,null,null,null,null,"SD6-9"]
[null,null,null,null,null,null,"SD6-10"]
[null,null,null,null,null,null,"SD6-11"]
[null,null,null,null,null,null,"SD6-12"]
[null,null,null,null,null,null,"SD6-13"]
[null,null,null,null,null,null,"SD6-14"]
[null,null,null,null,null,null,"SD6-15"]
[null,null,null,null,null,null,"SD6-16"]
[null,null,null,null,null,null,"SD6-17"]
[null,null,null,null,null,null,"SD6-18"]
[null,null,null,null,null,null,"SD6-19"]
[null,null,null,null,null,null,"SD6-151"]
["Please insert new lines above"]
[]
["Total Number of Black Learners completing their Learnership",{"$f":"COUNTA(B12:B32)","v":0}]
["Total Number of Black Learners completing their Learnership - Employed",{"$f":"COUNTIF(F12:F32,\"Y\")","v":0}]

{"sheet":"Skills Development","index":16,"n_rows":83,"n_cols":15,"rows_kept":83,"cut":false,"hidden":false,"merged":[[0,1,0,8],[2,1,2,8],[4,0,6,14],[24,2,24,4],[24,5,24,7],[24,8,24,10],[24,11,24,13],[55,8,55,10],[55,11,55,13],[57,0,57,1],[81,0,81,1],[43,2,43,4],[43,5,43,7],[52,0,52,1],[53,0,53,1],[49,8,49,9],[44,8,44,10],[50,8,50,9],[59,0,59,1],[66,0,66,1],[67,0,67,1],[55,2,55,4],[55,5,55,7]]}
["COMPANY NAME",{"$f":"'Global Business Solutions'!B27","v":"Test"}]
[]
["FINANCIAL INFORMATION USED",{"$f":"'Global Business Solutions'!B29","v":"2017-02-28"}]
[]
["Skills Development Working Paper "]
[]
[]
[]
["Leviable Payroll","SDL * 100","From EMP201"]
["Month","Month"]
[{"$f":"+A12-31","v":"2016-03-24"},{"$f":"C11/1%","v":0}]
["2016-04-24",{"$f":"C12/1%","v":0}]
["2016-05-25",{"$f":"C13/1%","v":0}]
["2016-06-25",{"$f":"C14/1%","v":0}]
["2016-07-26",0]
["2016-08-26",0]
["2016-09-26",0]
["2016-10-27",0]
["2016-11-27",0]
["2016-12-28",0]
[{"$f":"+A22-31","v":"2017-01-28"},0]
[{"$f":"+B3","v":"2017-02-28"},0]
["Total (You may use Budgeted Payroll for the year)",{"$f":"SUM(B11:B22)","v":0},{"$f":"SUM(C11:C22)","v":0}]
[]
["Skills Expenditure",null,"Amount Spent on Black Males",null,null,"Amount Spent on Black Females",null,null,"Amount Spent on Disabled Black Males",null,null,"Amount Spent on Black Female Disabled People"]
["Type of Initiative","Comments","A","I","C","A","I","C","A","I","C","A","I","C","Ref"]
["All Initiatives submitted per SD Table 1",null,{"$f":"+'SD Table 1'!Z33","v":0},{"$f":"+'SD Table 1'!AA33","v":0},{"$f":"+'SD Table 1'!AB33","v":0},{"$f":"+'SD Table 1'!AC33","v":0},{"$f":"+'SD Table 1'!AD33","v":0},{"$f":"+'SD Table 1'!AE33","v":0},{"$f":"+'SD Table 1'!AF33","v":0},{"$f":"+'SD Table 1'!AG33","v":0},{"$f":"+'SD Table 1'!AH33","v":0},{"$f":"+'SD Table 1'!AI33","v":0},{"$f":"+'SD Table 1'!AJ33","v":0},{"$f":"+'SD Table 1'!AK33","v":0},"SDWP-25"]
["All Salary of Learners per SD Table 2",null,{"$f":"'SD Table 2'!N33","v":0},{"$f":"'SD Table 2'!O33","v":0},{"$f":"'SD Table 2'!P33","v":0},{"$f":"'SD Table 2'!Q33","v":0},{"$f":"'SD Table 2'!R33","v":0},{"$f":"'SD Table 2'!S33","v":0},{"$f":"'SD Table 2'!T33","v":0},{"$f":"'SD Table 2'!U33","v":0},{"$f":"'SD Table 2'!V33","v":0},{"$f":"'SD Table 2'!W33","v":0},{"$f":"'SD Table 2'!X33","v":0},{"$f":"'SD Table 2'!Y33","v":0},"SDWP-26"]
["All Bursary Costs per SD Table 3",null,{"$f":"+'SD Table 3'!L33","v":0},{"$f":"+'SD Table 3'!M33","v":0},{"$f":"+'SD Table 3'!N33","v":0},{"$f":"+'SD Table 3'!O33","v":0},{"$f":"+'SD Table 3'!P33","v":0},{"$f":"+'SD Table 3'!Q33","v":0},{"$f":"+'SD Table 3'!R33","v":0},{"$f":"+'SD Table 3'!S33","v":0},{"$f":"+'SD Table 3'!T33","v":0},{"$f":"+'SD Table 3'!U33","v":0},{"$f":"+'SD Table 3'!V33","v":0},{"$f":"+'SD Table 3'!W33","v":0},"SDWP-27"]
["All overhead costs per SD Table 4",null,{"$f":"'SD Table 4'!E20","v":0},{"$f":"'SD Table 4'!F20","v":0},{"$f":"'SD Table 4'!G20","v":0},{"$f":"'SD Table 4'!H20","v":0},{"$f":"'SD Table 4'!I20","v":0},{"$f":"'SD Table 4'!J20","v":0},{"$f":"'SD Table 4'!K20","v":0},{"$f":"'SD Table 4'!L20","v":0},{"$f":"'SD Table 4'!M20","v":0},{"$f":"'SD Table 4'!N20","v":0},{"$f":"'SD Table 4'!O20","v":0},{"$f":"'SD Table 4'!P20","v":0},"SDWP-28"]
[]
["Total",{"$f":"SUM(C32:H32)","v":0},{"$f":"SUM(C27:C30)","v":0},0,0,0,0,0,0,0,0,0,0,0,"SDWP-29"]
[]
["Remove Category F & G",null,{"$f":"+'SD Table 1'!AL33+'SD Table 4'!B33","v":0},{"$f":"+'SD Table 1'!AM33+'SD Table 4'!C33","v":0},{"$f":"+'SD Table 1'!AN33+'SD Table 4'!D33","v":0},{"$f":"+'SD Table 1'!AO33+'SD Table 4'!E33","v":0},{"$f":"+'SD Table 1'!AP33+'SD Table 4'!F33","v":0},{"$f":"+'SD Table 1'!AQ33+'SD Table 4'!G33","v":0},{"$f":"+'SD Table 1'!AR33+'SD Table 4'!H33","v":0},{"$f":"+'SD Table 1'!AS33+'SD Table 4'!I33","v":0},{"$f":"+'SD Table 1'!AT33+'SD Table 4'!J33","v":0},{"$f":"+'SD Table 1'!AU33+'SD Table 4'!K33","v":0},{"$f":"+'SD Table 1'!AV33+'SD Table 4'!L33","v":0},{"$f":"+'SD Table 1'!AW33+'SD Table 4'!M33","v":0},"SDWP-30"]
["Travel, Accommodation and Training",null,{"$f":"'SD Table 1'!AX33","v":0},{"$f":"'SD Table 1'!AY33","v":0},{"$f":"'SD Table 1'!AZ33","v":0},{"$f":"'SD Table 1'!BA33","v":0},{"$f":"'SD Table 1'!BB33","v":0},{"$f":"'SD Table 1'!BC33","v":0},{"$f":"'SD Table 1'!BD33","v":0},{"$f":"'SD Table 1'!BE33","v":0},{"$f":"'SD Table 1'!BF33","v":0},{"$f":"'SD Table 1'!BG33","v":0},{"$f":"'SD Table 1'!BH33","v":0},{"$f":"'SD Table 1'!BI33","v":0},"SDWP-31"]
["Total against which to measure Travel, Accommodation and Training and Categories F & G",{"$f":"+B32*15%","v":0},{"$f":"C32-C34-C35","v":0},{"$f":"D32-D34-D35","v":0},0,0,0,0,0,0,0,0,0,0,"SDWP-32"]
["Categories F & G Percentage",null,{"$f":"IF(C32>0,C34/C32,0)","v":0},{"$f":"IF(D32>0,D34/D32,0)","v":0},0,0,0,0,0,0,0,0,0,0,"SDWP-33"]
["Travel, Accommodation and Training Percentage",null,{"$f":"IF(C32>0,C35/C32,0)","v":0},{"$f":"IF(D32>0,D35/D32,0)","v":0},0,0,0,0,0,0,0,0,0,0]
["Total Recognised Spend Excluding Travel, Accommodation and Training and Categories F & G",null,{"$f":"C36","v":0},{"$f":"D36","v":0},0,0,0,0,0,0,0,0,0,0,"SDWP-34"]
["Categories F & G Value",null,{"$f":"IF(C34>0,IF(C37<15%,C34,(C32*0.15)),0)","v":0},{"$f":"IF(D34>0,IF(D37<15%,D34,(D32*0.15)),0)","v":0},0,0,0,0,0,0,0,0,0,0,"SDWP-35"]
["Travel, Accommodation and Catering",null,{"$f":"IF(C35>0,IF(C38<15%,C35,(C32*0.15)),0)","v":0},{"$f":"IF(D35>0,IF(D38<15%,D35,(D32*0.15)),0)","v":0},0,0,0,0,0,0,0,0,0,0,"SDWP-36"]
["Total Spend Recognised",null,{"$f":"SUM(C39:C41)","v":0},{"$f":"SUM(D39:D41)","v":0},0,0,0,0,0,0,0,0,0,0,"SDWP-37"]
[]
[null,null,"Amount Spent on Black Males",null,null,"Amount Spent on Black Females"]
[null,null,"A","I","C","A","I","C","Disabled"]
["EAP Target",null,{"$f":"+'Employment Equity Worksheet'!B20","v":0.42799999999999999},{"$f":"+'Employment Equity Worksheet'!C20","v":1.7999999999999999E-2},{"$f":"+'Employment Equity Worksheet'!D20","v":5.2999999999999999E-2},{"$f":"+'Employment Equity Worksheet'!G20","v":0.35099999999999998},{"$f":"+'Employment Equity Worksheet'!H20","v":0.01},{"$f":"+'Employment Equity Worksheet'!I20","v":4.4999999999999998E-2},"total spend",null,{"$f":"IF($B$23>0,SUM(I42:N42),0)","v":0}]
["Adjusted EAP",null,{"$f":"+'Employment Equity Worksheet'!B21","v":0.47292817679558008},{"$f":"+'Employment Equity Worksheet'!C21","v":1.9889502762430938E-2},{"$f":"+'Employment Equity Worksheet'!D21","v":5.8563535911602203E-2},{"$f":"+'Employment Equity Worksheet'!G21","v":0.38784530386740329},{"$f":"+'Employment Equity Worksheet'!H21","v":1.1049723756906077E-2},{"$f":"+'Employment Equity Worksheet'!I21","v":4.9723756906077346E-2},"Leviable Amount",null,{"$f":"+B23","v":0}]
["Points available",null,8,null,null,null,null,null,"Points available",null,4]
["Target",null,0.06,null,null,null,null,null,"Target",null,3.0000000000000001E-3]
["Points per Category",null,{"$f":"ROUND($C$48*C47,2)","v":3.78},0.16,0.47,3.1,0.09,0.4,"Calculate Score",null,{"$f":"IF(K47>0,IF((K46/K47)/K49*K48>K48,K48,(K46/K47)/K49*K48),0)","v":0}]
["Target per category",null,{"$f":"ROUND($C$49*C47,4)","v":2.8400000000000002E-2},1.1999999999999999E-3,3.5000000000000001E-3,2.3300000000000001E-2,6.9999999999999999E-4,3.0000000000000001E-3,"Percentage achieved",null,{"$f":"IF(K47>0,K46/K47,0)","v":0}]
["Total Black Training  %",null,{"$f":"IF($B$23>0,C42/$B$23,0)","v":0},0,0,0,0,0]
["Points Scored",null,{"$f":"IF(C52/C51*C50>C50,C50,ROUND(C52/C51*C50,2))","v":0},0,0,0,0,0]
["Calculate Score",null,{"$f":"SUM(C53:H53)","v":0},{"$f":"IF(K47>0,SUM(C42:H42)/K47,0)","v":0}]
[]
[null,null,"Black Males - Learnerships",null,null,"Black Females - Learnerships",null,null,"Black Males - Unemployed Training",null,null,"Black Females - Unemployed Training"]
[null,null,"A","I","C","A","I","C","A","I","C","A","I","C"]
["EAP Target",null,{"$f":"+C46","v":0.42799999999999999},1.7999999999999999E-2,5.2999999999999999E-2,0.35099999999999998,0.01,4.4999999999999998E-2,{"$f":"+C58","v":0.42799999999999999},{"$f":"+D58","v":1.7999999999999999E-2},5.2999999999999999E-2,0.35099999999999998,0.01,4.4999999999999998E-2]
["Adjusted EAP",null,{"$f":"+C47","v":0.47292817679558008},1.9889502762430938E-2,5.8563535911602203E-2,0.38784530386740329,1.1049723756906077E-2,4.9723756906077346E-2,{"$f":"+C59","v":0.47292817679558008},1.9889502762430938E-2,5.8563535911602203E-2,0.38784530386740329,1.1049723756906077E-2,4.9723756906077346E-2]
["Black people",null,{"$f":"'SD Table 2'!N34","v":0},{"$f":"'SD Table 2'!O34","v":0},{"$f":"'SD Table 2'!P34","v":0},{"$f":"'SD Table 2'!Q34","v":0},{"$f":"'SD Table 2'!R34","v":0},{"$f":"'SD Table 2'!S34","v":0},{"$f":"'SD Table 5'!J33","v":0},{"$f":"'SD Table 5'!K33","v":0},{"$f":"'SD Table 5'!L33","v":0},{"$f":"'SD Table 5'!M33","v":0},{"$f":"'SD Table 5'!N33","v":0},{"$f":"'SD Table 5'!O33","v":0}]
["Total Employees",null,{"$f":"'Targets & Inputs'!D17","v":0}]
["Black %",null,{"$f":"IF($C$61>0,C60/$C$61,0)","v":0},{"$f":"IF($C$61>0,D60/$C$61,0)","v":0},0,0,0,0,0,0,0,0,0,0]
["Points available",null,4,null,null,null,null,null,4]
["Target",null,2.5000000000000001E-2,null,null,null,null,null,2.5000000000000001E-2]
["Points per Category",null,{"$f":"ROUND($C$63*C59,2)","v":1.89},0.08,0.23,1.55,0.04,0.2,1.89,0.08,0.23,1.55,0.04,0.2]
["Target per category",null,{"$f":"ROUND($C$64*C59,4)","v":1.18E-2},5.0000000000000001E-4,1.5E-3,9.7000000000000003E-3,2.9999999999999997E-4,1.1999999999999999E-3,1.18E-2,5.0000000000000001E-4,1.5E-3,9.7000000000000003E-3,2.9999999999999997E-4,1.1999999999999999E-3]
["Points Scored",null,{"$f":"IF(C66>0,IF(C62/C66*C65>C65,C65,ROUND(C62/C66*C65,2)),0)","v":0},{"$f":"IF(D66>0,IF(D62/D66*D65>D65,D65,ROUND(D62/D66*D65,2)),0)","v":0},0,0,0,0,0,0,0,0,0,0]
["Calculate Score",null,{"$f":"SUM(C67:H67)","v":0},{"$f":"IF(C61>0,SUM(C60:H60)/$C$61,0)","v":0},null,null,null,null,{"$f":"SUM(I67:N67)","v":0},{"$f":"IF(I61>0,SUM(I60:N60)/$C$61,0)","v":0}]
[]
[null,"Black Unemployed"]
["Black Learners - Employed",{"$f":"'SD Table 6'!B35","v":0}]
["Total Number of Learners completing learnerships",{"$f":"'SD Table 6'!B34","v":0}]
["Scored",{"$f":"IF(B72>0,B71/B72,0)","v":0}]
["Target",1]
[]
["Industry SETA"]
[]
[]
["Score for Skills Spend",null,1.2332324756843136]
["Score for Disabled Skills Spend",null,0.93415404044853623]
["Learners - Black ",null,4]
["Black Unemployed people participating in training per the Matrix",null,"No Data available"]
["Absorption of Learners",null,"No Data available"]

{"sheet":"Procurement Recognition","index":17,"n_rows":35,"n_cols":29,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
["Client Name",{"$f":"'Global Business Solutions'!B27","v":"Test"}]
[]
["FINANCIAL INFORMATION USED",{"$f":"'Global Business Solutions'!B29","v":"2017-02-28"}]
[]
["Preferential Procurement                    "]
["Details of BEE suppliers"]
["Measurement period",{"$f":"+C7-364","v":"2016-03-01"},{"$f":"+B3","v":"2017-02-28"}]
["Supplier Name","Supplier Code","Expiry Date","Currency","Comments","Classification ",null,null,null,null,"Level Contribution Status (0 to 9)","BEE Recognition Level","Level 9 Exclusions","Exclusions Total","Total Procurement Spend","Total Procurement Spend - Last Financial Year","SD beneficiary with 3 yr contract","Black EME/QSE (Non SD) with 3 yr contract","First time suppplier","Supplier an Empowering Supplier?","Supplier Greater than 51% Black Owned?",null,"Supplier Greater than 30% Black Women Owned?",null,">51% black owned & Designated Group Supplier ",null,"Proof of BEE Status Available for Inspection?","Recognised Procurement"]
[null,null,null,null,null,"QSE (Y/N)","EME (Y/N)","Other/Generic (Y/N)","Recognised QSE","Recognised EME","0=no certificate, 9=Exclusion","0% - 135%","Reason",null,"Annual EXCL VAT","R 's","Y = 1.2, N = 1","Y = 1.2, N = 1","Y = 1.2, N = 1"," (Y/N)"," (Y/N)","Recognised"," (Y/N)","Recognised "," (Y/N)","Recognised "," (Y/N)"]
[null,null,null,null,null,"","",null,{"$f":"IF(F10=\"Y\",AB10,0)","v":0},{"$f":"IF(G10=\"Y\",AB10,0)","v":0},null,{"$f":"IF(K10>0,VLOOKUP(K10,Scorecard!$A$77:$D$87,4,FALSE),0)","v":0},null,{"$f":"IF(K10=9,P10,0)","v":0},null,{"$f":"SUM(O10:O10)","v":0},null,null,null,"Y",null,{"$f":"IF(U10=\"Y\",AB10,0)","v":0},null,{"$f":"IF(W10=\"Y\",AB10,0)","v":0},null,{"$f":"IF(Y10=\"Y\",AB10,0)","v":0},{"$f":"IF(AND(C10>$B$7,T10=\"Y\"),\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(T10=\"Y\",AA10=\"Y\"),O10*L10*Q10*R10*S10,0)","v":0},{"$f":"SUM(Q10:S10)","v":0}]
[null,null,null,null,null,"","",null,{"$f":"IF(F11=\"Y\",AB11,0)","v":0},{"$f":"IF(G11=\"Y\",AB11,0)","v":0},null,{"$f":"IF(K11>0,VLOOKUP(K11,Scorecard!$A$77:$D$87,4,FALSE),0)","v":0},null,{"$f":"IF(K11=9,P11,0)","v":0},null,{"$f":"SUM(O11:O11)","v":0},null,null,null,"Y",null,{"$f":"IF(U11=\"Y\",AB11,0)","v":0},null,{"$f":"IF(W11=\"Y\",AB11,0)","v":0},null,{"$f":"IF(Y11=\"Y\",AB11,0)","v":0},{"$f":"IF(AND(C11>$B$7,T11=\"Y\"),\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(T11=\"Y\",AA11=\"Y\"),O11*L11*Q11*R11*S11,0)","v":0},0]
[null,null,null,null,null,"","",null,0,0,null,{"$f":"IF(K12>0,VLOOKUP(K12,Scorecard!$A$77:$D$87,4,FALSE),0)","v":0},null,0,null,0,null,null,null,"Y",null,0,null,0,null,0,"N",0,0]
[null,null,null,null,null,"","",null,0,0,null,{"$f":"IF(K13>0,VLOOKUP(K13,Scorecard!$A$77:$D$87,4,FALSE),0)","v":0},null,0,null,0,null,null,null,"Y",null,0,null,0,null,0,"N",0,0]
[null,null,null,null,null,"","",null,0,0,null,{"$f":"IF(K14>0,VLOOKUP(K14,Scorecard!$A$77:$D$87,4,FALSE),0)","v":0},null,0,null,0,null,null,null,"Y",null,0,null,0,null,0,"N",0,0]
[null,null,null,null,null,"","",null,0,0,null,{"$f":"IF(K15>0,VLOOKUP(K15,Scorecard!$A$77:$D$87,4,FALSE),0)","v":0},null,0,null,0,null,null,null,"Y",null,0,null,0,null,0,"N",0,0]
[null,null,null,null,null,"","",null,0,0,null,{"$f":"IF(K16>0,VLOOKUP(K16,Scorecard!$A$77:$D$87,4,FALSE),0)","v":0},null,0,null,0,null,null,null,"Y",null,0,null,0,null,0,"N",0,0]
[null,null,null,null,null,"","",null,0,0,null,{"$f":"IF(K17>0,VLOOKUP(K17,Scorecard!$A$77:$D$87,4,FALSE),0)","v":0},null,0,null,0,null,null,null,"Y",null,0,null,0,null,0,"N",0,0]
[null,null,null,null,null,"","",null,0,0,null,{"$f":"IF(K18>0,VLOOKUP(K18,Scorecard!$A$77:$D$87,4,FALSE),0)","v":0},null,0,null,0,null,null,null,"Y",null,0,null,0,null,0,"N",0,0]
[null,null,null,null,null,"","",null,0,0,null,{"$f":"IF(K19>0,VLOOKUP(K19,Scorecard!$A$77:$D$87,4,FALSE),0)","v":0},null,0,null,0,null,null,null,"Y",null,0,null,0,null,0,"N",0,0]
[null,null,null,null,null,"","",null,0,0,null,{"$f":"IF(K20>0,VLOOKUP(K20,Scorecard!$A$77:$D$87,4,FALSE),0)","v":0},null,0,null,0,null,null,null,"Y",null,0,null,0,null,0,"N",0,0]
[null,null,null,null,null,"","",null,0,0,null,{"$f":"IF(K21>0,VLOOKUP(K21,Scorecard!$A$77:$D$87,4,FALSE),0)","v":0},null,0,null,0,null,null,null,"Y",null,0,null,0,null,0,"N",0,0]
[null,null,null,null,null,"","",null,0,0,null,{"$f":"IF(K22>0,VLOOKUP(K22,Scorecard!$A$77:$D$87,4,FALSE),0)","v":0},null,0,null,0,null,null,null,"Y",null,0,null,0,null,0,"N",0,0]
[null,null,null,null,null,"","",null,0,0,null,{"$f":"IF(K23>0,VLOOKUP(K23,Scorecard!$A$77:$D$87,4,FALSE),0)","v":0},null,0,null,0,null,null,null,"Y",null,0,null,0,null,0,"N",0,0]
[null,null,null,null,null,"","",null,0,0,null,{"$f":"IF(K24>0,VLOOKUP(K24,Scorecard!$A$77:$D$87,4,FALSE),0)","v":0},null,0,null,0,null,null,null,"Y",null,0,null,0,null,0,"N",0,0]
[null,null,null,null,null,"","",null,0,0,null,{"$f":"IF(K25>0,VLOOKUP(K25,Scorecard!$A$77:$D$87,4,FALSE),0)","v":0},null,0,null,0,null,null,null,"Y",null,0,null,0,null,0,"N",0,0]
[null,null,null,null,null,"","",null,0,0,null,{"$f":"IF(K26>0,VLOOKUP(K26,Scorecard!$A$77:$D$87,4,FALSE),0)","v":0},null,0,null,0,null,null,null,"Y",null,0,null,0,null,0,"N",0,0]
[null,null,null,null,null,"","",null,0,0,null,{"$f":"IF(K27>0,VLOOKUP(K27,Scorecard!$A$77:$D$87,4,FALSE),0)","v":0},null,0,null,0,null,null,null,"Y",null,0,null,0,null,0,"N",0,0]
[null,null,null,null,null,"","",null,0,0,null,{"$f":"IF(K28>0,VLOOKUP(K28,Scorecard!$A$77:$D$87,4,FALSE),0)","v":0},null,0,null,0,null,null,null,"Y",null,0,null,0,null,0,"N",0,0]
[null,null,null,null,null,"","",null,0,0,null,{"$f":"IF(K29>0,VLOOKUP(K29,Scorecard!$A$77:$D$87,4,FALSE),0)","v":0},null,0,null,0,null,null,null,"Y",null,0,null,0,null,0,"N",0,0]
[null,null,null,null,null,"","",null,0,0,null,{"$f":"IF(K30>0,VLOOKUP(K30,Scorecard!$A$77:$D$87,4,FALSE),0)","v":0},null,0,null,0,null,null,null,"Y",null,0,null,0,null,0,"N",0,0]
[null,null,null,null,null,null,null,null,{"$f":"IF(F31=\"Y\",AB31,0)","v":0},{"$f":"IF(G31=\"Y\",AB31,0)","v":0},null,{"$f":"IF(K31>0,VLOOKUP(K31,Scorecard!$A$77:$D$87,4,FALSE),0)","v":0},null,{"$f":"IF(K31=9,P31,0)","v":0},null,{"$f":"SUM(O31:O31)","v":0},null,null,null,"Y",null,{"$f":"IF(U31=\"Y\",AB31,0)","v":0},null,{"$f":"IF(W31=\"Y\",AB31,0)","v":0},null,{"$f":"IF(Y31=\"Y\",AB31,0)","v":0},{"$f":"IF(AND(C31>$B$7,T31=\"Y\"),\"Y\",\"N\")","v":"N"},0]
["Insert Lines above"]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I10:I32)","v":0},{"$f":"SUM(J10:J32)","v":0},null,null,null,{"$f":"SUM(N10:N32)","v":0},null,{"$f":"SUM(P10:P32)","v":0},null,null,null,null,null,{"$f":"SUM(V10:V32)","v":0},null,{"$f":"SUM(X10:X32)","v":0},null,{"$f":"SUM(Z10:Z31)","v":0},null,{"$f":"SUM(AB10:AB32)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(I33:J33)","v":0},null,null,null,0,null,0,null,null,null,null,null,0,null,0,null,0,null,0]
[null,null,null,null,null,null,null,null,0,0]

{"sheet":"Procurement Calculation","index":18,"n_rows":28,"n_cols":6,"rows_kept":28,"cut":false,"hidden":false,"merged":[[4,0,4,5],[0,1,0,4],[2,1,2,4],[22,0,22,1],[23,0,23,1],[21,0,21,1],[15,0,15,1],[16,0,16,1],[17,0,17,1],[19,0,20,0],[18,0,18,1]]}
["COMPANY NAME",{"$f":"'Global Business Solutions'!B27","v":"Test"}]
[]
["FINANCIAL INFORMATION USED",{"$f":"'Global Business Solutions'!B29","v":"2017-02-28"}]
[]
["Preferential Procurement                    "]
[]
["Total Measured Procurement Spend",{"$f":"TMPS!D18","v":0}]
["Recognised Procurement",{"$f":"'Procurement Recognition'!AB33","v":0}]
["QSE Spend",{"$f":"+'Procurement Recognition'!I33","v":0}]
["EME Spend",{"$f":"+'Procurement Recognition'!J33","v":0}]
["Black Owned Spend",{"$f":"'Procurement Recognition'!V33","v":0}]
["Black Women Owned Spend",{"$f":"'Procurement Recognition'!X33","v":0}]
["51% black owned designated group spend",{"$f":"'Procurement Recognition'!Z33","v":0}]
[]
["Calculations"]
["Procurement Indicator",null,"Company Performance","Compliance Target","Weighting Points ","Score"]
["B-BBEE Procurement Spend from all Empowering Suppliers as % of Measured Spend",null,{"$f":"IF($B$7>0,B8/$B$7,0)","v":0},{"$f":"+Scorecard!E39","v":0.8},{"$f":"+Scorecard!F39","v":5},{"$f":"IF(C17/D17*E17>E17,E17,C17/D17*E17)","v":0}]
["BEE Procurement Spend from Empowering QSE Suppliers",null,0,{"$f":"+Scorecard!E40","v":0.15},{"$f":"+Scorecard!F40","v":3},0]
["BEE Procurement Spend from EME Suppliers",null,0,{"$f":"+Scorecard!E41","v":0.15},{"$f":"+Scorecard!F41","v":4},0]
["Spend from Black Owned Suppliers","Black  Owned",0,{"$f":"+Scorecard!E42","v":0.4},{"$f":"+Scorecard!F42","v":9},0]
[null,"Black Woman Owned",0,{"$f":"+Scorecard!E43","v":0.12},{"$f":"+Scorecard!F43","v":4},0]
["BBBEE Spend from Designated Group Suppliers >=51% Black Owned",null,0,{"$f":"+Scorecard!E44","v":0.02},{"$f":"+Scorecard!F44","v":2},0]
["Supplier Development",null,{"$f":"'ED & SD'!C55","v":0},{"$f":"+Scorecard!E45","v":0.02},{"$f":"+Scorecard!F45","v":10},{"$f":"+'ED & SD'!B47","v":0}]
["Enterprise Development",null,{"$f":"'ED & SD'!C56","v":0},{"$f":"+Scorecard!E46","v":0.01},{"$f":"+Scorecard!F46","v":5},{"$f":"+'ED & SD'!C47","v":0}]
["Graduation to Supplier Development from Enterprise Development",null,0,{"$f":"+Scorecard!E47","v":1},{"$f":"+Scorecard!F47","v":1},{"$f":"IF(C25>=1,E25,0)","v":0}]
["Creating one or more Jobs via Supplier or Enterprise Development",null,0,{"$f":"+Scorecard!E48","v":1},{"$f":"+Scorecard!F48","v":1},{"$f":"IF(C26>=1,E26,0)","v":0}]
[]
[null,null,null,null,null,{"$f":"SUM(F17:F27)","v":0}]

{"sheet":"TMPS","index":19,"n_rows":52,"n_cols":4,"rows_kept":52,"cut":false,"hidden":false,"merged":[[0,1,0,4],[2,1,2,4],[4,0,6,4]]}
["COMPANY NAME",{"$f":"'Global Business Solutions'!B27","v":"Test"}]
[]
["FINANCIAL INFORMATION USED",{"$f":"'Global Business Solutions'!B29","v":"2017-02-28"}]
[]
["TMPS & NPAT"]
[]
[]
[]
[null,null,{"$f":"'Procurement Recognition'!C7","v":"2017-02-28"},"Total"]
["COS",null,{"$f":"+'Procurement Recognition'!P33","v":0},{"$f":"SUM(C10:C10)","v":0}]
["Operational Expenditure",null,0,{"$f":"SUM(C11:C11)","v":0}]
["Capex",null,0,0]
["Interest & Finance Charges",null,0,0]
["Miscellaneous",null,0,0]
["Total Expenditure",null,{"$f":"SUM(C10:C14)","v":0},{"$f":"SUM(D10:D14)","v":0}]
["Imports and Government Suppliers per schedule",null,null,{"$f":"'Procurement Recognition'!N33","v":0}]
["Exclusions - per Table below",null,{"$f":"+C49","v":0},{"$f":"SUM(C17:C17)","v":0}]
["TMPS",null,{"$f":"C15-C17","v":0},{"$f":"(D15-D17-D16)","v":0}]
[null,null,0]
["Exclusions"]
[]
["Bad debts",null,0,{"$f":"SUM(C22:C22)","v":0}]
["Depreciation",null,0,0]
["Donations ",null,0,0]
["Fines",null,0,0]
["Licences and levies",null,0,0]
["Loss on sale of Fixed Assets",null,0,0]
["Labour",null,0,0]
["Travel Allowances",null,0,0]
["Rates & Taxes",null,0,0]
["Skills development Levies",null,0,0]
["Tender Costs",null,0,0]
["Overseas Travel",null,0,0]
["Vehicle Adjustment",null,0,0]
["Obsolescence",null,0,0]
["Stock Adjustment",null,0,0]
["Utilities",null,0,0]
["Customs Duty",null,0,0]
["Royalties",null,0,0]
["Stock Losses",null,0,0]
["Fines",null,0,0]
["Taxation",null,0,0]
["Impairment Loss",null,0,0]
["Management fees",null,0,0]
["Annual Duty",null,0,0]
["Discount",null,0,0]
["Imports",null,0,0]
["Miscellaneous",null,0,0]
[null,null,{"$f":"SUM(C21:C48)","v":0},{"$f":"SUM(D22:D48)","v":0}]
[]
["Net Profit after Tax",null,{"$f":"+'Targets & Inputs'!C20","v":0},{"$f":"SUM(C51:C51)","v":0}]
["Turnover",null,{"$f":"+'Targets & Inputs'!C19","v":0},{"$f":"SUM(C52:C52)","v":0}]

{"sheet":"ED & SD","index":20,"n_rows":89,"n_cols":15,"rows_kept":89,"cut":false,"hidden":false,"merged":[[30,8,30,10],[11,8,11,10],[0,1,0,4],[2,1,2,4],[4,0,6,14],[8,8,8,10],[9,8,9,10],[10,8,10,10],[12,8,12,10],[13,8,13,10],[14,8,14,10],[15,8,15,10],[16,8,16,10],[17,8,17,10],[18,8,18,10],[19,8,19,10],[20,8,20,10],[21,8,21,10],[22,8,22,10],[23,8,23,10],[24,8,24,10],[25,8,25,10],[26,8,26,10],[27,8,27,10],[28,8,28,10],[29,8,29,10]]}
["COMPANY NAME",{"$f":"'Global Business Solutions'!B27","v":"Test"}]
[]
["FINANCIAL INFORMATION USED",{"$f":"'Global Business Solutions'!B29","v":"2017-02-28"}]
[]
["Enterprise Development "]
[]
[]
[]
["Beneficiaries - If beneficiary is also supplier please use exact name as used in Procurement Recognition Sheet","Enterprise/Supplier Development","Contribution Type","Monetary or Non Monetary","Contribution Factor per Matrix","amount claimed","amount recognised","ref","Comments",null,null,"Supplier Development","Enterprise Development","Supplier Development - Early Settlement","Enterprise Development - Early Settlement"]
["Early Payments","Enterprise Development","Early Payment","Non Monetary",1,{"$f":"+'Early Payments - ED'!H24","v":0},{"$f":"F10*E10","v":0},"ED-1",null,null,null,null,0,{"$f":"IF(AND(B10=\"Supplier Development\",C10=\"Early Payment\"),G10,0)","v":0},{"$f":"IF(AND(B10=\"Enterprise Development\",C10=\"Early Payment\"),G10,0)","v":0}]
["Early Payments","Supplier Development","Early Payment","Non Monetary",1,{"$f":"+'Early Payments - SD'!H32","v":0},{"$f":"F11*E11","v":0},"ED-2",null,null,null,0,null,{"$f":"IF(AND(B11=\"Supplier Development\",C11=\"Early Payment\"),G11,0)","v":0},{"$f":"IF(AND(B11=\"Enterprise Development\",C11=\"Early Payment\"),G11,0)","v":0}]
[null,null,"Direct Cost","Monetary",{"$f":"VLOOKUP(C12,$D$76:$E$89,2,FALSE)","v":1},null,{"$f":"F12*E12","v":0},"ED-3",null,null,null,{"$f":"IF(B12=\"Supplier Development\",G12,0)","v":0},{"$f":"IF(B12=\"Enterprise Development\",G12,0)","v":0},{"$f":"IF(AND(B12=\"Supplier Development\",C12=\"Early Payment\"),G12,0)","v":0},{"$f":"IF(AND(B12=\"Enterprise Development\",C12=\"Early Payment\"),G12,0)","v":0}]
[null,null,"Direct Cost","Monetary",1,null,{"$f":"F13*E13","v":0},"ED-4",null,null,null,{"$f":"IF(B13=\"Supplier Development\",G13,0)","v":0},{"$f":"IF(B13=\"Enterprise Development\",G13,0)","v":0},{"$f":"IF(AND(B13=\"Supplier Development\",C13=\"Early Payment\"),G13,0)","v":0},{"$f":"IF(AND(B13=\"Enterprise Development\",C13=\"Early Payment\"),G13,0)","v":0}]
[null,null,"Direct Cost","Monetary",1,null,{"$f":"F14*E14","v":0},"ED-5",null,null,null,0,0,0,0]
[null,null,"Direct Cost","Monetary",1,null,0,"ED-6",null,null,null,0,0,0,0]
[null,null,"Direct Cost","Monetary",1,null,0,"ED-7",null,null,null,0,0,0,0]
[null,null,"Employee Time","Monetary",0.6,null,0,"ED-8",null,null,null,0,0,0,0]
[null,null,"Direct Cost","Monetary",1,null,0,"ED-9",null,null,null,0,0,0,0]
[null,null,"Employee Time","Monetary",0.6,null,0,"ED-10",null,null,null,0,0,0,0]
[null,null,"Employee Time","Monetary",0.6,null,0,"ED-11",null,null,null,0,0,0,0]
[null,null,"Employee Time","Monetary",0.6,null,0,"ED-12",null,null,null,0,0,0,0]
[null,null,"Employee Time","Monetary",0.6,null,0,"ED-13",null,null,null,0,0,0,0]
[null,null,"Direct Cost","Monetary",1,null,0,"ED-14",null,null,null,0,0,0,0]
[null,null,"Grant","Monetary",1,null,0,"ED-15",null,null,null,0,0,0,0]
[null,null,"Grant","Monetary",1,null,0,"ED-16",null,null,null,0,0,0,0]
[null,null,"Grant","Monetary",1,null,0,"ED-17",null,null,null,0,0,0,0]
[null,null,"Grant","Monetary",1,null,0,"ED-18",null,null,null,0,0,0,0]
[null,null,"Grant","Monetary",1,null,0,"ED-19",null,null,null,0,0,0,0]
[null,null,"Employee Time","Monetary",0.6,null,0,"ED-20",null,null,null,0,0,0,0]
[null,null,"Employee Time","Monetary",0.6,null,0,"ED-21",null,null,null,0,0,0,0]
["Insert lines above"]
[null,null,null,null,null,null,{"$f":"SUM(G10:G31)","v":0},null,null,null,null,{"$f":"SUM(L10:L31)","v":0},{"$f":"SUM(M10:M31)","v":0},{"$f":"SUM(N10:N31)","v":0},{"$f":"SUM(O10:O31)","v":0}]
[]
["Makeup","Supplier Development","Enterprise Development","Total"]
["Early Settlement",{"$f":"+N32","v":0},{"$f":"+O32","v":0},{"$f":"+B35+C35","v":0}]
["Other ",{"$f":"+L32","v":0},{"$f":"+M32","v":0},{"$f":"+B36+C36","v":0}]
[null,{"$f":"SUM(B35:B36)","v":0},{"$f":"SUM(C35:C36)","v":0},{"$f":"SUM(D35:D36)","v":0}]
[]
[null,"Supplier Development","Enterprise Development"]
["Points Available",{"$f":"+Scorecard!F45","v":10},{"$f":"+Scorecard!F46","v":5}]
["Targets",0.02,{"$f":"+Scorecard!E46","v":0.01}]
["Spend Required",{"$f":"+B41*C54","v":0},{"$f":"+C41*C54","v":0}]
[]
["Scoring","Supplier Development","Enterprise Development"]
["Early Settlement",{"$f":"IF($C$54>0,IF(B35/$C$54/B41*B40>15%*B40,15%*B40,ROUND(B35/$C$54/B41*B40,2)),0)","v":0},{"$f":"IF($C$54>0,IF(C35/$C$54/C41*C40>15%*C40,15%*C40,ROUND(C35/$C$54/C41*C40,2)),0)","v":0}]
["Other ",{"$f":"IF($C$54>0,IF((B36/$C$54/B41*B40)+B45>B40,B40-B45,ROUND(B36/$C$54/B41*B40,2)),0)","v":0},{"$f":"IF($C$54>0,IF((C36/$C$54/C41*C40)+C45>C40,C40-C45,ROUND(C36/$C$54/C41*C40,2)),0)","v":0}]
[null,{"$f":"SUM(B45:B46)","v":0},{"$f":"SUM(C45:C46)","v":0}]
[]
["Percentages","Supplier Development","Enterprise Development"]
["Early Settlement",{"$f":"IF(C54>0,B35/$C$54,0)","v":0},{"$f":"IF(C54>0,C35/$C$54,0)","v":0}]
["Other ",{"$f":"IF(C54>0,B36/$C$54,0)","v":0},{"$f":"IF(C54>0,C36/$C$54,0)","v":0}]
[null,{"$f":"SUM(B50:B51)","v":0},{"$f":"SUM(C50:C51)","v":0}]
[]
["Net Profit after tax ",null,{"$f":"HLOOKUP(D54,B71:J74,4)","v":0},{"$f":"'Targets & Inputs'!C23","v":"Table 3"}]
["% spend of NPAT - Supplier Dev",null,{"$f":"+B52","v":0}]
["% spend of NPAT - Enterprise Dev",null,{"$f":"+C52","v":0}]
[]
[{"$f":"+'Targets & Inputs'!A166","v":"2016-12-31"},"All Industries","Mining & Quarrying","Manufacturing","Electricity, Gas & Water Supply","Construction","Trade","Transport, Storage & Communication","Real Estate & Other Business Services","Community, Social and Personnal Services"]
[null,"Table 1","Table 2","Table 3","Table 4","Table 5","Table 6","Table 7","Table 8","Table 9"]
["Stats SA Returns"]
["Turnover",{"$f":"'Targets & Inputs'!B169","v":2309987},{"$f":"'Targets & Inputs'!C169","v":158235},{"$f":"'Targets & Inputs'!D169","v":645643},{"$f":"'Targets & Inputs'!E169","v":56197},{"$f":"'Targets & Inputs'!F169","v":109228},{"$f":"'Targets & Inputs'!G169","v":810779},{"$f":"'Targets & Inputs'!H169","v":203834},{"$f":"'Targets & Inputs'!I169","v":270075},{"$f":"'Targets & Inputs'!J169","v":55996}]
["Net profit before Tax",{"$f":"'Targets & Inputs'!B170","v":164904},{"$f":"'Targets & Inputs'!C170","v":23915},{"$f":"'Targets & Inputs'!D170","v":38725},{"$f":"'Targets & Inputs'!E170","v":-197},{"$f":"'Targets & Inputs'!F170","v":3713},{"$f":"'Targets & Inputs'!G170","v":44922},{"$f":"'Targets & Inputs'!H170","v":16409},{"$f":"'Targets & Inputs'!I170","v":35077},{"$f":"'Targets & Inputs'!J170","v":2340}]
["Tax",{"$f":"'Targets & Inputs'!B171","v":31644},{"$f":"'Targets & Inputs'!C171","v":5820},{"$f":"'Targets & Inputs'!D171","v":8716},{"$f":"'Targets & Inputs'!E171","v":504},{"$f":"'Targets & Inputs'!F171","v":1497},{"$f":"'Targets & Inputs'!G171","v":5616},{"$f":"'Targets & Inputs'!H171","v":3862},{"$f":"'Targets & Inputs'!I171","v":4454},{"$f":"'Targets & Inputs'!J171","v":1175}]
["Net Profit after Tax",{"$f":"+B62-B63","v":133260},{"$f":"+C62-C63","v":18095},30009,-701,2216,39306,12547,30623,{"$f":"+J62-J63","v":1165}]
["NPAT %",{"$f":"IF(B61>0,B64/B61,0)","v":5.7688636342975087E-2},{"$f":"IF(C61>0,C64/C61,0)","v":0.11435523114355231},4.6479246270771928E-2,-1.2473975479118103E-2,2.0287838283224082E-2,4.8479302004615317E-2,6.1554990825868107E-2,0.11338702212348421,{"$f":"IF(J61>0,J64/J61,0)","v":2.0805057504107435E-2}]
[0.25,{"$f":"+B65*$A$66","v":1.4422159085743772E-2},{"$f":"+C65*$A$66","v":2.8588807785888078E-2},1.1619811567692982E-2,-3.1184938697795257E-3,5.0719595708060205E-3,1.2119825501153829E-2,1.5388747706467027E-2,2.8346755530871053E-2,{"$f":"+J65*$A$66","v":5.2012643760268587E-3}]
[]
["Client Figures"]
["Turnover",{"$f":"TMPS!C52","v":0},{"$f":"+B69","v":0},{"$f":"+C69","v":0},0,0,0,0,0,{"$f":"+I69","v":0}]
[]
[null,"Table 1","Table 2","Table 3","Table 4","Table 5","Table 6","Table 7","Table 8","Table 9"]
["Industry Norm NPAT",{"$f":"+B69*B66","v":0},0,0,0,0,0,0,0,0]
["NPAT",{"$f":"+TMPS!C51","v":0},{"$f":"+B73","v":0},{"$f":"+C73","v":0},0,0,0,0,0,{"$f":"+I73","v":0}]
["Figure Used",{"$f":"IF(B72>B73,B72,B73)","v":0},{"$f":"IF(C72>C73,C72,C73)","v":0},0,0,0,0,0,0,{"$f":"IF(J72>J73,J72,J73)","v":0}]
[]
[null,"Qualifying Contribution type","Contribution Amount","Contribution Amount","Benefit Factor"]
["Grant and Related Contributions","Grant Contribution","Full Grant Amount","Grant",1]
[null,"Direct Cost incurred in supporting Enterprise Development and Supplier Development","Verifiable Cost (including both monetary and non-monetary)","Direct Cost",1]
[null,"Discounts in addition to normal business practices supporting Enterprise Development and Supplier Development","Discount Amount (in addition to normal business discount)","Discount",1]
[null,"Overhead Costs incurred in supporting Enterprise Development and Supplier Development (including people appointed in Enterprise Development and Supplier Development)","Verifiable Costs (including both monetary and non-monetary)","Overhead Costs",0.7]
["Loans and Related Contributions","Interest-Free Loan with no security requirements supporting Enterprise Development and Supplier Development","Outstanding Loan Amount","Interest Free Loan",0.7]
[null,"Standard Loan to Enterprise Development and Supplier Development Beneficiaries","Outstanding Loan Amount","Standard Loan",0.5]
[null,"Guarantees provided on behalf of a Beneficiary entity","Guarantee Amount","Guarantee Amount",0.03]
[null,"Lower Interest Rate","Outstanding loan amount","Lower interest Rate","Prime Rate - Actual Rate"]
["Equity Investments and Related Contributions","Minority Investment in Enterprise Development and Supplier Development Beneficiaries","Investment Amount","Equity Investment",0.7]
[null,"Enterprise Development and Supplier Development Investment with lower dividend to financier","Investment Amount","Investment Amount",1]
["Contributions made in the form of human resource capacity","Professional services rendered at no cost and supporting Enterprise Development and Supplier Development","Commercial hourly rate of professional","Professional Services",0.6]
[null,"Professional services rendered at a discount and supporting Enterprise Development and Supplier Development","Value of discount based on commercial hourly rate of professional","Discounted Professional Services",0.6]
[null,"Time of employees of Measured Entity productively deployed in assisting beneficiaries","Monthly salary divided by 160","Employee Time",0.6]

{"sheet":"Early Payments - ED","index":21,"n_rows":24,"n_cols":10,"rows_kept":24,"cut":false,"hidden":false,"merged":[[0,1,0,4],[2,1,2,4],[4,0,6,9]]}
["COMPANY NAME",{"$f":"'Global Business Solutions'!B27","v":"Test"}]
[]
["FINANCIAL INFORMATION USED",{"$f":"'Global Business Solutions'!B29","v":"2017-02-28"}]
[]
["Enterprise Development - Early Payments Schedule"]
[]
[]
[]
["Beneficiaries","Invoice Date","Invoice Amount excl VAT","Category Classification","Recognition Amount","EFT Date","Benefit Factor","Amount Recognised","ref","Comments"]
[null,null,null,null,{"$f":"IF(D10=\"A\",(C10*1),0)","v":0},null,{"$f":"IF(B10=0,0,(IF((15-(F10-B10))>15,15,(15-(F10-B10)))))/100","v":0},{"$f":"IF(G10<5%,0,(G10*E10))","v":0},"ED/SD-1"]
[null,null,null,null,0,null,0,0,"ED/SD-2"]
[null,null,null,null,0,null,0,0,"ED/SD-3"]
[null,null,null,null,0,null,0,0,"ED/SD-4"]
[null,null,null,null,0,null,0,0,"ED/SD-5"]
[null,null,null,null,0,null,0,0,"ED/SD-6"]
[null,null,null,null,0,null,0,0,"ED/SD-7"]
[null,null,null,null,0,null,0,0,"ED/SD-8"]
[null,null,null,null,0,null,0,0,"ED/SD-9"]
[null,null,null,null,0,null,0,0,"ED/SD-10"]
[null,null,null,null,0,null,0,0,"ED/SD-11"]
[null,null,null,null,0,null,{"$f":"IF(B21=0,0,(IF((15-(F21-B21))>15,15,(15-(F21-B21)))))/100","v":0},{"$f":"IF(G21<5%,0,(G21*E21))","v":0},"ED/SD-12"]
[null,null,null,null,{"$f":"IF(D22=\"A\",(C22*1),0)","v":0},null,0,0,"ED/SD-13"]
["Please insert Lines above"]
[null,null,null,null,null,null,null,{"$f":"SUM(H10:H23)","v":0}]

{"sheet":"Early Payments - SD","index":22,"n_rows":37,"n_cols":10,"rows_kept":37,"cut":false,"hidden":false,"merged":[[0,1,0,4],[2,1,2,4],[4,0,6,9]]}
["COMPANY NAME",{"$f":"'Global Business Solutions'!B27","v":"Test"}]
[]
["FINANCIAL INFORMATION USED",{"$f":"'Global Business Solutions'!B29","v":"2017-02-28"}]
[]
["Supplier Development - Early Payments Schedule"]
[]
[]
[]
["Beneficiaries","Invoice Date","Invoice Amount excl VAT","Category Classification","Recognition Amount","EFT Date","Benefit Factor","Amount Recognised","ref","Comments"]
[null,null,null,null,{"$f":"IF(D10=\"A\",(C10*1),0)","v":0},null,{"$f":"IF(B10=0,0,(IF((15-(F10-B10))>15,15,(15-(F10-B10)))))/100","v":0},{"$f":"IF(G10<5%,0,(G10*E10))","v":0},"ED/SD-1"]
[null,null,null,null,{"$f":"IF(D11=\"A\",(C11*1),0)","v":0},null,{"$f":"IF(B11=0,0,(IF((15-(F11-B11))>15,15,(15-(F11-B11)))))/100","v":0},{"$f":"IF(G11<5%,0,(G11*E11))","v":0},"ED/SD-2"]
[null,null,null,null,0,null,0,0,"ED/SD-3"]
[null,null,null,null,0,null,0,0,"ED/SD-4"]
[null,null,null,null,0,null,0,0,"ED/SD-5"]
[null,null,null,null,0,null,0,0,"ED/SD-6"]
[null,null,null,null,0,null,0,0,"ED/SD-7"]
[null,null,null,null,0,null,0,0,"ED/SD-8"]
[null,null,null,null,0,null,0,0,"ED/SD-9"]
[null,null,null,null,0,null,0,0,"ED/SD-10"]
[null,null,null,null,0,null,0,0,"ED/SD-11"]
[null,null,null,null,0,null,0,0,"ED/SD-12"]
[null,null,null,null,0,null,0,0,"ED/SD-13"]
[null,null,null,null,0,null,0,0,"ED/SD-14"]
[null,null,null,null,0,null,0,0,"ED/SD-15"]
[null,null,null,null,0,null,0,0,"ED/SD-16"]
[null,null,null,null,0,null,0,0,"ED/SD-17"]
[null,null,null,null,0,null,0,0,"ED/SD-18"]
[null,null,null,null,0,null,0,0,"ED/SD-19"]
[null,null,null,null,0,null,0,0,"ED/SD-20"]
[null,null,null,null,0,null,0,0,"ED/SD-21"]
["Please insert lines above"]
[null,null,null,null,null,null,null,{"$f":"SUM(H10:H31)","v":0}]
[]
[]
[]
["A"]
["B"]

{"sheet":"Socio Economic Development","index":23,"n_rows":45,"n_cols":9,"rows_kept":45,"cut":false,"hidden":false,"merged":[[0,1,0,4],[2,1,2,4],[4,0,6,8]]}
["COMPANY NAME",{"$f":"'Global Business Solutions'!B27","v":"Test"}]
[]
["FINANCIAL INFORMATION USED",{"$f":"'Global Business Solutions'!B29","v":"2017-02-28"}]
[]
["Socio Economic Development "]
[]
[]
[]
["Beneficiaries","Contribution Type","Monetary or Non Monetary","Contribution Factor per Matrix","% Black Beneficiaries","amount claimed","amount recognised","ref","Comments"]
[null,"Grant",null,{"$f":"VLOOKUP(B10,$D$38:$E$45,2,FALSE)","v":1},null,null,{"$f":"IF(E10<75%,(F10*E10*D10),F10*D10)","v":0},"SED-1"]
[null,"Grant",null,{"$f":"VLOOKUP(B11,$D$38:$E$45,2,FALSE)","v":1},null,null,{"$f":"IF(E11<75%,(F11*E11*D11),F11*D11)","v":0},"SED-2"]
[null,"Grant",null,1,null,null,0,"SED-3"]
[null,"Grant",null,1,null,null,0,"SED-4"]
[null,"Grant",null,1,null,null,0,"SED-5"]
[null,"Grant",null,1,null,null,0,"SED-6"]
[null,"Costs",null,{"$f":"VLOOKUP(B16,$D$38:$E$45,2,FALSE)","v":0.8},null,null,0,"SED-7"]
[null,"Grant",null,1,null,null,0,"SED-8"]
[null,"Grant",null,1,null,null,0,"SED-9"]
[null,"Grant",null,1,null,null,0,"SED-10"]
[null,"Grant",null,1,null,null,0,"SED-11"]
[null,"Grant",null,1,null,null,0,"SED-12"]
[null,"Grant",null,1,null,null,0,"SED-13"]
[null,"Grant",null,1,null,null,0,"SED-14"]
[null,"Grant",null,1,null,null,0,"SED-15"]
[null,"Grant",null,1,null,null,0,"SED-16"]
[null,"Grant",null,1,null,null,0,"SED-17"]
[null,"Grant",null,1,null,null,0,"SED-18"]
["Insert lines above","Grant",null,1,null,null,{"$f":"IF(E28<75%,(F28*E28*D28),F28*D28)","v":0}]
[null,null,null,null,null,null,{"$f":"SUM(G10:G28)","v":0}]
[]
["Net Profit after tax ",{"$f":"+'ED & SD'!C54","v":0}]
["% spend of NPAT",{"$f":"IF(B31>0,G29/B31,0)","v":0}]
["Target",{"$f":"+Scorecard!E51","v":0.01}]
["Weight",{"$f":"+Scorecard!F51","v":5}]
["Score",{"$f":"IF((B32/B33*B34)>B34,B34,(B32/B33*B34))","v":0}]
["Spend Required",{"$f":"+B31*B33","v":0}]
[]
[null,"Qualifying Contribution type","Contribution Amount","Contribution Amount","Benefit Factor"]
["Grant and Related Contributions","Grant Contribution","Full Grant Amount","Grant",1]
[null,"Direct Cost incurred in supporting socio-economic development, sector specific initiatives or Qualifying Socio-Economic Development Contributions","Verifiable Cost (including both monetary and non-monetary)","Verifiable cost",1]
[null,"Discounts in addition to normal business practices supporting socio-economic development, sector specific initiatives or Qualifying Socio-Economic Development Contributions","Discount Amount (in addition to normal business discount)","Discount",1]
[null,"Overhead Costs incurred in supporting socio-economic development, sector specific initiatives orQualifying Socio-Economic Development Contributions","Verifiable Costs (including both monetary and non-monetary)","Costs",0.8]
["Contributions made in the form of human resource capacity","Professional services rendered at no cost supporting socio-economic development, sector specific initiatives or Qualifying Socio-Economic Development Contributions","Commercial hourly rate of professional","Commercial Rate",0.8]
[null,"Professional services rendered at a discount supporting socio-economic development, sector specific initiatives or Qualifying Socio-Economic Development Contributions","Value of discount based on commercial hourly rate of professional","Prof Discount",0.8]
[null,"Time of employees of Measured Entity productively deployed in assisting beneficiaries and supporting socio-economic development, sector specific initiatives or Qualifying Socio-Economic Development Contributions","Monthly salary divided by 160","Salary",0.8]