Skip to main content

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.

Comments

Post a Comment

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...
1 comment
Read more

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 ...
1 comment
Read more