{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["BOQ","CPA"],"not_rendered":{"defined_names":52},"read":"whole","date_system":"1900"}

{"sheet":"BOQ","index":0,"n_rows":43,"n_cols":8,"rows_kept":43,"merged":[[40,1,40,6]]}
["GROOTVLEI POWER STATION"]
["BOQ : SUPPLY AND DELIVERY OF GROCERIES"]
[]
["Item","Description","SAP date","Unit","Quantity","Old Rate","Rate","Total "]
[1,"CREAMER NON DAIRY:BAG PLASTIC;1 KG","14.08.19","each",4000,{"v":40,"d":"40.00"},null,{"$f":"E5*G5","v":0}]
[{"$f":"A5+1","v":2},"DETERGENT:FABRIC SOFTNER;LAUNDRY MACHINE","04.06.19","each",50,{"v":41.8,"d":"41.80"},null,{"$f":"E6*G6","v":0}]
[{"$f":"A6+1","v":3},"DETERGENT:SUNLIGHT;DISH WASHING;25 L","16.04.19","each",2000,{"v":465,"d":"465.00"},null,0]
[4,"SUGAR BRWN:PACKET;1 KG;GRANULES","19.09.19","kg",4400,23.45,null,0]
[5,"SUGAR REFND:PKT;2.5 KG;WHITE; PACKED IN","14.08.19","kg",15500,{"v":16,"d":"16.00"},null,0]
[6,"TEA:JOKO;BOX;250 G;TAGLESS 100 BAGS","14.08.19","each",3100,{"v":38,"d":"38.00"},null,0]
[7,"TEA:ROOIBOS;BOX;200 G","14.08.19","each",1500,{"v":46,"d":"46.00"},null,0]
[8,"MILK:LONG LIFE;FULL CREAM;CARTON;1 L","14.08.19","each",33000,{"v":14,"d":"14.00"},null,0]
[9,"COFFEE INST:RIC0FFY;RICOFFY DECAFF;TIN (750G)","14.08.19","each",1200,79.99,null,0]
[10,"COFFEE INST:NESCAFE DECAF;NESTLE;TIN (200g)","14.08.19","each",800,{"v":155,"d":"155.00"},null,0]
[11,"CREAM BARR:PETROLEUM JELLY WHITE;TUB","04.06.19","kg",900,{"v":49,"d":"49.00"},null,0]
[12,"SOAP LDRY:WASHING POWDER;10 KG","12.02.18","each",20,{"v":384,"d":"384.00"},null,0]
[13,"CLEANER HND:ARGOSY;TOILET SOAP","19.07.17","each",820,{"v":6,"d":"6.00"},null,0]
[14,"CLEANER HND:TOILET SOAP;CAKE 100 G","13.08.19","each",2500,{"v":9,"d":"9.00"},null,0]
[15,"CLEANER:SOAP;CAKE;WRAPPED 500 G;SUNLIGHT","24.05.19","each",1700,18.36,null,0]
[16,"CLEANER HND:COMPOUND;TUBE 250 ML;SOLOPOL","13.09.17","each",400,59.95,null,0]
[17,"CLEANER HND:DELUXE LIQUID SOAP;125XA","28.03.19","L",4000,15.26,null,0]
[18,"CLEANER:R;BLEACH;LIQUID;JIK","14.08.19","L",5000,{"v":23.3,"d":"23.30"},null,0]
[19,"PAPER TOILT:ROLL;1;WHITE;PERFORATED","09.09.19","each",140000,{"v":36,"d":"36.00"},null,0]
[20,"PAPER BOND:80 GSM;A4;WHITE;SHEET;80 GSM","29.11.19","each",23000,{"v":47,"d":"47.00"},null,0]
[21,"BAG:REFUSE;WD 800 X LG 930 X THK 0.5 MM","18.05.16","each",17000,1.05,null,0]
[22,"FLASHLIGHT:FL-006;RECHARGEABLE;(1) 6 V","25.07.18","each",800,{"v":450,"d":"450.00"},null,0]
[23,"BATT DCELL:ALKALINE;1.5 VDC;AAA","09.10.18","each",5000,11.25,null,0]
[24,"BATT DCELL:ALKALINE;1.5 VDC;AA;FLAT PIN","21.01.19","each",5000,7.85,null,0]
[25,"PADLOCK:KEY;6 MM;WD 33 X THK 40 MM;BRS","11.10.18","each",700,{"v":141,"d":"141.00"},null,0]
[26,"PADLOCK:KEY;5 MM;BRS;14 MM;16 MM","01.06.17","each",200,{"v":82.5,"d":"82.50"},null,0]
[27,"PADLOCK:KEY;8.8 MM;50 MM;BRS;25 MM;25 MM","31.01.19","each",400,{"v":113,"d":"113.00"},null,0]
[28,"TOWEL PPR:DISPOSABLE;WD 240 MM;LG 360 MM","11.07.18","each",350,{"v":270,"d":"270.00"},null,0]
[29,"TOWEL PPR:DISPOSABLE;WD 270 MM;LG 1.5 KM","14.03.19","each",2100,236.75,null,0]
[30,"BIN WST:REFUSE;DIA 450 X HT 600 MM;PE","29.05.18","each",50,{"v":1080,"d":"1,080.00"},null,0]
[31,"COFFEE INST:CLASSIC;NESCAFE;GRANULES;JAR","09.09.21","each",20,207.69,null,0]
[32,"COFFEE INST:FILTER CLASSIC PRELUDE;CIRO","06.12.18","each",10,1782.5,null,0]
[33,"BAG:REFUSE;WD 750 X LG 950 MM;BLACK;20","22.03.18","each",50000,1.79,null,0]
[34,"BATT DCELL:ALKALINE;9 VDC","06.10.15","each",400,108.1,null,0]
[35,"BATT DCELL:D;ALKALINE;1.5 VDC;D","23.07.20","each",1300,25.8,null,0]
[36,"PAPER BOND:A4;PINK LIGHT;BOX 5 RM","25.05.21","each",500,628.1,null,0]
[null,"TOTAL",{"$nulls":5},{"$f":"SUM(H4:H40)","v":{"v":0,"d":"R0.00"}}]
[]
[null,"Total Value",{"$nulls":5},{"$f":"SUM(H5:H40)","v":{"v":0,"d":"R0.00"}}]

