__Databases and Lists with
Calculation Mechanisms__

__Created by David Alderoty
© 2011, David@TechForText.com
__

__To contact the author use the above email address
or__

__left click on these words for a website
communication form.__

__ __

This website provides free of charge, 14 databases and
9 lists with various types of calculation mechanisms, such as for statistics,
algebra, calculus, etc. The databases and 9 lists are located on 14 websites
that contain over 22,000 words of information and instructions. This webpage
provides links to the 14 websites, as well as direct links to most of the
databases and lists, with brief descriptions on each device. (If you want definitions and other information about
these devices left click on these words.) **I created all of the above,
including this website, in a four or five month period, from March to August,
2011.** To access the devices, or for additional information, scroll down
and browse through the headings and subheadings, or go to the table of contents of this website, by
left clicking on these words.

__Website Links and Download
Links for the Databases, and Lists__

NOTE: The 14 **DATABASES** and 9 **LISTS** are
available in one or more of the following: __JavaScript__, __Microsoft
Excel 2003__, __Excel 2007-2010__, and __OpenOffice Calc__. The __JavaScript
devices__, function online directly from the Internet, but the __Excel and
OpenOffice Calc devices__ must be downloaded first and use with a computer
that has Microsoft Windows. To open or download a device left click on a blue
link. The main websites have additional links and download options.

__WEBSITE 1)____
and The One‑Year Appointment Book Generator__

This device is comprised of a ** LIST** of formulas, and its website is located
at: www.TechForText.com/AppointmentBookGenerator

The 368 page ** Appointment Book
Generator** is available in Microsoft Excel 2003, Microsoft Excel,
2007-2010, and OpenOffice Calc. If
you want the One-Year Appointment Book Generator, in all the formats mentioned
above, in a single zip folder, left click on these words.
The files should be removed from the zipped folder before they are used.

The main website for the ** Appointment
Book Generator** has a hyperlinked table of contents, and over 4000 words
explaining some of the techniques I used to create this device. The
one-year appointment book required over 10,500 formulas to create. The
formulas are very simple, but this project is extremely complex, because of the
large number of highly complex links between the 10,500 formulas. If
you want to download a Microsoft Excel document that displays each formula and
its exact location in the Appointment Book Generator, left click on these
words. Note: this document looks almost identical to
the

__WEBSITE 2) ____The Averaging Calculator
and Averaging‑Database__

__The Averaging Calculator__**
calculates the average of** a ** LIST**
of numbers, with a without names, entered by the user. The

** **

__WEBSITE 3)____
Correlation‑Calculator__

This device performs calculations on two ** LISTs** of numbers, with or without names,
entered by the user, to determine the degree of correlation between the two
lists. (That is it calculates the correlation coefficient for two data sets.)
The website for this device is: www.TechForText.com/Correlation-Calculator This
website is very small, and it only contains the

__WEBSITE 4)____
Mathematics‑Problem‑Generators__

This website www.TechForText.com/Mathematics-Problem-Generators
__has information about six calculation devices I created that are designed
to generate mathematics exercises, to help students practice solving math
problems.__ However, the main focus of this
website is on one of these devices, which is the

You
can download five versions of the **Basic Algebraic Equation Generator**, in
one zipped folder, for Microsoft Excel 2003, Excel 2007-2010, OpenOffice Calc,
and JavaScript, by left clicking on these words.
These file should be removed from the zip folder, before you use them.

The following set of files is similar
to the above, but they have an additional feature, called the ** Random
Number Generator**. You
can download five versions of the Basic Algebraic Equation Generator, with the
Random Number Generator, in one zipped folder, for Microsoft Excel 2003, Excel
2007-2010, OpenOffice Calc, and JavaScript, by left clicking on these words.

__WEBSITE
5)____ The
Basic Integral Calculus Generator__

This device is comprised of a ** LIST** of 12 calculation devices that receive
numbers from the same set of input boxes, and its website is www.TechForText.com/IntegralCalculusGenerator
This website contains over 4000 words, on the Basic Integral Calculus
Generator. The Integral Calculus Generator is a practical device, designed to
help students practice solving basic integrals. For an online printer friendly
version of the

You can download the above in a number of formats, in one zipped folder, by left clicking on these words. This includes file formats for Microsoft Excel 2003, Excel 2007-2010, OpenOffice Calc , and JavaScript versions. These file should be removed from the zip folder, before you use them.

__WEBSITE
6)____ The Trig‑Integral‑Calculus‑Generator__

This device is comprised of a ** LIST** of 12 calculation devices that receive
numbers from the same set of input boxes, and its website is www.TechForText.com/Trig-Integral-Calculus-Generator

If you want the above for Microsoft Excel 2007-2010, left click on these words.

If you want the above for OpenOffice Calc, left click on these words.

