Comish 30GM Draft Excel Tool

[notubble]

I was creating something for myself out of the player salary and position eligibility list, and it seems to have cannonballed into something that i will probably end up using for my draft to see some things. I was wondering if you guys would be interested in having a tool available to you something like this..

There is a sheet which will allow you to input a players name. When this name is typed the following will be displayed in the Tool:

-Player\'s info from Salary list will be displayed ($,GP,G,etc.)
-Player\'s Hit to the salary cap will be deducted from 1000
-Calculation of avg salary to be spent on remaining REQUIRED picks
-# of REQUIRED picks left

I can edit this to display total number of picks ALLOWED while subtracting from when you input the players\' names and just make it a general cap hit calculation as opposed to keeping it in the whole \"REQUIRED\" picks idea.

I don\'t know if this will help anyone, i don\'t know if it will help speed the draft up. This is my first draft ever and my first dynasty league i have joined so this started mainly so i could just organize what im doing.

Here is a picture of what it looks like, please post your comments on this idea and if you think you guys would be interested in this

[notubble]

[img size=499]http://i27.tinypic.com/t5ncqo.jpg[/img]

[honduranhockey]

Wow, that\'s impressive. Nice work!

[The Comish]

Very nice idea notubble. I did something similar for a salary cap pool I\'m in - it\'s not as nice as yours looks though!

Certainly most people will need to keep track of their salary and how much they have left to spend. It will become very important later in the draft when (if) you are getting close to the cap limit.

You can send it to me if you like, I would likely use it over mine. I can always doctor up the excel formulas to make it do what I want it to. Great idea.

[Nehithaw]

Awesome job notubble. I would definitely be interested in something like that.

I rarely announce it when I do it, but Karma for you.

[sd1976]

I\'ll take a copy too if possible..

Can you send it to [email protected] ???

[DieHardWingsFan]

Yeah good idea I would use that for sure good work.

[Raccer]

I want it too please !!

[C-Lo]

I\'d love to have a look at that and see if I can put it to use in my league. Email [email protected]

Thanks so much

[Crazynuck]

Maybe you could just email it to everyone in the Commish Pool since you have all our emails.

thx in advance

[Torture]

I would love that if you\'re willing to share it with your competition! :P

[email protected]

[notubble]

Thanks for the quick replies guys, I will be completing this tool so that it suits the Comish 30 team dynasty layout.

I will release a version of it so that people in other leagues will be able to use this for their own use, maybe just giving one row of each example for formulas and such.

Pertaining to the 30 Team League:

In an Effort to slim the tool down to a smaller more straight forward size, i would like some suggestions to help get it

- What are the chances that someone will have more than 3 goalies?

I have already reduced the size of fonts, and made it a bit smaller, and i also had it zoomed to 120% when i did the screen shot, so, it is smaller then it appears.

Please let me know some ideas as to roster sizes, etc that would help to make it smaller.

Would anyone be interested in a way of calling up multi-year stats pages? I know i would like to see that stuff, but to compile a list like that, it will be pretty difficult to try and do it myself, anyone with some sort of spreadsheet master list of multi year stats (maybe 3-5 years) would like to donate a little time or pass it along to me, i would love to try and get something like that incorporated into this.

I am also looking in to how efficiently i can make the list use drop down lists so that we don\'t need to remember how to spell Marc-Edouard Vlasic, for example.

I started this project for myself, but since i found this website it has been of the most significant help for my success in my first season of fantasy hockey (07-08) and helped me achieve first place victory in most all of my leagues, thanks to the guys throughout these forums, and i feel like it is time to give back something that will help you guys, and maybe this site down the road.

Sean

[The Comish]

Crazynuck wrote:

Maybe you could just email it to everyone in the Commish Pool since you have all our emails.

thx in advance

I\'ll do that if Sean would like. It might be easier. Or he could just hit reply to all on one of my earlier emails (I\'ve broken the dist lists up into 3 groups of 10).

[Chuk]

Really nice Notubble...

I would be interested in getting a copy to look at with my other similar projects.

Considering there are a lot of regulars in the Commish pool, what does everyone think of asking Dobber to host and allow members to download tools such as this one. maybe as a bonus for all those that buy the fantasy packs or something.


I am not as gifted as Notubble but I was able to create:

a spreadsheet that had all the predictions from all the major fantasy magazines averaged out and broken down into various categories.

a worksheet that used Dobber\'s rankings filtered by NHL Salary for those in leagues that use real NHL salaries.

It might be too much of a burden but it would be nice to share useful tools. They do take a lot of time to develop but considering the amount of fanatics here, we could probably develop some fantastic tools pretty quickly, while constantly improving on existing models.

Just a thought.

[sd1976]

shareware would probably mean new servers for Dobber. You need alot of Bandwidth for something like that...