# Posts by giloopp

• ## Running Out Of Columns

Re: Running Out Of Columns

thanks...i am building a model from raw data...where columns build upon the calculation made in the previous columns....

• ## Optimal Combination Model With Constraints & Variables

Re: Representative Sample

Quote from Oskar

Hi!

There might be some mathematically way of calculating what is the minimum number of samples you need.

However, one way of determning it is to run the "simulation" a few times with, lets say, with 1% of the possible samples. How much does your answer change? If it changes only a "litle", then it is enough, if it changes "alot", then it is to few... So, whats litle/alot depends on the problem

using iterative sampling is what risk does...so I need to see how my output behaves from sample to sample?[hr]*[/hr] Auto Merged Post Until 24 Hrs Passes;[dl]*[/dl]

Quote from shg

How about using Solver with integer constraints?

i am going to use Evolver or OptQuest....Solver has still yet to be evaluated...thanks!

• ## Optimal Combination Model With Constraints & Variables

Hi!
I need to optimize an Excel model with 5 variables each of which cam be any value from 1 to 20. The solution space, therefore, contains 3,200,000 combinations. I have a software(Palisade Risk) which can give out a random sampling of this solution space. I need to know how many combinations can be considered as a representative sample of this solution space - e.g. can it be 1%?.
Thanks!!!
Dima

• ## View Multiple Sheets

Re: Window Split To Different Sheet

thank you for your reply but this method works only for complete workbooks while i need a way to see the worksheets of the same workbook side by side...[hr]*[/hr] Auto Merged Post Until 24 Hrs Passes;[dl]*[/dl]ahhh ...ok..i got resolved this....here is a great link which describes this:
http://www.bettersolutions.com/excel/EDO113/WO746653532.htm

• ## View Multiple Sheets

Hi!
I need to find a way to be able to see the contents of the other sheet while working on the current one. Excel has the window split feature but it works only on teh same worksheet. I wonder if there is a way or any plugin to see the contents of other sheet in the same manner. Thanking in advance for any opinion.
Dima

• ## Running Out Of Columns

Re: Running Out Of Columns

I need all the data in the spreadsheet at once since the calculation is interconnected...can you give me the link to how I can use excel formulas in acces?
thanks!

• ## Running Out Of Columns

Re: Running Out Of Columns

does access allow to use all the formulas excel does? thanks!

• ## Running Out Of Columns

Hi!
I am building a massive model in Excel and I am running out of the columns....only 2 left out of the 256 allowed. I need a lot more columns so I am seriously considering moving to Excel 2007. I need your advice - do you think this move is adequate given that I can overcome this column limitation by continuing to build my model in the other sheets and cross-linking them? I will be using Solver or Evolver later on so I am concerned how these perform on Excel 2007. I am more concerned with the speed of excel 2007 when it comes to handling large workbooks.
ANY thoughts are highly appreciated!
Dima

• ## Plot On Chart/Graph As Zigzag Pattern

Re: Plot On Chart/Graph As Zigzag Pattern

thanks....let me check it out!

• ## Plot On Chart/Graph As Zigzag Pattern

Re: Plot On Chart/Graph As Zigzag Pattern

thanks..but i need such a graph without modifying the data series...((

• ## Plot On Chart/Graph As Zigzag Pattern

Hi!
I have the following list of values which I want to plot as a zigzag. But when i create a line chart from them, the lines connect the zeros and the non-zero points - while I want the lines to connect only the non-zero points - so that there is a zigzag-like pattern shown...I wonder if this can be done..Thanks!

the Data:

0
0
0
0
0
1.4343
0
0
0
0
0
0
0
0
1.4332
0
0
0
0
0
0
0
0
1.4318
0
0
0
0
0
0
0
0
0
1.4521
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
1.5153
0
0
0
0
0
0
1.5336
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
1.55
0
0
0
0
0
0
0
0
0
0
0
0
0
0
1.5431
0
0
0
0
0
0
0
0
0
1.5472
0
0
0
0
0
0
0
0
1.5404
0
0
0
0
0
0
0

Dima

• ## Best Practice For Large Model

Re: Best Practice For Large Model

thanks Bill for your explanation......the genetic optimizer is used to solve problems with extremely large number of variables and constraints....i know evolver and solver which do these tasks....i wonder if anyone have experience working with these on genetic optimization tasks....[hr]*[/hr] Auto Merged Post Until 24 Hrs Passes;[dl]*[/dl]

Quote from Dave Hawley

Me too, so it's not you, Reafidy.

That's like saying; "I'm going to build a House that will need proping up later".

Prevention is better than cure and a good foundation IS everything. See EFFICEINT spreadsheet designs

i am building more a calculator than a static model....which will adapt to the various input[hr]*[/hr] Auto Merged Post Until 24 Hrs Passes;[dl]*[/dl]i apologize but i think that your new title is not much more informative than my original one - "Genetic Optimizer"

• ## Best Practice For Large Model

Hi!
Can you please recommend some good genetic optimizer for Excel? I am building a big model in Excel which needs to be optimized later. I am thinking of Evolver...
Thanks!!!
Dima

• ## Chart Series Data Source From Another Sheet

Hi!
I have some data entered on different sheets of the same workbook. I select these tables and then try to make a line chart but it only includes the series from the first sheet. I wonder if it is possible to include the data series from the other wroksheet into the chart.
Thanks!

• ## Count/Sum Non-Contiguous Cells By Condition

Re: Count/Sum Non-Contiguous Cells By Condition