Spreadsheets

Forum for graphics and other tech topics. Discuss operating system wars. etc..
post

Re: Spreadsheets

Postby mightyleemoon » Tue Jun 06, 2017 6:58 am

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.
User avatar
mightyleemoon
 
Posts: 3396
Joined: Wed Jan 14, 2015 2:35 pm
Has thanked: 13 times
Been thanked: 186 times

Re: Spreadsheets

Postby Mountaineer Buc » Tue Jun 13, 2017 9:31 am

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.
Image
User avatar
Mountaineer Buc
 
Posts: 8318
Joined: Wed Jan 14, 2015 1:15 pm
Has thanked: 85 times
Been thanked: 483 times

Re: Spreadsheets

Postby Buc2 » Tue Jun 13, 2017 10:05 am

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.
Image
Don't tread on me
User avatar
Buc2
 
Posts: 7403
Joined: Wed Jan 14, 2015 2:16 pm
Location: America
Has thanked: 713 times
Been thanked: 247 times

Re: Spreadsheets

Postby Mountaineer Buc » Tue Jun 13, 2017 1:41 pm

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.
Image
User avatar
Mountaineer Buc
 
Posts: 8318
Joined: Wed Jan 14, 2015 1:15 pm
Has thanked: 85 times
Been thanked: 483 times

Re: Spreadsheets

Postby NYBF » Tue Jun 13, 2017 2:42 pm

Mountaineer Buc wrote:The more you play with it, the more you can break down


And go blind.
Image
User avatar
NYBF
 
Posts: 3901
Joined: Wed Jan 14, 2015 11:46 am
Has thanked: 152 times
Been thanked: 357 times

Re: Spreadsheets

Postby Mountaineer Buc » Tue Jun 13, 2017 2:44 pm

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.
Image
User avatar
Mountaineer Buc
 
Posts: 8318
Joined: Wed Jan 14, 2015 1:15 pm
Has thanked: 85 times
Been thanked: 483 times

Re: Spreadsheets

Postby PrimeMinister » Thu Jun 15, 2017 8:47 pm

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.
PrimeMinister
 
Posts: 5856
Joined: Wed Jan 14, 2015 12:34 am
Has thanked: 27 times
Been thanked: 151 times

Re: Spreadsheets

Postby A Man's Part » Mon Jun 19, 2017 8:37 pm

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.
User avatar
A Man's Part
 
Posts: 1127
Joined: Wed Jan 14, 2015 12:26 am
Has thanked: 34 times
Been thanked: 54 times

Re: Spreadsheets

Postby PrimeMinister » Tue Jun 20, 2017 1:28 am

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.
PrimeMinister
 
Posts: 5856
Joined: Wed Jan 14, 2015 12:34 am
Has thanked: 27 times
Been thanked: 151 times

Previous

post

Return to The Nerdery

Who is online

Users browsing this forum: No registered users and 1 guest