For some time now we have been coordinating our database of parts in Revit to match our database inventory in Sage 100 Contractor. Well today, I am proud to announce, we have figured it out! All with a simple Dynamo script. The process is simple! We tied a description to all of our parts from Sage to all of our Revit families. We then use Dynamo to use these "Key Families" to parameter map the descriptions of an excel spreadsheet to the prospective "Key Family" in the revit model. This allows us to pull the pricing data in at the end of each job, accurate pricing based on updated excel spreadsheets to our server, and in turn handing off accurate spool drawings with pricing to aid in our initial estimation and fabrication stage. Attached below is the current script and an example of the excel spreadsheet we are using to fuel this data to the parts! Enjoy!
 |
I can’t imagine focusing long enough to research; much less write this kind of article. You’ve outdone yourself with this material. This is great content.
ReplyDeleteexcel vba courses london
Every week you need to complete your task like it says it has to be done the way it is and you could complete them like wise. http://www.professionaltypist.net/professional-typing-services/audio-typing-services/ for the students that is very helpful for the writing services.
ReplyDeleteThanks for sharing the information Construction Documentation in USA
ReplyDelete