LookUp Tables allow the creation of
sets of common information of any type to be stored in a data file
for access at any time within EstimatorVJ.
Creating a LookUp Table
is extremely simple.
Create/Open
a Worksheet with the necessary Headings and Data desired, range
the data to be put into the LookUp table, click the button and
select the option 'Save this Worksheet as a LookUp', then give
the file to store this data in a name and click Save.
By default, all LookUp Tables
are stored in a folder called 'LookUp' in the current Projects
Folder ('Estdata8'), however if you so wish these can be stored
anywhere.
The data file created will
contain as the first line, the Headings that were selected during
creation, and the data on subsequent lines. This ensures that
when the data is retrieved later on, the program can match and
insert the data into the matching columns of the destination worksheet.
Retrieving:
This is achieved by
first accessing the LookUp Table. Click the button and select
the option 'Load a LookUp Worksheet' then select the LookUp Table
from the Open File dialog.
Having done this, a lefthand pane
will open up, showing the contents of this LookUp (just like the
RC List panel in a Rate/Cost workup sheet).
|