{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Scoring Card"],"read":"whole","date_system":"1900"}

{"sheet":"Scoring Card","index":0,"n_rows":54,"n_cols":7,"rows_kept":54,"merged":[[0,0,0,6],[1,0,1,6],[4,0,8,0],[4,1,8,1],[9,0,13,0],[9,1,13,1],[14,0,17,0],[14,1,17,1],[18,0,22,0],[18,1,22,1],[23,0,26,0],[23,1,26,1],[27,0,31,0],[27,1,31,1],[32,0,34,0],[32,1,34,1],[35,0,36,0],[35,1,36,1],[37,0,38,0],[37,1,38,1],[39,0,43,0],[39,1,43,1],[44,0,45,0],[44,1,45,1],[47,0,47,4],[47,5,47,6],[48,0,48,4],[48,5,48,6],[51,1,51,6],[52,1,52,6],[53,1,53,6]]}
["CATERING SERVICES TENDER — TECHNICAL FUNCTIONALITY SCORING CARD"]
["Functionality Evaluation  |  Total Weighting = 100%"]
[]
["No.","Evaluation Criteria","Scoring Band Description","Max Weight","Score Input\n(1 = Selected)","Result","Validation"]
[1,"1. Catering Contract Experience — main contractor serving more than 500 meals per day, for at least the last 3 years prior to the tender submission deadline (Attach Orders / Contracts / Reference letters / Completion Certificates, all with verifiable references)","1 000+ meals per day",{"v":0.1,"d":"10.0%"},0,{"$f":"IF(E5=1,D5,0)","v":{"v":0,"d":"0.0%"}}]
[null,null,"800 to 999 meals per day",{"v":0.07,"d":"7.0%"},0,{"$f":"IF(E6=1,D6,0)","v":{"v":0,"d":"0.0%"}}]
[null,null,"500 to 799 meals per day",{"v":0.05,"d":"5.0%"},0,{"$f":"IF(E7=1,D7,0)","v":{"v":0,"d":"0.0%"}}]
[null,null,"0 to 499 meals per day",{"v":0.02,"d":"2.0%"},0,{"$f":"IF(E8=1,D8,0)","v":{"v":0,"d":"0.0%"}}]
[null,null,"SUBTOTAL",{"$f":"MAX(D5:D8)","v":{"v":0.1,"d":"10.0%"}},null,{"$f":"SUM(F5:F8)","v":{"v":0,"d":"0.0%"}},{"$f":"IF(COUNTIF(E5:E8,1)>1,\"Select ONE band only\",\"OK\")","v":"OK"}]
[2,"2. Integrated HR Plan with Organogram — indicating the tenderer's proposed structure for the execution of the Catering Services","Plan and Organogram showing Management, Departmental Heads and Staff",{"v":0.1,"d":"10.0%"},0,{"$f":"IF(E10=1,D10,0)","v":{"v":0,"d":"0.0%"}}]
[null,null,"Plan only",{"v":0.05,"d":"5.0%"},0,{"$f":"IF(E11=1,D11,0)","v":{"v":0,"d":"0.0%"}}]
[null,null,"Organogram only",{"v":0.03,"d":"3.0%"},0,{"$f":"IF(E12=1,D12,0)","v":{"v":0,"d":"0.0%"}}]
[null,null,"No plan, no organogram",{"v":0,"d":"0.0%"},0,{"$f":"IF(E13=1,D13,0)","v":{"v":0,"d":"0.0%"}}]
[null,null,"SUBTOTAL",{"$f":"MAX(D10:D13)","v":{"v":0.1,"d":"10.0%"}},null,{"$f":"SUM(F10:F13)","v":{"v":0,"d":"0.0%"}},{"$f":"IF(COUNTIF(E10:E13,1)>1,\"Select ONE band only\",\"OK\")","v":"OK"}]
[3,"3. Project / Catering Manager — CV with traceable references; National Diploma / Degree in Hospitality, Food Services or Food and Beverage Management (certified copies)","5 or more years relevant experience (CV + qualifications)",{"v":0.1,"d":"10.0%"},0,{"$f":"IF(E15=1,D15,0)","v":{"v":0,"d":"0.0%"}}]
[null,null,"3 to 4 years relevant experience",{"v":0.05,"d":"5.0%"},0,{"$f":"IF(E16=1,D16,0)","v":{"v":0,"d":"0.0%"}}]
[null,null,"0 to 2 years relevant experience",{"v":0,"d":"0.0%"},0,{"$f":"IF(E17=1,D17,0)","v":{"v":0,"d":"0.0%"}}]
[null,null,"SUBTOTAL",{"$f":"MAX(D15:D17)","v":{"v":0.1,"d":"10.0%"}},null,{"$f":"SUM(F15:F17)","v":{"v":0,"d":"0.0%"}},{"$f":"IF(COUNTIF(E15:E17,1)>1,\"Select ONE band only\",\"OK\")","v":"OK"}]
[4,"4. Head Chef — CV with traceable references; Culinary Arts Diploma or any Catering related Diploma; Registration with South African Chefs Association","5 or more years (CV + qualifications + registration)",{"v":0.1,"d":"10.0%"},0,{"$f":"IF(E19=1,D19,0)","v":{"v":0,"d":"0.0%"}}]
[null,null,"3 to 4 years (CV + qualifications + registration)",{"v":0.08,"d":"8.0%"},0,{"$f":"IF(E20=1,D20,0)","v":{"v":0,"d":"0.0%"}}]
[null,null,"1 to 2 years (CV + qualifications + registration)",{"v":0.05,"d":"5.0%"},0,{"$f":"IF(E21=1,D21,0)","v":{"v":0,"d":"0.0%"}}]
[null,null,"No professional registration",{"v":0,"d":"0.0%"},0,{"$f":"IF(E22=1,D22,0)","v":{"v":0,"d":"0.0%"}}]
[null,null,"SUBTOTAL",{"$f":"MAX(D19:D22)","v":{"v":0.1,"d":"10.0%"}},null,{"$f":"SUM(F19:F22)","v":{"v":0,"d":"0.0%"}},{"$f":"IF(COUNTIF(E19:E22,1)>1,\"Select ONE band only\",\"OK\")","v":"OK"}]
[5,"5. Production Manager — CV with traceable references; National Diploma / Degree in Hospitality, Food Services or Food and Beverage Management","5 or more years relevant experience (CV + qualifications)",{"v":0.1,"d":"10.0%"},0,{"$f":"IF(E24=1,D24,0)","v":{"v":0,"d":"0.0%"}}]
[null,null,"3 to 4 years relevant experience",{"v":0.05,"d":"5.0%"},0,{"$f":"IF(E25=1,D25,0)","v":{"v":0,"d":"0.0%"}}]
[null,null,"0 to 2 years relevant experience",{"v":0,"d":"0.0%"},0,{"$f":"IF(E26=1,D26,0)","v":{"v":0,"d":"0.0%"}}]
[null,null,"SUBTOTAL",{"$f":"MAX(D24:D26)","v":{"v":0.1,"d":"10.0%"}},null,{"$f":"SUM(F24:F26)","v":{"v":0,"d":"0.0%"}},{"$f":"IF(COUNTIF(E24:E26,1)>1,\"Select ONE band only\",\"OK\")","v":"OK"}]
[6,"6. Nutritionist / Dietitian — CV with traceable references; BSc in Nutrition / Dietetics; HPCSA registered","5 or more years (CV + qualifications + registration)",{"v":0.1,"d":"10.0%"},0,{"$f":"IF(E28=1,D28,0)","v":{"v":0,"d":"0.0%"}}]
[null,null,"3 to 4 years (CV + qualifications + registration)",{"v":0.08,"d":"8.0%"},0,{"$f":"IF(E29=1,D29,0)","v":{"v":0,"d":"0.0%"}}]
[null,null,"1 to 2 years (CV + qualifications + registration)",{"v":0.05,"d":"5.0%"},0,{"$f":"IF(E30=1,D30,0)","v":{"v":0,"d":"0.0%"}}]
[null,null,"No professional registration",{"v":0,"d":"0.0%"},0,{"$f":"IF(E31=1,D31,0)","v":{"v":0,"d":"0.0%"}}]
[null,null,"SUBTOTAL",{"$f":"MAX(D28:D31)","v":{"v":0.1,"d":"10.0%"}},null,{"$f":"SUM(F28:F31)","v":{"v":0,"d":"0.0%"}},{"$f":"IF(COUNTIF(E28:E31,1)>1,\"Select ONE band only\",\"OK\")","v":"OK"}]
[7,"7. Mobilisation Plan — taking over and serving meals from Day 1","Detailed Mobilisation Plan",{"v":0.1,"d":"10.0%"},0,{"$f":"IF(E33=1,D33,0)","v":{"v":0,"d":"0.0%"}}]
[null,null,"Not Detailed Mobilisation Plan",{"v":0.05,"d":"5.0%"},0,{"$f":"IF(E34=1,D34,0)","v":{"v":0,"d":"0.0%"}}]
[null,null,"SUBTOTAL",{"$f":"MAX(D33:D34)","v":{"v":0.1,"d":"10.0%"}},null,{"$f":"SUM(F33:F34)","v":{"v":0,"d":"0.0%"}},{"$f":"IF(COUNTIF(E33:E34,1)>1,\"Select ONE band only\",\"OK\")","v":"OK"}]
[8,"8. Operations Continuity & Emergency Planning Processes — detailing contingency in case of unforeseen operational disruptions","Operations Continuity & Emergency Plan submitted",{"v":0.05,"d":"5.0%"},0,{"$f":"IF(E36=1,D36,0)","v":{"v":0,"d":"0.0%"}}]
[null,null,"SUBTOTAL",{"$f":"SUM(D36:D36)","v":{"v":0.05,"d":"5.0%"}},null,{"$f":"SUM(F36:F36)","v":{"v":0,"d":"0.0%"}},{"$f":"IF(COUNTIF(E36:E36,1)>1,\"Check entries\",\"OK\")","v":"OK"}]
[9,"9. Maintenance Plan — full maintenance plan of all equipment and furniture","Full Maintenance Plan submitted",{"v":0.1,"d":"10.0%"},0,{"$f":"IF(E38=1,D38,0)","v":{"v":0,"d":"0.0%"}}]
[null,null,"SUBTOTAL",{"$f":"SUM(D38:D38)","v":{"v":0.1,"d":"10.0%"}},null,{"$f":"SUM(F38:F38)","v":{"v":0,"d":"0.0%"}},{"$f":"IF(COUNTIF(E38:E38,1)>1,\"Check entries\",\"OK\")","v":"OK"}]
[10,"10. Cooking, Storage, Production & Distribution Processes (four independent components — select all that apply)","Cooking Process",{"v":0.025,"d":"2.5%"},0,{"$f":"IF(E40=1,D40,0)","v":{"v":0,"d":"0.0%"}}]
[null,null,"Storage Process",{"v":0.025,"d":"2.5%"},0,{"$f":"IF(E41=1,D41,0)","v":{"v":0,"d":"0.0%"}}]
[null,null,"Production Process",{"v":0.025,"d":"2.5%"},0,{"$f":"IF(E42=1,D42,0)","v":{"v":0,"d":"0.0%"}}]
[null,null,"Distribution Process",{"v":0.025,"d":"2.5%"},0,{"$f":"IF(E43=1,D43,0)","v":{"v":0,"d":"0.0%"}}]
[null,null,"SUBTOTAL",{"$f":"SUM(D40:D43)","v":{"v":0.1,"d":"10.0%"}},null,{"$f":"SUM(F40:F43)","v":{"v":0,"d":"0.0%"}},{"$f":"IF(COUNTIF(E40:E43,1)>4,\"Check entries\",\"OK\")","v":"OK"}]
[11,"11. Cleaning and Hygiene","Cleaning and Hygiene Plan submitted",{"v":0.05,"d":"5.0%"},0,{"$f":"IF(E45=1,D45,0)","v":{"v":0,"d":"0.0%"}}]
[null,null,"SUBTOTAL",{"$f":"SUM(D45:D45)","v":{"v":0.05,"d":"5.0%"}},null,{"$f":"SUM(F45:F45)","v":{"v":0,"d":"0.0%"}},{"$f":"IF(COUNTIF(E45:E45,1)>1,\"Check entries\",\"OK\")","v":"OK"}]
[]
["MAXIMUM POSSIBLE SCORE (framework check — confirms the scoring bands sum to 100%)",{"$nulls":4},{"$f":"SUM(D9,D14,D18,D23,D27,D32,D35,D37,D39,D44,D46)","v":{"v":1,"d":"100.0%"}}]
["TOTAL SCORE ACHIEVED",{"$nulls":4},{"$f":"SUM(F9,F14,F18,F23,F27,F32,F35,F37,F39,F44,F46)","v":{"v":0,"d":"0.0%"}}]
[]
["Legend:"]
["Yellow cells","Editable — enter 1 to select a scoring band, 0 / blank otherwise"]
["Grey rows","Subtotal per criterion (auto-calculated)"]
["\"Select ONE band only\"","Warning shown if more than one band is selected within a criterion"]