Creating Views Click the Start Menu should be on

  • Run Regedit
  •  Sign in to address the following key: HKEY_CURRENT_USER \ Control Panel \ Desktop
  • Add new data type String Value 
  • Change the name of the data into MenuShowDelay and fill in value to 999
 

Respecting differences

One time, there is a professor who wants to take time from her daily life as an academic. Finally he decided to go to a beach and asked a fisherman to take him away to the horizon at sea.
A quarter of the trip, the professor asked, "O fisherman, whether you know the science of geography?" The fisherman replied, "the science of geography which I know is that the sea has begun to frequent tidal waves, then the rainy season will arrive soon." "Fisherman stupid! "the professor said. "Did you know that by not mastered the science of geography you have lost a quarter of your life."
A quarter of the next trip, the professor asked the fisherman if he studied biological sciences and science? The fisherman replied that he knew the biological sciences is to know what kind of fish can be eaten. "Fishermen stupid, with no master of science you've lost a quarter of your life." Then the professor told me about the God who created mankind with the body structure, the same brain capacity, and others.
Furthermore, the professor asked if fishermen are learning math? The fisherman replied that the mathematics which he knew was how to weigh their catch, already counting the cost of issuance, and sell their catch in order to generate sufficient profits. Again the professor is saying how stupid the fisherman and he had lost another quarter of his life.
Then, on the road after a far from the beach and close to the horizon, the professor asked, "what does a black cloud that hangs in the sky?" "Hurricane storm is coming soon, and will make the oceans become very dangerous." Answered the fisherman. "Do you know how to swim?" Said the fisherman.
It turned out that the professor does not know how to swim. The fisherman then said, "I may have lost three-quarters of my life by not studying the three subjects that had been expressed by professors, but professors will lose all the life they have."
The fishermen then jumped from the boat and swam to shore while the professor was drowned.
Likewise in our lives, whether in work or daily life. Sometimes we underestimate friends, subordinates or fellow colleagues. The phrase "
he does not know anything" may unconsciously often express when we're discussing an issue. In fact, there are times when other people more aware and have specific capabilities that can address problems that arise.
An operator in a textile mill mixing color or paint may be more to know the things that are technical rather than superiors. In essence, people who cultivate their fields everyday to understand in detail exactly what she is doing compared to people 'outside' who only know the 'skin' alone.

Salt in Lake

Once, there lived a wise old man.

One morning there came a young
man who was troubled. Stride was unsteady and his face complicated. The visitor, it looks like people are unhappy.

The young man tells his troubles. A wise old man, just listen carefully. He then grabbed a handful of salt, and asked his guests to take a glass of water. He sowed salt into a glass, then stirred slowly. "Take, drink this, and tell me how it feels?", Said the old man. "Salty, salty at all," replied the guest, as he spat on the side. Old Man, a little smile. He then invited his guest, to walk to the edge of the lake in the woods near his residence.


The two men walked side by side, and finally they came to the edge of the lake is calm. The old man, then again sprinkled a handful of salt, into the natural lake. With a piece of wood, made ​​by churning waves and created a ripple of water, disturbing the peace of the lake. "Look, take the water of this lake, and drink." When the guests drank the water that's done, old man said again, "How does it feel?". "Fresh", replied his guest. 'Do you feel the salt in the water? ", Asked the old man again. 'No', replied the young man.

With the wise, old man patted the young man. He then sat facing him, kneeling beside the lake. "Young man, listen. The bitterness of life, is like a handful of salt, no more. The number and it is the same bitter taste and it will remain the same. "



"But, the bitterness we feel, will greatly depend on the container we have. Bitterness, it will be based from feeling where we put everything. It will all depend on our hearts. So, when you feel the bitterness and failure in life, there is only one thing you can do. Exert yourself to receive all the bitterness. "

The old man returned to give advice. "Your heart is the container. Your heart is where you hold everything. So, do not make your heart is like glass, make like a lake that can reduce any bitterness and turn it into a freshness and happiness. "

Eliminating the option Search in the Start Button

  1. Run Regedit (Start -> Run -> Regedit)
  2. Sign in to address the following key: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\policies\
  3. Add new data with type DWORD Value
  4. Rename the data into NoFind and content value with a