If you want the above in JavaScript, left click on these words.

All of the above files are in a zipped folder, and they should be removed from the folder, before you use them. For instructions, additional information and links go to the main website for this device: www.TechForText.com/Trig-Integral-Calculus-Generator

__WEBSITE 7)____
The Tangent‑Cotangent‑Integral-Calculus‑Generator__

This device is comprised
of a ** LIST** of 12 calculation
devices that receive numbers from the same set of input boxes, and its website
is www.TechForText.com/Tangent-Cotangent-Integral-Calculus

__This is a practical device, designed to help students
practice solving integrals with tangent and cotangent.__ ** **For
an online printer friendly version of the ** Tangent-Cotangent-Integral-Calculus-Generator
**left click on:

If you want the above in one zipped folder, for Microsoft Excel 2003, Excel 2007-2010, OpenOffice Calc, and JavaScript left click on these words. These file should be removed from the zip folder, before you use them. For instructions, and additional information and links go to the main website for this device.

__WEBSITE
8)____ The Secant‑Cosecant‑Integral‑Calculus‑Generator__

This device is comprised
of a ** LIST** of 12 calculation
devices that receive numbers from the same set of input boxes, and its website
is www.TechForText.com/Secant-Cosecant-Integral-Calculus

This is a practical device, designed to help students
practice solving integrals with secant and cosecant. For an online printer
friendly version of the **Tangent-Cotangent-Integral-Calculus-Generator** left
click on:** **www.TechForText.com/Tangent-Cotangent-Integral-Calculus/1

If you want the above in one zipped folder, for Microsoft Excel 2003, Excel 2007-2010, OpenOffice Calc, and JavaScript versions, left click on these words. These file should be removed from the zip folder, before you use them. For instructions, and additional information and links go to the main website for this device.

__WEBSITE
9)____ The Double‑Integral‑Calculus‑Generator__

This device is comprised
of a ** LIST** of 12 calculation
devices that receive numbers from the same set of input boxes, and its website
is www.TechForText.com/Double-Integral-Calculus-Generator
This is a practical device, designed to help students practice solving double
integrals. For an online printer friendly version of the
Double-Integral-Calculus-Generator left click on: www.TechForText.com/Double-Integral-Calculus-Generator/1

You can download six versions of the Double-Integral-Calculus-Generator, in one zipped folder, for Microsoft Excel 2003, Excel 2007-2010, OpenOffice Calc, and JavaScript, by left clicking on these words. These file should be removed from the zip folder, before you use them. For instructions, and additional information and links go to the main website for this device.

__WEBSITE 10)____
Calculating‑Databases Website with 12 Excel Databases__

This website www.TechForText.com/Calculating-Databases
has 12 Excel databases with an alphabetizing function, and some type of a
calculation mechanism, such as for statistical calculations. **To download the Excel databases, and for additional
information go to the main website, which is listed above.** This
website contains over 4500 words of descriptive text and instructions, and it
has a hyperlinked table of contents. All the Excel databases from this website
are in two file formats, one for Microsoft Excel 2003, and the other for Excel
2007-2010. There are two additional databases link to this website, (__Averaging‑Database__
from WEBSITE 2, and the __Database Scientific Calculator__, from WEBSITE
14)

The following 4 websites have JavaScript
databases that function online. The websites and the calculation devices they
contain can be accessed through links on the ** Calculating-Databases
Website,** as well as the links listed below.

__WEBSITE 11)____
The online JavaScript Average‑Score‑Database‑Calculator__

This website is very small, www.TechForText.com/Average-Score-Database-Calculator, and it contains a calculation device that calculates an average score, and an individual score, based on percent of the average, when a set of names or labels are entered with scores. The individual scores are calculated with the following formula, by the mechanism in the software.

**100%(Individual Score/Average)= %of
Average Score**

**The above formula is the same as: 100
multiplied by, the individual score divided by the average score. **The
above formula is applied to each score entered. **The formula converts each
score into a percentage based on the average, such that an average score is
100%, a score below averages less than 100%, and a score above average is
greater than 100%. This is similar to the way IQ scores are represented. **

__WEBSITE 12) ____The
Online JavaScript Maximum‑Score‑Database‑Calculator__

This website is very small, www.TechForText.com/Maximum-Score-Database-Calculator and it contains a calculation device that calculates individual scores, by comparing each score with the maximum score, in terms of percent, when a set of names or labels are entered with scores. To do this, the software uses the following formula:

**100%( Individual Score/Maximum Score)=
% of Maximum Score**

The above formula is the same as: **100
multiplied by, the individual score divided by the maximum score. **With
this formula, the maximum score is always 100%, and any score that is less than
the maximum will be less than 100%.

__WEBSITE 13)____The
Online JavaScript Score‑Database‑Calculator__

