Capping MLB 2007 #101a Ov/Un plus Las Vegas Q&A

[pops69]

bill: put LM up in the filter area on the holly wip and than see if you can move other variables into the bottom area and get a better feel for NLM

p.s. forget it, you cant, or at least i couldnt get it in both areas

 

[pops69]

this one works. filter LM to show only 0, than add the combined ERA Rank to the filter area. decent distribution, now looking for any patterns

 

[BillDildeaux]

this one works. filter LM to show only 0, than add the combined ERA Rank to the filter area. decent distribution, now looking for any patterns

There are some good ones there.

 

[pops69]

now were getting somewhere

on the NLM

AVG Score Minus to the OL, ERA Rank 3-7

10o=18u

AVG Score Plus to the OL, ERA Rank 3-7

43o-33u

finally, the numbers are where you would expect them to be for the NLM

the ERA in the 8-16 typical shit pitchers look about 50/50 in the minus and plus avg scores to OL

fuck that's much much better. only prob is that i dont have era rank in the wa nps, it part of the al and nl combined, but the table to get it is at the top of the sheet

 

[BillDildeaux]

Pops now all I need is the key for era rank.

rank1 = ?era
rank2 = ?era
and so on

I can try to figure it out if you dont know off hand. Tks

 

[pops69]

Pops now all I need is the key for era rank.

rank1 = ?era
rank2 = ?era
and so on

I can try to figure it out if you dont know off hand. Tks

col CQ CR and CS. CS is the combination of CQ and CR, the cal to get each is in CQ and CR and the calc is ref in the table in row 2 CT thru DA

 

[BillDildeaux]

col CQ CR and CS. CS is the combination of CQ and CR, the cal to get each is in CQ and CR and the calc is ref in the table in row 2 CT thru DA

Shit pops that calculation looks complicated. I guess its time for me to put my Excel thinking cap on.

 

[pops69]

Shit pops that calculation looks complicated. I guess its time for me to put my Excel thinking cap on.

look at the table at the top of the sheet rows 2 thru 9 col ct-da. a little math there but you can see the ranges. plus if you feel those ranges should be different, it's easy to make the changes there and everything just recalc based on those changes

the more time i spend with the spreadsheet, it's fucken amazing

the answers to anything you want to know is there at the push of a botton

 

[BillDildeaux]

look at the table at the top of the sheet rows 2 thru 9 col ct-da. a little math there but you can see the ranges. plus if you feel those ranges should be different, it's easy to make the changes there and everything just recalc based on those changes

the more time i spend with the spreadsheet, it's fucken amazing

the answers to anything you want to know is there at the push of a botton

Ok thanks I think I got it.

This SS is amazing and effortless.

 

[pops69]

here's what i'm looking for

have a 3x3x2ft equipment closet in the garage that holds a bunch of key computer and sat equipment. temp is well over 100 with two fans inside that small area. anyone know of a small a/c unit that i could put in that area to drop it to the 70s

 

[pops69]

here's what i'm looking for

have a 3x3x2ft equipment closet in the garage that holds a bunch of key computer and sat equipment. temp is well over 100 with two fans inside that small area. anyone know of a small a/c unit that i could put in that area to drop it to the 70s

forget it, i just solved my prob. just going to buy a small ref and drill a couple of holes in each side and put the equipment in in and lose the two fans. man i'm smart

 

[ILMW]

If you have room to vent out somewhere get a squirrell cage fan and let the heat escape that way. Dont think though it would lower 30 degrees.

http://www.plantitearth.com/store/product.asp?pid=135&catid=5

The 465 moves 465 cubic feet of air per minute. Nice exchange.

Pops cannot believe youre pushing 70 and you got 2 modded xboxes, that is funny shit. I have cursed at a few fvcks during on line play because their shit was flying across the map and cannot hit what you cannot see.

 

[pops69]

If you have room to vent out somewhere get a squirrell cage fan and let the heat escape that way. Dont think though it would lower 30 degrees.

http://www.plantitearth.com/store/product.asp?pid=135&catid=5

The 465 moves 465 cubic feet of air per minute. Nice exchange.

Pops cannot believe youre pushing 70 and you got 2 modded xboxes, that is funny shit. I have cursed at a few fvcks during on line play because their shit was flying across the map and cannot hit what you cannot see.

i actually have 3 mod xboxes, one is the 360 as well

 

[BillyWaltersJr+]

i have (2) mod original xboxes, also two 360's, 1 white and 1 black elite, and 1 ps3. i like the ps3 but shit for games out there, but the controller is nice and light. the new elite is so much noiser than the original 360 but overall many more decent games on the 360 vs ps3. also have a wi but that in the main house for the grand kinds when they come over, everyone has the most fun with that one, although i almost never play it

i'm a 1 person shooter guy, and only way to play a good game is laying on your back

Yeah, I know what you mean about the PS3 having no games, but we should probably be getting some more within the next few months, plus the new GTA is coming out in October. Have you ever played Resistance for PS3, my vote for best game out there for that system right now, Motorstorm and RB6V is pretty good too.

I might buy the 360 in a month or two, Halo 3 comes out soon and I want to see what all of the hype is about (barely played the first one and not at all on the second).

 

[pops69]

Yeah, I know what you mean about the PS3 having no games, but we should probably be getting some more within the next few months, plus the new GTA is coming out in October. Have you ever played Resistance for PS3, my vote for best game out there for that system right now, Motorstorm and RB6V is pretty good too.

I might buy the 360 in a month or two, Halo 3 comes out soon and I want to see what all of the hype is about (barely played the first one and not at all on the second).

finished fall of man on all levels in less than a week after it came out. it was decent, but not as good as GOW

 

[pops69]

fyi, i'm in the process up upgrading the internal data network in my office and house to a Gigabit with new switches and router so i'll be up and down from time to time

shopping for a 9 in tonights game, if i find one that where i'm going

back from time to time

 

[BillyWaltersJr+]

finished fall of man on all levels in less than a week after it came out. it was decent, but not as good as GOW

I finished in about a month after I got it, didn't play it that much until just recently.

Do you ever play online?

 

[pops69]

I finished in about a month after I got it, didn't play it that much until just recently.

Do you ever play online?

i have with the 360, but never with the ps3. the one thing i do not like at all about the new 360 elite is the fan and dvd drive noise. got to be a least 10 times more than my original 360. the p3 is so quiet you dont even know it's on.

 

[patswin]

i like it. just uploaded july 11th rev c. the holly wip (although holly number is not included) pretty well reinforces my opinion on the line moves on ov/un. but this shows it in relation to the scoring avg (which is very close to what the OL comes out as)

i have a legend in that pivot, but basically the M is where the scoring avg is less than the opening line. and P is where it more than the opening line


pops been looking over the latest rev master tonight. i am trying to figure out the holly wip tab. i think i have it figured out, for example, al games where the scoring avg is 1 run higher than the o/l the result is 3o 1u. am i interpreting it correctly? and does this help in knowing whether or not to fade line moves or does it tell you to bet o or u?

 

[pops69]

i like it. just uploaded july 11th rev c. the holly wip (although holly number is not included) pretty well reinforces my opinion on the line moves on ov/un. but this shows it in relation to the scoring avg (which is very close to what the OL comes out as)

i have a legend in that pivot, but basically the M is where the scoring avg is less than the opening line. and P is where it more than the opening line


pops been looking over the latest rev master tonight. i am trying to figure out the holly wip tab. i think i have it figured out, for example, al games where the scoring avg is 1 run higher than the o/l the result is 3o 1u. am i interpreting it correctly? and does this help in knowing whether or not to fade line moves or does it tell you to bet o or u?

just got about half of the new network up and running. M=where the team home/away-day/night scoring avg is less than the opening line regardless of the amount. and P= where it greater than the opening line

let me know if that makes any easier. althought the tab say's holly wip, no holly in the pivots
numbers.