+ Reply to Thread
Results 1 to 62 of 62

Rep points system

  1. #1
    Valued Forum Contributor ImranBhatti's Avatar
    Join Date
    03-27-2014
    Location
    Rawalpindi,Pakistan
    MS-Off Ver
    Office 365
    Posts
    1,784

    Rep points system

    I still could not understand rep points system.
    some time an OP clicks * and the helping member gets 1 points and sometimes more than 1 points are added.Is this depends on the comment that OP writes in the rep dialogue or what?
    I am curiousssss.....
    Teach me Excel VBA

  2. #2
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Rep points system

    The points awarded on each REP event are based on the giver's experience on the forum. Everyone starts at 1 and progresses slowly upward.

    At this time your rep power is 4 pts, that's what everyone you give a a positive rep to gets.
    By comparison, my rep power is 20 pts.

    The more posts you make (experience) the higher your level grows, slowly.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

  3. #3
    Valued Forum Contributor ImranBhatti's Avatar
    Join Date
    03-27-2014
    Location
    Rawalpindi,Pakistan
    MS-Off Ver
    Office 365
    Posts
    1,784

    Re: Rep points system

    Thanks Sir Jerry.
    So is it documented somewhere in a section of forum that how many posts give you the power of 1 rep point?

    And what do the number of green tiny buttons indicate underneath the member IDs.i.e. I have 2 and you have 10 and now no space for further buttons.
    Attached Images Attached Images

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Rep points system

    I am also at 20, and no, there is not really anything laid what your rep "power", and if you think about it, for most members, it will be constantly changing.

    The green bars indicate what that member's reputation level is. I think the dark green bars are worth 1500 each and the light green bars are 500 - or something like that
    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

  5. #5
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Rep points system

    By my reckoning, the dark green bars are 100 each, and the light green 200 each, thus 1700 to get a full set.
    Don
    Please remember to mark your thread 'Solved' when appropriate.

  6. #6
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    Re: Rep points system

    I'm not sure that reckoning is quite right: I suspect that you need 2000 for the full gamut, as I only recently achieved it and I currently have 2461 rep points. By the way, there are five dark and SIX light green bars, so 11 in total.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  7. #7
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,090

    Re: Rep points system

    I'm sure the Admins know better than I but ... I seem to recall that, after you have made at least one post, you start with a rep power of 1. Then, I think, you have to earn 100 rep points for each of the dark green bars. And then you must earn 200 rep points for each of the light green bars. So, when the line is full, you will have earned at least 1700 rep points. I'm not sure if your rep power goes up by 1 each time you get a bar but I guess it might be linked to that. On top of all that, your rep power increases by 1 for each year you have been a member of the forum.

    I'm not sure what my rep power is, there's no way of telling, but I think it's about 16.

    Edit: I think xlnitwit is correct at 1700 rep points, not the 1800 I had wrongly calculated.
    Last edited by TMS; 05-07-2017 at 04:59 AM.
    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


  8. #8
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    Re: Rep points system

    There is an easy way of telling, but it would be an abuse of the rep system.

  9. #9
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,090

    Re: Rep points system

    @Ali: yes, I know. I guess you could just ask someone after you've repped them . For a clever or interesting answer, of course.
    Last edited by TMS; 05-07-2017 at 05:05 AM.

  10. #10
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Rep points system

    I would guess that admins and moderators could simply look it up for you? (based on post #2 admins at least certainly can)

  11. #11
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,090

    Re: Rep points system

    I seem to recall that Moderators could see rep points but not rep power. As you say, obviously the Admins can see all.

  12. #12
    Valued Forum Contributor ImranBhatti's Avatar
    Join Date
    03-27-2014
    Location
    Rawalpindi,Pakistan
    MS-Off Ver
    Office 365
    Posts
    1,784

    Re: Rep points system

    Oh....now I look at these bars again and can see that there are dark and light bars which sir Ford talked first about.

  13. #13
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MO Prof Plus 2016
    Posts
    6,907

    Re: Rep points system

    Also the text displayed when you put your mousepointer on the green bars gives an indication of the number of rep points earned.
    Every so much points the text changes until you have reached 'a reputation beyond repute' which means you have 2000+ rep points earned.
    Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
    You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.

  14. #14
    Forum Expert JapanDave's Avatar
    Join Date
    06-10-2008
    Location
    The grid, I got in!
    MS-Off Ver
    Excel 2010/13
    Posts
    1,696

    Re: Rep points system

    Everyone just rep me and I will tell you all if it is working OK.
    Be fore warned, I regularly post drunk. So don't take offence (too much) to what I say.
    I am the real 'Napster'
    The Grid. A digital frontier. I tried to picture clusters of information as they moved through the computer. What did they look like? Ships? motorcycles? Were the circuits like freeways? I kept dreaming of a world I thought I'd never see. And then, one day...

    If you receive help please give thanks. Click the * in the bottom left hand corner.

    snb's VBA Help Files

  15. #15
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    Re: Rep points system

    Moderators are unable to see rep power (well, I can't, anyway).

  16. #16
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,164

    Re: Rep points system

    If you click on Settings, you can see your total Rep points above any you have received in the title called "Latest Rep Points"
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  17. #17
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    Re: Rep points system

    Yes, rep points can be seen in settings, but not rep power (if you're replying to me, Marvin).

  18. #18
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Rep points system

    Only admins can see rep power

  19. #19
    Valued Forum Contributor
    Join Date
    03-22-2013
    Location
    Australia,NSW, Wirrimbi
    MS-Off Ver
    Excel 2013
    Posts
    1,057

    Re: Rep points system

    The rep system (to get to Forum Expert) seems slightly flawed to me..

    I have more than enough points to be awarded Forum Expert.. but I have not made enough posts to be awarded that..

    Yet i see others that would have less points but more posts ( *cough* spam *cough*) that have. I am not really interested in posting trivial questions or saying "You're Welcome" to every solution i have done.... ask a question if it is pertinent and then provide a solution...

    Sure.. if you have thousands of helpful posts like most of the gurus here have.. then do whatever you like.. as you have earned it.. but.. just saying.. I definitely have noticed a certain subset of members that seem to have worked out if you spam your a$$ off and answer easy questions.. then you can advance quite easily..

    I also think some go overboard with the begging in their sigs to click on the Rep button.. but, hey.. that's just my opinion.

  20. #20
    Forum Expert
    Join Date
    02-14-2009
    Location
    .
    MS-Off Ver
    ................
    Posts
    2,840

    Re: Rep points system

    +1 to paras 4 & 5.

    The rep system is over-rated and just leads, in some cases, to a race to the bottom. The 'begging' sigs just emphasise that.

    The preceding is simply my opinion, not a stated fact.

  21. #21
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,090

    Re: Rep points system

    @apo:

    I have more than enough points to be awarded Forum Expert.. but I have not made enough posts to be awarded that..
    Seem to be mixed messages ...

    To quote the FAQ page:
    This is the current level structure being followed -
    - Registered User: New users
    - Forum Contributor: 60 days and 100 posts
    - Valued Forum Contributor : 120 days registered and 300 posts and 150 reputation points
    - Forum Expert: 360 days registered, 1200 posts and 600 reputation points
    - Forum Guru: Promoted by voting from Forum Expert level
    - Forum Moderator: Promoted from Forum Guru or Forum Expert level
    - Forum Administrator: Promoted from Forum Moderator level
    Just the way it is. As for "begging for rep points", I actually was taken to task by one of the moderators in the early days because she considered that I was doing that. I think I was perhaps doing what others do now but I stopped. My signature now includes a line that suggests people +rep anyone who has helped them in the thread. Maybe that's still considered begging but then again, maybe if people are not aware there is a rep system, they can't/won't use it.

    I guess the rep system is a bit like Performance Management which also gets a mixed press. But how do you recognise someone's contribution if you can't measure it? Lots of posts doesn't mean lots of answers, nor necessarily, good answers. High post count + high rep count means more answers than questions and answers that are considered helpful. Do you look at the feedback about products you consider buying online?

    For what it's worth, I've been answering questions on this forum, and others (much less frequently) for just short of 7 years; I've got around 25,400+ posts; and I have just under 11,000 rep points ... no idea what that means in terms of rep power but probably around 16 to 18.

    Not everyone says thank you. Not everyone gives +rep points. And there seems to be an increasing tendency for some people to ask questions and not provide any feedback whatsoever. On the other hand, rep points from a contributor with several years on the forum makes up for that somewhat. From my point of view, if someone provides feedback and/or says thank you, with or without +rep, I will say "you're welcome". I consider that common courtesy and closes of the thread.

    I am not really interested in posting trivial questions
    While questions are an essential part of a forum, you would not expect to get recognition for not knowing the answer to something, would you?

    Just my opinion, not a stated fact ... ( )

    How do you get this title ...
    Forum Expert (Lazarus)

  22. #22
    Forum Expert
    Join Date
    02-14-2009
    Location
    .
    MS-Off Ver
    ................
    Posts
    2,840

    Re: Rep points system

    I got banned for spamming - actually I reported 2 or 3, one after the other and then got banned; accidentally I should add.

    The custom title was offered as recompense and I thought Lazarus was appropriate

    Plus - nothing wrong with a sig letting people know there is such a system in place. It's just that over-large "IF I HELP THEN REP" sigs are just a little OTT
    Last edited by cytop; 05-08-2017 at 10:02 AM.

  23. #23
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,090

    Re: Rep points system

    @cytop: I like it

  24. #24
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Rep points system. Reputation not beyond repute like children playing with themselves.

    Most of the OP’s I help don’t know what a Rep is, and I don’t usually feel like spending a week trying to explain it to them, Lol..
    _._____________________________
    I don’t understand the pretty green stripes either, not that I am too bothered much

    Reputation beyond Repute ( Full GAMut )
    200
    200
    200
    200
    200
    100
    100
    100
    100
    100
    100
    =1600
    100
    100
    100
    100
    100
    200
    200
    200
    200
    200
    200
    =1700


    I don't have a reputation beyond a repute, and I have 1497 points. Here my stripes
    DocAlanAlmostThere.JPG http://imgur.com/gPUT0j0
    DocAlanAlmostThere2.JPG http://imgur.com/3g16vOd
    DocAlanAlmostThere3.JPG http://imgur.com/9A5z8Av
    Doc.AElstein makes solutions like children playing with themselves
    200
    200
    200
    200
    200
    100
    100
    100
    100
    100
    0
    =1500
    100
    100
    100
    100
    100
    200
    200
    200
    200
    200
    0
    =1500

    Or:
    At 2001 a Full Gutodology
    100
    100
    100
    100
    100
    100
    100
    100
    100
    100
    100
    1100
    200
    200
    200
    200
    200
    1000
    =2100
    ( I’ll let you know what happens, should I have the fortune to be graciously honoured with another 4 Rep points… )

    _._______________________________________________________________
    @ TMS
    Hi Trevor.
    I think apo is referring to that he is under the required 1200 posts. I am guessing from his pretty green stripes that he might be above 600 rep points, like 1000 – 1100, or more depending on what of my screen shots is correct. – 5@200=1000 Dark green and started on a 100 light green ??
    ( I think most people know apo is a real life Expert, at Excel VBA as well as Bier, or Rum , I think )
    _.____________________________________________________________

    @Imran
    Hi Imran

    I wouldn’t put too much thought at your stage into Rep Points and the Title under the name given to Members in the forum, if I were you.
    Just enjoy being part of the community, contributing if and when you can.
    When asking for help, concentrate on a good posting style, make the content clear and give helpful feedback for others encountering the same problem and make sure you have a good Thread title so others on a search can catch the Thread. ( And do try please Imran, to be better at marking your Threads a s Solved https://www.excelforum.com/the-water...ml#post4593016 https://www.excelforum.com/the-water...the-forum.html You are very bad at forgetting that Imran. I lost count how many times I remind you )
    Have a good search before posting for existing Threads covering the Theme you are interested in, especially concerning those for Suggestions for Improvement for and The Water Cooler. – In these forums a quick scroll down will often find the Theme your interested in – a quick look shows there for the Theme of Rep Points:
    https://www.excelforum.com/the-water...ml#post4509092
    http://www.excelforum.com/tips-and-t...on-points.html
    http://www.excelforum.com/the-water-...from-guru.html
    https://www.excelforum.com/suggestio...on-points.html
    http://www.excelforum.com/the-water-...-feedback.html
    https://www.excelforum.com/the-water...on-points.html
    https://www.excelforum.com/tips-and-...ml#post4483653

    _.....
    The very best help I have had has been split 50 50 between highly Repped senior Members on the one hand, and Members on the other extreme with virtually no Points or Title who are sometimes very talented professionally that simply only occasionally access the Forum so don’t get the “build” up of points and Title under their name
    I don’t think it does any harm to Rep those that help you, or even those that have a good try. Some are indifferent to them, others appreciate them. Try to make a kind Rep comment as well , if appropriate. Feedback is most appreciated by most I think
    But I think you should not worry too much about your Title under your name or rep count, just my opinion. Enjoy being part of the community, improve your posting style, the rest will follow.

    Alan
    Forum Expert.. apparently
    '_- Google first, like this _ site:ExcelForum.com Gamut
    Use Code Tags: Highlight code; click on the # icon above,
    Post screenshots COPYABLE to a Spredsheet; NOT IMAGES PLEASE
    http://www.excelforum.com/the-water-...ml#post4109080
    https://app.box.com/s/gjpa8mk8ko4vkwcke3ig2w8z2wkfvrtv
    http://excelmatters.com/excel-forums/ ( Scrolll down to bottom )

  25. #25
    Forum Expert
    Join Date
    05-20-2015
    Location
    Chicago, Illinois
    MS-Off Ver
    2016
    Posts
    2,103

    Re: Rep points system

    Quote Originally Posted by apo View Post
    I have more than enough points to be awarded Forum Expert.. but I have not made enough posts to be awarded that..
    I felt this frustration, too. I was quite proud of my rep to posts ratio, and didn't like the idea of spamming "you're welcome" to hit the posts threshold, but I think letting go of my ratio obsession has made me a more pleasant forum participant. I still generally try to avoid "you're welcome" posts if they'll bump a long dead thread back onto page one, but I try to be polite now if the "thank you" was recent. Eschewing the ratio pride has also made me more active on the Water Cooler threads, which can be rewarding.

    As to the earlier discussion of the little green bars, I distinctly remember that it only took an additional 100 rep points to get my first light green rep bar, then 200 points per bar thereafter. So you get a dark green bar for free, then 400 rep points gets you the full 5 dark green bars. Your 500th point gets you a light green bar, then 700 for your 2nd light green (7th overall), 900 for your 3rd (8th overall), etc. I can confirm the progression up through 3 light greens. Ultimately, then, a filled 11-bar meter results from your 1500th point. Presumably. Ask again in a year
    Last edited by CAntosh; 05-08-2017 at 11:21 AM.
    If your problem has been solved, please use "Thread Tools" to mark the thread as "Solved".

    If you're grateful for this site's existence and would like to contribute to the community, please consider posting something hilarious in our joke thread:
    https://www.excelforum.com/the-water...ke-thread.html

  26. #26
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: Rep points system. Hail me, I have a Full GAMUT !!!

    Quote Originally Posted by CAntosh View Post
    ... Ultimately, then, a filled 11-bar meter results from your 1500th point. ...
    I have a full Gamut, @1507 points…
    _..and a brilliant Future… _..
    AlanFullMamut.JPG http://imgur.com/RiWShIn
    _.... in the future I will have a reputation beyond repute @ 2000 possibly , but my stripes won’t change.. and neither will I..
    So Full Gamut = > 1500
    @CAntosh - I do not quite follow yout greens teory ?? something along these lines,
    CAntosh
    100
    200
    300
    400
    500
    700
    900
    1100
    1300
    1500

    But no matter...
    I learnt something. -
    Quote Originally Posted by CAntosh View Post
    ....more active on the Water Cooler threads, which can be rewarding...
    I know what a Gamut is http://bfy.tw/81ET
    Last edited by Doc.AElstein; 05-08-2017 at 11:32 AM.

  27. #27
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Rep points system

    Things we do and see daily, for months and years, can take on a semblance of irritation in repetition. Such is the case with signatures and the feeling we are seeing unending REP reminders.

    For the most part, but not completely, this is an error in perception.

    We who are here almost every day doing the work see things much more often than the the usual "come and go" questioners. For them, it's all new. Keep that in mind and consider not harassing other members for their reminders to ops old and new about the common courtesies of the forum. It's harmless if we let it be and let it go.

  28. #28
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    Re: Rep points system

    OK. I am feeling a little 'got at', whether that is intentional or not, so just to set the record straight, I will respond to those criticisms levelled here that I consider unjustified (in my case, at least):

    1. I am not interested in the number of posts I have made. My only reason for being here is to help people. I like helping people. Get it?
    2. I have added the line about rep. points in my sig. because (a) the rep. system exists, and (b) I don't think many newcomers realise it does. If it's there, why not let people use it, if they want to? I don't like the 'in your face' flashy sig. that one member has recently adopted, but that's just my opinion.
    3. I respond to thank yous with "you're welcome" because I consider it polite to do so, not because it adds another post to my count, about which I care not a jot (see point 1 above).
    4. I respond to requests for help that I think I can answer. I am sorry if some people think that I am only responding to 'easy' questions: my competences are not as great as some others' here, but those asking 'simple' questions need answering, not ignoring. If some of you consider it below you to answer questions that you consider too simple, then you are not here for the same reasons as I am. Just my opinion.

    OK, so I've got that off my chest!

  29. #29
    Valued Forum Contributor ImranBhatti's Avatar
    Join Date
    03-27-2014
    Location
    Rawalpindi,Pakistan
    MS-Off Ver
    Office 365
    Posts
    1,784

    Re: Rep points system

    Sir Doc.Yes you have reminded me many times.
    Here I have asked about is it also mandatory to mark the threads as solved in "Water Cooler" as well but I could not received an answer
    https://www.excelforum.com/the-water...ed-avatar.html

    I am still have a mind that since it is "Water Cooler" we discuss off the topic here and we don't need to mark it solved.

    Is this like so?

  30. #30
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: Rep points system

    Quote Originally Posted by ImranBhatti View Post
    I am still have a mind that since it is "Water Cooler" we discuss off the topic here and we don't need to mark it solved
    Hi Imran, you may be right, the Rules are all a bit relaxed here (But in those Threads you asked specific questions and issues which were answered and Solved, but not a big issue )
    Last edited by Doc.AElstein; 05-08-2017 at 01:30 PM.

  31. #31
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    Re: Rep points system

    There is no rule about marking threads as solved, it's just handy and neat and tidy if they are. however, here in the Water Cooler, it's a moot point as these ramblings are discussions rather than Qs and As.

  32. #32
    Valued Forum Contributor ImranBhatti's Avatar
    Join Date
    03-27-2014
    Location
    Rawalpindi,Pakistan
    MS-Off Ver
    Office 365
    Posts
    1,784

    Re: Rep points system

    I am telling my personal experience that when I first registered here for help and of course many Experts/Gurus and even "Registered user" helped me and I thanked them from the bottom of my heart and by doing so I was thinking that I am showing my best wished for the helper. I still remember that some ov my problem were solved and I did not gave rep to the helper. Now I am planning to do so by sitting one every week and search my earlier posts and give rep to those who helped me out.I don't care if they are now not coming (that is my rough idea otherwise I don't know if someone is missing now). I am feeling that I was unintentionally hurt them.

  33. #33
    Forum Expert
    Join Date
    05-20-2015
    Location
    Chicago, Illinois
    MS-Off Ver
    2016
    Posts
    2,103

    Re: Rep points system. Hail me, I have a Full GAMUT !!!

    Quote Originally Posted by Doc.AElstein View Post
    @CAntosh - I do not quite follow yout greens teory ?? something along these lines,
    CAntosh
    100
    200
    300
    400
    500
    700
    900
    1100
    1300
    1500
    Your interpretation is spot on, Doc - that picture captures my progression through the greens thus far.

  34. #34
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: Rep points system. Hail me, I have a Full GAMUT !!!

    Quote Originally Posted by CAntosh View Post
    Your interpretation is spot on, ..
    One day,... you shall receive your initiation in to the Club of the Full GAMUTS ( and may be many secrets may be revealed to you … )

    [joke]
    From Forum Rules:
    https://www.excelforum.com/forum-rul...rum-rules.html
    - Registered User: New users
    - Forum Contributor: 60 days and 100 posts...you will be able to upload a non-animated avatar.
    - Valued Forum Contributor : 120 days registered and 300 posts and 150 reputation points...you will be able to upload an animated avatar.
    - Forum Expert: 360 days registered, 1200 posts and 600 reputation points...you can upload a profile picture
    - Forum GAMUT: 1500 reputation points… you receive initiation in to the Club of the Full GAMUTS
    - Forum Guru: promoted by voting from Forum Expert level
    - Forum Moderator: promoted from Forum Guru or Forum Expert level
    - Forum Administrator: promoted from Forum Moderator level
    [joke]



    Moderators Note: I added joke tags on for you this time. Please remember to add them in future yourself….
    Last edited by Doc.AElstein; 05-08-2017 at 02:21 PM. Reason: Added link to Forum Rules. Moderator: added Joke tags

  35. #35
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    Re: Rep points system

    I am feeling that I was unintentionally hurt them.
    I don't think you should feel like that, certainly not from my point of view, anyway: giving rep. points is entirely voluntary and just one way of expressing your gratitude.

  36. #36
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,893

    Re: Rep points system

    Competitiveness is a basic human instinct. I don't come here for the money. I am entitled to provide answers, in exchange for a financial reward, in Commercial Services. I don't. Once money comes into it, it ceases to be fun. My part-time consultancy work (unrelated to Excel) is not for fun. It IS for the money.

    So, why do I spend time here. It's partly for fun, partly to keep the grey matter active and partly for the competitive side of me. A rep point or two is a cost-free way of saying "Ta Ta" and does not merit being sneered at. If you're not into it, fine. If you are, fine.

    Whatever "floats your boat".
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  37. #37
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Rep points system

    Quote Originally Posted by Glenn Kennedy View Post
    Competitiveness is a basic human instinct. I don't come here for the money. I am entitled to provide answers, in exchange for a financial reward, in Commercial Services. I don't. Once money comes into it, it ceases to be fun. My part-time consultancy work (unrelated to Excel) is not for fun. It IS for the money.

    So, why do I spend time here. It's partly for fun, partly to keep the grey matter active and partly for the competitive side of me. A rep point or two is a cost-free way of saying "Ta Ta" and does not merit being sneered at. If you're not into it, fine. If you are, fine.

    Whatever "floats your boat".
    Couldnt agree with you more, Glenn. Keeps my brain active, feeds like liking to help and share knowledge. A thanks, either from a "thank you" or from being rep'd (or both) are a great way to show appreciation for help that was offered - even if it was not what was needed.
    By the same token, expecting (hoping for?) a thank you, and getting it, kind of behooves a polite acknowledgement from the "thanked one"

    As you said though, whatever floats your boat. This is not a discussion that will ever have 100% agreement

  38. #38
    Forum Expert
    Join Date
    05-20-2015
    Location
    Chicago, Illinois
    MS-Off Ver
    2016
    Posts
    2,103

    Re: Rep points system. Hail me, I have a Full GAMUT !!!

    Quote Originally Posted by Doc.AElstein View Post
    One day,... you shall receive your initiation in to the Club of the Full GAMUTS ( and may be many secrets may be revealed to you … )
    [joke]

    Haha, some day! The first secret I need to learn is proper use of [joke] tags!

    [/joke]

  39. #39
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,090

    Re: Rep points system

    @Ali, Glenn and Ford: I agree with all your points. With regard to rep, it does float my boat, I welcome it and am grateful for it, and sometimes I'm disappointed if I don't get it for a particularly neat solution. But I also appreciate a simple thank you though it's not so easy to count them . I also rep people who answer my questions and also those who produce a better answer than mine. And I give rep to people in threads where I'm not involved but where I learn something new and/or interesting.

    I answer whatever questions I can. Some are "easy" but that's a relative term. If you know how to do something, it's easy; if you don't, it's a challenge. The more you challenge yourself, and learn from others, the more you know and the easier it becomes.

    A long time ago, in a nearby galaxy, I was a programming project leader leading a team of programmers. In the early days, I took on the complex tasks and the team did the simple programs. As their experience widened, and my confidence in their ability grew, our roles reversed and they took on the complex tasks and I churned out the simple repetitive programs. They had the opportunity to develop and I was able to spend more time actively managing and supporting the team. In many instances, I feel we are able to develop and support the people asking questions on the forum. There are, inevitably, people who are just lazy and have no desire to improve ... hence we see the same or similar questions from the same people time and again. But, I digress ...

  40. #40
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,910

    Re: Rep points system

    The rep points are nice, and I have to admit that I did keep my eye on them when approaching an appropriate milestone just to watch the odometer "roll over," so to speak.

    I'm here because I like helping people. I'm simply "paying back" on behalf of the giants upon whose shoulders I stand.

    Alas, as an old fart (68), I like keep the brain limber - some people do word puzzles, others do logic problems, still others brave the Sunday NYT crossword puzzle with a ball-point pen. I do Excel. It is interesting to see what kinds of problems people can come up with. Many of the posts I choose to attack are for my own benefit. They present a unique challenge or I know that they will force me to do research into a particular area. All of it goes into the data bank so when I need it for my job, I can hit the ground running.

    I've dealt with regional setting differences, something I would have never come across in my daily data crunching. I've also picked up a word here and there of foreign languages and I learned that the Dutch word for year is jaar which means if you need a 4-digit year, use "jjjj" if in Amsterdam instead of "yyyy." I'm now able to write code to switch the settings and commenting it so the OP can translate my English MSGBOX code into their native language.

    I've also learned a lot of non-Excel related things: like accounting, human resources management, geology and training. I even had fun with a spreadsheet developed by an Israeli that went from right to left. Fortunately, named dynamic ranges can also work right to left and it was fun to engage my brain "backwards."

    So yeah, it's fun. It keeps me off the street at night and awake in the middle of the afternoon on those days when no reports are due. And, I don't lose sleep over number of posts or rep points.
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

  41. #41
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,893

    Re: Rep points system

    dflak. There is no-one alive that is more totally right-handed than me (excluding amputees...) in daily life. Same for R-L sheets. OMG. i can't cope with them at all!!!

    It's also good to know that you're a (slightly) older fart than I am...

    The important thing to remember about Rep Points is that they flatter your vanity, but tell you little about your ability. There are many here who outclass me 100 times over, but who have a lower rep score. I'll only name one name, mainly 'cos he's currently (sadly) a relatively infrequent visitor here. XOR LX has forgotten more than I will ever know.

    So, remember: it IS just for fun and being No XXX in the EF Hall of Fame (or whatever...) probably just measures your personal temporal input.

    That said, I do get very narked when I spend an age on a problem posted by a "hit and run" poster and get neither rep nor "thank you".

  42. #42
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Rep points system

    Since Rep points could not be exchanged for "Vouchers" or cash them in, here is my suggestion:
    I will be the first to volunteer to help "Friends of the Earth" or "Green good cause" by giving all my rep points up(The Greens) to good cause. If others follow suite with their green bars, the world would be a much better place to live-in.

    Long live the Greens!

  43. #43
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,893

    Re: Rep points system

    I'm not sure if Greenpeace, Amnesty International or Plan International (each of which received a monthly dollop of cash from me for 25 years or more) would know what to do with an EF Rep Point... or even where to stick it....

  44. #44
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Rep points system

    They stick them in their Logo; rep points are greens bars after all.

  45. #45
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,893

    Re: Rep points system

    Mmmm. Irish bars are green bars, also. Do they take EF Rep points in exchange for pints??

  46. #46
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Rep points system

    They might, but I am all for a good cause.

  47. #47
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,893

    Re: Rep points system

    And a pint and associated "craic agus ceol" isn't a good cause???

    (fun & music, BtW)

  48. #48
    Valued Forum Contributor loginjmor's Avatar
    Join Date
    01-31-2013
    Location
    Cedar Rapids, Iowa
    MS-Off Ver
    Excel 2013
    Posts
    1,073

    Re: Rep points system

    I'm with Glenn - Let's all raise a pint! That's the best advice yet!
    ____________________________________________
    If this has solved your problem, please edit the thread title to add the word [SOLVED] at the beginning. You can do this by
    -Go to the top of the first post
    -Select Thread Tools
    -Select Mark thread as Solved

    If I have been particularly helpful, please "bump" my reputation by pressing the small star in the lower left corner of my post.

  49. #49
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,893

    Re: Rep points system

    I hate to admit it... but you Yanks can make a bloody good pint.... even if it's rather smaller than ours...

  50. #50
    Valued Forum Contributor loginjmor's Avatar
    Join Date
    01-31-2013
    Location
    Cedar Rapids, Iowa
    MS-Off Ver
    Excel 2013
    Posts
    1,073

    Re: Rep points system

    Yes, but the best pint is the one someone else buys!

  51. #51
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Rep points system

    Yes, so long as it is a pint of "Guinness"

  52. #52
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: Rep points system

    Quote Originally Posted by Glenn Kennedy View Post
    I hate to admit it... but you Yanks can make a bloody good pint.... even if it's rather smaller than ours...
    I suppose you've never been to Belgium then?

  53. #53
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,649

    Re: Rep points system

    @pepe

    Apparently it's only amount that counts....



  54. #54
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,893

    Re: Rep points system

    No. The USA makes some/most of the worst beer in the world. Bud, etc, devoid of taste. USA microbreweries can be superb: esp with a load of the 3C hops.

    I've been to Belgium more times than I can remember. Some fantastic lambics. Gueze Cantillon being among my favourites. And Rodemback Grand Cru.. . Some of it is a tad strong, though.

  55. #55
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: Rep points system.. Reps and Beer and Bier …. Behove? And behold: - We are all Gamuts

    Hail fellow Gamuts..

    Quote Originally Posted by Gamut.LeMokko View Post
    I suppose you've never been to Belgium then?
    I expect I will be hung for treason, or accused of crawling to help offset any ill effects to me arising from the Brexit.. But I have to confess, after 20 years of the Darker Cellar Beer in Germany, I do find that English Beer does indeed taste, in comparison, as we often joked like Pixs. But to be fair I was not as familiar as I should of been of the real Ale at the time…
    @Glenn: Someone way back mentioned to me our family might not have originated on the “mainland”,
    If I get a good test result ( https://www.excelforum.com/the-water...ml#post4646761 ), and find any Irish Blood, will you put in a good word for me to get an Irish Passport ?

    _........................
    _.--___________________________________________________

    Quote Originally Posted by HonGamut.apo View Post
    ...have more than enough points to be awarded Forum Expert.. but I have not made enough posts to be awarded that..
    Quote Originally Posted by MasterGamut.TMS View Post
    ... seems to be an increasing tendency for some people to ask questions and not provide any feedback whatsoever. On the other hand, rep points from a contributor with several years on the forum makes up for that somewhat. From my point of view, if someone provides feedback and/or says thank you, with or without +rep, I will say "you're welcome". I consider that common courtesy and closes of the thread.. ]... But I also appreciate a simple thank you though it's not so easy to count them... There are, inevitably, people who are just lazy and have no desire to improve..
    Quote Originally Posted by FullGamut.Alan View Post
    I think there is a growing tendency to being uncourteous and not saying thanks ...
    I have also noticed that some regulars and experienced users are sometimes giving very bad or no feedback when someone helps or posts an answer or comments , makes suggestions....When occasionally asking a question , I sometimes get a useful partial answer to which I am very grateful. In those situations saying thanks in the thread is very useful to bump the Thread back up so that other outstanding issues might be commented by others ..
    Quote Originally Posted by LazarusGamut.cytop View Post
    ...nothing wrong with a sig letting people know there is such a system in place....
    Quote Originally Posted by UnderGamut.CAntosh View Post
    ....proud of my rep to posts ratio, and didn't like the idea of spamming "you're welcome" to hit the posts threshold,....generally try to avoid "you're welcome" posts if they'll bump a long dead thread back onto page one, but I try to be polite now if the "thank you" was recent. .....
    Quote Originally Posted by ChiefGamut.JBeaucaire View Post
    ...the usual "come and go" questioners. .... reminders to ops old and new about the common courtesies of the forum. .....
    Quote Originally Posted by Gamutiss.Ali View Post
    .... I am not interested in the number of posts I have made. .... I respond to thank yous with "you're welcome" because I consider it polite to do so, ...
    Quote Originally Posted by Gamut.dflak View Post
    ... don't lose sleep over number of posts or rep points.
    Quote Originally Posted by IrishRegionalLeader”floatshisboat”Gamut.Glenn View Post
    .. I do get very narked when I spend an age on a problem posted by a "hit and run" poster and get neither rep nor "thank you".
    Quote Originally Posted by ChiefGamut.FDibbins View Post
    ...behooves?? .. a polite acknowledgement from the "thanked one" floats your boat...
    We’ve discussed a lot the increasingly bad feedback and common courtesy in this and other Threads recently. So I think in my opinion it is essential to encourage it. ( feedback I mean not the lack of it.. Lol.. )
    So I will always say thanks for any feedback. But there are up to three alternatives to a post in the Thread that can be used. Depending on the users settings you may be able to drop off a thanks in their visitors messages or by PM. I sometimes do one or the other, or even a reply in the Thread, .. I never gave it too much thought - a reply in the thread is sometimes the quickest, so I can understand more active members would do that more often possibly.
    Very occasionally an OP will give detailed Feedback including code / measurements of test results, explanations etc. That I will sometimes give a Rep and an appropriate Rep message, ( Sadly some newer OP’s may never notice having no idea about Reps and their User Control Panel where they can see them ). Even more rarely, an OP having got no reply will make and post his detailed solution. That often gets a Rep from me. I got a couple of reps from fairly senior Members like that, and that can be very encouraging at a frustrating time.

    Occasionally I have dropped a PM to remind an OP of an answer he has not respond to from me or someone else. I was surprised that that often gets a response. ( I realise that it is not practical for very active Members to do that). It seems a lot of OP’s unsubscribe, don’t have Email Notifications enabled, and many rarely know what their User Control Panel is. – That is another thing it is good to inform/ remind newer OP’s about.
    Alan
    GamutOfCeremonies
    Behove ? – I am a Gamut ??


    P.s. I have just bestowed via PM, by way of a temporary recompense, the Title of Honorary Gamut to member apo
    Last edited by Doc.AElstein; 05-09-2017 at 09:51 AM.

  56. #56
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,893

    Re: Rep points system

    Anyone born on the island can automatically get an Irish passport. I'm in the anti-Brexit, British Northern bit of Ireland and have both UK and IRL passports. If you have one parent or one grandparent born on the island, you first have to apply for Irish citizenship (expensive!!) and then for the passport. If your ancestry is further back than that, you're out of luck...

  57. #57
    Forum Expert
    Join Date
    04-01-2013
    Location
    East Auckland
    MS-Off Ver
    Excel 365
    Posts
    1,340

    Re: Rep points system

    Apparently i am "very confident in my ability"... I look forward to "becoming a god in the excel world" I think that is the next one..
    that sounds pretty lofty At that point I think I may get delusions of grandeur.

    thanks for the analysis doc
    If you want something done right... find a forum and ask an online expert.

    Time flies like an arrow. Fruit flies like a banana.

  58. #58
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: Rep points system and Beer and Boats and Gamuts

    @Glenn. Looks like I’m out of luck. . Thanks for the info. Keep your boat floating

    _-.______________________________
    _...................
    @ scottiex
    Quote Originally Posted by scottiex View Post
    Apparently i am "very confident in my ability"... I look forward to "becoming a god in the excel world" ...
    that sounds pretty lofty At that point I think I may get delusions of grandeur.......thanks for the analysis ..
    Hi scottiex, - Some time ago I was warned that I “…..had an addiction to Excel” Foolishly I ignored it, Lol.. It’s worth thinking a bit when you are at that point!. The Rep system and titles are fun:, the owner is “….becoming part of the community”, http://imgur.com/Z30T0Pl , and the EF Management have clearly been rewarded, as they have “…….been very helpful” http://imgur.com/Qzb6eP6 recently, for example with getting us on the new sever which has cured many problems, and , I think, has encouraged some Members to come back
    Alan
    P.s.
    Thanks for the Rep. - This Thread made me the Full Gamut I am today
    Last edited by Doc.AElstein; 05-16-2017 at 06:06 AM.

  59. #59
    Forum Contributor
    Join Date
    08-04-2004
    Location
    Amsterdam
    MS-Off Ver
    2016
    Posts
    186

    Re: Rep points system

    Quote Originally Posted by Glenn Kennedy View Post
    No. The USA makes some/most of the worst beer in the world. Bud, etc, devoid of taste. USA microbreweries can be superb: esp with a load of the 3C hops.

    I've been to Belgium more times than I can remember. Some fantastic lambics. Gueze Cantillon being among my favourites. And Rodemback Grand Cru.. . Some of it is a tad strong, though.
    You should give the Belgium Winter Bier a go. Very dark and very strong (11% proof I believe)

  60. #60
    Forum Contributor
    Join Date
    08-04-2004
    Location
    Amsterdam
    MS-Off Ver
    2016
    Posts
    186

    Re: Rep points system

    I'd be lying if I said I didn't watch my meagre collection of rep points(although I only found out last week how to see who had given me rep) but getting points isn't why I'm here. I rarely ask for help as i prefer to try and solve my issues myself because that is the only way I will learn. I will look at posts asking for help and will often spend an hour or 2 tying to solve the complex (to me) ones by which time it has already been answered and marked solved but it means I will have learned something and will study the solutions given. I see little point in people asking for help but not attempting to understand the answer provided.
    I have learned far more here than by any Excel book I ever used.

  61. #61
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: Rep points system and Beer and Boats and Gamuts

    Hi philaugust
    Quote Originally Posted by philaugust2004 View Post
    …I only found out last week how to see who had given me rep … … will often spend an hour or 2 tying to solve the complex (to me) ones by which time it has already been answered and marked solved but it means I will have learned ….
    I have learned far more here than by any Excel book I ever used.
    The User Control Panel ( UCP ) needs to be better publicised…( https://www.excelforum.com/suggestio...new-users.html ) – I only came across it when it was suggested to me as an alternative to keeping up on replies to Threads I was subscribed to during the times that Email Notifications were not working. I use that a lot now. More active members use that rather than relying on Email notification as they would otherwise be swamped with Emails

    I totally agree the learning is a great incentive to try to answer a Thread. Trying examples/ Problems is often like in school the best way to learn, but when you are answering a “real life” problem it somehow seems more worthwhile and I find that a much better incentive than trying a “Homework” type question from a book. In fact , personally, I think that is what initially can be the best incentive initially and you should not think to much about Reps and Titles and things. Also you are likely to learn more of what is actually needed in real life. Books can be useful in parallel, but they will soon be a bit out of date with what is the most useful to learn. The learning often helps offset the poor feedback that you often get.
    As far as Reps are concerned, I personally prefer a bit of feedback, good or bad, either in the Thread or in a Rep message rather than a rep point.
    There can be a point you reach however, when you are not learning quite so much. Also for some of the very active Members with many years of experience, the learning they get from answering can be much reduced. At those levels, the lack of feedback can be slightly off putting. Opinions vary, some will say they do it as an alternative to the crossword puzzle, and they know that they have the right answer, which is enough satisfaction, and healthy to keep the brain active.
    Also at the “higher” levels, a bit of friendly competition in Rep count, as Glenn mentioned, seems harmless and healthy fun.
    Last edited by Doc.AElstein; 05-16-2017 at 12:09 PM.

  62. #62
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,090

    Re: Rep points system

    @philaugust2004: I learned initially form books, and a two day VBA course that I arranged for me and my team. Then it was a case of applying what I had learned in a real life practical situation ... automating an HR sickness management task. I recorded macros and asked questions on forums (not this one at the time) and improved the execution and performance of the code. I find I can't/don't learn just for the sake of it.

    Answering questions and viewing solutions helps me to broaden my knowledge. I learn something new every week, if not every day.


    @Doc: I only ever use the UCP for tracking threads. I don't want/need the emails, whether or not the system is working properly. I like answering questions and it helps me in what I do ... but I do appreciate the rep points

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Points scoring system
    By Fessy82 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-02-2015, 07:23 AM
  2. [SOLVED] Points system with conflicting IF functions
    By anglarna_ger in forum Excel General
    Replies: 4
    Last Post: 06-05-2012, 10:22 AM
  3. Excel 2007 : Points System If Function
    By nvechols in forum Excel General
    Replies: 2
    Last Post: 02-08-2012, 02:38 PM
  4. Points System
    By giant in forum Excel General
    Replies: 2
    Last Post: 06-06-2010, 02:31 PM
  5. points system
    By Duckie in forum Excel General
    Replies: 2
    Last Post: 11-15-2009, 03:42 AM
  6. Points system
    By Doraemon in forum Excel General
    Replies: 16
    Last Post: 10-03-2009, 03:08 AM
  7. POker league points system
    By Sgt.Trojan in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 04-06-2009, 04:27 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1