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]

[TABLE="class: grid, width: 1000"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD][/TD]
[TD]Week 1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Week 2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]MFG A[/TD]
[TD]MFG B[/TD]
[TD]MFG C[/TD]
[TD][/TD]
[TD="align: center"]MFG A[/TD]
[TD="align: center"]MFG B[/TD]
[TD="align: center"]MFG C[/TD]
[TD][/TD]
[TD="align: center"]MFG A[/TD]
[TD="align: center"]MFG B[/TD]
[TD="align: center"]MFG C[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Bananas[/TD]
[TD].6[/TD]
[TD].2[/TD]
[TD].2[/TD]
[TD][/TD]
[TD="align: center"]ON[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Apples[/TD]
[TD].1[/TD]
[TD].4[/TD]
[TD].5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: center"]ON[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Oranges[/TD]
[TD].3[/TD]
[TD].5[/TD]
[TD].2[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: center"]ON[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

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