Pattern/Sequence of Numbers based on Ratio/Percentage

[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

 

[StephenCrump]

Can you please provide more examples?

Otherwise it's not clear from your single example what you're trying to do.

 

[artikyulashun]

A

B

C

Week 1

Week 2

MFG A

MFG B

MFG C

MFG A

MFG B

MFG C

MFG A

MFG B

MFG C

Bananas

.6

.2

.2

ON

Apples

.1

.4

.5

ON

Oranges

.3

.5

.2

ON

<tbody>
</tbody>

Columns A,B and C represent Percentage of Unit Volume by MFG for the Fruits to the left.

Using these numbers, I would like to generate a rotating 13-week promotional schedule for each item. Maximum number of weeks in a row that an MFG can have any one specific item on sale is two weeks. However, at the end of the of the 13-weeks, I'd like the number of instances that, for example, MFG A has Bananas on sale equal or near their share or .6.

My initial thought that you could use a ratio to create a patterned binary list of 1 and 0 or "on" and "off". Is it easier with these percentages? Perhaps this is simply a manual task.

Your feedback is appreciated.

 

[StephenCrump]

Reposted: https://www.mrexcel.com/forum/excel-questions/1032515-rotating-schedule-based-unit-volume-share.html