Ventana software support forum

Many thanks Bob. I will follow this through

Best regards

Roger

thanks Tony - yes I remember our discussion and your answer well - however during a more recent discussion with Lee I understood him to say that Vensim could do it. I had hoped there was some new functionality that I had missed. Could you check with him to confirm I have misunderstood. I use this so...

A feature that I use a great deal in ithink is CYCLETIME. This function calculates how long it takes entities to flow through one or more sequential stock-flows on a FIFO basis. The flow where material enters the chain is 'time stamped' and then the CYCLETIME function is applied to outgoing flow to ...

Hi

1. Is there a shortcut way of displaying all subscipts within a custom graph and/or table without having to define each combination individually?

2. Can you have more than 6 variables/subscripts in any one graph or table, and if so how do you add variables?

Many thanks

Roger

this seems to work really well - thanks Lee

Rog

many thanks Lee


Best regards

Rog

thanks Lee - this is great Now the Vensim model makes it much clearer. It gives me a great start - I shall experiment with this What is the significance of the ? in '?data.xls' - I thought you needed the whole filename ie 'xlsdatafile.xls' - is this some kind of useful shorthand? Does the datafile a...

Thanks Lee

yes it does - thanks


Please see marked up spreadsheet with call out questions

Rog

I have built a client model which pulls in data from an Excel spreadsheet using GET XLS DATA and GET XLS CONSTANTS using Names in the formulae - works very well. I now want to make the model multi-dimensional using subscripts Please advise or point me in the right direction in order to determine: 1....

hi JJ

this really is much appreciated

Roger

Thanks so much for this JJ - I agree, subscripts offer a much more elegant and simpler solution. Can I try a scenario on you? A key margin dynamic in the mobile telecoms market is switching customers from commodidy voice and text services to high value data services. Take any customer segment and su...

Bob - this is great - you were right of course

Many thanks for such swift reply.

I like the sound ot this parsing idea - do you have a simple example?

Regards

Roger

Thanks Tony

Here are model and spreasheet

Challenge: I am building a dynamics Balanced Scorecard for the telecoms sector of a global IT company. The model will be fed by over 200 variables each month via an Excel spreadsheet captured from a BI solution. Some time sreries data, most constants. The model also has about 50 lookups which will a...

Versions Sable: 5.1.185 Vensim: 5.5c Problem: (Precise steps and dialogue feedback) Downloaded and unzipped all sable tutorial files into designated folder: E:sable_tutorial Loaded Predator_Prey.mdl and resaved as a binary format ensuring that the suffix was changed manually to .vmf (workaround for ...

Can Vensim return elapsed time taken for items to travel through a defined route in a the structure? This is needed to capture the actual leadtime for customers to undergo transistion form one state (level) to another. Please advise?