OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Turning a chart into a CUE Sheet

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
Arithmomaniac
General User
General User


Joined: 30 May 2008
Posts: 9

PostPosted: Mon Jun 02, 2008 9:06 am    Post subject: Turning a chart into a CUE Sheet Reply with quote

I have a table of track names and times, such as

Track 1 00:00
Track 2 02:40

etc.

What's the best way to turn this table into a CUE sheet? Is there a common template? Coding? Do I need to export it to Openoffice Base?

I know this is a broad question. but I don't know where to start.
Thanks,
Arithmomaniac
Back to top
View user's profile Send private message
Villeroy
Super User
Super User


Joined: 04 Oct 2004
Posts: 10106
Location: Germany

PostPosted: Mon Jun 02, 2008 12:14 pm    Post subject: Reply with quote

2 columns of name and time do not provide enough information for a CUE sheet, if you mean http://en.wikipedia.org/wiki/Cue_sheet_%28computing%29
You should not let the readers find out what a CUE sheet is.
_________________
Rest in peace, oooforum.org
Get help on https://forum.openoffice.org
Back to top
View user's profile Send private message
Arithmomaniac
General User
General User


Joined: 30 May 2008
Posts: 9

PostPosted: Mon Jun 02, 2008 2:22 pm    Post subject: Reply with quote

Villeroy wrote:
2 columns of name and time do not provide enough information for a CUE sheet, if you mean http://en.wikipedia.org/wiki/Cue_sheet_%28computing%29
You should not let the readers find out what a CUE sheet is.


Thanks for the link to CUE sheets.

I can put "title", "performer" (at the top) and "file" manually.
"index" can be 01, then the time from the spreadsheet.
the 'title' can come from the spreadsheet.

I think that's all I need. Did I miss something?

Thanks,
Arithmomaniac
Back to top
View user's profile Send private message
David
Super User
Super User


Joined: 24 Oct 2003
Posts: 5668
Location: Canada

PostPosted: Mon Jun 02, 2008 4:48 pm    Post subject: Reply with quote

If so, isn't that a text file? Why use a spreadsheet? You might save as a tab delimited file and start again in a text editor or word processor?

David.
Back to top
View user's profile Send private message
Villeroy
Super User
Super User


Joined: 04 Oct 2004
Posts: 10106
Location: Germany

PostPosted: Mon Jun 02, 2008 5:16 pm    Post subject: Reply with quote

Try someting with INDEX(List;MOD(ROW();5)) or use the Online cue sheet compiler
_________________
Rest in peace, oooforum.org
Get help on https://forum.openoffice.org
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group