Phase 2 Swiss Calculator

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
1	ENTER NUMBERS HERE		Round 10			Round 11			Round 12			Round 13			Round 14
2	Match Points	# Going into Phase 2	Match Point	# at MP	Cumulative	Match Point	# at MP	Cumulative	Match Point	# at MP	Cumulative	Match Point	# at MP	Cumulative	Match Point	# at MP	Cumulative
3	27	3	30	1.17	1.17	33	0.4563	0.4563	36	0.1780	0.1780	39	0.0694	0.0694	42	0.02707	0.02707
4	26	0	29	0	1.17	32	0	0.4563	35	0.0000	0.1780	38	0.0000	0.0694	41	0.00000	0.02707
5	25	4	28	2.22	3.39	31	1.1232	1.5795	34	0.5384	0.7164	37	0.2491	0.3185	40	0.11243	0.13950
6	24	15	27	7.02	10.41	30	3.1941	4.7736	33	1.4237	2.1400	36	0.6246	0.9432	39	0.27067	0.41017
7	23	51	26	20.77	31.18	29	8.5887	13.3623	32	3.5967	5.7367	35	1.5212	2.4643	38	0.64807	1.05824
8	22	51	25	24.75	55.93	28	12.0627	25.425	31	5.8452	11.5819	34	2.8028	5.2672	37	1.32768	2.38592
9	21	452	24	193.35	249.28	27	82.7137	108.1387	30	35.3936	46.9755	33	15.1500	20.4171	36	6.48676	8.87268
10	20	23	23	40.08	289.36	26	29.1765	137.3152	29	17.3822	64.3577	32	9.4677	29.8849	35	4.90229	13.77497
11	19	650	22	373.83	663.19	25	197.9832	335.2984	28	100.1149	164.4726	31	49.1110	78.9959	34	23.57940	37.35437
12	18		21	181.34	844.53	24	154.9467	490.2451	27	99.1064	263.5790	30	56.2791	135.2750	33	29.94023	67.29460
13	17		20	151.97	996.5	23	157.1421	647.3872	26	116.2206	379.7996	29	74.1304	209.4053	32	43.40768	110.70228
14	16		19	252.5	1249	22	285.1635	932.5507	25	222.5155	602.3151	28	147.6293	357.0346	31	89.11011	199.81238
15	Total	1249	18	0	1249	21	104.156	1036.7067	24	135.6213	737.9364	27	117.1123	474.1469	30	83.93132	283.74371
16			17	0	1249	20	114.8183	1151.525	23	168.8005	906.7369	26	160.1116	634.2585	29	123.83282	407.57652
17	ENTER EVENT INFO BELOW		16	0	1249	19	97.475	1249	22	173.1433	1,079.8802	25	184.1436	818.4022	28	155.15614	562.73266
18	# of Players	5000				18	0	1249	21	65.8809	1,145.7611	24	115.7220	934.1241	27	126.02993	688.76260
19	Tie Rate	0.11				17	0	1249	20	66.2236	1,211.9848	23	129.7510	1,063.8751	26	153.55801	842.32060
20						16	0	1249	19	37.0153	1,249.0000	22	97.4556	1,161.3307	25	135.28255	977.60315
21	Notes:								18	0.0000	1,249.0000	21	40.2627	1,201.5935	24	89.37925	1066.98240
22	-Make a copy of this file to use it								17	0.0000	1,249.0000	20	33.9706	1,235.5641	23	85.29164	1152.27403
23	-Enter the number of players advancing to Phase 2 at each given match point in B3:B14								16	0.0000	1,249.0000	19	13.4359	1,249.0000	22	53.10552	1205.37955
24	-Enter the total division attendance and the expected tie rate for Phase 2 in B18:B19											18	0.0000	1,249.0000	21	23.17599	1228.55555
25	-Currently only works for events with > 256 players, more improvments on the way											17	0.0000	1,249.0000	20	16.20443	1244.75998
26	-Does not account for IDs, but assume Table 1 IDs in the final Swiss round, there are no trends for other tables											16	0.0000	1,249.0000	19	4.2400	1249.00000