how to SPEED VARIABLES EVALUATION

HI ALL!

I have a very big variables table with much IF to drive 

a lot of numbers, and every time i make a variation on  a line

it takes a lot of time to re evaluate every thing,

do some one knows if and how can i 

speed all this??

 

thank y so muchSmiley Happy



Boomic
6 REPLIES

Re: how to SPEED VARIABLES EVALUATION

Solution Partner Phenom Solution Partner Phenom
Solution Partner Phenom

Try turning off automatic update on the tools tab.

LMGi
www.TLMGi.com

Re: how to SPEED VARIABLES EVALUATION

Honored Contributor
Honored Contributor

Get a faster computer.

Re: how to SPEED VARIABLES EVALUATION

I don't know if really this is the problem..

i have an i7-6700 cpu 3.40GHz with 32 GB of RAM

and a a GEFORCE GTX 750 ti WITH 2GB of memory.

 

my SE file is only 3,2 MB, but has something like 200 variables

and every time ai change a line

or a simple cell or add a new one

it takes 20-25 sec for refreshing every thing.

 

I would like to know if there is some settings where 

to decide if and when let SE do the refreshing

 

thank you again

 



Boomic

Re: how to SPEED VARIABLES EVALUATION

Solution Partner Phenom Solution Partner Phenom
Solution Partner Phenom

So the Automatic Update setting seems to help when working with Excel files linked to the variable table.

It also helps when editing dimensions directly.

It does not help when working in the Variable Table itself.

Maybe  you should call that in to your reseller to file an IR so we can make the software better.

LMGi
www.TLMGi.com

Re: how to SPEED VARIABLES EVALUATION

Honored Contributor
Honored Contributor

In general, I only have the variable open when they need to be edited. Having the variable tabel open at all really slows things down. Close the variable window and updates are much faster.

Re: how to SPEED VARIABLES EVALUATION

Thank you for your responses!

 

I found that if opened through an assembly

my 200 user variables are much faster to edit.

I could write all the rules (trigonometrics and IF statements) of my sheet file

In an excel, but i pointed to give the main part of  intelligence to

SE (and also because really it's much simple)

 

I worked calculating all necessary in user variables part

and finally  giving the elaboration to quotes and suppressions.

 

Im now trying to transfer a part of this work to  a .bas file with VB.

Will let you know

 

Thanks again

 

 



Boomic