Last day of the week, last day of the month. 33rd day at SSMC.
Today, I continued with the excel file. I did the tracing of macro programming language again but for the weekly update macro. And what I did yesterday was on the daily update macro. The weekly macro was harder to figure out and understand
As I was having a hard time with the macro programming language, I had decided to ignored it for the time being and turned to the actions that it carried out. For example, some macros were used to sum and count the data values and for these macros, I had been trying to replace them with formula.
And I succeeded! I had managed to replace part of the macro, on summing and counting data functions, using formula. This is also how I realized some macros are not so easily to be replaced. So for these (hard to replace) macros, I have only managed to replace the summing and counting functions using formula.
But I did successfully replace some macro with formula. These are some macros that are used to 'pluck' data from one excel sheet and insert into another.
So to conclude what I've done today, was:
-Replacing some macros to formula
-Replace part of macro to formula
And one question that I'm having after today's work, will the macro speed be faster after the actions that it suppose to carry out were lessen? This is what I really want to find out. And then, I will know whether what I have done will be wasted or not. (^^)
Friday 30 November 2012
Thursday 29 November 2012
Week 7 - 29 Nov 2012 - Thu
32nd day at SSMC.
Today, I received Miss Pascale message on what I can continue for the excel file. She said that I can make some improvement to update the data faster. So I spent my whole day in exploring and trying out.
And to know what improvement can be made to the excel file, I have to understand and know how the data are input into the excel file. So what I have done for the whole of today was to trace the macro programming language to find out how the data are input. The macro programming language was somewhat similar to what I have studied before, Structured Programming. Thus, I was able to somehow figure it out.
I have also done a mind map on how the 2 excel files are link by the macro functions and how the data are taken from excel file A and input into excel file B.
Today, other than the excel files, I have also edited the training guides. As I have discussed it with a colleague, Xu Fang, she had given her comments and objective suggestions as a person who will be using it. So, I had taken her advice and made some changes to the training guides.
After I'm done with the training guides, I had no choice but to switch back to exploring excel files.
And so, one working day left to weekends. Ganbatte!
Today, I received Miss Pascale message on what I can continue for the excel file. She said that I can make some improvement to update the data faster. So I spent my whole day in exploring and trying out.
And to know what improvement can be made to the excel file, I have to understand and know how the data are input into the excel file. So what I have done for the whole of today was to trace the macro programming language to find out how the data are input. The macro programming language was somewhat similar to what I have studied before, Structured Programming. Thus, I was able to somehow figure it out.
I have also done a mind map on how the 2 excel files are link by the macro functions and how the data are taken from excel file A and input into excel file B.
Today, other than the excel files, I have also edited the training guides. As I have discussed it with a colleague, Xu Fang, she had given her comments and objective suggestions as a person who will be using it. So, I had taken her advice and made some changes to the training guides.
After I'm done with the training guides, I had no choice but to switch back to exploring excel files.
And so, one working day left to weekends. Ganbatte!
Wednesday 28 November 2012
Week 7 - 28 Nov 2012 - Wed
31st day at SSMC.
Today, I started my day in trying to replace some formula in the excel file I've mentioned yesterday. I tried some formula that I have used before at first and then carried on to search for other formula that I have never tried before.
However, not much progress was done. I wasn't able to achieve the desired result.
This morning, I have also discussed with our department manager on the training guides that I have done earlier in this week. She wanted me to do the training guides using the SSMC template. So, since I wasn't having much progression in the excel file's formula, I switched to doing the training guides.
After finishing the training guides, I have, no choice but to switch back to the excel file again. This time, I looked back to the tasks I have done previously and finally, after long searching, I realized where I've gone wrong.
I was right to used the correct formula earlier, it's just that I have used it wrongly. I have set the wrong criteria for the right formula.
In the end, I had managed to replace some of the formula. I have also try inserting rolls and columns and the formula were not affected, so I guessed this is considered job done?
Anyway, I reported to Miss Pascale regarding what I've done for the excel file. Now, waiting for further instructions.
Two more days to go. :)
Today, I started my day in trying to replace some formula in the excel file I've mentioned yesterday. I tried some formula that I have used before at first and then carried on to search for other formula that I have never tried before.
However, not much progress was done. I wasn't able to achieve the desired result.
This morning, I have also discussed with our department manager on the training guides that I have done earlier in this week. She wanted me to do the training guides using the SSMC template. So, since I wasn't having much progression in the excel file's formula, I switched to doing the training guides.
After finishing the training guides, I have, no choice but to switch back to the excel file again. This time, I looked back to the tasks I have done previously and finally, after long searching, I realized where I've gone wrong.
I was right to used the correct formula earlier, it's just that I have used it wrongly. I have set the wrong criteria for the right formula.
In the end, I had managed to replace some of the formula. I have also try inserting rolls and columns and the formula were not affected, so I guessed this is considered job done?
Anyway, I reported to Miss Pascale regarding what I've done for the excel file. Now, waiting for further instructions.
Two more days to go. :)
Tuesday 27 November 2012
Week 7 - 27 Nov 2012 - Tue
30th day at SSMC.
Today, I was given a task; to improve an existing excel file. Instead of the existing macro functions, Miss Pascale hopes that I will be able to substitute the macro functions with formula. I was totally clueless in the morning and even after lunch, I was still brainstorming for ideas.
Meanwhile, during my 'brainstorming' session, Miss Pascale had asked me to update 2 reports for her as she needed them urgently. All I have to do is to screenshot some charts that I've created, with data values entered, and update some excel table from 2012 to 2013. After which, paste into the report for updating.
I have also done some miscellaneous tasks and work today. Though I had spent some time on them but I will not list in detail.
Wanted to start my report tonight, but now is kinda late. Guess will postpone to tomorrow then. Wonder if I can really start my report tomorrow. @.@
Today, I was given a task; to improve an existing excel file. Instead of the existing macro functions, Miss Pascale hopes that I will be able to substitute the macro functions with formula. I was totally clueless in the morning and even after lunch, I was still brainstorming for ideas.
Meanwhile, during my 'brainstorming' session, Miss Pascale had asked me to update 2 reports for her as she needed them urgently. All I have to do is to screenshot some charts that I've created, with data values entered, and update some excel table from 2012 to 2013. After which, paste into the report for updating.
I have also done some miscellaneous tasks and work today. Though I had spent some time on them but I will not list in detail.
Wanted to start my report tonight, but now is kinda late. Guess will postpone to tomorrow then. Wonder if I can really start my report tomorrow. @.@
Monday 26 November 2012
Week 7 - 26 Nov 2012 - Mon
29th day at SSMC.
Today, I have done a presentation, not literally one, on the naming conventions of the chart IDs and DCOPs. I should say that I've designed the naming conventions. I've spent almost the whole day doing it as I need to present them in the way that people will understand at one glance.
I've also took the design and layout of the information and content into consideration.
Due to many constraints, I have different versions of the naming convention for the DCOPs. For example, the naming of Ball Room DCOPs are different from the naming of the Test Lab DCOPs. Thus, I have to present them in different ways but the overall has to be similar. This is thr hardest part of all.
It's like the overview for the naming convention of DCOPs has to be one standard way then for each individual location, in their individual slide, they are different.
After I'm done with the naming convention, I've done a training guide on the steps to enter data into the database. Miss Pascale said that I will need to teach the MAs in the fab so I will need a guide for them.
So that's about all for today. Bye bye.
Today, I have done a presentation, not literally one, on the naming conventions of the chart IDs and DCOPs. I should say that I've designed the naming conventions. I've spent almost the whole day doing it as I need to present them in the way that people will understand at one glance.
I've also took the design and layout of the information and content into consideration.
Due to many constraints, I have different versions of the naming convention for the DCOPs. For example, the naming of Ball Room DCOPs are different from the naming of the Test Lab DCOPs. Thus, I have to present them in different ways but the overall has to be similar. This is thr hardest part of all.
It's like the overview for the naming convention of DCOPs has to be one standard way then for each individual location, in their individual slide, they are different.
After I'm done with the naming convention, I've done a training guide on the steps to enter data into the database. Miss Pascale said that I will need to teach the MAs in the fab so I will need a guide for them.
So that's about all for today. Bye bye.
Friday 23 November 2012
Week 6 - 23 Nov 2012 - Fri
28th day at SSMC.
Today, I have finally finished creating the remaining 475 DCOPs. Why 475 and not 477 DCOPs as mentioned in yesterday's post? This is because Miss Pascale has asked me to keep 2 DCOPs for her to practice. :)
Anyway, like I've mentioned yesterday that I have an outdoor task today in the afternoon, the 475 DCOPs was done by 1.40pm as I was supposed to leave by this time. I'm not trying to proud or something but me myself was surprised too.
I feel that I've gotten faster in creating DCOPs, charts and whatever after these few days' training.
Now, the outdoor task I've been mentioning, it's actually a drop test of the wafer containers. However, the boxes failed as the wafers got cracked after the second last test had carried out. The photo below shows the cracked wafers:
That's all for today. Hope the things I shared are interesting.
See you next week. (^^)
Today, I have finally finished creating the remaining 475 DCOPs. Why 475 and not 477 DCOPs as mentioned in yesterday's post? This is because Miss Pascale has asked me to keep 2 DCOPs for her to practice. :)
Anyway, like I've mentioned yesterday that I have an outdoor task today in the afternoon, the 475 DCOPs was done by 1.40pm as I was supposed to leave by this time. I'm not trying to proud or something but me myself was surprised too.
I feel that I've gotten faster in creating DCOPs, charts and whatever after these few days' training.
Now, the outdoor task I've been mentioning, it's actually a drop test of the wafer containers. However, the boxes failed as the wafers got cracked after the second last test had carried out. The photo below shows the cracked wafers:
That's all for today. Hope the things I shared are interesting.
See you next week. (^^)
Thursday 22 November 2012
Week 6 - 22 Nov 2012 - Thu
27th day at SSMC.
Today, I had continue to create the DCOPs and finally, left only 1 chart of DCOPs which is the chart that consists of 546 points. But because I had created some of the DCOPs for that chart previously, so that total number of DCOP I had left today is 477.
Last week, I used 2 days to create 500 plus DCOPs. I hope that by the end of this week, I can finish creating the 1625 DCOPs, 33 charts and 6 OCAP IDs. This means that tomorrow only left the 477 DCOPs.
But, not sure if I can. Tomorrow I have an outdoor task and will need to travel around. Hope to finish the 477 DCOPs in the morning,
All the best to myself for creating the DCOPs and All the best to my friends taking their NAPFA test tomorrow.
Today, I had continue to create the DCOPs and finally, left only 1 chart of DCOPs which is the chart that consists of 546 points. But because I had created some of the DCOPs for that chart previously, so that total number of DCOP I had left today is 477.
Last week, I used 2 days to create 500 plus DCOPs. I hope that by the end of this week, I can finish creating the 1625 DCOPs, 33 charts and 6 OCAP IDs. This means that tomorrow only left the 477 DCOPs.
But, not sure if I can. Tomorrow I have an outdoor task and will need to travel around. Hope to finish the 477 DCOPs in the morning,
All the best to myself for creating the DCOPs and All the best to my friends taking their NAPFA test tomorrow.
Wednesday 21 November 2012
Week 6 - 21 Nov 2012 - Wed
26th day at SSMC.
Today, I have finished creating DCOPs for 11 charts. I'm not sure how many DCOPs I have left, only know that I have 22 charts of DCOPs left.
Another stressful eyes day had past and I get lesser and lesser thing to share. My blog posts are getting shorter and shorter.
Today is Wednesday, half of the week had past. Weekends please come soon. (^^)
Today, I have finished creating DCOPs for 11 charts. I'm not sure how many DCOPs I have left, only know that I have 22 charts of DCOPs left.
Another stressful eyes day had past and I get lesser and lesser thing to share. My blog posts are getting shorter and shorter.
Today is Wednesday, half of the week had past. Weekends please come soon. (^^)
Tuesday 20 November 2012
Week 6 - 20 Nov 2012 - Tue
25th day at SSMC.
Today, I finished creating all the charts and I have also created 1 DCOP for each location. This will, somehow, make my life easier when come to create the 1625 DCOPs.
As I can just simply copy the DCOPs like I've mentioned before, and copying the DCOPs will reduce quite a number of steps.
Although, the creation steps for the DCOPs will be reduced, I still have to stare at the computer for the whole day. It is still very stressful for my eyes.... >.<
How I wish that I can finish creating the DCOPs tomorrow, no more staring at the computer screen... ;P
Anyway, I believe I will have lesser things to share as I will doing the same things until I finish create the DCOPs. My posts should be getting shorter... >.<
Hope to finish the DCOPs soon and get to do new things and to be able to share more things on my blog. (^^)
Today, I finished creating all the charts and I have also created 1 DCOP for each location. This will, somehow, make my life easier when come to create the 1625 DCOPs.
As I can just simply copy the DCOPs like I've mentioned before, and copying the DCOPs will reduce quite a number of steps.
Although, the creation steps for the DCOPs will be reduced, I still have to stare at the computer for the whole day. It is still very stressful for my eyes.... >.<
How I wish that I can finish creating the DCOPs tomorrow, no more staring at the computer screen... ;P
Anyway, I believe I will have lesser things to share as I will doing the same things until I finish create the DCOPs. My posts should be getting shorter... >.<
Hope to finish the DCOPs soon and get to do new things and to be able to share more things on my blog. (^^)
Monday 19 November 2012
Week 6 - 19 Nov 2012 - Mon
24th day at SSMC.
Today, I have finally, officially started creating my charts in the actual production system. I started creating the OCAP IDs, follewed by the charts and finally the DCOPs. However, I only created some of the charts and the related DCOPs and I had quite a lot left. This is pretty obvious, isn't it? How can I finish creating 33 charts and 1625 DCOPs in just one day?
Back to today's story... Before creatingthe OCAP IDs, I kept reminding myself to be extra extra careful when entering the settings required. However, sometimes, things just won't go smoothly like how you want it to be.
For me, a careless mistake made few weeks ago resulted in my first wrong setting for 2 of my OCAP IDs. Previously, I had print-screen the steps in creating the charts, DCOPs and OCAP IDs. As I was referring to the slides that I've done, I pretty much copied what I have recorded few weeks ago. I copied the title of the OCAP ID from what I had set few weeks ago which was not what I should be entering (after discussion with Miss Pascale some time later). Hence, here goes my first mistake.
As I have 'freeze' the OCAP ID, I couldn't do anything about it. It's either I can get the assistance from the IT department to 'unfreeze' the OCAP ID or I can just simply created that of a version two. So I chose the second option.
After this experience, I thought, to myself, that I will not make any mistake. True enough, I have smoothly created my charts for the particle section.
However, another careless mistake was done, again, when I'm creating the DCOP for the particle charts.
I have forgotten to enter the OCAP ID for 1 of the DCOP and only realizing that after having 'freezing' my DCOP.
At first, I thought that all of the DCOPs that I've created do not consist of the OCAP ID. But after checking, I realized it was only the one that I've forgotten to enter. As I explained the situation to Miss Pascale, again, we chose to created that DCOP in version two.
Miss Pascale also asked me to take a break and have a drink. Was it because that I have been staring at the computer screen the whole day (except lunch break) and due to that I got tired and hence make those careless mistakes?
Anyway, (hopefully) to prevent myself from making more mistakes , guess I should take the advice of getting out of my seat every 1 to 2 hours to rest my eyes and stretch my back. At the very least, close my eyes (for awhile, of course) when I feel tired.
That should be all for today. Bye bye (^^)
Today, I have finally, officially started creating my charts in the actual production system. I started creating the OCAP IDs, follewed by the charts and finally the DCOPs. However, I only created some of the charts and the related DCOPs and I had quite a lot left. This is pretty obvious, isn't it? How can I finish creating 33 charts and 1625 DCOPs in just one day?
Back to today's story... Before creatingthe OCAP IDs, I kept reminding myself to be extra extra careful when entering the settings required. However, sometimes, things just won't go smoothly like how you want it to be.
For me, a careless mistake made few weeks ago resulted in my first wrong setting for 2 of my OCAP IDs. Previously, I had print-screen the steps in creating the charts, DCOPs and OCAP IDs. As I was referring to the slides that I've done, I pretty much copied what I have recorded few weeks ago. I copied the title of the OCAP ID from what I had set few weeks ago which was not what I should be entering (after discussion with Miss Pascale some time later). Hence, here goes my first mistake.
As I have 'freeze' the OCAP ID, I couldn't do anything about it. It's either I can get the assistance from the IT department to 'unfreeze' the OCAP ID or I can just simply created that of a version two. So I chose the second option.
After this experience, I thought, to myself, that I will not make any mistake. True enough, I have smoothly created my charts for the particle section.
However, another careless mistake was done, again, when I'm creating the DCOP for the particle charts.
I have forgotten to enter the OCAP ID for 1 of the DCOP and only realizing that after having 'freezing' my DCOP.
At first, I thought that all of the DCOPs that I've created do not consist of the OCAP ID. But after checking, I realized it was only the one that I've forgotten to enter. As I explained the situation to Miss Pascale, again, we chose to created that DCOP in version two.
Miss Pascale also asked me to take a break and have a drink. Was it because that I have been staring at the computer screen the whole day (except lunch break) and due to that I got tired and hence make those careless mistakes?
Anyway, (hopefully) to prevent myself from making more mistakes , guess I should take the advice of getting out of my seat every 1 to 2 hours to rest my eyes and stretch my back. At the very least, close my eyes (for awhile, of course) when I feel tired.
That should be all for today. Bye bye (^^)
Friday 16 November 2012
Week 5 - 16 Nov 2012 - Fri
23rd day at SSMC.
Today is Friday. (^^)
As yesterday did not managed to finish create the 546 DCOPs to be connect into 1 chart, so today was continuing this task.
Yesterday, I've created 305 DCOPs and today, 243 DCOPs was created and I have no idea why i had 2 extra DCOPs. But in any case, I can conclude that I am able to connect more than 546 DCOPs to 1 single chart and this is definitely a good news!
Things got lesser to say today as compared to yesterday.
But still have to end my speech.
See you next week. (^^)
Today is Friday. (^^)
As yesterday did not managed to finish create the 546 DCOPs to be connect into 1 chart, so today was continuing this task.
Yesterday, I've created 305 DCOPs and today, 243 DCOPs was created and I have no idea why i had 2 extra DCOPs. But in any case, I can conclude that I am able to connect more than 546 DCOPs to 1 single chart and this is definitely a good news!
Things got lesser to say today as compared to yesterday.
But still have to end my speech.
See you next week. (^^)
Thursday 15 November 2012
Week 5 - 15 Nov 2012 - Thu
22nd day at SSMC.
Today, I have started creating the DCOPs. However, instead of creating them in the actual production system, I have created them in the training environment. This is because we were not sure how many DCOPs we are able to connect to 1 chart.
I had tried looking for the information from the guides but nothing was found. I had also consulted the IT personnel but they only know the maximum number of charts can be link to 1 DCOP but not the other way round. They mentioned that no one has done the other way round, so I have to try it out myself.
So, here I am, creating 305 DCOPs in the training environment (to ensure whatever I've done will not affect the production system). I had chosen the points under ball room for particle count as the ball room has the most points for measurement to be taken for particle count. (FYI, the ball room has a total of 546 points to be put into 1 chart)
After a long day (which is today -.-), I had only managed to created 305 DCOPs and these 305 DCOPs were successfully connected to 1 single chart. Entry of data was also successfully for these 305 DCOPs.
Today has less to share but the work was definitely consuming. It took me the whole of today yet I only managed to create 305 DCOPs. How ironic... -_-
Today, I have started creating the DCOPs. However, instead of creating them in the actual production system, I have created them in the training environment. This is because we were not sure how many DCOPs we are able to connect to 1 chart.
I had tried looking for the information from the guides but nothing was found. I had also consulted the IT personnel but they only know the maximum number of charts can be link to 1 DCOP but not the other way round. They mentioned that no one has done the other way round, so I have to try it out myself.
So, here I am, creating 305 DCOPs in the training environment (to ensure whatever I've done will not affect the production system). I had chosen the points under ball room for particle count as the ball room has the most points for measurement to be taken for particle count. (FYI, the ball room has a total of 546 points to be put into 1 chart)
After a long day (which is today -.-), I had only managed to created 305 DCOPs and these 305 DCOPs were successfully connected to 1 single chart. Entry of data was also successfully for these 305 DCOPs.
Today has less to share but the work was definitely consuming. It took me the whole of today yet I only managed to create 305 DCOPs. How ironic... -_-
Wednesday 14 November 2012
Week 5 - 14 Nov 2012 - Wed
21st day at SSMC.
Today, I have finished up listing out all the DCOPs that we will be creating. Out of curiosity, I calculated the total number of DCOPs that we gonna create. (Since this time round, we are creating for every single point.) And so,the total number of DCOPs we will be creating is 1625. Can you believe it? (^^)
Anyway, the listing of DCOPs took me almost half a day. I was still doing it after lunch... -.-
After done listing out the DCOPs, I continued to think of the naming convention for the chart IDs. Miss Pascale said that the naming convention for the chart IDs must be standardize. So it took me awhile to standardize the IDs.
And, similarly, listing the chart IDs out was part of my today's tasks. After listing out, I calculated the number of charts to be 33. This turned out lesser than what we have calculated before. Guess, I'm kinda familiar with how the charts works and the settings. I used to have 4 charts for 1 category but now I can lessen to 2 charts for that particular category.
Once again, after I'm done with the chart IDs, I proceeded to the OCAP IDs and titles. I have listed out the several OCAP IDs and titles to be created to ensure that I have everything ready before I start to create anything. This is to reduce errors and to be able to make amendments while we still can.
I have everything ready for checking, the DCOPs, chart IDs and OCAP IDs. As long as everything passes the check, I am officially starting to create them. How wonderful! :)
Today, I have finished up listing out all the DCOPs that we will be creating. Out of curiosity, I calculated the total number of DCOPs that we gonna create. (Since this time round, we are creating for every single point.) And so,the total number of DCOPs we will be creating is 1625. Can you believe it? (^^)
Anyway, the listing of DCOPs took me almost half a day. I was still doing it after lunch... -.-
After done listing out the DCOPs, I continued to think of the naming convention for the chart IDs. Miss Pascale said that the naming convention for the chart IDs must be standardize. So it took me awhile to standardize the IDs.
And, similarly, listing the chart IDs out was part of my today's tasks. After listing out, I calculated the number of charts to be 33. This turned out lesser than what we have calculated before. Guess, I'm kinda familiar with how the charts works and the settings. I used to have 4 charts for 1 category but now I can lessen to 2 charts for that particular category.
Once again, after I'm done with the chart IDs, I proceeded to the OCAP IDs and titles. I have listed out the several OCAP IDs and titles to be created to ensure that I have everything ready before I start to create anything. This is to reduce errors and to be able to make amendments while we still can.
I have everything ready for checking, the DCOPs, chart IDs and OCAP IDs. As long as everything passes the check, I am officially starting to create them. How wonderful! :)
Monday 12 November 2012
Week 5 - 12 Nov 2012 - Mon
20th day at SSMC.
Today, I had spent my morning practicing the steps in creating charts, DCOPs and OCAP IDs. As I'm afraid that I'll make mistakes in the actual production system, thus I rather practice more now. I have also kept track of what are the necessary settings like the setting of control violation rules and variables etc.
I have also tried creating a new chart and DCOPs for one of the ionization points. As the variables and the parameters and different from, what I have been doing recently, particle count, thus I tried out today to get an idea of it.
As I have mentioned in the previous posts that the DCOP names that I had came out, were not appropriate anymore. So I had to rename the DCOPs but with just a little changes. I have set the 7 characters of the DCOP in this arrangement:
First character tells the type of measurement. For example, P is for particle count and A is for Air Velocity etc.
Second and third characters tell the location of the points. For example, TL for Test Lab. For the location, I'm using the previous naming idea. :)
And for the last 4 characters, I have decided to keep them for the naming of points. This is because there are points with 4 characters. For example, AE65 etc.
The naming convention, I have completed, but I'm not done listing out all the DCOPs for the points. (There is just too much...) Anyway, since tomorrow is holiday, will only get to continue on Wednesday. Meanwhile, time to rest!!! On tomorrow... (^^)
I am also taught, by Miss Pascale, on how to update some data on a daily basis. I am supposed to help out in updating the information when Miss Pascale's on leave or that they are not available or around. It's sounded like a simple 3 steps task but I wouldn't want to screw things up there. I have taken down what to do and the steps in doing it. Definitely wouldn't wish to create trouble... @.@
Today, I had spent my morning practicing the steps in creating charts, DCOPs and OCAP IDs. As I'm afraid that I'll make mistakes in the actual production system, thus I rather practice more now. I have also kept track of what are the necessary settings like the setting of control violation rules and variables etc.
I have also tried creating a new chart and DCOPs for one of the ionization points. As the variables and the parameters and different from, what I have been doing recently, particle count, thus I tried out today to get an idea of it.
As I have mentioned in the previous posts that the DCOP names that I had came out, were not appropriate anymore. So I had to rename the DCOPs but with just a little changes. I have set the 7 characters of the DCOP in this arrangement:
First character tells the type of measurement. For example, P is for particle count and A is for Air Velocity etc.
Second and third characters tell the location of the points. For example, TL for Test Lab. For the location, I'm using the previous naming idea. :)
And for the last 4 characters, I have decided to keep them for the naming of points. This is because there are points with 4 characters. For example, AE65 etc.
The naming convention, I have completed, but I'm not done listing out all the DCOPs for the points. (There is just too much...) Anyway, since tomorrow is holiday, will only get to continue on Wednesday. Meanwhile, time to rest!!! On tomorrow... (^^)
I am also taught, by Miss Pascale, on how to update some data on a daily basis. I am supposed to help out in updating the information when Miss Pascale's on leave or that they are not available or around. It's sounded like a simple 3 steps task but I wouldn't want to screw things up there. I have taken down what to do and the steps in doing it. Definitely wouldn't wish to create trouble... @.@
Friday 9 November 2012
Week 4 - 09 Nov 2012 - Fri
Last day of Week 4, 19th day at SSMC.
Time really flies. Today is the last day of week 4 and this means that 1/4 of the ITP period has past. I've also used up half of my notebook and this is so much faster than I had used a notebook during school time. Lol.
Anyway, I have good news and bad news today. Let's just start from the beginning...
For the whole of this morning, I continued to search and try all possible ways to set the graph to display all the data values for the points that I've entered. However, I still did not managed to find a solution for yesterday's problem. I was still stuck at the setting, 'Spec for Variable 1'. I read through the PROMIS guide and tried the method stated in it but it just won't work.
So I've consulted Selinda, collegue who has experiences in using PROMIS and SPC Chartor. She replied that normally they will show one point in one chart and (I guess) that's how the system works.
And so, I reported the situation to Miss Pascale. And after discussion, I began to try linking the second DCOP to the chart (with the first DCOP linked). This turned out successful. I've managed to get the chart to display the data values calculated by the 2 DCOPs after entering data for the 2 DCOPs.
After showing Miss Pascale my successfully done chart, we went to discuss, with our manger, what we have till now.
Let's fast forward to after discussion with manager and the conclusion is, with too much constraints and different requirements, we will have to create 1 DCOP containing 1 point. And I meant 1 exact point. This is the so called 'bad news'. I have no idea how many DCOPs I will be creating but definitely more than 500. Why am I so positive about that? Remember I had mentioned before, or if not, that for particle count of ball room, the points are already 546. This is why I'm so positive that I'm gonna be creating more than 500 DCOPs. XD
On the other hand, the good news is that I am officially starting my project. I will be working the charts in the actual environment in the system. Hope that I'll not screw things up. (^^) And I really hope to finish this project before ITP ends. This is the least I can do.
Time really flies. Today is the last day of week 4 and this means that 1/4 of the ITP period has past. I've also used up half of my notebook and this is so much faster than I had used a notebook during school time. Lol.
Anyway, I have good news and bad news today. Let's just start from the beginning...
For the whole of this morning, I continued to search and try all possible ways to set the graph to display all the data values for the points that I've entered. However, I still did not managed to find a solution for yesterday's problem. I was still stuck at the setting, 'Spec for Variable 1'. I read through the PROMIS guide and tried the method stated in it but it just won't work.
So I've consulted Selinda, collegue who has experiences in using PROMIS and SPC Chartor. She replied that normally they will show one point in one chart and (I guess) that's how the system works.
And so, I reported the situation to Miss Pascale. And after discussion, I began to try linking the second DCOP to the chart (with the first DCOP linked). This turned out successful. I've managed to get the chart to display the data values calculated by the 2 DCOPs after entering data for the 2 DCOPs.
After showing Miss Pascale my successfully done chart, we went to discuss, with our manger, what we have till now.
Let's fast forward to after discussion with manager and the conclusion is, with too much constraints and different requirements, we will have to create 1 DCOP containing 1 point. And I meant 1 exact point. This is the so called 'bad news'. I have no idea how many DCOPs I will be creating but definitely more than 500. Why am I so positive about that? Remember I had mentioned before, or if not, that for particle count of ball room, the points are already 546. This is why I'm so positive that I'm gonna be creating more than 500 DCOPs. XD
On the other hand, the good news is that I am officially starting my project. I will be working the charts in the actual environment in the system. Hope that I'll not screw things up. (^^) And I really hope to finish this project before ITP ends. This is the least I can do.
Thursday 8 November 2012
Week 4 - 08 Nov 2012 - Thu
18th day at SSMC.
Today, I have finally successfully programmed the chart to show the correct calculated values. I was so happy!
This morning, I've created a new chart, as mentioned in yesterday's post, to replace the one that I've entered the wrong set ups. And upon doing so, I've recorded every single step using screenshots and saved them into a PowerPoint. I have also make notes and comments at each step foe explanation purpose.
However, after I have set up the new settings in my newly created chart, I still could not get the graph to display the calculated values. The chart kept showing 1 of the 4 entered data value. No matter, how many data value I enter into the system, the chart only show the data values entered for that 1 point.
Thus, this means that I'm partially failed...
And so, I went to consult the IT personnel, Sock Bee, again. (I've been troubling her these few days... Guilty ...) She mentioned to me that I've done the 'variable' setting wrongly. I thought that I would have to start all over again as I have freeze my chart. But Sock Bee said that I can unfreeze my chart in the training environment as I am the owner of my chart. And this is a good news to me. Sock Bee also showed me a PROMIS guide that would help me in doing my try outs. The guide was mainly for data entry and DCOPs and it really solved some of my queries.
So, I continued to try setting the correct set up for my chart. And finally, after many edits here and there, I got the graph to display my calculated 'Range' and 'Average' values!
I could not believe it at first, so I entered a few more data values and it showed all the correct values that is the calculated 'Range' and 'Average' values.
I was so delight and presented my work to Miss Pascale. (^^)
And after some discussion, we seem to find that the groupings were not appropriate anymore, Therefore, we are back to displaying individual point's values. So for the last half an hour, I was making changes to the chart and DCOP settings.
The missing part is always the 'Specification for Variable 1' setting. I'm not sure of what to put for that part to make the graph display all data values entered for all the points.
Guess, i'll try all possible settings to make it work and will find someway to resolve it. Ganbatte!~ (^^)
Today, I have finally successfully programmed the chart to show the correct calculated values. I was so happy!
This morning, I've created a new chart, as mentioned in yesterday's post, to replace the one that I've entered the wrong set ups. And upon doing so, I've recorded every single step using screenshots and saved them into a PowerPoint. I have also make notes and comments at each step foe explanation purpose.
However, after I have set up the new settings in my newly created chart, I still could not get the graph to display the calculated values. The chart kept showing 1 of the 4 entered data value. No matter, how many data value I enter into the system, the chart only show the data values entered for that 1 point.
Thus, this means that I'm partially failed...
And so, I went to consult the IT personnel, Sock Bee, again. (I've been troubling her these few days... Guilty ...) She mentioned to me that I've done the 'variable' setting wrongly. I thought that I would have to start all over again as I have freeze my chart. But Sock Bee said that I can unfreeze my chart in the training environment as I am the owner of my chart. And this is a good news to me. Sock Bee also showed me a PROMIS guide that would help me in doing my try outs. The guide was mainly for data entry and DCOPs and it really solved some of my queries.
So, I continued to try setting the correct set up for my chart. And finally, after many edits here and there, I got the graph to display my calculated 'Range' and 'Average' values!
I could not believe it at first, so I entered a few more data values and it showed all the correct values that is the calculated 'Range' and 'Average' values.
I was so delight and presented my work to Miss Pascale. (^^)
And after some discussion, we seem to find that the groupings were not appropriate anymore, Therefore, we are back to displaying individual point's values. So for the last half an hour, I was making changes to the chart and DCOP settings.
The missing part is always the 'Specification for Variable 1' setting. I'm not sure of what to put for that part to make the graph display all data values entered for all the points.
Guess, i'll try all possible settings to make it work and will find someway to resolve it. Ganbatte!~ (^^)
Wednesday 7 November 2012
Week 4 - 07 Nov 2012 - Wed
17th day at SSMC.
Today, I have spent the whole morning exploring the commands and functions in the software, 'Tera Term'. I have also taken down, step by step, the process of creating the charts, DCOP, and OCAP ID. This will allow me to have reference in the future.
And 1 hour before lunch, I've consulted the IT personnel, Sock Bee, and the IT manager for further progression of my project. Sock Bee had suggested me doing do all my testing charts, DCOPs, OCAP ID in the 'Tera Term's' training environment and this training environment will not affect the actual production system.
As for the IT manger, I have consulted him on what I am supposed to find out about the FTP and what else do I need to know besides running a script and superscript to transfer data. I have seriously learnt quite a handful of stuff this morning.
After lunch, I began to create chart, DCOPs and OCAP ID. I wasn't able to use what I have created in the actual production system in the training environment. Thus, I got to start all over again, start from the basic that is to create a new chart. In a way, I get to refresh my memory on creating charts.
I managed to create the chart, DCOP and OCAP ID; set the neccessary settings and get the charts to work. Although I was successful in entering the data values to the chart, somehow, I couldn't get the chart to display the data that I wanted.
After troubleshooting (for not sure how long but should be not too long :P), I believe that the 'variable' should be the part where I have set up wrongly. However, I can't edit the part of the chart as I have already 'freeze' the chart. Hence, I have to re-create a new chart.
Time flies. After I found out that I have to create a new chart, it was also about time to end. So, the creation of a new chart was postponed to tomorrow.
Hope that things will go smoothly tomorrow, without me making mistakes in the process. I will be extra careful in the steps of the process. One wrong step and I will need to start all over again.
Today, I have spent the whole morning exploring the commands and functions in the software, 'Tera Term'. I have also taken down, step by step, the process of creating the charts, DCOP, and OCAP ID. This will allow me to have reference in the future.
And 1 hour before lunch, I've consulted the IT personnel, Sock Bee, and the IT manager for further progression of my project. Sock Bee had suggested me doing do all my testing charts, DCOPs, OCAP ID in the 'Tera Term's' training environment and this training environment will not affect the actual production system.
As for the IT manger, I have consulted him on what I am supposed to find out about the FTP and what else do I need to know besides running a script and superscript to transfer data. I have seriously learnt quite a handful of stuff this morning.
After lunch, I began to create chart, DCOPs and OCAP ID. I wasn't able to use what I have created in the actual production system in the training environment. Thus, I got to start all over again, start from the basic that is to create a new chart. In a way, I get to refresh my memory on creating charts.
I managed to create the chart, DCOP and OCAP ID; set the neccessary settings and get the charts to work. Although I was successful in entering the data values to the chart, somehow, I couldn't get the chart to display the data that I wanted.
After troubleshooting (for not sure how long but should be not too long :P), I believe that the 'variable' should be the part where I have set up wrongly. However, I can't edit the part of the chart as I have already 'freeze' the chart. Hence, I have to re-create a new chart.
Time flies. After I found out that I have to create a new chart, it was also about time to end. So, the creation of a new chart was postponed to tomorrow.
Hope that things will go smoothly tomorrow, without me making mistakes in the process. I will be extra careful in the steps of the process. One wrong step and I will need to start all over again.
Tuesday 6 November 2012
Week 4 - 06 Nov 2012 - Tue
16th day at SSMC.
Today, I have rearranged the number ranges of some of the DCOPs. As the number ranges were not even and is difficult for people to remember. What I meant by the number ranges are not even is that they are in terms of, for example, 20, 25, 45, 60 etc. And what I have done is to rearrange, according to the points, them into more evenly distributed ranges. For example, 10, 20, 30, 40, 50, 60 etc. These more evenly distributed number ranges will be much easier for people to remember.
After which, I had combine all DCOPs into 1 single Excel sheet for ease of viewing. With the overall naming convention, done yesterday, inserted at the first sheet, I am now considered job done. (^^)
But this 'job done' is only for the task 'creating DCOPs'. After lunch, Miss Pascale brought me to discuss, with the manager of the IT department, about our project. During discussion, the IT manager pointed out some points of what we are required to do but we were kind of lost. He said that I will need to use the FTP (Files Transfer Protocol) command and to input values, manually, to the charts using the software, 'Tera Term'.
Up to here, I can be considered as pretty lost. I have a general idea of what the IT manager had told us but I am clueless of how to do or even start it.
The IT manager suggested us to 'google' FTP and get some hands-on on inputting the values. Though I am eager to start doing it, but I have no idea how. Thus, Miss Pascale had printed some information, that we have found through internet, regarding FTP. Hoping that I could get something out of those information, I read through the handouts.
However, I did not. I presumed the information we've gotten does not relate to what we needed. I guess I will need to do more research...
Today, I have rearranged the number ranges of some of the DCOPs. As the number ranges were not even and is difficult for people to remember. What I meant by the number ranges are not even is that they are in terms of, for example, 20, 25, 45, 60 etc. And what I have done is to rearrange, according to the points, them into more evenly distributed ranges. For example, 10, 20, 30, 40, 50, 60 etc. These more evenly distributed number ranges will be much easier for people to remember.
After which, I had combine all DCOPs into 1 single Excel sheet for ease of viewing. With the overall naming convention, done yesterday, inserted at the first sheet, I am now considered job done. (^^)
But this 'job done' is only for the task 'creating DCOPs'. After lunch, Miss Pascale brought me to discuss, with the manager of the IT department, about our project. During discussion, the IT manager pointed out some points of what we are required to do but we were kind of lost. He said that I will need to use the FTP (Files Transfer Protocol) command and to input values, manually, to the charts using the software, 'Tera Term'.
Up to here, I can be considered as pretty lost. I have a general idea of what the IT manager had told us but I am clueless of how to do or even start it.
The IT manager suggested us to 'google' FTP and get some hands-on on inputting the values. Though I am eager to start doing it, but I have no idea how. Thus, Miss Pascale had printed some information, that we have found through internet, regarding FTP. Hoping that I could get something out of those information, I read through the handouts.
However, I did not. I presumed the information we've gotten does not relate to what we needed. I guess I will need to do more research...
Monday 5 November 2012
Week 4 - 05 Nov 2012 - Mon
Start of a new week, 15th day at SSMC.
Today, I've finished up the naming of DCOPs for ionization, ESD, field voltage and SMIF. The concept of the naming convention is similar to particle and air velocity previously.
The first and second characters are for the different locations. Third and fourth characters are of a little different. For ionzation, the third and fourth characters can be either 'DT' for Decay Time or 'OV' for Offset Voltage. For ESD, it will be the different types of ESD such as 'HB' for Human Body and 'PG' for Power Grounding. The last 3 characters are the number range, ID or the points, same as what I have for particle and air velocity.
After which, I consolidated all DCOPs and came up with a overall naming convention. I have stated all locations (with their 'short forms') and other acronyms that I have used with explanation and description. This will allow other people to understand how I had come up with those DCOPs.
We also have a discussion with a IT personnel and she pointed out that `1 DCOP can only have a maximum of 9 to 10 points. This means that I have to regroup my DCOPs as some of my DCOPs have more than 10 points. Although I had managed to regroup the points by the end of today, the number range now is not even and is more difficult to remember. Thus, Miss Pascale wants me to think of a better solution.
The total number of DCOPs I have came up is 360. And after regrouping, it increases to 391 DCOPs. It alot, ain't it? But we are still looking into it. We are, somehow, stuck as we are not sure if we are able to link the measuring devices to the system. If this can't work, it will be no point for us to create so many DCOPs.
Anyway, I hope that we will receive good news from the IT personnel.
Today, I've finished up the naming of DCOPs for ionization, ESD, field voltage and SMIF. The concept of the naming convention is similar to particle and air velocity previously.
The first and second characters are for the different locations. Third and fourth characters are of a little different. For ionzation, the third and fourth characters can be either 'DT' for Decay Time or 'OV' for Offset Voltage. For ESD, it will be the different types of ESD such as 'HB' for Human Body and 'PG' for Power Grounding. The last 3 characters are the number range, ID or the points, same as what I have for particle and air velocity.
After which, I consolidated all DCOPs and came up with a overall naming convention. I have stated all locations (with their 'short forms') and other acronyms that I have used with explanation and description. This will allow other people to understand how I had come up with those DCOPs.
We also have a discussion with a IT personnel and she pointed out that `1 DCOP can only have a maximum of 9 to 10 points. This means that I have to regroup my DCOPs as some of my DCOPs have more than 10 points. Although I had managed to regroup the points by the end of today, the number range now is not even and is more difficult to remember. Thus, Miss Pascale wants me to think of a better solution.
The total number of DCOPs I have came up is 360. And after regrouping, it increases to 391 DCOPs. It alot, ain't it? But we are still looking into it. We are, somehow, stuck as we are not sure if we are able to link the measuring devices to the system. If this can't work, it will be no point for us to create so many DCOPs.
Anyway, I hope that we will receive good news from the IT personnel.
Friday 2 November 2012
Week 3 - 02 Nov 2012 - Fri
14th day at SSMC.
Today, I can say to have solve some parts of the 'problem'. (^^) Before sharing what I have solve, I shall explain the situation first.
Part of my creating charts process is to create the DCOPs. And to get these DCOPs, I need to decide on how I want the points (for measurement) to be divided. But, there's a limitation for the DCOPs, that is, each DCOP can only have a maximum of 7 alphanumeric characters.
Thus, 1 of my idea is that, for the 1st and 2nd characters, it will be initials of the different areas. For example, BR for Ball Room and TL is for Test Lab.
The 3rd and 4th characters determine either the months of the readings or measurement being taken or the type of measurement such as AV for Air Velocity.
The last 3 characters will be either the Number or the 'coordinates' of the points or the ID of the measurement points. But this Number determine the range of the points. For example, 20 means for points up to 20. Thus, 1 DCOP can be for a number of points.
And we are able to link few DCOPs to 1chart, that's why we have decided to create more DCOPs.
Today, I have settled the DCOPs for particle count and air velocity. I had only left ionization, ESD and field voltage. And once everything's done, we will be able to start creating the charts... I am 1 step nearer to my goal. (^^)
Last day of the week. Time to rest. Weekends, hope you will pass slowly...
Today, I can say to have solve some parts of the 'problem'. (^^) Before sharing what I have solve, I shall explain the situation first.
Part of my creating charts process is to create the DCOPs. And to get these DCOPs, I need to decide on how I want the points (for measurement) to be divided. But, there's a limitation for the DCOPs, that is, each DCOP can only have a maximum of 7 alphanumeric characters.
Thus, 1 of my idea is that, for the 1st and 2nd characters, it will be initials of the different areas. For example, BR for Ball Room and TL is for Test Lab.
The 3rd and 4th characters determine either the months of the readings or measurement being taken or the type of measurement such as AV for Air Velocity.
The last 3 characters will be either the Number or the 'coordinates' of the points or the ID of the measurement points. But this Number determine the range of the points. For example, 20 means for points up to 20. Thus, 1 DCOP can be for a number of points.
And we are able to link few DCOPs to 1chart, that's why we have decided to create more DCOPs.
Today, I have settled the DCOPs for particle count and air velocity. I had only left ionization, ESD and field voltage. And once everything's done, we will be able to start creating the charts... I am 1 step nearer to my goal. (^^)
Last day of the week. Time to rest. Weekends, hope you will pass slowly...
Thursday 1 November 2012
Week 3 - 01 Nov 2012 - Thu
13th day at SSMC.
Today, I finished up yesterday's work (which is identifying the different wafer defect types) and carried on to categorize the data into different wafer types by the working weeks.
The categorization was done using Excel's formula and the formula used today were similar to previous work. I had used the 'COUNTOFS' and 'SUMIFS' fomula, however, I spent quite a while on setting the criteria. I had also set up 2 Excel's charts based on the data I had categorized. Overall, I still managed to finish this task before lunch.
After lunch, I continued my second task (assigned on Tuesday) that is regrouping of the points for the measurement.
To have a clearer idea of where the points exactly are located in the different areas, I identified all the points on the map of each areas. Nonetheless, this task is another time consuming work. But halfway through, we have came up with 1 idea. Just that, Miss Pascale mentioned before that we should always have a back up plan so I trying to think of another idea (just for in case). But, ideas don't just come easily. >.<
I left the largest area, with the most number of points, not done identifying the points yet. Guess tomorrow will continue thinking and hope to come up with better and more ideas.
By the way, today is first day of November and tomorrow is Friday. This week is ending soon.
Today, I finished up yesterday's work (which is identifying the different wafer defect types) and carried on to categorize the data into different wafer types by the working weeks.
The categorization was done using Excel's formula and the formula used today were similar to previous work. I had used the 'COUNTOFS' and 'SUMIFS' fomula, however, I spent quite a while on setting the criteria. I had also set up 2 Excel's charts based on the data I had categorized. Overall, I still managed to finish this task before lunch.
After lunch, I continued my second task (assigned on Tuesday) that is regrouping of the points for the measurement.
To have a clearer idea of where the points exactly are located in the different areas, I identified all the points on the map of each areas. Nonetheless, this task is another time consuming work. But halfway through, we have came up with 1 idea. Just that, Miss Pascale mentioned before that we should always have a back up plan so I trying to think of another idea (just for in case). But, ideas don't just come easily. >.<
I left the largest area, with the most number of points, not done identifying the points yet. Guess tomorrow will continue thinking and hope to come up with better and more ideas.
By the way, today is first day of November and tomorrow is Friday. This week is ending soon.
Subscribe to:
Posts (Atom)