Labels and Worksheets Made Easy—Sort Of

KEVIN ALLEN: So for those of you who signed up for this class originally, you probably remember when you got your information, you might have noticed that Garrett was teaching this class, right. Garrett Tice, any of you guys know him at all? He had some family situation develop, and couldn't attend AU this year.

So, William and I were of informed on Monday when we got here, that we needed to do a class on Thursday for labels and worksheets. So over the course of the last couple of evenings, we've put together a presentation for you on labels and worksheets. You probably noticed that there was no uploads, handouts, any types of things. That's the reason why.

We just got this finished, and I will get it uploaded maybe this evening, maybe tomorrow or over the weekend. I get to you at least, so that you've got the PowerPoint presentation. We didn't put together handout, OK, it was last minute.

You're certainly more than welcome to contact us if you need additional assistance above and beyond this class. So I think before we get started, since we do have such small class, who in here has built labels and worksheets before, right?

Everybody? Nobody? A couple? You've done a little? OK. Carrie, you've don't done none. OK.

AUDIENCE: [INAUDIBLE] I've done some labels.

KEVIN ALLEN: You've done some labels. What about you guys? Nothing, OK. So what's your intent, or what are you trying to gain here? Are you going to be moving into building labels and worksheets, is that why you're here? OK. All right. So hopefully, what we've put together, will help you do that, right?

And so like I said, the PowerPoint-- I'll post it in the next few days so that you can download it and have it for your tutorial. So bear with us, right? This is pretty much last minute. So we put together what we could do in a short amount of-- oh, of course.

WILLIAM TUCKER: Did it quit working again?

KEVIN ALLEN: Yeah, quit working again.

WILLIAM TUCKER: Mouse work?

KEVIN ALLEN: Well, we'll just turn it like this and I'll hit the button, how's that?

WILLIAM TUCKER: There you go. That worked.

KEVIN ALLEN: OK.

WILLIAM TUCKER: That'll work.

KEVIN ALLEN: So, learn how to produce labels and worksheets using CAMduct software, right. So everybody in here, you're using CAMduct currently today, right? No, you're not. OK, what are you using?

AUDIENCE: Nothing.

KEVIN ALLEN: Nothing. OK.

AUDIENCE: I work for a civil engineering firm.

KEVIN ALLEN: OK.

AUDIENCE: So I'm taking this just for interest.

KEVIN ALLEN: OK, same with you? So you're not using CAMduct?

AUDIENCE: Correct.

KEVIN ALLEN: OK. So this is going to be geared primarily towards CAMduct, which is a plasma cutting software that takes sheet metal components and does the flat pattern develop and then puts the stickers on them, the labels, so that we know where to put the parts in the shop. So that now we can assemble the ductwork. OK, so that's kind of the gist of where we're at right here. Question?

AUDIENCE: Are you guys going to do bar coding with the labels?

KEVIN ALLEN: We currently are not today, but we're going to show you QR codes on the labels we've got today. And we're going to start that process in the first or second or third week of January. We're going to implement QR code status changing for a couple of our shops.

So, a little bit about us. I'm Kevin Allen, this is William Tucker. William may not talk as much as I do, his throat's a little sore, so I'm going to try to do most of the talking for us. If he needs to get in, he'll certainly jump in.

So my title, Director of BIM and Productivity for Comfort Systems. William's BIM trainer and product specialist for us. We have 25 companies nationwide that we're supporting, 10 shops, six [? core ?] [? lines ?]-- is that right? Six [? core ?] [? lines? ?]

WILLIAM TUCKER: I think, yeah.

KEVIN ALLEN: So six, and 150 users, 150, 60 users of the software running on one database. So it's a pretty big endeavour. So we set up labels, we set up worksheets, and we have all of our shops try to use the same ones because we're pushing the same data to them.

So we have the ability, because we're a nationwide company, we can draw or coordinate ductwork in one branch office and send it to another location to have it be fabricated, and send it somewhere else to be installed. So we're sharing resources, sharing that information back and forth. So since we have that single database, we're able to do that.

If it wasn't for that, it would be real hard for somebody to set up a label and pull a print object for some certain field. And then the guy at the other office, he didn't fill out that field, so obviously nothing's coming in on the label or the worksheet, right? Covering labels, worksheets, label sizes, printing, using processes for printing those labels. We might even get in and show you our list of processes, just to give you an idea about what we're up against on our challenge on our side. So hopefully you can get something out of this today.

So creating labels and printing labels, create and print worksheets, adjust the size of the label. Sometimes that can be difficult, getting the size to fit whether you're using in a six on an eight label page, right. So you're going and getting your Avery labels and you have six of those on a page, or do you have eight of those on a page. Try to make that fit on a page, hopefully we got some things for you to help you on that. And then learning how to do that through, and your process.

