Windows 8 Support

  • Subscribe to our RSS feed.
  • Twitter
  • StumbleUpon
  • Reddit
  • Facebook
  • Digg
Showing posts with label Excel. Show all posts
Showing posts with label Excel. Show all posts

Thursday, 14 November 2013

What's in a Multi-Category Schedule?

Posted on 10:06 by Unknown
Ever wondered what’s in a Autodesk Revit Multi-Category schedule? Here’s the skinny…while a regular Revit Schedule reports on a single category of data such as Doors, Plumbing Fixtures, or Structural Foundations, a Multi-category schedule can report on many of the Revit model categories at once, which can be useful for quantity takeoffs. Sounds straightforward, but the catch is that some of the model categories are being excluded. What’s missing are the system families such as Walls, Floors, etc.

The good news is that Ideate BIMLink not only includes all the model category data that you need to do a comprehensive takeoff, but it also lets you select, on a per category basis, which elements you want to include. Furthermore, you can include not just the Length and the Volume, but also the Area, which is slightly important.


Here are the steps required to use Ideate BIMLink to quickly extract your quantity data from a Revit Building Information Model:
1.    Within Ideate BIMLink create a New Link that is based on <Multi-Category> 
2.    On the Multi-Category tab review the items to decide which you need for your takeoff. 
3.    Export to Excel. 
4.    Ideate BIMLink will create a row of data for each instance within your Revit project. If you want a summary, to include counts and totals, you can use Excel’s Pivot table – see video
That’s it. You now have a comprehensive list of the model elements and proceed with your estimating with confidence.


Glynnis Patterson is a registered architect and the Director of Software Development at Ideate, Inc.

Read More
Posted in BIM, bimlink for revit, Excel, export to excel, Glynnis Patterson, Ideate BIMLink, revit building information model, revit multi-category, revit schedule | No comments

Monday, 11 November 2013

Workset Reporting with Ideate Explorer for Revit

Posted on 10:00 by Unknown
A few weeks ago we gave a gentle nudge to BIM Managers to take the courageous step of actually executing on their workset plans. That post generated a lot of positive feedback and discussion. Including this follow-up question.

Q:  Can I use Ideate Explorer for Revit to generate a list of elements per Category or by Workset for offline review? 

A:  Yes, any elements selected within Ideate Explorer can be exported to Excel from the Detail View. After Exporting to Excel the information can be easily transformed to include element counts by using a Pivot table. Here's how:  http://www.screencast.com/t/eyB3nisThiuN

Try the Ideate Explorer for Revit Free Trial today.




Glynnis Patterson is a registered architect and the Director of Software Development at Ideate, Inc.

Read More
Posted in Excel, Glynnis Patterson, Ideate, Ideate Explorer, Revit, Workset | No comments

Wednesday, 12 October 2011

One of These Things is Not Like the Other!

Posted on 10:00 by Unknown
Recently,  I received a Support call regarding Ideate BIMLink.

The customer was distraught because he exported all his data using Ideate BIMLink and when he tried to import back to Revit 2012, he was presented with this error:

Unable to Import Excel Spreadsheet. Excel Columns Do Not Match Link Properties


I racked my brain for a moment, made a few calls and we all agreed that it could have been one of two options.

1. After exporting from Revit, The columns have either been reordered, or deleted in Excel.

--OR--

2. After exporting from Revit, The Ideate BIMLink link definition has changed.

