Like The New Sc's Best List - Topic

Member

Posts: 37,613

Joined: May 3 2007

Gold: 119,903.34

Jan 29 2011 09:56am

Quote (Stok3d @ Jan 29 2011 10:53am)

@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:

S Column (Hidden): =INDEX(Owner,MATCH(0,IF(ISBLANK(Owner),"",COUNTIF($R$1:R1,Owner)),0))
R 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!

We don't give a sh1t on HC. We like to spend our time playing the game and laughing at everyone else.

ToughGuy_TJ

Member

Posts: 81,364

Joined: Oct 9 2007

Gold: 313,250.16

#52

Jan 29 2011 11:18am

Quote (DeafBoy @ Jan 29 2011 10:56am)

We don't give a sh1t on HC. We like to spend our time playing the game and laughing at everyone else.

You don't speak for all of HC

Pipe down Paparick

Stok3d

Member

Posts: 12,411

Joined: Feb 17 2009

Gold: 33,836.87

#53

Jan 29 2011 11:43am

Quote (HoR_Rahl @ Jan 29 2011 09:03am)

Still not working :cry:

On the version uploaded to google docs, I removed all the tabulating formulas. This should assist in "latency issues" ppl were experiencing before.
Until _Mork_ updates it, access it here and let me know if you have a better experience: https://spreadsheets0.google.com/ccc?hl=en&key=tHoh-fOQadssz6Ow5wLkHIw&hl=en#gid=0

If not, the only thing I can suggest is what Joe said below:

Quote (TunEArmY @ Jan 29 2011 11:41am)

Working for me... Javascript is enabled?

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...

sir_lance_bb

Member

Posts: 37,613

Joined: May 3 2007

Gold: 119,903.34

#54

Jan 29 2011 11:43am

Quote (ToughGuy_TJ @ Jan 29 2011 12:18pm)

You don't speak for all of HC

Pipe down Paparick

This is like me saying you don't speak for all the trolls on jsp.

VanHalen

Member

Posts: 40,835

Joined: Sep 28 2007

Gold: 275.00

#55

Jan 29 2011 02:58pm

Quote (DeafBoy @ Jan 29 2011 12:43pm)

This is like me saying you don't speak for all the trolls on jsp.

trolling is an art

/e lance you going to make it past nightmare this reset?

This post was edited by VanHalen on Jan 29 2011 02:59pm

sir_lance_bb

Member

Posts: 37,613

Joined: May 3 2007

Gold: 119,903.34

#56

Jan 29 2011 03:08pm

Quote (VanHalen @ Jan 29 2011 03:58pm)

trolling is an art

/e lance you going to make it past nightmare this reset?

I made it through nm brah. I switched to the Barb.

But yeah, I was pushing myself a little to hard and got whacked.

And there isn't going to be another reset for a while brah.

legirotto

Member

Posts: 8,757

Joined: Sep 16 2007

Gold: 133.94

#57

Jan 29 2011 09:22pm

hi nick

suggestion: remove "hybrid" name from sections and change to "stats", since half of them aren't really hybrid but pure melee.

there is one item from mcclain in the list without the main mod, lvl 25 str med armor

and gz for this amazing job

MrMoJoRising

Member

Posts: 11,644

Joined: Sep 9 2007

Gold: 0.00

#58

Jan 30 2011 12:00pm

I love what you have done with the SC Best Items list Nick. The filtering capability is so useful, I love it. And the ranking list keeps User Item Records alive, which I think is also nice.

The amount of time you put into this, to type out every individual character for every single item is astonishing and your commitment and dedication is truly second to none and the LS community should be proud to have you as a part of them.

So, to you I offer my :cheers: