HOW TO CREATE YOUR OWN NUMBER TO WORD CONVERTER IN MS EXCEL, MS VISUAL BASIC, MS ACCESS OR PHP?
PART 1
1. INTRODUCTION
As promised about a year ago, I'll share the subject with you. !!! :)
Lets choose the platform from which you want to do your program from. For this free lesson and for the purpose of easy access to the tools, I would create the conversion on MS EXCEL. MS Excel is readily available in your laptop and you can experiment on what I do here immediately in your computer.
For Visual basic - either Visual Basic (this is a powerful programming language and some fighter jet cockpit software is written abd driven by Visual Basic) or visual basic for application, the approach to N2W is greatly different. So does PHP and other programming languages.
There should be no problem with other programming language coding because you will know where to start and what to do once you understand the subject that you want to do program on.
1. STUDY THE LANGUAGE STRUCTURE
Let the conversion be named as "Number to Word (N2W) - English" (N2WE), Malay- (N2WM), Miriek (N2WR)
You can't start your programming or coding work until you fully understand the language structure of the language that you want to do N2W." The same goes with other subject that you want your computer and programming tools to do. If you want to do CALENDAR, you have to know how exactly the values in the particular calendar works. It may be a muslim or chinese or any other calendar system. One of the worst nightmare ever was the Y2K bugs that exist in some computer program that can "hay-wire" the whole program. It means that you computer can no more understand the function that was build in the calendar system.
Before we start the complex task of doing the coding one have to understand the stucture of the language you are going to do your conversion with.
In this example we are going to convert number into word in English Language, Malay & Miriek Language. The reason why I want to use English, Malay and Miriek at the same time is for the purpose of highlighting the difference in structure of the three Languages and thereby will also teach you the detail of the subject before you start the more exciting part, ie coding.
I am not going to teach you excel here. I assume that you have the basic knowledge sufficient to understand and follow the instruction (If you intend to).
I have not seen any conversion in excel done or available on internet yet. There could be many out there but have not found any one available as downloads and of course I had mine somewhere on the internet available for free somewhere BTW I have forgotten the link as to where I posted it for that particular download some 15 years ago) and it was a N2WR (In Miriek language) but it was caption as "Learning how to count in bahasa Miriek Language"then.
I do not know how they do it but i know it is a very long and tedious and systematic approach to solving a problem. I have my way and for as long as it can achieve what i want it to do, then, I consider it DONE !!.
NOW THE ENGLISH LANGUAGE STRUCTURE INVOLVE IN THE COUNTING
0 - Zero, When standing alone without any number or digit other than itself, in front or behind it, it is called and pronounced as "zero" (Lets hear how it sounds) If there is any other digit after it, it will never retain or sounded anything to do with ":zero"anymore. Eg. 10 => sound "ten". Threre is no mention of "zero"even if you have ten, twenty or 30 pieces of zeros in front. It is going to be spoken out with no mention of "zero"" again.
Simply, zero is only mentioned once and it is cm"unique" BUT if a decimal (Dot) is introduced behind the number zero with another digit greater than zero (>0) ie any number 1 to 9, then you still have to call it as Zero. Eg. 0.01 - read as Zero Point Zero One. In this case (decimal) the mention of zero is still required.
So, don't lose interest yet. Its just a start. It may be a boring and a poor start. Nobody taught me this, but it just a simple common sense at work. Anyway we are not even 0.0001% complete yet.
1 - One - Standing singly it is called, mentioned, sounded - "one", 2 digit with "one" behind another number the sound /mention will vary Eg 10 called Ten (Also unique but will repeat itself although the counting eg 10 ten, 10,000 - Ten Thousand, 10,000,000 - "Ten" Million, so on and so forth but the unique one is the mention/sound of "Ten" that you can use over and over again ie. repeat for later use in thousand, million, Billion, trillion, zillion ..... till infinity !!
WILL BE CONTINUED SOON..... we are just 0.0002% completed. Don't rush. Take thing slowly and systematically. As the saying goes Never rush a philosopher !!! Want to share before I be gone !!
PART 1
1. INTRODUCTION
As promised about a year ago, I'll share the subject with you. !!! :)
Lets choose the platform from which you want to do your program from. For this free lesson and for the purpose of easy access to the tools, I would create the conversion on MS EXCEL. MS Excel is readily available in your laptop and you can experiment on what I do here immediately in your computer.
For Visual basic - either Visual Basic (this is a powerful programming language and some fighter jet cockpit software is written abd driven by Visual Basic) or visual basic for application, the approach to N2W is greatly different. So does PHP and other programming languages.
There should be no problem with other programming language coding because you will know where to start and what to do once you understand the subject that you want to do program on.
1. STUDY THE LANGUAGE STRUCTURE
You can't start your programming or coding work until you fully understand the language structure of the language that you want to do N2W." The same goes with other subject that you want your computer and programming tools to do. If you want to do CALENDAR, you have to know how exactly the values in the particular calendar works. It may be a muslim or chinese or any other calendar system. One of the worst nightmare ever was the Y2K bugs that exist in some computer program that can "hay-wire" the whole program. It means that you computer can no more understand the function that was build in the calendar system.
Before we start the complex task of doing the coding one have to understand the stucture of the language you are going to do your conversion with.
In this example we are going to convert number into word in English Language, Malay & Miriek Language. The reason why I want to use English, Malay and Miriek at the same time is for the purpose of highlighting the difference in structure of the three Languages and thereby will also teach you the detail of the subject before you start the more exciting part, ie coding.
I am not going to teach you excel here. I assume that you have the basic knowledge sufficient to understand and follow the instruction (If you intend to).
I have not seen any conversion in excel done or available on internet yet. There could be many out there but have not found any one available as downloads and of course I had mine somewhere on the internet available for free somewhere BTW I have forgotten the link as to where I posted it for that particular download some 15 years ago) and it was a N2WR (In Miriek language) but it was caption as "Learning how to count in bahasa Miriek Language"then.
I do not know how they do it but i know it is a very long and tedious and systematic approach to solving a problem. I have my way and for as long as it can achieve what i want it to do, then, I consider it DONE !!.
NOW THE ENGLISH LANGUAGE STRUCTURE INVOLVE IN THE COUNTING
0 - Zero, When standing alone without any number or digit other than itself, in front or behind it, it is called and pronounced as "zero" (Lets hear how it sounds) If there is any other digit after it, it will never retain or sounded anything to do with ":zero"anymore. Eg. 10 => sound "ten". Threre is no mention of "zero"even if you have ten, twenty or 30 pieces of zeros in front. It is going to be spoken out with no mention of "zero"" again.
Simply, zero is only mentioned once and it is cm"unique" BUT if a decimal (Dot) is introduced behind the number zero with another digit greater than zero (>0) ie any number 1 to 9, then you still have to call it as Zero. Eg. 0.01 - read as Zero Point Zero One. In this case (decimal) the mention of zero is still required.
So, don't lose interest yet. Its just a start. It may be a boring and a poor start. Nobody taught me this, but it just a simple common sense at work. Anyway we are not even 0.0001% complete yet.
1 - One - Standing singly it is called, mentioned, sounded - "one", 2 digit with "one" behind another number the sound /mention will vary Eg 10 called Ten (Also unique but will repeat itself although the counting eg 10 ten, 10,000 - Ten Thousand, 10,000,000 - "Ten" Million, so on and so forth but the unique one is the mention/sound of "Ten" that you can use over and over again ie. repeat for later use in thousand, million, Billion, trillion, zillion ..... till infinity !!
WILL BE CONTINUED SOON..... we are just 0.0002% completed. Don't rush. Take thing slowly and systematically. As the saying goes Never rush a philosopher !!! Want to share before I be gone !!
No comments:
Post a Comment