{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Contractor 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":"Contractor Enlistment Form","index":0,"n_rows":149,"n_cols":8,"rows_kept":149,"cut":false,"hidden":false,"merged":[[37,1,37,2],[48,1,48,2],[57,1,57,2],[72,1,72,2],[114,1,114,2],[130,1,130,2],[2,0,2,7],[98,1,98,2],[101,1,101,2],[104,1,104,2],[107,1,107,2],[79,1,79,2],[5,0,5,6],[6,0,6,6],[88,1,88,2],[13,1,13,2],[21,1,21,2],[33,1,33,2]]}
[null,null,null,null,"Form Ref No"]
[null,null,null,null,10112017]
["Tuaman Engineering Limited"]
[]
[]
["Enlistment Form for Contractors"]
["* 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 Contractor",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]
[]
["*","Company URL, if any",null,null,null,null,null,{"$f":"IF(C30<>\"\",1,0)","v":0}]
[]
["*","Item/s for which Enlistment is Sought",null,null,null,null,null,{"$f":"IF(C32<>\"\",1,0)","v":0}]
[]
[null,"Details of Service Range"]
["*","Enclose Catalogues & Service Range","Enclosure",null,null,null,{"$f":"HyperlinkFound(C35)","v":false},{"$f":"IF(HyperlinkFound(C35),1,0)","v":0}]
["*","Type of Contractor",null,null,null,null,null,{"$f":"IF(C36<>\"\",1,0)","v":0}]
[]
[null,"Statutory Details"]
["*","Year of Establishment",null,null,null,null,null,{"$f":"IF(C39<>\"\",1,0)","v":0}]
["*","Organization Registration No. with date",34,"Enclose certificate",null,null,{"$f":"HyperlinkFound(D40)","v":true},{"$f":"IF(AND(C40<>\"\",HyperlinkFound(D40)=TRUE),1,0)","v":1}]
["*","SSI/NSIC Registration No. with Date","RG","Enclose certificate",null,null,{"$f":"HyperlinkFound(D41)","v":false},{"$f":"IF(AND(C41<>\"\",HyperlinkFound(D41)=TRUE),1,0)","v":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(C47)","v":false},{"$f":"IF(HyperlinkFound(C47),1,0)","v":0}]
[]
[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(E51)","v":true},{"$f":"IF(AND(C51<>\"\",D51<>\"\",HyperlinkFound(E51)=TRUE),1,0)","v":0}]
["*","FY 2015-16",null,null,"Enclose Balance Sheet & Profit-Loss Statement",null,{"$f":"HyperlinkFound(E52)","v":false},{"$f":"IF(AND(C52<>\"\",D52<>\"\",HyperlinkFound(E52)=TRUE),1,0)","v":0}]
["*","FY 2016-17",null,null,"Enclose Balance Sheet & Profit-Loss Statement",null,{"$f":"HyperlinkFound(E53)","v":false},{"$f":"IF(AND(C53<>\"\",D53<>\"\",HyperlinkFound(E53)=TRUE),1,0)","v":0}]
[]
["*","Enclose ITR for last 3 Financial years","Enclosure",null,null,null,{"$f":"HyperlinkFound(C55)","v":false},{"$f":"IF(HyperlinkFound(C55),1,0)","v":0}]
["*","Enclose Income Tax Clearance Certificate for last 3 Financial years","Enclosure",null,null,null,{"$f":"HyperlinkFound(C56)","v":false},{"$f":"IF(HyperlinkFound(C56),1,0)","v":0}]
[]
[null,"Banking Details"]
["*","Name of Banker - 1",null,null,null,null,null,{"$f":"IF(C59<>\"\",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 ISO Certifications"]
["*","ISO 9001",null,"Enclose certificate",null,null,{"$f":"HyperlinkFound(D74)","v":true},{"$f":"IF(OR(AND(C74=\"Yes\",HyperlinkFound(D74)=TRUE),C74=\"No\"),1,0)","v":0}]
["*","ISO 14001",null,"Enclose certificate",null,null,{"$f":"HyperlinkFound(D75)","v":true},{"$f":"IF(OR(AND(C75=\"Yes\",HyperlinkFound(D75)=TRUE),C75=\"No\"),1,0)","v":0}]
["*","ISO 18001",null,"Enclose certificate",null,null,{"$f":"HyperlinkFound(D76)","v":false},{"$f":"IF(OR(AND(C76=\"Yes\",HyperlinkFound(D76)=TRUE),C76=\"No\"),1,0)","v":0}]
["*","ISO 50001",null,"Enclose certificate",null,null,{"$f":"HyperlinkFound(D77)","v":false},{"$f":"IF(OR(AND(C77=\"Yes\",HyperlinkFound(D77)=TRUE),C77=\"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(D81)","v":true},{"$f":"IF(OR(AND(C81=\"Yes\",HyperlinkFound(D81)=TRUE),C81=\"No\",C81=\"NA\"),1,0)","v":1}]
["*","ASME Codes Followed",null,"Enclose certificate",null,null,false,{"$f":"IF(OR(AND(C82=\"Yes\",HyperlinkFound(D82)=TRUE),C82=\"No\",C82=\"NA\"),1,0)","v":0}]
["*","IBR",null,"Enclose certificate",null,null,false,0]
[]
["*","Please enclose Organization chart","Enclosure",null,null,null,{"$f":"HyperlinkFound(C85)","v":false},{"$f":"IF(HyperlinkFound(C85),1,0)","v":0}]
[]
["*","Details of Key Management Personnel","Enclosure",null,null,null,{"$f":"HyperlinkFound(C87)","v":false},{"$f":"IF(HyperlinkFound(C87),1,0)","v":0}]
[]
[null,"Manpower Distribution (in nos)"]
["*","Resident Managers / Resident Engineers",null,null,null,null,null,{"$f":"IF(C90<>\"\",1,0)","v":0}]
["*","Site Engineers (Erection and Commissioning",null,null,null,null,null,{"$f":"IF(C91<>\"\",1,0)","v":0}]
["*","Site Engineers (Quality)",null,null,null,null,null,{"$f":"IF(C92<>\"\",1,0)","v":0}]
["*","Site Safety Officers",null,null,null,null,null,{"$f":"IF(C93<>\"\",1,0)","v":0}]
["*","Site Supervisors",null,null,null,null,null,{"$f":"IF(C94<>\"\",1,0)","v":0}]
["*","Skilled Workmen",null,null,null,null,null,0]
["*","Others",null,null,null,null,null,{"$f":"IF(C96<>\"\",1,0)","v":0}]
[null,"Total Manpower",{"$f":"SUM(C90:C96)","v":0}]
[]
[null,"Tools, Tackles and Machinery"]
["*","Enclose List of Tools, Tackles and Machinery","Enclosure",null,null,null,{"$f":"HyperlinkFound(C100)","v":false},{"$f":"IF(HyperlinkFound(C100),1,0)","v":0}]
[]
[null,"Details of Quality Control"]
["*","Enclose Index of Quality Control Procedures","Enclosure",null,null,null,{"$f":"HyperlinkFound(C103)","v":false},{"$f":"IF(HyperlinkFound(C103),1,0)","v":0}]
[]
[null,"Details of Quality Assurance"]
["*","Enclose Index of Quality Assurance Procedures","Enclosure",null,null,null,{"$f":"HyperlinkFound(C106)","v":false},{"$f":"IF(HyperlinkFound(C106),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(C109)","v":false},{"$f":"IF(HyperlinkFound(C109),1,0)","v":0}]
[]
["*","Any other Quality Certification obtained",null,"Enclose Certificate, if applicable",null,null,{"$f":"HyperlinkFound(D111)","v":false},{"$f":"IF(OR(AND(C111=\"Yes\",HyperlinkFound(D111)=TRUE),C111=\"No\"),1,0)","v":0}]
[]
["*","Have you executed jobs under TPI Agencies / Consultants",null,null,null,null,null,{"$f":"IF(C113<>\"\",1,0)","v":0}]
[]
[null,"Nature of Work usually Sub-Contracted"]
["*","Engineering",null,null,null,null,null,{"$f":"IF(C116<>\"\",1,0)","v":0}]
["*","Site Fabrication",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(D121)","v":false},{"$f":"IF(OR(AND(C121=\"Yes\",HyperlinkFound(D121)=TRUE),C121=\"No\",C121=\"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(C123)","v":false},{"$f":"IF(HyperlinkFound(C123),1,0)","v":0}]
[]
["*","Highest Valued Order Executed (in INR lacs)",null,"Enclose PO Copy",null,null,{"$f":"HyperlinkFound(D125)","v":true},{"$f":"IF(AND(C125<>\"\",HyperlinkFound(D125)=TRUE),1,0)","v":0}]
[]
["*","Enclose List of Orders Executed in the last 3 Financial years (detailing scope, nature of job, value, date of PO, Time Schedule, Contractual Completion date and Actual Completion date)","Enclosure",null,null,null,{"$f":"HyperlinkFound(C127)","v":false},{"$f":"IF(HyperlinkFound(C127),1,0)","v":0}]
[]
["*","Has the Contractor entered into a Tie-up / Collaboration with anyone (any kind) ?",null,"Enclose Details",null,null,null,{"$f":"IF(OR(AND(C129=\"Yes\",HyperlinkFound(D129)=TRUE),C129=\"No\"),1,0)","v":0}]
[]
[null,"Safety"]
["*","Do you have a written Safety Policy?",null,"Enclose Policy",null,null,{"$f":"HyperlinkFound(D132)","v":false},{"$f":"IF(OR(AND(C132=\"Yes\",HyperlinkFound(D132)=TRUE),C132=\"No\"),1,0)","v":0}]
["*","Do you provide General Safety Awareness sessions to Employees and Workers?",null,null,null,null,null,{"$f":"IF(C133<>\"\",1,0)","v":0}]
["*","Do you encourage use of PPE (Personal Protection Equipment) at Site?",null,null,null,null,null,{"$f":"IF(C134<>\"\",1,0)","v":0}]
["*","Do you Monitor and Document Safety related incidents?",null,null,null,null,null,{"$f":"IF(C135<>\"\",1,0)","v":0}]
["*","Is a Safety Officer available at the Site in all shifts ?",null,null,null,null,null,{"$f":"IF(C136<>\"\",1,0)","v":0}]
[]
["*","Are any legal cases pending against the organization",null,null,null,null,null,{"$f":"IF(C138<>\"\",1,0)","v":0}]
[]
[]
[]
[null,"Filled in by"]
[null,"Designation"]
[null,"Date"]
[null,"Place"]
[]
[]
[null,"Mandatory Fields",{"$f":"COUNTIF(A10:A138,\"*\")","v":75}]
[1,"Fields which are filled",{"$f":"COUNTIF(H10:H128,A149)","v":2}]

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