Decision Channeling Calculator

 

Created by David@TechForText.com © 2010

TechForText Network™

To contact the author use the above email address, or

left click on these words for a website communication form.

The Decision Channeling Calculator was created as an experimental device. This Calculator demonstrates that software in the JavaScript and spreadsheet formats can be created with decision making capabilities, coupled with the functional capacity to channel numbers through predetermined pathways, and to perform over 100 calculations simultaneously.  The online JavaScript version of the Calculator is embedded in this webpage, and it is just below this paragraph.  If you want this Calculator in the spreadsheet format (Excel or OpenOffice) or if you need detailed information, scroll all the way down, beneath the online Calculator.  Alternatively, you can left click on one of the gray buttons, on the top of this page, which will take you to the Table of Contents of this Website.     Alternative Email is www@TechForText.com

 

The Online JavaScript Decision Channeling Calculator

© David@TechForText.com

                                
  Delete the number in the pink box below, and then enter your own number. After this, left click with the mouse on the calculated results.   Scroll down to see two boxes, one green and the other yellow. After this enter a number in the pink input box on the left. When this is completed, you will find that even numbers are channeled into the green box, and non-even numbers are channeled into the yellow box. This is a simple decision-making process that is automatically carried out by this software. y
     
                       
                  Non-even numbers are channeled into this yellow box, and THEN DOWNWARD THROUGH THE YELLOW PATH.      
    The instructions for the computer:        
           
    The English translation of the above is:        
    If the number is NOT even, put it in the yellow box. ? ?        
    The instructions for the computer:   Even numbers are channeled into this green box, and THEN DOWNWARD THROUGH THE GREEN PATH.        
             
                           
    The English translation of the above is:          
    If the number is even, put it in the green box.?          
     

The squares on the left and right are storage boxes for text. The software transfers the text to the dark blue box below, from the green box for even, and from the yellow for non-even numbers. If you want to, you can change the statements in these boxes, by left clicking inside the boxes, and pressing the delete key, and then you can add your own statements for the computer.

      The green path leads to a set of green boxes, and the yellow path leads to a set of yellow boxes. When an even number is entered over 100 calculations take place in the green boxes. When a non-even number is entered over 100 calculations takes place in the yellow boxes. Scroll down to see the boxes and calculated results.      
    Cell F22 Cell M22        
           
    The instructions for the computer to do the above:          
             
             
                       
                                       
                                       
 
     
    Square Root of Number                      
      0         Square Root of Number  
            Square Root of Number    
                Square Root of Number  
            Square Root of Number    
                Square Root of Number  
            Square Root of Number    
                Square Root of Number  
            Square Root of Number    
                Square Root of Number  
            Square Root of Number    
                Square Root of Number  
            Square Root of Number    
                Square Root of Number  
            Square Root of Number    
                Square Root of Number  
            Square Root of Number    
                Square Root of Number  
            Square Root of Number    
                Square Root of Number  
            Square Root of Number    
                Square Root of Number  
            Square Root of Number    
                Square Root of Number  
            Square Root of Number    
                Square Root of Number  
            Square Root of Number    
                Square Root of Number  
            Square Root of Number    
                Square Root of Number  
            Square Root of Number    
                Square Root of Number  
            Square Root of Number    
                Square Root of Number  
            Square Root of Number    
                Square Root of Number  
            Square Root of Number    
                Square Root of Number  
            Square Root of Number    
                Square Root of Number  
            Square Root of Number    
                Square Root of Number  
            Square Root of Number    
                Square Root of Number  
            Square Root of Number    
                Square Root of Number  
            Square Root of Number    
                Square Root of Number  
            Square Root of Number    
                Square Root of Number  
            Square Root of Number    
                Square Root of Number  
            Square Root of Number    
                Square Root of Number  
            Square Root of Number    
                Square Root of Number  
            Square Root of Number    
                Square Root of Number  
            Square Root of Number    
                Square Root of Number  
            Square Root of Number    
                Square Root of Number  
            Square Root of Number    
                Square Root of Number  
            Square Root of Number    
                Square Root of Number  
            Square Root of Number    
                Square Root of Number  
            Square Root of Number    
                Square Root of Number  
            Square Root of Number    
                Square Root of Number  
            Square Root of Number    
                Square Root of Number  
            Square Root of Number    
                Square Root of Number  
            Square Root of Number    
                Square Root of Number  
            Square Root of Number    
                Square Root of Number  
            Square Root of Number    
                Square Root of Number  
            Square Root of Number    
                Square Root of Number  
            Square Root of Number    
                Square Root of Number  
            Square Root of Number    
                Square Root of Number  
            Square Root of Number    
                Square Root of Number  
            Square Root of Number    
                Square Root of Number  
            Square Root of Number    
                Square Root of Number  
            Square Root of Number    
                Square Root of Number  
            Square Root of Number    
                Square Root of Number  
            Square Root of Number    
                Square Root of Number  
            Square Root of Number    
                Square Root of Number  
            Square Root of Number    
                Square Root of Number  
                       
  Decision Channeling Calculator by David@TechForText.com © 2010                      

                                 

 

If you want a printer friendly version of the online JavaScript Decision Channeling Calculator left click on these words.

 

 

TechForText Network™

 

 

 

 

 

 

 

Hyperlink Table of Contents of this Website

