Chapter 39. Importing data from a text file or document
Question answered in this chapter:
How can I import data from a text file into Excel so that I can analyze it?
Jeff Sagarin, the creator of the USA Today basketball and football ratings, and I have developed a system to rate NBA players that has been used by several NBA teams, including the Dallas Mavericks and New York Knicks. Every day during the season, Jeff’s FORTRAN program produces many bits of information, including ratings for each Dallas Mavericks lineup during each game. Jeff’s program produces this data in the form of a text file. In this chapter, I show you how you can import ...