Monday, December 02, 2013

Excel calendar, whoops, HTML Clock and Calendar

   Excel calendar, whoops, HTML Clock and Calendar, is now revised and shows the events of the season, - today, music pieces by Andre Riew played on YouTube on "Now". Its colour changes from hour to hour of the day with the time shown.

- December 2, 2013 - Revised

Monday, September 09, 2013

Oil Is Up While Gold Is Down


There are ups and downs in prices of everything on the market. But historically, gold has been tested by time and proved literally rustproof thus become a symbol of imperishable value, substituted by people across the continents to retain wealth whenever they are involved in any crises, economic - say, the Leerman Shock in 2008 - or not - social upheavals like wars or depressions or natural disasters like earthquakes and floods and their fortune is deemed vulnerable and put at the risk of devastating loss. So there is an almost eternal belief in gold. They abandon their money, rushing it to the gold. Their behavior in this option is called 'flight to simplicity'.

However, gold can be of less and less value over the shorter period of time, like the past one year. Whereas oil has been more and more highly priced meanwhile.

Their curbs are shown dramatically opposite by the graphs in these Excel files:

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

    Excel Chart: Cushing, OK WTI Spot Price FOB (Dollars per Barrel)

- September 9, 2013 -
 

Saturday, June 22, 2013

Let Excel Show the Market Trend to Make Analysis in Investment


    
"Excel Gold Price Chart" or formally "Excel Chart: Daily Gold Price in US Dollar per Troy Ounce, London PM Fix" will help us analyze the trend of gold prices on the market. Who said that when the curb turns down is the time to rush your money to the gold? Sounds stupid unless decision is made by studying and analyzing data available on the market. Excel will be of great help.

- June 22, 2013 -
 

Friday, May 10, 2013

My Old Excel Calendar Homepage is Back

Excel Calendar with World Clock
since November 3, 1999 but interrupted for a couple of years of Tripod's neglect.

I will resume the website, adding my latest Excel files from time to time.

Ken Matsuoka

Monday, June 16, 2008

Now comes Google Gadgets

Now I have just found them, I am looking forward to find out how I am going to make the best use of the three: Google Spreadsheets, Google Gadgets and Excel, all combined on a single web page like this or each separetely like juggling, but with an option to link one to another.

Thursday, December 06, 2007

Chemical Periodic Table in Google Spreadsheet

The table in Google Spreadsheet, exported from Excel, works, retaining the data and links.

Here is my web page with both Google and Excel spreadsheets.









Friday, November 30, 2007

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.





Friday, August 17, 2007

"Google Distributes Sun's StarOffice for Free"

DailyTech August 16, 2007 2:21 PM


Star Office 8 Sun Micro Systems


I will try it here in Japan. What difference does it make from Google Spreadsheets?
I will find out.





Wednesday, May 16, 2007

Excel Dodecahedrons


    
Excel Father's Day Dodecahedron

- May 17, 2007 -
 


    
Christmas Dodecahedron


Thanks Kaboose for clip art.



- December 14, 2007 -


Tuesday, February 20, 2007

(phi+1/phi)^2=5 as my Spreadsheet Shows





    
Binomial Theorem

Pascal's Triangle




"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". Try the "Interest" sheet.




    

This is Pascal Triangle Pro. It has lookup functions for binomial coefficient and shows Fibonacci numbers in the triangle.

- February 21, 2007 - 




Friday, January 26, 2007

Another Decoding

Following my first attempt to use Excel for decoding in Google & Excel: Excel as Decoding Tool, I have added "A Thousand Winds" for a similar decoding on my spreadsheet. Just check "Google & Excel: Excel as Decoding Tool".

"A Thousand Winds" has two versions. Thanks do not stand at my grave and weep - bereavement poem.


(do not stand at my grave and weep)

Do not stand at my grave and weep
I am not there; I do not sleep.
I am a thousand winds that blow,
I am the diamond glints on snow,
I am the sun on ripened grain,
I am the gentle autumn rain.
When you awaken in the morning's hush
I am the swift uplifting rush
Of quiet birds in circling flight.
I am the soft starlight at night.
Do not stand at my grave and cry,
I am not there; I did not die.


(do not stand at my grave and weep)

Do not stand at my grave and weep,
I am not there, I do not sleep.
I am in a thousand winds that blow,
I am the softly falling snow.
I am the gentle showers of rain,
I am the fields of ripening grain.
I am in the morning hush,
I am in the graceful rush
Of beautiful birds in circling flight,
I am the starshine of the night.
I am in the flowers that bloom,
I am in a quiet room.
I am in the birds that sing,
I am in each lovely thing.
Do not stand at my grave and cry,
I am not there. I do not die.



"do not stand at my grave and weep" song - Google Search

Wednesday, December 13, 2006

12 Pentagons Make a Dodecahedron

Or 2 pentagons each having 6 smaller pentagons in it make a dodecahedron.

