Skip to main content

On-Screen Takeoff makes finding/accessing the information you need easy. You can use a variety of sorting, searching, filtering, and grouping options, each detailed below.

Sorting

Most lists in On-Screen Takeoff can be sorted in ascending (1,2,3,a,b,c) or descending (c,b,a,3,2,1) order by clicking once or twice on the column header. An upward pointing triangle indicates ascending order while a downward pointing triangle means descending order. The triangle also indicates which column is being used as the sort key.

Clicking on headers sorts by that column, up arrow indicates ascending sort, down arrow indicates descending sort

In most lists, typing in the first few characters of an entry in the sort key column moves your focus to the first matching entry in the list.

For example, if the above list was sorted by Project Name, typing in "F" would put focus on Bid 25 - "Finish Carpentry & Millwork".

Searching

There are several ways to search the master tables when entering information. For example, to assign an owner when you are creating a new Style Set, type in the first one or two letters of the name of the Estimator (to be assigned as "Owner") and On-Screen Takeoff auto-fills the box with a matching name. If there are multiple matches (for example, type in "BR" - the program finds "Brown" and "Bradford") the drop down list is filtered to what is typed. The more letters typed in, the more refined the filtering is until only one match is left.

Type Ahead

Whenever a Search box is displayed (any text box with the magnifying glass next to it), use "Type Ahead" to quickly locate an existing entry.

The lookup button The Lookup button looks like a magnifying glass and opens a Master list where you can select an existing entry opens the Employee List in this example.

Filter boxes support 'type-ahead' filtering/selecting - type the first one or two characters and matching results are displayed
In the example above we typed "sa" into the Estimator box and the program located the first entry "Sample Estimator" from the Employee list.

Use type-ahead filtering to quickly locate bids or records in pick lists
In the example above, we typed "24" into the Style box - the program shows a list that includes only those entries from the Style Library that begin with "24".

Using Type Ahead improves efficiency and reduces the risk of creating duplicate entries in the database.

The more characters you type, the more refined the list becomes - when there is only one selection left, On-Screen Takeoff will automatically insert that selection.

On-Screen Takeoff's database support 'on-the-fly' data entry. This means, if a record doesn't exist when you type it in a Lookup box, the program prompts you to add it to the Masters. This way, you do not have to build your Master records first, before you start using the program - add them as you need them!

Filtering

Most lists in On-Screen Takeoff can be filtered by using Filter boxes. The Filter boxes for a list will always appear at the top of the list. Some Filter boxes allow an estimator to make a selection from a list in the Filter box, and others require the estimator type in information. For Example, on the Bids Tab, there are four filters: Project Name, Estimator, Job No., and Job Status. Filter boxes for all other lists and tabs are similar in function to these.

Bids Tab filters help you locate a specific project quickly, just be sure to clear them when you locate the correct project

  • Some Filters are open entry text boxes (for example, Project Name and Job No. on the Projects Tab). To locate a specific project or bid in the list by Project Name, type in the one or two letters of the Project Name - the list is filtered to matching entries (the more letters typed in, the more refined the filtering is). In the Example above, we've typed "PL" and only those projects whose Project Name contain that sequence are shown.
  • Some Filter boxes are drop down lists (Estimator and Job Status on the Projects Tab) - click on the arrow Click drop-down arrows to open a list of existing records to see a list of available filters. Drop down lists pull from the available list of records for a particular field. In the case of "Estimator" on the Projects Tab, those estimators who are assigned "Logins" in their Employee Details show up in the drop down.

Filters are persistent - remember to clear the Filter(s) after locating the appropriate Bid, they do not automatically clear.

If you forget to clear previously set Filters, you may have problems trying to create a new Project (for example, if you used the letter "X" as a Filter in Project Name, you could not create a Project that didn't include that letter in its Project Name - the program would prevent it).

Grouping Lists

In addition to being sorted or filtered, many lists can be grouped.

For example, the Projects Tab can be grouped by Job Status, the Condition List can be grouped by Type, and the Summary Tab can be grouped by Page, Type, Zone, or Area.

Keep reading this chapter for information on the Projects, Takeoff, Summary, and Estimate Tabs.

click here to view the previous article The Difference Between a Select and an OK Dialog Box Using Imperial or Metric (SI) Units of Measurement (UOM) click here to view the next article

 

Related Articles

 

Be the first to reply!

Reply