KR101066409B1 - Apparatus for operating quantity and price sheet, method for operating quantity and price using the same - Google Patents

Abstract

The present invention allows a user to easily modify a work sheet and store the work sheet as one object, so that when the work sheet is loaded, calculation processing is performed on the input data according to the format contents included in the work sheet. An apparatus and a product calculation method using the same are provided.

The article sheet calculating device includes a product sheet storage unit which stores the product sheets in one object unit, and a product sheet processing unit which processes input data according to the format contents created in the product sheet; And a data output unit for outputting the result data processed through the production sheet according to the contents defined in the regular form contents or the file operating in conjunction with the production sheet, wherein the production sheet is configured in units of cells. The processor recognizes the contents defined in each cell and performs arithmetic processing on the input data.

Product, spreadsheet, quantity, unit price

Description

Apparatus for operating quantity and price sheet, method for operating quantity and price using the same}

The present invention relates to an apparatus for calculating a sheet and a method of calculating a product using the same, wherein the user easily modifies the sheet and stores the sheet as one object, according to the format contents included in the sheet when the sheet is loaded. A product sheet calculating device for performing arithmetic processing on input data.

In general, the construction site person purchases the materials necessary for the construction process by referring to the drawings, specifications, and construction plans by hand, and then purchases the purchase request to the headquarters purchasing team or the material company, receives the quotation, You will enter into a purchase agreement with a suitable material supplier, pay for the material after it has been delivered.

In other words, the construction site manager extracts the information on the materials needed for construction with the design, specification, and construction plan, prepares the purchase plan, and then makes a purchase request to the headquarters purchasing team online or offline to the material company. . When the construction site manager makes a purchase request online, the headquarters purchasing team sends a purchase notice to the construction e-market place, and when a purchase request is made offline, the purchase notice is sent directly to the material company. . Our procurement team receives the quotation online or offline from the material supplier, enters into a purchase contract with the appropriate supplier based on the received quotation, supplies the material to the construction site, and pays the material supplier. In the case of making a purchase request offline at the construction site, the construction site manager receives a quotation from a material company, enters into a purchase contract with a suitable material company, supplies the material, and then pays the material price to the material company.

Conventionally, in order to prepare a design (or quotation) about the quantity, unit price, material cost, labor cost, expenses, etc. of materials required for construction in various construction fields such as architecture, communication, electricity, etc. When the values are entered, the data input from the program is processed and the result value is calculated.

However, if the standard of the construction equipment changes, or the number of items required for the design increases or decreases, the professional software producer or programmer, not the general user, had to modify the program source code or adjust the database structure. There is a problem that the maintenance cost increases.

Therefore, there is a need to solve these problems so that the general user can easily create a design.

The present invention allows a user to easily modify the format contents of a production sheet and store the production sheet as one object, so that a calculation process is performed on the input data reflecting the changes of the format contents when the production sheet is loaded. An object of the present invention is to provide a computing device and a method for calculating a product using the same.

In addition, the present invention, while the expert had to change the program source and database in order to carry out operations such as adding, modifying, and deleting items in accordance with the change of construction standards and other requirements, the general public can easily change the format of the sheet. An object of the present invention is to provide a product sheet calculating device and a product calculating method using the same, which enable the addition of items, the change of contents, and the like.

In addition, the present invention outputs the result data in at least one of a file, a picture, a graph, and a chart according to the definition of the output form included in the format sheet of the sheet or the output form defined in the file operating in conjunction with the sheet. Or to output a result data at a specified cell position of the sheet or another sheet configured on a cell basis to diversify the output form of the input data. The purpose is.

In addition, in the present invention, when using a product sheet of a predetermined item stored in a storage location shared by a plurality of users over a network, the calculation process is performed according to the format contents written in the shared product sheet for data input by each user. In order to provide a product sheet calculating device and a method for calculating a product using the same, the result data of the same form can be obtained according to the definition sheet of the product sheet and the work efficiency can be increased by reducing the cost increase such as duplicated formatting. Has its purpose.

