Spreadsheet: 26564d1218723927-overall-design-problem-for-a-work-schedule-opi-schedule-test
Sheet: Data

 |  |  | Background, OPI's are inspections preformed by maintenance or employees, they have different frequencies and are assigned by different production lines
 |  |  | and to different foremen.  The OPI's are word files, we want a way to list them by week linked to the files so that we can edit/update the OPI's without
 |  |  | changing multiple copies (what they do now is copy the files into folders for each week, so there may be up to 52 copies, all done by hand)
 |  |  | This was my attempt, was trying different vlookups, matches etc, results on next sheet
 |  |  |  | These will be hyperlinked to word files
 |  |  | start date | OPI/PM | Line | [NAME] (in weeks) | User | Date1 | Date2 | Date3 | [NAME] | Date5 | Date6 | Date7 | Date8 | Date9 | Date10 | Date11 | Date12 | Date13 | Date14 | Date15 | [NAME] | Date17 | Date18 | Date19 | Date20 | Date21 | Date22 | Date23 | [NAME] | Date25 | Date26 | Date27 | Date28 | Date29 | Date30 | Date31 | Date32 | Date33 | Date34 | Date35 | Date36 | Date37 | [NAME] | Date39 | [NAME] | Date41 | Date42 | Date43 | [NAME] | Date45 | Date46 | Date47 | Date48 | Date49 | Date50 | Date51 | [NAME]
 |  |  | 2008-01-01 00:00:00 | Block Press OPI | Block Press | 12 | [NAME] | 2008-01-01 00:00:00 | 2008-03-25 00:00:00 | 2008-06-17 00:00:00 | 2008-09-09 00:00:00 | 2008-12-02 00:00:00 | 2009-02-24 00:00:00 | 2009-05-19 00:00:00 | 2009-08-11 00:00:00 | 2009-11-03 00:00:00 | 2010-01-26 00:00:00 | 2010-04-20 00:00:00 | 2010-07-13 00:00:00 | 2010-10-05 00:00:00 | 2010-12-28 00:00:00 | 2011-03-22 00:00:00 | 2011-06-14 00:00:00 | 2011-09-06 00:00:00 | 2011-11-29 00:00:00 | 2012-02-21 00:00:00 | 2012-05-15 00:00:00 | 2012-08-07 00:00:00 | 2012-10-30 00:00:00 | 2013-01-22 00:00:00 | 2013-04-16 00:00:00 | 2013-07-09 00:00:00 | 2013-10-01 00:00:00 | 2013-12-24 00:00:00 | 2014-03-18 00:00:00 | 2014-06-10 00:00:00 | 2014-09-02 00:00:00 | 2014-11-25 00:00:00 | 2015-02-17 00:00:00 | 2015-05-12 00:00:00 | 2015-08-04 00:00:00 | 2015-10-27 00:00:00 | 2016-01-19 00:00:00 | 2016-04-12 00:00:00 | 2016-07-05 00:00:00 | 2016-09-27 00:00:00 | 2016-12-20 00:00:00 | 2017-03-14 00:00:00 | 2017-06-06 00:00:00 | 2017-08-29 00:00:00 | 2017-11-21 00:00:00 | 2018-02-13 00:00:00 | 2018-05-08 00:00:00 | 2018-07-31 00:00:00 | 2018-10-23 00:00:00 | 2019-01-15 00:00:00 | 2019-04-09 00:00:00 | 2019-07-02 00:00:00 | 2019-09-24 00:00:00
 |  |  | 2008-01-08 00:00:00 | Canline TCP OPI | Canline | 4 | [NAME] | 2008-01-08 00:00:00 | 2008-02-05 00:00:00 | 2008-03-04 00:00:00 | 2008-04-01 00:00:00 | 2008-04-29 00:00:00 | 2008-05-27 00:00:00 | 2008-06-24 00:00:00 | 2008-07-22 00:00:00 | 2008-08-19 00:00:00 | 2008-09-16 00:00:00 | 2008-10-14 00:00:00 | 2008-11-11 00:00:00 | 2008-12-09 00:00:00 | 2009-01-06 00:00:00 | 2009-02-03 00:00:00 | 2009-03-03 00:00:00 | 2009-03-31 00:00:00 | 2009-04-28 00:00:00 | 2009-05-26 00:00:00 | 2009-06-23 00:00:00 | 2009-07-21 00:00:00 | 2009-08-18 00:00:00 | 2009-09-15 00:00:00 | 2009-10-13 00:00:00 | 2009-11-10 00:00:00 | 2009-12-08 00:00:00 | 2010-01-05 00:00:00 | 2010-02-02 00:00:00 | 2010-03-02 00:00:00 | 2010-03-30 00:00:00 | 2010-04-27 00:00:00 | 2010-05-25 00:00:00 | 2010-06-22 00:00:00 | 2010-07-20 00:00:00 | 2010-08-17 00:00:00 | 2010-09-14 00:00:00 | 2010-10-12 00:00:00 | 2010-11-09 00:00:00 | 2010-12-07 00:00:00 | 2011-01-04 00:00:00 | 2011-02-01 00:00:00 | 2011-03-01 00:00:00 | 2011-03-29 00:00:00 | 2011-04-26 00:00:00 | 2011-05-24 00:00:00 | 2011-06-21 00:00:00 | 2011-07-19 00:00:00 | 2011-08-16 00:00:00 | 2011-09-13 00:00:00 | 2011-10-11 00:00:00 | 2011-11-08 00:00:00 | 2011-12-06 00:00:00
 |  |  | 2008-01-16 00:00:00 | [NAME] shrinker OPI | [NAME] | 1 | [NAME] | 2008-01-16 00:00:00 | 2008-01-23 00:00:00 | 2008-01-30 00:00:00 | 2008-02-06 00:00:00 | 2008-02-13 00:00:00 | 2008-02-20 00:00:00 | 2008-02-27 00:00:00 | 2008-03-05 00:00:00 | 2008-03-12 00:00:00 | 2008-03-19 00:00:00 | 2008-03-26 00:00:00 | 2008-04-02 00:00:00 | 2008-04-09 00:00:00 | 2008-04-16 00:00:00 | 2008-04-23 00:00:00 | 2008-04-30 00:00:00 | 2008-05-07 00:00:00 | 2008-05-14 00:00:00 | 2008-05-21 00:00:00 | 2008-05-28 00:00:00 | 2008-06-04 00:00:00 | 2008-06-11 00:00:00 | 2008-06-18 00:00:00 | 2008-06-25 00:00:00 | 2008-07-02 00:00:00 | 2008-07-09 00:00:00 | 2008-07-16 00:00:00 | 2008-07-23 00:00:00 | 2008-07-30 00:00:00 | 2008-08-06 00:00:00 | 2008-08-13 00:00:00 | 2008-08-20 00:00:00 | 2008-08-27 00:00:00 | 2008-09-03 00:00:00 | 2008-09-10 00:00:00 | 2008-09-17 00:00:00 | 2008-09-24 00:00:00 | 2008-10-01 00:00:00 | 2008-10-08 00:00:00 | 2008-10-15 00:00:00 | 2008-10-22 00:00:00 | 2008-10-29 00:00:00 | 2008-11-05 00:00:00 | 2008-11-12 00:00:00 | 2008-11-19 00:00:00 | 2008-11-26 00:00:00 | 2008-12-03 00:00:00 | 2008-12-10 00:00:00 | 2008-12-17 00:00:00 | 2008-12-24 00:00:00 | 2008-12-31 00:00:00 | 2009-01-07 00:00:00
 |  |  | Lines | Users | Week Beginning
 |  |  | All | All | 2007-12-31 00:00:00
 |  |  | Block Press | [NAME] | 2008-01-07 00:00:00
 |  |  | Canline | [NAME] | 2008-01-14 00:00:00
 |  |  | [NAME] | [NAME] | 2008-01-21 00:00:00
 |  |  | Front Office |  | 2008-01-28 00:00:00
 |  |  |  |  | 2008-02-04 00:00:00
 |  |  |  |  | 2008-02-11 00:00:00
 |  |  |  |  | 2008-02-18 00:00:00
 |  |  |  |  | 2008-02-25 00:00:00
 |  |  |  |  | 2008-03-03 00:00:00
 |  |  |  |  | 2008-03-10 00:00:00
 |  |  |  |  | 2008-03-17 00:00:00
 |  |  |  |  | 2008-03-24 00:00:00
 |  |  |  |  | 2008-03-31 00:00:00
 |  |  |  |  | 2008-04-07 00:00:00
 |  |  |  |  | 2008-04-14 00:00:00
 |  |  |  |  | 2008-04-21 00:00:00
 |  |  |  |  | 2008-04-28 00:00:00
 |  |  |  |  | 2008-05-05 00:00:00
 |  |  |  |  | 2008-05-12 00:00:00
 |  |  |  |  | 2008-05-19 00:00:00
 |  |  |  |  | 2008-05-26 00:00:00
 |  |  |  |  | 2008-06-02 00:00:00
 |  |  |  |  | 2008-06-09 00:00:00
 |  |  |  |  | 2008-06-16 00:00:00
 |  |  |  |  | 2008-06-23 00:00:00
 |  |  |  |  | 2008-06-30 00:00:00
 |  |  |  |  | 2008-07-07 00:00:00
 |  |  |  |  | 2008-07-14 00:00:00
 |  |  |  |  | 2008-07-21 00:00:00
 |  |  |  |  | 2008-07-28 00:00:00
 |  |  |  |  | 2008-08-04 00:00:00
 |  |  |  |  | 2008-08-11 00:00:00
 |  |  |  |  | 2008-08-18 00:00:00
 |  |  |  |  | 2008-08-25 00:00:00
 |  |  |  |  | 2008-09-01 00:00:00
 |  |  |  |  | 2008-09-08 00:00:00
 |  |  |  |  | 2008-09-15 00:00:00
 |  |  |  |  | 2008-09-22 00:00:00
 |  |  |  |  | 2008-09-29 00:00:00
 |  |  |  |  | 2008-10-06 00:00:00
 |  |  |  |  | 2008-10-13 00:00:00
 |  |  |  |  | 2008-10-20 00:00:00
 |  |  |  |  | 2008-10-27 00:00:00
 |  |  |  |  | 2008-11-03 00:00:00
 |  |  |  |  | 2008-11-10 00:00:00
 |  |  |  |  | 2008-11-17 00:00:00
 |  |  |  |  | 2008-11-24 00:00:00
 |  |  |  |  | 2008-12-01 00:00:00
 |  |  |  |  | 2008-12-08 00:00:00
 |  |  |  |  | 2008-12-15 00:00:00
 |  |  |  |  | 2008-12-22 00:00:00
 |  |  |  |  | 2008-12-29 00:00:00
 |  |  |  |  | 2009-01-05 00:00:00
 |  |  |  |  | 2009-01-12 00:00:00
 |  |  |  |  | 2009-01-19 00:00:00
 |  |  |  |  | 2009-01-26 00:00:00
 |  |  |  |  | 2009-02-02 00:00:00
 |  |  |  |  | 2009-02-09 00:00:00
 |  |  |  |  | 2009-02-16 00:00:00
 |  |  |  |  | 2009-02-23 00:00:00
 |  |  |  |  | 2009-03-02 00:00:00
 |  |  |  |  | 2009-03-09 00:00:00
 |  |  |  |  | 2009-03-16 00:00:00
 |  |  |  |  | 2009-03-23 00:00:00
 |  |  |  |  | 2009-03-30 00:00:00