Export specific data

[vletm]

Lenche08​

Check this sample version
... I tried to solve those 'small'-values 'myway'.
This should work (again) if Your expected values are between 20 & 100.
What was Your challenge with those Frog's?
I added those to same folder and ... seems to work ... hmm?

 

[p45cal]

'myway'.
This should work (again) if Your expected values are between 20 & 100.

And if they're not, as is the case for a shear rate of 500 for example…?
(multiply/divide by 10 until in range?!? - tsk tsk)

 

[vletm]

p45cal​

... so far those shear rates has none decimals ...
Just now, it 'take care' only Viscosity-values.
BUT there should be other way to do this ... that's true.

I found one other way

Workbooks.OpenText FileName:=f, DecimalSeparator:=",", ThousandsSeparator:=" "

For me the result looks same as before
but those csv-file output looks 'better'.

Lenche08​

Do those values look now correct?
There should be a chart too ... or how?

 

[p45cal]

And if they're not, as is the case for a shear rate of 500

OK, read:
'And if they're not, as is the case for the viscosity values when the shear rates are 500.'

Those viscosity values are around "19,57” in the CSV file (from what I can remember) which comes out as 195.7 (one hundred and ninety five point seven) instead of 19.57 (nineteen point five seven) in your solution.
(I'll add a picture when I get in front of a computer)

 

[vletm]

p45cal​

Okay, I found Your point
There were no challenges with 'Shear Rate'-values.
There were challenges with 'Viscosity'-values.
... which should be between 20...100 ... which is not true ( There are smaller value than 20 ).
BUT
With my the latest version ... I've other solution for those values than *10 or /10.

 

[p45cal]

I found one other way

Workbooks.OpenText FileName:=f, DecimalSeparator:=",", ThousandsSeparator:=" "

Now we're talking.
Much better! Much more robust.
I knew of Workbooks.OpenText but hadn't explored the arguments available; definitely something worth remembering.
Now to get those date/times into Excel date times!

 

[Lenche08]

Hello experts
I am finally home today and now I will get into my problems and your solutions.

Message for Expert001 p45cal
I get some erorr message? What could be wrong? I try it with my files and I get empty results. no results.



Message for Expert 002 vletm
That seems perfect. I test different shear rates and is working perfectly. Dates are correct, results are correct. Decimals and numbers are correct. Very veryy goood.
I dont need chart becose I have live image moving and creating charts when I perform that measurments.



for Vletm

There were challenges with 'Viscosity'-values.
... which should be between 20...100 ... which is not true ( There are smaller value than 20 ).

With that I mean that must be numbers, smile numbers. like 20 or 100 .not 20.000.....maybe I say that wrong and make confused you. I am sorry.

So my experts?
One question more? Was that very difficult to make? Was that a difficult chalenge to make?

I am without wordssss...you make solution for me in les than 24 hours. I am so happy to see that is working.
In which company are you working boys? You are both genius. I asume that you make magic for your cooworkers in daily routine if they have some problems.

Thank you very much.

I will make some testing more to see if everythink is working...with another csv files, another intervals and so on.
PS: I am total amatour for creating somethink like that? but is that difficult to make? If you will have time can you show me how you make that? where is the code hidden?

Thank you so much again.

 

[Lenche08]

Challenge with frogs was that were only two intervals. In another example with ball we have 3 intervals.

 

[vletm]

Lenche08​

Your I dont need chart...
it's there now, it depends ... what are You looking for? ... do it matter if there are 0.001 difference or 1000?
... am I lucky that I did just add only one chart?

Your #35 reply about 20...100

Your One question more?
If something no work and soon it works without any modifications - it makes challenges.
It was possible to solve ... and same time learn something new.
If there are clear and steady master idea, then many things would be smoother to do.
My sample should have as many intervals and shear rates as needs ... of course there should be data for those too.
I could test only with data I've gotten. There could be some variations which makes unwanted results or so.

 

[p45cal]

What could be wrong? I try it with my files and I get empty results.

In all the csv files you've given us so far there has been a column called 'Shear Rate' (a header, about 24 lines down, (in line with 'Interval data:" on the left.)
Was there a csv file in the folder that didn't have such an arrangement of data?

 

[Lenche08]

Hi again
Yes you make all perfect. Are you mathematic guy? Computer guy?

Some queations about the excel final results
If i change the columns shear rate or viscosity? Will the macro still work?
If i delete some line or change the name or move something will macro still work?
Or better
What things I am not alloved to touch?
Thank you

 

[Lenche08]

hi p45cal
no. All my csv files has shear rate. Is strange. Yesterday your file was working and today not. Hmmmmm

My question in post #61 is for you vletm. I forgot to write it

 

[vletm]

Your
Some queations about the excel final results
If i change the columns shear rate or viscosity? Will the macro still work?
If i delete some line or change the name or move something will macro still work?
Both ifs ... Yes, but the result could be unwanted
Or better
What things I am not alloved to touch?
Your datas layout should be as You've shown to us.
As I've already, written - there are already some variations - those should be okay.
Any code 'works' as it has written - it can be very sensitive.
It's possible to modify code which has more variations ... but those should be know.
There could add options which makes it more smoother to use and get needed results.
Eg there should be note, if something is missing.

 

[Lenche08]

Ok thank you for your explanation.

 

[vletm]

Lenche08​

I continue with some tests ...

There are two sheets for use:

Init:
# [ DeSelect ] - clears selections
# [ Get Files ] - shows ALL possible files in that folder ( ~ You can keep all files there )
# [ Final Results ] - to other sheet ... while changing sheet it reads selected files

Usage:
# If there are new files then press [ Get Files ]
# 'Select' one-by-one those files, which You would like to ... manage.
... Managed files are green.
# press [ Final Results ] ... to manage


Final Results:
# [ Init ] - to other sheet
# [ ReStart ] - sometimes ... happens ... then it needs to 'ReStart'

Usage:
# Make selections with 'Intervals', 'Shear Rates' - as many as needed
# Make selection with 'Results' - one-in-time
# Make selection with 'Chart'-mode
After each selection, You'll get refresh results.

'Interval', Shear rates' and 'Result' are 'fixed' ... (so far).

'Chart' shows two different modes ...
... still I don't have clear image - what do You manage?

Maybe something like this would be smoother to use than previous version?

 

[Lenche08]

Hello vletm

Ok I will test also this version. Thank you so much for you work.

meanwhile I find something else I need to export...if you can look...I need the same just that this time I need another values.
I will explain you in next post.

 

[Lenche08]

Hi again
I need the next results:

LVE range- Here we have 2 points but I need only point 1.
Point 1
Values -Shear Strain (%)
Values -Shear stress (Pa)


Yield Point
Point 1
Values -Shear Strain (%)
Values -Shear stress (Pa)



Flow point
Point 1
Values -Shear Strain (%)
Values -Shear stress (Pa)
Storage Modolus (Pa)




See the example in next post.
Thank you very much

 

[Lenche08]

Here are some examples

 

[Lenche08]

I just tested your new version- it is excelent. It is perfect.
Is like I am on the software that create that results not in excel. wowwww
Very very good.
thank you again

 

[vletm]

Lenche08​

Basically same steps with this sample.
... and You can modify it or other versions Yourself.

 

[Lenche08]

Ok i will test it and look and learn how to do it.
Thank you

 

[Lenche08]

I get some error... hmmm
Is working on your site?

 

[Lenche08]

hmmm

 

[Lenche08]

Ohhh
now is working perfectly.


Ok I will do some more testing

 

[Lenche08]

Thank you very much for all your work. Both excels are working correcty.

You make very big work for me.