CN1092884A - Laboratory in cement works computer management method and system - Google Patents

Abstract

The invention discloses the method and system of a kind of Applied Computer Techniques to the laboratory in cement works management.It is the new data management model of one that the present invention has successfully set up collection laboratory in cement works data computation, statistics, inquiry, and some are difficult to the professional formula modularization calculated with conventional method, makes work efficiency improve more than hundred times.

Description

Laboratory in cement works computer management method and system

The present invention relates to management automation field, cement mill, more particularly, relate to the method and system of a kind of Applied Computer Techniques the laboratory in cement works management.

An important routine work of laboratory in cement works is that a large amount of production runes and product quality check and analysis data are added up, calculated and file.Usually the method that adopts is artificial calculating, statistic law at present.Collect raw data by each production testing department and report the laboratory every day, utilizes conventional computational tool (abacus, counter) to calculate by the statistician, will carry out class's statistics every day, day statistics; Carried out once month statistics in every month; Carry out a next year statistics every year.Means are quite backward, can not catch up with the requirement of current cement mill management at all.

The cement mill raw mix formula mainly adopts two kinds of methods to calculate at present, be algebraic approach and error hit-and-miss method, but because computation process complexity, computational tool falls behind, in general the cement mill does not use computing method to calculate, but make prescription according to the experience of oneself by the laboratory director, by the semi-manufacture chemical analysis results of producing, difference is adjusted prescription according to circumstances, from producing the result of laboratory test several hrs that comes out generally to want, be in runaway condition in the cement mill, add the instability of supplied materials chemical analysis and produce in the meantime, cause the frequent variations of prescription, thereby directly have influence on the quality of raw material.

Management method falls behind, and is example with a standard production line of producing 8.8 ten thousand tons of cement per year, and annual statistician will face the housekeeping of up to a million data, if the data form in 1 year stacked several meters height is arranged! Large batch of like this data, form all adopt artificial tabulation, and the method for classification and inquiry manages, and sometimes in order to make a certain table, inquire about data and will spend several hrs, even several days time, the work efficiency reliability is extremely low.

The calculating means fall behind, neither one laboratory in cement works dedicated computing instrument, and some computing method of laboratory in cement works and computing formula are all definite, and often use, but very complicated with conventional computational tool calculating, as: calculating of three ratio or the like, work efficiency are extremely low.

As mentioned above, because the backwardness of cement mill data processing means and method, make a fault unavoidably or miscount, and this will cause unnecessary waste and loss to enterprise, the cement mill in the whole nation with and be responsible for government department and all urgently wish to set up a laboratory data management model, adopt advanced computer generation for artificial, big at current laboratory in cement works management information amount, processing speed is slow, reliability, the phenomenon that accuracy is low, the development and set up cement mill data management model, make laboratory in cement works systematic management, standardization.

The object of the present invention is to provide a kind of laboratory in cement works management method and system that laboratory in cement works data computing, statistics and inquiry are the Applied Computer Techniques of one that collect.

The present invention also aims to provide a kind of can be with those be difficult to the professional formula modularization calculated with conventional means in the laboratory in cement works, laboratory in cement works management method and system that the work efficiency in laboratory is improved greatly.

The present invention also aims to provide a kind of laboratory in cement works management method and system of very being convenient to manipulate to enrich feature such as Chinese character demonstration, man-machine conversation function, menu mode man-machine interface that have.

The object of the present invention is achieved like this, construct a laboratory in cement works computer management system and mainly form, use this laboratory in cement works computer management system and carry out the method for laboratory in cement works management and include: recipe calculation, laboratory management of data tables, auxiliary calculating and steps such as file processing by industrial computer, display device, keyboard, printer, UPS etc.

Recipe calculation in the laboratory in cement works management method of the present invention comprises: steps such as complete black meal recipe calculation, semiblack meal recipe calculation, common meal recipe calculation, formulation management.Wherein first three step all comprise be received in the data inserted in the parameter page or leaf and on the prescription page or leaf step of output prescription, the packet of described parameter page or leaf input contains: the material composition data that have or not certain material in the indication prescription of representing with "Yes", "No"; The complete chemical analysis data that have material in the indication prescription of representing with number percent; The data of indication fluorite, gypsum blending method and number percent; The hear rate data of the calorific value of coal, ash content A and grog and design three ratio data; Can select and import service time when a plurality of prescription is arranged on the described prescription page or leaf, confirm also whether selection deposits;

Above-mentioned formulation management step comprises: fills a prescription according to being retrieved of input and uses the date in computer, to retrieve, as retrieve, show the formulation parameter page or leaf and the page or leaf of all filling a prescription, and the step of printing prescription.

