{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["2017","Sheet2","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":1,"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":"2017","index":0,"n_rows":41,"n_cols":5,"rows_kept":41,"cut":false,"hidden":false,"merged":[[3,0,9,0],[10,0,14,0],[2,0,2,2],[36,0,40,0],[22,0,26,0],[27,0,31,0],[32,0,35,0],[15,0,21,0]]}
["Monthly Operations Reporting",null,null,{"$f":"STARTDATE2()","v":{"$error":"#NAME?"}}]
[]
[{"$f":"YEAR(D1)","v":{"$error":"#NAME?"}},null,null,{"$f":"MONTH(D1)","v":{"$error":"#NAME?"}}," definition"]
["Output","Product line 1 (Cylinders)","pcs",null,"Output volume per product line"]
[null,"Product line 2 (Locks)","pcs"]
[null,"Product line 3 (Handles)","pcs"]
[null,"Product line 4 (Safe boxes)","pcs"]
[null,"Product line 5 (Padlocks )","pcs"]
[null,"Total pcs","pcs"]
[null,"Total standard hours","hrs",null,"Standard hours or equivalent"]
["Delivery","Customer OFR","%",{"$f":"CUSTOFR(A3,D3)","v":{"$error":"#NAME?"}},"Total number of fulfilled (date, qulity, amount) order lines / total number of order lines to customer site"]
[null,"Supplier OFR","%",{"$f":"SUPPLOFR(A3,D3)","v":{"$error":"#NAME?"}},"Total number of fulfilled (date, qulity, amount) order lines by our suppliers / total number of order lines"]
[null,"Production OFR","%",{"$f":"PRODOFR(A3,D3)","v":{"$error":"#NAME?"}},"Sum of delivered orders on time internally / sum of all orders delivered internally"]
[null,"Average lead time (days)","days",{"$f":"AVGTIME(A3,D3)","v":{"$error":"#NAME?"}},"Average lead time of delivered items in a month"]
[null,"Order backlog (overdue orders)","k loc. Cur",{"$f":"BACKLOG(A3,D3)","v":{"$error":"#NAME?"}},"Total value of orders currently overdue at month end vs expected customer delivery date"]
["People","Direct Production Labour HC","HC",null,"Number of direct labor employees - permanent and temp together"]
[null,"Direct Production Labour Temporary HC","HC",null,"Number of direct temporary labor employees (agency, with limited contract)"]
[null,"Indirect Production Labour HC","HC",null,"Number of indirect prodution labor employees "]
[null,"Total number of clocked hours (incl overtime)","hrs",null,"Total number of clocked hours in the month excluding holidays, sickness, absence etc"]
[null,"Plant efficiency (std hrs/clocked hrs)","%",null,"Technical efficiency measure (std hrs / clocked hrs)"]
[null,"Overtime in % - DL only","%",null,"(Overtime / Standard working time) *100"]
[null,"Absenteeism in % - DL only","%",null,"(Absentee time / Standard working time)*100 "]
["Safety","Number of days lost due to injuries","days",null,"Number of lost days due to injuries in a month"]
[null,"Number of injuries resulting in lost days","no.",null,"Number of injuries resulting in >1 lost day in a month"]
[null,"Injury lost day rate (ILDR)","no.",null,"Number of lost days due to injury / Number of hours worked * 1,000,000"]
[null,"Injury rate (IR)","no.",null,"Number of injuries resulting in >1 lost day / Number of hours worked * 1,000,000"]
[null,"No. of near misses reported","no.",null,"Sum of opportunities for improvement in Health, safety and environment"]
["Quality","Customer quality DPPM ","no.",null,"Sum of defected parts at the customer / sum of total parts produced * 1,000,000"]
[null,"Customer Quality - Speed of resolution","days",null,"Average of speed of resolution in days"]
[null,"Supplier quality DPPM","no.",null,"Sum of defected parts from supplier / sum of total parts recieved from suppliers * 1,000,000"]
[null,"Supplier Quality - Speed of resolution ","days",null,"Average of speed of resolution in days"]
[null,"Internal quality - rework in hrs","hrs",null,"Sum of hours spent on rework, repair (not first time right)"]
["Inventory","MTPT","days",null,"As reported in HFM"]
[null,"Raw materials value (k local currency)","k loc. Cur",null,"As per HFM"]
[null,"WIP value (k local currency)","k loc. Cur",null,"As per HFM"]
[null,"Finished Goods value (k local currency)","k loc. Cur",null,"As per HFM"]
["OEE","OEE AA machine 1 (TORNOS Deco 26A)","%",null,"OEE of main Bottleneck machines with \"AA\" TPM classification"]
[null,"OEE AA machine 2 (Quicktech i42)","%"]
[null,"OEE AA machine 3 (HiTurn A65-9 X)","%"]
[null,"OEE AA machine 4 (Traub TNL 18)","%"]
[null,"OEE AA machine 5 (Okuma LT 2000 EX)","%"]

{"sheet":"Sheet2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}