JP2003288371A - Data management system - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To make automatically formable a spreadsheet for individual information without using another spreadsheet soft only by plotting individual information consisting of an identification mark for a setting matter on a drawing by use of CAD software or the like. <P>SOLUTION: An individual layer 2 for plotting individual information Pn and tabulation layers 5A-5D in which spreadsheets 4A-4D having cells with a tabulation processing calculation expression for the individual information Pn set therein are recorded, are formed within one file 7, so that the tabulation data of individual information can be displayed on a spreadsheet only by plotting the individual information to be tabulated. <P>COPYRIGHT: (C)2004,JPO

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a data management system for tabulating the quantity and amount of individual information plotted on a layer and displaying the tabulated data.
In particular, it is suitable for use when managing the installation location, quantity, amount, etc. of indoor and outdoor installations of buildings and ground installations such as road signs and guide signs.

[0002]

2. Description of the Related Art For example, in a high-rise building, there is an emergency installation such as a fire alarm, a heat-sensitive fire sensor, a harmful gas sensor, a guide light, an emergency exit guide plate, a fire extinguisher, smoke prevention equipment, and evacuation equipment on each floor. It is provided.

[0003] In this case, at the design stage, the installation work is performed by writing which installations are to be installed in which location on the floor plan of each floor, and performing the layout design, and calculating the cost by calculating the number by type and calculating the amount of money. Need to do.

Further, at the time of construction, the installation work is carried out while confirming which type of installation product should be arranged and where, after the installation work, the installation confirmation work of whether each installation product is definitely installed in a required place. In addition, when performing maintenance for specific equipment such as replacement work due to the expiration of the useful life, total the number of installation objects to be replaced, and check the installation location of each installation It is necessary to perform maintenance work at the installation location of.

The layout design of the installations is performed by plotting an ID code or a specific mark representing the installations on the floor plan of each floor using CAD software, and the number of installations is totalized based on this data. In this case, a spreadsheet containing the type and number of installations on each floor is created with spreadsheet software such as Excel (a product name of Microsoft Corporation).

In addition, in the installation work, installation confirmation work, and maintenance work, it is general to print out a plan view of each floor in which the installation position of the installation object is plotted, and perform the confirmation work while looking at it.

[0007]

However, when aggregating the number of installations using spreadsheet software, it is necessary to re-enter data one by one into each cell of the table created by the spreadsheet software for the type and number of installations. Not only is there a need to do this, but it is extremely difficult to confirm whether or not the re-input data is correct, and there is the problem that the reliability of the aggregated results is poor.

[0008] In addition, the installation work for a specific installation,
When performing installation confirmation work and maintenance work, it is essential to confirm the installation position. In this case, since the plots for all the installations exist in each drawing, the more installations there are, the more difficult it is to find a plot of a particular installation without overlooking. In particular, if the installation is to be installed only on a limited number of floors of a high-rise building with several tens of floors, it is necessary to review the floor plans of all floors to confirm the installation location. , It is not easy to find it from the floor plan of several tens of floors.

Further, in the case of exchanging all of the specific installations with the lapse of service life, first, it is necessary to have data on what kind of installations and how many and where they are installed. If such data is not available for old buildings, etc., you must start by going around each floor of the building and collecting data on the number of installations and installation locations for specific installations. It is difficult to collect.

These circumstances are not limited to the management of installations in high-rise buildings, but also the management of installations at a plurality of sales offices, stores, branches, warehouses, and various ground installations such as road signs and guide signs by region. The same applies when managing.

Therefore, according to the present invention, firstly, when individual information consisting of identification symbols such as installation objects is plotted on a drawing or the like using CAD software or the like, a tabulation table of the individual information is automatically created. Secondly, the technical issue is to be able to easily confirm where specific installations are located and to collect data.

[0012]

In order to solve this problem, the invention according to claim 1 has an individual layer in which individual information is plotted, and an aggregate having a cell in which an aggregate processing calculation formula of the individual information is set. The feature is that the summary layer recording the table is created in one file.

According to the first aspect of the present invention, a cell in which the aggregation processing calculation formula of the individual information plotted in the individual layer is set is formed in the aggregation table recorded in the aggregation layer. Since the individual layer and the summary layer are created as independent layers in one file respectively, if the individual information to be aggregated is plotted on the individual layer, the aggregated data of the individual information will be displayed in the summary table of the aggregated layer. Is displayed.

If the display color conversion means for converting the display color of the individual information for each individual information is provided as in the second aspect of the invention, each layer is created in one file. If you change the display color for the individual information of,
The display color of specific individual information recorded on all layers is converted at once. Therefore, if the display color of the individual information to be searched for is changed, the individual information can be searched for from each layer without oversight.

Further, as in the third aspect of the invention, if the position information layer recording the drawing showing the position where the individual information is plotted and the individual layer are displayed in layers, the individual information can be plotted in the individual layer very easily. can do.

In particular, when the identification information such as an ID number or a mark attached according to the type of the indoor / outdoor installation or the ground installation of the building is used as the individual information as in the invention of claim 4, If an internal plan of the building or a map of a specific area is recorded in the position information layer, the identification symbol can be plotted on the drawing according to the installation position.

When the total layer is a unit total layer recording a unit total table for displaying total data of individual information plotted in one individual layer, each individual individual layer is recorded. A summary table of individual information can be displayed for each layer.

Therefore, it is possible to display a table for each floor or store for indoor / outdoor installations, and for each area for ground installations. It is possible to display the installation location by layer and the number of installations by the unit summary table.

When a plurality of individual layers are created as in the invention of claim 6, the aggregated data obtained by aggregating all the individual information plotted in the plurality of individual layers as an aggregate layer for each individual layer. And, by using the total summary layer that records the summary data that aggregates the individual information collectively for all individual layers, the aggregate data of individual information can be displayed for each individual layer and It is also possible to display aggregated data for individual layers.

For example, when managing indoor and outdoor installations of a high-rise building, the total summary table displays the number of installations for each floor of the high-rise building and the total number of installations, regardless of the number of installations. , It is easy to see what is installed on which floor.

According to a seventh aspect of the present invention, at least the individual layer, a position information layer in which image data indicating a position at which the individual information is plotted are recorded, and a calculation processing formula of the individual information plotted in the one individual layer A required number of plot sheets are created by stacking unit summary layers that record summary tables with cells set to, and the individual information plotted in each individual layer in the overall summary layer is summarized and displayed. Is made in.

According to the invention of claim 7, when managing installations of a high-rise building, a position information layer in which floor plans of respective floors are recorded, an individual layer for plotting identification symbols of installations, and a unit Create three layers, one of which is a layered layer, as a total layer, and create layers for each floor. Here, if you plot the identification symbols according to the type of installation on the individual layers of each floor, the aggregate data of the installations on each floor will be automatically entered in the unit aggregation layer, and the aggregation processing will be performed.
Aggregated data for each type of installation and number of floors is automatically input to the total aggregation layer.

Therefore, only by plotting on the individual layer, the necessary total data is automatically input to each of the unit total layer and the total total layer. By displaying aggregated data on how many floors each installation is on in the total aggregation layer, which installation is installed on what floor when performing installation work, installation confirmation work, and maintenance work. Is obvious. Also, by displaying the individual layers on each floor, it is possible to confirm where each floor is installed on the internal plan view, so there is no need to search for the installation location.

When the summary layer is an individual summary layer in which an individual summary table displaying the summary data is recorded for each individual information plotted in the individual layer as in the invention of claim 8, the individual information is You can display the aggregation result for each.

The invention according to claim 9 is as an aggregation layer,
Individual information plotted on all individual layers is aggregated for each individual information, together with image information corresponding to the individual information,
An image-added summary layer that records a summary table to be displayed as a list is used.

