Energy and Injury Spreadsheet

Not sure if the formulas will transfer properly, but here’s a tool to model different depletion rates for energy (plus half time and post match replenishment) and how this might impact on the likelihood of Injury (too high I think as currently modelled - even allowing for the fact that this player is being grossly overplayed).

		Energy start	1	2	3	4	5	6	7	H/T	8	9	10	11	12	13	14	End
Match 1	Player 1	100	97	94	91	88	85	82	79	89	86	83	80	77	74	71	68	83
Match 2	Player 1	83	80	77	74	71	68	65	62	72	69	66	63	60	57	54	51	66
Match 3	Player 1	66	63	60	57	54	51	48	45	55	52	49	46	43	40	37	34	49
New session	Player 1	49
	Min by min reduction	3
	H/T recovery	10
	P/M recovery	15
		Injury Risk
Match 1	Player 1	0	3	6	9	12	15	18	21	11	14	17	20	23	26	29	32	17
Match 2	Player 1	17	20	23	26	29	32	35	38	28	31	34	37	40	43	46	49	34
Match 3	Player 1	34	37	40	43	46	49	52	55	45	48	51	54	57	60	63	66	51
New session	Player 1	51
	Injury Risk	100