Captain Hindsight
New Member
- Joined
- Oct 9, 2013
- Messages
- 46
How can I write a formula to display data as per the below?
The 239.555 is cell C2.
The months going horizontally start from E3, going vertically they start from B5.
In E5 I am up to here with the formula (needs to be dragged across and down) so as to apply the pattern below to each row, beginning when the month above the cell and one to the left (prev month), matches the month to the left of the cell (current month):
=IF($B5<=D$3,IF($C5>0,IF(COLUMNS($A:A)<4,IF(MOD(COLUMNS($A:A),3)=1,0,$C$2),IF(MOD(COLUMNS($A:A),4)=0,0,$C$2)),0),"")
However this gives does not start the pattern from the place I mentioned above, it gives me where the pattern above would be at if it had started from Dec 15, which I don't want.
HELP!
[TABLE="class: cms_table"]
<TBODY>[TR]
[TD]Batch 1</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]</SPAN>[/TD]
[TD="align: right"]</SPAN>[/TD]
[TD="align: right"]</SPAN>[/TD]
[TD="align: right"]</SPAN>[/TD]
[TD="align: right"]</SPAN>[/TD]
[TD="align: right"]</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]</SPAN>[/TD]
[TD="align: right"]239.555</SPAN>[/TD]
[TD][/TD]
[TD="align: right"]1</SPAN>[/TD]
[TD="align: right"]2</SPAN>[/TD]
[TD="align: right"]3</SPAN>[/TD]
[TD="align: right"]4</SPAN>[/TD]
[TD="align: right"]5</SPAN>[/TD]
[TD="align: right"]6</SPAN>[/TD]
[TD="align: right"]7</SPAN>[/TD]
[TD="align: right"]8</SPAN>[/TD]
[TD="align: right"]9</SPAN>[/TD]
[TD="align: right"]10</SPAN>[/TD]
[TD="align: right"]11</SPAN>[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]Dec-15</SPAN>[/TD]
[TD="align: right"]Jan-16</SPAN>[/TD]
[TD="align: right"]Feb-16</SPAN>[/TD]
[TD="align: right"]Mar-16</SPAN>[/TD]
[TD="align: right"]Apr-16</SPAN>[/TD]
[TD="align: right"]May-16</SPAN>[/TD]
[TD="align: right"]Jun-16</SPAN>[/TD]
[TD="align: right"]Jul-16</SPAN>[/TD]
[TD="align: right"]Aug-16</SPAN>[/TD]
[TD="align: right"]Sep-16</SPAN>[/TD]
[TD="align: right"]Oct-16</SPAN>[/TD]
[/TR]
[TR]
[TD]Month of introduction</SPAN>[/TD]
[TD]Date</SPAN>[/TD]
[TD]Delivered</SPAN>[/TD]
[TD]</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1</SPAN>[/TD]
[TD="align: right"]Dec-15</SPAN>[/TD]
[TD="align: right"]1</SPAN>[/TD]
[TD="align: right"]</SPAN>[/TD]
[TD][/TD]
[TD="align: right"]239.555</SPAN>[/TD]
[TD="align: right"]239.555</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]239.555</SPAN>[/TD]
[TD="align: right"]239.555</SPAN>[/TD]
[TD="align: right"]239.555</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]239.555</SPAN>[/TD]
[TD="align: right"]239.555</SPAN>[/TD]
[TD="align: right"]239.555</SPAN>[/TD]
[/TR]
[TR]
[TD]2</SPAN>[/TD]
[TD="align: right"]Jan-16</SPAN>[/TD]
[TD="align: right"]3</SPAN>[/TD]
[TD="align: right"]</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]239.555</SPAN>[/TD]
[TD="align: right"]239.555</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]239.555</SPAN>[/TD]
[TD="align: right"]239.555</SPAN>[/TD]
[TD="align: right"]239.555</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]239.555</SPAN>[/TD]
[TD="align: right"]239.555</SPAN>[/TD]
[/TR]
[TR]
[TD]3</SPAN>[/TD]
[TD="align: right"]Feb-16</SPAN>[/TD]
[TD="align: right"]2</SPAN>[/TD]
[TD="align: right"]</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]239.555</SPAN>[/TD]
[TD="align: right"]239.555</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]239.555</SPAN>[/TD]
[TD="align: right"]239.555</SPAN>[/TD]
[TD="align: right"]239.555</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]239.555</SPAN>[/TD]
[/TR]
[TR]
[TD]4</SPAN>[/TD]
[TD="align: right"]Mar-16</SPAN>[/TD]
[TD="align: right"]2</SPAN>[/TD]
[TD="align: right"]</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]239.555</SPAN>[/TD]
[TD="align: right"]239.555</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]239.555</SPAN>[/TD]
[TD="align: right"]239.555</SPAN>[/TD]
[TD="align: right"]239.555</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[/TR]
[TR]
[TD]5</SPAN>[/TD]
[TD="align: right"]Apr-16</SPAN>[/TD]
[TD="align: right"]4</SPAN>[/TD]
[TD="align: right"]</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]239.555</SPAN>[/TD]
[TD="align: right"]239.555</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]239.555</SPAN>[/TD]
[TD="align: right"]239.555</SPAN>[/TD]
[TD="align: right"]239.555</SPAN>[/TD]
[/TR]
[TR]
[TD]6</SPAN>[/TD]
[TD="align: right"]May-16</SPAN>[/TD]
[TD="align: right"]3</SPAN>[/TD]
[TD="align: right"]</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]239.555</SPAN>[/TD]
[TD="align: right"]239.555</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]239.555</SPAN>[/TD]
[TD="align: right"]239.555</SPAN>[/TD]
[/TR]
[TR]
[TD]7</SPAN>[/TD]
[TD="align: right"]Jun-16</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[/TR]
[TR]
[TD]8</SPAN>[/TD]
[TD="align: right"]Jul-16</SPAN>[/TD]
[TD="align: right"]3</SPAN>[/TD]
[TD="align: right"]</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]239.555</SPAN>[/TD]
[TD="align: right"]239.555</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[/TR]
[TR]
[TD]9</SPAN>[/TD]
[TD="align: right"]Aug-16</SPAN>[/TD]
[TD="align: right"]2</SPAN>[/TD]
[TD="align: right"]</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]239.555</SPAN>[/TD]
[TD="align: right"]239.555</SPAN>[/TD]
[/TR]
[TR]
[TD]10</SPAN>[/TD]
[TD="align: right"]Sep-16</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[/TR]
[TR]
[TD]11</SPAN>[/TD]
[TD="align: right"]Oct-16</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[/TR]
</TBODY>[/TABLE]
The 239.555 is cell C2.
The months going horizontally start from E3, going vertically they start from B5.
In E5 I am up to here with the formula (needs to be dragged across and down) so as to apply the pattern below to each row, beginning when the month above the cell and one to the left (prev month), matches the month to the left of the cell (current month):
=IF($B5<=D$3,IF($C5>0,IF(COLUMNS($A:A)<4,IF(MOD(COLUMNS($A:A),3)=1,0,$C$2),IF(MOD(COLUMNS($A:A),4)=0,0,$C$2)),0),"")
However this gives does not start the pattern from the place I mentioned above, it gives me where the pattern above would be at if it had started from Dec 15, which I don't want.
HELP!
[TABLE="class: cms_table"]
<TBODY>[TR]
[TD]Batch 1</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]</SPAN>[/TD]
[TD="align: right"]</SPAN>[/TD]
[TD="align: right"]</SPAN>[/TD]
[TD="align: right"]</SPAN>[/TD]
[TD="align: right"]</SPAN>[/TD]
[TD="align: right"]</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]</SPAN>[/TD]
[TD="align: right"]239.555</SPAN>[/TD]
[TD][/TD]
[TD="align: right"]1</SPAN>[/TD]
[TD="align: right"]2</SPAN>[/TD]
[TD="align: right"]3</SPAN>[/TD]
[TD="align: right"]4</SPAN>[/TD]
[TD="align: right"]5</SPAN>[/TD]
[TD="align: right"]6</SPAN>[/TD]
[TD="align: right"]7</SPAN>[/TD]
[TD="align: right"]8</SPAN>[/TD]
[TD="align: right"]9</SPAN>[/TD]
[TD="align: right"]10</SPAN>[/TD]
[TD="align: right"]11</SPAN>[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]Dec-15</SPAN>[/TD]
[TD="align: right"]Jan-16</SPAN>[/TD]
[TD="align: right"]Feb-16</SPAN>[/TD]
[TD="align: right"]Mar-16</SPAN>[/TD]
[TD="align: right"]Apr-16</SPAN>[/TD]
[TD="align: right"]May-16</SPAN>[/TD]
[TD="align: right"]Jun-16</SPAN>[/TD]
[TD="align: right"]Jul-16</SPAN>[/TD]
[TD="align: right"]Aug-16</SPAN>[/TD]
[TD="align: right"]Sep-16</SPAN>[/TD]
[TD="align: right"]Oct-16</SPAN>[/TD]
[/TR]
[TR]
[TD]Month of introduction</SPAN>[/TD]
[TD]Date</SPAN>[/TD]
[TD]Delivered</SPAN>[/TD]
[TD]</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1</SPAN>[/TD]
[TD="align: right"]Dec-15</SPAN>[/TD]
[TD="align: right"]1</SPAN>[/TD]
[TD="align: right"]</SPAN>[/TD]
[TD][/TD]
[TD="align: right"]239.555</SPAN>[/TD]
[TD="align: right"]239.555</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]239.555</SPAN>[/TD]
[TD="align: right"]239.555</SPAN>[/TD]
[TD="align: right"]239.555</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]239.555</SPAN>[/TD]
[TD="align: right"]239.555</SPAN>[/TD]
[TD="align: right"]239.555</SPAN>[/TD]
[/TR]
[TR]
[TD]2</SPAN>[/TD]
[TD="align: right"]Jan-16</SPAN>[/TD]
[TD="align: right"]3</SPAN>[/TD]
[TD="align: right"]</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]239.555</SPAN>[/TD]
[TD="align: right"]239.555</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]239.555</SPAN>[/TD]
[TD="align: right"]239.555</SPAN>[/TD]
[TD="align: right"]239.555</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]239.555</SPAN>[/TD]
[TD="align: right"]239.555</SPAN>[/TD]
[/TR]
[TR]
[TD]3</SPAN>[/TD]
[TD="align: right"]Feb-16</SPAN>[/TD]
[TD="align: right"]2</SPAN>[/TD]
[TD="align: right"]</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]239.555</SPAN>[/TD]
[TD="align: right"]239.555</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]239.555</SPAN>[/TD]
[TD="align: right"]239.555</SPAN>[/TD]
[TD="align: right"]239.555</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]239.555</SPAN>[/TD]
[/TR]
[TR]
[TD]4</SPAN>[/TD]
[TD="align: right"]Mar-16</SPAN>[/TD]
[TD="align: right"]2</SPAN>[/TD]
[TD="align: right"]</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]239.555</SPAN>[/TD]
[TD="align: right"]239.555</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]239.555</SPAN>[/TD]
[TD="align: right"]239.555</SPAN>[/TD]
[TD="align: right"]239.555</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[/TR]
[TR]
[TD]5</SPAN>[/TD]
[TD="align: right"]Apr-16</SPAN>[/TD]
[TD="align: right"]4</SPAN>[/TD]
[TD="align: right"]</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]239.555</SPAN>[/TD]
[TD="align: right"]239.555</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]239.555</SPAN>[/TD]
[TD="align: right"]239.555</SPAN>[/TD]
[TD="align: right"]239.555</SPAN>[/TD]
[/TR]
[TR]
[TD]6</SPAN>[/TD]
[TD="align: right"]May-16</SPAN>[/TD]
[TD="align: right"]3</SPAN>[/TD]
[TD="align: right"]</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]239.555</SPAN>[/TD]
[TD="align: right"]239.555</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]239.555</SPAN>[/TD]
[TD="align: right"]239.555</SPAN>[/TD]
[/TR]
[TR]
[TD]7</SPAN>[/TD]
[TD="align: right"]Jun-16</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[/TR]
[TR]
[TD]8</SPAN>[/TD]
[TD="align: right"]Jul-16</SPAN>[/TD]
[TD="align: right"]3</SPAN>[/TD]
[TD="align: right"]</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]239.555</SPAN>[/TD]
[TD="align: right"]239.555</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[/TR]
[TR]
[TD]9</SPAN>[/TD]
[TD="align: right"]Aug-16</SPAN>[/TD]
[TD="align: right"]2</SPAN>[/TD]
[TD="align: right"]</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]239.555</SPAN>[/TD]
[TD="align: right"]239.555</SPAN>[/TD]
[/TR]
[TR]
[TD]10</SPAN>[/TD]
[TD="align: right"]Sep-16</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[/TR]
[TR]
[TD]11</SPAN>[/TD]
[TD="align: right"]Oct-16</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[/TR]
</TBODY>[/TABLE]