Quick bump of my Forum Code Tool. Especially useful for new managers who are not familiar with formatting on the site who want to get nicely colored stat tables for their HQ. Detailed instructions are inside the tool.
I've read a couple times last year that some people struggle with coloring rider tables in previews, HQ roster presentations or wherever you might want to post rider stats. A while back i made myself an excel table that made that process a lot quicker for me and I've used it for basically every HQ post with rider stats and also for the tables you saw in the Conglomerate previews but i've only ever shared it when someone asked me if i had one because the previous version was super raw and messy. I finally decided to clean it up a bit so that i could share it with you.
What can this do? This tool creates the HTML code for colored rider stat tables and links the correct flags. You can quickly hide columns (e.g. if you only need the stats MO, HI, TT, RES, REC, ACC, DH for a stage race preview, that is done very quickly). You can also change the color and the threshold values for the used coloring of stats.
How do I use this? Basically, you copy the riders you want to include (e.g. your team, the top stage racers in a stage race or whatever) from the DB into the input sheet, change which stats are supposed to be visible and then copy the Output table into a forum reply and add the [ table=100% ] [ /table ] brackets (without the spaces obviously). Slightly more detailed explanations about the different modification options are included in the tool that should explain everything well.
Mistakes - If there are any mistakes or questions, please share them in this thread. Also report any missing or wrong flags and stuff like that.
Spoiler
Example for how a table could look with this tool:
Nat.
Name
FL
MO
HI
TT
ST
RS
RC
CB
SP
AC
FG
DH
PR
Age
Silvio Herklotz
72
84
81
74
79
80
78
67
68
76
80
76
78
28
Taylor Phinney
73
85
77
83
77
74
76
58
72
75
68
71
83
32
Pierre-Henri Lecuisinier
71
85
75
77
78
80
79
65
67
74
65
70
77
29
Miguel Angel Lopez
70
79
84
71
76
74
74
50
66
78
80
71
72
28
Fernando Gaviria
76
63
72
65
74
76
80
72
83
84
68
71
71
28
Merhawi Kudus
69
84
77
72
79
77
79
53
63
70
70
67
72
28
Lukasz Wisniowski
80
69
71
74
75
76
71
83
73
76
74
73
77
31
Lachlan Morton
70
84
76
73
79
78
78
54
57
67
68
68
73
30
Joseph Dombrowski
70
84
75
71
80
78
78
55
60
75
67
72
71
31
Alexey Lutsenko
69
73
83
68
76
73
70
54
72
81
69
70
68
30
For managers who already use it:
No new features or changed functionalities so no new download needed but i changed the color table to the one below. By changing the bottom values to the same value as the lowest colored stat, there will be no empty brackets if the min stat for a color isnt reached so I recommend copy pasting the new table over the previous one (On the "Color" page) if you use the default values.
Min Stat
Color
80
red
75
#009900
70
#66ff00
70
70
Spoiler
Once again thank you everyone for all the praise this has gotten everywhere <3
If any (reporter?) wants to use this for race/season previews, but is missing some features, send me a message and I'll try to put out an improved version at some point.
Here is V2 of my Forum Code Tool. For those who want to get nicely colored stat tables for their HQ. Detailed instructions are inside the tool.
Changes: - Medium Mountain stat gets added
- Bugfix to show the Angilla Flag
- Monaco changed from MON to MCO in the DB a couple years ago. Updated.
- Cayman Island, Dominica, Grenada, Oman flags got added
I've read a couple times last year that some people struggle with coloring rider tables in previews, HQ roster presentations or wherever you might want to post rider stats. A while back i made myself an excel table that made that process a lot quicker for me and I've used it for basically every HQ post with rider stats and also for the tables you saw in the Conglomerate previews but i've only ever shared it when someone asked me if i had one because the previous version was super raw and messy. I finally decided to clean it up a bit so that i could share it with you.
What can this do? This tool creates the HTML code for colored rider stat tables and links the correct flags. You can quickly hide columns (e.g. if you only need the stats MO, HI, TT, RES, REC, ACC, DH for a stage race preview, that is done very quickly). You can also change the color and the threshold values for the used coloring of stats.
How do I use this? Basically, you copy the riders you want to include (e.g. your team, the top stage racers in a stage race or whatever) from the DB into the input sheet, change which stats are supposed to be visible and then copy the Output table into a forum reply and add the [ table=100% ] [ /table ] brackets (without the spaces obviously). Slightly more detailed explanations about the different modification options are included in the tool that should explain everything well.
Mistakes - If there are any mistakes or questions, please share them in this thread. Also report any missing or wrong flags and stuff like that.
Example for how a table could look with this tool:
Here is V2 of my Forum Code Tool. For those who want to get nicely colored stat tables for their HQ. Detailed instructions are inside the tool.
Changes: - Medium Mountain stat gets added
- Bugfix to show the Angilla Flag
- Monaco changed from MON to MCO in the DB a couple years ago. Updated.
- Cayman Island, Dominica, Grenada, Oman flags got added
I've read a couple times last year that some people struggle with coloring rider tables in previews, HQ roster presentations or wherever you might want to post rider stats. A while back i made myself an excel table that made that process a lot quicker for me and I've used it for basically every HQ post with rider stats and also for the tables you saw in the Conglomerate previews but i've only ever shared it when someone asked me if i had one because the previous version was super raw and messy. I finally decided to clean it up a bit so that i could share it with you.
What can this do? This tool creates the HTML code for colored rider stat tables and links the correct flags. You can quickly hide columns (e.g. if you only need the stats MO, HI, TT, RES, REC, ACC, DH for a stage race preview, that is done very quickly). You can also change the color and the threshold values for the used coloring of stats.
How do I use this? Basically, you copy the riders you want to include (e.g. your team, the top stage racers in a stage race or whatever) from the DB into the input sheet, change which stats are supposed to be visible and then copy the Output table into a forum reply and add the [ table=100% ] [ /table ] brackets (without the spaces obviously). Slightly more detailed explanations about the different modification options are included in the tool that should explain everything well.
Mistakes - If there are any mistakes or questions, please share them in this thread. Also report any missing or wrong flags and stuff like that.
Example for how a table could look with this tool:
Nat.
Name
FL
MO
MM
HI
TT
ST
RS
RC
CB
SP
AC
FG
DH
PR
Luke Plapp
72
79
78
76
77
74
78
76
58
62
68
73
65
78
Miguel Angel Lopez
70
80
82
84
71
76
74
74
50
66
78
80
71
72
Pierre-Henri Lecuisinier
71
85
80
75
78
78
80
79
65
67
74
65
70
77
Martins Blums
72
77
77
77
68
71
73
74
63
64
70
73
78
71
Krists Neilands
77
56
63
69
63
74
73
70
78
71
67
63
71
67
Eriks Toms Gavars
70
75
75
74
73
71
73
72
58
67
70
70
67
72
Alekss Krasts
70
76
74
72
73
72
72
72
59
66
70
73
73
73
Kristers Ansons
78
68
69
70
71
73
72
70
69
73
76
72
69
70
Pascal Eenkhoorn
71
78
76
73
69
76
77
80
65
64
71
69
67
75
Tobias Foss
69
78
75
72
77
77
79
79
66
60
69
68
66
72
Fredrik Dversnes
78
67
68
69
66
76
76
72
70
69
77
77
67
68
Stepan Kurianov
79
65
65
65
62
76
74
76
71
75
70
72
70
64
Jan Polanc
71
73
73
72
69
77
72
63
77
66
74
66
70
73
And now with the Kosovo flag added as well. Thanks to cunego
