CN112950081A

CN112950081A - Outline calculation method and device

Info

Publication number: CN112950081A
Application number: CN202110366889.5A
Authority: CN
Inventors: 张今非
Original assignee: Individual
Current assignee: Individual
Priority date: 2021-04-06
Filing date: 2021-04-06
Publication date: 2021-06-11

Abstract

The invention relates to a method and a device for calculating an outline, which comprises the steps of obtaining a training outline file and inputting a calculation template; calculating the original data in the outline file through a boundary condition and an interpolation method to obtain a result data array of the original data; and carrying out statistical analysis on the result data array to obtain a statistical result. The invention can automatically process training data of soldiers, policemen and athletes in batches, automatically check outline, calculate scores in batches, automatically build files and form images in batches. The method and the system can be used for freely expanding the training outline and the calculation template, and realize the mixed checking calculation of all training courses of army, police and athletes. The system has the characteristics of open-loop design, high multiplexing, complete decoupling and the like, is batched, automatic and standardized, and is convenient for commanders and coaches to rapidly control unit training data.

Description

Outline calculation method and device

Technical Field

The invention belongs to the technical field of software, and particularly relates to a method and a device for calculating an outline.

Background

Some organizations can make a training outline during training so as to solve the problem of difficult evaluation and calculation in training. In the related technology, all levels of organs and troops of our army calculate the training achievement by compiling various macros, formulas, single-machine and networking programs, mobile phone applets and other modes. But the calculation result is not accurate and the problem that the format of the training assessment result table has different standards in different trips and even different links is caused by the problem that the program calculation has different standards.

In the prior art, batch processing of training data for an outline generally adopts an excel formula written by this unit to calculate data, or adopts a manual calculation mode or a query app. However, under the condition that a new outline appears, if the excel macro used before is used for filling in the calculation result, the calculation result is not standardized and is not accurate, the manual calculation operation is complex, the training data cannot be automatically processed, and the visualization is impossible.

Disclosure of Invention

In view of this, the present invention provides a method and an apparatus for calculating an outline, so as to solve the problems in the prior art that training data for the outline cannot be automatically processed and cannot be visualized.

In order to achieve the purpose, the invention adopts the following technical scheme: a method of computing for a schema, comprising:

acquiring a training outline file and inputting a calculation template;

calculating and processing the original data in the outline file through boundary conditions and an interpolation method to obtain a result data array of the original data;

and carrying out statistical analysis on the result data array to obtain a statistical result.

Further, the performing calculation processing on the original data in the outline file through boundary condition and interpolation calculation includes:

acquiring boundary condition data according to a boundary condition, and performing traversal search on the boundary condition data to obtain two adjacent boundary points in the boundary condition data;

and carrying out interpolation calculation on the two adjacent boundary points.

Further, the boundary conditions include: time class upper bound condition, time class lower bound condition, numerical class upper bound condition, numerical class lower bound condition, plateau transformation upper bound condition, plateau transformation lower bound condition, time format condition, and age calculation boundary condition;

the interpolation method comprises the following steps: linear interpolation, median interpolation, maximum interpolation, and minimum interpolation.

Furthermore, the score data array adopts a score system;

the score system comprises: percent preparation, secondary preparation, tertiary preparation and quintile preparation.

Further, the performing statistical analysis on the achievement data array to obtain a statistical result includes:

performing primary statistics on partial data of the score data array, and writing the statistical result into a Word file; the archives comprise personal registration, unit statistics, unit summarization and unit record;

performing advanced statistics on the residual data of the score data array, and drawing a statistical result into a training data graph; the training data map comprises a unit radar map, a personal radar map, a trend map, a scale map, a scatter map, a topological map and a bubble map.

Further, a multi-branch tree model is adopted to carry out tree type transformation on the score data array so as to carry out classified statistics, establish archives and score analysis.

Further, before obtaining the training outline and the calculation template, the method further includes:

selecting a corresponding engine type according to the Office type of the equipment;

if the Office type is Open Office or Yozo Office, selecting a Java engine;

and if the Office type is MS Office or WPS Office, selecting a VBA engine.

Further, the method also comprises the following steps:

storing original data in the outline file to a memory array; the interpolation is stored in the memory array.

Further, the formats adopted by the training outline file and the calculation template are excel tables;

the calculation template comprises a preset template and a self-defined template.

An embodiment of the present application provides a computing device for an outline, including:

the acquisition module is used for acquiring the training outline file and inputting the training outline file into a calculation template;

the processing module is used for calculating and processing the original data in the outline file through boundary conditions and an interpolation method to obtain a result data array of the original data;

and the statistical module is used for carrying out statistical analysis on the score data array and acquiring a statistical result.

