Spreadsheet: 798109d1664304439-formula-not-working-as-expected-what-am-i-doing-wrong-sample
Sheet: Sheet1

Machine | [NAME] |  | Chosen | Risk Reduction | Discipline | Control | Current Score | Residual Score | Budget | $/Risk Reduction | Selected Low Risk | 18
Machine | Mod impact, toe/foot crush/amp, between moving components and surrounding objects when accessing the rear of the machine |  | N |  | FS | OPT1: Repostion existing rear light curtain to >1500mm from hazard | 15 | 14
 |  |  | N |  | FS | OPT2: Replace existing rear light curtain with 14[NAME] resolution and position >300mm from hazard | 15 | 14
 |  |  | Y |  | M/FS | [NAME]: Replace rear light curtain with distance barriers and interlocked gate >1800mm high positioned <120mm from hazard | 15 | 14
 |  |  | Y |  | FS | Fit a safety reset with direct LOS of the area being reset for the rear light curtains/interlocked gate. Mirrors and CCTV camera/screen cannot be used for direct LOS for a safety reset. | 15 | 14
 | Mod impact, toe/foot crush/amp, between moving components and surrounding objects when accessing the infeed of the machine |  | N |  | FS | OPT1: Repostion existing infeed light curtain to >1500mm from hazard | 15 | 14
 |  |  | N |  | FS | OPT2: Replace existing infeed light curtain with 14[NAME] resolution and position >300mm from hazard | 15 | 14
 |  |  | Y |  | M/FS | OPT3: Replace infeed light curtain with distance barriers and interlocked gate >1800mm high positioned <120mm from hazard | 15 | 14
 |  |  | Y |  | FS | Fit a safety reset with direct LOS of the area being reset for the infeed light curtains/interlocked gate. Mirrors and CCTV camera/screen cannot be used for direct LOS for a safety reset. | 15 | 14
 | Mod impact, toe/foot crush/amp, between moving components and surrounding objects when accessing the front outfeed of the machine |  | N |  | FS | OPT1: Repostion existing outfeed light curtain to >1500mm from hazard | 18 | 14
 |  |  | Y |  | FS | OPT2: Replace existing outfeed light curtain with 14[NAME] resolution and position >300mm from hazard | 18 | 14
 |  |  | N |  | M/FS | [NAME]: Replace outfeed light curtain with distance barriers and interlocked gate >1800mm high positioned <120mm from hazard | 18 | 14
 |  |  | Y |  | FS | Fit barriers along the side of the operator station to prevent whole body entry through the railing | 18 | 14
 | Finger/hand amp/crush/broken in the bend and shear head or other moving components around the operator position |  | Y |  | M | Fit barriers 1400mm high with 1100[NAME] reach to bending and shearing hazards - Existing interlock can be used. | 18 | 14
 |  |  | Y |  | M |  | 18 | 14
 | Fatality due to fall from height >2.7m form carriage when unloading |  | Y |  | M | Fit railing along the front edge of the carriage | 19 | 16
 | Transmission hazard-Carriage |  | N |  | FS | OPT1: Repostion existing rear light curtain to >1500mm from hazard | 15 | 14
 |  |  | N |  | FS | OPT2: Replace existing rear light curtain with 14[NAME] resolution and position >300mm from hazard | 15 | 14
 |  |  | Y |  | M/FS | [NAME]: Replace rear light curtain with distance barriers and interlocked gate >1800mm high positioned <120mm from hazard | 15 | 14
 | Transmission hazard-GENIUS |  | N |  | FS | OPT1: Repostion existing infeed light curtain to >1500mm from hazard | 15 | 14
 |  |  | N |  | FS | OPT2: Replace existing infeed light curtain with 14[NAME] resolution and position >300mm from hazard | 15 | 14
 |  |  | Y |  | M/FS | OPT3: Replace infeed light curtain with distance barriers and interlocked gate >1800mm high positioned <120mm from hazard | 15 | 14
 | Transmission hazard - BarWiser |  |  |  |  |  | 7 | 7