Eliminating Facility Menu Control Panel, Printers, and Network Settings

  1. Run Regedit
  2.  Sign in to address the following key: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\policies\ 
  3. Add new data with type DWORD Value 
  4. Rename the data into NoSetFolders and content value with 0

Do not Arrogant

A shipwreck at sea because of storms and great waves.


Only two men can save themselves and swim to a small barren island. Two of the survivors did not know what to do. However, they both believe that no one can do but pray.
To find out who is most answered prayers, they agreed to divide it into two small island territory. And they lived alone on the opposite sides of the island.



The first prayer they prayed, they begged to be lowered food. The next day, one man to see a tree full of fruit growing on the side of his residence. While in the area where he lived the rest remain empty.
A week later, to a man who feels lonely and decided to pray to be given a wife. The next day, there was a ship wreck and the only passenger who survived was a woman who swam and stranded on the side where the man into one's living. While in the residence to the two men still is not nothing.
Soon, this one man to pray for a house, clothes, and foods. The next day, like a miracle, all that was asked for his present.



While both men are still not getting anything. Finally, this one man to pray for the ship that he and his wife could leave the island. In the morning they found a ship moored on the beach. Soon the men into one and his wife go up to the boat and get ready to sail to leave the island. He then decided to leave the man to the two who lived on the other side of the island. According to him, was the second man was not worthy of a blessing because the prayers never come true.

Once the ship ready to go, this one man to hear the voice echoed from the sky, "Hey, why do you leave your partner at the other side of this island?"


"Blessing for me is just my own, because only prayer was granted," he replied to this one. "Prayer is man's none of my friends is granted. So, he did not deserve anything. "" You're wrong! "Boomed the voice barked. "Did you know that your partner had only one prayer. And, all her prayers come true. If not, then you will not get anything. "

"Tell me," asked the man to one.

"What kind of prayer he prayed that I should feel indebted to all of this to him?"

"He prayed that all your prayers answered!"

What kind of arrogance that makes us feel better than others?

Realize how many people who have sacrificed everything for our success. We should not ignore the role of others, and do not judge someone / something only the "visible" only.


Realize how many people who have sacrificed everything for our success. We should not ignore the role of others, and do not judge someone / something of the "visible" only. 

The Windows Registry Via the Command Line

There are times when you may need to make changes to the Windows Registry via the command line, scripting in Windows is one example.

In this article we will look at the command line utility Microsoft provide for this activity.

Using Reg.Exe

Microsoft provide the command line tool Reg.Exe for working with the Windows Registry for users of Windows XP/Vista/7. It comes with the following built in functions:

QUERY / ADD / DELETE / COPY / SAVE / LOAD / UNLOAD / RESTORE / COMPARE / EXPORT / IMPORT

Whilst it is beyond this article to fully explain each of these options of Reg.Exe, we can look at some common examples of each.

QUERY

The REG QUERY command allows the user to query a single key for a single value, or a range of keys for all their values. To display the full range of parameters that can be used, type the following into the command line:  reg query /?

To display all subkeys and values under the key HKLM\Software\Microsoft\ResKit\Nt\Setup on a remote computer named ABC, type:

  REG QUERY \\ABC\HKLM\Software\Microsoft\ResKit\Nt\Setup /s

To display the key, value, and data for exact and case sensitive matches of SYSTEM under the HKLM root of data type REG_SZ, type:

  REG QUERY HKLM /f SYSTEM /t REG_SZ /c /e

To display all the subkeys and values of the type REG_MULTI_SZ using # as the separator, type:

  REG QUERY HKLM\Software\Microsoft\ResKit\Nt\Setup /se #

ADD

The REG ADD command allows the user to add new keys and values to the Registry. To display the full range of parameters that can be used, type the following into the command line:  reg add /?

To add the key HKLM\Software\MyNewApp on remote computer PC2, type:

  REG ADD \\PC2\HKLM\Software\MyNewApp

To add a registry entry to HKLM\Software\MyNewApp with a value named Data of type REG_BINARY and data of fe340ead, type:

  REG ADD HKLM\Software\MyNewApp /v Data /t REG_BINARY /d fe340ead