Laboratory management of data tables step in the laboratory in cement works management method of the present invention comprises: data typing, data modification, data statistics, data retrieval and form printing step; Each above-mentioned step all is that the table menu of consolidation form is carried out, and described table menu includes title, form operation flag, table content and presenting bank, and described form operation flag includes typing, modification, statistics, retrieval and printing; Described title has: cement mill raw material chemical analysis raw readings, cement mill proximate analysis of coal raw readings, starting material dries quantity controlling recording, cement slurry flow demand logging, raw material bistrique raw meal particle size record, raw material bistrique material moisture record, go out to grind raw material quality control record, go into kiln raw material quality control record, grog physical examination raw readings, grog stability check raw readings, grog is checked raw readings setting time, grog density, the specific area measuring raw readings, cement proportion flow selective examination raw readings, finished product bistrique raw meal particle size demand logging, go out to grind SO3 fineness controlling recording, go out to grind cement physical examination raw readings, go out to wear away soundness of cement check raw readings, go out to grind cement setting time check raw readings, cement physical examination raw readings, soundness of cement check raw readings, the cement setting time that dispatches from the factory check raw readings, cement density specific area measuring raw readings, the cement uniformity testing that dispatches from the factory report, cement S03 dispatches from the factory, loss on ignition check raw readings, bag of cement is heavily spot-check strain beginning record, raw material Shop floor control statistical form, go into kiln raw material production control statistical form, kiln discharge manufacture of cement control statistical form, kiln discharge raw material chemical analysis machine account, go into kiln raw material chemical analysis machine account, kiln discharge grog physical examination machine account, kiln discharge grog chemical analysis machine account, the cement quality machine account dispatches from the factory, go out to grind the tired summary table of raw material quality, go into the tired summary table of kiln raw material quality, clinker quality tires out summary table, go out to grind the tired summary table of cement quality, the packing bag of cement heavily reaches the tired summary table of stability quality, the cement quality that dispatches from the factory tires out summary table, the cement quality statistical form dispatches from the factory, cement physical cell experiment condition raw readings, cement mill controlling index scope, cement mill raw mix formula design table.

Auxiliary calculating in the laboratory in cement works management method of the present invention comprises: chemical analysis, mineral composition and three ratio calculation procedure, butt, warm basic conversion step; Percentage by weight conversion step; Calculating such as mean value, standard deviation and weighted mean value calculation procedure.

Described file processing step in the laboratory in cement works management method of the present invention comprises that data backup, data are packed into, data deletion and disk initialization step.

Implement method and system of the present invention, have following characteristics:

1. this system has very strong practicality and novelty, and it makes the laboratory rise to new height by managed by micro computer from labor management, makes laboratory management standardization, standardization more, has improved the work efficiency in laboratory greatly.

2. simple to operate, speed is fast, user interface close friend, full menu in Chinese shows, very strong man-machine conversation function need not imported Chinese character, only needs input digit or can finish every function operations by each function key (hot key), be easy to learn and use, those of ordinary skill only need train or read in detail user manual a little and can skillfully operate.

3. software has adopted many safety practices, to guarantee the safety of data of user's storage.

4. adopt high jamproof industrial 286 microcomputers, dustproof case and keyboard, system hardware have very strong reliability and security.

In conjunction with the accompanying drawings, the invention will be further described.

In the accompanying drawing:

Fig. 1 is for implementing the system layout of laboratory in cement works computer management method of the present invention;

Fig. 2 is a laboratory in cement works computer management method structured flowchart of the present invention;

Fig. 3 is the structured flowchart of recipe calculation in the laboratory in cement works computer management method shown in Figure 2;

Fig. 4 is the structured flowchart of laboratory management in the computer management method of cement shown in Figure 2 laboratory;

Fig. 5 is the auxiliary structured flowchart that calculates in the laboratory in cement works computer management method shown in Figure 2;

Fig. 6 is the structured flowchart of file processing in the laboratory in cement works computer management method shown in Figure 2;

Fig. 7 is the program flow diagram of Fig. 3 recipe calculation;

Fig. 8 is for using cement mill production control quality management data model synoptic diagram in the present invention;

Fig. 9 realizes that the programming flowchart of retrieving is revised in typing among Fig. 4;

Figure 10 is a programming flowchart of realizing Fig. 4 data statistics step;

Figure 11 is a programming flowchart of realizing chemical analysis chemical composition and three ratio switch process among Fig. 5;

Figure 12 is a programming flowchart of realizing butt number percent and warm basic number percent conversion step among Fig. 5;

Figure 13 is a programming flowchart of realizing flow and number percent switch process among Fig. 5;

Figure 14 is a programming flowchart of realizing statistical function step among Fig. 5;

Figure 15 is a programming flowchart of realizing weighted mean value calculation procedure among Fig. 5;

Realize the programming flowchart of data backup step among Fig. 6 among Figure 16;

Figure 17 realizes pack into the programming flowchart of step of data among Fig. 6;

Figure 18 realizes the programming flowchart of data deletion step among Fig. 6;

Figure 19 is a programming flowchart of realizing disk initialization step among Fig. 6.

As shown in Figure 1, the hardware configuration of implementing the system of laboratory in cement works computer management method of the present invention comprises 286 Industrial Control Computers, keyboard, standard VGA display, UPS uninterrupted power source, EPSON LQ-1600K Chinese and western languages printer.The basis of this hardware is provided with the MS DOS 5.0 of Microsoft and the Western Hills hanzi system software environment as native system.

Fig. 2 has listed the composition of laboratory in cement works computer management method of the present invention, and promptly this method comprises recipe calculation, laboratory management, auxiliary calculating and file processing.

The details of recipe calculation part is described in conjunction with Fig. 3.

1, function

