{"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.7166599999996}]
[null,null,"Part-II Quote",{"$f":"'Part-II'!I23","v":0.0},{"$f":"'Part-II'!J23","v":0.0}]
[null,null,"TCO",{"$f":"SUM(D20:D21)","v":1905.0},{"$f":"SUM(E20:E21)","v":1588.7166599999996}]
[]
[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],[7,11,8,11],[7,12,8,12],[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.","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",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"]
[1.0,"Software Licenses/Subscription",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":"G11*1*C11+H11*0.90909*C11+I11*0.82645*C11+J11*0.75131*C11+K11*0.68301*C11","v":208.49299999999997}]
["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":"G13*1*C13+H13*0.90909*C13+I13*0.82645*C13+J13*0.75131*C13+K13*0.68301*C13","v":83.3972}]
[null,"Test Automation (Desktop Application)",20.0,null,null,"Per user",1.0,1.0,1.0,1.0,1.0,100.0,83.3972]
[null,"Test Automation (Mobile Application)",20.0,null,null,"Per user",1.0,1.0,1.0,1.0,1.0,100.0,83.3972]
["1C","API Testing",20.0,null,null,"Per user",1.0,1.0,1.0,1.0,1.0,100.0,83.3972]
["1D","Performance Testing Software (along with load injector) for 10000 concurrency",1.0,null,null,"Per virtual/concurrent user",1.0,1.0,1.0,1.0,1.0,5.0,4.16986]
["1E","Application Performance Monitoring",50.0,null,null,"Per agent",1.0,1.0,1.0,1.0,1.0,250.0,208.49299999999997]
["1F","Defect Management Software",200.0,null,null,"Per user",1.0,1.0,1.0,1.0,1.0,1000.0,833.9719999999999]
[2.0,"Other Software/Tools(If required)"]
["2A","OS License Other than Linux",0.0,null,null,null,0.0,0.0,0.0,0.0,0.0,{"$f":"(G21+H21+I21+J21+K21)*C21","v":0.0},{"$f":"G21*1*C21+H21*0.90909*C21+I21*0.82645*C21+J21*0.75131*C21+K21*0.68301*C21","v":0.0}]
["2B","DB license Other than MySQL",0.0,null,null,null,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
["2C","Any Other Software",0.0,null,null,null,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
["2D","Any Other Software",0.0,null,null,null,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
["2E","Any Other SW",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(L11:L25)","v":1905.0},{"$f":"SUM(M11:M25)","v":1588.7166599999996},null,null,null,null,null,null,{"$f":"SUM(T10:T19)","v":0.0}]
[]
[]
[]
[null,"The Number/Quantity are for TCO purpose only. Actual Procurement 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":28,"n_cols":10,"rows_kept":28,"cut":false,"hidden":false,"merged":[[0,0,0,11],[1,0,1,11],[2,0,2,11],[22,1,22,7],[25,1,25,5],[9,3,9,7],[5,0,6,9],[4,1,4,11]]}
[{"$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"]
[]
["Sl.","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]
[1.0,"Testing Resources",null,"Cost of per Man month "]
["1A","Project manager/TCoE Lead",1.0,null,null,null,null,null,{"$f":"D11*C11+E11*C11+F11*C11+G11*C11+H11*C11","v":0.0},{"$f":"D11*1*C11+E11*0.90909*C11+F11*0.82645*C11+G11*0.75131*C11+H11*0.68301*C11","v":0.0}]
["1B","Test/Quality Lead",1.0,null,null,null,null,null,{"$f":"D12*C12+E12*C12+F12*C12+G12*C12+H12*C12","v":0.0},{"$f":"D12*1*C12+E12*0.90909*C12+F12*0.82645*C12+G12*0.75131*C12+H12*0.68301*C12","v":0.0}]
["1C","Test Architect (Automation)",1.0,null,null,null,null,null,{"$f":"D13*C13+E13*C13+F13*C13+G13*C13+H13*C13","v":0.0},{"$f":"D13*1*C13+E13*0.90909*C13+F13*0.82645*C13+G13*0.75131*C13+H13*0.68301*C13","v":0.0}]
["1D","Sr. SW test Engineer",6.0,null,null,null,null,null,0.0,0.0]
["1E","Jr. SW Test Engineer",10.0,null,null,null,null,null,0.0,0.0]
["1F","Sr. SW Test Engineer (Automation)",5.0,null,null,null,null,null,0.0,0.0]
["1G","Jr. SW Test Engineer (Automation)",10.0,null,null,null,null,null,0.0,0.0]
["1H","Sr. performance test engineer",2.0,null,null,null,null,null,0.0,0.0]
["1I","Jr. Performance Test Engineer",6.0,null,null,null,null,null,0.0,0.0]
["1J","Subject Matter Expert/ Business Analyst",7.0,null,null,null,null,null,0.0,0.0]
[null,"Test Environment support engg",1.0,null,null,null,null,null,{"$f":"D21*C21+E21*C21+F21*C21+G21*C21+H21*C21","v":0.0},{"$f":"D21*1*C21+E21*0.90909*C21+F21*0.82645*C21+G21*0.75131*C21+H21*0.68301*C21","v":0.0}]
[2.0,"Mobile/tab Rental Unit Cost(Per Mobile/tab Per Month)",100.0,null,null,null,null,null,{"$f":"D22*C22+E22*C22+F22*C22+G22*C22+H22*C22","v":0.0},{"$f":"D22*1*C22+E22*0.90909*C22+F22*0.82645*C22+G22*0.75131*C22+H22*0.68301*C22","v":0.0}]
[null,"TOTAL",null,null,null,null,null,null,{"$f":"SUM(I11:I22)","v":0.0},{"$f":"SUM(J11:J22)","v":0.0}]
[]
[]
[null,"The Number/Quantiy are for TCO purpose only. Actual deployment will be decided by LIC based on this rate card."]
[]
[null,"Signature of Vendor's Representative",null,null,"Date:","dd-mm-yyyy"]