Spreadsheet: 730040d1619516930-excel-keeps-calculating-no-idea-why-production-planning-excel-issue
Sheet: INFO

INFO
Reason codes waste and/or usage of # boards |  |  |  |  |  |  | Gradation |  | Saws |  |  |  |  |  | PRD people available per week |  | # people | # people | # people | # people | # people | Hours S2
Bad quality |  |  |  |  |  |  | Difficulty |  |  |  |  |  |  |  |  |  | Monday | Tuesday | Wednesday | Thursday | Friday
Bad quality other supplier |  |  |  |  |  |  | 1 = Very Easy |  | S2 |  |  |  |  |  | wk01 |  | 10 | 10 | 10 | 10 | 10
Production error |  |  |  |  |  |  | 2 = Easy |  | S3 |  |  |  |  |  | wk02 |  | 10 | 10 | 10 | 10 | 10
Damage transport |  |  |  |  |  |  | 3 = Average |  |  |  |  |  |  |  | wk03 |  | 10 | 10 | 10 | 10 | 10
Out of stock SKU |  |  |  |  |  |  | 4 = Difficult |  |  |  |  |  |  |  | wk04 |  | 10 | 10 | 10 | 10 | 10
Sales error - no SKU |  |  |  |  |  |  | 5 = Very Difficult |  |  |  |  |  |  |  | wk05 |  | 10 | 10 | 10 | 10 | 10
Optimalisation saw scheme |  |  |  |  |  |  |  |  |  |  |  |  |  |  | wk06 |  | 10 | 10 | 10 | 10 | 10
Damage HT |  |  |  |  |  |  | Indeling ploegen |  |  |  |  |  |  |  | wk07 |  | 10 | 10 | 10 | 10 | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | wk08 |  | 10 | 10 | 10 | 10 | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | wk09 |  | 10 | 10 | 10 | 10 | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | wk10 |  | 10 | 10 | 10 | 10 | 10
 |  |  |  |  |  |  | Ploeg 1 |  |  |  | Ploeg 2 |  |  |  | wk11 |  | 10 | 10 | 10 | 10 | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | wk12 |  | 10 | 10 | 10 | 10 | 10
Reason codes downtime |  |  |  |  |  |  |  |  |  |  |  |  |  |  | wk13 |  | 10 | 10 | 10 | 10 | 10
Boards B-quality (sorting out/delays) |  |  |  |  |  |  |  |  |  |  |  |  |  |  | wk14 |  | 10 | 10 | 10 | 10 | 10
Machine defect |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  | 10 | 10 | 10 | 10 | 10
Cleaning/Manintenance |  |  |  |  |  |  |  |  |  |  |  |  |  |  | wk16 |  | 10 | 10 | 10 | 10 | 10
Production error |  |  |  |  |  |  |  |  |  |  |  |  |  |  | wk17 |  | 10 | 10 | 10 | 10 | 10
Readjustment saw/tools/profile - change-over |  |  |  |  |  |  |  |  |  |  |  |  |  |  | wk18 |  | 10 | 10 | 10 | 10 | 10
Shredder defect |  |  |  |  |  |  |  |  |  |  |  |  |  |  | wk19 |  | 10 | 10 | 10 | 10 | 10
Waiting time packaging |  |  |  |  |  |  |  |  |  |  |  |  |  |  | wk20 |  | 10 | 10 | 10 | 10 | 10
Meeting/explanations |  |  |  |  |  |  |  |  |  |  |  |  |  |  | wk21 |  | 10 | 10 | 10 | 10 | 10
Training new team member |  |  |  |  |  |  |  |  |  |  |  |  |  |  | wk22 |  | 10 | 10 | 10 | 10 | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | wk23 |  | 10 | 10 | 10 | 10 | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | wk24 |  | 10 | 10 | 10 | 10 | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | wk25 |  | 10 | 10 | 10 | 10 | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | wk26 |  | 10 | 10 | 10 | 10 | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | wk27 |  | 10 | 10 | 10 | 10 | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | wk28 |  | 10 | 10 | 10 | 10 | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | wk29 |  | 10 | 10 | 10 | 10 | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | wk30 |  | 10 | 10 | 10 | 10 | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | wk31 |  | 10 | 10 | 10 | 10 | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | wk32 |  | 10 | 10 | 10 | 10 | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | wk33 |  | 10 | 10 | 10 | 10 | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | wk34 |  | 10 | 10 | 10 | 10 | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  | 10 | 10 | 10 | 10 | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | wk36 |  | 10 | 10 | 10 | 10 | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | wk37 |  | 10 | 10 | 10 | 10 | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | wk38 |  | 10 | 10 | 10 | 10 | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | wk39 |  | 10 | 10 | 10 | 10 | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | wk40 |  | 10 | 10 | 10 | 10 | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | wk41 |  | 10 | 10 | 10 | 10 | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | wk42 |  | 10 | 10 | 10 | 10 | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | wk43 |  | 10 | 10 | 10 | 10 | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  | 10 | 10 | 10 | 10 | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | wk45 |  | 10 | 10 | 10 | 10 | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | wk46 |  | 10 | 10 | 10 | 10 | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | wk47 |  | 10 | 10 | 10 | 10 | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | wk48 |  | 10 | 10 | 10 | 10 | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | wk49 |  | 10 | 10 | 10 | 10 | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | wk50 |  | 10 | 10 | 10 | 10 | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | wk51 |  | 10 | 10 | 10 | 10 | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | wk52 |  | 10 | 10 | 10 | 10 | 10