RotoGuru Baseball Forum

View the Forum Registry


Self-edit this thread


0 Subject: I'm an excel retard

Posted by: Robber - [933287] Fri, Apr 18, 2003, 12:54

I have a spreadsheet that I've maintained throughout the season. It tracks daily price changes for all regular starters, schedules, projected starters (normally about a week out) rainouts, and a running tally of my roster day to day with price increases, roster value etc.
I would like to post it for all to use but I'm just out of my depth. I'd like to e-mail the SS to a guru and after you have successfully posted it walk me through the steps so I can post weekly updates. E-mail me at rsgallagher@hotmail.com.
1Farn
      Donor
      ID: 4710402716
      Fri, Apr 18, 2003, 12:56
Robber- if you want to share the actual spreadsheet just upload it to a server or website and post the link here for others to download.

If you just want to post the results you can just copy and paste it to the forum.
2 Bandos
      ID: 422571916
      Fri, Apr 18, 2003, 13:01
Robber -

You can send it to me again. Here is how to post it.

Select the area you wish to post
Make this the Print area
Save as Web Page
On the Save as Web Page window there is a small box in the middle: save selction. click that.

Save it

Open the file in your web browser by clicking on the icon.
Go to View, click source.

Hit ctrl A to select and then copy.

Paste into the message field and click the yes button below.

Try it.
3 Farn
      Donor
      ID: 4710402716
      Fri, Apr 18, 2003, 13:02
Robber- if you want me to host the file for people to download you can email it to me and I will put up a link for people to download it.
4Robber
      ID: 933287
      Fri, Apr 18, 2003, 13:21
Hitter Update   Hitter Update  
Pitcher Update   Pitcher Update  
Price Increase   Price Increase  
Price Decrease   Price Decrease  
Injuried   Injuried  
Rain Out   Rain Out  
Doubleheader  
             
Thu Fri Sat Sun Mon Tue Wen
4/10 4/11 4/12 4/13 4/14 4/15 4/16
          New York Mets
Fla Mont Mont Mont Mont Pitt Pitt
Glavine Glavine Glavine Glavine Glavine Glavine Glavine
5,770,000 5,770,000 5,770,000 5,770,000 5,770,000 5,770,000 5,770,000
Leiter Leiter Leiter Leiter Leiter Leiter Leiter
5,160,000 5,160,000 5,160,000 5,160,000 5,160,000 5,160,000 5,160,000
Trachsel Trachsel Trachsel Trachsel Trachsel Trachsel Trachsel
3,890,000 3,870,000 3,850,000 3,830,000 3,810,000 3,790,000 3,770,000
Cone Cone Cone Cone Cone Cone Cone
1,140,000 1,160,000 1,170,000 1,170,000 1,160,000 1,140,000 1,100,000
Seo Seo Seo Seo Seo Seo Seo
500,000 500,000 500,000 500,000 500,000 500,000 500,000
          Philadelphia  
Atl Cinn Cinn Cinn Fla Fla Fla
Millwood Millwood Millwood Millwood Millwood Millwood Millwood
6,430,000 6,420,000 6,420,000 6,420,000 6,420,000 6,420,000 6,420,000
Wolf Wolf Wolf Wolf Wolf Wolf Wolf
6,020,000 6,020,000 6,020,000 6,010,000 6,010,000 6,010,000 6,010,000
Padilla Padilla Padilla Padilla Padilla Padilla Padilla
5,240,000 5,240,000 5,240,000 5,240,000 5,240,000 5,240,000 5,240,000
Myers Myers Myers Myers Myers Myers Myers
1,890,000 1,900,000 1,900,000 1,900,000 1,900,000 1,900,000 1,890,000
Roa Roa Roa Roa Roa Roa Roa
1,820,000 1,800,000 1,780,000 1,760,000 1,740,000 1,720,000 1,700,000
             
Thu Fri Sat Sun Mon Tue Wen
4/10 4/11 4/12 4/13 4/14 4/15 4/16
          Montreal  
Chi (N) NY Mets NY Mets NY Mets NY Mets Atl Atl
Armas Jr Armas Jr Armas Jr Armas Jr Armas Jr Armas Jr Armas Jr
3,750,000 3,750,000 3,750,000 3,750,000 3,760,000 3,780,000 3,800,000
Day Day Day Day Day Day Day
1,770,000 1,770,000 1,740,000 1,710,000 1,700,000 1,690,000 1,690,000
Vazquez Vazquez Vazquez Vazquez Vazquez Vazquez Vazquez
5,250,000 5,250,000 5,250,000 5,250,000 5,280,000 5,320,000 5,350,000
Ohka Ohka Ohka Ohka Ohka Ohka Ohka
4,820,000 4,800,000 4,780,000 4,760,000 4,740,000 4,720,000 4,700,000
Hernandez,L Hernandez,L Hernandez,L Hernandez,L Hernandez,L Hernandez,L Hernandez,L
3,730,000 3,710,000 3,690,000 3,670,000 3,650,000 3,630,000 3,610,000
          Atlanta  
