Hey Frank, Another thread of conversation for you .. Can you help me out a bit more with the row 16+. This is where I want to put our data. I can see from the demo sheet roughly how it works but I have some specific questions. 1) What's the "4" all about in row E? Does that somehow tell the system to just use the definition above? What is the relationship between the definitions for the same indicators across different years? Does the system just look at the first year's worth of definitions and apply them to all? Given that I am progammatically generating these rows from our data I do not have to worry too much about duplicating definitions across rows as they will never be changed manually. 2) Sources. Usually a source is associated with an indicator, but it seems like you associate it to the whole dataset. Is that right? My office pulls data together from a bunch of sources and does one of two things: display them verbatim (so the source would be the original) and use them as an input to a calculation that generates our own indicator (so we'd be the source of that). Maybe I'd just have to produce a web page that has all the sources listed on it and link to that huh? Thanks, Andy |
Hi Andy, I'm still looking
Hi Andy,
I'm still looking into the CSV, it should be possible to enable commas in the upcoming version (all of StatPlanet is programmed in ActionScript 3).
Regarding these questions:
1) Yes the '4' means get the definition from row 4. This is optional, so if a definition is re-used it does not have to be duplicated. Row 4 refers to the row number in the sheet 'Import' which is where you normally insert and edit your data.
You are also right about the first year's worth of definitions. The same definition will be applied for those indicators for all years.
2) Again yes, the source applies to the whole dataset. It would be possible to add the option of having a different source for each indicator. But otherwise your suggestion to link to a web-page with all the sources is a good one.
Frank
Post new comment