Spreadsheet: 87760d1287607915-kpi-worksheet-collating-and-adding-multiple-points-of-data-kpi_calculator_wip-mod
Sheet: Daily KPI's

Error? | Employee Name | Rcpts | Replen | Pick | Loading | Training | Unloading | Wrapping | Put Away | PART Case Picking | PART Wrapping | PART Loading | [NAME] | Supervisor Errors | [NAME] | Cleaners | [NAME] | Special Projects | Receipts Reception | Battery Attendant | FORMULA DEMO
FIX | ALEX MAY |  |  | 5.25 | 0.375 | 1 |  |  |  |  | 1 |  |  |  | 0.3749999999999999 |  |  |  |  |  | 1
FIX | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
FIX | [NAME] |  |  | 5.25 | 0.375 | 1 |  |  |  |  | 1 |  |  |  | 0.3749999999999999 |  |  |  |  |  | 1
FIX | CHRISTINA BOWDEN |  |  | 5.25 | 0.375 | 1 |  |  |  |  | 1 |  |  |  | 0.3749999999999999 |  |  |  |  |  | 0
FIX | [NAME] |  |  | 5.25 | 0.375 | 1 |  |  |  |  | 1 |  |  |  | 0.3749999999999999 |  |  |  |  |  | 0
FIX | CRYSTAL POWERS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
FIX | DARLENE BARTON |  |  | 5.25 | 0.375 | 1 |  |  |  |  | 1 |  |  |  | 0.3749999999999999 |  |  |  |  |  | 0.25
FIX | DOLORES MCLAUGHLIN |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
FIX | DON SHARPE |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
FIX | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
FIX | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
FIX | DWIGHT MONROE |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
FIX | ELSIE BARTON |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
FIX | ELSIE HAMILTON |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
FIX | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
FIX | ERICA HALL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
FIX | FRANCIS MCNAMARA |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
FIX | FRANKLIN VICK |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
FIX | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
FIX | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
FIX | GRETCHEN GOLDSTEIN |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
FIX | GRETCHEN HILL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
FIX | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
FIX | HARVEY UNDERWOOD |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
FIX | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
FIX | JASON CROSS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
FIX | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
FIX | JEROME JOHNSTON |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
FIX | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
FIX | JUDITH COOPER |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
FIX | JULIA DESAI |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
FIX | KAREN PUCKETT |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
FIX | KATHERINE BENDER |  |  | 5.25 | 0.375 | 1 |  |  |  |  | 1 |  |  |  | 0.3749999999999999 |  |  |  |  |  | 1
FIX | KRISTINA CHUNG |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
FIX | KRISTINE DOUGHERTY |  |  | 5.25 | 0.375 | 1 |  |  |  |  | 1 |  |  |  | 0.3749999999999999 |  |  |  |  |  | 1
FIX | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
FIX | LOUIS ROSENTHAL |  |  | 5.25 | 0.375 | 1 |  |  |  |  | 1 |  |  |  | 0.3749999999999999 |  |  |  |  |  | 1
FIX | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
FIX | MARCIA WALSH |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
FIX | MARIAN SOLOMON |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
FIX | MARION MOON |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
FIX | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
FIX | NEAL MIDDLETON |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
FIX | PAIGE CHEN |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
FIX | PATRICIA MANGUM |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
FIX | PATRICK SONG |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
FIX | PAUL WOODS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
FIX | PRISCILLA WILKERSON |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
FIX | SANDY RAYNOR |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
FIX | SHELLEY WEEKS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
FIX | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
FIX | SHIRLEY MERRITT |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
FIX | STEPHANIE HAWKINS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
FIX | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
FIX | WAYNE CONNOLLY |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
FIX | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
FIX | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  | KPI %'ge Calculator |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ALL new names MUST be added to the list below to appear on the dropdown box
 | NAME | SHIFT START | SHIFT FINISH | HRS | TASK | START | FINISH | HRS ON TASK | Task instance %'ge
 | DARLENE BARTON | 15:00:00 | 23:00:00 | 08:00:00 | ORDER RELEASER | 15:00:00 | 18:00:00 | 03:00:00 | 0.3749999999999999 |  |  |  |  |  |  |  |  |  |  |  | Tasks | Names
 | CHRISTINA BOWDEN | 15:00:00 | 23:00:00 | 08:00:00 | PART WRAPPING | 15:00:00 | 23:00:00 | 08:00:00 | 1 |  |  |  |  |  |  |  |  |  |  |  | BATTERY ATTENDANT | ALEX MAY
 | DARLENE BARTON | 15:00:00 | 23:00:00 | 08:00:00 | LOADING | 18:00:00 | 19:00:00 | 01:00:00 | 0.1249999999999999 |  |  |  |  |  |  |  |  |  |  |  | CLEANERS | [NAME]
 | LOUIS ROSENTHAL | 15:00:00 | 23:00:00 | 08:00:00 | PICK | 15:00:00 | 23:00:00 | 08:00:00 | 1 |  |  |  |  |  |  |  |  |  |  |  | PART CASE PICKING | [NAME]
 | ALEX MAY | 15:00:00 | 23:00:00 | 08:00:00 | PICK | 15:00:00 | 23:00:00 | 08:00:00 | 1 |  |  |  |  |  |  |  |  |  |  |  | PART LOADING | CHRISTINA BOWDEN
 | [NAME] | 15:00:00 | 23:00:00 | 08:00:00 | PICK | 15:00:00 | 23:00:00 | 08:00:00 | 1 |  |  |  |  |  |  |  |  |  |  |  | PART WRAPPING | [NAME]
 | KRISTINE DOUGHERTY | 15:00:00 | 23:00:00 | 08:00:00 | PICK | 15:00:00 | 23:00:00 | 08:00:00 | 1 |  |  |  |  |  |  |  |  |  |  |  | LOADING | CRYSTAL POWERS
 | KATHERINE BENDER | 15:00:00 | 23:00:00 | 08:00:00 | PICK | 15:00:00 | 23:00:00 | 08:00:00 | 1 |  |  |  |  |  |  |  |  |  |  |  | ORDER RELEASER | DARLENE BARTON
 | [NAME] | 15:00:00 | 23:00:00 | 08:00:00 | TRAINING | 15:00:00 | 23:00:00 | 08:00:00 | 1 |  |  |  |  |  |  |  |  |  |  |  | PICK | DOLORES MCLAUGHLIN
 | DARLENE BARTON | 15:00:00 | 23:00:00 | 08:00:00 | PICK | 19:00:00 | 21:00:00 | 02:00:00 | 0.2500000000000001 |  |  |  |  |  |  |  |  |  |  |  | PUT AWAY | DON SHARPE
 | DARLENE BARTON | 15:00:00 | 23:00:00 | 08:00:00 | LOADING | 21:00:00 | 23:00:00 | 02:00:00 | 0.2500000000000001 |  |  |  |  |  |  |  |  |  |  |  | RCPTS | [NAME]
 |  | 15:00:00 | 23:00:00 | 08:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | RECEIPTS RECEPTION | [NAME]
 |  | 15:00:00 | 23:00:00 | 08:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | REPLEN | DWIGHT MONROE
 |  | 15:00:00 | 23:00:00 | 08:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SICK LEAVE | ELSIE BARTON
 |  | 15:00:00 | 23:00:00 | 08:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SPECIAL PROJECTS | ELSIE HAMILTON
 |  | 15:00:00 | 23:00:00 | 08:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SUPERVISOR ERRORS | [NAME]
 |  | 15:00:00 | 23:00:00 | 08:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SYS DOWN | ERICA HALL
 |  | 15:00:00 | 23:00:00 | 08:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TRAINING | FRANCIS MCNAMARA
 |  | 15:00:00 | 23:00:00 | 08:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | UNLOADING | FRANKLIN VICK
 |  | 15:00:00 | 23:00:00 | 08:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WRAPPING | [NAME]
 |  | 15:00:00 | 23:00:00 | 08:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  | 15:00:00 | 23:00:00 | 08:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GRETCHEN GOLDSTEIN
 |  | 15:00:00 | 23:00:00 | 08:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GRETCHEN HILL
 |  | 15:00:00 | 23:00:00 | 08:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  | 15:00:00 | 23:00:00 | 08:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HARVEY UNDERWOOD
 |  | 15:00:00 | 23:00:00 | 08:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  | 15:00:00 | 23:00:00 | 08:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JASON CROSS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JEROME JOHNSTON
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JUDITH COOPER
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JULIA DESAI
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | KAREN PUCKETT
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | KATHERINE BENDER
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | KRISTINA CHUNG
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | KRISTINE DOUGHERTY
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LOUIS ROSENTHAL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MARCIA WALSH
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MARIAN SOLOMON
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MARION MOON
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NEAL MIDDLETON
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PAIGE CHEN
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PATRICIA MANGUM
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PATRICK SONG
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PAUL WOODS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PRISCILLA WILKERSON
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SANDY RAYNOR
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SHELLEY WEEKS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SHIRLEY MERRITT
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | STEPHANIE HAWKINS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WAYNE CONNOLLY
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]