KML = Cell based Google spreadsheets
Path calculator.

Source
http://spreadsheets.google.com/pub?key=phRmoRD2Q-V_mFA-Tckq7dw

GMaps
http://www.google.com/maps?f=q&hl=en&q=h...e=UTF8&z=5&om=1

Enjoy!

Cities grid

Source
http://spreadsheets.google.com/pub?key=phRmoRD2Q-V8RJKy4zds5ZA

GMaps
http://www.google.com/maps?f=q&hl=en...mp;ll=43.452919,-96.855469&spn=25.367277,59.765625&om=1

Best BBS

Source
http://spreadsheets.google.com/pub?key=phRmoRD2Q-V_xfdNEQhbRKQ

1. Read manual by Gerardo64 (thanks!)
http://bbs.keyhole.com/ubb/showthreaded.php/Cat/0/Number/550183
See Editgrid solution.

2. Prepare need dataset in spreadsheets and assembly all KML file in cell A1.
I use Cell A1 as standard for fast change of datasets.

3. Publish current spreadsheets and see link.
We see near http://spreadsheets.google.com/pub?key=phRmoRD2Q-V_mFA-Tckq7dw

4. Create Network link, open Properties by right click and insert into field Link generated string
( for path calculator it is http://spreadsheets.google.com/pub?key=phRmoRD2Q-V_mFA-Tckq7dw )

5. Add to string "&output=txt&range=a1"
a1 it is cell with generated KML file

6. Check the network Link, add need description and public this. Enjoy.

7. Open http://www.google.com/maps and insert into field Search Maps string Link from Network Link. Press Enter and see results.

8. Press "Link to this page" and see http link. Copy result from http string to need place. Press link and check results. Enjoy two

9. Add source "published" link or place embed spreadsheets in a web page.

10. Check and clean my bad English, prepare best manual, public in BBS.

Thanks.

PS: Generation KML from Google spreadsheets is very fast!
Nice!

Path calculator in blog
http://gisplanet.blogspot.com/2006/12/kml-from-google-spreadsheets.html

1. Press Publish > More publishing options...
2. Select "HTML embed in a web page"
3. Press "Generate URL"
4. Copy-Paste result into HTML of post.

Example of publication in Google Pages.
http://spreadsheetsgis.googlepages.com/pathcalculator2

Current way