PsychoTableTool is a program to convert tables that was generated during some experiments.
PsychoTableTool was build 2024 by Kristian Schultz k.schultz@mail.de. It is free to use. See LICENSE for details.
Here you have the option to select a "patient <-> script mapping" or to calculate the mean in a table.
You may click on the buttons or drag a file from your file-explorer to the according button.
Here you can select a patient. The according scripts will be set for the table conversion. You will be lead to the file selection page.
Here you select the tables to convert and the destination folder. You may click on "Datei Auswählen" and then select the file using the "Open file dialog" or drag a file from your file-explorer to the according button.
When you have selected all files and the destination folder click on "start".
In the destination folder will be created this files:
After clicking the button Mittelwerte Berechnen you may select a ".xls" file or a ".csv" file. The CSV file need to have a semicolon ";" as field separator.
The program calculates the mean and saves the result as: file-name_Mittelwerte.csv
The input file needs this columns to be present:
When present this columns will be used to create this values:
Empty cells will be ignored and don't count in to the mean. When two columns are needed in the input both values have to be present for this row to count for the mean.
For each calculated mean there will be two rows present:
After clicking on Tabellen vereinigen you get to a screen where you can collect tables in a list. By clicking on Hinzufügen you may add existing tables. You may also add them by dragging the files from a file browser in to the white area. You can reorder the files by dragging them around in that window. When you click on Speichern you can give a destination file name.
The tables will merged in the destination table the uppermost first. The first line in each source table will be used as heading. Each column heading has to be unique per table. All headings will merged and put in the first line of the output table.