{"id":5934,"date":"2019-12-19T19:18:32","date_gmt":"2019-12-19T19:18:32","guid":{"rendered":"https:\/\/max-drake.cc\/?p=5934"},"modified":"2019-12-19T20:16:25","modified_gmt":"2019-12-19T20:16:25","slug":"yed-organisational-chart-from-excel","status":"publish","type":"post","link":"https:\/\/max-drake.cc\/?p=5934","title":{"rendered":"yEd organisational chart from Excel"},"content":{"rendered":"\n<p>I&#8217;ve been doing some work for my daughter on her growing business. One of the things I was trying to work out was a flow process for the organisation, from seed o delivery and items needed along the way. I started to use Bubbl.us to look at some of the flows and organizational structures and do linkings. OK to a point but lots of writing within bubbles and then organizing the bubbles. <\/p>\n\n\n\n<p>I had an RSS feed on Visio and alternatives, all paid programmes so looked on AlternativeTo website and typed in Visio and then looked at the offerings. I was quite surprised to find a whole plethora of alternatives, and a lot of them free. For some reason LucidCharts pops up as a freemium. The free version is so cut down as to be a complete waste of time. <\/p>\n\n\n\n<p>Two popped out at me,  Think Composer &amp; yEd. What really appealed to me with yEd is that you can upload an organisational chart from an Excel file and it will populate the information in the programme. You have to set a few relationships up first, but I really loved the idea of it. So I want to try it out. <\/p>\n\n\n\n<figure class=\"wp-block-embed-youtube wp-block-embed is-type-video is-provider-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe title=\"Org charts with yED and spreadsheet data\" width=\"678\" height=\"381\" data-src=\"https:\/\/www.youtube.com\/embed\/l-ktE8syWUI?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>\n<\/div><\/figure>\n\n\n\n<p>I would work in Drawings and spreadsheets first, and Bubbl.us , although nice, is not my normal method of organizing data, so I&#8217;m going to try the tutorial as shown in the video below. This can be a simple organization chart, and the nice thing is it can be updated over time from a spreadsheet. It might be a handy tool for my daughter. <\/p>\n\n\n\n<p>There is also this video that adds extra coloured items to the palate: <\/p>\n\n\n\n<figure class=\"wp-block-embed-youtube wp-block-embed is-type-video is-provider-youtube wp-embed-aspect-4-3 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe title=\"Using yEd graph editor to draw causal diagrams - initial configuration\" width=\"678\" height=\"509\" data-src=\"https:\/\/www.youtube.com\/embed\/Pb5coRQuAd8?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>\n<\/div><\/figure>\n\n\n\n<p>I had a bit of problem with the file and ended up exporting another and cutting\/pasting the body of the first file into it. The video is also good for quickly doing the settings. Thank you Andrew Critch. <\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Project &#8211; Excel to Org chart in yEd<\/h4>\n\n\n\n<p>I created a couple of videos to show how I extended the process from the initial tutorial YouTube video below:<\/p>\n\n\n\n<figure class=\"wp-block-embed-youtube wp-block-embed is-type-video is-provider-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe title=\"Creating Org chart from Excel using free yED Part 1 Setup\" width=\"678\" height=\"381\" data-src=\"https:\/\/www.youtube.com\/embed\/0RdTln8R04g?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>\n<\/div><\/figure>\n\n\n\n<figure class=\"wp-block-embed-youtube wp-block-embed is-type-video is-provider-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe title=\"Creating Org chart from Excel using free yED Part 2 Export\" width=\"678\" height=\"381\" data-src=\"https:\/\/www.youtube.com\/embed\/xv_xIUSHPyU?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>\n<\/div><\/figure>\n\n\n\n<p>I was quite excited about the hyperlink to the HTML code and put it in the iframe below, the links are only to YT vids, but its the process. Hover over a block in image below and click on tooltip to be taken to website. This doesn&#8217;t seem to work in the view of the page, but works when you are in edit mode. Something resizes the image so looses the hyperlink locations:<\/p>\n\n\n\n<html>\n<head><title>ABC123y<\/title>\n<style type=\"text\/css\">\n.tooltip {\n  font-size:10pt;\n  background-color:#FFFFCC;\n  border:1px solid black;\n  padding:2px\n}\n<\/style>\n<style type=\"text\/css\">\n.tooltip {\n  position:absolute;\n  display:none\n}\n<\/style>\n<\/head>\n<body>\n\n<script type=\"text\/javascript\">\ntooltip = null;\ndocument.onmousemove = updateTooltip;\nfunction updateTooltip(e) {\ntry {\nif (document.all) {\nif (document.documentElement && document.documentElement.scrollTop) { \/\/ Explorer 6 Strict\nx = document.documentElement.scrollLeft + window.event.x;\ny = document.documentElement.scrollTop + window.event.y;\n}\nelse { \/\/ all other Explorers\nx = document.body.scrollLeft + window.event.x;\ny = document.body.scrollTop + window.event.y;\n}\n}\nelse {\nx = e.pageX;\ny = e.pageY;\n}\nif (tooltip != null) {\no = 20;\nvar sx, sy;\nif (self.pageYOffset) { \/\/ all except Explorer\nsx = self.pageXOffset;\nsy = self.pageYOffset;\n}\nelse if (document.documentElement && document.documentElement.scrollTop) { \/\/ Explorer 6 Strict\nsx = document.documentElement.scrollLeft;\nsy = document.documentElement.scrollTop;\n}\nelse if (document.body) { \/\/ all other Explorers\nsx = document.body.scrollLeft;\nsy = document.body.scrollTop;\n}\nt = y + o + tooltip.offsetHeight;\nw = sy + document.body.clientHeight;\nif (t > w) {\ny = y - o - tooltip.offsetHeight;\n}\nelse {\ny = y + o;\n}\nt = x + o + tooltip.offsetWidth;\nw = sx + document.body.clientWidth;\nif (t > w) {\nx = x - o - tooltip.offsetWidth;\n}\nelse {\nx = x + o;\n}\nif ((tooltip.style.top == '' || tooltip.style.top == 0) && (tooltip.style.left == '' || tooltip.style.left == 0))\n{\ntooltip.style.width = tooltip.offsetWidth + 'px';\ntooltip.style.height = tooltip.offsetHeight + 'px';\n}\ntooltip.style.left = x + \"px\";\ntooltip.style.top = y + \"px\";\n}\n} catch (error) { error = null; }\n}\nfunction showTooltip(id) {\ntry {\ntooltip = document.getElementById(id);\ntooltip.style.display = \"block\";\n} catch (error) { error = null; }\n}\nfunction hideTooltip() {\ntry {\ntooltip.style.display = \"none\";\n} catch (error) { error = null; }\n}\n<\/script>\n\n<div class=\"tooltip\" id=\"n0\">Zoe Zed  Biodata<\/div>\n<div class=\"tooltip\" id=\"n1\">Jo Scaramuche  Biodata<\/div>\n<div class=\"tooltip\" id=\"n2\">Malcolm Plum  Biodata<\/div>\n<div class=\"tooltip\" id=\"n3\">George Rabbit  Biodata<\/div>\n<div class=\"tooltip\" id=\"n4\">Jo Blogs  Biodata<\/div>\n<div class=\"tooltip\" id=\"n5\">Fredrica Weed  Biodata<\/div>\n<div class=\"tooltip\" id=\"n6\">Lisa Triangle   Biodata<\/div>\n<div class=\"tooltip\" id=\"n7\">Fred  Fisher  Biodata<\/div>\n<div class=\"tooltip\" id=\"n8\">George Uno  Biodata<\/div>\n\n<map name=\"image1_1\">\n  <area shape=\"rect\" coords=\"551,511,727,634\" href=\"https:\/\/www.youtube.com\/watch?v=GZvSYJDk-us&#038;feature=emb_logo\" alt=\"\" onmouseover=\"showTooltip('n8')\" onmouseout=\"hideTooltip()\" target=\"_blank\"\/>\n  <area shape=\"rect\" coords=\"1023,511,1197,634\" href=\"https:\/\/www.youtube.com\/watch?v=GZvSYJDk-us&#038;feature=emb_logo\" alt=\"\" onmouseover=\"showTooltip('n7')\" onmouseout=\"hideTooltip()\" target=\"_blank\"\/>\n  <area shape=\"rect\" coords=\"799,511,951,634\" href=\"https:\/\/www.youtube.com\/watch?v=GZvSYJDk-us&#038;feature=emb_logo\" alt=\"\" onmouseover=\"showTooltip('n6')\" onmouseout=\"hideTooltip()\" target=\"_blank\"\/>\n  <area shape=\"rect\" coords=\"303,511,479,634\" href=\"https:\/\/www.youtube.com\/watch?v=GZvSYJDk-us&#038;feature=emb_logo\" alt=\"\" onmouseover=\"showTooltip('n5')\" onmouseout=\"hideTooltip()\" target=\"_blank\"\/>\n  <area shape=\"rect\" coords=\"15,511,231,634\" href=\"https:\/\/www.youtube.com\/watch?v=GZvSYJDk-us&#038;feature=emb_logo\" alt=\"\" onmouseover=\"showTooltip('n4')\" onmouseout=\"hideTooltip()\" target=\"_blank\"\/>\n  <area shape=\"rect\" coords=\"834,244,999,367\" href=\"https:\/\/www.youtube.com\/watch?v=GZvSYJDk-us&#038;feature=emb_logo\" alt=\"\" onmouseover=\"showTooltip('n3')\" onmouseout=\"hideTooltip()\" target=\"_blank\"\/>\n  <area shape=\"rect\" coords=\"321,244,462,367\" href=\"https:\/\/www.youtube.com\/watch?v=GZvSYJDk-us&#038;feature=emb_logo\" alt=\"\" onmouseover=\"showTooltip('n2')\" onmouseout=\"hideTooltip()\" target=\"_blank\"\/>\n  <area shape=\"rect\" coords=\"110,244,249,367\" href=\"https:\/\/www.youtube.com\/watch?v=GZvSYJDk-us&#038;feature=emb_logo\" alt=\"\" onmouseover=\"showTooltip('n1')\" onmouseout=\"hideTooltip()\" target=\"_blank\"\/>\n  <area shape=\"rect\" coords=\"322,16,461,139\" href=\"https:\/\/www.youtube.com\/watch?v=GZvSYJDk-us&#038;feature=emb_logo\" alt=\"\" onmouseover=\"showTooltip('n0')\" onmouseout=\"hideTooltip()\" target=\"_blank\"\/>\n<\/map>\n\n\n    <table class=\"yimagetable\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\">\n      <tr>\n        <td><img decoding=\"async\" class=\"yimage lazyload\" data-src=\"https:\/\/max-drake.cc\/data\/Orgchart\/orgchart.png\" usemap=\"#image1_1\" border=\"0\" alt=\"\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" \/><\/td>\n      <\/tr>\n    <\/table>\n\n<\/body>\n<\/html>\n\n\n\n<h3 class=\"wp-block-heading\">End comment<\/h3>\n\n\n\n<p>Its an interesting programme. I like the building of the chaert from an Excel file, I don&#8217;t like the total rebuild required once saved as a different file type. I do like the hyperlinks in the HTML files, thats quite handy. <\/p>\n\n\n\n<p>I need to think how I can build and lik data with this with the BIM info that I export. I need to mull it over for a while, as there is no obvious thing I can use this for, although relationships between rooms and data in a room might be an interesting hierarchy to explore and represent.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I&#8217;ve been doing some work for my daughter on her growing business. One of the things I was trying to work out was a flow process for the organisation, from seed o delivery and items needed along the way. I started to use Bubbl.us to look at some of the flows and organizational structures and [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":5939,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[32,12,29],"tags":[],"class_list":["post-5934","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-power-bi","category-visualisation","category-web"],"featured_image_src":"https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/12\/2019-12-20-19_12_44-ABC123y.jpg","featured_image_src_square":"https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/12\/2019-12-20-19_12_44-ABC123y.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\/5934","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=5934"}],"version-history":[{"count":0,"href":"https:\/\/max-drake.cc\/index.php?rest_route=\/wp\/v2\/posts\/5934\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/max-drake.cc\/index.php?rest_route=\/wp\/v2\/media\/5939"}],"wp:attachment":[{"href":"https:\/\/max-drake.cc\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=5934"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/max-drake.cc\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=5934"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/max-drake.cc\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=5934"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}