EXCEL設(shè)計低頻變壓器

1、ITEMABCDEFUVWXYLEEI1410.5148.751.751.753.53.5728EI1614161222441036EI191519 12.52.52.5554.534EI2418241533661248EI2825282144861762EI41334127661382182.5EI300EI206.26.213.89.3EI3832 38.4 25.66.46.4 12.86.4 19.276.8UI3030 50.3 40.3101010 30.3120.6UI39396571.5EI3529.535 24.5559.67.7 19.574.200000 00000000

2、00型號規(guī)格ABC1C2DFHRTEI28118.4 11.36.37.6 25.1 19.4 17.616.8 0.6EI1335045.3 50.561.293.5872EI762826 28.534.41EI25*76.86.810.1180.8EI41*13.513.7 13.79.19.1280.8EI30*12N-003,7B.DEI.3013X-00312.1 14.375.119.8EI28*16N-002910.2 17.97719.7EI30*2310.42375.119.50.8EI763026303548.61.3ei48*16.518.5 18.6101029.5UI

3、43*14.5JSB-14A14.5 14.519.219.2 53.4281.3EI76*42.5vde01-76425B1/C126 43.21616 65.5494637 1.2EI66*35.501-66355B422.5 35.830.258 43.5 34.832.6 1.270*9418.5 13.2162846.71.2EI19B6.86.88.413.7EI57*25.5JSB-51 (PIN N0.04)19.5 25.525.649.6361ei48*16.5JSB54A16.5 16.510.410.429.51LBSEI48*26.2N-0186(適配器)18.1 2

4、8.1101031.4EI105*70SHOULDER35.77048.569.21.2ei66*26.524.4 28.712.612.641.8EI25*77.17.1ei19*56.456.98.513.7EI28*16N-0029ERA Brand6.26.25.75.713.8EI41*38.4JSB-07 41*39-B16.5 16.521.6280.8EI54*48.8EI54/18.8 gSe Art Nr:26409.718.5 18.811.611.635.21.2EI54*48.9COVER 71071.4 48*56.8*39.1PBT 玻璃纖維加強料EI38*13.

5、6 OD23009.7 PET13.3 13.616.725EI-11438.2 50.151.772.81.2UI3047043.910.4 16.51313200.9UI39309213.61717.617.625.91EI35*14 N-0068 N-0067 WITH COVER11.7 16.38.86.422.7EI41*178PIN (N-0126) WITH COVER15 19.26.56.525.8EI41*16.5(B01000346)Jsb-54A 8PIN 5/10*25.413.5 16.56.66.625.80.8EI120*50.723209.340.8 50.

