Tenis Spreadsheet Test

[hagis]

Tenis Spreadsheet Test
Juz od dawna chciałem sie za to zabrać
chodzi o odwrocenie stron i bycie bukmacherem
Generowanie excelem spreadsheeta z danymi
Spreadsheet
Zobaczymy czy jest to cos warte

1 Test

________________________________________________
29.06.12
12:30
Lu Yen-hsun (TAI)
Waske Alexander (DEU)
28.88 %

V

Malisse Xavier (BEL)
Norman Dick (BEL)
71.12 %
KURS:1.40
________________________________________________
29.06.12
12:30
Haase Robin (NLD) /
Nieminen Jarkko (FIN)
27.94 %
V
Bryan Bob (USA)
Bryan Mike (USA)
72.06 %
Kurs:1.12
________________________________________________​

 

[dalik]

Wszystko ładnie piękne ale teraz proszę wytłumacz jakie to może mieć zastosowanie w praktyce?

 

[hagis]

Start Testu 10 BANKÓW
Budżet na Test 10
Podzielony na 10 Banków po (1)
1 Etap uzykanie 20 Banków 10x(2.00)
2 Etap uzykanie 40 Banków 10x(4.00)
3 Etap uzykanie 80 Banków 10x(8.00)
4 Etap uzykanie 160 Banków 10x(16.00)
5 Etap uzykanie 320 Banków 10x(32.00)
6 Etap uzykanie 640 Banków 10x(64.00)
7 Etap uzykanie 1280 Banków 10x(128.00)
8 Etap uzykanie 2560 Banków 10x(256.00)​

Bank 1 (1.00)
Rufin Guillaume (FRA) (168) 74.36 % (1.40) ???? (1.00)=(1.40)
Pashanski Boris (SRB) (342) 25.64 % (2.60)
Bank 2 (1.00)
Serena Williams (1.20) ???? (1.00)=(1.20)
Victoria Azarenka

Bank 2 (1.20)
Jagodina DnB (1.22) (1.20)=(1.47) :;/:
FC Ordabasy
Bank 3 (1.00)
Peter Polansky (1.20) ???? (1.00)=(1.20)
Christopher Diaz-Figueroa
Bank 3 (1.20)
Gabriela Paz (1.16) ???? (1.20)=(1.40)
Vasilisa Bardina
Bank 3 (1.40)
Diego Sebastian Schwartzman (1.08) ???? (1.40)=(1.51)
Agustin Velotti
musze sie ratowac
Agustin Velotti (1.40) ???? (7.00)=(9.80)
Bank 1 (0.80)
SA Silver Stars
IND Fever Over 154 (1.90)???? (0.80)=(1.52)

ILOŚĆ BANKÓW 10
ZYSK/STRATA (+0.52)

 

[hagis]

Bank 1 (1.50)
Novak Djokovic (1.40)????( 1.25)=(1.75)
Roger Federer
Bank 2 (1.00)
Shelbourne REMIS (3.60)(1.00)=(3.60)
Dundalk
Bank 3 (1.00)
Cercle Brugge REMIS (3.75)(1.00)=(3.75)
Mons
ILOŚĆ BANKÓW 10
ZYSK/STRATA (+0.87)

 

[hagis]

Bank 1 (0.87)
FK Austria Vienna
West Ham (2.60)(0.87)=(2.26)

Bank 2 (1.00)
Vissel Kobe (3.25)(0.50)=(1.63)
Sendai

Bank 2 (0.50)
Sligo Rovers v Bray Wanderers - over 1.5 goals
Kashiwa Reysol v Nagoya Grampus - over 1.5 goals
New England v New York - over 1.5 goals
Chicago Fire v Los Angeles - over 1.5 goals
(2.22)(0.50)=(1.11)
Bank 3 (1.00)
Urawa Red Diamonds v Sagan Tosu (4:3)
Kashima Antlers v Omiya Ardija (Draw No Bet) (1:0)
(1.48)(1.00)=(1.48)
Bank 4 (1.00)
Sabah v Terengganu
REMIS (3.40)(0.50)=(1.70)
Bank 4 (0.50)
Nacional Asuncion v Sportivo Luqueno
REMIS (3.75)(0.50)=(1.88)

Bank 5 (1.00)
Federer R. (1.50) ???? (1.00)=(1.50)(3:1)
Murray A.
Bank 6 (1.00)
Okzhetpes Kokshetau v Tobol Kostanay (Draw No Bet) (1.16) (0:1)
AIK v BK Hacken AIK +0.5 (1.40) (3:1)
Elfsborg v Mjallby Elfsborg +0.5 (1.10)(0:0)

(1.80)(1.00)=(1.80)


ILOŚĆ BANKÓW 10
ZYSK/STRATA (+0.89)

 

[hagis]

Bank 1 (1.00)
Atletico Mineiro v Portuguesa
Atletico Mineiro +0.5
(1.11)
Orebro SK v Malmo FF
Malmo FF +0.5
(1.175)
(1.30)(1.00)=(1.30)

