1、高壓電纜選型計(jì)算(按載流量選擇),,,,,2、直流電纜選型計(jì)算（最大值）,,,,,3、外線鋼芯鋁絞線選擇,,,,

區(qū)域方陣容量：,1250,kVA,拉手方陣數(shù)量：,12,電纜直徑(組)：,4,mm2,電纜直徑(匯)：,50,裝機(jī)容量：,30036.16,kW,綜合效率：,0.9

拉手額定電流：,247.44,A,綜合校正系數(shù)：,0.7,允許壓降：,3%,,系統(tǒng)電壓：,572,接入電壓：,35,kV,經(jīng)濟(jì)電流：,240

電纜載流量：,353.49,A,電纜線徑選擇：,3×150,電纜長(zhǎng)度(組)：,215.46,m,電纜長(zhǎng)度(匯)：,168.33,計(jì)算電流：,445.93,A,導(dǎo)體線徑：,240

,,,,,直流側(cè)允許壓降按3%計(jì)算，計(jì)算為綜合匯流箱出線電纜計(jì)算。,,,,,,,,,

26/35kV交聯(lián)銅芯電纜載流量選擇表（自動(dòng)計(jì)算）,,,,,PVF-1電纜載流量選擇表（自動(dòng)計(jì)算）,,,,,LGJ鋼芯鋁絞線載流量選擇表（自動(dòng)計(jì)算）,,,,

空氣30度，三芯電纜,,,埋地25度，三芯電纜ρ=2.5,,,空氣<60度，單芯電纜,,,,空氣40度,,,,

截面(mm2),持續(xù)載流量(A),,截面(mm2),持續(xù)載流量(A),,截面(mm2),持續(xù)載流量(A),,,截面(mm2),持續(xù)載流量(A),,,

50,179,,50,128,,4,44,組件工作電流：,8.61A,35,137,,30036.16,

70,229,,70,159,,6,57,組件工作電壓：,26.00V,50,178,,20894.72,

95,277,,95,189,,10,79,組件串聯(lián)數(shù)：,22塊,70,222,,,

120,322,,120,214,,35,150,不常用,,95,272,,,

150,371,,150,242,,50,182,,,120,307,,,

185,424,,185,272,,70,228,,,150,360,,,

240,500,,240,314,,95,273,,,185,416,,,

300,577,,300,353,,120,314,,,240,494,,,

400,651,,400,397,,150,360,,,300,566,270.26,,

,,,,,,16平方及以上為1kV交聯(lián)電纜，銅電阻率0.0185。,,,,,,,,

6下50線，79上95，10上120,,,,,,,,,,,<3000,3000-5000,>5000,

,,,,,2、直流電纜選型計(jì)算（合計(jì)計(jì)算值）,,,,,銅裸導(dǎo)線和母線,3,2.25,1.75,

,,,,,電纜直徑(組)：,4,mm2,電纜直徑(匯)：,50,裸鋁導(dǎo)線和母線,1.65,1.15,0.9,

,,,,,允許壓降：,2.478%,,系統(tǒng)電壓：,572,銅芯電纜,2.5,2.25,2,

,,,,,電纜長(zhǎng)度(組)：,50.00,m,電纜長(zhǎng)度(匯)：,100.00,鋁芯電纜,1.92,1.73,1.54,

,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,

"MIN(IF($K$9:$K$17>$M$17,$K$9:$K$17))",,,,,,,,,,,,,,

MAX((K9:K17<M17)*K9:K17),,,,,,,,,,,,,,

,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,

找出某列與數(shù)值最接近的,,,,,,,,,,,,,,

"INDEX(A1:A100,MATCH(0,0/(A1:A100>=B1),))",,,,,,,,,,,,,,

,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,

"查找B組中與111最接近但大于111的值,返回到C1.并將與A組對(duì)應(yīng)的值返回到D1",,,,,,,,,,,,,,

"查找B組中與111最接近但小于111的值,返回到C2.并將與A組對(duì)應(yīng)的值返回到D2",,,,,,,,,,,,,,

,,,,,,,,,,,,,,,

"C1=MIN(IF($A$1:$A$10>111,A1:A10))",,,,,,,,,,,,,,