Battlepass Calculator v1 13_MAR_2023

	A	B	D	E	F	G	H	J	K	L	M	N	P	Q	R	S	T	V
1	World of TanksBattlePass Completion Calculator
2	Enter Info in Yellow boxes only.		NOTE: CLICK {FILE} then {MAKE A COPY} and save to your own Drive folder to enable editing
3					Level by end of day					Level by end of day					Level by end of day			You can either just use the top section on the left and enter Start/end dates, and ensure Total points required is correct (usually 50pts per stage x 50 stages x 3 chapters = 7500). You can then select whether to inlcude the last day, reason this option exists is the last day in some timezones is only a few hours in the early morning so it essentially doesn't count. Then as you progress you have the option to use the middle section. Click the checkbox, enter a date and your progress up to that point, then choose a daily goal. Chart will now show you your new scheduled completion. The lower section is a guide to help you determine a daily goal
4	Start Day	5-Mar-2024	Day#	Date	Chap	Stg	+Pts	Day#	Date	Chap	Stg	Pts	Day#	Date	Chap	Stg	Pts
5	End Day	4-Jun-2024	1	Tue, Mar 5	1	1	33	33	Sat, Apr 6	2	4	39	65	Wed, May 8	3	7	45
6	Total Days	91	2	Wed, Mar 6	1	3	16	34	Sun, Apr 7	2	6	22	66	Thu, May 9	3	9	28
7	Inlcude Last day		3	Thu, Mar 7	1	4	49	35	Mon, Apr 8	2	8	5	67	Fri, May 10	3	11	11
8	Total Pts Req	7500	4	Fri, Mar 8	1	6	32	36	Tue, Apr 9	2	9	38	68	Sat, May 11	3	12	44
9	Daily Points Req	83	5	Sat, Mar 9	1	8	15	37	Wed, Apr 10	2	11	21	69	Sun, May 12	3	14	27
10	Today	23-Apr-2024	6	Sun, Mar 10	1	9	48	38	Thu, Apr 11	2	13	4	70	Mon, May 13	3	16	10
11	Click to use your progress/daily		7	Mon, Mar 11	1	11	31	39	Fri, Apr 12	2	14	37	71	Tue, May 14	3	17	43
12	Last Update		8	Tue, Mar 12	1	13	14	40	Sat, Apr 13	2	16	20	72	Wed, May 15	3	19	26
13	Remaining Days	↑enter date↑	9	Wed, Mar 13	1	14	47	41	Sun, Apr 14	2	18	3	73	Thu, May 16	3	21	9
14	Finished Chapters		10	Thu, Mar 14	1	16	30	42	Mon, Apr 15	2	19	36	74	Fri, May 17	3	22	42
15	Finished Stages		11	Fri, Mar 15	1	18	13	43	Tue, Apr 16	2	21	19	75	Sat, May 18	3	24	25
16	Current Points		12	Sat, Mar 16	1	19	46	44	Wed, Apr 17	2	23	2	76	Sun, May 19	3	26	8
17	Current Total Points	0	13	Sun, Mar 17	1	21	29	45	Thu, Apr 18	2	24	35	77	Mon, May 20	3	27	41
18	New Min Daily Req	179	14	Mon, Mar 18	1	23	12	46	Fri, Apr 19	2	26	18	78	Tue, May 21	3	29	24
19	Daily Avg Goal		15	Tue, Mar 19	1	24	45	47	Sat, Apr 20	2	28	1	79	Wed, May 22	3	31	7
20			16	Wed, Mar 20	1	26	28	48	Sun, Apr 21	2	29	34	80	Thu, May 23	3	32	40
21			17	Thu, Mar 21	1	28	11	49	Mon, Apr 22	2	31	17	81	Fri, May 24	3	34	23
22	These are guides to help you determine a daily goal		18	Fri, Mar 22	1	29	44	50	Tue, Apr 23	2	33	0	82	Sat, May 25	3	36	6
23	These are guides to help you determine a daily goal		19	Sat, Mar 23	1	31	27	51	Wed, Apr 24	2	34	33	83	Sun, May 26	3	37	39
24	Average Daily Missions		20	Sun, Mar 24	1	33	10	52	Thu, Apr 25	2	36	16	84	Mon, May 27	3	39	22
25	1st Daily (10)	1	21	Mon, Mar 25	1	34	43	53	Fri, Apr 26	2	37	49	85	Tue, May 28	3	41	5
26	2nd Daily(15)	1	22	Tue, Mar 26	1	36	26	54	Sat, Apr 27	2	39	32	86	Wed, May 29	3	42	38
27	3rd Daily(20)	0.75	23	Wed, Mar 27	1	38	9	55	Sun, Apr 28	2	41	15	87	Thu, May 30	3	44	21
28	Bonus Daily(25)	0.5	24	Thu, Mar 28	1	39	42	56	Mon, Apr 29	2	42	48	88	Fri, May 31	3	46	4
29	Est Avg Daily Mission Pts:	52.5	25	Fri, Mar 29	1	41	25	57	Tue, Apr 30	2	44	31	89	Sat, Jun 1	3	47	37
30	45 Mission completion		26	Sat, Mar 30	1	43	8	58	Wed, May 1	2	46	14	90	Sun, Jun 2	3	49	20
31	Premium	Yes	27	Sun, Mar 31	1	44	41	59	Thu, May 2	2	47	47	91	Mon, Jun 3	4	1	3
32	Est Missions per day	5	28	Mon, Apr 1	1	46	24	60	Fri, May 3	2	49	30	-	Tue, Jun 4	-	-	-
33	Max # of possible Completions	10	29	Tue, Apr 2	1	48	7	61	Sat, May 4	3	1	13	-	BP over	-	-	-
34	Avg Daily savings	5.6	30	Wed, Apr 3	1	49	40	62	Sun, May 5	3	2	46	-	-	-	-	-
35	Total est Daily Mission Pts	58	31	Thu, Apr 4	2	1	23	63	Mon, May 6	3	4	29	-	-	-	-	-
36			32	Fri, Apr 5	2	3	6	64	Tue, May 7	3	6	12	-	-	-	-	-
37
38