Skip to main content

Day 3

I learned more than I ever thought I would need to know about Excel. I learned how to add and lookup pictures with a user search function that my boss was trying to set up. Since I was the one that figured it out I had to fix the spreadsheet and put all the pictures in on a 200-row spreadsheet which was the downside of showing off my programming skills. Once I was labeled as the excel engineer, my boss asked if I link and look up files in the system. There were also jokes about voice command and the spreadsheet talking back after the pictures took me a whole day.

Excel was the extent of my day today, which sounds very boring. However, I was very happy with myself because I got to see where the important time-saving functions come in and I can now add proficient with excel to my resume which will be very helpful in my future.

One of the guys on my team is a process engineer who wrote his thesis on saving time with things like this excel spreadsheet lookup function. As he explained to me, Mark, my boss, looks up apart about 200 times a day when doing quotes, talking on the phone, and checking statuses and the pictures and links save about 30 seconds each time which over the entire project is about $200,000 dollars of work. So, it pays off. I felt useful and I have taken another step towards knowing what I want to do and how my career will play out.

Comments

Popular posts from this blog

Day 2

Today I learned a lot more about organization and documentation. Mark, my program manager, has an excel dashboard program that he uses to easily look up pieces and projects. He can look up jobs by Jedco's part number, the partner's part number, or the part's find number. It gives him back a lot of information about the part including tools used in the process, cost, quote, profit margins, and issues and comments. On one of the parts he was looking it up but none of the information was being brought back. So, in an effort to learn an important skill for engineering jobs and jobs in general, I taught myself Visual Basic, the language behind Excel formulas. At the end of the tutorial I was skimming and after about two hours of reading the code behind Mark's dashboard, I couldn't find any errors so I asked the person who wrote the code about the references and some clarifications about the code just to make sure I was clear on everything. At the end of it all, we realiz...

Day 6

I finished all my work on the individual search forms in excel for each department of my team. Since I got them working all smoothly, the one-stop-shop type dashboard was passed to me to create. It will have links to each individual form, get the data from them so you can see everything in one place. This dashboard will be what I leave with the team with my name on it. There are a lot of challenges that I had to overcome immediately; how to get updated data from other forms, how to search through it neatly, and how to organize the dashboard. I spent a lot of my day organizing my ideas for it and researching how to access data from other forms. This type of stuff is what Microsoft access is for so the hardest part will be hardcoding the function of Microsoft access into Microsoft Excel. I'm excited to create something of my own for the team.

Expectations and Goals

I have known I wanted to be an engineer for a long time. I enjoy problem-solving and have always had excellent spatial reasoning. I began tinkering at a young age with old computers and RC cars. At 11 I ruined one of my RC cars trying to drive it on water. I was still so happy because it skimmed on water for a good three seconds before the frame caught and dragged it down. The only failure was not sealing off the electronics well enough but I was so happy to have done something without a kit or instructions. It was all around fun. I kept going with legos, robots, computer programs, I got to know my way around a wood shop freshmen year and learned about 3d printing and machine guided cutting from CNC machining to laser cutting. As I leave for college I feel completely prepared to tackle any engineering challenge that comes my way. I have a strong base in math and calculus that can only grow in the years to come. And an even stronger base of experience with tinkering and making ...