By adopting the technical scheme, the invention can achieve the following beneficial effects:

the invention provides a method and a device for calculating an outline, which comprises the steps of obtaining a training outline file and recording the training outline file into a calculation template; calculating the original data in the outline file through a boundary condition and an interpolation method to obtain a result data array of the original data; and carrying out statistical analysis on the result data array to obtain a statistical result. The invention can automatically process training data of soldiers, policemen and athletes in batches, automatically check outline, calculate scores in batches, automatically build files and form images in batches. The method and the system can be used for freely expanding the training outline and the calculation template, and realize the mixed checking calculation of all training courses of army, police and athletes. Compared with the small programs, macros, formulas and the like used by soldiers, policemen and athletes for evaluating the physical performance and skill performance in the past, the method has the characteristics of open-loop design, high multiplexing, complete decoupling and the like, is batched, automatic and standardized, and is convenient for commanders and coaches to rapidly master unit training data.

Drawings

In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below, it is obvious that the drawings in the following description are only some embodiments of the present invention, and for those skilled in the art, other drawings can be obtained according to these drawings without any creative effort.

FIG. 1 is a schematic diagram of the steps of the method for schema computation of the present invention;

FIG. 2 is a schematic flow chart of a method for schema computation according to the present invention;

FIG. 3 is a diagram of a double ended queue model according to the present invention;

FIG. 4 is a schematic diagram of a scoring system according to the present invention;

FIG. 5 is a schematic diagram of a computing device for outline according to the present invention.

Detailed Description

In order to make the objects, technical solutions and advantages of the present invention more apparent, the technical solutions of the present invention will be described in detail below. It is to be understood that the described embodiments are merely exemplary of the invention, and not restrictive of the full scope of the invention. All other embodiments, which can be derived by a person skilled in the art from the examples given herein without making any creative effort, shall fall within the protection scope of the present invention.

A specific calculation method for the outline provided in the embodiment of the present application is described below with reference to the drawings.

As shown in fig. 1, the method for calculating an outline provided in the embodiment of the present application includes:

s101, acquiring a training outline file and inputting a calculation template;

after the system is started, the outline of the data to be acquired is acquired first, and the calculation template is recorded into the system. The outline can be a police training outline used by police officers, a military training outline, a national standard physical outline used by athletes or a training outline of officers. It can be understood that the calculation template in the present application is preset and recorded in the system, and the calculation template is suitable for all outlines. And calculating a template for reading and writing, reading and writing original data of the template into a memory array during system operation, and operating a whole set of algorithm taking a double-ended queue as a core in a memory.

S102, calculating and processing original data in the outline file through boundary conditions and an interpolation method to obtain a result data array of the original data;

because the training outline versions are complicated, contradictory and different in standard. The various people pass is 60 points or 55 points, the sum exceeds 100 points, the sum is less than 60 points, the sum is less than 55 points, the conversion and interpolation are performed by four-level five-division 5-point system 20 types such as two-level three-level five-division, and the like, the body type data is converted into percentage, and the five-division level is 50, 52, 530, 532 or 5432; the special level of individuals evaluates the weights of different courses, and how much the mixed performance of physical skills calculates the total score. Therefore, the method and the device utilize the boundary conditions and the interpolation method to carry out calculation processing normalization on the trained original data, and are beneficial to the checking calculation of new personnel and new courseware tables; the stability of the algorithm is moderate, and the algorithm occupies less memory compared with data methods such as a directed graph of a target structure. And determining a synopsis data column where the assessment result is located, and calibrating the data position where the achievement standard is located by the system by adopting a vernier method.

And S103, carrying out statistical analysis on the result data array to obtain a statistical result.

Further carrying out deep analysis on the array by a system background, extracting partial data for primary statistics to obtain individual and unit training results, summarizing the individual and unit training results, and automatically writing the data into word files in batches based on a calculation engine, wherein the files comprise individual registration, unit statistics, unit summarization, unit records and the like; the other part of data is used for advanced statistics, based on part of job classification and the like, 6 types of 12 training data graph analysis is carried out by utilizing a GD library and a system background special mapping algorithm: unit and individual radar maps, trend maps, scale maps, scatter maps, topological maps, and bubble maps.

The working principle of the calculation method for the outline is as follows: as shown in fig. 2, in the present application, a training outline file is first obtained and a calculation template is entered; calculating and processing the original data in the outline file by using a boundary condition and an interpolation method through outline original data and a calculation template to obtain a result data array of the original data; and carrying out statistical analysis on the result data array to obtain a statistical result, and realizing mixed checking and calculation of all training subjects of the military, the police and the athletes through the archives and the training data graphs. The system has the characteristics of open-loop design, high multiplexing, complete decoupling and the like, is batched, automatic and standardized, and is convenient for commanders and coaches to rapidly control unit training data.

