I have a spreadsheet that is being used as a form to complete Project Estimates. Users enter a project start date and I have formula in place that retrieves the Quarter/Year the project will begin...(See image)
<TABLE style="WIDTH: 502pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=669 border=0 x:str><COLGROUP><COL style="WIDTH: 301pt; mso-width-source: userset; mso-width-alt: 14665" width=401><COL style="WIDTH: 12pt; mso-width-source: userset; mso-width-alt: 585" width=16><COL style="WIDTH: 54pt; mso-width-source: userset; mso-width-alt: 2633" width=72><COL style="WIDTH: 91pt; mso-width-source: userset; mso-width-alt: 4425" width=121><COL style="WIDTH: 44pt; mso-width-source: userset; mso-width-alt: 2157" width=59><TBODY><TR style="HEIGHT: 13.5pt" height=18><TD class=xl65 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; WIDTH: 301pt; BORDER-BOTTOM: #e0dfe3; HEIGHT: 13.5pt; BACKGROUND-COLOR: white" width=401 height=18>Project start Date (used for these estimates):</TD><TD class=xl65 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; WIDTH: 12pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: white" width=16></TD><TD class=xl66 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; WIDTH: 54pt; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: white" width=72>03</TD><TD class=xl67 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: windowtext; WIDTH: 91pt; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: white" align=right width=121 x:num>2010</TD><TD class=xl68 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: windowtext; WIDTH: 44pt; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: yellow" width=59>Q1 2010</TD></TR></TBODY></TABLE>
Next the user identifies how many quarters it will take to complete the project based on "phases", there are 5 phases total (i.e. Design Phase, Implementation Phase, etc.)...(See image)
<TABLE style="WIDTH: 108pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=144 border=0 x:str><COLGROUP><COL style="WIDTH: 44pt; mso-width-source: userset; mso-width-alt: 2157" width=59><COL style="WIDTH: 64pt; mso-width-source: userset; mso-width-alt: 3108" width=85><TBODY><TR style="HEIGHT: 12.75pt; mso-height-source: userset" height=17><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 44pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: white" width=59 height=17></TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 64pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" width=85>Assessment</TD></TR><TR style="HEIGHT: 12.75pt; mso-height-source: userset" height=17><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 44pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: white" width=59 height=17>Qtrs</TD><TD class=xl67 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" x:num>
</TD></TR></TBODY></TABLE>
This information needs to roll-up into a two-year quarter trending view and then an annual view thereafter (i.e. Q1 2010, Q2 2010, Q3 2010, Q4 2010, then Q1 2011, Q2 2011, Q3 2011, Q4 2011...then 2012, 2013, and 2014) without double counting...here's a snap-shot of the phase breakout:
<TABLE style="WIDTH: 566pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=753 border=0 x:str><COLGROUP><COL style="WIDTH: 54pt; mso-width-source: userset; mso-width-alt: 2633" width=72><COL style="WIDTH: 64pt; mso-width-source: userset; mso-width-alt: 3108" width=85><COL style="WIDTH: 6pt; mso-width-source: userset; mso-width-alt: 292" width=8><COL style="WIDTH: 101pt; mso-width-source: userset; mso-width-alt: 4937" width=135><COL style="WIDTH: 6pt; mso-width-source: userset; mso-width-alt: 292" width=8><COL style="WIDTH: 93pt; mso-width-source: userset; mso-width-alt: 4534" width=124><COL style="WIDTH: 6pt; mso-width-source: userset; mso-width-alt: 292" width=8><COL style="WIDTH: 89pt; mso-width-source: userset; mso-width-alt: 4315" width=118><COL style="WIDTH: 6pt; mso-width-source: userset; mso-width-alt: 292" width=8><COL style="WIDTH: 78pt; mso-width-source: userset; mso-width-alt: 3803" width=104><COL style="WIDTH: 7pt; mso-width-source: userset; mso-width-alt: 329" width=9><COL style="WIDTH: 56pt; mso-width-source: userset; mso-width-alt: 2706" width=74><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD class=xl90 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; WIDTH: 54pt; BORDER-BOTTOM: #e0dfe3; HEIGHT: 12.75pt; BACKGROUND-COLOR: white" width=72 height=17></TD><TD class=xl92 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: #e0dfe3; WIDTH: 64pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: white" width=85>Assessment</TD><TD class=xl93 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: #e0dfe3; WIDTH: 6pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: white" width=8></TD><TD class=xl92 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: #e0dfe3; WIDTH: 101pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: white" width=135>Planning</TD><TD class=xl93 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: #e0dfe3; WIDTH: 6pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: white" width=8></TD><TD class=xl92 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: #e0dfe3; WIDTH: 93pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: white" width=124>Execution</TD><TD class=xl93 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: #e0dfe3; WIDTH: 6pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: white" width=8></TD><TD class=xl92 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: #e0dfe3; WIDTH: 89pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: white" width=118>Testing</TD><TD class=xl93 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: #e0dfe3; WIDTH: 6pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: white" width=8></TD><TD class=xl92 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: #e0dfe3; WIDTH: 78pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: white" width=104>Implementation</TD><TD class=xl93 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: #e0dfe3; WIDTH: 7pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: white" width=9></TD><TD class=xl93 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: #e0dfe3; WIDTH: 56pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: white" width=74>TOTAL</TD></TR><TR style="HEIGHT: 12.75pt; mso-height-source: userset" height=17><TD class=xl91 style="BORDER-RIGHT: #e0dfe3 0.5pt; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; WIDTH: 54pt; BORDER-BOTTOM: #e0dfe3; HEIGHT: 12.75pt; BACKGROUND-COLOR: white" width=72 height=17>Qtrs</TD><TD class=xl88 style="BORDER-RIGHT: #e0dfe3 0.5pt; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3 0.5pt; BACKGROUND-COLOR: white" x:num>5</TD><TD style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent"></TD><TD class=xl88 style="BORDER-RIGHT: #e0dfe3 0.5pt; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3 0.5pt; BORDER-BOTTOM: #e0dfe3 0.5pt; BACKGROUND-COLOR: white" x:num>4</TD><TD style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent"></TD><TD class=xl88 style="BORDER-RIGHT: #e0dfe3 0.5pt; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3 0.5pt; BORDER-BOTTOM: #e0dfe3 0.5pt; BACKGROUND-COLOR: white" x:num>5</TD><TD style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent"></TD><TD class=xl88 style="BORDER-RIGHT: #e0dfe3 0.5pt; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3 0.5pt; BORDER-BOTTOM: #e0dfe3 0.5pt; BACKGROUND-COLOR: white" x:num>3</TD><TD style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent"></TD><TD class=xl88 style="BORDER-RIGHT: #e0dfe3 0.5pt; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3 0.5pt; BORDER-BOTTOM: #e0dfe3 0.5pt; BACKGROUND-COLOR: white" x:num>2</TD><TD class=xl66 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; WIDTH: 7pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: white" width=9></TD><TD class=xl89 style="BORDER-RIGHT: #e0dfe3 0.5pt; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3 0.5pt; BORDER-BOTTOM: #e0dfe3 0.5pt; BACKGROUND-COLOR: white" x:num="19">19 </TD></TR><TR style="HEIGHT: 6.75pt; mso-height-source: userset" height=9><TD class=xl68 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; WIDTH: 54pt; BORDER-BOTTOM: #e0dfe3; HEIGHT: 6.75pt; BACKGROUND-COLOR: white" width=72 height=9></TD><TD class=xl86 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3 0.5pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl83 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl83 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl83 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl83 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl83 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl83 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl83 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl83 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl66 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; WIDTH: 7pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: white" width=9></TD><TD class=xl69 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; WIDTH: 56pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: white" width=74></TD></TR><TR style="HEIGHT: 24pt" height=32><TD class=xl85 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: #e0dfe3; WIDTH: 54pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 24pt; BACKGROUND-COLOR: transparent" width=72 height=32>COUNT</TD><TD class=xl81 style="BORDER-RIGHT: #e0dfe3 0.5pt; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3 0.5pt; WIDTH: 64pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffff99" width=85>Assessment
(in 000s)
</TD><TD class=xl84 style="BORDER-RIGHT: #e0dfe3 0.5pt; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl81 style="BORDER-RIGHT: #e0dfe3 0.5pt; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; WIDTH: 101pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffff99" width=135>Planning
(in 000s)
</TD><TD class=xl78 style="BORDER-RIGHT: #e0dfe3 0.5pt; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl81 style="BORDER-RIGHT: #e0dfe3 0.5pt; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; WIDTH: 93pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffff99" width=124>Execiton
(in 000s)
</TD><TD class=xl78 style="BORDER-RIGHT: #e0dfe3 0.5pt; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl81 style="BORDER-RIGHT: #e0dfe3 0.5pt; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; WIDTH: 89pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffff99" width=118>Testing
(in 000s)
</TD><TD class=xl78 style="BORDER-RIGHT: #e0dfe3 0.5pt; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl82 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; WIDTH: 78pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffff99" width=104>Implementation
(in 000s)
</TD><TD class=xl74 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; WIDTH: 7pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: white" width=9></TD><TD class=xl75 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: #e0dfe3; WIDTH: 56pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffff99" width=74>TOTAL
(in 000s)
</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl70 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: windowtext; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: silver" height=17></TD><TD class=xl70 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: windowtext; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: silver"></TD><TD class=xl73 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: windowtext; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: silver"></TD><TD class=xl70 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: windowtext; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: silver"></TD><TD class=xl70 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: windowtext; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: silver"></TD><TD class=xl70 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: windowtext; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: silver"></TD><TD class=xl70 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: windowtext; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: silver"></TD><TD class=xl70 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: windowtext; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: silver"></TD><TD class=xl70 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: windowtext; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: silver"></TD><TD class=xl70 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: windowtext; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: silver"></TD><TD class=xl70 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: silver"></TD><TD class=xl71 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: silver"></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl80 style="BORDER-RIGHT: #e0dfe3 0.5pt; BORDER-TOP: windowtext; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; HEIGHT: 12.75pt; BACKGROUND-COLOR: white" height=17 x:num>1</TD><TD class=xl77 style="BORDER-RIGHT: #e0dfe3 0.5pt; BORDER-TOP: windowtext; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: #ffff99" x:num="187.5">188 </TD><TD class=xl76 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: white"></TD><TD class=xl77 style="BORDER-RIGHT: #e0dfe3 0.5pt; BORDER-TOP: windowtext; BORDER-LEFT: #e0dfe3 0.5pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: #ffff99" x:num="150">150 </TD><TD class=xl94 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: windowtext; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: white"></TD><TD class=xl77 style="BORDER-RIGHT: #e0dfe3 0.5pt; BORDER-TOP: windowtext; BORDER-LEFT: #e0dfe3 0.5pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: #ffff99" x:num="187.5">188 </TD><TD class=xl94 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: windowtext; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: white"></TD><TD class=xl77 style="BORDER-RIGHT: #e0dfe3 0.5pt; BORDER-TOP: windowtext; BORDER-LEFT: #e0dfe3 0.5pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: #ffff99" x:num="112.5">113 </TD><TD class=xl94 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: windowtext; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: white"></TD><TD class=xl77 style="BORDER-RIGHT: #e0dfe3 0.5pt; BORDER-TOP: windowtext; BORDER-LEFT: #e0dfe3 0.5pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: #ffff99" x:num="75">75 </TD><TD class=xl65 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: white"></TD><TD class=xl79 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: #ffff99" x:num="712.5">713 </TD></TR></TBODY></TABLE>
and here's a snap-shot of the summary roll-up:
I'd prefer not to use VBA because I am not familiar with it...any ideas????
<TABLE style="WIDTH: 502pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=669 border=0 x:str><COLGROUP><COL style="WIDTH: 301pt; mso-width-source: userset; mso-width-alt: 14665" width=401><COL style="WIDTH: 12pt; mso-width-source: userset; mso-width-alt: 585" width=16><COL style="WIDTH: 54pt; mso-width-source: userset; mso-width-alt: 2633" width=72><COL style="WIDTH: 91pt; mso-width-source: userset; mso-width-alt: 4425" width=121><COL style="WIDTH: 44pt; mso-width-source: userset; mso-width-alt: 2157" width=59><TBODY><TR style="HEIGHT: 13.5pt" height=18><TD class=xl65 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; WIDTH: 301pt; BORDER-BOTTOM: #e0dfe3; HEIGHT: 13.5pt; BACKGROUND-COLOR: white" width=401 height=18>Project start Date (used for these estimates):</TD><TD class=xl65 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; WIDTH: 12pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: white" width=16></TD><TD class=xl66 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; WIDTH: 54pt; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: white" width=72>03</TD><TD class=xl67 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: windowtext; WIDTH: 91pt; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: white" align=right width=121 x:num>2010</TD><TD class=xl68 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: windowtext; WIDTH: 44pt; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: yellow" width=59>Q1 2010</TD></TR></TBODY></TABLE>
Next the user identifies how many quarters it will take to complete the project based on "phases", there are 5 phases total (i.e. Design Phase, Implementation Phase, etc.)...(See image)
<TABLE style="WIDTH: 108pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=144 border=0 x:str><COLGROUP><COL style="WIDTH: 44pt; mso-width-source: userset; mso-width-alt: 2157" width=59><COL style="WIDTH: 64pt; mso-width-source: userset; mso-width-alt: 3108" width=85><TBODY><TR style="HEIGHT: 12.75pt; mso-height-source: userset" height=17><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 44pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: white" width=59 height=17></TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 64pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" width=85>Assessment</TD></TR><TR style="HEIGHT: 12.75pt; mso-height-source: userset" height=17><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 44pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: white" width=59 height=17>Qtrs</TD><TD class=xl67 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white" x:num>
4
</TD></TR></TBODY></TABLE>
This information needs to roll-up into a two-year quarter trending view and then an annual view thereafter (i.e. Q1 2010, Q2 2010, Q3 2010, Q4 2010, then Q1 2011, Q2 2011, Q3 2011, Q4 2011...then 2012, 2013, and 2014) without double counting...here's a snap-shot of the phase breakout:
<TABLE style="WIDTH: 566pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=753 border=0 x:str><COLGROUP><COL style="WIDTH: 54pt; mso-width-source: userset; mso-width-alt: 2633" width=72><COL style="WIDTH: 64pt; mso-width-source: userset; mso-width-alt: 3108" width=85><COL style="WIDTH: 6pt; mso-width-source: userset; mso-width-alt: 292" width=8><COL style="WIDTH: 101pt; mso-width-source: userset; mso-width-alt: 4937" width=135><COL style="WIDTH: 6pt; mso-width-source: userset; mso-width-alt: 292" width=8><COL style="WIDTH: 93pt; mso-width-source: userset; mso-width-alt: 4534" width=124><COL style="WIDTH: 6pt; mso-width-source: userset; mso-width-alt: 292" width=8><COL style="WIDTH: 89pt; mso-width-source: userset; mso-width-alt: 4315" width=118><COL style="WIDTH: 6pt; mso-width-source: userset; mso-width-alt: 292" width=8><COL style="WIDTH: 78pt; mso-width-source: userset; mso-width-alt: 3803" width=104><COL style="WIDTH: 7pt; mso-width-source: userset; mso-width-alt: 329" width=9><COL style="WIDTH: 56pt; mso-width-source: userset; mso-width-alt: 2706" width=74><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD class=xl90 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; WIDTH: 54pt; BORDER-BOTTOM: #e0dfe3; HEIGHT: 12.75pt; BACKGROUND-COLOR: white" width=72 height=17></TD><TD class=xl92 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: #e0dfe3; WIDTH: 64pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: white" width=85>Assessment</TD><TD class=xl93 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: #e0dfe3; WIDTH: 6pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: white" width=8></TD><TD class=xl92 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: #e0dfe3; WIDTH: 101pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: white" width=135>Planning</TD><TD class=xl93 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: #e0dfe3; WIDTH: 6pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: white" width=8></TD><TD class=xl92 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: #e0dfe3; WIDTH: 93pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: white" width=124>Execution</TD><TD class=xl93 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: #e0dfe3; WIDTH: 6pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: white" width=8></TD><TD class=xl92 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: #e0dfe3; WIDTH: 89pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: white" width=118>Testing</TD><TD class=xl93 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: #e0dfe3; WIDTH: 6pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: white" width=8></TD><TD class=xl92 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: #e0dfe3; WIDTH: 78pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: white" width=104>Implementation</TD><TD class=xl93 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: #e0dfe3; WIDTH: 7pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: white" width=9></TD><TD class=xl93 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: #e0dfe3; WIDTH: 56pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: white" width=74>TOTAL</TD></TR><TR style="HEIGHT: 12.75pt; mso-height-source: userset" height=17><TD class=xl91 style="BORDER-RIGHT: #e0dfe3 0.5pt; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; WIDTH: 54pt; BORDER-BOTTOM: #e0dfe3; HEIGHT: 12.75pt; BACKGROUND-COLOR: white" width=72 height=17>Qtrs</TD><TD class=xl88 style="BORDER-RIGHT: #e0dfe3 0.5pt; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3 0.5pt; BACKGROUND-COLOR: white" x:num>5</TD><TD style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent"></TD><TD class=xl88 style="BORDER-RIGHT: #e0dfe3 0.5pt; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3 0.5pt; BORDER-BOTTOM: #e0dfe3 0.5pt; BACKGROUND-COLOR: white" x:num>4</TD><TD style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent"></TD><TD class=xl88 style="BORDER-RIGHT: #e0dfe3 0.5pt; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3 0.5pt; BORDER-BOTTOM: #e0dfe3 0.5pt; BACKGROUND-COLOR: white" x:num>5</TD><TD style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent"></TD><TD class=xl88 style="BORDER-RIGHT: #e0dfe3 0.5pt; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3 0.5pt; BORDER-BOTTOM: #e0dfe3 0.5pt; BACKGROUND-COLOR: white" x:num>3</TD><TD style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent"></TD><TD class=xl88 style="BORDER-RIGHT: #e0dfe3 0.5pt; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3 0.5pt; BORDER-BOTTOM: #e0dfe3 0.5pt; BACKGROUND-COLOR: white" x:num>2</TD><TD class=xl66 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; WIDTH: 7pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: white" width=9></TD><TD class=xl89 style="BORDER-RIGHT: #e0dfe3 0.5pt; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3 0.5pt; BORDER-BOTTOM: #e0dfe3 0.5pt; BACKGROUND-COLOR: white" x:num="19">19 </TD></TR><TR style="HEIGHT: 6.75pt; mso-height-source: userset" height=9><TD class=xl68 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; WIDTH: 54pt; BORDER-BOTTOM: #e0dfe3; HEIGHT: 6.75pt; BACKGROUND-COLOR: white" width=72 height=9></TD><TD class=xl86 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3 0.5pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl83 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl83 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl83 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl83 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl83 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl83 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl83 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl83 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl66 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; WIDTH: 7pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: white" width=9></TD><TD class=xl69 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; WIDTH: 56pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: white" width=74></TD></TR><TR style="HEIGHT: 24pt" height=32><TD class=xl85 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: #e0dfe3; WIDTH: 54pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 24pt; BACKGROUND-COLOR: transparent" width=72 height=32>COUNT</TD><TD class=xl81 style="BORDER-RIGHT: #e0dfe3 0.5pt; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3 0.5pt; WIDTH: 64pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffff99" width=85>Assessment
(in 000s)
</TD><TD class=xl84 style="BORDER-RIGHT: #e0dfe3 0.5pt; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl81 style="BORDER-RIGHT: #e0dfe3 0.5pt; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; WIDTH: 101pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffff99" width=135>Planning
(in 000s)
</TD><TD class=xl78 style="BORDER-RIGHT: #e0dfe3 0.5pt; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl81 style="BORDER-RIGHT: #e0dfe3 0.5pt; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; WIDTH: 93pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffff99" width=124>Execiton
(in 000s)
</TD><TD class=xl78 style="BORDER-RIGHT: #e0dfe3 0.5pt; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl81 style="BORDER-RIGHT: #e0dfe3 0.5pt; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; WIDTH: 89pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffff99" width=118>Testing
(in 000s)
</TD><TD class=xl78 style="BORDER-RIGHT: #e0dfe3 0.5pt; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl82 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; WIDTH: 78pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffff99" width=104>Implementation
(in 000s)
</TD><TD class=xl74 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; WIDTH: 7pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: white" width=9></TD><TD class=xl75 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: #e0dfe3; WIDTH: 56pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffff99" width=74>TOTAL
(in 000s)
</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl70 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: windowtext; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: silver" height=17></TD><TD class=xl70 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: windowtext; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: silver"></TD><TD class=xl73 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: windowtext; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: silver"></TD><TD class=xl70 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: windowtext; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: silver"></TD><TD class=xl70 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: windowtext; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: silver"></TD><TD class=xl70 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: windowtext; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: silver"></TD><TD class=xl70 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: windowtext; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: silver"></TD><TD class=xl70 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: windowtext; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: silver"></TD><TD class=xl70 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: windowtext; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: silver"></TD><TD class=xl70 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: windowtext; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: silver"></TD><TD class=xl70 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: silver"></TD><TD class=xl71 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: silver"></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl80 style="BORDER-RIGHT: #e0dfe3 0.5pt; BORDER-TOP: windowtext; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; HEIGHT: 12.75pt; BACKGROUND-COLOR: white" height=17 x:num>1</TD><TD class=xl77 style="BORDER-RIGHT: #e0dfe3 0.5pt; BORDER-TOP: windowtext; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: #ffff99" x:num="187.5">188 </TD><TD class=xl76 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: white"></TD><TD class=xl77 style="BORDER-RIGHT: #e0dfe3 0.5pt; BORDER-TOP: windowtext; BORDER-LEFT: #e0dfe3 0.5pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: #ffff99" x:num="150">150 </TD><TD class=xl94 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: windowtext; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: white"></TD><TD class=xl77 style="BORDER-RIGHT: #e0dfe3 0.5pt; BORDER-TOP: windowtext; BORDER-LEFT: #e0dfe3 0.5pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: #ffff99" x:num="187.5">188 </TD><TD class=xl94 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: windowtext; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: white"></TD><TD class=xl77 style="BORDER-RIGHT: #e0dfe3 0.5pt; BORDER-TOP: windowtext; BORDER-LEFT: #e0dfe3 0.5pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: #ffff99" x:num="112.5">113 </TD><TD class=xl94 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: windowtext; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: white"></TD><TD class=xl77 style="BORDER-RIGHT: #e0dfe3 0.5pt; BORDER-TOP: windowtext; BORDER-LEFT: #e0dfe3 0.5pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: #ffff99" x:num="75">75 </TD><TD class=xl65 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: white"></TD><TD class=xl79 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: #ffff99" x:num="712.5">713 </TD></TR></TBODY></TABLE>
and here's a snap-shot of the summary roll-up:
<TABLE style="WIDTH: 590pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=789 border=0 x:str><COLGROUP><COL style="WIDTH: 47pt; mso-width-source: userset; mso-width-alt: 2304" span=2 width=63><COL style="WIDTH: 49pt; mso-width-source: userset; mso-width-alt: 2377" width=65><COL style="WIDTH: 47pt; mso-width-source: userset; mso-width-alt: 2304" span=8 width=63><COL style="WIDTH: 71pt; mso-width-source: userset; mso-width-alt: 3437" width=94><TBODY><TR style="HEIGHT: 15pt; mso-height-source: userset" height=20><TD class=xl72 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 519pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: blue" width=695 colSpan=11 height=20>Quarterly & Yearly Project Costs Input Worksheet
</TD><TD class=xl71 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: #e0dfe3; WIDTH: 71pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: blue" width=94>
</TD></TR><TR style="HEIGHT: 25.5pt" height=34><TD class=xl67 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 25.5pt; BACKGROUND-COLOR: #333333" height=34>Q1 2010
</TD><TD class=xl67 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #333333">Q2 2010
</TD><TD class=xl67 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #333333">Q3 2010
</TD><TD class=xl67 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #333333">Q4 2010
</TD><TD class=xl67 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #333333">Q1 2011
</TD><TD class=xl67 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #333333">Q2 2011
</TD><TD class=xl67 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #333333">Q3 2011
</TD><TD class=xl67 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #333333">Q4 2011
</TD><TD class=xl67 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #333333" x:num>2012
</TD><TD class=xl67 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #333333" x:num>2013
</TD><TD class=xl67 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #333333" x:num>2014
</TD><TD class=xl67 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #333333">Total
</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl68 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: windowtext; BORDER-LEFT: #e0dfe3; WIDTH: 47pt; BORDER-BOTTOM: #e0dfe3; HEIGHT: 12.75pt; BACKGROUND-COLOR: silver" width=63 height=17>
</TD><TD class=xl68 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: windowtext; BORDER-LEFT: #e0dfe3; WIDTH: 47pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: silver" width=63>
</TD><TD class=xl68 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: windowtext; BORDER-LEFT: #e0dfe3; WIDTH: 49pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: silver" width=65>
</TD><TD class=xl68 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: windowtext; BORDER-LEFT: #e0dfe3; WIDTH: 47pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: silver" width=63>
</TD><TD class=xl68 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: windowtext; BORDER-LEFT: #e0dfe3; WIDTH: 47pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: silver" width=63>
</TD><TD class=xl68 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: windowtext; BORDER-LEFT: #e0dfe3; WIDTH: 47pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: silver" width=63>
</TD><TD class=xl68 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: windowtext; BORDER-LEFT: #e0dfe3; WIDTH: 47pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: silver" width=63>
</TD><TD class=xl68 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: windowtext; BORDER-LEFT: #e0dfe3; WIDTH: 47pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: silver" width=63>
</TD><TD class=xl68 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: windowtext; BORDER-LEFT: #e0dfe3; WIDTH: 47pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: silver" width=63>
</TD><TD class=xl68 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: windowtext; BORDER-LEFT: #e0dfe3; WIDTH: 47pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: silver" width=63>
</TD><TD class=xl68 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: windowtext; BORDER-LEFT: #e0dfe3; WIDTH: 47pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: silver" width=63>
</TD><TD class=xl69 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: #e0dfe3; WIDTH: 71pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: silver" width=94>
</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl65 style="BORDER-RIGHT: #e0dfe3 0.5pt; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3 0.5pt; BORDER-BOTTOM: #e0dfe3; HEIGHT: 12.75pt; BACKGROUND-COLOR: #ffff99" height=17 x:num="75">75
</TD><TD class=xl65 style="BORDER-RIGHT: #e0dfe3 0.5pt; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: #ffff99" x:num="0">-
</TD><TD class=xl65 style="BORDER-RIGHT: #e0dfe3 0.5pt; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: #ffff99">
</TD><TD class=xl65 style="BORDER-RIGHT: #e0dfe3 0.5pt; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: #ffff99">
</TD><TD class=xl65 style="BORDER-RIGHT: #e0dfe3 0.5pt; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: #ffff99">
</TD><TD class=xl65 style="BORDER-RIGHT: #e0dfe3 0.5pt; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: #ffff99">
</TD><TD class=xl65 style="BORDER-RIGHT: #e0dfe3 0.5pt; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: #ffff99"></TD><TD class=xl65 style="BORDER-RIGHT: #e0dfe3 0.5pt; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: #ffff99"></TD><TD class=xl65 style="BORDER-RIGHT: #e0dfe3 0.5pt; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: #ffff99"></TD><TD class=xl65 style="BORDER-RIGHT: #e0dfe3 0.5pt; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: #ffff99"></TD><TD class=xl66 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: #ffff99"></TD><TD class=xl70 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #e0dfe3; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: #ffff99" x:num="75">75 </TD></TR></TBODY></TABLE>I'd prefer not to use VBA because I am not familiar with it...any ideas????
