User manual

The main window has four large buttons respectively with the following features:

1: Models

Choosing a data model

Button 1 of the main window opens the following window:

• A: List of existing models (or templates). The application offers some initial models that can then be deleted, modified or left as is. Double-click on a model is equivalent to clicking the button C.
• B: Button to delete the selected model in the list A.
• C: Button to change the data model selected in the list A.
• D: Button to change the name of the selected model in the list A.
• E: button to create a new model.
• F: Button to create a model from the one selected in the list A.

Buttons C, E and F open the following window:

Editing a model

• A: list of columns (or fields of information) of the selected data model. If the title of the column is checked, it will be visible in the spreadsheets created from the model. Double-click on a title in the list is equivalent to clicking the button D.
• B: Button to add a column.
• C: button to delete the selected column in list A (whether the column is checked or not).
• D: button to change the settings of the selected column in List A.

The B and D buttons open the following window:

Data Types

Depending on the type of data, the number of possible characters in a box in the appropriate column of a data sheet built from the selected model is not the same:

• For an integer or automatic number, 18 digits are possible;
• For a decimal number, 17 characters are possible (including the decimal dot and the possible exponent -- with the letter E);
• For a column of yes-no type, a single character;
• For dates and times, 10 characters;
• And for columns of type text, a box can contain up to 99,999 characters, although this is not recommended for processing duration if all the boxes in the column contained a large number of characters. In practice, for example, in a column for the name of a person or object, 50 or 100 characters are usually more than sufficient.

In addition, each column can be defined initially as visible or editable or not, and requiring filling or not. However, even in a data sheet inherited from a particular model, the data type can always be changed later. But changing the type of a column in a data sheet does not change the corresponding column of the model from which it originated.

2: Spreadsheets

Creating or selecting a data sheet

Button 2 in the main window opens the following window:

• A: List of spreadsheets already created. Double-click on the name of a data sheet is equivalent to clicking the button E.
• B: Button to add a new sheet (created from a data model).
• C: Button to duplicate the data sheet selected in the list A.
• D: button to delete the selected sheet in List A.
• E: button to edit or view the data in the selected spreadsheet.
• F: Button to change the name of the selected sheet.

A click on the B button opens a window for selecting the data model used for the new sheet, and a small window to write the name chosen for this paper.

A click on the C button opens a window for selecting the data model you want more or less completely duplicate, then the following window:

The name of the sheet proposed by default (depending on the duplicated sheet) can be changed.
The derived sheet can be either completely filled (the third option from the window above), or filled with blank lines (depending on the number of rows in the original spreadsheet) or be empty (by only taking the data model of the original sheet, in its current state).

The E button (as well as B and C buttons after preliminary step shown above) opens the following window:

Editing or viewing a data sheet

• A: Area for the column header. Using the mouse, you can perform each of the following on a given column:
• move it by drag and drop, so you can change the order of columns in the table;
• sort it (thus changing the order of rows);
  
• change its width by moving the mouse to the right edge of the column and by holding the left mouse button down to enlarge or shrink the column.
• B: Number of rows in the table.
• C: Selected row in the spreadsheet, here with blue background (according to the color settings of the application).
• D: Other table rows.
• E: Button to add a blank row to the table. Only in case of automatic number, if any, the corresponding cell will be filled (use no more than one column of this type).
• F: Button to delete the selected table row.
• G: Button to save the changes made to the selected row. Note that if the automatic saving option is selected, using this button loses interest in general.
• H: Button to cancel the changes made to the selected row if the window is still reported in edit mode (in which case the bottom left part of the window - with buttons and filter - has a darker background color).
• I: Button to add several rows at once to the table, opening the following window:
  
  If at least one column of type date, the window shows the appearance above.
  One can add at once, for example, a row for each of the 31 days in july in july in the considered year, and this without the need to write the corresponding dates manually. Simply select the Add (...) option, type 31 in the box for the number of blank rows with date(s), and also select the option for date series beginning (...), and finally write the date 2013-07-01 (or 01/07/2013, according to the format for dates).
  However, if no column is of type date in the sheet, instead of the rectangular area to add a number of blank lines with date(s), there is the option to add blank lines (with no dates).
  This window also allows you to copy one or more times a block of rows into (and from) the table. This may be usefull when one needs a lot of similar data rows, knowing that it is easier to modify some data from those added blocks than to fill a corresponding number of added empty rows.
• J: Button to delete several rows of the table all at once or to clear there contents, opening the following window:
  
