Find string, do calculation

wibni · Jun 15, 2011

Hi,

I'm very new to Excel VBA and got a challenge which I'm not sure how to start with.
The below spreadsheet is generated by our financial system
The top 3 rows are code from the financial reporter.
Starting at row 6 is the output.

I need to do calculations with these results which can't be done by in a formula I'm afraid, so has to be VBA.

What I'm trying to achieve is to distribute the values under SiteBalance (column P) accross rows that belong in the same category.
For example the $20,914 in column P needs to be distributed accross all rows which have the same Country, AccSegment and Site.
So for that example it $20,914 needs to be divided by 6 because there are 6 accounts which match the criteria above (Country = 94, AccSegment = 5111 and Site = GGM).

Could someone please advise how to achieve this in VBA? i would actually prefer an Excel formula but don't think that can be done.

Any help much appreciated.

<table bordercolordark="#FFFFFF" border="1" bordercolor="#C0C0C0" cellpadding="2" cellspacing="0"> <tbody><tr> <td style="white-space: nowrap">E</td> <td style="white-space: nowrap">J</td> <td style="white-space: nowrap">K</td> <td style="white-space: nowrap">L</td> <td style="white-space: nowrap">M</td> <td style="white-space: nowrap">N</td> <td style="white-space: nowrap">O</td> <td style="white-space: nowrap">P</td> <td style="white-space: nowrap">Q</td> </tr> <tr> <td style="white-space: nowrap">AcctID</td> <td style="white-space: nowrap">Country</td> <td style="white-space: nowrap">AccSegment</td> <td style="white-space: nowrap">ManCo</td> <td style="white-space: nowrap">RigSite</td> <td style="white-space: nowrap">Site</td> <td style="white-space: nowrap">Current Period</td> <td style="white-space: nowrap">SiteBalance</td> <td style="white-space: nowrap">
</td> </tr> <tr> <td style="white-space: nowrap">#NAME?</td> <td style="white-space: nowrap">#NAME?</td> <td style="white-space: nowrap">#NAME?</td> <td style="white-space: nowrap">#NAME?</td> <td style="white-space: nowrap">#NAME?</td> <td style="white-space: nowrap">#NAME?</td> <td style="white-space: nowrap">#NAME?</td> <td style="white-space: nowrap">#NAME?</td> <td style="white-space: nowrap">
</td> </tr> <tr> <td style="white-space: nowrap">\</td> <td style="white-space: nowrap">\</td> <td style="white-space: nowrap">\</td> <td style="white-space: nowrap">\</td> <td style="white-space: nowrap">\</td> <td style="white-space: nowrap">\</td> <td style="white-space: nowrap">\</td> <td style="white-space: nowrap">\</td> <td style="white-space: nowrap">
</td> </tr> <tr> <td style="white-space: nowrap">
</td> <td style="white-space: nowrap">
</td> <td style="white-space: nowrap">
</td> <td style="white-space: nowrap">
</td> <td style="white-space: nowrap">
</td> <td style="white-space: nowrap">
</td> <td style="white-space: nowrap">
</td> <td style="white-space: nowrap">
</td> <td style="white-space: nowrap">
</td> </tr> <tr> <td style="white-space: nowrap">
</td> <td style="white-space: nowrap">
</td> <td style="white-space: nowrap">
</td> <td style="white-space: nowrap">
</td> <td style="white-space: nowrap">
</td> <td style="white-space: nowrap">
</td> <td style="white-space: nowrap">
</td> <td style="white-space: nowrap">
</td> <td style="white-space: nowrap">
</td> </tr> <tr> <td style="white-space: nowrap">AcctID</td> <td style="white-space: nowrap">Country</td> <td style="white-space: nowrap">AccSegment</td> <td style="white-space: nowrap">ManCo</td> <td style="white-space: nowrap">RigSite</td> <td style="white-space: nowrap">Site</td> <td style="white-space: nowrap">Current Period</td> <td style="white-space: nowrap">SiteBalance</td> <td style="white-space: nowrap">Reallocation</td> </tr> <tr> <td style="white-space: nowrap">10-4110-008</td> <td style="white-space: nowrap">10</td> <td style="white-space: nowrap">4110</td> <td style="white-space: nowrap">10</td> <td style="white-space: nowrap">008</td> <td style="white-space: nowrap">GGM</td> <td style="white-space: nowrap">-208,985</td> <td style="white-space: nowrap">0</td> <td style="white-space: nowrap">
</td> </tr> <tr> <td style="white-space: nowrap">10-4110-028</td> <td style="white-space: nowrap">10</td> <td style="white-space: nowrap">4110</td> <td style="white-space: nowrap">10</td> <td style="white-space: nowrap">028</td> <td style="white-space: nowrap">GGM</td> <td style="white-space: nowrap">-174,000</td> <td style="white-space: nowrap">0</td> <td style="white-space: nowrap">
</td> </tr> <tr> <td style="white-space: nowrap">10-4110-038</td> <td style="white-space: nowrap">10</td> <td style="white-space: nowrap">4110</td> <td style="white-space: nowrap">10</td> <td style="white-space: nowrap">038</td> <td style="white-space: nowrap">GGM</td> <td style="white-space: nowrap">-242,657</td> <td style="white-space: nowrap">0</td> <td style="white-space: nowrap">
</td> </tr> <tr> <td style="white-space: nowrap">10-4110-055</td> <td style="white-space: nowrap">10</td> <td style="white-space: nowrap">4110</td> <td style="white-space: nowrap">10</td> <td style="white-space: nowrap">055</td> <td style="white-space: nowrap">GGM</td> <td style="white-space: nowrap">-210,230</td> <td style="white-space: nowrap">0</td> <td style="white-space: nowrap">
</td> </tr> <tr> <td style="white-space: nowrap">10-4110-066</td> <td style="white-space: nowrap">10</td> <td style="white-space: nowrap">4110</td> <td style="white-space: nowrap">10</td> <td style="white-space: nowrap">066</td> <td style="white-space: nowrap">GGM</td> <td style="white-space: nowrap">-221,175</td> <td style="white-space: nowrap">0</td> <td style="white-space: nowrap">
</td> </tr> <tr> <td style="white-space: nowrap">10-4110-073</td> <td style="white-space: nowrap">10</td> <td style="white-space: nowrap">4110</td> <td style="white-space: nowrap">10</td> <td style="white-space: nowrap">073</td> <td style="white-space: nowrap">GGM</td> <td style="white-space: nowrap">-240,455</td> <td style="white-space: nowrap">0</td> <td style="white-space: nowrap">
</td> </tr> <tr> <td style="white-space: nowrap">10-4420-008</td> <td style="white-space: nowrap">10</td> <td style="white-space: nowrap">4420</td> <td style="white-space: nowrap">10</td> <td style="white-space: nowrap">008</td> <td style="white-space: nowrap">GGM</td> <td style="white-space: nowrap">-3,747</td> <td style="white-space: nowrap">0</td> <td style="white-space: nowrap">
</td> </tr> <tr> <td style="white-space: nowrap">10-4420-028</td> <td style="white-space: nowrap">10</td> <td style="white-space: nowrap">4420</td> <td style="white-space: nowrap">10</td> <td style="white-space: nowrap">028</td> <td style="white-space: nowrap">GGM</td> <td style="white-space: nowrap">-16,975</td> <td style="white-space: nowrap">0</td> <td style="white-space: nowrap">
</td> </tr> <tr> <td style="white-space: nowrap">10-4420-055</td> <td style="white-space: nowrap">10</td> <td style="white-space: nowrap">4420</td> <td style="white-space: nowrap">10</td> <td style="white-space: nowrap">055</td> <td style="white-space: nowrap">GGM</td> <td style="white-space: nowrap">-3,747</td> <td style="white-space: nowrap">0</td> <td style="white-space: nowrap">
</td> </tr> <tr> <td style="white-space: nowrap">10-4420-066</td> <td style="white-space: nowrap">10</td> <td style="white-space: nowrap">4420</td> <td style="white-space: nowrap">10</td> <td style="white-space: nowrap">066</td> <td style="white-space: nowrap">GGM</td> <td style="white-space: nowrap">-3,747</td> <td style="white-space: nowrap">0</td> <td style="white-space: nowrap">
</td> </tr> <tr> <td style="white-space: nowrap">10-4430-008</td> <td style="white-space: nowrap">10</td> <td style="white-space: nowrap">4430</td> <td style="white-space: nowrap">10</td> <td style="white-space: nowrap">008</td> <td style="white-space: nowrap">GGM</td> <td style="white-space: nowrap">-17,138</td> <td style="white-space: nowrap">0</td> <td style="white-space: nowrap">
</td> </tr> <tr> <td style="white-space: nowrap">10-4430-028</td> <td style="white-space: nowrap">10</td> <td style="white-space: nowrap">4430</td> <td style="white-space: nowrap">10</td> <td style="white-space: nowrap">028</td> <td style="white-space: nowrap">GGM</td> <td style="white-space: nowrap">-5,302</td> <td style="white-space: nowrap">0</td> <td style="white-space: nowrap">
</td> </tr> <tr> <td style="white-space: nowrap">10-4430-038</td> <td style="white-space: nowrap">10</td> <td style="white-space: nowrap">4430</td> <td style="white-space: nowrap">10</td> <td style="white-space: nowrap">038</td> <td style="white-space: nowrap">GGM</td> <td style="white-space: nowrap">-247</td> <td style="white-space: nowrap">0</td> <td style="white-space: nowrap">
</td> </tr> <tr> <td style="white-space: nowrap">10-4430-055</td> <td style="white-space: nowrap">10</td> <td style="white-space: nowrap">4430</td> <td style="white-space: nowrap">10</td> <td style="white-space: nowrap">055</td> <td style="white-space: nowrap">GGM</td> <td style="white-space: nowrap">-15,740</td> <td style="white-space: nowrap">0</td> <td style="white-space: nowrap">
</td> </tr> <tr> <td style="white-space: nowrap">10-4430-066</td> <td style="white-space: nowrap">10</td> <td style="white-space: nowrap">4430</td> <td style="white-space: nowrap">10</td> <td style="white-space: nowrap">066</td> <td style="white-space: nowrap">GGM</td> <td style="white-space: nowrap">-18,363</td> <td style="white-space: nowrap">0</td> <td style="white-space: nowrap">
</td> </tr> <tr> <td style="white-space: nowrap">10-4430-073</td> <td style="white-space: nowrap">10</td> <td style="white-space: nowrap">4430</td> <td style="white-space: nowrap">10</td> <td style="white-space: nowrap">073</td> <td style="white-space: nowrap">GGM</td> <td style="white-space: nowrap">-5,272</td> <td style="white-space: nowrap">0</td> <td style="white-space: nowrap">
</td> </tr> <tr> <td style="white-space: nowrap">94-5111-008-910</td> <td style="white-space: nowrap">94</td> <td style="white-space: nowrap">5111</td> <td style="white-space: nowrap">10</td> <td style="white-space: nowrap">008</td> <td style="white-space: nowrap">GGM</td> <td style="white-space: nowrap">14,456</td> <td style="white-space: nowrap">0</td> <td style="white-space: nowrap">3485.66</td> </tr> <tr> <td style="white-space: nowrap">94-5111-028-910</td> <td style="white-space: nowrap">94</td> <td style="white-space: nowrap">5111</td> <td style="white-space: nowrap">10</td> <td style="white-space: nowrap">028</td> <td style="white-space: nowrap">GGM</td> <td style="white-space: nowrap">8,553</td> <td style="white-space: nowrap">0</td> <td style="white-space: nowrap">3485.66</td> </tr> <tr> <td style="white-space: nowrap">94-5111-038-910</td> <td style="white-space: nowrap">94</td> <td style="white-space: nowrap">5111</td> <td style="white-space: nowrap">10</td> <td style="white-space: nowrap">038</td> <td style="white-space: nowrap">GGM</td> <td style="white-space: nowrap">12,551</td> <td style="white-space: nowrap">0</td> <td style="white-space: nowrap">3485.66</td> </tr> <tr> <td style="white-space: nowrap">94-5111-055-910</td> <td style="white-space: nowrap">94</td> <td style="white-space: nowrap">5111</td> <td style="white-space: nowrap">10</td> <td style="white-space: nowrap">055</td> <td style="white-space: nowrap">GGM</td> <td style="white-space: nowrap">14,004</td> <td style="white-space: nowrap">0</td> <td style="white-space: nowrap">3485.66</td> </tr> <tr> <td style="white-space: nowrap">94-5111-066-910</td> <td style="white-space: nowrap">94</td> <td style="white-space: nowrap">5111</td> <td style="white-space: nowrap">10</td> <td style="white-space: nowrap">066</td> <td style="white-space: nowrap">GGM</td> <td style="white-space: nowrap">17,588</td> <td style="white-space: nowrap">0</td> <td style="white-space: nowrap">3485.66</td> </tr> <tr> <td style="white-space: nowrap">94-5111-073-910</td> <td style="white-space: nowrap">94</td> <td style="white-space: nowrap">5111</td> <td style="white-space: nowrap">10</td> <td style="white-space: nowrap">073</td> <td style="white-space: nowrap">GGM</td> <td style="white-space: nowrap">20,624</td> <td style="white-space: nowrap">0</td> <td style="white-space: nowrap">3485.66</td> </tr> <tr> <td style="white-space: nowrap">94-5111-GGM-910</td> <td style="white-space: nowrap">94</td> <td style="white-space: nowrap">5111</td> <td style="white-space: nowrap">10</td> <td style="white-space: nowrap">GGM</td> <td style="white-space: nowrap">GGM</td> <td style="white-space: nowrap">20,914</td> <td style="white-space: nowrap">20,914</td> <td style="white-space: nowrap">
</td> </tr> <tr> <td style="white-space: nowrap">10-5111-008</td> <td style="white-space: nowrap">10</td> <td style="white-space: nowrap">5111</td> <td style="white-space: nowrap">10</td> <td style="white-space: nowrap">008</td> <td style="white-space: nowrap">GGM</td> <td style="white-space: nowrap">9,565</td> <td style="white-space: nowrap">0</td> <td style="white-space: nowrap">4990.16</td> </tr> <tr> <td style="white-space: nowrap">10-5111-028</td> <td style="white-space: nowrap">10</td> <td style="white-space: nowrap">5111</td> <td style="white-space: nowrap">10</td> <td style="white-space: nowrap">028</td> <td style="white-space: nowrap">GGM</td> <td style="white-space: nowrap">4,018</td> <td style="white-space: nowrap">0</td> <td style="white-space: nowrap">4990.16</td> </tr> <tr> <td style="white-space: nowrap">10-5111-038</td> <td style="white-space: nowrap">10</td> <td style="white-space: nowrap">5111</td> <td style="white-space: nowrap">10</td> <td style="white-space: nowrap">038</td> <td style="white-space: nowrap">GGM</td> <td style="white-space: nowrap">639</td> <td style="white-space: nowrap">0</td> <td style="white-space: nowrap">4990.16</td> </tr> <tr> <td style="white-space: nowrap">10-5111-055</td> <td style="white-space: nowrap">10</td> <td style="white-space: nowrap">5111</td> <td style="white-space: nowrap">10</td> <td style="white-space: nowrap">055</td> <td style="white-space: nowrap">GGM</td> <td style="white-space: nowrap">9,324</td> <td style="white-space: nowrap">0</td> <td style="white-space: nowrap">4990.16</td> </tr> <tr> <td style="white-space: nowrap">10-5111-066</td> <td style="white-space: nowrap">10</td> <td style="white-space: nowrap">5111</td> <td style="white-space: nowrap">10</td> <td style="white-space: nowrap">066</td> <td style="white-space: nowrap">GGM</td> <td style="white-space: nowrap">6,789</td> <td style="white-space: nowrap">0</td> <td style="white-space: nowrap">4990.16</td> </tr> <tr> <td style="white-space: nowrap">10-5111-073</td> <td style="white-space: nowrap">10</td> <td style="white-space: nowrap">5111</td> <td style="white-space: nowrap">10</td> <td style="white-space: nowrap">073</td> <td style="white-space: nowrap">GGM</td> <td style="white-space: nowrap">4,540</td> <td style="white-space: nowrap">0</td> <td style="white-space: nowrap">4990.16</td> </tr> <tr> <td style="white-space: nowrap">10-5111-GGM</td> <td style="white-space: nowrap">10</td> <td style="white-space: nowrap">5111</td> <td style="white-space: nowrap">10</td> <td style="white-space: nowrap">GGM</td> <td style="white-space: nowrap">GGM</td> <td style="white-space: nowrap">29,941</td> <td style="white-space: nowrap">29,941</td> <td style="white-space: nowrap">
</td> </tr> <tr> <td style="white-space: nowrap">10-5113-008</td> <td style="white-space: nowrap">10</td> <td style="white-space: nowrap">5113</td> <td style="white-space: nowrap">10</td> <td style="white-space: nowrap">008</td> <td style="white-space: nowrap">GGM</td> <td style="white-space: nowrap">1,052</td> <td style="white-space: nowrap">0</td> <td style="white-space: nowrap">548.83</td> </tr> <tr> <td style="white-space: nowrap">10-5113-028</td> <td style="white-space: nowrap">10</td> <td style="white-space: nowrap">5113</td> <td style="white-space: nowrap">10</td> <td style="white-space: nowrap">028</td> <td style="white-space: nowrap">GGM</td> <td style="white-space: nowrap">442</td> <td style="white-space: nowrap">0</td> <td style="white-space: nowrap">548.83</td> </tr> <tr> <td style="white-space: nowrap">10-5113-038</td> <td style="white-space: nowrap">10</td> <td style="white-space: nowrap">5113</td> <td style="white-space: nowrap">10</td> <td style="white-space: nowrap">038</td> <td style="white-space: nowrap">GGM</td> <td style="white-space: nowrap">268</td> <td style="white-space: nowrap">0</td> <td style="white-space: nowrap">548.83</td> </tr> <tr> <td style="white-space: nowrap">10-5113-055</td> <td style="white-space: nowrap">10</td> <td style="white-space: nowrap">5113</td> <td style="white-space: nowrap">10</td> <td style="white-space: nowrap">055</td> <td style="white-space: nowrap">GGM</td> <td style="white-space: nowrap">1,052</td> <td style="white-space: nowrap">0</td> <td style="white-space: nowrap">548.83</td> </tr> <tr> <td style="white-space: nowrap">10-5113-066</td> <td style="white-space: nowrap">10</td> <td style="white-space: nowrap">5113</td> <td style="white-space: nowrap">10</td> <td style="white-space: nowrap">066</td> <td style="white-space: nowrap">GGM</td> <td style="white-space: nowrap">747</td> <td style="white-space: nowrap">0</td> <td style="white-space: nowrap">548.83</td> </tr> <tr> <td style="white-space: nowrap">10-5113-073</td> <td style="white-space: nowrap">10</td> <td style="white-space: nowrap">5113</td> <td style="white-space: nowrap">10</td> <td style="white-space: nowrap">073</td> <td style="white-space: nowrap">GGM</td> <td style="white-space: nowrap">579</td> <td style="white-space: nowrap">0</td> <td style="white-space: nowrap">548.83</td> </tr> <tr> <td style="white-space: nowrap">10-5113-GGM</td> <td style="white-space: nowrap">10</td> <td style="white-space: nowrap">5113</td> <td style="white-space: nowrap">10</td> <td style="white-space: nowrap">GGM</td> <td style="white-space: nowrap">GGM</td> <td style="white-space: nowrap">3,293</td> <td style="white-space: nowrap">3,293</td> <td style="white-space: nowrap">
</td> </tr> </tbody></table>

