Have formula repeat for a value in a cell then use a different formula for a value number of steps

[Tmoff]

I am quite new to some of excels formula and coding, and have been struggling to understand how to set up certain formula.
My current problem is that I have three cells which contain variables, the value of these variables is then used to fill cells. The three variables of concern are flow demand M1, batches/ hour, delivery time M1, and wish to have the values in these cells fill row F11:74 (1 minute to 60 minutes). Effectively I have managed to use formula to have these cells be filled for the demand over the delivery time, however if 2 batches were to occur in an hour I don't understand how to get the formula to repeat after the 10 minute delivery + the break between. I have attached a mini sheet to help articulate and illustrate my issue, if anyone can help I would appreciate it.

tank calc 2hr snapshot.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X
1	Input Tab
2
3	Mains water Temp (DegC)|		18		Flow Demand Mixer 1 (L)		100		Delivery time Mixer 1 (min)		10		Density (kg/m3)		997				Flow Demand (L/min)		10		Spacing Value	25
4
5	Initial tank temp (DegC)		10		Flow Demand Mixer 2 (L)		300		Delivery time Mixer 2 (min)		20		Set point of Heat exchanger (DegC)		2				Flow Demand (L/min)		15		Spacing Value	20
6
7	Initial tank level (L)		1200		Batches / hour Mixer 1		2		Flow from Mains		62.5
8
9	Constant circular flow (L/s)		50		Batches / hour Mixer 2		2		Specific Heat Capacity (kJ/kgDegC)		4.186
10
11	Mins	DegC	DegC	L	L	L/min	Kg/min	L/min	Kg/min	L/min	Kg/min	L/min	Kg/min	L/min	Kg/min	Kw
12	Time	Mains water temp	Tank temp	Tank level	Tank mass volume	Flow to M1	Mass flow M1	Flow to M2	Mass flow M2	Flow to HEX	Mass flow to HEX	Flow return tank	Mass flow return	Flow from mains	Mass flow mains	HEX duty
13	1	18	10	1200	1196.4	10	9.97	15	14.955	75	74.775	50	49.85	62.5	62.3125	41.73442
14	2	18	10.07407407	1237.5	1233.7875	10	9.97	15	14.955	75	74.775	50	49.85	62.5	62.3125	42.12084981
15	3	18	10.14014014	1275	1271.175	10	9.97	15	14.955	75	74.775	50	49.85	62.5	62.3125	42.46550343
16	4	18	10.19925188	1312.5	1308.5625	10	9.97	15	14.955	75	74.775	50	49.85	62.5	62.3125	42.77387772
17	5	18	10.25230088	1350	1345.95	10	9.97	15	14.955	75	74.775	50	49.85	62.5	62.3125	43.05062388
18	6	18	10.30004498	1387.5	1383.3375	10	9.97	15	14.955	75	74.775	50	49.85	62.5	62.3125	43.29969542
19	7	18	10.34313112	1425	1420.725	10	9.97	15	14.955	75	74.775	50	49.85	62.5	62.3125	43.5244673
20	8	18	10.38211382	1462.5	1458.1125	10	9.97	15	14.955	75	74.775	50	49.85	62.5	62.3125	43.72783234
21	9	18	10.41747022	1500	1495.5	10	9.97	15	14.955	75	74.775	50	49.85	62.5	62.3125	43.91227969
22	10	18	10.4496124	1537.5	1532.8875	10	9.97	15	14.955	75	74.775	50	49.85	62.5	62.3125	44.07995911
23	11	18	10.4788975	1575	1570.275	0	0	15	14.955	65	64.805	50	49.85	62.5	62.3125	38.33503586
24	12	18	10.50548196	1622.5	1617.6325	0	0	15	14.955	65	64.805	50	49.85	62.5	62.3125	38.45523027
25	13	18	10.52968015	1670	1664.99	0	0	15	14.955	65	64.805	50	49.85	62.5	62.3125	38.56463584
26	14	18	10.55176266	1717.5	1712.3475	0	0	15	14.955	65	64.805	50	49.85	62.5	62.3125	38.6644759
27	15	18	10.5719633	1765	1759.705	0	0	15	14.955	65	64.805	50	49.85	62.5	62.3125	38.75580761
28	16	18	10.59048492	1812.5	1807.0625	0	0	15	14.955	65	64.805	50	49.85	62.5	62.3125	38.83954812
29	17	18	10.60750416	1860	1854.42	0	0	15	14.955	65	64.805	50	49.85	62.5	62.3125	38.91649599
30	18	18	10.62317534	1907.5	1901.7775	0	0	15	14.955	65	64.805	50	49.85	62.5	62.3125	38.98734897
31	19	18	10.63763375	1955	1949.135	0	0	15	14.955	65	64.805	50	49.85	62.5	62.3125	39.05271878
32	20	18	10.65099839	2002.5	1996.4925	0	0	15	14.955	65	64.805	50	49.85	62.5	62.3125	39.11314335
33	21	18	10.6633742	2050	2043.85	0	0	0	0	50	49.85	50	49.85	62.5	62.3125	30.13007477
34	22	18	10.67477662	2112.5	2106.1625	0	0	0	0	50	49.85	50	49.85	62.5	62.3125	30.16973092
35	23	18	10.68530673	2175	2168.475	0	0	0	0	50	49.85	50	49.85	62.5	62.3125	30.20635326
36	24	18	10.69505269	2237.5	2230.7875	0	0	0	0	50	49.85	50	49.85	62.5	62.3125	30.2402484
37	25	18	10.70409168	2300	2293.1	0	0	0	0	50	49.85	50	49.85	62.5	62.3125	30.27168483
38	26	18	10.71249156	2362.5	2355.4125	0	0	0	0	50	49.85	50	49.85	62.5	62.3125	30.30089849
39	27	18	10.72031213	2425	2417.725	0	0	0	0	50	49.85	50	49.85	62.5	62.3125	30.3280974
40	28	18	10.72760631	2487.5	2480.0375	0	0	0	0	50	49.85	50	49.85	62.5	62.3125	30.35346563
41	29	18	10.73442107	2550	2542.35	0	0	0	0	50	49.85	50	49.85	62.5	62.3125	30.37716645
42	30	18	10.74079818	2612.5	2604.6625	0	0	0	0	50	49.85	50	49.85	62.5	62.3125	30.39934521
Sheet2 (3)

Cell Formulas
Range	Formula
U3,U5	U3	=G3/K3
X3,X5	X3	=(60-K3)/G7
B13:B42	B13	=$C$3
C13	C13	=C5
D13	D13	=C7
E13:E42,G13:G42,I13:I42,K13:K42,M13:M42,O13:O42	E13	=(D13/1000)*$O$3
F13:F42	F13	=IF(ROW(F13)<$K$3+13,IF(U$3>0,$U$3,""),"0")
H13:H42	H13	=IF(ROW(H13)<$K$5+13,IF(U$5>0,$U$5,""),"0")
J13:J42	J13	=$C$9+F13+H13
L13:L42	L13	=J13-H13-F13
N13:N42	N13	=$K$7
P13:P42	P13	=((K13/60)*$K$9*(C13-$O$5))
C14:C42	C14	=(((B14*O14*$K$9)+(C13*E14*$K$9)+($O$5*$K$9*M14))/((O14*$K$9)+(E14*$K$9)+(M14*$K$9)))
D14:D42	D14	=D13-(F13+H13)+N13

 

[Tmoff]

I no longer need a reply to this as I have found a formula which works.
=IF(MOD(A13, ROUNDDOWN(121/$G$7, 0))<$K$3, $G$3/$K$3, 0)