3.2 DASHBOARD

The key advantages of SIGNAX DASHBOARD are: - Always up-to-date data in the smartphone - Clear understanding of the situation on the construction site - Unified reporting standard for all projects - Transparent management, clear metrics Please check our predefined reporting cards:

Construction progress tracking methodology


Example of work assembly code: A10.20.50 or W3.2.1
First, you need to download all standard sizes into an Excel file. Then, fill in the work assembly codes in the elements that show work status. After that, it is necessary to load the object structure file, which consists of form-generating units dividing the object into sections and floors.
Example of an element package code: A10.20.50-B01.S03.L05 or W3.2.1-B01.S03.L25
To associate element packages with works and budget items, they must have the exact breakdown ( ex., the same assembly code used to determine the volumes).

In a basic situation, we receive project model files with a filled assembly code divided into packages from the designer. Next, create the NWF model, which is necessary to generate and check search sets from an Excel file using the SIGNAX for Navis plugin.
Then export work volumes to Excel using the same plugin. Finally, create a pivot table, the Bill of Quantities, and the project budget based on the previous Excel report.
After that, create the Microsoft Project time-scaled activity network schedule and bind it with Navisworks Timeliner.
Realize construction visualization and plan / actual tracking performing with the Timeliner tool.
The following scheme represents the construction model-creating process:

Autodesk Revit creates a new construction model file for a specific job based on the construction model template. Further, load project models into the template. The project model contains the necessary elements for volume calculating and progress display. Then, take the construction elements from the loaded file and transfer them into the construction model. After that, make additional preparations, such as cutting into sections.
Further, convert the construction model into NWC format for assembly in Autodesk Navisworks, where you will mark the elements' completion status, confirm completed work volumes, and make a plan / actual comparison. Also, using the construction model, prepare PDF 3D reports and NWD model for uploading to the SIGNAX DASHBOARD Customer's Account.

The Customer's Account gets the information directly from the BIM model and Excel. To prepare data in Excel, we use exporting volumes from Autodesk Navisworks using our plugin. Then, using Excel, we track the volumes summary, the connection between the work performance and the project budget, and the accounting of non-modeled works. After that, the information is collected on a separate sheet (in a predetermined form) and copied into the Plan-fact, Rates, Budget, Workers dynamics cards.
Load NWD Models into Autodesk Docs, copy the model URL, and paste into the Customer's Account card. Further synchronization by URL link is automatic and allows you to update the model through the Autodesk Desktop Connector by saving the file.

DASHBOARD - How to create reports

Access DASHBOARD


Viewing reports with cards is done through a web browser on a PC and from a mobile device at dash.signax.io. To access the user account dashboard, you will need a SIGNAX account with a DASHBOARD license.

Download the mobile application for iOS or Android devices: dm.signax.io

Login to DASHBOARD

Navigate to the user account, enter your email and password during registration, and click "Login".

image-1715236444929.png

Select the Company and open the Project from the list available to the user. For each project, brief information about its status is displayed, which is configured by the Project Administrator.

image-1715237212864.jpg

The user has access to the "Report" section, where published reports with cards for the selected date are displayed. Some cards can be opened, while others only show information in the preview. You can familiarize yourself with the purpose of all cards in the "Instructions".

image-1715237475169.jpg

DASHBOARD Admin

Access to the User Account

Creating and editing report cards is done at dash.signax.io in the "Management" section. To access the user account dashboard, you will need a SIGNAX account with a DASHBOARD license.

Adding users to projects and adjusting access rights to view specific projects is done using the SIGNAX HUB admin panel.

Logging into the user account is no different from the user's. In addition to the "Report" section, the Administrator has access to the "Management" and "Linking" sections for creating and configuring cards.

When opening a new project for the first time, you will be prompted to create a report - enter the report date and click "Save".

image-1715237565399.png

Adding Cards and Groups

Adding and editing cards is done in the "Management" section.

First, you need to create a group. With groups, you can divide cards into different construction sections, locations, etc., for easy navigation through the report.

To create a group, enter its name, for example, GENERAL DATA, and click "+".

image-1715237703765.png

Editing a group:

image-1715237792548.png

  1. Rename the group
  2. Hide/Show the group in the "Report" section
  3. Delete the group
  4. Move the group down
  5. Move the group up

To create a card, click "+" inside the group.

image-1715237836943.png

In the opened window, select the card type from the list and enter the card name. Then click "Save". Each card is described in detail in the instructions.

Editing a card:

image-1715238167769.png

  1. Rename the card
  2. Hide/Show the card in the "Report" section
  3. Delete the card

