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.

Formulas and Modifiers

1 reply [Last post]
Bogdan Leonte
User offline. Last seen 4 hours 18 min ago. Offline
Joined: 18 Aug 2012
Posts: 176

Hello Vladimir,

For some time I have been trying to figure out how to use modifiers in formulas but I am at a loss regarding their use. I manage to create formulas using modifiers but it's more of a trial and error process.

I found it useful to be able to set distance lags for infrastructure projects. In order to use such a lag I use the following fields:

  1.  Start Location
  2. Finish Location
  3. User Field called Distance Lag [m], wich contains the distance between 2 activities
  4. Formula, which is applied in the Links table, formula which computes (depending on the type of links - SS or FF) the volume of the lag according to the Distance.

The formula is as follows:

Lag = if ( LagType  = 'Volume' and LagUnit = 'Unit of volume', RoundTo ( if ( Code [ Code , ?PredCode , GanttAct ] = PredCode and TypeSF = 'Start-Start',  VolPlan [ Code , ?PredCode , GanttAct ] / ( LocFin [ Code , ?PredCode , GanttAct ] - LocStart [ Code , ?PredCode , GanttAct ] ) *  Dist_Lag [ Code , ?PredCode , GanttAct ], If ( Code [ Code , ?PredCode , GanttAct ] = PredCode and TypeSF = 'Finish-Finish', VolPlan [ Code , ?SuccCode , GanttAct ] / ( LocFin [ Code , ?PredCode , GanttAct ] - LocStart [ Code , ?PredCode , GanttAct ] ) *  Dist_Lag [ Code , ?PredCode , GanttAct ], Lag ) ), 4), Lag )

The problem I have is that I don't fully understand modifiers and cannot get the formula to be called from the Activity Gantt into the Links Table.

If you could go into more detail on using Formulas and Modifiers it would be much appreciated.

Best regards,

Bogdan

Replies

Bogdan Leonte
User offline. Last seen 4 hours 18 min ago. Offline
Joined: 18 Aug 2012
Posts: 176

I have found a workaround to apply formula directly in the Links table via script, ProjTabApplyFormula (Calc_Lag_Dist_Vol, LINK);