Left click, on the upper portion of the title or subtitle you are interested in, and the material you want will appear on your screen.  Alternatively, you can scroll down or up, and browse the titles, subtitles, and the 6400 words on this website.

 

Decision Channeling Calculator Top of this Webpage

© David@TechForText.com

 

The Online JavaScript Decision Channeling Calculator 2

© David@TechForText.com. 2

Download Links for the Decision. 16

Channeling Calculator 16

© David@TechForText.com. 16

The Excel and OpenOffice Formats  16

© David@TechForText.com. 16

Basic Description of the. 18

Decision Channeling Calculator 18

© David@TechForText.com. 18

Introductory Note. 18

© David@TechForText.com. 18

What Does the Decision Channeling Calculator Do?. 19

And What Type of Computations Does it Perform?. 19

© David@TechForText.com. 19

Theory and Programming Concepts. 21

© David@TechForText.com. 21

Introductory Note. 21

© David@TechForText.com. 21

Decision-Making Capability of the Calculator 22

© David@TechForText.com. 22

Creating a Theorem that Can be. 22

Converted to Computer Instructions, 22

To Identify Even and Non-Even Numbers. 22

© David@TechForText.com. 22

Creating a Set of Computer Instructions, 25

With the Theorem, and Decision-Making Concepts. 25

© David@TechForText.com. 25

The Computer Instructions Are Presented Below.. 27

© David@TechForText.com. 27

A Step-By-Step Translation of the Computer 29

Instructions, Into Human Language  29

© David@TechForText.com. 29

Are Alternative Sets of Computer Instructions Possible?. 35

for the Decision Channeling Process Discussed Above?. 35

© David@TechForText.com. 35

The Computer Instructions at the. 36

End of the Green and Yellow Pathways  36

© David@TechForText.com. 36

Computer Resources and the Calculations. 36

In the Green and Yellow Boxes of the  36

Decision Channeling Calculator 36

© David@TechForText.com. 36

The Computer Code for the Calculations. 39

In the Yellow and Green Boxes of the  39

Decision Channeling Calculator 39

© David@TechForText.com. 39

The Calculator’s Boxes for Square Roots. 42

© David@TechForText.com. 42

The JavaScript Version of the. 47

Decision Channeling Calculator 47

© David@TechForText.com. 47

The Computer Code from the JavaScript Version. 47

Of the Decision Channeling Calculator  47

© David@TechForText.com. 47

Potential Utility of the. 47

Concepts Demonstrated by the. 47

Decision Channeling Calculator 47

© David@TechForText.com. 47

The Primary Purpose of The. 47

Decision Channeling Calculator 47

© David@TechForText.com. 47

The Potential Utility of Decision-Making, 48

And Channeling Numbers Through Pathways. 48

© David@TechForText.com. 48

Multiple Calculations Performed Simultaneously. 49

© David@TechForText.com. 49

Decision-Making Software. 51

© David@TechForText.com. 51

Other Software Besides the. 51

Decision Channeling Calculator 51

That Makes Decisions. 51

© David@TechForText.com. 51

Speculations on Decision-Making Software. 54

© David@TechForText.com. 54

In General, Can Decision-Making Software. 54

Of Any Kind, Replace, or Partly Replace, 54

Human Decision-Making; a Few Speculations. 54

© David@TechForText.com. 54

Can Decision-Making Software With Appropriate. 55

Hardware And Sensing Equipment Override. 55

Reckless Decision-Making Of Humans?. 55

© David@TechForText.com. 55

Decision Channeling Calculator, 55

And Very Large or Very Small Numbers  56

And Negetve Numbers. 56

© David@TechForText.com. 56

Very Large and Very Small numbers  56

(in Terms of Absolute Value) and the  56

Decision Channeling Calculator 56

© David@TechForText.com. 56

Negative Numbers, and the. 58

Decision Channeling Calculator 58

© David@TechForText.com. 58

Scientific Notation and the. 59

Decision Channeling Calculator 59

© David@TechForText.com. 59

When the Calculator Displays. 59

Very Large or Very Small Numbers  59

© David@TechForText.com. 59

Examples of the Display of Very Large Numbers. 60

In Scientific Notation, Using the Letter E. 60

© David@TechForText.com. 60

Examples of the Display of Very Small Numbers. 60

In Scientific Notation, Using the Letter E. 60

© David@TechForText.com. 60

Services Offered From the Author 61

Of This Website and the Creator of the  61

Decision Channeling Calculator 61

David@TechForText.com.. 61

© David@TechForText.com. 61

Calculation Devices, and. 61

Website Communication Forms, 61

Made To Order 61

© David@TechForText.com. 61

I Offer Technical and General 62

Writing Services. 62

© David@TechForText.com. 62

Contact Information for the Services I Offer 63

David@TechForText.com. 63

 

 

Download Links for the Decision

Channeling Calculator

© David@TechForText.com

 

The Excel and OpenOffice Formats

© David@TechForText.com

 

If you want an Excel version of the Decision Channeling Calculator left click on these words.

 

If you want the Decision Channeling Calculator in the newer Excel 2007 format left click on these words.  This requires Windows and Microsoft Excel 2007 or later, or Office 2000, Office XP, Office 2003 with the free Microsoft Compatibility Pack.

 

To obtain the free Microsoft Compatibility Pack go to Microsoft’s website, by Left clicking on these words.

 

 

If you want the Decision Channeling Calculator in the OpenOffice.org format, left click on these words.  This requires the free OpenOffice.org software package, and Microsoft Windows.

 

The website that provides the free OpenOffice.org software package is located at www.OpenOffice.orgYou can access this site by left clicking on these words.

 

 

If you want the Decision Channeling Calculator in all of the above formats, left click on these words.  This is downloaded in a single Compressed Zip Folder, which contains a conventional folder inside of it, with all of the spreadsheet formats mentioned above..

 

 

Basic Description of the

Decision Channeling Calculator

© David@TechForText.com

 

Introductory Note

© David@TechForText.com

You should closely examine the structure and function of the Decision Channeling Calculator, and its green and yellow pathways, before reading the following.  This will make the material presented below easier to understand.  

  

 

What Does the Decision Channeling Calculator Do?

And What Type of Computations Does it Perform?

© David@TechForText.com

When the user enters a number into the input box of the Decision Channeling Calculator, the Calculator performs a series of computations to determine if the number is even or non-even.  (Non-even is defined here as odd numbers, and numbers with a decimal, that is greater than or less than zero, such as 3, 85, 2.4, 4.21)  If the number is non-even the Calculator will channel it through a yellow path, but if the number is even it will channel it through a green path.   This is a simple form of decision-making, which consists of deciding which path to channel a number through. 

 

At the end of the yellow path there is a set of yellow boxes where a number of computations takes place simultaneously, a fraction of the second, after the user entered a non-even number.  Similarly, at the end of the green path there is a set of green boxes, where a series of computations takes place, when the user enters an even number.  These computations involve over 100 calculations and results, for the JavaScript version, of the Decision Channeling Calculator.  The spreadsheet versions of the Calculator, in the Excel, and OpenOffice formats, perform over 200 calculations, and display a corresponding number of results.  The calculated results for non-even numbers are displayed in the yellow boxes and the results for the even numbers are displayed in the green boxes.

 

The calculations that take place in the green and yellow boxes consist of a sequence based on the number the user entered in the input box.  If the user entered a number, designated by X, the sequence would be X, 2X, 3X, 4X, 5X, etc.  For example, if you enter an even number, such as 2, the Calculator will put a number in each green box, with the following sequence of, 2, 4, 6, 8, 10, 12, 14, etc.   In addition, the Calculator will calculate the square root of each of these numbers, and place them in an adjacent green box.  When a non-even number is entered, all of the above takes place in the yellow boxes. 

 

Note: When a number is entered into the input box of the Calculator, either the green or the yellow set of boxes will not have any calculated results to display.  The set of boxes without any calculated results, will have a 0 (zero) in each box, for the online JavaScript and OpenOffice versions.  However, the Excel version displays #VALUE! in the set of boxes that do not have any calculated results.

 

 

 

Theory and Programming Concepts

© David@TechForText.com

 

Introductory Note

© David@TechForText.com

The following material is somewhat technical.  Readers who do not have an adequate background in spreadsheet formulas and mathematics might find this section difficult.  Even if you have an adequate background, portions of this material should be read at a slow pace, step-by-step.

 

 

Decision-Making Capability of the Calculator

© David@TechForText.com

Basically, the decision-making capability of the Calculator is based on an evaluation of the mathematical properties of two sets of numbers.  Some examples of number sets are represented by the following mathematical expressions: N=X, N>X, N<X, N+X=Y, N/X=Y, N-X=Y, etc.  The two number sets used for the Decision Channeling Calculator are even and non-even numbers.   Non-even numbers are defined here as either odd numbers, or numbers that are not integers (numbers with a decimal that is greater than or less than zero).

 

 

Creating a Theorem that Can be

Converted to Computer Instructions,

To Identify Even and Non-Even Numbers

© David@TechForText.com

Almost everyone can easily identify an even and non-even number; it's common sense.  However, a computer does NOT have common sense.  It is necessary to delineate everything in a step-by-step way for a computer, which often must be done in the form of mathematics.  To do this, I devised the following theorem, and translated it into computer instructions for the Decision Channeling Calculator. 

 

N represents a real number, and N/2=n, and if n is rounded down to an integer, the result is represented by I.

 

If 2I=N or 2I-N=0 then N is an even number, if not, N is a non-even number.

 

This theorem can be restated with less mathematical symbols as follows:

 

I will use a number for this example called N.   The number N is divided by two, and then it is rounded down to an integer, which we will call I.  If the number I is multiplied by two, and if it is equal to the number N, then N is an even number, if not N is a non-even number

 

I will present some examples of the above theorem, with numbers, in a series of steps. 

 

If N=43.

 

N/2=n In words this means:  43 divided by 2 equals 21.5, which means n=21.5

 

When n=21.5 is rounded down to an integer, it equals 21, which means 21=I 

 

Based on the theorem, 2I=N or 2I-N=0 indicates an even number.  If we substitute our numbers (21, and 43) into the above formulas, we get 21 multiplied by 2, does not equal 43.  Or 2(21)-43=-1   This proves, based on the theorem presented above, that 43 is a non-even number.

 

 

Another example is presented below:

 

If N=44

 

(N/2=n) In words this means: 44 divided by 2 equals 22, which means n=22

 

When n=22 is rounded down to an integer, nothing is changed; it is still equal to 22, which means 22=I

 

Based on the theorem, 2I=N or 2I-N=0 indicates an even number.  If we substitute our numbers (22, and 44) into the above formulas, we get 22 multiplied by 2, equals 44. Or 2(22)-44=0  This proves, based on the theorem presented above, that 44 is an even number.

 

 

Creating a Set of Computer Instructions,

With the Theorem, and Decision-Making Concepts

© David@TechForText.com

 

. The theorem, discussed above, and the concepts of even and non-even, and the channeling of numbers through specific pathways, had to be presented in mathematical terms, using symbols that the computer would understand.  To do this, two sets of computer instructions were created for the Decision Channeling Calculator.

 

One set of computer instructions blocks even numbers from passing through the yellow path, but it allows non-even numbers to pass through.  The other set of instructions blocks non-even numbers from passing through the green path, but it allows even numbers to pass through. 

 

 The two sets of computer instructions I am focusing on in this section are for the spreadsheet format.  However, the general concepts involved with these instructions apply to the JavaScript version of the Calculator, as well as to computer programming in general.  Computer instructions of this type are usually called formulas, but they can be designed to perform computations that are nonmathematical.  These instructions are very concise, but each set contains enough information to fill a paragraph, if they were written for a human.  (I will discuss the JavaScript version in a later section.) 

 

 

The Computer Instructions Are Presented Below

© David@TechForText.com

 

=IF((ROUNDDOWN((E8/2), 0)*2)-E8=0, "", E8)

Computer instructions, in the form of a spreadsheet formula

This expression blocks even numbers, and allows non-even numbers to pass through the yellow path of the Decision Channeling Calculator.

 

=IF((ROUNDDOWN((E8/2), 0)*2)-E8=0, E8, "" )

Computer instructions, in the form of a spreadsheet formula

This expression blocks non-even numbers, and allows even numbers to pass through the green path of the Decision Channeling Calculator.

 

 

The meaning of the symbols in the green and yellow expressions, above, are explained below.  This will be followed by a discussion of how these formulas function, and how they instruct the computer.

 

The E8 is a cell reference for the pink input box on top of the calculator.  This acts as if it was a transmission wire that sends data from the input box to any cell that has =E8 in it.

 

The / with the 2 means divide by 2. 

 

 

The * means multiply, and the *2 means multiply by 2.

 

The word ROUNDDOWN and the 0, means to remove all decimals.   That is numbers are rounded down to zero decimal places, which is the same as rounding down to an integer.  

 

The two quotation marks " " in each expression means do not display anything.   More precisely, this means display the symbols between the quotation marks, but in this case, there is nothing between the quotation marks, so nothing is displayed.

 

 

The IF(   ) means if something is true, (or if a condition exists) perform a specified set of computations, but if it is false (or if a condition does NOT exist) perform an alternative set of computations. The computations can involve displaying a specific set of words or numbers if true, and if false displaying an alternative set of symbols.

 

 

A Step-By-Step Translation of the Computer

Instructions, Into Human Language

© David@TechForText.com

The Calculator's two sets of decision-making computer instructions are explained in the following paragraphs.  Both sets of instructions are highlighted, one in yellow, and the other in green, which corresponds to the pathway they control on the Decision Channeling Calculator.

 

=IF((ROUNDDOWN((E8/2), 0)*2)-E8=0,  "", E8)  To make this explanation clear, I will present it in terms of the actual steps it carries out in the Decision Channeling Calculator.  This will be presented along with an example, in red type, using the number 3.  That is, assume the user entered 3 in the pink input box of the Calculator.  

 

Step one) Divide the number that the user entered into the input box by 2  This is done by (E8/2)Assuming the user entered 3, the result is: 3/2=1.5 

 

Step two) Round the result from step one down to zero decimal places (Round down to an integer)  This is done by (ROUNDDOWN(    , 0).   The result from step one is 1.5, and when it is rounded down to zero decimal places it is equal to 1.

 

Step three) Multiply the result from step two by 2   This is done by *2  Thus, from step two we obtained 1, and when 1 is multiplied by two, the result is 2

 

 

Step four) Subtract the number the user entered in the input box, from the result obtained in step three  This is done by -E8   The result from step three is 2, and the user entered 3, which is 2-3=-1 

 

Step five) If the result from step four is 0 (zero), the number the user entered is even, and it will be blocked from the yellow path.  (The blocking is done by  “” )  However, if the result from step four is NOT 0 (zero), the number is non-even, and it will be allowed to pass through the yellow path.  This passage, is done by the E8 at the end of the expression.  With our example, the result from step four is -1, so the number entered by the user is non-even, and thus it will pass through the yellow path.

 

 

 

=IF((ROUNDDOWN((E8/2), 0)*2)-E8=0, " ", E8)

Interesting note: The location of the quotation marks, in this expression mean do not display even numbers, which results in blocking even numbers from passing through the yellow path.   The location of E8 at the end of the expression allows non-even numbers to pass through the yellow path.  The green expression does just the opposite of the yellow expression.  The green expression, blocks non-even numbers and it allows even numbers to pass through the green path.  Thus, in the green expression the location of the quotation marks and the E8 are reversed.  That is the E8 was placed before the quotation marks, and the quotation marks was placed at the end of the green expression.  See the following, and compare it with the yellow expression above:

 