Creating a Report

Creating a report is done in the "Management" section.

To create the next report for a new week/month, select the existing report, based on which the new one will be created. Then expand the list of dates and click "New Report".

image-1715238293595.png

In the opened window, enter the date for the report and click "Save".

image-1715238463068.png

Publish reports

An unpublished report is not accessible for users to view. To make the report available to users, it needs to be published in the "Report" section. To do this, click "Publish Report". Previously published reports remain available to users in the "Report" section.

image-1715238569858.png

Updating Report Data

After creating a new report, it is necessary to update the data for the cards according to the current information about the object.

Data updates can be performed directly by editing the cards or by exporting the report to Excel or Google Sheets. After updating the information in Excel or Google Sheets, they can be imported back into the DASHBOARD service.

Linking Cards via Google Sheets

The DASHBOARD service offers the option to bind cards to a Google Sheet. This speeds up the process of adding/updating data in created cards. Linking in Google Sheets is done through named ranges.

  1. First, create a Google Sheet. This can be done in two ways:


    Method 1:

    This method can be used to bind a small number of selected cards, for example, the most commonly used ones in the project.

    Simply create a new Google Sheet or a copy of the template and grant access to it. Cards will be copied there in the future.

     

    image-1715239239830.png

    Method 2:

    This method can be used to bind the entire report.

    Download the entire report from the DASHBOARD service by clicking "Export to Excel".

    image-1715239346519.png

    Import the Excel file into Google Sheets. To do this, in a new Google Sheet, click "File" ➤ "Import". In the opened window, switch to the "Upload" tab and upload the Excel file.

    image-1715239473034.png

     

    To navigate the document more easily after importing it, you can rename the sheets in Google Sheets according to the names of the cards.

    image-1715239566324.png

  2. In the DASHBOARD service, go to the "Linking" section. Copy the link to the Google Sheet and paste it into the "Google Sheet Link" field. Then clickimage-1715239670997.png "Link Report".

    image-1715239722544.png

Note: When creating a new report, the link to the Google Sheet will be saved and transferred to the new report.

3. Populate the Google Sheet report with the necessary cards, placing them on the same sheet as in the template or on separate sheets. Click the image-1715238670708.pngto copy the card data to the clipboard. Paste the data into Google Sheets using Ctrl+V.

image-1715239840065.png

Note: When placing cards on the same sheet, arrange them horizontally and do not insert a new card on top of an existing one.

4. Now you need to create ranges for the cards, adhering to the rule: only one card can be included in one range.

Open Named Ranges by clicking "Data" ➤ "Named Ranges".

image-1715239951104.png

image-1715240037521.png

Note: The range name can only contain letters, numbers, and underscores (_); it should not contain spaces or punctuation marks; it should not start with a number.

5. After adding the necessary cards to the Google Sheet and creating the ranges, return to the DASHBOARD service.

Click the image-1715238929398.pngto "Refresh the list of ranges" to pull the created ranges from the Google Sheet. Then bind the ranges to the cards. To do this, on the card, expand the list of ranges and select the range corresponding to the selected card. After that, the card will change color to dark blue.

image-1715240224947.png

6. After selecting the ranges, you need to synchronize the cards with the Google Sheet to update their data. To do this, click  image-1715238899160.pngon the card itself to synchronize the data of one card, or above the link to the Google Sheet, to synchronize the entire report.

image-1715240317126.png

10_Album

10_Album - Add photos or any images about your project. You can use any uploaded image as the Album Cover.



image-1717153333471.png

  • add picture;
  • choose the album cover;
  • crop the picture and add background;
  • delete.

11_TEI

11_TEI - technical and economic indicators. Excel template

12_Risks

12_Risks - slide with information about all possible risks

image-1715242184856.png

13_Video stream

13_Video Stream - allows tracking production processes on the construction site in real-time.

Displaying the Card in User Mode

image-1715242208383.png

Card Configuration

  1. RTSP Tab

Specify the link to the video stream in RTSP format.

image-1715243106861.png

  1. RTSP.ME Tab

If your video stream is hosted on the RTSP.ME website, specify the link from this site in RTSP.ME format.

image-1715243546819.png

Stream view

When viewing the card in user mode, you can switch between two video stream qualities:

image-1715243582857.png Viewing mode in HD quality (high-quality format).

image-1715243591340.png When deselecting the checkbox, the viewing quality becomes low.

14_Workers trend

14_Workers trend - by days. 

15_Dynamics universal

15 Dynamics universal - add multiple columns and enter chronological data

image-1681280692238.png

image-1681280712071.png

16_Percentage of object readiness

