Skip to content

Making Connections

isee systems blog

Making Connections

  • About
  • More Connections
Search

Tip: Setting up imports for 2D Graphical Functions

Updated: February 19, 2009January 29, 2009Filed under: Modeling Tips8 Comments

iThink and STELLA version 9.0 introduced a powerful new feature: data import and export with Excel.  Here at isee, we were excited to hear from our customers about how much they appreciated the feature and how easy it was to use.  In fact, many customers told us that it was the major reason they upgraded to version 9.0
simple import 1

Setting up a data import from Excel is pretty straight forward:  type the name of the model variable in one cell, type the value you want to import in the cell below it, (or beside it if you are using horizontal orientation):

If you are importing a time series or graphical function, you just keep listing the data points in the cells below the variable name:

simple import 2

This kind of data formatting works well since an Excel sheet is made up of columns and rows.  But how do you format data that is harder to visualize?  Things get a little tricky when you start dealing with arrayed variables.  The most complex import is a 2 dimensional array of graphical functions.  It’s actually 3 dimensions!

I’ve put together a simple example to illustrate how to do this.

Let’s say you have a model set up to look at 3 teams’ performance on 3 different projects.  The model has an array of Projects and Teams. The Project dimension has 3 elements: Project 1, Project 2 and Project 3.  The Team dimension has 3 elements: Team 1,Team 2 and Team 3.

In this model we’ll put down a converter called “Performance rates” which we’ll later define as a 2D array of graphical functions over time.  The converter will contain historical data on the various teams performance rates for the various projects.

You can see how this sort of setup is pretty close to what someone would want to do – track performance over time per project per team.

The format of the Excel spreasheet would look like this:

Project 1   Project 2   Project 3
Team 1 Team 2 Team 3 Team 1 Team 2 Team 3 Team 1 Team 2 Team 3
                 
Performance rates … … *** … … *** … …
100 34 63 98 87 18 20 14 3
45 25 78 69 35 99 25 13 25
67 53 23 100 43 78 98 55 76

Notice that the Team 2 and Team 3 columns have an ellipsis (…) in the header that indicates the column is still part of the Project 1 array element.  Start the next array element, Project 2 with 3 asterisks  (***) at the top of the column.

This is important: The converter name is listed first, then then an ellipsis for each element of the team dimension, (since Team is our first dimension).  The Project dimensions are delimited by the *** and of course the time data goes down.

After setting up your spreadsheet, you  need to set the converter correctly.

Converter Dialog:

Converter

In the converter dialog, first check Array, change it from 1D to 2D, (Teams and Projects) and leave Apply to All checked.

Click on the “Become Graphical Function” button on the lower left.  This will switch to the Graphical Function dialog.

Graphical Function Dialog:

graphical_function

Uncheck Apply to All and be sure you have 3 data points set up for each Row/Column combination.  This corresponds to the three time data points we set up going down in the Excel sheet.

Import dialog

Data imported!
The data has been imported into the conveter

Open the Import Data dialog under the Edit Menu. Set up the link so that you are pointing to the spreadsheet you just created.

Select the Import Type you want and browse for the Excel file and worksheet you created.  The data orientation you pick should match the orientation of the spreadsheet.

Once you click OK, a message will let you know if data was successfully imported or not.

Now check to see that the data was imported by hovering over the arrayed variable.

It worked!! You’re good to go.

 >> Download the Sample Files

 

Modeling Tips
  • 2D array
  • arrays
  • graphical function
  • import

Post navigation

Previous Post:

isee.NET Framework 1.1 – Powering isee NetSim Server

Next Post:

Modeling Learning Network for Health & Social Care

About the Author

Sarah Davie

All posts bySarah DavieWebsite

Hide

Categories

  • Education (4)
  • isee NetSim (3)
  • isee.NET Framework (1)
  • Modeling Tips (32)
  • News & Announcements (15)
  • STELLA & iThink (14)
  • Stories from the Field (5)
  • Systems Thinking (8)
  • Training (6)

Archives

Browse by keyword

2D array archetypes arrays Barry Richmond Bass diffusion builtins calibration Causal Loop CLD command line conferences crisis data diffusion Education environment export game graphical function h1n1 healthcare housing import iThink/STELLA market dynamics MODSIM modules mortgage netsim optimization Physics policy price releases scholarship software spatial Stella storytelling System Dynamics Society Systems Thinking Version 9.1.2 video webinar workshop

Recent Posts

  • COVID-19: Modeling Distributions of Incubation and Recovery Times April 1, 2020
  • Multiobjective Optimization January 9, 2018
  • Optimizing Model Performance December 22, 2017
  • Calibration in Stella® December 15, 2017
  • Drifting Goals March 9, 2016

RSS System Dynamics Forum

  • Closing Learning Gaps with Systems Thinking Education
  • How to Review for the International System Dynamics Conference 2025
  • Accelerating Sustainability Education with System Dynamics: A Community-Based Strategy
  • System Dynamics in Policy Design: A Case Study from India’s Renewable Energy Sector

Recent Comments

  • best apps review on About
  • digital software on Modeling the Economic Crisis
  • Mishawaka Indiana on What are “Mental Models”?
  • La Paz Indiana on XMILE – An open standard for system dynamics models
  • Bristol Indiana on Modeling the Economic Crisis

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
Products
Software (v1.3)
  • Stella Architect
  • Stella Professional
  • Stella Designer
  • Stella Simulator
  • iThink
  • Feature Updates
  • Policies
  • Publishing Options
  • License Agreement
Free Software
  • Stella Online
  • isee Player
  • Stella Architect Trial
Solutions
Consulting
  • Systems Innovation Practice
Common Applications
  • Business
  • Education
  • Research
  • Government
  • Energy
  • Health
  • Agriculture
  • Manufacturing
  • Conservation
Quick Links
About
  • isee systems
  • Systems Thinking
  • Barry Richmond Scholarship
Resources
  • Frequently Asked Questions
  • Product Help
  • Examples
  • Request Support
  • Request Quote
  • Systems in Focus
  • Quick Tips
  • Legacy Tutorials
News and Events
Upcoming Workshops
  • Introduction to Dynamic Modeling
  • Whole Systems Partnership
Newsletter
  • The Connector
Recent Webinars
  • Model Mysteries
Recent Training
  • Systems Thinking Practice
Press Release
  • Stella Architect Release

  Phone: (603) 448-4990   Email: info@iseesystems.com

   Monday - Friday: 9:00 am - 5:00 pm EDT | Saturday - Sunday: Closed
Wheelock Office Park | 31 Old Etna Rd, Suite 7N | Lebanon, NH 03766 | US

isee systems inc. holds registered trademark rights over the following: iThink®, STELLA®, Stella®, isee systems® and claims the following trademarks; isee NetSim™, Stella Live™, Causal Lens™ and Stella Online™.

Terms of Use

© 2017. isee systems inc . All rights reserved.