WG Week in Review Correction: 2009 vs 2003A

As I mentioned in my previous post, the calculation for determining the Goal WΔ was incorrect for comparing 2009 entries to 2003A, and as a result, the amount any particular week was ahead or behind was off (stat showed me more behind than reality). I've gone back and recalculated for each week of the year, and have displayed the wrong and the corrected numbers here:

01/01/2012 - 01/07/2012
							Wrong						Corrected
	SoY	SoW	EoW	WΔ	YΔ			WΔ	YΔ	WvG	DvG			WΔ	YΔ	WvG	DvG
2003A	3603	3603	3611	8	8		Goal	46	46	-18	-18		Goal	46	46	-18	-18
2009	1339	1339	1375	36	036		Actual	28	028				Actual	28	028

01/08/2012 - 01/14/2012
							Wrong						Corrected
	SoY	SoW	EoW	WΔ	YΔ			WΔ	YΔ	WvG	DvG			WΔ	YΔ	WvG	DvG
2003A	3603	3611	3616	5	13		Goal	37	82	-5	-22		Goal	36	82	-4	-22
2009	1339	1375	1412	37	073		Actual	32	060				Actual	32	060

01/15/2012 - 01/21/2012
							Wrong						Corrected
	SoY	SoW	EoW	WΔ	YΔ			WΔ	YΔ	WvG	DvG			WΔ	YΔ	WvG	DvG
2003A	3603	3616	3623	7	20		Goal	51	131	-8	-28		Goal	49	131	-6	-28
2009	1339	1412	1462	50	123		Actual	43	103				Actual	43	103

01/22/2012 - 01/28/2012
							Wrong						Corrected
	SoY	SoW	EoW	WΔ	YΔ			WΔ	YΔ	WvG	DvG			WΔ	YΔ	WvG	DvG
2003A	3603	3623	3624	1	21		Goal	41	169	+14	-11		Goal	39	169	+16	-11
2009	1339	1462	1518	56	179		Actual	55	158				Actual	55	158

01/29/2012 - 02/04/2012
							Wrong						Corrected
	SoY	SoW	EoW	WΔ	YΔ			WΔ	YΔ	WvG	DvG			WΔ	YΔ	WvG	DvG
2003A	3603	3624	3633	9	30		Goal	51	217	-5	-13		Goal	48	217	-2	-13
2009	1339	1518	1573	55	234		Actual	46	204				Actual	46	204

02/05/2012 - 02/11/2012
							Wrong						Corrected
	SoY	SoW	EoW	WΔ	YΔ			WΔ	YΔ	WvG	DvG			WΔ	YΔ	WvG	DvG
2003A	3603	3633	3643	10	40		Goal	53	265	+3	-5		Goal	48	265	+8	-5
2009	1339	1573	1639	66	300		Actual	56	260				Actual	56	260

02/12/2012 - 02/18/2012
							Wrong						Corrected
	SoY	SoW	EoW	WΔ	YΔ			WΔ	YΔ	WvG	DvG			WΔ	YΔ	WvG	DvG
2003A	3603	3643	3644	1	41		Goal	43	303	+18	+18		Goal	38	303	+23	+18
2009	1339	1639	1701	62	362		Actual	61	321				Actual	61	321

The incorrect formula was calculating the delta needed assuming that I needed to make up the year's difference in the bills I still needed to enter starting this week to meet my year's entry goal. So for this week, it was calculating that I needed to cover the year's 2,264 bill deficient (2009 vs 2003A) in the 4,415 bills I had left to enter for this year. As such, as it week went by, the calculation would be more and more off.

Now that it's fixed, you can add the weekly difference to last week's overall difference and obtain this week's overall difference (+/- 1 since fractional bills are rounded). The overall numbers were calculated separately (and correctly), so they were right, so I always knew where I was at with the goal. I only had the wrong information regarding how the week's entries had done.