This website is very small, www.TechForText.com/Score-Database-Calculator and it contains a calculation device that calculates individual scores, in terms of a percent of a standard score. The user enters a score that is to be used as a standard score. The software uses the following formula for the calculations:

**100%( Individual Score/ Standard
Score) = % of Standard Score**

The above formula is the same as: 100 multiplied by, the individual score divided by the Standard Score. With this formula, any score that is above the standard score will be greater than 100%, and any score that is below the standard score will be less than 100%. Any score equal to the standard score is 100%.

__WEBSITE
14)____ The
Database Scientific Calculator__

**The Database-Scientific-Calculator is a multifunction
calculation device, with three built-in databases, for mathematical
functions, for instructional text, and for equivalent spreadsheet
formulas. **The website for this device is www.TechForText.com/Database-Scientific-Calculator
For an online printer friendly version of the Database-Scientific-Calculator
left click on the following link: www.TechForText.com/Database-Scientific-Calculator/1
The Database-Scientific-Calculator is also available for download, in Microsoft
Excel 2003, Excel 2007-2010, OpenOffice Calc, and JavaScript formats, by left
clicking on the following link. You
can download all of the above, in one zip folder, by left clicking on these
words. The
file should be removed from the zip folder before they are used.

**The
Database-Scientific-Calculator can perform all of the following ****calculations: addition; subtraction; multiplication;
division; logarithms with any base, including e; hyperbolic
and trigonometric calculations, for sine, cosine, tangent,
cotangent, secant, and cosecant, with angles in degrees or
radians.** It also has built-in formulas to calculate the
perimeter and area of a circle, the surface area and volume of a sphere.
The Database-Scientific-Calculator has 50 functions, but 14 are experimental.
These functions provide a utility similar to a scientific calculator.

**The Database-Scientific-Calculator has
three built-in databases that operate as a single unit, for mathematical
operations, to display equivalent spreadsheet formulas, and to
display instructions and general information. The three databases are
concealed from the user, but the search box and the results of the search are
visible to the user. **

On the surface, the ** Database-Scientific-Calculator**
does not appear to be any better than a $75 handheld scientific
calculator. However, if we examine the details there are very significant
differences between a conventional scientific calculator, and the
Database-Scientific-Calculator. A calculation device such as the
Database-Scientific-Calculator can be designed and built with thousands of
functions, and tens of thousands of words of instructional material for the
user. The calculation devices built with this design concept can perform
highly complex calculations with Mega formulas. Devices such as the
Database-Scientific-Calculator can be designed and built to perform
computations with letters and text, but I did not test this extensively. There
is no doubt that it can retrieve text stored in its database, in response to a
word, symbol, a sentence, or a question.

A conventional scientific calculator,
or any other device that I know of cannot do __all of the above, in one
operation. (Perform a calculation with a function retrieved from its
database,__

**If you want to go to the top
of the website, left click on these words.**

__Definitions and other Information
for the Databases and Lists__

__ __

**As the terminology is used on this website**,
a

All of the databases provided through this website have some type of built-in calculation mechanism that I created. This can range from devices that simply count the number of blank spaces and the number of entries in a database, to relatively complex calculation mechanisms that perform various types of statistical calculations.

__As the terminology is used
here,__* **a *__list__* *is
a set of records, arranged in ** columns**, which can consist of text,
formulas, numbers, calculation devices, or any type of data that can be
recognized, by either humans or the computer. The databases provided by this
website are essentially lists with retrieval mechanisms.) The calculation
mechanisms in the lists vary widely, depending on the purpose of the device.

This concept can be somewhat
confusing, so I will provide the lists available from this website as
examples. ** The One-Year Appointment Book Generator,** is a list of
formulas that generate 368 dates, on 368 pages, to create an appointment book
that is useful for 368 days.

· __Basic
Algebraic Equation Generator __

· __The
Basic Integral Calculus Generator__

· __The
Trig‑Integral‑Calculus‑Generator__

· __The
Tangent‑Cotangent‑Integral-Calculus‑Generator __

· __The
Secant-Cosecant-Integral-Calculus-Generator__

· __The
Double-Integral-Calculus-Generator__

Most of the devices provided through this website have practical applications. For example, six of the devices I created are designed to help students practice solving: algebra problems, single integrals, trigonometric integrals, and double integrals. Another device generates one-year appointment books that have many practical uses. A number of the devices I created serve as online calculation devices, such as to calculate averages, and the correlation coefficient of two data sets. The Excel databases I created come in a number of varieties, and they have many practical uses, ranging from storing contact information, to calculating classroom grades based on test scores.

__ __

__Reusable Template Format for Devices
in Microsoft Excel and Openoffice Calc__