Polyhedron like dodecahedron will be explored with Excel to use polygon like pentagon as building blocks.

I have designed and drawn a chain of 12 pentagons to cut and fold to make a dodecahedron dice so we can play with our kids. Excel Trigonometry.



Tuesday, December 05, 2006

Martin Gardner Challenges us in "In the beginning God...."

"1) In the beginning God created the heaven and the Earth.

2) 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.

3) And God said, Let there be light: and there was light."

In "Wonders of Numbers" (Clifford A. Pickover, 2000), Mathematician Martin Gardner challenges the reader to find out that:

Start with any word in 1) above ('In' to 'Earth'), and count the number of (length of) the word (say 3 in 'the'): "n1";

and Proceed to the word n1 after the first word (say 'created'), and count the number of (length of) the word (7): "n2";

and Proceed to the word n2 after the second word ('created'),
and so forth, and the two 'God's (one each in 2) and 3)) will thus end up just n* after the preceeding words.

My Excel spreadsheet will help find out about this.

Wonders of Numbers: Adventures in Mathematics, Mind, and Meaning



Monday, December 04, 2006

Correct?    "phi - (((1 / phi) * (1 - ((1 / phi)^70))) / (1 - (1 / phi))) = 0"



phi - (((1 / phi) * (1 - ((1 / phi)^70))) / (1 - (1 / phi))) = 0 is not verified by what I figure out with my Excel Trigonometry.


06/12/12

((1 / phi) * (1 - ((1 / phi)^70))) / (1 - (1 / phi)) = 1.61803399, more precisely, means that:

  1. 1/phi + 1/phi^2 + 1/phi^3 + .... + 1/phi^70 is 1.618033988..

  2. 1/phi + 1/phi^2 + 1/phi^3 + .... + 1/phi^70 + .... + 1/phi^n
    becomes indefinately closer to phi as 'n' increases to infinity.

    Phi to 20,000 places

Note:
  1. 1/phi, 1/phi^2, 1/phi^3, ... forms Fibonacci Numbers

  2. Formula for the geometrical series for this:
    (((1 / phi) * (1 - ((1 / phi)^n))) / (1 - (1 / phi)))

  3. phi+1, (phi+1)^2, (phi+1)^3, ... also forms Fibonacci Numbers




Saturday, November 25, 2006

Try Exploring Vector in Hexagon and Heptagon with Excel

Try exploring Vector in Hexagon and Heptagon with Excel.
Excel Vector Trigonometry is launched today to show how to use Excel to make calculation for vectors with trigonometry.
- November 26, 2006 -

06/12/14
"<-0.5: The minimum inner product with T, O, B, all on the circle with radius 1>" is shown on the spreadsheet at "Vector in Hexagon", Excel Vector Trigonometry.

06/12/21
"<4: The maximum inner product with T, O, B, all on the circle with radius 1>"


Thursday, November 23, 2006

Vector in Octagon


sqrt(2) - sqrt(8 * (sin(22.5 degrees)^2) * (1 - cos(135 degrees)))
= 0


It shows that the length of the shortest diagonal line of an octagon inscribed in a circle with radius of 1 is square root of 2. How cosine formula and inner product work with vectors in octagon is demonstrated in my spreadsheet.

'Vector in Pentagon' was added to my spreadsheet to calculate magnitude of vector on the diagonal line of a pentagon which is a side of pentagon times phi. (06/11/25)

Monday, November 20, 2006

Phi Figures

(5 / (1 / the golden ratio)) - (5 / the golden ratio) = 5

(10 / (1 / the golden ratio)) - (10 / the golden ratio) = 10

"Phi Figures" - a set of figures calculated with phi
and trigonometric function - is added on this spreadsheet.
- November 21, 2006 -





Monday, November 13, 2006

Exploring Phi-by-Phi Squares with Excel Trigonometry

((phi^3)^2) - ((phi^4) + (phi^5)) = 0 is an exmple of how phi^n makes the Fibonacci Sequence - phi^n=phi^n-2+phi^n-1.

Excel is used to show how multiplied phi-by-phi squares are analysed. The phi^2-by-phi^2 square has an area of phi^4.
Phi^4 is equal to: 1 + (4 * (1 / phi)) + (6 * (1 / (phi^2))) + (4 * (1 / (phi^3))) + (1 / (phi^4))). They can be broken down to smaller squares:

phi^3-by-phi^3 "Golden Square", 4*1/phi^2 squares, and 4*1/phi-by-(phi^2-1/2*phi) rectangles


Excel Trigonometry





Tuesday, November 07, 2006

Exploring Pi with Trigonometry

Trigonometry that seems to have nothing to do with circles or anything having no angles does work in measuring tangent pi on angles on triangles with an area equal to or twice as large as that of a circle and having angles with pi or 2*pi in tangent.

pi-tan(72.343212845degrees) - Google Search -


My Excel sheets show how calculation was made and the relevant trigonometric function.

Excel Trigonometry