col1   col2  col3   col4  col5    col6    col7   col8    col9
akashkum 478.50 49.84 449.33 40.12 1999.68 2011.68  46.74 2058.42
chenting 466.57 48.60 333.83 29.81 1448.63 1456.63  98.35 1554.98
isc07211 475.00 49.48 466.67 41.67 2061.63 2070.63  92.87 2163.50
johansya  80.00  8.33  27.00  2.41   20.09   28.09   0.00   28.09
jonathan 286.00 29.79 152.50 13.62  405.65  413.65 227.27  640.92
kohchung 334.00 34.79 327.33 29.23 1016.83 1025.83 184.45 1210.28
lohyeong 362.00 37.71 383.80 34.27 1292.18 1324.18  72.52 1396.70
ouyongji  93.00  9.69 147.50 13.17  127.58  135.58   3.36  138.94
phanthix 446.29 46.49 445.30 39.76 1848.32 1865.32  38.83 1904.15
trantuan 330.00 34.38 266.67 23.81  818.45  829.45   2.60  832.05
trianaku 292.71 30.49 213.50 19.06  581.24  590.24  39.61  629.85
wangying 479.40 49.94 367.83 32.84 1640.06 1652.06 555.77 2207.83
zhangxin 480.00 50.00 492.33 43.96 2197.92 2206.92 601.61 2808.53
zhoujing 448.71 46.74 405.00 36.16 1690.19 1699.19 329.24 2028.43
zhuwenbi 478.50 49.84 526.67 47.02 2343.84 2355.84 293.72 2649.56
zhuyi    479.40 49.94 534.33 47.71 2382.43 2394.43 563.06 2957.49

col1 = userid
col2 = 80% fractional knapsack on homework      max =  480
col3 = col2 scaled to 50 marks                  max =   50
col4 = 80% fractional knapsack on tests         max =  560
col5 = col4 scaled to 50 marks                  max =   50
col6 = col3 * col5                              max = 2500
col7 = col6 + bonuses (excluding judge)         max = 2550
col8 = judge scores at deadline
col9 = col7 + col8 = final score