Page 2 of 7 FirstFirst 1234 ... LastLast
Results 11 to 20 of 67

Thread: If Chip Pearson's website ever helped you, please jot a note...

  1. #11
    MrExcel MVP shg's Avatar
    Join Date
    May 2008
    Location
    The Great State of Texas
    Posts
    21,639
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    14 Thread(s)

    Default Re: If Chip Pearson's website ever helped you, please jot a note...

    Chip's website was well organized, his explanations lucid, and his code meticulous. I bet over the years I read most of it. I would visit in search of a solution to some immediate need, but always overstayed when some shiny object caught my eye: "Ooh, this looks interesting!"

    As I got better, I vectored OPs to Chip's site. His pages on debugging VBA are, to me, the most valuable information toward improved coding skills I have ever seen -- there is no better path than learning to fix your own problems. Maintaining his site would be a gift to the community for as long as VBA remains a viable programming language. It is an impressive opus.

  2. #12
    Board Regular Taul's Avatar
    Join Date
    Oct 2004
    Location
    Uxbridge
    Posts
    644
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: If Chip Pearson's website ever helped you, please jot a note...

    My condolences to Chip’s parents for their loss. I have to agree with the consensus listed here; Chip’s site is indeed a valuable resource and repository of his knowledge.
    I have used Chip’s site many times over the years and also directed others to take a look at it to solve their particular coding problems. In particular the section on date calculations have been very useful to me. It remains in my shortcut list as a favourite.
    Please keep the site open if at all possible; it’s a valuable resource for all.

    Cheers
    Paul.
    Excel 2010 on Win7 at home - 2013 on win7 at work

  3. #13
    New Member ashleedawg's Avatar
    Join Date
    Oct 2017
    Location
    Canada
    Posts
    11
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Thumbs up Re: If Chip Pearson's website ever helped you, please jot a note...

    Quote Originally Posted by Greg Truby View Post
    This week I have been working with Chip's hosting company and his domain registrar to get those accounts transferred over to Mrs. Pearson's control so she can get the site back up and running. I think we're almost there. So if you've tried his site and haven't gotten in, please keep trying. Hopefully we'll get it back online in the coming days.
    Ah so you're the "other mystery caller" who the hosting company wouldn't identify! I was getting worried that someone was going to try for financial benefit by resurrecting the website as a business (especially given the timing of the domain expiring in a couple weeks.)

    THIS IS FANTASTIC NEWS and I thank you for your time and effort in this. I think we all agree that it's imperative that the site live on as Chip's legacy, and to help millions more. (I will try to contact you privately about some specific matters.)

    Quote Originally Posted by Greg Truby View Post
    ... I told them that Chip had helped hundreds of thousands, perhaps even millions of people all over the globe. While they knew Chip was a Microsoft Excel MVP, I don't think they had a real appreciation for just what a titan Chip was in the Excel world; which is why Mrs. Pearson had Chip's website taken down after his death.
    I think you're going to have to call Mr. & Mrs. Pearson back and let them know your estimate was off.

    I spent hours on various archived versions of the site from a number of sources, consolidating facts and stats, mostly from Chip's own notes that he would tally up every couple years. It appears that he gave up trying to keep track of site traffic since it was consuming time he could spend answering emails and phone calls. His last count was almost 5 years ago but I found a pretty solid data source so I could estimate the usage since then . Even as "VBA usage as a whole" has decreased in the last number of years, cpearson.com site visitor counts were *never* lower than the previous years; always a increase.

    So I think this figure would have been a surprise even to him. In the last few years cpearson.com the average day for the site consisted of 50,000 unique visitors reading 80,000 pages.

    All things considered (and estimating on the low side) the total traffic since the site was registered in 1999 was:


    • 163,300,000 site visits
    • 287,280,000 page loads


    Chip was averaging 1 site visitor every 1.7 seconds. Half a million zip files were downloaded per year.

    That's a lot of traffic - especially considering the site consists of only 500 pages and 300 downloadable files... that shows just how valuable the site "golden content" really is.

    I'm slapped together some charts. (I'm a little embarrassed with the quality of of them considering the topic, but I wanted to get this posted ASAP!)


    Daily Chart All-time Chart

    Although Chip had originally set out with the purpose of teaching himself PowerPoint, he quickly realized the satisfaction that can be achieved from helping others. In a post from 1999, Chip discussed his excitement at having reached 100 daily visitors, saying "I feel like the king of the world!"

    Years later he had to set some boundaries for people emailing him with questions, because he was receiving thousands of emails per day and opening every single one. He set out some basic rules, "use spell check, be specific, poor writing is a pet peeve, and don't attach files" (since that extra time in opening attachments would reduce the number of people he could respond to in a day). Yet even when putting his foot down he was still apologetic for not replying to everyone personally.



    Chip's words:

    Quote Originally Posted by Chip Pearson
    ...include it any any applications that you create, including commercial works and works for hire. This distribution is royalty-free and may be done without any license from me. I would appreciate a reference to my page in the source code and in any printed documentation.

    This attribution, however, is optional. Do what you feel is the right thing to do.
    It sounds like we have a chance to get the site back up and running, and we're going to have to work together to make that happen. That act of binding together will in itself will be an amazing legacy for "King" Chip Pearson to leave us.

  4. #14
    Board Regular MARK858's Avatar
    Join Date
    Nov 2010
    Location
    Southern England
    Posts
    11,236
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    2 Thread(s)

    Default Re: If Chip Pearson's website ever helped you, please jot a note...

    Just to say that the site is back up now, my thanks to all involved in getting it up and running.
    Especially I would like to give my thanks to the family for the consideration they have given to others at this sad time.

    Link to the site topic index
    Last edited by MARK858; May 7th, 2018 at 05:32 AM.
    Test VBA on a copy of your data (remember you can't normally reverse the action)

    Please follow the forum Rules and Guidelines & please use Code tags around your code i.e. [CODE]your code[/CODE]

    To post a screenshot try one of these links
    MrExcel HTML Maker, RoryA addin (Win & Mac) or Borders-Copy-Paste

  5. #15
    MrExcel MVP
    Junior Admin
    Joe4's Avatar
    Join Date
    Aug 2002
    Posts
    51,042
    Post Thanks / Like
    Mentioned
    57 Post(s)
    Tagged
    11 Thread(s)

    Default Re: If Chip Pearson's website ever helped you, please jot a note...

    Thank you to everyone, especially Greg, Bill, and Chip's parents. My condolences to his family for the loss.
    The Excel community lost a great member, but it is nice to know that his legacy will live on with his site (which I often quote myself in helping people).
    TIPS FOR FINDING EXCEL SOLUTIONS
    1. Use the built-in Help that comes with Excel/Access
    2. Use the Search functionality on this board
    3. A lot of VBA code can be acquired by using the Macro Recorder.

    "Give a man a fish, feed him for a day. Teach a man to fish, feed him for life!"

  6. #16
    MrExcel MVP Greg Truby's Avatar
    Join Date
    Jun 2002
    Location
    39° 17' 15" N, -94° 40' 26" W
    Posts
    9,999
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    1 Thread(s)

    Default Re: If Chip Pearson's website ever helped you, please jot a note...

    Quote Originally Posted by ashleedawg View Post
    Ah so you're the "other mystery caller" who the hosting company wouldn't identify! I was getting worried that someone was going to try for financial benefit by resurrecting the website as a business (especially given the timing of the domain expiring in a couple weeks.)
    Back atcha there, sunshine. Bill and I had already contacted his hosting company and made sure they knew the score, so there was never any danger of his hosting company reactivating the site without the Pearson family's consent. The real threat was some internet carpetbagger buying the domain and using Chip's hard work for their own gain. While its expiry was more than a couple of weeks out, it was a concern we needed to address. I am pleased to state that I have seen to it that Mr. & Mrs. Pearson now have control of Chip's account with his domain registrar and thus this threat has been neutralized.

    Quote Originally Posted by ashleedawg View Post
    THIS IS FANTASTIC NEWS and I thank you for your time and effort in this. I think we all agree that it's imperative that the site live on as Chip's legacy, and to help millions more.
    Indeed it is fantastic news. I'm just glad I could help. And nice work on the traffic analysis.

    Quote Originally Posted by MARK858 View Post
    Just to say that the site is back up now, my thanks to all involved in getting it up and running.
    Especially I would like to give my thanks to the family for the consideration they have given to others at this sad time.

    Link to the site topic index
    Mark has beaten me to the punch. Yes, Chip's host e-mailed Mrs. Pearson this morning to inform her that his website should be back up and running. I have gone out and checked the home page and jumped around, following a few links and everything appears to be in order. If anyone finds something amiss, please private message (PM) me here and I will forward the issue to his hosting company. But please confine your PM's to just issues of the site loading/rendering. As ashleedawg has already pointed out, trying to answer specific questions about how to apply Chip's articles would overwhelm anyone.
    Last edited by Greg Truby; May 9th, 2018 at 02:11 PM.
    Greg
    ………………………………………………
    Home: XL 2003, 2007, 2010, and 2013 on Windows 7
    Work: XL 2013, 2016 on Windows 10
    Please use CODE tags - especially for longer excerpts of code.

  7. #17
    MrExcel MVP
    Moderator
    RoryA's Avatar
    Join Date
    May 2008
    Location
    UK
    Posts
    33,990
    Post Thanks / Like
    Mentioned
    53 Post(s)
    Tagged
    6 Thread(s)

    Default Re: If Chip Pearson's website ever helped you, please jot a note...

    First, my deepest sympathies to Chip's parents - I can't even begin to comprehend what they have been through.

    Second, my sincere thanks to all involved in resurrecting Chip's site. Its worth to the Excel world is frankly incalculable, and it is a truly fitting memorial to Chip's great mind and huge generosity of spirit. I certainly wouldn't be half the programmer I am today without the wealth of knowledge I gained from him, and judging by the sentiments I have seen expressed on every forum or newsgroup I frequent, the same is true of so many others.

    I only hope that the reaction of the community can be some small comfort to his parents at this time.

  8. #18
    Board Regular kweaver's Avatar
    Join Date
    May 2018
    Location
    La Jolla, CA
    Posts
    645
    Post Thanks / Like
    Mentioned
    6 Post(s)
    Tagged
    0 Thread(s)

    Default Re: If Chip Pearson's website ever helped you, please jot a note...

    A very sad loss to the family and friends and associates. His website and generosity helped me (and many others) over the years.
    If there is a need to contribute to the cost of hosting his site, count me in.

    Kevin

  9. #19
    Administrator starl's Avatar
    Join Date
    Aug 2002
    Location
    Everywhere!
    Posts
    5,864
    Post Thanks / Like
    Mentioned
    5 Post(s)
    Tagged
    0 Thread(s)

    Default Re: If Chip Pearson's website ever helped you, please jot a note...

    My condolences to Chip's parents. As you can see, your wonderful son touched the lives of many, MANY people around the world. He shared his knowledge freely and it was truly helpful. He will be missed.

    Greg - thank you for the work you started it getting Chip's site back up. When I saw the site was down, I went into Google archives and saved the pages I had linked to my drive (the ones I could).
    Mr & Mrs Pearson - thank you for understanding and caring how much his work meant to Excel users around the world.
    Bill - thank you for sponsoring the work to get Chip's site back up.

    Tracy

  10. #20
    Board Regular Jaafar Tribak's Avatar
    Join Date
    Dec 2002
    Location
    Larache--Morocco
    Posts
    7,394
    Post Thanks / Like
    Mentioned
    40 Post(s)
    Tagged
    3 Thread(s)

    Default Re: If Chip Pearson's website ever helped you, please jot a note...

    I have only just learnt of the passing of Chip Pearson .. I am so saddened to hear of this piece of news.

    I would like to express my deepest condolences and respects to his family and friends.

    His very well oraganised and easy-to-use website has always been my first reference to findng answers to many of the VBA programming problems I have encountered... His passing is no doubt a big blow to the entire excel community and I couldn't thank him enough for all his generous
    contibutions to helping excel users worldwide.

    Thank you Bill and Greg for your efforts in getting Chip's site back.


    Last edited by Jaafar Tribak; May 9th, 2018 at 04:03 AM.
    Office/Excel 2010 64Bits -- Win10 64Bits

    Common sense is not so common.


    http://photo-larache.blogspot.com/

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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