Looking for Excel BOM tutorial
Looking for Excel BOM tutorial
(OP)
Has anyone run across a good Excel BOM tutorial I would like to set one up for our company.
Running SW 2007.
Thanks
Running SW 2007.
Thanks
When was the last time you drove down the highway without seeing a commercial truck hauling goods?
Download nowINTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS Come Join Us!Are you an
Engineering professional? Join Eng-Tips Forums!
*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail. Posting GuidelinesJobs |
Looking for Excel BOM tutorial
|
RE: Looking for Excel BOM tutorial
RE: Looking for Excel BOM tutorial
http
Heckler
Sr. Mechanical Engineer
SWx 2007 SP 3.0 & Pro/E 2001
XP Pro SP2.0 P4 3.6 GHz, 1GB RAM
NVIDIA Quadro FX 1400
o
_`\(,_
(_)/ (_)
(In reference to David Beckham) "He can't kick with his left foot, he can't tackle, he can't head the ball and he doesn't score many goals. Apart from that, he's all right." -- George Best
RE: Looking for Excel BOM tutorial
I did not find Excel BOMs very complicated. Most of what I have had to learn is various forms of Microsoft Excel abuse.
What do you want to do?
JHH
RE: Looking for Excel BOM tutorial
Do not use Excel BOM’s. SolidWorks lets you use Excel BOM’s, but they do not support it. The SolidWorks table BOM’s are better and easier to use after they are setup.
The problem we had with Excel BOM’s is the equations had to be calculated after every change. Several drafters forgot to double click the BOM and the quantities did not show up. They had to be reprinted several times.
Bradley
SolidWorks Premim 2007 x64 SP3.1
PDM Works, Intel(R) Pentium(R) D CPU
3.00 GHz, 4 GB RAM, Virtual memory 12577 MB, nVidia 3400
RE: Looking for Excel BOM tutorial
I would like to make a series of excel pages that sort the information in different ways for different people as well as interact with other spread sheets. So for purchasing I want the spread sheet to sum up all the sizes organize by type put cost next it, interact with our inventory levels and our scheduling etc etc.
For the a simple case of when you have a BOM larger then one page how do you set that up in solid works? Split the table and put it on two pages? What if you add a bunch of stuff to the first page and it bumps it off the page again?
I only took a brief look at excel BOMS and couldnt get the headings linked to solidworks formulas (They were just written in as data) and decided to ask if there was a guide here before i invested a lot of time into teaching myself how to do it.
Perhaps I should invest more time into learning the excel bom then come back with a specific question.
RE: Looking for Excel BOM tutorial
Jason
UG NX2.02.2 on Win2000 SP3
UG NX4.01.0 on Win2000 SP3
SolidWorks 2007 SP3.1 on WinXP SP2
RE: Looking for Excel BOM tutorial
RE: Looking for Excel BOM tutorial
Sorry if that was unclear.
RE: Looking for Excel BOM tutorial