Solved

Exhale Fun Thread, Number 3

Posted on 2011-09-05
53
306 Views
Last Modified: 2012-06-01
The Excel Forum lacked its own "Fun Thread" and we used to let our self loose in the "Excel Zone Expert Discussion" which dilutes the objective of that thread and hence the need for a separate "Fun Thread". This thread is especially for Excel, where experts can just chill out and relax when there is no rush in the forum or they would like to share something funny. Topics MAY NOT include:

- Asking for assistance with specific questions
- Issues, announcements, and discoveries related to this zone
- Discussing Experts Exchange features and functions

And, occasionally, a little SERIOUS POSTS and other completely unrelated topics. Though try to avoid that... :-|

This thread must not be used for any of the following:

- Presenting any specific member in a negative light
- Suggesting that any specific member needs to change their behavior
- Suggesting that others blacklist any Asker for any reason
- How Bored YOU are

These topics and any others like them should be taken up privately with the site moderators, all of whom are listed here with their email addresses:

   http://www.experts-exchange.com/communityService.jsp?editVolunteerMenuIndex=1

Previous Exhale Fun Thread: http:/Q_26923688.html

Next Fun Thread: None

---

Zone Advisors

When this thread reaches a page size of about 100K (about 200 posts):

1) Create a new "Exhale Fun Thread" thread using this content as a template, incrementing the number in the title, and setting the "Previous Expert Discussion" link to this thread.

2) Edit the new thread and set the points to zero.

3) Edit this question and set the "Next Exhale Fun Thread" to link to the new thread.

4) Make a final post in this thread with a link to the new thread "Next Exhale Fun Thread: http:Q_xxxxxxxxx.html" and accept that post as the solution.
0
Comment
Question by:SiddharthRout
  • 22
  • 12
  • 10
  • +6
53 Comments
 
LVL 30

Author Comment

by:SiddharthRout
ID: 36486632
Hoping to have a fun filled month!

If you had to buy Space in Excel worksheet, which range would that be?

Mine would be the SID column (SID1:SID1048576) ;-)

Sid
0
 
LVL 37

Expert Comment

by:TommySzalapski
ID: 36486826
You're not backward compatible. I still have 2003 so you don't exist in my world.

And I would just claim some free space in OpenOffice Calc since I tend to avoid paying for anything digital if at all legally possible.
0
 
LVL 30

Author Comment

by:SiddharthRout
ID: 36486980
>>>You're not backward compatible. I still have 2003 so you don't exist in my world.

Oh! You don't have the latest version of Excel 2003? That's what happens when you stick to OpenOffice Calc :-|
Sidz.bmp
0
 
LVL 37

Expert Comment

by:TommySzalapski
ID: 36487388
Or you could just hide columns T:IC, but that still only gets you 65536 rows. So even when you show up you're only 6.25% there (which would explain a lot).
0
 
LVL 30

Author Comment

by:SiddharthRout
ID: 36568841
No one else having fun in Sept?

Sid
0
 
LVL 20

Expert Comment

by:pari123
ID: 36569721
i am HP touchpad hunting... :) can't believe how hard it is to get my hands on one...
0
 
LVL 30

Author Comment

by:SiddharthRout
ID: 36571266
3D gaming? ;-)
0
 
LVL 50

Expert Comment

by:teylyn
ID: 37055957
OK, fun is over. This just came up in the Cleanup tool.

Time for a few more jokes or should I recommend deletion? <eeek!!>
0
 
LVL 30

Author Comment

by:SiddharthRout
ID: 37078060
Strange.... No one is interested in any more fun?

Sid
0
 
LVL 41

Expert Comment

by:dlmille
ID: 37151552
I am!

I'm taking my wife and 3 kids
=IF({15, 8, and pushing 13}*{girl,boy,girl},"Lots of love, and you're in for an adventure, let me tell you!","Better get started, lol")

We're going on a cruise for Thanksgiving.  7 days on the Mexican Riveria, the Love Boat cruise line (Princess).  A stop in Cabo and Puerto Vallarta, and all the food, fun, and (hopefully) rest and relaxation I can handle.

