Say I have a column of cells, some saying "open", some saying "closed" that are AutoFiltered. I want to know if it is possible to have a cell that displays which filter was selected with the pull down. So I can say "displying: XXXXX jobs" in a cell near the top so people know the sheet is...
Can anyone share with me their success/horror stories on doing their own PTFE coatings? I'm trying to do in-house PTFE coatings on beryllium copper bushings for journal bearings. Any recommended suppliers for buying the spray? Can we get .001 +/- .0002 thick by doing it at our plant?
Thank you!
Is there a way to have your arguments displayed when typing in a custom function into excel? For example when you type =if(... excel will show a tool tip showing =if(logical_test, [value if true], [value if false]...
thank you
I have a thrust washer which is between a housing and a shaft, with a pilot pin locating in the center. The shaft is 1.452" in diameter, and is turning between 100-200rpm. There is roughly a 5250# axial load pushing against the housing into the thrust washer. We keep the the thrust washers...
I found that under options->display the setting for "create viewports in layouts" was not checked. I tried changing this in the acad.dwt file, but still every time I create a new layout in an existing file it doesn't have a viewport on it.
Any ideas how I can set this option globally?
The current bearing I'm dealing with is produced in house, and is made in a variety of sizes. The bearing is a multiple piece unit which incorporates a bushing, thrust washer, and a ball race (which retains our stationary peice to our peice in motion).
The bushing (kinda a misnomer, we just...