|
|
|
|
#1
08-16-2006, 06:14 PM
|
|||
|
|||
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? 
|
|
#5
08-16-2006, 07:04 PM
|
|||
|
|||
|
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.
|
|
#6
08-16-2006, 07:08 PM
|
|||
|
|||
|
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 ]
|
|
#7
08-16-2006, 07:24 PM
|
|||
|
|||
|
Re: Who wants to talk countif() tags?
that is good.
|
|
#8
08-16-2006, 07:26 PM
|
|||
|
|||
|
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.
|
|
#9
08-16-2006, 07:33 PM
|
|||
|
|||
|
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
|
|
#10
08-16-2006, 08:02 PM
|
|||
|
|||
|
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.
|
 |
|
|
Hybrid Mode
