Difference between revisions of "Excel Tips"

From Tuflow
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. If you have any suggestions to be included in these pages, please add them to the discussion page. [[Talk:Excel_Tips | Please add Excel Suggestions Here!]].
 
This page describes the tips and tools for setting up and reviewing TUFLOW models. If you have any suggestions to be included in these pages, please add them to the discussion page. [[Talk:Excel_Tips | Please add Excel Suggestions Here!]].
 +
=General Tips=
 +
*[[EXCEL_setting_default_chart | Setting a default chart type]]
 
=Adding an Add-in=
 
=Adding an Add-in=
 
<ol>
 
<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:
 
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>[http://www.tuflow.com/ TUFLOW website]</u>.</li>
+
<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 16: 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 23: 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 10:57, 23 January 2023

Introduction

This page describes the tips and tools for setting up and reviewing TUFLOW models. If you have any suggestions to be included in these pages, please add them to the discussion page. Please add Excel Suggestions Here!.

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
  4. Navigate to the Add-Ins section. In the Manage Section, select Excel Add-Ins from the drop-box and then hit the Go... button.
  5. Excel Add Addin Step2.png
  6. In the Add-Ins dialogue, select Browse... and navigate to the "TUFLOW_Tools_v2.0.xlam" file downloaded from the TUFLOW website.
  7. Ensure the tick box next the TUFLOW_Tools_v2.0 is selected and hit OK.
  8. Excel Add Addin Step3.png
  9. 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.
  10. 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