Hello experts
I need some help to make something that will make my daily work easier.
First off all I do not know if that is possible, but if that will became possible then I will be very apreciate to all of you.
What is the problem?
I have some csv file which contains some data. From that csv file I want to extract some data that are important for my results.
What is in the csv file?
Here we can find some data from 3 intvervals.
Intervals are marked in that syntax:
Interval and data points: 1 10
Interval and data points: 2 100
Interval and data points: 3 100
I will need to extract data from Interval and data points 2 and from Interval and data points 3.
What data I need from Interval and data points 2 and from Interval and data points 3?
I will need results from 2 specific columns. Column Shear Rate[ 1/s] and Column Viscosity[mPa·s]
Every point of shear rate[ 1/s] gives the results for Viscosity[mPa·s].
I will need results from column Shear Rate[ 1/s] at specific points of shear rates. In my case I will need 3 points of Shear Rate[ 1/s] for my both intervals. My objective is to get the results for viscosity at specific shear rates.
From interval 2:
Interval and data points 2
Point:20 Shear Rate[ 1/s]= 100 Viscosity:?
Point:40 Shear Rate[ 1/s]= 200 Viscosity:?
Point:60 Shear Rate[ 1/s]= 300 Viscosity:?
From interval 3:
Interval and data points 3
Point:41 Shear Rate[ 1/s]= 300 Viscosity:?
Point:61 Shear Rate[ 1/s]= 200 Viscosity:?
Point:81 Shear Rate[ 1/s]= 100 Viscosity:?
How I am doing that now?
Now I am doing that manually.Opening one file by one ...looking for correct interval and coyping the correct data from specific shear rates and then copying that to another excel table. Closing the prevous file and looking for another file..then again copying the results closing and again..
What I want to manage?
I want to manage: with your help to create some macro- some excel macro-macro that will allow me to so select multiple csv files and then automaticly extract the data points I want in another excel worksheet.
I need some help to make something that will make my daily work easier.
First off all I do not know if that is possible, but if that will became possible then I will be very apreciate to all of you.
What is the problem?
I have some csv file which contains some data. From that csv file I want to extract some data that are important for my results.
What is in the csv file?
Here we can find some data from 3 intvervals.
Intervals are marked in that syntax:
Interval and data points: 1 10
Interval and data points: 2 100
Interval and data points: 3 100
I will need to extract data from Interval and data points 2 and from Interval and data points 3.
What data I need from Interval and data points 2 and from Interval and data points 3?
I will need results from 2 specific columns. Column Shear Rate[ 1/s] and Column Viscosity[mPa·s]
Every point of shear rate[ 1/s] gives the results for Viscosity[mPa·s].
I will need results from column Shear Rate[ 1/s] at specific points of shear rates. In my case I will need 3 points of Shear Rate[ 1/s] for my both intervals. My objective is to get the results for viscosity at specific shear rates.
From interval 2:
Interval and data points 2
Point:20 Shear Rate[ 1/s]= 100 Viscosity:?
Point:40 Shear Rate[ 1/s]= 200 Viscosity:?
Point:60 Shear Rate[ 1/s]= 300 Viscosity:?
From interval 3:
Interval and data points 3
Point:41 Shear Rate[ 1/s]= 300 Viscosity:?
Point:61 Shear Rate[ 1/s]= 200 Viscosity:?
Point:81 Shear Rate[ 1/s]= 100 Viscosity:?
How I am doing that now?
Now I am doing that manually.Opening one file by one ...looking for correct interval and coyping the correct data from specific shear rates and then copying that to another excel table. Closing the prevous file and looking for another file..then again copying the results closing and again..
What I want to manage?
I want to manage: with your help to create some macro- some excel macro-macro that will allow me to so select multiple csv files and then automaticly extract the data points I want in another excel worksheet.