| |
|
|
|
|
|
| |
|
|
|
|
| |
|
A
Demonstration Device, in the Form of a
Software-Based Calendar, to Illustrate a
Mathematical Concept, Involving Repetitive Cycles |
|
|
| |
|
Created by David Alderoty © 2015 |
|
|
| |
To contact
the author left click for a website communication
form, or use: |
|
| |
|
David@TechForText.com
|
|
|
| |
|
This software was created from a Microsoft Excel
spreadsheet, but it was converted to HTML and
JavaScript with SpreadsheetConverter, so that it can
function directly over the Internet, in conventional
web browsers. If you want the
software in the Excel format, you can download it,
by clicking on one of the following links:
The link on the left is for both the Excel
and JavaScript versions, IN A ZIP FOLDER.
|
|
|
| |
|
|
|
| |
|
www.TechForText.com/Ma/CR.xlsx
|
www.TechForText.com/Ma/CR.zip
|
|
|
|
|
|
|
| |
|
Delete the date in the white box below,
and enter any date you prefer. After entering your date, left click
with the mouse on the yellow or blue section of
the software, or click on the update button. Then the
software will generate a 50-day calendar, based on
the date you entered. The date
must be entered as month/day/year, as shown below.
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
|
|
|
| |
|
This calendar was primarily created to
illustrate a general mathematical concept, which is
essentially a theorem that relates to cycles, and to
demonstrate the functionality of the formulas listed
on the left side of the software. Each
of these formulas calculates a date with a specific
date of the week, which is based on a seven-day
cycle that starts on Sunday and ends on Saturday |
|
|
| |
|
|
|
| |
|
|
|
| |
|
The sequence of calculations starts by converting
the date you entered into a number that can be
calculated by the formulas comprising the software.
Based on the date that was entered above,
calculations will |
|
|
| |
|
|
|
|
| |
|
Microsoft Excels system, where Sunday, January 1, 1900 is
defined as DAY ONE. For the
calculations carried out by this software,
Saturday, December 31, 1899 is defined as times
zero, or DAY ZERO. This means
|
|
|
| |
|
|
|
|
|
|
|
|
|
| |
|
The
calculations start, with {=7*ROUNDDOWN((days/7),0)},
which is the first formula, listed on the software.
The initial calculation converts the the
number of days (that comprises the date you entered)
to weeks from time zero. Then, the result is rounded
down to the nearest integer to obtain a specific
number of weeks, without any fractions.
This date will be Saturday, because time zero
was on a Saturday, and we are dealing with a
repetitive seven-day cycle. Keep
in mind the cycle starts on Sunday, and ends on
Saturday. The above calculation,
locates the END-POINT OF THE CYCLE, which is a
Saturday. |
|
|
| |
|
|
|
| |
|
|
|
| |
|
|
|
|
|
|
|
|
| |
|
Formula
{=7*ROUNDDOWN((days/7),0)} also converts the weeks back into days, by multiplying by seven.
Keep in mind that this result may be equal
to or smaller than the initial number of days,
that comprised the date you entered. This
is because the number was rounded down when it was
converted from days to weeks. Thus,
the final calculated result from
{=7*ROUNDDOWN((days/7),0)} can be an earlier date
than you initially entered, but it will always be
on a Saturday, if it is based on Microsoft Excel’s
seven-day cycle.
|
|
|
| |
|
|
|
| |
|
|
|
|
|
|
|
|
| |
|
The other formulas in this software are based
on the formula described above, with the addition of
a number, as illustrated in the following examples:
|
|
|
| |
|
Calculated date is on a Saturday
=7*ROUNDDOWN((days/7),0) |
|
|
| |
|
Calculated date is on a Sunday
=7*ROUNDDOWN((days/7),0)+1 |
|
|
| |
|
Calculated date is on a Monday
=7*ROUNDDOWN((days/7),0)+2 |
|
|
| |
|
Calculated date is on a Tuesday
=7*ROUNDDOWN((days/7),0)+3 |
|
|
|
|
|
|
|
|
| |
|
It
is important to note that the formulas comprising
the software represent general mathematical
concepts, and they are not limited to Microsoft
Excel. However, time zero in
another software device, or in an applied
mathematical situation, might not be Saturday.
For example, if time zero
were on a Friday, the formulas listed above would
indicate: |
|
|
| |
|
|
|
| |
|
Calculated date is on a Friday
=7*ROUNDDOWN((days/7),0) |
|
|
| |
|
Calculated date is on a Saturday
=7*ROUNDDOWN((days/7),0)+1 |
|
|
| |
|
Calculated date is on a Sunday
=7*ROUNDDOWN((days/7),0)+2 |
|
|
| |
|
Calculated date is on a Monday
=7*ROUNDDOWN((days/7),0)+3 |
|
|
| |
|
|
|
|
|
| |
|
The final calculated results from all of the
formulas, comprising this software are converted
from days to dates, with the following Microsoft
Excel format code: [$-F800]dddd, mmmm dd, yyyy |
|
|
|
|
|
|
|
| |
|
For
additional information, about the mathematical
concepts explained above, left click on the
following link:
www.TechForText.com/Ma/Chapter-8 |
|
|
| |
|
|
|
|
|
| |
|
This
formula calculates a date that is a Saturday |
|
|
| |
|
|
|
|
|
| |
|
This
formula calculates a date that is a Sunday |
|
|
| |
|
|
|
|
|
| |
|
This
formula calculates a date that is a Monday |
|
|
| |
|
|
|
|
|
| |
|
This
formula calculates a date that is a Tuesday |
|
|
| |
|
|
|
|
|
| |
|
This
formula calculates a date that is a Wednesday |
|
|
| |
|
|
|
|
|
| |
|
This
formula calculates a date that is a Thursday |
|
|
| |
|
|
|
|
|
| |
|
This
formula calculates a date that is a Friday |
|
|
| |
|
|
|
|
|
| |
|
This
formula calculates a date that is a Saturday |
|
|
| |
|
|
|
|
|
| |
|
This
formula calculates a date that is a Sunday |
|
|
| |
|
|
|
|
|
| |
|
This
formula calculates a date that is a Monday |
|
|
| |
|
|
|
|
|
| |
|
This
formula calculates a date that is a Tuesday |
|
|
| |
|
|
|
|
|
| |
|
This
formula calculates a date that is a Wednesday |
|
|
| |
|
|
|
|
|
| |
|
This
formula calculates a date that is a Thursday |
|
|
| |
|
|
|
|
|
| |
|
This
formula calculates a date that is a Friday |
|
|
| |
|
|
|
|
|
| |
|
This
formula calculates a date that is a Saturday |
|
|
| |
|
|
|
|
|
| |
|
This
formula calculates a date that is a Sunday |
|
|
| |
|
|
|
|
|
| |
|
This
formula calculates a date that is a Monday |
|
|
| |
|
|
|
|
|
| |
|
This
formula calculates a date that is a Tuesday |
|
|
| |
|
|
|
|
|
| |
|
This
formula calculates a date that is a Wednesday |
|
|
| |
|
|
|
|
|
| |
|
This
formula calculates a date that is a Thursday |
|
|
| |
|
|
|
|
|
| |
|
This
formula calculates a date that is a Friday |
|
|
| |
|
|
|
|
|
| |
|
This
formula calculates a date that is a Saturday |
|
|
| |
|
|
|
|
|
| |
|
This
formula calculates a date that is a Sunday |
|
|
| |
|
|
|
|
|
| |
|
This
formula calculates a date that is a Monday |
|
|
| |
|
|
|
|
|
| |
|
This
formula calculates a date that is a Tuesday |
|
|
| |
|
|
|
|
|
| |
|
This
formula calculates a date that is a Wednesday |
|
|
| |
|
|
|
|
|
| |
|
This
formula calculates a date that is a Thursday |
|
|
| |
|
|
|
|
|
| |
|
This
formula calculates a date that is a Friday |
|
|
| |
|
|
|
|
|
| |
|
This
formula calculates a date that is a Saturday |
|
|
| |
|
|
|
|
|
| |
|
This
formula calculates a date that is a Sunday |
|
|
| |
|
|
|
|
|
| |
|
This
formula calculates a date that is a Monday |
|
|
| |
|
|
|
|
|
| |
|
This
formula calculates a date that is a Tuesday |
|
|
| |
|
|
|
|
|
| |
|
This
formula calculates a date that is a Wednesday |
|
|
| |
|
|
|
|
|
| |
|
This
formula calculates a date that is a Thursday |
|
|
| |
|
|
|
|
|
| |
|
This
formula calculates a date that is a Friday |
|
|
| |
|
|
|
|
|
| |
|
This
formula calculates a date that is a Saturday |
|
|
| |
|
|
|
|
|
| |
|
This
formula calculates a date that is a Sunday |
|
|
| |
|
|
|
|
|
| |
|
This
formula calculates a date that is a Monday |
|
|
| |
|
|
|
|
|
| |
|
This
formula calculates a date that is a Tuesday |
|
|
| |
|
|
|
|
|
| |
|
This
formula calculates a date that is a Wednesday |
|
|
| |
|
|
|
|
|
| |
|
This
formula calculates a date that is a Thursday |
|
|
| |
|
|
|
|
|
| |
|
This
formula calculates a date that is a Friday |
|
|
| |
|
|
|
|
|
| |
|
This
formula calculates a date that is a Saturday |
|
|
| |
|
|
|
|
|
| |
|
This
formula calculates a date that is a Sunday |
|
|
| |
|
|
|
|
|
| |
|
This
formula calculates a date that is a Monday |
|
|
| |
|
|
|
|
|
| |
|
This
formula calculates a date that is a Tuesday |
|
|
| |
|
|
|
|
|
| |
|
This
formula calculates a date that is a Wednesday |
|
|
| |
|
|
|
|
|
| |
|
This
formula calculates a date that is a Thursday |
|
|
| |
|
|
|
|
|
| |
|
This
formula calculates a date that is a Friday |
|
|
| |
|
|
|
|
|
| |
|
This
formula calculates a date that is a Saturday |
|
|
| |
|
|
|
|
|
| |
|
This
formula calculates a date that is a Sunday |
|
|
| |
|
|
|
|
|
|
|
|
|
|
|