In order to achieve the above object, the production sheet calculation apparatus according to an embodiment of the present invention is a production sheet storage unit for storing the production sheet in one object unit, and the processing sheet for processing the input data according to the format content created on the production sheet Processing unit; And a data output unit for outputting the result data processed through the production sheet according to the contents defined in the regular form contents or the file operating in conjunction with the production sheet, wherein the production sheet is configured in units of cells. The processor recognizes the contents defined in each cell and performs arithmetic processing on the input data.

The assembly sheet processor may recognize a changed format content of the assembly sheet when loading the assembly sheet, and perform a function operation according to the contents defined in each cell of the assembly sheet.

In addition, the product sheet includes a variable definition and a product formula for calculating a product for quantity and unit cost related to labor cost, material cost, and expense in construction, communication, and electrical processes. It is done.

The result data may be output in at least one of a file, a picture, a graph, and a chart according to a definition of an output form included in a format content of the sheet or an output form defined in a file operating in conjunction with the sheet. Or at a specified cell position of another sheet configured on a cell basis.

In addition, the fabric sheet is shared on a network, it is characterized in that the distribution, management or reuse is possible.

According to an embodiment of the present invention, a method for calculating a product includes a step (a) in which a product sheet storage unit stores a product sheet including formatting contents in one object unit, and the product sheet processing unit loads the production sheet and forms the content of the production sheet. (B) calculating the result data by calculating the input data according to the calculation; And (c) outputting the result data according to the definition of the output form included in the format content of the production sheet or the output form defined in the file operating in association with the production sheet.

In addition, the step (b) further comprises the step of processing the result data in accordance with the formula operation formula defined in the form by matching the parameter value of the input data and the variables included in the form with the product sheet processing unit It is characterized by including.

According to the product sheet calculating apparatus and the product calculating method using the same according to the present invention, the following effects are obtained.

First, the user can easily modify the format contents of the production sheet and store the production sheet as one object, so that the processing of the input data reflecting the changed contents of the format contents is performed when the production sheet is loaded.

Second, while the experts had to change the program source and database to perform tasks such as adding, modifying, and deleting items in accordance with changes in construction standards and other requirements, the general public could easily add items by changing the format of the product sheet. It also has the advantage of being able to change contents.

Third, output the result data in at least one of file, picture, graph, and chart form according to the definition of the output form included in the format sheet of the sheet or the output form defined in the file operating in conjunction with the sheet. It is also advantageous to diversify the output form of the input data by outputting the result data at a specified cell position of the production sheet or another sheet configured in units of cells.

Fourth, when using a product sheet of a predetermined item stored in a shared storage place by a plurality of users over a network, the operation sheet is processed according to the format contents written in the shared product sheet for the data input by each user. According to the definition, the result data of the same type can be obtained, and the work efficiency can be improved by reducing the cost increase such as duplicated form filling.

Advantages and features of the present invention, and methods for achieving them will be apparent with reference to the embodiments described below in detail in conjunction with the accompanying drawings. However, the present invention is not limited to the embodiments disclosed below, but may be implemented in various forms, and only the embodiments of the present invention make the disclosure of the present invention complete and the general knowledge in the technical field to which the present invention belongs. It is provided to fully convey the scope of the invention to those skilled in the art, and the invention is only defined by the scope of the claims. Like reference numerals refer to like elements throughout.

1 is a block diagram of an assembly sheet calculating apparatus according to an exemplary embodiment.

Hereinafter, a process for calculating a process and a unit price according to the construction of a manhole in a communication facility expansion construction will be described as an example. However, the present invention is not limited thereto, and according to an embodiment of the present invention for the production of various construction fields such as construction, civil engineering, and electricity, The product sheet calculating apparatus 100 and a product operation using the same may be performed. In addition, the principle of the present invention can be applied not only in the construction field but also in various industrial fields.

The production sheet computing device 100 includes a production sheet storage unit 110, a production sheet processing unit 120, and a data output unit 130.

The product sheet storage unit 110 stores the product sheet 200 for converting the data input by the user into the standardized data into one object unit, and the product sheet 200 includes a product calculation formula, a variable definition, And a spreadsheet including a form content such as application conditions. For example, the production sheet 200 may include a form content necessary to calculate a product for a quantity and a unit price related to labor costs, material costs, and expenses in the construction, communication, and electrical processes. For reference, product is a general term that refers to how much all the products, such as labor costs, material costs, expenses, etc., are required for a certain process.

