.png)
Пока попробуем поэкспериментировать с пересчётом....
Новая формула пересчёта
FTDI_2 = (A11 - A21) * d1.Value + d1.Value * (time2 - A20) / d2.Value + A10
1—дист и трек куда переводим
2—дист., время, трек с которого переводим на трек_1
26
288 ответов в эту тему
#262 OFFLINE
-
- mp
-
- 6322 сообщения
Специалист
602
Добавлено 19 July 2015 - 06:38
Посмотрел выборочно забеги, которые выше тут по новой формуле--часть точек почему-то получаются такими же, а часть другими....решения частично другие-- часть ставок, которые лузы, по новой формуле не выбираются (но ХЗ чё выбирается и как оно зайдёт????....пока не смотрел...думаю лучше на свежих данных посмотреть...факт что вроде шо-то другое и вроде как получше на первый взгляд.). Модель почему-то очень чувствительна к эти значениям, небольшое изменение в двух даже лошадях из 10 приводит к совершенно другим характеристикам всего забега на предмет приоритетов выбора.....
#263 OFFLINE
-
- mp
-
- 6322 сообщения
Специалист
602
Добавлено 19 July 2015 - 06:58
Будем попутно делать несколько дел--будем продолжать небольшие эксперименты по новой формуле, искать--где надыбать средние по трекам, продолжать мыслить в направлении пересчёта--есть идея подключить потерю мощности лошади(общая концепция есть такого дела)...ну а пока--- пойду делать домик для уток.....всем привет...кого не видел...
Вот сама функция эта долбаная (названия треков под сервис Снежка)....
Function FTDI_2(ByRef dist1 As Range, ByRef dist2 As Range, ByRef T2 As Range, ByRef Trek1 As Range, ByRef Trek2 As Range _
, Optional VolatileOn As Boolean = True) As Variant
Application.Volatile VolatileOn
Dim Namtrbaz(63) As String
Dim Kfbaz(63, 1) As Double
Dim d1, d2, time2, cla, TR1, TR2 As Range
Dim A10, A11, A20, A21 As Double
Dim i, k, m As Integer
Set d1 = dist1
Set d2 = dist2
Set time2 = T2
Set TR1 = Trek1
Set TR2 = Trek2
Namtrbaz(0) = "Aintree"
Namtrbaz(1) = "Ascot"
Namtrbaz(2) = "Ayr"
Namtrbaz(3) = "Bath"
Namtrbaz(4) = "Beverley"
Namtrbaz(5) = "Brighton"
Namtrbaz(6) = "Carlisle"
Namtrbaz(7) = "Catterick"
Namtrbaz(8) = "Chelmsford AW"
Namtrbaz(9) = "Chepstow"
Namtrbaz(10) = "Chester"
Namtrbaz(11) = "Doncaster"
Namtrbaz(12) = "Epsom"
Namtrbaz(13) = "Ffos Las"
Namtrbaz(14) = "Folkestone"
Namtrbaz(15) = "Goodwood"
Namtrbaz(16) = "Hamilton"
Namtrbaz(17) = "Haydock"
Namtrbaz(18) = "Kempton AW"
Namtrbaz(19) = "Leicester"
Namtrbaz(20) = "Lingfield"
Namtrbaz(21) = "Lingfield AW"
Namtrbaz(22) = "Musselburgh"
Namtrbaz(23) = "Newbury"
Namtrbaz(24) = "Newcastle"
Namtrbaz(25) = "Newmarket"
Namtrbaz(26) = "Newmarket (July)"
Namtrbaz(27) = "Nottingham"
Namtrbaz(28) = "Pontefract"
Namtrbaz(29) = "Redcar"
Namtrbaz(30) = "Ripon"
Namtrbaz(31) = "Salisbury"
Namtrbaz(32) = "Sandown"
Namtrbaz(33) = "Southwell AW"
Namtrbaz(34) = "Thirsk"
Namtrbaz(35) = "Warwick"
Namtrbaz(36) = "Windsor"
Namtrbaz(37) = "Wolverhampton AW"
Namtrbaz(38) = "Yarmouth"
Namtrbaz(39) = "York"
Namtrbaz(40) = "Ballinrobe"
Namtrbaz(41) = "Bellewstown"
Namtrbaz(42) = "Clonmel"
Namtrbaz(43) = "Cork "
Namtrbaz(44) = "Curragh"
Namtrbaz(45) = "Down Royal"
Namtrbaz(46) = "Dundalk AW"
Namtrbaz(47) = "Fairyhouse"
Namtrbaz(48) = "Galway"
Namtrbaz(49) = "Gowran Park"
Namtrbaz(50) = "Killarney"
Namtrbaz(51) = "Leopardstown"
Namtrbaz(52) = "Limerick"
Namtrbaz(53) = "Listowel"
Namtrbaz(54) = "Naas"
Namtrbaz(55) = "Navan"
Namtrbaz(56) = "Roscommon"
Namtrbaz(57) = "Sligo"
Namtrbaz(58) = "Tipperary"
Namtrbaz(59) = "Tramore"
Namtrbaz(60) = "Wexford"
Namtrbaz(61) = "Meydan"
Namtrbaz(62) = "JEBEL ALI (UAE) Dirt"
Namtrbaz(63) = "NAD-AL-SHEBA (UAE) Dirt"
Kfbaz(0, 0) = 6.76215434664739E-02
Kfbaz(1, 0) = 5.98760330578513E-02
Kfbaz(2, 0) = 6.22313420206465E-02
Kfbaz(3, 0) = 0.060936565961871
Kfbaz(4, 0) = 6.31516405446734E-02
Kfbaz(5, 0) = 6.15381672282432E-02
Kfbaz(6, 0) = 0.057669688067429
Kfbaz(7, 0) = 0.061529246200187
Kfbaz(8, 0) = 6.15788404755581E-02
Kfbaz(9, 0) = 0.064536496273968
Kfbaz(10, 0) = 0.058506664606474
Kfbaz(11, 0) = 5.75145208131655E-02
Kfbaz(12, 0) = 6.62779715147553E-02
Kfbaz(13, 0) = 6.34090909090909E-02
Kfbaz(14, 0) = 6.32982740471464E-02
Kfbaz(15, 0) = 0.063411503624449
Kfbaz(16, 0) = 6.23592344708078E-02
Kfbaz(17, 0) = 6.32692307692307E-02
Kfbaz(18, 0) = 0.060607822410148
Kfbaz(19, 0) = 6.17957305044035E-02
Kfbaz(20, 0) = 0.067185148838731
Kfbaz(21, 0) = 0.059572884012539
Kfbaz(22, 0) = 6.25763660881801E-02
Kfbaz(23, 0) = 5.85025479694244E-02
Kfbaz(24, 0) = 6.04697476569392E-02
Kfbaz(25, 0) = 5.73181818181818E-02
Kfbaz(26, 0) = 0.057903605015674
Kfbaz(27, 0) = 6.02779610053625E-02
Kfbaz(28, 0) = 5.97724602803472E-02
Kfbaz(29, 0) = 6.04545454545455E-02
Kfbaz(30, 0) = 0.062257977285019
Kfbaz(31, 0) = 6.09827781603259E-02
Kfbaz(32, 0) = 5.98851764111274E-02
Kfbaz(33, 0) = 6.19776119402984E-02
Kfbaz(34, 0) = 6.05060782241015E-02
Kfbaz(35, 0) = 0.056784393134522
Kfbaz(36, 0) = 5.99437300617648E-02
Kfbaz(37, 0) = 5.99613989165789E-02
Kfbaz(38, 0) = 6.02029237702685E-02
Kfbaz(39, 0) = 5.99526068708596E-02
Kfbaz(40, 0) = 6.54176904176904E-02
Kfbaz(41, 0) = 5.97306412313544E-02
Kfbaz(42, 0) = 6.64335664335664E-02
Kfbaz(43, 0) = 6.17263843648208E-02
Kfbaz(44, 0) = 5.65081701124842E-02
Kfbaz(45, 0) = 0.062620213713268
Kfbaz(46, 0) = 5.79271536066425E-02
Kfbaz(47, 0) = 5.86413586413586E-02
Kfbaz(48, 0) = 6.32805615931387E-02
Kfbaz(49, 0) = 6.15802827111272E-02
Kfbaz(50, 0) = 0.063791562388273
Kfbaz(51, 0) = 5.86302211302211E-02
Kfbaz(52, 0) = 6.14199922510655E-02
Kfbaz(53, 0) = 6.74465240641711E-02
Kfbaz(54, 0) = 6.30329153605016E-02
Kfbaz(55, 0) = 5.98961681997297E-02
Kfbaz(56, 0) = 5.87918660287083E-02
Kfbaz(57, 0) = 6.68621700879765E-02
Kfbaz(58, 0) = 0.057851694212592
Kfbaz(59, 0) = 5.90909090909091E-02
Kfbaz(60, 0) = 5.68682189442887E-02
Kfbaz(61, 0) = 6.29278074866309E-02
Kfbaz(62, 0) = 5.40454545454545E-02
Kfbaz(63, 0) = 5.94545454545455E-02
Kfbaz(0, 1) = -11.882703777336
Kfbaz(1, 1) = -6.42727272727282
Kfbaz(2, 1) = -11.7984007446268
Kfbaz(3, 1) = -8.0036227958667
Kfbaz(4, 1) = -14.5756438401049
Kfbaz(5, 1) = -13.6840620225428
Kfbaz(6, 1) = -2.68877347169605
Kfbaz(7, 1) = -10.1255791819688
Kfbaz(8, 1) = -9.11575872142982
Kfbaz(9, 1) = -18.3983173721009
Kfbaz(10, 1) = -5.46659935923341
Kfbaz(11, 1) = -5.25617134559535
Kfbaz(12, 1) = -21.5202164969361
Kfbaz(13, 1) = -14.2
Kfbaz(14, 1) = -11.72205565472
Kfbaz(15, 1) = -14.0891419587333
Kfbaz(16, 1) = -11.1886772872035
Kfbaz(17, 1) = -12.0230769230768
Kfbaz(18, 1) = -9.6232558139536
Kfbaz(19, 1) = -11.3035782051562
Kfbaz(20, 1) = -21.5508995747468
Kfbaz(21, 1) = -9.33189655172384
Kfbaz(22, 1) = -11.7616308044089
Kfbaz(23, 1) = -7.03648757214913
Kfbaz(24, 1) = -7.78937521290627
Kfbaz(25, 1) = -5.68
Kfbaz(26, 1) = -6.13362068965525
Kfbaz(27, 1) = -8.40618564428512
Kfbaz(28, 1) = -3.24755705601244
Kfbaz(29, 1) = -10.9
Kfbaz(30, 1) = -11.7527312060574
Kfbaz(31, 1) = -7.59351961037457
Kfbaz(32, 1) = -6.14064288574332
Kfbaz(33, 1) = -8.36865671641776
Kfbaz(34, 1) = -9.23110465116272
Kfbaz(35, 1) = -5.25097652483394
Kfbaz(36, 1) = -7.9665002854113
Kfbaz(37, 1) = -6.77017928806554
Kfbaz(38, 1) = -9.09836337829408
Kfbaz(39, 1) = -9.05028472693504
Kfbaz(40, 1) = -14.3851351351351
Kfbaz(41, 1) = -8.52747816009985
Kfbaz(42, 1) = -24.1538461538462
Kfbaz(43, 1) = -11.7931596091205
Kfbaz(44, 1) = -3.234584916643
Kfbaz(45, 1) = -12.4492097061443
Kfbaz(46, 1) = -6.27598923196683
Kfbaz(47, 1) = -5.38461538461539
Kfbaz(48, 1) = -11.3732597074546
Kfbaz(49, 1) = -8.98205871692642
Kfbaz(50, 1) = -16.5019663925632
Kfbaz(51, 1) = -5.56756756756756
Kfbaz(52, 1) = -6.95358388221621
Kfbaz(53, 1) = -17.4823529411765
Kfbaz(54, 1) = -13.398275862069
Kfbaz(55, 1) = -6.6517905618754
Kfbaz(56, 1) = -2.19736842105289
Kfbaz(57, 1) = -6.74193548387098
Kfbaz(58, 1) = -5.5824304902992
Kfbaz(59, 1) = 4.66666666666667
Kfbaz(60, 1) = -0.566826770693638
Kfbaz(61, 1) = -12.8014705882351
Kfbaz(62, 1) = 1.34000000000001
Kfbaz(63, 1) = -8.34000000000001
i = 0
m = 0
For i = 0 To 63
m = m + 1
If Namtrbaz(i) = TR1.Value Then
A11 = Kfbaz(i, 0)
A10 = Kfbaz(i, 1)
Exit For
End If
Next i
i = 0
k = 0
For i = 0 To 63
If Namtrbaz(i) = TR2.Value Then
A21 = Kfbaz(i, 0)
A20 = Kfbaz(i, 1)
k = k + 1
Exit For
End If
Next i
If k < 1 Then ' если в базе нет трека с которого переводим считаем по №18(или 17 или другому на выбор)
A21 = Kfbaz(18, 0)
A20 = Kfbaz(18, 1)
End If
FTDI_2 = A21 * d1.Value + d1.Value * ((A11 - A21) * d2.Value + (A10 - A20) + time2 - (A21 * d2.Value + A20)) / d2.Value + A10
End Function
Вводится в яч как
FTDI_2(dist1;dist2;T2;Trek1; Trek2) данные берутся из ячеек листа Excel
1—дист и трек куда переводим
2—дист., время, трек с которого переводим на трек_1
Новая формула пересчёта
FTDI_2 = (A11 - A21) * d1.Value + d1.Value * (time2 - A20) / d2.Value + A10
1—дист и трек куда переводим
2—дист., время, трек с которого переводим на трек_1
вот этот трек не уверен что такое же назван. на сервисе Newmarket (July) и два последних ХЗ чёто не видел назв. можно потом подправить ну и добить там чё нет...
Вот сама функция эта долбаная (названия треков под сервис Снежка)....
Function FTDI_2(ByRef dist1 As Range, ByRef dist2 As Range, ByRef T2 As Range, ByRef Trek1 As Range, ByRef Trek2 As Range _
, Optional VolatileOn As Boolean = True) As Variant
Application.Volatile VolatileOn
Dim Namtrbaz(63) As String
Dim Kfbaz(63, 1) As Double
Dim d1, d2, time2, cla, TR1, TR2 As Range
Dim A10, A11, A20, A21 As Double
Dim i, k, m As Integer
Set d1 = dist1
Set d2 = dist2
Set time2 = T2
Set TR1 = Trek1
Set TR2 = Trek2
Namtrbaz(0) = "Aintree"
Namtrbaz(1) = "Ascot"
Namtrbaz(2) = "Ayr"
Namtrbaz(3) = "Bath"
Namtrbaz(4) = "Beverley"
Namtrbaz(5) = "Brighton"
Namtrbaz(6) = "Carlisle"
Namtrbaz(7) = "Catterick"
Namtrbaz(8) = "Chelmsford AW"
Namtrbaz(9) = "Chepstow"
Namtrbaz(10) = "Chester"
Namtrbaz(11) = "Doncaster"
Namtrbaz(12) = "Epsom"
Namtrbaz(13) = "Ffos Las"
Namtrbaz(14) = "Folkestone"
Namtrbaz(15) = "Goodwood"
Namtrbaz(16) = "Hamilton"
Namtrbaz(17) = "Haydock"
Namtrbaz(18) = "Kempton AW"
Namtrbaz(19) = "Leicester"
Namtrbaz(20) = "Lingfield"
Namtrbaz(21) = "Lingfield AW"
Namtrbaz(22) = "Musselburgh"
Namtrbaz(23) = "Newbury"
Namtrbaz(24) = "Newcastle"
Namtrbaz(25) = "Newmarket"
Namtrbaz(26) = "Newmarket (July)"
Namtrbaz(27) = "Nottingham"
Namtrbaz(28) = "Pontefract"
Namtrbaz(29) = "Redcar"
Namtrbaz(30) = "Ripon"
Namtrbaz(31) = "Salisbury"
Namtrbaz(32) = "Sandown"
Namtrbaz(33) = "Southwell AW"
Namtrbaz(34) = "Thirsk"
Namtrbaz(35) = "Warwick"
Namtrbaz(36) = "Windsor"
Namtrbaz(37) = "Wolverhampton AW"
Namtrbaz(38) = "Yarmouth"
Namtrbaz(39) = "York"
Namtrbaz(40) = "Ballinrobe"
Namtrbaz(41) = "Bellewstown"
Namtrbaz(42) = "Clonmel"
Namtrbaz(43) = "Cork "
Namtrbaz(44) = "Curragh"
Namtrbaz(45) = "Down Royal"
Namtrbaz(46) = "Dundalk AW"
Namtrbaz(47) = "Fairyhouse"
Namtrbaz(48) = "Galway"
Namtrbaz(49) = "Gowran Park"
Namtrbaz(50) = "Killarney"
Namtrbaz(51) = "Leopardstown"
Namtrbaz(52) = "Limerick"
Namtrbaz(53) = "Listowel"
Namtrbaz(54) = "Naas"
Namtrbaz(55) = "Navan"
Namtrbaz(56) = "Roscommon"
Namtrbaz(57) = "Sligo"
Namtrbaz(58) = "Tipperary"
Namtrbaz(59) = "Tramore"
Namtrbaz(60) = "Wexford"
Namtrbaz(61) = "Meydan"
Namtrbaz(62) = "JEBEL ALI (UAE) Dirt"
Namtrbaz(63) = "NAD-AL-SHEBA (UAE) Dirt"
Kfbaz(0, 0) = 6.76215434664739E-02
Kfbaz(1, 0) = 5.98760330578513E-02
Kfbaz(2, 0) = 6.22313420206465E-02
Kfbaz(3, 0) = 0.060936565961871
Kfbaz(4, 0) = 6.31516405446734E-02
Kfbaz(5, 0) = 6.15381672282432E-02
Kfbaz(6, 0) = 0.057669688067429
Kfbaz(7, 0) = 0.061529246200187
Kfbaz(8, 0) = 6.15788404755581E-02
Kfbaz(9, 0) = 0.064536496273968
Kfbaz(10, 0) = 0.058506664606474
Kfbaz(11, 0) = 5.75145208131655E-02
Kfbaz(12, 0) = 6.62779715147553E-02
Kfbaz(13, 0) = 6.34090909090909E-02
Kfbaz(14, 0) = 6.32982740471464E-02
Kfbaz(15, 0) = 0.063411503624449
Kfbaz(16, 0) = 6.23592344708078E-02
Kfbaz(17, 0) = 6.32692307692307E-02
Kfbaz(18, 0) = 0.060607822410148
Kfbaz(19, 0) = 6.17957305044035E-02
Kfbaz(20, 0) = 0.067185148838731
Kfbaz(21, 0) = 0.059572884012539
Kfbaz(22, 0) = 6.25763660881801E-02
Kfbaz(23, 0) = 5.85025479694244E-02
Kfbaz(24, 0) = 6.04697476569392E-02
Kfbaz(25, 0) = 5.73181818181818E-02
Kfbaz(26, 0) = 0.057903605015674
Kfbaz(27, 0) = 6.02779610053625E-02
Kfbaz(28, 0) = 5.97724602803472E-02
Kfbaz(29, 0) = 6.04545454545455E-02
Kfbaz(30, 0) = 0.062257977285019
Kfbaz(31, 0) = 6.09827781603259E-02
Kfbaz(32, 0) = 5.98851764111274E-02
Kfbaz(33, 0) = 6.19776119402984E-02
Kfbaz(34, 0) = 6.05060782241015E-02
Kfbaz(35, 0) = 0.056784393134522
Kfbaz(36, 0) = 5.99437300617648E-02
Kfbaz(37, 0) = 5.99613989165789E-02
Kfbaz(38, 0) = 6.02029237702685E-02
Kfbaz(39, 0) = 5.99526068708596E-02
Kfbaz(40, 0) = 6.54176904176904E-02
Kfbaz(41, 0) = 5.97306412313544E-02
Kfbaz(42, 0) = 6.64335664335664E-02
Kfbaz(43, 0) = 6.17263843648208E-02
Kfbaz(44, 0) = 5.65081701124842E-02
Kfbaz(45, 0) = 0.062620213713268
Kfbaz(46, 0) = 5.79271536066425E-02
Kfbaz(47, 0) = 5.86413586413586E-02
Kfbaz(48, 0) = 6.32805615931387E-02
Kfbaz(49, 0) = 6.15802827111272E-02
Kfbaz(50, 0) = 0.063791562388273
Kfbaz(51, 0) = 5.86302211302211E-02
Kfbaz(52, 0) = 6.14199922510655E-02
Kfbaz(53, 0) = 6.74465240641711E-02
Kfbaz(54, 0) = 6.30329153605016E-02
Kfbaz(55, 0) = 5.98961681997297E-02
Kfbaz(56, 0) = 5.87918660287083E-02
Kfbaz(57, 0) = 6.68621700879765E-02
Kfbaz(58, 0) = 0.057851694212592
Kfbaz(59, 0) = 5.90909090909091E-02
Kfbaz(60, 0) = 5.68682189442887E-02
Kfbaz(61, 0) = 6.29278074866309E-02
Kfbaz(62, 0) = 5.40454545454545E-02
Kfbaz(63, 0) = 5.94545454545455E-02
Kfbaz(0, 1) = -11.882703777336
Kfbaz(1, 1) = -6.42727272727282
Kfbaz(2, 1) = -11.7984007446268
Kfbaz(3, 1) = -8.0036227958667
Kfbaz(4, 1) = -14.5756438401049
Kfbaz(5, 1) = -13.6840620225428
Kfbaz(6, 1) = -2.68877347169605
Kfbaz(7, 1) = -10.1255791819688
Kfbaz(8, 1) = -9.11575872142982
Kfbaz(9, 1) = -18.3983173721009
Kfbaz(10, 1) = -5.46659935923341
Kfbaz(11, 1) = -5.25617134559535
Kfbaz(12, 1) = -21.5202164969361
Kfbaz(13, 1) = -14.2
Kfbaz(14, 1) = -11.72205565472
Kfbaz(15, 1) = -14.0891419587333
Kfbaz(16, 1) = -11.1886772872035
Kfbaz(17, 1) = -12.0230769230768
Kfbaz(18, 1) = -9.6232558139536
Kfbaz(19, 1) = -11.3035782051562
Kfbaz(20, 1) = -21.5508995747468
Kfbaz(21, 1) = -9.33189655172384
Kfbaz(22, 1) = -11.7616308044089
Kfbaz(23, 1) = -7.03648757214913
Kfbaz(24, 1) = -7.78937521290627
Kfbaz(25, 1) = -5.68
Kfbaz(26, 1) = -6.13362068965525
Kfbaz(27, 1) = -8.40618564428512
Kfbaz(28, 1) = -3.24755705601244
Kfbaz(29, 1) = -10.9
Kfbaz(30, 1) = -11.7527312060574
Kfbaz(31, 1) = -7.59351961037457
Kfbaz(32, 1) = -6.14064288574332
Kfbaz(33, 1) = -8.36865671641776
Kfbaz(34, 1) = -9.23110465116272
Kfbaz(35, 1) = -5.25097652483394
Kfbaz(36, 1) = -7.9665002854113
Kfbaz(37, 1) = -6.77017928806554
Kfbaz(38, 1) = -9.09836337829408
Kfbaz(39, 1) = -9.05028472693504
Kfbaz(40, 1) = -14.3851351351351
Kfbaz(41, 1) = -8.52747816009985
Kfbaz(42, 1) = -24.1538461538462
Kfbaz(43, 1) = -11.7931596091205
Kfbaz(44, 1) = -3.234584916643
Kfbaz(45, 1) = -12.4492097061443
Kfbaz(46, 1) = -6.27598923196683
Kfbaz(47, 1) = -5.38461538461539
Kfbaz(48, 1) = -11.3732597074546
Kfbaz(49, 1) = -8.98205871692642
Kfbaz(50, 1) = -16.5019663925632
Kfbaz(51, 1) = -5.56756756756756
Kfbaz(52, 1) = -6.95358388221621
Kfbaz(53, 1) = -17.4823529411765
Kfbaz(54, 1) = -13.398275862069
Kfbaz(55, 1) = -6.6517905618754
Kfbaz(56, 1) = -2.19736842105289
Kfbaz(57, 1) = -6.74193548387098
Kfbaz(58, 1) = -5.5824304902992
Kfbaz(59, 1) = 4.66666666666667
Kfbaz(60, 1) = -0.566826770693638
Kfbaz(61, 1) = -12.8014705882351
Kfbaz(62, 1) = 1.34000000000001
Kfbaz(63, 1) = -8.34000000000001
i = 0
m = 0
For i = 0 To 63
m = m + 1
If Namtrbaz(i) = TR1.Value Then
A11 = Kfbaz(i, 0)
A10 = Kfbaz(i, 1)
Exit For
End If
Next i
i = 0
k = 0
For i = 0 To 63
If Namtrbaz(i) = TR2.Value Then
A21 = Kfbaz(i, 0)
A20 = Kfbaz(i, 1)
k = k + 1
Exit For
End If
Next i
If k < 1 Then ' если в базе нет трека с которого переводим считаем по №18(или 17 или другому на выбор)
A21 = Kfbaz(18, 0)
A20 = Kfbaz(18, 1)
End If
FTDI_2 = A21 * d1.Value + d1.Value * ((A11 - A21) * d2.Value + (A10 - A20) + time2 - (A21 * d2.Value + A20)) / d2.Value + A10
End Function
Вводится в яч как
FTDI_2(dist1;dist2;T2;Trek1; Trek2) данные берутся из ячеек листа Excel
1—дист и трек куда переводим
2—дист., время, трек с которого переводим на трек_1
Новая формула пересчёта
FTDI_2 = (A11 - A21) * d1.Value + d1.Value * (time2 - A20) / d2.Value + A10
1—дист и трек куда переводим
2—дист., время, трек с которого переводим на трек_1
вот этот трек не уверен что такое же назван. на сервисе Newmarket (July) и два последних ХЗ чёто не видел назв. можно потом подправить ну и добить там чё нет...
Отредактировано Bambuk, 19 July 2015 - 07:06.
#264 OFFLINE
-
- mp
-
- 6322 сообщения
Специалист
602
Добавлено 20 July 2015 - 11:33
2015-07-20 02:30 Ayr GB / Good To Soft Today´s Racing Just £10 with RacingUK Handicap Flat 6f (6f) (Class 5) 3yo+ Rating: 0-75
New Bidder 6,11995104 11,70960187 27,32240437 151,5151515
Barney Mcgrew 1,40016802 1,860119048 2,850627138 6,313131313
pl Ask Dad 1,271617497 1,595405233 2,310536044 4,578754579
Jinky 2,061005771 2,634351949 3,584229391 5,753739931
Sea Of Green 1,207146306 1,501952538 2,287282708 5,213764338
pl Exotic Guest 1,40016802 1,787629603 2,511300854 4,30292599
lay pl Pomme De Terre 200 1666,666667 #ДЕЛ/0! #ДЕЛ/0!
Goninodaethat 4,436557232 7,73993808 16,02564103 53,76344086
lay pl Amis Reunis 12,85347044 64,1025641 333,3333333 #ДЕЛ/0!
плейсы тут по идее не в тему так как много претендентов...но смотреть всё равно надо лучшие варианты с точки зрения метода (иначе будет не совсем понятно---что он даёт)....
New Bidder 6,11995104 11,70960187 27,32240437 151,5151515
Barney Mcgrew 1,40016802 1,860119048 2,850627138 6,313131313
pl Ask Dad 1,271617497 1,595405233 2,310536044 4,578754579
Jinky 2,061005771 2,634351949 3,584229391 5,753739931
Sea Of Green 1,207146306 1,501952538 2,287282708 5,213764338
pl Exotic Guest 1,40016802 1,787629603 2,511300854 4,30292599
lay pl Pomme De Terre 200 1666,666667 #ДЕЛ/0! #ДЕЛ/0!
Goninodaethat 4,436557232 7,73993808 16,02564103 53,76344086
lay pl Amis Reunis 12,85347044 64,1025641 333,3333333 #ДЕЛ/0!
плейсы тут по идее не в тему так как много претендентов...но смотреть всё равно надо лучшие варианты с точки зрения метода (иначе будет не совсем понятно---что он даёт)....
#265 OFFLINE
-
- mp
-
- 6322 сообщения
Специалист
602
Добавлено 20 July 2015 - 14:07
2015-07-20 03:05 Ayr GB / Good To Soft Polyflor Handicap Flat 5f (5f) (Class 4) 3yo+ Rating: 0-85
pl Pearl Blue 1,488981537 1,690902942 2,084201751 3,415300546
Lexington Place 2,313743637 3,790750569 8,090614887 31,64556962
Rural Celebration 6,289308176 10,96491228 25,77319588 104,1666667
lay pl Lover Man 19,45525292 52,63157895 208,3333333 1250
Something Lucky 3,285151117 4,378283713 6,906077348 16,66666667
Cruise Tothelimit 2,285191956 2,925687537 4,325259516 10,24590164
Ambitious Icarus 2,597402597 3,267973856 4,329004329 8,460236887
pl Gowanharry 1,885369532 2,106149958 2,490039841 3,484320557
Go Go Green 2,508780733 3,725782414 7,473841555 24,87562189
Economic Crisis 3,170577045 4,69043152 9,523809524 30,3030303
lay pl Margrets Gift 37,59398496 138,8888889 454,5454545 #ДЕЛ/0!
Apricot Sky 3,474635163 5,133470226 9,671179884 34,24657534
2015-07-20 04:10 Ayr GB / Good To Soft Fly For Less Glasgow Prestwick Airport Handicap Flat 9f (1m1f20y) (Class 5) 3yo+ Rating: 0-75
lay pl Silver Rime 5,903187721 12,37623762 33,33333333 147,0588235
Sakhalin Star 5,636978579 9,652509653 22,22222222 76,92307692
pl Piccadilly Jim 1,431024614 1,706484642 2,254283138 3,885003885
lay pl Tectonic 6,30517024 12,10653753 33,11258278 161,2903226
lay pl Mash Potato 10,91703057 29,06976744 138,8888889 1000
pl Advance 1,279426817 1,456876457 1,90912562 3,351206434
Yat Ding Yau 2,652519894 4,456327986 9,98003992 45,04504505
pl Sir Lancelott 1,663339987 2,111486486 3,067484663 6,426735219
Iftikaar 2,0500205 2,483854943 3,457814661 6,321112516
Latin Rebel 2,190100745 3,071253071 4,8828125 12,31527094
pl Pearl Blue 1,488981537 1,690902942 2,084201751 3,415300546
Lexington Place 2,313743637 3,790750569 8,090614887 31,64556962
Rural Celebration 6,289308176 10,96491228 25,77319588 104,1666667
lay pl Lover Man 19,45525292 52,63157895 208,3333333 1250
Something Lucky 3,285151117 4,378283713 6,906077348 16,66666667
Cruise Tothelimit 2,285191956 2,925687537 4,325259516 10,24590164
Ambitious Icarus 2,597402597 3,267973856 4,329004329 8,460236887
pl Gowanharry 1,885369532 2,106149958 2,490039841 3,484320557
Go Go Green 2,508780733 3,725782414 7,473841555 24,87562189
Economic Crisis 3,170577045 4,69043152 9,523809524 30,3030303
lay pl Margrets Gift 37,59398496 138,8888889 454,5454545 #ДЕЛ/0!
Apricot Sky 3,474635163 5,133470226 9,671179884 34,24657534
2015-07-20 04:10 Ayr GB / Good To Soft Fly For Less Glasgow Prestwick Airport Handicap Flat 9f (1m1f20y) (Class 5) 3yo+ Rating: 0-75
lay pl Silver Rime 5,903187721 12,37623762 33,33333333 147,0588235
Sakhalin Star 5,636978579 9,652509653 22,22222222 76,92307692
pl Piccadilly Jim 1,431024614 1,706484642 2,254283138 3,885003885
lay pl Tectonic 6,30517024 12,10653753 33,11258278 161,2903226
lay pl Mash Potato 10,91703057 29,06976744 138,8888889 1000
pl Advance 1,279426817 1,456876457 1,90912562 3,351206434
Yat Ding Yau 2,652519894 4,456327986 9,98003992 45,04504505
pl Sir Lancelott 1,663339987 2,111486486 3,067484663 6,426735219
Iftikaar 2,0500205 2,483854943 3,457814661 6,321112516
Latin Rebel 2,190100745 3,071253071 4,8828125 12,31527094
#266 OFFLINE
-
- mp
-
- 6322 сообщения
Специалист
602
Добавлено 20 July 2015 - 14:24
2015-07-20 05:10 Ayr GB / Good To Soft Racing Together Apprentice Handicap Flat 13f (1m5f13y) (Class 6) 3yo+ Rating: 0-65
Politbureau 2,356267672 3,134796238 4,233700254 6,30517024
lay pl Vicky Valentine 2,092050209 3,516174402 6,793478261 20,40816327
pl Eilean Mor 1,407261469 1,821493625 2,583979328 4,52079566
Wor Lass 1,581777918 2,240143369 3,597122302 7,587253414
Blue Cannon 3,615328995 5,279831045 8,460236887 14,88095238
Grand Diamond 1,91424196 2,850627138 5,096839959 11,4416476
pl Toboggan´S Gift 1,046243984 1,161440186 1,569365976 3,511235955
Politbureau 2,356267672 3,134796238 4,233700254 6,30517024
lay pl Vicky Valentine 2,092050209 3,516174402 6,793478261 20,40816327
pl Eilean Mor 1,407261469 1,821493625 2,583979328 4,52079566
Wor Lass 1,581777918 2,240143369 3,597122302 7,587253414
Blue Cannon 3,615328995 5,279831045 8,460236887 14,88095238
Grand Diamond 1,91424196 2,850627138 5,096839959 11,4416476
pl Toboggan´S Gift 1,046243984 1,161440186 1,569365976 3,511235955
#267 OFFLINE
-
- mp
-
- 6322 сообщения
Специалист
602
Добавлено 20 July 2015 - 14:34
2015-07-20 06:40 Beverley GB / Good To Firm Maureen McGrath Birthday Handicap Flat 5f (5f) (Class 5) 3yo+ Rating: 0-75
pl Jack Luey 1,783803068 2,064409579 2,544529262 4,019292605
Noodles Blue Boy 1,703577513 2,436647173 4,480286738 14,74926254
pl El Viento 1,191043354 1,394700139 1,957713391 4,533091568
Tom Sawyer 1,844337883 2,920560748 6,30517024 24,03846154
lay pl Classic Flyer 3,491620112 10,70663812 58,82352941 714,2857143
pl Thatcherite 2,031694433 2,302025783 2,686727566 3,599712023
lay pl Bronze Beau 7,102272727 13,22751323 35,21126761 208,3333333
Tweety Pie 1,814223512 2,26039783 3,369272237 7,288629738
pl Jack Luey 1,783803068 2,064409579 2,544529262 4,019292605
Noodles Blue Boy 1,703577513 2,436647173 4,480286738 14,74926254
pl El Viento 1,191043354 1,394700139 1,957713391 4,533091568
Tom Sawyer 1,844337883 2,920560748 6,30517024 24,03846154
lay pl Classic Flyer 3,491620112 10,70663812 58,82352941 714,2857143
pl Thatcherite 2,031694433 2,302025783 2,686727566 3,599712023
lay pl Bronze Beau 7,102272727 13,22751323 35,21126761 208,3333333
Tweety Pie 1,814223512 2,26039783 3,369272237 7,288629738
#268 OFFLINE
-
- mp
-
- 6322 сообщения
Специалист
602
Добавлено 20 July 2015 - 17:19
2015-07-20 07:40 Beverley GB / Good To Firm Richard And Carol Hudson Handicap Flat 7f (7f100y) (Class 4) 3yo Rating: 0-85
Swift Approval 1,450116009 1,834862385 2,554931017 5,643340858
pl New Strategy 1,160362033 1,304461258 1,572327044 2,472799209
Pumaflor 1,414427157 1,988071571 3,644314869 12,59445844
Mustaqbal 1,300728408 2,069536424 5,324813632 28,57142857
Unnoticed 1,490757305 1,749475157 2,143163309 3,367003367
lay pl Make On Madam 3,311258278 7,656967841 22,83105023 142,8571429
2015-07-20 08:40 Beverley GB / Good To Firm Racing UK Handicap Flat 10f (1m1f207y) (Class 5) 3yo+ Rating: 0-75
pl Tin Pan Alley 1,272588445 1,506024096 2,019386107 3,866976025
pl King Of The Celts 1,249375312 1,434308663 1,801801802 2,853881279
Hussar Ballad 1,949317739 3,043213634 6,242197253 23,69668246
lay pl Impressive Victory 4,780114723 13,26259947 54,34782609 833,3333333
Stoked 2,23015165 3,984063745 10,52631579 58,82352941
pl Mister Rockandroll 1,390820584 1,692620176 2,336448598 4,413062665
Virtual Reality 1,907668829 2,544529262 4,029008864 9,615384615
2015-07-20 07:20 Windsor GB / Good Download The Unibet Racing App Handicap Flat 10f (1m2f7y) (Class 5) 3yo+ Rating: 0-75
pl The Third Man 1,39586823 1,712328767 2,297794118 4,111842105
Avocadeau 2,617801047 3,39673913 4,803073967 8,278145695
pl Biotic 1,190192811 1,448855404 2,15424386 5,12295082
lay pl Munsarim 2,287282708 4,329004329 11,65501166 53,76344086
Shell Bay 2,262443439 2,883506344 3,940110323 6,553079948
Pink Diamond 2,985074627 3,90625 5,688282139 11,01321586
Thames Knight 2,883506344 4,512635379 8,347245409 21,73913043
Capsize 1,998401279 2,659574468 3,888024883 7,530120482
2015-07-20 08:50 Windsor GB / Good Daily Price Boosts With Unibet Handicap Flat 8f (1m67y) (Class 5) 3yo+ Rating: 0-75
pl Twenty One Choice 1,493875112 1,652346332 1,959247649 2,962085308
Unison 1,98019802 2,79173646 5,165289256 17,18213058
Ajig 2,069536424 2,336448598 2,871912694 4,66853408
Hot Mustard 1,851166235 2,590673575 4,793863854 17,73049645
pl Talksalot 1,60307791 1,810282404 2,2737608 4,074979625
Wu Zetian 3,376097232 5,917159763 13,15789474 54,94505495
lay pl Manolito 3,687315634 7,911392405 26,88172043 208,3333333
Molten Lava 2,836074872 5,364806867 14,83679525 67,56756757
Grams And Ounces 4,533091568 5,780346821 8,710801394 20
lay pl Improvized 26,45502646 64,93506494 250 2500
Swift Approval 1,450116009 1,834862385 2,554931017 5,643340858
pl New Strategy 1,160362033 1,304461258 1,572327044 2,472799209
Pumaflor 1,414427157 1,988071571 3,644314869 12,59445844
Mustaqbal 1,300728408 2,069536424 5,324813632 28,57142857
Unnoticed 1,490757305 1,749475157 2,143163309 3,367003367
lay pl Make On Madam 3,311258278 7,656967841 22,83105023 142,8571429
2015-07-20 08:40 Beverley GB / Good To Firm Racing UK Handicap Flat 10f (1m1f207y) (Class 5) 3yo+ Rating: 0-75
pl Tin Pan Alley 1,272588445 1,506024096 2,019386107 3,866976025
pl King Of The Celts 1,249375312 1,434308663 1,801801802 2,853881279
Hussar Ballad 1,949317739 3,043213634 6,242197253 23,69668246
lay pl Impressive Victory 4,780114723 13,26259947 54,34782609 833,3333333
Stoked 2,23015165 3,984063745 10,52631579 58,82352941
pl Mister Rockandroll 1,390820584 1,692620176 2,336448598 4,413062665
Virtual Reality 1,907668829 2,544529262 4,029008864 9,615384615
2015-07-20 07:20 Windsor GB / Good Download The Unibet Racing App Handicap Flat 10f (1m2f7y) (Class 5) 3yo+ Rating: 0-75
pl The Third Man 1,39586823 1,712328767 2,297794118 4,111842105
Avocadeau 2,617801047 3,39673913 4,803073967 8,278145695
pl Biotic 1,190192811 1,448855404 2,15424386 5,12295082
lay pl Munsarim 2,287282708 4,329004329 11,65501166 53,76344086
Shell Bay 2,262443439 2,883506344 3,940110323 6,553079948
Pink Diamond 2,985074627 3,90625 5,688282139 11,01321586
Thames Knight 2,883506344 4,512635379 8,347245409 21,73913043
Capsize 1,998401279 2,659574468 3,888024883 7,530120482
2015-07-20 08:50 Windsor GB / Good Daily Price Boosts With Unibet Handicap Flat 8f (1m67y) (Class 5) 3yo+ Rating: 0-75
pl Twenty One Choice 1,493875112 1,652346332 1,959247649 2,962085308
Unison 1,98019802 2,79173646 5,165289256 17,18213058
Ajig 2,069536424 2,336448598 2,871912694 4,66853408
Hot Mustard 1,851166235 2,590673575 4,793863854 17,73049645
pl Talksalot 1,60307791 1,810282404 2,2737608 4,074979625
Wu Zetian 3,376097232 5,917159763 13,15789474 54,94505495
lay pl Manolito 3,687315634 7,911392405 26,88172043 208,3333333
Molten Lava 2,836074872 5,364806867 14,83679525 67,56756757
Grams And Ounces 4,533091568 5,780346821 8,710801394 20
lay pl Improvized 26,45502646 64,93506494 250 2500
Bambuk, on 20 July 2015 - 11:33, сказал:
2015-07-20 02:30 Ayr GB / Good To Soft Today´s Racing Just £10 with RacingUK Handicap Flat 6f (6f) (Class 5) 3yo+ Rating: 0-75
New Bidder 6,11995104 11,70960187 27,32240437 151,5151515
Barney Mcgrew 1,40016802 1,860119048 2,850627138 6,313131313
pl Ask Dad 1,271617497 1,595405233 2,310536044 4,578754579
Jinky 2,061005771 2,634351949 3,584229391 5,753739931
Sea Of Green 1,207146306 1,501952538 2,287282708 5,213764338
pl (1.71) Exotic Guest 1,40016802 1,787629603 2,511300854 4,30292599
lay pl (3.87) Pomme De Terre 200 1666,666667 #ДЕЛ/0! #ДЕЛ/0!
Goninodaethat 4,436557232 7,73993808 16,02564103 53,76344086
lay pl(8.2) Amis Reunis 12,85347044 64,1025641 333,3333333 #ДЕЛ/0!
плейсы тут по идее не в тему так как много претендентов...но смотреть всё равно надо лучшие варианты с точки зрения метода (иначе будет не совсем понятно---что он даёт)....
New Bidder 6,11995104 11,70960187 27,32240437 151,5151515
Barney Mcgrew 1,40016802 1,860119048 2,850627138 6,313131313
pl Ask Dad 1,271617497 1,595405233 2,310536044 4,578754579
Jinky 2,061005771 2,634351949 3,584229391 5,753739931
Sea Of Green 1,207146306 1,501952538 2,287282708 5,213764338
pl (1.71) Exotic Guest 1,40016802 1,787629603 2,511300854 4,30292599
lay pl (3.87) Pomme De Terre 200 1666,666667 #ДЕЛ/0! #ДЕЛ/0!
Goninodaethat 4,436557232 7,73993808 16,02564103 53,76344086
lay pl(8.2) Amis Reunis 12,85347044 64,1025641 333,3333333 #ДЕЛ/0!
плейсы тут по идее не в тему так как много претендентов...но смотреть всё равно надо лучшие варианты с точки зрения метода (иначе будет не совсем понятно---что он даёт)....
#269 OFFLINE
-
- mp
-
- 6322 сообщения
Специалист
602
Добавлено 20 July 2015 - 17:28
Bambuk, on 20 July 2015 - 14:07, сказал:
2015-07-20 03:05 Ayr GB / Good To Soft Polyflor Handicap Flat 5f (5f) (Class 4) 3yo+ Rating: 0-85
pl(4.5) Pearl Blue 1,488981537 1,690902942 2,084201751 3,415300546
Lexington Place 2,313743637 3,790750569 8,090614887 31,64556962
Rural Celebration 6,289308176 10,96491228 25,77319588 104,1666667
lay pl(2.85) Lover Man 19,45525292 52,63157895 208,3333333 1250
Something Lucky 3,285151117 4,378283713 6,906077348 16,66666667
Cruise Tothelimit 2,285191956 2,925687537 4,325259516 10,24590164
Ambitious Icarus 2,597402597 3,267973856 4,329004329 8,460236887
pl(2.65) Gowanharry 1,885369532 2,106149958 2,490039841 3,484320557
Go Go Green 2,508780733 3,725782414 7,473841555 24,87562189
Economic Crisis 3,170577045 4,69043152 9,523809524 30,3030303
lay pl(5.9) Margrets Gift 37,59398496 138,8888889 454,5454545 #ДЕЛ/0!
Apricot Sky 3,474635163 5,133470226 9,671179884 34,24657534
2015-07-20 04:10 Ayr GB / Good To Soft Fly For Less Glasgow Prestwick Airport Handicap Flat 9f (1m1f20y) (Class 5) 3yo+ Rating: 0-75
lay pl(6.4) Silver Rime 5,903187721 12,37623762 33,33333333 147,0588235
Sakhalin Star 5,636978579 9,652509653 22,22222222 76,92307692
pl(1.83) Piccadilly Jim 1,431024614 1,706484642 2,254283138 3,885003885
lay pl(4.65) Tectonic 6,30517024 12,10653753 33,11258278 161,2903226
lay pl(2.95) Mash Potato 10,91703057 29,06976744 138,8888889 1000
pl(2.34) Advance 1,279426817 1,456876457 1,90912562 3,351206434
Yat Ding Yau 2,652519894 4,456327986 9,98003992 45,04504505
pl Non Runners Sir Lancelott 1,663339987 2,111486486 3,067484663 6,426735219
Iftikaar 2,0500205 2,483854943 3,457814661 6,321112516
Latin Rebel 2,190100745 3,071253071 4,8828125 12,31527094
pl(4.5) Pearl Blue 1,488981537 1,690902942 2,084201751 3,415300546
Lexington Place 2,313743637 3,790750569 8,090614887 31,64556962
Rural Celebration 6,289308176 10,96491228 25,77319588 104,1666667
lay pl(2.85) Lover Man 19,45525292 52,63157895 208,3333333 1250
Something Lucky 3,285151117 4,378283713 6,906077348 16,66666667
Cruise Tothelimit 2,285191956 2,925687537 4,325259516 10,24590164
Ambitious Icarus 2,597402597 3,267973856 4,329004329 8,460236887
pl(2.65) Gowanharry 1,885369532 2,106149958 2,490039841 3,484320557
Go Go Green 2,508780733 3,725782414 7,473841555 24,87562189
Economic Crisis 3,170577045 4,69043152 9,523809524 30,3030303
lay pl(5.9) Margrets Gift 37,59398496 138,8888889 454,5454545 #ДЕЛ/0!
Apricot Sky 3,474635163 5,133470226 9,671179884 34,24657534
2015-07-20 04:10 Ayr GB / Good To Soft Fly For Less Glasgow Prestwick Airport Handicap Flat 9f (1m1f20y) (Class 5) 3yo+ Rating: 0-75
lay pl(6.4) Silver Rime 5,903187721 12,37623762 33,33333333 147,0588235
Sakhalin Star 5,636978579 9,652509653 22,22222222 76,92307692
pl(1.83) Piccadilly Jim 1,431024614 1,706484642 2,254283138 3,885003885
lay pl(4.65) Tectonic 6,30517024 12,10653753 33,11258278 161,2903226
lay pl(2.95) Mash Potato 10,91703057 29,06976744 138,8888889 1000
pl(2.34) Advance 1,279426817 1,456876457 1,90912562 3,351206434
Yat Ding Yau 2,652519894 4,456327986 9,98003992 45,04504505
pl Non Runners Sir Lancelott 1,663339987 2,111486486 3,067484663 6,426735219
Iftikaar 2,0500205 2,483854943 3,457814661 6,321112516
Latin Rebel 2,190100745 3,071253071 4,8828125 12,31527094
#270 OFFLINE
-
- mp
-
- 6322 сообщения
Специалист
602
Добавлено 20 July 2015 - 17:45
Bambuk, on 20 July 2015 - 14:24, сказал:
2015-07-20 05:10 Ayr GB / Good To Soft Racing Together Apprentice Handicap Flat 13f (1m5f13y) (Class 6) 3yo+ Rating: 0-65
Politbureau(2) 2,356267672 3,134796238 4,233700254 6,30517024
lay pl(2.68) Vicky Valentine 2,092050209 3,516174402 6,793478261 20,40816327
pl(3.35) Eilean Mor 1,407261469 1,821493625 2,583979328 4,52079566
Wor Lass(1) 1,581777918 2,240143369 3,597122302 7,587253414
Blue Cannon 3,615328995 5,279831045 8,460236887 14,88095238
Grand Diamond 1,91424196 2,850627138 5,096839959 11,4416476
pl(4.6) Toboggan´S Gift 1,046243984 1,161440186 1,569365976 3,511235955
Politbureau(2) 2,356267672 3,134796238 4,233700254 6,30517024
lay pl(2.68) Vicky Valentine 2,092050209 3,516174402 6,793478261 20,40816327
pl(3.35) Eilean Mor 1,407261469 1,821493625 2,583979328 4,52079566
Wor Lass(1) 1,581777918 2,240143369 3,597122302 7,587253414
Blue Cannon 3,615328995 5,279831045 8,460236887 14,88095238
Grand Diamond 1,91424196 2,850627138 5,096839959 11,4416476
pl(4.6) Toboggan´S Gift 1,046243984 1,161440186 1,569365976 3,511235955
#271 OFFLINE
-
- mp
-
- 6322 сообщения
Специалист
602
Добавлено 20 July 2015 - 19:34
Bambuk, on 20 July 2015 - 14:34, сказал:
2015-07-20 06:40 Beverley GB / Good To Firm Maureen McGrath Birthday Handicap Flat 5f (5f) (Class 5) 3yo+ Rating: 0-75
pl (2.66) Jack Luey 1,783803068 2,064409579 2,544529262 4,019292605
Noodles Blue Boy 1,703577513 2,436647173 4,480286738 14,74926254
pl(4.7) El Viento 1,191043354 1,394700139 1,957713391 4,533091568
Tom Sawyer 1,844337883 2,920560748 6,30517024 24,03846154
lay pl(4.6) Classic Flyer 3,491620112 10,70663812 58,82352941 714,2857143
pl(2.88) Thatcherite 2,031694433 2,302025783 2,686727566 3,599712023
lay pl(1.94) Bronze Beau 7,102272727 13,22751323 35,21126761 208,3333333
Tweety Pie 1,814223512 2,26039783 3,369272237 7,288629738
pl (2.66) Jack Luey 1,783803068 2,064409579 2,544529262 4,019292605
Noodles Blue Boy 1,703577513 2,436647173 4,480286738 14,74926254
pl(4.7) El Viento 1,191043354 1,394700139 1,957713391 4,533091568
Tom Sawyer 1,844337883 2,920560748 6,30517024 24,03846154
lay pl(4.6) Classic Flyer 3,491620112 10,70663812 58,82352941 714,2857143
pl(2.88) Thatcherite 2,031694433 2,302025783 2,686727566 3,599712023
lay pl(1.94) Bronze Beau 7,102272727 13,22751323 35,21126761 208,3333333
Tweety Pie 1,814223512 2,26039783 3,369272237 7,288629738
#272 OFFLINE
-
- mp
-
- 6322 сообщения
Специалист
602
Добавлено 20 July 2015 - 19:48
2015-07-20 07:20 Windsor GB / Good Download The Unibet Racing App Handicap Flat 10f (1m2f7y) (Class 5) 3yo+ Rating: 0-75
pl The Third Man(4.73) 1,39586823 1,712328767 2,297794118 4,111842105
Avocadeau 2,617801047 3,39673913 4,803073967 8,278145695
pl Biotic(1.34)(1место) 1,190192811 1,448855404 2,15424386 5,12295082
lay pl Munsarim(в жопе)(7.4) 2,287282708 4,329004329 11,65501166 53,76344086
Shell Bay(2место) 2,262443439 2,883506344 3,940110323 6,553079948
Pink Diamond 2,985074627 3,90625 5,688282139 11,01321586
Thames Knight 2,883506344 4,512635379 8,347245409 21,73913043
Capsize 1,998401279 2,659574468 3,888024883 7,530120482
pl The Third Man(4.73) 1,39586823 1,712328767 2,297794118 4,111842105
Avocadeau 2,617801047 3,39673913 4,803073967 8,278145695
pl Biotic(1.34)(1место) 1,190192811 1,448855404 2,15424386 5,12295082
lay pl Munsarim(в жопе)(7.4) 2,287282708 4,329004329 11,65501166 53,76344086
Shell Bay(2место) 2,262443439 2,883506344 3,940110323 6,553079948
Pink Diamond 2,985074627 3,90625 5,688282139 11,01321586
Thames Knight 2,883506344 4,512635379 8,347245409 21,73913043
Capsize 1,998401279 2,659574468 3,888024883 7,530120482
#273 OFFLINE
-
- mp
-
- 6322 сообщения
Специалист
602
Добавлено 20 July 2015 - 19:58
2015-07-20 07:40 Beverley GB / Good To Firm Richard And Carol Hudson Handicap Flat 7f (7f100y) (Class 4) 3yo Rating: 0-85
Swift Approval 1,450116009 1,834862385 2,554931017 5,643340858
pl(2.32) New Strategy 1,160362033 1,304461258 1,572327044 2,472799209
Pumaflor 1,414427157 1,988071571 3,644314869 12,59445844
Mustaqbal 1,300728408 2,069536424 5,324813632 28,57142857--пришла 2??(пересчёт лучше но говно..надо средние)
Unnoticed 1,490757305 1,749475157 2,143163309 3,367003367
lay pl(3.04) Make On Madam 3,311258278 7,656967841 22,83105023 142,8571429
Swift Approval 1,450116009 1,834862385 2,554931017 5,643340858
pl(2.32) New Strategy 1,160362033 1,304461258 1,572327044 2,472799209
Pumaflor 1,414427157 1,988071571 3,644314869 12,59445844
Mustaqbal 1,300728408 2,069536424 5,324813632 28,57142857--пришла 2??(пересчёт лучше но говно..надо средние)
Unnoticed 1,490757305 1,749475157 2,143163309 3,367003367
lay pl(3.04) Make On Madam 3,311258278 7,656967841 22,83105023 142,8571429
#274 OFFLINE
-
- mp
-
- 6322 сообщения
Специалист
602
Добавлено 20 July 2015 - 20:51
2015-07-20 08:40 Beverley GB / Good To Firm Racing UK Handicap Flat 10f (1m1f207y) (Class 5) 3yo+ Rating: 0-75
pl(3.01) Tin Pan Alley 1,272588445 1,506024096 2,019386107 3,866976025
pl(2.49) King Of The Celts 1,249375312 1,434308663 1,801801802 2,853881279
Hussar Ballad 1,949317739 3,043213634 6,242197253 23,69668246
lay pl(5.4) Impressive Victory 4,780114723 13,26259947 54,34782609 833,3333333
Stoked 2,23015165 3,984063745 10,52631579 58,82352941
pl (пришла 3)Mister Rockandroll 1,390820584 1,692620176 2,336448598 4,413062665
Virtual Reality 1,907668829 2,544529262 4,029008864 9,615384615
pl(3.01) Tin Pan Alley 1,272588445 1,506024096 2,019386107 3,866976025
pl(2.49) King Of The Celts 1,249375312 1,434308663 1,801801802 2,853881279
Hussar Ballad 1,949317739 3,043213634 6,242197253 23,69668246
lay pl(5.4) Impressive Victory 4,780114723 13,26259947 54,34782609 833,3333333
Stoked 2,23015165 3,984063745 10,52631579 58,82352941
pl (пришла 3)Mister Rockandroll 1,390820584 1,692620176 2,336448598 4,413062665
Virtual Reality 1,907668829 2,544529262 4,029008864 9,615384615
#275 OFFLINE
-
- mp
-
- 6322 сообщения
Специалист
602
Добавлено 20 July 2015 - 21:28
2015-07-20 08:50 Windsor GB / Good Daily Price Boosts With Unibet Handicap Flat 8f (1m67y) (Class 5) 3yo+ Rating: 0-75
pl(2.48) Twenty One Choice 1,493875112 1,652346332 1,959247649 2,962085308
Unison 1,98019802 2,79173646 5,165289256 17,18213058
Ajig 2,069536424 2,336448598 2,871912694 4,66853408
Hot Mustard 1,851166235 2,590673575 4,793863854 17,73049645
pl(15.46) Talksalot 1,60307791 1,810282404 2,2737608 4,074979625
Wu Zetian 3,376097232 5,917159763 13,15789474 54,94505495
lay pl(1.59) Manolito 3,687315634 7,911392405 26,88172043 208,3333333
Molten Lava 2,836074872 5,364806867 14,83679525 67,56756757
Grams And Ounces 4,533091568 5,780346821 8,710801394 20
lay pl(7.4) Improvized 26,45502646 64,93506494 250 2500
pl(2.48) Twenty One Choice 1,493875112 1,652346332 1,959247649 2,962085308
Unison 1,98019802 2,79173646 5,165289256 17,18213058
Ajig 2,069536424 2,336448598 2,871912694 4,66853408
Hot Mustard 1,851166235 2,590673575 4,793863854 17,73049645
pl(15.46) Talksalot 1,60307791 1,810282404 2,2737608 4,074979625
Wu Zetian 3,376097232 5,917159763 13,15789474 54,94505495
lay pl(1.59) Manolito 3,687315634 7,911392405 26,88172043 208,3333333
Molten Lava 2,836074872 5,364806867 14,83679525 67,56756757
Grams And Ounces 4,533091568 5,780346821 8,710801394 20
lay pl(7.4) Improvized 26,45502646 64,93506494 250 2500
#276 OFFLINE
-
- mp
-
- 6322 сообщения
Специалист
602
Добавлено 20 July 2015 - 21:44
ДЕБЕТ_КРЕДЕТ
1,71
3,87 1,30703101
8,2 1,124688279
4,5
2,85 1,468384075
2,65
6,4 1,165562914
2,95 1,445434298
2,34
2,68 1,513347023
2,66
4,7
4,6 1,246305419
1,94 1,881834215
1,34
2,32
3,04 1,42662116
3,01
2,49
7,4 1,140056022
сумм 41,43926442 ставок 34 (текущий % с оборота 21.88) нужен около 30 на большом объёме
ставки на лей считал
=1,1*К/(1,1*К-1)
1,71
3,87 1,30703101
8,2 1,124688279
4,5
2,85 1,468384075
2,65
6,4 1,165562914
2,95 1,445434298
2,34
2,68 1,513347023
2,66
4,7
4,6 1,246305419
1,94 1,881834215
1,34
2,32
3,04 1,42662116
3,01
2,49
7,4 1,140056022
сумм 41,43926442 ставок 34 (текущий % с оборота 21.88) нужен около 30 на большом объёме
ставки на лей считал
=1,1*К/(1,1*К-1)
Отредактировано Bambuk, 20 July 2015 - 21:46.
#277 OFFLINE
-
- Участник
-
- 3 сообщения
Новичок
0
Добавлено 21 August 2015 - 20:20
А кто нибудь ставил по стратегии 3 КФ ??
#278 OFFLINE
-
- Участник II
-
- 74 сообщения
Пунтер
5
Добавлено 22 August 2015 - 21:10
pagon4, on 21 August 2015 - 20:20, сказал:
А кто нибудь ставил по стратегии 3 КФ ??
#279 OFFLINE
-
- RSB
-
- 2226 сообщения
Иерихон
859
Добавлено 22 August 2015 - 21:13
pagon4, on 21 August 2015 - 20:20, сказал:
А кто нибудь ставил по стратегии 3 КФ ??
#280 OFFLINE
-
- Участник II
-
- 312 сообщения
Специалист
20
Добавлено 22 August 2015 - 22:04
pagon4, on 21 August 2015 - 20:20, сказал:
А кто нибудь ставил по стратегии 3 КФ ??
