Excel Zone Expert Discussion, Number 17

This thread is for general discussion about all things related to the Excel zone and its Experts. Topics welcome include:

- Asking for assistance with specific questions
- Issues, announcements, and discoveries related to this zone
- Discussing Experts Exchange features and functions
- Recognition of new Experts, amazing posts, and accomplishments
- Getting to know your fellow Experts
- Planning meets and greets with other Experts when traveling

And, occasionally, a little humor and other completely unrelated topics.

Any and all drivel posts such as "First Post" or "Subscribing" will be deleted. Note to all you buffoons: there is a link to the right with the text "Monitor". Click it. It does magical things.

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

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 Expert Discussion: http:Q_25728452.html

Next Expert Discussion: http:Q_26273993.html

---

Zone Advisors

When this thread reaches a page size of about 75K (about 150 posts):

1) Create a new "Expert Discussion" 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 Expert Discussion" to link to the new thread.

4) Make a final post in this thread with a link to the new thread "Next Expert Discussion: http:Q_xxxxxxxxx.html" and accept that post as the solution.
LVL 81
zorvek (Kevin Jones)ConsultantAsked:
Who is Participating?
 
zorvek (Kevin Jones)ConsultantAuthor Commented:
Next Expert Discussion: http:Q_26273993.html
0
 
Patrick MatthewsCommented:
Gang,

Please be on the lookout for mbugot, http://www.experts-exchange.com/M_5761464.html

S/he has posted two questions so far:
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_25993785.html
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_25993509.html

In the "array search" one, s/he admitted it is an academic assignment.  I am assuming that the other is as well, as both were posted today.

Please remember that providing general tips and hints is OK, but providing an actual solution is not :)

Patrick
0
 
bromy2004Commented:
Just a question for the ppl in the top 100,
How many question do you answer/comment on per day,
Because i seen to get about 20k-25k points per month, and some of you guys/girls are getting that much per day.

Any tips for increasing points?
0
Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

 
zorvek (Kevin Jones)ConsultantAuthor Commented:
We're sick.
0
 
Saurabh Singh TeotiaCommented:
Well here are the tips that i learnt over a period of time from experts here...
  • Test your work before you post.
  • Challange urself for a better solution because after barry being here there is no heights to how much innovative you can get.
  • Fastest fingers first because first one to post first one to get selected is as answer till the time someone else post back which is better then yours.
  • Avoid the topics where you already see an expert participating and things are working out.
  • Keep a eye on kevin and rory when they are online then you need to be quick coz he is damm fast and accurate and to the point.
Saurabh...
0
 
Saurabh Singh TeotiaCommented:
And yeah kevin is sick he just cant sleep...and hey kevin i got your harley picks with me...do you want me to email it across but it wont go because their size is heavy..where i should upload..
0
 
zorvek (Kevin Jones)ConsultantAuthor Commented:
My email doesn't have a size limitation. If you can write the email content without ellipses it will probably go through.
0
 
Saurabh Singh TeotiaCommented:
Roger that sir..will send it across in a day or two.. and you know already that my fingers get struck on the elipses as and when i pass them and you had a opportunity to remove it from my laptop keyboard but you missed it...
0
 
nutschCommented:
Saurabh, I love the "Test your work before you post" right before the "Fastest fingers first because first one to post first one to get selected is as answer till the time someone else post back which is better then yours. " comment.
Bhai, the only thing missing in that sentence is an ellipsis.

@bromy2004, as hard as it might be try to focus on quality of answer before speed. Yes you will lose speed fights with Saurabh, Rory, Kevin and Barry, but you would lose them anyway. It's a hard example to follow, but I think that Brad Y is the standard by which everything gets measured.

Thomas
0
 
zorvek (Kevin Jones)ConsultantAuthor Commented:
And your English still sucks.

>Any tips for increasing points?

If Brad, Rory, or Barry has already posted, forget it. Don't waste your time.

If I have posted, fix my mistakes and you will get the points.

If Saurabh has posted, just post anything in intelligible English with proper grammar, spelling, and punctuation (no ellipses) and you will get the points. It would help if it's a real solution to the problem.

Change your sleep patterns so your waking hours are the same as the Aussie's. They don't know much (too much snake venom and alcohol). Teylyn is the exception but she is really a Kiwi. The only problem with this strategy is most Askers ask during the US waking hours.
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
>> but she is really a Kiwi

I'm not. I just live here. I can stop any time!

>>The only problem with this strategy is most Askers ask during the US waking hours.

Which is why I end up with the gunk questions from Asia, and askers with often less than intelligible prose. Ah, well.

There really are drawbacks to living in NZ. But not many. :)
0
 
zorvek (Kevin Jones)ConsultantAuthor Commented:
Brad's strategy is pretty simple, really: read the question, think about the question, understand the question, work an a solution, test the solution, post the solution with ample instructions so that the Asker actually feels as though the solution is both correct and is implementable. He does this while the rest of us stumble over ourselves posting untested junk for a question that wasn't even asked.

Back in the day when Brad had a boring job and he posted more than once a day, this was a fairly regular occurrence and few if any of us stood a chance.

Want to have some real fun? Tell an Asker something can't be done. Woohoo!
0
 
Saurabh Singh TeotiaCommented:
@Thomas..Lately i'm not testing my work but when i have time thats a practice i always follow... and bhai kevin ko already chidta hai itna ki useha aur tang karneha ka maan nahin hai... ;-)
Okay kevin..I Will start posting in my mother tongue asking author to go to use google translator for conversion a link for it in my signature and in that ways you will never know what i posted ... :-)
Saurabh...
0
 
Saurabh Singh TeotiaCommented:
I like the rory timezone..thats the timezone when i was i used to get lot of questions and no one on..My timezone and Aussies timezone is a bit hard like right now in my timezone its 4:24 AM of the morning and australia will be like 9:00 Am and look teylyn is here from morning or i bet she is insomaniac like me and kevin...
0
 
