My current employer is transitioning to SW (from 2d) and I was hoping somebody offer some advise, tips, or knowledge.
We use a lot of parts defined within assemblies. Virtual parts works great for this. I can define the part within an assembly and mate it, but it doesn't require it's own part...
I'm having trouble finding a supplier for the following item:
Black iron cross fitting for 1-1/2" Schedule 40 pipe, butt-weld connection.
I was able to find a socket-weld on McMaster Carr, but that was nearly $50 each. Our customer has requested these be used in construction of some guarding...
Is there a way to change the default settings for formatting of cells in a worksheet? The settings I would like to be able to change are:
Cell vertical text alignment to centered (default is bottom)
Column width of all columns to 10
Row height of 15
Is it possible to have these settings...
Greetings,
I know that many aspects of P.E. licensing have been covered in-depth. If the answer is out there, please point me to it! Or if this topic is more appropriate in a different forum, please suggest which one.
I currently am an EIT and working in an exempt industry where a PE license...
Is it possible to get data from multiple files into a single "Summary" book? I was trying to create a form for estimating purposes. Some of our projects are quite large and broken into parts A, B, C, etc...
So, I wanted to make a folder for estimating that would contain one file "Project.xls"...
Greetings,
I am a younger engineer, about 3 years experience. I have in the past year started managing my own projects for equipment design.
I am currently working with a customer on a machine that was installed. The customer is constantly wanting things "tweaked" to work just the way they...
Hello All,
I have a spreadsheet with different projects listed. The spreadsheet has columns for "Due Date" and "Progress". I would like the cell for "Due Date" to have a red background if the project is past today's date AND the Progress is not listed as "Complete." However, while I can write...
I started this thread because there have been a number of threads recently that have touched on the level of knowledge and abilities of new graduates. What would you suggest for improving the quality of new graduates so they are able to hit the ground running and succeed?
Some ideas:
- Hire...
Is there a way to have a toggle button or drop-down list of some kind that would allow either manual entry or a lookup value? I have never used VBA, so excel formulas would definately make me happier, but I don't know that it can be done.
Basically, say I wanted to create a spreadsheet for...
Greetings all,
I have an application where I need to look at a Ampco bronze bushing to determine the life. I have determined the static loading and verified that the material will not yield. However, I am looking to see how much wear can be expected.
First off, I have an equation for the...
I have a combustion chamber and would like to design duct work for capturing exhaust. I have the volume flow rate (in CFM) of the exhaust gases, size of the exit from the chamber, and temperature of the gases. I am assuming that the gases have the same properties as air (i.e. ideal gas, gas...