Phil Florida Florida Florida   Montreal Montreal
Maddux Maddux Maddux Maddux Maddux Maddux Maddux
5,580,000 5,560,000 5,550,000 5,540,000 5,520,000 5,520,000 5,520,000
Ramirez Ramirez Ramirez Ramirez Ramirez Ramirez Ramirez
800,000 800,000 780,000 740,000 690,000 630,000 560,000
Ortiz Ortiz Ortiz Ortiz Ortiz Ortiz Ortiz
5,250,000 5,250,000 5,250,000 5,250,000 5,250,000 5,250,000 5,250,000
Marquis Marquis Marquis Marquis Marquis Marquis Marquis
1,910,000 1,910,000 1,900,000 1,890,000 1,880,000 1,880,000 1,870,000
Reynolds Reynolds Reynolds
2,340,000 2,320,000
             
Thu Fri Sat Sun Mon Tue Wen
4/10 4/11 4/12 4/13 4/14 4/15 4/16
          Florida  
NY Mets Atl Atl Atl Phil Phil Phil
Penny Penny Penny Penny Penny Penny Penny
3,830,000 3,810,000 3,790,000 3,770,000 3,750,000 3,730,000 3,710,000
Pavano Pavano Pavano Pavano Pavano Pavano Pavano
1,700,000 1,680,000 1,660,000 1,640,000 1,620,000 1,600,000 1,580,000
Redman Redman Redman Redman Redman Redman Redman
3,610,000 3,610,000 3,610,000 3,610,000 3,610,000 3,610,000 3,610,000
Beckett Beckett Beckett Beckett Beckett Beckett Beckett
3,820,000 3,820,000 3,820,000 3,820,000 3,820,000 3,810,000 3,800,000
Burnett Burnett Burnett Burnett Burnett Burnett Burnett
5,960,000 5,940,000 5,920,000 5,900,000 5,880,000 5,860,000 5,840,000
          St Louis  
Col Hou Hou Hou Milw Milw Milw
Morris Morris Morris Morris Morris Morris Morris
5,570,000 5,570,000 5,570,000 5,570,000 5,570,000 5,570,000 5,600,000
Williams Williams Williams Williams Williams Williams Williams
4,420,000 4,420,000 4,420,000 4,420,000 4,420,000 4,420,000 4,420,000
Stephenson Stephenson Stephenson Stephenson Stephenson Stephenson Stephenson
1,580,000 1,580,000 1,580,000 1,580,000 1,570,000 1,560,000 1,550,000
Tomko Tomko Tomko Tomko Tomko Tomko Tomko
3,890,000 3,880,000 3,870,000 3,840,000 3,830,000 3,830,000 3,810,000
Simontacchi Simontacchi Simontacchi Simontacchi Simontacchi Simontacchi Simontacchi
3,590,000 3,580,000 3,550,000 3,520,000 3,490,000 3,470,000 3,450,000
             
Thu Fri Sat Sun Mon Tue Wen
4/10 4/11 4/12 4/13 4/14 4/15 4/16
          Cincinnati  
Hou Phil Phil Phil Cubs Cubs Cubs
Haynes Haynes Haynes Haynes Haynes Haynes Haynes
3,840,000 3,820,000 3,800,000 3,780,000 3,760,000 3,740,000 3,720,000
Dempster Dempster Dempster Dempster Dempster Dempster Dempster
2,630,000 2,620,000 2,610,000 2,610,000 2,610,000 2,600,000 2,580,000
Anderson Anderson Anderson Anderson Anderson Anderson Anderson
1,060,000 1,040,000 1,020,000 1,000,000 980,000 960,000 940,000
Graves Graves Graves Graves Graves Graves Graves
4,390,000 4,370,000 4,350,000 4,330,000 4,310,000 4,290,000 4,270,000
Wilson Wilson Wilson Wilson Wilson Wilson Wilson
2,370,000 2,350,000 2,330,000 2,310,000 2,290,000 2,270,000 2,250,000
          Pittsburgh  
Milw Cubs Cubs Cubs   NY Mets NY Mets
Benson Benson Benson Benson Benson Benson Benson
3,700,000 3,750,000 3,820,000 3,880,000 3,930,000 3,980,000 4,010,000
Wells Wells Wells Wells Wells Wells Wells
4,390,000 4,390,000 4,360,000 4,330,000 4,310,000 4,290,000 4,270,000
Fogg Fogg Fogg Fogg Fogg Fogg Fogg
3,690,000 3,690,000 3,690,000 3,680,000 3,650,000 3,640,000 3,630,000
Suppan Suppan Suppan Suppan Suppan Suppan Suppan
2,590,000 2,610,000 2,630,000 2,650,000 2,670,000 2,670,000 2,700,000
D'Amico D'Amico D'Amico D'Amico D'Amico D'Amico D'Amico
2,360,000 2,340,000 2,320,000 2,300,000 2,280,000 2,260,000 2,240,000
             
