How to create a concrete quantity graph

Is it possible into Synchro to create a graph with the concrete quantity. Our client request a graph to be able to pay on time with the real quantity. 

With the timeline, we would like to see the growth of the concrete quantities. 

Thanks for your answer.

Thomas

  • Guest
  • Dec 12 2017
  • FAQ
Company BOUYGUES BATIMENT NORD EST
  • Apr 9, 2018

    Admin Response

    If you have Volume User Field assigned to the 3D Resources:

    1. If the User field is of Type=String, then you will need to create a new Resource UF of Type Number. You may wish to rename the String type UF e.g. Volume (string) - UFs cannot have duplicate names

     

    Select the string type UF and right click to "Copy Values to Associated Objects. then select the new UF for the Destination User Field 

    2. Create a Task User Field with Type=Number and Calculation Type=Calculate

    The formula is: SUM(RESOURCE.UFV("Volume")) 

    where Volume should be replaced by the name of your Resource User Field if it's different

    3. Since other non-concrete resources may have the Volume UF assigned, you should create a filter to show only the concrete items you wish to track. Then select those objects of interest and right click in the 3D window to "Select Assigned to Task(s)"

    4. From the Analyse ribbon, select "Recalculate Values". Make sure to choose the "Selected" option for "Processed Objects" - this will calculate the Task User Field only for the selected concrete tasks. If you have other Calculated UFs in your project, you should also choose "Selected" for "User Fields to Recalculate" and make sure that the new Task UF is selected in the User Fields window list

     

    5. Now that you have a total volume of concrete per task - you can turn on Windows>User Field Graph . In the Navigator>User Fields window check the box next to your calculated Task UF to show it in the graph. In the properties panel, disable "Draw in UF Graph", and enable "Draw cumulative in UF Graph"

    Now the cumulative concrete installed will be shown below the Gantt chart. The one caveat is that the total volume of concrete per task is added to the cumulative graph at the BEGINNING of the task rather than the end

    This graph can be included in AVI Exports or Printed if desired

     

     

    You now have a few options if you want to get more precise:

    A. You could now export or copy/paste the Task table to Excel to create a graph that shows the volume being added at the end of the task

    B. You could create a second Task User Field that calculates the total volume only for tasks that are set to the Finished Status and sum this to the top of the WBS to get a total value of finished concrete. The Formula would be: IF( LEAF, IF(FINISHED,  SUM( UFV("Concrete volume")), 0), SUM(TASK.UFV("Finished Volume"))))

    Select the tasks you want to calculate, including the parent WBS tasks, then press Recalculate Values with the following settings. 

    Recalculate Values repeatedly until the top level WBS is evaluated giving the total finished concrete volume for all finished tasks.

    Again, you can now export or copy/paste the Task table to Excel to create a graph that shows the volume being added at the end of the task

    C. You can create a generic concrete resource to assign to the concrete tasks and assign the total concrete volume in the Task UF as the Planned Units in order to take advantage of the time-distributed Resource Usage Spreadsheet which will give spread the concrete volume evenly over the task and can show the planned volume in day, week, or month increments.

    1. Create a Material Resource and in Resource Properties>General>Quantities, check the box for "Renewable"

    2. Assign the new Resource to all of the concrete tasks

    3. Make sure the concrete Resource is selected and open Analyse>Synchro Script and paste the following Script:

    RESOURCE(SELECTED).ASSIGNMENT SET_PROPERTY(PLANNED_WORK, TASK.UFV("Concrete volume"))

    This will set the value from the calculated Task UF as the Planned Units for the selected resource

    Press Preview and then Run

    You can check (and edit if desired) the assigned units in Task Properties>Resources

    4. Deselect all Resources, then open Windows>Resource Usage Spreadsheet. Right click in the right side under the Timeline and Customise Fields to show Cumulative>Planned Units. Then right click again under the Timeline to Edit Timescale and set the Timeline step as desired

    5. Select the generic concrete resource in the Resources window the cumulative volume of concrete planned to be installed as of each time step is shown per assigned Task. The top summary row by the resource name shows the total volume planned over all tasks

    6. As you update the schedule with actual start and finish dates, you can run the following script to set actual quantities of concrete installed to date

    RESOURCE(SELECTED).ASSIGNMENT SET_PROPERTY(ACTUAL_WORK_WORK, TASK(FINISHED).UFV("Concrete volume"))

    Then you can Customise Fields in the spreadsheet to show Actual Units

    7. The Resource Usage Spreadsheet  can be exported to Excel for graphing there by right clicking under the TImeline and choosing "Export to Excel." Iin the Save As dialog, CSV format is preferable (and is necessary for projects with long timelines as there is a column limit for the XLS export). There is a Resource Usage graph in Synchro, but there are a couple bugs in the current version (5.4) so I would recommend using Excel to graph for now (these bugs should be fixed for the next major release in 2018)

  • Attach files
  • Lidia Privezentseva commented
    April 9, 2018 08:28

    Hello! Thank you, this answer was helpful, but I have one more question according to this theme. What if we use Resource Groups in Synchro Pro? In my project it doesn't work - when I trying to recalculate values of task user field (to connect it and take a data from revit parameter). It works only with tasks which have assigned Resources but not Resource Groups. What should I do?

    Thank you for your answer
    Lidia

  • Admin
    Kate Hester commented
    April 9, 2018 10:51

    If you are using Resource Groups and Resoruces, simply modify the formula in step 2 to SUM(RESOURCE.UFV("Volume")) +SUM(GROUP.RESOURCE.UFV("Volume")) 

    If you are just using Resource Groups, the formula can be SUM(GROUP.RESOURCE.UFV("Volume")) 

  • M Manoj Victor commented
    June 20, 2018 05:41

    In the formula SUM(RESOURCE.UFV("Volume")) do we have to insert the inverted commas. I'm not getting any output.

  • M Manoj Victor commented
    June 20, 2018 07:24

    Hi,

    I'm getting this error when trying to recalculate values from analyse ribbon. Please help.

    Warning: cannot validate condition value of UF[Concrete vol] for Task object [Columns] : Error: function without contents

  • Admin
    Kate Hester commented
    June 20, 2018 13:14

    RE: In the formula SUM(RESOURCE.UFV("Volume")) do we have to insert the inverted commas. I'm not getting any output.

    Yes, " " [quote marks] around the name of the User Field are necessary. If you use the search function in the Formula Editor to find the User Field name, then double click on it in the list or use the Insert button for the Formula, then the whole command UFV("User Field Name") will be inserted into the formula at your cursor location with the correct formatting 


    RE: 

    I'm getting this error when trying to recalculate values from analyse ribbon. Please help. Warning: cannot validate condition value of UF[Concrete vol] for Task object [Columns] : Error: function without contents

    There is insufficient information to troubleshoot. What is the formula you are trying to calculate? Please email support@synchroltd.com with a full description of the problem and screenshots where appropriate for help troubleshooting