WO2002013108A1 - Material and labor cost estimating method and system - Google Patents

Material and labor cost estimating method and system Download PDF

Info

Publication number
WO2002013108A1
WO2002013108A1 PCT/US2001/024873 US0124873W WO0213108A1 WO 2002013108 A1 WO2002013108 A1 WO 2002013108A1 US 0124873 W US0124873 W US 0124873W WO 0213108 A1 WO0213108 A1 WO 0213108A1
Authority
WO
WIPO (PCT)
Prior art keywords
items
grouped items
grouped
database
data
Prior art date
Application number
PCT/US2001/024873
Other languages
French (fr)
Inventor
Dennis Duenke
Original Assignee
Murphy Company
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Murphy Company filed Critical Murphy Company
Priority to AU2001286421A priority Critical patent/AU2001286421A1/en
Publication of WO2002013108A1 publication Critical patent/WO2002013108A1/en

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q10/00Administration; Management
    • G06Q10/10Office automation; Time management
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q10/00Administration; Management
    • G06Q10/06Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q30/00Commerce
    • G06Q30/02Marketing; Price estimation or determination; Fundraising
    • G06Q30/0283Price estimation or determination

Definitions

  • the present invention generally relates to a method and system for determining the exact counts of construction hardware and associated material and labor costs for estimating construction projects. More particularly, the invention pertains to on-screen tools and instructions which walk a user through identifying construction items for a specific construction project. Once data is entered, automated procedures produce total estimated material costs, labor hours, units of measure and costs for a project.
  • Computer-based cost estimating programs have long been used in business to calculate material and labor costs for projects. They have also been used for purposes of looking up material and labor costs. Conventional models have also been expanded to be useable to track the material and labor costs of projects.
  • the advantages of such computerized programs include reduction of manual errors, a decrease in estimating turn-around time as well as extended capabilities beyond those which can be carried out on a manual or a semi-automated basis. More recent programs implement WTNDOWS-based programs using a mouse and digitized boards. WINDOWS is a registered trademark of Microsoft, Inc. (Redmond, WA).
  • Such programs make it possible to generate material and labor cost estimates for mechanical piping, electrical systems, control devices, supports and structural steel, sheet metal and insulation, fire protection systems, industrial process lines and the like. Some of these systems can also be used for scheduling of manpower and materials to build a project.
  • Programs of the prior art do not permit an individual to visually observe the location of a given piece of hardware in relation to connected hardware, equipment, or fixtures when conducting an estimate.
  • Prior art programs have displayed a standardized list of hardware quantities in tabular form that the user can manipulate to suit a customized project. The user must exercise skill in selecting components for the estimate. Errors in estimating are often easily overlooked as an estimator views a table of numbers representing the quantity of hardware that is to be used rather than graphically viewing the location of where the hardware will be installed.
  • a further object of the invention is a mechanical cost estimating method and system that provides a user with all the items required to install equipment and hook-up materials of a construction project that are grouped together as a single group and added to an estimate as a group.
  • Still another object of the present invention is a mechanical cost estimating method and system that provides a graphical user interface data entry screen in a take off sheet.
  • the present invention is directed towards a computerized method for estimating material and labor costs of a construction project.
  • the method comprises maintaining a database of items and cost data associated for the items, grouping one or more of the items to define predetermined sets of grouped items, selecting one or more of the grouped items based on the construction project, and calculating the estimated cost of the construction project based at least in part upon the cost data associated with the items in the selected set of grouped items.
  • the invention is directed to an automated material and labor cost estimating method within a computer system having a processor, a graphical user interface including a computer display, and an input device.
  • the method comprises maintaining a database of items and cost data associated with the items.
  • the present invention is directed to an automated system for estimating a cost of selected equipment for a construction project.
  • the system comprises a first database containing construction items and material and labor cost data associated with the construction items and a second database containing predetermined sets of grouped items corresponding to a desired installation of the grouped items in the construction project.
  • a computer executes a cost estimating software program that accesses the second database and provides a cost estimate of the construction project based at least in part upon the selected grouped items data.
  • the present invention is directed to a computerized system for estimating the material and labor costs of a construction project.
  • the system comprises a remote server on a communications network managing software programs and databases, a central database associated with the remote server storing construction material specifications and graphics, labor cost data, and material prices, and a local computer on a communications network.
  • the local computer executes an estimating software program and accessing data from the central database and generating material and labor costs for the construction project.
  • Figure 1 is a block diagram invention of a mechanical cost estimating system according to a preferred embodiment of the invention.
  • Figure 2 is a block diagram illustrating interrelationships between data entry, data entry screens, material databases, and reports databases used by the system of Figure 1.
  • Figure 3 is an exemplary flowchart illustrating data entry operations of the system of
  • Figure 4 is an illustration of an exemplary Copy Down Utility user interface according to a preferred embodiment of the present invention.
  • Figure 5 is an illustration of an exemplary Take Off Sheet data entry user interface according to a preferred embodiment of the present invention.
  • Figure 6 is an illustration of an exemplary item drop-down user interface for selecting an item according to a preferred embodiment of the present invention.
  • Figure 7 is an illustration of an exemplary window user interface displaying a graphical representation of an item selected from a Take Off Sheet and "Next Step Messages.”
  • Figure 8 is an illustration of an exemplary "Pick a Starting Size" window user interface according to a preferred embodiment of the present invention.
  • Figure 9 is an illustration of an exemplary window user interface showing "size buttons" according to a preferred embodiment of the present invention.
  • Figure 10 is an illustration of an exemplary calculator window user interface according to a preferred embodiment of the present invention.
  • Figure 11 is an illustration of an exemplary pipe material and labor calculator window user interface according to a preferred embodiment of the present invention.
  • Figure 12 is an illustration of an exemplary Typical list drop-down list user interface according to a preferred embodiment of the present invention.
  • Figure 13 is an illustration an exemplary HNAC "Typical" being created in the Typical Image and Attribute Builder according to a preferred embodiment of the present invention.
  • Figure 14 is an illustration an exemplary "Options" window user interface according to a preferred embodiment of the present invention.
  • Figure 15 is an illustration an exemplary plumbing "Typical" being created in the Typical Image and Attribute Builder according to a preferred embodiment of the present invention.
  • Figure 16 is an illustration an exemplary coupled HNAC "Typical" being created in the Typical Coupling Creator according to a preferred embodiment of the present invention.
  • Figure 17 is an illustration an exemplary coupled plumbing "Typical" being created in the Typical Coupling Creator according to a preferred embodiment of the present invention.
  • Figure 18 is an illustration an exemplary HNAC "Typical" in a Typical Builder Items screen according to a preferred embodiment of the present invention.
  • Figure 19 is an illustration an exemplary item drop-down box user interface according to a preferred embodiment of the present invention.
  • Figure 20 is an illustration of an exemplary "Replace Utility” user interface in accordance with the present invention according to a preferred embodiment of the present invention.
  • Figure 21 is an illustration of an exemplary "Print Utility Screen” user interface in accordance with the present invention according to a preferred embodiment of the present invention.
  • Figure 22 is an illustration of an exemplary "Updatable Grid” user interface in accordance with the present invention according to a preferred embodiment of the present invention.
  • the present invention provides systems and methods that assist in determining the amount of labor and material to produce an estimate for construction projects.
  • the present invention overcomes the learning difficulties of the prior art by providing a data entry screen which looks similar to a manual take off sheet used in construction estimating, but which is linked to a database and utilizes step by step messages to help the user remember how to use the program.
  • the present invention incorporates features to speed up data entry, view estimate data on a screen, compile estimate data to reports, and update databases and pricing.
  • the present invention comprises a computer, processor, display, data storage device, graphical user interface, data entry screen (e.g., the Take Off Sheet), graphical illustrations of equipment, graphical illustrations of connection hardware, a project specific database of saved estimate data, pricing databases, report programs, and a messaging feature that walks a user through data entry.
  • data entry screen e.g., the Take Off Sheet
  • FIG. 1 illustrates an exemplary physical configuration of a mechanical cost estimating system 100 embodying aspects of the present invention.
  • computer 102 such as a personal computer, workstation, notebook computer, and the like accesses computer server 104 via network 106.
  • Network 106 may be any computer network such as an intranet (e.g., a local area network, wide-area network, and the like), or a global computer network (e.g., the Internet).
  • Computer 102 may contain material and labor cost estimating software, databases for materials, pricing, reports, and other databases stored locally in its own memory, hard drive, compact disk drive, or other storage device.
  • the materials, pricing, and reports databases are updated from materials, pricing, and reports data 108 and vendor pricing data 109 accessed by server 104.
  • Materials, pricing, and reports data 108 and vendor pricing data 109 are downloaded to computer 102, via network 106, for utilization in mechanical cost estimating software.
  • computer 102 may access vendor pricing data 110 directly from vendor computer 112 via computer network 106.
  • Vendor pricing data 110 is preferably downloaded to computer 102 for utilization in mechanical cost estimating software.
  • materials, pricing, reports, and vendor data may be updated directly from a computer readable disk 114 (e.g., compact disk, magnetic diskette, etc.) containing stored estimating data that is accessed locally by computer 102.
  • Computer 102 may also alternatively use a browser to access and execute the mechanical cost estimating software located remotely on server 104 via computer network 106.
  • vendor may be updated from server 104, vendor computer 112, locally from a computer readable disk 114, or accessed directly from sever 104, as described above.
  • computer 102 executes the material and labor cost estimating software to generate material and labor cost estimate reports are generated.
  • the material and labor cost estimate reports may be output to the display screen of computer 102, to printer 116 or a remote printer via network 106, to an export file that is stored locally on computer 102 or remotely on server 104, or sent directly to customer 118, via network 106, in the form of a computer file, an email, facsimile, and the like.
  • Fig. 2 is a block diagram illustrating the interrelationships between data entry, data entry screens, material databases, and reports databases for a preferred embodiment of the present invention.
  • the present invention shows a graphical user interface that includes a data entry screen.
  • an estimating take off sheet data entry screen 202 (hereinafter referred to as "Take Off Sheet”) is supplied data by user defined descriptions 204, input device 208, stored Take Off Sheets 210, material, labor, and pricing databases 206, calculator and size windows 212, Typical Builder Items 214, Typical Image and Attributes Builder 216, and Typical Component Coupler 216.
  • User defined descriptions 204 comprises systems and materials definitions, item images, and item groups set up by a user for a project being estimated.
  • Take Off Sheet 202 also provides function buttons, boxes, and menus which permit a user to manipulate data and calculate estimates such as multiply quantities, show messages, calculate buttons and boxes and the like.
  • Input device 206 comprises a computer mouse, roller ball, trackpad, pointer, digitizer, touch screen, and the like.
  • Stored takeoff sheets 208 comprise previous takeoff sheets created and saved to estimating database 218.
  • Material, labor, and pricing databases 210 comprise material specification, material cost, labor cost, vendor pricing databases and the like utilized to identify the specifications and material and labor costs associated with an item used or installed in a construction project.
  • An item may be selected from material, labor, and pricing databases 210 by utilizing computer pull-down menus provided by Take Off Sheet 202.
  • Calculator and size buttons 212 comprise graphical user interface windows displayed on a computer screen from which numerical quantities and sizes may be entered onto Take Off Sheet 202. Calculator and size buttons 212 also access information from material, labor, and pricing databases 210 which identify whether a specific item is available.
  • Typicals Database 214 contains saved groups of items and quantities of items (hereinafter referred to as "Typicals") that are represented by graphical images of fixtures or equipment and associated hook-up material (pipes, ductwork, connectors, electrical wiring, etc.) that connect the fixtures or equipment to a main line.
  • Typicals constitute predetermined sets of grouped items corresponding to a desired combination or installation wherein the items include fixtures, equipment and associated hook-up material.
  • the saved Typicals may be accessed later and entered into Take Off Sheet 202.
  • Typical Image and Attributes Builder 215 is a computer application that permits a user to create Typicals and enter the groups of items and item quantities defined in a Typical directly to Take Off Sheet 202 or alternatively, save the Typicals to Typical Database 214.
  • Typical Component Coupler 216 connects Typicals together that were defined by Typical Image and Attributes Builder 215 or modified by Typical Builder Items 217 and sizes the coupling connections according to information in building code databases and available item sizes in size databases.
  • Typical Builder Items 217 modifies items and/or item quantities in Typicals defined by Typical Image and Attributes Builder 215 or Typical Component Coupler 216 and enters the modified Typicals directly to Take Off Sheet 202 or alternatively, saves the Typicals to Typical Database 214.
  • Typical Database 214 Once data has been entered onto Take Off Sheet 202, the information is manipulated according to a specific construction project estimate and saved to estimating database 218 as a specific takeoff sheet record. Estimating database 218 also accesses information from materials and labor databases 220 which, in turn receives pricing data from vendor databases 222.
  • Materials and labor databases provide estimating database 218 with specific material and labor units associated with items used in a construction project. When a project is calculated, material and labor units are associated with all items for a sheet or group of sheets, are totaled, and cost estimates are calculated. The cost estimates are formatted on a report form from reports database 224 and output to output devices 226. Output devices 226 may include any form of output device used to view or access a report, including a printer, a display screen, an export file, email, facsimile, and the like.
  • Fig.3 is an overview flowchart of the mechanical cost estimating process.
  • the process begins at step 302 with the execution of a file updating program (hereinafter referred to as the "Copy Down Utility") which keeps track of all the programs, reports, and files associated with the program.
  • the Copy Down Utility compares the master databases and files that are present on server 104, CDROM, or other storage device with local databases such as the vendor pricing, materials, project, take off, reports and other files and databases stored locally on computer 102 and determines whether the local files are up to date. If any local file is not current, the user may replace the older local file with the newer file from server 104, CDROM, or other storage device.
  • the program compares all the dates and times of each local file accessed by computer 102 to the files on server 104.
  • the Copy Down Utility at step 304 identifies which local databases or files are not current with the databases or files residing on server 104.
  • the user is given a choice whether to download the databases which are not current.
  • An exemplary Copy Down Utility screen is illustrated in Fig. 4. In addition to maintaining all the files associated with the estimating program, the
  • Copy Down Utility may itself be periodically updated and maintained through the estimating program from the file menu.
  • a text message and instructions may be displayed indicating that the Copy Down Utility program is not current and needs to be updated.
  • the estimation program is executed.
  • the user is asked whether they want to work on a new project, an existing project, or the last project on which the user worked.
  • the user selects the desired project option.
  • the user selects to use a "database format" or a "Take Off Sheet” format for inputting estimate data. If the database format is selected, at step 312, the user enters data directly into estimating database 218. If the Take Off Sheet format is selected, at step 314, a Take Off Sheet data entry screen, as illustrated in Fig. 5, is displayed on the screen of computer 102.
  • the Take Off Sheet contains rows of items and columns of either item sizes or item reducing sizes.
  • a data cell exists at each column and row intersection wherein a quantity value corresponding to the quantity of items of a given size or reducing size is entered.
  • the default Take Off Sheet may be blank, it may be the last sheet the user was estimating, or it may be some other default sheet.
  • the user selects the desired Take Off Sheet for data entry.
  • Next Step Messages are optionally displayed on top of the Take Off Sheet entry screen.
  • the Next Step Messages point to an entry cell or button that would be the next logical step where data should be entered or an activity performed and also displays a message describing what the nature of the next step should be.
  • the Next Step Messages may be optionally disabled.
  • the Take Off Sheet is checked to determine whether it is locked or unlocked at step 316.
  • Take Off Sheets may be locked once they have been saved to prevent inadvertent overwriting of data. If the sheet is locked, at step 318 the system warns the user that entry of data will overwrite existing data on the Take Off Sheet and asks whether the user wants to overwrite the data, and thereby unlock the sheet. If the user chooses to overwrite the data, the process proceeds to step 320. If the user does not want to overwrite the data, the user may select a different Take Off Sheet at step 322 from the database and the process proceeds to step 316.
  • the user may enter project identification data such as project name, project number, drawing number, system, material, building, Take Off Sheet number, Take Off Sheet revision number, and the like.
  • This information may be preset in a database which can be selected by the user from a computer drop-down box, automatically completed upon entry of the first few characters of typed data, manually typed in its entirety into the data box, and the like.
  • the project identification information is utilized by the program to save the individual Take Off Sheet as well as group the Take Off Sheet with related projects for estimating the costs for an entire project of several systems.
  • a system identifies the type of system being estimated such as chilled water, hot water, domestic water, sanitary waste and vent, electrical system, process systems, high pressure supply air, or other system to be installed.
  • Several types of materials may be required for the installation of each system, such as carbon steel, carbon steel, copper, stainless steel or other type of pipe or conduit material.
  • step 322 specific items such as a pipe, elbow, coupling and the like may be entered and the corresponding size(s) and quantity or quantities may be entered into data cells of the Take Off Sheet that are required for the project being estimated.
  • Take Off Sheet item text boxes and data cells may be selected by highlighting, clicking a mouse button, and so forth to bring up either a hardware item selection list, item size buttons, or a calculator to perform arithmetic operations or preset numbers to enter quantities into the Take Off Sheet data cells that are highlighted.
  • the user can also enter data by obtaining information from a previous Take Off Sheet or by getting information from the last Take Off Sheet that was saved to memory.
  • Items may be selected from a drop-down box of pre-defined items, by an autocomplete text entry method, typed in manually, or the like. To reduce errors in item selection and ensure accurate estimations, it is preferred that the user select the item from a predefined list.
  • An example of a drop-down list of items is illustrated in Fig. 6. If a system and material have been loaded into supporting databases, once a specific system and material have been entered onto the Take Off Sheet, the program can pre-load the Take Off Sheet with predefined items and the sizes and quantities of the items that are commonly used for the system or have been specifically selected for the particular project being estimated.
  • Each item also may have materials or requirements information associated with it that can be included automatically in the estimate when it is finally calculated, such as required joining materials, welds, hangers, supports, couplings, or any other material or item in the databases.
  • materials or requirements information associated with it that can be included automatically in the estimate when it is finally calculated, such as required joining materials, welds, hangers, supports, couplings, or any other material or item in the databases.
  • a box adjacent to the item column may be depressed to display a picture of the item on the screen (See box immediately to the left of each item row, Fig. 5) and can also include dimensions and physical data associated with the item. An example of such a picture is illustrated in Fig. 7.
  • the user may enter the quantities of items needed according to the size of each.
  • various sizes associated with a given item may be presented in column headings of the Take Off Sheet as illustrated in Fig 5.
  • the sizes may be listed across the columns in incremental order, in varying sizes, or some other order.
  • the user may select a starting size from which the size columns incrementally increase by selecting a starting size button from the "Pick a Starting Size" window which can be defined by the user. An example of this is illustrated in Fig. 8.
  • a specific column size may also be edited by clicking on the column size cell and entering a new size by manually typing the new size or by selecting the new size from a size window.
  • An alternative means to manually entering the sizes is through a size window in which the user can select pre-determined sizes by simply depressing a size button on the size window to assign a size to a column of the Take Off Sheet, or pick a size from a size list.
  • the size window is illustrated in Fig. 9.
  • Another feature of the size buttons is the ability to see what sizes are available for a certain item picked when an "Available Sizes" button is selected and show what sizes exist in pricing databases. This helps the user know whether an item is in the pricing databases.
  • Non- manufactured sizes may be pre-defined for each defined item listed such that a data entry cell corresponding to a non-manufactured item size can be "blacked-out" on the Take Off Sheet. The "blacked-out" cells thereby aid the user in avoiding selecting unavailable item sizes in an estimate.
  • Pre-loaded size and quantity values for listed items may be edited as required. If the item quantity values entered by the user or pre-loaded by the program are not desired, the user can remove all quantities by using a "clear all quantities” button. Similarly, if only a single column of sizes or row of items is desired to be cleared, a clear button adjacent to the column or row (as illustrated by the "C” button on Fig. 5) may be pressed to clear the information from the Take Off Sheet. Furthermore, as all quantities except for the length of pipe may often need to be revised, the "-P" button at the bottom of each column may be pressed to clear all quantities except for those pre-loaded for the pipe.
  • a user may utilize a calculator to select quantities into the Take Off Sheet by depressing a button having a predetermined number, manually enter a specific number, or calculate quantities and enter the quantities into a data cell. Additionally, a selected quantity may be manipulated by the arithmetic functions thereby permitting the user to easily increase the estimated quantities for multiple systems by adding or multiplying the quantities or decreasing the quantities through subtraction and division function buttons. If a quantity is already listed on the Take Off Sheet and the user simply wants to add a quantity to the listed number, the "accumulate numbers" function may be selected on the calculator in order to add the listed quantity with the additional quantity selected by the user on the calculator.
  • a single quantity may also be entered into multiple data cells by selecting a multiple cells check box on the calculator and then selecting any quantity of data cells in the Take Off Sheet format input screen. As a quantity data cell is selected, the value selected on the calculator is entered into or added to the quantity data cells until the multiple cells feature is unchecked.
  • the calculator is illustrated in Fig. 10.
  • Another feature of the Take Off Sheet format is a Piping Calculator that allows the user to mouse click on any data cell on the Take Off Sheet input screen and calculate the material and labor using pricing databases.
  • the piping calculator is illustrated in Fig. 11.
  • Typicals are groups of items that are combined to attach a system to the main lines of construction (e.g., HNAC systems, electrical systems, piping systems, electrical systems, control devices, supports and structural steel systems, sheet metal and insulation systems, fire protection systems, industrial process systems, etc.).
  • Typicals include fixtures, equipment, or structural steel supports and all of the associated hook-up materials necessary to attach the fixtures or equipment to the main line (e.g., piping, connectors, elbows, valves, reducers, electrical wiring, etc.).
  • fixtures or equipment examples include HNAC equipment, chillers, hot-water heaters, structural steel supports and the like.
  • the Typicals can be viewed by a user by selecting the desired Typical from a Typicals pull-down box which then displays the Typical on the screen as illustrated in Fig. 12. By viewing the Typical on the screen, the user can accurately identify and select the correct Typical fixture or equipment that is to be installed in the system. When a Typical is selected, the items and their quantities are entered on the Take Off
  • a selected Typical may be predefined to include all the required hook up connections and lines to attach the Typical to the main lines of construction which can be added to the Take Off Sheet in one step. For example, in Fig. 12, if a "1-14 inch-2-way 1- high coil" is needed in the installation of a commercial/institutional HNAC system, the Typical may be selected from the list of pre-defined Typicals. All the connections, including the equipment, lines, etc.
  • Typical items may also be defined such that the associated materials or requirements such as joining materials, required welds, hangers, supports and any other data associated with the item are automatically added to the estimate when it is calculated.
  • the method of estimating pipe and fittings of the present invention is unique in that it graphically represents the equipment or fixture and associated hook-up materials and saves the graphic with all the information for a particular project.
  • the user can also scroll through all the Typicals he has entered and saved for a particular project by using a data scroll or find button.
  • the find button allows the user to look for Typicals by identification number and other searching parameters based on what has been input into the other text boxes. Saved Typicals may be retrieved and used as a template containing standardized sizes of hardware for Typicals that are repeated in projects, and quantities can be modified to adapt to each project's requirements.
  • the required items and their quantities for a Typical may be created and saved as a pre-defined Typical for use in later estimates and/or be directly added to a Take Off Sheet in the same manner as previously described for adding pre-defined Typicals to a Take Off Sheet.
  • a Typical may be an HNAC Typical, plumbing chase Typical, electrical Typical, structural steel support, or any other piece of equipment or fixture installed in construction projects as described in the Typical Builder Application section below.
  • step 326 the user instructs the program to save the information at step 326.
  • step 328 the data entered is checked to determine whether the minimum required data fields were completed. If the minimum data fields were not completed, at step 330 the user is required to complete the minimum fields. The process loops back to step 328 to verify if all of the required data fields were entered. If all required data fields have been completed, the process proceeds to step 332 wherein the information is stored to memory such as estimating database 218 and project specific databases. The information may be stored to local memory such as a hard drive, diskette, compact disk, or other local storage medium, or stored to remote memory such as a remote server database.
  • step 334 it is determined whether the user wants to calculate an estimate for the input data. If the user selects to calculate an estimate, the data entered on the Take Off Sheet (i.e., the selected items and their quantities) and the materials or requirements associated with the selected items such as joining materials, required welds, hangers, supports and any other data associated with an item are totaled.
  • the material and labor costs and other information are retrieved from pricing databases and a cost estimate is produced at step 338. Factors such as projects scheduled to start in the future may also be used to adjust the cost estimate (e.g., material costs for projects scheduled in the future may be estimated to cost more than if they were scheduled to begin immediately). Thus, the user may manipulate project dates to revise factors such as material and labor cost escalation factors.
  • step 340 it is determined whether a report is to be created for the calculated estimate. If no report is to be created, the process proceeds to step 346. If the user wishes to create a report, at step 342, the user selects a report from a list of pre-defined reports and selects whether the report should be printed to screen, to a printer, to a file, or to another output device. Tracking fields, such as drawing number, system number and so forth, may be used to allow reports to be generated and data to be grouped together. Once a user selects a report, a print utility permits the user to further define reporting criteria by a tracking field, such as an individual drawing number, building, etc. User defined reports may be created or saved to the reports database. At step 344, the selected report is created.
  • Tracking fields such as drawing number, system number and so forth
  • the reports may be sent to an output device such as a printer, a computer display screen, an export file, and the like.
  • the reports may also be saved to a database. Additionally, reports may be electronically sent over network 106 to customer 118 via export files, email, facsimile, and so forth. The process proceeds to step 346.
  • step 346 if additional data is to be entered, the process loops back to step 315, otherwise, if no other data is to be entered, the estimating file may be saved to storage device as an individual file and process ends at step 348.
  • the Take Off Sheet entry screen provides a user with a number of options in preparing an estimate in addition to those briefly described above. Some of these options, as illustrated in Fig.5, include but are not limited to:
  • a "Get Info from Previous Sheet” button feature will copy all the information from the last saved sheet as in step (b) above, or will get all the information saved to memory as in step (d) below and copy that information into the current Take Off Sheet input screen.
  • a "Copy Info Shown for Next Sheet” button feature will save the information on the current Take Off Sheet to memory and allow the user to utilize the information for another sheet.
  • a "Calculate This Project” button feature will perform several procedural steps at once. If the "Automatically Count Joints" option is checked, the program will insert related items, such as welds for welded pipe and gaskets, fittings, and so forth into estimating database 218.
  • Other items such as pipe, fittings, valves can be set up by the user to count and insert other items into the estimating database of the project specific database. For example, some such items can be counted and inserted when a related item is selected (e.g., 2 flanges, 2 bolt and gasket sets, and 2 welds can be counted and inserted for every flanged valve that is found in the estimating database).
  • a related item e.g., 2 flanges, 2 bolt and gasket sets, and 2 welds can be counted and inserted for every flanged valve that is found in the estimating database.
  • a "Labor Factor” feature allows the user to apply the labor factor to all of the items on the sheet and applies that factor to the labor units at report time.
  • the Labor Factor of a project is based upon the difficulty of the construction project being estimated. A default of "1" is used by the present invention unless changed by the user. If, for example, a particular job is located in a confined area thereby increasing the difficulty of a project, the Labor Factor can be increased accordingly to estimate higher labor costs resulting from the increased labor hours required to complete the project.
  • a "Material Escalation Factor” feature allows the user to apply a material factor to all of the items on the Take Off Sheet and applies that factor to the material units at report time. If the project is anticipated to begin in the near term, the default factor of "1" is used. However, if a project estimate is being created far in advance of the actual start of the project, or if the project is anticipated to be delayed, the Material Escalation Factor may be increased (e.g., from a default of "1" to "1.2”) to reflect an increase in material costs over time.
  • a "Next Take Off Sheet” button feature brings up the next Take Off Sheet input screen to be input and copies information from the previous saved Take Off Sheet input screen as it pertains to a particular project such as the Project Name, Project Number, etc.
  • a "Multiply All Quantities By:” button feature allows the user to enter an amount in the data box to the right of this button that causes all quantities on the Take Off Sheet to be multiplied by the amount entered.
  • An "Enter Quantities Manually” check box feature allows the user to navigate around in the quantity data cells using the arrow keys, tab key and enter key rather than using a mouse-based point and click method of inputting data. Once the user is at a desired data cell, the numeric key pad can be used to enter quantities. If the user accidentally scrolls to the top, bottom, left, or right part of the quantity data cell area, an error dialog box appears and warns that the user has scrolled too far.
  • An "Automatically Count Joints" check box feature allows related items to be included in an estimate when specific items are selected based on criteria set up by the user. Thus, a gasket which is always used in connection with a flange can be automatically included in the estimate when the flange is selected. The items are then added into the estimating database and included in the total scope of the project when the "Calculate this Project" button is selected.
  • An "Automatically Count Hangers” check box feature allows hangers to be attached to piping items based on criteria set up by the software administrator. These hangers are then added into the estimating database and included in the total scope of the project when the "Calculate this Project" button is selected.
  • a "Pipe Calculator Mode On/Off check box feature allows the user to look up material units and labor units for any item selected in the Take Off Sheet and perform calculations on that selected item.
  • the present invention also includes a method to generate Typicals that may be added to a Take Off Sheet during an estimate.
  • a Typical is a group of items and item quantities that are required to completely install a system, particular piece of equipment or fixture to a main line in a construction project.
  • a main line may be a plumbing line, ventilation connection, electrical junction, and the like in a construction project.
  • installed systems or particular pieces of equipment or fixtures include, but are not limited to, chillers, hot-water heaters, plumbing fixtures, electrical heaters, industrial pumps, and the like.
  • a Typical for a hot water heater would include the items of a hot water heater, piping for providing incoming water from a main water line to the hot water heater, piping for providing outgoing, heated water to the main line, and all the valves, connectors, hangers, elbows, fittings, and the like required to completely install the Typical.
  • a Typical provides a graphical representation of the Typical connection (e.g., the schematic identifying all the parts of the Typical) to permit an estimator to accurately estimate all the pieces required for installing a complete Typical.
  • three interrelated Typical methods are utilized to aid the user in building a Typical, grouping Typicals together, and permitting the selection, use, and/or modification of pre-defined Typicals.
  • These programs include: the Typical Image and Attribute Builder, the Typical Component Coupler and Typical Builder Items.
  • the Typical Builder Items can be used by itself without sizes and length attributes or in conjunction with Typical Image and Attribute Builder or Typical Component Coupler.
  • the method relies upon a computer having a display screen, stored executable instructions, an input device and a processing unit coupled to the display screen, data storage device and the entry device.
  • Typical Image and Attribute Builder works in conjunction with the Typical
  • the Typical Image and Attribute Builder of the present invention allows a user to create and store information in a file or database which includes graphical images, text fields for dimensions and lengths of pipe, ductwork, etc. (the attributes), X and Y coordinates for the size and lineal feet data boxes, and all the items needed to install a Typical.
  • the user can define or "build" a Typical by selecting a graphical image of a particular piece of equipment or fixture that will appear on screen and identify or map the location where dimension and length data boxes are placed around or on the graphical image.
  • the graphical image is displayed on the screen after it is chosen from the pull-down box, selected from a graphical image database, scanned, or generated by the user.
  • Fig. 13 illustrates a Computer- Aided Design graphical image of a HNAC Typical being defined in the Typical Image and Attribute Builder of the present invention.
  • the fixture that is included in a plumbing Typical may be defined in the Typical Image and Attribute Builder or the Typical Component Coupler as described below.
  • Lead lines may be preferably provided on the graphical image that connect the data boxes to the piece of pipe or other item being defined.
  • the user chooses dimensions and lengths for the Typical from a size list and enters the dimension and length values of pipe, ductwork, conduit, etc. into the data boxes around the graphical image.
  • An error message may be displayed if the user tries to enter a dimension into a lineal foot data box.
  • the gage and voltage/amperage rating of electrical wiring may alternatively be entered in the data boxes.
  • the other items that are to be included for the Typical may selected from a pull-down box listing the items, by manually typing the item name, or otherwise selecting the item.
  • the sizes and quantities of the selected items are then defined for the Typical.
  • Other parameters in a Typical definition may include, but are not limited to, the quantity of how many multiples of item sizes and quantities are to be included if a Typical includes more than one group of the items and quantity of items that was just defined, an identification number, drawing number, construction area, etc.
  • the defined Typical i.e., the graphical image and associated data boxes, and other associated items and their attributes
  • the file or database may contain stored Typicals only or it may be a combined file or database containing stored Typicals and other data such as individual items, materials pricing, and the like.
  • Typicals may also be created to provide a graphical illustration of the fixture or equipment without the surrounding data boxes. In such a case, the dimensions and lengths of all the items are defined and saved to the Typical database, but are not displayed on the graphical illustration.
  • the Typical Image and Attribute Builder may also be used to build pictures of a Typical and define the requirements for fixtures and equipment.
  • piping in chases can be designed and connected to plumbing fixtures.
  • the present invention provides systems and methods which assist a plumbing contractor and plumbing designer in determining the size of pipes, total fixture units and quantity of items for plumbing fixtures, equipment and foundry according to building codes, plumbing codes, engineering codes, and governmental codes.
  • the configuration of fixtures and piping are graphically displayed and the total quantity of items required for the piping to these fixtures, equipment, foundry or miscellaneous labor operations are stored in a database.
  • the user can choose individual pictures of fixtures and pipe.
  • the selection may be conducted by selecting from a drop-down box, manually typing the file name, selecting the picture from a file or database, and the like.
  • the Typical Image and Attribute Builder can allow the user to choose fixtures by selecting boxes or pictures of fixtures on the screen and "build" the graphical image.
  • a selection box may be structured to first display a picture of a flush valve water closet fixture. If the selection box is selected again, by clicking the box with a computer mouse, trackpad, and the like, the box then displays a picture of a sink fixture.
  • the Typical Image and Attribute Builder may also display the cold water (CW), hot water (HW) and sanitary waste and vent (SWN) piping information required to install the fixture shown, based on options chosen. Once the user is finished with the layout, the information may be saved to Typicals Database 214. The user can also directly add the quantities associated with the plumbing Typical to an existing Take Off Sheet or to a new blank Take Off Sheet as described above by choosing the Pick a Typical button and selecting the plumbing Typical ID from the list or selecting the Typical from a Typical Menu. Type of material, additions, and modifications to the quantities and items can be made and additional information about the items can be added such as Building, Floor, Area, etc. Fig.
  • FIG. 15 is an exemplary screen display of the Typical Image and Attribute Builder screen that illustrates the creation of a plumbing Typical.
  • the type of plumbing fixture shown changes until the user finds the fixture desired.
  • the cold water piping similar to the piping may be shown in a color (e.g., blue) connected to the selected plumbing fixture.
  • An example of this is illustrated in Fig. 15.
  • the hot water piping similarly may be shown in a different color (e.g., red), and the sanitary piping similarly may be shown in yet another color (e.g., black). Sizes and lineal feet quantities can be added or changed in any of the data boxes shown with leaders pointing to the items in each Typical.
  • Some of the advantages of the present invention over other programs include allowing the user to quickly visualize, size, and add quantities.
  • the Typical Image and Attribute Builder feature thus allows the user to visually build, save, and automatically generate quantities of pipe, fittings, and other items based on what parameters are chosen.
  • a Typical may be selected from pre-defined Typicals already stored in the file or database in order to insert similar hook-up materials, hook-up configurations, and attributes and then modify the pre-defined information. Using similar hook-ups versus starting from scratch each time would save time in the Typical building process.
  • the defined Typical may also be saved directly to a Take Off Sheet. If this is done, the defined items along with information about the Typical, sizes, and lengths, and other attributes are then added to the current Take Off Sheet that is being estimated. Thus, a Typical may be defined and saved on the Take Off Sheet for a current estimate and can also be saved in Typical Database 214 for use in a later estimate.
  • a defined Typical can be added directly to the Takeoff Builder Items screen described below. This can be done by selecting a predefined button on the Typical
  • Image and Attribute Builder such as the "Add to Typical Builder" button seen on Figs. 13 and 15 or similar button or menu selection. If this is done, the defined items, along with information about the Typical, sizes and lengths are added to the Typical Builder Items screen. By saving the Typical to the Typical Builder Items, the user can scroll through the Typicals built for each project as well as add/modify the Typicals in the Typical Builder
  • the Typical Component Coupler works in conjunction with the Typical Image and Attribute Builder and the Typical Builder Items to link pre-defined Typicals together.
  • the Typical Component Coupler can design a layout, size the piping, and estimate quantities required to hook up fixtures, equipment and foundry. In this way a determination of what is required for each individual fixture is made versus looking at the whole amount of piping required for a riser diagram. In a sense it is like an electronic erector set that puts small pieces of the riser diagram together to make a whole riser diagram. Prior art deals with the riser diagrams as a whole and not as small pieces. From a database containing Typicals, a user selects a Typical that is to be connected to one or more other Typicals.
  • the program sizes and displays these Typicals on the screen based on parameters and Typical attributes that have been defined in either the Typical Image and Attribute Builder or the Typical Builder Items.
  • the coupling materials running between each Typical e.g., pipe, connectors, elbows, electrical wiring, etc.
  • the coupled Typicals may be saved to a file or the Typicals Database 214 as a single pre-defined Typical.
  • An example of a coupled HNAC Typical is illustrated in Fig. 16. For example, if a user chooses a flush valve water closet in the Typical Component
  • Coupler the program will load the correct coupling component or components as each fixture or piece of equipment is selected from code databases and piping configurations based on the Options selected and items defined in the Typical Image and Attribute Builder (See Fig. 14). Selection of additional fixtures or equipment continues.
  • a calculate instruction is given (e.g., the user selects a "calculate" button or menu item).
  • the main piping that connects each fixture or piece of equipment together is sized and the unit of weight for each fixture or piece of equipment (Fixture Units, GPM, etc.) is totaled together based on code information (e.g., building codes, plumbing codes, engineering codes, and governmental codes) and items databases storing available sizes for the main piping, hook-up materials and coupling components.
  • code information e.g., building codes, plumbing codes, engineering codes, and governmental codes
  • items databases storing available sizes for the main piping, hook-up materials and coupling components.
  • the calculated size of couplings can be overridden by the user by entering a size manually. If the value is manually entered, the remaining couplings are once again sized upon selection of a calculate instruction.
  • the revised configuration of all the components shown on the screen can be saved to Typicals Database 214.
  • the items stored in the database created with Typical Image and Attribute Builder
  • sizes and lengths of pipes calculated in the Typical Component Coupler are added to the Typical Builder Items screen for further additions and modifications.
  • each saved configuration is also available to the user when they choose Pick A Typical in the Take Off Screen. In addition to its use in performing cost estimates of a construction project, the
  • Typical Component Coupler can aid in the design of systems in which two or more fixtures or pieces of equipment are connected.
  • the Typical Component Coupler can provide an automated method of designing and sizing connections between two or more pieces of equipment based on building codes, standard engineering practices and available sizes of coupling items.
  • Typical Builder Items is a method that permits a user to either select a pre-defined Typical that is saved to memory and enter it on the Take Off Sheet or to modify a predefined Typical by identifying, adding, modifying, or deleting items or quantities thereof from a pre- defined Typical and saving it to Typicals Database 214.
  • the Typical Builder Items may accessed from a button on the Take Off Sheet, a menu item that may be selected from the Take Off Sheet menu, an independent application, and the like. Once a Typical has been selected from the pre-defined Typicals or has been modified, it may be directly added to an active Take Off Sheet.
  • Typical is modified by a user, once the Typical has been completed, it may be saved to the database of pre-defined Typicals or, alternatively, the Typical may also be directly entered onto an active data sheet.
  • Fig. 18 illustrates a predefined Typical being displayed on the Typical Builder Items screen.
  • a Typical image along with the size boxes and length boxes can be viewed when the user selects a "Pick A Typical" button or menu item in the Take Off Sheet screen or in the
  • Typical Builder Items screen See Fig. 19.
  • the user can enter all the items in the electronic Take Off Sheet required to install a Typical by selecting a button for Typicals (e.g., see Fig. 5, "Pick a Typical" button) selection from a Take Off Sheet menu, etc. and selecting a Typical from a Typical database or a list of Typicals.
  • the quantities associated with the selected Typical can be added to an existing Take Off Sheet or to a new blank Take Off
  • Pipe Calculator Fig. 11 is an exemplary screen display showing the Pipe Calculator. This feature allows the user to pick any item on the Take Off Sheet entry screen that has corresponding pricing data in the pricing databases and perform calculations on the item that has no effect on any of the data for the project. This feature can also allow an administrator of the pricing databases to make changes to units (e.g., item cost, labor installation cost, etc.) in these databases without having to go anywhere else in the program.
  • units e.g., item cost, labor installation cost, etc.
  • This feature allows the user to quickly switch between materials and items in the pricing databases to find prices and labor units.
  • By entering a quantity in the quantity data box of the piping calculator and choosing the calculate button material and labor can be calculated without setting up a project or inputting any data into the input screens or project specific database tables for a project.
  • the Labor Tracking feature allows the user to tag all items in the database to show progress on a project. While in the project tracking screen one can select a Line Number, Isometric Number or other fields that are associated with items. One can then choose Fabricated, Installed, Weld-Out, Punch, Test or some other tracking field tag. The tags (Fabricated, Installed, etc.) are applied to all the items associated with the Line Number, Isometric Number, etc. The report has formulas that detect which items are tagged and then multiplies the hours for each item by user defined percentages. This will indicate what percentage (Hours) of the project is complete and what percentage (Hours) is left to complete the project.
  • Fig. 7 shows the Take Off Screen format and also shows a "Next Step Message" message and arrow that instructs the user to save the sheet and check function boxes as appropriate.
  • the present invention provides Next Step Messages based on what options, material, and so forth are chosen and based on logic in the software in the form of executable instructions.
  • the present invention also provides on-screen tools that permits users to utilize a format similar to a spreadsheet to pick items, sizes and quantities and speed up the input process. Preferably, one or two clicks of a mouse are needed to input data descriptions, numbers or variables.
  • the Next Step Messages, in conjunction with the Take Off Sheet input screen, results in a shorter user learning curve for the program.
  • Fig. 20 is an exemplary screen display showing the Replace Utility that allows the user to change data such as Drawing Numbers, Items, Sizes, Change Material and Labor factors, Allow Labor Tracking and other fields to be manipulated. This identifies which construction systems (e.g., piping, electrical, etc.) have been completed on a project or the extent the overall project has been completed.
  • construction systems e.g., piping, electrical, etc.
  • This feature allows the user to change the data by allowing the user to globally change or modify data in the project specific database without searching through the input screens or individual items.
  • Fig. 21 is an exemplary screen display showing the Print Utility Screen. This feature allows the user to run standard reports for purchasing, to print or view what is in the pricing databases, and to run reports on criteria set up in the fields when the user enters the data in the input screen. When picking a report from the "Review Take Off side of the Print Utility
  • the user can pick from a project specific database to further narrow down the report to specific items or group of items as shown by the buttons that appear at the bottom of the screen.
  • the captions and items to choose from at the bottom of the screen depend on what type of report is chosen by the user.
  • Fig. 6 is an exemplary screen display showing the Pick Item List that appears when the user clicks on an item text box shown on the left side of the screen shown in Fig. 5 of the Take Off Sheet input screen.
  • the items shown and listed here are items in the pricing databases. These items can be changed and new items added using the updatable grids as shown in Fig. 22 and described below. This feature allows the user the ability to pick items set up by them in the pricing databases.
  • "Updatable Grids" are also used to update and manipulate the Automatically Count Joints feature, the Automatically Count Hangers feature, and the information in the estimating database the project specific database.
  • Item Pricing Databases Fig.22 is an exemplary screen display showing an "Updatable Grid” that allows the user to add or change data in the pricing databases.
  • the program can attach units of measure, like prices, labor units, weights, etc. to items in a project that are entered into the Take Off Sheet input screen.
  • the user clicks on the "Group Description: list” the “Group Sort By: list” the grids are populated with items that match what was picked and the top grid is also filtered to the item picked in the Group Description: list.
  • the updatable grid feature allows for plug numbers to be added during the bidding process of a project and by using the "Show all Plug #'s" button, the user can filter all items with plug numbers, change the pricing to what the actual cost is from the suppliers of those items and calculate a new total cost for the project.
  • This updatable grid also allows for a row or rows in the top grid to be highlighted and copied to the pricing database grid on the bottom by using the right mouse button to drag and copy the information.
  • the descriptions of these items, Group Descriptions, Group Sort By: descriptions and other attributes of these new items can then be easily changed for any specifications for a project.

