臺灣博碩士論文加值系統

為了跟進工業4.0，工廠推廣用電安全及推動工廠自動化，本論文透過機器學習設計一個結合LINE訊息推播之產線電力控制系統，主要由一Arduino開發板(Mega2560 pro)、乙太網路模組(W5500)、各區塊電路、個人電腦及設計開發之電路板所組成。由電腦使用XAMPP來整合PHP開發網站及MySQL所建立的資料庫，並與產線配電箱進行互聯，來實現系統物聯網，從中電腦也是擔任伺服器的重要一職；將傳統分電盤改成可遠端來控制生產線上的電源與氣壓，並能及時遠端監控產線三相電流，清楚瞭解有無三相用電不平衡情況發生，也可免除每日上下班需由人力進行送電及斷電；每當開關切換狀態有改變或是有監測到異常狀況時，皆會由LINE Notify第一時間自動發送訊息通知，也能讓主管當下得知每條生產線的電力及氣壓運作情形。

In order to keep up with Industry 4.0, promote electricity safety in factories and promote factory automation, this paper uses machine learning to design a production line power control system combined with LINE message push and broadcast, which mainly consists of an Arduino development board (Mega2560 pro), Ethernet Module (W5500), each block circuit, personal computer and circuit board designed and developed. The computer uses XAMPP to integrate the PHP development website and the database established by MySQL, and interconnects with the distribution box of the production line to realize the system Internet of Things, from which the computer also plays an important role as the server; the traditional distribution board is changed to The power supply and air pressure on the production line can be remotely controlled, and the three-phase current of the production line can be remotely monitored in time to clearly understand whether there is any unbalanced three-phase power consumption, and it can also avoid the need for manual power transmission and disconnection when commuting to and from work every day Electricity; whenever the switching state of the switch changes or an abnormal situation is detected, LINE Notify will automatically send a message notification at the first time, and it can also let the supervisor know the power and air pressure operation status of each production line immediately.

摘要............................................................i
Abstract.......................................................ii
誌謝..........................................................iii
目錄...........................................................iv
表目錄........................................................vii
圖目錄.......................................................viii
第一章 緒論.....................................................1
1.1研究目的.....................................................1
1.2文獻探討.....................................................1
1.3論文貢獻.....................................................1
1.4論文大綱.....................................................2
第二章 相關技術之研討............................................3
2.1 Python.....................................................3
2.2 Visual Studio Code.........................................3
2.3 Arduino....................................................4
2.3.1 Arduino介紹..............................................4
2.3.2 Arduino官方板種類.........................................5
2.3.3 Arduino Mega2560 pro開發板介紹............................8
2.4 XAMPP.....................................................10
2.4.1 MySQL與MariaDB的原由.....................................11
2.5 LINE Notify...............................................12
第三章 系統與電路之設計及其應用..................................13
3.1系統架構及流程...............................................13
3.2乙太網路區...................................................14
3.2.1 W5500網路模組簡介.........................................15
3.2.1.1何謂SPI..................................................16
3.2.2 W5500網路模組接線方式......................................17
3.3氣壓偵測區....................................................18
3.3.1壓力感測器動作原理...........................................18
3.3.1.1壓力單位..................................................19
3.3.1.2 Arduino類比腳位I/O及指令..................................19
3.3.2壓力感測器接線方式............................................20
3.4電流感測區.....................................................21
3.4.1 SCT-013開合式電流互感器簡介..................................22
3.4.2 ADS1115模組簡介.............................................23
3.4.2.1何謂I2C....................................................24
3.4.2.2 ADS1115晶片引腳............................................24
3.4.3 SCT-013電流互感器結合ADS1115模組..............................25
3.4.3.1 ADS1115模組Address位址.....................................25
3.4.3.2 SCT-013電流互感器結合ADS1115模組接線方式.....................26
3.5溫度量測區......................................................27
3.5.1 MAX6675溫度感測模組簡介.......................................28
3.5.1.1熱電偶......................................................29
3.5.2 MAX6675溫度感測模組接線方式....................................30
3.6繼電器控制區.....................................................31
3.6.1固態繼電器模組簡介..............................................32
3.6.1.1固態繼電器模組動作原理.........................................32
3.6.2固態繼電器模組接線方式...........................................32
3.6.3電磁接觸器簡介..................................................33
3.6.4電磁換向閥簡介..................................................35
第四章 實作過程與數值校正及分析........................................37
4.1網路線拉線作業與線路測試............................................37
4.2開發電路板零組件焊接...............................................40
4.3產線分電盤配線與改裝...............................................42
4.4氣壓管路配置與感測器安裝............................................46
4.4.1電力方面之改善...................................................46
4.4.1.1電線走火發生之原因.............................................46
4.4.2氣壓方面之改善...................................................47
4.5 Arduino程式撰寫與感測器讀取數值之校正..............................48
4.5.1宣告函式庫及變數.................................................50
4.5.2 setup()函數撰寫................................................52
4.5.3 loop()函數撰寫.................................................53
4.5.4電流互感器讀取數值之校正.........................................55
4.5.5壓力感測器讀取數值之校正.........................................57
4.6 Python程式撰寫結合LINE Notify傳送訊息通知.........................59
4.6.1導入套件及宣告變數...............................................59
4.6.2開關狀態改變傳送訊息通知.........................................60
4.6.3氣壓偵測異常傳送訊息通知.........................................62
4.6.4電控箱內溫度偵測異常傳送訊息通知..................................62
4.6.5三相電流偵測異常傳送訊息通知......................................63
4.6.6 LINE Notify傳送訊息通知畫面.....................................65
4.7網頁架構功能與圖表數據分析..........................................66
4.7.1產線網頁架構與功能介紹............................................66
4.7.2排程系統網頁架構與功能介紹........................................69
4.7.3圖表數據分析及探討................................................71
第五章 結論與未來展望..................................................72
5.1結論...............................................................72
5.2未來展望...........................................................72
參考文獻..............................................................75
附錄..................................................................77
Extended Abstract.....................................................83