Thu Fri Sat Sun Mon Tue Wen
4/10 4/11 4/12 4/13 4/14 4/15 4/16
          Houston  
Cubs St L St L St L SF SF SF
Oswalt Oswalt Oswalt Oswalt Oswalt Oswalt Oswalt
6,640,000 6,630,000 6,620,000 6,610,000 6,610,000 6,610,000 6,610,000
Miller Miller Miller Miller Miller Miller Miller
5,330,000 5,330,000 5,320,000 5,320,000 5,310,000 5,300,000 5,300,000
Moehler Moehler Moehler Moehler Moehler Moehler Moehler
1,080,000 1,060,000 1,040,000 1,020,000 1,000,000 980,000 960,000
Redding Redding Redding Redding Redding Redding Redding
1,300,000 1,300,000 1,300,000 1,300,000 1,300,000 1,300,000 1,300,000
Robertson Robertson Robertson Robertson Robertson Robertson Robertson
500,000 500,000 500,000 500,000 500,000 500,000 500,000
          Milwaukee  
Pitt Ariz Ariz Ariz St L St L St L
Sheets Sheets Sheets Sheets Sheets Sheets Sheets
4,110,000 4,090,000 4,070,000 4,050,000 4,030,000 4,010,000 3,990,000
Rusch Rusch Rusch Rusch Rusch Rusch Rusch
3,090,000 3,070,000 3,050,000 3,030,000 3,010,000 2,990,000 2,970,000
Ritchie Ritchie Ritchie Ritchie Ritchie Ritchie Ritchie
650,000 650,000 650,000 650,000 660,000 670,000 670,000
Franklin Franklin Franklin Franklin Franklin Franklin Franklin
2,200,000 2,180,000 2,160,000 2,140,000 2,120,000 2,100,000 2,080,000
Kinney Kinney Kinney Kinney Kinney Kinney Kinney
810,000 790,000 770,000 750,000 730,000 710,000 690,000
             
Thu Fri Sat Sun Mon Tue Wen
4/10 4/11 4/12 4/13 4/14 4/15 4/16
          Chicago Cubs  
Mont Pitt Pitt Pitt Cinn Cinn Cinn
Wood Wood Wood Wood Wood Wood Wood
5,870,000 5,850,000 5,850,000 5,850,000 5,860,000 5,870,000 5,920,000
Clement Clement Clement Clement Clement Clement Clement
5,930,000 5,910,000 5,890,000 5,890,000 5,890,000 5,890,000 5,890,000
Prior Prior Prior Prior Prior Prior Prior
4,820,000 4,890,000 4,970,000 5,070,000 5,180,000 5,300,000 5,390,000
Estes Estes Estes Estes Estes Estes Estes
1,940,000 1,930,000 1,920,000 1,910,000 1,900,000 1,890,000 1,890,000
Zambrano Zambrano Zambrano Zambrano Zambrano Zambrano Zambrano
2,380,000 2,390,000 2,400,000 2,410,000 2,410,000 2,410,000 2,410,000
          Los Angeles  
SF SF SF SF   SD SD
Nomo Nomo Nomo Nomo Nomo Nomo Nomo
6,430,000 6,420,000 6,410,000 6,400,000 6,390,000 6,370,000 6,360,000
Perez Perez Perez Perez Perez Perez Perez
5,770,000 5,770,000 5,770,000 5,750,000 5,730,000 5,700,000 5,680,000
Brown Brown Brown Brown Brown Brown Brown
5,530,000 5,550,000 5,510,000 5,490,000 5,440,000 5,350,000 5,250,000
Ishii Ishii Ishii Ishii Ishii Ishii Ishii
3,830,000 3,820,000 3,810,000 3,800,000 3,800,000 3,800,000 3,800,000
Dreifort Dreifort Dreifort Dreifort Dreifort Dreifort Dreifort
900,000 900,000 880,000 850,000 790,000 730,000 670,000
             
Thu Fri Sat Sun Mon Tue Wen
4/10 4/11 4/12 4/13 4/14 4/15 4/16
          SanFrancisco  
LA LA LA LA Hou Hou Hou
Rueter Rueter Rueter Rueter Rueter Rueter Rueter
4,760,000 4,760,000 4,760,000 4,760,000 4,760,000 4,760,000 4,770,000
Schmidt Schmidt Schmidt Schmidt Schmidt Schmidt Schmidt
6,260,000 6,270,000 6,230,000 6,210,000 6,190,000 6,170,000 6,140,000
Moss Moss Moss Moss Moss Moss Moss
4,710,000 4,710,000 4,700,000 4,690,000 4,690,000 4,690,000 4,690,000
Jensen Jensen Jensen Jensen Jensen Jensen Jensen
3,420,000 3,400,000 3,380,000 3,360,000 3,330,000 3,310,000 3,290,000
Ainsworth Ainsworth Ainsworth Ainsworth Ainsworth Ainsworth Ainsworth
1,620,000 1,620,000 1,620,000 1,630,000 1,640,000 1,650,000 1,670,000
          San Diego  
  Col Col Col   LA LA
Lawrence Lawrence Lawrence Lawrence Lawrence Lawrence Lawrence
4,540,000 4,560,000 4,580,000 4,590,000 4,600,000 4,610,000 4,640,000
Eaton Eaton Eaton Eaton Eaton Eaton Eaton
1,250,000 1,240,000 1,240,000 1,240,000 1,240,000 1,240,000 1,240,000
Perez Perez Perez Perez Perez Perez Perez
3,090,000 3,060,000 3,030,000 3,010,000 2,990,000 2,970,000 2,950,000
Peavy Peavy Peavy Peavy Peavy Peavy Peavy
2,660,000 2,670,000 2,670,000 2,670,000 2,670,000 2,670,000 2,670,000
Condrey Condrey Condrey Condrey Condrey Condrey Condrey
500,000 500,000 500,000 500,000 500,000 500,000 500,000
             
Thu Fri Sat Sun Mon Tue Wen
4/10 4/11 4/12 4/13 4/14 4/15 4/16
          Colorado  
St L SD SD SD Ariz Ariz Ariz
Jennings Jennings Jennings Jennings Jennings Jennings Jennings
3,870,000 3,850,000 3,830,000 3,810,000 3,790,000 3,770,000 3,750,000
Cook Cook Cook Cook Cook Cook Cook
720,000 700,000 680,000 660,000 640,000 620,000 600,000
Cruz Cruz Cruz Cruz Cruz Cruz Cruz
810,000 790,000 770,000 750,000 760,000 770,000 780,000
Chacon Chacon Chacon Chacon Chacon Chacon Chacon
1,390,000 1,400,000 1,410,000 1,420,000 1,430,000 1,430,000 1,430,000
Oliver Oliver Oliver Oliver Oliver Oliver Oliver
870,000 850,000 830,000 810,000 790,000 770,000 750,000
          Arizona  
  Milw Milw Milw Col Col Col
Johnson Johnson Johnson Johnson Johnson Johnson Johnson
9,830,000 9,870,000 9,870,000 9,860,000 9,840,000 9,810,000 9,740,000
Schilling Schilling Schilling Schilling Schilling Schilling Schilling
9,180,000 9,140,000 9,150,000 9,160,000 9,170,000 9,180,000 9,190,000
Dessens Dessens Dessens Dessens Dessens Dessens Dessens
4,080,000 4,060,000 4,040,000 4,020,000 4,000,000 3,980,000 3,960,000
Patterson Patterson Patterson Patterson Patterson Patterson Patterson
1,990,000 1,970,000 1,950,000 1,930,000 1,910,000 1,890,000 1,870,000
Kim Kim Kim Kim Kim Kim Kim
5,310,000 5,290,000 5,270,000 5,250,000 5,230,000 5,210,000 5,190,000
             
Thu Fri Sat Sun Mon Tue Wen
4/10 4/11 4/12 4/13 4/14 4/15 4/16
          NY Yankees  
Minn TB TB TB Tor Tor Tor
Clemens Clemens Clemens Clemens Clemens Clemens Clemens
5,350,000 5,340,000 5,360,000 5,400,000 5,440,000 5,470,000 5,470,000
Pettite Pettite Pettite Pettite Pettite Pettite Pettite
4,660,000 4,680,000 4,680,000 4,680,000 4,710,000 4,740,000 4,720,000
Mussina Mussina Mussina Mussina Mussina Mussina Mussina
5,850,000 5,860,000 5,870,000 5,880,000 5,880,000 5,900,000 5,920,000
Wells Wells Wells Wells Wells Wells Wells
5,810,000 5,830,000 5,840,000 5,850,000 5,870,000 5,870,000 5,930,000
Weaver Weaver Weaver Weaver Weaver Weaver Weaver
5,010,000 5,010,000 5,010,000 5,010,000 5,010,000 5,000,000 4,980,000
          Baltimore  
