蛇形分班到随机均衡含身份证（附加其他条件）.xls

1、其他:用数字自己定义意义,比如:6表示6周岁,10表示西岸社区。避免6周岁或同个社区在同班级。也组合:106表示：西岸社区6周岁 分班数 6男女身份证姓名性别成绩其他排名男女排名 0.4308 40.124 5345 0.2946 50.099 6356 0.1172 60.907 2362 0.8287 30.357 4334 0.8907 10.721 3313 0.8744 20.914 1321 0.3651 60.116 691212 0.5905 40.854 29108 0.6993 30.253 59911 0.3987 50.516 491110 0.8402 10.7239

2、79 0.7566 20.954 1987 0.1969 60.651 3151815 0.7118 30.116 6151518 0.5362 40.348 4151616 0.8775 20.289 5151417 0.9212 10.657 2151314 0.3705 50.904 1151713 0.6518 10.466 5211923 0.5789 20.946 1212019 0.5103 30.813 2212120 0.3327 40.542 4212222 0.1834 50.646 3212321 0.1644 60.222 6212424 0.9944 17E-04

3、6272530 0.2793 40.593 1272825 0.05260.073 5273029 0.5062 30.547 3272727 0.9714 20.556 2272626 0.0895 50.344 4272928 0.5597 50.493333533 0.6899 30.812 2333332 0.4116 60.242 5333635 0.9915 10.052 6333136 0.6862 40.896 1333431 0.9246 20.355 4333234 0.1321 60.553 5394241 0.5275 10.772 2393738 0.4842 30.

4、891 1393937 0.3276 50.656 3394139 0.4985 20.625 4393840 0.4534 40.153 6394042 0.9810.227 4454346 0.3534 50.076 6454748 0.3563 40.382454644 0.3148 60.171 5454847 0.9249 20.229 3454445 0.8444 30.948 1454543 0.6473 20.829 1515049 0.0992 50.553 3515351 0.2773 40.311 5515253 0.4208 30.068 6515154 0.0945

5、60.627 2515450 0.9144 10.426 4514952 0.9831 10.702 2575556 0.19760.956 1576055 0.7606 20.046575660 0.3599 40.095 5575859 0.48330.135 4575758 0.2362 50.234 3575957 0.9482 20.107 6636266 0.9726 10.395 4636164 0.2391 60.839 2636662 0.3418 50.345 5636565 0.3799 40.994 1636461 0.4619 30.763 3636363 0.214

6、7 50.968 1697167 0.1178 60.757 3697269 0.5122 40.686 4697070 0.7551 30.412 6696972 0.9952 10.862 2696768 0.9514 20.655696871 0.0164 60.325 5757877 0.9116 20.948 1757473 0.9579 10.936 2757374 0.3132 50.372 3757775 0.4284 40.371 4757676 0.85130.028 6757578 0.2463 50.124 5818383 0.5154 20.036818084 0.3

7、032 40.718 2818280 0.23960.878 1818479 0.5424 10.678 3817981 0.4164 30.159 4818182 0.6696 10.785 1878585 0.4184 40.733 2878886 0.0724 60.222 5879089 0.5052 20.046 6878690 0.1328 50.299 4878988 0.4662 30.553 3878787 0.8317 20.751 2939292 0.5158 60.267 5939695 0.6802 40.536 3939493 0.8883 10.827 19391

8、91 0.7556 30.498 4939394 0.5337 50.014 6939596 0.8195 20.656 3999899 0.2376 60.136 699102 102 0.6405 40.614 599100 101 0.7623 30.627 49999100 0.4673 50.883 19910197 0.8302 10.871 2999798 0.39740.411 4105 106 106 0.0229 60.184 6105 108 108 0.1053 50.732 3105 107 105 0.93710.873 2105 103 104 0.57930.9

9、77 1105 105 103 0.8428 20.375 5105 104 107 0.3978 30.596 2111 111 110 0.5876 10.761111 109 109 0.4763 20.155 6111 110 114 0.29660.459 4111 114 112 0.32440.397 5111 112 113 0.3023 50.563111 113 111 0.29350.065117 119 119 0.5787 20.463 1117 116 115 0.4352 30.407 3117 117 117 0.2567 60.407 2117 120 116

10、 0.6562 10.308 4117 115 118 0.3471 40.041 6117 118 120 0.4117 20.923 1123 122 121 0.6955 10.772 2123 121 122 0.3945 30.043 6123 123 126 0.3307 40.643 3123 124 123 0.0045 60.105 5123 126 125 0.2275 50.317 4123 125 124 0.0739 60.838 2129 132 128 0.1442 50.334 6129 131 132 0.2358 40.369 5129 130 131 0.

