fbpx
  • Plumbing Code Calculations With Spreadsheet Link and Schedule XL – Part 2

    Posted from CTC BIM Project Suite White Paper Library –  CTC Software

    Result

    When the workflow is developed and implemented, the entire building occupancy can be calculated in a minute, and the code validation table can be filled out. With one more step, that same table can be linked back into the Revit model for use on sheets. Any user, on any project, at any time can leverage this workflow to get updated numbers and update the tables on the sheets. Revit data-entry frustrations and quality control issues are gone, since you can leverage the power of computers to do what computers were designed for by automating the repetitive tasks that creative human minds are not great at completing.

    Savings/Benefits Users do not need to know the formulas that are running automatically. They do not need to depend on Dynamo scripts that can be volatile after updates. They can simply walk through a simple workflow that is stable and repeatable. The manual, error prone process can be eliminated, allowing users to focus more on design and documentation more than focusing on basic calculations and manual data entry. Time savings can be found every time that print day approaches. Design time can be extended since this time-consuming manual process is now automated.

    Conclusion

    Spreadsheet Link and Schedule XL from the CTC BIM Project Suite can help automate calculations. This example of occupancy and plumbing code calculations can be automated nearly 100%. There are many other areas where this type of automation can save hours of time consistently throughout the design and documentation process. Whenever you or your team are pulling data from the Revit model, transferring to a spreadsheet environment, running some calculations then manually transferring data or graphics back into Revit, think about how this can be automated by the BIM Project Suite. Manual, repetitive tasks are not enjoyable, often error-prone and should be eliminated where possible. Let the tools generated for you by CTC Software augment your workflow to allow you and your team to be more creative for longer periods.

    Plumbing Code Calculations With Spreadsheet Link and Schedule XL – Part 1

    Posted from CTC BIM Project Suite White Paper Library –  CTC Software

    The Issue

    Revit® has trouble with complex calculations and the ability to run cross-category math. This can be frustrating when design calculations need to be run. In the case of plumbing code calculations, we need to take the occupancy of a defined area (floor, smoke compartment, etc.) and use these totals to derive the number of different plumbing fixtures that are required by code to be designed into these areas. Many firms run these calculations manually, but this can be done far more efficiently. This white paper will describe how a re-usable workflow can generate occupancy, calculate plumbing fixture counts and generate graphics for use in Revit to present this information in a live model.

    Typical Workflow

    In manual workflows, some Architectural firms will use either fake calculated values in a Revit schedule, then sometimes copy those values across to a real parameter for display in a tag, a schedule, and on the actual room object. Some firms may also use a calculated value in a tag to reduce some of the manual data transfer. Other firms will export schedules to Excel®, and run calculations there, but then must manually copy the values back into Revit. In all cases, the process is very manual and extremely error prone.

    This is also rather time consuming, reducing potential production time. Regardless of how we get the room occupancy, we always must manually transfer the occupancy to a spreadsheet for our code checks, present the information in a meaningful way and return this information back to Revit. This is also entirely manual and error prone. Nothing keeps this information up to date with the Revit project model. There needs to be a better, more efficient way to do these types of calculations, and return the result of our efforts to the Revit project model and include the information on the construction document set.

    Solution

    This entire workflow can be heavily automated using the Spreadsheet Link and Schedule XL tools from the CTC BIM Project Suite. Your current spreadsheet can be incorporated, and the values entered far more automatically. Even the room occupancy calculations can be tuned to your liking, entered directly into the room/area/space elements you are using in the Revit model. Further, the spreadsheet graphics can be directly linked into the model, avoiding any manual image or CAD file workflows.

    • Establish predictable, repeatable workflows for all Revit users
    • Leverage existing spreadsheet layouts so formatting in Revit aligns with company graphic standards
    • Implement the power of spreadsheet formulas to drive calculations and graphics
    • Import spreadsheet graphics directly into the Revit model for use on sheets

    BIM Project Suite – Free Valuable Tools for AEC

    Down below are BIM Project’s Suites best FREE tools:

    (1) Quick Select

    Gives users the ability to build or filter selections of Revit objects by specific categories or parameter values. For more click here

    Revit Filter Tool

     vs Quick Select Tool

    (2) Renumbering

    Provides a fast and simple way to renumber your rooms and doors. Auto-swapping avoids duplicates. Alphanumeric sequential numbering. Add separators and suffices to room and door numbers. For more click here

    Common Uses of Productivity Tools by Contractors

    Model Compare, in the BIM Project Suite. This tool can compare to iterations of a Revit model. Very useful to see “what’s changed” in very great detail. Thus if they are estimating, or looking for coordination issues, model compare is an excellent tool that many of our contractors use.

    Spreadsheet Link, in the BIM Project Suite. This tool can push and pull data to and from Revit and spreadsheets. Very useful in estimation processes, and also if they ever need to push commissioning/installation/facility management data back into Revit objects in a project.

    Fab Sheets, in the BIM Project Suite. This tool was actually created specifically for contractors who self-perform concrete work. If they do, or create any type of construction sequencing drawing/pour sets, this tool could be a huge time saver.

    Project Cleaner, in the BIM Manager Suite. This tool is free. It helps to clean up models coming in from other parties, blowing away things like working views, or “all views, not on a sheet” which is a common desire of general contractors. This solves a few things. One, it makes the Revit project file faster performing. Two, by blowing away all the “junk” the designers left behind, it makes navigating the project in Revit easier.

    Dim Checker, in the BIM Manager Suite. This is a really cool tool. It finds out where designers might be “lying” in a dimension.

    1. Sometimes designers and engineers do not feel they have time to properly coordinate modeled object positions
    2. Too frequently this leads to overriding dimension values in very dirty ways, mimicking the days of AutoCAD workflows
    3. Unfortunately, these are rarely found and more rarely repaired, and can cause HUGE headaches for contractors and increase risk.
    4. The DIM Checker allows these dimensions strings to be found and reports generated to allow the team to easily repair and coordinate these dimensions where appropriate

    Plotter & Exporter, in the BIM Batch Suite. This tool runs on a nightly, or specified schedule to do all your exports for you. NavisWorks, PDF, DWG, whatever else you might need, automatically.

    1. Sure, generating PDFs can happen from Bluebeam, but what about everything else
    2. DWGs, Navisworks files and others often must be exported for other consultants and partners
    3. Instead of doing this from multiple places, use Plotter/Exporter to single click export all the needed files
    4. Have them exported where you want, named how you want with the exact settings you want.
    5. Instead of manually triggering exports, try scheduling this so it can happen after hours and be ready for you when you walk in the office

    Last but not least:

    Import & Link Manger, in the BIM Manager Suite. Loading, and reloading links and imported files for coordination happens all the time. Waiting for Revit to link in everything, or to find where a link or import may, or may not be working is a pain.

    1. All too frequently files are improperly linked or imported into production models
    2. While Revit does allow minimal management of links, there is no easy way to find and fix imported AutoCAD files
    3. ILM is critical to the regular maintenance of models by finding and fixing imports and update link settings in a simple interface

    To watch our previous webinars on BIM Project Suite click here!

    Introduction to BIM Project Suite

    In case you were unable to attend SolidCAD and CTC’s webinar last week here is what you need to know…

    Shawn Zirbes, a Guru for everything CTC, uncovered how the BIM Project Suite allows Autodesk Revit users to automate routine tasks, manage large numbers of content files, generate database information and much more in a lot less time, all within the Revit environment.

    BIM Project Suite is meant for everyday users of all skill levels and used by firms of all sizes. To learn more about the some of key functionalities of the suite, watch the full webinar on our YouTube Channel.

    Reconcile the Differences Between Parameters live in projects without Destroying Data

    Let’s talk about Revit families. Are your Revit users pulling families from manufacturer websites, then having to spend project time individually reconciling the differences between the parameters used without destroying existing data?

    Downloaded Revit family content introduces shared parameters into a project that are often times different from the parameters used in the company’s schedule. These differences often cause schedules to display incomplete or inaccurate data requiring tedious, individual fixes.

    BIM Project Suite 2020’s Parameter Jammer uses a two-step process to swap the parameters in the family to reconcile the differences between the parameters without destroying your existing data, saving users time and headaches. The first step swaps parameters that can be safely identified as a match, while the second allows users to map, add or omit parameters that do not need to be swapped.
    Parameter Jammer is user friendly, and was designed so that Revit users who are unfamiliar with the family editor can successfully prepare a family to be scheduled; it also:

    • Uses the schedule to derive parameter needs; and
    • Allows the end user to push parameters into a non-standard family.

    Maximize your Revit project team’s time with Parameter Jammer and the entire BIM Project Suite 2020 by downloading a free software trial and scheduling a demo today.

    CTC BIM Projct Suite 2020 – Invisibility Advisor

    Find improperly displayed elements in Revit with Invisibility Advisor. Part of the BIM Project Suite, this tool can also identify the cause of invisibilty as well as offer useful information and links to relevant knowledgeable articles for each issue.

    Common Challenges

    Revit users may spend 2-4 hours a week on average resolving object visibility issues

    Revit has various ways of finding objects, and users rarely check all

    Often invisibility can be controlled by multiple factors and multiple users

    Solution – Invisibility Advisor

    Invisibility Advisor searches through almost 60 different factors affecting an object’s invisibility

    Advice is offered to assist with understanding why the object(s) were not visible

    In many cases, an instant ‘Fix’ option is available to resolve the visibility issue automagically

    The Invisibility Advisor can remain on screen while you work, so visibility solutions are available at your fingertips

    ROI

    At even 1 hour per week time savings, Invisibility Advisor can save an average firm $3400/year/Revit user

    For more information visit CTC Productivity Tools to learn more, and download free trial.