How to map one variable to another variable?

[husnafezaahmad]

Hello there!

I have this one question regarding on the model that i'm currently working with.

I have 2 variables; sorted marginal cost and sorted generation as show in figure below.

Screen Shot 2020-10-09 at 23.36.57.png (218.94 KiB) Viewed 3500 times

These two variables are mapped under the same subscript and both are actually correlate. But my problem is, how do i arrange these two variables that can give me an output like this;

Screen Shot 2020-10-09 at 23.46.39.png (238.5 KiB) Viewed 3500 times

Is it possible to do so?

[Administrator]

Can you upload the model? I'm sure it's possible, but we don't have enough information to help.

[Administrator]

Maybe vector elm map function is what you need?

You can use vector elm map to pick elements out from another subscripted parameter.

[husnafezaahmad]

Can you upload the model? I'm sure it's possible, but we don't have enough information to help.

Here it is

It's on the MARGINAL COST's view.

[husnafezaahmad]

Maybe vector elm map function is what you need?

You can use vector elm map to pick elements out from another subscripted parameter.

I tried using VECTOR ELM MAP as suggested, but it seems it didn't work (or maybe i used it wrong?)

[husnafezaahmad]

Anyone can please help me? :'(

[Administrator]

I'm not sure I understand what you need to do. Are you asking how to generate an Excel sheet with the parameters as you have them in your sheet?

[tomfid]

If the requirement is a table that interleaves marginal cost and generation, as in your example, I don't think there's a way to do that within Vensim.

[husnafezaahmad]

If the requirement is a table that interleaves marginal cost and generation, as in your example, I don't think there's a way to do that within Vensim.

Oh really? It's okay then.Thanks a lot Tom & Admin