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.
Subscribe to:
Posts (Atom)