since Novmber 3, 1999
since Novmber 3, 1999
since December 21, 2001
|
|
|
Excel Calendar with World Clock |
What's New:
|
Countdown in Excel for Your Events excelfan.com (CalendarClockCountdown)
- October 3, 2008 -
Google Spreadsheets/List of Victims from Sept. 11, 2001
- September 11, 2008 -
- June 15, 2008 -
- May 25, 2008 -
- May 17, 2008 -
- May 14, 2008 - |
Weeks Numbers of 52 Weeks of the Year - Excel spreadsheet
|
- March 25, 2008 -
- February 20, 2008 -
- February 6, 2008 -
- January 15, 2008 -
YouTube - Completing The Square, Part 1 of 3 |
Easter Dodecahedron in Excel Pentagon and
Dodecahedron
Thanks Kaboose for clip art.
Conversion: mile to kilometer; gallon to liter
I have just tried to use Google Spreadsheet and Search to help those
in countries like Japan where they are not familiar to the units of mile and gallon,
as in the lists of fuel economy leader models of cars and SUV recently announced
by EPA for the 2008 model year.
Here is my spreadsheet.
- December 1, 2007 -
Google Docs & Spreadsheets - 070809Calendar
on my Google Spreadsheet
now has the new sheet for the table of birthdays
and ages of some of the billionaires as listed by Forbes.com.
Excel
Version - 070809.xls
- August 16, 2007 -
On
the spreadsheet is the chemical "Periodic Table" .
Also shown in
Google Spreadsheet
YouTube - Periodic Table of the Elements Song
- January 5, 2008 -
|
Once-in-a-Lifetime
or Even -a-Century Total Solar Eclipse in July 2009
"The total solar eclipse begins just off the coast of India at 00:51:17 UT
The maximum eclipse is at
02:35:21 UT on July 22, when the total phase will ( Hermit Eclipse: Total Solar Eclipse: July 22 2009)
"The path of totality passes through the Ryukyu Islands
(Map of
Okinawa) at around 01:56 UT; YouTube - Total Solar Eclipse 2006 |
Excel as Decoding Tool
How to keep your weekly or monthly schedule table updated
Monthly Birthday Calendar for Centenarians
lists
Excel Anniversary & Birthday Update Excel can be used just not for calendars or planners. It also comes into play when Floating
weekly calendar is designed to show the current week and
Excel Mortgage Payment Calculator
"Mortgage terms are usually 15 or 30 years.
The longer the term, the lower your monthly payment,
but the higher your overall interest costs."
So says Mortgage Basics - Real Estate Guide on Yahoo! Personal Finance.
My spreadsheet can be used to calculate the "overall interest costs"
as well as the amount of payment including interest month by month.
- March 2, 2007 -
Excel Combination & Binomial Theorem
Binomial Theorem
Pascal's Triangle
- February 21, 2007 -
World Clock Summer Time
- January 25, 2007 -
5-Month Floating Planner
- January 5, 2007 -
- October 14, 2006 -
In "Wonders of Numbers: Adventures in Mathematics, Mind, and Meaning
Martin Gardner challenges the reader to find out about something relevant in numbers
in the following paragraphs (details):
In the beginning God created the heaven and the Earth.
And the earth was without form, and void; and darkness was
upon the face of the deep. And the Spirit of God moved
upon the face of the waters.
And God said, Let there be light: and there was light.
- December 6, 2006 -
- September 20, 2006 -
the oldest man and woman in the world.
Age calculation for centenarians, what Excel does not support in simply
subtracting the birthdate before 1900/1/1 from today, is shown on
the spreadsheet with the names of 65 super centenarians (age over 109)
in Japan, announced by Ministry of Health, Labour and Welfare
on the occasion of Respect for the Aged holiday weekend.
- September 16, 2006 -
- September 12, 2006 -
used as math tools. It would prove more useful when combined with google calculator.
Here is Excel Trigonometry.
- August 17, 2006 -
Excel Vector Trigonometry
- November 25, 2006 -
the next some 30 weeks. This would be typically used for hotel bookings
or dating, both to avoid conflicting arrangements.
Here is Hotel Reservations Bookings Weekly Planner.
- August 8, 2006 -
This is a revised version of my entry dated September 21, 2001 to show the booking status
of a hotel
for any week - past, present or future. Type in the date which you would
like
to be shown in the starting week of the period in cell C3.
About Sudoku
Try my first Sudoku puzzles on Excel Sudoku
- July 3, 2006 -
Sample some Sudoku, or number place, puzzles here.
To start with, Wikipedia in Excel
- July 6, 2006 -
|
"May I tell a story purposing to render clear the ratio circular perimeter breadth,
My
first calendar website designed not to use Excel but only HTML,
Here
are some HTML files converted from Excel files:
So we are now at the threshold of the new millennium. Back at the end
Now, starting to make new year's, well,
new millennium's resolutions,
So we need the calendar for 2001 and afterword. Don't look around for
Please
find out with Excel
International Holiday Schedule 2008
Request
Tracking in Excel 40-month
Floating Weekly Planner
The
2010 FIFA World Cup (Soccer) South Africa Timeline in Excel
revealing one of the problems most famous in modern days, and the greatest man of
science anciently known."
said someone, trying to recite, incredibly, the first 31st digits of Pi.
Prose in Pi
- June 4, 2006 -
Google & Excel
- May 13, 2006 -
The
Olympics Term Planner
shows the Olympic Games of the past and present
plus the next two Olympics: Beijing, 2008 and London, 2012.
- May 16, 2006 -
Excel
Calendar Stock Chart
- September 11, 2003 -
Timeline
Planner is designed to help work out a weekly schedule for completing
a task by the deadline date process by process with activities and
responsibilities defined. Type in a date to start the time frame in cell
C1.
Here is the file.
- October 31, 2013 - Revised
- October 18, 2001 -
for time management, is linked from here.
I am no expert on HTML,
as you see from this webpage, but will try to improve the website.
So please check it out for update from time to time.
- August 28, 2003 -
date & time duration calculation and expense report form
- November 13, 2003 -
Time
Management for academic support for the new semester
- April 27, 2003 -
of 1999, we were bracing ourselves for the possibly apocalyptic Y2K issue.
Thank God, practically nothing happened. We have weathered all that,
and now, feeling like new men and women, we are focusing on various
challenges awaiting us in 2001. The long-term challenge for the 21st
century would be to further spread democracy worldwide to create an
environmentand infrastructures to enable the people on all the continents to use
the latest industrial and information technologies to raise their living standards
and truly civilize their societies, thus liberalizing some from poverty, racial
prejudice, oppression of dictatorships or digital-divide.
we should work out our plans and schedules.
the calendars,
though. Here is the Excel
Calendar for 2006. This
has holiday
schedule of
the USA for 2006, 2007, 2008, 2009 and 2010 listed.
By entering the
year, 2004, for example, in the cell G3,
you can have the annual calendar of that
year.
Or you may find it interesting to see the current month always shown on top.
Thus we see the time really flow. How? Just leave the cell
blank.
- December 27, 2002 -
Then how are the holidays of the US scheduled to compare with those of
other countries such as Australia, China, Islamic, Japan, Jewish and Korea?
Click here when the link above doesn't work.
Revised October 25, 2007
- Since February 18, 2003 -
Countdown
in Excel for Your Events
- November 27, 2002 -
- September 7, 2002 -
3-month
Blank Calendar
- March 27, 2002 -
- March 30, 2002 -
- March 13, 2003 -
The 2007 Rugby
World Cup Schedule with countdown in Excel
- July 27, 2002 -
Excel Major League Baseball Schedule & Score Update
- August 25, 2006 -
How
about making a calendar on your own. How?
Start with filling in dates on the cells of Excel. Here
is the file.
- December 15, 2001 -
The
3-Month Vertical Calendar, designed to show the 3 months,
starting with either the current month (enter "=TODAY()" in B1 cell),
or
any month (enter "2001/7" in B1 cell) followed by the next 2 months,
is posted. This may be used as "To do list", but would be
refined with advice
from the users.
- February 26, 2001 -
- Just for change, here is the 2004 holiday calendar of Japan.
The holiday
dates, like Jan. 14, are shown in bold face with underbar. October 15, 2001 -
The 2004 holiday calendar for
Great
Britain
- November 23, 2001 -
The 200
4 holiday calendar for Canada
Now,
fed up with all these calendars? Yes, all we need is this Excel spreadsheet
to figure out how many more days to go to next Saturday or next month.
- June 20, 2001 -
As
the 21st century starts, we are now experiencing the true turn of the
century. Here is my old Excel
Millennium Countdown Clock.
Please find out how the countdown data has changed in the same cell
since midnight, Jan. 1, 2001.
Are
you always drawing up a monthly schedule for your
business, study or training, with paper and pens, or, well, Excel,
from a scratch. Then, this is a template you would use Excel to print
or enter date on your PC's.
The
3-month template version has just been revised to have a lookup
function to show the daily schedules listed on the year sheet on the monthly
sheet, for the current month and the following two months. Here
is the file
When accessing the file server, you may be prompted to enter ID and
passwords. Just press the "Cancel" button, and downloading will
start.
Excel
Blank Monthly Calendar (single- and three-month)
- Revised October 21, 2000 -
Excel Weeks Calculator
When will it be or was it after 400 weeks starting from any given date?
Scroll down the Excel sheet to cells E20, F20 and G20.
- December 2, 2000 -
When
will it be one's (oh, women's) next period in their monthly
menstrual cycles. It is reported in an article of Time that more and
more women are tricking their bodies into skipping their periods,
some to nine instead of the usual 13 periods a year.
How then do they figure out the date of the next period, if they are to take
control of their monthly cycles. It may be none of my business, but
I have designed a calculator on the same spreadsheet of the Excel Weeks
Calculator (cell E28), hopefully to help them get a grip on their monthly
cycles.
Here
is the article "Who Needs a
Period?" - By Christine Gorman,
Time, September 18, 2000
Lunar
Month Due Date Calculation
- Thanks for the theory, Lunar
months: Calculating your due date
- November 14, 2001 -
Lunar
Months: Natural Family Planning Basics
- Thanks for the theory, Natural
Family Planning Basics - Couple to Couple League
- November 18, 2001 -
Excel
Look-up Monthly Calendar <II>
- March 31, 2001 -
The revised version of the Excel Lookup Monthly Calendar, which was
posted on June 20, 2000, has now only the daily schedules of the week listed
on the Weekly Table shown onto the monthly calendar.
And
here is one more planner. Tired of staring at monthly calendars, I
have designed
a long-term planner, a combination of a term calculator and a chart, to help
work out
a plan based on To Do actions listed on the long term basis. It is
designed to show
a monthly time chart up to the year 2016. This would help us put things
into
perspective to prioritize things to do over a given time frame. Here
is the file.
To start with, type in the starting year on the cell D7.
- June 9, 2001 -
And
a weekly planner, designed to show the next 4 months, starting with the
current
month (or type in any month in cell C1, eg. 2001/8), is posted. This would
eliminate the hassle of looking up the first and last day of the month in a
calendar.
Here is the file.
- June 13, 2001 -
The weekly planner is now combined with the monthly calendar
as well as 3-month calendar that shows the record marked on the year sheet,
which was posted on May 25, 2001.
On the weekly calendar, the schedule marked on the cell below
the Monday date (eg. cell AY80) on the year sheet
is shown above
the corresponding Monday date.
Personnel Terms & Headcount
Here is the file.
- November 21, 2001 -
On the monthly calendar, the schedule marked on the cell 2 lines below the date
(eg. cell AZ81) on the year sheet is shown on the corresponding date.
Here is the file.
- June 20, 2001 -
Here
is Three Month Lookup Calendar 2002. The 3-month and weekly
calendars are modified to allow entry of more schedule data for each day and week
respectively.
On the weekly sheet, cell C1 carries this to show the current month
followed by the next 5 months.
=DATE(YEAR(TODAY()),MONTH(TODAY()),DAY(1))
Now, change this to the following:
=DATE(YEAR(TODAY()),MONTH(TODAY())+X,DAY(1))
Here in X comes any number of months before (+ changed to -) or after
the current month.
And you have cell C1 show any month to start the weekly calendar.
Here is the file.
-September 8, 2001-
Excel
Look-up Monthly Calendar <I>
- June 20, 2000 -
Excel
lookup function is used to show the anniversary and holiday listed on
the Annual Table, daily schedule of the week listed on the Weekly Table,
and birthday listed on the Birthday Table,
all onto the corresponding columns of the monthly calendar (view).
-
June 3, 2000 -
Staring at the calendar can be boring, unless it is one's only pastime.
I have figured out how Excel can be used to have my weekly schedule,
-- routine, that is, shown on the monthly calendar so as to avoid the hassle
of daily entry. The look-up function is used to show the weekly events
recorded
on "Weekly Table" onto the monthly sheet.
Monthly Birthday Calendar for Centenarians lists the oldest man and woman in the world.
Age calculation for centenarians, what Excel does not support in simply
subtracting the birthdate before 1900/1/1 from today, is shown on
the spreadsheet with the names of 65 super centenarians (age over 109) in Japan,
announced by Ministry of Health, Labour and Welfare
on the occasion of Respect for the Aged holiday weekend.
- September 16, 2006 -
Access
Ken Matsuoka's original calendar with millennium countdown
,
which also has the new additional Weekly Calendar allowing insertion of
photograph(s)
(on cell B8 of the sheet Weekly), and you will figure out how you can use this
to
attract more access to your Web page, by showing the link with or
without
advertisement on the Excel work sheet.
The original monthly calendar has been equipped with the dropdown list of months
to select (dropdown list in cell J7 while clearing cell J4;
otherwise "=TODAY()" or blank in cell J4 to show the current
month).
- this comment added May 22, 2001 -
Please select the version:
The Mon - Sun Version
The Sun - Sat Version
Find
out how the combination of the monthly calendar and the 3-Month Lookup
Calendar, posted on Mar. 3, 2001, works to make the records marked on the year
sheet stand out in the calendar of one (typically the current) month or 3
months.
Type a phrase in cell E81 of the year sheet for May 3 (next to
"Kyoto" in cell D81),
and you will have the same shown on both the monthly and 3-month calendars.
Here is the
file.
- May 25, 2001 -
6-Month
Dynamic Calendar; 12-Month
Dynamic Calendar
The Japan Times Top News of the Day
and Archive