Excel等级赋分一分一赋程序931.pdf

班级学号姓名考号技术赋分值高二(05)511*1111522004089291高二(09)931*1111522004099291 等级比例切分线累计人数高二(08)836*11115220041092911100973%9831高二(05)543*1111522004089189296943%9652高二(07)729*1111522004099089393914%9296高二(11)1135*1111522004108988490885%89136高二(09)906*1111522004088886587856%86180高二(10)1021*1111522004098886684827%80243高二(08)831*1111522004108786781798%74314高二(12)1231*1111522004088786878767%69373高二(10)1029*1111522004098786975737%64433高二(06)615*11115220041087861072707%59491高二(11)1116*11115220040887861169677%54551高二(09)921*11115220040987861266647%49610高二(05)525*11115220041087861363617%44669高二(12)1232*11115220040886851460586%40717高二(08)828*1111522004091001001557555%32755高二(10)1001*11115220041099991654524%25789高二(07)703*11115220040898971751493%19818高二(06)606*11115220040997951848462%16832高二(12)1205*11115220041096941945431%13843高二(03)303*11115220040895932042401%11849高二(06)631*1111522004099492高二(10)1033*1111522004109392高二(11)1107*1111522004089291高二(09)917*1111522004099189高二(05)516*1111522004109089高二(07)709*1111522004088988高二(08)833*1111522004098886高二(06)628*1111522004108786高二(10)1004*1111522004088685高二(09)914*111152200409根据浙江省最新一分一赋要求编写。说明：使用前需要启用“宏”。点击“工具-宏-安全性”设置为“中”，然后关闭重新打开，启用宏即可。考号和分数数据必须有，其他可以留空。等级分区间赋分计算清空总人数 849高二(12)1225*111152200410考号和分数数据必须有，其他可以留空。比例可以自行修改！高二(08)820*111152200408高二(05)521*111152200409高二(12)1201*111152200410高二(11)1103*111152200408高二(07)717*1111522004097981高二(12)1210*1111522004107880高二(11)1127*1111522004087780高二(09)908*1111522004097680高二(06)611*1111522004107579高二(08)815*1111522004087479高二(08)801*1111522004097378高二(07)732*1111522004107277高二(10)1031*1111522004087177高二(05)503*1111522004097076高二(10)1022*1111522004106976高二(11)1104*1111522004086875高二(08)807*1111522004096774高二(12)1226*1111522004106674高二(07)728*1111522004086573高二(06)632*1111522004096473高二(09)930*1111522004106372高二(11)1101*1111522004086271高二(05)513*1111522004096171高二(11)1108*1111522004106070高二(09)916*1111522004085970高二(07)707*1111522004095869高二(06)608*1111522004105768高二(08)829*1111522004085668Excel 2007以上版本启用宏方法，请自己百度！程序设计：杜宗飞高二(12)1202*1111522004095567高二(10)1028*1111522004105467高二(05)507*1111522004085366高二(09)934*1111522004095265高二(15)1511*1111522004105165高二(10)1014*1111522004085064高二(11)1125*1111522004094964高二(08)804*1111522004104863高二(05)533*1111522004084762高二(06)630*1111522004094662高二(07)701*1111522004104561高二(12)1228*1111522004084461高二(10)1027*1111522004094360高二(07)704*1111522004104259高二(11)1110*1111522004084159高二(09)928*1111522004094058高二(12)1227*1111522004103957高二(08)834*1111522004083857高二(05)534*1111522004093756高二(06)607*1111522004103656高二(09)901*1111522004083556高二(01)116*1111522004093456高二(09)902*1111522004103355高二(14)1407*1111522004083255高二(08)822*1111522004093154高二(07)734*1111522004103053高二(11)1132*1111522004082953高二(05)512*1111522004092853高二(08)839*1111522004102753高二(11)1118*1111522004082652高二(05)505*1111522004092552高二(08)802*1111522004102451高二(11)1112*1111522004082350高二(05)540*1111522004092250高二(08)811*1111522004102150高二(08)811*1111522004082049高二(11)1124*1111522004091949高二(11)1124*1111522004101847高二(11)1102*1111522004081747高二(11)1102*1111522004098082高二(05)508*1111522004107880高二(05)508*1111522004087680高二(11)1119*1111522004097479高二(11)1119*1111522004107277高二(08)803*1111522004087076高二(08)803*1111522004096875高二(06)634*1111522004106674高二(06)634*1111522004086473高二(11)1131*1111522004096271高二(11)1131*1111522004106070高二(08)814*1111522004085869高二(08)814*1111522004095668高二(07)713*1111522004105467高二(07)713*1111522004085265高二(06)623*1111522004095064高二(06)623*1111522004104863高二(10)1018*1111522004084662高二(10)1018*1111522004094461高二(12)1213*1111522004104259高二(12)1213*1111522004084058高二(05)530*1111522004093857高二(05)530*1111522004103656高二(05)509*1111522004083456高二(05)509*1111522004093255高二(06)612*1111522004103053高二(06)612*1111522004082853高二(10)1019*1111522004092652高二(10)1019*1111522004102451高二(12)1208*1111522004082250高二(12)1208*1111522004092049高二(05)532*1111522004101847高二(05)532*1111522004081646高二(11)1129*1111522004091444高二(11)1129*1111522004101241高二(08)838*1111522004089089高二(08)838*1111522004098988高二(07)705*1111522004108886高二(07)705*1111522004088786高二(10)1007*1111522004098685高二(10)1007*1111522004108584高二(05)518*1111522004088483高二(05)518*1111522004098383高二(12)1206*1111522004108283高二(12)1206*1111522004088182高二(07)738*1111522004098082高二(07)738*1111522004107981高二(11)1113*1111522004087880高二(11)1113*1111522004097780高二(08)805*1111522004107680高二(08)805*1111522004087579高二(12)1209*1111522004097479高二(12)1209*1111522004107378高二(06)609*1111522004087277高二(06)609*1111522004097177高二(05)506*1111522004107076高二(05)506*1111522004086976高二(10)1008*1111522004096875高二(10)1008*1111522004106774高二(09)943*1111522004086674高二(09)943*1111522004096573高二(12)1236*1111522004106473高二(12)1236*1111522004086372高二(11)1126*1111522004096271高二(11)1126*1111522004106171高二(06)627*1111522004086070高二(06)627*1111522004095970高二(07)721*1111522004105869高二(07)721*1111522004085768高二(08)816*1111522004095668高二(08)816*1111522004105567高二(06)626*1111522004085467高二(06)626*1111522004095366高二(09)913*1111522004105265高二(09)913*1111522004085165高二(06)616*1111522004095064高二(06)616*1111522004104964高二(11)1122*1111522004084863高二(11)1122*1111522004094762高二(07)716*1111522004104662高二(07)716*1111522004084561高二(05)527*1111522004094461高二(05)527*1111522004104360高二(08)808*1111522004084259高二(08)808*1111522004094159高二(12)1245*1111522004104058高二(12)1245*1111522004083957高二(14)1401*1111522004093857高二(14)1401*1111522004103756高二(10)1013*1111522004083656高二(10)1013*1111522004093556高二(09)904*1111522004103456高二(09)904*1111522004083355高二(06)613*1111522004093255高二(05)526*1111522004103154高二(10)1009*1111522004083053高二(07)712*1111522004092953高二(08)840*1111522004102853高二(11)1138*1111522004082753高二(12)1229*1111522004092652高二(07)711*1111522004102552高二(04)405*1111522004082451高二(10)1038*1111522004092350高二(08)821*1111522004102250高二(09)903*1111522004082150高二(05)519*1111522004092049高二(12)1211*1111522004101949高二(11)1117*1111522004081847高二(06)605*1111522004091747高二(11)1109*1111522004101646高二(06)601*1111522004081544高二(09)907*1111522004091444高二(05)501*1111522004101343高二(05)528*1111522004081241高二(08)824*1111522004091140高二(07)722*111152200410100100高二(10)1012*1111522004089999高二(12)1212*1111522004099897高二(11)1130*1111522004109795高二(06)610*1111522004089694高二(10)1002*1111522004099593高二(12)1203*1111522004109492高二(07)725*1111522004089392高二(07)710*1111522004099291高二(01)132*1111522004109189高二(03)329*1111522004089089高二(12)1207*1111522004098988高二(08)809*1111522004108886高二(01)139*1111522004088786高二(11)1105*1111522004098685高二(03)332*1111522004108584高二(13)1311*1111522004088483高二(10)1039*1111522004098383高二(07)731*1111522004108283高二(14)1413*1111522004088182高二(16)1631*1111522004098082高二(16)1631*1111522004107981高二(06)617*1111522004087880高二(06)617*1111522004097780高二(01)101*1111522004107680高二(01)101*1111522004087579高二(09)925*1111522004097479高二(09)925*1111522004107378高二(02)215*1111522004087277高二(02)215*1111522004097177高二(04)415*1111522004107076高二(04)415*1111522004086976高二(13)1305*1111522004096875高二(13)1305*1111522004106774高二(10)1010*1111522004086674高二(10)1010*1111522004096573高二(07)737*1111522004106473高二(07)737*1111522004086372高二(11)1114*1111522004096271高二(11)1114*1111522004106171高二(09)936*1111522004086070高二(09)936*1111522004095970高二(12)1224*1111522004105869高二(12)1224*1111522004085768高二(15)1508*1111522004095668高二(15)1508*1111522004105567高二(06)645*1111522004085467高二(06)645*1111522004095366高二(06)635*1111522004105265高二(06)635*1111522004085165高二(03)306*1111522004095064高二(03)306*1111522004104964高二(14)1437*1111522004084863高二(14)1437*1111522004094762高二(02)208*1111522004104662高二(02)208*1111522004084561高二(01)123*1111522004094461高二(01)123*1111522004104360高二(08)841*1111522004084259高二(08)841*1111522004094159高二(16)1601*1111522004104058高二(16)1601*1111522004083957高二(09)945*1111522004093857高二(09)945*1111522004103756高二(03)315*1111522004083656高二(11)1140*1111522004093556高二(02)201*1111522004103456高二(13)1328*1111522004083355高二(14)1410*1111522004093255高二(04)431*1111522004103154高二(10)1032*1111522004083053高二(02)204*1111522004092953高二(12)1242*1111522004102853高二(01)135*1111522004082753高二(15)1506*1111522004092652高二(06)603*1111522004102552高二(16)1626*1111522004082451高二(08)817*1111522004092350高二(07)715*1111522004102250高二(08)818*1111522004082150高二(10)1020*1111522004092049高二(16)1610*1111522004101949高二(15)1531*1111522004081847高二(11)1145*1111522004091747高二(12)1230*1111522004101646高二(09)933*1111522004081544高二(08)835*1111522004091444高二(06)636*1111522004101343高二(09)919*1111522004081241高二(03)341*1111522004091140高二(04)437*111152200410100100高二(01)107*1111522004089999高二(13)1335*1111522004099897高二(07)718*1111522004109795高二(14)1403*1111522004089694高二(02)228*1111522004099593高二(09)909*1111522004109492高二(02)217*1111522004089392高二(14)1414*1111522004099291高二(16)1602*1111522004109189高二(03)316*1111522004089089高二(10)1006*1111522004098988高二(15)1502*1111522004108886高二(12)1244*1111522004088786高二(16)1636*1111522004098685高二(01)105*1111522004108584高二(07)739*1111522004088483高二(13)1314*1111522004098383高二(04)414*1111522004108283高二(06)639*1111522004088182高二(10)1017*1111522004098082高二(11)1143*1111522004107981高二(08)823*1111522004087880高二(07)743*1111522004097780高二(03)330*1111522004107680高二(16)1604*1111522004087579高二(12)1238*1111522004097479高二(06)618*1111522004107378高二(11)1120*1111522004087277高二(08)825*1111522004097177高二(01)110*1111522004107076高二(02)216*1111522004086976高二(02)211*1111522004096875高二(15)1513*1111522004106774高二(14)1408*1111522004086674高二(09)905*1111522004096573高二(04)430*1111522004106473高二(13)1340*1111522004086372高二(10)1016*1111522004096271高二(14)1411*1111522004106171高二(04)418*1111522004086070高二(07)719*1111522004095970高二(05)522*1111522004105869高二(10)1023*1111522004085768高二(02)202*1111522004095668高二(13)1329*1111522004105567高二(11)1128*1111522004085467高二(06)625*1111522004095366高二(09)911*1111522004105265高二(03)314*1111522004085165高二(08)837*1111522004095064高二(15)1534*1111522004104964高二(12)1222*1111522004084863高二(15)1503*1111522004094762高二(01)114*1111522004104662高二(01)133*1111522004084561高二(02)233*1111522004094461高二(03)336*1111522004104360高二(04)428*1111522004084259高二(08)843*1111522004094159高二(12)1235*1111522004104058高二(09)918*1111522004083957高二(14)1429*1111522004093857高二(15)1516*1111522004103756高二(10)1005*1111522004083656高二(06)620*1111522004093556高二(01)112*1111522004103456高二(07)733*1111522004083355高二(13)1301*1111522004093255高二(11)1121*1111522004103154高二(06)640*1111522004083053高二(07)724*1111522004092953高二(02)239*1111522004102853高二(04)403*1111522004082753高二(08)845*1111522004092652高二(14)1438*1111522004102552高二(12)1233*1111522004082451高二(11)1139*1111522004092350高二(01)128*1111522004102250高二(12)1240*1111522004082150高二(09)938*1111522004092049高二(06)624*1111522004101949高二(03)310*1111522004081847高二(10)1035*1111522004091747高二(13)1319*1111522004101646高二(15)1505*1111522004081544高二(13)1303*1111522004091444高二(09)926*1111522004101343高二(15)1527*1111522004081241高二(03)337*1111522004091140高二(10)1015*111152200410100100高二(12)1204*1111522004089795高二(09)929*1111522004099492高二(06)622*1111522004109189高二(04)434*1111522004088886高二(01)117*1111522004098584高二(11)1142*1111522004108283高二(07)741*1111522004087981高二(15)1532*1111522004097680高二(14)1417*1111522004107378高二(11)1141*1111522004087076高二(10)1040*1111522004096774高二(07)726*1111522004106473高二(09)923*1111522004086171高二(12)1219*1111522004095869高二(13)1312*1111522004105567高二(14)1404*1111522004085265高二(15)1518*1111522004094964高二(06)642*1111522004104662高二(14)1430*1111522004084360高二(01)102*1111522004094058高二(04)416*1111522004103756高二(12)1220*1111522004083456高二(13)1333*1111522004093154高二(04)424*1111522004102853高二(07)720*1111522004082552高二(16)1603*1111522004092250高二(09)944*1111522004101949高二(12)1218*1111522004081646高二(10)1044*1111522004091343高二(13)1322*111152200410100100高二(06)644*1111522004089999高二(14)1415*1111522004099897高二(07)723*1111522004109795高二(09)920*1111522004089694高二(13)1310*1111522004099593高二(10)1025*1111522004109492高二(07)730*1111522004089392高二(04)411*1111522004099291高二(09)924*1111522004109189高二(07)735*1111522004089089高二(10)1045*1111522004098988高二(04)436*1111522004108886高二(09)942*1111522004088786高二(07)744*1111522004098685高二(04)401*1111522004108584高二(09)941*1111522004088483高二(07)745*1111522004098383高二(14)1406*1111522004108283高二(11)1123*1111522004088182高二(09)922*1111522004098082高二(13)1313*1111522004107981高二(03)301*1111522004087880高二(15)1501*1111522004097780高二(04)413*1111522004107680高二(03)309*1111522004087579高二(02)230*1111522004097479高二(11)1136*1111522004107378高二(09)910*1111522004087277高二(01)113*1111522004097177高二(07)708*1111522004107076高二(06)619*1111522004086976高二(05)523*1111522004096875高二(14)1412*1111522004106774高二(10)1030*1111522004086674高二(13)1330*1111522004096573高二(12)1239*1111522004106473高二(16)1634*1111522004086372高二(08)842*1111522004096271高二(07)702*1111522004106171高二(03)305*1111522004086070高二(10)1011*1111522004095970高二(11)1111*1111522004105869高二(09)912*1111522004085768高二(04)433*1111522004095668高二(10)1034*1111522004105567高二(02)203*1111522004085467高二(16)1627*1111522004095366高二(05)529*1111522004105265高二(06)604*1111522004085165高二(15)1515*1111522004095064高二(12)1234*1111522004104964高二(13)1306*1111522004084863高二(14)1405*1111522004094762高二(01)130*1111522004104662高二(08)806*1111522004084561高二(07)742*1111522004094461高二(13)1338*1111522004104360高二(10)1026*1111522004084259高二(03)302*1111522004094159高二(01)104*1111522004104058高二(02)210*111152200408100100高二(14)1426*1111522004099999高二(05)536*1111522004109897高二(13)1309*1111522004089795高二(04)404*1111522004099694高二(08)827*1111522004109593高二(09)932*1111522004089492高二(07)736*1111522004099392高二(11)1115*1111522004109291高二(06)614*1111522004089189高二(05)541*1111522004099089高二(16)1611*1111522004108988高二(15)1528*1111522004088886高二(11)1106*1111522004098786高二(12)1214*1111522004108685高二(04)427*1111522004088584高二(16)1614*1111522004098483高二(14)1436*1111522004108383高二(06)629*1111522004088283高二(15)1504*1111522004098182高二(11)1137*1111522004108082高二(10)1036*1111522004087981高二(03)307*1111522004097880高二(13)1336*1111522004107780高二(04)402*1111522004087680高二(05)544*1111522004097579高二(07)727*1111522004107479高二(12)1215*1111522004087378高二(01)136*1111522004097277高二(02)205*1111522004107177高二(09)937*1111522004087076高二(08)810*1111522004096976高二(15)1510*1111522004106875高二(12)1223*1111522004086774高二(04)432*1111522004096674高二(01)134*1111522004106573高二(04)441*1111522004086473高二(16)1620*1111522004096372高二(03)335*1111522004106271高二(14)1423*1111522004086171高二(03)342*1111522004096070高二(02)241*1111522004105970高二(04)440*1111522004085869高二(14)1420*1111522004095768高二(16)1642*1111522004105668高二(09)935*1111522004085567高二(13)1326*1111522004095467高二(15)1537*1111522004105366高二(01)127*1111522004085265高二(14)1422*1111522004095165高二(16)1624*1111522004105064高二(04)435*1111522004084964高二(13)1341*1111522004094863高二(15)1539*1111522004104762高二(03)318*1111522004084662高二(02)206*1111522004094561高二(01)131*1111522004104461高二(01)144*1111522004084360高二(15)1536*1111522004094259高二(04)420*1111522004104159高二(13)1343*1111522004084058高二(02)236*111152200409100100高二(03)343*1111522004109999高二(16)1629*1111522004089897高二(14)1444*1111522004099795高二(01)142*1111522