WILLIAM TUCKER: Let's back up just a second. When you were talking about, this is CAM, just point out the worksheets can also be used in CAD.

KEVIN ALLEN: That's right. Yes.

WILLIAM TUCKER: And we still print labels out of CAD.

KEVIN ALLEN: That's correct. Yes. So we're gonna dive right in. So bear with us, we got a lot of text on here, trying to explain some things. But we thought, if nothing else, the PowerPoint, if you didn't catch all today, the PowerPoint's going to help you when you get back to your office, to explain to you, hopefully, everything you need to know about setting up a labor [INAUDIBLE] worksheet.

So we really put a lot of text on here. You normally wouldn't produce a PowerPoint like this, but because we didn't do the handout, then we had to put all the information we could into the PowerPoint.

So, getting into the labels. Applying information to the manufactured parts and having that label in there, so we know where it goes, right? We've got some pictures here of our actual labels.

Setting up to any printer. All the outputs, so if you're familiar with the software, inside the MIS folder, the IZNs, the LZNs, DZNs, those are all the different file extensions for the different types of labels that are in there, and worksheets. These are all labels, but then there's worksheets in there as well. So if you needed to go in there and copy that file, and do things with it, right.

WILLIAM TUCKER: Sorry I missed that one. WZN, I believe is what is--

KEVIN ALLEN: I was going to say, W-- yeah. So that that should be the-- well, this is actually a label. So maybe we got that on the next slide.

WILLIAM TUCKER: Maybe.

KEVIN ALLEN: So here's a picture of our label. So one of the things that really helps out the shop and the delivery of the ductwork to the field is the colors, right. You got a job color. You've got a section color.

We also assign a service color to our labels, so that it's just one more visual piece that the installers, once it's getting out to the field, they can tell right away. Hopefully they're not colorblind, right? They can tell where that piece goes. And as you see down there on the bottom right hand corner, we just put our QR codes on there.

We were able to scan that with an iPhone last night. That's science, right? So we're hoping that that's going to work. We're going to move forward with that and see if it actually does. Anybody have any experience with that?

AUDIENCE: We're starting-- trying to use the barcode and stuff like that. Are you guys tracking it externally like with a scan and code Excel sheet to track where it's at in the process?

KEVIN ALLEN: So we're going to try to keep all of our status updates with the MAJ file, so that we can run the reports on the MAJ file. We could dump it into Excel later, but we want all the live tracking to be in that MAJ. OK. Yep.

So, again, you could read through this. Color coded, sizes, connectors, seams, all the information that we need for that part to go out to the field and be installed, right. Now part labels, this is for shaking it out in the shop, right?

So we've got four, if you see the little picture right here, since my pointer's not working. That elbow has four parts to it, right? So this is part--

WILLIAM TUCKER: One of four.

KEVIN ALLEN: One of four. OK. Yeah. So that's one of four, right, two of four, three of four, four of four. So now we need to take all those parts, get them together on the table in the shop, and now be able to put them together, right.

So we need enough information on here so that the shop knows how to break that elbow. What kind of seams they're going to put on there. What kind of connectors they're going to put on for the [? TDF, ?] [? TDCES ?], and drive. All the different pieces, the connectivity for that. But we need all that on that label to get there, right.

So again, a lot of text on here. But again, we're going to hand this to you and let you hopefully be able to take this and go with it. Here towards the end, we're going to actually jump in, maybe show you how to make one. Do some things with that. Maybe try to customize one, you know, get to that level.

The software automatically breaks out straights versus fittings, right. So this happens to decoiled straight cut type. So when we set up this label, all we're going to get on this label is our straight joints. None of our fittings are going to show up on this label.

So this label can be customized with the view and the options to say what do I want to see just on my straights versus what I want to see on my fittings. You can customize each one of those individually. And it's pretty straightforward interface to build those.

So nest labels. So when you print-- I think we actually have a slide on the next one or one of these, that actually shows if you want the nest labels to print with your part labels. And this basically shows the guy who's running the plasma table, when we've nested these parts, there's part one, there's part two, there's part three.

That's what's on that flat pattern development that's getting ready to get out on the floor and we're going to have to start shaking these things out. So just another way for them to keep up with what's happening on all of the indices. So on a particular download, you may have flat patterns whether you're using 5 by 10 sheets, or 10 by 20 sheets, whatever it is, 5 by 10s, 5 by 20s. There's lots of these, right? There's going to be a lot of these different development sheets that part one of piece 5 might be on the first sheet, but part two of piece 5 might be on the fifth sheet that we burn.

So now we've got to get those organized and get them into the shop and start getting them over to the table so we can put them together. So sheet numbers displayed. Graphical sheet view.

