Excel Tips

From Tuflow
Jump to navigation Jump to search

Introduction

This page describes the tips and tools for setting up and reviewing TUFLOW models.

General Tips

Adding an Add-in

    To add the Excel TUFLOW Tools to your Excel. Follow the process outlined below, which should work for both Excel 2007 and Excel 2010:
  1. Download the TUFLOW Tools Excel Add-in (TUFLOW_Tools_v2.0.xlam) this is available from the downloads section of the TUFLOW website.
  2. Go to the File tab and select Options.
    3. Excel Add Addin Step1.png
  3. Navigate to the Add-Ins section. In the Manage Section, select Excel Add-Ins from the drop-box and then hit the Go... button.
    4. Excel Add Addin Step2.png
  4. In the Add-Ins dialogue, select Browse... and navigate to the "TUFLOW_Tools_v2.0.xlam" file downloaded from the TUFLOW website.
  5. Ensure the tick box next the TUFLOW_Tools_v2.0 is selected and hit OK.
    6. Excel Add Addin Step3.png
  6. The TUFLOW Tools Add-Ins should now be loaded every time Excel is started. A new menu item should be visible, as per the image below.
    7. Excel TUFLOW Tools v2.png

TUFLOW Add-ins

As per the image above, the following items will be added. These tools are described separately in the pages linked below.


Up
Go-up.png Back to Main Page
Retrieved from "https://wiki.tuflow.com/w/index.php?title=Excel_Tips&oldid=42420"