New AI ranking of goalies

 I rewrote the formula for goalie save percentage to generate the number of shots required to score a goal based on save percentage. 95% means a goal every 20 shots, 90% means a goal every 10 shots. 80% means a goal every 5 shots.

I made a few other tweaks.

Prompt

I am drafting two hockey goalies for a fantasy NHL draft. Ignore goalies with less than 20 games played. For each goalie in the NHL, obtain their goaltending statistics from the attached spreadsheet, which is from https://www.quanthockey.com/nhl/seasons/nhl-goalies-stats.html. Save percentage is worth 20%. For save percentage, we are actually evaluating the number of shots needed to score a goal. 95% means a goal every 20 shots, 90% means a goal every 10 shots. 80% means a goal every 5 shots.Use this formula: (1/(1 - save percentage)) * 20. Save percentage is a number less than one (e.g. 98.71% = 0.9871). Any numbers below zero count as zero. Games played is worth 40%. Take the number of games played, divide by 82 games, and multiply by 40 to get the number of points for this criteria. Wins are worth 20%. Use this formula: (wins/82) * 20. Shutouts are worth 20%. Use this formula: (shutouts/8)*20. Deliver the results in table format, sorted by total points ranking: [total points] [goalie name] [team][game played][games played points][shutouts] [shutout points] [save percentage] [save percentage points] [wins] [wins points]. Provide a downloadable table. List the top 20, sorted by total points ranking.

Results:

Total Points	Name	Team	GP	GP Points	SO	SO Points	SV%	SV Points	W	W Points
71.92	Connor Hellebuyck	WPG	63	30.73	8	20	0.92	266.67	47	11.46
67.78	Andrei Vasilevski	TBL	63	30.73	6	15	0.92	253.16	38	9.27
64.4	Darcy Kuemper	LAK	50	24.39	5	12.5	0.92	253.16	31	7.56
63.71	Anthony Stolarz	TOR	34	16.59	4	10	0.93	270.27	21	5.12
61.84	Filip Gustavsson	MIN	58	28.29	5	12.5	0.91	232.56	31	7.56
59.75	Mackenzie Blackwood	COL	56	27.32	4	10	0.91	227.27	28	6.83
58.38	Ilya Sorokin	NYI	61	29.76	4	10	0.91	215.05	30	7.32
58.32	Igor Shesterkin	NYR	61	29.76	6	15	0.9	210.53	27	6.59
58.03	Jake Oettinger	DAL	58	28.29	2	5	0.91	219.78	36	8.78
57.7	Dustin Wolf	CGY	53	25.85	3	7.5	0.91	222.22	29	7.07
57.2	Sergei Bobrovsky	FLA	54	26.34	5	12.5	0.91	212.77	33	8.05
56.01	Samuel Montembeault	MTL	62	30.24	4	10	0.9	202.02	31	7.56
55.99	Joey Daccord	SEA	57	27.8	2	5	0.91	212.77	27	6.59
55.87	Adin Hill	VGK	50	24.39	4	10	0.91	212.77	32	7.8
55.76	Linus Ullmark	OTT	44	21.46	4	10	0.91	219.78	25	6.1
55.35	Logan Thompson	WSH	43	20.98	2	5	0.91	222.22	31	7.56
54.75	Karel Vejmelka	UTA	58	28.29	1	2.5	0.9	208.33	26	6.34
54.01	Casey DeSmith	DAL	27	13.17	2	5	0.92	235.29	14	3.41
53.99	Kevin Lankinen	VAN	51	24.88	4	10	0.9	204.08	25	6.1
53.97	Joseph Woll	TOR	42	20.49	1	2.5	0.91	219.78	27	6.59