Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

Automatic formulas and order of computation

2 replies [Last post]
Rafael Davila
User offline. Last seen 5 hours 59 min ago. Offline
Joined: 1 Mar 2004
Posts: 5229

Formulas order of computation

 

At times I would like to control in an easy way the order of computation of formulas, this on an easier way than using scripts. Perhaps a special formula definition that will run a series of formulas in a sequence of my choice. This in combination to the ability to make it automatically would be welcomed, as this is a functionality I use very frequently on all of my schedules.

Perhaps any of you can give me a suggestion, if I am missing something, other than recording a macro script, easy but not as direct, at times when in a hurry, you forget about the macros, I want it to be automatic whenever I chose it to be.

Regards,

Rafael

Replies

Rafael Davila
User offline. Last seen 5 hours 59 min ago. Offline
Joined: 1 Mar 2004
Posts: 5229

Marcus,

Some way of setting for automatic computation was on my wish list and finally Spider Team found how to do it without affecting the benefits of the way Spider does the computations. But I still need for my formulas computation be done in a specific order. Say a formula computes a value for A, then another formula computes B as a function of A. I need the software to compute new values for A and then using these new values to compute B.

The particular way Spider Computes formulas is more powerful than the way others do, even some loop computations could be defined using circular references the way Excel does with the idea of "Complex Formulas".

There are a few ideas like adding drop down menus for filters and formulae on the tool bar where WBS Level, WBS and Configurations Drop Down selection are available. I also would like for a field available on the tables to specify if the Formula and Filter is to be displayed on the drop down list, I would like to toggle off those intermediate Filters and Formulas used in Complex Filters and on the idea of Complex Formula (as set of formulas to be computed on a specific order).

Regards,

Rafael

Marcus Possi
User offline. Last seen 11 weeks 3 days ago. Offline
Joined: 27 Feb 2010
Posts: 71
Hello Rafael, After The option "execute after cost calculation" everything became easier to us. After everything schedulle calculation we force The cost calculation. Does it answer you expectations ? Regards, Marcus POSSi (by IPod)