So, because I hate solver and can't get it to do anything I want, can someone help me out with just creating a simple loop.
http://www.excelforum.com/showthread.php?t=641046
Check that thread for a sample/explanation of what I want to do.
I was thinking all of yesterday that I was going to have to figure out how to throw all this Data into MatLAB somehow and then just create a simple nested loop to vary those weighting values. Then I realized I'm sure you can do the same in VBA, I just don't have a clue how.
So here's what I'm thinking I want it to do:
Vary weighting 1 from .01 to 1 in increments of .01
.....Vary weighting 2 from .01 to 1 in increments of .01
..........Vary weighting 3 from .01 to 1 in increments of .01
...............Vary weighting 4 from .01 to 1 in increments of .01
....................Check the % of correct against initial % correct
....................If current % correct > initial % correct record weighting values 1-4
....................If current % correct < initial % correct, leave it
....................Increase weighting 4 by .01
...............End Loop
...............Increase Weighting 3 by .01
..........End Loop
..........Increase Weighting 2 by .01
.....End loop
.....Increase Weighting 1 by .01
End Loop
End
Should be pretty simple, can someone help me out with that?
Also, if you could link me to a tutorial on how to actual put a script into Excel properly that would be helpful, but if not I'll just search around myself
Thanks so much!
Bookmarks