LVDC Tab - Excel integrator & Revisions manager

LVDC Tab - Excel integrator & Revisions manager

Win64, English

LotanVDC
Elevate your workflow with Excel® connectivity, advanced revision management, and an intuitive viewer control panel. Perfect for Autodesk® Navisworks® clashes reports, design reviews, and more.

General Usage Instructions

Load:

  • Click on the "Load" button to initiate the import process.

  • A dialog will prompt you to select an Excel workbook and worksheet. Ensure the worksheet includes column headers in the first row and that data is organized by columns. Then, click the "Parameters" button to proceed.

  • Select the columns representing X, Y, and Z from the selected sheet. Ensure that these columns contain numerical values that match the project's "Distance" unit set in Autodesk® Revit®. For example, if the "Distance" unit is set to "meters" in Revit, LVDC will consider the imported X, Y, and Z values as meters.

  • Select a column representing the Status parameter. By default, LVDC will set each of the created object's status values to "New".

  • Choose a column representing the Identifier parameter. This parameter's values cannot repeat themselves. If multiple objects share the same value for the Identifier parameter, only the first occurrence will be generated in Revit. By default, LVDC uses the XYZ values as identifiers, so if two or more objects have the exact same coordinates, only the first one will be generated.

  • Specify which columns you want to import as additional object parameters. This allows you to customize the data import process according to your project requirements.
    For each selected column, choose the parameter type, modifiability, and name. Parameter types include Text, Integer, Number, Yes/No, and ElementId.

               * Text-type parameters are suitable for storing textual information.
               * Integer-type parameters are ideal for numerical values that are whole numbers.
                  They can also be utilized to toggle between the next and previous objects.
               * Number-type parameters are suitable for numerical values that include decimals.
                  They, along with integer-type parameters, can be used to search for objects
                  within a specified range.
               * Yes/No-type parameters are represented as checkboxes, with the box checked for
                 'Yes/True/1' values, unchecked for 'No/False/0' values, and null for other values.
               * ElementId-type parameters establish a link between the generated LVDC Object
                  and associated Revit elements.

  • Finally, select a Revit (point-based) family to hold the imported data. You can also enhance your selection options by adding custom Revit families. Simply drop the family .rfa file into the LVDC_Tab/Resources folder. This family will serve as the graphical representation of your data within your project.

  • Confirm your selections to proceed with the import process.

  • LVDC Tab will import the data from the Excel sheet into your Revit project, creating the specified parameters and generating the selected Revit family instances. Additionally, a schedule capturing all desired data is automatically generated for your convenience. Moreover, LVDC Tab generates hidden Excel sheets in the imported workbook to track revisions and changes, ensuring data integrity and project cohesion. These Excel sheets should not be manually modified.

Commands

Ribbon/Toolbar Icon Command Command Description

Load

Import Excel Data and Create Revit Elements and Schedules: Use the Load command to import Excel data into your Revit project. Select your Excel sheet and specify data columns to import as parameters. Customize parameter types, names, and modifiability, and choose a family to generate graphical representations of your data within your project.

Refresh

Synchronize LVDC Database with Revit: Keep your LVDC Objects database aligned with the Revit project. LVDC Tab will prompt you to refresh whenever disparities arise, ensuring data integrity and project cohesion.

Export

Extract Custom Data: Utilize the Export command to transfer data from your Revit project to an Excel sheet. Selectively export user-defined data from LVDC objects and schedules, including object coordinates, for further use and analysis.

Disconnect

Detach Objects from LVDC Database: Utilize the Disconnect command to convert LVDC Objects into standard Revit elements, enabling manual customization within your project. For instance, after completing modifications to your project, disconnect to prevent subsequent changes from being saved to the Excel sheet.

Remove

Safely Remove Sheet and LVDC Traces: Use the Remove command to eliminate a sheet from your project and erase associated LVDC traces. This includes deleting LVDC objects, revision files, schedules, and related data of the selected sheet.

Revisions

Manage Sheet Revisions: With the Revisions command, oversee and modify sheet revisions. Access details like issuers, dates, descriptions, and sequence numbers. Edit, add, or delete revisions.

Previous

Toggle to Previous LVDC Object: Use the Previous command to select the previous LVDC object. By default, it selects based on the "No." parameter value unless another "Integer" type parameter is specified in the "Parameters" selection box. Only visible objects are selected.

Next

Toggle to Next LVDC Object: Use the Next command to select the next LVDC object. By default, it selects based on the "No." parameter value unless another "Integer" type parameter is specified in the "Parameters" selection box. Only visible objects are selected.

Off

Set Visibility Off: Utilize the 'Off' command to set selected LVDC Objects invisible.

On

Set Visibility On: Utilize the 'On' command to set selected LVDC Objects visible.

Elements

Select Linked Revit Elements: Use the Elements command to select the Revit elements linked to the currently selected LVDC objects. Objects can be linked using the "Link" button on the control panel or by setting a LVDC object parameter type to "ElementId" and providing valid Revit element IDs.

Focus

Focus on Selected LVDC Objects: Use the 'Focus' command to zoom in on the selected LVDC objects.

Add

Add LVDC Objects: Use the Add command to add LVDC objects to the project and the selected sheet.

Delete

Safely Delete LVDC Objects: Use the Delete command to safely delete LVDC objects from the project and matching data from the Excel sheet.

Link

Link Revit Elements: Use the Link command to link Revit elements to the selected LVDC objects and capture the elements' IDs.

Unlink

Unlink Revit Elements: Use the Unlink command to unlink the selected Revit elements from the selected LVDC objects.

Select

Search and Select LVDC Objects: Use the Select command to set the search function mode to search and select matching LVDC objects.

Filter

Search and Filter LVDC Objects: Use the Filter command to set the search function mode to search and filter matching LVDC objects.

Custom Color

Set Custom Colors: Use the Custom Color command to set selected LVDC objects' colors using the user's color selection.

Default Color

Restore Default Colors: Use the Default Color command to retrieve selected LVDC objects' colors to the original color.

Status Color

Set Colors by Status: Use the Status Color command to set the selected LVDC objects' colors based on their status parameter value.

Installation/Uninstallation

The installer that ran when you downloaded this app/plug-in from the Autodesk App Store will start installing the app/plug-in. Or simply double-click the downloaded installer to install the app/plug-in.
You may need to restart the Autodesk product to activate the app/plug-in.


To uninstall this plug-in, exit the Autodesk product if you are currently running it, simply rerun the installer, and select the "Uninstall" button. OR, click Control Panel > Programs > Programs and Features (Windows 10/11) and uninstall as you would for any other application from your system.

Additional Information

Known Issues

Contact

Author/Company Information

LotanVDC

Support Information

For any inquiries or assistance regarding the LVDC Tab, please feel free to reach out to us via email.

Company Name: LotanVDC
Email: Support@LotanVDC.com

We are committed to assisting you with any questions or issues you may encounter concerning the LVDC Tab. Our dedicated team is here to provide prompt and valuable support, ensuring that your experience with our plugin is both seamless and productive.

If you have any improvement suggestions, we kindly request that you share them with us. Your feedback is invaluable in our efforts to enhance and refine our product for future versions.

Version History

Version Number Version Description

1.0.0

LVDC Tab® debut release!
Go top