中位值法评标计算表

,,中位值法评标计算表,,,,,,,,,,,,,,,,,,,,

序号,序号,"单位

签号",投标单位,"投标报价

（元）","最高限价

（元）",K/M值,下浮比列,进入A、B系列数据,,B系列平均数（大于等于7家，去除最高值、去除最低值）,B系列除以B系列平均数,B系列平均数1.1倍以上投标报价,B系列平均数1.1倍（含）至平均数0.9倍（含）之间投标报价,B系列平均数0.9倍以下投标报价,B系列1.1倍以上所有数据的平均数,B系列1.1倍（含）至0.9倍（含）之间所有数据,B系列0.9倍以下的所有数据的平均数,中位数,参考价,基准价D,C值（抽签系数）,有效值

,,,,,,18%,,A（＜K值）,B（≥K值）,,,,,,,,,,,,,

1,1,1,,"2,802,126.12",3321916.84,,0.1565,2802126.12,FALSE,2484692.73,0.00,,FALSE,,,,2175570,2488895,2723971.809,2488894.95,0.975,2426672.576

2,2,2,,"2,439,994.86",3321916.84,,0.2655,FALSE,2439994.86,,0.98,,2439994.86,,,2439995,,,,,,

3,3,3,,"2,570,000.01",3321916.84,,0.2264,FALSE,2570000.01,,1.03,,2570000.01,,,2570000,,,,,,

4,4,4,,"2,175,569.98",3321916.84,,0.3451,FALSE,2175569.98,,0.88,,FALSE,2175570,,,,,,,,

5,5,5,,"2,451,770.70",3321916.84,,0.2619,FALSE,2451770.7,,0.99,,2451770.7,,,2451771,,,,,,

6,6,6,,"2,919,100.00",3321916.84,,0.1213,2919100,FALSE,,0.00,,FALSE,,,,,,,,,

7,7,7,,"2,542,867.64",3321916.84,,0.2345,FALSE,2542867.64,,1.02,,2542867.64,,,2542868,,,,,,

8,8,8,,"2,908,230.26",3321916.84,,0.1245,2908230.26,FALSE,,0.00,,FALSE,,,,,,,,,

9,9,9,,"2,671,955.30",3321916.84,,0.1957,FALSE,2671955.3,,1.08,,2671955.3,,,2671955,,,,,,

10,10,10,,"2,420,002.65",3321916.84,,0.2715,FALSE,2420002.65,,0.97,,2420002.65,,,2420003,,,,,,

11,11,11,,"2,388,816.28",3321916.84,,0.2809,FALSE,2388816.28,,0.96,,2388816.28,,,2388816,,,,,,

12,12,12,,"2,516,354.09",3321916.84,,0.2425,FALSE,2516354.09,,1.01,,2516354.09,,,2516354,,,,,,

13,13,13,,"2,535,652.34",3321916.84,,0.2367,FALSE,2535652.34,,1.02,,2535652.34,,,2535652,,,,,,

14,14,14,,"2,461,435.81",3321916.84,,0.259,FALSE,2461435.81,,0.99,,2461435.81,,,2461436,,,,,,

,15,15,,"2,520,032.89",3321916.84,,0.2414,FALSE,2520032.89,,1.01,,2520032.89,,,2520033,,,,,,

,①红色单元格数据需要手动输入；②蓝色单元格为定值，无需改动；③其他单元格为自动