Abstract

A material and labor cost estimating method and system for estimating the construction costs related to mechanical contracting, electrical contracting, fire protection or processing businesses. The method and system utilizes databases of construction material items, graphical representations of the items, material and labor costs, and a data entry screen to estimate a construction project. Groups of items that comprise a Typical system being installed may be defined to include all the related equipment and hook-ups to install the Typical system. The group of items may also be graphically displayed to illustrate the connection of the equipment to a main construction line. The estimated construction costs may be calculated upon selection of construction items.

Description

MATERIAL AND LABOR COST ESTIMATING METHOD AND SYSTEM
BACKGROUND OF INVENTION
Field of the Invention
The present invention generally relates to a method and system for determining the exact counts of construction hardware and associated material and labor costs for estimating construction projects. More particularly, the invention pertains to on-screen tools and instructions which walk a user through identifying construction items for a specific construction project. Once data is entered, automated procedures produce total estimated material costs, labor hours, units of measure and costs for a project.
Description of Related Art
Computer-based cost estimating programs have long been used in business to calculate material and labor costs for projects. They have also been used for purposes of looking up material and labor costs. Conventional models have also been expanded to be useable to track the material and labor costs of projects. The advantages of such computerized programs include reduction of manual errors, a decrease in estimating turn-around time as well as extended capabilities beyond those which can be carried out on a manual or a semi-automated basis. More recent programs implement WTNDOWS-based programs using a mouse and digitized boards. WINDOWS is a registered trademark of Microsoft, Inc. (Redmond, WA). Such programs make it possible to generate material and labor cost estimates for mechanical piping, electrical systems, control devices, supports and structural steel, sheet metal and insulation, fire protection systems, industrial process lines and the like. Some of these systems can also be used for scheduling of manpower and materials to build a project. Programs of the prior art, however, do not permit an individual to visually observe the location of a given piece of hardware in relation to connected hardware, equipment, or fixtures when conducting an estimate. Prior art programs have displayed a standardized list of hardware quantities in tabular form that the user can manipulate to suit a customized project. The user must exercise skill in selecting components for the estimate. Errors in estimating are often easily overlooked as an estimator views a table of numbers representing the quantity of hardware that is to be used rather than graphically viewing the location of where the hardware will be installed.
While prior art methods and software programs have been used to estimate labor and material for construction projects, they are time consuming, difficult to understand, and/or require a long learning curve. When such a method or program is learned, even if it is simple to use, if it is not used very often, it becomes quickly forgotten.
It would therefore be beneficial to have an estimating program that permits a user to view graphical representations of the installation locations of equipment and connection or "hook-up" hardware and thereby reduce erroneous ordering of incorrect or unnecessary hardware. It would also be useful for all the items required for a to install equipment identified in the graphical representation could be grouped together as a single group and added to an estimate as a group. It would be further beneficial to have an estimating program that overcomes the learning difficulties of the prior art by providing a data entry screen which looks similar to a manual take off sheet used in construction estimating, in which estimating data can be graphically entered and viewed. It would be further useful for the program to display messages that guide the user through the program in a manner that reduces erroneous data from being entered.
SUMMARY OF THE INVENTION
Accordingly, it is an object of the present invention to provide a material and labor cost estimating method and system which provides an individual with graphical illustrations identifying the equipment that is the subject of the estimate.
Another object of the present invention is a mechanical cost estimating method and system that provides graphical illustrations of equipment and identification of the detailed connections to be estimated. Another object of the present invention is a mechanical cost estimating method and system that provides a user with prompting instructions regarding appropriate data that should be entered at various steps in data entry.
A further object of the invention is a mechanical cost estimating method and system that provides a user with all the items required to install equipment and hook-up materials of a construction project that are grouped together as a single group and added to an estimate as a group. Still another object of the present invention is a mechanical cost estimating method and system that provides a graphical user interface data entry screen in a take off sheet.
Briefly, therefore, the present invention is directed towards a computerized method for estimating material and labor costs of a construction project. The method comprises maintaining a database of items and cost data associated for the items, grouping one or more of the items to define predetermined sets of grouped items, selecting one or more of the grouped items based on the construction project, and calculating the estimated cost of the construction project based at least in part upon the cost data associated with the items in the selected set of grouped items. In another aspect, the invention is directed to an automated material and labor cost estimating method within a computer system having a processor, a graphical user interface including a computer display, and an input device. The method comprises maintaining a database of items and cost data associated with the items. One or more of the items are grouped to define predetermined sets of grouped items corresponding to a desired installation of the construction proj ect. A Take Off Sheet data entry screen is displayed comprising quantity data cells corresponding to item size. One or more of the grouped items are entered onto the Take Off Sheet based on the construction project. The estimated cost of the construction project is calculated based at least in part upon the identified quantities of items. In another aspect, the present invention is directed to an automated system for estimating a cost of selected equipment for a construction project. The system comprises a first database containing construction items and material and labor cost data associated with the construction items and a second database containing predetermined sets of grouped items corresponding to a desired installation of the grouped items in the construction project. A computer executes a cost estimating software program that accesses the second database and provides a cost estimate of the construction project based at least in part upon the selected grouped items data.
In yet another aspect, the present invention is directed to a computerized system for estimating the material and labor costs of a construction project. The system comprises a remote server on a communications network managing software programs and databases, a central database associated with the remote server storing construction material specifications and graphics, labor cost data, and material prices, and a local computer on a communications network. The local computer executes an estimating software program and accessing data from the central database and generating material and labor costs for the construction project.
Other features of the present invention will be in part apparent to those skilled in the art and in part pointed out in the detailed description provided below.
BRIEF DESCRIPTION OF DRAWINGS
Figure 1 is a block diagram invention of a mechanical cost estimating system according to a preferred embodiment of the invention.
Figure 2 is a block diagram illustrating interrelationships between data entry, data entry screens, material databases, and reports databases used by the system of Figure 1. Figure 3 is an exemplary flowchart illustrating data entry operations of the system of
Figure 1.
Figure 4 is an illustration of an exemplary Copy Down Utility user interface according to a preferred embodiment of the present invention.
Figure 5 is an illustration of an exemplary Take Off Sheet data entry user interface according to a preferred embodiment of the present invention.
Figure 6 is an illustration of an exemplary item drop-down user interface for selecting an item according to a preferred embodiment of the present invention.
Figure 7 is an illustration of an exemplary window user interface displaying a graphical representation of an item selected from a Take Off Sheet and "Next Step Messages."
Figure 8 is an illustration of an exemplary "Pick a Starting Size" window user interface according to a preferred embodiment of the present invention.
Figure 9 is an illustration of an exemplary window user interface showing "size buttons" according to a preferred embodiment of the present invention. Figure 10 is an illustration of an exemplary calculator window user interface according to a preferred embodiment of the present invention.
Figure 11 is an illustration of an exemplary pipe material and labor calculator window user interface according to a preferred embodiment of the present invention.
Figure 12 is an illustration of an exemplary Typical list drop-down list user interface according to a preferred embodiment of the present invention. Figure 13 is an illustration an exemplary HNAC "Typical" being created in the Typical Image and Attribute Builder according to a preferred embodiment of the present invention.
Figure 14 is an illustration an exemplary "Options" window user interface according to a preferred embodiment of the present invention.
Figure 15 is an illustration an exemplary plumbing "Typical" being created in the Typical Image and Attribute Builder according to a preferred embodiment of the present invention.
Figure 16 is an illustration an exemplary coupled HNAC "Typical" being created in the Typical Coupling Creator according to a preferred embodiment of the present invention.
Figure 17 is an illustration an exemplary coupled plumbing "Typical" being created in the Typical Coupling Creator according to a preferred embodiment of the present invention.
Figure 18 is an illustration an exemplary HNAC "Typical" in a Typical Builder Items screen according to a preferred embodiment of the present invention. Figure 19 is an illustration an exemplary item drop-down box user interface according to a preferred embodiment of the present invention.
Figure 20 is an illustration of an exemplary "Replace Utility" user interface in accordance with the present invention according to a preferred embodiment of the present invention. Figure 21 is an illustration of an exemplary "Print Utility Screen" user interface in accordance with the present invention according to a preferred embodiment of the present invention.
Figure 22 is an illustration of an exemplary "Updatable Grid" user interface in accordance with the present invention according to a preferred embodiment of the present invention.
DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS
The present invention provides systems and methods that assist in determining the amount of labor and material to produce an estimate for construction projects. The present invention overcomes the learning difficulties of the prior art by providing a data entry screen which looks similar to a manual take off sheet used in construction estimating, but which is linked to a database and utilizes step by step messages to help the user remember how to use the program. In addition, the present invention incorporates features to speed up data entry, view estimate data on a screen, compile estimate data to reports, and update databases and pricing.
The present invention comprises a computer, processor, display, data storage device, graphical user interface, data entry screen (e.g., the Take Off Sheet), graphical illustrations of equipment, graphical illustrations of connection hardware, a project specific database of saved estimate data, pricing databases, report programs, and a messaging feature that walks a user through data entry.
While this invention is susceptible of embodiment in many different forms, Figs. 1-22 illustrate specific embodiments thereof with the understanding that the present disclosure is to be considered as an exemplification of the principles of the invention and is not intended to limit the invention to the specific embodiments illustrated.
Referring now to the drawings, FIG. 1 illustrates an exemplary physical configuration of a mechanical cost estimating system 100 embodying aspects of the present invention. In Fig. 1, computer 102, such as a personal computer, workstation, notebook computer, and the like accesses computer server 104 via network 106. Network 106 may be any computer network such as an intranet (e.g., a local area network, wide-area network, and the like), or a global computer network (e.g., the Internet). Computer 102 may contain material and labor cost estimating software, databases for materials, pricing, reports, and other databases stored locally in its own memory, hard drive, compact disk drive, or other storage device. Once the material and labor cost estimating software is executed, the materials, pricing, and reports databases are updated from materials, pricing, and reports data 108 and vendor pricing data 109 accessed by server 104. Materials, pricing, and reports data 108 and vendor pricing data 109 are downloaded to computer 102, via network 106, for utilization in mechanical cost estimating software.
Alternatively, computer 102 may access vendor pricing data 110 directly from vendor computer 112 via computer network 106. Vendor pricing data 110 is preferably downloaded to computer 102 for utilization in mechanical cost estimating software.
Still alternatively, materials, pricing, reports, and vendor data may be updated directly from a computer readable disk 114 (e.g., compact disk, magnetic diskette, etc.) containing stored estimating data that is accessed locally by computer 102. Computer 102 may also alternatively use a browser to access and execute the mechanical cost estimating software located remotely on server 104 via computer network 106. In such a system, vendor may be updated from server 104, vendor computer 112, locally from a computer readable disk 114, or accessed directly from sever 104, as described above. Once all of the databases have been established and updated, computer 102 executes the material and labor cost estimating software to generate material and labor cost estimate reports are generated. The material and labor cost estimate reports may be output to the display screen of computer 102, to printer 116 or a remote printer via network 106, to an export file that is stored locally on computer 102 or remotely on server 104, or sent directly to customer 118, via network 106, in the form of a computer file, an email, facsimile, and the like.
Fig. 2 is a block diagram illustrating the interrelationships between data entry, data entry screens, material databases, and reports databases for a preferred embodiment of the present invention. The present invention shows a graphical user interface that includes a data entry screen. In this instance, an estimating take off sheet data entry screen 202 (hereinafter referred to as "Take Off Sheet") is supplied data by user defined descriptions 204, input device 208, stored Take Off Sheets 210, material, labor, and pricing databases 206, calculator and size windows 212, Typical Builder Items 214, Typical Image and Attributes Builder 216, and Typical Component Coupler 216. User defined descriptions 204 comprises systems and materials definitions, item images, and item groups set up by a user for a project being estimated. Take Off Sheet 202 also provides function buttons, boxes, and menus which permit a user to manipulate data and calculate estimates such as multiply quantities, show messages, calculate buttons and boxes and the like. Input device 206 comprises a computer mouse, roller ball, trackpad, pointer, digitizer, touch screen, and the like. Stored takeoff sheets 208 comprise previous takeoff sheets created and saved to estimating database 218.
Material, labor, and pricing databases 210 comprise material specification, material cost, labor cost, vendor pricing databases and the like utilized to identify the specifications and material and labor costs associated with an item used or installed in a construction project. An item may be selected from material, labor, and pricing databases 210 by utilizing computer pull-down menus provided by Take Off Sheet 202. Calculator and size buttons 212 comprise graphical user interface windows displayed on a computer screen from which numerical quantities and sizes may be entered onto Take Off Sheet 202. Calculator and size buttons 212 also access information from material, labor, and pricing databases 210 which identify whether a specific item is available. Typicals Database 214 contains saved groups of items and quantities of items (hereinafter referred to as "Typicals") that are represented by graphical images of fixtures or equipment and associated hook-up material (pipes, ductwork, connectors, electrical wiring, etc.) that connect the fixtures or equipment to a main line.
Thus, Typicals constitute predetermined sets of grouped items corresponding to a desired combination or installation wherein the items include fixtures, equipment and associated hook-up material. The saved Typicals may be accessed later and entered into Take Off Sheet 202. Typical Image and Attributes Builder 215 is a computer application that permits a user to create Typicals and enter the groups of items and item quantities defined in a Typical directly to Take Off Sheet 202 or alternatively, save the Typicals to Typical Database 214. Typical Component Coupler 216 connects Typicals together that were defined by Typical Image and Attributes Builder 215 or modified by Typical Builder Items 217 and sizes the coupling connections according to information in building code databases and available item sizes in size databases. The coupled Typical can be entered directly to Take Off Sheet 202 or alternatively, saved to Typical Database 214. Typical Builder Items 217 modifies items and/or item quantities in Typicals defined by Typical Image and Attributes Builder 215 or Typical Component Coupler 216 and enters the modified Typicals directly to Take Off Sheet 202 or alternatively, saves the Typicals to Typical Database 214. Once data has been entered onto Take Off Sheet 202, the information is manipulated according to a specific construction project estimate and saved to estimating database 218 as a specific takeoff sheet record. Estimating database 218 also accesses information from materials and labor databases 220 which, in turn receives pricing data from vendor databases 222. Materials and labor databases provide estimating database 218 with specific material and labor units associated with items used in a construction project. When a project is calculated, material and labor units are associated with all items for a sheet or group of sheets, are totaled, and cost estimates are calculated. The cost estimates are formatted on a report form from reports database 224 and output to output devices 226. Output devices 226 may include any form of output device used to view or access a report, including a printer, a display screen, an export file, email, facsimile, and the like.
Fig.3 is an overview flowchart of the mechanical cost estimating process. The process begins at step 302 with the execution of a file updating program (hereinafter referred to as the "Copy Down Utility") which keeps track of all the programs, reports, and files associated with the program. The Copy Down Utility compares the master databases and files that are present on server 104, CDROM, or other storage device with local databases such as the vendor pricing, materials, project, take off, reports and other files and databases stored locally on computer 102 and determines whether the local files are up to date. If any local file is not current, the user may replace the older local file with the newer file from server 104, CDROM, or other storage device. For example, if all master files are stored on server 104, when a user of the present invention uses the Copy Down Utility program while on computer network 106, the program compares all the dates and times of each local file accessed by computer 102 to the files on server 104. The Copy Down Utility at step 304 identifies which local databases or files are not current with the databases or files residing on server 104. At step 306, if any file has a newer date and time on server 104 compared to the local file(s) on computer 102, the user is given a choice whether to download the databases which are not current. An exemplary Copy Down Utility screen is illustrated in Fig. 4. In addition to maintaining all the files associated with the estimating program, the
Copy Down Utility may itself be periodically updated and maintained through the estimating program from the file menu. A text message and instructions may be displayed indicating that the Copy Down Utility program is not current and needs to be updated.
At step 308, the estimation program is executed. The user is asked whether they want to work on a new project, an existing project, or the last project on which the user worked. The user selects the desired project option. At step 310, the user selects to use a "database format" or a "Take Off Sheet" format for inputting estimate data. If the database format is selected, at step 312, the user enters data directly into estimating database 218. If the Take Off Sheet format is selected, at step 314, a Take Off Sheet data entry screen, as illustrated in Fig. 5, is displayed on the screen of computer 102. The Take Off Sheet contains rows of items and columns of either item sizes or item reducing sizes. A data cell exists at each column and row intersection wherein a quantity value corresponding to the quantity of items of a given size or reducing size is entered. The default Take Off Sheet may be blank, it may be the last sheet the user was estimating, or it may be some other default sheet. At step 315, the user selects the desired Take Off Sheet for data entry.
Messages (hereinafter referred to as "Next Step Messages") are optionally displayed on top of the Take Off Sheet entry screen. The Next Step Messages point to an entry cell or button that would be the next logical step where data should be entered or an activity performed and also displays a message describing what the nature of the next step should be. The Next Step Messages may be optionally disabled.
When the user selects a cell to enter data, the Take Off Sheet is checked to determine whether it is locked or unlocked at step 316. For data protection purposes, Take Off Sheets may be locked once they have been saved to prevent inadvertent overwriting of data. If the sheet is locked, at step 318 the system warns the user that entry of data will overwrite existing data on the Take Off Sheet and asks whether the user wants to overwrite the data, and thereby unlock the sheet. If the user chooses to overwrite the data, the process proceeds to step 320. If the user does not want to overwrite the data, the user may select a different Take Off Sheet at step 322 from the database and the process proceeds to step 316.
At step 320 the user may enter project identification data such as project name, project number, drawing number, system, material, building, Take Off Sheet number, Take Off Sheet revision number, and the like. This information may be preset in a database which can be selected by the user from a computer drop-down box, automatically completed upon entry of the first few characters of typed data, manually typed in its entirety into the data box, and the like. The project identification information is utilized by the program to save the individual Take Off Sheet as well as group the Take Off Sheet with related projects for estimating the costs for an entire project of several systems. A system identifies the type of system being estimated such as chilled water, hot water, domestic water, sanitary waste and vent, electrical system, process systems, high pressure supply air, or other system to be installed. Several types of materials may be required for the installation of each system, such as carbon steel, carbon steel, copper, stainless steel or other type of pipe or conduit material.
After project identification data have been entered, at step 322 specific items such as a pipe, elbow, coupling and the like may be entered and the corresponding size(s) and quantity or quantities may be entered into data cells of the Take Off Sheet that are required for the project being estimated. Take Off Sheet item text boxes and data cells may be selected by highlighting, clicking a mouse button, and so forth to bring up either a hardware item selection list, item size buttons, or a calculator to perform arithmetic operations or preset numbers to enter quantities into the Take Off Sheet data cells that are highlighted. The user can also enter data by obtaining information from a previous Take Off Sheet or by getting information from the last Take Off Sheet that was saved to memory. Items may be selected from a drop-down box of pre-defined items, by an autocomplete text entry method, typed in manually, or the like. To reduce errors in item selection and ensure accurate estimations, it is preferred that the user select the item from a predefined list. An example of a drop-down list of items is illustrated in Fig. 6. If a system and material have been loaded into supporting databases, once a specific system and material have been entered onto the Take Off Sheet, the program can pre-load the Take Off Sheet with predefined items and the sizes and quantities of the items that are commonly used for the system or have been specifically selected for the particular project being estimated. Each item also may have materials or requirements information associated with it that can be included automatically in the estimate when it is finally calculated, such as required joining materials, welds, hangers, supports, couplings, or any other material or item in the databases. To aid the user in ensuring that the correct item is selected, a box adjacent to the item column may be depressed to display a picture of the item on the screen (See box immediately to the left of each item row, Fig. 5) and can also include dimensions and physical data associated with the item. An example of such a picture is illustrated in Fig. 7.
At step 324, the user may enter the quantities of items needed according to the size of each. For example, various sizes associated with a given item may be presented in column headings of the Take Off Sheet as illustrated in Fig 5. The sizes may be listed across the columns in incremental order, in varying sizes, or some other order. The user may select a starting size from which the size columns incrementally increase by selecting a starting size button from the "Pick a Starting Size" window which can be defined by the user. An example of this is illustrated in Fig. 8. Alternatively, a specific column size may also be edited by clicking on the column size cell and entering a new size by manually typing the new size or by selecting the new size from a size window. An alternative means to manually entering the sizes is through a size window in which the user can select pre-determined sizes by simply depressing a size button on the size window to assign a size to a column of the Take Off Sheet, or pick a size from a size list. The size window is illustrated in Fig. 9. Another feature of the size buttons is the ability to see what sizes are available for a certain item picked when an "Available Sizes" button is selected and show what sizes exist in pricing databases. This helps the user know whether an item is in the pricing databases. Non- manufactured sizes may be pre-defined for each defined item listed such that a data entry cell corresponding to a non-manufactured item size can be "blacked-out" on the Take Off Sheet. The "blacked-out" cells thereby aid the user in avoiding selecting unavailable item sizes in an estimate.
Pre-loaded size and quantity values for listed items may be edited as required. If the item quantity values entered by the user or pre-loaded by the program are not desired, the user can remove all quantities by using a "clear all quantities" button. Similarly, if only a single column of sizes or row of items is desired to be cleared, a clear button adjacent to the column or row (as illustrated by the "C" button on Fig. 5) may be pressed to clear the information from the Take Off Sheet. Furthermore, as all quantities except for the length of pipe may often need to be revised, the "-P" button at the bottom of each column may be pressed to clear all quantities except for those pre-loaded for the pipe.
A user may utilize a calculator to select quantities into the Take Off Sheet by depressing a button having a predetermined number, manually enter a specific number, or calculate quantities and enter the quantities into a data cell. Additionally, a selected quantity may be manipulated by the arithmetic functions thereby permitting the user to easily increase the estimated quantities for multiple systems by adding or multiplying the quantities or decreasing the quantities through subtraction and division function buttons. If a quantity is already listed on the Take Off Sheet and the user simply wants to add a quantity to the listed number, the "accumulate numbers" function may be selected on the calculator in order to add the listed quantity with the additional quantity selected by the user on the calculator. A single quantity may also be entered into multiple data cells by selecting a multiple cells check box on the calculator and then selecting any quantity of data cells in the Take Off Sheet format input screen. As a quantity data cell is selected, the value selected on the calculator is entered into or added to the quantity data cells until the multiple cells feature is unchecked. The calculator is illustrated in Fig. 10. Another feature of the Take Off Sheet format is a Piping Calculator that allows the user to mouse click on any data cell on the Take Off Sheet input screen and calculate the material and labor using pricing databases. The piping calculator is illustrated in Fig. 11.
In a further aid for identifying and entering specific quantities of items on the Take Off Sheet, a user may select a "Typical" by depressing the "Pick a Typical" button illustrated in Fig. 5. Typicals are groups of items that are combined to attach a system to the main lines of construction (e.g., HNAC systems, electrical systems, piping systems, electrical systems, control devices, supports and structural steel systems, sheet metal and insulation systems, fire protection systems, industrial process systems, etc.). Thus, Typicals include fixtures, equipment, or structural steel supports and all of the associated hook-up materials necessary to attach the fixtures or equipment to the main line (e.g., piping, connectors, elbows, valves, reducers, electrical wiring, etc.). Examples of fixtures or equipment include HNAC equipment, chillers, hot-water heaters, structural steel supports and the like. The Typicals can be viewed by a user by selecting the desired Typical from a Typicals pull-down box which then displays the Typical on the screen as illustrated in Fig. 12. By viewing the Typical on the screen, the user can accurately identify and select the correct Typical fixture or equipment that is to be installed in the system. When a Typical is selected, the items and their quantities are entered on the Take Off
Sheet. If the user wishes to add the Typical quantities to the listed quantities that may already exist on the Take Off Sheet, the accumulate numbers function, similar to that of the calculator described above, will add the item quantities defined for the Typical to the listed quantities. In addition, a selected Typical may be predefined to include all the required hook up connections and lines to attach the Typical to the main lines of construction which can be added to the Take Off Sheet in one step. For example, in Fig. 12, if a "1-14 inch-2-way 1- high coil" is needed in the installation of a commercial/institutional HNAC system, the Typical may be selected from the list of pre-defined Typicals. All the connections, including the equipment, lines, etc. required to hook the " Λ inch-2-way 1-high coil" to the main lines of construction can be added to the Take Off Sheet by depressing the "Add Quantities For This Typical to the Take Off Sheet" button. Thus, each piece of pipe, elbow, valve, equipment and so forth can be added to the estimate as a group and would not have to be individually entered on the Take Off Sheet. In addition, the listed Typical items may also be defined such that the associated materials or requirements such as joining materials, required welds, hangers, supports and any other data associated with the item are automatically added to the estimate when it is calculated.
The method of estimating pipe and fittings of the present invention is unique in that it graphically represents the equipment or fixture and associated hook-up materials and saves the graphic with all the information for a particular project. The user can also scroll through all the Typicals he has entered and saved for a particular project by using a data scroll or find button. The find button allows the user to look for Typicals by identification number and other searching parameters based on what has been input into the other text boxes. Saved Typicals may be retrieved and used as a template containing standardized sizes of hardware for Typicals that are repeated in projects, and quantities can be modified to adapt to each project's requirements.
In still another alternative to entering data into the Take Off Sheet, the required items and their quantities for a Typical may be created and saved as a pre-defined Typical for use in later estimates and/or be directly added to a Take Off Sheet in the same manner as previously described for adding pre-defined Typicals to a Take Off Sheet. Such a Typical may be an HNAC Typical, plumbing chase Typical, electrical Typical, structural steel support, or any other piece of equipment or fixture installed in construction projects as described in the Typical Builder Application section below.
After all the items and their corresponding quantities have been entered in the Take Off Sheet, the user instructs the program to save the information at step 326. At step 328, the data entered is checked to determine whether the minimum required data fields were completed. If the minimum data fields were not completed, at step 330 the user is required to complete the minimum fields. The process loops back to step 328 to verify if all of the required data fields were entered. If all required data fields have been completed, the process proceeds to step 332 wherein the information is stored to memory such as estimating database 218 and project specific databases. The information may be stored to local memory such as a hard drive, diskette, compact disk, or other local storage medium, or stored to remote memory such as a remote server database.
At step 334, it is determined whether the user wants to calculate an estimate for the input data. If the user selects to calculate an estimate, the data entered on the Take Off Sheet (i.e., the selected items and their quantities) and the materials or requirements associated with the selected items such as joining materials, required welds, hangers, supports and any other data associated with an item are totaled. The material and labor costs and other information are retrieved from pricing databases and a cost estimate is produced at step 338. Factors such as projects scheduled to start in the future may also be used to adjust the cost estimate (e.g., material costs for projects scheduled in the future may be estimated to cost more than if they were scheduled to begin immediately). Thus, the user may manipulate project dates to revise factors such as material and labor cost escalation factors. At step 340, it is determined whether a report is to be created for the calculated estimate. If no report is to be created, the process proceeds to step 346. If the user wishes to create a report, at step 342, the user selects a report from a list of pre-defined reports and selects whether the report should be printed to screen, to a printer, to a file, or to another output device. Tracking fields, such as drawing number, system number and so forth, may be used to allow reports to be generated and data to be grouped together. Once a user selects a report, a print utility permits the user to further define reporting criteria by a tracking field, such as an individual drawing number, building, etc. User defined reports may be created or saved to the reports database. At step 344, the selected report is created. The reports may be sent to an output device such as a printer, a computer display screen, an export file, and the like. The reports may also be saved to a database. Additionally, reports may be electronically sent over network 106 to customer 118 via export files, email, facsimile, and so forth. The process proceeds to step 346.
At step 346, if additional data is to be entered, the process loops back to step 315, otherwise, if no other data is to be entered, the estimating file may be saved to storage device as an individual file and process ends at step 348.
The Take Off Sheet entry screen provides a user with a number of options in preparing an estimate in addition to those briefly described above. Some of these options, as illustrated in Fig.5, include but are not limited to:
(a) A "Sheet Locked/Unlocked" feature that locks everything on the screen so that existing information cannot be accidentally changed. An error dialog appears and gives you a choice to lock or unlock the screen. (b) A "Save This Sheet" button feature will save the information displayed on the
Take Off Sheet input screen and any associated item to an estimating database in the project specific database. Before the information is saved to the estimating database, the database is searched for existing data that matches the record number of the Take Off Sheet and overwrites the matching record. This ensures that any changed data will be deleted and recommitted before labor units, material units and other units of measure are applied as in paragraph (e) below.
(c) A "Get Info from Previous Sheet" button feature will copy all the information from the last saved sheet as in step (b) above, or will get all the information saved to memory as in step (d) below and copy that information into the current Take Off Sheet input screen. (d) A "Copy Info Shown for Next Sheet" button feature will save the information on the current Take Off Sheet to memory and allow the user to utilize the information for another sheet. (e) A "Calculate This Project" button feature will perform several procedural steps at once. If the "Automatically Count Joints" option is checked, the program will insert related items, such as welds for welded pipe and gaskets, fittings, and so forth into estimating database 218. Other items, such as pipe, fittings, valves can be set up by the user to count and insert other items into the estimating database of the project specific database. For example, some such items can be counted and inserted when a related item is selected (e.g., 2 flanges, 2 bolt and gasket sets, and 2 welds can be counted and inserted for every flanged valve that is found in the estimating database).
After the "Calculate This Project" button has been selected, all labor units, material units and other units of measure in the pricing databases are determined and calculated for each item in the Take Off Table. After these units have been determined, the Print Utility Screen appears as shown in Fig. 11 and allows the user to choose and print reports. The total material costs and labor hours are calculated from the input data at the time the reports are generated and multiple pricing and labor units may be applied at report time. (f) A "Labor Factor" feature allows the user to apply the labor factor to all of the items on the sheet and applies that factor to the labor units at report time. The Labor Factor of a project is based upon the difficulty of the construction project being estimated. A default of "1" is used by the present invention unless changed by the user. If, for example, a particular job is located in a confined area thereby increasing the difficulty of a project, the Labor Factor can be increased accordingly to estimate higher labor costs resulting from the increased labor hours required to complete the project.
(g) A "Material Escalation Factor" feature allows the user to apply a material factor to all of the items on the Take Off Sheet and applies that factor to the material units at report time. If the project is anticipated to begin in the near term, the default factor of "1" is used. However, if a project estimate is being created far in advance of the actual start of the project, or if the project is anticipated to be delayed, the Material Escalation Factor may be increased (e.g., from a default of "1" to "1.2") to reflect an increase in material costs over time.
(h) A "Next Take Off Sheet" button feature brings up the next Take Off Sheet input screen to be input and copies information from the previous saved Take Off Sheet input screen as it pertains to a particular project such as the Project Name, Project Number, etc. (i) A "Multiply All Quantities By:" button feature allows the user to enter an amount in the data box to the right of this button that causes all quantities on the Take Off Sheet to be multiplied by the amount entered.
(j) An "Enter Quantities Manually" check box feature allows the user to navigate around in the quantity data cells using the arrow keys, tab key and enter key rather than using a mouse-based point and click method of inputting data. Once the user is at a desired data cell, the numeric key pad can be used to enter quantities. If the user accidentally scrolls to the top, bottom, left, or right part of the quantity data cell area, an error dialog box appears and warns that the user has scrolled too far. (k) An "Automatically Count Joints" check box feature allows related items to be included in an estimate when specific items are selected based on criteria set up by the user. Thus, a gasket which is always used in connection with a flange can be automatically included in the estimate when the flange is selected. The items are then added into the estimating database and included in the total scope of the project when the "Calculate this Project" button is selected.
(1) An "Automatically Count Hangers" check box feature allows hangers to be attached to piping items based on criteria set up by the software administrator. These hangers are then added into the estimating database and included in the total scope of the project when the "Calculate this Project" button is selected. (m) A "Pipe Calculator Mode On/Off check box feature allows the user to look up material units and labor units for any item selected in the Take Off Sheet and perform calculations on that selected item.
(n) The "C" button feature adjacent to an identified item or column will clear all information contained in a row or column of a Take Off Sheet input screen.
TYPICAL BUILDER APPLICATIONS
The present invention also includes a method to generate Typicals that may be added to a Take Off Sheet during an estimate.
As described above, a Typical is a group of items and item quantities that are required to completely install a system, particular piece of equipment or fixture to a main line in a construction project. A main line may be a plumbing line, ventilation connection, electrical junction, and the like in a construction project. Examples of installed systems or particular pieces of equipment or fixtures include, but are not limited to, chillers, hot-water heaters, plumbing fixtures, electrical heaters, industrial pumps, and the like. For example, a Typical for a hot water heater would include the items of a hot water heater, piping for providing incoming water from a main water line to the hot water heater, piping for providing outgoing, heated water to the main line, and all the valves, connectors, hangers, elbows, fittings, and the like required to completely install the Typical. In addition, a Typical provides a graphical representation of the Typical connection (e.g., the schematic identifying all the parts of the Typical) to permit an estimator to accurately estimate all the pieces required for installing a complete Typical. In a preferred embodiment, three interrelated Typical methods are utilized to aid the user in building a Typical, grouping Typicals together, and permitting the selection, use, and/or modification of pre-defined Typicals. These programs include: the Typical Image and Attribute Builder, the Typical Component Coupler and Typical Builder Items. The Typical Builder Items can be used by itself without sizes and length attributes or in conjunction with Typical Image and Attribute Builder or Typical Component Coupler. To create a Typical, the method relies upon a computer having a display screen, stored executable instructions, an input device and a processing unit coupled to the display screen, data storage device and the entry device.
Typical Image and Attribute Builder: The Typical Image and Attribute Builder works in conjunction with the Typical
Builder Items and the Typical Component Coupler. The Typical Image and Attribute Builder of the present invention allows a user to create and store information in a file or database which includes graphical images, text fields for dimensions and lengths of pipe, ductwork, etc. (the attributes), X and Y coordinates for the size and lineal feet data boxes, and all the items needed to install a Typical. The user can define or "build" a Typical by selecting a graphical image of a particular piece of equipment or fixture that will appear on screen and identify or map the location where dimension and length data boxes are placed around or on the graphical image. The graphical image is displayed on the screen after it is chosen from the pull-down box, selected from a graphical image database, scanned, or generated by the user. The user may also import and save his own pictures of equipment that are used to identify a defined Typical. Fig. 13 illustrates a Computer- Aided Design graphical image of a HNAC Typical being defined in the Typical Image and Attribute Builder of the present invention. The fixture that is included in a plumbing Typical may be defined in the Typical Image and Attribute Builder or the Typical Component Coupler as described below. Lead lines may be preferably provided on the graphical image that connect the data boxes to the piece of pipe or other item being defined.
Once a graphical image of the Typical is selected and the data boxes are located around or on the graphical image, the user chooses dimensions and lengths for the Typical from a size list and enters the dimension and length values of pipe, ductwork, conduit, etc. into the data boxes around the graphical image. An error message may be displayed if the user tries to enter a dimension into a lineal foot data box. In the same manner, if the Typical is for electrical equipment, the gage and voltage/amperage rating of electrical wiring may alternatively be entered in the data boxes.
The other items that are to be included for the Typical (e.g., valves, connectors, hangers, elbows, fittings, junction boxes, and the like may selected from a pull-down box listing the items, by manually typing the item name, or otherwise selecting the item. The sizes and quantities of the selected items are then defined for the Typical. Other parameters in a Typical definition may include, but are not limited to, the quantity of how many multiples of item sizes and quantities are to be included if a Typical includes more than one group of the items and quantity of items that was just defined, an identification number, drawing number, construction area, etc. Once the Typical has been built, the defined Typical (i.e., the graphical image and associated data boxes, and other associated items and their attributes) is stored in a file or database for later retrieval. The file or database may contain stored Typicals only or it may be a combined file or database containing stored Typicals and other data such as individual items, materials pricing, and the like. Typicals may also be created to provide a graphical illustration of the fixture or equipment without the surrounding data boxes. In such a case, the dimensions and lengths of all the items are defined and saved to the Typical database, but are not displayed on the graphical illustration.
The Typical Image and Attribute Builder may also be used to build pictures of a Typical and define the requirements for fixtures and equipment. In the case of plumbing estimates, there are a myriad of configurations that piping in chases can be designed and connected to plumbing fixtures. The present invention provides systems and methods which assist a plumbing contractor and plumbing designer in determining the size of pipes, total fixture units and quantity of items for plumbing fixtures, equipment and foundry according to building codes, plumbing codes, engineering codes, and governmental codes. In addition, the configuration of fixtures and piping are graphically displayed and the total quantity of items required for the piping to these fixtures, equipment, foundry or miscellaneous labor operations are stored in a database.
As described above, the user can choose individual pictures of fixtures and pipe. The selection may be conducted by selecting from a drop-down box, manually typing the file name, selecting the picture from a file or database, and the like. Alternatively, the Typical Image and Attribute Builder can allow the user to choose fixtures by selecting boxes or pictures of fixtures on the screen and "build" the graphical image. For example, a selection box may be structured to first display a picture of a flush valve water closet fixture. If the selection box is selected again, by clicking the box with a computer mouse, trackpad, and the like, the box then displays a picture of a sink fixture. If selected yet again, it displays a urinal this process continues each time the user clicks on the same box until the desired fixture appears or the picture loop back to the first displayed picture. The user selects the type of Typical that is being defined from an Options window (See Fig. 14). These parameters will affect the type of pictures that appear, the quantity of items such as pipe, fittings and valves, and the sizing of the mains determined by local and state codes chosen. Based on piping configurations selected in the Options and code requirements databases and the sizes of the pipe available in the items databases, the program will load the correct item or items and their respective quantities, dimensions, and lengths as each fixture or piece of equipment is selected. The Typical Image and Attribute Builder may also display the cold water (CW), hot water (HW) and sanitary waste and vent (SWN) piping information required to install the fixture shown, based on options chosen. Once the user is finished with the layout, the information may be saved to Typicals Database 214. The user can also directly add the quantities associated with the plumbing Typical to an existing Take Off Sheet or to a new blank Take Off Sheet as described above by choosing the Pick a Typical button and selecting the plumbing Typical ID from the list or selecting the Typical from a Typical Menu. Type of material, additions, and modifications to the quantities and items can be made and additional information about the items can be added such as Building, Floor, Area, etc. Fig. 15 is an exemplary screen display of the Typical Image and Attribute Builder screen that illustrates the creation of a plumbing Typical. When a user clicks on a rectangular box or square the type of plumbing fixture shown changes until the user finds the fixture desired. At the same time a fixture is selected, the cold water piping similar to the piping may be shown in a color (e.g., blue) connected to the selected plumbing fixture. An example of this is illustrated in Fig. 15. The hot water piping similarly may be shown in a different color (e.g., red), and the sanitary piping similarly may be shown in yet another color (e.g., black). Sizes and lineal feet quantities can be added or changed in any of the data boxes shown with leaders pointing to the items in each Typical. Some of the advantages of the present invention over other programs include allowing the user to quickly visualize, size, and add quantities. The Typical Image and Attribute Builder feature thus allows the user to visually build, save, and automatically generate quantities of pipe, fittings, and other items based on what parameters are chosen.
If the user is building a new Typical, a Typical may be selected from pre-defined Typicals already stored in the file or database in order to insert similar hook-up materials, hook-up configurations, and attributes and then modify the pre-defined information. Using similar hook-ups versus starting from scratch each time would save time in the Typical building process.
The defined Typical may also be saved directly to a Take Off Sheet. If this is done, the defined items along with information about the Typical, sizes, and lengths, and other attributes are then added to the current Take Off Sheet that is being estimated. Thus, a Typical may be defined and saved on the Take Off Sheet for a current estimate and can also be saved in Typical Database 214 for use in a later estimate.
Additionally, a defined Typical can be added directly to the Takeoff Builder Items screen described below. This can be done by selecting a predefined button on the Typical
Image and Attribute Builder such as the "Add to Typical Builder" button seen on Figs. 13 and 15 or similar button or menu selection. If this is done, the defined items, along with information about the Typical, sizes and lengths are added to the Typical Builder Items screen. By saving the Typical to the Typical Builder Items, the user can scroll through the Typicals built for each project as well as add/modify the Typicals in the Typical Builder
Items screen. Typical Component Coupler:
The Typical Component Coupler works in conjunction with the Typical Image and Attribute Builder and the Typical Builder Items to link pre-defined Typicals together. The Typical Component Coupler can design a layout, size the piping, and estimate quantities required to hook up fixtures, equipment and foundry. In this way a determination of what is required for each individual fixture is made versus looking at the whole amount of piping required for a riser diagram. In a sense it is like an electronic erector set that puts small pieces of the riser diagram together to make a whole riser diagram. Prior art deals with the riser diagrams as a whole and not as small pieces. From a database containing Typicals, a user selects a Typical that is to be connected to one or more other Typicals. Once the Typicals that are to be connected have been selected, the program sizes and displays these Typicals on the screen based on parameters and Typical attributes that have been defined in either the Typical Image and Attribute Builder or the Typical Builder Items. When the final coupling of Typicals is complete, the coupling materials running between each Typical (e.g., pipe, connectors, elbows, electrical wiring, etc.) are automatically sized and selected from item databases when a calculate instruction is executed. Once the coupling calculations have been completed, the coupled Typicals may be saved to a file or the Typicals Database 214 as a single pre-defined Typical. An example of a coupled HNAC Typical is illustrated in Fig. 16. For example, if a user chooses a flush valve water closet in the Typical Component
Coupler, the program will load the correct coupling component or components as each fixture or piece of equipment is selected from code databases and piping configurations based on the Options selected and items defined in the Typical Image and Attribute Builder (See Fig. 14). Selection of additional fixtures or equipment continues. When the user is done with the selections, a calculate instruction is given (e.g., the user selects a "calculate" button or menu item). The main piping that connects each fixture or piece of equipment together is sized and the unit of weight for each fixture or piece of equipment (Fixture Units, GPM, etc.) is totaled together based on code information (e.g., building codes, plumbing codes, engineering codes, and governmental codes) and items databases storing available sizes for the main piping, hook-up materials and coupling components. Once the selections and calculations are finished, the configuration of all the components shown on the screen can be saved in a file or database. The file or database used to store the configuration can contain pre-defined Typicals or also contain other data such as individual item information, material specifications, pricing, etc. An example of a plumbing Typical being coupled in the Typical Couplings Creator is illustrated in Fig. 17.
Although there are defaults for each component that is selected during the calculation of the component size, the calculated size of couplings can be overridden by the user by entering a size manually. If the value is manually entered, the remaining couplings are once again sized upon selection of a calculate instruction. The revised configuration of all the components shown on the screen can be saved to Typicals Database 214.
If the user chooses the "Add to Typical Builder Items" button, the items stored in the database (created with Typical Image and Attribute Builder) along with sizes and lengths of pipes calculated in the Typical Component Coupler are added to the Typical Builder Items screen for further additions and modifications. As in the Typical Image and Attribute Builder and the Typical Builder Items, each saved configuration is also available to the user when they choose Pick A Typical in the Take Off Screen. In addition to its use in performing cost estimates of a construction project, the
Typical Component Coupler can aid in the design of systems in which two or more fixtures or pieces of equipment are connected. The Typical Component Coupler can provide an automated method of designing and sizing connections between two or more pieces of equipment based on building codes, standard engineering practices and available sizes of coupling items.
TYPICAL BUILDER ITEMS
Typical Builder Items is a method that permits a user to either select a pre-defined Typical that is saved to memory and enter it on the Take Off Sheet or to modify a predefined Typical by identifying, adding, modifying, or deleting items or quantities thereof from a pre- defined Typical and saving it to Typicals Database 214. The Typical Builder Items may accessed from a button on the Take Off Sheet, a menu item that may be selected from the Take Off Sheet menu, an independent application, and the like. Once a Typical has been selected from the pre-defined Typicals or has been modified, it may be directly added to an active Take Off Sheet. If the Typical is modified by a user, once the Typical has been completed, it may be saved to the database of pre-defined Typicals or, alternatively, the Typical may also be directly entered onto an active data sheet. Fig. 18 illustrates a predefined Typical being displayed on the Typical Builder Items screen.
Pick a Typical
A Typical image along with the size boxes and length boxes can be viewed when the user selects a "Pick A Typical" button or menu item in the Take Off Sheet screen or in the
Typical Builder Items screen. See Fig. 19. The user can enter all the items in the electronic Take Off Sheet required to install a Typical by selecting a button for Typicals (e.g., see Fig. 5, "Pick a Typical" button) selection from a Take Off Sheet menu, etc. and selecting a Typical from a Typical database or a list of Typicals. The quantities associated with the selected Typical can be added to an existing Take Off Sheet or to a new blank Take Off
Sheet. The type of material and additions and modifications to these quantities and items can be made and additional information about these items can be added such as Building, Floor, Area, etc.
Pipe Calculator Fig. 11 is an exemplary screen display showing the Pipe Calculator. This feature allows the user to pick any item on the Take Off Sheet entry screen that has corresponding pricing data in the pricing databases and perform calculations on the item that has no effect on any of the data for the project. This feature can also allow an administrator of the pricing databases to make changes to units (e.g., item cost, labor installation cost, etc.) in these databases without having to go anywhere else in the program.
This feature allows the user to quickly switch between materials and items in the pricing databases to find prices and labor units. By entering a quantity in the quantity data box of the piping calculator and choosing the calculate button material and labor can be calculated without setting up a project or inputting any data into the input screens or project specific database tables for a project.
Labor Tracking
The Labor Tracking feature allows the user to tag all items in the database to show progress on a project. While in the project tracking screen one can select a Line Number, Isometric Number or other fields that are associated with items. One can then choose Fabricated, Installed, Weld-Out, Punch, Test or some other tracking field tag. The tags (Fabricated, Installed, etc.) are applied to all the items associated with the Line Number, Isometric Number, etc. The report has formulas that detect which items are tagged and then multiplies the hours for each item by user defined percentages. This will indicate what percentage (Hours) of the project is complete and what percentage (Hours) is left to complete the project. For example, if certain items are tagged as Fabricated for Line Number CWR-001002- 1-1/2 and in the user defined report 10% is used for any item tagged as fabricated then the unit hour for each item is multiplied by 0.1. If a 6" Elbow = 1.5 hours and it is checked as being being fabricated would be 1.5 x .1 = .15 hours completed. Therefore, it will still take 1.35 hours to Install it, Weld it out, Punch and Test it before the installation is complete.
Next Step Messages
Fig. 7 shows the Take Off Screen format and also shows a "Next Step Message" message and arrow that instructs the user to save the sheet and check function boxes as appropriate. The present invention provides Next Step Messages based on what options, material, and so forth are chosen and based on logic in the software in the form of executable instructions. The present invention also provides on-screen tools that permits users to utilize a format similar to a spreadsheet to pick items, sizes and quantities and speed up the input process. Preferably, one or two clicks of a mouse are needed to input data descriptions, numbers or variables. The Next Step Messages, in conjunction with the Take Off Sheet input screen, results in a shorter user learning curve for the program.
Replace Utility
Fig. 20 is an exemplary screen display showing the Replace Utility that allows the user to change data such as Drawing Numbers, Items, Sizes, Change Material and Labor factors, Allow Labor Tracking and other fields to be manipulated. This identifies which construction systems (e.g., piping, electrical, etc.) have been completed on a project or the extent the overall project has been completed.
This feature allows the user to change the data by allowing the user to globally change or modify data in the project specific database without searching through the input screens or individual items. Print Screen Utility
Fig. 21 is an exemplary screen display showing the Print Utility Screen. This feature allows the user to run standard reports for purchasing, to print or view what is in the pricing databases, and to run reports on criteria set up in the fields when the user enters the data in the input screen. When picking a report from the "Review Take Off side of the Print Utility
Screen, the user can pick from a project specific database to further narrow down the report to specific items or group of items as shown by the buttons that appear at the bottom of the screen. The captions and items to choose from at the bottom of the screen depend on what type of report is chosen by the user.
Pick Item List
Fig. 6 is an exemplary screen display showing the Pick Item List that appears when the user clicks on an item text box shown on the left side of the screen shown in Fig. 5 of the Take Off Sheet input screen. The items shown and listed here are items in the pricing databases. These items can be changed and new items added using the updatable grids as shown in Fig. 22 and described below. This feature allows the user the ability to pick items set up by them in the pricing databases. "Updatable Grids" are also used to update and manipulate the Automatically Count Joints feature, the Automatically Count Hangers feature, and the information in the estimating database the project specific database.
Item Pricing Databases Fig.22 is an exemplary screen display showing an "Updatable Grid" that allows the user to add or change data in the pricing databases. When the user adds descriptions of an item, descriptions of groups, or changes data that are specific to the item, the program can attach units of measure, like prices, labor units, weights, etc. to items in a project that are entered into the Take Off Sheet input screen. When the user clicks on the "Group Description: list" the "Group Sort By: list," the grids are populated with items that match what was picked and the top grid is also filtered to the item picked in the Group Description: list.
As the user continues to choose from the "Group Sort By: list" and "Material
Description Code: list" is populated with items that match what was chosen in the "Group Sort By: list." Any item in the grids can be updated at any point in this process of selecting from the list. Data in the pricing databases can be updated by using this feature.
The updatable grid feature allows for plug numbers to be added during the bidding process of a project and by using the "Show all Plug #'s" button, the user can filter all items with plug numbers, change the pricing to what the actual cost is from the suppliers of those items and calculate a new total cost for the project.
This updatable grid also allows for a row or rows in the top grid to be highlighted and copied to the pricing database grid on the bottom by using the right mouse button to drag and copy the information. The descriptions of these items, Group Descriptions, Group Sort By: descriptions and other attributes of these new items can then be easily changed for any specifications for a project.
In view of the above, it will be seen that the several objects of the invention are achieved and other advantageous results attained.
When introducing elements of the present invention or the preferred embodiment(s) thereof, the articles "a", "an", "the" and "said" are intended to mean that there are one or more of the elements. The terms "comprising", "including" and "having" are intended to be inclusive and mean that there may be additional elements other than the listed elements.
As various changes could be made in the above compositions and processes without departing from the scope of the invention, it is intended that all matter contained in the above description be interpreted as illustrative and not in a limiting sense.

Claims

I Claim:
1. A computerized method for estimating material and labor costs of a construction project comprising: maintaining a first database of items and cost data associated with each of the items; grouping one or more of the items from the first database to define predetermined sets of items, each of said predetermined sets of items corresponding to a desired installation of the grouped items; selecting one or more of the sets of grouped items based on the construction project; and calculating the estimated cost of the construction project based at least in part upon the cost data associated with the items in the selected set of grouped items.
2. The computerized method of claim 1 further comprising: maintaining a second database of graphical representations, each of said graphical representations corresponding to one of the sets of grouped items; and displaying the graphical representation of at least one set of grouped items upon selection.
3. The computerized method of claim 2 further comprising identifying sizes and quantities of the grouped items from the displayed graphical representation.
4. The computerized method of claim 2, wherein the the graphical representation of the grouped items is displayed and dimensions of hook-up materials are defined by entering dimension units of measure in data boxes associated with the graphical representation of the grouped items.
5. The computerized method of claim 1 wherein the grouped items are selected from the group consisting of heating, ventilation, and air conditioning equipment and associated hookup materials; plumbing fixtures, equipment, foundry, structural supports, and associated hook-up materials; and electrical fixtures, equipment, and associated hook-up materials.
6. The computerized method of claim 5 wherein the length and size of associated hookup materials are defined at the time the grouped items are selected.
7. The computerized method of claim 1, wherein the grouped items comprises at least two fixtures or equipment connected together with coupling materials.
8. The computerized method of claim 7, wherein the size of the coupling materials is calculated based at least in part upon stored building code and available coupling material size.
9. The computerized method of claim 8, wherein the calculated size of coupling materials may be manually overridden by a user.
10. In a computer system having a processor, a graphical user interface including a computer display, and an input device, a method for estimating material and labor costs of a construction project comprising: maintaining a first database of items and cost data associated with each of the items; grouping one or more of the items from the first database to define predetermined sets of grouped items, each of said predetermined sets of grouped items corresponding to a desired installation of the construction project; displaying a Take Off Sheet data entry screen on the computer display comprising quantity data cells corresponding to item size; entering one or more of the sets of grouped items onto said Take Off Sheet data entry screen based on the construction project; and calculating the estimated cost of the construction project based at least in part upon the cost data associated with the items in the selected set of grouped items.
11. The method of claim 10, wherein the selected grouped items is selected from the group consisting of heating, ventilation, and air conditioning equipment and associated hookup materials; plumbing fixtures, equipment, foundry, structural supports, and associated hook-up materials; electrical fixtures, equipment, and associated hook-up materials; industrial process equipment and associated hook-up materials; and fire protection equipment and associated hook-up materials.
12. The method of claim 11 , wherein the set of grouped items are grouped together according to a graphical representation of the grouped items.
13. The method of 12, further comprising identifying sizes and quantities of the grouped items from the displayed graphical representation.
14. The method of claim 12, wherein dimensions of grouped items are identified on the graphical representation of the grouped items and stored to a database of pre-defined grouped items.
15. The method of 14, wherein the dimensions of hook-up materials are defined by entering dimension units of measure in data boxes associated with the graphical representation of the grouped items.
16. The method of claim 15, wherein the graphical representation of the grouped items is displayed to the computer display prior to being entered onto said Take Off Sheet data entry screen.
17. The method of claim 10, wherein the items comprising the pre-defined grouped items are modified prior to being entered onto said Take Off Sheet data entry screen.
18. The method of claim 17, wherein the modified grouped items are stored to the database of pre-defined grouped items.
19. The method of claim 12, wherein two or more sets of grouped items are combined to form a combined set of grouped items.
20. The method of claim 19, wherein dimensions of the combined set of grouped items are identified on the graphical representation of the combined grouped items and stored to a database of pre-defined grouped items.
21. The method of claim 19, wherein the sets of grouped items comprise at least two fixtures or equipment that are connected together with coupling materials.
22. The method of claim 19, wherein the coupling material size is calculated by the processor based at least in part according to code requirements.
23. The method of claim 22, wherein the code requirements are selected from the group consisting of building codes, plumbing codes, engineering codes, and governmental codes.
24. An automated system for estimating a cost of selected equipment for a construction project comprising: a. an first database containing construction items and material and labor cost data associated with each of the items; b. a second database containing one or more of the items from the first database that define predetermined sets of grouped items, each of said predetermined sets of grouped items corresponding to a desired installation of the grouped items in the construction project; and c. a computer executing a cost estimating software program and accessing the second database for users to select grouped items, said cost estimating software program retrieving information from the second database, and providing a cost estimate of the construction project based at least in part upon the selected grouped items data.
25. The automated cost estimating system of claim 24 further comprising graphical illustrations of grouped items wherein the computer executing a cost estimating software program displays graphical illustrations of the selected grouped items.
26. The automated cost estimating system of claim 24 wherein the items and sets of grouped items are stored in a common database.
27. The automated cost estimating system of claim 24 wherein the software program provides a series of instructions that prompt a user to enter appropriate estimate data.
28. The automated cost estimating system of claim 24 wherein the software program estimates construction project costs for selected grouped items and hook-up materials and automatically includes associated equipment and hardware related to the selected grouped items and hook-up materials.
29. The automated cost estimating system of claim 28, wherein the associated equipment and hardware related to the selected grouped items and hook-up materials is defined by a user.
30. A computerized system for estimating the material and labor costs of a construction project comprising: a remote server on a communications network managing software programs and databases; a central database associated with the remote server, said central database storing construction material specifications and graphics, labor cost data, and material pricing data; and a local computer on the communications network executing a material and labor cost estimating program, accessing data from the central database for use by the material and labor cost estimating program, and generating one or more reports for material and labor cost estimates for the construction project.
PCT/US2001/024873 2000-08-09 2001-08-09 Material and labor cost estimating method and system WO2002013108A1 (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
AU2001286421A AU2001286421A1 (en) 2000-08-09 2001-08-09 Material and labor cost estimating method and system

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
US22396300P 2000-08-09 2000-08-09
US60/223,963 2000-08-09

Publications (1)

Publication Number Publication Date
WO2002013108A1 true WO2002013108A1 (en) 2002-02-14

Family

ID=22838721

Family Applications (1)

Application Number Title Priority Date Filing Date
PCT/US2001/024873 WO2002013108A1 (en) 2000-08-09 2001-08-09 Material and labor cost estimating method and system

Country Status (3)

Country Link
US (1) US20020026343A1 (en)
AU (1) AU2001286421A1 (en)
WO (1) WO2002013108A1 (en)

Cited By (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US7337151B2 (en) 2003-01-17 2008-02-26 California Distribution Center, Inc. Automated pricing system
WO2008033101A1 (en) * 2006-09-13 2008-03-20 National University Of Singapore System and method for generating a bill of quantities
US7769595B2 (en) 2003-01-17 2010-08-03 California Distribution Center, Inc. Automated pricing and/or “Green” indicating method and system
US7783523B2 (en) 2003-01-17 2010-08-24 California Distribution Center, Inc. Automated pricing system
US8260628B2 (en) 2003-01-17 2012-09-04 Uniloc Luxembourg S. A. Automated pricing and/or “green” indicating method and system
US8266005B2 (en) 2003-01-17 2012-09-11 Uniloc Luxembourg Automated pricing system

Families Citing this family (88)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US7362775B1 (en) * 1996-07-02 2008-04-22 Wistaria Trading, Inc. Exchange mechanisms for digital information packages with bandwidth securitization, multichannel digital watermarks, and key management
US5613004A (en) * 1995-06-07 1997-03-18 The Dice Company Steganographic method and device
US6205249B1 (en) 1998-04-02 2001-03-20 Scott A. Moskowitz Multiple transform utilization and applications for secure digital watermarking
US7664263B2 (en) 1998-03-24 2010-02-16 Moskowitz Scott A Method for combining transfer functions with predetermined key creation
US7095874B2 (en) * 1996-07-02 2006-08-22 Wistaria Trading, Inc. Optimization methods for the insertion, protection, and detection of digital watermarks in digitized data
US7159116B2 (en) 1999-12-07 2007-01-02 Blue Spike, Inc. Systems, methods and devices for trusted transactions
US7177429B2 (en) * 2000-12-07 2007-02-13 Blue Spike, Inc. System and methods for permitting open access to data objects and for securing data within the data objects
US5889868A (en) * 1996-07-02 1999-03-30 The Dice Company Optimization methods for the insertion, protection, and detection of digital watermarks in digitized data
US7346472B1 (en) * 2000-09-07 2008-03-18 Blue Spike, Inc. Method and device for monitoring and analyzing signals
US7457962B2 (en) * 1996-07-02 2008-11-25 Wistaria Trading, Inc Optimization methods for the insertion, protection, and detection of digital watermarks in digitized data
US7730317B2 (en) * 1996-12-20 2010-06-01 Wistaria Trading, Inc. Linear predictive coding implementation of digital watermarks
US7664264B2 (en) 1999-03-24 2010-02-16 Blue Spike, Inc. Utilizing data reduction in steganographic and cryptographic systems
WO2001018628A2 (en) 1999-08-04 2001-03-15 Blue Spike, Inc. A secure personal content server
US6996503B2 (en) * 2000-04-27 2006-02-07 El-Con System Co., Ltd. System and method for take-off of materials using two-dimensional CAD interface
US20040243540A1 (en) * 2000-09-07 2004-12-02 Moskowitz Scott A. Method and device for monitoring and analyzing signals
US7127615B2 (en) 2000-09-20 2006-10-24 Blue Spike, Inc. Security based on subliminal and supraliminal channels for data objects
US20020103710A1 (en) * 2000-12-29 2002-08-01 Brian Como System and method for an automated virtual jobsite office
WO2002054173A2 (en) * 2001-01-03 2002-07-11 Gerber Scientific Products, Inc. Automation of construction and decoration projects
US7720703B1 (en) * 2001-02-05 2010-05-18 Trimble Navigation Limited System and method for tracking and managing construction projects
US7283975B2 (en) * 2001-02-05 2007-10-16 Broughton W Curtis System and method for tracking and managing construction projects
US20020116239A1 (en) * 2001-02-21 2002-08-22 Reinsma Jeffrey Dean Systems and methods for optimizing building materials
US20030069716A1 (en) * 2001-10-09 2003-04-10 Martinez David Frederick System & method for performing field inspection
US7287275B2 (en) 2002-04-17 2007-10-23 Moskowitz Scott A Methods, systems and devices for packet watermarking and efficient provisioning of bandwidth
JP2003345483A (en) * 2002-05-29 2003-12-05 Toshiba Corp Information processing apparatus and window size control method used therein
US20040054568A1 (en) * 2002-07-01 2004-03-18 Bradley Gary J. Automated construction project estimator tool
US20040225513A1 (en) * 2002-07-27 2004-11-11 Brad Haeberle Method and system for obtaining service contract information
US20040148288A1 (en) * 2002-07-27 2004-07-29 Brad Haeberle Method and system for obtaining operational data and service information for a building site
US7337191B2 (en) * 2002-07-27 2008-02-26 Siemens Building Technologies, Inc. Method and system for obtaining service related information about equipment located at a plurality of sites
US20040143510A1 (en) * 2002-07-27 2004-07-22 Brad Haeberle Method and system for obtaining service information about one or more building sites
WO2004036356A2 (en) * 2002-10-17 2004-04-29 Litz Michael W Method and system for detailed construction estimating
US20040117267A1 (en) * 2002-12-13 2004-06-17 Kilburn Mary Jo Engineering data interface and electrical specification tracking and ordering system
US7587061B1 (en) 2002-12-23 2009-09-08 Pacenti James R Symbol recognition system software and method
US20040148209A1 (en) * 2003-01-28 2004-07-29 Church David E. System and method for producing an infrastructure project estimate for information technology
US8249999B2 (en) * 2003-11-14 2012-08-21 International Business Machines Corporation Systems and method for costing of service proposals
US7389255B2 (en) * 2003-11-25 2008-06-17 Robert Formisano Dynamic residential construction cost estimation process
US20060080279A1 (en) * 2004-10-13 2006-04-13 Jones Ryan K Customized and customizable engineering calculation and project detailing system
US7246036B2 (en) * 2004-12-08 2007-07-17 Armstrong International, Inc. Remote monitor for steam traps
US20060149687A1 (en) * 2005-01-05 2006-07-06 Houseraising, Inc. System and method for automated management of custom home design and build projects
US20060185275A1 (en) * 2005-02-07 2006-08-24 Yatt Barry D Method and system for building, designing with and managing elements of construction
US20060179012A1 (en) * 2005-02-09 2006-08-10 Robert Jacobs Computer program for preparing contractor estimates
US8458009B1 (en) * 2005-10-14 2013-06-04 J. Scott Southworth Method and system for estimating costs for a complex project
US20070112692A1 (en) * 2005-11-01 2007-05-17 Cindy Bolduc Drawing Take Off System
JP4277861B2 (en) * 2006-02-23 2009-06-10 コニカミノルタビジネステクノロジーズ株式会社 Image processing apparatus, control program thereof, and control method thereof
US9451195B2 (en) * 2006-08-04 2016-09-20 Gula Consulting Limited Liability Company Moving video tags outside of a video area to create a menu system
US20080312980A1 (en) * 2007-06-13 2008-12-18 International Business Machines Corporation Method and system for staffing and cost estimation models aligned with multi-dimensional project plans for packaged software applications
US8055606B2 (en) * 2007-06-13 2011-11-08 International Business Machines Corporation Method and system for self-calibrating project estimation models for packaged software applications
US8032404B2 (en) 2007-06-13 2011-10-04 International Business Machines Corporation Method and system for estimating financial benefits of packaged application service projects
US20080313008A1 (en) * 2007-06-13 2008-12-18 International Business Machines Corporation Method and system for model-driven approaches to generic project estimation models for packaged software applications
US8065123B2 (en) 2007-09-10 2011-11-22 Autodesk, Inc. Systems and methods for performing quantity takeoff computations from computer aided design drawings
US20090198539A1 (en) * 2008-02-06 2009-08-06 Leonard Buzz Onscreen takeoff incorporating typical areas system, method and computer product
US20090287517A1 (en) * 2008-05-19 2009-11-19 Xerox Corporation Automated method and system for opportunity analysis using management qualification tool
US8244608B2 (en) * 2008-07-28 2012-08-14 Autodesk, Inc. Takeoff list palette for guiding semi-automatic quantity takeoff from computer aided design drawings
US20100100405A1 (en) * 2008-10-17 2010-04-22 Green Wizard, Llc Method and Apparatus for Determining and Managing Sustainability Ratings
US20100275147A1 (en) * 2009-04-24 2010-10-28 Rockwell Automation Technologies, Inc. Industrial energy demand management and services
US20100274612A1 (en) * 2009-04-24 2010-10-28 Rockwell Automation Technologies, Inc. Utilizing sustainability factors for product optimization
US8321187B2 (en) 2009-04-24 2012-11-27 Rockwell Automation Technologies, Inc. Process simulation utilizing component-specific consumption data
US8892540B2 (en) 2009-04-24 2014-11-18 Rockwell Automation Technologies, Inc. Dynamic sustainability search engine
US10013666B2 (en) * 2009-04-24 2018-07-03 Rockwell Automation Technologies, Inc. Product lifecycle sustainability score tracking and indicia
US10223167B2 (en) * 2009-04-24 2019-03-05 Rockwell Automation Technologies, Inc. Discrete resource management
US9129231B2 (en) * 2009-04-24 2015-09-08 Rockwell Automation Technologies, Inc. Real time energy consumption analysis and reporting
US20100274603A1 (en) * 2009-04-24 2010-10-28 Rockwell Automation Technologies, Inc. Dynamic sustainability factor management
US9406036B2 (en) * 2009-04-24 2016-08-02 Rockwell Automation Technologies, Inc. Discrete energy assignments for manufacturing specifications
US9087309B2 (en) * 2009-12-03 2015-07-21 Siemens Industry, Inc. Sales estimating tool with alternate estimating
US8738190B2 (en) 2010-01-08 2014-05-27 Rockwell Automation Technologies, Inc. Industrial control energy object
US9274518B2 (en) 2010-01-08 2016-03-01 Rockwell Automation Technologies, Inc. Industrial control energy object
US20120265692A1 (en) * 2011-04-14 2012-10-18 Gerald Gerber System and method for project estimates
US9116923B2 (en) 2011-10-06 2015-08-25 Trimble Navigation Limited Construction drawing evaluation systems and methods
US9811612B2 (en) * 2013-02-26 2017-11-07 On Center Software, Inc. Multi condition takeoff in construction project software programs
US9377985B2 (en) * 2013-03-15 2016-06-28 Xerox Corporation Method and apparatus for utilizing personal computing resources for mobile print conversion and routing
US9911163B2 (en) 2013-03-15 2018-03-06 Rockwell Automation Technologies, Inc. Systems and methods for determining energy information using an organizational model of an industrial automation system
US9501804B2 (en) 2013-03-15 2016-11-22 Rockwell Automation Technologies, Inc. Multi-core processor for performing energy-related operations in an industrial automation system using energy information determined with an organizational model of the industrial automation system
US9423848B2 (en) 2013-03-15 2016-08-23 Rockwell Automation Technologies, Inc. Extensible energy management architecture
US9842372B2 (en) 2013-03-15 2017-12-12 Rockwell Automation Technologies, Inc. Systems and methods for controlling assets using energy information determined with an organizational model of an industrial automation system
CA2853270A1 (en) * 2013-05-31 2014-11-30 Francois Lepage Method and system for project planning and estimation
US20150254587A1 (en) * 2014-03-10 2015-09-10 International Business Machines Corporation Estimates using historical analysis
WO2015139086A1 (en) * 2014-03-17 2015-09-24 Ethereal Holdings Pty Ltd Method of preparing an application to make an improvement to a site
US9798343B2 (en) 2014-11-25 2017-10-24 Rockwell Automation Technologies, Inc. Quantifying operating strategy energy usage
US9785126B2 (en) 2014-11-25 2017-10-10 Rockwell Automation Technologies, Inc. Inferred energy usage and multiple levels of energy usage
US9798306B2 (en) 2014-11-25 2017-10-24 Rockwell Automation Technologies, Inc. Energy usage auto-baseline for diagnostics and prognostics
US20180101883A1 (en) * 2016-10-10 2018-04-12 Gary Duncan Method of Selling Exterior Iron door with Customized Interchangeable Forged Scrollwork Insert
US10311529B1 (en) 2018-06-05 2019-06-04 Emprove, Inc. Systems, media, and methods of applying machine learning to create a digital request for proposal
CN108921619A (en) * 2018-07-12 2018-11-30 上海精智实业股份有限公司 A kind of data capture method, device, computer equipment and medium
CN110895619A (en) 2018-09-13 2020-03-20 开利公司 Fire extinguishing system-end-to-end solution for fire extinguishing sales and design
CN110895614A (en) 2018-09-13 2020-03-20 开利公司 Fire extinguishing system-pipeline design artificial intelligence auxiliary and visual tool
CN110895863B (en) * 2018-09-13 2023-06-23 开利公司 Fire detection system-method for automatically placing fire equipment
CN110895632A (en) 2018-09-13 2020-03-20 开利公司 Fire suppression system-system and method for optimal nozzle placement
US11030709B2 (en) 2018-10-29 2021-06-08 DIGIBILT, Inc. Method and system for automatically creating and assigning assembly labor activities (ALAs) to a bill of materials (BOM)
US10997553B2 (en) 2018-10-29 2021-05-04 DIGIBILT, Inc. Method and system for automatically creating a bill of materials

Citations (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5920849A (en) * 1997-01-22 1999-07-06 Quickpen International Corp. Systems and methods for evaluating building materials

Family Cites Families (14)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US4181954A (en) * 1971-05-19 1980-01-01 Chevron Research Company Computer-aided graphics system including a computerized material control system and method of using same
US4353117A (en) * 1979-12-28 1982-10-05 Chevron Research Company Method of diagnosing errors off-line in pipe specification files of a computer-aided graphics system
US4782448A (en) * 1985-10-04 1988-11-01 Judith Titton Contract estimating system utilizing a digitizing ruler
US4847761A (en) * 1987-09-24 1989-07-11 International Business Machines Corp. Automated bill of material
US5119307A (en) * 1989-12-22 1992-06-02 General Electric Company Method and system for automated bill-of-material generation
JPH06325110A (en) * 1993-05-17 1994-11-25 Nec Corp Sheet metal cad system
US5517428A (en) * 1994-05-02 1996-05-14 Williams; David Optimizing a piping system
US5918219A (en) * 1994-12-14 1999-06-29 Isherwood; John Philip System and method for estimating construction project costs and schedules based on historical data
US5764519A (en) * 1995-03-08 1998-06-09 Hitachi, Inc. Method and device for computing material requirements
US5793632A (en) * 1996-03-26 1998-08-11 Lockheed Martin Corporation Cost estimating system using parametric estimating and providing a split of labor and material costs
US5893082A (en) * 1996-12-23 1999-04-06 Mccormick; John M. System for processing and presenting cost estimates in the construction industry
US6037945A (en) * 1997-12-16 2000-03-14 Xactware, Inc. Graphical method for modeling and estimating construction costs
US6446053B1 (en) * 1999-08-06 2002-09-03 Michael Elliott Computer-implemented method and system for producing a proposal for a construction project
US6922701B1 (en) * 2000-08-03 2005-07-26 John A. Ananian Generating cad independent interactive physical description remodeling, building construction plan database profile

Patent Citations (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5920849A (en) * 1997-01-22 1999-07-06 Quickpen International Corp. Systems and methods for evaluating building materials

Cited By (7)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US7337151B2 (en) 2003-01-17 2008-02-26 California Distribution Center, Inc. Automated pricing system
US7769595B2 (en) 2003-01-17 2010-08-03 California Distribution Center, Inc. Automated pricing and/or “Green” indicating method and system
US7783523B2 (en) 2003-01-17 2010-08-24 California Distribution Center, Inc. Automated pricing system
US8260628B2 (en) 2003-01-17 2012-09-04 Uniloc Luxembourg S. A. Automated pricing and/or “green” indicating method and system
US8266005B2 (en) 2003-01-17 2012-09-11 Uniloc Luxembourg Automated pricing system
US8515820B2 (en) 2003-01-17 2013-08-20 Uniloc Luxembourg S.A. Automated pricing system
WO2008033101A1 (en) * 2006-09-13 2008-03-20 National University Of Singapore System and method for generating a bill of quantities

Also Published As

Publication number Publication date
US20020026343A1 (en) 2002-02-28
AU2001286421A1 (en) 2002-02-18

Similar Documents

Publication Publication Date Title
US20020026343A1 (en) Material and labor cost estimatting method and system
US7571392B2 (en) User definable task based interface
US4885694A (en) Automated building control design system
US20040205519A1 (en) Method and system for automatically generating construction documents
US20110246322A1 (en) System and Method for Intelligent Product Configuration and Price Quotation
US7562340B2 (en) Method for graphically building business rule conditions
US7644363B2 (en) “For-each” label components in CAD drawings
US7467122B2 (en) System for aiding the design of product configuration
EP1473645A2 (en) Establishing and maintaining a relationship between a three-dimensional model and related data
US20130311217A1 (en) One View Integrated Project Management System
Ivson et al. A systematic review of visualization in building information modeling
US8520531B2 (en) Isolation list creation program, method, and device
JP2009169778A (en) Plant construction simulation data creation method and system
US20130054284A1 (en) Templatized reporting engine
Coles et al. Spreadsheet modelling for management decision making
JP4351230B2 (en) Design document data generation system and design document data generation method
CN113190304A (en) Archive information display method and device, computer equipment and storage medium
JP3555397B2 (en) Equipment system operation management support system and method
JPH07141405A (en) Method and device for supporting design operation
US20200342146A1 (en) Filtering components compatible with a computer-modeled structure
JP2004272728A (en) System for estimating price of residence
Holder Automated Estimating System (AES)
Hirsch et al. DOE 2.2 and power DOE
JP6528416B2 (en) Business evaluation method, business evaluation program and business evaluation device
Smith et al. From Front-End to Final Testing: Detailed Heat Tracing from Plant 3-D Models

Legal Events

Date Code Title Description
AK Designated states

Kind code of ref document: A1

Designated state(s): AE AG AL AM AT AU AZ BA BB BG BR BY BZ CA CH CN CO CR CU CZ DE DK DM DZ EC EE ES FI GB GD GE GH GM HR HU ID IL IN IS JP KE KG KP KR KZ LC LK LR LS LT LU LV MA MD MG MK MN MW MX MZ NO NZ PL PT RO RU SD SE SG SI SK SL TJ TM TR TT TZ UA UG US UZ VN YU ZA ZW

AL Designated countries for regional patents

Kind code of ref document: A1

Designated state(s): GH GM KE LS MW MZ SD SL SZ TZ UG ZW AM AZ BY KG KZ MD RU TJ TM AT BE CH CY DE DK ES FI FR GB GR IE IT LU MC NL PT SE TR BF BJ CF CG CI CM GA GN GQ GW ML MR NE SN TD TG

121 Ep: the epo has been informed by wipo that ep was designated in this application
REG Reference to national code

Ref country code: DE

Ref legal event code: 8642

122 Ep: pct application non-entry in european phase
NENP Non-entry into the national phase

Ref country code: JP