365文库
登录
注册
福利来袭，限时免费在线编辑
转Pdf
下载我编辑的
下载原始文档
收藏
北有亡夢南有孤島
上传于：2024-09-13
商品分类控制表Commodity Classification Control Table记录人梅梅A类￥506,000,000.00总金额￥646,120,000.00B类￥66,420,000.00总量4450C类￥73,700,000.00序号产品名称单价总量累计百分比金额资金占比自动分类备注1as￥100.001503%￥1,600,000.000%C2aq￥100.002004%￥1,500,000.000%C3aw￥100.0050011%￥1,900,000.000%C4ae￥100.0060013%￥13,000,000.002%C5ar￥100.001503%￥13,000,000.002%C6at￥100.0070016%￥12,500,000.002%C7ag￥100.0080018%￥4,500,000.001%C8ac￥100.001503%￥506,000,000.0078%A9ax￥100.001503%￥9,300,000.001%C10az￥100.001503%￥3,600,000.001%C11ah￥100.001503%￥66,420,000.0010%B12ak￥100.001503%￥3,700,000.001%C13an￥100.001503%￥2,400,000.000%C14am￥100.001503%￥2,600,000.000%C15al￥100.001503%￥2,000,000.000%C16au￥100.001503%￥2,100,000.000%C设定产品分类按资金占比分，可对H行百分比进行相应修改，如：IF(G7<10%,\"C\",IF(G7<20%,\"B\",IF(G7<50%,\"B\",\"A\")))