Ventana software support forum

If it's reporting "does not exist" you probably have a path error. Change the equation to GET XLS DATA('?mydata', 'Sheet1' , '1' , 'B2' ) and it will query you to locate the file when you run the model. (Be sure that it's not open in Excel, because Excel locks the file.) I try to use my l...

If it's reporting "does not exist" you probably have a path error. Change the equation to GET XLS DATA('?mydata', 'Sheet1' , '1' , 'B2' ) and it will query you to locate the file when you run the model. (Be sure that it's not open in Excel, because Excel locks the file.) When running the ...

Administrator wrote: ↑Thu May 07, 2020 7:18 pm Change the equation for DATA from
GET XLS DATA('INPUT DATA.xlsx', 'Sheet1' , '1' , 'B2' )
to
GET XLS DATA('INPUT DATA.xls', 'Sheet1' , '1' , 'B2' )

It doesn't work, report same error.

You could also try saving it in an older format (XLS file). Although you cannot see any issues, the text cells have geographical data embedded within them, I'm not sure how you would remove it. Yes, it works when use an older format. The data can import into Vensim. But, when I run the model, the e...

ok, that spreadsheet has some extra info attached to the cells A1 and A2 which are causing problems when importing. It will be fixed in the next release. If you edit cell A1, the contents are 'Time, delete the ' from the start of it. Sorry, I don't really understand edit cell. Especially the conten...

I managed to get it to import. Edit cells A1 and A2 and delete the ' from the start of the cell. Save and now try importing. What version of Excel did you create this spreadsheet with? I was wondering did you mean delete the A1 and A2, then try importing. If yes, it is still an error, said: Unable ...

Administrator wrote: ↑Thu May 07, 2020 12:05 pm Can you upload the Excel file?

This is the Excel file

Hello everyone, I try to import database into Vensim, it awalys report an error said Unable to parse the data file. The reason might be that when importing database, Vensim did not recognize the data's name. But, in the excel, the name is set. I have tried many times and it still doesn't work. So I ...

For the constant elasticity curve, see: https://www.vensim.com/documentation/24335.htm The width and elasticity parameters are always positive, though for a demand curve, it will be interpreted as negative, e.g. p^(-e). Hi, I have read the link, I also read the User Guide of Vensim, but I have a li...

If you check the dropdown error menu, you will find that there are more issues: USE FLAG: -total demand- is not used in the model. USE FLAG: -total supply- is not used in the model. ERROR: Simultaneous equations involving: demand satiation[d1]. : market price. : current price. : effect price. : dem...

What you're doing here is basically double-counting the price elasticity effect. The allocation functions already assume a supply curve and demand curve, with elasticities that are implicit for a given choice of width and ptype (shape) parameters. Hi, the ptype (5) is constant elasticity, I am not ...

Dear sir I need to build the relationship between price and demand. So, throug price elasticity, compare the current price with past price to get the effect of price chages on demand. But, when I build it in model, it doesn't work. The error is some value is not used in the model. I think it maybe b...

You've mixed up the subscripting by deleting the "demander" dimension. Therefore FIND MARKET PRICE is iterating over suppliers on one side of the market, and durations on the other side. The solution is to preserve the demander range, with length 1: demander : total Then use that in the d...

If you step through the elements of "priority vector" you will find that the first element has [duration,supplier,ptype] and the next has [duration,supplier,pprofile]. That doesn't work because pprofile is the range. If you replace it with the element ppriority it should work. Hi, thanks....

Hi, I have solved the question that I asked above and there is only one demander. but when I discretize the demand into multiple segments to represent different needs at different times of every year, and each segment should be equalibrium. the model reports an error, but I don't know how to solve i...

It should work as you've described, if the dimensionality of demand is reduced to 1. The demand priority should be greater than the max supply priority, to ensure that demand is always fulfilled. If you want stepwise allocations, the width parameter needs to be narrow. Yes, it is solved. Thank you ...

Hi, Following the above question, I would like to ask. If I have only one demander and the goal is to achieve the balance between supply and demand, how to use the find market price function. For example, the suppliers (a,b,c) with certain capacityies and prices at which they sell. capacities (suppl...

I think the thing to do is to discretize the LDC into a number of segments, represented by an array dimension. Then you can compute utilization of each plant type in each segment. Then the price is the highest-cost plant with nonzero utilization in the segment. (The allocation functions might make ...

tomfid wrote: ↑Wed Dec 11, 2019 11:59 pm No problem - we can delete one. Is this the better copy?

Yes, it is the better one.
Please help me to delete the another one.
Thank you

I am so sorry that I ask the question twices.
I resubmitted the question due to typographical erros.
Say sorry again to everyone.

Hi, I am working on a model that simulate the long-term investment behavior for electricity market. In order to betwer simulate this behavior, I need to calcualte the profit by simulating the price under different demand load for each hour of the year. So, I need to build the load duration curve, it...

This attached model would mimic what you are say you want to achieve. There is a lot more that goes into modelling the electricity market. Good luck! Do note that this is a quick job so I didnt align the units. Reading the documentation and what others have posted before about these functions are v...

Hi, I am preparing to build a model of the electricityt market, which has a question about merit order of capacity. It is a typlical problem of building a supply curve and dispatching. For example, I have 3 suppliers: 10(a), 20(b), 5(c) The supplier has different costs: 1, 2, 3 Demand: 29 Price: 2.8...

tomfid wrote: ↑Mon Oct 14, 2019 6:35 pm I don't know what any of this means, but with a corrected expression it works:
FIND ZERO 2.mdl

I see. Thank you for your help.

The simple model