Spreadsheet: 586659d1534509642-moving-my-dashboard-with-formulas-from-month-to-month-test-dashboard
Sheet: Dashbooard

 | MATERIAL VARIANCE OVERVIEW |  |  |  |  |  |  |  |  |  |  |  | PRODUCTION VARIANCE OVERVIEW
 | KG |  |  |  |  |  |  | £
 | TOP 3 MATERIAL VARIANCES (KG) |  |  |  |  |  |  | TOP 3 MATERIAL VARIANCES (£) |  |  |  |  | PRODUCTION
 | PRODUCTION O/N | MATERIAL | MC | REASON | VARIANCES (KG) |  |  | PRODUCTION O/N | MATERIAL | REASON | VARIANCES (£) |  | NUMBER OF ORDERS ENDED IN AUGUST | TOTAL HOUR [NAME] |  |  | PRODUCTION  BREAKDOWN | HOURS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | STYLE CHANGE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MANUAL STOP
 |  |  |  |  |  |  |  |  |  |  |  |  | ADHERENCE TO STANDARD ORDER QUANTITIES (TOTAL) |  |  |  | ELECTRICIAN
 | TOTAL WEIGHT OF TOP 3 VARIANCES (KG) |  |  |  |  |  |  | TOTAL COST OF TOP 3 VARIANCES |  |  |  |  | STANDARD ORDER QUANTITY (MTRS) |  |  |  | ROLL CHANGE
 |  |  |  |  |  |  |  |  |  |  |  |  | ACTUAL ORDER QUANTITY (MTRS) |  |  |  | LACK OF LABOUR (PLANNED)
 | CARBON MATERIAL FIGURES |  |  |  | [NAME] TYPE | MATERIAL [NAME] (KG) |  | [NAME] TYPE | MATERIAL [NAME] (£) |  |  |  | DIFFERENCE (MTRS) |  |  |  | LACK OF RAW MATERIAL
 | EXPECTED USAGE (KG) |  |  |  | RAW MATERIAL QUALITY |  |  | MACHINE |  |  |  |  | SOQ VS AOQ (INC 99 & 88 & 0) |  |  |  | MECHANIC CALLED
 | ACTUAL USAGE (KG) |  |  |  | OTHER - CONSUMPTION |  |  | WRONG STD |  |  |  |  | SOQ VS AOQ (EX 99 & 88 & 0) |  |  |  | LUNCH BREAK
 | VARAIANCE (KG) |  |  |  | TRIAL |  |  | OTHER - CONSUMPTION |  |  |  |  |  |  |  |  | CREEL CHANGE
 |  |  |  |  | MACHINE |  |  | OTHER - REWORK |  |  |  |  |  |  |  |  | CLEANING
 | GLASS MATERIAL FIGURES |  |  |  | OTHER - REWORK |  |  | RAW MATERIAL QUALITY |  |  |  |  | % OF ORDERS MEETING SOQ (INC 99,88,0) |  |  |  | ELEMENT CHANGE
 | EXPECTED USAGE (KG) |  |  |  | PEOPLE |  |  | TRIAL |  |  |  |  | % OF ORDERS MEETING SOQ (EX 99, 88,0) |  |  |  | LACK OF LABOUR (UNPLANNED)
 | ACTUAL USAGE (KG) |  |  |  | BATCH (SOQ) |  |  | PEOPLE |  |  |  |  |  |  |  |  | MAT / FLEECE CHANGE
 | VARAIANCE (KG) |  |  |  | OTHER - PLANNING |  |  | BATCH (SOQ) |  |  |  |  |  |  |  |  | FLEECE OR MAT CHANGE
 |  |  |  |  | OTHER |  |  | OTHER - PLANNING |  |  |  |  |  |  |  |  | BEAM CHANGE
 | TOTAL MATERIAL FIGURES |  |  |  | PAIR |  |  | SUBCONTRACT |  |  |  |  |  |  |  |  | ENGINEER ON SITE
 | EXPECTED USAGE (KG) |  |  |  | PROCESS |  |  | OTHER |  |  |  |  |  |  |  |  | LAYER 2 FAULT
 | ACTUAL USAGE (KG) |  |  |  | SUBCONTRACT |  |  | PAIR |  |  |  |  |  |  |  |  | LAYER 1 FAULT
 | VARAIANCE (KG) |  |  |  | WRONG STD |  |  | NA |  |  |  |  |  |  |  |  | ZERO FAULT
 |  |  |  |  | A.R.M (PPV) |  |  | PROCESS |  |  |  |  |  |  |  |  | SECOND CLASS ROLL
 |  |  |  |  | TOTAL |  |  | A.R.M (PPV) |  |  |  |  |  |  |  |  | LAYER 3 FAULT
 |  |  |  |  |  |  |  | TOTAL |  |  |  |  |  |  |  |  | START UP CHECKS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WEFT CHAIN
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | QUALITY CHECKS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CHOP FAULT
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NOT APPLICAPLE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TRIAL FABRIC
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ENGINEER ON SITE (NO MTRS COUNTED)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL