Excel Tips: Difference between revisions

Browse history interactively

← Older edit

Content deleted Content added

VisualWikitext

Revision as of 13:25, 13 September 2011 view source tuflow>Par →TUFLOW Add-ins ← Older edit		Latest revision as of 16:35, 20 February 2025 view source Emilie Nielsen (talk \| contribs) Administrators 6,412 edits No edit summary
(4 intermediate revisions by 3 users not shown)
Line 1: =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!]]~~. =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>[~~http~~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]] Line 16 ⟶ 18: [[File:Excel TUFLOW Tools v2.png\|frame\|none]] </ol> =TUFLOW Add-ins= As per the image above, the following ~~three~~items will be added. These tools are described separately in the pages linked below. [[EXCEL_Tools_Plot_1D_Results \| Plot 1D Results]] ~~==ESTRY Tools==~~ ~~===~~[[EXCEL_Tools_Plot_PO_Results \| Plot 1DPO Results~~===~~]] [[EXCEL_Tools_Export_Active_Chart \| Export Active Chart]] ~~When you have 1D results open, select the '''Plot 1D Results''' option.<br>~~ [[EXCEL_Tools_Active_Sheet_to_CSV \| Export Active Sheet to .csv]] ~~You will be asked to input the number of series that you wish to plot simultaneously.~~ [[EXCEL_Tools_Entire_Workbook_to_CSV \| Export Entire Workbook to .csv]] ~~==TUFLOW Tools==~~ <br> ~~===Plot PO Results===~~ {{Tips Navigation ~~===Export Active Chart===~~ \|uplink=[[Main_Page\| Back to Main Page]] ~~==dbase Tools==~~ }} ~~===Active Sheet to csv===~~ ~~===Entire Workbook to csv===~~