Help with a sumif or similar formula

[nsharonew]

My current project is analysis of difference between two sets of numbers. I will try to leave all the boring details out and get to the good stuff.

Basically this is for resource allocations. Each resource has a plan and allocation within three types of work. My task is to find what the difference is between the plan and the allocation and track "movement".

So, let's say John Smith is planned to have 25% in type a, 25% in type b and 50% in type c. John Smith is then allocated 100% in type c, meaning the difference will be -25%, -25% and 50% respectively.

For all intents and purposes this is already half done. I have the plans and allocations as well as the differences. What I need is a formula which will track this movement, in the case of John smith, it would be that type a gave 25% to type c and type b gave 25% to type c. Except, it will be for approximately 320 resources.

The issue I am running into is that if, for instance, I am trying to find the total that type a gave to type c I also need to consider that type a could have given type b a portion and type c a portion.

Here is an example of the data...

<TABLE style="WIDTH: 394pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=524><COLGROUP><COL style="WIDTH: 81pt; mso-width-source: userset; mso-width-alt: 3949" width=108><COL style="WIDTH: 31pt; mso-width-source: userset; mso-width-alt: 1499" width=41><COL style="WIDTH: 37pt; mso-width-source: userset; mso-width-alt: 1792" width=49><COL style="WIDTH: 34pt; mso-width-source: userset; mso-width-alt: 1645" width=45><COL style="WIDTH: 44pt; mso-width-source: userset; mso-width-alt: 2121" width=58><COL style="WIDTH: 37pt; mso-width-source: userset; mso-width-alt: 1792" width=49><COL style="WIDTH: 34pt; mso-width-source: userset; mso-width-alt: 1645" width=45><COL style="WIDTH: 35pt; mso-width-source: userset; mso-width-alt: 1718" width=47><COL style="WIDTH: 32pt; mso-width-source: userset; mso-width-alt: 1572" width=43><COL style="WIDTH: 29pt; mso-width-source: userset; mso-width-alt: 1426" width=39><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue 0.5pt solid; BACKGROUND-COLOR: lime; WIDTH: 81pt; HEIGHT: 15pt; BORDER-TOP: blue 0.5pt solid; BORDER-RIGHT: blue 0.5pt solid" class=xl63 height=20 width=108>Resource Name</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: lime; WIDTH: 31pt; BORDER-TOP: blue 0.5pt solid; BORDER-RIGHT: blue 0.5pt solid" class=xl64 width=41>A Plan</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: lime; WIDTH: 37pt; BORDER-TOP: blue 0.5pt solid; BORDER-RIGHT: blue 0.5pt solid" class=xl64 width=49>A Alloc.</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: lime; WIDTH: 34pt; BORDER-TOP: blue 0.5pt solid; BORDER-RIGHT: blue 0.5pt solid" class=xl64 width=45>A Diff</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: lime; WIDTH: 44pt; BORDER-TOP: blue 0.5pt solid; BORDER-RIGHT: blue 0.5pt solid" class=xl64 width=58>B Plan</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: lime; WIDTH: 37pt; BORDER-TOP: blue 0.5pt solid; BORDER-RIGHT: blue 0.5pt solid" class=xl64 width=49>B Alloc</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: lime; WIDTH: 34pt; BORDER-TOP: blue 0.5pt solid; BORDER-RIGHT: blue 0.5pt solid" class=xl64 width=45>Bdiff</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: lime; WIDTH: 35pt; BORDER-TOP: blue 0.5pt solid; BORDER-RIGHT: blue 0.5pt solid" class=xl64 width=47>C Plan</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: lime; WIDTH: 32pt; BORDER-TOP: blue 0.5pt solid; BORDER-RIGHT: blue 0.5pt solid" class=xl64 width=43>C Alloc</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: lime; WIDTH: 29pt; BORDER-TOP: blue 0.5pt solid; BORDER-RIGHT: blue 0.5pt solid" class=xl64 width=39>C Diff</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl65 height=20>name1</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl66 align=right>0.40 </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl66 align=right>0.40 </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl66 align=right>0.00 </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl66 align=right>0.30 </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl66 align=right>0.60 </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl66 align=right>0.30 </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl66 align=right>0.30 </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl66 align=right>0.00 </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl66 align=right>(0.30)</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl65 height=20>name2</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl66 align=right>0.00 </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl66 align=right>0.00 </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl66 align=right>0.00 </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl66 align=right>0.25 </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl66 align=right>0.20 </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl66 align=right>(0.05)</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl66 align=right>0.75 </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl66 align=right>0.80 </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl66 align=right>0.05 </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl65 height=20>name3</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl66 align=right>0.35 </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl66 align=right>0.25 </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl66 align=right>(0.10)</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl66 align=right>0.10 </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl66 align=right>0.75 </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl66 align=right>0.65 </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl66 align=right>0.55 </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl66 align=right>0.00 </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl66 align=right>(0.55)</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl65 height=20>name4</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl66 align=right>1.00 </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl66 align=right>1.00 </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl66 align=right>0.00 </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl66 align=right>0.00 </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl66 align=right>0.00 </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl66 align=right>0.00 </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl66 align=right>0.00 </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl66 align=right>0.00 </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl66 align=right>0.00 </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl65 height=20>name5</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl66 align=right>0.75 </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl66 align=right>0.25 </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl66 align=right>(0.50)</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl66 align=right>0.25 </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl66 align=right>0.00 </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl66 align=right>(0.25)</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl66 align=right>0.00 </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl66 align=right>0.75 </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl66 align=right>0.75 </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl65 height=20>name6</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl66 align=right>0.00 </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl66 align=right>0.00 </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl66 align=right>0.00 </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl66 align=right>0.00 </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl66 align=right>0.00 </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl66 align=right>0.00 </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl66 align=right>1.00 </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl66 align=right>1.00 </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl66 align=right>0.00 </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl65 height=20>name7</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl66 align=right>0.00 </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl66 align=right>0.00 </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl66 align=right>0.00 </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl66 align=right>0.00 </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl66 align=right>0.00 </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl66 align=right>0.00 </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl66 align=right>1.00 </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl66 align=right>1.00 </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl66 align=right>0.00 </TD></TR></TBODY></TABLE>

