• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 333
  • Last Modified:

Exhale Fun Thread, Number 3

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
SiddharthRout
Asked:
SiddharthRout
  • 22
  • 12
  • 10
  • +6
1 Solution
 
SiddharthRoutAuthor Commented:
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
 
TommySzalapskiCommented:
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
 
SiddharthRoutAuthor Commented:
>>>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
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
TommySzalapskiCommented:
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
 
SiddharthRoutAuthor Commented:
No one else having fun in Sept?

Sid
0
 
Ardhendu SarangiSr. Project ManagerCommented:
i am HP touchpad hunting... :) can't believe how hard it is to get my hands on one...
0
 
SiddharthRoutAuthor Commented:
3D gaming? ;-)
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
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
 
SiddharthRoutAuthor Commented:
Strange.... No one is interested in any more fun?

Sid
0
 
dlmilleCommented:
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
 
SiddharthRoutAuthor Commented:
>>>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
 
TommySzalapskiCommented:
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
 
SiddharthRoutAuthor Commented:
Monoply... OK.
Maths/Trig/Calculus... Nah!    :-D
0
 
SiddharthRoutAuthor Commented:
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
 
SiddharthRoutAuthor Commented:
And crossing my score as well!!! Damn! I need to be back with full focus!!! :D

Sid
0
 
dlmilleCommented:
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
 
barry houdiniCommented:
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
 
dlmilleCommented:
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
 
dlmilleCommented:
>> "giving back" as the community

I meant "giving back" to the community that had helped me over the years...
0
 
dlmilleCommented:
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
 
byundtCommented:
<<The trumpets are much sweeter in Excel>>

Don't forget our fabulous string section.
0
 
dlmilleCommented:
and drums!

ba da bing!
0
 
TommySzalapskiCommented:
string section is a pun because you use strings in Excel. I'm not sure where the drums are supposed to come in.
0
 
byundtCommented:
The string section is a reference to our resident cellist: teylyn.


teylyn.png
0
 
dlmilleCommented:
You've never heard of the "Drum" class?  how do you think drummers learn to play?
0
 
TommySzalapskiCommented:
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
 
dlmilleCommented:
I can do THAT!
0
 
nutschCommented:
Step 4 (expert): Repeat previous steps until someone else than the bass player says it sounds good
0
 
SiddharthRoutAuthor Commented:
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
 
TommySzalapskiCommented:
I could associate every single word there with Excel in one way or the other. What am I classified as?
0
 
SiddharthRoutAuthor Commented:
How would you associate route ?

And I don't mean like this

Dim route as string ;)

Sid
0
 
SiddharthRoutAuthor Commented:
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
 
dlmilleCommented:
I found 28 without repeats, but as with Tommy, for me the rest can be variable names, so all of them :P
0
 
dlmilleCommented:
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
 
SiddharthRoutAuthor Commented:
@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
 
SiddharthRoutAuthor Commented:
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
 
byundtCommented:
I found 63, but 16 are as dubious as SID
0
 
SiddharthRoutAuthor Commented:
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
 
dlmilleCommented:
I'm up to 58 (I am now barefoot)
0
 
SiddharthRoutAuthor Commented:
New Year! New Fun! Bring it on!

Sid
0
 
SiddharthRoutAuthor Commented:
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
 
TommySzalapskiCommented:
Nice
0
 
SiddharthRoutAuthor Commented:
I seriously hope you were doing something important in excel when you tried that :| Now that would have been fuuuuuuuuuuuuuun!
0
 
cyberkiwiCommented:
sub SiddharthRoutKilledMeExcel
    redim preserve v(,1 to Z)
0
 
TommySzalapskiCommented:
It crashes 2003 too in case anyone cares.
0
 
dlmilleCommented:
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
 
SiddharthRoutAuthor Commented:
Boy, am I glad that this site has a "-" between Experts and Exchange :)

0
 
SiddharthRoutAuthor Commented:
Ah the link didn't upload


395947-313544615362598-289998861.jpg
0
 
cyberkiwiCommented:
SiddharthRout - did you pay for a subscription or are you now blocked from all the effort you put into this site?
0
 
SiddharthRoutAuthor Commented:
No I haven't paid for the subscription. Nor am I blocked... Yet.
0
 
TommySzalapskiCommented:
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
 
SiddharthRoutAuthor Commented:
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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 22
  • 12
  • 10
  • +6
Tackle projects and never again get stuck behind a technical roadblock.
Join Now