Spreadsheet help! - Fantasy Baseball Cafe 2014 Fantasy Baseball Cafe
100% Deposit Bonus for Cafe Members!

Return to Baseball Leftovers

Spreadsheet help!

Moderator: Baseball Moderators

Postby SaintsOfTheDiamond » Sun Nov 28, 2004 11:56 pm

Back to Excel right quick. Is there any way to remove the hyperlinks from all cells in a colum/row or preferably the entire spreadsheet? :-?
Image
Member #4 of the Inaugural Yadier Molina Fan Club!!!
SaintsOfTheDiamond
Hall of Fame Hero
Hall of Fame Hero

Fantasy ExpertCafe WriterCafe Ranker
Posts: 6480
Joined: 6 May 2004
Home Cafe: Baseball
Location: Swiping second

Postby Tavish » Mon Nov 29, 2004 12:15 am

SaintsOfTheDiamond wrote:Back to Excel right quick. Is there any way to remove the hyperlinks from all cells in a colum/row or preferably the entire spreadsheet? :-?


Stupid Excel. It doesn't have a way to remove all hyperlinks in a spreadsheet automatically. You can use the Macro I use to kill them all at once though.

Open the spreadsheet then press alt-F11 to open the VB editor. Choose Insert/Module to create a new module then copy/paste or type this into the window

<pre>
Sub KillAllHyperlinks()
Cells.Hyperlinks.Delete
End Sub
</pre>

You can then go back to your spreadsheet choose Tools/Macro/Macros (or alt-F8) and select KillAllHyperlinks

HTH
Image

Bury me a Royal.
Tavish
Mod in Retirement
Mod in Retirement

User avatar
CafeholicFantasy ExpertCafe WriterCafe RankerMock(ing) DrafterEagle EyeCafe SpotterWeb Supporter
Posts: 11067
(Past Year: 26)
Joined: 3 May 2004
Home Cafe: Baseball

Postby SaintsOfTheDiamond » Mon Nov 29, 2004 12:17 am

Thanks Tav. Worked like a charm. ;-D
Image
Member #4 of the Inaugural Yadier Molina Fan Club!!!
SaintsOfTheDiamond
Hall of Fame Hero
Hall of Fame Hero

Fantasy ExpertCafe WriterCafe Ranker
Posts: 6480
Joined: 6 May 2004
Home Cafe: Baseball
Location: Swiping second

Postby Wozzyck » Mon Nov 29, 2004 3:07 am

SQL doesn't actually stand for anything;


Nice overview, Pedantic. (FWIW, SQL stands for structured query language.)
Wozzyck
Minor League Mentor
Minor League Mentor

User avatar

Posts: 468
Joined: 14 Jul 2004
Home Cafe: Baseball

Postby SaintsOfTheDiamond » Mon Nov 29, 2004 3:45 pm

Now how do you delete macros? :-D I followed the instructions in help, but the delete option is unavailable. :-? Or how do I get the annoying pop up to go away is all I really want. Is the security warning message important? :-/
Image
Member #4 of the Inaugural Yadier Molina Fan Club!!!
SaintsOfTheDiamond
Hall of Fame Hero
Hall of Fame Hero

Fantasy ExpertCafe WriterCafe Ranker
Posts: 6480
Joined: 6 May 2004
Home Cafe: Baseball
Location: Swiping second

Postby Pedantic » Mon Nov 29, 2004 4:12 pm

Wozzyck wrote:
SQL doesn't actually stand for anything;


Nice overview, Pedantic. (FWIW, SQL stands for structured query language.)


Actually, that's a misnomer because:
1. SQL isn't structured.
2. SQL isn't limited to queries.
3. SQL isn't a full language.

But I used to think it stood for that as well; it almost makes sense...almost.
Image
Pedantic
Hall of Fame Hero
Hall of Fame Hero

User avatar
CafeholicEagle EyeCafe Musketeer
Posts: 6725
Joined: 5 Dec 2003
Home Cafe: Baseball
Location: Funny movie quote that everyone knows

Postby Amazinz » Mon Nov 29, 2004 5:32 pm

SQL is the acronym for Structured Query Language whether or not you think it is. It is not a misnomer. :-b

It is structured. Structured in this sense is referring to standardization by ANSI and ISO.

SQL is a fully implemented "Query Language". It is "Structured" "Query Language" not "Structured" "Query" "Language". So in this regard it is a full database language.

SQL is limited to queries. Don't confuse SELECT (data retrieval) as the only form of a query. There are five: SELECT, WHERE, UPDATE, DELETE, and INSERT. All database operations can be reduced to one of these five queries. ;-)
Image
Maine has a good swing for a pitcher but on anything that moves, he has no chance. And if it's a fastball, it has to be up in the zone. Basically, the pitcher has to hit his bat. - Mike Pelfrey
Amazinz
Mod in Retirement
Mod in Retirement

User avatar
CafeholicFantasy ExpertCafe WriterCafe RankerMock(ing) DrafterEagle EyeWeb SupporterPick 3 Weekly WinnerSweet 16 SurvivorLucky Ladders Weekly Winner
Posts: 18800
Joined: 16 Mar 2004
Home Cafe: Baseball
Location: in Canada, toughening up figure skaters

Postby Pedantic » Mon Nov 29, 2004 10:07 pm

Amazinz wrote:SQL is the acronym for Structured Query Language whether or not you think it is. It is not a misnomer. :-b

It is structured. Structured in this sense is referring to standardization by ANSI and ISO.


Well, if they meant structured in that sense, why didn't they use "Standardized"? It wouldn't even ruin the "acronym".

Amazinz wrote:SQL is a fully implemented "Query Language". It is "Structured" "Query Language" not "Structured" "Query" "Language". So in this regard it is a full database language.

SQL is limited to queries. Don't confuse SELECT (data retrieval) as the only form of a query. There are five: SELECT, WHERE, UPDATE, DELETE, and INSERT. All database operations can be reduced to one of these five queries. ;-)


Weeell, first of all, you're forgetting FROM. And while WHERE may be a clause in a statement, it is certainly not the most crucial part, and certainly cannot form its own statement. UPDATE, DELETE, and INSERT are also not queries. A query returns information from one or more tables. Since when did those three statements return any rows from a table? And if those "queries", as you say, are all there are to SQL, then, my friend, we are up the creek without a paddle. For it would be most difficult to actually create a database in the first place. It would also be rather difficult to create or alter a table, now wouldn't it? And creating indices and views would most certainly be impossible, would it not?

While attempting to explain "query" and "language" by saying it is a "query language" is convenient, it is also not true, as I've demonstrated that there is more to SQL than the SELECT statement. It is, however, a database language. It is also a declarative language. But it is not a "query language".

And as the final nail in the coffin, I shall quote from an SQL reference book:

Chris Fehily wrote:It's a common misconception that SQL stands for structured query language; it stands for S-Q-L and nothing else. Why? Because ANSI says so. The official name is Database Language SQL... Furthermore, referring to it as a structured query language is a disservice to new SQL programmers; it amuses database professionals and academics to point out that "structured query language" is the worst possible description, as SQL:
  • Isn't structured (because it can't be broken down into blocks or procedures)
  • Isn't limited to only queries (that is, there's more than just the SELECT statement)
  • Isn't a complete language (according to Turing's Thesis, which you'll study should you take Theory of Computation)


SQL may have used to have been called "structured query language", but as of the ANSI standards, it is not.
Image
Pedantic
Hall of Fame Hero
Hall of Fame Hero

User avatar
CafeholicEagle EyeCafe Musketeer
Posts: 6725
Joined: 5 Dec 2003
Home Cafe: Baseball
Location: Funny movie quote that everyone knows

Postby LBJackal » Tue Nov 30, 2004 12:07 am

War of the geeks! :-D

And according to Vince McMahon XFL didn't stand for anything..... but we all know it was the "Xtreme Football League".
Image

"Jack, will you call me, if you're able?"

"I've got your phone number written, in the back of my Bible."
LBJackal
Hall of Fame Hero
Hall of Fame Hero

User avatar
Pick 3 Weekly Winner
Posts: 9196
Joined: 1 Jul 2003
Home Cafe: Baseball
Location: The Hotel Yorba

Postby Tavish » Tue Nov 30, 2004 12:07 am

Pedantic wrote:Weeell, first of all, you're forgetting FROM. And while WHERE may be a clause in a statement, it is certainly not the most crucial part, and certainly cannot form its own statement. UPDATE, DELETE, and INSERT are also not queries. A query returns information from one or more tables. Since when did those three statements return any rows from a table?


Eh? UPDATE, DELETE, and INSERT are most definitely queries. They are action queries. A query simply asks the DB a question, the type of query determines what is done with the information.
Image

Bury me a Royal.
Tavish
Mod in Retirement
Mod in Retirement

User avatar
CafeholicFantasy ExpertCafe WriterCafe RankerMock(ing) DrafterEagle EyeCafe SpotterWeb Supporter
Posts: 11067
(Past Year: 26)
Joined: 3 May 2004
Home Cafe: Baseball

PreviousNext

Return to Baseball Leftovers

Who is online

Users browsing this forum: No registered users and 7 guests

Forums Articles & Tips Sleepers Rankings Leagues


Today's Games
Saturday, Aug. 23
(All times are EST, weather icons show forecast for game time)

Chi White Sox at NY Yankees
(1:05 pm)
Tampa Bay at Toronto
(1:07 pm)
Detroit at Minnesota
(1:10 pm)
Seattle at Boston
(1:35 pm)
Baltimore at Chi Cubs
(2:20 pm)
San Francisco at Washington
(4:05 pm)
Houston at Cleveland
(7:05 pm)
St. Louis at Philadelphia
(7:05 pm)
Pittsburgh at Milwaukee
(7:10 pm)
Atlanta at Cincinnati
(7:10 pm)
San Diego at Arizona
(8:10 pm)
Miami at Colorado
(8:10 pm)
Detroit at Minnesota
(8:10 pm)
Kansas City at Texas
(8:25 pm)
LA Angels at Oakland
(9:05 pm)
NY Mets at LA Dodgers
(9:10 pm)

  • Fantasy Baseball
  • Article Submissions
  • Privacy Statement
  • Site Survey 
  • Contact