zorvek (Kevin Jones)ConsultantAuthor Commented:
>I'm not. I just live here. I can stop any time.

You live there you are. Playing a cello doesn't change things.

>There really are drawbacks to living in NZ. But not many.

Like what? Cold in the Summer? Hot Christmases? Boohoo. Look in Washington for what we have to live with. THAT sucks.
0
 
zorvek (Kevin Jones)ConsultantAuthor Commented:
>Lately i'm</A></A> not testing my work but when i have time thats a practice i always follow... and bhai kevin ko already chidta hai itna ki useha aur tang karneha ka maan nahin hai...Okay kevin..I Will start posting in my mother tongue asking author to go to use google translator for conversion a link for it in my signature and in that ways you will never know what i posted I like the rory timezone..thats the timezone when i was i used to get lot of questions and no one on..My timezone and Aussies timezone is a bit hard like right now in my timezone its 4:24 AM of the morning and australia will be like 9:00 Am and look teylyn is here from morning or i bet she is insomaniac like me and kevin

blah, blah, blah. Shoot me, please.
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
It's not cold in summer. You just have to remind yourself every once in a while that summer now takes place from December to March.
0
 
Saurabh Singh TeotiaCommented:
Lol...With your potato gun..??
0
 
zorvek (Kevin Jones)ConsultantAuthor Commented:
"Lately i'm not testing my work but when i have time thats a practice i always follow"

You might want to stop posting before you really get yourself in a pickle.
0
 
bromy2004Commented:
haha,
Thanks for all the (sorta) answers.

No need to change the waking hours to Aussie, Already there. (Western Australia)
Maybe that explains why i cant get 20k points a day...too much snake venom eh.

And i would normally get 100-125 Q's a night and only 20 or so during the day
0
 
zorvek (Kevin Jones)ConsultantAuthor Commented:
>It's not cold in summer. You just have to remind yourself every once in a while that summer now takes place from December to March.

How do you deal with Christmas? Dang, between Saurabh's gobbledygook and these jacked opposing hemisphere realities I'm getting nauseous.
0
 
nutschCommented:
>How do you deal with Christmas?
You just remind yourself that the only reason that Xmas is in December was to preempt the pagan winter solstice celebrations and you celebrate it whenever you feel like it.
0
 
bromy2004Commented:
Aussies are at 7 AM atm.

Classic Kevin
> Cold in the Summer?
Summer is the hot months :D

@Teylyn
> You just have to remind yourself every once in a while that summer now takes place from December to March.
Isn't summer Dec to Feb?
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Christmas is a real problem. Sitting on the beach with a cold beer, barbecue sizzling, skin burning ... and then you have to wear those warm Santa hats! Ughh!

0
 
bromy2004Commented:
Those santa hats, made by some crazy in America,
i was under the impression that new zullund is colder that Australia, with all the mountains with snow and all that.
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Bromy, by NZ definition, yes, but weatherwise, March counts as summer for me. It's often hotter than December.

Also, going by the sun, summer is technically from midsummer, 21-Dec, to equinox, 21-March, but that is too complicated for the Kiwis. They've asked barry for a formula to find the first day of December and the last day of February in any given year from now to 2150 A.D., and they were so impressed by the speed and accuracy of the answer that they've implemented these dates as the summer boundary dates by law.

0
 
zorvek (Kevin Jones)ConsultantAuthor Commented:
Oh! I know how to score points!!! Ask a question in the "Excel Zone Expert Discussion" thread about how to score points and while we're all talking about tweaky stupid stuff, go off and have a field day!
0
 
bromy2004Commented:
Good point Kevin...OOOHH....LOOK...A distraction!!
0
 
Saurabh Singh TeotiaCommented:
And bromy..Just to add if quickee is back working..then thats the best place to answer first because it makes life easy a lot..i miss quickee so much that im not able to keep up at the moment with EE and other things because i just can't tap of new questions...
Wayne..If you are hearing this...please fix quickee i need it...
0
 
bromy2004Commented:
And FYI, my first name is Nathan, bromy is a nickname
0
 
byundtCommented:
Excluding "roll of the dice" easy questions (where speed is everything), you ought to be able to get points on half the questions you tackle. Don't bother posting a "me-too" suggestion. Ignoring those questions will improve your batting average, and give you more time to work on the trickier ones.

Kevin's tongue in cheek description of my approach to answering questions is certainly my ideal. I like to give a complete solution with my first post. Subsequent posts are for situations where the Asker changes the question focus or because he can't apply the suggestion directly to the real workbook. I try to anticipate this latter possibility, with varying success.

I've given up asking clarifying questions. By the time the Asker responds, two or three other Experts have already posted. You are better off making your assumption clear and showing how to modify the solution if different conditions obtain.

Brad
0
 
Chris BottomleySoftware Quality Lead EngineerCommented:
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

Does that mean I can't winge about Teylyn?, ... everywhere I look there you are.  You're more of a scourge than Rory, Kevin & Saurabh ... put together ;o)

(I hope the kids settled ok and for being a little nice will you please not scrutinise my grammar I know it's horrible!)

Chris
0
 
DaveCommented:
Nathan, give up.
If the timezone wasn't bad enough, we've got an early rising, sleep deprived kiwi flogging the points that rightfully belong to you, me and Wayne (but not that ellipse guy ......)
0
 
Rory ArchibaldCommented:
I suppose I should apologise as I may have had a hand in steering teylyn this way... :)
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Chris: Oh, you can winge all right! And you can rest assured that (paid) work will soon get in the way of my daytime posting. And my beginner's luck will have to come to an end soon. Now that everyone's back from California, Richard Schollar is re-instated, bromy and broomee ever pushing the boundaries, etc. things are getting harder.