Peter_SSs · Jun 15, 2011

Welcome to the MrExcel board!

Depending on your Excel version try either M7 or N7 copied down. Note that I have just hidden the irrelevant columns to keep my screen shot a bit smaller. The N7 formula will also work in Excel 2007+ but the M7 formula is a bit more efficient for those versions.

Excel Workbook

F

G

J

L

M

N

6

Country

AccSegment

Site

SiteBalance

Reallocation 2007+

Reallocation 2003-

7

10

4110

GGM

0

8

10

4110

GGM

0

9

10

4110

GGM

0

10

4110

GGM

0

11

10

4110

GGM

0

12

10

4110

GGM

0

13

10

4420

GGM

0

14

10

4420

GGM

0

15

10

4420

GGM

0

16

10

4420

GGM

0

17

10

4430

GGM

0

18

10

4430

GGM

0

19

10

4430

GGM

0

20

10

4430

GGM

0

21

10

4430

GGM

0

22

10

4430

GGM

0

23

94

5111

GGM

0

3485.666667

24

94

5111

GGM

0

3485.666667

25

94

5111

GGM

0

3485.666667

26

94

5111

GGM

0

3485.666667

27

94

5111

GGM

0

3485.666667

28

94

5111

GGM

0

3485.666667

29

94

5111

