{"id":129,"date":"2010-08-05T00:30:00","date_gmt":"2010-08-05T04:30:00","guid":{"rendered":"http:\/\/spreadsheet-day.com\/blog\/2010\/08\/05\/spreadsheet-planning-home-improvement\/"},"modified":"2019-10-18T15:16:32","modified_gmt":"2019-10-18T19:16:32","slug":"spreadsheet-planning-home-improvement","status":"publish","type":"post","link":"https:\/\/spreadsheet-day.com\/blog\/2010\/08\/05\/spreadsheet-planning-home-improvement\/","title":{"rendered":"Spreadsheet Planning: Home Improvement"},"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><img loading=\"lazy\" decoding=\"async\" style=\"display: inline; margin-left: 0px; margin-right: 0px; border: 0px;\" title=\"image\" src=\"http:\/\/spreadsheet-day.com\/blog\/wp-content\/uploads\/2010\/08\/image.png\" alt=\"image\" width=\"102\" height=\"102\" align=\"right\" border=\"0\" \/>Spreadsheets aren&#8217;t just for project planning at the office &#8212; it&#8217;s great for planning home improvement projects too.<\/p>\n<p>Fred Chidester Sr., who claims to be in his 70s (hard to believe!), is always looking for new ways to use Excel. He&#8217;s currently working on a bathroom renovation, and sent me the Excel file that he&#8217;s using to plan and manage the project.<\/p>\n<p>A man of few words, Fred didn&#8217;t bore me with all the details, and simply described his workbook as:<\/p>\n<blockquote><p>It isn&#8217;t pretty, but it is getting the job done.<\/p><\/blockquote>\n<h3>Planning the Renovation Budget<\/h3>\n<p>Despite Fred&#8217;s modest description, the workbook efficiently packs several tasks into a few sheets. On one worksheet, Fred keeps a list of supplies, with the order status, quantities and costs.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" style=\"display: inline; border: 0px;\" title=\"BathReno01\" src=\"http:\/\/spreadsheet-day.com\/blog\/wp-content\/uploads\/2010\/08\/BathReno01.png\" alt=\"BathReno01\" width=\"378\" height=\"173\" border=\"0\" \/><\/p>\n<p>On another sheet, Fred keeps track of the daily start and end times, and totals the material, labor, and other costs.<\/p>\n<h3>Designing the Renovation<\/h3>\n<p>Another sheet in the workbook as the bathroom layout, for the floors and wall tiles.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" style=\"display: inline; border: 0px;\" title=\"BathReno02\" src=\"http:\/\/spreadsheet-day.com\/blog\/wp-content\/uploads\/2010\/08\/BathReno02.png\" alt=\"BathReno02\" width=\"398\" height=\"262\" border=\"0\" \/><\/p>\n<p>There&#8217;s even a picture of the tiles that will be used.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" style=\"display: inline; border: 0px;\" title=\"BathReno03\" src=\"http:\/\/spreadsheet-day.com\/blog\/wp-content\/uploads\/2010\/08\/BathReno03.png\" alt=\"BathReno03\" width=\"388\" height=\"316\" border=\"0\" \/><\/p>\n<h3>Download the Bathroom Reno Sample File<\/h3>\n<p>You can download Fred&#8217;s <a href=\"https:\/\/spreadsheet-day.com\/blog\/wp-content\/uploads\/2010\/08\/BathReno.zip\">Bath Reno Sample File<\/a>, to see how it works. Thanks Fred!<\/p>\n<p>If you have any interesting or unusual spreadsheets of your own that you&#8217;d like to share, please let me know!<\/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>Spreadsheets aren&#8217;t just for project planning at the office &#8212; it&#8217;s great for planning home improvement projects too. Fred Chidester Sr., who claims to be in his 70s (hard to believe!), is always looking&#46;&#46;&#46;<\/p>\n","protected":false},"author":1,"featured_media":128,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3,4],"tags":[35,37,36],"class_list":["post-129","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-spreadsheet-day","category-spreadsheets","tag-home-renovation","tag-planning","tag-remodelling"],"_links":{"self":[{"href":"https:\/\/spreadsheet-day.com\/blog\/wp-json\/wp\/v2\/posts\/129","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=129"}],"version-history":[{"count":2,"href":"https:\/\/spreadsheet-day.com\/blog\/wp-json\/wp\/v2\/posts\/129\/revisions"}],"predecessor-version":[{"id":564,"href":"https:\/\/spreadsheet-day.com\/blog\/wp-json\/wp\/v2\/posts\/129\/revisions\/564"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/spreadsheet-day.com\/blog\/wp-json\/wp\/v2\/media\/128"}],"wp:attachment":[{"href":"https:\/\/spreadsheet-day.com\/blog\/wp-json\/wp\/v2\/media?parent=129"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/spreadsheet-day.com\/blog\/wp-json\/wp\/v2\/categories?post=129"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/spreadsheet-day.com\/blog\/wp-json\/wp\/v2\/tags?post=129"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}