So, oversize labels. Again, another piece of the puzzle. When we draw a piece of ductwork, if it doesn't fit on the sheet, now it becomes an oversized label, because now there's different information that we need for the oversized label to tell the guys in the shop how to build this then there is in just a regular part label. So these are oversized, again.

And the set up of each one of these is all the same. OK. Once you figure how to do one, now you just have to repeat the process multiple times to get each one of your labels. Here we go.

So, inside of the software, go set up a label printer. So the first thing we need to do is tell it where we're going to send these guys, right. So internal to the software, correct me if I"m wrong, William, but you could print labels on one tray and reports on another, Right

WILLIAM TUCKER: Exactly. Yep.

KEVIN ALLEN: So you don't want to be switching out your paper in your printer, you want to set up two different trays, so that you print labels on one, and regular, flat stock paper on the other for all your reports. So you're going to have your weight reports, and your [? skipler ?] reports, and [? essen ?] drive reports, and on and on and on.

So select the printer from the drop down, so you should have drop down list. It basically ties back to Windows and has your default printers in there that you've already set up. Select the units. We like to use zero right there. There's non printable area, obviously, around the sheet. And it updates based on the margins that you put in here.

So when you're printing around the label, depending on are you buying Avery labels or some other maker, what's the border around each one of those labels, OK, so then now there's some adjustments. I think we get into that on the next page here.

How do we get the information that was displayed on those labels previously to fit on that sheet like that. Select the printer at the top. Check the box for multiple labels. Select custom label, and then adjust the margins. And this is probably the most-- I wouldn't say the most difficult, but the most least documented part of this process, because you just kind of get around here, and play with these numbers, and you try to make something match.

Well, here's how that works. A Is from the left side of the page to the start of the label. That's A, to the edge of the first label. And there was nothing really to tell us this before, we kind of figured this out by trial and error. B being the width of the label. So that's there to there. Then C being the value from the left edge of the left label to the left edge of this. So it's from here to here.

It's not really intuitive on exactly how this works. So if you've ever had to do that, you kind of just hunt and peck around in there and you kind of make something work. You never really understood how does this work, what's it doing, right? And then you can follow the rest.

D's from the top. There's always a margin at the top where the labels get pushed down. So you can adjust these.

This happens to be a six on an eight, this is what most of our companies use. Is anybody using anything different than that? Are you making smaller labels? Or are they most of them all six on eights? All the same?

And of course, set your units there. And you can either load an existing label that you've already set up, or go ahead and save this one for future use. Don't just set it up and walk away, hit save. Because you'll back in here doing it again, right?

So you're modifying a snapshot, again, save it again. Make sure you hit save before you get out of here. Because once you get that thing working the way you want it, save it. So that's the labels, and I think we're going into-- oh, so creating a label. OK.

What do we do? We hit item labels. By default, there may be some out of the box ones there that show up, but you can start, I think there's a new one right there on the bottom. Hit new, and you get a blank page, just like that.

So now we need to start working on it. So what do we do? Do we go into right clicked and divide, is that on the next page?

WILLIAM TUCKER: I'm not sure there's a [INAUDIBLE]

KEVIN ALLEN: Yeah, we might've skipped that part. There we go. So right here, you right click in the screen, and then you could say split horizontally or split vertically. There we go, these guys.

So you basically just start dividing up this page. So you start making yourself little blocks. And once you get the block that you think you want in the size that you want, now you come over here to print objects, and you say, you know what, I need to put in item number on there. So you just drag and drop that in there. So again, it's a process if you start from scratch.

First off, you're going to have to make a mental note what all information do I want that label, right? What's the easiest way? Go to your Vulcan, or whatever software you got previously, look at all of stuff you got on there, OK, now I just need to put it all on here. I need to replicate what I already had with a new system.

That's usually what happens, is if you're in here in this mode, you're probably just starting out with CAM and building labels from scratch. We're going to talk about worksheets here in a minute, and some of the things that you may or may not know about worksheets.

So divide it into sections, add your print objects, right click it to split it in horizontal and vertical sections. So you right click split, right click split, and each one you can just keep splitting that box smaller and smaller to get it to what you want. So go to the next one there, William.

AUDIENCE: [INAUDIBLE]

KEVIN ALLEN: Yeah.

WILLIAM TUCKER: Yeah.

KEVIN ALLEN: Yeah. So you need to take out the fields, remove it, and then maybe move one back in.

WILLIAM TUCKER: Yep. If you take-- say if you burned in an object right here and you didn't want it, if you right click and delete, that's going to delete that whole field right there. So depending on how that one was divided up. How that one was divided, and it is in order, so you have to pay attention when you build these things, because if you need to delete a hole and delete this line out of here--

KEVIN ALLEN: It may take the whole thing.

