31 May 2010

After much research into the subject of Macros, I was able to come up with a sequence of programming codes that will extract as well as show inputs provided by the user, perform calculations on those values and generate those arithmetic results. That sequence of codes that I had created basically covered all the theoretical evaluation part of the project that I had already completed, which is the feasibility of implementing upbent lead frames for SOT363F products. It proved to be a success as the string of results generated based of the same set of parameters considered for my project are exactly the same as those obtained by my hand calculations which are showed coherently in my project report. Nonetheless, I did not dwell on that success and strive to refine and add more features to my Excel program such as pop-up diagrams accompanying prompt input box to enhance user’s understanding of the value being referred to. Besides that, I am also working on providing additional comments on results generated. For instance, if the distance between the capillary and the die is less than zero, a message of “cracked die” will be shown.