GGM

20,914

30

10

5111

GGM

0

4990.166667

31

10

5111

GGM

0

4990.166667

32

10

5111

GGM

0

4990.166667

33

10

5111

GGM

0

4990.166667

34

10

5111

GGM

0

4990.166667

35

10

5111

GGM

0

4990.166667

36

10

5111

GGM

29,941

37

10

5113

GGM

0

548.8333333

38

10

5113

GGM

0

548.8333333

39

10

5113

GGM

0

548.8333333

40

10

5113

GGM

0

548.8333333

41

10

5113

GGM

0

548.8333333

42

10

5113

GGM

0

548.8333333

43

10

5113

GGM

3,293

44

Spread Value

AlphaFrog · Jun 15, 2011

You could do it with just formulas...

 <table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #A6AAB6"><colgroup><col width="25px" style="background-color: #E0E0F0" /><col /><col /><col /><col /><col /><col /><col /><col /><col /></colgroup><thead><tr style=" background-color: #E0E0F0;text-align: center;color: #161120"><th></th><th>E</th><th>J</th><th>K</th><th>L</th><th>M</th><th>N</th><th>O</th><th>P</th><th>Q</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">1</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">AcctID</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">Country</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">AccSegment</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">ManCo</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">RigSite</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">Site</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">Current Period</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">SiteBalance</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td></tr><tr ><td style="color: #161120;text-align: center;">2</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">#NAME?</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">#NAME?</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">#NAME?</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">#NAME?</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">#NAME?</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">#NAME?</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">#NAME?</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">#NAME?</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td></tr><tr ><td style="color: #161120;text-align: center;">3</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">\</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">\</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">\</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">\</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">\</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">\</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">\</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">\</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td></tr><tr ><td style="color: #161120;text-align: center;">4</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td></tr><tr ><td style="color: #161120;text-align: center;">5</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td></tr><tr ><td style="color: #161120;text-align: center;">6</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">AcctID</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">Country</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">AccSegment</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">ManCo</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">RigSite</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">Site</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">Current Period</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">SiteBalance</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">Reallocation</td></tr><tr ><td style="color: #161120;text-align: center;">7</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">10-4110-008</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">10</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">4110</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">10</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">8</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">GGM</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">-208,985</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">0</td><td style="text-align: right;border-top: 1px solid black;border-left: 1px solid black;;">0.00</td></tr><tr ><td style="color: #161120;text-align: center;">8</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">10-4110-028</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">10</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">4110</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">10</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">28</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">GGM</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">-174,000</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">0</td><td style="text-align: right;border-left: 1px solid black;;">0.00</td></tr><tr ><td style="color: #161120;text-align: center;">9</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">10-4110-038</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">10</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">4110</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">10</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">38</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">GGM</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">-242,657</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">0</td><td style="text-align: right;border-left: 1px solid black;;">0.00</td></tr><tr ><td style="color: #161120;text-align: center;">10</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">10-4110-055</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">10</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">4110</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">10</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">55</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">GGM</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">-210,230</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">0</td><td style="text-align: right;border-left: 1px solid black;;">0.00</td></tr><tr ><td style="color: #161120;text-align: center;">11</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">10-4110-066</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">10</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">4110</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">10</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">66</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">GGM</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">-221,175</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">0</td><td style="text-align: right;border-left: 1px solid black;;">0.00</td></tr><tr ><td style="color: #161120;text-align: center;">12</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">10-4110-073</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">10</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">4110</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">10</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">73</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">GGM</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">-240,455</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">0</td><td style="text-align: right;border-left: 1px solid black;;">0.00</td></tr><tr ><td style="color: #161120;text-align: center;">13</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">10-4420-008</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">10</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">4420</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">10</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">8</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">GGM</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">-3,747</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">0</td><td style="text-align: right;border-left: 1px solid black;;">0.00</td></tr><tr ><td style="color: #161120;text-align: center;">14</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">10-4420-028</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">10</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">4420</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">10</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">28</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">GGM</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">-16,975</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">0</td><td style="text-align: right;border-left: 1px solid black;;">0.00</td></tr><tr ><td style="color: #161120;text-align: center;">15</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">10-4420-055</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">10</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">4420</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">10</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">55</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">GGM</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">-3,747</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">0</td><td style="text-align: right;border-left: 1px solid black;;">0.00</td></tr><tr ><td style="color: #161120;text-align: center;">16</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">10-4420-066</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">10</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">4420</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">10</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">66</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">GGM</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">-3,747</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">0</td><td style="text-align: right;border-left: 1px solid black;;">0.00</td></tr><tr ><td style="color: #161120;text-align: center;">17</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">10-4430-008</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">10</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">4430</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">10</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">8</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">GGM</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">-17,138</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">0</td><td style="text-align: right;border-left: 1px solid black;;">0.00</td></tr><tr ><td style="color: #161120;text-align: center;">18</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">10-4430-028</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">10</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">4430</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">10</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">28</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">GGM</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">-5,302</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">0</td><td style="text-align: right;border-left: 1px solid black;;">0.00</td></tr><tr ><td style="color: #161120;text-align: center;">19</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">10-4430-038</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">10</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">4430</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">10</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">38</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">GGM</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">-247</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">0</td><td style="text-align: right;border-left: 1px solid black;;">0.00</td></tr><tr ><td style="color: #161120;text-align: center;">20</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">10-4430-055</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">10</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">4430</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">10</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">55</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">GGM</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">-15,740</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">0</td><td style="text-align: right;border-left: 1px solid black;;">0.00</td></tr><tr ><td style="color: #161120;text-align: center;">21</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">10-4430-066</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">10</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">4430</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">10</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">66</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">GGM</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">-18,363</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">0</td><td style="text-align: right;border-left: 1px solid black;;">0.00</td></tr><tr ><td style="color: #161120;text-align: center;">22</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">10-4430-073</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">10</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">4430</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">10</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">73</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">GGM</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">-5,272</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">0</td><td style="text-align: right;border-left: 1px solid black;;">0.00</td></tr><tr ><td style="color: #161120;text-align: center;">23</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">94-5111-008-910</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">94</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">5111</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">10</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">8</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">GGM</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">14,456</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">0</td><td style="text-align: right;border-left: 1px solid black;;">3485.67</td></tr><tr ><td style="color: #161120;text-align: center;">24</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">94-5111-028-910</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">94</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">5111</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">10</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">28</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">GGM</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">8,553</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">0</td><td style="text-align: right;border-left: 1px solid black;;">3485.67</td></tr><tr ><td style="color: #161120;text-align: center;">25</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">94-5111-038-910</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">94</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">5111</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">10</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">38</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">GGM</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">12,551</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">0</td><td style="text-align: right;border-left: 1px solid black;;">3485.67</td></tr><tr ><td style="color: #161120;text-align: center;">26</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">94-5111-055-910</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">94</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">5111</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">10</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">55</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">GGM</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">14,004</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">0</td><td style="text-align: right;border-left: 1px solid black;;">3485.67</td></tr><tr ><td style="color: #161120;text-align: center;">27</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">94-5111-066-910</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">94</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">5111</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">10</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">66</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">GGM</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">17,588</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">0</td><td style="text-align: right;border-left: 1px solid black;;">3485.67</td></tr><tr ><td style="color: #161120;text-align: center;">28</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">94-5111-073-910</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">94</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">5111</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">10</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">73</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">GGM</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">20,624</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">0</td><td style="text-align: right;border-left: 1px solid black;;">3485.67</td></tr><tr ><td style="color: #161120;text-align: center;">29</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">94-5111-GGM-910</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">94</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">5111</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">10</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">GGM</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">GGM</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">20,914</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">20,914</td><td style="border-left: 1px solid black;;"></td></tr><tr ><td style="color: #161120;text-align: center;">30</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">10-5111-008</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">10</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">5111</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">10</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">8</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">GGM</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">9,565</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">0</td><td style="text-align: right;border-left: 1px solid black;;">4990.17</td></tr><tr ><td style="color: #161120;text-align: center;">31</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">10-5111-028</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">10</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">5111</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">10</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">28</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">GGM</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">4,018</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">0</td><td style="text-align: right;border-left: 1px solid black;;">4990.17</td></tr><tr ><td style="color: #161120;text-align: center;">32</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">10-5111-038</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">10</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">5111</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">10</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">38</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">GGM</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">639</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">0</td><td style="text-align: right;border-left: 1px solid black;;">4990.17</td></tr><tr ><td style="color: #161120;text-align: center;">33</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">10-5111-055</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">10</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">5111</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">10</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">55</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">GGM</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">9,324</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">0</td><td style="text-align: right;border-left: 1px solid black;;">4990.17</td></tr><tr ><td style="color: #161120;text-align: center;">34</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">10-5111-066</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">10</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">5111</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">10</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">66</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">GGM</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">6,789</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">0</td><td style="text-align: right;border-left: 1px solid black;;">4990.17</td></tr><tr ><td style="color: #161120;text-align: center;">35</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">10-5111-073</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">10</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">5111</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">10</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">73</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">GGM</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">4,540</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">0</td><td style="text-align: right;border-left: 1px solid black;;">4990.17</td></tr><tr ><td style="color: #161120;text-align: center;">36</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">10-5111-GGM</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">10</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">5111</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">10</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">GGM</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">GGM</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">29,941</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">29,941</td><td style="border-left: 1px solid black;;"></td></tr><tr ><td style="color: #161120;text-align: center;">37</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">10-5113-008</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">10</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">5113</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">10</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">8</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">GGM</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">1,052</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">0</td><td style="text-align: right;border-left: 1px solid black;;">548.83</td></tr><tr ><td style="color: #161120;text-align: center;">38</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">10-5113-028</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">10</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">5113</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">10</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">28</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">GGM</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">442</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">0</td><td style="text-align: right;border-left: 1px solid black;;">548.83</td></tr><tr ><td style="color: #161120;text-align: center;">39</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">10-5113-038</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">10</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">5113</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">10</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">38</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">GGM</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">268</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">0</td><td style="text-align: right;border-left: 1px solid black;;">548.83</td></tr><tr ><td style="color: #161120;text-align: center;">40</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">10-5113-055</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">10</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">5113</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">10</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">55</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">GGM</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">1,052</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">0</td><td style="text-align: right;border-left: 1px solid black;;">548.83</td></tr><tr ><td style="color: #161120;text-align: center;">41</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">10-5113-066</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">10</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">5113</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">10</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">66</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">GGM</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">747</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">0</td><td style="text-align: right;border-left: 1px solid black;;">548.83</td></tr><tr ><td style="color: #161120;text-align: center;">42</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">10-5113-073</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">10</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">5113</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">10</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">73</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">GGM</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">579</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">0</td><td style="text-align: right;border-left: 1px solid black;;">548.83</td></tr><tr ><td style="color: #161120;text-align: center;">43</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">10-5113-GGM</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">10</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">5113</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">10</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">GGM</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">GGM</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">3,293</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">3,293</td><td style="border-left: 1px solid black;;"></td></tr></tbody></table> <table width="85%" cellpadding="2.5px" rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: #FFFFFF" ><tr><td style="padding:6px" >Worksheet Formulas<table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: #FFFFFF;border-collapse: collapse; border-color: #A6AAB6"><thead><tr style=" background-color: #E0E0F0;color: #161120"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">Q7</th><td style="text-align:left">=IF(P7=0,SUMPRODUCT(--($J$7:$J$43=J7),--($K$7:$K$43=K7),--($N$7:$N$43=N7),--($P$7:$P$43))/(SUMPRODUCT(--($J$7:$J$43=J7),--($K$7:$K$43=K7),--($N$7:$N$43=N7))-1),"")</td></tr></tbody></table></td></tr></table>

If you have Excel 2007 or later, you could use a SUMIFS/COUNTIFS formula instead of SUMPRODUCT.
=IF(P7=0,SUMIFS(P:P, J:J, J7, K:K, K7, N:N, N7)/(COUNTIFS(J:J, J7, K:K, K7, N:N, N7)-1),"")

Peter_SSs · Jun 16, 2011

Oops, AlphaFrog's post alerted me to the fact that I had not adjusted my columns correctly.

Of course with both suggestions you will need to ensure the ranges in the formulas reach at least to the bottom of your data so you may need to amend the $50 in my formulas and the $43 in AlphaFrog's formulas before copying down.

Just to tidy up my suggestion, here it is again with (hopefully

) the correct columns.

Excel Workbook

J

K

N

P

Q

R

6

Country

AccSegment

Site

SiteBalance

Reallocation 2007+

Reallocation 2003-

7

10

4110

GGM

0

8

10

4110

GGM

0

9

10

4110

GGM

0

10

4110

GGM

0

11

10

4110

GGM

0

12

10

4110

GGM

0

13

10

4420

GGM

0

14

10

4420

GGM

0

15

10

4420

GGM

0

16

10

4420

GGM

0

17

10

4430

GGM

0

18

10

4430

GGM

0

19

10

4430

GGM