WILLIAM TUCKER: You might end up deleting everything. But if you just want to get rid of that data field, drag it and drop in the trashcan.

KEVIN ALLEN: Yeah. So what you don't know, is when somebody built that label in the past, did they split this vertically first and then add these, or did they do it after the fact. Because then they could have had these lines going all the way across and they said split horizontally, split horizontally. Well, now you go take this one out, well it really jumbled up your label, right, because again, you don't know what somebody else did in the past. So it could be a little tricky when you get into that situation. Absolutely.

WILLIAM TUCKER: And I've had to do that a few times myself. Just get back inside, I need another field somewhere. I need to get rid of something and change it. And I just take a screenshot of the whole label, set it to the side, and pretty much delete everything out of there and go back and start over.

KEVIN ALLEN: Right. At that point, when you get it so far out of whack, it's like, OK you know what, hit the new button and start over. Because there's really no way to save yourself at that point. You're too far down into [? tricks ?] at that point, right.

WILLIAM TUCKER: Best to have a plan before you get started.

KEVIN ALLEN: Yeah. Kind of know the data, right, that's the whole thing, is know what you want before you start dividing this thing up, because yeah it can be very tricky. There's no doubt.

AUDIENCE: [INAUDIBLE]

KEVIN ALLEN: Yep. Yep. Yep. So once you get a print object pulled in, so you take one of these objects and you pull it in, now you can right click in this area and go to the Properties and now you can change what's displayed about that particular print object. So not only do you need to decide what print objects you need, but now you need to go in there and tweak each one of those little print objects to really give you the data that you want on the label.

So just drag and drop. So once you got what you want up here, just left click and hold, get over the box you want it in and turn loose, and bang, it's in there. So it's just a drag and drop at that point. OK? All right.

Let's go to the next one there. So once they're all applied, now we can use the Print Preview button and go test it. I think I got the right data that I wanted, but let's go check it. Don't forget, you've got to have something in your job taken off and nested before you can test it. Because if you don't have anything in there, the label's going to say nothing to print. Because I don't have a nest, I don't have anything in there to show you, right.

So is everybody familiar with this dialog box, Processes Everybody understands what that does, right? OK. If you weren't in one of our earlier classes, we'll show you our list of processes, just so you got an idea about how many it takes for us to do what we're doing at Comfort Systems.

WILLIAM TUCKER: Something tell me your computer didn't sync last night.

KEVIN ALLEN: It might not've. Yeah, we're missing a slide there, aren't we. Yeah.

WILLIAM TUCKER: Missing a slide there.

KEVIN ALLEN: OK. Now, worksheets. Well, before we go on, any other questions on labels? I know we kind of went through that very quickly. Yes, sir.

AUDIENCE: The bar codes, is that something [INAUDIBLE]?

KEVIN ALLEN: So barcodes are in the system. They are now included with CAMduct, so if you all a station of CAMduct now have the ability to--

AUDIENCE: [INAUDIBLE]

KEVIN ALLEN: 2015 or 2016, that's correct. That is correct. What version are you running now?

AUDIENCE: 2015.

KEVIN ALLEN: OK, so you're good. So you have the ability now, just like we showed some of those. We're trying to decide. Are we going to do QR codes or are we going to do barcodes. We're trying to make that decision now. I know a lot of people out there doing barcodes now, not very many doing QR codes and utilizing that for a lot of things.

So Tracker, which is the other component you need, if you're going to put a barcode on a label, now you need to be able to scan it and track it, right? Tracker is also included with CAMduct. It used to be, in the past, it was a separate purchase. And now it's all included.

So now it's just a matter of you taking the time at your organization to implement it, And that's exactly where we're at. We got one particular shop, that, probably like most, is having some delivery issues. We'll put it that way, where the field's claiming they're not getting the duct. The shop's saying, no, we sent it.

And now there's some blame game going. And they want to put a stop to that and say, here, we scanned it. Here's the shipping list that was on the truck. Now, we're still toying, are they going to actually scan it again when they get it to the job site. I mean, what are we talking about.

Worst case scenario, it's going to fall off the truck, right? Other than that, unless you stopped at McDonald's and somebody stole it off the truck, right, we shouldn't have anything lost between the time we put on the truck and the time we got to the jobsite. So I question whether or not we even need that second scan at the jobsite, right.

But again, it's not it's not my call, it it's going to be that particular-- our particular operating company. They're going to make that call, and we'll set it up anyway they want. Any other questions on labels. Yeah?

AUDIENCE: I'm not a [INAUDIBLE] guy, but do these labels essentially replace any type of application [INAUDIBLE]?

KEVIN ALLEN: No, sir. So on a fabrication drawing, so we got a shop drawing, right, that has a run of duct work going through a corridor and running out to a VB box and supplying some drills. So on our shop drawing, we'll label that as piece one, two, three, four, five, up to 500, whatever piece numbers they are. We'll print that.