We may need a campaign to lure more askers to EE. Compared to other Excel web forums, the number of questions here is not very high.

I'm amazed at the variety and the bandwidth of asker knowledge. Some askers apparently can hardly enter a sum() formula without breaking their index finger on the Enter key. Others offer 123.5 points for a job that would cost them thousands of dollars or euros for a paid consultant.

But getting back to Nathan's question: I guess it also comes down to how well you understand the level that the asker is at.
I scored a question today, where the first comment from someone else was just "use vlookup" (or some such). For me, it was clear that the asker belonged in the "index finger danger" category, so I put in lots of short sentences, with short words and explanations and stuff. It was basically the same answer, but I got the points, because the asker could understand and relate.

So Nathan, let's roll up EE from down under. I think there are a few experts in our area that don't quite fit Kevin's categorisation ("they don't know much"), and if we work a bit harder, we may be able to prove Kevin wrong.

cheers, teylyn
0
 
DaveCommented:
If teylyn can drum up a UK dopplelanger then I'll call it even.
0
 
DaveCommented:
>  Compared to other Excel web forums, the number of questions here is not very high
If you go back to 2003/04 we used to have congrats thread when people hit the top 15 or so after a year of contributing. With an earth shattering 50K points.
This was the era of the 20 and 50 point questions at 10 questions a day. People would sell their mothers for a 200 point question. Ok, I exaggerate ..... their grandmothers.  The environment was just a little competitive.
0
 
Wayne Taylor (webtubbs)Commented:
It must be time for me to go to sleep, cos I read "sleep deprived kiwi" as "sheep deprived kiwi" :)
0
 
DaveCommented:
ROFLMAO !!!!
That's gold :)
 
0
 
Rory ArchibaldCommented:
>>"you can rest assured that (paid) work will soon get in the way of my daytime posting"

but once you get kicked out of EF for repeatedly mentioning Simon's forum, you'll have more time to spend here! :)
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Wayne, ROTFL!!

Dave, I can't believe people feel I'm hogging the site when I delete most of the Qs in my email notifs before even opening them. I leave all the juicy ADO, .NET, ODBC, Access, SQL stuff and all but the simplest VBA things to the pros. My attempts cover the more pedestrian questions, and I only get a foot in the door if it's 3am in the UK and rory and barry are safely tucked away in bed. Or if it's charts. I've noticed that there's no real charting wiz here, so my virtual apprenticeship with Jon Peltier and Andy Pope seems to pay off.

Dave, what's a dopplelanger ? .... (sorry, Kevin) - Oh! I think I know what you mean! But, no, I don't think we need another UK based Über-Genius. Rory, Barry, Richard are already covering that territory nicely, thanks.

Rory, c'mon! I signed up at EE long before you did! Then again, Yes! Do blame it on Rory. I read in his MS MVP profile that he favours EE, so I came to have a look, found my old sign on and started posting.

I only wish that broomee will pick up speed. There's way too much testosterone in the air here!

cheers, teylyn
0
 
Patrick MatthewsCommented:
Speaking of Kiwis...

cyberkiwi, http://www.experts-exchange.com/M_5782761.html

In less than four days, he has racked up a staggering 95k points, and in a most impressive expanse of zones, including Excel.

Patrick
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
maybe it's demazter or a3 posting with an alias ....
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Rory,

>>but once you get kicked out of EF for repeatedly mentioning Simon's forum, you'll have more time to spend here! :)

For one: that won't mean there will be more questions here that I could solve

and two: some would-be internet entrepreneur will not prevent me from speaking my mind or recommending a site I find worthwhile. There are plenty of links to other sites on EF, so I don't see why linking to the Cage should be different. "Elvis" is a total failure, both as a businessman and as a forum owner, AFAIC.

0
 
DaveCommented:
> I leave all the juicy ADO, .NET, ODBC, Access, SQL stuff

Its like eating the wagyu beef and leaving the zucchini :)
0
 
nutschCommented:
I'm leaving the zone for three weeks, that should help Nathan a bit.

I'll be missing you, but not too much (vacation time)

Thomas
0
 
Saurabh Singh TeotiaCommented:
Thomas,
Have fun..Enjoy your vacation buddy..Bhai..Masti time...
0
 
Tommy KinardCommented:
I’ll be breezing through on occasion, keeping it fun :D
0
 
DaveCommented:
Great to see you back Tommy  - regular would be better than occasional :)

Dave
0
 
Tommy KinardCommented:
Hi Dave nice to see ya again!

Looking through some of the topics I see 2007 is getting to be in high demand. It's been 3-4 years and I am a little rusty so I will have to take it slow. What's funny is now I actually use Excel quite a bit, not just coding in it. I sure am glad we can post workbooks now!!!

I see a lot of people I remember are still here.

Well I gotta get back at it, I'll see ya'll in the next thread!

dragontooth

0
 
TracyVBA DeveloperCommented:
>>I only wish that broomee will pick up speed. There's way too much testosterone in the air here!
I know, you and I are it, where are the rest of the girls?

Adding to the discussion, I only answer questions where there are 0-4 comments, if there's more than that, then chances are it's already been answered and the asker is being lazy about closing it.  Occasionally I'll look at older questions (over a day) and see if I can help on any of those, usually not though.

I'm in the USA EST (NY) so there's plenty of questions if rory, barry and saurabh don't get to them first.  Sometimes it's slow though, so I'll do clean up instead, until someone posts another question.
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
You go, Girl! Let's show them!

When I go online in the morning, I first go through the comments to my participated threads, then I scour the list for charting or formula questions. After that, I'll take a pick at Qs with less than 3-4 answers, just like broomee. More often than not, there's not much to be had, so I'll wait for the Indian sub-continent to wake up (OK, Saurabh is always awake), and try to make sense of their interpretation of English.

There's not much coming in during the NZ business day, but it picks up again at (my) night time, which is why I still stay up past midight.

Then there's the "clients" you have attached to. With some askers, I feel there's a kind of rapport, or at least a history of PAQs. My favourite charting client at the mo' is Bright01. I know the subject matter, and I think I understand what s/he wants. It's a pleasure working on these Qs, even if I spend waaaay more time on them than on a Vlookup or Sumproduct quickie.
0
 
Saurabh Singh TeotiaCommented:
teylyn,
I try my best to be as clear as i can be but i guess im still lacking behind when it comes for intperatition of things in english...And im cutting down my hours here...normally im here for 12-14 hours not like earlier which was 18-20 hours....I dont know what's wrong with me i just need sleep of 4 hours...thats it
Saurabh....
0
 
Saurabh Singh TeotiaCommented:
Anyways im on break for 2 days...on a company offsite no internet nothing ... :-(
Saurabh...
0
 
DaveCommented:
Don't you have numerous iphones S?
0
 
Saurabh Singh TeotiaCommented:
I do... but i dont access internet over iphone because i prefer to be offline for sometime :-)
0
 
Wayne Taylor (webtubbs)Commented:
I've recently got a little carried away in another non-required project while I've been waiting to fix QEE, and it's finally done.

It's a Sidebar Gadget for EE which can retrieve your Filters and filter results from EE, and periodically retrieves new questions.

It's available for download at http://www.webtubbs.net/EE/EEFilters.zip

Before you use it, note that gadgets use the IE engine, and as such the gadget requires you to be logged into EE with IE. It's a limitation I was trying to overcome, but it would appear that javascript doesn't allow it.

Wayne
0
 
Patrick MatthewsCommented:
BTW gang, I'd like to see your thoughts re: mass conversion of Office files:

http://www.experts-exchange.com/blogs/matthewspatrick/Convert-Office-2003-files-or-leave-well-enough-alone.html
0
 
Harisha M GCommented:
Hi all :-)
0
 
zorvek (Kevin Jones)ConsultantAuthor Commented:
Who the hell are you?
0
 
Chris BottomleySoftware Quality Lead EngineerCommented:
OH NIce ... there's welcoming :o)
0
 
Harisha M GCommented:
Great Kevin, you still have insomnia!
0
 
Chris BottomleySoftware Quality Lead EngineerCommented:
And he's not alone these days there's a ton of them about on all continents .. not that that makes a difference with insomniacs!

Chris
0
 
zorvek (Kevin Jones)ConsultantAuthor Commented:
Harris, is that really you? Did you ever find a woman?
0
 
Harisha M GCommented:
Chris,
Yes. I need to watch out :-)

Kevin,
Not again..
0
 
Patrick MatthewsCommented:
Harish,

You're back!  I've been wondering about you!

Patrick
0
 
byundtCommented:
Not only is Harish back in this thread, but he's already answered eight questions in six different zones just in the past two days. Some things never change. Welcome back Harish!

Brad
0
 
byundtCommented:
For the benefit of the newer Experts in this thread, mgh_mgharish in 2005 to 2006 filled somewhat of the same role as saurabh726 does today--brilliant and everywhere, answering questions at all hours of the day and stimulating a lot of discussion. There weren't as many questions to answer in those days,so points were harder to accumulate, but there is no doubt he would have been a strong candidate for Microsoft MVP Award had he still been participating in 2007 when six were honored from the Excel Zone.

The other really neat thing about Harish is the fact that he tried to answer questions in as many Zones as possible. He had points from over a hundred in 2006--and that was before the explosion of new Zones, crossposted questions and filters to find them that made such an accomplishment easier for the polymath. He did what AngelIII still does--review every new EE question to see if there might be something intelligent he could add to the discussion.

If memory serves, Harish was about a year away from finishing his undergrad degree. So should we be addressing him as Dr. Harish now?

Brad
0
 
Harisha M GCommented:
I'm glad to know that you all still remember me.

Brad, I'm not a doctor, but an engineer :-)
What you've said above seems a bit overdose.. Certainly I was not in a level to compete for MVP award..

I completed my engineering in 2007 and am working from the past two and a half years. EE was taking too much toll on me at that time.. So I had decided to keep it away for some time.

Although I'm back, I don't think I can excel in Excel zone now. Reason is simple: I don't use it now, both at workplace and at home.
Also, the number of posts I can answer will also be less... because, as I saw from some discussions, Tubb's QuickEE doesn't work in Linux :-(
0
 
byundtCommented:
Harish,
My reference to Dr. was contemplating a PhD degree, not MD http://www.cse.iitk.ac.in/acad/adm_phd.html  You are certainly smart enough.

Brad
0
 
zorvek (Kevin Jones)ConsultantAuthor Commented:
Except for his men never landing on the moon conspiracy theories, Harish is an OK guy. Except he seems to have the same affliction affecting his period key as Saurabh.
0
 
zorvek (Kevin Jones)ConsultantAuthor Commented:
Check it:

   http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_26206643.html

Ya gotta love his rapid fire tenacity. Yes, he does remind us of Saurabh ;-)
0
 
Harisha M GCommented:
LOL! As I told before, I don't have excel to test what I post. And mistakes do happen..
0
 
DaveCommented:
Bah. What engineer never uses Excel.
0
 
Saurabh Singh TeotiaCommented:
Hey...Harish...welcome in...These guys have always talked about you..but though never got a chance to meet u...where u from..?? And ignore kevin he is always like that...actually u know what he loves us too much people from this part of the world that he cant live without paying too much attention to we guys .... :-)
By the way which part of India you from..?? and i hope u speak Hindi..?
0
 
Harisha M GCommented:
Dave,
I don't use :-) Problem is, in office, during recession, instead of buying new licenses of the latest Office suite, they installed OpenOffice.. So I don't use Excel anymore.. And in home, I don't even have Windows installed right now!

Saurabh, I'm from Sagar, Karnataka (near Jog falls). My mother tongue is Kannada, but I can comprehend (and speak a little) Hindi.
0
 
Saurabh Singh TeotiaCommented:
Ahh nice...man i dont know anything about kannada...Im from delhi...whenever you are here this part..feel free to call in...
0
 
Harisha M GCommented:
Saurabh, Sure, Thanks.

Kevin, now I know why you were relating us regarding period key :-)
0
 
zorvek (Kevin Jones)ConsultantAuthor Commented:
Thank God you guys don't have a common language! I had a nightmare last night where I was reading a bunch of Hindi/Kannada crap riddled with ellipses!!!!

Now, you two take your bromance to a room and leave the big boys to their work.
0
 
Harisha M GCommented:
Kevin, still we can converse.. ¿¿ ¿¿ ¿¿¿¿?
0
 
Harisha M GCommented:
OOPS.. When did EE go back to non-unicode format??! I was typing in Hindi... hai na saurabh?
0
 
zorvek (Kevin Jones)ConsultantAuthor Commented:
Where's my gun...
0
 
Saurabh Singh TeotiaCommented:
haan harish...kyunki i can use words which are easy for u to understand...aur kevin ka dimaag ghoom jayega poora...hahahhaa
0
 
Rory ArchibaldCommented:
If anyone has time, could they look at this: http://www.experts-exchange.com/Programming/Languages/SQL_Syntax/Q_26213669.html
as I have to deal with family stuff for a few days.
It's Access/Excel based, so sounds right up Patrick (M)'s street. :)
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Hey Rory,

hope there's no major trouble in your camp. Hope you'll be back to your usual powers soon.

cheers,

Ingeborg
0
 
DaveCommented:
And he's 99% Savant 1% Genius  to mangle a famous phrase :)
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Congrats to Rory on the overall SAVANT! I'm watching closely for the Excel TA Savant!! Can't be too many days off.

0
 
Patrick MatthewsCommented:
Rory,

I'll take a look a little later, but IMHO what the Asker is asking for is crazy.  I would never want a function that is
continually going out to an Access data store and updating itself :)

Patrick
0
 
Rory ArchibaldCommented:
I reckon it will only be about 2 weeks before teylyn hits Genius... :)
0
 
barry houdiniCommented:
"....teylyn hits Genius..."
Which one? I'd pay to see that.....
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Congratulations to Rory for achieving Savant in Excel.

What a performance!
0
 
DaveCommented:
Brilliant work Rory - a huge milestone.

Congratulations!

Dave

PS - does this mean you go on sabbatical now as per our resident douche? <ducking>
0
 
Patrick MatthewsCommented:
0
 
cyberkiwiCommented:
I guess it's time to drop by such a thread and say hi.

There, done.
0
 
DaveCommented:
> Which one? I'd pay to see that.....

i'd missed that, but got a late chuckle.


0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Cyberkiwi,

glad to see you here! High time, I'd say! I feel quite awed at your accomplishment of winning the running record for achieving overall genius points. Less than 40 days - sheesh, bro! Can you breathe a bit easier now? I guess it'll take quite some time untill someone will top that.

If you've read this and the previous threads, you'll find we're quite relaxed here. Not much protocol to follow, so just lean back and talk if you feel like it.

--------------- new post -------------------- (just saving the postage)

I'm currently attending the Sharepoint 2010 Conference in Wellington. The first day of speeches and presentations is over. I sent myself a fake email to make my mobile buzz, so I had an excuse to leave the conference room during the after-lunch session. It was a last resort. People left, right and center were already asleep. I don't envy the poor speaker who has to take on the after-lunch crowd, but then, they *could* have chosen a livelier topic.

After that, and after a couple of strong coffees and a few Danishs,  things went straight uphill again. I somehow won the draw for a 1 TB USB drive -- Just in time for managing the megapixels hubby produces with his new Nikon digital SLR. All excited, I rang hubby, and after I had explained to this non-computer person what the general idea of an external drive is  and what it's good for, he says "Great, now I can go for RAW instead of JPG!"

Hmmph.

The draw itself was a funny affair. All the entries were business cards or pieces of paper with contact info in a glass jar.

The Organizer pulled a card - only to discover that it was his own business card.

So: no go, redraw.

Second winner was drawn and announced, but s/he was not present. Tough. No presence, no prize.  

Third try. "Here we are: A yellow card: XXXXYYYY company." (my ears and all my coleague's ears from xxxxyyyy start to prick).

Then -- a lengthy pause -- while the lucky draw fairy-man turns the card upside-down and right-side up again, making feeble attempts at pronouncing what he thinks is the name of a living person. Before he has it out, I know. "That would be me!" I said.

My first name is Ingeborg. Those who are linked-in with me will know that my last name is a bit more challenging to English speakers, and can be quite a mouthful.

I just LOVE it when I win a prize and they can't even tell who won it. So far, it has happened for an Office 2007 Prof package last year, and now this HP USB drive today. Sometimes I wish my name was easier to pronounce for the Anglo-speakers. But in moments like these it just drives anticipppppation to a maxx.

If hubby leaves some room, I'll d/l all of rorya's accepted answers to study and learn.

cheers, teylyn







0
 
byundtCommented:
Teylyn,
Is the third letter of your family name pronounced like a vee? Are there any other traps for the unwary Anglophone?

Brad
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Brad,

how would you know about my last name?

Phonetically, you'd go: 'haa-vick-horst -- with the stress on the first syllable.

"W" in German is like a "V" or soft "F" in English.

The name means "Hawk's nest" (or hawk's lair) and is a bit more interesting than my "maiden name", which was a legacy of poachers. (Now I challenge you to find out my maiden name. Send me an email if you do).

I came upon my "maiden name" again today, when I submitted my passport renewal application at the German Embassy, between Sharepoint agenda item #1 and #2. Good timing for the Sharepoint Conference!

In a small place like NZ, you've got to take what you can get, as soon as it is available.

cheers, teylyn
0
 
Rory ArchibaldCommented:
Does it start with an H?
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Mr R.A.,

does *WHAT* start with an "H"? You know my family (married) name (as will anyone else who reads this thread, now), so, are you referring to my birth name? Drop me an email with your best guess.

Other than that, I don't feel I'm worthy of communicating with you until I've passed the Genius threshold. But since my company has just graced me with a new role, which requires that I actually spend some time on work issues during work hours (which is fair, seeing that they pay me for it), I'm afraid that I won't quite get to that level until the end of June.

cheers, teylyn

0
 
Rory ArchibaldCommented:
Email on its way now. :)
And we can still talk - I don't have a Genius cert either. ;)
0
 
DaveCommented:
> I sent myself a fake email to make my mobile buzz, so I had an excuse to  leave the conference room during the after-lunch session.

<Applause>

That's a nice variation of getting the friend to ring. Will certainly use that in future with an email on time delay
0
 
cyberkiwiCommented:
This is less cumbersome than an email.
Where I live, if you dial 112 (don't even have to unlock any phone!) then hang up, they will call back.

Easy pie.
0
 
DaveCommented:
An interesting one re number formats for GB, MB that requires an adjustemnet for the 2^10.
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_26249039.html?cid=1576

 I think its impossible to do a insitu with a custom number format such as
[<500000]#,##0.00" B ";[<500000000]#,##0.00,," MB";#,##0.00,,," GB"
lifted from elsewhere given the need for the 2^10 conversion

Any takers?

Dave

0
 
DaveCommented:
Nice trick on the 112 cyberkiwi, and welcome to the EEEE forum :)
0
 
Patrick MatthewsCommented:
Gang,

Please have a look here: http://www.experts-exchange.com/blogs/matthewspatrick/B_2536-Documenting-VBA-Projects-in-Excel.html

As the blog post explains, it contains a file with code that will list the procedures, user defined types, enums,
API declarations, and references for selected workbooks.

I'd love your feedback and assistance with testing; I will eventually turn that into an add-in with an accompanying
article.

Patrick
0
 
Rory ArchibaldCommented:
Quick question before review: does it do something that MZ Tools doesn't? (that's an actual question, not a suggestion there is no point!)

PS I love your article #47 about EE points. VERY TRUE! :)
0
 
Patrick MatthewsCommented:
Rory,

Great question about MZ Tools; it had been so long since I used it (last time I installed it was a couple of
computers and several crashes ago), it had completely slipped my mind :)

Basically, you can get more--much more--from the XML Documentation routine in MZ Tools.  That said, if
what you want is more on the order of a somewhat simple flat list, the output from my routine will be easier
to work with.

My routine also offers some filtering options that MZ Tools doesn't.  For example, MZ Tools will run the
documenter for all open workbooks while mine lets you choose; MZ Tools will document essentially
everything in the modules while mine lets you choose what to return.

MZ Tools also does not pick up the API Declarations.

So, I would agree that MZ Tools does the more complete job, but for some tasks, the flat list my code returns
may be more suitable.

Patrick
0
 
Rory ArchibaldCommented:
OK, thanks. Will take a look later. (when I'm soberer)
0
 
Chris BottomleySoftware Quality Lead EngineerCommented:
Patrick

As a first step, you have an Excel application here, I have been experimenting with a simple, (as in simplistic) means of making code run in any VBA application, as such it seems to be working ... I have used it for years between word and excel and have extended it further recently.

As such there may be some benefit in enhancing your code so that it will run on all applications, (outlook is beyond my method though).  I was thinking about about putting it up as an article even though it would have limited application.  

Interested?

Chris
0
 
Patrick MatthewsCommented:
chris_bottomley said:
>>Interested?

You bet!  How about we move the discussion over to the blog so we don't clog this one up.
0
 
Brad Sims, CCNANetwork AdministratorCommented:
I'm sure this is an easy fix, but I don't have experience with QueryTables.  Would someone mind taking a quick look and helping this person?

http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_26256592.html
0
 
Chris BottomleySoftware Quality Lead EngineerCommented:
A quick question for any of you Mac types, Brad for instance ... with the coming of Office for MAc 2011 and VBA support re-introduced is a mac laptop a better purchase than a PC - would be general internet/mail and VBA development I guess VBS isn't possible ... that's not a big loss obviously.

I realise I could ask a question formally but I trust you folks to have a similar perspective to me.

Chris
0
 
byundtCommented:
Chris,
I haven't seen Office 2011, but if it is anything like Office 95, Office 98, and Office 2004 (which I did use and which do support VBA) you are apt to be more pleased with Office 2010 run under emulation. The VBA IDE for the Mac in Excel 2004 is similar to what we had with Excel 97. I fire up the Mac versions of Excel only to help my wife and daughter, or to answer questions on Experts Exchange. For daily work, I use Excel 2003 run under emulation (using Parallels & Windows XP). It's very snappy, and has the user interface that we power users have come to expect.

Microsoft treats Windows versions of Office as being business tools, with numerous hotfixes and service packs over the useful life of the product. Macintosh versions of Office are treated as consumer products, with very few hotfixes and only one or two service packs. Their support policy is described here: http://support.microsoft.com/gp/lifepolicy

I paid the extra money for the Apple because of its construction quality. Everything really does "just work." To illustrate, I always use a mouse with PC laptops because the trackpad is prone to "falsing" (moving the cursor when I least expect it). With the Mac, I have never seen such a problem. With my two previous PC laptops, I wore the letters off some of the keys after six months, and wore a hole through those keys after three years. With the Mac, the keys show no wear after 18 months use. The two PC laptops I used both died (motherboard failure) about six months after the warranty expired. I expect the Mac to continue going strong years after I want to replace it with a more powerful model.

I took my Mac to the MVP Summit in 2009. I was amazed at how many Microsoft employees were using Macs. They all ran Windows, and must have picked the Mac for its construction quality.

For other applications outside the Office suite, I am very pleased with what is available on the Mac. On average, the applications seem more polished and have more consistent user interface than we are used to on Windows. And it really is true that you don't need anti-virus software (and the two to three hours a day it needs to run a virus scan).

Brad
0
 
Chris BottomleySoftware Quality Lead EngineerCommented:
Thanks, i'm not yet commited but all information helps ... and the reference to MS employees is enlightening!

Chris
0
 
Patrick MatthewsCommented:
Gang,

Probably easy, but I can't figure it out:

http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_26266677.html

(Summing Xth column of an array returned by a UDF)

Patrick
0
 
Rory ArchibaldCommented:
Smart Alecs 1 and 2 have already reported for duty on that one. ;)
0
 
