Spreadsheet: 148299d1333338122-conditional-formatting-window-basic-question-kyler_spreadsheet
Sheet: Product Design

 |  |  |  |  |  |  |  | Q3 2012 |  | Eng 1 | Eng 2 | Eng 3 | Eng 4 | Eng 5 | Eng 6 | Eng 7 | Eng 8 | Q4 2012 |  | Eng 1 | Eng 2 | Eng 3 | Eng 4 | Eng 5 | Eng 6 | Eng 7 | Eng 8 | Q1 2013 |  | B.King | D.Hamilton | P.Reich | K.Roggenkamp | C.Kruse | Design Engineer 1 | Intern 2 | Intern 3 | Q2 2013 |  | Eng 1 | Eng 2 | Eng 3 | Eng 4 | Eng 5 | Eng 6 | Eng 7 | Eng 8
 |  |  |  |  |  |  |  | Available hrs: |  |  |  |  |  |  |  |  |  | Available hrs: |  |  |  |  |  |  |  |  |  | Available hrs: |  |  |  |  |  |  |  |  |  | Available hrs:
 |  |  |  |  |  |  |  | Required hrs: |  |  |  |  |  |  |  |  |  | Required hrs: |  |  |  |  |  |  |  |  |  | Required hrs: |  |  |  |  |  |  |  |  |  | Required hrs:
 |  |  |  |  |  |  |  | Allocated hrs: |  |  |  |  |  |  |  |  |  | Allocated hrs: |  |  |  |  |  |  |  |  |  | Allocated hrs: |  |  |  |  |  |  |  |  |  | Allocated hrs:
 | OEM Project | Req'd Hours: | Qtr start: | Qtr end: | # [NAME]: | # Hours/Qtr | Assigned:  Total |  |  | 0.85 | 0.85 | 0.85 | 0.85 | 0 | 0 | 0 | 0 |  |  | 0.85 | 0.85 | 0.85 | 0.85 | 0.6 | 0.5 | 0 | 0 |  |  | 0.85 | 0.85 | 0.85 | 0.5 | 0.6 | 0.85 | 0.5 | 0.5 |  |  | 0.85 | 0.85 | 0.85 | 0.85 | 0.85 | 0.85 | 0.85 | 0.85
1 | Project 1 | 4250 | Q4 2012 | Q4 2013 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0.25 |  | 0.5 | 0 |  |  |  |  |  | 1 | 0.75
2 | Project 2 | 2000 | Q4 2012 | Q4 2013 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  | 1
3 | Project 3 | 2000 | Q2 2013 | Q4 2013
4 | Project 4 | 1000 | Q4 2012 | Q2 2013 |  |  |  |  |  |  |  |  | 0.25 |  |  |  |  |  |  |  |  |  | 0.5 |  |  |  |  |  |  |  |  |  | 0.75 |  |  | 1
5 | Project 5 | 1500 | Q1 2013 | Q4 2013 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  | 1
6 | Project 6 | 750 | Q3 2012 | Q3 2012 |  |  |  |  |  | 1 | 1 |  | 0.5
7 | Project 7 | 700 | Q3 2012 | Q4 2012 |  |  |  |  |  |  |  | 0.85 | 0.25 |  |  |  |  |  |  |  |  | 0.85
8 | Project 8 | 250 | Q3 2012 | Q4 2012 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.5 |  |  | 0.5
9 | Project 9 | 250 | Q4 2012 | Q4 2012
10 | Project 10 | 500 | Q4 2012 | Q2 2013 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.25 |  | 0 |  |  |  |  |  |  |  | 0.25 |  |  |  |  |  |  |  |  |  | 0.25
11 | Project 11 | 100 | Q4 2012 | Q4 2012 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 0.5
12 | Project 12 | 100 | Q3 2012 | Q3 2012
13 | Project 13 | 1000 | Q3 2013 | Q2 2014
14 | Project 14 | 1500 | Q3 2013 | Q2 2014
15 | Project 15 | 100 | Q3 2012 | Q4 2012 |  |  |  |  |  |  |  | 0.15 |  |  |  |  |  |  |  |  |  | 0.15
 |  |  |  |  |  |  |  |  |  | Workdays this QTR: |  |  |  | 64 |  |  |  |  |  | Workdays this QTR: |  |  |  | 65 |  |  |  |  |  | Workdays this QTR: |  |  |  | 65 |  |  |  |  |  | Workdays this QTR: |  |  |  | 65
 |  |  |  |  |  |  |  |  |  | Work Hours this QTR: |  |  |  |  |  |  |  |  |  | Work Hours this QTR: |  |  |  |  |  |  |  |  |  | Work Hours this QTR: |  |  |  |  |  |  |  |  |  | Work Hours this QTR:
 |  |  | INDEX | QTR | INDEX | START | END
 |  |  | 0 | Q1 2012 | 1 | 2011-07-01 00:00:00 | 2011-09-30 00:00:00
 |  |  |  | Q2 2012 | 2 | 2011-10-01 00:00:00 | 2011-12-31 00:00:00
 |  |  |  | Q3 2012 | 3 | 2012-01-01 00:00:00 | 2012-03-31 00:00:00
 |  |  |  | Q4 2012 | 4 | 2012-04-01 00:00:00 | 2012-06-30 00:00:00
 |  |  |  | Q1 2013 | 5 | 2012-07-01 00:00:00 | 2012-09-30 00:00:00
 |  |  |  | Q2 2013 | 6 | 2012-10-01 00:00:00 | 2012-12-31 00:00:00
 |  |  |  | Q3 2013 | 7 | 2013-01-01 00:00:00 | 2012-03-31 00:00:00
 |  |  |  | Q4 2013 | 8 | 2013-04-01 00:00:00 | 2012-06-30 00:00:00
 |  |  |  | Q1 2014 | 9 | 2013-07-01 00:00:00 | 2013-09-30 00:00:00
 |  |  | 9 | Q2 2014 | 10 | 2013-10-01 00:00:00 | 2013-12-31 00:00:00
 |  |  | 10 | Q3 2014 | 11 | 2014-01-01 00:00:00 | 2014-03-31 00:00:00
 |  |  | 11 | Q4 2014 | 12 | 2014-04-01 00:00:00 | 2014-06-30 00:00:00