LinkBack URL
About LinkBacks
go me....i just got my 1000th rep point
go me....i just got my 1000th rep point
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Congratulations FDibbins. Great work.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Nice one, well done!
My counter ticked past the 1,800 mark at the end of last week and I'm wondering how many more I have to rack up before my "brilliant future" changes into "a reputation beyond repute".
Congrat's, nice one.
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
thanks guys
Congos Sir. Good luck!
Congrats...nice work...
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
...Thanks
Congr. Nice work.
Now next milestone will be the 1500.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
If it's a milestone then next should be 1609.
Or perhapes 1852?
Never use Merged Cells in Excel
Well done! Those last couple of points can take forever, can't they?
Don't those nice round numbers make you feel good?
Kind regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Hi zbor
Yes absolutely!If it's a milestone then next should be 1609.
That I think is more doubtful unless you are a diver of courseOr perhaps 1852?
Alf
I recently hit 1900, and have no idea what my slogan is. I guess I'll find out when I submit this post..
EDIT: Still a brilliant future. Oh well, at least I have that going for me.
felt good to break the 1K mark, the rest will come when they come
@Paul: you can't be far off "a reputation beyond repute" ... whatever that means.
Regards, TMS
Nice
I m getting worried.
What's you reps/posts ratio ?
Rep/post ratio - cool, a new stat to work on.
Mine's <Bill & Ted> 0.69, dudes! </B&T>
@snb: I guess only the individual can know that. Once you've gone off the top of the visible rep scale, no-one else will know. Same for rep/thread count. I would generally say thank you for any rep or feedback, so that's going to half my true post count, if you know what I mean. Then there's the odd high rep from a guru or mod skews it a bit. Who knows? I'm guessing that anywhere between 50 and 60 percent give positive rep, but it could be much lower.
Hmm... For mods/ex mods that ratio is worse since there's lot of you-have-break-rule posts.Originally Posted by snb
Nice
I m getting worried.
What's you reps/posts ratio ?
And noone give rep points for that.
Congrats FDibbins!
Hope that helps,
~tigeravatar
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Yeah, congratulations from me as well - I'm just 4 away from the 1K mark, but posters don't seem to be so willing to click that little star in recent weeks.
Pete
Congratulations FD!, Here's to the next 1000........
Audere est facere
Thanks guys, and yes Pete, I know what you mean...it took days to get those last 2 points
This, as TMS ,....What's you reps/posts ratio ?And also Zbor, saidI would generally say thank you for any rep or feedback, so that's going to half my true post count, if you know what I mean.
depands on..Hmm... For mods/ex mods that ratio is worse since there's lot of you-have-break-rule posts.
And noone give rep points for that.
And something more..
Another case (in some cases this is most obvious), some who have great power, they give (gave) a lot of points with just once.
Remember that it can take days to collect five (say) points and someone else getting thirty cuddly ....Even in the "Water Cooler" section..
I see a lot of braincrushing as a result of a simple question: 'what is your reps/posts ratio' ....:D
1/3 ! Yours?
My ratio is 0.296 (rep/posts)
Pete
2354/7820 = Log2
I can say in my defence that I've never asked someone, directly or in signature, to give me rep points
Very true, my rep/post ratio is so high because I've posted some "funny" things, which have earned me rep from the elders of this forum, who I could never assist with mere Excel problems.Another case (in some cases this is most obvious), some who have great power, they give (gave) a lot of points with just once.
Remember that it can take dys to collect five (say) points and someone else getting thirty cuddly ....Even in the "Water Cooler" section..
The thing is that Andrew's Law* states that the perceived funniness of something is inversely proportional to your expectation that the medium you're engaged with is going to contain something funny.
[* - To be fair I've just thought of this, so it may be a bit keen to call it a "law", but it does explain why we laugh at things in real life that wouldn't even raise a smile if they appeared in our favourite comedy show, or why, if you ever have to give a sermon** you can bring the house down with a few fart gags]
[** - Or a eulogy]
Anyway, since nobody is expecting anything funny on an Excel forum it's easy for me to seem incredibly witty and rake in the rep points, despite the fact I can barely form an IF function.
However, it's a fundamental rule of humans that they adapt their behaviour to match the rewards that the system offers. So now that people have seen my awesome rep/post ratio we'll see an increase in humour on the forum, as posters try to cash in:
Slowly the forum will mutate. At first it will be an Excel forum with a few funny posts, then the number of funny posts will increase, the Water Cooler section will expand while the number of directly Excel related posts decreases, the Excel sections of the forum will decrease and, eventually, will only live on in the names of the sections:
- CLEAN jokes
- RND funnies
- SINful Humor (NO .color=0 jokes!)
- Yo mama's so LARGE
By this time the top posters here will have drifted away, or reinvented themselves as humourists...
...and then I can prey upon the few people who, confused by the URL, have come here seeking Excel help and all of the rep points will be mine!!!
0.34166104
Regards, TMS
@zbor: >>> 0.301023018
Even if you do, I don't believe it makes a noticeable difference. In the early days, I got a serious reprimand from teylyn for what she described as "begging for rep points" ... so now I just try to gently encourage people to rep anyone who has helped them. Hey, we all need our ego stroked a bit, we do this for free!I can say in my defence that I've never asked someone, directly or in signature, to give me rep points
Interestingly, I've had 36 rep points from the last 19 threads from which I have had positive rep ... so, nearly 2 to 1. I have noticed a couple of "jumps" but it's not obvious to me why the OP had such rep power.
Ho hum, another mystery. Maybe I should start telling jokes.
I know log2 is irrational but I couldn't resist
Irrational, illogical, moody ... ? Sorry, I'm missing something ... don't understand.
an irrational number is any real number that cannot be expressed as a ratio a/b, where a and b are integers (as I did).
@ zbor
2354/7820 = Log2 should that be defined as "=LOG(2354/7820;2)" -> -1,73205 or have I missed something?
Alf
2354 / 7820 = 0,30102301790281329923273657289003
log2 = 0,30102999566398119521373889472449
Accurate at 99,99768%
That's why I write log2 and not this huge number
I tried rhyming answers at one point (I've got a feeling you could use CEILING etc.) but that fell down on two counts:Ho hum, another mystery. Maybe I should start telling jokes.
1) I'm obviously not as funny as I think I am.....(and certainly not as funny as Andrew-R)
2) I couldn't find a rhyme for SUMPRODUCT and that sort of scuppered the whole thing
My ratio is 0.419 which is clearly higher than it should be - I put that down to begging for rep points at every available opportunity (please click on the star icon if you find this post even in the slightest bit interesting or amusing - if you don't then please consider clicking on the star icon anyway, you can always give me negative rep.......)
Newer members will also tend to have higher rep-to-post ratios for the mere fact that rep wasn't introduced until a few years after some of us joined. Some of my best work was in the early years, tbh. It's all downhill from here. And I repped Andrew-R just to further skew his humor ratio.
That's what you get for being an "early adopter"rep wasn't introduced until a few years after some of us joined.
Yup.
You should stop posting altogether now.. you have 8888 posts. A nice, round number. Unless your plan is to get to 11111. Which isn't round, but very well aligned.
Thanks for that - that's me sorted for a rolling-náked-in-rep-points night.
Edited to add: Heh, the forum auto-censor wouldn't let me be náked
Last edited by Andrew-R; 01-30-2013 at 04:52 PM.
You can act
as SUMPRODUCT
slow on tract
with great impact
@Paul: re the PM, that should probably have been "infinity and beyond"
Ah, too late, on the way to 9999, 11111 and the rest ...
Regards, TMS
Or so you thought! Posts in this sub-forum don't count!
So, the rumours are true ... EF is stuck in a time warp
Just to bring this thread back to life - looking through the members' list I noticed that Haseeb A has a higher rep than me, with fewer posts.
In fact, his rep/post ratio must be at least 1.02!!!
Speak to us, Haseeb - what is your secret?
@Paul: just broken the 9000 posts and 3100 rep points (merci à DLL) ... so the "raw" sum on this is pretty straightforward
I hope this gets through ... the board seems a little bit flaky this afternoon.
Just to bring this thread back to life, how can you have a good rep/post ratio, if you really try to help(and don't let it to go..) but for an issue like this need 25 posts?
Is this answer correct? "Just don't try to help, if you see that request is not clear"
http://www.excelforum.com/excel-form...est-ifs-2.html
I suppose that, ultimately, the rep/post ratio is pretty irrelevant and I think specifically trying to improve it would be a road of hurt leading to insanity
Anyway, back on topic - a milestone for me this morning, I'm now in the top 20 forum members (sorted by rep). Sorry to Paul, whose #20 slot I stole. More exciting is that there's only one person above me with the "...has a brilliant future" rep status, so I've nearly reached the level of having "a reputation beyond repute"!
I'm not going to let this new celebrity status change me. OK, so my life from now will be whirl of private jets, showbiz Excel parties and phone calls from world leaders, but I'll still make time for you, the common people, and remember that I was once a mere mortal like you (expect more intelligent, wittier, more handsome and always destined for greatness...obviously).
Actually, while I'm on a roll I might give the Vatican a call about the job they've got going. I think Pope Excel I has a nice ring to it
!
Correct!...I suppose that, ultimately, the rep/post ratio is pretty irrelevant and I think specifically trying to improve it would be a road of hurt leading to insanity
Thanks for this..., but I'll still make time for you, the common people, and remember that I was once a mere mortal like you (expect more intelligent, wittier, more handsome and always destined for greatness...obviously).
Also not bad at all to get more than 100 reb-points in less than 20 days(Posts#3 & 13)!
and all that in spite of your dyslexia...(expect more intelligent, wittier, more handsome and always destined for greatness...obviously).
Wow, another stat - Reps/days_joinedAlso not bad at all to get more than 100 reb-points in less than 20 days(Posts#3 & 13)!
For me that is 2.55 today.
Pete
You may mock, but I know that you're scared that I'm roaring up to your rep-point level like a stream train ... or possibly a team stainand all that in spite of your dyslexia...
Yup, just another 8,000 rep points to get and I'll only be a couple of places behind you
We should ask Arlette if she can get the Tech Team to produce some MI ... stop them from bug****** about ... sorry, tinkering with the system
The board has been very poorly for the past few days, or is it my imagination?
Thank you - I will.You may mock
I'm sure you'll catch up in no time, although the rep caps won't help.
Rep caps?
Are you saying that there's a limit on how much rep you can have, or do I just get sent a cap to wear with "Reputation beyond repute" written on the brim?
No I mean that the amount of rep awarded by some of the more senior members was capped (or maybe just reset, I forget). Previously a tip of the scales from someone like NBVC was worth over 50 points.
On the plus side it makes it far less likely that I'll decide to switch from dispensing mediocre Excel advice to black-mailing you and NBVC.
P.S. If I'm not at "Reputation beyond repute" by the end of the day I'll be posting the photographs here. Even the one with the goat. You know what you have to do.
Leave Daisy out of this!
I've already repped you.
How about "Megas doux of Excel"? And as far as I know the title has been up for grabs since the fall of Constantinople. It also have the advantage of being both non political and non religious so nobody should be upset.I think Pope Excel I has a nice ring to it
Alf
Sorry, but I've really set my heart on being Pope. It's a nice indoor job with no heavy lifting, you get a bulletproof car, access to a virtually limitless supply of nuns (and I've seen enough Ken Russell films to know what that means), an assortment of fancy dress costumes to wear, keys to the Vatican treasury and you only ever have to have one performance review with your boss.
Aside from being an atheist I think I'm ideally suited for the job.
Who knows, that might actually be an asset ... a bit of thinking outside the box could end up with millions of new recruits to the faithAside from being an atheist I think I'm ideally suited for the job.
Well my election manifesto in brief:
Out
Going to church
Prayers
Pretending god exists
Looking for answers in the Bible
Fiscal probity
In
Vatican City race-track
Saint Richard Dawkins
All Nun strip clubs
Indulgences (back on sale by popular request)
Buy the Pope a Pint nights
So, if you do happen to be in college of cardinals do remember to vote for me and I'll turn a blind eye to priceless artworks being smuggled out under cassocks, you know what I mean?
Luckly, you won't be elected
Well, probably not - I think the Catholic church is pretty down on atheistic popes. But under EU rules that must surely be illegal discrimination, so if I don't get to be Pope I can sue them and take them for every gaudy trinket and fake relic they've got.
It's a win-win situation, really.
Is the Vatican, being a separate nation, part of the EU?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Vatican City (which is the state) is not in the EU or the UN, the Vatican (i.e. the Papacy) has 'observer' status within the UN. Traditionally it is neutral, including remaining neutral during WWII despite being completely surrounded by an axis power and also having been granted their status as an independent state by Mussolini. However, their standing army is mainly ceremonial and their nuclear weapons programme is in its infancy.
And as an extra bonus when you speak about an Excel problem "Ex cathedra" you would be infallible!Aside from being an atheist I think I'm ideally suited for the job.
Alf
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks