Skip to content

Data Export - wrong data types for timestamps (dates) and all other values (rpm, bar, °C, W,A,etc) #1002

@MilanVDB

Description

@MilanVDB

When exporting the Data, everything is a text datatype, except for the "Dates"
The Timestamps include date and time but only show time since it is in the wrong data type
Instead of 6.12.2025 14:32:16 it is just 06.12.2025
Video Describing the Issue here:
https://youtu.be/nz5QGZ4HH70

Rename the columns Value (#) to just the value with the sheetname
Example for Nozzle : Value(°C) -> Nozzle °C
Value (W) -> Nozzle W

All Data given in different sheets. The names are not good. Call them Nozzle Stats and for the Data sheet "Nozzle Temp, Watt"
Image
Nozzle Stats
Nozzle Data -> Nozzle Temp, Watt
Front Stats
Front Data -> Front Temp, Watt
Middle Stats
Middle Data -> Middle Temp, Watt
Back Stats
Back Data -> Back Temp, Watt
Total Stats -> Total Watt Stats
Total Data -> Total Watt
Series 1 Stats -> Ampere Stats
Series 1 Data -> Ampere
Series 1 Stats_1 -> Bar Stats
Series 1 Data_1 -> Bar
Series 1 Stats_2 -> rpm Stats
Series 1 Data_2 -> Rpm
New: Auswertung
Rest should only exist in given data sheets, as explained below.

Change the sheets to this, now as example for nozzle:
one sheet for Nozzle Temp, Watt
column A: Timestamp
Column B: W Nozzle
Column c: °C Nozzle

Use one sheet for Nozzle Stats
put the columns from the other sheet in columns E and F

Add one more sheet that is called "Auswertung". This should include all data from the sheets with a diagram

Timestamp | Bar | rpm | Temp Front | Temp Middle | Temp back | Temp nozzle | Total W | W front | W middle | W back | W nozzle

x Achsis should be used for timestamp (should show time) if it is not working with time then just use seconds

See the diagram below. it should look like this:
For the Heading you use the name of the excel and the timestamp with beginning time "bis" time end

Image

Include all target data like Temperature, rpm and or bar that where typed in by the user
-> so that we know when the information was entered and how long the extruder needs to come to this

Also include comments from user in the next free column and correct in line with the timestamp. Also include this on Auswertung

Include in the Auswertungs sheet a number of total comments given behind the column with the comments

Add Information about used software

add used PID data for pressure and temperature and make it possible to write comments if not possible by now

Metadata

Metadata

Assignees

Labels

Good First IssueAssign something like this for now people in the TeamLow-PrioLow-Prio Issues can be left unattended for a while.

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions