Lease Table

seoneil

New Member
Joined
Jun 18, 2002
Messages
11
My boss needs a model that works as follows. The ideal model would allow us to enter the five variables (square feet, rent/sq ft, annual rent escalation rate, lease commencement date and lease expiration date) which would deliver the active years across the top and the rents due in the appropriate months (with blanks wherever there is no rent due). He also wants the months, January thru December constantly listed in a column on the left with the years of the lease across the top row. I can't seem to post my spreadsheet to the board to show an example of what I want, so I hope this is clear!
 

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop

zzydhf

Board Regular
Joined
Apr 10, 2002
Messages
236
Well, here is something I came up with. I assumed the annual rent escalation rate was added to the rent/sqft each year. the formulas are different in a8:a19 and in b7:k7 and the first column in the matrix is diiferent than the columns to the right. If you want me to send this to you, IM me with your Email. HTH

<CENTER><TABLE borderColor=#c0c0c0 cellSpacing=0 width="60%" align=center border=1><TBODY><TR><TD bgColor=#0c266b colSpan=12><TABLE width="100%" align=center border=0><TBODY><TR><TD align=left><FONT color=white>Microsoft Excel - sqftrent.xls</FONT></TD><TD align=right><FONT color=white size=2>___Running: xl2000 : OS = Windows ME </FONT></TD></TR></TBODY></TABLE></TD></TR><TR><TD bgColor=#d4d0c8 colSpan=12><TABLE height=10 width="100%" align=center border=0 VALIGN="MIDDLE"><TBODY><TR><TD>(<U>F</U>)ile (<U>E</U>)dit (<U>V</U>)iew (<U>I</U>)nsert (<U>O</U>)ptions (<U>T</U>)ools (<U>D</U>)ata (<U>W</U>)indow (<U>H</U>)elp</TD><TD vAlign=center align=right><FORM name=formCb5705><INPUT onclick='window.clipboardData.setData("Text",document.formFb4266.sltNb5992.value);' type=button value="Copy Formula" name=btCb2288></FORM></TD></TR></TBODY></TABLE></TD></TR><TR><TD bgColor=white colSpan=12><TABLE border=0><TBODY><TR><FORM name=formFb4266><TD align=middle width="5%" bgColor=white><SELECT onchange="document.formFb4266.txbFb6925.value = document.formFb4266.sltNb5992.value" name=sltNb5992><OPTION value==DATE(YEAR(B4),1,1) selected>B7<OPTION value==DATE(YEAR(B7)+1,1,1)>C7<OPTION value==DATE(YEAR(C7)+1,1,1)>D7<OPTION value==DATE(YEAR(D7)+1,1,1)>E7<OPTION value==DATE(YEAR(E7)+1,1,1)>F7<OPTION value==DATE(YEAR(F7)+1,1,1)>G7<OPTION value==DATE(YEAR(G7)+1,1,1)>H7<OPTION value==DATE(YEAR(H7)+1,1,1)>I7<OPTION value==DATE(YEAR(I7)+1,1,1)>J7<OPTION value==DATE(YEAR(J7)+1,1,1)>K7<OPTION value==DATE(YEAR($B$4),1,1)>A8<OPTION value='=IF(AND(DATE(YEAR(B$7),MONTH($A8),DAY($A8))>=$B$4,DATE(YEAR(B$7),MONTH($A8),DAY($A8))<=$B$5),$B$1*$B$2,"")'>B8<OPTION value='=IF(AND(DATE(YEAR(C$7),MONTH($A8),DAY($A8))>=$B$4,DATE(YEAR(C$7),MONTH($A8),DAY($A8))<=$B$5),$B$1*($B$2+ROUNDDOWN((COUNTIF($B$8:B$19,">0")+MONTH($A8)-1)/12,0.1)),"")'>C8<OPTION value='=IF(AND(DATE(YEAR(D$7),MONTH($A8),DAY($A8))>=$B$4,DATE(YEAR(D$7),MONTH($A8),DAY($A8))<=$B$5),$B$1*($B$2+ROUNDDOWN((COUNTIF($B$8:C$19,">0")+MONTH($A8)-1)/12,0.1)),"")'>D8<OPTION value='=IF(AND(DATE(YEAR(E$7),MONTH($A8),DAY($A8))>=$B$4,DATE(YEAR(E$7),MONTH($A8),DAY($A8))<=$B$5),$B$1*($B$2+ROUNDDOWN((COUNTIF($B$8:D$19,">0")+MONTH($A8)-1)/12,0.1)),"")'>E8<OPTION value='=IF(AND(DATE(YEAR(F$7),MONTH($A8),DAY($A8))>=$B$4,DATE(YEAR(F$7),MONTH($A8),DAY($A8))<=$B$5),$B$1*($B$2+ROUNDDOWN((COUNTIF($B$8:E$19,">0")+MONTH($A8)-1)/12,0.1)),"")'>F8<OPTION value='=IF(AND(DATE(YEAR(G$7),MONTH($A8),DAY($A8))>=$B$4,DATE(YEAR(G$7),MONTH($A8),DAY($A8))<=$B$5),$B$1*($B$2+ROUNDDOWN((COUNTIF($B$8:F$19,">0")+MONTH($A8)-1)/12,0.1)),"")'>G8<OPTION value='=IF(AND(DATE(YEAR(H$7),MONTH($A8),DAY($A8))>=$B$4,DATE(YEAR(H$7),MONTH($A8),DAY($A8))<=$B$5),$B$1*($B$2+ROUNDDOWN((COUNTIF($B$8:G$19,">0")+MONTH($A8)-1)/12,0.1)),"")'>H8<OPTION value='=IF(AND(DATE(YEAR(I$7),MONTH($A8),DAY($A8))>=$B$4,DATE(YEAR(I$7),MONTH($A8),DAY($A8))<=$B$5),$B$1*($B$2+ROUNDDOWN((COUNTIF($B$8:H$19,">0")+MONTH($A8)-1)/12,0.1)),"")'>I8<OPTION value='=IF(AND(DATE(YEAR(J$7),MONTH($A8),DAY($A8))>=$B$4,DATE(YEAR(J$7),MONTH($A8),DAY($A8))<=$B$5),$B$1*($B$2+ROUNDDOWN((COUNTIF($B$8:I$19,">0")+MONTH($A8)-1)/12,0.1)),"")'>J8<OPTION value='=IF(AND(DATE(YEAR(K$7),MONTH($A8),DAY($A8))>=$B$4,DATE(YEAR(K$7),MONTH($A8),DAY($A8))<=$B$5),$B$1*($B$2+ROUNDDOWN((COUNTIF($B$8:J$19,">0")+MONTH($A8)-1)/12,0.1)),"")'>K8<OPTION value==DATE(YEAR($B$4),MONTH(A8)+1,1)>A9<OPTION value='=IF(AND(DATE(YEAR(B$7),MONTH($A9),DAY($A9))>=$B$4,DATE(YEAR(B$7),MONTH($A9),DAY($A9))<=$B$5),$B$1*$B$2,"")'>B9<OPTION value='=IF(AND(DATE(YEAR(C$7),MONTH($A9),DAY($A9))>=$B$4,DATE(YEAR(C$7),MONTH($A9),DAY($A9))<=$B$5),$B$1*($B$2+ROUNDDOWN((COUNTIF($B$8:B$19,">0")+MONTH($A9)-1)/12,0.1)),"")'>C9<OPTION value='=IF(AND(DATE(YEAR(D$7),MONTH($A9),DAY($A9))>=$B$4,DATE(YEAR(D$7),MONTH($A9),DAY($A9))<=$B$5),$B$1*($B$2+ROUNDDOWN((COUNTIF($B$8:C$19,">0")+MONTH($A9)-1)/12,0.1)),"")'>D9<OPTION value='=IF(AND(DATE(YEAR(E$7),MONTH($A9),DAY($A9))>=$B$4,DATE(YEAR(E$7),MONTH($A9),DAY($A9))<=$B$5),$B$1*($B$2+ROUNDDOWN((COUNTIF($B$8:D$19,">0")+MONTH($A9)-1)/12,0.1)),"")'>E9<OPTION value='=IF(AND(DATE(YEAR(F$7),MONTH($A9),DAY($A9))>=$B$4,DATE(YEAR(F$7),MONTH($A9),DAY($A9))<=$B$5),$B$1*($B$2+ROUNDDOWN((COUNTIF($B$8:E$19,">0")+MONTH($A9)-1)/12,0.1)),"")'>F9<OPTION value='=IF(AND(DATE(YEAR(G$7),MONTH($A9),DAY($A9))>=$B$4,DATE(YEAR(G$7),MONTH($A9),DAY($A9))<=$B$5),$B$1*($B$2+ROUNDDOWN((COUNTIF($B$8:F$19,">0")+MONTH($A9)-1)/12,0.1)),"")'>G9<OPTION value='=IF(AND(DATE(YEAR(H$7),MONTH($A9),DAY($A9))>=$B$4,DATE(YEAR(H$7),MONTH($A9),DAY($A9))<=$B$5),$B$1*($B$2+ROUNDDOWN((COUNTIF($B$8:G$19,">0")+MONTH($A9)-1)/12,0.1)),"")'>H9<OPTION value='=IF(AND(DATE(YEAR(I$7),MONTH($A9),DAY($A9))>=$B$4,DATE(YEAR(I$7),MONTH($A9),DAY($A9))<=$B$5),$B$1*($B$2+ROUNDDOWN((COUNTIF($B$8:H$19,">0")+MONTH($A9)-1)/12,0.1)),"")'>I9<OPTION value='=IF(AND(DATE(YEAR(J$7),MONTH($A9),DAY($A9))>=$B$4,DATE(YEAR(J$7),MONTH($A9),DAY($A9))<=$B$5),$B$1*($B$2+ROUNDDOWN((COUNTIF($B$8:I$19,">0")+MONTH($A9)-1)/12,0.1)),"")'>J9<OPTION value='=IF(AND(DATE(YEAR(K$7),MONTH($A9),DAY($A9))>=$B$4,DATE(YEAR(K$7),MONTH($A9),DAY($A9))<=$B$5),$B$1*($B$2+ROUNDDOWN((COUNTIF($B$8:J$19,">0")+MONTH($A9)-1)/12,0.1)),"")'>K9<OPTION value==DATE(YEAR($B$4),MONTH(A9)+1,1)>A10<OPTION value='=IF(AND(DATE(YEAR(B$7),MONTH($A10),DAY($A10))>=$B$4,DATE(YEAR(B$7),MONTH($A10),DAY($A10))<=$B$5),$B$1*$B$2,"")'>B10<OPTION value='=IF(AND(DATE(YEAR(C$7),MONTH($A10),DAY($A10))>=$B$4,DATE(YEAR(C$7),MONTH($A10),DAY($A10))<=$B$5),$B$1*($B$2+ROUNDDOWN((COUNTIF($B$8:B$19,">0")+MONTH($A10)-1)/12,0.1)),"")'>C10<OPTION value='=IF(AND(DATE(YEAR(D$7),MONTH($A10),DAY($A10))>=$B$4,DATE(YEAR(D$7),MONTH($A10),DAY($A10))<=$B$5),$B$1*($B$2+ROUNDDOWN((COUNTIF($B$8:C$19,">0")+MONTH($A10)-1)/12,0.1)),"")'>D10<OPTION value='=IF(AND(DATE(YEAR(E$7),MONTH($A10),DAY($A10))>=$B$4,DATE(YEAR(E$7),MONTH($A10),DAY($A10))<=$B$5),$B$1*($B$2+ROUNDDOWN((COUNTIF($B$8:D$19,">0")+MONTH($A10)-1)/12,0.1)),"")'>E10<OPTION value='=IF(AND(DATE(YEAR(F$7),MONTH($A10),DAY($A10))>=$B$4,DATE(YEAR(F$7),MONTH($A10),DAY($A10))<=$B$5),$B$1*($B$2+ROUNDDOWN((COUNTIF($B$8:E$19,">0")+MONTH($A10)-1)/12,0.1)),"")'>F10<OPTION value='=IF(AND(DATE(YEAR(G$7),MONTH($A10),DAY($A10))>=$B$4,DATE(YEAR(G$7),MONTH($A10),DAY($A10))<=$B$5),$B$1*($B$2+ROUNDDOWN((COUNTIF($B$8:F$19,">0")+MONTH($A10)-1)/12,0.1)),"")'>G10<OPTION value='=IF(AND(DATE(YEAR(H$7),MONTH($A10),DAY($A10))>=$B$4,DATE(YEAR(H$7),MONTH($A10),DAY($A10))<=$B$5),$B$1*($B$2+ROUNDDOWN((COUNTIF($B$8:G$19,">0")+MONTH($A10)-1)/12,0.1)),"")'>H10<OPTION value='=IF(AND(DATE(YEAR(I$7),MONTH($A10),DAY($A10))>=$B$4,DATE(YEAR(I$7),MONTH($A10),DAY($A10))<=$B$5),$B$1*($B$2+ROUNDDOWN((COUNTIF($B$8:H$19,">0")+MONTH($A10)-1)/12,0.1)),"")'>I10<OPTION value='=IF(AND(DATE(YEAR(J$7),MONTH($A10),DAY($A10))>=$B$4,DATE(YEAR(J$7),MONTH($A10),DAY($A10))<=$B$5),$B$1*($B$2+ROUNDDOWN((COUNTIF($B$8:I$19,">0")+MONTH($A10)-1)/12,0.1)),"")'>J10<OPTION value='=IF(AND(DATE(YEAR(K$7),MONTH($A10),DAY($A10))>=$B$4,DATE(YEAR(K$7),MONTH($A10),DAY($A10))<=$B$5),$B$1*($B$2+ROUNDDOWN((COUNTIF($B$8:J$19,">0")+MONTH($A10)-1)/12,0.1)),"")'>K10<OPTION value==DATE(YEAR($B$4),MONTH(A10)+1,1)>A11<OPTION value='=IF(AND(DATE(YEAR(B$7),MONTH($A11),DAY($A11))>=$B$4,DATE(YEAR(B$7),MONTH($A11),DAY($A11))<=$B$5),$B$1*$B$2,"")'>B11<OPTION value='=IF(AND(DATE(YEAR(C$7),MONTH($A11),DAY($A11))>=$B$4,DATE(YEAR(C$7),MONTH($A11),DAY($A11))<=$B$5),$B$1*($B$2+ROUNDDOWN((COUNTIF($B$8:B$19,">0")+MONTH($A11)-1)/12,0.1)),"")'>C11<OPTION value='=IF(AND(DATE(YEAR(D$7),MONTH($A11),DAY($A11))>=$B$4,DATE(YEAR(D$7),MONTH($A11),DAY($A11))<=$B$5),$B$1*($B$2+ROUNDDOWN((COUNTIF($B$8:C$19,">0")+MONTH($A11)-1)/12,0.1)),"")'>D11<OPTION value='=IF(AND(DATE(YEAR(E$7),MONTH($A11),DAY($A11))>=$B$4,DATE(YEAR(E$7),MONTH($A11),DAY($A11))<=$B$5),$B$1*($B$2+ROUNDDOWN((COUNTIF($B$8:D$19,">0")+MONTH($A11)-1)/12,0.1)),"")'>E11<OPTION value='=IF(AND(DATE(YEAR(F$7),MONTH($A11),DAY($A11))>=$B$4,DATE(YEAR(F$7),MONTH($A11),DAY($A11))<=$B$5),$B$1*($B$2+ROUNDDOWN((COUNTIF($B$8:E$19,">0")+MONTH($A11)-1)/12,0.1)),"")'>F11<OPTION value='=IF(AND(DATE(YEAR(G$7),MONTH($A11),DAY($A11))>=$B$4,DATE(YEAR(G$7),MONTH($A11),DAY($A11))<=$B$5),$B$1*($B$2+ROUNDDOWN((COUNTIF($B$8:F$19,">0")+MONTH($A11)-1)/12,0.1)),"")'>G11<OPTION value='=IF(AND(DATE(YEAR(H$7),MONTH($A11),DAY($A11))>=$B$4,DATE(YEAR(H$7),MONTH($A11),DAY($A11))<=$B$5),$B$1*($B$2+ROUNDDOWN((COUNTIF($B$8:G$19,">0")+MONTH($A11)-1)/12,0.1)),"")'>H11<OPTION value='=IF(AND(DATE(YEAR(I$7),MONTH($A11),DAY($A11))>=$B$4,DATE(YEAR(I$7),MONTH($A11),DAY($A11))<=$B$5),$B$1*($B$2+ROUNDDOWN((COUNTIF($B$8:H$19,">0")+MONTH($A11)-1)/12,0.1)),"")'>I11<OPTION value='=IF(AND(DATE(YEAR(J$7),MONTH($A11),DAY($A11))>=$B$4,DATE(YEAR(J$7),MONTH($A11),DAY($A11))<=$B$5),$B$1*($B$2+ROUNDDOWN((COUNTIF($B$8:I$19,">0")+MONTH($A11)-1)/12,0.1)),"")'>J11<OPTION value='=IF(AND(DATE(YEAR(K$7),MONTH($A11),DAY($A11))>=$B$4,DATE(YEAR(K$7),MONTH($A11),DAY($A11))<=$B$5),$B$1*($B$2+ROUNDDOWN((COUNTIF($B$8:J$19,">0")+MONTH($A11)-1)/12,0.1)),"")'>K11<OPTION value==DATE(YEAR($B$4),MONTH(A11)+1,1)>A12<OPTION value='=IF(AND(DATE(YEAR(B$7),MONTH($A12),DAY($A12))>=$B$4,DATE(YEAR(B$7),MONTH($A12),DAY($A12))<=$B$5),$B$1*$B$2,"")'>B12<OPTION value='=IF(AND(DATE(YEAR(C$7),MONTH($A12),DAY($A12))>=$B$4,DATE(YEAR(C$7),MONTH($A12),DAY($A12))<=$B$5),$B$1*($B$2+ROUNDDOWN((COUNTIF($B$8:B$19,">0")+MONTH($A12)-1)/12,0.1)),"")'>C12<OPTION value='=IF(AND(DATE(YEAR(D$7),MONTH($A12),DAY($A12))>=$B$4,DATE(YEAR(D$7),MONTH($A12),DAY($A12))<=$B$5),$B$1*($B$2+ROUNDDOWN((COUNTIF($B$8:C$19,">0")+MONTH($A12)-1)/12,0.1)),"")'>D12<OPTION value='=IF(AND(DATE(YEAR(E$7),MONTH($A12),DAY($A12))>=$B$4,DATE(YEAR(E$7),MONTH($A12),DAY($A12))<=$B$5),$B$1*($B$2+ROUNDDOWN((COUNTIF($B$8:D$19,">0")+MONTH($A12)-1)/12,0.1)),"")'>E12<OPTION value='=IF(AND(DATE(YEAR(F$7),MONTH($A12),DAY($A12))>=$B$4,DATE(YEAR(F$7),MONTH($A12),DAY($A12))<=$B$5),$B$1*($B$2+ROUNDDOWN((COUNTIF($B$8:E$19,">0")+MONTH($A12)-1)/12,0.1)),"")'>F12<OPTION value='=IF(AND(DATE(YEAR(G$7),MONTH($A12),DAY($A12))>=$B$4,DATE(YEAR(G$7),MONTH($A12),DAY($A12))<=$B$5),$B$1*($B$2+ROUNDDOWN((COUNTIF($B$8:F$19,">0")+MONTH($A12)-1)/12,0.1)),"")'>G12<OPTION value='=IF(AND(DATE(YEAR(H$7),MONTH($A12),DAY($A12))>=$B$4,DATE(YEAR(H$7),MONTH($A12),DAY($A12))<=$B$5),$B$1*($B$2+ROUNDDOWN((COUNTIF($B$8:G$19,">0")+MONTH($A12)-1)/12,0.1)),"")'>H12<OPTION value='=IF(AND(DATE(YEAR(I$7),MONTH($A12),DAY($A12))>=$B$4,DATE(YEAR(I$7),MONTH($A12),DAY($A12))<=$B$5),$B$1*($B$2+ROUNDDOWN((COUNTIF($B$8:H$19,">0")+MONTH($A12)-1)/12,0.1)),"")'>I12<OPTION value='=IF(AND(DATE(YEAR(J$7),MONTH($A12),DAY($A12))>=$B$4,DATE(YEAR(J$7),MONTH($A12),DAY($A12))<=$B$5),$B$1*($B$2+ROUNDDOWN((COUNTIF($B$8:I$19,">0")+MONTH($A12)-1)/12,0.1)),"")'>J12<OPTION value='=IF(AND(DATE(YEAR(K$7),MONTH($A12),DAY($A12))>=$B$4,DATE(YEAR(K$7),MONTH($A12),DAY($A12))<=$B$5),$B$1*($B$2+ROUNDDOWN((COUNTIF($B$8:J$19,">0")+MONTH($A12)-1)/12,0.1)),"")'>K12<OPTION value==DATE(YEAR($B$4),MONTH(A12)+1,1)>A13<OPTION value='=IF(AND(DATE(YEAR(B$7),MONTH($A13),DAY($A13))>=$B$4,DATE(YEAR(B$7),MONTH($A13),DAY($A13))<=$B$5),$B$1*$B$2,"")'>B13<OPTION value='=IF(AND(DATE(YEAR(C$7),MONTH($A13),DAY($A13))>=$B$4,DATE(YEAR(C$7),MONTH($A13),DAY($A13))<=$B$5),$B$1*($B$2+ROUNDDOWN((COUNTIF($B$8:B$19,">0")+MONTH($A13)-1)/12,0.1)),"")'>C13<OPTION value='=IF(AND(DATE(YEAR(D$7),MONTH($A13),DAY($A13))>=$B$4,DATE(YEAR(D$7),MONTH($A13),DAY($A13))<=$B$5),$B$1*($B$2+ROUNDDOWN((COUNTIF($B$8:C$19,">0")+MONTH($A13)-1)/12,0.1)),"")'>D13<OPTION value='=IF(AND(DATE(YEAR(E$7),MONTH($A13),DAY($A13))>=$B$4,DATE(YEAR(E$7),MONTH($A13),DAY($A13))<=$B$5),$B$1*($B$2+ROUNDDOWN((COUNTIF($B$8:D$19,">0")+MONTH($A13)-1)/12,0.1)),"")'>E13<OPTION value='=IF(AND(DATE(YEAR(F$7),MONTH($A13),DAY($A13))>=$B$4,DATE(YEAR(F$7),MONTH($A13),DAY($A13))<=$B$5),$B$1*($B$2+ROUNDDOWN((COUNTIF($B$8:E$19,">0")+MONTH($A13)-1)/12,0.1)),"")'>F13<OPTION value='=IF(AND(DATE(YEAR(G$7),MONTH($A13),DAY($A13))>=$B$4,DATE(YEAR(G$7),MONTH($A13),DAY($A13))<=$B$5),$B$1*($B$2+ROUNDDOWN((COUNTIF($B$8:F$19,">0")+MONTH($A13)-1)/12,0.1)),"")'>G13<OPTION value='=IF(AND(DATE(YEAR(H$7),MONTH($A13),DAY($A13))>=$B$4,DATE(YEAR(H$7),MONTH($A13),DAY($A13))<=$B$5),$B$1*($B$2+ROUNDDOWN((COUNTIF($B$8:G$19,">0")+MONTH($A13)-1)/12,0.1)),"")'>H13<OPTION value='=IF(AND(DATE(YEAR(I$7),MONTH($A13),DAY($A13))>=$B$4,DATE(YEAR(I$7),MONTH($A13),DAY($A13))<=$B$5),$B$1*($B$2+ROUNDDOWN((COUNTIF($B$8:H$19,">0")+MONTH($A13)-1)/12,0.1)),"")'>I13<OPTION value='=IF(AND(DATE(YEAR(J$7),MONTH($A13),DAY($A13))>=$B$4,DATE(YEAR(J$7),MONTH($A13),DAY($A13))<=$B$5),$B$1*($B$2+ROUNDDOWN((COUNTIF($B$8:I$19,">0")+MONTH($A13)-1)/12,0.1)),"")'>J13<OPTION value='=IF(AND(DATE(YEAR(K$7),MONTH($A13),DAY($A13))>=$B$4,DATE(YEAR(K$7),MONTH($A13),DAY($A13))<=$B$5),$B$1*($B$2+ROUNDDOWN((COUNTIF($B$8:J$19,">0")+MONTH($A13)-1)/12,0.1)),"")'>K13<OPTION value==DATE(YEAR($B$4),MONTH(A13)+1,1)>A14<OPTION value='=IF(AND(DATE(YEAR(B$7),MONTH($A14),DAY($A14))>=$B$4,DATE(YEAR(B$7),MONTH($A14),DAY($A14))<=$B$5),$B$1*$B$2,"")'>B14<OPTION value='=IF(AND(DATE(YEAR(C$7),MONTH($A14),DAY($A14))>=$B$4,DATE(YEAR(C$7),MONTH($A14),DAY($A14))<=$B$5),$B$1*($B$2+ROUNDDOWN((COUNTIF($B$8:B$19,">0")+MONTH($A14)-1)/12,0.1)),"")'>C14<OPTION value='=IF(AND(DATE(YEAR(D$7),MONTH($A14),DAY($A14))>=$B$4,DATE(YEAR(D$7),MONTH($A14),DAY($A14))<=$B$5),$B$1*($B$2+ROUNDDOWN((COUNTIF($B$8:C$19,">0")+MONTH($A14)-1)/12,0.1)),"")'>D14<OPTION value='=IF(AND(DATE(YEAR(E$7),MONTH($A14),DAY($A14))>=$B$4,DATE(YEAR(E$7),MONTH($A14),DAY($A14))<=$B$5),$B$1*($B$2+ROUNDDOWN((COUNTIF($B$8:D$19,">0")+MONTH($A14)-1)/12,0.1)),"")'>E14<OPTION value='=IF(AND(DATE(YEAR(F$7),MONTH($A14),DAY($A14))>=$B$4,DATE(YEAR(F$7),MONTH($A14),DAY($A14))<=$B$5),$B$1*($B$2+ROUNDDOWN((COUNTIF($B$8:E$19,">0")+MONTH($A14)-1)/12,0.1)),"")'>F14<OPTION value='=IF(AND(DATE(YEAR(G$7),MONTH($A14),DAY($A14))>=$B$4,DATE(YEAR(G$7),MONTH($A14),DAY($A14))<=$B$5),$B$1*($B$2+ROUNDDOWN((COUNTIF($B$8:F$19,">0")+MONTH($A14)-1)/12,0.1)),"")'>G14<OPTION value='=IF(AND(DATE(YEAR(H$7),MONTH($A14),DAY($A14))>=$B$4,DATE(YEAR(H$7),MONTH($A14),DAY($A14))<=$B$5),$B$1*($B$2+ROUNDDOWN((COUNTIF($B$8:G$19,">0")+MONTH($A14)-1)/12,0.1)),"")'>H14<OPTION value='=IF(AND(DATE(YEAR(I$7),MONTH($A14),DAY($A14))>=$B$4,DATE(YEAR(I$7),MONTH($A14),DAY($A14))<=$B$5),$B$1*($B$2+ROUNDDOWN((COUNTIF($B$8:H$19,">0")+MONTH($A14)-1)/12,0.1)),"")'>I14<OPTION value='=IF(AND(DATE(YEAR(J$7),MONTH($A14),DAY($A14))>=$B$4,DATE(YEAR(J$7),MONTH($A14),DAY($A14))<=$B$5),$B$1*($B$2+ROUNDDOWN((COUNTIF($B$8:I$19,">0")+MONTH($A14)-1)/12,0.1)),"")'>J14<OPTION value='=IF(AND(DATE(YEAR(K$7),MONTH($A14),DAY($A14))>=$B$4,DATE(YEAR(K$7),MONTH($A14),DAY($A14))<=$B$5),$B$1*($B$2+ROUNDDOWN((COUNTIF($B$8:J$19,">0")+MONTH($A14)-1)/12,0.1)),"")'>K14<OPTION value==DATE(YEAR($B$4),MONTH(A14)+1,1)>A15<OPTION value='=IF(AND(DATE(YEAR(B$7),MONTH($A15),DAY($A15))>=$B$4,DATE(YEAR(B$7),MONTH($A15),DAY($A15))<=$B$5),$B$1*$B$2,"")'>B15<OPTION value='=IF(AND(DATE(YEAR(C$7),MONTH($A15),DAY($A15))>=$B$4,DATE(YEAR(C$7),MONTH($A15),DAY($A15))<=$B$5),$B$1*($B$2+ROUNDDOWN((COUNTIF($B$8:B$19,">0")+MONTH($A15)-1)/12,0.1)),"")'>C15<OPTION value='=IF(AND(DATE(YEAR(D$7),MONTH($A15),DAY($A15))>=$B$4,DATE(YEAR(D$7),MONTH($A15),DAY($A15))<=$B$5),$B$1*($B$2+ROUNDDOWN((COUNTIF($B$8:C$19,">0")+MONTH($A15)-1)/12,0.1)),"")'>D15<OPTION value='=IF(AND(DATE(YEAR(E$7),MONTH($A15),DAY($A15))>=$B$4,DATE(YEAR(E$7),MONTH($A15),DAY($A15))<=$B$5),$B$1*($B$2+ROUNDDOWN((COUNTIF($B$8:D$19,">0")+MONTH($A15)-1)/12,0.1)),"")'>E15<OPTION value='=IF(AND(DATE(YEAR(F$7),MONTH($A15),DAY($A15))>=$B$4,DATE(YEAR(F$7),MONTH($A15),DAY($A15))<=$B$5),$B$1*($B$2+ROUNDDOWN((COUNTIF($B$8:E$19,">0")+MONTH($A15)-1)/12,0.1)),"")'>F15<OPTION value='=IF(AND(DATE(YEAR(G$7),MONTH($A15),DAY($A15))>=$B$4,DATE(YEAR(G$7),MONTH($A15),DAY($A15))<=$B$5),$B$1*($B$2+ROUNDDOWN((COUNTIF($B$8:F$19,">0")+MONTH($A15)-1)/12,0.1)),"")'>G15<OPTION value='=IF(AND(DATE(YEAR(H$7),MONTH($A15),DAY($A15))>=$B$4,DATE(YEAR(H$7),MONTH($A15),DAY($A15))<=$B$5),$B$1*($B$2+ROUNDDOWN((COUNTIF($B$8:G$19,">0")+MONTH($A15)-1)/12,0.1)),"")'>H15<OPTION value='=IF(AND(DATE(YEAR(I$7),MONTH($A15),DAY($A15))>=$B$4,DATE(YEAR(I$7),MONTH($A15),DAY($A15))<=$B$5),$B$1*($B$2+ROUNDDOWN((COUNTIF($B$8:H$19,">0")+MONTH($A15)-1)/12,0.1)),"")'>I15<OPTION value='=IF(AND(DATE(YEAR(J$7),MONTH($A15),DAY($A15))>=$B$4,DATE(YEAR(J$7),MONTH($A15),DAY($A15))<=$B$5),$B$1*($B$2+ROUNDDOWN((COUNTIF($B$8:I$19,">0")+MONTH($A15)-1)/12,0.1)),"")'>J15<OPTION value='=IF(AND(DATE(YEAR(K$7),MONTH($A15),DAY($A15))>=$B$4,DATE(YEAR(K$7),MONTH($A15),DAY($A15))<=$B$5),$B$1*($B$2+ROUNDDOWN((COUNTIF($B$8:J$19,">0")+MONTH($A15)-1)/12,0.1)),"")'>K15<OPTION value==DATE(YEAR($B$4),MONTH(A15)+1,1)>A16<OPTION value='=IF(AND(DATE(YEAR(B$7),MONTH($A16),DAY($A16))>=$B$4,DATE(YEAR(B$7),MONTH($A16),DAY($A16))<=$B$5),$B$1*$B$2,"")'>B16<OPTION value='=IF(AND(DATE(YEAR(C$7),MONTH($A16),DAY($A16))>=$B$4,DATE(YEAR(C$7),MONTH($A16),DAY($A16))<=$B$5),$B$1*($B$2+ROUNDDOWN((COUNTIF($B$8:B$19,">0")+MONTH($A16)-1)/12,0.1)),"")'>C16<OPTION value='=IF(AND(DATE(YEAR(D$7),MONTH($A16),DAY($A16))>=$B$4,DATE(YEAR(D$7),MONTH($A16),DAY($A16))<=$B$5),$B$1*($B$2+ROUNDDOWN((COUNTIF($B$8:C$19,">0")+MONTH($A16)-1)/12,0.1)),"")'>D16<OPTION value='=IF(AND(DATE(YEAR(E$7),MONTH($A16),DAY($A16))>=$B$4,DATE(YEAR(E$7),MONTH($A16),DAY($A16))<=$B$5),$B$1*($B$2+ROUNDDOWN((COUNTIF($B$8:D$19,">0")+MONTH($A16)-1)/12,0.1)),"")'>E16<OPTION value='=IF(AND(DATE(YEAR(F$7),MONTH($A16),DAY($A16))>=$B$4,DATE(YEAR(F$7),MONTH($A16),DAY($A16))<=$B$5),$B$1*($B$2+ROUNDDOWN((COUNTIF($B$8:E$19,">0")+MONTH($A16)-1)/12,0.1)),"")'>F16<OPTION value='=IF(AND(DATE(YEAR(G$7),MONTH($A16),DAY($A16))>=$B$4,DATE(YEAR(G$7),MONTH($A16),DAY($A16))<=$B$5),$B$1*($B$2+ROUNDDOWN((COUNTIF($B$8:F$19,">0")+MONTH($A16)-1)/12,0.1)),"")'>G16<OPTION value='=IF(AND(DATE(YEAR(H$7),MONTH($A16),DAY($A16))>=$B$4,DATE(YEAR(H$7),MONTH($A16),DAY($A16))<=$B$5),$B$1*($B$2+ROUNDDOWN((COUNTIF($B$8:G$19,">0")+MONTH($A16)-1)/12,0.1)),"")'>H16<OPTION value='=IF(AND(DATE(YEAR(I$7),MONTH($A16),DAY($A16))>=$B$4,DATE(YEAR(I$7),MONTH($A16),DAY($A16))<=$B$5),$B$1*($B$2+ROUNDDOWN((COUNTIF($B$8:H$19,">0")+MONTH($A16)-1)/12,0.1)),"")'>I16<OPTION value='=IF(AND(DATE(YEAR(J$7),MONTH($A16),DAY($A16))>=$B$4,DATE(YEAR(J$7),MONTH($A16),DAY($A16))<=$B$5),$B$1*($B$2+ROUNDDOWN((COUNTIF($B$8:I$19,">0")+MONTH($A16)-1)/12,0.1)),"")'>J16<OPTION value='=IF(AND(DATE(YEAR(K$7),MONTH($A16),DAY($A16))>=$B$4,DATE(YEAR(K$7),MONTH($A16),DAY($A16))<=$B$5),$B$1*($B$2+ROUNDDOWN((COUNTIF($B$8:J$19,">0")+MONTH($A16)-1)/12,0.1)),"")'>K16<OPTION value==DATE(YEAR($B$4),MONTH(A16)+1,1)>A17<OPTION value='=IF(AND(DATE(YEAR(B$7),MONTH($A17),DAY($A17))>=$B$4,DATE(YEAR(B$7),MONTH($A17),DAY($A17))<=$B$5),$B$1*$B$2,"")'>B17<OPTION value='=IF(AND(DATE(YEAR(C$7),MONTH($A17),DAY($A17))>=$B$4,DATE(YEAR(C$7),MONTH($A17),DAY($A17))<=$B$5),$B$1*($B$2+ROUNDDOWN((COUNTIF($B$8:B$19,">0")+MONTH($A17)-1)/12,0.1)),"")'>C17<OPTION value='=IF(AND(DATE(YEAR(D$7),MONTH($A17),DAY($A17))>=$B$4,DATE(YEAR(D$7),MONTH($A17),DAY($A17))<=$B$5),$B$1*($B$2+ROUNDDOWN((COUNTIF($B$8:C$19,">0")+MONTH($A17)-1)/12,0.1)),"")'>D17<OPTION value='=IF(AND(DATE(YEAR(E$7),MONTH($A17),DAY($A17))>=$B$4,DATE(YEAR(E$7),MONTH($A17),DAY($A17))<=$B$5),$B$1*($B$2+ROUNDDOWN((COUNTIF($B$8:D$19,">0")+MONTH($A17)-1)/12,0.1)),"")'>E17<OPTION value='=IF(AND(DATE(YEAR(F$7),MONTH($A17),DAY($A17))>=$B$4,DATE(YEAR(F$7),MONTH($A17),DAY($A17))<=$B$5),$B$1*($B$2+ROUNDDOWN((COUNTIF($B$8:E$19,">0")+MONTH($A17)-1)/12,0.1)),"")'>F17<OPTION value='=IF(AND(DATE(YEAR(G$7),MONTH($A17),DAY($A17))>=$B$4,DATE(YEAR(G$7),MONTH($A17),DAY($A17))<=$B$5),$B$1*($B$2+ROUNDDOWN((COUNTIF($B$8:F$19,">0")+MONTH($A17)-1)/12,0.1)),"")'>G17<OPTION value='=IF(AND(DATE(YEAR(H$7),MONTH($A17),DAY($A17))>=$B$4,DATE(YEAR(H$7),MONTH($A17),DAY($A17))<=$B$5),$B$1*($B$2+ROUNDDOWN((COUNTIF($B$8:G$19,">0")+MONTH($A17)-1)/12,0.1)),"")'>H17<OPTION value='=IF(AND(DATE(YEAR(I$7),MONTH($A17),DAY($A17))>=$B$4,DATE(YEAR(I$7),MONTH($A17),DAY($A17))<=$B$5),$B$1*($B$2+ROUNDDOWN((COUNTIF($B$8:H$19,">0")+MONTH($A17)-1)/12,0.1)),"")'>I17<OPTION value='=IF(AND(DATE(YEAR(J$7),MONTH($A17),DAY($A17))>=$B$4,DATE(YEAR(J$7),MONTH($A17),DAY($A17))<=$B$5),$B$1*($B$2+ROUNDDOWN((COUNTIF($B$8:I$19,">0")+MONTH($A17)-1)/12,0.1)),"")'>J17<OPTION value='=IF(AND(DATE(YEAR(K$7),MONTH($A17),DAY($A17))>=$B$4,DATE(YEAR(K$7),MONTH($A17),DAY($A17))<=$B$5),$B$1*($B$2+ROUNDDOWN((COUNTIF($B$8:J$19,">0")+MONTH($A17)-1)/12,0.1)),"")'>K17<OPTION value==DATE(YEAR($B$4),MONTH(A17)+1,1)>A18<OPTION value='=IF(AND(DATE(YEAR(B$7),MONTH($A18),DAY($A18))>=$B$4,DATE(YEAR(B$7),MONTH($A18),DAY($A18))<=$B$5),$B$1*$B$2,"")'>B18<OPTION value='=IF(AND(DATE(YEAR(C$7),MONTH($A18),DAY($A18))>=$B$4,DATE(YEAR(C$7),MONTH($A18),DAY($A18))<=$B$5),$B$1*($B$2+ROUNDDOWN((COUNTIF($B$8:B$19,">0")+MONTH($A18)-1)/12,0.1)),"")'>C18<OPTION value='=IF(AND(DATE(YEAR(D$7),MONTH($A18),DAY($A18))>=$B$4,DATE(YEAR(D$7),MONTH($A18),DAY($A18))<=$B$5),$B$1*($B$2+ROUNDDOWN((COUNTIF($B$8:C$19,">0")+MONTH($A18)-1)/12,0.1)),"")'>D18<OPTION value='=IF(AND(DATE(YEAR(E$7),MONTH($A18),DAY($A18))>=$B$4,DATE(YEAR(E$7),MONTH($A18),DAY($A18))<=$B$5),$B$1*($B$2+ROUNDDOWN((COUNTIF($B$8:D$19,">0")+MONTH($A18)-1)/12,0.1)),"")'>E18<OPTION value='=IF(AND(DATE(YEAR(F$7),MONTH($A18),DAY($A18))>=$B$4,DATE(YEAR(F$7),MONTH($A18),DAY($A18))<=$B$5),$B$1*($B$2+ROUNDDOWN((COUNTIF($B$8:E$19,">0")+MONTH($A18)-1)/12,0.1)),"")'>F18<OPTION value='=IF(AND(DATE(YEAR(G$7),MONTH($A18),DAY($A18))>=$B$4,DATE(YEAR(G$7),MONTH($A18),DAY($A18))<=$B$5),$B$1*($B$2+ROUNDDOWN((COUNTIF($B$8:F$19,">0")+MONTH($A18)-1)/12,0.1)),"")'>G18<OPTION value='=IF(AND(DATE(YEAR(H$7),MONTH($A18),DAY($A18))>=$B$4,DATE(YEAR(H$7),MONTH($A18),DAY($A18))<=$B$5),$B$1*($B$2+ROUNDDOWN((COUNTIF($B$8:G$19,">0")+MONTH($A18)-1)/12,0.1)),"")'>H18<OPTION value='=IF(AND(DATE(YEAR(I$7),MONTH($A18),DAY($A18))>=$B$4,DATE(YEAR(I$7),MONTH($A18),DAY($A18))<=$B$5),$B$1*($B$2+ROUNDDOWN((COUNTIF($B$8:H$19,">0")+MONTH($A18)-1)/12,0.1)),"")'>I18<OPTION value='=IF(AND(DATE(YEAR(J$7),MONTH($A18),DAY($A18))>=$B$4,DATE(YEAR(J$7),MONTH($A18),DAY($A18))<=$B$5),$B$1*($B$2+ROUNDDOWN((COUNTIF($B$8:I$19,">0")+MONTH($A18)-1)/12,0.1)),"")'>J18<OPTION value='=IF(AND(DATE(YEAR(K$7),MONTH($A18),DAY($A18))>=$B$4,DATE(YEAR(K$7),MONTH($A18),DAY($A18))<=$B$5),$B$1*($B$2+ROUNDDOWN((COUNTIF($B$8:J$19,">0")+MONTH($A18)-1)/12,0.1)),"")'>K18<OPTION value==DATE(YEAR($B$4),MONTH(A18)+1,1)>A19<OPTION value='=IF(AND(DATE(YEAR(B$7),MONTH($A19),DAY($A19))>=$B$4,DATE(YEAR(B$7),MONTH($A19),DAY($A19))<=$B$5),$B$1*$B$2,"")'>B19<OPTION value='=IF(AND(DATE(YEAR(C$7),MONTH($A19),DAY($A19))>=$B$4,DATE(YEAR(C$7),MONTH($A19),DAY($A19))<=$B$5),$B$1*($B$2+ROUNDDOWN((COUNTIF($B$8:B$19,">0")+MONTH($A19)-1)/12,0.1)),"")'>C19<OPTION value='=IF(AND(DATE(YEAR(D$7),MONTH($A19),DAY($A19))>=$B$4,DATE(YEAR(D$7),MONTH($A19),DAY($A19))<=$B$5),$B$1*($B$2+ROUNDDOWN((COUNTIF($B$8:C$19,">0")+MONTH($A19)-1)/12,0.1)),"")'>D19<OPTION value='=IF(AND(DATE(YEAR(E$7),MONTH($A19),DAY($A19))>=$B$4,DATE(YEAR(E$7),MONTH($A19),DAY($A19))<=$B$5),$B$1*($B$2+ROUNDDOWN((COUNTIF($B$8:D$19,">0")+MONTH($A19)-1)/12,0.1)),"")'>E19<OPTION value='=IF(AND(DATE(YEAR(F$7),MONTH($A19),DAY($A19))>=$B$4,DATE(YEAR(F$7),MONTH($A19),DAY($A19))<=$B$5),$B$1*($B$2+ROUNDDOWN((COUNTIF($B$8:E$19,">0")+MONTH($A19)-1)/12,0.1)),"")'>F19<OPTION value='=IF(AND(DATE(YEAR(G$7),MONTH($A19),DAY($A19))>=$B$4,DATE(YEAR(G$7),MONTH($A19),DAY($A19))<=$B$5),$B$1*($B$2+ROUNDDOWN((COUNTIF($B$8:F$19,">0")+MONTH($A19)-1)/12,0.1)),"")'>G19<OPTION value='=IF(AND(DATE(YEAR(H$7),MONTH($A19),DAY($A19))>=$B$4,DATE(YEAR(H$7),MONTH($A19),DAY($A19))<=$B$5),$B$1*($B$2+ROUNDDOWN((COUNTIF($B$8:G$19,">0")+MONTH($A19)-1)/12,0.1)),"")'>H19<OPTION value='=IF(AND(DATE(YEAR(I$7),MONTH($A19),DAY($A19))>=$B$4,DATE(YEAR(I$7),MONTH($A19),DAY($A19))<=$B$5),$B$1*($B$2+ROUNDDOWN((COUNTIF($B$8:H$19,">0")+MONTH($A19)-1)/12,0.1)),"")'>I19<OPTION value='=IF(AND(DATE(YEAR(J$7),MONTH($A19),DAY($A19))>=$B$4,DATE(YEAR(J$7),MONTH($A19),DAY($A19))<=$B$5),$B$1*($B$2+ROUNDDOWN((COUNTIF($B$8:I$19,">0")+MONTH($A19)-1)/12,0.1)),"")'>J19<OPTION value='=IF(AND(DATE(YEAR(K$7),MONTH($A19),DAY($A19))>=$B$4,DATE(YEAR(K$7),MONTH($A19),DAY($A19))<=$B$5),$B$1*($B$2+ROUNDDOWN((COUNTIF($B$8:J$19,">0")+MONTH($A19)-1)/12,0.1)),"")'>K19</OPTION></SELECT></TD><TD align=right width="3%" bgColor=#d4d0c8>=</TD><TD align=left bgColor=white><INPUT size=120 value==DATE(YEAR(B4),1,1) name=txbFb6925></TD></FORM></TR></TBODY></TABLE></TD></TR><TR><TD align=middle width="1%" bgColor=#d4d0c8>
</TD><TD align=middle bgColor=#d4d0c8><CENTER>A</CENTER></TD><TD align=middle bgColor=#d4d0c8><CENTER>B</CENTER></TD><TD align=middle bgColor=#d4d0c8><CENTER>C</CENTER></TD><TD align=middle bgColor=#d4d0c8><CENTER>D</CENTER></TD><TD align=middle bgColor=#d4d0c8><CENTER>E</CENTER></TD><TD align=middle bgColor=#d4d0c8><CENTER>F</CENTER></TD><TD align=middle bgColor=#d4d0c8><CENTER>G</CENTER></TD><TD align=middle bgColor=#d4d0c8><CENTER>H</CENTER></TD><TD align=middle bgColor=#d4d0c8><CENTER>I</CENTER></TD><TD align=middle bgColor=#d4d0c8><CENTER>J</CENTER></TD><TD align=middle bgColor=#d4d0c8><CENTER>K</CENTER></TD></TR><TR><TD align=middle width="1%" bgColor=#d4d0c8><CENTER>1</CENTER></TD><TD vAlign=bottom align=left bgColor=#ffffff><FONT face=Arial color=#000000>Sq Ft:</FONT></TD><TD vAlign=bottom align=right bgColor=#ffffff><FONT face=Arial color=#000000>200</FONT></TD><TD bgColor=#ffffff>
</TD><TD bgColor=#ffffff>
</TD><TD bgColor=#ffffff>
</TD><TD bgColor=#ffffff>
</TD><TD bgColor=#ffffff>
</TD><TD bgColor=#ffffff>
</TD><TD bgColor=#ffffff>
</TD><TD bgColor=#ffffff>
</TD><TD bgColor=#ffffff>
</TD></TR><TR><TD align=middle width="1%" bgColor=#d4d0c8><CENTER>2</CENTER></TD><TD vAlign=bottom align=left bgColor=#ffffff><FONT face=Arial color=#000000>rent/Sq Ft</FONT></TD><TD vAlign=bottom align=right bgColor=#ffffff><FONT face=Arial color=#000000>10</FONT></TD><TD bgColor=#ffffff>
</TD><TD bgColor=#ffffff>
</TD><TD bgColor=#ffffff>
</TD><TD bgColor=#ffffff>
</TD><TD bgColor=#ffffff>
</TD><TD bgColor=#ffffff>
</TD><TD bgColor=#ffffff>
</TD><TD bgColor=#ffffff>
</TD><TD bgColor=#ffffff>
</TD></TR><TR><TD align=middle width="1%" bgColor=#d4d0c8><CENTER>3</CENTER></TD><TD vAlign=bottom align=left bgColor=#ffffff><FONT face=Arial color=#000000>Annual Esc Rate</FONT></TD><TD vAlign=bottom align=right bgColor=#ffffff><FONT face=Arial color=#000000>1</FONT></TD><TD bgColor=#ffffff>
</TD><TD bgColor=#ffffff>
</TD><TD bgColor=#ffffff>
</TD><TD bgColor=#ffffff>
</TD><TD bgColor=#ffffff>
</TD><TD bgColor=#ffffff>
</TD><TD bgColor=#ffffff>
</TD><TD bgColor=#ffffff>
</TD><TD bgColor=#ffffff>
</TD></TR><TR><TD align=middle width="1%" bgColor=#d4d0c8><CENTER>4</CENTER></TD><TD vAlign=bottom align=left bgColor=#ffffff><FONT face=Arial color=#000000>Begin</FONT></TD><TD vAlign=bottom align=right bgColor=#ffffff><FONT face=Arial color=#000000>2/1/2003</FONT></TD><TD bgColor=#ffffff>
</TD><TD bgColor=#ffffff>
</TD><TD bgColor=#ffffff>
</TD><TD bgColor=#ffffff>
</TD><TD bgColor=#ffffff>
</TD><TD bgColor=#ffffff>
</TD><TD bgColor=#ffffff>
</TD><TD bgColor=#ffffff>
</TD><TD bgColor=#ffffff>
</TD></TR><TR><TD align=middle width="1%" bgColor=#d4d0c8><CENTER>5</CENTER></TD><TD vAlign=bottom align=left bgColor=#ffffff><FONT face=Arial color=#000000>End</FONT></TD><TD vAlign=bottom align=right bgColor=#ffffff><FONT face=Arial color=#000000>9/30/2007</FONT></TD><TD bgColor=#ffffff>
</TD><TD bgColor=#ffffff>
</TD><TD bgColor=#ffffff>
</TD><TD bgColor=#ffffff>
</TD><TD bgColor=#ffffff>
</TD><TD bgColor=#ffffff>
</TD><TD bgColor=#ffffff>
</TD><TD bgColor=#ffffff>
</TD><TD bgColor=#ffffff>
</TD></TR><TR><TD align=middle width="1%" bgColor=#d4d0c8><CENTER>6</CENTER></TD><TD bgColor=#ffffff>
</TD><TD bgColor=#ffffff>
</TD><TD bgColor=#ffffff>
</TD><TD bgColor=#ffffff>
</TD><TD bgColor=#ffffff>
</TD><TD bgColor=#ffffff>
</TD><TD bgColor=#ffffff>
</TD><TD bgColor=#ffffff>
</TD><TD bgColor=#ffffff>
</TD><TD bgColor=#ffffff>
</TD><TD bgColor=#ffffff>
</TD></TR><TR><TD align=middle width="1%" bgColor=#d4d0c8><CENTER>7</CENTER></TD><TD bgColor=#ffffff>
</TD><TD vAlign=bottom align=right bgColor=#ffffff><FONT face=Arial color=#000000>2003</FONT></TD><TD vAlign=bottom align=right bgColor=#ffffff><FONT face=Arial color=#000000>2004</FONT></TD><TD vAlign=bottom align=right bgColor=#ffffff><FONT face=Arial color=#000000>2005</FONT></TD><TD vAlign=bottom align=right bgColor=#ffffff><FONT face=Arial color=#000000>2006</FONT></TD><TD vAlign=bottom align=right bgColor=#ffffff><FONT face=Arial color=#000000>2007</FONT></TD><TD vAlign=bottom align=right bgColor=#ffffff><FONT face=Arial color=#000000>2008</FONT></TD><TD vAlign=bottom align=right bgColor=#ffffff><FONT face=Arial color=#000000>2009</FONT></TD><TD vAlign=bottom align=right bgColor=#ffffff><FONT face=Arial color=#000000>2010</FONT></TD><TD vAlign=bottom align=right bgColor=#ffffff><FONT face=Arial color=#000000>2011</FONT></TD><TD vAlign=bottom align=right bgColor=#ffffff><FONT face=Arial color=#000000>2012</FONT></TD></TR><TR><TD align=middle width="1%" bgColor=#d4d0c8><CENTER>8</CENTER></TD><TD vAlign=bottom align=right bgColor=#ffffff><FONT face=Arial color=#000000>January</FONT></TD><TD vAlign=bottom align=left bgColor=#ffffff><FONT face=Arial color=#000000></FONT></TD><TD vAlign=bottom align=right bgColor=#ffffff><FONT face=Arial color=#000000>$ 2,000 </FONT></TD><TD vAlign=bottom align=right bgColor=#ffffff><FONT face=Arial color=#000000>$ 2,200 </FONT></TD><TD vAlign=bottom align=right bgColor=#ffffff><FONT face=Arial color=#000000>$ 2,400 </FONT></TD><TD vAlign=bottom align=right bgColor=#ffffff><FONT face=Arial color=#000000>$ 2,600 </FONT></TD><TD vAlign=bottom align=left bgColor=#ffffff><FONT face=Arial color=#000000></FONT></TD><TD vAlign=bottom align=left bgColor=#ffffff><FONT face=Arial color=#000000></FONT></TD><TD vAlign=bottom align=left bgColor=#ffffff><FONT face=Arial color=#000000></FONT></TD><TD vAlign=bottom align=left bgColor=#ffffff><FONT face=Arial color=#000000></FONT></TD><TD vAlign=bottom align=left bgColor=#ffffff><FONT face=Arial color=#000000></FONT></TD></TR><TR><TD align=middle width="1%" bgColor=#d4d0c8><CENTER>9</CENTER></TD><TD vAlign=bottom align=right bgColor=#ffffff><FONT face=Arial color=#000000>February</FONT></TD><TD vAlign=bottom align=right bgColor=#ffffff><FONT face=Arial color=#000000>$ 2,000 </FONT></TD><TD vAlign=bottom align=right bgColor=#ffffff><FONT face=Arial color=#000000>$ 2,200 </FONT></TD><TD vAlign=bottom align=right bgColor=#ffffff><FONT face=Arial color=#000000>$ 2,400 </FONT></TD><TD vAlign=bottom align=right bgColor=#ffffff><FONT face=Arial color=#000000>$ 2,600 </FONT></TD><TD vAlign=bottom align=right bgColor=#ffffff><FONT face=Arial color=#000000>$ 2,800 </FONT></TD><TD vAlign=bottom align=left bgColor=#ffffff><FONT face=Arial color=#000000></FONT></TD><TD vAlign=bottom align=left bgColor=#ffffff><FONT face=Arial color=#000000></FONT></TD><TD vAlign=bottom align=left bgColor=#ffffff><FONT face=Arial color=#000000></FONT></TD><TD vAlign=bottom align=left bgColor=#ffffff><FONT face=Arial color=#000000></FONT></TD><TD vAlign=bottom align=left bgColor=#ffffff><FONT face=Arial color=#000000></FONT></TD></TR><TR><TD align=middle width="1%" bgColor=#d4d0c8><CENTER>10</CENTER></TD><TD vAlign=bottom align=right bgColor=#ffffff><FONT face=Arial color=#000000>March</FONT></TD><TD vAlign=bottom align=right bgColor=#ffffff><FONT face=Arial color=#000000>$ 2,000 </FONT></TD><TD vAlign=bottom align=right bgColor=#ffffff><FONT face=Arial color=#000000>$ 2,200 </FONT></TD><TD vAlign=bottom align=right bgColor=#ffffff><FONT face=Arial color=#000000>$ 2,400 </FONT></TD><TD vAlign=bottom align=right bgColor=#ffffff><FONT face=Arial color=#000000>$ 2,600 </FONT></TD><TD vAlign=bottom align=right bgColor=#ffffff><FONT face=Arial color=#000000>$ 2,800 </FONT></TD><TD vAlign=bottom align=left bgColor=#ffffff><FONT face=Arial color=#000000></FONT></TD><TD vAlign=bottom align=left bgColor=#ffffff><FONT face=Arial color=#000000></FONT></TD><TD vAlign=bottom align=left bgColor=#ffffff><FONT face=Arial color=#000000></FONT></TD><TD vAlign=bottom align=left bgColor=#ffffff><FONT face=Arial color=#000000></FONT></TD><TD vAlign=bottom align=left bgColor=#ffffff><FONT face=Arial color=#000000></FONT></TD></TR><TR><TD align=middle width="1%" bgColor=#d4d0c8><CENTER>11</CENTER></TD><TD vAlign=bottom align=right bgColor=#ffffff><FONT face=Arial color=#000000>April</FONT></TD><TD vAlign=bottom align=right bgColor=#ffffff><FONT face=Arial color=#000000>$ 2,000 </FONT></TD><TD vAlign=bottom align=right bgColor=#ffffff><FONT face=Arial color=#000000>$ 2,200 </FONT></TD><TD vAlign=bottom align=right bgColor=#ffffff><FONT face=Arial color=#000000>$ 2,400 </FONT></TD><TD vAlign=bottom align=right bgColor=#ffffff><FONT face=Arial color=#000000>$ 2,600 </FONT></TD><TD vAlign=bottom align=right bgColor=#ffffff><FONT face=Arial color=#000000>$ 2,800 </FONT></TD><TD vAlign=bottom align=left bgColor=#ffffff><FONT face=Arial color=#000000></FONT></TD><TD vAlign=bottom align=left bgColor=#ffffff><FONT face=Arial color=#000000></FONT></TD><TD vAlign=bottom align=left bgColor=#ffffff><FONT face=Arial color=#000000></FONT></TD><TD vAlign=bottom align=left bgColor=#ffffff><FONT face=Arial color=#000000></FONT></TD><TD vAlign=bottom align=left bgColor=#ffffff><FONT face=Arial color=#000000></FONT></TD></TR><TR><TD align=middle width="1%" bgColor=#d4d0c8><CENTER>12</CENTER></TD><TD vAlign=bottom align=right bgColor=#ffffff><FONT face=Arial color=#000000>May</FONT></TD><TD vAlign=bottom align=right bgColor=#ffffff><FONT face=Arial color=#000000>$ 2,000 </FONT></TD><TD vAlign=bottom align=right bgColor=#ffffff><FONT face=Arial color=#000000>$ 2,200 </FONT></TD><TD vAlign=bottom align=right bgColor=#ffffff><FONT face=Arial color=#000000>$ 2,400 </FONT></TD><TD vAlign=bottom align=right bgColor=#ffffff><FONT face=Arial color=#000000>$ 2,600 </FONT></TD><TD vAlign=bottom align=right bgColor=#ffffff><FONT face=Arial color=#000000>$ 2,800 </FONT></TD><TD vAlign=bottom align=left bgColor=#ffffff><FONT face=Arial color=#000000></FONT></TD><TD vAlign=bottom align=left bgColor=#ffffff><FONT face=Arial color=#000000></FONT></TD><TD vAlign=bottom align=left bgColor=#ffffff><FONT face=Arial color=#000000></FONT></TD><TD vAlign=bottom align=left bgColor=#ffffff><FONT face=Arial color=#000000></FONT></TD><TD vAlign=bottom align=left bgColor=#ffffff><FONT face=Arial color=#000000></FONT></TD></TR><TR><TD align=middle width="1%" bgColor=#d4d0c8><CENTER>13</CENTER></TD><TD vAlign=bottom align=right bgColor=#ffffff><FONT face=Arial color=#000000>June</FONT></TD><TD vAlign=bottom align=right bgColor=#ffffff><FONT face=Arial color=#000000>$ 2,000 </FONT></TD><TD vAlign=bottom align=right bgColor=#ffffff><FONT face=Arial color=#000000>$ 2,200 </FONT></TD><TD vAlign=bottom align=right bgColor=#ffffff><FONT face=Arial color=#000000>$ 2,400 </FONT></TD><TD vAlign=bottom align=right bgColor=#ffffff><FONT face=Arial color=#000000>$ 2,600 </FONT></TD><TD vAlign=bottom align=right bgColor=#ffffff><FONT face=Arial color=#000000>$ 2,800 </FONT></TD><TD vAlign=bottom align=left bgColor=#ffffff><FONT face=Arial color=#000000></FONT></TD><TD vAlign=bottom align=left bgColor=#ffffff><FONT face=Arial color=#000000></FONT></TD><TD vAlign=bottom align=left bgColor=#ffffff><FONT face=Arial color=#000000></FONT></TD><TD vAlign=bottom align=left bgColor=#ffffff><FONT face=Arial color=#000000></FONT></TD><TD vAlign=bottom align=left bgColor=#ffffff><FONT face=Arial color=#000000></FONT></TD></TR><TR><TD align=middle width="1%" bgColor=#d4d0c8><CENTER>14</CENTER></TD><TD vAlign=bottom align=right bgColor=#ffffff><FONT face=Arial color=#000000>July</FONT></TD><TD vAlign=bottom align=right bgColor=#ffffff><FONT face=Arial color=#000000>$ 2,000 </FONT></TD><TD vAlign=bottom align=right bgColor=#ffffff><FONT face=Arial color=#000000>$ 2,200 </FONT></TD><TD vAlign=bottom align=right bgColor=#ffffff><FONT face=Arial color=#000000>$ 2,400 </FONT></TD><TD vAlign=bottom align=right bgColor=#ffffff><FONT face=Arial color=#000000>$ 2,600 </FONT></TD><TD vAlign=bottom align=right bgColor=#ffffff><FONT face=Arial color=#000000>$ 2,800 </FONT></TD><TD vAlign=bottom align=left bgColor=#ffffff><FONT face=Arial color=#000000></FONT></TD><TD vAlign=bottom align=left bgColor=#ffffff><FONT face=Arial color=#000000></FONT></TD><TD vAlign=bottom align=left bgColor=#ffffff><FONT face=Arial color=#000000></FONT></TD><TD vAlign=bottom align=left bgColor=#ffffff><FONT face=Arial color=#000000></FONT></TD><TD vAlign=bottom align=left bgColor=#ffffff><FONT face=Arial color=#000000></FONT></TD></TR><TR><TD align=middle width="1%" bgColor=#d4d0c8><CENTER>15</CENTER></TD><TD vAlign=bottom align=right bgColor=#ffffff><FONT face=Arial color=#000000>August</FONT></TD><TD vAlign=bottom align=right bgColor=#ffffff><FONT face=Arial color=#000000>$ 2,000 </FONT></TD><TD vAlign=bottom align=right bgColor=#ffffff><FONT face=Arial color=#000000>$ 2,200 </FONT></TD><TD vAlign=bottom align=right bgColor=#ffffff><FONT face=Arial color=#000000>$ 2,400 </FONT></TD><TD vAlign=bottom align=right bgColor=#ffffff><FONT face=Arial color=#000000>$ 2,600 </FONT></TD><TD vAlign=bottom align=right bgColor=#ffffff><FONT face=Arial color=#000000>$ 2,800 </FONT></TD><TD vAlign=bottom align=left bgColor=#ffffff><FONT face=Arial color=#000000></FONT></TD><TD vAlign=bottom align=left bgColor=#ffffff><FONT face=Arial color=#000000></FONT></TD><TD vAlign=bottom align=left bgColor=#ffffff><FONT face=Arial color=#000000></FONT></TD><TD vAlign=bottom align=left bgColor=#ffffff><FONT face=Arial color=#000000></FONT></TD><TD vAlign=bottom align=left bgColor=#ffffff><FONT face=Arial color=#000000></FONT></TD></TR><TR><TD align=middle width="1%" bgColor=#d4d0c8><CENTER>16</CENTER></TD><TD vAlign=bottom align=right bgColor=#ffffff><FONT face=Arial color=#000000>September</FONT></TD><TD vAlign=bottom align=right bgColor=#ffffff><FONT face=Arial color=#000000>$ 2,000 </FONT></TD><TD vAlign=bottom align=right bgColor=#ffffff><FONT face=Arial color=#000000>$ 2,200 </FONT></TD><TD vAlign=bottom align=right bgColor=#ffffff><FONT face=Arial color=#000000>$ 2,400 </FONT></TD><TD vAlign=bottom align=right bgColor=#ffffff><FONT face=Arial color=#000000>$ 2,600 </FONT></TD><TD vAlign=bottom align=right bgColor=#ffffff><FONT face=Arial color=#000000>$ 2,800 </FONT></TD><TD vAlign=bottom align=left bgColor=#ffffff><FONT face=Arial color=#000000></FONT></TD><TD vAlign=bottom align=left bgColor=#ffffff><FONT face=Arial color=#000000></FONT></TD><TD vAlign=bottom align=left bgColor=#ffffff><FONT face=Arial color=#000000></FONT></TD><TD vAlign=bottom align=left bgColor=#ffffff><FONT face=Arial color=#000000></FONT></TD><TD vAlign=bottom align=left bgColor=#ffffff><FONT face=Arial color=#000000></FONT></TD></TR><TR><TD align=middle width="1%" bgColor=#d4d0c8><CENTER>17</CENTER></TD><TD vAlign=bottom align=right bgColor=#ffffff><FONT face=Arial color=#000000>October</FONT></TD><TD vAlign=bottom align=right bgColor=#ffffff><FONT face=Arial color=#000000>$ 2,000 </FONT></TD><TD vAlign=bottom align=right bgColor=#ffffff><FONT face=Arial color=#000000>$ 2,200 </FONT></TD><TD vAlign=bottom align=right bgColor=#ffffff><FONT face=Arial color=#000000>$ 2,400 </FONT></TD><TD vAlign=bottom align=right bgColor=#ffffff><FONT face=Arial color=#000000>$ 2,600 </FONT></TD><TD vAlign=bottom align=left bgColor=#ffffff><FONT face=Arial color=#000000></FONT></TD><TD vAlign=bottom align=left bgColor=#ffffff><FONT face=Arial color=#000000></FONT></TD><TD vAlign=bottom align=left bgColor=#ffffff><FONT face=Arial color=#000000></FONT></TD><TD vAlign=bottom align=left bgColor=#ffffff><FONT face=Arial color=#000000></FONT></TD><TD vAlign=bottom align=left bgColor=#ffffff><FONT face=Arial color=#000000></FONT></TD><TD vAlign=bottom align=left bgColor=#ffffff><FONT face=Arial color=#000000></FONT></TD></TR><TR><TD align=middle width="1%" bgColor=#d4d0c8><CENTER>18</CENTER></TD><TD vAlign=bottom align=right bgColor=#ffffff><FONT face=Arial color=#000000>November</FONT></TD><TD vAlign=bottom align=right bgColor=#ffffff><FONT face=Arial color=#000000>$ 2,000 </FONT></TD><TD vAlign=bottom align=right bgColor=#ffffff><FONT face=Arial color=#000000>$ 2,200 </FONT></TD><TD vAlign=bottom align=right bgColor=#ffffff><FONT face=Arial color=#000000>$ 2,400 </FONT></TD><TD vAlign=bottom align=right bgColor=#ffffff><FONT face=Arial color=#000000>$ 2,600 </FONT></TD><TD vAlign=bottom align=left bgColor=#ffffff><FONT face=Arial color=#000000></FONT></TD><TD vAlign=bottom align=left bgColor=#ffffff><FONT face=Arial color=#000000></FONT></TD><TD vAlign=bottom align=left bgColor=#ffffff><FONT face=Arial color=#000000></FONT></TD><TD vAlign=bottom align=left bgColor=#ffffff><FONT face=Arial color=#000000></FONT></TD><TD vAlign=bottom align=left bgColor=#ffffff><FONT face=Arial color=#000000></FONT></TD><TD vAlign=bottom align=left bgColor=#ffffff><FONT face=Arial color=#000000></FONT></TD></TR><TR><TD align=middle width="1%" bgColor=#d4d0c8><CENTER>19</CENTER></TD><TD vAlign=bottom align=right bgColor=#ffffff><FONT face=Arial color=#000000>December</FONT></TD><TD vAlign=bottom align=right bgColor=#ffffff><FONT face=Arial color=#000000>$ 2,000 </FONT></TD><TD vAlign=bottom align=right bgColor=#ffffff><FONT face=Arial color=#000000>$ 2,200 </FONT></TD><TD vAl
 

juliehmac

New Member
Joined
Jan 9, 2014
Messages
7
Hello,

I know this post is quite old, but I'm looking for this exact thing. Would anyone be able to send me a copy of a workbook like this?

Thank you,
Julie
 

Forum statistics

Threads
1,148,194
Messages
5,745,276
Members
423,942
Latest member
excelhelp1423

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top