[1]王尹廷，2019，”物聯網在工程自動化診斷之應用研究”，國立台灣師範大學工業教育學系碩士論文。
[2]物聯網是什麼意思？生活上有什麼應用例子？
https://www.machsync.com.tw/tw/article/%E5%B7%A5%E6%A5%AD4.0/%E7%89%A9%E8%81%AF%E7%B6%B2%E6%98%AF%E4%BB%80%E9%BA%BC%E6%84%8F%E6%80%9D%EF%BC%9F%E7%94%9F%E6%B4%BB%E4%B8%8A%E6%9C%89%E4%BB%80%E9%BA%BC%E6%87%89%E7%94%A8%E4%BE%8B%E5%AD%90%EF%BC%9F
[3]Welcome to Python.org
https://www.python.org/downloads/
[4]什麼是Python?-雲端初學者Python指南-AWS
https://aws.amazon.com/tw/what-is/python/
[5]Visual Studio Code-維基百科，自由的百科全書
https://zh.wikipedia.org/zh-tw/Visual_Studio_Code
[6]Day7.介紹一下VS Code-打Code好幫手-iT邦幫忙
https://ithelp.ithome.com.tw/articles/10265135
[7]Visual Studio Code- Code Editing. Redefined
https://code.visualstudio.com/
[8]施士文，2015，Arduino微電腦應用實習(含AMA中級先進微控制器應用認證術科試題)，台科大圖書股份有限公司，新北。
[9]Arduino Mega2560 Rev3 Overview, Retrieved from
https://store.arduino.cc/products/arduino-mega-2560-rev3
[10]Download XAMPP - Apache Friends
https://www.apachefriends.org/zh_tw/index.html
[11]MySQL
https://www.mysql.com/
[12]MariaDB Foundation - MariaDB.org
https://mariadb.org/
[13]MySQL -維基百科，自由的百科全書
https://zh.wikipedia.org/wiki/MySQL
[14]MariaDB -維基百科，自由的百科全書
https://zh.wikipedia.org/zh-tw/MariaDB
[15][Day 13] 開始進入資料庫篇，淺談MySql與MariaDB - iT邦幫忙
https://ithelp.ithome.com.tw/articles/10193092?sc=rss.iron
[16]LINE Notify
https://notify-bot.line.me/zh_TW/
[17]W5500-WIZnet
https://www.iwiznet.cn/products/network-chip/w5500/
[18]SCT-013-000 YHDC 100A開合式電流互感器SCT013000
https://www.taiwansensor.com.tw/product/sct-013-000-yhdc-100a-%E9%96%8B%E5%90%88%E5%BC%8F%E9%9B%BB%E6%B5%81%E4%BA%92%E6%84%9F%E5%99%A8-sct013000/
[19]北京耀華德昌電子有限公司
https://www.yhdc.com/product1311.html?productId=749
[20]ADS1115引腳圖及功能_數據手冊-采芯網
https://www.findic.com/serialparts/ads1115.html
[21]ADIO-MAX6675K MAX6675傳感器模組+K型熱電偶|廣華電子
https://shop.cpu.com.tw/product/56459/info/
[22]瞭解熱電偶(thermocouple)、測溫線、感溫線的基本原理與選擇注意事項
https://www.researchmfg.com/2021/06/thermocouple/
[23]金屬氧化半導體場效電晶體MOSFET
https:// physcourse.thu.edu.tw/galechu/wp-content/uploads/sites/8/2018/09/ MOSFET-0924.pdf