11、6136 30.872 1129 129 127 0.8682 10.593 4129 127 130 0.7964 20.787 3129 128 129 0.3498 60.616 3135 138 135 0.5849 30.214 4135 135 136 0.5674 40.876 1135 136 133 0.7859 20.054 6135 134 138 0.8481 10.637 2135 133 134 0.46250.162 5135 137 137 0.8072 10.549 3141 139 141 0.2144 60.032 5141 144 143 0.5979

12、40.449 4141 142 142 0.5701 50.008 6141 143 144 0.6154 30.637 1141 141 139 0.7958 20.564 2141 140 140 0.41950.561147 149 145 0.5594 30.075 5147 147 149 0.4015 60.24147 150 148 0.8891 10.488 2147 145 146 0.6361 20.063 6147 146 150 0.4883 40.396 3147 148 147 0.23950.166 5153 155 155 0.2494 40.538 3153

13、154 153 0.0903 60.895 1153 156 151 0.8632 20.046153 152 156 0.9809 10.304 4153 151 154 0.56930.582153 153 152 0.1061 60.339 5159 162 161 0.4725 30.798 2159 159 158 0.2594 40.356 4159 160 160 0.7703 10.585 3159 157 159 0.1642 50.985 1159 161 157 0.7173 20.058 6159 158 162 0.1079 50.059 5165 167 167 0

14、.3265 40.008 6165 166 168 0.4398 20.512 4165 164 166 0.3306 30.657 3165 165 165 0.5176 10.976 1165 163 163 0.0406 60.839 2165 168 164 0.3522 50.098 5171 173 173 0.7447 10.876 1171 169 169 0.6893 20.073 6171 170 174 0.5837 40.691 2171 172 170 0.2697 60.474 3171 174 171 0.6553 30.259 4171 171 172 0.20

15、42 60.556 4177 180 178 0.4871 30.473 5177 177 179 0.79410.733177 175 177 0.6588 20.919 1177 176 175 0.3822 40.848 2177 178 176 0.3189 50.213 6177 179 180 0.3037 40.198 4183 184 184 0.1208 60.791183 186 181 0.55330.544 3183 183 183 0.66620.103 6183 182 186 0.9576 10.757 2183 181 182 0.2211 50.146 518

16、3 185 185 0.2028 50.108 6189 191 192 0.2289 40.133 5189 190 191 0.6067 20.523189 188 189 0.6548 10.205 4189 187 190 0.3993 30.661 1189 189 187 0.03460.639 2189 192 188 0.6864 30.331 4195 195 196 0.5026 40.323 5195 196 197 0.7334 20.747 2195 194 194 0.1433 50.616 3195 197 195 0.8196 10.035 6195 193 1

17、98 0.11860.824 1195 198 193 0.8545 10.624 2201 199 200 0.5263 20.277 5201 200 203 0.4173 40.364201 202 202 0.4955 30.109 6201 201 204 0.0803 60.756 1201 204 199 0.0953 50.557 3201 203 201 0.1685 30.333 6207 207 210 0.3014 20.442 5207 206 209 0.1632 40.914 2207 208 206 0.9163 10.978 1207 205 205 0.15

18、350.831 3207 209 207 0.0853 60.753 4207 210 208 0.0424 60.744 1213 216 211 0.0591 50.188 6213 215 216 0.7226 30.283 5213 213 215 0.7299 20.345 4213 212 214 0.0934 40.517 2213 214 212 0.8176 10.452 3213 211 213 0.8078 10.306 5219 217 221 0.5186 30.393 2219 219 218 0.2435 60.142 6219 222 222 0.34550.3

19、91 3219 221 219 0.6729 20.932 1219 218 217 0.4894 40.329 4219 220 220 0.3627 60.649 1225 228 223 0.8239 10.394225 223 226 0.4345 40.422 3225 226 225 0.5920.047 6225 224 228 0.5359 30.507 2225 225 224 0.4268 50.318 5225 227 227 0.4828 30.676 1231 231 229 0.1311 50.102 5231 233 233 0.8088 10.404 3231

20、229 231 0.4427 40.647 2231 232 230 0.7276 20.028 6231 230 234 0.0442 60.334231 234 232 0.1954 50.399 6237 239 240 0.6553 30.404 5237 237 239 0.0594 60.845 2237 240 236 0.87320.633237 236 237 0.9272 10.434237 235 238 0.4463 40.921 1237 238 235 0.8209 20.381 4243 242 244 0.2485 60.874 1243 246 241 0.5