6、754.877.52EI66*16.5B.DEI.6617X-001(jsb54A 22.5 16.512.612.637.21LDHIAW1AW2wire p SuSU44.24.930.87 37.241 1 0.785 0.785207.6 18.85 1153.601 1 0.785 0.785117-1433.64.861.26.3552.83.8556.24.7573.23.75122.41074.25.568.45.4514810.3126.29.37312.927.23.45987.25745.50092.46.65221 15.55106.28.728.4 -3.5526.7

7、 3.625000024.83.872.44.9584.27.15000053.85.85186.216.1613.969.25.15565.568.45.4665.4199 16.3585.66.4000000 11:30f63ea3097d573333d0a621bc546001c9.xls輔助計算表15RD制 表: 徐萬軍 2022/2/3 第 6 頁客戶：客戶編號我方料號產(chǎn)品型號電壓調(diào)整率初級功率 轉(zhuǎn)換效率材質(zhì)H18L0.35疊片系數(shù)EI 6626.4%35.9W72.57%le:CM0.98骨架EI66*16槽深(mm)6.4Sc(cm2) 3.45Bm（T）1.564環(huán)境溫度25鐵

8、芯尺寸舌寬疊厚功率規(guī)格鐵重槽1寬(mm)12.6 aw1(mm2) 80.64Pri-J9.66F（H Hz）50最高溫升65221651.3WEI66348.4底長電壓IIo(Ma) Pri匝數(shù)線徑股數(shù)排繞系數(shù)疊繞系數(shù) 層,匝 層數(shù) 厚度匝長DCR20DCRH銅重(G) 壓降 穩(wěn)態(tài)電壓 銅損耗絕緣0.080鐵損3.212w/kg861150.312268.89609600.2030.20311.051.159.1 16.23.697.351.686351.686365.914826.893 20.694.46.425862300.156119200.20311.051.159.1 16.23

9、.6119.963.691581.224833.139 12.7217.31.979SU00.20.203絕緣0.13910.139槽2寬寬(mm)12.6窗口面積(mm2)80.641初級用漆包圓線總厚 7.339總重量(G) 60.032總損耗8.4040.80.23Sec-J4.56類型1王字1次級用漆包圓線次繞組底長電壓電流Sec匝匝數(shù)數(shù)線線徑徑股數(shù)排繞系數(shù)疊繞系數(shù) 層,匝 層數(shù) 厚度匝長DCR20DCRH銅重(G) 壓降 穩(wěn)穩(wěn)態(tài)態(tài)電電壓壓 銅損耗0.0801869.61.8780800.7240.72411.051.116.64.83.897.90.34070.34070.43452

10、8.68228.6820.87.0677.0671.5192869.61.8780800.7240.72411.051.116.654122.40.4260.4260.543335.8635.8616.8676.8671.930 00 011.151.200000 000 000 0040 00 011.151.200000 000 000 0050 00 011.151.200000 000 000 00絕緣FALSESU1SU2SU3SU4SU50.0820.16GAP4991.846 Inductance80UhSc(cm)3.45抱抱歉歉! !繞繞組組超超尺尺寸寸:1.56mm:1.5

11、6mm ! !0.2總厚 7.967.96總重量(G) 64.542總損耗3.419絕緣漆AC-437.4g黑膠無JuneHsu最大輸出功率（Pmax）：51.3W輔料計算表4.4CM4EI66NO.名稱厚度寬度顏色總層數(shù)長度重量比重功率Sc(cm)Swb/ah/cc/aabch3M#440.139551141.9626.15.10.91.05730.232223.35153M#562283.91NO.名稱 型號規(guī)格顏色長度剝皮端子安全裝置NOMEX01TS4KRAFT PAPER03851.15 FISH PAPER0快巴紙0青殼紙01.15錫高溫?zé)o鉛錫條:Sn-0

12、.7Cu30.375過流(溫)保護安裝方式氬焊螺絲墊圈套管tf-328B1同方無鉛助焊劑30.3M6*60M600EI66產(chǎn)能排拉工時工價核算表0 11:30f63ea3097d573333d0a621bc546001c9.xls輔助計算表15RD制 表: 徐萬軍 2022/2/3 第 7 頁工序作業(yè)速率Ps/min工序參數(shù)放寬率工時工作制10定單量10000總需時4336000人工小時費5人工機器SPECQTY%S 排拉人數(shù) 日產(chǎn)量交期2人數(shù)60日成品量4982pcs人工費N11500 0. 2 FOIL 20005.00%841249820.1167N2600.8805.00%841251

13、430.1167N310005.00%0000N410005.00%0000N5150035005.00%0000N65035005.00%0000N710035005.00%0000包膠帶50ML15.00%1.30.1952620.0018掛腳5085.00%10.11.4451330.014出線55.00%0000上端子55.00%0000上錫525.00%25.23.651430.035測圈1515.00%4.20.651430.0058測電阻1515.00%4.20.651430.0058裝鐵芯50455.00%56.78.151430.0788空測1525.00%8.41.2514

14、30.0117電阻1535.00%12.61.851430.0175上支架115.00%63951430.0875包膠帶405.00%0000浸漆115.00%63951430.0875外觀1215.00%5.30.7651620.0074綜測155.00%0000電壓1515.00%4.20.651430.0058電阻155.00%0000耐壓1515.00%4.20.651430.0058貼標(biāo)2015.00%3.20.4651750.0044合計433.66282287498283pcs/人0.6022元物料清單（低頻類）客戶名稱: 0 客戶P/N:0可立克P/N:0 日期:07/6/19

15、材料名稱規(guī)格要求說明單位用量/PCS供應(yīng)商單價軟銅箔MW-80C32AWGS克62/克/MW-80C21AWGS克68/克/0克00克00克0鐵芯EI66 H180.35 A克360骨架EI66*16.5FR530（JSB-54A）套1正崧外殼CASEEI66*16.5支架/夾框0個4引線條條條條條溫度保險絲0個1塊巴紙/克/克/螺桿/螺母套4套金屬墊片個8絕緣墊片個絕緣膠帶3M#44/0.139*55米0.2/米/米套管米米接線片套接線卡座PCS環(huán)氧膠0克無絕緣漆AC-43克7.4g稀釋劑KT-100克7.4g錫條高溫?zé)o鉛錫條:Sn-0.7Cu克0.375助焊劑tf-328B1同方無鉛助焊劑

16、克0.3標(biāo)簽 白底黑字17.5*30個1總成本材料費：包裝費：制造費:0.8擬定:徐萬軍審查:批準(zhǔn):類別供應(yīng)商UL NO。漆包線PACIFICPACIFIC ELECTRICELECTRIC WIREWIRE & & CABLECABLE (SHENZHEN)(SHENZHEN) COCO LTDLTDE201757漆包線WANWAN MONMON INDUSTRIALINDUSTRIAL CORPCORPE104091漆包線TATA WINWIN INDUSTRIESINDUSTRIES (M)(M) SDNSDN BHDBHDE152187漆包線HUNGHUNG HSANG

17、HSANG WIREWIRE MFGMFG COCO LTDLTDE158025漆包線FENGFENG CHINGCHING METALMETAL CORPCORPE172395絕緣漆HANGHANG CHEUNGCHEUNG PETROCHEMICALPETROCHEMICAL LTDLTDE200154絕緣漆JOHNJOHN C C DOLPHDOLPH COCOE76517絕緣膠帶 3M3M COMPANYCOMPANYE17385絕緣膠帶 BONDTECBONDTEC PACIFICPACIFIC COCO LTDLTDE175868絕緣膠帶 JINGJIANGJINGJIANG YA

18、HUAYAHUA PRESSUREPRESSURE SENSITIVESENSITIVE GLUEGLUE COCO LTDLTDE165111絕緣膠帶 NITTONITTO DENKODENKO CORPCORPE34833絕緣膠帶 DUCKDUCK SUNGSUNG HITECHHITECH COCO LTDLTDE105147BOBBIN E E I I DUPONTDUPONT DEDE NEMOURSNEMOURS & & COCO INCINCE41938BOBBIN SOLUTIASOLUTIA INCINCE70062類別 名稱規(guī)格型號材料描述數(shù)量申請日期回答日

19、期 到料日期 供應(yīng)商產(chǎn)品產(chǎn)品客戶 位置1 BOBBINEI14*5N-0001電木3+3PIN306月12日 南吉達(dá)1#箱2 BOBBINEI28*16N-0029PET FR530(blk)106月12日 南吉達(dá)TI066084/5NORATEL 樣品房3 COVEREI28*16PBT 4115(blk)106月12日 南吉達(dá)TI066084/5NORATEL 樣品房4 電子線18AWGUL1015105 鐵芯片EI76H18 0.5A 6H246月14日6 BOBBINEI41*16.5N-0126(N-0126 ei41*17)206月16日6月19日7 BOBBINEI41*16.5

20、JSB-54A JSB-54A206月16日8M4*75 螺絲1006月16日910TURNS2510 EI48*17H18A0.35 39SHEETWIRE0.11 SC2.584 CM2F(Hz)50 Lc9.6 CMU0B0I0(Ma)AT/cmUe143.99161.569 5074.432172.781.282.092 4566.989201.581.412.13.164 3522.913228.941.5921.65.648 2241.36600 #DIV/0!00 #DIV/0!700 #DIV/0!00 #DIV/0!00 #DIV/0!00 #DIV/0!00 #DIV/0!

21、00 #DIV/0!00 #DIV/0!00 #DIV/0!00 #DIV/0!00 #DIV/0!00EI48 H18 0.35A B0/H0圖1.81.61.41.210.80.60.40.200246B0(T)H0(A/CM)TURNS1250 EI41*20.5H18A0.5WIRESC2.6 CM2F(Hz)50 Lc34 CMU0B0I0(Ma)AT/cmUe72.15110.40.382 20842.3775.761.0511.80.434 19262.3879.371.1130.47818322.182.971.1514.30.526 17406.9486.581.216.30.599 15950.1590.191.2518.20.669 14876.2893.81.320.40.75 13800.4297.41.3523.30.85712541.9101.011.4270.993 11225.07104.621.45311.14 10126.83108.231.5381.397 8548.801111.831.5547.41.743 7080.186115.441.661.22.25 5661.713119.051.65792.904 5681.818122.661.71003.676 4624.59212