{"text_format":"3","workbook":"xls","n_sheets":18,"sheets":["Summary","A1","A2","A3","A4","A5","B1","B2","B3","Contractor SDM","SDM Cert ","Rep Sum ","IA ","Invoice ","Statement ","SDM COVER","RECON CESSION","Invoice"],"not_rendered":{"images":9,"macros":1,"external_links":5,"defined_names":15},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Summary","index":0,"n_rows":20,"n_cols":4,"rows_kept":20,"merged":[[1,2,1,3],[2,2,2,3],[14,1,14,2],[18,1,18,2],[19,1,19,2]],"flags":["formulas_cached_only"]}
[]
[null,"PROJECT NO.","SUMMARY OF QUANTITIES"]
[null,"INF-W16/2023/2024","CAPRICORN HOUSEHOLD SANITATION PROJECT "]
[]
[null,"SECTION REFERENCE","DESCRIPTION","TENDERED AMOUNT"]
[]
[null,"A1","PRELIMINARY AND GENERAL - FIXED CHARGE AND VALUE RELATED OBLIGATIONS"]
[null,"A2","PRELIMINARY AND GENERAL - TIME RELATED OBLIGATIONS"]
[null,"A3","PRELIMINARY AND GENERAL - PROVISIONAL SUMS"]
[null,null,"SCHEDULE A"]
[null,"B1","EARTHWORKS FOR TOILET PITS"]
[null,"B2","CONCRETE AND MASONRY WORKS"]
[null,null,"SCHEDULE B"]
[]
[null,"SUB-TOTAL A"]
[null,"Less 10% Retention"]
[null,"ALLOW FOR  10% CONTIGENCIES"]
[null,"SUB-TOTAL B"]
[null,"VALUE ADDED TAX [15%]:"]
[null,"TOTAL TO FORM OF OFFER"]

{"sheet":"A1","index":1,"n_rows":33,"n_cols":7,"rows_kept":33,"merged":[[1,1,2,1],[1,2,1,3],[1,4,1,5],[2,2,2,3],[2,4,2,5],[6,2,6,5],[32,3,32,5]],"flags":["formulas_cached_only"]}
[]
[null,null,"SCHEDULE OF QUANTITIES",null,"CONTRACT No.:",null,"SECTION No.:"]
[null,null,"                                                                    ",null,"INF-W16/2023/2024",null,"A1"]
[]
[null,"ITEM No.","DESCRIPTION","UNIT","QUANTITY","RATE","TOTAL AMOUNT"]
[]
[null,"A1","PRELIMINARY AND GENERAL - FIXED CHARGE AND VALUE RELATED OBLIGATIONS"]
[null,1.1,"Contractual Requirements:"]
[null,"1.1.1","Fixed charge contractual requirements.","Sum",{"v":1,"d":"1.00"},null,0]
[null,"1.1.2","Value related contractual requirements.","Sum",{"v":1,"d":"1.00"},null,0]
[]
[null,1.2,"Facilities for Engineer:"]
[null,"1.2.1","Furnished office - 1 No.","No",{"v":1,"d":"1.00"},null,0]
[null,"1.2.2","Name boards ","No",{"v":2,"d":"2.00"},null,0]
[]
[null,1.3,"Facilities for Contractor:"]
[null,"1.3.1","Offices and storage sheds","Sum",{"v":1,"d":"1.00"},null,0]
[null,"1.3.2","Living accommodation","Sum",{"v":1,"d":"1.00"},null,0]
[null,"1.3.3","Ablution and latrine facilities","Sum",{"v":1,"d":"1.00"},null,0]
[null,"1.3.4","Tools and equipment","Sum",{"v":1,"d":"1.00"},null,0]
[null,"1.3.5","Water supplies, electric power and communications","Sum",{"v":1,"d":"1.00"},null,0]
[null,"1.3.6","Access","Sum",{"v":1,"d":"1.00"},null,0]
[null,"1.3.7","Plant","Sum",{"v":1,"d":"1.00"},null,0]
[null,"1.3.8","Materials on site storage and protection.","Sum",{"v":1,"d":"1.00"},null,0]
[]
[null,1.4,"Other Fixed Charge Obligations:","Sum",{"v":1,"d":"1.00"},null,0]
[]
[null,1.5,"Removal of Site Establishment:","Sum",{"v":1,"d":"1.00"},null,0]
[]
[null,1.6,"Occupational Health & Safety"]
[null,"1.6.1","Compliance with Occupational  Health and Safety ACT including COVID-19 safety compliance","Sum",{"v":1,"d":"1.00"},null,0]
[]
[{"$nulls":3},"TOTAL CARRIED TO SUMMARY",null,null,0]

{"sheet":"A2","index":2,"n_rows":29,"n_cols":7,"rows_kept":29,"merged":[[1,1,2,1],[1,2,1,3],[1,4,1,5],[2,2,2,3],[2,4,2,5],[6,2,6,5],[28,3,28,5]],"flags":["formulas_cached_only"]}
[]
[null,null,"SCHEDULE OF QUANTITIES",null,"CONTRACT No.:"]
[null,null,"CAPRICORN HOUSEHOLD SANITATION PROJECT ",null,"INF-W16/2023/2024"]
[]
[null,"ITEM No.","DESCRIPTION","UNIT","QUANTITY","RATE","TOTAL"]
[]
[null,"A2","PRELIMINARY AND GENERAL - TIME RELATED OBLIGATIONS"]
[null,2.1,"Contractual Requirements:"]
[null,"2.1.1","Time related contractual requirements.","Month",{"v":6,"d":"6.00"},null,0]
[]
[null,2.2,"Facilities for Engineer:"]
[null,"2.2.1","Furnished office - 1 No.","Month",{"v":6,"d":"6.00"},null,0]
[null,"2.2.2","Telephone","Month",{"v":6,"d":"6.00"},null,0]
[]
[null,"2.3","Facilities for Contractor:",{"$nulls":3},0]
[null,"2.3.1","Offices and storage sheds.","Month",{"v":6,"d":"6.00"},null,0]
[null,"2.3.4","Living accommodation.","Month",{"v":6,"d":"6.00"},null,0]
[null,"2.3.5","Ablution and latrine facilities.","Month",{"v":6,"d":"6.00"},null,0]
[null,"2.3.6","Tools and equipment.","Month",{"v":6,"d":"6.00"},null,0]
[null,"2.3.7","Water supplies, electric power and communications.","Month",{"v":6,"d":"6.00"},null,0]
[null,"2.3.8","Access.","Month",{"v":6,"d":"6.00"},null,0]
[null,"2.3.9","Plant.","Month",{"v":6,"d":"6.00"},null,0]
[]
[]
[null,"2.4","Occupational Health & Safety"]
[null,"2.4.1","Compliance with Occupational Health and Safety ACT","Month",{"v":6,"d":"6.00"},null,0]
[]
[]
[{"$nulls":3},"TOTAL CARRIED TO SUMMARY",null,null,0]

{"sheet":"A3","index":3,"n_rows":32,"n_cols":7,"rows_kept":32,"merged":[[1,1,2,1],[1,2,1,3],[1,4,1,5],[2,2,2,3],[2,4,2,5],[6,2,6,5],[31,3,32,5]],"flags":["formulas_cached_only"]}
[]
[null,null,"SCHEDULE OF QUANTITIES",null,"CONTRACT No.:",null,"INF-W16/2023/2024"]
[null,null,"CAPRICORN HOUSEHOLD SANITATION PROJECT ",null,"INF-W16/2023/2024"]
[]
[null,"ITEM No.","DESCRIPTION","UNIT","QUANTITY","RATE","TOTAL AMOUNT"]
[]
[null,null,"PRELIMINARY AND GENERAL - PROVISIONAL SUMS"]
[null,3.1,"Community Liaison Officer:"]
[null,"3.1.1","Provision for the employment of CLO for each village","Prov.Sum",{"v":1,"d":"1.00"},{"v":54000,"d":"54,000.00"},{"v":54000,"d":"54,000.00"}]
[null,"3.1.2","Overheads, charges and profit on item 3.1.1.","%",{"v":54000,"d":"54,000.00"},null,0]
[]
[null,3.2,"PSC Attendance at Site Meeting:"]
[null,"3.2.1","Provision for the attendance of PSC members.","Prov.Sum",{"v":1,"d":"1.00"},{"v":7200,"d":"7,200.00"},{"v":7200,"d":"7,200.00"}]
[null,"3.2.2","Overheads, charges and profit on item 3.2.1.","%",{"v":7200,"d":"7,200.00"},null,0]
[]
[null,3.3,"Basic Skills and Construction Training:"]
[null,"3.3.1","Provision for basic skills and construction site safety training.","Prov. Sum",{"v":1,"d":"1.00"},{"v":120000,"d":"120,000.00"},{"v":120000,"d":"120,000.00"}]
[null,"3.3.2","Overheads, charges and profit on item 3.3.1.",null,{"v":120000,"d":"120,000.00"},null,0]
[]
[]
[null,3.4,"Community Development",null,null,""]
[null,"3.4.1","Specialist hygiene training, providing training and facilitation to beneficiaries (i.e compensation for community reps, user education materials, health & hygiene workshops) .","Prov. Sum",{"v":1,"d":"1.00"},{"v":250000,"d":"250,000.00"},{"v":250000,"d":"250,000.00"}]
[null,null,"Overheads, charges and profit on item 3.4.1.","%",{"v":250000,"d":"250,000.00"},null,0]
[]
[null,"3.5","Student training"]
[null,"3.5.1","Nominated student","Prov sum",{"v":1,"d":"1.00"},{"v":30000,"d":"30,000.00"},{"v":30000,"d":"30,000.00"}]
[null,"3.5.2","Overheads, charges and profit on item 3.4.2","%",{"v":30000,"d":"30,000.00"},null,0]
[]
[null,3.6,"Provision for numbering of VIP's"]
[null,"3.6.1","numbering of units as approved by engineers","sum",{"v":1,"d":"1.00"},{"v":20000,"d":"20,000.00"},{"v":20000,"d":"20,000.00"}]
[{"$nulls":6}," "]
[{"$nulls":3},"TOTAL CARRIED TO SUMMARY"]

{"sheet":"A4","index":4,"n_rows":35,"n_cols":10,"rows_kept":35,"hidden":true,"merged":[[1,1,2,1],[1,2,1,3],[1,4,1,5],[1,6,1,9],[2,2,2,3],[2,4,2,5],[2,6,2,9],[6,2,6,5]],"flags":["formulas_cached_only"]}
[]
[null,null,"SCHEDULE OF QUANTITIES",null,"CONTRACT No.:",null,"SECTION"]
[null,null,"CAPRICORN HOUSEHOLD SANITATION PROJECT ",null,"INF-W16/2023/2024",null,"A4"]
[]
[null,"ITEM No.","DESCRIPTION","UNIT","QUANTITY","RATE","PRESENT QUANTITY","PREVIOUS QUANTITY","TOTAL  QUANTITY","AMOUNT"]
[]
[null,"A4","PRELIMINARY AND GENERAL - DAYWORKS",{"$nulls":6},{"v":10500,"d":"10,500.00"}]
[null,5.1,"Labour - Normal Working Hours: [Provisional]"]
[null,"5.1.1","Skilled Labour (Artisan).","hr",{"v":40,"d":"40.00"},{"v":25,"d":"25.00"},null,null,0,0]
[null,"5.1.2","Semi-skilled Labour.","hr",{"v":40,"d":"40.00"},{"v":35,"d":"35.00"},null,null,0,0]
[null,"5.1.3","Unskilled Labour.","hr",{"v":40,"d":"40.00"},{"v":25,"d":"25.00"},null,null,0,0]
[null,"5.1.4","Foreman.","hr",{"v":40,"d":"40.00"},{"v":90,"d":"90.00"},null,null,0,0]
[null,"5.1.5","Extra-over rate for items 5.1.1 to 5.1.4 for work during non working hours.","hr","R/O"]
[]
[null,5.2,"Materials: [Provisional]"]
[null,"5.2.1","Allowance for Materials used under Dayworks.","Sum",{"v":1,"d":"1.00"},{"v":20000,"d":"20,000.00"},0.25,null,0.25,{"v":5000,"d":"5,000.00"}]
[null,"5.2.2","Overheads, Handling and all Charges on Item 5.2.1.","%",{"v":20000,"d":"20,000.00"},{"v":0.1,"d":"10%"},null,null,0,{"v":500,"d":"500.00"}]
[]
[null,5.3,"Plant - Heavy Equipment: [Provisional]"]
[null,null,"(Plant shall not be more than 3 years old or have more than 3000 hrs logged. Operator to be qualified and competency certified.)"]
[null,"5.3.1","Excavator - Size Cat 225.","hr","R/O"]
[null,"5.3.2","Excavator - TLB.","hr","R/O"]
[null,"5.3.3","Grader 140G or similar.","hr","R/O"]
[null,"5.3.4","Front end loader - bucket capacity ≤ 1.5 m3.","hr","R/O"]
[null,"5.3.5","Front end loader - bucket capacity ≤ 1.5 m3.","hr","R/O"]
[null,"5.3.6","Tip truck - 5 m3  capacity.","hr","R/O"]
[null,"5.3.7","Tip truck - 10 m3 capacity.","hr","R/O"]
[null,"5.3.8","Vibratory compaction roller - 13.5 ton.","hr","R/O"]
[null,"5.3.9","Transport cost per any unit of plant to deliver to site and remove from site for items 5.3.1 to 5.3.8","Sum",{"v":1,"d":"1.00"},{"v":5000,"d":"5,000.00"},{"v":1,"d":"1.00"},null,{"v":1,"d":"1.00"},{"v":5000,"d":"5,000.00"}]
[]
[null,5.4,"Plant - Small Equipment: [Provisional]"]
[null,"5.4.1","Pedestrian roller - BW90 or similar.","hr","R/O"]
[null,"5.4.2","Vibratory plate compactor.","hr","R/O"]
[null,"5.4.3","Vibratory rammer.","hr","R/O"]
[null,"5.4.4","Transport cost per any unit of plant to deliver to site and remove from site for items 5.4.1 to 5.4.3. ","Sum",{"v":1,"d":"1.00"},{"v":5000,"d":"5,000.00"},null,null,0,0]

{"sheet":"A5","index":5,"n_rows":13,"n_cols":10,"rows_kept":13,"hidden":true,"merged":[[1,1,2,1],[1,2,1,3],[1,4,1,5],[1,6,1,9],[2,2,2,3],[2,4,2,5],[2,6,2,9],[6,2,6,5]],"flags":["formulas_cached_only"]}
[]
[null,null,"SCHEDULE OF QUANTITIES",null,"CONTRACT No.:",null,"SECTION"]
[null,null,"CAPRICORN HOUSEHOLD SANITATION PROJECT ",null,"INF-W16/2023/2024",null,"A5"]
[]
[null,"ITEM No.","DESCRIPTION","UNIT","QUANTITY","RATE","PRESENT QUANTITY","PREVIOUS QUANTITY","TOTAL  QUANTITY","AMOUNT"]
[]
[null,"A5","PRELIMINARY AND GENERAL - TEMPORARY WORKS",{"$nulls":6},{"v":18000,"d":"18,000.00"}]
[null,6.1,"Access Roads to the Works."]
[null,"6.1.1","Provision and maintenance of construction access to sites or houses as required by the contractor.","Prov.Sum",{"v":1,"d":"1.00"},{"v":42000,"d":"42,000.00"},0.25,null,0.25,{"v":10500,"d":"10,500.00"}]
[]
[]
[null,6.2,"Safety Measures at Excavations:"]
[null,"6.2.1","Provision of all safety measures required to fully protect all excavations against public access, injury or any other possible accident. ","Prov.Sum",{"v":1,"d":"1.00"},{"v":30000,"d":"30,000.00"},0.25,null,0.25,{"v":7500,"d":"7,500.00"}]

{"sheet":"B1","index":6,"n_rows":33,"n_cols":11,"rows_kept":33,"merged":[[1,2,2,2],[1,3,1,4],[1,5,1,6],[1,7,1,8],[2,3,2,4],[2,5,2,6],[2,7,2,8],[6,3,6,6],[32,5,33,7]],"flags":["formulas_cached_only"]}
[]
[{"$nulls":3},"SCHEDULE OF QUANTITIES",null,"CONTRACT No.:",null,"SECTION No.:"]
[{"$nulls":3},"CAPRICORN HOUSEHOLD SANITATION PROJECT ",null,"INF-W16/2023/2024",null,"B1"]
[]
[null,"LIC","ITEM No.","DESCRIPTION","UNIT","QUANTITY","RATE","NO.OF VIPs","TOTAL AMOUNT"]
[]
[null,null,"B1","EARTHWORKS FOR TOILET PITS"]
[null,null,1.1,"Site Clearance:"]
[null,"LIC","1.1.1","Digging up and removing rubish, debris, vegetation, hedges, shrubs and trees not exceeding 200mm girth, bush, etc ","m2",{"v":4,"d":"4.00"},null,515,0]
[null,"LIC","1.1.2","Stripping average 100mm thick layer of top soil and dump to a suitable dumping site to be located by the contractor ","m2",{"v":4,"d":"4.00"},null,515,0]
[]
[null,null,1.2,"Excavations"]
[{"$nulls":3},"Excavate in earth not exceeding 2m deep below natural, elevated or reduced ground level for "]
[null,"LIC","1.2.1","Pit excavation and foundation trench","m3",{"v":10,"d":"10.00"},null,515,0]
[]
[null,"LIC","1.2.2","Extra over all excavations for carting away surplus material from 'excavations and /or stockpile on site to a dumping site to be located by the contractor ","m3",2,null,160,0]
[]
[null,null,"1.2.3","Extra over all excavations in soft rock in pits and foundation trenches","m3",{"v":2.5,"d":"2.50"},null,120,0]
[]
[null,null,"1.2.4","Provision  for excavation in hard rock","m3",6,null,80,null,null,480]
[]
[null,null,1.3,"Excavation Ancillaries;"]
[]
[null,null,"1.3.1","Allow for risk of collapse top sides of hole exceeding 1.5m deep","m2",{"v":2,"d":"2.00"},null,80,0]
[]
[]
[null,null,1.4,"Backfill and Compaction:"]
[null,"LIC","1.4.1","Backfill and compact trenches using labour intensive methods From the excavations, spread, well watered, levelled and compacted in layers not exceeding 150mm thick in back filling around the pit to 95% MOD.AASHTO density at optimum moisture content","m3",{"v":2,"d":"2.00"},null,515,0]
[]
[null,null,"1.4.2","Provision for compaction tests as approved by the engineer","Sum",{"v":1,"d":"1.00"},null,null,{"v":15000,"d":"15,000.00"}]
[]
[]
[{"$nulls":5},"TOTAL CARRIED TO SUMMARY"]

{"sheet":"B2","index":7,"n_rows":74,"n_cols":9,"rows_kept":74,"merged":[[1,2,2,2],[1,3,1,4],[1,5,1,6],[1,7,1,8],[2,3,2,4],[2,5,2,6],[2,7,2,8],[6,3,6,6],[45,4,46,6],[45,8,46,8],[48,4,48,6]],"flags":["formulas_cached_only"]}
[]
[{"$nulls":3},"SCHEDULE OF QUANTITIES",null,"CONTRACT No.:",null,"SECTION No.:"]
[{"$nulls":3},"CAPRICORN HOUSEHOLD SANITATION PROJECT ",null,"INF-W16/2023/2024",null,"B2"]
[]
[null,"LIC","ITEM No.","DESCRIPTION","UNIT","QUANTITY","RATE","NO. OF VIPs","TOTAL AMOUNT"]
[]
[null,null,"B2","CONCRETE AND MASONRY WORKS"]
[]
[{"$nulls":3},"CONCRETE, FORMWORK AND REINFORCEMENT"]
[{"$nulls":3},"(Finishing top surfaces of concrete smooth with wood float)"]
[]
[null,null,2.1,"FOUNDATIONS"]
[{"$nulls":3},"(Concrete foundation of PIT to be 130mm thick by 250mm wide)"]
[null,"LIC","2.1.1","Concrete with a coarse aggregate of 19mm and a minimum compressive strength of 20Mpa at 28 days","m3",0.65,null,515,0]
[]
[{"$nulls":3},"Extra over item 2.1.1","m3",0.25,null,80,0]
[]
[null,null,2.2,"CONCRETE TESTS BLOCK"]
[]
[null,null,"2.2.1","Provison for making and testing 150 x150x150mm concrete strength test cubes","Sum",1,null,null,{"v":8000,"d":"8,000.00"}]
[]
[null,null,2.3,"CONCRETE SUNDRIES"]
[]
[null,"LIC","2.3.1","Concrete slabs","m3",{"v":2.8,"d":"2.80"},null,50,0]
[]
[null,null,"2.3.2","Provision for walkways as instructed by engineer","sum",{"v":1,"d":"1.00"},null,null,{"v":42000,"d":"42,000.00"}]
[]
[null,null,2.4,"MASONRY"]
[]
[{"$nulls":3},"Description for brickwork shall be deemed to include for"]
[{"$nulls":3},"brickforce specified every three course"]
[]
[{"$nulls":3},"LINED PITS"]
[]
[{"$nulls":3},"BRICKWORK"]
[]
[{"$nulls":3},"Brickwork in M4 Blocks/Maxi bricks with cement mortar 1:5 mix"]
[{"$nulls":3},"All joints grouted in solid with cement mortar"]
[]
[null,"LIC","2.4.1","140mm Thick wall","m2",{"v":15,"d":"15.00"},null,{"v":515,"d":"515.00"},0]
[]
[]
[null,null,"2.4.2","Brickforce 220mm wide","m",{"v":40,"d":"40.00"},null,{"v":515,"d":"515.00"},0]
[]
[]
[{"$nulls":4},"SUMMARY CARRIED FORWARD"]
[]
[]
[{"$nulls":4},"BALANCE BROUGHT FORWARD"]
[]
[null,null,"2.5","PLASTERING"]
[]
[null,"LIC","2.5.1","Plaster inside of pit using 1:1:1 cement, plasters and & key-cote sealant mixture.","m2",{"v":14,"d":"14.00"},null,{"v":80,"d":"80.00"},0]
[null,"LIC","2.5.2","Extra over item for 2.4.3.1 sealant dealing with high water table,Plaster to height of 1m from bottom.","m2",{"v":5,"d":"5.00"},null,{"v":80,"d":"80.00"},0]
[]
[null,null,"2.6","SOILCRETE"]
[]
[null,"LIC","2.6.1","Soilcrete backfill to sides of pit using 7% 32.5 CEM II Portland cement.","m3",{"v":2.5,"d":"2.50"},null,5,0]
[{"$nulls":3},"'Concrete slab for dealing with high water table(Incl.100mm of soilcrete to be used on the surround of the pit)"]
[{"$nulls":3},"NB! The area measured for payment shall be determined from the drawings."]
[]
[]
[]
[null,null,"2.7","SUPERSTRUCTURE"]
[]
[{"$nulls":3},"APPROVED PRECAST PANELS"]
[]
[null,31,null,"All precast panels to be purchased from approved suppliers ONLY."]
[{"$nulls":3},"Procure and install complete  concrete top structure (inclusive of all panels, base & cover slabs, galvanized door,  pedestal, seat & lid, vent pipe and fly screen,  handwash basin, 10l reservoir, 250 micron DPC for soak pit, all pipe work, fittings and seals) with 25mm concrete screed on top of pre-casted slabs"]
[null,null,"2.7.1","Supply and installation of precast concrete VIP superstructure","No",{"v":1,"d":"1.00"},null,{"v":505,"d":"505.00"},0]
[]
[null,null,"2.7.2","Supply and installation of precast concrete VIP superstructure(Disabled Persons)","No",{"v":1,"d":"1.00"},null,{"v":10,"d":"10.00"},0]
[]
[{"$nulls":5},"TOTAL CARRIED TO SUMMARY"]

{"sheet":"B3","index":8,"n_rows":29,"n_cols":11,"rows_kept":29,"hidden":true,"merged":[[1,1,2,1],[1,2,1,3],[1,4,1,5],[1,6,1,10],[2,2,2,3],[2,4,2,5],[2,6,2,10],[6,2,6,5]],"flags":["formulas_cached_only"]}
[]
[null,null,"SCHEDULE OF QUANTITIES",null,"CONTRACT No.:",null,"SECTION No.:"]
[null,null,"CAPRICORN HOUSEHOLD SANITATION PROJECT ",null,"INF-W16/2023/2024",null,"B3"]
[]
[null,"ITEM No.","DESCRIPTION","UNIT","QUANTITY","RATE","NO. OF VIPs","PRESENT QUANTITY","PREVIOUS QUANTITY","TOTAL  QUANTITY","AMOUNT"]
[]
[null,"B3","IRONMONGERY AND PLUMBING",{"$nulls":7},0]
[]
[null,3.1,"IRONMONGERY"]
[]
[null,null,"SUPPLEMENTARY PREAMBLES"]
[null,null,"Description for bolts shall be deemed to include nuts and washers"]
[]
[null,"3.1.1","Supply and installation of a Standard stainless steel door with a lockable spring-loaded latch from approved suppliers.","No.",{"v":1,"d":"1.00"},{"v":200,"d":"200.00"},300,null,null,0,0]
[]
[]
[null,3.2,"PLUMBING AND DRAINAGE"]
[]
[null,"3.2.1","u PVC pipes"]
[]
[null,"3.2.1.1","Supply and installation of 110mm Ø Black Ventilation pipe ","m",{"v":3,"d":"3.0"},{"v":80,"d":"80.00"},300,null,null,0,0]
[]
[null,"3.2.2","VIP CLOSET"]
[null,null,"Supply and installation of the following item from approved suppliers:"]
[null,"3.2.2.1","PVC  VIP Toilet Pan","No",{"v":1,"d":"1.00"},{"v":250,"d":"250.00"},300,null,null,0,0]
[]
[null,"3.2.2.2","Plastic Toilet Seat and Flap","No",{"v":1,"d":"1.00"},{"v":120,"d":"120.00"},300,null,null,0,0]
[]
[null,"3.2.2.3","Supply and install CSIR Handwash apparatus","No",{"v":1,"d":"1.00"},{"v":200,"d":"200.00"},300,null,null,0,0]

{"sheet":"Contractor SDM","index":9,"n_rows":106,"n_cols":22,"rows_kept":106,"hidden":true,"merged":[[0,0,0,7],[0,8,0,9],[0,12,0,19],[0,20,0,21],[1,0,1,9],[3,3,3,7],[3,13,3,14],[3,19,3,20],[12,2,12,4],[14,15,14,18],[20,13,20,17],[21,14,21,17],[24,13,24,17],[25,2,25,4],[25,14,25,17],[26,1,26,4],[27,1,27,4],[27,5,27,7],[28,2,28,4],[29,2,29,4],[29,13,29,17],[30,1,30,4],[30,14,30,17],[31,1,31,4],[33,13,33,17],[34,14,34,17],[37,13,37,17],[38,14,38,17],[40,6,40,9],[41,6,41,7],[41,13,41,17],[42,14,42,17],[46,12,46,14],[47,12,47,14],[48,12,48,14],[49,12,49,14],[50,12,50,14],[51,12,51,14],[52,12,52,14],[53,12,53,14],[54,5,54,7],[54,12,54,14],[55,2,55,9],[55,12,55,14],[61,6,61,8],[70,12,70,20],[71,0,71,1],[71,7,71,8],[73,0,73,1],[74,0,74,1],[74,4,74,5],[75,0,75,1],[75,4,75,5],[76,0,76,1],[76,4,76,5],[77,0,77,1],[78,0,78,1]],"flags":["formulas_cached_only"]}
["                                                     SEKHUKHUNE DISTRICT MUNICIPALITY",{"$nulls":7},"REF 5 (Created 2007)",{"$nulls":3},"                                       GREATER SEKHUKHUNE DISTRICT MUNICIPALITY"]
["CONTRACTOR PAYMENT CERTIFICATE",{"$nulls":11},"                         SUMMARY OF CESSION PAYMENTS ON CERTIFICATE"]
[]
["PROJECT   DESCRIPTION       :",null,null,"EPHRAIM MOGALE LM RURAL HOUSEHOLD SANITATION PROJECT PHASE II",{"$nulls":4},"Project No:"," SK/8/3/1-11/2015/16",null,null,"GSDM No. :"," SK/8/3/1-11/2015/16",null,"CERT. No. :",1,null,"CONTRACTOR :",0]
[]
["1.   I hereby certify that the project have been inspected and that the",{"$nulls":4},"3. I have inspected this claim and I am satisfied that payment as indicated"]
["work has been executed satisfactorily and according to specification",{"$nulls":4},"can be made.",{"$nulls":7},"VALUE OF PRESENT CLAIM------------------ \"subtotal    A\"",{"$nulls":6},{"$error":"#REF!"}]
["and that the quantities and prices shown are correct.",{"$nulls":13},"    PLUS               ------------------- retention payout",{"$nulls":5},0]
[{"$nulls":14},"    LESS               ------------------- all cessions",{"$nulls":4},"[F]",{"$error":"#REF!"}]
["02nd December 2015",null,"........................................................",null,null,"        ………………..                                  ",null,".........................................................",{"$nulls":12},{"$error":"#REF!"},"A"]
["             Date ",null,"                       Engineer",null,null,"               Date                ",null,"     On behalf of Municipality",{"$nulls":11},"VAT @ 14 %",{"$error":"#REF!"}]
[{"$nulls":19},"TOTAL",{"$error":"#REF!"}]
["            Name:             ",null,"VALERIE MAMPANE",null,null,"                   Name:",null,"........................................................."]
[{"$nulls":13},"RETENTION MONEY on this certificate TO RETENTION ACCOUNT !!!",{"$nulls":6},{"$error":"#REF!"},"B"]
["Capacity    :",null,"..........................................",null,null,"            Capacity:                            ",null,".........................................................",{"$nulls":5},"Account reference No.    :",{"$nulls":5},"VAT 14 %",{"$error":"#REF!"}]
["2. I have inspected this claim and I am satisfied that payment as ",{"$nulls":4},"4.   I certify that the above-mentioned work has executed satisfactorily  ",{"$nulls":13},"TOTAL",{"$error":"#REF!"}]
["indicated can be made.",{"$nulls":4},"and that the work to the value of the amount has been performed"]
["incl"]
["        ………………..                                  ",null,"........................................................",{"$nulls":10},"CESSION PAYMENTS INCLUDED IN THIS CERTIFICATE",{"$nulls":4},"SUPPLIER",null,"AMOUNT"]
["             Date                    ",null,"Project Manager.",null,null,"        ………………..              ",null,".........................................................",{"$nulls":10},"SIGNATURE"]
[{"$nulls":5},"               Date                            ",null,"On behalf of Implementing agent",{"$nulls":4},"1]",{"$nulls":8},"C"]
["           Name:                                     ",null,"........................................................",{"$nulls":10},"VAT cert. no",{"$nulls":5},"VAT 14 %",{"v":0,"d":"0.00"}]
[{"$nulls":5},"               Name: ",null,"......................................................",{"$nulls":11},"TOTAL",{"v":0,"d":"0.00"}]
["Designation:                        ",null,"........................................................"]
["ok",{"$nulls":6},"VAT incl / excl  ?","incl",{"$nulls":3},"2]",{"$nulls":8},"D"]
["G.S.D.M.","CONTRACTOR :",{"$nulls":3},"Contract amount as awarded     ",null,"R",{"v":1813454.5,"d":"1,813,454.50"},"vat excl",{"$nulls":3},"VAT cert. no",{"$nulls":5},"VAT 14 %",{"v":0,"d":"0.00"}]
["No.",{"$nulls":4},"Additional expenditure authorized",null,"R",null,"vat excl",{"$nulls":9},"TOTAL",{"v":0,"d":"0.00"}]
[" SK/8/3/1-11/2015/16","ZERBACRAFT JV LANCE MANAGEMENT",{"$nulls":7},"vat excl"]
["`","VAT No",4700266788]
["FUND","ADDRESS :","60A RAILWAY STREET",{"$nulls":3},"sub total","R",{"v":1813454.5,"d":"1813454.50"},{"$nulls":3},"3]"]
["REF. no,","LADANNA, POLOKWANE",{"$nulls":4},"VAT","R",{"v":253883.63000000003,"d":"253883.63"},{"$nulls":4},"VAT cert. no",{"$nulls":5},"VAT 14 %",{"v":0,"d":"0.00"}]
[null,"0699",{"$nulls":3},"TOTAL  APPROVED  AMOUNT",null,"R",{"v":2067338.1300000001,"d":"2067338.13"},{"$nulls":10},"TOTAL",{"v":0,"d":"0.00"}]
[{"$nulls":6},"TEL  :",null,"FAX :"]
["SUMMARY  OF  PREVIOUS  CLAIMS (A)",{"$nulls":11},"4]"]
["Certificate No.","Date","Amount              (VAT excl)","Certificate No.","Date","Amount              (VAT excl)","Certificate No.","Date","Amount               (vat excl)",{"$nulls":4},"VAT cert. no",{"$nulls":5},"VAT 14 %",{"v":0,"d":"0.00"}]
[1,"01/012/2016",{"v":312125,"d":"312125.00"},5,null,null,9,null,null,"total",{"$nulls":9},"TOTAL",{"v":0,"d":"0.00"}]
[2,null,null,6,null,null,10,null,null,"of"]
[3,null,null,7,null,null,11,null,null,"\"amount\"",null,null,"5]",{"$nulls":8},"G"]
[4,null,null,8,null,null,12,null,null,{"v":312125,"d":"312125.00"},{"$nulls":3},"VAT cert. no",{"$nulls":5},"VAT 14 %",{"v":0,"d":"0.00"}]
[{"$nulls":19},"TOTAL",{"v":0,"d":"0.00"}]
["THIS  CERTIFICATE  No.      :",null,null,1,"is this a cert. of completion","no","CHECK CERT NO"]
["PARTICULARS OF PRESENT CLAIM ",{"$nulls":3},"12 mth retention","No",null,null,"CONTRACT AMOUNTS",{"$nulls":3},"6]"]
["TO  CONTRACTOR  FOR  WORK  DONE  UP  TO   DATE      :",{"$nulls":4},"02nd December 2015",null,null,"R",{"$nulls":4},"VAT cert. no",{"$nulls":5},"VAT 14 %",{"v":0,"d":"0.00"}]
[null,"Value of all work done [including cession payments] up to date",{"$nulls":5},"[VAT excl.]",{"$error":"#REF!"},";",{"$nulls":9},"TOTAL",{"v":0,"d":"0.00"}]
[null,"Value of all Nominated sub contractors work up to date",{"$nulls":5},"[VAT excl.]",{"$nulls":4},"LIST OF ALL CESSION HOLDERS ON PROJECT"]
[null,"Escalation of cost up to date",{"$nulls":5},"[VAT excl.]",{"$nulls":5},"SUPPLIERS",null,"VALUE","SIGNATURE",null," PAYMENT TO","[ A ]",{"$error":"#REF!"}]
[{"$nulls":7},"SUBTOTAL",{"$error":"#REF!"},{"$error":"#REF!"},null,1,{"$nulls":6},"CONTRACTOR","VAT @ 14%",{"$error":"#REF!"}]
[null,"        Less Any Penalties that may be applicable",{"$nulls":7},{"$error":"#REF!"},null,2,{"$nulls":7},"TOTAL",{"$error":"#REF!"}]
[null,"        Less all previous payments [VAT excl] made up to certificate no.",{"$nulls":5},0,{"v":312125,"d":"312,125.00"},null,null,3]
[{"$nulls":7},"SUBTOTAL",{"$error":"#REF!"},null,null,4,{"$nulls":6},"TOTAL OF","[ B ]",{"$error":"#REF!"},"I"]
[{"$nulls":11},5,{"$nulls":6},"RETENTION","VAT @ 14%",{"$error":"#REF!"}]
[null,"        Plus materials on site @ 80 % of  invoiced payments",{"$nulls":5},"[VAT excl.]",{"$nulls":3},6,{"$nulls":7},"TOTAL",{"$error":"#REF!"}]
[{"$nulls":7},"SUBTOTAL",{"$error":"#REF!"},"(A)",null,7]
[{"$nulls":7},"VAT  14 %",{"$error":"#REF!"},null,null,8,{"$nulls":7},"[ C+D+E+F+G+H ]",0]
[{"$nulls":5},"              TOTAL OF PRESENT CLAIM",null,null,{"$error":"#REF!"},"ok",null,9,{"$nulls":6},"TOTAL OF","VAT @ 14%",0]
["AMOUNT IN WORDS :",{"$nulls":10},10,{"$nulls":6},"CESSIONS","TOTAL",0]
[]
[]
["CATEGORY",4,"SUMMARY OF PREVIOUS RETENTION & SURITY RETAINED",{"$nulls":3},"total value of retention",null,{"$error":"#REF!"},"total in ret.",{"$nulls":7},"TOTAL                          [ VAT incl ]",null,null,{"$error":"#REF!"}]
["surety limit %",10,"Certificate no","Amount","Certificate no","Amount","previous retention held",null,{"v":31212.5,"d":"31,212.50"},"account"]
["surity bond","PPCXZXZCVVVVVVVVVVVVVVVVVVVVVVV                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            V C ",1,{"v":31212.5,"d":"31212.50"},7,null,"retention on this certificate",null,{"$error":"#REF!"},{"$error":"#REF!"}]
["cash","NO",2,null,8,null,"                         retention to be paid out",null,null,"to be paid"]
["reten. limit  %",10,3,null,9,null,"on completion certificate       %",null,{"v":0,"d":"0.0"},"from ret.",null,null,"       signed by engineer",{"$nulls":4},"      signed by contractor"]
["contr.  bond","Yes",4,null,10,null,"on retention certificate         %",null,{"v":0,"d":"0.0"},"account"]
["maint.  bond","Yes",5,null,11,null,0,"o"," "]
["total reten.","%",6,null,12,null,"          PAYMENT TO CONTRACTOR   :",null,null,{"$error":"#REF!"}]
["& cash to ",{"v":10,"d":"10.0"}," ","   total previous retention",null,{"v":31212.5,"d":"31212.50"},"RETENTION TO RETENTION ACCOUNT.  :",null,null,{"$error":"#REF!"},null,null,"date",{"$nulls":4},"date"]
[1.14,{"v":0,"d":"0.0"}," "," ","…………….",null,"ALL SESSION PAYMENTS :",null,null,0]
[{"$nulls":6},"                     ( details on sheet  B3 )",null,null,{"$error":"#REF!"}]
[]
[{"$nulls":12},"FOR OFFICIAL USE ONLY"]
[{"$nulls":7},"Balance of Retention with SDM",null,{"$error":"#REF!"},null,"PROJECT MANAGER",{"$nulls":3},"SIGNATURE",{"$nulls":3},"DATE"]
[]
[]
["Surity with SDM",null,{"$error":"#REF!"},"Release",{"v":0,"d":"R 0.00"},{"$nulls":6},"____________________________",{"$nulls":3},"________________________________",{"$nulls":3},"__________________________"]
["Retention with SDM",null,{"$error":"#REF!"},"Realease 50%",{"v":0,"d":"R 0.00"},{"$nulls":6},"QUANTITY SURVEYOR",{"$nulls":3},"SIGNATURE",{"$nulls":3},"DATE"]
["TOTAL",null,{"$error":"#REF!"},null,{"v":0,"d":"R 0.00"}]
[]
[{"$nulls":11},"____________________________",{"$nulls":3},"________________________________",{"$nulls":3},"__________________________"]
[{"$nulls":11},"ACCOUTANT",{"$nulls":3},"SIGNATURE",{"$nulls":3},"DATE"]
[]
[{"$nulls":11},"___________________________",{"$nulls":3},"_______________________________",{"$nulls":3},"__________________________"]
["Ret in ret account",null,null,"Surity",null,"Retention"]
[]
[{"$error":"#REF!"},null,null,{"$error":"#REF!"},null,{"$error":"#REF!"}]
[]
[]
["Competion cert"]
[]
["Pay out of ret",null,null,"Pay out",null,"Balance",null,"!2 month ret pay out"]
[]
[{"$error":"#REF!"},"Surity",null,0,null,{"$error":"#REF!"}]
[{"$error":"#REF!"},"Ret",5,0,null,{"$error":"#REF!"},null,0]
[{"$error":"#REF!"},null,null,{"v":0,"d":"0.00"},null,{"$error":"#REF!"}]
[]
["12 mth retention"]
[]
[{"$error":"#REF!"}]
[]
[]
[1,1,5,0,9,0]
[2,0,6,0,10,0]
[3,0,7,0,11,0]
[4,0,8,0,12,0]
[]
[{"$nulls":6},1,-1]

{"sheet":"SDM Cert ","index":10,"n_rows":109,"n_cols":24,"rows_kept":109,"hidden":true,"merged":[[6,5,7,9],[6,21,7,23],[29,4,29,6],[34,15,34,19],[59,2,59,11],[61,14,61,16],[84,14,84,22],[102,3,102,4],[104,3,104,4],[105,3,105,4],[106,3,106,4],[107,3,107,4],[108,3,108,4],[109,3,109,4]],"flags":["formulas_cached_only"]}
[]
[]
[]
[null,null,"                                    SEKHUKHUNE DISTRICT MUNICIPALITY                                  B 1",{"$nulls":11},"                                 SEKHUKHUNE  DISTRICT MUNICIPALITY                          B 3"]
[null,null,"CONTRACT PAYMENT COVER SHEET",{"$nulls":11},"                         SUMMARY OF CESSION PAYMENTS ON CERTIFICATE"]
[]
[null,null,"PROJECT   DESCRIPTION       :",null,null,"MAKHUDUTHAMAGA LM RURAL HOUSEHOLD SANITATION PROJECT PHASE 2.1 CLUSTER 1 SK/8/3/1-05/2016/17",{"$nulls":4},"            (computer based)",{"$nulls":3},"CDM No. :","SK8/3/1-11/2015/2016",null,"CERT. No. :",2,null,"CONTRACTOR :","Zerbacraft JV Lance Management Services"]
[]
[]
[null,null,"1.   I hereby certify that the project has been inspected and that the",{"$nulls":4},"3. I have inspected this claim and I am satisfied that payment as indicated",{"$nulls":7},"VALUE OF PRESENT CLAIM------------------ \"subtotal    A\"",{"$nulls":6},{"$error":"#REF!"}]
[null,null,"work has been executed satisfactorily and according to specification",{"$nulls":4},"can be made.",{"$nulls":8},"    PLUS               ------------------- retention payout",{"$nulls":5},{"$error":"#REF!"}]
[null,null,"and that the quantities and prices shown are correct.",{"$nulls":13},"    LESS               ------------------- all cessions",{"$nulls":4},"[F]",{"$error":"#REF!"}]
[]
[null,null,"07-December 2016",null,"........................................................",null,null,"        ………………..                                  ",null,"........................................................."]
[null,null,"             Date ",null,"                       Engineer (Monchi Consulting)",null,null,"               Date                ",null,"     On behalf of Municipality"]
[]
[null,null,"            Name:             ",null,"……………………………………",null,null,"                   Name:",{"$nulls":14},{"$error":"#REF!"},"A"]
[{"$nulls":21},"VAT @ 14 %",{"$error":"#REF!"}]
[null,null,"Capacity    :",{"$nulls":4},"            Capacity:                            ",null,".........................................................",{"$nulls":11},"TOTAL",{"$error":"#REF!"}]
[null,null,"2. I have inspected this claim and I am satisfied that payment as ",{"$nulls":4},"4.   I certify that the above-mentioned work has executed satisfactorily  "]
[null,null,"indicated can be made.",{"$nulls":4},"and that the work to the value of the amount has been performed"]
[null,null,"incl"]
[null,null,"        ………………..                                  ",null,"........................................................",null,null,"        ………………..              ",null,".........................................................",{"$nulls":5},"RETENTION MONEY on this certificate TO RETENTION ACCOUNT !!!",{"$nulls":6},{"$error":"#REF!"},"B"]
[null,null,"             Date                    ",null,"On behalf of Steering Comm.",null,null,"               Date                            ",null,"On behalf of Implementing Agent"]
[{"$nulls":15},"Account reference No.    :",{"$nulls":5},"VAT 14 %",{"$error":"#REF!"}]
[null,null,"           Name:                                     ",null,"……………………………………..",null,null,"               Name: ",null,"......................................................",{"$nulls":11},"TOTAL",{"$error":"#REF!"}]
[]
[null,null,"Designation:                        ",null,"........................................................",null,null,"Capacity:                        ",null,"........................................................"]
[null,null,"ok",{"$nulls":6},"VAT incl / excl  ?","incl"]
[null,null,"C.D.M.","CONTRACTOR :","Zerbacraft JV Lance Management Services",null,null,"Contract amount as awarded     ",null,"R",{"v":3692582.3,"d":"3,692,582.30"},"vat excl"]
[null,null,"No.",{"$nulls":4},"Additional expenditure authorized",null,"R",null,"vat excl"]
[null,null,"SK8/3/1-11/2015/2016",{"$nulls":8},"vat excl",{"$nulls":3},"CESSION PAYMENTS INCLUDED IN THIS CERTIFICATE",{"$nulls":4},"SUPPLIER",null,"AMOUNT"]
[null,null,"FUND","ADDRESS :","60A Railway Street",{"$nulls":4},"R",{"v":3692582.3,"d":"3,692,582.30"}]
[null,null,"REF. no,",null,"Ladanna, Polokwane",{"$nulls":4},"R",{"v":516961.522,"d":"516,961.52"},{"$nulls":9},"SIGNATURE"]
[null,null,"SK8/3/1-11/2015/2016",null,1699,null,null,"TOTAL  APPROVED  AMOUNT",null,"R",{"v":4209543.822,"d":"4,209,543.82"},{"$nulls":3},"1]",{"$nulls":7},{"v":0,"d":"0.00"},"C"]
[{"$nulls":8},"TEL  :","011 601 5900","FAX :","011 615 4993"]
[null,null,"SUMMARY  OF  PREVIOUS  CLAIMS",{"$nulls":12},"VAT cert. no",{"$nulls":5},"VAT 14 %",{"v":0,"d":"0.00"}]
[null,null,"Certificate No.","Date","Amount              (VAT excl)","Certificate No.","Date","Amount              (VAT excl)","Certificate No.","Date","Amount               (vat excl)"]
[null,null,1,"19-12-2016",{"v":284295,"d":"284,295.00"},5,null,null,9,null,null,"total",{"$nulls":9},"TOTAL",{"v":0,"d":"0.00"}]
[null,null,2,null,0,6,null,null,10,null,null,"of"]
[null,null,3,null,0,7,null,null,11,null,null,"\"amount\"",null,null,"2]",{"$nulls":8},"D"]
[null,null,4,null,null,8,null,null,12,null,null,{"v":284295,"d":"284,295.00"},{"$nulls":3},"VAT cert. no",{"$nulls":5},"VAT 14 %",{"v":0,"d":"0.00"}]
[{"$nulls":21},"TOTAL",{"v":0,"d":"0.00"}]
[null,null,"THIS  CERTIFICATE  No.      :",null,null,2,"Is this a certificate of completion","NO"]
[null,null,"PARTICULARS OF PRESENT CLAIM ",{"$nulls":3},"12 mth retention","NO",null,null,"CONTRACT AMOUNTS",{"$nulls":3},"3]",{"$nulls":8},"E"]
[null,null,"TO  CONTRACTOR  FOR  WORK  DONE  UP  TO   DATE      :",{"$nulls":7},"R",{"$nulls":4},"VAT cert. no",{"$nulls":5},"VAT 14 %",{"v":0,"d":"0.00"}]
[{"$nulls":3},"Value of all work done [including cession payments] up to date",{"$nulls":5},"[VAT excl.]",{"$error":"#REF!"},{"$nulls":10},"TOTAL",{"v":0,"d":"0.00"}]
[{"$nulls":3},"Value of all Nominated sub contractors work up to date",{"$nulls":5},"[VAT excl.]"]
[{"$nulls":3},"Escalation of cost up to date",{"$nulls":5},"[VAT excl.]",{"$nulls":4},"4]",{"$nulls":8},"F"]
[{"$nulls":9},"SUBTOTAL",{"$error":"#REF!"},{"$error":"#REF!"},{"$nulls":3},"VAT cert. no",{"$nulls":5},"VAT 14 %",{"v":0,"d":"0.00"}]
[{"$nulls":3},"        Less Any Penalties that may be applicable",{"$nulls":7},{"$error":"#REF!"},{"$nulls":9},"TOTAL",{"v":0,"d":"0.00"}]
[{"$nulls":3},"        Less all previous payments [VAT excl] made up to certificate no.",{"$nulls":5},0,{"v":284295,"d":"284,295.00"}]
[{"$nulls":9},"SUBTOTAL",{"$error":"#REF!"},{"$nulls":3},"5]",{"$nulls":8},"G"]
[{"$nulls":15},"VAT cert. no",{"$nulls":5},"VAT 14 %",{"v":0,"d":"0.00"}]
[{"$nulls":3},"        Plus materials on site @ 80 % of  invoiced payments",{"$nulls":5},"[VAT excl.]",{"$nulls":11},"TOTAL",{"v":0,"d":"0.00"}]
[{"$nulls":9},"SUBTOTAL",{"$error":"#REF!"},"(A)"]
[{"$nulls":9},"VAT  14 %",{"$error":"#REF!"},{"$nulls":3},"6]",{"$nulls":8},"H"]
[{"$nulls":7},"              TOTAL OF PRESENT CLAIM",null,null,{"$error":"#REF!"},"ok",{"$nulls":3},"VAT cert. no",{"$nulls":5},"VAT 14 %",{"v":0,"d":"0.00"}]
[null,null,"AMOUNT IN WORDS :",{"$nulls":18},"TOTAL",{"v":0,"d":"0.00"}]
[null,null,"Five zero four six one five rands and thirty cents only",{"$nulls":11},"LIST OF ALL CESSION HOLDERS ON PROJECT"]
[{"$nulls":15},"SUPPLIERS",null,"VALUE","SIGNATURE",null," PAYMENT TO","[ A ]",{"$error":"#REF!"}]
[null,null,"CATEGORY",4,"SUMMARY OF PREVIOUS RETENTION & SURITY RETAINED",{"$nulls":3},"total value of retention",null,{"$error":"#REF!"},"total in ret.",null,1,"AMALOOLOO",null,null,{"v":0,"d":"0.00"},null,null,"CONTRACTOR","VAT @ 14%",{"$error":"#REF!"}]
[null,null,"surety limit %",10,"Certificate no","Amount              (VAT excl)","Certificate no","Amount","previous retention held",null,{"v":28429.5,"d":"28,429.50"},"account",null,2,{"$nulls":7},"TOTAL",{"$error":"#REF!"}]
[null,null,"surity bond","YES",1,{"v":28429.5,"d":"28,429.50"},7,null,"retention on this certificate",null,{"$error":"#REF!"},{"$error":"#REF!"},324096.3,3]
[null,null,"cash","YES",2,0,8,null,"                         retention to be paid out",null,null,"to be paid",null,4,{"$nulls":6},"TOTAL OF","[ B ]",{"$error":"#REF!"},"I"]
[null,null,"reten. limit  %",10,3,0,9,null,"on completion certificate       %",null,0,"from ret.",null,5,{"$nulls":6},"RETENTION","VAT @ 14%",{"$error":"#REF!"}]
[null,null,"contr.  bond","NO",4,0,10,null,"on retention certificate         %",null,0,"account",null,6,{"$nulls":7},"TOTAL",{"$error":"#REF!"}]
[null,null,"maint.  bond","NO",5,0,11,null,0,"O"," ",{"$error":"#REF!"},null,7]
[null,null,"total reten.","%",6,0,12,null,"          PAYMENT TO CONTRACTOR   :",null,null,{"$error":"#REF!"},null,8,{"$nulls":7},"[ C+D+E+F+G+H ]",{"v":0,"d":"0.00"}]
[null,null,"& cash to ",{"v":10,"d":"10.0"}," ","   total previous retention",null,{"v":28429.5,"d":"28429.50"},"RETENTION TO RETENTION ACCOUNT.  :",null,null,{"$error":"#REF!"},null,9,{"$nulls":6},"TOTAL OF","VAT @ 14%",{"v":0,"d":"0.00"}]
[null,null,1.14,{"v":0,"d":"0.0"}," "," ","…………….",null,"ALL SESSION PAYMENTS :",null,null,{"v":0,"d":"0.00"},null,10,{"$nulls":6},"CESSIONS","TOTAL",{"v":0,"d":"0.00"}]
[{"$nulls":8},"                     ( details on sheet  B3 )",null,null,{"$error":"#REF!"}]
[]
[{"$nulls":19},"TOTAL                          [ VAT incl ]",null,null,{"$error":"#REF!"}]
[]
[]
[]
[{"$nulls":14},"       signed by Engineer",{"$nulls":4},"      signed by Contractor"]
[]
[]
[{"$nulls":14},"           name in print",{"$nulls":4},"           name in print"]
[]
[]
[{"$nulls":14},"date",{"$nulls":4},"date"]
[{"$nulls":14},"For official use only"]
[{"$nulls":14},"PROJECT MANAGER",null,null,"SIGNATURE",{"$nulls":3},"DATE"]
[]
[{"$nulls":14},"Mokwadi P Mogano"]
[{"$nulls":14},"QUANTITY SURVEYOR"]
[]
[{"$nulls":14},"Titus Maroga"]
[{"$nulls":14},"ACCOUNTANT"]
[]
[{"$nulls":14},"Matlala Mathung",null,null,"_______________________________________",{"$nulls":3},"____________________________"]
{"$rows_empty":7}
[{"$nulls":3},"OFFICIAL USE ONLY"]
[{"$nulls":3},"PROJECT MANAGER",{"$nulls":4},"SIGNATURE",null,null,"DATE"]
[]
[]
[{"$nulls":3},"QUANTITY SURVEYOR",{"$nulls":4},"SIGNATURE",null,null,"DATE"]
[]
[]
[{"$nulls":3},"ACCOUNTANT",{"$nulls":4},"SIGNATURE",null,null,"DATE"]

{"sheet":"Rep Sum ","index":11,"n_rows":50,"n_cols":20,"rows_kept":50,"hidden":true,"flags":["formulas_cached_only"]}
["Re"]
[null,"SDM",null,null,"FUNDED","Division","PROJECT REPORT FORM  -  IMPLEMENTED BY SDM"]
[null,"FUND","MIG",null,"MIG",{"v":4209543.822,"d":"4,209,544"},"NB !!  Fill in funding sources !!!"]
[]
[{"$nulls":4},"VAT",{"v":516961.5220000001,"d":"516,961.52"}]
[null,null,"MUNICIPALITY","Project Tittle",null,"Incl",".=VAT","< < < < < PLEASE INDICATE VAT   incl   OR   excl   IN THE AREA PROVIDED THEREFOR",{"$nulls":7},"DATE  :","2016-05-03","2023-09-05"]
[null,1.14,"SEKHUKHUNE DISTRICT MUNICIPALITY","CAPRICORN HOUSEHOLD SANITATION PROJECT ","Project approved R","Counter funding R","Consul tant Appoint ment","Design period estimate weeks","extended Design time approved","Estimate construc tion    period","Estimate project completion","Tender Advert              ","Contract start - site hand over","Construc tion period","Extention of time approved","Contractual comple  tion","Actual comple tion achived","Contract progress time                % ","Project progress time                % "," Project progress cost            %"]
[{"$nulls":6},"date",10,"weeks","weeks","date","date","date","weeks","days","date","date"]
[null,"CAT.","surity bond !!!","CONTRACT DETAILS",null,0,"2015-06-26","2015-09-04",0,20,null,"?","30/11/2015",20,0,"13/04/2016","?",{"v":20,"d":"20.0"},{"v":19,"d":"19.0"},{"v":0,"d":"0.0"}]
[null,"4A","CONTRACT","certificate date","2016-05-03"]
[null,"award",{"v":3692582.3,"d":"3,692,582.30"},"certificate no.",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16]
[null,"VAT",{"v":516961.522,"d":"516,961.52"},"work done",{"$error":"#REF!"}]
[null,"contr.",{"v":4209543.822,"d":"4,209,543.82"},"escalation"]
[null,{"v":0,"d":"0.0"},"SURETY","variation orders"]
[null,"yes","BOND","sub total",{"$error":"#REF!"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,0,"CASH","less penalties"]
[null,null,"INSURANCE","less previous payments",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,10,"RETENTION","plus additionals"]
[null,10,"LIMIT [ % ]10","plus  80% materials on site"]
[{"$nulls":3},"Sub total  A",{"$error":"#REF!"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":3},"ret +surity",{"$error":"#REF!"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":3},"conrtactor",{"$error":"#REF!"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"no","BOND [10%]","direct payments"]
[null,"no","bond     [5%]","plus retention pay out",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"ret acc",{"$error":"#REF!"},"sub total",{"$error":"#REF!"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"paid out",{"v":0,"d":"0.00"},"14% VAT",{"$error":"#REF!"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"bal",{"$error":"#REF!"},"Amount to Contractor",{"$error":"#REF!"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":3},"to retention account",{"$error":"#REF!"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Within Budget",null,"ENGINEERING DETAILS",{"$error":"#REF!"},null,"fees ok!",null,{"$error":"#REF!"}]
[null,null,"APPOINT","certificate date"]
[null,"award",{"v":0,"d":"0.00"},"certificate no.",{"$nulls":3},4,5,6,7,8,9,10,11,12,13,14,15,16]
[null,"VAT",{"v":0,"d":"0.00"},"fees"]
[null,"consul",{"v":0,"d":"0.00"},"disbursements"]
[null,null,"INDEMNITY","specialist services"]
[null,"yes","PROOF","less previous payments",{"$nulls":3},0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":3},"sub total",{"$nulls":3},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"RETENTION ACCOUNT",null,"Less 5 % retention",{"$nulls":3},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"ret acc",{"v":0,"d":"0.00"},{"$nulls":4},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"paid out",{"v":0,"d":"0.00"},"Retention pay out",{"$nulls":3},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"bal",{"v":0,"d":"0.00"},"14 % VAT",{"$nulls":3},0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":3},"Amount to Engineer",{"$nulls":3},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"project financial details [vat incl]                     dates"]
[null,"paid",{"$error":"#REF!"},"contract cost    :     estimate","Within Budget"]
[null,"bal.",{"$error":"#REF!"},{"$error":"#REF!"},"e c"]
[null,"paid",{"v":0,"d":"0.00"},"engineering fees  :  estimate",null,"                  Paid   out per fund [ VAT incl ]",null,null,"Cession holder","Value","Payed","Cession holder","Value","Payed","Cession holder","Value","Payed","Cession holder","Value","Payed"]
[null,"bal,",{"v":0,"d":"0.00"},"ok !","MIG",{"v":0,"d":"0.00"},"limit  =",0]
[null,"app.",{"v":0,"d":"0.00"},"project cost     :       estimate",0,{"v":0,"d":"0.00"},"limit  =",0]
[null,"paid",{"$error":"#REF!"},{"$error":"#REF!"},"VAT",{"v":0,"d":"0.00"},"limit  =",0]
[{"$nulls":3},"cash flow @ B/P stage from month starting with","Nov","Dec","Jan"]
[{"$nulls":3},"cash flow @ contract stage from month starting with","Start Month"]

{"sheet":"IA ","index":12,"n_rows":96,"n_cols":11,"rows_kept":96,"hidden":true,"merged":[[0,0,0,10],[2,0,2,10],[4,1,4,2],[4,6,4,10],[5,6,5,10],[10,0,10,1],[10,2,10,3],[32,5,32,6],[35,5,35,6],[37,7,37,8],[47,7,47,8],[74,0,74,10],[79,2,79,3],[79,4,79,5],[79,7,79,8],[80,2,80,3],[80,4,80,5],[80,7,80,8],[81,2,81,3],[81,4,81,5],[81,7,81,8],[82,2,82,3],[82,4,82,5],[82,7,82,8],[83,2,83,3],[83,4,83,5],[83,7,83,8],[84,2,84,3],[84,4,84,5],[84,7,84,8],[85,2,85,3],[85,7,85,8],[86,2,86,3],[86,4,86,5],[86,7,86,8],[87,2,87,3],[87,7,87,8],[88,2,88,3],[88,7,88,8],[89,2,89,3],[89,7,89,8],[90,2,90,3],[90,7,90,8],[91,2,91,3],[91,7,91,8],[92,2,92,3],[92,7,92,8],[93,2,93,3],[93,7,93,8],[94,2,94,3],[94,7,94,8],[95,0,95,1],[95,4,95,5],[95,7,95,8]],"flags":["formulas_cached_only"]}
["SEKHUKHUNE DISTRICT MUNICIPALITY IMPLEMENTING  AGENT"]
[]
["MIG PROJECT  PROGRESS PAYMENT CERTIFICATE"]
[]
["     BID No:  ","INF-W16/2023/2024",null,"     PROJECT   NAME :",null,null,"MAKHUDUTHAMAGA LM RURAL HOUSEHOLD SANITATION PROJECT PHASE 2.1_Cluster 1"]
["         "]
["1.   CERTIFICATION BY ENGINEER:"]
["      I hereby certify that the project have been inspected and that the work has been executed satisfactorily and according to"]
["      specification and that the quantities and prices shown are correct."]
[]
["07-December 2016",null,"Monchi Consulting Engineers",{"$nulls":3},"…………………………………………………………",null,null,"........................................................"]
["             Date ",null,"Name of Firm",{"$nulls":3},"Name of Engineer",null,null,"Signature"]
["2. CERTIFICATION BY PMU:"]
["    I certify that the work has been performed and that payment can be made."]
[]
["        ………………..                       ",null,"........................................................",{"$nulls":3},"........................................................",null,null,"........................................................"]
["             Date ",null,"Position",{"$nulls":3},"Name",null,null,"Signature"]
["3. CERTIFICATION BY IMPLEMENTING AGENT:"]
["    3.1     I certify that the work has been executed satisfactorily and that work to the value has been performed."]
[]
["        ………………..                       ",{"$nulls":5},"........................................................",null,null,"........................................................"]
["             Date ",{"$nulls":5},"Name",null,null,"IA MIG Manager"]
[]
["    3.2    I certify that I have inspected this claim and I am satisfied that payment as indicated can be made."]
[]
["        ………………..                       ",{"$nulls":5},"........................................................",null,null,"........................................................"]
["             Date ",{"$nulls":5},"Name",null,null,"IA Technical Manager"]
[]
["    3.3    I hereby certify that requested payment satisfy all conditions of IA and MIG"]
[]
["        ………………..                       ",{"$nulls":5},"........................................................",null,null,"........................................................"]
["        Date ",{"$nulls":5},"Name",null,null,"Implementing Agent Manager"]
[]
[]
[]
["THIS  CERTIFICATE  No.      :",null,null,5,null,"Is this a cert. of completion?",null,"no",null,"APPROVED MIG VALUE","MIG     BALANCE"]
[{"$nulls":9},{"v":4209543.822,"d":"R 4,209,543.82"}]
["MIG 6","PARTICULARS OF MANAGEMENT FEE CLAIM",{"$nulls":4},"Date","07-December 2016",null,"."]
[{"$nulls":3},"Yes or No"]
["KPI's","Is an EIA necessary?",null,"No",null,"Max. Management fee @ 14% [VAT incl.] =",null,{"v":0,"d":"0.00"}]
[null,"Is the EIA approved?",null,"No",null,"Management fee not claimed yet",null,{"v":0,"d":"0.00"}]
[null,"Was the design report submitted?",null,"Yes",{"$nulls":5}," "]
[null,"Was the design report approved?",null,"Yes",null,"Total Management fee claimed",{"$nulls":3},{"v":0,"d":"R 0.00"},{"v":4209543.822,"d":"R 4,209,543.82"}]
[null,"Is a technical report necessary?",null,"Yes",null,"Less: Management fee claimed previously:",{"$nulls":3},{"v":0,"d":"R 0.00"}]
[null,"Is the technical report approved?",null,"Yes",null,"MANAGEMENT FEE ON THIS CLAIM:",{"$nulls":3},{"v":0,"d":"R 0.00"},"(A)"]
[null,"Is the tender advertised?",null,"Yes"]
[]
["MIG 8","PARTICULARS OF CONSTRUCTION CLAIM",{"$nulls":4},"Date","18/03/2016",null,"AMOUNT CERTIFIED"]
[null,null,"Total value of all work done up to date",{"$nulls":4},"[VAT excl.]",null,{"$error":"#REF!"}]
[null,null,"Value of all Nominated sub contractors work up to date",{"$nulls":4},"[VAT excl.]",null,{"v":0,"d":"0.00"}]
[null,null,"Escalation of cost up to date",{"$nulls":4},"[VAT excl.]",null,{"v":0,"d":"0.00"}]
[null,null,"Less: Total Penalties recovered to date",{"$nulls":4},"[VAT excl.]",null,{"v":0,"d":"0.00"}]
[{"$nulls":7},"SUBTOTAL",null,{"$error":"#REF!"}]
[null,null,"Plus invoice values for materials on site (80%)",{"$nulls":4},"[VAT excl.]",null,{"v":0,"d":"0.00"}]
[{"$nulls":7},"SUBTOTAL",null,{"$error":"#REF!"}]
[{"$nulls":7},"VAT  14 %",null,{"$error":"#REF!"}]
[{"$nulls":7},"SUBTOTAL",null,{"$error":"#REF!"}]
[null,null,"Less: Value to be paid under Counter Funding",{"$nulls":4},"[VAT incl.]",null,{"$error":"#REF!"}]
[{"$nulls":5},"TOTAL MIG VALUE T0 DATE",{"$nulls":3},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$nulls":5},"LESS: TOTAL MIG VALUE PREVIOUSLY CERTIFIED",{"$nulls":3},{"v":0,"d":"0.00"}]
[{"$nulls":5},"TOTAL MIG VALUE FOR CONSTRUCTION",{"$nulls":3},{"$error":"#REF!"},"(B)"]
[{"$nulls":5},"TOTAL MIG VALUE FOR THIS CERTIFICATE",{"$nulls":3},{"$error":"#REF!"},"(A + B)"]
[]
[{"$nulls":3},"[VAT incl.]",null,"MANAGEMENT FEE",null,"[VAT incl.]",null,{"v":0,"d":"0.00"}]
["PREVIOUS RETENTION HELD",null,null,{"v":0,"d":"0.00"},null,"PAYMENT TO CONTRACTOR",null,"[VAT incl.]",null,{"$error":"#REF!"}]
["RETENTION ON THIS CERTIFICATE",null,null,{"$error":"#REF!"},null,"ALL SESSION PAYMENTS",null,"[VAT incl.]",null,{"v":0,"d":"0.00"}]
["TOTAL IN RETENTION ACCOUNT",null,null,{"$error":"#REF!"},null,"RETENTION ON THIS CERTIFICATE",null,"[VAT incl.]",null,{"$error":"#REF!"}]
[null,null,"RETENTION & SURETY (%)",{"v":0.1,"d":"10.00%"},null,"TOTAL MIG VALUE FOR THIS CERTIFICATE",null,"[VAT incl.]",null,{"$error":"#REF!"}]
[]
[]
[]
[]
[]
[]
["SEKHUKHUNE DISTRICT MUNICIPALITY IMPLEMENTING  AGENT"]
[]
["     MIG No:  CLP",null,"INF-W16/2023/2024","     PROJECT   NAME :",null,null,"MAKHUDUTHAMAGA LM RURAL HOUSEHOLD SANITATION PROJECT PHASE 2.1_Cluster 1"]
[]
[{"$nulls":3},"Summary of ACTUAL PAYMENTS made [VAT incl.]"]
["Payment no","Date","Name of Service Provider",null,"Payment to Consultant",null,"Payment to Contractor","Cession payments",null,"TOTAL AMOUNT CERTIFIED"]
[1,"2016-07-12","Zerbacraft JV Lance Management Serv",{"$nulls":3},{"v":454153.77,"d":"R 454,153.77"},null,null,{"v":454153.77,"d":"R 454,153.77"}]
[2,{"$nulls":8},{"v":0,"d":"R 0.00"}]
[3,{"$nulls":8},{"v":0,"d":"R 0.00"}]
[4,{"$nulls":8},{"v":0,"d":"R 0.00"}]
[5,{"$nulls":8},{"v":0,"d":"R 0.00"}]
[6,{"$nulls":8},{"v":0,"d":"R 0.00"}]
[7,{"$nulls":8},{"v":0,"d":"R 0.00"}]
[8,{"$nulls":8},{"v":0,"d":"R 0.00"}]
[9,{"$nulls":8},{"v":0,"d":"R 0.00"}]
[10,{"$nulls":8},{"v":0,"d":"R 0.00"}]
[11,{"$nulls":8},{"v":0,"d":"R 0.00"}]
[12,{"$nulls":8},{"v":0,"d":"R 0.00"}]
[13,{"$nulls":8},{"v":0,"d":"R 0.00"}]
[14,{"$nulls":8},{"v":0,"d":"R 0.00"}]
[15,{"$nulls":8},{"v":0,"d":"R 0.00"}]
["TOTAL",{"$nulls":3},{"v":0,"d":"R 0.00"},null,{"v":454153.77,"d":"R 454,153.77"},{"v":0,"d":"R 0.00"},null,{"v":454153.77,"d":"R 454,153.77"}]

{"sheet":"Invoice ","index":13,"n_rows":56,"n_cols":11,"rows_kept":56,"hidden":true,"merged":[[2,1,7,5],[8,1,8,10],[9,1,9,10],[10,2,10,5],[11,2,11,5],[12,2,12,6],[17,2,17,3],[23,1,23,10],[25,2,25,6],[26,2,26,6],[27,1,28,1],[27,2,28,6],[29,2,29,6],[30,2,30,6],[31,2,31,6],[32,2,32,6],[33,2,33,6],[34,2,34,6],[35,2,35,6],[36,2,36,6],[37,2,37,6],[38,2,38,6],[44,2,44,6],[45,2,45,6],[46,1,46,9],[47,1,47,9],[48,1,48,9],[49,1,49,10],[54,4,54,5]],"flags":["formulas_cached_only"]}
{"$rows_empty":10}
[null,"Date:","30/03/2017",{"$nulls":6},"Invoice No:","17/001"]
[]
[null,"To:","Sekhukhune District Municipality"]
[null,null,"P.Bag X8611"]
[null,null,"Groblersdaal"]
[null,null,"0470"]
[]
[null,"Your VAT No","4420195390"]
[]
[null,"Tel No:","013 262 7669"]
[null,"Fax No:","013 262 3688"]
[]
[null,"Attention:","Project Manager"]
[null,"TAX INVOICE"]
[]
[null,"ITEM","DESCRIPTION",{"$nulls":4},"UNIT","QTY","RATE","TOTAL"]
[]
[null,"01","Sekhukhune District Municipality: MAKHUDUTHAMAGA LM RURAL HOUSEHOLD  SANITATION PROJECT PHASE 2.1"]
[]
[null,null,"WORK DONE TO DATE",{"$nulls":4},"No",1,{"$error":"#REF!"},{"$error":"#REF!"}]
{"$rows_empty":9}
[null,"Regards "]
[]
[null,"Signed :  _______________________"]
[]
[null,"Date :     _______________________"]
[]
[]
[null,"Sub-total",{"$nulls":8},{"$error":"#REF!"}]
[null,"VAT @ 14%",{"$nulls":8},{"$error":"#REF!"}]
[null,"Total",{"$nulls":8},{"$error":"#REF!"}]
[]
[null,"BANKING DETAILS:-"]
[]
[null,"ACCOUNT HOLDER   :",null,null,"PEADOM INVESTMENT (Pty) Ltd"]
[null,"BANK",null,":","STANDARD BANK"]
[null,"ACCOUNT NO.",null,":",372491715]
[null,"BRANCH",null,":","MALL OF THE NORTH"]

{"sheet":"Statement ","index":14,"n_rows":39,"n_cols":12,"rows_kept":39,"hidden":true,"merged":[[2,1,7,5],[5,7,5,9],[10,2,10,5],[11,2,11,5],[12,2,12,6],[17,2,17,3],[23,1,23,9],[24,2,24,6],[25,2,25,6],[26,2,26,6],[27,2,27,6],[28,2,28,6],[29,2,29,6],[30,2,30,6],[31,2,31,6],[32,2,32,6],[33,2,33,6],[34,2,34,6],[35,2,35,6],[36,2,36,6],[37,2,37,6],[38,1,38,8]],"flags":["formulas_cached_only"]}
{"$rows_empty":8}
["                                                                      VAT Registration No.  4700266788"]
[]
[null,"Date:","30/03/2017"]
[]
[null,"To:","Sekhukhune District Municipality"]
[null,null,"P.Bag X8611"]
[null,null,"Groblersdaal"]
[null,null,"0470"]
[]
[null,"Your VAT No","4420195390"]
[]
[null,"Tel No:","013 262 7669"]
[null,"Fax No:","013 262 3688"]
[]
[null,"Attention:","Project Manager"]
[null,"STATEMENT CLUSTER 3"]
[null,"INVOICE DATE","INVOICE NUMBER",{"$nulls":4},"AMOUNT","PAYMENT RECEIVED","BALANCE"]
[]
[null,"2017-12-07",1,{"$nulls":4},{"v":264399.36,"d":"R 264,399.36"},{"v":264399.36,"d":"R 264,399.36"},{"v":0,"d":"R 0.00"}]
[null,"2017-01-30",2,{"$nulls":4},{"v":399976.68,"d":"R 399,976.68"},{"v":399976.68,"d":"R 399,976.68"},{"v":-264399.36,"d":"-R 264,399.36"}]
[null,"27/02/2017",3,{"$nulls":4},{"v":233466.61,"d":"R 233,466.61"},{"v":233466.61,"d":"R 233,466.61"},{"v":-664376.04,"d":"-R 664,376.04"}]
[null,"30/03/2017",4,{"$nulls":4},{"$error":"#REF!"},{"v":0,"d":"R 0.00"},{"v":-664376.04,"d":"-R 664,376.04"},null,0]
{"$rows_empty":8}
[null,"Outstanding Balance",{"$nulls":7},{"v":-664376.04,"d":"-R 664,376.04"}]

{"sheet":"SDM COVER","index":15,"n_rows":83,"n_cols":22,"rows_kept":83,"hidden":true,"merged":[[0,0,0,7],[0,8,0,9],[0,12,0,19],[0,20,0,21],[1,0,1,9],[3,3,4,7],[14,15,14,18],[20,13,20,17],[21,14,21,17],[24,13,24,17],[25,3,25,4],[25,14,25,17],[26,1,26,4],[27,1,27,4],[27,5,27,7],[28,2,28,4],[29,13,29,17],[30,1,30,4],[30,14,30,17],[31,1,31,4],[33,13,33,17],[34,14,34,17],[37,13,37,17],[38,14,38,17],[40,6,40,9],[41,6,41,7],[41,13,41,17],[42,6,42,7],[42,14,42,17],[46,12,46,14],[47,12,47,14],[48,12,48,14],[49,12,49,14],[50,12,50,14],[51,12,51,14],[52,12,52,14],[53,12,53,14],[54,12,54,14],[55,2,55,9],[55,12,55,14],[70,12,70,20],[71,0,71,1],[71,7,71,8],[73,0,73,1],[74,0,74,1],[74,4,74,5],[75,0,75,1],[75,4,75,5],[76,0,76,1],[76,4,76,5],[77,0,77,1],[78,0,78,1]],"flags":["formulas_cached_only"]}
["                                                     SEKHUKHUNE DISTRICT MUNICIPALITY",{"$nulls":7},"REF 5 (Created 2007)",{"$nulls":3},"                               SEKHUKHUNE DISTRICT MUNICIPALITY"]
["CONTRACTOR PAYMENT CERTIFICATE",{"$nulls":11},"                         SUMMARY OF CESSION PAYMENTS ON CERTIFICATE"]
[]
["PROJECT   DESCRIPTION       :",null,null,"MAKHUDUTHAMAGA LM RURAL HOUSEHOLD SANITATION PROJECT PHASE 2.1 CLUSTER 3 SK/8/3/1-05/2016/17",{"$nulls":4},"Project No:","SK/8/3/1-04/2016/17",null,null,"GSDM No. :","SK/8/3/1-04/2016/17",null,"CERT. No. :",4,null,"CONTRACTOR :",0]
[]
["1.   I hereby certify that the project have been inspected and that the",{"$nulls":4},"3. I have inspected this claim and I am satisfied that payment as indicated"]
["work has been executed satisfactorily and according to specification",{"$nulls":4},"can be made.",{"$nulls":7},"VALUE OF PRESENT CLAIM------------------ \"subtotal    A\"",{"$nulls":6},{"$error":"#REF!"}]
["and that the quantities and prices shown are correct.",{"$nulls":13},"    PLUS               ------------------- retention payout",{"$nulls":5},{"v":0,"d":"0.00"}]
[{"$nulls":14},"    LESS               ------------------- all cessions",{"$nulls":4},"[F]",{"$error":"#REF!"}]
["        ………………..                       ",null,"........................................................",null,null,"        ………………..                                  ",null,".........................................................",{"$nulls":12},{"$error":"#REF!"},"A"]
["             Date ",null,"                       Engineer",null,null,"               Date                ",null,"     On behalf of Municipality",{"$nulls":11},"VAT @ 14 %",{"$error":"#REF!"}]
[{"$nulls":19},"TOTAL",{"$error":"#REF!"}]
["            Name:             ",null,"..........................................",null,null,"                   Name:",null,"........................................................."]
[{"$nulls":13},"RETENTION MONEY on this certificate TO RETENTION ACCOUNT !!!",{"$nulls":6},{"$error":"#REF!"},"B"]
["Capacity    :",null,"..........................................",null,null,"            Capacity:                            ",null,".........................................................",{"$nulls":5},"Account reference No.    :",{"$nulls":5},"VAT 14 %",{"$error":"#REF!"}]
["2. I have inspected this claim and I am satisfied that payment as ",{"$nulls":4},"4.   I certify that the above-mentioned work has executed satisfactorily  ",{"$nulls":13},"TOTAL",{"$error":"#REF!"}]
["indicated can be made.",{"$nulls":4},"and that the work to the value of the amount has been performed"]
["incl"]
["        ………………..                                  ",null,"........................................................",{"$nulls":10},"CESSION PAYMENTS INCLUDED IN THIS CERTIFICATE",{"$nulls":4},"SUPPLIER",null,"AMOUNT"]
["             Date                    ",null,"Project Manager.",null,null,"        ………………..              ",null,".........................................................",{"$nulls":10},"SIGNATURE"]
[{"$nulls":5},"               Date                            ",null,"On behalf of Implementing agent",{"$nulls":4},"1]","Betrams (Amalooloo)",{"$nulls":6},{"v":560000,"d":"560000.00"},"C"]
["           Name:                                     ",null,"........................................................",{"$nulls":10},"VAT cert. no",{"$nulls":5},"VAT 14 %",{"v":78400.00000000001,"d":"78400.00"}]
[{"$nulls":5},"               Name: ",null,"......................................................",{"$nulls":11},"TOTAL",{"v":638400,"d":"638400.00"}]
["Designation:                        ",null,"........................................................"]
["ok",{"$nulls":6},"VAT incl / excl  ?","incl",{"$nulls":3},"2]",{"$nulls":8},"D"]
["S.D.M.","CONTRACTOR :",{"$nulls":3},"Contract amount as awarded     ",null,"R",{"v":1905158.75,"d":"1,905,158.75"},"vat excl",{"$nulls":3},"VAT cert. no",{"$nulls":5},"VAT 14 %",{"v":0,"d":"0.00"}]
["No.","Peadom Investment JV LMS",{"$nulls":3},"Additional expenditure authorized",null,"R",null,"vat excl",{"$nulls":9},"TOTAL",{"v":0,"d":"0.00"}]
["SK/8/3/1-04/2016/17",{"$nulls":8},"vat excl"]
["`","VAT No"]
["FUND","ADDRESS :","60A Railway Street",{"$nulls":3},"sub total","R",1905158.75,{"$nulls":3},"3]"]
["REF. no,","Ladanna, Polokwane",{"$nulls":4},"VAT","R",{"v":266722.22500000003,"d":"266722.23"},{"$nulls":4},"VAT cert. no",{"$nulls":5},"VAT 14 %",{"v":0,"d":"0.00"}]
[null,1699,{"$nulls":3},"TOTAL  APPROVED  AMOUNT",null,"R",{"v":2171880.975,"d":"2171880.98"},{"$nulls":10},"TOTAL",{"v":0,"d":"0.00"}]
[{"$nulls":6},"TEL  :",null,"FAX :"]
["SUMMARY  OF  PREVIOUS  CLAIMS (A)",{"$nulls":11},"4]"]
["Certificate No.","Date","Amount              (VAT excl)","Certificate No.","Date","Amount              (VAT excl)","Certificate No.","Date","Amount               (vat excl)",{"$nulls":4},"VAT cert. no",{"$nulls":5},"VAT 14 %",{"v":0,"d":"0.00"}]
[1,"19-12-2016",{"v":257700,"d":"R 257,700.00"},5,null,null,9,null,null,"total",{"$nulls":9},"TOTAL",{"v":0,"d":"0.00"}]
[2,"30/01/2017",{"v":389840,"d":"R 389,840.00"},6,null,null,10,null,null,"of"]
[3,"27/02/2017",{"v":227550.3,"d":"R 227,550.30"},7,null,null,11,null,null,"\"amount\"",null,null,"5]",{"$nulls":8},"G"]
[4,null,null,8,null,null,12,null,null,{"v":875090.3,"d":"875090.30"},{"$nulls":3},"VAT cert. no",{"$nulls":5},"VAT 14 %",{"v":0,"d":"0.00"}]
[{"$nulls":19},"TOTAL",{"v":0,"d":"0.00"}]
["THIS  CERTIFICATE  No.      :",null,null,4,"is this a cert. of completion","no"," "]
["PARTICULARS OF PRESENT CLAIM ",{"$nulls":3},"12 mth retention","No",null,null,"CONTRACT AMOUNTS",{"$nulls":3},"6]"]
["TO  CONTRACTOR  FOR  WORK  DONE  UP  TO   DATE      :",{"$nulls":4},"30/03/2017",null,null,"R",{"$nulls":4},"VAT cert. no",{"$nulls":5},"VAT 14 %",{"v":0,"d":"0.00"}]
[null,"Value of all work done [including cession payments] up to date",{"$nulls":5},"[VAT excl.]",{"$error":"#REF!"},{"$nulls":10},"TOTAL",{"v":0,"d":"0.00"}]
[null,"Value of all Nominated sub contractors work up to date",{"$nulls":5},"[VAT excl.]",{"$nulls":4},"LIST OF ALL CESSION HOLDERS ON PROJECT"]
[null,"Escalation of cost up to date",{"$nulls":5},"[VAT excl.]",{"$nulls":5},"SUPPLIERS",null,"VALUE","SIGNATURE",null," PAYMENT TO","[ A ]",{"$error":"#REF!"}]
[{"$nulls":7},"SUBTOTAL",{"$error":"#REF!"},"ok",null,1,"Betrams (Amalooloo)",null,null,{"v":638400,"d":"638,400.00"},null,null,"CONTRACTOR","VAT @ 14%",{"$error":"#REF!"}]
[null,"        Less Any Penalties that may be applicable",{"$nulls":7},{"$error":"#REF!"},null,2,{"$nulls":7},"TOTAL",{"$error":"#REF!"}]
[null,"        Less all previous payments [VAT excl] made up to certificate no.",{"$nulls":5},3,{"v":875090.3,"d":"875,090.30"},null,null,3]
[{"$nulls":7},"SUBTOTAL",{"$error":"#REF!"},null,null,4,{"$nulls":6},"TOTAL OF","[ B ]",{"$error":"#REF!"},"I"]
[{"$nulls":11},5,{"$nulls":6},"RETENTION","VAT @ 14%",{"$error":"#REF!"}]
[null,"        Plus materials on site @ 80 % of  invoiced payments",{"$nulls":5},"[VAT excl.]",{"$nulls":3},6,{"$nulls":7},"TOTAL",{"$error":"#REF!"}]
[{"$nulls":7},"SUBTOTAL",{"$error":"#REF!"},"(A)",null,7]
[{"$nulls":7},"VAT  14 %",{"$error":"#REF!"},null,null,8,{"$nulls":7},"[ C+D+E+F+G+H ]",{"v":560000,"d":"560000.00"}]
[{"$nulls":5},"              TOTAL OF PRESENT CLAIM",null,null,{"$error":"#REF!"},"ok",null,9,{"$nulls":6},"TOTAL OF","VAT @ 14%",{"v":78400.00000000001,"d":"78400.00"}]
["AMOUNT IN WORDS :",null,"NINE HUNDRED AND FORTY TWO THOUSANDS FOUR HUNDRED AND EIGHTY SEVEN RANDS EIGHTY FOUR CENTS",{"$nulls":8},10,{"$nulls":6},"CESSIONS","TOTAL",{"v":638400,"d":"638400.00"}]
["                                             "]
[]
["CATEGORY",4,"SUMMARY OF PREVIOUS RETENTION & SURITY RETAINED",{"$nulls":3},"total value of retention",null,{"$error":"#REF!"},"total in ret.",{"$nulls":7},"TOTAL                          [ VAT incl ]",null,null,"300727.96"]
["surety limit %",10,"Certificate no","Amount","Certificate no","Amount","previous retention held",null,87509.03,"account"]
["surity bond","PPCXZXZCVVVVVVVVVVVVVVVVVVVVVVV                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            V C ",1,{"v":25770,"d":"25770.00"},7,null,"retention on this certificate",null,{"$error":"#REF!"},{"$error":"#REF!"}]
["cash","no",2,{"v":38984,"d":"38984.00"},8,null,"                         retention to be paid out",null,null,"to be paid"]
["reten. limit  %",10,3,22755.03,9,null,"on completion certificate       %",null,{"v":0,"d":"0.0"},"from ret.",null,null,"       signed by engineer",{"$nulls":4},"      signed by contractor"]
["contr.  bond","No",4,null,10,null,"on retention certificate         %",null,{"v":0,"d":"0.0"},"account"]
["maint.  bond","no",5,null,11,null,0,"o"," "]
["total reten.","%",6,null,12,null,"          PAYMENT TO CONTRACTOR   :",null,null,{"$error":"#REF!"}]
["& cash to ",{"v":10,"d":"10.0"}," ","   total previous retention",null,87509.03,"RETENTION TO RETENTION ACCOUNT.  :",null,null,{"$error":"#REF!"},null,null,"date",{"$nulls":4},"date"]
[1.14,{"v":3.3333333333333335,"d":"3.3"}," "," ","…………….",null,"ALL SESSION PAYMENTS :",null,null,{"v":638400,"d":"638,400.00"}]
[{"$nulls":6},"                     ( details on sheet  B3 )",null,null,{"$error":"#REF!"}]
[]
[{"$nulls":12},"FOR OFFICIAL USE ONLY"]
[{"$nulls":7},"Balance of Retention with GSDM",null,{"$error":"#REF!"},null,"PROJECT MANAGER",{"$nulls":3},"SIGNATURE",{"$nulls":3},"DATE"]
[]
[]
["Surity with GSDM",null,{"v":0,"d":"R 0.00"},"Release",{"v":0,"d":"R 0.00"},{"$nulls":6},"____________________________",{"$nulls":3},"________________________________",{"$nulls":3},"__________________________"]
["Retention with GSDM",null,{"$error":"#REF!"},"Realease 50%",{"v":0,"d":"R 0.00"},{"$nulls":6},"QUANTITY SURVEYOR",{"$nulls":3},"SIGNATURE",{"$nulls":3},"DATE"]
["TOTAL",null,{"$error":"#REF!"},null,{"v":0,"d":"R 0.00"}]
[]
[{"$nulls":11},"____________________________",{"$nulls":3},"________________________________",{"$nulls":3},"__________________________"]
[{"$nulls":11},"ACCOUTANT",{"$nulls":3},"SIGNATURE",{"$nulls":3},"DATE"]
[]
[{"$nulls":11},"___________________________",{"$nulls":3},"_______________________________",{"$nulls":3},"__________________________"]
["Ret in ret account",null,null,"Surity",null,"Retention"]

{"sheet":"RECON CESSION","index":16,"n_rows":39,"n_cols":8,"rows_kept":39,"hidden":true,"merged":[[7,4,7,5],[8,4,8,5],[9,4,9,5],[12,1,13,4],[16,0,16,1],[16,3,16,5],[17,3,17,5],[18,3,18,5],[23,4,23,5],[24,0,24,5],[26,0,26,5],[28,0,28,1],[29,0,29,3],[37,0,37,1]],"flags":["formulas_cached_only"]}
{"$rows_empty":7}
["14 PEACE STRT KURHULA","P. O. BOX 3748","REG: 2005/078058/23",null,"FAX:      086 654 5027"]
["PARK TZANEEN","TZANEEN 0850","VAT: 4240233371",null,"CELL:    072 251 3822",null,null,"CELL 072 251 3822/083 686 9816"]
["O85O","O850","TAX: 9214023161",null,"TELL:      015 307 3250"]
["Contact Person: Mr. Church Mushwana ",null,"CIDB: 110865",null,"EMAIL: cmushwana@gmail.com"]
[]
[null,"CESSION RECORN FOR AMALOOLOO"]
[]
[]
[]
["CLIENT DETAILS",null,null,"PROJECT DESCRIPTION"]
[{"$nulls":3},"PROJECT DESCRIPTION"]
["SEKHUKHUNE DISTRICT MUNICIPALITY",null,null,"PROJECT: MAKHUDUTHAMAGA LM RURAL HOUSEHOLD SANITATION PROJECT PHASE 2.1 CLUSTER 3 SK/8/3/1-05/2016/17"]
["FINANCE DEPARTMENT: SEKHUKHUNE MUNICIPALITY",null,null,"CONTRACT NO:","SK/8/3/1-04/2016/17"]
["PRIVATE BAG X 8611, GROBLERSDAL , 0470",null,null,"SITE: PELEPELE PARK"]
["Contact: "," (0) 13 262 7669"]
["VAT NO.",{"v":4420195390,"d":"4,420,195,390"}]
[]
["30/03/2017"]
[]
["CLAIM NO 1"]
["TOTAL CESSION AMOUNT : R 2 149 845.06",{"v":638400,"d":"R 638,400.00"}]
["DESCRIPTION",null,null,"UNIT PRICE","VAT","AMOUNT"]
["SUPPLY OF 200 VIP TOP STRUCTURES"]
["CONTRACTOT CLAIM NO",4]
["INVOICE DATE:","30/03/2017"]
["TOTAL APPOINTMENT PROJECT AMOUNT",null,null,{"v":560000,"d":"R 560,000.00"},{"v":78400.00000000001,"d":"R 78,400.00"},{"v":638400,"d":"R 638,400.00"}]
["1 CLAIM AMOUNT",null,"PRESENT",{"v":560000,"d":"R 560,000.00"},{"v":78400.00000000001,"d":"R 78,400.00"},{"v":638400,"d":"R 638,400.00"}]
["TOTAL REMAINING PROJECT AMOUNT",null,null,0,0,0]
["200 VIP TOP STRUCTURES SUPPLIED"]
[{"$nulls":5},0]
["PEADOM INVESTMENT JV LMS",null,null,"Vat",null,0]
[{"$nulls":3},"Total Remaining Amount",null,0]

{"sheet":"Invoice","index":17,"n_rows":55,"n_cols":10,"rows_kept":55,"hidden":true,"merged":[[2,0,6,4],[7,0,7,9],[8,0,8,9],[9,1,9,4],[10,1,10,4],[11,1,11,5],[16,1,16,2],[22,0,22,9],[24,1,24,5],[25,1,25,5],[26,0,27,0],[26,1,27,5],[28,1,28,5],[29,1,29,5],[30,1,30,5],[31,1,31,5],[32,1,32,5],[33,1,33,5],[34,1,34,5],[35,1,35,5],[36,1,36,5],[37,1,37,5],[43,1,43,5],[44,1,44,5],[45,0,45,8],[46,0,46,8],[47,0,47,8],[48,0,48,9],[53,3,53,4]],"flags":["formulas_cached_only"]}
[]
[]
["ZERBACRAFT (PTY) LTD JV LANCE MANAGEMENT SERVICES",{"$nulls":5},"                           60 Railway street ,Ladanna"]
[{"$nulls":6},"POLOKWANE,0699"]
[{"$nulls":6},"FAX : 086 668 3851"]
[{"$nulls":7},"Email.dommym78@live.co.za"]
[]
["                                                                      VAT Registration No.  4160284164"]
[]
["Date:","2019-01-28",{"$nulls":6},"Invoice No:","2/003"]
[]
["To:","Capricorn District Municipality"]
[null,"P.BOX 4100"]
[null,"Polokwane"]
[null,{"$error":"#REF!"}]
[]
["Your VAT No",4650102827]
[]
["Tel No:","015-294 1000"]
["Fax No:","015-291 4297"]
[]
["Attention:","Project Manager"]
["TAX INVOICE"]
[]
["ITEM","DESCRIPTION",{"$nulls":4},"UNIT","QTY","RATE","TOTAL"]
[]
["01","Capricorn District Municipality:Lepelle Nkumpi Household Sanitation"]
[]
[null,"Work Done todate",{"$nulls":4},"No",1,{"$error":"#REF!"},{"$error":"#REF!"}]
{"$rows_empty":9}
["Regards "]
[]
["Signed :  _______________________"]
[]
["Date :     _______________________"]
[]
[]
["Sub-total",{"$nulls":8},{"$error":"#REF!"}]
["VAT @ 15%",{"$nulls":8},{"$error":"#REF!"}]
["Total",{"$nulls":8},{"$error":"#REF!"}]
[]
["BANKING DETAILS:-"]
[]
["ACCOUNT HOLDER   :",null,null,"ZERBACRAFT CC"]
["BANK",null,":","ABSA"]
["ACCOUNT NO.",null,":",4079542548]
["BRANCH",null,":","POLOKWANE"]