Page 2 of 2

Re: Spreadsheets

PostPosted: Tue Jun 06, 2017 6:58 am
by mightyleemoon
Buc2 wrote:
NYBF wrote:
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:

Image


This is the winner.

Re: Spreadsheets

PostPosted: Tue Jun 13, 2017 9:31 am
by 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.

Re: Spreadsheets

PostPosted: Tue Jun 13, 2017 10:05 am
by 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.

Re: Spreadsheets

PostPosted: Tue Jun 13, 2017 1:41 pm
by Mountaineer Buc
Buc2 wrote: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.

Re: Spreadsheets

PostPosted: Tue Jun 13, 2017 2:42 pm
by NYBF
Mountaineer Buc wrote:The more you play with it, the more you can break down


And go blind.

Re: Spreadsheets

PostPosted: Tue Jun 13, 2017 2:44 pm
by Mountaineer Buc
NYBF wrote:
Mountaineer Buc wrote:The more you play with it, the more you can break down


And go blind.

My palms are too hairy to hide.

Re: Spreadsheets

PostPosted: Thu Jun 15, 2017 8:47 pm
by PrimeMinister
Mountaineer Buc wrote:
Buc2 wrote: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.

Re: Spreadsheets

PostPosted: Mon Jun 19, 2017 8:37 pm
by 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.

Re: Spreadsheets

PostPosted: Tue Jun 20, 2017 1:28 am
by PrimeMinister
A Man's Part wrote: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.