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.