招标投标评标评分系统（自动计算）.xls

1、招招标标投投标标评评标标评评分分一一览览表表项目名称:*学院试验楼工程序号投标单位技术标得分施工组织设计工期工程质量评委1评委2评委3评委4评委5平均得分自报工期得分自报评分得分满分25220330标底A111111十建25.020.023.025.025.023.62053.0合格3.03.02七建25.025.025.025.025.025.02103.0合格3.03.03华源25.025.025.025.025.025.02053.0合格3.03.04四川25.025.025.025.025.025.02103.0合格3.03.05华山25.025.025.025.025.025.021

2、03.0合格3.03.06华山25.025.025.025.025.025.02103.0合格3.03.06平均值7说明ABCDEFGHIJPQST12454025.020.025.025.025.025.00招招标标投投标标评评标标评评分分一一览览表表*学院试验楼工程商务标得分项目班子企业信誉鲁班奖省优奖技术标总分技术标得分排序名次预算价投标报价投标报三材量钢材(T)得分得分项数得分项数得分040000358258294.008091260.84406.1700.04.0000033.617801114.607800000.00114.6800.04.0000035.017649735.60

3、7600000.00409.8000.04.0000035.017975545.997950000.00417.9180.04.0000035.017784483.007006000.00438.0000.04.0000035.017984264.807900666.00402.8000.04.0000035.017700000.007500000.00410.000注意:UVWXYZAAADAEAFAGAH100100超出标底百分比?%参与计算的单位数参与L值计算的数量水泥(T)超出标底百分比?%参与计算的单位数参与L值计算的数量木材(M3)超出标底百分比?%参与计算的单位数参与L值计算的数

4、量0.00%1406.1702491.840.00%12491.84083.840.00%183.840-71.77%2391.94-4.01%12391.940102.0621.73%00.0000.89%1409.8002365.36-5.08%00.000100.0019.27%00.0002.89%1417.9182413.80-3.13%12413.800102.1621.85%00.0007.84%2404.00-3.53%12404.000100.9220.37%00.000-0.83%1402.8001951.30-21.69%00.00093.4811.50%00.0000.

5、94%1410.0002480.00-0.48%12480.00085.001.38%185.0005409.3452436.32284.421、三材评标标准量L=(标底量+参与L值计算的数量)/(1+参与L值计算的投标单位数量)；2、凡投标单位投标报量超出标底量5%，则该投报量不参加L值的计算；若各投标单位均在此范围之外，标底量即为评标标准量。AIAJAKALAMANAOAPAQARAS409.1720050-75%-75%2.50%1FALSE#VALUE!招招标标投投标标评评标标评评分分一一览览表表商务标得分投标报三材量招招标标投投标标评评标标评评分分一一览览表表*学院试验楼工程商务标得

6、分投标价排序名次合成标底(0.4*标底+0.6*均值)比例?%=(投报价量-标底价量)/标底价量预算价均值计算合成标底(0.4*标底+0.6*均值)投标报价超出标底百分比参与均值计算的单位预算价单位数量参与B值计算的预算价比例合成标底超出合成标底百分比%得分得分57578258294.0040%3303317.6044-5.54%0.0000.0060%0.00-3.60%45 45.013-7.37%0.0000.0060%0.00-6.07%0 54.056-3.42%7975545.9913987773.0060%2392663.80-1.75%39 39.031-5.74%0.0000

7、.0060%0.00-13.41%0 45.065-3.32%7984264.8013992132.4060%2395279.44-3.59%45 45.022-6.76%0.0000.0060%0.00-8.54%55 55.07979905.4027979905.408091260.841、评标标底价D=0.4*标底价+0.6*参与投标单位的预算价之和/参与B值计算的投标单位数量；2、凡投标单位投标预算价超出标底量5%，则该投报量不参加B值的计算；若各投标单位均在此范围之外，标底价即为评标标准价。各分项得分参照评标办法确定BABCBDBEBFBGBHBJBKBL#REF!8091260.8