Be applicable to complete black meal, the recipe calculation of semiblack meal and common meal and management.Can select raw material type in the raw mix formula arbitrarily according to the different situations of each cement mill.As long as each material complete chemical analysis of input, the technical analysis of coal, and designed prescription hear rate that grog requires and three ratio just can calculate the prescription of raw material rapidly.Have under the situation that mineralizer adds, its method of mixing is defined as physics method and chemical method, and (how many mineralizers are the physics method for directly mixing at raw material; How many mineralizer chemical constitutions chemical method for joining in raw material).The method of mixing that can select coal in semiblack meal calculates is promptly: account for number percent in the raw material or mix the number percent of full coal amount in raw material.Mixing method and mix number percent according to mineralizer, calculate the proportioning of mineralizer automatically, is foundation with the design three ratio at last, calculates the prescription of raw material with reference to the proportioning of mineralizer and coal.

In recipe calculation, raw mix formula can also be imported, the anti-calculating three ratio of testing by calculating several times, can be tried to achieve satisfied prescription.

In formulation management, with the date as sequence number, as long as input uses the date of prescription just can find this prescription rapidly.

2, principle

The desired value of raw mix formula is the three ratio of grog, and promptly the three ratio that burns till behind the grog of the raw material of being allotted by this prescription is necessary for desired value.The three ratio of raw material equates fully that with the three ratio of grog this is because raw material burn till grog, burns the loss on ignition part in the just raw material that lose, main chemical (CaO.Fe ₂O ₃Al ₂O ₃SO ₃SiO ₂Deng) all remain, their ratios in grog are in the 100/(100-loss on ignition) ratio change the constant rate between each oxide, so the grog three ratio equates fully with the three ratio that burns preceding raw material.

Have coal and mineral (fluorite, gypsum) to add in raw mix formula, but they are not raw material after all, coal is a fuel, and mineralizer is a kind of adulterating agent, plays certain booster action, and primary raw material has lime stone, iron powder, clay etc.

1. propose the calorific value Q of coal by the technical analysis of coal, make the proportioning G that the hear rate of whenever burning till 100 kilograms of grogs just can be calculated as follows coal according to the situation of our factory by producer:

G=(Q')/(Q) (100-L0) Kg coal/100 raw material ... .(1)

L0 is the loss on ignition of raw material in the formula, and it is by experimental formula

L0=35+(39-0.6A) (Q')/(Q) ... ... (2) draw

A is a pit ash, draws by the technical analysis of coal, by the ratio formula that must produce coal with (1) (2) formula in raw material:

G＝ (Q')/(Q) [75+（39-0.6·A）· (Q')/(Q) ].........（3）

2. the method for mixing and the incorporation of mineralizer

By extensive studies, sum up two kinds of mineralizers and mixed method, be defined as chemical method and physics method, so-called physics method is exactly directly to make the ratio of mineralizer in raw material by the user according to own rich experience and our factory's actual conditions.This is a present factory common method.Chemical method is exactly the number percent (the corresponding CaF2 of fluorite, the corresponding SO3 of gypsum) that is just provided the corresponding chemical constitution of mineralizer in the raw material by the user, and by formula (4) calculate the proportioning of mineralizer in raw material.

K＝F/P.......（4）

F: the number percent of the chemical constitution that each hundred kilograms of raw material requirement is mixed.

P: corresponding chemical constitution number percent in the mineralizer.

3. the proportioning of primary raw material is calculated

Top (3) and (4) are calculated the proportioning of producing coal with mineralizer just can calculate the number percent of their pairing oxides in whole raw material, and their pairing three rate values.

If: require three rate values to be respectively KH, N, P

Calculate lime stone, iron powder, clay and other proportion of raw materials X, Y, Z, v, establish: the proportioning of three kinds of mineralizers is respectively H1 again, H2, H3.

The proportioning of coal is G, and four kinds of raw materials, the complete chemical analysis of three kinds of mineralizers and coal finish to distinguish with the subscript of 1-8 respectively, raw material do not pour down mark.The following symbol of chemical constitution:

C：CaO

S：SiO ₂

A：Al ₂O ₃

F：Fe ₂O ₃

V：SO ₃

Reach desired value and have in order to satisfy in the raw material saturation ratio KH:

KH＝ (C-（1.65A-0.7V-0.35F）)/(2.8XS) ..........（5）

So: C=C1X+C2Y+C3Z+C4R+C5H1+C6H2+C7H3+C8G

S＝S1X+S2Y+……+S8G..........（6）

A＝A1X+A2Y+……+A8G

F＝F1X+F2Y+……+F8G

V＝V1X+V2Y+……+V8G

With (6) substitution (5) and establish:

K1＝2.8KHxS1+1.65A1+0.7V1+0.35F1-C1

K2＝2.8KHxS2+1.65A2+0.7V2+0.35F2-C2.......（7）

.

.

.

K8＝2.8KHxS8+1.65A8+0.7V8+0.35F8-C8

Obtain following formula:

K1X+K2Y+K3Z+K4R+K5H1+K6H2+K7H3+K8G＝0.......（8）

Same in order to satisfy N and the P in the raw material, as long as establish:

N1＝N（A1+F1）-S1

N2＝N（A2+F2）-S2

. .......（9）

.

.

N8＝N（A8+F8）-S8

P1＝PF1-A1

P2＝PF2-A2

. ........（10）

P8＝PF8-A8

Can get:

N1X+N2Y+N3Z+N4R1+N5H1+N6H2+N7H3+N8G＝0....（11）

P1X+P2Y+P3Z+P4R+P5H1+P6H2+P7H3+P8G＝0....（12）

Have only XYZR to be value to be separated in the formula of front (8) (11) (12), other all can be asked by the proportioning of chemical analysis results and coal mineralizer.Below we divide three kinds of briefings prescription how to find the solution

(I) four component recipe calculation

This moment X, Y, Z, four kinds of materials of R are all participated in batching.Have:

K1X+K2Y+K3Z+K4R+K5H1+K6H2+K7H3+K8G＝0

N1X+N2Y+N3Z+N4R+N5H1+N6H2+N7H3+N8G＝0.....（13）

P1X+P2Y+P3Z+P4R+P5H1+P6H2+P7H3+P8G＝0

X+Y+Z+H1+H2+H3+G＝100

Separating this system of equations can draw the prescriptions that three ratio all satisfies and separate.

(II) three component recipe calculation

This moment X, Y, Z, four kinds of materials of R have only three kinds to participate in batching, are made as X, Y, Z have three groups to separate at this moment:

A kind of is to satisfy separating of KH and N

K1X+K2Y+K3Z+K5H1+K6H2+K7H3+K8G＝0

N1X+N2Y+N3Z+N5H1+N6H2+N7H3+N8G＝0.....（14）

X+Y+Z+H1+H2+H3+G＝100

Second kind is to satisfy separating of KH and P

K1X+K2Y+K3Z+K5H1+K6H2+K7H3+K8G＝0.....（15）

P1X+P2Y+P3Z+P5H1+P6H2+P7H3+P8G＝0

X+Y+Z+H1+H2+H3+G＝100

The third is separated and is preceding two groups of mean values of separating, it can only satisfy KH but N, P near set-point.

If (14) separate and be X1, Y1, Z1

(15) separate and be X2, Y2, Z2

The 3rd separate into

X3＝（X1+X2）/2

Y3＝（Y1+Y2）/2

Z3＝（Z1+Z2）/2

(III) two component recipe calculation

This moment X, Y, Z, four kinds of materials of R have only two kinds to participate in batching, are made as X, Y, have one group to separate this moment:

Can only satisfy KH

K1X+K2Y+K5H1+K6H2+K7H3+K8G＝0.......（16）

X+Y+H1+H2+H3+G＝100

4. semiblack meal calculates from raw mix formula

So-called semiblack meal promptly adds the part coal in raw meal proportioning, other coal is that outer coal blending adds going into the kiln previous crops.Therefore, as long as after pressing the proportioning of customer requirements change coal, revise the proportioning of each material by following formula.

X'＝ (X)/(100-（G-G'）) ·100

