JP2004118340A

JP2004118340A - Integrating processing system and device, and program

Info

Publication number: JP2004118340A
Application number: JP2002277843A
Authority: JP
Inventors: Riyougo Shimizu; 清水　良悟
Original assignee: Toshiba Corp; Toshiba Solutions Corp
Current assignee: Toshiba Corp; Toshiba Digital Solutions Corp
Priority date: 2002-09-24
Filing date: 2002-09-24
Publication date: 2004-04-15
Anticipated expiration: 2022-09-24
Also published as: JP3927106B2

Abstract

<P>PROBLEM TO BE SOLVED: To store a deciding process of a numerical quantity of a unit price list effectively utilized in creating the next unit price list. <P>SOLUTION: This integrating processing system comprises a master database 31 storing various data relating to the unit price list used as standard in integrating, a storing means 14a and the like storing a unit price list creation screen, a calculator-type calculation process input screen and a numerical quantity input list screen, a unit price list creating means 151 displaying the unit price list creation screen of the storing means, and writing various data relating to the unit price list, a numerical quantity calculating inputting means 152 displaying the calculation process input screen of the storing means on the basis of the input of the numerical quantity calculating inputting instruction, inputting the numerical quantity calculating inputting data to the calculation process input screen, performing the calculation of the numerical quantity by using the unit price, and writing the numerical quantity and the calculation process to a numerical quantity area of the unit price list creation screen and storing the same, and a numerical quantity input list creating means 153 for creating the numerical quantity input list screen by using the calculation process acquired by the calculating inputting means and using the same in correction/appropriation. <P>COPYRIGHT: (C)2004,JPO

Description

