Lease Table

S

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

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.
Sort by date Sort by votes
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
 
Upvote 0
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
 
Upvote 0
You must log in or register to reply here.

Similar threads

D
  • Question
VBA Code - the code is not pasting to the column I need it to.
Replies
2
Views
563
dragontbone
D
D
  • Question
Need Excel Help with a formula
Replies
3
Views
467
hernantorres23
hernantorres23
S
  • Solved
Linking to a workbook that doesn't yet exist - for use in template creating
2
Replies
11
Views
1K
SophieYaldwyn
S
R
  • Question
Managing Expiry Dates
Replies
3
Views
1K
Nvablejrg
N
T
  • Question
Adapting Old VBA Code for PDF Printing
Replies
0
Views
667
treaves04
T

Forum statistics

Threads
1,214,590
Messages
6,120,423
Members
448,961
Latest member
nzskater

Share this page

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
Back
Top