Punggol Trial

Tried the (1) Sigma105mm macro lens and (2) dreamy water sunset view

Realized that F3.2 is too shadow for SIgma105mm...

Here are the pix :)







Enjoy the shots with baby :)

Nice and Cute PPL that I met in Maple

Pirate progress (3)

Beary Xmas to all^^

my pirate progress (2)

I am supposed to be doing some office stuff now. But, since it is given 2x exp now, I shall train first >_<.

It is the motivation to ork harder later^^

my pirate progress

Lvl 21

Lvl 19

PurseIn

This item is so nice and neat! But quite pricy..

The official website is selling at approx SGD50...

Where can I find lobang in it?...>_<

Source: http://www.pursesitter.com/purse-organizer/pursein.htm

Advanced excel (1)

Having googling for answers on some special or overlooked tool in excel...

Finally, I got my answers on them. But if I dun record it, I will forget it. Life is so busy >_<>

Trick 1: Color fill Multiple Rows Based on Condition
source: www.ozgrid.com

1. Select all cells on the worksheet
2. Select: Format|Conditional Formating....
3. Set: "Formula is" and for formula use: =IF($F1="Yes", TRUE, False)
4. Set your pattern
   

Trick 2: Fill alternate rows with a color

1. Select the range
2. Select: Format|Conditional Formating
3. Set: "Formula is" and for formula use: = MOD(ROW(), 2)=0
4. Set your pattern

• Remarks: explanation on the sytax: MOD Function and ROW()

MOD(,): Remainder
ROW(): row number

i.e. Remainder of "ROW( ) being divided 2" is equal to 0. If true, apply the pattern, else no action will be taken.

Next coming Sort by color

Trick 3: Sort by color (coming soon ... ^^)