Spreadsheet: 583301d1532362065-data-across-mutiple-workbooks-help-sample-workbook
Sheet: Analysis

Machine Number | Production O/N | Fibre Type | Legacy Code | Expected hours SET UP | Actual Hours SET UP | [NAME] | HOUR [NAME] (£) | Actual Hours Production | Expected hours Production | HOUR Variance | [NAME] | HOUR [NAME] (£)2 | SET UP INVESTIGATION | Reason 1 | Time Taken | Reason 2 | Time Taken 2 | Reason 3 | Time Taken 3 | Shift Report Info
NA | 97M0002923 | CGL4818DYC00N | FCIM159 |  |  |  |  | 0 | 5.83332 |  | 20.8 |  |  | NA | 0 | NA | 0 | NA | 0 | NA
8 | 97L0005498 001 | FI01008N1 | FGE102 |  |  |  |  | 16.78666666666667 | 22.648912 |  | 20.8 |  |  | MAN STOP | 5.79 | ROLL CHANGE | 3.02 | MECHANIC | 0.78 | NA
NA | 97M0002922 | CGL4732DYC000 | FCIM159 |  |  |  |  | 0 | 6 |  | 20.8 |  |  | NA | 0 | NA | 0 | NA | 0 | NA
99 | 97M0003064 | GGL4940MPA00E | FGE670 |  |  |  |  | 5.58 | 11.935829 |  | 20.8 |  |  | NA | 0 | NA | 0 | NA | 0 | NA
99 | 97M0003027 | CGL4026DY8820 | FCIM253 |  |  |  |  | 2 | 9.591837 |  | 20.8 |  |  | NA | 0 | NA | 0 | NA | 0 | NA
9 | 97L0005198 001 | CI001232N1 | FCIM105 |  |  |  |  | 24.81083333333333 | 32.72724 |  | 20.8 |  |  | MAN STOP | 5.26 | ROLL CHANGE | 1.68 | CREEL | 1.51 | NA
7 | 97L0005555 001 | CI001108N1 | FCIM230 |  |  |  |  | 19.14444444444444 | 27.77775 |  | 20.8 |  |  | MAN STOP | 2.68 | LUNCH | 1.09 | ROLL CHANGE | 0.94 | NA
15 | 97L0005282 001 | FI01242N1 | FGE843 |  |  |  |  | 39.37333333333332 | 55.6362 |  | 20.8 |  |  | MAN STOP | 16.24 | ROLL CHANGE | 2.82 | CLEANING | 0.47 | NA
4 | 97L0005549 001 | FI01229N1 | FGE479 |  |  |  |  | 0 | 16.279937 |  | 20.8 |  |  | MECHANIC | 5.92 | MAN STOP | 5.56 | ROLL CHANGE | 2.02 | NA
NA | 97M0002754 | GGL4123DYA000 | FGE105 |  |  |  |  | 0 | 17.4 |  | 20.8 |  |  | NA | 0 | NA | 0 | NA | 0 | NA
88 | 97L0005602 001 | CGL7006EXD15N | FCIM358 |  |  |  |  | 0 | 18.386665 |  | 20.8 |  |  | MAN STOP | 22.22 | NA | 0 | NA | 0 | NA
88 | 97L0005626 001 | CGL7275EXC00J | FCIM487 |  |  |  |  | 0 | 19.956647 |  | 20.8 |  |  | NA | 0 | NA | 0 | NA | 0 | NA
4 | 97L0004630 001 | FI01229N1 | FGE479 |  |  |  |  | 70.9 | 91.076922 |  | 20.8 |  |  | MAN STOP | 22.67 | ROLL CHANGE | 5.77 | CLEANNING | 4.11 | NA
88 | 97L0005578 001 | CGL7004EXC000 | FCIM359 |  |  |  |  | 0 | 20.653299 |  | 20.8 |  |  | MAN STOP | 54.04 | NA | 0 | NA | 0 | NA
8 | 97L0005598 001 | FI01228N1 | XGE190 |  |  |  |  | 0 | 20.982082 |  | 20.8 |  |  | MAN STOP | 9.2 | ROLL CHANGE | 5.52 | MECHANIC | 0.57 | NA
2 | 97L0005624 001 | CGL7006EXD15N | FCIM358 |  |  |  |  | 0 | 26.266656 |  | 20.8 |  |  | NA | 0 | NA | 0 | NA | 0 | NA
88 | 97L0005507 001 | CXL7027EXC000PB | FCIM359 |  |  |  |  | 0 | 26.793312 |  | 20.8 |  |  | MAN STOP | 29.04 | LUNCH | 0.65 | NA | 0 | NA
1 | 97L0005529 001 | CI001108N1 | XCIM491 |  |  |  |  | 19.19833333333334 | 53.030226 |  | 20.8 |  |  | MAN STOP | 3.91 | ROLL CHANGE | 1.76 | CREEL | 0.51 | NA
15 | 97L0005283 001 | FI01242N1 | FGE843 |  |  |  |  | 40.9388888888889 | 75.1514 |  | 20.8 |  |  | MAN STOP | 13.41 | ROLL CHANGE | 0.89 | NA | 0 | NA
4 | 97L0005180 001 | GGL6799DYA00F | FGE158 |  |  |  |  | 0 | 57.037032 |  | 20.8 |  |  | MAN STOP | 39.15 | ROLL CHANGE | 9.5 | MECHANIC | 6.2 | NA
4 | 97L0004848 001 | FI01165N1 | FGE479 |  |  |  |  | 0 | 69.19658 |  | 20.8 |  |  | MAN STOP | 15.31 | ROLL CHANGE | 14.58 | ELECTRICAL | 4.89 | NA
99 | 97M0003065 | CGL4377BYC000 | FCIM312 |  |  |  |  | 1 | 2.403822 | -1.403822 | 20.8 | -29.1994976 | NA | 0 | NA | 0 |  |  | NA