Difficulty converting the scans to excel plots

• Previous message: Betty Jacobs: "If we put our questions in the subject line we can all see what each message is about"
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]

I tried this yesterday and it worked.

1. Open Excel
2. Click File_Open and open the scan .xms file (it might take a while)
3. A prompt box will appear asking you to select options - you should
select - delimited, next, tick other and put " in the box, next, finish
4. This should put all the data in a spreadsheet. Scroll down to find
it. Don't worry about the mess.
5. Delete all columns except the Frequency values and the Signal
Strength values and make sure these columns are formatted as numbers
6. Put headings on these columns
7. You should then be able to select these columns and create your chart
(graph).

Let me know if this works.

Betty..

--
---------------------------------
Betty Jacobs
Community Outreach Co-ordinator
Faculty of Engineering
University of Technology, Sydney
http://www.eng.uts.edu.au/~betty
Telephone - 9514 2450, Fax - 9514 2611
Email - Betty.Jacobs_at_uts.edu.au
Mail - Room 7074 / Building 2 Level 7
UTS, PO Box 123, Broadway, NSW, 2007
Engineering Links Project
http://www.eng.uts.edu.au/links
SEARFE Project
http://www.searfe.atnf.csiro.au/
--------------------------------

• Next message: Betty Jacobs: "Re: dear Betty"
• Previous message: Betty Jacobs: "If we put our questions in the subject line we can all see what each message is about"
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]

This archive was generated by hypermail 2.1.4 : Thu Sep 12 2002 - 12:13:25 EST