Gurus - Help!

[excelblackbelt]

***Admin I apologize if this is too long, but this was the shortest I could keep the Jenie without losing the main component of the question and formulas***

Hello,

I am having trouble having my February data extend on my calendar...I am not sure why it will not carry over as it did in 2010 to 2011...

Here is a screenshot....

Consolidated Calendar


<TABLE style="PADDING-RIGHT: 2pt; PADDING-LEFT: 2pt; FONT-SIZE: 10pt; FONT-FAMILY: Arial,Arial; BACKGROUND-COLOR: #ffffff" cellSpacing=0 cellPadding=0 border=1><COLGROUP><COL style="FONT-WEIGHT: bold; WIDTH: 30px"><COL style="WIDTH: 307px"><COL style="WIDTH: 72px"><COL style="WIDTH: 69px"><COL style="WIDTH: 65px"><COL style="WIDTH: 79px"><COL style="WIDTH: 18px"><COL style="WIDTH: 18px"><COL style="WIDTH: 18px"><COL style="WIDTH: 18px"><COL style="WIDTH: 18px"><COL style="WIDTH: 18px"><COL style="WIDTH: 18px"><COL style="WIDTH: 18px"><COL style="WIDTH: 18px"><COL style="WIDTH: 18px"><COL style="WIDTH: 18px"><COL style="WIDTH: 18px"><COL style="WIDTH: 18px"><COL style="WIDTH: 18px"><COL style="WIDTH: 18px"><COL style="WIDTH: 18px"><COL style="WIDTH: 18px"><COL style="WIDTH: 18px"><COL style="WIDTH: 18px"><COL style="WIDTH: 18px"><COL style="WIDTH: 18px"><COL style="WIDTH: 18px"><COL style="WIDTH: 18px"><COL style="WIDTH: 18px"><COL style="WIDTH: 18px"><COL style="WIDTH: 18px"><COL style="WIDTH: 18px"><COL style="WIDTH: 18px"><COL style="WIDTH: 18px"><COL style="WIDTH: 18px"><COL style="WIDTH: 18px"><COL style="WIDTH: 18px"><COL style="WIDTH: 18px"><COL style="WIDTH: 18px"><COL style="WIDTH: 18px"><COL style="WIDTH: 18px"><COL style="WIDTH: 18px"></COLGROUP><TBODY><TR style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center"><TD> </TD><TD>C</TD><TD>D</TD><TD>E</TD><TD>F</TD><TD>G</TD><TD>BC</TD><TD>BD</TD><TD>BE</TD><TD>BF</TD><TD>BG</TD><TD>BH</TD><TD>BI</TD><TD>BJ</TD><TD>BK</TD><TD>BL</TD><TD>BM</TD><TD>BN</TD><TD>BO</TD><TD>BP</TD><TD>BQ</TD><TD>BR</TD><TD>BS</TD><TD>BT</TD><TD>BU</TD><TD>BV</TD><TD>BW</TD><TD>BX</TD><TD>BY</TD><TD>BZ</TD><TD>CA</TD><TD>CB</TD><TD>CC</TD><TD>CD</TD><TD>CE</TD><TD>CF</TD><TD>CG</TD><TD>CH</TD><TD>CI</TD><TD>CJ</TD><TD>CK</TD><TD>CL</TD><TD>CM</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">3</TD><TD style="FONT-FAMILY: Constantia"> </TD><TD style="FONT-FAMILY: Constantia"> </TD><TD style="FONT-FAMILY: Constantia"> </TD><TD style="FONT-FAMILY: Constantia"> </TD><TD style="FONT-FAMILY: Constantia"> </TD><TD style="FONT-WEIGHT: bold; COLOR: #ffffff; FONT-FAMILY: Constantia; BACKGROUND-COLOR: #008000; TEXT-ALIGN: center" colSpan=12>Q3 - 2011</TD><TD style="FONT-WEIGHT: bold; COLOR: #ffffff; FONT-FAMILY: Constantia; BACKGROUND-COLOR: #008000; TEXT-ALIGN: center" colSpan=12>Q4 - 2011</TD><TD style="FONT-WEIGHT: bold; COLOR: #ffffff; FONT-FAMILY: Constantia; BACKGROUND-COLOR: #008000; TEXT-ALIGN: center" colSpan=12>Q1 - 2012</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">4</TD><TD style="FONT-FAMILY: Constantia"> </TD><TD style="FONT-FAMILY: Constantia"> </TD><TD style="FONT-FAMILY: Constantia"> </TD><TD style="FONT-FAMILY: Constantia"> </TD><TD style="FONT-FAMILY: Constantia"> </TD><TD style="FONT-WEIGHT: bold; COLOR: #ffffff; FONT-FAMILY: Constantia; BACKGROUND-COLOR: #008000; TEXT-ALIGN: center" colSpan=4>July</TD><TD style="FONT-WEIGHT: bold; COLOR: #ffffff; FONT-FAMILY: Constantia; BACKGROUND-COLOR: #008000; TEXT-ALIGN: center" colSpan=4>August</TD><TD style="FONT-WEIGHT: bold; COLOR: #ffffff; FONT-FAMILY: Constantia; BACKGROUND-COLOR: #008000; TEXT-ALIGN: center" colSpan=4>Sept</TD><TD style="FONT-WEIGHT: bold; COLOR: #ffffff; FONT-FAMILY: Constantia; BACKGROUND-COLOR: #008000; TEXT-ALIGN: center" colSpan=4>Oct</TD><TD style="FONT-WEIGHT: bold; COLOR: #ffffff; FONT-FAMILY: Constantia; BACKGROUND-COLOR: #008000; TEXT-ALIGN: center" colSpan=4>Nov</TD><TD style="FONT-WEIGHT: bold; COLOR: #ffffff; FONT-FAMILY: Constantia; BACKGROUND-COLOR: #008000; TEXT-ALIGN: center" colSpan=4>Dec</TD><TD style="FONT-WEIGHT: bold; COLOR: #ffffff; FONT-FAMILY: Constantia; BACKGROUND-COLOR: #008000; TEXT-ALIGN: center" colSpan=4>Jan</TD><TD style="FONT-WEIGHT: bold; COLOR: #ffffff; FONT-FAMILY: Constantia; BACKGROUND-COLOR: #008000; TEXT-ALIGN: center" colSpan=4>Feb</TD><TD style="FONT-WEIGHT: bold; COLOR: #ffffff; FONT-FAMILY: Constantia; BACKGROUND-COLOR: #008000; TEXT-ALIGN: center" colSpan=4>Mar</TD></TR><TR style="HEIGHT: 35px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">6</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: Constantia">Project Name</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: Constantia">Actual or Expected</TD><TD style="FONT-SIZE: 5pt; FONT-FAMILY: Constantia">Project Start Date</TD><TD style="FONT-SIZE: 5pt; FONT-FAMILY: Constantia">Expected Completion</TD><TD style="FONT-SIZE: 5pt; FONT-FAMILY: Constantia">Actual Completion Date</TD><TD style="FONT-WEIGHT: bold; COLOR: #ffffff; FONT-FAMILY: Constantia; BACKGROUND-COLOR: #008000; TEXT-ALIGN: center">4</TD><TD style="FONT-WEIGHT: bold; COLOR: #ffffff; FONT-FAMILY: Constantia; BACKGROUND-COLOR: #008000; TEXT-ALIGN: center">1</TD><TD style="FONT-WEIGHT: bold; COLOR: #ffffff; FONT-FAMILY: Constantia; BACKGROUND-COLOR: #008000; TEXT-ALIGN: center">2</TD><TD style="FONT-WEIGHT: bold; COLOR: #ffffff; FONT-FAMILY: Constantia; BACKGROUND-COLOR: #008000; TEXT-ALIGN: center">3</TD><TD style="FONT-WEIGHT: bold; COLOR: #ffffff; FONT-FAMILY: Constantia; BACKGROUND-COLOR: #008000; TEXT-ALIGN: center">4</TD><TD style="FONT-WEIGHT: bold; COLOR: #ffffff; FONT-FAMILY: Constantia; BACKGROUND-COLOR: #008000; TEXT-ALIGN: center">1</TD><TD style="FONT-WEIGHT: bold; COLOR: #ffffff; FONT-FAMILY: Constantia; BACKGROUND-COLOR: #008000; TEXT-ALIGN: center">2</TD><TD style="FONT-WEIGHT: bold; COLOR: #ffffff; FONT-FAMILY: Constantia; BACKGROUND-COLOR: #008000; TEXT-ALIGN: center">3</TD><TD style="FONT-WEIGHT: bold; COLOR: #ffffff; FONT-FAMILY: Constantia; BACKGROUND-COLOR: #008000; TEXT-ALIGN: center">4</TD><TD style="FONT-WEIGHT: bold; COLOR: #ffffff; FONT-FAMILY: Constantia; BACKGROUND-COLOR: #008000; TEXT-ALIGN: center">1</TD><TD style="FONT-WEIGHT: bold; COLOR: #ffffff; FONT-FAMILY: Constantia; BACKGROUND-COLOR: #008000; TEXT-ALIGN: center">2</TD><TD style="FONT-WEIGHT: bold; COLOR: #ffffff; FONT-FAMILY: Constantia; BACKGROUND-COLOR: #008000; TEXT-ALIGN: center">3</TD><TD style="FONT-WEIGHT: bold; COLOR: #ffffff; FONT-FAMILY: Constantia; BACKGROUND-COLOR: #008000; TEXT-ALIGN: center">4</TD><TD style="FONT-WEIGHT: bold; COLOR: #ffffff; FONT-FAMILY: Constantia; BACKGROUND-COLOR: #008000; TEXT-ALIGN: center">1</TD><TD style="FONT-WEIGHT: bold; COLOR: #ffffff; FONT-FAMILY: Constantia; BACKGROUND-COLOR: #008000; TEXT-ALIGN: center">2</TD><TD style="FONT-WEIGHT: bold; COLOR: #ffffff; FONT-FAMILY: Constantia; BACKGROUND-COLOR: #008000; TEXT-ALIGN: center">3</TD><TD style="FONT-WEIGHT: bold; COLOR: #ffffff; FONT-FAMILY: Constantia; BACKGROUND-COLOR: #008000; TEXT-ALIGN: center">4</TD><TD style="FONT-WEIGHT: bold; COLOR: #ffffff; FONT-FAMILY: Constantia; BACKGROUND-COLOR: #008000; TEXT-ALIGN: center">1</TD><TD style="FONT-WEIGHT: bold; COLOR: #ffffff; FONT-FAMILY: Constantia; BACKGROUND-COLOR: #008000; TEXT-ALIGN: center">2</TD><TD style="FONT-WEIGHT: bold; COLOR: #ffffff; FONT-FAMILY: Constantia; BACKGROUND-COLOR: #008000; TEXT-ALIGN: center">3</TD><TD style="FONT-WEIGHT: bold; COLOR: #ffffff; FONT-FAMILY: Constantia; BACKGROUND-COLOR: #008000; TEXT-ALIGN: center">4</TD><TD style="FONT-WEIGHT: bold; COLOR: #ffffff; FONT-FAMILY: Constantia; BACKGROUND-COLOR: #008000; TEXT-ALIGN: center">1</TD><TD style="FONT-WEIGHT: bold; COLOR: #ffffff; FONT-FAMILY: Constantia; BACKGROUND-COLOR: #008000; TEXT-ALIGN: center">2</TD><TD style="FONT-WEIGHT: bold; COLOR: #ffffff; FONT-FAMILY: Constantia; BACKGROUND-COLOR: #008000; TEXT-ALIGN: center">3</TD><TD style="FONT-WEIGHT: bold; COLOR: #ffffff; FONT-FAMILY: Constantia; BACKGROUND-COLOR: #008000; TEXT-ALIGN: center">4</TD><TD style="FONT-WEIGHT: bold; COLOR: #ffffff; FONT-FAMILY: Constantia; BACKGROUND-COLOR: #008000; TEXT-ALIGN: center">1</TD><TD style="FONT-WEIGHT: bold; COLOR: #ffffff; FONT-FAMILY: Constantia; BACKGROUND-COLOR: #008000; TEXT-ALIGN: center">2</TD><TD style="FONT-WEIGHT: bold; COLOR: #ffffff; FONT-FAMILY: Constantia; BACKGROUND-COLOR: #008000; TEXT-ALIGN: center">3</TD><TD style="FONT-WEIGHT: bold; COLOR: #ffffff; FONT-FAMILY: Constantia; BACKGROUND-COLOR: #008000; TEXT-ALIGN: center">4</TD><TD style="FONT-WEIGHT: bold; COLOR: #ffffff; FONT-FAMILY: Constantia; BACKGROUND-COLOR: #008000; TEXT-ALIGN: center">1</TD><TD style="FONT-WEIGHT: bold; COLOR: #ffffff; FONT-FAMILY: Constantia; BACKGROUND-COLOR: #008000; TEXT-ALIGN: center">2</TD><TD style="FONT-WEIGHT: bold; COLOR: #ffffff; FONT-FAMILY: Constantia; BACKGROUND-COLOR: #008000; TEXT-ALIGN: center">3</TD><TD style="FONT-WEIGHT: bold; COLOR: #ffffff; FONT-FAMILY: Constantia; BACKGROUND-COLOR: #008000; TEXT-ALIGN: center">4</TD><TD style="FONT-WEIGHT: bold; COLOR: #ffffff; FONT-FAMILY: Constantia; BACKGROUND-COLOR: #008000; TEXT-ALIGN: center">1</TD><TD style="FONT-WEIGHT: bold; COLOR: #ffffff; FONT-FAMILY: Constantia; BACKGROUND-COLOR: #008000; TEXT-ALIGN: center">2</TD><TD style="FONT-WEIGHT: bold; COLOR: #ffffff; FONT-FAMILY: Constantia; BACKGROUND-COLOR: #008000; TEXT-ALIGN: center">3</TD><TD style="FONT-WEIGHT: bold; COLOR: #ffffff; FONT-FAMILY: Constantia; BACKGROUND-COLOR: #008000; TEXT-ALIGN: center">4</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">7</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: Constantia">Shift Differential Program - Actual</TD><TD style="FONT-FAMILY: Constantia">Actual</TD><TD style="FONT-FAMILY: Constantia; TEXT-ALIGN: right">6/20/2011</TD><TD style="FONT-FAMILY: Constantia; TEXT-ALIGN: right">2/10/2012</TD><TD style="FONT-FAMILY: Constantia; TEXT-ALIGN: right">1/0/1900</TD><TD style="FONT-SIZE: 5pt; COLOR: #ff0000; FONT-FAMILY: Constantia; BACKGROUND-COLOR: #ff0000">X</TD><TD style="FONT-SIZE: 5pt; COLOR: #ff0000; FONT-FAMILY: Constantia; BACKGROUND-COLOR: #ff0000">X</TD><TD style="FONT-SIZE: 5pt; COLOR: #ffffff; FONT-FAMILY: Constantia; TEXT-ALIGN: right">0</TD><TD style="FONT-SIZE: 5pt; COLOR: #ffffff; FONT-FAMILY: Constantia; TEXT-ALIGN: right">0</TD><TD style="FONT-SIZE: 5pt; COLOR: #ffffff; FONT-FAMILY: Constantia; TEXT-ALIGN: right">0</TD><TD style="FONT-SIZE: 5pt; COLOR: #ffffff; FONT-FAMILY: Constantia; TEXT-ALIGN: right">0</TD><TD style="FONT-SIZE: 5pt; COLOR: #ffffff; FONT-FAMILY: Constantia; TEXT-ALIGN: right">0</TD><TD style="FONT-SIZE: 5pt; COLOR: #ffffff; FONT-FAMILY: Constantia; TEXT-ALIGN: right">0</TD><TD style="FONT-SIZE: 5pt; COLOR: #ffffff; FONT-FAMILY: Constantia; TEXT-ALIGN: right">0</TD><TD style="FONT-SIZE: 5pt; COLOR: #ffffff; FONT-FAMILY: Constantia; TEXT-ALIGN: right">0</TD><TD style="FONT-SIZE: 5pt; COLOR: #ffffff; FONT-FAMILY: Constantia; TEXT-ALIGN: right">0</TD><TD style="FONT-SIZE: 5pt; COLOR: #ffffff; FONT-FAMILY: Constantia; TEXT-ALIGN: right">0</TD><TD style="FONT-SIZE: 5pt; COLOR: #ffffff; FONT-FAMILY: Constantia; TEXT-ALIGN: right">0</TD><TD style="FONT-SIZE: 5pt; COLOR: #ffffff; FONT-FAMILY: Constantia; TEXT-ALIGN: right">0</TD><TD style="FONT-SIZE: 5pt; COLOR: #ffffff; FONT-FAMILY: Constantia; TEXT-ALIGN: right">0</TD><TD style="FONT-SIZE: 5pt; COLOR: #ffffff; FONT-FAMILY: Constantia; TEXT-ALIGN: right">0</TD><TD style="FONT-SIZE: 5pt; COLOR: #ffffff; FONT-FAMILY: Constantia; TEXT-ALIGN: right">0</TD><TD style="FONT-SIZE: 5pt; COLOR: #ffffff; FONT-FAMILY: Constantia; TEXT-ALIGN: right">0</TD><TD style="FONT-SIZE: 5pt; COLOR: #ffffff; FONT-FAMILY: Constantia; TEXT-ALIGN: right">0</TD><TD style="FONT-SIZE: 5pt; COLOR: #ffffff; FONT-FAMILY: Constantia; TEXT-ALIGN: right">0</TD><TD style="FONT-SIZE: 5pt; COLOR: #ffffff; FONT-FAMILY: Constantia; TEXT-ALIGN: right">0</TD><TD style="FONT-SIZE: 5pt; COLOR: #ffffff; FONT-FAMILY: Constantia; TEXT-ALIGN: right">0</TD><TD style="FONT-SIZE: 5pt; COLOR: #ffffff; FONT-FAMILY: Constantia; TEXT-ALIGN: right">0</TD><TD style="FONT-SIZE: 5pt; COLOR: #ffffff; FONT-FAMILY: Constantia; TEXT-ALIGN: right">0</TD><TD style="FONT-SIZE: 5pt; COLOR: #ffffff; FONT-FAMILY: Constantia; TEXT-ALIGN: right">0</TD><TD style="FONT-SIZE: 5pt; COLOR: #ffffff; FONT-FAMILY: Constantia; TEXT-ALIGN: right">0</TD><TD style="FONT-SIZE: 5pt; COLOR: #ffffff; FONT-FAMILY: Constantia; TEXT-ALIGN: right">0</TD><TD style="FONT-SIZE: 5pt; COLOR: #ffffff; FONT-FAMILY: Constantia; TEXT-ALIGN: right">0</TD><TD style="FONT-SIZE: 5pt; COLOR: #ffffff; FONT-FAMILY: Constantia; TEXT-ALIGN: right">0</TD><TD style="FONT-SIZE: 5pt; COLOR: #ffffff; FONT-FAMILY: Constantia; TEXT-ALIGN: right">0</TD><TD style="FONT-SIZE: 5pt; COLOR: #ffffff; FONT-FAMILY: Constantia; TEXT-ALIGN: right">0</TD><TD style="FONT-SIZE: 5pt; COLOR: #ffffff; FONT-FAMILY: Constantia; TEXT-ALIGN: right">0</TD><TD style="FONT-SIZE: 5pt; COLOR: #ffffff; FONT-FAMILY: Constantia; TEXT-ALIGN: right">0</TD><TD style="FONT-SIZE: 5pt; COLOR: #ffffff; FONT-FAMILY: Constantia; TEXT-ALIGN: right">0</TD><TD style="FONT-SIZE: 5pt; COLOR: #ffffff; FONT-FAMILY: Constantia; TEXT-ALIGN: right">0</TD><TD style="FONT-SIZE: 5pt; COLOR: #ffffff; FONT-FAMILY: Constantia; TEXT-ALIGN: right">0</TD><TD style="FONT-SIZE: 5pt; COLOR: #ffffff; FONT-FAMILY: Constantia; TEXT-ALIGN: right">0</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">8</TD><TD style="FONT-WEIGHT: bold; FONT-FAMILY: Constantia">Shift Differential Program - Expected</TD><TD style="FONT-FAMILY: Constantia">Expected</TD><TD style="FONT-FAMILY: Constantia; TEXT-ALIGN: right">6/20/2011</TD><TD style="FONT-FAMILY: Constantia; TEXT-ALIGN: right">2/10/2012</TD><TD style="FONT-FAMILY: Constantia; TEXT-ALIGN: right">1/0/1900</TD><TD style="FONT-SIZE: 5pt; COLOR: #0000ff; FONT-FAMILY: Constantia; BACKGROUND-COLOR: #0000ff">Y</TD><TD style="FONT-SIZE: 5pt; COLOR: #0000ff; FONT-FAMILY: Constantia; BACKGROUND-COLOR: #0000ff">Y</TD><TD style="FONT-SIZE: 5pt; COLOR: #0000ff; FONT-FAMILY: Constantia; BACKGROUND-COLOR: #0000ff">Y</TD><TD style="FONT-SIZE: 5pt; COLOR: #0000ff; FONT-FAMILY: Constantia; BACKGROUND-COLOR: #0000ff">Y</TD><TD style="FONT-SIZE: 5pt; COLOR: #0000ff; FONT-FAMILY: Constantia; BACKGROUND-COLOR: #0000ff">Y</TD><TD style="FONT-SIZE: 5pt; COLOR: #0000ff; FONT-FAMILY: Constantia; BACKGROUND-COLOR: #0000ff">Y</TD><TD style="FONT-SIZE: 5pt; COLOR: #0000ff; FONT-FAMILY: Constantia; BACKGROUND-COLOR: #0000ff">Y</TD><TD style="FONT-SIZE: 5pt; COLOR: #0000ff; FONT-FAMILY: Constantia; BACKGROUND-COLOR: #0000ff">Y</TD><TD style="FONT-SIZE: 5pt; COLOR: #0000ff; FONT-FAMILY: Constantia; BACKGROUND-COLOR: #0000ff">Y</TD><TD style="FONT-SIZE: 5pt; COLOR: #0000ff; FONT-FAMILY: Constantia; BACKGROUND-COLOR: #0000ff">Y</TD><TD style="FONT-SIZE: 5pt; COLOR: #0000ff; FONT-FAMILY: Constantia; BACKGROUND-COLOR: #0000ff">Y</TD><TD style="FONT-SIZE: 5pt; COLOR: #0000ff; FONT-FAMILY: Constantia; BACKGROUND-COLOR: #0000ff">Y</TD><TD style="FONT-SIZE: 5pt; COLOR: #0000ff; FONT-FAMILY: Constantia; BACKGROUND-COLOR: #0000ff">Y</TD><TD style="FONT-SIZE: 5pt; COLOR: #0000ff; FONT-FAMILY: Constantia; BACKGROUND-COLOR: #0000ff">Y</TD><TD style="FONT-SIZE: 5pt; COLOR: #0000ff; FONT-FAMILY: Constantia; BACKGROUND-COLOR: #0000ff">Y</TD><TD style="FONT-SIZE: 5pt; COLOR: #0000ff; FONT-FAMILY: Constantia; BACKGROUND-COLOR: #0000ff">Y</TD><TD style="FONT-SIZE: 5pt; COLOR: #0000ff; FONT-FAMILY: Constantia; BACKGROUND-COLOR: #0000ff">Y</TD><TD style="FONT-SIZE: 5pt; COLOR: #0000ff; FONT-FAMILY: Constantia; BACKGROUND-COLOR: #0000ff">Y</TD><TD style="FONT-SIZE: 5pt; COLOR: #0000ff; FONT-FAMILY: Constantia; BACKGROUND-COLOR: #0000ff">Y</TD><TD style="FONT-SIZE: 5pt; COLOR: #0000ff; FONT-FAMILY: Constantia; BACKGROUND-COLOR: #0000ff">Y</TD><TD style="FONT-SIZE: 5pt; COLOR: #0000ff; FONT-FAMILY: Constantia; BACKGROUND-COLOR: #0000ff">Y</TD><TD style="FONT-SIZE: 5pt; COLOR: #0000ff; FONT-FAMILY: Constantia; BACKGROUND-COLOR: #0000ff">Y</TD><TD style="FONT-SIZE: 5pt; COLOR: #0000ff; FONT-FAMILY: Constantia; BACKGROUND-COLOR: #0000ff">Y</TD><TD style="FONT-SIZE: 5pt; COLOR: #0000ff; FONT-FAMILY: Constantia; BACKGROUND-COLOR: #0000ff">Y</TD><TD style="FONT-SIZE: 5pt; COLOR: #0000ff; FONT-FAMILY: Constantia; BACKGROUND-COLOR: #0000ff">Y</TD><TD style="FONT-SIZE: 5pt; COLOR: #ffffff; FONT-FAMILY: Constantia; TEXT-ALIGN: right">0</TD><TD style="FONT-SIZE: 5pt; COLOR: #ffffff; FONT-FAMILY: Constantia; TEXT-ALIGN: right">0</TD><TD style="FONT-SIZE: 5pt; COLOR: #ffffff; FONT-FAMILY: Constantia; TEXT-ALIGN: right">0</TD><TD style="FONT-SIZE: 5pt; COLOR: #ffffff; FONT-FAMILY: Constantia; TEXT-ALIGN: right">0</TD><TD style="FONT-SIZE: 5pt; COLOR: #ffffff; FONT-FAMILY: Constantia; TEXT-ALIGN: right">0</TD><TD style="FONT-SIZE: 5pt; COLOR: #ffffff; FONT-FAMILY: Constantia; TEXT-ALIGN: right">0</TD><TD style="FONT-SIZE: 5pt; COLOR: #ffffff; FONT-FAMILY: Constantia; TEXT-ALIGN: right">0</TD><TD style="FONT-SIZE: 5pt; COLOR: #ffffff; FONT-FAMILY: Constantia; TEXT-ALIGN: right">0</TD><TD style="FONT-SIZE: 5pt; COLOR: #ffffff; FONT-FAMILY: Constantia; TEXT-ALIGN: right">0</TD><TD style="FONT-SIZE: 5pt; COLOR: #ffffff; FONT-FAMILY: Constantia; TEXT-ALIGN: right">0</TD><TD style="FONT-SIZE: 5pt; COLOR: #ffffff; FONT-FAMILY: Constantia; TEXT-ALIGN: right">0</TD><TD style="FONT-SIZE: 5pt; COLOR: #ffffff; FONT-FAMILY: Constantia; TEXT-ALIGN: right">0</TD></TR></TBODY></TABLE>


