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

{"sheet":"BOQ","index":0,"n_rows":57,"n_cols":6,"rows_kept":57,"merged":[[53,5,54,5]]}
[]
[{"$nulls":3},"Total of Prices:",null,{"$f":"SUM(F4:F57)","v":{"v":0,"d":"R0.00"}}]
[null,"SCOPE OF WORK: Full Refurbishment 1000KVA","Unit","QTY (No of Minisubs)","Rate","Total"]
[null,"REFURBISH ACTIVE PART"]
[null,"Drain oil from transformer into storage tank"]
[null,"Remove top cover and untank active part"]
[null,"Inspect active part and conduct insulation resistance test on the core insulation.","Sum",20,null,{"$f":"E7*D7","v":{"v":0,"d":"R0.00"}}]
[null,"Low voltage tests (ratio & polarity, magnetization, Impedance, resistance and Insulation resistance)."]
[null,"Active part final dry out, tank and test."]
[null,"REFURBISH TANK"]
[null,"Sandblast tank and base   "]
[null,"Clean and regasket Replace breathers."]
[null,"Modify Casing to Install drain valve Modify Casing to install sight glass"]
[null,"Grind top lid base to prepare for modification of top lid"]
[null,"Take measurements and manufacture new top l!d"]
[null,"Install top lid with provision for a filling up point & breather on top lid "]
[null,"Punch holes with hole punching machine for mounting of top lid to casing "]
[null,"Install new piping for breather point"]
[null,"Apply red oxide coatings to transformer base and check paint thicknesses."]
[null,"Sandblast, clean and abrade surfaces","Sum",20,null,{"$f":"E20*D20","v":{"v":0,"d":"R0.00"}}]
[null,"Paint CR12 Green"]
[null,"Check paint thicknesses"]
[null,"Manufacture new warning stickers and information boards"]
[null,"Replace all bolts, studs, washers and nuts"]
[null,"LV COMPARTMENT UNIT"]
[null,"Install new neutral busbar","Sum",20,null,{"$f":"E26*D26","v":{"v":0,"d":"R0.00"}}]
[null,"Install new LV compartment gland plate"]
[null,"Testing of LV breakers & cleaning thereof with electrical cleaner"]
[null,"Install & Replace Ammeter & Voltmeter"]
[null,"Ammeter & voltmeter testing for functionality & cleaning with electrical cleaner"]
[null,"SWITCHGEAR"]
[null,"Re-furbish/ Replace RMU allow for full FAT testing","Sum",20,null,{"$f":"E32*D32","v":{"v":0,"d":"R0.00"}}]
[null,"Test CT's"]
[null,"Check measuring Instruments for functionality"]
[null,"SERVICE INSULATORS"]
[null,"Clean insulator shells."]
[null,"Replace all seal sand gaskets on HV & LV  sides ","Sum",20,null,{"$f":"E37*D37","v":{"v":0,"d":"R0.00"}}]
[null,"Reassemble insulators on both HV & LV sides "]
[null,"Paint flanges and parts and refit on transformer."]
[null,"TAP CHANGER"]
[null,"Clean all contacts, spring tensions and shafts. Operate to check free movement.","Sum",20,null,{"$f":"E41*D41","v":{"v":0,"d":"R0.00"}}]
[null,"Refit Tap changer"]
[null,"DRY OUT AND OIL FILLING"]
[null,"Final dry out active part"]
[null,"Supply virgin uninhibited oil"]
[null,"Fill transformer With oil under vacuum. Take oil samples for kV, moisture and DGA. Perform final HV test on the transformer.","SUM",20,null,{"$f":"E46*D46","v":{"v":0,"d":"R0.00"}}]
[null,"Take oil sample for DGA after HV test.",null,null,"1600LT allowed/mini"]
[null,"TESTING"]
[null,"Tests performed before after Dry out and again after Oil filling:"]
[null,"Ratio and vector group Magnetization Impedance"]
[null,"Resistance Megger"]
[null,"HV tests:"]
[null,"Tan delta test at 100°/0 Separate source 80%","Sum",20,null,{"$f":"E53*D53","v":{"v":0,"d":"R0.00"}}]
[null,"No load loss at 1000/4"]
[null,"Load loss at 100%"]
[null,"TRANSPORTATION"]
[null,"Transportation from Site to Testing Premises and back to site Perform megger test prior and after loading on transport,","Sum",20,null,{"$f":"E57*D57","v":{"v":0,"d":"R0.00"}}]