{"id":4140,"date":"2018-10-09T20:55:25","date_gmt":"2018-10-09T12:55:25","guid":{"rendered":"https:\/\/www.lixiangluntan.com\/4140\/"},"modified":"2018-10-09T20:55:25","modified_gmt":"2018-10-09T12:55:25","slug":"%e5%a4%a7%e6%99%ba%e6%85%a7%e4%b8%bb%e5%8a%9b30%e5%88%86%e9%92%9f%e7%bb%9f%e8%ae%a1%e6%8c%87%e6%a0%87%e5%85%ac%e5%bc%8f_%e5%a4%a7%e6%99%ba%e6%85%a7ace%e7%a0%b4%e8%a7%a3%e7%89%88","status":"publish","type":"post","link":"https:\/\/www.lixiangluntan.com\/?p=4140","title":{"rendered":"\u5927\u667a\u6167\u4e3b\u529b30\u5206\u949f\u7edf\u8ba1\u6307\u6807\u516c\u5f0f_\u5927\u667a\u6167ace\u7834\u89e3\u7248"},"content":{"rendered":"<blockquote style=\"font-size:15px;background-color: #F5F5F5;border:none;padding: 5px;margin:15px;line-height: 1.6;text-indent: 2em;\">\n<p style=\"margin-bottom:5px;\">\u5927\u667a\u61676\u5747\u7ebf\u8d44\u91d1\u4e3b\u56fe\u6307\u6807\u516c\u5f0f<\/p>\n<p>\u3000\u3000\u5e10\u6237\u603b\u6570\uff1aextradata\uff08\u2018\u6563\u6237\u7ebf\u2019\uff09\uff0clinethick0\uff0cPRECIS0;<\/p>\n<\/blockquote>\n<p>&nbsp;&nbsp;&nbsp;&nbsp;  <\/p>\n<p> \u3000\u3000{\u4e3b\u529b30\u5206}<\/p>\n<p> \u3000\u3000input:N\uff081\uff0c1\uff0c2\uff09;<\/p>\n<p> \u3000\u3000TODAY\uff1a=\u201c\u5206\u65f6DDX.DDX\u7d2f\u79ef\u201d\u300a\u300b0;{\u5224\u65ad\u662f\u5426\u6709\u6b63\u7248\u6570\u636e}<\/p>\n<p> \u3000\u3000TODAY1\uff1a=\u201cLXDDX.DDX#day\u201d=0;{\u5224\u65ad\u662f\u5426\u6709\u96e8\u6768\u6570\u636e}<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08680\uff0c-12\uff0cIFS\uff08TODAY\uff0c\u2018\u6b63\u7248\u6570\u636e\u2019\uff0cIFS\uff08TODAY1\uff0c\u2018\u5f15\u5165\u6570\u636e\u2019\uff0c\u2018\u96e8\u6768\u6570\u636e \u2019\uff09\uff09\uff09\uff0cLINETHICK1\uff0ccolorwhite;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08752\uff0c-12\uff0cIFS\uff08N=1\uff0c\u2018\u9010\u5355\u2019\uff0c\u2018\u9010\u7b14\u2019\uff09\uff09\uff0cLINETHICK1\uff0ccolorwhite;<\/p>\n<p> \u3000\u3000ZT1\uff1a=\u201cwd.o12\u201d{ORDERVOL\uff081\uff0c2\uff09};<\/p>\n<p> \u3000\u3000YT1\u7d2f\u79ef\uff1a=\u201cDDEDATA@BIGORDERSCALE\u201d\uff081\uff0c2\uff09*SUM\uff08VOL\uff0c0\uff09;<\/p>\n<p> \u3000\u3000YT1\uff1a=YT1\u7d2f\u79ef-REF\uff08YT1\u7d2f\u79ef\uff0c1\uff09;<\/p>\n<p> \u3000\u3000RT1\u7d2f\u79ef\uff1a=\u201cwd.\u4e3b\u5355\u4e70#day\u201d*SUM\uff08VOL\uff0c0\uff09;<\/p>\n<p> \u3000\u3000RT1\uff1a=RT1\u7d2f\u79ef-REF\uff08RT1\u7d2f\u79ef\uff0c1\uff09;<\/p>\n<p> \u3000\u3000T1\uff1a=IF\uff08TODAY\uff0cZT1\uff0cIF\uff08TODAY1\uff0cRT1\uff0cYT1\uff09\uff09;<\/p>\n<p> \u3000\u3000T2\uff1a=\u201cwd.t12\u201d{TRANSACTVOL\uff081\uff0c2\uff09};<\/p>\n<p> \u3000\u3000ZT3\uff1a=\u201cwd.o22\u201d{ORDERVOL\uff082\uff0c2\uff09};<\/p>\n<p> \u3000\u3000YT3\u7d2f\u79ef\uff1a=\u201cDDEDATA@BIGORDERSCALE\u201d\uff082\uff0c2\uff09*SUM\uff08VOL\uff0c0\uff09;<\/p>\n<p> \u3000\u3000YT3\uff1a=YT3\u7d2f\u79ef-REF\uff08YT3\u7d2f\u79ef\uff0c1\uff09;<\/p>\n<p> \u3000\u3000RT3\u7d2f\u79ef\uff1a=\u201cwd.\u4e3b\u5355\u5356#day\u201d*SUM\uff08VOL\uff0c0\uff09;<\/p>\n<p> \u3000\u3000RT3\uff1a=RT3\u7d2f\u79ef-REF\uff08RT3\u7d2f\u79ef\uff0c1\uff09;<\/p>\n<p> \u3000\u3000T3\uff1a=IF\uff08TODAY\uff0cZT3\uff0cIF\uff08TODAY1\uff0cRT3\uff0cYT3\uff09\uff09;<\/p>\n<p> \u3000\u3000T4\uff1a=\u201cwd.t22\u201d{TRANSACTVOL\uff082\uff0c2\uff09};<\/p>\n<p> \u3000\u3000ZS1\uff1a=\u201cwd.d12\u201d{ORDERNUM\uff081\uff0c2\uff09};<\/p>\n<p> \u3000\u3000YS1\uff1a=\u201cDDEDATA@BIGORDERSCALE\u201d\uff081\uff0c2\uff09;<\/p>\n<p> \u3000\u3000RS1\uff1a=\u201cwd.\u4e3b\u5355\u4e70#day\u201d;<\/p>\n<p> \u3000\u3000S1\uff1a=IF\uff08TODAY\uff0cZS1\uff0cIF\uff08TODAY1\uff0cRS1\uff0cYS1\uff09\uff09;<\/p>\n<p> \u3000\u3000S2\uff1a=\u201cwd.l12\u201d{TRANSACTNUM\uff081\uff0c2\uff09};<\/p>\n<p> \u3000\u3000ZS3\uff1a=\u201cwd.d22\u201d{ORDERNUM\uff082\uff0c2\uff09};<\/p>\n<p> \u3000\u3000YS3\uff1a=\u201cDDEDATA@BIGORDERSCALE\u201d\uff082\uff0c2\uff09;<\/p>\n<p> \u3000\u3000RS3\uff1a=\u201cwd.\u4e3b\u5355\u5356#day\u201d;<\/p>\n<p> \u3000\u3000S3\uff1a=IF\uff08TODAY\uff0cZS3\uff0cIF\uff08TODAY1\uff0cRS3\uff0cYS3\uff09\uff09;<\/p>\n<p> \u3000\u3000S4\uff1a=\u201cwd.l22\u201d{TRANSACTNUM\uff082\uff0c2\uff09};<\/p>\n<p> \u3000\u3000M1\uff1a=TIME\u300a=100000;<\/p>\n<p> \u3000\u3000M2\uff1a=TIME\u300a=103000 AND TIME\u300b100000;<\/p>\n<p> \u3000\u3000M3\uff1a=TIME\u300a=110000 AND TIME\u300b103000;<\/p>\n<p> \u3000\u3000M4\uff1a=TIME\u300a=113000 AND TIME\u300b110000;<\/p>\n<p> \u3000\u3000M5\uff1a=TIME\u300a=133000 AND TIME\u300b130000;<\/p>\n<p> \u3000\u3000M6\uff1a=TIME\u300a=140000 AND TIME\u300b133000;<\/p>\n<p> \u3000\u3000M7\uff1a=TIME\u300a=143000 AND TIME\u300b140000;<\/p>\n<p> \u3000\u3000M8\uff1a=TIME\u300a=150000 AND TIME\u300b143000;<\/p>\n<p> \u3000\u3000{\u6570\u636e1\u5927\u4e70}<\/p>\n<p> \u3000\u3000A1\uff1a=IF\uff08M1\uff0cS1\uff0c0\uff09;<\/p>\n<p> \u3000\u3000A2\uff1a=IF\uff08M1\uff0cS2\uff0c0\uff09;<\/p>\n<p> \u3000\u3000AA\uff1a=SUM\uff08IF\uff08N=1\uff0cA1\uff0cA2\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000B1\uff1a=IF\uff08M2\uff0cS1\uff0c0\uff09;<\/p>\n<p> \u3000\u3000B2\uff1a=IF\uff08M2\uff0cS2\uff0c0\uff09;<\/p>\n<p> \u3000\u3000BB\uff1a=SUM\uff08IF\uff08N=1\uff0cB1\uff0cB2\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000C1\uff1a=IF\uff08M3\uff0cS1\uff0c0\uff09;<\/p>\n<p> \u3000\u3000C2\uff1a=IF\uff08M3\uff0cS2\uff0c0\uff09;<\/p>\n<p> \u3000\u3000CC\uff1a=SUM\uff08IF\uff08N=1\uff0cC1\uff0cC2\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000D1\uff1a=IF\uff08M4\uff0cS1\uff0c0\uff09;<\/p>\n<p> \u3000\u3000D2\uff1a=IF\uff08M4\uff0cS2\uff0c0\uff09;<\/p>\n<p> \u3000\u3000DD\uff1a=SUM\uff08IF\uff08N=1\uff0cD1\uff0cD2\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000E1\uff1a=IF\uff08M5\uff0cS1\uff0c0\uff09;<\/p>\n<p> \u3000\u3000E2\uff1a=IF\uff08M5\uff0cS2\uff0c0\uff09;<\/p>\n<p> \u3000\u3000EE\uff1a=SUM\uff08IF\uff08N=1\uff0cE1\uff0cE2\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000F1\uff1a=IF\uff08M6\uff0cS1\uff0c0\uff09;<\/p>\n<p> \u3000\u3000F2\uff1a=IF\uff08M6\uff0cS2\uff0c0\uff09;<\/p>\n<p> \u3000\u3000FF\uff1a=SUM\uff08IF\uff08N=1\uff0cF1\uff0cF2\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000G1\uff1a=IF\uff08M7\uff0cS1\uff0c0\uff09;<\/p>\n<p> \u3000\u3000G2\uff1a=IF\uff08M7\uff0cS2\uff0c0\uff09;<\/p>\n<p> \u3000\u3000GG\uff1a=SUM\uff08IF\uff08N=1\uff0cG1\uff0cG2\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000H1\uff1a=IF\uff08M8\uff0cS1\uff0c0\uff09;<\/p>\n<p> \u3000\u3000H2\uff1a=IF\uff08M8\uff0cS2\uff0c0\uff09;<\/p>\n<p> \u3000\u3000HH\uff1a=SUM\uff08IF\uff08N=1\uff0cH1\uff0cH2\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000I1\uff1a=IF\uff08M1\uff0cT1\uff0c0\uff09;<\/p>\n<p> \u3000\u3000I2\uff1a=IF\uff08M1\uff0cT2\uff0c0\uff09;<\/p>\n<p> \u3000\u3000II\uff1a=SUM\uff08IF\uff08N=1\uff0cI1\uff0cI2\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000J1\uff1a=IF\uff08M2\uff0cT1\uff0c0\uff09;<\/p>\n<p> \u3000\u3000J2\uff1a=IF\uff08M2\uff0cT2\uff0c0\uff09;<\/p>\n<p> \u3000\u3000JJ\uff1a=SUM\uff08IF\uff08N=1\uff0cJ1\uff0cJ2\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000K1\uff1a=IF\uff08M3\uff0cT1\uff0c0\uff09;<\/p>\n<p> \u3000\u3000K2\uff1a=IF\uff08M3\uff0cT2\uff0c0\uff09;<\/p>\n<p> \u3000\u3000KK\uff1a=SUM\uff08IF\uff08N=1\uff0cK1\uff0cK2\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000L1\uff1a=IF\uff08M4\uff0cT1\uff0c0\uff09;<\/p>\n<p> \u3000\u3000L2\uff1a=IF\uff08M4\uff0cT2\uff0c0\uff09;<\/p>\n<p> \u3000\u3000LL\uff1a=SUM\uff08IF\uff08N=1\uff0cL1\uff0cL2\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000N1\uff1a=IF\uff08M5\uff0cT1\uff0c0\uff09;<\/p>\n<p> \u3000\u3000N2\uff1a=IF\uff08M5\uff0cT2\uff0c0\uff09;<\/p>\n<p> \u3000\u3000NN\uff1a=SUM\uff08IF\uff08N=1\uff0cN1\uff0cN2\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000O1\uff1a=IF\uff08M6\uff0cT1\uff0c0\uff09;<\/p>\n<p> \u3000\u3000O2\uff1a=IF\uff08M6\uff0cT2\uff0c0\uff09;<\/p>\n<p> \u3000\u3000OO\uff1a=SUM\uff08IF\uff08N=1\uff0cO1\uff0cO2\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000P1\uff1a=IF\uff08M7\uff0cT1\uff0c0\uff09;<\/p>\n<p> \u3000\u3000P2\uff1a=IF\uff08M7\uff0cT2\uff0c0\uff09;<\/p>\n<p> \u3000\u3000PP\uff1a=SUM\uff08IF\uff08N=1\uff0cP1\uff0cP2\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000Q1\uff1a=IF\uff08M8\uff0cT1\uff0c0\uff09;<\/p>\n<p> \u3000\u3000Q2\uff1a=IF\uff08M8\uff0cT2\uff0c0\uff09;<\/p>\n<p> \u3000\u3000QQ\uff1a=SUM\uff08IF\uff08N=1\uff0cQ1\uff0cQ2\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000{\u6570\u636e2\u5927\u5356}<\/p>\n<p> \u3000\u3000A3\uff1a=IF\uff08M1\uff0cS3\uff0c0\uff09;<\/p>\n<p> \u3000\u3000A4\uff1a=IF\uff08M1\uff0cS4\uff0c0\uff09;<\/p>\n<p> \u3000\u3000AA1\uff1a=SUM\uff08IF\uff08N=1\uff0cA3\uff0cA4\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000B3\uff1a=IF\uff08M2\uff0cS3\uff0c0\uff09;<\/p>\n<p> \u3000\u3000B4\uff1a=IF\uff08M2\uff0cS4\uff0c0\uff09;<\/p>\n<p> \u3000\u3000BB1\uff1a=SUM\uff08IF\uff08N=1\uff0cB3\uff0cB4\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000C3\uff1a=IF\uff08M3\uff0cS3\uff0c0\uff09;<\/p>\n<p> \u3000\u3000C4\uff1a=IF\uff08M3\uff0cS4\uff0c0\uff09;<\/p>\n<p> \u3000\u3000CC1\uff1a=SUM\uff08IF\uff08N=1\uff0cC3\uff0cC4\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000D3\uff1a=IF\uff08M4\uff0cS3\uff0c0\uff09;<\/p>\n<p> \u3000\u3000D4\uff1a=IF\uff08M4\uff0cS4\uff0c0\uff09;<\/p>\n<p> \u3000\u3000DD1\uff1a=SUM\uff08IF\uff08N=1\uff0cD3\uff0cD4\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000E3\uff1a=IF\uff08M5\uff0cS3\uff0c0\uff09;<\/p>\n<p> \u3000\u3000E4\uff1a=IF\uff08M5\uff0cS4\uff0c0\uff09;<\/p>\n<p> \u3000\u3000EE1\uff1a=SUM\uff08IF\uff08N=1\uff0cE3\uff0cE4\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000F3\uff1a=IF\uff08M6\uff0cS3\uff0c0\uff09;<\/p>\n<p> \u3000\u3000F4\uff1a=IF\uff08M6\uff0cS4\uff0c0\uff09;<\/p>\n<p> \u3000\u3000FF1\uff1a=SUM\uff08IF\uff08N=1\uff0cF3\uff0cF4\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000G3\uff1a=IF\uff08M7\uff0cS3\uff0c0\uff09;<\/p>\n<p> \u3000\u3000G4\uff1a=IF\uff08M7\uff0cS4\uff0c0\uff09;<\/p>\n<p> \u3000\u3000GG1\uff1a=SUM\uff08IF\uff08N=1\uff0cG3\uff0cG4\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000H3\uff1a=IF\uff08M8\uff0cS3\uff0c0\uff09;<\/p>\n<p> \u3000\u3000H4\uff1a=IF\uff08M8\uff0cS4\uff0c0\uff09;<\/p>\n<p> \u3000\u3000HH1\uff1a=SUM\uff08IF\uff08N=1\uff0cH3\uff0cH4\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000I3\uff1a=IF\uff08M1\uff0cT3\uff0c0\uff09;<\/p>\n<p> \u3000\u3000I4\uff1a=IF\uff08M1\uff0cT4\uff0c0\uff09;<\/p>\n<p> \u3000\u3000II1\uff1a=SUM\uff08IF\uff08N=1\uff0cI3\uff0cI4\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000J3\uff1a=IF\uff08M2\uff0cT3\uff0c0\uff09;<\/p>\n<p> \u3000\u3000J4\uff1a=IF\uff08M2\uff0cT4\uff0c0\uff09;<\/p>\n<p> \u3000\u3000JJ1\uff1a=SUM\uff08IF\uff08N=1\uff0cJ3\uff0cJ4\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000K3\uff1a=IF\uff08M3\uff0cT3\uff0c0\uff09;<\/p>\n<p> \u3000\u3000K4\uff1a=IF\uff08M3\uff0cT4\uff0c0\uff09;<\/p>\n<p> \u3000\u3000KK1\uff1a=SUM\uff08IF\uff08N=1\uff0cK3\uff0cK4\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000L3\uff1a=IF\uff08M4\uff0cT3\uff0c0\uff09;<\/p>\n<p> \u3000\u3000L4\uff1a=IF\uff08M4\uff0cT4\uff0c0\uff09;<\/p>\n<p> \u3000\u3000LL1\uff1a=SUM\uff08IF\uff08N=1\uff0cL3\uff0cL4\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000N3\uff1a=IF\uff08M5\uff0cT3\uff0c0\uff09;<\/p>\n<p> \u3000\u3000N4\uff1a=IF\uff08M5\uff0cT4\uff0c0\uff09;<\/p>\n<p> \u3000\u3000NN1\uff1a=SUM\uff08IF\uff08N=1\uff0cN3\uff0cN4\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000O3\uff1a=IF\uff08M6\uff0cT3\uff0c0\uff09;<\/p>\n<p> \u3000\u3000O4\uff1a=IF\uff08M6\uff0cT4\uff0c0\uff09;<\/p>\n<p> \u3000\u3000OO1\uff1a=SUM\uff08IF\uff08N=1\uff0cO3\uff0cO4\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000P3\uff1a=IF\uff08M7\uff0cT3\uff0c0\uff09;<\/p>\n<p> \u3000\u3000P4\uff1a=IF\uff08M7\uff0cT4\uff0c0\uff09;<\/p>\n<p> \u3000\u3000PP1\uff1a=SUM\uff08IF\uff08N=1\uff0cP3\uff0cP4\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000Q3\uff1a=IF\uff08M8\uff0cT3\uff0c0\uff09;<\/p>\n<p> \u3000\u3000Q4\uff1a=IF\uff08M8\uff0cT4\uff0c0\uff09;<\/p>\n<p> \u3000\u3000QQ1\uff1a=SUM\uff08IF\uff08N=1\uff0cQ3\uff0cQ4\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000{\u6570\u636e3\u603b\u4e70\u603b\u5356\u5dee}<\/p>\n<p> \u3000\u3000MR\uff1a=IF\uff08N=1\uff0cSUM\uff08T1\uff0c0\uff09\uff0cSUM\uff08T2\uff0c0\uff09\uff09;<\/p>\n<p> \u3000\u3000MC\uff1a=IF\uff08N=1\uff0cSUM\uff08T3\uff0c0\uff09\uff0cSUM\uff08T4\uff0c0\uff09\uff09;<\/p>\n<p> \u3000\u3000MRE\uff1a=MR*DYNAINFO\uff0811\uff09*100\/10000;<\/p>\n<p> \u3000\u3000MCE\uff1a=MC*DYNAINFO\uff0811\uff09*100\/10000;<\/p>\n<p> \u3000\u3000\u6d41\u5165\u8d44\u91d1\uff1aMRE\uff0cCOLOR0000FF\uff0clinethick0\uff0cPRECIS2;<\/p>\n<p> \u3000\u3000\u6d41\u51fa\u8d44\u91d1\uff1aMCE\uff0cCOLORFFFF00\uff0clinethick0\uff0cPRECIS2;<\/p>\n<p> \u3000\u3000MRB\uff1a=IF\uff08N=1\uff0cSUM\uff08S1\uff0c0\uff09\uff0cSUM\uff08S2\uff0c0\uff09\uff09;<\/p>\n<p> \u3000\u3000MCB\uff1a=IF\uff08N=1\uff0cSUM\uff08S3\uff0c0\uff09\uff0cSUM\uff08S4\uff0c0\uff09\uff09;<\/p>\n<p> \u3000\u3000RBG\uff1a=MR*100\/MRB;<\/p>\n<p> \u3000\u3000CBG\uff1a=MC*100\/MCB;<\/p>\n<p> \u3000\u3000JS\uff1a=MR-MC;<\/p>\n<p> \u3000\u3000JE\uff1a=MRE-MCE;<\/p>\n<p> \u3000\u3000\u51c0\u8d44\u91d1\uff1aJE\uff0cCOLOR00FFFF\uff0clinethick0\uff0cPRECIS2;<\/p>\n<p> \u3000\u3000JB\uff1a=MRB-MCB;<\/p>\n<p> \u3000\u3000JC\uff1a=RBG-CBG;<\/p>\n<p> \u3000\u3000RZB\uff1a=MR\/DYNAINFO\uff088\uff09*100;<\/p>\n<p> \u3000\u3000CZB\uff1a=MC\/DYNAINFO\uff088\uff09*100;<\/p>\n<p> \u3000\u3000MR1\uff1a=IF\uff08N=1\uff0cT1\uff0cT2\uff09;<\/p>\n<p> \u3000\u3000MC1\uff1a=IF\uff08N=1\uff0cT3\uff0cT4\uff09;<\/p>\n<p> \u3000\u3000ZMX\uff1a=\uff08MR1-MC1\uff09\/DYNAINFO\uff088\uff09*100;<\/p>\n<p> \u3000\u3000CS\uff1a=IFS\uff08N=1\uff0c\u2018\u5355\u2019\uff0c\u2018\u7b14\u2019\uff09;<\/p>\n<p> \u3000\u3000{\u8868\u683c}<\/p>\n<p> \u3000\u3000DRAWRECTABS\uff080\uff0c0\uff0c838\uff0c48\uff0cRGB\uff081\uff0c1\uff0c1\uff09\uff09\uff0cCOLOR0000C0;<\/p>\n<p> \u3000\u3000DRAWRECTABS\uff080\uff0c0\uff0c696\uff0c13\uff0cRGB\uff08210\uff0c150\uff0c0\uff09\uff09\uff0cCOLOR0096D2;<\/p>\n<p> \u3000\u3000DRAWRECTABS\uff08696\uff0c0\uff0c838\uff0c13\uff0cRGB\uff08210\uff0c100\uff0c0\uff09\uff09\uff0cCOLOR0064D2;<\/p>\n<p> \u3000\u3000DRAWRECTABS\uff080\uff0c0\uff0c87\uff0c48\uff0c0\uff09\uff0cCOLOR0000C0;<\/p>\n<p> \u3000\u3000DRAWRECTABS\uff080\uff0c0\uff0c174\uff0c48\uff0c0\uff09\uff0cCOLOR0000C0;<\/p>\n<p> \u3000\u3000DRAWRECTABS\uff080\uff0c0\uff0c261\uff0c48\uff0c0\uff09\uff0cCOLOR0000C0;<\/p>\n<p> \u3000\u3000DRAWRECTABS\uff080\uff0c0\uff0c348\uff0c48\uff0c0\uff09\uff0cCOLOR0000C0;<\/p>\n<p> \u3000\u3000DRAWRECTABS\uff080\uff0c0\uff0c435\uff0c48\uff0c0\uff09\uff0cCOLOR0000C0;<\/p>\n<p> \u3000\u3000DRAWRECTABS\uff080\uff0c0\uff0c522\uff0c48\uff0c0\uff09\uff0cCOLOR0000C0;<\/p>\n<p> \u3000\u3000DRAWRECTABS\uff080\uff0c0\uff0c609\uff0c48\uff0c0\uff09\uff0cCOLOR0000C0;<\/p>\n<p> \u3000\u3000DRAWRECTABS\uff080\uff0c0\uff0c696\uff0c48\uff0c0\uff09\uff0cCOLOR0000C0;<\/p>\n<p> \u3000\u3000DRAWRECTABS\uff080\uff0c0\uff0c838\uff0c48\uff0c0\uff09\uff0cCOLOR0000C0;<\/p>\n<p> \u3000\u3000{\u663e\u793a\u6587\u5b57\u6570\u5b57}<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff0815\uff0c1\uff0c\u20189:30-10:00 10:00-10:30 10:30-11:00 11:00-11:30 13:00-13:30 13:30-14:00 14:00-14:30 14:30-15:00 \u2019\uff09\uff0cCOLORFFFFFF;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff0836\uff0c13\uff0cNUMTOSTRN\uff08AA\uff0c0\uff09+CS\uff09\uff0cCOLOR0000FF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff0836\uff0c24\uff0cNUMTOSTRN\uff08AA1\uff0c0\uff09+CS\uff09\uff0cCOLORFFFF00\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff0836\uff0c35\uff0cNUMTOSTRN\uff08AA-AA1\uff0c0\uff09+CS\uff09\uff0cCOLOR00FFFF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff0886\uff0c13\uff0cNUMTOSTRN\uff08II\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLOR0000FF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff0886\uff0c24\uff0cNUMTOSTRN\uff08II1\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLORFFFF00\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff0886\uff0c35\uff0cNUMTOSTRN\uff08II-II1\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLOR00FFFF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08123\uff0c13\uff0cNUMTOSTRN\uff08BB\uff0c0\uff09+CS\uff09\uff0cCOLOR0000FF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08123\uff0c24\uff0cNUMTOSTRN\uff08BB1\uff0c0\uff09+CS\uff09\uff0cCOLORFFFF00\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08123\uff0c35\uff0cNUMTOSTRN\uff08BB-BB1\uff0c0\uff09+CS\uff09\uff0cCOLOR00FFFF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08173\uff0c13\uff0cNUMTOSTRN\uff08JJ\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLOR0000FF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08173\uff0c24\uff0cNUMTOSTRN\uff08JJ1\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLORFFFF00\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08173\uff0c35\uff0cNUMTOSTRN\uff08JJ-JJ1\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLOR00FFFF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08210\uff0c13\uff0cNUMTOSTRN\uff08CC\uff0c0\uff09+CS\uff09\uff0cCOLOR0000FF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08210\uff0c24\uff0cNUMTOSTRN\uff08CC1\uff0c0\uff09+CS\uff09\uff0cCOLORFFFF00\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08210\uff0c35\uff0cNUMTOSTRN\uff08CC-CC1\uff0c0\uff09+CS\uff09\uff0cCOLOR00FFFF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08260\uff0c13\uff0cNUMTOSTRN\uff08KK\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLOR0000FF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08260\uff0c24\uff0cNUMTOSTRN\uff08KK1\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLORFFFF00\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08260\uff0c35\uff0cNUMTOSTRN\uff08KK-KK1\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLOR00FFFF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08297\uff0c13\uff0cNUMTOSTRN\uff08DD\uff0c0\uff09+CS\uff09\uff0cCOLOR0000FF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08297\uff0c24\uff0cNUMTOSTRN\uff08DD1\uff0c0\uff09+CS\uff09\uff0cCOLORFFFF00\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08297\uff0c35\uff0cNUMTOSTRN\uff08DD-DD1\uff0c0\uff09+CS\uff09\uff0cCOLOR00FFFF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08347\uff0c13\uff0cNUMTOSTRN\uff08LL\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLOR0000FF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08347\uff0c24\uff0cNUMTOSTRN\uff08LL1\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLORFFFF00\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08347\uff0c35\uff0cNUMTOSTRN\uff08LL-LL1\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLOR00FFFF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08384\uff0c13\uff0cNUMTOSTRN\uff08EE\uff0c0\uff09+CS\uff09\uff0cCOLOR0000FF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08384\uff0c24\uff0cNUMTOSTRN\uff08EE1\uff0c0\uff09+CS\uff09\uff0cCOLORFFFF00\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08384\uff0c35\uff0cNUMTOSTRN\uff08EE-EE1\uff0c0\uff09+CS\uff09\uff0cCOLOR00FFFF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08434\uff0c13\uff0cNUMTOSTRN\uff08NN\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLOR0000FF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08434\uff0c24\uff0cNUMTOSTRN\uff08NN1\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLORFFFF00\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08434\uff0c35\uff0cNUMTOSTRN\uff08NN-NN1\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLOR00FFFF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08471\uff0c13\uff0cNUMTOSTRN\uff08FF\uff0c0\uff09+CS\uff09\uff0cCOLOR0000FF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08471\uff0c24\uff0cNUMTOSTRN\uff08FF1\uff0c0\uff09+CS\uff09\uff0cCOLORFFFF00\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08471\uff0c35\uff0cNUMTOSTRN\uff08FF-FF1\uff0c0\uff09+CS\uff09\uff0cCOLOR00FFFF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08521\uff0c13\uff0cNUMTOSTRN\uff08OO\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLOR0000FF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08521\uff0c24\uff0cNUMTOSTRN\uff08OO1\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLORFFFF00\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08521\uff0c35\uff0cNUMTOSTRN\uff08OO-OO1\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLOR00FFFF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08558\uff0c13\uff0cNUMTOSTRN\uff08GG\uff0c0\uff09+CS\uff09\uff0cCOLOR0000FF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08558\uff0c24\uff0cNUMTOSTRN\uff08GG1\uff0c0\uff09+CS\uff09\uff0cCOLORFFFF00\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08558\uff0c35\uff0cNUMTOSTRN\uff08GG-GG1\uff0c0\uff09+CS\uff09\uff0cCOLOR00FFFF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08608\uff0c13\uff0cNUMTOSTRN\uff08PP\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLOR0000FF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08608\uff0c24\uff0cNUMTOSTRN\uff08PP1\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLORFFFF00\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08608\uff0c35\uff0cNUMTOSTRN\uff08PP-PP1\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLOR00FFFF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08645\uff0c13\uff0cNUMTOSTRN\uff08HH\uff0c0\uff09+CS\uff09\uff0cCOLOR0000FF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08645\uff0c24\uff0cNUMTOSTRN\uff08HH1\uff0c0\uff09+CS\uff09\uff0cCOLORFFFF00\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08645\uff0c35\uff0cNUMTOSTRN\uff08HH-HH1\uff0c0\uff09+CS\uff09\uff0cCOLOR00FFFF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08695\uff0c13\uff0cNUMTOSTRN\uff08QQ\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLOR0000FF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08695\uff0c24\uff0cNUMTOSTRN\uff08QQ1\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLORFFFF00\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08695\uff0c35\uff0cNUMTOSTRN\uff08QQ-QQ1\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLOR00FFFF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWRECTABS\uff08767\uff0c2\uff0c767+RZB\uff0c12\uff0cRGB\uff08255\uff0c30\uff0c30\uff09\uff09\uff0cCOLORFFFFFF;<\/p>\n<p> \u3000\u3000DRAWRECTABS\uff08767\uff0c2\uff0c767-CZB\uff0c12\uff0cRGB\uff0830\uff0c30\uff0c255\uff09\uff09\uff0cCOLORFFFFFF;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08733\uff0c1\uff0cNUMTOSTRN\uff08CZB\uff0c2\uff09+\u2018%\u2019\uff09\uff0cALIGN2\uff0cCOLOR00FFFF;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08837\uff0c1\uff0cNUMTOSTRN\uff08RZB\uff0c2\uff09+\u2018%\u2019\uff09\uff0cALIGN2\uff0cCOLOR00FFFF;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08740\uff0c13\uff0cNUMTOSTRN\uff08MR\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLOR4848FF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08740\uff0c24\uff0cNUMTOSTRN\uff08MC\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLOR48FF48\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08740\uff0c35\uff0cNUMTOSTRN\uff08JS\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLOREEEEEE\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08773\uff0c13\uff0cNUMTOSTRN\uff08MRB\uff0c0\uff09+\u2018\u7b14\u2019\uff09\uff0cCOLOR4848FF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08773\uff0c24\uff0cNUMTOSTRN\uff08MCB\uff0c0\uff09+\u2018\u7b14\u2019\uff09\uff0cCOLOR48FF48\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08773\uff0c35\uff0cNUMTOSTRN\uff08JB\uff0c0\uff09+\u2018\u7b14\u2019\uff09\uff0cCOLOREEEEEE\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08837\uff0c13\uff0cNUMTOSTRN\uff08RBG\uff0c0\uff09+\u2018\u80a1\/\u7b14\u2019\uff09\uff0cCOLOR4848FF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08837\uff0c24\uff0cNUMTOSTRN\uff08CBG\uff0c0\uff09+\u2018\u80a1\/\u7b14\u2019\uff09\uff0cCOLOR48FF48\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08837\uff0c35\uff0cNUMTOSTRN\uff08JC\uff0c0\uff09+\u2018\u80a1\/\u7b14\u2019\uff09\uff0cCOLOREEEEEE\uff0cALIGN2;<\/p>\n<p> \u3000\u3000{\u8d85\u623730\u5206}<\/p>\n<p> \u3000\u3000input:N\uff081\uff0c1\uff0c2\uff09;<\/p>\n<p> \u3000\u3000TODAY\uff1a=\u201c\u5206\u65f6DDX.DDX\u7d2f\u79ef\u201d\u300a\u300b0;{\u5224\u65ad\u662f\u5426\u6709\u6b63\u7248\u6570\u636e}<\/p>\n<p> \u3000\u3000TODAY1\uff1a=\u201cLXDDX.DDX#day\u201d=0;{\u5224\u65ad\u662f\u5426\u6709\u96e8\u6768\u6570\u636e}<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08680\uff0c-12\uff0cIFS\uff08TODAY\uff0c\u2018\u6b63\u7248\u6570\u636e\u2019\uff0cIFS\uff08TODAY1\uff0c\u2018\u5f15\u5165\u6570\u636e\u2019\uff0c\u2018\u96e8\u6768\u6570\u636e \u2019\uff09\uff09\uff09\uff0cLINETHICK1\uff0ccolorwhite;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08752\uff0c-12\uff0cIFS\uff08N=1\uff0c\u2018\u9010\u5355\u2019\uff0c\u2018\u9010\u7b14\u2019\uff09\uff09\uff0cLINETHICK1\uff0ccolorwhite;<\/p>\n<p> \u3000\u3000ZT1\uff1a=\u201cwd.o13\u201d{ORDERVOL\uff081\uff0c3\uff09};<\/p>\n<p> \u3000\u3000YT1\u7d2f\u79ef\uff1a=\u201cDDEDATA@BIGORDERSCALE\u201d\uff081\uff0c3\uff09*SUM\uff08VOL\uff0c0\uff09;<\/p>\n<p> \u3000\u3000YT1\uff1a=YT1\u7d2f\u79ef-REF\uff08YT1\u7d2f\u79ef\uff0c1\uff09;<\/p>\n<p> \u3000\u3000RT1\u7d2f\u79ef\uff1a=\u201cwd.\u7279\u5355\u4e70#day\u201d*SUM\uff08VOL\uff0c0\uff09;<\/p>\n<p> \u3000\u3000RT1\uff1a=RT1\u7d2f\u79ef-REF\uff08RT1\u7d2f\u79ef\uff0c1\uff09;<\/p>\n<p> \u3000\u3000T1\uff1a=IF\uff08TODAY\uff0cZT1\uff0cIF\uff08TODAY1\uff0cRT1\uff0cYT1\uff09\uff09;<\/p>\n<p> \u3000\u3000T2\uff1a=\u201cwd.t13\u201d{TRANSACTVOL\uff081\uff0c3\uff09};<\/p>\n<p> \u3000\u3000ZT3\uff1a=\u201cwd.o23\u201d{ORDERVOL\uff082\uff0c3\uff09};<\/p>\n<p> \u3000\u3000YT3\u7d2f\u79ef\uff1a=\u201cDDEDATA@BIGORDERSCALE\u201d\uff082\uff0c3\uff09*SUM\uff08VOL\uff0c0\uff09;<\/p>\n<p> \u3000\u3000YT3\uff1a=YT3\u7d2f\u79ef-REF\uff08YT3\u7d2f\u79ef\uff0c1\uff09;<\/p>\n<p> \u3000\u3000RT3\u7d2f\u79ef\uff1a=\u201cwd.\u7279\u5355\u5356#day\u201d*SUM\uff08VOL\uff0c0\uff09;<\/p>\n<p> \u3000\u3000RT3\uff1a=RT3\u7d2f\u79ef-REF\uff08RT3\u7d2f\u79ef\uff0c1\uff09;<\/p>\n<p> \u3000\u3000T3\uff1a=IF\uff08TODAY\uff0cZT3\uff0cIF\uff08TODAY1\uff0cRT3\uff0cYT3\uff09\uff09;<\/p>\n<p> \u3000\u3000T4\uff1a=\u201cwd.t23\u201d{TRANSACTVOL\uff082\uff0c3\uff09};<\/p>\n<p> \u3000\u3000ZS1\uff1a=\u201cwd.d13\u201d{ORDERNUM\uff081\uff0c3\uff09};<\/p>\n<p> \u3000\u3000YS1\uff1a=\u201cDDEDATA@BIGORDERSCALE\u201d\uff081\uff0c3\uff09;<\/p>\n<p> \u3000\u3000RS1\uff1a=\u201cwd.\u7279\u5355\u4e70#day\u201d;<\/p>\n<p> \u3000\u3000S1\uff1a=IF\uff08TODAY\uff0cZS1\uff0cIF\uff08TODAY1\uff0cRS1\uff0cYS1\uff09\uff09;<\/p>\n<p> \u3000\u3000S2\uff1a=\u201cwd.l13\u201d{TRANSACTNUM\uff081\uff0c3\uff09};<\/p>\n<p> \u3000\u3000ZS3\uff1a=\u201cwd.d23\u201d{ORDERNUM\uff082\uff0c3\uff09};<\/p>\n<p> \u3000\u3000YS3\uff1a=\u201cDDEDATA@BIGORDERSCALE\u201d\uff082\uff0c3\uff09;<\/p>\n<p> \u3000\u3000RS3\uff1a=\u201cwd.\u7279\u5355\u5356#day\u201d;<\/p>\n<p> \u3000\u3000S3\uff1a=IF\uff08TODAY\uff0cZS3\uff0cIF\uff08TODAY1\uff0cRS3\uff0cYS3\uff09\uff09;<\/p>\n<p> \u3000\u3000S4\uff1a=\u201cwd.l23\u201d{TRANSACTNUM\uff082\uff0c3\uff09};<\/p>\n<p> \u3000\u3000M1\uff1a=TIME\u300a=100000;<\/p>\n<p> \u3000\u3000M2\uff1a=TIME\u300a=103000 AND TIME\u300b100000;<\/p>\n<p> \u3000\u3000M3\uff1a=TIME\u300a=110000 AND TIME\u300b103000;<\/p>\n<p> \u3000\u3000M4\uff1a=TIME\u300a=113000 AND TIME\u300b110000;<\/p>\n<p> \u3000\u3000M5\uff1a=TIME\u300a=133000 AND TIME\u300b130000;<\/p>\n<p> \u3000\u3000M6\uff1a=TIME\u300a=140000 AND TIME\u300b133000;<\/p>\n<p> \u3000\u3000M7\uff1a=TIME\u300a=143000 AND TIME\u300b140000;<\/p>\n<p> \u3000\u3000M8\uff1a=TIME\u300a=150000 AND TIME\u300b143000;<\/p>\n<p> \u3000\u3000{\u6570\u636e1\u5927\u4e70}<\/p>\n<p> \u3000\u3000A1\uff1a=IF\uff08M1\uff0cS1\uff0c0\uff09;<\/p>\n<p> \u3000\u3000A2\uff1a=IF\uff08M1\uff0cS2\uff0c0\uff09;<\/p>\n<p> \u3000\u3000AA\uff1a=SUM\uff08IF\uff08N=1\uff0cA1\uff0cA2\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000B1\uff1a=IF\uff08M2\uff0cS1\uff0c0\uff09;<\/p>\n<p> \u3000\u3000B2\uff1a=IF\uff08M2\uff0cS2\uff0c0\uff09;<\/p>\n<p> \u3000\u3000BB\uff1a=SUM\uff08IF\uff08N=1\uff0cB1\uff0cB2\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000C1\uff1a=IF\uff08M3\uff0cS1\uff0c0\uff09;<\/p>\n<p> \u3000\u3000C2\uff1a=IF\uff08M3\uff0cS2\uff0c0\uff09;<\/p>\n<p> \u3000\u3000CC\uff1a=SUM\uff08IF\uff08N=1\uff0cC1\uff0cC2\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000D1\uff1a=IF\uff08M4\uff0cS1\uff0c0\uff09;<\/p>\n<p> \u3000\u3000D2\uff1a=IF\uff08M4\uff0cS2\uff0c0\uff09;<\/p>\n<p> \u3000\u3000DD\uff1a=SUM\uff08IF\uff08N=1\uff0cD1\uff0cD2\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000E1\uff1a=IF\uff08M5\uff0cS1\uff0c0\uff09;<\/p>\n<p> \u3000\u3000E2\uff1a=IF\uff08M5\uff0cS2\uff0c0\uff09;<\/p>\n<p> \u3000\u3000EE\uff1a=SUM\uff08IF\uff08N=1\uff0cE1\uff0cE2\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000F1\uff1a=IF\uff08M6\uff0cS1\uff0c0\uff09;<\/p>\n<p> \u3000\u3000F2\uff1a=IF\uff08M6\uff0cS2\uff0c0\uff09;<\/p>\n<p> \u3000\u3000FF\uff1a=SUM\uff08IF\uff08N=1\uff0cF1\uff0cF2\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000G1\uff1a=IF\uff08M7\uff0cS1\uff0c0\uff09;<\/p>\n<p> \u3000\u3000G2\uff1a=IF\uff08M7\uff0cS2\uff0c0\uff09;<\/p>\n<p> \u3000\u3000GG\uff1a=SUM\uff08IF\uff08N=1\uff0cG1\uff0cG2\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000H1\uff1a=IF\uff08M8\uff0cS1\uff0c0\uff09;<\/p>\n<p> \u3000\u3000H2\uff1a=IF\uff08M8\uff0cS2\uff0c0\uff09;<\/p>\n<p> \u3000\u3000HH\uff1a=SUM\uff08IF\uff08N=1\uff0cH1\uff0cH2\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000I1\uff1a=IF\uff08M1\uff0cT1\uff0c0\uff09;<\/p>\n<p> \u3000\u3000I2\uff1a=IF\uff08M1\uff0cT2\uff0c0\uff09;<\/p>\n<p> \u3000\u3000II\uff1a=SUM\uff08IF\uff08N=1\uff0cI1\uff0cI2\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000J1\uff1a=IF\uff08M2\uff0cT1\uff0c0\uff09;<\/p>\n<p> \u3000\u3000J2\uff1a=IF\uff08M2\uff0cT2\uff0c0\uff09;<\/p>\n<p> \u3000\u3000JJ\uff1a=SUM\uff08IF\uff08N=1\uff0cJ1\uff0cJ2\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000K1\uff1a=IF\uff08M3\uff0cT1\uff0c0\uff09;<\/p>\n<p> \u3000\u3000K2\uff1a=IF\uff08M3\uff0cT2\uff0c0\uff09;<\/p>\n<p> \u3000\u3000KK\uff1a=SUM\uff08IF\uff08N=1\uff0cK1\uff0cK2\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000L1\uff1a=IF\uff08M4\uff0cT1\uff0c0\uff09;<\/p>\n<p> \u3000\u3000L2\uff1a=IF\uff08M4\uff0cT2\uff0c0\uff09;<\/p>\n<p> \u3000\u3000LL\uff1a=SUM\uff08IF\uff08N=1\uff0cL1\uff0cL2\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000N1\uff1a=IF\uff08M5\uff0cT1\uff0c0\uff09;<\/p>\n<p> \u3000\u3000N2\uff1a=IF\uff08M5\uff0cT2\uff0c0\uff09;<\/p>\n<p> \u3000\u3000NN\uff1a=SUM\uff08IF\uff08N=1\uff0cN1\uff0cN2\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000O1\uff1a=IF\uff08M6\uff0cT1\uff0c0\uff09;<\/p>\n<p> \u3000\u3000O2\uff1a=IF\uff08M6\uff0cT2\uff0c0\uff09;<\/p>\n<p> \u3000\u3000OO\uff1a=SUM\uff08IF\uff08N=1\uff0cO1\uff0cO2\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000P1\uff1a=IF\uff08M7\uff0cT1\uff0c0\uff09;<\/p>\n<p> \u3000\u3000P2\uff1a=IF\uff08M7\uff0cT2\uff0c0\uff09;<\/p>\n<p> \u3000\u3000PP\uff1a=SUM\uff08IF\uff08N=1\uff0cP1\uff0cP2\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000Q1\uff1a=IF\uff08M8\uff0cT1\uff0c0\uff09;<\/p>\n<p> \u3000\u3000Q2\uff1a=IF\uff08M8\uff0cT2\uff0c0\uff09;<\/p>\n<p> \u3000\u3000QQ\uff1a=SUM\uff08IF\uff08N=1\uff0cQ1\uff0cQ2\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000{\u6570\u636e2\u5927\u5356}<\/p>\n<p> \u3000\u3000A3\uff1a=IF\uff08M1\uff0cS3\uff0c0\uff09;<\/p>\n<p> \u3000\u3000A4\uff1a=IF\uff08M1\uff0cS4\uff0c0\uff09;<\/p>\n<p> \u3000\u3000AA1\uff1a=SUM\uff08IF\uff08N=1\uff0cA3\uff0cA4\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000B3\uff1a=IF\uff08M2\uff0cS3\uff0c0\uff09;<\/p>\n<p> \u3000\u3000B4\uff1a=IF\uff08M2\uff0cS4\uff0c0\uff09;<\/p>\n<p> \u3000\u3000BB1\uff1a=SUM\uff08IF\uff08N=1\uff0cB3\uff0cB4\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000C3\uff1a=IF\uff08M3\uff0cS3\uff0c0\uff09;<\/p>\n<p> \u3000\u3000C4\uff1a=IF\uff08M3\uff0cS4\uff0c0\uff09;<\/p>\n<p> \u3000\u3000CC1\uff1a=SUM\uff08IF\uff08N=1\uff0cC3\uff0cC4\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000D3\uff1a=IF\uff08M4\uff0cS3\uff0c0\uff09;<\/p>\n<p> \u3000\u3000D4\uff1a=IF\uff08M4\uff0cS4\uff0c0\uff09;<\/p>\n<p> \u3000\u3000DD1\uff1a=SUM\uff08IF\uff08N=1\uff0cD3\uff0cD4\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000E3\uff1a=IF\uff08M5\uff0cS3\uff0c0\uff09;<\/p>\n<p> \u3000\u3000E4\uff1a=IF\uff08M5\uff0cS4\uff0c0\uff09;<\/p>\n<p> \u3000\u3000EE1\uff1a=SUM\uff08IF\uff08N=1\uff0cE3\uff0cE4\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000F3\uff1a=IF\uff08M6\uff0cS3\uff0c0\uff09;<\/p>\n<p> \u3000\u3000F4\uff1a=IF\uff08M6\uff0cS4\uff0c0\uff09;<\/p>\n<p> \u3000\u3000FF1\uff1a=SUM\uff08IF\uff08N=1\uff0cF3\uff0cF4\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000G3\uff1a=IF\uff08M7\uff0cS3\uff0c0\uff09;<\/p>\n<p> \u3000\u3000G4\uff1a=IF\uff08M7\uff0cS4\uff0c0\uff09;<\/p>\n<p> \u3000\u3000GG1\uff1a=SUM\uff08IF\uff08N=1\uff0cG3\uff0cG4\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000H3\uff1a=IF\uff08M8\uff0cS3\uff0c0\uff09;<\/p>\n<p> \u3000\u3000H4\uff1a=IF\uff08M8\uff0cS4\uff0c0\uff09;<\/p>\n<p> \u3000\u3000HH1\uff1a=SUM\uff08IF\uff08N=1\uff0cH3\uff0cH4\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000I3\uff1a=IF\uff08M1\uff0cT3\uff0c0\uff09;<\/p>\n<p> \u3000\u3000I4\uff1a=IF\uff08M1\uff0cT4\uff0c0\uff09;<\/p>\n<p> \u3000\u3000II1\uff1a=SUM\uff08IF\uff08N=1\uff0cI3\uff0cI4\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000J3\uff1a=IF\uff08M2\uff0cT3\uff0c0\uff09;<\/p>\n<p> \u3000\u3000J4\uff1a=IF\uff08M2\uff0cT4\uff0c0\uff09;<\/p>\n<p> \u3000\u3000JJ1\uff1a=SUM\uff08IF\uff08N=1\uff0cJ3\uff0cJ4\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000K3\uff1a=IF\uff08M3\uff0cT3\uff0c0\uff09;<\/p>\n<p> \u3000\u3000K4\uff1a=IF\uff08M3\uff0cT4\uff0c0\uff09;<\/p>\n<p> \u3000\u3000KK1\uff1a=SUM\uff08IF\uff08N=1\uff0cK3\uff0cK4\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000L3\uff1a=IF\uff08M4\uff0cT3\uff0c0\uff09;<\/p>\n<p> \u3000\u3000L4\uff1a=IF\uff08M4\uff0cT4\uff0c0\uff09;<\/p>\n<p> \u3000\u3000LL1\uff1a=SUM\uff08IF\uff08N=1\uff0cL3\uff0cL4\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000N3\uff1a=IF\uff08M5\uff0cT3\uff0c0\uff09;<\/p>\n<p> \u3000\u3000N4\uff1a=IF\uff08M5\uff0cT4\uff0c0\uff09;<\/p>\n<p> \u3000\u3000NN1\uff1a=SUM\uff08IF\uff08N=1\uff0cN3\uff0cN4\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000O3\uff1a=IF\uff08M6\uff0cT3\uff0c0\uff09;<\/p>\n<p> \u3000\u3000O4\uff1a=IF\uff08M6\uff0cT4\uff0c0\uff09;<\/p>\n<p> \u3000\u3000OO1\uff1a=SUM\uff08IF\uff08N=1\uff0cO3\uff0cO4\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000P3\uff1a=IF\uff08M7\uff0cT3\uff0c0\uff09;<\/p>\n<p> \u3000\u3000P4\uff1a=IF\uff08M7\uff0cT4\uff0c0\uff09;<\/p>\n<p> \u3000\u3000PP1\uff1a=SUM\uff08IF\uff08N=1\uff0cP3\uff0cP4\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000Q3\uff1a=IF\uff08M8\uff0cT3\uff0c0\uff09;<\/p>\n<p> \u3000\u3000Q4\uff1a=IF\uff08M8\uff0cT4\uff0c0\uff09;<\/p>\n<p> \u3000\u3000QQ1\uff1a=SUM\uff08IF\uff08N=1\uff0cQ3\uff0cQ4\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000{\u6570\u636e3\u603b\u4e70\u603b\u5356\u5dee}<\/p>\n<p> \u3000\u3000MR\uff1a=IF\uff08N=1\uff0cSUM\uff08T1\uff0c0\uff09\uff0cSUM\uff08T2\uff0c0\uff09\uff09;<\/p>\n<p> \u3000\u3000MC\uff1a=IF\uff08N=1\uff0cSUM\uff08T3\uff0c0\uff09\uff0cSUM\uff08T4\uff0c0\uff09\uff09;<\/p>\n<p> \u3000\u3000MRE\uff1a=MR*DYNAINFO\uff0811\uff09*100\/10000;<\/p>\n<p> \u3000\u3000MCE\uff1a=MC*DYNAINFO\uff0811\uff09*100\/10000;<\/p>\n<p> \u3000\u3000\u6d41\u5165\u8d44\u91d1\uff1aMRE\uff0cCOLOR0000FF\uff0clinethick0\uff0cPRECIS2;<\/p>\n<p> \u3000\u3000\u6d41\u51fa\u8d44\u91d1\uff1aMCE\uff0cCOLORFFFF00\uff0clinethick0\uff0cPRECIS2;<\/p>\n<p> \u3000\u3000MRB\uff1a=IF\uff08N=1\uff0cSUM\uff08S1\uff0c0\uff09\uff0cSUM\uff08S2\uff0c0\uff09\uff09;<\/p>\n<p> \u3000\u3000MCB\uff1a=IF\uff08N=1\uff0cSUM\uff08S3\uff0c0\uff09\uff0cSUM\uff08S4\uff0c0\uff09\uff09;<\/p>\n<p> \u3000\u3000RBG\uff1a=MR*100\/MRB;<\/p>\n<p> \u3000\u3000CBG\uff1a=MC*100\/MCB;<\/p>\n<p> \u3000\u3000JS\uff1a=MR-MC;<\/p>\n<p> \u3000\u3000JE\uff1a=MRE-MCE;<\/p>\n<p> \u3000\u3000\u51c0\u8d44\u91d1\uff1aJE\uff0cCOLOR00FFFF\uff0clinethick0\uff0cPRECIS2;<\/p>\n<p> \u3000\u3000JB\uff1a=MRB-MCB;<\/p>\n<p> \u3000\u3000JC\uff1a=RBG-CBG;<\/p>\n<p> \u3000\u3000RZB\uff1a=MR\/DYNAINFO\uff088\uff09*100;<\/p>\n<p> \u3000\u3000CZB\uff1a=MC\/DYNAINFO\uff088\uff09*100;<\/p>\n<p> \u3000\u3000MR1\uff1a=IF\uff08N=1\uff0cT1\uff0cT2\uff09;<\/p>\n<p> \u3000\u3000MC1\uff1a=IF\uff08N=1\uff0cT3\uff0cT4\uff09;<\/p>\n<p> \u3000\u3000ZMX\uff1a=\uff08MR1-MC1\uff09\/DYNAINFO\uff088\uff09*100;<\/p>\n<p> \u3000\u3000CS\uff1a=IFS\uff08N=1\uff0c\u2018\u5355\u2019\uff0c\u2018\u7b14\u2019\uff09;<\/p>\n<p> \u3000\u3000{\u8868\u683c}<\/p>\n<p> \u3000\u3000DRAWRECTABS\uff080\uff0c0\uff0c838\uff0c48\uff0cRGB\uff081\uff0c1\uff0c1\uff09\uff09\uff0cCOLOR0000C0;<\/p>\n<p> \u3000\u3000DRAWRECTABS\uff080\uff0c0\uff0c696\uff0c13\uff0cRGB\uff08210\uff0c150\uff0c0\uff09\uff09\uff0cCOLOR0096D2;<\/p>\n<p> \u3000\u3000DRAWRECTABS\uff08696\uff0c0\uff0c838\uff0c13\uff0cRGB\uff08210\uff0c100\uff0c0\uff09\uff09\uff0cCOLOR0064D2;<\/p>\n<p> \u3000\u3000DRAWRECTABS\uff080\uff0c0\uff0c87\uff0c48\uff0c0\uff09\uff0cCOLOR0000C0;<\/p>\n<p> \u3000\u3000DRAWRECTABS\uff080\uff0c0\uff0c174\uff0c48\uff0c0\uff09\uff0cCOLOR0000C0;<\/p>\n<p> \u3000\u3000DRAWRECTABS\uff080\uff0c0\uff0c261\uff0c48\uff0c0\uff09\uff0cCOLOR0000C0;<\/p>\n<p> \u3000\u3000DRAWRECTABS\uff080\uff0c0\uff0c348\uff0c48\uff0c0\uff09\uff0cCOLOR0000C0;<\/p>\n<p> \u3000\u3000DRAWRECTABS\uff080\uff0c0\uff0c435\uff0c48\uff0c0\uff09\uff0cCOLOR0000C0;<\/p>\n<p> \u3000\u3000DRAWRECTABS\uff080\uff0c0\uff0c522\uff0c48\uff0c0\uff09\uff0cCOLOR0000C0;<\/p>\n<p> \u3000\u3000DRAWRECTABS\uff080\uff0c0\uff0c609\uff0c48\uff0c0\uff09\uff0cCOLOR0000C0;<\/p>\n<p> \u3000\u3000DRAWRECTABS\uff080\uff0c0\uff0c696\uff0c48\uff0c0\uff09\uff0cCOLOR0000C0;<\/p>\n<p> \u3000\u3000DRAWRECTABS\uff080\uff0c0\uff0c838\uff0c48\uff0c0\uff09\uff0cCOLOR0000C0;<\/p>\n<p> \u3000\u3000{\u663e\u793a\u6587\u5b57\u6570\u5b57}<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff0815\uff0c1\uff0c\u20189:30-10:00 10:00-10:30 10:30-11:00 11:00-11:30 13:00-13:30 13:30-14:00 14:00-14:30 14:30-15:00 \u2019\uff09\uff0cCOLORFFFFFF;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff0836\uff0c13\uff0cNUMTOSTRN\uff08AA\uff0c0\uff09+CS\uff09\uff0cCOLOR0000FF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff0836\uff0c24\uff0cNUMTOSTRN\uff08AA1\uff0c0\uff09+CS\uff09\uff0cCOLORFFFF00\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff0836\uff0c35\uff0cNUMTOSTRN\uff08AA-AA1\uff0c0\uff09+CS\uff09\uff0cCOLOR00FFFF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff0886\uff0c13\uff0cNUMTOSTRN\uff08II\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLOR0000FF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff0886\uff0c24\uff0cNUMTOSTRN\uff08II1\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLORFFFF00\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff0886\uff0c35\uff0cNUMTOSTRN\uff08II-II1\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLOR00FFFF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08123\uff0c13\uff0cNUMTOSTRN\uff08BB\uff0c0\uff09+CS\uff09\uff0cCOLOR0000FF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08123\uff0c24\uff0cNUMTOSTRN\uff08BB1\uff0c0\uff09+CS\uff09\uff0cCOLORFFFF00\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08123\uff0c35\uff0cNUMTOSTRN\uff08BB-BB1\uff0c0\uff09+CS\uff09\uff0cCOLOR00FFFF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08173\uff0c13\uff0cNUMTOSTRN\uff08JJ\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLOR0000FF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08173\uff0c24\uff0cNUMTOSTRN\uff08JJ1\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLORFFFF00\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08173\uff0c35\uff0cNUMTOSTRN\uff08JJ-JJ1\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLOR00FFFF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08210\uff0c13\uff0cNUMTOSTRN\uff08CC\uff0c0\uff09+CS\uff09\uff0cCOLOR0000FF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08210\uff0c24\uff0cNUMTOSTRN\uff08CC1\uff0c0\uff09+CS\uff09\uff0cCOLORFFFF00\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08210\uff0c35\uff0cNUMTOSTRN\uff08CC-CC1\uff0c0\uff09+CS\uff09\uff0cCOLOR00FFFF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08260\uff0c13\uff0cNUMTOSTRN\uff08KK\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLOR0000FF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08260\uff0c24\uff0cNUMTOSTRN\uff08KK1\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLORFFFF00\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08260\uff0c35\uff0cNUMTOSTRN\uff08KK-KK1\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLOR00FFFF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08297\uff0c13\uff0cNUMTOSTRN\uff08DD\uff0c0\uff09+CS\uff09\uff0cCOLOR0000FF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08297\uff0c24\uff0cNUMTOSTRN\uff08DD1\uff0c0\uff09+CS\uff09\uff0cCOLORFFFF00\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08297\uff0c35\uff0cNUMTOSTRN\uff08DD-DD1\uff0c0\uff09+CS\uff09\uff0cCOLOR00FFFF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08347\uff0c13\uff0cNUMTOSTRN\uff08LL\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLOR0000FF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08347\uff0c24\uff0cNUMTOSTRN\uff08LL1\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLORFFFF00\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08347\uff0c35\uff0cNUMTOSTRN\uff08LL-LL1\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLOR00FFFF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08384\uff0c13\uff0cNUMTOSTRN\uff08EE\uff0c0\uff09+CS\uff09\uff0cCOLOR0000FF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08384\uff0c24\uff0cNUMTOSTRN\uff08EE1\uff0c0\uff09+CS\uff09\uff0cCOLORFFFF00\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08384\uff0c35\uff0cNUMTOSTRN\uff08EE-EE1\uff0c0\uff09+CS\uff09\uff0cCOLOR00FFFF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08434\uff0c13\uff0cNUMTOSTRN\uff08NN\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLOR0000FF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08434\uff0c24\uff0cNUMTOSTRN\uff08NN1\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLORFFFF00\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08434\uff0c35\uff0cNUMTOSTRN\uff08NN-NN1\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLOR00FFFF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08471\uff0c13\uff0cNUMTOSTRN\uff08FF\uff0c0\uff09+CS\uff09\uff0cCOLOR0000FF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08471\uff0c24\uff0cNUMTOSTRN\uff08FF1\uff0c0\uff09+CS\uff09\uff0cCOLORFFFF00\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08471\uff0c35\uff0cNUMTOSTRN\uff08FF-FF1\uff0c0\uff09+CS\uff09\uff0cCOLOR00FFFF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08521\uff0c13\uff0cNUMTOSTRN\uff08OO\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLOR0000FF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08521\uff0c24\uff0cNUMTOSTRN\uff08OO1\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLORFFFF00\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08521\uff0c35\uff0cNUMTOSTRN\uff08OO-OO1\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLOR00FFFF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08558\uff0c13\uff0cNUMTOSTRN\uff08GG\uff0c0\uff09+CS\uff09\uff0cCOLOR0000FF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08558\uff0c24\uff0cNUMTOSTRN\uff08GG1\uff0c0\uff09+CS\uff09\uff0cCOLORFFFF00\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08558\uff0c35\uff0cNUMTOSTRN\uff08GG-GG1\uff0c0\uff09+CS\uff09\uff0cCOLOR00FFFF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08608\uff0c13\uff0cNUMTOSTRN\uff08PP\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLOR0000FF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08608\uff0c24\uff0cNUMTOSTRN\uff08PP1\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLORFFFF00\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08608\uff0c35\uff0cNUMTOSTRN\uff08PP-PP1\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLOR00FFFF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08645\uff0c13\uff0cNUMTOSTRN\uff08HH\uff0c0\uff09+CS\uff09\uff0cCOLOR0000FF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08645\uff0c24\uff0cNUMTOSTRN\uff08HH1\uff0c0\uff09+CS\uff09\uff0cCOLORFFFF00\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08645\uff0c35\uff0cNUMTOSTRN\uff08HH-HH1\uff0c0\uff09+CS\uff09\uff0cCOLOR00FFFF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08695\uff0c13\uff0cNUMTOSTRN\uff08QQ\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLOR0000FF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08695\uff0c24\uff0cNUMTOSTRN\uff08QQ1\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLORFFFF00\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08695\uff0c35\uff0cNUMTOSTRN\uff08QQ-QQ1\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLOR00FFFF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWRECTABS\uff08767\uff0c2\uff0c767+RZB\uff0c12\uff0cRGB\uff08255\uff0c30\uff0c30\uff09\uff09\uff0cCOLORFFFFFF;<\/p>\n<p> \u3000\u3000DRAWRECTABS\uff08767\uff0c2\uff0c767-CZB\uff0c12\uff0cRGB\uff0830\uff0c30\uff0c255\uff09\uff09\uff0cCOLORFFFFFF;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08733\uff0c1\uff0cNUMTOSTRN\uff08CZB\uff0c2\uff09+\u2018%\u2019\uff09\uff0cALIGN2\uff0cCOLOR00FFFF;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08837\uff0c1\uff0cNUMTOSTRN\uff08RZB\uff0c2\uff09+\u2018%\u2019\uff09\uff0cALIGN2\uff0cCOLOR00FFFF;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08740\uff0c13\uff0cNUMTOSTRN\uff08MR\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLOR4848FF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08740\uff0c24\uff0cNUMTOSTRN\uff08MC\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLOR48FF48\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08740\uff0c35\uff0cNUMTOSTRN\uff08JS\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLOREEEEEE\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08773\uff0c13\uff0cNUMTOSTRN\uff08MRB\uff0c0\uff09+\u2018\u7b14\u2019\uff09\uff0cCOLOR4848FF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08773\uff0c24\uff0cNUMTOSTRN\uff08MCB\uff0c0\uff09+\u2018\u7b14\u2019\uff09\uff0cCOLOR48FF48\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08773\uff0c35\uff0cNUMTOSTRN\uff08JB\uff0c0\uff09+\u2018\u7b14\u2019\uff09\uff0cCOLOREEEEEE\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08837\uff0c13\uff0cNUMTOSTRN\uff08RBG\uff0c0\uff09+\u2018\u80a1\/\u7b14\u2019\uff09\uff0cCOLOR4848FF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08837\uff0c24\uff0cNUMTOSTRN\uff08CBG\uff0c0\uff09+\u2018\u80a1\/\u7b14\u2019\uff09\uff0cCOLOR48FF48\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08837\uff0c35\uff0cNUMTOSTRN\uff08JC\uff0c0\uff09+\u2018\u80a1\/\u7b14\u2019\uff09\uff0cCOLOREEEEEE\uff0cALIGN2;<\/p>\n<p> \u3000\u3000{\u5927\u623730\u5206}<\/p>\n<p> \u3000\u3000input:N\uff081\uff0c1\uff0c2\uff09;<\/p>\n<p> \u3000\u3000TODAY\uff1a=\u201c\u5206\u65f6DDX.DDX\u7d2f\u79ef\u201d\u300a\u300b0;{\u5224\u65ad\u662f\u5426\u6709\u6b63\u7248\u6570\u636e}<\/p>\n<p> \u3000\u3000TODAY1\uff1a=\u201cLXDDX.DDX#day\u201d=0;{\u5224\u65ad\u662f\u5426\u6709\u96e8\u6768\u6570\u636e}<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08680\uff0c-12\uff0cIFS\uff08TODAY\uff0c\u2018\u6b63\u7248\u6570\u636e\u2019\uff0cIFS\uff08TODAY1\uff0c\u2018\u5f15\u5165\u6570\u636e\u2019\uff0c\u2018\u96e8\u6768\u6570\u636e \u2019\uff09\uff09\uff09\uff0cLINETHICK1\uff0ccolorwhite;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08752\uff0c-12\uff0cIFS\uff08N=1\uff0c\u2018\u9010\u5355\u2019\uff0c\u2018\u9010\u7b14\u2019\uff09\uff09\uff0cLINETHICK1\uff0ccolorwhite;<\/p>\n<p> \u3000\u3000ZT1\uff1a=\u201cwd.o12\u201d-\u201cwd.o13\u201d{ORDERVOL\uff081\uff0c2\uff09-ORDERVOL\uff081\uff0c3\uff09};<\/p>\n<p> \u3000\u3000YT1\u7d2f\u79ef\uff1a=\uff08\u201cDDEDATA@BIGORDERSCALE\u201d\uff081\uff0c2\uff09-\u201cDDEDATA@BIGORDERSCALE\u201d \uff081\uff0c3\uff09\uff09*SUM\uff08VOL\uff0c0\uff09;<\/p>\n<p> \u3000\u3000YT1\uff1a=YT1\u7d2f\u79ef-REF\uff08YT1\u7d2f\u79ef\uff0c1\uff09;<\/p>\n<p> \u3000\u3000RT1\u7d2f\u79ef\uff1a=\u201cwd.\u5927\u5355\u4e70#day\u201d*SUM\uff08VOL\uff0c0\uff09;<\/p>\n<p> \u3000\u3000RT1\uff1a=RT1\u7d2f\u79ef-REF\uff08RT1\u7d2f\u79ef\uff0c1\uff09;<\/p>\n<p> \u3000\u3000T1\uff1a=IF\uff08TODAY\uff0cZT1\uff0cIF\uff08TODAY1\uff0cRT1\uff0cYT1\uff09\uff09;<\/p>\n<p> \u3000\u3000T2\uff1a=\u201cwd.t12\u201d-\u201cwd.t13\u201d{TRANSACTVOL\uff081\uff0c2\uff09-TRANSACTVOL\uff081\uff0c3\uff09};<\/p>\n<p> \u3000\u3000ZT3\uff1a=\u201cwd.o22\u201d-\u201cwd.o23\u201d{ORDERVOL\uff082\uff0c2\uff09-ORDERVOL\uff082\uff0c3\uff09};<\/p>\n<p> \u3000\u3000YT3\u7d2f\u79ef\uff1a=\uff08\u201cDDEDATA@BIGORDERSCALE\u201d\uff082\uff0c2\uff09-\u201cDDEDATA@BIGORDERSCALE\u201d \uff082\uff0c3\uff09\uff09*SUM\uff08VOL\uff0c0\uff09;<\/p>\n<p> \u3000\u3000YT3\uff1a=YT3\u7d2f\u79ef-REF\uff08YT3\u7d2f\u79ef\uff0c1\uff09;<\/p>\n<p> \u3000\u3000RT3\u7d2f\u79ef\uff1a=\u201cwd.\u5927\u5355\u5356#day\u201d*SUM\uff08VOL\uff0c0\uff09;<\/p>\n<p> \u3000\u3000RT3\uff1a=RT3\u7d2f\u79ef-REF\uff08RT3\u7d2f\u79ef\uff0c1\uff09;<\/p>\n<p> \u3000\u3000T3\uff1a=IF\uff08TODAY\uff0cZT3\uff0cIF\uff08TODAY1\uff0cRT3\uff0cYT3\uff09\uff09;<\/p>\n<p> \u3000\u3000T4\uff1a=\u201cwd.t22\u201d-\u201cwd.t23\u201d{TRANSACTVOL\uff082\uff0c2\uff09-TRANSACTVOL\uff082\uff0c3\uff09};<\/p>\n<p> \u3000\u3000ZS1\uff1a=\u201cwd.d12\u201d-\u201cwd.d13\u201d{ORDERNUM\uff081\uff0c2\uff09-ORDERNUM\uff081\uff0c3\uff09};<\/p>\n<p> \u3000\u3000YS1\uff1a=\u201cDDEDATA@BIGORDERSCALE\u201d\uff081\uff0c2\uff09-\u201cDDEDATA@BIGORDERSCALE\u201d\uff081\uff0c3\uff09;<\/p>\n<p> \u3000\u3000RS1\uff1a=\u201cwd.\u5927\u5355\u4e70#day\u201d;<\/p>\n<p> \u3000\u3000S1\uff1a=IF\uff08TODAY\uff0cZS1\uff0cIF\uff08TODAY1\uff0cRS1\uff0cYS1\uff09\uff09;<\/p>\n<p> \u3000\u3000S2\uff1a=\u201cwd.l12\u201d-\u201cwd.l13\u201d{TRANSACTNUM\uff081\uff0c2\uff09-TRANSACTNUM\uff081\uff0c3\uff09};<\/p>\n<p> \u3000\u3000ZS3\uff1a=\u201cwd.d22\u201d-\u201cwd.d23\u201d{ORDERNUM\uff082\uff0c2\uff09-ORDERNUM\uff082\uff0c3\uff09};<\/p>\n<p> \u3000\u3000YS3\uff1a=\u201cDDEDATA@BIGORDERSCALE\u201d\uff082\uff0c2\uff09-\u201cDDEDATA@BIGORDERSCALE\u201d\uff082\uff0c3\uff09;<\/p>\n<p> \u3000\u3000RS3\uff1a=\u201cwd.\u5927\u5355\u5356#day\u201d;<\/p>\n<p> \u3000\u3000S3\uff1a=IF\uff08TODAY\uff0cZS3\uff0cIF\uff08TODAY1\uff0cRS3\uff0cYS3\uff09\uff09;<\/p>\n<p> \u3000\u3000S4\uff1a=\u201cwd.l22\u201d-\u201cwd.l23\u201d{TRANSACTNUM\uff082\uff0c2\uff09-TRANSACTNUM\uff082\uff0c3\uff09};<\/p>\n<p> \u3000\u3000M1\uff1a=TIME\u300a=100000;<\/p>\n<p> \u3000\u3000M2\uff1a=TIME\u300a=103000 AND TIME\u300b100000;<\/p>\n<p> \u3000\u3000M3\uff1a=TIME\u300a=110000 AND TIME\u300b103000;<\/p>\n<p> \u3000\u3000M4\uff1a=TIME\u300a=113000 AND TIME\u300b110000;<\/p>\n<p> \u3000\u3000M5\uff1a=TIME\u300a=133000 AND TIME\u300b130000;<\/p>\n<p> \u3000\u3000M6\uff1a=TIME\u300a=140000 AND TIME\u300b133000;<\/p>\n<p> \u3000\u3000M7\uff1a=TIME\u300a=143000 AND TIME\u300b140000;<\/p>\n<p> \u3000\u3000M8\uff1a=TIME\u300a=150000 AND TIME\u300b143000;<\/p>\n<p> \u3000\u3000{\u6570\u636e1\u5927\u4e70}<\/p>\n<p> \u3000\u3000A1\uff1a=IF\uff08M1\uff0cS1\uff0c0\uff09;<\/p>\n<p> \u3000\u3000A2\uff1a=IF\uff08M1\uff0cS2\uff0c0\uff09;<\/p>\n<p> \u3000\u3000AA\uff1a=SUM\uff08IF\uff08N=1\uff0cA1\uff0cA2\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000B1\uff1a=IF\uff08M2\uff0cS1\uff0c0\uff09;<\/p>\n<p> \u3000\u3000B2\uff1a=IF\uff08M2\uff0cS2\uff0c0\uff09;<\/p>\n<p> \u3000\u3000BB\uff1a=SUM\uff08IF\uff08N=1\uff0cB1\uff0cB2\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000C1\uff1a=IF\uff08M3\uff0cS1\uff0c0\uff09;<\/p>\n<p> \u3000\u3000C2\uff1a=IF\uff08M3\uff0cS2\uff0c0\uff09;<\/p>\n<p> \u3000\u3000CC\uff1a=SUM\uff08IF\uff08N=1\uff0cC1\uff0cC2\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000D1\uff1a=IF\uff08M4\uff0cS1\uff0c0\uff09;<\/p>\n<p> \u3000\u3000D2\uff1a=IF\uff08M4\uff0cS2\uff0c0\uff09;<\/p>\n<p> \u3000\u3000DD\uff1a=SUM\uff08IF\uff08N=1\uff0cD1\uff0cD2\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000E1\uff1a=IF\uff08M5\uff0cS1\uff0c0\uff09;<\/p>\n<p> \u3000\u3000E2\uff1a=IF\uff08M5\uff0cS2\uff0c0\uff09;<\/p>\n<p> \u3000\u3000EE\uff1a=SUM\uff08IF\uff08N=1\uff0cE1\uff0cE2\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000F1\uff1a=IF\uff08M6\uff0cS1\uff0c0\uff09;<\/p>\n<p> \u3000\u3000F2\uff1a=IF\uff08M6\uff0cS2\uff0c0\uff09;<\/p>\n<p> \u3000\u3000FF\uff1a=SUM\uff08IF\uff08N=1\uff0cF1\uff0cF2\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000G1\uff1a=IF\uff08M7\uff0cS1\uff0c0\uff09;<\/p>\n<p> \u3000\u3000G2\uff1a=IF\uff08M7\uff0cS2\uff0c0\uff09;<\/p>\n<p> \u3000\u3000GG\uff1a=SUM\uff08IF\uff08N=1\uff0cG1\uff0cG2\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000H1\uff1a=IF\uff08M8\uff0cS1\uff0c0\uff09;<\/p>\n<p> \u3000\u3000H2\uff1a=IF\uff08M8\uff0cS2\uff0c0\uff09;<\/p>\n<p> \u3000\u3000HH\uff1a=SUM\uff08IF\uff08N=1\uff0cH1\uff0cH2\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000I1\uff1a=IF\uff08M1\uff0cT1\uff0c0\uff09;<\/p>\n<p> \u3000\u3000I2\uff1a=IF\uff08M1\uff0cT2\uff0c0\uff09;<\/p>\n<p> \u3000\u3000II\uff1a=SUM\uff08IF\uff08N=1\uff0cI1\uff0cI2\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000J1\uff1a=IF\uff08M2\uff0cT1\uff0c0\uff09;<\/p>\n<p> \u3000\u3000J2\uff1a=IF\uff08M2\uff0cT2\uff0c0\uff09;<\/p>\n<p> \u3000\u3000JJ\uff1a=SUM\uff08IF\uff08N=1\uff0cJ1\uff0cJ2\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000K1\uff1a=IF\uff08M3\uff0cT1\uff0c0\uff09;<\/p>\n<p> \u3000\u3000K2\uff1a=IF\uff08M3\uff0cT2\uff0c0\uff09;<\/p>\n<p> \u3000\u3000KK\uff1a=SUM\uff08IF\uff08N=1\uff0cK1\uff0cK2\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000L1\uff1a=IF\uff08M4\uff0cT1\uff0c0\uff09;<\/p>\n<p> \u3000\u3000L2\uff1a=IF\uff08M4\uff0cT2\uff0c0\uff09;<\/p>\n<p> \u3000\u3000LL\uff1a=SUM\uff08IF\uff08N=1\uff0cL1\uff0cL2\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000N1\uff1a=IF\uff08M5\uff0cT1\uff0c0\uff09;<\/p>\n<p> \u3000\u3000N2\uff1a=IF\uff08M5\uff0cT2\uff0c0\uff09;<\/p>\n<p> \u3000\u3000NN\uff1a=SUM\uff08IF\uff08N=1\uff0cN1\uff0cN2\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000O1\uff1a=IF\uff08M6\uff0cT1\uff0c0\uff09;<\/p>\n<p> \u3000\u3000O2\uff1a=IF\uff08M6\uff0cT2\uff0c0\uff09;<\/p>\n<p> \u3000\u3000OO\uff1a=SUM\uff08IF\uff08N=1\uff0cO1\uff0cO2\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000P1\uff1a=IF\uff08M7\uff0cT1\uff0c0\uff09;<\/p>\n<p> \u3000\u3000P2\uff1a=IF\uff08M7\uff0cT2\uff0c0\uff09;<\/p>\n<p> \u3000\u3000PP\uff1a=SUM\uff08IF\uff08N=1\uff0cP1\uff0cP2\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000Q1\uff1a=IF\uff08M8\uff0cT1\uff0c0\uff09;<\/p>\n<p> \u3000\u3000Q2\uff1a=IF\uff08M8\uff0cT2\uff0c0\uff09;<\/p>\n<p> \u3000\u3000QQ\uff1a=SUM\uff08IF\uff08N=1\uff0cQ1\uff0cQ2\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000{\u6570\u636e2\u5927\u5356}<\/p>\n<p> \u3000\u3000A3\uff1a=IF\uff08M1\uff0cS3\uff0c0\uff09;<\/p>\n<p> \u3000\u3000A4\uff1a=IF\uff08M1\uff0cS4\uff0c0\uff09;<\/p>\n<p> \u3000\u3000AA1\uff1a=SUM\uff08IF\uff08N=1\uff0cA3\uff0cA4\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000B3\uff1a=IF\uff08M2\uff0cS3\uff0c0\uff09;<\/p>\n<p> \u3000\u3000B4\uff1a=IF\uff08M2\uff0cS4\uff0c0\uff09;<\/p>\n<p> \u3000\u3000BB1\uff1a=SUM\uff08IF\uff08N=1\uff0cB3\uff0cB4\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000C3\uff1a=IF\uff08M3\uff0cS3\uff0c0\uff09;<\/p>\n<p> \u3000\u3000C4\uff1a=IF\uff08M3\uff0cS4\uff0c0\uff09;<\/p>\n<p> \u3000\u3000CC1\uff1a=SUM\uff08IF\uff08N=1\uff0cC3\uff0cC4\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000D3\uff1a=IF\uff08M4\uff0cS3\uff0c0\uff09;<\/p>\n<p> \u3000\u3000D4\uff1a=IF\uff08M4\uff0cS4\uff0c0\uff09;<\/p>\n<p> \u3000\u3000DD1\uff1a=SUM\uff08IF\uff08N=1\uff0cD3\uff0cD4\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000E3\uff1a=IF\uff08M5\uff0cS3\uff0c0\uff09;<\/p>\n<p> \u3000\u3000E4\uff1a=IF\uff08M5\uff0cS4\uff0c0\uff09;<\/p>\n<p> \u3000\u3000EE1\uff1a=SUM\uff08IF\uff08N=1\uff0cE3\uff0cE4\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000F3\uff1a=IF\uff08M6\uff0cS3\uff0c0\uff09;<\/p>\n<p> \u3000\u3000F4\uff1a=IF\uff08M6\uff0cS4\uff0c0\uff09;<\/p>\n<p> \u3000\u3000FF1\uff1a=SUM\uff08IF\uff08N=1\uff0cF3\uff0cF4\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000G3\uff1a=IF\uff08M7\uff0cS3\uff0c0\uff09;<\/p>\n<p> \u3000\u3000G4\uff1a=IF\uff08M7\uff0cS4\uff0c0\uff09;<\/p>\n<p> \u3000\u3000GG1\uff1a=SUM\uff08IF\uff08N=1\uff0cG3\uff0cG4\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000H3\uff1a=IF\uff08M8\uff0cS3\uff0c0\uff09;<\/p>\n<p> \u3000\u3000H4\uff1a=IF\uff08M8\uff0cS4\uff0c0\uff09;<\/p>\n<p> \u3000\u3000HH1\uff1a=SUM\uff08IF\uff08N=1\uff0cH3\uff0cH4\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000I3\uff1a=IF\uff08M1\uff0cT3\uff0c0\uff09;<\/p>\n<p> \u3000\u3000I4\uff1a=IF\uff08M1\uff0cT4\uff0c0\uff09;<\/p>\n<p> \u3000\u3000II1\uff1a=SUM\uff08IF\uff08N=1\uff0cI3\uff0cI4\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000J3\uff1a=IF\uff08M2\uff0cT3\uff0c0\uff09;<\/p>\n<p> \u3000\u3000J4\uff1a=IF\uff08M2\uff0cT4\uff0c0\uff09;<\/p>\n<p> \u3000\u3000JJ1\uff1a=SUM\uff08IF\uff08N=1\uff0cJ3\uff0cJ4\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000K3\uff1a=IF\uff08M3\uff0cT3\uff0c0\uff09;<\/p>\n<p> \u3000\u3000K4\uff1a=IF\uff08M3\uff0cT4\uff0c0\uff09;<\/p>\n<p> \u3000\u3000KK1\uff1a=SUM\uff08IF\uff08N=1\uff0cK3\uff0cK4\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000L3\uff1a=IF\uff08M4\uff0cT3\uff0c0\uff09;<\/p>\n<p> \u3000\u3000L4\uff1a=IF\uff08M4\uff0cT4\uff0c0\uff09;<\/p>\n<p> \u3000\u3000LL1\uff1a=SUM\uff08IF\uff08N=1\uff0cL3\uff0cL4\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000N3\uff1a=IF\uff08M5\uff0cT3\uff0c0\uff09;<\/p>\n<p> \u3000\u3000N4\uff1a=IF\uff08M5\uff0cT4\uff0c0\uff09;<\/p>\n<p> \u3000\u3000NN1\uff1a=SUM\uff08IF\uff08N=1\uff0cN3\uff0cN4\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000O3\uff1a=IF\uff08M6\uff0cT3\uff0c0\uff09;<\/p>\n<p> \u3000\u3000O4\uff1a=IF\uff08M6\uff0cT4\uff0c0\uff09;<\/p>\n<p> \u3000\u3000OO1\uff1a=SUM\uff08IF\uff08N=1\uff0cO3\uff0cO4\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000P3\uff1a=IF\uff08M7\uff0cT3\uff0c0\uff09;<\/p>\n<p> \u3000\u3000P4\uff1a=IF\uff08M7\uff0cT4\uff0c0\uff09;<\/p>\n<p> \u3000\u3000PP1\uff1a=SUM\uff08IF\uff08N=1\uff0cP3\uff0cP4\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000Q3\uff1a=IF\uff08M8\uff0cT3\uff0c0\uff09;<\/p>\n<p> \u3000\u3000Q4\uff1a=IF\uff08M8\uff0cT4\uff0c0\uff09;<\/p>\n<p> \u3000\u3000QQ1\uff1a=SUM\uff08IF\uff08N=1\uff0cQ3\uff0cQ4\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000{\u6570\u636e3\u603b\u4e70\u603b\u5356\u5dee}<\/p>\n<p> \u3000\u3000MR\uff1a=IF\uff08N=1\uff0cSUM\uff08T1\uff0c0\uff09\uff0cSUM\uff08T2\uff0c0\uff09\uff09;<\/p>\n<p> \u3000\u3000MC\uff1a=IF\uff08N=1\uff0cSUM\uff08T3\uff0c0\uff09\uff0cSUM\uff08T4\uff0c0\uff09\uff09;<\/p>\n<p> \u3000\u3000MRE\uff1a=MR*DYNAINFO\uff0811\uff09*100\/10000;<\/p>\n<p> \u3000\u3000MCE\uff1a=MC*DYNAINFO\uff0811\uff09*100\/10000;<\/p>\n<p> \u3000\u3000\u6d41\u5165\u8d44\u91d1\uff1aMRE\uff0cCOLOR0000FF\uff0clinethick0\uff0cPRECIS2;<\/p>\n<p> \u3000\u3000\u6d41\u51fa\u8d44\u91d1\uff1aMCE\uff0cCOLORFFFF00\uff0clinethick0\uff0cPRECIS2;<\/p>\n<p> \u3000\u3000MRB\uff1a=IF\uff08N=1\uff0cSUM\uff08S1\uff0c0\uff09\uff0cSUM\uff08S2\uff0c0\uff09\uff09;<\/p>\n<p> \u3000\u3000MCB\uff1a=IF\uff08N=1\uff0cSUM\uff08S3\uff0c0\uff09\uff0cSUM\uff08S4\uff0c0\uff09\uff09;<\/p>\n<p> \u3000\u3000RBG\uff1a=MR*100\/MRB;<\/p>\n<p> \u3000\u3000CBG\uff1a=MC*100\/MCB;<\/p>\n<p> \u3000\u3000JS\uff1a=MR-MC;<\/p>\n<p> \u3000\u3000JE\uff1a=MRE-MCE;<\/p>\n<p> \u3000\u3000\u51c0\u8d44\u91d1\uff1aJE\uff0cCOLOR00FFFF\uff0clinethick0\uff0cPRECIS2;<\/p>\n<p> \u3000\u3000JB\uff1a=MRB-MCB;<\/p>\n<p> \u3000\u3000JC\uff1a=RBG-CBG;<\/p>\n<p> \u3000\u3000RZB\uff1a=MR\/DYNAINFO\uff088\uff09*100;<\/p>\n<p> \u3000\u3000CZB\uff1a=MC\/DYNAINFO\uff088\uff09*100;<\/p>\n<p> \u3000\u3000MR1\uff1a=IF\uff08N=1\uff0cT1\uff0cT2\uff09;<\/p>\n<p> \u3000\u3000MC1\uff1a=IF\uff08N=1\uff0cT3\uff0cT4\uff09;<\/p>\n<p> \u3000\u3000ZMX\uff1a=\uff08MR1-MC1\uff09\/DYNAINFO\uff088\uff09*100;<\/p>\n<p> \u3000\u3000CS\uff1a=IFS\uff08N=1\uff0c\u2018\u5355\u2019\uff0c\u2018\u7b14\u2019\uff09;<\/p>\n<p> \u3000\u3000{\u8868\u683c}<\/p>\n<p> \u3000\u3000DRAWRECTABS\uff080\uff0c0\uff0c838\uff0c48\uff0cRGB\uff081\uff0c1\uff0c1\uff09\uff09\uff0cCOLOR0000C0;<\/p>\n<p> \u3000\u3000DRAWRECTABS\uff080\uff0c0\uff0c696\uff0c13\uff0cRGB\uff08210\uff0c150\uff0c0\uff09\uff09\uff0cCOLOR0096D2;<\/p>\n<p> \u3000\u3000DRAWRECTABS\uff08696\uff0c0\uff0c838\uff0c13\uff0cRGB\uff08210\uff0c100\uff0c0\uff09\uff09\uff0cCOLOR0064D2;<\/p>\n<p> \u3000\u3000DRAWRECTABS\uff080\uff0c0\uff0c87\uff0c48\uff0c0\uff09\uff0cCOLOR0000C0;<\/p>\n<p> \u3000\u3000DRAWRECTABS\uff080\uff0c0\uff0c174\uff0c48\uff0c0\uff09\uff0cCOLOR0000C0;<\/p>\n<p> \u3000\u3000DRAWRECTABS\uff080\uff0c0\uff0c261\uff0c48\uff0c0\uff09\uff0cCOLOR0000C0;<\/p>\n<p> \u3000\u3000DRAWRECTABS\uff080\uff0c0\uff0c348\uff0c48\uff0c0\uff09\uff0cCOLOR0000C0;<\/p>\n<p> \u3000\u3000DRAWRECTABS\uff080\uff0c0\uff0c435\uff0c48\uff0c0\uff09\uff0cCOLOR0000C0;<\/p>\n<p> \u3000\u3000DRAWRECTABS\uff080\uff0c0\uff0c522\uff0c48\uff0c0\uff09\uff0cCOLOR0000C0;<\/p>\n<p> \u3000\u3000DRAWRECTABS\uff080\uff0c0\uff0c609\uff0c48\uff0c0\uff09\uff0cCOLOR0000C0;<\/p>\n<p> \u3000\u3000DRAWRECTABS\uff080\uff0c0\uff0c696\uff0c48\uff0c0\uff09\uff0cCOLOR0000C0;<\/p>\n<p> \u3000\u3000DRAWRECTABS\uff080\uff0c0\uff0c838\uff0c48\uff0c0\uff09\uff0cCOLOR0000C0;<\/p>\n<p> \u3000\u3000{\u663e\u793a\u6587\u5b57\u6570\u5b57}<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff0815\uff0c1\uff0c\u20189:30-10:00 10:00-10:30 10:30-11:00 11:00-11:30 13:00-13:30 13:30-14:00 14:00-14:30 14:30-15:00 \u2019\uff09\uff0cCOLORFFFFFF;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff0836\uff0c13\uff0cNUMTOSTRN\uff08AA\uff0c0\uff09+CS\uff09\uff0cCOLOR0000FF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff0836\uff0c24\uff0cNUMTOSTRN\uff08AA1\uff0c0\uff09+CS\uff09\uff0cCOLORFFFF00\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff0836\uff0c35\uff0cNUMTOSTRN\uff08AA-AA1\uff0c0\uff09+CS\uff09\uff0cCOLOR00FFFF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff0886\uff0c13\uff0cNUMTOSTRN\uff08II\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLOR0000FF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff0886\uff0c24\uff0cNUMTOSTRN\uff08II1\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLORFFFF00\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff0886\uff0c35\uff0cNUMTOSTRN\uff08II-II1\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLOR00FFFF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08123\uff0c13\uff0cNUMTOSTRN\uff08BB\uff0c0\uff09+CS\uff09\uff0cCOLOR0000FF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08123\uff0c24\uff0cNUMTOSTRN\uff08BB1\uff0c0\uff09+CS\uff09\uff0cCOLORFFFF00\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08123\uff0c35\uff0cNUMTOSTRN\uff08BB-BB1\uff0c0\uff09+CS\uff09\uff0cCOLOR00FFFF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08173\uff0c13\uff0cNUMTOSTRN\uff08JJ\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLOR0000FF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08173\uff0c24\uff0cNUMTOSTRN\uff08JJ1\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLORFFFF00\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08173\uff0c35\uff0cNUMTOSTRN\uff08JJ-JJ1\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLOR00FFFF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08210\uff0c13\uff0cNUMTOSTRN\uff08CC\uff0c0\uff09+CS\uff09\uff0cCOLOR0000FF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08210\uff0c24\uff0cNUMTOSTRN\uff08CC1\uff0c0\uff09+CS\uff09\uff0cCOLORFFFF00\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08210\uff0c35\uff0cNUMTOSTRN\uff08CC-CC1\uff0c0\uff09+CS\uff09\uff0cCOLOR00FFFF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08260\uff0c13\uff0cNUMTOSTRN\uff08KK\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLOR0000FF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08260\uff0c24\uff0cNUMTOSTRN\uff08KK1\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLORFFFF00\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08260\uff0c35\uff0cNUMTOSTRN\uff08KK-KK1\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLOR00FFFF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08297\uff0c13\uff0cNUMTOSTRN\uff08DD\uff0c0\uff09+CS\uff09\uff0cCOLOR0000FF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08297\uff0c24\uff0cNUMTOSTRN\uff08DD1\uff0c0\uff09+CS\uff09\uff0cCOLORFFFF00\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08297\uff0c35\uff0cNUMTOSTRN\uff08DD-DD1\uff0c0\uff09+CS\uff09\uff0cCOLOR00FFFF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08347\uff0c13\uff0cNUMTOSTRN\uff08LL\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLOR0000FF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08347\uff0c24\uff0cNUMTOSTRN\uff08LL1\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLORFFFF00\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08347\uff0c35\uff0cNUMTOSTRN\uff08LL-LL1\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLOR00FFFF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08384\uff0c13\uff0cNUMTOSTRN\uff08EE\uff0c0\uff09+CS\uff09\uff0cCOLOR0000FF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08384\uff0c24\uff0cNUMTOSTRN\uff08EE1\uff0c0\uff09+CS\uff09\uff0cCOLORFFFF00\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08384\uff0c35\uff0cNUMTOSTRN\uff08EE-EE1\uff0c0\uff09+CS\uff09\uff0cCOLOR00FFFF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08434\uff0c13\uff0cNUMTOSTRN\uff08NN\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLOR0000FF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08434\uff0c24\uff0cNUMTOSTRN\uff08NN1\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLORFFFF00\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08434\uff0c35\uff0cNUMTOSTRN\uff08NN-NN1\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLOR00FFFF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08471\uff0c13\uff0cNUMTOSTRN\uff08FF\uff0c0\uff09+CS\uff09\uff0cCOLOR0000FF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08471\uff0c24\uff0cNUMTOSTRN\uff08FF1\uff0c0\uff09+CS\uff09\uff0cCOLORFFFF00\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08471\uff0c35\uff0cNUMTOSTRN\uff08FF-FF1\uff0c0\uff09+CS\uff09\uff0cCOLOR00FFFF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08521\uff0c13\uff0cNUMTOSTRN\uff08OO\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLOR0000FF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08521\uff0c24\uff0cNUMTOSTRN\uff08OO1\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLORFFFF00\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08521\uff0c35\uff0cNUMTOSTRN\uff08OO-OO1\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLOR00FFFF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08558\uff0c13\uff0cNUMTOSTRN\uff08GG\uff0c0\uff09+CS\uff09\uff0cCOLOR0000FF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08558\uff0c24\uff0cNUMTOSTRN\uff08GG1\uff0c0\uff09+CS\uff09\uff0cCOLORFFFF00\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08558\uff0c35\uff0cNUMTOSTRN\uff08GG-GG1\uff0c0\uff09+CS\uff09\uff0cCOLOR00FFFF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08608\uff0c13\uff0cNUMTOSTRN\uff08PP\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLOR0000FF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08608\uff0c24\uff0cNUMTOSTRN\uff08PP1\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLORFFFF00\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08608\uff0c35\uff0cNUMTOSTRN\uff08PP-PP1\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLOR00FFFF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08645\uff0c13\uff0cNUMTOSTRN\uff08HH\uff0c0\uff09+CS\uff09\uff0cCOLOR0000FF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08645\uff0c24\uff0cNUMTOSTRN\uff08HH1\uff0c0\uff09+CS\uff09\uff0cCOLORFFFF00\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08645\uff0c35\uff0cNUMTOSTRN\uff08HH-HH1\uff0c0\uff09+CS\uff09\uff0cCOLOR00FFFF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08695\uff0c13\uff0cNUMTOSTRN\uff08QQ\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLOR0000FF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08695\uff0c24\uff0cNUMTOSTRN\uff08QQ1\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLORFFFF00\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08695\uff0c35\uff0cNUMTOSTRN\uff08QQ-QQ1\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLOR00FFFF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWRECTABS\uff08767\uff0c2\uff0c767+RZB\uff0c12\uff0cRGB\uff08255\uff0c30\uff0c30\uff09\uff09\uff0cCOLORFFFFFF;<\/p>\n<p> \u3000\u3000DRAWRECTABS\uff08767\uff0c2\uff0c767-CZB\uff0c12\uff0cRGB\uff0830\uff0c30\uff0c255\uff09\uff09\uff0cCOLORFFFFFF;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08733\uff0c1\uff0cNUMTOSTRN\uff08CZB\uff0c2\uff09+\u2018%\u2019\uff09\uff0cALIGN2\uff0cCOLOR00FFFF;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08837\uff0c1\uff0cNUMTOSTRN\uff08RZB\uff0c2\uff09+\u2018%\u2019\uff09\uff0cALIGN2\uff0cCOLOR00FFFF;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08740\uff0c13\uff0cNUMTOSTRN\uff08MR\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLOR4848FF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08740\uff0c24\uff0cNUMTOSTRN\uff08MC\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLOR48FF48\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08740\uff0c35\uff0cNUMTOSTRN\uff08JS\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLOREEEEEE\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08773\uff0c13\uff0cNUMTOSTRN\uff08MRB\uff0c0\uff09+\u2018\u7b14\u2019\uff09\uff0cCOLOR4848FF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08773\uff0c24\uff0cNUMTOSTRN\uff08MCB\uff0c0\uff09+\u2018\u7b14\u2019\uff09\uff0cCOLOR48FF48\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08773\uff0c35\uff0cNUMTOSTRN\uff08JB\uff0c0\uff09+\u2018\u7b14\u2019\uff09\uff0cCOLOREEEEEE\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08837\uff0c13\uff0cNUMTOSTRN\uff08RBG\uff0c0\uff09+\u2018\u80a1\/\u7b14\u2019\uff09\uff0cCOLOR4848FF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08837\uff0c24\uff0cNUMTOSTRN\uff08CBG\uff0c0\uff09+\u2018\u80a1\/\u7b14\u2019\uff09\uff0cCOLOR48FF48\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08837\uff0c35\uff0cNUMTOSTRN\uff08JC\uff0c0\uff09+\u2018\u80a1\/\u7b14\u2019\uff09\uff0cCOLOREEEEEE\uff0cALIGN2;<\/p>\n<p> \u3000\u3000{\u4e2d\u623730\u5206}<\/p>\n<p> \u3000\u3000input:N\uff081\uff0c1\uff0c2\uff09;<\/p>\n<p> \u3000\u3000TODAY\uff1a=\u201c\u5206\u65f6DDX.DDX\u7d2f\u79ef\u201d\u300a\u300b0;{\u5224\u65ad\u662f\u5426\u6709\u6b63\u7248\u6570\u636e}<\/p>\n<p> \u3000\u3000TODAY1\uff1a=\u201cLXDDX.DDX#day\u201d=0;{\u5224\u65ad\u662f\u5426\u6709\u96e8\u6768\u6570\u636e}<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08680\uff0c-12\uff0cIFS\uff08TODAY\uff0c\u2018\u6b63\u7248\u6570\u636e\u2019\uff0cIFS\uff08TODAY1\uff0c\u2018\u5f15\u5165\u6570\u636e\u2019\uff0c\u2018\u96e8\u6768\u6570\u636e \u2019\uff09\uff09\uff09\uff0cLINETHICK1\uff0ccolorwhite;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08752\uff0c-12\uff0cIFS\uff08N=1\uff0c\u2018\u9010\u5355\u2019\uff0c\u2018\u9010\u7b14\u2019\uff09\uff09\uff0cLINETHICK1\uff0ccolorwhite;<\/p>\n<p> \u3000\u3000ZT1\uff1a=\u201cwd.o11\u201d-\u201cwd.o12\u201d{ORDERVOL\uff081\uff0c1\uff09-ORDERVOL\uff081\uff0c2\uff09};<\/p>\n<p> \u3000\u3000YT1\u7d2f\u79ef\uff1a=\uff08\u201cDDEDATA@BIGORDERSCALE\u201d\uff081\uff0c1\uff09-\u201cDDEDATA@BIGORDERSCALE\u201d \uff081\uff0c2\uff09\uff09*SUM\uff08VOL\uff0c0\uff09;<\/p>\n<p> \u3000\u3000YT1\uff1a=YT1\u7d2f\u79ef-REF\uff08YT1\u7d2f\u79ef\uff0c1\uff09;<\/p>\n<p> \u3000\u3000RT1\u7d2f\u79ef\uff1a=\u201cwd.\u4e2d\u5355\u4e70#day\u201d*SUM\uff08VOL\uff0c0\uff09;<\/p>\n<p> \u3000\u3000RT1\uff1a=RT1\u7d2f\u79ef-REF\uff08RT1\u7d2f\u79ef\uff0c1\uff09;<\/p>\n<p> \u3000\u3000T1\uff1a=IF\uff08TODAY\uff0cZT1\uff0cIF\uff08TODAY1\uff0cRT1\uff0cYT1\uff09\uff09;<\/p>\n<p> \u3000\u3000T2\uff1a=\u201cwd.t11\u201d-\u201cwd.t12\u201d{TRANSACTVOL\uff081\uff0c1\uff09-TRANSACTVOL\uff081\uff0c2\uff09};<\/p>\n<p> \u3000\u3000ZT3\uff1a=\u201cwd.o21\u201d-\u201cwd.o22\u201d{ORDERVOL\uff082\uff0c1\uff09-ORDERVOL\uff082\uff0c2\uff09};<\/p>\n<p> \u3000\u3000YT3\u7d2f\u79ef\uff1a=\uff08\u201cDDEDATA@BIGORDERSCALE\u201d\uff082\uff0c1\uff09-\u201cDDEDATA@BIGORDERSCALE\u201d \uff082\uff0c2\uff09\uff09*SUM\uff08VOL\uff0c0\uff09;<\/p>\n<p> \u3000\u3000YT3\uff1a=YT3\u7d2f\u79ef-REF\uff08YT3\u7d2f\u79ef\uff0c1\uff09;<\/p>\n<p> \u3000\u3000RT3\u7d2f\u79ef\uff1a=\u201cwd.\u4e2d\u5355\u5356#day\u201d*SUM\uff08VOL\uff0c0\uff09;<\/p>\n<p> \u3000\u3000RT3\uff1a=RT3\u7d2f\u79ef-REF\uff08RT3\u7d2f\u79ef\uff0c1\uff09;<\/p>\n<p> \u3000\u3000T3\uff1a=IF\uff08TODAY\uff0cZT3\uff0cIF\uff08TODAY1\uff0cRT3\uff0cYT3\uff09\uff09;<\/p>\n<p> \u3000\u3000T4\uff1a=\u201cwd.t21\u201d-\u201cwd.t22\u201d{TRANSACTVOL\uff082\uff0c1\uff09-TRANSACTVOL\uff082\uff0c2\uff09};<\/p>\n<p> \u3000\u3000ZS1\uff1a=\u201cwd.d11\u201d-\u201cwd.d12\u201d{ORDERNUM\uff081\uff0c1\uff09-ORDERNUM\uff081\uff0c2\uff09};<\/p>\n<p> \u3000\u3000YS1\uff1a=\u201cDDEDATA@BIGORDERSCALE\u201d\uff081\uff0c1\uff09-\u201cDDEDATA@BIGORDERSCALE\u201d\uff081\uff0c2\uff09;<\/p>\n<p> \u3000\u3000RS1\uff1a=\u201cwd.\u4e2d\u5355\u4e70#day\u201d;<\/p>\n<p> \u3000\u3000S1\uff1a=IF\uff08TODAY\uff0cZS1\uff0cIF\uff08TODAY1\uff0cRS1\uff0cYS1\uff09\uff09;<\/p>\n<p> \u3000\u3000S2\uff1a=\u201cwd.l11\u201d-\u201cwd.l12\u201d{TRANSACTNUM\uff081\uff0c1\uff09-TRANSACTNUM\uff081\uff0c2\uff09};<\/p>\n<p> \u3000\u3000ZS3\uff1a=\u201cwd.d21\u201d-\u201cwd.d22\u201d{ORDERNUM\uff082\uff0c1\uff09-ORDERNUM\uff082\uff0c2\uff09};<\/p>\n<p> \u3000\u3000YS3\uff1a=\u201cDDEDATA@BIGORDERSCALE\u201d\uff082\uff0c1\uff09-\u201cDDEDATA@BIGORDERSCALE\u201d\uff082\uff0c2\uff09;<\/p>\n<p> \u3000\u3000RS3\uff1a=\u201cwd.\u4e2d\u5355\u5356#day\u201d;<\/p>\n<p> \u3000\u3000S3\uff1a=IF\uff08TODAY\uff0cZS3\uff0cIF\uff08TODAY1\uff0cRS3\uff0cYS3\uff09\uff09;<\/p>\n<p> \u3000\u3000S4\uff1a=\u201cwd.l21\u201d-\u201cwd.l22\u201d{TRANSACTNUM\uff082\uff0c1\uff09-TRANSACTNUM\uff082\uff0c2\uff09};<\/p>\n<p> \u3000\u3000M1\uff1a=TIME\u300a=100000;<\/p>\n<p> \u3000\u3000M2\uff1a=TIME\u300a=103000 AND TIME\u300b100000;<\/p>\n<p> \u3000\u3000M3\uff1a=TIME\u300a=110000 AND TIME\u300b103000;<\/p>\n<p> \u3000\u3000M4\uff1a=TIME\u300a=113000 AND TIME\u300b110000;<\/p>\n<p> \u3000\u3000M5\uff1a=TIME\u300a=133000 AND TIME\u300b130000;<\/p>\n<p> \u3000\u3000M6\uff1a=TIME\u300a=140000 AND TIME\u300b133000;<\/p>\n<p> \u3000\u3000M7\uff1a=TIME\u300a=143000 AND TIME\u300b140000;<\/p>\n<p> \u3000\u3000M8\uff1a=TIME\u300a=150000 AND TIME\u300b143000;<\/p>\n<p> \u3000\u3000{\u6570\u636e1\u5927\u4e70}<\/p>\n<p> \u3000\u3000A1\uff1a=IF\uff08M1\uff0cS1\uff0c0\uff09;<\/p>\n<p> \u3000\u3000A2\uff1a=IF\uff08M1\uff0cS2\uff0c0\uff09;<\/p>\n<p> \u3000\u3000AA\uff1a=SUM\uff08IF\uff08N=1\uff0cA1\uff0cA2\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000B1\uff1a=IF\uff08M2\uff0cS1\uff0c0\uff09;<\/p>\n<p> \u3000\u3000B2\uff1a=IF\uff08M2\uff0cS2\uff0c0\uff09;<\/p>\n<p> \u3000\u3000BB\uff1a=SUM\uff08IF\uff08N=1\uff0cB1\uff0cB2\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000C1\uff1a=IF\uff08M3\uff0cS1\uff0c0\uff09;<\/p>\n<p> \u3000\u3000C2\uff1a=IF\uff08M3\uff0cS2\uff0c0\uff09;<\/p>\n<p> \u3000\u3000CC\uff1a=SUM\uff08IF\uff08N=1\uff0cC1\uff0cC2\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000D1\uff1a=IF\uff08M4\uff0cS1\uff0c0\uff09;<\/p>\n<p> \u3000\u3000D2\uff1a=IF\uff08M4\uff0cS2\uff0c0\uff09;<\/p>\n<p> \u3000\u3000DD\uff1a=SUM\uff08IF\uff08N=1\uff0cD1\uff0cD2\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000E1\uff1a=IF\uff08M5\uff0cS1\uff0c0\uff09;<\/p>\n<p> \u3000\u3000E2\uff1a=IF\uff08M5\uff0cS2\uff0c0\uff09;<\/p>\n<p> \u3000\u3000EE\uff1a=SUM\uff08IF\uff08N=1\uff0cE1\uff0cE2\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000F1\uff1a=IF\uff08M6\uff0cS1\uff0c0\uff09;<\/p>\n<p> \u3000\u3000F2\uff1a=IF\uff08M6\uff0cS2\uff0c0\uff09;<\/p>\n<p> \u3000\u3000FF\uff1a=SUM\uff08IF\uff08N=1\uff0cF1\uff0cF2\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000G1\uff1a=IF\uff08M7\uff0cS1\uff0c0\uff09;<\/p>\n<p> \u3000\u3000G2\uff1a=IF\uff08M7\uff0cS2\uff0c0\uff09;<\/p>\n<p> \u3000\u3000GG\uff1a=SUM\uff08IF\uff08N=1\uff0cG1\uff0cG2\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000H1\uff1a=IF\uff08M8\uff0cS1\uff0c0\uff09;<\/p>\n<p> \u3000\u3000H2\uff1a=IF\uff08M8\uff0cS2\uff0c0\uff09;<\/p>\n<p> \u3000\u3000HH\uff1a=SUM\uff08IF\uff08N=1\uff0cH1\uff0cH2\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000I1\uff1a=IF\uff08M1\uff0cT1\uff0c0\uff09;<\/p>\n<p> \u3000\u3000I2\uff1a=IF\uff08M1\uff0cT2\uff0c0\uff09;<\/p>\n<p> \u3000\u3000II\uff1a=SUM\uff08IF\uff08N=1\uff0cI1\uff0cI2\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000J1\uff1a=IF\uff08M2\uff0cT1\uff0c0\uff09;<\/p>\n<p> \u3000\u3000J2\uff1a=IF\uff08M2\uff0cT2\uff0c0\uff09;<\/p>\n<p> \u3000\u3000JJ\uff1a=SUM\uff08IF\uff08N=1\uff0cJ1\uff0cJ2\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000K1\uff1a=IF\uff08M3\uff0cT1\uff0c0\uff09;<\/p>\n<p> \u3000\u3000K2\uff1a=IF\uff08M3\uff0cT2\uff0c0\uff09;<\/p>\n<p> \u3000\u3000KK\uff1a=SUM\uff08IF\uff08N=1\uff0cK1\uff0cK2\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000L1\uff1a=IF\uff08M4\uff0cT1\uff0c0\uff09;<\/p>\n<p> \u3000\u3000L2\uff1a=IF\uff08M4\uff0cT2\uff0c0\uff09;<\/p>\n<p> \u3000\u3000LL\uff1a=SUM\uff08IF\uff08N=1\uff0cL1\uff0cL2\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000N1\uff1a=IF\uff08M5\uff0cT1\uff0c0\uff09;<\/p>\n<p> \u3000\u3000N2\uff1a=IF\uff08M5\uff0cT2\uff0c0\uff09;<\/p>\n<p> \u3000\u3000NN\uff1a=SUM\uff08IF\uff08N=1\uff0cN1\uff0cN2\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000O1\uff1a=IF\uff08M6\uff0cT1\uff0c0\uff09;<\/p>\n<p> \u3000\u3000O2\uff1a=IF\uff08M6\uff0cT2\uff0c0\uff09;<\/p>\n<p> \u3000\u3000OO\uff1a=SUM\uff08IF\uff08N=1\uff0cO1\uff0cO2\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000P1\uff1a=IF\uff08M7\uff0cT1\uff0c0\uff09;<\/p>\n<p> \u3000\u3000P2\uff1a=IF\uff08M7\uff0cT2\uff0c0\uff09;<\/p>\n<p> \u3000\u3000PP\uff1a=SUM\uff08IF\uff08N=1\uff0cP1\uff0cP2\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000Q1\uff1a=IF\uff08M8\uff0cT1\uff0c0\uff09;<\/p>\n<p> \u3000\u3000Q2\uff1a=IF\uff08M8\uff0cT2\uff0c0\uff09;<\/p>\n<p> \u3000\u3000QQ\uff1a=SUM\uff08IF\uff08N=1\uff0cQ1\uff0cQ2\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000{\u6570\u636e2\u5927\u5356}<\/p>\n<p> \u3000\u3000A3\uff1a=IF\uff08M1\uff0cS3\uff0c0\uff09;<\/p>\n<p> \u3000\u3000A4\uff1a=IF\uff08M1\uff0cS4\uff0c0\uff09;<\/p>\n<p> \u3000\u3000AA1\uff1a=SUM\uff08IF\uff08N=1\uff0cA3\uff0cA4\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000B3\uff1a=IF\uff08M2\uff0cS3\uff0c0\uff09;<\/p>\n<p> \u3000\u3000B4\uff1a=IF\uff08M2\uff0cS4\uff0c0\uff09;<\/p>\n<p> \u3000\u3000BB1\uff1a=SUM\uff08IF\uff08N=1\uff0cB3\uff0cB4\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000C3\uff1a=IF\uff08M3\uff0cS3\uff0c0\uff09;<\/p>\n<p> \u3000\u3000C4\uff1a=IF\uff08M3\uff0cS4\uff0c0\uff09;<\/p>\n<p> \u3000\u3000CC1\uff1a=SUM\uff08IF\uff08N=1\uff0cC3\uff0cC4\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000D3\uff1a=IF\uff08M4\uff0cS3\uff0c0\uff09;<\/p>\n<p> \u3000\u3000D4\uff1a=IF\uff08M4\uff0cS4\uff0c0\uff09;<\/p>\n<p> \u3000\u3000DD1\uff1a=SUM\uff08IF\uff08N=1\uff0cD3\uff0cD4\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000E3\uff1a=IF\uff08M5\uff0cS3\uff0c0\uff09;<\/p>\n<p> \u3000\u3000E4\uff1a=IF\uff08M5\uff0cS4\uff0c0\uff09;<\/p>\n<p> \u3000\u3000EE1\uff1a=SUM\uff08IF\uff08N=1\uff0cE3\uff0cE4\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000F3\uff1a=IF\uff08M6\uff0cS3\uff0c0\uff09;<\/p>\n<p> \u3000\u3000F4\uff1a=IF\uff08M6\uff0cS4\uff0c0\uff09;<\/p>\n<p> \u3000\u3000FF1\uff1a=SUM\uff08IF\uff08N=1\uff0cF3\uff0cF4\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000G3\uff1a=IF\uff08M7\uff0cS3\uff0c0\uff09;<\/p>\n<p> \u3000\u3000G4\uff1a=IF\uff08M7\uff0cS4\uff0c0\uff09;<\/p>\n<p> \u3000\u3000GG1\uff1a=SUM\uff08IF\uff08N=1\uff0cG3\uff0cG4\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000H3\uff1a=IF\uff08M8\uff0cS3\uff0c0\uff09;<\/p>\n<p> \u3000\u3000H4\uff1a=IF\uff08M8\uff0cS4\uff0c0\uff09;<\/p>\n<p> \u3000\u3000HH1\uff1a=SUM\uff08IF\uff08N=1\uff0cH3\uff0cH4\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000I3\uff1a=IF\uff08M1\uff0cT3\uff0c0\uff09;<\/p>\n<p> \u3000\u3000I4\uff1a=IF\uff08M1\uff0cT4\uff0c0\uff09;<\/p>\n<p> \u3000\u3000II1\uff1a=SUM\uff08IF\uff08N=1\uff0cI3\uff0cI4\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000J3\uff1a=IF\uff08M2\uff0cT3\uff0c0\uff09;<\/p>\n<p> \u3000\u3000J4\uff1a=IF\uff08M2\uff0cT4\uff0c0\uff09;<\/p>\n<p> \u3000\u3000JJ1\uff1a=SUM\uff08IF\uff08N=1\uff0cJ3\uff0cJ4\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000K3\uff1a=IF\uff08M3\uff0cT3\uff0c0\uff09;<\/p>\n<p> \u3000\u3000K4\uff1a=IF\uff08M3\uff0cT4\uff0c0\uff09;<\/p>\n<p> \u3000\u3000KK1\uff1a=SUM\uff08IF\uff08N=1\uff0cK3\uff0cK4\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000L3\uff1a=IF\uff08M4\uff0cT3\uff0c0\uff09;<\/p>\n<p> \u3000\u3000L4\uff1a=IF\uff08M4\uff0cT4\uff0c0\uff09;<\/p>\n<p> \u3000\u3000LL1\uff1a=SUM\uff08IF\uff08N=1\uff0cL3\uff0cL4\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000N3\uff1a=IF\uff08M5\uff0cT3\uff0c0\uff09;<\/p>\n<p> \u3000\u3000N4\uff1a=IF\uff08M5\uff0cT4\uff0c0\uff09;<\/p>\n<p> \u3000\u3000NN1\uff1a=SUM\uff08IF\uff08N=1\uff0cN3\uff0cN4\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000O3\uff1a=IF\uff08M6\uff0cT3\uff0c0\uff09;<\/p>\n<p> \u3000\u3000O4\uff1a=IF\uff08M6\uff0cT4\uff0c0\uff09;<\/p>\n<p> \u3000\u3000OO1\uff1a=SUM\uff08IF\uff08N=1\uff0cO3\uff0cO4\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000P3\uff1a=IF\uff08M7\uff0cT3\uff0c0\uff09;<\/p>\n<p> \u3000\u3000P4\uff1a=IF\uff08M7\uff0cT4\uff0c0\uff09;<\/p>\n<p> \u3000\u3000PP1\uff1a=SUM\uff08IF\uff08N=1\uff0cP3\uff0cP4\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000Q3\uff1a=IF\uff08M8\uff0cT3\uff0c0\uff09;<\/p>\n<p> \u3000\u3000Q4\uff1a=IF\uff08M8\uff0cT4\uff0c0\uff09;<\/p>\n<p> \u3000\u3000QQ1\uff1a=SUM\uff08IF\uff08N=1\uff0cQ3\uff0cQ4\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000{\u6570\u636e3\u603b\u4e70\u603b\u5356\u5dee}<\/p>\n<p> \u3000\u3000MR\uff1a=IF\uff08N=1\uff0cSUM\uff08T1\uff0c0\uff09\uff0cSUM\uff08T2\uff0c0\uff09\uff09;<\/p>\n<p> \u3000\u3000MC\uff1a=IF\uff08N=1\uff0cSUM\uff08T3\uff0c0\uff09\uff0cSUM\uff08T4\uff0c0\uff09\uff09;<\/p>\n<p> \u3000\u3000MRE\uff1a=MR*DYNAINFO\uff0811\uff09*100\/10000;<\/p>\n<p> \u3000\u3000MCE\uff1a=MC*DYNAINFO\uff0811\uff09*100\/10000;<\/p>\n<p> \u3000\u3000\u6d41\u5165\u8d44\u91d1\uff1aMRE\uff0cCOLOR0000FF\uff0clinethick0\uff0cPRECIS2;<\/p>\n<p> \u3000\u3000\u6d41\u51fa\u8d44\u91d1\uff1aMCE\uff0cCOLORFFFF00\uff0clinethick0\uff0cPRECIS2;<\/p>\n<p> \u3000\u3000MRB\uff1a=IF\uff08N=1\uff0cSUM\uff08S1\uff0c0\uff09\uff0cSUM\uff08S2\uff0c0\uff09\uff09;<\/p>\n<p> \u3000\u3000MCB\uff1a=IF\uff08N=1\uff0cSUM\uff08S3\uff0c0\uff09\uff0cSUM\uff08S4\uff0c0\uff09\uff09;<\/p>\n<p> \u3000\u3000RBG\uff1a=MR*100\/MRB;<\/p>\n<p> \u3000\u3000CBG\uff1a=MC*100\/MCB;<\/p>\n<p> \u3000\u3000JS\uff1a=MR-MC;<\/p>\n<p> \u3000\u3000JE\uff1a=MRE-MCE;<\/p>\n<p> \u3000\u3000\u51c0\u8d44\u91d1\uff1aJE\uff0cCOLOR00FFFF\uff0clinethick0\uff0cPRECIS2;<\/p>\n<p> \u3000\u3000JB\uff1a=MRB-MCB;<\/p>\n<p> \u3000\u3000JC\uff1a=RBG-CBG;<\/p>\n<p> \u3000\u3000RZB\uff1a=MR\/DYNAINFO\uff088\uff09*100;<\/p>\n<p> \u3000\u3000CZB\uff1a=MC\/DYNAINFO\uff088\uff09*100;<\/p>\n<p> \u3000\u3000MR1\uff1a=IF\uff08N=1\uff0cT1\uff0cT2\uff09;<\/p>\n<p> \u3000\u3000MC1\uff1a=IF\uff08N=1\uff0cT3\uff0cT4\uff09;<\/p>\n<p> \u3000\u3000ZMX\uff1a=\uff08MR1-MC1\uff09\/DYNAINFO\uff088\uff09*100;<\/p>\n<p> \u3000\u3000CS\uff1a=IFS\uff08N=1\uff0c\u2018\u5355\u2019\uff0c\u2018\u7b14\u2019\uff09;<\/p>\n<p> \u3000\u3000{\u8868\u683c}<\/p>\n<p> \u3000\u3000DRAWRECTABS\uff080\uff0c0\uff0c838\uff0c48\uff0cRGB\uff081\uff0c1\uff0c1\uff09\uff09\uff0cCOLOR0000C0;<\/p>\n<p> \u3000\u3000DRAWRECTABS\uff080\uff0c0\uff0c696\uff0c13\uff0cRGB\uff08210\uff0c150\uff0c0\uff09\uff09\uff0cCOLOR0096D2;<\/p>\n<p> \u3000\u3000DRAWRECTABS\uff08696\uff0c0\uff0c838\uff0c13\uff0cRGB\uff08210\uff0c100\uff0c0\uff09\uff09\uff0cCOLOR0064D2;<\/p>\n<p> \u3000\u3000DRAWRECTABS\uff080\uff0c0\uff0c87\uff0c48\uff0c0\uff09\uff0cCOLOR0000C0;<\/p>\n<p> \u3000\u3000DRAWRECTABS\uff080\uff0c0\uff0c174\uff0c48\uff0c0\uff09\uff0cCOLOR0000C0;<\/p>\n<p> \u3000\u3000DRAWRECTABS\uff080\uff0c0\uff0c261\uff0c48\uff0c0\uff09\uff0cCOLOR0000C0;<\/p>\n<p> \u3000\u3000DRAWRECTABS\uff080\uff0c0\uff0c348\uff0c48\uff0c0\uff09\uff0cCOLOR0000C0;<\/p>\n<p> \u3000\u3000DRAWRECTABS\uff080\uff0c0\uff0c435\uff0c48\uff0c0\uff09\uff0cCOLOR0000C0;<\/p>\n<p> \u3000\u3000DRAWRECTABS\uff080\uff0c0\uff0c522\uff0c48\uff0c0\uff09\uff0cCOLOR0000C0;<\/p>\n<p> \u3000\u3000DRAWRECTABS\uff080\uff0c0\uff0c609\uff0c48\uff0c0\uff09\uff0cCOLOR0000C0;<\/p>\n<p> \u3000\u3000DRAWRECTABS\uff080\uff0c0\uff0c696\uff0c48\uff0c0\uff09\uff0cCOLOR0000C0;<\/p>\n<p> \u3000\u3000DRAWRECTABS\uff080\uff0c0\uff0c838\uff0c48\uff0c0\uff09\uff0cCOLOR0000C0;<\/p>\n<p> \u3000\u3000{\u663e\u793a\u6587\u5b57\u6570\u5b57}<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff0815\uff0c1\uff0c\u20189:30-10:00 10:00-10:30 10:30-11:00 11:00-11:30 13:00-13:30 13:30-14:00 14:00-14:30 14:30-15:00 \u2019\uff09\uff0cCOLORFFFFFF;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff0836\uff0c13\uff0cNUMTOSTRN\uff08AA\uff0c0\uff09+CS\uff09\uff0cCOLOR0000FF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff0836\uff0c24\uff0cNUMTOSTRN\uff08AA1\uff0c0\uff09+CS\uff09\uff0cCOLORFFFF00\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff0836\uff0c35\uff0cNUMTOSTRN\uff08AA-AA1\uff0c0\uff09+CS\uff09\uff0cCOLOR00FFFF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff0886\uff0c13\uff0cNUMTOSTRN\uff08II\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLOR0000FF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff0886\uff0c24\uff0cNUMTOSTRN\uff08II1\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLORFFFF00\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff0886\uff0c35\uff0cNUMTOSTRN\uff08II-II1\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLOR00FFFF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08123\uff0c13\uff0cNUMTOSTRN\uff08BB\uff0c0\uff09+CS\uff09\uff0cCOLOR0000FF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08123\uff0c24\uff0cNUMTOSTRN\uff08BB1\uff0c0\uff09+CS\uff09\uff0cCOLORFFFF00\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08123\uff0c35\uff0cNUMTOSTRN\uff08BB-BB1\uff0c0\uff09+CS\uff09\uff0cCOLOR00FFFF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08173\uff0c13\uff0cNUMTOSTRN\uff08JJ\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLOR0000FF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08173\uff0c24\uff0cNUMTOSTRN\uff08JJ1\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLORFFFF00\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08173\uff0c35\uff0cNUMTOSTRN\uff08JJ-JJ1\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLOR00FFFF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08210\uff0c13\uff0cNUMTOSTRN\uff08CC\uff0c0\uff09+CS\uff09\uff0cCOLOR0000FF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08210\uff0c24\uff0cNUMTOSTRN\uff08CC1\uff0c0\uff09+CS\uff09\uff0cCOLORFFFF00\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08210\uff0c35\uff0cNUMTOSTRN\uff08CC-CC1\uff0c0\uff09+CS\uff09\uff0cCOLOR00FFFF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08260\uff0c13\uff0cNUMTOSTRN\uff08KK\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLOR0000FF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08260\uff0c24\uff0cNUMTOSTRN\uff08KK1\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLORFFFF00\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08260\uff0c35\uff0cNUMTOSTRN\uff08KK-KK1\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLOR00FFFF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08297\uff0c13\uff0cNUMTOSTRN\uff08DD\uff0c0\uff09+CS\uff09\uff0cCOLOR0000FF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08297\uff0c24\uff0cNUMTOSTRN\uff08DD1\uff0c0\uff09+CS\uff09\uff0cCOLORFFFF00\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08297\uff0c35\uff0cNUMTOSTRN\uff08DD-DD1\uff0c0\uff09+CS\uff09\uff0cCOLOR00FFFF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08347\uff0c13\uff0cNUMTOSTRN\uff08LL\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLOR0000FF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08347\uff0c24\uff0cNUMTOSTRN\uff08LL1\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLORFFFF00\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08347\uff0c35\uff0cNUMTOSTRN\uff08LL-LL1\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLOR00FFFF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08384\uff0c13\uff0cNUMTOSTRN\uff08EE\uff0c0\uff09+CS\uff09\uff0cCOLOR0000FF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08384\uff0c24\uff0cNUMTOSTRN\uff08EE1\uff0c0\uff09+CS\uff09\uff0cCOLORFFFF00\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08384\uff0c35\uff0cNUMTOSTRN\uff08EE-EE1\uff0c0\uff09+CS\uff09\uff0cCOLOR00FFFF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08434\uff0c13\uff0cNUMTOSTRN\uff08NN\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLOR0000FF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08434\uff0c24\uff0cNUMTOSTRN\uff08NN1\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLORFFFF00\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08434\uff0c35\uff0cNUMTOSTRN\uff08NN-NN1\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLOR00FFFF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08471\uff0c13\uff0cNUMTOSTRN\uff08FF\uff0c0\uff09+CS\uff09\uff0cCOLOR0000FF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08471\uff0c24\uff0cNUMTOSTRN\uff08FF1\uff0c0\uff09+CS\uff09\uff0cCOLORFFFF00\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08471\uff0c35\uff0cNUMTOSTRN\uff08FF-FF1\uff0c0\uff09+CS\uff09\uff0cCOLOR00FFFF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08521\uff0c13\uff0cNUMTOSTRN\uff08OO\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLOR0000FF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08521\uff0c24\uff0cNUMTOSTRN\uff08OO1\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLORFFFF00\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08521\uff0c35\uff0cNUMTOSTRN\uff08OO-OO1\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLOR00FFFF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08558\uff0c13\uff0cNUMTOSTRN\uff08GG\uff0c0\uff09+CS\uff09\uff0cCOLOR0000FF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08558\uff0c24\uff0cNUMTOSTRN\uff08GG1\uff0c0\uff09+CS\uff09\uff0cCOLORFFFF00\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08558\uff0c35\uff0cNUMTOSTRN\uff08GG-GG1\uff0c0\uff09+CS\uff09\uff0cCOLOR00FFFF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08608\uff0c13\uff0cNUMTOSTRN\uff08PP\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLOR0000FF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08608\uff0c24\uff0cNUMTOSTRN\uff08PP1\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLORFFFF00\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08608\uff0c35\uff0cNUMTOSTRN\uff08PP-PP1\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLOR00FFFF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08645\uff0c13\uff0cNUMTOSTRN\uff08HH\uff0c0\uff09+CS\uff09\uff0cCOLOR0000FF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08645\uff0c24\uff0cNUMTOSTRN\uff08HH1\uff0c0\uff09+CS\uff09\uff0cCOLORFFFF00\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08645\uff0c35\uff0cNUMTOSTRN\uff08HH-HH1\uff0c0\uff09+CS\uff09\uff0cCOLOR00FFFF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08695\uff0c13\uff0cNUMTOSTRN\uff08QQ\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLOR0000FF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08695\uff0c24\uff0cNUMTOSTRN\uff08QQ1\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLORFFFF00\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08695\uff0c35\uff0cNUMTOSTRN\uff08QQ-QQ1\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLOR00FFFF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWRECTABS\uff08767\uff0c2\uff0c767+RZB\uff0c12\uff0cRGB\uff08255\uff0c30\uff0c30\uff09\uff09\uff0cCOLORFFFFFF;<\/p>\n<p> \u3000\u3000DRAWRECTABS\uff08767\uff0c2\uff0c767-CZB\uff0c12\uff0cRGB\uff0830\uff0c30\uff0c255\uff09\uff09\uff0cCOLORFFFFFF;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08733\uff0c1\uff0cNUMTOSTRN\uff08CZB\uff0c2\uff09+\u2018%\u2019\uff09\uff0cALIGN2\uff0cCOLOR00FFFF;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08837\uff0c1\uff0cNUMTOSTRN\uff08RZB\uff0c2\uff09+\u2018%\u2019\uff09\uff0cALIGN2\uff0cCOLOR00FFFF;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08740\uff0c13\uff0cNUMTOSTRN\uff08MR\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLOR4848FF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08740\uff0c24\uff0cNUMTOSTRN\uff08MC\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLOR48FF48\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08740\uff0c35\uff0cNUMTOSTRN\uff08JS\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLOREEEEEE\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08773\uff0c13\uff0cNUMTOSTRN\uff08MRB\uff0c0\uff09+\u2018\u7b14\u2019\uff09\uff0cCOLOR4848FF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08773\uff0c24\uff0cNUMTOSTRN\uff08MCB\uff0c0\uff09+\u2018\u7b14\u2019\uff09\uff0cCOLOR48FF48\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08773\uff0c35\uff0cNUMTOSTRN\uff08JB\uff0c0\uff09+\u2018\u7b14\u2019\uff09\uff0cCOLOREEEEEE\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08837\uff0c13\uff0cNUMTOSTRN\uff08RBG\uff0c0\uff09+\u2018\u80a1\/\u7b14\u2019\uff09\uff0cCOLOR4848FF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08837\uff0c24\uff0cNUMTOSTRN\uff08CBG\uff0c0\uff09+\u2018\u80a1\/\u7b14\u2019\uff09\uff0cCOLOR48FF48\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08837\uff0c35\uff0cNUMTOSTRN\uff08JC\uff0c0\uff09+\u2018\u80a1\/\u7b14\u2019\uff09\uff0cCOLOREEEEEE\uff0cALIGN2;<\/p>\n<p> \u3000\u3000{\u6563\u623730\u5206}<\/p>\n<p> \u3000\u3000input:N\uff081\uff0c1\uff0c2\uff09;<\/p>\n<p> \u3000\u3000TODAY\uff1a=\u201c\u5206\u65f6DDX.DDX\u7d2f\u79ef\u201d\u300a\u300b0;{\u5224\u65ad\u662f\u5426\u6709\u6b63\u7248\u6570\u636e}<\/p>\n<p> \u3000\u3000TODAY1\uff1a=\u201cLXDDX.DDX#day\u201d=0;{\u5224\u65ad\u662f\u5426\u6709\u96e8\u6768\u6570\u636e}<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08680\uff0c-12\uff0cIFS\uff08TODAY\uff0c\u2018\u6b63\u7248\u6570\u636e\u2019\uff0cIFS\uff08TODAY1\uff0c\u2018\u5f15\u5165\u6570\u636e\u2019\uff0c\u2018\u96e8\u6768\u6570\u636e \u2019\uff09\uff09\uff09\uff0cLINETHICK1\uff0ccolorwhite;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08752\uff0c-12\uff0cIFS\uff08N=1\uff0c\u2018\u9010\u5355\u2019\uff0c\u2018\u9010\u7b14\u2019\uff09\uff09\uff0cLINETHICK1\uff0ccolorwhite;<\/p>\n<p> \u3000\u3000ZT1\uff1a=\u201cwd.o10\u201d-\u201cwd.o11\u201d{ORDERVOL\uff081\uff0c0\uff09-ORDERVOL\uff081\uff0c1\uff09};<\/p>\n<p> \u3000\u3000YT1\u7d2f\u79ef\uff1a=\uff08\u201cDDEDATA@BIGORDERSCALE\u201d\uff081\uff0c0\uff09-\u201cDDEDATA@BIGORDERSCALE\u201d \uff081\uff0c1\uff09\uff09*SUM\uff08VOL\uff0c0\uff09;<\/p>\n<p> \u3000\u3000YT1\uff1a=YT1\u7d2f\u79ef-REF\uff08YT1\u7d2f\u79ef\uff0c1\uff09;<\/p>\n<p> \u3000\u3000RT1\u7d2f\u79ef\uff1a=\u201cwd.\u6563\u5355\u4e70#day\u201d*SUM\uff08VOL\uff0c0\uff09;<\/p>\n<p> \u3000\u3000RT1\uff1a=RT1\u7d2f\u79ef-REF\uff08RT1\u7d2f\u79ef\uff0c1\uff09;<\/p>\n<p> \u3000\u3000T1\uff1a=IF\uff08TODAY\uff0cZT1\uff0cIF\uff08TODAY1\uff0cRT1\uff0cYT1\uff09\uff09;<\/p>\n<p> \u3000\u3000T2\uff1a=\u201cwd.t10\u201d-\u201cwd.t11\u201d{TRANSACTVOL\uff081\uff0c0\uff09-TRANSACTVOL\uff081\uff0c1\uff09};<\/p>\n<p> \u3000\u3000ZT3\uff1a=\u201cwd.o20\u201d-\u201cwd.o21\u201d{ORDERVOL\uff082\uff0c0\uff09-ORDERVOL\uff082\uff0c1\uff09};<\/p>\n<p> \u3000\u3000YT3\u7d2f\u79ef\uff1a=\uff08\u201cDDEDATA@BIGORDERSCALE\u201d\uff082\uff0c0\uff09-\u201cDDEDATA@BIGORDERSCALE\u201d \uff082\uff0c1\uff09\uff09*SUM\uff08VOL\uff0c0\uff09;<\/p>\n<p> \u3000\u3000YT3\uff1a=YT3\u7d2f\u79ef-REF\uff08YT3\u7d2f\u79ef\uff0c1\uff09;<\/p>\n<p> \u3000\u3000RT3\u7d2f\u79ef\uff1a=\u201cwd.\u6563\u5355\u5356#day\u201d*SUM\uff08VOL\uff0c0\uff09;<\/p>\n<p> \u3000\u3000RT3\uff1a=RT3\u7d2f\u79ef-REF\uff08RT3\u7d2f\u79ef\uff0c1\uff09;<\/p>\n<p> \u3000\u3000T3\uff1a=IF\uff08TODAY\uff0cZT3\uff0cIF\uff08TODAY1\uff0cRT3\uff0cYT3\uff09\uff09;<\/p>\n<p> \u3000\u3000T4\uff1a=\u201cwd.t20\u201d-\u201cwd.t21\u201d{TRANSACTVOL\uff082\uff0c0\uff09-TRANSACTVOL\uff082\uff0c1\uff09};<\/p>\n<p> \u3000\u3000ZS1\uff1a=\u201cwd.d10\u201d-\u201cwd.d11\u201d{ORDERNUM\uff081\uff0c0\uff09-ORDERNUM\uff081\uff0c1\uff09};<\/p>\n<p> \u3000\u3000YS1\uff1a=\u201cDDEDATA@BIGORDERSCALE\u201d\uff081\uff0c0\uff09-\u201cDDEDATA@BIGORDERSCALE\u201d\uff081\uff0c1\uff09;<\/p>\n<p> \u3000\u3000RS1\uff1a=\u201cwd.\u6563\u5355\u4e70#day\u201d;<\/p>\n<p> \u3000\u3000S1\uff1a=IF\uff08TODAY\uff0cZS1\uff0cIF\uff08TODAY1\uff0cRS1\uff0cYS1\uff09\uff09;<\/p>\n<p> \u3000\u3000S2\uff1a=\u201cwd.l10\u201d-\u201cwd.l11\u201d{TRANSACTNUM\uff081\uff0c0\uff09-TRANSACTNUM\uff081\uff0c1\uff09};<\/p>\n<p> \u3000\u3000ZS3\uff1a=\u201cwd.d20\u201d-\u201cwd.d21\u201d{ORDERNUM\uff082\uff0c0\uff09-ORDERNUM\uff082\uff0c1\uff09};<\/p>\n<p> \u3000\u3000YS3\uff1a=\u201cDDEDATA@BIGORDERSCALE\u201d\uff082\uff0c0\uff09-\u201cDDEDATA@BIGORDERSCALE\u201d\uff082\uff0c1\uff09;<\/p>\n<p> \u3000\u3000RS3\uff1a=\u201cwd.\u6563\u5355\u5356#day\u201d;<\/p>\n<p> \u3000\u3000S3\uff1a=IF\uff08TODAY\uff0cZS3\uff0cIF\uff08TODAY1\uff0cRS3\uff0cYS3\uff09\uff09;<\/p>\n<p> \u3000\u3000S4\uff1a=\u201cwd.l20\u201d-\u201cwd.l21\u201d{TRANSACTNUM\uff082\uff0c0\uff09-TRANSACTNUM\uff082\uff0c1\uff09};<\/p>\n<p> \u3000\u3000M1\uff1a=TIME\u300a=100000;<\/p>\n<p> \u3000\u3000M2\uff1a=TIME\u300a=103000 AND TIME\u300b100000;<\/p>\n<p> \u3000\u3000M3\uff1a=TIME\u300a=110000 AND TIME\u300b103000;<\/p>\n<p> \u3000\u3000M4\uff1a=TIME\u300a=113000 AND TIME\u300b110000;<\/p>\n<p> \u3000\u3000M5\uff1a=TIME\u300a=133000 AND TIME\u300b130000;<\/p>\n<p> \u3000\u3000M6\uff1a=TIME\u300a=140000 AND TIME\u300b133000;<\/p>\n<p> \u3000\u3000M7\uff1a=TIME\u300a=143000 AND TIME\u300b140000;<\/p>\n<p> \u3000\u3000M8\uff1a=TIME\u300a=150000 AND TIME\u300b143000;<\/p>\n<p> \u3000\u3000{\u6570\u636e1\u5927\u4e70}<\/p>\n<p> \u3000\u3000A1\uff1a=IF\uff08M1\uff0cS1\uff0c0\uff09;<\/p>\n<p> \u3000\u3000A2\uff1a=IF\uff08M1\uff0cS2\uff0c0\uff09;<\/p>\n<p> \u3000\u3000AA\uff1a=SUM\uff08IF\uff08N=1\uff0cA1\uff0cA2\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000B1\uff1a=IF\uff08M2\uff0cS1\uff0c0\uff09;<\/p>\n<p> \u3000\u3000B2\uff1a=IF\uff08M2\uff0cS2\uff0c0\uff09;<\/p>\n<p> \u3000\u3000BB\uff1a=SUM\uff08IF\uff08N=1\uff0cB1\uff0cB2\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000C1\uff1a=IF\uff08M3\uff0cS1\uff0c0\uff09;<\/p>\n<p> \u3000\u3000C2\uff1a=IF\uff08M3\uff0cS2\uff0c0\uff09;<\/p>\n<p> \u3000\u3000CC\uff1a=SUM\uff08IF\uff08N=1\uff0cC1\uff0cC2\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000D1\uff1a=IF\uff08M4\uff0cS1\uff0c0\uff09;<\/p>\n<p> \u3000\u3000D2\uff1a=IF\uff08M4\uff0cS2\uff0c0\uff09;<\/p>\n<p> \u3000\u3000DD\uff1a=SUM\uff08IF\uff08N=1\uff0cD1\uff0cD2\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000E1\uff1a=IF\uff08M5\uff0cS1\uff0c0\uff09;<\/p>\n<p> \u3000\u3000E2\uff1a=IF\uff08M5\uff0cS2\uff0c0\uff09;<\/p>\n<p> \u3000\u3000EE\uff1a=SUM\uff08IF\uff08N=1\uff0cE1\uff0cE2\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000F1\uff1a=IF\uff08M6\uff0cS1\uff0c0\uff09;<\/p>\n<p> \u3000\u3000F2\uff1a=IF\uff08M6\uff0cS2\uff0c0\uff09;<\/p>\n<p> \u3000\u3000FF\uff1a=SUM\uff08IF\uff08N=1\uff0cF1\uff0cF2\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000G1\uff1a=IF\uff08M7\uff0cS1\uff0c0\uff09;<\/p>\n<p> \u3000\u3000G2\uff1a=IF\uff08M7\uff0cS2\uff0c0\uff09;<\/p>\n<p> \u3000\u3000GG\uff1a=SUM\uff08IF\uff08N=1\uff0cG1\uff0cG2\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000H1\uff1a=IF\uff08M8\uff0cS1\uff0c0\uff09;<\/p>\n<p> \u3000\u3000H2\uff1a=IF\uff08M8\uff0cS2\uff0c0\uff09;<\/p>\n<p> \u3000\u3000HH\uff1a=SUM\uff08IF\uff08N=1\uff0cH1\uff0cH2\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000I1\uff1a=IF\uff08M1\uff0cT1\uff0c0\uff09;<\/p>\n<p> \u3000\u3000I2\uff1a=IF\uff08M1\uff0cT2\uff0c0\uff09;<\/p>\n<p> \u3000\u3000II\uff1a=SUM\uff08IF\uff08N=1\uff0cI1\uff0cI2\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000J1\uff1a=IF\uff08M2\uff0cT1\uff0c0\uff09;<\/p>\n<p> \u3000\u3000J2\uff1a=IF\uff08M2\uff0cT2\uff0c0\uff09;<\/p>\n<p> \u3000\u3000JJ\uff1a=SUM\uff08IF\uff08N=1\uff0cJ1\uff0cJ2\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000K1\uff1a=IF\uff08M3\uff0cT1\uff0c0\uff09;<\/p>\n<p> \u3000\u3000K2\uff1a=IF\uff08M3\uff0cT2\uff0c0\uff09;<\/p>\n<p> \u3000\u3000KK\uff1a=SUM\uff08IF\uff08N=1\uff0cK1\uff0cK2\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000L1\uff1a=IF\uff08M4\uff0cT1\uff0c0\uff09;<\/p>\n<p> \u3000\u3000L2\uff1a=IF\uff08M4\uff0cT2\uff0c0\uff09;<\/p>\n<p> \u3000\u3000LL\uff1a=SUM\uff08IF\uff08N=1\uff0cL1\uff0cL2\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000N1\uff1a=IF\uff08M5\uff0cT1\uff0c0\uff09;<\/p>\n<p> \u3000\u3000N2\uff1a=IF\uff08M5\uff0cT2\uff0c0\uff09;<\/p>\n<p> \u3000\u3000NN\uff1a=SUM\uff08IF\uff08N=1\uff0cN1\uff0cN2\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000O1\uff1a=IF\uff08M6\uff0cT1\uff0c0\uff09;<\/p>\n<p> \u3000\u3000O2\uff1a=IF\uff08M6\uff0cT2\uff0c0\uff09;<\/p>\n<p> \u3000\u3000OO\uff1a=SUM\uff08IF\uff08N=1\uff0cO1\uff0cO2\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000P1\uff1a=IF\uff08M7\uff0cT1\uff0c0\uff09;<\/p>\n<p> \u3000\u3000P2\uff1a=IF\uff08M7\uff0cT2\uff0c0\uff09;<\/p>\n<p> \u3000\u3000PP\uff1a=SUM\uff08IF\uff08N=1\uff0cP1\uff0cP2\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000Q1\uff1a=IF\uff08M8\uff0cT1\uff0c0\uff09;<\/p>\n<p> \u3000\u3000Q2\uff1a=IF\uff08M8\uff0cT2\uff0c0\uff09;<\/p>\n<p> \u3000\u3000QQ\uff1a=SUM\uff08IF\uff08N=1\uff0cQ1\uff0cQ2\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000{\u6570\u636e2\u5927\u5356}<\/p>\n<p> \u3000\u3000A3\uff1a=IF\uff08M1\uff0cS3\uff0c0\uff09;<\/p>\n<p> \u3000\u3000A4\uff1a=IF\uff08M1\uff0cS4\uff0c0\uff09;<\/p>\n<p> \u3000\u3000AA1\uff1a=SUM\uff08IF\uff08N=1\uff0cA3\uff0cA4\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000B3\uff1a=IF\uff08M2\uff0cS3\uff0c0\uff09;<\/p>\n<p> \u3000\u3000B4\uff1a=IF\uff08M2\uff0cS4\uff0c0\uff09;<\/p>\n<p> \u3000\u3000BB1\uff1a=SUM\uff08IF\uff08N=1\uff0cB3\uff0cB4\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000C3\uff1a=IF\uff08M3\uff0cS3\uff0c0\uff09;<\/p>\n<p> \u3000\u3000C4\uff1a=IF\uff08M3\uff0cS4\uff0c0\uff09;<\/p>\n<p> \u3000\u3000CC1\uff1a=SUM\uff08IF\uff08N=1\uff0cC3\uff0cC4\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000D3\uff1a=IF\uff08M4\uff0cS3\uff0c0\uff09;<\/p>\n<p> \u3000\u3000D4\uff1a=IF\uff08M4\uff0cS4\uff0c0\uff09;<\/p>\n<p> \u3000\u3000DD1\uff1a=SUM\uff08IF\uff08N=1\uff0cD3\uff0cD4\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000E3\uff1a=IF\uff08M5\uff0cS3\uff0c0\uff09;<\/p>\n<p> \u3000\u3000E4\uff1a=IF\uff08M5\uff0cS4\uff0c0\uff09;<\/p>\n<p> \u3000\u3000EE1\uff1a=SUM\uff08IF\uff08N=1\uff0cE3\uff0cE4\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000F3\uff1a=IF\uff08M6\uff0cS3\uff0c0\uff09;<\/p>\n<p> \u3000\u3000F4\uff1a=IF\uff08M6\uff0cS4\uff0c0\uff09;<\/p>\n<p> \u3000\u3000FF1\uff1a=SUM\uff08IF\uff08N=1\uff0cF3\uff0cF4\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000G3\uff1a=IF\uff08M7\uff0cS3\uff0c0\uff09;<\/p>\n<p> \u3000\u3000G4\uff1a=IF\uff08M7\uff0cS4\uff0c0\uff09;<\/p>\n<p> \u3000\u3000GG1\uff1a=SUM\uff08IF\uff08N=1\uff0cG3\uff0cG4\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000H3\uff1a=IF\uff08M8\uff0cS3\uff0c0\uff09;<\/p>\n<p> \u3000\u3000H4\uff1a=IF\uff08M8\uff0cS4\uff0c0\uff09;<\/p>\n<p> \u3000\u3000HH1\uff1a=SUM\uff08IF\uff08N=1\uff0cH3\uff0cH4\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000I3\uff1a=IF\uff08M1\uff0cT3\uff0c0\uff09;<\/p>\n<p> \u3000\u3000I4\uff1a=IF\uff08M1\uff0cT4\uff0c0\uff09;<\/p>\n<p> \u3000\u3000II1\uff1a=SUM\uff08IF\uff08N=1\uff0cI3\uff0cI4\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000J3\uff1a=IF\uff08M2\uff0cT3\uff0c0\uff09;<\/p>\n<p> \u3000\u3000J4\uff1a=IF\uff08M2\uff0cT4\uff0c0\uff09;<\/p>\n<p> \u3000\u3000JJ1\uff1a=SUM\uff08IF\uff08N=1\uff0cJ3\uff0cJ4\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000K3\uff1a=IF\uff08M3\uff0cT3\uff0c0\uff09;<\/p>\n<p> \u3000\u3000K4\uff1a=IF\uff08M3\uff0cT4\uff0c0\uff09;<\/p>\n<p> \u3000\u3000KK1\uff1a=SUM\uff08IF\uff08N=1\uff0cK3\uff0cK4\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000L3\uff1a=IF\uff08M4\uff0cT3\uff0c0\uff09;<\/p>\n<p> \u3000\u3000L4\uff1a=IF\uff08M4\uff0cT4\uff0c0\uff09;<\/p>\n<p> \u3000\u3000LL1\uff1a=SUM\uff08IF\uff08N=1\uff0cL3\uff0cL4\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000N3\uff1a=IF\uff08M5\uff0cT3\uff0c0\uff09;<\/p>\n<p> \u3000\u3000N4\uff1a=IF\uff08M5\uff0cT4\uff0c0\uff09;<\/p>\n<p> \u3000\u3000NN1\uff1a=SUM\uff08IF\uff08N=1\uff0cN3\uff0cN4\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000O3\uff1a=IF\uff08M6\uff0cT3\uff0c0\uff09;<\/p>\n<p> \u3000\u3000O4\uff1a=IF\uff08M6\uff0cT4\uff0c0\uff09;<\/p>\n<p> \u3000\u3000OO1\uff1a=SUM\uff08IF\uff08N=1\uff0cO3\uff0cO4\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000P3\uff1a=IF\uff08M7\uff0cT3\uff0c0\uff09;<\/p>\n<p> \u3000\u3000P4\uff1a=IF\uff08M7\uff0cT4\uff0c0\uff09;<\/p>\n<p> \u3000\u3000PP1\uff1a=SUM\uff08IF\uff08N=1\uff0cP3\uff0cP4\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000Q3\uff1a=IF\uff08M8\uff0cT3\uff0c0\uff09;<\/p>\n<p> \u3000\u3000Q4\uff1a=IF\uff08M8\uff0cT4\uff0c0\uff09;<\/p>\n<p> \u3000\u3000QQ1\uff1a=SUM\uff08IF\uff08N=1\uff0cQ3\uff0cQ4\uff09\uff0c0\uff09;<\/p>\n<p> \u3000\u3000{\u6570\u636e3\u603b\u4e70\u603b\u5356\u5dee}<\/p>\n<p> \u3000\u3000MR\uff1a=IF\uff08N=1\uff0cSUM\uff08T1\uff0c0\uff09\uff0cSUM\uff08T2\uff0c0\uff09\uff09;<\/p>\n<p> \u3000\u3000MC\uff1a=IF\uff08N=1\uff0cSUM\uff08T3\uff0c0\uff09\uff0cSUM\uff08T4\uff0c0\uff09\uff09;<\/p>\n<p> \u3000\u3000MRE\uff1a=MR*DYNAINFO\uff0811\uff09*100\/10000;<\/p>\n<p> \u3000\u3000MCE\uff1a=MC*DYNAINFO\uff0811\uff09*100\/10000;<\/p>\n<p> \u3000\u3000\u6d41\u5165\u8d44\u91d1\uff1aMRE\uff0cCOLOR0000FF\uff0clinethick0\uff0cPRECIS2;<\/p>\n<p> \u3000\u3000\u6d41\u51fa\u8d44\u91d1\uff1aMCE\uff0cCOLORFFFF00\uff0clinethick0\uff0cPRECIS2;<\/p>\n<p> \u3000\u3000MRB\uff1a=IF\uff08N=1\uff0cSUM\uff08S1\uff0c0\uff09\uff0cSUM\uff08S2\uff0c0\uff09\uff09;<\/p>\n<p> \u3000\u3000MCB\uff1a=IF\uff08N=1\uff0cSUM\uff08S3\uff0c0\uff09\uff0cSUM\uff08S4\uff0c0\uff09\uff09;<\/p>\n<p> \u3000\u3000RBG\uff1a=MR*100\/MRB;<\/p>\n<p> \u3000\u3000CBG\uff1a=MC*100\/MCB;<\/p>\n<p> \u3000\u3000JS\uff1a=MR-MC;<\/p>\n<p> \u3000\u3000JE\uff1a=MRE-MCE;<\/p>\n<p> \u3000\u3000\u51c0\u8d44\u91d1\uff1aJE\uff0cCOLOR00FFFF\uff0clinethick0\uff0cPRECIS2;<\/p>\n<p> \u3000\u3000JB\uff1a=MRB-MCB;<\/p>\n<p> \u3000\u3000JC\uff1a=RBG-CBG;<\/p>\n<p> \u3000\u3000RZB\uff1a=MR\/DYNAINFO\uff088\uff09*100;<\/p>\n<p> \u3000\u3000CZB\uff1a=MC\/DYNAINFO\uff088\uff09*100;<\/p>\n<p> \u3000\u3000MR1\uff1a=IF\uff08N=1\uff0cT1\uff0cT2\uff09;<\/p>\n<p> \u3000\u3000MC1\uff1a=IF\uff08N=1\uff0cT3\uff0cT4\uff09;<\/p>\n<p> \u3000\u3000ZMX\uff1a=\uff08MR1-MC1\uff09\/DYNAINFO\uff088\uff09*100;<\/p>\n<p> \u3000\u3000CS\uff1a=IFS\uff08N=1\uff0c\u2018\u5355\u2019\uff0c\u2018\u7b14\u2019\uff09;<\/p>\n<p> \u3000\u3000{\u8868\u683c}<\/p>\n<p> \u3000\u3000DRAWRECTABS\uff080\uff0c0\uff0c838\uff0c48\uff0cRGB\uff081\uff0c1\uff0c1\uff09\uff09\uff0cCOLOR0000C0;<\/p>\n<p> \u3000\u3000DRAWRECTABS\uff080\uff0c0\uff0c696\uff0c13\uff0cRGB\uff08210\uff0c150\uff0c0\uff09\uff09\uff0cCOLOR0096D2;<\/p>\n<p> \u3000\u3000DRAWRECTABS\uff08696\uff0c0\uff0c838\uff0c13\uff0cRGB\uff08210\uff0c100\uff0c0\uff09\uff09\uff0cCOLOR0064D2;<\/p>\n<p> \u3000\u3000DRAWRECTABS\uff080\uff0c0\uff0c87\uff0c48\uff0c0\uff09\uff0cCOLOR0000C0;<\/p>\n<p> \u3000\u3000DRAWRECTABS\uff080\uff0c0\uff0c174\uff0c48\uff0c0\uff09\uff0cCOLOR0000C0;<\/p>\n<p> \u3000\u3000DRAWRECTABS\uff080\uff0c0\uff0c261\uff0c48\uff0c0\uff09\uff0cCOLOR0000C0;<\/p>\n<p> \u3000\u3000DRAWRECTABS\uff080\uff0c0\uff0c348\uff0c48\uff0c0\uff09\uff0cCOLOR0000C0;<\/p>\n<p> \u3000\u3000DRAWRECTABS\uff080\uff0c0\uff0c435\uff0c48\uff0c0\uff09\uff0cCOLOR0000C0;<\/p>\n<p> \u3000\u3000DRAWRECTABS\uff080\uff0c0\uff0c522\uff0c48\uff0c0\uff09\uff0cCOLOR0000C0;<\/p>\n<p> \u3000\u3000DRAWRECTABS\uff080\uff0c0\uff0c609\uff0c48\uff0c0\uff09\uff0cCOLOR0000C0;<\/p>\n<p> \u3000\u3000DRAWRECTABS\uff080\uff0c0\uff0c696\uff0c48\uff0c0\uff09\uff0cCOLOR0000C0;<\/p>\n<p> \u3000\u3000DRAWRECTABS\uff080\uff0c0\uff0c838\uff0c48\uff0c0\uff09\uff0cCOLOR0000C0;<\/p>\n<p> \u3000\u3000{\u663e\u793a\u6587\u5b57\u6570\u5b57}<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff0815\uff0c1\uff0c\u20189:30-10:00 10:00-10:30 10:30-11:00 11:00-11:30 13:00-13:30 13:30-14:00 14:00-14:30 14:30-15:00 \u2019\uff09\uff0cCOLORFFFFFF;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff0836\uff0c13\uff0cNUMTOSTRN\uff08AA\uff0c0\uff09+CS\uff09\uff0cCOLOR0000FF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff0836\uff0c24\uff0cNUMTOSTRN\uff08AA1\uff0c0\uff09+CS\uff09\uff0cCOLORFFFF00\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff0836\uff0c35\uff0cNUMTOSTRN\uff08AA-AA1\uff0c0\uff09+CS\uff09\uff0cCOLOR00FFFF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff0886\uff0c13\uff0cNUMTOSTRN\uff08II\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLOR0000FF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff0886\uff0c24\uff0cNUMTOSTRN\uff08II1\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLORFFFF00\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff0886\uff0c35\uff0cNUMTOSTRN\uff08II-II1\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLOR00FFFF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08123\uff0c13\uff0cNUMTOSTRN\uff08BB\uff0c0\uff09+CS\uff09\uff0cCOLOR0000FF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08123\uff0c24\uff0cNUMTOSTRN\uff08BB1\uff0c0\uff09+CS\uff09\uff0cCOLORFFFF00\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08123\uff0c35\uff0cNUMTOSTRN\uff08BB-BB1\uff0c0\uff09+CS\uff09\uff0cCOLOR00FFFF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08173\uff0c13\uff0cNUMTOSTRN\uff08JJ\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLOR0000FF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08173\uff0c24\uff0cNUMTOSTRN\uff08JJ1\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLORFFFF00\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08173\uff0c35\uff0cNUMTOSTRN\uff08JJ-JJ1\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLOR00FFFF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08210\uff0c13\uff0cNUMTOSTRN\uff08CC\uff0c0\uff09+CS\uff09\uff0cCOLOR0000FF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08210\uff0c24\uff0cNUMTOSTRN\uff08CC1\uff0c0\uff09+CS\uff09\uff0cCOLORFFFF00\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08210\uff0c35\uff0cNUMTOSTRN\uff08CC-CC1\uff0c0\uff09+CS\uff09\uff0cCOLOR00FFFF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08260\uff0c13\uff0cNUMTOSTRN\uff08KK\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLOR0000FF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08260\uff0c24\uff0cNUMTOSTRN\uff08KK1\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLORFFFF00\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08260\uff0c35\uff0cNUMTOSTRN\uff08KK-KK1\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLOR00FFFF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08297\uff0c13\uff0cNUMTOSTRN\uff08DD\uff0c0\uff09+CS\uff09\uff0cCOLOR0000FF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08297\uff0c24\uff0cNUMTOSTRN\uff08DD1\uff0c0\uff09+CS\uff09\uff0cCOLORFFFF00\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08297\uff0c35\uff0cNUMTOSTRN\uff08DD-DD1\uff0c0\uff09+CS\uff09\uff0cCOLOR00FFFF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08347\uff0c13\uff0cNUMTOSTRN\uff08LL\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLOR0000FF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08347\uff0c24\uff0cNUMTOSTRN\uff08LL1\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLORFFFF00\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08347\uff0c35\uff0cNUMTOSTRN\uff08LL-LL1\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLOR00FFFF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08384\uff0c13\uff0cNUMTOSTRN\uff08EE\uff0c0\uff09+CS\uff09\uff0cCOLOR0000FF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08384\uff0c24\uff0cNUMTOSTRN\uff08EE1\uff0c0\uff09+CS\uff09\uff0cCOLORFFFF00\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08384\uff0c35\uff0cNUMTOSTRN\uff08EE-EE1\uff0c0\uff09+CS\uff09\uff0cCOLOR00FFFF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08434\uff0c13\uff0cNUMTOSTRN\uff08NN\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLOR0000FF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08434\uff0c24\uff0cNUMTOSTRN\uff08NN1\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLORFFFF00\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08434\uff0c35\uff0cNUMTOSTRN\uff08NN-NN1\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLOR00FFFF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08471\uff0c13\uff0cNUMTOSTRN\uff08FF\uff0c0\uff09+CS\uff09\uff0cCOLOR0000FF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08471\uff0c24\uff0cNUMTOSTRN\uff08FF1\uff0c0\uff09+CS\uff09\uff0cCOLORFFFF00\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08471\uff0c35\uff0cNUMTOSTRN\uff08FF-FF1\uff0c0\uff09+CS\uff09\uff0cCOLOR00FFFF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08521\uff0c13\uff0cNUMTOSTRN\uff08OO\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLOR0000FF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08521\uff0c24\uff0cNUMTOSTRN\uff08OO1\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLORFFFF00\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08521\uff0c35\uff0cNUMTOSTRN\uff08OO-OO1\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLOR00FFFF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08558\uff0c13\uff0cNUMTOSTRN\uff08GG\uff0c0\uff09+CS\uff09\uff0cCOLOR0000FF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08558\uff0c24\uff0cNUMTOSTRN\uff08GG1\uff0c0\uff09+CS\uff09\uff0cCOLORFFFF00\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08558\uff0c35\uff0cNUMTOSTRN\uff08GG-GG1\uff0c0\uff09+CS\uff09\uff0cCOLOR00FFFF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08608\uff0c13\uff0cNUMTOSTRN\uff08PP\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLOR0000FF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08608\uff0c24\uff0cNUMTOSTRN\uff08PP1\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLORFFFF00\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08608\uff0c35\uff0cNUMTOSTRN\uff08PP-PP1\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLOR00FFFF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08645\uff0c13\uff0cNUMTOSTRN\uff08HH\uff0c0\uff09+CS\uff09\uff0cCOLOR0000FF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08645\uff0c24\uff0cNUMTOSTRN\uff08HH1\uff0c0\uff09+CS\uff09\uff0cCOLORFFFF00\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08645\uff0c35\uff0cNUMTOSTRN\uff08HH-HH1\uff0c0\uff09+CS\uff09\uff0cCOLOR00FFFF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08695\uff0c13\uff0cNUMTOSTRN\uff08QQ\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLOR0000FF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08695\uff0c24\uff0cNUMTOSTRN\uff08QQ1\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLORFFFF00\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08695\uff0c35\uff0cNUMTOSTRN\uff08QQ-QQ1\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLOR00FFFF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWRECTABS\uff08767\uff0c2\uff0c767+RZB\uff0c12\uff0cRGB\uff08255\uff0c30\uff0c30\uff09\uff09\uff0cCOLORFFFFFF;<\/p>\n<p> \u3000\u3000DRAWRECTABS\uff08767\uff0c2\uff0c767-CZB\uff0c12\uff0cRGB\uff0830\uff0c30\uff0c255\uff09\uff09\uff0cCOLORFFFFFF;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08733\uff0c1\uff0cNUMTOSTRN\uff08CZB\uff0c2\uff09+\u2018%\u2019\uff09\uff0cALIGN2\uff0cCOLOR00FFFF;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08837\uff0c1\uff0cNUMTOSTRN\uff08RZB\uff0c2\uff09+\u2018%\u2019\uff09\uff0cALIGN2\uff0cCOLOR00FFFF;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08740\uff0c13\uff0cNUMTOSTRN\uff08MR\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLOR4848FF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08740\uff0c24\uff0cNUMTOSTRN\uff08MC\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLOR48FF48\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08740\uff0c35\uff0cNUMTOSTRN\uff08JS\uff0c0\uff09+\u2018\u624b\u2019\uff09\uff0cCOLOREEEEEE\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08773\uff0c13\uff0cNUMTOSTRN\uff08MRB\uff0c0\uff09+\u2018\u7b14\u2019\uff09\uff0cCOLOR4848FF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08773\uff0c24\uff0cNUMTOSTRN\uff08MCB\uff0c0\uff09+\u2018\u7b14\u2019\uff09\uff0cCOLOR48FF48\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08773\uff0c35\uff0cNUMTOSTRN\uff08JB\uff0c0\uff09+\u2018\u7b14\u2019\uff09\uff0cCOLOREEEEEE\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08837\uff0c13\uff0cNUMTOSTRN\uff08RBG\uff0c0\uff09+\u2018\u80a1\/\u7b14\u2019\uff09\uff0cCOLOR4848FF\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08837\uff0c24\uff0cNUMTOSTRN\uff08CBG\uff0c0\uff09+\u2018\u80a1\/\u7b14\u2019\uff09\uff0cCOLOR48FF48\uff0cALIGN2;<\/p>\n<p> \u3000\u3000DRAWTEXTABS\uff08837\uff0c35\uff0cNUMTOSTRN\uff08JC\uff0c0\uff09+\u2018\u80a1\/\u7b14\u2019\uff09\uff0cCOLOREEEEEE\uff0cALIGN2;<\/p>\n<p> \uff08\u80a1\u7968\u8d44\u6e90\u9986lixiangluntan.com\uff09<\/p>\n<blockquote style=\"font-size:15px;background-color: #F5F5F5;border:none;padding: 5px;margin:15px;line-height: 1.6;text-indent: 2em;\">\n<p style=\"margin-bottom:5px;\">\u3010\u80a1\u7968\u8d44\u6e90\u9986\u3011\u5927\u667a\u6167\u4e13\u4e1a\u7248\u7834\u89e3\u7248,\u5927\u667a\u6167\u673a\u6784\u7834\u89e3\u7248,\u5927\u667a\u6167ACE\u7834\u89e3\u7248,ACE\u7b56\u7565,AI\u6d3b\u8dc3\u5ea6\u3002<\/p>\n<\/blockquote>\n<blockquote style=\"font-size:15px;background-color: #F5F5F5;border:none;padding: 5px;margin:15px;line-height: 1.6;text-indent: 2em;\">\n<p style=\"margin-bottom:5px;\">\u5927\u667a\u6167\u5206\u65f6\u4e3b\u56fe\u6307\u6807\u516c\u5f0f<\/p>\n<p>\u3000\u3000\u5206\u65f6\u4e3b\u56fe\u53e0\u52a0\u4e86\u5927\u76d8\u7ebf\uff0c\u5927\u76d8\u53c2\u8003\u7ebf\uff08\u76ee\u7684\u4e3a\u4e86\u9009\u80a1\u53c2\u8003\u7528\uff09\uff0c\u80a1\u4ef7\uff0c\u5747\u4ef7\uff0c\u770b\u5f3a\u7ebf\u3002<\/p>\n<\/blockquote>\n","protected":false},"excerpt":{"rendered":"<p>\u3000\u3000{\u4e3b\u529b30\u5206}<\/p>\n","protected":false},"author":6,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[131],"tags":[132],"class_list":["post-4140","post","type-post","status-publish","format-standard","hentry","category-dzhgs","tag-132"],"_links":{"self":[{"href":"https:\/\/www.lixiangluntan.com\/index.php?rest_route=\/wp\/v2\/posts\/4140","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.lixiangluntan.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.lixiangluntan.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.lixiangluntan.com\/index.php?rest_route=\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/www.lixiangluntan.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=4140"}],"version-history":[{"count":0,"href":"https:\/\/www.lixiangluntan.com\/index.php?rest_route=\/wp\/v2\/posts\/4140\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.lixiangluntan.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=4140"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.lixiangluntan.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=4140"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.lixiangluntan.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=4140"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}