Need to sum values based on varying values in other cells

DaveWW00

New Member
Joined
Feb 3, 2006
Messages
40
<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
 

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.

DaveWW00

New Member
Joined
Feb 3, 2006
Messages
40
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
 

Forum statistics

Threads
1,141,914
Messages
5,709,313
Members
421,627
Latest member
bennhrios9

We've detected that you are using an adblocker.

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

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

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

Disable uBlock

Follow these easy steps to disable uBlock

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