Clip The Xmas 
Do you mean the Driver Points and Constructor Points tables, the bottom two here?
http://cliptheapex.com/pages/2013-results/
http://cliptheapex.com/pages/2013-results/
Site Suggestions & Updates
- Thread starter Brogan
- Start date
Josephiah
Podium Finisher
Yes indeed, and the Driver Results one - sorry, a link and better description on my part might have been helpful.
I was thinking of:
I was thinking of:
- A final column showing champ position in the Driver Results table, and
- A final column showing current season points totals in the two Points tables.
The driver results one can't be sortable as the cell content isn't all numeric, there are also reasons such as Ret, -, etc., which means sorting doesn't work correctly.
I did originally have sorting but the cells with non numeric characters are sorted first/last so it was never possible to get 1-20.
I will revisit it and see if it's the same.
The bottom two I can add other columns to but it's quite a bit of work so I'll see if I can implement that for next season.
I did originally have sorting but the cells with non numeric characters are sorted first/last so it was never possible to get 1-20.
I will revisit it and see if it's the same.
The bottom two I can add other columns to but it's quite a bit of work so I'll see if I can implement that for next season.
Well I got bored with what I was doing so I added a total column to those two tables after all.
It's not perfect as the cell contents are center aligned, which can't be changed, but it works: http://cliptheapex.com/pages/2013-results/
I'm not sure what value it adds considering the standings are available here anyway but it's done: http://cliptheapex.com/pages/2013-standings/
I tried the sorting of the other tables again and then I remembered why it wasn't possible...
As you can see from the AUS column, as the cells are text formatted, they are sorted 1, 10, 11, 12.....2, 20, 21, 22, 3, and so on.
Unfortunately the Google API doesn't allow for alphanumeric cell content with intelligent sorting.
It's not perfect as the cell contents are center aligned, which can't be changed, but it works: http://cliptheapex.com/pages/2013-results/
I'm not sure what value it adds considering the standings are available here anyway but it's done: http://cliptheapex.com/pages/2013-standings/
I tried the sorting of the other tables again and then I remembered why it wasn't possible...
As you can see from the AUS column, as the cells are text formatted, they are sorted 1, 10, 11, 12.....2, 20, 21, 22, 3, and so on.
Unfortunately the Google API doesn't allow for alphanumeric cell content with intelligent sorting.
Last edited:
Can that be solved by writing the numbers as 01, 02, 03 etc. For Kovalainen would X or similar notation mean his entries where he didn't compete be sent to the bottom of the list.
Last edited:
I have just updated all of the previous season Race Hub pages to add the Tot column to the driver and constructor points tables.
(Not something I ever want to repeat, it was such a laborious task.)
I have also made a slight change to the Head To Head page, moving the values to the inner columns and the driver names to the outer columns: http://cliptheapex.com/pages/2013-head-to-head/
(Not something I ever want to repeat, it was such a laborious task.)
I have also made a slight change to the Head To Head page, moving the values to the inner columns and the driver names to the outer columns: http://cliptheapex.com/pages/2013-head-to-head/
Now we have the featured threads making a regular appearance would it be feasible to award trophy points for getting it noticed? Would reward the intelligent threads as well as encouraging us to write more articles and keep the forum discussion going especially in these bleak winter months.
