{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Vendor Enlistment Form","Inputs"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"comments":1,"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":"Vendor Enlistment Form","index":0,"n_rows":200,"n_cols":8,"rows_kept":200,"cut":false,"hidden":false,"merged":[[165,1,165,2],[181,1,181,2],[2,0,2,7],[147,1,148,1],[149,1,150,1],[152,1,152,2],[158,1,158,2],[115,1,115,2],[120,1,120,2],[124,1,124,2],[132,1,132,2],[135,1,135,2],[146,1,146,2],[94,1,94,2],[111,1,111,2],[5,0,5,6],[6,0,6,6],[103,1,103,2],[13,1,13,2],[21,1,21,2],[29,1,29,2],[42,1,42,2],[45,1,45,2],[58,1,58,2],[67,1,67,2],[82,1,82,2],[87,1,87,2]]}
[null,null,null,null,"Form Ref No"]
[null,null,null,null,10112017]
["Tuaman Engineering Limited"]
[]
[]
["Enlistment Form for Vendors (Suppliers)"]
["* Indicates Mandatory fields\n* Please fill data in Greyed space only\n*Please hyperlink documents in cells wherein \"Enclose Details / Enclose Certificate etc\" is written"]
[]
[]
["*","Name of Vendor",null,null,null,null,null,{"$f":"IF(C10<>\"\",1,0)","v":0}]
[]
["*","Organization Type",null,null,null,null,null,{"$f":"IF(C12<>\"\",1,0)","v":0}]
[]
[null,"Details of Head Office"]
["*","Full Address with Pincode",null,null,null,null,null,{"$f":"IF(C15<>\"\",1,0)","v":0}]
["*","Contact Person",null,null,null,null,null,0]
["*","Designation",null,null,null,null,null,0]
["*","Contact No.",null,null,null,null,null,0]
["*","Fax No",null,null,null,null,null,0]
["*","Email ID",null,null,null,null,null,0]
[]
[null,"Details of Eastern Regional Office (if any)"]
["*","Full Address with Pincode",null,null,null,null,null,{"$f":"IF(C23<>\"\",1,0)","v":0}]
["*","Contact Person",null,null,null,null,null,0]
["*","Designation",null,null,null,null,null,0]
["*","Contact No.",null,null,null,null,null,0]
["*","Fax No",null,null,null,null,null,0]
["*","Email ID",null,null,null,null,null,0]
[]
[null,"Details of Manufacturing Unit (if any)"]
["*","Full Address with Pincode",null,null,null,null,null,{"$f":"IF(C31<>\"\",1,0)","v":0}]
["*","Contact Person",null,null,null,null,null,0]
["*","Designation",null,null,null,null,null,0]
["*","Contact No.",null,null,null,null,null,0]
["*","Fax No",null,null,null,null,null,0]
["*","Email ID",null,null,null,null,null,0]
[]
["*","Company URL, if any",null,null,null,null,null,{"$f":"IF(C38<>\"\",1,0)","v":0}]
[]
["*","Item/s for which Enlistment is Sought",null,null,null,null,null,{"$f":"IF(C40<>\"\",1,0)","v":0}]
[]
[]
[null,"Details of Product / Service Range"]
["*","Enclose Catalogues & Product Range","Enclosure",null,null,null,{"$f":"HyperlinkFound(C44)","v":false},{"$f":"IF(HyperlinkFound(C44),1,0)","v":0}]
[]
[null,"Statutory Details"]
["*","Year of Establishment",null,null,null,null,null,{"$f":"IF(C47<>\"\",1,0)","v":0}]
["*","Organization Registration No. with date",34,"Enclose certificate",null,null,{"$f":"HyperlinkFound(D48)","v":true},{"$f":"IF(AND(C48<>\"\",HyperlinkFound(D48)=TRUE),1,0)","v":1}]
["*","Factory License No. with Date & Validity","E","Enclose certificate",null,null,{"$f":"HyperlinkFound(D49)","v":false},{"$f":"IF(AND(C49<>\"\",HyperlinkFound(D49)=TRUE),1,0)","v":0}]
["*","SSI/NSIC Registration No. with Date","RG","Enclose certificate",null,null,false,0]
["*","MSME Registration No. with Date",null,"Enclose certificate",null,null,true,0]
["*","Labor License No",null,"Enclose certificate",null,null,false,0]
["*","PF Registration No","HJ","Enclose certificate",null,null,false,0]
["*","PAN No","HJ","Enclose certificate",null,null,false,0]
["*","GST Registration No",null,"Enclose certificate",null,null,false,0]
["*","List of Directors","Enclose details",null,null,null,{"$f":"HyperlinkFound(C56)","v":false},{"$f":"IF(HyperlinkFound(C56),1,0)","v":0}]
["*","Clearance Certificate from Pollution Control Board","Enclose certificate",null,null,null,{"$f":"HyperlinkFound(C57)","v":true},{"$f":"IF(HyperlinkFound(C57),1,0)","v":1}]
[]
[null,"Financial Details"]
[null,null,"Turnover (INR lacs)","Net Profit (INR lacs)"]
["*","FY 2014-15",null,null,"Enclose Balance Sheet & Profit-Loss Statement",null,{"$f":"HyperlinkFound(E61)","v":true},{"$f":"IF(AND(C61<>\"\",D61<>\"\",HyperlinkFound(E61)=TRUE),1,0)","v":0}]
["*","FY 2015-16",null,null,"Enclose Balance Sheet & Profit-Loss Statement",null,{"$f":"HyperlinkFound(E62)","v":false},{"$f":"IF(AND(C62<>\"\",D62<>\"\",HyperlinkFound(E62)=TRUE),1,0)","v":0}]
["*","FY 2016-17",null,null,"Enclose Balance Sheet & Profit-Loss Statement",null,{"$f":"HyperlinkFound(E63)","v":false},{"$f":"IF(AND(C63<>\"\",D63<>\"\",HyperlinkFound(E63)=TRUE),1,0)","v":0}]
[]
["*","Enclose ITR for last 3 Financial years","Enclosure",null,null,null,{"$f":"HyperlinkFound(C65)","v":false},{"$f":"IF(HyperlinkFound(C65),1,0)","v":0}]
["*","Enclose Income Tax Clearance Certificate for last 3 Financial years","Enclosure",null,null,null,{"$f":"HyperlinkFound(C66)","v":false},{"$f":"IF(HyperlinkFound(C66),1,0)","v":0}]
[]
[null,"Banking Details"]
["*","Name of Banker - 1",null,null,null,null,null,{"$f":"IF(C69<>\"\",1,0)","v":0}]
["*","Branch Address",null,null,null,null,null,0]
["*","Account No",null,null,null,null,null,0]
["*","Account Type",null,null,null,null,null,0]
["*","Non-Fund Based Limit",null,null,null,null,null,0]
["*","Fund Based Limit",null,null,null,null,null,0]
[]
[null,"Name of Banker - 2"]
[null,"Branch Address"]
[null,"Account No"]
[null,"Account Type"]
[null,"Non-Fund Based Limit"]
[null,"Fund Based Limit"]
[]
[null,"Details of Annual Production Capacity"]
["*","Unit of Measurement (UOM)",null,null,null,null,null,{"$f":"IF(C84<>\"\",1,0)","v":0}]
["*","Annual Capacity",null,null,null,null,null,{"$f":"IF(C85<>\"\",1,0)","v":0}]
["*","Current Load (in %)",null,null,null,null,null,{"$f":"IF(C86<>\"\",1,0)","v":0}]
[]
[null,"Details of ISO Certifications"]
["*","ISO 9001",null,"Enclose certificate",null,null,{"$f":"HyperlinkFound(D89)","v":true},{"$f":"IF(OR(AND(C89=\"Yes\",HyperlinkFound(D89)=TRUE),C89=\"No\"),1,0)","v":0}]
["*","ISO 14001",null,"Enclose certificate",null,null,{"$f":"HyperlinkFound(D90)","v":true},{"$f":"IF(OR(AND(C90=\"Yes\",HyperlinkFound(D90)=TRUE),C90=\"No\"),1,0)","v":0}]
["*","ISO 18001",null,"Enclose certificate",null,null,{"$f":"HyperlinkFound(D91)","v":false},{"$f":"IF(OR(AND(C91=\"Yes\",HyperlinkFound(D91)=TRUE),C91=\"No\"),1,0)","v":0}]
["*","ISO 50001",null,"Enclose certificate",null,null,{"$f":"HyperlinkFound(D92)","v":false},{"$f":"IF(OR(AND(C92=\"Yes\",HyperlinkFound(D92)=TRUE),C92=\"No\"),1,0)","v":0}]
[null,"Any other ISO Certification",null,"Enclose certificate, if applicable"]
[]
[null,"Details of other Certifications"]
["*","PESO / CCOE","Yes","Enclose certificate",null,null,{"$f":"HyperlinkFound(D96)","v":true},{"$f":"IF(OR(AND(C96=\"Yes\",HyperlinkFound(D96)=TRUE),C96=\"No\"),1,0)","v":1}]
["*","ASME Codes Followed",null,"Enclose certificate",null,null,false,0]
["*","IBR",null,"Enclose certificate",null,null,false,0]
[]
["*","Please enclose Organization chart","Enclosure",null,null,null,{"$f":"HyperlinkFound(C100)","v":false},{"$f":"IF(HyperlinkFound(C100),1,0)","v":0}]
[]
["*","Details of Key Management Personnel","Enclosure",null,null,null,{"$f":"HyperlinkFound(C102)","v":false},{"$f":"IF(HyperlinkFound(C102),1,0)","v":0}]
[]
[null,"Manpower Distribution (in nos)"]
["*","ITI",null,null,null,null,null,{"$f":"IF(C105<>\"\",1,0)","v":0}]
["*","Diploma",null,null,null,null,null,{"$f":"IF(C106<>\"\",1,0)","v":0}]
["*","Graduates",null,null,null,null,null,{"$f":"IF(C107<>\"\",1,0)","v":0}]
["*","Post Graduates",null,null,null,null,null,{"$f":"IF(C108<>\"\",1,0)","v":0}]
["*","Others",null,null,null,null,null,{"$f":"IF(C109<>\"\",1,0)","v":0}]
[null,"Total Manpower",{"$f":"SUM(C105:C109)","v":0}]
[]
[null,"Design and Engineering"]
["*","Codes / Standards Followed",null,null,null,null,null,{"$f":"IF(C113<>\"\",1,0)","v":0}]
["*","Design / Drawings Facilities",null,null,null,null,null,0]
[]
[null,"Manufacturing Facilities"]
["*","Enclose List of Plant & Machinery","Enclosure",null,null,null,{"$f":"HyperlinkFound(C117)","v":false},{"$f":"IF(HyperlinkFound(C117),1,0)","v":0}]
["*","Size of Manufacturing Unit (in sq metres)",null,null,null,null,null,{"$f":"IF(C118<>\"\",1,0)","v":0}]
["*","Confirm whether Manufacturing facility is covered or open",null,null,null,null,null,{"$f":"IF(C119<>\"\",1,0)","v":0}]
[]
[null,"Details of Max Size of Equipment that can be dispatched"]
["*","Dimensions",null,null,null,null,null,{"$f":"IF(C122<>\"\",1,0)","v":0}]
["*","Weight (in MT)",null,null,null,null,null,{"$f":"IF(C123<>\"\",1,0)","v":0}]
[]
[null,"Details of Quality Control"]
["*","Enclose Index of Quality Control Procedures","Enclosure",null,null,null,{"$f":"HyperlinkFound(C126)","v":false},{"$f":"IF(HyperlinkFound(C126),1,0)","v":0}]
[null,"Inspection and Quality Control Records Maintained"]
["*","          Raw Material",null,"Enclose Standard Formats",null,null,null,{"$f":"IF(OR(AND(C128=\"Yes\",HyperlinkFound(D128)=TRUE),C128=\"No\",C128=\"NA\"),1,0)","v":0}]
["*","          Various Stages of Production",null,"Enclose Standard Formats",null,null,null,{"$f":"IF(OR(AND(C129=\"Yes\",HyperlinkFound(D129)=TRUE),C129=\"No\",C129=\"NA\"),1,0)","v":0}]
["*","          Sub-Vendor Inspection",null,"Enclose Standard Formats",null,null,null,0]
["*","          Final Inspection and Testing",null,"Enclose Standard Formats",null,null,null,0]
[]
[null,"Details of Quality Assurance"]
["*","Enclose Index of Quality Assurance Procedures","Enclosure",null,null,null,{"$f":"HyperlinkFound(C134)","v":false},{"$f":"IF(HyperlinkFound(C134),1,0)","v":0}]
[]
[null,"Details of Testing / Measurement Equipment"]
["*","Enclose List of Testing / Measurement Equipment with Calibration Validity","Enclosure",null,null,null,{"$f":"HyperlinkFound(C137)","v":false},{"$f":"IF(HyperlinkFound(C137),1,0)","v":0}]
[]
["*","NDT Facilities available",null,"Enclose details",null,null,{"$f":"HyperlinkFound(D139)","v":false},{"$f":"IF(OR(AND(C139=\"Yes\",HyperlinkFound(D139)=TRUE),C139=\"No\",C139=\"NA\"),1,0)","v":0}]
[]
["*","Any other Quality Certification obtained",null,"Enclose Certificate, if applicable",null,null,{"$f":"HyperlinkFound(D141)","v":false},{"$f":"IF(OR(AND(C141=\"Yes\",HyperlinkFound(D141)=TRUE),C141=\"No\"),1,0)","v":0}]
[]
["*","NABL Accreditation for Lab",null,"Enclose Certificate",null,null,{"$f":"HyperlinkFound(D143)","v":true},{"$f":"IF(OR(AND(C143=\"Yes\",HyperlinkFound(D143)=TRUE),C143=\"No\"),1,0)","v":0}]
[]
["*","Have you executed jobs under TPI Agencies / Consultants",null,null,null,null,null,{"$f":"IF(C145<>\"\",1,0)","v":0}]
[]
[null,"Details of Warehousing / Storage Facilities"]
["*","Raw Material","Storage Facility (Open or closed)",null,null,null,null,{"$f":"IF(D148<>\"\",1,0)","v":0}]
["*",null,"Size of Facility (in sq metres)",null,null,null,null,{"$f":"IF(D149<>\"\",1,0)","v":0}]
["*","Finished Product / Equipment","Storage Facility (Open or closed)",null,null,null,null,{"$f":"IF(D150<>\"\",1,0)","v":0}]
["*",null,"Size of Facility (in sq metres)",null,null,null,null,{"$f":"IF(D151<>\"\",1,0)","v":0}]
[]
[null,"Details of Material Handling Facilities"]
["*","Max weight of Equipment that can be lifted",null,"Enclose details",null,null,{"$f":"HyperlinkFound(D154)","v":true},{"$f":"IF(AND(C154<>\"\",HyperlinkFound(D154)=TRUE),1,0)","v":0}]
[]
["*","Installed Power Capacity",null,null,null,null,null,{"$f":"IF(C156<>\"\",1,0)","v":0}]
["*","Back-up Power Capacity",null,null,null,null,null,{"$f":"IF(C157<>\"\",1,0)","v":0}]
[]
[null,"Other Facilities"]
["*","Balancing Facility (Available or not)",null,"Enclose details",null,null,{"$f":"HyperlinkFound(D160)","v":true},{"$f":"IF(OR(AND(C160=\"Yes\",HyperlinkFound(D160)=TRUE),C160=\"No\",C160=\"NA\"),1,0)","v":0}]
["*","Shot Blasting Facility (Available or not)",null,"Enclose details",null,null,{"$f":"HyperlinkFound(D161)","v":false},0]
["*","Painting Facility (Available or not)",null,"Enclose details",null,null,{"$f":"HyperlinkFound(D162)","v":true},0]
["*","Heat Treatment Facility (Available or not)",null,"Enclose details",null,null,{"$f":"HyperlinkFound(D163)","v":true},0]
["*","Galvanizing Facility (Available or not)",null,"Enclose details",null,null,{"$f":"HyperlinkFound(D164)","v":false},0]
[]
[null,"Nature of Work usually Sub-Contracted"]
["*","Engineering",null,null,null,null,null,{"$f":"IF(C167<>\"\",1,0)","v":0}]
["*","Manufacturing",null,null,null,null,null,0]
["*","Labour Contract",null,null,null,null,null,0]
["*","QC / Inspection",null,null,null,null,null,0]
[]
["*","Are Resources available for Site Fabrication, Installation & Commissioning",null,"Enclose details",null,null,{"$f":"HyperlinkFound(D172)","v":false},{"$f":"IF(OR(AND(C172=\"Yes\",HyperlinkFound(D172)=TRUE),C172=\"No\",C172=\"NA\"),1,0)","v":0}]
[]
["*","Enclose list of Major Customers along-with Turnover from them in the last 3 Financial years","Enclosure",null,null,null,{"$f":"HyperlinkFound(C174)","v":false},{"$f":"IF(HyperlinkFound(C174),1,0)","v":0}]
[]
["*","Highest Valued Order Executed (in INR lacs)",null,"Enclose PO Copy",null,null,{"$f":"HyperlinkFound(D176)","v":true},{"$f":"IF(AND(C176<>\"\",HyperlinkFound(D176)=TRUE),1,0)","v":0}]
[]
["*","Enclose List of Orders Executed in the last 3 Financial years (detailing item, scope, value, date of PO, Supply date, Actual Supply date)","Enclosure",null,null,null,{"$f":"HyperlinkFound(C178)","v":false},{"$f":"IF(HyperlinkFound(C178),1,0)","v":0}]
[]
["*","Has the Vendor entered into a Tieup / Collaboration with anyone (of any kind)?",null,"Enclose Details",null,null,null,{"$f":"IF(OR(AND(C180=\"Yes\",HyperlinkFound(D180)=TRUE),C180=\"No\"),1,0)","v":0}]
[]
[null,"Safety"]
["*","Do you have a written Safety Policy?",null,"Enclose Policy",null,null,{"$f":"HyperlinkFound(D183)","v":false},{"$f":"IF(OR(AND(C183=\"Yes\",HyperlinkFound(D183)=TRUE),C183=\"No\"),1,0)","v":0}]
["*","Do you provide General Safety Awareness sessions to Employees and Workers?",null,null,null,null,null,{"$f":"IF(C184<>\"\",1,0)","v":0}]
["*","Do you encourage use of PPE (Personal Protection Equipment) at Shop floor?",null,null,null,null,null,{"$f":"IF(C185<>\"\",1,0)","v":0}]
["*","Do you Monitor and Document Safety related incidents?",null,null,null,null,null,{"$f":"IF(C186<>\"\",1,0)","v":0}]
["*","Is a Safety Officer available at the unit in all shifts ?",null,null,null,null,null,{"$f":"IF(C187<>\"\",1,0)","v":0}]
[]
["*","Are any legal cases pending against the organization",null,null,null,null,null,{"$f":"IF(C189<>\"\",1,0)","v":0}]
[]
[]
[]
[null,"Filled in by"]
[null,"Designation"]
[null,"Date"]
[null,"Place"]
[]
[]
[null,"Mandatory Fields",{"$f":"COUNTIF(A10:A189,\"*\")","v":107}]
[1,"Fields which are filled",{"$f":"COUNTIF(H10:H179,A200)","v":3}]

{"sheet":"Inputs","index":1,"n_rows":19,"n_cols":1,"rows_kept":19,"cut":false,"hidden":true,"merged":[]}
["Govt Undertaking"]
["Public Ltd"]
["Private Ltd"]
["Sole Ownership"]
["Partnership"]
["Other (Please Mention)"]
[]
["Yes"]
["No"]
[]
["Open"]
["Covered"]
[]
["Open"]
["Closed"]
["NA"]
["Yes"]
["No"]
["NA"]