{"text_format":"1","workbook":"xlsx","n_sheets":42,"sheets":["OSO","Statement - VHS","Statement -Elgin","Statement - Powerforce","Statement - Discovery Drilling","Statement - BHS","Statement - Delante","Statement - Coalseam","Statement - CIH","Statement - Rock Mining Machine","Statement - Largostax","Statement - Vex Mining","Statement - S. Automac","Statement - Hydrapower","Statement - Contour","Statement - FLP Diesel","StateRecon - Tshwane","Statement - OM Trading","Statement - Countywide","Statement - SA Tube OFS","Remittance","Delivery Note","Purchase Order","Purchase Order - Ambrosales","Purchase Order - HDC","Purchase Order - KPL","Quotation","Quotation (2)","STD Repair Quote (2)","STD Repair Quote (4)","STD Repair Quote (3)","Quotation - Sandvik","Quotation - Sandvik (2)","Quotation - AngloGold","STD Repair Quote","AGRIGEL Quote","AGRIGEL Purchase ORder","AGRIGEL Tax Invoice","AGRIGEL Delivery Note","AGRIGEL Statement","AGRIGEL Credit Note","InfantMed Statement"],"not_rendered":{"charts":0,"images":10,"macros":1,"external_links":0,"defined_names":41,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"OSO","index":0,"n_rows":44,"n_cols":13,"rows_kept":44,"cut":false,"hidden":false,"merged":[[0,0,0,10],[1,11,25,11],[13,1,13,10]]}
[]
[null,"COMPANY NAME","DATE ORDERED","QTY","PART NO","DESCRIPTION","PRICE","DATE REQ.","P/O NO","JOB NO","REMARKS",null,"TOTAL"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"G3*D3","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"AGRIGEL ORDERS:",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"REPAIRS:",null,null,null,null,"QUOTED","STATUS","ORDER No","DELIV. No","JOB No",null,{"$f":"SUM(M3:M18)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"G20*D20","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M19:M26)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   "]
[]
[]
[null,null,null,null,"   "]

{"sheet":"Statement - VHS","index":1,"n_rows":60,"n_cols":7,"rows_kept":60,"cut":false,"hidden":false,"merged":[[26,0,26,1],[24,0,24,1],[25,0,25,1],[4,0,4,3],[22,0,22,1],[23,0,23,1],[0,0,0,3],[1,0,1,3],[19,0,19,1],[20,0,20,1],[21,0,21,1],[5,0,5,6],[6,0,6,6],[15,0,15,1],[17,0,17,1],[18,0,18,1],[15,3,15,4],[1,5,1,6],[2,5,2,6],[3,0,3,3],[27,0,27,1],[35,0,35,1],[36,0,36,1],[59,0,59,1],[29,0,29,1],[30,0,30,1],[31,0,31,1],[32,0,32,1],[33,0,33,1],[34,0,34,1],[28,0,28,1]]}
[]
["Manufacturers of Hydraulic Components",null,null,null,null,"STATEMENT"]
["P.O. Box 2892, Delmas, 2210   \u009f   Cnr Road 10 and Driedoring Street, Delmas",null,null,null,null,"JANUARY 2022"]
["Tel: 013 668 0000   \u009f   Fax: 086 659 8207"]
["VAT Number: 4810183410"]
[]
["STATEMENT"]
[]
[]
[null,"VHS TECH SERVICES CC"]
[null,"Unit 3 Astro Place"]
[null,"c/o Fleming & vd Bijl Street"]
[null,"Meadowdale"]
[null,"Germiston"]
[]
["DATE",null,"REFERENCE","DESCRIPTION",null,"AMOUNT","BALANCE"]
[]
["2015-10-26",null,"Tax Invoice - PI1649",null,null,11730.6,{"$f":"F18","v":11730.6}]
["2015-11-01",null,"Balance brought down",null,null,null,{"$f":"G18","v":11730.6}]
["2015-11-02",null,"Tax Invoice - PI1668",null,null,1824,{"$f":"G19+F20","v":13554.6}]
["2015-11-24",null,"Payment - Thank you!",null,null,-11730.6,{"$f":"G20+F21","v":1824}]
["2021-11-18",null,"AI4348","Tax Invoice",null,34419.5,{"$f":"F22","v":34419.5}]
["2021-12-14",null,"PI4374","Tax Invoice",null,460,{"$f":"G22+F23","v":34879.5}]
["2022-01-31",null,"PI4392","Tax Invoice",null,68839,{"$f":"G23+F24","v":103718.5}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["+ 90 Days",null,"90 Days","60 Days","30 Days","Current","Total Due"]
[null,null,0,{"$f":"F22","v":34419.5},{"$f":"F23","v":460},{"$f":"F24","v":68839},{"$f":"SUM(A60:F60)","v":103718.5}]

{"sheet":"Statement -Elgin","index":2,"n_rows":60,"n_cols":7,"rows_kept":60,"cut":false,"hidden":false,"merged":[[4,0,4,3],[0,0,0,3],[1,0,1,3],[1,5,1,6],[2,5,2,6],[3,0,3,3],[24,0,24,1],[5,0,5,6],[6,0,6,6],[15,0,15,1],[15,3,15,4],[17,0,17,1],[18,0,18,1],[19,0,19,1],[20,0,20,1],[21,0,21,1],[22,0,22,1],[23,0,23,1],[59,0,59,1],[25,0,25,1],[26,0,26,1],[27,0,27,1],[28,0,28,1],[29,0,29,1],[30,0,30,1],[31,0,31,1],[32,0,32,1],[33,0,33,1],[34,0,34,1],[35,0,35,1]]}
[]
["Manufacturers of Hydraulic Components",null,null,null,null,"STATEMENT"]
["P.O. Box 2892, Delmas, 2210   \u009f   Cnr Road 10 and Driedoring Street, Delmas",null,null,null,null,"JANUARY 2022"]
["Tel: 013 668 0000   \u009f   Fax: 086 659 8207"]
["VAT Number: 4810183410"]
[]
["STATEMENT"]
[]
[]
[null,"ELGIN FLAMEPROOFING"]
[null,"P.O. Box 2164"]
[null,"Kempton Park"]
[null,1620]
[]
[]
["DATE",null,"REFERENCE","DESCRIPTION",null,"AMOUNT","BALANCE"]
[]
["2015-10-26",null,"Tax Invoice - PI1649",null,null,11730.6,{"$f":"F18","v":11730.6}]
["2015-11-01",null,"Balance brought down",null,null,null,{"$f":"G18","v":11730.6}]
["2015-11-02",null,"Tax Invoice - PI1668",null,null,1824,{"$f":"G19+F20","v":13554.6}]
["2015-11-24",null,"Payment - Thank you!",null,null,-11730.6,{"$f":"G20+F21","v":1824}]
[]
["2021-01-21",null,"PI3955","Tax Invoice",null,1415.5,{"$f":"G22+F23","v":1415.5}]
["2021-01-22",null,"PI3961","Tax Invoice",null,2944,{"$f":"G23+F24","v":4359.5}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["+ 90 Days",null,"90 Days","60 Days","30 Days","Current","Total Due"]
[{"$f":"F23+F24","v":4359.5},null,null,null,0,0,{"$f":"SUM(A60:F60)","v":4359.5}]

{"sheet":"Statement - Powerforce","index":3,"n_rows":55,"n_cols":7,"rows_kept":55,"cut":false,"hidden":false,"merged":[[0,0,0,3],[1,0,1,3],[6,0,6,6],[15,0,15,1],[15,2,15,3],[1,5,1,6],[2,5,2,6],[3,0,3,3],[4,0,4,3],[5,0,5,6],[30,0,30,1],[17,0,17,1],[18,0,18,1],[54,0,54,1],[23,0,23,1],[24,0,24,1],[22,0,22,1],[26,0,26,1],[27,0,27,1],[25,0,25,1],[28,0,28,1],[29,0,29,1]]}
[]
["Manufacturers of Hydraulic Components",null,null,null,null,"STATEMENT"]
["P.O. Box 2892, Delmas, 2210   \u009f   Cnr Road 10 and Driedoring Street, Delmas",null,null,null,null,"JUNE 2021"]
["Tel: 013 668 0000   \u009f   Fax: 086 659 8207"]
["VAT Number: 4810183410"]
[]
["STATEMENT"]
[]
[]
[null,"POWERFORCE HYDRAULICS"]
[null,"P.O. Box 660"]
[null,"Trichardt"]
[null,2300]
[]
[]
["DATE",null,"TRANSACTION",null,null,"AMOUNT","BALANCE"]
[]
["2021-05-12",null,"PI4075","Tax Invoice",null,4140,{"$f":"F18","v":4140}]
["2021-05-14",null,"PI4079","Tax Invoice",null,5865,{"$f":"G18+F19","v":10005}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["+ 90 Days",null,"90 Days","60 Days","30 Days","Current","Total Due"]
[null,null,null,null,{"$f":"F18+F19","v":10005},0,{"$f":"SUM(A55:F55)","v":10005}]

{"sheet":"Statement - Discovery Drilling","index":4,"n_rows":53,"n_cols":7,"rows_kept":53,"cut":false,"hidden":false,"merged":[[16,0,16,1],[52,0,52,1],[0,0,0,3],[1,0,1,3],[6,0,6,6],[14,0,14,1],[14,2,14,3],[1,5,1,6],[2,5,2,6],[3,0,3,3],[4,0,4,3],[5,0,5,6]]}
[]
["Manufacturers of Hydraulic Components",null,null,null,null,"STATEMENT"]
["",null,null,null,null,"2022-03-10"]
["Tel: 013 668 0000   \u009f   Fax: 086 659 8207"]
["VAT Number: 4810183410"]
[]
["STATEMENT"]
[]
[]
[null,"DISCOVERY DRILLING"]
[null,"P.O. BOX 10"]
[null,"BOSHOEK"]
[null,301]
[]
["DATE",null,"TRANSACTION",null,null,"AMOUNT","BALANCE"]
[]
["2021-03-12",null,"Payment - Thank you!",null,null,-23000,{"$f":"F17","v":-23000}]
[null,"2021-04-01","Tax Invoice - PI3999",null,null,307050,{"$f":"G17+F18","v":284050}]
[null,"2021-07-01","Tax Invoice - PI4132",null,null,20700,{"$f":"G18+F19","v":304750}]
[null,"2021-07-07","Payment - Thank you!",null,null,-150000,{"$f":"G19+F20","v":154750}]
[null,"2021-09-02","Payment - Thank you!",null,null,-100000,{"$f":"G20+F21","v":54750}]
[null,"2021-10-27","Tax Invoice - PI4308",null,null,22540,{"$f":"G21+F22","v":77290}]
[null,"2021-10-27","Tax Invoice - PI4309",null,null,21781,99071]
[null,"2021-12-03","Payment - Thank you!",null,null,-99071,0]
[null,"2022-02-07","Tax Invoice - PI4397",null,null,63940,63940]
[null,"2022-03-04","Payment - Thank you!",null,null,-63940,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["+ 90 Days",null,"90 Days","60 Days","30 Days","Current","Total Due"]
[null,null,null,null,null,null,{"$f":"SUM(A53:F53)","v":0}]

{"sheet":"Statement - BHS","index":5,"n_rows":95,"n_cols":9,"rows_kept":95,"cut":false,"hidden":false,"merged":[[46,0,46,1],[47,0,47,1],[49,0,49,1],[53,0,53,1],[52,0,52,1],[51,0,51,1],[50,0,50,1],[48,0,48,1],[36,0,36,1],[37,0,37,1],[44,0,44,1],[45,0,45,1],[39,0,39,1],[40,0,40,1],[41,0,41,1],[42,0,42,1],[19,0,19,1],[18,0,18,1],[43,0,43,1],[94,0,94,1],[24,0,24,1],[25,0,25,1],[26,0,26,1],[27,0,27,1],[28,0,28,1],[29,0,29,1],[30,0,30,1],[31,0,31,1],[32,0,32,1],[33,0,33,1],[34,0,34,1],[35,0,35,1],[22,0,22,1],[23,0,23,1],[38,0,38,1],[0,0,0,3],[1,0,1,3],[6,0,6,6],[15,0,15,1],[15,2,15,3],[1,5,1,6],[2,5,2,6],[3,0,3,3],[4,0,4,3],[5,0,5,6],[20,0,20,1],[21,0,21,1],[17,0,17,1],[59,0,59,1],[54,0,54,1],[58,0,58,1],[57,0,57,1],[56,0,56,1]]}
[]
["Manufacturers of Hydraulic Components",null,null,null,null,"STATEMENT"]
["P.O. Box 2892, Delmas, 2210   \u009f   Cnr Road 10 and Driedoring Street, Delmas",null,null,null,null,"MAY 2021"]
["Tel: 013 668 0000   \u009f   Fax: 086 659 8207"]
["VAT Number: 4810183410"]
[]
["STATEMENT"]
[]
[]
[null,"BHS ENTERPRISES CC"]
[null,"P.O. Box 22845"]
[null,"Middelburg"]
[null,1050]
[null,"Att: Tienie"]
[]
["DATE",null,"TRANSACTION",null,null,"AMOUNT","BALANCE"]
[]
["2017-01-01",null,"Balance brought down",null,null,null,23039.4]
["2017-01-13",null,"Tax Invoice - PI2170",null,null,29115.599999999999,{"$f":"G18+F19","v":52155}]
["2017-01-30",null,"Payment - Thank You!",null,null,-23039.4,{"$f":"G19+F20","v":29115.599999999999}]
["2017-02-01",null,"Balance brought down",null,null,null,{"$f":"G20","v":29115.599999999999}]
["2017-02-07",null,"Tax Invoice - PI2199",null,null,1288.2,{"$f":"G21+F22","v":30403.8}]
["2017-02-14",null,"Tax Invoice - PI2206",null,null,2439.6,{"$f":"G22+F23","v":32843.4}]
["2017-02-27",null,"Payment - Thank You!",null,null,-29115.599999999999,{"$f":"G23+F24","v":3727.8000000000029}]
["2017-03-28",null,"Payment - Thank You!",null,null,-3727.8,{"$f":"G24+F25","v":0}]
["2017-04-07",null,"Tax Invoice - PI2264",null,null,9667.2000000000007,9667.2000000000007]
["2017-04-10",null,"Tax Invoice - PI2265",null,null,1710,11377.2]
["2017-05-29",null,"Payment - Thank You!",null,null,-11377.2,0]
["2017-05-30",null,"Tax Invoice - PI2324",null,null,3357.3,3357.3]
["2018-02-05",null,"Tax Invoice - PI2624",null,null,4924.8,{"$f":"F30","v":4924.8}]
["2018-03-26",null,"Payment - Thank You!",null,null,-4924.8,{"$f":"G30+F31","v":0}]
["2018-07-23",null,"Tax Invoice - PI2760",null,null,4496.5,4496.5]
["2018-08-23",null,"Payment - Thank You!",null,null,-4496.5,0]
["2018-08-24",null,"Tax Invoice - PI2801",null,null,11339,11339]
["2018-09-25",null,"Payment - Thank You!",null,null,-11339,0]
["2018-12-10",null,"Tax Invoice - PI3018",null,null,5980,5980]
["2019-01-01",null,"Balance brought down",null,null,null,5980]
["2019-01-24",null,"Tax Invoice - PI3051",null,null,7544,{"$f":"G37+F38","v":13524}]
["2019-01-30",null,"Payment - Thank You!",null,null,-5980,{"$f":"G38+F39","v":7544}]
["2019-02-01",null,"Balance brought down",null,null,null,{"$f":"G39","v":7544}]
["2019-02-06",null,"Tax Invoice - PI3057",null,null,2932.5,{"$f":"G39+F41","v":10476.5}]
["2019-02-08",null,"Tax Invoice - PI3059",null,null,2760,{"$f":"G41+F42","v":13236.5}]
["2019-02-25",null,"Payment - Thank You!",null,null,-7544,5692.5]
["2019-03-27",null,"Payment - Thank You!",null,null,-2932.5,2760]
["2019-04-11",null,"Tax Invoice - PI3121",null,null,9418.5,12178.5]
["2019-04-11",null,"Tax Invoice - PI3122",null,null,2714,14892.5]
["2019-04-29",null,"Tax Invoice - PI3137",null,null,13800,28692.5]
["2019-04-29",null,"Tax Invoice - PI3138",null,null,4071,32763.5]
["2019-06-06",null,"Tax Invoice - PI3175",null,null,4830,37593.5]
["2019-06-13",null,"Tax Invoice - PI3189",null,null,4945,42538.5]
["2019-06-13",null,"Tax Invoice - PI3190",null,null,7567,50105.5]
["2019-06-13",null,"Payment - Thank You!",null,null,-30003.5,20102]
["2019-07-09",null,"Payment - Thank You!",null,null,-17342,2760]
["2019-09-30",null,"Tax Invoice - PI3316",null,null,8510,11270]
["2020-06-02",null,"Tax Invoice - PI3601",null,null,4738,{"$f":"F55","v":4738}]
[]
["2021-03-01",null,"PI4000","Tax Invoice",null,2415,{"$f":"F57","v":2415}]
[]
[]
[null,null,null,null,null,null,null,null,{"$f":"F59+F57","v":2415}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["+ 90 Days",null,"90 Days","60 Days","30 Days","Current","Total Due"]
[null,null,null,null,null,{"$f":"F57","v":2415},{"$f":"SUM(A95:F95)","v":2415}]

{"sheet":"Statement - Delante","index":6,"n_rows":56,"n_cols":7,"rows_kept":56,"cut":false,"hidden":false,"merged":[[55,0,55,1],[19,0,19,1],[5,0,5,6],[6,0,6,6],[15,0,15,1],[15,2,15,3],[17,0,17,1],[18,0,18,1],[20,0,20,1],[21,0,21,1],[4,0,4,3],[0,0,0,3],[1,0,1,3],[1,5,1,6],[2,5,2,6],[3,0,3,3]]}
[]
["Manufacturers of Hydraulic Components",null,null,null,null,"STATEMENT"]
["P.O. Box 2892, Delmas, 2210   \u009f   Cnr Road 10 and Driedoring Street, Delmas",null,null,null,null,"SEPTEMBER 2018"]
["Tel: 013 668 0000   \u009f   Fax: 086 659 8207"]
["VAT Number: 4810183410"]
[]
["STATEMENT"]
[]
[]
[null,"DELANTE"]
[null,"26 Harriet Avenue"]
[null,"Driehoek"]
[null,"Germiston"]
[null,1401]
[]
["DATE",null,"TRANSACTION",null,null,"AMOUNT","BALANCE"]
[]
["2018-08-01",null,"Balance brought down",null,null,4945,{"$f":"F18","v":4945}]
["2018-08-02",null,"Payment",null,null,-4945,{"$f":"G18+F19","v":0}]
["2018-08-14",null,"Tax Invoice - PI2779",null,null,230,{"$f":"G19+F20","v":230}]
["2018-09-13",null,"Tax Invoice - PI2832",null,null,5175,{"$f":"G20+F21","v":5405}]
["2018-09-13",null,"Tax Invoice - PI2833",null,null,5175,{"$f":"G21+F22","v":10580}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["+ 90 Days",null,"90 Days","60 Days","30 Days","Current","Total Due"]
[null,null,null,null,{"$f":"F20","v":230},{"$f":"SUM(F21:F22)","v":10350},{"$f":"SUM(A56:F56)","v":10580}]

{"sheet":"Statement - Coalseam","index":7,"n_rows":84,"n_cols":10,"rows_kept":84,"cut":false,"hidden":false,"merged":[[70,0,70,1],[71,0,71,1],[72,0,72,1],[73,0,73,1],[65,0,65,1],[66,0,66,1],[67,0,67,1],[68,0,68,1],[69,0,69,1],[60,0,60,1],[61,0,61,1],[62,0,62,1],[63,0,63,1],[64,0,64,1],[43,0,43,1],[29,0,29,1],[30,0,30,1],[31,0,31,1],[38,0,38,1],[39,0,39,1],[41,0,41,1],[40,0,40,1],[42,0,42,1],[34,0,34,1],[35,0,35,1],[36,0,36,1],[37,0,37,1],[33,0,33,1],[32,0,32,1],[26,0,26,1],[28,0,28,1],[27,0,27,1],[0,0,0,3],[1,0,1,3],[3,0,3,3],[4,0,4,3],[5,0,5,7],[1,6,1,7],[2,6,2,7],[44,0,44,1],[82,3,82,4],[83,3,83,4],[6,0,6,7],[15,2,15,3],[83,0,83,1],[15,0,15,1],[17,0,17,1],[18,0,18,1],[19,0,19,1],[20,0,20,1],[22,0,22,1],[23,0,23,1],[24,0,24,1],[21,0,21,1],[25,0,25,1],[58,0,58,1],[59,0,59,1],[57,0,57,1],[45,0,45,1],[46,0,46,1],[49,0,49,1],[53,0,53,1],[54,0,54,1],[50,0,50,1],[51,0,51,1],[52,0,52,1],[55,0,55,1],[56,0,56,1],[47,0,47,1],[48,0,48,1]]}
[]
["Manufacturers of Hydraulic Components",null,null,null,null,null,"STATEMENT"]
["P.O. Box 2892, Delmas, 2210   \u009f   Cnr Road 10 and Driedoring Street, Delmas",null,null,null,null,null,{"$f":"TODAY()","v":"2022-03-10"}]
["Tel: 013 668 0000   \u009f   Fax: 086 659 8207"]
["VAT Number: 4810183410"]
[]
["STATEMENT"]
[]
[]
[null,"COALSEAM HYDRAULICS & MINING SUPPLIES"]
[null,"PO Box 1780"]
[null,"Edenvale"]
[null,1610]
[]
[]
["DATE",null,"TRANSACTION",null,"ORDER NUMBER",null,"AMOUNT","BALANCE"]
[]
["2018-06-18",null,"Tax Invoice - PI2727",null,null,null,969,{"$f":"G18","v":969},"ü"]
["2018-06-20",null,"Tax Invoice - PI2729",null,"B24948",null,5750,{"$f":"H18+G19","v":6719},"ü"]
["2018-06-20",null,"Tax Invoice - PI2730",null,"B26064",null,5750,{"$f":"H19+G20","v":12469}]
["2018-06-21",null,"Payment - B26064",null,null,null,-28750,{"$f":"H20+G21","v":-16281},"-"]
["2018-07-31",null,"Payment - B27049",null,null,null,-25875,{"$f":"H21+G22","v":-42156},"-"]
["2018-08-01",null,"Tax Invoice - PI2770",null,"B27049",null,25875,-16281,"ü"]
["2018-08-16",null,"Tax Invoice - PI2781",null,"B27752",null,26496,{"$f":"H23+G24","v":10215},"ü"]
["2018-08-16",null,"Payment - B27752",null,null,null,-26496,-16281]
["2018-08-18",null,"Tax Invoice - PI2783",null,"B26064",null,23000,6719,"ü"]
["2018-08-21",null,"Tax Invoice - PI2791",null,"B28013",null,11500,18219]
["2018-08-22",null,"Payment - B28013",null,null,null,-11500,6719]
["2018-08-22",null,"Tax Invoice - PI2813",null,"B28121",null,14375,21094]
["2018-09-03",null,"Payment - Thank you!",null,null,null,-14375,6719]
[null,null,"Credit Note - PI3065",null,null,null,{"$f":"-6719+3516","v":-3203},3516]
["2018-10-01",null,"Balance brought down",null,null,null,null,{"$f":"H31","v":3516}]
["2018-10-15",null,"Tax Invoice - PI2914",null,"B29181",null,10350,{"$f":"H31+G33","v":13866}]
["2018-10-12",null,"Payment - Thank you!",null,null,null,-10350,3516]
["2018-11-21",null,"Tax Invoice - PI2996",null,"B30606",null,2875,6391]
["2018-11-21",null,"Tax Invoice - PI2997",null,"B31488",null,2875,9266]
["2018-11-21",null,"Tax Invoice - PI2998",null,"B30758",null,5750,15016]
["2018-11-21",null,"Tax Invoice - PI2999",null,"B30607",null,2875,{"$f":"H37+G38","v":17891}]
["2018-11-22",null,"Payment - Thank you!",null,null,null,-15525,2366]
["2018-12-12",null,"Tax Invoice - PI3023",null,"B31423",null,2875,5241]
["2018-12-12",null,"Tax Invoice - PI3024",null,"B31424",null,2875,8116]
["2019-03-04",null,"Tax Invoice - PI3094",null,"B30609",null,2875,10991]
["2019-03-07",null,"Tax Invoice - PI3076",null,"B32967",null,2875,{"$f":"H42+G43","v":13866}]
["2019-03-07",null,"Payment - Thank you!",null,null,null,-2875,10991]
["2019-03-25",null,"Payment - Thank you!",null,null,null,-10991,0]
[null,null,null,null,null,null,null,{"$f":"G46","v":0}]
["2019-11-28",null,"Tax Invoice - PI3443",null,"B38663",null,28750,{"$f":"H46+G47","v":28750}]
["2020-12-09",null,"Tax Invoice - PI3459",null,"B38799",null,5750,34500]
["2020-12-09",null,"Payment - B38799",null,null,null,-5750,28750]
["2019-12-17",null,"Tax Invoice - PI3468",null,"B38857",null,5750,34500]
["2020-01-28",null,"Payment - B39021",null,null,null,-11500,23000]
["2020-01-28",null,"Payment - B38663",null,null,null,-2875,20125]
["2020-01-29",null,"Payment - B38663",null,null,null,-2875,17250]
["2020-02-04",null,"Tax Invoice - PI3488",null,"B39021",null,11500,28750]
["2020-02-07",null,"Payment - B38663",null,null,null,-14375,14375]
["2020-02-25",null,"Payment - B39474",null,null,null,-2875,11500]
["2020-02-26",null,"Tax Invoice - PI3514",null,"B39474",null,2875,14375]
["2020-02-26",null,"Payment - B38663",null,null,null,-8625,5750,null,{"$f":"G58+G55+G53+G52","v":-28750}]
["2020-06-17",null,"Payment - B40528",null,null,null,-5750,0]
["2020-06-18",null,"Tax Invoice - PI3631",null,"B40528",null,5750,5750]
["2020-07-08",null,"Tax Invoice - PI3665",null,"B40757",null,5750,{"$f":"H60+G61","v":11500}]
["2020-07-08",null,"Payment - B40757",null,null,null,-5750,5750]
["2020-07-09",null,"Tax Invoice - PI3667",null,"B40788",null,2875,8625]
["2020-07-09",null,"Tax Invoice - PI3668",null,"B40791",null,2875,11500]
["2020-07-09",null,"Tax Invoice - PI3669",null,"B40792",null,2875,14375]
["2020-07-09",null,"Payment - B40788",null,null,null,-2875,11500]
["2020-07-09",null,"Payment - B40791",null,null,null,-2875,8625]
["2020-07-09",null,"Payment - B40792",null,null,null,-2875,5750]
["2020-07-20",null,"Tax Invoice - PI3677",null,"B40880",null,2875,8625]
["2020-07-20",null,"Tax Invoice - PI3678",null,"B40881",null,2875,11500]
["2020-07-20",null,"Tax Invoice - PI3679",null,"B40882",null,2875,14375]
["2020-07-21",null,"Payment - B40880",null,null,null,-2875,11500]
["2020-07-21",null,"Payment - B40881",null,null,null,-2875,8625]
["2020-07-21",null,"Payment - B40882",null,null,null,-2875,5750]
[]
[]
[]
[]
[]
[]
[]
[]
["+ 90 Days",null,"90 Days","60 Days",null,"30 Days","Current","Total Due"]
[{"$f":"H58","v":5750},null,null,null,null,null,null,{"$f":"SUM(A84:G84)","v":5750}]

{"sheet":"Statement - CIH","index":8,"n_rows":56,"n_cols":7,"rows_kept":56,"cut":false,"hidden":false,"merged":[[55,0,55,1],[0,0,0,3],[1,0,1,3],[1,5,1,6],[2,5,2,6],[3,0,3,3],[4,0,4,3],[5,0,5,6],[6,0,6,6],[14,0,14,1],[14,2,14,3],[16,0,16,1],[17,0,17,1]]}
[]
["Manufacturers of Hydraulic Components",null,null,null,null,"STATEMENT"]
["P.O. Box 2892, Delmas, 2210   \u009f   Cnr Road 10 and Driedoring Street, Delmas",null,null,null,null,"AUGUST 2018"]
["Tel: 013 668 0000   \u009f   Fax: 086 659 8207"]
["VAT Number: 4810183410"]
[]
["STATEMENT"]
[]
[]
[null,"COMMERCIAL INDUSTRIAL HYDRAULICS CC"]
[null,"6 Asset Road"]
[null,"Jet Park"]
[null,1467]
[]
["DATE",null,"TRANSACTION",null,null,"AMOUNT","BALANCE"]
[]
["2018-08-24",null,"Tax Invoice - PI2800",null,null,2850,{"$f":"F17","v":2850}]
["2018-08-28",null,"Tax Invoice - PI2805",null,null,6934.5,{"$f":"G17+F18","v":9784.5}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["+ 90 Days",null,"90 Days","60 Days","30 Days","Current","Total Due"]
[null,null,null,null,null,{"$f":"SUM(F17:F19)","v":9784.5},{"$f":"G18","v":9784.5}]

{"sheet":"Statement - Rock Mining Machine","index":9,"n_rows":56,"n_cols":7,"rows_kept":56,"cut":false,"hidden":false,"merged":[[22,0,22,1],[55,0,55,1],[23,0,23,1],[24,0,24,1],[25,0,25,1],[26,0,26,1],[27,0,27,1],[28,0,28,1],[29,0,29,1],[30,0,30,1],[31,0,31,1],[32,0,32,1],[5,0,5,6],[6,0,6,6],[14,0,14,1],[14,2,14,3],[16,0,16,1],[21,0,21,1],[20,0,20,1],[19,0,19,1],[18,0,18,1],[17,0,17,1],[4,0,4,3],[0,0,0,3],[1,0,1,3],[1,5,1,6],[2,5,2,6],[3,0,3,3]]}
[]
["Manufacturers of Hydraulic Components",null,null,null,null,"STATEMENT"]
["P.O. Box 2892, Delmas, 2210   \u009f   Cnr Road 10 and Driedoring Street, Delmas",null,null,null,null,"AUGUST 2018"]
["Tel: 013 668 0000   \u009f   Fax: 086 659 8207"]
["VAT Number: 4810183410"]
[]
["STATEMENT"]
[]
[]
[null,"ROCK MINING MACHINES"]
[null,"PO Box 500"]
[null,"Witbank"]
[null,1035]
[]
["DATE",null,"TRANSACTION",null,null,"AMOUNT","BALANCE"]
[]
["2018-08-25",null,"Tax Invoice - PI2802",null,null,53521,{"$f":"F17","v":53521}]
["2018-08-25",null,"Tax Invoice - PI2803",null,null,1150,{"$f":"G17+F18","v":54671}]
["2018-08-30",null,"Tax Invoice - PI2812",null,null,22356,77027]
["2018-08-30",null,"Payment - Thank you",null,null,-70782.5,6244.5]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["+ 90 Days",null,"90 Days","60 Days","30 Days","Current","Total Due"]
[null,null,null,null,null,{"$f":"G20","v":6244.5},{"$f":"SUM(A56:F56)","v":6244.5}]

{"sheet":"Statement - Largostax","index":10,"n_rows":65,"n_cols":7,"rows_kept":65,"cut":false,"hidden":false,"merged":[[0,0,0,3],[1,0,1,3],[6,0,6,6],[14,0,14,1],[14,2,14,3],[1,5,1,6],[2,5,2,6],[3,0,3,3],[4,0,4,3],[5,0,5,6],[20,0,20,1],[21,0,21,1],[64,0,64,1],[16,0,16,1],[17,0,17,1],[18,0,18,1],[19,0,19,1],[22,0,22,1],[23,0,23,1],[24,0,24,1],[25,0,25,1]]}
[]
["Manufacturers of Hydraulic Components",null,null,null,null,"STATEMENT"]
["P.O. Box 2892, Delmas, 2210   \u009f   Cnr Road 10 and Driedoring Street, Delmas",null,null,null,null,"APRIL 2017"]
["Tel: 013 668 0000   \u009f   Fax: 086 659 8207"]
["VAT Number: 4810183410"]
[]
["STATEMENT"]
[]
[]
[null,"LARGOSTAX CC"]
[null,"P.O. Box 12097"]
[null,"Benoryn"]
[null,1504]
[]
["DATE",null,"TRANSACTION",null,null,"AMOUNT","BALANCE"]
[]
["2013-01-07",null,"Tax Invoice - PI0471",null,null,5016,{"$f":"F17","v":5016}]
["2013-01-16",null,"Tax Invoice - PI0477",null,null,5016,{"$f":"G17+F18","v":10032}]
["2013-02-22",null,"Tax Invoice - PI0516",null,null,4560,{"$f":"G18+F19","v":14592}]
["2013-04-01",null,"Opening Balance",null,null,null,{"$f":"G19","v":14592}]
["2013-02-02",null,"Payment received",null,null,-14592,{"$f":"G20+F21","v":0}]
["2014-11-05",null,"Tax Invoice - PI1265",null,null,1368,{"$f":"G21+F22","v":1368}]
["2014-11-05",null,"Tax Invoice - PI1266",null,null,1368,{"$f":"G22+F23","v":2736}]
["2015-01-14",null,"Tax Invoice - PI1337",null,null,769.5,{"$f":"F24","v":769.5}]
["2015-04-02",null,"Payment received",null,null,-769.5,{"$f":"G24+F25","v":0}]
["2017-03-24",null,"Tax Invoice - PI2246",null,null,2793,{"$f":"G25+F26","v":2793}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["+ 90 Days",null,"90 Days","60 Days","30 Days","Current","Total Due"]
[null,null,null,null,{"$f":"F26","v":2793},null,{"$f":"SUM(A65:F65)","v":2793}]

{"sheet":"Statement - Vex Mining","index":11,"n_rows":65,"n_cols":7,"rows_kept":65,"cut":false,"hidden":false,"merged":[[24,0,24,1],[25,0,25,1],[64,0,64,1],[18,0,18,1],[19,0,19,1],[20,0,20,1],[21,0,21,1],[22,0,22,1],[23,0,23,1],[17,0,17,1],[0,0,0,3],[1,0,1,3],[1,5,1,6],[2,5,2,6],[3,0,3,3],[4,0,4,3],[5,0,5,6],[6,0,6,6],[14,0,14,1],[14,2,14,3],[16,0,16,1]]}
[]
["Manufacturers of Hydraulic Components",null,null,null,null,"STATEMENT"]
["P.O. Box 2892, Delmas, 2210   \u009f   Cnr Road 10 and Driedoring Street, Delmas",null,null,null,null,"AUGUST 2016"]
["Tel: 013 668 0000   \u009f   Fax: 086 659 8207"]
["VAT Number: 4810183410"]
[]
["STATEMENT"]
[]
[]
[null,"VEX MINING REPAIRS"]
[null,"19 Harriet Avenue"]
[null,"Germiston"]
[]
[]
["DATE",null,"TRANSACTION",null,null,"AMOUNT","BALANCE"]
[]
["2013-01-07",null,"Tax Invoice - PI0471",null,null,5016,{"$f":"F17","v":5016}]
["2013-01-16",null,"Tax Invoice - PI0477",null,null,5016,{"$f":"G17+F18","v":10032}]
["2013-02-22",null,"Tax Invoice - PI0516",null,null,4560,{"$f":"G18+F19","v":14592}]
["2013-04-01",null,"Opening Balance",null,null,null,{"$f":"G19","v":14592}]
["2013-02-02",null,"Payment received",null,null,-14592,{"$f":"G20+F21","v":0}]
["2014-11-05",null,"Tax Invoice - PI1265",null,null,1368,{"$f":"G21+F22","v":1368}]
["2014-11-05",null,"Tax Invoice - PI1266",null,null,1368,{"$f":"G22+F23","v":2736}]
["2015-01-14",null,"Tax Invoice - PI1337",null,null,769.5,{"$f":"F24","v":769.5}]
["2015-04-02",null,"Payment received",null,null,-769.5,{"$f":"G24+F25","v":0}]
["2016-07-15",null,"Tax Invoice - PI1913",null,null,3192,{"$f":"G25+F26","v":3192}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["+ 90 Days",null,"90 Days","60 Days","30 Days","Current","Total Due"]
[null,null,null,{"$f":"G26","v":3192},null,null,{"$f":"SUM(A65:F65)","v":3192}]

{"sheet":"Statement - S. Automac","index":12,"n_rows":58,"n_cols":7,"rows_kept":58,"cut":false,"hidden":false,"merged":[[57,3,57,4],[55,0,55,1],[17,0,17,1],[0,0,0,3],[1,0,1,3],[6,0,6,6],[14,0,14,1],[14,2,14,3],[16,0,16,1],[1,5,1,6],[2,5,2,6],[3,0,3,3],[4,0,4,3],[5,0,5,6],[18,0,18,1],[19,0,19,1]]}
[]
["Manufacturers of Hydraulic Components",null,null,null,null,"STATEMENT"]
["P.O. Box 2892, Delmas, 2210   \u009f   Cnr Road 10 and Driedoring Street, Delmas",null,null,null,null,"MAY 2015"]
["Tel: 013 668 0000   \u009f   Fax: 086 659 8207"]
["VAT Number: 4810183410"]
[]
["STATEMENT"]
[]
[]
[null,"S. AUTOMAC SERVICES CC"]
[null,"P.O. Box 91"]
[null,"Welkom"]
[null,9460]
[]
["DATE",null,"TRANSACTION",null,"AMOUNT","DISCOUNT - 25%","BALANCE"]
[]
["2015-05-01",null,"Balance brought forward",null,null,null,0]
["2015-05-06",null,"Payment - Thank you!",null,-484.48,null,{"$f":"G17+E18","v":-484.48}]
["2015-05-08",null,"Tax Invoice - PI1439",null,4560,{"$f":"E19*0.25","v":1140},{"$f":"G18+E19-F19","v":2935.52}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["+ 90 Days",null,"90 Days","60 Days","30 Days","Current","Total Due"]
[null,null,null,null,null,{"$f":"G19","v":2935.52},{"$f":"G17","v":0}]
[]
[null,null,null,{"$f":"SUM(D56:E56)","v":0}]

{"sheet":"Statement - Hydrapower","index":13,"n_rows":58,"n_cols":7,"rows_kept":58,"cut":false,"hidden":false,"merged":[[22,0,22,1],[18,0,18,1],[57,0,57,1],[17,0,17,1],[19,0,19,1],[20,0,20,1],[21,0,21,1],[23,0,23,1],[24,0,24,1],[0,0,0,3],[1,0,1,3],[6,0,6,6],[15,0,15,1],[15,2,15,3],[1,5,1,6],[2,5,2,6],[3,0,3,3],[4,0,4,3],[5,0,5,6]]}
[]
["Manufacturers of Hydraulic Components",null,null,null,null,"STATEMENT"]
["",null,null,null,null,"MARCH 2016"]
["Tel: 013 668 0000   \u009f   Fax: 086 659 8207"]
["VAT Number: 4810183410"]
[]
["STATEMENT"]
[]
[]
[null,"HYDRAPOWER HYDRAULICS"]
[null,"20 Paterson Street"]
[null,"Newcastle"]
[]
[]
[]
["DATE",null,"TRANSACTION",null,null,"AMOUNT","BALANCE"]
[]
["2015-01-26",null,"Tax Invoice - PI1354",null,null,4366.2,{"$f":"F18","v":4366.2}]
["2015-03-02",null,"Payment - Thank You!",null,null,-4366.2,{"$f":"G18+F19","v":0}]
["2015-12-10",null,"Tax Invoice - PI1726",null,null,16222.2,16222.2]
["2016-02-01",null,"Payment - Thank You!",null,null,-16222.2,0]
["2016-02-01",null,"Tax Invoice - PI1758",null,null,2576.4,2576.4]
["2016-02-12",null,"Tax Invoice - PI1770",null,null,957.6,3534]
["2016-03-01",null,"Tax Invoice - PI1781",null,null,27816,31350]
["2016-03-17",null,"Tax Invoice - PI1796",null,null,3180.6,34530.6]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["+ 90 Days",null,"90 Days","60 Days","30 Days","Current","Total Due"]
[null,null,null,null,{"$f":"F22+F23","v":3534},{"$f":"F24+F25","v":30996.6},{"$f":"SUM(A58:F58)","v":34530.6}]

{"sheet":"Statement - Contour","index":14,"n_rows":56,"n_cols":7,"rows_kept":56,"cut":false,"hidden":false,"merged":[[18,0,18,1],[55,0,55,1],[5,0,5,6],[6,0,6,6],[14,0,14,1],[14,2,14,3],[16,0,16,1],[17,0,17,1],[4,0,4,3],[0,0,0,3],[1,0,1,3],[1,5,1,6],[2,5,2,6],[3,0,3,3]]}
[]
["Manufacturers of Hydraulic Components",null,null,null,null,"STATEMENT"]
["P.O. Box 2892, Delmas, 2210   \u009f   Cnr Road 10 and Driedoring Street, Delmas",null,null,null,null,"JUNE 2013"]
["Tel: 013 668 0000   \u009f   Fax: 086 659 8207"]
["VAT Number: 4810183410"]
[]
["STATEMENT"]
[]
[]
[null,"CONTOUR PARTS & ENGINEERING"]
[null,"18 Bronze Street"]
[null,"Empangeni"]
[]
[]
["DATE",null,"TRANSACTION",null,null,"AMOUNT","BALANCE"]
[]
["2013-05-23",null,"Tax Invoice - PI0600",null,null,23860.2,{"$f":"F17","v":23860.2}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["+ 90 Days",null,"90 Days","60 Days","30 Days","Current","Total Due"]
[null,null,null,null,{"$f":"F17","v":23860.2},null,{"$f":"SUM(A56:F56)","v":23860.2}]

{"sheet":"Statement - FLP Diesel","index":15,"n_rows":56,"n_cols":7,"rows_kept":56,"cut":false,"hidden":false,"merged":[[4,0,4,3],[0,0,0,3],[1,0,1,3],[1,5,1,6],[2,5,2,6],[3,0,3,3],[19,0,19,1],[55,0,55,1],[5,0,5,6],[6,0,6,6],[15,0,15,1],[15,2,15,3],[17,0,17,1],[18,0,18,1]]}
[]
["Manufacturers of Hydraulic Components",null,null,null,null,"STATEMENT"]
["P.O. Box 2892, Delmas, 2210   \u009f   Cnr Road 10 and Driedoring Street, Delmas",null,null,null,null,"FEBRUARY 2015"]
["Tel: 013 668 0000   \u009f   Fax: 086 659 8207"]
["VAT Number: 4810183410"]
[]
["STATEMENT"]
[]
[]
[null,"FLP DIESEL"]
[null,"10 Meter Street"]
[null,"Middelburg"]
[null,1050]
[null,"Email: flpdiesel@telkomsa.net"]
[]
["DATE",null,"TRANSACTION",null,null,"AMOUNT","BALANCE"]
[]
["2014-09-01",null,"Tax Invoice - PI1139",null,null,3522.6,{"$f":"F18","v":3522.6}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["+ 90 Days",null,"90 Days","60 Days","30 Days","Current","Total Due"]
[null,null,null,null,null,{"$f":"F18","v":3522.6},{"$f":"SUM(A56:F56)","v":3522.6}]

{"sheet":"StateRecon - Tshwane","index":16,"n_rows":23,"n_cols":7,"rows_kept":23,"cut":false,"hidden":false,"merged":[[4,0,4,3],[0,0,0,3],[1,0,1,3],[1,5,1,6],[2,5,2,6],[3,0,3,3],[21,0,21,1],[22,0,22,1],[23,0,23,1],[5,0,5,6],[6,0,6,6],[17,0,17,1],[17,2,17,3],[19,0,19,1],[20,0,20,1]]}
[]
["Manufacturers of Hydraulic Components",null,null,null,null,"MONTH ENDING:"]
["P.O. Box 2892, Delmas, 2210   \u009f   Cnr Road 10 and Driedoring Street, Delmas",null,null,null,null,"AUGUST 2013"]
["Tel: 013 668 0000   \u009f   Fax: 086 659 8207"]
["VAT Number: 4810183410"]
[]
["RECONCILIATION"]
[]
[]
[null,"TSHWANE HYDRAULICS CC"]
[null,"PO Box 807"]
[null,"Olifantsfontein"]
[null,1665]
[]
[null,"ATT: Gruchen"]
[null,"Please view the recon of goods recevied and supplied between our companies below:"]
[]
["DATE",null,"TRANSACTION",null,"DEBIT","CREDIT","BALANCE"]
[]
["2013-07-01",null,"Balance due by Tshwane as per statement",null,8033.32,null,{"$f":"E20-F20","v":8033.32}]
["2013-07-01",null,"Balance due by PREMAC as per statement",null,null,25058.5,{"$f":"G20+E21-F21","v":-17025.18}]
["2013-07-18",null,"30 x Selector Valves supplied",null,{"$f":"(500*30)+(500*30)*0.14","v":17100},null,{"$f":"G21+E22-F22","v":74.819999999999709}]
["2013-07-18",null,"Bad debts",null,null,74.819999999999993,{"$f":"G22+E23-F23","v":-2.8421709430404007E-13}]

{"sheet":"Statement - OM Trading","index":17,"n_rows":56,"n_cols":7,"rows_kept":56,"cut":false,"hidden":false,"merged":[[4,0,4,3],[0,0,0,3],[1,0,1,3],[1,5,1,6],[2,5,2,6],[3,0,3,3],[18,0,18,1],[55,0,55,1],[5,0,5,6],[6,0,6,6],[14,0,14,1],[14,2,14,3],[16,0,16,1],[17,0,17,1],[19,0,19,1],[31,1,34,3]]}
[]
["Manufacturers of Hydraulic Components",null,null,null,null,"STATEMENT DATE"]
["P.O. Box 2892, Delmas, 2210   \u009f   Cnr Road 10 and Driedoring Street, Delmas",null,null,null,null,"DECEMBER 2014"]
["Tel: 013 668 0000   \u009f   Fax: 086 659 8207"]
["VAT Number: 4810183410"]
[]
["STATEMENT"]
[]
[]
[null,"O.M. TRADING CC"]
[null,"P.O. Box 1691"]
[null,"Edenvale"]
[null,1610]
[]
["DATE",null,"TRANSACTION",null,null,"AMOUNT","BALANCE"]
[]
["2014-10-10",null,"Tax Invoice - PI1234",null,null,4195.2,{"$f":"F17","v":4195.2}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["+ 90 Days",null,"90 Days","60 Days","30 Days","Current","Total Due"]
[null,null,null,{"$f":"F17","v":4195.2},null,null,{"$f":"SUM(A56:F56)","v":4195.2}]

{"sheet":"Statement - Countywide","index":18,"n_rows":56,"n_cols":7,"rows_kept":56,"cut":false,"hidden":false,"merged":[[55,0,55,1],[0,0,0,3],[1,0,1,3],[1,5,1,6],[2,5,2,6],[3,0,3,3],[4,0,4,3],[5,0,5,6],[6,0,6,6],[15,0,15,1],[15,2,15,3],[17,0,17,1],[18,0,18,1],[19,0,19,1]]}
[]
["Manufacturers of Hydraulic Components",null,null,null,null,"STATEMENT"]
["P.O. Box 2892, Delmas, 2210   \u009f   Cnr Road 10 and Driedoring Street, Delmas",null,null,null,null,"MARCH 2015"]
["Tel: 013 668 0000   \u009f   Fax: 086 659 8207"]
["VAT Number: 4810183410"]
[]
["STATEMENT"]
[]
[]
[null,"COUNTRYWIDE GEARBOX REPAIRS"]
[null,"P.O. Box 25061"]
[null,"East Rand"]
[null,1462]
[]
[]
["DATE",null,"TRANSACTION",null,null,"AMOUNT","BALANCE"]
[]
["2015-03-01",null,"Balance brought forward",null,null,5871,{"$f":"F18","v":5871}]
["2015-03-04",null,"Payment - Thank You!",null,null,-5871,{"$f":"G18+F19","v":0}]
["2015-03-09",null,"Tax Invoice - PI1393",null,null,5871,{"$f":"G19+F20","v":5871}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["+ 90 Days",null,"90 Days","60 Days","30 Days","Current","Total Due"]
[null,null,null,null,null,{"$f":"G20","v":5871},{"$f":"SUM(A56:F56)","v":5871}]

{"sheet":"Statement - SA Tube OFS","index":19,"n_rows":56,"n_cols":7,"rows_kept":56,"cut":false,"hidden":false,"merged":[[55,0,55,1],[0,0,0,3],[1,0,1,3],[1,5,1,6],[2,5,2,6],[3,0,3,3],[4,0,4,3],[5,0,5,6],[6,0,6,6],[15,0,15,1],[15,2,15,3],[17,0,17,1],[18,0,18,1]]}
[]
["Manufacturers of Hydraulic Components",null,null,null,null,"STATEMENT"]
["P.O. Box 2892, Delmas, 2210   \u009f   Cnr Road 10 and Driedoring Street, Delmas",null,null,null,null,"JANUARY 0214"]
["Tel: 013 668 0000   \u009f   Fax: 086 659 8207"]
["VAT Number: 4810183410"]
[]
["STATEMENT"]
[]
[]
[null,"SA TUBE & HONING"]
[null,"PO Box 826"]
[null,"Welkom"]
[null,9459]
[]
[]
["DATE",null,"TRANSACTION",null,null,"AMOUNT","BALANCE"]
[]
["2013-10-30",null,"Tax Invoice - PI0823",null,null,1368,{"$f":"F18","v":1368}]
["2013-11-21",null,"Tax Invoice - PI0868",null,null,684,{"$f":"G18+F19","v":2052}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["+ 90 Days",null,"90 Days","60 Days","30 Days","Current","Total Due"]
[null,null,{"$f":"F18","v":1368},{"$f":"F19","v":684},null,null,{"$f":"SUM(A56:F56)","v":2052}]

{"sheet":"Remittance","index":20,"n_rows":54,"n_cols":15,"rows_kept":54,"cut":false,"hidden":false,"merged":[[36,8,36,9],[32,6,32,7],[31,6,31,7],[31,8,31,9],[30,6,30,7],[21,8,21,9],[22,6,22,7],[25,6,25,7],[26,6,26,7],[27,8,27,9],[45,6,45,7],[19,6,19,7],[23,6,23,7],[21,6,21,7],[20,6,20,7],[28,6,28,7],[29,6,29,7],[52,7,52,8],[53,7,53,8],[51,0,51,1],[7,12,8,14],[50,13,50,14],[51,13,51,14],[53,13,53,14],[50,7,50,8],[51,7,51,8],[34,6,34,7],[35,6,35,7],[51,5,51,6],[50,5,50,6],[17,8,17,9],[18,8,18,9],[51,2,51,3],[0,12,0,14],[17,3,17,5],[17,6,17,7],[33,6,33,7],[18,6,18,7],[7,0,7,9],[2,0,2,9],[3,0,3,9],[1,13,1,14],[2,13,2,14],[3,13,3,14],[15,1,15,3],[0,0,0,4],[6,0,6,9],[16,1,16,3],[4,0,4,9],[5,0,5,9],[50,2,50,3],[17,1,17,2],[33,8,33,9],[34,8,34,9],[35,8,35,9],[46,6,46,7],[37,6,37,7],[38,6,38,7],[39,6,39,7],[40,6,40,7],[41,6,41,7],[24,6,24,7],[42,6,42,7],[43,6,43,7],[44,6,44,7]]}
[null,null,null,null,null,null,null,null,null,null,null,null,"REMITTANCE ADVICE"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Date :","2012-09-11"]
["Manufacturers of Hydraulic Components",null,null,null,null,null,null,null,null,null,null,null,"Page :",1]
["P.O. Box 2892, Delmas, 2210   \u009f   Cnr Road 10 and Driedoring Street, Delmas",null,null,null,null,null,null,null,null,null,null,null,"Acc Number :","TUR01"]
["Tel: 013 668 0000   \u009f   Fax: 086 659 8207"]
["VAT Number: 4810183410"]
[]
["REMITTANCE ADVICE",null,null,null,null,null,null,null,null,null,null,null,"PREMAC, a division of AGRIGEL (PTY) Ltd."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"P.O. Box 2892"]
["ALPHA HARDCHROME CC",null,null,null,null,null,null,null,null,null,null,null,"Delmas"]
["P.O. Box 17859",null,null,null,null,null,null,null,null,null,null,null,2210]
["Sunward Park"]
[1470]
[]
["Account","Date",null,null,"Page",null,null,null,null,null,null,null,"Account","Date","Page"]
["TUR01","2012-09-11",null,null,1,null,null,null,null,null,null,null,"TUR01","2012-09-11",1]
["DATE","REFERENCE",null,"DESCRIPTION",null,null,"DEBIT",null,"CREDIT",null,null,null,"DATE","REFERENCE","AMOUNT"]
[]
["2012-05-03",null,419199,null,"Tax Invoice",null,387.6,null,null,null,null,null,"2012-05-03",419199,"387.60D"]
["2012-05-16",null,420579,null,"Tax Invoice",null,1570.73,null,null,null,null,null,"2012-05-16",420579,"1570.73D"]
["2012-07-02",null,null,"Payment",null,null,null,null,{"$f":"SUM(G20:H21)","v":1958.33},null,null,null,"2012-07-02",null,"1958.33C"]
["2012-05-16",null,420626,null,"Tax Invoice",null,215.65,null,null,null,null,null,"2012-05-16",420626,"215.65D"]
["2012-06-04",null,422413,null,"Tax Invoice",null,11.4,null,null,null,null,null,"2012-06-04",422413,"11.4D"]
["2012-06-04",null,422414,null,"Tax Invoice",null,207.48,null,null,null,null,null,"2012-06-04",422414,"207.48D"]
["2012-06-05",null,422554,null,"Tax Invoice",null,184.66,null,null,null,null,null,"2012-06-05",422554,"184.66D"]
["2012-06-27",null,425008,null,"Tax Invoice",null,{"$f":"1390.8-18.24","v":1372.56},null,null,null,null,null,"2012-06-27",425008,"1372.56D"]
["2012-08-21",null,null,"Payment",null,null,null,null,{"$f":"1991.75","v":1991.75},null,null,null,"2012-08-21",null,"1991.75C"]
["2012-06-27",null,425008,null,"Tax Invoice",null,18.239999999999998,null,null,null,null,null,"2012-06-27",425008,"18.24D"]
["2012-07-05",null,425827,null,"Tax Invoice",null,866.09,null,null,null,null,null,"2012-07-05",425827,"866.09D"]
["2012-07-06",null,425910,null,"Tax Invoice",null,307.8,null,null,null,null,null,"2012-07-06",425910,"307.8D"]
["2012-07-09",null,22658,null,"Credit Note",null,null,null,171,null,null,null,"2012-07-09",22658,"171C"]
["2012-07-09",null,426065,null,"Tax Invoice",null,328.32,null,null,null,null,null,"2012-07-09",426065,"328.32D"]
["2012-07-09",null,426133,null,"Tax Invoice",null,766.08,null,null,null,null,null,"2012-07-09",426133,"766.08D"]
["2012-09-03",null,null,"Payment",null,null,null,null,{"$f":"SUM(G29:H34)-I32","v":2115.5300000000002},null,null,null,"2012-09-03",null,"2155.53C"]
["2012-07-20",null,427392,null,"Tax Invoice",null,1436.4,null,null,null,null,null,"2012-07-20",427392,"1436.4D"]
["2012-09-11",null,null,"Payment",null,null,null,null,1436.4,null,null,null,"2012-09-11",null,"1436.40C"]
["2012-08-01",null,428470,null,"Tax Invoice",null,1869.6,null,null,null,null,null,"2012-08-01",428470,"1869.6D"]
["2012-08-02",null,428600,null,"Tax Invoice",null,521.54999999999995,null,null,null,null,null,"2012-08-02",428600,"521.55D"]
["2012-08-02",null,428618,null,"Tax Invoice",null,521.54999999999995,null,null,null,null,null,"2012-08-02",428618,"521.55D"]
["2012-08-28",null,430787,null,"Tax Invoice",null,188.1,null,null,null,null,null,"2012-08-28",430787,"188.1D"]
["2012-08-28",null,430833,null,"Tax Invoice",null,1322.4,null,null,null,null,null,"2012-08-28",430833,"1322.4D"]
["2012-08-28",null,430852,null,"Tax Invoice",null,2052,null,null,null,null,null,"2012-08-28",430852,"2052D"]
["2012-09-04",null,431652,null,"Tax Invoice",null,4195.2,null,null,null,null,null,"2012-09-04",431652,"4195.2D"]
[]
[]
[]
[]
[]
[]
["120+ Days",null,"90 Days",null,"60 Days","30 Days",null,"Current",null,null,null,null,"Amount Due :",{"$f":"H54","v":10670.4}]
[null,null,null,null,null,{"$f":"SUM(G38:H43)","v":6475.2},null,{"$f":"G44","v":4195.2},null,null,null,null,"Amount Paid :",{"$f":"I37+I35+I28+I22","v":7502.01}]
[null,null,null,null,null,null,null,"Total Due",null,null,null,null,"Comments :"]
[null,null,null,null,null,null,null,{"$f":"SUM(A52:I52)","v":10670.4}]

{"sheet":"Delivery Note","index":21,"n_rows":56,"n_cols":12,"rows_kept":56,"cut":false,"hidden":false,"merged":[[16,8,16,9],[51,0,51,1],[15,8,15,9],[15,11,15,12],[22,8,22,9],[22,11,22,12],[16,11,16,12],[17,8,17,9],[17,11,17,12],[18,8,18,9],[18,11,18,12],[20,8,20,9],[21,8,21,9],[20,11,20,12],[21,11,21,12],[19,8,19,9],[19,11,19,12],[55,1,55,2],[55,3,55,5],[23,8,23,9],[23,11,23,12],[14,1,14,2],[0,0,0,2],[1,0,1,3],[2,0,2,3],[3,0,3,3],[4,0,4,3],[6,0,6,5]]}
[null,null,null,null,"Invoice No:","D00886"]
[null,null,null,null,"Date:",{"$f":"TODAY()","v":"2022-03-10"}]
["P.O. Box 2892, Delmas, 2210   \u009f   Cnr Road 10 and Driedoring Street, Delmas"]
["Tel: 013 668 0000   \u009f   Fax: 086 659 8207"]
["VAT Number: 4810183410"]
[]
["TAX INVOICE"]
[]
["SUPPLIER:",null,"SHIP TO:"]
[null,"CASH CUSTOMER",null,"Collect"]
[]
[null,"Att: Jaco"]
[]
[]
["LINE","DESCRIPTION",null,"QUANTITY","PRICE PER EA","TOTAL"]
[null,null,null,null,null,null,null,null,"Fuel Filter CX0708",null,1,"123.65"]
["1","FUEL FILTER (CX0708)",null,1,123.65,{"$f":"D17*E17","v":123.65},null,null,"Oil Filter     JX0810",null,1,"112.25"]
[2,"OIL FILTER (JX0810)",null,1,112.25,{"$f":"D18*E18","v":112.25},null,null,"Air Filter     TC26703",null,1,"379.85"]
[3,"AIR FILTER (TC26703)",null,1,379.85,379.85,null,null,"Cat Coolant 1L",null,1,"75.00"]
[4,"CAT COOLANT 1LT",null,1,75,75,null,null,"Multi Grade 15W40 20L",null,1,"1140.00"]
[5,"MULTI GRADE 15W40 20LT",null,1,1140,1140,null,null,"Radiator Cap Size 2",null,1,"185.50"]
[6,"RADIATOR CAP SIZE 2",null,1,185.5,185.5,null,null,"Door Sealer Spunge 10M",null,1,"345.00"]
[7,"DOOR SEALER SPUNGE 10M",null,1,345,345,null,null,"De-Grease Supreme 5L",null,1,"60.00"]
[8,"DE-GREASE SUPREME 5L",null,1,60,60,null,null,"3  Way 16 Amp IGN Swtch",null,1,445]
[9,"3 WAY 16 AMP IGN SWITCH",null,1,445,445]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Received in good condition:",null,null,null,"Total Stockroom Value:",{"$f":"SUM(F17:F49)","v":2866.25}]
[null,null,null,null,"VAT Total:",{"$f":"F50*0.14","v":401.27500000000003}]
["Signature",null,null,null,"Balance Due:",{"$f":"F50+F51","v":3267.5250000000001}]
[]
["Received in good condition:"]
[]
[null,"Signature",null,"Date"]

{"sheet":"Purchase Order","index":22,"n_rows":51,"n_cols":6,"rows_kept":51,"cut":false,"hidden":false,"merged":[[14,1,14,2],[49,0,49,5],[3,0,3,4],[4,0,4,4],[0,0,0,2],[1,0,1,3],[6,0,6,5]]}
[null,null,null,null,"Order Number:","PNG009"]
["Manufacturers of Hydraulic Components",null,null,null,"Order Date:",{"$f":"TODAY()","v":"2022-03-10"}]
["P.O. Box 2892, Delmas, 2210   \u009f   Cnr Road 10 and Driedoring Street, Delmas"]
["Tel: 013 668 0000   \u009f   Fax: 086 659 8207"]
["VAT Number: 4810183410"]
[]
["PURCHASE ORDER"]
[]
["SUPPLIER:",null,"SHIP TO:"]
[null,"ATLAS OIL & CHEMICAL DELMAS",null,"PREMAC"]
[null,"P.O. Box 6098",null,"Plot 58, c/o Road 10 and Driedoring St."]
[null,"Dunswart",null,"Delmas"]
[null,1508,null,"Mpumalanga"]
[]
["LINE","DESCRIPTION",null,"QTY","PRICE PER EA","TOTAL"]
[]
[null,"Please supply us with the following:"]
[]
["1","Rimula R4 X 15W40 CI-4-209LT",null,627,35.99,{"$f":"D19*E19","v":22565.73}]
[]
[2,"AF152 Engine Super, Radiator Coolant Concentrate 20Lt",null,20]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Total Stockroom Value:",{"$f":"SUM(F16:F46)","v":22565.73}]
[null,null,null,null,"VAT Total:",{"$f":"F47*15%","v":3384.8595}]
[null,null,null,null,"Balance Due:",{"$f":"SUM(F47:F48)","v":25950.589499999998}]
["For and on bahalf of   PREMAC, a division of AGRIGEL (PTY) Ltd."]
[null,null,null,"PURCHASING MANAGER"]

{"sheet":"Purchase Order - Ambrosales","index":23,"n_rows":51,"n_cols":6,"rows_kept":51,"cut":false,"hidden":false,"merged":[[14,1,14,2],[49,0,49,5],[0,0,0,2],[1,0,1,3],[2,0,2,3],[3,0,3,3],[4,0,4,3],[6,0,6,5]]}
[null,null,null,null,"Order Number:","PNG007"]
["Manufacturers of Hydraulic Components",null,null,null,"Order Date:",{"$f":"TODAY()","v":"2022-03-10"}]
["P.O. Box 2892, Delmas, 2210   \u009f   Cnr Road 10 and Driedoring Street, Delmas"]
["Tel: 013 668 0000   \u009f   Fax: 086 659 8207"]
["VAT Number: 4810183410"]
[]
["PURCHASE ORDER"]
[]
["SUPPLIER:",null,"SHIP TO:"]
[null,"VARCO INDUSTRIAL PRODUCTS",null,"Collect"]
[null,"Benoni"]
[]
[]
[]
["LINE","DESCRIPTION",null,"QUANTITY","PRICE PER EA","TOTAL"]
[]
[null,"Please get the following ready for Leon:"]
[]
["1","Oring - 2-119 in Viton",null,16]
[]
[2,"Oring - 2-117 in Viton",null,6]
[]
[3,"Oring - 2-210 in Viton",null,10]
[]
[4,"Oring - 2-118 in Viton",null,10]
[]
[5,"Oring - 2-022 in Viton",null,6]
[]
[6,"Oring - 2-023 in Viton",null,6]
[]
[7,"Oring - 3-910 in Viton",null,6]
[]
[8,"Oring - 2-015 in Viton",null,10]
[]
[9,"Oring - 2-016 in Viton",null,10]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Total Stockroom Value:",{"$f":"SUM(F16:F46)","v":0}]
[null,null,null,null,"VAT Total:",{"$f":"F47*14%","v":0}]
[null,null,null,null,"Balance Due:",{"$f":"SUM(F47:F48)","v":0}]
["For and on bahalf of   PREMAC, a division of AGRIGEL (PTY) Ltd."]
[null,null,null,"PURCHASING MANAGER"]

{"sheet":"Purchase Order - HDC","index":24,"n_rows":50,"n_cols":6,"rows_kept":50,"cut":false,"hidden":false,"merged":[[14,1,14,2],[48,0,48,5],[0,0,0,2],[1,0,1,3],[2,0,2,3],[3,0,3,3],[4,0,4,3],[6,0,6,5]]}
[null,null,null,null,"Order Number:","PNG006"]
["Manufacturers of Hydraulic Components",null,null,null,"Order Date:",{"$f":"TODAY()","v":"2022-03-10"}]
["P.O. Box 2892, Delmas, 2210   \u009f   Cnr Road 10 and Driedoring Street, Delmas"]
["Tel: 013 668 0000   \u009f   Fax: 086 659 8207"]
["VAT Number: 4810183410"]
[]
["PURCHASE ORDER"]
[]
["SUPPLIER:",null,"SHIP TO:"]
[null,"HIGH DUTY CASTINGS",null,"Collect"]
[null,"P.O. Box 157"]
[null,"Boksburg"]
[null,1460]
[]
["LINE","DESCRIPTION",null,"QUANTITY","PRICE PER EA","TOTAL"]
[]
[null,"Please supply us with the following:"]
[]
["1","BL 18859 - Selector Valves",null,100]
[]
[2,"BL 18848 - V150 Inlet Covers",null,100]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Total Stockroom Value:",{"$f":"SUM(F16:F45)","v":0}]
[null,null,null,null,"VAT Total:",{"$f":"F46*14%","v":0}]
[null,null,null,null,"Balance Due:",{"$f":"SUM(F46:F47)","v":0}]
["For and on bahalf of   PREMAC, a division of AGRIGEL (PTY) Ltd."]
[null,null,null,"PURCHASING MANAGER"]

{"sheet":"Purchase Order - KPL","index":25,"n_rows":50,"n_cols":6,"rows_kept":50,"cut":false,"hidden":false,"merged":[[6,0,6,5],[0,0,0,2],[1,0,1,3],[3,0,3,3],[48,0,48,5],[14,1,14,2],[2,0,2,3],[4,0,4,3],[26,1,26,2],[27,1,27,2]]}
[null,null,null,null,"Order Number:","PNG005"]
["Manufacturers of Hydraulic Components",null,null,null,"Order Date:",{"$f":"TODAY()","v":"2022-03-10"}]
["P.O. Box 2892, Delmas, 2210   \u009f   Cnr Road 10 and Driedoring Street, Delmas"]
["Tel: 013 668 0000   \u009f   Fax: 086 659 8207"]
["VAT Number: 4810183410"]
[]
["PURCHASE ORDER"]
[]
["SUPPLIER:",null,"SHIP TO:"]
[null,"KPL DIE CASTINGS",null,"Collect"]
[null,"P.O. Box 2624"]
[null,"Bedfordview"]
[null,2008]
[]
["LINE","DESCRIPTION",null,"QUANTITY","PRICE PER EA","TOTAL"]
[]
[null,"Please supply us with the following:"]
[]
[1,"3734 - Agrigel CAM",null,300]
[2,"3735 - AGRIGEL Piston",null,"balance of material"]
[]
[null,"in Azim 5 - to be delivered"]
[]
[]
[]
[]
[]
[null,"Please confirm price and advise on delivery date"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Total Stockroom Value:",{"$f":"SUM(F16:F45)","v":0}]
[null,null,null,null,"VAT Total:",{"$f":"F46*14%","v":0}]
[null,null,null,null,"Total PO Value:",{"$f":"SUM(F46:F47)","v":0}]
["For and on bahalf of   PREMAC, a division of AGRIGEL (PTY) Ltd."]
[null,null,null,"PURCHASING MANAGER"]

{"sheet":"Quotation","index":26,"n_rows":53,"n_cols":7,"rows_kept":53,"cut":false,"hidden":false,"merged":[[0,0,0,2],[1,0,1,3],[5,0,5,6],[6,0,6,6],[16,2,16,3],[2,0,2,3],[3,0,3,3],[4,0,4,3]]}
[]
["Manufacturers of Hydraulic Components",null,null,null,null,"Quote Number:","NG1066"]
["P.O. Box 2892, Delmas, 2210   \u009f   Cnr Road 10 and Driedoring Street, Delmas",null,null,null,null,"Date:",{"$f":"TODAY()","v":"2022-03-10"}]
["Tel: 013 668 0000   \u009f   Fax: 086 659 8207"]
["VAT Number: 4810183410"]
[]
["QUOTATION"]
[]
[]
["CUSTOMER:",null,null,"SHIP TO:"]
[null,"EHD COMPONENTS 2005 (PTY) Ltd",null,null,"Att: Franco van Deventer"]
[null,"Corner Hubert & Marshall Streets",null,null,"VAT No: 4790223137"]
[null,"Marshalltown"]
[null,"Johannesburg"]
[null,2001]
[]
["LINE","PART NO","DESCRIPTION",null,"QTY","PRICE EA","TOTAL"]
[]
[1,"V75-3","V75 3 Bank Control Valve",null,2,4340,{"$f":"E19*F19","v":8680}]
[]
[2,"V75-CS-4","V75 Center Section",null,2,1680,{"$f":"E21*F21","v":3360}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Subtotal:",{"$f":"SUM(G19:G50)","v":12040}]
[null,null,null,null,null,"VAT Total:",{"$f":"G51*0.15","v":1806}]
[null,null,null,null,null,"TOTAL:",{"$f":"SUM(G51:G52)","v":13846}]

{"sheet":"Quotation (2)","index":27,"n_rows":51,"n_cols":7,"rows_kept":51,"cut":false,"hidden":false,"merged":[[6,0,6,6],[17,2,17,3],[0,0,0,2],[1,0,1,3],[2,0,2,3],[3,0,3,3],[4,0,4,3],[5,0,5,6]]}
[]
["Manufacturers of Hydraulic Components",null,null,null,null,"Quotation Number:","FS1115"]
["P.O. Box 2892, Delmas, 2210   \u009f   Cnr Road 10 and Driedoring Street, Delmas",null,null,null,null,"Quotation Date:",{"$f":"TODAY()","v":"2022-03-10"}]
["Tel: 013 668 0000   \u009f   Fax: 086 659 8207"]
["VAT Number: 4810183410"]
[]
["QUOTATION"]
[]
["CUSTOMER:",null,null,"SHIP TO:"]
[null,"Safegas",null,null,"Collect"]
[null,"113 Stamford Hill Road"]
[null,"Greyville"]
[null,"Durban"]
[]
[null,"Att: Hamza"]
[null,"Tel: 084 714 4428"]
[]
["LINE","PART NO","DESCRIPTION",null,"QTY","PRICE EA","TOTAL"]
[]
[1,"FACE SHIELD","Face Shield (Medium)",null,1,45,{"$f":"E20*F20","v":45}]
[]
[2,"FACE SHIELD","Face Shield (Large)",null,1,45,{"$f":"E22*F22","v":45}]
[]
[3,"COURIER","The Courier Guy",null,1,110,{"$f":"E24*F24","v":110}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Subtotal:",{"$f":"SUM(G20:G48)","v":200}]
[null,null,null,null,null,"VAT Total:",{"$f":"(G49/1.15)*0.15","v":26.086956521739129}]
[null,null,null,null,null,"TOTAL:",{"$f":"G49","v":200}]

{"sheet":"STD Repair Quote (2)","index":28,"n_rows":55,"n_cols":9,"rows_kept":55,"cut":false,"hidden":false,"merged":[[6,0,6,8],[16,4,16,5],[17,4,17,5],[0,0,0,4],[1,0,1,5],[2,0,2,5],[3,0,3,5],[4,0,4,5],[5,0,5,8]]}
[]
["Manufacturers of Hydraulic Components",null,null,null,null,null,null,"Quotation Number:","NG1066"]
["P.O. Box 2892, Delmas, 2210   \u009f   Cnr Road 10 and Driedoring Street, Delmas",null,null,null,null,null,null,"Quotation Date:",{"$f":"TODAY()","v":"2022-03-10"}]
["Tel: 013 668 0000   \u009f   Fax: 086 659 8207"]
["VAT Number: 4810183410"]
[]
["VALVE REPAIR QUOTATION"]
[]
[]
["CUSTOMER:",null,null,null,null,"SHIP TO:"]
[null,null,"J.A. ENGINEERING",null,null,null,"Collect"]
[null,null,"Cnr Innes & Bismut Street"]
[null,null,"Jet Park"]
[]
[]
[]
["VALVE DETAILS :",null,null,null,"J401/1058 REXROTH VALVE"]
[null,null,null,null,"Serial Number: 5 / Job No: E3389"]
[]
[null,null,null,null,null,null,"QTY","PRICE EA","TOTAL"]
[]
[null,"A)","REPLACE SPOOL O/SIZE"]
[null,null,"1.","Grind and chrome"]
[null,null,"2.","Hone housing and fit spool"]
[null,"B)","PORT RELIEFS"]
[null,null,"1.","Replace"]
[null,null,"2.","Repair and replace parts"]
[null,"C)","LOAD HOLDING CHECK"]
[null,null,"1.","Replace poppet and spring"]
[null,null,"2.","Replace spring"]
[null,"D)","ANTI CAV CHECK"]
[null,null,"1.","Replace"]
[null,null,"2.","Repair"]
[null,"E)","MAIN RELIEF VALVE",null,null,null,null,"."]
[null,null,"1.","Replace"]
[null,null,"2.","Repair"]
[null,"F)","VALVE BODIES"]
[null,null,"1.","Work Sections - New"]
[null,null,"2.","Inlet Cover"]
[null,null,"3.","Outlet Cover"]
[null,null,"HANDLE ASSEMBLIES"]
[null,null,"HANDLE BRACKETS"]
[null,null,"BONNETS"]
[null,null,"SPRING ASSEMBLY (STANDARD)"]
[null,null,"SPRING ASSEMBLY (FLOAT)"]
[null,null,"SPRING ASSEMBLY (REGEN)"]
[null,null,"POWER BEYOND"]
[null,null,"CLEVIS"]
[null,null,"SEAL KIT",null,null,null,1,180,{"$f":"H49*G49","v":180}]
[null,null,"SUNDRY PARTS - LEVER, KNOB, BASE, BOOT",null,null,null,1,1460,{"$f":"H50*G50","v":1460}]
[null,null,"LABOUR, ASSEMBLY AND TEST",null,null,null,1,490,{"$f":"H51*G51","v":490}]
[]
[null,null,null,null,null,null,null,"Total Stockroom Value:",{"$f":"SUM(I22:I52)","v":2130}]
[null,null,null,null,null,null,null,"VAT Total:"]
[null,null,null,null,null,null,null,"Balance Due:",{"$f":"SUM(I53:I54)","v":2130}]

{"sheet":"STD Repair Quote (4)","index":29,"n_rows":55,"n_cols":9,"rows_kept":55,"cut":false,"hidden":false,"merged":[[6,0,6,8],[16,4,16,5],[17,4,17,5],[0,0,0,4],[1,0,1,5],[2,0,2,5],[3,0,3,5],[4,0,4,5],[5,0,5,8]]}
[]
["Manufacturers of Hydraulic Components",null,null,null,null,null,null,"Quotation Number:","NG1066"]
["P.O. Box 2892, Delmas, 2210   \u009f   Cnr Road 10 and Driedoring Street, Delmas",null,null,null,null,null,null,"Quotation Date:",{"$f":"TODAY()","v":"2022-03-10"}]
["Tel: 013 668 0000   \u009f   Fax: 086 659 8207"]
["VAT Number: 4810183410"]
[]
["VALVE REPAIR QUOTATION"]
[]
[]
["CUSTOMER:",null,null,null,null,"SHIP TO:"]
[null,null,"J.A. ENGINEERING",null,null,null,"Collect"]
[null,null,"Cnr Innes & Bismut Street"]
[null,null,"Jet Park"]
[]
[]
[]
["VALVE DETAILS :",null,null,null,"J401/1058 REXROTH VALVE"]
[null,null,null,null,"Serial Number: 5 / Job No: E3389"]
[]
[null,null,null,null,null,null,"QTY","PRICE EA","TOTAL"]
[]
[null,"A)","HYDRAULIC"]
[null,null,"1.","Repair/Replace spool section"]
[null,null,"2.","Chrome and grind, hone housing & fit/modify spool"]
[null,null,"3.","Port reliefs:"]
[null,null,null," -  Replace",null,null,1,null,{"$f":"G26*H26","v":0}]
[null,null,null," -  Test and adjust pressures",null,null,12,350,{"$f":"G27*H27","v":4200}]
[null,null,"4.","Inlet section seal kit",null,null,1,700,700]
[null,null,"5.","Spool section seal kit",null,null,8,750,6000]
[null,null,"6.","Outlet section seal kit",null,null,1,500,500]
[null,null,"7.","Spool seal kit",null,null,7,300,2100]
[null,null,"8.","Main relief valve: adjust, repair or replace",null,null,1,250,250]
[null,null,"9.","New fittings / repaired"]
[null,null,"10.","Sundry spares, cap screws, bolts, nuts and plates"]
[null,null,"11.","Spool stroke limiters"]
[null,null,"12.","Strip, clean, inspect and assess",null,null,6,750,{"$f":"G36*H36","v":4500}]
[null,null,"13.","Assembly",null,null,7,750,5250]
[null,null,"14.","Test, set flows and pressures",null,null,5,750,3750]
[]
[null,"B)","ELECTRICAL"]
[null,null,"1.","Test PC Boards, LEDs and Solenoids",null,null,8,200,{"$f":"G41*H41","v":1600}]
[null,null,"2.","Test proximity switches and adjust",null,null,8,350,2800]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Total Stockroom Value:",{"$f":"SUM(I22:I52)","v":31650}]
[null,null,null,null,null,null,null,"VAT Total:",{"$f":"I53*0.14","v":4431}]
[null,null,null,null,null,null,null,"Balance Due:",{"$f":"SUM(I53:I54)","v":36081}]

{"sheet":"STD Repair Quote (3)","index":30,"n_rows":54,"n_cols":9,"rows_kept":54,"cut":false,"hidden":false,"merged":[[6,0,6,8],[16,4,16,5],[17,4,17,5],[0,0,0,4],[1,0,1,5],[2,0,2,5],[3,0,3,5],[4,0,4,5],[5,0,5,8]]}
[]
["Manufacturers of Hydraulic Components",null,null,null,null,null,null,"Quotation Number:","NG1016"]
["P.O. Box 2892, Delmas, 2210   \u009f   Cnr Road 10 and Driedoring Street, Delmas",null,null,null,null,null,null,"Quotation Date:",{"$f":"TODAY()","v":"2022-03-10"}]
["Tel: 013 668 0000   \u009f   Fax: 086 659 8207"]
["VAT Number: 4810183410"]
[]
["VALVE REPAIR QUOTATION"]
[]
[]
["CUSTOMER:",null,null,null,null,"SHIP TO:"]
[null,null,"MALOMA COLLIERY LIMITED",null,null,null,"Collect"]
[null,null,"PO Box 103"]
[null,null,"Matata"]
[null,null,"Kingdom of Swaziland"]
[]
[]
["VALVE DETAILS :",null,null,null,"Possi Neutral Block"]
[null,null,null,null,"Serial Number: 91142"]
[]
[null,null,null,null,null,null,"QTY","PRICE EA","TOTAL"]
[]
[null,"A)","UNLOADING VALVE"]
[null,null,"1.","Replace"]
[null,null,"2.","Repair and replace parts",null,null,1,1480,{"$f":"H24*G24","v":1480}]
[null,"B)","PILOT CONTROL PRESSURE"]
[null,null,"1.","Replace"]
[null,null,"2.","Repair and replace parts"]
[null,"C)","LOAD HOLDING CHECK VALVE"]
[null,null,"1.","Replace"]
[null,null,"2.","Repair and replace parts",null,null,1,290,{"$f":"H30*G30","v":290}]
[null,"D)","STEEL BLOCK"]
[null,null,"1.","Replace"]
[null,null,"2.","Repair and replace parts"]
[null,"E)","MAIN RELIEF VALVE"]
[null,null,"1.","Replace"]
[null,null,"2.","Repair"]
[null,"F)","SEAL KIT",null,null,null,1,150,{"$f":"H37*G37","v":150}]
[null,"G)","LABOUR, ASSEMBLY AND TEST",null,null,null,1,550,{"$f":"H38*G38","v":550}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Total Stockroom Value:",{"$f":"SUM(I22:I51)","v":2470}]
[null,null,null,null,null,null,null,"VAT Total:"]
[null,null,null,null,null,null,null,"Balance Due:",{"$f":"SUM(I52:I53)","v":2470}]

{"sheet":"Quotation - Sandvik","index":31,"n_rows":56,"n_cols":7,"rows_kept":56,"cut":false,"hidden":false,"merged":[[14,2,14,3],[6,0,6,6],[5,0,5,6],[0,0,0,2],[1,0,1,3],[2,0,2,3],[3,0,3,3],[4,0,4,3]]}
[]
["Manufacturers of Hydraulic Components",null,null,null,null,"Quotation Number:","NG1126"]
["P.O. Box 2892, Delmas, 2210   \u009f   Cnr Road 10 and Driedoring Street, Delmas",null,null,null,null,"Quotation Date:",{"$f":"TODAY()","v":"2022-03-10"}]
["Tel: 013 668 0000   \u009f   Fax: 086 659 8207"]
["VAT Number: 4810183410"]
[]
["QUOTATION"]
[]
["CUSTOMER:",null,null,"SHIP TO:"]
[null,"SANDVIK MINING RSA (PTY) Ltd",null,null,"1 Flambojant Street"]
[null,"P.O. Box 57",null,null,"Delmas"]
[null,"Delmas"]
[null,2210]
[]
["LINE","PART NO","DESCRIPTION",null,"QTY","PRICE","TOTAL"]
[]
[1,"V150-5-TH","V150 5 Spool Valve Bank, Tyre Handler",null,1,17200,{"$f":"E17*F17","v":17200}]
[null,null,"5 Spools"]
[null,null,"Lever operated B port"]
[null,null,"Port reliefs on all ports"]
[null,null,"Main relief"]
[null,null,"All standard work sections"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Total Stockroom Value:",{"$f":"SUM(G16:G53)","v":17200}]
[null,null,null,null,null,"VAT Total:",{"$f":"G54*15%","v":2580}]
[null,null,null,null,null,"Balance Due:",{"$f":"G54+G55","v":19780}]

{"sheet":"Quotation - Sandvik (2)","index":32,"n_rows":56,"n_cols":7,"rows_kept":56,"cut":false,"hidden":false,"merged":[[6,0,6,6],[16,2,16,3],[16,4,16,5],[18,2,18,3],[0,0,0,2],[1,0,1,3],[2,0,2,3],[3,0,3,3],[4,0,4,3],[5,0,5,6]]}
[]
["Manufacturers of Hydraulic Components",null,null,null,null,"Quotation Number:","DSAC130618"]
["P.O. Box 2892, Delmas, 2210   \u009f   Cnr Road 10 and Driedoring Street, Delmas",null,null,null,null,"Quotation Date:",{"$f":"TODAY()","v":"2022-03-10"}]
["Tel: 013 668 0000   \u009f   Fax: 086 659 8207"]
["VAT Number: 4810183410"]
[]
["REPAIR QUOTATION"]
[]
["CUSTOMER:",null,null,"SHIP TO:"]
[null,"SANDVIK MINING RSA (PTY) Ltd",null,null,"1 Flambojant Street"]
[null,"P.O. Box 57",null,null,"Delmas"]
[null,"Delmas"]
[null,2210]
[]
["HEREUNDER PLEASE FIND THE DETAILS FOR REPAIR OF THE FOLLOWING MACHINE NUMBER:"]
[]
[null,"Machine Number:","Delivery Note: 150996 / SMCL No: 7121212"]
[]
["LINE","PART NO","DESCRIPTION",null,"QTY","PRICE","TOTAL"]
[]
[1,"VALVE REPAIR","3 Spool Pilot Controller",null,null,null,{"$f":"SUM(F22:F24)","v":3910}]
[null,null,"  - Miscellaneous parts (plugs, knobs, etc.)",null,1,2780]
[null,null,"  - Seal Kit",null,1,210]
[null,null,"  - Labour, Assembly and Test",null,1,920]
[]
[2,"VALVE REPAIR","4lt Accumulator",null,null,null,{"$f":"SUM(F27:F31)*2","v":9860}]
[null,null,"  - Barrel: Hone, repair and/or replace parts",null,2,3080]
[null,null,"  - Seal Kit",null,2,450]
[null,null,"  - End Caps: Inspect, repair and replace parts",null,2,390]
[null,null,"  - Pre-charge accumulator",null,2,250]
[null,null,"  - Labour, Assembly and Test",null,2,760]
[]
[3,"VALVE REPAIR","1lt Accumulator",null,null,null,{"$f":"SUM(F34:F35,F37:F38)+E36*F36","v":3980}]
[null,null,"  - Barrel: Hone, repair and/or replace parts",null,1,2300]
[null,null,"  - Seal Kit",null,1,450]
[null,null,"  - End Caps: Inspect, repair and replace parts",null,2,250]
[null,null,"  - Pre-charge accumulator",null,1,250]
[null,null,"  - Labour, Assembly and Test",null,1,480]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Total Stockroom Value:",{"$f":"SUM(G20:G53)","v":17750}]
[null,null,null,null,null,"VAT Total:",{"$f":"G54*14%","v":2485.0000000000005}]
[null,null,null,null,null,"Balance Due:",{"$f":"G54+G55","v":20235}]

{"sheet":"Quotation - AngloGold","index":33,"n_rows":54,"n_cols":7,"rows_kept":54,"cut":false,"hidden":false,"merged":[[5,0,5,6],[0,0,0,2],[1,0,1,3],[2,0,2,3],[3,0,3,3],[4,0,4,3],[15,2,15,3],[23,2,23,3],[26,2,26,3],[27,2,27,3],[6,0,6,6]]}
[]
["Manufacturers of Hydraulic Components",null,null,null,null,"Quotation Number:","NG695"]
["P.O. Box 2892, Delmas, 2210   \u009f   Cnr Road 10 and Driedoring Street, Delmas",null,null,null,null,"Quotation Date:",{"$f":"TODAY()","v":"2022-03-10"}]
["Tel: 013 668 0000   \u009f   Fax: 086 659 8207"]
["VAT Number: 4810183410"]
[]
["QUOTATION"]
[]
["CUSTOMER:",null,null,"SHIP TO:"]
[null,"ANGLOGOLD ASHANTI",null,null,"Mponeng Mine"]
[null,"Offsite Repairs West Wits"]
[]
[null,"ATT: Ernest Wienand"]
[null,"FAX: 018 700 4050"]
[]
["LINE","PART NO","DESCRIPTION",null,"QTY","PRICE EA","TOTAL"]
[]
[null,"Work Request/Order Number: 31/291HS"]
[null,"Workshop Order Number: 100/321920"]
[]
[1,"SERVICE EXCHANGE UNIT",null,null,1,6400,{"$f":"F21*E21","v":6400}]
[null,null,"Eimco 913 Control Valve, 3 Spool"]
[]
[2,"NEW UNIT","Eimco 913 Control Valve, 3 Spool",null,1,12130]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Total Stockroom Value:",{"$f":"SUM(G17:G51)","v":6400}]
[null,null,null,null,null,"VAT Total:",{"$f":"G52*14%","v":896.00000000000011}]
[null,null,null,null,null,"Balance Due:",{"$f":"G52+G53","v":7296}]

{"sheet":"STD Repair Quote","index":34,"n_rows":55,"n_cols":9,"rows_kept":55,"cut":false,"hidden":false,"merged":[[6,0,6,8],[16,4,16,5],[17,4,17,5],[0,0,0,4],[1,0,1,5],[2,0,2,5],[3,0,3,5],[4,0,4,5],[5,0,5,8]]}
[]
["Manufacturers of Hydraulic Components",null,null,null,null,null,null,"Quotation Number:","NG820"]
["P.O. Box 2892, Delmas, 2210   \u009f   Cnr Road 10 and Driedoring Street, Delmas",null,null,null,null,null,null,"Quotation Date:",{"$f":"TODAY()","v":"2022-03-10"}]
["Tel: 013 668 0000   \u009f   Fax: 086 659 8207"]
["VAT Number: 4810183410"]
[]
["VALVE REPAIR QUOTATION"]
[]
[]
["CUSTOMER:",null,null,null,null,"SHIP TO:"]
[null,null,"MALOMA COLLIERY LTD",null,null,null,"Collect"]
[null,null,"PO Bo 103"]
[null,null,"Matata"]
[null,null,"Kingdom of Swaziland"]
[]
[]
["VALVE DETAILS :",null,null,null,"V150 2 Bank, Steering and Eject Valve"]
[null,null,null,null,"Serial No: RF13"]
[]
[null,null,null,null,null,null,"QTY","PRICE EA","TOTAL"]
[]
[null,"A)","REPLACE SPOOL O/SIZE"]
[null,null,"1.","Grind and chrome"]
[null,null,"2.","Hone housing and fit spool"]
[null,"B)","PORT RELIEFS"]
[null,null,"1.","Replace"]
[null,null,"2.","Repair and replace parts",null,null,2,850,{"$f":"H27*G27","v":1700}]
[null,"C)","LOAD HOLDING CHECK"]
[null,null,"1.","Replace poppet and spring"]
[null,null,"2.","Replace spring"]
[null,"D)","ANTI CAV CHECK"]
[null,null,"1.","Replace"]
[null,null,"2.","Repair"]
[null,"E)","MAIN RELIEF VALVE"]
[null,null,"1.","Replace"]
[null,null,"2.","Repair",null,null,1,1320,{"$f":"H36*G36","v":1320}]
[null,"F)","VALVE BODIES"]
[null,null,"1.","Work Sections"]
[null,null,"2.","Inlet Cover"]
[null,null,"3.","Outlet Cover"]
[null,null,"HANDLE ASSEMBLIES"]
[null,null,"HANDLE BRACKETS"]
[null,null,"BONNETS"]
[null,null,"SPRING ASSEMBLY (STANDARD)"]
[null,null,"SPRING ASSEMBLY (FLOAT)"]
[null,null,"SPRING ASSEMBLY (REGEN)"]
[null,null,"CLEVIS"]
[null,null,"SEAL KIT",null,null,null,1,450,{"$f":"H48*G48","v":450}]
[]
[null,null,"LABOUR, ASSEMBLY AND TEST",null,null,null,1,900,{"$f":"H50*G50","v":900}]
[]
[]
[null,null,null,null,null,null,null,"Total Stockroom Value:",{"$f":"SUM(I22:I52)","v":4370}]
[null,null,null,null,null,null,null,"VAT Total:",0]
[null,null,null,null,null,null,null,"Balance Due:",{"$f":"SUM(I53:I54)","v":4370}]

{"sheet":"AGRIGEL Quote","index":35,"n_rows":54,"n_cols":7,"rows_kept":54,"cut":false,"hidden":false,"merged":[[34,2,34,3],[16,2,16,3],[0,0,0,2],[1,0,1,2],[2,0,2,2],[6,0,6,6],[3,0,3,2],[4,0,4,2],[33,2,33,3]]}
[]
[null,null,null,null,null,"Quotation Number:","AG529"]
[null,null,null,null,null,"Quotation Date:",{"$f":"TODAY()","v":"2022-03-10"}]
["Tel: 013 668 0000   Fax: 086 659 8207"]
["REG No: 1998/24699/07   V AT No: 4810183410"]
[]
["QUOTATION"]
[]
[]
["CUSTOMER:",null,null,"SHIP TO:"]
[null,"CLAYTON BUTLER",null,null,"Email: clayton@truenw.co.za"]
[]
[]
[]
[]
[]
["LINE","PART NO","DESCRIPTION",null,"QTY","PRICE EA","TOTAL"]
[]
[1,"LFP-6","6 Row Liquid Fertiliser Pump",null,1,11760,{"$f":"E19*F19","v":11760}]
[]
[2,"LFM-100","Monitor",null,6,185,{"$f":"E21*F21","v":1110}]
[]
[3,"LFC-200","End of line check valve",null,6,165,{"$f":"E23*F23","v":990}]
[]
[]
[null,"Optional/Recommended Extras"]
[]
[null,"LFF-100","Filter",null,null,500]
[]
[null,"SPARES","40mm Valves",null,null,150]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Total Stockroom Value:",{"$f":"SUM(G19:G51)","v":13860}]
[null,null,null,null,null,"VAT Total:",{"$f":"G52*14%","v":1940.4}]
[null,null,null,null,null,"Balance Due:",{"$f":"G52+G53","v":15800.4}]

{"sheet":"AGRIGEL Purchase ORder","index":36,"n_rows":54,"n_cols":7,"rows_kept":54,"cut":false,"hidden":false,"merged":[[51,0,51,2],[52,0,52,1],[17,1,17,3],[0,0,0,2],[1,0,1,2],[2,0,2,2],[3,0,3,2],[4,0,4,2],[6,0,6,6]]}
[]
[null,null,null,null,null,"PURCHASE ORDER NUMBER:","ANG111"]
[null,null,null,null,null," Date:",{"$f":"TODAY()","v":"2022-03-10"}]
["Tel: 013 668 0000   Fax: 086 659 8207"]
["REG No: 1998/24699/07   V AT No: 4810183410"]
[]
["PURCHASE ORDER"]
[]
["SUPPLIER:"]
[null,"PLASTAMID"]
[null,"Kempton Park"]
[]
[null,"Att: Renee Brennan"]
[]
[]
[null,"Please supply us with the following:"]
[]
["LINE","DESCRIPTION",null,null,"QTY","PRICE EA","TOTAL"]
[]
[1,"Hytrel 4056 (per kg)",null,null,150,178.3,{"$f":"E20*F20","v":26745}]
[]
[2,"Hytrel 3078 (per kg)",null,null,25,0,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["For and on behalf of Agrigel (PTY) Ltd.",null,null,null,null,"Total Stockroom Value:",{"$f":"SUM(G20:G51)","v":26745}]
["Purchasing Manager:",null,null,null,null,"VAT Total:",{"$f":"G52*15%","v":4011.75}]
[null,null,null,null,null,"PO Value:",{"$f":"G52+G53","v":30756.75}]

{"sheet":"AGRIGEL Tax Invoice","index":37,"n_rows":58,"n_cols":7,"rows_kept":58,"cut":false,"hidden":false,"merged":[[57,1,57,2],[57,3,57,5],[53,0,53,1],[16,2,16,3],[0,0,0,2],[1,0,1,2],[2,0,2,2],[3,0,3,2],[4,0,4,2],[6,0,6,6]]}
[]
[null,null,null,null,null,"Tax Invoice Number:","AG518"]
[null,null,null,null,null,"Invoice Date:","2015-08-28"]
["Tel: 013 668 0000   Fax: 086 659 8207"]
["REG No: 1998/24699/07   V AT No: 4810183410"]
[]
["TAX INVOICE"]
[]
[]
["CUSTOMER:",null,null,"SHIP TO:","Collect"]
[null,"MJ POTGIETER"]
[null,"12 Tsitsikamma"]
[null,"30 Karee Avenue"]
[null,"Delmas"]
[null,2210]
[]
["LINE","PART NO","DESCRIPTION",null,"QTY","PRICE EA","TOTAL"]
[]
[1,"LFP-11","Serviced - 11 Row Liquid Fertilizer Pump",null,4,570,{"$f":"E19*F19","v":2280}]
[null,null,"Complete with monitors"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Received in good condition:",null,null,null,null,"Total Stockroom Value:",{"$f":"SUM(G19:G51)","v":2280}]
[null,null,null,null,null,"VAT Total:",0]
["Signature",null,"Date",null,null,"Balance Due:",{"$f":"G52+G53","v":2280}]
[]
["Received in good condition:"]
[]
[null,"Signature",null,"Date"]

{"sheet":"AGRIGEL Delivery Note","index":38,"n_rows":55,"n_cols":7,"rows_kept":55,"cut":false,"hidden":false,"merged":[[16,2,16,3],[54,1,54,2],[54,3,54,6],[0,0,0,2],[1,0,1,2],[2,0,2,2],[3,0,3,2],[4,0,4,2],[6,0,6,6]]}
[]
[null,null,null,null,null,"Delivery Note Number:","AG513"]
[null,null,null,null,null,"Date:",{"$f":"TODAY()","v":"2022-03-10"}]
["Tel: 013 668 0000   Fax: 086 659 8207"]
["REG No: 1998/24699/07   V AT No: 4810183410"]
[]
["DELIVERY NOTE"]
[]
[]
["CUSTOMER:",null,null,"SHIP TO:","Collect"]
[null,"FERTEX SOLUTIONS"]
[null,"P.O. Box 170"]
[null,"Big Bend"]
[null,"L311"]
[null,"Swaziland"]
[]
["LINE","PART NO","DESCRIPTION",null,"QTY","PRICE EA","TOTAL"]
[]
[1,"SERVICE-11","Serviced - 11 Row Liquid Fertilizer Pump",null,4]
[null,null,"Complete with check valves and monitors"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Received in good condition:"]
[]
[null,"Signature",null,"Date"]

{"sheet":"AGRIGEL Statement","index":39,"n_rows":55,"n_cols":7,"rows_kept":55,"cut":false,"hidden":false,"merged":[[0,0,0,3],[0,5,0,6],[1,0,1,3],[2,0,2,3],[18,0,18,1],[3,0,3,6],[4,0,4,6],[17,0,17,1],[54,0,54,1],[9,5,9,6],[19,0,19,1],[20,0,20,1],[7,5,8,6],[14,0,14,1],[14,2,14,3],[22,0,22,1],[21,0,21,1],[16,0,16,1]]}
[]
["Tel: 013 668 0000   \u009f   Fax: 086 659 8207"]
["VAT Number: 4810183410"]
[]
["STATEMENT"]
[]
[]
[null,"P.R. CILLIERS",null,null,null,"STATEMENT DATE:"]
[null,"Posbus 126"]
[null,"Balfour",null,null,null,{"$f":"TODAY()","v":"2022-03-10"}]
[null,2410]
[null,"Fax: 017 773 1007"]
[]
[]
["DATE",null,"TRANSACTION",null,null,"AMOUNT","BALANCE"]
[]
["2010-12-02",null,"Tax Invoice - 1106",null,null,7535.4,{"$f":"F17","v":7535.4}]
["2012-09-03",null,"Tax Invoice - AI0231",null,null,12517.2,{"$f":"G17+F18","v":20052.599999999999}]
["2012-11-01",null,"Credit Note - 1106",null,null,-7535.4,{"$f":"G18+F19","v":12517.199999999999}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["+ 90 Days",null,"90 Days","60 Days","30 Days","Current","Total Due"]
[null,null,{"$f":"F18","v":12517.2},null,null,null,{"$f":"SUM(A55:F55)","v":12517.2}]

{"sheet":"AGRIGEL Credit Note","index":40,"n_rows":57,"n_cols":6,"rows_kept":57,"cut":false,"hidden":false,"merged":[[16,1,16,2],[0,0,0,1],[1,0,1,1],[2,0,2,1],[3,0,3,1],[4,0,4,1],[6,0,6,5]]}
["Tegnologie vir die landbou"]
["AGRIGEL",null,null,null,"Credit Note No:","CN00125"]
["Agricultural Technology",null,null,null,"Date:",{"$f":"TODAY()","v":"2022-03-10"}]
["Tel: 087 754 4747   Fax: 086 659 8207"]
["REG No: 81/01176/07   V AT No: 4430110512"]
[]
["CREDIT NOTE"]
[]
[]
["CUSTOMER:"]
[null,"NWK Beperk",null,"Vloeibare Kunsmisaanleg"]
[null,"Posbus 107",null,"1E Laan Verlenging"]
[null,"Lichtenburg",null,"Lottieshalte"]
[null,2740,null,"Lichtenburg"]
[]
[]
["LINE","DESCRIPTION",null,null,"QUANTITY","PRICE"]
[]
[1,"6 Row Converted to 8 Row",null,null,3,1685.2]
[null,"Danie Erasmus - 20% discount"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Total Stockroom Value:",{"$f":"F19","v":1685.2}]
[null,null,null,null,"VAT Total:",{"$f":"F55*14%","v":235.92800000000003}]
[null,null,null,null,"Credit Balance:",{"$f":"F55+F56","v":1921.1280000000002}]

{"sheet":"InfantMed Statement","index":41,"n_rows":54,"n_cols":7,"rows_kept":54,"cut":false,"hidden":false,"merged":[[53,0,53,1],[0,0,0,3],[1,5,1,6],[2,5,2,6],[3,0,3,3],[4,0,4,3],[1,0,1,4],[5,0,5,6],[6,0,6,6],[14,0,14,1],[14,2,14,3],[16,0,16,1]]}
[]
["a division of AGRIGEL (PTY) Ltd.",null,null,null,null,"STATEMENT"]
["P.O. Box 2892, Delmas, 2210   \u009f   Cnr Road 10 and Driedoring Street, Delmas",null,null,null,null,"AUGUST 2013"]
["Tel: 013 668 0000   \u009f   Fax: 086 659 8207"]
["VAT Number: 4810183410"]
[]
["STATEMENT"]
[]
[]
[null,"QUECK BABY"]
[null,"Att: Melinda Queck"]
[]
[]
[]
["DATE",null,"TRANSACTION",null,null,"AMOUNT","BALANCE"]
[]
["2013-08-05",null,"Tax Invoice - II0671",null,null,570,{"$f":"F17","v":570}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["+ 90 Days",null,"90 Days","60 Days","30 Days","Current","Total Due"]
[null,null,null,null,null,{"$f":"G17","v":570},{"$f":"G17","v":570}]