Skip to main content
19-Tanzanite
March 25, 2024
Solved

How to automatically extract the range of frequency and how to find the time for maximum values

  • March 25, 2024
  • 1 reply
  • 21751 views

Hi,

Cornel_6-1711377730107.png

Cornel_7-1711377941104.png


1. How can I search for each frequency range?
For example I looked into the excel file and I saw that 1kHz begin from line 61536 and is ended at line 62560:

Cornel_8-1711378288579.png

.
.
.

Cornel_9-1711378316430.png


Therefore I extracted manually the respective range in Mathcad:

Cornel_10-1711378363167.png

Cornel_11-1711378383997.png

Cornel_12-1711378391342.png

Cornel_13-1711378398107.png

Cornel_14-1711378404952.png

 

 

 

So, for example I want to know between what range the 0.001Hz begging and ends, but without staying and looking into excel file, some automatic routine if can be made in Mathcad:

Cornel_15-1711378509511.png

 

And then I want to know the maximum value for Vout and Vin at the respective Frequency and at which time these maximum values are occuring:

Cornel_17-1711378637684.png

Cornel_16-1711378625038.png

Above its only the maximum value at 1kHz, but I do not know at what time these maximum values for Vout and Vin are occuring.

Cornel_18-1711378783328.png

Because I want to know then the difference between t2-t1.

Best answer by ttokoro

Using modified Werner_E's Unuque function.

image.pngimage.pngimage.png

image.png

image.png

image.png     image.pngimage.pngimage.png

image.png

image.pngimage.png

image.pngimage.png

1 reply

Cornel19-TanzaniteAuthor
19-Tanzanite
March 25, 2024

And these two things I want to know:
1. The maximum value for Vout and Vin at each frequency range
2. The time values t2 and t1 when maximum Vout and maximum Vin are occuring for each frequency range

For each frequency range:

Cornel_0-1711379661033.png

Cornel_1-1711379672653.png
and so on..

 

 

 

 

Cornel19-TanzaniteAuthor
19-Tanzanite
March 25, 2024

The spacing between frequencies:

From 0.001Hz to 0.01Hz:
Cornel_0-1711385357113.png
From 0.01Hz to 0.1Hz:

Cornel_1-1711385384730.png

 

 

and so on...till 1e6Hz

Cornel19-TanzaniteAuthor
19-Tanzanite
March 25, 2024

From 0.1Hz to 1Hz:

Cornel_1-1711386046427.png