蛇形分班到随机均衡(含身份证）.xls

1、分班数 6男女身份证姓名性别成绩排名 男女排名 0.6801 10.223 431432457841128411吴三男34511男1 0.4166 40.035 634624579821334142庄四女24121女1 0.0234 60.199 536511477454557544施五男24132男2 0.6683 20.807 1321 0.4741 30.365 2332 0.06450.231 3353 0.5026 40.487 39109 0.8203 20.1769812 0.9254 10.173 59711 0.6941 30.917 1997 0.4447 50.496 2

2、9118 0.3953 60.275 491210 0.1446 50.341 5151717 0.6298 30.288 6151518 0.2165 40.942 1151613 0.0539 60.524151816 0.9759 10.766 3151315 0.7693 20.784 2151414 0.4373 30.551 3212121 0.2247 50.369 5212323 0.8361 10.118 6211924 0.6794 20.996 1212019 0.0828 60.414212422 0.3375 40.832 2212220 0.4375 30.057

3、5272729 0.3169 50.038 6272930 0.5979 20.075 4272628 0.8501 10.649 2272526 0.2334 60.654 1273025 0.4032 40.598 3272827 0.7327 10.554 2333132 0.6837 20.016 6333236 0.0219 60.418 3333633 0.2554 40.044 5333435 0.2844 30.759 1333331 0.0483 50.332 4333534 0.37840.893 1394037 0.4362 35E-04 6393942 0.4846 2

4、0.312 4393840 0.9191 10.177 5393741 0.1156 60.395 3394239 0.3033 50.551 2394138 0.9105 10.296 5454347 0.6443 30.572 2454544 0.6707 20.516 3454445 0.2494 60.649 1454843 0.6313 40.469 4454646 0.4985 50.097 6454748 0.6055 20.806 1515049 0.3363 30.011 6515154 0.1032 60.182 4515452 0.1925 40.448 2515250

5、0.1745 50.351 3515351 0.6998 10.092 5514953 0.2533 50.055 6575960 0.2192 60.142 4576058 0.7645 10.259 3575557 0.5097 20.706 1575655 0.4093 30.638 2575756 0.3773 40.127 5575859 0.9149 20.067 6636266 0.1657 60.809 2636662 0.9598 10.181 5636165 0.1954 50.664 4636564 0.7767 30.751 3636363 0.24640.848 16

6、36461 0.44850.757 3697169 0.2353 60.642 5697271 0.8871 40.939 1697067 0.8873 30.772696968 0.9641 10.723 4696770 0.9575 20.495 6696872 0.0083 60.545 4757876 0.9436 10.661 2757374 0.5418 20.001 6757478 0.24550.596 3757775 0.4394 40.269 5757677 0.5016 30.982 1757573 0.8355 20.699 2818080 0.7115 40.552

7、3818281 0.7941 30.485 4818182 0.9541 10.91817979 0.6079 50.294 5818383 0.4864 60.015 6818484 0.1153 40.384878888 0.9231 20.139 5878689 0.0019 60.959 1879085 0.9576 10.782 2878586 0.4613 30.392 3878787 0.1095 50.055 6878990 0.1229 60.843 2939692 0.3127 40.596 5939495 0.8586 20.646 4939294 0.40430.757

8、 3939393 0.2264 50.16939596 0.8989 111939191 0.8766 10.249997100 0.1995 50.929 199 10197 0.3736 20.722 3999899 0.2119 40.084 699 100 102 0.0273 60.178 599 102 101 0.2497 30.907 2999998 0.1489 50.773 1 105 107 103 0.6945 30.561 2 105 105 104 0.8267 10.277 5 105 103 107 0.0141 60.499 4 105 108 106 0.7

9、0920.506 3 105 104 105 0.2482 40.268 6 105 106 108 0.1563 50.466 3 111 113 111 0.6009 20.315 4 111 110 112 0.4606 30.067 6 111 111 114 0.3632 40.138 5 111 112 113 0.12460.781 111 114 109 0.7023 10.541 2 111 109 110 0.7349 20.286 117 116 120 0.44950.862 117 119 116 0.2026 60.573 4 117 120 118 0.72830

10、.376 5 117 117 119 0.7549 10.985 1 117 115 115 0.5247 40.748 3 117 118 117 0.2723 60.433 123 126 123 0.9976 10.034 5 123 121 125 0.7037 40.635 2 123 124 122 0.7665 30.906 1 123 123 121 0.2802 50.031 6 123 125 126 0.8673 20.318 4 123 122 124 0.1188 60.594 3 129 132 129 0.3645 50.891 129 131 127 0.739

11、5 20.475 4 129 128 130 0.7391 30.872 129 129 128 0.8905 10.064 6 129 127 132 0.7378 40.098 5 129 130 131 0.68220.614 2 135 134 134 0.4607 40.359 5 135 136 137 0.8131 10.654 1 135 133 133 0.6387 30.569 3 135 135 135 0.15850.499 4 135 137 136 0.1122 60.126 135 138 138 0.6305 20.141 5 141 140 143 0.060

12、4 60.16 141 144 144 0.9494 10.662 141 139 140 0.1743 40.744 1 141 142 139 0.16750.542 3 141 143 141 0.4671 30.207 4 141 141 142 0.2498 40.085 147 148 149 0.6506 20.174 147 146 148 0.1374 60.699 1 147 150 145 0.8566 10.378 3 147 145 147 0.5181 30.612 2 147 147 146 0.2196 50.007 6 147 149 150 0.0657 5

13、0.708 2 153 155 152 0.8188 20.691 4 153 152 154 0.0185 60.772 1 153 156 151 0.8676 10.692 3 153 151 153 0.6712 30.438 5 153 153 155 0.2439 40.393 6 153 154 156 0.7172 10.796 1 159 157 157 0.2521 50.692 2 159 161 158 0.2027 60.177 5 159 162 161 0.4325 40.151 6 159 160 162 0.6055 20.229 3 159 158 159

14、0.4403 30.189 4 159 159 160 0.7111 20.627 2 165 164 164 0.62650.256 165 167 168 0.6836 30.539 3 165 165 165 0.6554 40.338 4 165 166 166 0.74410.325 165 163 167 0.0486 60.737 1 165 168 163 0.1082 60.667 2 171 174 170 0.7505 30.115 6 171 171 174 0.6662 40.709 1 171 172 169 0.7998 20.349 5 171 170 173

15、0.6152 50.657 3 171 173 171 0.8782 10.436 4 171 169 172 0.06860.713 177 180 177 0.4571 20.926 2 177 176 176 0.7932 10.939 1 177 175 175 0.2019 40.484 5 177 178 179 0.0734 50.055 6 177 179 180 0.3064 30.697 4 177 177 178 0.8554 10.051 6 183 181 186 0.4491 50.325 3 183 185 183 0.5681 40.81 183 184 181

16、 0.3804 60.197 4 183 186 184 0.6757 20.057 5 183 182 185 0.59230.642 2 183 183 182 0.6167 40.409 5 189 190 191 0.5493 50.452 4 189 191 190 0.1527 60.893 2 189 192 188 0.7471 20.718 3 189 188 189 0.6532 30.924 1 189 189 187 0.99510.145 6 189 187 192 0.2944 50.808 1 195 197 193 0.6865 20.302 5 195 194

17、 197 0.6682 30.544 2 195 195 194 0.4643 40.067 6 195 196 198 0.16560.481 3 195 198 195 0.9613 10.446 4 195 193 196 0.3826 50.123 6 201 203 204 0.5824 20.209 5 201 200 203 0.7824 10.536 3 201 199 201 0.1289 60.424 201 204 202 0.5107 30.539 2 201 201 200 0.4216 40.827 1 201 202 199 0.15450.201 5 207 2

18、09 209 0.6065 30.314 4 207 207 208 0.6717 10.817 1 207 205 205 0.3637 40.051 6 207 208 210 0.6658 20.355 3 207 206 207 0.0385 60.387 2 207 210 206 0.3528 30.365 213 213 215 0.0206 60.652 213 216 212 0.4007 20.637 3 213 212 213 0.1785 40.655 1 213 214 211 0.5979 10.367 4 213 211 214 0.1622 50.126 213

19、 215 216 0.1343 50.354 219 221 220 0.8303 10.997 1 219 217 217 0.3459 40.302 5 219 220 221 0.7834 20.244 6 219 218 222 0.4143 30.682 3 219 219 219 0.0203 60.751 2 219 222 218 0.4884 20.651 4 225 224 226 0.2021 40.802 2 225 226 224 0.7777 10.733 225 223 225 0.3701 30.019 6 225 225 228 0.2007 50.964 1

20、 225 227 223 0.1453 60.45 225 228 227 0.8707 30.622 5 231 231 233 0.2959 40.738 1 231 232 229 0.8944 20.701 2 231 230 230 0.0329 60.108 6 231 234 234 0.9554 10.643 3 231 229 231 0.2515 50.634 231 233 232 0.8497 10.439 5 237 235 239 0.7679 20.176 237 236 240 0.0484 50.778 4 237 239 238 0.1465 40.981

21、1 237 238 235 0.00360.862 2 237 240 236 0.1739 30.818 3 237 237 237 0.9795 10.747 3 243 241 243 0.3925 50.775 2 243 245 242 0.5881 30.703 4 243 243 244 0.2557 60.907 1 243 246 241 0.4769 40.194 6 243 244 246 0.95320.384 5 243 242 245 0.7347 10.884 1 249 247 247 0.4501 30.669 4 249 249 250 0.1868 40.

22、728 3 249 250 249 0.4774 20.838 2 249 248 248 0.1383 60.511 5 249 252 251 0.1856 50.067 6 249 251 252 0.9735 10.483 6 255 253 258 0.2732 50.874 2 255 257 254 0.8748 20.535 5 255 254 257 0.87330.735 4 255 255 256 0.6417 40.753 3 255 256 255 0.0783 60.967 1 255 258 253 0.2809 50.574 2 261 263 260 0.18

23、26 60.435 3 261 264 261 0.6807 40.028 6 261 262 264 0.9666 10.968 1 261 259 259 0.8585 20.319 4 261 260 262 0.7231 30.228 5 261 261 263 0.5667 50.801 2 267 269 266 0.61540.076 6 267 268 270 0.7975 20.954 1 267 266 265 0.6189 30.287 4 267 267 268 0.9373 10.145 5 267 265 269 0.06460.657 3 267 270 267

24、0.3721 50.683 273 275 273 0.98710.354 6 273 271 276 0.9813 20.443 5 273 272 275 0.2377 60.812 273 276 272 0.5291 40.507 4 273 274 274 0.9548 30.961 1 273 273 271 0.0687 50.138 5 279 281 281 0.3615 30.846 1 279 279 277 0.04760.219 4 279 282 280 0.1024 40.639 2 279 280 278 0.9844 10.004 6 279 277 282

25、0.71620.293 3 279 278 279 0.4423 30.698 1 285 285 283 0.2591 50.497 2 285 287 284 0.0643 60.274 5 285 288 287 0.9296 10.126 285 283 288 0.3140.324 4 285 286 286 0.7264 20.382 3 285 284 285 0.5395 20.033 5 291 290 293 0.0645 60.758 1 291 294 289 0.1883 50.509 2 291 293 290 0.4611 30.217 3 291 291 291

26、 0.4076 40.006 6 291 292 294 0.6061 10.164 4 291 289 292 0.2778 50.601 3 297 299 297 0.8486 20.368 6 297 296 300 0.33740.412 5 297 298 299 0.65230.514 4 297 297 298 0.8884 10.892 1 297 295 295 0.0109 60.699 2 297 300 296 0.98910.552 3 303 301 303 0.7416 40.616 2 303 304 302 0.6067 60.395 5 303 306 3

27、05 0.73850.981 303 305 301 0.7826 20.266 6 303 302 306 0.7544 30.546 4 303 303 304 0.5566 60.634 2 309 312 308 0.9506 10.863 1 309 307 307 0.6551 50.559 4 309 311 310 0.7467 40.606 3 309 310 309 0.9111 30.091 6 309 309 312 0.9463 20.203 5 309 308 311 0.4207 40.775 2 315 316 314 0.66730.283 6 315 315

28、 318 0.07650.616 4 315 317 316 0.0574 60.663 315 318 315 0.6936 20.897 1 315 314 313 0.70410.521 5 315 313 317 0.2347 50.679 2 321 323 320 0.8610.921 321 319 319 0.7593 20.304 4 321 320 322 0.6202 40.065 321 322 323 0.7188 30.572 3 321 321 321 0.0499 60.051 6 321 324 324 0.5036 60.318 6 327 330 330

29、0.82930.741 2 327 327 326 0.9626 10.731 3 327 325 327 0.8156 40.646 4 327 328 328 0.7837 50.746 1 327 329 325 0.89220.374 5 327 326 329 0.8104 10.068 6 333 331 336 0.2476 40.977 1 333 334 331 0.47620.723 3 333 332 333 0.4063 30.094 5 333 333 335 0.0788 60.34 333 336 334 0.1662 50.788 2 333 335 332 0

30、.2281 30.508 5 339 339 341 0.1135 40.768 3 339 340 339 0.9251 10.921 1 339 337 337 0.0376 60.507 6 339 342 342 0.0971 50.668 4 339 341 340 0.3656 20.778 2 339 338 338 0.5369 30.176 6 345 345 348 0.4199 50.733 1 345 347 343 0.8218 10.566 3 345 343 345 0.4959 40.432 4 345 346 346 0.0416 60.653 2 345 3

31、48 344 0.7617 20.367 5 345 344 347 0.2176 40.136 5 351 352 353 0.0689 60.596 2 351 354 350 0.0750.971 351 353 349 0.2609 30.003 6 351 351 354 0.8461 10.282 3 351 349 351 0.6852 20.186 4 351 350 352 0.3617 50.989 1 357 359 355 0.5683 40.929 2 357 358 356 0.9921 10.187 6 357 355 360 0.7411 20.553 5 35

32、7 356 359 0.6758 30.635 4 357 357 358 0.2957 60.817 3 357 360 357 0.5097 30.688 3 363 363 363 0.3808 40.238 5 363 364 365 0.8593 10.646 4 363 361 364 0.2438 60.045 6 363 366 366 0.3079 50.792 2 363 365 362 0.6548 20.797 1 363 362 361 0.0303 60.007 6 369 372 372 0.0988 50.669 3 369 371 369 0.3408 20.

33、488 4 369 368 370 0.9895 10.825 2 369 367 368 0.2426 30.211 5 369 369 371 0.1961 40.985 1 369 370 367 0.5589 20.405 6 375 374 378 0.0960.406 5 375 378 377 0.4528 30.802 1 375 375 373 0.2873 40.641 4 375 376 376 0.2084 50.801 2 375 377 374 0.7671 10.734 3 375 373 375 0.2603 40.954 2 381 382 380 0.390

34、5 30.955 1 381 381 379 0.1884 60.403 5 381 384 383 0.8194 10.285 6 381 379 384 0.4849 20.783 3 381 380 381 0.2229 50.406 4 381 383 382 0.57630.903 1 387 387 385 0.5078 40.023 6 387 388 390 0.3556 50.195 387 389 389 0.1393 60.725 2 387 390 386 0.9459 10.261 4 387 385 388 0.7713 20.521 3 387 386 387 0

35、.4435 40.675 2 393 394 392 0.6711 30.227 5 393 393 395 0.9015 10.506 4 393 391 394 0.2821 60.795 1 393 396 391 0.8683 20.589 3 393 392 393 0.4211 50.219 6 393 395 396 0.9307 10.647 2 399 397 398 0.3047 40.422 5 399 400 401 0.7001 20.458 4 399 398 400 0.2855 50.521 3 399 401 399 0.1802 60.371 6 399 4

36、02 402 0.6648 30.673 1 399 399 397 0.85610.746 2 405 403 404 0.5949 20.564 3 405 404 405 0.4554 50.995 1 405 407 403 0.5936 30.131 5 405 405 407 0.3262 60.336 4 405 408 406 0.5643 40.044 6 405 406 408 0.8803 10.452 3 411 409 411 0.2885 60.238 6 411 414 414 0.4668 20.372 4 411 410 412 0.2887 50.834 1

37、 411 413 409 0.3013 40.314 5 411 412 413 0.4266 30.742 2 411 411 410 0.1606 40.699 4 417 418 418 0.0454 60.845 2 417 420 416 0.4724 20.657 5 417 416 419 0.2467 30.934 1 417 417 415 0.5517 10.801 3 417 415 417 0.1021 50.158 6 417 419 420 0.3571 50.653 3 423 425 423 0.5743 40.096 6 423 424 426 0.6517

38、20.451 4 423 422 424 0.98810.865 2 423 421 422 0.3098 60.918 1 423 426 421 0.6330.275 423 423 425 0.8948 20.674 4 429 428 430 0.92410.875 1 429 427 427 0.6919 30.311 6 429 429 432 0.4891 40.747 3 429 430 429 0.1635 50.643 5 429 431 431 0.0122 60.747 2 429 432 428 0.2716 40.741 3 435 436 435 0.2095 5

39、0.995 1 435 437 433 0.4081 30.878 2 435 435 434 0.5498 20.094 6 435 434 438 0.5524 10.145 435 433 437 0.1478 60.555 4 435 438 436 0.4524 50.489 3 441 443 441 0.8468 20.282 5 441 440 443 0.6664 30.052 6 441 441 444 0.6149 40.388 4 441 442 442 0.9455 10.766 1 441 439 439 0.1757 60.748 2 441 444 440 0.

40、3907 50.146 3 447 449 447 0.7466 10.492 1 447 445 445 0.5278 30.004 6 447 447 450 0.4709 40.467 2 447 448 446 0.6033 20.028 5 447 446 449 0.2564 60.069 4 447 450 448 0.0116 50.762 2 453 455 452 0.0076 60.139 5 453 456 455 0.8851 10.082 6 453 451 456 0.6811 30.603 4 453 453 454 0.8304 20.754 3 453 45

41、2 453 0.6108 40.982 1 453 454 451 0.5542 20.052 6 459 458 462 0.0783 50.264 459 461 460 0.0031 60.133 5 459 462 461 0.3362 40.349 2 459 460 458 0.7152 10.302 3 459 457 459 0.5297 30.792 1 459 459 457 0.6435 30.709 4 465 465 466 0.2626 60.131 6 465 468 468 0.5002 40.246 5 465 466 467 0.8910.799 2 465

42、 463 464 0.6939 20.874 1 465 464 463 0.3701 50.787 3 465 467 465 0.3151 60.231 5 471 474 473 0.6711 20.306 4 471 470 472 0.6168 30.933 1 471 471 469 0.7161 10.879 2 471 469 470 0.5936 40.442 3 471 472 471 0.5268 50.207 6 471 473 474 0.4636 30.068 6 477 477 480 0.2059 40.618 2 477 478 476 0.9522 10.5

43、89 3 477 475 477 0.5915 20.563 4 477 476 478 0.1475 50.941 477 479 475 0.04460.141 5 477 480 479 0.0877 60.795 2 483 486 482 0.2246 40.804 1 483 484 481 0.2126 50.128 6 483 485 486 0.9958 10.619 4 483 481 484 0.5778 20.285 483 482 485 0.35330.675 3 483 483 483 0.2295 30.388 5 489 489 491 0.0515 50.8

44、53 1 489 491 487 0.0274 60.691 2 489 492 488 0.6737 20.161 6 489 488 492 0.7615 10.638 3 489 487 489 0.06140.616 4 489 490 490 0.8582 10.403 5 495 493 497 0.6824 20.921 1 495 494 493 0.1498 40.749 4 495 496 496 0.0544 60.763 3 495 498 495 0.1185 50.852 2 495 497 494 0.3824 30.16 495 495 498 0.4623 5

45、0.593 4 501 503 502 0.9919 10.546 5 501 499 503 0.8136 30.791 3 501 501 501 0.6323 40.838 1 501 502 499 0.8661 20.803 2 501 500 500 0.2842 60.532 6 501 504 504 0.4445 40.875 1 507 508 505 0.93810.864 2 507 505 506 0.0102 60.119 4 507 510 508 0.4696 30.151 3 507 507 507 0.3347 50.006 6 507 509 510 0.

46、9213 20.108 5 507 506 509 0.2311 50.519 3 513 515 513 0.3377 40.448 4 513 514 514 0.1166 60.346 513 516 516 0.9238 20.362 5 513 512 515 0.4365 30.785 2 513 513 512 0.9562 10.894 1 513 511 511 0.2809 50.144 4 519 521 520 0.3839 40.119 5 519 520 521 0.9033 20.654 1 519 518 517 0.4169 30.621 2 519 519

47、518 0.93410.068 6 519 517 522 0.1406 60.238 3 519 522 519 0.9011 30.271 5 525 525 527 0.4518 50.556 3 525 527 525 0.1464 60.401 4 525 528 526 0.8866 44E-04 6 525 526 528 0.9903 10.772 525 523 524 0.9241 20.781 525 524 523 0.8039 20.018 5 531 530 533 0.12960.523 531 534 531 0.7869 30.007 6 531 531 53

48、4 0.8243 10.837 1 531 529 529 0.5536 50.782 2 531 533 530 0.7112 40.244 4 531 532 532 0.7018 20.992 1 537 536 535 0.6397 30.695 3 537 537 537 0.0242 60.962 537 540 536 0.5432 50.039 6 537 539 540 0.5589 40.055 5 537 538 539 0.7612 10.546 4 537 535 538 0.1976 60.108 6 543 546 546 0.7632 10.463 543 54

49、1 543 0.2045 50.835 1 543 545 541 0.4867 20.215 543 542 545 0.4599 30.612 543 543 542 0.3551 40.308 4 543 544 544 0.2089 40.749 2 549 550 548 0.2618 30.634 3 549 549 549 0.2054 50.007 6 549 551 552 0.0571 60.416 4 549 552 550 0.6357 10.783 1 549 547 547 0.4429 20.214 5 549 548 551 0.1621 40.267 6 55

50、5 556 558 0.9179 10.277 5 555 553 557 0.0966 50.573 3 555 557 555 0.0004 60.682 1 555 558 553 0.1636 30.397 4 555 555 556 0.3347 20.606 2 555 554 554 0.3805 40.818 1 561 562 559 0.5715 30.676 2 561 561 560 0.7946 20.604 3 561 560 561 0.8456 10.554 5 561 559 563 0.3303 50.575 4 561 563 562 0.0763 60.