We leave, this Saturday, returning the following Sunday.  We're driving down to LA from SF (about 6.5 hours, I think) with stops every hour to hour and a half (that's for me :), and Dad will be quizzing the kids on math, science, geometry, and trig/beginner calculus - visualizing and solving without paper.  Did that a while back and the Miller "geeks" had a pretty good time at it, or the kids were humoring their 'Ol dad a bit, not sure which...

I hope to stay connected, but if I fall off the map for a few days you guys/gals can have all the points, lol.  I WILL try to plot my trip on the google maps: http://maps.google.com/maps/myplaces?vpsrc=1&ctz=480&abauth=8ee99de1:eug8a3iqwedstX8S7ffcbIBmfJU&vps=1&ei=08vETqCRCqSYoQTbyJXoBw&num=10

Does that link work for you?  Anyway, its the link nutsch setup for us.  I'll try to find a boat as my icon for the trip, though it doesn't compare to - hey, aikimark - you're badger is back!

What's everyone else doing?

Let's do a round on what folks are doing this last quarter in the realm of getting a "break" from the "grind"!

Dave
0
 
LVL 30

Author Comment

by:SiddharthRout
ID: 37152011
>>>and Dad will be quizzing the kids on math, science, geometry, and trig/beginner calculus - visualizing and solving without paper.

I thought it was a fun trip LOL.

Anyways have a safe trip :)

Sid

0
 
LVL 37

Expert Comment

by:TommySzalapski
ID: 37152672
That does sound fun.

I remember once playing Monopoly all in our heads as a kid with my family on a long trip in the car. My mom was the only one that didn't know the board, so she got to be the dice.
0
 
LVL 30

Author Comment

by:SiddharthRout
ID: 37152823
Monoply... OK.
Maths/Trig/Calculus... Nah!    :-D
0
 
LVL 30

Author Comment

by:SiddharthRout
ID: 37196736
Congrats David on crossing the 1m mark!!!!

I must say your holiday was perfectly timed and well deserved :-D

Hope you have a ball of a time :)

Sid
0
 
LVL 30

Author Comment

by:SiddharthRout
ID: 37196737
And crossing my score as well!!! Damn! I need to be back with full focus!!! :D

Sid
0
 
LVL 41

Expert Comment

by:dlmille
ID: 37198118
Thanks, Sid - I'm not sure who will end up as "Rookie of the Year" in the Excel space, but I believe if my first answer had been Jan 1, instead of Dec 15th, I might have had a shot, lol :P
0
 
LVL 50

Expert Comment

by:barry houdini
ID: 37198637
If I'm right then leading contender for Excel "Rookie of the Year" for 2011 looks to be andrewssd3. I started on 23rd October so I didn't have much of a shot - December 15th makes it a real challenge!

How was the cruise, Dave? Mrs Houdini and i have been on two European cruises in the last two years (Med and Baltic) - we might try and expand our horizons next time - Canaries or Caribbean?

regards, barry
0
 
LVL 41

Expert Comment

by:dlmille
ID: 37198650
Well, when I started, it wasn't about anything but, "giving back" as the community (not Excel, but other geek stuff I'd used over the years), but it was a bit of a sore point to learn that "Rookie" meant not having prior year points, no matter what day it started on, lol.

I got a lot of t-shirts, tho :)

The cruise was fantastic.  I got a lot of ME time (geeking out on an article/app), and the kids were almost always absent (except the 3-4 hour check-in).  The food was GREAT.  We snorkeled in Cabo San Lucas, and enjoyed a 3-hour cruise on a real (vintage 1880's) sailboat (called the "Sunderland"), with the wind at our backs, imagining how the did in the "old days".

barry - that's a lot of cruises in a short time :)  My kids were asking if we were going again, next year, lol.

We might try the Caribbean, as well, next time.  Need to see how my brother-in-law and his family sorted out as they were cruising there, at the same time.

Dave
0
 
LVL 41

Expert Comment

by:dlmille
ID: 37198651
>> "giving back" as the community

I meant "giving back" to the community that had helped me over the years...
0
 
LVL 41

Expert Comment

by:dlmille
ID: 37210118
barry - I checked several and found I was some busy guy from Dec 15th to end of the year.  I think the only one I might rank as rookie is VB Classic, lol.  If that's true (looks like all ahead of me have > 1MM points overall, so assuming it is) then that's a surprise.

The trumpets are much sweeter in Excel, though.  Now, why couldn't they have given a disclaimer, like, "Are you SURE you want to respond to this posting and try to become an Expert NOW?  Why not wait till after the end of the year - its only 2 weeks away?"  I guess I'm giving away I have a bit of a competitive spirit as if you didn't know.

Maybe for next year, I can get the designers to add VSTO as its own separate zone, perhaps.  Or gum chewing, lol - and, probably, in an effort to show I can chew and walk at the same time, I'd probably get an answer in before Dec 31st on the first few questions off the block :)

:P


Dave
0
 
LVL 80

Expert Comment

by:byundt
ID: 37210501
<<The trumpets are much sweeter in Excel>>

Don't forget our fabulous string section.
0
 
LVL 41

Expert Comment

by:dlmille
ID: 37210524
and drums!

ba da bing!
0
 
LVL 37

Expert Comment

by:TommySzalapski
ID: 37210532
string section is a pun because you use strings in Excel. I'm not sure where the drums are supposed to come in.
0
 
LVL 80

Expert Comment

by:byundt
ID: 37210649
The string section is a reference to our resident cellist: teylyn.


teylyn.png
0
 
LVL 41

Expert Comment

by:dlmille
ID: 37210978
You've never heard of the "Drum" class?  how do you think drummers learn to play?
0
 
LVL 37

Expert Comment

by:TommySzalapski
ID: 37214239
Being a drummer myself, I can actually answer that (then we can cross post this in the Music zone and give me my points).

Step 1: Hit something
Step 2: Repeat step 1 until it sounds good
Step 3 (advanced): Repeat previous steps until someone else says it sounds good

See? No classes needed.
0
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 
LVL 41

Expert Comment

by:dlmille
ID: 37214432
I can do THAT!
0
 
LVL 39

Expert Comment

by:nutsch
ID: 37215517
Step 4 (expert): Repeat previous steps until someone else than the bass player says it sounds good
0
 
LVL 30

Author Comment

by:SiddharthRout
ID: 37215840
The fun you are having with words gave me this idea :-D

In the below paragraph, there are words which are associated with Excel in one way or the other. Can you identify them?

Words Found
Less than 15: You are an Excel Newbie
16 to 20: You are getting there
21 to 25: Excel genius?
26 to 30: You are an Excel Wizard ;)
>30: If I have my way, the next version of Excel will be named after you!

---------------------------------------------------------------------------------------------------------
It is in strict confidence we disclose that we are having a party and it is a private party and not a public party. There will be dim lights and soft music. The party is for the class of 2010. This has been a const affair. This event has been recognized on a global level. Dress code has not been declared yet. The organizers will declare it soon. Booze will overflow. Everyone has to ensure that they dance once on the floor. The total sum for the entry fee is 550 USD. No negotiations. it is a fixed price. Please call or inform all relevant friend(s) there should be no error in communication.

Weather: We have seen the forecast and hereby comment that the sky would be clear and it is a perfect day to have this party.

Mode of transport: small cars for home pickups. While every route has been covered but if your name is not in the list then please forward us the exact address details.

Time: 7 pm
Date: today
---------------------------------------------------------------------------------------------------------

Sid
0
 
LVL 37

Expert Comment

by:TommySzalapski
ID: 37215873
I could associate every single word there with Excel in one way or the other. What am I classified as?
0
 
LVL 30

Author Comment

by:SiddharthRout
ID: 37215897
How would you associate route ?

And I don't mean like this

Dim route as string ;)

Sid
0
 
LVL 30

Author Comment

by:SiddharthRout
ID: 37215908
I am looking for words with are already a part of VBA Code / Excel Formulas or are prominent displayed in the Excel window. For example

comment, class, const etc... :)

Sid
0
 
LVL 37

Expert Comment

by:TommySzalapski
ID: 37215933
0
 
LVL 41

Expert Comment

by:dlmille
ID: 37217300
I found 28 without repeats, but as with Tommy, for me the rest can be variable names, so all of them :P
0
 
LVL 41

Expert Comment

by:dlmille
ID: 37217308
Might have been more, but I was counting without writing down my score and didn't want to pull my shoes off. (its tough when I get past 10 without them)
0
 
LVL 30

Author Comment

by:SiddharthRout
ID: 37217434
@Tommy: Aha! I didn't know about that :) But yes, all of them words in the above para are not associated with Excel :) I personally counted 35 (without repeats) and then after that gave up LOL.

Sid

0
 
LVL 30

Author Comment

by:SiddharthRout
ID: 37217456
Slight change :D

Words Found
Less than 15: You are an Excel Newbie
16 to 20: You are getting there
21 to 25: Excel genius?
26 to 39: You are an Excel Wizard ;)
>40: If I have my way, the next version of Excel will be named after you!
0
 
LVL 80

Expert Comment

by:byundt
ID: 37217593
I found 63, but 16 are as dubious as SID
0
 
LVL 30

Author Comment

by:SiddharthRout
ID: 37217603
Brad, I won't even ask you what are those.... byundt 2012 is the next Excel Version!!! :D

BTW, I had thought about "SID" and hence I deliberately kept "Sid" out of that para. If you notice it is after the line :) But still I am interested in those 16 entries.

Sid
0
 
LVL 41

Expert Comment

by:dlmille
ID: 37217842
I'm up to 58 (I am now barefoot)
0
 
LVL 30

Author Comment

by:SiddharthRout
ID: 37392412
New Year! New Fun! Bring it on!

Sid
0
 
LVL 30

Author Comment

by:SiddharthRout
ID: 37463127
Here is an interesting bug! Found it while browsing another forum :)

This will crash your Excel (I tested in 2010)

Open a module and copy and paste the below code. The moment you will paste it, Excel will crash!!! INTERESTING

private sub foo
    dim v(1 to N, 1 to M)
    ...
    M = New_Value
    redim preserve v(,1 to M)  

Open in new window

0
 
LVL 37

Expert Comment

by:TommySzalapski
ID: 37463161
Nice
0
 
LVL 30

Author Comment

by:SiddharthRout
ID: 37463195
I seriously hope you were doing something important in excel when you tried that :| Now that would have been fuuuuuuuuuuuuuun!
0
 
LVL 58

Expert Comment

by:cyberkiwi
ID: 37465673
sub SiddharthRoutKilledMeExcel
    redim preserve v(,1 to Z)
0
 
LVL 37

Expert Comment

by:TommySzalapski
ID: 37465708
It crashes 2003 too in case anyone cares.
0
 
LVL 41

Expert Comment

by:dlmille
ID: 37498759
http:/Q_27555252.html

I just had to smile.  TODAY()  DAY(TODAY())  what about a TOMORROW() function or a LASTMONTH() function?  

In Spanish, is the NOW() function AHORA()? and if there was a YESTERDAY function would it start with LAPROXIMA?

What if there were a Pig Latin version of Excel?

The end of the month would be =ODAYTAY() - AYDAY(ODAYTAY())

and then, I started humming....

"YESTERDAY.... hmmmm...  all my troubles seemed so far away... da da de de dum da de dee dum, daaa, daa deee deee, daa daa dee dee!"

:)

dave
0
 
LVL 30

Author Comment

by:SiddharthRout
ID: 37519407
Boy, am I glad that this site has a "-" between Experts and Exchange :)

0
 
LVL 30

Author Comment

by:SiddharthRout
ID: 37519413
Ah the link didn't upload


395947-313544615362598-289998861.jpg
0
 
LVL 58

Expert Comment

by:cyberkiwi
ID: 37586821
SiddharthRout - did you pay for a subscription or are you now blocked from all the effort you put into this site?
0
 
LVL 30

Author Comment

by:SiddharthRout
ID: 37587223
No I haven't paid for the subscription. Nor am I blocked... Yet.
0
 
LVL 37

Expert Comment

by:TommySzalapski
ID: 37587811
They may/should have some sort of lifetime membership for people who hit Genius level or something. That would be kind of lame if they blocked you, Sid.
0
 
LVL 30

Accepted Solution

by:
SiddharthRout earned 0 total points
ID: 37669425
I don't see this happening (nor would I want it personally) but imagine what if MS decides to replace VBA with VBNA (VB.Net For Applications) or say CSA (C# For Applications) in Office applications.

Um that would be quite funny and to think of it SCARY!
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

What is a Form List Box? (skip if you know this) The forms List Box is the alternative to the ActiveX list box. If you are using excel 2007, you first make sure you have a developer tab (click the Orb)->"Excel Options"->Popular->"Show Developer tab…
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

746 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now