Bank 2 (0.87)
Changchun Yatai v Dalian Shide (Draw No Bet)
(1.33)(0.80)=(1.087)
Bank 3 (1.00)
Orebro SK v Malmo FF
Orebro SK 3.0 (1.12)
IFK Goteborg v Helsingborg
Helsingborg 3.0 (1.06)
(1.19)(1.00)=(1.19)
Bank 4 (1.00)
AGF Aarhus +2.0 @ 1.105
FC Honka +3.0 @ 1.05
TPV +3.0,+3.5 @ 1.16 (4:0) :/
Lillestrom +3.0 @ 1.083
Helsingborg +2.0,+2.5 @ 1.10
Portugal U17 +1.5,+2.0 @ 1.105
(1.77)(1.00)=(1.77)

ILOŚĆ BANKÓW 8
ZYSK/STRATA (-1.81)

 

[hagis]

Bank 1 (1.00)
???? Grace Min vs Chanelle Scheepers (1.50)

Shaun Murphy vs Marcus Campbell (1.44)
(2.13) I (1.00)=(2.17)

Bank 2 (1.00)

Shaun Murphy vs Marcus Campbell (1.44)
(1.44)

(1.00)=(1.44)

ILOŚĆ BANKÓW 10
ZYSK/STRATA (-0.20)

 

[hagis]

Bank 1 (1.00)

England vs Australia - 5th ODI (1.66)
(1.66)

(1.00)=(1.66)
0.66
Bank 2 (1.00)
????Horacio Zeballos vs Joao Souza (1.25)
????Frederico Gil vs Marsel Ilhan (1.40)
???? Filippo Volandri vs Michael Ryderstedt (1.36)

Stuart Bingham vs Matthew Selt (1.36)
(3.25) I (1.00)=(3.25)
-1.00

Bank 3 (1.00)
????Filippo Volandri vs Michael Ryderstedt (1.36)
(1.36) ???? (1.00)=(1.36)
0.36

Bank 4 (1.00)
????Tommy Haas vs Igor Andreev (1.36)

England vs Australia - 5th ODI (1.66)
(2.27) (1.00)=(2.27)
1.27
Bank 5 (1.00)
????Igor Sijsling vs Kei Nishikori (1.16)
????Karol Beck vs Fabio Fognini (1.11)

England vs Australia - 5th ODI (1.66)
(2.16) (1.00)=(2.16)
1.16
Bank 6 (1.00)

England vs Australia - 5th ODI (1.66)
(1.66)

(1.00)=(1.66)
0.66
Bank 7 (1.00)
???? MIN Lynx @ TUL Shock
Under 162.0 (1.90)
(1.90) (1.00)=(1.90)
-1.00
Bank 8 (1.00)
???? LA Sparks @ PHX Mercury
PHX Mercury +7.5 (1.90)
(1.90) (1.00)=(1.90)
-1.00

Bank 9 (1.00)
Portadown vs Škendija 79
Double Chance X2(1.50)
(1.50)(0.33)=(0.50)
Bank 9 (1.00)
Portadown vs Škendija 79
Škendija 79 -1 AH (4.40)
(4.40)(0.33)=(1.45)

Bank 9 (1.00)
Portadown vs Škendija 79
Škendija 79 0 AH (1.85)
(1.90)(0.33)=(0.61)
-1.00
ILOŚĆ BANKÓW 10
ZYSK/STRATA (-0.09)

 

[hagis]

Bank 1 (1.00)

West Indies vs New Zealand (1.25)
(1.25)

(1.00)=(1.25)

Bank 2 (1.00)

West Indies vs New Zealand (1.25)

Mark Selby vs Jamie Burnett (1.28)

Shaun Murphy vs Tom Ford (1.36)
(2.19) I (1.00)=(2.19)

Bank 3 (1.00)
????Sara Errani @ (1.083)
????Martin Klizan @ (1.36)
????Robert Lindstedt & Horia Tecau @ (1.33)
????David Ferrer @ (1.03)
(2.03) ???? (1.00)=(2.03)

Bank 4 (1.00)

Essex @ (1.80)
(1.80)

(1.00)=(1.80)

Bank 5 (1.00)
Corinthians @ (1.36) DnB

Shaun Murphy @ (1.36)
(1.86)I(1.00)=(1.86)

ILOŚĆ BANKÓW 6
ZYSK/STRATA (-4.09)

 

[hagis]

Bank 1 (1.00)
????Jerzy Janowicz vs Boy Westerhof
Jerzy Janowicz - 76.31 %
1.22
Bank 2 (1.00)
????Motti/ Paire vs Kohlmann/ Petzschner
Michael Kohlmann & Philipp Petzschner 74.12 %
1.36
Bank 3 (1.00)
????Milos Raonic vs Benjamin Becker
Milos Raonic - 70.33 %
1.18

Bank 4 (1.00)
????Daniel Gimeno-Traver vs Alessandro Giannessi
Alessandro Giannessi - 70.62 %
2.25
1 raz trafiłem mecz ktory nie zgadza sie z ocena buka
zobaczymy