Page History

...

• Any Windows computer with Microsoft Excel.
• Excel Workbook Value List Builder and Value List Builder Scientist found in the ALL Things DESClogik folder. A copy exists under the expedition Value Lists folder, attached below, and an originals can be found in the following link; T:\IODP_Share\ALL things DESClogik\Value List Builder

Value List Builder.xlsm

Value List Builder Scientist.xlsmImage Removed
          

You must rename these files as captioned above after you open it.

...

After clicking the search icon (magnifying glass) in the VLB you will prompted to input your expedition number. The macros use this number to set the folder directory it will search. The folder directory/file structure should be consistent with other expeditions; otherwise, the macro will give you an error. Below is an example of the proper file structure. Note the underscore before the expedition folder.

VT:\IODP_Share\ALL things DESClogik_DESClogik_EXP371\Value Lists

...

• Exact Match Only and All Possible Matches Option (Callout 4).  The Exact Match Only option will restrict all search returns to exact matches only. Unselected, the search returns the nearest matches allowing for extraneous characters before and after the user value. For example, with the Exact Match Only option deselected the user value radiolarian might return radiolarian and with or radiolarian marl. This search only returns the first match found. The All Possible Matches option will continue to search through a list and return all matches found within. The exact match feature can be turned on or off.

...

The macro specifically references the names of the "Value List Builder.xlsm" and "Value List Builder Scientist.xlsm" workbooks and the sheet "Paste Your Values Here". DO NOT CHANGE the names of the workbook or the first sheet. If you change these names, you can simply rename them the originals, or replace the workbook with a copy from the other two locations.
The file path is specific and the file structure of your expedition needs to follow the example given below. Note, that there is an underscore before the expedition number.

VT:\IODP_Share\ALL things DESClogik_DESClogik_EXP371\Value Lists

...