Caracalla MLB season

[caracalla]

copy and paste Pivot : problems
Retry
Pick
L
W
Total
Angels

2

5

7

Astros

1

1

Athletics

2

3

5

BlueJays

3

3

Braves

1

3

4

Cardinals

4

2

6

Cubs

1

1

2

Dodgers

3

4

7

Giants

2

3

5

Mariners

1

1

Marlins

2

1

3

Mets

1

2

3

Nationals

1

1

2

Padres

2

3

5

Phillies

1

1

Pirates

1

1

Rangers

2

5

7

Rays

5

2

7

Reds

3

6

9

RedSox

6

6

12

Rockies

2

2

4

Royals

1

2

3

Tigers

1

3

4

Twins

3

5

8

WhiteSox

3

3

Yankees

4

16

20

Totale complessivo

52

81

133

[caracalla]

again, spreadsheey module code? from sbrforum? Where?

[caracalla]

sorry, i can't copy and paste spreadsheet

[Tommy_de1st]

What are you trying to do?>
copy from excel?

[Tommy_de1st]

try from excel to notepad (e.g. pitpad) and from that in here

[Tommy_de1st]

Date Pick H/A Opponents Line Odds PickScore OppScore Result
4/18/10 Athletics H Orioles -1,5 135 3 8 L
4/18/10 Twins H Royals -1,5 105 5 10 L
4/20/10 Pirates H Brewers 115 1 8 L
4/20/10 Twins H Indians -149 5 1 W
4/23/10 Athletics H Indians -1,5 145 10 0 W
4/23/10 Twins A Royals -130 8 3 W
4/24/10 Padres A Reds 114 5 0 W
4/24/10 Twins A Royals -119 9 7 W
4/25/10 Athletics H Indians -125 11 0 W
4/25/10 Mets H Braves 102 1 0 W
4/25/10 Padres A Reds -107 4 5 L
4/25/10 Twins A Royals -130 3 4 L
4/26/10 Angels H Indians -1,5 105 5 2 W
4/26/10 Rockies H Diamondbacks 100 3 5 L
4/28/10 Giants H Phillies -145 6 7 L
4/28/10 Rangers H WhiteSox -120 6 5 W
4/28/10 Reds A Astros 100 6 4 W
4/28/10 Yankees A Orioles -1,5 -135 8 3 W
4/29/10 Rangers H WhiteSox -121 5 7 L
4/29/10 Yankees A Orioles -1,5 100 4 0 W
4/30/10 Cardinals H Reds -1,5 105 2 3 L
4/30/10 Marlins H Nationals -1,5 100 1 7 L
4/30/10 Rays H Royals -1,5 -120 2 3 L
4/30/10 RedSox A Orioles -150 4 5 L
4/30/10 Yankees H WhiteSox -1,5 -130 6 4 W
5/1/10 Giants H Rockies -1,5 145 6 1 W
5/1/10 Rays H Royals -1,5 -130 2 4 L
5/1/10 RedSox A Orioles -159 9 12 L
5/2/10 Padres H Brewers -105 8 0 W
5/2/10 Yankees H WhiteSox -1,5 100 12 3 W
5/3/10 Yankees H Orioles -1,5 -145 4 1 W
5/4/10 BlueJays A Indians -123 5 4 W
5/4/10 Cubs A Pirates -149 2 3 L
5/4/10 Yankees H Orioles -115 4 1 W
5/5/10 Nationals H Braves 135 6 7 L
5/5/10 Twins H Tigers -1,5 130 5 4 L
5/5/10 Yankees H Orioles -1,5 -140 7 5 W
5/6/10 Rays A Mariners -147 8 0 W
5/7/10 Rays A Athletics -124 4 1 W
5/8/10 Dodgers H Rockies 105 0 8 L
5/8/10 Tigers A Indians -147 6 4 W
5/9/10 Mets H Giants 175 5 6 L
5/9/10 Rangers H Royals -1,5 125 6 4 W
5/9/10 Yankees A RedSox 107 3 9 L
5/12/10 Cardinals H Astros -1,5 130 6 9 L
5/12/10 Dodgers A Diamondbacks -115 6 3 W
5/16/10 Marlins H Mets -1,5 125 10 8 W
5/16/10 Yankees H Twins -1,5 135 3 6 L
5/17/10 Cardinals H Nationals -1,5 135 6 2 W
5/17/10 Yankees H RedSox -1,5 110 11 9 W
5/18/10 Athletics H Mariners 117 6 5 W
5/18/10 Cardinals H Nationals -1,5 -115 3 2 L
5/18/10 Phillies H Pirates -1,5 -145 1 2 L
5/18/10 Yankees H Redsox -1,5 110 6 7 L
5/19/10 Nationals H Mets -141 5 3 W
5/21/10 Braves A Pirates -145 7 0 W
5/21/10 Dodgers H Tigers -1,5 123 4 1 W
5/21/10 Reds A Indians -109 7 4 W
5/21/10 Royals H Rockies 109 9 2 W
5/21/10 Yankees A Mets -155 2 1 W
5/22/10 Reds A Indians 101 6 4 W
5/22/10 Rockies A Royals -110 3 0 W
5/23/10 Reds A Indians -119 3 4 L
5/23/10 Royals H Rockies -144 7 11 L
5/24/10 Angels H BlueJays -120 0 6 L
5/24/10 Reds H Pirates -1,5 115 7 5 W
5/25/10 Mets H Phillies 124 8 0 W
5/25/10 Rays H RedSox -110 0 2 L
5/25/10 Reds H Pirates -1,5 120 1 2 L
5/25/10 Rockies H Diamondbacks -1,5 150 3 2 L
5/26/10 Royals H Rangers 106 5 2 W
5/27/10 Reds H Pirates -1,5 120 4 0 W
5/27/10 Rockies H Diamondbacks 104 8 2 W
5/28/10 Angels H Mariners -103 3 8 L
5/28/10 Giants H Diamondbacks -128 5 0 W
5/28/10 Padres H Nationals -140 3 5 L
5/29/10 BlueJays H Orioles -1,5 110 5 2 W
5/29/10 Cubs H Cardinals -130 5 0 W
5/29/10 Padres H Nationals -1,5 130 4 2 W
5/29/10 Reds H Astros -1,5 115 12 2 W
5/30/10 Angels H Mariners -1,5 135 9 7 W
5/30/10 BlueJays H Orioles -1,5 110 6 1 W
5/30/10 Reds H Astros -1,5 -105 0 2 L
5/30/10 Yankees H Indians -1,5 -150 7 3 W
5/31/10 Angels A Royals -105 7 1 W
5/31/10 Dodgers H Diamondbacks -1,5 110 5 4 L
6/1/10 Dodgers H Diamondbacks -122 1 0 W
6/1/10 Tigers H Indians -1,5 120 2 3 L
6/1/10 Yankees H Orioles -1,5 -120 3 1 W
6/2/10 Dodgers H Diamondbacks -1,5 145 1 0 L
6/2/10 Mariners H Twins -1,5 150 2 1 L
6/2/10 Yankees H Orioles -1,5 -160 9 1 W
6/3/10 Angels A Royals 112 5 4 W
6/3/10 Braves A Dodgers 125 4 3 W
6/3/10 Yankees H Orioles -1,5 -144 6 3 W
6/4/10 Athletics H Twins -101 4 5 L
6/4/10 RedSox A Orioles -1,5 -104 11 0 W
6/5/10 Astros H Cubs -107 5 8 L
6/5/10 RedSox A Orioles -1,5 -120 8 2 W
6/6/10 Angels A Mariners 106 9 4 W
6/6/10 RedSox A Orioles -1,5 -110 3 4 L
6/7/10 Braves A Cardinals 118 4 7 L
6/7/10 RedSox A Indians -145 4 1 W
6/8/10 RedSox A Indians -153 3 2 W
6/8/10 Yankees A Orioles -1,5 -133 12 7 W
6/9/10 Dodgers H Cardinals -110 4 3 W
6/9/10 Rangers H Mariners -1,5 105 12 2 W
6/9/10 RedSox A Indians -164 0 11 L
6/9/10 Twins H Royals -1,5 110 6 2 W
6/9/10 Yankees A Orioles -1,5 -151 4 2 W
6/10/10 RedSox A Indians -1,5 -130 7 8 L
6/10/10 Yankees A Orioles -1,5 -145 3 4 L
6/11/10 Rays H Marlins -1,5 115 9 14 L
6/11/10 Rockies H BlueJays -1,5 129 5 3 cancelled
6/12/10 RedSox H Phillies -1,5 130 10 2 W
6/13/10 RedSox H Phillies 102 3 5 L
6/15/10 Cardinals H Mariners -1,5 124 4 2 W
6/15/10 Giants H Orioles -147 1 4 L
6/15/10 Marlins H Rangers -1,5 145 2 3 L
6/15/10 Twins H Rockies -149 9 3 W
6/15/10 Yankees H Phillies -120 8 3 W
6/16/10 Giants H Orioles -1,5 -114 6 3 W
6/16/10 Tigers H Nationals -1,5 110 8 3 W
6/16/10 WhiteSox A Pirates -133 7 2 W
6/17/10 Tigers H Nationals -1,5 116 8 3 W
6/17/10 WhiteSox A Pirates -124 5 4 W
6/18/10 Rangers A Astros -128 9 3 W
6/18/10 Rays A Marlins -1,5 105 4 7 L
6/19/10 Cardinals H Athletics -1,5 104 4 3 L
6/19/10 Rangers A Astros -1,5 -105 5 1 W
6/20/10 Braves H Royals -1,5 118 8 5 W
6/20/10 Rangers A Astros 1,5 -105 5 4 L
6/20/10 RedSox H Dodgers -1,5 130 2 0 W
6/20/10 WhiteSox A Nationals -110 6 3 W
6/21/10 Athletics H Reds -122 4 6 L

