Announcement

Collapse
No announcement yet.

2006 Lists Part I

Collapse
This topic is closed.
X
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Thanks for the aprpeciation guys, it is a slow and labourious process to check the lsit each month, i have to copy from the members list just over 3000 names each month. ( i refuse t ospend the time downloading all 70,000 members when only the top 3000 are really posters.)

    After that i have to run a script that looks for missing names. Then i have to manually check the name change thread and update as necessary, then i have to seek if anyone has been Banned (they dont show in Member lsit when banned).

    after all that i need to add a couple more columns of formulaes that do a lookup to find the posts total, calculate the days since last update and finally sort the list into PPD for last month
    GM of MAFIA #40 ,#41, #43, #45,#47,#49-#51,#53-#58,#61,#68,#70, #71

    Comment


    • Originally posted by Rasputin
      Thanks for the aprpeciation guys, it is a slow and labourious process to check the lsit each month, i have to copy from the members list just over 3000 names each month. ( i refuse t ospend the time downloading all 70,000 members when only the top 3000 are really posters.)

      After that i have to run a script that looks for missing names. Then i have to manually check the name change thread and update as necessary, then i have to seek if anyone has been Banned (they dont show in Member lsit when banned).

      after all that i need to add a couple more columns of formulaes that do a lookup to find the posts total, calculate the days since last update and finally sort the list into PPD for last month
      All that just to feed a family

      Thanks a bunch (From a Big Eater)
      Attached Files
      Hi, I'm RAH and I'm a Benaholic.-rah

      Comment


      • Originally posted by Rasputin
        Thanks for the aprpeciation guys, it is a slow and labourious process to check the lsit each month, i have to copy from the members list just over 3000 names each month. ( i refuse t ospend the time downloading all 70,000 members when only the top 3000 are really posters.)

        After that i have to run a script that looks for missing names. Then i have to manually check the name change thread and update as necessary, then i have to seek if anyone has been Banned (they dont show in Member lsit when banned).

        after all that i need to add a couple more columns of formulaes that do a lookup to find the posts total, calculate the days since last update and finally sort the list into PPD for last month
        I had no idea it was so much work. I´m impressed
        I love being beaten by women - Lorizael

        Comment


        • Rasputin
          ~ If Tehben spits eggs at you, jump on them and throw them back. ~ Eventis ~ Eventis Dungeons & Dragons 6th Age Campaign: Chapter 1, Chapter 2, Chapter 3, Chapter 4: (Unspeakable) Horror on the Hill ~

          Comment


          • Well it gives me sonething to do....

            The Excel Spreadsheet is growing quite large now.

            Posters > 500 = 203
            Posters > 1000 = 207
            Posters > 3000 = 203
            Posters > 10000 = 24
            Posters > 20000 = 5
            GM of MAFIA #40 ,#41, #43, #45,#47,#49-#51,#53-#58,#61,#68,#70, #71

            Comment


            • Whats my current PPD, out of curiosity?
              I'm building a wagon! On some other part of the internets, obviously (but not that other site).

              Comment


              • Originally posted by Skanky Burns
                Whats my current PPD, out of curiosity?
                9.13 ppd
                Hi, I'm RAH and I'm a Benaholic.-rah

                Comment


                • is that overall? or for the month of Feb?
                  Gurka 17, People of the Valley
                  I am of the Horde.

                  Comment


                  • Originally posted by Paddy the Scot
                    is that overall? or for the month of Feb?
                    He asked for current..which currently he has

                    I dont have, if he was asking for, the month of February
                    Hi, I'm RAH and I'm a Benaholic.-rah

                    Comment


                    • According to the search function, Skanky's posted 73 times in the past month, so it's about 2.5 ppd currently. Of course, that doesn't count private forums, so it could be higher.

                      Vovan
                      XBox Live: VovanSim
                      xbox.com (login required)
                      Halo 3 Service Record (I fail at FPS...)
                      Spore page

                      Comment


                      • Originally posted by vovan
                        According to the search function, Skanky's posted 73 times in the past month, so it's about 2.5 ppd currently. Of course, that doesn't count private forums, so it could be higher.

                        Vovan
                        Ok

                        "currently" it is 9.13 ppd over the life of his status here

                        The "past Month" he may have 2.5 ppd but it is not even February anymore so that too would be past tense

                        Just sharing folks
                        Hi, I'm RAH and I'm a Benaholic.-rah

                        Comment


                        • Originally posted by Grandpa Troll
                          "currently" it is 9.13 ppd over the life of his status here
                          I assume Skanky was asking about his PPD over the past month, because I am guessing he can look up the number in the profile himself. Or is he that lazy?

                          Vovan
                          XBox Live: VovanSim
                          xbox.com (login required)
                          Halo 3 Service Record (I fail at FPS...)
                          Spore page

                          Comment


                          • Originally posted by vovan


                            I assume Skanky was asking about his PPD over the past month, because I am guessing he can look up the number in the profile himself. Or is he that lazy?

                            Vovan
                            not sure but I did look to Miriam Webster:

                            cur·rent ( P ) Pronunciation Key (kûrnt, kr-)
                            adj.

                            1-Belonging to the present time: current events; current leaders.
                            2-Being in progress now: current negotiations.
                            3-Passing from one to another; circulating: current bills and coins.
                            4-Prevalent, especially at the present time: current fashions. See 5-Synonyms at prevailing.
                            6-Running; flowing.



                            I was thinking currently his ppd is 9.13 as oppossed to what it was last year or period ending Dec 2005

                            Well, I am off to be and counting sheep, I shall allow greater minds than mine to answer what he wants

                            Hi, I'm RAH and I'm a Benaholic.-rah

                            Comment


                            • Originally posted by Grandpa Troll
                              not sure but I did look to Miriam Webster:
                              The question is: did he look in the dictionary before posting?



                              Vovan
                              XBox Live: VovanSim
                              xbox.com (login required)
                              Halo 3 Service Record (I fail at FPS...)
                              Spore page

                              Comment




                              • I'm too lazy to look up the dictionary before posting, but not too lazy to look at my own profile. I guess I'm an intermediate level of laziness overall.

                                But yes, I meant my monthly ppd for February.
                                I'm building a wagon! On some other part of the internets, obviously (but not that other site).

                                Comment

                                Working...
                                X