{"id":647,"date":"2010-09-28T08:44:50","date_gmt":"2010-09-27T22:44:50","guid":{"rendered":"http:\/\/blog.dbohs.com\/?p=647"},"modified":"2024-10-11T15:48:17","modified_gmt":"2024-10-11T05:48:17","slug":"fun-with-excel","status":"publish","type":"post","link":"https:\/\/blog.dbohs.com\/?p=647","title":{"rendered":"Fun with Excel"},"content":{"rendered":"<p>I have used spreadsheets since Software Arts&#8217;\u00a0<a title=\"Visicalc\" href=\"http:\/\/www.google.com.au\/search?rlz=1C1GGGE_enAU374AU378&amp;aq=f&amp;sourceid=chrome&amp;ie=UTF-8&amp;q=Visicalc\" target=\"_blank\" rel=\"noopener\"><strong>Visicalc <\/strong><\/a>was available on an Apple II, but I really like digging under the bonnet to increase the power of Excel. Its even possible to use some 1500 extra functions hidden in the Windows operating system. I spent endless hours with my PhD creating diffusion models using Excel.<\/p>\n<p>I have just\u00a0discovered <strong>Excel Hero<\/strong><strong>,<\/strong> an Excel Blog with lots of downloads to play with.\u00a0\u00a0I rather liked this &#8220;Square Spiral&#8221; optical illusion and the\u00a0spreadsheet to create it.<\/p>\n<p style=\"text-align: center;\">\n","protected":false},"excerpt":{"rendered":"<p>I have used spreadsheets since Software Arts&#8217;\u00a0Visicalc was available on an Apple II, but I really like digging under the bonnet to increase the power of Excel. Its even possible to use some 1500 extra functions hidden in the Windows operating system. I spent endless hours with my PhD creating diffusion models using Excel. I [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[1],"tags":[130,121],"class_list":["post-647","post","type-post","status-publish","format-standard","category-uncategorized","tag-fun","tag-vba","czr-hentry"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 4.9.9 - aioseo.com -->\n\t<meta name=\"description\" content=\"I have used spreadsheets since Software Arts&#039; Visicalc was available on an Apple II, but I really like digging under the bonnet to increase the power of Excel. Its even possible to use some 1500 extra functions hidden in the Windows operating system. I spent endless hours with my PhD creating diffusion models using Excel. I\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"admin\"\/>\n\t<link rel=\"canonical\" href=\"https:\/\/blog.dbohs.com\/?p=647\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 4.9.9\" \/>\n\t\t<meta property=\"og:locale\" content=\"en_US\" \/>\n\t\t<meta property=\"og:site_name\" content=\"Wild and Woolly | Occupational Hygiene - and Ideas\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"Fun with Excel | Wild and Woolly\" \/>\n\t\t<meta property=\"og:description\" content=\"I have used spreadsheets since Software Arts&#039; Visicalc was available on an Apple II, but I really like digging under the bonnet to increase the power of Excel. Its even possible to use some 1500 extra functions hidden in the Windows operating system. I spent endless hours with my PhD creating diffusion models using Excel. I\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/blog.dbohs.com\/?p=647\" \/>\n\t\t<meta property=\"og:image\" content=\"https:\/\/blog.dbohs.com\/wordpress\/wp-content\/uploads\/Wild-and-Woolley.png\" \/>\n\t\t<meta property=\"og:image:secure_url\" content=\"https:\/\/blog.dbohs.com\/wordpress\/wp-content\/uploads\/Wild-and-Woolley.png\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2010-09-27T22:44:50+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2024-10-11T05:48:17+00:00\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary\" \/>\n\t\t<meta name=\"twitter:title\" content=\"Fun with Excel | Wild and Woolly\" \/>\n\t\t<meta name=\"twitter:description\" content=\"I have used spreadsheets since Software Arts&#039; Visicalc was available on an Apple II, but I really like digging under the bonnet to increase the power of Excel. Its even possible to use some 1500 extra functions hidden in the Windows operating system. I spent endless hours with my PhD creating diffusion models using Excel. I\" \/>\n\t\t<meta name=\"twitter:image\" content=\"https:\/\/blog.dbohs.com\/wordpress\/wp-content\/uploads\/Wild-and-Woolley.png\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/blog.dbohs.com\\\/?p=647#article\",\"name\":\"Fun with Excel | Wild and Woolly\",\"headline\":\"Fun with Excel\",\"author\":{\"@id\":\"https:\\\/\\\/blog.dbohs.com\\\/?author=3#author\"},\"publisher\":{\"@id\":\"https:\\\/\\\/blog.dbohs.com\\\/#person\"},\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/blog.dbohs.com\\\/?p=647#articleImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/dbaa9fe1c0960938d10f73a45ec32fd7403e987878d09a42c397c59a61da66f2?s=96&d=mm&r=g\",\"width\":96,\"height\":96,\"caption\":\"admin\"},\"datePublished\":\"2010-09-28T08:44:50+10:00\",\"dateModified\":\"2024-10-11T15:48:17+10:00\",\"inLanguage\":\"en-US\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/blog.dbohs.com\\\/?p=647#webpage\"},\"isPartOf\":{\"@id\":\"https:\\\/\\\/blog.dbohs.com\\\/?p=647#webpage\"},\"articleSection\":\"Uncategorized, fun, VBA\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/blog.dbohs.com\\\/?p=647#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/blog.dbohs.com#listItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/blog.dbohs.com\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/blog.dbohs.com\\\/?cat=1#listItem\",\"name\":\"Uncategorized\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/blog.dbohs.com\\\/?cat=1#listItem\",\"position\":2,\"name\":\"Uncategorized\",\"item\":\"https:\\\/\\\/blog.dbohs.com\\\/?cat=1\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/blog.dbohs.com\\\/?p=647#listItem\",\"name\":\"Fun with Excel\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/blog.dbohs.com#listItem\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/blog.dbohs.com\\\/?p=647#listItem\",\"position\":3,\"name\":\"Fun with Excel\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/blog.dbohs.com\\\/?cat=1#listItem\",\"name\":\"Uncategorized\"}}]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/blog.dbohs.com\\\/#person\",\"name\":\"David Bromwich\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/blog.dbohs.com\\\/?p=647#personImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/b95a4b8562be54c8b766757dc9e19aaf5bd9c83ce051490cda1caf3077fc8e68?s=96&d=mm&r=g\",\"width\":96,\"height\":96,\"caption\":\"David Bromwich\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/blog.dbohs.com\\\/?author=3#author\",\"url\":\"https:\\\/\\\/blog.dbohs.com\\\/?author=3\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/blog.dbohs.com\\\/?p=647#authorImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/dbaa9fe1c0960938d10f73a45ec32fd7403e987878d09a42c397c59a61da66f2?s=96&d=mm&r=g\",\"width\":96,\"height\":96,\"caption\":\"admin\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/blog.dbohs.com\\\/?p=647#webpage\",\"url\":\"https:\\\/\\\/blog.dbohs.com\\\/?p=647\",\"name\":\"Fun with Excel | Wild and Woolly\",\"description\":\"I have used spreadsheets since Software Arts' Visicalc was available on an Apple II, but I really like digging under the bonnet to increase the power of Excel. Its even possible to use some 1500 extra functions hidden in the Windows operating system. I spent endless hours with my PhD creating diffusion models using Excel. I\",\"inLanguage\":\"en-US\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/blog.dbohs.com\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/blog.dbohs.com\\\/?p=647#breadcrumblist\"},\"author\":{\"@id\":\"https:\\\/\\\/blog.dbohs.com\\\/?author=3#author\"},\"creator\":{\"@id\":\"https:\\\/\\\/blog.dbohs.com\\\/?author=3#author\"},\"datePublished\":\"2010-09-28T08:44:50+10:00\",\"dateModified\":\"2024-10-11T15:48:17+10:00\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/blog.dbohs.com\\\/#website\",\"url\":\"https:\\\/\\\/blog.dbohs.com\\\/\",\"name\":\"Wild and Woolly\",\"description\":\"Occupational Hygiene - and Ideas\",\"inLanguage\":\"en-US\",\"publisher\":{\"@id\":\"https:\\\/\\\/blog.dbohs.com\\\/#person\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"Fun with Excel | Wild and Woolly","description":"I have used spreadsheets since Software Arts' Visicalc was available on an Apple II, but I really like digging under the bonnet to increase the power of Excel. Its even possible to use some 1500 extra functions hidden in the Windows operating system. I spent endless hours with my PhD creating diffusion models using Excel. I","canonical_url":"https:\/\/blog.dbohs.com\/?p=647","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/blog.dbohs.com\/?p=647#article","name":"Fun with Excel | Wild and Woolly","headline":"Fun with Excel","author":{"@id":"https:\/\/blog.dbohs.com\/?author=3#author"},"publisher":{"@id":"https:\/\/blog.dbohs.com\/#person"},"image":{"@type":"ImageObject","@id":"https:\/\/blog.dbohs.com\/?p=647#articleImage","url":"https:\/\/secure.gravatar.com\/avatar\/dbaa9fe1c0960938d10f73a45ec32fd7403e987878d09a42c397c59a61da66f2?s=96&d=mm&r=g","width":96,"height":96,"caption":"admin"},"datePublished":"2010-09-28T08:44:50+10:00","dateModified":"2024-10-11T15:48:17+10:00","inLanguage":"en-US","mainEntityOfPage":{"@id":"https:\/\/blog.dbohs.com\/?p=647#webpage"},"isPartOf":{"@id":"https:\/\/blog.dbohs.com\/?p=647#webpage"},"articleSection":"Uncategorized, fun, VBA"},{"@type":"BreadcrumbList","@id":"https:\/\/blog.dbohs.com\/?p=647#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"https:\/\/blog.dbohs.com#listItem","position":1,"name":"Home","item":"https:\/\/blog.dbohs.com","nextItem":{"@type":"ListItem","@id":"https:\/\/blog.dbohs.com\/?cat=1#listItem","name":"Uncategorized"}},{"@type":"ListItem","@id":"https:\/\/blog.dbohs.com\/?cat=1#listItem","position":2,"name":"Uncategorized","item":"https:\/\/blog.dbohs.com\/?cat=1","nextItem":{"@type":"ListItem","@id":"https:\/\/blog.dbohs.com\/?p=647#listItem","name":"Fun with Excel"},"previousItem":{"@type":"ListItem","@id":"https:\/\/blog.dbohs.com#listItem","name":"Home"}},{"@type":"ListItem","@id":"https:\/\/blog.dbohs.com\/?p=647#listItem","position":3,"name":"Fun with Excel","previousItem":{"@type":"ListItem","@id":"https:\/\/blog.dbohs.com\/?cat=1#listItem","name":"Uncategorized"}}]},{"@type":"Person","@id":"https:\/\/blog.dbohs.com\/#person","name":"David Bromwich","image":{"@type":"ImageObject","@id":"https:\/\/blog.dbohs.com\/?p=647#personImage","url":"https:\/\/secure.gravatar.com\/avatar\/b95a4b8562be54c8b766757dc9e19aaf5bd9c83ce051490cda1caf3077fc8e68?s=96&d=mm&r=g","width":96,"height":96,"caption":"David Bromwich"}},{"@type":"Person","@id":"https:\/\/blog.dbohs.com\/?author=3#author","url":"https:\/\/blog.dbohs.com\/?author=3","name":"admin","image":{"@type":"ImageObject","@id":"https:\/\/blog.dbohs.com\/?p=647#authorImage","url":"https:\/\/secure.gravatar.com\/avatar\/dbaa9fe1c0960938d10f73a45ec32fd7403e987878d09a42c397c59a61da66f2?s=96&d=mm&r=g","width":96,"height":96,"caption":"admin"}},{"@type":"WebPage","@id":"https:\/\/blog.dbohs.com\/?p=647#webpage","url":"https:\/\/blog.dbohs.com\/?p=647","name":"Fun with Excel | Wild and Woolly","description":"I have used spreadsheets since Software Arts' Visicalc was available on an Apple II, but I really like digging under the bonnet to increase the power of Excel. Its even possible to use some 1500 extra functions hidden in the Windows operating system. I spent endless hours with my PhD creating diffusion models using Excel. I","inLanguage":"en-US","isPartOf":{"@id":"https:\/\/blog.dbohs.com\/#website"},"breadcrumb":{"@id":"https:\/\/blog.dbohs.com\/?p=647#breadcrumblist"},"author":{"@id":"https:\/\/blog.dbohs.com\/?author=3#author"},"creator":{"@id":"https:\/\/blog.dbohs.com\/?author=3#author"},"datePublished":"2010-09-28T08:44:50+10:00","dateModified":"2024-10-11T15:48:17+10:00"},{"@type":"WebSite","@id":"https:\/\/blog.dbohs.com\/#website","url":"https:\/\/blog.dbohs.com\/","name":"Wild and Woolly","description":"Occupational Hygiene - and Ideas","inLanguage":"en-US","publisher":{"@id":"https:\/\/blog.dbohs.com\/#person"}}]},"og:locale":"en_US","og:site_name":"Wild and Woolly | Occupational Hygiene - and Ideas","og:type":"article","og:title":"Fun with Excel | Wild and Woolly","og:description":"I have used spreadsheets since Software Arts' Visicalc was available on an Apple II, but I really like digging under the bonnet to increase the power of Excel. Its even possible to use some 1500 extra functions hidden in the Windows operating system. I spent endless hours with my PhD creating diffusion models using Excel. I","og:url":"https:\/\/blog.dbohs.com\/?p=647","og:image":"https:\/\/blog.dbohs.com\/wordpress\/wp-content\/uploads\/Wild-and-Woolley.png","og:image:secure_url":"https:\/\/blog.dbohs.com\/wordpress\/wp-content\/uploads\/Wild-and-Woolley.png","article:published_time":"2010-09-27T22:44:50+00:00","article:modified_time":"2024-10-11T05:48:17+00:00","twitter:card":"summary","twitter:title":"Fun with Excel | Wild and Woolly","twitter:description":"I have used spreadsheets since Software Arts' Visicalc was available on an Apple II, but I really like digging under the bonnet to increase the power of Excel. Its even possible to use some 1500 extra functions hidden in the Windows operating system. I spent endless hours with my PhD creating diffusion models using Excel. I","twitter:image":"https:\/\/blog.dbohs.com\/wordpress\/wp-content\/uploads\/Wild-and-Woolley.png"},"aioseo_meta_data":{"post_id":"647","title":null,"description":null,"keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"Article","isEnabled":true},"graphs":[]},"schema_type":null,"schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"breadcrumb_settings":null,"limit_modified_date":false,"ai":null,"created":"2021-02-26 00:16:45","updated":"2026-01-17 15:38:33","seo_analyzer_scan_date":null},"aioseo_breadcrumb":"<div class=\"aioseo-breadcrumbs\"><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/blog.dbohs.com\" title=\"Home\">Home<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/blog.dbohs.com\/?cat=1\" title=\"Uncategorized\">Uncategorized<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\tFun with Excel\n\t\t<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"Home","link":"https:\/\/blog.dbohs.com"},{"label":"Uncategorized","link":"https:\/\/blog.dbohs.com\/?cat=1"},{"label":"Fun with Excel","link":"https:\/\/blog.dbohs.com\/?p=647"}],"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/blog.dbohs.com\/index.php?rest_route=\/wp\/v2\/posts\/647","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.dbohs.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.dbohs.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.dbohs.com\/index.php?rest_route=\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.dbohs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=647"}],"version-history":[{"count":8,"href":"https:\/\/blog.dbohs.com\/index.php?rest_route=\/wp\/v2\/posts\/647\/revisions"}],"predecessor-version":[{"id":1751,"href":"https:\/\/blog.dbohs.com\/index.php?rest_route=\/wp\/v2\/posts\/647\/revisions\/1751"}],"wp:attachment":[{"href":"https:\/\/blog.dbohs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=647"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.dbohs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=647"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.dbohs.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=647"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}