{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["PRICING SCHEDULE","Disc Model & Pricing Principle","Base Component","Growth Component","Professional Services"],"not_rendered":{"images":2,"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"PRICING SCHEDULE","index":0,"n_rows":39,"n_cols":23,"rows_kept":39,"merged":[[0,5,0,7],[5,5,5,11],[13,2,13,3],[14,2,14,3],[14,5,16,5],[15,2,15,3],[16,2,16,3],[18,4,18,6],[18,7,18,9],[18,10,18,12],[18,13,18,15],[18,16,18,18],[35,1,38,1],[35,2,35,3],[35,4,35,5],[36,2,36,3],[37,2,37,3],[37,4,37,5],[38,2,38,3],[38,4,38,5]]}
[null,"SUPPLY CHAIN MANAGEMENT",{"$nulls":3},"Pricing Response_02 (Subscription) "]
[null,"Pricing schedule"]
["RFB No","RFB 3280-2026"]
["RFB Title","REQUEST TO APPROVE THE ESTABLISHMENT OF A NEW FIVE (5) YEAR DEVELOPMENT, SUPPORT AND LICENCE MAINTENANCE AGREEMENT FOR THE BEYONDTRUST REMOTE SUPPORT SYSTEM FOR SITA"]
["Bidder Name "]
[{"$nulls":5},"Version: WO83355 Pricing Response _Rev01"]
["1. INSTRUCTION FOR COMPLETING THE PRICING SCHEDULE"]
["(a)  Bidder must complete the following worksheets: Disc Model and Pricing Principle, Base Component, Growth Component and Professional Services sheets and then confirm the values in the Pricing Schedule sheet"]
["(b)  Below is the total cost for 5 years (not committed)"]
["(c)  Bidder must complete/enter YELLOW cells only"]
["(d)  Unit and Line prices must be VAT EXCLUSIVE and in South African Rand (ZAR) currency"]
["(e) The price must include all cost to deliver the goods or render the service, including all applicable taxes, duty fees, logistics/delivery, storage, labour, overtime and subsistance and travel"]
["(f)  Prices that are dependent on Rate of Exchange (ROE) must use ROE indicated below, then enter in Column \"Forex %\" the percentage of the price that is ROE dependent (0% means the price is not ROE dependent)"]
[null,"Foreign currency","South African Rand (ZAR) exchange rate "]
[null,"1 US Dollar",{"v":16.17,"d":"R16.17"},null,null,"Mark with an X, which ROE is applicable"]
[null,"1 Euro",{"v":18.68,"d":"R18.68"}]
[null,"1 Pound (UK)",{"v":21.86,"d":"R21.86"}]
[]
[{"$nulls":4},"YEAR 1",null,null,"YEAR 2",null,null,"YEAR 3",null,null,"YEAR 4",null,null,"YEAR 5",null,null,"TOTAL"]
["Item No","Goods/Service description","Unit of measure","Forex %","Qty Y1","Unit Price Y1\n(Excl VAT)","Line Price Y1","Qty Y2","Unit Price Y2\n(Excl VAT)","Line Price Y2","Qty Y3","Unit Price Y3\n(Excl VAT)","Line Price Y3","Y4","Unit Price Y4\n(Excl VAT)","Line Price Y4","QtyY5","Unit Price Y5\n(Excl VAT)","Line Price Y5","Line Price Term \n(Excl VAT)","Forex Price portion","BRAND / MODEL","Price clarification comment"]
[1,"Subscription Base Component Total",{"$nulls":4},{"$f":"SUBTOTAL(9, G22:G24)","v":0},null,null,{"$f":"SUBTOTAL(9, J22:J24)","v":0},null,null,{"$f":"SUBTOTAL(9, M22:M24)","v":0},null,null,{"$f":"SUBTOTAL(9, P22:P24)","v":0},null,null,{"$f":"SUBTOTAL(9, S22:S24)","v":0},{"$f":"SUBTOTAL(9, T22:T24)","v":0},{"$f":"SUBTOTAL(9, U22:U24)","v":0}]
["1.1","Subscription on Base BeyondTrust Appliance licenses per year","each",{"$f":"'Base Component'!C16","v":{"v":0,"d":"0%"}},2,{"$f":"'Base Component'!E16","v":0},{"$f":"E22*F22","v":0},2,{"$f":"'Base Component'!H16","v":0},{"$f":"H22*I22","v":0},2,{"$f":"'Base Component'!K16","v":0},{"$f":"K22*L22","v":0},2,{"$f":"'Base Component'!N16","v":0},{"$f":"N22*O22","v":0},2,{"$f":"'Base Component'!Q16","v":0},{"$f":"Q22*R22","v":0},{"$f":"SUM(G22,J22,M22,P22,S22)","v":0},{"$f":"D22*T22","v":0}]
["1.2","Subscription on Base BeyondTrust User licenses per year","each",{"$f":"'Base Component'!C17","v":{"v":0,"d":"0%"}},30,{"$f":"'Base Component'!E17","v":0},0,30,{"$f":"'Base Component'!H17","v":0},0,30,{"$f":"'Base Component'!K17","v":0},{"$f":"K23*L23","v":0},30,{"$f":"'Base Component'!N17","v":0},0,30,{"$f":"'Base Component'!Q17","v":0},0,{"$f":"SUM(G23,J23,M23,P23,S23)","v":0},{"$f":"D23*T23","v":0}]
["1.3","Subscription on Base BMC Remedy Integration licenses per year","each",{"$f":"'Base Component'!C18","v":{"v":0,"d":"0%"}},1,{"$f":"'Base Component'!E18","v":0},0,1,{"$f":"'Base Component'!H18","v":0},0,1,{"$f":"'Base Component'!K18","v":0},0,1,{"$f":"'Base Component'!N18","v":0},0,1,{"$f":"'Base Component'!Q18","v":0},0,0,0]
[2,"Growth Component",{"$nulls":4},{"$f":"SUBTOTAL(9,G26:G28)","v":0},null,null,{"$f":"SUBTOTAL(9,J26:J28)","v":0},null,null,{"$f":"SUBTOTAL(9,M26:M28)","v":0},null,null,{"$f":"SUBTOTAL(9,P26:P28)","v":0},null,null,{"$f":"SUBTOTAL(9,S26:S28)","v":0},{"$f":"SUBTOTAL(9,T26:T28)","v":0},{"$f":"SUBTOTAL(9,U26:U28)","v":0}]
[2.1,"BeyondTrust Appliance Growth licenses per year","each",{"$f":"'Growth Component'!C38","v":{"v":0,"d":"0%"}},0,{"$f":"'Growth Component'!F38","v":0},{"$f":"E26*F26","v":0},2,{"$f":"'Growth Component'!I38","v":0},{"$f":"(H26+E26)*I26","v":0},0,{"$f":"'Growth Component'!L38","v":0},{"$f":"(K26+H26)*L26","v":0},0,{"$f":"'Growth Component'!O38","v":0},{"$f":"(N26+K26)*O26","v":0},0,{"$f":"'Growth Component'!R38","v":0},{"$f":"(Q26+N26)*R26","v":0},{"$f":"SUM(G26,J26,M26,P26,S26)","v":0},{"$f":"D26*T26","v":0}]
[2.2,"BeyondTrust User Growth licenses per year","each",{"$f":"'Growth Component'!C39","v":{"v":0,"d":"0%"}},100,{"$f":"'Growth Component'!F39","v":0},{"$f":"E27*F27","v":0},150,{"$f":"'Growth Component'!I39","v":0},{"$f":"(H27+E27)*I27","v":0},200,{"$f":"'Growth Component'!L39","v":0},{"$f":"(K27+H27)*L27","v":0},250,{"$f":"'Growth Component'!O39","v":0},{"$f":"(N27+K27)*O27","v":0},250,{"$f":"'Growth Component'!R39","v":0},{"$f":"(Q27+N27)*R27","v":0},{"$f":"SUM(G27,J27,M27,P27,S27)","v":0},{"$f":"D27*T27","v":0}]
[2.3,"BMC Remedy Integration licenses per year","each",{"$f":"'Growth Component'!C40","v":{"v":0,"d":"0%"}},0,{"$f":"'Growth Component'!F40","v":0},0,1,{"$f":"'Growth Component'!I40","v":0},{"$f":"(H28+E28)*I28","v":0},0,{"$f":"'Growth Component'!L40","v":0},{"$f":"(K28+H28)*L28","v":0},0,{"$f":"'Growth Component'!O40","v":0},{"$f":"(N28+K28)*O28","v":0},0,{"$f":"'Growth Component'!R40","v":0},{"$f":"(Q28+N28)*R28","v":0},{"$f":"SUM(G28,J28,M28,P28,S28)","v":0},{"$f":"D28*T28","v":0}]
[4,"Professional Services",{"$nulls":4},{"$f":"SUBTOTAL(9,G30:G30)","v":0},null,null,{"$f":"SUBTOTAL(9,J30:J30)","v":0},null,null,{"$f":"SUBTOTAL(9,M30:M30)","v":0},null,null,{"$f":"SUBTOTAL(9,P30:P30)","v":0},null,null,{"$f":"SUBTOTAL(9,S30:S30)","v":0},{"$f":"SUBTOTAL(9,T30:T30)","v":0},{"$f":"SUBTOTAL(9,U30:U30)","v":0}]
["4.1","Professional services per year","each",{"$f":"'Professional Services'!C23","v":{"v":0,"d":"0%"}},3330,{"$f":"'Professional Services'!E23","v":0},{"$f":"E30*F30","v":0},3330,{"$f":"'Professional Services'!H23","v":0},{"$f":"H30*I30","v":0},3330,{"$f":"'Professional Services'!K23","v":0},{"$f":"K30*L30","v":0},3330,{"$f":"'Professional Services'!N23","v":0},{"$f":"N30*O30","v":0},3330,{"$f":"'Professional Services'!Q23","v":0},{"$f":"Q30*R30","v":0},{"$f":"SUM(G30,J30,M30,P30,S30)","v":0},{"$f":"D30*T30","v":0}]
[null,"TOTAL  BID PRICE (EXCL VAT)",{"$nulls":4},{"$f":"SUM(G21,G25,G29)","v":0},null,null,{"$f":"SUM(J21,J25,J29)","v":0},null,null,{"$f":"SUM(M21,M25,M29)","v":0},null,null,{"$f":"SUM(P21,P25,P29)","v":0},null,null,{"$f":"SUM(S21,S25,S29)","v":0},{"$f":"SUM(T21,T25,T29)","v":0},{"$f":"SUM(U21,U25,U29)","v":0}]
[null,"VAT (@15%)",{"$nulls":4},{"$f":"G31*0.15","v":0},null,null,{"$f":"J31*0.15","v":0},null,null,{"$f":"M31*0.15","v":0},null,null,{"$f":"P31*0.15","v":0},null,null,{"$f":"S31*0.15","v":0},{"$f":"T31*0.15","v":0},{"$f":"U31*0.15","v":0}]
[null,"TOTAL  BID PRICE (INCL VAT)",{"$nulls":4},{"$f":"SUM(G31:G32)","v":0},null,null,{"$f":"SUM(J31:J32)","v":0},null,null,{"$f":"SUM(M31:M32)","v":0},null,null,{"$f":"SUM(P31:P32)","v":0},null,null,{"$f":"SUM(S31:S32)","v":0},{"$f":"SUM(T31:T32)","v":0},{"$f":"SUM(U31:U32)","v":0}]
[]
[]
[null,"I, the bidder, confirm that the price(s) and rate(s) quoted cover all the goods and/or works specified in the bidding documents; that the price(s) or rate(s) cover all my obligations and I accept that any mistakes regarding price(s), rate(s) or calculations will be at my own risk.\n[Note: First convert to PDF, then add signature]"]
[null,null,"Name",null,"Capacity"]
[]
[null,null,"Signature (above)",null,"Date"]

{"sheet":"Disc Model & Pricing Principle","index":1,"n_rows":36,"n_cols":4,"rows_kept":36,"merged":[[0,0,0,3],[2,0,2,3],[2,4,2,6],[3,0,3,3],[3,4,3,6],[4,0,4,6],[8,0,8,6],[9,0,9,6],[10,0,10,6],[11,0,11,6],[12,0,12,6],[13,0,13,6],[14,0,14,6],[15,0,15,6],[16,0,16,6],[17,0,17,6],[18,0,18,6],[19,0,19,6],[20,0,20,6],[21,0,21,6],[22,0,22,6],[23,0,23,6],[24,0,24,6],[25,0,25,6],[26,0,26,6]]}
["Disc Model and Pricing Principle"]
[]
["The growth component of this RFB includes possible customer taken on."]
["The following growth principles will apply to this contract:"]
["a)           There should be a tiered discount model that will cover growth requirements over the 5 years, as per the example below:"]
[]
[]
["Tiered Discount Example"]
["b)          Growth will be projected for the purposes of developing a discount model. No upfront commitment will be made as all growth will be supported by a new client being onboarded."]
["c)           Discount model principles:"]
["     i)            Starting price = Market price = X"]
["     ii)           % discount = A-G"]
["               (1)         A = 0%"]
["               (2)         B = 50%"]
["               (3)         C = 55%"]
["               (4)         D = 60%"]
["               (5)         E = 65%"]
["               (6)         F = 70%"]
["     iii)         Maximum discount based on volumes must be defined"]
["     iv)         Starting volume will be 3500 licenses."]
["d)          The model will be based on Pay as you use (Buy as needed)."]
["e)           Additional license procurement will be prorated and paid upfront to the end of the contract."]
["f)            Start with the current base of deployed licenses with some capacity for flexibility."]
["g)           All licenses procured during the 5-year term will be co-termed for the 5-year contract period. (No licenses will be extended beyond the contract term)"]
["h)          Upon renewal of this contract only the new base will be renewed, and a new discount table will be negotiated."]
["i)            The actual maintenance that will be paid per year will be based on the existing base at the time of maintenance payment. "]
[]
["Complete tiered discount model"]
["#","Discount Level","Total Licences","% discount"]
[1,"A",30,{"v":0,"d":"0%"}]
[2,"B",130,{"v":0,"d":"0%"}]
[3,"C",230,{"v":0,"d":"0%"}]
[4,"D",380,{"v":0,"d":"0%"}]
[5,"E",580,{"v":0,"d":"0%"}]
[6,"F",605,{"v":0,"d":"0%"}]
[7,"G",855,{"v":0,"d":"0%"}]

{"sheet":"Base Component","index":2,"n_rows":18,"n_cols":20,"rows_kept":18,"merged":[[0,5,0,15],[2,0,2,3],[5,1,5,7],[7,1,7,7],[9,1,9,7]]}
["Base Component:",{"$nulls":4},"Version: WO83355  Pricing Response _Rev01"]
[]
["a) The inflation rate to be used for the calculations is 5,6%."]
[]
[null,"No Licenses ","Year 1","Year 2","Year 3","Year 4","Year 5","Projected discount"]
["Subscription price per licence - Beyond truts system",{"v":0,"d":"R0.00"}]
["Base licences per year Cost per license",2,{"$f":"B6*(1-H7)","v":{"v":0,"d":"R0.00"}},{"$f":"C7*1.056","v":{"v":0,"d":"R0.00"}},{"$f":"D7*1.056","v":{"v":0,"d":"R0.00"}},{"$f":"E7*1.056","v":{"v":0,"d":"R0.00"}},{"$f":"F7*1.056","v":{"v":0,"d":"R0.00"}},{"$f":"H9","v":{"v":0,"d":"0%"}}]
["Subscription price per licence - Beyond trust user",{"v":0,"d":"R0.00"}]
["Base licences per year Cost per license",30,{"$f":"B8*(1-H9)","v":{"v":0,"d":"R0.00"}},{"$f":"C9*1.056","v":{"v":0,"d":"R0.00"}},{"$f":"D9*1.056","v":{"v":0,"d":"R0.00"}},{"$f":"E9*1.056","v":{"v":0,"d":"R0.00"}},{"$f":"F9*1.056","v":{"v":0,"d":"R0.00"}},{"$f":"'Disc Model & Pricing Principle'!D30","v":{"v":0,"d":"0%"}}]
["Subscription price per licence - Beyond trust integration",{"v":0,"d":"R0.00"}]
["Base licences per year Cost per license",1,{"$f":"B10*(1-H11)","v":{"v":0,"d":"R0.00"}},{"$f":"C11*1.056","v":{"v":0,"d":"R0.00"}},{"$f":"D11*1.056","v":{"v":0,"d":"R0.00"}},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"$f":"H9","v":{"v":0,"d":"0%"}}]
[]
[]
["Goods/Service description","Unit of measure","Forex %","Qty Y1","Unit Price Y1\n(Excl VAT)","Line Price Y1","Qty Y2","Unit Price Y2\n(Excl VAT)","Line Price Y2","Qty Y3","Unit Price Y3\n(Excl VAT)","Line Price Y3","Qty Y4","Unit Price Y4\n(Excl VAT)","Line Price Y4","Qty Y5","Unit Price Y5\n(Excl VAT)","Line Price Y5","Line Price Term \n(Excl VAT)","Forex Price portion"]
["Base Component",{"$nulls":4},{"$f":"SUM(F16:F18)","v":0},null,null,{"$f":"SUM(I16:I18)","v":0},null,null,{"$f":"SUM(L16:L18)","v":0},null,null,{"$f":"SUM(O16:O18)","v":0},null,null,{"$f":"SUM(R16:R18)","v":0},{"$f":"SUM(F15:R15)","v":0},{"$f":"SUM(T16:T18)","v":0}]
["Beyond truts system","each",{"v":0,"d":"0%"},2,{"$f":"C7","v":0},{"$f":"D16*E16","v":0},2,{"$f":"E16*1.056","v":0},{"$f":"G16*H16","v":0},2,{"$f":"H16*1.056","v":0},{"$f":"J16*K16","v":0},2,{"$f":"K16*1.056","v":0},{"$f":"M16*N16","v":0},2,{"$f":"N16*1.056","v":0},{"$f":"P16*Q16","v":0},{"$f":"R16+I16+F16+L16+O16","v":0},{"$f":"C16*S16","v":0}]
["Beyond trust user","each",{"v":0,"d":"0%"},30,{"$f":"C9","v":0},{"$f":"D17*E17","v":0},30,{"$f":"E17*1.056","v":0},{"$f":"G17*H17","v":0},30,{"$f":"H17*1.056","v":0},{"$f":"J17*K17","v":0},30,{"$f":"K17*1.056","v":0},{"$f":"M17*N17","v":0},30,{"$f":"N17*1.056","v":0},{"$f":"P17*Q17","v":0},{"$f":"R17+I17+F17+L17+O17","v":0},{"$f":"C17*S17","v":0}]
["Beyond trust integration","each",{"v":0,"d":"0%"},1,{"$f":"C11","v":0},0,1,{"$f":"E18*1.056","v":0},{"$f":"G18*H18","v":0},1,{"$f":"H18*1.056","v":0},0,1,0,0,1,0,{"$f":"P18*Q18","v":0},{"$f":"R18+I18+F18+L18+O18","v":0},{"$f":"C18*S18","v":0}]

{"sheet":"Growth Component","index":3,"n_rows":40,"n_cols":21,"rows_kept":40,"merged":[[2,4,2,8],[9,1,9,8],[10,0,10,1],[17,1,17,8],[18,0,18,1],[25,1,25,8],[26,0,26,1],[34,4,34,6],[34,7,34,9],[34,10,34,12],[34,13,34,15],[34,16,34,18],[34,20,35,20]]}
["Growth Component:"]
[]
["a) The growth component of this RFB includes possible customer taken on.",{"$nulls":3},"Version: WO83355  Pricing Response _Rev01"]
["c) The inflation rate to be used for the calculations is 5,6%."]
[]
[]
["Table 2: Subscription cost for 5 years"]
["Total Subscription cost over 5 years"]
[null,"License growth per year","Total base for year (Base + growth)","Year 1","Year 2","Year 3","Year 4","Year 5","Projected discount"]
["Subscription price per licence - Beyond truts system",{"v":0,"d":"R0.00"}]
["CPI Included",null,null,{"$f":"B10","v":{"v":0,"d":"R0.00"}},{"$f":"D11*1.056","v":{"v":0,"d":"R0.00"}},{"$f":"E11*1.056","v":{"v":0,"d":"R0.00"}},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
["Growth year 1",0,{"$f":"2+B12","v":2},{"$f":"D11*(1-I12)","v":{"v":0,"d":"R0.00"}},{"$nulls":4},{"$f":"I20","v":{"v":0,"d":"0%"}}]
["Growth year 2",2,{"$f":"B12+C12","v":2},null,{"$f":"E11*(1-I13)","v":{"v":0,"d":"R0.00"}},{"$nulls":3},{"$f":"I21","v":{"v":0,"d":"0%"}}]
["Growth year 3",0,{"$f":"B13+C13","v":4},null,null,{"$f":"F11*(1-I14)","v":{"v":0,"d":"R0.00"}},null,null,{"v":0,"d":"0%"}]
["Growth year 4",0,4,{"$nulls":3},{"$f":"G11*(1-I15)","v":{"v":0,"d":"R0.00"}},null,{"v":0,"d":"0%"}]
["Growth year 5",0,4,{"$nulls":4},{"$f":"H11*(1-I16)","v":{"v":0,"d":"R0.00"}},{"v":0,"d":"0%"}]
["Total",{"$f":"SUM(B12:B16)","v":2},4]
["Subscription price per licence - Beyond trust user",{"v":0,"d":"R0.00"}]
["CPI Included",null,null,{"$f":"B18","v":{"v":0,"d":"R0.00"}},{"$f":"D19*1.056","v":{"v":0,"d":"R0.00"}},{"$f":"E19*1.056","v":{"v":0,"d":"R0.00"}},{"$f":"F19*1.056","v":{"v":0,"d":"R0.00"}},{"$f":"G19*1.056","v":{"v":0,"d":"R0.00"}}]
["Growth year 1",100,{"$f":"30+B20","v":130},{"$f":"D19*(1-I20)","v":{"v":0,"d":"R0.00"}},{"$nulls":4},{"$f":"'Disc Model & Pricing Principle'!D31","v":{"v":0,"d":"0%"}}]
["Growth year 2",150,{"$f":"B20+C20","v":230},null,{"$f":"E19*(1-I21)","v":{"v":0,"d":"R0.00"}},{"$nulls":3},{"$f":"'Disc Model & Pricing Principle'!D32","v":{"v":0,"d":"0%"}}]
["Growth year 3",200,{"$f":"B21+C21","v":380},null,null,{"$f":"F19*(1-I22)","v":{"v":0,"d":"R0.00"}},null,null,{"$f":"'Disc Model & Pricing Principle'!D33","v":{"v":0,"d":"0%"}}]
["Growth year 4",25,580,{"$nulls":3},{"$f":"G19*(1-I23)","v":{"v":0,"d":"R0.00"}},null,{"$f":"'Disc Model & Pricing Principle'!D34","v":{"v":0,"d":"0%"}}]
["Growth year 5",250,605,{"$nulls":4},{"$f":"H19*(1-I24)","v":{"v":0,"d":"R0.00"}},{"$f":"'Disc Model & Pricing Principle'!D35","v":{"v":0,"d":"0%"}}]
["Total",{"$f":"SUM(B20:B24)","v":725},855]
["Subscription price per licence - Beyond trust integration",{"v":0,"d":"R0.00"}]
["CPI Included",null,null,{"$f":"B26","v":{"v":0,"d":"R0.00"}},{"$f":"D27*1.056","v":{"v":0,"d":"R0.00"}},{"$f":"E27*1.056","v":{"v":0,"d":"R0.00"}},{"$f":"F27*1.056","v":{"v":0,"d":"R0.00"}},{"$f":"G27*1.056","v":{"v":0,"d":"R0.00"}}]
["Growth year 1",0,{"$f":"1+B28","v":1},{"$f":"D27*(1-I28)","v":{"v":0,"d":"R0.00"}},{"$nulls":4},{"$f":"I20","v":{"v":0,"d":"0%"}}]
["Growth year 2",1,{"$f":"B28+C28","v":1},null,{"$f":"E27*(1-I29)","v":{"v":0,"d":"R0.00"}},{"$nulls":3},{"$f":"I21","v":{"v":0,"d":"0%"}}]
["Growth year 3",0,{"$f":"B29+C29","v":2},null,null,{"$f":"F27*(1-I30)","v":{"v":0,"d":"R0.00"}},null,null,{"v":0,"d":"0%"}]
["Growth year 4",0,2,{"$nulls":3},{"$f":"G27*(1-I31)","v":{"v":0,"d":"R0.00"}},null,{"v":0,"d":"0%"}]
["Growth year 5",0,2,{"$nulls":4},{"$f":"H27*(1-I32)","v":{"v":0,"d":"R0.00"}},{"v":0,"d":"0%"}]
["Total",{"$f":"SUM(B28:B32)","v":1},2]
[]
[{"$nulls":4},"YEAR 1",null,null,"YEAR 2",null,null,"YEAR 3",null,null,"YEAR 4",null,null,"YEAR 5",null,null,"TOTAL","Forex Price portion"]
["Goods/Service description","Unit of measure","Forex %","License base ","Qty Y1","Unit Price Y1\n(Excl VAT)","Line Price Y1","Qty Y2","Unit Price Y2\n(Excl VAT)","Line Price Y2","Qty Y3","Unit Price Y3\n(Excl VAT)","Line Price Y3","Qty Y4","Unit Price Y4\n(Excl VAT)","Line Price Y4","Qty Y5","Unit Price Y5\n(Excl VAT)","Line Price Y5","Line Price Term \n(Excl VAT)"]
["Growth component",{"$nulls":5},{"$f":"SUM(G38:G40)","v":0},null,null,{"$f":"SUM(J38:J40)","v":0},null,null,{"$f":"SUM(M38:M40)","v":0},null,null,{"$f":"SUM(P38:P40)","v":0},null,null,{"$f":"SUM(S38:S40)","v":0},{"$f":"SUM(G37:S37)","v":0},{"$f":"SUM(U38:U40)","v":0}]
["Beyond truts system","each",{"v":0,"d":"0%"},2,0,{"$f":"D12","v":0},{"$f":"E38*F38","v":0},2,{"$f":"E13","v":0},{"$f":"(H38+E38)*I38","v":0},0,{"$f":"F14","v":0},{"$f":"(K38+H38)*L38","v":0},0,{"$f":"G15","v":0},{"$f":"(N38+K38)*O38","v":0},0,{"$f":"H16","v":0},{"$f":"(Q38+N38)*R38","v":0},{"$f":"SUM(G38,J38,S38,P38,M38)","v":0},{"$f":"T38*C38","v":0}]
["Beyond trust user","each",{"v":0,"d":"0%"},30,100,{"$f":"D20","v":0},0,150,{"$f":"E21","v":0},{"$f":"(H39+E39)*I39","v":0},200,{"$f":"F22","v":0},{"$f":"(K39+H39)*L39","v":0},250,{"$f":"G23","v":0},{"$f":"(N39+K39)*O39","v":0},250,{"$f":"H24","v":0},{"$f":"(Q39+N39)*R39","v":0},{"$f":"SUM(G39,J39,S39,P39,M39)","v":0},{"$f":"T39*C39","v":0}]
["Beyond trust integration","each",{"v":0,"d":"0%"},1,0,{"$f":"D28","v":0},0,1,{"$f":"E29","v":0},{"$f":"(H40+E40)*I40","v":0},0,{"$f":"F30","v":0},0,0,{"$f":"G31","v":0},0,0,{"$f":"H32","v":0},0,0,0]

{"sheet":"Professional Services","index":4,"n_rows":23,"n_cols":20,"rows_kept":23,"merged":[[2,4,2,8],[19,3,19,5],[19,6,19,8],[19,9,19,11],[19,12,19,14],[19,15,19,17]]}
["Professional Services:"]
["The professional services required for this service must comply with the following:"]
["a)           Professional services will be requested, as and when needed.",{"$nulls":3},"Version: WO83355  Pricing Response _Rev01"]
["b)          The service delivery resource must be available on-site within 8 hours of such a request (This excludes any potential travel to other offices outside of the three main Gauteng SITA offices)."]
["c)           Support hours may be carried over to the next year, or moved back from a future year to the present year, during the five years, according to workload requirements."]
["d)          The bidder must be able to provide 1665x2 = 3330 support hours per year for 5 years. (3330x5 = 16650 total hours)"]
["e)           SITA is not obligated to utilize the full 3330 hours per annum or over the 5-year term of the contract and utilization will be time sheet based."]
["f)            This is on-site professional services at the two main Gauteng SITA offices (Erasmuskloof and Centurion). This requirement is in addition to the support associated with the annual license subscription fees."]
["g)           A blended rate per hour must be used for calculating the professional services in Table 4. The bidder must determine own methodology to calculate blended rate."]
["h)          The inflation rate to be used for the calculations is 5,6%."]
[]
["Table 3: Professional Services"]
["Professional Services","Rate"]
["Functional Application Support (FAS)",{"v":0,"d":"R0.00"}]
["Junior Remedy Developer",{"v":0,"d":"R0.00"},{"$nulls":3},1665,{"$f":"F15*2","v":3330}]
["Senior Remedy Developer",{"v":0,"d":"R0.00"}]
["Blended rate",{"$f":"AVERAGE(B14:B16)","v":{"v":0,"d":"R0.00"}}]
[]
[]
[{"$nulls":3},"YEAR 1",null,null,"YEAR 2",null,null,"YEAR 3",null,null,"YEAR 4",null,null,"YEAR 5",null,null,"TOTAL"]
["Goods/Service description","Unit of measure","Forex %","Qty Y1","Unit Price Y1\n(Excl VAT)","Line Price Y1","Qty Y2","Unit Price Y2\n(Excl VAT)","Line Price Y2","Qty Y3","Unit Price Y3\n(Excl VAT)","Line Price Y3","Qty Y4","Unit Price Y4\n(Excl VAT)","Line Price Y4","Qty Y5","Unit Price Y5\n(Excl VAT)","Line Price Y5","Line Price Term \n(Excl VAT)","Forex Price portion"]
["Professional Services",{"$nulls":4},{"$f":"SUBTOTAL(9,F23:F23)","v":0},null,null,{"$f":"SUBTOTAL(9,I23:I23)","v":0},null,null,{"$f":"SUBTOTAL(9,L23:L23)","v":0},null,null,{"$f":"SUBTOTAL(9,O23:O23)","v":0},null,null,{"$f":"SUBTOTAL(9,R23:R23)","v":0},{"$f":"SUM(F22:R22)","v":0},{"$f":"SUBTOTAL(9,T23:T23)","v":0}]
["Professional services per year","Hour",{"v":0,"d":"0%"},3330,{"$f":"B17","v":0},{"$f":"D23*E23","v":0},3330,{"$f":"E23*1.056","v":0},{"$f":"G23*H23","v":0},3330,{"$f":"H23*1.056","v":0},{"$f":"J23*K23","v":0},3330,{"$f":"K23*1.056","v":0},{"$f":"M23*N23","v":0},3330,{"$f":"N23*1.056","v":0},{"$f":"P23*Q23","v":0},{"$f":"SUM(F23,I23,R23,L23,O23)","v":0},{"$f":"C23*S23","v":0}]