{"text_format":"3","workbook":"xlsx","n_sheets":11,"sheets":["READ ME FIRST","5.1.1 COVER SHEET","5.1.1.1 PREAMBLE","5.1.2 SUMMARY","5.1.3 BOQ","5.1.3.1 MEAL'S DETAILS","5.1.3.2 SSA BREAKDOWN","5.1.4 CPA FORMULA","5.1.6 MENU SPEC","5.1.7 DAY MENU (16 DAY MENU)","5.1.8 STAFF COMPLIMENT ORGANO"],"not_rendered":{"images":3,"external_links":1,"comments":3},"read":"whole","date_system":"1900"}

{"sheet":"READ ME FIRST","index":0,"n_rows":29,"n_cols":3,"rows_kept":29,"merged":[[10,1,10,2],[12,1,12,2]]}
["Project:",null,"KUSILE POWER STATION PROJECT"]
["Enquiry No."]
["Package Name:",null,"CATERING SERVICES AT KUSILE SITE AND KENDAL VILLAGE"]
["Tenderer's Name:",null,{"$f":"'[1]5.1.1 Tender Cover Sheet'!C24","v":0}]
[]
[]
["READ ME"]
[]
[null,"Read these notes BEFORE you commence input or make any changes to this workbook."]
[]
[null,"The Tenderer must provide a clear indication on the Cover Sheet as to whether the offer is \"main\" or \"alternative\" (and if there are several alternatives, to number them). There must be a separate Excel file for each offer if applicable"]
[]
[null,"NOTE:  ALL CALCULATIONS ARE THE RESPONSIBILITY OF THE TENDERER, AND MUST BE CHECKED THOROUGHLY.  ANY DISCREPANCY FOUND IN THE CALCULATIONS IN THIS WORKBOOK MUST BE BROUGHT TO THE ATTENTION OF ESKOM, THROUGH THE DESIGNATED BUYER!"]
[]
[]
[1,"This workbook contains the following sheets:"]
[null,"Read Me","This sheet provides an overview to the Tenderer of the content and role of the sheets making up the Price Schedules.  It will not form part of the tender or contract."]
[null,"5.1.1 Tender Cover Sheet","This is the cover sheet for Section 5.1 and provides the total tender price.  It is also the source of the package name, tenderer name etc for the other sheets."]
[null,"5.1.1.1  Preamble","This sheet provides general guidelines for this section."]
[null,"5.1.2 Summary","This is where the total amounts of all the trades are shown"]
[null,"5.1.3 BOQ","This is the main data entry sheet for the Tenderer to complete. "]
[null,"5.1.4 CPA Formulae","This is where the tenderer selects the CPA Formulae"]
[]
[]
[]
[2,"Conventions used in this workbook"]
[null,"The following conventions have been used in this workbook to facilitate its accurate use:"]
[null,"Red","This GREEN shading is used for cells where DATA ENTRY is required from the Tenderer.  The Tenderer must complete the information in these GREEN shaded cells."]
[null,null,"PLEASE REFRAIN from tampering with ANY other cells contained in this workbook as it may affect Eskom's standard formulae and lead to data integrity issues."]

{"sheet":"5.1.1 COVER SHEET","index":1,"n_rows":50,"n_cols":4,"rows_kept":50,"merged":[[1,1,1,2],[20,1,21,1],[20,2,21,2]]}
[]
[null,"KUSILE POWER STATION PROJECT"]
{"$rows_empty":12}
[null,"PRICING INFORMATION"]
[]
[null,"TENDER INFORMATION"]
[]
[null,"ENQUIRY No."]
[]
[null,"NAME OF PACKAGE:","CATERING SERVICES AT KUSILE SITE AND KENDAL VILLAGE"]
[]
[]
[null,"TENDERER’S NAME:  "]
[]
[]
[null,"Annexure IT 5.1 Price Schedules "]
[]
[]
[null,"THE PRICE:  IN ZAR",{"$f":"'[1]5.1.2 Summary'!E20","v":{"v":0,"d":"  0  RAND"}}]
[null,"(excluding VAT)"]
[null,"RAND VALUE IN WORDS"]
[]
[]
[]
[]
[null,"DATE :"]
[]
[]
[]
[null,"FULL NAMES OF SIGNATORY:"]
[]
[]
[]
[null,"DESIGNATION OF SIGNATORY:"]
[]
[]
[]
[null,"SIGNATURE :"]
[{"$nulls":3}," "]

{"sheet":"5.1.1.1 PREAMBLE","index":2,"n_rows":10,"n_cols":3,"rows_kept":10,"merged":[[7,1,7,2],[8,1,8,2],[9,1,9,2],[10,1,10,2],[11,1,11,2]]}
["Project:",null,"KUSILE POWER STATION PROJECT"]
["Enquiry No.",null,{"$f":"'[1]5.1.1 Tender Cover Sheet'!C19","v":"MWP1470PS"}]
["Package Name:",null,{"$f":"'[1]5.1.1 Tender Cover Sheet'!C21","v":"CATERING SERVICES AT KUSILE SITE AND KENDAL VILLAGE"}]
["Tenderer's Name:",null,{"$f":"'5.1.1 COVER SHEET'!C24","v":0}]
[]
["5.1.1.1 PREAMBLE TO PRICE SCHEDULE "]
[]
[1,"The Provisional Price Schedule provides the basis of valuation of all the work activities and inputs and information for general contract progress monitoring. "]
[2,"The amount due at each application for payment date is based on activities and/or milestones completed as indicated on the Price Schedule/Bills of Quantities. The Tenderer must provide all necessary information which is required to determine amounts due in respect of each application for payment relative to the activities."]
[3,"The total of the prices must include for all direct and indirect costs, overheads, profits, on costs, risks, liabilities, obligations, etc. relative to the contract."]

{"sheet":"5.1.2 SUMMARY","index":3,"n_rows":20,"n_cols":5,"rows_kept":20,"merged":[[19,1,19,3]]}
[null,"ANNEXURE 01"]
[]
[null,"CATERING SERVICES AT KUSILE SITE AND KENDAL VILLAGE"]
[]
[null,"FINAL SUMMARY"]
[]
[]
[null,"ITEM NO.","DESCRIPTION","UNIT","AMOUNT"]
[]
[null,100,"PRELIMINARY & GENERAL - FIXED","SUM",{"$f":"'5.1.3 BOQ'!H10","v":0}]
[]
[null,200,"PRELIMINARY & GENERAL - TIME RELATED","SUM",{"$f":"'5.1.3 BOQ'!H22","v":0}]
[]
[null,300,"TRANSPORT COST","SUM",{"$f":"'5.1.3 BOQ'!H32","v":0}]
[]
[null,400,"OVERHEAD COST","SUM",{"$f":"'5.1.3 BOQ'!H41","v":0}]
[]
[null,500,"MAIN MEAL","SUM",{"$f":"'5.1.3 BOQ'!H62","v":0}]
[]
[null,"TOTAL AMOUNT",null,null,{"$f":"E10+E12+E14+E16+E18","v":0}]

