Sampling table functions

A place for Ventity software questions & answers
Post Reply
Junior Member
Posts: 7
Joined: Thu Mar 09, 2017 9:37 am
Vensim version: Ventity

Sampling table functions

Post by gsimpso4 » Fri Jul 14, 2017 12:17 pm

I have some tables holding estimates of the relationship between an input and an output.

Each table has multiple rows, representing different estimates of the relationship.

Each table is either from SME estimates (few rows) or from business analytics (many rows)

I would like to randomly sample among the rows in my tables, running my model across the samples and compiling distributions of the output.

Is there an example that shows how to do this?

Posts: 2567
Joined: Wed May 24, 2006 4:54 am

Re: Sampling table functions

Post by tomfid » Fri Jul 14, 2017 8:10 pm

We don't have an example unfortunately. (This is a bit exotic!) We'll ponder how to do it.

The basic idea would be to put the lookup in an entitytype (maybe by itself, one entity per table). You can supply the tables as a data source if you use Excel input (the builtin doesn't support lookups). Then assign your simulation a reference to the required lookup. One way to do that would be to use a Process List action to pick a lookup entity at random, and assign it's ID to whatever entity is using the table.

Post Reply