[Tommy_de1st]

I did for ya
hope it is you wanted

[caracalla]

away 45: 31-14 69%
home 88: 50-38 57%

ML 67: 42-25 63%
RL 66: 39-27 59%

ML Away 24-9 74% (BEST)
ML home 18-16 53% (WORST)

RL Away 7-5 58%
RL home 32-22 59%

[caracalla]

tx Tommy, I retry following your advice
Pick
L
W
Totale complessivo
Angels

2

5

7

Astros

1

1

Athletics

2

3

5

BlueJays

3

3

Braves

1

3

4

Cardinals

4

2

6

Cubs

1

1

2

Dodgers

3

4

7

Giants

2

3

5

Mariners

1

1

Marlins

2

1

3

Mets

1

2

3

Nationals

1

1

2

Padres

2

3

5

Phillies

1

1

Pirates

1

1

Rangers

2

5

7

Rays

5

2

7

Reds

3

6

9

RedSox

6

6

12

Rockies

2

2

4

Royals

1

2

3

Tigers

1

3

4

Twins

3

5

8

WhiteSox

3

3

Yankees

4

16

20

Totale complessivo

52

81

133

[caracalla]

nothing... I'm copying from Excel Pivot

[caracalla]

from word...
Pick L W Totale complessivo
Angels 2 5 7
Astros 1 1
Athletics 2 3 5
BlueJays 3 3
Braves 1 3 4
Cardinals 4 2 6
Cubs 1 1 2
Dodgers 3 4 7
Giants 2 3 5
Mariners 1 1
Marlins 2 1 3
Mets 1 2 3
Nationals 1 1 2
Padres 2 3 5
Phillies 1 1
Pirates 1 1
Rangers 2 5 7
Rays 5 2 7
Reds 3 6 9
RedSox 6 6 12
Rockies 2 2 4
Royals 1 2 3
Tigers 1 3 4
Twins 3 5 8
WhiteSox 3 3
Yankees 4 16 20
Totale complessivo 52 81 133