X: the proportioning of material when coal all mixes.

G: the proportioning of coal in complete black meal.

G': the ratio of the coal that requirement is mixed.

X': the proportioning of material in the semiblack meal.

The calculating of outer coal blending:

Outside the G'=(outer G-G') X 100/ (100-(G-G'))

Outside the G': every 100Kg semiblack meal institute coal blending amount

G: the proportioning of coal in the complete black meal

G': the ratio of the coal that requirement is mixed

So-called common meal, i.e. not coal blending in raw meal proportioning, coal is that outer coal blending adds going into the kiln previous crops all, can revise proportioning by following formula:

X″＝ (X)/(100-G)

X ": the proportioning of material in the common meal

Outer coal blending amount: G " outer GX 100/ (100-G)

G " outside: the few coal of the outer coal of every 100Kg common meal

5. formulation management

It is little to consider that prescription generally changes in plant produced, sometimes may one prescription used several days, prescription is to arrange by date in depositing hard disk in, is search key with the date when the prescription inquiry, if there is not the prescription on corresponding date, just inquire about preceding first prescription of this date.

3, implementation method

The programming flowchart of recipe calculation step as shown in Figure 7 among realization Fig. 3.Promptly on routine processes recipe calculation is divided into following three display screens, promptly parameter incoming page, prescription show page or leaf and formulation selection page or leaf.

An example of parameter incoming page is as follows:

Numeral input press the input of numerical key Chinese character+-key

Esc: withdraw from PD: skip ← ↑ → ↓: select F1: ash → coal conversion F2: coal → grey conversion

Data in the input of parameter page or leaf have five classes:

One. material is formed, and has or not this material to represent with "Yes" or "No" in the prescription, with+,-the key selection.

Two. the complete chemical analysis of various raw materials, all represent with percentage.As if a certain "No" that is chosen as in the material composition, then do not import the relevant data of this material.

Three. the adulteration method of fluorite, gypsum and number percent.Adulteration method has two kinds, i.e. " physics " admixture method and " chemistry " admixture method, with+,-key selects.The number percent of physics admixture method back is represented the percentage composition of this material in raw material.The percentage of chemistry admixture method back has two kinds of situations: the number percent of fluorite chemistry admixture method is represented the content of CaF2 in raw material, and the number percent of gypsum chemistry admixture method is represented the content of SO3 in raw material.The admixture method of other mineralizer can only be admixed method for physics.

Four. the hear rate of the calorific value of coal, ash content A and grog.

Five. the design three ratio.

Import these data successively, can obtain corresponding prescription.In the input process, the usefulness cursor key → ← ↑ ↓ the selection input item.The value of coal ash and coal can be exchanged automatically, as loss on ignition, chemical constitution and the ash content of input coal ash, the loss on ignition and the chemical analysis of the coal that can convert; Otherwise,, go out the loss on ignition and the chemical analysis of the coal ash that can convert as loss on ignition, chemical analysis and the ash content of input coal.Scaling function key: F1 ash → coal conversion, F2 coal → grey conversion.If be input as the total analysis of coal ash, must be converted to the total analysis of coal by the F1 key.

The result of this function obtains raw mix formula.Raw material for two components (only containing two kinds in lime stone, clay, iron powder and four kinds of primary raw materials of other raw material) and four components (containing four kinds of primary raw materials) batching, have only a prescription, the raw material of three components (containing three kinds of primary raw materials) batching then have three prescriptions.These prescriptions are theoretical value, and we are called theoretical prescription, allow the user according to theoretical value and actual the making amendment of production, and to obtain meeting the optimum formula of our factory's actual conditions, we are called real prescription.Therefore, the raw material of two components and four components batching have two prescriptions, and prescription one is theoretical prescription, and prescription two is actual prescription; The raw material of three components batching have four prescriptions, and prescription one, two, three is theoretical prescription, and prescription four is for realizing prescription.

By the demonstration of can in formulation parameter page or leaf and each prescription page or leaf, skipping of PU and PD key.In the prescription page or leaf, can carry out formulation selection by the F3 key, press F4 key printing note page or leaf prescription.

After selecting prescription, the formulation examples that screen shows is as follows:

Complete black meal recipe calculation 1992-12-28

A 16:25:43 fills a prescription

Prescription loss on ignition SiO ₂Al ₂O ₃Fe ₂O ₃CaO MgO CaF ₂SO ₃

Lime stone 72.93 29.73 1.87 1.03 0.63 37.61 0.00 0.00 0.00

Clay 11.68 0.58 7.94 1.91 0.70 0.29 0.00 0.00 0.00

Iron powder 1.85 0.02 0.43 0.09 1.12 0.12 0.00 0.00 0.00

Other raw material

Fluorite 2.13 0.15 0.92 0.12 0.04 0.57 0.00 0.35 0.00

Gypsum 2.19 0.39 0.21 0.05 0.02 0.67 0.00 0.00 0.00

Other mineralizer

Coal 9.22 7.32 0.82 0.48 0.07 0.38 0.00 0.00 0.00

Outer coal blending

Raw material 38.19 12.19 3.69 2.56 39.63 0.00 0.35 0.80

Grog 19.72 5.96 4.15 64.12 0.00 0.57 1.30

Design load

0.940 1.950

1.438

937.30 kilojoule/kilogram grog

When a plurality of prescription was arranged, an example of formulation selection page or leaf was as follows:

Complete black meal recipe calculation 1992-12-28

Formulation selection 16:26:49

Two prescriptions three of filling a prescription fill a prescription four

Lime stone 72.93 72.80 72.86 72.86

Clay 11.68 11.54 11.61 11.61

Iron powder 1.85 2.13 1.99 1.99

Other raw material 0.00 0.00 0.00 0.00

Fluorite 2.13 2.13 2.13 2.13

Gypsum 2.19 2.19 2.19 2.19

Other mineralizer 0.00 0.00 0.00 0.00

Coal 9.22 9.22 9.22 9.22

Outer coal blending 0.00 0.00 0.00 0.00

Please select to use prescription (1-4):

When formulation selection, can select to check three ratio then conversely and whether reach requirement by user oneself input prescription.Can constantly import prescription till satisfaction.

Details in conjunction with laboratory administrative section in Fig. 4 and Fig. 8 key diagram 2.

1. function

All data qualifications of laboratory in cement works are organized into 42.Native system can carry out typing to any table, revises retrieval and printing.Only need the input raw data in tables of original record, the class of calculating adds up automatically, day statistics.Can generate moon form and year form automatically.In typing, all adopt the mode of full screen numbering in the alter mode, can insert arbitrarily, delete and undelete.By search key data query record, can print at any time arbitrary appointment form.

2. principle

(1). cement mill production control, quality management data model

Data and form that each tame cement mill production control at present, quality management are adopted have nothing in common with each other, and some can't reflect the basic condition of a factory.Native system is set up a sets of data administrative model as shown in Figure 8 for this reason.

This administrative model is embodied in 42 forms, has covered all data of cement mill production control and quality management.Existing raw data statistical report form has monthly returns and year statistical form again.

(2). data model and management

So lot of data and form manage with the conventional method programming, and procedure quantity is big well imagines.The present invention has designed conventional data typing, demonstration, update routine for this reason, conventional data deposit program, and the conventional data fetch program, conventional data search program and conventional data edit routine are greatly simplified system.

Data in each form are divided into several records, and the feature of each record reflects with the form of data, and leaves in the hard disk.When using this record, as long as the characteristic that will import in advance accesses, general purpose processor can be handled record according to these data.

On way to manage, adopt typing, modification, statistics, retrieval and printing type.The raw data of user input and handle after deposit data at hard disk, so that retrieval.The form that data are deposited in hard disk is binary code representation, has improved the information amount of storage of hard disk greatly.Deposit with the form of ASCII character such as a floating number 12.35, will account for 5 bytes in hard disk, turn to the form deposit of shaping with binary code in the native system, 04D3H only accounts for the space of two bytes.Data are deposited order in hard disk also be clocklike, generally deposits by the priority order of year, month, day, wire size, class number, character etc., can improve the access and the retrieval rate of data so greatly.

3. this administrative model of implementation method is divided into five modules from function.

The typing of data, modification and retrieval have many identical disposal routes.Just revise and retrieval will be called in and is retrieved and revises content, will forbid that for search function modification, typing, statistics, skewer are gone into, delete function.During to the typing state, be unchangeable if data are taken out from hard disk.

The data statistics function will produce table and year form automatically, mainly contain B001, raw material Workshop Production control statistical form; B1001 goes into kiln raw material production control statistical form; B201 goes out to grind manufacture of cement control statistical form; C201, the cement quality machine account dispatches from the factory; D001 goes out to grind the tired summary table of raw material quality; D002 goes into the tired summary table of kiln raw material matter; D101, clinker quality tires out summary table; D201 goes out to grind the tired summary table of cement quality; D301, packing bag of cement heavily reach the tired summary table of stability; D401, the prosperous tired summary table of output water shale; D402, the cement quality statistical form dispatches from the factory.

Whether existing this statistics detects in will be to hard disk after statistics finishes, if just exist with new, with old shoe again, if do not have, new record skewer is gone into.So just be unlikely to after repeatedly adding up, to cause a plurality of statistical items are arranged in the hard disk.

The form printing function.Can print all forms, printing can be divided into appointment printing reports and the whole month report printing.All forms of printing have deposited hard disk in document form, during use the sky table are called in, and fill in after the data for concrete form, transfer print routine to print.

The details of the modularization of laboratory dedicated computing function part in the key diagram 2.

1, function:

Some is cumbersome for laboratory in cement works, and complicated evaluation work does not still have a kind of dedicated computing instrument.Native system is developed a kind of dedicated computing module of laboratory in cement works, and it has, and raw material chemical analysis, chemical composition and three ratio are just contrary to calculate dried, wet basis conversion Calculation; Flow, number percent converts; Median, extreme difference, standard deviation, the coefficient of variation, the computing function of mean value and weighted mean value.

2, principle

1. raw material chemical analysis, chemical composition and three ratio convert

I, known chemical composition coefficient of conversion value

KH＝ (CaO-fCaO-（1.65Al2O3+0.35Fe2O3+0.70SO3）)/(2.8（SiO2-fSiO2）) （P＞0.64）

KH＝ (CaO-fCaO-（1.10Al2O3+0.7Fe2O3+0.70SO3）)/(2.8（SiO2-fSiO2）) （P＞0.64）

n＝ (SiO2)/(Al2O3+Fe2O3)

p＝ (Al2O3)/(Fe2O3)

II, known mineral composition coefficient of conversion value

KH＝ (C3S+0.8838C2S)/(C3S+1.3256C2S)

n＝ (C3S+1.3256C2S)/(1.4341C3A+2.0464C4)

p＝ (1.1501C3A)/(C4AF) +0.6368

III, known chemical composition conversion mineral composition

P＞0.64 o'clock

C3S＝4.07（CaO-fCaO）-7.60SiO2-6.72Al2O3-1.43Fe2O3-2.86SO3

C2S＝8.60SiO2+5.07Al2O3+1.07Fe2O3+2.15SO3-3.07CaO

C3A＝2.65Al2O3-1.69Fe2O3

C4AF＝4.77Al2O3

P＜=0.64 o'clock

C3S＝4.07CaO-7.60SiO2-4.47Al2O3-2.86Fe2O3-2.86SO3

C2S＝8.60SiO2+3.38Al2O3+2.15Fe2O3+2.15SO3-3.07CaO

C3A＝1.70（Fe2O3-1.57Al2O3）

C4AF＝4.77Al2O3

IV, known mineral composition conversion chemical analysis

SiO2＝0.2631C3S+0.3488C2S

Al2O3＝0.3773C3A+0.2098C4AF

Fe2O3＝0.3286C4AF

CaO＝0.7369C3S+0.6512C2S+0.6227C3A+0.4616C4AF+0.4119CaSO4

SO3＝0.5881CaSO4

2. butt, wet basis conversion

If butt number percent: G1, G2, G3 ... Gn

Wet basis number percent: S1, S2, S3 ... Sn

Moisture: W1, W2, W3 ... Wn

I, wet basis convert butt to

Gi＝ (Si（1-Wi）)/(∑) （i＝1，2…n）

∑＝S1（1-W1）+S2（1-W2）+…+Sn（1-Wn）

II, butt convert wet basis to

Si＝ (Gi)/(（1-Wi）·∑') （i＝1，2，…n）

${\mathrm{\&Sigma;}}^{\&prime;}=\frac{\mathrm{<figure-callout\; id="1"\; label="G"\; filenames="93103213X\_DRIMG1.png,93103213X\_DRIMG6.png"\; state="\{\{state\}\}">G</figure-callout>}1}{1-\mathrm{<figure-callout\; id="1"\; label="W"\; filenames="93103213X\_DRIMG1.png,93103213X\_DRIMG6.png"\; state="\{\{state\}\}">W</figure-callout>}1}+\frac{G2}{1-W2}+\&hellip;+\frac{\mathrm{GN}}{1-\mathrm{Wn}}=\underset{i=1}{\overset{\mathrm{<figure-callout\; id="1"\; label="n\; G"\; filenames="93103213X\_DRIMG1.png,93103213X\_DRIMG6.png"\; state="\{\{state\}\}">n</figure-callout>}}{\mathrm{\&Sigma;}}}\frac{G}{}\frac{1}{1-\mathrm{<figure-callout\; id="1"\; label="W"\; filenames="93103213X\_DRIMG1.png,93103213X\_DRIMG6.png"\; state="\{\{state\}\}">W</figure-callout>}1}$

3. flow, number percent convert

If flow is L1, L2 ... the Ln(kilogram/minute)

Unit-hour output G(ton/hour)

Number percent S1, S2 ... Sn(%)

I, known percentage calculated flow rate

Li＝G·Si·1000/60＝16.67G·Si（i＝1，2…n）

II, known mass flow calculate number percent

Si＝Li/∑（i＝1，2…n）

$\mathrm{\&Sigma;}=\mathrm{<figure-callout\; id="1"\; label="L"\; filenames="93103213X\_DRIMG1.png,93103213X\_DRIMG6.png"\; state="\{\{state\}\}">L</figure-callout>}1+L2+\&hellip;+\mathrm{Ln}=\underset{i=1}{\overset{n}{\mathrm{\&Sigma;}}}\mathrm{Li}$

4. statistical function

I, mean value

$X=\frac{{\mathrm{<figure-callout\; id="1"\; label="X"\; filenames="93103213X\_DRIMG1.png,93103213X\_DRIMG6.png"\; state="\{\{state\}\}">X</figure-callout>}}_1+X_2+\&hellip;+\mathrm{Xn}}{n}=\frac{\underset{i=1}{\overset{n}{\mathrm{\&Sigma;}}}\mathrm{Xi}}{n}$

II, median X

X1 X2 ... Xn order by size arranges, and when n was odd number, X was exactly the numerical value of middle, and when n was even number, X was exactly the mean values of middle two numbers

III, extreme difference R

R＝Xmax-Xmin

IV, standard deviation

S＝ (（X1-X）2+（X2-X）2+…+（Xn-X）2)/(n-1)

$=\frac{\underset{i=1}{\overset{n}{\mathrm{\&Sigma;}}}{(\mathrm{Xi}-X)}_2}{n-1}$

V, the coefficient of variation: Cr

Cr＝S/X

5. weighted mean value

Known X1, X2 ... Xn and their weighted value Y1, Y2 ... Yn

Weighted mean value=(X1Y1+X2Y2 ... + XnYn)/(Y1+Y2 ... + Yn)

3 implementation methods:

Assist and be calculated as laboratory one specific purpose tool, program is divided into five major parts, that is: chemical analysis, chemical composition and three ratio conversion; Butt number percent and the conversion of wet basis number percent; Flow and number percent conversion; Statistical function; Weighted mean value calculates, and programming flowchart is referring to Fig. 5.

The program circuit of chemical analysis chemical composition among realization Fig. 5 and three ratio conversion is seen Figure 11, the programming flowchart that butt number percent and wet basis number percent convert among realization Fig. 5 is seen Figure 12, the programming flowchart of flow and number percent conversion is seen Figure 13 among realization Fig. 5, the programming flowchart of statistical function is seen Figure 14 among realization Fig. 5, realizes that weighted mean value Program for Calculation flow graph is seen Figure 15 among Fig. 5.The program of Figure 11 has three functions: analyzed by the chemical composition chemistry; Calculate three ratio by chemical analysis chemistry component and by chemical analysis.The block diagram of Figure 12 can calculate wet basis number percent or go out butt number percent according to the wet basis percentage calculation of importing according to the butt number percent and the moisture content of input.The flow graph of Figure 13 can be calculated number percent according to the flowmeter of input, also can import number percent and unit-hour output calculates flow.The flow graph of Figure 14 can calculate arithmetic mean, median, extreme difference standard deviation and the coefficient of variation.

The file processing function

Can carry out the backup of data at any time, delete and pack into, can carry out initialization floppy disk.Data backup is deleted and the purpose of packing into all is to guarantee safety of data.If the basic configuration of being selected shop equipment in a year by the user is ordered in the initialization of backup diskette, can calculate the data that computing machine will be handled in a year like this is sizes.See Fig. 6.

Data backup among Fig. 6 just backups to the data in the hard disk in the floppy disk and removes process block Figure 16.

Data among Fig. 6 are packed into and just the backup in the floppy disk are installed onto hard disk.Flow chart is seen Figure 17.

Deleted data among Fig. 6.But be used for deletion data under the not enough situation of hard drive space.Flow chart is seen Figure 17.

Diskette initialization, the equipment and the condition of production in tame factory every year are all inequality, between each family the use of form also different, this function can be the use that the user provides equipment and lattice are arranged, with the size of estimating that this year will the deal with data amount.Flow chart is seen Figure 19.

Implement method and system of the present invention and former laboratory ladder of management relatively, from bringing up to a new height in essence; Successfully computing machine is incorporated into laboratory in cement works, has proposed laboratory data management model, and have versatility and applicability widely.Ladder of management is fundamentally improved.The work of cement labouratory personnel are freed from heavy data statistics work, improved work efficiency greatly, fully guaranteed the reliability and the accuracy of data statistics and recipe calculation.

It is easy to operate to implement method and system of the present invention.Adopt full character reminding and hierarchical menu structure, each the step operation that neutralizes of each process all has character reminding.Begin to learn and just go up machine study several hrs and can grasp basic operation.All maloperations are equipped with warning, the down normal operation of protection computing machine.

It is fast to implement method and system data processing speed of the present invention.The work that originally artificial calculating or statistics need be finished several days time, native system only need be operated several keys and in seconds finish.In addition, searching of form printed, backup, and functions such as calculating prescription are all tried to gain greatly and are increased work efficiency.

It is big to implement method and system information storage amount of the present invention.Producing 8.8 ten thousand per year with the previous standard of order, to ram the loose soil with a stone-roller after sowing the cement mill be example, can store its total data in 20 years, and this compares with the storage three annual data levels that present cement mill way to manage can reach, and is once tremendous progress.

Implement method and system of the present invention and can fundamentally can solve present cement production enterprise laboratory situation backward in management, realized the laboratory in cement works supervisory computerization, along with the raising of the efficiency of management, will bring certain economic benefits and social benefit to the cement mill.

Claims (6)

1, a kind of method of carrying out the laboratory in cement works management with computing machine is characterized in that the method includes the steps of:

The recipe calculation step;

Laboratory management of data tables step;

Auxiliary calculation procedure;

The file processing step.

2, method according to claim 1 is characterized in that described recipe calculation step includes:

Complete black meal recipe calculation step;

Semiblack meal recipe calculation step;

Common meal recipe calculation step;

The formulation management step;

The formulation management step;

Above-mentioned first three step all comprises being received in to be inserted data and export the step of filling a prescription on the prescription page or leaf in the parameter page or leaf, the packet of described parameter page or leaf input contains: have or not the material of certain material to form data in the indication prescription with the "Yes" "No"; The complete chemical analysis data that have material in the indication prescription of representing with the face proportion by subtraction; The data of indication fluorite, gypsum blending method and number percent; The hear rate data of the calorific value of coal, ash content A and grog and design three ratio data; When being arranged on the described prescription page or leaf, a plurality of prescription can select, and input service time, confirm also whether selection deposits;

Above-mentioned formulation management step comprises: used for 12 phases retrieved in computer according to the prescription of importing that is retrieved, as retrieve demonstration formulation parameter face and whole prescription page or leaf, and beat the step of filling a prescription.

3, method according to claim 1 is characterized in that described laboratory management process includes:

Data typing step;

The data modification step;

The data statistics step;

Data retrieval step, step;

The form printing step;

Above-mentioned each step all is that the table menu of consolidation form is carried out, and described table menu includes title, form operation flag, table content and presenting bank, and described form operation flag includes: typing, modification, statistics retrieval and printing; Described title has:

Cement mill raw material chemical analysis raw readings, cement mill proximate analysis of coal raw readings, starting material dries quantity controlling recording, cement slurry flow demand logging, raw material bistrique raw meal particle size record, raw material bistrique material moisture record, go out to grind raw material quality control record, go into kiln raw material quality control record, grog physical examination raw readings, grog stability check raw readings, grog is checked raw readings setting time, grog density, the specific area measuring raw readings, the beginning record is analysed in the selective examination of cement proportion flow, finished product bistrique raw meal particle size demand logging, go out to grind SO3 fineness controlling recording, go out to grind cement physical examination raw readings, go out to grind soundness of cement check raw readings, go out to grind cement setting time check raw readings, cement physical examination raw readings, soundness of cement check raw readings, the cement setting time that dispatches from the factory check raw readings, cement density specific area measuring raw readings, the cement uniformity testing that dispatches from the factory report, cement S03 dispatches from the factory, loss on ignition check raw readings, bag of cement is heavily spot-check raw readings, raw material Shop floor control statistical form, go into kiln raw material production control statistical form, kiln discharge manufacture of cement control statistical form, kiln discharge raw material chemical analysis machine account, go into kiln raw material chemical analysis machine account, kiln discharge grog physical examination machine account, kiln discharge grog chemical analysis machine account, the cement quality machine account dispatches from the factory, go out to grind the tired summary table of raw material quality, go into the tired summary table of kiln raw material quality, clinker quality tires out summary table, go out to grind the tired summary table of cement quality, the packing bag of cement heavily reaches the tired summary table of stability quality, the cement quality that dispatches from the factory tires out summary table, go out the cement quality statistical form, cement physical cell experiment condition raw readings, cement mill controlling index scope, cement mill raw mix formula design table.

4, method according to claim 1 is characterized in that described auxiliary calculation procedure includes; Chemical analysis, mineral composition and three rate calculation procedures:

Butt, wet basis conversion step;

Weight, number percent conversion step;

Calculation procedure such as mean value, standard deviation;

The weighted mean value calculation procedure.

5, method according to claim 1 is characterized in that described file processing step includes:

The data backup step;

The data step of packing into;

The deleted data step;

The disk initialization step.

6, a kind of department of computer science that is used for the laboratory in cement works management, form by industrial computer, display device, keyboard, printer UPS etc., it is characterized in that, install in this system and operation has and can carry out as the computer program of method as described in each in the claim 1 to 5.

Images