manipulating array of data

[guidance microwave]

X_Value	Voltage - Dev1_ai0
0	2.47051
4.55E-05	2.468536
9.09E-05	2.475117
0.000136	2.471169
0.000182	2.475446
0.000227	2.473143
0.000273	2.473143
0.000318	2.469523
0.000364	2.468865
0.000409	2.470181
0.000454	2.470181

Hi, i dragged my signal from signal viewer into microsoft excel and i was given the above data (above is only a sample). i need to find a way of converting the x-data from freq to range. i have the formulae to do it - but i have not a clue on where to start. n e help would be great thanks.

[muks]

Use a read spreadsheet.Get the data into a for loop(index enabled) . Use your formula and get the out put.

[guidance microwave]

what do u mean a read spreadsheet?. read-only?

the formulae i have to convert freq to range is

range = freq*c*dT/(2*dF)

where:

c   = 3*10^8

dT = 0.02

dF = 66*10^6

How do u do index enabled?

do u know how to do for loops in excel?

[muks]

Why dont you continue in the original thread? You were getting the replies right?

[guidance microwave]

hi, no i wasnt getting any replies. 😞

[muks]

What do you mean by no replies. that thread is two page long remember. Be patient and continue in the same thread. Instead of starting a new thread you can give an elaborate explanation of what you want there to get it solved.........