Difference between revisions of "Excel Tips"
Jump to navigation
Jump to search
(2 intermediate revisions by 2 users not shown) | |||
Line 1: | Line 1: | ||
=Introduction= | =Introduction= | ||
− | This page describes the tips and tools for setting up and reviewing TUFLOW models | + | This page describes the tips and tools for setting up and reviewing TUFLOW models. |
=General Tips= | =General Tips= | ||
*[[EXCEL_setting_default_chart | Setting a default chart type]] | *[[EXCEL_setting_default_chart | Setting a default chart type]] | ||
Line 7: | Line 7: | ||
To add the Excel TUFLOW Tools to your Excel. Follow the process outlined below, which should work for both Excel 2007 and Excel 2010: | 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>[ | + | <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> | <li>Go to the '''File''' tab and select '''Options'''.</li> | ||
[[File:Excel Add Addin Step1.png|frame|none]] | [[File:Excel Add Addin Step1.png|frame|none]] | ||
Line 18: | Line 18: | ||
[[File:Excel TUFLOW Tools v2.png|frame|none]] | [[File:Excel TUFLOW Tools v2.png|frame|none]] | ||
</ol> | </ol> | ||
+ | |||
=TUFLOW Add-ins= | =TUFLOW Add-ins= | ||
As per the image above, the following items will be added. These tools are described separately in the pages linked below. | As per the image above, the following items will be added. These tools are described separately in the pages linked below. | ||
Line 25: | Line 26: | ||
*[[EXCEL_Tools_Active_Sheet_to_CSV | Export Active Sheet to .csv]] | *[[EXCEL_Tools_Active_Sheet_to_CSV | Export Active Sheet to .csv]] | ||
*[[EXCEL_Tools_Entire_Workbook_to_CSV | Export Entire Workbook 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 |
---|
![]() |