{"sheet":"5.1.3 BOQ","index":4,"n_rows":81,"n_cols":8,"rows_kept":81,"merged":[[6,5,6,7]]}
[null,"ANNEXURE 02"]
[]
[null,"CATERING SERVICES AT KUSILE SITE AND KENDAL VILLAGE"]
[]
[null,"BILL OF QUANTITIES"]
[]
[{"$nulls":5},"PERIOD MAY 2024 TO NOV' 2025 (19 MONTHS)"]
[null,"ITEM NO.","DESCRIPTION","UNIT","FURTHER EXPLANATION","QTY","RATE","AMOUNT"]
[]
[null,100,"PRELIMINARY & GENERAL ",{"$nulls":4},{"$f":"SUM(H14:H20)","v":0}]
[]
[null,null,"Fixed"]
[]
[null,100.1,"Establishment of facilities ","Sum",null,1,0,{"$f":"F14*G14","v":0}]
[]
[null,100.2,"Kitchen equipment","Sum",null,19,0,{"$f":"F16*G16","v":0}]
[]
[null,100.3,"Kitchen smalls","Sum",null,19,0,0]
[]
[null,100.4,"Canteen Access Control & Reporting: IT related cost","Sum",null,19,0,0]
[]
[null,200,"TIME RELATED",{"$nulls":4},{"$f":"SUM(H26:H30)","v":0}]
[]
[null,null,"Labour cost - Based on SSA requirements"]
[]
[null,200.1,"Staff compliment - Kusile Site","Monthly","Tenderer to provide price breakdown of rates (Tab 5.1.3B Staff Compliment) in line with the organogram",19,0,{"$f":"F26*G26","v":0}]
[]
[null,200.2,"Staff compliment - Kendal Village","Monthly","Tenderer to provide price breakdown of rates (Tab 5.1.3B Staff Compliment) in line with the organogram",19,0,0]
[]
[null,200.3,"SSA Allowance (To be administered in line with the Employer's Policies and Procedures of SSA)","Prov. Sum","Tenderer to refer to the annexure  tab \"5.1.3C\" for pricing",1,{"$f":"'5.1.3.2 SSA BREAKDOWN'!W20","v":0},0]
[]
[null,300,"TRANSPORT COST",{"$nulls":4},{"$f":"SUM(H34:H38)","v":0}]
[]
[null,300.1,"Delivery cost at Kusile site","Sum",null,19,0,{"$f":"F34*G34","v":0}]
[]
[null,300.2,"Staff transport to Kusile Site","Sum",null,19,0,0]
[]
[null,300.3,"Staff transport to Kendal Village","Sum",null,19,0,0]
[]
[]
[null,400,"OVERHEAD COST",{"$nulls":4},{"$f":"SUM(H43:H59)","v":0}]
[]
[null,400.1,"Operation and maintenance (including of maintenance on Backup Generators for 2000 seaters and 500 seaters Canteen)","Sum",null,1,0,{"$f":"F43*G43","v":0}]
[]
[null,400.2,"Management ","Sum",null,19,0,{"$f":"F45*G45","v":0}]
[]
[null,400.3,"Environmental related costs","Sum",null,19,0,0]
[]
[null,400.4,"Health & Safety related costs","Sum",null,19,0,0]
[]
[null,400.5,"Serving & Quality related costs","Sum",null,19,0,0]
[]
[null,400.6,"Training related costs","Sum",null,19,0,0]
[]
[null,400.7,"Medical tests / Induction training","Sum",null,19,0,0]
[]
[null,400.8,"Administration, Connection & Office IT related cost","Sum",null,19,0,0]
[]
[null,400.9,"Cleaning related cost","Sum",null,19,0,0]
[]
[]
[null,500,"MAIN MEAL",{"$nulls":4},{"$f":"SUM(H64:H78)","v":0}]
[]
[null,500.1,"Project Worker (Main Meal)","Sum",null,19,{"$f":"'5.1.3.1 MEAL''S DETAILS'!H9","v":0},{"$f":"F64*G64","v":0}]
[]
[null,500.2,"Kendal Village -Breakfast","Sum",null,19,{"$f":"'5.1.3.1 MEAL''S DETAILS'!H13","v":0},0]
[]
[null,500.3,"Kendal Village - Lunch","Sum",null,19,{"$f":"'5.1.3.1 MEAL''S DETAILS'!H17","v":0},0]
[]
[null,500.4,"Kendal Village - Supper","Sum",null,19,{"$f":"'5.1.3.1 MEAL''S DETAILS'!H21","v":0},0]
[]
[null,500.5,"Emergency breakfast packs - Kendal Village","Sum",null,19,{"$f":"'5.1.3.1 MEAL''S DETAILS'!H25","v":0},0]
[]
[null,500.6,"Office beverage services","Sum",null,19,{"$f":"'5.1.3.1 MEAL''S DETAILS'!H28","v":0},0]
[]
[null,500.7,"Functions ","Sum",null,19,{"$f":"'5.1.3.1 MEAL''S DETAILS'!H67","v":0},0]
[]
[]
[]
[]
[null,"TOTAL AMOUNT",{"$nulls":5},{"$f":"H10+H22+H32+H41+H62","v":0}]

