Home | News | Products | Support | Download | Sales | library | Guests | Contact | WebCam | Links
CDS Logo LanBox-Talk mail archive
 
By date: Prev | Next | Index By thread: Prev | Next | Index
Subject: [LCtalk] probably simple excel question
From: Jorg Schellekens
Date: Tue, 07 Dec 2004 15:35:11 +0100

Hi all,

Probably a very simple/stupid question, but I can't figure it out:

I have a theatre show for which I've made an Excel sheet with the contents of all cues, for reference of the shows light tech.

This is a simple sheet with 1 cue / memory per row, 1 dimmer channel per column, and all values in dimmer percentages (0-100%).

I'd like to import this show into LcEdit to be able to run it on a LanBox. And preferably without plotting all of the show from scratch.

Should be a piece of cake since the lay out of the Excel sheet is already similar to the LcEdit cue editor lay-out.
But of course the percentages need to be converted to DMX values (0-255).
So I guess I need to multiply all this stuff by 2.55, and after that convert everything to whole numbers.
But I just can't seem to get the right command to multiply every value in my cue/channel matrix by 2.55 in one single action.
Nonetheless I'm sure this is really easy to do, so hopefully someone will shed some light on this one (bad pun intended).

Regards,

Jorg Schellekens
By date: Prev | Next | Index By thread: Prev | Next | Index