In some embodiments, the performing a calculation process on the original data in the outline file through a boundary condition and interpolation calculation includes:

and carrying out interpolation calculation on the two adjacent boundary points.

Preferably, the boundary conditions include: time class upper bound condition, time class lower bound condition, numerical class upper bound condition, numerical class lower bound condition, plateau transformation upper bound condition, plateau transformation lower bound condition, time format condition, and age calculation boundary condition;

In the application, the boundary conditions of the training outline are divided into 6 types of 3 types, namely a time type upper boundary condition, a time type lower boundary condition, a numerical value type upper boundary condition, a numerical value type lower boundary condition, a plateau transformation upper boundary condition and a plateau transformation lower boundary condition, and in addition, 2 supplementary conditions of a time format and an age calculation boundary are also included. All the conditions are lack of east and west in the training outline of each edition of our army, and are disordered from physical strength class to military category class. Interfaces are reserved in the outline computing system for the problems, so that officers and soldier users can write and modify boundary data at will and control computing conditions.

As shown in fig. 3, the interpolation algorithm adopted in the present application is a double-ended queue model algorithm, and the calculation of double-ended queues is to remove the clamping force from both ends, and if the clamping force is not obtained, the interpolation is taken. When the cursor walks to a row, the data of the row is loaded into a queue, and the empty loop is eliminated for further processing. Compared with other methods such as arrays, linked lists and the like, the most obvious advantage of the queue in the field of outline calculation is flexible checking of data backlash, and random positions are cleared at any time. The pointer at the head of the team and the pointer at the tail of the team move inwards at the same time, so that the calculation speed and the calculation precision are ensured. During calculation of plateau subjects, altitude interpolation conversion is needed when data dequeues, namely plateau drift.

Preferably, as shown in fig. 4, the score data array adopts a score system;

The system has 5 parts of score system, percentage system, two-level system, three-level system, four-level system and five-level system, all the parts are generalized to all the lessons, and an algorithm is designed to realize free conversion. Basic principle of conversion: equal proportion, linearization and accurate hundred differentiation. The percentage system achievement is a basic standard and a conversion base number of a segmentation system and is also a calculation base number of the graph analysis. The equal proportion and linearization mean that the relative relation between the training result and the training result is not changed between different groups of training data after conversion; the accurate percentile is that when other score systems except the percentile system are mutually converted, the score systems are firstly converted into accurate percentile scores and then converted into target score systems, and the accuracy is the most accurate.

It is understood that the present application makes a classification of the personnel categories, and the personnel categories are mainly classified into 4 categories and 8 categories: the first class, the second class, the third class and the non-third class are respectively calculated according to 8 kinds of people which are distinguished by men and women and are organized into special courses separately. Training subjects are uniformly divided into 5 types: general, special, engaged, common and professional lessons. Only the difference of the outline data exists between different courses, and the interpolation calculation process is equivalent.

In some embodiments, the performing statistical analysis on the achievement data array to obtain a statistical result includes:

Preferably, a multi-branch tree model is adopted to carry out tree type transformation on the achievement data array so as to carry out classified statistics, establish archives and achieve analysis.

Specifically, the multi-branch tree is a data structure convenient for classification and combination, and is suitable for classification processing of outline calculation result scores. From calculation to category statistics, archive establishment, and mapping analysis, tree transformation of the calculated performance metadata array is required. For example, when the division of the division statistical part is adopted, different boxes are respectively entered according to the combination principle: the ' 1 link, 1 row and 1 shift ' calculation result is divided into 3 parts of ' 1 link, ' 1 row ' and ' 1 shift ', the result belongs to 3 relational units at the same time, and simultaneously enters a ' link ', ' row ' and ' shift ' counting box, and a counter is added with one.

In some embodiments, before obtaining the training outline and the computation template, the method further includes:

if the Office type is Open Office or Yozo Office, selecting a Java engine;

and if the Office type is MS Office or WPS Office, selecting a VBA engine.

The method realizes the automation of the whole military training Office under the joint cooperation of the WPS Office engine, the MS Office engine and the thunder engine, calculates and counts the file-building image, and has no soft Office or soft execution.

Preferably, the method further comprises the following steps:

Preferably, the formats adopted by the training outline file and the calculation template are excel tables;

The self-defined template is a template which can be designed according to actual needs.

As shown in fig. 5, the present application provides a computing device for an outline, comprising:

an obtaining module 501, configured to obtain a training outline file and enter a calculation template;

the processing module 502 is configured to perform calculation processing on the original data in the outline file through a boundary condition and an interpolation method to obtain a result data array of the original data;

