My Automated MLB System - Download - Everyone welcome

[Boxslayer]

lot of work done there man! great job

it looks like a TON of work, but its really not THAT bad. when you get to know excel, the basic thing of the autofill button coupled with formulas is a lifesaver. you gotta write the first formula then just drag it to every cell with autofill.

 

[CapNWatch]

How do we add in more starting pitchers?

 

[Boxslayer]

you must enter them in their correct alphabetical spot on the "Translation-Pitchers" worksheet....then give them a power ranking



Jake peavy is 340.
the average MLB pitcher is 225.
Edwin Jackson is 100.


Then go to the User interface (Power Rankings) Page....and you'll have to write the new pitchers name in manually, as he wont show up on the drop down box until i fix it up

 

[ShiftyMac]

you must enter them in their correct alphabetical spot on the "Translation-Pitchers" worksheet....then give them a power ranking



Jake peavy is 340.
the average MLB pitcher is 225.
Edwin Jackson is 100.


Then go to the User interface (Power Rankings) Page....and you'll have to write the new pitchers name in manually, as he wont show up on the drop down box until i fix it up

once again, beautiful... is there away that when we add new pitchers in the spreadhseet that we can copy formulas so that the new pitchers stats are updated also....? like if i added homer bailey today, assigned him a power ranking for a couple days, then copied and entered a formula so that the system goes out and grabs all his stats and then assigns him a power ranking based on his stats...?

 

[che-chino]

BOXS your system does not have anyplay today:WTF:

thank in advance.:think2:

 

[Boxslayer]

i dont know i havent looked at it

i put the first system play up yesterday but it was premature and i jumped the gun...there is still some work to do on it, tweaking of numbers etc

 

[PyRoCaPPer]

Wrong forum, but are you playing any NBA tonight? I'd go out on a limb saying you will have a pretty big play on the 1st half over as it fits criteria.

 

[ShiftyMac]

think the system has a big play on A's today when i calculated it... think there was like a 60 point difference, line was only -106

 

[rehawk]

i got plays from detroit, a's, and royals. does that sound right?

 

[ShiftyMac]

detroit and A's sound right, did not cap the royals game because i was too tired and went to bed...

the only prob, which isnt really a prob with box's excellent system is the addition of new pitchers and getting their current stats up and running....but definetely love this new system, and we should all thank box for being generous enough to share it, most charge or do not disclose anything

 

[Boxslayer]

very little value on the royals...probably not worth playing...still learning

Braves are showing value

<TABLE style="WIDTH: 280pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=373 border=0 x:str><COLGROUP><COL style="WIDTH: 114pt; mso-width-source: userset; mso-width-alt: 5558" width=152><COL style="WIDTH: 79pt; mso-width-source: userset; mso-width-alt: 3840" width=105><COL style="WIDTH: 87pt; mso-width-source: userset; mso-width-alt: 4242" width=116><TBODY><TR style="HEIGHT: 15.75pt" height=21><TD class=xl26 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 1pt solid; WIDTH: 114pt; BORDER-BOTTOM: #f0f0f0; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent" width=152 height=21>Braves</TD><TD class=xl24 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext; WIDTH: 79pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent" width=105 x:num="293.17500000000001">293.18</TD><TD class=xl24 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext; WIDTH: 87pt; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent" width=116> </TD></TR><TR style="HEIGHT: 16.5pt" height=22><TD class=xl27 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 16.5pt; BACKGROUND-COLOR: transparent" height=22>Twins</TD><TD class=xl25 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent" x:num="309.84375">309.84</TD><TD class=xl25 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent" x:num="-116.66875" x:fmla="=(B1-B2)-100">-116.67</TD></TR></TBODY></TABLE>


Twins should be: -116
Twins are currently: -185

I'm personally playing 4* Braves +165

I dont recommend anyone follow just yet, things need to be tracked and tweaked. Braves one of the best teams in baseball on the road. Johan overvalued. Hudson can hold his own.

 

[ShiftyMac]

any new formulas or updates that we should know about box? thanks for the help

 

[ShiftyMac]

Blah

 

[ShiftyMac]

box, can u help me with something....

when i go to the WQ-pitchers section and press update stats, it updates the stats but then screws all the pitchers formulas on the 'look-up values' page, which then makes the power rankings page on the pitchers all N/A

 

[CalvinTy]

Bump.

Box, great effort on your part with the file! I am back from vacation today & I will check into your file further tomorrow for any comments I may have.

But NickFantana said one thing that I wanted to repeat. You certainly can benefit from using your Office 2007 suite and simply saving the file as an Office 97-2003 file so that you can use the ability to refresh all data instantaneously as mentioned.

I'll go under the hood your file (am too lazy to do it now; rather, I'm quite beat!) & see what thoughts I have. Just wanted to chime in right now on this.

* CalvinTy

 

[chengkeke]

I think this is beyond me. Can someone list the steps as what to do? Much appreciated.
cheng

 

[ShiftyMac]

just read the thread, the steps are all there