Design > Project Development > Engineering Applications > EBASE
Explanation of EBASE
Getting access to EBASE
To use the EBASE program, you must first have EBASE installed on your PC. Contact your Workstation Support person or local Help Desk, they can do this for you.
• To get access to the EBASE server (DOTDBOLYHQ01P), contact Thomasa Hume-Pontius to submit a request for EBASE file permissions for your user ID.
EBASE for Local Agencies and the Private Sector
Unfortunately at this time, due to budgetary constraints, our plans for developing a module of EBASE for Local Agencies and Private entities have been put on hold. However it remains one of our goals.
Understanding the Bid Items tab
The Bid Items tab is used to enter the Biddable items of work, then to tie these items to the Groups/Columns of work and Funding sources.
Please see the illustration below which explains all of the Elements of the Bid Items Tab and their functions. or click on the image for a printable version.
How to set up Funds
The Funding tab is used to setup and manipulate the funding sources for estimates. This tab is comprised of three sub tabs, each of which must contain the proper elements before you may create a viable Fund.
FUNDS, the first tab.
Use this tab to create the numbered set that participants are to be assigned to. You may use any numeric sequence, e.g.. 1, 2, 3...; 5, 10, 15...; 10, 20, 30... These are only identifiers so that you may assign to them participants who will be contributing to the same Groups of work. Later these identifiers will be assigned to the each of the groups of work as they are created on the Groups tab.
PARTICIPANTS. the second tab.
Use this tab to list all of the Participants in the funding of the project. When entering each participant, it is necessary that each is named uniquely so that the estimate will properly calculate and print. e.g. FEDERAL, FEDERAL IM, FEDERAL STP. For Federal Participants, enter the full federal aid number in the space provided.
FUND/PARTICIPANT MATCHING, the third tab.
Use this tab to assign the identifiers from the FUNDS tabs to the PARTICIPANTS on the participants tab. Each Fund may be comprised of as few as 1 participant per fund (No Maximum amount may be assigned to funds with a single participant), or as many as 4. Please see the example below for an illustration of a typical funding scenario.
For more information please see the EBASE Users Guide.
An easy way to setup funds is to imagine them as buckets That each participant is going to help fill. See the funding situation above, described in the table below.
Participant and Sequence
|The State will contribute all the $$$ it takes finish paying for the work that is covered by Fund 5. In other words the State will finish filling up the bucket. Since there are only 3 participants in Fund 5, STATE will be entered as the Tertiary Participant in the fund by entering the number 3 as the funding sequence. 100% is entered under Participation Percentage, indicating the STATE will pay for 100% of what is left to pay in the fund after the first two participants have made their contributions. |
STATE will be a participant in most funds.
|Once the City of Twisp contributed their $10,000, the Feds are willing to pay 80% of the remaining work in this Fund. They are entered as the Secondary Participant in Fund 5 by entering the number 2 as the Funding Sequence, and 80% is entered under Participation Percentage. |
City of Twisp
|They are Contributing up to a Maximum Amount of $10,000. We want to use up as much of The $$$ they are willing to contribute as we can, So they are designated as the Primary Participant Of Fund 5 by entering the number 1 as the Funding Sequence, and a Participation Percentage of 100% So all of the $10,000 will be used. |
|The State will contribute all the $$$ it takes finish paying for the work that is covered by Fund 10. In other words the State will finish filling up the bucket. Since there are only 2 participants in Fund 10, STATE will be entered as the Secondary Participant in the fund by entering the number 2 as the funding sequence. 100% is entered under Participation Percentage, indicating the STATE will pay for 100% of what is left to pay in the fund after the first participant has made its contributions. |
STATE will be a participant in most funds.
|Feds are willing to pay 80% of the work this Fund is paying for. They are entered as the Primary Participant in Fund 10 by entering the number 1 as the Funding Sequence, and 80% is entered under Participation Percentage. |
|The State will contribute all the $$$ For THIRD PARTY DAMAGES. If STATE is not paying for the entire project, then a separate Fund must be setup to assign to your REIMBURSEMENT FOR THIRD PARTY DAMAGES group. |
This Fund, shown here as Fund 15 will contain STATE as the Primary, and only participant, Funding sequence 1 and Participation Percentage of 100%.
The Reimbursement for third party damages is set up this way so the Contract may be closed even if we have not recovered our costs for any damages repaired from the “Third Party” .
Mobilization must be calculated as a percentage of the Contract Total (work done Contractor) this is the dollar amount before the addition of tax or additives. The calculation is then entered into the estimate as a Lump Sum Bid Item that is Prorated across the applicable Columns of work.
Mobilization is a contract pay item that is used to cover a Contractor’s preconstruction expenses and also the costs of preparatory work and operations. Since there is no clear list as to what this work effort is and each Contractor has the ability to adjust their bid as needed to cover these expenses, there are no true rules as what percentage should be used per Contract. The following table is a suggested guide:
Less than $100,000 Use 8% to 12%
$100,000 to $250,000 Use 6 % to 10 %
$250,000 to $500,000 Use 6 % to 9%
$500,000 to $1,000,000 Use 5 % to 9 %
$1,000,000 to $2,000,000 Use 6 % to 9 %
$2,000,000 to $5,000,000 Use 7 % to 9 %
$5,000,000 to $10,000,000 Use 8 % to 10 %
$10,000,000 to $20,000,000 Use 7 % to 11 %
Over $20,000,000 Use 7 % to 10 %
To more accurately calculate the Mobilization percentage that should be used for each individual project, consideration should also be given to:
- The location of the project The complexity of the project
- The need for specialized equipment
- The type of work being performed
- Rural vs. Urban Projects with multiple work sites
- Excessive preparatory removal items
- Large quantities of excavation
- Spanning of constructions seasons when it would become necessary for the contractor to shut down and clear the work site between these seasons.
Entering 3rd party damages
Reimbursement for Third Party Damages is a required bid item for WSDOT projects. Minimum requirements for this bid item are: Planned Quantity = 5.00 Unit Price = $1.00 However each project should be evaluated to accurately determine it's needs. Some things to take into consideration when calculating a Planned Quantity for Third Party Damages on your project are: Does the project contain items that are highly susceptible to Third Party Damage? What are the project conditions? Urban or Rural location? High Traffic Exposure? Length of contract? Longer contracts have more exposure to the traveling public. Once the determination of what items are likely to be damaged, enter in the Planned Quantity, a dollar value that represents a reasonable cost of repair/replacement for the item. When assigning the bid item, Reimbursement for Third Party Damages, assign it to the largest PIN or the PIN that is most likely to sustain damages. This Bid Item will be paid for with State Funds only. Do not assign this Bid Item to a Column that is attached to a Group with Federal Funding.
Estimate & Bid Analysis System (EBASE) is a SQL server application built in Power Builder. EBASE provides the user with a friendly Windows type environment to create and manipulate project estimates and bid data for Construction Projects.
With this application one may enter the preliminary data in the Project Definition stage and continue to build on and modify the estimate as the project progresses.
EBASE also makes it easy to share estimates electronically. Anyone with access may view an estimate alone, or simultaneously with others, or access may be granted to users to manipulate and estimate during their involvement in the development process. Once they have completed their contribution, they may once again be limited to “view only” access.
In addition, after the project is advertised and bids are opened, EBASE receives the bids (manually or electronically), compares them to the estimate and creates the necessary management reports to allow the Contract Ad and Award office to select the lowest responsible bidder.
EBASE also maintains the Standard Item Table (S.I.T.) and the Unit Bid Analysis (U.B.A.).
EBASE updates the Mainframe files that populate the CAPS III, CCIS and PREQUAL systems tables. This data feed process allows for features such as electronic bid item lookup and bid price history at the click of a button.
The ultimate goal of EBASE is to provide users with a quick, reliable, flexible, and effective way to manage estimates and contract bid information, while eliminating duplicated effort and the need for side systems and databases with local offices.
Maintaining EBASE files
The EBASE Administrator within each Region is responsible for keeping their Region EBASE files organized and current.
There are four estimate sets that the Administrators need to be aware of:
Current Versions -
This file set displays only the most current version of all
estimates within the system.
This file set should ideally contain only the most
current version of the engineers estimate for projects that are being developed, on Ad or that have been awarded.
All Estimates -
This file set displays all versions of all the
estimates within the system [excluding version 99].
This file set should ideally contain the most current version of an estimate and perhaps one or two earlier versions.
This file set displays all versions of estimates that have
been deleted from the Current Versions and All Estimates file sets. This file will occasionally be purged by an EBASE Manager.
This file set is maintained as a back-up file, in case
the most current version of an estimate is
This file set displays the version 99 [true bids] version
of the estimate that is created when a project has
This file will be maintained by a system manager.
The Estimates in the AS-Built file are created from the version 99 Awarded estimate by making a New Version.
The AS-Built (version 100) estimate is to be used to modify the Awarded contractors estimated item quantities, to reflect actual constructed item quantities.
Contact your Region EBASE Administrator when the creation of an AS-Built estimate is needed.
It is recommended that each Region Administrator set up a regular maintenance schedule for deleting estimates in the Current Versions and All Estimates file sets. These deleted estimates will go to the Deleted file. An EBASE Manager will notify the EBASE Administrators prior to purging the “Deleted” file.
IMPORTANT: Check Estimates thoroughly before pushing the
“Load to Bids” button
(New info) EBASE MUST BE LOCKED BEFORE THE (WOA) and construction contract funding authorizations (CCFA). can be approved. (please read the DRAFT Program Management policy for EBASE and CCFA approval)
When a project is turned in for Advertisement the project must be locked, and loaded to the Bids module. To Lock and Load an estimate, On the General Info tab click the button that is labeled MOVE TO BIDS. This will load all the estimate information to the CAPS files and the Bids Module, as well as lock the estimate.
Should it become necessary to make revisions to the estimate that will affect the bids, use the Duplicate/New Version button on the General Info tab to make a new Version of the estimate. Make the revisions to this new version; click the MOVE TO BIDS button to load the revisions to the CAPS files, Bids Module, and to lock the estimate.
EBASE performs an automatic cursory review of each estimate to ensure that it is loadable. However this review is minimal, and only checks to see if enough data is entered on each tab to allow the load.
Before locking any estimate a review should be done by the Region Administrator.
Things to check for that EBASE will not catch:
- On L.S., CALC. And EST. bid items check to ensure that the Unit Price has been entered as 1.00, and that the total amount for the item is enter under Planned Quantity. The exception to this rule being Prorated L.S. items.
- A column may not have a total of less than $5.00.
- Zero quantities are not valid and will create erroneous results.
- Non Standard bid items are assigned to a Section Header, and have a Pre Qual Code.
- Non Bid Items are assigned to a Column.
- All columns that the bid items are assigned to must have a Planned Quantity entered.
- All Funds, Fund Participants, Bid Items, Groups and columns that are entered into the
estimate are used. Do not leave superfluous data in the estimate.
- Funds are matched to participants.
- Data for Individual groups on the Groups tab is complete.
- Engineering and Contingency % has been entered.
- Section Headers tab must not contain blank lines, if they exist, delete them.
For further information on EBASE Administrator functions, see EBASE Administrator in Chapter 2 – Level of users in the EBASE Users Guide.
Using the Filter function
Using the Filter Function in EBASE to extract data is cumbersome due to the fact that it must actually be Coded. Included here are some examples that should get you though in most cases.
An Existing Column must be selected to apply the Filter to. When filtering use the Columns box to select what to filter through (i.g. by double clicking on “Title” you will be specifying to look in the Titles Table).
NOTE: Available Column selections will vary depending on the screen you are filtering from.
PROJECT BY TITLE
Example… to find all projects that contained “Seismic” in the title. title like ‘%’+’SEISMIC’+’%’ (This is case sensitive, words in the title must be exact).
FIND AN ESTIMATE VERSION
Example… To find versions greater than 10. version_number >10
FIND BY CONTRACT NUMBER
TO FIND A RANGE
Example… To find a Planned Quantity range planned_quantity > 5,000 and planned_quantity < 10,000
TO FILTER BY 2 SETS OF CRITERIA
Example… To find a Planned Quantity + an Award Date on or after a specified date. (planned_quantity > 5,000 and planned_quantity < 10,000) and award_date >= date(yyyy,mm,dd) (enter your date in year, month, day)
TO FILTER BY 3 SETS OF CRITERIA
Example… In Eastern Region, to find a Planned Quantity + an Award Date on or after a specified date. (region_code= ‘6’) and (award_date >= date(yyyy,mm,dd)) and planned_quantity >=2
Special User Levels have been setup to accommodate entry into EBASE by Consultants who are preparing project estimates. However this access is available only if there is a WSDOT Consultant Liaison working within the Consultant office who has a WSDOT setup remote connection to the WSDOT network.
If this connection is available:
EBASE must be loaded on the PC. and The Consultant must possess a valid 6+1 WSDOT network ID.
- Contact the Region Help desk to have this application installed and to request a network ID for the Consultant.
Once the application has been installed And a Network ID established, Contact: Thomasa W. Hume @ 360.705.7456 To obtain access for data entry into EBASE, and for help in the use of the application.
Should no connection be available through a WSDOT Consultant Liaison:
The Consulting office should submit their Estimate data to the WSDOT Project Office they are working with. The Project Office will then enter the estimate data into EBASE. Last update: 3/27/2007
Training available via GoTo Meeting on request.
Please call Tomi @ 360.705.7456 to setup a session