Batch production method for handheld console files

Abstract

The invention relates to a batch production method for handheld console files, and belongs to the technical field of power supply measurement and the technical field of information. The technical scheme of the method comprises the steps of 1, double clicking a ZJ.exe to run the program, opening an excel service, loading a handheld console template.xlsx, and activating a current workbook; 2, usinga bar code gun to scan a 22-bit bar code of an electricity meter, and automatically inputting the bar code to the ZJ.exe program; 3, after scanning of the bar code is ended, inputting 0; 4, intercepting the bar code to convert into a character type value, and generating a handheld console file named by handheld console.xlsx; and 5, ending the work. The method provided by the invention has the beneficial effects that a Python language is used for compiling a handheld console file production program, manual input is replaced with scanning of the bar code of the electricity meter by using the barcode gun, the single and repeated handheld console production process is automatically completed, the process is simple and easy to implement, the human errors are avoided, the work efficiency is improved, and the manpower and time area greatly saved.

Description

technical field [0001] The invention relates to a batch production method of handheld files, belonging to the technical field of power supply metering. Background technique [0002] The handheld is a tool that all power supply stations are using. Its two commonly used functions: modifying the meter rate and allowing the meter to switch on, both need to create a handheld file based on the barcode number of the target meter. [0003] The entire process of making handheld files includes: 1) inputting the barcode of the electric meter, 2) intercepting the meter number, and 3) generating the handheld file. [0004] 1) Barcode input: input the 22-digit barcode length into the specified excel form; [0005] 2) Table number interception: use the formula in the table to intercept the 22-digit table number into a 12-digit short number; [0006] 3) Handset file generation: the short number is copied and pasted into Notepad, the short number is converted into a numerical number, the ...

AI Technical Summary

Problems solved by technology

[0008] Most of the smart meters installed in the area of ​​Zunhua Company were installed in 2015 or even 2012. The national standard DL / T5202-2004 stipulates that the electric energy meter should be equipped with a backup battery with a service life of more than 3 years. At present, the replaced electric energy meter has appeared In the case of scrapped batteries, we are faced with the problem of investing a lot of manpower and time to replace the meters in batches and modify the tariffs

Images