本研究在提升太陽能智慧電網的電流檢測和管理效率，透過物聯網技術構建一個綜合系統。該系統結合了Node-RED平台、phpmyadmin數據庫和Google sheet，利用MQTT協議實現數據的即時傳輸和分析，並且系統的供電來源包括太陽能和市電，同時配備電池以儲存電力，確保穩定供應。首先，傳感器負責檢測電流數據，並將這些數據傳送至Node-RED進行處理，然後儲存在phpmyadmin數據庫中，最後同步到Google sheet以便監控和分析。在系統的設計和實施過程中，選用了高精度的電流傳感器來確保數據的準確性，這些傳感器被部署在關鍵節點上，能夠即時捕捉到電流變化。透過Node-RED平台，設計了一系列的數據處理流程，包括數據的清洗、過濾和初步分析，這些流程不僅提高了數據處理的效率，還保證了數據的可靠性。儲存在phpmyadmin數據庫中的數據，利用其強大的查詢和管理功能，進行了進一步的數據挖掘和分析，為後續的決策提供了重要依據。最後，透過與Google sheet的同步，實現了數據的可視化和實時監控，管理人員可以隨時查看和分析電流數據，及時發現並處理潛在問題。實驗結果顯示，這套系統能有效地監測和管理電流，明顯提升太陽能智慧電網的穩定性和效率。具體而言，該系統在電流變化的響應速度、數據的準確性和可靠性方面都表現出色，有效降低了電網故障的發生率，提升了能源利用效率。此外，系統的可擴展性和靈活性也為未來的升級和擴展提供了便利。本研究為物聯網技術在再生能源管理中的應用提供了新的視角，對未來智慧電網的發展具有重要意義。這套系統不僅展示了物聯網技術在實時數據傳輸和處理方面的優勢，還突顯了數據庫和雲端服務在數據管理和分析中的重要角色。未來，我們計劃進一步優化系統，增加更多的功能模塊，如智慧預警系統和自動調節機制，以進一步提升太陽能智慧電網的管理水平和運行效率。

This study aims to enhance the efficiency of current detection and management in solar smart grids through an integrated IoT-based system. The system combines the Node-RED platform, phpmyadmin database, and Google sheet, utilizing the MQTT protocol for real-time data transmission and analysis. The power supply for the system includes solar energy and mains electricity, with batteries for power storage to ensure stability. Sensors detect current data, which is processed in Node-RED, stored in phpmyadmin, and synced to Google sheet for monitoring and analysis. High-precision sensors ensure data accuracy, capturing real-time current changes at key nodes. Node-RED facilitates data cleaning, filtering, and preliminary analysis, improving efficiency and reliability. phpmyadmin's powerful query and management functions enable further data mining and analysis, supporting decision-making. Google sheet synchronization provides data visualization and real-time monitoring, allowing managers to promptly identify and address issues. Experimental results show the system effectively monitors and manages current, enhancing the stability and efficiency of the solar smart grid. It excels in response speed, data accuracy, and reliability, reducing grid faults and improving energy efficiency. The system's scalability and flexibility facilitate future upgrades. This study offers new insights into IoT technology in renewable energy management, highlighting the importance of databases and cloud services in data management and analysis. Future plans include system optimization and additional features like intelligent warning systems and automatic adjustment mechanisms to further enhance solar smart grid management and efficiency.

