投标报价得分计算表ExceleVIP

投标报价得分计算表,,,,,,,,,,,,,,

工程名称：大方县预防职务犯罪工作委员会及大方县人民检察院侦查技术用房综合楼工程施工招标,,,,,,,标段：标,评审时间：2012年8月6日表8,,,,,,

控制总价：,,3217837.90,元,,最低下限价：,0.00元,评标基准价：,4748.00,,元,,,,

序,投标企业,,,,投标报价（元）,评标基准价,偏差率计算,投标报价得分计算,,,,,,

,,,,,,J=（B1+B2+…+Bn)÷n,P=[Bn-J]÷J×100%,报价满分,P×K×100值,报价满分-P×K×100值,,,,

1,,,,,5689.00,4748.00,0.20,75,198.19,-123.19,,,,

2,,,,,4563.00,4748.00,0.04,75,11.69,63.31,,,,

3,,,,,4563.00,4748.00,0.04,75,11.69,63.31,,5689.00,,

4,,,,,4545.00,4748.00,0.04,75,12.83,62.17,,4563.00,,

5,,,,,4786.00,4748.00,0.01,75,8.00,67.00,,4563.00,,

6,,,,,4786.00,4748.00,0.01,75,8.00,67.00,,4545.00,,

7,,,,,4786.00,4748.00,0.01,75,8.00,67.00,,4786.00,,

8,,,,,4786.00,4748.00,0.01,75,8.00,67.00,,4786.00,,#NUM!

9,,,,,4786.00,4748.00,0.01,75,8.00,67.00,,4786.00,,4563.00

10,,,,,4786.00,4748.00,0.01,75,8.00,67.00,,4786.00,,4563.00

11,,,,,4786.00,4748.00,0.01,75,8.00,67.00,,4786.00,,4786.00

12,,,,,4586.00,4748.00,0.03,75,10.24,64.76,,4786.00,,4786.00

13,,,,,4786.00,4748.00,0.01,75,8.00,67.00,,4786.00,,4786.00

14,,,,,4786.00,4748.00,0.01,75,8.00,67.00,,4586.00,,4786.00

15,,,,,8686.00,4748.00,0.83,75,829.40,-754.40,,4786.00,,4786.00

16,,,,,4786.00,4748.00,0.01,75,8.00,67.00,,4786.00,,4786.00

17,,,,,4786.00,4748.00,0.01,75,8.00,67.00,,8686.00,,4786.00

18,,,,,4786.00,4748.00,0.01,75,8.00,67.00,,4786.00,,4586.00

19,,,,,4786.00,4748.00,0.01,75,8.00,67.00,,4786.00,,4786.00

20,,,,,4786.00,4748.00,0.01,75,8.00,67.00,,4786.00,,4786.00

,合计,,,,99636.00,备注：n=参加计算基准价的家数,,,备注：偏差率中K值为正时取10、为负时取3,,,4786.00,,4786.00

,去掉二个最高和去掉一个最低报价总合计,,,,4748.00,,,,备注：偏差率正减、负（-）加[P×K×100]值，,,,4786.00,,4786.00

,计算人签字：,,,,,,,,,,,99636,,47