Pro Golf Rankings Iron Championships, PGR Step by step calculation example

						Column	Column	Column	Step 1				Step	Step	Step	Step		Step	Step	Step	Step	Step	Step	Step		Step	Step	Step	Step	Step	Step
	Download Data					A	B	C	Step 1				2	3	4	5		6	7	8	9	10	11	12		13	14	15	16	17	18
	Feb 01, 2004 FBR Open					Final score of players CUT	Final Score of Players not cut	Determine number of rounds	Adjust each round for all players so that the best score for that rounf is:				For players qualified for final rounds, determine total score in final rounds only. .	Determine the maximum score in step 2 Finals group	Add Maximum score found in step 3 to:	Determine number of rounds not played by players cut		Add numbers from step 5	Put Final Group Column B numbers in space below.	Determine the maximum score in step 7	Put this score after name of each player in DQ Group	Determine number of rounds with no score for players in DQ Cut Group	Add number from step 10 DQ players	Put results from step 7 and step 11 in same column		Determine the lowest score in step 12.	Multiply the total number of rounds (column C) by 72	Subtract step 14 Final Group	Enter that number for all players.	Subtract this difference from all the scores in step 12	Divide Final score in step 17 by number of rounds
Player Groups	Round #'s	1	2	3	4			4	72				Add up final rounds (#3 and #4) in Finals group. put in step 2	Maximum = 170.	Column A numbers for CUT group.	and enter for each of players in CUT group		to totals in step 4 for CUT group	Put results from step 6 for cut Group in next space down	For both Final and Cut Group Maximum = 354		and enter for each of these players in DQ Cut Group	to totals in step 9 for DQ players			This is the wining score For Final Group	4 times 72 equals 288	from step 13 Final group	Final, CUT and DQ	This is final score used.	This is final average for each player
	These Players made the final round(s)																These Players made the final round(s)								These Players made the final round(s)
	Player 1	74	66	65	71		276		79	72	72	76	148				Player 1		299					299	Player 1	299	288	11	11	288	72.00
Finals	Player 2	67	67	74	68		276		72	73	81	73	154				Player 2		299					299	Player 2				11	288	72.00
	Player 69	68	77	69	69		283		73	83	76	74	150				Player 69		306					306	Player 69				11	295	73.75
	Player 70	75	73	79	79		306		80	79	86	84	170	170			Player 70		329					329	Player 70				11	318	79.50
	These Players failed to qualify : "CUT"																These Players failed to qualify								These Players failed to qualify
	Player 71	77	72			149									319	2	Player 71	321	321					321	Player 71				11	310	77.50
CUT	Player 72	77	73			150									320	2	Player 72	322	322					322	Player 72				11	311	77.75
	Player 129	80	72			152									322	2	Player 129	324	324					324	Player 129				11	313	78.25
	Player 130	93	89			182									352	2	Player 130	354	354	354				354	Player 130				11	343	85.75
	These Players were disqualified, withdrew or did not enter																These Players were disqualified, withdrew or did not enter								These Players were disqualified, withdrew or did not enter
DQ	Player 131																Player 131				354	2	356	356	Player 131				11	345	86.25
	Player 132																Player 136				354	2	356	356	Player 136				11	345	86.25
																						2								See why this is fair!