{"sheet":"5.1.3.1 MEAL'S DETAILS","index":5,"n_rows":137,"n_cols":8,"rows_kept":137,"merged":[[132,1,132,2]]}
[null,"ANNEXURE 03"]
[]
[null,"CATERING SERVICES AT KUSILE SITE AND KENDAL VILLAGE"]
[]
[null,"MEALS COST BREAKDOWN"]
[null,"ITEM NO.","DESCRIPTION","FURTHER DESCRIPTION","UNIT","QTY","RATE","AMOUNT"]
[null,500,"MAIN MEAL",{"$nulls":4},{"$f":"H9+H13+H17+H21+H25+H28+H67","v":0}]
[]
[null,"500.1","Project Worker (Main Meal)",{"$nulls":4},{"$f":"SUM(H11)","v":0}]
[]
[null,null,"Project Worker (Main Meal)",null,"No",{"v":87303.7418545727,"d":"87304"},0,{"$f":"F11*G11","v":0}]
[]
[null,"500.2","Kendal Village -Breakfast",{"$nulls":4},{"$f":"SUM(H15:H16)","v":0}]
[]
[null,null,"Kendal Village -Breakfast",null,"No",{"v":4010.5711613827298,"d":"4011"},0,{"$f":"F15*G15","v":0}]
[]
[null,"500.3","Kendal Village - Lunch",{"$nulls":4},{"$f":"SUM(H19:H20)","v":0}]
[]
[null,null,"Kendal Village - Lunch",null,"No",{"v":2188.0840851853627,"d":"2188"},0,{"$f":"F19*G19","v":0}]
[]
[null,"500.4","Kendal Village - Supper",{"$nulls":4},{"$f":"SUM(H23:H24)","v":0}]
[]
[null,null,"Kendal Village - Supper",null,"No",{"v":4262.004647336534,"d":"4262"},0,{"$f":"F23*G23","v":0}]
[]
[null,"500.5","Emergency breakfast packs - Kendal Village",{"$nulls":4},{"$f":"SUM(H26:H27)","v":0}]
[null,null,"Emergency breakfast packs - Kendal Village",null,"No",198,0,{"$f":"F26*G26","v":0}]
[]
[null,"500.6","Office beverage services",{"$nulls":4},{"$f":"SUM(H29:H65)","v":0}]
[null,"500.6.1","Water 20 litre, Dispenser refill (water only)",null,"No",776,0,{"$f":"F29*G29","v":0}]
[]
[null,"500.6.2","20 litre empty dispenser bottles (Budget to administered as a lumpsum only when required by the Employer",null,"No",10,null,{"$f":"F31*G31","v":0}]
[]
[null,"500.6.3","Water Dispenser Equipment ((Budget to administered as a lumpsum only when required by the Employer)",null,"No",3,0,{"$f":"F33*G33","v":0}]
[]
[null,"500.6.4","Water 500 ml, Bottle","A-Grade","No",200,0,{"$f":"F35*G35","v":0}]
[]
[null,"500.6.5","Branded Coffee, single serving sachet","Ricoffee 200","No",16800,0,{"$f":"F37*G37","v":0}]
[]
[null,"500.6.6","Branded Tea, Five Roses, single envelope","Five Roses ","No",80,0,{"$f":"F39*G39","v":0}]
[]
[null,"500.6.7","Five Roses, single bags","Five Roses ","No",8978,0,{"$f":"F41*G41","v":0}]
[]
[null,"500.6.8","Branded Tea, rooibos, single envelope","Rooibos","No",80,0,{"$f":"F43*G43","v":0}]
[]
[null,"500.6.9","Branded Tea, rooibos, single bag","Rooibos","No",7970,0,{"$f":"F45*G45","v":0}]
[]
[null,"500.6.10","Cremora 200's","Cremora 200's","No",29800,0,{"$f":"F47*G47","v":0}]
[]
[null,"500.6.11","Branded Sugar, Brown single sachet","Hullets / Selati","No",34700,0,{"$f":"F49*G49","v":0}]
[]
[null,"500.6.12","Good Quality Fomo Cup 250ml","Foam Cup","No",16630,0,{"$f":"F51*G51","v":0}]
[]
[null,"500.6.13","Tea Spoon, disposable","Teaspoon 500","No",7950,0,{"$f":"F53*G53","v":0}]
[]
[null,"500.6.14","Project Director Office Milk 1 litre long life","A-Grade Quality","No",18,0,{"$f":"F55*G55","v":0}]
[]
[null,"500.6.15","Project Director Office Coffee Machine Rental","Milk based product, premium bean, includes maintenance","No",1,0,{"$f":"F57*G57","v":0}]
[]
[null,"500.6.16","Project Director Office Coffee per cup",null,"No",30,0,{"$f":"F59*G59","v":0}]
[]
[null,"500.6.17","Vending Machine Rental Per Month (4000 cup per month)","Zen counter top, includes maintenance","No",2,0,{"$f":"F61*G61","v":0}]
[]
[null,"500.6.18","Vending Machine Coffee Per Cup",null,"No",4503,0,{"$f":"F63*G63","v":0}]
[]
[null,"500.6.19","Main Meal Cutlery Pack","Cutlery set Knife, Fork, serviette, salt and pepper","No",5375,0,{"$f":"F65*G65","v":0}]
[]
[null,500.7,"Functions ",{"$nulls":4},{"$f":"SUM(H69:H131)","v":0}]
[]
[null,"500.7.1","Meal of the day ",null,"No",100,0,{"$f":"F69*G69","v":0}]
[]
[null,"500.7.2","Special Meal",null,"No",100,0,{"$f":"F71*G71","v":0}]
[]
[null,"500.7.3","Extra Protein",null,"No",50,0,{"$f":"F73*G73","v":0}]
[]
[null,"500.7.4","Eat Sum More Biscuits",null,"No",25,0,{"$f":"F75*G75","v":0}]
[]
[null,"500.7.5","Tennis Biscuits",null,"No",25,0,{"$f":"F77*G77","v":0}]
[]
[null,"500.7.6","100% Assorted Juice","500ml bottles","No",100,0,{"$f":"F79*G79","v":0}]
[]
[null,"500.7.7","100% Assorted Juice","250 ml bottles","No",100,0,{"$f":"F81*G81","v":0}]
[]
[null,"500.7.8","Assorted Cans","Assorted Cans","No",100,0,{"$f":"F83*G83","v":0}]
[]
[null,"500.7.9","Packaging","Packaging","No",200,0,{"$f":"F85*G85","v":0}]
[]
[null,"500.7.10","Fresh Sandwiches ",null,"No",50,0,{"$f":"F87*G87","v":0}]
[]
[null,"500.7.11","Toasted Sandwiches","Bacon &egg, cheese & tomato, chicken mayo, ham & cheese on white and brown bread","No",100,0,{"$f":"F89*G89","v":0}]
[]
[null,"500.7.12","lunch pack",null,null,50,0,{"$f":"F91*G91","v":0}]
[]
[null,"500.7.13","Executive Finger Lunch","A variety of finger foods  of 8 snacks per person consisting of pastries, and meat snacks","No",50,0,{"$f":"F93*G93","v":0}]
[]
[null,"500.7.14","Chocolates","40g nestle chocolate","No",50,0,{"$f":"F95*G95","v":0}]
[]
[null,"500.7.15","Fruit salad and yoghurt","sliced Fruit and yoghurt","No",50,0,{"$f":"F97*G97","v":0}]
[]
[null,"500.7.16","Breakfast","combo of fruit salad and yoghurt with muesli, mini wrap and muffin","No",100,0,{"$f":"F99*G99","v":0}]
[]
[null,"500.7.17","Executive breakfast","English Breakfast","No",50,0,{"$f":"F101*G101","v":0}]
[]
[null,"500.7.18","Breakfast Wrap","1 large tortilla wrap with bacon, egg  cheese & tomato","No",50,0]
[]
[null,"500.7.19","Jumbo Muffin","200g muffin","No",50,0,{"$f":"F105*G105","v":0}]
[]
[null,"500.7.20","Alternative Packaging","this is for individual pakage meals, 3 dividion packaging or Fomo packaging for braai","No",50,0,{"$f":"F107*G107","v":0}]
[]
[null,null,"Braai"]
[null,"500.7.21","Pap and gravy, Wors, Chicken, Salad","180g  chicken  and 120g wors, pap, gravy , salad","No",50,0,{"$f":"F110*G110","v":0}]
[]
[null,null,"Braai"]
[null,"500.7.22","Pap, and gravy, T-Bone, Chicken, Salad","240g t-bone, 180g chicken ,pap ,gravy and salad","No",50,0,{"$f":"F113*G113","v":0}]
[]
[null,null,"Braai"]
[null,"500.7.23","Pap, and gravy, Wors, Chicken, T-Bone, Salad","240g T bone, 180 g chicken , 120 g wors, pap, gravy & salad","No",50,0,{"$f":"F116*G116","v":0}]
[]
[null,"500.7.24","Halaal meal Nando’s","Bought meal from Nandos( 1/2 chicken , chips and roll)","No",20,0,{"$f":"F118*G118","v":0}]
[]
[null,"500.7.25","Kosher","Specially prepared in a strictly kosher kitchen(starch protein and vegetables)","No",10,0,{"$f":"F120*G120","v":0}]
[]
[null,"500.7.26","kosher and Halllal  breakfast ",null,"No",20,0,{"$f":"F122*G122","v":0}]
[]
[null,"500.7.27","kosher and Halllal  Lunch",null,"No",20,0,{"$f":"F124*G124","v":0}]
[]
[null,"500.7.28","Halaal meal","Specially prepared in a strictly halaal kitchen( starch, protein and vegetables)","No",20,0,{"$f":"F126*G126","v":0}]
[]
[null,"500.7.29","Extra Salad",null,"No",20,0,{"$f":"F128*G128","v":0}]
[]
[null,"500.7.30","Filled Croissant",null,"No",50,0,{"$f":"F130*G130","v":0}]
[]
[]
[null,"TOTAL AMOUNT"]
[]
[]
[]
[null,null,"CURRENT CONTRACT DECLARED PROFIT"]