【０００１】
【発明の属する技術分野】
本発明は、各種の積算業務を支援する積算処理システム、積算処理装置及びプログラムに関する。
【０００２】
【従来の技術】
この種の積算処理システムには、幾つかの積算処理形態が考えられている。
【０００３】
その１つの積算処理形態は、予めマスタデータベースに積算基準となる単価表の構成要素・単価が蓄積され、単価表の作成時、マスタデータベースの単価表の構成要素・単価を参照し、単価表に必要な構成要素を適宜選択し、自動的に費用の明細となる単価表（労務，機械，材料の単価×数量＝金額の集合体）を作成する。なお、各構成要素の数量については、単価表作成者、積算者が各積算対象とする業務のノウハウのもとに、任意のツール（電卓、表計算ソフト）を用いて、数量結果を算出している。
【０００４】
具体的に述べると、図６に示すように積算対象が「ある建築物の塗装」であると仮定した場合、マスタデータベース５１に積算基準となる建築物の塗装に関する各積算項目名称である塗装種類（素地調整、下塗、中塗，上塗，…）の他、単価表作成に必要な規格、単位、単価等データが定められているが、単価表の作成に際し、数量が必要となる。この数量の算出は、単価表作成者や積算者が電卓５２や表計算ソフト５３を用いて、各壁の面積を算出し、さらに複数の壁面積を合算した塗装総面積を集計し、１つの塗装種類の面積である数量結果５４を決定する。
【０００５】
そして、各塗装種類ごとに面積数量結果５４を出した後、積算処理装置５５の単価表作成機能がマスタデータベース５１から積算基準となる建築物の塗装に関する各積算項目である塗装種類を選択し、この塗装種類に対応する規格、単位、単価を取り出し、さらに電卓５２や表計算ソフト５３によって決定された数量を入力し、この数量と単価とに基づいて金額を計算し単価表を作成するとともに、マスタデータベースもしくはその他の記憶手段５６に記録する。従って、単価表の作成後、記憶手段に数量データが保存されるが、「数量」の計算過程が単価表レコードには記録されない。
【０００６】
また、他の１つの積算処理形態は、建築物に関する積算項目名称，数量，数量計算式、単価，金額が積算明細マスタを介して入力される積算計算ファイルが設けられ、単価表作成時に積算項目名称ごとに各数量計算式により自動的に数量を算出し、ファイルの数量データを更新する形態である（例えば特許文献１参照）。
【０００７】
【特許文献１】
特開２００２−４９６５７号公報。
【０００８】
【発明が解決しようとする課題】
しかしながら、前者の積算処理形態は、数量の計算過程が記録されず、数量の計算根拠は専ら積算者個人のノウハウに留まることから、建築工事の都度、別ツールを利用して各費用明細の数量計算を行なう必要があり、前任者等の数量計算内容を有効に活用できない問題がある。
【０００９】
また、記憶手段５６に多数の建築工事に関する単価表の集合体である積算設計書データが保存されるが、数量の計算過程が見えないことは、管理者を初め、その担当部署で数量の適正化その他をチェックできない不便さがある。
【００１０】
一方、前述する後者の積算処理形態は、予め積算項目名称ごとに数量計算式が定められているが、積算項目名称ごとの細かい作業に対する内容が見えなくなり、適切な積算明細が作成できない問題がある。
【００１１】
また、一般的には、建築工事に際し、ユーザの要求に応じて各種のオプション項目が入ってきたとき、その都度ソフト的に計算式を構築する必要があり、返って融通性に欠ける問題がある。
【００１２】
本発明は上記事情に鑑みてなされたもので、数量計算過程を含んで積算に関連するデータ全体を一元管理し、他の単価表作成時に数量計算過程の有効活用，ひいては単価表作成作業の効率化を図り、また積算内容の正当性を容易にチェック可能とする積算処理システム、積算処理装置及びプログラムを提供することを目的とする。
【００１３】
【課題を解決するための手段】
（１）　上記課題を解決するために、本発明に係わる積算処理システムは、ネットワークを通じて複数の積算処理装置およびサーバ装置とが接続されてなる積算処理システムであって、
前サーバ装置は、積算基準となる単価表に関する積算項目名称及び単価表作成上必要とする単位、単価等の各種データを保存する第１の記憶手段が設けられ、前記積算処理装置からの要求に応じて前記積算項目名称に対応する各種のデータを送信し、
前記各積算処理装置は、前記単価表を作成するために必要な単価表作成画面、電卓形式の計算過程入力画面を格納する第２の記憶手段と、前記単価表の作成に際し、前記第２の記憶手段から単価表作成画面を読み出して表示し、前記サーバ装置の第１の記憶手段から前記単価表に関する各積算項目名称に対応する単位、単価等のデータを取得し、前記単価表作成画面に書込む単価表作成手段と、数量計算入力指示の入力に基づき、前記第２の記憶手段から計算過程入力画面を読み出して表示し、この計算過程入力画面に数量計算入力データを入力し、この数量計算入力データと前記単価とを用いて数量計算処理を実行し、前記単価表作成画面の数量エリアに計算処理結果の数量及び計算過程を書込み前記第２の記憶手段に保存する数量計算入力手段と、この数量計算入力手段によって取得された計算過程を用いて数量入力表画面を生成し前記第２の記憶手段に保存する数量入力表生成手段と、修正・流用等の指示を受けた場合、予め記憶される数量入力表メニュー画面に基づいて積算対象に類似する数量入力表画面を読み出し、当該数量入力表画面の数量計算入力データ等を修正し、前記単価表作成画面の数量エリアに修正処理結果の数量及び計算過程を書込んで前記第２の記憶手段に保存する手段とを設けた構成である。
【００１４】
本発明は以上のような構成とすることにより、各積算処理装置は、単価表作成時、単価表作成画面に前記サーバ装置の第１の記憶手段に記憶される単価表に関する各積算項目名称に対応する単位、単価等のデータを取り出して書込むとともに、単価表の数量エリアに関し、電卓形式の計算過程入力画面を表示し、この画面から順次数量計算入力データを入力する。その結果、入力される数量計算入力データと画面上の単価とを用いて数量計算処理を実行し、計算処理結果の数量と計算過程とを単価表作成画面の数量エリアに書込むので、数量に関係する計算過程を履歴として保存することが可能である。
【００１５】
また、各積算処理装置は、計算過程を用いて数量入力表画面を生成し記憶するが、修正・流用等の指示を受けた場合、予め記憶される数量入力表メニュー画面に基づいて積算対象に類似する数量入力表画面を読み出し、数量入力表画面の数量計算入力データ等を修正し、単価表作成画面の数量エリアに修正処理結果の数量及び計算過程を書込んで記憶するので、単価表作成作業を効率的に行うことが可能である。
【００１６】
なお、以上のような構成は、積算処理システムに関する構成であるが、サーバ装置自体に各積算処理装置の上記構成を設けてもよく、或いはサーバ装置や各積算処理装置がコンピュータの場合には、一連の単価表作成処理をプログラムによっても実現することも可能である。
【００１７】
【発明の実施の形態】
以下、本発明の実施の形態について図面を参照して説明する。
【００１８】
図１は本発明に係わる積算処理システムの一実施の形態を示す構成図である。
【００１９】
この積算処理システムには、例えば社内網であるＬＡＮ、専用線などのネットワーク１が設けられ、このネットワーク１には、単価表を作成する積算担当者などが所持する積算処理装置２ａ，２ｂ，…，２ｎと、積算基準となる積算項目名称、規格、単位、単価等に関するデータを一元管理するサーバ装置３が接続されている。なお、単価表作成処理を含む一連の積算処理は積算処理装置２ａ，２ｂ，…，２ｎが行うが、サーバ装置３側が積算処理装置２ａ，２ｂ，…，２ｎの機能を備えている場合にはサーバ装置３側で行ってもよい。
【００２０】
サーバ装置３には、前述する積算基準となる積算項目名称、規格、単位、単価等に関するデータを一元管理するためのマスタデータベース３１が設けられている。
【００２１】
各積算処理装置２ａ，２ｂ，…，２ｎは、単価表を作成する積算担当者その他の該当部署の業務担当者が必要なデータや制御指示その他必要な指示を入力するキーボード，ポインティングデバイス等の入力手段１１ａ，１１ｂ，…，１１ｎと、単価表作成処理に関連する画面等を表示する表示部，プリンタなどの出力手段１２ａ，１２ｂ，…，１２ｎと、積算処理に必要な全てのプログラムを記録する記録媒体１３ａ，１３ｂ，…，１３ｎ（記録媒体１３ｂ，…，１３ｎは図面省略）と、単価表入力画面２１、電卓形式入力の計算過程入力画面２２及び数量入力表画面２３のデータの他、単価表作成に関する処理中、処理後のデータ及びマスタデータベース３１から読み出した必要なデータ等を一時記憶するとか、数量計算入力データを所要のデータに変換するデータ変換テーブルなどを記憶するデータ一時記憶手段１４ａ，１４ｂ，…，１４ｎと、入力手段１１ａ，１１ｂ，…，１１ｎからの制御指示に基づいてデータ一時記憶手段１４ａ，１４ｂ，…，１４ｎから単価表作成画面を読み出して表示し、費用明細となる単価表の作成の他、単価表の一構成要素である数量計算入力による計算過程の履歴保存処理及び数量入力表生成などの処理を行い、また単価表の集合体である積算設計書データを一元管理するＣＰＵで構成された積算制御処理部１５ａ，１５ｂ，…，１５ｎとによって構成されている。なお、各画面２１〜２３等については画面データ専用の記憶手段或いは記録媒体１３ａ，１３ｂ，…，１３ｎに記憶してもよいが、以下、説明の便宜上、データ一時記憶手段１４ａ，１４ｂ，…，１４ｎに記憶されている例について述べる。
【００２２】
また、記録媒体１３ａ，１３ｂ，…，１３ｎとしては、一般的にはＣＤ−ＲＯＭやＨＤＤ等が用いられるが、それ以外にも例えば磁気テープ、ＤＶＤ−ＲＯＭ、フロッピーディスク、ＭＯ、ＣＤ−Ｒ、メモリカードなどを用いてもよい。
【００２３】
この積算処理装置２ａ（２ｂ，…，２ｎ）の積算制御処理部１５ａ，（１５ｂ，…，１５ｎ）について説明する。なお、各積算制御処理部１５ａ，１５ｂ，…，１５ｎは同一構成であるので、以下、積算制御処理部１５ａについて説明し、他の１５ｂ，…，１５ｎについては省略する。
【００２４】
すなわち、積算処理装置２ａの積算制御処理部１５ａは、図２に示すように、入力手段１１ａから入力される単価表作成指示に基づき、データ一時記憶手段１４ａから単価表作成画面２１を読み出して表示した後、サーバ装置３のマスタデータベース３１から積算基準となる単価表に必要な各積算項目名称に対応するフィールドデータ（規格，単位等のデータ）を読み出して単価表を作成する単価表作成手段１５１、入力手段１１ａから入力される数量計算入力指示の入力を受けて、データ一時記憶手段１４ａから電卓入力形式の計算過程入力画面２２を表示し、通常の電卓イメージにて数量計算入力データを入力し、その計算結果である数量及び計算過程を前記単価表の構成要素である数量エリアに書込む数量計算入力手段１５２と、この手段１５２による数量計算入力データを用いて数量入力表画面２３を生成する数量入力生成手段１５３が設けられている。
【００２５】
従って、ある建築物の例えば塗装に関し、マスタデータベース３１から積算基準となる積算項目名称，規格，単位等のデータを読み出すだけで、積算処理装置２ａは、数量，当該数量を算出するに至った計算過程，この数量と単価とから計算される金額等からなる単価表レコードを有する費用の明細となる単価表を保管でき、第３者においては、その数量決定に関する根拠の正当性について容易にチェックできる。
【００２６】
なお、以上の説明は、各積算処理装置２ａ，２ｂ，…，２ｎの構成について説明したが、サーバ装置３側に同様の手段１５１〜１５３を設け、かつ、マスタデータベース３１等に必要な画面２１〜２３を保存すれば、サーバ装置３が同様の処理を実行することが可能である。
【００２７】
次に、積算処理装置の動作及び積算制御処理部１５ａが記録媒体１３ａから単価表作成処理用プログラムを読み出して一連の処理を実行する例について図３及び図４を参照して説明する。
【００２８】
先ず、積算制御処理部１５ａは、単価表作成手段１５１を実行する。この、単価表作成手段１５１は、入力手段１１ａから単価表作成指示が入力されたか否かを判断し（Ｓ１）、作成指示が入力されたと判断された場合、データ一時記憶手段１４ａから図４に示す単価表作成画面２１を読み出し、出力手段１２ａの１つである例えば表示部に表示する（Ｓ２）。
【００２９】
この単価表作成画面２１を表示した後、積算担当者等は、マスタデータベース３１から積算対象に必要な積算項目名称を順次選択すると、各選択された積算項目対象に対応する規格，単位、単価等のデータを取り出し、画面の該当エリアに自動的に書込んで表示する（Ｓ３）。これらステップＳ１〜Ｓ３は単価表作成機能に相当する。従って、この段階においては、数量入力欄となる数量入力エリアと金額エリアだけが空白状態となっている。
【００３０】
引き続き、積算制御処理部１５ａは、予め定める規則に従って例えば入力手段１１ａの一形態であるマウス操作による数量計算入力指示が有りか否かを判断し（Ｓ４）、指示入力がない場合には従来と同様な数量入力形態と判断し、指示入力がある場合には本来の数量計算入力手段１５２を起動する。すなわち、ここでは、データ一時記憶手段１４ａから電卓形式の計算過程入力画面２２を読み出し、出力手段１２ａにウインドウ表示する（Ｓ５）。計算過程入力画面２２を表示した後、数量入力表の表示指示が有りか否かを判断する（Ｓ６）。
【００３１】
ここで、数量入力表が表示指示が無いと判断された場合、積算者等がマウス操作によって計算過程入力画面２２に対して電卓イメージで数量計算入力データを順次入力すると（Ｓ７）、計算処理を実行する（Ｓ８）。そして、計算が複数行に及ぶことが多いので、計算終了まで続ける（Ｓ９）。これらステップＳ４〜Ｓ９は数量計算入力機能に相当する。
【００３２】
なお、電卓形式による入力は、行単位で入力を行い、変数については定義が可能である。なお、定義済み変数はコンボックス（Ｃｏｍｂｏ　Ｂｏｘ）に表示される。数値のみの入力の場合、定数として判断する。入力された数量計算入力データは電卓同様に計算を行う。複数行の計算を行う場合、「Ｍ＋」（行計算結果をプラス）または「Ｍ−」（行計算結果マイナス）により１行の計算結果を確定し、次行に移るものとする。
【００３３】
そして、計算過程入力画面２２の「＝」を操作することにより、計算結果を数量として単価表データに反映する（Ｓ１０）。さらに、計算過程を式データに変換し、同様に単価表データに登録する（Ｓ１１，Ｓ１２）。これらステップＳ１０〜Ｓ１２は数量計算過程保存機能に相当する。
【００３４】
この計算過程を式データに変換する場合、一例として、例えば図５に示すようなデータ一時記憶手段１４ａに記憶されるデータ変換テーブルのデータ変換内容に基づいて変換する。
【００３５】
引き続き、積算制御処理部１５ａは、数量入力表生成手段１５３を実行する。この数量入力表生成手段１５３は、単価表レコードに登録されている計算過程データから数量入力表を生成する（Ｓ１３：数量入力表生成機能）。各行データについては、変数，定数，演算子（＋，−，＊，÷）を用い、各行の小計及び全行の集計を行い、例えば後述するように数量入力表メニューに必要な識別データ等の文書名を付してデータ一時記憶手段１４ａに保存する。
【００３６】
ところで、ステップＳ６において、例えばマウスによる右クリックによる操作があれば、数量入力表の表示指示有りと判断し、データ一時記憶手段１４ａから数量入力表メニュー画面２４を読み出して出力手段１２ａにウインドウ表示する（Ｓ１４）。この数量入力表メニュー画面２４は、過去に積算対象ごとに作成された数量入力表の一覧であり、例えばメニュー識別データとしては例えば積算対象「建築物の塗装」などによって表わされている。この中から今回の積算対象に近いか、あるいは比較的類似する積算対象を選択すると、データ一時記憶手段１４ａからその数量入力表メニューに対応する数量入力表画面２３を読み出して出力手段１２ａに表示する（Ｓ１５）。この数量入力表画面２３を表示する理由は、今回の積算対象に近いか、あるいは比較的類似する積算対象の単価表作成の作業効率を上げるためである。
【００３７】
ここで、積算者等においては、数量入力表画面２３の必要なエリアの数値等を修正し、計算終了の指示を入力すれば（Ｓ１６）、ステップＳ１０に移行し、前述同様の処理を実行し、更新処理を実行する（Ｓ１０〜Ｓ１３）。
【００３８】
これらステップＳ１４〜Ｓ１６は数量修正処理機能相当する。
【００３９】
従って、以上のような一連の処理により、数量だけでなく、数量計算過程のデータも保存でき、しかもこの数量計算過程のデータから数量入力表を生成し、後の類似の積算対象に利用可能にしたので、数量入力表メニューから適宜選択し、修正利用することにより、単価表を効率的に作成できる。
【００４０】
すなわち、本発明に係わる積算処理システム、積算処理装置及びプログラムの実施の形態によれば、従来、作成される単価表だけでなく、独立したツール（電卓，表計算ソフト）によって算出される数量の計算過程が積算処理装置１５ａに記憶され、これら単価表の集合体である積算設計書データを一元管理でき、ひいては既に作成された単価表の計算過程を修正時に有効に活用できる。よって、数量の算出に関わる作業の効率化を図ることができる。
【００４１】
また、計算過程がデータ化されることにより、積算対象の性質が類似する場合、計算過程を表わす数量入力表を取り出し、数量計算入力データ等を修正するだけで流用することができ、数量の算出に関わる作業の効率化を図ることができる。
【００４２】
さらに、単価表の集合体である積算設計書データを一元管理することにより、数量入力の転写ミスがなくなり、かつ、管理データの散在を防ぐことができる。
【００４３】
さらに、数量決定の過程データが保存されているので、必要な第３者が積算の正当性をチェックでき、積算上のミス、不正を未然に回避できる。
【００４４】
さらに、積算対象の性質が類似する場合、所要とする数量入力表を取り出し、修正、流用を図ることができ、非常に融通性に富んだものとすることが出来る。
【００４５】
なお、算出される数量の数量過程が長文化する場合がありうるが、積算項目名称に含む個別の計算対象，例えば図４において「壁１」、「壁２」、「壁３」だけを書込み、これら各壁にリンクするように各壁の計算過程を別に格納する構成であってもよい。
【００４６】
その他、本願発明は、上記実施の形態に限定されるものでなく、その要旨を逸脱しない範囲で種々変形して実施できる。例えば積算処理装置２ａ，２ｂ，…，２ｎは、全てのプログラムを保有し、マスタデータベース３１の積算基準となる単価表作成用データを参照し、単価表を作成したが、例えばマスタデータベース３１がネットワークなしで積算処理装置２ａ，２ｂ，…，２ｎに保有されているスタンドアロン形式の構成であってもよい。
【００４７】
また、各実施の形態は可能な限り組み合わせて実施することが可能であり、その場合には組み合わせによる効果が得られる。さらに、上記各実施の形態には種々の上位，下位段階の発明が含まれており、開示された複数の構成要素の適宜な組み合わせにより種々の発明が抽出され得るものである。例えば問題点を解決するための手段に記載される全構成要件から幾つかの構成要件が省略されうることで発明が抽出された場合には、その抽出された発明を実施する場合には省略部分が周知慣用技術で適宜補われるものである。
【００４８】
【発明の効果】
以上説明したように本発明によれば、数量計算過程を含んで積算に関連するデータ全体を一元管理でき、他の単価表作成時に数量計算過程を有効活用することにより、単価表作成作業の効率化を図ることができ、また積算内容の正当性を容易にチェックできる積算処理システム、積算処理装置及びプログラムを提供できる。
【図面の簡単な説明】
【図１】本発明に係る積算処理システムの一実施の形態を示す系統構成図。
【図２】図１に示す積算処理装置の一具体例を説明する機能構成図。
【図３】本発明に係わる積算処理装置の動作およびプログラムによる一連の処理を説明するフローチャート。
【図４】本発明に係る積算処理装置のさらに詳細な具体例を説明する機能構成図。
【図５】計算過程を計算式に変換する場合のデータ変換内容を説明する図。
【図６】従来の積算処理装置の説明する機能構成図。
【符号の説明】
１…ネットワーク
２ａ，２ｂ，…，２ｎ…積算処理装置
３…サーバ装置
１１ａ，１１ｂ，…，１１ｎ…入力手段
１２ａ，１２ｂ，…，１２ｎ…出力手段
１３ａ，１３ｂ，…，１３ｎ…記録媒体
１４ａ，１４ｂ，…，１４ｎ…データ一時記憶手段
１５ａ，１５ｂ，…，１５ｎ…積算処理制御部
３１…マスタデータベース
１５１…単価表作成手段
１５２…数量計算入力手段
１５３…数量入力表生成手段[0001]
TECHNICAL FIELD OF THE INVENTION
The present invention relates to an integration processing system, an integration processing device, and a program that support various integration tasks.
[0002]
[Prior art]
Several types of integration processing are considered for this type of integration processing system.
[0003]
In one of the integration processing modes, the components and unit prices of the unit price table serving as the integration reference are accumulated in the master database in advance, and when the unit price table is created, the components and unit prices of the unit table in the master database are referred to and the unit price table is added. The necessary constituent elements are appropriately selected, and a unit price table (a unit of labor, machine, material unit × quantity = amount of money) is automatically created as a detail of the cost. Regarding the quantity of each component, the quantity result is calculated by the unit price table creator and the estimator using any tool (calculator, spreadsheet software) based on the know-how of the business to be added. ing.
[0004]
More specifically, assuming that the object to be integrated is “painting of a certain building” as shown in FIG. In addition to (base adjustment, undercoating, middle coat, topcoat,...), Data such as standards, units, and unit prices required for unit price table creation are defined. However, when creating unit price tables, quantities are required. To calculate the quantity, the unit price table creator or the estimator calculates the area of each wall using the calculator 52 and the spreadsheet software 53, and further sums up the total painting area obtained by adding up a plurality of wall areas. The quantity result 54, which is the area of the coating type, is determined.
[0005]
Then, after outputting the area quantity result 54 for each coating type, the unit price table creation function of the integration processing device 55 selects the coating type, which is each integration item related to the coating of the building as the integration reference, from the master database 51, A standard, a unit, and a unit price corresponding to the coating type are taken out, a quantity determined by the calculator 52 and the spreadsheet software 53 is input, and an amount is calculated based on the quantity and the unit price to create a unit price table. The information is recorded in the master database or other storage means 56. Therefore, after the unit price table is created, the quantity data is stored in the storage unit, but the calculation process of “quantity” is not recorded in the unit price table record.
[0006]
Another one of the integration processing forms is provided with an integration calculation file in which the integration item name, quantity, quantity calculation formula, unit price, and amount of money relating to the building are input via an integration detail master. This is a mode in which the quantity is automatically calculated by each quantity calculation formula for each name and the quantity data of the file is updated (for example, see Patent Document 1).
[0007]
[Patent Document 1]
JP-A-2002-49657.
[0008]
[Problems to be solved by the invention]
However, in the former estimation processing, the calculation process of the quantity is not recorded, and the basis for calculating the quantity is based solely on the know-how of the estimator. It is necessary to perform calculations, and there is a problem that the contents of quantity calculation such as a predecessor cannot be effectively used.
[0009]
In addition, the accumulated design document data, which is a set of unit price tables relating to a large number of building works, is stored in the storage means 56. There is an inconvenience that you can not check for other things.
[0010]
On the other hand, in the latter integration processing form, the quantity calculation formula is determined in advance for each integration item name, but there is a problem in that the details of detailed work for each integration item name cannot be seen, and an appropriate integration specification cannot be created. .
[0011]
Also, in general, when various optional items are entered in response to a user's request during construction work, it is necessary to construct a calculation formula in software each time, and there is a problem of lack of flexibility. .
[0012]
The present invention has been made in view of the above circumstances, and centrally manages all data related to integration including the quantity calculation process, effectively utilizes the quantity calculation process when creating another unit price table, and furthermore, the efficiency of the unit price table creation work. It is an object of the present invention to provide an integration processing system, an integration processing device, and a program that can easily check the validity of the integration content.
[0013]
[Means for Solving the Problems]
(1) In order to solve the above problem, an integration processing system according to the present invention is an integration processing system in which a plurality of integration processing devices and a server device are connected through a network,
The preceding server device is provided with first storage means for storing various data such as an integration item name relating to a unit price table serving as an integration reference, a unit required for creating the unit price table, a unit price, and the like. In response, transmit various data corresponding to the integration item name,
Each of the multiplication processing devices includes a unit price table creation screen required to create the unit price table, a second storage unit that stores a calculator-type calculation process input screen, and the second unit for creating the unit price table. The unit price table creation screen is read out from the storage unit and displayed, and data such as a unit and a unit price corresponding to each integration item name relating to the unit price table is acquired from the first storage unit of the server device, and the unit price table creation screen is displayed. Based on the unit price table creation means to be written and the input of the quantity calculation input instruction, the calculation process input screen is read out from the second storage means and displayed, and the quantity calculation input data is input to the calculation process input screen. A quantity calculation process is performed using the calculation input data and the unit price, and the quantity and calculation process of the calculation process result are written in the quantity area of the unit price table creation screen and stored in the second storage means. Means, a quantity input table generating means for generating a quantity input table screen using the calculation process obtained by the quantity calculation input means and storing it in the second storage means; Based on the quantity input table menu screen stored in advance, the quantity input table screen similar to the accumulation target is read out, the quantity calculation input data and the like of the quantity input table screen are corrected, and the quantity area of the unit price table creation screen is corrected. Means for writing the number of processing results and the calculation process and storing the same in the second storage means.
[0014]
With the above-described configuration of the present invention, each of the multiplication processing devices can add, to the unit price table creation screen, each integration item name relating to the unit price table stored in the first storage unit of the server device when the unit price table is created. The data of the corresponding unit, unit price and the like are taken out and written, and a calculator type calculation process input screen is displayed for the quantity area of the unit price table, and the quantity calculation input data is sequentially input from this screen. As a result, the quantity calculation process is executed using the input quantity calculation input data and the unit price on the screen, and the quantity of the calculation result and the calculation process are written in the quantity area of the unit price table creation screen. It is possible to save the related calculation process as a history.
[0015]
In addition, each integration processing device generates and stores a quantity input table screen using a calculation process, but when an instruction such as correction / diversion is received, based on a previously stored quantity input table menu screen, the integration target is set as an integration target. A similar quantity input table screen is read out, the quantity calculation input data on the quantity input table screen is corrected, and the quantity and calculation process of the correction processing result are written and stored in the quantity area of the unit price table creation screen. Work can be performed efficiently.
[0016]
Note that the above configuration is a configuration related to the integration processing system, but the above-described configuration of each integration processing device may be provided in the server device itself, or when the server device or each integration processing device is a computer, A series of unit price table creation processes can also be realized by a program.
[0017]
BEST MODE FOR CARRYING OUT THE INVENTION
Hereinafter, embodiments of the present invention will be described with reference to the drawings.
[0018]
FIG. 1 is a configuration diagram showing an embodiment of the integration processing system according to the present invention.
[0019]
The integration processing system is provided with a network 1 such as an in-house network such as a LAN and a dedicated line. The network 1 has integration processing devices 2a, 2b,. , 2n, and a server device 3 that integrally manages data relating to an integration item name, a standard, a unit, a unit price, and the like as an integration reference. .., 2n are performed by the integration processing devices 2a, 2b,..., 2n. However, when the server device 3 has the functions of the integration processing devices 2a, 2b,. It may be performed on the server device 3 side.
[0020]
The server device 3 is provided with a master database 31 for centrally managing data on an integration item name, a standard, a unit, a unit price, and the like, which serve as an integration reference.
[0021]
Each of the integration processing devices 2a, 2b,..., 2n is provided with a keyboard, a pointing device, and the like for inputting necessary data, control instructions, and other necessary instructions by an integration clerk who creates a unit price table and other business personnel in the relevant department. , 11n, a display section for displaying a screen related to the unit price table creation processing, output means 12a, 12b, ..., 12n such as a printer, and all programs necessary for the integration processing are recorded. , 13n (the recording media 13b,..., 13n are omitted in the drawing), a unit price table input screen 21, a calculator type input calculation process input screen 22, and a quantity input table screen 23. During processing related to table creation, temporary storage of processed data and necessary data read from the master database 31 is required, or quantity calculation input data is required. , 14n for storing a data conversion table or the like to be converted into data, and temporary data storage means 14a, 14b,..., Based on control instructions from input means 11a, 11b,. 14n, a unit price table creation screen is read out and displayed, and in addition to creation of a unit price table as a cost detail, processing such as a history saving process of a calculation process by a quantity calculation input which is one component of the unit price table and a process of generating a quantity input table are performed. , And 15n, which are integrated control processing units 15a, 15b,..., 15n, which integrally manage the integrated design document data, which is an aggregate of unit price tables. Note that each of the screens 21 to 23 and the like may be stored in a storage unit dedicated to screen data or in a recording medium 13a, 13b,..., 13n. However, for the sake of convenience, the data temporary storage units 14a, 14b,. 14n will be described.
[0022]
As the recording media 13a, 13b,..., 13n, a CD-ROM, a HDD, or the like is generally used, but other than that, for example, a magnetic tape, a DVD-ROM, a floppy disk, an MO, a CD-R, A memory card or the like may be used.
[0023]
The integration control processing units 15a, (15b, ..., 15n) of the integration processing device 2a (2b, ..., 2n) will be described. Since the integration control processing units 15a, 15b,..., 15n have the same configuration, the integration control processing unit 15a will be described below, and the other 15b,.
[0024]
That is, as shown in FIG. 2, the integration control processing unit 15a of the integration processing device 2a reads and displays the unit price table creation screen 21 from the data temporary storage unit 14a based on the unit price table creation instruction input from the input unit 11a. Then, field data (data such as standard, unit, etc.) corresponding to each integration item name required for the unit price table serving as an integration reference is read from the master database 31 of the server device 3 to create a unit price table. In response to the input of the quantity calculation input instruction input from the input means 11a, the calculation process input screen 22 in the calculator input format is displayed from the data temporary storage means 14a, and the quantity calculation input data is input using a normal calculator image. A quantity calculation input means 152 for writing the quantity and the calculation process as the calculation result into the quantity area which is a component of the unit price table; Quantity input generation unit 153 for generating the quantity input table screen 23 using the quantity calculated input data by stage 152 is provided.
[0025]
Therefore, with respect to, for example, the painting of a certain building, the integration processing device 2a simply reads out the data such as the integration item name, standard, and unit from the master database 31 as the integration reference, and the integration processing apparatus 2a calculates the quantity and the quantity. Processes, unit prices can be stored as details of costs having unit price table records consisting of amounts calculated from the quantities and unit prices, and a third party can easily check the validity of the basis for determining the quantity. .
[0026]
In the above description, the configuration of each integration processing device 2a, 2b,..., 2n has been described, but the same means 151 to 153 are provided on the server device 3 side, and the screen 21 necessary for the master database 31 and the like is provided. If the server device 3 is stored, the server device 3 can execute the same processing.
[0027]
Next, an example in which the operation of the integration processing apparatus and the integration control processing unit 15a reads the unit price table creation processing program from the recording medium 13a and executes a series of processing will be described with reference to FIGS.
[0028]
First, the integration control processing unit 15a executes the unit price table creation unit 151. The unit price table creation unit 151 determines whether a unit price table creation instruction has been input from the input unit 11a (S1). If it is determined that the creation instruction has been input, the data temporary storage unit 14a returns to FIG. The unit price table creation screen 21 shown is read and displayed on, for example, a display unit, which is one of the output means 12a (S2).
[0029]
After displaying the unit price table creation screen 21, the person in charge of accumulation sequentially selects the accumulation item names necessary for accumulation from the master database 31, and the standard, unit, unit price, etc. corresponding to each selected accumulation item object. Is automatically taken out and displayed in the corresponding area of the screen (S3). These steps S1 to S3 correspond to a unit price table creation function. Therefore, at this stage, only the quantity input area and the price area which are the quantity input fields are blank.
[0030]
Subsequently, the integration control processing unit 15a determines whether or not there is a quantity calculation input instruction by, for example, a mouse operation which is one form of the input unit 11a according to a predetermined rule (S4). It is determined that the quantity input mode is the same, and if there is an instruction input, the original quantity calculation input means 152 is activated. That is, here, the calculator-type calculation process input screen 22 is read from the data temporary storage means 14a and is displayed on the output means 12a as a window (S5). After displaying the calculation process input screen 22, it is determined whether or not there is a display instruction of the quantity input table (S6).
[0031]
Here, if it is determined that there is no display instruction in the quantity input table, the integrator or the like sequentially inputs the quantity calculation input data with the calculator image on the calculation process input screen 22 by operating the mouse (S7). Execute (S8). Since the calculation is often performed on a plurality of rows, the calculation is continued until the calculation is completed (S9). These steps S4 to S9 correspond to a quantity calculation input function.
[0032]
The input in the calculator format is performed on a line-by-line basis, and variables can be defined. Note that the defined variables are displayed in a combo box. If only numerical values are input, it is determined as a constant. The entered quantity calculation input data is calculated similarly to the calculator. When calculating a plurality of rows, the calculation result of one row is determined by “M +” (plus the row calculation result) or “M−” (minus the row calculation result), and the process moves to the next row.
[0033]
Then, by operating "=" on the calculation process input screen 22, the calculation result is reflected in the unit price table data as a quantity (S10). Further, the calculation process is converted into formula data, and similarly registered in unit price table data (S11, S12). These steps S10 to S12 correspond to a quantity calculation process saving function.
[0034]
When this calculation process is converted into formula data, for example, the conversion is performed based on the data conversion contents of a data conversion table stored in the data temporary storage means 14a as shown in FIG.
[0035]
Subsequently, the integration control processing unit 15a executes the quantity input table generation unit 153. The quantity input table generation means 153 generates a quantity input table from the calculation process data registered in the unit price table record (S13: quantity input table generation function). For each line data, subtotal of each line and total of all lines are calculated using variables, constants, and operators (+,-, *, ÷). A document name is assigned and stored in the data temporary storage unit 14a.
[0036]
By the way, in step S6, if there is an operation by right-clicking with a mouse, for example, it is determined that there is a display instruction of the quantity input table, and the quantity input table menu screen 24 is read from the data temporary storage means 14a and displayed on the output means 12a as a window. (S14). The quantity input table menu screen 24 is a list of quantity input tables created for each accumulation target in the past. For example, the menu identification data is represented by the accumulation target “building painting” or the like. When an integration target close to or relatively similar to the current integration target is selected from these, the quantity input table screen 23 corresponding to the quantity input table menu is read from the data temporary storage means 14a and displayed on the output means 12a. (S15). The reason for displaying the quantity input table screen 23 is to increase the work efficiency of creating a unit price table for the integration target that is close to or relatively similar to the current integration target.
[0037]
Here, if the accumulator or the like corrects the numerical value and the like of the necessary area of the quantity input table screen 23 and inputs an instruction to end the calculation (S16), the process proceeds to step S10, and the same processing as described above is executed. , Update processing is performed (S10 to S13).
[0038]
These steps S14 to S16 correspond to a quantity correction processing function.
[0039]
Therefore, by the series of processes described above, not only the quantity but also the data of the quantity calculation process can be saved, and the quantity input table is generated from the data of the quantity calculation process, so that it can be used for similar accumulation targets later. Thus, the unit price table can be efficiently created by appropriately selecting from the quantity input table menu and using it for correction.
[0040]
That is, according to the embodiment of the integration processing system, the integration processing apparatus and the program according to the present invention, not only the unit price table conventionally created but also the quantity calculated by an independent tool (calculator, spreadsheet software). The calculation process is stored in the integration processing unit 15a, so that the integrated design document data, which is an aggregate of these unit price tables, can be centrally managed, and the calculation process of the already created unit price table can be effectively utilized at the time of correction. Therefore, the efficiency of the work related to the calculation of the quantity can be improved.
[0041]
In addition, if the properties of the integration target are similar due to the calculation process being converted into data, the quantity input table representing the calculation process can be taken out, and the quantity calculation input data can be diverted simply by modifying the data. Work efficiency can be improved.
[0042]
Furthermore, by integrating management of the integrated design document data, which is a set of unit price tables, it is possible to eliminate a transfer error of the quantity input and to prevent the management data from being scattered.
[0043]
Further, since the process data of the quantity determination is stored, a required third party can check the validity of the accumulation, and can avoid mistakes and improper operations in the accumulation.
[0044]
Further, when the properties of the integration targets are similar, the required quantity input table can be taken out, corrected and diverted, and thus can be made very flexible.
[0045]
Although the quantity process of the calculated quantity may be long, the individual calculation targets included in the integration item name, for example, only “wall 1”, “wall 2”, and “wall 3” in FIG. 4 are written. Alternatively, the calculation process of each wall may be separately stored so as to link to each of these walls.
[0046]
In addition, the present invention is not limited to the above-described embodiment, and can be variously modified and implemented without departing from the gist thereof. For example, the integration processing devices 2a, 2b,..., 2n have all the programs and create unit price tables by referring to unit price table creation data serving as the integration reference of the master database 31. .., 2n, and may be a stand-alone type configuration held in the integration processing devices 2a, 2b,.
[0047]
Further, the embodiments can be implemented in combination as much as possible, and in that case, the effect of the combination can be obtained. Furthermore, each of the above embodiments includes various upper and lower stage inventions, and various inventions can be extracted by appropriately combining a plurality of disclosed components. For example, when an invention is extracted because some constituent elements can be omitted from all the constituent elements described in the means for solving the problem, if the extracted invention is implemented, the omitted part is omitted. Is appropriately supplemented by well-known conventional techniques.
[0048]
【The invention's effect】
As described above, according to the present invention, it is possible to centrally manage the entire data related to integration including the quantity calculation process, and to efficiently utilize the quantity calculation process when creating another unit price table, thereby improving the efficiency of unit price table creation work. It is possible to provide an integration processing system, an integration processing device, and a program that can easily check the validity of the integration content.
[Brief description of the drawings]
FIG. 1 is a system configuration diagram showing an embodiment of an integration processing system according to the present invention.
FIG. 2 is a functional configuration diagram illustrating a specific example of an integration processing device illustrated in FIG. 1;
FIG. 3 is a flowchart for explaining the operation of the integration processing apparatus according to the present invention and a series of processing by a program;
FIG. 4 is a functional configuration diagram illustrating a more detailed specific example of the integration processing device according to the present invention.
FIG. 5 is a view for explaining data conversion contents when a calculation process is converted into a calculation formula.
FIG. 6 is a functional configuration diagram illustrating a conventional integration processing device.
[Explanation of symbols]
1 Network 2a, 2b, ..., 2n Integration processing device 3 Server devices 11a, 11b, ..., 11n Input means 12a, 12b, ..., 12n Output means 13a, 13b, ..., 13n Recording medium 14a, 14b,..., 14n data temporary storage means 15a, 15b,..., 15n integration processing control unit 31 master database 151 unit price table creation means 152 quantity calculation input means 153 quantity input table generation means

