If..Then Conditional Question Possibility?

trandg

New Member
Joined
Jun 20, 2002
Messages
11
Hi there,

here's a copy of my workbook. basically I think I need some sort of nested If statement in order to come up with my solution.

You will see I have two groupings of data. The first set is from cells A to E. The second set is anything after that. I am trying to have a process that will have a breakdown of a 24 hour period broken down into 10 minute intervals. (eg. 0:00, 0:10, 0:20 etc). Next to this data, i need the appropriate date. You will see in the first data group the dates can vary from 8 marked days (A87-A94) to 37 (A2-A28) or even just 1 (its not shown in this data, but i have it here!). Somehow I need the dates to be copied from the first group to the second group, next to the time (its already done in the second group, but I did that manually).

If you need clarification, please email me at

DavidT@lsrca.on.ca

The data is essentially from a rain gauge tipping device. Everytime the bucket fills 0.25mm, it tips over. I have calculated a method to figure out the amounts per each 10 minute interval. Now I just need a method to do it from the dates of 2/28/99 all the way to 2002! THATS A LOT OF DATA!

Thanks for anyone who attempts this feat!

Good luck!

<SCRIPT language=JavaScript src="http://www.interq.or.jp/sun/puremis/colo/popup.js"></SCRIPT><CENTER><TABLE cellSpacing=0 cellPadding=0 align=center><TBODY><TR><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid" bgColor=#0c266b colSpan=11><TABLE width="100%" align=center border=0><TBODY><TR><TD align=left><FONT color=white>Microsoft Excel - Office rain gauge for posting.xls</FONT></TD><TD style="FONT-SIZE: 9pt; COLOR: #ffffff; FONT-FAMILY: caption" align=right>___Running: xl97 : OS = Windows 98 </FONT></TD></TR></TBODY></TABLE></TD></TR><TR><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid; HEIGHT: 25px" bgColor=#d4d0c8 colSpan=11><TABLE width="100%" align=center border=0 VALIGN="MIDDLE"><TBODY><TR><TD style="FONT-SIZE: 10pt; COLOR: #000000; FONT-FAMILY: caption">(<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 (<U>A</U>)bout</TD><TD vAlign=center align=right><FORM name=formCb755237><INPUT onclick='window.clipboardData.setData("Text",document.formFb078704.sltNb935705.value);' type=button value="Copy Formula" name=btCb873980></FORM></TD></TR></TBODY></TABLE></TD></TR><TR><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid" bgColor=white colSpan=11><TABLE border=0><TBODY><TR><FORM name=formFb078704><TD style="WIDTH: 60px" align=middle bgColor=white><SELECT onchange="document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value" name=sltNb935705><OPTION value="{=SUM(IF($B$2:$B$38<H3,$D$2:$D$38))}" selected>I2<OPTION value==I2>J2<OPTION value==H2+10/(24*60)>H3<OPTION value="{=SUM(IF($B$2:$B$38<H4,$D$2:$D$38))}">I3<OPTION value==I3-I2>J3<OPTION value==H3+10/(24*60)>H4<OPTION value="{=SUM(IF($B$2:$B$38<H5,$D$2:$D$38))}">I4<OPTION value==I4-I3>J4<OPTION value==H4+10/(24*60)>H5<OPTION value="{=SUM(IF($B$2:$B$38<H6,$D$2:$D$38))}">I5<OPTION value==I5-I4>J5<OPTION value==H5+10/(24*60)>H6<OPTION value="{=SUM(IF($B$2:$B$38<H7,$D$2:$D$38))}">I6<OPTION value==I6-I5>J6<OPTION value==H6+10/(24*60)>H7<OPTION value="{=SUM(IF($B$2:$B$38<H8,$D$2:$D$38))}">I7<OPTION value==I7-I6>J7<OPTION value==H7+10/(24*60)>H8<OPTION value="{=SUM(IF($B$2:$B$38<H9,$D$2:$D$38))}">I8<OPTION value==I8-I7>J8<OPTION value==H8+10/(24*60)>H9<OPTION value="{=SUM(IF($B$2:$B$38<H10,$D$2:$D$38))}">I9<OPTION value==I9-I8>J9<OPTION value==H9+10/(24*60)>H10<OPTION value="{=SUM(IF($B$2:$B$38<H11,$D$2:$D$38))}">I10<OPTION value==I10-I9>J10<OPTION value==H10+10/(24*60)>H11<OPTION value="{=SUM(IF($B$2:$B$38<H12,$D$2:$D$38))}">I11<OPTION value==I11-I10>J11<OPTION value==H11+10/(24*60)>H12<OPTION value="{=SUM(IF($B$2:$B$38<H13,$D$2:$D$38))}">I12<OPTION value==I12-I11>J12<OPTION value==H12+10/(24*60)>H13<OPTION value="{=SUM(IF($B$2:$B$38<H14,$D$2:$D$38))}">I13<OPTION value==I13-I12>J13<OPTION value==H13+10/(24*60)>H14<OPTION value="{=SUM(IF($B$2:$B$38<H15,$D$2:$D$38))}">I14<OPTION value==I14-I13>J14<OPTION value==H14+10/(24*60)>H15<OPTION value="{=SUM(IF($B$2:$B$38<H16,$D$2:$D$38))}">I15<OPTION value==I15-I14>J15<OPTION value==H15+10/(24*60)>H16<OPTION value="{=SUM(IF($B$2:$B$38<H17,$D$2:$D$38))}">I16<OPTION value==I16-I15>J16<OPTION value==H16+10/(24*60)>H17<OPTION value="{=SUM(IF($B$2:$B$38<H18,$D$2:$D$38))}">I17<OPTION value==I17-I16>J17<OPTION value==H17+10/(24*60)>H18<OPTION value="{=SUM(IF($B$2:$B$38<H19,$D$2:$D$38))}">I18<OPTION value==I18-I17>J18<OPTION value==H18+10/(24*60)>H19<OPTION value="{=SUM(IF($B$2:$B$38<H20,$D$2:$D$38))}">I19<OPTION value==I19-I18>J19<OPTION value==H19+10/(24*60)>H20<OPTION value="{=SUM(IF($B$2:$B$38<H21,$D$2:$D$38))}">I20<OPTION value==I20-I19>J20<OPTION value==H20+10/(24*60)>H21<OPTION value="{=SUM(IF($B$2:$B$38<H22,$D$2:$D$38))}">I21<OPTION value==I21-I20>J21<OPTION value==H21+10/(24*60)>H22<OPTION value="{=SUM(IF($B$2:$B$38<H23,$D$2:$D$38))}">I22<OPTION value==I22-I21>J22<OPTION value==H22+10/(24*60)>H23<OPTION value="{=SUM(IF($B$2:$B$38<H24,$D$2:$D$38))}">I23<OPTION value==I23-I22>J23<OPTION value==H23+10/(24*60)>H24<OPTION value="{=SUM(IF($B$2:$B$38<H25,$D$2:$D$38))}">I24<OPTION value==I24-I23>J24<OPTION value==H24+10/(24*60)>H25<OPTION value="{=SUM(IF($B$2:$B$38<H26,$D$2:$D$38))}">I25<OPTION value==I25-I24>J25<OPTION value==H25+10/(24*60)>H26<OPTION value="{=SUM(IF($B$2:$B$38<H27,$D$2:$D$38))}">I26<OPTION value==I26-I25>J26<OPTION value==H26+10/(24*60)>H27<OPTION value="{=SUM(IF($B$2:$B$38<H28,$D$2:$D$38))}">I27<OPTION value==I27-I26>J27<OPTION value==H27+10/(24*60)>H28<OPTION value="{=SUM(IF($B$2:$B$38<H29,$D$2:$D$38))}">I28<OPTION value==I28-I27>J28<OPTION value==H28+10/(24*60)>H29<OPTION value="{=SUM(IF($B$2:$B$38<H30,$D$2:$D$38))}">I29<OPTION value==I29-I28>J29<OPTION value==H29+10/(24*60)>H30<OPTION value="{=SUM(IF($B$2:$B$38<H31,$D$2:$D$38))}">I30<OPTION value==I30-I29>J30<OPTION value==H30+10/(24*60)>H31<OPTION value="{=SUM(IF($B$2:$B$38<H32,$D$2:$D$38))}">I31<OPTION value==I31-I30>J31<OPTION value==H31+10/(24*60)>H32<OPTION value="{=SUM(IF($B$2:$B$38<H33,$D$2:$D$38))}">I32<OPTION value==I32-I31>J32<OPTION value==H32+10/(24*60)>H33<OPTION value="{=SUM(IF($B$2:$B$38<H34,$D$2:$D$38))}">I33<OPTION value==I33-I32>J33<OPTION value==H33+10/(24*60)>H34<OPTION value="{=SUM(IF($B$2:$B$38<H35,$D$2:$D$38))}">I34<OPTION value==I34-I33>J34<OPTION value==H34+10/(24*60)>H35<OPTION value="{=SUM(IF($B$2:$B$38<H36,$D$2:$D$38))}">I35<OPTION value==I35-I34>J35<OPTION value==H35+10/(24*60)>H36<OPTION value="{=SUM(IF($B$2:$B$38<H37,$D$2:$D$38))}">I36<OPTION value==I36-I35>J36<OPTION value==H36+10/(24*60)>H37<OPTION value="{=SUM(IF($B$2:$B$38<H38,$D$2:$D$38))}">I37<OPTION value==I37-I36>J37<OPTION value==H37+10/(24*60)>H38<OPTION value="{=SUM(IF($B$2:$B$38<H39,$D$2:$D$38))}">I38<OPTION value==I38-I37>J38<OPTION value==H38+10/(24*60)>H39<OPTION value="{=SUM(IF($B$2:$B$38<H40,$D$2:$D$38))}">I39<OPTION value==I39-I38>J39<OPTION value==H39+10/(24*60)>H40<OPTION value="{=SUM(IF($B$2:$B$38<H41,$D$2:$D$38))}">I40<OPTION value==I40-I39>J40<OPTION value==H40+10/(24*60)>H41<OPTION value="{=SUM(IF($B$2:$B$38<H42,$D$2:$D$38))}">I41<OPTION value==I41-I40>J41<OPTION value==H41+10/(24*60)>H42<OPTION value="{=SUM(IF($B$2:$B$38<H43,$D$2:$D$38))}">I42<OPTION value==I42-I41>J42<OPTION value==H42+10/(24*60)>H43<OPTION value="{=SUM(IF($B$2:$B$38<H44,$D$2:$D$38))}">I43<OPTION value==I43-I42>J43<OPTION value==H43+10/(24*60)>H44<OPTION value="{=SUM(IF($B$2:$B$38<H45,$D$2:$D$38))}">I44<OPTION value==I44-I43>J44<OPTION value==H44+10/(24*60)>H45<OPTION value="{=SUM(IF($B$2:$B$38<H46,$D$2:$D$38))}">I45<OPTION value==I45-I44>J45<OPTION value==H45+10/(24*60)>H46<OPTION value="{=SUM(IF($B$2:$B$38<H47,$D$2:$D$38))}">I46<OPTION value==I46-I45>J46<OPTION value==H46+10/(24*60)>H47<OPTION value="{=SUM(IF($B$2:$B$38<H48,$D$2:$D$38))}">I47<OPTION value==I47-I46>J47<OPTION value==H47+10/(24*60)>H48<OPTION value="{=SUM(IF($B$2:$B$38<H49,$D$2:$D$38))}">I48<OPTION value==I48-I47>J48<OPTION value==H48+10/(24*60)>H49<OPTION value="{=SUM(IF($B$2:$B$38<H50,$D$2:$D$38))}">I49<OPTION value==I49-I48>J49<OPTION value==H49+10/(24*60)>H50<OPTION value="{=SUM(IF($B$2:$B$38<H51,$D$2:$D$38))}">I50<OPTION value==I50-I49>J50<OPTION value==H50+10/(24*60)>H51<OPTION value="{=SUM(IF($B$2:$B$38<H52,$D$2:$D$38))}">I51<OPTION value==I51-I50>J51<OPTION value==H51+10/(24*60)>H52<OPTION value="{=SUM(IF($B$2:$B$38<H53,$D$2:$D$38))}">I52<OPTION value==I52-I51>J52<OPTION value==H52+10/(24*60)>H53<OPTION value="{=SUM(IF($B$2:$B$38<H54,$D$2:$D$38))}">I53<OPTION value==I53-I52>J53<OPTION value==H53+10/(24*60)>H54<OPTION value="{=SUM(IF($B$2:$B$38<H55,$D$2:$D$38))}">I54<OPTION value==I54-I53>J54<OPTION value==H54+10/(24*60)>H55<OPTION value="{=SUM(IF($B$2:$B$38<H56,$D$2:$D$38))}">I55<OPTION value==I55-I54>J55<OPTION value==H55+10/(24*60)>H56<OPTION value="{=SUM(IF($B$2:$B$38<H57,$D$2:$D$38))}">I56<OPTION value==I56-I55>J56<OPTION value==H56+10/(24*60)>H57<OPTION value="{=SUM(IF($B$2:$B$38<H58,$D$2:$D$38))}">I57<OPTION value==I57-I56>J57<OPTION value==H57+10/(24*60)>H58<OPTION value="{=SUM(IF($B$2:$B$38<H59,$D$2:$D$38))}">I58<OPTION value==I58-I57>J58<OPTION value==H58+10/(24*60)>H59<OPTION value="{=SUM(IF($B$2:$B$38<H60,$D$2:$D$38))}">I59<OPTION value==I59-I58>J59<OPTION value==H59+10/(24*60)>H60<OPTION value="{=SUM(IF($B$2:$B$38<H61,$D$2:$D$38))}">I60<OPTION value==I60-I59>J60<OPTION value==H60+10/(24*60)>H61<OPTION value="{=SUM(IF($B$2:$B$38<H62,$D$2:$D$38))}">I61<OPTION value==I61-I60>J61<OPTION value==H61+10/(24*60)>H62<OPTION value="{=SUM(IF($B$2:$B$38<H63,$D$2:$D$38))}">I62<OPTION value==I62-I61>J62<OPTION value==H62+10/(24*60)>H63<OPTION value="{=SUM(IF($B$2:$B$38<H64,$D$2:$D$38))}">I63<OPTION value==I63-I62>J63<OPTION value==H63+10/(24*60)>H64<OPTION value="{=SUM(IF($B$2:$B$38<H65,$D$2:$D$38))}">I64<OPTION value==I64-I63>J64<OPTION value==H64+10/(24*60)>H65<OPTION value="{=SUM(IF($B$2:$B$38<H66,$D$2:$D$38))}">I65<OPTION value==I65-I64>J65<OPTION value==H65+10/(24*60)>H66<OPTION value="{=SUM(IF($B$2:$B$38<H67,$D$2:$D$38))}">I66<OPTION value==I66-I65>J66<OPTION value==H66+10/(24*60)>H67<OPTION value="{=SUM(IF($B$2:$B$38<H68,$D$2:$D$38))}">I67<OPTION value==I67-I66>J67<OPTION value==H67+10/(24*60)>H68<OPTION value="{=SUM(IF($B$2:$B$38<H69,$D$2:$D$38))}">I68<OPTION value==I68-I67>J68<OPTION value==H68+10/(24*60)>H69<OPTION value="{=SUM(IF($B$2:$B$38<H70,$D$2:$D$38))}">I69<OPTION value==I69-I68>J69<OPTION value==H69+10/(24*60)>H70<OPTION value="{=SUM(IF($B$2:$B$38<H71,$D$2:$D$38))}">I70<OPTION value==I70-I69>J70<OPTION value==H70+10/(24*60)>H71<OPTION value="{=SUM(IF($B$2:$B$38<H72,$D$2:$D$38))}">I71<OPTION value==I71-I70>J71<OPTION value==H71+10/(24*60)>H72<OPTION value="{=SUM(IF($B$2:$B$38<H73,$D$2:$D$38))}">I72<OPTION value==I72-I71>J72<OPTION value==H72+10/(24*60)>H73<OPTION value="{=SUM(IF($B$2:$B$38<H74,$D$2:$D$38))}">I73<OPTION value==I73-I72>J73<OPTION value==H73+10/(24*60)>H74<OPTION value="{=SUM(IF($B$2:$B$38<H75,$D$2:$D$38))}">I74<OPTION value==I74-I73>J74<OPTION value==H74+10/(24*60)>H75<OPTION value="{=SUM(IF($B$2:$B$38<H76,$D$2:$D$38))}">I75<OPTION value==I75-I74>J75<OPTION value==H75+10/(24*60)>H76<OPTION value="{=SUM(IF($B$2:$B$38<H77,$D$2:$D$38))}">I76<OPTION value==I76-I75>J76<OPTION value==H76+10/(24*60)>H77<OPTION value="{=SUM(IF($B$2:$B$38<H78,$D$2:$D$38))}">I77<OPTION value==I77-I76>J77<OPTION value==H77+10/(24*60)>H78<OPTION value="{=SUM(IF($B$2:$B$38<H79,$D$2:$D$38))}">I78<OPTION value==I78-I77>J78<OPTION value==H78+10/(24*60)>H79<OPTION value="{=SUM(IF($B$2:$B$38<H80,$D$2:$D$38))}">I79<OPTION value==I79-I78>J79<OPTION value==H79+10/(24*60)>H80<OPTION value="{=SUM(IF($B$2:$B$38<H81,$D$2:$D$38))}">I80<OPTION value==I80-I79>J80<OPTION value==H80+10/(24*60)>H81<OPTION value="{=SUM(IF($B$2:$B$38<H82,$D$2:$D$38))}">I81<OPTION value==I81-I80>J81<OPTION value==H81+10/(24*60)>H82<OPTION value="{=SUM(IF($B$2:$B$38<H83,$D$2:$D$38))}">I82<OPTION value==I82-I81>J82<OPTION value==H82+10/(24*60)>H83<OPTION value="{=SUM(IF($B$2:$B$38<H84,$D$2:$D$38))}">I83<OPTION value==I83-I82>J83<OPTION value==H83+10/(24*60)>H84<OPTION value="{=SUM(IF($B$2:$B$38<H85,$D$2:$D$38))}">I84<OPTION value==I84-I83>J84<OPTION value==H84+10/(24*60)>H85<OPTION value="{=SUM(IF($B$2:$B$38<H86,$D$2:$D$38))}">I85<OPTION value==I85-I84>J85<OPTION value==H85+10/(24*60)>H86<OPTION value="{=SUM(IF($B$2:$B$38<H87,$D$2:$D$38))}">I86<OPTION value==I86-I85>J86<OPTION value==H86+10/(24*60)>H87<OPTION value="{=SUM(IF($B$2:$B$38<H88,$D$2:$D$38))}">I87<OPTION value==I87-I86>J87<OPTION value==H87+10/(24*60)>H88<OPTION value="{=SUM(IF($B$2:$B$38<H89,$D$2:$D$38))}">I88<OPTION value==I88-I87>J88<OPTION value==H88+10/(24*60)>H89<OPTION value="{=SUM(IF($B$2:$B$38<H90,$D$2:$D$38))}">I89<OPTION value==I89-I88>J89<OPTION value==H89+10/(24*60)>H90<OPTION value="{=SUM(IF($B$2:$B$38<H91,$D$2:$D$38))}">I90<OPTION value==I90-I89>J90<OPTION value==H90+10/(24*60)>H91<OPTION value="{=SUM(IF($B$2:$B$38<H92,$D$2:$D$38))}">I91<OPTION value==I91-I90>J91<OPTION value==H91+10/(24*60)>H92<OPTION value="{=SUM(IF($B$2:$B$38<H93,$D$2:$D$38))}">I92<OPTION value==I92-I91>J92<OPTION value==H92+10/(24*60)>H93<OPTION value="{=SUM(IF($B$2:$B$38<H94,$D$2:$D$38))}">I93<OPTION value==I93-I92>J93<OPTION value==H93+10/(24*60)>H94<OPTION value="{=SUM(IF($B$2:$B$38<H95,$D$2:$D$38))}">I94<OPTION value==I94-I93>J94<OPTION value==H94+10/(24*60)>H95<OPTION value="{=SUM(IF($B$2:$B$38<H96,$D$2:$D$38))}">I95<OPTION value==I95-I94>J95<OPTION value==H95+10/(24*60)>H96<OPTION value="{=SUM(IF($B$2:$B$38<H97,$D$2:$D$38))}">I96<OPTION value==I96-I95>J96<OPTION value==H96+10/(24*60)>H97<OPTION value="{=SUM(IF($B$2:$B$38<H98,$D$2:$D$38))}">I97<OPTION value==I97-I96>J97<OPTION value==H97+10/(24*60)>H98<OPTION value="{=SUM(IF($B$2:$B$38<H99,$D$2:$D$38))}">I98<OPTION value==I98-I97>J98<OPTION value==H98+10/(24*60)>H99<OPTION value="{=SUM(IF($B$2:$B$38<H100,$D$2:$D$38))}">I99<OPTION value==I99-I98>J99<OPTION value==H99+10/(24*60)>H100<OPTION value="{=SUM(IF($B$2:$B$38<H101,$D$2:$D$38))}">I100<OPTION value==I100-I99>J100<OPTION value==H100+10/(24*60)>H101<OPTION value="{=SUM(IF($B$2:$B$38<H102,$D$2:$D$38))}">I101<OPTION value==I101-I100>J101<OPTION value==H101+10/(24*60)>H102<OPTION value="{=SUM(IF($B$2:$B$38<H103,$D$2:$D$38))}">I102<OPTION value==I102-I101>J102<OPTION value==H102+10/(24*60)>H103<OPTION value="{=SUM(IF($B$2:$B$38<H104,$D$2:$D$38))}">I103<OPTION value==I103-I102>J103<OPTION value==H103+10/(24*60)>H104<OPTION value="{=SUM(IF($B$2:$B$38<H105,$D$2:$D$38))}">I104<OPTION value==I104-I103>J104<OPTION value==H104+10/(24*60)>H105<OPTION value="{=SUM(IF($B$2:$B$38<H106,$D$2:$D$38))}">I105<OPTION value==I105-I104>J105<OPTION value==H105+10/(24*60)>H106<OPTION value="{=SUM(IF($B$2:$B$38<H107,$D$2:$D$38))}">I106<OPTION value==I106-I105>J106<OPTION value==H106+10/(24*60)>H107<OPTION value="{=SUM(IF($B$2:$B$38<H108,$D$2:$D$38))}">I107<OPTION value==I107-I106>J107<OPTION value==H107+10/(24*60)>H108<OPTION value="{=SUM(IF($B$2:$B$38<H109,$D$2:$D$38))}">I108<OPTION value==I108-I107>J108<OPTION value==H108+10/(24*60)>H109<OPTION value="{=SUM(IF($B$2:$B$38<H110,$D$2:$D$38))}">I109<OPTION value==I109-I108>J109<OPTION value==H109+10/(24*60)>H110<OPTION value="{=SUM(IF($B$2:$B$38<H111,$D$2:$D$38))}">I110<OPTION value==I110-I109>J110<OPTION value==H110+10/(24*60)>H111<OPTION value="{=SUM(IF($B$2:$B$38<H112,$D$2:$D$38))}">I111<OPTION value==I111-I110>J111<OPTION value==H111+10/(24*60)>H112<OPTION value="{=SUM(IF($B$2:$B$38<H113,$D$2:$D$38))}">I112<OPTION value==I112-I111>J112<OPTION value==H112+10/(24*60)>H113<OPTION value="{=SUM(IF($B$2:$B$38<H114,$D$2:$D$38))}">I113<OPTION value==I113-I112>J113<OPTION value==H113+10/(24*60)>H114<OPTION value="{=SUM(IF($B$2:$B$38<H115,$D$2:$D$38))}">I114<OPTION value==I114-I113>J114<OPTION value==H114+10/(24*60)>H115<OPTION value="{=SUM(IF($B$2:$B$38<H116,$D$2:$D$38))}">I115<OPTION value==I115-I114>J115<OPTION value==H115+10/(24*60)>H116<OPTION value="{=SUM(IF($B$2:$B$38<H117,$D$2:$D$38))}">I116<OPTION value==I116-I115>J116<OPTION value==H116+10/(24*60)>H117<OPTION value="{=SUM(IF($B$2:$B$38<H118,$D$2:$D$38))}">I117<OPTION value==I117-I116>J117<OPTION value==H117+10/(24*60)>H118<OPTION value="{=SUM(IF($B$2:$B$38<H119,$D$2:$D$38))}">I118<OPTION value==I118-I117>J118<OPTION value==H118+10/(24*60)>H119<OPTION value="{=SUM(IF($B$2:$B$38<H120,$D$2:$D$38))}">I119<OPTION value==I119-I118>J119<OPTION value==H119+10/(24*60)>H120<OPTION value="{=SUM(IF($B$2:$B$38<H121,$D$2:$D$38))}">I120<OPTION value==I120-I119>J120<OPTION value==H120+10/(24*60)>H121<OPTION value="{=SUM(IF($B$2:$B$38<H122,$D$2:$D$38))}">I121<OPTION value==I121-I120>J121<OPTION value==H121+10/(24*60)>H122<OPTION value="{=SUM(IF($B$2:$B$38<H123,$D$2:$D$38))}">I122<OPTION value==I122-I121>J122<OPTION value==H122+10/(24*60)>H123<OPTION value="{=SUM(IF($B$2:$B$38<H124,$D$2:$D$38))}">I123<OPTION value==I123-I122>J123<OPTION value==H123+10/(24*60)>H124<OPTION value="{=SUM(IF($B$2:$B$38<H125,$D$2:$D$38))}">I124<OPTION value==I124-I123>J124<OPTION value==H124+10/(24*60)>H125<OPTION value="{=SUM(IF($B$2:$B$38<H126,$D$2:$D$38))}">I125<OPTION value==I125-I124>J125<OPTION value==H125+10/(24*60)>H126<OPTION value="{=SUM(IF($B$2:$B$38<H127,$D$2:$D$38))}">I126<OPTION value==I126-I125>J126<OPTION value==H126+10/(24*60)>H127<OPTION value="{=SUM(IF($B$2:$B$38<H128,$D$2:$D$38))}">I127<OPTION value==I127-I126>J127<OPTION value==H127+10/(24*60)>H128<OPTION value="{=SUM(IF($B$2:$B$38<H129,$D$2:$D$38))}">I128<OPTION value==I128-I127>J128<OPTION value==H128+10/(24*60)>H129<OPTION value="{=SUM(IF($B$2:$B$38<H130,$D$2:$D$38))}">I129<OPTION value==I129-I128>J129<OPTION value==H129+10/(24*60)>H130<OPTION value="{=SUM(IF($B$2:$B$38<H131,$D$2:$D$38))}">I130<OPTION value==I130-I129>J130<OPTION value==H130+10/(24*60)>H131<OPTION value="{=SUM(IF($B$2:$B$38<H132,$D$2:$D$38))}">I131<OPTION value==I131-I130>J131<OPTION value==H131+10/(24*60)>H132<OPTION value="{=SUM(IF($B$2:$B$38<H133,$D$2:$D$38))}">I132<OPTION value==I132-I131>J132<OPTION value==H132+10/(24*60)>H133<OPTION value="{=SUM(IF($B$2:$B$38<H134,$D$2:$D$38))}">I133<OPTION value==I133-I132>J133<OPTION value==H133+10/(24*60)>H134<OPTION value="{=SUM(IF($B$2:$B$38<H135,$D$2:$D$38))}">I134<OPTION value==I134-I133>J134<OPTION value==H134+10/(24*60)>H135<OPTION value="{=SUM(IF($B$2:$B$38<H136,$D$2:$D$38))}">I135<OPTION value==I135-I134>J135<OPTION value==H135+10/(24*60)>H136<OPTION value="{=SUM(IF($B$2:$B$38<H137,$D$2:$D$38))}">I136<OPTION value==I136-I135>J136<OPTION value==H136+10/(24*60)>H137<OPTION value="{=SUM(IF($B$2:$B$38<H138,$D$2:$D$38))}">I137<OPTION value==I137-I136>J137<OPTION value==H137+10/(24*60)>H138<OPTION value="{=SUM(IF($B$2:$B$38<H139,$D$2:$D$38))}">I138<OPTION value==I138-I137>J138<OPTION value==H138+10/(24*60)>H139<OPTION value="{=SUM(IF($B$2:$B$38<H140,$D$2:$D$38))}">I139<OPTION value==I139-I138>J139<OPTION value==H139+10/(24*60)>H140<OPTION value="{=SUM(IF($B$2:$B$38<H141,$D$2:$D$38))}">I140<OPTION value==I140-I139>J140<OPTION value==H140+10/(24*60)>H141<OPTION value="{=SUM(IF($B$2:$B$38<H142,$D$2:$D$38))}">I141<OPTION value==I141-I140>J141<OPTION value==H141+10/(24*60)>H142<OPTION value="{=SUM(IF($B$2:$B$38<H143,$D$2:$D$38))}">I142<OPTION value==I142-I141>J142<OPTION value==H142+10/(24*60)>H143<OPTION value="{=SUM(IF($B$2:$B$38<H144,$D$2:$D$38))}">I143<OPTION value==I143-I142>J143<OPTION value==H143+10/(24*60)>H144<OPTION value="{=SUM(IF($B$2:$B$38<H145,$D$2:$D$38))}">I144<OPTION value==I144-I143>J144<OPTION value==H144+10/(24*60)>H145<OPTION value==I145-I144>J145<OPTION value==SUM(J2:J145)>J146</OPTION></SELECT></TD><TD align=right width="3%" bgColor=#d4d0c8>=</TD><TD align=left bgColor=white><INPUT size=80 value="{=SUM(IF($B$2:$B$38<H3,$D$2:$D$38))}" name=txbFb426622></TD></FORM></TR></TBODY></TABLE></TD></TR><TR><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid; BACKGROUND-COLOR: #d4d0c8" align=middle width="2%">
</TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle><CENTER>A</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle><CENTER>B</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle><CENTER>C</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle><CENTER>D</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle><CENTER>E</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle><CENTER>F</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle><CENTER>G</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle><CENTER>H</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle><CENTER>I</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle><CENTER>J</CENTER></TD></TR><TR><TD style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle width="2%"><CENTER>1</CENTER></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">Date</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">Time</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">Tips</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">Precip </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">Units</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: MS Sans Serif; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: MS Sans Serif; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">Time</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: MS Sans Serif; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">Cumulative</TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: MS Sans Serif; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">Rainfall per Interval</TD></TR><TR><TD style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle width="2%"><CENTER>2</CENTER></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">2/28/99</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">5:04</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">1</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">0.25</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: MS Sans Serif; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">mm</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: MS Sans Serif; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">2/28/99</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: MS Sans Serif; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">0:00</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: MS Sans Serif; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">0</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: MS Sans Serif; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">0</FONT></TD></TR><TR><TD style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle width="2%"><CENTER>3</CENTER></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">2/28/99</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">5:10</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">2</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">0.25</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: MS Sans Serif; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">mm</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: MS Sans Serif; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">2/28/99</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: MS Sans Serif; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">0:10</FONT></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: MS Sans Serif; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">0</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: MS Sans Serif; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">0</FONT></TD></TR><TR><TD style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle width="2%"><CENTER>4</CENTER></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">2/28/99</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">5:19</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">3</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">0.25</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: MS Sans Serif; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">mm</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: MS Sans Serif; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">2/28/99</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: MS Sans Serif; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">0:20</FONT></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: MS Sans Serif; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">0</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: MS Sans Serif; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">0</FONT></TD></TR><TR><TD style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle width="2%"><CENTER>5</CENTER></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">2/28/99</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">5:27</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">4</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">0.25</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: MS Sans Serif; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">mm</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: MS Sans Serif; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">2/28/99</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: MS Sans Serif; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">0:30</FONT></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: MS Sans Serif; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">0</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: MS Sans Serif; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">0</FONT></TD></TR><TR><TD style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle width="2%"><CENTER>6</CENTER></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">2/28/99</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">5:35</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">5</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">0.25</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: MS Sans Serif; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">mm</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: MS Sans Serif; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">2/28/99</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: MS Sans Serif; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">0:40</FONT></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: MS Sans Serif; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">0</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: MS Sans Serif; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">0</FONT></TD></TR><TR><TD style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle width="2%"><CENTER>7</CENTER></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">2/28/99</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">5:44</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">6</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">0.25</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: MS Sans Serif; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">mm</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: MS Sans Serif; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">2/28/99</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: MS Sans Serif; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">0:50</FONT></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: MS Sans Serif; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">0</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: MS Sans Serif; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">0</FONT></TD></TR><TR><TD style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle width="2%"><CENTER>8</CENTER></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">2/28/99</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">5:55</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">7</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">0.25</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: MS Sans Serif; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">mm</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: MS Sans Serif; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">2/28/99</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: MS Sans Serif; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">1:00</FONT></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: MS Sans Serif; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">0</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: MS Sans Serif; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">0</FONT></TD></TR><TR><TD style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle width="2%"><CENTER>9</CENTER></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">2/28/99</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">6:06</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">8</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">0.25</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: MS Sans Serif; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">mm</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: MS Sans Serif; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">2/28/99</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: MS Sans Serif; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">1:10</FONT></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: MS Sans Serif; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">0</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: MS Sans Serif; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">0</FONT></TD></TR><TR><TD style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle width="2%"><CENTER>10</CENTER></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">2/28/99</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">6:17</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">9</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">0.25</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: MS Sans Serif; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">mm</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: MS Sans Serif; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">2/28/99</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: MS Sans Serif; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">1:20</FONT></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: MS Sans Serif; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">0</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: MS Sans Serif; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">0</FONT></TD></TR><TR><TD style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle width="2%"><CENTER>11</CENTER></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">2/28/99</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">6:21</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">10</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">0.25</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: MS Sans Serif; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">mm</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: MS Sans Serif; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">2/28/99</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: MS Sans Serif; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">1:30</FONT></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: MS Sans Serif; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">0</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: MS Sans Serif; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">0</FONT></TD></TR><TR><TD style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle width="2%"><CENTER>12</CENTER></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">2/28/99</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">6:29</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">11</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">0.25</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: MS Sans Serif; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">mm</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: MS Sans Serif; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">2/28/99</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: MS Sans Serif; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">1:40</FONT></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: MS Sans Serif; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">0</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: MS Sans Serif; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">0</FONT></TD></TR><TR><TD style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle width="2%"><CENTER>13</CENTER></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">2/28/99</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">6:36</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">12</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">0.25</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: MS Sans Serif; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">mm</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: MS Sans Serif; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">2/28/99</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: MS Sans Serif; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">1:50</FONT></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: MS Sans Serif; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">0</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: MS Sans Serif; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">0</FONT></TD></TR><TR><TD style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle width="2%"><CENTER>14</CENTER></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">2/28/99</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">6:46</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">13</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">0.25</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: MS Sans Serif; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">mm</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: MS Sans Serif; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">2/28/99</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: MS Sans Serif; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">2:00</FONT></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: MS Sans Serif; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">0</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: MS Sans Serif; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">0</FONT></TD></TR><TR><TD style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle width="2%"><CENTER>15</CENTER></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">2/28/99</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">6:51</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">14</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Aria
 

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.
Oh, I don't know if I was clear on this:

I need these 10 minute intervals (for 24 hours) for EVERY date in my data (so from 2/28/99 to 2/28/02 gives me a big workbook).

Also, as I have mentioned, the time and cumulative, and rainfall have been figured out...just getting the appropriate dates and times automated...

thanks again
 
Upvote 0
Oh, I don't know if I was clear on this:

I need these 10 minute intervals (for 24 hours) for EVERY date in my data (so from 2/28/99 to 2/28/02 gives me a big workbook).

Also, as I have mentioned, the time and cumulative, and rainfall have been figured out...just getting the appropriate dates and times automated...

thanks again
 
Upvote 0
</table>

trandg

read your post, couldn't work out what you wanted. Occsionally thought I had it, but no :(

Do you mean where you've got
{=SUM(IF($B$2:$B$38<H3,$D$2:$D$38))}

in col H you want to -

a) get it working for each time interval / day (currently it only hcecks times, so will 'erroneously' add amounts for the sme time on different days in the range

and

b) do a similar thing in another column that finds cumulative / day


Could you try again?

Maybe break the solution you want down step by step based on the data you posted...



Paddy
 
Upvote 0
I have found that most of the time I figure out how to effectively communicate a problem, I have also figured out the solution.
 
Upvote 0

Forum statistics

Threads
1,214,394
Messages
6,119,263
Members
448,881
Latest member
Faxgirl

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