DELETE

The REG DELETE command allows the user to remove a Registry key or value (it will remove all subkeys and values beneath the key - but will always confirm you wish to perform the deletion first.) You should perform this as an Administrator. To display the full range of parameters that can be used, type the following into the command line:  reg delete /?

To delete the registry key Timeout and its all subkeys and values, type:

  REG DELETE HKLM\Software\MyCo\MyApp\Timeout

To delete the registry value MTU under HKLM\Software\MyCo on the computer named PC2, type:

  REG DELETE \\PC2\HKLM\Software\MyCo /v MTU

COPY

The REG COPY command allows the user to copy a single value or an entire hive from its original location to another - local or remote. This is a VERY popular command for administrators supporting Windows computers. To display the full range of parameters that can be used, type the following into the command line:  reg copy /?

To copy all subkeys and values under the key MyApp to the key SaveMyApp, type:

  REG COPY HKLM\Software\MyCo\MyApp HKLM\Software\MyCo\SaveMyApp /s

To copy all values under the key MyCo on the computer named PC2 to the key MyCo1 on the local computer, type:

  REG COPY \\PC2\HKLM\Software\MyCo HKLM\Software\MyCo1

SAVE

The REG SAVE command allows the user to save a copy of specified Registry subkeys, entries, and values in a specified file. To display the full range of parameters that can be used, type the following into the command line:  reg save /?

To save the hive Perk30 into the current folder as a file named MyRegHive.hiv, type:

  REG SAVE HKCU\Software\Perk30 MyRegHive.hiv

To save the hive Perk30 into the folder Backups, as a named MyRegHive.hiv, type:

  REG SAVE HKCU\Software\Perk30 C:\Backups\MyRegHive.hiv

LOAD

The REG LOAD command allows the user to write saved subkeys and entries into a different subkey in the registry - it only applies to HKLM and HKU. It is intended for use with temporary files that are used for troubleshooting or editing registry entries. (You can use this command to load an alternative Default user profile on a PC for example). To display the full range of parameters that can be used, type the following into the command line:  reg load /?

To load the file TempHive.hiv to the Key HKLM\TempHive, type:

  REG LOAD HKLM\TempHive TempHive.hiv

UNLOAD

The REG UNLOAD command allows the user to remove a section of the registry that was loaded using the reg load operation.. To display the full range of parameters that can be used, type the following into the command line:  reg unload /?

To unload the hive TempHive in the file HKLM, type:

  REG UNLOAD HKLM\TempHive

RESTORE

The REG RESTORE command allows the user to write saved subkeys and entries back to the registry. To display the full range of parameters that can be used, type the following into the command line:  reg restore /?

To restore the file named NTRKBkUp.hiv into the key HKLM\Software\Microsoft\ResKit, and overwrite the existing contents of the key, type:

  REG RESTORE HKLM\Software\Microsoft\ResKit NTRKBkUp.hiv

COMPARE

The REG COMPARE command allows the user to compare specified registry subkeys or entries. To display the full range of parameters that can be used, type the following into the command line:  reg compare /?

To compare all values under the key MyApp with all values under the key SaveMyApp, type:

  REG COMPARE HKLM\Software\MyCo\MyApp HKLM\Software\MyCo\SaveMyApp

EXPORT

The REG EXPORT command allows the user to copy the specified subkeys, entries, and values of the local computer into a file for transfer to other servers. To display the full range of parameters that can be used, type the following into the command line:  reg export /?

To export the contents of all subkeys and values of the key MyApp to the file AppBkUp.reg, type:

  REG EXPORT HKLM\Software\MyCo\MyApp AppBkUp.reg

IMPORT

The REG IMPORT command allows the user to copy the contents of a file that contains exported registry subkeys, entries, and values into the registry of the local computer. To display the full range of parameters that can be used, type the following into the command line:  reg import /?

To import registry entries from the file named AppBkUp.reg, type:

  REG IMPORT AppBkUp.reg

How to Transfer Blog Account on Blogspot

If we have two different accounts-let's call it Account A and Account B, the plan we want to transfer one of the blogs on Account A to Account B, it should be noted that the account that gives the power (which invites Account / Account-A ) is the account that his blog will be transferred, which means the account-B is what will receive the full power of blogs in account-A.
  1. Log into your account will be transferred (eg acount-A) 
  2. Click "Dashboard" then select "Settings" 
  3. On the Settings tab select the sub tab "permission" 
  4. Click the button "Add Authors" 
  5. Enter your Gmail address to another account (Account B), in which case we invite gmail account is the account that will accept transfer of the blog. 
  6. If you have, we have to login to gmail addresses will be invited (Account-B) and will receive a letter of promulgation to join in Account-A. 
  7. In the email we receive there is a link there, click on the link that we agree to contribute to the blog Invitor, do not forget to put the password as a sign of approval. 
  8. On the "Control Panel" has seen no new blog from the account-A.
  9.  Further back again to Account-A or back to the No. 1,2 and 3. 
  10. On this page looks Account-B, which has been in the law, do not forget to click the link "Give me your admin-level privileges" and pressing the "Give the admin level privileges" in the popup that appears. 
  11. If we do not want to use the Account-A and only give admin rights on-Account B we can remove permissions Account-A by clicking on the "delete". 
  12. Done .. and congratulations we've done the transfer from the blog into acount acount-A-B, to transfer the other blogs do the same with the above process.

Install Java in Windows

  1. Download Java
  2. The File Download dialog box appears prompting you to run or save the download file. Click Save to download the file to your local system. Tip: Save the file to a known location on your computer, for example, to your desktop. 
  3. Close all applications including the browser.
  4. Double-click on the saved file to start the installation process.
  5. The installation process starts. Click the Install button to accept the license terms and to continue with the installation.

Eliminating the option Open, Explore, and Search on the Right Click of Start Button

  • Run Regedit 
  • Sign in to address the following key: HKEY_CLASSES_ROOT \ Directory \ shell 
  • Rename the subkey shell into Shel-old
  • Sign in to address the following key: HKEY_CLASSES_ROOT \ Folder \ shell 
  • Rename the subkey shell into Shel-old
  • After the second subkey renamed, do the refresh computer
 

While There's Still Time

There was a young entrepreneur who that morning rush leaving office because he overslept. While that morning he was meeting with his business associates. In his haste, he did not get to eat breakfast made by his wife. He then decided to stop into a store to buy bread instead of breakfast. He thought, "Later this bread eaten in the office alone."
When he was selecting who want to buy bread, his interest in a child aged about ten years of being pick flowers in the shop next door. This little fellow was seen haggling with the clerk of interest rates are.
"Ma'am, how much interest rates?" He asked the clerk.
"Five dollars," replied the waitress.
Then he chose another flower and asked again,
"If interest is how much?".
"It's more expensive, fifteen dollars!" Replied the waitress.
"If that is how much?" He asked, showing interest even better.
"It cost twenty-five, son!" Replied the waitress.
This child looked puzzled as increasing interest rates high, while he did not realize that the flowers which he was nominated best interest.
Sadly he asked, "Are there any flowers that cost a half dollars?"
This kid was just having money and a half dollars despite his desire to get the flowers are very large. Have not had the clerk answered, the young entrepreneur was soon asked his son, "Son, you want to buy flowers for whom?"
Then the boy answered, "I want to buy flowers for mom, because mom's birthday today!" These young entrepreneurs snapped up, in his heart he said, "oh god, I forgot! Today is my wife's birthday. I do not say happy birthday to him. If I forget, he can be angry! "Immediately he said to the clerk," Ma'am, I bought these flowers. I bought two ikat. Only for this child. Please later among these flowers to my home address, "he said as he gave her his card. Then the young entrepreneurs that give the flowers to the child and say thank you for reminding him that today was also his wife's birthday. The boy then went.
This entrepreneur rushed to his car and proceeded to the office. When he was driving, he passed the little boy is running. And he stopped and asked if he was one-way with her. The little boy said yes and then get into his car.
Until somewhere a bit quiet this child asked for down. Young entrepreneurs are surprised to see this little boy go through a small hallway. Curious, he followed the boy from behind. How shocked she was when I saw this little boy put the flowers on a mound of yellow that is still wet.
Then he asked, "Son, this cemetery who?"
The little boy then replied, "Uncle, my mother's birthday today. But unfortunately, my mother had just died two days ago. Therefore I came to this place to bring flowers and congratulate mommy's birthday. "
Young entrepreneurs are so struck by the words of this child.
"Is my wife is still alive today?" She wondered.
Immediately he ran into the car, driving at high speed and headed into the store. With panting she said to the clerk, "Where flowers did I buy? The flowers do not have to be sent, let me just who immediately gave it to my wife's hand. "
He quickly grabbed the interest and drive home. Back home, he immediately ran to his wife. "Praise the Lord! My wife is still alive! "While giving the flowers she said," My wife, a happy birthday. " Then he kissed and hugged his wife tightly as he gave thanks to God. Weeping, she said, "Thank you, Lord. You still give me a second chance. "
Many of us are too busy with everyday activities. Activities and routines were already 'killed' attention and the important moments to be enjoyed with the people we love; parents, husbands, wives, children, and our brothers.
For the sake of pursuing a career, money and position the service even more people forget about the family. A businessman was just thinking that satisfy the material needs of his wife and children had made him feel like a good father. A servant of God thought that with a busy in service and is known everywhere have made him feel like a righteous man in the family. We are not aware, we are wrong to think so.
Today, if we are given the opportunity to live all a gift Allh. Therefore, do not wait until tomorrow to show our love and affection to those around us, especially those closest to us. Do not wait until we realized they were gone. Do not wait until tomorrow! Because we do not know what will happen to tomorrow. If we still lived in today means that this second chance for us. Take the second chance that God gives to us today.

