Excel Tips: Difference between revisions
Content deleted Content added
No edit summary |
No edit summary |
||
| (6 intermediate revisions by 3 users not shown) | |||
Line 1:
=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]]
}}
| |||