16_Percentage of object readiness - readiness visualization of the object as a percentage: plan / actual / remaining.

20_Percentage of money spent

20_Percentage of money spent - construction budget disbursement: plan/fact/total.

21_General cumulative by money

21_General cumulative by money - construction budget planning: payment for accepted structures, withheld money, advance payment data. 

22_Mastering money by month

22_Mastering money by month - data visualization on how much was paid compared with a payment plan. 

30_Percentage of implementation period

30_Percentage of implementation period - start and end date visualization of the construction work.

31_Project milestones

31_Project milestones


32_Graph excel

32_Graph excel

33_Graph MPP

33_Graph MPP


34_Graph MPP with milestones

34_Graph MPP with milestones

image-1715242465747.png

image-1715242482498.png

image-1715242503808.png

35_Chart

35_Chart
1. Copy start and finish works dates data from MS Project to Excel.


2. Copy Excel data to the card

3.Set up the relationship between the table columns with the option the card offers to select. For example, column "Number in structure" - WBS, "Task Name" - Job name.

4. To customize the slide title, you need to select the top line of the chart and select the scale: by days, weeks, months, or quarters. Then close the "Preview" and save.

Ex.: “Preview” button shows the entire chart for the whole period

You can cutomize chart display:
  • 1.
    by day
  • 2.
    by week
  • 3.
    by month
  • 4.
    by quarter

36_Chart

image-1689076229781.png

41_Plan-Actual volumes

41_Plan-Actual volumes - planned and actual scope of work completion. You can also make it so that only the month number is displayed for the monthly report. Check the box next to "Display by months". Excel Template.

43_Execution rates by volume

43_Execution rates by volume - a slide shows the production of a particular work plan/actual in ft3/day per person. The cards' block "To be completed on time" automatically calculates how many people are needed with the same output and what the output should be with the same actual number of people.. Excel Template

45_Forecast

44_Forecast - prediction of work completion;

image-1681280560553.png

image-1681280591314.png

52_Summary BIM model

52_Summary BIM model - Navisworks .nwd model, unlinked from the "Completed' dates and Colors; You must paste the Autodesk Docs link to the .nwd file;

54_BIM model by color

54_BIM model by color - Navisworks .nwd model with colorized model elements using SIGNAX for Navis plugin; You must paste the Autodesk Docs link to the .nwd file.

55_BIM planned volumes

55_BIM planned volumes - Planned .nwd model - 4D/5D model (with timeliner/budget), pre-loaded into the Autodesk Docs project, contains search sets with dates based on the timeliner, created by the SIGNAX for Navis plugin.

56_BIM actual volumes

  • 56_BIM actual volumes - Displays Navisworks .nwd model files by clicking on the slide image. You must paste the Autodesk Docs link to the .nwd file;
Prepare the file using the SIGNAX for Navis plugin to display the required volume.


62_Issues DOCS

Card view in Report mode:

image-1724243377164.jpg

Card settings

image-1724244095444.jpg

1 - From the dropdown list, select the types of issues to be displayed on the chart.

2 - Display issues with a cumulative effect or the number of issues issued on a specific date.

3 - Display statistics by month.

63_General reviews in DOCS

Card  view in Report mode:

image-1724244997381.jpg

Card settings:

Select the types of reviews to be included in the statistics from the dropdown list.

image-1724245085228.jpg

64_Dynamics of reviews DOCS

Card  view in Report mode:

image-1724245438891.jpg

When opening the card:

image-1724245459244.jpg

Card settings are similar to 63_General Reviews in DOCS.

65_Register of Reviews DOCS

Card view in Report mode:

image-1724245857159.jpg

When opening the card:

image-1724245873713.jpg

Clicking on a row allows you to navigate to the corresponding Review in SIGNAX DOCS:

image-1724245905984.jpg

Card settings are similar to 63_General Reviews in DOCS.

 

66_Folders

66_Folders- create hyperlinks to the Autodesk Docs folders you use the most.

71_Activity chart ACC

71_Activity chart ACC - shows the number of users, who've mady any changes in the project for the particular period.
Upload the Autodesk Docs .csv file. To get this file, open the project using “Project Admin” mode, click Services->Activity->Export and choose required time period.


90_Integration

90_Integration - shows 360 panoramic pictures from the 360 Photo service photo.signax.ae

image-1715242709910.png

image-1715242787079.png



92_YouTube Link

92_YouTube Link- watch the video from the slide. Copy the identificator (ID) from the YouTube URL-link. Paste the ID to the slide:

image-1715243034105.jpg


image-1715242847946.png

image-1715242861841.png