[wdmmg-discuss] DATA MODEL

Rufus Pollock rufus.pollock at okfn.org
Wed Apr 7 08:20:46 UTC 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.

Rufus

On 15 March 2010 21:04, George Adcock <gsaintheusa at gmail.com> wrote:
>
> 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
> _______________________________________________
> wdmmg-discuss mailing list
> wdmmg-discuss at lists.okfn.org
> http://lists.okfn.org/mailman/listinfo/wdmmg-discuss
>



--
Open Knowledge Foundation
Promoting Open Knowledge in a Digital Age
http://www.okfn.org/ - http://blog.okfn.org/




More information about the openspending mailing list