Working with eCabinets cut list in excel
Moderators: Jason Susnjara, Larry Epplin, Clint Buechlein, Scott G Vaal
-
- Guru Member
- Posts: 838
- 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
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
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
https://www.facebook.com/groups/397563664342467
https://www.youtube.com/user/ecabinetstips
https://www.facebook.com/groups/397563664342467
-
- Guru Member
- Posts: 559
- Joined: Wed, May 18 2005, 6:59PM
- Company Name: CNC Automation
- Country: CANADA
- Location: St. Zotique, Québec, Canada
- Contact:
Re: Working with eCabinets cut list in excel
Thank you Scott!
-
- Guru Member
- Posts: 838
- 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
Thank you Brad for the reply!
Yes! Oh Yes! I Think We Are Going to make It!
https://www.youtube.com/user/ecabinetstips
https://www.facebook.com/groups/397563664342467
https://www.youtube.com/user/ecabinetstips
https://www.facebook.com/groups/397563664342467
-
- Guru Member
- Posts: 838
- 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
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
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
https://www.facebook.com/groups/397563664342467
https://www.youtube.com/user/ecabinetstips
https://www.facebook.com/groups/397563664342467
-
- Guru Member
- Posts: 622
- Joined: Fri, May 20 2005, 6:48PM
- Company Name: Classic Cabinetry
- Location: Albany Western Australia
- Contact:
Re: Working with eCabinets cut list in excel
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
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
-
- Guru Member
- Posts: 838
- 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
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
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
https://www.facebook.com/groups/397563664342467
https://www.youtube.com/user/ecabinetstips
https://www.facebook.com/groups/397563664342467
-
- Guru Member
- Posts: 622
- Joined: Fri, May 20 2005, 6:48PM
- Company Name: Classic Cabinetry
- Location: Albany Western Australia
- Contact:
Re: Working with eCabinets cut list in excel
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
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
-
- Guru Member
- Posts: 838
- 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
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.
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
https://www.facebook.com/groups/397563664342467
https://www.youtube.com/user/ecabinetstips
https://www.facebook.com/groups/397563664342467
-
- Guru Member
- Posts: 622
- Joined: Fri, May 20 2005, 6:48PM
- Company Name: Classic Cabinetry
- Location: Albany Western Australia
- Contact:
Re: Working with eCabinets cut list in excel
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
Regards
Neville
Neville Australia
-
- Guru Member
- Posts: 838
- 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
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
https://youtu.be/lr0EnPZlWDY
Yes! Oh Yes! I Think We Are Going to make It!
https://www.youtube.com/user/ecabinetstips
https://www.facebook.com/groups/397563664342467
https://www.youtube.com/user/ecabinetstips
https://www.facebook.com/groups/397563664342467
-
- Guru Member
- Posts: 838
- 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
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
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
https://www.facebook.com/groups/397563664342467
https://www.youtube.com/user/ecabinetstips
https://www.facebook.com/groups/397563664342467
-
- Guru Member
- Posts: 838
- 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
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
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
https://www.facebook.com/groups/397563664342467
https://www.youtube.com/user/ecabinetstips
https://www.facebook.com/groups/397563664342467
-
- Thermwood Sales
- Posts: 18
- Joined: Mon, Feb 22 2010, 10:32AM
- Company Name: Thermwood Corporation
Re: Working with eCabinets cut list in excel
Great stuff Scott, thanks for sharing!
-
- Guru Member
- Posts: 838
- 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
Thank you Sir for the feedback
Yes! Oh Yes! I Think We Are Going to make It!
https://www.youtube.com/user/ecabinetstips
https://www.facebook.com/groups/397563664342467
https://www.youtube.com/user/ecabinetstips
https://www.facebook.com/groups/397563664342467
-
- Guru Member
- Posts: 838
- 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
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
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
https://www.facebook.com/groups/397563664342467
https://www.youtube.com/user/ecabinetstips
https://www.facebook.com/groups/397563664342467