Difference between revisions of "Excel Tips"
Jump to navigation
Jump to search
| (6 intermediate revisions by 3 users not shown) | |||
| Line 1: | Line 1: | ||
| − | Excel | + | =Introduction= |
| + | This page describes the tips and tools for setting up and reviewing TUFLOW models. | ||
| + | =General Tips= | ||
| + | *[[EXCEL_setting_default_chart | Setting a default chart type]] | ||
| + | =Adding an Add-in= | ||
| + | <ol> | ||
| + | To add the Excel TUFLOW Tools to your Excel. Follow the process outlined below, which should work for both Excel 2007 and Excel 2010: | ||
| + | |||
| + | <li>Download the TUFLOW Tools Excel Add-in (TUFLOW_Tools_v2.0.xlam) this is available from the downloads section of the <u>[https://www.tuflow.com/ TUFLOW website]</u>.</li> | ||
| + | <li>Go to the '''File''' tab and select '''Options'''.</li> | ||
| + | [[File:Excel Add Addin Step1.png|frame|none]] | ||
| + | <li>Navigate to the '''Add-Ins''' section. In the '''Manage''' Section, select '''Excel Add-Ins''' from the drop-box and then hit the '''Go...''' button.</li> | ||
| + | [[File:Excel Add Addin Step2.png|frame|none]] | ||
| + | <li>In the '''Add-Ins''' dialogue, select '''Browse...''' and navigate to the "TUFLOW_Tools_v2.0.xlam" file downloaded from the TUFLOW website.</li> | ||
| + | <li>Ensure the tick box next the '''TUFLOW_Tools_v2.0''' is selected and hit '''OK'''.</li> | ||
| + | [[File:Excel Add Addin Step3.png|frame|none]] | ||
| + | <li>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.</li> | ||
| + | [[File:Excel TUFLOW Tools v2.png|frame|none]] | ||
| + | </ol> | ||
| + | |||
| + | =TUFLOW Add-ins= | ||
| + | As per the image above, the following items will be added. These tools are described separately in the pages linked below. | ||
| + | *[[EXCEL_Tools_Plot_1D_Results | Plot 1D Results]] | ||
| + | *[[EXCEL_Tools_Plot_PO_Results | Plot PO Results]] | ||
| + | *[[EXCEL_Tools_Export_Active_Chart | Export Active Chart]] | ||
| + | *[[EXCEL_Tools_Active_Sheet_to_CSV | Export Active Sheet to .csv]] | ||
| + | *[[EXCEL_Tools_Entire_Workbook_to_CSV | Export Entire Workbook to .csv]] | ||
| + | <br> | ||
| + | {{Tips Navigation | ||
| + | |uplink=[[Main_Page| Back to Main Page]] | ||
| + | }} | ||
Latest revision as of 16:35, 20 February 2025
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:
- Download the TUFLOW Tools Excel Add-in (TUFLOW_Tools_v2.0.xlam) this is available from the downloads section of the TUFLOW website.
- Go to the File tab and select Options.
- Navigate to the Add-Ins section. In the Manage Section, select Excel Add-Ins from the drop-box and then hit the Go... button.
- In the Add-Ins dialogue, select Browse... and navigate to the "TUFLOW_Tools_v2.0.xlam" file downloaded from the TUFLOW website.
- Ensure the tick box next the TUFLOW_Tools_v2.0 is selected and hit OK.
- 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.
TUFLOW Add-ins
As per the image above, the following items will be added. These tools are described separately in the pages linked below.
- Plot 1D Results
- Plot PO Results
- Export Active Chart
- Export Active Sheet to .csv
- Export Entire Workbook to .csv
| Up |
|---|
 Back to Main Page
|