LINE Event – Free Sundae Cone

I received a Line Message as below:

Jom, let’s enjoy a FREE McD Sundae Cone from LINE Malaysia together! Just click the link to redeem it!

link: http://r.line.me/H6zz

The link about only work if you in LINE App.

I do not have the screen for redeem. Thanks God, I had been chosen to win the voucher 😀

LINE Event: FREE Sundae Cone
LINE Event: FREE Sundae Cone
LINE Event: FREE Sundae Cone - T&C
LINE Event: FREE Sundae Cone – T&C

After my working office hour, I went to Subang Parade to redeem my Free Ice Cream~

LINE Event: FREE Sundae Cone - The staff at McD will click on this. Do not do it yourselves! If will not get your Free Ice Cream....
LINE Event: FREE Sundae Cone – The staff at McD will click on this. Do not do it yourselves! If will not get your Free Ice Cream….

Tata!~

LINE Event: FREE Sundae Cone!! Yummy~ Thanks LINE Malaysia and Thanks McD
LINE Event: FREE Sundae Cone!! Yummy~ Thanks LINE Malaysia and Thanks McD

Excel Pivot Table Sequence No or Count Row Number

Today one of my job task is to find the way to count the number of row in the Pivot table.

I am using Microsoft Excel 2013.

The step is pretty simple if you know the step to do it.

Get the Calculated Field in Pivot Table.

1. Select the Pivot Table. On the “Analyze” Tab → “Calculations” Group → Fields, Items, & Sets → Calculated Field.

Calculated Field
Calculated Field
Insert Calculated Field Name: No. Formula: = 1 Click "Add"
Insert Calculated Field
Name: No.
Formula: = 1
Click “Add” Button
Drag the field to VALUES Sections
Drag the field to VALUES Sections

Click on the Sum of No., select Value Field Settings..

Value Field Settings for Summarize Values By SUM
Value Field Settings for Summarize Values By SUM
Show Values As "Running Total in" Base field: Course
Show Values As
“Running Total in”
Base field: Course

Here you go!!

Sequence Number for Pivot Table
Sequence Number for Pivot Table

You can get more information about this post in Microsoft Community

http://answers.microsoft.com/en-us/office/forum/office_2007-excel/just-want-to-count-the-rows-when-subtotalling-in/0a3779d1-e596-4590-b67d-874d2ff76252

Happy Learning~

Windows 8 Drag and Drop Not Working in Adobe Photoshop

So you are using Windows 8, without the drag and drop function in Adobe Photoshop is like lagging something good that you work with. The solution and the only really possible fix is to totally disable UAC (user account control).

How to fully  disable UAC on Windows 8

Go to Start > Run or Window Key+R then type:  regedit     (then press enter).

The windows registry editor will now open.

You now need to follow this route through the registry editor:

HKEY_LOCAL_MACHINE > SOFTWARE > Microsoft > Windows > CurrentVersion > Policies > System

Then Find this Key EnableLUA, Double Click on it and change the Value data from 1 to 0.

After pressing OK you’ll notice in the task bar a message pops up saying UAC is now disabled and a restart is required.

After the restart everything will run as it did on Windows 7,  Ensure you’ve untagged “Run as Administrator” on your app shortcuts.

Good Day!

remove Push to SVN or Remove SVN DCommit (Migrate from SVN to GIT)

I has been migrate from SVN to GIT quite sometimes, however what is the most annoying me is the GIT context menu still have the option of SVN. I would like to totally remove it. I tried to google for this solution unfortunately I can’t find any related solution. In this case, I would like to get my hand dirty to have try to totally remove it.

1. Go to GIT config file. (Normally locate at .git/config
Remove [svn] setting there.

[svn-remote "svn"]
	noMetadata = 1
	url = https://mycomputer/svn/myproject
	fetch = trunk:refs/remotes/trunk
	branches = branches/*:refs/remotes/*
	tags = tags/*:refs/remotes/tags/*
[svn]
	authorsfile = c:/authors.txt

After I remove SVN related config the SVN DCommit option is still there. The next thing I would try is remove the .git/svn folder.

remove svn folder in .git
remove svn folder in .git

VoilĂ ~ No more SVN DCommit or if you using SourceTree you will not have the default “Push changes immediately to Subversion“!

Happy Coding~

 

*Note: I did try another folder also migrate from SVN to GIT, actually you just remove the .git/svn folder it will remove the SVN feature.