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

 | Planning
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Planned hours |  |  | Actual hours |  |  | Boards |  |  | Special remarks / transport |  | Downtime |  |  | Waste and/or <> usage of # boards |  |  | Planned vs actual |  |  | M2 boards |  |  | M2 boards/hour
Monday | Del.date | Prd.date | OC Berghoef | Client | Order client | Delivery place | Specials | Article number | Material description | Boards |  |  |  | Gradation | Cut to size |  | S1 | S2 | S3 | S1 | S2 | S3 | S1 | S2 | S3 |  |  | Time(hours) | S2/3 | Reason code | # | M2 | Reason code | S1 | S2 | S3 | S1 | S2 | S3 | S1 | S2 | S3
 |  |  |  |  |  |  |  |  |  | # | colli | Length | [NAME] | Difficulty | # | size | Plan | Plan | Plan | Actuals | Actuals | Actuals
2021-01-04 00:00:00
 |  |  |  |  |  |  |  | 150199 |  | 20
 |  |  |  |  |  |  |  | 150201 |  | 1000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Totals
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Planned hours |  |  | Actual hours |  |  | Boards |  |  | Special remarks / transport |  | Downtime |  |  | Waste and/or <> usage of # boards |  |  | Planned vs actual |  |  | M2 boards |  |  | M2 boards/hour
Tuesday | Del.date | Prd.date | OC Berghoef | Client | Order client | Delivery place | Specials | Article number | Material description | Boards |  |  |  | Gradation | Cut to size |  | S1 | S2 | S3 | S1 | S2 | S3 | S1 | S2 | S3 |  |  | Time(hours) | S2/3 | Reason code | # | M2 | Reason code | S1 | S2 | S3 | S1 | S2 | S3 | S1 | S2 | S3
 |  |  |  |  |  |  |  |  |  | # | colli | Length | [NAME] | Difficulty | aantal | [NAME] | Plan | Plan | Plan | Actuals | Actuals | Actuals
 |  |  |  |  |  |  |  | 150201 |  | 14
 |  |  |  |  |  |  |  | 150201 |  | 100
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Totals
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Planned hours |  |  | Actual hours |  |  | Boards |  |  | Special remarks / transport |  | Downtime |  |  | Waste and/or <> usage of # boards |  |  | Planned vs actual |  |  | M2 boards |  |  | M2 boards/hour
Wednesday | Del.date | Prd.date | OC Berghoef | Client | Order client | Delivery place | Specials | Article number | Material description | Boards |  |  |  | Gradation | Cut to size |  | S1 | S2 | S3 | S1 | S2 | S3 | S1 | S2 | S3 |  |  | Time(hours) | S2/3 | Reason code | # | M2 | Reason code | S1 | S2 | S3 | S1 | S2 | S3 | S1 | S2 | S3
 |  |  |  |  |  |  |  |  |  | # | colli | Length | [NAME] | Difficulty | aantal | [NAME] | Plan | Plan | Plan | Actuals | Actuals | Actuals
 |  |  |  |  |  |  |  | 150201 |  | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Totals
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Planned hours |  |  | Actual hours |  |  | Boards |  |  | Special remarks / transport |  | Downtime |  |  | Waste and/or <> usage of # boards |  |  | Planned vs actual |  |  | M2 boards |  |  | M2 boards/hour
Thursday | Del.date | Prd.date | OC Berghoef | Client | Order client | Delivery place | Specials | Article number | Material description | Boards |  |  |  | Gradation | Cut to size |  | S1 | S2 | S3 | S1 | S2 | S3 | S1 | S2 | S3 |  |  | Time(hours) | S2/3 | Reason code | # | M2 | Reason code | S1 | S2 | S3 | S1 | S2 | S3 | S1 | S2 | S3
 |  |  |  |  |  |  |  |  |  | # | colli | Length | [NAME] | Difficulty | aantal | [NAME] | Plan | Plan | Plan | Actuals | Actuals | Actuals
 |  |  |  |  |  |  |  | 150201 |  | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Totals
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Planned hours |  |  | Actual hours |  |  | Boards |  |  | Special remarks / transport |  | Downtime |  |  | Waste and/or <> usage of # boards |  |  | Planned vs actual |  |  | M2 boards |  |  | M2 boards/hour
Friday | Del.date | Prd.date | OC Berghoef | Client | Order client | Delivery place | Specials | Article number | Material description | Boards |  |  |  | Gradation | Cut to size |  | S1 | S2 | S3 | S1 | S2 | S3 | S1 | S2 | S3 |  |  | Time(hours) | S2/3 | Reason code | # | M2 | Reason code | S1 | S2 | S3 | S1 | S2 | S3 | S1 | S2 | S3
 |  |  |  |  |  |  |  |  |  | # | colli | Length | [NAME] | Difficulty | aantal | [NAME] | Plan | Plan | Plan | Actuals | Actuals | Actuals
 |  |  |  |  |  |  |  | 150201 |  | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Totals
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Planned hours |  |  | Actual hours |  |  | Boards |  |  | Special remarks / transport |  | Downtime |  |  | Waste and/or <> usage of # boards |  |  | Planned vs actual |  |  | M2 boards |  |  | M2 boards/hour
Call-off | Del.date | Prd.date | OC Berghoef | Client | Order client | Delivery place | Specials | Article number | Material description | Boards |  |  |  | Gradation | Cut to size |  | S1 | S2 | S3 | S1 | S2 | S3 | S1 | S2 | S3 |  |  | Time(hours) | S2/3 | Reason code | # | M2 | Reason code | S1 | S2 | S3 | S1 | S2 | S3 | S1 | S2 | S3
 |  |  |  |  |  |  |  |  |  | # | colli | Length | [NAME] | Difficulty | aantal | [NAME] | Plan | Plan | Plan | Actuals | Actuals | Actuals
 | NVT | NVT
 | NVT | NVT
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Totals
 |  |  |  |  |  |  |  |  | LSR |  |  |  |  | TOTAL | Available hours |  |  |  |  | Boards |  |  |  |  |  | Total productivity |  | Planned hours |  |  |  |  |  | [NAME] |  | M2/H |  | Boards/H
 |  |  |  |  |  |  |  | LSR |  |  |  |  |  |  | Planned hours |  |  |  |  |  |  |  |  |  |  |  |  | Actual hours
 | Raw material not available |  |  |  |  |  |  |  |  |  |  |  |  |  | Capacity (%) |  |  |  |  |  |  |  |  |  |  |  |  | (%)
 | Prd.order/sheets/Schnitt/Stickers ok
 | In production
 | Finished |  |  |  |  |  |  |  |  |  |  |  |  | SAW 1 | Available hours |  | 0 |  |  | Boards |  |  |  |  |  | Productivity SAW 2 |  | Planned hours |  |  |  |  |  | [NAME] |  | M2/H |  | Boards/H
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Planned hours |  |  |  |  |  |  |  |  |  |  |  |  | Actual hours
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Capacity (%) |  |  |  |  |  |  |  |  |  |  |  |  | (%)
 |  |  |  |  |  |  |  |  |  |  |  |  |  | SAW 2 | Available hours |  |  |  |  | Boards |  |  |  |  |  | Productivity SAW 3 |  | Planned hours |  |  |  |  |  | [NAME] |  | M2/H |  | Boards/H
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Planned hours |  |  |  |  |  |  |  |  |  |  |  |  | Actual hours
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Capacity (%) |  |  |  |  |  |  |  |  |  |  |  |  | (%)
 |  |  |  |  |  |  |  |  |  |  |  |  |  | SAW 3 | Available hours |  | 60 |  |  | Boards
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Planned hours
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Capacity (%)
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Call-off | Available hours |  | 4 |  |  | Boards |  |  |  |  |  | Gradation |  | 1 | 2 | 3 | 4 | 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Planned hours |  |  |  |  |  |  |  |  |  |  | # orders
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Capacity (%) |  |  |  |  |  |  |  |  |  |  | % of all orders
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | # boards
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Downtime % |  |  |  | Waste/ <> usage
 |  |  |  |  |  |  |  |  |  |  |  |  |  | % of all prd hours |  |  |  | # M2
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Hours downtime |  |  |  | # boards
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Downtime (H/saw) |  |  |  | S2 |  | S3 |  |  |  |  |  | Waste and/or <> usage of # boards |  |  |  |  | M2
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Total hours |  |  |  |  |  |  |  |  |  |  |  | Total M2