Displays the Start Menu quickly

  • Run Regedit
  • Sign in to address the following key: HKEY_CURRENT_USER \ Control Panel \ Desktop
  • Add new data with type String Value
  • Rename the data into MenuShowDelay and content value with

No Easy Way To Success

In the morning, seen a young man with a cloth bundle containing provisions on his back underway with the aim of climbing to the top of the mountain.
The legend says that at the top of the mountain there are beautiful views like being in heaven. Arriving at the mountain, seen a small house inhabited by an old man.
After greeting the owner of the house, the youth expressed intention "Old man, I want to climb this mountain. Please, show them the easiest way to reach to the top of the mountain ".
The old man reluctantly raised his hand and showed three fingers into the front of the youth.
"There are three roads to the summit, you can choose left, center or right?"
"If I choose the left?"
"The left past a lot of rocks." After saying goodbye and saying thank you, the young man hurried on his way. A few hours later, with sweat streaming down, the boy looks back at the front door of the old man's house.
"Old man, I can not pass through steep rocks. The road next to where else should I pass? "
The old man with a smile reappoint three fingers replied, "Pick your own, left, center or right?"
"If I choose the right path?"
"To the right a lot of brambles." After a brief rest, the young man went back up. A few hours later, he returned to the house of the old man.
With fatigue the young man said, "Old man, I really want to reach the top of the mountain. Right and left of the road I have traveled, I seemed to keep circling in the same place so I have not managed to climb to higher ground and had to come back with no results I want, please show me another road is flat and easier for me to succeed climb to the summit of the mountain. "
The old man of the youth seriously listen to complaints, glowering he said sternly "Young man! If you want to get to the top of the mountain, there is no way a flat and easy! Obstacles in the form of rocks and thorns, you shall pass, sometimes even a dead end you must face. As long as your desire to reach the top it still does not waver, confront all obstacles! Fight the challenges! Go with your feet step by step, you will surely get to the top of the mountain as you want! and enjoy superb views! Do you understand? "
With amazement the young man heard all the speeches grandfather, smiling happily he replied "I know old man, I understand! Thanks old man! I am ready for the step by step every obstacle and challenge! I was more solid determination to climb again to reach the summit of this mountain.
With a satisfied smile the old man said, "Young man, I believe you can surely reach the top of the mountain! Good luck!
No Easy Way To Success!

Changing Data Horizontal to Vertical or Opposite

