Difference between revisions of "Talk:Master Integrated Timeline"
From ConRunner
(lexical sorting) |
Tbmorgan74 (Talk | contribs) |
||
| Line 16: | Line 16: | ||
:It looks like it's sorting lexically on the "days out" field, not numerically. So it goes -1, -10, -100, -101, -102, ..., -11, -110, ... which is not really useful. Maybe forcing to a fixed numeric width will help some, but the sort will still be backwards for precon milestones. --[[User:Phi|phi]] 08:52, 22 February 2007 (PST) | :It looks like it's sorting lexically on the "days out" field, not numerically. So it goes -1, -10, -100, -101, -102, ..., -11, -110, ... which is not really useful. Maybe forcing to a fixed numeric width will help some, but the sort will still be backwards for precon milestones. --[[User:Phi|phi]] 08:52, 22 February 2007 (PST) | ||
| + | |||
| + | ::Your right. I dont even think we should keep days out. Months out would be sufficient. Decimal months should work for tight periods like just before the con. Notice that Months do work, and sort downwards from the past, thru 0, and into the future. --[[User:Tbmorgan74|Tbmorgan74]] 14:00, 22 February 2007 (PST) | ||
Revision as of 15:00, 22 February 2007
This is the first step in the master timeline. I used this:
http://de.wikipedia.org/wiki/Wikipedia:Helferlein/VBA-Macro_for_EXCEL_tableconversion#VBA-Source
to create a base table, using phi's data.
Then I tweaked it to make it sortable.
The results look promising. But the data needs to be scrubbed in Excel before I export it. Scrubbing in wiki is terrible.
Also, this page has yet another version of mediawiki with a wysiwyg editor for tables:
http://www.wikipage.org/wikinaut/index.php/WYSIWYG-Editor/Sandbox --Tbmorgan74 16:03, 21 February 2007 (PST)
- It looks like it's sorting lexically on the "days out" field, not numerically. So it goes -1, -10, -100, -101, -102, ..., -11, -110, ... which is not really useful. Maybe forcing to a fixed numeric width will help some, but the sort will still be backwards for precon milestones. --phi 08:52, 22 February 2007 (PST)
- Your right. I dont even think we should keep days out. Months out would be sufficient. Decimal months should work for tight periods like just before the con. Notice that Months do work, and sort downwards from the past, thru 0, and into the future. --Tbmorgan74 14:00, 22 February 2007 (PST)
