We're please to announce that the finalists are: MTR's 'New Lines New Minds - Professional Passionate Engineers' and 'New Lines New Minds - Synergy'; Atkins Asia Pacific's 'Prevail'; two Arup teams 'AgRUP of MEN' and 'It's all Ova now' and Mott MacDonald's 'Buckingham Palace'.

More details to follow....

The Sponsors Award this year will be presented to Mott MacDonald at the Final.

 

{arijdatatable bAutoWidth="false"} {arisqltable} {arisqltablecolumns} {arisqltablecolumn id="rank" alias="Position" className="idg" className="centerit"} {arisqltablecolumn id="team" alias="Team" headerClassName="head"} {arisqltablecolumn id="sponsor" alias="Sponsor" headerClassName="head"} {arisqltablecolumn id="result" alias="Total Rating" headerClassName="head" className="centerit"} {arisqltablecolumn id="improv" alias="% Improve." headerClassName="head" className="centerit"} {/arisqltablecolumns} {arisqltablequery} SELECT @rank := @rank + 1 AS rank, T1.* FROM ( SELECT #__users.name AS team, #__mrt_team_sponsors.sponsor AS sponsor, c.t_rating as result, ROUND(((100/(SELECT p.t_rating FROM #__mrt_game_results p WHERE p.teamid = c.teamid AND p.period=c.period-1))*c.t_rating)-100) AS improv FROM #__mrt_game_results c LEFT JOIN #__users ON (#__users.username = c.teamid) LEFT Join #__mrt_team_sponsors ON (#__mrt_team_sponsors.teamid = c.teamid) WHERE c.period="12" AND c.game="merit2014" AND c.dat_tim > "2012-01-01 00:00:01" ) AS T1, (SELECT @rank := 0) AS r ORDER BY result DESC LIMIT 10 {/arisqltablequery}{/arisqltable}{/arijdatatable}

Click here to see the Full Period 12 table