d2jsp
Log InRegister
d2jsp Forums > Off-Topic > Sports Coliseum > Hockey > <<jsphl Data Filtering>> > Might Be Helpful For Some
12Next
Add Reply New Topic New Poll
Member
Posts: 27,518
Joined: May 10 2009
Gold: 13,891.00
Jul 9 2011 05:28pm
I am working on getting this pivot table feature available in a functional/shared format for everyone (if it would be useful and tom approves) but currently googles pivot tables are broken to say the least :lol:
I have never made a video like this before so I hope it came out in a way that is helpful to you lol.
The problem right now is that you have to remake this table every time tom updates the stats (if you desire). But dont worry, I've been searching high and low to make a usable table like this in a shared format.
Ive never used any video editing program or made a video for that matter before. With that, I think it came out pretty cool :p

http://www.screencast.com/t/pUd4g2yX

I am most likely going to do a few videos like this for things like Yahoo! fantasy etc etc but thats another day.

Was it helpful? Is this a function that you think would help you find what you are looking for in this league?
Member
Posts: 18,250
Joined: Sep 9 2007
Gold: 3,642.90
Jul 9 2011 05:34pm
Sexy, I was doing something like this earlier, but pivot tables > VLookup

Gonna go set this up

Thanks for the vid bro!
Member
Posts: 27,518
Joined: May 10 2009
Gold: 13,891.00
Jul 9 2011 05:37pm
Quote (FunOnABun @ Jul 9 2011 07:34pm)
Sexy, I was doing something like this earlier, but pivot tables > VLookup

Gonna go set this up

Thanks for the vid bro!


:thumbsup:
Thanks- I hope people can actually get some use out of this :p
Member
Posts: 20,715
Joined: Mar 1 2008
Gold: 82.00
Jul 9 2011 05:50pm
Did this, works great! Thanks a lot, that was well worth the time ! :hug:
Member
Posts: 27,518
Joined: May 10 2009
Gold: 13,891.00
Jul 9 2011 06:02pm
Quote (jimmym007 @ Jul 9 2011 07:57pm)
Is there any way to sort it by my actual lines instead of by default alphabetical order?


Yes. Click the top of the column you would like to filter (probably First Name). Go to "More Sort Options".
Move your cursor to the lower right corner of the selected cell and move it around until you get the cursor that is 4 arrows pointing in all direction (up down left right).
With this cursor style, you can drag and drop that name anywhere in that column you like.

Let me know if you have any questions
Member
Posts: 53,772
Joined: Aug 7 2008
Gold: 630.01
Jul 9 2011 06:12pm
on my iPhone will do this when I get home :o
Member
Posts: 27,518
Joined: May 10 2009
Gold: 13,891.00
Jul 9 2011 06:16pm
Quote (BB_MelloYello @ Jul 9 2011 08:12pm)
on my iPhone will do this when I get home :o


cool :D
the video will make a lot more sense when you have a clear resolution :p
cant imagine the text comes in real well on a phone. Thats why I didnt use youtube. Resolution was bad :(
Member
Posts: 23,156
Joined: Nov 2 2009
Gold: 15,900.90
Jul 9 2011 06:52pm
great tutorial
Member
Posts: 53,772
Joined: Aug 7 2008
Gold: 630.01
Jul 9 2011 07:31pm
this some cool beans right here :o

zooming in/zooming out blows my mind
Member
Posts: 47,317
Joined: Aug 27 2008
Gold: 30,000.00
Jul 9 2011 07:36pm
Hey what's going on guys.
Go Back To Hockey Topic List
12Next
Add Reply New Topic New Poll