Excel will make a best guess and then you will need to adjust it based on the data layout. For most files sent from ITS, the data is set up in single columns. This window is used to set which columns are used for the data. You will be presented with a window similar to the following: Make sure that Fixed width is selected then click next. You should now see a window similar to the following: Under Files of Type select text then select the file you want to open and click the open button. You will see a window similar to the following: Launch your Excel application and select open from the file menu (or the menu that is used to open files in your version of Excel). You will also notice that the first column is not all the way to the left of the screen. In this example the first column is gender (1=male, 5=female), the second column of numbers is age and the third is payscale where 1 is the lowest and 5 is the highest. The file consists of six records from a fictional survey on pay equity. The following is an example of ASCII data. Most programs like SPSS or Excel are able to work with directly or import text only data. Untitled Document Working with Data supplied by ITSĪll data received from ITS is in a specific format called column oriented text or ascii only data.
0 Comments
Leave a Reply. |