=IF((ROUNDDOWN((E8/2), 0)*2)-E8=0, E8, “” )

This green expression involves the same principle (as explained above) for the yellow pathway.  The actual steps it carries out in the Calculator are explained below, along with an example presented in red type, using the number 3.  (Assume the user entered 3) Note all of the following calculations are the same as for the yellow path, except for the last step.

 

Step one) Divide the number the user entered by 2   This is done by E8/2   Assuming the user entered 3, the result is: 3/2=1.5 

 

 

Step two) Round down the result from step one to zero decimal places. (Round down to an integer)  This is done by (ROUNDDOWN(       ,0)   The Result from step one is 1.5, and when it is rounded down to zero decimal places it is equal to 1.

 

 

Step three) Then, multiply the result from step two by 2.   This is done by *2   The result from step two is 1, thus 1 x 2=2

 

 

Step four) Subtract the number the user entered from the result from step three.  This is done by -E8   With our example, the  result from step three is 2.  The user entered 3, which is 2-3=-1

 

Step five) If the result from step four is 0 (zero), then the user entered an even number.  Then it will be transmitted through the green path.   If the result from step four does not equal 0 (zero), the original number is non-even, and it will be blocked from the green path.  The result from step four is -1, so the number entered by the user is non-even, and thus it will be blocked from the green path.

 

 

Are Alternative Sets of Computer Instructions Possible?

for the Decision Channeling Process Discussed Above?

© David@TechForText.com

It is quite likely, that many other sets of computer instructions can be created, to do the decision-making and channeling process described in the previous paragraphs.  In general, there are usually many alternative ways of creating computer instructions to achieve an objective.  This applies to computer instructions in just about any format, including spreadsheet formulas.

 

The computer instructions discussed above, in the form of two spreadsheet formulas, are the instructions I derived on the first attempt.  I did not try to create alternatives, or more efficient set of instructions, because the first set I created worked perfectly. 

 

However, when computer instructions are very lengthy, or consume a large amount of computer resources, it is important to devise the most efficient set possible.  Nevertheless this was not the case with the computer instructions for the decision-making and channeling process carried out by the Calculator.  However, calculations at the end of the pathways, do consume a significant amount of computer resources, especially for the JavaScript version.  For details read the next subsection.

  

 

The Computer Instructions at the

End of the Green and Yellow Pathways

© David@TechForText.com

 

Computer Resources and the Calculations

In the Green and Yellow Boxes of the

Decision Channeling Calculator

© David@TechForText.com

The calculations involved with the decision-making and channeling process involve less than a dozen calculations, but the calculations at the end of the pathways involve over 100 to 200, relatively simple calculations, involving, adding, and taking square roots. 

 

The 100 plus calculations at the end of the yellow and green pathways, (in the green and yellow boxes) consume far more computer resources then the two sets of decision-making formulas, discussed above.  However, this was not problematic with the spreadsheet version, which performs over 200 calculations, but it was a difficulty with the JavaScript version.  To solve this problem the calculations the JavaScript version performs, at the end of the yellow and green pathways, was reduced to about 100 calculations. 

 

The programming concepts involved with the calculations, at the end of the green and yellow paths of the Calculator, are much simpler than the two formulas created for the decision channeling process.  However, they require OVER 100 formulas, and many more computations, then the decision channeling process.

 

The concept of difficulty, as human beings experience it is NOT the same for the computer.  That is problems that are very difficult for humans, sometimes require very little computer resources.  However, a task that is not very difficult for a human might consume a large amount of computer resources.  An extreme example involves turning large high quality photographs upside down.  A five-year-old child can quickly and easily perform this task.  However, it is relatively difficult for a computer, in terms of computer resources, and the huge amount of required computations.  Most calculus problems would be easier to solve for the computer then the above.

I

Note the words: easier, difficult, difficulty when applied to the computer, in this text, refers to all of the following, (when the computer is solving a problem, or carrying out a task): the number of computations required; the number of processor cycles required; the amount of random access memory required; the use of any other computer resources, the tendency for the computer to crash.  When the above factors are relatively large, the task is difficult, and when they are small, the task is easy, based on the way I am using the terminology.

 

 

 

The Computer Code for the Calculations

In the Yellow and Green Boxes of the

Decision Channeling Calculator

© David@TechForText.com

The following is based on the spreadsheet version of the Decision Channeling Calculator, but the basic concept also applies to the JavaScript version.  This material focuses on the calculations that take place in the green boxes, for even numbers.  Keep in mind that identical calculations take place in the yellow boxes, for non-even numbers.  This material will be easier to understand, if you first examine the green and blue graphic which is located, several paragraphs below, at the end of this section.

 

In the green boxes at the end of the green path, on the left, a chain like sequence of adding the number the user entered takes place.  This involves accessing the number the user entered, and placing it in the first green box.  For example, if the user entered 2 in the pink input box of the calculator the following sequence will result.  2 will be placed in the first green box, by way of the green path.  Then the calculation for the second box, involves adding the number the user entered 2 with the result in the first green box, which is 2+2=4.  The third green box will access the number in the second box, which is 4, and add 2 resulting in 6.  The fourth box will be 6+2=8.  The fifth box is 8+2=10. The sixth box is 10+2=12, etc. 

 