0

20

10

4430

GGM

0

21

10

4430

GGM

0

22

10

4430

GGM

0

23

94

5111

GGM

0

3485.666667

24

94

5111

GGM

0

3485.666667

25

94

5111

GGM

0

3485.666667

26

94

5111

GGM

0

3485.666667

27

94

5111

GGM

0

3485.666667

28

94

5111

GGM

0

3485.666667

29

94

5111

GGM

20,914

30

10

5111

GGM

0

4990.166667

31

10

5111

GGM

0

4990.166667

32

10

5111

GGM

0

4990.166667

33

10

5111

GGM

0

4990.166667

34

10

5111

GGM

0

4990.166667

35

10

5111

GGM

0

4990.166667

36

10

5111

GGM

29,941

37

10

5113

GGM

0

548.8333333

38

10

5113

GGM

0

548.8333333

39

10

5113

GGM

0

548.8333333

40

10

5113

GGM

0

548.8333333

41

10

5113

GGM

0

548.8333333

42

10

5113

GGM

0

548.8333333

43

10

5113

GGM

3,293

44

Spread Value

wibni · Jun 16, 2011

I'm using Excel 2007.
Thank you so very much! This is excellent.

Now I have an even more difficult task. I don't think this can be done in VBA though.

Excel Workbook

