1 / 16

Phase, Addon & Formula

Phase, Addon & Formula. Database concepts. information is stored into FOLDERS FILES collection of related information: .DAT, .PEE RECORDS information about one thing : item, phase, formula FIELDS individual pieces of information that make up the record. Database & Estimate Files.

alaric
Download Presentation

Phase, Addon & Formula

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Phase, Addon &Formula

  2. Database concepts • information is stored into • FOLDERS • FILES • collection of related information: .DAT, .PEE • RECORDS • information about one thing : item, phase, formula • FIELDS • individual pieces of information that make up the record

  3. Database & Estimate Files • PES.DAT • Precision Estimating Standards file contains records that define phases, subcontractors, material classes, addons and formulas • PEI.DAT • Precision Estimating Items file contain records that define items

  4. Database & Estimate Files • ESTIMATE NAME . PEE • Precision Estimating Estimate file contains data that defines a particular estimate (takeoff)

  5. Setting up of database • the database that you build is the foundation for all “future” estimates • PrEcIsIoNeStImAtInGiScAsEsEnSiTiVe

  6. Database General Information • general information consists of information about your company, such as the name & address, & other information including: • phase code format (number of decimals) • 3.000 or 3000.00 • number of working hours per day & per week

  7. Creating / Editing Database • PHASES • basic building blocks for the database are • group phases (yellow) • regular phases (cyan) • items (green)

  8. Group Phase • HIGHEST LEVEL of the database (most general) • represents a general work category (division) • 3.000 Concrete • 4000.00 Masonry • group phase help organize regular phases & items

  9. Regular Phase • represents types of work or types of material • 3.100 concrete formwork • 3200.50 concrete reinforcing

  10. Items • LOWEST level of the database • represents specific task or material • c20 slab on grade 20 mpa • used for takeoff to create estimate and where costs are stored

  11. Phases & Items • PHASES & ITEMS are identified by a code & a description • they can be alpha-numeric

  12. Addons ( markup ) • profit, bond fee, permit fee, insurance fee, overhead, sales tax • each is identified by three digit numbers which you define • can be set up to be allocated across those items from which it was earned • the cost of supervision can be allocated across those items that include labor ( L ) as a cost category

  13. Formula Basics • formulas • convert drawing dimensions into quantities • are stored as part of the database • are attached to items • are made up of standard mathematical symbols and variables

  14. Formula Basics • variables are the values you specify during takeoff • wall length’ • conc. depth” • the rules of algebraic logic apply • left to right within parentheses • * and / operation performed first • then + and - operations are performed

  15. Formulas in takeoff window SF Conc Wall Forms = Length’ x Height of all Wall’

  16. Formulas • sheets of drywall • wall length’*wall height’/32 • givespart sheets • Roundto( wall length’ * wall height’ /32,1,1) • gives complete sheets • number of studs • IF( stud spacing =16, wall length’ /1.33, wall length’ ) + (2 * # of openings)+( # of corner or intersection )

More Related