|
Post by Steve Nash on Mar 24, 2016 13:29:34 GMT
Cavs, Bulls, Clippers.
|
|
|
|
Post by dunksby on Mar 24, 2016 15:03:47 GMT
CLE CHI Clippers
|
|
|
|
Post by Hellfire Missile Pack on Mar 24, 2016 15:10:08 GMT
Cavaliers Bulls Clippers
|
|
|
Deleted
•
Posts: 0
Likes:
|
Post by Deleted on Mar 24, 2016 15:10:47 GMT
-----UPDATED STANDINGS------ 1. BasedTom (12-3) +0 2. Legend of Sauga (11-4) +0 2. Browntown (11-4) +0 2. KyleKong (11-4) +25. Killbot (10-5) -16. rondo (9-6) -2 6. American Badass (9-6) -26. Chrome (9-6) +26. dunksby (9-6) +5
6. Jaydacris (9-6) +56. ThatAdmiral (9-6) +512. fplii (8-7) -412. dm (8-7) -414. Outbreak (7- -3 15. TeeEssKay (5-10) +0 15. SugarHill (5-10) +117. Gabi (3-12) +0
|
|
|
Deleted
•
Posts: 0
Likes:
|
Post by Deleted on Mar 24, 2016 15:24:02 GMT
|
|
|
Deleted
•
Posts: 0
Likes:
|
Post by Deleted on Mar 24, 2016 15:48:26 GMT
Cavs, Bulls, Clippers.
|
|
|
|
Post by KyleKong on Mar 24, 2016 15:53:33 GMT
Cavs, Bulls, Clippers
|
|
|
|
Post by KyleKong on Mar 24, 2016 15:53:56 GMT
I'm coming for you Tom
|
|
|
Deleted
•
Posts: 0
Likes:
|
Post by Deleted on Mar 24, 2016 16:24:45 GMT
|
|
|
|
Post by SugarHill on Mar 24, 2016 16:29:05 GMT
I'm liking this new format, tsk. Do your thing mane. We are tied. Blood brothers. Dumb brothers.
|
|
|
|
Post by dunksby on Mar 24, 2016 16:29:44 GMT
Looks good.
|
|
|
Deleted
•
Posts: 0
Likes:
|
Post by Deleted on Mar 24, 2016 16:30:27 GMT
CAVALIERS .VS. NETS - ST 7:30 PM
BULLS .VS. KINCKS - ST 7:30 PM
BLAZERS .VS. CLIPPERS - ST 10:30 PM
|
|
|
|
Post by Hellfire Missile Pack on Mar 24, 2016 16:30:28 GMT
I'm fine with either. I prefer you to stick to this one though, since you already put in the effort, unless it will be a pain to maintain. I'm surprised you went through all the trouble of putting people's picture in Excel. Copy and pasting images into excel and then aligning them is absolutely horrible experience
|
|
|
|
Post by Steve Nash on Mar 24, 2016 16:30:51 GMT
|
|
|
|
Post by Hellfire Missile Pack on Mar 24, 2016 16:32:56 GMT
Are you manually hand typing this or is this done by formulas? If done by formulas this is quite impressive to do a change in position like that. Although, you could just have two sets of data (one old and one new) and do a formula based on their old ranking and new ranking.
|
|
|
Deleted
•
Posts: 0
Likes:
|
Post by Deleted on Mar 24, 2016 16:33:50 GMT
I'm fine with either. I prefer you to stick to this one though, since you already put in the effort, unless it will be a pain to maintain. I'm surprised you went through all the trouble of putting people's picture in Excel. Copy and pasting images into excel and then aligning them is absolutely horrible experience the pictures really weren't that bad tbh. whole thing took prolly 20mins, but will only take a couple mins to update each day. the up and down arrows were way more annoying than the avys The record is automatically updated but i'll have to adjust "trending" manually.
|
|
|
Deleted
•
Posts: 0
Likes:
|
Post by Deleted on Mar 24, 2016 16:38:36 GMT
That looks cool man.
|
|
|
|
Post by Hellfire Missile Pack on Mar 24, 2016 16:39:51 GMT
Ah so those arrows were manual.
Not sure if this would work since I haven't tried this mathematical formula, and I don't know your layout. Have an old data table and a new data table that incorporates today
Then do for the ranking change column
=SUMIFS(Rank cells location new today, Username cell location new today, Specific username)- SUMIFS(Rank cells location old data, Username cell location old data, Specific username)
Then do some kind of conditional formatting that shows trends.
So whenever it's the next day, you copy all, but the ranking change column and paste into old data (paste special values). You already have the automatic calculation for the new data table already in place.
|
|
|
Deleted
•
Posts: 0
Likes:
|
Post by Deleted on Mar 24, 2016 16:41:06 GMT
Ah so those arrows were manual. Not sure if this would work since I haven't tried this mathematical formula, and I don't know your layout. Have an old data table and a new data table that incorporates today Then do for the ranking change column =SUMIFS(Rank cells location new today, Username cell location new today, Specific username)- SUMIFS(Rank cells location old data, Username cell location old data, Specific username) Then do some kind of conditional formatting that shows trends. yeah i'll be playing around with it some more, im lazy so i'd like to do as little as possible each day will give this a shot
|
|
|
|
Post by Last Stand on Mar 24, 2016 16:54:23 GMT
Cavaliers Bulls Clippers
|
|
|
Deleted
•
Posts: 0
Likes:
|
Post by Deleted on Mar 24, 2016 17:30:43 GMT
Nets Knicks Blazers
|
|
|
|
Post by SugarHill on Mar 24, 2016 17:38:15 GMT
Look at this cute contrarian
|
|
|
Deleted
•
Posts: 0
Likes:
|
Post by Deleted on Mar 24, 2016 18:31:05 GMT
moe gonna make playoffs and knock off a top seed
|
|
|
|
Post by Scottie4Hottie on Mar 24, 2016 18:31:14 GMT
I absolutely love it.
|
|
|
|
Post by fpliii on Mar 24, 2016 18:44:01 GMT
Cavs Knicks Clippers
|
|
|
|
Post by Scottie4Hottie on Mar 24, 2016 19:27:28 GMT
@guyina4000dollarsuit you gotta make your picks.
|
|
|
|
Post by dm on Mar 24, 2016 19:35:03 GMT
Cavs, Bulls, Clips
|
|
|
|
Post by Scottie4Hottie on Mar 24, 2016 19:45:27 GMT
@guyina4000dollarsuit you gotta make your picks. Cavs knicks clips Just woke up sorry dont apologize I just really want your picks in with the 12 hour time difference.
|
|
|
Deleted
•
Posts: 0
Likes:
|
Post by Deleted on Mar 24, 2016 20:35:42 GMT
nah, he should definitely apologize.
|
|
|
|
Post by Hellfire Missile Pack on Mar 24, 2016 20:38:27 GMT
Ayo TSK,
There's a typo in that graphic. I noticed mine says 11-4 and 5th place, but I should be 10-5.
|
|
|