TB Bos Bos Bos   Clev Clev
Lopez Lopez Lopez Lopez Lopez Lopez Lopez
5,220,000 5,190,000 5,170,000 5,150,000 5,130,000 5,110,000 5,090,000
Daal Daal Daal Daal Daal Daal Daal
3,730,000 3,710,000 3,690,000 3,660,000 3,640,000 3,620,000 3,600,000
Helling Helling Helling Helling Helling Helling Helling
3,270,000 3,250,000 3,230,000 3,210,000 3,190,000 3,170,000 3,150,000
Ponson Ponson Ponson Ponson Ponson Ponson Ponson
3,530,000 3,510,000 3,490,000 3,470,000 3,450,000 3,430,000 3,410,000
Johnson Johnson Johnson Johnson Johnson Johnson Johnson
2,080,000 2,060,000 2,040,000 2,020,000 2,000,000 1,980,000 1,960,000
             
Thu Fri Sat Sun Mon Tue Wen
4/10 4/11 4/12 4/13 4/14 4/15 4/16
          Toronto  
Bos Minn Minn Minn NY Y NY Y NY Y
Halladay Halladay Halladay Halladay Halladay Halladay Halladay
6,280,000 6,280,000 6,280,000 6,280,000 6,280,000 6,270,000 6,270,000
Lidle Lidle Lidle Lidle Lidle Lidle Lidle
4,010,000 4,010,000 4,010,000 3,990,000 3,970,000 3,950,000 3,930,000
Hendrickson Hendrickson Hendrickson Hendrickson Hendrickson Hendrickson Hendrickson
830,000 810,000 790,000 770,000 750,000 730,000 710,000
Sturtze Sturtze Sturtze Sturtze Sturtze Sturtze Sturtze
2,000,000 2,010,000 2,020,000 2,030,000 2,030,000 2,030,000 2,020,000
Miller Miller Miller Miller Miller Miller Miller
1,530,000 1,510,000 1,490,000 1,470,000 1,450,000 1,430,000 1,410,000
          Boston  
Tor Balt Balt Balt   TB TB
Martinez Martinez Martinez Martinez Martinez Martinez Martinez
8,540,000 8,610,000 8,710,000 8,710,000 8,620,000 8,510,000 8,380,000
Wakefield Wakefield Wakefield Wakefield Wakefield Wakefield Wakefield
5,020,000 5,000,000 5,000,000 4,980,000 4,960,000 4,940,000 4,920,000
Lowe Lowe Lowe Lowe Lowe Lowe Lowe
6,660,000 6,640,000 6,620,000 6,660,000 6,590,000 6,590,000 6,590,000
Fossum Fossum Fossum Fossum Fossum Fossum Fossum
2,560,000 2,540,000 2,520,000 2,500,000 2,470,000 2,460,000 2,460,000
Burkett Burkett Burkett Burkett Burkett Burkett Burkett
3,650,000 3,650,000 3,650,000 3,650,000 3,650,000 3,640,000 3,640,000
             
Thu Fri Sat Sun Mon Tue Wen
4/10 4/11 4/12 4/13 4/14 4/15 4/16
          Tampa Bay  
Balt NY Y NY Y NY Y   Bos Bos
Kennedy Kennedy Kennedy Kennedy Kennedy Kennedy Kennedy
3,170,000 3,150,000 3,130,000 3,110,000 3,090,000 3,070,000 3,050,000
Zambrano Zambrano Zambrano Zambrano Zambrano Zambrano Zambrano
1,400,000 1,380,000 1,360,000 1,340,000 1,320,000 1,300,000 1,280,000
Parque Parque Parque Parque Parque Parque Parque
500,000 500,000 500,000 500,000 500,000 500,000 500,000
Bierbrodt Bierbrodt Bierbrodt Bierbrodt Bierbrodt Bierbrodt Bierbrodt
500,000 500,000 500,000 500,000 500,000 500,000 500,000
Parris Parris Parris Parris Parris Parris Parris
840,000 820,000 800,000 780,000 760,000 740,000 720,000
          White Sox  
Clev Det Det Det   KC KC
Buehrle Buehrle Buehrle Buehrle Buehrle Buehrle Buehrle
5,950,000 5,980,000 6,000,000 6,020,000 6,040,000 6,030,000 6,030,000
Colon Colon Colon Colon Colon Colon Colon
6,790,000 6,780,000 6,760,000 6,760,000 6,780,000 6,800,000 6,820,000
Garland Garland Garland Garland Garland Garland Garland
3,490,000 3,470,000 3,450,000 3,430,000 3,410,000 3,390,000 3,370,000
Loaiza Loaiza Loaiza Loaiza Loaiza Loaiza Loaiza
1,990,000 2,010,000 2,030,000 2,050,000 2,070,000 2,090,000 2,110,000
Stewart Stewart Stewart Stewart Stewart Stewart Stewart
600,000 610,000 620,000 630,000 640,000 650,000
             
