Load Planner Optimizer.xlsm

	A	B	C	E	F	G	H	I	J	K	S	T	U	AB	AC
1	Input Your Constraints			Week	Date	Load	Acute Load	Chronic Load	ACWR	Monotony		days
2	Input Your Constraints			Week	Date	Load	Acute Load	Chronic Load	ACWR	Monotony	Acute time constant:	7	0.25
3	Start Date			#N/A		2500	2500				Chronic time constant	28	0.07
4	Day 1 Chronic:			#N/A	12/31/1899	1800	2500	172	14.50	4.34
5	Max ACWR:	1.3		#N/A	1/1/1900	500	2325	285	8.17	1.58
6	Min ACWR:	0.8		#N/A	1/2/1900	700	1869	300	6.24	1.46				Date	Week
7	Max Chronic:	595		#N/A	1/3/1900	650	1577	327	4.82	1.40					Week 1
8	Readiness on Day 100:	75		#N/A	1/4/1900	0	1345	349	3.85	1.10				1/6/1900	Week 2
9	Max Monotony	2.00		#N/A	1/5/1900	0	1009	325	3.10	0.94				1/13/1900	Week 3
10	Minimum Daily Load	0		Week 2	1/6/1900	2500	757	303	2.50	0.94				1/20/1900	Week 4
11	Maximum Daily Load	2000		Week 2	1/7/1900	1800	1192	454	2.62	0.94
12				Week 2	1/8/1900	500	1344	547	2.46	0.94
13				Week 2	1/9/1900	700	1133	544	2.08	0.94
14	Calculation Checker			Week 2	1/10/1900	650	1025	555	1.85	0.94
15	Calculation Checker			Week 2	1/11/1900	0	931	561	1.66	0.94
16	Max ACWR:	14.50		Week 2	1/12/1900	0	698	523	1.34	0.94
17	Min ACWR:	0.23		Week 3	1/13/1900	2500	524	487	1.08	0.94
18	Max Chronic:	706		Week 3	1/14/1900	1800	1018	625	1.63	0.94
19	Readiness on Day 100:	302		Week 3	1/15/1900	500	1213	706	1.72	0.94
20	Max Monotony	#DIV/0!		Week 3	1/16/1900	700	1035	692	1.50	0.94
21	Minimum Daily Load	0		Week 3	1/17/1900	650	951	693	1.37	0.94
22	Maximum Daily Load	2500		Week 3	1/18/1900	0	876	690	1.27	0.94
23				Week 3	1/19/1900	0	657	642	1.02	0.94
24				Week 4	1/20/1900		493	598	0.82	0.92
25	Week	Total Load	% Change	Week 4	1/21/1900		370	557	0.66	1.07
26	Week 1	6150		Week 4	1/22/1900		277	518	0.53	0.86
27	Week 2	6150	0%	Week 4	1/23/1900		208	483	0.43	0.58
28	Week 3	6150	0%	Week 4	1/24/1900		156	449	0.35	#DIV/0!
29	Week 4	0	-100%	Week 4	1/25/1900		117	418	0.28	#DIV/0!
30	Total	18450		Week 4	1/26/1900		88	389	0.23	#DIV/0!
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100