{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Site Details","Staff Details","Technical_Checklist","Asset","PPM","Escalation "],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"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":"Site Details","index":0,"n_rows":8,"n_cols":2,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Site  Name","ABC Limited"]
["Description"]
["Address","Lajpat Nagar, New Delhi pin- 110065"]
["Name of Super Admin","Rohit Khurana"]
["Email of Super admin","abc@gmail.com"]
["Phone No of super admin",9999888810]
["Logo"]
["Site Reg. Office \nAddress","Goregaon, Mumbai"]

{"sheet":"Staff Details","index":1,"n_rows":22,"n_cols":6,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["Employee Name","Mobile ","Email","Role","Technician Type","Team"]
["Mohit","9191xxxxxx","abz123@gmail,com","Admin","Applicable for staff","Admin"]
["Aditi","91xxxxxxxx","optional","Staff","Electrical","Technical Team"]
["Navya","81xxxxxxxx","optional","Staff","Housekeeping","Housekeeping Team"]
["Aditi","78xxxxxxxx","optional","Staff","Housekeeping","Housekeeping Team"]
[]
[]
[]
[null,"Advisable to add email id for different Admin.  "]
[]
["User Guide"]
[null,"How to fill data template- Asset & PPM and Inventory templates in details- English: ","https://www.youtube.com/watch?v=hNmMGhQOP9g&t=103s"]
[]
[null,"https://factech.co.in/blog/ufaqs/add-employee-staff-kaizen/"]
["Add new Admins in System"]
[null,"https://factech.co.in/blog/ufaqs/how-to-create-new-admin-id-for-login/"]
[]
[null,"https://factech.co.in/blog/what-is-new/"]
["Technician Mobile App"]
[null,"https://factech.co.in/blog/what-is-new/#Technician_Mobile_App_New_Version"]
["Manage Roles & Permissions"]
[null,"https://factech.co.in/blog/ufaqs/how-to-assign-permission-to-role/"]

{"sheet":"Technical_Checklist","index":2,"n_rows":24,"n_cols":10,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["S.No.","Name","Group","Instruction","Type","Options for dropdowns only","Optional"]
[1,"DG-Every 600 Hours","Basic check","Lubricating oil & lubricating oil filter change","dropdown","Yes;No","YES"]
[null,null,"Basic check","Air filter","dropdown","Yes;No"]
[null,null,"Basic check","Fuel filters change","dropdown","Yes;No","YES"]
[null,null,"Basic check","Change radiator water and mixed coolant","dropdown","Yes;No","YES",null,null,"dropdown"]
[null,null,"Basic check","Fuel filters water separator change","dropdown","Yes;No","YES",null,null,"checkbox"]
[null,null,"Basic check","Air filters restriction check & correct","checkbox",null,"YES",null,null,"text"]
[null,null,"Basic check","Battery water check or refill","dropdown","Yes;No","YES",null,null,"file"]
[null,null,"Basic check","Overhead set - Adjust","dropdown","Yes;No","YES",null,null,"number"]
[null,null,"Basic check","Engine wiring harness - Check/replace if need","dropdown","Yes;No","YES",null,null,"document"]
[null,null,"Basic check","Engine cranking breather Clean","dropdown","Yes;No"]
[null,null,"Basic check","Ignition system - Check /Replace","text"]
[null,null,"Basic check","Is Battery Checked","dropdown","Yes;No"]
[null,null,"Photos Verification","Photo","file"]
[]
[2,"DG-LOGS","Readings","KWH","number"]
[null,null,"Readings","Running Hours","number"]
[null,null,"Readings","Diesel Consumed","number"]
[null,null,"Readings","Efficiency","number"]
[null,null,"Photos Verification","Photo","file"]
[null,null,null,null,null,null,null,null,null,"NO"]
[]
[]
[null,"Yellow fields are compulsory."]

{"sheet":"Asset","index":3,"n_rows":27,"n_cols":6,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["Asset Name","Location","Category","Serial Number","Make","Model"]
["DG- 1500 KV-1","first floor, Building 1","Electrical"]
["DG- 1500 KV-2","Ground floor","Electrical"]
["DG 700 KV-Third Floor","Third Floor","HVAC"]
[]
[]
[null,"GROUND FLOOR","Electrical"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Yellow Fields are compulsory"]
[null,"You can add any number of Properties against the asset"]
[null,"Asset Name must be unique"]
[null,"User Guide"]
[null,"https://factech.co.in/blog/ufaqs/how-to-add-asset-manually-in-kaizen/"]
[null,"Asset Dashboards"]
[null,"https://factech.co.in/blog/ufaqs/how-to-populate-asset-performance-charts-in-real-time/"]
[null,"1ST to 41 Floor"]
[null,"Sheet name \"Asset\", if we add any asset in column no A, it will be aitomatically pasted in Column A of PPM sheets"]

{"sheet":"PPM","index":4,"n_rows":23,"n_cols":8,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["Asset Name","Category","Frequency of PPM/ E-checklist","Start Date of Schedule","Time","Checklist Name","Assigned Team","Restrictions In Hrs"]
["DG- 1500 KV-1","Electrical","M","2024-03-12",9,"DG-Every 600 Hours","Technical Team",2]
["DG- 1500 KV-1","Electrical","D","2024-03-12","8, 13, 18,00,",null,"Technical Team"]
["AHU","HVAC","M","2024-05-18",14]
[null,null,"Note for Frequency"]
[null,null,"Q=Quarterly"]
[null,null,"M=Monthly"]
[null,null,"Y=Yearly"]
[null,null,"H=Half Yearly"]
[null,null,"W=Weekly"]
[null,null,"D=Daily ( Hourly will also come in daily, just need to select multiple timessss"]
[]
[null,null,"Note-Yellow Fields are compulsory"]
[null,null,"Asset Name must match with Name in Asset Sheet"]
[null,null,"Checklist Name to be provided if want to automatically map to PPM/ Schedule; Must Match with Name from Checklist sheet"]
[null,null,"Escalation Matrix must be match with Escalation Matrix sheet"]
[]
[]
[null,"User Guide","https://factech.co.in/blog/ufaqs/how-to-add-pm-schedule-manually/",null,"DG-LOGS"]
[]
[null,null,"https://factech.co.in/blog/ufaqs/how-to-add-threshold-violation-rules-in-checklist-instructions/"]
[]
[null,null,"https://factech.co.in/blog/what-is-new/#Technician_Mobile_App_New_Version"]

{"sheet":"Escalation ","index":5,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Sr.No","PM category Name ","Level","Hours After","Alert Email"]
[1,"Housekeeping","Level-1",0.5]
[null,null,"Level-2",1]
[null,null,"Level-3",1.5]
[null,null,"Level-4",2]
[2,"Plumbing","Level-1",0.5]
[null,null,"Level-2",1]
[null,null,"Level-3",1.5]
[null,null,"Level-4",2]