and the statistical module 503 is configured to perform statistical analysis on the achievement data array to obtain a statistical result.

The working principle of the computing device for the outline provided by the application is that the obtaining module 501 obtains a training outline file and inputs a computing template; the processing module 502 performs calculation processing on the original data in the outline file through boundary conditions and an interpolation method to obtain a result data array of the original data; the statistics module 503 performs statistical analysis on the score data array to obtain a statistical result.

The embodiment of the application provides computer equipment, which comprises a processor and a memory connected with the processor;

the memory is used for storing a computer program used for executing the calculation method for the outline provided by any one of the above embodiments;

the processor is used to call and execute the computer program in the memory.

In summary, the present invention provides a method and an apparatus for calculating an outline, including obtaining a training outline file, and inputting a calculation template; calculating and processing the original data in the outline file through boundary conditions and an interpolation method to obtain a result data array of the original data; and carrying out statistical analysis on the score data array to obtain a statistical result. The invention can automatically process training data of soldiers, policemen and athletes in batches, automatically check outline, calculate scores in batches, automatically build archives and form images in batches. The method can arbitrarily expand the training outline and the calculation template, and realize the mixed checking calculation of all training courses of the army, the police and the athletes. Compared with the small programs, macros, formulas and the like used by soldiers, policemen and athletes for evaluating the physical performance and skill performance in the past, the method has the characteristics of open-loop design, high multiplexing, complete decoupling and the like, is batched, automatic and standardized, and is convenient for commanders and coaches to rapidly master unit training data.

It is to be understood that the embodiments of the method provided above correspond to the embodiments of the apparatus described above, and the corresponding specific contents may be referred to each other, which is not described herein again.

As will be appreciated by one skilled in the art, embodiments of the present application may be provided as a method, system, or computer program product. Accordingly, the present application may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, the present application may take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, optical storage, and the like) having computer-usable program code embodied therein.

The present application has been described with reference to flowchart illustrations and/or block diagrams of methods, apparatus (systems), and computer program products according to embodiments of the application. It will be understood that each flow and/or block of the flow diagrams and/or block diagrams, and combinations of flows and/or blocks in the flow diagrams and/or block diagrams, can be implemented by computer program instructions. These computer program instructions may be provided to a processor of a general purpose computer, special purpose computer, embedded processor, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, create means for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.

These computer program instructions may also be stored in a computer-readable memory that can direct a computer or other programmable data processing apparatus to function in a particular manner, such that the instructions stored in the computer-readable memory produce an article of manufacture including instruction means which implement the function specified in the flowchart flow or flows and/or block diagram block or blocks.

These computer program instructions may also be loaded onto a computer or other programmable data processing apparatus to cause a series of operational steps to be performed on the computer or other programmable apparatus to produce a computer implemented process such that the instructions which execute on the computer or other programmable apparatus provide steps for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.

The above description is only for the specific embodiment of the present invention, but the scope of the present invention is not limited thereto, and any person skilled in the art can easily conceive of the changes or substitutions within the technical scope of the present invention, and all the changes or substitutions should be covered within the scope of the present invention. Therefore, the protection scope of the present invention shall be subject to the protection scope of the appended claims.

Claims

1. A method for calculating an outline, comprising:

acquiring a training outline file and inputting a calculation template;

calculating the original data in the outline file through a boundary condition and an interpolation method to obtain a result data array of the original data;

2. The method according to claim 1, wherein the performing of the calculation processing on the raw data in the outline file through the boundary condition and interpolation calculation comprises:

and carrying out interpolation calculation on the two adjacent boundary points.

3. The method of claim 2,

the boundary conditions include: time class upper bound condition, time class lower bound condition, numerical class upper bound condition, numerical class lower bound condition, plateau transformation upper bound condition, plateau transformation lower bound condition, time format condition, and age calculation boundary condition;

4. The method of claim 1, wherein the performance data array employs a score system;

5. The method of claim 1, wherein the performing a statistical analysis on the array of performance data to obtain a statistical result comprises:

performing primary statistics on partial data of the score data array, and writing the statistical result into a Word file; the file comprises individual registration, unit statistics, unit summarization and unit records;

6. The method of claim 5,

and performing tree type transformation on the score data array by adopting a multi-branch tree model to perform classified statistics, establish files and perform score analysis.

7. The method of claim 1, prior to obtaining the training outline and the computation template, further comprising:

if the Office type is Open Office or Yozo Office, selecting a Java engine;

and if the Office type is MS Office or WPS Office, selecting a VBA engine.

8. The method of claim 7, further comprising:

9. The method of claim 1,

the formats adopted by the training outline file and the calculation template are excel tables;

10. A computing device for a schema, comprising: