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.

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.

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.

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

Excel Dodecahedrons

    
Excel Father's Day Dodecahedron

- May 17, 2007 - 

    
Christmas Dodecahedron


Thanks Kaboose for clip art.

- December 14, 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 - 

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

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.

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

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

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

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)

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 -

Phi^10-by-Phi^10 Rectangle and Progressive Difference

(phi^20) - (1 + phi + (phi^3) + (phi^5) + (phi^7) + (phi^9) + (phi^11) + (phi^13) + (phi^15) + (phi^17) + (phi^19)) = 0 *1 *2 shows how I am going to theorize my "Phi-by-Phi (Golden) Rectangle" with Excel Trigonometry.

Excel, Google and websites like Virtual Library of Useful URLs - Fibonacci Numbers and the Pascal Triangle, which will be referred to from time to time, will help beginners like myself further explore the golden ratio and Fibonacci Numbers.

*1 06/11/18
((phi + 1)^10) - (1 + (phi^10) + ((10 * phi) * ((phi^8) + 1)) + ((45 * (phi^2)) * ((phi^6) + 1)) + ((120 * (phi^3)) * ((phi^4) + 1)) + ((210 * (phi^4)) * ((phi^2) + 1)) + (252 * (phi^5))) = 0

*2 06/11/26
the golden ratio^20 = 15 126.9999

(phi^20) - ((1 + phi)^10) = 0

(phi^10) - sqrt((1 + phi)^10) = 0

the golden ratio^10 = 122.991869

the golden ratio^5 = 11.0901699


Excel Calendar

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

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

Phi-by-Phi Square

I have tried to use my Excel sheet to make calculation on various angles of the golden rectangle, which is 1 by phi. I have found out that by extending the shorter side from 1 to phi, a phi-by-phi square is formed, and the new diagonal line on the extended area (1/phi by phi) is SQRT(3) and forms tangent 2.61803399.. on the corner, as compared with tangent 1.61803399.. on the corner of the original rectangle.

As there seems to be no naming of this, I would like to call this Golden Square.

Excel Trigonometry

Excel as Decoding Tool

"Study this paragraph and all things in it. What is vitally wrong with it? Actually, nothing in it is wrong, but you must admit that it is most unusual. Don't just zip through it quickly, but study it scrupulously. With luck you should spot what is so particular about it and all words found in it. Can you say what it is? Tax your brains and try again. Don't miss a word or a symbol. It isn't all that difficult.... "

I have tried, first glancing and then staring at it, but could'nt find out how there is something particular or unsual about it. Sarah Flannery, a talented young mathematician and author of 'A Mathematical Journey', says in her book that "anyone acquainted with encoding algorithm should have no difficulty finding an answer."

Here is my spreadsheet designed to verify the answer. It is used to locate the position where any of the alphabetical letter, both small and capital, appears first, if any.

I have then used this spreadsheet to find out if there is something similarly particular or unusual about Samuel Ullman's prose "Youth", which has more than twice as many characters and symbols as "study this paragraph ..".

"Youth" by Samuel Ullman

"Youth is not a time of life, it is a state of mind; it is not a matter of rosy cheeks, red lips and supple knees; it is a matter of the will, a quality of the imagination, a vigor of the emotions; it is the freshness of the deep springs of life.

Youth means a temperamental predominance of courage over timidity, of the appetite for adventure over the love of ease. This often exists in a man of sixty more than a boy of twenty. Nobody grows old merely by a number of years. We grow old by deserting our ideals.

Years may wrinkle the skin, but to give up enthusiasm wrinkles the soul. Worry, fear, self-distrust bows the heart and turns the spirit back to dust.

Whether sixty or sixteen, there is in every human being's heart the lure of wonder, the unfailing child-like appetite of what's next, and the joy of the game of living. In the center of your heart and my heart there is a wireless station; so long as it receives messages of beauty, hope, cheer, courage and power from men and from the infinite, so long are you young.

When the aerials are down, and your spirit is covered with the snows of cynicism and the ice of pessimism, then you are grown old, even at twenty, but as long as your aerials are up, to catch the waves of optimism, there is hope you may die young at eighty."

The result shows that the paragraphs do not contain a z, but they do contain all of the other letters.


Samuel Ullman and "Youth": The Life, the legacy

In Code: A Mathematical Journey


Prose in Pi

Google Spreadsheets

What's New

My Website Excel and Google Spreadsheets
- August 21, 2007 -


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

August 19, 2007



Beijing Olympics Schedule - Google Docs & Spreadsheets


Calendar Template on Google Spreadsheets

August 16, 2007



Here comes, finally or at last for Excel fans who love Google as well, Google Spreadsheets.

Google Spreadsheets - Sneak Peek

To sign in Welcome to Google Spreadsheets

Google Directory - Computers > Software > Spreadsheets > Excel > Add-Ins

Excel Cell Locator

The expanse of Excel, as "spreadsheet" implies, is fully used to store and locate data.

Each cell on its sheet is addressed by the column and row, so it is easy to locate the cell with its address (e.g. A1).

The number of columns on a single sheet is 256 and rows, 65,536.

Excel cell locator - Google Search lists websites giving ideas on how to understand and use "Excell, whoops, Excel cell locator".

Excel Cell Locator