Details for putting your data into meinedata/mellanrummet

When we started building meinedata, one of the aims was for the data to be reasonably editable by those who care about their owns bits of data.

Now available is a converter which takes an excel spreadsheet and turns it into the xml required by the flash code. This allows anyone to put their data into the system (and since it's all freely available, you can do it on your own websites.

Some notes about the spreadsheet follow.

• The spreadsheet consists of a top (first) sheet and one or more data sheets. All points to be plotted must be listed in the top sheet.
  
  
• Data sheets must have names. Each sheet contains a series unless the sheet name begins with the word "variable", in which each column is treated as separate variables. There can be multiple sheets of both varieties. Sequence sheets have the entryid in the column headers. Empty cells are treated as missing.
  
  
• Cell A1 in sequence sheets should be the full, displayed, name. All other cells in Row A and all cells in row 2 in all worksheets are reserved and should be empty.
  
  
• Column headers are on row3 of each worksheet.
  
  
• Column A of all data sheet must match an entry in column A or B of the first worksheet, otherwise they will be ignored.
  
  
• The column order in the topsheet must match the order in the examples. All columns must be present and should be filled with the exception of Column A.
  
  
• Column A in the topsheet is not displayed, but is used as a second field to match against if the name in a data sheet doesn't match in Column B. This allows you to use reference codes/identifiers in data sheets and still match against user friendly names. Column A in the topsheet is therefor optional.
  

If the above rules don't match the example spreadsheets, the examples are right (and tell me so I can fix the above).