According to the invention of claim 9, by displaying a photograph or a schematic diagram of each installation as image information when managing the installation, the shape of the installation displayed by the model number or the like can be visually recognized. It can be confirmed as a realistic shape.

[0027]

BEST MODE FOR CARRYING OUT THE INVENTION Embodiments of the present invention will be specifically described below with reference to the drawings. 1 is a conceptual diagram showing a data management system according to the present invention, FIG. 2 is an explanatory diagram showing a plot sheet, FIG. 3 is an explanatory diagram showing an overall aggregation layer, FIG. 4 is an explanatory diagram showing an individual aggregation layer, and FIG. It is explanatory drawing which shows a total layer with an image.

A case where the present invention is applied to an indoor installation management system for managing emergency installations installed on each floor of a high-rise building will be described below. An indoor installation management system (data management system) 1 using the present invention is an identification code Pn (n = 1) preset according to an emergency installation.
~ N) is an individual layer 2 that is plotted as individual information
And a position information layer 3 in which the image data M of each floor internal plan view showing the position where the identification symbol Pn is plotted is recorded,
Three kinds of layers 2, 3, which are the floor-specific aggregation layer (unit aggregation layer) 5A that records the floor-specific aggregation table (unit aggregation table) 4A that displays the aggregation data of each identification symbol Pn plotted in one individual layer. Plot sheets 6 in which 5A are laminated are prepared for the number of floors of the building.

Further, the identification symbols Pn plotted on the individual layer 2 of each floor are tabulated and displayed for each floor, and the total tabulation table 4B for displaying the tabulated results of all the individual layers 2 is recorded as the total tabulation layer 5B. , An individual tabulation layer 5C in which an individual tabulation table 4C for each identification code Pn is recorded for all identification codes Pn plotted in all the individual layers 2 and an identification code Pn plotted in all the individual layers 2 is provided for each identification code Pn. The image totaling layer 5D in which the image list G4 corresponding to the identification symbol Pn and the image list totaling table 4D to be displayed as a list are recorded is created.

The layers 2 ... 3 ... 5A
5D are all created as individual layers of one file 7, and the calculation processing formula of the identification symbol Pn is set in each cell of each of the totalization tables 4A to 4D as necessary. Further, a display color conversion means is provided for converting the display color of the identification symbol Pn recorded in the file 7 for each identification symbol Pn. For example, with respect to the installation represented by the identification symbol P ₁ , arbitrary layers 2, 3, 5A to 5D
If the display color of the identification symbol P ₁ is changed to red, the layers 2, 3, 5A to 5D are created in one file 7, so the identification symbol P recorded in all layers is recorded.
The display color of ₁ is collectively converted.

The plot sheet 6 includes a unit information layer 4A having a transparent background color on a position information layer 3 having an opaque background color, and an individual layer 2 further arranged on the unit totalizing layer 4A. When the images are stacked and displayed, the image data M of each floor internal plan view, the identification symbol Pn plotted on the image data, and the floor-specific summary table 4A are as if written on one drawing. Is displayed.

In the floor-by-floor tabulation table 4A recorded in the unit tabulation layer 5A, the individual layer 2 of the same plot sheet 6 is included.
The identification symbol display field F _{11 of} the installations plotted in FIG. ₁₁ , the name display field F ₁₂ and the installation number display field F ₁₃ corresponding to each of them.
There are formed, the identification symbols Pn and each installation number display field F ₁₃ plotted in the individual layer 2 of the same plot sheet 6
An aggregation process calculation formula for aggregating the number of plots of is set.

[0033] throughout the entire recorded on aggregate layer 5B schedule 4B is an identification symbol display column _{F 21,} the name display field F
₂₂ , an installation number display column F _{23 for} each floor showing the number of installation items installed on each floor, a total installation number display column F ₂₄ showing the total number of installations, a unit price display column F _25, and a total price display for each installation item The column F ₂₆ is formed, and the total amount display column F ₂₇ is formed at the bottom of the installation-based total amount display column F ₂₆ .

