Sliders with more than one variable

  • Thread starter Thread starter Bhaltair
  • Start date Start date
B

Bhaltair

Hello everyone. I'm a junior in college and I'm taking an ops class. My
teacher showed us how to make sliders, but I have a question on them.
Can you make a slider change 3 variables? I'm trying to do weighted
moving average forecasting and am curious howt0 a) make 3 variables = 1
(.6+.3+.1 etc.) or make the slider give more weight to the left side as
you scroll etc.
Any takers on helping me out?
E mail me or post here. Thanx!
 
If the result cell =1 then the third variable is =1-var1-var2
Make var2 dependent on the slider change
Make var1 =var2*2
 
Debra said:
If the result cell =1 then the third variable is =1-var1-var2
Make var2 dependent on the slider change
Make var1 =var2*2

From what I understand of what you wrote, Varity will always be 2* Var
2, right? I'm trying to change the Values of the variables like this -
Var1+var2+Var+=1
where Var 1 could equal one or .5 or any other number.

Solver has these for the values but I want to learn how to make the
graph with MAD and BIAS graphed as well with sliders for more than just
one variable.

Weighted Moving Ave 1 2 3 Total
α 0.17 0.62 0.21 1
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top