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

{"sheet":"Sheet1","index":0,"n_rows":44,"n_cols":21,"rows_kept":44,"merged":[[0,0,0,20],[1,0,1,14],[3,2,3,20],[4,8,5,9],[4,10,5,11],[4,12,5,13],[4,14,5,15],[4,16,5,17],[4,18,5,19],[7,0,39,0],[7,1,39,1]]}
["Transportation of Wheels for Transnet Engineering, Koedoespoort Depot"]
[]
[]
["Vendor Name: "]
[{"$nulls":8},"Year 1",null,"Year 2",null,"Year 3",null,"Year 1",null,"Year 2",null,"Year 3"]
[]
["Centre","Truck requirements","Route","KM\n(Return) GPS","Estimate Number of Trips (YEAR 1)","Estimate Number of Trips (YEAR 2)","Estimate Number of Trips (YEAR 3)","Class (Distance)","Rate per KM  (1st 6months)","Rate per KM  (2nd 6months)","Rate per KM  (3rd 6months)","Rate per KM  (4th 6months)","Rate per KM  (5th 6months)","Rate per KM  (6th 6months)","Rate per route (Return trip) (1st 6months)","Rate per route (Return trip) (2nd 6months)","Rate per route (Return trip) (3rd 6months)","Rate per route (Return trip) (4th 6months)","Rate per route (Return trip) (5th 6months)","Rate per route (Return trip) (6th 6months)","Total Price for all trips (Route)"]
["Koedoespoort","4x Superlinks, 2x Triaxle, 1x 12 Ton\n","Danskraal / Ladysmith",{"$f":"413*2*1.05","v":{"v":867.3000000000001,"d":"867"}},{"v":13.333333333333334,"d":"13"},{"v":13.333333333333334,"d":"13"},{"v":13.333333333333334,"d":"13"},"Long",null,{"$f":"I8*1.04","v":0},{"$f":"J8*1.04","v":0},{"$f":"K8*1.04","v":0},{"$f":"L8*1.04","v":0},{"$f":"M8*1.04","v":0},{"$f":"I8*D8","v":0},{"$f":"J8*D8","v":0},{"$f":"K8*D8","v":0},{"$f":"L8*D8","v":0},{"$f":"M8*D8","v":0},{"$f":"N8*D8","v":0},{"$f":"((O8*E8)*0.5)+((P8*E8)*0.5)+((Q8*F8)*0.5)+((R8*F8)*0.5)+((S8*E8)*0.5)+((T8*E8)*0.5)","v":{"v":0,"d":"R 0.00"}}]
[null,null,"Polokwane",{"v":607.76,"d":"608"},{"v":60.6666666666667,"d":"61"},{"v":60.6666666666667,"d":"61"},{"v":60.6666666666667,"d":"61"},"Long",null,{"$f":"I9*1.04","v":0},0,0,0,0,0,{"$f":"J9*D9","v":0},{"$f":"K9*D9","v":0},{"$f":"L9*D9","v":0},{"$f":"M9*D9","v":0},{"$f":"N9*D9","v":0},{"$f":"((O9*E9)*0.5)+((P9*E9)*0.5)+((Q9*F9)*0.5)+((R9*F9)*0.5)+((S9*E9)*0.5)+((T9*E9)*0.5)","v":{"v":0,"d":"R 0.00"}}]
[null,null,"Witbank / eMalahleni ",{"$f":"106*2*1.05","v":{"v":222.60000000000002,"d":"223"}},{"v":40.6666666666667,"d":"41"},{"v":40.6666666666667,"d":"41"},{"v":40.6666666666667,"d":"41"},"Long",null,{"$f":"I10*1.04","v":0},0,0,0,0,0,0,0,0,0,0,{"v":0,"d":"R 0.00"}]
[null,null,"Beaconsfield",{"v":1159.88,"d":"1160"},25,25,25,"Long",null,{"$f":"I11*1.04","v":0},0,0,0,0,0,0,0,0,0,0,{"v":0,"d":"R 0.00"}]
[null,null,"Nelspruit",{"v":678.38,"d":"678"},{"v":60.6666666666667,"d":"61"},{"v":60.6666666666667,"d":"61"},{"v":60.6666666666667,"d":"61"},"Long",null,{"$f":"I12*1.04","v":0},0,0,0,0,0,0,0,0,0,0,{"v":0,"d":"R 0.00"}]
[null,null,"Komatiepoort",{"v":898.8000000000001,"d":"899"},{"v":100.666666666667,"d":"101"},{"v":100.666666666667,"d":"101"},{"v":100.666666666667,"d":"101"},"Long",null,{"$f":"I13*1.04","v":0},0,0,0,0,0,0,0,0,0,0,{"v":0,"d":"R 0.00"}]
[null,null,"Richards Bay (Insese)",{"v":1388.8600000000001,"d":"1389"},{"v":110.666666666667,"d":"111"},{"v":110.666666666667,"d":"111"},110,"Long",null,{"$f":"I14*1.04","v":0},0,0,0,0,0,0,0,0,0,0,{"v":0,"d":"R 0.00"}]
[null,null,"Durban / Wentworth / Umbilo",{"v":1341.78,"d":"1342"},6,6,6,"Long",null,{"$f":"I15*1.04","v":0},0,0,0,0,0,0,0,0,0,0,{"v":0,"d":"R 0.00"}]
[null,null,"Ermelo",{"v":490.06,"d":"490"},12,12,12,"Long",null,{"$f":"I16*1.04","v":0},0,0,0,0,0,0,0,0,0,0,{"v":0,"d":"R 0.00"}]
[null,null,"Bloemfontein",{"v":1003.6600000000001,"d":"1004"},26,26,26,"Long",null,{"$f":"I17*1.04","v":0},0,0,0,0,0,0,0,0,0,0,{"v":0,"d":"R 0.00"}]
[null,null,"Bellville",{"v":3092.3,"d":"3092"},{"v":3.3333333333333335,"d":"3"},{"v":3.3333333333333335,"d":"3"},{"v":3.3333333333333335,"d":"3"},"Long",null,{"$f":"I18*1.04","v":0},0,0,0,0,0,0,0,0,0,0,{"v":0,"d":"R 0.00"}]
[null,null,"Salt River",{"v":3120.1200000000003,"d":"3120"},{"v":2.3333333333333335,"d":"2"},{"v":2.3333333333333335,"d":"2"},{"v":2.3333333333333335,"d":"2"},"Long",null,{"$f":"I19*1.04","v":0},0,0,0,0,0,0,0,0,0,0,{"v":0,"d":"R 0.00"}]
[null,null,"Lydenburg",600,5,5,5,"Long",null,{"$f":"I20*1.04","v":0},0,0,0,0,0,0,0,0,0,0,{"v":0,"d":"R 0.00"}]
[null,null,"Nigel",{"$f":"102*2*1.05","v":{"v":214.20000000000002,"d":"214"}},10,10,10,"Long",null,{"$f":"I21*1.04","v":0},0,0,0,0,0,0,0,0,0,0,{"v":0,"d":"R 0.00"}]
[null,null,"Coligny",{"$f":"240*2*1.05","v":504},9,22,22,"Long",null,{"$f":"I22*1.04","v":0},0,0,0,0,0,0,0,0,0,0,{"v":0,"d":"R 0.00"}]
[null,null,"Sentrarand",{"v":116.202,"d":"116"},95,95,95,"Long",null,{"$f":"I23*1.04","v":0},0,0,0,0,0,0,0,0,0,0,{"v":0,"d":"R 0.00"}]
[null,null,"Koedoespoort",1,{"v":400.666666666667,"d":"401"},{"v":400.666666666667,"d":"401"},{"v":400.666666666667,"d":"401"},"Short",null,{"$f":"I24*1.04","v":0},0,0,0,0,0,0,0,0,0,0,{"v":0,"d":"R 0.00"}]
[null,null,"Pyramid South",{"v":45.582,"d":"46"},19,19,19,"Medium",null,{"$f":"I25*1.04","v":0},0,0,0,0,0,0,0,0,0,0,{"v":0,"d":"R 0.00"}]
[null,null,"Capital Park",20,130,130,130,"Short",null,{"$f":"I26*1.04","v":0},0,0,0,0,0,0,0,0,0,0,{"v":0,"d":"R 0.00"}]
[null,null,"Welgedacht",{"v":166.92000000000002,"d":"167"},4,4,4,"Medium",null,{"$f":"I27*1.04","v":0},0,0,0,0,0,0,0,0,0,0,{"v":0,"d":"R 0.00"}]
[null,null,"Krugersdorp",{"$f":"77*2*1.05","v":{"v":161.70000000000002,"d":"162"}},8,8,8,"Medium",null,{"$f":"I28*1.04","v":0},0,0,0,0,0,0,0,0,0,0,{"v":0,"d":"R 0.00"}]
[null,null,"Germiston",130,{"v":20.6666666666667,"d":"21"},{"v":20.6666666666667,"d":"21"},{"v":20.6666666666667,"d":"21"},"Medium",null,{"$f":"I29*1.04","v":0},0,0,0,0,0,0,0,0,0,0,{"v":0,"d":"R 0.00"}]
[null,null,"Braamfontein",164,{"v":40.3333333333333,"d":"40"},{"v":40.3333333333333,"d":"40"},{"v":40.3333333333333,"d":"40"},"Medium",null,{"$f":"I30*1.04","v":0},0,0,0,0,0,0,0,0,0,0,{"v":0,"d":"R 0.00"}]
[null,null,"Phalaborwa",930,{"v":1.6666666666666667,"d":"2"},{"v":1.6666666666666667,"d":"2"},{"v":1.6666666666666667,"d":"2"},"Long",null,{"$f":"I31*1.04","v":0},0,0,0,0,0,0,0,0,0,0,{"v":0,"d":"R 0.00"}]
[null,null,"Sasolburg",286,{"v":1.6666666666666667,"d":"2"},{"v":1.6666666666666667,"d":"2"},{"v":1.6666666666666667,"d":"2"},"Long",null,{"$f":"I32*1.04","v":0},0,0,0,0,0,0,0,0,0,0,{"v":0,"d":"R 0.00"}]
[null,null,"Leeuhof",260,{"v":3.6666666666666665,"d":"4"},{"v":3.6666666666666665,"d":"4"},{"v":3.6666666666666665,"d":"4"},"Long",null,{"$f":"I33*1.04","v":0},0,0,0,0,0,0,0,0,0,0,{"v":0,"d":"R 0.00"}]
[null,null,"Trichardt ",330,{"v":1.6666666666666667,"d":"2"},{"v":1.6666666666666667,"d":"2"},{"v":1.6666666666666667,"d":"2"},"Long",null,{"$f":"I34*1.04","v":0},0,0,0,0,0,0,0,0,0,0,{"v":0,"d":"R 0.00"}]
[null,null,"New brighten",2270,{"v":2.6666666666666665,"d":"3"},{"v":2.6666666666666665,"d":"3"},{"v":2.6666666666666665,"d":"3"},"Long",null,{"$f":"I35*1.04","v":0},0,0,0,0,0,0,0,0,0,0,{"v":0,"d":"R 0.00"}]
[null,null,"Cambridge",2172,4,4,4,"Long",null,{"$f":"I36*1.04","v":0},0,0,0,0,0,0,0,0,0,0,{"v":0,"d":"R 0.00"}]
[null,null,"Rovos",20,{"v":1.6666666666666667,"d":"2"},{"v":1.6666666666666667,"d":"2"},{"v":1.6666666666666667,"d":"2"},"Short",null,{"$f":"I37*1.04","v":0},0,0,0,0,0,0,0,0,0,0,{"v":0,"d":"R 0.00"}]
[null,null,"Blue Train",24,{"v":9.6666666666667,"d":"10"},{"v":9.6666666666667,"d":"10"},{"v":9.6666666666667,"d":"10"},"Short",null,{"$f":"I38*1.04","v":0},0,0,0,0,0,0,0,0,0,0,{"v":0,"d":"R 0.00"}]
[null,null,"New Castle",700,{"v":0.3333333333333333,"d":"0"},{"v":0.3333333333333333,"d":"0"},{"v":0.3333333333333333,"d":"0"},"Long",null,{"$f":"I39*1.04","v":0},0,0,0,0,0,0,0,0,0,0,{"v":0,"d":"R 0.00"}]
[null,null,"Uitenhage ",2228,{"v":1.3333333333333333,"d":"1"},{"v":1.3333333333333333,"d":"1"},{"v":1.3333333333333333,"d":"1"},"Long",null,{"$f":"I40*1.04","v":0},0,0,0,0,0,0,0,0,0,0,{"v":0,"d":"R 0.00"}]
[{"$nulls":7},"Total (Excluding  Vat) ",{"$nulls":6},{"$f":"SUM(O8:O40)","v":0},{"$f":"SUM(P8:P40)","v":0},{"$f":"SUM(Q8:Q40)","v":0},{"$nulls":3},{"$f":"SUM(U8:U40)","v":{"v":0,"d":"R 0.00"}}]
[{"$nulls":7},"Total (Including  Vat) ",{"$nulls":12},{"$f":"U41*1.15","v":{"v":0,"d":"R0.00"}}]
["Note: Out of contract rate will be determined by using the rate per kilometer based on the distance closest to the pricing mentioned above."]
["For example: If the out of contract is 3000 Kilos, the closest route distance will be Bellville and that qouted rate will be used."]