【会计四期】第三讲上交作业贴（23-44号）

無心

<p><font size="5">请大家使用威望帖交作业，不要用回复可见，如果没交正确，可以重复编辑，不要重复发贴。</font></p><p><font color="#000000" size="5"><a href="http://www.excelpx.com/forum.php?mod=viewthread&tid=129699" target="_blank">威望帖的发帖方法</a></font></p><p>&nbsp;<font size="3"><span lang="EN-US" style="FONT-SIZE: 9pt; COLOR: black; FONT-FAMILY: tahoma;">
                                <p><strong></strong></p></span></font></p><p><strong></strong></p><p></p><p><strong><font color="#3300ff"></font></strong></p><p></p><p><strong><font color="#3300ff"></font></strong></p><p><strong><font color="#3300ff"></font></strong></p><p style="BACKGROUND: white; WORD-BREAK: break-all; TEXT-INDENT: 18pt;"><font size="3"><span><strong><font color="#3300ff">1、<font color="#ff0066">非本班成员严禁回复</font>，一经发现按抄袭论处，删贴扣币币；</font></strong></span><span lang="EN-US" style="FONT-SIZE: 9pt; COLOR: black; FONT-FAMILY: tahoma;"><strong><font color="#3300ff">
                                        </font></strong><p><strong><font color="#3300ff"></font></strong></p></span></font></p><p><strong><font color="#3300ff"></font></strong></p><p></p><p><strong><font color="#3300ff"></font></strong></p><p></p><p><strong><font color="#3300ff"></font></strong></p><p><strong><font color="#3300ff"></font></strong></p><p style="BACKGROUND: white; WORD-BREAK: break-all; TEXT-INDENT: 18pt;"><font size="3"><span><strong><font color="#3300ff">2、作业上交截止时间为<font color="#ff0066">本周日下午17点</font>；</font></strong></span><span lang="EN-US" style="FONT-SIZE: 9pt; COLOR: black; FONT-FAMILY: tahoma;"><strong><font color="#3300ff">
                                        </font></strong><p><strong><font color="#3300ff"></font></strong></p></span></font></p><p><strong><font color="#3300ff"></font></strong></p><p></p><p><strong><font color="#3300ff"></font></strong></p><p></p><p><strong><font color="#3300ff"></font></strong></p><p><strong><font color="#3300ff"></font></strong></p><p style="BACKGROUND: white; WORD-BREAK: break-all; TEXT-INDENT: 18pt;"><font size="3"><span><strong><font color="#3300ff">3、<font color="#ff0066">交白卷的视为未交作业</font>；</font></strong></span><span lang="EN-US" style="COLOR: #ff6600; FONT-FAMILY: tahoma;"><strong><font color="#3300ff">
                                        </font></strong><p><strong><font color="#3300ff"></font></strong></p></span></font></p><p><strong><font color="#3300ff"></font></strong></p><p></p><p><strong><font color="#3300ff"></font></strong></p><p></p><p><strong><font color="#3300ff"></font></strong></p><p><strong><font color="#3300ff"></font></strong></p><p style="BACKGROUND: white; WORD-BREAK: break-all; TEXT-INDENT: 18pt;"><strong><font color="#3300ff"><font size="3"><span>4、上交好<font color="#ff0066">作业后再投票</font>(非本组成员严禁投票)。</span></font><span lang="EN-US" style="FONT-SIZE: 9pt; COLOR: black; FONT-FAMILY: tahoma;">
                                </span></font></strong></p>

小灰太狼

[Power=1]<p>1、=SUM(C4:F4)+IF(COUNTIF(C4:F4,"&gt;60")&gt;3,30,IF(COUNTIF(C4:F4,"&gt;60")&gt;2,20,))</p><p>2、=IF(C14-D14=0,"是","否")</p><p>3、=SUM(B22:G27)</p><p>4-1、=SUMPRODUCT((B31:B44="BB")*(D31:D44&gt;1)*E31:E44)<br/>4-2、=SUMPRODUCT(((B31:B44="BB")+(B31:B44="CC"))*D31:D44*E31:E44)<br/>4-3、=SUMPRODUCT((B31:B44="AA")*(E31:E44&gt;200))</p><p>5、=SUMIF(B51:E59,"??R*",C51)</p><p>6-1、=SUMPRODUCT((J3:J22&lt;-1)+(J3:J22&gt;5)-(J3:J22=9))<br/>6-2、=SUMPRODUCT(((J3:J22&lt;-1)+(J3:J22&gt;5)-(J3:J22=9))*J3:J22)</p><p>7、=COUNTIF(K26:K35,"*中学")</p><p>8、=SUMIF(K43:K69,K41&amp;"*",L43:L69)</p><p>选1、=COUNTIF(C3:C12,"&gt;80000")*500+500*COUNT(C3:C12)</p><p>选2、=SUMPRODUCT((C17:C31=G16:I16)*D17:D31*G17:I17)</p><p>选3、=SUMPRODUCT(COUNTIF(B35:B44,C35:C44)<font color="#ee1111"><strong><em><u>*1</u></em></strong></font>)&nbsp; <font color="#f70909">多余了</font></p><p>选4-1、=SUMIF($B$48:$N$48,$C$60,B49:N49)<br/></p><p>选4-2、=SUMIF($C$48:$N$48,"&lt;="&amp;$C$60,C49:N49)</p><p>终于想出来了</p><p><font color="#f70909">算全对了！</font></p><p><font color="#f70909">——dgxsdr</font></p>

[此贴子已经被無心于2010-6-8 0:39:27编辑过]

hx910

