{"id":620,"date":"2015-08-28T06:26:56","date_gmt":"2015-08-28T11:26:56","guid":{"rendered":"http:\/\/arthurnix.meicivil.net\/?p=620"},"modified":"2020-10-16T15:38:26","modified_gmt":"2020-10-16T15:38:26","slug":"clean-up-spreadsheet-calculations","status":"publish","type":"post","link":"https:\/\/heavybid.ewksol.com\/index.php\/2015\/08\/28\/clean-up-spreadsheet-calculations\/","title":{"rendered":"Clean up Spreadsheet Calculations"},"content":{"rendered":"<p>If you are a regular reader of my blogs you know I like the internal spreadsheet (SpreadSheet Gear) in HeavyBid. But honestly there are a lot of spreadsheets in the list that you will never use such as all the Metric ones (unless you are in Canada). I suggest deleting the spreadsheets that will never get used so that it will encourage users in your company to utilize the internal spreadsheets since the listing will be a easier to navigate. And it will prevent someone using the metric spreadsheets also unintentionally. The spreadsheets are in the directory X:\/HEAVYBID\/HCSS\/CALCTEMPLETES\/STANDARD where X is your HeavyBid directory. If you want you can copy the directory to another location in case you want to use a deleted spreadsheet later. Now delete all the metric based spreadsheets and take a hard look at the remaining ones. Trust me you will never use the &#8220;Liquid Application&#8221; spreadsheet.\u00a0I would guess you can delete at least half of the\u00a0remaining\u00a0spreadsheets once you review them. Now the list will be much smaller and not so confusing. \u00a0Here is my list.<\/p>\n<p><a href=\"http:\/\/arthurnix.meicivil.net\/wp-content\/uploads\/2015\/08\/Spreadsheet.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-622\" src=\"http:\/\/arthurnix.meicivil.net\/wp-content\/uploads\/2015\/08\/Spreadsheet.jpg\" alt=\"Spreadsheet\" width=\"799\" height=\"647\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>If you are a regular reader of my blogs you know I like the internal spreadsheet (SpreadSheet Gear) in HeavyBid. But honestly there are a lot of spreadsheets in the list that you will never use such as all the Metric ones (unless you are&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5,12,19,1],"tags":[],"class_list":["post-620","post","type-post","status-publish","format-standard","hentry","category-expert-series","category-productivity","category-tuneup-heavybid","category-uncategorized"],"brizy_media":[],"_links":{"self":[{"href":"https:\/\/heavybid.ewksol.com\/index.php\/wp-json\/wp\/v2\/posts\/620","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/heavybid.ewksol.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/heavybid.ewksol.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/heavybid.ewksol.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/heavybid.ewksol.com\/index.php\/wp-json\/wp\/v2\/comments?post=620"}],"version-history":[{"count":1,"href":"https:\/\/heavybid.ewksol.com\/index.php\/wp-json\/wp\/v2\/posts\/620\/revisions"}],"predecessor-version":[{"id":3105,"href":"https:\/\/heavybid.ewksol.com\/index.php\/wp-json\/wp\/v2\/posts\/620\/revisions\/3105"}],"wp:attachment":[{"href":"https:\/\/heavybid.ewksol.com\/index.php\/wp-json\/wp\/v2\/media?parent=620"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/heavybid.ewksol.com\/index.php\/wp-json\/wp\/v2\/categories?post=620"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/heavybid.ewksol.com\/index.php\/wp-json\/wp\/v2\/tags?post=620"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}