201220636 六、發明說明： 【發明所屬之技術領域】 本發明關於一種用φ 電管理的技術領域，可解決用電資 料零散且不斷成長而難 乂官理的問題，將電力公司每月提 供之電費收據資料透過咨、s * 過資通汛處理技術存入資料庫系 統’提供電費收據資料、碳排放量及用電趨勢統計分析查 旬以及專家„夕斷分析功能，分析各電錶單號最佳契約容 量及最佳計費方式，遠剡姐 、這到快速掌握用電狀況、碳管理、電 費支出及降低電費支出之方式。 【先前技術】 目則專利技術幾乎皆為針對單一電號或設備，透過硬 體進行設備負載量測後，將用電度數乘以固定的電f單價 進行簡單的電費換算，卻未能考量到現行電力公司除了用 電度數外，還依用電種類（包燈、表燈、低壓、高壓…etc) φ及a十偏方式不同（低壓時間、低壓非時間、高壓二段、高 壓二段…etc )而有不同的計費方式，另外還需考慮功率 因數、契約容量、尖離峰用電時間而有不同的電費明細。 針對有許多電號之用電單位，無法有效快速掌握實際用電 狀況並選擇最有利之用電計價類別，極為不便。本案發明 人鑑於先前技術瓶頸產生的各項缺點，乃丞思加以改良創 新’研發一種直接介接電費收據資料並分析現行實際用電 計費方式，經努力研究後’終於成功實作出電費管理系 201220636 統’可以滿足現有 【發明内容】 需求及先前技術無法克服之難題 針對分支機構眾多或有多筆用電電號之單位 信業、銀行業及政府公眾部門，透過介接電力公司資： 人工輸入進本發明系統’系統即可提供異常偵測、最適電 費計價方式及最佳轵&☆且，& % $約谷量計算功能，快速掌握用電 及評估是否需申請計價方式變更或契約容量調整，在二 變使用者習慣的情況下，即可節省龐大的電費支出。 本發明另-目的為配合實際需求產生各種統計分析 報表，提供單位進行節能績效評核管理之功能，達到碳盤 查及碳管理之目標。 本系統是-種自行研發之電費管理系統與方法，建有 關連式資料庫，並與企業網際網路(Intranet)連接，提供 使用者利用網頁管理查詢功能，可見本發明之實用性與技 術性。 本系統主要包含了收據分析模組、t費計算模組、電 費異常偵測模組及用電專家診斷模組。 收據分析模組’係提供將電子收據檔欄位按照定義格 式，將相關用電資料包含用電度數、用電費用、功率因數 及契約容量等資料剖析後’存入資料庫系統提供電力資料 查詢與管理之功能。 電費4算模組，係透過根據電力公司公告之用電費率 201220636 存入系統中，並依據各種計價方式進行資訊系統模組化設 計。 電費異常偵測模組，係透過系統内建立之資料庫管理 系統記錄之歷史電費資料與匯入之電費資料進行比對，若 有異常情形則發出Email或簡訊通知。 用電專家診斷模組，係由依據使用者輸入或量測的尖 離峰用電比例’將歷史用電資料套入電費計算模組之中， 計算該電號套用各種計價方式後所得之累積電費進行比 較’取累積電費最少者做為最佳計費方式。 【實施方式】 晴參閱圖一，為本發明電費管理之系統架構圖，其中 電費營4» /.j. 里糸統主機11内包含系統應用程式及資料庫，系 統部目丨丨4 刀為：收據分析模組12 :負責將電子收據檔解 析後存Α έ μ 八糸統主機資料庫中、電費計算模組13 :可依據201220636 VI. Description of the invention: [Technical field to which the invention pertains] The present invention relates to a technical field of using φ electric management, which can solve the problem that the power consumption data is scattered and continuously growing and difficult to be used, and the electricity fee provided by the power company every month. Receipt data through the consultation, s * over-the-counter processing technology into the database system 'provide electricity bill receipt data, carbon emissions and electricity trend statistical analysis and analysis and expert analysis function, analyze the best electric form number Contract capacity and the best billing method, far from sister, this is the way to quickly grasp the power consumption, carbon management, electricity bills and reduce electricity bills. [Prior Art] The patented technology is almost for a single number or device. After the device load measurement by hardware, the electricity rate is multiplied by the fixed electricity f unit price for simple electricity rate conversion, but it cannot be considered that the current power company uses the type of electricity in addition to the power consumption (package light) , table lamp, low voltage, high voltage...etc) φ and a ten bias mode (low pressure time, low pressure non-time, high pressure two-stage, high-voltage two-stage...etc) Different billing methods, in addition to power factor, contract capacity, peak off-peak power consumption time and different electricity bills. For power units with many electric numbers, can not effectively grasp the actual power consumption and select the most The favorable use of electricity pricing category is extremely inconvenient. In view of the shortcomings caused by the prior art bottleneck, the inventor of this case is thinking and improving and innovating, researching and developing a direct incoming electricity fee receipt data and analyzing the current actual electricity charging method. After the 'final success of the electricity fee management department 201220636 system' can meet the existing [invention content] demand and the problems that the prior art can not overcome for the unit of many branches or have multiple electric power numbers, the banking industry and the government public sector, Through the introduction of the power company: manual input into the system of the invention's system can provide anomaly detection, optimal electricity tariff pricing and best 轵 & ☆ and, &&#; $ about the amount of calculation, to quickly grasp the power and Evaluate whether it is necessary to apply for pricing change or contract capacity adjustment. In addition, the invention can save huge electricity expenses. The invention is also aimed at generating various statistical analysis reports in accordance with actual needs, providing the unit with the function of energy-saving performance evaluation management, and achieving the objectives of carbon inventory and carbon management. The self-developed electricity fee management system and method, the connection of the connected database, and the connection with the enterprise intranet (Intranet), providing users with the use of web page management query function, can be seen the practicality and technicality of the present invention. The receipt analysis module, the t-calculation module, the electricity cost anomaly detection module and the power expert diagnostic module. The receipt analysis module provides the electronic receipt file field according to a defined format, and the relevant power data is included. After analyzing the data such as electricity, electricity, power factor and contract capacity, the data stored in the database system provides power data query and management. The electricity fee 4 calculation module is stored in the system according to the electricity rate announced by the power company 201220636, and the information system is modularized according to various pricing methods. The electricity fee anomaly detection module compares the historical electricity bill data recorded by the database management system established in the system with the incoming electricity bill data, and sends an email or SMS notification if there is an abnormal situation. The electricity expert diagnostic module is based on the user's input or measurement of the peak-to-peak power consumption ratio's historical power consumption data into the electricity fee calculation module, and the accumulation of the electricity number is calculated by using various pricing methods. The comparison of electricity charges is made by taking the least amount of accumulated electricity as the best way to charge. [Embodiment] Clearly referring to Figure 1, the system architecture diagram of the electricity fee management of the present invention, wherein the electricity fee camp 4» /.j. The system host 11 contains system applications and databases, and the system department has a 4 knife. : Receipt Analysis Module 12: Responsible for parsing and storing the electronic receipt file Α μ 糸 主机 主机 host database, electricity bill calculation module 13 : can be based on
電號計彳雷t 4? 方式及電力公司最新流動電費及基本電費眚 資料古十宜 只κ千 °异應缴電費、電費異常偵測模組14 :可將當# 電資料盥卜如山 ，、上期或去年同期用電資料進行比對並判斷是否 、韦、專家診斷模組15 :依照系統研發的演算 號最佳契的心 4异電 、'”、★量及評估最佳計價m t費計算模組可The electric meter is 彳雷 t 4? The method and the latest mobile electricity fee and basic electricity fee of the power company 眚 古 古 只 只 κ ° ° 缴 缴 缴 、 、 、 、 、 、 、 、 、 、 、 、 、 、 、 、 、 、 、 、 、 、 、 、 、 、 、 , the previous period or the same period last year, the electricity consumption data for comparison and judge whether, Wei, expert diagnostic module 15: according to the system development number of the best calculation of the heart of the 4 different power, '", ★ quantity and evaluation of the best pricing mt fee Computing module
1 、種類包含包燈16、低壓時間17、低壓非時間 咼壓二段^ Q 22莫田9、高壓三段2〇、功因調整費h、超約附加費 費用計算等模組，當匯入用電收據資料時，則 201220636 採用異常债測模組14進行異常^貞，.則 請參閱圖二所示，為本發明之 锞刀析模組流程，當 與電力公司申請電費集中繳納作 〇 电刀公司每月會將 單位内所有電號通知單及收據資料 L推人τα ，透過系統的 上傳介面會自動依據相對應的 ^ ^ ± A °』析後存入資料庫 中，並提供相關查詢功能給使 可鱼祠，其步驟包含： a•上傳當期用電收據之資料。 b·進行收據剖析動作： ⑴檔案格式不正確’例如 上傳失敗。 卩·txt或.…則顯示 ⑺槽案格式正確則進行剖析之動作， 所定義之格式進行將資…、力△司 成功則顯n U # #庫之㈣’若剖析 成力則顯不成功，否則顯示失敗。 請參閱圖三所示，為士 测流赵，" 為本發明之用電異常偵測模組之谓 "β匯入電力公司繳費通知單時，除:r將杳以 進入資斜痛冰介a 平了除了將資料剖析 ’ …、會同時與上期及去年同期 比較，當差異過大則會顯-巾電資枓進行 號答“ 會顯不異常告警並寄送EmaiI給該電 唬管理者，其步驟包含： 。°亥電 ^‘匯入㈣之用電電費金額、度數。 d.進資料庫系統 用電資料。 …旬该電號最近一期及去年同期之 e •根據使用者需來 /或系統設定，異常判斷方式為. 201220636 _ (1)當當期用電度數大於x度，系統内有上期用電資 料，且比上期用電度數資料成長γ%，判斷為異常。 (2) 當當其用電度數大於χ度，系統内有去年同期用 電身料，且比去年同期用電資料成長Y%，判斷為異常。 (3) 當判斷為異常時，進行簡訊或Email通知相關負 責人員。 4參閱圖四及圖五所示，為本發明之專家診斷模組， •可根據使用輸入之用電電號或單位，進行專家診斷功能， 評估各電號最佳契約容量及最佳計費方式，其步驟包含： a. 根據輸入或整批查詢之電號，查詢最近一年的用電 契約身料，利用超約附加費計算模組搭配最小平方誤差法 之演算邏輯，計算該電號之最佳契約容量，並將其計算邏 輯模組化，如圖四所示。 b. 根據輸入或整批查詢之電號，判斷為高壓或低壓， • 依據使用者輸入或量測的尖離峰用電比例，將歷史用電資 料套入電費計算模組之中，計算該電號套用各種計價方式 後所得之累積電費進行比較’取累積電費最少者做為最佳 計費方式’並將各計價公式模組化，如圖五所示。 本發明所提供之電費管理系統與方法，在架構設計與 管理實施上均屬創新突破，更具有下列之優點： 1，本發明可透過匯入電子收據檔或人工補登之方式 直接使用電力公司電費資料來進行管理，與傳統透過加裝 201220636 硬體進行負載量測管理更為實際β 2.本發明透過匯入電子收摅 4文據檔之方式可快速對多個 電號進行管理及查詢相關統計報表， I视衣名紊保存紙本收據空 間及人工作業之時間，並完成 凡唧/开用電資枓零散且不斷成 長而難以管理的問題’大幅姆推答畑Α方 N增進管理效率及符合環保精 神。 3. 本發明可根據實際電費計價方式並隨時調整費率 設定’透過資訊系統大量運算的能力，計算出最適合的用 電計價方式及契約容量，大幅減少用電支出。 4. 本發明透過資料庫系統儲存大量資料，並在匯入每 期電費資料時自動進行異常摘測，若發現當期用電費用及 度數與上冑或去年同期#常增加，則會發送告警通知訊 息，可避免電力公司人員抄表錯誤或被竊電之情況發生。 上列詳細說明係針對本發明之一可行實施之具體說 明，惟該實施例並非用以限制本發明之專利範圍，凡未脫 離本發明技藝精神所為之等效實施或變更，均應包含於本 案之專利範圍中。 综上所述，本案不但在技術思想上確屬創新，並能較 習用物品增進上述多項功效，應已充分符合新穎性及進步 性之法定發明專利要件，目前系統已在中華電信公司使用 中，功效良好，爰依法提出申請，懇請貴局核准本件 發明專利申請案，以勵發明，至感德便。 201220636 【圖式簡單說明】 請參閱以下有關本發明之詳細說明及其附圖’將可進 一步瞭解本發明之技術内容及其目的功效；有關附圖為·· 圖一為本發明電費管理系統與方法之系統架構圖； 圖二為本發明收據分析流程圖 圖三為本發明電費管理系統與方法之異常偵測流程 統與方法ϋ圭契約診斷 圖四為本發明電費管理系 流程圖； 圖五為本發明電費管理系 診斷流程圖； 統與方法之最佳 計費方式 【主要元件符號說明】 11電費管理系統主機 12收據分析模組 13電費計算模組 14電費異常偵測模組 15專家診斷模組 16包燈電費計算模組 17低壓時間電費計算模組 18低壓非時間電費計算模組 19高壓二段式電費計算模組 20高壓三段式電費計算模組 9 201220636 2 1功因調整費計算模組 22超約附加費計算模組1, the type includes package light 16, low pressure time 17, low pressure non-time pressure two sections ^ Q 22 Motian 9, high pressure three sections 2 〇, power factor adjustment fee h, super approximate surcharge fee calculation module, etc. When entering the electricity receipt data, 201220636 uses the abnormal debt measurement module 14 to perform the abnormality. Please refer to Figure 2 for the process of the file analysis module of the present invention. 〇Electric Knife Company will push all the electric number notices and receipt data L in the unit to τα every month. The uploading interface of the system will be automatically deposited in the database according to the corresponding ^ ^ ± A ° and provided. The relevant query function is used to make the fish, and the steps include: a. Uploading the data of the current electricity receipt. b. Carry out the parsing analysis action: (1) The file format is incorrect', for example, the upload failed.卩·txt or .... shows that (7) the slot format is correct, then the analysis is performed. The format defined will be used for the operation of the file, and the force of the △ division will be displayed. n U # #库之(四)' If the analysis is successful, it will be unsuccessful. Otherwise the display fails. Please refer to Figure 3, for the measurement of flow, ", for the use of the power anomaly detection module of the invention, "when the electricity company pays notice, in addition to: r will be slanted into the capital In addition to analyzing the data '..., it will be compared with the previous period and the same period of last year. When the difference is too large, the number will be changed. The number will be answered and the EmaiI will be sent to the eDonkey. The steps include: .Haihai ^' Import (4) The amount of electricity and the amount of electricity used. d. Enter the data of the database system. ... The latest version of the electric number and the same period last year e • According to the user Need to come to / or system settings, the abnormal judgment method is 201220636 _ (1) When the current electricity consumption is greater than x degrees, the system has the previous period of electricity consumption data, and the growth rate of the previous period is γ%, which is judged to be abnormal. 2) When the power consumption is greater than the temperature, the system uses the electric body material for the same period last year, and it is judged to be abnormal when it is Y% higher than the electricity consumption data of the same period of last year. (3) When it is judged to be abnormal, send a newsletter or email notification Relevant responsible personnel. 4 See Figure 4 and Figure 5 for The expert diagnostic module of the invention can perform expert diagnosis function according to the electric number or unit used for input, evaluate the optimal contract capacity of each electric number and the best charging method, and the steps include: a. According to the input or the whole The electric number of the batch inquiry, query the electricity contract body of the most recent year, calculate the optimal contract capacity of the electric number by using the calculation logic of the super-plus surcharge calculation module and the least square error method, and calculate the logical model Grouping, as shown in Figure 4. b. According to the electric number of the input or batch inquiry, it is judged as high voltage or low voltage, • According to the user's input or measurement of the peak off-peak power consumption ratio, the historical electricity data is nested Among the electricity fee calculation modules, the accumulated electricity charges obtained by using the various pricing methods are compared to calculate 'the least accumulated electricity charge is used as the best charging method' and the pricing formulas are modularized, as shown in FIG. The electricity fee management system and method provided by the invention are innovative breakthroughs in architecture design and management implementation, and have the following advantages: 1. The invention can be imported into an electronic receipt file or artificially. The method of replenishment is directly used to manage the electricity company's electricity bills. It is more practical than the traditional load management measurement by adding 201220636 hardware. 2. The invention can be quickly exchanged by importing electronic receipts. A number of electric numbers are used to manage and query relevant statistical reports. I use the name of the clothing to save the paper receipt space and the time of manual work, and complete the problem that the 唧 唧 / open electricity resources are scattered and constantly growing and difficult to manage. It is recommended that the management efficiency and environmental protection spirit be improved. 3. The invention can calculate the most suitable electricity pricing method and contract based on the actual electricity tariff pricing method and adjust the rate setting at any time. Capacity, greatly reducing electricity consumption. 4. The invention stores a large amount of data through the database system, and automatically performs abnormal sampling when importing each period of electricity tariff data. If the current electricity cost and degree are found, it is the same as last month or the same period last year. #常增, will send an alert notification message, can avoid the situation of power company personnel reading errors or stolen electricity. The detailed description above is a detailed description of the possible implementation of the present invention, and the embodiment is not intended to limit the scope of the invention, and the equivalent implementation or modification of the present invention should be included in the present invention. In the scope of patents. In summary, this case is not only innovative in terms of technical thinking, but also can enhance the above-mentioned multiple functions compared with conventional articles. It should fully comply with the statutory invention patent requirements of novelty and progressiveness. At present, the system has been used by Chunghwa Telecom. The effect is good. If you apply in accordance with the law, you are requested to approve the application for the invention patent in order to encourage the invention. 201220636 [Simplified description of the drawings] Please refer to the following detailed description of the present invention and the accompanying drawings, which will further understand the technical contents of the present invention and the effects of the objects of the present invention. The system architecture diagram of the method; Figure 2 is the flow chart of the receipt analysis of the present invention. FIG. 3 is an overview of the abnormality detection process and method of the electricity tariff management system and method of the present invention. FIG. 4 is a flow chart of the electricity fee management system of the present invention; The utility model is a diagnosis flowchart of the electricity fee management system of the present invention; the optimal charging method of the system and the method [main component symbol description] 11 electricity fee management system host 12 receipt analysis module 13 electricity fee calculation module 14 electricity fee abnormality detection module 15 expert diagnosis Module 16 package lamp electricity bill calculation module 17 low-voltage time electricity bill calculation module 18 low-voltage non-time electricity bill calculation module 19 high-voltage two-section electricity bill calculation module 20 high-voltage three-section electricity bill calculation module 9 201220636 2 1 power factor adjustment fee Computing module 22 super-additional surcharge calculation module
1010