{"sheet":"CPA","index":1,"n_rows":21,"n_cols":9,"rows_kept":21,"hidden":true,"merged":[[5,1,5,2],[7,1,8,1],[7,2,8,2],[7,4,8,4],[7,5,8,5],[7,6,8,6],[7,7,8,7],[7,8,8,8]]}
[]
[null,"CPA Calculation - The provision of electrical maintenance at Grootvlei Power Station"]
[]
[]
[]
[null,"Base Date :  01 December 2017"]
[]
[null,"Ref","Description - Component","CPA","Component size","Base index","Final index","Gross Adustment","Net adjustment"]
[]
[]
[null,null,"FORMULA"]
[]
[null,1,"Non-adjustable (Fixed Portion)","Fixed",0]
[]
[null,3,"Material","Stats SA - Table D2  ",{"v":0.9,"d":"0.90"},{"v":100,"d":"100.00"},{"v":122.6,"d":"122.60"},{"$f":"E15*(G15/F15)","v":{"v":1.1034,"d":"1.10"}},{"$f":"H15-E15","v":{"v":0.20339999999999991,"d":"0.20"}}]
[]
[null,3,"Transport","Stats SA - Table L2 A",{"v":0.1,"d":"0.10"},{"v":100,"d":"100.00"},{"v":136.3,"d":"136.30"},{"$f":"E17*(G17/F17)","v":{"v":0.13630000000000003,"d":"0.14"}},{"$f":"H17-E17","v":{"v":0.03630000000000003,"d":"0.04"}}]
[]
[]
[]
[null,null,"Net Adjustment Total",null,{"$f":"SUM(E13:E19)","v":{"v":1,"d":"1.00"}},{"$nulls":3},{"$f":"SUM(I13:I19)","v":{"v":0.23969999999999994,"d":"0.24"}}]