{"sheet":"5.1.3.2 SSA BREAKDOWN","index":6,"n_rows":117,"n_cols":23,"rows_kept":117,"merged":[[13,0,13,21],[20,7,20,22]]}
["ANNEXURE 05"]
[]
["Project:",null,"KUSILE POWER STATION PROJECT"]
["ANNEXURE 04"]
[]
[]
["CONTRACT  NO."]
["Package Name:",null,"CATERING SERVICES AT KUSILE SITE AND KENDAL VILLAGE"]
["Tenderer's Name:"]
[]
["TO BE READ AND PRICED IN CONJUNCTION WITH THE EMPLOYER’S POLICIES AND PROCEDURES"]
["THE PRICES/RATES/QUANTITIES IN THIS PAGE ARE FOR ESTIMATION ONLY"]
[]
["THE FIRST LINE ITEM SERVES AS A GUIDE, ADDITIONAL LINE ITEMS CAN BE ADDED TO CATER FOR RESOURCES FOR EXAMPLE GENERAL WORKERS X5 . PLEASE NOTE THAT ESKOM PROVIDES 15.5 HOURS PER MONTH FOR THE BONUS AND  0,5 HRS TO THE CONTRACTOR'S ACCOUNT. PLEASE REFER TO SSA GUIDELINES FOR FURTHER INFORMATION."]
[]
["PA ATTENDANCE BONUS"]
[]
["SSA CALC."]
["COST",{"$nulls":21},{"$f":"(W117/12)*19","v":0}]
["TOTAL",{"$nulls":21},{"$f":"SUM(W19:W19)","v":0}]
["ATTENDANCE BONUS SHEET",{"$nulls":6},"TENDERER PROPOSAL"]
["Resource No","Employee Company ","Employee","Trade","ID NO","Date On Site",null,"Hourly","May 24","Jun 24","July 24","Aug 24","Sep 24","Oct 24","Nov 24","Dec 24","Jan 25","Feb 25","Mar 25","Apr 25","Acrrued","Bonus","Bonus"]
[null,"No","Names",{"$nulls":4},"Rate",{"$nulls":13},"Hours","Amount"]
[]
[1,null,null,"General Assistant",{"$nulls":3},0,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,null,{"$f":"SUBTOTAL(9,I25:U25)","v":186},{"$f":"H25*V25","v":0}]
[{"$f":"A25+1","v":2},null,null,"General Assistant",{"$nulls":3},0,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,null,186,0]
[{"$f":"A26+1","v":3},null,null,"General Assistant",{"$nulls":3},0,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,null,186,0]
[4,null,null,"General Assistant",{"$nulls":3},0,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,null,186,0]
[5,null,null,"General Assistant",{"$nulls":3},0,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,null,186,0]
[{"$f":"A29+1","v":6},null,null,"General Assistant",{"$nulls":3},0,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,null,186,0]
[{"$f":"A30+1","v":7},null,null,"General Assistant",{"$nulls":3},0,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,null,186,0]
[{"$f":"A31+1","v":8},null,null,"General Assistant",{"$nulls":3},0,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,null,186,0]
[{"$f":"A32+1","v":9},null,null,"General Assistant",{"$nulls":3},0,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,null,186,0]
[10,null,null,"General Assistant",{"$nulls":3},0,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,null,186,0]
[11,null,null,"General Assistant",{"$nulls":3},0,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,null,186,0]
[12,null,null,"General Assistant",{"$nulls":3},0,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,null,{"$f":"SUBTOTAL(9,I36:T36)","v":186},0]
[{"$f":"A36+1","v":13},null,null,"General Assistant",{"$nulls":3},0,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,null,{"$f":"SUBTOTAL(9,I37:T37)","v":186},0]
[{"$f":"A37+1","v":14},null,null,"General Assistant",{"$nulls":3},0,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,null,{"$f":"SUBTOTAL(9,I38:T38)","v":186},0]
[{"$f":"A38+1","v":15},null,null,"General Assistant",{"$nulls":3},0,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,null,186,0]
[16,null,null,"General Assistant",{"$nulls":3},0,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,null,186,0]
[17,null,null,"General Assistant",{"$nulls":3},0,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,null,186,0]
[18,null,null,"General Assistant",{"$nulls":3},0,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,null,186,0]
[19,null,null,"General Assistant",{"$nulls":3},0,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,null,186,0]
[20,null,null,"General Assistant",{"$nulls":3},0,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,null,186,0]
[21,null,null,"General Assistant",{"$nulls":3},0,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,null,186,0]
[22,null,null,"General Assistant",{"$nulls":3},0,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,null,186,0]
[23,null,null,"General Assistant",{"$nulls":3},0,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,null,186,0]
[24,null,null,"General Assistant",{"$nulls":3},0,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,null,186,0]
[25,null,null,"General Assistant",{"$nulls":3},0,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,null,186,0]
[26,null,null,"General Assistant",{"$nulls":3},0,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,null,186,0]
[27,null,null,"General Assistant",{"$nulls":3},0,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,null,186,0]
[28,null,null,"General Assistant",{"$nulls":3},0,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,null,186,0]
[29,null,null,"General Assistant",{"$nulls":3},0,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,null,186,0]
[30,null,null,"General Assistant",{"$nulls":3},0,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,null,186,0]
[31,null,null,"General Assistant",{"$nulls":3},0,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,null,186,0]
[32,null,null,"General Assistant",{"$nulls":3},0,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,null,186,0]
[33,null,null,"General Assistant",{"$nulls":3},0,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,null,186,{"$f":"H57*V57","v":0}]
[34,null,null,"General Assistant",{"$nulls":3},0,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,null,186,0]
[35,null,null,"General Assistant",{"$nulls":3},0,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,null,186,0]
[36,null,null,"General Assistant",{"$nulls":3},0,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,null,186,0]
[37,null,null,"General Assistant",{"$nulls":3},0,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,null,186,0]
[38,null,null,"General Assistant",{"$nulls":3},0,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,null,186,0]
[39,null,null,"General Assistant",{"$nulls":3},0,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,null,186,0]
[40,null,null,"General Assistant",{"$nulls":3},0,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,null,186,0]
[41,null,null,"General Assistant",{"$nulls":3},0,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,null,186,0]
[42,null,null,"General Assistant",{"$nulls":3},0,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,null,186,0]
[43,null,null,"General Assistant",{"$nulls":3},0,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,null,186,0]
[44,null,null,"General Assistant",{"$nulls":3},0,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,null,186,0]
[45,null,null,"General Assistant",{"$nulls":3},0,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,null,186,0]
[46,null,null,"General Assistant",{"$nulls":3},0,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,null,186,0]
[47,null,null,"General Assistant",{"$nulls":3},0,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,null,186,0]
[48,null,null,"General Assistant",{"$nulls":3},0,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,null,186,0]
[49,null,null,"General Assistant",{"$nulls":3},0,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,null,186,0]
[50,null,null,"General Assistant",{"$nulls":3},0,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,null,186,0]
[51,null,null,"General Assistant",{"$nulls":3},0,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,null,186,0]
[52,null,null,"General Assistant",{"$nulls":3},0,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,null,186,0]
[53,null,null,"General Assistant",{"$nulls":3},0,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,null,186,0]
[54,null,null,"General Assistant",{"$nulls":3},0,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,null,186,0]
[55,null,null,"Driver",{"$nulls":3},0,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,null,186,0]
[56,null,null,"Driver",{"$nulls":3},0,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,null,186,0]
[57,null,null,"Driver",{"$nulls":3},0,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,null,186,0]
[58,null,null,"Driver",{"$nulls":3},0,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,null,186,0]
[59,null,null,"Driver",{"$nulls":3},0,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,null,186,0]
[60,null,null,"Driver",{"$nulls":3},0,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,null,186,0]
[61,null,null,"Driver",{"$nulls":3},0,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,null,186,0]
[62,null,null,"Driver",{"$nulls":3},0,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,null,186,0]
[63,null,null,"Driver",{"$nulls":3},0,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,null,186,0]
[64,null,null,"Cashier",{"$nulls":3},0,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,null,186,0]
[65,null,null,"Cashier",{"$nulls":3},0,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,null,186,{"$f":"H89*V89","v":0}]
[66,null,null,"Cashier",{"$nulls":3},0,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,null,186,0]
[67,null,null,"Cashier",{"$nulls":3},0,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,null,186,0]
[68,null,null,"Cashier",{"$nulls":3},0,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,null,186,0]
[69,null,null,"Admin",{"$nulls":3},0,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,null,186,0]
[70,null,null,"Bookkeeper ",{"$nulls":3},0,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,null,186,0]
[71,null,null,"Head Chef ",{"$nulls":3},0,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,null,186,0]
[72,null,null,"Cooks",{"$nulls":3},0,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,null,186,0]
[73,null,null,"Cooks",{"$nulls":3},0,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,null,186,0]
[74,null,null,"Cooks",{"$nulls":3},0,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,null,186,0]
[75,null,null,"Cooks",{"$nulls":3},0,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,null,186,0]
[76,null,null,"IT Teck",{"$nulls":3},0,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,null,186,0]
[77,null,null,"Maintenance ",{"$nulls":3},0,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,null,186,0]
[78,null,null,"Maintenance ",{"$nulls":3},0,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,null,{"$f":"SUBTOTAL(9,I102:T102)","v":186},0]
[{"$f":"A102+1","v":79},null,null,"Maintenance ",{"$nulls":3},0,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,null,186,0]
[80,null,null,"Supervisor ",{"$nulls":3},0,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,null,186,0]
[81,null,null,"Supervisor ",{"$nulls":3},0,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,null,186,0]
[82,null,null,"Supervisor ",{"$nulls":3},0,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,null,186,0]
[83,null,null,"Supervisor ",{"$nulls":3},0,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,null,186,0]
[84,null,null,"Supervisor ",{"$nulls":3},0,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,null,186,0]
[85,null,null,"Supervisor ",{"$nulls":3},0,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,null,186,0]
[86,null,null,"Supervisor ",{"$nulls":3},0,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,null,186,0]
[87,null,null,"Supervisor ",{"$nulls":3},0,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,null,186,0]
[88,null,null,"SHEQ Officers ",{"$nulls":3},0,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,null,186,0]
[89,null,null,"SHEQ Officers ",{"$nulls":3},0,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,null,186,0]
[90,null,null,"SHEQ Officers ",{"$nulls":3},0,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,15.5,null,186,0]
[]
[]
[null,"SUB-TOTAL 1",{"$nulls":20},{"$f":"SUM(W24:W116)","v":0}]

