Leave your brain on the desk when you go
Leave your brain on the desk when you go
(OP)
So I am leaving my company at the end of the week.
I was asked to write up a guide on all the excel programs I made and all the facility projects I am working on. I have nothing wrong with this –they are the property of the company- and fully want the next person to be up to speed with this position and what has been done and what can be done.
I wrote a number of excel programs, and have no problem with someone learning them and then using them. My concern is that someone will use them without understanding their limitations and even if I make a guide explaining them. The major one is a guy which was demoted from an engineer position to a sales position for making some decisions which where against Code, just ignorant, and bad. As most of you know, you don't get demoted for making one mistake... he has repeatedly made mistakes and ignored basic concepts. I was given complete oversight of all his projects to prevent any projects being released that could have problems. Because of this I also know he really wants to do "engineering" and may try to do it after I leave.
What do you guys normally do with information which is only known to you?
Thanks
I was asked to write up a guide on all the excel programs I made and all the facility projects I am working on. I have nothing wrong with this –they are the property of the company- and fully want the next person to be up to speed with this position and what has been done and what can be done.
I wrote a number of excel programs, and have no problem with someone learning them and then using them. My concern is that someone will use them without understanding their limitations and even if I make a guide explaining them. The major one is a guy which was demoted from an engineer position to a sales position for making some decisions which where against Code, just ignorant, and bad. As most of you know, you don't get demoted for making one mistake... he has repeatedly made mistakes and ignored basic concepts. I was given complete oversight of all his projects to prevent any projects being released that could have problems. Because of this I also know he really wants to do "engineering" and may try to do it after I leave.
What do you guys normally do with information which is only known to you?
Thanks





RE: Leave your brain on the desk when you go
RE: Leave your brain on the desk when you go
I suggest, however, adding in to the "comment" section of the Excel files (File->Properties, or something like that) that the program was created by you and should only be used by people appropriately trained in its use, results are not guaranteed to fit any specific set of rules and are meant to be a rough guideline only, etc. Do what you can to document the stuff, but don't work yourself to death doing it unless they intend to pay you overtime for the work (and they may want to if the tools are that helpful).
Dan - Owner

