Freelancer

Wednesday, September 25, 2013

[Tip] Show all sheets in Excel 2013

If you have tried Excel 2013, you would see a new style of manage sheets. For somebody, it's strange and hard to use if there are many sheets.
Today I will show you how to view all sheets and move to any sheet you want. It's very easy!

Excel sheets
Excel sheets



Right click on the arrow

excel sheets tooltip

And here is what you'll see!

excell all sheets

Wednesday, August 21, 2013

[Tip] Set static ARP

For Windows XP

1. Open Command Prompt
2. At the command prompt, type:
arp -s ip_address mac_address
Example:
arp -s 192.168.2.1 00-34-A3-7D-66-FF
3. In order to delete the static arp entry, type:
arp -d ip_address
Example:
arp -d 192.168.2.1

For Windows 7, Windows 8

1. Open Command Prompt
2. At the command prompt, type:
netsh -c "interface ipv4" set neighbors "connection_name" "ip_address" "mac_address"
Example:
netsh -c "interface ipv4" set neighbors "Wi-fi" "192.168.1.1" "00-A3-F7-C0-AE-32"
3. In order to delete the static arp entry, type:
netsh interface ipv4 delete neighbor "connection_name" "ip_address" "mac_address"
Example:
netsh interface ipv4 delete neighbor "Wi-fi" "192.168.1.1" "00-A3-F7-C0-AE-32"
When you restart the computer, if the arp entry is still displayed, go to this link for more information.

For Linux

1. Open Terminal
2. At the terminal prompt, type:
sudo arp -s ip_address mac_address
Example:
sudo arp -s 10.0.0.2 00:0C:29:C0:94:BF
3. In order to delete the static arp entry, type:
sudo arp -d ip_address
Example:
sudo arp -d 10.0.1.0

Tuesday, August 20, 2013

How much time you surfing in a day

Today I found some firefox extensions to track you browsing time. These extensions are good for someone who is easy to be distract in working. It let you know how much time you spend for each page. Here they are:


Mind the Time



mind the time, browsing time, surfing time


Rescue Time



rescue time, browsing time, surfing time

Monday, August 19, 2013

[Cooking] Poached pork with egg

Today, I give a guide to cook "poached pork with eggs" - an Asia food.

pork with egg, pork and egg, thịt kho trứng

Ingredients:

  • 600 grams pork ham
  • 4 duck eggs
  • 1 liter of coconut water
  • Star anise
  • Fish sauce
  • Monosodium glutamate (MSG)
  • Colored water
  • Sugar
  • Chopped onion
  • Chopped garlic
  • Pepper
  • Cooking oil

Directions:

  1. Cleaned pork, cut into bite size pieces, marinate with 1 tablespoon of chopped garlic, 1 tbsp. of chopped onion, 1 cup of fish sauce, 4 tbsp. of sugar, 1 tbsp. of MSG, 1 teaspoon of ground pepper, 1 tbsp of colored water, 2 tbsp of cooking oil, for about 15 minutes for the spices are absorbed.
  2. Boiled duck eggs for about 10 minutes, let cool, peel. Then put into a heat frying pan of oil, fry until yellow evenly.
  3. Put pork to the pot star anise, add fresh coconut water. Cook over medium heat until the meat is ready, just cooked, remove foam. Then add the duck eggs and cook with eggs in small fire until the meat is tender, done.

Saturday, August 17, 2013

[Tutorial] Install Damn Small Linux (DSL) 2.4 on Virtualbox

Step 1: Install Virtualbox (DIY)
Step 2: Download dsl iso install file
Access ftp://distro.ibiblio.org/pub/linux/distributions/damnsmall/ select the archive folder and download the file dsl-2.4.iso (if you want the newest version, select the current folder)

dsl, virtualbox, linux, install

Step 3: Install and setting
Open virtualbox and click New

dsl, virtualbox, linux, install
dsl, virtualbox, linux, install
dsl, virtualbox, linux, install
dsl, virtualbox, linux, install
dsl, virtualbox, linux, install
dsl, virtualbox, linux, install
dsl, virtualbox, linux, install
dsl, virtualbox, linux, install
dsl, virtualbox, linux, install

Now config the created virtual machine

dsl, virtualbox, linux, install
dsl, virtualbox, linux, install

Replace SATA controller by IDE controller:

dsl, virtualbox, linux, install
dsl, virtualbox, linux, install

Choose dsl.vdi file >> Open >> Ok

dsl, virtualbox, linux, install

Now start the virtual machine and install dsl

dsl, virtualbox, linux, install
dsl, virtualbox, linux, install
dsl, virtualbox, linux, install

Select the dsl-2.4.iso file downloaded before

dsl, virtualbox, linux, install
dsl, virtualbox, linux, install
dsl, virtualbox, linux, install

When the boot screen appear, press Enter key and wait for dsl to start


dsl, virtualbox, linux, install

Here is what we got:
(If you have problem with mouse, select Machine >> Disable Mouse Integration

dsl, virtualbox, linux, install

Now, right click on desktop >> Xshell >> Root Access >> Transparent

dsl, virtualbox, linux, install

The shell window appear, type fdisk /dev/hda

dsl, virtualbox, linux, install

Press 'm' key for help menu:

dsl, virtualbox, linux, install

Type commands as the following image:
(n >> p >> 1 >> 520)

dsl, virtualbox, linux, install

 Continue with these commands: t >> 83 >> w


dsl, virtualbox, linux, install

Now, close the shell window, right click on desktop >> Apps >> Tools >> Install to Hard Drive


dsl, virtualbox, linux, install

A window appear, type hda1 >> n >> n >> y


dsl, virtualbox, linux, install

Type 'y' and press Enter:

dsl, virtualbox, linux, install

Type 'g' to make Grub boot loader:


dsl, virtualbox, linux, install

After this, type 'y' to restart the virtual machine, and then you got DSL installed.