Excel formulas for DMX 512

[Jeffl]

I'm trying to get my channels worked out so that I can get them hooked easier for my helpers and my sanity.  I'm a LOR user and I can open the sequence channel export and get a fairly nice output in excel.  I have been able to come up with a formula to translate the channel# to the LOR Unit ID. 

LOR Unit ID = =DEC2HEX((ROUNDUP(Channel#/16,0)),2)

Channel                            Channel Type     Channel #     Universe  LOR Unit ID
12 MegaTree 5 - White   DMX Universe   17               1              02
12 MegaTree 5 - Red           DMX Universe   18               1              02
12 MegaTree 5 - Green   DMX Universe   19               1              02
12 MegaTree 6 - White   DMX Universe   20               1              02
12 MegaTree 6 - Red           DMX Universe   21               1              02

What I'm trying to come up with now is the DMX channel # converted to LE plug #:

Channel 17 = LE plug 1
Channel 32 = LE plug 16

Any thoughts would be helpful so I don't have to redo it by hand each time I change channels.

Thanks

[kgustafson]

jeffl,

Look into modulus arithmetic.

=IF(MOD(A1,16)=0,16,MOD(A1,16))

A1 would hold the channel value (17 = 1, 32=16, 20=4, etc.)

The reason for the IF logic is that when the modulus 16 hits 16, 32, 48, 64, etc. it will = 0, however, we want it to be 16 when this case hits.

Kurt

[jnealand]

Here is my excel spreadsheet from 2010, before I started adding all the thousands of smart string channels.  I used this to generate vixen labels and lor labels and kept a copy handy when I was doing setup and troubleshooting.  There is nothing proprietary in there so I am passing it along.

Enjoy

[Jeffl]

Thanks for the help.  I'll try out the suggestions tonight.  I new there were individuals out there that were way smarter than I.

[Jeffl]

This will make DMX easy which is what I wanted.  Formula looks to work like a charm.  So many people far smarter than I.   I like it.

[joeengler]

Jeff,

Any way you might also share your spreadsheet so we can get a look at what you did also.

[Jeffl]

Yes.  I'll take a look tonight.  PM me if I forget.