Now that print gets delivered to the guy in the field. Now these labels have numbers on them. The piece number that's on the label is the same number that's on that shop drawing, so now it's an install by sequence. Literally, it's install by number at this point.

Whether you're doing it as pre-fabricated spools or sectioning ductwork, or you're just installing it piece by piece by piece. So the use of this data is really just to fabricate it in the shop, and to know where it's installed in field. Once that happens, the label's pretty much useless at that point. Nobody will ever use it again.

WILLIAM TUCKER: So the power label-- for example, here, the power label would have four parts to this elbow. That's in the shop, so then grab all four of those parts. Right at the very top is number one.

KEVIN ALLEN: Piece number one. Yeah.

WILLIAM TUCKER: Piece number one.

[INTERPOSING VOICES]

KEVIN ALLEN: That little guy right there is showing-- wow, that's hard to-- it's hard to keep my finger in the right spot. So it's showing you that this piece is the top part of that. There'll be another one of these where that back piece is highlighted there. Then another one there, and then another one down here in the corner. So there's actually four pieces to that.

And so that graphical representation shows the person in the shop does this go on top of the elbow or the bottom of the elbow, basically. So this is all the data that he needs to be able to build it, so that now we can go install it. That help make sense?

AUDIENCE: Yeah.

KEVIN ALLEN: OK.

AUDIENCE: [INAUDIBLE]

KEVIN ALLEN: Degrees and inches.

AUDIENCE: [INAUDIBLE]

WILLIAM TUCKER: What are you asking? You just asking the bending information?

KEVIN ALLEN: The bending information. Yes, the degree of the bend.

WILLIAM TUCKER: It's on the label, yeah.

KEVIN ALLEN: So maybe when we get into when we're actually driving, we'll see if we can't actually grab a transition.

WILLIAM TUCKER: And you mentioned Vulcan, right? OK. Just to let you know that I don't understand how they did in Vulcan. I've only used this software, but I do know that your bending information, you're looking at it opposite from the one you're doing with Vulcan. But I can explain to you what that bending information means.

AUDIENCE: [INAUDIBLE]

KEVIN ALLEN: You could get both.

AUDIENCE: [INAUDIBLE]

KEVIN ALLEN: We'll see if we can't find a transition and actually trying to find the label for you, and see if we can't get the data for you. Obviously, we're a pretty small class, so that's going to work out to most of you guys' advantage, right, because we can really dive in to some of these little things as we get there, right. OK. Any other thing on labels? Let me get back to the slide we were on.

AUDIENCE: Is there a QR code, or you guys manually place it in, or is it a field that you guys are putting in there--

KEVIN ALLEN: Oh, it's a field that generates your prints automatically. Yeah. Absolutely.

WILLIAM TUCKER: Is anybody using bar codes of any kind right now? Are you using bar codes or QRs?

AUDIENCE: We're using bar codes.

KEVIN ALLEN: Bar codes.

AUDIENCE: For our job. Job number information on it.

KEVIN ALLEN: Yup. Job number and item number, right?

AUDIENCE: We're [INAUDIBLE] job number and ticket number so we can track it from the shop. And then the item number [INAUDIBLE].

WILLIAM TUCKER: Does the bar code eat up too much room on your label?

AUDIENCE: No it does not. We seem to have used just a small amount of space on the top and we've got a small [INAUDIBLE].

KEVIN ALLEN: And it scans pretty good?

AUDIENCE: Yeah. [INAUDIBLE]

KEVIN ALLEN: Yup.

WILLIAM TUCKER: We're about out of space on our labels, and I put that on last night and tested it. I think it's going to work just fine.

KEVIN ALLEN: So let's continue on then to worksheets there. So does anybody understand what the difference is between worksheet and label? Label's printing items, right? And then worksheets being almost like a reporting functionality, right? Not just a single part.

But you can limit items because it's I would say limited filtering available in worksheets, right? It's not as robust as a full blown item report, OK? You don't have that level of filtering capabilities, but you can filter worksheets to show you only certain items like-- I think we've got an example in here of a canvas, where we want a particular worksheet to only show us the canvas information, OK?

And what we don't want for a canvas is to have an individual label for each piece. We just need to know what sizes we need to build and how many, right? So it kind of makes more of a report than it does print the individual parts and pieces, right? That a good enough explanation for that, William?

WILLIAM TUCKER: Yep.

KEVIN ALLEN: OK. So again-- you could include this, can include that. Saved as a WZN-- there's the extension there. But a lot of people don't understand that they can also run worksheets in CAD, OK? A lot of people think that labels and worksheets are only intended for CAM, but there's lots of uses for worksheets in the CAD environment, OK?

