tag:blogger.com,1999:blog-70178830486508951872024-02-18T22:27:41.556-08:00BuildinginformationworkerBuildinginformationworkerhttp://www.blogger.com/profile/13803197110189149046noreply@blogger.comBlogger9125tag:blogger.com,1999:blog-7017883048650895187.post-36803351128793667412016-02-10T22:52:00.000-08:002016-02-10T22:52:12.575-08:00Building Ops<table cellpadding="0" cellspacing="0" class="tr-caption-container" style="float: right; margin-left: 1em; text-align: right;"><tbody>
<tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhbk88a-1EHU5cHAK_tlA1MhA3FHkWFQwVLr75qHBFTqnXx9I0nc7fO2YL0kCZSvUtE1t-E2HJd2JSZb3Lijesm7jmWYImEpd4yTRscr5cop354glFTsqymzWkJxGXrVkzNbmDlU0gRs8w/s1600/building+ops.jpg" imageanchor="1" style="clear: right; margin-bottom: 1em; margin-left: auto; margin-right: auto;"><img border="0" height="180" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhbk88a-1EHU5cHAK_tlA1MhA3FHkWFQwVLr75qHBFTqnXx9I0nc7fO2YL0kCZSvUtE1t-E2HJd2JSZb3Lijesm7jmWYImEpd4yTRscr5cop354glFTsqymzWkJxGXrVkzNbmDlU0gRs8w/s320/building+ops.jpg" width="320" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;">Overview of the Building Ops tool</td></tr>
</tbody></table>
It has been a long wait but, with the introduction of <a href="http://www.autodesk.com/products/building-ops/overview" target="_blank">Autodesk Building Ops</a> there is a tool that can be fitted into a workflow from Design, to Build, to Operate <i>(PennState phase names)</i>.<br />
<br />
Over the course of my career I have used several tools to capture building maintenance and they all fell short, where it came to having a connection to the design or build model. Building Ops fills this gap by directly accessing this model information.<br />
<br />
<b>Process to get information in Building Ops</b><br />
Naturally I was curious to get some hands on experience with the capabilities of Building Ops. During the 2015 Christmas period I started an experiment using my own house.<br />
<br />
<ol>
<li>modeled in Revit</li>
<li>exported to BIM 360 Glue (this can be skipped in with the 2016 Revit add-in, but I would recommend to keep using this workflow). </li>
<li>exported the equipment from BIM 360 Glue to BIM 360 Field.</li>
<li>added bar-codes in BIM 360 Field (I will write about this in more detail later). <i>Bar-codes are already nice and relevant when you are working in BIM 360 Field but, it becomes even better with Building Ops. With the bar-code a user can lookup a piece of equipment and log an issue. At the same time all the information available about that piece of equipment will be available both on an information level, such as schematics, purchace dates, etc. as well as a 3D view of the model.</i></li>
<li>exported all information from BIM 360 Field to Building Ops. <i>At the moment the export is only one way.</i></li>
</ol>
<br />
<br />
<b>Platforms</b><br />
Building Ops currently has interfaces to access the Building Ops platform.<br />
<br />
<ul>
<li><b>iOS</b><br />The iOS platform is intended for mobile users.</li>
<li><b>Web</b><br />The Web is the platform intended for the people that will be responsible for tasking and overseeing the service providers. <i>This can also be handled from the iOS, however the larger screen will help here.</i></li>
</ul>
<br />
<b>Users</b><br />
Building Ops is developed to cater to 3 main user groups.<br />
<br />
<ul>
<li><b>tenants / occupants</b><br />This group will be a group of mobile users logging the issues. A room being to hot, window being broken, AC leaking, lights not working, etc. Potentially this can also be used track things, such as chairs, desks, monitors, beds, that sit more on the facilities management side.</li>
<li><b>owners / operators</b><br />This group will be the group that has an interest in understanding and controlling the issues and subsequent actions taken. This group will be involved in the setup of a building, the users, task types, signing service providers, etc. The web-based version will be the primary tool for this group.</li>
<li><b>service providers</b><br />This group consist out of (frame) contractors, such as plumbers, ac maintenance, glas supplier, carpenter, that have been signed on to respond to tasks issued to them through the system. This group will use both the mobile platform as well as the web-based version.</li>
</ul>
<br />
<b>Example #1</b><br />
<table cellpadding="0" cellspacing="0" class="tr-caption-container" style="float: right; margin-left: 1em; text-align: right;"><tbody>
<tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgqE3RwaLQaAKqCQTxf7vmegaj85GBR5b1uenmDhXkCY6KJVd2LEZbsebASB_1CNBZ15ja28DInrZjkGiejvpady18Uot0lXXaTlmwh6vcNNONEcS8Y1Q8pw03hiZ1loDYxsEAgZdCbBqQ/s1600/image1.JPG" imageanchor="1" style="clear: right; margin-bottom: 1em; margin-left: auto; margin-right: auto;"><img border="0" height="240" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgqE3RwaLQaAKqCQTxf7vmegaj85GBR5b1uenmDhXkCY6KJVd2LEZbsebASB_1CNBZ15ja28DInrZjkGiejvpady18Uot0lXXaTlmwh6vcNNONEcS8Y1Q8pw03hiZ1loDYxsEAgZdCbBqQ/s320/image1.JPG" width="320" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;">AC unit with bar-code</td></tr>
</tbody></table>
I currently live in the Middle East and AC units are really needed to make life bearable. At the same time the units will have a lot of issues during a year. Sometimes they will breakdown multiple times in one single week. The current process relies on calling the landlord and ask him to send someone over. Putting a bar-code on all the AC units will make it easier to log and track any issues with the units. This process is very intuitive for tenant, landlord and service provider. <i>Additionally this data can be used for analytics as well. I intent to write more on that later.</i><br />
<br />
<b>Example #2</b><br />
Being involved with building maintenance, I also was confronted with questions related to tracking of more mobile assets such as desk and chairs. Especially schools did not seem to have any records of what they had, while at the same time they were asked to present write off plans to governing bodies. Having a simple bar-code (like some of us will have on their laptops) stuck to these assets will make the difference of throwing things out or holding on to them for another couple of years. <i>I don't envision a model that is continuously updated to have the right table in the right room, that just might prove to labor intensive.</i><br />
<b><br /></b>
<b>What should be brought into Building Ops</b><br />
After all of this the main question will be, how much information should be put into Building Ops. The catch here is that there is no easy one size fits all answer. In my opinion users should restrain a bit, look at which items are already causing issues on a regular basis and put those in. In other words what items will be directly actionable, such as toilets that get blocked, issues related to temperature.<i> The opposite of this is to put items in that have long cycles, painting once every 5 years, replace heater between 15-30 years, recover bituminous roof 10-15 years.A rule of thumb, that I picked up working in the planned maintenance sector, is that 20% of the buildings assets will account for 80% of the maintenance cost.</i><br />
<br />
<br />
<br />Buildinginformationworkerhttp://www.blogger.com/profile/13803197110189149046noreply@blogger.com0tag:blogger.com,1999:blog-7017883048650895187.post-56182878976685985282016-02-07T22:07:00.001-08:002016-02-07T22:07:51.450-08:00"Automated" Org Charts - With Visio and Excel<div class="MsoNormal">
Ever had this situation? You have a list of people and you need to turn it into an
Org Chart. Think BIM execution plan. There is a quick way to do this with a little help from Visio.<br />
<h4>
<b>STEP#1</b></h4>
</div>
<div class="MsoNormal">
<o:p></o:p></div>
<div class="MsoNormal">
Open up Visio and choose for an Organization Chart.<o:p></o:p></div>
<div class="MsoNormal">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjOubHjymbS-c4E1p1N8omI7DrKwaKyoR9dzoUwoMn0kwdG1Ixm_QGM2SGs7qutSMD2rKc0m_TP58kuTXQgov08SOw-HhhQCiLvwnODNAn36I_Q0fQz1c7MR4dZtmQHb1GjscHGe5ZGdQg/s1600/orgchart1.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjOubHjymbS-c4E1p1N8omI7DrKwaKyoR9dzoUwoMn0kwdG1Ixm_QGM2SGs7qutSMD2rKc0m_TP58kuTXQgov08SOw-HhhQCiLvwnODNAn36I_Q0fQz1c7MR4dZtmQHb1GjscHGe5ZGdQg/s1600/orgchart1.png" /></a></div>
<br />
<h4>
<b>STEP#2</b></h4>
<div class="MsoNormal">
In the wizard you will have 2 options use the
list you had or create a new one. I would go for the first option. This way you control the data in Excel and it is good to have a list that you have prepared. <o:p></o:p></div>
<div class="MsoNormal">
<span style="background: yellow; mso-highlight: yellow;"><br /></span></div>
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgzqU4I7kfzRYn5qq3Gf441ahTlxdzdgR26M4XNxpOqg1K9AdigqmRhO2MwCZerB5Z-s-sUjK-6R7zLK-THvIXOLNiCo972MJP-bJ1h-617i2Qca_7n8gZsXhoF0J70hEUbpzfzG2EFc7M/s1600/orgchart2.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em; text-align: center;"><img border="0" height="209" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgzqU4I7kfzRYn5qq3Gf441ahTlxdzdgR26M4XNxpOqg1K9AdigqmRhO2MwCZerB5Z-s-sUjK-6R7zLK-THvIXOLNiCo972MJP-bJ1h-617i2Qca_7n8gZsXhoF0J70hEUbpzfzG2EFc7M/s1600/orgchart2.png" width="320" /></a><br />
<br />
<div>
<br />
<div class="MsoNormal">
<i>NOTE: If you reopen you can also access this wizard through
the import button under Org Chart in the Ribbon.</i><o:p></o:p><br />
<i><br /></i></div>
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh-qc61C6HW0cLcrIh0EqXC5zTaI26CCgOWIqek3Eqf3KUfjiiXb4ooEYZ-OmmdmZsbK7WI441LJLmUVX96nMzwfKQFGbUjgXHiDkqRN52LK5HtR07Ex2mhKWGa1QB-t_PVT-R15Xbh_5Q/s1600/orgchart3.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em; text-align: center;"><img border="0" height="124" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh-qc61C6HW0cLcrIh0EqXC5zTaI26CCgOWIqek3Eqf3KUfjiiXb4ooEYZ-OmmdmZsbK7WI441LJLmUVX96nMzwfKQFGbUjgXHiDkqRN52LK5HtR07Ex2mhKWGa1QB-t_PVT-R15Xbh_5Q/s1600/orgchart3.png" width="320" /></a><br />
<h4>
<b>STEP#3</b></h4>
<div class="MsoNormal">
I will assume you have chosen the first option which will
bring you to the next window. In this window you can select the source type.
Choose for Excel.<o:p></o:p></div>
<div class="MsoNormal">
<br /></div>
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjGblRKR4FTq3ZgfXjlYePN_rVThOdlziqeWJ0bVfff5CaI2qIhyUVMHj9cQeuLVuMkdJ2bbVv-nx9laF2OEceagEcN2QfnGbQ1SJB6ifJeIbp9kRPqQkh-FBVoO1ZjQyYnRkqjSknxwAU/s1600/orgchart4.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em; text-align: center;"><img border="0" height="209" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjGblRKR4FTq3ZgfXjlYePN_rVThOdlziqeWJ0bVfff5CaI2qIhyUVMHj9cQeuLVuMkdJ2bbVv-nx9laF2OEceagEcN2QfnGbQ1SJB6ifJeIbp9kRPqQkh-FBVoO1ZjQyYnRkqjSknxwAU/s1600/orgchart4.png" width="320" /></a><br />
<br />
<div class="MsoNormal">
<i>Note that you can also pull directly from Exchange or ODBC.
Neither of which I have tried.</i></div>
<div class="MsoNormal">
<h4>
STEP#4</h4>
</div>
<div class="MsoNormal">
Once you have selected the source type you can point to your
data by using “Browse…”, Select your file and click “Next”. <o:p></o:p></div>
<div class="MsoNormal">
<br /></div>
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhmDTElQZkiF1lT4TvR9c0L9JoYAqSjDRkpGMCA6YT7-FuiRlBAqfjXY64M4qMWaHQnx1n7zB2fkawCOjmGgbBNJXSeEvNPSsdxO5jtxZw3SXXbtQhJl6jC_LMCh9VpAhDhLp5atNbdAuU/s1600/orgchart5.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em; text-align: center;"><img border="0" height="209" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhmDTElQZkiF1lT4TvR9c0L9JoYAqSjDRkpGMCA6YT7-FuiRlBAqfjXY64M4qMWaHQnx1n7zB2fkawCOjmGgbBNJXSeEvNPSsdxO5jtxZw3SXXbtQhJl6jC_LMCh9VpAhDhLp5atNbdAuU/s1600/orgchart5.png" width="320" /></a><br />
<h4>
STEP#5</h4>
<div class="MsoNormal">
Access will analyze your file and want you to provide some
more information about how your data is structured. An important piece of this
wizard is built around the “Reports to”. This is the field that determines the
place in the org chart.<o:p></o:p><br />
<br /></div>
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgn734zA3hsYTjdP_hDjIn26-SnqeBw_8j2WWD7WMOFddlJMN4bqaBWJefPVYwQJiIZSrdkOQu3kVBlvGLguTO2i9gYy4jaZO658ip80ZgPTirs_3It9wr0YEX6EFzJnkbGkImvqqvVtyE/s1600/orgchart6.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em; text-align: center;"><img border="0" height="209" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgn734zA3hsYTjdP_hDjIn26-SnqeBw_8j2WWD7WMOFddlJMN4bqaBWJefPVYwQJiIZSrdkOQu3kVBlvGLguTO2i9gYy4jaZO658ip80ZgPTirs_3It9wr0YEX6EFzJnkbGkImvqqvVtyE/s1600/orgchart6.png" width="320" /></a><br />
<br />
<div class="MsoNormal">
<i>NOTE 1 a person can only report to one manager. I appreciate
that some organizations have a matrix like structure and that reporting lines
are vague. However I would encourage you to think of a project a standalone
organization.<o:p></o:p></i><br />
<i><br /></i></div>
<div class="MsoNormal">
<i>NOTE 2 a person rolls up only under his manager all the way
up. This means that for me I will report to my manager but not his manager.
This keeps the data clean.</i><o:p></o:p></div>
<div class="MsoNormal">
<h4>
STEP#6</h4>
</div>
<div class="MsoNormal">
Now that we informed on the link between the people it is
time to tell Access a bit more about the information we want to display.<o:p></o:p><br />
<br /></div>
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjzq-Uh9bBseHRpFzypFZJzAEm-93cEX5_QM7IN3J1rrmaH8WvAbbuVB2eC-zS9_sGk_0EuJE8aOLRn3iIOhrVWcGAfQPqHg-39FtiGK6y3bYsl-Gr1iAPU5KsGbZq2t41-jNA1ab2mGtI/s1600/orgchart7.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em; text-align: center;"><img border="0" height="209" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjzq-Uh9bBseHRpFzypFZJzAEm-93cEX5_QM7IN3J1rrmaH8WvAbbuVB2eC-zS9_sGk_0EuJE8aOLRn3iIOhrVWcGAfQPqHg-39FtiGK6y3bYsl-Gr1iAPU5KsGbZq2t41-jNA1ab2mGtI/s1600/orgchart7.png" width="320" /></a><br />
<div class="MsoNormal">
<br />
This section has two places to edit.</div>
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEigIgC_6dyGMVL4cfQDebPoJ-iCMPrTUkY5zgwfN6HoArmzN-OxA_f_EbrQDxOBQVYSWQnYBkI7qq6GPL4Xd04Xi5MEIhv2_l7BJJz_b5WpMzvCaOtb2Efp3G8LT7g6LJk7BVEERzuf1X8/s1600/orgchart8.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em; text-align: center;"><img border="0" height="209" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEigIgC_6dyGMVL4cfQDebPoJ-iCMPrTUkY5zgwfN6HoArmzN-OxA_f_EbrQDxOBQVYSWQnYBkI7qq6GPL4Xd04Xi5MEIhv2_l7BJJz_b5WpMzvCaOtb2Efp3G8LT7g6LJk7BVEERzuf1X8/s1600/orgchart8.png" width="320" /></a><br />
<h4>
STEP#7</h4>
<div class="MsoNormal">
Now you can chose to not use pictures and just jump to step#10 directly or you can choose to add some pictures.<o:p></o:p><br />
<br /></div>
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh1dsQmtdx8lsJhFRGCDJyaL2MmbzvIvhUAQfkLZ5OwpPXucoB59msweYEsjFPROR5eKMGEZ6jabY9Q9SEGNEnJHdqf9JX8QzuUjAs5MsdF7d-L764WI9Hopv5HnJyIgrPbjmg6Oop5a60/s1600/orgchart9.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em; text-align: center;"><img border="0" height="209" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh1dsQmtdx8lsJhFRGCDJyaL2MmbzvIvhUAQfkLZ5OwpPXucoB59msweYEsjFPROR5eKMGEZ6jabY9Q9SEGNEnJHdqf9JX8QzuUjAs5MsdF7d-L764WI9Hopv5HnJyIgrPbjmg6Oop5a60/s1600/orgchart9.png" width="320" /></a><br />
<div class="MsoNormal">
<h4>
STEP#8</h4>
</div>
<div class="MsoNormal">
I like to add visual information so I will add the pictures.
Do that by creating a folder one level below where you have stored your Visio
(and Excel) file. In theory *.PNG should wold but I have only made it work with *.JPG<o:p></o:p><br />
<br /></div>
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg3qZGy-r89oiU-uyVChg6QKHPln4j6VD4-tUsfdkL79QusSRxe2ZznU6U4m5OVLnR-QymxJ7S2DhfWXS9u0b9CqPuon_rjnWyl_UYjs7Pzcw7UABPTAdZ8j2GmDBLjv8Ahu1ThcRE1Qow/s1600/orgchart10.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em; text-align: center;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg3qZGy-r89oiU-uyVChg6QKHPln4j6VD4-tUsfdkL79QusSRxe2ZznU6U4m5OVLnR-QymxJ7S2DhfWXS9u0b9CqPuon_rjnWyl_UYjs7Pzcw7UABPTAdZ8j2GmDBLjv8Ahu1ThcRE1Qow/s1600/orgchart10.png" /></a><br />
<i>Note for this tutorial I ran a search on Google for logo's and used these to test the principle. As I do not own the copyright to these logo's I will not show them here.</i><br />
<h4>
STEP#9</h4>
<div class="MsoNormal">
Inform Visio of the name that you used for the image files. Consider this before you start setting up your data. There will always be with the first name, some will even have the same first and last name. So if you want to use images of people make sure you are using something more unique, e.g. an employee ID#.<o:p></o:p><br />
<br />
When creating BEP's I like to have a clear overview of who is from which company, so I use company logo's. This chart will not be used by the team working on the project. They can an will use the communications table so many BEP's start with. This information is more for the people around the project.<br />
<br /></div>
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiyASCAoyMzVrc4imdeGeSwvfzGszzmLmxe8zlYLKS_aDbPNzqXGT9wvriAXggwzG6oE_FttcZw51xWTRxB4U8HSzgKyeYQtyhTnSzFnEz7VHytniU91ysNA6myoju760q9uJ56tyBiom4/s1600/orgchart11.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em; text-align: center;"><img border="0" height="209" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiyASCAoyMzVrc4imdeGeSwvfzGszzmLmxe8zlYLKS_aDbPNzqXGT9wvriAXggwzG6oE_FttcZw51xWTRxB4U8HSzgKyeYQtyhTnSzFnEz7VHytniU91ysNA6myoju760q9uJ56tyBiom4/s1600/orgchart11.png" width="320" /></a><br />
<br />
<div class="MsoNormal">
<i>NOTE that a denominator like Organization is smaller than a individual "name".</i><o:p></o:p></div>
<div class="MsoNormal">
<h4>
STEP#10</h4>
</div>
<div class="MsoNormal">
The most important part is telling Visio how to export
the information. If you do nothing access will start to aggregate and output
sheets based on:<o:p></o:p></div>
<div class="MsoListParagraphCxSpFirst" style="mso-list: l0 level1 lfo1; text-indent: -18.0pt;">
<!--[if !supportLists]-->-<span style="font-size: 7pt; font-stretch: normal;">
</span><!--[endif]-->Reports to<o:p></o:p></div>
<div class="MsoListParagraphCxSpLast" style="mso-list: l0 level1 lfo1; text-indent: -18.0pt;">
<!--[if !supportLists]-->-<span style="font-size: 7pt; font-stretch: normal;">
</span><!--[endif]-->Organization<o:p></o:p></div>
<div class="MsoNormal">
and you could easily end up with more than 10 sheets.<o:p></o:p><br />
<br />
To counter this, use the option to tell Visio that you want to be in charge of which data gets used and how it should be presented.<br />
<br /></div>
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjltXHOc3-oG2DLNSJ1C_U17kAxRgZLdaPBEeflUJYUjZ4yCp62C4-lozm66yHlNF61H5BEW4jL26KzZsrK7enOiieCg9697BgxGrjoBjObssrSSpmv9b33GVRT2AV0viHORyV15SbhOn4/s1600/orgchart12.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em; text-align: center;"><img border="0" height="209" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjltXHOc3-oG2DLNSJ1C_U17kAxRgZLdaPBEeflUJYUjZ4yCp62C4-lozm66yHlNF61H5BEW4jL26KzZsrK7enOiieCg9697BgxGrjoBjObssrSSpmv9b33GVRT2AV0viHORyV15SbhOn4/s1600/orgchart12.png" width="320" /></a><br />
<h4>
STEP#11</h4>
<div class="MsoNormal">
If the this page holds any all the pages that are there and start setting up new
ones.<o:p></o:p><br />
<br /></div>
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiC4vtfj3YknX76-kHEKGbmMHRBsZSrE7VwY6FUdcjHTGjBwTx8hyNwTPrlcbOi7kt5kuQKp7Fx19f8OfhggJ04zYRuQR9RKbf4g2WNH-mG_ZNI_N3FFzyt3PSXv0LyIOvjnezZRFHJSN4/s1600/orgchart13.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em; text-align: center;"><img border="0" height="209" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiC4vtfj3YknX76-kHEKGbmMHRBsZSrE7VwY6FUdcjHTGjBwTx8hyNwTPrlcbOi7kt5kuQKp7Fx19f8OfhggJ04zYRuQR9RKbf4g2WNH-mG_ZNI_N3FFzyt3PSXv0LyIOvjnezZRFHJSN4/s1600/orgchart13.png" width="320" /></a><br />
<br />
<i>NOTE that if you change your data source to another source because you need or have another Org Chart you want to create. </i><br />
<h4>
STEP#</h4>
<div class="MsoNormal">
Click add to start the wizard. Select<o:p></o:p></div>
<div class="MsoListParagraphCxSpFirst" style="mso-list: l0 level1 lfo1; text-indent: -18.0pt;">
<!--[if !supportLists]-->-<span style="font-size: 7pt; font-stretch: normal;">
</span><!--[endif]-->The top level “Name at top of page”<o:p></o:p></div>
<div class="MsoListParagraphCxSpMiddle" style="mso-list: l0 level1 lfo1; text-indent: -18.0pt;">
<!--[if !supportLists]-->-<span style="font-size: 7pt; font-stretch: normal;">
</span><!--[endif]-->The depth of the chart “Number of additional
levels”<o:p></o:p></div>
<div class="MsoListParagraphCxSpLast" style="mso-list: l0 level1 lfo1; text-indent: -18.0pt;">
<!--[if !supportLists]-->-<span style="font-size: 7pt; font-stretch: normal;">
</span><!--[endif]-->A name for you page “Page Name”<o:p></o:p><br />
<br /></div>
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgY1gEpWfed0AhBbVr1cr92qGuOK0iTyOT5gUJq-ACWVv1e4aXznZxPYV3HkyREgwBZOELg3CK8aqgM_i66o7DQ2Ykg-z_G4mKYPHTd8hFoNO4jb7CvQWN8urTBHdcLjNMkwX1c2pO4kJI/s1600/orgchart14.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em; text-align: center;"><img border="0" height="199" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgY1gEpWfed0AhBbVr1cr92qGuOK0iTyOT5gUJq-ACWVv1e4aXznZxPYV3HkyREgwBZOELg3CK8aqgM_i66o7DQ2Ykg-z_G4mKYPHTd8hFoNO4jb7CvQWN8urTBHdcLjNMkwX1c2pO4kJI/s1600/orgchart14.png" width="320" /></a><br />
<h4>
STEP#</h4>
<div class="MsoNormal">
Click “OK” when done.<o:p></o:p></div>
<div class="MsoNormal">
Click “Finish” in the overview of sheets to generate your
sheets.<o:p></o:p></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
You will see Access read and generate sheets for you. Be
sure to check if the images you have defined come in. If not try to find out
what is wrong by using the dedicated buttons in the ribbon.<o:p></o:p><br />
<br /></div>
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiddhy-oiU7jDT3bbv3LXp7cCvWRTAc0y408qJUKvEyb6fqApeXcmFu5TemxPfn3FdGo37rc4dMo71lY4M5VtwfG_7WNJaIShhfoYll777AGHpLDzqlNN5Q1ozGGuQgYLJwzPIv0_LVkmc/s1600/orgchart15.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em; text-align: center;"><img border="0" height="124" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiddhy-oiU7jDT3bbv3LXp7cCvWRTAc0y408qJUKvEyb6fqApeXcmFu5TemxPfn3FdGo37rc4dMo71lY4M5VtwfG_7WNJaIShhfoYll777AGHpLDzqlNN5Q1ozGGuQgYLJwzPIv0_LVkmc/s1600/orgchart15.png" width="320" /></a><br />
<h4>
STEP#</h4>
<div class="MsoNormal">
If you made sure your images work it is time to focus on the
formatting of the chart. If you brought in large quantities of data you will
see that the sheet gets clogged up. I would recommend tweaking your layout
until it looks nice.<o:p></o:p></div>
<div class="MsoNormal">
Generally speaking don’t go down more than 2 levels in
horizontal mode.<o:p></o:p><br />
<br /></div>
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi1XYhRWfGoZACBy5IjXUtOBSLlPY91uHT6G9jKxTiZsY9BB5avWjBuWZqg2JWofYe5SWYILtD8S7jc7zXEVG0tDnMj9qoC1p-MgEn5U8uCCwXhwZko0h8lsu3-7G-VxH7vLy_6wYQafoM/s1600/orgchart16.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em; text-align: center;"><img border="0" height="279" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi1XYhRWfGoZACBy5IjXUtOBSLlPY91uHT6G9jKxTiZsY9BB5avWjBuWZqg2JWofYe5SWYILtD8S7jc7zXEVG0tDnMj9qoC1p-MgEn5U8uCCwXhwZko0h8lsu3-7G-VxH7vLy_6wYQafoM/s1600/orgchart16.png" width="320" /></a><br />
<br />
<div class="MsoNormal">
I hope this helps you create your org charts in an easy way. Happy Charting<o:p></o:p></div>
</div>
Buildinginformationworkerhttp://www.blogger.com/profile/13803197110189149046noreply@blogger.com0tag:blogger.com,1999:blog-7017883048650895187.post-34628876668661648782016-02-07T01:20:00.000-08:002016-02-07T02:38:12.971-08:00NL-SFB Item Catalogue Schema for NavisworksQuite recently I have been documenting workflows on how to use the Quantity Take Off (QTO) feature in Navisworks.<br />
<br />
One of the first things Navisworks will ask you to do when setting up your model for QTO purposes <br />
is to identify an "item catalogue". This item catalogue is used by Naviswork to create Work Breakdown Structure (WBS) of the model. This WBS is usually dependent on what has been identified in the Project and/or BIM execution plan. This in turn will vary based on your location. <br />
<br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgD-uDp0IPVzqdWydWhw95gp0lv4OtcroOMJqChyTO2aqLkU1Z4zdRKNKKliEBt19j_pFOgpFm-S_SvZ7NYL9IZ8e3_PX_bvPY2RFsavVr6_aMY6t0wSy9ILwsL5K9BsAnx_cJ1cazEgW4/s1600/QTO+wizard.jpg" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="217" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgD-uDp0IPVzqdWydWhw95gp0lv4OtcroOMJqChyTO2aqLkU1Z4zdRKNKKliEBt19j_pFOgpFm-S_SvZ7NYL9IZ8e3_PX_bvPY2RFsavVr6_aMY6t0wSy9ILwsL5K9BsAnx_cJ1cazEgW4/s320/QTO+wizard.jpg" width="320" /></a>Although I have been working internationally for 3 years now, I do still revert back to the Dutch coding system I grew up with the NL-SFB. The reason for this is that most of the codes used seem to be hardwired into my brain.<br />
<br />
<i>NL-SFB is predominantly used by engineers to breakdown a model of a building. Next to NL-SFB there is aslo a Stabu-coding which is mostly used by contractors and quantity surveyors. More on both can be found <a href="http://www.stabu.org/" target="_blank">here</a>.</i><br />
<br />
<br />
I was surprised to see that no one had made a custom NL-SFB catalogue available as a download. So decided to create my own. Using the information and the Excel spreadsheet made available on <a href="http://help.autodesk.com/view/NAV/2015/ENU/?guid=GUID-5C6AE212-ACE5-4B08-A591-C71245F78A09" target="_blank">Autodesk Help</a> I was able to generate the required .XML that Navisworks needs to create a WBS. Once you have gone through the wizard the WBS will appear in Navisworks. If you don't like the breakdown at this stage, hit CTRL + Z to undo. You can omport an updated version of your item catalogue using the Import option on the QTO Workbook Ribbon.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjBTSdTA62lwRMF-bsJdqlurCOXF7ZinfdlZwB3yuoGtQIahwpl4ZSDFOiTyWi39Wlr9Z6YfLboOb02bI2nxLuoK2KUWNS_kRj-fKhAAo3KfLwmKYnmKr0RnuCa_8C5LKcfEK6j34Tdh8w/s1600/wbs+reload.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="107" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjBTSdTA62lwRMF-bsJdqlurCOXF7ZinfdlZwB3yuoGtQIahwpl4ZSDFOiTyWi39Wlr9Z6YfLboOb02bI2nxLuoK2KUWNS_kRj-fKhAAo3KfLwmKYnmKr0RnuCa_8C5LKcfEK6j34Tdh8w/s320/wbs+reload.jpg" width="320" /></a></div>
<br />
<br />
On the highest level it looks like this. For the Dutch users, no I have not created the high level roll up, this would require an adding an extra character.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgnj605vUehnerEjLV_tbuMJDkF9LYJ6hJ7JzUX91RPONlJHJ9UN2cTIxOodh6sBXcKMB3PcM5626cBOFqnMNmupt6E_X-JQ28WlR8HK6TRr6vvrAslRslIHXyVgDTo5T0FJPkbtAiB0CM/s1600/qto+wbs+tree1.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="269" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgnj605vUehnerEjLV_tbuMJDkF9LYJ6hJ7JzUX91RPONlJHJ9UN2cTIxOodh6sBXcKMB3PcM5626cBOFqnMNmupt6E_X-JQ28WlR8HK6TRr6vvrAslRslIHXyVgDTo5T0FJPkbtAiB0CM/s320/qto+wbs+tree1.jpg" width="320" /></a></div>
<br />
<br />
Drilling down to lowest level.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh3wFrqlnN32N0rwGbbZx9XKB69dBiT_3V4kONUI3UYK9SjpfGO80qKfDLmbFAbfBZ-cGuH875b5Nel5MWm3tVEsQnVKC0uW9ZO-3ywtBkDMt99r1_op9SGXJX7-CKHc4OuogltqOv1kXg/s1600/qto+wbs+tree2.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="127" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh3wFrqlnN32N0rwGbbZx9XKB69dBiT_3V4kONUI3UYK9SjpfGO80qKfDLmbFAbfBZ-cGuH875b5Nel5MWm3tVEsQnVKC0uW9ZO-3ywtBkDMt99r1_op9SGXJX7-CKHc4OuogltqOv1kXg/s320/qto+wbs+tree2.jpg" width="320" /></a></div>
<br />
Kindly note that this is only the WBS. In order to perform QTO one will also need to create a list of resources. These can be defined in the same Excel spreadsheet.<br />
<br />
For more information exchanging .XML files feel free to reach out to me.Buildinginformationworkerhttp://www.blogger.com/profile/13803197110189149046noreply@blogger.com6tag:blogger.com,1999:blog-7017883048650895187.post-57210739610273671132014-12-31T05:20:00.000-08:002014-12-31T05:20:20.567-08:00TranslateTranslation of words and terms is something that becomes more and more integrated in our day to day work. Please see the video from <a class="ob tv Ub Hf" href="https://plus.google.com/u/0/107437543535682792496" oid="107437543535682792496" style="-webkit-transition: color 0.218s; color: #262626; cursor: pointer; font-weight: bold; transition: color 0.218s;"><span style="font-family: Roboto, arial, sans-serif;"><span style="font-size: 14px;">+</span></span>DanielMonsén</a>. He demonstrates how you can translate something from language A to B in Revit. NOTE He does use an additional Plug-In, so don't cheer to soon.<br />
<br />
During the past year if have studied how one could translate between Classification systems by using a database. The method Daniel uses is based on the same philosophy, search and replace. NOTE When changing/translating a classification system you will have to do some work manually.<br />
<br />
I will now show you the essence of Daniels work.<br />
<br />
The first thing you need is a Google account connected to GoogleDocs. Within Spreadsheets there is a feature that you probably will have used before, GoogleTranslate. Now start a new Spreadsheet and type<br />
<br />
"<i>=Google....</i>"<br />
<br />
you will be given the opportunity to select the Translate function. The "wizard" will guide you through all the steps.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhFA_YANkrrCx-9r1BxZn11f1hSHksiIuv1AWiNxTNBBphxRUKIOD7JqwLB4La8ZS6G8oAnpiMBp2CgyZ2SlJf8iZXNShpdY1bl2Gf75RNHCpQxfaeTOvht9KkzOzSwcRAO5Wa9P9mViR0/s1600/translate-3.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhFA_YANkrrCx-9r1BxZn11f1hSHksiIuv1AWiNxTNBBphxRUKIOD7JqwLB4La8ZS6G8oAnpiMBp2CgyZ2SlJf8iZXNShpdY1bl2Gf75RNHCpQxfaeTOvht9KkzOzSwcRAO5Wa9P9mViR0/s1600/translate-3.PNG" height="235" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhujF-mjIByjm4TnjL6O7K4KonmBptEcRx8X25xXd48tfZ2GnrQbxMNCKy3utQy-cd8L0OPmyJUNu7Y5F277vocZ4dXLtFvmkg77erpT12fTkFcVcEcQSMaAFkuogyuA_IwrrIuWEzFORY/s1600/translate-2.PNG" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><br /></a><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhujF-mjIByjm4TnjL6O7K4KonmBptEcRx8X25xXd48tfZ2GnrQbxMNCKy3utQy-cd8L0OPmyJUNu7Y5F277vocZ4dXLtFvmkg77erpT12fTkFcVcEcQSMaAFkuogyuA_IwrrIuWEzFORY/s1600/translate-2.PNG" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><br /></a>I strongly recommend to have a list of words. That way you can see the result of your work directly.<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhujF-mjIByjm4TnjL6O7K4KonmBptEcRx8X25xXd48tfZ2GnrQbxMNCKy3utQy-cd8L0OPmyJUNu7Y5F277vocZ4dXLtFvmkg77erpT12fTkFcVcEcQSMaAFkuogyuA_IwrrIuWEzFORY/s1600/translate-2.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhujF-mjIByjm4TnjL6O7K4KonmBptEcRx8X25xXd48tfZ2GnrQbxMNCKy3utQy-cd8L0OPmyJUNu7Y5F277vocZ4dXLtFvmkg77erpT12fTkFcVcEcQSMaAFkuogyuA_IwrrIuWEzFORY/s1600/translate-2.PNG" height="172" width="640" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both;">
I have modified the formula in my Spreadsheet. Depending on the place in the formula I have blocked either row or column. This give you more freedom to copy or stretch your formula or if you want to add additional TARGETLANGUAGES.</div>
<div class="separator" style="clear: both;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjnjZhYnZvFfVDF0fe6IDu3y00MFtff8Gd1E9DQysa18DD1IscMh1BDaxUu0iS38zse71t6GyP1HI6PXAG4ZIZsb2jMvvMKJW3jOdnO7EgSjXnaNC0Pil2a_hDOmNDzODYPBzpK8V0k0Y8/s1600/translate-4.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjnjZhYnZvFfVDF0fe6IDu3y00MFtff8Gd1E9DQysa18DD1IscMh1BDaxUu0iS38zse71t6GyP1HI6PXAG4ZIZsb2jMvvMKJW3jOdnO7EgSjXnaNC0Pil2a_hDOmNDzODYPBzpK8V0k0Y8/s1600/translate-4.PNG" height="26" width="320" /></a></div>
<div class="separator" style="clear: both;">
<br /></div>
<div class="separator" style="clear: both;">
For those who are new to the world of spreadsheets I will explain how the formula is build up. (note that I started in B2)</div>
<div class="" style="clear: both;">
</div>
<ul>
<li>$A2<br />Always use COLUMN A </li>
<li>SOURCELANGUAGE<br />Always use CEL A1</li>
<li>TARGETLANGUAGE<br />Always use ROW 1 for the column the cel is in. (again note that I started in B2)</li>
</ul>
<br />Buildinginformationworkerhttp://www.blogger.com/profile/13803197110189149046noreply@blogger.com0tag:blogger.com,1999:blog-7017883048650895187.post-82951763965131927432014-12-31T04:57:00.001-08:002015-01-04T20:32:43.705-08:00Vertalen - NLHet vertalen van woorden is iets dat met internationaal BIM steeds vaker voorkomt. Zie ook de video van <a class="ob tv Ub Hf" href="https://plus.google.com/u/0/107437543535682792496" oid="107437543535682792496" style="-webkit-transition: color 0.218s; color: #262626; cursor: pointer; font-weight: bold; transition: color 0.218s;">+DanielMonsén</a> die laat zien hoe je iets van taal A in taal B omzet in Revit. NB hij gebruikt naast de onderstaande werkwijze nog een aanvullende Plug-In, dus niet te vroeg juichen ;-).<br />
<br />
Zelf heb ik mij het afgelopen jaar verdiept in Classificatie en hoe je die met behulp van een Database snel zou kunnen vertalen. De truc die Daniel gebruikt is gebaseerd op de zelfde techniek zoek en vervang. Bij een classificatie systeem zul je echter de link eerst met de hand moeten leggen.<br />
<br />
Ik zal je laten zien hoe de truc van Daniel of beter Google werk.<br />
<br />
Het eerste wat je nodig hebt is een Google account met GoogleDocs. Binnen Spreadsheets heb je dan een handige functie tot je beschikking die je vast al vaker gebruikt, namelijk GoogleTranslate. Start een nieuw Spreadsheet en type<br />
<br />
"<i>=Google....</i>"<br />
<br />
en je kunt de functie direct selecteren. Je krijgt een handig hulp menu dat je door je stappen heen leidt.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhFA_YANkrrCx-9r1BxZn11f1hSHksiIuv1AWiNxTNBBphxRUKIOD7JqwLB4La8ZS6G8oAnpiMBp2CgyZ2SlJf8iZXNShpdY1bl2Gf75RNHCpQxfaeTOvht9KkzOzSwcRAO5Wa9P9mViR0/s1600/translate-3.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhFA_YANkrrCx-9r1BxZn11f1hSHksiIuv1AWiNxTNBBphxRUKIOD7JqwLB4La8ZS6G8oAnpiMBp2CgyZ2SlJf8iZXNShpdY1bl2Gf75RNHCpQxfaeTOvht9KkzOzSwcRAO5Wa9P9mViR0/s1600/translate-3.PNG" height="235" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhujF-mjIByjm4TnjL6O7K4KonmBptEcRx8X25xXd48tfZ2GnrQbxMNCKy3utQy-cd8L0OPmyJUNu7Y5F277vocZ4dXLtFvmkg77erpT12fTkFcVcEcQSMaAFkuogyuA_IwrrIuWEzFORY/s1600/translate-2.PNG" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><br /></a><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhujF-mjIByjm4TnjL6O7K4KonmBptEcRx8X25xXd48tfZ2GnrQbxMNCKy3utQy-cd8L0OPmyJUNu7Y5F277vocZ4dXLtFvmkg77erpT12fTkFcVcEcQSMaAFkuogyuA_IwrrIuWEzFORY/s1600/translate-2.PNG" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><br /></a>Ik raad je aan om alvast een rijtje met woorden klaar te zetten zodat je direct ziet wat het resultaat is.<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhujF-mjIByjm4TnjL6O7K4KonmBptEcRx8X25xXd48tfZ2GnrQbxMNCKy3utQy-cd8L0OPmyJUNu7Y5F277vocZ4dXLtFvmkg77erpT12fTkFcVcEcQSMaAFkuogyuA_IwrrIuWEzFORY/s1600/translate-2.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhujF-mjIByjm4TnjL6O7K4KonmBptEcRx8X25xXd48tfZ2GnrQbxMNCKy3utQy-cd8L0OPmyJUNu7Y5F277vocZ4dXLtFvmkg77erpT12fTkFcVcEcQSMaAFkuogyuA_IwrrIuWEzFORY/s1600/translate-2.PNG" height="172" width="640" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
Ik heb de functie in mijn Spreadsheet aangepast, waarbij ik afhankelijk van de plaats in de formule de rij of de kolom heb geblokkeerd. Dit is handig wanneer je rij met woorden langer wordt, je een andere BRONTAAL of DOELTAAL wilt instellen. Met andere woorden de formule is nu kopieerbaar.</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjnjZhYnZvFfVDF0fe6IDu3y00MFtff8Gd1E9DQysa18DD1IscMh1BDaxUu0iS38zse71t6GyP1HI6PXAG4ZIZsb2jMvvMKJW3jOdnO7EgSjXnaNC0Pil2a_hDOmNDzODYPBzpK8V0k0Y8/s1600/translate-4.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjnjZhYnZvFfVDF0fe6IDu3y00MFtff8Gd1E9DQysa18DD1IscMh1BDaxUu0iS38zse71t6GyP1HI6PXAG4ZIZsb2jMvvMKJW3jOdnO7EgSjXnaNC0Pil2a_hDOmNDzODYPBzpK8V0k0Y8/s1600/translate-4.PNG" height="26" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
Voor diegene die nieuw zijn in de wereld van spreadsheets zal ik uitleggen hoe de functie hierboven, geknipt uit cel B2, is opgebouwd.</div>
<div class="" style="clear: both; text-align: left;">
</div>
<ul>
<li>$A2<br />Altijd kolom A gebruiken </li>
<li>BRONTAAL<br />Altijd CEL A1 gebruiken</li>
<li>DOELTAAL<br />Altijd de eerste rij gebruiken uit de kolom waarin de CEL (waarin je staat) zich bevind.</li>
</ul>
<div>
Ik ben zeer aangenaam verrast door de accuraatheid van de vertaling. Deze is beter met enkele woorden maar ook kleine zinnetjes laten zich vertalen. Momenteel gebruik ik het samen met <a class="g-profile" href="https://plus.google.com/114168343342240477139" target="_blank">+anne westerhoven</a> om de kinderen Engels te leren. Ze mogen dan zelf elke week 10 woorden op mama's of papa's computer in tikken en printen voor op de ijskast. Zo leren ze en Engels en werken met een spreadsheet, iets waarvan ik denk dat je er niet vroeg genoeg mee kan beginnen.</div>
<br />
<br />Buildinginformationworkerhttp://www.blogger.com/profile/13803197110189149046noreply@blogger.com0tag:blogger.com,1999:blog-7017883048650895187.post-31975269824966226822014-12-30T00:49:00.000-08:002014-12-30T00:49:33.582-08:00Navisworks Datatools - ENSomething that I find fundamental to BIM is that it offers the opportunity to see, add and enrich data.<br />
<br />
In most cases this done during the design stage, by adding parameters / values, in one of the many design authoring platforms. But how can you do this if the design is frozen? Can data still be added to a BIM? Can maintenance information, from a separate database, be linked to the model? Can you add an additional classification system?<br />
<br />
Through the use of Navisworks this seems possible. I will give a short instruction on how to do this. For more detail I refer to my AU2014 Class - <i>AB6967 Navisworks And Classification Based Model Checking</i> that I did together with <a href="http://t.co/O39dVsY2nA" target="_blank">Rob Oud</a>. In this class we will go a bit deeper, however the principle stays replace A with B.<br />
<br />
<u>Step 1</u><br />
Select the data you want to link to and open the selection inspector.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg1RgGt2RYhTR5aF-oZJhi02GlbOfirS6cS_DqRqNi4GRce8fmW6ZElvFKpIUs_qp6LEF_EYQ1aWognC8GpPen8xNyupdwf26Nmg_oKo8y8A2YkV-TPti98IFgrdaeYdTS07DpP7G2HyEE/s1600/datatools-1.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg1RgGt2RYhTR5aF-oZJhi02GlbOfirS6cS_DqRqNi4GRce8fmW6ZElvFKpIUs_qp6LEF_EYQ1aWognC8GpPen8xNyupdwf26Nmg_oKo8y8A2YkV-TPti98IFgrdaeYdTS07DpP7G2HyEE/s1600/datatools-1.png" height="291" width="320" /></a></div>
<br />
Look through the fields and ensure yourself you have all the fields that will help you understand the data when you want to link it to other data. <b>Make sure that you also include a unique indentifier</b>. When you are done export to *.CSV<br />
<br />
<u>Step 2</u><br />
Open the *.CSV in Excel add columns with the new data. You could use search functions in excel to make it easier to yourself. It doesn't really matter how you do it as long as your new columns get filled with data. When you are done save your file as a *.xlsx<br />
<br />
<u>Step 3</u><br />
Now that you have enriched your data in Excel you will need to move the data to Access. Basically there are 2 way to do this.<br />
<ol>
<li>Import the entire worhsheet into Access.</li>
<li>Copy the columns into Access<br /><i>I am indifferent, but if you are new to Access I would start with this choice</i>. </li>
</ol>
<div>
If you have done everything correctly you should see something like the image below. In that table I have added Uniclass and Omniclass to my dataset.</div>
<div>
<br /></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjGFtQ2NYZVJKGQkNg2z3dhWs1z5dr5YQ_qL8s-2pCEnaJpzXhxlB6e4MSeOFnuEtZh53LW5QpdS-frOg9rLIvL5Q2wkh8mks8pLyNrhHIBXhPN5bvMCoDDYftxUVqyfoZRxg2SBK7KUbU/s1600/datatools-2.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjGFtQ2NYZVJKGQkNg2z3dhWs1z5dr5YQ_qL8s-2pCEnaJpzXhxlB6e4MSeOFnuEtZh53LW5QpdS-frOg9rLIvL5Q2wkh8mks8pLyNrhHIBXhPN5bvMCoDDYftxUVqyfoZRxg2SBK7KUbU/s1600/datatools-2.png" height="87" width="400" /></a></div>
<br />
<u>Step 4</u><br />
For this final step I will give some more instruction. If you make 1 mistake you data won't be linked.<br />
<br />
In Navisworks click on datatools to open the wizard. Choose "New.." to create a new connection.<br />
<ol>
<li>Name your connection</li>
<li>Choose Access in ODBC.<br /><i>Other connections are also possible, but I found them to be either difficult or more prone not to work.</i></li>
<li>Define a search string.</li>
<li>Inform which field values you want to bring in.</li>
</ol>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEibxiJtL7LA34sTAj2fYZmO6MK1x2bLIdVxEZctbhdDMH3wJYnmVb2MFreN3O4i32P1R8BuSFzd47z13cDlu-eQRFPRY3GrcEH57UjyEubd5oxTUyP6ofzPJ4p0KuUTwg1LL-tWBRSUzKk/s1600/datatools-3.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEibxiJtL7LA34sTAj2fYZmO6MK1x2bLIdVxEZctbhdDMH3wJYnmVb2MFreN3O4i32P1R8BuSFzd47z13cDlu-eQRFPRY3GrcEH57UjyEubd5oxTUyP6ofzPJ4p0KuUTwg1LL-tWBRSUzKk/s1600/datatools-3.png" height="220" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both;">
Step 1 and 2 are reasonable self explanatory, the devil is in in 3 and some in 4. The search string needs to be done just right. A space to many or to few and the link doesn't work. I recommend to use Notepad when defining the search string.</div>
<div class="separator" style="clear: both;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgBV8mnaF_fSVX7uuC9S15XlOraLTb8JuJ8fz1ZIWRnQ8Hd06ENFJq9aXQih7FjJIV3it3mMhkP0TKY546nnr1qKU01nJv25f4Y6eXFTsfRh5vB9BGqjzMEjWTuZRDKw1Ob2ulU0IgMkEM/s1600/datatools-5.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgBV8mnaF_fSVX7uuC9S15XlOraLTb8JuJ8fz1ZIWRnQ8Hd06ENFJq9aXQih7FjJIV3it3mMhkP0TKY546nnr1qKU01nJv25f4Y6eXFTsfRh5vB9BGqjzMEjWTuZRDKw1Ob2ulU0IgMkEM/s1600/datatools-5.png" height="64" width="640" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both;">
I will now explain how this string is build up.</div>
<div class="separator" style="clear: both;">
<br /></div>
<table border="1" cellpadding="0" cellspacing="0" class="MsoTable15Grid4Accent1" style="border-collapse: collapse; border: none; mso-border-alt: solid #95B3D7 .5pt; mso-border-themecolor: accent1; mso-border-themetint: 153; mso-padding-alt: 0cm 5.4pt 0cm 5.4pt; mso-yfti-tbllook: 1184;"><tbody>
<tr><td style="background: #4F81BD; border-right: none; border: solid #4F81BD 1.0pt; mso-background-themecolor: accent1; mso-border-bottom-alt: solid #4F81BD .5pt; mso-border-bottom-themecolor: accent1; mso-border-left-alt: solid #4F81BD .5pt; mso-border-left-themecolor: accent1; mso-border-themecolor: accent1; mso-border-top-alt: solid #4F81BD .5pt; mso-border-top-themecolor: accent1; padding: 0cm 5.4pt 0cm 5.4pt; width: 239.4pt;" valign="top" width="399"><div class="MsoNormal">
<b>Code<o:p></o:p></b></div>
</td><td style="background: #4F81BD; border-left: none; border: solid #4F81BD 1.0pt; mso-background-themecolor: accent1; mso-border-bottom-alt: solid #4F81BD .5pt; mso-border-bottom-themecolor: accent1; mso-border-right-alt: solid #4F81BD .5pt; mso-border-right-themecolor: accent1; mso-border-themecolor: accent1; mso-border-top-alt: solid #4F81BD .5pt; mso-border-top-themecolor: accent1; padding: 0cm 5.4pt 0cm 5.4pt; width: 239.4pt;" valign="top" width="399"><div class="MsoNormal">
<b>Doet<o:p></o:p></b></div>
</td></tr>
<tr><td style="background: #DBE5F1; border-top: none; border: solid #95B3D7 1.0pt; mso-background-themecolor: accent1; mso-background-themetint: 51; mso-border-alt: solid #95B3D7 .5pt; mso-border-themecolor: accent1; mso-border-themecolor: accent1; mso-border-themetint: 153; mso-border-themetint: 153; mso-border-top-alt: solid #95B3D7 .5pt; mso-border-top-themecolor: accent1; mso-border-top-themetint: 153; padding: 0cm 5.4pt 0cm 5.4pt; width: 239.4pt;" valign="top" width="399"><div class="MsoNormal">
<b>SELECT * from import<o:p></o:p></b></div>
</td><td style="background: #DBE5F1; border-bottom: solid #95B3D7 1.0pt; border-left: none; border-right: solid #95B3D7 1.0pt; border-top: none; mso-background-themecolor: accent1; mso-background-themetint: 51; mso-border-alt: solid #95B3D7 .5pt; mso-border-bottom-themecolor: accent1; mso-border-bottom-themetint: 153; mso-border-left-alt: solid #95B3D7 .5pt; mso-border-left-themecolor: accent1; mso-border-left-themetint: 153; mso-border-right-themecolor: accent1; mso-border-right-themetint: 153; mso-border-themecolor: accent1; mso-border-themetint: 153; mso-border-top-alt: solid #95B3D7 .5pt; mso-border-top-themecolor: accent1; mso-border-top-themetint: 153; padding: 0cm 5.4pt 0cm 5.4pt; width: 239.4pt;" valign="top" width="399"><div class="MsoNormal">
<span style="font-family: "Calibri",sans-serif; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-theme-font: minor-bidi; mso-fareast-font-family: Calibri; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;">Select all from database table called "import" <o:p></o:p></span></div>
</td></tr>
<tr><td style="border-top: none; border: solid #95B3D7 1.0pt; mso-border-alt: solid #95B3D7 .5pt; mso-border-themecolor: accent1; mso-border-themecolor: accent1; mso-border-themetint: 153; mso-border-themetint: 153; mso-border-top-alt: solid #95B3D7 .5pt; mso-border-top-themecolor: accent1; mso-border-top-themetint: 153; padding: 0cm 5.4pt 0cm 5.4pt; width: 239.4pt;" valign="top" width="399"><div class="MsoNormal">
<b>where<o:p></o:p></b></div>
</td><td style="border-bottom: solid #95B3D7 1.0pt; border-left: none; border-right: solid #95B3D7 1.0pt; border-top: none; mso-border-alt: solid #95B3D7 .5pt; mso-border-bottom-themecolor: accent1; mso-border-bottom-themetint: 153; mso-border-left-alt: solid #95B3D7 .5pt; mso-border-left-themecolor: accent1; mso-border-left-themetint: 153; mso-border-right-themecolor: accent1; mso-border-right-themetint: 153; mso-border-themecolor: accent1; mso-border-themetint: 153; mso-border-top-alt: solid #95B3D7 .5pt; mso-border-top-themecolor: accent1; mso-border-top-themetint: 153; padding: 0cm 5.4pt 0cm 5.4pt; width: 239.4pt;" valign="top" width="399"><div class="MsoNormal">
<br /></div>
</td></tr>
<tr><td style="background: #DBE5F1; border-top: none; border: solid #95B3D7 1.0pt; mso-background-themecolor: accent1; mso-background-themetint: 51; mso-border-alt: solid #95B3D7 .5pt; mso-border-themecolor: accent1; mso-border-themecolor: accent1; mso-border-themetint: 153; mso-border-themetint: 153; mso-border-top-alt: solid #95B3D7 .5pt; mso-border-top-themecolor: accent1; mso-border-top-themetint: 153; padding: 0cm 5.4pt 0cm 5.4pt; width: 239.4pt;" valign="top" width="399"><div class="MsoNormal">
<b>“field1”<o:p></o:p></b></div>
</td><td style="background: #DBE5F1; border-bottom: solid #95B3D7 1.0pt; border-left: none; border-right: solid #95B3D7 1.0pt; border-top: none; mso-background-themecolor: accent1; mso-background-themetint: 51; mso-border-alt: solid #95B3D7 .5pt; mso-border-bottom-themecolor: accent1; mso-border-bottom-themetint: 153; mso-border-left-alt: solid #95B3D7 .5pt; mso-border-left-themecolor: accent1; mso-border-left-themetint: 153; mso-border-right-themecolor: accent1; mso-border-right-themetint: 153; mso-border-themecolor: accent1; mso-border-themetint: 153; mso-border-top-alt: solid #95B3D7 .5pt; mso-border-top-themecolor: accent1; mso-border-top-themetint: 153; padding: 0cm 5.4pt 0cm 5.4pt; width: 239.4pt;" valign="top" width="399"><div class="MsoNormal">
<span style="font-family: "Calibri",sans-serif; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-theme-font: minor-bidi; mso-fareast-font-family: Calibri; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;">The field in the database that hold the unique identifier. You can change this to the name you have chosen.<o:p></o:p></span></div>
</td></tr>
<tr><td style="border-top: none; border: solid #95B3D7 1.0pt; mso-border-alt: solid #95B3D7 .5pt; mso-border-themecolor: accent1; mso-border-themecolor: accent1; mso-border-themetint: 153; mso-border-themetint: 153; mso-border-top-alt: solid #95B3D7 .5pt; mso-border-top-themecolor: accent1; mso-border-top-themetint: 153; padding: 0cm 5.4pt 0cm 5.4pt; width: 239.4pt;" valign="top" width="399"><div class="MsoNormal">
<b>=<o:p></o:p></b></div>
</td><td style="border-bottom: solid #95B3D7 1.0pt; border-left: none; border-right: solid #95B3D7 1.0pt; border-top: none; mso-border-alt: solid #95B3D7 .5pt; mso-border-bottom-themecolor: accent1; mso-border-bottom-themetint: 153; mso-border-left-alt: solid #95B3D7 .5pt; mso-border-left-themecolor: accent1; mso-border-left-themetint: 153; mso-border-right-themecolor: accent1; mso-border-right-themetint: 153; mso-border-themecolor: accent1; mso-border-themetint: 153; mso-border-top-alt: solid #95B3D7 .5pt; mso-border-top-themecolor: accent1; mso-border-top-themetint: 153; padding: 0cm 5.4pt 0cm 5.4pt; width: 239.4pt;" valign="top" width="399"><div class="MsoNormal">
<br /></div>
</td></tr>
<tr><td style="background: #DBE5F1; border-top: none; border: solid #95B3D7 1.0pt; mso-background-themecolor: accent1; mso-background-themetint: 51; mso-border-alt: solid #95B3D7 .5pt; mso-border-themecolor: accent1; mso-border-themecolor: accent1; mso-border-themetint: 153; mso-border-themetint: 153; mso-border-top-alt: solid #95B3D7 .5pt; mso-border-top-themecolor: accent1; mso-border-top-themetint: 153; padding: 0cm 5.4pt 0cm 5.4pt; width: 239.4pt;" valign="top" width="399"><div class="MsoNormal">
<b>%prop(“Element ID”,Value);<o:p></o:p></b></div>
</td><td style="background: #DBE5F1; border-bottom: solid #95B3D7 1.0pt; border-left: none; border-right: solid #95B3D7 1.0pt; border-top: none; mso-background-themecolor: accent1; mso-background-themetint: 51; mso-border-alt: solid #95B3D7 .5pt; mso-border-bottom-themecolor: accent1; mso-border-bottom-themetint: 153; mso-border-left-alt: solid #95B3D7 .5pt; mso-border-left-themecolor: accent1; mso-border-left-themetint: 153; mso-border-right-themecolor: accent1; mso-border-right-themetint: 153; mso-border-themecolor: accent1; mso-border-themetint: 153; mso-border-top-alt: solid #95B3D7 .5pt; mso-border-top-themecolor: accent1; mso-border-top-themetint: 153; padding: 0cm 5.4pt 0cm 5.4pt; width: 239.4pt;" valign="top" width="399"><div class="MsoNormal">
<span style="font-family: "Calibri",sans-serif; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-theme-font: minor-bidi; mso-fareast-font-family: Calibri; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;">properties of the data in Navisworks for "Element ID" with "Value". This Value should be the same as the Value in field1.<o:p></o:p></span></div>
</td></tr>
</tbody></table>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both;">
Once the data is linked to your file you have to opportunity to store it within the file. This does not have my preference as I would like my data to be flexible. If you do want to try it out for yourself make sure your match the publish settings as per image below.</div>
<div class="separator" style="clear: both;">
<br /></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEho-yYb3cclxsRe7tDTPAjYtSxrmfJb_Pbe_tpRoyYPaYCUh0JScS1YoWkkUmXTEUEMFJ0rEXK1Jfh0YH7vdeAq3AKgvir_ehM6V2yjT5q_vgImuWTZvDOIEDUlbaZzetfS1Zg6E89XPrs/s1600/datatools-4.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEho-yYb3cclxsRe7tDTPAjYtSxrmfJb_Pbe_tpRoyYPaYCUh0JScS1YoWkkUmXTEUEMFJ0rEXK1Jfh0YH7vdeAq3AKgvir_ehM6V2yjT5q_vgImuWTZvDOIEDUlbaZzetfS1Zg6E89XPrs/s1600/datatools-4.png" height="320" width="173" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both;">
I sincerely hope that you will be able to get / add more out / in you BIM.</div>
<div>
<br /></div>
Buildinginformationworkerhttp://www.blogger.com/profile/13803197110189149046noreply@blogger.com1tag:blogger.com,1999:blog-7017883048650895187.post-53620399111274070192014-12-29T21:59:00.001-08:002014-12-30T00:48:15.835-08:00Navisworks Datatools - NLIets wat ik fundamenteel vind in BIM is de mogelijkheid data te doorzien, te bewerken en te verrijken.<br />
<br />
Veelal gebeurd dit tijden het ontwerp, door parameters / waarden mee te geven, in een van de vele ontwerppaketten. Maar hoe moet dat nu als het het ontwerp al klaar is en de modellen "stilstaan"? Kan er nog wel data aan worden toegevoegd? Kun je onderhoudsinformatie vanuit een aparte database koppelen en linken aan je model? Kun je een additionele classificatie toevoegen?<br />
<br />
Met behulp van de datatools in Navisworks lijkt dit prima te kunnen. Ik zal hier onder een korte instructie geven van de belangrijkste stappen voor meer detail verwijs ik graag naar mijn klas voor AU2014 <i>AB6967 Navisworks And Classification Based Model Checking</i> die ik samen met <a href="http://t.co/O39dVsY2nA" target="_blank">Rob Oud</a> heb mogen geven. In deze klas gaan we wel iets verder maar de essesntie is hetzelfde vervang A voor B.<br />
<br />
<u>Stap 1</u><br />
Selecteer de data waar je naar toe wilt linken en vraag de selection inspector op.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg1RgGt2RYhTR5aF-oZJhi02GlbOfirS6cS_DqRqNi4GRce8fmW6ZElvFKpIUs_qp6LEF_EYQ1aWognC8GpPen8xNyupdwf26Nmg_oKo8y8A2YkV-TPti98IFgrdaeYdTS07DpP7G2HyEE/s1600/datatools-1.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg1RgGt2RYhTR5aF-oZJhi02GlbOfirS6cS_DqRqNi4GRce8fmW6ZElvFKpIUs_qp6LEF_EYQ1aWognC8GpPen8xNyupdwf26Nmg_oKo8y8A2YkV-TPti98IFgrdaeYdTS07DpP7G2HyEE/s1600/datatools-1.png" height="291" width="320" /></a></div>
<br />
Bekijk je data en voeg waar nodig extra velden toe om je data beter "leesbaar" te maken voor wanneer je er data aan gaat koppelen. <b>Vergewis jezelf ervan dat er een unieke nummer of ander attribuut aanwezig is</b>. Als je klaar bent klik op exporteren naar *.CSV<br />
<br />
<u>Stap 2</u><br />
Open de *.CSV in Excel en voeg kolommen toe met data. Je kunt daar zoek functies voor gebruiken om het jezelf makkelijker te maken. Het maakt eigenlijk niet uit wat je do<br />
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
et als je de extra kolommen maar op de juiste plaatsen gevuld raken. Als je klaar bent save je de file als een *.xlsx<br />
<br />
<u>Stap 3</u><br />
Nu dat de data is verrijkt in Excel is het zaak je data naar Access te krijgen. Je kunt dit op 2 manieren doen.<br />
<br />
<ol>
<li>Je importeert het gehele tabblad.</li>
<li>Je kopieert de kolommen direct uit Excel.<br /><i>Ik heb geen voorkeur, maar als je nieuw bent in Access zou ik beginnen met deze optie</i>. </li>
</ol>
<div>
Als je je werk goed hebt gedaan zou je tabel er zo kunnen uitzien. In de onderstaande tabel heb ik Uniclass en Omniclass toegevoegd aan mijn dataset.</div>
<div>
<br /></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjGFtQ2NYZVJKGQkNg2z3dhWs1z5dr5YQ_qL8s-2pCEnaJpzXhxlB6e4MSeOFnuEtZh53LW5QpdS-frOg9rLIvL5Q2wkh8mks8pLyNrhHIBXhPN5bvMCoDDYftxUVqyfoZRxg2SBK7KUbU/s1600/datatools-2.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjGFtQ2NYZVJKGQkNg2z3dhWs1z5dr5YQ_qL8s-2pCEnaJpzXhxlB6e4MSeOFnuEtZh53LW5QpdS-frOg9rLIvL5Q2wkh8mks8pLyNrhHIBXhPN5bvMCoDDYftxUVqyfoZRxg2SBK7KUbU/s1600/datatools-2.png" height="87" width="400" /></a></div>
<br />
<u>Stap 4</u><br />
De laatste en meest belangrijke stap zal ik wat nauwgezetter beschrijven omdat dit heel nauwkeurig luistert. 1 fout en je data wordt niet gekoppeld.<br />
<br />
In Navisworks klik op datatools om de wizard te openen. Kies voor "New.." om een nieuwe connectie aan te maken.<br />
<br />
<ol>
<li>Geef je connectie in naam</li>
<li>Kies voor Access in ODBC.<br /><i>Andere connecties zijn ook mogelijk, maar ik vond ze minder robuust.</i></li>
<li>Definieer de zoek variabele voor de koppeling.</li>
<li>Geef de velden op waarvan je de data wilt zien</li>
</ol>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEibxiJtL7LA34sTAj2fYZmO6MK1x2bLIdVxEZctbhdDMH3wJYnmVb2MFreN3O4i32P1R8BuSFzd47z13cDlu-eQRFPRY3GrcEH57UjyEubd5oxTUyP6ofzPJ4p0KuUTwg1LL-tWBRSUzKk/s1600/datatools-3.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEibxiJtL7LA34sTAj2fYZmO6MK1x2bLIdVxEZctbhdDMH3wJYnmVb2MFreN3O4i32P1R8BuSFzd47z13cDlu-eQRFPRY3GrcEH57UjyEubd5oxTUyP6ofzPJ4p0KuUTwg1LL-tWBRSUzKk/s1600/datatools-3.png" height="220" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
Stap 1 en 2 zijn nog wel te volgen, maar het venijn zit hem in 3 en een beetje in 4. De zoek variabele luister zeer nauw. Een spatie teveel of te weining en je koppeling werkt niet. Gebuik altijd Notepad om je zoek variabele te definieren.</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgBV8mnaF_fSVX7uuC9S15XlOraLTb8JuJ8fz1ZIWRnQ8Hd06ENFJq9aXQih7FjJIV3it3mMhkP0TKY546nnr1qKU01nJv25f4Y6eXFTsfRh5vB9BGqjzMEjWTuZRDKw1Ob2ulU0IgMkEM/s1600/datatools-5.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgBV8mnaF_fSVX7uuC9S15XlOraLTb8JuJ8fz1ZIWRnQ8Hd06ENFJq9aXQih7FjJIV3it3mMhkP0TKY546nnr1qKU01nJv25f4Y6eXFTsfRh5vB9BGqjzMEjWTuZRDKw1Ob2ulU0IgMkEM/s1600/datatools-5.png" height="64" width="640" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
Ik zal nu uitleggen hoe deze string is opgebouwd.</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<table border="1" cellpadding="0" cellspacing="0" class="MsoTable15Grid4Accent1" style="border-collapse: collapse; border: none; mso-border-alt: solid #95B3D7 .5pt; mso-border-themecolor: accent1; mso-border-themetint: 153; mso-padding-alt: 0cm 5.4pt 0cm 5.4pt; mso-yfti-tbllook: 1184;">
<tbody>
<tr>
<td style="background: #4F81BD; border-right: none; border: solid #4F81BD 1.0pt; mso-background-themecolor: accent1; mso-border-bottom-alt: solid #4F81BD .5pt; mso-border-bottom-themecolor: accent1; mso-border-left-alt: solid #4F81BD .5pt; mso-border-left-themecolor: accent1; mso-border-themecolor: accent1; mso-border-top-alt: solid #4F81BD .5pt; mso-border-top-themecolor: accent1; padding: 0cm 5.4pt 0cm 5.4pt; width: 239.4pt;" valign="top" width="399"><div class="MsoNormal">
<b><span style="color: white; font-family: "Calibri",sans-serif; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-theme-font: minor-bidi; mso-fareast-font-family: Calibri; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin; mso-themecolor: background1;">Code<o:p></o:p></span></b></div>
</td>
<td style="background: #4F81BD; border-left: none; border: solid #4F81BD 1.0pt; mso-background-themecolor: accent1; mso-border-bottom-alt: solid #4F81BD .5pt; mso-border-bottom-themecolor: accent1; mso-border-right-alt: solid #4F81BD .5pt; mso-border-right-themecolor: accent1; mso-border-themecolor: accent1; mso-border-top-alt: solid #4F81BD .5pt; mso-border-top-themecolor: accent1; padding: 0cm 5.4pt 0cm 5.4pt; width: 239.4pt;" valign="top" width="399"><div class="MsoNormal">
<b><span style="color: white; font-family: "Calibri",sans-serif; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-theme-font: minor-bidi; mso-fareast-font-family: Calibri; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin; mso-themecolor: background1;">Doet<o:p></o:p></span></b></div>
</td>
</tr>
<tr>
<td style="background: #DBE5F1; border-top: none; border: solid #95B3D7 1.0pt; mso-background-themecolor: accent1; mso-background-themetint: 51; mso-border-alt: solid #95B3D7 .5pt; mso-border-themecolor: accent1; mso-border-themecolor: accent1; mso-border-themetint: 153; mso-border-themetint: 153; mso-border-top-alt: solid #95B3D7 .5pt; mso-border-top-themecolor: accent1; mso-border-top-themetint: 153; padding: 0cm 5.4pt 0cm 5.4pt; width: 239.4pt;" valign="top" width="399"><div class="MsoNormal">
<b><span style="font-family: "Calibri",sans-serif; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-theme-font: minor-bidi; mso-fareast-font-family: Calibri; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;">SELECT * from import<o:p></o:p></span></b></div>
</td>
<td style="background: #DBE5F1; border-bottom: solid #95B3D7 1.0pt; border-left: none; border-right: solid #95B3D7 1.0pt; border-top: none; mso-background-themecolor: accent1; mso-background-themetint: 51; mso-border-alt: solid #95B3D7 .5pt; mso-border-bottom-themecolor: accent1; mso-border-bottom-themetint: 153; mso-border-left-alt: solid #95B3D7 .5pt; mso-border-left-themecolor: accent1; mso-border-left-themetint: 153; mso-border-right-themecolor: accent1; mso-border-right-themetint: 153; mso-border-themecolor: accent1; mso-border-themetint: 153; mso-border-top-alt: solid #95B3D7 .5pt; mso-border-top-themecolor: accent1; mso-border-top-themetint: 153; padding: 0cm 5.4pt 0cm 5.4pt; width: 239.4pt;" valign="top" width="399"><div class="MsoNormal">
<span style="font-family: "Calibri",sans-serif; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-theme-font: minor-bidi; mso-fareast-font-family: Calibri; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;">Selecteert alles vanuit de database tabel die "import" heet<o:p></o:p></span></div>
</td>
</tr>
<tr>
<td style="border-top: none; border: solid #95B3D7 1.0pt; mso-border-alt: solid #95B3D7 .5pt; mso-border-themecolor: accent1; mso-border-themecolor: accent1; mso-border-themetint: 153; mso-border-themetint: 153; mso-border-top-alt: solid #95B3D7 .5pt; mso-border-top-themecolor: accent1; mso-border-top-themetint: 153; padding: 0cm 5.4pt 0cm 5.4pt; width: 239.4pt;" valign="top" width="399"><div class="MsoNormal">
<b><span style="font-family: "Calibri",sans-serif; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-theme-font: minor-bidi; mso-fareast-font-family: Calibri; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;">where<o:p></o:p></span></b></div>
</td>
<td style="border-bottom: solid #95B3D7 1.0pt; border-left: none; border-right: solid #95B3D7 1.0pt; border-top: none; mso-border-alt: solid #95B3D7 .5pt; mso-border-bottom-themecolor: accent1; mso-border-bottom-themetint: 153; mso-border-left-alt: solid #95B3D7 .5pt; mso-border-left-themecolor: accent1; mso-border-left-themetint: 153; mso-border-right-themecolor: accent1; mso-border-right-themetint: 153; mso-border-themecolor: accent1; mso-border-themetint: 153; mso-border-top-alt: solid #95B3D7 .5pt; mso-border-top-themecolor: accent1; mso-border-top-themetint: 153; padding: 0cm 5.4pt 0cm 5.4pt; width: 239.4pt;" valign="top" width="399"><div class="MsoNormal">
<span style="font-family: "Calibri",sans-serif; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-theme-font: minor-bidi; mso-fareast-font-family: Calibri; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;">waar</span></div>
</td>
</tr>
<tr>
<td style="background: #DBE5F1; border-top: none; border: solid #95B3D7 1.0pt; mso-background-themecolor: accent1; mso-background-themetint: 51; mso-border-alt: solid #95B3D7 .5pt; mso-border-themecolor: accent1; mso-border-themecolor: accent1; mso-border-themetint: 153; mso-border-themetint: 153; mso-border-top-alt: solid #95B3D7 .5pt; mso-border-top-themecolor: accent1; mso-border-top-themetint: 153; padding: 0cm 5.4pt 0cm 5.4pt; width: 239.4pt;" valign="top" width="399"><div class="MsoNormal">
<b><span style="font-family: "Calibri",sans-serif; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-theme-font: minor-bidi; mso-fareast-font-family: Calibri; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;">“field1”<o:p></o:p></span></b></div>
</td>
<td style="background: #DBE5F1; border-bottom: solid #95B3D7 1.0pt; border-left: none; border-right: solid #95B3D7 1.0pt; border-top: none; mso-background-themecolor: accent1; mso-background-themetint: 51; mso-border-alt: solid #95B3D7 .5pt; mso-border-bottom-themecolor: accent1; mso-border-bottom-themetint: 153; mso-border-left-alt: solid #95B3D7 .5pt; mso-border-left-themecolor: accent1; mso-border-left-themetint: 153; mso-border-right-themecolor: accent1; mso-border-right-themetint: 153; mso-border-themecolor: accent1; mso-border-themetint: 153; mso-border-top-alt: solid #95B3D7 .5pt; mso-border-top-themecolor: accent1; mso-border-top-themetint: 153; padding: 0cm 5.4pt 0cm 5.4pt; width: 239.4pt;" valign="top" width="399"><div class="MsoNormal">
<span style="font-family: "Calibri",sans-serif; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-theme-font: minor-bidi; mso-fareast-font-family: Calibri; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;">De veld waarde in de database die moet worden vergeleken. Je kunt hier ook een andere naam gebruiken.<o:p></o:p></span></div>
</td>
</tr>
<tr>
<td style="border-top: none; border: solid #95B3D7 1.0pt; mso-border-alt: solid #95B3D7 .5pt; mso-border-themecolor: accent1; mso-border-themecolor: accent1; mso-border-themetint: 153; mso-border-themetint: 153; mso-border-top-alt: solid #95B3D7 .5pt; mso-border-top-themecolor: accent1; mso-border-top-themetint: 153; padding: 0cm 5.4pt 0cm 5.4pt; width: 239.4pt;" valign="top" width="399"><div class="MsoNormal">
<b><span style="font-family: "Calibri",sans-serif; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-theme-font: minor-bidi; mso-fareast-font-family: Calibri; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;">=<o:p></o:p></span></b></div>
</td>
<td style="border-bottom: solid #95B3D7 1.0pt; border-left: none; border-right: solid #95B3D7 1.0pt; border-top: none; mso-border-alt: solid #95B3D7 .5pt; mso-border-bottom-themecolor: accent1; mso-border-bottom-themetint: 153; mso-border-left-alt: solid #95B3D7 .5pt; mso-border-left-themecolor: accent1; mso-border-left-themetint: 153; mso-border-right-themecolor: accent1; mso-border-right-themetint: 153; mso-border-themecolor: accent1; mso-border-themetint: 153; mso-border-top-alt: solid #95B3D7 .5pt; mso-border-top-themecolor: accent1; mso-border-top-themetint: 153; padding: 0cm 5.4pt 0cm 5.4pt; width: 239.4pt;" valign="top" width="399"><div class="MsoNormal">
<span style="font-family: "Calibri",sans-serif; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-theme-font: minor-bidi; mso-fareast-font-family: Calibri; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;">gelijk is<o:p></o:p></span></div>
</td>
</tr>
<tr>
<td style="background: #DBE5F1; border-top: none; border: solid #95B3D7 1.0pt; mso-background-themecolor: accent1; mso-background-themetint: 51; mso-border-alt: solid #95B3D7 .5pt; mso-border-themecolor: accent1; mso-border-themecolor: accent1; mso-border-themetint: 153; mso-border-themetint: 153; mso-border-top-alt: solid #95B3D7 .5pt; mso-border-top-themecolor: accent1; mso-border-top-themetint: 153; padding: 0cm 5.4pt 0cm 5.4pt; width: 239.4pt;" valign="top" width="399"><div class="MsoNormal">
<b><span style="font-family: "Calibri",sans-serif; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-theme-font: minor-bidi; mso-fareast-font-family: Calibri; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;">%prop(“Element ID”,Value);<o:p></o:p></span></b></div>
</td>
<td style="background: #DBE5F1; border-bottom: solid #95B3D7 1.0pt; border-left: none; border-right: solid #95B3D7 1.0pt; border-top: none; mso-background-themecolor: accent1; mso-background-themetint: 51; mso-border-alt: solid #95B3D7 .5pt; mso-border-bottom-themecolor: accent1; mso-border-bottom-themetint: 153; mso-border-left-alt: solid #95B3D7 .5pt; mso-border-left-themecolor: accent1; mso-border-left-themetint: 153; mso-border-right-themecolor: accent1; mso-border-right-themetint: 153; mso-border-themecolor: accent1; mso-border-themetint: 153; mso-border-top-alt: solid #95B3D7 .5pt; mso-border-top-themecolor: accent1; mso-border-top-themetint: 153; padding: 0cm 5.4pt 0cm 5.4pt; width: 239.4pt;" valign="top" width="399"><div class="MsoNormal">
<span style="font-family: "Calibri",sans-serif; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-theme-font: minor-bidi; mso-fareast-font-family: Calibri; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;">properties in Navisworks voor de kolom Element ID met de waarde Value.<o:p></o:p></span></div>
</td>
</tr>
</tbody></table>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
Wanneer je data is gekoppeld en je wilt afsluiten kun je ervoor kiezen om je data bij de file op te slaan. Mijn voorkeur heeft het niet omdat ik het graag als 2 communicerende vaten wil houden. Mocht je het toch willen proberen zorg dan dat je publish instellingen staan zoals hier onder.</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEho-yYb3cclxsRe7tDTPAjYtSxrmfJb_Pbe_tpRoyYPaYCUh0JScS1YoWkkUmXTEUEMFJ0rEXK1Jfh0YH7vdeAq3AKgvir_ehM6V2yjT5q_vgImuWTZvDOIEDUlbaZzetfS1Zg6E89XPrs/s1600/datatools-4.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em; text-align: center;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEho-yYb3cclxsRe7tDTPAjYtSxrmfJb_Pbe_tpRoyYPaYCUh0JScS1YoWkkUmXTEUEMFJ0rEXK1Jfh0YH7vdeAq3AKgvir_ehM6V2yjT5q_vgImuWTZvDOIEDUlbaZzetfS1Zg6E89XPrs/s1600/datatools-4.png" height="320" width="173" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
Ik hoop dat je hiermee met deze informatie wat meer muziek kunt halen uit de data die je hebt.</div>
<br />Buildinginformationworkerhttp://www.blogger.com/profile/13803197110189149046noreply@blogger.com0tag:blogger.com,1999:blog-7017883048650895187.post-63323579866813567832014-12-29T11:53:00.001-08:002014-12-30T00:50:59.887-08:00Visio and Excel - EN - Part 1<span style="font-size: large;">"Measure twice, cut once" </span><br />
- Carpenters rule<br />
<br />
One of the tings that keeps amazing me is that people will gladly enter and maintain information in more than one place. Whenever that happens there is room for investigation and improvement.<br />
<br />
When we were making documents for a customer we kept ending up with delta's between our documents in Visio and Excel. Meaning we needed to enter text twice, and spellcheck it twice, update it twice if something changed.<br />
<br />
This should be easier in after all we live in a digital era, right?<br />
<br />
First you will need Visio Professional 2010 or 2013. It is our experience that the non professional versions don't allow you to make <u>data connections.</u><br />
<u><br /></u>
When you want to start using Visio and Excel in tandem always start with Excel as your single source of truth. Develop it, spelcheck it and when you think it is ready you can start to setup your data connection.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgIGTJoLedtBnQjWP1hHZP7SAlFTquEupMlHTnHA2p82cL5fXCEq8IqO563MX6r1q0KluRhCY2QHLRZ16LOgZDYhX_O_I3NulIiNjC0MhZfKzrfsB0Y0JbKhUH9pjJnlq9THt6LNU8R0DE/s1600/visio-excel-1.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgIGTJoLedtBnQjWP1hHZP7SAlFTquEupMlHTnHA2p82cL5fXCEq8IqO563MX6r1q0KluRhCY2QHLRZ16LOgZDYhX_O_I3NulIiNjC0MhZfKzrfsB0Y0JbKhUH9pjJnlq9THt6LNU8R0DE/s1600/visio-excel-1.png" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
Click in the "Link Data to Shapes" button. Visio will take you to a wizard of which data you want to attach. Once you are done Visio will show you a new field filled with data that can be linked. </div>
<div class="separator" style="clear: both; text-align: left;">
<i><br /></i></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjRsLaQLvACojS9ytYEAVs2BnQURwcjxpPa9IUaOq3LthLCZ7d_0lUvROYK-ontpc5-3xE4s-Yj6nqnkTnqYTJJallBPGJxKViNPOrlB96Phbvkd4kWPy2wsHr5qprODAClGFWEInnRUwI/s1600/visio-excel-2.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjRsLaQLvACojS9ytYEAVs2BnQURwcjxpPa9IUaOq3LthLCZ7d_0lUvROYK-ontpc5-3xE4s-Yj6nqnkTnqYTJJallBPGJxKViNPOrlB96Phbvkd4kWPy2wsHr5qprODAClGFWEInnRUwI/s1600/visio-excel-2.png" height="320" width="142" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
<i style="text-align: center;">The little link icon in front of my data indicates that the data has been linked to shapes in my diagram.</i></div>
<div class="separator" style="clear: both; text-align: left;">
<i style="text-align: center;"><br /></i></div>
<div class="separator" style="clear: both; text-align: left;">
If you start to link data to you shapes you will see that Visio uses a template to make the information visual. We were not happy with the way the data was represented and needed to find a way to change it. For us the only way to tweak the data was to add a custom field.</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjXxNyUziC0cRr9AsM-8lma1ywJMpu95vU1mlTx7vt-avvpQK4LTjlpZCRp2T_zzpW6e37MwH0WKsGWNjw3fTxbnsOJLw8DVhOPFwOpqT9iNTeaKUZv65IpkU-2yu7RNF7C1cVVAStYWu8/s1600/visio-excel-4.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjXxNyUziC0cRr9AsM-8lma1ywJMpu95vU1mlTx7vt-avvpQK4LTjlpZCRp2T_zzpW6e37MwH0WKsGWNjw3fTxbnsOJLw8DVhOPFwOpqT9iNTeaKUZv65IpkU-2yu7RNF7C1cVVAStYWu8/s1600/visio-excel-4.png" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
Click the "Field" button to open up a wizard. In this wizard select "Custom Formula". In the text bar start typing "=Prop._VisDM_" Visio will narrow the number of items to the items you have imported.</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEijatfOkTG5ylrVZmW8TAVjPULLBy9mGuBj1CLe39Aft5rN-lTshUAweCXbbtHdRTwCN8zk4Fv2aHo-7zHXIEAym9w5dTIKbs90N2-8BQlyAlDyPoyGRO06-C74uOlul5mJsJK17czBQSo/s1600/visio-excel-3.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEijatfOkTG5ylrVZmW8TAVjPULLBy9mGuBj1CLe39Aft5rN-lTshUAweCXbbtHdRTwCN8zk4Fv2aHo-7zHXIEAym9w5dTIKbs90N2-8BQlyAlDyPoyGRO06-C74uOlul5mJsJK17czBQSo/s1600/visio-excel-3.png" height="230" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
<i>The formula responds like a regular concatenate formula in Excel. Allowing you to create your own string of information. </i></div>
<div class="separator" style="clear: both; text-align: left;">
<i><br /></i></div>
<div class="separator" style="clear: both; text-align: left;">
<i>=Prop._VisDM_<u>EXPRESSION1</u>&" "&Prop._VisDM_</i><i><u>EXPRESSION2</u></i></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: right;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
Buildinginformationworkerhttp://www.blogger.com/profile/13803197110189149046noreply@blogger.com0tag:blogger.com,1999:blog-7017883048650895187.post-35078953455197808062014-12-29T11:04:00.003-08:002016-02-10T05:15:52.097-08:00Welkom - Welcome<span id="docs-internal-guid-5d71eae4-9766-6a3f-15f5-58610369e0d2"></span><br />
<div dir="ltr" style="line-height: 1.15; margin-bottom: 0pt; margin-top: 0pt;">
<span id="docs-internal-guid-5d71eae4-9766-6a3f-15f5-58610369e0d2"><span style="font-family: "arial"; font-size: 15px; vertical-align: baseline; white-space: pre-wrap;">Over de afgelopen 17 jaar heb ik redelijk wat kennis en ervaring opgedaan over de bouwwereld en organisaties. H</span><span style="font-family: "arial"; font-size: 15px; white-space: pre-wrap;">et is mijn doel om doormiddel van blogs mijn ervaring met u te delen. </span></span></div>
<span id="docs-internal-guid-5d71eae4-9766-6a3f-15f5-58610369e0d2">
<div dir="ltr" style="line-height: 1.15; margin-bottom: 0pt; margin-top: 0pt;">
<span style="font-family: "arial"; font-size: 15px; white-space: pre-wrap;"><br /></span></div>
<div dir="ltr" style="line-height: 1.15; margin-bottom: 0pt; margin-top: 0pt;">
<span style="font-family: "arial"; font-size: 15px; white-space: pre-wrap;">Over the past 17 years I have acquired knowledge and experience in the AEC industry as well as organizations in general. It is my goal to share some of that knowledge through blogs.</span></div>
<div dir="ltr" style="line-height: 1.15; margin-bottom: 0pt; margin-top: 0pt;">
<span style="font-family: "arial"; font-size: 15px; white-space: pre-wrap;"><br /></span></div>
<div dir="ltr" style="margin-bottom: 0pt; margin-top: 0pt;">
<span style="font-family: "arial";"><span style="font-size: 15px; line-height: 17.25px; white-space: pre-wrap;">De titel van mijn blog is een een combinatie van <a href="https://en.wikipedia.org/wiki/Building_information_modeling">buildinginformation</a> en <a href="https://en.wikipedia.org/wiki/Knowledge_worker">informationworker</a>.</span></span></div>
<div dir="ltr" style="margin-bottom: 0pt; margin-top: 0pt;">
<span style="font-family: "arial";"><span style="font-size: 15px; line-height: 17.25px; white-space: pre-wrap;"><br /></span></span></div>
<div dir="ltr" style="margin-bottom: 0pt; margin-top: 0pt;">
<span style="font-family: "arial";"><span style="font-size: 15px; line-height: 17.25px; white-space: pre-wrap;">The title for my blog is taken from </span></span><a href="https://en.wikipedia.org/wiki/Building_information_modeling" style="font-family: Arial; font-size: 15px; line-height: 17.25px; white-space: pre-wrap;">buildinginformation</a><span style="font-family: "arial"; font-size: 15px; line-height: 17.25px; white-space: pre-wrap;"> and </span><a href="https://en.wikipedia.org/wiki/Knowledge_worker" style="font-family: Arial; font-size: 15px; line-height: 17.25px; white-space: pre-wrap;">informationworker</a><span style="font-family: "arial"; font-size: 15px; line-height: 17.25px; white-space: pre-wrap;">.</span></div>
<div dir="ltr" style="margin-bottom: 0pt; margin-top: 0pt;">
<span style="font-family: "arial";"><span style="font-size: 15px; line-height: 17.25px; white-space: pre-wrap;"><br /></span></span></div>
<div dir="ltr" style="margin-bottom: 0pt; margin-top: 0pt;">
<span style="font-family: "arial";"><span style="font-size: 15px; line-height: 17.25px; white-space: pre-wrap;"><br /></span></span></div>
</span><br />
<br />Buildinginformationworkerhttp://www.blogger.com/profile/13803197110189149046noreply@blogger.com0