《Excel等级赋分计算方法程序比例可修改空值不赋分1297.pdf》由会员分享，可在线阅读，更多相关《Excel等级赋分计算方法程序比例可修改空值不赋分1297.pdf（25页珍藏版）》请在taowenge.com淘文阁网|工程机械CAD图纸|机械工程制图|CAD装配图下载|SolidWorks_CaTia_CAD_UG_PROE_设计图分享下载上搜索。
1、班级学号姓名考号技术赋分值高二(05)511*1111522004089291高二(09)931*1111522005889291 等级赋分比例切分线累计人数高二(08)836*1.51152E+11929111001%10011高二(05)543*1.21152E+1191882972%9831高二(07)729*1.21152E+1190883943%9652高二(11)1135*1.21152E+1189884914%9296高二(09)906*1.11152E+1188855885%89136高二(10)1021*1.21152E+1188856856%86180高二(08)831*1
2、.11152E+1187857827%80243高二(12)1231*1.11152E+1187858798%74314高二(10)1029*1.11152E+1187859767%69373高二(06)615*1.21152E+11878510737%64433高二(11)1116*1.21152E+11878511707%59491高二(09)921*1.51152E+11878512677%54551高二(05)525*1.51152E+11878513647%49610高二(12)1232*1.11152E+11868514617%44669高二(08)828*1.11152E+111
3、0010015586%40717高二(10)1001*1.11152E+11999716555%32755高二(07)703*1.11152E+11989717524%25789高二(06)606*1.11152E+11979418493%19818高二(12)1205*1.21152E+11969419462%16832高二(03)303*1.21152E+11959120431%13843高二(06)631*1.51152E+11949121401%0849高二(10)1033*1.51152E+119391高二(11)1107*1.11152E+119291高二(09)917*1.111
4、52E+119188高二(05)516*1.11152E+119088高二(07)709*1.21152E+118988高二(08)833*1.21152E+118885高二(06)628*1.21152E+118785高二(10)1004*1.21152E+118685高二(09)914*1.21152E+11说明：使用前需要启用“宏”。点击“工具-宏-安全性”设置为“中”，然后关闭重新打开，启用宏即可。考号和分数数据必须有，其他可以留空。赋分计算清空总人数 849高二(12)1225*1.21152E+11考号和分数数据必须有，其他可以留空。比例可以自行修改！高二(08)820*1.211
5、52E+11高二(05)521*1.21152E+11高二(12)1201*1.21152E+11高二(11)1103*1.21152E+11高二(07)717*1.21152E+117979高二(12)1210*1.11152E+117879高二(11)1127*1111522005527779高二(09)908*1.21152E+117679高二(06)611*1.21152E+117579高二(08)815*1.21152E+117479高二(08)801*1.21152E+117376高二(07)732*1.21152E+117276高二(10)1031*1.21152E+117176
6、高二(05)503*1.21152E+117076高二(10)1022*1.51152E+116976高二(11)1104*1.51152E+116873高二(08)807*1.11152E+116773高二(12)1226*1.11152E+116673高二(07)728*1.11152E+116573高二(06)632*1.11152E+116473高二(09)930*1.11152E+116370高二(11)1101*1.11152E+116270高二(05)513*1.11152E+116170高二(11)1108*1.11152E+116070高二(09)916*1.21152E+1
7、15970高二(07)707*1.21152E+115867高二(06)608*1.21152E+115767高二(08)829*1.21152E+115667Excel 2007以上版本启用宏方法，请自己百度！程序设计：杜宗飞高二(12)1202*1.21152E+115567高二(10)1028*1.21152E+115467高二(05)507*1.21152E+115364高二(09)934*1.41152E+115264高二(15)1511*1.51152E+115164高二(10)1014*1.51152E+115064高二(11)1125*1.11152E+114964高二(08)
8、804*1.11152E+114861高二(05)533*1.11152E+114761高二(06)630*1.11152E+114661高二(07)701*1.11152E+114561高二(12)1228*1.11152E+114461高二(10)1027*1.21152E+114358高二(07)704*1.21152E+114258高二(11)1110*1.21152E+114158高二(09)928*1.21152E+114058高二(12)1227*1.21152E+113955高二(08)834*1.21152E+113855高二(05)534*1.21152E+113755高二
9、(06)607*1.21152E+113655高二(09)901*1.51152E+113555高二(01)116*1.51152E+113455高二(09)902*1.51152E+113355高二(14)1407*1.51152E+113255高二(08)822*1.51152E+113152高二(07)734*1.51152E+113052高二(11)1132*1.11152E+112952高二(05)512*1.11152E+112852高二(08)839*1.11152E+112752高二(11)1118*1.11152E+112652高二(05)505*1.11152E+11255
10、2高二(08)802*1.11152E+112449高二(11)1112*1.11152E+112349高二(05)540*1.21152E+112249高二(08)811*1.21152E+112149高二(08)811*1.21152E+112049高二(11)1124*1.51152E+111949高二(11)1124*1.51152E+111846高二(11)1102*1.51152E+111746高二(11)1102*1.51152E+118082高二(05)508*1.51152E+117879高二(05)508*1.11152E+117679高二(11)1119*1.11152E
11、+117479高二(11)1119*1.11152E+117276高二(08)803*1.11152E+117076高二(08)803*1.11152E+116873高二(06)634*1.11152E+116673高二(06)634*1.11152E+116473高二(11)1131*1.21152E+116270高二(11)1131*1.21152E+116070高二(08)814*1.21152E+115867高二(08)814*1.21152E+115667高二(07)713*1.21152E+115467高二(07)713*1.21152E+115264高二(06)623*1.211
12、52E+115064高二(06)623*1.41152E+114861高二(10)1018*1.51152E+114661高二(10)1018*1.11152E+114461高二(12)1213*1.11152E+114258高二(12)1213*1.11152E+114058高二(05)530*1.11152E+113855高二(05)530*1.11152E+113655高二(05)509*1.11152E+113455高二(05)509*1.11152E+113255高二(06)612*1.11152E+113052高二(06)612*1.11152E+112852高二(10)1019*
13、1.21152E+112652高二(10)1019*1.21152E+112449高二(12)1208*1.21152E+112249高二(12)1208*1.21152E+112049高二(05)532*1.21152E+111846高二(05)532*1.21152E+111646高二(11)1129*1.21152E+111443高二(11)1129*1.21152E+111240高二(08)838*1.21152E+119088高二(08)838*1.21152E+118988高二(07)705*1.21152E+118885高二(07)705*1.31152E+118785高二(10
14、)1007*1.31152E+118685高二(10)1007*1.31152E+118582高二(05)518*1.41152E+118482高二(05)518*1.51152E+118382高二(12)1206*1.51152E+118282高二(12)1206*1.51152E+118182高二(07)738*1.51152E+118082高二(07)738*1.11152E+117979高二(11)1113*1.11152E+117879高二(11)1113*1.11152E+117779高二(08)805*1.21152E+117679高二(08)805*1.21152E+11757
15、9高二(12)1209*1.21152E+117479高二(12)1209*1.21152E+117376高二(06)609*1.21152E+117276高二(06)609*1.21152E+117176高二(05)506*1.21152E+117076高二(05)506*1.21152E+116976高二(10)1008*1.21152E+116873高二(10)1008*1.21152E+116773高二(09)943*1.21152E+116673高二(09)943*1.21152E+116573高二(12)1236*1.31152E+116473高二(12)1236*1.31152E
16、+116370高二(11)1126*1.31152E+116270高二(11)1126*1.31152E+116170高二(06)627*1.41152E+116070高二(06)627*1.51152E+115970高二(07)721*1.11152E+115867高二(07)721*1.11152E+115767高二(08)816*1.11152E+115667高二(08)816*1.11152E+115567高二(06)626*1.21152E+115467高二(06)626*1.21152E+115364高二(09)913*1.21152E+115264高二(09)913*1.2115
17、2E+115164高二(06)616*1.21152E+115064高二(06)616*1.21152E+114964高二(11)1122*1.21152E+114861高二(11)1122*1.21152E+114761高二(07)716*1.21152E+114661高二(07)716*1.31152E+114561高二(05)527*1.31152E+114461高二(05)527*1.31152E+114358高二(08)808*1.41152E+114258高二(08)808*1.51152E+114158高二(12)1245*1.51152E+114058高二(12)1245*1.
18、51152E+113955高二(14)1401*1.51152E+113855高二(14)1401*1.51152E+113755高二(10)1013*1.11152E+113655高二(10)1013*1.11152E+113555高二(09)904*1.21152E+113455高二(09)904*1.21152E+113355高二(06)613*1.21152E+113255高二(05)526*1.21152E+113152高二(10)1009*1.21152E+113052高二(07)712*1.21152E+112952高二(08)840*1.21152E+112852高二(11)1
19、138*1.21152E+112752高二(12)1229*1.21152E+112652高二(07)711*1.21152E+112552高二(04)405*1.21152E+112449高二(10)1038*1.31152E+112349高二(08)821*1.31152E+112249高二(09)903*1.41152E+112149高二(05)519*1.41152E+112049高二(12)1211*1.51152E+111949高二(11)1117*1.51152E+111846高二(06)605*1.51152E+111746高二(11)1109*1.51152E+111646高
20、二(06)601*1.51152E+111543高二(09)907*1.51152E+111443高二(05)501*1.11152E+111343高二(05)528*1.11152E+111240高二(08)824*1.11152E+111140高二(07)722*1.11152E+11100100高二(10)1012*1.11152E+119997高二(12)1212*1.11152E+119897高二(11)1130*1.11152E+119794高二(06)610*1.11152E+119694高二(10)1002*1.21152E+119591高二(12)1203*1.21152E+
21、119491高二(07)725*1.21152E+119391高二(07)710*1.21152E+119291高二(01)132*1.21152E+119188高二(03)329*1.21152E+119088高二(12)1207*1.31152E+118988高二(08)809*1.31152E+118885高二(01)139*1.31152E+118785高二(11)1105*1.31152E+118685高二(03)332*1.31152E+118582高二(13)1311*1.31152E+118482高二(10)1039*1.41152E+118382高二(07)731*1.411
22、52E+118282高二(14)1413*1.41152E+118182高二(16)1631*1.41152E+118082高二(16)1631*1.51152E+117979高二(06)617*1.51152E+117879高二(06)617*1.51152E+117779高二(01)101*1.11152E+117679高二(01)101*1.11152E+117579高二(09)925*1.11152E+117479高二(09)925*1.21152E+117376高二(02)215*1.21152E+117276高二(02)215*1.21152E+117176高二(04)415*1.
23、21152E+117076高二(04)415*1.21152E+116976高二(13)1305*1.21152E+116873高二(13)1305*1.21152E+116773高二(10)1010*1.21152E+116673高二(10)1010*1.21152E+116573高二(07)737*1.21152E+116473高二(07)737*1.21152E+116370高二(11)1114*1.31152E+116270高二(11)1114*1.41152E+116170高二(09)936*1.51152E+116070高二(09)936*1.51152E+115970高二(12)
24、1224*1.51152E+115867高二(12)1224*1.51152E+115767高二(15)1508*1.11152E+115667高二(15)1508*1.11152E+115567高二(06)645*1.11152E+115467高二(06)645*1.11152E+115364高二(06)635*1.11152E+115264高二(06)635*1.11152E+115164高二(03)306*1.21152E+115064高二(03)306*1.21152E+114964高二(14)1437*1.21152E+114861高二(14)1437*1.21152E+114761
25、高二(02)208*1.21152E+114661高二(02)208*1.21152E+114561高二(01)123*1.21152E+114461高二(01)123*1.21152E+114358高二(08)841*1.21152E+114258高二(08)841*1.31152E+114158高二(16)1601*1.31152E+114058高二(16)1601*1.41152E+113955高二(09)945*1.41152E+113855高二(09)945*1.41152E+113755高二(03)315*1.51152E+113655高二(11)1140*1.51152E+113
26、555高二(02)201*1.51152E+113455高二(13)1328*1.51152E+113355高二(14)1410*1.51152E+113255高二(04)431*1.51152E+113152高二(10)1032*1.11152E+113052高二(02)204*1.11152E+112952高二(12)1242*1.11152E+112852高二(01)135*1.11152E+112752高二(15)1506*1.21152E+112652高二(06)603*1.21152E+112552高二(16)1626*1.21152E+112449高二(08)817*1.2115
27、2E+112349高二(07)715*1.21152E+112249高二(08)818*1.21152E+112149高二(10)1020*1.21152E+112049高二(16)1610*1.21152E+111949高二(15)1531*1.21152E+111846高二(11)1145*1.21152E+111746高二(12)1230*1.21152E+111646高二(09)933*1.21152E+111543高二(08)835*1.31152E+111443高二(06)636*1.31152E+111343高二(09)919*1.31152E+111240高二(03)341*1
28、.41152E+111140高二(04)437*1.41152E+11100100高二(01)107*1.41152E+119997高二(13)1335*1.41152E+119897高二(07)718*1.51152E+119794高二(14)1403*1.51152E+119694高二(02)228*1.51152E+119591高二(09)909*1.51152E+119491高二(02)217*1.11152E+119391高二(14)1414*1.11152E+119291高二(16)1602*1.21152E+119188高二(03)316*1.21152E+119088高二(10
29、)1006*1.21152E+118988高二(15)1502*1.21152E+118885高二(12)1244*1.21152E+118785高二(16)1636*1.21152E+118685高二(01)105*1.31152E+118582高二(07)739*1.31152E+118482高二(13)1314*1.31152E+118382高二(04)414*1.31152E+118282高二(06)639*1.31152E+118182高二(10)1017*1.31152E+118082高二(11)1143*1.31152E+117979高二(08)823*1.31152E+1178
30、79高二(07)743*1.31152E+117779高二(03)330*1.41152E+117679高二(16)1604*1.41152E+117579高二(12)1238*1.51152E+117479高二(06)618*1.51152E+117376高二(11)1120*1.51152E+117276高二(08)825*1.51152E+117176高二(01)110*1.51152E+117076高二(02)216*1.51152E+116976高二(02)211*1.51152E+116873高二(15)1513*1.51152E+116773高二(14)1408*1.51152E
31、+116673高二(09)905*1.51152E+116573高二(04)430*1.51152E+116473高二(13)1340*1.11152E+116370高二(10)1016*1.11152E+116270高二(14)1411*1.11152E+116170高二(04)418*1.21152E+116070高二(07)719*1.21152E+115970高二(05)522*1.21152E+115867高二(10)1023*1.21152E+115767高二(02)202*1.21152E+115667高二(13)1329*1.21152E+115567高二(11)1128*1.
32、21152E+115467高二(06)625*1.21152E+115364高二(09)911*1.31152E+115264高二(03)314*1.31152E+115164高二(08)837*1.31152E+115064高二(15)1534*1.31152E+114964高二(12)1222*1.31152E+114861高二(15)1503*1.31152E+114761高二(01)114*1.31152E+114661高二(01)133*1.31152E+114561高二(02)233*1.41152E+114461高二(03)336*1.41152E+114358高二(04)428
33、*1.41152E+114258高二(08)843*1.41152E+114158高二(12)1235*1.41152E+114058高二(09)918*1.51152E+113955高二(14)1429*1.11152E+113855高二(15)1516*1.11152E+113755高二(10)1005*1.11152E+113655高二(06)620*1.11152E+113555高二(01)112*1.11152E+113455高二(07)733*1.11152E+113355高二(13)1301*1.11152E+113255高二(11)1121*1.11152E+113152高二(
34、06)640*1.21152E+113052高二(07)724*1.21152E+112952高二(02)239*1.21152E+112852高二(04)403*1.21152E+112752高二(08)845*1.21152E+112652高二(14)1438*1.21152E+112552高二(12)1233*1.21152E+112449高二(11)1139*1.31152E+112349高二(01)128*1.31152E+112249高二(12)1240*1.31152E+112149高二(09)938*1.31152E+112049高二(06)624*1.31152E+11194
35、9高二(03)310*1.31152E+111846高二(10)1035*1.31152E+111746高二(13)1319*1.31152E+111646高二(15)1505*1.31152E+111543高二(13)1303*1.41152E+111443高二(09)926*1.41152E+111343高二(15)1527*1.41152E+111240高二(03)337*1.41152E+111140高二(10)1015*1.51152E+11100100高二(12)1204*1.51152E+119794高二(09)929*1.51152E+119491高二(06)622*1.511
36、52E+119188高二(04)434*1.51152E+118885高二(01)117*1.51152E+118582高二(11)1142*1.51152E+118282高二(07)741*1.51152E+117979高二(15)1532*1.11152E+117679高二(14)1417*1.11152E+117376高二(11)1141*1.11152E+117076高二(10)1040*1.11152E+116773高二(07)726*1.11152E+116473高二(09)923*1.11152E+116170高二(12)1219*1.21152E+115867高二(13)131
37、2*1.21152E+115567高二(14)1404*1.21152E+115264高二(15)1518*1.21152E+114964高二(06)642*1.21152E+114661高二(14)1430*1.21152E+114358高二(01)102*1.21152E+114058高二(04)416*1.21152E+113755高二(12)1220*1.21152E+113455高二(13)1333*1.21152E+113152高二(04)424*1.21152E+112852高二(07)720*1.31152E+112552高二(16)1603*1.31152E+112249高二
38、(09)944*1.31152E+111949高二(12)1218*1.31152E+111646高二(10)1044*1.31152E+111343高二(13)1322*1.31152E+11100100高二(06)644*1.31152E+119997高二(14)1415*1.31152E+119897高二(07)723*1.31152E+119794高二(09)920*1.31152E+119694高二(13)1310*1.41152E+119591高二(10)1025*1.41152E+119491高二(07)730*1.41152E+119391高二(04)411*1.51152E+
39、119291高二(09)924*1.51152E+119188高二(07)735*1.51152E+119088高二(10)1045*1.11152E+118988高二(04)436*1.11152E+118885高二(09)942*1.11152E+118785高二(07)744*1.11152E+118685高二(04)401*1.11152E+118582高二(09)941*1.21152E+118482高二(07)745*1.21152E+118382高二(14)1406*1.21152E+118282高二(11)1123*1.21152E+118182高二(09)922*1.2115
40、2E+118082高二(13)1313*1.21152E+117979高二(03)301*1.21152E+117879高二(15)1501*1.21152E+117779高二(04)413*1.21152E+117679高二(03)309*1.21152E+117579高二(02)230*1.31152E+117479高二(11)1136*1.31152E+117376高二(09)910*1.31152E+117276高二(01)113*1.31152E+117176高二(07)708*1.31152E+117076高二(06)619*1.31152E+116976高二(05)523*1.3
41、1152E+116873高二(14)1412*1.31152E+116773高二(10)1030*1.31152E+116673高二(13)1330*1.31152E+116573高二(12)1239*1.31152E+116473高二(16)1634*1.31152E+116370高二(08)842*1.31152E+116270高二(07)702*1.31152E+116170高二(03)305*1.31152E+116070高二(10)1011*1.31152E+115970高二(11)1111*1.41152E+115867高二(09)912*1.41152E+115767高二(04)
42、433*1.41152E+115667高二(10)1034*1.41152E+115567高二(02)203*1.41152E+115467高二(16)1627*1.51152E+115364高二(05)529*1.51152E+115264高二(06)604*1.51152E+115164高二(15)1515*1.51152E+115064高二(12)1234*1.51152E+114964高二(13)1306*1.51152E+114861高二(14)1405*1.51152E+114761高二(01)130*1.51152E+114661高二(08)806*1.51152E+114561
43、高二(07)742*1.51152E+114461高二(13)1338*1.51152E+114358高二(10)1026*1.51152E+114258高二(03)302*1.51152E+114158高二(01)104*1.51152E+114058高二(02)210*1.51152E+11100100高二(14)1426*1.51152E+119997高二(05)536*1.11152E+119897高二(13)1309*1.11152E+119794高二(04)404*1.11152E+119694高二(08)827*1.11152E+119591高二(09)932*1.21152E+
44、119491高二(07)736*1.21152E+119391高二(11)1115*1.21152E+119291高二(06)614*1.21152E+119188高二(05)541*1.21152E+119088高二(16)1611*1.21152E+118988高二(15)1528*1.31152E+118885高二(11)1106*1.31152E+118785高二(12)1214*1.31152E+118685高二(04)427*1.31152E+118582高二(16)1614*1.31152E+118482高二(14)1436*1.31152E+118382高二(06)629*1.
45、31152E+118282高二(15)1504*1.31152E+118182高二(11)1137*1.31152E+118082高二(10)1036*1.31152E+117979高二(03)307*1.31152E+117879高二(13)1336*1.31152E+117779高二(04)402*1.31152E+117679高二(05)544*1.31152E+117579高二(07)727*1.31152E+117479高二(12)1215*1.31152E+117376高二(01)136*1.41152E+117276高二(02)205*1.41152E+117176高二(09)9
46、37*1.51152E+117076高二(08)810*1.51152E+116976高二(15)1510*1.51152E+116873高二(12)1223*1.51152E+116773高二(04)432*1.51152E+116673高二(01)134*1.51152E+116573高二(04)441*1.51152E+116473高二(16)1620*1.51152E+116370高二(03)335*1.51152E+116270高二(14)1423*1.51152E+116170高二(03)342*1.51152E+116070高二(02)241*1.11152E+115970高二(
47、04)440*1.11152E+115867高二(14)1420*1.11152E+115767高二(16)1642*1.11152E+115667高二(09)935*1.11152E+115567高二(13)1326*1.11152E+115467高二(15)1537*1.11152E+115364高二(01)127*1.11152E+115264高二(14)1422*1.21152E+115164高二(16)1624*1.21152E+115064高二(04)435*1.21152E+114964高二(13)1341*1.21152E+114861高二(15)1539*1.21152E+1
48、14761高二(03)318*1.31152E+114661高二(02)206*1.31152E+114561高二(01)131*1.31152E+114461高二(01)144*1.31152E+114358高二(15)1536*1.31152E+114258高二(04)420*1.31152E+114158高二(13)1343*1.31152E+114058高二(02)236*1.31152E+11100100高二(03)343*1.31152E+119997高二(16)1629*1.31152E+119897高二(14)1444*1.31152E+119794高二(01)142*1.31
49、152E+119694高二(14)1441*1.31152E+119591高二(10)1041*1.31152E+119491高二(03)339*1.31152E+119391高二(15)1526*1.41152E+119291高二(13)1324*1.41152E+119188高二(01)140*1.41152E+119088高二(16)1622*1.41152E+118988高二(02)235*1.51152E+118885高二(04)422*1.51152E+118785高二(03)322*1.51152E+118685高二(14)1425*1.51152E+118582高二(02)22
50、3*1.51152E+118482高二(05)537*1.51152E+118382高二(15)1523*1.51152E+118282高二(04)426*1.51152E+118182高二(01)111*1.51152E+118082高二(16)1613*1.11152E+117979高二(13)1323*1.11152E+117879高二(03)319*1.11152E+117779高二(01)115*1.11152E+117679高二(16)1638*1.11152E+117579高二(02)242*1.11152E+117479高二(14)1424*1.21152E+117376高二(