Input Data Format

perSimplex supports the generally known CSV (Comma Separated Values) format. The data in this format can be prepared virtually in any software environment and transferred without problems between different platforms.

CSV format is a text format where each row corresponds to one curve and the individual numeric values are separated by the mean of comma or semicolon. Therefore, the perSimplex product input is the only file with CSV suffix, in which are the data for the curve diagram plotting.

image002

Fig. 1 Input file with CSV format (Comma Separated Values)

Also the well-known table processor Excel included in the Microsoft Office package supports the files with CSV format. Basically, the input file is a simple table of numerical values, where the names of the individual columns are in the first row and the row identifier in the first column of each row.

The Fig. 1 shows an example of input file, dealer.csv, which can be found in the SimplexManual\sample directory. The file contains 100 rows; each of these rows contains fictitious data on the activities of one dealer from January 2001 to December 2002. This means that for each dealer, the file contains 24 values in columns called I-01, II-01, …, XII-02. The dealer’s name (Alison, Anna, Brenda, …) in the first column called “NAME” is the row identifier. Let’s assume that the numeric values are certain evaluation of the successfulness of the dealer during the given month.

image004

Fig. 2 dealer.csv input file read in MS Excel

If you already have some real input data in the file with XLS (Excel) format, then you will save simply this file from Excel directly as CSV (Save as). If the data are contained in your information system, you may export them to CSV directly.

This Manual includes several demonstration examples, which explain the method of work with perSimplex product. One of them is the example with data on persons. For full understanding of CSV format, you may create the people.csv file with the following data: name, height, mass and age. For the file creation, you may use, for example, the Notepad text editor, in which you will enter and save, for instance, the following rows:

  • Name,Height(cm),Mass(kg),Age
  • Alison,171,59,34
  • Anna,170,54,42
  • Brenda,162,53,32
  • Brian,154,69,45
  • Brigitta,162,63,43
  • Britney,167,59,33
  • Carole,180,70,40
  • Clare,176,77,44
  • Claudia,168,58,43
  • Cory,163,50,32
  • Debbie,168,78,43
  • Denise,175,67,29

If the file cannot be generated, you will find it in the SimplexManual\sample directory.