{"sheet":"5.1.4 CPA FORMULA","index":7,"n_rows":103,"n_cols":10,"rows_kept":103,"merged":[[61,1,61,7],[61,8,61,9],[72,1,72,7],[72,8,72,9],[83,1,83,7],[83,8,83,9],[94,1,94,7],[94,8,94,9]]}
["ANNEXURE 05"]
[]
["KUSILE POWER STATION PROJECT"]
["ENQUIRY No.",null,null,{"$f":"'[1]5.1.1 Tender Cover Sheet'!C19","v":"MWP1470PS"}]
["TENDERER NAME:",null,null,{"$f":"'[1]5.1.1 Tender Cover Sheet'!C24","v":0}]
["NAME OF PACKAGE:",null,null,{"$f":"'[1]5.1.1 Tender Cover Sheet'!C21","v":"CATERING SERVICES AT KUSILE SITE AND KENDAL VILLAGE"}]
["PRICE ADJUSTMENT FOR INFLATION"]
["Summary"]
["No","Description"]
["A",0,null,null,"Type in description of formula which is carried through below"]
[]
[]
[]
["GENERAL NOTES :"]
["a.","References to \"indices\" below have the meaning of \"cost indices or reference prices\",  unless otherwise stated."]
["b.","Where historical information is applicable as requested below, internet address references which are accessible to the"]
[null,"general public may be submitted instead, with the specific electronic route and web page reflecting the applicable data."]
["c.","Each formula is related to one unique currency. Mixing of currencies in a specific formula is not acceptable."]
["CPA FORMULA REQUIREMENTS :"]
["i.","Formulae must be linked to independent cost indices or other benchmarks (\"reference prices\") and must be clearly and"]
[null,"completely defined. The source must be a recognised statistical publishing source and must not be in-house indices."]
["ii.","Local Indices: Where local indices other than SEIFSA or StatsSA are specified, the tenderer is to submit 5 years' historical data"]
[null,"for such indices.  Note that the Contractor must ensure that indices are published and recommended by the \"Source\" as"]
[null,"applicable to the work involved. For example SEIFSA has terminated the publication of Table E and is replaced by Table E-A and"]
[null,"or E-EX and the specific sub breakdown of such must be identified. Also SEIFSA recommends utilisation of Table L-2 for road"]
[null,"transport rather than Table L-1.  "]
["iii.","Foreign Price Adjustments: In the case of foreign price adjustments, the Contractor is to submit 5 years' historical data for the"]
[null,"tendered indices.  Where a formula is linked to indices in a country, payment of the amounts for that formula must be in the "]
[null,"currency of the same country.  A formula may not be linked to indices of more than one country."]
["iv.","Commodity Price Linked Payments: The reference price is considered as the base price (index) for purpose of the CPA formula"]
[null,"and is incuded in the applicable tables below and must be in the currency in which the CPA will be payable.  The exchange"]
[null,"rate applied to convert the base price in a foreign currency into that of the currency of the formula must also be indicated in"]
[null,"the tables below if the price is not in the same currency as the applicable formula.. ie exposure to the movement in a"]
[null,"reference price is in the same currency as that of the CPA formula.  The Contractor is to submit 5 years' historical price data"]
[null,"for such commodity, "]
["v.","London Metal Exchange (LME) Prices: For metals traded on the LME, the tonnage will be required before contract award in"]
[null,"order for Eskom to hedge the metal price fluctuations.  This applies also for prices linked to local indices or reference prices. "]
[null,"Though these metals are traded in US$, prices are daily quoted in various other currencies. "]
[null,"The LME price in the currency of the formula must apply and thus not the US$ unless the amount payable in terms of the"]
[null,"formula is US$.  Refer to the \"LME\" Sheet in this file for more detail regarding this aspect.  By indicating any of these metals in"]
[null,"the formulae below, the contractor declares that neither he nor any other body avails or will avail of forward price and/or"]
[null,"currency cover for the metal(s).  "]
["vi.","CPA Base Date: The CPA base date for calculating price movements is the Base Date as defined in the Particular Conditions,"]
[null,"Clause 1.1.3.1. For indices or reference prices published as at certain dates, and where such a date is not the Base Date, the"]
[null,"latest date for which it is published before the Base Date will be considered as the Base Date index or reference price.  In"]
[null,"instances where the figure or value is not as at the Base Date or considered as the Base Date index or reference price as"]
[null,"explained herein, the date, figure or value as well as the reason for the deviation must be clearly separately stated and must"]
[null,"be realistic for purposes of the price adjustment. "]
["vii.","Period for Movement in Indices: The period for which the movement in indices or reference prices is considered, is the period"]
[null,"until the last day of the month prior to the  month in which the work in question was executed or completed (or in which an"]
[null,"event or activity for which the adjustment applies, took place).  For indices or reference prices published as at certain dates,"]
[null,"and where such a date is not the last day of the month prior to the month in which the work was executed or completed (or an"]
[null,"event or activity took place),  then latest date for which the indices or price references are published before the last day of the"]
[null,"month prior to the execution or completion of work (or an event or activity took place) is considered as the last day index"]
[null,"or reference price of the month prior to execution or completion of work (or event or activity). "]
["viii.","Proportions/weighting/coefficients/base reference in CPA Formulae: The fixed portion of each formula, not subject to inflation,"]
[null,"is at least 15% and contractors may submit higher fixed portion percentages.  The indices or other benchmarks and their"]
[null,"proportions in the formula must be realistic and relative to the applicable work. The fixed portion and other proportions must add"]
[null,"up to 100%."]
["ix.","Base Index or Reference Price :   The base index or reference price must be inserted in the appropriate column"]
[]
["Formula A","Consumer Price Inflation",{"$nulls":6},"Exchange rate for converting base reference price (e.g. US$ LME price) to the currency of this formula"]
["Index Ref.","Proportions / weightings for each index (refer note 1)","Description / scope of index (e.g. Labour)","Full title/definition of index as per publisher","Source/publisher of index (e.g. SEIFSA, Stats SA, LME)","Base Month for CPA if not Base Date as defined (refer note 4)","Base Date Index (refer note 4)","Foreign CPA formula currency code","Base reference price currency code ","Exchange rate (currency 1,00 = x)"]
["A1",{"$nulls":8},{"$f":"IF(I64<>\"\",VLOOKUP(I64,#REF!,2,FALSE),\"\")","v":""}]
["A2",{"$nulls":8},{"$f":"IF(I65<>\"\",VLOOKUP(I65,#REF!,2,FALSE),\"\")","v":""}]
["A3",{"$nulls":8},{"$f":"IF(I66<>\"\",VLOOKUP(I66,#REF!,2,FALSE),\"\")","v":""}]
["A4",{"$nulls":8},{"$f":"IF(I67<>\"\",VLOOKUP(I67,#REF!,2,FALSE),\"\")","v":""}]
["A5",{"$nulls":8},{"$f":"IF(I68<>\"\",VLOOKUP(I68,#REF!,2,FALSE),\"\")","v":""}]
["A6",{"v":0.15,"d":"0.150"},"Fixed 15% minimum not subject to CPA (0.150)"]
[null,{"$f":"SUM(B64:B69)","v":{"v":0.15,"d":"0.150"}},"Total"]
[]
[]
["Formula B","Food Price Inflation",{"$nulls":6},"Exchange rate for converting base reference price (e.g. US$ LME price) to the currency of this formula"]
["Index Ref.","Proportions / weightings for each index (refer note 1)","Description / scope of index (e.g. Labour)","Full title/definition of index as per publisher","Source/publisher of index (e.g. SEIFSA, Stats SA, LME)","Base Month for CPA if not Base Date as defined (refer note 4)","Base Date Index (refer note 4)","Foreign CPA formula currency code ","Base reference price currency code ","Exchange rate (currency 1,00 = x)"]
["B1"]
["B2"]
["B3"]
["B4",{"$nulls":8},{"$f":"IF(I78<>\"\",VLOOKUP(I78,#REF!,2,FALSE),\"\")","v":""}]
["B5",{"$nulls":8},{"$f":"IF(I79<>\"\",VLOOKUP(I79,#REF!,2,FALSE),\"\")","v":""}]
["B6",{"v":0.15,"d":"0.150"},"Fixed 15% minimum not subject to CPA (0.150)"]
[null,{"$f":"SUM(B75:B80)","v":{"v":0.15,"d":"0.150"}},"Total"]
[]
[]
["FORMULA C","Wage Increases, Primarily, by the Relevant and Local Bargaining Counsel, if agreement not available increase based on National Minimum Wage increase and adjusted to Primary determination when it becomes available.  ",{"$nulls":6},"Exchange rate for converting base reference price (e.g. US$ LME price) to the currency of this formula"]
["Index Ref.","Proportions / weightings for each index (refer note 1)","Description / scope of index (e.g. Labour)","Full title/definition of index as per publisher","Source/publisher of index (e.g. SEIFSA, , LME)","Base Month for CPA if not Base Date as defined (refer note 4)","Base Date Index (refer note 4)","Foreign CPA formula currency code","Base reference price currency code ","Exchange rate (currency 1,00 = x)"]
["C1",{"$nulls":6}," "," "," "]
["C2",{"$nulls":8},{"$f":"IF(I87<>\"\",VLOOKUP(I87,#REF!,2,FALSE),\"\")","v":""}]
["C3",{"$nulls":8},{"$f":"IF(I88<>\"\",VLOOKUP(I88,#REF!,2,FALSE),\"\")","v":""}]
["C4",{"$nulls":8},{"$f":"IF(I89<>\"\",VLOOKUP(I89,#REF!,2,FALSE),\"\")","v":""}]
["C5",{"$nulls":8},{"$f":"IF(I90<>\"\",VLOOKUP(I90,#REF!,2,FALSE),\"\")","v":""}]
["C6",{"v":0.15,"d":"0.150"},"Fixed 15% minimum not subject to CPA (0.150)"]
[null,{"$f":"SUM(B86:B91)","v":{"v":0.15,"d":"0.150"}},"Total"]
[]
[]
["FORMULA D","Transport",{"$nulls":6},"Exchange rate for converting base reference price (e.g. US$ LME price) to the currency of this formula"]
["Index Ref.","Proportions / weightings for each index (refer note 1)","Description / scope of index (e.g. Labour)","Full title/definition of index as per publisher","Source/publisher of index (e.g. SEIFSA, , LME)","Base Month for CPA if not Base Date as defined (refer note 4)","Base Date Index (refer note 4)","Foreign CPA formula currency code ","Base reference price currency code ","Exchange rate (currency 1,00 = x)"]
["D1",{"$nulls":8},{"$f":"IF(I97<>\"\",VLOOKUP(I97,#REF!,2,FALSE),\"\")","v":""}]
["D2",{"$nulls":8},{"$f":"IF(I98<>\"\",VLOOKUP(I98,#REF!,2,FALSE),\"\")","v":""}]
["D3",{"$nulls":8},{"$f":"IF(I99<>\"\",VLOOKUP(I99,#REF!,2,FALSE),\"\")","v":""}]
["D4",{"$nulls":8},{"$f":"IF(I100<>\"\",VLOOKUP(I100,#REF!,2,FALSE),\"\")","v":""}]
["D5",{"$nulls":8},{"$f":"IF(I101<>\"\",VLOOKUP(I101,#REF!,2,FALSE),\"\")","v":""}]
["D6",{"v":0.15,"d":"0.150"},"Fixed 15% minimum not subject to CPA (0.150)"]
[null,{"$f":"SUM(B97:B102)","v":{"v":0.15,"d":"0.150"}},"Total"]