Claims

An integration processing system in which a plurality of integration processing devices and a server device are connected through a network,
The server device is provided with first storage means for storing various data such as an integration item name relating to a unit price table serving as an integration reference, a unit and a unit price required for creating the unit price table, and a request from each of the integration processing devices. Transmits various data corresponding to the integration item name according to
Each of the multiplication processing devices includes a unit price table creation screen required to create the unit price table, a second storage unit that stores a calculator-type calculation process input screen, and the second unit for creating the unit price table. The unit price table creation screen is read out from the storage unit and displayed, and data such as a unit and a unit price corresponding to each integration item name relating to the unit price table is acquired from the first storage unit of the server device, and the unit price table creation screen is displayed. Based on the unit price table creation means to be written and the input of the quantity calculation input instruction, the calculation process input screen is read out from the second storage means and displayed, and the quantity calculation input data is input to the calculation process input screen. A quantity calculation process is performed using the calculation input data and the unit price, and the quantity and calculation process of the calculation process result are written in the quantity area of the unit price table creation screen and stored in the second storage means. Integrated processing system, characterized in that a force means.

The integration processing system according to claim 1,
The integration processing device generates a quantity input table screen using the calculation process obtained by the quantity calculation input means and stores the quantity input table screen in the second storage means. If received, the quantity input table screen similar to the accumulation target is read out based on the quantity input table menu screen stored in advance, the quantity calculation input data and the like of the quantity input table screen are corrected, and the quantity on the unit price table creation screen is corrected. Means for writing the number of correction processing results and the calculation process in the area and storing the same in the second storage means.

