|
{公式一ZT}
MK:C>=ZTPRICE(REF(C,1),0.1)&&H!=L;
{公式二ZTTJ}
N:=2;
{行N3-100 }
N:=2;
DRAWTEXT_FIX(V>0,0,1,0,'煤301');
DRAWTEXT_FIX(V>0,0.1,0.96,0,'油310');
DRAWTEXT_FIX(V>0,0,0.94,0,'钢318');
DRAWTEXT_FIX(V>0,0.1,0.92,0,'有324');
DRAWTEXT_FIX(V>0,0,0.9,0,'电305');
DRAWTEXT_FIX(V>0,0.1,0.88,0,'纤330');
DRAWTEXT_FIX(V>0,0,0.86,0,'化335');
DRAWTEXT_FIX(V>0,0.1,0.84,0,'建344');
DRAWTEXT_FIX(V>0,0,0.82,0,'纸350');
DRAWTEXT_FIX(V>0,0.1,0.80,0,'矿351');
DRAWTEXT_FIX(V>0,0,0.78,0,'通用437');
DRAWTEXT_FIX(V>0,0.1,0.76,0,'工业440工程447');
DRAWTEXT_FIX(V>0,0,0.74,0,'电备446');
DRAWTEXT_FIX(V>0,0.1,0.72,0,'筑476');
DRAWTEXT_FIX(V>0,0,0.7,0,'日355');
DRAWTEXT_FIX(V>0,0.1,0.68,0,'农360');
DRAWTEXT_FIX(V>0,0,0.66,0,'纺367');
DRAWTEXT_FIX(V>0,0.1,0.64,0,'家电387');
DRAWTEXT_FIX(V>0,0,0.62,0,'车390');
DRAWTEXT_FIX(V>0,0.1,0.6,0,'居399');
DRAWTEXT_FIX(V>0,0,0.58,0,'连406代414');
DRAWTEXT_FIX(V>0,0.1,0.56,0,'房482');
DRAWTEXT_FIX(V>0,0,0.54,0,'食372');
DRAWTEXT_FIX(V>0,0.1,0.52,0,'医398');
DRAWTEXT_FIX(V>0,0,0.5,0,'药400');
DRAWTEXT_FIX(V>0,0.1,0.48,0,'餐423旅424');
DRAWTEXT_FIX(V>0,0,0.46,0,'媒418');
DRAWTEXT_FIX(V>0,0.1,0.44,0,'广421');
DRAWTEXT_FIX(V>0,0,0.42,0,'文422');
DRAWTEXT_FIX(V>0,0.1,0.4,0,'仪448');
DRAWTEXT_FIX(V>0,0,0.38,0,'信营452');
DRAWTEXT_FIX(V>0,0.1,0.36,0,'IT489');
DRAWTEXT_FIX(V>0,0,0.34,0,'半491');
DRAWTEXT_FIX(V>0,0.1,0.32,0,'元492');
DRAWTEXT_FIX(V>0,0,0.3,0,'软493');
DRAWTEXT_FIX(V>0,0.1,0.28,0,'网494');
DRAWTEXT_FIX(V>0,0,0.26,0,'公453运服459');
DRAWTEXT_FIX(V>0,0.1,0.24,0,'水454气455');
DRAWTEXT_FIX(V>0,0,0.22,0,'环456');
DRAWTEXT_FIX(V>0,0.1,0.2,0,'综497');
DRAWTEXT_FIX(V>0,0,0.18,0,'航430船431');
DRAWTEXT_FIX(V>0,0.1,0.16,0,'运备432');
DRAWTEXT_FIX(V>0,0,0.14,0,'仓464');
DRAWTEXT_FIX(V>0,0.1,0.12,0,'交465');
DRAWTEXT_FIX(V>0,0,0.1,0,'银471');
DRAWTEXT_FIX(V>0,0.1,0.08,0,'证472');
DRAWTEXT_FIX(V>0,0,0.06,0,'保473');
DRAWTEXT_FIX(V>0,0.1,0.04,0,'多474');
DRAWTEXT_FIX(V>0,0,0.02,0,'信备490');
DRAWTEXT_FIX(V>0,0.1,0,0,'酒380');
A1:=INSUM('煤炭','ZT',1,0);
A2:=INSUM('电力','ZT',1,0);
A3:=INSUM('石油','ZT',1,0);
A4:=INSUM('钢铁','ZT',1,0);
A5:=INSUM('有色','ZT',1,0);
A6:=INSUM('化纤','ZT',1,0);
A7:=INSUM('化工','ZT',1,0);
A8:=INSUM('建材','ZT',1,0);
A9:=INSUM('造纸','ZT',1,0);
A10:=INSUM('矿物制品','ZT',1,0);
A11:=INSUM('日用化工','ZT',1,0);
A12:=INSUM('农林牧渔','ZT',1,0);
A13:=INSUM('纺织服饰','ZT',1,0);
A14:=INSUM('食品饮料','ZT',1,0);
A15:=INSUM('酿酒','ZT',1,0);
A16:=INSUM('家用电器','ZT',1,0);
A17:=INSUM('汽车类','ZT',1,0);
A18:=INSUM('医疗保健','ZT',1,0);
A19:=INSUM('家居用品','ZT',1,0);
A20:=INSUM('医药','ZT',1,0);
A21:=INSUM('商业连锁','ZT',1,0);
A22:=INSUM('商贸代理','ZT',1,0);
A23:=INSUM('传媒娱乐','ZT',1,0);
A24:=INSUM('广告包装','ZT',1,0);
A25:=INSUM('文教休闲','ZT',1,0);
A26:=INSUM('酒店餐饮','ZT',1,0);
A27:=INSUM('旅游','ZT',1,0);
A28:=INSUM('航空','ZT',1,0);
A29:=INSUM('船舶','ZT',1,0);
A30:=INSUM('运输设备','ZT',1,0);
A31:=INSUM('通用机械','ZT',1,0);
A32:=INSUM('工业机械','ZT',1,0);
A33:=INSUM('电气设备','ZT',1,0);
A34:=INSUM('工程机械','ZT',1,0);
A35:=INSUM('电器仪表','ZT',1,0);
A36:=INSUM('电信运营','ZT',1,0);
A37:=INSUM('公共交通','ZT',1,0);
A38:=INSUM('水务','ZT',1,0);
A39:=INSUM('供气供热','ZT',1,0);
A40:=INSUM('环境保护','ZT',1,0);
A41:=INSUM('运输服务','ZT',1,0);
A42:=INSUM('仓储物流','ZT',1,0);
A43:=INSUM('交通设施','ZT',1,0);
A44:=INSUM('银行','ZT',1,0);
A45:=INSUM('证券','ZT',1,0);
A46:=INSUM('保险','ZT',1,0);
A47:=INSUM('多元金融','ZT',1,0);
A48:=INSUM('建筑','ZT',1,0);
A49:=INSUM('房地产','ZT',1,0);
A50:=INSUM('IT设备','ZT',1,0);
A51:=INSUM('通信设备','ZT',1,0);
A52:=INSUM('半导体','ZT',1,0);
A53:=INSUM('元器件','ZT',1,0);
A54:=INSUM('软件服务','ZT',1,0);
A55:=INSUM('互联网','ZT',1,0);
A56:=INSUM('综合类','ZT',1,0);
DRAWNUMBER(A1>N,0,A1);
DRAWNUMBER(A3>N,0.02,A3);
DRAWNUMBER(A4>N,0.04,A4);
DRAWNUMBER(A5>N,0.06,A5);
DRAWNUMBER(A2>N,0.08,A2);
DRAWNUMBER(A6>N,0.1,A6);
DRAWNUMBER(A7>N,0.12,A7);
DRAWNUMBER(A8>N,0.14,A8);
DRAWNUMBER(A9>N,0.16,A9);
DRAWNUMBER(A10>N,0.18,A10);
DRAWNUMBER(A31>N,0.2,A31);
DRAWNUMBER(A32>N||A34>N,0.22,MAX(A32,A34));
DRAWNUMBER(A33>N,0.24,A33);
DRAWNUMBER(A48>N,0.26,A48);
DRAWNUMBER(A11>N,0.28,A11);
DRAWNUMBER(A12>N,0.3,A12);
DRAWNUMBER(A13>N,0.32,A13);
DRAWNUMBER(A16>N,0.34,A16);
DRAWNUMBER(A17>N,0.36,A17);
DRAWNUMBER(A19>N,0.38,A19);
DRAWNUMBER(A21>N||A22>N,0.4,MAX(A21,A22));
DRAWNUMBER(A49>N,0.42,A49);
DRAWNUMBER(A14>N,0.44,A14);
DRAWNUMBER(A18>N,0.46,A18);
DRAWNUMBER(A20>N,0.48,A20);
DRAWNUMBER(A26>N||A27>N,0.50,MAX(A26,A27));
DRAWNUMBER(A23>N,0.52,A23);
DRAWNUMBER(A24>N,0.54,A24);
DRAWNUMBER(A25>N,0.56,A25);
DRAWNUMBER(A35>N,0.58,A35);
DRAWNUMBER(A36>N,0.60,A36);
DRAWNUMBER(A50>N,0.62,A50);
DRAWNUMBER(A52>N,0.64,A52);
DRAWNUMBER(A53>N,0.66,A53);
DRAWNUMBER(A54>N,0.68,A54);
DRAWNUMBER(A55>N,0.7,A55);
DRAWNUMBER(A37>N||A41>N,0.72,MAX(A37,A41));
DRAWNUMBER(A38>N||A39>N,0.74,MAX(A38,A39));
DRAWNUMBER(A40>N,0.76,A40);
DRAWNUMBER(A56>N,0.78,A56);
DRAWNUMBER(A28>N||A29>N,0.8,MAX(A28,A29));
DRAWNUMBER(A30>N,0.82,A30);
DRAWNUMBER(A42>N,0.84,A42);
DRAWNUMBER(A43>N,0.86,A43);
DRAWNUMBER(A44>N,0.88,A44);
DRAWNUMBER(A45>N,0.9,A45);
DRAWNUMBER(A46>N,0.92,A46);
DRAWNUMBER(A47>N,0.94,A47);
DRAWNUMBER(A51>N,0.96,A51);
DRAWNUMBER(A15>N,0.98,A15)
|
