店鋪評分DSR計算表

店鋪動態(tài)評分（僅供參考不代表官方）,,,,,,,,,,,,推算一,,,推算二,,

DSR,店鋪評分,,同行評分,,"相對同行

評分比率",評分人數(shù),"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)

賣家的服務態(tài)度,=(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)

賣家發(fā)貨的速度,=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)

禁止輸入,,,,,數(shù)據(jù)錄入?yún)^(qū),,,,,,,,禁止輸入,,數(shù)據(jù)錄入?yún)^(qū),,禁止輸入

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

,,,,,,,,,,紅色為輸出,,,,,,,

,,,,,,,,,,綠色為輸入,,,注意：在截圖數(shù)據(jù)的時候，當光標,,,,

,,,,,,,,,,,,,移動到“寶貝與描述相符”才是這項的評分，當移動到“賣家的服務態(tài)度”才顯示是這項評分。,,,,

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

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

,,,,,,,,,,,,,1.只需要把店鋪輸入填入“數(shù)據(jù)錄入?yún)^(qū)”即可2.”禁止輸入“請勿錄入數(shù)據(jù)，它會自動計算,,,,

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

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

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

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

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

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

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

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

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

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

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

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

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

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