摘要...i
Abstract...ii
誌謝...iii
目錄...iv
表目錄...vi
圖目錄...vii
第一章 緒論...1
1.1研究背景...1
1.2研究動機與目的...2
1.3論文架構...2
第二章 文獻回顧...3
2.1物聯網...3
2.2智慧電網...6
2.3電流檢測技術...9
2.4太陽能...10
2.5通訊協議 MQTT...14
第三章 系統規劃...16
3.1軟硬體設備介紹...16
3.1.1 phpMyAdmin...16
3.1.2 Node-RED...17
3.1.3 VNC（Virtual Network Computing）...19
3.1.4 Google Sheet...20
3.1.5 Raspberry Pi 4B...21
3.1.6交流電多功能感測模組...23
3.1.7太陽能板控制器...24
3.1.8 ATS-MS...26
3.1.9 逆變器...27
3.1.10 MCP3008...29
3.1.11太陽能板...30
3.1.12鉛酸電池...31
3.2系統規劃...31
3.2.1系統流程...32
3.2.2系統架構...33
3.3智慧電網實際應用架構...34
第四章 實驗與結果...37
4.1太陽能及電瓶介紹...37
4.2監測介面介紹...38
4.3數據存儲與查詢...40
4.4數據監控與即時警示...47
4.4實際應用...52
第五章 結論與未來研究...53
參考文獻...54

[1]何謂智慧電網，智慧電網架構應用與現況趨勢解析https://www.greenimpact.cc/Articles/detail?cid=2&id=158
[2]重新認識「Iot」，物聯網的由來以及對未來的影響https://www.techbang.com/posts/23698-the-internet-of-things-key-to-a-new-life-in-the-digital-age-pchome232-touch-the-future
[3]智慧電網懶人包｜一篇看懂智慧電網與應用，全面掌握電網知識https://college.itri.org.tw/Home/InfoData/f6e19f2d-f81c-421c-bc36-ea6409ba0a5d/30eaf225-8ccc-409a-9544-3be19e2af141
[4]儲能系統 廠辦能源效率調節https://blog.deltaww.com/energyinfrastructuresolutions/ess/slash-energy-storage-system-plant-energy-efficiency-adjustment/
[5]一次弄懂 MQTT ！物聯網通訊協定全面指南https://resource.webduino.io/blog/mqtt-guide
[6]MQTT 教程https://www.emqx.com/zh/mqtt-guide
[7]屋頂太陽能板優缺點https://www.uniteckenergy.com/news-detail/solar-panel-roof/
[8]太陽能優缺點https://inraa.org/zh/2020/06/zh-pros-and-cons-of-solar-energy/
[9]再生能源https://greenimpact.cc/Articles/detail?cid=2&id=309
[10]陸瑞強, 廖裕評，物聯網實作：Node-RED萬物聯網視覺化，五南圖書公司，民國107年
[11]Tran-Dang, H., Krommenacker, N., Charpentier, P., & Kim, D.-S. (2020). Toward the internet of things for physical internet: Perspectives and challenges. IEEE Internet of Things Journal, 7(6), 4711-4736. https://doi.org/10.1109/JIOT.2020.2971736
[12]McBee, K. D., & Simoes, M. G. (2012). Utilizing a smart grid monitoring system to improve voltage quality of customers. IEEE Transactions on Smart Grid, 3(2), 738-743. https://doi.org/10.1109/TSG.2012.2185857
[13]Tiwari, S. K., Singh, B., & Goel, P. K. (2018). Design and control of microgrid fed by renewable energy generating sources. IEEE Transactions on Industry Applications, 54(3), 2041-2050. https://doi.org/10.1109/TIA.2018.2793213
[14]P. S., A., & Kumar, S. M. D. (2022). Delay estimation of healthcare applications based on MQTT protocol: A Node-RED implementation. In 2022 IEEE International Conference on Electronics, Computing and Communication Technologies (CONECCT) (pp. 1-6). Bangalore, India. https://doi.org/10.1109/CONECCT55679.2022.9865759
[15]Samad, T., & Annaswamy, A. M. (2017). Controls for smart grids: Architectures and applications. Proceedings of the IEEE, 105(11), 2244-2261. https://doi.org/10.1109/JPROC.2017.2707326
[16]Li, W., Song, H., & Zeng, F. (2018). Policy-based secure and trustworthy sensing for Internet of Things in smart cities. *IEEE Internet of Things Journal, 5*(2), 716-723. https://doi.org/10.1109/JIOT.2017.2720635