Draft Question

[Michael Xavier]

Without manually doing it, is there a way to make it so the team that comes in first picks first in the draft?

[Orcin]

I don't think so.

[NoOne]

Just a couple workarounds-- openoffice calc is free, too.

you can setup a spreadsheet to mostly automate this at least.

This is less automated, but still fast:

export the data as csv, pop into openoffice calc (free and syntax may be different than MS excel, below).

insert a row next to team neam, type a 1 into it... fill down to match # of rows... you know have a 1, 2, 3 ... count next to tteam names.

highlight tha tcolumn plus teams (any column related to a team, but not related to order of the ddraft, actually... even move them around temporarily, if necessary, and move back at end of process to correct order)

sort descending... you should know have reversed the order of anything team related and retained draft round / pick etc... delete the count column you added... save as CSV or TXT etc... pay attention to "delemiting" options, you don't want " " added all ove rthe place, for example. re-import to game... now reversed in a few seconds of effort.

smarter way:

link a worksheet to the exported draft file (external data link) -- heck, if it's in the same directory and named the same each year, you only do this one time, ever.

use different worksheet to link to the worksheet that contains the exported data... you now only need to set up 2 rows.

2rows:

any round / pick type order must be linked in it's existing order - e.g. if it's a1, then "=!worksheet1.A1" ... (assumes worksheet1 is name of sheet with exported data) ... and of course to the 2nd row -> 2nd row, too.... you can fill across, then delete any column that contains data that needs to be reversed... save the re-typing. so, you only have to type into 2 different cells to do this at minimum.

if it's anythign to do with the teams you are reversing the order, then you need to link to the LAST row for that data in the first row of this work sheet... and of course the 2nd to last row in the 2nd row. if you filled accross with the previous stuff, you'll have to type this in individually if not adjacent to each other... (whichever is less work, i assume less stuff is reversing).

so you do that for only the first 2 rows to set up the series for the spreadsheet to do the rest.. now, you can highlight those 2 rows you created and "fill" down... pow, it's reversed! (highlight area first, then use Tools-> fill if it's thousands of rows -- click top-left cell... then shift-click bottom-right cell -- you can even name this range for future use)

Okay, now export the second worksheet as a csv / txt etc...just as above... if you have to delete the other worksheet, so be it, just don't save over the original file...

So, each time you load it up from now on, it will ask : "Do you want to update linked files?", you click yes, and the entire thing is already finished for you on the 2nd worksheet... links update automatically throughout the entire sheet with the new data... simply export as normal, like above.

get in a habit of "save as" different name right after you load it up... retain a backup just in case you delete something and save over, etc...

always link to exported data to it's own worksheet to manipulate... never manipulate the exported data... this ensures data integrity and automates everything.

*** if fill doesn't work as i stated above, there is a way... just go about it differently.. it hsould understand n-1 and n+1 for the fields, though... 99% sure you won't need to use the file menu - Tools->fill function (offers more options for the pattern/series to fill).