Patrick MatthewsCommented:
Rory and Richard,

6 minutes to an answer?  What a couple of slackers!

Double :)

Patrick
0
 
Rory ArchibaldCommented:
I admit it - I've been cheating on EE with other forums. :)
0
 
DaveCommented:
I hadn't realised there had been some changes at EE admin, that is a shame

From Jenna's linkedin comments


jenna.png
0
 
bromy2004Commented:
I'm not sure if there are any other clean-up volunteers on here, but has anyone noticed there aren't any questions left in the Excel Zone?
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
I guess that's on account of the Excel zone broom. She sweeps regularly and she makes short work of things.
0
 
Patrick MatthewsCommented:
Don't discount your own contribution there, teylyn.  You both have been doing a terrific job!
0
 
Chris BottomleySoftware Quality Lead EngineerCommented:
Seconded.
0
 
Rory ArchibaldCommented:
Ditto. You are all very selfless. :)
0
 
Ardhendu SarangiSr. Project ManagerCommented:
I am predicting a new genius will be joining us this weekend :)  Anyone would like to bet on it?


BTW, Happy Fathers Day to all the Dads out there!
0
 
DaveCommented:
> Don't discount your own contribution there, teylyn.  You both have been  doing a terrific job!

Its the quick clean-up of the new questions that worries me

<jesting>
0
 
Chris BottomleySoftware Quality Lead EngineerCommented:
Re: http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_26272941.html

And they say the  excel zone is very competetive ... can't see it myself!

Chris
0
 
Harisha M GCommented:
Yeah, and the problem is, everyone posts comments, except the authors ;-)
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Chris,

LOL.

It's hard enough with the google monkeys falling over each other, but the challenge has some added twists when the real guys throw the gauntlet. When the bits and bytes have finally made it to NZ, before the kiwis even have a chance to post, the question has already been answered twice or more from around the rest of the world, and the kiwis look like the worst of the copy cats (except for cyberkiwi, who seems to be using a proxy outside of NZ).

Humphhh!
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Harish,

>> everyone posts comments, except the authors ;-)

this is one of my pet peeves. The most difficult questions seem to be flaunted in two-sentence statements, with experts coming up with all kinds of ingenious and brilliant ideas, only for the original asker never to return.

As a CV, sadly, I see quite a lot of that. Often times, I have to suggest a "Delete with no refund" , but whenever I have enough wits to grasp the nature of the question and the ensuing answers, I will always recommend an accept or a split rather than a delete.

EE has quite a different kind of clientele compared to other Excel online communities. The askers here are often only interested in a turn-key solution rather than in learning how it works.

So, very often, efforts to educate askers are completely futile, as long as you can provide the formula/code/link with the solution to their immediate problem.

It also means that askers are less inclined to search for a previously published solution to their problem before posting. The attitude seems to be: "I pay, so you deliver, and you better be quick!"

Many askers don't seem to be aware that the experts are not paid for their contributions on EE.  The other day, when I mentioned in a comment that I needed some ZZZZzzzz before continuing, because it was way past midnight where I live, the asker said, "fine, this is really a long day's work for you". I think s/he believes that we do this full time and for payment.

Now, if I could get EE to pay me enough to keep my family in bread and butter and some jam/ham, then I'd probably seriously consider it. I'd even upskill to include Access and SQL if need be. But I don't think EE will be able to keep thousands of Experts as paid consultants.

This would take the fun out of the whole answering thing, too. I fell that EE needs to make it clearer that the answers here are all delivered by unpaid volunteers. Lately, I've come across quite a few askers who seem to claim a right to a perfect solution, just because they pay EE a subscription fee. Even though the askers are barely able to construct a legible sentence.

So here's another disparity: askers get away with almost anything. Bad grammar, bad spelling, no punctuation whatsoever in a 5 line paragraph. Experts, on the other hand, are expected to deliver perfect solutions, ready to copy and paste without modification, and if one single comma is out of place or a closing bracket is omitted by mistake, then that is enough reason for the asker to reject the comment with "it's not working".

I wish there were some guidelines for askers to adhere to a minimum standard of communication.

</rant>

teylyn


0
 
Harisha M GCommented:
teylyn, you rant is not working opening <rant> is missing :D
0
 
DaveCommented:
teylyn,

You've reached the third stage of the EE experience - disenchantment.

Things look up once you get to cynicism. Even better once you reach acceptance :)

