# How to generate a new spreadsheet from existing ones [closed]

I need to convert a family of curves for an electronic component into a different family of curves. For that, I use Engauge Digitizer to convert the original curves into several csv files. I found how to import them into calc, one sheet per file, and now I want to generate new sheets from the old ones. For that I must apply some filters.

The goal is to be abble to use it with curves from different manufacturers and different components of that type (vaccuum tubes). The main issue here is that digitizer will give me files with different numbers of columns and rows.

The existing data are for the constant voltage family of curves. I want to transform these datas in order to get the constant current family of curves. It is trivial to make it on a paper sheet, but very time consuming. For each value of current and each wanted new curve, you have to take in account the same point on 3 of the original curves/sheets. But I am new to calc and spreasheets in general, I didn't figured out how I can automatize that.

It will be another calculation from these new sheets in order to generate the parameters used by a SPICE model to simulate these components. But I first need to make these new sheets. Any help or suggestion will be appreciated.

To resume, I will import csv files to create one sheet per file. As Mariosv explain it in the first answer, these sheets will be updated automaticaly. They are by groups of 3, the first sheet is the Ia=F(Ua) curves, the second sheet is the Ig2=f(Ua) curves, and the third one is the Ig1=f(Ua) curves. All 3 have the Ua voltage on the x axys, and a current on the y axys, that for the same and constant Ug2 and different and constant Ug1.

From these, I want to get new curves and their data with the G1 voltage on the y axys, and Ua on the x axys, that for the same Ug2, and different and constant Ig1, Ig2 and Ia. For that, I must take the same point, as example at Ua=300 V on the 3 original curves. First issue, I can have points at 300 V on the first curve, at 299 and 301 V on the second one ...