I did a formula that would sum if A diff was less than 0 and C diff was greater than 0 but I am getting thrown off by Bdiff receiving a portion of adiff. I tried to subtract a sumif the bdiff was greater than 0, but it just gave me the wrong number.

Any help would be appreciated. So far I have tried sumifs, If/And and that's about it. Currently I am using an if statement to pull whether a number is positive or negative and manually saying whether and of the types gave or received and totalling those out, which is tedious and terribly inaccurate.

 

[GlennUK]

It sounds like you just want to sum the flows of all of either:
A flow into/from C
A flow into/from B
B flow into/from C
... so why not have 3 columns for these differences, and you then sum easily.

 

[nsharonew]

I am not too sure if I completely understand. Currently, as I mentioned, I am using if statements in 6 columns, this will show the amount and whether it's the giver or the receiver and manually entering which category gave an amount to another. See below.

<TABLE style="WIDTH: 383pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=509><COLGROUP><COL style="WIDTH: 81pt; mso-width-source: userset; mso-width-alt: 3949" width=108><COL style="WIDTH: 43pt; mso-width-source: userset; mso-width-alt: 2084" width=57><COL style="WIDTH: 37pt; mso-width-source: userset; mso-width-alt: 1792" width=49><COL style="WIDTH: 40pt; mso-width-source: userset; mso-width-alt: 1938" width=53><COL style="WIDTH: 44pt; mso-width-source: userset; mso-width-alt: 2121" width=58><COL style="WIDTH: 37pt; mso-width-source: userset; mso-width-alt: 1792" width=49><COL style="WIDTH: 34pt; mso-width-source: userset; mso-width-alt: 1645" width=45><COL style="WIDTH: 35pt; mso-width-source: userset; mso-width-alt: 1718" width=47><COL style="WIDTH: 32pt; mso-width-source: userset; mso-width-alt: 1572" width=43><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 81pt; HEIGHT: 15pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: blue 0.5pt solid" class=xl63 height=20 width=108>A give</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; WIDTH: 43pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: blue 0.5pt solid" class=xl64 width=57>B Give</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; WIDTH: 37pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: blue 0.5pt solid" class=xl64 width=49>C Give</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; WIDTH: 40pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: blue 0.5pt solid" class=xl64 width=53>A Rec</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; WIDTH: 44pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: blue 0.5pt solid" class=xl64 width=58>B Rec</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; WIDTH: 37pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: blue 0.5pt solid" class=xl64 width=49>C Rec</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; WIDTH: 34pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: blue 0.5pt solid" class=xl64 width=45>Giver</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; WIDTH: 35pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: blue 0.5pt solid" class=xl65 width=47>Amt</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; WIDTH: 32pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: blue 0.5pt solid" class=xl65 width=43>Rec.</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl66 height=20> </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl67> </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl67 align=right>-0.3</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl67> </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl67 align=right>0.3</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl67> </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl68>C</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl69>0.3</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl70>B</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl66 height=20> </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl67 align=right>-0.05</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl67> </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl67> </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl67> </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl67 align=right>0.05</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl68>B</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl69>0.05</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl70>C</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl66 height=20 align=right>-0.1</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl67> </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl67 align=right>-0.55</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl67> </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl67 align=right>0.65</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl67> </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl68>A</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl69>0.1</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl70>B</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl66 height=20> </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl67> </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl67> </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl67> </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl67> </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl67> </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl68>C</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl69>0.55</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: blue 0.5pt solid" class=xl71>B</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl66 height=20 align=right>-0.5</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl67 align=right>-0.25</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl67> </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl67> </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl67> </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl67 align=right>0.75</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl68>A</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl69>0.5</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue 0.5pt solid; BORDER-RIGHT: blue 0.5pt solid" class=xl70>C</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl66 height=20> </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl67> </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl67> </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl67> </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl67> </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl67> </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl68>B</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl69>0.25</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: blue 0.5pt solid" class=xl71>C</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl66 height=20 align=right>-0.25</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl67 align=right>-0.25</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl67> </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl67> </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl67> </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl67 align=right>0.5</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl68>A</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl69>0.25</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue 0.5pt solid; BORDER-RIGHT: blue 0.5pt solid" class=xl70>C</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl66 height=20> </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl67> </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl67> </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl67> </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl67> </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl67> </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl68>B</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl69>0.25</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: blue 0.5pt solid" class=xl71>C</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl66 height=20> </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl67 align=right>-0.5</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl67> </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl67> </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl67> </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl67 align=right>0.5</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl68>B</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl69>0.5</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue 0.5pt solid; BORDER-RIGHT: blue 0.5pt solid" class=xl70>C</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl66 height=20 align=right>-0.1</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl67> </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl67 align=right>-0.55</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl67> </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl67 align=right>0.65</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl67> </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl68>A</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl69>0.1</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl70>B</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl66 height=20> </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl67> </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl67> </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl67> </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl67> </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl67> </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl68>C</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl69>0.55</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: blue 0.5pt solid" class=xl72>B</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl66 height=20> </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl67> </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl67 align=right>-1</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl67 align=right>0.75</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl67 align=right>0.25</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl67> </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl68>C</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl69>0.75</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl70>A</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl66 height=20> </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl67> </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl67> </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl67> </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl67> </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl67> </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl68>C</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl69>0.25</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: blue 0.5pt solid" class=xl71>B</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl66 height=20 align=right>-0.05</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl67> </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl67 align=right>-0.45</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl67> </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl67> </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl67> </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl68>A</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl69>0.05</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue 0.5pt solid; BORDER-RIGHT: blue 0.5pt solid" class=xl70>U</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl66 height=20> </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl67> </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl67> </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl67> </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl67> </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl67> </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl68>C</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl69>0.45</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: blue 0.5pt solid" class=xl71>U</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl66 height=20> </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl67 align=right>-0.5</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl67 align=right>-0.5</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl67 align=right>0.5</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl67> </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl67> </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl68>B</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl69>0.5</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue 0.5pt solid; BORDER-RIGHT: blue 0.5pt solid" class=xl70>A</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl66 height=20> </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl67> </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl67> </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl67> </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl67> </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl67> </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl68>C</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl69>0.5</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: blue 0.5pt solid" class=xl71>U</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl66 height=20 align=right>-0.25</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl67> </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl67> </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl67> </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl67> </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl67 align=right>0.25</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl68>A</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl69>0.25</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue 0.5pt solid; BORDER-RIGHT: blue 0.5pt solid" class=xl70>C</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl66 height=20 align=right>-0.1</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl67 align=right>-0.4</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl67> </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl67> </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl67> </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl67 align=right>0.5</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl68>A</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl69>0.1</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl70>C</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl66 height=20> </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl67> </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl67> </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl67> </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl67> </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl67> </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl68>B</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl69>0.4</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: blue 0.5pt solid" class=xl71>C</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl66 height=20> </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl67 align=right>-0.95</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl67> </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl67> </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl67> </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl67 align=right>0.95</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl68>B</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl69>0.95</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: transparent; BORDER-TOP: blue 0.5pt solid; BORDER-RIGHT: blue 0.5pt solid" class=xl70>C</TD></TR></TBODY></TABLE>

