Estimating Monthly Webinar August 2024

Well, hi, everyone. Thank you all for joining us for our monthly heavy bid webinar. We have a lot to share with you today on new product releases, and improvements. But before we do that, I thought we should start with a few introductions. So I'll start with myself. My name is Melissa Teague. I just joined the HCSS team as a product marketing manager over, heavy bed in preconstruction. And so, what I do, part of my job is to really understand, you know, our customers, really know your day to day, your pain points, and how our products help you. And so with that, I'm going to sprinkle in a few poll questions. We're asking, you know, a few more things where we can get to know you. And, so if you don't mind answering those, that would be great. And then I'll flip it over to Aaron for his his introduction. Alright. For those of you, that have been been to any of these webinars before, you know me already. My name is Aaron Alshouse. I'm the technical product manager, for HeavyBid. For those of you that have not been here before, welcome welcome to the to the party. Love it. And so our agenda for today, we as you can see, we have a lot to talk about. The most important one, of course, is we have an improved, takeoffs integration. And and then we will, talk about preparations to sunset, the classic export to accounting screen. We're gonna talk about improved import quote prices, update to word bid proposal, estimate history sync automation, and speed improvements for SQL. And as a reminder, feel free to drop any questions in the chat box, and we'll get to those, as we're going through everything. So I will pass it off to Aaron. Alrighty. So we should be off to the races here. Melissa, can y'all see the slide for takeoff integration? See. I see the slide. Mhmm. Okay. Perfect. So first thing we're gonna take a look at here is takeoff integration improvement. So one of the things that we've had in heavy bid for several years now is takeoff integration. I say that term fairly loosely because it was not a a very user friendly module that we had beforehand, and we noticed, many, many users wanting to have a better integration with their takeoff solution, whether that's AgTech, whether that's Bluebeam, whether it's, you know, whatever whatever it is that you're using. So we went back to the drawing board and essentially rewrote the takeoff integration from scratch. What I'm gonna do now is I'm gonna jump over into precon where everything starts. So the reason I say everything starts in precon is because precon is going to be the one stop solution for reviewing a project from start to end. It's where you manage your perspective work. It's where you can run analytics on any in progress estimates or any past estimates. You can run comparisons. It's also where you can review the details of any in progress, projects. Would that be Sorry, Erin. So I can't see your screen. I don't know if it's just me. Let's see. I see the takeoffs integration slide still. See if I stop sharing my screen. Okay. I just gotta Paul. He can see the pre con screen. So Okay. So within the within the project details, we have a new model to the to the right that's basically for takeoffs. Now this is essentially where we're going to import our takeoff file from whatever our takeoff solution is. How that's going to talk back to the estimate in heavy bid is as we scroll down a little bit, and this, these details might look different depending on how you have precon set up, but you have to have a linked estimate. Now whether or not you create the estimate from precon or you link it after the fact does not matter. It doesn't need to start with a with a precon project as long as that estimate is eventually linked to a project that has that takeoff file. Now to import the takeoff, we're just simply gonna click the button that says import takeoffs. It's gonna bring up a a new model that has a drop down on the top left. The first one is AgTech AgTech structure summary. We partnered up with AgTech. This actually came out of a conversation at ConExpo, in twenty twenty three, where we basically are working with them. They put they put together a prebuilt, structure summary export out of AgTech that we then took and built an import template specifically to accommodate that. However, for those of you that are not using AgTech, we also have the For the sake of demonstration, I'm going to select AgTech. And to bring it in, I can either click and drag the file, or I can click within the file import box, go and find my import file, click okay. For whatever reason, my computer, takes just a second to process that. So we're gonna see that, and you'll see my selected file is my structure summary. If for whatever reason that takeoff sheet has more than one or that takeoff file has more than one sheet, I can click the drop down under the sheet selector and select which, which sheet I wanna read. As far as I'm aware, there is no limit to the number of sheets. Once you show once you load up the file, what we're gonna do is we're gonna show you a preview. So you can actually get a, a look at what the import's going to look like before you actually commit the import. So we can see our import numbers, our phases, our structures, our materials, any labels that we might have, quantities, units, and any structure or material codes we might have for this particular import. We can review that, and, basically, if there's anything that's wrong, we can go back and adjust the file before we actually bring it in. Now in this case, I'm gonna go ahead and I'm going to click import. Now I'm gonna get a little message that says, this will overwrite any existing takeoff files in this project. Since I do not have any existing takeoff files, I'm gonna click import anyway, and I'm not gonna worry about it. And then I get a little summary of my import. In this case, I brought in nine takeoff lines. I didn't update or remove anything because I didn't have anything to update or remove. Now just to the right of that, I have my takeoff information, and you're gonna see everything showing up right here. You're gonna see a column to the left, and it shows linked. It's gonna be blank right out of the gate, and you're gonna see why that's important, here shortly. But in order for that information to show up in HeavyBid, all I need to do is click the save button under my project detail. I'll get my webinar demo saves message in the top right, and now I have the ability to jump back down into HeavyBid. Now for anyone who has used the import, import from takeoffs in the past, it was under the exchange menu, buried under the more, and you'll see now it's gone. We no longer have that takeoff, that takeoff under the exchange menu. We've actually brought it under the estimate menu, and we've replaced an older takeoff solution from merge takeoffs to link to take off. This is what's actually going to go up and grab that takeoff information. So once I bring that information or once I click that button, HeavyBid's gonna make a call to Precon, grab that takeoff information, and display it here for you. So the takeoff information on the left hand side of the screen is gonna be representative of what you brought in. So using the AgTech, template, this is what you're going to see. However, if you're using the customized view or the customized template, you're gonna see what is brought in based on your custom settings. Now once we have the takeoff information, on the left hand side, we can now begin to link or create items for our bid. So on the right hand side of the screen, you're gonna see an estimate preview. This is what your estimate currently looks like. Now I can go ahead. I can, collapse all my views to only show my bid out of information. I can expand it all to show all of my activities and any of my materials that I have, along along with it. But now I can go through, and I can select any item in my takeoff that I want. And to link it to an an existing item, all I need to do is come over here and let's see. Do I have anything? Here we go. We'll do we'll do the excavation column. We're gonna select and link to this activity right here. All I gotta do is click the checkbox. You'll see here on the left hand side, the bid item and the activity automatically prefill. The resource did not prefill because I did not select, to link anything at the resource level. You'll also see on the right hand side of the screen, my quantity and my unit is automatically updated with the takeoff quantity from my takeoff file. However, the change has not been applied to the estimate itself. To do that, I need to save my changes or save to estimate once I'm done. Now in the top right, I get a link to takeoffs or a link takeoffs modal with those same links. Why do I have it in two different places? Well, I have it in two different places because I can link that same takeoff file to more than one line in my estimate. So if I have it linked to more than one line, I can now go into my link takeoffs, see every instance of that linking for that one particular item. And on the left hand side, I'll see a multi across the bid item activity and resource, letting me know that that item is linked to more than one line in heavy bid. And I can rinse and repeat that process for as many items as I deem appropriate. Now one of the big, things that we got when we were looking at building this was customers want the ability to create items from their takeoff. How do you do that? Well, I can do that in several different ways. One easy way to do that is I can go into a line here and simply just give it a new bid item code. And if that bid item code does not exist, I get an add bid item. It's gonna bring up and it's gonna ask me what I wanna do for that. So I can change the description. I can adjust quantities and units if I choose to. I can also apply a client number. So in this case, I'm gonna click okay. You'll see on the bottom that bid item nine nine nine is now created. And now I can go in and I can create a new activity, or I can leave it linked to the bid item. If I want to link it to the activity, I can go in and I can prefill any activity code that I want, or I can click the activity header and pull straight from my code book. So we all run into the instance where we have a lot of codes in our activity code book. It's not always easy to remember exactly what those codes are. However, I can go in and I can select exactly what item I wanna bring in. It's gonna ask me for the description, quantity, and unit. And now if that activity in my code book has crews, productions, non crew resources, all of those items get brought along as well. If there's any materials with that item, it's gonna show underneath in the tree as well. If I want to, I can also apply any resources, and those resources, those resources will pull straight from my material codebook. Now, in that case in this case, it it showed me a message that that link is already created. I need to create a new link because I went over and actually clicked the drop down, so I exited out of that row. But, basically, when I'm in one row, I can add a bid item activity or resource basically to whatever level of detail that I want, and HeavyBid is going to update the link to that level of detail until I leave that line. Now I can go through and repeat this process again as many times as I want. So I can go in as we saw, I can go in and I can click a checkbox and link to whichever items that I want. You'll see here if I scroll up, those links show in the checkbox. I can also go ahead and select, anything that I hand keyed in. In this case, I went ahead and selected my bid item. I went ahead and, hand keyed it in. But if I wanted to, I can also come in and select from the header any of my bid items that are currently in my estimate. I can also go in and select the header for the activity codebook or select the header for the material codebook, so you get very granular on what items you wanna bring in. I can also go in and hand key those items in and create something on the fly if I choose to. So, again, if I wanted to, I could come in here. Let's go two zero one two zero two. And then I can select the resource header and bring in whatever I want from from my codebook. And in this case, it's gonna pull straight from, from my material codebook. Right. Once I have made whatever changes I want here to commit those changes to my estimate, all I need to do is click the save to estimate button, and I'm gonna get a message. Do I wanna update the resource quantities utilizing the new activity quantities? So if I map or if I link takeoffs to a bid item or an activity and I'm adjusting those quantities, HeavyBid is going to ask me, do I want to update the resource quantities to reflect that new quantity from my takeoff? In this case, I'm gonna click yes to all, and my tree view will now rebuild or my preview will now rebuild based on the changes that I just made. To exit the screen, we simply click close. And now what I can do is I can jump back to precon, and you'll see I didn't have to sync anything. I didn't have to click any additional buttons. Once I click that save, HeavyBid's going to send the linked information back up to precon so that whoever's reviewing information in precon can see what items are linked, where they're linked to in an estimate, as well as any items that aren't linked, maybe check and see why they're not linked. So all I need to do is see the blue bar under the linked in the checkbox. I can hover over that, and I'll see exactly which bid item activities and resources that particular line, are linked to. Now one thing that always comes up with with takeoffs well, take a step back. Something that does come up, maybe not always, but something that does come up are addendums or change orders. How do we accommodate that? So within the takeoff model and precon, on the top right of that modal, you get a little three dot button. I can click that check I can click that button, and I can click import takeoffs. At this stage, it's following the exact same process that we did beforehand. So I'm gonna go I'm gonna find my new file. In this case, for the sake of demonstration, I'm just gonna use the existing file. Precom's gonna load it up for me. It's gonna show me my preview, but also below that, I get some validation warnings. Basically, precon's gonna tell me whether this row already exists. If it already exists, it's gonna ask me a question. What do I wanna do with it? I essentially get a couple options here. Do I want to overwrite my existing row? Do I wanna import as a new takeoff line, which basically means that I'll have two, two identical takeoff lines, or do I want to import as a new takeoff line and remove the, duplicate entry. So, basically, for whatever reason, if I have the same line that matches a previous line, but I know it's different, I can select to remove the duplicate, remove the old entry, and now I just have that new line that I can now go back and map, or create items off of. I can go ahead and basically rinse and repeat that process for however many duplicate entries that I have. And once I'm done, I click import and have and Precon is going to update my takeoff file. And, again, I can then jump back into HeavyBid and see those changes. Any questions on, on the new takeoffs integration? The idea here was to make it much more user friendly, much more customizable. Beforehand, you did not have the ability to actually see what you were importing prior to importing it. You had to basically make sure that you had the format correct. Now you can basically take exactly what's coming straight out of the takeoff solution and bring it in however it's set up. You can also create items now in the takeoff versus just simply linking to existing items. So we we spent a lot of time. We put a lot of effort into making sure that this was something that you were going to get use out of. Alright. I'm not seeing any questions, so we're gonna go ahead and we're gonna jump to the next item on the list here. And next thing we're gonna do is we're gonna we're gonna go ahead and we're gonna ask a poll here. So, Melissa, if you do me a favor and pull up the poll for our users here. The question that we're asking is what takeoff software do you currently use? I have my own preconceived notions about what we might see, but I'm curious to see if those notions are correct or if I am just way off base. There's two in the lead, and they keep they keep fluctuating. Alright. We'll wait a few more seconds. Okay. Alright. So it looks like it's a a fairly healthy mix between Excel, AgTech, Bluebeam, and frankly, other as well. I'm curious, just from my own knowledge, for anyone who put other, if you wouldn't mind, posting it either in the chat or the question, what is that other, other solution? Yeah. I see one for PlanSwift, Trimble. Okay. So Lance with and Trimble and then, a little bit of everything else along along as well. Okay. And I definitely see on screen on there as well. Awesome. Alright. Going ahead and moving along here. We're gonna jump to our next item on the list here, and that is sunsetting the classic ETA. So for anyone who who essentially was not at UGM this year where where we made the initial announcement, in heavy bid twenty twenty four dot one, if you are still using the export to a heavy job and accounting classic screen, when you launch that screen, you're now gonna get presented with a with a message down at the bottom of the screen in red text that says, export to heavy job and accounting classic. We discontinued in heavy bid twenty twenty six. Please contact support at one eight five five two three one seven eight seven six to be migrated. So I wanted to take a minute and talk about this. There really isn't anything to demo in this particular instance. It's more of a discussion point. So for anyone who has used HeavyBid over the years, we have run concurrently now for at least the last six years to export to accounting systems. What you might know as the export to accounting classic and the new export to accounting, just the export to heavy job in accounting. Well, over the last several years, we have made many, many strides in making the new export to accounting more configurable, more customizable, and, does not require development or customizations in order to make those tweaks that you might need for your accounting integration. All of those things are things that we do not have the same functionality for in the classic. So we've made the conscious decision to go ahead and sunset that classic export to accounting screen beginning when we launch heavy bid twenty twenty six in calendar year twenty twenty six. We're giving everybody the two solid years in order to make sure that they can get, they can get in contact with support and get migrated over to the new export to accounting if they haven't already. For those of you that might have paid for a custom export to accounting in the classic, you might be asking yourself, am I gonna need to to pay again for that new integration? The answer to that is no. So if you've already done your customizations in the classic, we're gonna work with you to re basically, rinse and repeat those new customizations in the new export to accounting and make sure that you can use the new export to accounting to do exactly what you did prior in the classic. Any questions on sunsetting the export to accounting? Alright. I'm not seeing anything show up here. Let's see here. Let's see. Bear with me. It looks like someone has told me that I might have something. So I went ahead and closed it. Is everybody else seeing something at the bottom of my screen? Because I'm not seeing that on my particular monitor. Okay. Alright. Well, I I apologize about that. I'm not seeing, seeing exactly what it is. I I see the messages, but I'm not seeing it on my particular screen. So if it does cover up something important, please just post it in the chat, and I'll I'll make sure to adjust my screen so that everybody can see it. And then, Hal, I see you raised your hand. Do you wanna go ahead and, let me know what it is, that you raised your hand about? Oh, no worries at all. Alright. So the next thing we're gonna chat about is, improvements to the import quote prices screen. So for anyone that did not know, and I can't say I blame you, we have an import quote prices, function in HeavyBid, but over the last several years, it's it's been buried in the program. And what I mean by that is it's always been under the quote tree. So if we go into subsystems and heavy bid and go to quotes, beforehand, what you'd have to do is you'd have to go into the quote tree. And then down at the bottom of the screen, you'd have to click import quote prices. Now that's fine if what you use is mostly the the quote tree. However, the vast majority of our user base uses the quote summary screen. So it was it was not ideal by any stretch to force the users to have to go into another screen just to be able to access that import. So what we've done is we've taken that import, and we've actually put it in a lot, in a in a couple other locations. One being straight from the quote summary menu, I can click on folder options from any of my folders and click on import quote prices. This is going to allow me to access that import, straight from the quote summary, and it's gonna target the folder that I want it to go to. So within the import quote prices, I'm gonna browse to my file here, and we've made a couple changes, here as well. So the first change we've made is we fixed this, this screen over here. Beforehand, it just showed up as a as a white background where you couldn't actually see anything. So we've actually been able to open it up and show you what the column headers represent in your in your quote file. So now when you're actually mapping your fields, you know what it is you're mapping to without having to have the the Excel file off on another monitor or off in the corner of the monitor. We've also gone ahead and removed the requirement for the item number and sequence number. The item number and sequence number, were essentially used in a in a bygone era, and they're no longer relevant for for most users. So we've removed the requirements. The only thing you need now are the description, quantity, unit, and unit price. So we're gonna go ahead and we're gonna map those out. And I'm just gonna say I wanna bring in the first fifteen rows here. We're gonna click import. Now once we do that, the first thing it's gonna ask me or let me take one step back. The next change that we made was we had a function, or within the the import quote prices screen. We did not have the ability to actually see the unit price. You couldn't see what the quoted price was on the import. So we looked at that, and we're like, that makes zero sense whatsoever. So we've we brought it back. You can now see the import quote prices, and you can basically map everything that you need and or see all the information you need that's relevant to be able to update the unit price from your from your Excel sheet properly. So now I can go in. I can find whatever it is I need, highlight what I wanna bring it into, and then map it. If for whatever reason, the unit of measure is different, I'm gonna get a a little message here. It's gonna ask me if I wanna bring it in even though the unit is is different. And I'm gonna go ahead, and I'm gonna copy the item anyway even if the unit and the quantity are not exactly identical. So HeavyBid's gonna check. It's gonna see that those things are different, and it's gonna basically ask, are you sure you wanna do this? If that's the case, you can go ahead and click yes and continue your import. And once you've made your once you've made your adjustments, you've brought the items in that you wanna bring in, you can go ahead and you can finish your import. And now when I go to my quote sheet, I see my new quoted price. Now we haven't done anything anything earth earth shattering with the import quote prices. We've just simply tried to make it more user friendly for y'all so that when you do wanna import an Excel sheet from your supplier, it's a it's a much more simplistic process. Now when I said we added it to a couple other places, not only can we add can we access that screen from within the quote summary, we can also click on options within the quote sheet itself and select import quote prices. And that's gonna take us to the exact same screen we were just at. Any questions on import quote prices? Where is the field available for vendor? Okay. So Bear with me just a second here. Once you actually get to the import quote prices screen, And I think it is just about time for me to get a new laptop. Right at the very top here under the quote, underneath the the the quote sheet, you have a field for vendor. So here is where you can actually select which vendor you wanna apply these quotes to. So the the question is, can you import multiple vendors at once or each individually? So you can import multiple vendors at once. The key is when you're selecting, the vendor price or who or what price you're mapping it to, you need to make sure that you select the vendor that that quote price applies to, when you're doing the mapping. So what I mean by that is if this price right here belongs to a b c vendor, I wanna make sure that my vendor selected as a b c when I map it over. From there, I can switch my vendor to d e f, do my other mapping, and then click finish. Alright. Any other questions on import quote prices? Now the next item we're gonna take a look at, this came straight out of town hall. I believe it was UGM twenty twenty three. So one of the questions that came up or one of the one of the problems that user were facing was they like using the word bid proposal. However, the quantity field in the word bid proposal prints out to three decimal places. Problem with that is a lot of owners only wanted to see the quantity out to two decimal places. So what users had to do was they had to go out and essentially print the proposal and then trim the decimal places. It's just an extra step that you you shouldn't necessarily have to do. User brought it up at the town hall, and we got a I think we got about forty percent of the the town hall voted saying that this is something that they run into. So so we went ahead and we made what I like to think is a is a fairly simple change. And under the word bid proposal nope. We're not gonna run summary here. Right in the top right, we get a little checkbox here that says print quantity as two decimal places. So it's pretty straightforward. You click the checkbox, and you get a little message here that says selecting the print to two decimal places could result in totals appearing incorrect. So if you have quantities that do do go out to three decimal places and you trim it to two, the total could appear off. However, it is correct. It's just it's rounding at that point. So we're gonna click okay, and we're gonna generate the proposal here. It's definitely time for a new laptop. Alright. And you'll see here the quantity shows out to two decimal places. If I deselect that, the quantity will show out to three decimal places. So So it isn't anything earth shattering. There's nothing, that's going to affect the calculations in the background. It's simply trimming the quantity to two decimal places in order to try and save everybody that extra step, after generating the proposal that you shouldn't need to do. Alright. Next item is estimate, estimate sync automation. So what do I mean by that? Because we already have estimate, estimate sync automation. For anyone who is unfamiliar with what I am referring to, I am referring to the ability to archive and sync estimates. Now within HeavyBid, you have two options here. You can either archive or you can sync estimates. With archiving an estimate, it is essentially the same as making a backup and removing it from your system. What I mean by that is when I click archive an estimate, I am essentially making a backup of that bid, and I am storing it in our cloud storage that has no additional cost to you, the end user, and I am removing it from my local estimate list. I can, use that in several different ways in HeavyBid, and I can also retrieve it at any point I I want to. However, I no longer have access to that estimate from my open estimates window until I retrieve it or I make a copy of it. The other option is sync. Sync is beneficial for estimates that are currently still in progress. What I mean by that is any estimate that is not complete and it's something that I'm still going to log into and estimate. I want the users to have the ability to make those backups, and we have the ability to automate that. What I mean by automate is anytime a user runs a bid summary and spread or they close that estimate, HeavyBid's going to sync that estimate data up to cloud storage. And that way, in the event of catastrophic, something catastrophic happening, server crashes, flood, fire, whatever the case is, we can retrieve that data and get you back up and running. One of the other really cool aspects of that is the integration between preconstruction and HeavyBid. For anybody who is unfamiliar, within HeavyBid, I have the ability to map certain fields such as my project name, the job site, project status, state, owner, so on and so forth, to specific fields within HeavyBid. And you essentially get two choices. Well, you get three, but two that we're we're focusing on today of what I want as a source of truth. What I mean by that is if I enter information in both places for the same field, which one is the truth? Is it gonna be project tracking, or is it gonna be heavy bid? So if I have HeavyBid selected as my source of truth, what happens is when I run that sync, HeavyBid's gonna send the data up to precon and project tracking, and any information that is in those fields that is different from what is in the field in in precon is going to be updated. However, that also holds true the other way around when I select project tracking. So, basically, if I want to have my estimate synced, if I make any changes to project tracking, let's say I change the estimator in charge. Yeah. My estimator and charge here. And I want that to sync back down to HeavyBid, and I have precon selected as my source of truth. I still have to open the bid and either run bid summary or open and close the estimate in order for that sync to take place. Nine times out of ten, that's not really that big of a deal unless I'm trying to run reports out of heavy bid that require that updated information from precon. In which case, now I'm running with outdated information unless I go in and either manually sync everything, which is a step I shouldn't have to do, or I go ahead and open the bid and close it again. Again, an step I shouldn't have to do. So what we did was we we basically created, essentially, a Windows scheduled task that you can set up and run at any given time. Within your bin folder, once you update to twenty four dot one, you're going to have a new executable, and it's gonna be sync pre con estimates. And what that's going to do is it's going to basically look at the the last modified It's gonna look at this last modified date on the project details, and it's gonna compare it to the last modified state or the last modified time stamp in heavy bid. If the last modified date in precon is newer than the last modified date of the estimate in in heavy bid, it's going to sync that estimate for you, and there's no limit on the number of estimates. Basically, if you have one estimate that needs to be updated, it's going to update that one estimate. If it's got if you have five thousand estimates that need updated, it's going to update those five thousand estimates. Now what we recommend is setting up an interval to have that process run once an hour. Because if you try to run it, like, once a minute, if you have several instances, you know, two, three hundred, projects or two or three hundred estimates that need updated, you do have the potential of not having that first process complete before the next one, essentially starts up, in which case, it'll it'll cancel itself out. That's kinda what when, Windows Task Scheduler does. So we recommend an hour. That way, you give, you give the process plenty of time to complete. What this is gonna do is it's gonna make those those folks that have to go in and manually open an estimate just for the sake of getting the updated information from precon or having to go in and run that manual sync, it's gonna take that step away. If you're running that manual sync on a thousand estimates, that there's no way around it. That takes a while. I'd rather run it on the fifteen that I actually need to update than run it on all one thousand every time. Alright. Any questions on on the the sync automation? Right. Moving along here. So have you been SQL? We started getting a few calls, after twenty twenty three dot two was released. Slightly odd since the root cause of the problem was in twenty twenty three dot one, but what we found was there were specific slowdowns in the the query menus and utilizing the spreadsheet view. If you were utilizing either of those functions, HeavyBid essentially came down to a crawl. Basically, when we started getting those reports, we took a look and we found, we found a bottleneck in heavy bid. We, we basically got rid of that bottleneck. We fixed the problem while not getting rid of what that fix was trying to address, and we brought it back, to actually faster than it was beforehand. So what we did was we put out a a patch release for twenty twenty three dot two and twenty four, and that fix is also in the base build of heavy bid twenty twenty four dot one. So if you're experiencing slowdown in twenty twenty three dot two or twenty four and you're on heavy bid SQL, once you update to twenty four dot one, you should notice, a significant performance improvement, within the query menu as well as the spreadsheet view. Right? Any questions on that? So what is SQL? So SQL is an iteration well, SQL is a is a database management system that Microsoft offers, and we have a version of HeavyBid that that functions alongside or functions within the SQL database. So, basically, your your standard, your standard data structure that HeavyBid runs off of is essentially converted to a SQL database solution. And what that does is it gives users the ability to build their own custom reports out of that SQL database. SQL systems have a have a large community where you can get certifications, you can take classes, you can learn to your heart's content to basically mine that data in a much more efficient way than you could in heavy bid standard, data structure. And that's why users like to some users like to utilize the the SQL back end of HeavyBid. Any other questions on the the SQL speed improvements? Alright. Now the the next item that I wanna bring up is one more poll, for everybody. Melissa, if you do me a favor and pull that poll up. Has just launched. Alright. Alright. And what we're trying to do is we're just trying to see kinda what role the users that are attending, this webinar, what their you know, what do they do on their day to day basis, basically? I love all the participation. We're at about seventy percent. Let's give it just one more second here. Alright. Alright. Go ahead. We'll end that poll here. Alright. And okay. Looks like So go ahead. We'll close that. Alright. Well, so I'm gonna go ahead and I'm gonna close it here, and we're gonna move on to closing remarks. So, does anybody have any any questions or comments, anything that we talked about today, or any questions they might have about the twenty four dot one release? Right now, it is in support's hands, which means that barring anything they find, you should be receiving an email here within the next three to four weeks letting you know that it is on the community ready and able to be downloaded. Alright. And give everybody a minute, see if anybody has any questions. If not, then we'll, we'll go ahead and wrap up here in just a minute. And, while we have everyone here, if anyone has anything that they want to see in future webinars or specific topics they wanna learn about or functions within heavy bed, drop it in the chat, and we'll definitely consider that for the future. We'd love to hear from you. So Alright. I think that's it. I don't see any questions coming in. So thank you all for coming. We really appreciate it, and we'll see you at the next one.