{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["NAT TOT  BOX COUNT","BOXES PER REGION","RATE CONS","RELOCATION COSTS"],"not_rendered":{"images":1},"read":"whole","date_system":"1900"}

{"sheet":"NAT TOT  BOX COUNT","index":0,"n_rows":17,"n_cols":6,"rows_kept":17}
[]
[]
[]
["National Box Count",{"$nulls":3},"Forecated Intransit Boxes 10%","TOTAL"]
[null,"SB1","Storage Voucher Boxes",{"v":8,"d":"8.00"},{"$f":"D5*10%","v":{"v":0.8,"d":"0.80"}},{"$f":"E5+D5","v":{"v":8.8,"d":"8.80"}}]
[null,"SB2","Storage Fnb Special Boxes",{"v":1,"d":"1.00"},{"$f":"D6*10%","v":{"v":0.1,"d":"0.10"}},{"$f":"E6+D6","v":{"v":1.1,"d":"1.10"}}]
[null,"SBF1","Storage Metal Trays",{"v":825,"d":"825.00"},{"v":82.5,"d":"82.50"},{"v":907.5,"d":"907.50"}]
[null,"SM1","Storage M1 Boxes",{"v":5,"d":"5.00"},{"v":0.5,"d":"0.50"},{"v":5.5,"d":"5.50"}]
[null,"SM2","Storage M2 Boxes",{"v":196401,"d":"196,401.00"},{"v":19640.100000000002,"d":"19,640.10"},{"v":216041.1,"d":"216,041.10"}]
[null,"SM3","Storage M3 Boxes",{"v":16479,"d":"16,479.00"},{"v":1647.9,"d":"1,647.90"},{"v":18126.9,"d":"18,126.90"}]
[null,"SM4","Storage M4 Boxes",{"v":10,"d":"10.00"},{"v":1,"d":"1.00"},{"v":11,"d":"11.00"}]
[null,"SMX3","Storage",{"v":26,"d":"26.00"},{"v":2.6,"d":"2.60"},{"v":28.6,"d":"28.60"}]
[null,"SNHLS","Slides",{"v":456,"d":"456.00"},{"v":45.6,"d":"45.60"},{"v":501.6,"d":"501.60"}]
[null,"SS2","Storage S2 Boxes",{"v":2,"d":"2.00"},{"v":0.2,"d":"0.20"},{"v":2.2,"d":"2.20"}]
[null,"ST3","Storage X Large Tubes",{"v":4,"d":"4.00"},{"v":0.4,"d":"0.40"},{"v":4.4,"d":"4.40"}]
[]
[null,"GRAND TOTAL",null,{"$f":"SUM(D5:D16)","v":{"v":214217,"d":"214,217.00"}},{"v":21421.7,"d":"21,421.70"},{"$f":"SUM(F5:F16)","v":{"v":235638.7,"d":"235,638.70"}}]

