cabinet part list into excel
Moderators: Jason Susnjara, Larry Epplin, Clint Buechlein, Scott G Vaal
-
- Junior Member
- Posts: 69
- Joined: Tue, May 19 2015, 7:44PM
- Company Name: Classic Cabinetry
- Country: AUSTRALIA
cabinet part list into excel
hi, ive searched this forum and not sure if ive missed a post that might explain how to do it.
we do flatpack kitchens and are wanting to be able to print out detailed sheet of each cabinet and what parts are required
for that cabinet e.g lh end, back, deck, top rail etc. to make it easier for the person working on collating the job parts.
basically we are trying to simplify the job of collating parts so we can get junior workers to be able to look at the sheet and say this is all i need for this cabinet.
any help would be much appreciated.
thanks
we do flatpack kitchens and are wanting to be able to print out detailed sheet of each cabinet and what parts are required
for that cabinet e.g lh end, back, deck, top rail etc. to make it easier for the person working on collating the job parts.
basically we are trying to simplify the job of collating parts so we can get junior workers to be able to look at the sheet and say this is all i need for this cabinet.
any help would be much appreciated.
thanks
-
- eCabinets Beta Tester
- Posts: 1740
- Joined: Tue, May 17 2005, 8:33PM
- Company Name: Timeless Cabinetry and Mantles
- Location: South East
Re: cabinet part list into excel
Chris,
If I understand you wanting to export your cut list to Excel, is easy with a click of the button between the Line Drawing Editor and CNC output button.
However, I think your question is probably relative to how to separate items of like kind, once you do export the file. That will be done using Macros. Each "shop" will need their own unique macro to separate items of like kind and sort them into sizes.
There is some great videos on YouTube from Scott @ eCabinets tips and tricks regarding the filters and macros. Again you will have to customize to your own needs so the videos will just help you get started.
https://www.youtube.com/watch?v=jfalIKPZ1U0
https://www.youtube.com/watch?v=2Duh78jZtjY
https://www.youtube.com/watch?v=7lh_fgZ7VSo
Hope this helps
If I understand you wanting to export your cut list to Excel, is easy with a click of the button between the Line Drawing Editor and CNC output button.
However, I think your question is probably relative to how to separate items of like kind, once you do export the file. That will be done using Macros. Each "shop" will need their own unique macro to separate items of like kind and sort them into sizes.
There is some great videos on YouTube from Scott @ eCabinets tips and tricks regarding the filters and macros. Again you will have to customize to your own needs so the videos will just help you get started.
https://www.youtube.com/watch?v=jfalIKPZ1U0
https://www.youtube.com/watch?v=2Duh78jZtjY
https://www.youtube.com/watch?v=7lh_fgZ7VSo
Hope this helps
Intel Core i7-5820K (6-Cores, 3.3GHz, 15MB Cache)
32Gigs DDR4
NVIDIA GeForce GTX 960 4GB
SSD 840 256Gig, 2TB, 3TB, Samsung (2TB)
Corsair RM650
32Gigs DDR4
NVIDIA GeForce GTX 960 4GB
SSD 840 256Gig, 2TB, 3TB, Samsung (2TB)
Corsair RM650
-
- Junior Member
- Posts: 69
- Joined: Tue, May 19 2015, 7:44PM
- Company Name: Classic Cabinetry
- Country: AUSTRALIA
Re: cabinet part list into excel
Thats fine i can see on his version of excel there are tabs to choose from, on my version there isnt any tabs so i cant go to sheet components as he is instruction to do.
-
- eCabinets Beta Tester
- Posts: 1740
- Joined: Tue, May 17 2005, 8:33PM
- Company Name: Timeless Cabinetry and Mantles
- Location: South East
Re: cabinet part list into excel
What version are you using? You can install OPEN OFFICE. This will also open in tabs.
https://openoffice.apache.org/
https://openoffice.apache.org/
Intel Core i7-5820K (6-Cores, 3.3GHz, 15MB Cache)
32Gigs DDR4
NVIDIA GeForce GTX 960 4GB
SSD 840 256Gig, 2TB, 3TB, Samsung (2TB)
Corsair RM650
32Gigs DDR4
NVIDIA GeForce GTX 960 4GB
SSD 840 256Gig, 2TB, 3TB, Samsung (2TB)
Corsair RM650
-
- Guru Member
- Posts: 322
- Joined: Thu, Nov 29 2007, 5:18PM
- Company Name: Tim Lucas Custom Woodworks LLC
- Country: UNITED STATES
- Location: bell, florida
- Contact:
Re: cabinet part list into excel
Chris,Chris Armstrong wrote:Thats fine i can see on his version of excel there are tabs to choose from, on my version there isnt any tabs so i cant go to sheet components as he is instruction to do.
I have found if I save my file first then open it the tabs are there.
Tim
Tim Lucas Custom Woodworks LLC
www.TLCW.us
www.TLCW.us
-
- Guru Member
- Posts: 837
- Joined: Sat, Mar 05 2011, 7:29AM
- Company Name: Heritage WoodWorks
- Country: UNITED STATES
- Location: Jacksonville Nc
- Contact:
Re: cabinet part list into excel
Try going to Options click on advanced then scroll down to Display options for this workbook. Make sure that you have show sheet tabs checked.Chris Armstrong wrote:Thats fine i can see on his version of excel there are tabs to choose from, on my version there isnt any tabs so i cant go to sheet components as he is instruction to do.
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
-
- Junior Member
- Posts: 69
- Joined: Tue, May 19 2015, 7:44PM
- Company Name: Classic Cabinetry
- Country: AUSTRALIA
Re: cabinet part list into excel
Okay this great, i have worked it out i have written my macro.
when i export cutlist to excel on a different job my macro isnt there. but if i open up the saved cutlist with the macro i made it sorts it out exactly how i want it.
how do i make the macro save so i dont have to keep opening up this one cutlist everytime i want to do this?
appreciate all of your help. am nearly where i want to be just a little further.
when i export cutlist to excel on a different job my macro isnt there. but if i open up the saved cutlist with the macro i made it sorts it out exactly how i want it.
how do i make the macro save so i dont have to keep opening up this one cutlist everytime i want to do this?
appreciate all of your help. am nearly where i want to be just a little further.
-
- Guru Member
- Posts: 837
- Joined: Sat, Mar 05 2011, 7:29AM
- Company Name: Heritage WoodWorks
- Country: UNITED STATES
- Location: Jacksonville Nc
- Contact:
Re: cabinet part list into excel
Hi Chris. Glad to see that you are coming along well. The reason that you have to keep opening the saved job to execute the macros is probably because these macros where stored in the saved workbook. Generally when recording macros I store them in my personal workbook. If you would like to send me both workbooks I think that I can help you with this. You can PM me with the files or email.
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
-
- Junior Member
- Posts: 69
- Joined: Tue, May 19 2015, 7:44PM
- Company Name: Classic Cabinetry
- Country: AUSTRALIA
Re: cabinet part list into excel
you were correcto on this point, i created it in the personal workbook and it worked a treat. thanks for all of you help, i will watch thos videos you sent me in due course to make it even easier but for now i am where i need to be.Scott Marshburn wrote:Hi Chris. Glad to see that you are coming along well. The reason that you have to keep opening the saved job to execute the macros is probably because these macros where stored in the saved workbook. Generally when recording macros I store them in my personal workbook. If you would like to send me both workbooks I think that I can help you with this. You can PM me with the files or email.