胶南高职校校园网基础建设需求表

 

第二篇：03需求的格式---简化了的表格模式

0max30000

序数12431415xxxxxxxxxxxx2213214115116416n

11159xxxxxxxxxxxx594141xxxxxxxxxxxx9122xxxxxxxxxxxx37xxxxxxxxxxxx7138111xxxxxxxxxxxx3815171517137137136xxxxxxxxxxxx122xxxxxxxxxxxx14137xxxxxxxxxxxx517122xxxxxxxxxxxx517122xxxxxxxxxxxx38038021037038038xxxxxxxxxxxx210220380000010000000000000010000000010000000010000000010000000010010000000010010000010010000000010xxxxxxxxxxxx10001000000000100000000000000000000000000

0000000000000000000000000000000000000000000000000000000

11xxxxxxxxxxxx11xxxxxxxxxxxx11xxxxxxxxxxxx1111111111

11xxxxxxxxxxxx11xxxxxxxxxxxx2222222222222222222222222

2222222222222222222222222222222222222222222222222

说明

我先将效率比X概率进行了一次计算，简化后的表格就是在AF-AT列中附加问题：可以用正太函数来模拟计算结果不，10%以内的误差我都很满理很多行（30000行）的数据，现成的函数方便我后期的处理

依靠3进制列出的所有组合0000000000000000000000000

0000000000000000000000000

00000000011xxxxxxxxxxxx2

00011xxxxxxxxxxxx0001112

012xxxxxxxxxxxx120120120

123xxxxxxxxxxxx31415161xxxxxxxxxxxx2425

0.30.30.30.30.30.30.30.30.30.30.30.30.30.30.30.30.30.30.30.30.30.30.30.30.3

0.160.160.160.160.160.160.160.160.160.160.160.160.160.160.160.160.160.160.160.160.160.160.160.160.16

0.37120.37120.37120.37120.37120.37120.37120.37120.37120.30.30.30.30.30.30.30.30.30.51870.51870.51870.51870.51870.51870.5187

0.220.220.220.69420.69420.69423.28443.28443.28440.220.220.220.69420.69420.69423.28443.28443.28440.220.220.220.69420.69420.69423.2844

0.87330.6815

0.30.87330.6815

0.30.87330.6815

0.30.87330.6815

0.30.87330.6815

0.30.87330.6815

0.30.87330.6815

0.30.87330.6815

0.30.8733

0.0034230.0026710.0011760.0108020.0084290.0037110.0511060.0398810.0175560.0027670.0021590.000950.008730.0068130.0029990.0413030.0322320.0141890.0047830.0037330.0016430.0150940.0117790.0051850.071413

0020xxxxxxxxxxxx0010010010xxxxxxxxxxxx11xxxxxxxxxxxx11011012xxxxxxxxxxxx12012012012020020020020020020020xxxxxxxxxxxx21xxxxxxxxxxxx21xxxxxxxxxxxx22xxxxxxxxxxxx12622xxxxxxxxxxxx01031113212332034213522360037013xxxxxxxxxxxx12422043214422450046014702481xxxxxxxxxxxx522153225400550156025710581xxxxxxxxxxxx6222630064016502661067116xxxxxxxxxxxx22720073017402751076117712782079218022810.30.160.30.160.30.72960.30.72960.30.72960.30.72960.30.72960.30.72960.30.72960.30.72960.30.72960.30.72960.30.72960.30.72960.30.72960.30.72960.30.72960.30.72960.30.72960.30.72960.30.72960.30.72960.30.72960.30.72960.30.72960.30.72960.30.72960.30.72960.30.72960.34.2120.34.2120.34.2120.34.2120.34.2120.34.2120.34.2120.34.2120.34.2120.34.2120.34.2120.34.2120.34.2120.34.2120.34.2120.34.2120.34.2120.34.2120.34.2120.34.2120.34.2120.34.2120.34.2120.34.2120.34.2120.34.2120.34.2120.51873.28440.51873.28440.37120.220.37120.220.37120.220.37120.69420.37120.69420.37120.69420.37123.28440.37123.28440.37123.28440.30.220.30.220.30.220.30.69420.30.69420.30.69420.33.28440.33.28440.33.28440.51870.220.51870.220.51870.220.51870.69420.51870.69420.51870.69420.51873.28440.51873.28440.51873.28440.37120.220.37120.220.37120.220.37120.69420.37120.69420.37120.69420.37123.28440.37123.28440.37123.28440.30.220.30.220.30.220.30.69420.30.69420.30.69420.33.28440.33.28440.33.28440.51870.220.51870.220.51870.220.51870.69420.51870.69420.51870.69420.51873.28440.51873.28440.51873.28440.6815

0.0557290.30.0245320.87330.015610.6815

0.0121820.30.0053620.87330.0492560.6815

0.0384380.30.0169210.87330.2330420.6815

0.1818590.30.0800560.87330.0126160.6815

0.0098450.30.0043340.87330.0398080.6815

0.0310650.30.0136750.87330.1883420.6815

0.1469770.30.06470.87330.0218130.6815

0.0170220.30.0074930.87330.0688290.6815

0.0537120.30.0236440.87330.3256430.6815

0.2541230.30.1118660.87330.0901160.6815

0.0703240.30.0309570.87330.2843580.6815

0.2219050.30.0976840.87331.3453560.6815

1.049880.30.4621630.87330.0728310.6815

0.0568350.30.0250190.87330.2298150.6815

0.1793420.30.0789470.87331.0873020.6815

0.8485020.30.3735150.87330.1259250.6815

0.0982690.30.0432580.87330.3973510.6815

0.3100820.30.13650.87331.8799460.6815

1.467060.30.645808

1001001001001001001001001001011xxxxxxxxxxxx11011011011021xxxxxxxxxxxx210210210211xxxxxxxxxxxx11011011011011xxxxxxxxxxxx11111xxxxxxxxxxxx112xxxxxxxxxxxx121121xxxxxxxxxxxx02841085118612872088218xxxxxxxxxxxx029310941195129620972198229xxxxxxxxxxxx10xxxxxxxxxxxx10520xxxxxxxxxxxx0010xxxxxxxxxxxx11xxxxxxxxxxxx11521116xxxxxxxxxxxx19xxxxxxxxxxxx22xxxxxxxxxxxx25xxxxxxxxxxxx28xxxxxxxxxxxx311213220133211342213500136011370.50750.160.50750.160.50750.160.50750.160.50750.160.50750.160.50750.160.50750.160.50750.160.50750.160.50750.160.50750.160.50750.160.50750.160.50750.160.50750.160.50750.160.50750.160.50750.160.50750.160.50750.160.50750.160.50750.160.50750.160.50750.160.50750.160.50750.160.50750.72960.50750.72960.50750.72960.50750.72960.50750.72960.50750.72960.50750.72960.50750.72960.50750.72960.50750.72960.50750.72960.50750.72960.50750.72960.50750.72960.50750.72960.50750.72960.50750.72960.50750.72960.50750.72960.50750.72960.50750.72960.50750.72960.50750.72960.50750.72960.50750.72960.50750.72960.50750.72960.50754.2120.50754.2120.37120.220.37120.220.37120.220.37120.69420.37120.69420.37120.69420.37123.28440.37123.28440.37123.28440.30.220.30.220.30.220.30.69420.30.69420.30.69420.33.28440.33.28440.33.28440.51870.220.51870.220.51870.220.51870.69420.51870.69420.51870.69420.51873.28440.51873.28440.51873.28440.37120.220.37120.220.37120.220.37120.69420.37120.69420.37120.69420.37123.28440.37123.28440.37123.28440.30.220.30.220.30.220.30.69420.30.69420.30.69420.33.28440.33.28440.33.28440.51870.220.51870.220.51870.220.51870.69420.51870.69420.51870.69420.51873.28440.51873.28440.51873.28440.37120.220.37120.220.87330.0057910.6815

