Loving the conversation. Thank you all for sharing our opinions, insights, and experiences. One clarification I want to make is that I was asking about 'toolboxes' of individual employees--not the companies 'toolbox'. Regardless, I think the conversation has touched on both.
I will add to this that all 3 companies I've worked at over the last 7 years, I've had co-workers who had hard-drives worth of pdfs and excel design files from their previous companies. Those same companies ALSO had design excel files AND typical details from the companies that the owners previously worked at! This is consistent with many experiences noted below
One further question---has anyone employed a file audit/tracking software to track file copying, etc of employees? or vice versa--worked somewhere that did this.
phamENG said:
1) If you want to build an excel sheet to help you with some repetitive task, that's fine. But keep the company name OFF of it. Do NOT use it for produce calculation submittals.
milkshakelake said:
If any new calculation tools or details are developed, they are started by management, not as an initiative from an employee. The employee can make a suggestion that something needs to be improved or a certain calculation should be made, but they don't do it on their own. It's just a massive liability. Junior employees in particular don't have a big picture view of how the company is run, how to make an efficient and usable calculation, how to test it, etc.
Response to both above:
Yes and no. Spreadsheets that do a simple/single calculation are more akin and just as prone to errors as hand calcs. I make a spreadsheet of varying sizes for many of my projects--given, I think I've had much less projects that have not had unique aspects than projects that have had unique aspects (probably due to the companies I've worked at, and my <10 yrs in structural eng), and required new calcs that made sense to put into a spreadsheet (for design iteration or a future design tool). In agreement with you, I would say that large/complex spreadsheets that try to do a lot are significantly harder to vet. @milkshakelake, companies should have a stringent vetting process for standardized spreadsheets that they tell all employees "this spreadsheet is correct and is open for use!"..which should really mean the user needs not check as many parts of it as they would if they received a design spreadsheet from a coworker that wasn't fully vetted, but they generally trusted that co-worker.
Related, I agree with greglocock below:
greglocock said:
If any new calculation tools or details are developed, they are started by management, not as an initiative from an employee." Not necessarily in large companies, a fair amount is done under the radar by (typically) senior engineers chatting to each other. Of course things can get a bit political when it turns into a science project (my favorite projects) and absorbs significant hours.
Continuing..
phamENG said:
As far as exporting them to another company...yeah, don't do that. At least not the raw files. Not the CAD files or the Revit Templates/families. Not the actual spreadsheets. It's easy to get your hands on a PDF of something...if you want to copy my detail, so be it. But you'd better take the time to actually draw it yourself.
This seems like a reasonable piece of advice for an engineer tyring to build their toolbox (which also have design tools/spreadsheets, rules of thumbs, design tables, etc)
dvd said:
You are assuming a one-way door of everything leaking out, what about all of the tools that arrive with an experienced hand, that you haven't paid to develop?
This is a good point, but I wonder if that "hypocritical" mindset has an impact on the owner's decision or sense of ethics? They still may want to do their best to keep a close hold on their design tools.
phamENG said:
Sure, my details are based on the general knowledge I've inherited and the body of identical details floating around all of the firms in the area (I think most of the founders of the major regional players worked at the same firm at one point).
Same goes for the region I was working in for the past 6 years (until recently)