Pattern/Sequence of Numbers based on Ratio/Percentage

Ciao All ~

Is it possible to generate / create a sequence of binary numbers, that cannot repeat more than twice, based on an entered ratio x:y? if not a ratio, than perhaps two percentages equal to 100%?

For example, a 2:1 ratio would generate a 12 cell pattern of : 1,1,0,1,1,0,1,1,0,1,1,0

Cheers in advance.

artikyulashun

Originally Posted by artikyulashun

Ciao All ~

Is it possible to generate / create a sequence of binary numbers, that cannot repeat more than twice, based on an entered ratio x:y? if not a ratio, than perhaps two percentages equal to 100%?

For example, a 2:1 ratio would generate a 12 cell pattern of : 1,1,0,1,1,0,1,1,0,1,1,0

Cheers in advance.

artikyulashun

Hi,
The binary code patter is fixed of 12 digits??? If yes the your second condition to get atmost 2 consecutive digits is not possible.
Need to have better understanding about what you are upto.....

To convert a decimal to binary use (in A10)

Formula:

Please Login or Register  to view this content.

where E5:G5 is the ratio
To verify that the converted decimal number allows you to form the default use

Formula:

Please Login or Register  to view this content.

See the file that also contains another solution for generating random patterns.

I'm trying to create a rotating weekly promotional calendar based on MFGs share of unit volume for a particular item. I was starting with the first 12 weeks, but it could just as easily be 52.

My initial thought was simply trying to create an "on/off" [ binary 1's and 0's ] pattern based on their ratio of unit volume.

Say you have 3 Manufacturers selling Bananas. MFG A has sold 60% of the unit volume over the past 52 weeks. MFG B 25% and MFG C 15%.

Based on their historical unit volume, MFG A could have Bananas on sale roughly 7 weeks, while MFG B 3 and MFG C 2.

Is it possible to create a formula that would generate an on/off pattern for these three companies? The hope is not to allow any one company to be on sale for more than two weeks.

Hope this clarifies.

Thank you Jose Augusto. Like what you've produced. I'll spend some time this morning trying to wrap my head around it and see if I can apply it to my problem.