星期六的深夜 - 王力宏

Macros in EXCEL

Sometimes, working life can be SUPER boring especially when no job is assigning to you. However, i do appreciate the working experience that i am gaining from G&P company; they are priceless~

The work that i am dealing with now, is more to data analysis and modelling. When we talk about data analysis, that simply means you are dealing with tonnes and tonnes of numbers! And through this internship, i have learned to use Macro function in repeating the steps that i want in Excel. It is awesome! Saving my time!~

EXAMPLE

If let say you are having a range of monthly data from year 1990-2005 and your task is to plot monthly graphs.

---> Macros is of GREAT help in selecting only a certain month that you desired~!

Step 1: Make sure your data is sorted accordingly (by months and years). Now, point your cursor on Jan-90 as shown in Figure 1.

Figure 1

Step 2: Go to “View” and click on “Macros”, then select “Use Relative References” as shown in Figure 2. [NOTE: Do not remove the cursor on Jan-90]

Figure 2

Step 3: Click on “Record Macro…” from “Macros” function. Then, insert a shortcut key in the pop-up menu, let say, Ctrl + “w” as shown in Figure 3. [NOTE: Do not remove the cursor on Jan-90]

Figure 3

Step 4: Highlight rows from Feb-90 to Dec-90, then right click to delete them as shown in Figure 4.

Figure 4

Step 5: Now, point your cursor at Jan-91, then click "Stop Recording" as shown in Figure 5.

Figure 5

Step 6: By pointing the cursor on Jan-91, you may now press on "Ctrl+w" (the shortcut key that you set earlier) repeatedly until your task is done. Finally, only the data for the month of January are selected while the rest of the data are deleted automatically using “Macros” function. DONE~!

***Macros is a very useful function in repeating any task you want. Most importantly, be very certain of your desired starting and ending points***

"You're Gorgeous Just The Way You Are"

This is such an encouraging and educative video~
Thank you bro "Fei Keen" for telling me this~! ^^
This has reminded me to complain less about my life and learn to appreciate more~
I'll REMEMBER that whenever i feel helpless, hopeless, stressed or depressed...
Thanks bro~!!! :)

Only Words...

Words are so powerful..
Sometimes, they can be really wonderful and make you happy..
But sometimes, they can be very harmful and hurt you badly..

Most people that know me, they like to make jokes about me or even tease me..
But i know it well, they do it because they know i won't get angry easily..
But of course, everyone has a limit in accepting jokes..so do i..
Until some extent if i keep quiet about the things that you're saying, that simply means, i'm either not agreeing with your statement, i didn't hear that or i'm simply a bit angry and trying to calm myself down by changing a new topic..
I realised, not many people can understand me in this..eventhough we have been knowing each other for years..

And i always thought, things can be solve only if the problem/uneasy feeling is being told..but things aren't just that simple..
I know, i can be really rude in spilling out my bad feelings sometimes..
And i just did that to 2 person last night..one is my mum and one is YOU..
Well, i should just admit that my EQ is so damn low...i can't help it...

I don't normally spill out my feelings unless i really have to..
This time, i really have to because if i don't, i know i'm really gonna break down in no time..

First of all, sorry mum.. I shouldn't have shouted at you last night when helping you out..i know i always do that because i have no patience in explaining things over and over again while i know you're actually not paying attention.. I'll try my best to change this bad habit.. Sorry..

Secondly, sorry to YOU as i really didn't know that a few sentences can be so hurtful to YOU.. I know, what's done cannot be undone, especially to YOU.. My bad.. (>.<)

Thirdly, i ought to say sorry to Ting as well.. I know i did hurt your feelings a few times in the UK for spilling out my feelings.. I did right? But i must say, you're very patience in dealing with me.. Thank you so much~ Well, i'm gonna be your roommie soon, if i'm ever hurting your feelings again, do let me know k? You know, i like to discuss problems and solve that with you instead of putting it in heart.. :)

Lastly, sorry bro.. I FFK you yesterday night and you knew why... I know you've tonnes to spill out and so do i.. But i really dunno how to say.. Well, i may be a good listener (to you only...maybe?) but not a good spiller.. I know you're very busy in your mega project lately..and i can't get to help you at all..really sorry.. When you're free, just give me a ring.. I promise, i will never FFK you this time.. :)

Alright, that's all for the sorries.. I shall balance out with some thank you(s) too~

THANK YOU Kok Hoong!! You've been really wonderful and had really lessen my burden~ You've always been thoughtful and helpful to me.. Really thank you~! I know you don't like me saying this but i really mean it and wanna say it.. :)

"Fei Keen"~!! You've always showing your concern in knocking on my windows whenever you see me in MSN.. I really appreciate that~ But today, i'm really not in the mood of chatting.. That was why i only chatted for awhile.. Anyway, you're gonna be back real soon~! Do enjoy to the fullest in the UK while you still can lo~ ^^

I'm not sure whether you'll be reading this or not.. But well, i'm really happy in receiving your email today.. What a surprise~! Thanks for the song, the photos and your stories~ I'm so touched that you actually remember me because of that band~ Miss you all so much~!! :)

Kellie, i really wanna say thank you for inviting me to watch the MTV World Stage (Hoobastank rocks!! You're right, that girl was Pixie Lott..i just found that out from the newspaper today..haha) and The Proposal (great movie!!and i'm kinda shocked that you actually forgotten watching that with me and asking me to watch it for the second time..lolz)~ Well, i hope you did had fun for the PAINtball as well~ Oh ya, please forgive me for the stupid things that i did last week (fetching you).. :p See you tomorrow~ :)

Serene, Shea Yeong, Jason, Eeffie and Ken, how i wish you guys are here now with me.. I want Hoegaarden, Kronenberg and Carlsberg Export please....... I'm missing the eating & drinking sessions with you guys so much~!!