The meaning of storing the assembly sheet 200 as one object includes storing the assembly sheet 200 itself as a file in a database. The spreadsheet form includes a form in which the production sheet 200 is configured in units of cells and data recognition and arithmetic processing are performed in units of cells.

That is, since the structural unit of the production sheet 200 is a cell unit, it is preferable that a user inputs data in cell units when defining or inputting predetermined data in the form, and the format of the production sheet 200 is fixed for each item. Since the data is pre-created and stored in cell units according to the format, when the user inputs data according to the format format of the production sheet 200, the production sheet processing unit 120 to be described later recognizes and processes the data.

In addition, since the sheet 200 is stored in the sheet storage unit 110 as a sheet itself as a unit, the user adds the contents required by the sheet to the sheet and simply clicks the save button. It may be stored in the production sheet storage unit 110 in one file unit.

Thus, for example, in order to add safety-related items due to the change in the construction method and to add equipment-related items, a professional programmer must modify the program or manipulate the database. Even if a general user does not have professional knowledge, the desired result can be obtained by defining items and contents required in each production sheet 200 according to a format form, as in writing a document.

Therefore, if the format format is initially created and stored, the user can later add or change content according to the format format to obtain the desired result data.

In addition, the fabric sheet storage unit 110 may store the fabric sheet 200, a (library) file operating in association with the fabric sheet, and other sheets in which a predetermined form is input. The library file may include a definition of the data output form to output the result data processed through the production sheet 200 in various forms, for example, a schedule form (or cell) of the production sheet 200 or another sheet. It may include a definition for outputting the result data at the position of. Therefore, the result data processed in the production sheet 200 may be provided to the user in various output forms according to the form defined in the library file.

In addition, the product sheet storage unit 110 stores a process list (eg, temporary construction, pavement cutting, break packaging, etc.) and detailed items included therein for calculating a unit price, and also includes a product sheet 200 to correspond to each item. Can be stored.

In addition, the product sheet storage unit 110 is a standard material cost, labor costs, expenses, standard specifications, construction drawings, drawing figures, quantity, process information, material information, material company information per item (per unit, time, region, etc.) For example, construction-related information and various information for preparing a design document can be stored in a logical or physical storage area. More specific forms and preparation examples of the fabrication sheet 200 will be described in detail later with reference to FIG. 2.

The production sheet processing unit 120 loads the production sheet 200 and performs data processing on the input data according to the format contents created in the production sheet 200. Here, the sheet 200 may be loaded in the form of a file, and the sheet sheet processing unit 120 may perform a function operation according to the contents defined in each cell of the sheet 200 to calculate the result data of the input data. can do.

In addition, if there is a library file operating in cooperation with the production sheet 200, the production sheet processor 120 may read a definition included in the library file and output the result data in a predetermined form according to the defined content. .

The data output unit 130 outputs data stored in the production sheet storage unit 110 in a predetermined form under the control of the production sheet processing unit 120. That is, the data output unit 130 generates the result data in the form of a file according to the format content recognized by the production sheet processing unit 120, displays the data at a specified cell position of another sheet, or displays a statistical drawing, a figure, a graph, a chart, or the like. It can be output in the form of.

Here, when the sheet to which the result data is to be output and the output position are previously defined in the production sheet 200 or the library file, the data output unit 130 may output the result data to a predetermined portion of the sheet according to the defined contents. have.

The assembly sheet 200 described above may be shared and distributed, managed, or reused on a network, and each component of the assembly sheet computing device 100 may be manufactured and distributed by a chip or software.

For example, when a plurality of users use the production sheet 200 of a predetermined item stored in a shared storage location on a network, calculation processing is performed according to the form contents written in the shared production sheet 200 for data input by each user. Since the result data of the same form can be obtained according to the definition content of the production sheet 200, the work efficiency can be increased by reducing the cost increase such as duplicated form creation. At this time, the authority to change the content of the form sheet 200 may be set according to the user.

2 illustrates a fabrication sheet according to an embodiment of the present invention.

