Univers and Channels for pixels

[cfer]

Hi, I am wanting to put together a spreadsheet that will calculate my pixel led lights into universes.

Each Universe has 510 channels, each Universe increments by 1, you can hundreds of universes.

Headings will be

Channels used (A), start universe # (B), start channel # (C), end universe # (D), end channels # (E)

To start with I will start with Universe 1, Channel 1

So if I allocate 135 channels in cell A2

B2 = 1
C2 = 1
D2 = 1
E2 = 135

If I then allocate 380 channels to A3, then

B3 = 1
C3 = 136
D3 = 2
E3 = 5

The total amount for a Universe is 510, as I exceeded the 510 limit by 5, I have to increment to the next universe (2), and start at one again, as I have 5 channels left over, the end channel is 5.

If I then add another 200 channels, I would start at Universe 2, channel 6, ending universe 2, channel 205,

I need to keep this all the way down, the spread sheet.

Any suggestions very much appreciated

Cfer

 

[cfer]

Hi,

Thank you, I put it through some examples, and all worked, until I just put 510 in the first row of channels used, end channel shows 0, but should be 510.

Again excellent so far, are you able to have a look to see why it will not display 510 as the end channel.


Thanks Cfer

 

[FormR]

all worked, until I just put 510 in the first row of channels used, end channel shows 0, but should be 510.

Hi, sorry, I've been off grid for a week - not sure if you figured something out already, but if not you can try these adjustments to the formula in E2.

=MOD(SUM(A$2:A2)-1,510)+1

 

[cfer]

Hi FormR,

Excellent, it works, thanks for the time in helping me.

Cfer