Working with eCabinets cut list in excel

Moderators: Jason Susnjara, Larry Epplin, Clint Buechlein, Scott G Vaal

Scott Marshburn
Guru Member
Posts: 744
Joined: Sat, Mar 05 2011, 7:29AM
Company Name: Heritage WoodWorks
Country: UNITED STATES
Location: Jacksonville Nc
Contact:

Working with eCabinets cut list in excel

Postby Scott Marshburn » Sat, May 30 2015, 1:22PM

I have cool trick on how you can automatically add macro buttons to your excel workbook that ecabinets generates when you export cut list to excel.
Here is a link to a video that I made if you want to check it out.
https://youtu.be/jdOmtxfIktw
Yes! Oh Yes! I Think We Are Going to make It!
https://www.youtube.com/user/ecabinetstips

User avatar
Brad McIntosh
Guru Member
Posts: 482
Joined: Wed, May 18 2005, 6:59PM
Company Name: CNC Automation
Location: St. Zotique, Québec, Canada
Contact:

Re: Working with eCabinets cut list in excel

Postby Brad McIntosh » Mon, Jun 01 2015, 11:40AM

Thank you Scott!

Scott Marshburn
Guru Member
Posts: 744
Joined: Sat, Mar 05 2011, 7:29AM
Company Name: Heritage WoodWorks
Country: UNITED STATES
Location: Jacksonville Nc
Contact:

Re: Working with eCabinets cut list in excel

Postby Scott Marshburn » Mon, Jun 01 2015, 4:11PM

Thank you Brad for the reply!
Yes! Oh Yes! I Think We Are Going to make It!
https://www.youtube.com/user/ecabinetstips

Scott Marshburn
Guru Member
Posts: 744
Joined: Sat, Mar 05 2011, 7:29AM
Company Name: Heritage WoodWorks
Country: UNITED STATES
Location: Jacksonville Nc
Contact:

Re: Working with eCabinets cut list in excel

Postby Scott Marshburn » Fri, Sep 04 2015, 5:54PM

So. I have been working on a few videos lately about how to select the different worksheets from the excel workbook that it generates when you export their cut list into excel. I have 3 videos so far on how you can create a master workbook with a user form that will allow you to select any or all of the worksheets from the eCabinets workbook and then Import them into the master workbook.

Here are the links to check them out. If you are Interested

Create a userform to import worksheets from eCabinets excel cutlist into a master workbook part 1
https://youtu.be/9yI2xO2z_0o

Create a userform to import worksheets from eCabinets excel cutlist into a master workbook part 2
https://youtu.be/aeWbLr2fodU

Create a userform to import worksheets from eCabinets excel cutlist into a master workbook part 3
https://youtu.be/OzLXQTv2f38
Yes! Oh Yes! I Think We Are Going to make It!
https://www.youtube.com/user/ecabinetstips

User avatar
Neville Bastian
Guru Member
Posts: 589
Joined: Fri, May 20 2005, 6:48PM
Company Name: Classic Cabinetry
Location: Albany Western Australia
Contact:

Re: Working with eCabinets cut list in excel

Postby Neville Bastian » Sun, Sep 06 2015, 7:53PM

Hi Scott
Thanks for sharing that Video. A feature I was unaware of.
I looked through your other videos as I was hoping you may have done something with proposal/quotes using Ecabinets. The proposal side of Ecabinets is lacking a bit of flexability and hasnt been on the improvement hitlist of the programmers.
If you have something you use to extract the data to do your quotes I would like to see that.

Regards

Neville
Neville Australia

Scott Marshburn
Guru Member
Posts: 744
Joined: Sat, Mar 05 2011, 7:29AM
Company Name: Heritage WoodWorks
Country: UNITED STATES
Location: Jacksonville Nc
Contact:

Re: Working with eCabinets cut list in excel

Postby Scott Marshburn » Mon, Sep 07 2015, 6:07AM

Hi Neville. Thanks for the reply.
That is a good Idea I will look into that. Are you wanting to modify the actual proposal that eCabinets generates? If so I think that you can save that file. Then open it in word and modify it there. If you are wanting to develop your own proposal using the data from the excel workbook. I am sure that can be done also. However I have not attempted that. I do use it to create finish estimates and purchase orders based on the data in the cutlist workbook that eCabinets generates.
I have a video where I create a cabinet size report from the SheetComponentListing. I use something similar to calculate the amount of finish needed for a given job.
Here is the link for that video.
https://youtu.be/ks9SCtd1jkY
Yes! Oh Yes! I Think We Are Going to make It!
https://www.youtube.com/user/ecabinetstips

User avatar
Neville Bastian
Guru Member
Posts: 589
Joined: Fri, May 20 2005, 6:48PM
Company Name: Classic Cabinetry
Location: Albany Western Australia
Contact:

Re: Working with eCabinets cut list in excel

Postby Neville Bastian » Mon, Sep 07 2015, 9:47PM

Thanks Scott. Wow it’s great to see someone so familiar with Excel Macros.
With Ecabinets proposal we don’t use it for clients benefit but for our calculations. We just want to know the materials required and labour estimated. With the cut list you could obtain information that would create information to be used. For example you could apply times to process parts. Time to edge based on edged lengths. Assembly based on cabinet size or type, Time to cut and fit doors based on door size and quantity. You get the picture we all have stages we construct so if you take it from the Thermwood or in some cases the saw right through to loading it on the truck. If you had the zip code you could even get the travelling cost. The lengths of all the modules would give you the lineal meters or feet of boxes and then apply a install cost.
Maybe hardware applying might be harder but edge tape should not be hard, fasteners, hinges based on door quantity etc.
The good part might be doors which can be a pain when people want a few alternatives. That could be a quick pulldown box with different doors listed.
Really Scott it could be a program you could charge for if you had enough interest. If people want them modified they could do that themselves or have you build in their personal quirks. Hope I haven’t broken any rules on the forum mentioning money but it is reference to excel not Ecabinets.

