TheBoards

Go Back   TheBoards > Old School > NBL Archive

Notices

 
 
Thread Tools Search this Thread Display Modes
Old 29-05-2010, 07:13 PM   #1
Cameron84
Member
Default NBL 2010/11 Stat Spreadsheet

Just a quick question -

I am doing up my NBL spreadsheet now that the fixture is out. It includes the following features:

1. Plain copy of the schedule (as per the downloadable one on the NBL website)
2. A separate copy of the schedule (Draw page) where you enter in the score from each game. You can also choose a team on this page and all their games are highlighted (Bold and Black). The times will change according to the team you choose
3. Ladder (Team name, Wins, Losses, Games Behind, Streak, Home record, Away record, Won%, Points%) with a button that automatically sorts it. Ladder page also has a clock that will countdown to the next game (for whichever team you choose from the Draw page)
4. Roster page with each team, coash's name and players' names
5. Playoffs page with the top 4 (I am assuming it is the same format as last season) - this page also has a table that has how many titles each team has won, as well as a year by year grand final result
6. A Head to Head page with each team and their corresponding games for each opponent and round (blank cell turns green for a win and red for a loss)
7. A Game by Game page with each team (kinda like an individual schedule for each team) which shows the round number, whether it is a Home or Away game, opponent, game score, whether its a win on loss and current streak

Now this is the change I made for last season and it was very detailed:

8. An individual page for PPG, RPG, APG, BPG, SPG, TOPG, FTM, FTA etc. The thing is, you have to make sure you enter in the correct stats for each category for each team/player and game. There is a stat page linked to this and when you sort the ladder via the button on the ladder page, it will sort every stat page and will display the top 10 leaders for each category on the stat page.

It is pretty sweet, but it becomes time consuming, especially if teams sign a new player or sack a player (you have to re-arrange the team list for this). I was thinking about just simplifying it and just doing a PPG page instead of every stat.

I was wondering if there are any other aspects of the game that you guys think would improve the spreadsheet? I can'think of anything, so I thought I would just ask everyone.

Once I have finished it, I will put it on GoogleDocs for everyone to use.

Hope this post wasn't too long-winded.
__________________
"why are we only playing 40 minutes where a normal game of basketball all over the world is 48 minutes"

WHAT A NOOB!!!

Last edited by Cameron84; 29-05-2010 at 07:19 PM.
Cameron84 is offline  
Old 08-06-2010, 04:37 PM   #2
boz_novocastrian
Member
Send a message via MSN to boz_novocastrian
Default

Cam,

Cheers for that. was helpful last season
__________________
Life every day to the fullest as if it is your last

So Far 2 Taranaki Players have made in to the NBL:
Jeremiah Trueman - Breakers
Dillon Boucher - Breakers

With one still playing in the league:
Jeremiah Trueman - Breakers

C'mon Taranaki we want some more from the region make it to the nbl
boz_novocastrian is offline  
Old 09-06-2010, 07:58 PM   #3
Cameron84
Member
Default

Quote:
Originally Posted by boz_novocastrian View Post
Cam,

Cheers for that. was helpful last season
The majority of it is done now, I just need to tweak it a bit more and it'll be done.

I've also been pestering the NBL to get each score from past seasons, but apparently itll take and cost too much to do

Will be up on Google Docs soon.
__________________
"why are we only playing 40 minutes where a normal game of basketball all over the world is 48 minutes"

WHAT A NOOB!!!
Cameron84 is offline  
Old 10-06-2010, 12:46 PM   #4
R-Diddy
Member
Default

Quote:
Originally Posted by Cameron84 View Post
The majority of it is done now, I just need to tweak it a bit more and it'll be done.

I've also been pestering the NBL to get each score from past seasons, but apparently itll take and cost too much to do

Will be up on Google Docs soon.
Can you put up a link when it's posted, would love to have a look.
__________________
Visit Can't Buy a Basket.

Or follow us on twitter @cantbuyabasket
R-Diddy is offline  
Old 10-06-2010, 01:08 PM   #5
curious
Watching TS
Default

I assume Minutes PG will apear there as well?
curious is offline  
Old 10-06-2010, 01:50 PM   #6
Cameron84
Member
Default

Quote:
Originally Posted by curious View Post
I assume Minutes PG will apear there as well?
It wasn't in it last season but I'll add it.

Player efficiency is in there too.
__________________
"why are we only playing 40 minutes where a normal game of basketball all over the world is 48 minutes"

WHAT A NOOB!!!
Cameron84 is offline  
Old 10-06-2010, 01:50 PM   #7
Cameron84
Member
Default

Quote:
Originally Posted by R-Diddy View Post
Can you put up a link when it's posted, would love to have a look.
Yep, the link will be up as soon as it is done!
__________________
"why are we only playing 40 minutes where a normal game of basketball all over the world is 48 minutes"

WHAT A NOOB!!!
Cameron84 is offline  
Old 10-06-2010, 01:59 PM   #8
DJ Rod
Twitter Ninja
Default

I must have missed this last year but I'm super excited about it this year!

Well done mate - the sport survives on people like you!
DJ Rod is offline  
Old 10-06-2010, 02:00 PM   #9
R-Diddy
Member
Default