E

F

G

H

I

J

K

L

M

N

O

P

Q

1

GGM

6

008

028

038

055

066

073

2

NMM

8

005

011

021

024

032

042

048

049

3

MWA

14

4

KNC

14

5

AcctID

Acct Desc

Header

Category

SubCategory

Country

AccSegment

ManCo

RigSite

Site

Current Period

SiteBalance

ReAllocation

6

#NAME?

7

\

8

9

10

AcctID

Acct Desc

Header

Category

SubCategory

Country

AccSegment

ManCo

RigSite

Site

Current Period

SiteBalance

ReAllocation

15

10-4420-NMM

Revenue - Other

EBITDA

Revenue

10

4420

10

NMM

-64,517

23

94-5111-005-910

Salaries - Expatriates

EBITDA

Direct Expenses

94

5111

10

005

NMM

9,455

0

2531.978

25

94-5111-011-910

Salaries - Expatriates

EBITDA

Direct Expenses

94

5111

10

011

NMM

8,764

0

2531.978

26

94-5111-021-910

Salaries - Expatriates

EBITDA

Direct Expenses

94

5111

10

021

NMM

3,778

0

2531.978

27

94-5111-024-910

Salaries - Expatriates

EBITDA

Direct Expenses

94

5111

10

024

NMM

3,778

0

2531.978

29

94-5111-032-910

Salaries - Expatriates

EBITDA

Direct Expenses

94

5111

10

032

NMM

9,798

0

2531.978

31

94-5111-042-910

Salaries - Expatriates

EBITDA

Direct Expenses

94

5111

10

042

NMM

10,754

0

2531.978

32

94-5111-048-910

Salaries - Expatriates

EBITDA

Direct Expenses

94

5111

10

048

NMM

13,445

0

2531.978

33

94-5111-049-910

Salaries - Expatriates

EBITDA

Direct Expenses

94

5111

10

049

NMM

9,948

0

2531.978

39

94-5111-NMM-910

Salaries - Expatriates

EBITDA

Direct Expenses

94

5111

10

NMM

20,256

Sheet1

Excel 2007

The formula works if there are rows which can be used for the distribution, e.g Cell P39 is distributed over Q23:Q39.

In cell P15 however, I have $64,517 which don't get re-allocated with the previous formula.
Can the formula be changed to devide whatever is in column P by the number in Cell F1, F2, F3 or F4?

Cell P39 has country ='94', AccSegment = '5111' and Site 'NMM'.
Cell F2 shows, that there are 8 rigs in NMM. Therefore P39 is divided by 8.
In this case I have 8 rows to distribute the amount accross.

Cell P15 has country ='10', AccSegment = '4420' and Site 'NMM'.
Cell F2 shows, that there are 8 rigs in NMM but I have no account with AccSegment '4420' in NMM.

Now the difficult part is that I need Excel to create these 8 rows for me.

So when done it has distributed the $64,517 as well as shown below.
So I basically need the previous formula you guys created and having Excel creating a number of lines based on the count in cells F1 to F4.

I'd really appreciate if you could give me some advise on how to achieve this.

Excel Workbook

E

F

G

H

I

J

K

L

M

N

O

P

Q

1

GGM

6

008

028

038

055

066

073

2

NMM

8

005

011

021

024

032

042

048

049

3

MWA

14

4

KNC

14

5

AcctID

Acct Desc

Header

Category

SubCategory

Country

AccSegment

ManCo

RigSite

Site

Current Period

SiteBalance

ReAllocation

6

#NAME?

7

\

8

9

10

AcctID

Acct Desc

Header

Category

SubCategory

Country

AccSegment

ManCo

RigSite

Site

Current Period

SiteBalance

ReAllocation

15

10-4420-NMM

Revenue - Other

EBITDA

Revenue

10

4420

10

005

NMM

-64,517