Thu Fri Sat Sun Mon Tue Wen
4/10 4/11 4/12 4/13 4/14 4/15 4/16
          Detriot  
KC Chi Sox Chi Sox Chi Sox   Minn Minn
Maroth Maroth Maroth Maroth Maroth Maroth Maroth
2,350,000 2,330,000 2,310,000 2,290,000 2,270,000 2,250,000 2,230,000
Bonderman Bonderman Bonderman Bonderman Bonderman Bonderman Bonderman
660,000 640,000 620,000 600,000 580,000 560,000 540,000
Bernero Bernero Bernero Bernero Bernero Bernero Bernero
730,000 710,000 690,000 670,000 650,000 630,000 610,000
Cornejo Cornejo Cornejo Cornejo Cornejo Cornejo Cornejo
740,000 720,000 700,000 680,000 660,000 640,000 620,000
Knotts Knotts Knotts Knotts Knotts Knotts Knotts
680,000 660,000 640,000 620,000 600,000 580,000 560,000
          Kansas City  
Det Clev Clev Clev Clev Chi Sox Chi Sox
Hernandez Hernandez Hernandez Hernandez Hernandez Hernandez Hernandez
1,940,000 2,080,000 2,210,000 2,340,000 2,460,000 2,580,000 2,690,000
Affeldt Affeldt Affeldt Affeldt Affeldt Affeldt Affeldt
1,380,000 1,390,000 1,400,000 1,400,000 1,380,000 1,380,000 1,380,000
Asencio Asencio Asencio Asencio Asencio Asencio Asencio
1,230,000 1,230,000 1,230,000 1,230,000 1,230,000 1,230,000 1,230,000
George George George George George George George
560,000 580,000 610,000 640,000 660,000 680,000 700,000
May May May May May May May
1,500,000 1,480,000 1,460,000 1,440,000 1,420,000 1,400,000 1,380,000
             
Thu Fri Sat Sun Mon Tue Wen
4/10 4/11 4/12 4/13 4/14 4/15 4/16
          Minnesota  
NY Y Tor Tor Tor   Det Det
Radke Radke Radke Radke Radke Radke Radke
2,850,000 2,720,000 2,620,000 2,530,000 2,480,000 2,430,000 2,380,000
Mays Mays Mays Mays Mays Mays Mays
3,140,000 3,130,000 3,120,000 3,110,000 3,100,000 3,100,000 3,100,000
Lohse Lohse Lohse Lohse Lohse Lohse Lohse
4,180,000 4,180,000 4,180,000 4,180,000 4,200,000 4,270,000 4,330,000
Reed Reed Reed Reed Reed Reed Reed
4,890,000 4,870,000 4,850,000 4,830,000 4,810,000 4,790,000 4,790,000
Rodgers Rodgers Rodgers Rodgers Rodgers Rodgers Rodgers
4,380,000 4,360,000 4,340,000 4,320,000 4,300,000 4,280,000 4,260,000
          Cleveland  
Chi Sox KC KC KC KC Balt Balt
Sabathia Sabathia Sabathia Sabathia Sabathia Sabathia Sabathia
4,400,000 4,400,000 4,400,000 4,400,000 4,400,000 4,400,000 4,400,000
Rodriguez Rodriguez Rodriguez Rodriguez Rodriguez Rodriguez Rodriguez
1,280,000 1,290,000 1,300,000 1,320,000 1,360,000 1,400,000 1,450,000
Davis Davis Davis Davis Davis Davis Davis
500,000 500,000 500,000 500,000 500,000 500,000 500,000
Anderson Anderson Anderson Anderson Anderson Anderson Anderson
2,730,000 2,750,000 2,760,000 2,770,000 2,780,000 2,790,000 2,790,000
Bere Westbook Westbrook Westbrook Westbrook Westbrook Westbrook
810,000 500,000 500,000 500,000 500,000 500,000 510,000
             
Thu Fri Sat Sun Mon Tue Wen
4/10 4/11 4/12 4/13 4/14 4/15 4/16
          Oakland  
Tex Ana Ana Ana Sea Sea Sea
Hudson Hudson Hudson Hudson Hudson Hudson Hudson
6,350,000 6,330,000 6,310,000 6,290,000 6,280,000 6,260,000 6,240,000
Zito Zito Zito Zito Zito Zito Zito
7,790,000 7,790,000 7,780,000 7,790,000 7,800,000 7,810,000 7,810,000
Mulder Mulder Mulder Mulder Mulder Mulder Mulder
6,780,000 6,770,000 6,760,000 6,750,000 6,730,000 6,730,000 6,730,000
Lilly Lilly Lilly Lilly Lilly Lilly Lilly
2,990,000 3,010,000 3,020,000 3,020,000 3,010,000 2,970,000 2,950,000
Halama Halama Halama Halama Halama Halama Halama
2,180,000 2,180,000 2,180,000 2,180,000 2,160,000 2,140,000 2,140,000
          Seattle  
