Special Worksheet Criteria

NOTE-- We retired the MacNail estimating program in 2000, and replaced it with Goldenseal construction estimating software. There are still a significant number of die-hard MacNail users, so we keep the manuals online for them! Goldenseal is an integrated program that also includes accounting, scheduling and contract writing. It has a Find command which finds records, similar to the Criteria section of worksheets that is described here.

Finding Estimating Data

The Criteria section will help you to find some very specialized selections from any worksheet in the MacNail construction management software, if you use it creatively.

To find all items in a particular category, type the category code into the cat column. Then use Data--Find to jump to those records.

To find new items in the same category, type a second criteria into the flag column. If there are more than one criteria, only items matching all criteria will be found.

To find items with a code number greater than 2000, erase the previous criteria, and type >2000 under the code column.

To find all flagged items, erase the previous criteria, and type >aa under the flag column.

To find all items with a blank category, erase the previous criteria, and type = (equal sign) under the cat column.