[Power=1]<p>02028&nbsp; hx910交作业</p><p></p><p>[Power=1]</p><p>作业1：=SUM(C4:F4)+IF(COUNTIF(C4:F4,"&gt;60")=4,30,IF(COUNTIF(C4:F4,"&gt;60")=3,20))</p><p>作业2：=IF(C14*1=D14*1,"是","否")</p><p>作业3:=SUM(C22:C27,E22:E27,G22:G27)&nbsp; <font color="#ee1111"><strong><em><u>可简化</u></em></strong></font></p><p>作业4:=SUMPRODUCT((B31:B44="BB")*(D31:D44&gt;1)*E31:E44)</p><p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =SUMPRODUCT(((B31:B44="BB")+(B31:B44="CC"))*D31:D44*E31:E44)</p><p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; =SUMPRODUCT((B31:B44="AA")*(E31:E44&gt;200))</p><p>作业5:=SUMIF(B51:E59,"??R*",C51:F59)</p><p>作业6:=COUNTIF(J3:J22,"&lt;-1")+COUNTIF(J3:J22,"&gt;5")-COUNTIF(J3:J22,9)</p><p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =SUMIF(J3:J22,"&lt;-1",J3)+SUMIF(J3:J22,"&gt;5",J3)-SUMIF(J3:J22,9,J3)</p><p>作业7=COUNTIF(K25:K35,"*中学")</p><p>作业8=SUMIF(K43:K69,"*"&amp;RIGHT(K41,6),L43)</p><p>选做题1：{=SUM(IF(C3:C12&gt;80000,1000,500))}</p><p>选做题2:&nbsp; {=SUM(SUMIF(C17:C31,G16:I16,D17)*G17:I17)}</p><p>选做题3&nbsp; {=SUM(COUNTIF(B35:C44,B35:B44)-COUNTIF(B35:B44,B35:B44))}&nbsp; <font color="#ee1111"><strong><em><u>可简化</u></em></strong></font></p><p>选做题4:&nbsp; 本月数=SUMIF($C$48:$N$48,$C$60,C49)</p><p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 累计数=SUMIF($C$48:$N$48,"&lt;="&amp;$C$60,C49)</p><p><font color="#e61a1a">总体较好！</font></p><p><font color="#e61a1a">——dgxsdr</font></p><p></p><p></p><p></p><p></p><p></p><p></p>

[此贴子已经被無心于2010-6-8 0:39:41编辑过]

林玲玲

