Trouble recognizing varying revenue on a monthly basis - formula wrong.

[scott_bassman]

<!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--> I have included below a spreadsheet. The formulas are not correct, and I have no idea how to correct them. We have a, "start date" for opportunities - this could be any point within a given month. So, if it's a three month project and it starts on 4/15/2013 we would recognize ~half a month of revenue for that April, a full month for May, June, and ~half a month for July, making a total of 3 months. The formulas that are there do not account for this, and say for, "Line 8" they don't do what I need in the above. The different amounts do add up to the correct, "$500,000," but it's not calculating the correct amounts monthly. Can someone PLEASE help me figure this out? I would like to get the formula right for say, line 8, and apply that formula to the rest of the spreadsheet (if possible). Thanks! Also, I'm using MS Excel 2013, and Windows 8.

Excel 2012

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R
Total

<tbody>
[TD="align: center"]1[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #00B050, align: right"] 90[/TD]
[TD="align: right"] 108,382[/TD]
[TD="align: right"] 161,273[/TD]
[TD="align: right"] 290,960[/TD]
[TD="align: right"] 323,454[/TD]
[TD="align: right"] 173,281[/TD]
[TD="align: right"] 12,738[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]

[TD="align: center"]2[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #FFC000, align: right"] 75[/TD]
[TD="align: right"] 168,065[/TD]
[TD="align: right"] 226,896[/TD]
[TD="align: right"] 241,513[/TD]
[TD="align: right"] 171,093[/TD]
[TD="align: right"] 127,545[/TD]
[TD="align: right"] 67,437[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]

[TD="align: center"]3[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #FFFF00, align: right"] 50[/TD]
[TD="align: right"] 43,548[/TD]
[TD="align: right"] 938,602[/TD]
[TD="align: right"] 513,364[/TD]
[TD="align: right"] 218,192[/TD]
[TD="align: right"] 149,087[/TD]
[TD="align: right"] 117,316[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]

[TD="align: center"]4[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"][/TD]
[TD="align: right"][/TD]

[TD="align: right"] 319,995[/TD]
[TD="align: right"] 1,588,815[/TD]
[TD="align: right"] 1,704,288[/TD]
[TD="align: right"] 1,661,016[/TD]
[TD="align: right"] 1,129,683[/TD]
[TD="align: right"] 813,339[/TD]
[TD="align: right"] 350,373[/TD]
[TD="align: right"] 264,204[/TD]
[TD="align: right"] 201,300[/TD]
[TD="align: right"] -[/TD]

[TD="align: center"]5[/TD]
[TD="align: center"]Created Date[/TD]
[TD="align: center"]Opportunity Name[/TD]
[TD="align: center"]Probability (%)[/TD]
[TD="align: center"]Close Date[/TD]
[TD="align: center"]Start Date[/TD]
[TD="align: center"]Project Duration[/TD]
[TD="align: center"] Amount[/TD]
[TD="align: right"][/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]13[/TD]

[TD="align: center"]6[/TD]
[TD="align: right"]3/14/2013[/TD]
[TD="align: right"][/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]3/22/2013[/TD]
[TD="align: right"]4/1/2013[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]6500[/TD]
[TD="align: right"][/TD]
[TD="align: right"] 6,500[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]

[TD="align: center"]7[/TD]
[TD="align: right"]3/17/2013[/TD]
[TD="align: right"][/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]3/29/2013[/TD]
[TD="align: right"]4/19/2013[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]15000[/TD]
[TD="align: right"][/TD]
[TD="align: right"] 6,290[/TD]
[TD="align: right"] 8,710[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]

[TD="align: center"]8[/TD]
[TD="align: right"]2/15/2013[/TD]
[TD="align: right"][/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]3/29/2013[/TD]
[TD="align: right"]4/15/2013[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]500000[/TD]
[TD="align: right"][/TD]
[TD="align: right"] 91,398[/TD]
[TD="align: right"] 136,201[/TD]
[TD="align: right"] 136,201[/TD]
[TD="align: right"] 136,201[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]

[TD="align: center"]9[/TD]
[TD="align: right"]2/28/2013[/TD]
[TD="align: right"][/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]4/17/2013[/TD]
[TD="align: right"]5/15/2013[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]38500[/TD]
[TD="align: right"][/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] 10,556[/TD]
[TD="align: right"] 13,972[/TD]
[TD="align: right"] 13,972[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]

[TD="align: center"]10[/TD]
[TD="align: right"]2/27/2013[/TD]
[TD="align: right"][/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]3/29/2013[/TD]
[TD="align: right"]4/19/2013[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]10000[/TD]
[TD="align: right"][/TD]
[TD="align: right"] 4,194[/TD]
[TD="align: right"] 5,806[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]

[TD="align: center"]11[/TD]
[TD="align: right"]2/18/2013[/TD]
[TD="align: right"][/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]5/6/2013[/TD]
[TD="align: right"]6/24/2013[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]66300[/TD]
[TD="align: right"][/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] 8,555[/TD]
[TD="align: right"] 28,873[/TD]
[TD="align: right"] 28,873[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]

[TD="align: center"]12[/TD]
[TD="align: right"]2/28/2013[/TD]
[TD="align: right"][/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]5/31/2013[/TD]
[TD="align: right"]6/10/2013[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]345000[/TD]
[TD="align: right"][/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] 122,419[/TD]
[TD="align: right"] 111,290[/TD]
[TD="align: right"] 111,290[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]

[TD="align: center"]13[/TD]
[TD="align: right"]2/18/2013[/TD]
[TD="align: right"][/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]5/31/2013[/TD]
[TD="align: right"]6/24/2013[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]29250[/TD]
[TD="align: right"][/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] 3,774[/TD]
[TD="align: right"] 12,738[/TD]
[TD="align: right"] 12,738[/TD]
[TD="align: right"] 12,738[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]

[TD="align: center"]14[/TD]
[TD="align: right"]2/18/2013[/TD]
[TD="align: right"][/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]4/30/2013[/TD]
[TD="align: right"]6/24/2013[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]46800[/TD]
[TD="align: right"][/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] 6,039[/TD]
[TD="align: right"] 20,381[/TD]
[TD="align: right"] 20,381[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]

[TD="align: center"]15[/TD]
[TD="align: right"]2/21/2013[/TD]
[TD="align: right"][/TD]
[TD="align: right"]75[/TD]
[TD="align: right"]3/29/2013[/TD]
[TD="align: right"]4/22/2013[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]50000[/TD]
[TD="align: right"][/TD]
[TD="align: right"] 16,129[/TD]
[TD="align: right"] 33,871[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]

[TD="align: center"]16[/TD]
[TD="align: right"]3/14/2013[/TD]
[TD="align: right"][/TD]
[TD="align: right"]75[/TD]
[TD="align: right"]4/5/2013[/TD]
[TD="align: right"]4/8/2013[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]150000[/TD]
[TD="align: right"][/TD]
[TD="align: right"] 116,129[/TD]
[TD="align: right"] 33,871[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]

[TD="align: center"]17[/TD]
[TD="align: right"]2/18/2013[/TD]
[TD="align: right"][/TD]
[TD="align: right"]75[/TD]
[TD="align: right"]4/26/2013[/TD]
[TD="align: right"]5/10/2013[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]265000[/TD]
[TD="align: right"][/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] 20,896[/TD]
[TD="align: right"] 67,437[/TD]
[TD="align: right"] 67,437[/TD]
[TD="align: right"] 67,437[/TD]
[TD="align: right"] 67,437[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]

[TD="align: center"]18[/TD]
[TD="align: right"]2/28/2013[/TD]
[TD="align: right"][/TD]
[TD="align: right"]75[/TD]
[TD="align: right"]4/26/2013[/TD]
[TD="align: right"]5/17/2013[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]215000[/TD]
[TD="align: right"][/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] 34,677[/TD]
[TD="align: right"] 60,108[/TD]
[TD="align: right"] 60,108[/TD]
[TD="align: right"] 60,108[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]

[TD="align: center"]19[/TD]
[TD="align: right"]3/21/2013[/TD]
[TD="align: right"][/TD]
[TD="align: right"]75[/TD]
[TD="align: right"]6/3/2013[/TD]
[TD="align: right"]6/3/2013[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]50000[/TD]
[TD="align: right"][/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] 46,774[/TD]
[TD="align: right"] 3,226[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]

[TD="align: center"]20[/TD]
[TD="align: right"]11/28/2012[/TD]
[TD="align: right"][/TD]
[TD="align: right"]75[/TD]
[TD="align: right"]5/15/2013[/TD]
[TD="align: right"]6/26/2013[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]50000[/TD]
[TD="align: right"][/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] 9,677[/TD]
[TD="align: right"] 40,323[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]

[TD="align: center"]21[/TD]
[TD="align: right"]1/2/2013[/TD]
[TD="align: right"][/TD]
[TD="align: right"]75[/TD]
[TD="align: right"]4/30/2013[/TD]
[TD="align: right"]5/6/2013[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]10000[/TD]
[TD="align: right"][/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] 8,387[/TD]
[TD="align: right"] 1,613[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]

[TD="align: center"]22[/TD]
[TD="align: right"]1/2/2013[/TD]
[TD="align: right"][/TD]
[TD="align: right"]75[/TD]
[TD="align: right"]4/30/2013[/TD]
[TD="align: right"]5/6/2013[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]7000[/TD]
[TD="align: right"][/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] 5,871[/TD]
[TD="align: right"] 1,129[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]

[TD="align: center"]23[/TD]
[TD="align: right"]1/2/2013[/TD]
[TD="align: right"][/TD]
[TD="align: right"]75[/TD]
[TD="align: right"]4/30/2013[/TD]
[TD="align: right"]5/6/2013[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]30000[/TD]
[TD="align: right"][/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] 25,161[/TD]
[TD="align: right"] 4,839[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]

[TD="align: center"]24[/TD]
[TD="align: right"]1/2/2013[/TD]
[TD="align: right"][/TD]
[TD="align: right"]75[/TD]
[TD="align: right"]4/30/2013[/TD]
[TD="align: right"]5/6/2013[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]21000[/TD]
[TD="align: right"][/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] 17,613[/TD]
[TD="align: right"] 3,387[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]

[TD="align: center"]25[/TD]
[TD="align: right"]3/27/2013[/TD]
[TD="align: right"][/TD]
[TD="align: right"]75[/TD]
[TD="align: right"]4/5/2013[/TD]
[TD="align: right"]4/22/2013[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]111000[/TD]
[TD="align: right"][/TD]
[TD="align: right"] 35,806[/TD]
[TD="align: right"] 46,548[/TD]
[TD="align: right"] 46,548[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]

[TD="align: center"]26[/TD]
[TD="align: right"]3/25/2013[/TD]
[TD="align: right"][/TD]
[TD="align: right"]50[/TD]
[TD="align: right"]4/15/2013[/TD]
[TD="align: right"]4/22/2013[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]35000[/TD]
[TD="align: right"][/TD]
[TD="align: right"] 11,290[/TD]
[TD="align: right"] 23,710[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]

[TD="align: center"]27[/TD]
[TD="align: right"]2/21/2013[/TD]
[TD="align: right"][/TD]
[TD="align: right"]50[/TD]
[TD="align: right"]4/30/2013[/TD]
[TD="align: right"]5/1/2013[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]500000[/TD]
[TD="align: right"][/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] 125,000[/TD]
[TD="align: right"] 93,750[/TD]
[TD="align: right"] 93,750[/TD]
[TD="align: right"] 93,750[/TD]
[TD="align: right"] 93,750[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]

[TD="align: center"]28[/TD]
[TD="align: right"]2/28/2013[/TD]
[TD="align: right"][/TD]
[TD="align: right"]50[/TD]
[TD="align: right"]4/30/2013[/TD]
[TD="align: right"]5/10/2013[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]65000[/TD]
[TD="align: right"][/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] 15,376[/TD]
[TD="align: right"] 16,541[/TD]
[TD="align: right"] 16,541[/TD]
[TD="align: right"] 16,541[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]

[TD="align: center"]29[/TD]
[TD="align: right"]3/9/2013[/TD]
[TD="align: right"][/TD]
[TD="align: right"]50[/TD]
[TD="align: right"]6/3/2013[/TD]
[TD="align: right"]7/8/2013[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]76900[/TD]
[TD="align: right"][/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] 29,768[/TD]
[TD="align: right"] 23,566[/TD]
[TD="align: right"] 23,566[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]

[TD="align: center"]30[/TD]
[TD="align: right"]3/11/2013[/TD]
[TD="align: right"][/TD]
[TD="align: right"]50[/TD]
[TD="align: right"]5/20/2013[/TD]
[TD="align: right"]5/20/2013[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]100000[/TD]
[TD="align: right"][/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] 38,710[/TD]
[TD="align: right"] 61,290[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]

[TD="align: center"]31[/TD]
[TD="align: right"]2/27/2013[/TD]
[TD="align: right"][/TD]
[TD="align: right"]50[/TD]
[TD="align: right"]5/17/2013[/TD]
[TD="align: right"]5/1/2013[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]200000[/TD]
[TD="align: right"][/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] 100,000[/TD]
[TD="align: right"] 50,000[/TD]
[TD="align: right"] 50,000[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]

[TD="align: center"]32[/TD]
[TD="align: right"]4/1/2013[/TD]
[TD="align: right"][/TD]
[TD="align: right"]50[/TD]
[TD="align: right"]5/15/2013[/TD]
[TD="align: right"]6/3/2013[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]24500[/TD]
[TD="align: right"][/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] 11,460[/TD]
[TD="align: right"] 6,520[/TD]
[TD="align: right"] 6,520[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]

[TD="align: center"]33[/TD]
[TD="align: right"]3/6/2013[/TD]
[TD="align: right"][/TD]
[TD="align: right"]50[/TD]
[TD="align: right"]5/6/2013[/TD]
[TD="align: right"]4/30/2013[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]500000[/TD]
[TD="align: right"][/TD]
[TD="align: right"] 32,258[/TD]
[TD="align: right"] 467,742[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]

[TD="align: center"]34[/TD]
[TD="align: right"]3/14/2013[/TD]
[TD="align: right"][/TD]
[TD="align: right"]50[/TD]
[TD="align: right"]5/1/2013[/TD]
[TD="align: right"]5/13/2013[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]125000[/TD]
[TD="align: right"][/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] 76,613[/TD]
[TD="align: right"] 48,387[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]

[TD="align: center"]35[/TD]
[TD="align: right"]2/21/2013[/TD]
[TD="align: right"][/TD]
[TD="align: right"]50[/TD]
[TD="align: right"]4/30/2013[/TD]
[TD="align: right"]5/17/2013[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]150000[/TD]
[TD="align: right"][/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] 72,581[/TD]
[TD="align: right"] 77,419[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]

[TD="align: center"]36[/TD]
[TD="align: right"]2/18/2013[/TD]
[TD="align: right"][/TD]
[TD="align: right"]50[/TD]
[TD="align: right"]4/30/2013[/TD]
[TD="align: right"]6/5/2013[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]100000[/TD]
[TD="align: right"][/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] 87,097[/TD]
[TD="align: right"] 12,903[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]

[TD="align: center"]37[/TD]
[TD="align: right"]3/14/2013[/TD]
[TD="align: right"][/TD]
[TD="align: right"]50[/TD]
[TD="align: right"]4/22/2013[/TD]
[TD="align: right"]5/6/2013[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]30000[/TD]
[TD="align: right"][/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] 12,581[/TD]
[TD="align: right"] 8,710[/TD]
[TD="align: right"] 8,710[/TD]
[TD="align: right"] 8,710[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]

[TD="align: center"]38[/TD]
[TD="align: right"]3/19/2013[/TD]
[TD="align: right"][/TD]
[TD="align: right"]50[/TD]
[TD="align: right"]4/23/2013[/TD]
[TD="align: right"]5/29/2013[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]65000[/TD]
[TD="align: right"][/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] 6,290[/TD]
[TD="align: right"] 58,710[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]

[TD="align: center"]39[/TD]
[TD="align: right"]3/9/2013[/TD]
[TD="align: right"][/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]4/26/2013[/TD]
[TD="align: right"]5/29/2013[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]50000[/TD]
[TD="align: right"][/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] 2,419[/TD]
[TD="align: right"] 23,790[/TD]
[TD="align: right"] 23,790[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]

[TD="align: center"]40[/TD]
[TD="align: right"]2/28/2013[/TD]
[TD="align: right"][/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]4/26/2013[/TD]
[TD="align: right"]5/10/2013[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]215000[/TD]
[TD="align: right"][/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] 50,860[/TD]
[TD="align: right"] 54,713[/TD]
[TD="align: right"] 54,713[/TD]
[TD="align: right"] 54,713[/TD]
[TD="align: right"] 54,713[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]

[TD="align: center"]41[/TD]
[TD="align: right"]2/18/2013[/TD]
[TD="align: right"][/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]4/26/2013[/TD]
[TD="align: right"]5/10/2013[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]40000[/TD]
[TD="align: right"][/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] 14,194[/TD]
[TD="align: right"] 12,903[/TD]
[TD="align: right"] 12,903[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]

[TD="align: center"]42[/TD]
[TD="align: right"]2/28/2013[/TD]
[TD="align: right"][/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]4/26/2013[/TD]
[TD="align: right"]5/17/2013[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]215000[/TD]
[TD="align: right"][/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] 34,677[/TD]
[TD="align: right"] 60,108[/TD]
[TD="align: right"] 60,108[/TD]
[TD="align: right"] 60,108[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]

[TD="align: center"]43[/TD]
[TD="align: right"]3/13/2013[/TD]
[TD="align: right"][/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]7/18/2013[/TD]
[TD="align: right"]8/26/2013[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]265000[/TD]
[TD="align: right"][/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] 12,823[/TD]
[TD="align: right"] 63,044[/TD]
[TD="align: right"] 63,044[/TD]
[TD="align: right"] 63,044[/TD]
[TD="align: right"] 63,044[/TD]
[TD="align: right"] -[/TD]

[TD="align: center"]44[/TD]
[TD="align: right"]3/14/2013[/TD]
[TD="align: right"][/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]7/17/2013[/TD]
[TD="align: right"]8/5/2013[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]65000[/TD]
[TD="align: right"][/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] 56,613[/TD]
[TD="align: right"] 8,387[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]

[TD="align: center"]45[/TD]
[TD="align: right"]3/14/2013[/TD]
[TD="align: right"][/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]7/1/2013[/TD]
[TD="align: right"]7/31/2013[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]100000[/TD]
[TD="align: right"][/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] 3,226[/TD]
[TD="align: right"] 96,774[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]

[TD="align: center"]46[/TD]
[TD="align: right"]3/11/2013[/TD]
[TD="align: right"][/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]6/28/2013[/TD]
[TD="align: right"]7/12/2013[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]25000[/TD]
[TD="align: right"][/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] 8,065[/TD]
[TD="align: right"] 8,468[/TD]
[TD="align: right"] 8,468[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]

[TD="align: center"]47[/TD]
[TD="align: right"]3/14/2013[/TD]
[TD="align: right"][/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]6/26/2013[/TD]
[TD="align: right"]7/1/2013[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]100000[/TD]
[TD="align: right"][/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] 100,000[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]

[TD="align: center"]48[/TD]
[TD="align: right"]3/21/2013[/TD]
[TD="align: right"][/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]6/21/2013[/TD]
[TD="align: right"]7/19/2013[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]35000[/TD]
[TD="align: right"][/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] 7,339[/TD]
[TD="align: right"] 13,831[/TD]
[TD="align: right"] 13,831[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]

[TD="align: center"]49[/TD]
[TD="align: right"]3/14/2013[/TD]
[TD="align: right"][/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]6/19/2013[/TD]
[TD="align: right"]7/1/2013[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]150000[/TD]
[TD="align: right"][/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] 150,000[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]

[TD="align: center"]50[/TD]
[TD="align: right"]3/21/2013[/TD]
[TD="align: right"][/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]6/18/2013[/TD]
[TD="align: right"]6/28/2013[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]265000[/TD]
[TD="align: right"][/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] 8,548[/TD]
[TD="align: right"] 64,113[/TD]
[TD="align: right"] 64,113[/TD]
[TD="align: right"] 64,113[/TD]
[TD="align: right"] 64,113[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]

[TD="align: center"]51[/TD]
[TD="align: right"]2/18/2013[/TD]
[TD="align: right"][/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]6/14/2013[/TD]
[TD="align: right"]7/29/2013[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]50000[/TD]
[TD="align: right"][/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] 4,839[/TD]
[TD="align: right"] 45,161[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]

[TD="align: center"]52[/TD]
[TD="align: right"]3/14/2013[/TD]
[TD="align: right"][/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]10/1/2013[/TD]
[TD="align: right"]10/14/2013[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]150000[/TD]
[TD="align: right"][/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] 87,097[/TD]
[TD="align: right"] 62,903[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]

[TD="align: center"]53[/TD]
[TD="align: right"]3/21/2013[/TD]
[TD="align: right"][/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]9/30/2013[/TD]
[TD="align: right"]10/11/2013[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]35000[/TD]
[TD="align: right"][/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] 11,855[/TD]
[TD="align: right"] 11,573[/TD]
[TD="align: right"] 11,573[/TD]
[TD="align: right"] -[/TD]

[TD="align: center"]54[/TD]
[TD="align: right"]3/11/2013[/TD]
[TD="align: right"][/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]9/27/2013[/TD]
[TD="align: right"]10/18/2013[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]25000[/TD]
[TD="align: right"][/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] 5,645[/TD]
[TD="align: right"] 9,677[/TD]
[TD="align: right"] 9,677[/TD]
[TD="align: right"] -[/TD]

[TD="align: center"]55[/TD]
[TD="align: right"]3/14/2013[/TD]
[TD="align: right"][/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]8/21/2013[/TD]
[TD="align: right"]8/30/2013[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]150000[/TD]
[TD="align: right"][/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] 9,677[/TD]
[TD="align: right"] 140,323[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]

[TD="align: center"]56[/TD]
[TD="align: right"]3/14/2013[/TD]
[TD="align: right"][/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]8/5/2013[/TD]
[TD="align: right"]9/2/2013[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]50000[/TD]
[TD="align: right"][/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] 48,387[/TD]
[TD="align: right"] 1,613[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]

[TD="align: center"]57[/TD]
[TD="align: right"]3/21/2013[/TD]
[TD="align: right"][/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]7/19/2013[/TD]
[TD="align: right"]8/9/2013[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]265000[/TD]
[TD="align: right"][/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] 49,153[/TD]
[TD="align: right"] 53,962[/TD]
[TD="align: right"] 53,962[/TD]
[TD="align: right"] 53,962[/TD]
[TD="align: right"] 53,962[/TD]
[TD="align: right"] -[/TD]

[TD="align: center"]58[/TD]
[TD="align: right"]3/13/2013[/TD]
[TD="align: right"][/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]7/18/2013[/TD]
[TD="align: right"]8/26/2013[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]265000[/TD]
[TD="align: right"][/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] 12,823[/TD]
[TD="align: right"] 63,044[/TD]
[TD="align: right"] 63,044[/TD]
[TD="align: right"] 63,044[/TD]
[TD="align: right"] 63,044[/TD]
[TD="align: right"] -[/TD]

[TD="align: center"]59[/TD]
[TD="align: right"]3/14/2013[/TD]
[TD="align: right"][/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]6/10/2013[/TD]
[TD="align: right"]7/1/2013[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]30000[/TD]
[TD="align: right"][/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] 30,000[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]

[TD="align: center"]60[/TD]
[TD="align: right"]3/23/2013[/TD]
[TD="align: right"][/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]6/10/2013[/TD]
[TD="align: right"]6/24/2013[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]60000[/TD]
[TD="align: right"][/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] 15,484[/TD]
[TD="align: right"] 44,516[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]

[TD="align: center"]61[/TD]
[TD="align: right"]3/13/2013[/TD]
[TD="align: right"][/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]6/3/2013[/TD]
[TD="align: right"]7/17/2013[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]85000[/TD]
[TD="align: right"][/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] 20,565[/TD]
[TD="align: right"] 32,218[/TD]
[TD="align: right"] 32,218[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]

[TD="align: center"]62[/TD]
[TD="align: right"]3/21/2013[/TD]
[TD="align: right"][/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]5/30/2013[/TD]
[TD="align: right"]6/28/2013[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]40000[/TD]
[TD="align: right"][/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] 2,581[/TD]
[TD="align: right"] 18,710[/TD]
[TD="align: right"] 18,710[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]

[TD="align: center"]63[/TD]
[TD="align: right"]3/11/2013[/TD]
[TD="align: right"][/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]5/30/2013[/TD]
[TD="align: right"]6/10/2013[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]200000[/TD]
[TD="align: right"][/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] 141,935[/TD]
[TD="align: right"] 58,065[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]

[TD="align: center"]64[/TD]
[TD="align: right"]3/11/2013[/TD]
[TD="align: right"][/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]5/30/2013[/TD]
[TD="align: right"]6/14/2013[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]30000[/TD]
[TD="align: right"][/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] 8,710[/TD]
[TD="align: right"] 10,645[/TD]
[TD="align: right"] 10,645[/TD]
[TD="align: right"] 10,645[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]

[TD="align: center"]65[/TD]
[TD="align: right"]3/11/2013[/TD]
[TD="align: right"][/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]5/30/2013[/TD]
[TD="align: right"]6/14/2013[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]40000[/TD]
[TD="align: right"][/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] 11,613[/TD]
[TD="align: right"] 14,194[/TD]
[TD="align: right"] 14,194[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]

[TD="align: center"]66[/TD]
[TD="align: right"]3/21/2013[/TD]
[TD="align: right"][/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]5/24/2013[/TD]
[TD="align: right"]6/14/2013[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]50000[/TD]
[TD="align: right"][/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] 14,516[/TD]
[TD="align: right"] 17,742[/TD]
[TD="align: right"] 17,742[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]

[TD="align: center"]67[/TD]
[TD="align: right"]3/11/2013[/TD]
[TD="align: right"][/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]5/24/2013[/TD]
[TD="align: right"]6/14/2013[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]25000[/TD]
[TD="align: right"][/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] 7,258[/TD]
[TD="align: right"] 8,871[/TD]
[TD="align: right"] 8,871[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]

[TD="align: center"]68[/TD]
[TD="align: right"]3/11/2013[/TD]
[TD="align: right"][/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]5/23/2013[/TD]
[TD="align: right"]6/24/2013[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]75000[/TD]
[TD="align: right"][/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] 9,677[/TD]
[TD="align: right"] 32,661[/TD]
[TD="align: right"] 32,661[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]

[TD="align: center"]69[/TD]
[TD="align: right"]3/14/2013[/TD]
[TD="align: right"][/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]5/15/2013[/TD]
[TD="align: right"]5/30/2013[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]100000[/TD]
[TD="align: right"][/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] 6,452[/TD]
[TD="align: right"] 93,548[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]

[TD="align: center"]70[/TD]
[TD="align: right"]11/28/2012[/TD]
[TD="align: right"][/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]5/15/2013[/TD]
[TD="align: right"]6/24/2013[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]20000[/TD]
[TD="align: right"][/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] 5,161[/TD]
[TD="align: right"] 14,839[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]

[TD="align: center"]71[/TD]
[TD="align: right"]11/28/2012[/TD]
[TD="align: right"][/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]5/15/2013[/TD]
[TD="align: right"]6/24/2013[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]50000[/TD]
[TD="align: right"][/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] 12,903[/TD]
[TD="align: right"] 37,097[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]

[TD="align: center"]72[/TD]
[TD="align: right"]3/23/2013[/TD]
[TD="align: right"][/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]5/13/2013[/TD]
[TD="align: right"]5/20/2013[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]40000[/TD]
[TD="align: right"][/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] 15,484[/TD]
[TD="align: right"] 24,516[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]

[TD="align: center"]73[/TD]
[TD="align: right"]3/13/2013[/TD]
[TD="align: right"][/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]5/3/2013[/TD]
[TD="align: right"]6/17/2013[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]15195[/TD]
[TD="align: right"][/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] 3,676[/TD]
[TD="align: right"] 5,759[/TD]
[TD="align: right"] 5,759[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]

[TD="align: center"]74[/TD]
[TD="align: right"]3/11/2013[/TD]
[TD="align: right"][/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]5/1/2013[/TD]
[TD="align: right"]5/3/2013[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]20000[/TD]
[TD="align: right"][/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] 18,710[/TD]
[TD="align: right"] 1,290[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]

[TD="align: center"]75[/TD]
[TD="align: right"]2/18/2013[/TD]
[TD="align: right"][/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]4/30/2013[/TD]
[TD="align: right"]5/10/2013[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]50000[/TD]
[TD="align: right"][/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] 17,742[/TD]
[TD="align: right"] 16,129[/TD]
[TD="align: right"] 16,129[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]

[TD="align: center"]76[/TD]
[TD="align: right"]3/11/2013[/TD]
[TD="align: right"][/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]4/30/2013[/TD]
[TD="align: right"]5/17/2013[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]35000[/TD]
[TD="align: right"][/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] 8,468[/TD]
[TD="align: right"] 13,266[/TD]
[TD="align: right"] 13,266[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]

[TD="align: center"]77[/TD]
[TD="align: right"]3/11/2013[/TD]
[TD="align: right"][/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]4/30/2013[/TD]
[TD="align: right"]5/17/2013[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]40000[/TD]
[TD="align: right"][/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] 9,677[/TD]
[TD="align: right"] 15,161[/TD]
[TD="align: right"] 15,161[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]

[TD="align: center"]78[/TD]
[TD="align: right"]3/11/2013[/TD]
[TD="align: right"][/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]4/30/2013[/TD]
[TD="align: right"]5/21/2013[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]35000[/TD]
[TD="align: right"][/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] 6,210[/TD]
[TD="align: right"] 14,395[/TD]
[TD="align: right"] 14,395[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]

[TD="align: center"]79[/TD]
[TD="align: right"]3/11/2013[/TD]
[TD="align: right"][/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]4/30/2013[/TD]
[TD="align: right"]5/17/2013[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]50000[/TD]
[TD="align: right"][/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] 12,097[/TD]
[TD="align: right"] 18,952[/TD]
[TD="align: right"] 18,952[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]

[TD="align: center"]80[/TD]
[TD="align: right"]2/28/2013[/TD]
[TD="align: right"][/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]4/26/2013[/TD]
[TD="align: right"]5/10/2013[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]215000[/TD]
[TD="align: right"][/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] 50,860[/TD]
[TD="align: right"] 54,713[/TD]
[TD="align: right"] 54,713[/TD]
[TD="align: right"] 54,713[/TD]
[TD="align: right"] 54,713[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]

[TD="align: center"]81[/TD]
[TD="align: right"]3/21/2013[/TD]
[TD="align: right"][/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]4/29/2013[/TD]
[TD="align: right"]5/10/2013[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]40000[/TD]
[TD="align: right"][/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] 14,194[/TD]
[TD="align: right"] 12,903[/TD]
[TD="align: right"] 12,903[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]

[TD="align: center"]82[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]

[TD="align: center"]83[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]

[TD="align: center"]84[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]

[TD="align: center"]85[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]

[TD="align: center"]86[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]

[TD="align: center"]87[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]

[TD="align: center"]88[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]

[TD="align: center"]89[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]

[TD="align: center"]90[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]

[TD="align: center"]91[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]

[TD="align: center"]92[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]

[TD="align: center"]93[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]

[TD="align: center"]94[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]

[TD="align: center"]95[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]

[TD="align: center"]96[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]

[TD="align: center"]97[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]

[TD="align: center"]98[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]

[TD="align: center"]99[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]

</tbody>

report1364218650080​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<tbody>[TR="bgcolor: #DAE7F5"]
[TH]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
[TR]
[TH="bgcolor: #DAE7F5"]I1[/TH]
[TD="align: left"]=SUMIF(($C6:$C126),$H1,I6:I126)[/TD]
[/TR]
[TR]
[TH="bgcolor: #DAE7F5"]J1[/TH]
[TD="align: left"]=SUMIF(($C6:$C126),$H1,J6:J126)[/TD]
[/TR]
[TR]
[TH="bgcolor: #DAE7F5"]K1[/TH]
[TD="align: left"]=SUMIF(($C6:$C126),$H1,K6:K126)[/TD]
[/TR]
[TR]
[TH="bgcolor: #DAE7F5"]L1[/TH]
[TD="align: left"]=SUMIF(($C6:$C126),$H1,L6:L126)[/TD]
[/TR]
[TR]
[TH="bgcolor: #DAE7F5"]M1[/TH]
[TD="align: left"]=SUMIF(($C6:$C126),$H1,M6:M126)[/TD]
[/TR]
[TR]
[TH="bgcolor: #DAE7F5"]N1[/TH]
[TD="align: left"]=SUMIF(($C6:$C126),$H1,N6:N126)[/TD]
[/TR]
[TR]
[TH="bgcolor: #DAE7F5"]O1[/TH]
[TD="align: left"]=SUMIF(($C6:$C126),$H1,O6:O126)[/TD]
[/TR]
[TR]
[TH="bgcolor: #DAE7F5"]P1[/TH]
[TD="align: left"]=SUMIF(($C6:$C126),$H1,P6:P126)[/TD]
[/TR]
[TR]
[TH="bgcolor: #DAE7F5"]Q1[/TH]
[TD="align: left"]=SUMIF(($C6:$C126),$H1,Q6:Q126)[/TD]
[/TR]
[TR]
[TH="bgcolor: #DAE7F5"]R1[/TH]
[TD="align: left"]=SUMIF(($C6:$C126),$H1,R6:R126)[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]






<!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:TrackMoves/> <w:TrackFormatting/> <w:PunctuationKerning/> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent> <w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText> <w:DoNotPromoteQF/> <w:LidThemeOther>EN-US</w:LidThemeOther> <w:LidThemeAsian>X-NONE</w:LidThemeAsian> <w:LidThemeComplexScript>X-NONE</w:LidThemeComplexScript> <w:Compatibility> <w:BreakWrappedTables/> <w:SnapToGridInCell/> <w:WrapTextWithPunct/> <w:UseAsianBreakRules/> <w:DontGrowAutofit/> <w:SplitPgBreakAndParaMark/> <w:EnableOpenTypeKerning/> <w:DontFlipMirrorIndents/> <w:OverrideTableStyleHps/> <w:UseFELayout/> </w:Compatibility> <m:mathPr> <m:mathFont m:val="Cambria Math"/> <m:brkBin m:val="before"/> <m:brkBinSub m:val="--"/> <m:smallFrac m:val="off"/> <m:dispDef/> <m:lMargin m:val="0"/> <m:rMargin m:val="0"/> <m:defJc m:val="centerGroup"/> <m:wrapIndent m:val="1440"/> <m:intLim m:val="subSup"/> <m:naryLim m:val="undOvr"/> </m:mathPr></w:WordDocument> </xml><![endif]--><!--[if gte mso 9]><xml> <w:LatentStyles DefLockedState="false" DefUnhideWhenUsed="false" DefSemiHidden="false" DefQFormat="false" DefPriority="99" LatentStyleCount="371"> <w:LsdException Locked="false" Priority="0" QFormat="true" Name="Normal"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 1"/> <w:LsdException Locked="false" Priority="9" SemiHidden="true" UnhideWhenUsed="true" QFormat="true" Name="heading 2"/> <w:LsdException Locked="false" Priority="9" SemiHidden="true" UnhideWhenUsed="true" QFormat="true" Name="heading 3"/> <w:LsdException Locked="false" Priority="9" SemiHidden="true" UnhideWhenUsed="true" QFormat="true" Name="heading 4"/> <w:LsdException Locked="false" Priority="9" SemiHidden="true" UnhideWhenUsed="true" QFormat="true" Name="heading 5"/> <w:LsdException Locked="false" Priority="9" SemiHidden="true" UnhideWhenUsed="true" QFormat="true" Name="heading 6"/> <w:LsdException Locked="false" Priority="9" SemiHidden="true" UnhideWhenUsed="true" QFormat="true" Name="heading 7"/> <w:LsdException Locked="false" Priority="9" SemiHidden="true" UnhideWhenUsed="true" QFormat="true" Name="heading 8"/> <w:LsdException Locked="false" Priority="9" SemiHidden="true" UnhideWhenUsed="true" QFormat="true" Name="heading 9"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="index 1"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="index 2"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="index 3"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="index 4"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="index 5"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="index 6"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="index 7"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="index 8"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="index 9"/> <w:LsdException Locked="false" Priority="39" SemiHidden="true" UnhideWhenUsed="true" Name="toc 1"/> <w:LsdException Locked="false" Priority="39" SemiHidden="true" UnhideWhenUsed="true" Name="toc 2"/> <w:LsdException Locked="false" Priority="39" SemiHidden="true" UnhideWhenUsed="true" Name="toc 3"/> <w:LsdException Locked="false" Priority="39" SemiHidden="true" UnhideWhenUsed="true" Name="toc 4"/> <w:LsdException Locked="false" Priority="39" SemiHidden="true" UnhideWhenUsed="true" Name="toc 5"/> <w:LsdException Locked="false" Priority="39" SemiHidden="true" UnhideWhenUsed="true" Name="toc 6"/> <w:LsdException Locked="false" Priority="39" SemiHidden="true" UnhideWhenUsed="true" Name="toc 7"/> <w:LsdException Locked="false" Priority="39" SemiHidden="true" UnhideWhenUsed="true" Name="toc 8"/> <w:LsdException Locked="false" Priority="39" SemiHidden="true" UnhideWhenUsed="true" Name="toc 9"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Normal Indent"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="footnote text"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="annotation text"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="header"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="footer"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="index heading"/> <w:LsdException Locked="false" Priority="35" SemiHidden="true" UnhideWhenUsed="true" QFormat="true" Name="caption"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="table of figures"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="envelope address"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="envelope return"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="footnote reference"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="annotation reference"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="line number"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="page number"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="endnote reference"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="endnote text"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="table of authorities"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="macro"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="toa heading"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="List"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="List Bullet"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="List Number"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="List 2"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="List 3"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="List 4"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="List 5"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="List Bullet 2"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="List Bullet 3"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="List Bullet 4"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="List Bullet 5"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="List Number 2"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="List Number 3"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="List Number 4"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="List Number 5"/> <w:LsdException Locked="false" Priority="10" QFormat="true" Name="Title"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Closing"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Signature"/> <w:LsdException Locked="false" Priority="1" SemiHidden="true" UnhideWhenUsed="true" Name="Default Paragraph Font"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Body Text"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Body Text Indent"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="List Continue"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="List Continue 2"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="List Continue 3"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="List Continue 4"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="List Continue 5"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Message Header"/> <w:LsdException Locked="false" Priority="11" QFormat="true" Name="Subtitle"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Salutation"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Date"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Body Text First Indent"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Body Text First Indent 2"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Note Heading"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Body Text 2"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Body Text 3"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Body Text Indent 2"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Body Text Indent 3"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Block Text"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Hyperlink"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="FollowedHyperlink"/> <w:LsdException Locked="false" Priority="22" QFormat="true" Name="Strong"/> <w:LsdException Locked="false" Priority="20" QFormat="true" Name="Emphasis"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Document Map"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Plain Text"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="E-mail Signature"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="HTML Top of Form"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="HTML Bottom of Form"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Normal (Web)"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="HTML Acronym"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="HTML Address"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="HTML Cite"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="HTML Code"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="HTML Definition"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="HTML Keyboard"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="HTML Preformatted"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="HTML Sample"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="HTML Typewriter"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="HTML Variable"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Normal Table"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="annotation subject"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="No List"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Outline List 1"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Outline List 2"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Outline List 3"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Simple 1"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Simple 2"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Simple 3"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Classic 1"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Classic 2"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Classic 3"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Classic 4"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Colorful 1"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Colorful 2"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Colorful 3"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Columns 1"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Columns 2"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Columns 3"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Columns 4"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Columns 5"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Grid 1"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Grid 2"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Grid 3"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Grid 4"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Grid 5"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Grid 6"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Grid 7"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Grid 8"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table List 1"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table List 2"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table List 3"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table List 4"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table List 5"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table List 6"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table List 7"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table List 8"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table 3D effects 1"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table 3D effects 2"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table 3D effects 3"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Contemporary"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Elegant"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Professional"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Subtle 1"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Subtle 2"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Web 1"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Web 2"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Web 3"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Balloon Text"/> <w:LsdException Locked="false" Priority="39" Name="Table Grid"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Theme"/> <w:LsdException Locked="false" SemiHidden="true" Name="Placeholder Text"/> <w:LsdException Locked="false" Priority="1" QFormat="true" Name="No Spacing"/> <w:LsdException Locked="false" Priority="60" Name="Light Shading"/> <w:LsdException Locked="false" Priority="61" Name="Light List"/> <w:LsdException Locked="false" Priority="62" Name="Light Grid"/> <w:LsdException Locked="false" Priority="63" Name="Medium Shading 1"/> <w:LsdException Locked="false" Priority="64" Name="Medium Shading 2"/> <w:LsdException Locked="false" Priority="65" Name="Medium List 1"/> <w:LsdException Locked="false" Priority="66" Name="Medium List 2"/> <w:LsdException Locked="false" Priority="67" Name="Medium Grid 1"/> <w:LsdException Locked="false" Priority="68" Name="Medium Grid 2"/> <w:LsdException Locked="false" Priority="69" Name="Medium Grid 3"/> <w:LsdException Locked="false" Priority="70" Name="Dark List"/> <w:LsdException Locked="false" Priority="71" Name="Colorful Shading"/> <w:LsdException Locked="false" Priority="72" Name="Colorful List"/> <w:LsdException Locked="false" Priority="73" Name="Colorful Grid"/> <w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 1"/> <w:LsdException Locked="false" Priority="61" Name="Light List Accent 1"/> <w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 1"/> <w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 1"/> <w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 1"/> <w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 1"/> <w:LsdException Locked="false" SemiHidden="true" Name="Revision"/> <w:LsdException Locked="false" Priority="34" QFormat="true" Name="List Paragraph"/> <w:LsdException Locked="false" Priority="29" QFormat="true" Name="Quote"/> <w:LsdException Locked="false" Priority="30" QFormat="true" Name="Intense Quote"/> <w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 1"/> <w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 1"/> <w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 1"/> <w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 1"/> <w:LsdException Locked="false" Priority="70" Name="Dark List Accent 1"/> <w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 1"/> <w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 1"/> <w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 1"/> <w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 2"/> <w:LsdException Locked="false" Priority="61" Name="Light List Accent 2"/> <w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 2"/> <w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 2"/> <w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 2"/> <w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 2"/> <w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 2"/> <w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 2"/> <w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 2"/> <w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 2"/> <w:LsdException Locked="false" Priority="70" Name="Dark List Accent 2"/> <w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 2"/> <w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 2"/> <w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 2"/> <w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 3"/> <w:LsdException Locked="false" Priority="61" Name="Light List Accent 3"/> <w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 3"/> <w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 3"/> <w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 3"/> <w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 3"/> <w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 3"/> <w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 3"/> <w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 3"/> <w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 3"/> <w:LsdException Locked="false" Priority="70" Name="Dark List Accent 3"/> <w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 3"/> <w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 3"/> <w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 3"/> <w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 4"/> <w:LsdException Locked="false" Priority="61" Name="Light List Accent 4"/> <w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 4"/> <w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 4"/> <w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 4"/> <w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 4"/> <w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 4"/> <w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 4"/> <w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 4"/> <w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 4"/> <w:LsdException Locked="false" Priority="70" Name="Dark List Accent 4"/> <w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 4"/> <w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 4"/> <w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 4"/> <w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 5"/> <w:LsdException Locked="false" Priority="61" Name="Light List Accent 5"/> <w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 5"/> <w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 5"/> <w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 5"/> <w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 5"/> <w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 5"/> <w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 5"/> <w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 5"/> <w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 5"/> <w:LsdException Locked="false" Priority="70" Name="Dark List Accent 5"/> <w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 5"/> <w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 5"/> <w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 5"/> <w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 6"/> <w:LsdException Locked="false" Priority="61" Name="Light List Accent 6"/> <w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 6"/> <w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 6"/> <w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 6"/> <w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 6"/> <w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 6"/> <w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 6"/> <w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 6"/> <w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 6"/> <w:LsdException Locked="false" Priority="70" Name="Dark List Accent 6"/> <w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 6"/> <w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 6"/> <w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 6"/> <w:LsdException Locked="false" Priority="19" QFormat="true" Name="Subtle Emphasis"/> <w:LsdException Locked="false" Priority="21" QFormat="true" Name="Intense Emphasis"/> <w:LsdException Locked="false" Priority="31" QFormat="true" Name="Subtle Reference"/> <w:LsdException Locked="false" Priority="32" QFormat="true" Name="Intense Reference"/> <w:LsdException Locked="false" Priority="33" QFormat="true" Name="Book Title"/> <w:LsdException Locked="false" Priority="37" SemiHidden="true" UnhideWhenUsed="true" Name="Bibliography"/> <w:LsdException Locked="false" Priority="39" SemiHidden="true" UnhideWhenUsed="true" QFormat="true" Name="TOC Heading"/> <w:LsdException Locked="false" Priority="41" Name="Plain Table 1"/> <w:LsdException Locked="false" Priority="42" Name="Plain Table 2"/> <w:LsdException Locked="false" Priority="43" Name="Plain Table 3"/> <w:LsdException Locked="false" Priority="44" Name="Plain Table 4"/> <w:LsdException Locked="false" Priority="45" Name="Plain Table 5"/> <w:LsdException Locked="false" Priority="40" Name="Grid Table Light"/> <w:LsdException Locked="false" Priority="46" Name="Grid Table 1 Light"/> <w:LsdException Locked="false" Priority="47" Name="Grid Table 2"/> <w:LsdException Locked="false" Priority="48" Name="Grid Table 3"/> <w:LsdException Locked="false" Priority="49" Name="Grid Table 4"/> <w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark"/> <w:LsdException Locked="false" Priority="51" Name="Grid Table 6 Colorful"/> <w:LsdException Locked="false" Priority="52" Name="Grid Table 7 Colorful"/> <w:LsdException Locked="false" Priority="46" Name="Grid Table 1 Light Accent 1"/> <w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 1"/> <w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 1"/> <w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 1"/> <w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 1"/> <w:LsdException Locked="false" Priority="51" Name="Grid Table 6 Colorful Accent 1"/> <w:LsdException Locked="false" Priority="52" Name="Grid Table 7 Colorful Accent 1"/> <w:LsdException Locked="false" Priority="46" Name="Grid Table 1 Light Accent 2"/> <w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 2"/> <w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 2"/> <w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 2"/> <w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 2"/> <w:LsdException Locked="false" Priority="51" Name="Grid Table 6 Colorful Accent 2"/> <w:LsdException Locked="false" Priority="52" Name="Grid Table 7 Colorful Accent 2"/> <w:LsdException Locked="false" Priority="46" Name="Grid Table 1 Light Accent 3"/> <w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 3"/> <w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 3"/> <w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 3"/> <w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 3"/> <w:LsdException Locked="false" Priority="51" Name="Grid Table 6 Colorful Accent 3"/> <w:LsdException Locked="false" Priority="52" Name="Grid Table 7 Colorful Accent 3"/> <w:LsdException Locked="false" Priority="46" Name="Grid Table 1 Light Accent 4"/> <w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 4"/> <w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 4"/> <w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 4"/> <w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 4"/> <w:LsdException Locked="false" Priority="51" Name="Grid Table 6 Colorful Accent 4"/> <w:LsdException Locked="false" Priority="52" Name="Grid Table 7 Colorful Accent 4"/> <w:LsdException Locked="false" Priority="46" Name="Grid Table 1 Light Accent 5"/> <w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 5"/> <w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 5"/> <w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 5"/> <w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 5"/> <w:LsdException Locked="false" Priority="51" Name="Grid Table 6 Colorful Accent 5"/> <w:LsdException Locked="false" Priority="52" Name="Grid Table 7 Colorful Accent 5"/> <w:LsdException Locked="false" Priority="46" Name="Grid Table 1 Light Accent 6"/> <w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 6"/> <w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 6"/> <w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 6"/> <w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 6"/> <w:LsdException Locked="false" Priority="51" Name="Grid Table 6 Colorful Accent 6"/> <w:LsdException Locked="false" Priority="52" Name="Grid Table 7 Colorful Accent 6"/> <w:LsdException Locked="false" Priority="46" Name="List Table 1 Light"/> <w:LsdException Locked="false" Priority="47" Name="List Table 2"/> <w:LsdException Locked="false" Priority="48" Name="List Table 3"/> <w:LsdException Locked="false" Priority="49" Name="List Table 4"/> <w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark"/> <w:LsdException Locked="false" Priority="51" Name="List Table 6 Colorful"/> <w:LsdException Locked="false" Priority="52" Name="List Table 7 Colorful"/> <w:LsdException Locked="false" Priority="46" Name="List Table 1 Light Accent 1"/> <w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 1"/> <w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 1"/> <w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 1"/> <w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 1"/> <w:LsdException Locked="false" Priority="51" Name="List Table 6 Colorful Accent 1"/> <w:LsdException Locked="false" Priority="52" Name="List Table 7 Colorful Accent 1"/> <w:LsdException Locked="false" Priority="46" Name="List Table 1 Light Accent 2"/> <w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 2"/> <w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 2"/> <w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 2"/> <w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 2"/> <w:LsdException Locked="false" Priority="51" Name="List Table 6 Colorful Accent 2"/> <w:LsdException Locked="false" Priority="52" Name="List Table 7 Colorful Accent 2"/> <w:LsdException Locked="false" Priority="46" Name="List Table 1 Light Accent 3"/> <w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 3"/> <w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 3"/> <w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 3"/> <w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 3"/> <w:LsdException Locked="false" Priority="51" Name="List Table 6 Colorful Accent 3"/> <w:LsdException Locked="false" Priority="52" Name="List Table 7 Colorful Accent 3"/> <w:LsdException Locked="false" Priority="46" Name="List Table 1 Light Accent 4"/> <w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 4"/> <w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 4"/> <w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 4"/> <w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 4"/> <w:LsdException Locked="false" Priority="51" Name="List Table 6 Colorful Accent 4"/> <w:LsdException Locked="false" Priority="52" Name="List Table 7 Colorful Accent 4"/> <w:LsdException Locked="false" Priority="46" Name="List Table 1 Light Accent 5"/> <w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 5"/> <w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 5"/> <w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 5"/> <w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 5"/> <w:LsdException Locked="false" Priority="51" Name="List Table 6 Colorful Accent 5"/> <w:LsdException Locked="false" Priority="52" Name="List Table 7 Colorful Accent 5"/> <w:LsdException Locked="false" Priority="46" Name="List Table 1 Light Accent 6"/> <w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 6"/> <w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 6"/> <w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 6"/> <w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 6"/> <w:LsdException Locked="false" Priority="51" Name="List Table 6 Colorful Accent 6"/> <w:LsdException Locked="false" Priority="52" Name="List Table 7 Colorful Accent 6"/> </w:LatentStyles> </xml><![endif]--><!--[if gte mso 10]> <style> /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin;} </style> <![endif]-->

 

[RonB1111]

First, change the month entries in I5, J5, etc from 4, 5, etc to 4/1/2013, 5/1/2013, etc

Then enter this formula in I6 and copy down and across:

=$G6/$F6*IF(AND(EOMONTH($E6,0<=EOMONTH(I$5,0),EOMONTH(DATE(YEAR($E6),MONTH($E6)+$F6,1),0)>=EOMONTH(I$5,0)),1,0)*IF(EOMONTH($E6,0)=EOMONTH(I$5,0),(EOMONTH(I$5,0)-$E6+1)/DAY(EOMONTH(I$5,0)),1)*IF(EOMONTH(DATE(YEAR($E6),MONTH($E6)+$F6,1),0)=EOMONTH(I$5,0),($G6-SUM($H6:H6))/$G6*$F6,1)

Sorry it's so long. Took a while just to get it to work and I ran out of time to try and shorten it.

Be aware that your sample had blank cells in H6:H98 and I used these cells in the formula so they must remain blank for the formula to work.

 

[scott_bassman]

First, change the month entries in I5, J5, etc from 4, 5, etc to 4/1/2013, 5/1/2013, etc

Then enter this formula in I6 and copy down and across:

=$G6/$F6*IF(AND(EOMONTH($E6,0<=EOMONTH(I$5,0),EOMONTH(DATE(YEAR($E6),MONTH($E6)+$F6,1),0)>=EOMONTH(I$5,0)),1,0)*IF(EOMONTH($E6,0)=EOMONTH(I$5,0),(EOMONTH(I$5,0)-$E6+1)/DAY(EOMONTH(I$5,0)),1)*IF(EOMONTH(DATE(YEAR($E6),MONTH($E6)+$F6,1),0)=EOMONTH(I$5,0),($G6-SUM($H6:H6))/$G6*$F6,1)

Sorry it's so long. Took a while just to get it to work and I ran out of time to try and shorten it.

Be aware that your sample had blank cells in H6:H98 and I used these cells in the formula so they must remain blank for the formula to work.

Hi Ron, I'm not an expert in Excel, so it's possible that I'm doing something wrong. When I changed the I5, J5 etc from 4, 5, etc to 4/1/2013, 5/1/2013, etc I removed the formulas, and just plugged in the actual dates of 4/1/2013, 5/1/2013, etc.

Also, when entering the above code, I get the following error: "You've entered too many arguments for this function. To get help with this function, click OK to close this message. Then click the Insert Function button located to the left of the equal sign in your formula.

Thank you for your follow up and assistance - it's greatly appreciated!

 

[RonB1111]

I accidentally deleted the 1st ) when I tried to remove a line break - here it is correctly. Copy the entire formula into I6 & let me know how it goes.

=$G6/$F6*IF(AND(EOMONTH($E6,0)<=EOMONTH(I$5,0),EOMONTH(DATE(YEAR($E6),MONTH($E6)+$F6,1),0)>=EOMONTH(I$5,0)),1,0)*IF(EOMONTH($E6,0)=EOMONTH(I$5,0),(EOMONTH(I$5,0)-$E6+1)/DAY(EOMONTH(I$5,0)),1)*IF(EOMONTH(DATE(YEAR($E6),MONTH($E6)+$F6,1),0)=EOMONTH(I$5,0),($G6-SUM($H6:H6))/$G6*$F6,1)

 

[scott_bassman]

That worked perfectly! Now the fields, I4, J4, K4, etc. are not populating - there' a, "#DIV/O!" in each of them. If you could help with that too, that would be much appreciated.

Again, thank you for the help you've provided so far.

 

[RonB1111]

What are the formulas in I4, J4, etc? It would seem the formula should be =SUM(I1:I3) and copied across.

 

[scott_bassman]

What are the formulas in I4, J4, etc? It would seem the formula should be =SUM(I1:I3) and copied across.

Thank you so much! I really appreciate your assistance.

Thanks again!

 

[RonB1111]

You're welcome. Thank you for providing feedback.