0.0045190.30.0019890.87330.0182730.6815

0.014260.30.0062770.87330.0864540.6815

0.0674660.30.0296990.87330.004680.6815

0.0036520.30.0016080.87330.0147680.6815

0.0115250.30.0050730.87330.0698710.6815

0.0545250.30.0240020.87330.0080920.6815

0.0063150.30.002780.87330.0255340.6815

0.0199260.30.0087720.87330.1208070.6815

0.0942740.30.04150.87330.0264070.6815

0.0206070.30.0090710.87330.0833250.6815

0.0650250.30.0286240.87330.3942290.6815

0.3076460.30.1354270.87330.0213420.6815

0.0166540.30.0073310.87330.0673430.6815

0.0525520.30.0231340.87330.3186120.6815

0.2486360.30.1094510.87330.03690.6815

0.0287960.30.0126760.87330.1164350.6815

0.0908630.30.0399980.87330.550880.6815

0.4298920.30.1892410.87330.1524470.68150.118965

12xxxxxxxxxxxx12012012xxxxxxxxxxxx121121121121xxxxxxxxxxxx22xxxxxxxxxxxx002002002002002002002002002012xxxxxxxxxxxx120120120120xxxxxxxxxxxx20xxxxxxxxxxxx21xxxxxxxxxxxx1401214120142211432214xxxxxxxxxxxx14xxxxxxxxxxxx15020151211522215xxxxxxxxxxxx15xxxxxxxxxxxx15920160211612216xxxxxxxxxxxx16xxxxxxxxxxxx16820169211xxxxxxxxxxxx117xxxxxxxxxxxx176121772017821179221xxxxxxxxxxxx218xxxxxxxxxxxx18620187211882218xxxxxxxxxxxx192101930.50754.2120.50754.2120.50754.2120.50754.2120.50754.2120.50754.2120.50754.2120.50754.2120.50754.2120.50754.2120.50754.2120.50754.2120.50754.2120.50754.2120.50754.2120.50754.2120.50754.2120.50754.2120.50754.2120.50754.2120.50754.2120.50754.2120.50754.2120.50754.2120.50754.2120.76020.160.76020.160.76020.160.76020.160.76020.160.76020.160.76020.160.76020.160.76020.160.76020.160.76020.160.76020.160.76020.160.76020.160.76020.160.76020.160.76020.160.76020.160.76020.160.76020.160.76020.160.76020.160.76020.160.76020.160.76020.160.76020.160.76020.160.76020.72960.76020.72960.76020.72960.76020.72960.37120.220.37120.69420.37120.69420.37120.69420.37123.28440.37123.28440.37123.28440.30.220.30.220.30.220.30.69420.30.69420.30.69420.33.28440.33.28440.33.28440.51870.220.51870.220.51870.220.51870.69420.51870.69420.51870.69420.51873.28440.51873.28440.51873.28440.37120.220.37120.220.37120.220.37120.69420.37120.69420.37120.69420.37123.28440.37123.28440.37123.28440.30.220.30.220.30.220.30.69420.30.69420.30.69420.33.28440.33.28440.33.28440.51870.220.51870.220.51870.220.51870.69420.51870.69420.51870.69420.51873.28440.51873.28440.51873.28440.37120.220.37120.220.37120.220.37120.69420.30.0523690.87330.4810390.6815

0.375390.30.1652490.87332.2758930.6815

1.7760460.30.7818250.87330.1232060.6815

0.0961470.30.0423240.87330.3887710.6815

0.3033860.30.1335520.87331.8393530.6815

1.4353820.30.6318630.87330.2130230.6815

0.1662380.30.0731790.87330.6721850.6815