-8064.6

16

10-4420-NMM

Revenue - Other

EBITDA

Revenue

10

4420

10

011

NMM

-64,517

-8064.6

17

10-4420-NMM

Revenue - Other

EBITDA

Revenue

10

4420

10

021

NMM

-64,517

-8064.6

18

10-4420-NMM

Revenue - Other

EBITDA

Revenue

10

4420

10

024

NMM

-64,517

-8064.6

19

10-4420-NMM

Revenue - Other

EBITDA

Revenue

10

4420

10

032

NMM

-64,517

-8064.6

20

10-4420-NMM

Revenue - Other

EBITDA

Revenue

10

4420

10

042

NMM

-64,517

-8064.6

21

10-4420-NMM

Revenue - Other

EBITDA

Revenue

10

4420

10

048

NMM

-64,517

-8064.6

22

10-4420-NMM

Revenue - Other

EBITDA

Revenue

10

4420

10

049

NMM

-64,517

-8064.6

23

10-4420-NMM

Revenue - Other

EBITDA

Revenue

10

4420

10

NMM

-64,517

Sheet1

Excel 2007

Peter_SSs · Jun 16, 2011

wibni said:
I don't think this can be done in VBA though.

Hopefully that was a typo, since if you may require rows to be inserted you cannot do this without vba (unless you do the task manually of course

).

Test this in a copy of your workbook.

Option Explicit Option Base 1 Sub Spread_values() Dim aRows, aData, AMatchCols Dim LR As Long, r As Long, RwsReqd As Long Dim i As Long, j As Long, k As Long, x As Long, z As Long Dim Amt As Single Dim Site As String, CSS1 As String, CSS2 As String Const FR As Long = 11 '<-- First Row of actual data Const NumSites As Long = 4 '<--No. of possible sites AMatchCols = Array(6, 7, 10) '<--Cols in data that must match '(ie Country,Segment,Site) Application.ScreenUpdating = False x = UBound(AMatchCols) aRows = Range("E1:F" & NumSites).Value LR = Range("P" & Rows.Count).End(xlUp).Row aData = Range("E1:P" & LR).Value For r = LR To FR Step -1 If aData(r, 12) <> 0 Then Site = Range("N" & r).Value i = 0 Do i = i + 1 Loop Until aRows(i, 1) = Site Or i = NumSites If aRows(i, 1) = Site Then RwsReqd = aRows(i, 2) Else MsgBox "Site not found in table" Exit Sub End If Amt = Range("P" & r).Value / RwsReqd CSS1 = "" For j = 1 To x CSS1 = CSS1 & "|" & aData(r, AMatchCols(j)) Next j For k = 1 To RwsReqd If r - k >= FR - 1 Then z = r + 1 - k CSS2 = "" For j = 1 To x CSS2 = CSS2 & "|" & aData(r - k, AMatchCols(j)) Next j Else z = FR End If If CSS2 = CSS1 Then Range("Q" & r - k).Value = Amt Else With Rows(z) .Insert Range("E" & z).Resize(, 11).Value = _ Range("E" & z + 1).Resize(, 11).Value Range("Q" & z) = Amt End With End If Next k End If Next r Application.ScreenUpdating = True End Sub

wibni · Jun 16, 2011

Hi Peter,

Again, thank you so much!
You're right. It was a typo. Inserting rows can only be done in VBA.

I'm trying to work through and understand your code.
It works very well, although I noticed when it inserts the reallocation amount it jumps one row.
In my test I tried re-allocating the $7,434, in cell P25.
It devided it by 8 because there are 8 rigs at site NMM ( as in cell F2).
When it inserts the amount the 1st insert is correct in row 24, but then it jumps to row 22 for the next insert.
This then means, the site balance in cell P23 is being ignored.
I think the error is in the line below.

Code:

z = r + 1 - k

Another thing I noticed is that it seems to get confused with the sites, but thats probably related to jumping the rows.
Cell N22 for example should be site 'NMM' because N25 is 'NMM' as well.

Would it also be possible to have column M (RigSite) replaced with the actual rig number?
The numbers for the actual rigs on site are on the same worksheet in row 1 to 4.
Column E are the sites, F the number of rigs and the then following columns are the actual rig numbers as shown in my 2nd table below.

Excel Workbook

E

F

G

H

I

J

K

L

M

N

O

P

Q

10

AcctID

Acct Desc

Header

Category

SubCategory

Country

AccSegment

ManCo

RigSite

Site

Current Period

SiteBalance

ReAllocation

11

10-5811-048

Depreciation Expense

ITDA

Depreciation Expense

10

5811

10

048

NMM

5,098

0

929.23

12

10-5811-049

Depreciation Expense

ITDA

Depreciation Expense

10

5811

10

049

NMM

4,220

0

929.23

13

10-5811-055

Depreciation Expense

ITDA

Depreciation Expense

10

5811

10

055

GGM

2,947

0

14

10-5811-066

Depreciation Expense

ITDA

Depreciation Expense

10

5811

10

66

GGM

4,809

929.23

15

10-5811-066

Depreciation Expense

ITDA

Depreciation Expense

10

5811

10

066

GGM

4,809

0

16

10-5811-073

Depreciation Expense

ITDA

Depreciation Expense

10

5811

10

73

GGM

1,189

929.23

17

10-5811-073

Depreciation Expense

ITDA

Depreciation Expense

10

5811

10

073

GGM

1,189

0

18

10-5811-GGM

Depreciation Expense

ITDA

Depreciation Expense

10

5811

10

GGM

9,796

929.23

19

10-5811-GGM

Depreciation Expense

ITDA

Depreciation Expense

10

5811

10

GGM

9,796

20

10-5811-KNC

Depreciation Expense

ITDA

Depreciation Expense

10

5811

10

KNC

119

929.23

21

10-5811-KNC

Depreciation Expense

ITDA

Depreciation Expense

10

5811

10

KNC

119

22

10-5811-MWA

Depreciation Expense

ITDA

Depreciation Expense

10

5811

10

MWA

3,750

929.23

23

10-5811-MWA

Depreciation Expense

ITDA

Depreciation Expense

10

5811

10

MWA

3,750

24

10-5811-NMM

Depreciation Expense

ITDA

Depreciation Expense

10

5811

10

NMM

7,434

929.23

25

10-5811-NMM

Depreciation Expense

ITDA

Depreciation Expense

10

5811

10

NMM

7,434

Sheet1

Excel 2007

Excel Workbook

E

F

G

H

I

J

K

L

M

N

O

P

Q

1

GGM

6

008

028

038

055

066

073

2

NMM

8

005