In talking with the customer, I narrowed it down and found out that he had reorganized the Excel workbook to use in a presentation (Option #1). This was the root of the issue. But how do you fix it? Or better yet… how do you avoid it!? Let’s first understand what actually happens here.

Ideate BIMLink relies on the fact that when the link is exported, the columns will stay exactly the same as its initial state. You may replace the values of the columns but the order and organization of the columns and rows really need to stay put! This way when you import the data… Ideate BIMLink knows where it needs to go.

Great, so how do you avoid this? Let’s say that you are like our customer and need to create a presentation from your Ideate BIMLink data.

Here’s how: Excel Links.

Using a feature that has been in Microsoft Excel for some time now, you can reference data from an entirely different workbook. A visual example:

Image Credit: Microsoft

You can see here that the Data from “source.xls” is being pushed to “linking.xls” using the  excel links function. In cell “C5” the formula is “=[source.xls]Prices!A4” This references the worbook, worksheet and cell and pastes its value into our new cell.

To read more about Excel links, check out this page from Microsoft’s website.

Using this functionality allows us to leave the raw data from Ideate BIMLink alone (allowing us to import/export at will) and create a new presentation workbook that stay up-to-date to leverage our data. A very easy and valuable way to handle this situation.

Thanks for reading!



Matthew Nelson
MEP Solutions Application Specialist

Matthew has a deep understanding of Autodesk products. He studied Mechanical Engineering at SUNY Stony Brook. He has been a BIM manager and CAD manager for a leading international consulting services firm utilizing AutoCAD MEP, Civil 3D and Revit MEP. During that time, he focused his skills on understanding the dynamics of inter-discipline coordination on large scale civil and building engineering projects. At Ideate, Matthew provides training and support for Revit MEP, Navisworks and AutoCAD MEP. @MNelsonIdeate

Get it. Know it. Use it.
Read More
Posted in Autodesk Revit, BIMLink, Excel, Excel to Revit, Ideate, Ideate BIMLink, Ideate Inc., Revit, Revit to Excel, Revit tool | No comments
Older Posts Home
Subscribe to: Posts (Atom)

Popular Posts

  • Civil 3D 2013: 2D and 3D Polyline Conversion
    While working on a grading I needed to change grades along a path that had been defined as a 2D polyline. Well, it is a fact that a 2D polyl...
  • Civil 3D Technology Preview – Corridor Solids for Civil 3D 2012
    How do you import a Civil 3D corridor into Revit or Navisworks? I was asked this question a couple of months ago while importing a Civil 3D ...
  • Join Ideate, Inc. and Support Revit Forum
    RevitForum deserves the support of the entire Autodesk® Revit® using community. At Ideate, we are convinced Revit Forum is far more than in...
  • Revit MEP Tip - Single Column Panel Schedules
    When Revit MEP introduced the concept of panel schedule templates that enable you to control the appearance of electrical panel schedules. B...
  • Commitment to Change
    We all believe that we are good at 'change'. We are 'champions of change'. But is that really true? Why are people, in gener...
  • AutoCAD Civil 3D 2014: Hidden Command – Export to DGN
    At Ideate we are always digging and searching information to help improve your workflow. Have you ever needed to export your drawing to DGN ...
  • What's in a Multi-Category Schedule?
    Ever wondered what’s in a Autodesk Revit Multi-Category schedule? Here’s the skinny…while a regular Revit Schedule reports on a single cate...
  • Insertion Point: Revit Families
    Question: How do you define/change the insertion point of a Revit Family? Answer: From the properties of the reference planes in the Revit ...
  • The Infamous FILEDIA System Variable
    Here at Ideate, one of the common issues we hear about while on tech support is that a customer is not able to use a dialog box to select fi...
  • Exploded Axonometric Views in Revit 2014: No Problem!
    Thank you for visiting Ideate’s blog to check out the new features added to Autodesk Revit 2014. My name is Shruti Harve and I work as a Sen...

Categories

  • .NET 4.5
  • .NWC file
  • #ADSK2012
  • #ADSK2013
  • #adsk2014
  • #AU2011
  • #AU2012
  • #AU2013
  • 2014
  • 2014 Migration
  • 360
  • 360 account
  • 360 online options
  • 3D
  • 3D Axon
  • 3d design
  • 3d Object
  • 3d Scanning
  • 3D View
  • 3ds Max
  • 3ds Max 2014
  • 3ds Max Design
  • ACI
  • adoption
  • ADSK2014
  • AEC
  • AEC Application Specialist
  • AECbytes
  • AIA
  • AIA CEU
  • AIA LU
  • AIM
  • Air Terminal Duct Enhancement
  • Airborne
  • Alternate Dimensions
  • Annotation Scale Unit Scale
  • Apple Boot Camp
  • Architectural Project Manager
  • ASHRAE
  • Assembly Code
  • Asset Browser
  • assign pay items
  • ATC
  • AU
  • AU 2012
  • Aurecon
  • Authorized Training Center
  • AutoCAD
  • AutoCAD 2012
  • AutoCAD 2013
  • AutoCAD 2014
  • AutoCAD Architecture
  • AutoCAD Civil 3D
  • AutoCAD Civil 3D 2012
  • AutoCAD Civil 3D 2013
  • AutoCAD Civil 3D 2014
  • AutoCAD for Mac
  • AutoCAD for Mac 2013
  • AutoCAD LT
  • AutoCAD Map 3D
  • AutoCAD Mechanical
  • AutoCAD MEP
  • AutoCAD MEP 2012
  • AutoCAD MEP 2013
  • AutoCAD MEP 2014
  • AutoCAD Plant 3D
  • AutoCAD WS
  • Autodesk
  • Autodesk 2014
  • Autodesk 360
  • Autodesk 360 account
  • Autodesk 360 Settings
  • Autodesk 3ds Max Design
  • Autodesk 3ds Max Design 2013
  • Autodesk Authorized Certification Center
  • autodesk authorized developer
  • Autodesk Authorized Training Center
  • Autodesk Autodesk Authorized Training Center
  • Autodesk Autodesk Revit MEP
  • Autodesk Certification
  • Autodesk Certified Instructor
  • Autodesk Civil Infrastructure Specialized
  • autodesk cloud
  • autodesk community
  • autodesk construction specialization
  • Autodesk Consulting Services Partner
  • autodesk corrupt file
  • Autodesk Design Review
  • Autodesk Design Suites
  • Autodesk Ecotect
  • autodesk exchange apps
  • Autodesk Fabrication Specialization
  • autodesk file crash
  • autodesk forum
  • Autodesk Gallery
  • Autodesk Green Building Studio
  • Autodesk Impression
  • autodesk infrastructure modeler
  • Autodesk Instructor Certification
  • Autodesk Labs
  • Autodesk License Manager
  • Autodesk licensing
  • Autodesk M&E
  • Autodesk Maya
  • Autodesk MEP
  • Autodesk MEP 2014
  • autodesk mep systems specialization
  • autodesk mosaic
  • Autodesk Navisworks
  • Autodesk Navisworks 2012
  • Autodesk Navisworks 2013
  • Autodesk Navisworks 2014
  • Autodesk Navisworks Manage
  • Autodesk Navisworks Simulate
  • Autodesk Partner
  • Autodesk Product Support Specialization
  • Autodesk Quantity Takeoff
  • Autodesk ReCap
  • Autodesk Reseller
  • Autodesk Revit
  • Autodesk Revit 2012
  • Autodesk Revit 2013
  • Autodesk Revit 2014
  • autodesk revit architecture
  • Autodesk Revit Architecture 2012
  • autodesk revit architecture 2013
  • Autodesk Revit Architecture 2014
  • Autodesk Revit MEP
  • Autodesk Revit MEP 2013
  • Autodesk Revit MEP 2014
  • Autodesk Revit Structure 2013
  • Autodesk Revit Structure 2014
  • autodesk roadway design
  • Autodesk Showcase
  • autodesk simulation specialization
  • Autodesk SketchBook Pro
  • Autodesk Software
  • Autodesk software installation
  • autodesk specialization
  • Autodesk Structural Engineering Specialization
  • Autodesk Subscription
  • Autodesk Technical Support
  • autodesk training
  • Autodesk University
  • Autodesk Vault
  • AutoLISP
  • Axis
  • Below Ribbon
  • Bentley
  • Best Practices
  • Beyond the Basics
  • bill johnson
  • BIM
  • BIM 360 Field
  • BIMLink
  • bimlink for revit
  • blame
  • Bob Palioca
  • Bradley Cooley
  • BUGIE
  • Building Design Suite
  • building information modeling
  • Bullit Center
  • business
  • Business Analysis
  • BVN Architecture
  • CAD
  • CAD Files in Revit
  • CAD Files. Eugene O'Day
  • CAD Imports
  • CAD Links
  • CADLearning
  • CADLearning Portal
  • Certified Instructor
  • change
  • Citrix
  • Civil
  • Civil 101
  • Civil 3D
  • Civil 3D 2012
  • Civil 3D 2014
  • Civil 3D Fundamentals
  • civil 3D.
  • clash detective
  • Clinton Maulder
  • Cloud
  • cloud 360
  • CloudOn
  • COBie
  • COBie Guide
  • collaborate
  • Collaboration
  • Command Line
  • Commandline
  • commitment
  • Common Materials
  • Competition
  • Conduit Size
  • consulting
  • continuing education
  • corporate culture
  • corridor solids
  • create pipe table
  • create structure table
  • CSV
  • customer satisfaction
  • Cyclone
  • Data
  • Data References
  • Data Shortcuts
  • data sources
  • David Haynes
  • Derek Wielkopolski
  • Diagrammatic 3D views
  • Differentiator
  • Digital Entertainment
  • Displaced Views
  • Displacement
  • disruptive
  • DOE Solar Decathlon
  • drawing audit
  • Dropbox
  • Duct Pipe Elbow Specific Angle
  • DWF
  • dwg
  • Eagle Point
  • Ecotect
  • Ecotect Analysis
  • Edit Materials
  • Edith Green Wendell Wyatt
  • eLearning
  • Electrical Fundamentals
  • elevation analysis
  • enhanced rebar shapes
  • Environmental Science Associates
  • ESA
  • Eugene O'Day
  • Excel
  • Excel to Revit
  • Exploded Axonometric
  • Exploded Isometric
  • Explorer
  • Export
  • export to DGN
  • export to excel
  • FARO
  • fatal error
  • File Repathing
  • File Support
  • File Type
  • FILEDIA
  • Fitting
  • FUD
  • Gary M. Davis
  • gaurav bagga
  • gis
  • Glynnis Patterson
  • Google Maps
  • Google Sheet
  • Green BIM Basics
  • Green Building Studio
  • Hague Justice Portal
  • highways
  • HMC Architects
  • hsw credits
  • Ideate
  • Ideate BIMLink
  • Ideate BIMLink for Revit 2013
  • Ideate BIMLink for Revit 2014
  • Ideate BIMLink for Revit 2014.1
  • Ideate BIMLink Survey
  • Ideate Consulting
  • Ideate Explorer
  • Ideate Explorer for Revit
  • Ideate Explorer for Revit 2013
  • Ideate Explorer for Revit 2014
  • Ideate Inc.
  • Ideate presents
  • IdeateBIMLink
  • IdeateInc
  • improvement
  • IMSCAD
  • Inc.
  • InfaWorks
  • Infrastructure
  • Infrastructure Design Suite
  • Infrastructure Modeler
  • Infrastructure Modeler 2014
  • InfraWorks
  • InfraWorks 360
  • Infraworks R2
  • Inroads
  • Interior Designers
  • Intersection Design Tool
  • intuition
  • Inventor
  • IPD
  • James Cowan
  • Jasmax
  • Javascript
  • Jeld-Wen Field
  • Jim Cowan
  • Jim Quanci
  • Jobsite Inspections
  • Kasian Architecture
  • kate ming
  • Laser Scan
  • Layer Key Style
  • Layer Standard
  • Lean
  • LEED
  • LEED AP
  • LEED Gold
  • Leica
  • license cascading
  • License Manager
  • LIDAR
  • lionakis
  • Lock
  • Lookup Table
  • LPAS Architecture and Design
  • M&E
  • Mac OS
  • Manage Paths
  • Map 3D
  • Marcel de Jong
  • Mark Schoennagel
  • Material Editor
  • Material Library
  • Materials
  • matt miyamoto
  • Maya
  • Maya LT
  • Measurement
  • Mechanical and Plumbing
  • mentor
  • mep
  • MEP 2014
  • MEP Ideate
  • MEP IDeate
  • Microsoft Windows 8
  • Mobile
  • Mobile Apps
  • Model
  • MotionBuilder
  • Move Objects away
  • Mudbox
  • Multi Rebar Annotation
  • Navisworks
  • Navisworks 2014
  • Navisworks Manage
  • negotiation
  • network
  • network deployments
  • Nicholas M Kramer
  • ObjectARX
  • Objects & Label Styles
  • OS X
  • PAE Consulting Engineers
  • Parallel
  • Parallels
  • PAT files
  • Patterns
  • Perpendicular
  • Phased Based
  • Phillippi Engineering
  • Photometric Lights
  • Pipe Network
  • Planning
  • PMI
  • PMP
  • point cloud
  • Point Clouds
  • POINTCLOUD
  • polyline
  • post-mortem
  • preparation
  • Presentations
  • Pressure Network
  • Pressure Pipe
  • Pressure Pipe Networks
  • Pressure Pipe References
  • Pressure Pipe Shortcuts
  • Product Key
  • project galileo
  • project management
  • Project Management Institute
  • Project Management Professional
  • Project Manager
  • Project Neon
  • project silverstar
  • Properties
  • Property Set Definition
  • Proposals
  • PSD Schedule
  • quantity takeoff
  • Randomization
  • RCP
  • RCS
  • Reality Capture
  • RealWorks
  • Rebar Constraints
  • Rebar documentation
  • Recap
  • Registry
  • Reinforcement Rebar Enhancements
  • Reinforcement Rounding
  • Rendering
  • requirements
  • Review
  • Revit
  • Revit 201
  • Revit 2013
  • Revit 2013.3
  • Revit 2014
  • Revit 2014 Model Performance Technical Note
  • Revit Architecture
  • Revit Architecture 2014
  • Revit Architecture Fundamentals
  • revit building information model
  • Revit elevation
  • Revit error
  • Revit Families
  • revit forum
  • Revit Ideate "Ideate Inc." Parameter Variance Vary Group
  • Revit MEP
  • revit mep 2012
  • Revit MEP 2014
  • Revit Model
  • revit multi-category
  • Revit Railings
  • revit schedule
  • revit schedules
  • Revit Server
  • Revit Server 2013
  • Revit Stairs
  • Revit Structure
  • Revit Structure 2012
  • Revit Structure 2014
  • Revit Technology Conference
  • Revit Tip
  • Revit to Excel
  • Revit tool
  • Revit Training
  • Revit User Group
  • Risk
  • roads
  • Robert Palioca
  • Ron Palma
  • RonPalmaAEC
  • Room Aware Families
  • Room Calculation Point
  • RTC
  • RTC Europe
  • RTCUSA
  • RVT
  • sash kazeminejad
  • Scan Data
  • Scanning
  • Scenarios
  • Scoping
  • scripts
  • Selling
  • Services
  • settings
  • SFRUG
  • shruti harve
  • Signage
  • Site tools
  • SketchBook Designer
  • SketchBook Designer 2013
  • Sketchbook Mobile
  • Sketchbook Mobile Express
  • SketchUp
  • solution
  • Spreadsheet
  • Stair Functionality
  • Stairs and Railings
  • Storm and Sanitary Analysis
  • strategy
  • Structural Analytical Model Improvements
  • Structural Rebar
  • Support
  • surface analysis
  • survey
  • Switch Geometry Order
  • SWOT
  • sync settings
  • syncing settings
  • Systems
  • tech support
  • technology
  • Temporary View Properties
  • thinking
  • Time of Flight
  • Tooltip
  • travel
  • Trillium Creek
  • Trimble
  • USGBC
  • Value
  • Vasari
  • Vault
  • VDC
  • View Properties Temporary
  • Virtualization
  • VM Ware
  • Wayfinding
  • William Johnson
  • Windows
  • Windows 8
  • Windows Server 2012
  • workflows
  • Workset
  • worksharing
  • Workspace
  • Xgen

Blog Archive

  • ▼  2013 (204)
    • ▼  November (15)
      • Negotiate - What you do every day
      • eLearning – Upcoming Classes
      • Classroom Training – Open Revit Classes
      • The Benefit of Failure
      • Ideate, Inc. Features Lionakis in Its First Ideate...
      • What's in a Multi-Category Schedule?
      • Commitment to Change
      • Workset Reporting with Ideate Explorer for Revit
      • Classroom Training – Open Revit Classes
      • eLearning – Upcoming Classes
      • When am I done? Why is the customer unhappy?
      • Classroom Training – Open Revit Classes
      • Ideate Presents: Autodesk Digital Entertainment SF...
      • eLearning – Upcoming Classes
      • Big Red Button vs. Elephant Eating
    • ►  October (19)
    • ►  September (14)
    • ►  August (18)
    • ►  July (23)
    • ►  June (14)
    • ►  May (25)
    • ►  April (31)
    • ►  March (15)
    • ►  February (11)
    • ►  January (19)
  • ►  2012 (204)
    • ►  December (13)
    • ►  November (14)
    • ►  October (19)
    • ►  September (18)
    • ►  August (19)
    • ►  July (12)
    • ►  June (17)
    • ►  May (23)
    • ►  April (27)
    • ►  March (19)
    • ►  February (10)
    • ►  January (13)
  • ►  2011 (92)
    • ►  December (10)
    • ►  November (9)
    • ►  October (16)
    • ►  September (13)
    • ►  August (19)
    • ►  July (14)
    • ►  June (11)
Powered by Blogger.

About Me

Unknown
View my complete profile