8、4020#REF!B=(3+5)/2合成标底D=(0.4*A+0.6*B)-10.0%0.3-10.0%0.02=31=20=1-1=0-2=-1-3=-2-4=-3-5=-4-6=-5-7=-6-8=-7-9=-8-10=-9-11=-10综合得分综合得分排序名次商务标得分钢材水泥木材超出合成标底百分比%得分超出合成标底百分比%得分超出合成标底百分比%得分3.03.02.065100-71.21%0.0-4.10%1.821.58%0.046.8 80.42378.50.89%3.0-5.19%1.519.14%0.058.5 93.55180.42.87%2.4-3.20%2.121.70

9、%0.043.5 78.51483.07.78%0.9-3.61%2.120.23%0.048.0 83.07283.0-0.82%3.0-22.19%0.011.42%0.048.0 83.07293.50.94%3.0-0.49%3.01.37%1.862.8 97.86297.8BMBPBQBRBSBUBVBXBY279=10-10=-90.30.30.21308=9-9=-80.60.60.42337=8-8=-70.90.90.63366=7-7=-61.21.20.84395=6-6=-51.51.515424=5-5=-41.81.81.26453=4-4=-32.12.11.4

10、7482=3-3=-22.42.41.68招招标标投投标标评评标标评评分分一一览览表表比例?%=(投报价量-标底价量)/标底价量各分项得分参照评标办法确定511=2-2=-12.72.71.895401-1=01057-1=00=-133211551253135114招招标标投投标标评评标标评评分分一一览览表表项目名称:*绿化工程序号投标单位技术标得分施工组织设计工期工程质量评委1评委2评委3评委4评委5平均得分自报工期得分自报评分满分2522030标底A0111111A125.020.023.025.025.023.62053.0合格3.02A225.025.025.025.025.025.

11、02103.0合格3.03A325.025.025.025.025.025.02053.0合格3.04A425.025.025.025.025.025.02103.0合格3.05A525.025.025.025.025.025.02103.0合格3.06A625.025.025.025.025.025.02103.0合格3.07A725.025.025.025.025.025.02103.0合格3.08A825.025.025.025.025.025.02103.0合格3.09A925.025.025.025.025.025.02103.0合格3.010A1025.025.025.025.02

12、5.025.02103.0合格3.06平均值7说明ABCDEFGHIJPQS12454025.020.025.025.025.025.00招招标标投投标标评评标标评评分分一一览览表表*绿化工程商务标得分项目班子企业信誉鲁班奖省优奖技术标总分技术标得分排序名次预算价投标报价预算价排序名次得分得分得分项数得分项数得分3040000357586694.197609970.643.00.04.0000033.617778575.837081300.00103.00.04.0000035.017709245.417380000.0083.00.04.0000035.017680856.707280000

13、.0053.00.04.0000035.016865655.646865655.6413.00.04.0000035.017044395.607044395.6023.00.04.0000035.017634975.916980000.0043.00.04.0001136.027741499.207150000.0093.00.04.0002237.037070000.007070000.0033.00.04.0003338.047700791.177230000.0073.00.04.0004439.057687962.007060000.006TUVWXYZAAADAEAFAG招招标标投投

14、标标评评标标评评分分一一览览表表工程质量招招标标投投标标评评标标评评分分一一览览表表*学院试验楼工程商务标得分投标价价排序投标价排序名次投标价排序名次合成标底(0.4*标底+0.6*均值)投标价排序投标价排序号预算价均值计算合成标底(0.4*标底+0.6*均值)超出标底百分比参与均值计算的单位预算价单位数量参与B值计算的预算价比例合成标底7586694.1940%3034677.6806865655.641662.53%7778575.831972321.9860%583393.1906980000.0021001.62%7709245.411963655.6860%578193.415704

15、4395.603901.24%7680856.701960107.0960%576064.2517060000.00411-9.50%0.0000.0060%0.0027070000.00533-7.15%0.0000.0060%0.0047081300.006220.64%7634975.911954371.9960%572623.1907150000.007702.04%7741499.201967687.4060%580612.4437150000.00855-6.81%7070000.001883750.0060%530250.0007150000.009801.50%7700791.

