{"id":1036,"date":"2022-10-07T00:01:00","date_gmt":"2022-10-07T04:01:00","guid":{"rendered":"https:\/\/spreadsheet-day.com\/blog\/?p=1036"},"modified":"2024-10-31T09:59:42","modified_gmt":"2024-10-31T13:59:42","slug":"friday-fun-with-spreadsheets-2022-10-07","status":"publish","type":"post","link":"https:\/\/spreadsheet-day.com\/blog\/2022\/10\/07\/friday-fun-with-spreadsheets-2022-10-07\/","title":{"rendered":"Friday Fun with Spreadsheets 2022-10-07"},"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>Happy Friday! It&#8217;s only 10 days until Spreadsheet Day! In the meantime, here&#8217;s a bit of Friday fun, featuring spreadsheets. And if you&#8217;re in Canada, like I am, Happy Thanksgiving weekend!<\/p>\n<p><!--more--><\/p>\n<h3>Spreadsheet Art<\/h3>\n<p>There&#8217;s definitely an art to making great spreadsheets. But do you ever use spreadsheets to create art?<\/p>\n<p>For example, I love this North Carolina lighthouse, made by Professor Elizabeth Albright, from Duke University&#8217;s Nicholas School of the Environment.<\/p>\n<blockquote class=\"twitter-tweet\">\n<p dir=\"ltr\" lang=\"en\">now that <a href=\"https:\/\/twitter.com\/DukeEnvironment?ref_src=twsrc%5Etfw\">@DukeEnvironment<\/a> course registration is done, had a bit of time for this morning&#8217;s <a href=\"https:\/\/twitter.com\/hashtag\/spreadsheet?src=hash&amp;ref_src=twsrc%5Etfw\">#spreadsheet<\/a> <a href=\"https:\/\/twitter.com\/hashtag\/art?src=hash&amp;ref_src=twsrc%5Etfw\">#art<\/a>. Cape Lookout <a href=\"https:\/\/twitter.com\/hashtag\/Lighthouse?src=hash&amp;ref_src=twsrc%5Etfw\">#Lighthouse<\/a> on the <a href=\"https:\/\/twitter.com\/hashtag\/crystalcoast?src=hash&amp;ref_src=twsrc%5Etfw\">#crystalcoast<\/a> of North Carolina. It&#8217;s the argyle one. <a href=\"https:\/\/twitter.com\/CapeLookoutNPS?ref_src=twsrc%5Etfw\">@CapeLookoutNPS<\/a>. <a href=\"https:\/\/twitter.com\/hashtag\/dataviz?src=hash&amp;ref_src=twsrc%5Etfw\">#dataviz<\/a> <a href=\"https:\/\/twitter.com\/hashtag\/DataScience?src=hash&amp;ref_src=twsrc%5Etfw\">#DataScience<\/a> <a href=\"https:\/\/twitter.com\/hashtag\/AcademicTwitter?src=hash&amp;ref_src=twsrc%5Etfw\">#AcademicTwitter<\/a> <a href=\"https:\/\/twitter.com\/hashtag\/AcademicMentalHealth?src=hash&amp;ref_src=twsrc%5Etfw\">#AcademicMentalHealth<\/a> <a href=\"https:\/\/t.co\/QCCZj7YHwq\">pic.twitter.com\/QCCZj7YHwq<\/a><\/p>\n<p>\u2014 Elizabeth Albright (@enviro_prof) <a href=\"https:\/\/twitter.com\/enviro_prof\/status\/1562813172628611073?ref_src=twsrc%5Etfw\">August 25, 2022<\/a><\/p><\/blockquote>\n<p><script async=\"\" src=\"https:\/\/platform.twitter.com\/widgets.js\" charset=\"utf-8\"><\/script><\/p>\n<h3>Coffee and Spreadsheets<\/h3>\n<p>If you usually drink coffee, or another hot beverage, while you work with spreadsheets, a shortcut mug might come in handy!<\/p>\n<p>These shortcuts work in Excel, and most of them probably work in other spreadsheets too.<\/p>\n<blockquote class=\"twitter-tweet\">\n<p dir=\"ltr\" lang=\"en\">Just a girl working on a <a href=\"https:\/\/twitter.com\/hashtag\/spreadsheet?src=hash&amp;ref_src=twsrc%5Etfw\">#spreadsheet<\/a> with my coffee and my awesome shortcut mug that <a href=\"https:\/\/twitter.com\/SMoore_teach?ref_src=twsrc%5Etfw\">@SMoore_teach<\/a> sent me! \u2615\ufe0f <a href=\"https:\/\/t.co\/9ttKFV3aUK\">pic.twitter.com\/9ttKFV3aUK<\/a><\/p>\n<p>\u2014 Bonnie Chelette (@BonnieChelette) <a href=\"https:\/\/twitter.com\/BonnieChelette\/status\/1575117120089767936?ref_src=twsrc%5Etfw\">September 28, 2022<\/a><\/p><\/blockquote>\n<p><script async=\"\" src=\"https:\/\/platform.twitter.com\/widgets.js\" charset=\"utf-8\"><\/script><\/p>\n<p>Writer Jennifer &#8220;Jay&#8221; Palumbo has a spreadsheet mug too, and it&#8217;s definitely based on Excel. I&#8217;m sure that many Google Sheets people would agree though. <img decoding=\"async\" class=\"wlEmoticon wlEmoticon-winkingsmile\" src=\"https:\/\/spreadsheet-day.com\/blog\/wp-content\/uploads\/2022\/09\/wlEmoticon-winkingsmile.png\" alt=\"Winking smile\" \/><\/p>\n<blockquote class=\"twitter-tweet\">\n<p dir=\"ltr\" lang=\"en\">Awwwwwww yeah. <a href=\"https:\/\/twitter.com\/hashtag\/excelspreadsheets?src=hash&amp;ref_src=twsrc%5Etfw\">#excelspreadsheets<\/a> <a href=\"https:\/\/twitter.com\/hashtag\/googledocs?src=hash&amp;ref_src=twsrc%5Etfw\">#googledocs<\/a> <a href=\"https:\/\/twitter.com\/hashtag\/spreadsheets?src=hash&amp;ref_src=twsrc%5Etfw\">#spreadsheets<\/a> <a href=\"https:\/\/twitter.com\/hashtag\/loveagoodspread?src=hash&amp;ref_src=twsrc%5Etfw\">#loveagoodspread<\/a> <a href=\"https:\/\/t.co\/BB7IBrT5o8\">pic.twitter.com\/BB7IBrT5o8<\/a><\/p>\n<p>\u2014 Jennifer &#8220;Jay&#8221; Palumbo (@jennjaypal) <a href=\"https:\/\/twitter.com\/jennjaypal\/status\/1577443369130889222?ref_src=twsrc%5Etfw\">October 4, 2022<\/a><\/p><\/blockquote>\n<p><script async=\"\" src=\"https:\/\/platform.twitter.com\/widgets.js\" charset=\"utf-8\"><\/script><\/p>\n<h3>Spreadsheet Meme of the Week<\/h3>\n<p>Things don&#8217;t always go well in a spreadsheet, and you might run into problems sometimes, if you&#8217;re\u00a0 using pivot tables.<\/p>\n<p>The pivot items don&#8217;t always sort the way you&#8217;d like them to, and some days there&#8217;s data missing, even though you know it&#8217;s in the source table.<\/p>\n<p>This week&#8217;s spreadsheet meme is a tribute to days like that:<\/p>\n<blockquote><p>My day in 2 words. Pivot. Table.<\/p><\/blockquote>\n<p><strong>Tip<\/strong>: Google Search can be your best friend on days like that, and there&#8217;s a page on my Contextures site that <a href=\"https:\/\/www.contextures.com\/excelpivottableerrors.html\" target=\"_blank\" rel=\"noopener\">has ways to troubleshoot pivot table errors<\/a>.<\/p>\n<p><a href=\"https:\/\/spreadsheet-day.com\/blog\/wp-content\/uploads\/2022\/10\/twowordspivottable.jpg\"><img loading=\"lazy\" decoding=\"async\" style=\"border: 0px currentcolor; display: inline; background-image: none;\" title=\"My day in 2 words. Pivot. Table.\" src=\"https:\/\/spreadsheet-day.com\/blog\/wp-content\/uploads\/2022\/10\/twowordspivottable_thumb.jpg\" alt=\"My day in 2 words. Pivot. Table.\" width=\"400\" height=\"400\" border=\"0\" \/><\/a><\/p>\n<h3>More Pivot Table Errors<\/h3>\n<p><a href=\"https:\/\/www.contextures.com\/errorpivottablefieldname.html\" target=\"_blank\" rel=\"noopener\">Error: Field Name Not Valid<\/a><\/p>\n<p><a href=\"https:\/\/www.contextures.com\/excelpivottableoverlaperror.html\" target=\"_blank\" rel=\"noopener\">Error: Pivot Table Overlap<\/a><\/p>\n<p><a href=\"https:\/\/www.contextures.com\/excelpivottablerefresh.html\" target=\"_blank\" rel=\"noopener\">Error: Couldn&#8217;t Get Data<\/a><\/p>\n<p><a href=\"https:\/\/www.contextures.com\/errorpivotrefnotvalid.html\" target=\"_blank\" rel=\"noopener\">Error: Reference Isn&#8217;t Valid<\/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>Happy Friday! It&#8217;s only 10 days until Spreadsheet Day! In the meantime, here&#8217;s a bit of Friday fun, featuring spreadsheets. And if you&#8217;re in Canada, like I am, Happy Thanksgiving weekend!<\/p>\n","protected":false},"author":1,"featured_media":1029,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[65,58],"tags":[],"class_list":["post-1036","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-friday-fun","category-spreadsheet-days"],"_links":{"self":[{"href":"https:\/\/spreadsheet-day.com\/blog\/wp-json\/wp\/v2\/posts\/1036","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=1036"}],"version-history":[{"count":4,"href":"https:\/\/spreadsheet-day.com\/blog\/wp-json\/wp\/v2\/posts\/1036\/revisions"}],"predecessor-version":[{"id":1292,"href":"https:\/\/spreadsheet-day.com\/blog\/wp-json\/wp\/v2\/posts\/1036\/revisions\/1292"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/spreadsheet-day.com\/blog\/wp-json\/wp\/v2\/media\/1029"}],"wp:attachment":[{"href":"https:\/\/spreadsheet-day.com\/blog\/wp-json\/wp\/v2\/media?parent=1036"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/spreadsheet-day.com\/blog\/wp-json\/wp\/v2\/categories?post=1036"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/spreadsheet-day.com\/blog\/wp-json\/wp\/v2\/tags?post=1036"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}