{"id":2122,"date":"2018-02-09T16:27:16","date_gmt":"2018-02-09T16:27:16","guid":{"rendered":"https:\/\/max-drake.cc\/?p=2122"},"modified":"2018-02-17T14:44:56","modified_gmt":"2018-02-17T14:44:56","slug":"how-to-use-3d-pdfs-excel-macros-to-manage-your-assets-part-1-of-3","status":"publish","type":"post","link":"https:\/\/max-drake.cc\/?p=2122","title":{"rendered":"How to use 3D PDF&#8217;s  &#038; Excel Macro&#8217;s to manage your assets part 1 of 3"},"content":{"rendered":"<p>This is the first part of 3 videos.<\/p>\n<p>Video (5.40 min)<\/p>\n<p><iframe title=\"3D PDF for managing Assets, accessible by all\" width=\"678\" height=\"509\" data-src=\"https:\/\/www.youtube.com\/embed\/zWSB5MHXQYY?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" class=\"lazyload\" data-load-mode=\"1\"><\/iframe><\/p>\n<p>This video shows how to explore 3d pdfs that have been created from Revit BIM.<\/p>\n<p>Data created in Revit can be copied into the 3D PDF.&nbsp;<\/p>\n<p>We can use the 3D PDF to export this information further to an Excel Macro Sheet where we can manage the information in a simple table format.<\/p>\n<p>The power of this process is:<\/p>\n<ol>\n<li>3D PDF&#8217;s are viewable in free Adobe PDF Reader. We main ly use for 2D viewing, but the programme also views 3D PDF&#8217;s.<\/li>\n<li>The viewing software is free and is on most computers.<\/li>\n<li>Anyone can view the 3d model as its structured in plans\/elevations\/sections so easy to view<\/li>\n<li>We can export any data to a CSV file that can be read in Excel (a common programme)<\/li>\n<li>Inside Excel we can manipulate that data via a macro sheet to ordered table information (see part 2 )<\/li>\n<\/ol>\n<p>The 2nd post in the series is here:<br \/>\n<a href=\"https:\/\/max-drake.cc\/2018\/02\/09\/how-to-use-3d-pdfs-excel-macros-to-manage-your-assets-part-2-of-3\/\" target=\"_blank\" rel=\"noopener\">How to use 3D PDF&#8217;s &amp; Excel Macro&#8217;s to manage your assets part 2 of 3<\/a><br \/>\nThe 3rd post in the series is here:<br \/>\n<a href=\"https:\/\/max-drake.cc\/2018\/02\/09\/how-to-use-3d-pdfs-excel-macros-to-manage-your-assets-part-3-of-3-export-from-bim\/\" target=\"_blank\" rel=\"noopener\">How to use 3D PDF&#8217;s &amp; Excel Macro&#8217;s to manage your assets part 3 of 3- Export from BIM<\/a><\/p>\n<p>You can see more information on this site:<\/p>\n<blockquote class=\"wp-embedded-content\" data-secret=\"v16zD0Pew1\"><p><a href=\"https:\/\/pir2.tk\/index.php\/pdfs\/\">2\/3D PDF&#8217;s<\/a><\/p><\/blockquote>\n<p><iframe class=\"wp-embedded-content lazyload\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"&#8220;2\/3D PDF&#8217;s&#8221; &#8212; VAST\" data-src=\"https:\/\/pir2.tk\/index.php\/pdfs\/embed\/#?secret=DtjMyHRBZl#?secret=v16zD0Pew1\" data-secret=\"v16zD0Pew1\" width=\"600\" height=\"338\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" data-load-mode=\"1\"><\/iframe><\/p>\n<p>I hope this has been of interest. If you enjoyed this post please share it or click LIKE.<\/p>\n<p>Thank you<\/p>\n<p>Max Drake<\/p>\n","protected":false},"excerpt":{"rendered":"<p>This is the first part of 3 videos. Video (5.40 min) This video shows how to explore 3d pdfs that have been created from Revit BIM. Data created in Revit can be copied into the 3D PDF.&nbsp; We can use the 3D PDF to export this information further to an Excel Macro Sheet where we [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":55,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2,3,4,12],"tags":[],"class_list":["post-2122","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-3d-pdf-data-access","category-data-extraction","category-drawings","category-visualisation"],"featured_image_src":"https:\/\/max-drake.cc\/wp-content\/uploads\/2017\/05\/im7.jpg","featured_image_src_square":"https:\/\/max-drake.cc\/wp-content\/uploads\/2017\/05\/im7.jpg","author_info":{"display_name":"Max Drake","author_link":"https:\/\/max-drake.cc\/?author=1"},"_links":{"self":[{"href":"https:\/\/max-drake.cc\/index.php?rest_route=\/wp\/v2\/posts\/2122","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/max-drake.cc\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/max-drake.cc\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/max-drake.cc\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/max-drake.cc\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2122"}],"version-history":[{"count":0,"href":"https:\/\/max-drake.cc\/index.php?rest_route=\/wp\/v2\/posts\/2122\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/max-drake.cc\/index.php?rest_route=\/wp\/v2\/media\/55"}],"wp:attachment":[{"href":"https:\/\/max-drake.cc\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2122"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/max-drake.cc\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2122"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/max-drake.cc\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2122"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}