All the best

Neville
Neville Australia

Scott Marshburn
Guru Member
Posts: 744
Joined: Sat, Mar 05 2011, 7:29AM
Company Name: Heritage WoodWorks
Country: UNITED STATES
Location: Jacksonville Nc
Contact:

Re: Working with eCabinets cut list in excel

Postby Scott Marshburn » Tue, Sep 08 2015, 5:09AM

Thanks Neville for the feedback. Your suggestion is defiantly possible.
I am curious as to how other members would like to use this cutlist that eCabinets generates.
Yes! Oh Yes! I Think We Are Going to make It!
https://www.youtube.com/user/ecabinetstips

User avatar
Neville Bastian
Guru Member
Posts: 589
Joined: Fri, May 20 2005, 6:48PM
Company Name: Classic Cabinetry
Location: Albany Western Australia
Contact:

Re: Working with eCabinets cut list in excel

Postby Neville Bastian » Tue, Sep 08 2015, 8:31PM

Scott, maybe the question should be how many people generate their proposals through ecabinets module. If they would like do so,what is holding them back. There was a thread on this a couple of years back on what improvements people would like to happen.
Regards

Neville
Neville Australia

Scott Marshburn
Guru Member
Posts: 744
Joined: Sat, Mar 05 2011, 7:29AM
Company Name: Heritage WoodWorks
Country: UNITED STATES
Location: Jacksonville Nc
Contact:

Re: Working with eCabinets cut list in excel

Postby Scott Marshburn » Thu, Sep 10 2015, 6:40PM

So here is the final video on how to make a user form that will allow you to import the selected worksheets from eCabinets excel workbook into a master workbook. This video will show you how to program the delete selected worksheets button. here is the link If you want to check it out.
https://youtu.be/lr0EnPZlWDY
Yes! Oh Yes! I Think We Are Going to make It!
https://www.youtube.com/user/ecabinetstips

Scott Marshburn
Guru Member
Posts: 744
Joined: Sat, Mar 05 2011, 7:29AM
Company Name: Heritage WoodWorks
Country: UNITED STATES
Location: Jacksonville Nc
Contact:

Re: Working with eCabinets cut list in excel

Postby Scott Marshburn » Sun, Sep 27 2015, 2:11PM

Hello everyone here is my latest video on working with eCabinets cut list in excel.

In this video I show you how you can make a excel user form that will automatically create a check box for all of the visible worksheets in the master workbook that I am building that will allow you to select the ones that you wish to print
.
Here is the link if you would like to check it out.
https://youtu.be/_J3GPs0wv-o
Yes! Oh Yes! I Think We Are Going to make It!
https://www.youtube.com/user/ecabinetstips

Scott Marshburn
Guru Member
Posts: 744
Joined: Sat, Mar 05 2011, 7:29AM
Company Name: Heritage WoodWorks
Country: UNITED STATES
Location: Jacksonville Nc
Contact:

Re: Working with eCabinets cut list in excel

Postby Scott Marshburn » Tue, Oct 06 2015, 4:41PM

So here is the final video on how you can make a excel user form that will allow you to print the worksheets that you select.

Check it out and let me Know what you think.
https://youtu.be/okUv5E5Uj14
Yes! Oh Yes! I Think We Are Going to make It!
https://www.youtube.com/user/ecabinetstips

Jim Bullis
Thermwood Sales
Posts: 9
Joined: Mon, Feb 22 2010, 10:32AM
Company Name: Thermwood Corporation

Re: Working with eCabinets cut list in excel

Postby Jim Bullis » Fri, Oct 09 2015, 7:20AM

Great stuff Scott, thanks for sharing!

Scott Marshburn
Guru Member
Posts: 744
Joined: Sat, Mar 05 2011, 7:29AM
Company Name: Heritage WoodWorks
Country: UNITED STATES
Location: Jacksonville Nc
Contact:

Re: Working with eCabinets cut list in excel

Postby Scott Marshburn » Fri, Oct 09 2015, 11:01AM

Thank you Sir for the feedback
Yes! Oh Yes! I Think We Are Going to make It!
https://www.youtube.com/user/ecabinetstips

Scott Marshburn
Guru Member
Posts: 744
Joined: Sat, Mar 05 2011, 7:29AM
Company Name: Heritage WoodWorks
Country: UNITED STATES
Location: Jacksonville Nc
Contact:

Re: Working with eCabinets cut list in excel

Postby Scott Marshburn » Mon, Oct 12 2015, 6:16AM

Here is a quick video on how to use the advanced filter and SumIfs to summarize your eCabinets Cut list in excel.
https://youtu.be/2Duh78jZtjY
I will be doing two videos on how to do this. These videos are to prepare you for the series that I will be doing on modifying the five piece door break down from the eCabinets excel workbook.
In the next video I will show you how to do the same thing in VBA.
Here is a link to download the workbook if you want to follow along.
https://www.dropbox.com/s/tf0m4owfsth9b ... .xlsb?dl=0
Yes! Oh Yes! I Think We Are Going to make It!
https://www.youtube.com/user/ecabinetstips


Return to “eCabinet Systems Software”

Who is online

Users browsing this forum: No registered users and 12 guests