MCXƽ̨±äÁ÷Æ÷²úÆ·Éè¼Æ×ܽἰÓÅ»¯
ÊÕ²Ø
´òÓ¡
·¢¸øÅóÓÑ
·¢²¼Õߣºlunwenchina
ÈȶÈ0Ʊ ä¯ÀÀ6´Î
ʱ¼ä£º2021Äê2ÔÂ23ÈÕ 15:26
ÕÅ ÁÁ
£¨ÐÂÓþÅӰ͵ÏÇ£ÒýϵͳÓÐÏÞ¹«Ë¾ ½ËÕ ³£ÖÝ 213166 £©ÕªÒª£ºËæ×ÅÉç»á¾¼ÃµÄ¿ìËÙ·¢Õ¹£¬¶Ô¹ìµÀ½»Í¨ÐÐÒµÌá³öÁ˸ü¸ßµÄÒªÇó¡£ÎªÁËÊÊÓ¦ÐÂÐÎÊÆÏ¹ìµÀ·¢Õ¹Ç÷ÊÆ£¬±ØÐë¸ú½ô²½·¥£¬Ìá¸ß¹¤×÷ЧÂÊ£¬Í¬Ê±»¹Ðè¶ÔÎÒÃǵIJúÆ·²»¶ÏÓÅ»¯¡£±¾ÎÄÖ÷Òª½éÉÜÁ˱äÁ÷Æ÷Éè¼Æ¹ý³ÌÖУ¬ºÏÀíÔËÓà EXCEL º¯Êý¿ÉÒÔ´ó´óÌá¸ß¹¤×÷ЧÂÊ£»ÐÂÐÍÓÅ»¯´î¿ÛÀûÓõ¯»ÉÖùÈûµÄµ¯ÐÔÁ¦ÊµÏÖ×ÔËø´Ó¶ø½«ÏäÃŽϽôÃܵĸÇÔÚÏäÌåÉÏ£¬±£Ö¤Ç£ÒýÉ豸¸ßЧÎȶ¨¿É¿¿µÄÔËÐС£
¹Ø¼ü´Ê£º±äÁ÷Æ÷£»´î¿Û£» Excel º¯Êý£»µ¯»ÉÖùÈû
Abstract: With the rapid development of social economy, higher requirements have been put forward for the rail transit industry. In order to adapt to thetrend of track development under the new situation, We must keep pace with rail transit to improve work efficiency, and constantly optimize our products. Thispaper mainly introducesthat thereasonableuseof excel function can greatly improvetheworking efficiency in theprocessof converter design. Thenew optimizedbuckle makesuse of theelastic force of spring plunger to realize self-locking so that the box door can be tightly covered on the box body to ensure the efficient,stable and reliable operation of the traction equipment.
Key words: Converter; buckle; Excel function; spring plunger0 ÒýÑÔ
Ëæ×Ź«Ë¾ÏîÄ¿µÄÖð½¥Ôö¶à£¬Ö»ÓÐÌá¸ßÎÒÃǵŤ×÷ЧÂʲÅÄܱ£Ö¤²úÆ·°´ÆÚ½»¸¶¡£ÖÚËùÖÜÖª Excel Èí¼þ¾ßÓÐÊ®·ÖÇ¿´óµÄÊý¾ÝÐÅÏ¢·ÖÎö¼°Êý¾Ý´¦Àí¹¦ÄÜ¡£ºÏÀíµÄʹÓà Excel ½«´ó´óÌá¸ßÎҵŤ×÷ЧÂÊ¡£
Ëæ×ž¼ÃµÄ·¢Õ¹£¬¹ìµÀ½»Í¨Êг¡µÄ¾ºÕùÔ½À´Ô½¼¤ÁÒ£¬ÒªÊ¹µÃÎÒÃǵıäÁ÷Æ÷²úÆ·ÔÚ¾ºÕùÖÐÁ¢ÓÚ²»°ÜÖ®µØ£¬±ØÐë¶ÔÎÒÃǵıäÁ÷Æ÷²úÆ·²»¶ÏµØÓÅ»¯ÉõÖÁ´´Ð¡£
1 ExcelÔÚ²»Í¬ÏîĿģ¿é²îÒìÖеÄÔËÓÃ
1.1 Excel Ó¦ÓýéÉÜ
Excel ´óµÄ¹¦Äܲ»½öÔÚ¾¼Ãͳ¼Æ£¬²ÆÎñ±¨±íÖй㷺ʹÓ㬶øÇÒ»¹ÄÜΪ»úеÉè¼Æ£¬²úÆ·¿ª·¢£¬ÎïÁϹܿØÌṩÓÐÁ¦°ïÖú¡£ºÏÀíÔËÓà Excel ¹¦ÄÜ¿ÉÒÔÌá¸ß¹¤×÷ЧÂÊ£¬¼õÉÙÉè¼Æ¹¤×÷Öеijö´íÂÊ¡£
1.2 Ìõ¼þ²éÕÒÔÚÄ£¿é²îÒì±È¶ÔÖеÄÔËÓÃ
Ä£¿é×÷Ϊ±äÁ÷Æ÷²úÆ· [1] ÖÐ×îÎªÖØÒªµÄµÄ²¿¼þÖ®Ò»£¬ÔÚÉú²ú¹ý³ÌÖÐÐèÒª»¨·Ñ½Ï¶à¹¤Ê±¡£Èç¹ûÎÒÃÇÄܹ»ÕÒ³ö¸÷ÏîÄ¿¼äÄ£¿éÖÐÁã¼þµÄ²îÒ죬ʵÏÖ¸÷ÏîÄ¿¼äÄ£¿éµÄ»¥»»ÐÔ£¬½«»á´ó´ó¼õÉÙÄ£¿éµÄ×°Å乤ʱ¡£
¹¤×÷Öо³£ÊÕµ½ÓªÔËÓʼþ£¬ÄÜ·ñ½«Ö®Ç°ÏîÄ¿ÖжàÉú²ú³öµÄÄ£¿éÔËÓõ½ÐµÄÏîÄ¿ÖУ¬¼õÉÙ¿â´æ»ýѹ¡£ÕâÑù¾ÍÐèÒªÉè¼ÆÈËÔ±½«²»Í¬ÏîĿģ¿é²îÒìʶ±ð³öÀ´£¬Èç¹ûʶ±ð·½·¨²»µ±½«»á»¨·Ñ´óÁ¿Ê±¼ä£¬¶øÇÒ³ö´íÒ²ÄÑÒÔ±ÜÃâ¡£
ÏÖÒÔʶ±ð SML14 ºÍ SZL6 ÏîÄ¿ MCM Ä£¿é²îÒìΪÀý£¬¼ÓÒÔ˵Ã÷¡£
1. ´Ó Teamcenter Öе¼³ö SML14 ºÍ SZL6 MCM Ä£¿é EBOM ÓÚͬһ¸ösheet ¡£
2. ʹÓà Conditional Formatting>>Highlight cells Rules>>Duplicate Val-ues [2] ÈçÏÂͼ£º
ͼ1 Ìõ¼þ²éÕÒ²½Öè
ͼ 2 Ìõ¼þ²éÕÒ±ê¼Ç
3. µã»÷ Duplicate Values £¬Ñ¡ÖÐ Unique >>Light Red Fill with Dark RedText, Èçͼ 2:
4. µã»÷ OK £¬²»Í¬ÎïÁÏÒÔºìÉ«±ê¼Ç£¬ÈçÏÂͼ£º
ͼ3 Ìõ¼þ²éÕÒ½á¹û
5. Çø±ð£ºÖ÷ÒªÓÐ IGBT ¡¢ DCU ¡¢ MCM Ö±Á÷Ö§³ÅµçÈÝ¡¢ Connection box ¡¢ Heatsink ¡¢±ê×¼¼þµÈ¡£Òò´ËÒª½«²Ö¿âÖÐÊ£Óà SML14 ÏîÄ¿ MCM Ä£¿éÓõ½ SZL6 ÏîÄ¿ MCM Ä£¿é£¬Ö»Ð轫ÕâЩºìÉ«±ê¼ÇÏî×÷¸Ä¶¯£¬¼´¿É¡£
2 ±äÁ÷Æ÷ÏäÌå´î¿Û½á¹¹Éè¼ÆÓÅ»¯
2.1 ±³¾°¼¼Êõ
½üÄêÀ´£¬Ëæ×ÅÉç»á¾¼ÃµÄ¿ìËÙ·¢Õ¹£¬¶ÔÌú·½»Í¨Ìá³öÁ˸ü¸ßµÄÒªÇó£¬ÎªÁËÊÊÓ¦ÐÂÐÎÊÆÏÂÌú·µÄ²»¶ÏÌáËÙ£¬Ò²¶ÔÇ£Òý±äÁ÷Æ÷ÏäÔÚ°²È«·½ÃæÌá³öÁ˸ü¸ßÒªÇó¡£
ÔÚÕû¸öÇ£Òý±äÁ÷Æ÷ÏäÖдî¿ÛÓÐ×ŷdz£ÖØÒªµÄ×÷Ó㬽«ÏäÃŽϽôÃܵĸÇÔÚÏäÌåÉÏ£¬±£Ö¤Ç£ÒýÉ豸¸ßЧÎȶ¨¿É¿¿µÄÔËÐС£Ä¿Ç°Ç£Òý±äÁ÷Æ÷ÏäÓôî¿Û [3] ²»¾ßÓпɵ÷½Ú¹¦Äܺ͵¯ÐÔ×ÔËø¹¦ÄÜ£¬ËùÒÔ²»Äܱ£Ö¤´î¿Û³¤¾Ã´¦ÓÚ×îÓŵıպÏ״̬¡£¾¹ý³¤ÆÚÍâÁ¦×÷ÓûòÕñ¶¯Ê±£¬²»¾ßÓпɵ÷½Ú¼°µ¯ÐÔ×ÔËø¹¦ÄܵĴî¿ÛÈÝÒ×Ëɶ¯£¬½ø¶øÔì³ÉÏäÃÅ´ò¿ªÒý·¢°²È«Òþ»¼¡£
2.2 ×é³É½á¹¹
ÐÂÐÍ´î¿ÛÓɵ××ù 1 ¡¢´î¿ÛÐýת¸Ç 2 ¡¢µ¯»ÉÖùÈû 3 ¡¢´î¿Û±¾Ìå 4 ¡¢ÏúÖá 5 ×é³É¡£
ÈçÏÂͼ
ͼ4 дî¿Û×é³É½á¹¹
2.3¸½Í¼ËµÃ÷
ÏÂÃæ½áºÏ¸½Í¼ºÍʵÀý¶ÔÓÅ»¯´î¿Û×÷½øÒ»²½ËµÃ÷¡£
ͼ 5 ÊÇ´î¿Û½á¹¹Ö÷ÊÓͼ¡£
ͼ 6 ÊÇ´î¿Û½á¹¹×óÊÓͼ¡£Í¼ 7 ÊÇ´î¿ÛÐýת¸ÇÖ÷ÊÓͼ¡£
ͼ 8 ÊÇ´î¿ÛÐýת¸Ç×óÊÓͼ¡£
ͼ 9 Êǵ¯ÐÔÖùÈûʾÒâͼ¡£
ͼ 10 Êǵ××ùºÍµ¯ÐÔÖùÈû°²×°Ö÷ÊÓͼ¡£
ͼ 11 Êǵ××ùºÍµ¯ÐÔÖùÈû°²×°×óÊÓͼ
ͼÖУº 1. µ××ù£¬ 1-1. ±ÜÈòۣ» 2. ´î¿ÛÐýת¸Ç ,2-1. ¿¨²Û£¬ 2-2 µ÷½Ú²Û£» 3. µ¯ÐÔÖùÈû£¬ 3-1. ÖùÈû±¾Ì壬 3-1-1. Å¡Èë²Û ,3-1-2. µ¹½Ç£» 3-2. ÇòÐθǣ¬ 3-2-1. ĥƽ²¿Î»£¬3-3. µ¯»É£» 4. ´î¿Û±¾Ì壻 5. ÏúÖ᣻ 1-3. ¼þ 1 ºÍ 3 µãº¸²¿Î»¡£
ͼ5 ´î¿ÛÖ÷ÊÓͼ ͼ6 ´î¿Û×óÊÓͼ
ͼ7 ´î¿ÛÐýת¸ÇÖ÷ÊÓͼ ͼ8 ´î¿ÛÐýת¸Ç×óÊÓͼ
ͼ9 µ¯ÐÔÖùÈûʾÒâͼ
2.4 ¾ßÌåʵʩ·½Ê½
дî¿Û½á¹¹£¬È總ͼ 5 ¡¢ 6 £¬¾ßÓе××ù 1 ¡¢´î¿ÛÐýת¸Ç 2 ¡¢µ¯»ÉÖùÈû 3 ¡¢´î¿Û±¾Ìå 4 ¡¢ÏúÖá 5 ¡£µ××ù 1 µÄÒ»¶Ë×°Óе¯»ÉÖùÈû 3 £»´î¿ÛÐýת¸Ç 2 µÄÒ»¶ËÓëËùÊöµ××ù 1 Ô¶ÀëËùÊö×°Óе¯»ÉÖùÈû 3 µÄÒ»¶Ë¿Éת¶¯Á¬½Ó£¬ÁíÒ»¶ËÉèÓÐÓëËùÊöµ¯ÐÔÖùÈû 3 ÏàÅäºÏµÄ¿¨²Û 2-1 £»´î¿Û±¾Ìå 4 Óë´î¿ÛÐýת¸Ç 2 ͨ¹ýÏúÖá 5 ת¶¯Á¬½Ó¡£
È總ͼ 9 ÖУ¬µ¯ÐÔÖùÈû 3 β²¿¿ªÓÐÅ¡Èë²Û 3-1-1 £¬Å¡Èë²ÛΪÊÊÓÚÒ»×ÖÐÍÂÝË¿µ¶Å¡ÈëµÄÒ»×ÖÐÍ¡£
ͼ10 µ××ùºÍµ¯ÐÔÖùÈû°²×°Ö÷ÊÓͼ ͼ11 µ××ùºÍµ¯ÐÔÖùÈû°²×°×óÊÓͼÈ總ͼ 9 ÖУ¬Îª·½±ã´î¿ÛÐýת¸Ç 2 ¿ªºÏ£¬ÇòÐÎ¸Ç 3-2 Í·²¿ÉèÓÐĥƽ²¿Î»3-2-1 ¡£
È總ͼ 10 ÖУ¬ÎªÔöÇ¿µ××ù 1 ºÍµ¯ÐÔÖùÈû 3 ×°ÅäµÄ¿É¿¿ÐÔ£¬¿É½«µ××ù 1 ºÍµ¯ÐÔÖùÈû 3 ½øÐе㺸£¨ 1-3 £©¡£
È總ͼ 11 ÖУ¬µ××ù 1 ²à±ÚÉÏÉèÓбÜÈÃ²Û 1-1 ÓÃÀ´ÊÕÄÉ´î¿Û±¾Ìå 4 ¡£
2.5 ¸Ä½øÓŵã
´î¿ÛÐýת¸ÇÉÏ¿ªÉèµ÷½Ú²Û£¬·½±ãµ÷½Ú´î¿Û±¾ÌåµÄËø½ô³Ì¶È£»²ÉÓõ¯ÐÔÖùÈû¶Ô´î¿Û½øÐÐ×ÔËø£¬±ÜÃâÁËÒòÕñ¶¯»òÆäËüÍâÁ¦×÷ÓÃʱ£¬´î¿ÛËÉ¿ª¶øÔì³ÉµÄ°²È«Òþ»¼£»Í¬Ê±´ò¿ªºÍ¹Ø±Õ´î¿ÛÊÇ¿¿ÖùÈûÀïµÄµ¯»ÉÁ¦×÷Ó㬴î¿Û¿ªºÏ·½±ã¡¢ÇáËÉ¡£
3 ½áÂÛ
1. Ä£¿é²îÒì±È¶Ô¹ý³ÌÖУ¬ºÏÀíÔËÓà Excel º¯Êý¿ÉÒÔÌá¸ßЧÂÊ£¬¼õÉÙÉè¼Æ¹¤×÷Öеijö´íÂÊ¡£
2. ±äÁ÷Æ÷Ïä´î¿Û½á¹¹µÄºÏÀíÓÅ»¯£¬¿ÉÒÔÌá¸ßÇ£ÒýϵͳÎȶ¨ÐԺͰ²È«ÐÔ¡£
²Î¿¼ÎÄÏ×
[1] ÕÔÀö . ³ÇÊйìµÀ½»Í¨³µÁ¾µçÆø¿ØÖÆ [M] £¬±±¾©£º»úе¹¤Òµ³ö°æÉ磬2016 £¬ 77-80.
[2] Îéê» . ÄãÔç¸ÃÕâÃ´Íæ Excel[M] £¬±±¾©´óѧ³ö°æÉ磬 2011 £¬ 20-50.
[3] ÀÓñ . ´î¿ÛËø [P] £¬ÖйúרÀû£º 201730237121.2 £¬ 2017-06-12.