Nice implementation. Your spreadsheet makes a nice example of the possibilities. I also found a few sample spreadsheets with a google search. Thanks again. cb
On Feb 26, 4:12 pm, George Adams <[email protected]> wrote: > Christopher, > I have an example here,http://www.hayriverti.org/local-directory-map, of > a map but not a timeline that uses a Google spreadsheet. I am no expert > with this and the page does not use the latest Exhibit code. > The spreadsheet was set up originally as a Google Form so sheet 1 is the > information that local merchants submit. > The header row is as follows > Timestamp Business Name Contact Name Product Address City State Zip Phone > FAX email web Image Description > The Timestamp column is added by the form generation code. > > I made a second sheet, sheet 2, that has the following header row. > {label} {Name} {Product} {Address} {City} {State} {Zip} {Phone} {FAX} > {email} {web} {Image} {Description} {LocationLookup:LatLng} {id} > {Location:LatLng} > The second sheet is populated for the most part by data from the first > sheet using =ARRAYFORMULA(Sheet1!B2:B1025) This copies row 2 on down from > the first sheet to the second. The Timestamp is not copied. The ID column > is filled in with =ARRAYFORMULA(Row(2:1025)) which put the number of the > current in the ID column. This allows for a unique ID for each row. > I wrote a Google spreadsheet script that uses Maps Geocoder to fill in the > LocationLookup column based on the Address City State and Zip. It seems > that this lookup is done each time the spreadsheet is opened including when > it is accessed by the web page. Sometimes these lat long values are empty > when trying to display the map so I added the Location column. I manually > copy the value in the LocationLookup and do a Paste Special>>Values Only to > get a static value in that column. The LocationLookup is populated with the > formula =ARRAYFORMULA(getLatLongRange(D40:G225)) where getLatLongRange is > the name of the script I wrote. > Note that the column names in the second sheet are in curly brackets and > the Business Name has been changed to {label} > > You can view the source of the frame where the map is displayed. The web > page is a Google Sites web site so I had to jump through some hoops to get > it to work as I couldn't add code the page <HEAD>. > > The web form to add information to the map is a link on the map page or > this URLhttp://www.hayriverti.org/local-directory-map/directory-sign-up-2 > I do have the form set to email me of any additions so I can do the manual > copy and paste action and edit the entries if needed. > > I just change the permissions on the spreadsheet so anyone with a link can > view it. You can see the formulas but not the script. If that is of > interest I can email it to > you.https://docs.google.com/spreadsheet/ccc?key=0AkgOV8gxmgPadFpENkNmZ2xI... > > I haven't done anything with dates or times with the Google spreadsheets so > someone else will need to help out with that. > George > > On Sat, Feb 25, 2012 at 11:14 PM, alphabravo > <[email protected]>wrote: > > > > > > > > > Hi all, > > > I am looking for an example Google Spreadsheet that is suitable for > > events referenced by the Timeline Widget. Can someone post a link to > > one I can start from just to see the format and headers and such? > > > Also can I create a spreadsheet that will work with both the Timeline > > Widget and also the TimeMap Widget??? I am guessing the lat/lon fields > > would just be blank for events with no location. > > > Thanks in advance. > > cb > > > -- > > You received this message because you are subscribed to the Google Groups > > "SIMILE Widgets" group. > > To post to this group, send email to [email protected]. > > To unsubscribe from this group, send email to > > [email protected]. > > For more options, visit this group at > >http://groups.google.com/group/simile-widgets?hl=en. -- You received this message because you are subscribed to the Google Groups "SIMILE Widgets" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/simile-widgets?hl=en.