Alright..it's time for me to 反省 and also to heal myself.....by dreaming.....

I'm Killing Myself...... (>.<)

A week had passed.... What have i done?!! Maths ONLY!!! Been slacking ALOT and having TOO MUCH fun!! Especially yesterday and today... This was the FIRST time i played NON-STOP for more than 24 hours(excluded a few hours of sleep)!!

Yesterday, at 12pm i started cooking my chicken curry coz SOMEONE told me they will be arriving around 3pm~! As a result, my curry was over-cooked.....and burnt!! First time cooking+burnt, BUT still finished one whole pot of chicken curry woh~ You can imagine how "delicious" was that la.. :p

Besides my burnt curry, we also had delicious grilled chicken by Ken, excellent ABC soup by Shea Yeong, wonderful belt-fish by Teng Teng, and "no taste + not juicy" grilled lamb by Jason~ :p

After the "meat feast", we started card games such as "King", "Seven", "21", "Good Buddy", "Big 2" and "左轮手枪" plus drink drink drink~!! Half bottle of Whisky, a bottle of Vodka and a bottle of red wine plus 7-ups and a bottle of lemonade ---> killed 3 people....which are Ken, Jason and I........

I dunno what had happened after i collapsed.....and thanks to both Ting&Teng, i was on the bed instead of lying somewhere in the kitchen or the hallway"....

....this morning, they woke me up around 11 plus... Still abit "mabuk + pening"... Then, we started our card games again!! This time, NO MORE drinking!! Just having fun playing while cooking our "onion feast" for "lunch + dinner"... After eating, we rewarded ourselves with Ben's & Jerry's ice cream~ Winners eat~ Losers watch~ HAHA!!

After a nice treat, yet we had our final "punishment" ---> LAST bottle of hot wine~ That bottle of wine was actually not that bad....BUT after drinking TOO MUCH in the previous day, no one is appreciating that anymore... In short, it was wasted..

Finally, we ended our party around 8 something~ Having a gathering once in a blue moon, was truely joyful~ But NOT too often coz i'm getting sick after drinking too much...

Conclusion ---> Drinking is NO GOOD coz in the end, i can do NOTHING but to sleep...(>.<) Tomorrow is Sunday already!! Hopefully i can do some reading before heading to Edinburgh on Monday~ Snowy Edinburgh~ Here we come~ WooHoo~

After exams!! Next round!! Farewell party for Serene!! :)



************Jason ahh.....I want all the photos ahh.....************

~Wonderful Night~

Come to think of it, I’ve been away from home for more than 2 months now. So far, I’ve not been to any other place, except a small town called Leicester (which not many people could have known of it) and London Heathrow (which I only stepped my foot in the airport for less than an hour). That’s right, I’m basically stuck here in Nottingham and having a typical life as a student; study, cook, eat, sleep, play badminton, online, and shop for groceries. What else can I do??

To be honest, I have been really busy for the past few weeks because of my coursework that are constantly due on the same week or even on the same day!!(@.@) It has been a nightmare for me and it still is a nightmare for another 2 more weeks. Well, I do think I’ve been stressing myself a little too much and I do apologise if I did upset anyone for being “unfriendly”. OMG!! I seriously can’t wait to end this all up and take a break man!! Just another 2more weeks!! I’ll be coursework-free!! Woohoo~ (^.^)

After all this while, tonight was indeed the best night I've had, ever since I am here in the UK. Mr Tang (one of our lecturers from M’sia) was here since last week and we finally get to meet up with him tonight. Together, we attended a fabulous lecture regarding soil behaviour by one of the best lecturers named Dr. McDowell. Dr. McDowell, is not only handsome, but also smart and family oriented. The moment that he acknowledged his mother for all the supports she has been giving to him since childhood time was so touching and my tears are rolling in my eyes too.

Anyway, I think I have gone a little too far. What I am trying to say is, “Nice meeting you, Mr Tang!!” Tonight we all really had a wonderful chat with you and Mr Bill. We chatted on almost anything in random but interesting; the history of Civil Engineering in Uni. Of Nottingham, the names of the current buildings of Coates and Pope, the Telford, the sudden massive demands for education in Britain after World War 2, the current economy crisis, and etc. It was just so awesome that we could actually chat freely with our lecturers man~! :)

~More Updates~

Alright, i shall make this simply and fast!! (>.<)
First of all, i wanna show some pictures of 3 pretty trees~ **LOVE**


They were so leafy when we first saw~




Days later....



....the leaves are getting lesser....


But luckily, we managed to snap a pic before they become "botak"~ :p


The "Civil-ers" from M'sia~ (^.^)


~Sunset during Autumn~


Secondly, i wanna say thanks for a friend who had treating us a NICE dinner at her house~


"Thanks Stella(2nd from left)!!" Your cooking is MUCH better than mine~! haha~


Lastly, i wanna thanks a bunch for those who had wished me from across the world or celebrated my 21st birthday, here in the UK~ Thanks alot guys~!! (^.^)


Kebabs with chips and chicken wings, Rice & pitta with lamb and chicken meats PLUS mayo sauce, tomato sauce and garlic sauce!! I LOVE Charcoal Grill~ Yummy~


Thanks for the treat~! (^.^)


May ALL my dreams come true~ I have so sO SOooOO many dreams~ HAHA!


Lovely cheese cake & is very delicious~


Doritos with CHEESE and pasta sauce?


Ken preparing his very own, "secret recipe"~ Very nice ohh~


The Civil-ers: Alex (from HK), Ken, Ting, Jason and I~



ONE thing good about getting older is.......


......I'm legal to buy alchohols in the UK & USA~!! ~~WooHoo~~