Spreadsheets

[mightyleemoon]

I had no idea. Thanks for the tip. Seems like Google Docs has the same feature, "Split text to columns". It's grayed out on that sheet. But that might be because it's read only. Might be able to do it if he made himself his own copy.

Yeah...if it's a read only file, you can't do anything with the data without saving it as your own file first. However, what mdb is talking about cannot be done with those CBS Sports sheets. Those are embedded in the webpage and cannot be extracted except as text, html or a screen print.

Here's an example of one of their, so-called, spreadsheets that I think he's talking about:
http://www.cbssports.com/nfl/draft/pros ... s/2017/all

Now, he could copy that data in html format be selecting the text and pasting it directly into an Excel worksheet. It will even keep the hyperlinks that are embedded on the webpage, so if you click on the players name in the Excel spreadsheet, it will jump to the embedded link if you have an Internet connection. Anyway, from there, he could do all the worksheet functions I was talking about above, i.e., split the names into 2 columns (1 for first name and 1 for last name). That would be a lot of work, though, because he'd have to copy/paste every page of which there are 40 pages in the link I posted above.

I copied/pasted the 1st page of data from that website spreadsheet and separated the first/last names into separate columns using the Text to Columns Wizard. Here's what it looks like:

This is the winner.

[Mountaineer Buc]

Once you guys have your datasets, I suggest creating a pivot table.

You can break down the data any way you want.

I will be using it to determine the number of prospects playing in a game, looking at the average height of the corner prospects, etc.

You will have all sorts of options.

[Buc2]

I've never found a need to work with pivot tables, but I'm sure they are a powerful tool if it's something you can use. Anyway, I definitely don't have any experience with them so I can't advise there.

[Mountaineer Buc]

I've never found a need to work with pivot tables, but I'm sure they are a powerful tool if it's something you can use. Anyway, I definitely don't have any experience with them so I can't advise there.

Categorization is the best use.

In accounting, I would use them to show all the transactions of a monster datasdataset by several means. By code, by month, etc.

If you take your big board and put it in a pivot table, you can pull up every corner from a power 5 conference over 6'1.

The more you play with it, the more you can break down the data.

[NYBF]

The more you play with it, the more you can break down

And go blind.

[Mountaineer Buc]

The more you play with it, the more you can break down

And go blind.

My palms are too hairy to hide.

[PrimeMinister]

I've never found a need to work with pivot tables, but I'm sure they are a powerful tool if it's something you can use. Anyway, I definitely don't have any experience with them so I can't advise there.

Categorization is the best use.

In accounting, I would use them to show all the transactions of a monster datasdataset by several means. By code, by month, etc.

If you take your big board and put it in a pivot table, you can pull up every corner from a power 5 conference over 6'1.

The more you play with it, the more you can break down the data.

I've never used this, but I'm building spreadsheets for work now and this will come in handy.

[A Man's Part]

I used to think excel was the **** for data computation and analysis.


Then I discovered python.



Ok. There's my spreadsheet bump to keep this up top.

[PrimeMinister]

I used to think excel was the **** for data computation and analysis.


Then I discovered python.



Ok. There's my spreadsheet bump to keep this up top.

Never heard of python.