As shown, it has a clean look, it's just the entry that causes issues since I sometimes fatfinger and type in the wrong number. I have no problem after I finish the entry to get the numbers with a sumif, it's just the entry I am trying to avoid, it takes a long time and is often times inaccurate.

Thanks!

 

[GlennUK]

I was suggesting using formulas, like this:

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K	L	M
1	Resource Name	A Plan	A Alloc.	A Diff	B Plan	B Alloc	Bdiff	C Plan	C Alloc	C Diff	A/C flow	A/B Flow	B/C Flow
2	name1	0.4	0.4	0.00	0.3	0.6	0.30	0.3	0	-0.30	0	0	0.3
3	name2	0	0	0.00	0.25	0.2	-0.05	0.75	0.8	0.05	0	0	-0.05
4	name3	0.35	0.25	-0.10	0.1	0.75	0.65	0.55	0	-0.55	0	-0.1	0.55
5	name4	1	1	0.00	0	0	0.00	0	0	0.00	0	0	0
6	name5	0.75	0.25	-0.50	0.25	0	-0.25	0	0.75	0.75	-0.5	0	-0.25
7	name6	0	0	0.00	0	0	0.00	1	1	0.00	0	0	0
8	name7	0	0	0.00	0	0	0.00	1	1	0.00	0	0	0
Sheet1

The flows can be positive or negative in each of the 3 flow columns, depending on who is giving and who is receiving. There can be more than one flow happening per row. ( as can be seen in your original example ).

 

[nsharonew]

Wow! I will give it a try! Thanks so much!