<TABLE style="FONT-SIZE: 10pt; BORDER-LEFT-COLOR: #00ff00; BORDER-BOTTOM-COLOR: #00ff00; COLOR: #000000; BORDER-TOP-STYLE: groove; BORDER-TOP-COLOR: #00ff00; FONT-FAMILY: Arial; BORDER-RIGHT-STYLE: groove; BORDER-LEFT-STYLE: groove; BACKGROUND-COLOR: #fffcf9; BORDER-RIGHT-COLOR: #00ff00; BORDER-BOTTOM-STYLE: groove"><TBODY><TR><TD>Spreadsheet Formulas</TD></TR><TR><TD><TABLE style="FONT-SIZE: 9pt; FONT-FAMILY: Arial" cellSpacing=0 cellPadding=2 border=1><TBODY><TR style="FONT-SIZE: 10pt; BACKGROUND-COLOR: #cacaca"><TD>Cell</TD><TD>Formula</TD></TR><TR><TD>C7</TD><TD>=IF(OR(ISBLANK(VLOOKUP(B7,'Comp Project Details'!$A:$E,5,FALSE)),ISERROR(B7)),"",IF(B7=B6,(VLOOKUP(B7,'Comp Project Details'!$A:$F,COLUMN('Comp Project Details'!E:E),FALSE)&" - Expected"),(VLOOKUP(B7,'Comp Project Details'!$A:$F,COLUMN('Comp Project Details'!E:E),FALSE)&" - Actual")))</TD></TR><TR><TD>D7</TD><TD>=IF(ISERROR($B7),"",IF($B6=$B7,"Expected","Actual"))</TD></TR><TR><TD>E7</TD><TD>=IF(ISNUMBER(VLOOKUP($B7,'Comp Project Details'!$A:$O,COLUMN('Comp Project Details'!M2),FALSE)),(VLOOKUP($B7,'Comp Project Details'!$A:$O,COLUMN('Comp Project Details'!M2),FALSE)),0)</TD></TR><TR><TD>F7</TD><TD>=IF(ISNUMBER(VLOOKUP($B7,'Comp Project Details'!$A:$O,COLUMN('Comp Project Details'!N2),FALSE)),(VLOOKUP($B7,'Comp Project Details'!$A:$O,COLUMN('Comp Project Details'!N2),FALSE)),0)</TD></TR><TR><TD>G7</TD><TD>=IF(ISNUMBER(VLOOKUP($B7,'Comp Project Details'!$A:$O,COLUMN('Comp Project Details'!O2),FALSE)),(VLOOKUP($B7,'Comp Project Details'!$A:$O,COLUMN('Comp Project Details'!O2),FALSE)),0)</TD></TR><TR><TD>BC7</TD><TD>=IF(OR(start=0,DAYS360(BC$5,start,1)>0),0,IF(AND((Actual=0),(TODAY()-BC$5>1)),"X",IF(AND(Actual>0,BC$5-Actual<0),"X",)))</TD></TR><TR><TD>BD7</TD><TD>=IF(OR(start=0,DAYS360(BD$5,start,1)>0),0,IF(AND((Actual=0),(TODAY()-BD$5>1)),"X",IF(AND(Actual>0,BD$5-Actual<0),"X",)))</TD></TR><TR><TD>BE7</TD><TD>=IF(OR(start=0,DAYS360(BE$5,start,1)>0),0,IF(AND((Actual=0),(TODAY()-BE$5>1)),"X",IF(AND(Actual>0,BE$5-Actual<0),"X",)))</TD></TR><TR><TD>BF7</TD><TD>=IF(OR(start=0,DAYS360(BF$5,start,1)>0),0,IF(AND((Actual=0),(TODAY()-BF$5>1)),"X",IF(AND(Actual>0,BF$5-Actual<0),"X",)))</TD></TR><TR><TD>BG7</TD><TD>=IF(OR(start=0,DAYS360(BG$5,start,1)>0),0,IF(AND((Actual=0),(TODAY()-BG$5>1)),"X",IF(AND(Actual>0,BG$5-Actual<0),"X",)))</TD></TR><TR><TD>BH7</TD><TD>=IF(OR(start=0,DAYS360(BH$5,start,1)>0),0,IF(AND((Actual=0),(TODAY()-BH$5>1)),"X",IF(AND(Actual>0,BH$5-Actual<0),"X",)))</TD></TR><TR><TD>BI7</TD><TD>=IF(OR(start=0,DAYS360(BI$5,start,1)>0),0,IF(AND((Actual=0),(TODAY()-BI$5>1)),"X",IF(AND(Actual>0,BI$5-Actual<0),"X",)))</TD></TR><TR><TD>BJ7</TD><TD>=IF(OR(start=0,DAYS360(BJ$5,start,1)>0),0,IF(AND((Actual=0),(TODAY()-BJ$5>1)),"X",IF(AND(Actual>0,BJ$5-Actual<0),"X",)))</TD></TR><TR><TD>BK7</TD><TD>=IF(OR(start=0,DAYS360(BK$5,start,1)>0),0,IF(AND((Actual=0),(TODAY()-BK$5>1)),"X",IF(AND(Actual>0,BK$5-Actual<0),"X",)))</TD></TR><TR><TD>BL7</TD><TD>=IF(OR(start=0,DAYS360(BL$5,start,1)>0),0,IF(AND((Actual=0),(TODAY()-BL$5>1)),"X",IF(AND(Actual>0,BL$5-Actual<0),"X",)))</TD></TR><TR><TD>BM7</TD><TD>=IF(OR(start=0,DAYS360(BM$5,start,1)>0),0,IF(AND((Actual=0),(TODAY()-BM$5>1)),"X",IF(AND(Actual>0,BM$5-Actual<0),"X",)))</TD></TR><TR><TD>BN7</TD><TD>=IF(OR(start=0,DAYS360(BN$5,start,1)>0),0,IF(AND((Actual=0),(TODAY()-BN$5>1)),"X",IF(AND(Actual>0,BN$5-Actual<0),"X",)))</TD></TR><TR><TD>BO7</TD><TD>=IF(OR(start=0,DAYS360(BO$5,start,1)>0),0,IF(AND((Actual=0),(TODAY()-BO$5>1)),"X",IF(AND(Actual>0,BO$5-Actual<0),"X",)))</TD></TR><TR><TD>BP7</TD><TD>=IF(OR(start=0,DAYS360(BP$5,start,1)>0),0,IF(AND((Actual=0),(TODAY()-BP$5>1)),"X",IF(AND(Actual>0,BP$5-Actual<0),"X",)))</TD></TR><TR><TD>BQ7</TD><TD>=IF(OR(start=0,DAYS360(BQ$5,start,1)>0),0,IF(AND((Actual=0),(TODAY()-BQ$5>1)),"X",IF(AND(Actual>0,BQ$5-Actual<0),"X",)))</TD></TR><TR><TD>BR7</TD><TD>=IF(OR(start=0,DAYS360(BR$5,start,1)>0),0,IF(AND((Actual=0),(TODAY()-BR$5>1)),"X",IF(AND(Actual>0,BR$5-Actual<0),"X",)))</TD></TR><TR><TD>BS7</TD><TD>=IF(OR(start=0,DAYS360(BS$5,start,1)>0),0,IF(AND((Actual=0),(TODAY()-BS$5>1)),"X",IF(AND(Actual>0,BS$5-Actual<0),"X",)))</TD></TR><TR><TD>BT7</TD><TD>=IF(OR(start=0,DAYS360(BT$5,start,1)>0),0,IF(AND((Actual=0),(TODAY()-BT$5>1)),"X",IF(AND(Actual>0,BT$5-Actual<0),"X",)))</TD></TR><TR><TD>BU7</TD><TD>=IF(OR(start=0,DAYS360(BU$5,start,1)>0),0,IF(AND((Actual=0),(TODAY()-BU$5>1)),"X",IF(AND(Actual>0,BU$5-Actual<0),"X",)))</TD></TR><TR><TD>BV7</TD><TD>=IF(OR(start=0,DAYS360(BV$5,start,1)>0),0,IF(AND((Actual=0),(TODAY()-BV$5>1)),"X",IF(AND(Actual>0,BV$5-Actual<0),"X",)))</TD></TR><TR><TD>BW7</TD><TD>=IF(OR(start=0,DAYS360(BW$5,start,1)>0),0,IF(AND((Actual=0),(TODAY()-BW$5>1)),"X",IF(AND(Actual>0,BW$5-Actual<0),"X",)))</TD></TR><TR><TD>BX7</TD><TD>=IF(OR(start=0,DAYS360(BX$5,start,1)>0),0,IF(AND((Actual=0),(TODAY()-BX$5>1)),"X",IF(AND(Actual>0,BX$5-Actual<0),"X",)))</TD></TR><TR><TD>BY7</TD><TD>=IF(OR(start=0,DAYS360(BY$5,start,1)>0),0,IF(AND((Actual=0),(TODAY()-BY$5>1)),"X",IF(AND(Actual>0,BY$5-Actual<0),"X",)))</TD></TR><TR><TD>BZ7</TD><TD>=IF(OR(start=0,DAYS360(BZ$5,start,1)>0),0,IF(AND((Actual=0),(TODAY()-BZ$5>1)),"X",IF(AND(Actual>0,BZ$5-Actual<0),"X",)))</TD></TR><TR><TD>CA7</TD><TD>=IF(OR(start=0,DAYS360(CA$5,start,1)>0),0,IF(AND((Actual=0),(TODAY()-CA$5>1)),"X",IF(AND(Actual>0,CA$5-Actual<0),"X",)))</TD></TR><TR><TD>CB7</TD><TD>=IF(OR(start=0,DAYS360(CB$5,start,1)>0),0,IF(AND((Actual=0),(TODAY()-CB$5>1)),"X",IF(AND(Actual>0,CB$5-Actual<0),"X",)))</TD></TR><TR><TD>CC7</TD><TD>=IF(OR(start=0,DAYS360(CC$5,start,1)>0),0,IF(AND((Actual=0),(TODAY()-CC$5>1)),"X",IF(AND(Actual>0,CC$5-Actual<0),"X",)))</TD></TR><TR><TD>CD7</TD><TD>=IF(OR(start=0,DAYS360(CD$5,start,1)>0),0,IF(AND((Actual=0),(TODAY()-CD$5>1)),"X",IF(AND(Actual>0,CD$5-Actual<0),"X",)))</TD></TR><TR><TD>CE7</TD><TD>=IF(OR(start=0,DAYS360(CE$5,start,1)>0),0,IF(AND((Actual=0),(TODAY()-CE$5>1)),"X",IF(AND(Actual>0,CE$5-Actual<0),"X",)))</TD></TR><TR><TD>CF7</TD><TD>=IF(OR(start=0,DAYS360(CF$5,start,1)>0),0,IF(AND((Actual=0),(TODAY()-CF$5>1)),"X",IF(AND(Actual>0,CF$5-Actual<0),"X",)))</TD></TR><TR><TD>CG7</TD><TD>=IF(OR(start=0,DAYS360(CG$5,start,1)>0),0,IF(AND((Actual=0),(TODAY()-CG$5>1)),"X",IF(AND(Actual>0,CG$5-Actual<0),"X",)))</TD></TR><TR><TD>CH7</TD><TD>=IF(OR(start=0,DAYS360(CH$5,start,1)>0),0,IF(AND((Actual=0),(TODAY()-CH$5>1)),"X",IF(AND(Actual>0,CH$5-Actual<0),"X",)))</TD></TR><TR><TD>CI7</TD><TD>=IF(OR(start=0,DAYS360(CI$5,start,1)>0),0,IF(AND((Actual=0),(TODAY()-CI$5>1)),"X",IF(AND(Actual>0,CI$5-Actual<0),"X",)))</TD></TR><TR><TD>CJ7</TD><TD>=IF(OR(start=0,DAYS360(CJ$5,start,1)>0),0,IF(AND((Actual=0),(TODAY()-CJ$5>1)),"X",IF(AND(Actual>0,CJ$5-Actual<0),"X",)))</TD></TR><TR><TD>CK7</TD><TD>=IF(OR(start=0,DAYS360(CK$5,start,1)>0),0,IF(AND((Actual=0),(TODAY()-CK$5>1)),"X",IF(AND(Actual>0,CK$5-Actual<0),"X",)))</TD></TR><TR><TD>CL7</TD><TD>=IF(OR(start=0,DAYS360(CL$5,start,1)>0),0,IF(AND((Actual=0),(TODAY()-CL$5>1)),"X",IF(AND(Actual>0,CL$5-Actual<0),"X",)))</TD></TR><TR><TD>CM7</TD><TD>=IF(OR(start=0,DAYS360(CM$5,start,1)>0),0,IF(AND((Actual=0),(TODAY()-CM$5>1)),"X",IF(AND(Actual>0,CM$5-Actual<0),"X",)))</TD></TR><TR><TD>C8</TD><TD>=IF(OR(ISBLANK(VLOOKUP(B8,'Comp Project Details'!$A:$E,5,FALSE)),ISERROR(B8)),"",IF(B8=B7,(VLOOKUP(B8,'Comp Project Details'!$A:$F,COLUMN('Comp Project Details'!E:E),FALSE)&" - Expected"),(VLOOKUP(B8,'Comp Project Details'!$A:$F,COLUMN('Comp Project Details'!E:E),FALSE)&" - Actual")))</TD></TR><TR><TD>D8</TD><TD>=IF(ISERROR($B8),"",IF($B7=$B8,"Expected","Actual"))</TD></TR><TR><TD>E8</TD><TD>=IF(ISNUMBER(VLOOKUP($B8,'Comp Project Details'!$A:$O,COLUMN('Completed Projects'!M1),FALSE)),(VLOOKUP($B8,'Comp Project Details'!$A:$O,COLUMN('Completed Projects'!M1),FALSE)),0)</TD></TR><TR><TD>F8</TD><TD>=IF(ISNUMBER(VLOOKUP($B8,'Comp Project Details'!$A:$O,COLUMN('Completed Projects'!N1),FALSE)),(VLOOKUP($B8,'Comp Project Details'!$A:$O,COLUMN('Completed Projects'!N1),FALSE)),0)</TD></TR><TR><TD>G8</TD><TD>=IF(ISNUMBER(VLOOKUP($B8,'Comp Project Details'!$A:$O,COLUMN('Completed Projects'!O1),FALSE)),(VLOOKUP($B8,'Comp Project Details'!$A:$O,COLUMN('Completed Projects'!O1),FALSE)),0)</TD></TR><TR><TD>BC8</TD><TD>=IF(OR(start=0,DAYS360(BC$5,start,1)>0),0,IF(AND((start-BC$5)>1,(start-BC$5)<7),"Y",IF((Expected-BC$5)>0,"Y",0)))</TD></TR><TR><TD>BD8</TD><TD>=IF(OR(start=0,DAYS360(BD$5,start,1)>0),0,IF(AND((start-BD$5)>1,(start-BD$5)<7),"Y",IF((Expected-BD$5)>0,"Y",0)))</TD></TR><TR><TD>BE8</TD><TD>=IF(OR(start=0,DAYS360(BE$5,start,1)>0),0,IF(AND((start-BE$5)>1,(start-BE$5)<7),"Y",IF((Expected-BE$5)>0,"Y",0)))</TD></TR><TR><TD>BF8</TD><TD>=IF(OR(start=0,DAYS360(BF$5,start,1)>0),0,IF(AND((start-BF$5)>1,(start-BF$5)<7),"Y",IF((Expected-BF$5)>0,"Y",0)))</TD></TR><TR><TD>BG8</TD><TD>=IF(OR(start=0,DAYS360(BG$5,start,1)>0),0,IF(AND((start-BG$5)>1,(start-BG$5)<7),"Y",IF((Expected-BG$5)>0,"Y",0)))</TD></TR><TR><TD>BH8</TD><TD>=IF(OR(start=0,DAYS360(BH$5,start,1)>0),0,IF(AND((start-BH$5)>1,(start-BH$5)<7),"Y",IF((Expected-BH$5)>0,"Y",0)))</TD></TR><TR><TD>BI8</TD><TD>=IF(OR(start=0,DAYS360(BI$5,start,1)>0),0,IF(AND((start-BI$5)>1,(start-BI$5)<7),"Y",IF((Expected-BI$5)>0,"Y",0)))</TD></TR><TR><TD>BJ8</TD><TD>=IF(OR(start=0,DAYS360(BJ$5,start,1)>0),0,IF(AND((start-BJ$5)>1,(start-BJ$5)<7),"Y",IF((Expected-BJ$5)>0,"Y",0)))</TD></TR><TR><TD>BK8</TD><TD>=IF(OR(start=0,DAYS360(BK$5,start,1)>0),0,IF(AND((start-BK$5)>1,(start-BK$5)<7),"Y",IF((Expected-BK$5)>0,"Y",0)))</TD></TR><TR><TD>BL8</TD><TD>=IF(OR(start=0,DAYS360(BL$5,start,1)>0),0,IF(AND((start-BL$5)>1,(start-BL$5)<7),"Y",IF((Expected-BL$5)>0,"Y",0)))</TD></TR><TR><TD>BM8</TD><TD>=IF(OR(start=0,DAYS360(BM$5,start,1)>0),0,IF(AND((start-BM$5)>1,(start-BM$5)<7),"Y",IF((Expected-BM$5)>0,"Y",0)))</TD></TR><TR><TD>BN8</TD><TD>=IF(OR(start=0,DAYS360(BN$5,start,1)>0),0,IF(AND((start-BN$5)>1,(start-BN$5)<7),"Y",IF((Expected-BN$5)>0,"Y",0)))</TD></TR><TR><TD>BO8</TD><TD>=IF(OR(start=0,DAYS360(BO$5,start,1)>0),0,IF(AND((start-BO$5)>1,(start-BO$5)<7),"Y",IF((Expected-BO$5)>0,"Y",0)))</TD></TR><TR><TD>BP8</TD><TD>=IF(OR(start=0,DAYS360(BP$5,start,1)>0),0,IF(AND((start-BP$5)>1,(start-BP$5)<7),"Y",IF((Expected-BP$5)>0,"Y",0)))</TD></TR><TR><TD>BQ8</TD><TD>=IF(OR(start=0,DAYS360(BQ$5,start,1)>0),0,IF(AND((start-BQ$5)>1,(start-BQ$5)<7),"Y",IF((Expected-BQ$5)>0,"Y",0)))</TD></TR><TR><TD>BR8</TD><TD>=IF(OR(start=0,DAYS360(BR$5,start,1)>0),0,IF(AND((start-BR$5)>1,(start-BR$5)<7),"Y",IF((Expected-BR$5)>0,"Y",0)))</TD></TR><TR><TD>BS8</TD><TD>=IF(OR(start=0,DAYS360(BS$5,start,1)>0),0,IF(AND((start-BS$5)>1,(start-BS$5)<7),"Y",IF((Expected-BS$5)>0,"Y",0)))</TD></TR><TR><TD>BT8</TD><TD>=IF(OR(start=0,DAYS360(BT$5,start,1)>0),0,IF(AND((start-BT$5)>1,(start-BT$5)<7),"Y",IF((Expected-BT$5)>0,"Y",0)))</TD></TR><TR><TD>BU8</TD><TD>=IF(OR(start=0,DAYS360(BU$5,start,1)>0),0,IF(AND((start-BU$5)>1,(start-BU$5)<7),"Y",IF((Expected-BU$5)>0,"Y",0)))</TD></TR><TR><TD>BV8</TD><TD>=IF(OR(start=0,DAYS360(BV$5,start,1)>0),0,IF(AND((start-BV$5)>1,(start-BV$5)<7),"Y",IF((Expected-BV$5)>0,"Y",0)))</TD></TR><TR><TD>BW8</TD><TD>=IF(OR(start=0,DAYS360(BW$5,start,1)>0),0,IF(AND((start-BW$5)>1,(start-BW$5)<7),"Y",IF((Expected-BW$5)>0,"Y",0)))</TD></TR><TR><TD>BX8</TD><TD>=IF(OR(start=0,DAYS360(BX$5,start,1)>0),0,IF(AND((start-BX$5)>1,(start-BX$5)<7),"Y",IF((Expected-BX$5)>0,"Y",0)))</TD></TR><TR><TD>BY8</TD><TD>=IF(OR(start=0,DAYS360(BY$5,start,1)>0),0,IF(AND((start-BY$5)>1,(start-BY$5)<7),"Y",IF((Expected-BY$5)>0,"Y",0)))</TD></TR><TR><TD>BZ8</TD><TD>=IF(OR(start=0,DAYS360(BZ$5,start,1)>0),0,IF(AND((start-BZ$5)>1,(start-BZ$5)<7),"Y",IF((Expected-BZ$5)>0,"Y",0)))</TD></TR><TR><TD>CA8</TD><TD>=IF(OR(start=0,DAYS360(CA$5,start,1)>0),0,IF(AND((start-CA$5)>1,(start-CA$5)<7),"Y",IF((Expected-CA$5)>0,"Y",0)))</TD></TR><TR><TD>CB8</TD><TD>=IF(OR(start=0,DAYS360(CB$5,start,1)>0),0,IF(AND((start-CB$5)>1,(start-CB$5)<7),"Y",IF((Expected-CB$5)>0,"Y",0)))</TD></TR><TR><TD>CC8</TD><TD>=IF(OR(start=0,DAYS360(CC$5,start,1)>0),0,IF(AND((start-CC$5)>1,(start-CC$5)<7),"Y",IF((Expected-CC$5)>0,"Y",0)))</TD></TR><TR><TD>CD8</TD><TD>=IF(OR(start=0,DAYS360(CD$5,start,1)>0),0,IF(AND((start-CD$5)>1,(start-CD$5)<7),"Y",IF((Expected-CD$5)>0,"Y",0)))</TD></TR><TR><TD>CE8</TD><TD>=IF(OR(start=0,DAYS360(CE$5,start,1)>0),0,IF(AND((start-CE$5)>1,(start-CE$5)<7),"Y",IF((Expected-CE$5)>0,"Y",0)))</TD></TR><TR><TD>CF8</TD><TD>=IF(OR(start=0,DAYS360(CF$5,start,1)>0),0,IF(AND((start-CF$5)>1,(start-CF$5)<7),"Y",IF((Expected-CF$5)>0,"Y",0)))</TD></TR><TR><TD>CG8</TD><TD>=IF(OR(start=0,DAYS360(CG$5,start,1)>0),0,IF(AND((start-CG$5)>1,(start-CG$5)<7),"Y",IF((Expected-CG$5)>0,"Y",0)))</TD></TR><TR><TD>CH8</TD><TD>=IF(OR(start=0,DAYS360(CH$5,start,1)>0),0,IF(AND((start-CH$5)>1,(start-CH$5)<7),"Y",IF((Expected-CH$5)>0,"Y",0)))</TD></TR><TR><TD>CI8</TD><TD>=IF(OR(start=0,DAYS360(CI$5,start,1)>0),0,IF(AND((start-CI$5)>1,(start-CI$5)<7),"Y",IF((Expected-CI$5)>0,"Y",0)))</TD></TR><TR><TD>CJ8</TD><TD>=IF(OR(start=0,DAYS360(CJ$5,start,1)>0),0,IF(AND((start-CJ$5)>1,(start-CJ$5)<7),"Y",IF((Expected-CJ$5)>0,"Y",0)))</TD></TR><TR><TD>CK8</TD><TD>=IF(OR(start=0,DAYS360(CK$5,start,1)>0),0,IF(AND((start-CK$5)>1,(start-CK$5)<7),"Y",IF((Expected-CK$5)>0,"Y",0)))</TD></TR><TR><TD>CL8</TD><TD>=IF(OR(start=0,DAYS360(CL$5,start,1)>0),0,IF(AND((start-CL$5)>1,(start-CL$5)<7),"Y",IF((Expected-CL$5)>0,"Y",0)))</TD></TR><TR><TD>CM8</TD><TD>=IF(OR(start=0,DAYS360(CM$5,start,1)>0),0,IF(AND((start-CM$5)>1,(start-CM$5)<7),"Y",IF((Expected-CM$5)>0,"Y",0)))</TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>


Excel tables to the web >> http://www.excel-jeanie-html.de/index.php?f=1" target="_blank"> Excel Jeanie HTML 4

Thank you!!!!!!

 

[shg]

Is there a possibility you could explain in words what you're trying to do?

 

[excelblackbelt]

Ok...

In columns E,F, and G I am looking up from a previous worksheet and then that range populates the Gantt type chart. The problem is when I start using the 2012 dates the chart populates as if it were 2011 and does not flow in to Feb 2012. Look at Row 8 the end date in F8 that should populate to CG8, but the problem is it stops at CA8. I am not sure where the issue is in the formula.

Another side note is I used 2011 and did a copy to create 2012 copy and pasting 4 new quarters next to Q4 2011. For some reason I lost something in the formula and it will not populate CG8 and stops at CA8.

I really appreciate your help.

 

[excelblackbelt]

Does anyone have any ideas with this riddle? Why will my chart not populate into Jan & Feb of 2012?

Also, does anyone have any good GANNT chart templates I can reference that are easy to use?

Thank you!