{"sheet":"BOXES PER REGION","index":1,"n_rows":35,"n_cols":15,"rows_kept":35}
[]
[]
["NHLS NATIONAL BOX COUNT AS AT 31/05/2025"]
["Site ","Box Size","Description","Qty","Forecated Intransit Boxes 10%","Total"," Storage Cost",null,"Site ","Box Size","Description","Qty","Forecated Intransit Boxes 10%","Total"," Storage Cost"]
["Bloemfontein","SBF1","Storage Metal Trays",{"v":825,"d":"825.00"},{"$f":"D5*10%","v":{"v":82.5,"d":"82.50"}},{"$f":"D5+E5","v":{"v":907.5,"d":"907.50"}},null,null,"Empangeni","SM2","Storage M2 Boxes",{"v":12910,"d":"12,910.00"},{"$f":"L5*10%","v":{"v":1291,"d":"1,291.00"}}]
[null,"SM2","Storage M2 Boxes",{"v":11302,"d":"11,302.00"},{"$f":"D6*10%","v":{"v":1130.2,"d":"1,130.20"}},{"$f":"D6+E6","v":{"v":12432.2,"d":"12,432.20"}},{"$nulls":3},"SM3","Storage M3 Boxes",{"v":148,"d":"148.00"},{"$f":"L6*10%","v":{"v":14.8,"d":"14.80"}}]
[null,"SM3","Storage M3 Boxes",{"v":330,"d":"330.00"},{"v":33,"d":"33.00"},{"v":363,"d":"363.00"},{"$nulls":3},"SMX3","Storage",{"v":26,"d":"26.00"},{"v":2.6,"d":"2.60"}]
[null,null,"TOTAL",{"$nulls":7},"TOTAL"]
[]
[]
["Cape Town",{"$nulls":7},"Johannesburg"]
[null,"SB2","Storage Fnb Special Boxes",{"v":1,"d":"1.00"},{"$f":"D12*10%","v":{"v":0.1,"d":"0.10"}},{"$nulls":4},"SB1","Storage Voucher Boxes",{"v":8,"d":"8.00"},{"$f":"L12*10%","v":{"v":0.8,"d":"0.80"}}]
[null,"SM1","Storage M1 Boxes",{"v":1,"d":"1.00"},{"v":0.1,"d":"0.10"},{"$nulls":4},"SM1","Storage M1 Boxes",{"v":1,"d":"1.00"},{"v":0.1,"d":"0.10"}]
[null,"SM2","Storage M2 Boxes",{"v":11511,"d":"11,511.00"},{"v":1151.1000000000001,"d":"1,151.10"},{"$nulls":4},"SM2","Storage M2 Boxes",{"v":42899,"d":"42,899.00"},{"v":4289.900000000001,"d":"4,289.90"}]
[null,"SM3","Storage M3 Boxes",{"v":1346,"d":"1,346.00"},{"v":134.6,"d":"134.60"},{"$nulls":4},"SM3","Storage M3 Boxes",{"v":14198,"d":"14,198.00"},{"v":1419.8000000000002,"d":"1,419.80"}]
[null,null,"TOTAL",{"$nulls":6},"SM4","Storage M4 Boxes",{"v":10,"d":"10.00"},{"v":1,"d":"1.00"}]
[{"$nulls":9},"SS2","Storage S2 Boxes",{"v":2,"d":"2.00"},{"v":0.2,"d":"0.20"}]
[{"$nulls":10},"TOTAL"]
["Durban",{"$nulls":7},"Nelspruit"]
[{"$nulls":9},"SM1","Storage M1 Boxes",{"v":1,"d":"1.00"},{"$f":"L20*10%","v":{"v":0.1,"d":"0.10"}}]
[null,"SM2","Storage M2 Boxes",{"v":45813,"d":"45,813.00"},{"$f":"D21*10%","v":{"v":4581.3,"d":"4,581.30"}},{"$nulls":4},"SM2","Storage M2 Boxes",{"v":9250,"d":"9,250.00"},{"v":925,"d":"925.00"}]
[null,"SM3","Storage M3 Boxes",{"v":27,"d":"27.00"},{"v":2.7,"d":"2.70"},{"$nulls":4},"SM3","Storage M3 Boxes",{"v":1,"d":"1.00"},{"v":0.1,"d":"0.10"}]
[null,null,"TOTAL"]
[]
["East London",{"$nulls":7},"Polokwane"]
[null,"SNHLS","Slides",{"v":318,"d":"318.00"},{"$f":"D26*10%","v":{"v":31.8,"d":"31.80"}},{"$nulls":4},"SM2","Storage M2 Boxes",{"v":12787,"d":"12,787.00"},{"$f":"L26*10%","v":{"v":1278.7,"d":"1,278.70"}}]
[null,"SM2","Storage M2 Boxes",{"v":22197,"d":"22,197.00"},{"v":2219.7000000000003,"d":"2,219.70"},{"$nulls":4},"SM3","Storage M3 Boxes",{"v":136,"d":"136.00"},{"v":13.600000000000001,"d":"13.60"}]
[{"$nulls":10},"TOTAL"]
[]
["Port Elizabeth",{"$nulls":7},"Pretoria"]
[null,"SM2","Storage M2 Boxes",{"v":11678,"d":"11,678.00"},{"$f":"D31*10%","v":{"v":1167.8,"d":"1,167.80"}},{"$nulls":4},"SM1","Storage M1 Boxes",{"v":2,"d":"2.00"},{"$f":"L31*10%","v":{"v":0.2,"d":"0.20"}}]
[null,"SM3","Storage M3 Boxes",{"v":117,"d":"117.00"},{"$f":"D32*10%","v":{"v":11.700000000000001,"d":"11.70"}},{"$nulls":4},"SM2","Storage M2 Boxes",{"v":16054,"d":"16,054.00"},{"v":1605.4,"d":"1,605.40"}]
[null,"SNHLS","Slides",{"v":138,"d":"138.00"},{"v":13.8,"d":"13.80"},{"$nulls":4},"SM3","Storage M3 Boxes",{"v":176,"d":"176.00"},{"v":17.6,"d":"17.60"}]
[null,null,"TOTAL",{"$nulls":6},"ST3","Storage X Large Tubes",{"v":4,"d":"4.00"},{"v":0.4,"d":"0.40"}]
[{"$nulls":10},"TOTAL"]

{"sheet":"RATE CONS","index":2,"n_rows":17,"n_cols":5,"rows_kept":17,"merged":[[3,0,4,0],[15,0,16,3]]}
[]
[]
["RATE CONSOLIDATION"]
["Proposed NHLS Allocation","Year 1(Inclusive of Forecasting + VAT)","Year 2(Inclusive of Forecasting + VAT)","Year 3(Inclusive of Forecasting + VAT)"," 3-Years TOTAL"]
[]
["Nelspruit","R","R","R","R"]
["Johannesburg","R","R","R","R"]
["Empangeni","R","R","R","R"]
["Cape Town","R","R","R","R"]
["Durban","R","R","R","R"]
["East London","R","R","R","R"]
["Pretoria","R","R","R","R"]
["Bloemfontein","R","R","R","R"]
["Polokwane","R","R","R","R"]
["Port Elizabeth","R","R","R","R"]
[{"$nulls":4},"Grand Total"]
[{"$nulls":4},"R"]

{"sheet":"RELOCATION COSTS","index":3,"n_rows":14,"n_cols":6,"rows_kept":14}
[]
[]
["ONCE OFF RELOCATION COSTS"]
[null,null,"COSTING FOR TRANSPORT DISTRIBUTION"]
["COLLECTION POINT:","SUPPLIER STORAGE ADRESS","RATE  PER  BOX:INCLUDING HANDLING AND PACKING","QUANTITY OF BOXES","KM's","TOTAL"]
["Eastern Cape:25 Stormberg Road, Gately, East London"]
["Free State:8 Clarkson Street, Estoire, Bloemfontein"]
["Western Cape:1 Munich Street, Airport Industria"]
["KZN:1-3 Clubhouse Place, Mahogany Ridge, Westmead, Pinetown, KZN, 3608"]
["Mpumalanga:7 White Water Street, Riverside, Nelspruit"]
["Gauteng: 3 Gowie Road, The Gables, Cleveland, Gauteng, 2022"]
["Limpopo :1 Daniel Street, Industria"]
["Northern Cape :8 Clarkson Street, Estoire, Bloemfontein"]
["Total"]