{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Evaluation","Technical Evaluation","Variable Pricing Schedule","Guidelines on how to score"],"not_rendered":{"defined_names":22,"comments":2},"read":"whole","date_system":"1900"}

{"sheet":"Evaluation","index":0,"n_rows":13,"n_cols":5,"rows_kept":13}
["Part A - Mandatory Requirements"]
[1,"Completion of the Prescribed Standard Bidding Documentation"]
[2,"Proof of registration on the Central Supplier Database (CSD)"]
[3,"Proof of valid letter of good standing with the Legal Practice Council "]
[4,"Proof of valid Fidelity Fund Certificate "]
[5,"Proof of valid Admission Certificate to the relevant Law Society and Current Membership "]
[6,"Letter from Auditors that the Firm is in Good financial Standing "]
[]
[null,null,"Weight","% Score","Weighted Score"]
["Part B - Technical Evaluation"]
[1,"Experience and Expertise ",{"v":0.5,"d":"50.00%"},{"$f":"'Technical Evaluation'!K8","v":{"v":0.6666666666666666,"d":"66.67%"}},{"$f":"D11*C11","v":{"v":0.3333333333333333,"d":"33%"}}]
[2,"Capacity and Existence of the Firm ",{"v":0.5,"d":"50.00%"},{"$f":"'Technical Evaluation'!K14","v":{"v":0.5,"d":"50.00%"}},{"$f":"D12*C12","v":{"v":0.25,"d":"25%"}}]
[null,"Final Score",{"$f":"SUM(C1:C12)","v":{"v":1,"d":"100%"}},null,{"$f":"SUM(E1:E12)","v":{"v":0.5833333333333333,"d":"58%"}}]

{"sheet":"Technical Evaluation","index":1,"n_rows":14,"n_cols":11,"rows_kept":14}
[null,"Category","Proof required","Proof","Please add additional info if required","Point allocation","Max Points","Points","Weight","Max Score","Score"]
[null,"Experience and Expertise"]
[null,"Understanding of the regulatory framework applicable to the related area(s) of specialization and experience of providing legal services to organs of state (the Firm"]
[1,"Experience and understanding of Legislative and Regulatory requirements","Bidder must demonstrate extensive experience and understanding of the legislative and regulatory framework applicable to the related areas of expertise indicated in the scope of services. . This the bidder must do by submitting a full company profile and certificates to indicate the firms incorporation date and various affiliates profiles (e.g Senior or Junior advocates,  other resources that the firm may use in executing the firms expertise).",null,null,"15 years of experience to be outlined- 30 points\n5 or more years of experience to be outlined- 20 points \nLess than 5 years of experience to be outlined- 10 points \n",30,20,5,{"$f":"I4*G4","v":150},{"$f":"I4*H4","v":100}]
[null,"Experience of Key Staff Lead Attorney (Team Leader) in the related area(s) of specialization (CV/Profiles to be attached)","Bidders must supply details of specific relevant assignments undertaken within organs of state, and preferably within a SETA environment with contact details.",null,null,"Less than 5 years’ experience i.e., total duration of professional activity- 10 points \nMore than 5 years but less than 15 years’ experience i.e., total duration of professional activity- 20 points \nMore than 5 years but more than 15 years’ experience i.e., total duration of professional activity- 30 points ",30,20,5,{"$f":"I5*G5","v":150},{"$f":"I5*H5","v":100}]
[null,"Experience in comparative projects ","Bidders must supply details of specific relevant assignments undertaken within organs of state, and preferably within a SETA environment with contact details.",null,null,"Two reference letters- 10 points  \nFour reference letters- 20 points \nSix reference letters- 30 points  ",30,20,5,{"$f":"I6*G6","v":150},{"$f":"I6*H6","v":100}]
[null,null,"Sub Totals",{"$nulls":3},{"$f":"SUM(G4:G6)","v":90},{"$f":"SUM(H4:H6)","v":60},{"$f":"SUM(I4:I6)","v":15},{"$f":"SUM(J4:J6)","v":450},{"$f":"SUM(K4:K6)","v":300}]
[null,null,"% Score",{"$nulls":7},{"$f":"K7/J7","v":{"v":0.6666666666666666,"d":"66.67%"}}]
[]
[null,"Capacity and Existence of the Firm"]
[null,"Understanding of the regulatory framework applicable to the related area(s) of specialization and experience of providing legal services to organs of state (the Firm"]
[1,"Law firms reach or ability to practice Nationally ","Bidder must indicate footprint of presence Nationally or through its preferred corrospondant attorneys in various areas of the country",null,null,"Footprint in 2-4 provinces- 3 points \nFootprint in 4-6 provinces- 5 points\nFootprint in 6-9 provinces-10 points ",10,5,5,{"$f":"I12*G12","v":50},{"$f":"I12*H12","v":25}]
[null,null,"Sub Totals",{"$nulls":3},{"$f":"SUM(G12)","v":10},{"$f":"SUM(H12)","v":5},{"$f":"SUM(I12)","v":5},{"$f":"SUM(J12)","v":50},{"$f":"SUM(K12)","v":25}]
[null,null,"% Score",{"$nulls":7},{"$f":"K13/J13","v":{"v":0.5,"d":"50.00%"}}]

{"sheet":"Variable Pricing Schedule","index":2,"n_rows":9,"n_cols":4,"rows_kept":9}
["Position","Rate per hour Year 1","Rate per hour Year 2","Rate per hour Year 3"]
["Partner"]
["Director"]
["Senior Associate"]
["Junior Associate"]
["Candidate Attorney"]
[]
["Note :"]
["Disbursements will be billed separately "]

{"sheet":"Guidelines on how to score","index":3,"n_rows":32,"n_cols":3,"rows_kept":32}
[]
[null,"This document provides the Tender Evaluator and/or Bid Evaluation Committee guidelines on how to evaluate a bidder according to the Evaluation Criteria and how to use the evaluation form(s)."]
[null,"The evaluation of the BID aims to score a bidder according to specific requirements as set out in the TOR and this annexure."]
[null,"There are various spreadsheets that provides the evaluator with the requirements to score, the score per requirements"]
[]
[null,"As can be seen the workbook is split into 3 areas that is used to provide a final score for each bidder."]
[null,"General"]
[null,"The Evaluation spreadsheet is a summary of the scores based on the technical evaluation."]
[null,"The score from the technical evaluation is automatiacally captured for each of the Technical Evaluation Criteria."]
[null,"A weighting for each of the categories is assigned prior to evaluation. The weighting allocated is dependent on the importance (or weight) of the a specific criteria and must total to 100%"]
[null,"A final weighted score is automatically calculated from the weighting factor and score for the specific criteria."]
[null,"The scores are totalled and will give a score out of 100%"]
[]
[null,"Technical Evaluation"]
[null,"The TE form consists of the following items. Some of the items are completed by the bidder from where the Bid Evaluation Committee member will evalute the information provided and score accordingly."]
[null,"Category","The category provides the bidder with the requirements/specifications that will be evaluated against."]
[null,"Proof required","This item provides the bidder and evaluator with information of what proof the bidder must provide."]
[null,"Proof","The bidder must provide a reference in the proposal where the proof can be verified. This is required in order to assist the evaluator to confirm "]
[null,"Please add additional info if required","This item is to provide a place where a bidder can offer extra information per requirement"]
[null,"Point allocation","This item indicates how points will be allocated for scoring purposes."]
[null,"Points","The evaluator, after reviewing the proof, will score the requirement based on the Points allocation and proof to rate the bidder's response."]
[null,"Weight","The weight that has been allocated to a specific requirement at the time the bid is published. 5 is of a higher importance than 1."]
[null,"Score","A score per requirement will be calculated based on weigth and Points allocated by the evaluator."]
[]
[null,"The score for each requirement per category is totalled from where a percentage is calculated for each category of requirements. "]
[null,"This % score is transferred to the evaluation spreadsheet"]
[]
[null,"Pricing Schedules"]
[null,"The pricing schedule is not evaluated but it is used to assist the bidder in providing pricing for the bid in a consistent manner to ensure apples are compared with apples."]
[]
[null,"Areas in light green is completed by the bidder"]
[null,"Areas in light blue is completed by the evaluator"]