I think the bulk of the long term Experts would have experienced similar sentiments. Typically it is manifested in backing off from the intense levels that high accomplishing newcomers (such as yourself) start their EE interactions , whether boredom from handling infinite amounts of two variable SUMPRODUCT requests, or simply engaging in questions that look more interesting.

I think you are right that EE has a answer-focused clientelle compared to the more knowledge sharing approach of other forums. That goes hand in hand with the paid model, Askers here are paying for answers, not for shared learning

Cheers

Dave

0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Harish,

Didn't you know that Rants don't have to be declared with an opening statement? They just evolve from the context, grow and grow with every line of prose,  and when the red/black/angry hovering cloud is dark enough and threatens to burst, they just need to be closed.

Formal closing of a rant is optional. It can be flagged with a </rant> closing tag (as a pure courtesy to fellow readers), or just by hitting the submit button and feeling better for letting it all out.

The lashback will come with the comments from the peers.

cheers, teylyn

0
 
Harisha M GCommented:
teylyn, :-)

Add to what Dave said, being the "Grand Tourist of EE" as Brad had described me once, I see that the Excel zone is the best one I've come across. Credit should go to everyone and more to Brad for nurturing everyone here.

As you may be knowing, in other zones, I see a lot of comments which completely distract others from the original questions, and as you said, the askers who don't even think about what could be wrong, and say it's not working, are a pain. First, the question itself will not be clear. Second, if a clarification is needed, the author doesn't provide it soon. Third, after a long thread, we see that the question is abandoned. And about the learning, yes, authors don't seem to be interested in that. But experts do learn :-)

Also, I had a small goal in mind when I returned to EE: Get past 200 zones before Kevin (who was at 199) gets there. I did it today ;-) It's sad that Kevin isn't posting actively nowadays, but I'm happy to accomplish my goal at least :-)
0
 
DaveCommented:
> Credit should go to everyone and more to Brad for nurturing everyone  here.

100% concur with that.

> But experts do learn :-)

And that
 

0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Harish,

with the zone count, you've just introduced me to yet another aspect that can be tracked in the statistics.

Off to update the spreadsheet ....

Just joking.


Dave,

I think I hear what you're saying. I'd like to see a full list of EE stages, though, for the statistics, you know?  :-))
I must confess that over the last few weeks I've been ramping up my participation, seeing that the next Excel T-shirt is just a few dozen K points away. I'm sure I'll be able to exhale and take things a bit easier after that milestone has been reached. But then, it's really fun to work here! We give real solutions to real problems in the real business world. People have a pressing problem, find an answer here and get on with it.

I'm happy to be part of this.

cheers, teylyn
0
 
DaveCommented:
Hows this?

  • intrigued
  • obessesed
  • dis-enchanted
  • cyncicism
  • regrowth / dormant account
for the former path
  • acceptance
  • targeted involvement
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
So, according to this, where does rorya sit??? Methinks a category for his state has not yet been named. :-))

I do agree with the progression of the first three to four, though. Spot on! I can see parallels in other forums, too.

Will be able to tell you about my feelings about the next stages over the coming years.

cheers, teylyn
0
 
Rory ArchibaldCommented:
I think I revisit all those stages daily (perhaps several times each). That's why I use multiple forums - it was my first period of disenchantment that happened to lead me to Mr Excel for example. :)
0
 
DaveCommented:
Eric,

Well said.

DB.
0
 
cyberkiwiCommented:
I hear mention of me in http:#a33030570 so I dropped by.
>> except for cyberkiwi, who seems to be using a proxy outside of NZ).

In fact, I don't. At least I don't believe so.  Just regular broadband like everyone else in NZ.

Today I checked periodically to see you [teylyn] everywhere on duty extra time. [working hours even!]

Go All Whites.  Italy never deserved their penalty.  An Oscar for performance maybe.  Penalty, no.
0
 
DaveCommented:
>  Italy never deserved their penalty
At least in happened to you in the group stage - Australia got screwed in the elimination round by another Italian dive in 2006

NZ nearly won it outright, fantastic shot from the striker went just wide in the last 5 minutes. I stayed up to 2am watching it. Paying for it now as I my 5th coffee of the morning.

0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Eric, you make me smile!

cyberkiwi, you clearly don't live in the wops! "everyone"?  I wish. But since swapping the rural BOP for the urban part of the 'Naki, things have gotten a bit better.

And I wholeheartedly agree with your position on Italy and the penalty. They're such good actors. Unfortunately, watching a game at 2 am does not do much for concentration the next morning. So, since I'm not good for work much today, I'm checking the community and giving wrong answers to perfectly easy questions.
0
 
patrickabCommented:
0
 
byundtCommented:
I was able to repair the file in Patrick's thread http:/Q_26369622.html by saving it in OpenDocument Spreadsheet (*.ods) file format.

I don't know if the *.ods file format is part of the standard Excel 2007 install, or if it was added with Open Office (which I also have). Could someone who does not have Open Office confirm whether the *.ods file format still appears at the bottom of the Save As dialog?

Brad
0
 
Rory ArchibaldCommented:
It was included in 2007 SP2 as best I recall.
0
 
byundtCommented:
I clicked the link for "Help" in the dialog warning me about loss of functionality when I save in OpenDocument Spreadsheet file format. This took me to http://office.microsoft.com/client/helpcategory.aspx?CategoryID=CH100648079990&lcid=1033&NS=EXCEL&Version=12 which gave an extensive listing of the features that would be lost.

So between the Help link and Rory's comment, I reckon that OpenDocument Spreadsheet really is part of the standard Excel 2007 install. And saving a file in that format can be a useful way of removing stubborn file corruption.

Brad
0
 
zorvek (Kevin Jones)ConsultantAuthor Commented:
You guys do realize this thread is closed, right?
0
 
patrickabCommented:
Nope - look open enough to me...:))
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.