{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Start","Commercial"],"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":19,"n_cols":4,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,1,1,4],[2,1,2,4],[3,1,3,4],[4,1,4,4]]}
[]
[null,"Annexure-18 - Commercial Annexure"]
[null,"Procurement and Implementation of Change Data Capture (CDC) and Extract Transform Load (ETL) Solution"]
[null,"Ref:LIC/CO/IT-SD/EFEAP-NEXT/CDC-ETL/24-25/02 Dated: 01-08-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,"Date:","dd-mm-yyyy"]
[]
[null,null,null,"Signature of Vendor/Vendor's  Representative"]

{"sheet":"Commercial","index":1,"n_rows":35,"n_cols":19,"rows_kept":35,"cut":false,"hidden":false,"merged":[[6,4,8,4],[37,1,37,7],[4,1,4,11],[0,0,0,11],[1,0,1,11],[2,0,2,11],[5,0,5,11],[6,5,6,9],[6,3,8,3],[6,1,8,1],[6,2,8,2],[32,1,32,5],[25,2,25,11],[9,10,9,11],[9,5,9,9],[29,0,29,9]]}
[{"$f":"Start!B2","v":"Annexure-18 - Commercial Annexure"}]
[{"$f":"Start!B3","v":"Procurement and Implementation of Change Data Capture (CDC) and Extract Transform Load (ETL) Solution"}]
[{"$f":"Start!B4","v":"Ref:LIC/CO/IT-SD/EFEAP-NEXT/CDC-ETL/24-25/02 Dated: 01-08-2024"}]
[]
["Bidder :"]
["Part I - Quote for Services of Software Solution License/Subscription/ATS/AMS/Onsite Engineers and implementation efforts"]
[null,"Item",null,null,null,"License/Subscrition/AMC/ATS Cost for Paid SW Per unit for each year"]
[null,null,null,null,null,"Year 1","Year 2","Year 3","Year 4","Year 5"]
["Sl. No.",null,null,null,null,1.0,0.90909,0.82645,0.75131,0.68301,"TOTAL Cost Excluding GST","Total Discouted Cost @NPV excluding GST"]
[1.0,"Software Licenses+AMC/ATS cost OR Subscription cost  ","Name of SW/Tool","License/ Subscription Base\n(Server/core/…)","Quantity/Number"]
["1A","CDC Software (Quote Quantity as per requirement)",null,null,1.0,1.0,1.0,1.0,1.0,1.0,{"$f":"SUM(F11:J11)*E11","v":5.0},{"$f":"ROUND((F11*$F$9+G11*$G$9+H11*$H$9+I11*$I$9+J11*$J$9)*E11,2)","v":4.17}]
["1B","ETL Software (Quote Quantity as per requirement)",null,null,1.0,1.0,1.0,1.0,1.0,1.0,5.0,4.17]
["1C","Data Transfer/connector tool (if not part of CDC tool)(Quote Quantity as per requirement)",null,null,1.0,1.0,1.0,1.0,1.0,1.0,5.0,4.17]
["1D","OS License Other than RHEL (Quote quantity as per requirement)",null,null,1.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
["1E","DB License Other than MySQL (Quote quantity as per requirement)",null,null,1.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
["1F","Any Other Software  (Quote quantity as per requirement)",null,null,1.0,0.0,0.0,0.0,0.0,0.0,{"$f":"SUM(F16:J16)*E16","v":0.0},{"$f":"ROUND((F16*$F$9+G16*$G$9+H16*$H$9+I16*$I$9+J16*$J$9)*E16,2)","v":0.0}]
["1G","Any Other Software  (Quote quantity as per requirement)",null,null,1.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
["1H","Any Other Software  (Quote quantity as per requirement)",null,null,1.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
["1I","Any Other Software  (Quote quantity as per requirement)",null,null,1.0,0.0,0.0,0.0,0.0,0.0,0.0,{"$f":"ROUND((F19*$F$9+G19*$G$9+H19*$H$9+I19*$I$9+J19*$J$9)*E19,2)","v":0.0}]
["1J","Any Other Software  (Quote quantity as per requirement)",null,null,1.0,0.0,0.0,0.0,0.0,0.0,0.0,{"$f":"ROUND((F20*$F$9+G20*$G$9+H20*$H$9+I20*$I$9+J20*$J$9)*E20,2)","v":0.0}]
["1K","Any Other Software  (Quote quantity as per requirement)",null,null,1.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
["1L","Any Other Software  (Quote quantity as per requirement)",null,null,1.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
["1M","Any Other Software  (Quote quantity as per requirement)",null,null,1.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
["1N","Any Other Software  (Quote quantity as per requirement)",null,null,1.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[2.0,"End to End Initial Project implementation Cost including resources",null,null,1.0,1.0,0.0,0.0,0.0,0.0,{"$f":"SUM(F25:J25)*E25","v":1.0},1.0]
[3.0,"Onsite Engineer cost per year"]
["3A","L2 Engineer (Quote Quantity as per requirement) (Minumum 5)",null,null,5.0,1.0,1.0,1.0,1.0,1.0,{"$f":"SUM(F27:J27)*E27","v":25.0},20.85]
["3B","L2 Engineer Specialized in proposed ETL Software for CADW",null,null,3.0,1.0,0.0,0.0,0.0,0.0,{"$f":"SUM(F28:J28)*E28","v":3.0},3.0]
["3C","L4 Engineer (Quote Quantity as per requirement) (Minimum 1)",null,null,1.0,1.0,1.0,1.0,1.0,1.0,{"$f":"SUM(F29:J29)*E29","v":5.0},4.17]
["Total",null,null,null,null,null,null,null,null,null,{"$f":"SUM(K11:K29)","v":49.0},{"$f":"SUM(L11:L29)","v":41.53},null,null,null,null,null,null,{"$f":"SUM(S10:S25)","v":0.0}]
[]
[]
[null,"LIC may change the actual requirement/deployment including number of Engineers based on the above rates during the project period."]
[]
[null,"Signature of Vendor's Representative",null,null,null,"Date","dd-mm-yyyy"]