MRP手工表

一基础数据1.库存表2.待入库表3.在途采购订单表每次运算前需更新以上3张基础表中的数据点击表中完成与ERP中数据同步二BOM表需计算的产品需要保证在BOM表中输入BOM的单个清单可用同文件夹中同一产品只能存在一个BOM表BOM清单中一些虚拟件可认为判断后删除三MRP表1.MRP表行列不能随便增加，如需增加需在VBA的代码中调整---》》》》MRP表格说明1至5行内容固定，不可随意改动第6行开始往下的内容无需人工编辑，点击“RUN_MRP”后将自动展示，这个区域的数据及公式均由VBA代码自动生成导出清单1.MRP表行列不能随便增加，如需增加需在VBA的代码中调整---》》》》批次单元格中空白时计算当前录入的需求前录入的需求填入批次号后自动与“工单缺料表”中的数据关联，缺料表中标记完成OK后本表自动扣除需求。RUN_MRP”后将自代码自动生成VBA版本不能在MRP表中新增行和列，否则影响运算！，如需增加行数要再VBA代码中修改。第6行开始全部用VBA自动更新，不需要手工录入，内容删除后可点击“RUN_MRP”来更新只录入产品代码，案名，套数--》计算出模拟的订单需求，有批次后可手工复制到“工单缺料表”中录入批次后自动关联到“工单缺料表”中，物料领用完成后再“工单缺料表中”标记OK后，本表点击“RUN_MRP”后自动扣除物料代码替代料名称2000AUJ3I218001RDT2-AUJ3I218-V1贴片加工2000BCS8MBV1000RCT1-BCS8MB-V1贴片加工2000GLD24B44202RGLD-24B-D442-V2贴片加工2000GLD24BE4421RGLD-24B-EN-D442-V1贴片加工2000GLD24C43402RGLD-24C-D434-V2贴片加工2000GLD24C84202RGLD-24C-D842-V2贴片加工2000RB4FKAR5100RLT2-RB4FKA-V1贴片加工(RGB)2000RC6FUAR5100RLT2-RC6FUA-V1贴片加工(RGB)-BCS8552000T6883025005RT6883220VV5DRIVER贴片加工2000T6884045006RT6884-120V-V4.5DRIVER贴片加工2001P13S4018102RM8-P13S4-D405-V1插件加工2001T6883025005RT6883220VV5DRIVER插件加工2002BCS8MBV1002RCT1-BCS8MB-V1BCS855插件加工2004BCS8MBV1003RBCS855DRIVER灌胶加工-V22004P13S4018102RM8-P13S4-D405-V1灌胶加工2010PA0RT519M00RLM2-PA0RT519-V3-CXP-S27灯板加工2010R09RS419T01RLT2-R09RS419-V2RGB灯板加工2010RA2RS4V2D01RLT2-RA2RS4-V2贴片加工NW2011BBS43018100RBBS430RGB灯板插件加工2012BCP70618T00RBCP706-18RGB灯板焊接加工2012BCP70927T00RBCP709-27RGB灯板焊接加工2014BBS43018100RBBS430RGB灯板灌胶加工2030M00R1300011RCT1-M00R13-V1贴片加工2031M00R1300012RCT1-M00R13-V1插件加工SMD2045T6883100000RT6883/304共用料件2100P13S4018102RM8-P13S4-D405-V2贴片加工302R041200J0181R302R041200J1181R碳膜电阻302R10000000006RSMD电阻302R10000000170RSMD电阻302R100220F0170RSMD电阻302R100820J0170RSMD电阻302R100R30F0170RSMD电阻302R101001F0170RSMD电阻302R101002F0170RSMD电阻302R101002J0170RSMD电阻302R101003J0170RSMD电阻302R101004J0170RSMD电阻302R101102J0170RSMD电阻302R101R21J0170RSMD电阻302R101R81F0170RSMD电阻302R102001F0170RSMD电阻302R102002J0170RSMD电阻302R102202F0170RSMD电阻302R102401F0170RSMD电阻302R103302F0170RSMD电阻302R104R71J0170RSMD电阻302R105101F0170RSMD电阻302R105103J0170RSMD电阻302R105602F0170RSMD电阻302R110000F0170RSMD电阻302R110000J0170R302R11000000170RSMD电阻302R110020F0170RSMD电阻302R110100F0170RSMD电阻302R1101R8F0170RSMD电阻302R1104R7F0170RSMD电阻302R110560F0170RSMD电阻302R1106R2F0170RSMD电阻302R111001J0170RSMD电阻302R111002F0170RSMD电阻302R111003J0170R302R111003F0170RSMD电阻302R111004F0170RSMD电阻302R111004J0170RSMD电阻302R111202F0170RSMD电阻302R111500F0170RSMD电阻302R111504J0170RSMD电阻302R112004F0170RSMD电阻302R112203J0170RSMD电阻302R113302F0170RSMD电阻302R114702F0170RSMD电阻302R115103F0XX0RSMD电阻302R116801F0170RSMD电阻302R116802F0170RSMD电阻302R119101F0170RSMD电阻302R120220F0170RSMD电阻302R1403R3F0170RSMD电阻302R161002J0170RSMD电阻302R161004J0170RSMD电阻302R163003J0XX0RSMD电阻302R164701J0000RSMD电阻302R165102F0XX0RSMD电阻302R167501F0XX0RSMD电阻302R169101F0XX0RSMD电阻302R2140R2F0181R金属皮膜电阻302R900000X0181R跳线（电阻脚）302R910D07K1XX2R热敏电阻302R9511KD14XX1R压敏电阻302R97D471K0XX1R压敏电阻302R9SMDC12F000R热敏电阻PTC30C00010UMG1XX0R电解电容30C00047UKG1X11R30C00470UME1XX1R电解电容30C00100UMG1190R电解电容30C00101UMF1191R电解电容30C00221UMG1191R30C00221UMG1X10R电解电容30C00331UMG1XX1R电解电容30C20102PMX0210R陶瓷电容30C20121PKX0210R陶瓷电容30C20151PKX0210R陶瓷电容30C82101PKG1XX0RSMD电容30C82103PKG0XX0RSMD电容30C82104PKG1XX0RSMD电容30C82104PMG0170RSMD电容30C82105PKC0XX0R30C82105PMG0XX0RSMD电容30C82105PKG0XX0R30C82105PMG0XX0RSMD电容30C82105PMG0XX0RSMD电容30C82200PMG0170R30C83200PKG0170RSMD电容30C82220PJG1XX0RSMD电容30C82471PJG0170RSMD电容30C82471PKG0170RSMD电容30C82471PMG0170RSMD电容30C83103PKG1XX0RSMD电容30C83104PMG0XX0R30C82104PMG0170RSMD电容30C83105PKG1XX0RSMD电容30C83224PKG1780RSMD电容30C83224PKG1TY0R30C83224PKG1780RSMD电容30C83472PKK1XX0RSMD电容30C83475PKD2TY0RSMD电容30C83684PKG0100R30C83684PKG0100RSMD电容30C84103PKG2XX0R30C84103PKU0XX0RSMD电容30C84104PKG2XX0RSMD电容30C84105PKG1XX0RSMD电容30C84224PKG1780R30C84224PKG2XX0RSMD电容30C84471PKU1XX0R30C84471PKX1XX0RSMD电容30C86106PKG0XX0R30C86106UMG1XX0RSMD电容30C86475PKG1TY0RSMD电容30C86475PKG1XX0RSMD电容30C90104KKT0XX1R30C90104PKV0XX1RPET/CBB电容30C90104PML1XX3R安规X2电容30C90154PML1XX1R安规X2电容30C90222PMT0XX1R30C90222PMT0XX3R安规Y1电容30C90224PML1XX1R安规X2电容310102PH2541023R端子310102PH2541050R端子310102PH254V234R端子310201CE2X00000R防火接线端子31110102R540S01R单排排针A型31120102R540012R31120602R540012R双排排针31120302R542613R双排排针31120412R540012R排針母座314002T68832000RT6883公头(VDE)314102T68830500RT6883母头(VDE)3411N4148W0S085R小信号开关二极管3411N4148WSS085R二极管341BAT54A00S0XXR二极体341DFLS1400S0XXR二极体341DFLS1607S0XXR341SS106000S0XXR二极体341DL5235B0S091R稳压二极体341DL5250B0S0XXR稳压二极体341DL5254B0S0XXR稳压二极体341ES07D000S0XXR二极体341J26A0000S000RTVS管341LL414800S091R二极体341PD3S1400S0XXR341MSS1P400S0XXR二极体341PJSOT36CS000RTVS管341SD101AWSS0XXR二极管341SMAJ188AS000R341SMAJ170AS000RTVS管341SMAJ33A0S000RTVS管341SS140000S022R二极体341SS210000S000R二极体341UF1M0000S0XXR二极体341UF2D0000S0XXR二极体3422SC18150D0XXR三极体342AO34070OS000R342AO3407AOS000RMOS管342AO3422LOS000RMOS管342AO74010OS000RMOS管342FQPF3N60D0XXR342FQPF5N60D0XXRMOS管342MMBT3904S0XXR三极体342S8550000S085R三极体342SPD02N80C300R342HFD3N80XD0XXR贴片MOS管34308MHZ000D031R晶振34308MHZ000S031R晶振34465LBC184S0TIRIC34478L05000D0NARIC34478L05F00S000RIC344ATMEGA8LS029RIC344DB107000D085R桥堆344DB107S00S085R桥堆344DM163Q