{"id":109,"date":"2010-07-19T00:01:00","date_gmt":"2010-07-19T04:01:00","guid":{"rendered":"http:\/\/spreadsheet-day.com\/blog\/2010\/07\/19\/spreadsheet-creativity-streaming-radio\/"},"modified":"2020-12-09T16:37:39","modified_gmt":"2020-12-09T21:37:39","slug":"spreadsheet-creativity-streaming-radio","status":"publish","type":"post","link":"https:\/\/spreadsheet-day.com\/blog\/2010\/07\/19\/spreadsheet-creativity-streaming-radio\/","title":{"rendered":"Spreadsheet Creativity: Streaming Radio"},"content":{"rendered":"<div class=\"d942c2121bfbd137a3b44056a000f09c\" data-index=\"1\" style=\"float: none; margin:10px 0 10px 0; text-align:center;\">\n<script async src=\"\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js\"><\/script>\r\n<!-- Responsive Top -->\r\n<ins class=\"adsbygoogle\"\r\n     style=\"display:block\"\r\n     data-ad-client=\"ca-pub-9531091850463532\"\r\n     data-ad-slot=\"6574318169\"\r\n     data-ad-format=\"auto\"><\/ins>\r\n<script>\r\n(adsbygoogle = window.adsbygoogle || []).push({});\r\n<\/script>\n<\/div>\n<p>Just because you spend the day in a cubicle, staring at spreadsheets, doesn&#8217;t mean you shouldn&#8217;t have a bit of entertainment. Along with your analysis of banknotes, you can enjoy a few musical notes, with the Excel embedded streaming radio.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" style=\"display: inline; border-width: 0px;\" title=\"radiostreaming\" src=\"http:\/\/spreadsheet-day.com\/blog\/wp-content\/uploads\/2010\/07\/radiostreaming01.png\" alt=\"radiostreaming\" width=\"159\" height=\"161\" border=\"0\" \/><\/p>\n<h2>Excel Based Web Radio<\/h2>\n<p>In today&#8217;s example of spreadsheet ingenuity, Harald Staff, a Microsoft Excel MVP for several years, shares his Excel based web radio workbook.<\/p>\n<p>Read more about Harald, in the About the Developer section below.<\/p>\n<h2>Operate the Radio<\/h2>\n<p>The web radio workbook is small, and easy to use.<\/p>\n<ul>\n<li>Open the Web Radio file, and enable macros.<\/li>\n<li>Double-click on one of the radio station names in column A, to play that station, in the embedded player.<\/li>\n<li>You can add or remove stations in the list, to suit your musical taste, or lack of taste.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" style=\"display: inline; border-width: 0px;\" title=\"radiostreaming\" src=\"http:\/\/spreadsheet-day.com\/blog\/wp-content\/uploads\/2010\/07\/radiostreaming.png\" alt=\"radiostreaming\" width=\"398\" height=\"221\" border=\"0\" \/><\/p>\n<h2>Move the Embedded Player<\/h2>\n<p>If you want to move the embedded player, follow these steps.<\/p>\n<p>First, if you don&#8217;t see a Developer Tab on the Excel Ribbon, follow these steps to show it:<\/p>\n<ol>\n<li>Right-click on the Excel Ribbon<\/li>\n<li>Click Customize the Ribbon<\/li>\n<li>In the list at the right, add a check mark beside Developer.<\/li>\n<li>Click OK, to close the Excel Options window.<\/li>\n<\/ol>\n<p><a href=\"https:\/\/spreadsheet-day.com\/blog\/wp-content\/uploads\/2010\/07\/developertab01.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-866\" src=\"https:\/\/spreadsheet-day.com\/blog\/wp-content\/uploads\/2010\/07\/developertab01.png\" alt=\"show developer tab on Excel ribbon\" width=\"388\" height=\"321\" srcset=\"https:\/\/spreadsheet-day.com\/blog\/wp-content\/uploads\/2010\/07\/developertab01.png 388w, https:\/\/spreadsheet-day.com\/blog\/wp-content\/uploads\/2010\/07\/developertab01-300x248.png 300w\" sizes=\"auto, (max-width: 388px) 100vw, 388px\" \/><\/a><\/p>\n<p>Next, follow steps to move the embedded player:<\/p>\n<ol>\n<li>Click the Excel Ribbon&#8217;s Developer tab<\/li>\n<li>In the Controls group, click Design Mode<\/li>\n<li>The embedded player disappears, but click where it was<\/li>\n<li>You&#8217;ll see the outline of the selected player<\/li>\n<li>Point to the outlined player<\/li>\n<li>When a 4-headed arrow pointer appears, drag the player to a new location on the worksheet\n<ul>\n<li>NOTE: The outline will disappear while you drag<\/li>\n<\/ul>\n<\/li>\n<li>To see the player again, click Design Mode on the Developer Tab<\/li>\n<\/ol>\n<p><a href=\"https:\/\/spreadsheet-day.com\/blog\/wp-content\/uploads\/2010\/07\/webradio01.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-867\" src=\"https:\/\/spreadsheet-day.com\/blog\/wp-content\/uploads\/2010\/07\/webradio01.png\" alt=\"drag embedded player to new location\" width=\"337\" height=\"340\" srcset=\"https:\/\/spreadsheet-day.com\/blog\/wp-content\/uploads\/2010\/07\/webradio01.png 337w, https:\/\/spreadsheet-day.com\/blog\/wp-content\/uploads\/2010\/07\/webradio01-150x150.png 150w, https:\/\/spreadsheet-day.com\/blog\/wp-content\/uploads\/2010\/07\/webradio01-297x300.png 297w, https:\/\/spreadsheet-day.com\/blog\/wp-content\/uploads\/2010\/07\/webradio01-160x160.png 160w\" sizes=\"auto, (max-width: 337px) 100vw, 337px\" \/><\/a><\/p>\n<h2>Download the Web Radio Sample File<\/h2>\n<p>You can click this link to download Harald&#8217;s <a href=\"https:\/\/www.contextures.com\/Webradio.zip\" target=\"_blank\" rel=\"noopener\">Webradio sample file<\/a>.<\/p>\n<p>The file is zipped, and in Excel 2003 format (xls).<\/p>\n<h2>About the Developer: Harald Staff<\/h2>\n<p>Harald Staff was an Excel expert, and received the Microsoft Excel MVP award for several years. I had the pleasure of meeting Harald at a couple of the MVP Summits in Seattle, in 2001 and 2003 (a couple of photos are below).<\/p>\n<p>Always willing to share his knowledge, Harald <a href=\"https:\/\/www.contextures.com\/xlngstatsAnnual.html\" target=\"_blank\" rel=\"noopener\">answered thousands of Excel questions<\/a> in the old Microsoft Excel newsgroups. Many of the questions appeared over and over again, as new people arrived in the newsgroups, seeking help.<\/p>\n<p>So, Harald compiled a list of those frequently asked questions (FAQs), and gave his kind permission for me to <a href=\"https:\/\/www.contextures.com\/xlfaqIndex.html\" target=\"_blank\" rel=\"noopener\">publish the FAQ list on my Contextures site<\/a>.<\/p>\n<p>Sadly, Harald passed away in December 2020, much too soon, and he will be missed.<\/p>\n<h3>MVP Summit Photos<\/h3>\n<p>Here are some of the Excel MVPs, at the 2001 Summit in Seattle. Around the table, starting at the top left: Rob Bovey, Harald Staff, Niek Otten, Debra Dalgleish, Jake Marx, Tushar Mehta.<\/p>\n<p>That was the first Summit I attended, and it was wonderful meeting all the Excel expert from the newsgroups.<\/p>\n<p><a href=\"https:\/\/spreadsheet-day.com\/blog\/wp-content\/uploads\/2010\/07\/harald_seattle200111.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-874 size-full\" title=\"MVP Summit 2001\" src=\"https:\/\/spreadsheet-day.com\/blog\/wp-content\/uploads\/2010\/07\/harald_seattle200111.jpg\" alt=\"MVP Summit 2001 Excel MVPs at table relaxing\" width=\"450\" height=\"297\" srcset=\"https:\/\/spreadsheet-day.com\/blog\/wp-content\/uploads\/2010\/07\/harald_seattle200111.jpg 450w, https:\/\/spreadsheet-day.com\/blog\/wp-content\/uploads\/2010\/07\/harald_seattle200111-300x198.jpg 300w\" sizes=\"auto, (max-width: 450px) 100vw, 450px\" \/><\/a><\/p>\n<p>This photo was taken at the Summit 2003 party night, while Harald and I played a game of pool, or maybe it was billiards? That should tell you a bit about my skills in the game! Harald, as always, was a great sport, and didn&#8217;t make fun of my lack of ability at the game. \ud83d\ude09<\/p>\n<p><a href=\"https:\/\/spreadsheet-day.com\/blog\/wp-content\/uploads\/2010\/07\/harald_seattle200302.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-875 size-full\" title=\"Debra and Harald playing pool at MVP Summit 2003 party night\" src=\"https:\/\/spreadsheet-day.com\/blog\/wp-content\/uploads\/2010\/07\/harald_seattle200302.jpg\" alt=\"Debra and Harald playing pool at MVP Summit 2003 party night\" width=\"450\" height=\"337\" srcset=\"https:\/\/spreadsheet-day.com\/blog\/wp-content\/uploads\/2010\/07\/harald_seattle200302.jpg 450w, https:\/\/spreadsheet-day.com\/blog\/wp-content\/uploads\/2010\/07\/harald_seattle200302-300x225.jpg 300w\" sizes=\"auto, (max-width: 450px) 100vw, 450px\" \/><\/a><\/p>\n<p>__________<\/p>\n\n<div style=\"font-size: 0px; height: 0px; line-height: 0px; margin: 0; padding: 0; clear: both;\"><\/div>","protected":false},"excerpt":{"rendered":"<p>Just because you spend the day in a cubicle, staring at spreadsheets, doesn&#8217;t mean you shouldn&#8217;t have a bit of entertainment. Along with your analysis of banknotes, you can enjoy a few musical notes,&#46;&#46;&#46;<\/p>\n","protected":false},"author":1,"featured_media":108,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3,4],"tags":[22,24,23],"class_list":["post-109","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-spreadsheet-day","category-spreadsheets","tag-excel","tag-music","tag-web-radio"],"_links":{"self":[{"href":"https:\/\/spreadsheet-day.com\/blog\/wp-json\/wp\/v2\/posts\/109","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/spreadsheet-day.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/spreadsheet-day.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/spreadsheet-day.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/spreadsheet-day.com\/blog\/wp-json\/wp\/v2\/comments?post=109"}],"version-history":[{"count":4,"href":"https:\/\/spreadsheet-day.com\/blog\/wp-json\/wp\/v2\/posts\/109\/revisions"}],"predecessor-version":[{"id":876,"href":"https:\/\/spreadsheet-day.com\/blog\/wp-json\/wp\/v2\/posts\/109\/revisions\/876"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/spreadsheet-day.com\/blog\/wp-json\/wp\/v2\/media\/108"}],"wp:attachment":[{"href":"https:\/\/spreadsheet-day.com\/blog\/wp-json\/wp\/v2\/media?parent=109"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/spreadsheet-day.com\/blog\/wp-json\/wp\/v2\/categories?post=109"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/spreadsheet-day.com\/blog\/wp-json\/wp\/v2\/tags?post=109"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}