Google
 
Web excelfan.com

About Google

  

Excel Calendar with World Clock

Disclaimer

What's New:

Countdown in Excel for Your Events

excelfan.com (CalendarClockCountdown)

   Excel 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.

- October 31, 2013 - Revised

   Excel 2011 Rugby World Cup New Zealand Planner and Countdown
- now under construction
June 26, 2011

   Excel Prime Numbers

   Excel Age Count
- March 6, 2011 -

   Excel Calendar and Cell Locator
- January 8, 2006 -
Revised - October 9, 2008 -

     7-Week Workdays and Holidays Planner


- October 3, 2008 -


Google Spreadsheets/List of Victims from Sept. 11, 2001

Courtesy of FOXNews.com

- September 11, 2008 -


     Calendars: Google Spreadsheets/Gadgets and Excel



- June 15, 2008 -


     Excel Nobel Laureates since 1901



- May 25, 2008 -


     Excel Historical Timeline: Space Shuttle Timeline



- May 17, 2008 -


     Excel Chart: Daily Gold Price in US Dollar
per Troy Ounce, London PM Fix



- May 14, 2008 -



     Excel: Draw a Pentagon



- May 3, 2008 -


     Weeks Numbers of 52 Weeks of the Year - Excel spreadsheet



- April 19, 2008 -


     IMF Exchange Rates: Japanese Yen to US Dollar


Source: IMF Exchange Rates

- March 25, 2008 -


     St. John the Baptist Parish Sales and Use Tax Return Worksheet

"Feel free to copy this worksheet into your spreadsheet program (this worksheet is in Microsoft Excel format)."


- February 20, 2008 -


     Monthly Credit Cards, Loans and Utility Payments on Bank Accounts

"If the day a repeating payment is scheduled falls on a weekend or bank holiday,
the payment will be processed the next business day."


- February 6, 2008 -


     Spot Prices for Crude Oil and Petroleum Products: WTI


Source: EIA
- January 15, 2008 -


     New Year's Math: Completing the Square for Quadratic Equation

- December 30, 2007 -



YouTube - Completing The Square, Part 1 of 3


     Easter Dodecahedron in Excel Pentagon and
Dodecahedron


Thanks Kaboose for clip art.

- February 21, 2008 -


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. 

EPA-DOE Release Fuel Economy Lists for 2008 Models
- Numbers reflect new fuel economy testing methods Newsroom US EPA
 

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
on July 22, and ends in Polynesia at 04:19:26 UT on July 22. 

The maximum eclipse is at 02:35:21 UT on July 22, when the total phase will
 last a stunning 6 minutes and 39 seconds. The partial eclipse will be visible
 over south-east Asia, Malaysia, Indonesia and the Pacific 
between 23:58:19 UT on July 21 and 05:12:25 UT on July 22.
"

( Hermit Eclipse: Total Solar Eclipse: July 22 2009)


    Excel Countdown on the 2009 Total Solar Eclipse

"The path of totality passes through the Ryukyu Islands (Map of Okinawa) at around 01:56 UT; 
the path width is 254 km, and the total eclipse will last 6 minutes 20 seconds on the centreline
."




YouTube - Total Solar Eclipse 2006
- July 12, 2007 -

     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 -
 


Excel as Decoding Tool

- 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 -


How to keep your weekly or monthly schedule table updated

- September 20, 2006 - 


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 - 

Excel Anniversary & Birthday Update
- September 12, 2006 -




Excel can be used just not for calendars or planners. It also comes into play when
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 -



Floating weekly calendar is designed to show the current week and
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 -



Puzzle by Sudoku Fun 06/7/11 06/7/12
Puzzle by Nikoli.co.jp 06/7/8 hard
06/7/14
Puzzle by WebSudoku.com 06/7/8 06/7/14
Puzzle by Sudoku.com 06/7/8
Puzzle by Su Doku The Times
Times Online
'easy'
06/8/3
'fiendish'
06/7/20
Puzzle by Nikkei'Need over 20 minutes?
You need more practice.'

07/5/28



"May I tell a story purposing to render clear the ratio circular perimeter breadth,
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 -

My first calendar website designed not to use Excel but only HTML,
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 -

Here are some HTML files converted from Excel files: 
date & time duration calculation and expense report form
- November 13, 2003 -
 

   Time Management for academic support for the new semester
- April 27, 2003 -



So we are now at the threshold of the new millennium.  Back at the end
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.  

Now, starting to make new year's, well, new millennium's resolutions, 
we should work out our plans and schedules.

So we need the calendar for 2001 and afterword.  Don't look around for
 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, 200
4, 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?

Please find out with Excel International Holiday Schedule 2008
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 -

Request Tracking in Excel
- September 7, 2002 -

3-month Blank Calendar

- March 27, 2002 -

40-month Floating Weekly Planner
- March 30, 2002 -

The 2010 FIFA World Cup (Soccer) South Africa Timeline in Excel
- 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 -


    Books You Want 120x60

 

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 200
4 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 2004 holiday calendar for Canada
- December 8, 2001 -

Jewish Holiday Calendar
- October 13, 2001

 

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
2-Year Three Month Monthly Lookup Calendar & Planner.
- Mar. 3, 2001 -


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 -


And here are m
y earliest works:

6-Month Dynamic Calendar; 12-Month Dynamic Calendar

- December 6, 2000 -


And more.   Here is World Clock UK.  The local times in Ohio,
Los Angeles and Tokyo are shown relative to the time in the UK (GMT).
- The latest version file has now the international dialing code sheet 
December 6, 2000 -





Ken's Home Radio

Ken's Tips on Utsunomiya



The Japan Times Top News of the Day and Archive


Since November 3,1999


Back to Top


Copyright (C) Ken Matsuoka