中位值法评标计算表

K/M值18%A（＜K值）B（≥K值）112,802,126.123321916.840.15652802126.12FALSE0.00FALSE222,439,994.863321916.840.2655FALSE2439994.860.982439994.862439995332,570,000.013321916.840.2264FALSE2570000.011.032570000.012570000442,175,569.983321916.840.3451FALSE2175569.980.88FALSE2175570552,451,770.703321916.840.2619FALSE2451770.70.992451770.72451771662,919,100.003321916.840.12132919100FALSE0.00FALSE772,542,867.643321916.840.2345FALSE2542867.641.022542867.642542868882,908,230.263321916.840.12452908230.26FALSE0.00FALSE992,671,955.303321916.840.1957FALSE2671955.31.082671955.3267195510102,420,002.653321916.840.2715FALSE2420002.650.972420002.65242000311112,388,816.283321916.840.2809FALSE2388816.280.962388816.28238881612122,516,354.093321916.840.2425FALSE2516354.091.012516354.09251635413132,535,652.343321916.840.2367FALSE2535652.341.022535652.34253565214142,461,435.813321916.840.259FALSE2461435.810.992461435.81246143615152,520,032.893321916.840.2414FALSE2520032.891.012520032.892520033①红色单元格数据需要手动输入；②蓝色单元格为定值，无需改动；③其他单元格为自动计算基准价D2488894.95C值（抽签系数）0.975有效值2426672.576B系列1.1倍（含）至0.9倍（含）之间所有数据B系列0.9倍以下的所有数据的平均数2175570中位数2488895参考价2723971.8092484692.73B系列除以B系列平均数B系列平均数1.1倍以上投标报价B系列平均数1.1倍（含）至平均数0.9倍（含）之间投标报价B系列平均数0.9倍以下投标报价B系列1.1倍以上所有数据的平均数中位值法评标计算表进入A、B系列数据序号单位签号投标单位投标报价（元）最高限价（元）下浮比列B系列平均数（大于等于7家，去除最高值、去除最低值）签到号投标单位投标报价高于或等于中位值12000000020000000234567891011121314151617181920排序排序辅助11低于有效值#VALUE!低于有效值#VALUE!低于有效值#VALUE!低于有效值#VALUE!低于有效值#VALUE!低于有效值#VALUE!低于有效值#VALUE!低于有效值#VALUE!低于有效值#VALUE!低于有效值#VALUE!低于有效值#VALUE!低于有效值#VALUE!低于有效值#VALUE!低于有效值#VALUE!低于有效值#VALUE!低于有效值#VALUE!低于有效值#VALUE!低于有效值#VALUE!低于有效值#VALUE!