[0034] Here, in Kaibetsu placed the number of display field F _{23 ...} is,
A totaling process calculation formula for totaling the total number of plots of the identification symbols Pn plotted on the individual layer 2 of the relevant floor is set, and the total installation number display field F ₂₄ displays in the installation number display field F _{23 for} each floor. It is set calculation formula for calculating the installation total number of which is, in the installed object-specific total amount display column F _{2 6,} an installation number calculated in full extension number display column F _24, unit price display column F
A calculation formula for calculating the total amount of money for each installation is set based on the unit price written in _25, and the total amount display field F
_{In 27} , a calculation formula for totaling the amounts of money recorded in the installation-based total amount of money display field F ₂₆ is set.

The individual aggregate layer 5C individual schedule 4C recorded, the identification symbol display column _{F 31,} the name display field F
₃₂ , a part quantity display field F ₃₃ that displays the quantity of parts when each installation is composed of a plurality of parts, a unit price display field F ₃₄ that displays the unit price, and a part price display field F that displays the price of parts. ₃₅ , a unit price display field F ₃₆ for displaying the unit price of the installation, which is the total of the component prices, an installation number display field F ₃₇ for indicating the number of installations of the installation, and a total price display field F _{38 for} each installation. Has been done.

Here, a totalization calculation formula for totaling the total number of plots of the identification symbols Pn plotted on all the individual layers 2 ... Is set in the installation number display field F _37, and the total price display field F by installation item F _{In 38} , a formula for calculating the product of the data in the unit price display field F ₃₆ and the installed number display field F ₃₇ is set.

Further, the image list totalizing table 4D recorded on the image totaling layer 5D is provided with display areas DA ... For each type of the identification symbol Pn, and in each display area DA, the identification symbol display column F ₄₁ , Name display column F ₄₂ , installation number display column F ₄₃ , image information display column F corresponding to the identification symbol Pn
₄₄ is formed, and the unit price display field F is provided if necessary.
₄₅ and a total amount display column F _{46 for} each installed object are set.

Then, the installation number display column F₄₃In all
Each identification symbol Pn plotted on the individual layer 2 ...
The total processing calculation formula for totaling the total number of plots of is set,
Total amount display column F by installation₄₆Is the unit price display field F₄₅Over
And installation number display column F ₄₃Total by installation based on data from
A calculation formula for calculating the amount of money is set.

In the image information display field F ₄₄ , an arbitrary image of the installation is displayed as image information Gn. In this example, a front view, a plan view, a right side view, a perspective view thereof and a 3D image are displayed. It is supposed to be displayed. This 3D image is
It may be one that can be oriented at any angle by mouse operation, or one that is fixed in any direction. In addition, when the installation has a simple shape or when it is necessary to identify the letters and figures drawn on the front,
It is more convenient to use the front view only.

The above is the configuration of the present invention, and its operation will be described below. For example, when designing the layout of installations on each floor of a high-rise building, when CAD software has created the internal floor plan of each floor, each is attached to the location information layer 3 of each floor, and this location information layer 3 Plot sheets 6 in which the unit aggregation layer 5A and the individual layer 2 are stacked are prepared for the number of floors of the high-rise building.

Further, when all the installation objects to be used are decided, the respective identification symbols Pn, names, and image information Gn are decided according to the types of installation objects, and the total tabulation table 4B, individual tabulation table 4C, image Create a list summary table 4D,
It is recorded in the total aggregation layer 5B, the individual aggregation layer 5C, and the image-added aggregation layer 5D. At this time, an aggregation process calculation formula is set in each cell of each of the aggregation tables 4B to 4D as needed.

Next, the plot sheet 6 is displayed for each floor, and while looking at the internal plan view of the position information layer 3,
The identification symbol Pn of the desired installation object is plotted on the individual layer 2 at the place where the identification symbol Pn is to be installed. At this time, the installation number display columns F ₂₃ , F _{24 of} each of the tabulation tables 4B to 4D,
The F ₃₇ and F _{4 3} cells are set up with a totalization calculation formula for totaling the number of plots of the identification symbols Pn plotted on the individual layer 2, so the total is calculated by simply plotting the identification symbols on the individual layer 2. Processing is performed and the number of installations is totaled, and in accordance with this, the amount display columns F ₂₆ , F
₃₈ , F ₄₆ , and the amount display in the total amount display column F ₂₇ changes.

[0043] Also, the plot of each floor of the identification symbols Pn is ended, creates a floor totals table 4A in the unit aggregate layer 5A, are plotted into separate Layer 2 of the same plot sheet 6 to the installation number display field F ₁₃ each If you set up the aggregation process calculation formula that aggregates the number of plots of the identification symbol Pn,
The number of each identification symbol Pn plotted in the individual layer 2 is automatically totaled.

When plotting is completed for all floors in this way, there is no need to input any data,
The aggregation result is the aggregation table 4A-of each aggregation layer 5A-5D.
Displayed in 4D. In this case, since the trouble of re-inputting data is not necessary at all, an input error will not occur. Then, when the manufacturing cost is calculated or the like, the total amount required to purchase the installation item can be seen at a glance by looking at the total amount display column F ₂₇ of the total aggregation layer 4B.

Next, when ordering the installation items, the individual totalization layer 5C displaying data such as the parts list, the unit price of the parts, the number of installations, and the total price for each installation item, and if necessary, corresponding to each identification symbol Pn If an order is made with reference to the image-added total layer 5D on which the image to be displayed is displayed, waste such as excess or shortage of quantity is reduced.

Further, when the installation is brought into the site, the installation work cannot be performed unless it is known which installation should be installed on which floor. In this case, after confirming the floor on which the installation object having the specific identification symbol Pn is installed from the overall aggregation table 4B of the overall aggregation layer 5B using a laptop computer or the like, change the identification symbol Pn to red. If the plot sheet 6 of the floor is displayed, or if the plot sheet 6 is printed out, only the corresponding identification symbol Pn is displayed in red in the internal plan view of each floor.
The location is also self-explanatory.

Even after confirming whether or not the installation object is correctly set after the installation work is completed for the specific installation object having the identification symbol Pn, the floor of the installation object is installed in the same manner as described above. After confirming that, the identification symbol Pn is changed to red and the plot sheet 6 of the floor is displayed, and the confirmation work is performed while looking at this, so that oversight can be reduced.

Next, when performing maintenance on a specific installation object such as replacement work due to the lapse of useful life,
In order to secure a budget, we first investigate how many installations are to be replaced and how much they cost, and adjust the budget allocation. Therefore, if you look at the total aggregation layer 5B, the individual aggregation layer 5C, or the image-attached aggregation layer 5D, the number of installations and the total purchase price for the particular installation are displayed, so it is necessary to perform any aggregation processing. Absent.

When performing maintenance work such as replacement while confirming the installation location of each installation item, after confirming the installation floor in the aggregation layer 5B, the corresponding identification symbol is reversed to plot the floor. If you confirm the installation location on the sheet 6, you will not overlook it.

If such data is not prepared in advance for the installations, it is necessary to go around each floor of the building and collect data on the number of installations and installation locations of the specific installations. In this case, enter the floor plan of each floor in the location information layer 2 and go around each floor of the building looking for a specific installation while plot sheet 6
If the identification symbols are plotted on the internal plan view indicated by, each summary table 4A to 4D is created in the same manner as when designing the layout of the installation objects, so maintenance work is performed based on this data. Should be done.

Further, in the above description, the case where it is used as an installation management system for managing installations in a high-rise building has been described, but the present invention is not limited to this, and can be used in convenience stores, family restaurants, chain stores of gas stations. It can be used to manage advertising towers, signs, equipment, display shelves, and other in-store installations on a store-by-store basis, as well as any installation management such as ground installations such as road signs and guide signs.