__All the devices____ from this
website, i____n the Microsoft Excel and OpenOffice
Calc formats,____ are in a reusable template
format. That is each time you left click on the template it generates a new
device. The templates are NOT consumed by continuous use, and you can produce
a limitless number of devices from one template. The devices that are produced
from the template of course require Microsoft Excel or ____OpenOffice Calc,____ but they can
function without the original template.____ __

__When you left click on a
template to create a new device you must save the resulting device with a new
filename. Choose a filename that will help you and others easily identify the
device. __

__ __

**If you want to go to the top
of the website, left click on these words.**

__ __

__Design Concepts and
Services Offered by the Author__

__Design Concept to
Maximize User‑Friendliness:
For the Website and For The Databases____ and Lists__

I
designed the __calculating databases and lists__, and this __website__ in
a way that would maximize efficiency and ease-of-use. The __calculating
databases and lists__ have instructions placed next to related input cells,
and it is laid out with a simple structure, with large fonts.
The website similarly has large fonts, with a relatively simple structure, and
clearly written instructions.

The website is on one long webpage. This provides the convenience of scrolling down or up, from one section to another, and it avoids the unnecessary complexity of pull-down menus, and links to go from one page to another. However, I provided a hyperlink table of contents as an alternative way of navigating the website, located on the bottom of this webpage.

I structured each sentence with the goal of minimizing confusion, and maximizing comprehension, for users with varying levels of technical knowledge. In this regard, perfection is never possible, because users come from diverse technical, cultural, and linguistic backgrounds.

I provided many headings and subheadings throughout this text. This allows the user to easily skip material that they find difficult, or uninteresting. The headings and subheadings are also displayed in the table of contents.

__Services
Offered by the Author David Alderoty__

I design and build
user-friendly software based calculation devices for __arithmetic__, __accounting__,
__currency exchange rates__, __algebra__, __trigonometry__, __correlations__,
__calculus__, and databases with built-in calculation devices. I also
create attractive online calculation devices for websites. I generally make
these devices in the Microsoft Excel, OpenOffice.org, and the JavaScript
formats, but I can work with other spreadsheet formats besides the above. I
also create web communication forms in JavaScript for websites. This includes
forms with built-in calculation devices.

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

**For a list of websites with
calculation devices that I created, left click on these words, or go to the
following website:**** ****www.TechForText.com/Math****
**For a 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**

__I can provide
the services mentioned above 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 data on the services I offer, you
can email me at __**David@TechForText.com****
**or **use a website communication
form, by left clicking on these words.**

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

__ __

**If you want to go to the top
of the website, left click on these words.**

__ __

__SCROLL DOWN FOR THE TABLE OF
CONTENTS OF THIS WEBSITE__

** **

** **

** **

__Introduction to The Hyperlink
Table of Contents of this Website__

__This website is more or less laid out like a book, but
it is on one long webpage. You can scroll up or down to go from one__ topic
to another. However, if you want to examine all the sections and subsections
of this website, use the __hyperlink table of contents__, below this
paragraph. To go to any section or subsection of this website you can left
click on the blue words that relate to the material you want to read. The
subsections are in uppercase letters.

**If you want to go to the top
of the website, left click on these words.**

__Table of Contents
of this Website Contents__

** **

**Website Links and Download
Links for the Databases, and Lists**

**WEBSITE
1) and The One‑Year Appointment Book Generator**

**WEBSITE
2) The Averaging Calculator and Averaging‑Database**

**WEBSITE
3) Correlation‑Calculator**

**WEBSITE
4) Mathematics‑Problem‑Generators**

**WEBSITE
5) The Basic Integral Calculus Generator**

**WEBSITE
6) The Trig‑Integral‑Calculus‑Generator**

**WEBSITE
7) The Tangent‑Cotangent‑Integral-Calculus‑Generator**

**WEBSITE
8) The Secant‑Cosecant‑Integral‑Calculus‑Generator**

**WEBSITE
9) The Double‑Integral‑Calculus‑Generator**

**WEBSITE
10) Calculating‑Databases
Website with 12 Excel Databases**

**WEBSITE
11) The online JavaScript Average‑Score‑Database‑Calculator**

**WEBSITE
12) The Online JavaScript Maximum‑Score‑Database‑Calculator**

**WEBSITE
13)The Online JavaScript Score‑Database‑Calculator**

**WEBSITE
14) The Database Scientific Calculator**

**Definitions and other Information for
the Databases and Lists**

**Reusable Template Format for Devices
in Microsoft Excel and Openoffice Calc**

**Design Concepts and Services
Offered by the Author**

**Design Concept to
Maximize User‑Friendliness:
For the Website and For The Databases and
Lists**

**Services
Offered by the Author David Alderoty**

**Introduction to The Hyperlink Table of Contents of this Website**

** **