011

021

024

032

042

048

049

3

MWA

14

008

028

038

055

066

073

005

011

021

024

032

4

KNC

14

008

028

038

055

066

073

005

011

021

024

032

Sheet1

Excel 2007

Peter_SSs · Jun 16, 2011

Let's not try to bite off too much at once.

1. It seemed to work (without row skipping) for me with the data posted in the first screen shot in post #5. Does that work for you too?

2. I assume that the first screen shot in post #7 was taken after the code was run. Can you post what the data looked like before the code was run? You only need to post columns J:P.

wibni · Jun 17, 2011

Hi Peter,

You are right. it works for the 1st screen shot in post 5.
But when I take out row 15 from that screen shot and copy to the end of my list it is skipping rows.

#VALUE!

Excel Workbook

H

I

J

K

L

M

N

O

P

Q

10

Category

SubCategory

Country

AccSegment

ManCo

RigSite

Site

Current Period

SiteBalance

ReAllocation

11

Depreciation Expense

10

5811

10

005

NMM

728

0

12

Depreciation Expense

10

5811

10

008

GGM

1,936

0

13

Depreciation Expense

10

5811

10

011

NMM

5,008

0

14

Depreciation Expense

10

5811

10

021

NMM

2,018

0

15

Depreciation Expense

10

5811

10

024

NMM

3,659

0

16

Depreciation Expense

10

5811

10

028

GGM

2,369

0

17

Depreciation Expense

10

5811

10

032

NMM

5,447

0

18

Depreciation Expense

10

5811

10

038

GGM

8,061

0

19

Depreciation Expense

10

5811

10

042

NMM

2,076

0

20

Depreciation Expense

10

5811

10

048

NMM

5,098

0

21

Depreciation Expense

10

5811

10

049

NMM

4,220

0

22

Depreciation Expense

10

5811

10

055

GGM

2,947

0

23

Depreciation Expense

10

5811

10

066

GGM

4,809

0

24

Depreciation Expense

10

5811

10

073

GGM

1,189

0

25

Depreciation Expense

10

5811

10

GGM

9,796

26

Depreciation Expense

10

5811

10

KNC

119

27

Depreciation Expense

10

5811

10

MWA

3,750

28

Depreciation Expense

10

5811

10

NMM

7,434

Excel 2007 [/B] [*]Yes, the screen shot was taken after I ran it. This is BEFORE Sheet1

Excel Workbook

J

K

L

M

N

O

P

Q

10

Country

AccSegment

ManCo

RigSite

Site

Current Period

SiteBalance

ReAllocation

11

10

5811

10

005

NMM

728

0

12

10

5811

10

008

GGM

1,936

0

13

10

5811

10

011

NMM

5,008

0

14

10

5811

10

021

NMM

2,018

0

15

10

5811

10

024

NMM

3,659

0

16

10

5811

10

028

GGM

2,369

0

17

10

5811

10

032

NMM

5,447

0

18

10

5811

10

038

GGM

8,061

0

19

10

5811

10

042

NMM

2,076

0

20

10

5811

10

048

NMM

5,098

0

929.23

21

10

5811

10

049

NMM

4,220

0

929.23

22

10

5811

10

055

GGM

2,947

0

23

10

5811

10

66

GGM

4,809

929.23

24

10

5811

10

066

GGM

4,809

0

25

10

5811

10

73

GGM

1,189

929.23

26

10

5811

10

073

GGM

1,189

0

27

10

5811

10

GGM

9,796

929.23

28

10

5811

10

GGM

9,796

29

10

5811

10

KNC

119

929.23

30

10

5811

10

KNC

119

31

10

5811

10

MWA

3,750

929.23

32

10

5811

10

MWA

3,750

33

10

5811

10

NMM

7,434

929.23

34

10

5811

10

NMM

7,434

Excel 2007 [/B][/B]And AFTER [/B][/B]I stopped it after it had finished with the value in Cell P34. Sheet1

Excel 2007

[/B][/B]

Peter_SSs · Jun 17, 2011

You were right about there being a problem with the "z = r + 1 - k" line. I think I could fix that for section 1 of post #9.

However, that is on hold because section 2 of post #9 is quite different from your earlier data samples. In the previous data samples the lines that had the same Country, Segment, Site (CSS) were grouped together. This latest data does not have that feature. For example, look at CSS 10|5811|NMM, it is split into 5 distinct ranges.

Excel Workbook

J

K

L

M

N

O

P

10

Country

AccSegment

ManCo

RigSite

Site

Current Period

SiteBalance

11

10

5811

10

5

NMM

728

0

12

10

5811

10

8

GGM

1,936

0

13

10

5811

10

11

NMM

5,008

0

14

10

5811

10

21

NMM

2,018

0

15

10

5811

10

24

NMM

3,659

0

16

10

5811

10

28

GGM

2,369

0

17

10

5811

10

32

NMM

5,447

0

18

10

5811

10

38

GGM

8,061

0

19

10

5811

10

42

NMM

2,076

0

20

10

5811

10

48

NMM

5,098

0

21

10

5811

10

49

NMM

4,220

0

22

10

5811

10

55

GGM

2,947

0

23

10

5811

10

66

GGM

4,809

0

24

10

5811

10

73

GGM

1,189

0

25

10

5811

10

GGM

9,796

26

10

5811

10

KNC

119

27

10

5811

10

MWA

3,750

28

10

5811

10

NMM

7,434

Spread Value vba (6)

My code was based on those groupings being together per the earlier samples.
So, my questions are:

1. Is it OK to sort the data based on CSS so that those groupings come together.

2. If not, what should the 'After' look like for this second example in post #9?

Find string, do calculation

wibni

New Member

Excel Facts

Peter_SSs

MrExcel MVP, Moderator

AlphaFrog

MrExcel MVP

Peter_SSs

MrExcel MVP, Moderator

wibni

New Member

Peter_SSs

MrExcel MVP, Moderator

wibni

New Member

Peter_SSs

MrExcel MVP, Moderator

wibni

New Member

Peter_SSs

MrExcel MVP, Moderator

Similar threads

Forum statistics

Share this page

Find string, do calculation

New Member

Excel Facts

MrExcel MVP, Moderator

MrExcel MVP

MrExcel MVP, Moderator

New Member

MrExcel MVP, Moderator

New Member

MrExcel MVP, Moderator

New Member

MrExcel MVP, Moderator

Similar threads

Forum statistics

Share this page

We've detected that you are using an adblocker.

Which adblocker are you using?

Disable AdBlock

Disable AdBlock Plus

Disable uBlock Origin

Disable uBlock