For example, as the demand for telecommunications is expected to increase due to the formation of large residential areas, the construction of telecommunication facilities will be expanded, and manholes will be established for smooth telecommunication maintenance. At this time, the design document including the quantity and unit price according to the process to be carried out when the manhole is established is to be prepared.

As shown in FIG. 2, the process list 202 (temporary construction, pavement cutting, breaking pavement, etc.) for calculating the unit price includes corresponding sub-items 204, and one of them is selected. The item sheet 200 of the item is output on the screen.

For example, when a user selects an item for heavy dumping in order to prepare a form for calculating the heavy dumping price based on the construction standard product in the production sheet 200 for formatting data, the production sheet corresponding to the heavy dumping item ( 200) is output.

Then, when the user creates and stores the required form contents in the production sheet 200, the production sheet 200 is stored in the database as a unit file itself, including the form, and then the processing sheet 200 processing unit ( 120 may load the product sheet 200 to recognize a format included in the sheet, and perform an operation process on input data according to the format content.

In the form of the product sheet 200, for example, a formula, a variable definition, an application condition, and various reference contents may be defined. If necessary, the user may include formulas, variables, variable values, and result data. You can add, delete, or modify the contents such as the output form, location, and application conditions.

At this time, since the structural unit of the assembly sheet 200 is a cell unit, a function calculation and data recognition are performed on a cell basis. For example, since the basic format of the production sheet 200 is defined in units of cells according to the item, the user may add additional cells by adding cells according to the format, or modify the data in the existing created format to format the format. The contents can be changed or deleted, and when the process sheet 200 loads the process sheet 200, the process sheet 120 recognizes the format contents including data modified by the user and according to the input data according to the format contents. Will yield the data. In this case, the parameter value of the input data and the variable defined in the format content correspond to each other and are substituted into a function (or product) expression defined in each cell, thereby performing arithmetic processing.

Thus, the sheet 200 is composed of a plurality of cells by using the principle of the spreadsheet can be a function operation in the unit of cells, the sheet sheet 200 itself is stored and the formatting content in the sheet sheet 200 Recognition can be made and calculation and various data output forms can be formed, so that the user can easily perform data operations without expert knowledge.

On the other hand, the result data calculated through the format of the production sheet 200 may be displayed on a specific portion 220 of the production sheet 200, stored in a file, or displayed on a specific form of another sheet. Can be. See FIGS. 4 and 5 as an example of the output form of the result data.

These various output forms may vary depending on the content defined in the form in the assembly sheet 200, or the output forms may be defined in a library file that operates in conjunction with the assembly sheet 200.

That is, if a form for outputting the result data is defined in a library file operating in conjunction with the production sheet 200, the result data is generated as a file, displayed in a predetermined cell in another sheet, or a statistical drawing is defined according to the defined contents. Can be output in the form of a picture file.

In this way, the conventional programmer can solve the difficulty of modifying the source to add data, and the general user can easily add the necessary data to obtain the result value.

Hereinafter, a process of creating an actual design document using the above-described fabrication sheet 200 will be described in detail.

3 is a screen showing an example of basic data input to a production sheet, and FIGS. 4 and 5 show examples of various forms of result data output according to a production sheet format.

Based on the contents of FIG. 2 described above, various data output forms output based on the basic data (that is, input data) and the format contents of the production sheet 200 will be described.

When establishing a manhole as an example in FIG. 2, first, when a CAD drawing is created for a manhole standard to be installed and a work environment and ancillary processes required for manhole construction, the created drawings are stored in a program and protocol data form. Subsequently, drawing numerical data may be extracted according to a condition set from a CAD drawing file created in 2D or 3D and output on a screen as shown in FIG. 3. Such a task may be performed by a predetermined processor of a product server in which a product sheet calculating device 100 is stored, and a method of extracting data from a CAD drawing may be cited in the patent application No. 10-2008-0112498 and various conventional techniques. Can be used.

As shown in FIG. 3, the screen of the product server includes a first area 302 representing process information created in a CAD drawing, a second area 304 displaying a process of soil accumulation process required to perform a process, The third region 306 for modifying the working conditions of the process, for displaying the calculation of soil loads, the cross-sectional view of the manhole, or for viewing the calculation formulas on which the soil calculation is based; 308), a user may input basic data for making a design document through the provided screen, and the input data is subsequently processed according to the format created in the manufacturing sheet 200 of FIG. 2.

