{"id":1180,"date":"2017-10-12T11:31:19","date_gmt":"2017-10-12T11:31:19","guid":{"rendered":"http:\/\/heavybid.ewksol.com\/?p=1180"},"modified":"2020-10-16T15:34:50","modified_gmt":"2020-10-16T15:34:50","slug":"quick-biditem-spreadsheet-on-the-fly","status":"publish","type":"post","link":"https:\/\/heavybid.ewksol.com\/index.php\/2017\/10\/12\/quick-biditem-spreadsheet-on-the-fly\/","title":{"rendered":"Quick Biditem Spreadsheet On the Fly"},"content":{"rendered":"<p>I was working on an estimate and had this need for a spreadsheet for the biditem. I won&#8217;t need it again as it just a one-off spreadsheet. Now you can create a spreadsheet using the internal spreadsheet for an activity but I needed it for a biditem. So I went to Setup&gt;Spreadsheet Calcs and Assemblies and created a spreadsheet and saved it as &#8220;Spreadsheet&#8221;. I also check the box &#8220;Assembly&#8221;. Now I am not going to attach any activities but when I check the box it lets me bring the spreadsheet as opposed at only the activity level. Here are the steps to do this.<\/p>\n<p>Step 1 &#8211; Create the Spreadsheet. I called mine &#8220;Spreadsheet&#8221;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-1183\" src=\"http:\/\/heavybid.ewksol.com\/wp-content\/uploads\/2017\/10\/image3-1024x754.jpg\" alt=\"\" width=\"840\" height=\"619\" srcset=\"https:\/\/heavybid.ewksol.com\/wp-content\/uploads\/2017\/10\/image3-1024x754.jpg 1024w, https:\/\/heavybid.ewksol.com\/wp-content\/uploads\/2017\/10\/image3-300x221.jpg 300w, https:\/\/heavybid.ewksol.com\/wp-content\/uploads\/2017\/10\/image3-768x565.jpg 768w, https:\/\/heavybid.ewksol.com\/wp-content\/uploads\/2017\/10\/image3.jpg 1171w\" sizes=\"auto, (max-width: 840px) 100vw, 840px\" \/><\/p>\n<p>Step 2 &#8211; Now it is ready to pull into any biditem and be linked to Activites\/Resources<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-1184\" src=\"http:\/\/heavybid.ewksol.com\/wp-content\/uploads\/2017\/10\/image4-1024x642.jpg\" alt=\"\" width=\"840\" height=\"527\" srcset=\"https:\/\/heavybid.ewksol.com\/wp-content\/uploads\/2017\/10\/image4-1024x642.jpg 1024w, https:\/\/heavybid.ewksol.com\/wp-content\/uploads\/2017\/10\/image4-300x188.jpg 300w, https:\/\/heavybid.ewksol.com\/wp-content\/uploads\/2017\/10\/image4-768x481.jpg 768w, https:\/\/heavybid.ewksol.com\/wp-content\/uploads\/2017\/10\/image4.jpg 1200w\" sizes=\"auto, (max-width: 840px) 100vw, 840px\" \/><\/p>\n<p>Step 3 &#8211; Create notes or a spreadsheet calculation and map cells. What is awesome is that any activity that is already in the biditem will display in the Assembly.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-1185\" src=\"http:\/\/heavybid.ewksol.com\/wp-content\/uploads\/2017\/10\/image5-1024x787.jpg\" alt=\"\" width=\"840\" height=\"646\" srcset=\"https:\/\/heavybid.ewksol.com\/wp-content\/uploads\/2017\/10\/image5-1024x787.jpg 1024w, https:\/\/heavybid.ewksol.com\/wp-content\/uploads\/2017\/10\/image5-300x231.jpg 300w, https:\/\/heavybid.ewksol.com\/wp-content\/uploads\/2017\/10\/image5-768x590.jpg 768w, https:\/\/heavybid.ewksol.com\/wp-content\/uploads\/2017\/10\/image5.jpg 1171w\" sizes=\"auto, (max-width: 840px) 100vw, 840px\" \/><\/p>\n<p>Setups like this while simple can provide an estimating team significant productivity benefits. Give it a try.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I was working on an estimate and had this need for a spreadsheet for the biditem. I won&#8217;t need it again as it just a one-off spreadsheet. Now you can create a spreadsheet using the internal spreadsheet for an activity but I needed it for&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[33,12,1],"tags":[],"class_list":["post-1180","post","type-post","status-publish","format-standard","hentry","category-internal-spreadsheet","category-productivity","category-uncategorized"],"brizy_media":[],"_links":{"self":[{"href":"https:\/\/heavybid.ewksol.com\/index.php\/wp-json\/wp\/v2\/posts\/1180","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=1180"}],"version-history":[{"count":4,"href":"https:\/\/heavybid.ewksol.com\/index.php\/wp-json\/wp\/v2\/posts\/1180\/revisions"}],"predecessor-version":[{"id":1188,"href":"https:\/\/heavybid.ewksol.com\/index.php\/wp-json\/wp\/v2\/posts\/1180\/revisions\/1188"}],"wp:attachment":[{"href":"https:\/\/heavybid.ewksol.com\/index.php\/wp-json\/wp\/v2\/media?parent=1180"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/heavybid.ewksol.com\/index.php\/wp-json\/wp\/v2\/categories?post=1180"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/heavybid.ewksol.com\/index.php\/wp-json\/wp\/v2\/tags?post=1180"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}