{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Start","Part-I","Part-II"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"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":"Start","index":0,"n_rows":26,"n_cols":5,"rows_kept":26,"cut":false,"hidden":false,"merged":[[1,1,1,4],[2,1,2,4],[3,1,3,4]]}
[]
[null,"Annexure-18 - Commercial Annexure"]
[null,"Selection of System Integrator to establish Testing Center of Excellence for LIC"]
[null,"Ref: LIC/CO/IT-SD/EFEAP-NEXT/TCOE/23-24/01  Dated: 28-03-2024"]
[]
[null,null,"Enter Bidder Name"]
[]
[null,null,null,"Instructions related to entering quotes"]
[null,null,null," Excel Cells where Bidder has to input values, are unlocked."]
[]
[null,null,null,"The bidder will have to compulsorily quote prices for each line item. The quote should be for each line item and as per exact specifications called for in the Technical Bid."]
[null,null,null,"The Quantities are indicative and may vary, however, actual quantities will be as reflected in the Purchase Orders . "]
[null,null,null,"LIC may purchase additional quantities at the Approved Rate for all the components by giving additional Purchase Order(s)."]
[null,null,null,"The quotes should be in integer only (i.e. non decimal)."]
[]
[]
[]
[]
[null,null,null,"TOTAL COST of OWNERSHIP","Total Discounted Cost of Ownership"]
[null,null,"Part-I Quote",{"$f":"'Part-I'!L26","v":1905.0},{"$f":"'Part-I'!M26","v":1588.7199999999998}]
[null,null,"Part-II Quote",{"$f":"'Part-II'!I29","v":5400.0},{"$f":"'Part-II'!J29","v":4503.45}]
[null,null,"TCO",{"$f":"SUM(D20:D21)","v":7305.0},{"$f":"SUM(E20:E21)","v":6092.17}]
[]
[null,null,"Date:","dd-mm-yyyy"]
[]
[null,null,null,"Signature of Vendor/Vendor's  Representative"]

{"sheet":"Part-I","index":1,"n_rows":32,"n_cols":20,"rows_kept":32,"cut":false,"hidden":false,"merged":[[32,1,32,6],[7,1,8,1],[7,2,8,2],[7,3,8,3],[7,4,8,4],[7,5,8,5],[25,0,25,10],[7,0,8,0],[9,2,9,5],[29,1,29,5],[19,2,19,12],[11,2,11,12],[7,6,7,10],[9,11,9,12],[0,0,0,11],[1,0,1,11],[2,0,2,11],[4,1,4,11],[5,0,5,12]]}
[{"$f":"Start!B2","v":"Annexure-18 - Commercial Annexure"}]
[{"$f":"Start!B3","v":"Selection of System Integrator to establish Testing Center of Excellence for LIC"}]
[{"$f":"Start!B4","v":"Ref: LIC/CO/IT-SD/EFEAP-NEXT/TCOE/23-24/01  Dated: 28-03-2024"}]
[]
["Bidder:"]
["Part I - Quote for Software License/Subscrption/AMC/ATS Cost"]
[]
["Sl. No.","Item","Quantity/Number","Open Source Software Name and version at Zero cost","Paid software name and version","License/subscription Base(User/Application/Core/Server) for paid software","License/Subscrition/AMC/ATS Cost for Paid SW Per unit for each year",null,null,null,null,"Total Cost Excluding GST","Total Discouted Cost @NPV excluding GST"]
[null,null,null,null,null,null,"Year 1","Year 2","Year 3","Year 4","Year 5","(Sum of Yearly cost * Quantity)","(Sum of Yearly cost @NPV * Quantity)"]
[1.0,"Software Licenses/Subscriptions",null,null,null,null,1.0,0.90909,0.82645,0.75131,0.68301]
["1A","Test Management/ Test Ops Software",50.0,null,null,"Per user",1.0,1.0,1.0,1.0,1.0,{"$f":"(G11+H11+I11+J11+K11)*C11","v":250.0},{"$f":"ROUND((G11*$G$10+H11*$H$10+I11*$I$10+J11*$J$10+K11*$K$10)*C11,2)","v":208.49}]
["1B","[For Test automation SW, If same SW is proposed for all three or any two, cost may be given as zero for the subsequent entry]"]
[null,"Test Automation (Web Browser)",20.0,null,null,"Per user",1.0,1.0,1.0,1.0,1.0,{"$f":"(G13+H13+I13+J13+K13)*C13","v":100.0},{"$f":"ROUND((G13*$G$10+H13*$H$10+I13*$I$10+J13*$J$10+K13*$K$10)*C13,2)","v":83.4}]
[null,"Test Automation (Desktop Application)",20.0,null,null,"Per user",1.0,1.0,1.0,1.0,1.0,100.0,{"$f":"ROUND((G14*$G$10+H14*$H$10+I14*$I$10+J14*$J$10+K14*$K$10)*C14,2)","v":83.4}]
[null,"Test Automation (Mobile Application)",20.0,null,null,"Per user",1.0,1.0,1.0,1.0,1.0,100.0,83.4]
["1C","API Testing Software",20.0,null,null,"Per user",1.0,1.0,1.0,1.0,1.0,100.0,83.4]
["1D","Performance Testing Software (along with load injector license) with/for 10000 concurrency",1.0,null,null,"For 10000 virtual/ concurrent users",1.0,1.0,1.0,1.0,1.0,5.0,{"$f":"ROUND((G17*$G$10+H17*$H$10+I17*$I$10+J17*$J$10+K17*$K$10)*C17,2)","v":4.17}]
["1E","Application Performance Monitoring Software",50.0,null,null,"Per agent",1.0,1.0,1.0,1.0,1.0,250.0,{"$f":"ROUND((G18*$G$10+H18*$H$10+I18*$I$10+J18*$J$10+K18*$K$10)*C18,2)","v":208.49}]
["1F","Defect Management Software",200.0,null,null,"Per user",1.0,1.0,1.0,1.0,1.0,1000.0,{"$f":"ROUND((G19*$G$10+H19*$H$10+I19*$I$10+J19*$J$10+K19*$K$10)*C19,2)","v":833.97}]
[2.0,"Other Software/Tools(If required)"]
["2A","OS License Other than RHEL (Also Quote quantity as per requirement)",0.0,null,null,null,0.0,0.0,0.0,0.0,0.0,0.0,{"$f":"ROUND((G21*$G$10+H21*$H$10+I21*$I$10+J21*$J$10+K21*$K$10)*C21,2)","v":0.0}]
["2B","DB license Other than MySQL  (Also Quote quantity as per requirement)",0.0,null,null,null,0.0,0.0,0.0,0.0,0.0,0.0,{"$f":"ROUND((G22*$G$10+H22*$H$10+I22*$I$10+J22*$J$10+K22*$K$10)*C22,2)","v":0.0}]
["2C","Any Other Software  (Also Quote quantity as per requirement)",0.0,null,null,null,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
["2D","Any Other Software  (Also Quote quantity as per requirement)",0.0,null,null,null,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
["2E","Any Other Software  (Also Quote quantity as per requirement)",0.0,null,null,null,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
["Total",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L10:L25)","v":1905.0},{"$f":"SUM(M10:M25)","v":1588.7199999999998},null,null,null,null,null,null,{"$f":"SUM(T10:T19)","v":0.0}]
[]
[]
[]
[null,"The Number/Quantiy quoted above are for TCO purpose only. Actual requirement/deployment will be decided by LIC based on this rate card."]
[]
[null,"Signature of Vendor's Representative",null,null,null,"Date","dd-mm-yyyy"]

{"sheet":"Part-II","index":2,"n_rows":34,"n_cols":10,"rows_kept":34,"cut":false,"hidden":false,"merged":[[0,0,0,11],[1,0,1,11],[2,0,2,11],[28,1,28,7],[31,1,31,5],[9,3,9,7],[5,0,6,9],[4,1,4,11],[21,3,21,7],[8,8,9,8],[8,9,9,9]]}
[{"$f":"Start!B2","v":"Annexure-18 - Commercial Annexure"}]
[{"$f":"Start!B3","v":"Selection of System Integrator to establish Testing Center of Excellence for LIC"}]
[{"$f":"Start!B4","v":"Ref: LIC/CO/IT-SD/EFEAP-NEXT/TCOE/23-24/01  Dated: 28-03-2024"}]
[]
["Bidder:"]
["Part II - Quote for Onsite Testing Resources and Mobile/TAB rental"]
[]
["Sl. No.","Item","Number/Quantity","Quote Per unit Year-1","Quote Per unit Year-2","Quote Per unit Year-3","Quote Per unit Year-4","Quote Per unit Year-5","Total Cost Excluding GST","Total Discouted Cost @NPV excluding GST"]
[null,null,null,1.0,0.90909,0.82645,0.75131,0.68301,"(Total of Monthly Cost*Quantity * 12)","(Total of Monthly Cost @NPV *Quantity * 12)"]
[1.0,"TCoE Resources cost",null,"Cost of per resource per Man month "]
["1A","Project manager/TCoE Lead",1.0,1.0,1.0,1.0,1.0,1.0,{"$f":"(D11+E11+F11+G11+H11)*C11*12","v":60.0},{"$f":"ROUND((D11*$D$9+E11*$E$9+F11*$F$9+G11*$G$9+H11*$H$9)*C11*12,2)","v":50.04}]
["1B","Test/Quality Lead",2.0,1.0,1.0,1.0,1.0,1.0,{"$f":"(D12+E12+F12+G12+H12)*C12*12","v":120.0},{"$f":"ROUND((D12*$D$9+E12*$E$9+F12*$F$9+G12*$G$9+H12*$H$9)*C12*12,2)","v":100.08}]
["1C","Test Architect (Automation)",1.0,1.0,1.0,1.0,1.0,1.0,60.0,50.04]
["1D","Sr. SW test Engineer",5.0,1.0,1.0,1.0,1.0,1.0,300.0,250.19]
["1E","Jr. SW Test Engineer",10.0,1.0,1.0,1.0,1.0,1.0,600.0,500.38]
["1F","Sr. SW Test Engineer (Automation)",5.0,1.0,1.0,1.0,1.0,1.0,300.0,250.19]
["1G","Jr. SW Test Engineer (Automation)",10.0,1.0,1.0,1.0,1.0,1.0,600.0,500.38]
["1H","Sr. performance test Engineer",2.0,1.0,1.0,1.0,1.0,1.0,120.0,100.08]
["1I","Jr. Performance Test Engineer",5.0,1.0,1.0,1.0,1.0,1.0,300.0,250.19]
["1J","Subject Matter Expert/ Business Analyst",7.0,1.0,1.0,1.0,1.0,1.0,420.0,350.27]
["1K","Test Environment Support Engineer",2.0,1.0,1.0,1.0,1.0,1.0,120.0,100.08]
[2.0,"Mobile/TAB rental cost",null,"Unit Rental Cost Per Mobile or TAB Per Month "]
["2A","Physical Android Mobile/ TAB device Rental Cost",8.0,1.0,1.0,1.0,1.0,1.0,480.0,400.31]
["2B","Physical iOS Mobile/ TAB deviceRental cost",4.0,1.0,1.0,1.0,1.0,1.0,240.0,200.15]
["2C","Physical Windows OS Mobile/ TAB device Rental cost",2.0,1.0,1.0,1.0,1.0,1.0,120.0,100.08]
["2D","Android Mobile/ TAB Rental Cost hosted in Public/Private Cloud",15.0,1.0,1.0,1.0,1.0,1.0,900.0,750.57]
["2E","iOS Mobile/ TAB Rental Cost hosted in Public/Private Cloud",7.0,1.0,1.0,1.0,1.0,1.0,420.0,350.27]
["2F","Windows Mobile/ TAB Rental Cost hosted in Public/Private Cloud",4.0,1.0,1.0,1.0,1.0,1.0,240.0,200.15]
[null,"TOTAL",null,null,null,null,null,null,{"$f":"SUM(I11:I28)","v":5400.0},{"$f":"SUM(J11:J28)","v":4503.45}]
[]
[]
[null,"The Number/Quantity quoted above are for TCO purpose only. Actual requirement/deployment will be decided by LIC based on this rate card."]
[]
[null,"Signature of Vendor's Representative",null,null,"Date:","dd-mm-yyyy"]