21、811 30.801 2243 243 242 0.4091 50.334 5243 245 245 0.4616 40.002 6243 244 246 0.9292 10.401 3243 241 243 0.83810.604 4249 247 250 0.7051 30.643249 249 249 0.6522 40.347 5249 250 251 0.3843 50.691 2249 251 248 0.7935 20.192 6249 248 252 0.0982 60.731249 252 247 0.08660.327 4255 258 256 0.7211 20.529

22、3255 254 255 0.1277 40.146255 256 258 0.0894 50.577 2255 257 254 0.1461 30.317 5255 255 257 0.7417 10.684 1255 253 253 0.6606 10.296 6261 259 264 0.4911 30.398 5261 261 263 0.1758 40.641 3261 262 261 0.56620.437 4261 260 262 0.0542 60.866 2261 264 260 0.0631 50.948 1261 263 259 0.4985 40.476 4267 26

23、8 268 0.6105 30.893 3267 267 267 0.1911 60.926 2267 270 266 0.6132 20.055267 266 269 0.4578 50.007 6267 269 270 0.9142 10.975 1267 265 265 0.1077 60.35273 276 275 0.2125 50.856 2273 275 272 0.5753 20.633 4273 272 274 0.2977 30.694 3273 273 273 0.93610.912 1273 271 271 0.2636 40.274 6273 274 276 0.90

24、93 20.367 4279 278 280 0.80930.463279 279 279 0.91110.294 5279 277 281 0.3593 40.888 1279 280 277 0.2726 50.282 6279 281 282 0.1078 60.471 2279 282 278 0.2045 30.832285 285 284 0.56320.566 4285 284 286 0.0396 60.764 3285 288 285 0.7655 10.001 6285 283 288 0.20140.881285 286 283 0.1408 50.126 5285 28

25、7 287 0.28360.801 3291 294 291 0.4519 50.829 2291 293 290 0.5671 30.568 4291 291 292 0.9602 111291 289 289 0.8774 20.278 5291 290 293 0.5121 40.072 6291 292 294 0.83510.839 2297 295 296 0.8051 20.135 5297 296 299 0.3019 50.509 4297 299 298 0.51730.961 1297 297 295 0.2571 60.109 6297 300 300 0.4603 4

26、0.801 3297 298 297 0.3358 40.231 5303 304 305 0.9586 10.617 2303 301 302 0.08560.555 3303 306 303 0.2794 50.213 6303 305 306 0.8736 20.474 4303 302 304 0.3634 30.676 1303 303 301 0.2485 50.585 1309 311 307 0.6268 20.532 3309 308 309 0.1598 60.557 2309 312 308 0.6828 10.075 6309 307 312 0.44740.28530

27、9 310 311 0.4903 30.502 4309 309 310 0.0156 60.738 2315 318 314 0.0942 50.023 6315 317 318 0.8792 10.594 3315 313 315 0.5375 30.536 4315 315 316 0.8117 20.951 1315 314 313 0.5224 40.223 5315 316 317 0.1838 60.482 2321 324 320 0.93410.542 1321 319 319 0.91720.057 5321 320 323 0.9168 30.101 4321 321 3

28、22 0.9025 40.041 6321 322 324 0.3649 50.295 3321 323 321 0.2629 60.566 4327 330 328 0.9955 10.265 5327 325 329 0.3879 50.007 6327 329 330 0.4911 30.669 3327 327 327 0.8491 20.935 1327 326 325 0.3902 40.861 2327 328 326 0.0061 60.269 4333 336 334 0.6077 20.123 5333 332 335 0.2249 50.511 3333 335 333

29、0.3153 40.626 2333 334 332 0.6522 10.898 1333 331 331 0.4226 30.056333 333 336 0.2073 60.756 1339 342 337 0.3716 40.583 2339 340 338 0.2803 50.033 6339 341 342 0.6047 30.538 3339 339 339 0.84920.099 5339 338 341 0.9111 10.182 4339 337 340 0.7495 10.642 3345 343 345 0.4575 40.437 6345 346 348 0.1071

30、60.953 1345 348 343 0.5734 30.503 5345 345 347 0.3279 50.892 2345 347 344 0.6420.544345 344 346 0.9444 10.765 2351 349 350 0.4857 50.694 3351 353 351 0.8124 30.653 4351 351 352 0.8186 20.924 1351 350 349 0.28960.423 6351 354 354 0.6927 40.641 5351 352 353 0.6486 40.444 3357 358 357 0.02560.601 1357

