Ventana software support forum

I was wrong. The model actually doesn't use previous available hours... It finally seems like I have a problem with my subscripts, preventing the model to compare the whole demand to the limit of 1900 hours/year. I mean, the model considers I have 1900 hours/year for each building, and shares it bet...

Dear, I would like to better understand how the "allocate available" function works, as I cannot manage to do what I expected... Here is what I wish to represent : - every year, I have a certain amount of time available for working : 1900 hours/years - every year, I have tasks to achieve t...

Yes, you're right, thanks !

Laura

Oops, sorry !

I hope this is what you were talking about

Here we go !

Okay, I found the solution ! ALLOCATE BY PRIORITY ( hr demand[batiments,type de tache,type d effectif] , priority rank[batiments,type de tache,type d effectif] , elmcount(type de tache) , 1 , available time[batiments,type de tache,type d effectif] ) This works !! BUT there is still something I canno...

In attachment the same model using available time !

Thanks

It effectively computes something ! But now I have a floating point error message computing allocate time at time 1, whenever using total available time hours/year or available time as the supply stock. Once again, I don't know what this message means in my situation, do you have any idea about what...

I'm sorry, the model I'm working on is a terrible mess as I'm trying many different things to make it work...
But I isolated the variables involved in the view 5, I hope it will be okay for you to work with this...

Thanks a lot,

Laura

Hello, I'm again in trouble with the ALLOCATE BY PRIORITY function ! I managed to do what you advised me earlier, in the previous messages of this topic. I thought it worked well, but I realize that in this configuration, the allocation of time for every building was compared to the total time avail...

Hi, I am in trouble with the error message "simultaneous equations" ! I would like to build some kind of constraints in my model but I can't figure out how to avoid the simultaneous equations. For instance : -> I compute the variable "BIM investment cost", and I want to compare i...

Hi,
Thank you a lot for your help, it's working !!

Laura

Hi, It might be a problem of Excel version : with a computer using Excel 2010, the model works perfectly. With my usual computer using Excel 2016, I get error messages such as "Unable to connect to Excel". I've tried your suggestions (registering the document as .xls [97-2003] ; changing t...

Hi, I'm sorry, I still can't manage to do what I want. I did not find examples treating several subscripts at a time. I tried many things, but I guess I miss something and I don't know what. I tried to map the two subscripts [buildings] (15 elements) and [renovation scenarios] (3 elemnts) to the sam...

When I run the simulation, the correct file opens in Excel, but Vensim keeps sending the error message "Failed to connect to Excel to get data from Location.xlsx" - "Unable to get constant values"

Here we go !

It works very well ! I'm trying now to do the same for "price/m²" with GET XLS LOOKUP. But I keep having error messages "Failed to connect to Excel". The two useful documents are opened in Excel, I saved them in the same file and updated the path in Model>Settings, but still I ca...

Yes, VECTOR SELECT seems to be an appropriate way, but this function makes me crazy and I don't really know how to put it in my case, I need to deepen my reading of the documentation... Especially as I have the same problem with VECTOR RANK, that takes :NA: as 0 and keeps :NA: values as the best one...

You're right, using a random function in Excel was not one of my best ideas... oops ! Thanks for that ! Thanks to the model you sent me, I now better understand what GET XLS SUBSCRIPTS is made for. I thought it was to do something like this : location[Building1,Building2,Building3]=x1,x2,x3 where xn...

Hi ! I'm in trouble using GET XLS SUBSCRIPT function... Is it well a function to give the values of a subscripted variable that I want to populate ? If yes, I'll need your help to manage this... My first question is related to the VDF conversion box, opening when importing the dataset. I can't under...

Thank you for answering so fast !

Multiplying :NA: by 0 didn't work, it made 0 instead of suppressing the value...
I will try with the "999999" and have a look on VECTOR SELECT, and I'll let you know if I manage to make it work.

Thanks

Hi, How can I exclude :NA: from the solutions when using VMIN(x[i!]) ? Example : TRB[Building 1,scenario 1] = 3 TRB[Building 1, scenario 2] = 2 TRB[Building 1, scenario 3] = :NA: VMIN(TRB[Building 1, scenarios!]) = :NA: <== How can I make it "2", the "next" min value, and not tak...

In attachment: In this model I put a variable ROI 2. Here is the kind of results I would like to obtain (for instance, the first line ==> Building1;Scenario1 : ROI = 5 years) But I would like to have these results at the begining of the simulation in order to be able to make a decision on which scen...

Levelized Cost of Energy [...] is an economic assessment of the cost of the energy-generating system including all the costs over its lifetime: initial investment, operations and maintenance, cost of fuel, cost of capital. A net present value calculation is performed and solved in such a way that f...