Summer-Olympics-2021

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AL	AM	AN	AO	AP	AQ	AR	AS	AT	AU	AV	AW	AX	AY	AZ	BA	BB	BC	BD	BE	BF	BG	BH	BI	BJ	BK	BL	BM	BN	BO	BP	BQ	BR	BS	BT	BU	BV	BW	BX	BY	BZ	CA	CB	CC	CD	CE	CF	CG	CH	CI
1	"Expert's" Predictions https://olympicmedalspredictions.com/medals.php						Budget: 911.50 Anything not in list is 0.50.		12	This table is filled in automatically by ImportHtml (cell J3) https://olympics.com/tokyo-2020/olympic-games/en/results/all-sports/medal-standings.htm or https://en.wikipedia.org/wiki/2020_Summer_Olympics_medal_table						100% Complete			Calls Javascript function.			Lengthen as needed, but don't edit (post the blue cells). If this doesn't seem to be keeping up, check out my website. It gets data from the official site with at most a 5-minute delay.									2021 Entries (fill yellow cells, green cells (cost) and blue cells (points) are computed)
2	Jul 5, 2021																		Optimal Team			Unsorted				2021 Standings					Oralloy	JPN	NED	FRA	HUN	NZL	KOR	ESP	BRA	CAN	TUR	IND	KEN	UKR	CUB	KAZ	GEO	AZE	SLO	HKG	TUN
3	Country	Gold	Silver	Bronze	Total	Cost	NOC	Cost	NOC	Rank	Team	Gold	Silver	Bronze	Total	Score	Cost	ROI	NOC	Score	Cost	1	Oralloy	14	911.50	1	George	249	909.00	249-909	911.50	159.00	99.00	86.00	58.00	57.00	57.00	57.00	43.00	41.00	38.00	37.00	35.00	35.00	34.00	20.00	18.00	18.00	12.00	7.00	0.50
4	United States (USA)	49	28	29	106	358	USA	358.00		1	United States	39	41	33	113	351			Total	0	0	2	lmur	0	911.50	2	markr	14	911.00	14-911	14	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	14	0
5	China (CHN)	42	33	17	92	326	CHN	326.00		2	China	38	32	18	88	304						3	fbaezer	0	911.50	3	Oralloy	14	911.50	14-911.5	lmur	USA	GBR	GER	FRA	KOR	JAM	KEN	KAZ	AZE	RSA	THA	ARG	FIJ	JOR	PUR	CIV	LTU	SVK	VIE
6	(ROC)	27	25	18	70	228	ROC	228.00		3	Japan*	27	14	17	58	194						4	tgordon92	0	911.50	3	Ecartmill	14	911.50	14-911.5	911.50	358.00	165.00	106.00	86.00	57.00	36.00	35.00	20.00	18.00	9.00	8.00	7.00	1.00	1.00	1.00	1.00	1.00	1.00	0.50
7	Great Britain (GBR)	21	13	21	55	165	GBR	165.00		4	Great Britain	22	21	22	65	195						5	McGentrix	0	911.00	5	ehBeth	0	907.00	0-907	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
8	Japan (JPN)*	16	21	16	53	159	JPN	159.00	ROC	5	ROC	20	28	23	71	207	228.00	-21.0				6	ehBeth	0	907.00	6	Skin Rip	0	910.00	0-910	fbaezer	CHN	JPN	AUS	GER	ITA	KEN	UKR	MAS	ECU	MEX	FIN	MDA
9	Australia (AUS)	14	17	14	45	135	AUS	135.00		6	Australia	17	7	22	46	128						7	Skin Rip	0	910.00	7	McGentrix	0	911.00	0-911	911.50	326.00	159.00	135.00	106.00	99.00	35.00	35.00	6.00	6.00	3.00	1.00	0.50
10	Germany (GER)	15	3	22	40	106	GER	106.00		7	Netherlands	10	12	14	36	100						8	Ecartmill	14	911.50	8	lmur	0	911.50	0-911.5	0	0	0	0	0	0	0	0	0	0	0	0	0
11	Netherlands (NED)	10	14	7	31	99	NED	99.00		8	France	10	12	11	33	97						9	Ticomaya	0	911.50	8	fbaezer	0	911.50	0-911.5	tgordon92	JPN	GER	NED	FRA	KOR	BRA	CAN	UKR	SRB	CRO	KAZ	COL	AZE	GEO	POR	ROU	IRL	GRE	SLO	RSA	INA	BUL	ARG	ECU	MAS	VEN	GRN	QAT	ALG	MAR	KOS	MGL	MEX	FIJ	LTU	CYP	CIV	EGY	MKD	FIN	PUR	BER	BUR	SGP	VIE	TKM	MDA	NIG
12	Italy (ITA)	7	15	19	41	99	ITA	99.00		9	Germany	10	11	16	37	99						10	wheel158	0	911.50	8	tgordon92	0	911.50	0-911.5	911.50	159.00	106.00	99.00	86.00	57.00	43.00	41.00	35.00	35.00	21.00	20.00	19.00	18.00	18.00	16.00	14.00	14.00	13.00	12.00	9.00	9.00	8.00	7.00	6.00	6.00	5.00	5.00	4.00	3.00	3.00	3.00	3.00	3.00	1.00	1.00	1.00	1.00	1.00	1.00	1.00	1.00	0.50	0.50	0.50	0.50	0.50	0.50	0.50
13	France (FRA)	10	6	18	34	86	FRA	86.00		10	Italy	10	10	20	40	100						11	markr	14	911.00	8	Ticomaya	0	911.50	0-911.5	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
14	Poland (POL)	6	7	12	25	63	POL	63.00		11	Canada	7	6	11	24	64						12	George	249	909.00	8	wheel158	0	911.50	0-911.5	McGentrix	GBR	JPN	GER	NED	FRA	KOR	BRA	CAN	JAM	BEL	SUI	UZB	GEO	RSA	ARG	QAT
15	Hungary (HUN)	8	5	3	16	58	HUN	58.00		12	Brazil	7	6	8	21	61						13		0	0.00					-	911.00	165.00	159.00	106.00	99.00	86.00	57.00	43.00	41.00	36.00	28.00	27.00	26.00	18.00	9.00	7.00	4.00
16	New Zealand (NZL)	8	4	5	17	57	NZL	57.00		13	New Zealand	7	6	7	20	60						14	#ap	0	911.50					-	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
17	South Korea (KOR)	4	8	13	25	57	KOR	57.00		14	Cuba	7	3	5	15	49						15	#bs	14	911.00					-	ehBeth	USA	JPN	GER	NZL	CAN	JAM	KEN	SWE	DEN	ETH	EST	LAT	MGL	MEX	MAR	LTU	FIN	EGY	PUR
18	Spain (ESP)	2	13	8	23	57	ESP	57.00		15	Hungary	6	7	7	20	58						16	#gn	0	909.00					-	907.00	358.00	159.00	106.00	57.00	41.00	36.00	35.00	35.00	30.00	26.00	8.00	3.00	3.00	3.00	3.00	1.00	1.00	1.00	1.00
19	Brazil (BRA)*	6	3	4	13	43	BRA	43.00		16	South Korea	6	4	10	20	52															0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
20	Canada (CAN)	4	2	15	21	41	CAN	41.00		17	Poland	4	5	5	14	40															Skin Rip	GBR	GER	ITA	FRA	HUN	KOR	CAN	KEN	DEN	SUI	UZB	CRO	KAZ	COL	IRI	ROU	GRE	SLO	RSA	INA	BRN	THA	EST	ARG	MAS	VEN	GRN
21	Turkey (TUR)	4	4	6	14	38	TUR	38.00		18	Czech Republic	4	4	3	11	35															910.00	165.00	106.00	99.00	86.00	58.00	57.00	41.00	35.00	30.00	27.00	26.00	21.00	20.00	19.00	15.00	14.00	13.00	12.00	9.00	9.00	9.00	8.00	8.00	7.00	6.00	5.00	5.00
22	India (IND)	3	5	7	15	37	IND	37.00		19	Kenya	4	4	2	10	34															0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
23	Jamaica (JAM)	3	6	3	12	36	JAM	36.00		20	Norway	4	2	2	8	28															Ecartmill	USA	JPN	AUS	GER	CAN	CUB	KEN	ROU	SLO	RSA	HKG	MNE	COD
24	Kenya (KEN)	5	2	4	11	35	KEN	35.00		21	Jamaica	4	1	4	9	27															911.50	358.00	159.00	135.00	106.00	41.00	34.00	35.00	14.00	12.00	9.00	7.00	1.00	0.50
25	Serbia (SRB)	4	4	3	11	35	SRB	35.00		22	Spain	3	8	6	17	45															14	0	0	0	0	0	0	0	0	0	0	14	0	0
26	Ukraine (UKR)	3	4	8	15	35	UKR	35.00		23	Sweden	3	6	0	9	33															Ticomaya	USA	JPN	ITA	FRA	KOR	CAN	IND	JAM	KEN	NGR	SVK	LIE
27	Sweden (SWE)	2	6	7	15	35	SWE	35.00		24	Switzerland	3	4	6	13	33															911.50	358.00	159.00	99.00	86.00	57.00	41.00	37.00	36.00	35.00	2.00	1.00	0.50
28	Cuba (CUB)	3	6	1	10	34	CUB	34.00		25	Denmark	3	4	4	11	31															0	0	0	0	0	0	0	0	0	0	0	0	0
29	Czech Republic (CZE)	5	2	0	7	31	CZE	31.00		26	Croatia	3	3	2	8	26															wheel158	USA	JPN	NED	FRA	KOR	IND	CUB	CRO	NOR	IRL	SLO	VEN	QAT	MAR	LTU	FIJ	SVK	EGY	BOT	BUR	SMR	TTO	VIE
30	Chinese Taipei (TPE)	4	3	1	8	30	TPE	30.00		27	Iran	3	2	2	7	23															911.50	358.00	159.00	99.00	86.00	57.00	37.00	34.00	21.00	16.00	14.00	12.00	5.00	4.00	3.00	1.00	1.00	1.00	1.00	0.50	0.50	0.50	0.50	0.50
31	Denmark (DEN)	2	6	2	10	30	DEN	30.00		28	Serbia	3	1	5	9	23															0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
32	Belgium (BEL)	3	3	4	10	28	BEL	28.00		29	Belgium	3	1	3	7	21															markr	JPN	NED	FRA	HUN	KOR	BRA	CAN	JAM	KEN	UKR	CUB	BEL	SUI	CRO	KAZ	AZE	NOR	IRL	SLO	UGA	RSA	BUL	ARG	HKG	ECU	VEN	QAT	MAR	NGR	LTU	CIV	SVK	CYP	FIJ	EGY	BUR	SMR	BER	DOM	VIE	MDA	TTO	SYR	SGP	BOT
33	Switzerland (SUI)	3	3	3	9	27	SUI	27.00		30	Bulgaria	3	1	2	6	20															911.00	159.00	99.00	86.00	58.00	57.00	43.00	41.00	36.00	35.00	35.00	34.00	28.00	27.00	21.00	20.00	18.00	16.00	14.00	12.00	10.00	9.00	8.00	7.00	7.00	6.00	5.00	4.00	3.00	2.00	1.00	1.00	1.00	1.00	1.00	1.00	0.50	0.50	0.50	0.50	0.50	0.50	0.50	0.50	0.50	0.50
34	Belarus (BLR)	2	4	5	11	27	BLR	27.00		31	Slovenia	3	1	1	5	19															14	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	14	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
35	Uzbekistan (UZB)	3	2	5	10	26	UZB	26.00		32	Uzbekistan	3	0	2	5	17															George	CHN	ROC	JPN	KOR	IND	TPE	KAZ	IRI	BRN	THA	HKG	MAS	QAT	BAN	JOR	KUW
36	Ethiopia (ETH)	2	5	1	8	26	ETH	26.00		33	Georgia	2	5	1	8	26															909.00	326.00	228.00	159.00	57.00	37.00	30.00	20.00	15.00	9.00	8.00	7.00	6.00	4.00	1.00	1.00	1.00
37	Croatia (CRO)	2	2	5	9	21	CRO	21.00	TPE	34	Chinese Taipei	2	4	6	12	28	30.00	-2.0													249	0	207	0	0	0	28	0	0	0	0	14	0	0	0	0	0
38	Kazakhstan (KAZ)	1	2	9	12	20	KAZ	20.00		35	Turkey	2	2	9	13	25
39	Colombia (COL)	1	3	5	9	19	COL	19.00		36	Greece	2	1	1	4	14															0.00
40	Georgia (GEO)	3	0	3	6	18	GEO	18.00			Uganda	2	1	1	4	14															0
41	Azerbaijan (AZE)	1	4	1	6	18	AZE	18.00		38	Ecuador	2	1	0	3	13															#ap	USA	JPN	NED	KOR	IND	JAM	KEN	CUB	CRO	NOR	IRL	SLO	ECU	KGZ	VEN	QAT	MAR	NGR	EGY	FIJ	LTU	SVK	SMR	VIE	BUR	BOT	TTO	DOM	MDA	SYR	ZAM
42	Norway (NOR)	2	1	3	6	16	NOR	16.00		39	Ireland	2	0	2	4	12															911.50	358.00	159.00	99.00	57.00	37.00	36.00	35.00	34.00	21.00	16.00	14.00	12.00	6.00	5.00	5.00	4.00	3.00	2.00	1.00	1.00	1.00	1.00	0.50	0.50	0.50	0.50	0.50	0.50	0.50	0.50	0.50
43	Portugal (POR)	1	3	2	6	16	POR	16.00			Israel	2	0	2	4	12															0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
44	Iran (IRI)	2	0	5	7	15	IRI	15.00		41	Qatar	2	0	1	3	11															#bs	JPN	NED	FRA	KOR	BRA	CAN	SWE	UKR	CUB	BEL	SUI	CRO	KAZ	COL	AZE	GEO	POR	IRL	ROU	GRE	SLO	UGA	INA	RSA	BUL	ARG	HKG	ECU	MAS	GRN	VEN	QAT	ALG	KOS	MGL	MAR	CYP	EGY	FIN	CIV	LTU	MKD	PUR	SVK	ALB	BER	BUR	CRC	DOM	MDA	NIG	PER	SGP	SYR	TKM	VIE
45	Philippines (PHI)	2	1	1	4	14	PHI	14.00		42	Bahamas	2	0	0	2	10															911.00	159.00	99.00	86.00	57.00	43.00	41.00	35.00	35.00	34.00	28.00	27.00	21.00	20.00	19.00	18.00	18.00	16.00	14.00	14.00	13.00	12.00	10.00	9.00	9.00	8.00	7.00	7.00	6.00	6.00	5.00	5.00	4.00	3.00	3.00	3.00	3.00	1.00	1.00	1.00	1.00	1.00	1.00	1.00	1.00	0.50	0.50	0.50	0.50	0.50	0.50	0.50	0.50	0.50	0.50	0.50	0.50
46	Ireland (IRL)	2	1	1	4	14	IRL	14.00			Kosovo	2	0	0	2	10															14	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	14	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
47	Romania (ROU)	0	4	2	6	14	ROU	14.00		44	Ukraine	1	6	12	19	35															#gn	JPN	NED	FRA	HUN	NZL	KOR	ESP	BRA	CAN	TUR	IND	KEN	UKR	SWE	CUB	KAZ	GEO
48	Greece (GRE)	2	0	3	5	13	GRE	13.00		45	Belarus	1	3	3	7	17															909.00	159.00	99.00	86.00	58.00	57.00	57.00	57.00	43.00	41.00	38.00	37.00	35.00	35.00	35.00	34.00	20.00	18.00
49	Israel (ISR)	1	2	2	5	13	ISR	13.00		46	Romania	1	3	0	4	14															0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
50	Armenia (ARM)	1	2	2	5	13	ARM	13.00			Venezuela	1	3	0	4	14
51	Slovenia (SLO)	2	0	2	4	12	SLO	12.00		48	India	1	2	4	7	15
52	Bahamas (BAH)	2	0	0	2	10	BAH	10.00	HKG	49	Hong Kong	1	2	3	6	14	7.00	7.0
53	Uganda (UGA)	2	0	0	2	10	UGA	10.00		50	Philippines	1	2	1	4	12
54	Indonesia (INA)	1	1	1	3	9	INA	9.00			Slovakia	1	2	1	4	12
55	Bahrain (BRN)	1	1	1	3	9	BRN	9.00		52	South Africa	1	2	0	3	11
56	South Africa (RSA)	0	2	3	5	9	RSA	9.00		53	Austria	1	1	5	7	13
57	Austria (AUT)	0	2	3	5	9	AUT	9.00		54	Egypt	1	1	4	6	12
58	Thailand (THA)	1	1	0	2	8	THA	8.00		55	Indonesia	1	1	3	5	11
59	Bulgaria (BUL)	0	2	2	4	8	BUL	8.00		56	Ethiopia	1	1	2	4	10
60	Estonia (EST)	0	2	2	4	8	EST	8.00			Portugal	1	1	2	4	10
61	Argentina (ARG)	0	2	1	3	7	ARG	7.00		58	Tunisia	1	1	0	2	8
62	Hong Kong, China (HKG)	0	2	1	3	7	HKG	7.00		59	Estonia	1	0	1	2	6
63	Malaysia (MAS)	0	2	0	2	6	MAS	6.00			Fiji	1	0	1	2	6
64	Ecuador (ECU)	0	2	0	2	6	ECU	6.00			Latvia	1	0	1	2	6
65	Kyrgyzstan (KGZ)	1	0	0	1	5	KGZ	5.00			Thailand	1	0	1	2	6
66	North Korea (PRK)	1	0	0	1	5	PRK	5.00		63	Bermuda	1	0	0	1	5
67	Venezuela (VEN)	1	0	0	1	5	VEN	5.00			Morocco	1	0	0	1	5
68	Grenada (GRN)	1	0	0	1	5	GRN	5.00			Puerto Rico	1	0	0	1	5
69	Qatar (QAT)	0	1	1	2	4	QAT	4.00		66	Colombia	0	4	1	5	13
70	Latvia (LAT)	0	1	0	1	3	LAT	3.00		67	Azerbaijan	0	3	4	7	13
71	Algeria (ALG)	0	1	0	1	3	ALG	3.00		68	Dominican Republic	0	3	2	5	11
72	Bosnia and Herzegovina (BIH)	0	1	0	1	3	BIH	3.00		69	Armenia	0	2	2	4	8
73	Kosovo (KOS)	0	0	3	3	3	KOS	3.00		70	Kyrgyzstan	0	2	1	3	7
74	Mongolia (MGL)	0	0	3	3	3	MGL	3.00		71	Mongolia	0	1	3	4	6
75	Mexico (MEX)	0	0	3	3	3	MEX	3.00		72	Argentina	0	1	2	3	5
76	Morocco (MAR)	0	0	3	3	3	MAR	3.00			San Marino	0	1	2	3	5
77	Chile (CHI)	0	0	2	2	2	CHI	2.00		74	Jordan	0	1	1	2	4
78	Nigeria (NGR)	0	0	2	2	2	NGR	2.00			Malaysia	0	1	1	2	4
79	Cyprus (CYP)	0	0	1	1	1	CYP	1.00			Nigeria	0	1	1	2	4
80	Bangladesh (BAN)	0	0	1	1	1	BAN	1.00		77	Bahrain	0	1	0	1	3
81	Jordan (JOR)	0	0	1	1	1	JOR	1.00			Lithuania	0	1	0	1	3
82	Ivory Coast (CIV)	0	0	1	1	1	CIV	1.00			Namibia	0	1	0	1	3
83	Fiji (FIJ)	0	0	1	1	1	FIJ	1.00			North Macedonia	0	1	0	1	3
84	Kuwait (KUW)	0	0	1	1	1	KUW	1.00			Saudi Arabia	0	1	0	1	3
85	Lithuania (LTU)	0	0	1	1	1	LTU	1.00			Turkmenistan	0	1	0	1	3
86	North Macedonia (MKD)	0	0	1	1	1	MKD	1.00		83	Kazakhstan	0	0	8	8	8
87	Montenegro (MNE)	0	0	1	1	1	MNE	1.00		84	Mexico	0	0	4	4	4
88	Finland (FIN)	0	0	1	1	1	FIN	1.00		85	Finland	0	0	2	2	2
89	Slovakia (SVK)	0	0	1	1	1	SVK	1.00		86	Botswana	0	0	1	1	1
90	Egypt (EGY)	0	0	1	1	1	EGY	1.00			Burkina Faso	0	0	1	1	1
91	Puerto Rico (PUR)	0	0	1	1	1	PUR	1.00			Ghana	0	0	1	1	1
92	Namibia (NAM)	0	0	1	1	1	NAM	1.00			Grenada	0	0	1	1	1
93											Ivory Coast	0	0	1	1	1
94											Kuwait	0	0	1	1	1
95											Moldova	0	0	1	1	1
96											Syria	0	0	1	1	1
97										Totals (93 teams)		340	338	402	1080	3116
98
99
100