How do you make lsdl files?

[bailey]

I deleted the wrong post.

[gmo]

Upon quick glance it looks like you have the pieces laid out correctly for everything, however there are excess double-quote characters everywhere.

I make my .lsdl files through a scripting language these days. Using the spreadsheet I would probably copy the results over into a simple text editor like Notepad, convert the tab delimiters between the cell entries to spaces, then just save the file with an .lsdl extension (as opposed to say .txt). I am guessing you saved it directly to what is posted inside the spreadsheet program and that is why all the excess quote marks as those are the cell collectors.

If you know how to make the entries in the spreadsheet table hold information that will end up as the chunks of data in the resulting file I assume you can get them to work by the method I suggest. It would just take some experimentation to get the final result looking exactly like the lsdl format.

[Le Grande Orange]

Originally Posted by gmo

Using the spreadsheet I would probably copy the results over into a simple text editor like Notepad, convert the tab delimiters between the cell entries to spaces, then just save the file with an .lsdl extension (as opposed to say .txt).

Another approach is to set up the spreadsheet using some simple text replacement formulas to add in the appropriate line format for each line of the schedule. The results can be copied out into Wordpad and then saved from there.

I have an Excel file which does exactly that. It takes a standard list schedule and, using some very simple formulas, changes the dates into day numbers, the teams into team ID numbers, and formats the lines correctly.

[bailey]

deleted.

[exoromeo]

Originally Posted by Le Grande Orange

I have an Excel file which does exactly that. It takes a standard list schedule and, using some very simple formulas, changes the dates into day numbers, the teams into team ID numbers, and formats the lines correctly.

I'm using formulas to do the same thing, LGO, except for dates to day numbers. Having issues with that one. What's the formula you are using to make that happen?

[Le Grande Orange]

Originally Posted by exoromeo

I'm using formulas to do the same thing, LGO, except for dates to day numbers. Having issues with that one. What's the formula you are using to make that happen?

I have a cell at the top of the file where I enter the starting date for the schedule. Then, to convert the date on each line of the actual schedule, I subtract the schedule date line from the opening date cell then add one.

For example, if the opening date is in cell C1, and the first line of the schedule with the game date is in cell A15, then the formula is:

=SUM(A15-C1+1)

To show the result as a number, you'll probably have to change the cell formatting for the cell to show the result as a number rather than a date. I think by default Excel, when subtracting two cells which contain dates, shows the result as a date.