Build Elaborate Repetitive Structures with Assemblies

HeavyBid will allow you to quickly build elaborate structures in your estimate using our spreadsheet assemblies routine. Let's take a look at this pier concrete footing. If I go into our spreadsheet assemblies, you can see that I've used one here. Here you can see the spreadsheet in the top section. You'll notice that there's a mappable area. This is the area that HeavyBid will bring back into the notes of the estimate. All of the colored cells you can see are linked to activities that will be brought into the estimate, and resources as well. You can see that this spreadsheet has multiple tabs. So you can do a pretty complicated spreadsheet. And if you're currently using your own, you can import those as well to set this up. I can then link as many activities as I want to this from my activity code book. And then I can go about mapping cells to bring these calculations into the quantity fields or the production fields. And again, the same goes for the resource area. So if I take a look at this fab form unclassified, you can see I've got the square footage mapped out from one of the cells above, as well as the production rate for the crew. In the bottom area, there are several resources that could possibly be used. I only have to check off the ones that I care to use in this particular estimate. So if I close out of there, and we take a look at our notes, here is all the information from that spreadsheet built into a simple note form so that when you're reviewing the estimate or putting out cost reports, that is easy to get to. I can also get to the spreadsheet assembly quickly from the notes area. So let's take a look at how you actually use this in an estimate from scratch. You'll notice that was a pretty elaborate one, but if I jump into my storm drain here, then go back to my spreadsheet, I'm gonna pull in this install RCP complete for the storm drain. Let's say we're working with 36-inch storm drain. So I come in, go a foot and a half to the bottom of the pipe. We'll say we'll go halfway up, so we'll go three feet and three feet to the top of the trench. The pipe is a 36-inch pipe. I can leave this at zero because it's a circular pipe. Trench width, we'll go six feet wide. Depth, as I said, we're six feet down on that. Flair width, we'll say, we'll go out to 10 feet. Flair depth, we'll go two feet on the flair. And for the trench length, we're gonna go out 560 feet. Well, now I can scroll down a little bit here and take a look. So, we're gonna have 90% usable on our compactions. Our material we're using is 1.5 tons to a cubic yard. And as I'm typing this in, it's calculating out these results. The results are linked to activities in the bottom section here. And in this case, I'm gonna want to haul the excess away. I'm gonna do excavation and install bedding. And then you'll notice I could use this on several different sets of height, in this case, 36-inch. As I'm checking this, it's also checking the resources in the bottom. If I didn't need a resource, I would simply just uncheck that resource. Then it would not bring it in. Once I close this window, it's going to start calculating activities and building information out, or a structure in my estimate. So now if I expand this, and we take a look at that furnish and install, you'll notice it calculated out my quantities and pulled in the crew. If a change came up, maybe a linear foot changed, et cetera, all I would have to do to get back to there is click this note field. And you can see, here's everything coming from my calculation routine that we filled out. I can click on the routine, and it will quickly go back and open that up for me. Let's say we went out, did a new take off, and we actually have a run of 650 feet. As soon as I enter that, the numbers in my calculations change. Now I'm up to 650 feet of pipe length. So I'm gonna save that off and close out. Now it's gonna ask to update my activities. Yes, I'm gonna update that. When I do that, you'll notice my notes have been updated as well. I am now at a trench length of 650 and a pipe length of 650 linear feet. HeavyBid is the only estimating system out that will update your notes while using one of these styles of routines. If I close out of my notes here, and we're in that same RCP item, you'll notice that it's changed my quantity of 650, as well as set my quantities up. Easily HeavyBid can use your existing spreadsheets. You can pull those in. Or you can build out your own assembly here as we've done.