How do I export NMS scores into Excel?

[sarah...@gmail.com]

I need to export the NMS scores in the .gph file (or any of the PCOrd file formats, for that matter) into Excel. I have done this in the past and I remember it was difficult and non-intuitive but I cannot figure it out again. I am using PC-Ord 5.33. Any help is appreciated.
Thanks, Sarah.

[Peter Nelson]

Hi Sarah,

I usually just copy and paste the contents of the .gph file into a
.xls. I then use Data> Text to Columns, choosing "Delimited" and
"Space" to get each axis in a separate column. Hope that helps.

Peter R. Nelson
PhD candidate
Department of Botany and Plant Pathology
Cordley Hall 2082, Oregon State University
Corvallis, Oregon 97331-2902
Phone: 541-231-5584
http://peterrnelson.weebly.com/

> --
> You received this message because you are subscribed to the Google
> Groups "PC-ORD" group.
> To unsubscribe from this group and stop receiving emails from it,
> send an email to pc-ord+un...@googlegroups.com.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>

[Bruce McCune]

Sarah, Peter's method works, but it's even simpler than that. When you are looking at the graph, choose
File | Save scores as | spreadsheet

-Bruce McCune

At 07:42 AM 6/14/2013, you wrote:

I need to export the NMS scores in the .gph file (or any of the PCOrd file formats, for that matter) into Excel. I have done this in the past and I remember it was difficult and non-intuitive but I cannot figure it out again. I am using PC-Ord 5.33. Any help is appreciated.
Thanks, Sarah.

[sarah...@gmail.com]

Thank you so much, Peter and Bruce. You have no idea how much headache you have saved me (or, more accurately, my technician).
Sarah.