0.5245550.30.2309120.87333.1802420.6815

2.4817760.31.0924910.87330.0086740.6815

0.0067690.30.002980.87330.0273720.6815

0.021360.30.0094030.87330.1295020.6815

0.101060.30.0444870.87330.0070110.6815

0.0054710.30.0024080.87330.0221220.6815

0.0172630.30.0075990.87330.1046620.6815

0.0816750.30.0359540.87330.0121210.6815

0.0094590.30.0041640.87330.0382480.6815

0.0298480.30.0131390.87330.180960.6815

0.1412170.30.0621640.87330.0395550.6815

0.0308680.30.0135880.87330.124816

21xxxxxxxxxxxx2112xxxxxxxxxxxx12112112112122122122122122xxxxxxxxxxxx0220xxxxxxxxxxxx2022022xxxxxxxxxxxx22xxxxxxxxxxxx222222222222222222xxxxxxxxxxxx19520196211972219xxxxxxxxxxxx20xxxxxxxxxxxx20420xxxxxxxxxxxx0020xxxxxxxxxxxx21xxxxxxxxxxxx21421215xxxxxxxxxxxx18xxxxxxxxxxxx21xxxxxxxxxxxx24xxxxxxxxxxxx27xxxxxxxxxxxx301223120232212332223xxxxxxxxxxxx23xxxxxxxxxxxx2402024121242222430.76020.72960.76020.72960.76020.72960.76020.72960.76020.72960.76020.72960.76020.72960.76020.72960.76020.72960.76020.72960.76020.72960.76020.72960.76020.72960.76020.72960.76020.72960.76020.72960.76020.72960.76020.72960.76020.72960.76020.72960.76020.72960.76020.72960.76020.72960.76024.2120.76024.2120.76024.2120.76024.2120.76024.2120.76024.2120.76024.2120.76024.2120.76024.2120.76024.2120.76024.2120.76024.2120.76024.2120.76024.2120.76024.2120.76024.2120.76024.2120.76024.2120.76024.2120.76024.2120.76024.2120.76024.2120.76024.2120.76024.2120.76024.2120.76024.2120.76024.2120.37120.69420.37120.69420.37123.28440.37123.28440.37123.28440.30.220.30.220.30.220.30.69420.30.69420.30.69420.33.28440.33.28440.33.28440.51870.220.51870.220.51870.220.51870.69420.51870.69420.51870.69420.51873.28440.51873.28440.51873.28440.37120.220.37120.220.37120.220.37120.69420.37120.69420.37120.69420.37123.28440.37123.28440.37123.28440.30.220.30.220.30.220.30.69420.30.69420.30.69420.33.28440.33.28440.33.28440.51870.220.51870.220.51870.220.51870.69420.51870.69420.51870.69420.51873.28440.51873.28440.51873.28440.6815

0.0974030.30.0428770.87330.5905280.6815

0.4608320.30.2028610.87330.0319680.6815

0.0249470.30.0109820.87330.1008750.6815

0.078720.30.0346530.87330.4772580.6815

0.372440.30.163950.87330.0552730.6815

0.0431340.30.0189880.87330.1744120.6815

0.1361070.30.0599150.87330.825180.6815

0.6439480.30.2834690.87330.2283550.6815

0.1782020.30.0784460.87330.7205640.6815

0.5623090.30.2475310.87333.4091310.6815

2.6603950.31.171120.87330.1845540.6815

0.1440210.30.0633990.87330.5823520.6815

0.4544520.30.2000520.87332.7552240.6815

2.1501040.30.9464870.87330.3190940.6815

0.2490120.30.1096170.87331.0068870.6815

0.7857470.30.345890.87334.7637830.6815

3.7175290.31.636477

T列中，5组3元素数组，要做的计算就是所有可能5串1乘积的和值. 都很满意，用现成的函数，还是要比Vba写的更好用。最终我是需要处

的处理