[wdmmg-discuss] DATA MODEL
rufus.pollock at okfn.org
Wed Apr 7 09:20:46 BST 2010
Thanks for sending this over George. Are you suggesting this as a
standard interchange format for us to use.
As I understand it from what you've enclosed below, the spec is
oriented to 2d time-series data -- or am I missing something.
On 15 March 2010 21:04, George Adcock <gsaintheusa at gmail.com> wrote:
> 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
> wdmmg-discuss mailing list
> wdmmg-discuss at lists.okfn.org
Open Knowledge Foundation
Promoting Open Knowledge in a Digital Age
http://www.okfn.org/ - http://blog.okfn.org/
More information about the openspending-discuss