Spreadsheet: 485791d1477068389-solving-a-slow-excel-file-which-uses-over-1gb-of-memory-planfile2016test-1
Sheet: Hourlist Contract

 |  |  |  |  | 2016-10-21 00:00:00 |  |  |  |  | KRA
 |  |  |  |  |  |  |  |  |  |  |  |  | Absence
Temp/ Contract | Name | Function | Week number | Date | Start | End | Break | Hoursworked | Hoursstilltobeclarifiedinplanfile | Paraafemployee | SupporttootherSIC | HoursSupporttootherSIC | +TVT | -TVT | Oudreschpverlof | Verlof | Ziek | EXcused | [NAME] | pick | pack | ship | shiftlead | superuser | INV | Returns | Vas | Inbound | Consolidation | Replen | Opleiding | Projects | Meetings | Heatseal | Comment1 | Comment2 | NoCompliant?
 | [NAME]'s | KRAPicking | 24 | 2016-10-21 00:00:00 |  | 0 |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 0
 |  | KRA Shiftlead | 42 | 2016-10-21 00:00:00 |  |  |  | 0 |  |  |  |  |  |  | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 0
 |  | KRA VAS | 42 | 2016-10-21 00:00:00 | 08:00:00 | 16:30:00 | 01:00:00 | 7.50000000000001 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 0
 |  | KRA Storing | 42 | 2016-10-21 00:00:00 | 06:00:00 | 14:30:00 | 01:00:00 | 7.50000000000001 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 0
 |  | KRA Orderplanning | 42 | 2016-10-21 00:00:00 | 08:00:00 | 16:30:00 | 01:00:00 | 7.50000000000001 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 0
 |  | KRA VAS | 42 | 2016-10-21 00:00:00 |  |  | 01:00:00 | 0 |  |  |  |  |  |  |  |  | X |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 0
 |  | KRA Inventory | 42 | 2016-10-21 00:00:00 | 08:00:00 | 16:30:00 | 01:00:00 | 7.50000000000001 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 0
 |  | KRA WEB | 42 | 2016-10-21 00:00:00 | 08:00:00 | 16:30:00 | 01:00:00 | 7.50000000000001 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 0
 |  | KRA VAS skilled | 42 | 2016-10-21 00:00:00 |  |  | 01:00:00 | 0 |  |  |  |  |  | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 0
 |  | KRA Inventory | 42 | 2016-10-21 00:00:00 | 06:00:00 | 14:30:00 | 01:00:00 | 7.50000000000001 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 0
 |  | KRA Orderplanning | 42 | 2016-10-21 00:00:00 | 07:30:00 | 16:00:00 | 01:00:00 | 7.50000000000001 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 0
 |  | KRA VAS skilled | 42 | 2016-10-21 00:00:00 |  |  | 01:00:00 | 0 |  |  |  |  |  |  |  | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 0
 |  | KRA Shipping | 42 | 2016-10-21 00:00:00 | 08:00:00 | 16:30:00 | 01:00:00 | 7.50000000000001 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 0
 |  | [NAME] | 42 | 2016-10-21 00:00:00 | 07:30:00 | 16:00:00 | 01:00:00 | 7.50000000000001 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 0
 |  | [NAME] | 42 | 2016-10-21 00:00:00 | 08:00:00 | 17:00:00 | 01:00:00 | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 0
 |  | [NAME] | 42 | 2016-10-21 00:00:00 | 06:00:00 | 14:30:00 | 01:00:00 | 7.50000000000001 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 0
 |  | KRA Shiftlead | 42 | 2016-10-21 00:00:00 | 05:30:00 | 14:30:00 | 01:00:00 | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 0
 |  | KRA Shiftlead | 42 | 2016-10-21 00:00:00 | 07:30:00 | 16:30:00 | 01:00:00 | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 0
 |  | [NAME] | 42 | 2016-10-21 00:00:00 | 06:00:00 | 14:30:00 | 01:00:00 | 7.50000000000001 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 0
 |  | KRA Inventory | 42 | 2016-10-21 00:00:00 | 08:00:00 | 16:30:00 | 01:00:00 | 7.50000000000001 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 0
 |  | KRA Superuser | 42 | 2016-10-21 00:00:00 | 06:00:00 | 14:30:00 | 01:00:00 | 7.50000000000001 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 0
 |  | KRA VAS | 42 | 2016-10-21 00:00:00 | 12:00:00 | 16:00:00 | 01:00:00 | 3.75000000000001 |  |  |  |  |  |  |  |  | X |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 0
 |  | KRA Shipping | 42 | 2016-10-21 00:00:00 | 08:30:00 | 17:00:00 | 01:00:00 | 7.49999999999998 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 0
Tempoteam |  |  | 39 | 2016-10-21 00:00:00 |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 0
 | Approval Supervisor : |  |  |  |  |  |  | Approval Manager :
 | ►►►
 | ►►► |  |  |  |  |  |  |  |  |  |  |  |  | BIJ OVERUREN MOET ER PER 3 GEWERKTE UREN 15 MINUTEN PAUZE INGEHOUDEN WORDEN
 | ►►► |  |  |  |  |  |  | MAXIMAAL 13 WERKUREN PER DAG (MAXIMAAL 60 PER WEEK)
 | ►►► |  |  |  |  |  |  | TUSSEN 2 SHIFTS MOETEN MINIMAAL 11 UREN RUSTTIJD ZITTEN