I don't know that we have a lot of examples of that, but let's see. We're using worksheets in the CAD environment, for instance, because we have a particular operating company that wanted the hanger information to print on a label. So you do that same thing.

AUDIENCE: We use actually labels for-- we're a plumbing company, so we use all the labels. We do the [INAUDIBLE].

KEVIN ALLEN: So we built the label, so now we're giving them rod length, strut length, and hanger elevation all on the label. So when we print that label sheet out, that goes to the shop, they're fabricating hangers, and they fabricate hangers until they're done peeling off labels and sticking them on, right? This is how you know you're done with your project-- when you run out of labels.

AUDIENCE: It saves us on the labor too.

KEVIN ALLEN: Absolutely. Hands down. It's phenomenal. OK?

AUDIENCE: Do you number your hangers?

KEVIN ALLEN: Absolutely. Every hanger's numbered and every hanger has a specific rod length.

AUDIENCE: [INAUDIBLE].

WILLIAM TUCKER: Not only that-- hopefully we hung it-- we set it with a Trimble.

KEVIN ALLEN: Yeah, hopefully we use Trimble or some type of layout device, right, that we can now locate the [? embed ?] or anchor or however we're laying out that hanger, right. So that's a very important use for worksheets in the CAD environment versus just for the shop guys, right? That's a big thing. So yeah. Go on the next one there, William. Hopefully this gives you a lot of information.

So of course here's a worksheet for canvases, items-- again just kind of showing you some different things that you can do with worksheets that are different than labels. OK? So I'm sure if you've been around CAM a while you're doing these exact things.

Maybe you're going to go back and try to in CAD type in worksheets, right? It's going to bring up the exact same interface. So you're going to have to split horizontal, split vertical, do the exact same things that you do with labels-- you do with worksheets, OK.

So the only difference is up at the worksheets is a little filter piece at the top where you could tell it, I only want this to work for canvases or whatever it may be. Because again you want to change the data that's displayed on there for each of your items, right? OK?

So again, the worksheet interface looks almost identical. You've got the pull down at the top where you can pick which one you're using. The filter bar there-- click in there and it works like the filter that's in CAD where you can choose item service type, item material, on and on and on, equals this, equals that. So you can add as many filters there. It's and or or, right? So that can get a little tricky on you as well-- making sure you get what you want there.

So again, same thing-- right click, split horizontal, split vertical, drag items over, a little more robust because it's got some headers and some things at the top up there-- but yeah. Pretty handy little piece right there. OK?

So similar creating labels-- area here we go. Drag and drop required objects. Print objects can be scheduled-- can be searched for. The report header can be used to define the print order.

Order can be set by item number; by item service; so that now you've got supplies, printing with returns and all of that. Options to determine if a report is created for each item or each item quantity. So do I want 10 worksheets, or one worksheet quantity 10, right?

How do we want that to-- again, similar to the item report functionality. And then again the filter-- rectangular duct, item bought out flag is yes. So what do we want to see on this particular worksheet?

So I guess to sum it all up, really, it's incredibly powerful, but it is going to take you some time to get in there and set it all up, right? You've got to do each one individually. You've got to do-- you know, there's no-- I mean, I guess there kind of is a Save As, but now you're tearing it all apart trying to make it do something else, you might as well just start from scratch, right?

You've been there. You know how it is. Sometimes that's the best way-- to start from scratch and do it all over.

Many different print objects, right? I don't think in four hours we could go through every print object and explain to you what ever print object does in the system, right. The print objects within the suite of products is just crazy, right. You're just going to have to get in there and figure out which one you need what it's giving you, right. There's really no other way around that but to just pick one, hit Print Preview, right.

So many different ways to display it. Take time to experiment. I can't stress that enough, really. There's no other way to learn how to do this-- worksheets, labels, and to me, item reports, right? They all fall into that category where it takes time to learn how to manipulate the data to get back what you want, right? A lot of times it's a struggle. There's one little item-- something not giving you something right, right?

Everybody know about the command in CAD-- show me the DIFs, right? If you've got a list of items that you think should be all the same item numbers and it should be giving you quantity eight but you've got one that's showing up on another line at quantity one, go find that item, pick one or the other items, and show me the difference. What is it? Did somebody go in there and inadvertently add, say, item notes to that one item that none of the other items had? It throws it as a new item on your print report. OK?

Some little bitty thing like that can give you fits, and you're thinking it's something you've done wrong on your report, when in fact your report is working perfectly. Or your label or your worksheet-- whatever. But it's actually the item itself that something's different. So it is showing up on a new line, right?

So that's just kind of a little side note. Sorry about that. Take time to experiment. Use Print Preview. Again, I can't say it enough. Do something? Preview. Don't go in there and change 20 things and then finally decide, oh, let me go look and see what I did. OK?