16、171962598.9060%577559.3467230000.0010441.33%7687962.001960995.2560%576597.157625488.2887625488.287609970.641、评标标底价D=0.4*标底价+0.6*参与投标单位的预算价之和/参与B值计算的投标单位数量；2、凡投标单位投标预算价超出标底量5%，则该投报量不参加B值的计算；若各投标单位均在此范围之外，标底价即为评标标准价。AXAYBABABCBDBEBFBGBH#REF!7609970.641#REF!B=(3+5)/2合成标底D=(0.4*A+0.6*B)招招标标投投标标评评标标评评分分一

17、一览览表表商务标得分预算价排序名次综合 得分比例?%=(投报价量-标底价量)/标底价量商务标得分商务标得分排序名次计算商务标得分排序名次综合得分综合得分排序名次计算 综合得分排序名次投标报价超出合成标底百分比%得分筛选倒序 正序筛选 倒序正序5757100-6.95%48 54.048.048.062281.681.6544487-3.02%41 45.041.041.017776.076.0188886-4.34%44 48.044.044.035579.079.0366685-9.78%42 53.042.042.026677.077.0277782-7.43%46 57.046.046.

18、044481.081.0455581-8.28%46 55.046.044481.0455581-6.04%50 54.050.050.071186.086.0722281-7.10%44 57.044.035581.0455579-4.99%47 48.047.047.053385.085.0633377-7.23%48 57.048.062287.087.081117678各分项得分参照评标办法确定BJBLBU BVBX00-10.0%0.3-10.0%0.02=30.30.21=20.60.40=10.90.6-1=01.20.8-2=-11.51招招标标投投标标评评标标评评分分一一览览

19、表表商务标得分-3=-21.81.2-4=-32.11.4-5=-42.41.6-6=-52.71.8-7=-6-8=-732-9=-8-10=-9-11=-101234567891087878100010000008686720000000100858563000001000082825400000010008181450000100000797946000010000077774701000000007676380000100000#NUM!#NUM!290010000000#NUM!#NUM!1101000000000111131110011IF(BO9=CE9,B9,IF(BO10=C

20、E9,B10,IF(BO11=CE9,B11,IF(BO12=CE9,B12,IF(BO13=CE9,B13,IF(BO14=CE9,B14,IF(BO15=CE9,B15,IF(BO16=CE9,B16,IF(BO17=CE9,B17,IF(BO18=CE9,B18,)12B1413B151415B1216171819110IF(BO9=CE9,B9,IF(BO10=CE9,B10,IF(BO11=CE9,B11,IF(BO12=CE9,B12,IF(BO13=CE9,B13,IF(BO14=CE9,B14,IF(BO15=CE9,B15,IF(BO16=CE9,B16,IF(BO17=CE

21、9,B17,IF(BO18=CE9,B18,)IF(BO9=CE9,B9,IF(BO10=CE9,B10,IF(BO11=CE9,B11,IF(BO12=CE9,B12,IF(BO13=CE9,B13,IF(BO14=CE9,B14,IF(BO15=CE9,B15,IF(BO16=CE9,B16,IF(BO17=CE9,B17,IF(BO18=CE9,B18,)招招标标投投标标评评标标评评分分一一览览表表项目名称*学院试验楼工程序号投标单位技术标得分施工组织设计工期工程质量评委1评委2评委3评委4评委5平均得分自报工期得分自报评分得分满分25220330标底A111111十建25.020.02

22、3.025.025.023.62053.0合格3.03.02七建25.025.025.025.025.025.02103.0合格3.03.03华源25.025.025.025.025.025.02053.0合格3.03.04四川25.025.025.025.025.025.02103.0合格3.03.05华山25.025.025.025.025.025.02103.0合格3.03.06华山25.025.025.025.025.025.02103.0合格3.03.06平均值7说明ABCDEFGHIJPQST12454025.020.025.025.025.025.00招招标标投投标标评评标标评评

23、分分一一览览表表*学院试验楼工程商务标得分项目班子企业信誉鲁班奖省优奖技术标总分技术标得分排序名次预算价投标报价投标报三材量钢材(T)得分得分项数得分项数得分040000358258294.008091260.84406.1700.04.0000033.617801114.607800000.00114.6800.04.0000035.017649735.607600000.00409.8000.04.0000035.017975545.997950000.00417.9180.04.0000035.017784483.007006000.00438.0000.04.0000035.01798

24、4264.807900666.00402.8000.04.0000035.017700000.007500000.00410.000注意:UVWXYZAAADAEAFAGAH100100超出标底百分比?%参与计算的单位数参与L值计算的数量水泥(T)超出标底百分比?%参与计算的单位数参与L值计算的数量木材(M3)超出标底百分比?%参与计算的单位数参与L值计算的数量0.00%1406.1702491.840.00%12491.84083.840.00%183.840-71.77%2391.94-4.01%12391.940102.0621.73%00.0000.89%1409.8002365.36

25、-5.08%00.000100.0019.27%00.0002.89%1417.9182413.80-3.13%12413.800102.1621.85%00.0007.84%2404.00-3.53%12404.000100.9220.37%00.000-0.83%1402.8001951.30-21.69%00.00093.4811.50%00.0000.94%1410.0002480.00-0.48%12480.00085.001.38%185.0005409.3452436.32284.421、三材评标标准量L=(标底量+参与L值计算的数量)/(1+参与L值计算的投标单位数量)；2、凡

26、投标单位投标报量超出标底量5%，则该投报量不参加L值的计算；若各投标单位均在此范围之外，标底量即为评标标准量。AIAJAKALAMANAOAPAQARAS409.1720050-75%-75%2.50%1FALSE#VALUE!招招标标投投标标评评标标评评分分一一览览表表商务标得分投标报三材量招招标标投投标标评评标标评评分分一一览览表表*学院试验楼工程商务标得分投标价排序名次合成标底(0.4*标底+0.6*均值)比例?%=(投报价量-标底价量)/标底价量预算价均值计算合成标底(0.4*标底+0.6*均值)投标报价超出标底百分比参与均值计算的单位预算价单位数量参与B值计算的预算价比例合成标底超出

27、合成标底百分比%得分得分57578258294.0040%3303317.6044-5.54%0.0000.0060%0.00-3.60%45 45.013-7.37%0.0000.0060%0.00-6.07%0 54.056-3.42%7975545.9913987773.0060%2392663.80-1.75%39 39.031-5.74%0.0000.0060%0.00-13.41%0 45.065-3.32%7984264.8013992132.4060%2395279.44-3.59%45 45.022-6.76%0.0000.0060%0.00-8.54%55 55.07979

28、905.4027979905.408091260.841、评标标底价D=0.4*标底价+0.6*参与投标单位的预算价之和/参与B值计算的投标单位数量；2、凡投标单位投标预算价超出标底量5%，则该投报量不参加B值的计算；若各投标单位均在此范围之外，标底价即为评标标准价。各分项得分参照评标办法确定BABCBDBEBFBGBHBJBKBL#REF!8091260.84020#REF!B=(3+5)/2合成标底D=(0.4*A+0.6*B)-10.0%0.3-10.0%0.02=31=20=1-1=0-2=-1-3=-2-4=-3-5=-4-6=-5-7=-6-8=-7-9=-8-10=-9-11=-

29、10综合得分综合得分排序名次商务标得分钢材水泥木材超出合成标底百分比%得分超出合成标底百分比%得分超出合成标底百分比%得分3.03.02.065100-71.21%0.0-4.10%1.821.58%0.046.8 80.42378.50.89%3.0-5.19%1.519.14%0.058.5 93.55180.42.87%2.4-3.20%2.121.70%0.043.5 78.51483.07.78%0.9-3.61%2.120.23%0.048.0 83.07283.0-0.82%3.0-22.19%0.011.42%0.048.0 83.07293.50.94%3.0-0.49%3.

30、01.37%1.862.8 97.86297.8BMBPBQBRBSBUBVBXBY279=10-10=-90.30.30.21308=9-9=-80.60.60.42337=8-8=-70.90.90.63366=7-7=-61.21.20.84395=6-6=-51.51.515424=5-5=-41.81.81.26453=4-4=-32.12.11.47482=3-3=-22.42.41.68招招标标投投标标评评标标评评分分一一览览表表比例?%=(投报价量-标底价量)/标底价量各分项得分参照评标办法确定511=2-2=-12.72.71.895401-1=01057-1=00=-133211551253135114