CN109726378A - A kind of PCB chemical medicinal liquid analysis action data automation - Google Patents
A kind of PCB chemical medicinal liquid analysis action data automation Download PDFInfo
- Publication number
- CN109726378A CN109726378A CN201811591543.XA CN201811591543A CN109726378A CN 109726378 A CN109726378 A CN 109726378A CN 201811591543 A CN201811591543 A CN 201811591543A CN 109726378 A CN109726378 A CN 109726378A
- Authority
- CN
- China
- Prior art keywords
- analysis
- function
- medicinal liquid
- setting
- initial data
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000004458 analytical method Methods 0.000 title claims abstract description 53
- 239000000126 substance Substances 0.000 title claims abstract description 38
- 239000007788 liquid Substances 0.000 title claims abstract description 31
- 230000009471 action Effects 0.000 title claims abstract description 17
- 239000003814 drug Substances 0.000 claims abstract description 46
- 238000013215 result calculation Methods 0.000 claims abstract description 20
- 229940079593 drug Drugs 0.000 claims description 35
- 239000004615 ingredient Substances 0.000 claims description 31
- 238000004519 manufacturing process Methods 0.000 claims description 7
- 238000012546 transfer Methods 0.000 claims description 6
- 230000004048 modification Effects 0.000 claims description 5
- 238000012986 modification Methods 0.000 claims description 5
- 230000002159 abnormal effect Effects 0.000 claims description 3
- 238000012790 confirmation Methods 0.000 claims description 2
- 238000000034 method Methods 0.000 abstract description 7
- 238000012360 testing method Methods 0.000 abstract description 3
- 238000004321 preservation Methods 0.000 abstract 1
- 230000008901 benefit Effects 0.000 description 4
- 230000008569 process Effects 0.000 description 3
- 238000005070 sampling Methods 0.000 description 3
- 238000004364 calculation method Methods 0.000 description 2
- 239000003086 colorant Substances 0.000 description 2
- 238000010586 diagram Methods 0.000 description 2
- 230000000694 effects Effects 0.000 description 2
- 238000006243 chemical reaction Methods 0.000 description 1
- 230000006872 improvement Effects 0.000 description 1
- 238000002360 preparation method Methods 0.000 description 1
Landscapes
- Medical Treatment And Welfare Office Work (AREA)
Abstract
The invention discloses a kind of PCB chemical medicinal liquids to analyze action data automation, includes the following steps: the setting of S1 basic parameter information, the setting of S2 analysis date and time, the setting of S3 liquid medicine state, the input of S4 initial data and Analysis result calculation setting, the setting of S5 additional amount and S6 cryptoguard.By using this method: after manual analysis obtains initial data, initial data is inputted in Excel system, test can be analyzed PCB chemical medicinal liquid to carry out automatic calculated result and additional amount, determine result automatically, and can be used as the preservation of electronics shelves, have the characteristics that it is convenient and efficient, without additional increase cost, save that the time, error rate is low, retrospective is good.
Description
Technical field
The invention belongs to PCB to produce chemical medicinal liquid analysis technical field, and more specifically more particularly to a kind of PCB is chemical
Liquid medicine analyzes action data automation.
Background technique
In PCB factory, chemical medicinal liquid huge number, concentration is of crucial importance for product quality, so needing routine analysis
Test, comprising: sample is analyzed, according to initial data calculate analysis result, determine result whether control range it
Interior, calculating additional amount.
Currently, major part PCB factory is all manual sampling analysis, manual Calculation results and benefit after initial data are obtained
Dosage, it is more demanding to personnel's professional skill, have the shortcomings that speed is slow, error-prone, and without electronic archive, retrospective is poor.
Although automatically analyzing currently there are some PCB liquid medicine and adding equipment automatically, cost is very high, due to
PCB factory liquid medicine quantity is various, and only the important liquid medicine of only a few, which has used, automatically analyzes and add equipment automatically.Therefore, we
It needs to propose that one kind is easy to operate, be easy to implement, precisely quickly PCB chemical medicinal liquid analyzes action data automation.
Summary of the invention
The purpose of the present invention is to solve disadvantages existing in the prior art, and a kind of PCB chemical drugs moisture proposed
Analyse action data automation.
To achieve the above object, the invention provides the following technical scheme:
A kind of PCB chemical medicinal liquid analysis action data automation, includes the following steps:
S1, the setting of basic parameter information: the setting input basic parameter information in Excel table, including analysis item
Mesh, control range, cylinder volume, adds point, control point, result calculation formula coefficient, adds equation coefficients analysis frequency；
S2, analysis date and time setting: drop-down selection is provided using NOW function and data validity, options is only
For current system date and time, it is ensured that the accuracy of date and time；
S3, the setting of liquid medicine state: drop-down selection is provided using data finiteness, embodies production line current state；
S4, initial data input and Analysis result calculation setting: initial data is to be manually entered, Analysis result calculation formula
Using IF array function, the result calculation formula coefficient for transferring initial data and S1 calculates automatically, and array function can avoid artificial
Modification analysis result；
S5, additional amount setting: using IF function, transfer adding point, control point, cylinder volume, adding equation coefficients for S1, from
It is dynamic to calculate additional amount；
S6, cryptoguard: in addition to initial data, other all items use cryptoguard.
Preferably, the Excel function of the S4 and S5 transfers the parameter information of S1, once be provided with, function formula without
It needs to modify, need to only modify the parameter information in S1 when necessary, prevent function from malfunctioning.
Preferably, the liquid medicine state options in the S3 includes normal production, newly opens cylinder and abnormal option.
Preferably, the analysis project includes drug ingredient A, drug ingredient B and drug ingredient C, and analyzes result
It include the increment of chemicals D and the increment of chemicals E；Wherein, the increment of chemicals D is by drug ingredient A, drug
Ingredient B is calculated by function formula T, and the increment of chemicals E passes through function formula Y by drug ingredient B, drug ingredient C
It is calculated.
Preferably, the function formula T and function formula Y when in use, are required to call cylinder volume, add point, control
Point, result calculation formula coefficient and equation coefficients are added, and is provided with encryption lock on function formula T and function formula Y
Module prevents function formula from being tampered, impact analysis result.
Preferably, in the S4, while to analysis result use condition format, when it is more than the control range in S1
When, colors different as the result is shown is analyzed, result judgement can be quickly carried out.
Preferably, the initial data mentioned in the S4 be the type of drug ingredient obtained by drug chemistry analysis and
Levels data.
Preferably, when inputting initial data in the S4, it is set as signature block in the previous column of initial data, is confirmed
Initial data inputs person liable.
Preferably, the other all items mentioned in the S6 include analysis project, analysis frequency, control range,
Cylinder volume adds point, control point, result calculation formula coefficient, adds equation coefficients and function formula.
A kind of technical effect and advantage of the invention: PCB chemical medicinal liquid analysis database preparation system provided by the invention
System, the present invention is based on Excel, use function, data validity, conditional formats, cipher protection function:
1, in use, analysis personnel need to only input initial data can automatic Calculation results and benefit for the system
Dosage, and when analyzing result beyond control range, it can quickly identify；
2, without specific value in used function formula, the array and parameter only called, once it is provided with, function
It is not necessary to modify need to only modify the parameter of calling when necessary；It can prevent from artificially modifying using array function, guarantee that data have
Effect property；
3, using cryptoguard, it is ensured that this method is not tampered；
4, retrospective is ensured by electronic archive.
Detailed description of the invention
Fig. 1 is the structural schematic diagram of analysis project when the present invention is implemented；
Fig. 2 is the structural schematic diagram of result calculating process when the present invention is implemented.
Specific embodiment
In order to make the objectives, technical solutions, and advantages of the present invention clearer, below in conjunction with specific embodiment, to this
Invention is further elaborated.It should be appreciated that the specific embodiments described herein are merely illustrative of the present invention, not
For limiting the present invention.Based on the embodiments of the present invention, those of ordinary skill in the art are not before making creative work
Every other embodiment obtained is put, shall fall within the protection scope of the present invention.
Embodiment 1
A kind of PCB chemical medicinal liquid analysis action data automation, includes the following steps:
S1, the setting of basic parameter information: the setting input basic parameter information in Excel table, including analysis item
Mesh, control range, cylinder volume, adds point, control point, result calculation formula coefficient, adds equation coefficients analysis frequency；
S2, analysis date and time setting: drop-down selection is provided using NOW function and data validity, options is only
For current system date and time, it is ensured that the accuracy of date and time；
S3, the setting of liquid medicine state: drop-down selection is provided using data finiteness, embodies production line current state；Wherein,
Liquid medicine state options includes normal production, newly opens cylinder and abnormal option；
S4, initial data input and Analysis result calculation setting: initial data is to be manually entered, Analysis result calculation formula
Using IF array function, the result calculation formula coefficient for transferring initial data and S1 calculates automatically, and array function can avoid artificial
Modification analysis result；Simultaneously to analysis result use condition format, when it is more than the control range in S1, analysis is as the result is shown
Different colors can quickly carry out result judgement；The initial data is to analyze the drug ingredient obtained by drug chemistry
Type and levels data；
S5, additional amount setting: using IF function, transfer adding point, control point, cylinder volume, adding equation coefficients for S1, from
It is dynamic to calculate additional amount；The Excel function of the S4 and S5 transfers the parameter information of S1, once being provided with, function formula is not necessarily to
Modification, need to only modify the parameter information in S1 when necessary, prevent function from malfunctioning；
S6, cryptoguard: in addition to initial data, other all items use cryptoguard；Other all items packets
Analysis project has been included, analysis frequency, control range, cylinder volume, point has been added, control point, result calculation formula coefficient, adds formula
Coefficient and function formula.
In the specific implementation, the analysis project includes drug ingredient A, drug ingredient B and drug ingredient C, and is divided
Analysing result includes the increment of chemicals D and the increment of chemicals E；Wherein, the increment of chemicals D is by drug ingredient
A, drug ingredient B is calculated by function formula T, and the increment of chemicals E passes through function by drug ingredient B, drug ingredient C
Formula Y is calculated；The function formula T and function formula Y when in use, are required to call cylinder volume, add point, control
Point, result calculation formula coefficient and equation coefficients are added, and is provided with encryption lock on function formula T and function formula Y
Module prevents function formula from being tampered, impact analysis result.In operation input initial data, before initial data
Signature block is set as in one column, confirmation initial data inputs person liable.
In the specific implementation, the project for needing to analyze has the concentration of drug ingredient A, drug ingredient B and drug ingredient C big
Small, the control range of the concentration of drug ingredient A is (Am-An), the control model of the concentration of drug ingredient B in specific operation process
It encloses for (Bm-Bn), the concentration control range of drug ingredient C is (Cm-Cn), after being monitored sampling analysis, by initial data
When A1, B1 and C1 data are input in Excel table, if there is the concentration of A1 lower than Am, other are normal, then the Data Color of A1
Become red, warns；At this time by the increment D1 of observation chemicals D, can be added directly into chemical reaction pot pair
The chemicals D of D1 data is answered, preliminary adjust is completed and analyzes；And so on, when, which there is red, in chemicals data warns, as B2,
The data such as C3, in actual operation；The concentration that each drug ingredient that sampling analysis obtains can be directly inputted, carries out calculating correspondence
Chemicals increment.
In the actual operation process, it is necessary first to debugged, will debugging function, control range, cylinder volume, add point,
Control point, result calculation formula coefficient and add equation coefficients complete setting after, preceding ten production need manually checked,
After checking errorless, encrypted.So that it is guaranteed that the accuracy of data, avoids the error generated excessive, causes a large amount of low quality
Product is scrapped.
In summary: by using this method: after manual analysis obtains initial data, initial data being inputted Excel
In system, test can be analyzed PCB chemical medicinal liquid and carry out automatic calculated result and additional amount, automatic judgement as a result, and can
To save as electronics shelves, have convenient and efficient, nothing is additional increase cost, save the spies such as the time, error rate is low, retrospective is good
Point.
Finally, it should be noted that the foregoing is only a preferred embodiment of the present invention, it is not intended to restrict the invention,
Although the present invention is described in detail referring to the foregoing embodiments, for those skilled in the art, still may be used
To modify the technical solutions described in the foregoing embodiments or equivalent replacement of some of the technical features,
All within the spirits and principles of the present invention, any modification, equivalent replacement, improvement and so on should be included in of the invention
Within protection scope.
Claims (9)
1. a kind of PCB chemical medicinal liquid analyzes action data automation, characterized by the following steps:
S1, the setting of basic parameter information: the setting input basic parameter information in Excel table including analysis project, is divided
Analysis frequency, adds point, control point, result calculation formula coefficient, adds equation coefficients control range, cylinder volume；
S2, analysis date and time setting: drop-down selection is provided using NOW function and data validity, options is only to work as
Preceding system date and time, it is ensured that the accuracy of date and time；
S3, the setting of liquid medicine state: drop-down selection is provided using data finiteness, embodies production line current state；
S4, initial data input and Analysis result calculation setting: initial data is to be manually entered, and Analysis result calculation formula uses
IF array function, the result calculation formula coefficient for transferring initial data and S1 calculate automatically, and array function can avoid artificial modification
Analyze result；
S5, additional amount setting: using IF function, transfer adding point, control point, cylinder volume, adding equation coefficients for S1, automatic to count
Calculate additional amount；
S6, cryptoguard: in addition to initial data, other all items use cryptoguard.
2. a kind of PCB chemical medicinal liquid according to claim 1 analyzes action data automation, it is characterised in that: described
The Excel function of S4 and S5 transfers the parameter information of S1, once being provided with, it is not necessary to modify need to only repair function formula when necessary
Change the parameter information in S1, prevents function from malfunctioning.
3. a kind of PCB chemical medicinal liquid according to claim 1 analyzes action data automation, it is characterised in that: described
Liquid medicine state options in S3 includes normal production, newly opens cylinder and abnormal option.
4. a kind of PCB chemical medicinal liquid according to claim 1 analyzes action data automation, it is characterised in that: described
Analysis project includes drug ingredient A, drug ingredient B and drug ingredient C, and analyzes the supply that result includes chemicals D
The increment of amount and chemicals E；Wherein, the increment of chemicals D passes through function formula T by drug ingredient A, drug ingredient B
It is calculated, the increment of chemicals E is calculated by drug ingredient B, drug ingredient C by function formula Y.
5. a kind of PCB chemical medicinal liquid according to claim 4 analyzes action data automation, it is characterised in that: described
Function formula T and function formula Y when in use, are required to call cylinder volume, add point, control point, result calculation formula coefficient
And equation coefficients are added, and be provided with encryption lock module on function formula T and function formula Y, prevent function formula quilt
It tampers, impact analysis result.
6. a kind of PCB chemical medicinal liquid according to claim 1 analyzes action data automation, it is characterised in that: in institute
It states in S4, while to analysis result use condition format, when it is more than the control range in S1, analyzing different as the result is shown
Color can quickly carry out result judgement.
7. a kind of PCB chemical medicinal liquid according to claim 1 analyzes action data automation, it is characterised in that: described
The initial data mentioned in S4 is the type and levels data of the drug ingredient obtained by drug chemistry analysis.
8. a kind of PCB chemical medicinal liquid according to claim 1 analyzes action data automation, it is characterised in that: in institute
When stating input initial data in S4, signature block is set as in the previous column of initial data, confirmation initial data inputs person liable.
9. a kind of PCB chemical medicinal liquid according to claim 1 analyzes action data automation, it is characterised in that: in institute
The other all items mentioned in S6 are stated to include analysis project, analysis frequency, control range, cylinder volume, add point, control
Point, adds equation coefficients and function formula at result calculation formula coefficient.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811591543.XA CN109726378A (en) | 2018-12-25 | 2018-12-25 | A kind of PCB chemical medicinal liquid analysis action data automation |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811591543.XA CN109726378A (en) | 2018-12-25 | 2018-12-25 | A kind of PCB chemical medicinal liquid analysis action data automation |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN109726378A true CN109726378A (en) | 2019-05-07 |
Family
ID=66297056
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811591543.XA Pending CN109726378A (en) | 2018-12-25 | 2018-12-25 | A kind of PCB chemical medicinal liquid analysis action data automation |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109726378A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110890159A (en) * | 2019-11-23 | 2020-03-17 | 潍坊学院 | Method for evaluating antibacterial drug combination effect by using Excel function |
| CN113189940A (en) * | 2021-03-16 | 2021-07-30 | 广州广合科技股份有限公司 | Method for realizing PCB liquid medicine analysis and adjustment based on ERP system, electronic equipment and storage medium |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103632020A (en) * | 2012-08-22 | 2014-03-12 | 昆达电脑科技(昆山)有限公司 | Excel budgeting system |
| CN105787845A (en) * | 2016-03-25 | 2016-07-20 | 东莞美维电路有限公司 | Liquid medicine tracing back system and method |
-
2018
- 2018-12-25 CN CN201811591543.XA patent/CN109726378A/en active Pending
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103632020A (en) * | 2012-08-22 | 2014-03-12 | 昆达电脑科技(昆山)有限公司 | Excel budgeting system |
| CN105787845A (en) * | 2016-03-25 | 2016-07-20 | 东莞美维电路有限公司 | Liquid medicine tracing back system and method |
Non-Patent Citations (1)
| Title |
|---|
| 张宏亮等: "Excel软件快速计算住院患者抗菌药物使用强度的技巧探讨", 《中国医院用药评价与分析》 * |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110890159A (en) * | 2019-11-23 | 2020-03-17 | 潍坊学院 | Method for evaluating antibacterial drug combination effect by using Excel function |
| CN113189940A (en) * | 2021-03-16 | 2021-07-30 | 广州广合科技股份有限公司 | Method for realizing PCB liquid medicine analysis and adjustment based on ERP system, electronic equipment and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US20170315543A1 (en) | Evaluating petrochemical plant errors to determine equipment changes for optimized operations | |
| CN109726378A (en) | A kind of PCB chemical medicinal liquid analysis action data automation | |
| CN104536858B (en) | For the method for 1553B bus communication remote terminal automatic tests | |
| CN108681801B (en) | Method and system for monitoring operation index in production process | |
| CN108427093A (en) | A kind of calibrating and measuring system and method for watt-hour meter automatic verification device | |
| CN102262401A (en) | Industrial production line monitoring system | |
| DE102012110166A1 (en) | Predicted error analysis | |
| CN106295840A (en) | A kind of optimize the method for production line operation, device and production line | |
| CN107545361A (en) | Compare System and method between room | |
| CN107094086A (en) | A kind of information acquisition method and device | |
| CN107767024A (en) | One kind is used for cover-plate glass product of production line quality real-time monitoring system and method | |
| CN108319664A (en) | A kind of dam and the recognition methods of project security monitoring data error and system | |
| CN111046982B (en) | Equipment data monitoring method and device, computer equipment and storage medium | |
| Ganpati et al. | A comparative study of maintainability index of open source software | |
| CN106440225A (en) | Machine room temperature 3D monitoring method and device | |
| JP2010517167A (en) | Process variable transmitter validation | |
| CN110717273A (en) | Technological process simulation boundary condition construction method | |
| CN104243215B (en) | Method, equipment and the system of terminal device password management | |
| CN114521257A (en) | Assisted query building and data retrieval | |
| TW202125136A (en) | analysis system | |
| CN114070829B (en) | Abnormal data acquisition method and system based on MQTT | |
| CN106950933B (en) | Quality conformance control method and device, computer storage medium | |
| CN106444931A (en) | A white spirit alcoholic strength on-line monitoring method and a monitoring device | |
| JP2019070589A (en) | Flow rate computing device | |
| CN108722215A (en) | A kind of method, system and terminal device for preparing solution |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| AD01 | Patent right deemed abandoned | ||
| AD01 | Patent right deemed abandoned |
Effective date of abandoning: 20231117 |