Need help creating a custom column in power query to mimic this excel formula

[jag2005]

Hello - I need help creating a custom column in power query to mimic this excel formula.
=IF(s2<>s1,Ab2+Ad2,Ai1+Ad2)

Thanks in advance!
Josh

 

[sandy666]

is that what you want?

[Table="width:, class:head"]
[tr=bgcolor:#FFFFFF][td=bgcolor:#5B9BD5]S[/td][td=bgcolor:#5B9BD5]AB[/td][td=bgcolor:#5B9BD5]AD[/td][td=bgcolor:#5B9BD5]AI[/td][td][/td][td=bgcolor:#70AD47]S[/td][td=bgcolor:#70AD47]AB[/td][td=bgcolor:#70AD47]AD[/td][td=bgcolor:#70AD47]AI[/td][td=bgcolor:#70AD47]IF[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#DDEBF7]

1​

[/td][td=bgcolor:#DDEBF7]

11​

[/td][td=bgcolor:#DDEBF7]

21​

[/td][td=bgcolor:#DDEBF7]

7​

[/td][td][/td][td=bgcolor:#E2EFDA]

1​

[/td][td=bgcolor:#E2EFDA]

11​

[/td][td=bgcolor:#E2EFDA]

21​

[/td][td=bgcolor:#E2EFDA]

7​

[/td][td=bgcolor:#E2EFDA]

34​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]

2​

[/td][td]

12​

[/td][td]

22​

[/td][td]

7​

[/td][td][/td][td]

2​

[/td][td]

12​

[/td][td]

22​

[/td][td]

7​

[/td][td]

36​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#DDEBF7]

3​

[/td][td=bgcolor:#DDEBF7]

13​

[/td][td=bgcolor:#DDEBF7]

23​

[/td][td=bgcolor:#DDEBF7]

7​

[/td][td][/td][td=bgcolor:#E2EFDA]

3​

[/td][td=bgcolor:#E2EFDA]

13​

[/td][td=bgcolor:#E2EFDA]

23​

[/td][td=bgcolor:#E2EFDA]

7​

[/td][td=bgcolor:#E2EFDA]

31​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]

3​

[/td][td]

14​

[/td][td]

24​

[/td][td]

7​

[/td][td][/td][td]

3​

[/td][td]

14​

[/td][td]

24​

[/td][td]

7​

[/td][td]

40​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#DDEBF7]

4​

[/td][td=bgcolor:#DDEBF7]

15​

[/td][td=bgcolor:#DDEBF7]

25​

[/td][td=bgcolor:#DDEBF7]

7​

[/td][td][/td][td=bgcolor:#E2EFDA]

4​

[/td][td=bgcolor:#E2EFDA]

15​

[/td][td=bgcolor:#E2EFDA]

25​

[/td][td=bgcolor:#E2EFDA]

7​

[/td][td=bgcolor:#E2EFDA]

42​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]

5​

[/td][td]

16​

[/td][td]

26​

[/td][td]

7​

[/td][td][/td][td]

5​

[/td][td]

16​

[/td][td]

26​

[/td][td]

7​

[/td][td]

34​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#DDEBF7]

5​

[/td][td=bgcolor:#DDEBF7]

17​

[/td][td=bgcolor:#DDEBF7]

27​

[/td][td=bgcolor:#DDEBF7]

7​

[/td][td][/td][td=bgcolor:#E2EFDA]

5​

[/td][td=bgcolor:#E2EFDA]

17​

[/td][td=bgcolor:#E2EFDA]

27​

[/td][td=bgcolor:#E2EFDA]

7​

[/td][td=bgcolor:#E2EFDA]

46​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]

6​

[/td][td]

18​

[/td][td]

28​

[/td][td]

7​

[/td][td][/td][td]

6​

[/td][td]

18​

[/td][td]

28​

[/td][td]

7​

[/td][td]

48​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#DDEBF7]

7​

[/td][td=bgcolor:#DDEBF7]

19​

[/td][td=bgcolor:#DDEBF7]

29​

[/td][td=bgcolor:#DDEBF7]

7​

[/td][td][/td][td=bgcolor:#E2EFDA]

7​

[/td][td=bgcolor:#E2EFDA]

19​

[/td][td=bgcolor:#E2EFDA]

29​

[/td][td=bgcolor:#E2EFDA]

7​

[/td][td=bgcolor:#E2EFDA][/td][/tr]
[/table]

 

[jag2005]

Hi sandy666,

Here's a real example. Column AI is a running total of inventory quantity onhand. Then it restarts calculating when the item # changes.
https://docs.google.com/spreadsheet...cKLzH5bEVaO0OWLGO-q/pubhtml?gid=0&single=true

 

[sandy666]

sorry mate, I am not working with any google sheet. post link to downloadable excel file

 

[jag2005]

Hi - sorry about that. I dont see the option to attach a excel document in this site nor does my work network allow me to share this file outside of onedrive. thoughts?

 

[sandy666]

try http://tinyupload.com/

 

[jag2005]

<!-- Please do not remove this header -->
<!-- Table easily created from Excel with ASAP Utilities (http://www.asap-utilities.com) -->
<table border="1" bordercolor="#C0C0C0" bordercolordark="#FFFFFF" cellpadding="0">
<tr>
<td bgcolor="#70AD47" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#FFFFFF"><b>Item</b></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#70AD47" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#FFFFFF"><b>Location On Hand</b></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#70AD47" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#FFFFFF"><b>Qty +/-</b></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#70AD47" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#FFFFFF">IF(S2<>S1,AB2+AD2,AI1+AD2)</font></td>
</tr>
<tr>
<td bgcolor="#FFF2CC" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">10043-001</font></td>
<td bgcolor="#FFF2CC" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFF2CC" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFF2CC" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFF2CC" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFF2CC" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFF2CC" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFF2CC" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFF2CC" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFF2CC" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">32</font></td>
<td bgcolor="#FFF2CC" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFF2CC" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">-4</font></td>
<td bgcolor="#FFF2CC" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFF2CC" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFF2CC" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFF2CC" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFF2CC" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">28</font></td>
</tr>
<tr>
<td bgcolor="#FFF2CC" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">10043-001</font></td>
<td bgcolor="#FFF2CC" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFF2CC" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFF2CC" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFF2CC" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFF2CC" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFF2CC" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFF2CC" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFF2CC" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFF2CC" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">32</font></td>
<td bgcolor="#FFF2CC" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFF2CC" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">-4</font></td>
<td bgcolor="#FFF2CC" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFF2CC" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFF2CC" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFF2CC" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFF2CC" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">24</font></td>
</tr>
<tr>
<td bgcolor="#FFF2CC" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">10043-001</font></td>
<td bgcolor="#FFF2CC" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFF2CC" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFF2CC" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFF2CC" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFF2CC" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFF2CC" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFF2CC" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFF2CC" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFF2CC" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">32</font></td>
<td bgcolor="#FFF2CC" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFF2CC" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">-4</font></td>
<td bgcolor="#FFF2CC" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFF2CC" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFF2CC" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFF2CC" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFF2CC" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">20</font></td>
</tr>
<tr>
<td bgcolor="#FFF2CC" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">10043-001</font></td>
<td bgcolor="#FFF2CC" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFF2CC" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFF2CC" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFF2CC" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFF2CC" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFF2CC" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFF2CC" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFF2CC" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFF2CC" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">32</font></td>
<td bgcolor="#FFF2CC" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFF2CC" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">-4</font></td>
<td bgcolor="#FFF2CC" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFF2CC" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFF2CC" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFF2CC" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFF2CC" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">16</font></td>
</tr>
<tr>
<td bgcolor="#FFF2CC" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">10043-001</font></td>
<td bgcolor="#FFF2CC" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFF2CC" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFF2CC" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFF2CC" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFF2CC" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFF2CC" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFF2CC" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFF2CC" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFF2CC" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">32</font></td>
<td bgcolor="#FFF2CC" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFF2CC" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">-4</font></td>
<td bgcolor="#FFF2CC" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFF2CC" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFF2CC" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFF2CC" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFF2CC" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">12</font></td>
</tr>
<tr>
<td bgcolor="#FFF2CC" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">10043-001</font></td>
<td bgcolor="#FFF2CC" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFF2CC" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFF2CC" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFF2CC" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFF2CC" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFF2CC" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFF2CC" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFF2CC" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFF2CC" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">32</font></td>
<td bgcolor="#FFF2CC" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFF2CC" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">-4</font></td>
<td bgcolor="#FFF2CC" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFF2CC" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFF2CC" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFF2CC" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFF2CC" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">8</font></td>
</tr>
<tr>
<td bgcolor="#FFF2CC" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">10043-001</font></td>
<td bgcolor="#FFF2CC" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFF2CC" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFF2CC" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFF2CC" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFF2CC" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFF2CC" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFF2CC" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFF2CC" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFF2CC" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">32</font></td>
<td bgcolor="#FFF2CC" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFF2CC" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">-4</font></td>
<td bgcolor="#FFF2CC" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFF2CC" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFF2CC" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFF2CC" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFF2CC" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">4</font></td>
</tr>
<tr>
<td bgcolor="#FFF2CC" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">10043-001</font></td>
<td bgcolor="#FFF2CC" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFF2CC" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFF2CC" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFF2CC" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFF2CC" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFF2CC" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFF2CC" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFF2CC" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFF2CC" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">32</font></td>
<td bgcolor="#FFF2CC" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFF2CC" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">-4</font></td>
<td bgcolor="#FFF2CC" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFF2CC" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFF2CC" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFF2CC" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFF2CC" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">0</font></td>
</tr>
<tr>
<td bgcolor="#D0E0E3" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">10044-001</font></td>
<td bgcolor="#D0E0E3" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#D0E0E3" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#D0E0E3" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#D0E0E3" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#D0E0E3" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#D0E0E3" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#D0E0E3" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#D0E0E3" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#D0E0E3" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">32</font></td>
<td bgcolor="#D0E0E3" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#D0E0E3" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">-4</font></td>
<td bgcolor="#D0E0E3" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#D0E0E3" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#D0E0E3" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#D0E0E3" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#D0E0E3" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">28</font></td>
</tr>
<tr>
<td bgcolor="#D0E0E3" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">10044-001</font></td>
<td bgcolor="#D0E0E3" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#D0E0E3" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#D0E0E3" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#D0E0E3" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#D0E0E3" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#D0E0E3" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#D0E0E3" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#D0E0E3" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#D0E0E3" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">32</font></td>
<td bgcolor="#D0E0E3" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#D0E0E3" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">-4</font></td>
<td bgcolor="#D0E0E3" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#D0E0E3" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#D0E0E3" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#D0E0E3" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#D0E0E3" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">24</font></td>
</tr>
<tr>
<td bgcolor="#D0E0E3" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">10044-001</font></td>
<td bgcolor="#D0E0E3" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#D0E0E3" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#D0E0E3" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#D0E0E3" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#D0E0E3" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#D0E0E3" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#D0E0E3" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#D0E0E3" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#D0E0E3" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">32</font></td>
<td bgcolor="#D0E0E3" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#D0E0E3" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">-4</font></td>
<td bgcolor="#D0E0E3" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#D0E0E3" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#D0E0E3" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#D0E0E3" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#D0E0E3" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">20</font></td>
</tr>
<tr>
<td bgcolor="#D0E0E3" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">10044-001</font></td>
<td bgcolor="#D0E0E3" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#D0E0E3" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#D0E0E3" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#D0E0E3" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#D0E0E3" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#D0E0E3" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#D0E0E3" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#D0E0E3" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#D0E0E3" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">32</font></td>
<td bgcolor="#D0E0E3" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#D0E0E3" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">-4</font></td>
<td bgcolor="#D0E0E3" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#D0E0E3" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#D0E0E3" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#D0E0E3" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#D0E0E3" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">16</font></td>
</tr>
<tr>
<td bgcolor="#D0E0E3" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">10044-001</font></td>
<td bgcolor="#D0E0E3" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#D0E0E3" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#D0E0E3" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#D0E0E3" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#D0E0E3" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#D0E0E3" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#D0E0E3" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#D0E0E3" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#D0E0E3" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">32</font></td>
<td bgcolor="#D0E0E3" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#D0E0E3" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">-4</font></td>
<td bgcolor="#D0E0E3" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#D0E0E3" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#D0E0E3" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#D0E0E3" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#D0E0E3" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">12</font></td>
</tr>
<tr>
<td bgcolor="#D0E0E3" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">10044-001</font></td>
<td bgcolor="#D0E0E3" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#D0E0E3" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#D0E0E3" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#D0E0E3" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#D0E0E3" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#D0E0E3" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#D0E0E3" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#D0E0E3" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#D0E0E3" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">32</font></td>
<td bgcolor="#D0E0E3" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#D0E0E3" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">-4</font></td>
<td bgcolor="#D0E0E3" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#D0E0E3" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#D0E0E3" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#D0E0E3" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#D0E0E3" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">8</font></td>
</tr>
<tr>
<td bgcolor="#D0E0E3" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">10044-001</font></td>
<td bgcolor="#D0E0E3" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#D0E0E3" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#D0E0E3" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#D0E0E3" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#D0E0E3" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#D0E0E3" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#D0E0E3" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#D0E0E3" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#D0E0E3" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">32</font></td>
<td bgcolor="#D0E0E3" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#D0E0E3" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">-4</font></td>
<td bgcolor="#D0E0E3" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#D0E0E3" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#D0E0E3" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#D0E0E3" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#D0E0E3" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">4</font></td>
</tr>
<tr>
<td bgcolor="#D0E0E3" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">10044-001</font></td>
<td bgcolor="#D0E0E3" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#D0E0E3" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#D0E0E3" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#D0E0E3" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#D0E0E3" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#D0E0E3" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#D0E0E3" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#D0E0E3" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#D0E0E3" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">32</font></td>
<td bgcolor="#D0E0E3" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#D0E0E3" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">-4</font></td>
<td bgcolor="#D0E0E3" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#D0E0E3" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#D0E0E3" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#D0E0E3" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#D0E0E3" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">0</font></td>
</tr>
<tr>
<td bgcolor="#C9DAF8" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">10080-001</font></td>
<td bgcolor="#C9DAF8" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#C9DAF8" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#C9DAF8" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#C9DAF8" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#C9DAF8" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#C9DAF8" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#C9DAF8" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#C9DAF8" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#C9DAF8" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">80</font></td>
<td bgcolor="#C9DAF8" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#C9DAF8" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">-10</font></td>
<td bgcolor="#C9DAF8" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#C9DAF8" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#C9DAF8" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#C9DAF8" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#C9DAF8" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">70</font></td>
</tr>
<tr>
<td bgcolor="#C9DAF8" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">10080-001</font></td>
<td bgcolor="#C9DAF8" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#C9DAF8" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#C9DAF8" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#C9DAF8" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#C9DAF8" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#C9DAF8" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#C9DAF8" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#C9DAF8" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#C9DAF8" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">80</font></td>
<td bgcolor="#C9DAF8" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#C9DAF8" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">-10</font></td>
<td bgcolor="#C9DAF8" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#C9DAF8" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#C9DAF8" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#C9DAF8" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#C9DAF8" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">60</font></td>
</tr>
<tr>
<td bgcolor="#C9DAF8" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">10080-001</font></td>
<td bgcolor="#C9DAF8" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#C9DAF8" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#C9DAF8" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#C9DAF8" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#C9DAF8" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#C9DAF8" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#C9DAF8" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#C9DAF8" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#C9DAF8" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">80</font></td>
<td bgcolor="#C9DAF8" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#C9DAF8" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">-10</font></td>
<td bgcolor="#C9DAF8" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#C9DAF8" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#C9DAF8" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#C9DAF8" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#C9DAF8" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">50</font></td>
</tr>
<tr>
<td bgcolor="#C9DAF8" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">10080-001</font></td>
<td bgcolor="#C9DAF8" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#C9DAF8" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#C9DAF8" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#C9DAF8" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#C9DAF8" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#C9DAF8" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#C9DAF8" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#C9DAF8" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#C9DAF8" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">80</font></td>
<td bgcolor="#C9DAF8" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#C9DAF8" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">-10</font></td>
<td bgcolor="#C9DAF8" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#C9DAF8" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#C9DAF8" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#C9DAF8" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#C9DAF8" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">40</font></td>
</tr>
<tr>
<td bgcolor="#C9DAF8" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">10080-001</font></td>
<td bgcolor="#C9DAF8" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#C9DAF8" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#C9DAF8" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#C9DAF8" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#C9DAF8" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#C9DAF8" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#C9DAF8" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#C9DAF8" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#C9DAF8" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">80</font></td>
<td bgcolor="#C9DAF8" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#C9DAF8" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">-10</font></td>
<td bgcolor="#C9DAF8" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#C9DAF8" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#C9DAF8" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#C9DAF8" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#C9DAF8" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">30</font></td>
</tr>
<tr>
<td bgcolor="#C9DAF8" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">10080-001</font></td>
<td bgcolor="#C9DAF8" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#C9DAF8" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#C9DAF8" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#C9DAF8" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#C9DAF8" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#C9DAF8" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#C9DAF8" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#C9DAF8" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#C9DAF8" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">80</font></td>
<td bgcolor="#C9DAF8" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#C9DAF8" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">-10</font></td>
<td bgcolor="#C9DAF8" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#C9DAF8" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#C9DAF8" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#C9DAF8" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#C9DAF8" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">20</font></td>
</tr>
<tr>
<td bgcolor="#C9DAF8" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">10080-001</font></td>
<td bgcolor="#C9DAF8" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#C9DAF8" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#C9DAF8" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#C9DAF8" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#C9DAF8" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#C9DAF8" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#C9DAF8" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#C9DAF8" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#C9DAF8" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">80</font></td>
<td bgcolor="#C9DAF8" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#C9DAF8" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">-10</font></td>
<td bgcolor="#C9DAF8" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#C9DAF8" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#C9DAF8" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#C9DAF8" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#C9DAF8" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">10</font></td>
</tr>
<tr>
<td bgcolor="#C9DAF8" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">10080-001</font></td>
<td bgcolor="#C9DAF8" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#C9DAF8" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#C9DAF8" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#C9DAF8" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#C9DAF8" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#C9DAF8" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#C9DAF8" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#C9DAF8" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#C9DAF8" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">80</font></td>
<td bgcolor="#C9DAF8" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#C9DAF8" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">-10</font></td>
<td bgcolor="#C9DAF8" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#C9DAF8" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#C9DAF8" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#C9DAF8" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#C9DAF8" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">0</font></td>
</tr>
</table>

 

[jag2005]

http://s000.tinyupload.com/?file_id=83522450265736319271

 

[sandy666]

Here is example: file

---
Thanks MarcelBeug

 

[jag2005]

Thank you for your help. I tried to add what you provided but i was getting all different types of errors.


Here's what I'm trying to add to. The below combines two tables and sorts accordingly to setup the running total I'm looking for.

let
Source = Table.Combine({#"Deamand&Supply", PlannedSupply}),
#"Renamed Columns" = Table.RenameColumns(Source,{{"*Date Start/Expected", "Date Start/Expected"}, {"*Item", "Item"}}),
#"Filtered Rows" = Table.SelectRows(#"Renamed Columns", each true),
#"Replaced Value" = Table.ReplaceValue(#"Filtered Rows",null,"PlannedPO",Replacer.ReplaceValue,{"Document #"}),
#"Sorted Rows" = Table.Sort(#"Replaced Value",{{"Item", Order.Ascending}, {"Date Start/Expected", Order.Ascending}, {"*Type", Order.Descending}})

in
#"Sorted Rows"