31、360 355 0.7315 30.243 5357 357 359 0.8957 20.578 2357 356 356 0.5482 50.012 6357 359 360 0.9487 10.279 4357 355 358 0.1945 40.273363 364 363 0.0988 50.011 6363 365 366 0.9155 10.914 1363 361 361 0.0165 60.547 2363 366 362 0.5831 30.141 5363 363 365 0.5854 20.248 4363 362 364 0.1914 50.16369 371 372

32、0.70510.723 2369 367 368 0.3219 40.519 3369 370 369 0.5987 20.901 1369 368 367 0.1525 60.202 5369 372 371 0.5103 30.409 4369 369 370 0.0345 50.642 4375 377 376 0.21940.807 2375 376 374 0.3795 20.548 5375 374 377 0.9811 10.476 6375 373 378 0.0151 60.663 3375 378 375 0.3785 30.999 1375 375 373 0.5697

33、20.266 5381 380 383 0.6944 10.398 4381 379 382 0.4403 30.168 6381 381 384 0.2545 50.929 2381 383 380 0.1839 60.976 1381 384 379 0.4279 40.891 3381 382 381 0.0585 50.966 1387 389 385 0.53520.321 4387 386 388 0.4842 30.539 3387 387 387 0.3902 40.902 2387 388 386 0.7099 10.298 5387 385 389 0.0162 60.16

34、4 6387 390 390 0.1991 50.508 4393 395 394 0.9239 20.501 5393 392 395 0.9388 10.165 6393 391 396 0.7494 30.598 3393 393 393 0.1260.841393 396 391 0.2336 40.762393 394 392 0.5033 60.434399 402 400 0.7372 20.342 5399 398 401 0.68730.786 2399 399 398 0.6655 40.857 1399 400 397 0.5671 50.206 6399 401 402

35、 0.8412 10.543 3399 397 399 0.9823 10.026 6405 403 408 0.4366 30.667 3405 405 405 0.2612 50.696 2405 407 404 0.7853 20.732 1405 404 403 0.0242 60.514 5405 408 407 0.2732 40.653 4405 406 406 0.1232 60.409 5411 414 413 0.9499 10.342 6411 409 414 0.40530.712 3411 411 411 0.8591 20.601 4411 410 412 0.21

36、43 50.745 2411 413 410 0.3028 40.914 1411 412 409 0.6188 30.967 1417 417 415 0.4318 50.157 5417 419 419 0.4325 40.618 2417 418 416 0.4294 60.573417 420 417 0.8619 20.563 4417 416 418 0.9296 10.047 6417 415 420 0.1406 60.822 1423 426 421 0.9881 10.235 5423 421 425 0.7976 20.504 3423 422 423 0.6004 30

37、.555 2423 423 422 0.5823 40.294423 424 424 0.5439 50.228 6423 425 426 0.9883 10.418 4429 427 430 0.55140.011 6429 430 432 0.87620.72429 428 428 0.1233 60.835 1429 432 427 0.7774 30.394 5429 429 431 0.2693 50.559 3429 431 429 0.3429 60.315 4435 438 436 0.53740.986 1435 436 433 0.7109 30.166 5435 435

38、437 0.51750.069 6435 437 438 0.7546 20.577 3435 434 435 0.9246 10.589 2435 433 434 0.43850.938 2441 443 440 0.6004 40.599 4441 442 442 0.0094 60.895 3441 444 441 0.7721 30.981441 441 439 0.8824 20.047 6441 440 444 0.9296 10.079 5441 439 443 0.4873 40.311 4447 448 448 0.7817 20.964 2447 446 446 0.642

39、4 30.988 1447 447 445 0.4751 50.575 3447 449 447 0.2394 60.019 6447 450 450 0.7868 10.067 5447 445 449 0.78320.789 4453 452 454 0.2753 60.998 1453 456 451 0.8076 10.891 3453 451 453 0.5357 40.415453 454 455 0.5312 50.388 6453 455 456 0.6002 30.901 2453 453 452 0.3197 60.328 5459 462 461 0.7159 30.10

40、2 6459 459 462 0.7394 20.373 4459 458 460 0.5604 50.991459 461 457 0.7875 10.431 3459 457 459 0.7127 40.846 2459 460 458 0.9989 10.006 6465 463 468 0.9826 20.018 5465 464 467 0.78530.789 1465 465 463 0.7127 40.076 3465 466 465 0.6071 50.432 2465 467 464 0.34160.018 4465 468 466 0.1074 50.952 1471 47