For reference, based on the data displayed in the first area 302, the user additionally inputs data such as soil quality, soil height, width, slope, work classification (manpower or medium term), backfill soil, etc. required for manhole facility construction. Then, the result value to which the data is applied to the fourth region 308 is displayed in a predetermined form.

Thereafter, when the user selects an item and loads the product sheet 200 corresponding to the item in order to create a design document including a quantity and a unit price according to a process to be performed when a manhole is formed, as described in FIG. 2, FIG. 3. The data values input from are calculated according to the definition of the format included in the product sheet 200 and calculated as result data.

Here, a function operation may be performed by matching the parameter value of the input data with the variable defined in the format content and assigning it to a function defined in each cell.

That is, each data of FIG. 3 is substituted to correspond to a variable value defined in the assembly sheet 200, and is processed. At this time, application conditions and various reference contents are recognized and created as a final design document.

If there is a library file linked with the assembly sheet 200, the output form of the result data and various other additional processes may be performed according to the contents defined in the library file.

For example, when the library file includes a sheet file name for outputting the result data and position information for outputting the result data in the sheet, the result data processed through the production sheet 200 is a predetermined position of the sheet defined in the library file. Can be output to

That is, when the sheet defined in the library file is created in a predetermined form as shown in FIG. 4 and the result data is to be output to the (x, y) cells in the sheet, the file in the library file or the production sheet 200 You can specify in advance the position of the cell in which the result data will be output in the form. Therefore, the user can easily output the result data in the designated position of the desired form, thereby increasing the work efficiency.

If a predetermined item is added to the sheet to further calculate the quantity and unit price according to the corresponding item, the user first adds the item from the sheet and outputs the quantity and unit price (result data) according to the item (x1). , and add and store y1), and similarly, open the product sheet 200 to further define variables and expressions for calculating the product according to the item addition, and define the position where the result data according to the item is displayed.

In this case, a position where the result data is to be displayed may be defined in a library file corresponding to the assembly sheet 200. Then, when the product sheet 200 is loaded, the result data according to the item added by the user including the existing data is calculated, and the result corresponds to the quantity of the sheet to which the item is added and the cell position (x1, y1) of the unit price item. The data is output.

In addition, as shown in FIG. 5, a comprehensive design book according to each process list may be generated and output on the screen through linkage with data values stored in the sheet storage unit 110. That is, the process and the unit, quantity, material costs, labor costs, expenses, and the like can be collectively processed and output as result data through each fabric sheet 200. It reduces the cost of drafting design in the construction field, and makes it easy for general users to perform various data modification tasks such as adding and deleting items.

And, even if you are not a program expert through the above-described production sheet 200, if a general user opens the production sheet 200 and simply adds the necessary items, the added content is applied when the corresponding production sheet 200 is loaded. Therefore, since the data input by the user is calculated as a standardized result, even if the construction equipment standard is changed, the operation of the items or data according to it is simple, and thus it can contribute to economic efficiency, convenience, and popularity. .

In particular, it solves the difficulty of calculating the unit cost of materials that need to be installed in pipelines such as water supply and sewage, communication, etc., and solves the inconvenience and difficulty of making complicated calculation formulas from spreadsheets such as Excel, which are generally used. You can do it.

In addition, by sharing the production sheet 200 and the library source accordingly created between users to increase the efficiency of the work.

6 is a flowchart illustrating a product calculation method using a product sheet calculation device according to an exemplary embodiment.

First, the production sheet storage unit 110 stores the production sheet 200 including the form contents in one object unit (S601).

Next, the production sheet processing unit 120 loads the production sheet 200 and processes the input data according to the format contents of the production sheet 200 (S611). That is, the production sheet processing unit 120 loads and reads the production sheet 200 into the memory, and at this time, recognizes the contents of the format defined in the production sheet 200 on a cell-by-cell basis, and defines a variable defined in the format, a product (or function). ) The input data is processed according to an expression and an application condition to calculate the result data of the data conversion. In this case, the product sheet processor 120 may perform data conversion and arithmetic processing according to a product formula defined in the format by matching the parameter values of the input data with the variables included in the format.