A unit price table creation screen required to create the unit price table, a calculator-style calculation process input screen, in addition to the integration item name and the unit and unit price required for unit price table creation related to the unit price table used as the integration standard Storage means for storing
A unit price table creation screen which is read out and displayed from the storage means, retrieves data such as a unit and a unit price corresponding to each integration item name relating to the unit price table, and writes the data into the unit price table creation screen;
Based on the input of the quantity calculation input instruction, read out and display the calculation process input screen from the storage means, input the quantity calculation input data to the calculation process input screen, execute the quantity calculation process using the unit price, An accumulation processing device comprising: a quantity calculation input means for writing the quantity of the calculation processing result and the calculation process in a quantity area of a unit price table creation screen and storing it in the storage means.

The integration processing device according to claim 3,
A quantity input table generation means for generating a quantity input table screen using the calculation process obtained by the quantity calculation input means and storing the screen in the storage means, and a quantity stored in advance when an instruction such as correction / diversion is received. Based on the input table menu screen, read out the quantity input table screen similar to the accumulation target, correct the quantity calculation input data etc. of the relevant quantity input table screen, and enter the quantity and calculation of the correction processing result in the quantity area of the unit price table creation screen. Means for writing a process and storing it in the storage means.

The integration item names related to the unit price table serving as the integration reference, various data such as the unit and unit price required for creating the unit price table, the unit price table creation screen, and the calculator type calculation process input screen are stored in advance, and the unit price table creation processing is performed. In the computer of the processing device,
A unit price table creation screen is read out from the storage means and displayed, data of unit, unit price, etc. corresponding to each integration item name relating to the unit price table is taken out, and a unit price table creation function to be written on the unit price table creation screen, and a quantity calculation Based on the input instruction input, a calculation process input screen is read out from the storage means and displayed, and a quantity calculation input function for inputting the quantity calculation input data on the calculation process input screen, and using the quantity calculation input data and the unit price, A program for executing a quantity calculation process, and realizing a quantity calculation process saving function of writing and storing the number of calculation results and the calculation process in the quantity area of the unit price table creation screen.

