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

[cd329]

it's pretty easy to do, in the data tab Data Validation, do col c Series Game, high light row 3 thru 20 (line 20 is the end of my fields for data on the wa nps, than click on Dada Validation, you will see it ref the data right below it. same process for any of the drop down filters

Pops,
2 questions. I just did this for column c, rows 3-20. what exactly is supposed to happen when i do this, cause it looks like nothing happened.
When you open the data validation box, do you just hit the okay button.


second question, when i tried doing it on the visiting pitchers box, heres the message i got when i opened the data validation box
"the selection contains more then one type of validation, erase current settings and continue"
so i hit okay and nothing happened, drop down boxes for visiting pitchers didnt come back.

I love these excel lessons, will be a master by end of baseball season, lollll.

 

[pops69]

Thank you.

Did you go to the fight? I haven't been around much so I didn't read if you did or not.

yes i did and had a great time, especially when jimmy gave the winner. we sat on the opp side of the ring from mc cain but were about 8 rows back, next to that little shit de caprio. i think i was the biggest looking bumb there

 

[pops69]

Pops,
2 questions. I just did this for column c, rows 3-20. what exactly is supposed to happen when i do this, cause it looks like nothing happened.
When you open the data validation box, do you just hit the okay button.


second question, when i tried doing it on the visiting pitchers box, heres the message i got when i opened the data validation box
"the selection contains more then one type of validation, erase current settings and continue"
so i hit okay and nothing happened, drop down boxes for visiting pitchers didnt come back.

I love these excel lessons, will be a master by end of baseball season, lollll.

you need to make sure it's "list", than just drag the range from top to bottom of the data and it will fill in the range, than hit ok to close it

 

[mlfp]

M's/Yanks Results SS

Here's the results sheet for today's M's/Yanks game.
Avg Proj = 9.8
Range = 6.9 - 12.6

GL

 

[pops69]

Pops,

I have been reading the past posts and trying to catch up with things. Im am in college and just got done with my finals so I have a ton of time on my hands and if there is a way I can get in and help with things, I would like to. I look over your PDWS sheets that you post on here a lot and I found a trend the last 2 days that is 5-0-1 and It helped me out. I am not sure if you are going to keep posting them on here but I didn't see it for today and I think it could help us out.

i post pdws every day for anyone to d/l which also includes the popsummary. the complete spreadsheets only go to those that help to collect data for the spreadsheets or special projects. the pdws are the key pitching data which goes into making up the spreadsheets

 

[$4nothing]

<table bgcolor="white" border="0" cellpadding="3" cellspacing="3" width="100%"><tbody><tr><td>5/06/07
09:58:16</td> <td>MLB Baseball</td> <td>MLB Baseball: Gm# 971 Jason Kendall is NOT expected to be in the starting lineup for Oakland. S Stewart is NOT expected to be in the starting lineup for Oakland.</td></tr></tbody></table>

 

[$4nothing]

<table bgcolor="white" border="0" cellpadding="3" cellspacing="3" width="100%"><tbody><tr><td>5/06/07
10:04:59</td> <td>
</td> <td>MLB Baseball: Gm#955 (2B) Ronnie Belliard is NOT expected to be in the starting lineup for Washington</td></tr></tbody></table>

 

[cd329]

you need to make sure it's "list", than just drag the range from top to bottom of the data and it will fill in the range, than hit ok to close it

Pops,
okay i fixed the visiting pitcher drop down. What i did was copy the source from row 20, which was blank and had no pitchers in it, but still had the drop down arrow working. The source code for pitchers row 3-17 was wrong.
Now the dropdown is working, thanks for the excel lesson.
cd

 

[cincy_]

Pops, can I get on the root user notification list? My email is

secretsobriquet at yahoo dot com

 

[pops69]

i assume everyone has the root user plays?

 

[pops69]

Pops, can I get on the root user notification list? My email is

secretsobriquet at yahoo dot com

cincy, sorry guy, it only goes to those that work collecting the data. it wouldnt be fair to all those that are doing to work. if you want to be added to the work detail i'd be glad to add you as i have a couple of open slots in the barrel coming up but i'm close to being full up for the season etc. you need to have office 2007 to be able to do the spreadsheets

 

[cd329]

i assume everyone has the root user plays?

Just the ones you posted. no emails for them, if thats what you are referring to

 

[jacksonjohn]

<TABLE cellSpacing=3 cellPadding=3 width="100%" bgColor=white border=0><TBODY><TR><TD>5/06/07
09:23:05
</TD><TD>Wise Guy Move</TD><TD>Wise Guy Move: Gm# 964 DBACKS-EV</TD></TR><TR><TD vAlign=top width="100%" colSpan=4><HR></TD></TR></TBODY></TABLE>

Are you tailin' these or fadin'?

 

[EasyMoney9]

Thanks for posting em pops, no notifications yet.

 

[pops69]

Just the ones you posted. no emails for them, if thats what you are referring to

those are all of them for the early games

 

[EasyMoney9]

How did the roots do yesterday?

 

[pops69]

How did the roots do yesterday?

won money

 

[coachesplays]

i assume everyone has the root user plays?

I do not have the root user plays.

 

[pops69]

I do not have the root user plays.

i posted them

 

[pops69]

love letter

got an email from daw, leaving nam and heading to china. he didnt like it as much as his last trip, has turn into a hot and humid trash area etc

china in my opinion is mo better as well, especially to the areas he's headed