Ana Tex Tex Tex Oak Oak Oak
Garcia Garcia Garcia Garcia Garcia Garcia Garcia
5,140,000 5,140,000 5,140,000 5,140,000 5,140,000 5,140,000 5,140,000
Moyer Moyer Moyer Moyer Moyer Moyer Moyer
6,070,000 6,050,000 6,030,000 6,010,000 5,990,000 5,970,000 5,950,000
Franklin Franklin Franklin Franklin Franklin Franklin Franklin
2,500,000 2,480,000 2,460,000 2,440,000 2,420,000 2,400,000 2,380,000
Meche Meche Meche Meche Meche Meche Meche
510,000 500,000 500,000 500,000 500,000 500,000 500,000
Pineiro Pineiro Pineiro Pineiro Pineiro Pineiro Pineiro
5,080,000 5,080,000 5,080,000 5,080,000 5,070,000 5,070,000 5,070,000
             
Thu Fri Sat Sun Mon Tue Wen
4/10 4/11 4/12 4/13 4/14 4/15 4/16
          Anahiem  
Sea Oak Oak Oak Tex Tex Tex
Lackey Lackey Lackey Lackey Lackey Lackey Lackey
2,830,000 2,810,000 2,800,000 2,790,000 2,790,000 2,790,000 2,790,000
Callaway Callaway Callaway Callaway Callaway Callaway Callaway
1,980,000 1,980,000 1,980,000 1,980,000 1,980,000 1,980,000 1,980,000
Ortiz Ortiz Ortiz Ortiz Ortiz Ortiz Ortiz
5,820,000 5,800,000 5,780,000 5,760,000 5,740,000 5,720,000 5,700,000
Washburn Washburn Washburn Washburn Washburn Washburn Washburn
6,190,000 6,170,000 6,150,000 6,130,000 6,110,000 6,110,000 6,110,000
Appier Appier Appier Appier Appier Appier Appier
4,240,000 4,220,000 4,200,000 4,180,000 4,160,000 4,140,000 4,120,000
          Texas  
Oak Sea Sea Sea Ana Ana Ana
Valdes Valdes Valdes Valdes Valdes Valdes Valdes
3,620,000 3,600,000 3,580,000 3,560,000 3,540,000 3,520,000 3,500,000
Ho Park Ho Park Ho Park Ho Park Ho Park Ho Park Ho Park
2,050,000 2,030,000 2,020,000 2,010,000 2,010,000 2,010,000 2,010,000
Thomson Thomson Thomson Thomson Thomson Thomson Thomson
2,850,000 2,830,000 2,810,000 2,790,000 2,770,000 2,750,000 2,730,000
Lewis Lewis Lewis Lewis Lewis Lewis Lewis
510,000 510,000 510,000 500,000 500,000 500,000 500,000
Drese Drese Drese Drese Drese Drese Drese
1,190,000 1,170,000 1,150,000 1,130,000 1,110,000 1,090,000 1,070,000
             
Thu Fri Sat Sun Mon Tue Wen
4/10 4/11 4/12 4/13 4/14 4/15 4/16
             
             
5Robber
      ID: 933287
      Fri, Apr 18, 2003, 13:23
Not bad Bandos...............very cool. Now....what do ya think? I have the whole season available and update everyday.
6Chuck
      Donor
      ID: 571132017
      Fri, Apr 18, 2003, 13:30
Robber-- it took me a bit to figure out just how to read it, but now that I know what's going on, it looks good.

I'm not sure how complicated it was to put together, but the more colors you add the more impressive it looks :-)

To help with the reading, it would help if the team labels (New York Mets, Philadelphia, etc.) were alligned left, or at least centered. I was trying to figure out the sort order and I missed that the first times through. For distinguishing, maybe if the team name were in a color other than black, too.

Overall, though, it looks good. The more charts and figures we have on here, the better :-)

7Bandos
      ID: 422571916
      Fri, Apr 18, 2003, 13:32
I think every few days would be great. The colors really help me do a mental sort of acceptable/unacceptable pitchers. Think I would have good Wood vs. Schmidt had I seen this :)
8Chuck
      Donor
      ID: 571132017
      Fri, Apr 18, 2003, 13:36
Think I would have good Wood


ummm... ? ;-)
9Bandos
      ID: 422571916
      Fri, Apr 18, 2003, 13:38
Oops - gone Wood. hehe
10Robber
      ID: 933287
      Fri, Apr 18, 2003, 13:41
