Search found 60 matches

by kong17
Mon Oct 14, 2019 4:25 pm
Forum: Vensim
Topic: The question about Find Zero function
Replies: 5
Views: 2782

The question about Find Zero function

Hi, everyone I want to achieve this equation 1111.png when the equation equal to zero, find the value of p . So, I used Find Zero function to solve it. But, when I run the model, the simulation results are incorrect 22222.png This is because the denominator cannot be 0. And, when I change the initia...
by kong17
Tue Aug 06, 2019 5:13 pm
Forum: Vensim
Topic: Is there an equation for counter in Vensim?
Replies: 2
Views: 1777

Is there an equation for counter in Vensim?

Dear all I want to achieve the function in Figure The time step is month. I was wondering how to achieve it in vensim? If the time boundaries is 120. I try to use IF THEN ELSE and LEVEL. Each time step, the price will be accumulated. IF THEN ELSE=12, price/12,0 IF THEN ELSE=60, price/60,0 But, it on...
by kong17
Fri Feb 15, 2019 1:10 pm
Forum: Vensim
Topic: Question about import dataset into Vensim
Replies: 7
Views: 3509

Re: Question about import dataset into Vensim

Can you upload your file? I've tried importing it and it worked. You can also try importing the file from C:\Users\Public\Vensim\Models\UserGuide\CHAP18\CALIBRAT\ Thank you. It worked. I found the file in C:\Users\Public\Vensim\Models\UserGuide\CHAP18\CALIBRAT\ But, I was wondering how to create th...
by kong17
Fri Feb 15, 2019 12:47 pm
Forum: Vensim
Topic: Question about import dataset into Vensim
Replies: 7
Views: 3509

Re: Question about import dataset into Vensim

Administrator wrote: Fri Feb 15, 2019 12:36 pm What menu options are you clicking to import the data?
Model > Import Dataset
by kong17
Fri Feb 15, 2019 12:02 pm
Forum: Vensim
Topic: Question about import dataset into Vensim
Replies: 7
Views: 3509

Question about import dataset into Vensim

Hello everyone, I am learning the Optimization in Vensim. But, when I wanna import dataset, Vensim always report the error. I followed Venism Help to do it. I don't know what is wrong with that? I was wondering could anybody help me to solve it? Thank you very much! The step from Vensim Help step.JP...
by kong17
Fri Aug 31, 2018 4:44 pm
Forum: Vensim
Topic: Export and import data between Vensim and Excel
Replies: 11
Views: 6921

Re: Export and import data between Vensim and Excel

Hi what is your problem? Every year, I suppose that you have to take some décisions. which décisions? How is the cash flow of the year dependant from past Investments? it would be useful to upload a very small model to illustrate your problem. Regards. JJ Thank you all for your replies. I am new to...
by kong17
Fri Aug 31, 2018 4:44 pm
Forum: Vensim
Topic: Export and import data between Vensim and Excel
Replies: 11
Views: 6921

Re: Export and import data between Vensim and Excel

IRR makes sense for one-time investments. I'm not sure how you would integrate that into a continuously-evolving control system. Normally the cash flow would be the instantaneous cash flow; the purpose of smoothing is to convert the variable or stochastic flow into a more stable expectation. Capita...
by kong17
Thu Aug 23, 2018 5:06 pm
Forum: Vensim
Topic: Export and import data between Vensim and Excel
Replies: 11
Views: 6921

Re: Export and import data between Vensim and Excel

I don't think you really want IRR anyway, because it operates over a fixed period. For adaptive behavior, you want some kind of moving-average perception of rate of return. That could be as simple as SMOOTH(cash flow)/(capital investment). In my model, I need to get profitability index. IRR is very...
by kong17
Thu Aug 23, 2018 4:43 pm
Forum: Vensim
Topic: Export and import data between Vensim and Excel
Replies: 11
Views: 6921

Re: Export and import data between Vensim and Excel

why do you want to calculate the IRR out of Vensim? Because the function exists in Excel? It is much simpler to calculate the IRR in Vensim, than exchanging data between vensim and excel. to calculate the IRR, you must find the zero of the NPV, that i think is calculated in Vensim. to find the rate...
by kong17
Thu Aug 23, 2018 12:26 pm
Forum: Vensim
Topic: Export and import data between Vensim and Excel
Replies: 11
Views: 6921

Export and import data between Vensim and Excel

Hell @all I am having a question: I want to calculate the internal rate of return(IRR). The cash flow and investment costs will be changed every year, so the IRR is different every year. I try to use IRR function in Vensim, but it is not available. Then I find that Vensim and Excel could export and ...