The computer code for the above, in the form of spreadsheet formulas, is as follows: 

 

In the first green box (which is cell N32) the formula is =$O$30. (This formula accesses cell O30, which contains the number the user entered, as a result of the channeling process through the green pathway.

 

Second green box is cell N34, and it contains =N32+$O$30.  ($O$30 access the number the user entered, and the it is added to the quantity in the first green box, which is cell N32)

 

Third box is cell N36, and it contains =N34+$O$30 ($O$30 access the number entered by user, and it is added to the quantity in the second box, which is cell N34)

 

Fourth box is cell N38 and it contains =N36+$O$30, ($O$30 access the number entered by user, and it is added to the quantity in the third box, which is cell N36)

 

Fifth box is cell N40 and it contains =N38+$O$30 ($O$30 access the number entered by user, and it is added to the quantity in the fourth green box, which is cell N38)

 

 

The above sequence continues for over 200 boxes, for the spreadsheet version, and about 100 boxes for the JavaScript version.

 

(Note, the $ does not mean dollar in these formulas.  Basically, it means unconditionally link to a specific cell, which will maintain the cell linkage even if the configuration of the spreadsheet is changed.  For example, $O$30 means an absolute linkage to cell O30.)

 

 

The Calculator’s Boxes for Square Roots

© David@TechForText.com

While reading this, examine the lower portion of the Decision Channeling Calculator, and you will see two sets of yellow boxes, as well as two sets of green boxes.  You will also see yellow and green boxes that have the words: Square Root of Number.  These boxes contain formulas for calculating the square root of the numbers in the adjacent yellow and green boxes.  A portion of the computer code to do this, for the spreadsheet version, is presented below, in terms of formulas.  The computer code in the JavaScript version performs the same function.

 

Formula in first box =N32^0.5,  (This means access the number in cell N32 and take the square root of it.)

 

Formula in second box =N34^0.5, (Access the number in cell N34 and take the square root of it.)

 

Formula in third box =N36^0.5 (Access the number in cell N36 and take the square root of it.)

 

Formula in fourth box =N38^0.5 (Access the number in cell N38 and take the square root of it.)

 

Formula in fifth box N40^0.5, etc. (Access the number in cell N40 and take the square root of it.)

 

There are over 100 of the above formulas in the spreadsheet version, and a little over 50 in the JavaScript version.

 

I created the above formulas based on the following notation and concepts.  The ^ in these formulas means take a to number to specific power.  For example, 2^2 means two to the second power, or 2 squared, or 2 multiply by 2, which equals 4.  Another example is 4^3, which is four to the third power, or 4 multiplied by 4, multiplied by 4 equals 64.  Another example is 4^1 =4.  Thus, to take the square root of a number, you simply take the number to the one-half power. In my formulas I used 0.5 which equal to one-half.  For example, 4^0.5 means the number four to the one half power, which is the same as saying the square root of four, which equals 2.  

 

 

The graphic below is a copy of a few of the green boxes, from the bottom of the Decision Channeling Calculator.   The formulas on the left, create a sequence based on the number the user entered.  If the user entered X the sequence is X, 2X, 3X. 4X, 5X, etc.  The formulas in the boxes on the right take the square root of each number in the above sequence.  For example, user enters X. then the calculations on the left are (X^0.5), (2X^0.5), (3X^0.5), (4X^0.5), (5X^0.5), etc.

 

 

 

 

The JavaScript Version of the

Decision Channeling Calculator

© David@TechForText.com

 

The Computer Code from the JavaScript Version

Of the Decision Channeling Calculator

© David@TechForText.com

The computer code from the JavaScript version is very lengthy (about 84 pages.)  The explanations of the code are also relatively complex. Because of this, the JavaScript code is explained and presented on two separate web pages.  If you want to read about the JavaScript version of the Calculator, and see the code, left click on these words.  This will take you to another webpage.

 

 

Potential Utility of the

Concepts Demonstrated by the

Decision Channeling Calculator

© David@TechForText.com

 

The Primary Purpose of The

Decision Channeling Calculator

© David@TechForText.com

The Decision Channeling Calculator has no practical purpose; it is a demonstrational and experimental device.  However, the Calculator demonstrates useful programming concepts that can be incorporated into the design of dedicated mathematical software, created in the spreadsheet or JavaScript formats.  (These programming concepts can most likely be created in other formats besides the above, but I have only applied these concepts with the spreadsheet and JavaScript formats.)  The concepts are decision-making, channeling numbers based on specific mathematical criteria, and multiple calculations performed simultaneously.

 

 

The Potential Utility of Decision-Making,

And Channeling Numbers Through Pathways

© David@TechForText.com

The decision-making, and related channeling of numbers through pathways, is relatively simple decision-making.   However, the complexity and utility of this type of decision-making could be increased by designing software with more IF programming functions, and more pathways.  In theory, this can be coupled with other programming concepts, including advanced mathematics, and artificial intelligence.

 

In the simplest sense, the decision-making carried out by the Calculator, essentially involves sorting out numbers according to specific criteria, and channeling them to designated locations.  This might have some practical application for calculations that are generally done with conventional spreadsheets, or calculation devices created from spreadsheets.  Of course, the concept and the related formulas would have to be greatly modified, to fulfill specific needs.  

 

 

Multiple Calculations Performed Simultaneously

© David@TechForText.com

Probably the most useful concept demonstrated by the Decision Channeling Calculator is multiple calculations performed simultaneously.  I have used this concept in many of the calculation devices I have created.  When applied to the design of dedicated mathematical software, (including spreadsheets) it can save hours of work for the ultimate user.  That is several, dozens, or even hundreds of calculations can be performed simultaneously, even if they are very complex, with out any special skill, with little time and effort, and with a minimum of data entry.  Of course, this can only be achieved with sets of calculations that use the same data.  However, it does not matter, if different calculations, and related formulas, use the data in very different ways.  Two examples are presented in the following two paragraphs, with the needed data in red type.

 

A simple example is, with the length of the radius of a sphere you can calculate a sphere’s surface area, its volume, the surface to volume ratio, the volume to surface ratio, its perimeter, its diameter, the dimensions and volume of a box big enough to enclose the sphere.  That is with properly designed software, you can obtain all of the above, just by entering the length of the radius.

 

An example related to business, involves the monthly expenditures and monthly Revenue obtained from sales.  With this data all of the following can be calculated, profits and losses, acceleration or deceleration in the rate of profits, the rate of return based on the monthly profits and expenditures, the average rate of profits or losses, the optimistic, realistic (most likely), and pessimistic forecast of profits and losses, for three months, six months, nine months, a year, two years, three years.

 

Decision-Making Software

© David@TechForText.com

 

Other Software Besides the

Decision Channeling Calculator

That Makes Decisions

© David@TechForText.com

 

Are there other programs, besides the Decision Channeling Calculator, that make decisions?  Of course, there are many types of software available on the market that make decisions, of one type or another, based on the way I am using the terminology.  Decision-making is deciding between two or more choices or possibilities, and responding in some way.  For software, the response is always based on some type of computation.

 

One of the simplest examples of software making a decision is when to display an error message, and which error message to display.  At a far more complex level, speech to text software, (such as Dragon NaturallySpeaking) enters text into a computer, based on spoken words from the user.  In this process, this software often has to make decisions, when there is some uncertainty of one or more words that the user verbalized.  This might involve, the software selecting a word from several possibilities, which can be based on the probability of occurrence, in terms of other words that were verbalized along with it.  However, the decision-making carried out by speech to text software is sometimes incorrect, and the user must make the final correction.  However, most speech to text software programs, also have the capability of learning from experience, to make better, or more accurate, decisions.  (Incidentally, this is a form of artificial intelligence.) 

 

Even the IF( ) function from spreadsheet software (Excel and OpenOffice) involves a simple form of decision-making.  This usually involves a decision on what to display, in response to a mathematical result.  For example, this can be words that relate to statistics, such as above average, average, below average.

 

Nevertheless, the Decision Channeling Calculator, makes the decision, and takes action based on the decision.  This action involves channeling numbers through the green or yellow pathways, and carrying out over 100 calculations, in the green or yellow boxes.  This is to some degree different than all of the above. 

 

However, the point here is it is not uncommon for software to make decisions, with varying degrees of complexity.

 

Speculations on Decision-Making Software

© David@TechForText.com

 

In General, Can Decision-Making Software

Of Any Kind, Replace, or Partly Replace,

Human Decision-Making; a Few Speculations

© David@TechForText.com

For most purposes, humans are better decision-makers then any available computer technology, because most decision-making involves a large number of human values and goals.  Computers can perhaps help humans make better decisions, such as by retrieving relevant information, and carrying out logical and mathematical processes.

 

However, when there is a massive amount of data that must be processed to make a decision in a fraction of a second, computers are superior to humans.  For example to prevent collisions and crashes of airplanes during emergency situations, computer technology can provide an advantage over human judgment and reactions.  Computer technology, with appropriate sensing equipment, could probably also be employed to prevent collisions in automobiles. 

 

 

Can Decision-Making Software With Appropriate

Hardware And Sensing Equipment Override

Reckless Decision-Making Of Humans?

© David@TechForText.com

Yes; computer technology with sensing and control equipment, could be used to override reckless decisions, judgments, and behaviors, in some cases, such as with automobile drivers and airplane pilots by preventing speeding, excessively sharp turns, and any dangerous maneuver.  For example, the 9/11 World Trade Center disaster, at least in theory, could have been prevented, with computer technology designed to sense and override, pilot maneuvers that can result in dangerously low altitudes and collisions with buildings.

 

 

Decision Channeling Calculator,

And Very Large or Very Small Numbers

And Negetve Numbers

© David@TechForText.com

 

 

Very Large and Very Small numbers

(in Terms of Absolute Value) and the

Decision Channeling Calculator

© David@TechForText.com

The Decision Channeling Calculator in all three formats, JavaScript, Excel, and OpenOffice, can handle large numbers with up to15 digits, such as 100,000,000,000,001 and 100,000,000,000,002.  However, the calculations in the yellow and green boxes may be displayed in scientific notation.  Very small numbers may also be displayed in scientific notation.

 

When numbers are excessively large, (more than 15 digits) the Decision Channeling Calculator cannot distinguish between even and non-even numbers.  There is a mathematical reason for this, which is, the difference between even and non-even numbers diminish (in terms of a ratio or percentage) as numbers increase in magnitude.*  For example, the difference between 100 and 101 is 1/100 or 1%, but the difference between 100000 and 100001 is 1/100000 or 0.001%.  When we use even larger numbers such as 100,000,000,000,000 and 100,000,000,000,001 the difference becomes extremely small, 1/100,000,000,000,000 or 0.000000000001%. 

 

The Decision Channeling Calculator can still distinguish the very tiny difference mentioned above (0.000000000001%.), but when the difference becomes even smaller, the Calculator cannot distinguish between even and non-even numbers.  For example, if you put this even number 100,000,000,000,000,000, or this non-even number 100,000,000,000,000,001 into the Calculator's pink input box, it will treat them as if they were both even, and they will both be channeled through the green path. 

 

In addition, when numbers are very large they are likely to be rounded down to an even number, by the software. For example, 100,000,000,000,000,001 is non-even (odd), and it is round downed to an even number, in the Excel version, which is 100,000,000,000,000,000.  

 

*Note: In terms of numbers, as opposed to a ratio or percentage, the difference in magnitude between an even and non-even number is always 1 or less than 1 but greater than 0 (zero).  The difference in magnitude between an even and odd number is always 1.

 

 

Negative Numbers, and the

Decision Channeling Calculator

© David@TechForText.com

The Decision Channeling Calculator can handle negative numbers, and all of the material covered in this section, applies to both positive and negative numbers.  However, with negative numbers there are no square roots, in terms of real numbers.  (That is the square root of a negative number is imaginary.  For example, the square root of -4 is 2i.)  Thus, when negative numbers are entered into the calculator, the yellow and green boxes with the words Square Root of Number will have no calculated results. You will see an error message in these boxes, but the yellow and green boxes that calculate the number sequence, X, 2X, 3X, 4X, 5X, etc., will provide calculated results.

 

 

Scientific Notation and the

Decision Channeling Calculator

© David@TechForText.com

 

When the Calculator Displays

Very Large or Very Small Numbers

© David@TechForText.com

The Decision Channeling Calculator may display numbers in scientific notation, such as when calculated results are very large or very small.  This applies to all three versions, Excel, OpenOffice, and the JavaScript version.  The letter E is used to designate scientific notation.  The online JavaScript version uses a lowercase e, and the Excel and OpenOffice versions use an uppercase E.   This format is illustrated under the following three headings. 

 

 

Examples of the Display of Very Large Numbers

In Scientific Notation, Using the Letter E.

 © David@TechForText.com

1000000000000000000000 is displayed as 1E+21.  The 21, with a plus sign, (+) represents the number of decimal places after the first digit.  This can be clarified by counting the 21 red highlighted digits in the following: 1000000000000000000000

 

Another example is: 1456789666666890000000 is displayed as 1.45678966666689E+21.  The 21 represents the number of decimal places after the first digit.  This can be seen by counting the digits highlighted in red as follows: 1456789666666890000000

 

 

 

Examples of the Display of Very Small Numbers

In Scientific Notation, Using the Letter E

 © David@TechForText.com

0.000000000000000000001 is displayed as 1E-21. With this example, 21 with the minus sign represent the number of decimal places after the decimal point, as indicated by the 21 digits highlighted in red as follows: 0.000000000000000000001

 

Another example is: the number 0.0000000000000000000067987 is displayed as 6.7987E-21. Note the 21 with the minus sign (-) represent the number of decimal places after the decimal point. This becomes clear by counting the digits highlighted in red as follows: 0.0000000000000000000067987

 

 

 

Services Offered From the Author

Of This Website and the Creator of the

Decision Channeling Calculator

David@TechForText.com

© David@TechForText.com

 

Calculation Devices, and

Website Communication Forms,

Made To Order

© David@TechForText.com

I, David@TechForText.com, design and build user-friendly software based calculation devices for arithmetic, accounting, currency exchange rates, algebra, trigonometry, correlations, calculus, etc.  I also create attractive online calculation devices for websites, and website communication forms. This can include communication forms with built-in calculation devices.

 

I generally make calculation devices in the Microsoft Excel, OpenOffice.org, and JavaScript formats, and the web communication forms are in JavaScript.  However, I can work with other spreadsheet formats, besides the above.

 

For a website directory, with links to the online calculation devices I created, left click on these words, or go to: www.TechForText.com/Math

 

I Offer Technical and General

Writing Services

© David@TechForText.com

I write instructions for the devices I build.  I can also write instructions for software and computer devices created by others.  In addition, I write articles, material for websites, and advertising for products and services, etc.

 

For a detailed list of all the services I offer, see:

 

www.TechForText.com

 

For a list of all my websites see:

 

www.David100.com

 

My resume is online at:

 

www.David100.com/R

 

 

Contact Information for the Services I Offer

 David@TechForText.com

 

I offer my services, on a fee-for-service basis, or possibly based on temporary or permanent employment.  If you are interested in my services, and want additional contact information, or more information on the services I can provide, you can email me at: 

 

David@TechForText.com

 

Alternatively, you can left click on these words, for a website communication form.

 

I am located in the USA.  If you are a great distance from my locality or are in another country, this is not important.  I can provide these services worldwide, because the software and websites I make can be delivered through the Internet to any locality, providing there are no governmental restrictions.

 

 

.