[Tommy_de1st]

Somethig is still wrong but dont know what it is

[Tommy_de1st]

Ok from word is better now

[caracalla]

finally.... correct
Pick L W Totale complessivo
Angels 2 5 7
Astros 1 0 1
Athletics 2 3 5
BlueJays 0 3 3
Braves 1 3 4
Cardinals 4 2 6
Cubs 1 1 2
Dodgers 3 4 7
Giants 2 3 5
Mariners 1 0 1
Marlins 2 1 3
Mets 1 2 3
Nationals 1 1 2
Padres 2 3 5
Phillies 1 0 1
Pirates 1 0 1
Rangers 2 5 7
Rays 5 2 7
Reds 3 6 9
RedSox 6 6 12
Rockies 2 2 4
Royals 1 2 3
Tigers 1 3 4
Twins 3 5 8
WhiteSox 0 3 3
Yankees 4 16 20
Totale complessivo 52 81 133

[Tommy_de1st]

What is that mean?
Angels 2 5 7 ?
Means you played Angels 7 times and they lost 2 and won 5? am i correct?

[caracalla]

I start noticing interesting things....
TYVM Elgreco (and Tommy)

Now I have to study odds; I have to convert European odds to semplify

[caracalla]

What is that mean?
Angels 2 5 7 ?
Means you played Angels 7 times and they lost 2 and won 5? am i correct?