Next, the production sheet processing unit 120 outputs the result data according to the definition of the output form included in the form contents of the production sheet 200 or the output form defined in the file operating in conjunction with the production sheet 200 ( S621). For example, the output data may be output in at least one of a file, a picture, a graph, and a chart, or the result data may be output at a specified cell position of the production sheet 200 or another sheet configured in units of cells.

For details of the above-described steps S601, S611, and S621, refer to the description of FIGS. 1 to 5.

The assembly sheet storage unit 110 illustrated in FIG. 1 includes a cache, a read only memory (ROM), a programmable ROM (PROM), an erasable programmable ROM (EPROM), an electrically erasable programmable ROM (EEPROM), and a flash memory. It may be implemented as at least one of a nonvolatile memory device or a volatile memory device such as a random access memory (RAM), or a storage medium such as a hard disk drive (HDD) or a CD-ROM.

In addition, each component of FIG. 1 may be configured as a kind of 'module'. The 'module' refers to a hardware component such as software or a field programmable gate array (FPGA) or an application specific integrated circuit (ASIC), and the module plays a role. However, modules are not meant to be limited to software or hardware. A module may be configured to reside on an addressable storage medium and may be configured to execute one or more processors. The functionality provided by the components and modules may be combined into a smaller number of components and modules or further separated into additional components and modules.

And while the embodiments of the present invention have been described above with reference to the accompanying drawings, those skilled in the art to which the present invention pertains may be embodied in other specific forms without changing the technical spirit or essential features of the present invention. I can understand that you can. Therefore, it should be understood that the embodiments described above are exemplary in all respects and not restrictive.

1 is a block diagram of an apparatus for calculating a sheet according to an embodiment of the present invention.

2 is a fabrication sheet according to an embodiment of the present invention.

FIG. 3 is a screen showing an example of basic data input to the production sheet of FIG. 2; FIG.

4 and 5 are examples of various forms of result data output according to a product sheet format.

6 is a flowchart of a product calculation method using the product sheet calculation device of FIG. 1, according to an exemplary embodiment.

<Explanation of symbols on main parts of the drawings>

110: product sheet storage unit

120: product sheet processing unit

130: data output unit

200: sheet

Claims (7)

A production sheet storage unit which stores a production sheet configured in a cell unit as one object unit; Process the input data according to the format contents written on the sheet by loading the sheet, but recognize the changed format contents of the sheet when loading the sheet and perform a function operation according to the contents defined in each cell of the sheet. A product sheet processing unit to perform; And a data output unit configured to output the result data processed through the product sheet according to the format content or the content defined in a file operating in association with the product sheet. The result data may be output in at least one of a file, a picture, a graph, and a chart according to a definition of an output form included in the form contents of the sheet or an output form defined in a file operating in conjunction with the sheet. A production sheet computing device, outputted at a specified cell position of the production sheet or another sheet configured on a cell basis. delete The method of claim 1, The product sheet includes variable definitions and product formulas required to calculate products for quantities and unit costs related to labor, materials, and expenses required in construction, communications, and electrical processes. , Sheet cutting unit. delete The method of claim 1, The manufacturing sheet is a sheet manufacturing apparatus, characterized in that shared over the network can be distributed, managed or reused. A product calculation method using the production sheet calculation device according to any one of claims 1, 3, and 5, (A) storing, by the object sheet storage unit, the compound sheet including the contents of content as a single object unit; (B) loading, by the production sheet processor, the calculation sheet and calculating input data according to a format content of the production sheet to calculate result data; And An output in which the data output unit outputs the result data processed through the sample sheet according to the contents defined in the form contents or a file operated in association with the results sheet, wherein the result data is included in the contents contents of the results sheet. Output in at least one of file, picture, graph, and chart form according to a definition of a form or an output form defined in a file operating in conjunction with the production sheet, or the result data is configured in the production sheet or cell unit And (c) outputting to the designated cell position of the sheet. The method of claim 6, The step (b) further includes the step of processing the result data in accordance with the calculation formula defined in the format by the product sheet processing unit corresponding to the parameter value of the input data and the variable included in the format; A product calculation method, characterized in that.

Images