{"sheet":"5.1.6 MENU SPEC","index":8,"n_rows":59,"n_cols":3,"rows_kept":59,"merged":[[7,0,16,0],[19,0,22,0],[27,0,29,0],[31,0,31,2],[32,0,32,2],[34,0,34,2],[37,0,44,0],[45,0,50,0],[51,0,54,0],[51,2,54,2],[58,0,58,2]]}
["ANNEXURE 06"]
[]
["CATERING SERVICES AT KUSILE SITE AND KENDAL VILLAGE"]
[]
["MENU SPECIFICATION"]
["Item","Alternatives","Specification (Raw) "]
["Porridge","Maize meal, Mabele, Oats","100g "]
["Protein ","Eggs and Gravy ","2 Eggs + 80g Gravy"]
[null,"Vienna’s and Gravy  ","100g + 80g Gravy"]
[null,"Polony and Gravy","100g(slices) + 80g Gravy"]
[null,"Mince, ","120g"]
[null,"Fish Fingers and Gravy","100g + 80g Gravy"]
[null,"Chicken Livers","100g"]
[null,"Cheese (cheddar) and Gravy","50g + 80g Gravy"]
[null,"Wors ","120g"]
[null,"Beef Patty","100 g"]
[null,"Alternate - One each day"]
["Fruit","In Season","150 g"]
["Bread ","Brown or White","4 slices "]
["Spread ","Margarine  – Daily","2 Portions "]
[null,"Jam(3 varieties)   – Daily","2 Portions"]
[null,"Peanut butter       -  Daily","2 Portions"]
[null,"No Open Tins or Containers"]
["Beverages","Tea or Coffee (Good Quality – Branded Product)","1 bag or 1 sachet"]
["(Daily)","Sugar (Good Quality – Branded Product)","3 sachets"]
[null,"Creamer (Good Quality – Branded Product)","1 sachets"]
[null,"No Open Tins or Containers"]
[]
[null,"Magewu (Drinking Porridge)","500ml"]
[]
[]
["Disposable plastic cutlery (high quality grade) 2 x salt, pepper, serviette and toothpick in a sachet."]
["Tea and Coffee options to be combined in one sachet."]
[]
["Main Meal - Lunch and Supper (Packed for Site and Plated for Village) "]
["Item","Alternatives","Specification (Raw) "]
[]
["Protein ","Beef (Stew, chuck, blade)","280g"]
[null,"Chicken (Leg quarters, thighs, drumsticks)","280g"]
[null,"Vegetarian alternatives (daily)","220 – 250g"]
[null," "]
[]
[null,"The specification is for the cut only and does not  prescribe the dishes be included in the menu"]
[null,"Bone content not to exceed 15%"]
[]
["Starch ","Pap","150g"]
[null,"Rice","100g"]
[null,"Samp ","150g"]
[]
[null,"Rice to be served daily as an alternative to pap or samp and never without one of the two. "]
[]
["Vegetables","2 vegetables one green one yellow, daily ","100g each (peeled)"]
[]
[null,"Exclude vegetables that create chemical reactions e.g. tomato and cabbage"]
[]
["Fruit","In season","150g "]
["Beverage ","Juice (Minimum 40% fruit juice). Milk every alternative day at Kendal Village for Supper Only","250ml"]
[]
["Disposable plastic cutlery (high quality grade) 2 x salt, pepper, serviette and toothpick in a sachet."]

{"sheet":"5.1.7 DAY MENU (16 DAY MENU)","index":9,"n_rows":77,"n_cols":10,"rows_kept":77}
["ANNEXURE 07"]
[]
["CATERING SERVICES AT KUSILE SITE AND KENDAL VILLAGE"]
[]
["DAY MENU (16 DAYS MENU)"]
[]
[" 16 DAY CYCLE"]
[]
[null,null,"DAY 1","DAY 2 ","DAY 3 ","DAY 4","DAY 5","DAY 6","DAY 7","DAY 8"]
["BREAKFAST"]
["PORRIDGE","100g","MIELIE PAP","MABELLA","OATS","MIELIE PAP","MABELLA ","OATS","MIELIE PAP","MABELA"]
["MAGUE","500ml","MAGUE","MAGUE","MAGUE","MAGUE","MAGUE","MAGUE","MAGUE","MAGUE"]
["PROTEIN",null,"FISH CAKES       100g "," EGGS x 2       ","Savoury mince 100g ","VIENNA'S (100g) & ","FISH FINGERS       100g ","Chicken Livers 100g","Savoury mince 100g","FISH CAKES       100g "]
[null,null,"Tomato gravy (80g)"," Baked beans (80g)",null,"GRAVY (50g)","Tomato slice (60g)",null,null,"Tomato gravy (80g)"]
["TEA AND COFFEE","1 portion","Tea & Coffee ","Tea & Coffee ","Tea & Coffee ","Tea & Coffee ","Tea & Coffee ","Tea & Coffee ","Tea & Coffee ","Tea & Coffee "]
["FRUIT","1 portion","Fruit","Fruit","Fruit","Fruit","Fruit","Fruit","Fruit","Fruit"]
["CONDIMENTS","1 portion","Condiments and Spreads ","Condiments and Spreads ","Condiments and Spreads ","Condiments and Spreads ","Condiments and Spreads ","Condiments and Spreads ","Condiments and Spreads ","Condiments and Spreads "]
["BREAD","4 slices","Bread","Bread","Bread","Bread","Bread","Bread","Bread","Bread"]
[]
["LUNCH"]
["PROTEIN",null,"Beef Stew (280g) (50g veg's)","Portuguese Chicken  (280g) (50g veg's)","Wors Stew (240g)","Paprika Chicken  (280g) ","Grilled BBQ Chuck or Blade (280g)","Chicken Chakalaka    (80g veg's)","Beef Stew (280g) (50g veg's)","BBQ Chicken  (280g)"]
["GRAVY","100g",0,"Portuguese gravy","Tom & onion gravy ","Chakalaka vegs gravy","Beef gravy ","Paprika gravy",0,"Chicken gravy"]
["STARCH",null,"Pap & Rice ","Pap & Rice ","Pap & Rice ","Pap & Rice ","Pap & Rice &Samp","Pap & Rice ","Pap & Rice ","Pap & Rice "]
["VEGETABLE 1",null,"Pumpkin (150g raw)","Spinach & Potato     (150g raw)","Bake beans with carrots potato (200g ) ","Spinach &  Potato     (200g raw)","Green beans    (100g)    ","Sweet potato       (120g raw)","Pumpkin (150g raw)","Butternut      (100g raw)          "]
["VEGETABLE 2",{"$nulls":5},"Carrots     (100g)",null,null,"Morogo (100g raw)"]
["FRUIT","1 portion","FRUIT","FRUIT","FRUIT","FRUIT","FRUIT","FRUIT","FRUIT","FRUIT"]
["JUICE","250ml","JUICE","JUICE","JUICE","JUICE","JUICE","JUICE","JUICE","JUICE"]
[]
["SUPPER"]
["PROTEIN",null,"ROASTED CHICKEN 280g","BEEF STEW       280g","ROASTED CHICKEN 280g","WORS STEW        280g","ROASTED          BBQ CHICKEN  280g","GRILLED BLADE 280g","CHICKEN STEW      280g","BEEF CURRY       280g"]
["GRAVY","100g","GRAVY","GRAVY","GRAVY","GRAVY","GRAVY","GRAVY","GRAVY","GRAVY"]
["STARCH",null,"PAP (180g) or RICE (100g) or SAMP (150g)","PAP (180g) or RICE (100g) or SAMP (150g)","PAP (180g) or RICE (100g) or SAMP (150g)","PAP (180g) or RICE (100g) or SAMP (150g)","PAP (180g) or RICE (100g) or SAMP (150g)","PAP (180g) or RICE (100g) or SAMP (150g)","PAP (180g) or RICE (100g) or SAMP (150g)","PAP (180g) or RICE (100g) or SAMP (150g)"]
["VEGETABLES","100g","GEM SQUASH","ROASTED BUTTERNUT","SWEET POTATO","ROASTED BUTTERNUT","SPINACH","MIX VEGETABLES","GREEN BEANS","CURRIED CABBAGE"]
["SALAD","100g","COLE SLAW ","BEETROOT SALAD","PASTA SALAD","BEAN SALAD","POTATO SALAD ","MIX SALAD","CHAKALAKA SALAD ","COLE SLAW "]
["BEVERAGE","250ml","JUICE ","MILK(Kendal only)","JUICE ","MILK(Kendal only)","JUICE ","MILK(Kendal only)","JUICE ","MILK(Kendal only)"]
[]
[]
[]
[" 16 DAY CYCLE CONTINUES"]
[null,null,"DAY 9","DAY 10 ","DAY 11","DAY 12","DAY 13","DAY 14","DAY 15","DAY 16"]
["BREAKFAST"]
["PORRIDGE","100g","OATS","MIELIE PAP","MABELA","OATS","MIELIE PAP","MABELA","MIELIE PAP","MABELLA"]
["MAGUE","500ml","MAGUE","MAGUE","MAGUE","MAGUE","MAGUE","MAGUE","MAGUE","MAGUE"]
["PROTEIN",null,"CHEESE GAG","VIENNA'S (100g) &","FISH FINGERS       100g ","Chicken Livers 100g"," EGGS x 2        ","VIENNA'S (100g) ","CHEESE GAG","Savoury mince 100g "]
[null,null,"POLONY GAG "," GRAVY (50g)","Tomato slice (60g)",null,"Baked beans (80g)","GRAVY (50g)","POLONY GAG "]
["TEA AND COFFEE","1 portion","Tea & Coffee ","Tea & Coffee ","Tea & Coffee ","Tea & Coffee ","Tea & Coffee ","Tea & Coffee ","Tea & Coffee ","Tea & Coffee "]
["FRUIT","1 portion","Fruit","Fruit","Fruit","Fruit","Fruit","Fruit","Fruit","Fruit"]
["CONDIMENTS","1 portion","Condiments and Spreads ","Condiments and Spreads ","Condiments and Spreads ","Condiments and Spreads ","Condiments and Spreads ","Condiments and Spreads ","Condiments and Spreads ","Condiments and Spreads "]
["BREAD","4 slices","Bread","Bread","Bread","Bread","Bread","Bread","Bread","Bread"]
[]
["LUNCH"]
["PROTEIN",null,"Wors Stew (240g)","Chicken Casserole (280g) (50g veg's)","Grilled BBQ Chuck or Blade (280g)","Chicken Chakalaka    (80g veg's)","Beef Stew (280g) (50g veg's)","Portuguese Chicken  (280g) (50g veg's)","Grilled BBQ Chuck or Blade (280g)","Paprika Chicken  (280g) "]
["GRAVY","100g","Tom & onion gravy ","Casserole gravy","Beef gravy ","Chakalaka vegs gravy",0,"Portuguese gravy","Beef gravy ","Chakalaka vegs gravy"]
["STARCH",null,"Pap & Rice ","Pap & Rice ","Pap & Rice &Samp","Pap & Rice ","Pap & Rice ","Pap & Rice ","Pap & Rice &Samp","Pap & Rice "]
["VEGETABLE 1",null,"Bake beans with carrots dice potato (200g raw) ","Peas, carrots potatoes (150g raw)","Green beans    (100g)    ","Sweet potato       (120g raw)","Pumpkin (150g raw)","Spinach & Potato     (150g raw)","Green beans    (100g)    ","Spinach &  Potato     (200g raw)"]
["VEGETABLE 2",{"$nulls":3},"Carrots     (100g)",{"$nulls":3},"Carrots     (100g)"]
["FRUIT","1 portion","FRUIT","FRUIT","FRUIT","FRUIT","FRUIT","FRUIT","FRUIT","FRUIT"]
["JUICE","250ml","JUICE","JUICE","JUICE","JUICE","JUICE","JUICE","JUICE","JUICE"]
[]
["SUPPER"]
["PROTEIN",null,"CHICKEN CASSEROLE          280g","WORS STEW        280g","CHICKEN  STEW       280g","Grilled Chuck       280g","CHICKEN CURRY          280g","Beef Stew     280g","PAPRIKA CHICKEN                   280g","Beef Curry          280g"]
["GRAVY","100g","GRAVY","GRAVY","GRAVY","GRAVY","GRAVY","GRAVY","GRAVY","GRAVY"]
["STARCH",null,"PAP (180g) or RICE (100g) or SAMP (150g)","PAP (180g) or RICE (100g) or SAMP (150g)","PAP (180g) or RICE (100g) or SAMP (150g)","PAP (180g) or RICE (100g) or SAMP (150g)","PAP (180g) or RICE (100g) or SAMP (150g)","PAP (180g) or RICE (100g) or SAMP (150g)","PAP (180g) or RICE (100g) or SAMP (150g)","PAP (180g) or RICE (100g) or SAMP (150g)"]
["VEGETABLES","100g","GEM SQUASH","ROASTED BUTTERNUT","SWEET POTATO","FRIED CABBAGE","SPINACH","MIX VEGETABLES","GREEN BEANS","CURRIED CABBAGE"]
["SALAD","100g","BEETROOT SALAD","PASTA SALAD","BEAN SALAD","POTATO SALAD ","MIX SALAD","CHAKALAKA SALAD ","COLE SLAW ","BEETROOT SALAD"]
["BEVERAGE","250ml","JUICE ","MILK(Kendal only)","JUICE ","MILK(Kendal only)","JUICE ","MILK(Kendal only)","JUICE ","MILK(Kendal only)"]
[]
[]
[null,null,"Saturday ","Sunday   ","Monday"]
["PORRIDGE","100g"]
["PROTEIN",null,"Wors (120g)","Scramble eggs           &             ","Cheese 50g "]
[null,null,"Gravy (50g) ","Beef Pattie (100g) & Bake beans (50g)","EGG"]
["MAGUE","500ml","MAGUE","MAGUE","MAGUE"]
["TEA AND COFFEE","1 portion","TEA or COFFEE","TEA or COFFEE","TEA or COFFEE"]
["FRUIT","1 portion","FRUIT","FRUIT","FRUIT"]
["CONDIMENTS","1 portion","JAM & PEANUT BUTTER & MARGARINE","JAM & PEANUT BUTTER & MARGARINE","JAM & PEANUT BUTTER & MARGARINE"]
["BREAD","4 slices","BREAD (WHITE OR BROWN)","BREAD (WHITE OR BROWN)","BREAD (WHITE OR BROWN)"]

{"sheet":"5.1.8 STAFF COMPLIMENT ORGANO","index":10,"n_rows":4,"n_cols":2,"rows_kept":4}
[null,"ANNEXURE 08"]
[]
[null,"REQUIREMENT "]
[null,"Tenderer to provide Staff Compliment details (Price Breakdown)"]