d2jsp
Log InRegister
d2jsp Forums > d2jsp > Ladder Slasher >
Poll > Like The New Sc's Best List > Post Opinions & Thoughts Here
Prev13456Next
Add Reply New Topic New Poll
Views: 2650Replies: 59Track Topic
  Guests cannot view or vote in polls. Please register or login.
Member
Posts: 16,612
Joined: Aug 15 2007
Gold: 104.76
#41
Jan 29 2011 07:53am
It is quite appearant that you have knocked Jerry Springer to the number 2 spot on Cincinnati's most famous citizen list.

The spread sheet certainly showcases your items much better than the old format. Looks like a lot of time and effort.


Grats

This post was edited by BigDuke6 on Jan 29 2011 07:53am
Member
Posts: 33,492
Joined: Mar 15 2006
Gold: 19,830.79
#42
Jan 29 2011 08:49am
Quote (McClain @ 29 Jan 2011 07:35)
This ^^


Lol, I've been carrying that topic in tracked and even saved as a bookmark ^^
http://forums.d2jsp.org/topic.php?t=49142803&f=272&p=327982515


@Nick: I love what you've done :love:

This post was edited by barteq88 on Jan 29 2011 08:49am
Member
Posts: 12,411
Joined: Feb 17 2009
Gold: 33,836.87
#43
Jan 29 2011 09:13am
Mike, I just checked it on 4x of my computers and all was fine. I dunno really. I can't see how anything from Google would lag, but seems so.
I know I could also always share the .xlsx document itself that I use and upload it somewhere for it to be download, but I dunno how management here would feel about that. lmk if that changes for you.


@everyone: ty for the kind remarks. :)
Member
Posts: 37,613
Joined: May 3 2007
Gold: 119,903.34
#44
Jan 29 2011 09:17am
Quote (WarFox @ Jan 29 2011 08:22am)
I am almost positive I've used that 25 axe before. :headscratch:


Yeah, I thought I was cool and saw a mistake.
Member
Posts: 20,726
Joined: Jan 2 2007
Gold: 94,877.84
#45
Jan 29 2011 09:17am
Quote (DeafBoy @ Jan 29 2011 10:17am)
Yeah, I thought I was cool and saw a mistake.


Yea you aren't
Member
Posts: 37,613
Joined: May 3 2007
Gold: 119,903.34
#46
Jan 29 2011 09:18am
Quote (Boss @ Jan 29 2011 10:17am)
Yea you aren't


Yeah, I was made aware of this.
Member
Posts: 5,097
Joined: Aug 23 2006
Gold: 12.01
#47
Jan 29 2011 09:31am
great stuff, thanks Nick
Banned
Posts: 4,682
Joined: Jul 11 2008
Gold: 26,791.50
Warn: 20%
#48
Jan 29 2011 09:41am
Quote (HoR_Rahl @ Jan 29 2011 07:03am)
Still not working :cry:

http://i53.tinypic.com/15ohvtc.jpg


Working for me... Javascript is enabled?

Quote (Stok3d @ Jan 29 2011 09:13am)
Mike, I just checked it on 4x of my computers and all was fine.  I dunno really.  I can't see how anything from Google would lag, but seems so.
I know I could also always share the .xlsx document itself that I use and upload it somewhere for it to be download, but I dunno how management here would feel about that.  lmk if that changes for you.


@everyone:  ty for the kind remarks.  :)


If you press the "go to spreadsheet view" option, you can go to File->Download as->...
You can download the googledoc, as .csv, .html, .txt, .xsl, .pdf, and as an open office document.

So if google docs isn't working for someone, and they need to search the document or whatnot, they can always download it, in 1 of those 6 formats. I'd be surprised if at least one of them didn't work...

This post was edited by TunEArmY on Jan 29 2011 09:44am
Member
Posts: 8,044
Joined: Jul 30 2007
Gold: 8,118.97
#49
Jan 29 2011 09:52am
Great job, looks very professional.
Member
Posts: 12,411
Joined: Feb 17 2009
Gold: 33,836.87
#50
Jan 29 2011 09:53am
Quote (Stok3d @ Jan 29 2011 02:55am)
Found an error with my formula on determining unique names and then counting each occurance.
R2 (hidden): =IFERROR(INDEX(A:A,MATCH(,INDEX(ISNA(MATCH($A$2:$A$700,R$1:R1,))-1,),)+1,),"")
S2 (hidden): =IF(COUNTIF($A$2:$A$700,R2)>0,COUNTIF($A$2:$A$700,R2),"")

I'm too tired to see where I screwed up, but what I do is copy those down the column. I then simply copy/ paste special (value) to the 2nd tab and sort by column B.
If anyone knows excel and wants to help see where I screwed up, I'll gladly take your suggestion. MrMoJoRising isn't showing up so something is incorrect.


@TunEArmy (Joe): Thank you SO much for fixing my error while I slept. You are AWESOME--the email works perfectly.
If anyone decides to do this google doc for HC, here is the updated coding to be placed in Columns R & S to auto calculate PPLs Totals for Owning a Best In Game:

R Column (Hidden): =INDEX(Owner,MATCH(0,IF(ISBLANK(Owner),"",COUNTIF($R$1:R1,Owner)),0))
S Column (Hidden): =IF(COUNTIF($A$2:$A$700,R2)>0,COUNTIF($A$2:$A$700,R2),"")

Thanks Again Joe! Last thing I want to do is waste time counting after every update!

This post was edited by Stok3d on Jan 29 2011 09:59am
Go Back To Ladder Slasher Topic List
Prev13456Next
Add Reply New Topic New Poll

© 2003-2026 d2jsp  Contact