Solver/Data Tables - help pls :)

L

Latika

Sorry to repost. But if someone can help, I would be much indebted...I have
an assignment for school due in 4 hours!!

Thank you!!

Hi,

I have created a one-entry data table with 1000 trials. I want to use
Solver to minimize the average value in the data table by changing weights on
a corresponding portfolio. However, when I manually change the weights and
then ask Solver to re-solve, it gives me a different result. Any one have
any ideas? Does Solver not work well with data tables? Is there a way
around this?

Thank you!!
Latika
 
A

Art

Latika,

Not sure I can help, but I need more info to give it a shot.

The data table has 1000 rows. As I understand it in a data table you would
typically have one or more formulas that are calculated. This calculation is
done on each row for the corresponding value in your data table.

Do you have multiple formulas that you want to weight? Where are the
weights? Are you trying to weight something going down over the 1000 trials?

I'm sorry but I'm really having trouble picturing what you're trying to get
done.
 

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

Similar Threads


Top