Author Topic: Excel  (Read 1186 times)

0 Members and 1 Guest are viewing this topic.

Offline pawan89

  • Tennis God
  • ******
  • Posts: 8497
  • Gender: Male
    • Onset of Chaos
Excel
« on: May 18, 2011, 11:36:29 PM »
Is anyone who knows excel really well online right now?


Offline Swish

  • Tennis God
  • ******
  • Posts: 9999
  • Gender: Male
  • How Many Times?
Re: Excel
« Reply #1 on: May 19, 2011, 12:52:21 AM »
You'll have to wait for Babbs, I'm pretty sure he knows it.

He tried to do some limits once for BGT, it didn't work out though.  :rofl_2:


Offline pawan89

  • Tennis God
  • ******
  • Posts: 8497
  • Gender: Male
    • Onset of Chaos
Re: Excel
« Reply #2 on: May 19, 2011, 12:58:14 AM »
You'll have to wait for Babbs, I'm pretty sure he knows it.

He tried to do some limits once for BGT, it didn't work out though.  :rofl_2:


 :rofl_2: Babs to the rescue it shall be then!!


Offline DirtyKash

  • Tennis God
  • ******
  • Posts: 1323
  • Gender: Male
  • Child labor laws are ruining this country.
Re: Excel
« Reply #3 on: May 19, 2011, 06:37:57 AM »
I'm an expert at Lotus 1-2-3.

Offline Swish

  • Tennis God
  • ******
  • Posts: 9999
  • Gender: Male
  • How Many Times?
Re: Excel
« Reply #4 on: May 19, 2011, 12:15:10 PM »
You'll have to wait for Babbs, I'm pretty sure he knows it.

He tried to do some limits once for BGT, it didn't work out though.  :rofl_2:


 :rofl_2: Babs to the rescue it shall be then!!

I shouldn't have said anything about Babb's, I think I scared him off.   :rofl_2:


Offline Alex

  • Tennis God
  • ******
  • Posts: 11997
  • Gender: Male
Re: Excel
« Reply #5 on: May 19, 2011, 02:15:31 PM »
Babs excels at everything  :rofl_2:

Online Babblelot

  • Tennis God
  • ******
  • Posts: 32655
  • Gender: Male
  • Chicago, IL
Re: Excel
« Reply #6 on: May 19, 2011, 03:27:47 PM »
Excel expert proficient with various functions including, but not limited to, regression, VLookup, Visual Basics, Pivot Table, conditional formulas, charts, and formatting.
-Babblelot resume

« Last Edit: May 19, 2011, 03:34:32 PM by Babblelot »
1995 USO, 1997 USO, 2004 USO, 2005 RG, 2005 USO, 2006 RG, 2006 USO, 2007 USO, 2008 RG, 2008 USO, 2009 USO, 2010 USO, 2011 USO, 2012 USOhttp://www.gifsoup.com/view4/1856936/2005safin-o.gif
http://www.gifsoup.com/view1/1857331/2004gaudio-o.gif

Online Babblelot

  • Tennis God
  • ******
  • Posts: 32655
  • Gender: Male
  • Chicago, IL
Re: Excel
« Reply #7 on: May 19, 2011, 03:29:10 PM »
I assumed you used Excel to score the GS Bracket Challenge. How do you do it?
1995 USO, 1997 USO, 2004 USO, 2005 RG, 2005 USO, 2006 RG, 2006 USO, 2007 USO, 2008 RG, 2008 USO, 2009 USO, 2010 USO, 2011 USO, 2012 USOhttp://www.gifsoup.com/view4/1856936/2005safin-o.gif
http://www.gifsoup.com/view1/1857331/2004gaudio-o.gif

Offline pawan89

  • Tennis God
  • ******
  • Posts: 8497
  • Gender: Male
    • Onset of Chaos
Re: Excel
« Reply #8 on: May 19, 2011, 06:26:19 PM »
I assumed you used Excel to score the GS Bracket Challenge. How do you do it?

I do but I didn't need it that. That's pretty impressive Babbs, you DO know excel!! I have been having a lot of trouble with INDIRECT and references as well as developing algorithms to automate certain things. For instance lets say I have a list like the following, and I want to automate a process to list the top 5 performers, first by most titles won and then by grand slams won. how do you think i would go about doing it?

Name Titles GS
Federer 50 16
Nadal 85 14
Roddick 50 5
Djokovic 85 16

So I want them listed as first Djokovic (highest titles AND GS) then Nadal, then Federer then Roddick. Without using the simple But MANUAL sort function with two levels. 

Right now what I have checks for the 85 then eliminates ALL 85s and so on so what I am left with is just Djokovic and Federer


Online Babblelot

  • Tennis God
  • ******
  • Posts: 32655
  • Gender: Male
  • Chicago, IL
Re: Excel
« Reply #9 on: May 19, 2011, 06:57:50 PM »
Check your gmail, yo!
1995 USO, 1997 USO, 2004 USO, 2005 RG, 2005 USO, 2006 RG, 2006 USO, 2007 USO, 2008 RG, 2008 USO, 2009 USO, 2010 USO, 2011 USO, 2012 USOhttp://www.gifsoup.com/view4/1856936/2005safin-o.gif
http://www.gifsoup.com/view1/1857331/2004gaudio-o.gif

Online Babblelot

  • Tennis God
  • ******
  • Posts: 32655
  • Gender: Male
  • Chicago, IL
Re: Excel
« Reply #10 on: May 19, 2011, 07:01:00 PM »
Btw, I'm on FB now, so chat me up.
1995 USO, 1997 USO, 2004 USO, 2005 RG, 2005 USO, 2006 RG, 2006 USO, 2007 USO, 2008 RG, 2008 USO, 2009 USO, 2010 USO, 2011 USO, 2012 USOhttp://www.gifsoup.com/view4/1856936/2005safin-o.gif
http://www.gifsoup.com/view1/1857331/2004gaudio-o.gif

Online Babblelot

  • Tennis God
  • ******
  • Posts: 32655
  • Gender: Male
  • Chicago, IL
Re: Excel
« Reply #11 on: May 19, 2011, 07:28:59 PM »
Alex!

Why aren't you my Facebook friend?
1995 USO, 1997 USO, 2004 USO, 2005 RG, 2005 USO, 2006 RG, 2006 USO, 2007 USO, 2008 RG, 2008 USO, 2009 USO, 2010 USO, 2011 USO, 2012 USOhttp://www.gifsoup.com/view4/1856936/2005safin-o.gif
http://www.gifsoup.com/view1/1857331/2004gaudio-o.gif

Offline Alex

  • Tennis God
  • ******
  • Posts: 11997
  • Gender: Male
Re: Excel
« Reply #12 on: May 19, 2011, 07:31:39 PM »
Alex!

Why aren't you my Facebook friend?
belive it or not I do not have a fb account  :)

Online Babblelot

  • Tennis God
  • ******
  • Posts: 32655
  • Gender: Male
  • Chicago, IL
Re: Excel
« Reply #13 on: May 19, 2011, 07:44:39 PM »
Well, that's OK. We all suspect you look and talk like this...

[youtube]http://www.youtube.com/watch?v=YaA6JgWI4J0[/youtube]



...but in fact, you look and talk like this.

[youtube]http://www.youtube.com/watch?v=IPsAKZuz3t0&feature=related[/youtube]

1995 USO, 1997 USO, 2004 USO, 2005 RG, 2005 USO, 2006 RG, 2006 USO, 2007 USO, 2008 RG, 2008 USO, 2009 USO, 2010 USO, 2011 USO, 2012 USOhttp://www.gifsoup.com/view4/1856936/2005safin-o.gif
http://www.gifsoup.com/view1/1857331/2004gaudio-o.gif

Offline Alex

  • Tennis God
  • ******
  • Posts: 11997
  • Gender: Male
Re: Excel
« Reply #14 on: May 19, 2011, 07:47:56 PM »
^^^ that second video is totally me, darn, I'm so  busted  :rofl_2:

Online Babblelot

  • Tennis God
  • ******
  • Posts: 32655
  • Gender: Male
  • Chicago, IL
Re: Excel
« Reply #15 on: May 19, 2011, 07:53:01 PM »
You do say "What's the big scruffle aboot?"

I knew it!  :rofl_2:
1995 USO, 1997 USO, 2004 USO, 2005 RG, 2005 USO, 2006 RG, 2006 USO, 2007 USO, 2008 RG, 2008 USO, 2009 USO, 2010 USO, 2011 USO, 2012 USOhttp://www.gifsoup.com/view4/1856936/2005safin-o.gif
http://www.gifsoup.com/view1/1857331/2004gaudio-o.gif

Offline Alex

  • Tennis God
  • ******
  • Posts: 11997
  • Gender: Male
Re: Excel
« Reply #16 on: May 19, 2011, 08:00:07 PM »
You do say "What's the big scruffle aboot?"

I knew it!  :rofl_2:
ah, lol, that was good  :rofl_2:

Offline falcon

  • Tennis God
  • ******
  • Posts: 4938
  • Gender: Female
  • cooooooooooooooool
Re: Excel
« Reply #17 on: May 19, 2011, 08:12:12 PM »
American accent:  :)>>>>



The drag of destiny destroys the reins of reason

Online Babblelot

  • Tennis God
  • ******
  • Posts: 32655
  • Gender: Male
  • Chicago, IL
Re: Excel
« Reply #18 on: May 19, 2011, 08:20:28 PM »
1995 USO, 1997 USO, 2004 USO, 2005 RG, 2005 USO, 2006 RG, 2006 USO, 2007 USO, 2008 RG, 2008 USO, 2009 USO, 2010 USO, 2011 USO, 2012 USOhttp://www.gifsoup.com/view4/1856936/2005safin-o.gif
http://www.gifsoup.com/view1/1857331/2004gaudio-o.gif

Online Babblelot

  • Tennis God
  • ******
  • Posts: 32655
  • Gender: Male
  • Chicago, IL
Re: Excel
« Reply #19 on: May 19, 2011, 08:22:27 PM »
Pretty funny stuff, falconi.
1995 USO, 1997 USO, 2004 USO, 2005 RG, 2005 USO, 2006 RG, 2006 USO, 2007 USO, 2008 RG, 2008 USO, 2009 USO, 2010 USO, 2011 USO, 2012 USOhttp://www.gifsoup.com/view4/1856936/2005safin-o.gif
http://www.gifsoup.com/view1/1857331/2004gaudio-o.gif