{"id":857,"date":"2009-09-29T14:20:10","date_gmt":"2009-09-29T18:20:10","guid":{"rendered":"https:\/\/www.highedwebtech.com\/?p=857"},"modified":"2016-02-27T11:03:11","modified_gmt":"2016-02-27T16:03:11","slug":"google-makes-college-radio-station-charting-easy","status":"publish","type":"post","link":"https:\/\/www.highedwebtech.com\/2009\/09\/29\/google-makes-college-radio-station-charting-easy\/","title":{"rendered":"Google Makes College Radio Station Charting Easy"},"content":{"rendered":"<p>You know what I really like about this new web 2.0, cloud, distributed era we&#8217;re living in? As a web developer, it means there are some times that I can stop writing custom apps that I have to support for years after their initial launch and hand off the duties to someone that can do it better than I can. In this case, Google.<\/p>\n<p>In addition to my <a href=\"https:\/\/www.highedwebtech.com\/wp-content\/uploads\/2009\/09\/www.allegheny.edu\" rel=\"nofollow\">regular job<\/a>, <a href=\"https:\/\/www.highedwebtech.com\/wp-content\/uploads\/2009\/09\/www.erieblogs.com\">other job<\/a>, side work, <a href=\"https:\/\/www.highedwebtech.com\/wp-content\/uploads\/2009\/09\/speaking-conferences\">speaking<\/a>, parenting and more, I&#8217;m one of the faculty advisers at our campus radio station, WARC 90.3 FM. It&#8217;s fun &#8211; I get to hang out with students and listen to tons of great music.<\/p>\n<p>For as long as I&#8217;ve been here, student DJs would record every song they played on a sheet of paper and leave it in a box at the end of their show. As a station, we report what&#8217;s being played to places like <a href=\"https:\/\/www.highedwebtech.com\/wp-content\/uploads\/2009\/09\/www.cmj.com\">CMJ<\/a> &#8211; it helps them track what&#8217;s popular and what&#8217;s being played at colleges around the county. Labels also like to know what types of music we&#8217;re playing so they can send us new stuff to check out.<\/p>\n<p>Collating all that paper and trying to figure out what was being played was a giant pain. It took quite a bit of time and effort, and we realized there had to be a better way.<\/p>\n<p>So, a few years ago, I cobbled together a quick web app that allowed DJs to record their show&#8217;s playlists on a computer that lived in the studio. It worked pretty well for DJs, but it was still a bit of a pain for the people charting.<\/p>\n<p>There was no easy way to enter in that week&#8217;s new releases. There wasn&#8217;t easy ways to count or organize playlists and tracks. Most of that is my fault &#8211; I didn&#8217;t have the time to really create a great app.<\/p>\n<p>This year, we&#8217;re fixing that. We&#8217;re letting Google do all the heavy lifting. Since we transitioned our students and staff to Google Mail and Apps this summer, all our students have easy access to Google Spreadsheets. I created a quick form, that looks like this:<\/p>\n<p style=\"text-align: center;\"><a href=\"https:\/\/www.highedwebtech.com\/wp-content\/uploads\/2009\/09\/Screen-shot-2009-09-29-at-10.42.25-AM11.png\"><img decoding=\"async\" class=\"aligncenter  wp-image-858\" title=\"Screen shot 2009-09-29 at 10.42.25 AM\" alt=\"Screen shot 2009-09-29 at 10.42.25 AM\" src=\"https:\/\/www.highedwebtech.com\/wp-content\/uploads\/2009\/09\/Screen-shot-2009-09-29-at-10.42.25-AM-275x3001.png\" \/><\/a><\/p>\n<p>It&#8217;s set as the homepage of the studio computer and for DJs, the process really hasn&#8217;t changed that much. For the music director, his life has become much easier. Google Spreadsheets let you quick organize, parse and get out data quickly into many different formats. We can have multiple people getting in and working with the data. So far this semester, it&#8217;s been great. Here&#8217;s a look at the backend:<\/p>\n<p style=\"text-align: center;\"><a href=\"https:\/\/www.highedwebtech.com\/wp-content\/uploads\/2009\/09\/Screen-shot-2009-09-29-at-10.42.56-AM11.png\"><img decoding=\"async\" class=\"aligncenter  wp-image-859\" title=\"Screen shot 2009-09-29 at 10.42.56 AM\" alt=\"Screen shot 2009-09-29 at 10.42.56 AM\" src=\"https:\/\/www.highedwebtech.com\/wp-content\/uploads\/2009\/09\/Screen-shot-2009-09-29-at-10.42.56-AM-300x2051.png\" \/><\/a><\/p>\n<p>So far so good. I&#8217;m happy with it, our DJ&#8217;s are happy and our general manager and music director are happy. Wins all around.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Charting for radio stations is easier with Google Docs.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""}},"footnotes":""},"categories":[37,38],"tags":[113,234,759],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Google Makes College Radio Station Charting Easy - HighEdWebTech<\/title>\n<meta name=\"description\" content=\"Charting for radio stations is easier with Google Docs.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.highedwebtech.com\/2009\/09\/29\/google-makes-college-radio-station-charting-easy\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Google Makes College Radio Station Charting Easy - HighEdWebTech\" \/>\n<meta property=\"og:description\" content=\"Charting for radio stations is easier with Google Docs.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.highedwebtech.com\/2009\/09\/29\/google-makes-college-radio-station-charting-easy\/\" \/>\n<meta property=\"og:site_name\" content=\"HighEdWebTech\" \/>\n<meta property=\"article:published_time\" content=\"2009-09-29T18:20:10+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2016-02-27T16:03:11+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.highedwebtech.com\/wp-content\/uploads\/2009\/09\/Screen-shot-2009-09-29-at-10.42.25-AM-275x3001.png\" \/>\n<meta name=\"author\" content=\"Mike\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@mrichwalsky\" \/>\n<meta name=\"twitter:site\" content=\"@mrichwalsky\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Mike\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.highedwebtech.com\/2009\/09\/29\/google-makes-college-radio-station-charting-easy\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.highedwebtech.com\/2009\/09\/29\/google-makes-college-radio-station-charting-easy\/\"},\"author\":{\"name\":\"Mike\",\"@id\":\"https:\/\/www.highedwebtech.com\/#\/schema\/person\/c923dc4801e5e0b88fa4def573701980\"},\"headline\":\"Google Makes College Radio Station Charting Easy\",\"datePublished\":\"2009-09-29T18:20:10+00:00\",\"dateModified\":\"2016-02-27T16:03:11+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.highedwebtech.com\/2009\/09\/29\/google-makes-college-radio-station-charting-easy\/\"},\"wordCount\":458,\"publisher\":{\"@id\":\"https:\/\/www.highedwebtech.com\/#\/schema\/person\/c923dc4801e5e0b88fa4def573701980\"},\"image\":{\"@id\":\"https:\/\/www.highedwebtech.com\/2009\/09\/29\/google-makes-college-radio-station-charting-easy\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.highedwebtech.com\/wp-content\/uploads\/2009\/09\/Screen-shot-2009-09-29-at-10.42.25-AM-275x3001.png\",\"keywords\":[\"allegheny college\",\"College Radio\",\"WARC\"],\"articleSection\":[\"Google\",\"Google Apps\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.highedwebtech.com\/2009\/09\/29\/google-makes-college-radio-station-charting-easy\/\",\"url\":\"https:\/\/www.highedwebtech.com\/2009\/09\/29\/google-makes-college-radio-station-charting-easy\/\",\"name\":\"Google Makes College Radio Station Charting Easy - HighEdWebTech\",\"isPartOf\":{\"@id\":\"https:\/\/www.highedwebtech.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.highedwebtech.com\/2009\/09\/29\/google-makes-college-radio-station-charting-easy\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.highedwebtech.com\/2009\/09\/29\/google-makes-college-radio-station-charting-easy\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.highedwebtech.com\/wp-content\/uploads\/2009\/09\/Screen-shot-2009-09-29-at-10.42.25-AM-275x3001.png\",\"datePublished\":\"2009-09-29T18:20:10+00:00\",\"dateModified\":\"2016-02-27T16:03:11+00:00\",\"description\":\"Charting for radio stations is easier with Google Docs.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.highedwebtech.com\/2009\/09\/29\/google-makes-college-radio-station-charting-easy\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.highedwebtech.com\/2009\/09\/29\/google-makes-college-radio-station-charting-easy\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.highedwebtech.com\/2009\/09\/29\/google-makes-college-radio-station-charting-easy\/#primaryimage\",\"url\":\"https:\/\/www.highedwebtech.com\/wp-content\/uploads\/2009\/09\/Screen-shot-2009-09-29-at-10.42.25-AM.png\",\"contentUrl\":\"https:\/\/www.highedwebtech.com\/wp-content\/uploads\/2009\/09\/Screen-shot-2009-09-29-at-10.42.25-AM.png\",\"width\":608,\"height\":661},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.highedwebtech.com\/2009\/09\/29\/google-makes-college-radio-station-charting-easy\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.highedwebtech.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Google Makes College Radio Station Charting Easy\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.highedwebtech.com\/#website\",\"url\":\"https:\/\/www.highedwebtech.com\/\",\"name\":\"HighEdWebTech\",\"description\":\"Web &amp; Marketing for Education &amp; Nonprofits\",\"publisher\":{\"@id\":\"https:\/\/www.highedwebtech.com\/#\/schema\/person\/c923dc4801e5e0b88fa4def573701980\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.highedwebtech.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/www.highedwebtech.com\/#\/schema\/person\/c923dc4801e5e0b88fa4def573701980\",\"name\":\"Mike\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.highedwebtech.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/www.highedwebtech.com\/wp-content\/uploads\/2019\/11\/HEWT-2020-Logo.png\",\"contentUrl\":\"https:\/\/www.highedwebtech.com\/wp-content\/uploads\/2019\/11\/HEWT-2020-Logo.png\",\"width\":595,\"height\":128,\"caption\":\"Mike\"},\"logo\":{\"@id\":\"https:\/\/www.highedwebtech.com\/#\/schema\/person\/image\/\"},\"sameAs\":[\"https:\/\/www.instagram.com\/mikerichwalsky\/\",\"https:\/\/twitter.com\/mrichwalsky\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Google Makes College Radio Station Charting Easy - HighEdWebTech","description":"Charting for radio stations is easier with Google Docs.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.highedwebtech.com\/2009\/09\/29\/google-makes-college-radio-station-charting-easy\/","og_locale":"en_US","og_type":"article","og_title":"Google Makes College Radio Station Charting Easy - HighEdWebTech","og_description":"Charting for radio stations is easier with Google Docs.","og_url":"https:\/\/www.highedwebtech.com\/2009\/09\/29\/google-makes-college-radio-station-charting-easy\/","og_site_name":"HighEdWebTech","article_published_time":"2009-09-29T18:20:10+00:00","article_modified_time":"2016-02-27T16:03:11+00:00","og_image":[{"url":"https:\/\/www.highedwebtech.com\/wp-content\/uploads\/2009\/09\/Screen-shot-2009-09-29-at-10.42.25-AM-275x3001.png"}],"author":"Mike","twitter_card":"summary_large_image","twitter_creator":"@mrichwalsky","twitter_site":"@mrichwalsky","twitter_misc":{"Written by":"Mike","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.highedwebtech.com\/2009\/09\/29\/google-makes-college-radio-station-charting-easy\/#article","isPartOf":{"@id":"https:\/\/www.highedwebtech.com\/2009\/09\/29\/google-makes-college-radio-station-charting-easy\/"},"author":{"name":"Mike","@id":"https:\/\/www.highedwebtech.com\/#\/schema\/person\/c923dc4801e5e0b88fa4def573701980"},"headline":"Google Makes College Radio Station Charting Easy","datePublished":"2009-09-29T18:20:10+00:00","dateModified":"2016-02-27T16:03:11+00:00","mainEntityOfPage":{"@id":"https:\/\/www.highedwebtech.com\/2009\/09\/29\/google-makes-college-radio-station-charting-easy\/"},"wordCount":458,"publisher":{"@id":"https:\/\/www.highedwebtech.com\/#\/schema\/person\/c923dc4801e5e0b88fa4def573701980"},"image":{"@id":"https:\/\/www.highedwebtech.com\/2009\/09\/29\/google-makes-college-radio-station-charting-easy\/#primaryimage"},"thumbnailUrl":"https:\/\/www.highedwebtech.com\/wp-content\/uploads\/2009\/09\/Screen-shot-2009-09-29-at-10.42.25-AM-275x3001.png","keywords":["allegheny college","College Radio","WARC"],"articleSection":["Google","Google Apps"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.highedwebtech.com\/2009\/09\/29\/google-makes-college-radio-station-charting-easy\/","url":"https:\/\/www.highedwebtech.com\/2009\/09\/29\/google-makes-college-radio-station-charting-easy\/","name":"Google Makes College Radio Station Charting Easy - HighEdWebTech","isPartOf":{"@id":"https:\/\/www.highedwebtech.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.highedwebtech.com\/2009\/09\/29\/google-makes-college-radio-station-charting-easy\/#primaryimage"},"image":{"@id":"https:\/\/www.highedwebtech.com\/2009\/09\/29\/google-makes-college-radio-station-charting-easy\/#primaryimage"},"thumbnailUrl":"https:\/\/www.highedwebtech.com\/wp-content\/uploads\/2009\/09\/Screen-shot-2009-09-29-at-10.42.25-AM-275x3001.png","datePublished":"2009-09-29T18:20:10+00:00","dateModified":"2016-02-27T16:03:11+00:00","description":"Charting for radio stations is easier with Google Docs.","breadcrumb":{"@id":"https:\/\/www.highedwebtech.com\/2009\/09\/29\/google-makes-college-radio-station-charting-easy\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.highedwebtech.com\/2009\/09\/29\/google-makes-college-radio-station-charting-easy\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.highedwebtech.com\/2009\/09\/29\/google-makes-college-radio-station-charting-easy\/#primaryimage","url":"https:\/\/www.highedwebtech.com\/wp-content\/uploads\/2009\/09\/Screen-shot-2009-09-29-at-10.42.25-AM.png","contentUrl":"https:\/\/www.highedwebtech.com\/wp-content\/uploads\/2009\/09\/Screen-shot-2009-09-29-at-10.42.25-AM.png","width":608,"height":661},{"@type":"BreadcrumbList","@id":"https:\/\/www.highedwebtech.com\/2009\/09\/29\/google-makes-college-radio-station-charting-easy\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.highedwebtech.com\/"},{"@type":"ListItem","position":2,"name":"Google Makes College Radio Station Charting Easy"}]},{"@type":"WebSite","@id":"https:\/\/www.highedwebtech.com\/#website","url":"https:\/\/www.highedwebtech.com\/","name":"HighEdWebTech","description":"Web &amp; Marketing for Education &amp; Nonprofits","publisher":{"@id":"https:\/\/www.highedwebtech.com\/#\/schema\/person\/c923dc4801e5e0b88fa4def573701980"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.highedwebtech.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/www.highedwebtech.com\/#\/schema\/person\/c923dc4801e5e0b88fa4def573701980","name":"Mike","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.highedwebtech.com\/#\/schema\/person\/image\/","url":"https:\/\/www.highedwebtech.com\/wp-content\/uploads\/2019\/11\/HEWT-2020-Logo.png","contentUrl":"https:\/\/www.highedwebtech.com\/wp-content\/uploads\/2019\/11\/HEWT-2020-Logo.png","width":595,"height":128,"caption":"Mike"},"logo":{"@id":"https:\/\/www.highedwebtech.com\/#\/schema\/person\/image\/"},"sameAs":["https:\/\/www.instagram.com\/mikerichwalsky\/","https:\/\/twitter.com\/mrichwalsky"]}]}},"_links":{"self":[{"href":"https:\/\/www.highedwebtech.com\/wp-json\/wp\/v2\/posts\/857"}],"collection":[{"href":"https:\/\/www.highedwebtech.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.highedwebtech.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.highedwebtech.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.highedwebtech.com\/wp-json\/wp\/v2\/comments?post=857"}],"version-history":[{"count":0,"href":"https:\/\/www.highedwebtech.com\/wp-json\/wp\/v2\/posts\/857\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.highedwebtech.com\/wp-json\/wp\/v2\/media?parent=857"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.highedwebtech.com\/wp-json\/wp\/v2\/categories?post=857"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.highedwebtech.com\/wp-json\/wp\/v2\/tags?post=857"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}