This model uses an Excel VBA macro to import different data into a Time Series element based on user input through a dashboard drop-list. The user can choose to import streamflow data for a dry, average or wet year. Before running the model, the user must press a dashboard button ('Copy data for import'), which triggers the VBA macro, causing the correct data to be copied to the sheet from which the Time Series element imports.
Download the Model File:
Please sign in to leave a comment.