All (not) Open Source

Sometimes we need to calculate year, month and day between 2 cells in  Microsoft Excel. For example, You have an employees database in excel that record the date they joined the company and then you want to know "how long each employee has worked for the company until now?" In the such above case, I do the following in Microsoft Excel 2010: I Input the "signed date" in cell C3 after "No" in cell C1 and "Full Name" in cell C2. Make sure to assign "Date" as Cell Format for Cell C3. I input =NOW() in Cell C4 and this will show the current date. And the calculation begin in cell C5. In cell C5, I put formula like this: =DATEDIF(C3,C4,"y") & " years, " & DATEDIF(C3,C4,"ym") & " months, " & DATEDIF(C3,C4,"md") & " days" And the result of the above formula is like this: 19 years, 3 months, 11 days . If you do not want to show the "day", ju...

Sometimes we need to know whether our mx records are configured correctly. How to do it in Win 7? Here are the step: Go to start button, All Program Go to accessories menu Click on Command Prompt After the Command Prompt window appear, do this: type: "nslookup" and press enter type: "set type=mx" and press enter type "the domain name which you want to check its mx configuration" All done, and you will see the result Still having problem? You can ask in the comment bellow.

Some time we want to highlight some cell in Microsoft Office Excel which we considered as important or give stressed for a certain term. How to do that? Below are the instruction, especially for MS Office Excel 2007 that we can use conditional formating

I have Bufallo data link station 1 terabyte attached to my LAN. I have created some shared folders and each of shared folder has user access restriction only for certain user. One day I have to change my admin password. Open Command Prompt (Start > Search "cmd" > Enter) Enter the line: rundll32.exe keymgr.dll, KRShowKeyMgr When the window comes up you should be able to manage stored keys.

ImageMagick is dealing with image processing (on the web) that used by imagick PHP extension. MODx, one of PHP popular Content Management Framework is using ImageMagick for its gallery module. My CPanel Server does not have ImageMagick, so I have to install it. My server uses WHM version 11.30.2 and I plan to install ImageMagick from WHM dash board. In WHM, I go to "Software" and then go to "Install a RPM". From RPM list, I install ImageMagick and ImageMagick Devel respectively. This step basically will install ImageMagick application. Then the second step, I install Imagick PHP extension. I go to "Software" and then go to "Modules Installer". After that I choose PHP-pecl menu by clicking the "manage" button. Input "imagick" into "Install a PHP Pecl" form then hit the "Install Now" button. And the final step is to restart httpd (apache) web server services. And thats all.

I try Ubuntu 11.04 live cd on my Virtual Box to see all applications on its package. I just want to know all default application before I install it. Using Desktop Recorder, I make a video to show all Ubuntu 11.04 default application and what its looks like.

When I work together with my partners in my office, sometimes I should make some revision on a document that proposed by my partner. It is easy to modify the word document with Libre Office Writer, but I want to track what character, word or sentences that I have changed, so my partner can easily find my revision. In Libre Office Writer, after I open a word document, then I go to the "Edit" menu. From "Edit" menu, I choose "Changes" sub-menu and then give a check mark on "Record" sub-menu. After I do the above operation, I found that when I type a revision on the opened document, it will typed on orange. So my partner will easily find what I have revised. When I deleted a character, word or sentences, the deleted character/word/sentences would become a single strikethrough character/word/sentences. So, it easy to collaborate with other staff using Libre (Open) Office Writer.