{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Cover","Summary","Overview of measures","1. Documentation","2. Use and installation","3. Control syst. + command","4. Protection against mech. haz","5. Other hazards ","6. Setting up Maintanace Serv.","7. Risk ass. with electr. Energ","8. Ergonomie","FAQ","D 02-044 PL"],"not_rendered":{"charts":2,"images":7,"macros":1,"external_links":0,"defined_names":35,"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":"Cover","index":0,"n_rows":56,"n_cols":5,"rows_kept":56,"cut":false,"hidden":false,"merged":[[28,1,28,4],[32,1,32,3],[12,1,12,4],[16,0,16,4],[20,1,20,4],[22,1,22,4],[24,1,24,4],[26,1,26,4],[11,1,11,4],[3,4,3,7],[7,1,7,4],[8,1,8,4],[9,1,9,4],[10,1,10,4]]}
["I. Nature of the inspection "]
[]
[null,null,null,null,"Transaction No.:"]
[]
[]
["II. Details of the machine"]
[]
["Designation"]
["Type"]
["Serial No. "]
["Year of construction "]
["Manufacturer / Supplier"]
["Location"]
[]
["III. Scope of the inspection: "]
[]
["All safety related functions and components must satisfy the requirements of the FSS 5 General Machine Safety Checklist and local relevant standards as a minimum requirement. NOTE: If machines are used in conjunction with other machines or equipment, a supplementary safety check must be carried out with reference to the checklist for concatenated systems (Attachment 2). "]
[]
["IV. Results of the inspection "]
[]
[null,"The machine/apparatus/system complies with the current FSS 5 checklist"]
[]
[null,"The machine / system does not meet every requirement of the FSS 5 checklist. However, the machine / system may be used as the functions concerned are not critical in terms of safety."]
[]
[null,"The machine/apparatus/system does not comply with the current FSS 5 checklist."]
[]
[null,"The machine/apparatus/system will be upgraded."]
[null,"Initial cost estimate: ",null,"Date:"]
[null,"Renewed inspection required!"]
[]
[null,"The machine/apparatus/system will be removed from service"]
[null,"on:",null,"at the latest."]
[null,"Technical and/or organizational measures as laid down in the appendix will be implemented to ensure safe operation up to this date."]
[]
[null,"Date of next scheduled inspection:"]
[]
[]
["V. Distribution list "]
[]
[]
[null,null,"Name","Function"]
[]
["Person responsible for corrective action and improvements: "]
[]
["Person responsible for documentation, filing and archiving: "]
[]
[]
[]
[]
["VI. Inspection conducted by: "]
[]
[" ","Mechanical part ","Electrical part ","Owner","Other "]
["Name"]
["Function"]
["Date"]
["Signature"]

{"sheet":"Summary","index":1,"n_rows":50,"n_cols":3,"rows_kept":50,"cut":false,"hidden":false,"merged":[[18,2,20,2],[3,0,4,1],[3,2,4,2],[49,0,52,2]]}
[]
["Summary FSS 5 - Check"]
[]
["internal machine/system designation",null,{"$f":"IF(Cover!B8=\"\",\"\",Cover!B8)","v":""}]
[]
["Transaction No.:",null,{"$f":"IF(Cover!E4=\"\",\"\",Cover!E4)","v":""}]
[]
["Chapter","Assessment","Description"]
[1,{"$f":"'Overview of measures'!G7","v":0.20833333333333334},"Documentation "]
[2,{"$f":"'Overview of measures'!G35","v":0.5714285714285714},"Use and installation"]
[3,{"$f":"'Overview of measures'!G46","v":0.49056603773584906},"Control systems and command facilities (operator control elements)"]
[4,{"$f":"'Overview of measures'!G114","v":0.7142857142857143},"Protection against mechanical hazards"]
[5,{"$f":"'Overview of measures'!G160","v":0.83333333333333337},"Other hazards"]
[6,{"$f":"'Overview of measures'!G173","v":1},"Setting up / Maintenance / Service"]
[7,{"$f":"'Overview of measures'!G195","v":0.45454545454545453},"Risks associated with electrical energy"]
[8,{"$f":"'Overview of measures'!#REF!","v":{"$error":"#REF!"}},"Ergonomie"]
[null,{"$f":"SUBTOTAL(101,Summary!$B$9:$B$15)","v":0.61035606352317939}]
[]
[null,null,"[%] TOTAL RESULT incl. execution of the measures"]
[]
[]
[]
[]
[]
[null,{"$f":"SUM(B26:B28)","v":151},"Questions from 151 answer"]
[{"$f":"B26/$B$25","v":0.55629139072847678},{"$f":"'Overview of measures'!B217","v":84}," OK "]
[{"$f":"B27/$B$25","v":0},{"$f":"'Overview of measures'!B218","v":0},"NR (not relevant)"]
[{"$f":"B28/$B$25","v":0.44370860927152317},{"$f":"'Overview of measures'!B216","v":67},"NOK"]
[{"$f":"B29/B28","v":4.4776119402985072E-2},{"$f":"'Overview of measures'!L6","v":3},"sicherheitsrelevanten Punkte"]
[null,{"$f":"B28-B29","v":64}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["ERGEBNIS DER PRÜFUNG"]
[{"$f":"IF(#REF!=\"X\",#REF!,(IF(#REF!=\"X\",#REF!,(IF(#REF!=\"X\",#REF!,0)))))","v":{"$error":"#REF!"}}]

{"sheet":"Overview of measures","index":2,"n_rows":220,"n_cols":12,"rows_kept":220,"cut":false,"hidden":false,"merged":[[3,6,4,6],[3,0,3,1],[4,0,4,1],[8,7,24,7],[1,8,5,8],[7,8,10,8]]}
[]
[" Overview of measures FSS 5- Check",null,null,null,null,null,null,0,"% enclosed\n25 % design/conceptual design\n50 % start implementation\n75 %  implemented\n100 % measures implemented  / effictiveness checked"]
[null,null,null,null,null,null,null,0.25]
["internal machine/system designation",null,{"$f":"IF(Cover!B8=\"\",\"\",Cover!B8)","v":""},null,null,null,"NR = not relevant\nOK = in order / fine \nNOK = not in order",0.5]
["Transaction No.:",null,{"$f":"IF(Cover!E4=\"\",\"\",Cover!E4)","v":""},null,null,null,null,0.75]
[null,null,null,null,null,null,null,1,null,null,null,{"$f":"SUM(L9:L211)","v":3}]
["1. Documentation ",null,null,{"$f":"IF(B33>0,\"answered incompletely\",\"answer completely\")","v":"answer completely"},null,null,{"$f":"AVERAGE('Overview of measures'!$G$9:$G$32)","v":0.20833333333333334}]
["Question No.","Assessment","Measures","Who","Date","Effectiveness check","% closed",null,"NR = not relevant [100%]\nOK = in order / fine [100 %]\nNOK = not in order [0 %]\nblank = missing answer [0 %]","T1","BW","Rel"]
["1.1",{"$f":"'1. Documentation'!J2","v":"OK"},{"$f":"IF('1. Documentation'!J2=\"NOK\",'1. Documentation'!I2,\"none\")","v":"none"},null,null,null,{"$f":"IF('Overview of measures'!$B9=\"OK\",1,IF('Overview of measures'!$B9=\"NR\",1,0))","v":1},null,null,{"$f":"IF(B9=\"NOK\",1,0)","v":0},{"$f":"IF(J9=FALSE,1,0)","v":0},{"$f":"IF(AND('1. Documentation'!E2=\"NOK\",'1. Documentation'!B2=\"J\"),1,0)","v":0}]
["1.2",{"$f":"'1. Documentation'!J3","v":"NOK"},{"$f":"IF('1. Documentation'!J3=\"NOK\",'1. Documentation'!I3,\"none\")","v":0},null,null,null,{"$f":"IF('Overview of measures'!$B10=\"OK\",1,IF('Overview of measures'!$B10=\"NR\",1,0))","v":0},null,null,{"$f":"IF(B10=\"NOK\",1,0)","v":1},{"$f":"IF(J10=FALSE,1,0)","v":0},{"$f":"IF(AND('1. Documentation'!E3=\"NOK\",'1. Documentation'!B3=\"J\"),1,0)","v":0}]
["1.3",{"$f":"'1. Documentation'!J4","v":"OK"},{"$f":"IF('1. Documentation'!J4=\"NOK\",'1. Documentation'!I4,\"none\")","v":"none"},null,null,null,{"$f":"IF('Overview of measures'!$B11=\"OK\",1,IF('Overview of measures'!$B11=\"NR\",1,0))","v":1},null,null,0,0,{"$f":"IF(AND('1. Documentation'!E4=\"NOK\",'1. Documentation'!B4=\"J\"),1,0)","v":0}]
["1.4",{"$f":"'1. Documentation'!J5","v":"NOK"},{"$f":"IF('1. Documentation'!J5=\"NOK\",'1. Documentation'!I5,\"none\")","v":0},null,null,null,{"$f":"IF('Overview of measures'!$B12=\"OK\",1,IF('Overview of measures'!$B12=\"NR\",1,0))","v":0},null,null,1,0,{"$f":"IF(AND('1. Documentation'!E5=\"NOK\",'1. Documentation'!B5=\"J\"),1,0)","v":1}]
["1.5",{"$f":"'1. Documentation'!J6","v":"NOK"},{"$f":"IF('1. Documentation'!J6=\"NOK\",'1. Documentation'!I6,\"none\")","v":0},null,null,null,{"$f":"IF('Overview of measures'!$B13=\"OK\",1,IF('Overview of measures'!$B13=\"NR\",1,0))","v":0},null,null,1,0,{"$f":"IF(AND('1. Documentation'!E6=\"NOK\",'1. Documentation'!B6=\"J\"),1,0)","v":1}]
["1.6",{"$f":"'1. Documentation'!J7","v":"NOK"},{"$f":"IF('1. Documentation'!J7=\"NOK\",'1. Documentation'!I7,\"none\")","v":0},null,null,null,{"$f":"IF('Overview of measures'!$B14=\"OK\",1,IF('Overview of measures'!$B14=\"NR\",1,0))","v":0},null,null,1,0,{"$f":"IF(AND('1. Documentation'!E7=\"NOK\",'1. Documentation'!B7=\"J\"),1,0)","v":0}]
["1.7",{"$f":"'1. Documentation'!J8","v":"NOK"},{"$f":"IF('1. Documentation'!J8=\"NOK\",'1. Documentation'!I8,\"none\")","v":0},null,null,null,{"$f":"IF('Overview of measures'!$B15=\"OK\",1,IF('Overview of measures'!$B15=\"NR\",1,0))","v":0},null,null,1,0,{"$f":"IF(AND('1. Documentation'!E8=\"NOK\",'1. Documentation'!B8=\"J\"),1,0)","v":0}]
["1.8",{"$f":"'1. Documentation'!J9","v":"NOK"},{"$f":"IF('1. Documentation'!J9=\"NOK\",'1. Documentation'!I9,\"none\")","v":0},null,null,null,{"$f":"IF('Overview of measures'!$B16=\"OK\",1,IF('Overview of measures'!$B16=\"NR\",1,0))","v":0},null,null,1,0,{"$f":"IF(AND('1. Documentation'!E9=\"NOK\",'1. Documentation'!B9=\"J\"),1,0)","v":0}]
["1.9",{"$f":"'1. Documentation'!J10","v":"NOK"},{"$f":"IF('1. Documentation'!J10=\"NOK\",'1. Documentation'!I10,\"none\")","v":0},null,null,null,{"$f":"IF('Overview of measures'!$B17=\"OK\",1,IF('Overview of measures'!$B17=\"NR\",1,0))","v":0},null,null,1,0,{"$f":"IF(AND('1. Documentation'!E10=\"NOK\",'1. Documentation'!B10=\"J\"),1,0)","v":1}]
["1.10",{"$f":"'1. Documentation'!J11","v":"NOK"},{"$f":"IF('1. Documentation'!J11=\"NOK\",'1. Documentation'!I11,\"none\")","v":0},null,null,null,{"$f":"IF('Overview of measures'!$B18=\"OK\",1,IF('Overview of measures'!$B18=\"NR\",1,0))","v":0},null,null,1,0,{"$f":"IF(AND('1. Documentation'!E11=\"NOK\",'1. Documentation'!B11=\"J\"),1,0)","v":0}]
["1.11",{"$f":"'1. Documentation'!J12","v":"NOK"},{"$f":"IF('1. Documentation'!J12=\"NOK\",'1. Documentation'!I12,\"none\")","v":0},null,null,null,{"$f":"IF('Overview of measures'!$B19=\"OK\",1,IF('Overview of measures'!$B19=\"NR\",1,0))","v":0},null,null,1,0,{"$f":"IF(AND('1. Documentation'!E12=\"NOK\",'1. Documentation'!B12=\"J\"),1,0)","v":0}]
["1.12",{"$f":"'1. Documentation'!J13","v":"NOK"},{"$f":"IF('1. Documentation'!J13=\"NOK\",'1. Documentation'!I13,\"none\")","v":0},null,null,null,{"$f":"IF('Overview of measures'!$B20=\"OK\",1,IF('Overview of measures'!$B20=\"NR\",1,0))","v":0},null,null,1,0,{"$f":"IF(AND('1. Documentation'!E13=\"NOK\",'1. Documentation'!B13=\"J\"),1,0)","v":0}]
["1.13",{"$f":"'1. Documentation'!J14","v":"NOK"},{"$f":"IF('1. Documentation'!J14=\"NOK\",'1. Documentation'!I14,\"none\")","v":0},null,null,null,{"$f":"IF('Overview of measures'!$B21=\"OK\",1,IF('Overview of measures'!$B21=\"NR\",1,0))","v":0},null,null,1,0,{"$f":"IF(AND('1. Documentation'!E14=\"NOK\",'1. Documentation'!B14=\"J\"),1,0)","v":0}]
["1.14",{"$f":"'1. Documentation'!J15","v":"OK"},{"$f":"IF('1. Documentation'!J15=\"NOK\",'1. Documentation'!I15,\"none\")","v":"none"},null,null,null,{"$f":"IF('Overview of measures'!$B22=\"OK\",1,IF('Overview of measures'!$B22=\"NR\",1,0))","v":1}]
["1.15",{"$f":"'1. Documentation'!J16","v":"NOK"},{"$f":"IF('1. Documentation'!J16=\"NOK\",'1. Documentation'!I16,\"none\")","v":0},null,null,null,{"$f":"IF('Overview of measures'!$B23=\"OK\",1,IF('Overview of measures'!$B23=\"NR\",1,0))","v":0},null,null,1,0,{"$f":"IF(AND('1. Documentation'!E16=\"NOK\",'1. Documentation'!B16=\"J\"),1,0)","v":0}]
["1.16",{"$f":"'1. Documentation'!J17","v":"NOK"},{"$f":"IF('1. Documentation'!J17=\"NOK\",'1. Documentation'!I17,\"none\")","v":0},null,null,null,{"$f":"IF('Overview of measures'!$B24=\"OK\",1,IF('Overview of measures'!$B24=\"NR\",1,0))","v":0},null,null,1,0,{"$f":"IF(AND('1. Documentation'!E17=\"NOK\",'1. Documentation'!B17=\"J\"),1,0)","v":0}]
["1.17",{"$f":"'1. Documentation'!J18","v":"OK"},{"$f":"IF('1. Documentation'!J18=\"NOK\",'1. Documentation'!I18,\"none\")","v":"none"},null,null,null,{"$f":"IF('Overview of measures'!$B25=\"OK\",1,IF('Overview of measures'!$B25=\"NR\",1,0))","v":1},null,null,0,0,{"$f":"IF(AND('1. Documentation'!E18=\"NOK\",'1. Documentation'!B18=\"J\"),1,0)","v":0}]
["1.18",{"$f":"'1. Documentation'!J21","v":"NOK"},{"$f":"IF('1. Documentation'!J21=\"NOK\",'1. Documentation'!I21,\"none\")","v":0},null,null,null,{"$f":"IF('Overview of measures'!$B26=\"OK\",1,IF('Overview of measures'!$B26=\"NR\",1,0))","v":0}]
["1.19",{"$f":"'1. Documentation'!J22","v":"NOK"},{"$f":"IF('1. Documentation'!J22=\"NOK\",'1. Documentation'!I22,\"none\")","v":0},null,null,null,{"$f":"IF('Overview of measures'!$B27=\"OK\",1,IF('Overview of measures'!$B27=\"NR\",1,0))","v":0}]
["1.20",{"$f":"'1. Documentation'!J23","v":"NOK"},{"$f":"IF('1. Documentation'!J23=\"NOK\",'1. Documentation'!I23,\"none\")","v":0},null,null,null,{"$f":"IF('Overview of measures'!$B28=\"OK\",1,IF('Overview of measures'!$B28=\"NR\",1,0))","v":0}]
["1.21",{"$f":"'1. Documentation'!J24","v":"NOK"},{"$f":"IF('1. Documentation'!J24=\"NOK\",'1. Documentation'!I24,\"none\")","v":0},null,null,null,{"$f":"IF('Overview of measures'!$B29=\"OK\",1,IF('Overview of measures'!$B29=\"NR\",1,0))","v":0}]
["1.22",{"$f":"'1. Documentation'!J25","v":"NOK"},{"$f":"IF('1. Documentation'!J25=\"NOK\",'1. Documentation'!I25,\"none\")","v":0},null,null,null,{"$f":"IF('Overview of measures'!$B30=\"OK\",1,IF('Overview of measures'!$B30=\"NR\",1,0))","v":0}]
["1.23",{"$f":"'1. Documentation'!J26","v":"NOK"},{"$f":"IF('1. Documentation'!J26=\"NOK\",'1. Documentation'!I26,\"none\")","v":0},null,null,null,{"$f":"IF('Overview of measures'!$B31=\"OK\",1,IF('Overview of measures'!$B31=\"NR\",1,0))","v":0}]
["1.24",{"$f":"'1. Documentation'!J27","v":"OK"},{"$f":"IF('1. Documentation'!J27=\"NOK\",'1. Documentation'!I27,\"none\")","v":"none"},null,null,null,{"$f":"IF('Overview of measures'!$B32=\"OK\",1,IF('Overview of measures'!$B32=\"NR\",1,0))","v":1}]
[null,{"$f":"COUNTIFS(B9:B25,\"blank\")","v":0},null,null,null,null,{"$f":"SUBTOTAL(101,'Overview of measures'!$G$9:$G$32)","v":0.20833333333333334},null,null,0,0,{"$f":"IF(AND('1. Documentation'!E19=\"NOK\",'1. Documentation'!B19=\"J\"),1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,0,0,{"$f":"IF(AND('1. Documentation'!E20=\"NOK\",'1. Documentation'!B20=\"J\"),1,0)","v":0}]
["2. Use / Installation ",null,null,{"$f":"IF(B44>0,\"answered incompletely\",\"answer completely\")","v":"answer completely"},null,null,{"$f":"AVERAGE('Overview of measures'!$G$37:$G$43)","v":0.5714285714285714},null,null,1,0,{"$f":"IF(AND('1. Documentation'!E21=\"NOK\",'1. Documentation'!B21=\"J\"),1,0)","v":0}]
["Question No.","Assessment","Measures","Who","Date","Effectiveness check","% closed",null,null,0,0,{"$f":"IF(AND('1. Documentation'!E22=\"NOK\",'1. Documentation'!B22=\"J\"),1,0)","v":0}]
["2.1",{"$f":"'2. Use and installation'!J2","v":"OK"},{"$f":"IF('2. Use and installation'!J2=\"NOK\",'2. Use and installation'!I2,\"none\")","v":"none"},null,null,null,{"$f":"IF('Overview of measures'!$B37=\"OK\",1,IF('Overview of measures'!$B37=\"NR\",1,0))","v":1},null,null,0,0,{"$f":"IF(AND('1. Documentation'!E23=\"NOK\",'1. Documentation'!B23=\"J\"),1,0)","v":0}]
["2.2",{"$f":"'2. Use and installation'!J3","v":"NOK"},{"$f":"IF('2. Use and installation'!J3=\"NOK\",'2. Use and installation'!I3,\"none\")","v":0},null,null,null,{"$f":"IF('Overview of measures'!$B38=\"OK\",1,IF('Overview of measures'!$B38=\"NR\",1,0))","v":0},null,null,1,0,{"$f":"IF(AND('1. Documentation'!E24=\"NOK\",'1. Documentation'!B24=\"J\"),1,0)","v":0}]
["2.3",{"$f":"'2. Use and installation'!J4","v":"OK"},{"$f":"IF('2. Use and installation'!J4=\"NOK\",'2. Use and installation'!I4,\"none\")","v":"none"},null,null,null,{"$f":"IF('Overview of measures'!$B39=\"OK\",1,IF('Overview of measures'!$B39=\"NR\",1,0))","v":1},null,null,0,0,{"$f":"IF(AND('1. Documentation'!E25=\"NOK\",'1. Documentation'!B25=\"J\"),1,0)","v":0}]
["2.4",{"$f":"'2. Use and installation'!J5","v":"NOK"},{"$f":"IF('2. Use and installation'!J5=\"NOK\",'2. Use and installation'!I5,\"none\")","v":0},null,null,null,{"$f":"IF('Overview of measures'!$B40=\"OK\",1,IF('Overview of measures'!$B40=\"NR\",1,0))","v":0},null,null,1,0,{"$f":"IF(AND('1. Documentation'!E26=\"NOK\",'1. Documentation'!B26=\"J\"),1,0)","v":0}]
["2.5",{"$f":"'2. Use and installation'!J6","v":"OK"},{"$f":"IF('2. Use and installation'!J6=\"NOK\",'2. Use and installation'!I6,\"none\")","v":"none"},null,null,null,{"$f":"IF('Overview of measures'!$B41=\"OK\",1,IF('Overview of measures'!$B41=\"NR\",1,0))","v":1},null,null,0,0,{"$f":"IF(AND('1. Documentation'!E27=\"NOK\",'1. Documentation'!B27=\"J\"),1,0)","v":0}]
["2.6",{"$f":"'2. Use and installation'!J7","v":"NOK"},{"$f":"IF('2. Use and installation'!J7=\"NOK\",'2. Use and installation'!I7,\"none\")","v":0},null,null,null,{"$f":"IF('Overview of measures'!$B42=\"OK\",1,IF('Overview of measures'!$B42=\"NR\",1,0))","v":0},null,null,1,0,{"$f":"IF(AND('1. Documentation'!E28=\"NOK\",'1. Documentation'!B28=\"J\"),1,0)","v":0}]
["2.7",{"$f":"'2. Use and installation'!J8","v":"OK"},{"$f":"IF('2. Use and installation'!J8=\"NOK\",'2. Use and installation'!I8,\"none\")","v":"none"},null,null,null,{"$f":"IF('Overview of measures'!$B43=\"OK\",1,IF('Overview of measures'!$B43=\"NR\",1,0))","v":1},null,null,0,0,{"$f":"IF(AND('1. Documentation'!E29=\"NOK\",'1. Documentation'!B29=\"J\"),1,0)","v":0}]
[null,{"$f":"COUNTIFS(B37:B43,\"blank\")","v":0},null,null,null,null,{"$f":"SUBTOTAL(101,'Overview of measures'!$G$37:$G$43)","v":0.5714285714285714},null,null,0,0,{"$f":"IF(AND('1. Documentation'!E30=\"NOK\",'1. Documentation'!B30=\"J\"),1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,0,0,{"$f":"IF(AND('1. Documentation'!E31=\"NOK\",'1. Documentation'!B31=\"J\"),1,0)","v":0}]
["3. Control systems and command facilities (operator control elements)",null,null,{"$f":"IF(B112>0,\"answered incompletely\",\"answer completely\")","v":"answer completely"},null,null,{"$f":"AVERAGE('Overview of measures'!$G$48:$G$111)","v":0.49056603773584906},null,null,1,0,{"$f":"IF(AND('1. Documentation'!E32=\"NOK\",'1. Documentation'!B32=\"J\"),1,0)","v":0}]
["Question No.","Assessment","Measures","Who","Date","Effectiveness check","% closed",null,null,0,0,{"$f":"IF(AND('1. Documentation'!E33=\"NOK\",'1. Documentation'!B33=\"J\"),1,0)","v":0}]
["3.1",{"$f":"'3. Control syst. + command'!J2","v":"NOK"},{"$f":"IF('3. Control syst. + command'!J2=\"NOK\",'3. Control syst. + command'!I2,\"none\")","v":0},null,null,null,{"$f":"IF('Overview of measures'!$B48=\"OK\",1,IF('Overview of measures'!$B48=\"NR\",1,0))","v":0},null,null,1,0,{"$f":"IF(AND('1. Documentation'!E34=\"NOK\",'1. Documentation'!B34=\"J\"),1,0)","v":0}]
["3.2",{"$f":"'3. Control syst. + command'!J3","v":"OK"},{"$f":"IF('3. Control syst. + command'!J3=\"NOK\",'3. Control syst. + command'!I3,\"none\")","v":"none"},null,null,null,{"$f":"IF('Overview of measures'!$B49=\"OK\",1,IF('Overview of measures'!$B49=\"NR\",1,0))","v":1},null,null,0,0,{"$f":"IF(AND('1. Documentation'!E35=\"NOK\",'1. Documentation'!B35=\"J\"),1,0)","v":0}]
["3.3",{"$f":"'3. Control syst. + command'!J4","v":"NOK"},{"$f":"IF('3. Control syst. + command'!J4=\"NOK\",'3. Control syst. + command'!I4,\"none\")","v":0},null,null,null,{"$f":"IF('Overview of measures'!$B50=\"OK\",1,IF('Overview of measures'!$B50=\"NR\",1,0))","v":0},null,null,1,0,{"$f":"IF(AND('1. Documentation'!E36=\"NOK\",'1. Documentation'!B36=\"J\"),1,0)","v":0}]
["3.4",{"$f":"'3. Control syst. + command'!J5","v":"OK"},{"$f":"IF('3. Control syst. + command'!J5=\"NOK\",'3. Control syst. + command'!I5,\"none\")","v":"none"},null,null,null,{"$f":"IF('Overview of measures'!$B51=\"OK\",1,IF('Overview of measures'!$B51=\"NR\",1,0))","v":1},null,null,0,0,{"$f":"IF(AND('1. Documentation'!E37=\"NOK\",'1. Documentation'!B37=\"J\"),1,0)","v":0}]
["3.5",{"$f":"'3. Control syst. + command'!J6","v":"NOK"},{"$f":"IF('3. Control syst. + command'!J6=\"NOK\",'3. Control syst. + command'!I6,\"none\")","v":0},null,null,null,{"$f":"IF('Overview of measures'!$B52=\"OK\",1,IF('Overview of measures'!$B52=\"NR\",1,0))","v":0},null,null,1,0,{"$f":"IF(AND('1. Documentation'!E38=\"NOK\",'1. Documentation'!B38=\"J\"),1,0)","v":0}]
["3.6",{"$f":"'3. Control syst. + command'!J7","v":"OK"},{"$f":"IF('3. Control syst. + command'!J7=\"NOK\",'3. Control syst. + command'!I7,\"none\")","v":"none"},null,null,null,{"$f":"IF('Overview of measures'!$B53=\"OK\",1,IF('Overview of measures'!$B53=\"NR\",1,0))","v":1},null,null,0,0,{"$f":"IF(AND('1. Documentation'!E39=\"NOK\",'1. Documentation'!B39=\"J\"),1,0)","v":0}]
["Command facilities ",null,null,null,null,null,null,null,null,0,0,{"$f":"IF(AND('1. Documentation'!E40=\"NOK\",'1. Documentation'!B40=\"J\"),1,0)","v":0}]
["3.7",{"$f":"'3. Control syst. + command'!J9","v":"NOK"},{"$f":"IF('3. Control syst. + command'!J9=\"NOK\",'3. Control syst. + command'!I9,\"none\")","v":0},null,null,null,{"$f":"IF('Overview of measures'!$B55=\"OK\",1,IF('Overview of measures'!$B55=\"NR\",1,0))","v":0},null,null,1,0,{"$f":"IF(AND('1. Documentation'!E41=\"NOK\",'1. Documentation'!B41=\"J\"),1,0)","v":0}]
["3.8",{"$f":"'3. Control syst. + command'!J10","v":"OK"},{"$f":"IF('3. Control syst. + command'!J10=\"NOK\",'3. Control syst. + command'!I10,\"none\")","v":"none"},null,null,null,{"$f":"IF('Overview of measures'!$B56=\"OK\",1,IF('Overview of measures'!$B56=\"NR\",1,0))","v":1},null,null,0,0,{"$f":"IF(AND('1. Documentation'!E42=\"NOK\",'1. Documentation'!B42=\"J\"),1,0)","v":0}]
["3.9",{"$f":"'3. Control syst. + command'!J11","v":"NOK"},{"$f":"IF('3. Control syst. + command'!J11=\"NOK\",'3. Control syst. + command'!I11,\"none\")","v":0},null,null,null,{"$f":"IF('Overview of measures'!$B57=\"OK\",1,IF('Overview of measures'!$B57=\"NR\",1,0))","v":0},null,null,1,0,{"$f":"IF(AND('1. Documentation'!E43=\"NOK\",'1. Documentation'!B43=\"J\"),1,0)","v":0}]
["3.10",{"$f":"'3. Control syst. + command'!J12","v":"OK"},{"$f":"IF('3. Control syst. + command'!J12=\"NOK\",'3. Control syst. + command'!I12,\"none\")","v":"none"},null,null,null,{"$f":"IF('Overview of measures'!$B58=\"OK\",1,IF('Overview of measures'!$B58=\"NR\",1,0))","v":1},null,null,0,0,{"$f":"IF(AND('1. Documentation'!E44=\"NOK\",'1. Documentation'!B44=\"J\"),1,0)","v":0}]
["3.11",{"$f":"'3. Control syst. + command'!J13","v":"NOK"},{"$f":"IF('3. Control syst. + command'!J13=\"NOK\",'3. Control syst. + command'!I13,\"none\")","v":0},null,null,null,{"$f":"IF('Overview of measures'!$B59=\"OK\",1,IF('Overview of measures'!$B59=\"NR\",1,0))","v":0},null,null,1,0,{"$f":"IF(AND('1. Documentation'!E45=\"NOK\",'1. Documentation'!B45=\"J\"),1,0)","v":0}]
["3.12",{"$f":"'3. Control syst. + command'!J14","v":"OK"},{"$f":"IF('3. Control syst. + command'!J14=\"NOK\",'3. Control syst. + command'!I14,\"none\")","v":"none"},null,null,null,{"$f":"IF('Overview of measures'!$B60=\"OK\",1,IF('Overview of measures'!$B60=\"NR\",1,0))","v":1},null,null,0,0,{"$f":"IF(AND('1. Documentation'!E46=\"NOK\",'1. Documentation'!B46=\"J\"),1,0)","v":0}]
["3.13",{"$f":"'3. Control syst. + command'!J15","v":"NOK"},{"$f":"IF('3. Control syst. + command'!J15=\"NOK\",'3. Control syst. + command'!I15,\"none\")","v":0},null,null,null,{"$f":"IF('Overview of measures'!$B61=\"OK\",1,IF('Overview of measures'!$B61=\"NR\",1,0))","v":0},null,null,1,0,{"$f":"IF(AND('1. Documentation'!E47=\"NOK\",'1. Documentation'!B47=\"J\"),1,0)","v":0}]
["3.14",{"$f":"'3. Control syst. + command'!J16","v":"OK"},{"$f":"IF('3. Control syst. + command'!J16=\"NOK\",'3. Control syst. + command'!I16,\"none\")","v":"none"},null,null,null,{"$f":"IF('Overview of measures'!$B62=\"OK\",1,IF('Overview of measures'!$B62=\"NR\",1,0))","v":1},null,null,0,0,{"$f":"IF(AND('1. Documentation'!E48=\"NOK\",'1. Documentation'!B48=\"J\"),1,0)","v":0}]
["3.15",{"$f":"'3. Control syst. + command'!J17","v":"NOK"},{"$f":"IF('3. Control syst. + command'!J17=\"NOK\",'3. Control syst. + command'!I17,\"none\")","v":0},null,null,null,{"$f":"IF('Overview of measures'!$B63=\"OK\",1,IF('Overview of measures'!$B63=\"NR\",1,0))","v":0},null,null,1,0,{"$f":"IF(AND('1. Documentation'!E49=\"NOK\",'1. Documentation'!B49=\"J\"),1,0)","v":0}]
["3.16",{"$f":"'3. Control syst. + command'!J18","v":"OK"},{"$f":"IF('3. Control syst. + command'!J18=\"NOK\",'3. Control syst. + command'!I18,\"none\")","v":"none"},null,null,null,{"$f":"IF('Overview of measures'!$B64=\"OK\",1,IF('Overview of measures'!$B64=\"NR\",1,0))","v":1},null,null,0,0,{"$f":"IF(AND('1. Documentation'!E50=\"NOK\",'1. Documentation'!B50=\"J\"),1,0)","v":0}]
["Start-up (power-up, switch-on, etc.) ",null,null,null,null,null,null,null,null,0,0,{"$f":"IF(AND('1. Documentation'!E51=\"NOK\",'1. Documentation'!B51=\"J\"),1,0)","v":0}]
["3.17",{"$f":"'3. Control syst. + command'!J20","v":"NOK"},{"$f":"IF('3. Control syst. + command'!J20=\"NOK\",'3. Control syst. + command'!I20,\"none\")","v":0},null,null,null,{"$f":"IF('Overview of measures'!$B66=\"OK\",1,IF('Overview of measures'!$B66=\"NR\",1,0))","v":0},null,null,1,0,{"$f":"IF(AND('1. Documentation'!E52=\"NOK\",'1. Documentation'!B52=\"J\"),1,0)","v":0}]
["3.18",{"$f":"'3. Control syst. + command'!J21","v":"OK"},{"$f":"IF('3. Control syst. + command'!J21=\"NOK\",'3. Control syst. + command'!I21,\"none\")","v":"none"},null,null,null,{"$f":"IF('Overview of measures'!$B67=\"OK\",1,IF('Overview of measures'!$B67=\"NR\",1,0))","v":1},null,null,0,0,{"$f":"IF(AND('1. Documentation'!E53=\"NOK\",'1. Documentation'!B53=\"J\"),1,0)","v":0}]
["Shutdown (power-down, switch-off) ",null,null,null,null,null,null,null,null,0,0,{"$f":"IF(AND('1. Documentation'!E54=\"NOK\",'1. Documentation'!B54=\"J\"),1,0)","v":0}]
["3.19",{"$f":"'3. Control syst. + command'!J23","v":"NOK"},{"$f":"IF('3. Control syst. + command'!J23=\"NOK\",'3. Control syst. + command'!I23,\"none\")","v":0},null,null,null,{"$f":"IF('Overview of measures'!$B69=\"OK\",1,IF('Overview of measures'!$B69=\"NR\",1,0))","v":0},null,null,1,0,{"$f":"IF(AND('1. Documentation'!E55=\"NOK\",'1. Documentation'!B55=\"J\"),1,0)","v":0}]
["3.20",{"$f":"'3. Control syst. + command'!J24","v":"OK"},{"$f":"IF('3. Control syst. + command'!J24=\"NOK\",'3. Control syst. + command'!I24,\"none\")","v":"none"},null,null,null,{"$f":"IF('Overview of measures'!$B70=\"OK\",1,IF('Overview of measures'!$B70=\"NR\",1,0))","v":1},null,null,0,0,{"$f":"IF(AND('1. Documentation'!E56=\"NOK\",'1. Documentation'!B56=\"J\"),1,0)","v":0}]
["3.21",{"$f":"'3. Control syst. + command'!J25","v":"NOK"},{"$f":"IF('3. Control syst. + command'!J25=\"NOK\",'3. Control syst. + command'!I25,\"none\")","v":0},null,null,null,{"$f":"IF('Overview of measures'!$B71=\"OK\",1,IF('Overview of measures'!$B71=\"NR\",1,0))","v":0},null,null,1,0,{"$f":"IF(AND('1. Documentation'!E57=\"NOK\",'1. Documentation'!B57=\"J\"),1,0)","v":0}]
["3.22",{"$f":"'3. Control syst. + command'!J26","v":"OK"},{"$f":"IF('3. Control syst. + command'!J26=\"NOK\",'3. Control syst. + command'!I26,\"none\")","v":"none"},null,null,null,{"$f":"IF('Overview of measures'!$B72=\"OK\",1,IF('Overview of measures'!$B72=\"NR\",1,0))","v":1},null,null,0,0,{"$f":"IF(AND('1. Documentation'!E58=\"NOK\",'1. Documentation'!B58=\"J\"),1,0)","v":0}]
["3.23",{"$f":"'3. Control syst. + command'!J27","v":"NOK"},{"$f":"IF('3. Control syst. + command'!J27=\"NOK\",'3. Control syst. + command'!I27,\"none\")","v":0},null,null,null,{"$f":"IF('Overview of measures'!$B73=\"OK\",1,IF('Overview of measures'!$B73=\"NR\",1,0))","v":0},null,null,1,0,{"$f":"IF(AND('1. Documentation'!E59=\"NOK\",'1. Documentation'!B59=\"J\"),1,0)","v":0}]
["3.24",{"$f":"'3. Control syst. + command'!J28","v":"OK"},{"$f":"IF('3. Control syst. + command'!J28=\"NOK\",'3. Control syst. + command'!I28,\"none\")","v":"none"},null,null,null,{"$f":"IF('Overview of measures'!$B74=\"OK\",1,IF('Overview of measures'!$B74=\"NR\",1,0))","v":1},null,null,0,0,{"$f":"IF(AND('1. Documentation'!E60=\"NOK\",'1. Documentation'!B60=\"J\"),1,0)","v":0}]
["3.25",{"$f":"'3. Control syst. + command'!J29","v":"NOK"},{"$f":"IF('3. Control syst. + command'!J29=\"NOK\",'3. Control syst. + command'!I29,\"none\")","v":0},null,null,null,{"$f":"IF('Overview of measures'!$B75=\"OK\",1,IF('Overview of measures'!$B75=\"NR\",1,0))","v":0},null,null,1,0,{"$f":"IF(AND('1. Documentation'!E61=\"NOK\",'1. Documentation'!B61=\"J\"),1,0)","v":0}]
["3.26",{"$f":"'3. Control syst. + command'!J30","v":"OK"},{"$f":"IF('3. Control syst. + command'!J30=\"NOK\",'3. Control syst. + command'!I30,\"none\")","v":"none"},null,null,null,{"$f":"IF('Overview of measures'!$B76=\"OK\",1,IF('Overview of measures'!$B76=\"NR\",1,0))","v":1},null,null,0,0,{"$f":"IF(AND('1. Documentation'!E62=\"NOK\",'1. Documentation'!B62=\"J\"),1,0)","v":0}]
["3.27",{"$f":"'3. Control syst. + command'!J31","v":"NOK"},{"$f":"IF('3. Control syst. + command'!J31=\"NOK\",'3. Control syst. + command'!I31,\"none\")","v":0},null,null,null,{"$f":"IF('Overview of measures'!$B77=\"OK\",1,IF('Overview of measures'!$B77=\"NR\",1,0))","v":0},null,null,1,0,{"$f":"IF(AND('1. Documentation'!E63=\"NOK\",'1. Documentation'!B63=\"J\"),1,0)","v":0}]
["Emergency stop devices ",null,null,null,null,null,null,null,null,0,0,{"$f":"IF(AND('1. Documentation'!E64=\"NOK\",'1. Documentation'!B64=\"J\"),1,0)","v":0}]
["3.28",{"$f":"'3. Control syst. + command'!J33","v":"OK"},{"$f":"IF('3. Control syst. + command'!J33=\"NOK\",'3. Control syst. + command'!I33,\"none\")","v":"none"},null,null,null,{"$f":"IF('Overview of measures'!$B79=\"OK\",1,IF('Overview of measures'!$B79=\"NR\",1,0))","v":1},null,null,0,0,{"$f":"IF(AND('1. Documentation'!E65=\"NOK\",'1. Documentation'!B65=\"J\"),1,0)","v":0}]
["3.29",{"$f":"'3. Control syst. + command'!J34","v":"NOK"},{"$f":"IF('3. Control syst. + command'!J34=\"NOK\",'3. Control syst. + command'!I34,\"none\")","v":0},null,null,null,{"$f":"IF('Overview of measures'!$B80=\"OK\",1,IF('Overview of measures'!$B80=\"NR\",1,0))","v":0},null,null,1,0,{"$f":"IF(AND('1. Documentation'!E66=\"NOK\",'1. Documentation'!B66=\"J\"),1,0)","v":0}]
["3.30",{"$f":"'3. Control syst. + command'!J35","v":"OK"},{"$f":"IF('3. Control syst. + command'!J35=\"NOK\",'3. Control syst. + command'!I35,\"none\")","v":"none"},null,null,null,{"$f":"IF('Overview of measures'!$B81=\"OK\",1,IF('Overview of measures'!$B81=\"NR\",1,0))","v":1},null,null,0,0,{"$f":"IF(AND('1. Documentation'!E67=\"NOK\",'1. Documentation'!B67=\"J\"),1,0)","v":0}]
["3.31",{"$f":"'3. Control syst. + command'!J36","v":"NOK"},{"$f":"IF('3. Control syst. + command'!J36=\"NOK\",'3. Control syst. + command'!I36,\"none\")","v":0},null,null,null,{"$f":"IF('Overview of measures'!$B82=\"OK\",1,IF('Overview of measures'!$B82=\"NR\",1,0))","v":0},null,null,{"$f":"IF(B82=\"NOK\",1,0)","v":1},{"$f":"IF(J82=FALSE,1,0)","v":0},{"$f":"IF(AND('1. Documentation'!E68=\"NOK\",'1. Documentation'!B68=\"J\"),1,0)","v":0}]
["3.32",{"$f":"'3. Control syst. + command'!J37","v":"OK"},{"$f":"IF('3. Control syst. + command'!J37=\"NOK\",'3. Control syst. + command'!I37,\"none\")","v":"none"},null,null,null,{"$f":"IF('Overview of measures'!$B83=\"OK\",1,IF('Overview of measures'!$B83=\"NR\",1,0))","v":1},null,null,0,0,{"$f":"IF(AND('1. Documentation'!E69=\"NOK\",'1. Documentation'!B69=\"J\"),1,0)","v":0}]
["3.33",{"$f":"'3. Control syst. + command'!J38","v":"NOK"},{"$f":"IF('3. Control syst. + command'!J38=\"NOK\",'3. Control syst. + command'!I38,\"none\")","v":0},null,null,null,{"$f":"IF('Overview of measures'!$B84=\"OK\",1,IF('Overview of measures'!$B84=\"NR\",1,0))","v":0},null,null,1,0,{"$f":"IF(AND('1. Documentation'!E70=\"NOK\",'1. Documentation'!B70=\"J\"),1,0)","v":0}]
["3.34",{"$f":"'3. Control syst. + command'!J39","v":"OK"},{"$f":"IF('3. Control syst. + command'!J39=\"NOK\",'3. Control syst. + command'!I39,\"none\")","v":"none"},null,null,null,{"$f":"IF('Overview of measures'!$B85=\"OK\",1,IF('Overview of measures'!$B85=\"NR\",1,0))","v":1},null,null,0,0,{"$f":"IF(AND('1. Documentation'!E72=\"NOK\",'1. Documentation'!B72=\"J\"),1,0)","v":0}]
["3.35",{"$f":"'3. Control syst. + command'!J40","v":"NOK"},{"$f":"IF('3. Control syst. + command'!J40=\"NOK\",'3. Control syst. + command'!I40,\"none\")","v":0},null,null,null,{"$f":"IF('Overview of measures'!$B86=\"OK\",1,IF('Overview of measures'!$B86=\"NR\",1,0))","v":0},null,null,1,0,{"$f":"IF(AND('1. Documentation'!E73=\"NOK\",'1. Documentation'!B73=\"J\"),1,0)","v":0}]
["Coordinated machines (Production lines)"]
["Command facilities coordinated machine"]
["3.36",{"$f":"'3. Control syst. + command'!J43","v":"OK"},{"$f":"IF('3. Control syst. + command'!J43=\"NOK\",'3. Control syst. + command'!I43,\"none\")","v":"none"},null,null,null,{"$f":"IF('Overview of measures'!$B89=\"OK\",1,IF('Overview of measures'!$B89=\"NR\",1,0))","v":1}]
["3.37",{"$f":"'3. Control syst. + command'!J44","v":"NOK"},{"$f":"IF('3. Control syst. + command'!J44=\"NOK\",'3. Control syst. + command'!I44,\"none\")","v":0},null,null,null,{"$f":"IF('Overview of measures'!$B90=\"OK\",1,IF('Overview of measures'!$B90=\"NR\",1,0))","v":0}]
["3.38",{"$f":"'3. Control syst. + command'!J45","v":"OK"},{"$f":"IF('3. Control syst. + command'!J45=\"NOK\",'3. Control syst. + command'!I45,\"none\")","v":"none"},null,null,null,{"$f":"IF('Overview of measures'!$B91=\"OK\",1,IF('Overview of measures'!$B91=\"NR\",1,0))","v":1}]
["3.39",{"$f":"'3. Control syst. + command'!J46","v":"OK"},{"$f":"IF('3. Control syst. + command'!J46=\"NOK\",'3. Control syst. + command'!I46,\"none\")","v":"none"},null,null,null,{"$f":"IF('Overview of measures'!$B92=\"OK\",1,IF('Overview of measures'!$B92=\"NR\",1,0))","v":1}]
["Start-up of the coordinated line"]
["3.40",{"$f":"'3. Control syst. + command'!J48","v":"NOK"},{"$f":"IF('3. Control syst. + command'!J48=\"NOK\",'3. Control syst. + command'!I48,\"none\")","v":0},null,null,null,{"$f":"IF('Overview of measures'!$B94=\"OK\",1,IF('Overview of measures'!$B94=\"NR\",1,0))","v":0}]
["3.41",{"$f":"'3. Control syst. + command'!J49","v":"NOK"},{"$f":"IF('3. Control syst. + command'!J49=\"NOK\",'3. Control syst. + command'!I49,\"none\")","v":0},null,null,null,{"$f":"IF('Overview of measures'!$B95=\"OK\",1,IF('Overview of measures'!$B95=\"NR\",1,0))","v":0}]
["3.42",{"$f":"'3. Control syst. + command'!J50","v":"OK"},{"$f":"IF('3. Control syst. + command'!J50=\"NOK\",'3. Control syst. + command'!I50,\"none\")","v":"none"},null,null,null,{"$f":"IF('Overview of measures'!$B96=\"OK\",1,IF('Overview of measures'!$B96=\"NR\",1,0))","v":1}]
["3.43",{"$f":"'3. Control syst. + command'!J51","v":"NOK"},{"$f":"IF('3. Control syst. + command'!J51=\"NOK\",'3. Control syst. + command'!I51,\"none\")","v":0},null,null,null,{"$f":"IF('Overview of measures'!$B97=\"OK\",1,IF('Overview of measures'!$B97=\"NR\",1,0))","v":0}]
["3.44",{"$f":"'3. Control syst. + command'!J52","v":"NOK"},{"$f":"IF('3. Control syst. + command'!J52=\"NOK\",'3. Control syst. + command'!I52,\"none\")","v":0},null,null,null,{"$f":"IF('Overview of measures'!$B98=\"OK\",1,IF('Overview of measures'!$B98=\"NR\",1,0))","v":0}]
["Shutdown of the coordinated machine"]
["3.45",{"$f":"'3. Control syst. + command'!J54","v":"OK"},{"$f":"IF('3. Control syst. + command'!J54=\"NOK\",'3. Control syst. + command'!I54,\"none\")","v":"none"},null,null,null,{"$f":"IF('Overview of measures'!$B100=\"OK\",1,IF('Overview of measures'!$B100=\"NR\",1,0))","v":1}]
["3.46",{"$f":"'3. Control syst. + command'!J55","v":"OK"},{"$f":"IF('3. Control syst. + command'!J55=\"NOK\",'3. Control syst. + command'!I55,\"none\")","v":"none"},null,null,null,{"$f":"IF('Overview of measures'!$B101=\"OK\",1,IF('Overview of measures'!$B101=\"NR\",1,0))","v":1}]
["3.47",{"$f":"'3. Control syst. + command'!J56","v":"OK"},{"$f":"IF('3. Control syst. + command'!J56=\"NOK\",'3. Control syst. + command'!I56,\"none\")","v":"none"},null,null,null,{"$f":"IF('Overview of measures'!$B102=\"OK\",1,IF('Overview of measures'!$B102=\"NR\",1,0))","v":1}]
["3.48",{"$f":"'3. Control syst. + command'!J57","v":"NOK"},{"$f":"IF('3. Control syst. + command'!J57=\"NOK\",'3. Control syst. + command'!I57,\"none\")","v":0},null,null,null,{"$f":"IF('Overview of measures'!$B103=\"OK\",1,IF('Overview of measures'!$B103=\"NR\",1,0))","v":0}]
["3.49",{"$f":"'3. Control syst. + command'!J58","v":"NOK"},{"$f":"IF('3. Control syst. + command'!J58=\"NOK\",'3. Control syst. + command'!I58,\"none\")","v":0},null,null,null,{"$f":"IF('Overview of measures'!$B104=\"OK\",1,IF('Overview of measures'!$B104=\"NR\",1,0))","v":0}]
["Emergency Stop devices of the coordinated machine"]
["3.50",{"$f":"'3. Control syst. + command'!J60","v":"NOK"},{"$f":"IF('3. Control syst. + command'!J60=\"NOK\",'3. Control syst. + command'!I60,\"none\")","v":0},null,null,null,{"$f":"IF('Overview of measures'!$B106=\"OK\",1,IF('Overview of measures'!$B106=\"NR\",1,0))","v":0}]
["3.51",{"$f":"'3. Control syst. + command'!J61","v":"NOK"},{"$f":"IF('3. Control syst. + command'!J61=\"NOK\",'3. Control syst. + command'!I61,\"none\")","v":0},null,null,null,{"$f":"IF('Overview of measures'!$B107=\"OK\",1,IF('Overview of measures'!$B107=\"NR\",1,0))","v":0}]
["3.52",{"$f":"'3. Control syst. + command'!J62","v":"OK"},{"$f":"IF('3. Control syst. + command'!J62=\"NOK\",'3. Control syst. + command'!I62,\"none\")","v":"none"},null,null,null,{"$f":"IF('Overview of measures'!$B108=\"OK\",1,IF('Overview of measures'!$B108=\"NR\",1,0))","v":1}]
["Warningsignals and warning signs"]
["3.53",{"$f":"'3. Control syst. + command'!J64","v":"OK"},{"$f":"IF('3. Control syst. + command'!J64=\"NOK\",'3. Control syst. + command'!I64,\"none\")","v":"none"},null,null,null,{"$f":"IF('Overview of measures'!$B110=\"OK\",1,IF('Overview of measures'!$B110=\"NR\",1,0))","v":1}]
["3.54",{"$f":"'3. Control syst. + command'!J65","v":"NOK"},{"$f":"IF('3. Control syst. + command'!J65=\"NOK\",'3. Control syst. + command'!I65,\"none\")","v":0}]
[null,{"$f":"COUNTIFS(B48:B86,\"blank\")","v":0},null,null,null,null,{"$f":"SUBTOTAL(101,'Overview of measures'!$G$48:$G$111)","v":0.49056603773584906},null,null,0,0,{"$f":"IF(AND('1. Documentation'!E74=\"NOK\",'1. Documentation'!B74=\"J\"),1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,0,0,{"$f":"IF(AND('1. Documentation'!E75=\"NOK\",'1. Documentation'!B75=\"J\"),1,0)","v":0}]
["4. Mechanical hazards ",null,null,{"$f":"IF(B158>0,\"answered incompletely\",\"answer completely\")","v":"answer completely"},null,null,{"$f":"AVERAGE('Overview of measures'!$G$116:$G$157)","v":0.7142857142857143},null,null,1,0,{"$f":"IF(AND('1. Documentation'!E76=\"NOK\",'1. Documentation'!B76=\"J\"),1,0)","v":0}]
["Question No.","Assessment","Measures","Who","Date","Effectiveness check","% closed",null,null,0,0,{"$f":"IF(AND('1. Documentation'!E77=\"NOK\",'1. Documentation'!B77=\"J\"),1,0)","v":0}]
["4.1",{"$f":"'4. Protection against mech. haz'!J2","v":"NOK"},{"$f":"IF('4. Protection against mech. haz'!J2=\"NOK\",'4. Protection against mech. haz'!I2,\"none\")","v":0},null,null,null,{"$f":"IF(B116=\"OK\",1,IF(B116=\"NR\",1,0))","v":0},null,null,1,0,{"$f":"IF(AND('1. Documentation'!E78=\"NOK\",'1. Documentation'!B78=\"J\"),1,0)","v":0}]
["4.2",{"$f":"'4. Protection against mech. haz'!J3","v":"NOK"},{"$f":"IF('4. Protection against mech. haz'!J3=\"NOK\",'4. Protection against mech. haz'!I3,\"none\")","v":0},null,null,null,{"$f":"IF(B117=\"OK\",1,IF(B117=\"NR\",1,0))","v":0},null,null,1,0,{"$f":"IF(AND('1. Documentation'!E79=\"NOK\",'1. Documentation'!B79=\"J\"),1,0)","v":0}]
["4.3",{"$f":"'4. Protection against mech. haz'!J4","v":"OK"},{"$f":"IF('4. Protection against mech. haz'!J4=\"NOK\",'4. Protection against mech. haz'!I4,\"none\")","v":"none"},null,null,null,{"$f":"IF(B118=\"OK\",1,IF(B118=\"NR\",1,0))","v":1},null,null,0,0,{"$f":"IF(AND('1. Documentation'!E80=\"NOK\",'1. Documentation'!B80=\"J\"),1,0)","v":0}]
["4.4",{"$f":"'4. Protection against mech. haz'!J5","v":"NOK"},{"$f":"IF('4. Protection against mech. haz'!J5=\"NOK\",'4. Protection against mech. haz'!I5,\"none\")","v":0},null,null,null,{"$f":"IF(B119=\"OK\",1,IF(B119=\"NR\",1,0))","v":0},null,null,1,0,{"$f":"IF(AND('1. Documentation'!E81=\"NOK\",'1. Documentation'!B81=\"J\"),1,0)","v":0}]
["4.5",{"$f":"'4. Protection against mech. haz'!J6","v":"OK"},{"$f":"IF('4. Protection against mech. haz'!J6=\"NOK\",'4. Protection against mech. haz'!I6,\"none\")","v":"none"},null,null,null,{"$f":"IF(B120=\"OK\",1,IF(B120=\"NR\",1,0))","v":1},null,null,0,0,{"$f":"IF(AND('1. Documentation'!E82=\"NOK\",'1. Documentation'!B82=\"J\"),1,0)","v":0}]
["Risks arising from moving parts ",null,null,null,null,null,null,null,null,0,0,{"$f":"IF(AND('1. Documentation'!E83=\"NOK\",'1. Documentation'!B83=\"J\"),1,0)","v":0}]
["4.6",{"$f":"'4. Protection against mech. haz'!J8","v":"OK"},{"$f":"IF('4. Protection against mech. haz'!J8=\"NOK\",'4. Protection against mech. haz'!I8,\"none\")","v":"none"},null,null,null,{"$f":"IF(B122=\"OK\",1,IF(B122=\"NR\",1,0))","v":1},null,null,0,0,{"$f":"IF(AND('1. Documentation'!E84=\"NOK\",'1. Documentation'!B84=\"J\"),1,0)","v":0}]
["4.7",{"$f":"'4. Protection against mech. haz'!J9","v":"NOK"},{"$f":"IF('4. Protection against mech. haz'!J9=\"NOK\",'4. Protection against mech. haz'!I9,\"none\")","v":0},null,null,null,0,null,null,1,0,{"$f":"IF(AND('1. Documentation'!E85=\"NOK\",'1. Documentation'!B85=\"J\"),1,0)","v":0}]
["4.8",{"$f":"'4. Protection against mech. haz'!J10","v":"OK"},{"$f":"IF('4. Protection against mech. haz'!J10=\"NOK\",'4. Protection against mech. haz'!I10,\"none\")","v":"none"},null,null,null,1,null,null,0,0,{"$f":"IF(AND('1. Documentation'!E86=\"NOK\",'1. Documentation'!B86=\"J\"),1,0)","v":0}]
["4.9",{"$f":"'4. Protection against mech. haz'!J11","v":"OK"},{"$f":"IF('4. Protection against mech. haz'!J11=\"NOK\",'4. Protection against mech. haz'!I11,\"none\")","v":"none"},null,null,null,1,null,null,0,0,{"$f":"IF(AND('1. Documentation'!E87=\"NOK\",'1. Documentation'!B87=\"J\"),1,0)","v":0}]
["4.10",{"$f":"'4. Protection against mech. haz'!J12","v":"OK"},{"$f":"IF('4. Protection against mech. haz'!J12=\"NOK\",'4. Protection against mech. haz'!I12,\"none\")","v":"none"},null,null,null,1,null,null,0,0,{"$f":"IF(AND('1. Documentation'!E88=\"NOK\",'1. Documentation'!B88=\"J\"),1,0)","v":0}]
["4.11",{"$f":"'4. Protection against mech. haz'!J13","v":"OK"},{"$f":"IF('4. Protection against mech. haz'!J13=\"NOK\",'4. Protection against mech. haz'!I13,\"none\")","v":"none"},null,null,null,1,null,null,0,0,{"$f":"IF(AND('1. Documentation'!E89=\"NOK\",'1. Documentation'!B89=\"J\"),1,0)","v":0}]
["4.12",{"$f":"'4. Protection against mech. haz'!J14","v":"OK"},{"$f":"IF('4. Protection against mech. haz'!J14=\"NOK\",'4. Protection against mech. haz'!I14,\"none\")","v":"none"},null,null,null,1,null,null,0,0,{"$f":"IF(AND('1. Documentation'!E90=\"NOK\",'1. Documentation'!B90=\"J\"),1,0)","v":0}]
["4.13",{"$f":"'4. Protection against mech. haz'!J15","v":"OK"},{"$f":"IF('4. Protection against mech. haz'!J15=\"NOK\",'4. Protection against mech. haz'!I15,\"none\")","v":"none"},null,null,null,1,null,null,0,0,{"$f":"IF(AND('1. Documentation'!E91=\"NOK\",'1. Documentation'!B91=\"J\"),1,0)","v":0}]
["Fixed guards and safety devices ",null,null,null,null,null,null,null,null,0,0,{"$f":"IF(AND('1. Documentation'!E92=\"NOK\",'1. Documentation'!B92=\"J\"),1,0)","v":0}]
["4.14",{"$f":"'4. Protection against mech. haz'!J17","v":"NOK"},{"$f":"IF('4. Protection against mech. haz'!J17=\"NOK\",'4. Protection against mech. haz'!I17,\"none\")","v":0},null,null,null,{"$f":"IF(B131=\"OK\",1,IF(B131=\"NR\",1,0))","v":0},null,null,1,0,{"$f":"IF(AND('1. Documentation'!E93=\"NOK\",'1. Documentation'!B93=\"J\"),1,0)","v":0}]
["4.15",{"$f":"'4. Protection against mech. haz'!J18","v":"OK"},{"$f":"IF('4. Protection against mech. haz'!J18=\"NOK\",'4. Protection against mech. haz'!I18,\"none\")","v":"none"},null,null,null,{"$f":"IF(B132=\"OK\",1,IF(B132=\"NR\",1,0))","v":1},null,null,0,0,{"$f":"IF(AND('1. Documentation'!E94=\"NOK\",'1. Documentation'!B94=\"J\"),1,0)","v":0}]
["4.16",{"$f":"'4. Protection against mech. haz'!J19","v":"NOK"},{"$f":"IF('4. Protection against mech. haz'!J19=\"NOK\",'4. Protection against mech. haz'!I19,\"none\")","v":0},null,null,null,{"$f":"IF(B133=\"OK\",1,IF(B133=\"NR\",1,0))","v":0},null,null,1,0,{"$f":"IF(AND('1. Documentation'!E95=\"NOK\",'1. Documentation'!B95=\"J\"),1,0)","v":0}]
["Moving guards and safety devices ",null,null,null,null,null,null,null,null,0,0,{"$f":"IF(AND('1. Documentation'!E96=\"NOK\",'1. Documentation'!B96=\"J\"),1,0)","v":0}]
["4.17",{"$f":"'4. Protection against mech. haz'!J21","v":"OK"},{"$f":"IF('4. Protection against mech. haz'!J21=\"NOK\",'4. Protection against mech. haz'!I21,\"none\")","v":"none"},null,null,null,{"$f":"IF(B135=\"OK\",1,IF(B135=\"NR\",1,0))","v":1},null,null,0,0,{"$f":"IF(AND('1. Documentation'!E97=\"NOK\",'1. Documentation'!B97=\"J\"),1,0)","v":0}]
["4.18",{"$f":"'4. Protection against mech. haz'!J22","v":"OK"},{"$f":"IF('4. Protection against mech. haz'!J22=\"NOK\",'4. Protection against mech. haz'!I22,\"none\")","v":"none"},null,null,null,{"$f":"IF(B136=\"OK\",1,IF(B136=\"NR\",1,0))","v":1},null,null,0,0,{"$f":"IF(AND('1. Documentation'!E98=\"NOK\",'1. Documentation'!B98=\"J\"),1,0)","v":0}]
["4.19",{"$f":"'4. Protection against mech. haz'!J23","v":"OK"},{"$f":"IF('4. Protection against mech. haz'!J23=\"NOK\",'4. Protection against mech. haz'!I23,\"none\")","v":"none"},null,null,null,{"$f":"IF(B137=\"OK\",1,IF(B137=\"NR\",1,0))","v":1},null,null,0,0,{"$f":"IF(AND('1. Documentation'!E99=\"NOK\",'1. Documentation'!B99=\"J\"),1,0)","v":0}]
["4.20",{"$f":"'4. Protection against mech. haz'!J24","v":"OK"},{"$f":"IF('4. Protection against mech. haz'!J24=\"NOK\",'4. Protection against mech. haz'!I24,\"none\")","v":"none"},null,null,null,{"$f":"IF(B138=\"OK\",1,IF(B138=\"NR\",1,0))","v":1},null,null,0,0,{"$f":"IF(AND('1. Documentation'!E100=\"NOK\",'1. Documentation'!B100=\"J\"),1,0)","v":0}]
["Protective devices (e.g. light curtains, laser scanners, two-hand triggering facilities, pressure-sensitive mats).",null,null,null,null,null,null,null,null,0,0,{"$f":"IF(AND('1. Documentation'!E101=\"NOK\",'1. Documentation'!B101=\"J\"),1,0)","v":0}]
["4.21",{"$f":"'4. Protection against mech. haz'!J26","v":"NOK"},{"$f":"IF('4. Protection against mech. haz'!J26=\"NOK\",'4. Protection against mech. haz'!I26,\"none\")","v":0},null,null,null,{"$f":"IF(B140=\"OK\",1,IF(B140=\"NR\",1,0))","v":0},null,null,1,0,{"$f":"IF(AND('1. Documentation'!E102=\"NOK\",'1. Documentation'!B102=\"J\"),1,0)","v":0}]
["4.22",{"$f":"'4. Protection against mech. haz'!J27","v":"OK"},{"$f":"IF('4. Protection against mech. haz'!J27=\"NOK\",'4. Protection against mech. haz'!I27,\"none\")","v":"none"},null,null,null,1,null,null,0,0,{"$f":"IF(AND('1. Documentation'!E103=\"NOK\",'1. Documentation'!B103=\"J\"),1,0)","v":0}]
["4.23",{"$f":"'4. Protection against mech. haz'!J28","v":"OK"},{"$f":"IF('4. Protection against mech. haz'!J28=\"NOK\",'4. Protection against mech. haz'!I28,\"none\")","v":"none"},null,null,null,1,null,null,0,0,{"$f":"IF(AND('1. Documentation'!E104=\"NOK\",'1. Documentation'!B104=\"J\"),1,0)","v":0}]
["4.24",{"$f":"'4. Protection against mech. haz'!J29","v":"OK"},{"$f":"IF('4. Protection against mech. haz'!J29=\"NOK\",'4. Protection against mech. haz'!I29,\"none\")","v":"none"},null,null,null,1,null,null,0,0,{"$f":"IF(AND('1. Documentation'!E105=\"NOK\",'1. Documentation'!B105=\"J\"),1,0)","v":0}]
["4.25",{"$f":"'4. Protection against mech. haz'!J30","v":"OK"},{"$f":"IF('4. Protection against mech. haz'!J30=\"NOK\",'4. Protection against mech. haz'!I30,\"none\")","v":"none"},null,null,null,1,null,null,0,0,{"$f":"IF(AND('1. Documentation'!E106=\"NOK\",'1. Documentation'!B106=\"J\"),1,0)","v":0}]
["4.26",{"$f":"'4. Protection against mech. haz'!J31","v":"OK"},{"$f":"IF('4. Protection against mech. haz'!J31=\"NOK\",'4. Protection against mech. haz'!I31,\"none\")","v":"none"},null,null,null,1,null,null,0,0,{"$f":"IF(AND('1. Documentation'!E107=\"NOK\",'1. Documentation'!B107=\"J\"),1,0)","v":0}]
["4.27",{"$f":"'4. Protection against mech. haz'!J32","v":"OK"},{"$f":"IF('4. Protection against mech. haz'!J32=\"NOK\",'4. Protection against mech. haz'!I32,\"none\")","v":"none"},null,null,null,1,null,null,0,0,{"$f":"IF(AND('1. Documentation'!E108=\"NOK\",'1. Documentation'!B108=\"J\"),1,0)","v":0}]
["4.28",{"$f":"'4. Protection against mech. haz'!J33","v":"OK"},{"$f":"IF('4. Protection against mech. haz'!J33=\"NOK\",'4. Protection against mech. haz'!I33,\"none\")","v":"none"},null,null,null,1,null,null,0,0,{"$f":"IF(AND('1. Documentation'!E109=\"NOK\",'1. Documentation'!B109=\"J\"),1,0)","v":0}]
["4.29",{"$f":"'4. Protection against mech. haz'!J34","v":"OK"},{"$f":"IF('4. Protection against mech. haz'!J34=\"NOK\",'4. Protection against mech. haz'!I34,\"none\")","v":"none"},null,null,null,1,null,null,0,0,{"$f":"IF(AND('1. Documentation'!E110=\"NOK\",'1. Documentation'!B110=\"J\"),1,0)","v":0}]
["4.30",{"$f":"'4. Protection against mech. haz'!J35","v":"OK"},{"$f":"IF('4. Protection against mech. haz'!J35=\"NOK\",'4. Protection against mech. haz'!I35,\"none\")","v":"none"},null,null,null,1,null,null,0,0,{"$f":"IF(AND('1. Documentation'!E111=\"NOK\",'1. Documentation'!B111=\"J\"),1,0)","v":0}]
["Coordinated machines (Production lines)"]
["Fixed guards and movable guards"]
["4.31",{"$f":"'4. Protection against mech. haz'!J38","v":"NOK"},{"$f":"IF('4. Protection against mech. haz'!J38=\"NOK\",'4. Protection against mech. haz'!I38,\"none\")","v":0},null,null,null,{"$f":"IF(B152=\"OK\",1,IF(B152=\"NR\",1,0))","v":0}]
["4.32",{"$f":"'4. Protection against mech. haz'!J39","v":"OK"},{"$f":"IF('4. Protection against mech. haz'!J39=\"NOK\",'4. Protection against mech. haz'!I39,\"none\")","v":"none"},null,null,null,1]
["4.33",{"$f":"'4. Protection against mech. haz'!J40","v":"NOK"},{"$f":"IF('4. Protection against mech. haz'!J40=\"NOK\",'4. Protection against mech. haz'!I40,\"none\")","v":0},null,null,null,0]
["Breaking, bursting, shattering"]
["4.34",{"$f":"'4. Protection against mech. haz'!J42","v":"NOK"},{"$f":"IF('4. Protection against mech. haz'!J42=\"NOK\",'4. Protection against mech. haz'!I42,\"none\")","v":0},null,null,null,{"$f":"IF(B156=\"OK\",1,IF(B156=\"NR\",1,0))","v":0}]
["4.35",{"$f":"'4. Protection against mech. haz'!J43","v":"OK"},{"$f":"IF('4. Protection against mech. haz'!J43=\"NOK\",'4. Protection against mech. haz'!I43,\"none\")","v":"none"},null,null,null,1]
[null,{"$f":"COUNTIFS(B116:B149,\"blank\")","v":0},null,null,null,null,{"$f":"SUBTOTAL(101,'Overview of measures'!$G$116:$G$157)","v":0.7142857142857143},null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
["5. Other hazards ",null,null,{"$f":"IF(B171>0,\"answered incompletely\",\"answer completely\")","v":"answer completely"},null,null,{"$f":"AVERAGE('Overview of measures'!$G$162:$G$170)","v":0.83333333333333337},null,null,1,0]
["Question No.","Assessment","Measures","Who","Date","Effectiveness check","% closed",null,null,0,0]
["Hazards arising from hot and cold surfaces ",null,null,null,null,null,null,null,null,0,0]
["5.1",{"$f":"'5. Other hazards '!J3","v":"NOK"},{"$f":"IF('5. Other hazards '!J3=\"NOK\",'5. Other hazards '!I3,\"none\")","v":0},null,null,null,{"$f":"IF(B163=\"OK\",1,IF(B163=\"NR\",1,0))","v":0},null,null,1,0,{"$f":"IF(AND('5. Other hazards '!E4=\"NIO\",'5. Other hazards '!B4=\"J\"),1,0)","v":0}]
["5.2",{"$f":"'5. Other hazards '!J4","v":"OK"},{"$f":"IF('5. Other hazards '!J4=\"NOK\",'5. Other hazards '!I4,\"none\")","v":"none"},null,null,null,{"$f":"IF(B164=\"OK\",1,IF(B164=\"NR\",1,0))","v":1},null,null,0,0,{"$f":"IF(AND('5. Other hazards '!E5=\"NIO\",'5. Other hazards '!B5=\"J\"),1,0)","v":0}]
["5.3",{"$f":"'5. Other hazards '!J5","v":"OK"},{"$f":"IF('5. Other hazards '!J5=\"NOK\",'5. Other hazards '!I5,\"none\")","v":"none"},null,null,null,{"$f":"IF(B165=\"OK\",1,IF(B165=\"NR\",1,0))","v":1},null,null,0,0,{"$f":"IF(AND('5. Other hazards '!E6=\"NIO\",'5. Other hazards '!B6=\"J\"),1,0)","v":0}]
["Hazards caused by gas, vapor, mist, liquid and dust",null,null,null,null,null,null,null,null,0,0,{"$f":"IF(AND('5. Other hazards '!E7=\"NIO\",'5. Other hazards '!B7=\"J\"),1,0)","v":0}]
["5.4",{"$f":"'5. Other hazards '!J7","v":"OK"},{"$f":"IF('5. Other hazards '!J7=\"NOK\",'5. Other hazards '!I7,\"none\")","v":"none"},null,null,null,{"$f":"IF(B167=\"OK\",1,IF(B167=\"NR\",1,0))","v":1},null,null,0,0,{"$f":"IF(AND('5. Other hazards '!E8=\"NIO\",'5. Other hazards '!B8=\"J\"),1,0)","v":0}]
["Risk of personnel slipping, tripping or falling\n",null,null,null,null,null,null,null,null,0,0,{"$f":"IF(AND('5. Other hazards '!E9=\"NIO\",'5. Other hazards '!B9=\"J\"),1,0)","v":0}]
["5.5",{"$f":"'5. Other hazards '!J9","v":"OK"},{"$f":"IF('5. Other hazards '!J9=\"NOK\",'5. Other hazards '!I9,\"none\")","v":"none"},null,null,null,{"$f":"IF(B169=\"OK\",1,IF(B169=\"NR\",1,0))","v":1},null,null,0,0,{"$f":"IF(AND('5. Other hazards '!E10=\"NIO\",'5. Other hazards '!B10=\"J\"),1,0)","v":0}]
["5.6",{"$f":"'5. Other hazards '!J10","v":"OK"},{"$f":"IF('5. Other hazards '!J10=\"NOK\",'5. Other hazards '!I10,\"none\")","v":"none"},null,null,null,{"$f":"IF(B170=\"OK\",1,IF(B170=\"NR\",1,0))","v":1},null,null,0,0,{"$f":"IF(AND('6. Setting up Maintanace Serv.'!E13=\"NIO\",'6. Setting up Maintanace Serv.'!B13=\"J\"),1,0)","v":0}]
[null,{"$f":"COUNTIFS(B163:B170,\"blank\")","v":0},null,null,null,null,{"$f":"SUBTOTAL(101,'Overview of measures'!$G$162:$G$170)","v":0.83333333333333337},null,null,0,0,{"$f":"IF(AND('6. Setting up Maintanace Serv.'!E14=\"NIO\",'6. Setting up Maintanace Serv.'!B14=\"J\"),1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,0,0,{"$f":"IF(AND('1. Documentation'!E126=\"NIO\",'1. Documentation'!B126=\"J\"),1,0)","v":0}]
["6. Setting up / Maintenance / Service",null,null,{"$f":"IF(B193>0,\"answered incompletely\",\"answer completely\")","v":"answer completely"},null,null,{"$f":"AVERAGE('Overview of measures'!$G$175:$G$192)","v":1},null,null,1,0,{"$f":"IF(AND('6. Setting up Maintanace Serv.'!E2=\"NIO\",'6. Setting up Maintanace Serv.'!B2=\"J\"),1,0)","v":0}]
["Question No.","Assessment","Measures","Who","Date","Effectiveness check","% closed",null,null,0,0,{"$f":"IF(AND('6. Setting up Maintanace Serv.'!E3=\"NIO\",'6. Setting up Maintanace Serv.'!B3=\"J\"),1,0)","v":0}]
["6.1",{"$f":"'6. Setting up Maintanace Serv.'!J3","v":"OK"},{"$f":"IF('6. Setting up Maintanace Serv.'!J3=\"NOK\",'6. Setting up Maintanace Serv.'!I3,\"none\")","v":"none"},null,null,null,{"$f":"IF(B175=\"OK\",1,IF(B175=\"NR\",1,0))","v":1},null,null,0,0,{"$f":"IF(AND('6. Setting up Maintanace Serv.'!E4=\"NIO\",'6. Setting up Maintanace Serv.'!B4=\"J\"),1,0)","v":0}]
["Maintenance, service, cleaning and debugging work \n",null,null,null,null,null,null,null,null,0,0,{"$f":"IF(AND('6. Setting up Maintanace Serv.'!E5=\"NIO\",'6. Setting up Maintanace Serv.'!B5=\"J\"),1,0)","v":0}]
["6.2",{"$f":"'6. Setting up Maintanace Serv.'!J5","v":"OK"},{"$f":"IF('6. Setting up Maintanace Serv.'!J5=\"NOK\",'6. Setting up Maintanace Serv.'!I5,\"none\")","v":"none"},null,null,null,{"$f":"IF(B177=\"OK\",1,IF(B177=\"NR\",1,0))","v":1},null,null,0,0,{"$f":"IF(AND('6. Setting up Maintanace Serv.'!E6=\"NIO\",'6. Setting up Maintanace Serv.'!B6=\"J\"),1,0)","v":0}]
["6.3",{"$f":"'6. Setting up Maintanace Serv.'!J6","v":"OK"},{"$f":"IF('6. Setting up Maintanace Serv.'!J6=\"NOK\",'6. Setting up Maintanace Serv.'!I6,\"none\")","v":"none"},null,null,null,1,null,null,{"$f":"IF(B178=\"NOK\",1,0)","v":0},{"$f":"IF(J178=FALSE,1,0)","v":0},{"$f":"IF(AND('6. Setting up Maintanace Serv.'!E7=\"NIO\",'6. Setting up Maintanace Serv.'!B7=\"J\"),1,0)","v":0}]
["6.4",{"$f":"'6. Setting up Maintanace Serv.'!J7","v":"OK"},{"$f":"IF('6. Setting up Maintanace Serv.'!J7=\"NOK\",'6. Setting up Maintanace Serv.'!I7,\"none\")","v":"none"},null,null,null,1,null,null,0,0,{"$f":"IF(AND('6. Setting up Maintanace Serv.'!E8=\"NIO\",'6. Setting up Maintanace Serv.'!B8=\"J\"),1,0)","v":0}]
["6.5",{"$f":"'6. Setting up Maintanace Serv.'!J8","v":"OK"},{"$f":"IF('6. Setting up Maintanace Serv.'!J8=\"NOK\",'6. Setting up Maintanace Serv.'!I8,\"none\")","v":"none"},null,null,null,1,null,null,0,0,{"$f":"IF(AND('6. Setting up Maintanace Serv.'!E9=\"NIO\",'6. Setting up Maintanace Serv.'!B9=\"J\"),1,0)","v":0}]
["6.6",{"$f":"'6. Setting up Maintanace Serv.'!J9","v":"OK"},{"$f":"IF('6. Setting up Maintanace Serv.'!J9=\"NOK\",'6. Setting up Maintanace Serv.'!I9,\"none\")","v":"none"},null,null,null,1,null,null,0,0,{"$f":"IF(AND('6. Setting up Maintanace Serv.'!E10=\"NIO\",'6. Setting up Maintanace Serv.'!B10=\"J\"),1,0)","v":0}]
["6.7",{"$f":"'6. Setting up Maintanace Serv.'!J10","v":"OK"},{"$f":"IF('6. Setting up Maintanace Serv.'!J10=\"NOK\",'6. Setting up Maintanace Serv.'!I10,\"none\")","v":"none"},null,null,null,1,null,null,0,0,{"$f":"IF(AND('6. Setting up Maintanace Serv.'!E11=\"NIO\",'6. Setting up Maintanace Serv.'!B11=\"J\"),1,0)","v":0}]
["6.8",{"$f":"'6. Setting up Maintanace Serv.'!J11","v":"OK"},{"$f":"IF('6. Setting up Maintanace Serv.'!J11=\"NOK\",'6. Setting up Maintanace Serv.'!I11,\"none\")","v":"none"},null,null,null,1,null,null,0,0,{"$f":"IF(AND('6. Setting up Maintanace Serv.'!E12=\"NIO\",'6. Setting up Maintanace Serv.'!B12=\"J\"),1,0)","v":0}]
["6.9",{"$f":"'6. Setting up Maintanace Serv.'!J12","v":"OK"},{"$f":"IF('6. Setting up Maintanace Serv.'!J12=\"NOK\",'6. Setting up Maintanace Serv.'!I12,\"none\")","v":"none"},null,null,null,1,null,null,0,0,{"$f":"IF(AND('7. Risk ass. with electr. Energ'!E12=\"NIO\",'7. Risk ass. with electr. Energ'!B12=\"J\"),1,0)","v":0}]
["Coordinated machines (Production lines)"]
["Production, loading and unloading"]
["6.10",{"$f":"'6. Setting up Maintanace Serv.'!J15","v":"OK"},{"$f":"IF('6. Setting up Maintanace Serv.'!J15=\"NOK\",'6. Setting up Maintanace Serv.'!I15,\"none\")","v":"none"},null,null,null,{"$f":"IF(B187=\"OK\",1,IF(B187=\"NR\",1,0))","v":1}]
["6.11",{"$f":"'6. Setting up Maintanace Serv.'!J16","v":"OK"},{"$f":"IF('6. Setting up Maintanace Serv.'!J16=\"NOK\",'6. Setting up Maintanace Serv.'!I16,\"none\")","v":"none"},null,null,null,1]
["Maintenance, service, cleaning and debugging work "]
["6.12",{"$f":"'6. Setting up Maintanace Serv.'!J18","v":"OK"},{"$f":"IF('6. Setting up Maintanace Serv.'!J18=\"NOK\",'6. Setting up Maintanace Serv.'!I18,\"none\")","v":"none"},null,null,null,{"$f":"IF(B190=\"OK\",1,IF(B190=\"NR\",1,0))","v":1}]
["6.13",{"$f":"'6. Setting up Maintanace Serv.'!J19","v":"OK"},{"$f":"IF('6. Setting up Maintanace Serv.'!J19=\"NOK\",'6. Setting up Maintanace Serv.'!I19,\"none\")","v":"none"},null,null,null,1]
["6.14",{"$f":"'6. Setting up Maintanace Serv.'!J20","v":"OK"},{"$f":"IF('6. Setting up Maintanace Serv.'!J20=\"NOK\",'6. Setting up Maintanace Serv.'!I20,\"none\")","v":"none"},null,null,null,1]
[null,{"$f":"COUNTIFS(B175:B184,\"blank\")","v":0},null,null,null,null,{"$f":"SUBTOTAL(101,'Overview of measures'!$G$175:$G$192)","v":1},null,null,0,0,{"$f":"IF(AND('7. Risk ass. with electr. Energ'!E13=\"NIO\",'7. Risk ass. with electr. Energ'!B13=\"J\"),1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,0,0,{"$f":"IF(AND('1. Documentation'!E140=\"NIO\",'1. Documentation'!B140=\"J\"),1,0)","v":0}]
["7. Risks associated with electrical energy",null,null,{"$f":"IF(B210>0,\"answered incompletely\",\"answer completely\")","v":"answer completely"},null,null,{"$f":"AVERAGE('Overview of measures'!$G$197:$G$209)","v":0.45454545454545453},null,null,1,0,{"$f":"IF(AND('1. Documentation'!E141=\"NIO\",'1. Documentation'!B141=\"J\"),1,0)","v":0}]
["Question No.","Assessment","Measures","Who","Date","Effectiveness check","% closed",null,null,0,0,{"$f":"IF(AND('1. Documentation'!E142=\"NIO\",'1. Documentation'!B142=\"J\"),1,0)","v":0}]
["7.1",{"$f":"'7. Risk ass. with electr. Energ'!J2","v":"NOK"},{"$f":"IF('7. Risk ass. with electr. Energ'!J2=\"NOK\",'7. Risk ass. with electr. Energ'!I2,\"none\")","v":0},null,null,null,{"$f":"IF(B197=\"OK\",1,IF(B197=\"NR\",1,0))","v":0},null,null,1,0,{"$f":"IF(AND('7. Risk ass. with electr. Energ'!E2=\"NIO\",'7. Risk ass. with electr. Energ'!B2=\"J\"),1,0)","v":0}]
["7.2",{"$f":"'7. Risk ass. with electr. Energ'!J3","v":"NOK"},{"$f":"IF('7. Risk ass. with electr. Energ'!J3=\"NOK\",'7. Risk ass. with electr. Energ'!I3,\"none\")","v":0},null,null,null,0,null,null,1,0,{"$f":"IF(AND('7. Risk ass. with electr. Energ'!E3=\"NIO\",'7. Risk ass. with electr. Energ'!B3=\"J\"),1,0)","v":0}]
["7.3",{"$f":"'7. Risk ass. with electr. Energ'!J4","v":"NOK"},{"$f":"IF('7. Risk ass. with electr. Energ'!J4=\"NOK\",'7. Risk ass. with electr. Energ'!I4,\"none\")","v":0},null,null,null,0,null,null,1,0,{"$f":"IF(AND('7. Risk ass. with electr. Energ'!E4=\"NIO\",'7. Risk ass. with electr. Energ'!B4=\"J\"),1,0)","v":0}]
["7.4",{"$f":"'7. Risk ass. with electr. Energ'!J5","v":"NOK"},{"$f":"IF('7. Risk ass. with electr. Energ'!J5=\"NOK\",'7. Risk ass. with electr. Energ'!I5,\"none\")","v":0},null,null,null,0,null,null,1,0,{"$f":"IF(AND('7. Risk ass. with electr. Energ'!E5=\"NIO\",'7. Risk ass. with electr. Energ'!B5=\"J\"),1,0)","v":0}]
["7.5",{"$f":"'7. Risk ass. with electr. Energ'!J6","v":"OK"},{"$f":"IF('7. Risk ass. with electr. Energ'!J6=\"NOK\",'7. Risk ass. with electr. Energ'!I6,\"none\")","v":"none"},null,null,null,1,null,null,0,0,{"$f":"IF(AND('7. Risk ass. with electr. Energ'!E6=\"NIO\",'7. Risk ass. with electr. Energ'!B6=\"J\"),1,0)","v":0}]
["7.6",{"$f":"'7. Risk ass. with electr. Energ'!J7","v":"NOK"},{"$f":"IF('7. Risk ass. with electr. Energ'!J7=\"NOK\",'7. Risk ass. with electr. Energ'!I7,\"none\")","v":0},null,null,null,0,null,null,1,0,{"$f":"IF(AND('7. Risk ass. with electr. Energ'!E7=\"NIO\",'7. Risk ass. with electr. Energ'!B7=\"J\"),1,0)","v":0}]
["7.7",{"$f":"'7. Risk ass. with electr. Energ'!J8","v":"OK"},{"$f":"IF('7. Risk ass. with electr. Energ'!J8=\"NOK\",'7. Risk ass. with electr. Energ'!I8,\"none\")","v":"none"},null,null,null,1,null,null,0,0,{"$f":"IF(AND('7. Risk ass. with electr. Energ'!E8=\"NIO\",'7. Risk ass. with electr. Energ'!B8=\"J\"),1,0)","v":0}]
["7.8",{"$f":"'7. Risk ass. with electr. Energ'!J9","v":"OK"},{"$f":"IF('7. Risk ass. with electr. Energ'!J9=\"NOK\",'7. Risk ass. with electr. Energ'!I9,\"none\")","v":"none"},null,null,null,1,null,null,0,0,{"$f":"IF(AND('7. Risk ass. with electr. Energ'!E9=\"NIO\",'7. Risk ass. with electr. Energ'!B9=\"J\"),1,0)","v":0}]
["7.9",{"$f":"'7. Risk ass. with electr. Energ'!J10","v":"OK"},{"$f":"IF('7. Risk ass. with electr. Energ'!J10=\"NOK\",'7. Risk ass. with electr. Energ'!I10,\"none\")","v":"none"},null,null,null,1,null,null,0,0,{"$f":"IF(AND('7. Risk ass. with electr. Energ'!E10=\"NIO\",'7. Risk ass. with electr. Energ'!B10=\"J\"),1,0)","v":0}]
["7.10",{"$f":"'7. Risk ass. with electr. Energ'!J11","v":"OK"},{"$f":"IF('7. Risk ass. with electr. Energ'!J11=\"NOK\",'7. Risk ass. with electr. Energ'!I11,\"none\")","v":"none"},null,null,null,1,null,null,0,0,{"$f":"IF(AND('7. Risk ass. with electr. Energ'!E11=\"NIO\",'7. Risk ass. with electr. Energ'!B11=\"J\"),1,0)","v":0}]
["Coordinated machines (Production lines)"]
["Direct or indirect contact with electrical energy"]
["7.11",{"$f":"'7. Risk ass. with electr. Energ'!J14","v":"NOK"},{"$f":"IF('7. Risk ass. with electr. Energ'!J14=\"NOK\",'7. Risk ass. with electr. Energ'!I14,\"none\")","v":0},null,null,null,{"$f":"IF(B209=\"OK\",1,IF(B209=\"NR\",1,0))","v":0}]
[null,{"$f":"COUNTIFS(B197:B206,\"blank\")","v":0},null,null,null,null,{"$f":"SUBTOTAL(101,'Overview of measures'!$G$197:$G$209)","v":0.45454545454545453},null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0,{"$f":"IF(AND('1. Documentation'!E154=\"NIO\",'1. Documentation'!B154=\"J\"),1,0)","v":0}]
[]
[]
[]
[]
[null,{"$f":"COUNTIFS(B9:B211,\"NOK\")","v":67}]
[null,{"$f":"COUNTIFS(B9:B211,\"OK\")","v":84}]
[null,{"$f":"COUNTIFS(B9:B211,\"NR\")","v":0}]
[null,{"$f":"COUNTIFS(B9:B211,\"blank\")","v":0}]
[null,{"$f":"SUM(B216:B219)","v":151}]

{"sheet":"1. Documentation","index":3,"n_rows":27,"n_cols":11,"rows_kept":27,"cut":false,"hidden":false,"merged":[[18,0,18,9],[19,0,19,9]]}
["1","Rel.","Owner\nMech.\nElect.","Documentation / Orderliness ","Assess-ment\n[choise]","Regula-tion. / Norm","FAQ","Comments","Measures","Bewertung"]
["1.1","J","M/E/O","Does the machine have a rating plate / name plate? (details of the manufacturer, type, year of construction, etc.) ","OK","MRL 2006/42/EG          Annex,1.7.3","INFO",null,null,{"$f":"E2","v":"OK"},{"$f":"IF(J2=\"NOK\",Ausgabe(),\"okay\")","v":"okay"}]
["1.2","N","O","Is an up-to-date version of the operating manual available in the native language of the country where the machine is used? ","NOK","MRL 2006/42/EG          Annex I,1.7.4","INFO",null,null,{"$f":"E3","v":"NOK"},{"$f":"IF(J3=\"NOK\",Ausgabe( ),\"okay\")","v":{"$error":"#NAME?"}}]
["1.3","N","O","Do the operators, set-up personnel and maintenance personnel etc. have access to the operating manual and to all of the documents required for them to perform the work assigned to them? ","OK",null,"INFO","Version:",null,"OK",{"$f":"IF(J4=\"NOK\",Ausgabe(),\"okay\")","v":"okay"}]
["1.4","J","O","Was the machine designe according to the local legal requirements at the date of Pruchasing/Comissioning?\nE.g. for machines used in Europe that were brought into circulation after 1995: Is an EC declaration of conformity available for the machine / system as a whole? ","NOK","MRL 2006/42/EG          Annex I,1.7.4.2.","INFO","Applicable also for self designed machines for internal use, but also after significant changes or conjacenated machines.",null,"NOK",{"$f":"IF(J5=\"NOK\",Ausgabe(),\"okay\")","v":{"$error":"#NAME?"}}]
["1.5","J","O/M/E","Does the operating manual contain a description of safe practices in production mode and for maintenance, troubleshooting, set-up and repair work? ","NOK",null,"INFO",null,null,"NOK",{"$f":"IF(J6=\"NOK\",Ausgabe(),\"okay\")","v":{"$error":"#NAME?"}}]
["1.6","N","E","Is a circuit diagram available and is it up to date? ","NOK",null,null,"Last update from: ",null,"NOK",{"$f":"IF(J7=\"NOK\",Ausgabe(),\"okay\")","v":{"$error":"#NAME?"}}]
["1.7",null,"M/E","Is a hydraulic diagram available and is it up to date? ","NOK",null,null,"Last update from: ",null,"NOK",{"$f":"IF(J8=\"NOK\",Ausgabe(),\"okay\")","v":{"$error":"#NAME?"}}]
["1.8",null,"M/E","Is a pneumatic diagram available and is it up to date? ","NOK",null,null,"Last update from: ",null,"NOK",{"$f":"IF(J9=\"NOK\",Ausgabe(),\"okay\")","v":{"$error":"#NAME?"}}]
["1.9","J","O","Have limits for using the machine been defined, e.g.: maximum speed; maximum pressure; part dimensions; etc. for which the machine has been designed? ","NOK",null,"INFO",null,null,"NOK",{"$f":"IF(J10=\"NOK\",Ausgabe(),\"okay\")","v":{"$error":"#NAME?"}}]
["1.10",null,"O","Does the operating manual contain details of safe practices for the handling of the residual risks that it describes (e.g. venting, relieving, unloading, etc.)? ","NOK",null,"INFO","  ",null,"NOK",{"$f":"IF(J11=\"NOK\",Ausgabe(),\"okay\")","v":{"$error":"#NAME?"}}]
["1.11",null,"O","Does the operating manual contain details of airborne noise emissions (noise level)?  ","NOK",null,"INFO","dB(A): ",null,"NOK",{"$f":"IF(J12=\"NOK\",Ausgabe(),\"okay\")","v":{"$error":"#NAME?"}}]
["1.12",null,"O/M/E","Does the machine bear the necessary safety and hazard warning signs? ","NOK","MRL 2006/42/EG          Annex I,1.7.2","INFO","ISO 3864-1 ",null,"NOK",{"$f":"IF(J13=\"NOK\",Ausgabe(),\"okay\")","v":{"$error":"#NAME?"}}]
["1.13",null,"O/M/E","Does the maintenance schedule give details of when safety related parts / components of the machine are to be inspected and the ways in which they are to be checked and maintained? ","NOK",null,null,"Provided by the owner \ne.g. components with specific wear, chains, screws, and other components keeping parts in a defined position but also Light Curtain, Safety Relays, etc.",null,"NOK",{"$f":"IF(J14=\"NOK\",Ausgabe(),\"okay\")","v":{"$error":"#NAME?"}}]
["1.14",null,null,"Is information about the exchange of components (if the end of lifecycle is reached) transferred from the Operating manual into the Preventive Maintenance Plan.","OK",null,null,"e.g. mecanical components, safety components (switches, relays, valves,..) hydraulic hoses,…",null,{"$f":"E15","v":"OK"},{"$f":"IF(J15=\"NOK\",Ausgabe(),\"okay\")","v":"okay"}]
["1.15",null,"O","Does the maintenance plan take the operating conditions into consideration? \n(e.g. 3 shifts etc.) ","NOK",null,null,"Provided by the owner ",null,"NOK",{"$f":"IF(J16=\"NOK\",Ausgabe(),\"okay\")","v":{"$error":"#NAME?"}}]
["1.16",null,"O","Are documented Work Instructions/OPIs available for the machine / process and contain the necessary information about hazards and adequate measures? cess? ","NOK",null,null,"Provided by the owner ",null,"NOK",{"$f":"IF(J17=\"NOK\",Ausgabe(),\"okay\")","v":{"$error":"#NAME?"}}]
["1.17",null,"O","Has a risk assessment been carried out by the manufacturer in accordance with ISO 12100 (or other appropriate specifications))","OK","ISO 12100",null,null,null,"OK",{"$f":"IF(J18=\"NOK\",Ausgabe(),\"okay\")","v":"okay"}]
["Coordinated machines (Production lines)",null,null,null,null,null,null,null,null,null,{"$f":"IF(J19=\"NOK\",Ausgabe(),\"okay\")","v":"okay"}]
["Documentation / Orderliness ",null,null,null,null,null,null,null,null,null,{"$f":"IF(J20=\"NOK\",Ausgabe(),\"okay\")","v":"okay"}]
["1.18",null,null,"Is a complete set of documentation available for the \"assembly of machines or systems\", which indicates / describes the operating modes and traversing variants of the complete production line as planned by the manufacturer?","NOK",null,null,null,null,{"$f":"E21","v":"NOK"},{"$f":"IF(J21=\"NOK\",Ausgabe(),\"okay\")","v":{"$error":"#NAME?"}}]
["1.19",null,null,"Are operating instructions / instructions for use available for the coordinated machines / systems? ","NOK",null,null,null,null,{"$f":"E22","v":"NOK"},{"$f":"IF(J22=\"NOK\",Ausgabe(),\"okay\")","v":{"$error":"#NAME?"}}]
["1.20",null,null,"Was a risk assessment (FSS 10) carried out for the various working areas and operator stations throughout the system? \nAre operators aware of the residual risks at the machine interfaces?\nAre operators aware of the residual risks associated with the operating modes planned by the manufacturer?","NOK",null,null,null,null,"NOK",{"$f":"IF(J23=\"NOK\",Ausgabe(),\"okay\")","v":{"$error":"#NAME?"}}]
["1.21",null,null,"Are the electrical safety interlocks for the individual machines clearly described for concatenated operation in interface diagrams or corresponding circuit diagrams?","NOK",null,null,null,null,"NOK",{"$f":"IF(J24=\"NOK\",Ausgabe(),\"okay\")","v":{"$error":"#NAME?"}}]
["1.22",null,null,"Are appropriate hydraulic diagrams available that show the interfaces between the various machines?","NOK",null,null,null,null,"NOK",{"$f":"IF(J25=\"NOK\",Ausgabe(),\"okay\")","v":{"$error":"#NAME?"}}]
["1.23",null,null,"Are appropriate pneumatic diagrams available that show the interfaces between the various machines?","NOK",null,null,null,null,"NOK",{"$f":"IF(J26=\"NOK\",Ausgabe(),\"okay\")","v":{"$error":"#NAME?"}}]
["1.24",null,null,"Are there lockout positions enabling safe disconnection of the energy supplies to the various machines and/or the machine as a whole, and are these clearly designated / clearly marked?","OK",null,null,null,null,"OK",{"$f":"IF(J27=\"NOK\",Ausgabe(),\"okay\")","v":"okay"}]

{"sheet":"2. Use and installation","index":4,"n_rows":9,"n_cols":11,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["2","Rel.","Owner\nMech.\nElect.","Use and installation","Assess-ment\n[choise]","Regula-tion. / Norm","FAQ","Comments","Measures","Bewertung"]
["2.1","J","O","Is the machine solely used for the purpose for which it was designed and built by the manufacturer? (e.g. speed material, tools, etc.) ","OK",null,"INFO",null,null,{"$f":"E2","v":"OK"},{"$f":"IF(J2=\"NIO\",Ausgabe(),\"okay\")","v":"okay"}]
["2.2",null,"O","Is the machine or equipment solely operated under the ambient conditions specified by the manufacturer? (e.g. temperature, humidity, altitude, etc.) ","NOK",null,"INFO",null,null,{"$f":"E3","v":"NOK"},{"$f":"IF(J3=\"NIO\",Ausgabe(),\"okay\")","v":"okay"}]
["2.3",null,"M/E","Is the machine connected to the energy levels specified by the manufacturer?  (e.g. maximum pressure, electrical fuses, voltage, nominal frequency, etc.) ","OK",null,"INFO",null,null,"OK",{"$f":"IF(J4=\"NIO\",Ausgabe(),\"okay\")","v":"okay"}]
["2.4","N","O/M/E","Are the working zones adequately illuminated for the work performed in them? ","NOK","BetrSichV Annex 2 / 2.4 ","INFO",null,null,"NOK",{"$f":"IF(J5=\"NIO\",Ausgabe(),\"okay\")","v":"okay"}]
["2.5",null,"M/E","Are the maintenance and service areas adequately illuminated for the work performed in them? ","OK","Annex 1 / 2.9 ","INFO",null,null,"OK",{"$f":"IF(J6=\"NIO\",Ausgabe(),\"okay\")","v":"okay"}]
["2.6",null,"M","Has the machine been anchored / secured in accordance with the manufacturer's instructions and have the normal loads and stresses, which may be encountered in operational service, been taken into consideration? ","NOK","MD 2006/42/EC          Annex I, 1.3.1 ","INFO",null,null,"NOK",{"$f":"IF(J7=\"NIO\",Ausgabe(),\"okay\")","v":"okay"}]
["2.7","J","M","Have all machine parts, components, guards and safety devices been fitted properly and securely? ","OK",null,null,"Visual inspection",null,"OK",{"$f":"IF(J8=\"NIO\",Ausgabe(),\"okay\")","v":"okay"}]
[null,{"$f":"COUNTIF('2. Use and installation'!$B$2:$B$8,\"J\")","v":2}]

{"sheet":"3. Control syst. + command","index":5,"n_rows":65,"n_cols":11,"rows_kept":65,"cut":false,"hidden":false,"merged":[]}
["3","Rel.","Owner\nMech.\nElect.","Control systems and command facilities (operator control elements)","Assess-ment\n[choise]","Regula-tion. / Norm","FAQ","Comments","Measures","Bewertung"]
["3.1",null,"O/M/E","Have measures been taken to ensure that reasonably foreseeable human error during operation does not lead to hazardous situations? ","NOK","MRL 2006/42/EG          Annex I,1.2.1","INFO","according to \nIEC 61508 / IEC 62061",null,{"$f":"E2","v":"NOK"},{"$f":"IF(J2=\"NOK\",Ausgabe(),\"okay\")","v":{"$error":"#NAME?"}}]
["3.2",null,"E/M","Have measures been taken to ensure that the machine cannot start unexpectedly? ","OK","MRL 2006/42/EG          Annex I,1.2.1","INFO","according to \nIEC 61508 / IEC 62061",null,{"$f":"E3","v":"OK"},{"$f":"IF(J3=\"NOK\",Ausgabe(),\"okay\")","v":"okay"}]
["3.3","J","E/M","Have measures been taken to ensure that the parameters of the machinery do not change in an uncontrolled way, where such change may lead to hazardous situations? ","NOK","MRL 2006/42/EG          Annex I,1.2.1","INFO",null,null,"NOK",{"$f":"IF(J4=\"NOK\",Ausgabe(),\"okay\")","v":{"$error":"#NAME?"}}]
["3.4",null,"M/E","Have measures been taken to ensure that stop commands always have priority over start commands?","OK","MRL 2006/42/EG          Annex I,1.2.1","INFO",null,null,"OK",{"$f":"IF(J5=\"NOK\",Ausgabe(),\"okay\")","v":"okay"}]
["3.5",null,"M/E","Have measures been taken to ensure that objects, which constitute a potential risk, cannot fall or be ejected? ","NOK","MRL 2006/42/EG          Annex I,1.2.1","INFO",null,null,"NOK",{"$f":"IF(J6=\"NOK\",Ausgabe(),\"okay\")","v":{"$error":"#NAME?"}}]
["3.6","J","M/E","Have measures been taken to ensure that potentially hazardous movements can be stopped at any time in any operating mode? ","OK","MRL 2006/42/EG          Annex I,1.2.1","INFO",null,null,"OK",{"$f":"IF(J7=\"NOK\",Ausgabe(),\"okay\")","v":"okay"}]
["Command facilities ",null,null,null,null,null,null,null,null,null,{"$f":"IF(J8=\"NOK\",Ausgabe(),\"okay\")","v":"okay"}]
["3.7",null,"E/M","Are the command facilities / control devices clearly recognizable as such and can their functions be easily differentiated by means of labels in the national language or pictograms? ","NOK","MRL 2006/42/EG          Annex I,1.2.2.","INFO",null,null,"NOK",{"$f":"IF(J9=\"NOK\",Ausgabe(),\"okay\")","v":{"$error":"#NAME?"}}]
["3.8",null,"E/M","Are the command facilities / control devices positioned in such a way as to ensure that they can be operated reliably, safely, unhesitatingly, quickly and positively? ","OK","MRL 2006/42/EG          Annex I,1.2.2.","INFO",null,null,"OK",{"$f":"IF(J10=\"NOK\",Ausgabe(),\"okay\")","v":"okay"}]
["3.9",null,"E/M","Are the command facilities fitted outside the hazardous zones? ","NOK","MRL 2006/42/EG          Annex I,1.2.2.","INFO",null,null,"NOK",{"$f":"IF(J11=\"NOK\",Ausgabe(),\"okay\")","v":{"$error":"#NAME?"}}]
["3.10",null,"E/M","Are the command facilities / control devices positioned in such a way as to ensure that the operator can see into the danger zone, or have measures been implemented to meet the requirements laid down in 3.11 to 3.15?","OK","MRL 2006/42/EG          Annex I,1.2.2.","INFO",null,null,"OK",{"$f":"IF(J12=\"NOK\",Ausgabe(),\"okay\")","v":"okay"}]
["3.11",null,"O/E/M","If it is not possible to see into the danger zone(s): Has a person detection system been installed? ","NOK","MRL 2006/42/EG          Annex I,1.2.2.","INFO",null,null,"NOK",{"$f":"IF(J13=\"NOK\",Ausgabe(),\"okay\")","v":{"$error":"#NAME?"}}]
["3.12",null,"E/M","Or does the control system transmit an acoustic or visual warning signal before the machine is started?","OK","MRL 2006/42/EG          Annex I,1.2.2.","INFO",null,null,"OK",{"$f":"IF(J14=\"NOK\",Ausgabe(),\"okay\")","v":"okay"}]
["3.13",null,"E/M","Are the visual warning signals easily visible and can they be distinguished from other warning signals? ","NOK","MRL 2006/42/EG          Annex I,1.2.2.",null,null,null,"NOK",{"$f":"IF(J15=\"NOK\",Ausgabe(),\"okay\")","v":{"$error":"#NAME?"}}]
["3.14",null,"E/M","Are the acoustic warning signals easily audible and can they be distinguished from other warning signals? ","OK","MRL 2006/42/EG          Annex I,1.2.2.",null,null,null,"OK",{"$f":"IF(J16=\"NOK\",Ausgabe(),\"okay\")","v":"okay"}]
["3.15",null,"O/E/M","Does the employee have sufficient time to leave the danger zone? ","NOK","MRL 2006/42/EG          Annex I,1.2.2.","INFO",null,null,"NOK",{"$f":"IF(J17=\"NOK\",Ausgabe(),\"okay\")","v":{"$error":"#NAME?"}}]
["3.16",null,"O/E/M","Have measures been taken to ensure that, if there are several control positions, the machine can only be controlled from one control position at any one time? ","OK","MRL 2006/42/EG          Annex I,1.2.2.","INFO",null,null,"OK",{"$f":"IF(J18=\"NOK\",Ausgabe(),\"okay\")","v":"okay"}]
["Start-up (power-up, switch-on, etc.) ",null,null,null,null,null,null,null,null,null,{"$f":"IF(J19=\"NOK\",Ausgabe(),\"okay\")","v":"okay"}]
["3.17",null,"E/M","Have measures been taken to the ensure that no potentially hazardous movements are triggered when energy sources are activated (e.g. connecting up to the compressed air supply, turning the master switch on, etc.)? ","NOK","IEC 60 204-1\n7.5",null,null,null,"NOK",{"$f":"IF(J20=\"NOK\",Ausgabe(),\"okay\")","v":{"$error":"#NAME?"}}]
["3.18",null,"E/M","Have measures been taken to ensure that no potentially hazardous movements can occur when an energy supply is resumed after a failure? (undervoltage protection).","OK",null,null,null,null,"OK",{"$f":"IF(J21=\"NOK\",Ausgabe(),\"okay\")","v":"okay"}]
["Shutdown (power-down, switch-off) "]
["3.19",null,"E","Is there a master switch to turn the complete machine off? ","NOK",null,null,null,null,"NOK",{"$f":"IF(J23=\"NOK\",Ausgabe(),\"okay\")","v":{"$error":"#NAME?"}}]
["3.20",null,"E","Can the master switch be secured to prevent unauthorized or inadvertent operation? ","OK",null,null,null,null,"OK",{"$f":"IF(J24=\"NOK\",Ausgabe(),\"okay\")","v":"okay"}]
["3.21","J","E/M","Are command facilities to deactivate potentially hazardous movements / parts, or the machine as a whole, provided at every workplace? ","NOK","MRL 2006/42/EG          Annex I,1.2.4.1","INFO",null,null,"NOK",{"$f":"IF(J25=\"NOK\",Ausgabe(),\"okay\")","v":{"$error":"#NAME?"}}]
["3.22",null,"E/M","When the system is shut down, does this result in the machine assuming a safe state? ","OK","MRL 2006/42/EG          Annex I,1.2.4.2",null,null,null,"OK",{"$f":"IF(J26=\"NOK\",Ausgabe(),\"okay\")","v":"okay"}]
["3.23",null,"E","Are easily accessible and clearly recognizable facilities provided to disconnect the machine from the electrical energy source? ","NOK","MRL 2006/42/EG          Annex I,1.6.3.","INFO",null,null,"NOK",{"$f":"IF(J27=\"NOK\",Ausgabe(),\"okay\")","v":{"$error":"#NAME?"}}]
["3.24",null,"E/M","Are easily accessible and clearly recognizable facilities provided to disconnect the machine from the pneumatic energy source? ","OK","MRL 2006/42/EG          Annex I,1.6.3.",null,null,null,"OK",{"$f":"IF(J28=\"NOK\",Ausgabe(),\"okay\")","v":"okay"}]
["3.25",null,"E/M","Are easily accessible and clearly recognizable facilities provided to disconnect the machine from the hydraulic energy source? ","NOK","MRL 2006/42/EG          Annex I,1.6.3.",null,null,null,"NOK",{"$f":"IF(J29=\"NOK\",Ausgabe(),\"okay\")","v":{"$error":"#NAME?"}}]
["3.26",null,"E/M","Are easily accessible and clearly recognizable facilities provided to disconnect the machine from the steam energy source? ","OK","MRL 2006/42/EG          Annex I,1.6.3.",null,null,null,"OK",{"$f":"IF(J30=\"NOK\",Ausgabe(),\"okay\")","v":"okay"}]
["3.27","J","E/M","Are easily accessible and clearly recognizable facilities provided to disconnect the machine from any other energy sources? ","NOK","MRL 2006/42/EG          Annex I,1.6.3.",null,null,null,"NOK",{"$f":"IF(J31=\"NOK\",Ausgabe(),\"okay\")","v":{"$error":"#NAME?"}}]
["Emergency stop devices "]
["3.28",null,"E","Do the emergency stop devices operate reliably? Does the installation comply with the requirements for the risk-specific performance level (PLr) as laid down in\nISO 13849-1? ","OK","ISO 13849-1","INFO",null,null,"OK",{"$f":"IF(J33=\"NOK\",Ausgabe(),\"okay\")","v":"okay"}]
["3.29",null,"E/M","Does the failure of a safety device lead to the machine coming to a standstill? ","NOK","MD 2006/42/EC          Annex I, 1.2.4.3 ",null,null,null,"NOK",{"$f":"IF(J34=\"NOK\",Ausgabe(),\"okay\")","v":{"$error":"#NAME?"}}]
["3.30","N","E/M","Have measures been taken to ensure that activation of the emergency stop facility does not result in any additional potentially hazardous movement?","OK",null,null,null,null,"OK",{"$f":"IF(J35=\"NOK\",Ausgabe(),\"okay\")","v":"okay"}]
["3.31","J","E","Is the emergency stop device easily accessible? ","NOK","EN ISO 13850",null,null,null,"NOK",{"$f":"IF(J36=\"NOK\",Ausgabe(),\"okay\")","v":{"$error":"#NAME?"}}]
["3.32",null,"E","Do the emergency stop devices take the form of pushbuttons, mushroom-head pushbuttons, bars fitted at waist height or cable-operated switches? ","OK",null,null,null,null,"OK",{"$f":"IF(J37=\"NOK\",Ausgabe(),\"okay\")","v":"okay"}]
["3.33",null,"E","Are the emergency stop devices colored RED, with a yellow background wherever possible? ","NOK",null,null,null,null,"NOK",{"$f":"IF(J38=\"NOK\",Ausgabe(),\"okay\")","v":{"$error":"#NAME?"}}]
["3.34",null,"E","Have the emergency stop actuating elements been designed as latching components (it must not be possible to reset by simply removing the load from the actuating component)? ","OK",null,null,null,null,"OK",{"$f":"IF(J39=\"NOK\",Ausgabe(),\"okay\")","v":"okay"}]
["3.34",null,"E","Does the emergency stop device transpose potentially hazardous movements or processes into a safe state as quickly as possible (stop category)? ","NOK","ISO 13850",null,null,null,"NOK",{"$f":"IF(J40=\"NOK\",Ausgabe(),\"okay\")","v":{"$error":"#NAME?"}}]
["Coordinated machines (Production lines)"]
["Command facilities "]
["3.36",null,null,"Do the control consoles and operator consoles for the various machine give a clear indication of the machines to which they belong?\nIt is easy to distinguish between their respective command functions? \nHave measures been taken to eliminate the risk of mistaking one control console / operator control element with another? ","OK",null,null,null,null,"OK",{"$f":"IF(J43=\"NOK\",Ausgabe(),\"okay\")","v":"okay"}]
["3.37",null,null,"Where control and mode selector switches are provided at several locations, have measures been taken to ensure that they cannot be set to different positions.\nIs each selector switch position clearly recognizable and does it correspond to just one control / operating mode?","NOK",null,null,null,null,"NOK",{"$f":"IF(J44=\"NOK\",Ausgabe(),\"okay\")","v":{"$error":"#NAME?"}}]
["3.38",null,null,"Have measures been taken to ensure that the shutdown control elements for the assembly of machines, including the EMERGENCY STOP control elements, not only bring the machine to a standstill, but also all of the facilities connected to it where continued operation of such facilities could constitute a potential hazard?","OK",null,null,null,null,"OK",{"$f":"IF(J45=\"NOK\",Ausgabe(),\"okay\")","v":"okay"}]
["3.39",null,null,"Do the machine operators have an unobstructed view of the hazardous zone(s) in the concatenated system from every operator / control console? \nIf not, has a person presence detection system been installed, or\nare acoustic or visual alarm signals given before the system is started and does the employee have sufficient time to leave the hazardous zone?","OK",null,null,null,null,"OK",{"$f":"IF(J46=\"NOK\",Ausgabe(),\"okay\")","v":"okay"}]
["Start-up of the coordinated line"]
["3.40",null,null,"Is it only possible to START the concatenated machines / production line by deliberately operating the control elements provided for this purpose?","NOK",null,null,null,null,"NOK",{"$f":"IF(J48=\"NOK\",Ausgabe(),\"okay\")","v":{"$error":"#NAME?"}}]
["3.41",null,null,"Have measures been taken to ensure that the assembly of machines / production line cannot be started from several control consoles at the same time? kann?","NOK",null,null,null,null,"NOK",{"$f":"IF(J49=\"NOK\",Ausgabe(),\"okay\")","v":{"$error":"#NAME?"}}]
["3.42",null,null,"Have measures been taken to ensure that changes to the machine parameters (e.g. filling level, temperature, speed, etc.) cannot lead to uncontrolled start-up of other units (e.g. follower machine)? ","OK",null,null,null,null,"OK",{"$f":"IF(J50=\"NOK\",Ausgabe(),\"okay\")","v":"okay"}]
["3.43",null,null,"Measures have been taken to ensure that the machine(s) cannot start up unintentionally in the event of a breakdown in the energy supply to the machine(s), when the energy supply has been restored following a breakdown, or following a change in the energy supply.","NOK",null,null,null,null,"NOK",{"$f":"IF(J51=\"NOK\",Ausgabe(),\"okay\")","v":{"$error":"#NAME?"}}]
["3.44",null,null,"Measures have been taken to ensure that moving machine components or workpieces held by the machine cannot drop or be thrown out of the machine in the event of an energy failure.","NOK",null,null,null,null,"NOK",{"$f":"IF(J52=\"NOK\",Ausgabe(),\"okay\")","v":{"$error":"#NAME?"}}]
["Shutdown of the coordinated line"]
["3.45",null,null,"Is each operator console equipped with OFF switches (System STOP) for the assembly of machines?\nThese STOP functions have priority over all other operator / control functions","OK",null,null,null,null,"OK",{"$f":"IF(J54=\"NOK\",Ausgabe(),\"okay\")","v":"okay"}]
["3.46",null,null,"Is the entire production line / system BROUGHT TO A STANDSTILL in a safe, coordinated manner?","OK",null,null,null,null,"OK",{"$f":"IF(J55=\"NOK\",Ausgabe(),\"okay\")","v":"okay"}]
["3.47",null,null,"Is there a main isolating switch (master switch) to switch the entire concatenated system on and off?en?","OK",null,null,null,null,"OK",{"$f":"IF(J56=\"NOK\",Ausgabe(),\"okay\")","v":"okay"}]
["3.48",null,null,"If not, has a clearly recognizable facility been provided that offers a means of isolating every machine from every energy source?\n(cf General FSS 5 checklists for the individual machines)?","NOK",null,null,null,null,"NOK",{"$f":"IF(J57=\"NOK\",Ausgabe(),\"okay\")","v":{"$error":"#NAME?"}}]
["3.49",null,null,"Considering the interfaces, has a clearly visible facility been provided that offers a means of isolating and locking the system out from every energy source in the various production or maintenance modes?","NOK",null,null,null,null,"NOK",{"$f":"IF(J58=\"NOK\",Ausgabe(),\"okay\")","v":{"$error":"#NAME?"}}]
["E-Stop devices of the coordinated line"]
["3.50",null,null,"Are EMERGENCY STOP control elements provided at every control / operator console and at every workplace?\nWhen operated, do the individual machines come to a standstill as quickly as possible, without give rise to additional risks?","NOK",null,null,null,null,"NOK",{"$f":"IF(J60=\"NOK\",Ausgabe(),\"okay\")","v":{"$error":"#NAME?"}}]
["3.51",null,null,"EMERGENCY STOP control elements for the assembly of machines and EMERGENCY STOP control elements for individual machines (maschine stop) are clearly marked and described in an appropriate manner for the machine operators in their various functions?","NOK",null,null,null,null,"NOK",{"$f":"IF(J61=\"NOK\",Ausgabe(),\"okay\")","v":{"$error":"#NAME?"}}]
["3.52",null,null,"Can the EMERGENCY STOP control elements for the individiual machines be operated without giving rise to any additional risks or hazards? \nAll of the EMERGENCY STOP control elements installed on the assembly of machines must be reset locally at the EMERGENCY STOP control elements themselves and acknowledged at a central operator control station for the sys-tem.\nNeither the individual machine nor the assembly of machines may start up au-tomatically following the acknowledgement.  ","OK",null,null,null,null,"OK",{"$f":"IF(J62=\"NOK\",Ausgabe(),\"okay\")","v":"okay"}]
["Warningsignals and warning signs"]
["3.53",null,null,"When using different visual and acoustic alarm systems, are they easy to assign to the respective machine and clearly marked accordingly?","OK",null,null,null,null,"OK",{"$f":"IF(J64=\"NOK\",Ausgabe(),\"okay\")","v":"okay"}]
["3.54",null,null,"Are hazard marking pictograms used and are they arranged outside the danger areas?","NOK",null,null,null,null,"NOK",{"$f":"IF(J65=\"NOK\",Ausgabe(),\"okay\")","v":{"$error":"#NAME?"}}]

{"sheet":"4. Protection against mech. haz","index":6,"n_rows":116,"n_cols":11,"rows_kept":116,"cut":false,"hidden":false,"merged":[]}
["4","Rel.","Owner\nMech.\nElect.","Protection against mechanical hazards ","Assess-ment\n[choise]","Regula-tion. / Norm","FAQ","Comments","Measures","Bewertung"]
["4.1",null,"M","Have protective measures been implemented to guard against hazards caused by machine parts breaking, bursting and shattering? ","NOK","MD 2006/42/EG          Annex I,1.3.2","INFO",null,null,{"$f":"E2","v":"NOK"},{"$f":"IF(J2=\"NOK\",Ausgabe(),\"okay\")","v":{"$error":"#NAME?"}}]
["4.2",null,"M","Have all parts of the machine been fitted properly and securely? ","NOK","MD 2006/42/EG          Annex I,1.3.2","INFO",null,null,{"$f":"E3","v":"NOK"},{"$f":"IF(J3=\"NOK\",Ausgabe(),\"okay\")","v":{"$error":"#NAME?"}}]
["4.3",null,"M/E","Are all cables, pipes, leads and hoses protected and secured? (e.g. by hydraulic, pneumatic and thermal means) ","OK",null,null,null,null,"OK",{"$f":"IF(J4=\"NOK\",Ausgabe(),\"okay\")","v":"okay"}]
["4.4",null,"M/E","Have safety devices been installed that prevent machine components / loads falling or sagging? Hydraulic / pneumatic check valves or mechanical fall arresters. ","NOK","MD 2006/42/EG          Annex I,1.3.3 Annex I, 1.3.9.","INFO",null,null,"NOK",{"$f":"IF(J5=\"NOK\",Ausgabe(),\"okay\")","v":{"$error":"#NAME?"}}]
["4.5","J","M","Have measures been taken to ensure that accessible machine parts have no sharp or rough edges and no projecting components? ","OK","MD 2006/42/EG          Anhnex I,1.3.4","INFO",null,null,"OK",{"$f":"IF(J6=\"NOK\",Ausgabe(),\"okay\")","v":"okay"}]
["Risks arising from moving parts "]
["4.6",null,"M/E","Do the selected guards and safety devices prevent access to danger zones or bring potentially hazardous movements to a standstill before personnel can reach the danger zones?\n\n(minimum safety clearances are taken into account) ","OK","MD 2006/42/EG          Annex I,1.3.7     (EN 13857)","INFO",null,null,"OK",{"$f":"IF(J8=\"NOK\",Ausgabe(),\"okay\")","v":"okay"}]
["4.7","J","M","Are all guards and safety devices present and undamaged and are they in good working order? ","NOK",null,null,"Visual inspection ",null,"NOK",{"$f":"IF(J9=\"NOK\",Ausgabe(),\"okay\")","v":{"$error":"#NAME?"}}]
["4.8","N","M","Have the safety devices or guards been designed and built as rugged elements? ","OK","MD 2006/42/EC          Annex I, 1.3.2","INFO",null,null,"OK",{"$f":"IF(J10=\"NOK\",Ausgabe(),\"okay\")","v":"okay"}]
["4.9","J","M/E/O","Have measures been taken to ensure that the guards and safety devices do not obstruct the necessary observation of the processes? ","OK","EN 953 section 5.10 ","INFO",null,null,"OK",{"$f":"IF(J11=\"NOK\",Ausgabe(),\"okay\")","v":"okay"}]
["4.10",null,"O/M/E","Have measures been taken to ensure that the guards and safety devices do not give rise to any additional hazards? ","OK","EN 953 section 5.3.2 ","INFO",null,null,"OK",{"$f":"IF(J12=\"NOK\",Ausgabe(),\"okay\")","v":"okay"}]
["4.11",null,"M/E","Have measures been taken to prevent vertically moving safety devices falling? ","OK","MD 2006/42/EG          Annex I,1.4.1.","INFO",null,null,"OK",{"$f":"IF(J13=\"NOK\",Ausgabe(),\"okay\")","v":"okay"}]
["4.12",null,"E/M","Are the installed guards and safety devices designed in such a way as to ensure that they cannot be easily manipulated, bypassed or rendered ineffective? ","OK","MD 2006/42/EG          Annex I,1.4.1.","INFO",null,null,"OK",{"$f":"IF(J14=\"NOK\",Ausgabe(),\"okay\")","v":"okay"}]
["4.13",null,"M/E","Are all guards and safety devices secured with safety bolts? (safety devices, guards, safety switches, light barriers, etc.) ","OK",null,"INFO",null,null,"OK",{"$f":"IF(J15=\"NOK\",Ausgabe(),\"okay\")","v":"okay"}]
["Fixed guards and safety devices "]
["4.14",null,"M/E","Have all fixed guards and safety devices been fitted in their designated places properly, with at least 2 safety bolts? ","NOK","MD 2006/42/EG          Annex I,1.4.2.1.","INFO",null,null,"NOK",{"$f":"IF(J17=\"NOK\",Ausgabe(),\"okay\")","v":{"$error":"#NAME?"}}]
["4.15",null,"M/E","Does the guard / safety device prevent personnel reaching around, under, through and over (A-U-T-O) the danger zone with upper and lower limbs?  ","OK","ISO 13857","INFO",null,null,"OK",{"$f":"IF(J18=\"NOK\",Ausgabe(),\"okay\")","v":"okay"}]
["4.16",null,"M/E","Are interlocking devices (safety switches) in place, which monitor the fixed guards and safety devices that are opened more than once a year? ","NOK",null,null,null,null,"NOK",{"$f":"IF(J19=\"NOK\",Ausgabe(),\"okay\")","v":{"$error":"#NAME?"}}]
["Moving guards and safety devices "]
["4.17",null,"E/M","Are all moving safety devices monitored by interlocking devices (e.g. safety switches)?  ","OK","MRL 2006/42/EG          Anhang I,1.4.2.2.","INFO",null,null,"OK",{"$f":"IF(J21=\"NOK\",Ausgabe(),\"okay\")","v":"okay"}]
["4.18",null,"E","When the safety function(s) depent on a control system (e.g. interlocking devices, light curtain. Two-hand-startd, etc.)  are they consistent with the hazard-specific and risk-specific safety level (performance level (PL))? ","OK","EN 954 / ISO EN 13849 / EN 62061 / IEC 61508","INFO",null,null,"OK",{"$f":"IF(J22=\"NOK\",Ausgabe(),\"okay\")","v":"okay"}]
["4.19",null,"E/M","Are movable guards and safety devices on machines with stopping time secured by means of interlocking devices with guard locking devices? ","OK","MRL 2006/42/EG          Anhang I,1.4.2.2.","INFO",null,null,"OK",{"$f":"IF(J23=\"NOK\",Ausgabe(),\"okay\")","v":"okay"}]
["4.20","J","E/M","Are the edges of powered guards and safety devices protected by safety shutdown facilities (safety contact bars)? ","OK","EN 953 Abs. 5.2.5.2","INFO",null,null,"OK",{"$f":"IF(J24=\"NOK\",Ausgabe(),\"okay\")","v":"okay"}]
["Protective devices (e.g. light curtains, laser scanners, two-hand triggering facilities, pressure-sensitive mats). "]
["4.21",null,"E/M","Are the safety clearances and stopping times given on the machine for all danger zones? ","NOK","ISO 13855","INFO",null,null,"NOK",{"$f":"IF(J26=\"NOK\",Ausgabe(),\"okay\")","v":{"$error":"#NAME?"}}]
["4.22",null,"E/M","Are the actual safety clearances and stopping times meeting the requirements for a safe operation of the process?","OK",null,null,null,null,"OK",{"$f":"IF(J27=\"NOK\",Ausgabe(),\"okay\")","v":"okay"}]
["4.23",null,"E/M","Does the safety device remain active until the contact gap is less than 4 mm wide? ","OK",null,null,null,null,"OK",{"$f":"IF(J28=\"NOK\",Ausgabe(),\"okay\")","v":"okay"}]
["4.24","J","E/M","Has one of the following precautions been taken to prevent people walking behind guards and safety devices:\n- Person detection system (e.g. pressure-sensitive mat, scanner, etc.)\n- Hand-held control device with enabling button\n- Double command inputs (e.g. acknowledging walking behind the safety device and a deliberate start command)\nonly to be used if the hazardous area is clearly under visual control?","OK",null,null,null,null,"OK",{"$f":"IF(J29=\"NOK\",Ausgabe(),\"okay\")","v":"okay"}]
["4.25",null,"E/M","If a two-hand control device is installed: \nis the permitted interval between pressing the two buttons no longer than 0.5 seconds? \n","OK","DIN EN 574",null,null,null,"OK",{"$f":"IF(J30=\"NOK\",Ausgabe(),\"okay\")","v":"okay"}]
["4.26",null,"O/M/E","If a two-hand triggering device is installed: \nHas the workplace been designed as a one-man workplace? ","OK","DIN EN 574","INFO",null,null,"OK",{"$f":"IF(J31=\"NOK\",Ausgabe(),\"okay\")","v":"okay"}]
["4.27","J","E/M","Have measures been taken to eliminate the possibility of manipulating the two-hand control device? ","OK",null,"INFO",null,null,"OK",{"$f":"IF(J32=\"NOK\",Ausgabe(),\"okay\")","v":"okay"}]
["4.28",null,"M/E","Have measures been taken to make it impossible to access the danger zone during a two-hand start? ","OK",null,null,null,null,"OK",{"$f":"IF(J33=\"NOK\",Ausgabe(),\"okay\")","v":"okay"}]
["4.29",null,"M/E","Does the potentially hazardous movement only occur during a two-hand start? ","OK",null,null,null,null,"OK",{"$f":"IF(J34=\"NOK\",Ausgabe(),\"okay\")","v":"okay"}]
["4.30",null,"E/M","Have the necessary safety clearances been determined and are they observed? ","OK",null,"INFO",null,null,"OK",{"$f":"IF(J35=\"NOK\",Ausgabe(),\"okay\")","v":"okay"}]
["Coordinated machines (Production lines)"]
["Fixed guards and movable guards"]
["4.31",null,null,"Have the potentially hazardous areas at the interfaces / handover points between the individual machines been secured by means of guards and safety devices?","NOK",null,null,null,null,"NOK",{"$f":"IF(J38=\"NOK\",Ausgabe(),\"okay\")","v":{"$error":"#NAME?"}}]
["4.32",null,null,"Do these guards and safety devices comply with the requirements laid down in the general machine safety checklist?","OK",null,null,null,null,"OK",{"$f":"IF(J39=\"NOK\",Ausgabe(),\"okay\")","v":"okay"}]
["4.33",null,null,"The opening of a guard or safety device brings the movement of the machine in the protected area to a standstill. After-running times have been taken into consideration.","NOK",null,null,null,null,"NOK",{"$f":"IF(J40=\"NOK\",Ausgabe(),\"okay\")","v":{"$error":"#NAME?"}}]
["Breaking, bursting, shattering"]
["4.34",null,null,"Are the interface lines (pipelines, energy, signaling and interlick signaling lines) between the individual machines adequately protected against any risk of damage?\nDoes an interruption in or damage to any of these lines result in a safe shutdown of the machines?","NOK",null,null,null,null,"NOK",{"$f":"IF(J42=\"NOK\",Ausgabe(),\"okay\")","v":{"$error":"#NAME?"}}]
["4.35",null,null,"Have protective measures been implemented to protect personnel from hazards caused by machine parts breaking, bursting and shattering in the interface zones?","OK",null,null,null,null,"OK",{"$f":"IF(J43=\"NOK\",Ausgabe(),\"okay\")","v":"okay"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"'4. Protection against mech. haz'!A39","v":"4.32"}]

{"sheet":"5. Other hazards ","index":7,"n_rows":10,"n_cols":11,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["5","Rel.","Owner\nMech.\nElect.","Others hazards","Assess-ment\n[choise]","Regula-tion. / Norm","FAQ","Comments","Measures","Bewertung"]
["Hazards arising from hot and cold surfaces "]
["5.1",null,"E/M","Have appropriate technical protective measures been taken to reliably prevent personnel coming into contact with very hot or very cold parts, or does question 5.2 apply?\n(e.g. Contact duration 0.5 s, metal surface --> burning threshold 67°C (153°F); \nContact duration 0.5 s, plastic surface --> buring threshold 90°C (194°F)) ","NOK","BetrSichV / 2.10","INFO","ISO 13732-1-2006-Ergonomics of thermal environment - Methods for the assessment of human responses to contact with surfaces",null,{"$f":"E3","v":"NOK"},{"$f":"IF(J3=\"NIO\",Ausgabe(),\"okay\")","v":"okay"}]
["5.2",null,"E/M/O","Where this is not possible, is contact prevented by handling equipment or personal protective equipment worn by the personnel? ","OK","MD 2006/42/EC          Annex I, 1.5.5.","INFO",null,null,{"$f":"E4","v":"OK"},{"$f":"IF(J4=\"NIO\",Ausgabe(),\"okay\")","v":"okay"}]
["5.3","N","E/M/O","Are the hot and cold surfaces marked accordingly? ","OK","MD 2006/42/EC          Annex I, 1.5.5.",null,null,null,"OK",{"$f":"IF(J5=\"NIO\",Ausgabe(),\"okay\")","v":"okay"}]
["Hazards caused by gas, vapor, mist, liquid and dust \nVisual inspection, working zone analysis, test record \n",null,null,null,null,null,null,null,null,null,{"$f":"IF(J6=\"NIO\",Ausgabe(),\"okay\")","v":"okay"}]
["5.4",null,"O","Have extraction facilities been installed to extract such emissions at source? (e.g. workplace limits) ","OK","MD 2006/42/EC          Annex I, 1.5.13.","INFO",null,null,"OK",{"$f":"IF(J7=\"NIO\",Ausgabe(),\"okay\")","v":"okay"}]
["Risk of personnel slipping, tripping or falling ",null,null,null,null,null,null,null,null,null,{"$f":"IF(J8=\"NIO\",Ausgabe(),\"okay\")","v":"okay"}]
["5.5","J","O/M/E","Have measures been taken to ensure that personnel cannot slip, trip or fall? ","OK","MD 2006/42/EC          Annex I, 1.5.15.","INFO",null,null,"OK",{"$f":"IF(J9=\"NIO\",Ausgabe(),\"okay\")","v":"okay"}]
["5.6",null,"O/M/E","Have suitable catwalks, platforms or intermediate platforms been installed to ensure safe access to the equipment?  For maintenance, cleaning, loading with raw materials or removing the product at parts of the plant, which cannot be reached from the floor, for example? ","OK","MD 2006/42/EC          Annex I, 1.5.15.",null,null,null,"OK",{"$f":"IF(J10=\"NIO\",Ausgabe(),\"okay\")","v":"okay"}]

{"sheet":"6. Setting up Maintanace Serv.","index":8,"n_rows":127,"n_cols":11,"rows_kept":127,"cut":false,"hidden":false,"merged":[]}
["6","Rel.","Owner\nMech.\nElect.","Setting up / Maintenance / Service","Assess-ment\n[choise]","Regula-tion. / Norm","FAQ","Comments","Measures","Bewertung"]
["Setting up / Maintenance / Service"]
["6.1",null,"M/E","Do personnel have safe access to all of the areas required to perform their work safely? ","OK","MD 2006/42/EC          Annex I, 1.6.4","INFO",null,null,{"$f":"E3","v":"OK"},{"$f":"IF(J3=\"NOK\",Ausgabe(),\"okay\")","v":"okay"}]
["Maintenance, service, cleaning and debugging work "]
["6.2","J","M/E","Do personnel have safe access to all of the areas required to perform their work safely? ","OK","BetrSichV Annex 1 / 2.15","INFO",null,null,{"$f":"E5","v":"OK"},{"$f":"IF(J5=\"NOK\",Ausgabe(),\"okay\")","v":"okay"}]
["6.3",null,"M/E","Can all work associated with maintenance, service, cleaning and debugging be carried out with the machine at a complete standstill, or can appropriate protective measures be implemented? ","OK","BetrSichV Annex 1 / 2.12","INFO",null,null,"OK",{"$f":"IF(J6=\"NOK\",Ausgabe(),\"okay\")","v":"okay"}]
["6.4",null,"M/E","Are protective measures implemented when work has to be performed under raised loads? ","OK",null,"INFO",null,null,"OK",{"$f":"IF(J7=\"NOK\",Ausgabe(),\"okay\")","v":"okay"}]
["6.5","J","M/E","Have protective measures been implemented against hazards associated with stored / residual energies? (e.g. pressure reservoirs, hydraulic accumulators, electrical capacitors, etc.)","OK",null,"INFO","in case there is noc short circuit device for a electric capacitor refer to the discharge time",null,"OK",{"$f":"IF(J8=\"NOK\",Ausgabe(),\"okay\")","v":"okay"}]
["6.6","N","M/E","Are venting, relieving and depressurizing facilities available that offer a safe means of releasing stored energies and are these facilities marked accordingly? ","OK",null,"see 6.5",null,null,"OK",{"$f":"IF(J9=\"NOK\",Ausgabe(),\"okay\")","v":"okay"}]
["6.7",null,"M/E","Are warning notices provided where it is not possible to release energy that is stored in certain systems? (e.g. work instruction, LOTO, on the machine and/or in the operating manual) ","OK",null,"see 6.5",null,null,"OK",{"$f":"IF(J10=\"NOK\",Ausgabe(),\"okay\")","v":"okay"}]
["6.8",null,"O/M/E","Have checking cycles, to be performed by specialized personnel, been defined for the installed guards and safety devices and are these carried out and documented? (e.g. for light curtains, emergency stop devices etc.)","OK",null,null,null,null,"OK",{"$f":"IF(J11=\"NOK\",Ausgabe(),\"okay\")","v":"okay"}]
["6.9",null,"O/M/E","Are there permits / release notes, which must be used when handing the machine over for maintenance and repair work? \n(this also include the return of the machine)","OK",null,null,null,null,"OK",{"$f":"IF(J12=\"NOK\",Ausgabe(),\"okay\")","v":"okay"}]
["Coordinated machines (Production lines)"]
["Production, loading and unloading"]
["6.10",null,null,"Interface check of the areas between the individual machines. \nDo machine operators have safe access to all of the working areas, which they must enter in order to perform their work safely?","OK",null,null,null,null,"OK",{"$f":"IF(J15=\"NOK\",Ausgabe(),\"okay\")","v":"okay"}]
["6.11",null,null,"Has a setup mode been established under safe operating conditions, e.g. running at a lower speed?","OK",null,null,null,null,"OK",{"$f":"IF(J16=\"NOK\",Ausgabe(),\"okay\")","v":"okay"}]
["Maintenance, service, cleaning and debugging work "]
["6.12",null,null,"Interface check of the areas between the individual machines. \nDo personnel have safe access to all of the working areas, which they must enter in order to perform their work safely?","OK",null,null,null,null,"OK",{"$f":"IF(J18=\"NOK\",Ausgabe(),\"okay\")","v":"okay"}]
["6.13",null,null,"Has a setup mode been established under safe operating conditions, e.g. running at a lower speed?","OK",null,null,null,null,"OK",{"$f":"IF(J19=\"NOK\",Ausgabe(),\"okay\")","v":"okay"}]
["6.14",null,null,"Can all work associated with maintenance, service, cleaning and debugging be performed with the machine being at a standstill?n?","OK",null,null,null,null,"OK",{"$f":"IF(J20=\"NOK\",Ausgabe(),\"okay\")","v":"okay"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"'6. Setting up Maintanace Serv.'!J17","v":0}]

{"sheet":"7. Risk ass. with electr. Energ","index":9,"n_rows":14,"n_cols":11,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["7","Rel.","Owner\nMech.\nElect.","Risks associated with electrical energy","Assess-ment\n[choise]","Regula-tion. / Norm","FAQ","Comments","Measures","Bewertung"]
["7.1","N","E","Does the machine and its control devices have electric shock protection? (cable insulation, operator control elements etc.) ","NOK","EN 60204 Section 6.2",null,null,null,{"$f":"E2","v":"NOK"},{"$f":"IF(J2=\"NOK\",Ausgabe(),\"okay\")","v":{"$error":"#NAME?"}}]
["7.2",null,"E","Adequate protection class for the housing. ","NOK","EN 60204 Section 6.2","INFO","IP-Rating \n- IEC/EN 60529 \n– NFPA 70   (National Electrical Code)\n– CEC (Canadian Electrical Code)\n– UL 50\n– CSA-C22.2 No. 94-M91 (2006)\n– NEMA 250 -20031)",null,{"$f":"E3","v":"NOK"},{"$f":"IF(J3=\"NOK\",Ausgabe(),\"okay\")","v":{"$error":"#NAME?"}}]
["7.3",null,"E","Protection by insulating live parts (e.g. cables) ","NOK","EN 60204 Section 6.2",null,null,null,"NOK",{"$f":"IF(J4=\"NOK\",Ausgabe(),\"okay\")","v":{"$error":"#NAME?"}}]
["7.4",null,"E","Protection by covering, providing adequate clearances or barriers. ","NOK","EN 60204 Section 6.2",null,null,null,"NOK",{"$f":"IF(J5=\"NOK\",Ausgabe(),\"okay\")","v":{"$error":"#NAME?"}}]
["7.5","J","O/E","Have measures been taken to ensure that only suitably qualified, authorized personnel have access to switchgear cabinets and control rooms? (keys; special tools)","OK","EN 60204 Section 6.2",null,null,null,"OK",{"$f":"IF(J6=\"NOK\",Ausgabe(),\"okay\")","v":"okay"}]
["7.6",null,"E","Does the machine and/or the electrical installation have protection against indirect contact with electric current in the event of an insulation fault?\n(e.g. protective circuit, correctly dimensioned protective conductor, protective equipotential bonding of the machine housing, insulation monitoring, equipotential bonding, etc.)","NOK","EN 60204 Section 6.3",null,null,null,"NOK",{"$f":"IF(J7=\"NOK\",Ausgabe(),\"okay\")","v":{"$error":"#NAME?"}}]
["7.7",null,"E","Are there conductive cable runs and cable channels connected to the protective circuit?","OK",null,null,null,null,"OK",{"$f":"IF(J8=\"NOK\",Ausgabe(),\"okay\")","v":"okay"}]
["7.8",null,"E","Have suitable threaded connections been used to install the cables?","OK",null,null,null,null,"OK",{"$f":"IF(J9=\"NOK\",Ausgabe(),\"okay\")","v":"okay"}]
["7.9",null,"E","Have cable been secured to withstand tensile forces? (strain relief)","OK",null,null,null,null,"OK",{"$f":"IF(J10=\"NOK\",Ausgabe(),\"okay\")","v":"okay"}]
["7.10","J","E","Are cable, housing etc are not damaged?","OK",null,null,"Visual inspection ",null,"OK",{"$f":"IF(J11=\"NOK\",Ausgabe(),\"okay\")","v":"okay"}]
["Coordinated machines (Production lines)"]
["Direct or indirect contact with electrical energy"]
["7.11",null,"E","Interface testing on the connections between the individual machines: Does the entire system have appropriate protective devices between the individual machines to prevent employees from coming into direct or indirect contact with electricity?","NOK",null,null,null,null,"NOK",{"$f":"IF(J14=\"NOK\",Ausgabe(),\"okay\")","v":{"$error":"#NAME?"}}]

{"sheet":"8. Ergonomie","index":10,"n_rows":19,"n_cols":11,"rows_kept":19,"cut":false,"hidden":true,"merged":[]}
["8","Rel.","Betreiber\nMech.\nElekt.","Ergonomie","Bewer-tung\n[Auswahl]","Richtl. / Norm","FAQ","Bemerkungen","Maßnahmen","Bewertung"]
["8.1",null,"B","Mindestgröße von Ganzkörperzugängen an Maschinenarbeitsplätzen. Erlauben die Durchgänge innerhalb der Maschine einen ungehinderten und sicheren Zugang zu den Arbeitsplätzen, um Maßnahmen, wie die Betätigung von Stellteilen, das Überwachen von Arbeitsabläufen und das Prüfen von Arbeitsergebnissen, ausführen zu können?","NR","DIN EN 547-1:2009",null,null,null,{"$f":"E2","v":"NR"},{"$f":"IF(J2=\"NIO\",Ausgabe(),\"okay\")","v":"okay"}]
["8.2","J","B/M","Mindestmaße von Zugangsöffnungen.Sind geeignete Zugangsöffnungen vorgesehen, um das Betätigen von Stellteilen, das Beobachten von Vorgängen sowie Reinigungs-, Rüst- und Wartungsarbeiten zu ermöglichen?","NR",null,null,null,"test",{"$f":"E3","v":"NR"},{"$f":"IF(J3=\"NIO\",Ausgabe(),\"okay\")","v":"okay"}]
["8.3","J","B","Arbeitshöhen bei stehender Körperhaltung Sind die Arbeitshöhen für Steharbeitsplätze, die mehr als 1h/Tag genutzt werden, so gewählt, dass sie den Maßen und Kraftanforderungen der Werkstücke entsprechen?","NR","DIN EN ISO 14 738: 2008",null,null,null,"NR",{"$f":"IF(J4=\"NIO\",Ausgabe(),\"okay\")","v":"okay"}]
["8.4",null,"B","Beinraummaße. Ist der Raumbedarf unter der Arbeitsfläche so bemessen, dass abhängig von der gewählten Arbeitshaltung „Stehen“ oder „Stehen mit Stehhilfe“ ein ausreichender Raum für die Beine verbleibt?","NR","DIN EN ISO 14 738:2008",null,null,null,"NR",{"$f":"IF(J5=\"NIO\",Ausgabe(),\"okay\")","v":"okay"}]
["8.5",null,"B","Greifraum und Arbeitsraum Können alle Handhabungen und Betätigungen innerhalb des zulässigen Greifraums ausgeführt\nwerden?","NR",null,null,null,"test","NR",{"$f":"IF(J6=\"NIO\",Ausgabe(),\"okay\")","v":"okay"}]
["8.6",null,"B","Sehraum Ist der Sehraum so gewählt, dass bei der Beobachtung der Tätigkeit oder des Prozesses ungünstige Körperhaltungen vermieden werden?","NR","DIN EN 1005-4:2009     DIN EN ISO 14 738:2008",null,null,null,"NR",{"$f":"IF(J7=\"NIO\",Ausgabe(),\"okay\")","v":"okay"}]
["8.7",null,"B","Vermeidung von extremen Körperhaltungen Werden hohe Bewegungsfrequenzen oder statische Haltungen in ungünstigen oder extremen Körperhaltungen vermieden?","NR","DIN EN 1005-4:2009",null,null,null,"NR",{"$f":"IF(J8=\"NIO\",Ausgabe(),\"okay\")","v":"okay"}]
["8.8","N","B","Kombinierte Sitz-/Steharbeitsplätze Erfüllt die maßliche Gestaltung der Maschine die Anforderungen an einen Steharbeitsplatz und bietet sie die Möglichkeit der Nutzung eines Stuhls mit erhöhter Sitzposition?","NR",null,null,null,null,"NR",{"$f":"IF(J9=\"NIO\",Ausgabe(),\"okay\")","v":"okay"}]
["8.9",null,"B","Sitzarbeitsplätze Verfügt der Sitzarbeitsplatz über genügend Raum für freie Körperbewegungen, insbesondere der Beine, Füße und Arme?","NR","DIN EN ISO 14 738:2008",null,null,null,"NR",{"$f":"IF(J10=\"NIO\",Ausgabe(),\"okay\")","v":"okay"}]
["8.10",null,"B","Sitze Falls die Maschine im Sitzen bedient werden soll und der Bedienplatz fester Bestandteil der Maschine ist, muß die Maschine mit einem Sitz ausgestattet sein.\nErfüllt der Sitz die Anforderungen an einen Arbeitsplatz für sitzende Arbeitshaltung?","NR","MRL 2006/42/EG, Anhang 1",null,null,"test","NR",{"$f":"IF(J11=\"NIO\",Ausgabe(),\"okay\")","v":"okay"}]
["8.11",null,"B","Manuelle Handhabung von Gegenständen (Werkstücke, Werkzeuge und Maschinenteile)      Sind beim Gebrauch der Maschine infolge manueller Handhabung von Lasten > 3 kg Risiken für den Bediener/Instandhalter verhindert?","NR","DIN EN 1005-2:2009",null,null,null,"NR",{"$f":"IF(J12=\"NIO\",Ausgabe(),\"okay\")","v":"okay"}]
["8.12","J","B","Aktionskräfte bei Maschinenbetätigung ist verhindert, dass die Häufigkeit, Dauer und Art der Kraftaufwendung an Einrichtungen der Maschine, Schutzeinrichtungen, Zubehör oder Werkzeugen zur Maschinenbedienung oder Instandsetzung ein gesundheitliches Risiko beim Benutzer darstellt?","NR",null,null,null,"test","NR",{"$f":"IF(J13=\"NIO\",Ausgabe(),\"okay\")","v":"okay"}]
["8.13",null,"B","Handgriffe/Eingriffe/Griffe Sind Gegenstände leicht und gefahrlos zu greifen und zu halten?","NR",null,null,null,null,"NR",{"$f":"IF(J14=\"NIO\",Ausgabe(),\"okay\")","v":"okay"}]
["8.14",null,"B","Kurzzyklische Tätigkeiten bei hohen Handhabungsfrequenzen  Können bei der Maschinenbedienung gelegentlich oder häufig (> 1 h/Tag) anfallende, kurzzyklische Tätigkeiten ausgeschlossen werden?","NR",null,null,null,null,"NR",{"$f":"IF(J15=\"NIO\",Ausgabe(),\"okay\")","v":"okay"}]
["8.15",null,"B","Beleuchtungsstärke, Lichtrichtung, Blendung sind die Arbeitsbereiche der Maschine ausreichend beleuchtet?","NR","DIN EN 1837:2009",null,null,null,"NR",{"$f":"IF(J16=\"NIO\",Ausgabe(),\"okay\")","v":"okay"}]
["8.16",null,"B/E","Beleuchtungseinrichtung und -installation erfüllt die in die Maschine integrierte Beleuchtungseinrichtung die Bedingungen des Arbeitsbereiches?","NR",null,null,null,null,"NR",{"$f":"IF(J17=\"NIO\",Ausgabe(),\"okay\")","v":"okay"}]
["8.17",null,"B","Beobachtung des Arbeitszyklus im Fertigungsprozess ist es möglich, den Arbeitszyklus im Fertigungsprozess vom Bedienungsplatz der Maschine aus zu beobachten?","NR","MRL 2006/42/EG, Anhang 1",null,null,null,"NR",{"$f":"IF(J18=\"NIO\",Ausgabe(),\"okay\")","v":"okay"}]
[null,{"$f":"COUNTIFS('8. Ergonomie'!$B$2:$B$18,\"J\")","v":3},null,null,null,null,null,null,null,null,{"$f":"IF(J19=\"NIO\",Ausgabe(),\"okay\")","v":"okay"}]

{"sheet":"FAQ","index":11,"n_rows":135,"n_cols":2,"rows_kept":135,"cut":false,"hidden":false,"merged":[]}
[]
["FAQ"]
[]
["Nr. ","Inhalt"]
["1.1","All machinery must be marked visibly, legibly and indelibly with the following minimum particulars:\n— the business name and full address of the manufacturer and, where applicable, his authorised representative,\n— designation of the machinery,\n— the CE Marking (see Annex III),\n— designation of series or type,\n— serial number, if any,\n— the year of construction, that is the year in which the manufacturing process is completed. \n"]
["1.2","All machinery must be accompanied by instructions in the official Community language or languages of the Member State in which it is placed on the market and/or put into service.\nThe instructions accompanying the machinery must be either ‘Original instructions’ or a ‘Translation of the original instructions’,  in which case the translation must be accompanied by the original instructions. "]
["1.3","k.A."]
["1.4","Each instruction manual must contain, where applicable, at least the following information:\n(a) the business name and full address of the manufacturer and of his authorised representative;\n(b) the designation of the machinery as marked on the machinery itself, except for the serial number (see section 1.7.3);\n(c) the EC declaration of conformity, or a document setting out the contents of the EC declaration of conformity, showing the particulars of the machinery, not necessarily including the serial number and the signature; "]
["1.5","(d) a general description of the machinery;\n(e) the drawings, diagrams, descriptions and explanations necessary for the use, maintenance and repair of the machinery and for checking its correct functioning; \n"]
["1.6","k.A."]
["1.7","k.A."]
["1.8","k.A."]
["1.9","(g) a description of the intended use of the machinery; \n"]
["1.10","(l) information about the residual risks that remain despite the inherent safe design measures, safeguarding and complementary protective measures adopted; \n"]
["1.11","The machine must be designed and built in such a way as to ensure that risks arising from airborne noise emissions are reduced to the maximum extent permitted by the current state of the art using the means of reducing noise that are available, particularly at the source.\n(u) the following information on airborne noise emissions:\n— the A-weighted emission sound pressure level at workstations, where this exceeds 70 dB(A); where this level does not exceed 70 dB(A), this fact must be indicated,\n— the peak C-weighted instantaneous sound pressure value at workstations, where this exceeds 63 Pa (130 dB in relation to 20 μPa);\n— the A-weighted sound power level emitted by the machinery, where the A-weighted emission sound pressure level at workstations exceeds 80 dB(A). \n"]
["1.12","(h) warnings concerning ways in which the machinery must not be used that experience has shown might occur;\n Where risks remain despite the inherent safe design measures, safeguarding and complementary protective measures adopted, the necessary warnings, including warning devices, must be provided. \n"]
["1.13","Provided by the owner "]
["1.14","Provided by the owner "]
["1.15","Provided by the owner "]
["1.16","k.A."]
["2.1","refer to 1.9"]
["2.2","Pay attention to the information given in the operating manual. "]
["2.3","Pay attention to the information given in the operating manual (technical data, circuit diagram). "]
["2.4","The employer shall take all measures to ensure that appropriate lighting is available when using the work equipment. ISO 60204 section 17.2.\ne.g.: traffic ways and general:  100 lx;    workplaces:  200 lx; control stations, maintenance: 300 lx; work requiring better visibility: 500 lx;\n"]
["2.5","Areas and points for working on, or repair and maintenance of, work equipment must be suitably lit in line with the operation to be carried out. \n"]
["2.6","Machinery and its components and fittings must be stable enough to avoid overturning, falling or uncontrolled movements during transportation, assembly, dismantling and any other action involving the machinery.\nIf the shape of the machinery itself or its intended installation does not offer sufficient stability, appropriate means of anchorage must be incorporated and indicated in the instructions. \n"]
["2.7","Visual inspection "]
["3.1","— Power-up prerequisites in the logic prevent activation of potentially hazardous movements. "]
["3.2","— Power-up prerequisites in the logic prevent activation of the machine. "]
["3.3","— e.g. an acknowledgement prompt prevents machine parameters (e.g. setpoint values) being changed inadvertently. "]
["3.4","— the machinery must not be prevented from stopping if the stop command has already been given "]
["3.5","— no moving part of the machinery or piece held by the machinery may fall or be ejected "]
["3.6","— automatic or manual stopping of the moving parts, whatever they may be, must be unimpeded "]
["3.7","Control devices must be clearly visible and identifiable, using pictograms where appropriate "]
["3.8","Control devices must be positioned in such a way as to be safely operated without hesitation or loss of time and without ambiguity "]
["3.9","Control devices must be located outside the danger zones, except where necessary for certain control devices such as an emergency stop or a teach pendant ;"]
["3.10","From each control position, the operator must be able to ensure that no-one is in the danger zones "]
["3.11","or the control system must be designed and constructed in such a way that starting is prevented while someone is in the danger zone. "]
["3.12","If neither of these possibilities is applicable, before the machinery starts, an acoustic and/or visual warning signal must be given. "]
["3.13","k.A."]
["3.14","k.A."]
["3.15","The exposed persons must have time to leave the danger zone or prevent the machinery starting up. "]
["3.16","Where there is more than one control position, the control system must be designed in such a way that the use of one of them precludes the use of the others, except for stop controls and emergency stops. \n"]
["3.17","k.A."]
["3.18","k.A."]
["3.19","k.A."]
["3.20","k.A."]
["3.21","Machinery must be fitted with a control device whereby the machinery can be brought safely to a complete stop. Each workstation must be fitted with a control device to stop some or all of the functions of the machinery, depending on the existing hazards, so that the machinery is rendered safe. Once the machinery or its hazardous functions have stopped, the energy supply to the actuators concerned must be cut off. \n"]
["3.22","k.A."]
["3.23","Machinery must be fitted with means to isolate it from all energy sources. Such isolators must be clearly identified. They must be capable of being locked if reconnection could endanger persons. Isolators must also be capable of being locked where an operator is unable, from any of the points to which he has access, to check that the energy is still cut off. \n"]
["3.24","k.A."]
["3.25"]
["3.26","k.A."]
["3.27","k.A."]
["3.28","Every machine must be fitted with one or more emergency stop devices, which offer a means of averting an actual or impending danger.\nThe following exceptions apply:\n— machinery in which an emergency stop device would not lessen the risk, either because it would not reduce the stopping time or because it would not enable the special measures required to deal with the risk to be taken, — portable hand-held and/or hand-guided machinery.\nThe emergency stop device must\n— have clearly identifiable, clearly visible and quickly accessible control devices,\n— stop the hazardous process as quickly as possible, without creating additional risks,\n— where necessary, trigger or permit the triggering of certain safeguard movements.\nOnce active operation of the emergency stop device has ceased following a stop command, that command must be sustained by engagement of the emergency stop device until that engagement is specifically overridden; it must not be possible to engage the device without triggering a stop command; it must be possible to disengage the device only by an appropriate operation, disengaging the device must not restart the machinery but only permit restarting.\nThe emergency stop function must be available and operational at all times, regardless of the operating mode.\nEmergency stop devices must be a back-up to other safeguarding measures and not a substitute for them. "]
["3.29","k.A."]
["3.30","k.A."]
["3.31","k.A."]
["3.32","k.A."]
["3.33","k.A."]
["3.34","k.A."]
["3.35","k.A."]
["3.36","k.A."]
["4.1","The various parts of machinery and their linkages must be able to withstand the stresses to which they are subject when used. Where a risk of rupture or disintegration remains despite the measures taken, the parts concerned must be mounted, positioned and/or guarded in such a way that any fragments will be contained, preventing hazardous situations. "]
["4.2","Both rigid and flexible pipes carrying fluids, particularly those under high pressure, must be able to withstand the foreseen internal and external stresses and must be firmly attached and/or protected to ensure that no risk is posed by a rupture. "]
["4.3","k.A."]
["4.4","Precautions must be taken to prevent risks from falling or ejected objects. When a part of the machinery has been stopped, any drift away from the stopping position, for whatever reason other than action on the control devices, must be prevented or must be such that it does not present a hazard. "]
["4.5","Insofar as their purpose allows, accessible parts of the machinery must have no sharp edges, no sharp angles and no rough surfaces likely to cause injury. "]
["4.6","The moving parts of machinery must be designed and constructed in such a way as to prevent risks of contact which could lead to accidents or must, where risks persist, be fitted with guards or protective devices.\nThe instructions and, where possible, a sign on the machinery shall identify these specific protective devices and how they are to be used. Guards or protective devices designed to protect against risks arising from moving parts must be selected on the basis of the type of risk. "]
["4.7","Visual inspection "]
["4.8","The durability of the materials used must be adequate for the nature of the working environment foreseen by the manufacturer or his authorised representative, in particular as regards the phenomena of fatigue, ageing, corrosion and abrasion. Where a risk of rupture or disintegration remains despite the measures taken, the parts concerned must be mounted, positioned and/or guarded in such a way that any fragments will be contained, preventing hazardous situations. "]
["4.9","If it is necessary to observe machine operation through the safety guard, materials with suitable properties must be selected, e.g. material of an appropriate color with holes of a suitable size for looking through must be chosen if perforated material or wire mesh is used. Visibility can be improved by using perforated material of a darker color than the area under observation. "]
["4.10","Guards and safety devices must be designed in such a way as to ensure that they do not produce any hazardous crushing points or traps in conjunction with other parts of the machine or other guards or safety devices (also refer to EN 349).       Guards and protective devices must:\n— not give rise to any additional hazard, "]
["4.11"," Guards and protective devices must:\n— not give rise to any additional hazard, \n— be securely held in place, "]
["4.12","— not be easy to by-pass or render non-operational, "]
["4.13","Purpose of the safety bolts: It must not be possible to disassemble guards or safety devices without using special, dedicated tools, fitting only to these safety bolts. \n"]
["4.14","Fixed guards must be fixed by systems that can be opened or removed only with tools.    Their fixing systems must remain attached to the guards or to the machinery when the guards are removed.      Where possible, guards must be incapable of remaining in place without their fixings. "]
["4.15","A: around   U: under   T: through   O: over\n"]
["4.16","k.A."]
["4.17","Interlocking movable guards must:\n— as far as possible remain attached to the machinery when open,\n— be designed and constructed in such a way that they can be adjusted only by means of an intentional action. "]
["4.18","Machines produced up to and including 12-2011 can still be assessed in accordance with EN 954 (control system category). EN ISO 13849, IEC 61508 or EN 62061 must be applied to machines built after this date. nterlocking movable guards must be designed in such a way that the absence or failure of one of their components prevents starting or stops the hazardous machinery functions. "]
["4.19","Where it is possible for an operator to reach the danger zone before the risk due to the hazardous machinery functions has ceased, movable guards must be associated with a guard locking device in addition to an interlocking device. "]
["4.20","Powered guards and safety devices may not cause any injury (e.g. caused by closing pressure, force, speed, sharp edges). If a guard is equipped with a protective device that causes the guard to open again automatically as soon as a person or object comes into contact with the guard, the force required to prevent the guard closing shall not amount to more than 150 N. The kinetic energy of the guard shall not amount to more than 10 J. If a protective device of this nature is not fitted, these values must be reduced to to 75 N and 4 J accordingly. \n"]
["4.21","The determined data must be documented in the manufacturer's operating manual as a minimum requirement. "]
["4.22","k.A."]
["4.23","k.A."]
["4.24","k.A."]
["4.25","k.A."]
["4.26","The monitoring system may only exclude the space actually occupied by the operator's body. Guards and safety devices must be provided for all other parts of the machine (front, side and rear)! "]
["4.27","Check the distances (e.g. using a hand, an arm and another part of the body or a tool, etc. for operator control) "]
["4.28","k.A."]
["4.29","k.A."]
["4.30","e.g. with an inspection sticker on the machine or in the documentation for the machine. "]
["5.1","Guards and safety devices must be provided for parts of equipment that are very hot or very cold to prevent personnel coming into contact with such parts or coming into dangerously close proximity to them. "]
["5.2","Steps must be taken to eliminate any risk of injury arising from contact with or proximity to machinery parts or materials at high or very low temperatures."]
["5.3","The necessary steps must also be taken to avoid or protect against the risk of hot or very cold material being ejected. "]
["5.4","Machinery must be designed and constructed in such a way that risks of inhalation, ingestion, contact with the skin, eyes and mucous membranes and penetration through the skin of hazardous materials and substances which it produces can be avoided.Where a hazard cannot be eliminated, the machinery must be so equipped that hazardous materials and substances can be contained, evacuated, precipitated by water spraying, filtered or treated by another equally effective method. \nWhere the process is not totally enclosed during normal operation of the machinery, the devices for containment and/or evacuation must be situated in such a way as to have the maximum effect. "]
["5.5","Parts of the machinery where persons are liable to move about or stand must be designed and constructed in such a way as to prevent persons slipping, tripping or falling on or off these parts."]
["5.6","Where appropriate, these parts must be fitted with handholds that are fixed relative to the user and that enable them to maintain their stability. "]
["6.1","Machinery must be so designed, constructed and equipped that the need for operator intervention is limited. If operator intervention cannot be avoided, it must be possible to carry it out easily and safely. "]
["6.2","A safe means of accessing all of the necessary areas must be provided to perform production, setting, repair and maintenance work on equipment.\nIt must be possible to be in these areas without being exposed to any danger. "]
["6.3","It must be possible to perform repair and maintenance work with the equipment at a standstill.\nIf this is not possible, it must be possible to implement appropriate safety measures to perform the work, or it must be possible to perform the repair and maintenance work outside the danger zone. "]
["6.4","If it is necessary to perform repair and maintenance work under raised loads or working equipment, it must be possible to secure them and prevent them falling by means of appropriate facilities. "]
["6.5","If energy may still be stored in systems with storage capacity when the equipment has been disconnected from all energy sources, facilities must be available that are capable of de-energizing such systems.\nThese facilities must be marked accordingly.\nIf it is not possible to de-energize a system completely, appropriate hazard warnings must be provided on the equipment. "]
["6.6","see 6.5"]
["6.7","see 6.5"]
["6.8","k.A."]
["6.9","k.A."]
["7.1","k.A."]
["7.2","IP-Klasse - IEC/EN 60529 oder\n  – NFPA 70 (National Electrical Code)\n  – CEC (Canadian Electrical Code)\n  – UL 50\n  – CSA-C22.2 No. 94-M91 (2006)\n  – NEMA 250 -20031)\n"]
["7.3","k.A."]
["7.4","k.A."]
["7.5","k.A."]
["7.6","k.A."]
["7.7","k.A."]
["7.8","k.A."]
["7.9","k.A."]
["7.10","k.A."]
["8.1","k.A."]
["8.2","k.A."]
["8.3","k.A."]
["8.4","k.A."]
["8.5","k.A."]
["8.6","k.A."]
["8.7","k.A."]
["8.8","k.A."]
["8.9","k.A."]
["8.10","k.A."]
["8.11","k.A."]
["8.12","k.A."]
["8.13","k.A."]
["8.14","k.A."]
["8.15","k.A."]
["8.16","k.A."]
["8.17","k.A."]

{"sheet":"D 02-044 PL","index":12,"n_rows":9,"n_cols":16,"rows_kept":9,"cut":false,"hidden":true,"merged":[[7,12,7,13],[3,1,3,4],[3,8,3,9],[5,1,5,4],[7,0,8,0],[7,1,8,1],[7,2,8,2],[7,3,7,6],[7,7,7,11]]}
["D 02-044 – Annex 2",null,null,null,null,null,null,null,null,null,null,null,"Version:  1",null,null,"INFO ZU PL"]
["Documentation Performance Level (PL)",null,null,null,null,null,null,null,null,null,null,null,"Valid from:  1st January 2017"]
[]
["Machine:",null,null,null,null,null,null,"Date:"]
[]
["Name / Signature:"]
[]
["Risk","Safety device\n(e.g. interlocked protective device, light curtain, etc.)","Operation mode","Risk Assessment\n(EN ISO 13849)",null,null,null,"Performance Level\nEstimation\n(EN ISO 13849)",null,null,null,null,"Remaining risk",null,"Measures"]
[null,null,null,"S\nSeverity","F\nFrequency","P \nPossibility of avoidance","PLr","Cat.","DC","MTTFD","PL","∑ PL/ achieved",null,"accepted\nyes / no"]