eddie Posted June 18, 2014 Share Posted June 18, 2014 It seems like one correct score and fgs will fire anyone top. Japan - Ivory Coast did me a great favour! When I started writing the app, I was struggling to think of a way to keep the interest going if someone was to start running away with it. As it is, there are about 10 participants who could go top with just a 2-1 or a 3-1 plus the FGS. Even the Memsahib is still confident that just four consecutive all-corrects would leave you all trailing in her wake. Link to comment Share on other sites More sharing options...
Shuff264 Posted June 18, 2014 Share Posted June 18, 2014 When I started writing the app, I was struggling to think of a way to keep the interest going if someone was to start running away with it. As it is, there are about 10 participants who could go top with just a 2-1 or a 3-1 plus the FGS. Even the Memsahib is still confident that just four consecutive all-corrects would leave you all trailing in her wake. Im sure by the end of tomorrow, I'll be 20pts clear Link to comment Share on other sites More sharing options...
eddie Posted June 18, 2014 Share Posted June 18, 2014 Im sure by the end of tomorrow, I'll be 20pts clear I'm sure by the end of tomorrow, I will have rewritten the calculation engine. Bloody thing takes 30 seconds to run now. Link to comment Share on other sites More sharing options...
Grimbeard Posted June 18, 2014 Share Posted June 18, 2014 Of course I'm still playing. We've got the same number of points today and we've both got the same prediction for the Croatia game. It's that young pretender Jourdan we need to be wary of. Ee, I do like t see a bit of over confidence in my opponents. Link to comment Share on other sites More sharing options...
Boycie Posted June 18, 2014 Share Posted June 18, 2014 Anyone seen JW on the table? Link to comment Share on other sites More sharing options...
-JW- Posted June 18, 2014 Share Posted June 18, 2014 I'm slip streaming the top 2. In the words of B4, 'I'll be top by christmas'. Link to comment Share on other sites More sharing options...
Shuff264 Posted June 18, 2014 Share Posted June 18, 2014 I'm sure by the end of tomorrow, I will have rewritten the calculation engine. Bloody thing takes 30 seconds to run now. Wish I could help, but I'm no good with VBA Link to comment Share on other sites More sharing options...
eddie Posted June 18, 2014 Share Posted June 18, 2014 Wish I could help, but I'm no good with VBA Not a problem - at the moment I'm using nested 'If' statements, so as the number of both matches and predictions increase, the time to execute increases exponentially. I'm going to change it to use a single loop to process the predictions, then use locator variables to pick up the match results directly and to post the resultant points into a logical position (by column and row) in a worksheet based upon the match number and participant number. Should be simple. In fact, if I read all the match results and FGS into memory and store them in an internal array as well, it'll be much more rapid. Link to comment Share on other sites More sharing options...
Shuff264 Posted June 18, 2014 Share Posted June 18, 2014 Not a problem - at the moment I'm using nested 'If' statements, so as the number of both matches and predictions increase, the time to execute increases exponentially. I'm going to change it to use a single loop to process the predictions, then use locator variables to pick up the match results directly and to post the resultant points into a logical position (by column and row) in a worksheet based upon the match number and participant number. Should be simple. In fact, if I read all the match results and FGS into memory and store them in an internal array as well, it'll be much more rapid. Yea, nested if statements can get out of control pretty quickly Array would be good, just gotta make sure its large enough or variable sized Link to comment Share on other sites More sharing options...
eddie Posted June 18, 2014 Share Posted June 18, 2014 Yea, nested if statements can get out of control pretty quickly Array would be good, just gotta make sure its large enough or variable sized Maximum number of matches in the entire tournament is only 64 - that will be the maximum dimension of the array. I'll allocate it dynamically based upon the 'high' match number for the current run (user-entered parameter). Link to comment Share on other sites More sharing options...
Shuff264 Posted June 18, 2014 Share Posted June 18, 2014 Maximum number of matches in the entire tournament is only 64 - that will be the maximum dimension of the array. I'll allocate it dynamically based upon the 'high' match number for the current run (user-entered parameter). Sorted then! Link to comment Share on other sites More sharing options...
eddie Posted June 18, 2014 Share Posted June 18, 2014 Sorted then! There's no built-in 'sort' facility in VBA, but I can always write a swap sort/bubble sort. Oh sorry, not what you meant. Link to comment Share on other sites More sharing options...
Shuff264 Posted June 18, 2014 Share Posted June 18, 2014 There's no built-in 'sort' facility in VBA, but I can always write a swap sort/bubble sort. Oh sorry, not what you meant. No! But bubble sorts are pretty simple to throw in Link to comment Share on other sites More sharing options...
eddie Posted June 18, 2014 Share Posted June 18, 2014 DCFCFans World Cup Leaderboard - 2014-06-19 after Match 20 (Cameroon 0 Croatia 4) ------------------------------ Position Name Points -------- ---- ------ 1 Angry Ram 42 2 Jourdan 39 3 JW_DCFC 38 4 Shuff264 34 5 Grimbeard 32 5 maza233 32 7 Dale The Ram 30 8 CumbrianRam 28 9 dabber 27 9 r4derby 27 11 mo55y 26 12 Old Spalding Ram 25 13 Ambitious 24 13 KGDCFC 24 13 Leicester Ram 24 16 Srg 23 17 chezzyram 22 18 Dimmu 21 19 swansea ram 18 20 davenportram 17 20 reveldevil 17 22 maydrakin 14 22 Posh Ram 14 24 AnimalisaRam 12 24 Cam the Ram 12 26 Daaave 9 27 froggg 4 28 TheMemsahib 0 Today's top performers: chezzyram 4 Today's hall of shame: Daaave 0 AnimalisaRam 0 froggg 0 TheMemsahib 0 Link to comment Share on other sites More sharing options...
dabber Posted June 19, 2014 Share Posted June 19, 2014 Thursday 19 June Group C, Colombia v Ivory Coast (17:00), 2-2, Drogba Group D, Uruguay v England (20:00), 1-2, Rooney Group C, Japan v Greece (23:00), 2-1, Okazaki Link to comment Share on other sites More sharing options...
davenportram Posted June 19, 2014 Share Posted June 19, 2014 Thursday 19 June Group C, Colombia v Ivory Coast (17:00) 2 - 1 Gutierrez Group D, Uruguay v England (20:00) 1- 2 Sturridge Group C, Japan v Greece (23:00) 1 -3 Gekas Link to comment Share on other sites More sharing options...
Grimbeard Posted June 19, 2014 Share Posted June 19, 2014 ... I'm going to change it to use a single loop to process the predictions, then use locator variables to pick up the match results directly and to post the resultant points into a logical position (by column and row) in a worksheet based upon the match number and participant number. Should be simple. Well done that man. Carry on, just how I would have done it. Link to comment Share on other sites More sharing options...
chezzyram Posted June 19, 2014 Share Posted June 19, 2014 Thursday 19 June Group C, Colombia v Ivory Coast (17:00) 2-2, Rodriguez Group D, Uruguay v England (20:00) 1-2, Rooney Group C, Japan v Greece (23:00) 1-0, Honda Friday 20 June Group D, Italy v Costa Rica (17:00) 2-0, Ballotelli Group E, Switzerland v France (20:00) 0-2, Benzema Group E, Honduras v Ecuador (23:00) 0-2, Enner Valencia Saturday 21 June Group F, Argentina v Iran (17:00) 2-0, Aguero Group G, Germany v Ghana (20:00) 3-0, Gotze Group F, Nigeria v Bosnia-Herzegovena (23:00) 1-1, Dzeko Sunday 22 June Group H, Belgium v Russia (17:00) 2-1, Lukaku Group H, South Korea v Algeria (20:00) 2-1, Son Hueng-min Group G, USA v Portugal (23:00) 1-3, Ronaldo Link to comment Share on other sites More sharing options...
Rev Posted June 19, 2014 Share Posted June 19, 2014 Columbia v ivory coast 2-2 j Rodriguez Uruguay v England 0-3 Rooney Japan v Greece 2-0 Honda Link to comment Share on other sites More sharing options...
Srg Posted June 19, 2014 Share Posted June 19, 2014 Columbia 3-1 Ivory Coast - Cuadrado Uruguary 1-1 England - Cavani Japan 2-0 Greece - Okazaki Italy 3-1 Costa Rica - Balotelli Switzerland 1-3 France - Griezmann Honduras 0-2 Ecuador - E Vaencia Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.