How to generate random events (active=1) and (idle=0) in the specified occurrences

[Mujubie717]

Hello Everyone,
Good morning/noon/evening,
In related inquiry to my previous thread,
I would like to ask for help with the following questions:
1. How to generate the random events (active and idle) within N (number of minutes), lets say 100 minutes (see my excel file)
2. From that N (number) preferred, the event should follow these requirements, i.e., 40% idle (which means 40 minutes in total) and 60% (which obviously means 60 minutes).
3. Within the 40% of idle events, these must be within a minimum of 5 minutes and maximum of 10 minutes, and in similar fashion for active events (of 60%), within minimum 10 minutes and maximum of 15 minutes

Again, much appreciation for your kindly help and precious efforts,
Thank you

 

[Mujubie717]

Hello Everyone,
Good morning/noon/evening,
In related inquiry to my previous thread,
I would like to ask for help with the following questions:
1. How to generate the random events (active and idle) within N (number of minutes), lets say 100 minutes (see my excel file)
2. From that N (number) preferred, the event should follow these requirements, i.e., 40% idle (which means 40 minutes in total) and 60% (which obviously means 60 minutes).
3. Within the 40% of idle events, these must be within a minimum of 5 minutes and maximum of 10 minutes, and in similar fashion for active events (of 60%), within minimum 10 minutes and maximum of 15 minutes

Again, much appreciation for your kindly help and precious efforts,
Thank you

ASK3.xlsx
	A	B	C	D	E	F
1		100	The preferred total event of Active [1] and Idle [0] - Setup
2
3		40	The Percentage of Idle time [0] - Setup
4		60	The Percentage of Active time [1] - Setup
5		10	The Maximum Idle time [0] setup in minutes - Setup
6		5	The Minimum Idle time [0] setup in minutes - Setup
7		15	The Maximum Active time [1] setup in minutes - Setup
8		10	The Minimum Active time [1] setup in minutes - Setup
9
10	1	0
11	2	0		Active [1]	60	MATCH
12	3	0		Idle [0]	40	MATCH
13	4	0
14	5	0
15	6	0
16	7	0
17	8	1
18	9	1
19	10	1
20	11	1
21	12	1
22	13	1
23	14	1
24	15	1
25	16	1
26	17	1
27	18	1
28	19	1
29	20	1
30	21	0
31	22	0
32	23	0
33	24	0
34	25	0
35	26	0
36	27	0
37	28	0
38	29	0
39	30	1
40	31	1
41	32	1
42	33	1
43	34	1
44	35	1
45	36	1
46	37	1
47	38	1
48	39	1
49	40	1
50	41	1
51	42	1
52	43	1
53	44	0
54	45	0
55	46	0
56	47	0
57	48	0
58	49	0
59	50	0
60	51	0
61	52	1
62	53	1
63	54	1
64	55	1
65	56	1
66	57	1
67	58	1
68	59	1
69	60	1
70	61	1
71	62	1
72	63	0
73	64	0
74	65	0
75	66	0
76	67	0
77	68	0
78	69	0
79	70	0
80	71	1
81	72	1
82	73	1
83	74	1
84	75	1
85	76	1
86	77	1
87	78	1
88	79	1
89	80	1
90	81	1
91	82	0
92	83	0
93	84	0
94	85	0
95	86	0
96	87	0
97	88	0
98	89	0
99	90	1
100	91	1
101	92	1
102	93	1
103	94	1
104	95	1
105	96	1
106	97	1
107	98	1
108	99	1
109	100	1
GENERATED EVENTS

Cell Formulas
Range	Formula
B4	B4	=B1-B3
E11	E11	=COUNTIF(B10:B109, "1")
F11	F11	=IF(E11=B4, "MATCH", "UNMATCH")
E12	E12	=COUNTIF(B10:B109, "0")
F12	F12	=IF(E12=B3, "MATCH", "UNMATCH")
A11:A109	A11	=A10+1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
E12	Cell Value	<>$B$3	text	NO
E11	Cell Value	<>$B$4	text	NO
B10:B48	Other Type	Color scale		NO
B49:B109	Other Type	Color scale		NO