(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.
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:
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
Printer-friendly version
Send to friend
You can download the following sample schedules to explore Formula Modifiers.
Look for the notes under project properties as well as under formula creation screens.
If I am right and this is inherent in database tables maybe modifiers selection screen can be programmed to control data entry order and dim/hide those selections that cannot make the transfer/reference based on prior selections.
It would be convenient if formulas show in what view/table they were created (or belong). In addition field values when not belonging to current view might display the name of the view/table they belong instead of "empty".
For each Activity record(row) in Gantt Table there can be many successors and many predecessors, each with its own record(row) in the Links Table. Field Modifiers are used to transfer data between tables but to my understanding can only handle one to one relationships. It might be transfer of data from Gantt to Links Table are possible while transfer of data from Links Table to Gantt Table are not.
... cannot get the formula to be called from the Activity Gantt into the Links Table.
Rafael,
maybe you will find this of use:
For linear works (roads, water supply, etc.) I created a procedure in order to calculate volume lags based on distance. I belive this can be applied also for other types of constructions.
You define a user field called Distance Lag [m] (or whatever you like) and the following formula, which is applied in the links table
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 )
Using a macro you can use this sequence of commands:
ProjTabApplyFormula (#24_Calc_Lag_Dist_Vol, LINK);
ProjCalcSched ();
ProjCalcCost ();
This is the result:
Best regards,
Bogdan
I have found a workaround to apply formula directly in the Links table via script, ProjTabApplyFormula (Calc_Lag_Dist_Vol, LINK);
Email: PPadmin@planningplanet.com
Replies