Quote:
Originally Posted by Cameron84 View Post
Yep, the link will be up as soon as it is done!
Thanks, I'm working on something to do with week by week stats for each team and would love to see your statistical criteria, analysis and data, it may help me with what I'm doing.

If you like, pm me and I will explain what project I'm doing just so you know I'm not stealing your idea's.
__________________
Visit Can't Buy a Basket.

Or follow us on twitter @cantbuyabasket
R-Diddy is offline  
Old 10-06-2010, 02:06 PM   #10
Cameron84
Member
Default

Quote:
Originally Posted by DJ Rod View Post
I must have missed this last year but I'm super excited about it this year!

Well done mate - the sport survives on people like you!
I wasn't on OzHoops last year - I was using Sportal forums every now and then though.
__________________
"why are we only playing 40 minutes where a normal game of basketball all over the world is 48 minutes"

WHAT A NOOB!!!
Cameron84 is offline  
Old 10-06-2010, 02:26 PM   #11
Cameron84
Member
Default

Quote:
Originally Posted by R-Diddy View Post
Thanks, I'm working on something to do with week by week stats for each team and would love to see your statistical criteria, analysis and data, it may help me with what I'm doing.

If you like, pm me and I will explain what project I'm doing just so you know I'm not stealing your idea's.
I sent you a PM a little while ago.
__________________
"why are we only playing 40 minutes where a normal game of basketball all over the world is 48 minutes"

WHAT A NOOB!!!
Cameron84 is offline  
Old 11-06-2010, 04:50 PM   #12
Cameron84
Member
Smile

The NBL spreadsheet for 2010/11 is now done.

Unfortunately, as it is over 1MB, I can not upload it to Google Docs. I am trailing a similar application that allows me to use bigger sized files.

However, if you want a copy of this, please PM me with your email address and I will send it to you ASAP.

Thanks
__________________
"why are we only playing 40 minutes where a normal game of basketball all over the world is 48 minutes"

WHAT A NOOB!!!
Cameron84 is offline  
Old 11-06-2010, 04:53 PM   #13
curious
Watching TS
Default

does it use pretty colours?
That will bump up the file size massively as will any graphis stufflike, bold, borders.
I would suggest take off all attributes and see what file size you get.
curious is offline  
Old 11-06-2010, 04:57 PM   #14
Cussy+
Boards+ Member
Default

Quote:
Originally Posted by curious View Post
does it use pretty colours?
That will bump up the file size massively as will any graphis stufflike, bold, borders.
I would suggest take off all attributes and see what file size you get.
Dude, you're slipping
__________________
Go, Gary Go, Ervin puts on a show
Cussy is offline  
Old 11-06-2010, 05:28 PM   #15
Cameron84
Member
Default

Split the spreadsheet in half, as Google Docs won't let me upload more than 1 MB at once....grrrr!

Here is the team draw side:

http://spreadsheets.google.com/ccc?k...6VXBuRVE&hl=en

Here is the player stat side:

http://spreadsheets.google.com/ccc?k...KNHNPaEE&hl=en

You can merge them back together if you want.
__________________
"why are we only playing 40 minutes where a normal game of basketball all over the world is 48 minutes"

WHAT A NOOB!!!
Cameron84 is offline  
Old 11-06-2010, 06:32 PM   #16
curious
Watching TS
Default

Quote:
Originally Posted by Cussy View Post
Dude, you're slipping
No.
The (more) observant ones may have noticed that I don't always use uP all the time.
It sometimes catches those unaware.
curious is offline  
Old 12-06-2010, 09:56 PM   #17
Cameron84
Member
Default

Quote:
Originally Posted by Cameron84 View Post
Split the spreadsheet in half, as Google Docs won't let me upload more than 1 MB at once....grrrr!

Here is the team draw side:

http://spreadsheets.google.com/ccc?k...6VXBuRVE&hl=en

Here is the player stat side:

http://spreadsheets.google.com/ccc?k...KNHNPaEE&hl=en

You can merge them back together if you want.
The spreadsheet now includes minutes & minutes per game and fouls & fouls per game.
__________________
"why are we only playing 40 minutes where a normal game of basketball all over the world is 48 minutes"

WHAT A NOOB!!!
Cameron84 is offline  
Old 01-08-2010, 04:59 PM   #18
Cameron84
Member
Default

I will be doing up a spreadsheet for the 2010/2011 NBA season too once the draw is released on August 10. I will also be doing an NBA (and ABA) history one (Have got all the data already, just fixing it up to look more neat and tidy).
__________________
"why are we only playing 40 minutes where a normal game of basketball all over the world is 48 minutes"

WHAT A NOOB!!!
Cameron84 is offline  
Old 01-08-2010, 07:01 PM   #19
mattic
Mr. Pink
 
mattic's Avatar
Default

They are great! Thanks, Cameron.
__________________
As far as we know, we are the first and only instance of the Universe becoming aware of itself. Given long enough, carbon begins to wonder where it came from.
mattic is offline  
 

Bookmarks

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT +10. The time now is 04:38 PM.


Powered by vBulletin® Version 3.8.5
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Design and logos copyright 2000 - 2010, Dek-Net Design