Difference between revisions of "Talk:Master Integrated Timeline"

Revision as of 15:33, 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)

Nope, months are sorting "-1" before "-10" as well, at least for me. --phi 14:33, 22 February 2007 (PST)