Add external File data only to certain Date in calc

[chairborne_1]

Hello guys, so here is what I’d like to know but didn’t figure out yet.

So I have Data from an external .csv File which I also have managed to implement into calc.
My Problem now is that I have a calc table sorted by Date, the Sensor is basically counting rotations and counts up to 1 every 75 Rotations, then two the other 75 Rotations and so on, so the .csv File is basically just counting up. Is there any possibility to implement a solution to assign the value at a certain clock time to another Field?

[Lupp]

I’m afraid I’m not the only one not understanding the description.
Please clarify:

You have one sheet to which data from a csv get imported? Manually?
You have another sheet logging sensor data with a time stamp every second?
You want to combine logged data with imported data? By formulas? By user code? manually?

How do I manage to only write for a specific date and then continue it the next day in another column for the according date?

This doesn’t make sense to me. Importing additional data daily into next column (if I read this correctly) is a very bad idea.

Please upload an example file showing clearly what you have and what you want to get.

How do you want to handle the fact that a year has 365 days and a day has 86400 seconds?
There is an amount of data soon no longer manageable in a spreadsheet.document.

[chairborne_1]

The Sensor is basically counting rotations and counts up to 1 every 75 Rotations, then two the other 75 Rotations and so on, so the .csv File is basically just counting up. Is there any possibility to implement a solution to assign the value at a certain clock time to another Field? For example at 00:00h of day one counting then stop at 24:00h and start at another field.