Sometimes we need to change our data entry in a vertical to a horizontal sequence. It can be seen from the sequence of steps
  • Select the data to be changed, then copy (right click, select copy)
  • Place the cursor in cell where data is moved, then do a right click and select Paste Special
  • In the Paste Special menu, and tick theValue and Transpose
  • Please see the results
 

Hide the "All Programs" in the Start Menu

  • Run Regedit (Start -> Run -> Regedit)
  • Sign in to address the following key: HKEY_LOCAL_MACHINE \ SOFTWARE \ Microsoft \ Windows \ CurrentVersion \ Policies \ Explorer
  • Add new data with type DWORD Value
  • Rename the data into NoStartMenuMorePrograms and content value with 1
 

Noodle bowl

That night, Ana a fight with her mother. Because of very angry, Ana immediately leave the house without bringing anything. When walking on a street, he realized that he did not bring money.
When down a street, he passes a noodle shop and he smelled the scent of cooking smells. He wanted to order a bowl of noodles, but she had no money.
Owner of the shop long enough to see Ana standing in front of the restaurant, then said, "Miss, do you want to order a bowl of noodles?"
"Yes, but .. I do not bring money, "Ana replied shyly.
"It's okay, I'll buy you" replied the shop owner."Please sit down, I'll cook noodles for you".
Not long after, the owner of the shop was delivering a bowl of noodles.
Ana immediately eat a few mouthfuls, and then the tears started welling.
"What lady?", Asked the proprietor.
"It's okay. I'm just thrilled, "Ana said, drying her tears.
"In fact, I know someone who just had to give me a bowl of noodles. But .. my own mother, after a fight with me, immediately thrown out of the house and told me not to come back home. And you .. a new familiar, but so concerned with me than with her own blood, "he told the shop owner.
Owner of the shop after hearing the words of Ana, took a deep breath and said, "Miss, why do you think that way? Think about it, I just gave you a bowl of noodles and you're so moved. Your mother was cooking noodles and rice for you when you were little until now, why do not you thank him? And you're fighting with him "
Ana, was shocked to hear these things without.
"Why did not I think about it? For a bowl of noodles from a new person I knew, I was so grateful, but to my mother who cooked for me over the years, I did not even show concern for him. And just because a trivial issue, I had a fight with him ".
Ana, immediately spent the noodles, then he braced himself to go home to his house. As I walked into the house, he thought of the words must be spoken to his mother.
Once at the doorway of the house, he saw his mother with his face weary and anxious. When meeting with Ana, the first words out of his mouth were, "Ana, you're home, go fast, I had to prepare dinner and eat before you sleep, the food would be cool if you do not eat it now".

Time

Imagine there is a bank that gives you an amount of Rp. 86 400, - every morning. All that money you can use (no more). At night, the bank will remove the rest of the money that you do not use during the day.
Guess, what would you do? Of course, spending all the money borrowed.

Anyone of us has such a bank; named TIME.
Every morning, he'll give you 86,400 seconds. In the evening he will remove the remaining time that you do not use for good purposes. Because he does not give you the rest of the time. He also did not provide additional time. Every day he would open a new account for you. Every night he would menghanpuskan left.
If you do not use it then the loss will befall you. You can not take it back. Also, you can not ask for a "down payment" for the next day.
You must live in the reserve today.
Therefore, Invest for the health, happiness and your success.
The clock is ticking. Use your time well.

In order to know the importance of time A YEAR, ask the students who failed the class.

In order to know the importance of time A MONTH, ask a mother who gave birth to premature babies.

In order to know the importance of the WEEK, ask the editor of a weekly magazine.

In order to know the importance of AN HOUR, ask the lovers who are waiting to meet.

In order to know the importance of A MINUTE, ask the person behind the aircraft.

In order to know the importance of A SECOND, ask the person who just avoided an accident.

In order to know the importance of A MILISECOND, ask the Olympic silver medalist.

REFLECTION ... ...
"Treasure every moment you have. And remember time does not wait for anybody "

Ranking

In MS Excel we can know the sequence / stages to how a data from the smallest or the largest function RANK (Number; Ref: Order). For the last parameter (order), when its value = 0 it will be sorted in descending and when value <> 0 then be sorted in ascending

Syntax: RANK (number: ref; order)

number: the value of the selected
ref: Array
order: 1 for and 0 for Descending Ascending


Minimum and Maximum values

In Ms Excel to determine the value of the smallest and largest of a data using MIN and MAX functions

Syntax :
MIN(value1;value2;...)
MAX(value1;value2;...)

 

Calculation of Number of Cell

In Ms Excel, to calculate how many cells are filled (not empty) can use the COUNT function and COUNTA.

Syntax : 
COUNT(value1,value2,...)
COUNTA(value1,value2,...) 

 

Position Data on Ascending and Descending Order

In Ms Excel to determine the value of numbers in the n-th position of sequence numbers can use the function is SMALL and LARGE. The second parameter of the function they will state their position (sequence)

Syntax :
LARGE(Array;k)
SMALL(Array;k)


Value of Most Common

In Ms Excel to determine the value of the most frequently displayed in a table can use the MODE function.

Syntax : MODE(number1;number2:...)

MIN, Finding the Smallest Value

Syntax : MIN(field)

Example : SELECT MIN(Harga) AS 'MinHarga' FROM Barang;

Min function is used to find the smallest value from a field in a table


MAX, Finding the Biggest Value

Syntax : MAX (field)

Example : SELECT MAX (Harga) AS 'MaxHarga' FROM Barang;

Max function is used to find the greatest value from a field in a table


COUNT, Count Number of Records

Syntax : COUNT(field)

Example : SELECT COUNT(Satuan) AS 'CountSatuan' FROM Barang;

COUNT function is used to calculate the number of records from a field in a table that is not worth NULL


AVG, To Obtain Average Score

Syntax : AVG(expression)

Example : SELECT AVG (Harga) AS 'AvgCost' FROM Barang;

 AVG function is used to obtain the average value in a numeric field type


Trials of Life

A child complaining to his father about his life and ask why life is so hard for her. He does not know how to deal with it and almost gave up. He was tired to fight.
It seems like every time one problem is completed, new problems arise. His father, a chef, took her to the kitchen. She filled three pots with water and put it on the fire. Soon the pots came to boil. He put the carrots in the pan first, second and eggs in the pan he put ground coffee in the pot last. He let it boil without saying a word. The child is silent and waited impatiently, wondering what he was doing his father. After 20 minutes he turned off the fire. He set aside the carrots and put them in the bowl, picked up eggs and put it in another bowl, and pour the coffee in another bowl. Then he asked his daughter, "What you see, son?"

"Carrots, eggs, and coffee," she replied.
His father brought her closer and asked her to feel the carrots. She did and noted that they were soft. His father then asked him to take an egg and break it. After throwing his skin, he found a boiled egg is hardened. Finally, her father asked her to sip the coffee. He smiled when tasting coffee with a rich aroma. After that, the boy asked, "What does it mean, Dad?"

He explained that each had faced the same adversity, boiling water, but each reacted differently. Boiled carrots before the strong, hard and difficult to break. But after boiling, carrots become soft and tender. The egg had been fragile. Thin outer shell had protected its liquid interior. But after the boiling water, its inside became hardened. Coffee powder changes to a unique experience. Once in the boiling water, they changed the water. "You are including which one?" Asked his father. "When adversity knocks on your door, how do you respond? Are you a carrot, an egg or a coffee?"

How about you? Are you the carrot that seems strong, but with pain and adversity do I wilt and become soft and lose my strength. Am I the egg that starts with a malleable heart? With a dynamic spirit, but after a death, heartbreak, divorce or dismissal becomes hard and rigid. From the outside looks the same, but if you become bitter and tough with a stiff spirit and heart? Or am I like the coffee bean? Coffee grounds to change the hot water, something that causes pain, to reach it's maximum at a temperature of 100 degrees Celsius. When the water reaches the temperature of the hottest, the coffee taste better and better. If you like the coffee bean, when things get worse, you will become better and make things around you are also improving.

Satisfaction lies in the business, not the outcome. Trying hard is the ultimate victory. (Mahatma Gandhi)