{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["REGION 1","REGION 2","REGION 3"],"not_rendered":{"defined_names":24},"read":"whole","date_system":"1900"}

{"sheet":"REGION 1","index":0,"n_rows":69,"n_cols":9,"rows_kept":69,"merged":[[1,1,1,2],[1,3,1,8],[2,1,2,2],[2,3,2,8],[3,1,3,8],[4,1,4,2],[4,3,4,8],[6,1,6,2],[6,3,6,8],[7,1,7,8],[8,1,8,8],[9,1,9,8],[10,1,10,8],[11,1,11,8],[12,1,12,8],[13,1,13,8],[14,1,14,8],[15,1,15,8],[16,1,16,8],[17,1,17,8],[19,1,19,4],[20,2,20,4],[21,2,21,4],[22,2,22,4],[24,1,24,7],[26,1,26,4],[27,2,27,4],[28,2,28,4],[30,1,30,4],[31,2,31,4],[32,2,32,4],[33,2,33,4],[34,2,34,4],[35,1,35,7],[37,1,37,4],[38,2,38,4],[39,2,39,4],[40,2,40,4],[41,2,41,4],[42,1,42,7],[44,1,44,4],[60,1,60,4],[62,1,62,7],[64,4,64,5],[65,1,65,2],[65,4,65,5]]}
[]
[null,"Tender Number",null,"RFP 13/2023"]
[null,"Tender Name",null,"APPOINTMENT OF SUPPLIERS FOR SUPPLY AND DELIVERY OF INVERTERS, LITHIUM-ION BATTERIES AND SOLAR PANELS (ALTERNATIVE ENERGY EQUIPMENT)"]
[null,"REGION 1"]
[null,"Bidder Name"]
[]
[null,"NOTES :  ",null,"Bidders must carefully read the NOTES before completing the Price Template"]
[null,"1. Bidders should input their company name on the Green highlighted area of the coversheet of the pricing template."]
[null,"2. Bidders MUST NOT change the Pricing Template other than by providing values in the cells with \"GREEN\"; and Bidders are not allowed to change the format of this pricing schedule and any changes may render the bidder's proposal as non-responsive."]
[null,"3. All prices provided by the bidder must EXCLUDE VAT, the formulae in the tables will add VAT at 15% automatically. The prices must be given in South African Rand and must be all inclusive as no additional costs will be allowed."]
[null,"4. The pricing is to remain firm for 180 days from the closing date of this tender; SARS reserves the right to negotiate with the recommended bidder prior to signing of the contract. "]
[null,"5. Bidders must note that all pricing must be in \"ZAR\". It is the bidders responsibility to consider the USD/Rand exchange rate in completing the price template. No additional costs will be considered post award."]
[null,"6. Bidders must complete the Pricing Template, print the spreadsheet, initial each page, sign and submit in Hardcopy also submit in electronic (EXCEL) format."]
[null,"7. The quoted prices MUST be  inclusive of all SARS' requirements "]
[null,"8. Bidders can provide comments, assumptions and any points of clarification on a separate letter as an Annexure to their pricing submission, and this should be done in their company letterhead. "]
[null,"9. All cells must be populated and if no value is inserted it will be regarded as Zero, i.e., at NO cost to SARS."]
[null,"10. Bidders must note that the number of  Quantities indicated in this pricing template are estimates. These numbers will be used for comparative pricing evaluation purposes and the final number will be negotiated with the winning bidder post tender award."]
[null,"11. Under Table 5 Bidders are required to provide an all inclusive delivery cost per site for all sites in the region as listed below."]
[]
[null,"TABLE 1: INVERTERS "]
[null,"Item No ","Product Description",null,null,"Estimated QTY","Unit Price (Excl VAT)","VAT","Total (Incl. VAT)"]
[null,1,"12 kw 3phase inverters (12KW Output)",null,null,4,null,{"$f":"(F22*G22)*15%","v":{"v":0,"d":"R 0.00"}},{"$f":"(F22*G22)+H22","v":{"v":0,"d":"R 0.00"}}]
[null,2,"12 kw 3phase inverters (36KW Output)",null,null,{"$f":"3*4","v":12},null,{"$f":"(F23*G23)*15%","v":{"v":0,"d":"R 0.00"}},{"$f":"(F23*G23)+H23","v":{"v":0,"d":"R 0.00"}}]
[null,3,"12 kw 3 phase inverters (72KW Output)",null,null,{"$f":"6*6","v":36},null,{"$f":"(F24*G24)*15%","v":{"v":0,"d":"R 0.00"}},{"$f":"(F24*G24)+H24","v":{"v":0,"d":"R 0.00"}}]
[null,"Total Amount (Incl. VAT)",{"$nulls":6},{"$f":"SUM(I22:I24)","v":{"v":0,"d":"R 0.00"}}]
[]
[null,"TABLE 2: Temporary/Mobile Solutions"]
[null,"Item No ","Product Description",null,null,"Estimated QTY","Unit Price (Excl VAT)","VAT","Total (Incl. VAT)"]
[null,4,"All in one 7kw Single phase inverter (Mobile Unit)",null,null,10,null,{"$f":"(F29*G29)*15%","v":{"v":0,"d":"R 0.00"}},{"$f":"(F29*G29)+H29","v":{"v":0,"d":"R 0.00"}}]
[]
[null,"TABLE 3:  BATTERIES"]
[null,"Item No ","Product Description",null,null,"Estimated QTY","Unit Price (Excl VAT)","VAT","Total (Incl. VAT)"]
[null,1,"Lithium batteries 5kw each (25KWh Backup)",null,null,{"$f":"5*4","v":20},null,{"$f":"(F33*G33)*15%","v":{"v":0,"d":"R 0.00"}},{"$f":"(F33*G33)+H33","v":{"v":0,"d":"R 0.00"}}]
[null,2,"5Kw Lithium batteries (75KWh Backup)\n",null,null,{"$f":"15*4","v":60},null,{"$f":"(F34*G34)*15%","v":{"v":0,"d":"R 0.00"}},{"$f":"(F34*G34)+H34","v":{"v":0,"d":"R 0.00"}}]
[null,3,"5Kw Lithium batteries (150KWh Backup)\n",null,null,{"$f":"30*6","v":180},null,{"$f":"(F35*G35)*15%","v":{"v":0,"d":"R 0.00"}},{"$f":"(F35*G35)+H35","v":{"v":0,"d":"R 0.00"}}]
[null,"Total Amount (Incl. VAT)",{"$nulls":6},{"$f":"SUM(I33:I35)","v":{"v":0,"d":"R 0.00"}}]
[]
[null,"TABLE 4:  SOLAR PANELS"]
[null,"Item No ","Product Description",null,null,"Estimated QTY","Unit Price (Excl VAT)","VAT","Total (Incl. VAT)"]
[null,1,"650W Solar panels (15.6KWp)",null,null,{"$f":"24*4","v":96},null,{"$f":"(F40*G40)*15%","v":{"v":0,"d":"R 0.00"}},{"$f":"(F40*G40)+H40","v":{"v":0,"d":"R 0.00"}}]
[null,2,"650W Solar panels (62.4KWp)",null,null,{"$f":"96*4","v":384},null,{"$f":"(F41*G41)*15%","v":{"v":0,"d":"R 0.00"}},{"$f":"(F41*G41)+H41","v":{"v":0,"d":"R 0.00"}}]
[null,3,"650W Solar panels ( 93.6KWp) ",null,null,{"$f":"144*6","v":864},null,{"$f":"(F42*G42)*15%","v":{"v":0,"d":"R 0.00"}},{"$f":"(F42*G42)+H42","v":{"v":0,"d":"R 0.00"}}]
[null,"Total Amount (Incl. VAT)",{"$nulls":6},{"$f":"SUM(I40:I42)","v":{"v":0,"d":"R 0.00"}}]
[]
[null,"TABLE 5:  DELIVERY COST PER SITE"]
[null,"Item No ","SARS SITE","Delivery Cost Per Site (Excl VAT)","VAT","Total (Incl. VAT)"]
[null,1,"Rissik str",null,{"$f":"D47*15%","v":{"v":0,"d":"R 0.00"}},{"$f":"D47+E47","v":{"v":0,"d":"R 0.00"}}]
[null,2,"Pta CBD",null,{"$f":"D48*15%","v":{"v":0,"d":"R 0.00"}},{"$f":"D48+E48","v":{"v":0,"d":"R 0.00"}}]
[null,3,"Ashley Gardens",null,{"$f":"D49*15%","v":{"v":0,"d":"R 0.00"}},{"$f":"D49+E49","v":{"v":0,"d":"R 0.00"}}]
[null,4,"Randburg",null,{"$f":"D50*15%","v":{"v":0,"d":"R 0.00"}},{"$f":"D50+E50","v":{"v":0,"d":"R 0.00"}}]
[null,5,"Vereeniging",null,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"}]
[null,6,"Boksburg",null,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"}]
[null,7,"Krugersdorp",null,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"}]
[null,8,"Roodepoort",null,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"}]
[null,9,"Soweto",null,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"}]
[null,10,"Nigel",null,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"}]
[null,11,"Randfontein",null,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"}]
[null,12,"Springs",null,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"}]
[null,13,"Benoni",null,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"}]
[null,14,"Edenvale",null,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"}]
[null,"Total Delivery cost ",{"$nulls":3},{"$f":"SUM(F47:F60)","v":{"v":0,"d":"R 0.00"}}]
[]
[null,"Total Tender Value",{"$nulls":6},{"$f":"I25+I29+I36+I43+F61","v":{"v":0,"d":"R 0.00"}}]
[]
[]
[null,"Company Representative: Name",null,null,"Role in the Company"]
[]
[]
[null,"Signature",null,null,"Date"]

{"sheet":"REGION 2","index":1,"n_rows":70,"n_cols":9,"rows_kept":70,"merged":[[1,1,1,3],[1,4,1,8],[2,1,2,3],[2,4,2,8],[3,1,3,8],[4,1,4,3],[4,4,4,8],[6,1,6,2],[6,3,6,8],[7,1,7,8],[8,1,8,8],[9,1,9,8],[10,1,10,8],[11,1,11,8],[12,1,12,8],[13,1,13,8],[14,1,14,8],[15,1,15,8],[16,1,16,8],[17,1,17,8],[19,1,19,4],[20,2,20,4],[21,2,21,4],[22,2,22,4],[24,1,24,7],[26,1,26,4],[27,2,27,4],[28,2,28,4],[30,1,30,4],[31,2,31,4],[32,2,32,4],[33,2,33,4],[34,2,34,4],[35,1,35,7],[37,1,37,4],[38,2,38,4],[39,2,39,4],[40,2,40,4],[41,2,41,4],[42,1,42,7],[44,1,44,4],[61,1,61,4],[63,1,63,7],[65,4,65,5],[66,1,66,2],[66,4,66,5]]}
[]
[null,"Tender Number",null,null,"RFP 13/2023"]
[null,"Tender Name",null,null,"APPOINTMENT OF SUPPLIERS FOR SUPPLY AND DELIVERY OF INVERTERS, LITHIUM-ION BATTERIES AND SOLAR PANELS (ALTERNATIVE ENERGY EQUIPMENT)"]
[null,"REGION 2"]
[null,"Bidder Name"]
[]
[null,"NOTES :  ",null,"Bidders must carefully read the NOTES before completing the Price Template"]
[null,"1. Bidders should input their company name on the Green highlighted area of the coversheet of the pricing template."]
[null,"2. Bidders MUST NOT change the Pricing Template other than by providing values in the cells with \"GREEN\"; and Bidders are not allowed to change the format of this pricing schedule and any changes may render the bidder's proposal as non-responsive."]
[null,"3. All prices provided by the bidder must EXCLUDE VAT, the formulae in the tables will add VAT at 15% automatically. The prices must be given in South African Rand and must be all inclusive as no additional costs will be allowed."]
[null,"4. The pricing is to remain firm for 180 days from the closing date of this tender; SARS reserves the right to negotiate with the recommended bidder prior to signing of the contract. "]
[null,"5. Bidders must note that all pricing must be in \"ZAR\". It is the bidders responsibility to consider the USD/Rand exchange rate in completing the price template. No additional costs will be considered post award."]
[null,"6. Bidders must complete the Pricing Template, print the spreadsheet, initial each page, sign and submit in Hardcopy also submit in electronic (EXCEL) format."]
[null,"7. The quoted prices MUST be  inclusive of all SARS' requirements "]
[null,"8. Bidders can provide comments, assumptions and any points of clarification on a separate letter as an Annexure to their pricing submission, and this should be done in their company letterhead. "]
[null,"9. All cells must be populated and if no value is inserted it will be regarded as Zero, i.e., at NO cost to SARS."]
[null,"10. Bidders must note that the number of  Quantities indicated in this pricing template are estimates. These numbers will be used for comparative pricing evaluation purposes and the final number will be negotiated with the winning bidder post tender award."]
[null,"11. Under Table 5 Bidders are required to provide an all inclusive delivery cost per site for all sites in the region as listed below."]
[]
[null,"TABLE 1: INVERTERS "]
[null,"Item No ","Product Description",null,null,"Estimated QTY","Unit Price (Excl VAT)","VAT","Total (Incl. VAT)"]
[null,1,"12 kw 3phase inverters (12KW Output)",null,null,7,null,{"$f":"(F22*G22)*15%","v":{"v":0,"d":"R 0.00"}},{"$f":"(F22*G22)+H22","v":{"v":0,"d":"R 0.00"}}]
[null,2,"12 kw 3phase inverters (36KW Output)",null,null,{"$f":"3*5","v":15},null,{"$f":"(F23*G23)*15%","v":{"v":0,"d":"R 0.00"}},{"$f":"(F23*G23)+H23","v":{"v":0,"d":"R 0.00"}}]
[null,3,"12 kw 3 phase inverters (72KW Output)",null,null,{"$f":"6*3","v":18},null,{"$f":"(F24*G24)*15%","v":{"v":0,"d":"R 0.00"}},{"$f":"(F24*G24)+H24","v":{"v":0,"d":"R 0.00"}}]
[null,"Total Amount (Incl. VAT)",{"$nulls":6},{"$f":"SUM(I22:I24)","v":{"v":0,"d":"R 0.00"}}]
[]
[null,"TABLE 2: Temporary/Mobile Solutions"]
[null,"Item No ","Product Description",null,null,"Estimated QTY","Unit Price (Excl VAT)","VAT","Total (Incl. VAT)"]
[null,4,"All in one 7kw Single phase inverter (Mobile Unit)",null,null,10,null,{"$f":"(F29*G29)*15%","v":{"v":0,"d":"R 0.00"}},{"$f":"(F29*G29)+H29","v":{"v":0,"d":"R 0.00"}}]
[]
[null,"TABLE 3:  BATTERIES"]
[null,"Item No ","Product Description",null,null,"Estimated QTY","Unit Price (Excl VAT)","VAT","Total (Incl. VAT)"]
[null,1,"Lithium batteries 5kw each (25KWh Backup)",null,null,{"$f":"5*7","v":35},null,{"$f":"(F33*G33)*15%","v":{"v":0,"d":"R 0.00"}},{"$f":"(F33*G33)+H33","v":{"v":0,"d":"R 0.00"}}]
[null,2,"5Kw Lithium batteries (75KWh Backup)\n",null,null,{"$f":"15*5","v":75},null,{"$f":"(F34*G34)*15%","v":{"v":0,"d":"R 0.00"}},{"$f":"(F34*G34)+H34","v":{"v":0,"d":"R 0.00"}}]
[null,3,"5Kw Lithium batteries (150KWh Backup)\n",null,null,{"$f":"30*3","v":90},null,{"$f":"(F35*G35)*15%","v":{"v":0,"d":"R 0.00"}},{"$f":"(F35*G35)+H35","v":{"v":0,"d":"R 0.00"}}]
[null,"Total Amount (Incl. VAT)",{"$nulls":6},{"$f":"SUM(I33:I35)","v":{"v":0,"d":"R 0.00"}}]
[]
[null,"TABLE 4:  SOLAR PANELS"]
[null,"Item No ","Product Description",null,null,"Estimated QTY","Unit Price (Excl VAT)","VAT","Total (Incl. VAT)"]
[null,1,"650W Solar panels (15.6KWp)",null,null,{"$f":"24*7","v":168},null,{"$f":"(F40*G40)*15%","v":{"v":0,"d":"R 0.00"}},{"$f":"(F40*G40)+H40","v":{"v":0,"d":"R 0.00"}}]
[null,2,"650W Solar panels (62.4KWp)",null,null,{"$f":"96*5","v":480},null,{"$f":"(F41*G41)*15%","v":{"v":0,"d":"R 0.00"}},{"$f":"(F41*G41)+H41","v":{"v":0,"d":"R 0.00"}}]
[null,3,"650W Solar panels ( 93.6KWp) ",null,null,{"$f":"144*3","v":432},null,{"$f":"(F42*G42)*15%","v":{"v":0,"d":"R 0.00"}},{"$f":"(F42*G42)+H42","v":{"v":0,"d":"R 0.00"}}]
[null,"Total Amount (Incl. VAT)",{"$nulls":6},{"$f":"SUM(I40:I42)","v":{"v":0,"d":"R 0.00"}}]
[]
[null,"TABLE 5:  DELIVERY COST PER SITE"]
[null,"Item No ","SARS SITE","Delivery Cost Per Site (Excl VAT)","VAT","Total (Incl. VAT)"]
[null,1,"East London",null,{"$f":"D47*15%","v":{"v":0,"d":"R 0.00"}},{"$f":"D47+E47","v":{"v":0,"d":"R 0.00"}}]
[null,2,"PE Sanlam",null,{"$f":"D48*15%","v":{"v":0,"d":"R 0.00"}},{"$f":"D48+E48","v":{"v":0,"d":"R 0.00"}}]
[null,3,"Umtata",null,{"$f":"D49*15%","v":{"v":0,"d":"R 0.00"}},{"$f":"D49+E49","v":{"v":0,"d":"R 0.00"}}]
[null,4,"Bloemfontein Zastron",null,{"$f":"D50*15%","v":{"v":0,"d":"R 0.00"}},{"$f":"D50+E50","v":{"v":0,"d":"R 0.00"}}]
[null,5,"Welkom",null,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"}]
[null,6,"Bethlehem",null,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"}]
[null,7," Kroonstad",null,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"}]
[null,8,"Beaufort West",null,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"}]
[null,9,"Paarl",null,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"}]
[null,10,"Worcester",null,{"v":0,"d":"R 0.00"},{"$f":"D56+E56","v":{"v":0,"d":"R 0.00"}}]
[null,11,"Kimberley",null,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"}]
[null,12,"Upington",null,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"}]
[null,13,"Lower Long",null,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"}]
[null,14,"George",null,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"}]
[null,15,"Mitchells Plain",null,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"}]
[null,"Total Delivery cost ",{"$nulls":3},{"$f":"SUM(F47:F61)","v":{"v":0,"d":"R 0.00"}}]
[]
[null,"Total Tender Value",{"$nulls":6},{"$f":"I25+I29+I36+I43+F62","v":{"v":0,"d":"R 0.00"}}]
[]
[]
[null,"Company Representative: Name",null,null,"Role in the Company"]
[]
[]
[null,"Signature",null,null,"Date"]

{"sheet":"REGION 3","index":2,"n_rows":71,"n_cols":9,"rows_kept":71,"merged":[[1,1,1,3],[1,4,1,8],[2,1,2,3],[2,4,2,8],[3,1,3,8],[4,1,4,3],[4,4,4,8],[6,1,6,2],[6,3,6,8],[7,1,7,8],[8,1,8,8],[9,1,9,8],[10,1,10,8],[11,1,11,8],[12,1,12,8],[13,1,13,8],[14,1,14,8],[15,1,15,8],[16,1,16,8],[17,1,17,8],[19,1,19,4],[20,2,20,4],[21,2,21,4],[22,2,22,4],[24,1,24,7],[26,1,26,4],[27,2,27,4],[28,2,28,4],[30,1,30,4],[31,2,31,4],[32,2,32,4],[33,2,33,4],[34,2,34,4],[35,1,35,7],[37,1,37,4],[38,2,38,4],[39,2,39,4],[40,2,40,4],[41,2,41,4],[42,1,42,7],[44,1,44,4],[62,1,62,4],[64,1,64,7],[66,4,66,5],[67,1,67,2],[67,4,67,5]]}
[]
[null,"Tender Number",null,null,"RFP 13/2023"]
[null,"Tender Name",null,null,"APPOINTMENT OF SUPPLIERS FOR SUPPLY AND DELIVERY OF INVERTERS, LITHIUM-ION BATTERIES AND SOLAR PANELS (ALTERNATIVE ENERGY EQUIPMENT)"]
[null,"REGION 3"]
[null,"Bidder Name"]
[]
[null,"NOTES :  ",null,"Bidders must carefully read the NOTES before completing the Price Template"]
[null,"1. Bidders should input their company name on the Green highlighted area of the coversheet of the pricing template."]
[null,"2. Bidders MUST NOT change the Pricing Template other than by providing values in the cells with \"GREEN\"; and Bidders are not allowed to change the format of this pricing schedule and any changes may render the bidder's proposal as non-responsive."]
[null,"3. All prices provided by the bidder must EXCLUDE VAT, the formulae in the tables will add VAT at 15% automatically. The prices must be given in South African Rand and must be all inclusive as no additional costs will be allowed."]
[null,"4. The pricing is to remain firm for 180 days from the closing date of this tender; SARS reserves the right to negotiate with the recommended bidder prior to signing of the contract. "]
[null,"5. Bidders must note that all pricing must be in \"ZAR\". It is the bidders responsibility to consider the USD/Rand exchange rate in completing the price template. No additional costs will be considered post award."]
[null,"6. Bidders must complete the Pricing Template, print the spreadsheet, initial each page, sign and submit in Hardcopy also submit in electronic (EXCEL) format."]
[null,"7. The quoted prices MUST be  inclusive of all SARS' requirements "]
[null,"8. Bidders can provide comments, assumptions and any points of clarification on a separate letter as an Annexure to their pricing submission, and this should be done in their company letterhead. "]
[null,"9. All cells must be populated and if no value is inserted it will be regarded as Zero, i.e., at NO cost to SARS."]
[null,"10. Bidders must note that the number of  Quantities indicated in this pricing template are estimates. These numbers will be used for comparative pricing evaluation purposes and the final number will be negotiated with the winning bidder post tender award."]
[null,"11. Under Table 5 Bidders are required to provide an all inclusive delivery cost per site for all sites in the region as listed below."]
[]
[null,"TABLE 1: INVERTERS "]
[null,"Item No ","Product Description",null,null,"Estimated QTY","Unit Price (Excl VAT)","VAT","Total (Incl. VAT)"]
[null,1,"12 kw 3phase inverters (12KW Output)",null,null,6,null,{"$f":"(F22*G22)*15%","v":{"v":0,"d":"R 0.00"}},{"$f":"(F22*G22)+H22","v":{"v":0,"d":"R 0.00"}}]
[null,2,"12 kw 3phase inverters (36KW Output)",null,null,{"$f":"3*8","v":24},null,{"$f":"(F23*G23)*15%","v":{"v":0,"d":"R 0.00"}},{"$f":"(F23*G23)+H23","v":{"v":0,"d":"R 0.00"}}]
[null,3,"12 kw 3 phase inverters (72KW Output)",null,null,{"$f":"6*2","v":12},null,{"$f":"(F24*G24)*15%","v":{"v":0,"d":"R 0.00"}},{"$f":"(F24*G24)+H24","v":{"v":0,"d":"R 0.00"}}]
[null,"Total Amount (Incl. VAT)",{"$nulls":6},{"$f":"SUM(I22:I24)","v":{"v":0,"d":"R 0.00"}}]
[]
[null,"TABLE 2: Temporary/Mobile Solutions"]
[null,"Item No ","Product Description",null,null,"Estimated QTY","Unit Price (Excl VAT)","VAT","Total (Incl. VAT)"]
[null,4,"All in one 7kw Single phase inverter (Mobile Unit)",null,null,10,null,{"$f":"(F29*G29)*15%","v":{"v":0,"d":"R 0.00"}},{"$f":"(F29*G29)+H29","v":{"v":0,"d":"R 0.00"}}]
[]
[null,"TABLE 3:  BATTERIES"]
[null,"Item No ","Product Description",null,null,"Estimated QTY","Unit Price (Excl VAT)","VAT","Total (Incl. VAT)"]
[null,1,"Lithium batteries 5kw each (25KWh Backup)",null,null,{"$f":"5*6","v":30},null,{"$f":"(F33*G33)*15%","v":{"v":0,"d":"R 0.00"}},{"$f":"(F33*G33)+H33","v":{"v":0,"d":"R 0.00"}}]
[null,2,"5Kw Lithium batteries (75KWh Backup)\n",null,null,{"$f":"15*8","v":120},null,{"$f":"(F34*G34)*15%","v":{"v":0,"d":"R 0.00"}},{"$f":"(F34*G34)+H34","v":{"v":0,"d":"R 0.00"}}]
[null,3,"5Kw Lithium batteries (150KWh Backup)\n",null,null,{"$f":"30*2","v":60},null,{"$f":"(F35*G35)*15%","v":{"v":0,"d":"R 0.00"}},{"$f":"(F35*G35)+H35","v":{"v":0,"d":"R 0.00"}}]
[null,"Total Amount (Incl. VAT)",{"$nulls":6},{"$f":"SUM(I33:I35)","v":{"v":0,"d":"R 0.00"}}]
[]
[null,"TABLE 4:  SOLAR PANELS"]
[null,"Item No ","Product Description",null,null,"Estimated QTY","Unit Price (Excl VAT)","VAT","Total (Incl. VAT)"]
[null,1,"650W Solar panels (15.6KWp)",null,null,{"$f":"24*6","v":144},null,{"$f":"(F40*G40)*15%","v":{"v":0,"d":"R 0.00"}},{"$f":"(F40*G40)+H40","v":{"v":0,"d":"R 0.00"}}]
[null,2,"650W Solar panels (62.4KWp)",null,null,{"$f":"96*8","v":768},null,{"$f":"(F41*G41)*15%","v":{"v":0,"d":"R 0.00"}},{"$f":"(F41*G41)+H41","v":{"v":0,"d":"R 0.00"}}]
[null,3,"650W Solar panels ( 93.6KWp) ",null,null,{"$f":"144*2","v":288},null,{"$f":"(F42*G42)*15%","v":{"v":0,"d":"R 0.00"}},{"$f":"(F42*G42)+H42","v":{"v":0,"d":"R 0.00"}}]
[null,"Total Amount (Incl. VAT)",{"$nulls":6},{"$f":"SUM(I40:I42)","v":{"v":0,"d":"R 0.00"}}]
[]
[null,"TABLE 5:  DELIVERY COST PER SITE"]
[null,"Item No ","SARS SITE","Delivery Cost Per Site (Excl VAT)","VAT","Total (Incl. VAT)"]
[null,1,"PMB",null,{"$f":"D47*15%","v":{"v":0,"d":"R 0.00"}},{"$f":"D47+E47","v":{"v":0,"d":"R 0.00"}}]
[null,2,"Pinetown",null,{"$f":"D48*15%","v":{"v":0,"d":"R 0.00"}},{"$f":"D48+E48","v":{"v":0,"d":"R 0.00"}}]
[null,3,"Richardsbay",null,{"$f":"D49*15%","v":{"v":0,"d":"R 0.00"}},{"$f":"D49+E49","v":{"v":0,"d":"R 0.00"}}]
[null,4,"Umhlanga",null,{"$f":"D50*15%","v":{"v":0,"d":"R 0.00"}},{"$f":"D50+E50","v":{"v":0,"d":"R 0.00"}}]
[null,5,"Port Shepstone",null,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"}]
[null,6,"Newcastle",null,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"}]
[null,7,"Polokwane",null,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"}]
[null,8,"Giyani",null,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"}]
[null,9,"Lebowakgomo",null,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"}]
[null,10,"Thohoyandou",null,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"}]
[null,11,"Standerton",null,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"}]
[null,12,"Witbank",null,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"}]
[null,13,"Nelspruit",null,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"}]
[null,14,"Rustenburg",null,{"v":0,"d":"R 0.00"},{"$f":"D60+E60","v":{"v":0,"d":"R 0.00"}}]
[null,15,"Klerksdorp",null,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"}]
[null,16,"Mmabatho",null,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"}]
[null,"Total Delivery cost ",{"$nulls":3},{"$f":"SUM(F47:F62)","v":{"v":0,"d":"R 0.00"}}]
[]
[null,"Total Tender Value",{"$nulls":6},{"$f":"I25+I29+I36+I43+F63","v":{"v":0,"d":"R 0.00"}}]
[]
[]
[null,"Company Representative: Name",null,null,"Role in the Company"]
[]
[]
[null,"Signature",null,null,"Date"]