correct
L W total

[Tommy_de1st]

Ok thanks

[caracalla]

Average odd -106,21053
ML Av odd -116,0448
RL Av odd +103,7727

[caracalla]

Can anyone (Elgreco?) add a new column in spreadsheet with European odds?
TY

I have to stop now.... working
bye

[elgreco]

I appreciated file name (caracalla) and I noticed Excel is not your best weapon

You are my weapon...

I will add the European column within a few hours. My address is in column T, write me and I'll email you the xls or xlsx, whatever you prefer.

[caracalla]

You are my weapon...

I will add the European column within a few hours. My address is in column T, write me and I'll email you the xls or xlsx, whatever you prefer.

emailed you
ty

[caracalla]

SF -140
Tex -1.5 -125

[elgreco]

I did it!! And as Caracalla so kindly pointed out, I am horrible at excel

If anyone wants a copy in excel, click "File" then "Download as"... should work perfectly.

[caracalla]

downloaded
perfect
are you going to update it ?
I'll need it at the end of the season to prepare next season
Very appreciated work and, again, tyvm

[elgreco]

I come here everyday for picks, the least I can do is update it a few times a week. If anyone else wants to add formulas or anything, feel free. I just hope I won't have to lock it down due to vandalism.

[Tommy_de1st]

I come here everyday for picks, the least I can do is update it a few times a week. If anyone else wants to add formulas or anything, feel free. I just hope I won't have to lock it down due to vandalism.

definitely not, we'll take them down

[caracalla]

I'm studyng second system (average odd -115)
last year 183/133 58%
this year 112/68 (so far) 0,62%

according this method today
Oak -130

if you want....

not for my stats (unofficial)

[facasto]

I trust you so...
... I'll follow you on Oakland
ty

[elgreco]

The weapon strikes again

[elgreco]

Wow... If my numbers are right, your away record is 71%. Nice job.

Since the forum made it difficult for you to paste your pivot table results, I think the best option is to paste them directly into a new sheet in the google workbook

[pico]

good luck

[pico]

mlb

[pico]

71% is pretty high

[caracalla]

2-0
ytd 83-53 +2792