I used stark colors to really make anomalies stick out. It's hand entered and takes about 35 min a day for the price updates and 30 - 45 once every 4 days for the projected pitchers.
11Robber
      ID: 933287
      Fri, Apr 18, 2003, 13:49
Sooooooooooooo what would be the best thread to send this in?
12APerfect10
      Leader
      ID: 70412023
      Fri, Apr 18, 2003, 13:56
This is like looking directy at a welding flame...
13Chuck
      Donor
      ID: 571132017
      Fri, Apr 18, 2003, 14:06
B/c of the length of it, I would say start a new one. It would really bog down other threads in terms of loading time. But come up with a good name for it, and I'm sure people will check it out.

Pitcher price history?
The Welding flame?
14Robber
      ID: 933287
      Fri, Apr 18, 2003, 14:13
Hey............... just a tool I use. Its long because it covers 150 players every day as well as prospective starts in near future. If pitchers performed better I guess it would be the Shamrock flame. I guess I'll enter under thread "welding flame". If its too hard on the eyes people won't look at it. I could shrink it a tad and go w/ current week and upcoming week for analysis. AP10, sorry you don't like it. My first attempt at a SS.
15ukula
      Donor
      ID: 18391812
      Fri, Apr 18, 2003, 14:16
MY EYES!! MY EYES!!!!
16Bandos
      ID: 422571916
      Fri, Apr 18, 2003, 14:36
Robber - I don't think AP was saying he doesn't like it - just a little joke, that's all. Please post as its own thread - it good for trends.
17The Left Wings
      ID: 6142019
      Fri, Apr 18, 2003, 15:20
By the way, the first name is "Chan Ho", and the last name is "Park".
18Chuck
      Donor
      ID: 571132017
      Fri, Apr 18, 2003, 15:52
Robber-- relax. If you're getting ribbed, it means you're getting noticed. If you think yours is not perfect-- go back and try to find some of my first spreadsheet posts from a long time ago... like Monday!

It's a great tool. Keep working with it, and it'll keep getting better, too.

That's an awesome job and a lot of work went into it. Thanks for sharing!
19Robber
      ID: 933287
      Fri, Apr 18, 2003, 17:22
Thanks guys................ maybe alittle too sensitive. Will post tommorow as thread "welding flame"
20Strike One
      ID: 356372421
      Fri, Apr 18, 2003, 18:00
Robber, awesome stuff, one sugestion though.

Create a new column on the right and left that lists the team and the pitchers, and then eliminate the the pitchers name in the box with the price. Have those two columns notbe color coded, while leaving the the middle columns with the respective colors. This would cut the height almost in half and might be a little easier to read and find a teams pitcher. Not sure if it'd be hard to do, but just a suggestion
21Robber
      ID: 933287
      Fri, Apr 18, 2003, 19:53
Strike............... the problem with that idea (I had it that way when I was working on it in March) is this is a snap-shot of the SS. ie....it covers the entire season. I switched to this format due to trades, injuries, etc that I thought would make the sheet more cumbersome that it already is. If you want to tinker with it send me an e-mail at rsgallagher@hotmail.com and I'll send it to you. I'll look at any revisions ANYONE has to streamline or improve the final product.
22Astade
      ID: 303521820
      Fri, May 02, 2003, 14:47
I figured with a question like this, I deserved this heading ;)

I created a very simple spreadsheet in excel and now I've graphed the results as a scatterplot.

The problem is: When i put my cursor on the data points or have the labels displayed on the graph, i get a display like

Series 1 " Point .45643 " (.45643,32)

This is of course useless to me if I haven't sorted the data in the worksheet, because I have to go searching for x=.45643

Each of my entries has a name...isn't there a way to import a column of data names into this d@mned chart?!

I've searched the 'Help' function for about an hour now...

Any help would be appreciated, thanks
Rate this thread:
5 (top notch)
4 (even better)
3 (good stuff)
2 (lightweight)
1 (no value)
If you wish, you may rate this thread on scale of 1-5. Ratings should indicate how valuable or interesting you believe this thread would be to other users of this forum. A '5' means that this thread is a 'must read'. A '1' means that this is a complete waste of time.

If you have previously rated this thread, rating it again will delete your previous rating.

If you do not want to rate this thread, but want to see how others have rated it, then click the button without entering a rating, or else click here.

RotoGuru Baseball Forum

View the Forum Registry


Self-edit this thread




Post a reply to this message: (But first, how about checking out this sponsor?)

Name:
Email:
Message:
Click here to create and insert a link
Click here to insert a random spelling of Mientkiewicz
Ignore line feeds? no (typical)   yes (for HTML table input)


Viewing statistics for this thread
Period# Views# Users
Last hour11
Last 24 hours11
Last 7 days44
Last 30 days98
Since Mar 1, 2007605061790