[Power=1][Power=http://go.leiju.com/e/e1.asp?search=1] <p>&nbsp;<span lang="EN-US"><font face="Calibri">1,=IF(COUNTIF(C4:F4,"&gt;60")=4,SUM(C4:F4)+30,IF(COUNTIF(C4:F4,"&gt;60")=3,SUM(C4:F4)+20,SUM(C4:F4)))&nbsp; <font color="#f70909">可简化</font></font></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span lang="EN-US"><font face="Calibri">2,=IF(C14*1=D14*1,"</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin;">是</span><span lang="EN-US"><font face="Calibri">","</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin;">否</span><span lang="EN-US"><font face="Calibri">")</font></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span lang="EN-US"><font face="Calibri">3, =SUM(B22:G27)</font></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span lang="EN-US"><font face="Calibri">4,1)=SUMPRODUCT((B31:B44="BB")*(D31:D44&gt;1)*(E31:E44));{=SUM((B31:B44="BB")*(D31:D44&gt;1)*(E31:E44))}</font></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span lang="EN-US"><font face="Calibri"><span style="mso-spacerun: yes;">&nbsp; </span>2)SUMPRODUCT((B31:B44={"BB","CC"})*(D31:D44*E31:E44));{SUM((B31:B44={"BB","CC"})*(D31:D44*E31:E44))}</font></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span lang="EN-US"><font face="Calibri">3) SUMPRODUCT((B31:B44="AA")*(E31:E44&gt;200));{SUM((B31:B44="AA")*(E31:E44&gt;200))}</font></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span lang="EN-US"><font face="Calibri">5, =SUMIF(B51:E59,"??R*",C51:F59)</font></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span lang="EN-US"><font face="Calibri">6, 1)=COUNTIF(J3:J22,"&lt;-1")+COUNTIF(J3:J22,"&gt;5")-COUNTIF(J3:J22,"=9")</font></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span lang="EN-US"><font face="Calibri"><span style="mso-spacerun: yes;">&nbsp; </span>2) =SUMIF(J3:J22,"&lt;-1")+SUMIF(J3:J22,"&gt;5")-SUMIF(J3:J22,"=9")</font></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span lang="EN-US"><font face="Calibri">7,{=SUM(--ISNUMBER(FIND("</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin;">中学</span><span lang="EN-US"><font face="Calibri">",K26:K35)))}</font></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span lang="EN-US"><font face="Calibri">8, =SUMIF(K43:K69,K41&amp;"*",L43:L69)</font></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin;">选做题</span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span lang="EN-US"><font face="Calibri">1,{=SUM(--(C3:C12&gt;80000))*1000+SUM(--(C3:C12&lt;80000)*500)}</font></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><font face="Calibri"><span lang="EN-US">2, </span><span lang="EN-US" style="FONT-SIZE: 9.5pt; mso-bidi-font-size: 11.0pt;">{</span><span lang="EN-US">=SUM(SUMIF(C17:C31,G16:I16,D17:D31)*G17:I17)}</span></font></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><font face="Calibri"><span lang="EN-US">3, </span><span lang="EN-US" style="FONT-SIZE: 9.5pt; mso-bidi-font-size: 11.0pt;">{</span><span lang="EN-US">=SUM(COUNTIF(B35:B44,C35:C44))}</span></font></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span lang="EN-US"><font face="Calibri">4,</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin;">本月数</span><span lang="EN-US"><font face="Calibri">=SUMIF($C$48:$N$48,$C$60,$C49:$N49)</font></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span lang="EN-US"><span style="mso-spacerun: yes;"><font face="Calibri">&nbsp; </font></span></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin;">累计数</span><span lang="EN-US"><font face="Calibri">=SUMIF($C$48:$N$48,"&lt;="&amp;($C$60),$C49:$N49)</font></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span lang="EN-US"><font face="Calibri" color="#f70909">总体不错！</font></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span lang="EN-US"><font face="Calibri" color="#f70909">——dgxsdr</font></span></p><p></p>

[此贴子已经被無心于2010-6-8 0:39:57编辑过]

hwsh1002

[Power=1]<p>作业1：<br/>=IF(COUNTIF(C4:F4,"&gt;60")=4,SUM(C4:F4)+30,IF(COUNTIF(C4:F4,"&gt;60")=3,SUM(C4:F4)+20,SUM(C4:F4)))&nbsp; <font color="#f70909">可简化</font><br/>作业2：<br/>=IF(--C14=--D14,"是","否")<br/>作业3：<br/>=SUM(C22:C27,E22:E27,G22:G27)&nbsp; <font color="#e61a1a">可简化</font><br/>作业4：<br/>①=SUMPRODUCT((B31:B44="BB")*(D31:D44&gt;1)*E31:E44)<br/>②=SUMPRODUCT((B31:B44="BB")*(E31:E44)*(D31:D44))+SUMPRODUCT((B31:B44="CC")*(E31:E44)*(D31:D44))&nbsp; <font color="#e61a1a">要简化！<br/></font>③=SUMPRODUCT((B31:B44="AA")*(E31:E44&gt;200))<br/>作业5：<br/>=SUMIF(B51:E59,"??R*",C51:F59)<br/>作业6：<br/>①=SUMPRODUCT((J3:J22&lt;-1)+(J3:J22&gt;5)*(J3:J22&lt;&gt;9))<br/>②=SUMPRODUCT((J3:J22&lt;-1)*J3:J22)+SUMPRODUCT((J3:J22&gt;5)*J3:J22)-SUMPRODUCT((J3:J22=9)*J3:J22)&nbsp; <font color="#f70909">要简化！<br/></font>作业7：<br/>=COUNTIF(K26:K35,"??中学")<br/>作业8：<br/>=SUMPRODUCT((K43:K69=K41)*(L43:L69))<br/>选作题1：<br/>=SUM(IF(C3:C12&gt;80000,1000,500))按三键确定<br/>选做题2：<br/>=SUMPRODUCT(SUMIF(C17:C31,G16:I16,D17)*G17:I17)<br/>选做题3：<br/>=SUMPRODUCT(COUNTIF(B35:B44,C35:C44))<br/>选做题4：<br/>①=SUMIF($C$48:$N$48,$C$60,C49:N49)<br/>②=SUMIF($C$48:$N$48,"&lt;="&amp;$C$60,C49:N49)</p><p><font color="#dd2222">总体尚可，但有些概念还不清楚！</font></p><p><font color="#dd2222">——dgxsdr</font></p>

[此贴子已经被無心于2010-6-8 0:40:12编辑过]

EZD

<p>[Power=1] hSAVMqNo.rar (32.07 KB, 下载次数: 1)

2010-6-1 21:31 上传

点击文件名下载附件
【会计四期】第三讲上交作业贴（23-44号） </p><p><font color="#ee1111">作业1不对！</font></p><p><font color="#ee1111">作业4试试用SUM数组公式！</font></p><p><font color="#ee1111">选作题2要简化！</font></p><p><font color="#ee1111">——dgxsdr<br/></font></p>

[此贴子已经被無心于2010-6-8 0:40:31编辑过]

真永远

<p>[Power=1]1、=IF(AND(F4&gt;60,D4&gt;60,E4&gt;60,F4&gt;60),SUM(C4:F4)+30,IF(OR((F4,D4,E4,F4)&lt;60),SUM(C4:F4)+20,SUM(C4:F4)))&nbsp; <font color="#ee1111">要简化！</font><br/>2、=IF(DELTA(C14,D14),"是","否")<br/>3、=SUM(C22:C27,E22:E27,G22:G27)&nbsp; <font color="#dd4822">要简化！</font><br/>4、=SUMPRODUCT((B31:B44="BB")*1,(D31:D44&gt;1)*1,(E31:E44)*1)<br/>=SUMPRODUCT((B31:B44="BB")*1,D31:D44,E31:E44)+SUMPRODUCT((B31:B44="CC")*1,D31:D44,E31:E44)<br/>=SUMPRODUCT((B31:B44="AA")*(E31:E44&gt;200))&nbsp; <font color="#ee1111">试试SUM数组公式！</font><br/>5、=SUMIF(B51:B59,"??R*",C51:C59)+SUMIF(E51:E58,"??R*",F51:F58)&nbsp; <font color="#f70909">可简化！</font><br/>6、<br/>7、=COUNTIF(K26:K35,"*中学")<br/>8、=SUMIF(K43:K69,"K41",L43:L69)&nbsp; <font color="#f70909">不对！</font></p><p><font color="#f70909">继续努力！</font></p><p><font color="#f70909">——dgxsdr</font><br/></p>

[此贴子已经被無心于2010-6-8 0:40:46编辑过]

adinge

<p>[Power=1]</p><p>忙里偷空，先交一部分，有时间了再继续做，继续交</p><p>作业1：</p><p>作业2：&nbsp; =IF(C14*1=D14*1,"是","否")</p><p>作业3： =SUM(C22:C27,E22:E27,G22:G27)&nbsp; <font color="#f70909">可简化！</font></p><p>作业4：</p><p><font color="#ee1111">继续努力！</font></p><p><font color="#ee1111">——dgxsdr</font></p><p></p>

[此贴子已经被無心于2010-6-8 0:41:09编辑过]

tyghgood1978

[Power=1][Power=1] <p>1题,不会</p><p>2题:=IF(VALUE(C14)=VALUE(D14),"是","否")</p><p>3题:=SUM(C22:C27,E22:E27,G22:G27)&nbsp;&nbsp;&nbsp; <font color="#ff0000">可简化！</font></p><p>4题不会组合公式 <table cellspacing="0" cellpadding="0" width="628" border="0" style="WIDTH: 473pt; BORDER-COLLAPSE: collapse;"><colgroup><col span="4" width="72" style="WIDTH: 54pt;"></col><col></col><col></col><col></col><col width="82" style="WIDTH: 62pt; mso-width-source: userset; mso-width-alt: 2624;"></col><col></col><col></col><col></col><col span="3" width="86" style="WIDTH: 65pt; mso-width-source: userset; mso-width-alt: 2752;"></col><col></col><col></col><col></col></colgroup><tbody><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl29" width="72" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 54pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: #ffcc99;"><font size="2"><strong>产品编号</strong></font></td><td class="xl29" width="72" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 54pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffcc99;"><font size="2"><strong>生产日期</strong></font></td><td class="xl29" width="72" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 54pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffcc99;"><font size="2"><strong>产品单价</strong></font></td><td class="xl29" width="72" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 54pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffcc99;"><font size="2"><strong>产品数量</strong></font></td><td class="xl30" width="82" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f2f2f2; BORDER-LEFT: windowtext; WIDTH: 62pt; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: #ffcc99;"><font size="2"><strong>BB</strong></font></td><td class="xl31" width="86" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f2f2f2; BORDER-LEFT: windowtext; WIDTH: 65pt; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: #ffcc99;"><font size="2"><strong><font face="宋体">单价大于</font><font class="font6">1</font></strong></font></td><td class="xl31" width="86" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f2f2f2; BORDER-LEFT: windowtext; WIDTH: 65pt; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: #ffcc99;"><font face="宋体" size="2"><strong>相</strong></font></td><td class="xl31" width="86" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f2f2f2; BORDER-LEFT: windowtext; WIDTH: 65pt; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: #ffcc99;"><strong><font face="宋体" size="2">数量总和</font></strong></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl27" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font size="2">AA</font></td><td class="xl28" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">2000-6-15</font></td><td class="xl27" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">1</font></td><td class="xl27" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">100</font></td><td align="center" xfmla="=(A2:A15=&quot;BB&quot;)" xbool="FALSE" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font face="宋体">FALSE</font></td><td align="center" xfmla="=C2&gt;1" xbool="FALSE" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font face="宋体">FALSE</font></td><td align="right" xfmla="=E2*F2" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font face="宋体">0</font></td><td align="right" xfmla="=D2*G2" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font face="宋体">0</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl27" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font size="2">AA</font></td><td class="xl28" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">2000-6-20</font></td><td class="xl27" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">1</font></td><td class="xl27" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">125</font></td><td align="center" xfmla="=(A3:A16=&quot;BB&quot;)" xbool="FALSE" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font face="宋体">FALSE</font></td><td align="center" xfmla="=C3&gt;1" xbool="FALSE" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font face="宋体">FALSE</font></td><td align="right" xfmla="=E3*F3" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font face="宋体">0</font></td><td align="right" xfmla="=D3*G3" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font face="宋体">0</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl27" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font size="2">BB</font></td><td class="xl28" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">2000-6-30</font></td><td class="xl27" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">2</font></td><td class="xl27" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">150</font></td><td align="center" xbool="TRUE" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font face="宋体">TRUE</font></td><td align="center" xfmla="=C4&gt;1" xbool="TRUE" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font face="宋体">TRUE</font></td><td align="right" xfmla="=E4*F4" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font face="宋体">1</font></td><td align="right" xfmla="=D4*G4" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font face="宋体">150</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl27" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font size="2">BB</font></td><td class="xl28" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">2000-7-10</font></td><td class="xl27" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">2</font></td><td class="xl27" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">175</font></td><td align="center" xbool="TRUE" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font face="宋体">TRUE</font></td><td align="center" xfmla="=C5&gt;1" xbool="TRUE" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font face="宋体">TRUE</font></td><td align="right" xfmla="=E5*F5" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font face="宋体">1</font></td><td align="right" xfmla="=D5*G5" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font face="宋体">175</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl27" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font size="2">CC</font></td><td class="xl28" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">2000-7-15</font></td><td class="xl27" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">3</font></td><td class="xl27" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">200</font></td><td align="center" xbool="FALSE" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font face="宋体">FALSE</font></td><td align="center" xfmla="=C6&gt;1" xbool="TRUE" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font face="宋体">TRUE</font></td><td align="right" xfmla="=E6*F6" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font face="宋体">0</font></td><td align="right" xfmla="=D6*G6" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font face="宋体">0</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl27" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font size="2">CC</font></td><td class="xl28" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">2000-7-20</font></td><td class="xl27" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">3</font></td><td class="xl27" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">225</font></td><td align="center" xbool="FALSE" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font face="宋体">FALSE</font></td><td align="center" xfmla="=C7&gt;1" xbool="TRUE" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font face="宋体">TRUE</font></td><td align="right" xfmla="=E7*F7" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font face="宋体">0</font></td><td align="right" xfmla="=D7*G7" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font face="宋体">0</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl27" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font size="2">AA</font></td><td class="xl28" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">2000-7-30</font></td><td class="xl27" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">1</font></td><td class="xl27" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">250</font></td><td align="center" xbool="FALSE" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font face="宋体">FALSE</font></td><td align="center" xfmla="=C8&gt;1" xbool="FALSE" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font face="宋体">FALSE</font></td><td align="right" xfmla="=E8*F8" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font face="宋体">0</font></td><td align="right" xfmla="=D8*G8" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font face="宋体">0</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl27" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font size="2">AA</font></td><td class="xl28" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">2000-8-10</font></td><td class="xl27" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">1</font></td><td class="xl27" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">275</font></td><td align="center" xbool="FALSE" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font face="宋体">FALSE</font></td><td align="center" xfmla="=C9&gt;1" xbool="FALSE" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font face="宋体">FALSE</font></td><td align="right" xfmla="=E9*F9" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font face="宋体">0</font></td><td align="right" xfmla="=D9*G9" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font face="宋体">0</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl27" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font size="2">BB</font></td><td class="xl28" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">2000-8-15</font></td><td class="xl27" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">2</font></td><td class="xl27" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">300</font></td><td align="center" xbool="TRUE" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font face="宋体">TRUE</font></td><td align="center" xfmla="=C10&gt;1" xbool="TRUE" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font face="宋体">TRUE</font></td><td align="right" xfmla="=E10*F10" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font face="宋体">1</font></td><td align="right" xfmla="=D10*G10" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font face="宋体">300</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl27" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font size="2">BB</font></td><td class="xl28" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">2000-8-20</font></td><td class="xl27" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">2</font></td><td class="xl27" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">325</font></td><td align="center" xbool="TRUE" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font face="宋体">TRUE</font></td><td align="center" xfmla="=C11&gt;1" xbool="TRUE" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font face="宋体">TRUE</font></td><td align="right" xfmla="=E11*F11" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font face="宋体">1</font></td><td align="right" xfmla="=D11*G11" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font face="宋体">325</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl27" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font size="2">CC</font></td><td class="xl28" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">2000-8-30</font></td><td class="xl27" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">3</font></td><td class="xl27" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">350</font></td><td align="center" xbool="FALSE" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font face="宋体">FALSE</font></td><td align="center" xfmla="=C12&gt;1" xbool="TRUE" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font face="宋体">TRUE</font></td><td align="right" xfmla="=E12*F12" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font face="宋体">0</font></td><td align="right" xfmla="=D12*G12" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font face="宋体">0</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl27" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font size="2">CC</font></td><td class="xl28" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">2000-10-10</font></td><td class="xl27" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">3</font></td><td class="xl27" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">375</font></td><td align="center" xbool="FALSE" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font face="宋体">FALSE</font></td><td align="center" xfmla="=C13&gt;1" xbool="TRUE" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font face="宋体">TRUE</font></td><td align="right" xfmla="=E13*F13" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font face="宋体">0</font></td><td align="right" xfmla="=D13*G13" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font face="宋体">0</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl27" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font size="2">DD</font></td><td class="xl28" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">2000-10-15</font></td><td class="xl27" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">4</font></td><td class="xl27" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">400</font></td><td align="center" xbool="FALSE" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font face="宋体">FALSE</font></td><td align="center" xfmla="=C14&gt;1" xbool="TRUE" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font face="宋体">TRUE</font></td><td align="right" xfmla="=E14*F14" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font face="宋体">0</font></td><td align="right" xfmla="=D14*G14" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font face="宋体">0</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl27" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font size="2">DD</font></td><td class="xl28" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">2000-10-30</font></td><td class="xl27" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">4</font></td><td class="xl27" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">425</font></td><td align="center" xbool="FALSE" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font face="宋体">FALSE</font></td><td align="center" xfmla="=C15&gt;1" xbool="TRUE" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font face="宋体">TRUE</font></td><td align="right" xfmla="=E15*F15" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font face="宋体">0</font></td><td align="right" xfmla="=D15*G15" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font face="宋体">0</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td height="19" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font face="宋体"></font></td><td style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font face="宋体"></font></td><td style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font face="宋体"></font></td><td style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font face="宋体"></font></td><td style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font face="宋体"></font></td><td class="xl32" colspan="2" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font face="宋体">合计</font></td><td align="right" xfmla="=SUM(H2:H15)" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font face="宋体">950</font></td></tr></tbody></table></p><p><table cellspacing="0" cellpadding="0" width="542" border="0" style="WIDTH: 408pt; BORDER-COLLAPSE: collapse;"><colgroup><col span="4" width="72" style="WIDTH: 54pt;"></col><col></col><col></col><col></col><col width="82" style="WIDTH: 62pt; mso-width-source: userset; mso-width-alt: 2624;"></col><col></col><col></col><col></col><col span="2" width="86" style="WIDTH: 65pt; mso-width-source: userset; mso-width-alt: 2752;"></col><col></col><col></col><col></col></colgroup><tbody><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl29" width="72" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 54pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: #ffcc99;"><font size="2"><strong>产品编号</strong></font></td><td class="xl29" width="72" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 54pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffcc99;"><font size="2"><strong>生产日期</strong></font></td><td class="xl29" width="72" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 54pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffcc99;"><font size="2"><strong>产品单价</strong></font></td><td class="xl29" width="72" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 54pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffcc99;"><font size="2"><strong>产品数量</strong></font></td><td class="xl30" width="82" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f2f2f2; BORDER-LEFT: windowtext; WIDTH: 62pt; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: #ffcc99;"><font size="2"><strong>BB<font class="font6" face="宋体">或</font><font class="font7">CC</font></strong></font></td><td class="xl31" width="86" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f2f2f2; BORDER-LEFT: windowtext; WIDTH: 65pt; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: #ffcc99;"><strong><font size="2"><font face="宋体">单价</font><font class="font7">*</font><font class="font6" face="宋体">数量</font></font></strong></td><td class="xl31" width="86" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f2f2f2; BORDER-LEFT: windowtext; WIDTH: 65pt; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: #ffcc99;"><strong><font face="宋体" size="2">结果</font></strong></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl27" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font size="2">AA</font></td><td class="xl28" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">2000-6-15</font></td><td class="xl27" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">1</font></td><td class="xl27" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">100</font></td><td align="center" xfmla="=OR(A2=&quot;BB&quot;,A2=&quot;CC&quot;)" xbool="FALSE" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font face="宋体">FALSE</font></td><td align="right" xfmla="=C2*D2" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font face="宋体">100</font></td><td align="right" xfmla="=E2*F2" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font face="宋体">0</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl27" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font size="2">AA</font></td><td class="xl28" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">2000-6-20</font></td><td class="xl27" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">1</font></td><td class="xl27" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">125</font></td><td align="center" xfmla="=OR(A3=&quot;BB&quot;,A3=&quot;CC&quot;)" xbool="FALSE" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font face="宋体">FALSE</font></td><td align="right" xfmla="=C3*D3" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font face="宋体">125</font></td><td align="right" xfmla="=E3*F3" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font face="宋体">0</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl27" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font size="2">BB</font></td><td class="xl28" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">2000-6-30</font></td><td class="xl27" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">2</font></td><td class="xl27" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">150</font></td><td align="center" xfmla="=OR(A4=&quot;BB&quot;,A4=&quot;CC&quot;)" xbool="TRUE" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font face="宋体">TRUE</font></td><td align="right" xfmla="=C4*D4" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font face="宋体">300</font></td><td align="right" xfmla="=E4*F4" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font face="宋体">300</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl27" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font size="2">BB</font></td><td class="xl28" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">2000-7-10</font></td><td class="xl27" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">2</font></td><td class="xl27" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">175</font></td><td align="center" xfmla="=OR(A5=&quot;BB&quot;,A5=&quot;CC&quot;)" xbool="TRUE" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font face="宋体">TRUE</font></td><td align="right" xfmla="=C5*D5" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font face="宋体">350</font></td><td align="right" xfmla="=E5*F5" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font face="宋体">350</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl27" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font size="2">CC</font></td><td class="xl28" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">2000-7-15</font></td><td class="xl27" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">3</font></td><td class="xl27" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">200</font></td><td align="center" xfmla="=OR(A6=&quot;BB&quot;,A6=&quot;CC&quot;)" xbool="TRUE" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font face="宋体">TRUE</font></td><td align="right" xfmla="=C6*D6" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font face="宋体">600</font></td><td align="right" xfmla="=E6*F6" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font face="宋体">600</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl27" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font size="2">CC</font></td><td class="xl28" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">2000-7-20</font></td><td class="xl27" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">3</font></td><td class="xl27" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">225</font></td><td align="center" xfmla="=OR(A7=&quot;BB&quot;,A7=&quot;CC&quot;)" xbool="TRUE" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font face="宋体">TRUE</font></td><td align="right" xfmla="=C7*D7" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font face="宋体">675</font></td><td align="right" xfmla="=E7*F7" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font face="宋体">675</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl27" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font size="2">AA</font></td><td class="xl28" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">2000-7-30</font></td><td class="xl27" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">1</font></td><td class="xl27" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">250</font></td><td align="center" xfmla="=OR(A8=&quot;BB&quot;,A8=&quot;CC&quot;)" xbool="FALSE" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font face="宋体">FALSE</font></td><td align="right" xfmla="=C8*D8" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font face="宋体">250</font></td><td align="right" xfmla="=E8*F8" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font face="宋体">0</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl27" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font size="2">AA</font></td><td class="xl28" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">2000-8-10</font></td><td class="xl27" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">1</font></td><td class="xl27" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">275</font></td><td align="center" xfmla="=OR(A9=&quot;BB&quot;,A9=&quot;CC&quot;)" xbool="FALSE" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font face="宋体">FALSE</font></td><td align="right" xfmla="=C9*D9" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font face="宋体">275</font></td><td align="right" xfmla="=E9*F9" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font face="宋体">0</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl27" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font size="2">BB</font></td><td class="xl28" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">2000-8-15</font></td><td class="xl27" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">2</font></td><td class="xl27" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">300</font></td><td align="center" xfmla="=OR(A10=&quot;BB&quot;,A10=&quot;CC&quot;)" xbool="TRUE" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font face="宋体">TRUE</font></td><td align="right" xfmla="=C10*D10" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font face="宋体">600</font></td><td align="right" xfmla="=E10*F10" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font face="宋体">600</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl27" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font size="2">BB</font></td><td class="xl28" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">2000-8-20</font></td><td class="xl27" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">2</font></td><td class="xl27" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">325</font></td><td align="center" xfmla="=OR(A11=&quot;BB&quot;,A11=&quot;CC&quot;)" xbool="TRUE" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font face="宋体">TRUE</font></td><td align="right" xfmla="=C11*D11" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font face="宋体">650</font></td><td align="right" xfmla="=E11*F11" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font face="宋体">650</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl27" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font size="2">CC</font></td><td class="xl28" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">2000-8-30</font></td><td class="xl27" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">3</font></td><td class="xl27" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">350</font></td><td align="center" xfmla="=OR(A12=&quot;BB&quot;,A12=&quot;CC&quot;)" xbool="TRUE" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font face="宋体">TRUE</font></td><td align="right" xfmla="=C12*D12" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font face="宋体">1050</font></td><td align="right" xfmla="=E12*F12" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font face="宋体">1050</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl27" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font size="2">CC</font></td><td class="xl28" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">2000-10-10</font></td><td class="xl27" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">3</font></td><td class="xl27" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">375</font></td><td align="center" xfmla="=OR(A13=&quot;BB&quot;,A13=&quot;CC&quot;)" xbool="TRUE" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font face="宋体">TRUE</font></td><td align="right" xfmla="=C13*D13" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font face="宋体">1125</font></td><td align="right" xfmla="=E13*F13" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font face="宋体">1125</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl27" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font size="2">DD</font></td><td class="xl28" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">2000-10-15</font></td><td class="xl27" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">4</font></td><td class="xl27" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">400</font></td><td align="center" xfmla="=OR(A14=&quot;BB&quot;,A14=&quot;CC&quot;)" xbool="FALSE" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font face="宋体">FALSE</font></td><td align="right" xfmla="=C14*D14" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font face="宋体">1600</font></td><td align="right" xfmla="=E14*F14" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font face="宋体">0</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl27" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font size="2">DD</font></td><td class="xl28" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">2000-10-30</font></td><td class="xl27" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">4</font></td><td class="xl27" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">425</font></td><td align="center" xfmla="=OR(A15=&quot;BB&quot;,A15=&quot;CC&quot;)" xbool="FALSE" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font face="宋体">FALSE</font></td><td align="right" xfmla="=C15*D15" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font face="宋体">1700</font></td><td align="right" xfmla="=E15*F15" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font face="宋体">0</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td height="19" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font face="宋体"></font></td><td style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font face="宋体"></font></td><td style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font face="宋体"></font></td><td style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font face="宋体"></font></td><td align="right" xfmla="=SUM(G2:G15)" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font face="宋体">5350</font></td><td style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"></td><td style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"></td></tr></tbody></table></p><p><table cellspacing="0" cellpadding="0" width="628" border="0" style="WIDTH: 473pt; BORDER-COLLAPSE: collapse;"><colgroup><col span="4" width="72" style="WIDTH: 54pt;"></col><col></col><col></col><col></col><col width="82" style="WIDTH: 62pt; mso-width-source: userset; mso-width-alt: 2624;"></col><col></col><col></col><col></col><col span="3" width="86" style="WIDTH: 65pt; mso-width-source: userset; mso-width-alt: 2752;"></col><col></col><col></col><col></col></colgroup><tbody><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl29" width="72" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 54pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: #ffcc99;"><font size="2"><strong>产品编号</strong></font></td><td class="xl29" width="72" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 54pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffcc99;"><font size="2"><strong>生产日期</strong></font></td><td class="xl29" width="72" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 54pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffcc99;"><font size="2"><strong>产品单价</strong></font></td><td class="xl29" width="72" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 54pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffcc99;"><font size="2"><strong>产品数量</strong></font></td><td class="xl30" width="82" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; WIDTH: 62pt; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: #ffcc99;"><font size="2"><strong>AA</strong></font></td><td class="xl32" width="86" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; WIDTH: 65pt; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: #ffcc99;"><font face="宋体" size="2"><strong>数量大于200</strong></font></td><td class="xl32" width="86" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; WIDTH: 65pt; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: #ffcc99;"><strong><font face="宋体" size="2">　</font></strong></td><td class="xl32" width="86" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; WIDTH: 65pt; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: #ffcc99;"><strong><font face="宋体" size="2">　</font></strong></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl27" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font size="2">AA</font></td><td class="xl28" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">2000-6-15</font></td><td class="xl27" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">1</font></td><td class="xl27" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">100</font></td><td class="xl31" xfmla="=(A2:A15=&quot;AA&quot;)" xbool="TRUE" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font size="2">TRUE</font></td><td class="xl31" xfmla="=D2&gt;200" xbool="FALSE" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font size="2">FALSE</font></td><td class="xl31" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font size="2"></font></td><td class="xl31" xfmla="=F2*E2" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font size="2">0</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl27" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font size="2">AA</font></td><td class="xl28" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">2000-6-20</font></td><td class="xl27" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">1</font></td><td class="xl27" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">125</font></td><td class="xl31" xfmla="=(A3:A16=&quot;AA&quot;)" xbool="TRUE" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font size="2">TRUE</font></td><td class="xl31" xfmla="=D3&gt;200" xbool="FALSE" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font size="2">FALSE</font></td><td class="xl31" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font size="2"></font></td><td class="xl31" xfmla="=F3*E3" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font size="2">0</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl27" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font size="2">BB</font></td><td class="xl28" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">2000-6-30</font></td><td class="xl27" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">2</font></td><td class="xl27" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">150</font></td><td class="xl31" xbool="FALSE" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font size="2">FALSE</font></td><td class="xl31" xfmla="=D4&gt;200" xbool="FALSE" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font size="2">FALSE</font></td><td class="xl31" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font size="2"></font></td><td class="xl31" xfmla="=F4*E4" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font size="2">0</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl27" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font size="2">BB</font></td><td class="xl28" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">2000-7-10</font></td><td class="xl27" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">2</font></td><td class="xl27" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">175</font></td><td class="xl31" xbool="FALSE" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font size="2">FALSE</font></td><td class="xl31" xfmla="=D5&gt;200" xbool="FALSE" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font size="2">FALSE</font></td><td class="xl31" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font size="2"></font></td><td class="xl31" xfmla="=F5*E5" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font size="2">0</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl27" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font size="2">CC</font></td><td class="xl28" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">2000-7-15</font></td><td class="xl27" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">3</font></td><td class="xl27" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">200</font></td><td class="xl31" xbool="FALSE" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font size="2">FALSE</font></td><td class="xl31" xfmla="=D6&gt;200" xbool="FALSE" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font size="2">FALSE</font></td><td class="xl31" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font size="2"></font></td><td class="xl31" xfmla="=F6*E6" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font size="2">0</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl27" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font size="2">CC</font></td><td class="xl28" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">2000-7-20</font></td><td class="xl27" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">3</font></td><td class="xl27" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">225</font></td><td class="xl31" xbool="FALSE" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font size="2">FALSE</font></td><td class="xl31" xfmla="=D7&gt;200" xbool="TRUE" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font size="2">TRUE</font></td><td class="xl31" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font size="2"></font></td><td class="xl31" xfmla="=F7*E7" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font size="2">0</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl27" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font size="2">AA</font></td><td class="xl28" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">2000-7-30</font></td><td class="xl27" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">1</font></td><td class="xl27" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">250</font></td><td class="xl31" xbool="TRUE" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font size="2">TRUE</font></td><td class="xl31" xfmla="=D8&gt;200" xbool="TRUE" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font size="2">TRUE</font></td><td class="xl31" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font size="2"></font></td><td class="xl31" xfmla="=F8*E8" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font size="2">1</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl27" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font size="2">AA</font></td><td class="xl28" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">2000-8-10</font></td><td class="xl27" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">1</font></td><td class="xl27" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">275</font></td><td class="xl31" xbool="TRUE" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font size="2">TRUE</font></td><td class="xl31" xfmla="=D9&gt;200" xbool="TRUE" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font size="2">TRUE</font></td><td class="xl31" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font size="2"></font></td><td class="xl31" xfmla="=F9*E9" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font size="2">1</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl27" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font size="2">BB</font></td><td class="xl28" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">2000-8-15</font></td><td class="xl27" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">2</font></td><td class="xl27" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">300</font></td><td class="xl31" xbool="FALSE" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font size="2">FALSE</font></td><td class="xl31" xfmla="=D10&gt;200" xbool="TRUE" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font size="2">TRUE</font></td><td class="xl31" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font size="2"></font></td><td class="xl31" xfmla="=F10*E10" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font size="2">0</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl27" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font size="2">BB</font></td><td class="xl28" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">2000-8-20</font></td><td class="xl27" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">2</font></td><td class="xl27" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">325</font></td><td class="xl31" xbool="FALSE" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font size="2">FALSE</font></td><td class="xl31" xfmla="=D11&gt;200" xbool="TRUE" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font size="2">TRUE</font></td><td class="xl31" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font size="2"></font></td><td class="xl31" xfmla="=F11*E11" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font size="2">0</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl27" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font size="2">CC</font></td><td class="xl28" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">2000-8-30</font></td><td class="xl27" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">3</font></td><td class="xl27" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">350</font></td><td class="xl31" xbool="FALSE" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font size="2">FALSE</font></td><td class="xl31" xfmla="=D12&gt;200" xbool="TRUE" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font size="2">TRUE</font></td><td class="xl31" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font size="2"></font></td><td class="xl31" xfmla="=F12*E12" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font size="2">0</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl27" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font size="2">CC</font></td><td class="xl28" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">2000-10-10</font></td><td class="xl27" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">3</font></td><td class="xl27" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">375</font></td><td class="xl31" xbool="FALSE" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font size="2">FALSE</font></td><td class="xl31" xfmla="=D13&gt;200" xbool="TRUE" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font size="2">TRUE</font></td><td class="xl31" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font size="2"></font></td><td class="xl31" xfmla="=F13*E13" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font size="2">0</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl27" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font size="2">DD</font></td><td class="xl28" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">2000-10-15</font></td><td class="xl27" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">4</font></td><td class="xl27" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">400</font></td><td class="xl31" xbool="FALSE" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font size="2">FALSE</font></td><td class="xl31" xfmla="=D14&gt;200" xbool="TRUE" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font size="2">TRUE</font></td><td class="xl31" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font size="2"></font></td><td class="xl31" xfmla="=F14*E14" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font size="2">0</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl27" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font size="2">DD</font></td><td class="xl28" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">2000-10-30</font></td><td class="xl27" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">4</font></td><td class="xl27" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">425</font></td><td class="xl31" xbool="FALSE" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font size="2">FALSE</font></td><td class="xl31" xfmla="=D15&gt;200" xbool="TRUE" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font size="2">TRUE</font></td><td class="xl31" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font size="2"></font></td><td class="xl31" xfmla="=F15*E15" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font size="2">0</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td height="19" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font size="2"></font></td><td style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font size="2"></font></td><td style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font size="2"></font></td><td style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font size="2"></font></td><td style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font size="2"></font></td><td style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font face="宋体">合计</font></td><td style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font face="宋体"></font></td><td class="xl31" xfmla="=SUM(H2:H15)" style="BORDER-RIGHT: #f2f2f2; BORDER-TOP: #f2f2f2; BORDER-LEFT: #f2f2f2; BORDER-BOTTOM: #f2f2f2; BACKGROUND-COLOR: transparent;"><font size="2">2</font></td></tr></tbody></table></p><p>5题:=SUMIF(B51:B59,"??R*",C51:C59)+SUMIF(E51:E59,"??R*",F51:F59)&nbsp; <font color="#f70909">可简化！</font></p><p>6题:=COUNTIF(J3:J22,"&lt;-1")+COUNTIF(J3:J22,"&lt;&gt;9")-COUNTIF(J3:J22,"&lt;5")</p><p>=SUM(SUMIF(J3:J22,"&lt;-1")+SUMIF(J3:J22,"&lt;&gt;9")-SUMIF(J3:J22,"&lt;5"))&nbsp; <font color="#f70909">外套SUM多余！</font></p><p>7题:=COUNTIF(K26:K35,"??中学")</p><p>8题:思路不清</p><p><font color="#ee1111">继续努力！</font></p><p><font color="#ee1111">——dgxsdr</font></p>

[此贴子已经被無心于2010-6-8 0:41:30编辑过]

耀幺妈

<p>[Power=1] voH4jPfQ.zip (30.63 KB, 下载次数: 1)

2010-6-5 10:57 上传

点击文件名下载附件
02029耀幺妈交作业 </p><p><font color="#f70909">第1题未做！</font></p><p><font color="#f70909">第2题改了源数据！</font></p><p><font color="#f70909">第3题不是一个公式！</font></p><p><font color="#f70909">第4题的2也要简化！</font></p><p><font color="#f70909">第5题可简化！</font></p><p><font color="#f70909">第6题不对！</font></p><p><font color="#f70909">第8题不对！</font></p><p><font color="#f70909">要加油了！有问题可在群里或者论坛里提问！</font></p><p><font color="#f70909">——dgxsdr<br/></font></p>

[此贴子已经被無心于2010-6-8 0:41:45编辑过]