{"id":1601,"date":"2018-07-13T14:10:11","date_gmt":"2018-07-13T14:10:11","guid":{"rendered":"http:\/\/heavybid.ewksol.com\/?p=1601"},"modified":"2020-10-16T15:33:13","modified_gmt":"2020-10-16T15:33:13","slug":"export-all-quote-folders-to-one-excel-spreadsheet","status":"publish","type":"post","link":"https:\/\/heavybid.ewksol.com\/index.php\/2018\/07\/13\/export-all-quote-folders-to-one-excel-spreadsheet\/","title":{"rendered":"Export All Quote Folders to One Excel Spreadsheet"},"content":{"rendered":"

You get done with an estimate and want to export all the quote folders with vendors\/sub quotes to one Excel spreadsheet. Maybe it is for the job handoff or for a bid review. Before you export a setting has to be adjusted first in Excel. In Excel open up the default blank worksheet and go to Options>General and change the number of sheets (tabs) that will exist when Excel is open. Now if you want to export out 50 quote folders then the default will have to have that many sheets.<\/p>\n

\"\"<\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

Now in HeavyBid in Report>Analysis Report select all the folders that are desired to export to one Excel spreadsheet and select Export. See below.<\/p>\n

\"\"<\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

All the folders will exist in one spreadsheet with multiple tabs. I also suggest if you are using this for a job handoff document that the Vendor List also be printed or export to a PDF. [thanks to Aaron Allhouse-HCSS Tech Support Superman for this information]<\/p>\n

\"\"<\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

You get done with an estimate and want to export all the quote folders with vendors\/sub quotes to one Excel spreadsheet. Maybe it is for the job handoff or for a bid review. Before you export a setting has to be adjusted first in Excel….<\/p>\n","protected":false},"author":1,"featured_media":1608,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[18,1],"tags":[],"class_list":["post-1601","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-try-new-things","category-uncategorized"],"brizy_media":[],"_links":{"self":[{"href":"https:\/\/heavybid.ewksol.com\/index.php\/wp-json\/wp\/v2\/posts\/1601","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=1601"}],"version-history":[{"count":6,"href":"https:\/\/heavybid.ewksol.com\/index.php\/wp-json\/wp\/v2\/posts\/1601\/revisions"}],"predecessor-version":[{"id":1610,"href":"https:\/\/heavybid.ewksol.com\/index.php\/wp-json\/wp\/v2\/posts\/1601\/revisions\/1610"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/heavybid.ewksol.com\/index.php\/wp-json\/wp\/v2\/media\/1608"}],"wp:attachment":[{"href":"https:\/\/heavybid.ewksol.com\/index.php\/wp-json\/wp\/v2\/media?parent=1601"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/heavybid.ewksol.com\/index.php\/wp-json\/wp\/v2\/categories?post=1601"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/heavybid.ewksol.com\/index.php\/wp-json\/wp\/v2\/tags?post=1601"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}