[0052]

As described above, according to the present invention, only by plotting individual information, the aggregate data of the individual information is displayed in the aggregate table. The time and effort required for inputting are completely eliminated, and therefore, a very excellent effect of not making an input error can be achieved. Also, if you change the display color for each identification symbol, the display color of the identification symbol displayed on all layers will change, so it is extremely easy to check the installation location of a specific installation and there is no oversight. Has a very good effect.

[Brief description of drawings]

FIG. 1 is a conceptual diagram showing a data management system according to the present invention.

FIG. 2 is an explanatory diagram showing a plot sheet.

FIG. 3 is an explanatory diagram showing an overall aggregation layer.

FIG. 4 is an explanatory diagram showing an individual aggregation layer.

FIG. 5 is an explanatory view showing a total layer with images.

[Explanation of symbols]

1 ………… Indoor installation management system (data management system) Pn …… Identification symbol 2 ………… Individual layer M ………… Image data 3 ………… Position information layer 4A …… Floor summary table 4B …… Overall summary Table 4C: Individual totalization table 4D: Image list Totalization table Gn: Image information 5A: Unit totalization layer (totalization layer) 5B: Overall totalization layer (totalization layer) 5C: Individual totalization layer (totalization layer) 5D …… Total layer with image (total layer) 7 ………… File

─────────────────────────────────────────────────── ─── Continuation of front page (51) Int.Cl. ⁷ Identification code FI theme code (reference) G09B 29/00 G09B 29/00 A

Claims (9)

[Claims] 1. An aggregate that records an individual layer (2) on which individual information (Pn) is plotted, and an aggregate table (4A to 4D) having cells in which an aggregate processing calculation formula of the individual information (Pn) is set. A data management system characterized in that layers (5A to 5D) are created in one file (7). 2. The data management system according to claim 1, further comprising display color conversion means for converting a display color of the individual information (Pn) for each individual information. 3. A plot sheet (6) is formed by stacking and displaying a position information layer (3) recording image data (M) representing a position where the individual information (Pn) is plotted and the individual layer (2). The data management system according to claim 1 or 2. 4. The individual information (Pn) is an identification symbol according to the type of indoor / outdoor installation or ground installation of a building,
The data management system according to claim 3, wherein an internal plan view of a building or a map of a specific area is recorded in the position information layer (3). 5. The aggregation layer is a unit aggregation layer (5A) recording a unit aggregation table (4A) displaying aggregated data of individual information (Pn) plotted in one individual layer (2). The data management system according to items 1 to 4. 6. When a plurality of the individual layers (2 ...) Are created, all the individual information (P) plotted in the plurality of individual layers (2 ...) In the aggregate layer.
n) is aggregated for each individual layer (2), and the individual information (Pn) is used for all individual layers (2).
The total summary layer (5B) that records the total summary table (4B) that displays the summarized data collectively for
The data management system according to any one of claims 1 to 4. 7. At least the individual layer (2), a position information layer (3) recording image data (M) indicating a position where the individual information (Pn) is plotted, and one of the individual layers (2). Individual information plotted (Pn)
The total number of plot sheets (6) formed by stacking and displaying unit summary layers (5A) recording summary tables having cells with the calculation formulas set are created in the total summary layer (5B). 7. The data management system according to claim 6, wherein the individual information (Pn) plotted on each individual layer (2) is displayed in an aggregated manner. 8. The aggregation layer is an individual layer (2
5. An individual totalization layer (5C) recording an individual totalization table (4C) displaying aggregated data of individual individual information (Pn) plotted in ().
Described data management system. 9. The aggregation layer is an individual layer (2
All the individual information (Pn) plotted in () are recorded together with the image information (Gn) corresponding to each individual information (Pn), and a total table with images (4D) to be displayed as a list is recorded. The data management system according to any one of claims 1 to 4, which is a total layer (5D) with an image.