mdb1958 wrote:Who is the spreadsheet guru in Buczone?
I know nothing on them. I know you can lock them and password protect them - blah blah.
In the combine thread I borrowed a spreadsheet and I am pretty sure you can go into the columns and enable them to go alphabetical or numerical if you click on them if you give them that feature - Right?
Anyways in this "pride of Detroit spreadsheet" if its locked they would have to do that on their end - Right?
Anywho's this guy did such a wonderful job on this spreadsheet but I wish He would have added this feature to the columns.
Nano wrote:mdb translation: How do you enable the sorting feature in Google Docs if the author disabled it?
Or something close
Zarniwoop wrote:Nano wrote:mdb translation: How do you enable the sorting feature in Google Docs if the author disabled it?
Or something close
That's what the question seems like to me ... how do you edit a read only sheet
Buc2 wrote:Zarniwoop wrote:
That's what the question seems like to me ... how do you edit a read only sheet
And the answer is.............. You don't.
mdb1958 wrote:Buc2 wrote:And the answer is.............. You don't.
Then I'm going to have to have you contact the author so he can make changes to his spreadsheet.
First request - make the last names alphabetical not the first names
2nd request - make the columns where you can click on them to show the fastest, tallest, arm length, etc... In numerical order.
If you have not seen the spreadsheet its in the combine thread on the last post.
My boss used to show off and pretend like he was showing me how to do things with spread sheets
BUT
All he was doing was showing off how fast he was.
NYBF wrote:mdb1958 wrote:
Then I'm going to have to have you contact the author so he can make changes to his spreadsheet.
First request - make the last names alphabetical not the first names
2nd request - make the columns where you can click on them to show the fastest, tallest, arm length, etc... In numerical order.
If you have not seen the spreadsheet its in the combine thread on the last post.
My boss used to show off and pretend like he was showing me how to do things with spread sheets
BUT
All he was doing was showing off how fast he was.
1 - you're not going to be able to sort by last name. The names are entered in 1 cell. In order to sort by last name, you'd have to have the names in separate cells.
2 - You can probably do this yourself. If you click on File, then Make A Copy. This will give you your own copy of the spreadsheet to do whatever you want with. You should then be able to click in each individual column and sort however you'd like.
Buc2 wrote:NYBF wrote:
1 - you're not going to be able to sort by last name. The names are entered in 1 cell. In order to sort by last name, you'd have to have the names in separate cells.
2 - You can probably do this yourself. If you click on File, then Make A Copy. This will give you your own copy of the spreadsheet to do whatever you want with. You should then be able to click in each individual column and sort however you'd like.
Actually, in Excel, you can separate text from 1 cell into 2 cells by using the Text to Columns Wizard. Conversely, you can combine the text from 2 or more cells into one cell.
mdb1958 wrote:What is it that CBSSports uses for their draft prospects? You can click on all those headers and change the page.
NYBF wrote:Buc2 wrote:Actually, in Excel, you can separate text from 1 cell into 2 cells by using the Text to Columns Wizard. Conversely, you can combine the text from 2 or more cells into one cell.
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.
mdb1958 wrote:Buc2, you can click on all of the CBS draft prospect stuff. If you click on height it shows the tallest to the shortest and if you click twice, its shortest to the tallest.
You can put all of the colleges in alphabetical order. What ever header you click on can be put in order. There was some time where these functions didnt work for a while (if anyone remembers me complaining). I think they didnt prepare for chrome and edge.
Now when 2018 clicks in they will drop all the stuff except the forty and as we all know it will be way off base till the draft season updates.
Anyways, with the spreadsheets and using them with prospects I thought those features would be nice to have. Click on them and put them in numerical order. Alphabetical is nice to see who all is coming out from the same college. Or, to link all the positions together.
NYBF wrote:mdb1958 wrote:Buc2, you can click on all of the CBS draft prospect stuff. If you click on height it shows the tallest to the shortest and if you click twice, its shortest to the tallest.
You can put all of the colleges in alphabetical order. What ever header you click on can be put in order. There was some time where these functions didnt work for a while (if anyone remembers me complaining). I think they didnt prepare for chrome and edge.
Now when 2018 clicks in they will drop all the stuff except the forty and as we all know it will be way off base till the draft season updates.
Anyways, with the spreadsheets and using them with prospects I thought those features would be nice to have. Click on them and put them in numerical order. Alphabetical is nice to see who all is coming out from the same college. Or, to link all the positions together.
You can do all that on the spreadsheet I linked.
Buc2 wrote:NYBF wrote:
You can do all that on the spreadsheet I linked.
Correct. It's called, Sort.Excel has buttons that will do an A-Z (descending) sort or a Z-A (ascending) sort. You can even sort based on cell or font colors if your data has colored cells/fonts. Place the cursor on the column heading and click the A-Z or Z-A button and VOILA!
Basically, mdb really should do some reading up on spreadsheets and how to use them instead of bitching that they can't do what CBS Sports does on their website because they surely can.
mdb1958 wrote:Buc2 wrote:Correct. It's called, Sort.Excel has buttons that will do an A-Z (descending) sort or a Z-A (ascending) sort. You can even sort based on cell or font colors if your data has colored cells/fonts. Place the cursor on the column heading and click the A-Z or Z-A button and VOILA!
Basically, mdb really should do some reading up on spreadsheets and how to use them instead of bitching that they can't do what CBS Sports does on their website because they surely can.
Ahh, but Mustafa can you have it stay like that. For instance. I want to look at all the cornerbacks (so I do the AtoZ thing, now I want to see their fortys in numerical order --- guess what -- the cornerbacks are no longer lined up.
lachisbackisback wrote:I didn't read the thread at all, but I love that the thread showing on the main page for the Nerdery is titled Spreadsheets. Please ensure it stays at the top, whoever posts in here. It's too perfect.
lachisbackisback wrote:I didn't read the thread at all, but I love that the thread showing on the main page for the Nerdery is titled Spreadsheets. Please ensure it stays at the top, whoever posts in here. It's too perfect.
lachisbackisback wrote:lachisbackisback wrote:I didn't read the thread at all, but I love that the thread showing on the main page for the Nerdery is titled Spreadsheets. Please ensure it stays at the top, whoever posts in here. It's too perfect.
Buc2 wrote:I'm obviously missing something here because I still don't get what Lachy is even talking about.
A Man's Part wrote:Buc2 wrote:I'm obviously missing something here because I still don't get what Lachy is even talking about.
Really?
He's saying spreadsheets are the epitome of nerdery.
Rocker wrote:lachisbackisback wrote:I didn't read the thread at all, but I love that the thread showing on the main page for the Nerdery is titled Spreadsheets. Please ensure it stays at the top, whoever posts in here. It's too perfect.
mdb1958 wrote:Buc2 wrote:Correct. It's called, Sort.Excel has buttons that will do an A-Z (descending) sort or a Z-A (ascending) sort. You can even sort based on cell or font colors if your data has colored cells/fonts. Place the cursor on the column heading and click the A-Z or Z-A button and VOILA!
Basically, mdb really should do some reading up on spreadsheets and how to use them instead of bitching that they can't do what CBS Sports does on their website because they surely can.
Ahh, but Mustafa can you have it stay like that. For instance. I want to look at all the cornerbacks (so I do the AtoZ thing, now I want to see their fortys in numerical order --- guess what -- the cornerbacks are no longer lined up.
Users browsing this forum: No registered users and 4 guests