[wdmmg-discuss] DATA MODEL

[George Adcock]

G'day,

Google's public data explorer: http://www.google.com/publicdata/home
is working off of Epic's freeware: www.epicsyst.com/trendcompass
Their public data model supports Excel spreadsheet entry in this format:
http://epicsyst.com/trendcompass/ExcelSpecification.aspx?Home=1

   Excel file specification

 1. Data is read by Column from the Excel file. Thus Col "A" will have the
Date, Col "B" will have the X coordinate and Col "C" the Y coordinate.
 2. Every Object needs at least 3 Columns. So Object 1 is in Col (A,B,C)
then Object 2 is in Col (D,E,F) and so on.
 3. Now we need to enter some descriptions in Rows:
 Row 1 : A1=DATE,B1=VALUE,C1=VALUE for 1st object and
D1=DATE,E1=VALUE,F1=VALUE for 2nd object and so on
 Row 2 : A2=(description),B2=(description),C2=(description) for 1st object
and so on
 Row 3 : A3=(Object Description),B3=(X Axis Title),C3=(Y Axis Title) for 1st
object and so on

Cheers, Steve
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.okfn.org/pipermail/openspending/attachments/20100315/026f393f/attachment.html>