Unwrap phase

P

Phil Newman

anyone know of a good method to unwrap phase that is wrapped over
180degrees in excel?

cheers

Phil

J

jkend69315

Phil, I'm not sure what you mean by 180 degrees, but one way to keep
phrases from being broken by word wrap is to use non-printing
characters between the words instead of spaces. This works for me (I'm
using Arial font): Select one of the spaces you want to replace.
Click Insert on the menubar, then Symbol. Scroll down until you see a
blank square. Click on it to select it. Then click Insert, then
Close. Then press Enter to exit the edit mode. This should prevent
the phrase from breaking where you put the non-printing character.
HTH, James

P

Phil Newman

my phase data is being wrapped over by 180degrees. the data is in a
column format, and the format of the data has nothing to do with the
problem. it is a mathematical problem. once the phase data exceeds
+/-180degrees it "wraps" around to the other polarity, ie, phase that
goes 178 179 180 -179 -178 instead of 178 179 180 181 182...

Phil

B

Bernie Deitrick

Phil,

Perhaps a formula?

=IF(A1<0,A1+360,A1)

copied down to match your data, then do a copy pastespecial values to remove the formulas.

HTH,
Bernie
MS Excel MVP

J

rooster

This is not 100% correct but it was sufficient for my purposes. There are small errors at the shifting points due to digitization (not always exactly +/- 2*pi at the shifts hence the delta control value) If your values hit 2*pi more exactly you may be able to add or subtract 2*pi exactly rather than the jump that is there. The sign of (B6-B5) determines whether it adds or subtracts so you could extract the sign like this: (B6-B5) / ABS(B6-B5) * 2 * pi()
Use that in place of the second (B6-B5) in the shift amount formula and then set your delta very close to 2*pi (rather than the lower number I used (1.6).

Happy phase shifting in Excel...