41、3 469 0.0567 60.355471 474 473 0.2116 30.664 2471 471 470 0.1521 40.446 4471 472 472 0.56920.258 6471 470 474 0.8774 10.584 3471 469 471 0.1737 60.138 6477 480 480 0.57140.276 4477 478 478 0.9310.418 3477 475 477 0.6592 30.234 5477 477 479 0.3923 50.736 1477 479 475 0.7483 20.667 2477 476 476 0.5544

42、 20.418 5483 482 485 0.9747 10.581 3483 481 483 0.0188 60.592483 486 482 0.1246 50.197 6483 485 486 0.1813 40.608 1483 484 481 0.4576 30.537 4483 483 484 0.26750.823 2489 491 488 0.7254 10.914 1489 487 487 0.6853 20.435489 488 491 0.2992 40.673 3489 490 489 0.5458 30.025 6489 489 492 0.2399 60.587 4

43、489 492 490 0.6621 30.387 5495 495 497 0.3415 50.319 6495 497 498 0.8177 20.641 3495 494 495 0.2858 60.759 1495 498 493 0.9502 10.434495 493 496 0.4987 40.685 2495 496 494 0.47260.019 5501 504 503 0.99510.017 6501 499 504 0.8184 30.577 2501 501 500 0.9409 20.515 3501 500 501 0.6597 50.123 4501 503 5

44、02 0.6706 40.905 1501 502 499 0.0131 60.426 3507 510 507 0.9694 10.458 2507 505 506 0.69320.377 4507 506 508 0.3385 40.503 1507 508 505 0.2968 50.246 5507 509 509 0.5528 30.106 6507 507 510 0.9392 10.356 4513 511 514 0.5601 50.638 3513 515 513 0.80820.889 2513 512 512 0.1287 60.087 6513 516 516 0.64

45、37 40.108 5513 514 515 0.7313 30.941 1513 513 511 0.2639 60.63519 522 519 0.3527 50.251 6519 521 522 0.7117 20.312 5519 518 521 0.9955 10.901 1519 517 517 0.3915 30.588 4519 519 520 0.3882 40.863 2519 520 518 0.0265 60.643 4525 528 526 0.4479 20.155525 524 527 0.3452 30.998 1525 525 523 0.7173 10.78

46、3525 523 525 0.0749 50.051 6525 527 528 0.0942 40.858 2525 526 524 0.8607 10.089 5531 529 533 0.0897 60.314 4531 534 532 0.3203 30.645 2531 531 530 0.8131 20.531 3531 530 531 0.2801 40.811531 532 529 0.2703 50.056 6531 533 534 0.7939 20.591 2537 536 536 0.8985 10.184 6537 535 540 0.7859 30.444 3537

47、537 537 0.6797 50.875 1537 539 535 0.7063 40.311 4537 538 538 0.4077 60.305 5537 540 539 0.0914 60.445 4543 546 544 0.4419 30.773 3543 543 543 0.8378 10.907 2543 541 542 0.6645 20.137 5543 542 545 0.1311 50.108 6543 545 546 0.41340.996 1543 544 541 0.8903 20.751 2549 548 548 0.2036 50.584 5549 551 5

48、51 0.5359 40.695 4549 550 550 0.1279 60.859 1549 552 547 0.6283 30.743549 549 549 0.8976 10.198 6549 547 552 0.9747 20.762 3555 554 555 0.5393 50.518 5555 557 557 0.0282 60.984 1555 558 553 0.7369 30.584555 555 556 0.6601 40.137 6555 556 558 0.9935 10.925 2555 553 554 0.8993 10.065 6561 559 564 0.08

49、960.516 5561 564 563 0.6559 30.729 2561 561 560 0.1514 50.576 4561 563 562 0.3101 40.924 1561 562 559 0.8535 20.724 3561 560 561 0.3654 30.369 3567 567 567 0.04460.762567 570 566 0.8898 10.151 6567 565 570 0.7937 20.261 4567 566 568 0.2953 40.227 5567 568 569 0.2229 50.841 1567 569 565 0.4675 30.479

50、 3573 573 573 0.9805 10.438 5573 571 575 0.2528 40.474 4573 574 574 0.1423 60.923 1573 576 571 0.1484 50.368 6573 575 576 0.58220.839 2573 572 572 0.5392 30.052 6579 579 582 0.6661 20.547 1579 578 577 0.34850.199 3579 581 579 0.8705 10.137 5579 577 581 0.0497 60.139 4579 582 580 0.5007 40.235 2579 5