http://www.Hi-TecDesigns.com
RE: Leave your brain on the desk when you go
TTFN
FAQ731-376: Eng-Tips.com Forum Policies
RE: Leave your brain on the desk when you go
Just good business practice would compel me to certainly sit down with some individual or individuals and go over each project that is still active.
To help in this process, I'd put together a memo that outlines each project, a brief description of where it is currently at, some past important design issues, concerns, etc. Also state, forward looking, any upcoming concerns or issues you see developing.
The memo can also serve to clarify what you were and were not responsible for in terms of past errors or difficulties in the project process.
For the spreadsheets:
I'd second what macgyvers2000 states and I'd simply put together a list of the spreadsheets that you wrote and then at the bottom of the list write this:
These spreadsheets were developed by me over the course of ______ years and were design tools that I used on various projects. Use of these spreadsheets is at the users risk. The contents, logical flows, and algorithms utilized require special engineering skills and require complete familiarity with the spreadsheet's contents and limitations. No warranty is stated or implied that the spreadsheet is correct or without errors.
If the firm asks you for more than this you just simply have to refuse. Not because you don't want to cooperate but because anything beyond this is really impossible.
RE: Leave your brain on the desk when you go
RE: Leave your brain on the desk when you go
So if someone what's to use them they will have to look up the equations to know what the variables are. And hopefully learn about the program in the process.
I will talk to my boss when I can catch him in his office about protecting the programs.
RE: Leave your brain on the desk when you go
RE: Leave your brain on the desk when you go
Mike McCann
MMC Engineering
RE: Leave your brain on the desk when you go
Don Phillips
http://worthingtonengineering.com
RE: Leave your brain on the desk when you go
JAE's disclaimer is a great idea that I'm taking to work tomorrow. I might go one step further and add that until the user has reviewed the equations and variables, they should not use the spreadsheet. We've come to be very protective of our spreadsheets because as they grow, it becomes less obvious what things a small change may impact. Ideally, adding numerous comments to your sheet may help avoid some of this "summary work" in the future, but even as I suggest it, I'm guilty of not writing enough documentation.
You may consider an occasional email to your ex-boss to check if he needs any assistance with historical knowledge.
Good luck with your new job...
RE: Leave your brain on the desk when you go
It sounds like your company was happy to let you write your own "programs" and use them on company work undocumented. So the current problem is down to a lack of QA in your company. Not yours. It could be argued that the ubiquity of Excel is to blame. Untraceable, undocumentable (is that a word?).
I don't know what business the company is in, but when the plane crashes or the bridge collapses, investigators often want to dig deep into any software that was used at the time. "Err, some undocumented Excel spreadsheet I think" doesn't sound good in court.
- Steve
RE: Leave your brain on the desk when you go
Then I talked my boss into making an "Engineering Control and Release Form," basically a cover page which shows a summery of a project. Then have a hard copy of all the work in an "Engineering Log."
I was also trying to get the IT department to better QA for all engineering computer files.
I could write a 100page document about all the problems with the engineering program here but that's for another day.
I thought about just moving it to a place where it would just drift into nothingness computer land... by the time someone found it they would have no idea what it is...
RE: Leave your brain on the desk when you go
"Art without engineering is dreaming; Engineering without art is calculating."
Have you read FAQ731-376: Eng-Tips.com Forum Policies to make the best use of Eng-Tips Forums?
RE: Leave your brain on the desk when you go
I'd also suggest going into Properties in each spreadsheet and making sure that your name is not on there as the Author.
RE: Leave your brain on the desk when you go
MAD, we have to keep everything in the "engineering" drive on our server, so the file is not local.
What I currently have set up so everything is password protected and there are hyperlinks to my "Guide" for the programs. Hidden in the guide is the password.
So if someone takes the time to read the guide, they get access to the programs.
I just had an engineer from another company stop by my office and I asked him what he thought, his advice was... even $6000 FEA programs can be dangerous in the wrong hands. Technically its the companies responsibility to hire someone that is competent enough to use his judgment.
RE: Leave your brain on the desk when you go
TTFN
FAQ731-376: Eng-Tips.com Forum Policies
RE: Leave your brain on the desk when you go
- Steve
RE: Leave your brain on the desk when you go
TTFN
FAQ731-376: Eng-Tips.com Forum Policies
RE: Leave your brain on the desk when you go
SG, currently the configuration management setup is much better then it was. Actually hard copies of all designs and calculations in files, is a great start! I feel I have done more here than has been done in 12 yrs.
The problem here is the boss doesn't understand engineering.
One of the things that set me off to leaving is when i was reprimanded for taking the time to produce all the drawings for a particular design and making them as correct as possible, which takes more time then the last engineer.
My boss was like "How is it taking you so long to do these designs, Keith could have these done in a day, all he used to do was just use one drawing and stretch it. Then Mark (the machinist) would fix all the problems in the shop"
I asked my boss "what happens if Mark dies in a freak accident, who's going to fix all the mistakes?"
My boss just said " I dont know, just have this done by the end of the day."
This conversation was after numerous discussions with him stressing the importance of having correct designs on file, not only for simple manufacturing, simple duplication, but CYA. Some people just don't get it.
I can't wait to actually work with engineers and have a boss that's an engineer! and of course the raise is nice to.
RE: Leave your brain on the desk when you go
RE: Leave your brain on the desk when you go
I am just looking forward to my long weekend and starting my new job!
RE: Leave your brain on the desk when you go
Congratulations on getting your new job. Although we would all like to forget our soon-to-be former employers, you never know when you may need a reference (which I needed from 3 previous employers when I went for additional PE Licenses). Its usually best to leave on as good terms as you can, even when they don't deserve it.
RE: Leave your brain on the desk when you go
- Steve