He's laughing back there in the back, saying-- been there done that, right? Don't go down that road. Make a change-- preview, right? Make a change-- preview. Oh, I'm getting closer-- make a change-- preview. Right? Wear it out, right. Wear that button out, because you'll love it when you get all done.

And of course this is one-- make sure you haven't done that in an isolated environment. Make sure everybody has access to that, right. Hopefully you've got your network on-- or your database on a network of some sort. You're not just working locally. You've distributed that.

You know, many times in my previous life, and I think William too, where-- oh, well he doesn't have it. Oh, well we've got to put it up on the server and we've got to copy it over to him. What do you mean? Aren't you all running off the same database? Well, kind of.

So anyway. Put it out there where everybody can get to it and access it all at the same time, right? So that's really all I had. I think William has-- I think he's already started over there. He probably is trying to answer the question on the angles for a transition. So any questions-- again, we apologize. Last minute information-- we put together what we could here.

Anybody have any questions on the second part of this, which was really the worksheets? Again-- they're pretty similar. Not pretty-- they're very similar to the whole labels side, right? So are we ready to switch you?

WILLIAM TUCKER: Yeah. It show up there?

KEVIN ALLEN: It did, but it's kind of yellow. There we go. HDMI wasn't plugged in good or something.

WILLIAM TUCKER: Something wasn't good. So you asked, could you get a bending angle instead of that bending information, and I didn't find anything to do with angle. But--

AUDIENCE: [INAUDIBLE].

WILLIAM TUCKER: What's that?

AUDIENCE: [INAUDIBLE].

WILLIAM TUCKER: Yeah the break C2 down six. So that means from end one, you can put in one in the break, and you can break N2 down six inches. And you figure out what to do with N, too. And you figure out what to do with N, too.

AUDIENCE: [INAUDIBLE].

KEVIN ALLEN: No, but that's what he's getting at.

WILLIAM TUCKER: Yeah. I'm saying, yeah.

KEVIN ALLEN: You don't see that in here, right?

WILLIAM TUCKER: But that's what everybody-- Vulcan tells you both ways, right? Well this here tells you what to do with on, you figure out the other one. Which is pretty obvious, so.

AUDIENCE: On two. But I'm saying I have 190 inch by 20 inch [INAUDIBLE] so it's a big, big piece that [INAUDIBLE] only going down two inches. We're [INAUDIBLE] bigger stuff. The guys use the degree to know how much to kick [? in. ?] [INAUDIBLE]. Where I personally-- I would always just eyeball it. It's [INAUDIBLE], it's not--

KEVIN ALLEN: It's not rocket science, right? We're not building a Swiss watch.

WILLIAM TUCKER: And you're not the first person that's mentioned this to me. Maybe we just need to ask them for it. Ask if they can't give us a break angle.

KEVIN ALLEN: A break angle.

AUDIENCE: [INAUDIBLE] break angle on it, but you can't do both. [INAUDIBLE]. You can switch it to [INAUDIBLE]. You can switch it to read one or the other. You just can't do both.

WILLIAM TUCKER: Oh, really. Let's just make sure. Nope.

AUDIENCE: [INAUDIBLE].

KEVIN ALLEN: Are you in global?

WILLIAM TUCKER: Yeah.

KEVIN ALLEN: I have to ask this question, because we've got 160 people using this database, and if he does something wrong--

WILLIAM TUCKER: I'm probably I can change it. I just wanted to see where it's at because I never knew it was there.

AUDIENCE: [INAUDIBLE].

WILLIAM TUCKER: Options or switches. Developments.

AUDIENCE: [INAUDIBLE].

KEVIN ALLEN: Down four.

WILLIAM TUCKER: We'll do it right quick.

AUDIENCE: [INAUDIBLE].

KEVIN ALLEN: Oh god. Break down 19.

AUDIENCE: [INAUDIBLE].

KEVIN ALLEN: It's one or the other.

AUDIENCE: [INAUDIBLE].

KEVIN ALLEN: The guy's here that we need to talk to to see if we can get that in there, OK?

AUDIENCE: Is there a column you can add in the label that says [INAUDIBLE] information [INAUDIBLE].

KEVIN ALLEN: Probably not, no.

WILLIAM TUCKER: They'd probably just need to ask for a separate--

KEVIN ALLEN: We just need to ask for a separate print object to include that as well, right?

AUDIENCE: I believe with [INAUDIBLE]. Potentially you can do it by creating a new item through [INAUDIBLE]. But [INAUDIBLE].

KEVIN ALLEN: Who were you talking to on that?

AUDIENCE: Just [INAUDIBLE].