The program according to claim 5,
A quantity input table generation function for generating and storing a quantity input table screen using the calculation process obtained by the quantity calculation step storage function, and when receiving an instruction such as correction / reuse, based on the quantity input table menu screen. A function to read out the quantity input table screen similar to the accumulation target, correct the quantity calculation input data etc. of the quantity input table screen, and write and store the quantity of the correction processing result and the calculation process in the quantity area of the unit price table creation screen. And a program that realizes it.

The external device stores the integration item name, unit, unit price and other data required for unit price table creation, which are the unit price table used as the integration reference, and stores the unit price table creation screen and calculator-type calculation process input screen on its own computer. The computer for multiplication processing that performs unit price table creation processing
A unit price table creation function for reading and displaying the unit price table creation screen, extracting data such as a unit and a unit price corresponding to each integration item name relating to the unit price table from the external device, and writing the data into the unit price table creation screen; Based on the input instruction input, the calculation process input screen is read and displayed, and the quantity calculation input function for inputting the quantity calculation input data on the calculation process input screen, and the quantity calculation is performed using the quantity calculation input data and the unit price. A program for executing a process, and realizing a quantity calculation process saving function of writing and storing the number of calculation results and the calculation process in the quantity area of the unit price table creation screen.

The program according to claim 7,
A quantity input table generation function for generating and storing a quantity input table screen using the calculation process obtained by the quantity calculation step storage function, and when receiving an instruction such as correction / reuse, based on the quantity input table menu screen. A function to read out the quantity input table screen similar to the accumulation target, correct the quantity calculation input data etc. of the quantity input table screen, and write and store the quantity of the correction processing result and the calculation process in the quantity area of the unit price table creation screen. And a program that realizes it.