Thursday, May 5, 2016

How To Convert Amount To Words In Excel

Hello there!

In this tutorial, I am going to show you a Visual Basic Script for converting amount to words in excel.

Prerequisites:
    - The reader is expected to know how to use Excel VBA (Visual Basic for Applications) in order to follow the following instructions.


1. First, open your excel application

2. Navigate to the VBA by pressing Alt+F11

How to Generate Random Numbers in Excel

Generating random numbers in excel is very easy..

There are two ways to achieve this:

1. Using the RAND() function, and
2. Using the RANDBETWEEN() function

The first is the easiest, you just have to input the formula on

How to Concatenate Strings in Excel

In this tutorial, we are going to learn how to concatenate (combine) two or multiple strings in Microsoft Excel spreadsheets or any other similar applications.

Pre-requisites:
    1. The reader is assumed to have a background in using basic functions in excel.

Every content of a cell in an excel spreadsheet is considered a string.

To combine two strings, we use the '&' ampersand operator:




Let's try it in excel.

How To Draw Arrow In Autocad

In this tutorial, we will try to draw a solid arrow in Autocad using polyline.

The arrow should look similar to this:


Here is a sample dimensions that we are going to use in drawing a solid arrow similar to the above image.

Creating PHP Page

This tutorial is a contiuation of my first tutorial, the setting up your own web server.

In this tutorial, we will create a test page.


This page will be composed of html and php.

PHP by the way is a server-side scripting language.

Now we will create a php page.

Go to the installation directory of your WAMP Server, then go to 'www' and let's create another directory inside. Let's call it 'TestDirectory'.

Inside this directory, create a file called 'index.php' and paste the below code.

Now, save that file and go to your browser. Input in the address bar 'localhost/TestDirectory' and you

Wednesday, May 4, 2016

Setting PHP Server Offline

This tutorial will be a quick one describing on how to set-up your own server on your computer using WAMP server.

WAMPServer stands for Windows Apache MySQL PHP Server.

It is a Windows environment that allows you to develop web applications using PHP and MySQL on your machine. This is a good way of testing website projects or developments offline without using any hosting services just yet.

After installing/configuring your WAMPServer, you will now be able to develop your own web applications.

Here are the instructions:

1. First is to download the WAMP Server:

    The latest at this time of writing is WAMPServer 64bit & PHP 5.6.15 & PHP7:
           Click to Download for 64 bit machines and

Diversion Dam Software

First of all, I would like to give thanks to the people who made the creation of this software possible. To Engr. Zeny for encouragement to me to write this program and support during that time. To Engr. Cocoy for giving answers to every questions that I can throw and allowing me to take a peek for his excel program similar to the one I wrote and to my fellow designers and friends who helped me debug and test the program to see if the results were acceptable.

This program I called 'Diversion' is an aid to hydraulic