LVDC Tab - Excel integrator & Revisions manager
Win64, EnglishGeneral 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
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! |