店铺评分DSR计算表

店铺动态评分（仅供参考不代表官方）,,,,,,,,,,,,推算一,,,推算二,,

DSR,店铺评分,,同行评分,,"相对同行

评分比率",评分人数,"5分

☆☆☆☆☆","4分

☆☆☆☆","3分

☆☆☆","2分

☆☆","1分

☆",如果增加5分买家,店铺评分增加到,,参加活动评分要求,,"需增

5分买家"

宝贝与描述相符,=(H3*G3*5+I3*G3*4+J3*G3*3+K3*G3*2+L3*G3*1)/(H3*G3+I3*G3+J3*G3+K3*G3+L3*G3),分,"=IF(F3>0,(B3-5*F3)/(1-$F3),B3/(1+$F3))",分,-0.03,753,0.76,0.16,0.06,0.01,0.02,140,4.688596976,分,4.77,分,=((P3*G3)-G3*(H3*5+I3*4+J3*3+K3*2+L3*1))/(5-P3)

卖家的服务态度,=(H4*G4*5+I4*G4*4+J4*G4*3+K4*G4*2+L4*G4*1)/(H4*G4+I4*G4+J4*G4+K4*G4+L4*G4),分,"=IF(F4>0,(B4-5*F4)/(1-$F4),B4/(1+$F4))",分,-0.03,750,0.81,0.14,0.03,0.01,0.02,560,4.835114504,分,4.84,分,=((P4*G4)-G4*(H4*5+I4*4+J4*3+K4*2+L4*1))/(5-P4)

卖家发货的速度,=SUM(H5*G5*5+I5*G5*4+J5*G5*3+K5*G5*2+L5*G5*1)/SUM(H5*G5+I5*G5+J5*G5+K5*G5+L5*G5),分,"=IF(F5>0,(B5-5*F5)/(1-$F5),B5/(1+$F5))",分,-0.04,751,0.77,0.14,0.05,0.01,0.03,340,4.739869019,分,4.82,分,=((P5*G5)-G5*(H5*5+I5*4+J5*3+K5*2+L5*1))/(5-P5)

禁止输入,,,,,数据录入区,,,,,,,,禁止输入,,数据录入区,,禁止输入

,,,,,,,,,,,,,,,,,

,,,,,,,,,,红色为输出,,,,,,,

,,,,,,,,,,绿色为输入,,,注意：在截图数据的时候，当光标,,,,

,,,,,,,,,,,,,移动到“宝贝与描述相符”才是这项的评分，当移动到“卖家的服务态度”才显示是这项评分。,,,,

,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,使用方法：,,,,

,,,,,,,,,,,,,1.只需要把店铺输入填入“数据录入区”即可2.”禁止输入“请勿录入数据，它会自动计算,,,,

,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,