Comish Dynasty Playoff Standings 2012 - Fantasy Sports Forums

temek · #1 04-27-2012, 09:06 AM

So I wanted to keep with the playoff situation and made a spreadsheet for myself. I am sure I am not the only who'd like to keep up the with standings daily so I might as well share with everyone else. Playoff standings are Chinny's responsibility, but I am sure he doesn't mind.

I made the spreadsheet using openoffice so it doesn't work correctly in excel.

Some instructions to use the spreadsheet.

1.Allow macros
2.Open the spreadsheet and select yes when it asks to update links(this step might freeze program up to a minute so just wait)
3.Click the Replace and Sort buttons and you should have your standings.

Current standings after 1st round of playoffs. Tier winners will pick before 5th overall anyway so it doesn't actually matter how they finish so 5th overall would go to The Comish currently and so on.

EDIT: found an error so had to update the standings and the spreadsheet

Code:

	Team			GP	G	A	+/-	PIM	PPP	SOG		G GP	W	GAA	SVS
															
Tier 1	Das Chicleteur		72	20	27	5	101	19	188		2	1	1,73	43
Tier 3	LU Timbersports		60	12	18	3	47	10	104		5	4	1,59	164
	The Comish		62	12	13	3	26	9	128		7	4	2,06	166
	jl67SixtyS ilverSevens	71	12	14	-8	45	3	138		7	4	1,7	205
	The Guru		73	7	19	-3	65	9	109		5	4	1,81	151
	Backmarkers		69	10	29	-5	40	20	145		3	1	2,35	81
	iamlilc			67	6	16	-7	88	7	124		7	3	2,14	191
	Nordique		61	10	11	7	54	6	120		6	4	3,89	142
	Bleedblue		69	10	21	0	61	14	116		0	0	100	0
Tier 2	Maroons			69	10	20	-20	57	12	160		0	0	100	0
	Great Wall of Chinny	40	6	8	-12	27	2	99		3	1	1,31	97
	UW Ain't Rad		46	6	8	-3	59	4	109		0	0	100	0

Code:

	Team				G	A	+/-	PIM	PPP	SOG		W	GAA	SVS		Total
																
Tier 1	Das Chicleteur			12	11	11	12	11	12		5	9	4		87
Tier 3	LU Timbersports			10	7	9,5	5	8	2		10	11	9		71,5
	The Comish			10	4	9,5	1	6,5	8		10	7	10		66
	jl67SixtyS ilverSevens		10	5	3	4	2	9		10	10	12		65
	The Guru			4	8	6,5	10	6,5	3,5		10	8	8		64,5
	Backmarkers			6,5	12	5	3	12	10		5	5	5		63,5
	iamlilc				2	6	4	11	5	7		7	6	11		59
	Nordique			6,5	3	12	6	4	6		10	4	7		58,5
	Bleedblue			6,5	10	8	9	10	5		2	2	2		54,5
Tier 2	Maroons				6,5	9	1	7	9	11		2	2	2		49,5
	Great Wall of Chinny		2	1,5	2	2	1	1	        5	12	6		32,5
	UW Ain't Rad			2	1,5	6,5	8	3	3,5		2	2	2		30,5

I assumed we have min GP 1 requirement for goalies so your team is ranked (tied) last if you goalie hasn't played a game. I also included G,A, PIM and PPP for goalies. All should be up-to-date, but keep me posted if you find errors.

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Fantasy Ranking

Login Form