0
WrongWay

Do you have a DZ.com stalker?

Recommended Posts

Quote

back in your cage with your jello boobies!!!


Shouldn't you be gestating instead of postwhoring?:|

"For once you have tasted Absinthe you will walk the earth with your eyes turned towards the gutter, for there you have been and there you will long to return."

Share this post


Link to post
Share on other sites
Quote

How do you do that dave?



Put the stalkee in the search field, change subject & text to subject only, and the potential stalker in the "only show posts by" field. You'd have to have a suspicion to do it this way though.

Edit to add: Also, the numbers will be skewed if the stalkee's username is actually part of the thread title, not in the [in reply to] brackets.

Blues,
Dave
"I AM A PROFESSIONAL EXTREME ATHLETE!"
(drink Mountain Dew)

Share this post


Link to post
Share on other sites
Quote

how?


% the following gets you the data
  • do a search for [darius11], whole phrase
  • put 2205 results per page (D has 2205 replies to his name)
  • copy the table(cntrl+c)

    % the following puts the data where you can manipulate it
  • go to excel (alt+tab)
  • paste into excel(cntrl+c, cntrl+v)

    % the following gets rid of the data you don’t need (Score, Subject,Forum, Post time )
  • delete all columns, except name (alt+e, alt+d, alt+c,enter)

    % the following orders the data by name
  • sort by name (alt+d, alt+s)

    % the following will count how many times a name has appeared
  • put 1 in cell b1
  • put "=if(a2=a1,1+b1,1)" in cell b2, copy down (cntrl+d)

    % the following will let you know if the count is maxed or not, if they are equal, then they are both 1.
  • put "=if(b1>=b2,1,)" in cell c2, copy down (cntrl+d)

    % the following freeze the counts
  • copy column b and c, (cntrl+c)
  • paste special (values) on top of column b and c, (alt+e,alt+s, alt+v, enter)

    % the following will separate and delete out counts that are not max
  • sort by column c (alt+d, alt+s)
  • delete all rows with a count 0 in c, (alt+e, alt+d, alt+r)

    % the following will order by crazy level, and name if equal crazy level
  • sort by column b then a (alt+d, alt+s)

    i swear i can do it in less than 45 seconds with 1 eye closed
  • Share this post


    Link to post
    Share on other sites
    Quote

    Quote

    how?



  • do a search for [darius11], whole phrase
  • put 2205 results per page (D has 2205 replies to his name)
  • go to excel (alt+tab)
  • copy and paste into excel(cntrl+c, cntrl+v)
  • delete all columns, except name (cntrl+e, cntrl+d, cntrl+c,enter)
  • sortby name (cntrl+d, cntrl+s)
  • put 1 in cell b1
  • put "if(a2=a1,1+b1,1)" in cell b2, copy down (cntrl+d)
  • copy column b, (cntrl+c)
  • paste special (values) on top of column b, (cntrl+e,cntrl+s, cntrl+v, enter)
  • sort by column b (cntrl+d, cntrl+s)
  • delete all rows with a count of less than "x", (cntrl+e, cntrl+d, cntrl+r)
  • sort by column a then b (cntrl+d, cntrl+s)
  • delete rows with less than the max count for each user name. (cntrl+e, cntrl+d, cntrl+r)
  • sort by column b then a (cntrl+d, cntrl+s)

    i swear i can do it in less than 45 seconds with 1 eye closed



  • damn engineers....
    Scars remind us that the past is real

    Share this post


    Link to post
    Share on other sites
    Quote

    sexyberthabitch??


    I thought we had agreed on Sluttybertha. Having second thoughts about the name?:|

    "For once you have tasted Absinthe you will walk the earth with your eyes turned towards the gutter, for there you have been and there you will long to return."

    Share this post


    Link to post
    Share on other sites
    Quote

    if they like sluttybertha, i'm cool with it


    What's not to like about it? It's modern, singing, melts in the mouth, not in the hand, with a touch of sophistication that denotes a je ne sais quoi of French poetry.
    I like it.:|

    "For once you have tasted Absinthe you will walk the earth with your eyes turned towards the gutter, for there you have been and there you will long to return."

    Share this post


    Link to post
    Share on other sites
    Quote

    Quote

    if they like sluttybertha, i'm cool with it


    What's not to like about it? It's modern, singing, melts in the mouth, not in the hand, with a touch of sophistication that denotes a je ne sais quoi of French poetry.
    I like it.:|



    i like it too. now stop hijacking the thread stalker! :P:D

    Share this post


    Link to post
    Share on other sites
    Quote

    Quote

    Quote

    put "if(a2=a1,1+b1,1)" in cell b2, copy down (cntrl+d)



    Can you explain this step better?

    Blues,
    Dave


    =if(a2=a1,1+b1,1) 

    if the previously line indicates the same user as current line, it bumps the count up, else the count is set back to 1



    Damn engineers...

    :D:D:D
    Scars remind us that the past is real

    Share this post


    Link to post
    Share on other sites

    Join the conversation

    You can post now and register later. If you have an account, sign in now to post with your account.
    Note: Your post will require moderator approval before it will be visible.

    Guest
    Reply to this topic...

    ×   Pasted as rich text.   Paste as plain text instead

      Only 75 emoji are allowed.

    ×   Your link has been automatically embedded.   Display as a link instead

    ×   Your previous content has been restored.   Clear editor

    ×   You cannot paste images directly. Upload or insert images from URL.

    0