Need to sum values based on varying values in other cells

DaveWW00

New Member
Joined
Feb 3, 2006
Messages
39
<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=17><TABLE width="100%" align=center border=0><TBODY><TR><TD align=left><FONT color=white>Microsoft Excel - NewSettlement.xls</FONT></TD><TD style="FONT-SIZE: 9pt; COLOR: #ffffff; FONT-FAMILY: caption" align=right>___Running: 11.0 : OS = Windows XP </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=17><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=formCb605117><INPUT onclick='window.clipboardData.setData("Text",document.formFb202339.sltNb447362.value);' type=button value="Copy Formula" name=btCb942116></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=17><TABLE border=0><TBODY><TR><FORM name=formFb202339><TD style="WIDTH: 60px" align=middle bgColor=white><SELECT onchange="document.formFb202339.txbFb150492.value = document.formFb202339.sltNb447362.value" name=sltNb447362><OPTION value==D12 selected>D18<OPTION value==D12>E18<OPTION value==D12>F18<OPTION value==E19+D19>F19<OPTION value==E19+D19>E20<OPTION value==E20+D20>F20<OPTION value==G19-D19>G20<OPTION value==E20+D20>E21<OPTION value==E21+D21>F21<OPTION value==G20-D20>G21<OPTION value==E21+D21>E22<OPTION value==E22+D22>F22<OPTION value==G21-D21>G22<OPTION value==E22+D22>E23<OPTION value==E23+D23>F23<OPTION value==G22-D22>G23<OPTION value==E23+D23>E24<OPTION value==E24+D24>F24<OPTION value==G23-D23>G24<OPTION value==E24+D24>E25<OPTION value==E25+D25>F25<OPTION value==G24-D24>G25<OPTION value==E25+D25>E26<OPTION value==E26+D26>F26<OPTION value==G25-D25>G26<OPTION value==SUM(Q33:Q108)>L27<OPTION value='=IF(C11="FILL","","Depth Below Footing")'>C30<OPTION value==G19-C14>B33<OPTION value==C33+J$15>D33<OPTION value==AVERAGE(C33:D33)>E33<OPTION value="=IF($D33<=$F$19,H$19,IF($D33<=$F$20,H$20,IF($D33<=$F$21,H$21,IF($D33<=$F$22,H$22,IF($D33<=$F$23,H$23,IF($D33<=$F$24,H$24,IF($D33<=$F$25,H$25,IF($D33<=$F$26,H$26,H$26))))))))">F33<OPTION value="=IF((C$14+E33)<=J$13,F33,IF(F33=0,0,F33-62.4))">G33<OPTION value="=IF($D33<=$F$19,I$19,IF($D33<=$F$20,I$20,IF($D33<=$F$21,I$21,IF($D33<=$F$22,I$22,IF($D33<=$F$23,I$23,IF($D33<=$F$24,I$24,IF($D33<=$F$25,I$25,IF($D33<=$F$26,I$26,I$26))))))))">H33<OPTION value="=IF($D33<=$F$19,J$19,IF($D33<=$F$20,J$20,IF($D33<=$F$21,J$21,IF($D33<=$F$22,J$22,IF($D33<=$F$23,J$23,IF($D33<=$F$24,J$24,IF($D33<=$F$25,J$25,IF($D33<=$F$26,J$26,J$26))))))))">I33<OPTION value="=IF($D33<=$F$19,K$19,IF($D33<=$F$20,K$20,IF($D33<=$F$21,K$21,IF($D33<=$F$22,K$22,IF($D33<=$F$23,K$23,IF($D33<=$F$24,K$24,IF($D33<=$F$25,K$25,IF($D33<=$F$26,K$26,K$26))))))))">J33<OPTION value==(C14+E33)*G33>K33<OPTION value='=IF(C$11="CI",1-1/((1+(C$12/(2*E33))^2)^(3/2)),2*(ATAN($F$13*$F$12/E33/SQRT($F$13*$F$13+$F$12*$F$12+E33*E33))+$F$13*$F$12*E33*(1/($F$13*$F$13+E33*E33)+1/($F$12*$F$12+E33*E33))/SQRT($F$13*$F$13+$F$12*$F$12+E33*E33))/PI())'>L33<OPTION value==L33*J$14>M33<OPTION value==M33+K33>N33<OPTION value="=IF(K33<J33,I33*J$15*LOG(J33/K33,10),0)">O33<OPTION value="=IF(J33<N33,H33*J$15*LOG(N33/K33),0)">P33<OPTION value==(P33+O33)*12>Q33<OPTION value==B33-J$15>B34<OPTION value==D33>C34<OPTION value==C34+J$15>D34<OPTION value==AVERAGE(C34:D34)>E34<OPTION value="=IF($D34<=$F$19,H$19,IF($D34<=$F$20,H$20,IF($D34<=$F$21,H$21,IF($D34<=$F$22,H$22,IF($D34<=$F$23,H$23,IF($D34<=$F$24,H$24,IF($D34<=$F$25,H$25,IF($D34<=$F$26,H$26,H$26))))))))">F34<OPTION value="=IF((C$14+E34)<=J$13,F34,IF(F34=0,0,F34-62.4))">G34<OPTION value="=IF($D34<=$F$19,I$19,IF($D34<=$F$20,I$20,IF($D34<=$F$21,I$21,IF($D34<=$F$22,I$22,IF($D34<=$F$23,I$23,IF($D34<=$F$24,I$24,IF($D34<=$F$25,I$25,IF($D34<=$F$26,I$26,I$26))))))))">H34<OPTION value="=IF($D34<=$F$19,J$19,IF($D34<=$F$20,J$20,IF($D34<=$F$21,J$21,IF($D34<=$F$22,J$22,IF($D34<=$F$23,J$23,IF($D34<=$F$24,J$24,IF($D34<=$F$25,J$25,IF($D34<=$F$26,J$26,J$26))))))))">I34<OPTION value="=IF($D34<=$F$19,K$19,IF($D34<=$F$20,K$20,IF($D34<=$F$21,K$21,IF($D34<=$F$22,K$22,IF($D34<=$F$23,K$23,IF($D34<=$F$24,K$24,IF($D34<=$F$25,K$25,IF($D34<=$F$26,K$26,K$26))))))))">J34<OPTION value==K33+(E34-E33)*G34>K34<OPTION value='=IF(C$11="CI",1-1/((1+(C$12/(2*E34))^2)^(3/2)),2*(ATAN($F$13*$F$12/E34/SQRT($F$13*$F$13+$F$12*$F$12+E34*E34))+$F$13*$F$12*E34*(1/($F$13*$F$13+E34*E34)+1/($F$12*$F$12+E34*E34))/SQRT($F$13*$F$13+$F$12*$F$12+E34*E34))/PI())'>L34<OPTION value==L34*J$14>M34<OPTION value==M34+K34>N34<OPTION value="=IF(K34<J34,I34*J$15*LOG(J34/K34,10),0)">O34<OPTION value="=IF(J34<N34,H34*J$15*LOG(N34/K34),0)">P34<OPTION value==(P34+O34)*12>Q34<OPTION value==B34-J$15>B35<OPTION value==D34>C35<OPTION value==C35+J$15>D35<OPTION value==AVERAGE(C35:D35)>E35<OPTION value="=IF($D35<=$F$19,H$19,IF($D35<=$F$20,H$20,IF($D35<=$F$21,H$21,IF($D35<=$F$22,H$22,IF($D35<=$F$23,H$23,IF($D35<=$F$24,H$24,IF($D35<=$F$25,H$25,IF($D35<=$F$26,H$26,H$26))))))))">F35<OPTION value="=IF((C$14+E35)<=J$13,F35,IF(F35=0,0,F35-62.4))">G35<OPTION value="=IF($D35<=$F$19,I$19,IF($D35<=$F$20,I$20,IF($D35<=$F$21,I$21,IF($D35<=$F$22,I$22,IF($D35<=$F$23,I$23,IF($D35<=$F$24,I$24,IF($D35<=$F$25,I$25,IF($D35<=$F$26,I$26,I$26))))))))">H35<OPTION value="=IF($D35<=$F$19,J$19,IF($D35<=$F$20,J$20,IF($D35<=$F$21,J$21,IF($D35<=$F$22,J$22,IF($D35<=$F$23,J$23,IF($D35<=$F$24,J$24,IF($D35<=$F$25,J$25,IF($D35<=$F$26,J$26,J$26))))))))">I35<OPTION value="=IF($D35<=$F$19,K$19,IF($D35<=$F$20,K$20,IF($D35<=$F$21,K$21,IF($D35<=$F$22,K$22,IF($D35<=$F$23,K$23,IF($D35<=$F$24,K$24,IF($D35<=$F$25,K$25,IF($D35<=$F$26,K$26,K$26))))))))">J35<OPTION value==K34+(E35-E34)*G35>K35<OPTION value='=IF(C$11="CI",1-1/((1+(C$12/(2*E35))^2)^(3/2)),2*(ATAN($F$13*$F$12/E35/SQRT($F$13*$F$13+$F$12*$F$12+E35*E35))+$F$13*$F$12*E35*(1/($F$13*$F$13+E35*E35)+1/($F$12*$F$12+E35*E35))/SQRT($F$13*$F$13+$F$12*$F$12+E35*E35))/PI())'>L35<OPTION value==L35*J$14>M35<OPTION value==M35+K35>N35<OPTION value="=IF(K35<J35,I35*J$15*LOG(J35/K35,10),0)">O35<OPTION value="=IF(J35<N35,H35*J$15*LOG(N35/K35),0)">P35<OPTION value==(P35+O35)*12>Q35<OPTION value==B35-J$15>B36<OPTION value==D35>C36<OPTION value==C36+J$15>D36<OPTION value==AVERAGE(C36:D36)>E36<OPTION value="=IF($D36<=$F$19,H$19,IF($D36<=$F$20,H$20,IF($D36<=$F$21,H$21,IF($D36<=$F$22,H$22,IF($D36<=$F$23,H$23,IF($D36<=$F$24,H$24,IF($D36<=$F$25,H$25,IF($D36<=$F$26,H$26,H$26))))))))">F36<OPTION value="=IF((C$14+E36)<=J$13,F36,IF(F36=0,0,F36-62.4))">G36<OPTION value="=IF($D36<=$F$19,I$19,IF($D36<=$F$20,I$20,IF($D36<=$F$21,I$21,IF($D36<=$F$22,I$22,IF($D36<=$F$23,I$23,IF($D36<=$F$24,I$24,IF($D36<=$F$25,I$25,IF($D36<=$F$26,I$26,I$26))))))))">H36<OPTION value="=IF($D36<=$F$19,J$19,IF($D36<=$F$20,J$20,IF($D36<=$F$21,J$21,IF($D36<=$F$22,J$22,IF($D36<=$F$23,J$23,IF($D36<=$F$24,J$24,IF($D36<=$F$25,J$25,IF($D36<=$F$26,J$26,J$26))))))))">I36<OPTION value="=IF($D36<=$F$19,K$19,IF($D36<=$F$20,K$20,IF($D36<=$F$21,K$21,IF($D36<=$F$22,K$22,IF($D36<=$F$23,K$23,IF($D36<=$F$24,K$24,IF($D36<=$F$25,K$25,IF($D36<=$F$26,K$26,K$26))))))))">J36<OPTION value==K35+(E36-E35)*G36>K36<OPTION value='=IF(C$11="CI",1-1/((1+(C$12/(2*E36))^2)^(3/2)),2*(ATAN($F$13*$F$12/E36/SQRT($F$13*$F$13+$F$12*$F$12+E36*E36))+$F$13*$F$12*E36*(1/($F$13*$F$13+E36*E36)+1/($F$12*$F$12+E36*E36))/SQRT($F$13*$F$13+$F$12*$F$12+E36*E36))/PI())'>L36<OPTION value==L36*J$14>M36<OPTION value==M36+K36>N36<OPTION value="=IF(K36<J36,I36*J$15*LOG(J36/K36,10),0)">O36<OPTION value="=IF(J36<N36,H36*J$15*LOG(N36/K36),0)">P36<OPTION value==(P36+O36)*12>Q36<OPTION value==B36-J$15>B37<OPTION value==D36>C37<OPTION value==C37+J$15>D37<OPTION value==AVERAGE(C37:D37)>E37<OPTION value="=IF($D37<=$F$19,H$19,IF($D37<=$F$20,H$20,IF($D37<=$F$21,H$21,IF($D37<=$F$22,H$22,IF($D37<=$F$23,H$23,IF($D37<=$F$24,H$24,IF($D37<=$F$25,H$25,IF($D37<=$F$26,H$26,H$26))))))))">F37<OPTION value="=IF((C$14+E37)<=J$13,F37,IF(F37=0,0,F37-62.4))">G37<OPTION value="=IF($D37<=$F$19,I$19,IF($D37<=$F$20,I$20,IF($D37<=$F$21,I$21,IF($D37<=$F$22,I$22,IF($D37<=$F$23,I$23,IF($D37<=$F$24,I$24,IF($D37<=$F$25,I$25,IF($D37<=$F$26,I$26,I$26))))))))">H37<OPTION value="=IF($D37<=$F$19,J$19,IF($D37<=$F$20,J$20,IF($D37<=$F$21,J$21,IF($D37<=$F$22,J$22,IF($D37<=$F$23,J$23,IF($D37<=$F$24,J$24,IF($D37<=$F$25,J$25,IF($D37<=$F$26,J$26,J$26))))))))">I37<OPTION value="=IF($D37<=$F$19,K$19,IF($D37<=$F$20,K$20,IF($D37<=$F$21,K$21,IF($D37<=$F$22,K$22,IF($D37<=$F$23,K$23,IF($D37<=$F$24,K$24,IF($D37<=$F$25,K$25,IF($D37<=$F$26,K$26,K$26))))))))">J37<OPTION value==K36+(E37-E36)*G37>K37<OPTION value='=IF(C$11="CI",1-1/((1+(C$12/(2*E37))^2)^(3/2)),2*(ATAN($F$13*$F$12/E37/SQRT($F$13*$F$13+$F$12*$F$12+E37*E37))+$F$13*$F$12*E37*(1/($F$13*$F$13+E37*E37)+1/($F$12*$F$12+E37*E37))/SQRT($F$13*$F$13+$F$12*$F$12+E37*E37))/PI())'>L37<OPTION value==L37*J$14>M37<OPTION value==M37+K37>N37<OPTION value="=IF(K37<J37,I37*J$15*LOG(J37/K37,10),0)">O37<OPTION value="=IF(J37<N37,H37*J$15*LOG(N37/K37),0)">P37<OPTION value==(P37+O37)*12>Q37<OPTION value==B37-J$15>B38<OPTION value==D37>C38<OPTION value==C38+J$15>D38<OPTION value==AVERAGE(C38:D38)>E38<OPTION value="=IF($D38<=$F$19,H$19,IF($D38<=$F$20,H$20,IF($D38<=$F$21,H$21,IF($D38<=$F$22,H$22,IF($D38<=$F$23,H$23,IF($D38<=$F$24,H$24,IF($D38<=$F$25,H$25,IF($D38<=$F$26,H$26,H$26))))))))">F38<OPTION value="=IF((C$14+E38)<=J$13,F38,IF(F38=0,0,F38-62.4))">G38<OPTION value="=IF($D38<=$F$19,I$19,IF($D38<=$F$20,I$20,IF($D38<=$F$21,I$21,IF($D38<=$F$22,I$22,IF($D38<=$F$23,I$23,IF($D38<=$F$24,I$24,IF($D38<=$F$25,I$25,IF($D38<=$F$26,I$26,I$26))))))))">H38<OPTION value="=IF($D38<=$F$19,J$19,IF($D38<=$F$20,J$20,IF($D38<=$F$21,J$21,IF($D38<=$F$22,J$22,IF($D38<=$F$23,J$23,IF($D38<=$F$24,J$24,IF($D38<=$F$25,J$25,IF($D38<=$F$26,J$26,J$26))))))))">I38<OPTION value="=IF($D38<=$F$19,K$19,IF($D38<=$F$20,K$20,IF($D38<=$F$21,K$21,IF($D38<=$F$22,K$22,IF($D38<=$F$23,K$23,IF($D38<=$F$24,K$24,IF($D38<=$F$25,K$25,IF($D38<=$F$26,K$26,K$26))))))))">J38<OPTION value==K37+(E38-E37)*G38>K38<OPTION value='=IF(C$11="CI",1-1/((1+(C$12/(2*E38))^2)^(3/2)),2*(ATAN($F$13*$F$12/E38/SQRT($F$13*$F$13+$F$12*$F$12+E38*E38))+$F$13*$F$12*E38*(1/($F$13*$F$13+E38*E38)+1/($F$12*$F$12+E38*E38))/SQRT($F$13*$F$13+$F$12*$F$12+E38*E38))/PI())'>L38<OPTION value==L38*J$14>M38<OPTION value==M38+K38>N38<OPTION value="=IF(K38<J38,I38*J$15*LOG(J38/K38,10),0)">O38<OPTION value="=IF(J38<N38,H38*J$15*LOG(N38/K38),0)">P38<OPTION value==(P38+O38)*12>Q38<OPTION value==B38-J$15>B39<OPTION value==D38>C39<OPTION value==C39+J$15>D39<OPTION value==AVERAGE(C39:D39)>E39<OPTION value="=IF($D39<=$F$19,H$19,IF($D39<=$F$20,H$20,IF($D39<=$F$21,H$21,IF($D39<=$F$22,H$22,IF($D39<=$F$23,H$23,IF($D39<=$F$24,H$24,IF($D39<=$F$25,H$25,IF($D39<=$F$26,H$26,H$26))))))))">F39<OPTION value="=IF((C$14+E39)<=J$13,F39,IF(F39=0,0,F39-62.4))">G39<OPTION value="=IF($D39<=$F$19,I$19,IF($D39<=$F$20,I$20,IF($D39<=$F$21,I$21,IF($D39<=$F$22,I$22,IF($D39<=$F$23,I$23,IF($D39<=$F$24,I$24,IF($D39<=$F$25,I$25,IF($D39<=$F$26,I$26,I$26))))))))">H39<OPTION value="=IF($D39<=$F$19,J$19,IF($D39<=$F$20,J$20,IF($D39<=$F$21,J$21,IF($D39<=$F$22,J$22,IF($D39<=$F$23,J$23,IF($D39<=$F$24,J$24,IF($D39<=$F$25,J$25,IF($D39<=$F$26,J$26,J$26))))))))">I39<OPTION value="=IF($D39<=$F$19,K$19,IF($D39<=$F$20,K$20,IF($D39<=$F$21,K$21,IF($D39<=$F$22,K$22,IF($D39<=$F$23,K$23,IF($D39<=$F$24,K$24,IF($D39<=$F$25,K$25,IF($D39<=$F$26,K$26,K$26))))))))">J39<OPTION value==K38+(E39-E38)*G39>K39<OPTION value='=IF(C$11="CI",1-1/((1+(C$12/(2*E39))^2)^(3/2)),2*(ATAN($F$13*$F$12/E39/SQRT($F$13*$F$13+$F$12*$F$12+E39*E39))+$F$13*$F$12*E39*(1/($F$13*$F$13+E39*E39)+1/($F$12*$F$12+E39*E39))/SQRT($F$13*$F$13+$F$12*$F$12+E39*E39))/PI())'>L39<OPTION value==L39*J$14>M39<OPTION value==M39+K39>N39<OPTION value="=IF(K39<J39,I39*J$15*LOG(J39/K39,10),0)">O39<OPTION value="=IF(J39<N39,H39*J$15*LOG(N39/K39),0)">P39<OPTION value==(P39+O39)*12>Q39<OPTION value==B39-J$15>B40<OPTION value==D39>C40<OPTION value==C40+J$15>D40<OPTION value==AVERAGE(C40:D40)>E40<OPTION value="=IF($D40<=$F$19,H$19,IF($D40<=$F$20,H$20,IF($D40<=$F$21,H$21,IF($D40<=$F$22,H$22,IF($D40<=$F$23,H$23,IF($D40<=$F$24,H$24,IF($D40<=$F$25,H$25,IF($D40<=$F$26,H$26,H$26))))))))">F40<OPTION value="=IF((C$14+E40)<=J$13,F40,IF(F40=0,0,F40-62.4))">G40<OPTION value="=IF($D40<=$F$19,I$19,IF($D40<=$F$20,I$20,IF($D40<=$F$21,I$21,IF($D40<=$F$22,I$22,IF($D40<=$F$23,I$23,IF($D40<=$F$24,I$24,IF($D40<=$F$25,I$25,IF($D40<=$F$26,I$26,I$26))))))))">H40<OPTION value="=IF($D40<=$F$19,J$19,IF($D40<=$F$20,J$20,IF($D40<=$F$21,J$21,IF($D40<=$F$22,J$22,IF($D40<=$F$23,J$23,IF($D40<=$F$24,J$24,IF($D40<=$F$25,J$25,IF($D40<=$F$26,J$26,J$26))))))))">I40<OPTION value="=IF($D40<=$F$19,K$19,IF($D40<=$F$20,K$20,IF($D40<=$F$21,K$21,IF($D40<=$F$22,K$22,IF($D40<=$F$23,K$23,IF($D40<=$F$24,K$24,IF($D40<=$F$25,K$25,IF($D40<=$F$26,K$26,K$26))))))))">J40<OPTION value==K39+(E40-E39)*G40>K40<OPTION value='=IF(C$11="CI",1-1/((1+(C$12/(2*E40))^2)^(3/2)),2*(ATAN($F$13*$F$12/E40/SQRT($F$13*$F$13+$F$12*$F$12+E40*E40))+$F$13*$F$12*E40*(1/($F$13*$F$13+E40*E40)+1/($F$12*$F$12+E40*E40))/SQRT($F$13*$F$13+$F$12*$F$12+E40*E40))/PI())'>L40<OPTION value==L40*J$14>M40<OPTION value==M40+K40>N40<OPTION value="=IF(K40<J40,I40*J$15*LOG(J40/K40,10),0)">O40<OPTION value="=IF(J40<N40,H40*J$15*LOG(N40/K40),0)">P40<OPTION value==(P40+O40)*12>Q40<OPTION value==B40-J$15>B41<OPTION value==D40>C41<OPTION value==C41+J$15>D41<OPTION value==AVERAGE(C41:D41)>E41<OPTION value="=IF($D41<=$F$19,H$19,IF($D41<=$F$20,H$20,IF($D41<=$F$21,H$21,IF($D41<=$F$22,H$22,IF($D41<=$F$23,H$23,IF($D41<=$F$24,H$24,IF($D41<=$F$25,H$25,IF($D41<=$F$26,H$26,H$26))))))))">F41<OPTION value="=IF((C$14+E41)<=J$13,F41,IF(F41=0,0,F41-62.4))">G41<OPTION value="=IF($D41<=$F$19,I$19,IF($D41<=$F$20,I$20,IF($D41<=$F$21,I$21,IF($D41<=$F$22,I$22,IF($D41<=$F$23,I$23,IF($D41<=$F$24,I$24,IF($D41<=$F$25,I$25,IF($D41<=$F$26,I$26,I$26))))))))">H41<OPTION value="=IF($D41<=$F$19,J$19,IF($D41<=$F$20,J$20,IF($D41<=$F$21,J$21,IF($D41<=$F$22,J$22,IF($D41<=$F$23,J$23,IF($D41<=$F$24,J$24,IF($D41<=$F$25,J$25,IF($D41<=$F$26,J$26,J$26))))))))">I41<OPTION value="=IF($D41<=$F$19,K$19,IF($D41<=$F$20,K$20,IF($D41<=$F$21,K$21,IF($D41<=$F$22,K$22,IF($D41<=$F$23,K$23,IF($D41<=$F$24,K$24,IF($D41<=$F$25,K$25,IF($D41<=$F$26,K$26,K$26))))))))">J41<OPTION value==K40+(E41-E40)*G41>K41<OPTION value='=IF(C$11="CI",1-1/((1+(C$12/(2*E41))^2)^(3/2)),2*(ATAN($F$13*$F$12/E41/SQRT($F$13*$F$13+$F$12*$F$12+E41*E41))+$F$13*$F$12*E41*(1/($F$13*$F$13+E41*E41)+1/($F$12*$F$12+E41*E41))/SQRT($F$13*$F$13+$F$12*$F$12+E41*E41))/PI())'>L41<OPTION value==L41*J$14>M41<OPTION value==M41+K41>N41<OPTION value="=IF(K41<J41,I41*J$15*LOG(J41/K41,10),0)">O41<OPTION value="=IF(J41<N41,H41*J$15*LOG(N41/K41),0)">P41<OPTION value==(P41+O41)*12>Q41<OPTION value==B41-J$15>B42<OPTION value==D41>C42<OPTION value==C42+J$15>D42<OPTION value==AVERAGE(C42:D42)>E42<OPTION value="=IF($D42<=$F$19,H$19,IF($D42<=$F$20,H$20,IF($D42<=$F$21,H$21,IF($D42<=$F$22,H$22,IF($D42<=$F$23,H$23,IF($D42<=$F$24,H$24,IF($D42<=$F$25,H$25,IF($D42<=$F$26,H$26,H$26))))))))">F42<OPTION value="=IF((C$14+E42)<=J$13,F42,IF(F42=0,0,F42-62.4))">G42<OPTION value="=IF($D42<=$F$19,I$19,IF($D42<=$F$20,I$20,IF($D42<=$F$21,I$21,IF($D42<=$F$22,I$22,IF($D42<=$F$23,I$23,IF($D42<=$F$24,I$24,IF($D42<=$F$25,I$25,IF($D42<=$F$26,I$26,I$26))))))))">H42<OPTION value="=IF($D42<=$F$19,J$19,IF($D42<=$F$20,J$20,IF($D42<=$F$21,J$21,IF($D42<=$F$22,J$22,IF($D42<=$F$23,J$23,IF($D42<=$F$24,J$24,IF($D42<=$F$25,J$25,IF($D42<=$F$26,J$26,J$26))))))))">I42<OPTION value="=IF($D42<=$F$19,K$19,IF($D42<=$F$20,K$20,IF($D42<=$F$21,K$21,IF($D42<=$F$22,K$22,IF($D42<=$F$23,K$23,IF($D42<=$F$24,K$24,IF($D42<=$F$25,K$25,IF($D42<=$F$26,K$26,K$26))))))))">J42<OPTION value==K41+(E42-E41)*G42>K42<OPTION value='=IF(C$11="CI",1-1/((1+(C$12/(2*E42))^2)^(3/2)),2*(ATAN($F$13*$F$12/E42/SQRT($F$13*$F$13+$F$12*$F$12+E42*E42))+$F$13*$F$12*E42*(1/($F$13*$F$13+E42*E42)+1/($F$12*$F$12+E42*E42))/SQRT($F$13*$F$13+$F$12*$F$12+E42*E42))/PI())'>L42<OPTION value==L42*J$14>M42<OPTION value==M42+K42>N42<OPTION value="=IF(K42<J42,I42*J$15*LOG(J42/K42,10),0)">O42<OPTION value="=IF(J42<N42,H42*J$15*LOG(N42/K42),0)">P42<OPTION value==(P42+O42)*12>Q42<OPTION value==B42-J$15>B43<OPTION value==D42>C43<OPTION value==C43+J$15>D43<OPTION value==AVERAGE(C43:D43)>E43<OPTION value="=IF($D43<=$F$19,H$19,IF($D43<=$F$20,H$20,IF($D43<=$F$21,H$21,IF($D43<=$F$22,H$22,IF($D43<=$F$23,H$23,IF($D43<=$F$24,H$24,IF($D43<=$F$25,H$25,IF($D43<=$F$26,H$26,H$26))))))))">F43<OPTION value="=IF((C$14+E43)<=J$13,F43,IF(F43=0,0,F43-62.4))">G43<OPTION value="=IF($D43<=$F$19,I$19,IF($D43<=$F$20,I$20,IF($D43<=$F$21,I$21,IF($D43<=$F$22,I$22,IF($D43<=$F$23,I$23,IF($D43<=$F$24,I$24,IF($D43<=$F$25,I$25,IF($D43<=$F$26,I$26,I$26))))))))">H43<OPTION value="=IF($D43<=$F$19,J$19,IF($D43<=$F$20,J$20,IF($D43<=$F$21,J$21,IF($D43<=$F$22,J$22,IF($D43<=$F$23,J$23,IF($D43<=$F$24,J$24,IF($D43<=$F$25,J$25,IF($D43<=$F$26,J$26,J$26))))))))">I43<OPTION value="=IF($D43<=$F$19,K$19,IF($D43<=$F$20,K$20,IF($D43<=$F$21,K$21,IF($D43<=$F$22,K$22,IF($D43<=$F$23,K$23,IF($D43<=$F$24,K$24,IF($D43<=$F$25,K$25,IF($D43<=$F$26,K$26,K$26))))))))">J43<OPTION value==K42+(E43-E42)*G43>K43<OPTION value='=IF(C$11="CI",1-1/((1+(C$12/(2*E43))^2)^(3/2)),2*(ATAN($F$13*$F$12/E43/SQRT($F$13*$F$13+$F$12*$F$12+E43*E43))+$F$13*$F$12*E43*(1/($F$13*$F$13+E43*E43)+1/($F$12*$F$12+E43*E43))/SQRT($F$13*$F$13+$F$12*$F$12+E43*E43))/PI())'>L43<OPTION value==L43*J$14>M43<OPTION value==M43+K43>N43<OPTION value="=IF(K43<J43,I43*J$15*LOG(J43/K43,10),0)">O43<OPTION value="=IF(J43<N43,H43*J$15*LOG(N43/K43),0)">P43<OPTION value==(P43+O43)*12>Q43<OPTION value==B43-J$15>B44<OPTION value==D43>C44<OPTION value==C44+J$15>D44<OPTION value==AVERAGE(C44:D44)>E44<OPTION value="=IF($D44<=$F$19,H$19,IF($D44<=$F$20,H$20,IF($D44<=$F$21,H$21,IF($D44<=$F$22,H$22,IF($D44<=$F$23,H$23,IF($D44<=$F$24,H$24,IF($D44<=$F$25,H$25,IF($D44<=$F$26,H$26,H$26))))))))">F44<OPTION value="=IF((C$14+E44)<=J$13,F44,IF(F44=0,0,F44-62.4))">G44<OPTION value="=IF($D44<=$F$19,I$19,IF($D44<=$F$20,I$20,IF($D44<=$F$21,I$21,IF($D44<=$F$22,I$22,IF($D44<=$F$23,I$23,IF($D44<=$F$24,I$24,IF($D44<=$F$25,I$25,IF($D44<=$F$26,I$26,I$26))))))))">H44<OPTION value="=IF($D44<=$F$19,J$19,IF($D44<=$F$20,J$20,IF($D44<=$F$21,J$21,IF($D44<=$F$22,J$22,IF($D44<=$F$23,J$23,IF($D44<=$F$24,J$24,IF($D44<=$F$25,J$25,IF($D44<=$F$26,J$26,J$26))))))))">I44<OPTION value="=IF($D44<=$F$19,K$19,IF($D44<=$F$20,K$20,IF($D44<=$F$21,K$21,IF($D44<=$F$22,K$22,IF($D44<=$F$23,K$23,IF($D44<=$F$24,K$24,IF($D44<=$F$25,K$25,IF($D44<=$F$26,K$26,K$26))))))))">J44<OPTION value==K43+(E44-E43)*G44>K44<OPTION value='=IF(C$11="CI",1-1/((1+(C$12/(2*E44))^2)^(3/2)),2*(ATAN($F$13*$F$12/E44/SQRT($F$13*$F$13+$F$12*$F$12+E44*E44))+$F$13*$F$12*E44*(1/($F$13*$F$13+E44*E44)+1/($F$12*$F$12+E44*E44))/SQRT($F$13*$F$13+$F$12*$F$12+E44*E44))/PI())'>L44<OPTION value==L44*J$14>M44<OPTION value==M44+K44>N44<OPTION value="=IF(K44<J44,I44*J$15*LOG(J44/K44,10),0)">O44<OPTION value="=IF(J44<N44,H44*J$15*LOG(N44/K44),0)">P44<OPTION value==(P44+O44)*12>Q44<OPTION value==B44-J$15>B45<OPTION value==D44>C45<OPTION value==C45+J$15>D45<OPTION value==AVERAGE(C45:D45)>E45<OPTION value="=IF($D45<=$F$19,H$19,IF($D45<=$F$20,H$20,IF($D45<=$F$21,H$21,IF($D45<=$F$22,H$22,IF($D45<=$F$23,H$23,IF($D45<=$F$24,H$24,IF($D45<=$F$25,H$25,IF($D45<=$F$26,H$26,H$26))))))))">F45<OPTION value="=IF((C$14+E45)<=J$13,F45,IF(F45=0,0,F45-62.4))">G45<OPTION value="=IF($D45<=$F$19,I$19,IF($D45<=$F$20,I$20,IF($D45<=$F$21,I$21,IF($D45<=$F$22,I$22,IF($D45<=$F$23,I$23,IF($D45<=$F$24,I$24,IF($D45<=$F$25,I$25,IF($D45<=$F$26,I$26,I$26))))))))">H45<OPTION value="=IF($D45<=$F$19,J$19,IF($D45<=$F$20,J$20,IF($D45<=$F$21,J$21,IF($D45<=$F$22,J$22,IF($D45<=$F$23,J$23,IF($D45<=$F$24,J$24,IF($D45<=$F$25,J$25,IF($D45<=$F$26,J$26,J$26))))))))">I45<OPTION value="=IF($D45<=$F$19,K$19,IF($D45<=$F$20,K$20,IF($D45<=$F$21,K$21,IF($D45<=$F$22,K$22,IF($D45<=$F$23,K$23,IF($D45<=$F$24,K$24,IF($D45<=$F$25,K$25,IF($D45<=$F$26,K$26,K$26))))))))">J45<OPTION value==K44+(E45-E44)*G45>K45<OPTION value='=IF(C$11="CI",1-1/((1+(C$12/(2*E45))^2)^(3/2)),2*(ATAN($F$13*$F$12/E45/SQRT($F$13*$F$13+$F$12*$F$12+E45*E45))+$F$13*$F$12*E45*(1/($F$13*$F$13+E45*E45)+1/($F$12*$F$12+E45*E45))/SQRT($F$13*$F$13+$F$12*$F$12+E45*E45))/PI())'>L45<OPTION value==L45*J$14>M45<OPTION value==M45+K45>N45<OPTION value="=IF(K45<J45,I45*J$15*LOG(J45/K45,10),0)">O45<OPTION value="=IF(J45<N45,H45*J$15*LOG(N45/K45),0)">P45<OPTION value==(P45+O45)*12>Q45<OPTION value==B45-J$15>B46<OPTION value==D45>C46<OPTION value==C46+J$15>D46<OPTION value==AVERAGE(C46:D46)>E46<OPTION value="=IF($D46<=$F$19,H$19,IF($D46<=$F$20,H$20,IF($D46<=$F$21,H$21,IF($D46<=$F$22,H$22,IF($D46<=$F$23,H$23,IF($D46<=$F$24,H$24,IF($D46<=$F$25,H$25,IF($D46<=$F$26,H$26,H$26))))))))">F46<OPTION value="=IF((C$14+E46)<=J$13,F46,IF(F46=0,0,F46-62.4))">G46<OPTION value="=IF($D46<=$F$19,I$19,IF($D46<=$F$20,I$20,IF($D46<=$F$21,I$21,IF($D46<=$F$22,I$22,IF($D46<=$F$23,I$23,IF($D46<=$F$24,I$24,IF($D46<=$F$25,I$25,IF($D46<=$F$26,I$26,I$26))))))))">H46<OPTION value="=IF($D46<=$F$19,J$19,IF($D46<=$F$20,J$20,IF($D46<=$F$21,J$21,IF($D46<=$F$22,J$22,IF($D46<=$F$23,J$23,IF($D46<=$F$24,J$24,IF($D46<=$F$25,J$25,IF($D46<=$F$26,J$26,J$26))))))))">I46<OPTION value="=IF($D46<=$F$19,K$19,IF($D46<=$F$20,K$20,IF($D46<=$F$21,K$21,IF($D46<=$F$22,K$22,IF($D46<=$F$23,K$23,IF($D46<=$F$24,K$24,IF($D46<=$F$25,K$25,IF($D46<=$F$26,K$26,K$26))))))))">J46<OPTION value==K45+(E46-E45)*G46>K46<OPTION value='=IF(C$11="CI",1-1/((1+(C$12/(2*E46))^2)^(3/2)),2*(ATAN($F$13*$F$12/E46/SQRT($F$13*$F$13+$F$12*$F$12+E46*E46))+$F$13*$F$12*E46*(1/($F$13*$F$13+E46*E46)+1/($F$12*$F$12+E46*E46))/SQRT($F$13*$F$13+$F$12*$F$12+E46*E46))/PI())'>L46<OPTION value==L46*J$14>M46<OPTION value==M46+K46>N46<OPTION value="=IF(K46<J46,I46*J$15*LOG(J46/K46,10),0)">O46<OPTION value="=IF(J46<N46,H46*J$15*LOG(N46/K46),0)">P46<OPTION value==(P46+O46)*12>Q46<OPTION value==B46-J$15>B47<OPTION value==D46>C47<OPTION value==C47+J$15>D47<OPTION value==AVERAGE(C47:D47)>E47<OPTION value="=IF($D47<=$F$19,H$19,IF($D47<=$F$20,H$20,IF($D47<=$F$21,H$21,IF($D47<=$F$22,H$22,IF($D47<=$F$23,H$23,IF($D47<=$F$24,H$24,IF($D47<=$F$25,H$25,IF($D47<=$F$26,H$26,H$26))))))))">F47<OPTION value="=IF((C$14+E47)<=J$13,F47,IF(F47=0,0,F47-62.4))">G47<OPTION value="=IF($D47<=$F$19,I$19,IF($D47<=$F$20,I$20,IF($D47<=$F$21,I$21,IF($D47<=$F$22,I$22,IF($D47<=$F$23,I$23,IF($D47<=$F$24,I$24,IF($D47<=$F$25,I$25,IF($D47<=$F$26,I$26,I$26))))))))">H47<OPTION value="=IF($D47<=$F$19,J$19,IF($D47<=$F$20,J$20,IF($D47<=$F$21,J$21,IF($D47<=$F$22,J$22,IF($D47<=$F$23,J$23,IF($D47<=$F$24,J$24,IF($D47<=$F$25,J$25,IF($D47<=$F$26,J$26,J$26))))))))">I47<OPTION value="=IF($D47<=$F$19,K$19,IF($D47<=$F$20,K$20,IF($D47<=$F$21,K$21,IF($D47<=$F$22,K$22,IF($D47<=$F$23,K$23,IF($D47<=$F$24,K$24,IF($D47<=$F$25,K$25,IF($D47<=$F$26,K$26,K$26))))))))">J47<OPTION value==K46+(E47-E46)*G47>K47<OPTION value='=IF(C$11="CI",1-1/((1+(C$12/(2*E47))^2)^(3/2)),2*(ATAN($F$13*$F$12/E47/SQRT($F$13*$F$13+$F$12*$F$12+E47*E47))+$F$13*$F$12*E47*(1/($F$13*$F$13+E47*E47)+1/($F$12*$F$12+E47*E47))/SQRT($F$13*$F$13+$F$12*$F$12+E47*E47))/PI())'>L47<OPTION value==L47*J$14>M47<OPTION value==M47+K47>N47<OPTION value="=IF(K47<J47,I47*J$15*LOG(J47/K47,10),0)">O47<OPTION value="=IF(J47<N47,H47*J$15*LOG(N47/K47),0)">P47<OPTION value==(P47+O47)*12>Q47</OPTION></SELECT></TD><TD align=right width="3%" bgColor=#d4d0c8>=</TD><TD align=left bgColor=white><INPUT size=80 value==D12 name=txbFb150492></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>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><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>K</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>L</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>M</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>N</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>O</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>P</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>Q</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>17</CENTER></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center" rowSpan=2>Soil #</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center" rowSpan=2>Soil Name</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">Thickness</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">Top</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: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">Bottom</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: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">Top Elevation</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">Unit Weight</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center" rowSpan=2>Cc/(1+e)</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center" rowSpan=2>Cr/(1+e)</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">s p'</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" colSpan=2>Settlement</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: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </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: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </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: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #000000 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: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </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>18</CENTER></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">ft</FONT></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">ft</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: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">ft</FONT></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">ft</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">lbs/ft^3</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: middle; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">psf</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" colSpan=2>inches</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: right"> </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: right"> </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: right"> </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: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </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>19</CENTER></TD><TD style="BORDER-RIGHT: #000000 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">1</TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">A</TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">10.0</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.0</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: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">10.0</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">100.0</TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">120</TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">0.010</TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">0.005</TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">0</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" colSpan=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: right"> </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: right"> </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: right"> </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: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </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>20</CENTER></TD><TD style="BORDER-RIGHT: #000000 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</TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">B</TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">15.0</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.0</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: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">25.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: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">90.0</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">120</TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">0.005</TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">0.002</TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">0</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" colSpan=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: right"> </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: right"> </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: right"> </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: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </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>21</CENTER></TD><TD style="BORDER-RIGHT: #000000 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">3</TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">C</TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">5.0</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">25.0</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: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">30.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: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">75.0</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">120</TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">0.010</TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">0.009</TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">0</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" colSpan=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: right"> </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: right"> </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: right"> </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: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </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>22</CENTER></TD><TD style="BORDER-RIGHT: #000000 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">4</TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"> </TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"> </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">30.0</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: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">30.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: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">70.0</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"> </TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"> </TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"> </TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; 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" colSpan=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: right"> </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: right"> </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: right"> </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: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </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>23</CENTER></TD><TD style="BORDER-RIGHT: #000000 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">5</TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"> </TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"> </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">30.0</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: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">30.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: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">70.0</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"> </TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"> </TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"> </TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; 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" colSpan=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: right"> </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: right"> </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: right"> </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: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </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>24</CENTER></TD><TD style="BORDER-RIGHT: #000000 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">6</TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"> </TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"> </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">30.0</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: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">30.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: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">70.0</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"> </TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"> </TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"> </TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; 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" colSpan=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: right"> </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: right"> </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: right"> </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: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </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>25</CENTER></TD><TD style="BORDER-RIGHT: #000000 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">7</TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"> </TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"> </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">30.0</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: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">30.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: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">70.0</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"> </TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"> </TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"> </TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; 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" colSpan=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: right"> </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: right"> </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: right"> </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: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </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>26</CENTER></TD><TD style="BORDER-RIGHT: #000000 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">8</TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"> </TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"> </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">30.0</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: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">30.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: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">70.0</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"> </TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"> </TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"> </TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bot
 

Some videos you may like

Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).

DaveWW00

New Member
Joined
Feb 3, 2006
Messages
39
So i tried to post the excel sheet i have a question on but the sheet is too big too fit apparently (heres a simplified version).
Book1
CDEFG
4DepthSettlement
5TopBottom
6010Settlementfrom0to10feet
71015Settlementfrom10to15feet
81520Settlementfrom15to20feet
9Total=0.732
10
11DepthCalculationsSettlement
121VariousCalculations0.100
1320.090
1430.080
1540.070
1650.060
1760.050
1870.040
1980.037
2090.034
21100.031
22110.028
23120.025
24130.022
25140.019
26150.016
27160.013
28170.010
29180.007
30190.000
31200.000
Sheet1


Basically what i need is formulas for cells E6 to E8 to calculate the settlement in each layer. However, the thing that makes this complicated is that the depths will change. Also i dont think it can be something like TOTAL-layer1-layer2-layer3 because the layers are independent and doing it that way might create wrong values.

Any suggestions how to do this?
 

hayden

Board Regular
Joined
Sep 23, 2005
Messages
159
I am not totally sure I understand what you want but here is my best guess. Let me know if this works for you or not.

In another column write an if statement to determine which layer you are in. This would look something like this

=if(f12>=$c$8,3,if(f12<$d$6,1,2))

Drag this formula down for all the settlement values in f.

Now in cells e6-e8 you can use the sumif statemnt.

=sumif(range containing layer values,1,range containing settlements)

That formula would go in e6
For E7 you would need to change the 1 to a 2 etc.


Range containing layer values is the range of cells containing the 1,2,3 from the if statement,

Range containg settlement values is f12 - fwhatever

Good luck. Don't forget the help in excel.

Hayden
 

Watch MrExcel Video

Forum statistics

Threads
1,114,059
Messages
5,545,758
Members
410,704
Latest member
Cobber2008
Top