Who wants to talk countif() tags?
So, Horn had the great idea of actually automating a bunch of tags around his countif(), mostly to show off his mad excel skillzors.
This of course sounded a lot more fun than my real job so I updated my (almost completely unused) countif() spreadsheet to have some of these additional tags. However, there are certainly a few different ways to mark it up. Does anyone have any thoughts on what might be most readable? [ 1 ] amplify voted for Our House [ 2 ] BobOjedaFan voted for KyrosMother [ 0 ] Chuckleslovakian voted for BobOjedaFan <font color="red"> [ 4 ] durron597 voted for sighing </font> [ 2 ] fnord_too voted for Tokyo!! [ 0 ] GetThere1Time voted for fnord_too [ 0 ] Jonsan voted for fnord_too [ 0 ] kyro voted for durron597 [ 1 ] KyrosMother voted for Shortline99 [ 0 ] Nicholasp27 voted for sighing [ 1 ] Our House voted for durron597 [ 0 ] pudley4 voted for durron597 <font color="red"> [ 4 ] Shortline99 voted for durron597 </font> [ 3 ] sighing voted for BobOjedaFan [ 0 ] Thebram voted for Shortline99 [ 1 ] Tokyo!! voted for amplify [ 0 ] traz voted for [ 0 ] VoraciousReader voted for Shortline99 [ 0 ] wdcbooks voted for Shortline99 [ 0 ] WillMagic voted for sighing [ 0 ] xorbie voted for vs [ 1 ] amplify voted for durron597 [ 2 ] BobOjedaFan voted for KyrosMother [ 0 ] Chuckleslovakian voted for BobOjedaFan <font color="red"> [ 5 ] durron597 </font> voted for sighing [ 2 ] fnord_too voted for Tokyo!! [ 0 ] GetThere1Time voted for fnord_too [ 0 ] Jonsan voted for fnord_too [ 0 ] kyro voted for durron597 [ 1 ] KyrosMother voted for durron597 [ 0 ] Nicholasp27 voted for sighing [ 0 ] Our House voted for durron597 [ 0 ] pudley4 voted for durron597 <font color="brown"> [ 4 ] Shortline99 </font> voted for durron597 [ 3 ] sighing voted for BobOjedaFan [ 0 ] Thebram voted for durron597 [ 1 ] Tokyo!! voted for amplify [ 0 ] traz voted for [ 0 ] VoraciousReader voted for Shortline99 [ 0 ] wdcbooks voted for durron597 [ 0 ] WillMagic voted for sighing [ 0 ] xorbie voted for Or even: [ 1 ] amplify voted for <font color="red"> durron597 </font> [ 2 ] BobOjedaFan voted for KyrosMother [ 0 ] Chuckleslovakian voted for BobOjedaFan [ 6 ] <font color="red"> durron597 </font> voted for sighing [ 4 ] <font color="brown"> fnord_too </font> voted for Tokyo!! [ 0 ] GetThere1Time voted for <font color="brown"> fnord_too </font> [ 0 ] Jonsan voted for <font color="brown"> fnord_too </font> [ 0 ] kyro voted for <font color="red"> durron597 </font> [ 1 ] KyrosMother voted for <font color="red"> durron597 </font> [ 0 ] Nicholasp27 voted for sighing [ 0 ] Our House voted for <font color="brown"> fnord_too </font> [ 0 ] pudley4 voted for <font color="brown"> fnord_too </font> [ 1 ] Shortline99 voted for <font color="red"> durron597 </font> [ 3 ] sighing voted for BobOjedaFan [ 0 ] Thebram voted for <font color="red"> durron597 </font> [ 1 ] Tokyo!! voted for amplify [ 0 ] traz voted for [ 0 ] VoraciousReader voted for Shortline99 [ 0 ] wdcbooks voted for <font color="red"> durron597 </font> [ 0 ] WillMagic voted for sighing [ 0 ] xorbie voted for Or mix and match tags as you like. Who knows, if I end up liking my countif() spreadsheet enough maybe I'll mod more. Ideas? Comments? Snide remarks on how uninteresting this topic is to you? |
Re: Who wants to talk countif() tags?
I hate the italics. the last is best by far. also the brown/purple/whatever you're using for second place is barely distinguishable from black.
|
Re: Who wants to talk countif() tags?
[ QUOTE ]
the last is best by far. [/ QUOTE ] |
Re: Who wants to talk countif() tags?
bold > italics
|
Re: Who wants to talk countif() tags?
Should the vote count number be colored as well? Any thoughts on what the #1 and #2 colors should be? I stole them straight up from Horn's posts.
On a side note, this has given me a chance to play around with the board's tags as well. I might actually learn how this stuff works at some point. |
Re: Who wants to talk countif() tags?
[ QUOTE ]
[ 1 ] amplify voted for <font color="red"> durron597 </font> [ 2 ] BobOjedaFan voted for KyrosMother [ 0 ] Chuckleslovakian voted for BobOjedaFan [ 6 ] <font color="red"> durron597 </font> voted for sighing [ 4 ] <font color="blue"> fnord_too </font> voted for Tokyo!! [ 0 ] GetThere1Time voted for <font color="blue"> fnord_too </font> [ 0 ] Jonsan voted for <font color="blue"> fnord_too </font> [ 0 ] kyro voted for <font color="red"> durron597 </font> [ 1 ] KyrosMother voted for <font color="red"> durron597 </font> [ 0 ] Nicholasp27 voted for sighing [ 0 ] Our House voted for <font color="blue"> fnord_too </font> [ 0 ] pudley4 voted for <font color="blue"> fnord_too </font> [ 1 ] Shortline99 voted for <font color="red"> durron597 </font> [ 3 ] sighing voted for BobOjedaFan [ 0 ] Thebram voted for <font color="red"> durron597 </font> [ 1 ] Tokyo!! voted for amplify [ 0 ] traz voted for [ 0 ] VoraciousReader voted for Shortline99 [ 0 ] wdcbooks voted for <font color="red"> durron597 </font> [ 0 ] WillMagic voted for sighing [ 0 ] xorbie voted for [/ QUOTE ] |
Re: Who wants to talk countif() tags?
that is good.
|
Re: Who wants to talk countif() tags?
[ QUOTE ]
[ 1 ] amplify voted for <font color="red"> durron597 </font> [ 2 ] BobOjedaFan voted for KyrosMother [ 0 ] Chuckleslovakian voted for BobOjedaFan [ 6 ] <font color="red"> durron597 </font> voted for sighing [ 4 ] <font color="blue"> fnord_too </font> voted for Tokyo!! [ 0 ] GetThere1Time voted for <font color="blue"> fnord_too </font> [ 0 ] Jonsan voted for <font color="blue"> fnord_too </font> [ 0 ] kyro voted for <font color="red"> durron597 </font> [ 1 ] KyrosMother voted for <font color="red"> durron597 </font> [ 0 ] Nicholasp27 voted for sighing [ 0 ] Our House voted for <font color="blue"> fnord_too </font> [ 0 ] pudley4 voted for <font color="blue"> fnord_too </font> [ 1 ] Shortline99 voted for <font color="red"> durron597 </font> [ 3 ] sighing voted for BobOjedaFan [ 0 ] Thebram voted for <font color="red"> durron597 </font> [ 1 ] Tokyo!! voted for amplify [ 0 ] traz voted for [ 0 ] VoraciousReader voted for Shortline99 [ 0 ] wdcbooks voted for <font color="red"> durron597 </font> [ 0 ] WillMagic voted for sighing [ 0 ] xorbie voted for [/ QUOTE ] Nice. |
Re: Who wants to talk countif() tags?
[ QUOTE ]
[ QUOTE ] [ 1 ] amplify voted for <font color="red"> durron597 </font> [ 2 ] BobOjedaFan voted for KyrosMother [ 0 ] Chuckleslovakian voted for BobOjedaFan [ 6 ] <font color="red"> durron597 </font> voted for sighing [ 4 ] <font color="blue"> fnord_too </font> voted for Tokyo!! [ 0 ] GetThere1Time voted for <font color="blue"> fnord_too </font> [ 0 ] Jonsan voted for <font color="blue"> fnord_too </font> [ 0 ] kyro voted for <font color="red"> durron597 </font> [ 1 ] KyrosMother voted for <font color="red"> durron597 </font> [ 0 ] Nicholasp27 voted for sighing [ 0 ] Our House voted for <font color="blue"> fnord_too </font> [ 0 ] pudley4 voted for <font color="blue"> fnord_too </font> [ 1 ] Shortline99 voted for <font color="red"> durron597 </font> [ 3 ] sighing voted for BobOjedaFan [ 0 ] Thebram voted for <font color="red"> durron597 </font> [ 1 ] Tokyo!! voted for amplify [ 0 ] traz voted for [ 0 ] VoraciousReader voted for Shortline99 [ 0 ] wdcbooks voted for <font color="red"> durron597 </font> [ 0 ] WillMagic voted for sighing [ 0 ] xorbie voted for [/ QUOTE ] Nice. [/ QUOTE ] Winnah |
Re: Who wants to talk countif() tags?
And soah with the win. It's not a game, but you win.
Last tweak for now: colorize the vote total or no? For comparison (and how this all looks on 9 players): [ 1 ] amplify voted for <font color="red"> durron597 </font> [ 1 ] BobOjedaFan voted for fnord_too [ 0 ] Chuckleslovakian voted for <font color="red"> durron597 </font> [ 3 ] <font color="red"> durron597 </font> voted for <font color="blue"> GetThere1Time </font> [ 1 ] fnord_too voted for kyro [ 2 ] <font color="blue"> GetThere1Time </font> voted for <font color="red"> durron597 </font> [ 0 ] Jonsan voted for <font color="blue"> GetThere1Time </font> [ 1 ] kyro voted for amplify [ 0 ] KyrosMother voted for BobOjedaFan or [ 1 ] amplify voted for <font color="red"> durron597 </font> [ 1 ] BobOjedaFan voted for fnord_too [ 0 ] Chuckleslovakian voted for <font color="red"> durron597 </font> <font color="red">[ 3 ] durron597 </font> voted for <font color="blue"> GetThere1Time </font> [ 1 ] fnord_too voted for kyro <font color="blue">[ 2 ] GetThere1Time </font> voted for <font color="red"> durron597 </font> [ 0 ] Jonsan voted for <font color="blue"> GetThere1Time </font> [ 1 ] kyro voted for amplify [ 0 ] KyrosMother voted for BobOjedaFan I'll worry about how ties should look later. |
All times are GMT -4. The time now is 08:30 PM. |
Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.