These are projects posted by the students of Dr. Gove Allen at Brigham Young University. These students have taken one semester-long course on VBA and generally have had no prior programming experience

Monday, April 12, 2010

MyData info parser - Jeff Baxter - Winter 2010

Circuit board manufacturers are paid to put capacitors, resistors, inductors and ICs onto circuit boards. Their revenue is tightly coupled to the quantity of parts that they can put on boards in an hour. The equipment they use to put parts on to boards is called placement equipment. The MyData brand of placement equipment is used by a local circuit board manufacturer (see image to the right) and this machine stores a record of each time it places a part on a board. The business owner wants a way to display how many mounts are happening on this machine each hour. He would like a chart that displays the output of the machine over time.

Here is the report of how I did this, in .PDF format.
Here is the excel file that creates these placement summaries.

No comments:

Post a Comment

Blog Archive