KEVIN ALLEN: [INAUDIBLE]. Was it [? Jubel? ?] Was it [? Jubel? ?]

AUDIENCE: [INAUDIBLE]. I know I brought it up [INAUDIBLE].

KEVIN ALLEN: OK.

AUDIENCE: [INAUDIBLE].

KEVIN ALLEN: I was going to say, do a pull down for processes.

WILLIAM TUCKER: Yeah, because there was part of a slide there that was kind of important that we didn't get synced last night.

KEVIN ALLEN: So because we have so many different shops, these are all the processes that we need for each one of our individual shops in order to process metal, print reports, print labels, on and on and on. So each company-- if you see the abbreviations there in the front, you see a group that says DMI-- that's all of their processes that they run at that particular operating company, OK?

So the beauty of this is because all of our processes are stored globally, we can troubleshoot what's happening at a shop on any location we're at. We can run their report, run their processes, and solve problems without needing to log into their machine and try to replicate what's happening. We can do it on our machine because we're seeing the exact same thing they're seeing. So. OK. Cool, William. Sorry.

WILLIAM TUCKER: All right. So here on the select reports under options here-- you have the option for printing your nest labels along with them so that whenever you blueprint your item labels, you'll get one less label. Some people aren't aware of that just because that option's kind of hidden there a little bit. And I've seen people run off and print nest labels and there's really no need. I can't really see a need for printing nest labels, myself. Maybe even people that are shearing sheets.

So I see a few people that shear sheets will put an S label on the sheet, but the majority of the time they print a report, go out with a marker, and just write it on the sheet with a Sharpie. OK. Just want to point that out right there.

AUDIENCE: What item are you guys using for [INAUDIBLE].

KEVIN ALLEN: Item for Canvas connection? CID?

WILLIAM TUCKER: For the canvas?

KEVIN ALLEN: Yeah. CID.

WILLIAM TUCKER: Well I could have just looked down here. Sorry about that. I got one in here, so--

KEVIN ALLEN: Right there. Scroll over. Is it in there? CID, CID. I thought you had that in there already.

WILLIAM TUCKER: Oh, I probably should have.

KEVIN ALLEN: CID 166?

WILLIAM TUCKER: Yeah 166 for the rectangle, 555 for the round.

AUDIENCE: [INAUDIBLE].

WILLIAM TUCKER: Yeah.

KEVIN ALLEN: That's why it's easy to filter, right? In that little filter [INAUDIBLE] box at the top? Filter for that CID and you're good to go, right?

WILLIAM TUCKER: Yup. 166 and 555.

KEVIN ALLEN: OK. Everybody understand how that works at the top? When you click in there it gives you a pull down. It puts a space right there. It can go and or or. And then he's got a list of all the things you can filter by, right?

WILLIAM TUCKER: It's not as robust as reports. But one thing about reports-- I mean, you can't filter unless you have the object in the report. Or this one here, you have the option to filter through just about anything.

AUDIENCE: [INAUDIBLE].

KEVIN ALLEN: Turning range? Yeah, we got one in there for those as well.

WILLIAM TUCKER: Turning range?

KEVIN ALLEN: Yeah.

WILLIAM TUCKER: That going to be on the label, so. [INAUDIBLE].

KEVIN ALLEN: Yup, there you go.

AUDIENCE: Would you say the majority of the input going into CAM is going [INAUDIBLE].

KEVIN ALLEN: I would say across the nation for us it's probably 40%, 50%. Because we still have a lot of call ins, right. I mean, that's just the nature of the beast, right. There's still things that--

AUDIENCE: [INAUDIBLE].

KEVIN ALLEN: Yeah. It's becoming more the norm, I would say.

WILLIAM TUCKER: What was the question?

KEVIN ALLEN: How much is coming from CAD [INAUDIBLE] to the shop versus call ins. About 50% is what--

WILLIAM TUCKER: Won't be long that's going to be very few.

KEVIN ALLEN: Yeah.

WILLIAM TUCKER: Very few call ins.

[INTERPOSING VOICES].

KEVIN ALLEN: Anybody run a remote entry yet?

AUDIENCE: It's on our list to do.

KEVIN ALLEN: It's on your list to do. OK, so we rolled out remote entry the last quarter to three different operating companies ourselves. After what I saw this week, I'm hoping that there will be some improvements to that that will streamline that process. OK? I have to leave it at that, because I can't really go into a lot of detail on where that's at. But it could become a very user friendly tool in the near future.

WILLIAM TUCKER: It's got it's little quirks right now, but we still feel like that it's-- where it is right now today, it's still better than the alternative.

AUDIENCE: Ultimately the [INAUDIBLE].

KEVIN ALLEN: Currently today it's an REJ file, which is a remote entry job, versus a MAJ coming from CAD. But same information, right. It's the exact same data.