{"id":842,"date":"2020-10-17T00:01:00","date_gmt":"2020-10-17T04:01:00","guid":{"rendered":"https:\/\/spreadsheet-day.com\/blog\/?p=842"},"modified":"2020-10-12T16:22:11","modified_gmt":"2020-10-12T20:22:11","slug":"happy-spreadsheet-day-2020","status":"publish","type":"post","link":"https:\/\/spreadsheet-day.com\/blog\/2020\/10\/17\/happy-spreadsheet-day-2020\/","title":{"rendered":"Happy Spreadsheet Day 2020"},"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 Spreadsheet Day 2020! What will you do today, to celebrate?<!--more--><\/p>\n<h3>A Bit of History<\/h3>\n<p>Spreadsheet Day started in 2010, and we celebrate on October 17th every year.\u00a0 That\u2019s the date that VisiCalc was first released, way back in 1979.<\/p>\n<p>You can read the <a href=\"https:\/\/spreadsheet-day.com\/blog\/about\/\" target=\"_blank\" rel=\"noopener\">details on the About page<\/a>.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/spreadsheet-day.com\/blog\/wp-content\/uploads\/2019\/10\/shipdate_benlo01.png\" \/><\/p>\n<h3>It\u2019s a Challenge<\/h3>\n<p>Most years, you probably celebrate Spreadsheet Day at your office, while sharing spreadsheet horror stories with your co-workers.<\/p>\n<p>But things are different this year, and lots of us are working from home now. We can\u2019t have indoor parties this year, but maybe you can find a place to celebrate Spreadsheet Day outside instead.<\/p>\n<p><a href=\"https:\/\/spreadsheet-day.com\/blog\/wp-content\/uploads\/2020\/10\/celebrateoutdoors01.jpg\"><img loading=\"lazy\" decoding=\"async\" style=\"border: 0px currentcolor; display: inline; background-image: none;\" title=\"celebrateoutdoors01\" src=\"https:\/\/spreadsheet-day.com\/blog\/wp-content\/uploads\/2020\/10\/celebrateoutdoors01_thumb.jpg\" alt=\"celebrateoutdoors01\" width=\"352\" height=\"352\" border=\"0\" \/><\/a><\/p>\n<h3>Excel Budget Workbook<\/h3>\n<p>Way back in October 2011, we were celebrating the 2nd Spreadsheet Day. In honour of that event, Bob Ryan, who created the Simply Learning Excel website, contributed <a href=\"https:\/\/www.pivot-table.com\/2011\/10\/17\/student-budget-with-pivot-tables-spreadsheet-day-2011\/\" target=\"_blank\" rel=\"noopener\">an Excel budget template for students<\/a>. Thanks, Bob!<\/p>\n<p>Bob recently updated that file, and now it\u2019s a budget tool for everyone, not just students. You can download a copy for yourself, or maybe you know someone who could use it to get their finances organized.<\/p>\n<h3>Formulas and Pivot Tables<\/h3>\n<p>The workbook doesn\u2019t have any macros \u2013 just formulas and pivot tables. There are lots of notes in the workbook too, explaining how things work.<\/p>\n<p>On the transaction data entry sheet, there\u2019s a handy formula in the Balance column, that shows your running total:<\/p>\n<ul>\n<li><strong>=SUM(F$1:[@[Act$]])<\/strong><\/li>\n<\/ul>\n<p>The formula sums from the heading cell, with the row locked (F$1), down to the current row, in the Act$ column.<\/p>\n<p><a href=\"https:\/\/spreadsheet-day.com\/blog\/wp-content\/uploads\/2020\/10\/runningtotaltable01.png\"><img loading=\"lazy\" decoding=\"async\" style=\"border: 0px currentcolor; display: inline; background-image: none;\" title=\"runningtotaltable01\" src=\"https:\/\/spreadsheet-day.com\/blog\/wp-content\/uploads\/2020\/10\/runningtotaltable01_thumb.png\" alt=\"runningtotaltable01\" width=\"389\" height=\"311\" border=\"0\" \/><\/a><\/p>\n<p>There is grouping on that worksheet too, to show or hide the additional budget columns, at the right.<\/p>\n<p>On other sheets, there are pivot tables to summarize your transaction data, and compare the budget amounts to the actuals.<\/p>\n<p><a href=\"https:\/\/spreadsheet-day.com\/blog\/wp-content\/uploads\/2020\/10\/budgettemplate_br01.png\"><img loading=\"lazy\" decoding=\"async\" style=\"border: 0px currentcolor; display: inline; background-image: none;\" title=\"budgettemplate_br01\" src=\"https:\/\/spreadsheet-day.com\/blog\/wp-content\/uploads\/2020\/10\/budgettemplate_br01_thumb.png\" alt=\"budgettemplate_br01\" width=\"375\" height=\"300\" border=\"0\" \/><\/a><\/p>\n<h3>Get the Budget Template<\/h3>\n<p>To get Bob Ryan\u2019s budget template workbook, go to <a href=\"https:\/\/www.contextures.com\/excelfiles.html\" target=\"_blank\" rel=\"noopener\">the Excel Sample Files page<\/a> on my Contextures website.<\/p>\n<p>In the Pivot Tables section, look for <a href=\"https:\/\/www.contextures.com\/excelfiles.html#pt0050\" target=\"_blank\" rel=\"noopener\">PT0050 &#8211; Excel Budget Template<\/a>. The file is in xlsx format, and it is zipped. There are no macros in the file.<\/p>\n<p>___________________<\/p>\n<h3>Happy Spreadsheet Day 2020<\/h3>\n<p><a href=\"https:\/\/spreadsheet-day.com\/blog\/wp-content\/uploads\/2020\/10\/spreadsheetday2020_01a.jpg\"><img loading=\"lazy\" decoding=\"async\" style=\"border: 0px currentcolor; display: inline; background-image: none;\" title=\"Happy Spreadsheet Day 2020\" src=\"https:\/\/spreadsheet-day.com\/blog\/wp-content\/uploads\/2020\/10\/spreadsheetday2020_01a_thumb.jpg\" alt=\"Happy Spreadsheet Day 2020\" width=\"400\" height=\"400\" border=\"0\" \/><\/a><\/p>\n<p><a href=\"https:\/\/spreadsheet-day.com\/blog\/wp-content\/uploads\/2020\/10\/spreadsheetday2020_01b.jpg\"><img loading=\"lazy\" decoding=\"async\" style=\"border: 0px currentcolor; display: inline; background-image: none;\" title=\"Happy Spreadsheet Day 2020\" src=\"https:\/\/spreadsheet-day.com\/blog\/wp-content\/uploads\/2020\/10\/spreadsheetday2020_01b_thumb.jpg\" alt=\"Happy Spreadsheet Day 2020\" width=\"400\" height=\"200\" border=\"0\" \/><\/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 Spreadsheet Day 2020! What will you do today, to celebrate?<\/p>\n","protected":false},"author":1,"featured_media":838,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-842","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-spreadsheet-day"],"_links":{"self":[{"href":"https:\/\/spreadsheet-day.com\/blog\/wp-json\/wp\/v2\/posts\/842","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=842"}],"version-history":[{"count":2,"href":"https:\/\/spreadsheet-day.com\/blog\/wp-json\/wp\/v2\/posts\/842\/revisions"}],"predecessor-version":[{"id":844,"href":"https:\/\/spreadsheet-day.com\/blog\/wp-json\/wp\/v2\/posts\/842\/revisions\/844"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/spreadsheet-day.com\/blog\/wp-json\/wp\/v2\/media\/838"}],"wp:attachment":[{"href":"https:\/\/spreadsheet-day.com\/blog\/wp-json\/wp\/v2\/media?parent=842"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/spreadsheet-day.com\/blog\/wp-json\/wp\/v2\/categories?post=842"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/spreadsheet-day.com\/blog\/wp-json\/wp\/v2\/tags?post=842"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}