• K: Button to change the name and type of columns (this does not affect the original data model).
• L: Selecting a column after which you want to filter the data in the table or make a search.
• M: Criteria used to filter or search.
• N: Value which is compared to each cell of the column for filtering or searching.
• O: Button to search in the grid, depending on what was selected in L, M and N.
  Example: with the data in the above image of the spreadsheet: If in L the Rising time column is selected, if in M "Starting with" is selected, and if in N "08" is written (without the quotes), then clicking on a the O button select the row number 3 (Rising time = "08:20:00"). Another click will select line 6.
• P: Button to filter the data in the spreadsheet, depending on what was selected in L, M and N.
  With the same values as in the previous example for L, M and N, a click on the P button would display two rows to the table: the three and six current.
• Q: button to create a printable book (HTML document that can be read by Internet Explorer) from the data sheet, as seen in the table.
• R: Button to add the data table into an already created a book.
• S: Button to create a chart from data sheet (or table).
• T: Area recalling the names of the columns.
• U: Area for the value of each column for the selected spreadsheet row. One can edit the data here as well as in the table itself.

The S button opens the following window:

Graphics

• A: Menu offering different possibilities (exporting the graph, zoom, tips, appearance, etc..).
• B: Area for selection of one of the nine chart types.
• C: Chart title (by default it is the name of the sheet used to create it).
• D: Area for any subtitle used in the graph (by default, the filter of the spreadsheet is included).
• E: Different options depending on the type of chart.
• F: Small text reminder.
• G: Area to display the coordinates of a point on the graph for certain types that allow it. A click on the graph then shows you the coordinates (X, Y) and corresponding values.
• H: Columns that may possibly be seen in the graph. A selected column will be taken into account (if possible) in the graph. Some charts do however take into account a limited number of columns (in which case the additional checked columns are useless).
• I: Chart itself.
• J: Data grid about the graph (in the case of the standard curve) or area with slider to modify the labels orientation on the horizontal axis (if the chart type is appropriate).

3: Books

A click on the button 3 of the main window opens the following one:

• A List of books already created.
• B: Button to delete the selected book in list A.
• C: Button to change the name of the selected book in list A.
• D: Button to see the contents of the selected book, with an Internet browser.
• E: Button to convert the selected book to a PDF document.
  Note that the resulting appearance may be more or less beautiful and readable according to the chosen style when creating the book (see the Tools section) and to the size of the table (especially the number and contents of the columns).
  

0: Tools

A click on the 0 button on the main window opens the following:

The seven window buttons respectively allow the following features:

Basic parameters of the application

This window is also open on the first launch of the application. It defines the default language (english or french), the time format to display, the date format to display, as well as the automatic saving (or not) of modified data.

Color configuration interface

• A: Area for definition of the different components of the application taking into account the color settings.
• B: Area of current colors for these components. A click on one of the colored rectangles opens the color selection window.
• C: Area for visualizing components, taking into account the current color selection.
  Note that if a background color is indicated for buttons, it may be ignored in some systems or used for anything other than the background (eg the border). It may be the same for other specific components.

Styles

• A: Area for viewing the style (The effect may be slightly different in a Web browser and here the shading of a title does not appear when there is one.).
• B: Drop-down list to select the default style. Initially, only two styles are provided. They can be modified or deleted. To rename one, select it, and then create a new style and save it under the new name you want. Then delete the original style.
• C: Button to create a style from one selected.
• D: Button to delete the selected style.
• E: Button to save the changes of the selected style.
• F: Button to cancel the changes.
• G: Area to select one of five basic elements considered in the style (Title, normal text, table title, etc..).
• H: Parameters that may be changed for the considered style element.

Importing a CSV data file

A click on the Import button in the Tools window opens this following one:

Selecting a CSV file then opens the following window:

• A: Drop-down list to select the field separator (comma, semicolon or tab).
• B: Drop-down list to select the text delimiter (double quotes, single quotes or nothing).
• C: Checkbox to select if the first line of the file contains the field names. Do not check otherwise (if the file only contains rows of data).
• D: Small reminder text when needed.

Note that for good representation of special or accentuation characters, you should use a CSV file encoded in UTF 8.

Data backup

A click on the data backup button in the tool window allows to perform a backup as ZIP file archive. To retrieve the data, then just unzip the file and replace the application files and directories from the equivalent of the archive. Such recovery should occur only if serious data corruption make the software unusable.

Help

This assistance.

Tips

A list of tips about the software features.