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...

thanks for your suggestion though,

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
 
Joined
Oct 5, 2017
Messages
1
Reaction score
0
upload_2017-10-5_16-28-14.png


upload_2017-10-5_16-33-17.png


upload_2017-10-5_16-33-38.png



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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top