Vba code

A

AFPMM

New Member
Joined
Sep 21, 2016
Messages
4
Hello!
Could you give me some help with a vba code to organize this data? I've imported this table from a source pdf and organized it by columns.
Now, the goal was to concatenate the columns with text (including column A) and then pass thru the numerical values and paste them from right to left. So that the last value is aligned in the same column.
Thanks!!





[TABLE="class: grid, width: 1591, align: center"]
<tbody>[TR]
[TD="align: center"]A[/TD]
[TD="align: center"]E[/TD]
[TD="align: center"]EX[/TD]
[TD="align: center"]E[/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]5E+07[/TD]
[TD="align: center"]1,72E+08[/TD]
[TD="align: center"]2,6E+08[/TD]
[TD="align: center"]5,02E+08[/TD]
[TD="align: center"]8,76E+08[/TD]
[TD="align: center"]3,39E+08[/TD]
[TD="align: center"]1,77E+09[/TD]
[TD="align: center"]1,78E+08[/TD]
[TD="align: center"]1,18E+08[/TD]
[TD="align: center"]-6E+07[/TD]
[TD="align: center"]1,11E+09[/TD]
[TD="align: center"]1,27E+08[/TD]
[TD="align: center"]3,39E+08[/TD]
[TD="align: center"]2,46E+08[/TD]
[TD="align: center"]2,46E+08[/TD]
[TD="align: center"]-9,3E+07[/TD]
[TD="align: center"]1,23E+09[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]0[/TD]
[TD="align: center"]FEL[/TD]
[TD="align: center"]ST[/TD]
[TD="align: center"]2012[/TD]
[TD="align: center"]5E+07[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]-3041183[/TD]
[TD="align: center"]-920341[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]49836698[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]49836698[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]0.1[/TD]
[TD="align: center"]DEVELOPMENT[/TD]
[TD="align: center"]STUDIES[/TD]
[TD="align: center"]49109159[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]-3E+06[/TD]
[TD="align: center"]-401769[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]45666208[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]45666208[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]0.2[/TD]
[TD="align: center"]FIELD[/TD]
[TD="align: center"]ACTIVITIES[/TD]
[TD="align: center"]4689062[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]-518572[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]4170490[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]4170490[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD="align: center"]FEL[/TD]
[TD="align: center"]STUDIES[/TD]
[TD="align: center"]2013-2016[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]1E+06[/TD]
[TD="align: center"]348055[/TD]
[TD="align: center"]683673[/TD]
[TD="align: center"]838032[/TD]
[TD="align: center"]838032[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]530138[/TD]
[TD="align: center"]196320[/TD]
[TD="align: center"]-333818[/TD]
[TD="align: center"]2623447[/TD]
[TD="align: center"]719000[/TD]
[TD="align: center"]697872[/TD]
[TD="align: center"]850320[/TD]
[TD="align: center"]915320[/TD]
[TD="align: center"]77288[/TD]
[TD="align: center"]3342447[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]1.1[/TD]
[TD="align: center"]GENERAL[/TD]
[TD="align: center"]STUDIES[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]1E+06[/TD]
[TD="align: center"]348055[/TD]
[TD="align: center"]683673[/TD]
[TD="align: center"]838032[/TD]
[TD="align: center"]838032[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]530138[/TD]
[TD="align: center"]196320[/TD]
[TD="align: center"]-333818[/TD]
[TD="align: center"]2623447[/TD]
[TD="align: center"]719000[/TD]
[TD="align: center"]697872[/TD]
[TD="align: center"]850320[/TD]
[TD="align: center"]915320[/TD]
[TD="align: center"]77288[/TD]
[TD="align: center"]3342447[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD="align: center"]M[/TD]
[TD="align: center"]ST[/TD]
[TD="align: center"]DEVELOPMENT[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]1E+08[/TD]
[TD="align: center"]1,57E+08[/TD]
[TD="align: center"]1,99E+08[/TD]
[TD="align: center"]1,85E+08[/TD]
[TD="align: center"]1,85E+08[/TD]
[TD="align: center"]4,4E+08[/TD]
[TD="align: center"]94778334[/TD]
[TD="align: center"]66143403[/TD]
[TD="align: center"]-2,9E+07[/TD]
[TD="align: center"]5,55E+08[/TD]
[TD="align: center"]77620727[/TD]
[TD="align: center"]1,95E+08[/TD]
[TD="align: center"]1,44E+08[/TD]
[TD="align: center"]1,44E+08[/TD]
[TD="align: center"]-4,1E+07[/TD]
[TD="align: center"]6,33E+08[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]M[/TD]
[TD="align: center"]STR[/TD]
[TD="align: center"]DEVELOPMENT[/TD]
[TD="align: center"]-[/TD]
[TD="align: center"]CS[/TD]
[TD="align: center"]Phase[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]1,33E+08[/TD]
[TD="align: center"]98060410[/TD]
[TD="align: center"]-1882650[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]-2619966[/TD]
[TD="align: center"]-2619966[/TD]
[TD="align: center"]2,26E+08[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]-2616765[/TD]
[TD="align: center"]-2619966[/TD]
[TD="align: center"]-2619966[/TD]
[TD="align: center"]-2619966[/TD]
[TD="align: center"]2,26E+08[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]2.1[/TD]
[TD="align: center"]STR[/TD]
[TD="align: center"]CONCEPT[/TD]
[TD="align: center"]SELEC[/TD]
[TD="align: center"]UPS[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]77243320[/TD]
[TD="align: center"]46500323[/TD]
[TD="align: center"]-3274592[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]-258381[/TD]
[TD="align: center"]-258381[/TD]
[TD="align: center"]1,2E+08[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]-539400[/TD]
[TD="align: center"]-258381[/TD]
[TD="align: center"]-258381[/TD]
[TD="align: center"]-258381[/TD]
[TD="align: center"]1,2E+08[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]2.1.1[/TD]
[TD="align: center"]PROJECT[/TD]
[TD="align: center"]MANAGEMENT[/TD]
[TD="align: center"]/[/TD]
[TD="align: center"]DIRECTORATE[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]24288087[/TD]
[TD="align: center"]16571036[/TD]
[TD="align: center"]-1523567[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]283484[/TD]
[TD="align: center"]283484[/TD]
[TD="align: center"]39619040[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]283484[/TD]
[TD="align: center"]283484[/TD]
[TD="align: center"]283484[/TD]
[TD="align: center"]39619040[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]2.1.2[/TD]
[TD="align: center"]E[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]17256108[/TD]
[TD="align: center"]1E+07[/TD]
[TD="align: center"]686280[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]-539400[/TD]
[TD="align: center"]-539400[/TD]
[TD="align: center"]29722842[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]-539400[/TD]
[TD="align: center"]-539400[/TD]
[TD="align: center"]-539400[/TD]
[TD="align: center"]-539400[/TD]
[TD="align: center"]29722842[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]2.1.3[/TD]
[TD="align: center"]PRE-f[/TD]
[TD="align: center"]STUDIES[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]1E+07[/TD]
[TD="align: center"]1E+07[/TD]
[TD="align: center"]-2407233[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]20026544[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]20026544[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]2.1.4[/TD]
[TD="align: center"]SURVEYS[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]24611712[/TD]
[TD="align: center"]6E+06[/TD]
[TD="align: center"]-31359[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]-2465[/TD]
[TD="align: center"]-2465[/TD]
[TD="align: center"]30706969[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]-2465[/TD]
[TD="align: center"]-2465[/TD]
[TD="align: center"]-2465[/TD]
[TD="align: center"]30706969[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]2.1.5[/TD]
[TD="align: center"]ESH[/TD]
[TD="align: center"]-[/TD]
[TD="align: center"]H[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]113968[/TD]
[TD="align: center"]20021[/TD]
[TD="align: center"]1287[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]135276[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]135276[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]2.2[/TD]
[TD="align: center"]S[/TD]
[TD="align: center"]CONCEPT[/TD]
[TD="align: center"]SELECTION[/TD]
[TD="align: center"]MIDS[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]55687591[/TD]
[TD="align: center"]51560086[/TD]
[TD="align: center"]1391942[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]-2361585[/TD]
[TD="align: center"]-2361585[/TD]
[TD="align: center"]1,06E+08[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]-2077365[/TD]
[TD="align: center"]-2361585[/TD]
[TD="align: center"]-2361585[/TD]
[TD="align: center"]-2361585[/TD]
[TD="align: center"]1,06E+08[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]2.2.1[/TD]
[TD="align: center"]PROJECT[/TD]
[TD="align: center"]MANAGEMENT[/TD]
[TD="align: center"]/[/TD]
[TD="align: center"]DIRECTORATE[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]17853173[/TD]
[TD="align: center"]15046975[/TD]
[TD="align: center"]627282[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]-284148[/TD]
[TD="align: center"]-284148[/TD]
[TD="align: center"]33243282[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]-284148[/TD]
[TD="align: center"]-284148[/TD]
[TD="align: center"]-284148[/TD]
[TD="align: center"]33243282[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]2.2.2[/TD]
[TD="align: center"]E[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]2824759[/TD]
[TD="align: center"]9E+06[/TD]
[TD="align: center"]2E+06[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]-2077365[/TD]
[TD="align: center"]-2077365[/TD]
[TD="align: center"]12223147[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]-2077365[/TD]
[TD="align: center"]-2077365[/TD]
[TD="align: center"]-2077365[/TD]
[TD="align: center"]-2077365[/TD]
[TD="align: center"]12223147[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]2.2.3[/TD]
[TD="align: center"]PRE-f[/TD]
[TD="align: center"]STUDIES[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]3E+07[/TD]
[TD="align: center"]2E+07[/TD]
[TD="align: center"]-362092[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]53539182[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]53539182[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]2.2.4[/TD]
[TD="align: center"]SURVEYS[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]3868712[/TD]
[TD="align: center"]2E+06[/TD]
[TD="align: center"]73344[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]6091385[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]6091385[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]2.2.5[/TD]
[TD="align: center"]ESH[/TD]
[TD="align: center"]-[/TD]
[TD="align: center"]HSE[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]509241[/TD]
[TD="align: center"]1612695[/TD]
[TD="align: center"]-940827[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]-72[/TD]
[TD="align: center"]-72[/TD]
[TD="align: center"]1181037[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]-72[/TD]
[TD="align: center"]-72[/TD]
[TD="align: center"]-72[/TD]
[TD="align: center"]1181037[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]M[/TD]
[TD="align: center"]S[/TD]
[TD="align: center"]DEVELOPMENT[/TD]
[TD="align: center"]-[/TD]
[TD="align: center"]CD[/TD]
[TD="align: center"]Phase[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]59005505[/TD]
[TD="align: center"]2,01E+08[/TD]
[TD="align: center"]1,77E+08[/TD]
[TD="align: center"]1,77E+08[/TD]
[TD="align: center"]1,46E+08[/TD]
[TD="align: center"]92348334[/TD]
[TD="align: center"]68763369[/TD]
[TD="align: center"]-2,4E+07[/TD]
[TD="align: center"]3,28E+08[/TD]
[TD="align: center"]75206327[/TD]
[TD="align: center"]1,89E+08[/TD]
[TD="align: center"]1,45E+08[/TD]
[TD="align: center"]1,45E+08[/TD]
[TD="align: center"]-3,2E+07[/TD]
[TD="align: center"]4,04E+08[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]2.3[/TD]
[TD="align: center"]S[/TD]
[TD="align: center"]CONCEPT[/TD]
[TD="align: center"]DEFINITION[/TD]
[TD="align: center"]UP[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]42199528[/TD]
[TD="align: center"]1,14E+08[/TD]
[TD="align: center"]1,03E+08[/TD]
[TD="align: center"]1,03E+08[/TD]
[TD="align: center"]77626361[/TD]
[TD="align: center"]49730650[/TD]
[TD="align: center"]43717188[/TD]
[TD="align: center"]-6013462[/TD]
[TD="align: center"]2E+08[/TD]
[TD="align: center"]52639297[/TD]
[TD="align: center"]1,04E+08[/TD]
[TD="align: center"]95841380[/TD]
[TD="align: center"]96917990[/TD]
[TD="align: center"]-5723620[/TD]
[TD="align: center"]2,53E+08[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
</tbody>[/TABLE]
 
Sort by date Sort by votes
there is text after slash and dash which needs to be concatenated into col 1 as does the dash and slash
 
Upvote 0

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.
oldbrewer said:
row 16 (2.2.1)
Click to expand...
Column 1 of the corresponding row of my results (row 40) contains the 2.2.1 concatenated with the following text from row 16 including the slash and the text following that (2.2.1 PROJECT MANAGEMENT / DIRECTORATE), which is my understanding of the requirement. So I'm not seeing a problem.

What do you think cell A40 of my sheet should contain?
 
Last edited:
Upvote 0
Peter_SSs said:
See if this does what you want. Test in a copy of your workbook.

Code: 
Sub Rearrange()
  Dim a As Variant, b As Variant
  Dim i As Long, j As Long, k As Long
  
  a = Range("A1").CurrentRegion.Value
  ReDim b(1 To UBound(a), 1 To 18)
  For i = 1 To UBound(a)
    k = UBound(b, 2)
    j = UBound(a, 2)
    Do Until k = 1
      If a(i, j) <> vbNullString Then
        b(i, k) = a(i, j)
        k = k - 1
      End If
      j = j - 1
    Loop
    Do Until j = 0
      b(i, 1) = a(i, j) & " " & b(i, 1)
      j = j - 1
    Loop
    b(i, 1) = RTrim(b(i, 1))
  Next i
  Range("A" & Rows.Count).End(xlUp).Offset(3).Resize(UBound(b, 1), UBound(b, 2)).Value = b
End Sub

Below ..
- original data in rows 1:22.
- results of code in row 25 and below.



Excel 2010
ABCDEFGHIJKLMNOPQRSTUVW
AEEX
0FELST
0.1DEVELOPMENTSTUDIES
0.2FIELDACTIVITIES
1FELSTUDIES2013-2016
1.1GENERALSTUDIES
2MSTDEVELOPMENT
MSTRDEVELOPMENT-CSPhase
2.1STRCONCEPTSELECUPS
2.1.1PROJECTMANAGEMENT/DIRECTORATE
2.1.2E
2.1.3PRE-fSTUDIES
2.1.4SURVEYS
2.1.5ESH-H
2.2SCONCEPTSELECTIONMIDS
2.2.1PROJECTMANAGEMENT/DIRECTORATE
2.2.2E
2.2.3PRE-fSTUDIES
2.2.4SURVEYS
2.2.5ESH-HSE
MSDEVELOPMENT-CDPhase
2.3SCONCEPTDEFINITIONUP
A E EX E A
0 FEL ST 2012
0.1 DEVELOPMENT STUDIES
0.2 FIELD ACTIVITIES
1 FEL STUDIES 2013-2016
1.1 GENERAL STUDIES
2 M ST DEVELOPMENT
M STR DEVELOPMENT - CS Phase
2.1 STR CONCEPT SELEC UPS
2.1.1 PROJECT MANAGEMENT / DIRECTORATE
2.1.2 E
2.1.3 PRE-f STUDIES
2.1.4 SURVEYS
2.1.5 ESH - H
2.2 S CONCEPT SELECTION MIDS
2.2.1 PROJECT MANAGEMENT / DIRECTORATE
2.2.2 E
2.2.3 PRE-f STUDIES
2.2.4 SURVEYS
2.2.5 ESH - HSE
M S DEVELOPMENT - CD Phase
2.3 S CONCEPT DEFINITION UP

<tbody>
[TD="align: center"]1[/TD]

[TD="align: right"]E[/TD]
[TD="align: right"]A[/TD]
[TD="align: right"]5.00E+07[/TD]
[TD="align: right"]1.72E+08[/TD]
[TD="align: right"]2.60E+08[/TD]
[TD="align: right"]5.02E+08[/TD]
[TD="align: right"]8.76E+08[/TD]
[TD="align: right"]3.39E+08[/TD]
[TD="align: right"]1.77E+09[/TD]
[TD="align: right"]1.78E+08[/TD]
[TD="align: right"]1.18E+08[/TD]
[TD="align: right"]-6.00E+07[/TD]
[TD="align: right"]1.11E+09[/TD]
[TD="align: right"]1.27E+08[/TD]
[TD="align: right"]3.39E+08[/TD]
[TD="align: right"]2.46E+08[/TD]
[TD="align: right"]2.46E+08[/TD]
[TD="align: right"]-9.30E+07[/TD]
[TD="align: right"]1.23E+09[/TD]
[TD="align: right"][/TD]

[TD="align: center"]2[/TD]

[TD="align: right"]2012[/TD]
[TD="align: right"]5.00E+07[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]-3041183[/TD]
[TD="align: right"]-920341[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]49836698[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]49836698[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]3[/TD]

[TD="align: right"]49109159[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]-3.00E+06[/TD]
[TD="align: right"]-401769[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]45666208[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]45666208[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

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

[TD="align: right"]4689062[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]-518572[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]4170490[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]4170490[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]5[/TD]

[TD="align: right"]0[/TD]
[TD="align: right"]1.00E+06[/TD]
[TD="align: right"]348055[/TD]
[TD="align: right"]683673[/TD]
[TD="align: right"]838032[/TD]
[TD="align: right"]838032[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]530138[/TD]
[TD="align: right"]196320[/TD]
[TD="align: right"]-333818[/TD]
[TD="align: right"]2623447[/TD]
[TD="align: right"]719000[/TD]
[TD="align: right"]697872[/TD]
[TD="align: right"]850320[/TD]
[TD="align: right"]915320[/TD]
[TD="align: right"]77288[/TD]
[TD="align: right"]3342447[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]6[/TD]

[TD="align: right"]0[/TD]
[TD="align: right"]1.00E+06[/TD]
[TD="align: right"]348055[/TD]
[TD="align: right"]683673[/TD]
[TD="align: right"]838032[/TD]
[TD="align: right"]838032[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]530138[/TD]
[TD="align: right"]196320[/TD]
[TD="align: right"]-333818[/TD]
[TD="align: right"]2623447[/TD]
[TD="align: right"]719000[/TD]
[TD="align: right"]697872[/TD]
[TD="align: right"]850320[/TD]
[TD="align: right"]915320[/TD]
[TD="align: right"]77288[/TD]
[TD="align: right"]3342447[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]7[/TD]

[TD="align: right"]0[/TD]
[TD="align: right"]1.00E+08[/TD]
[TD="align: right"]1.57E+08[/TD]
[TD="align: right"]1.99E+08[/TD]
[TD="align: right"]1.85E+08[/TD]
[TD="align: right"]1.85E+08[/TD]
[TD="align: right"]4.40E+08[/TD]
[TD="align: right"]94778334[/TD]
[TD="align: right"]66143403[/TD]
[TD="align: right"]-2.90E+07[/TD]
[TD="align: right"]5.55E+08[/TD]
[TD="align: right"]77620727[/TD]
[TD="align: right"]1.95E+08[/TD]
[TD="align: right"]1.44E+08[/TD]
[TD="align: right"]1.44E+08[/TD]
[TD="align: right"]-4.10E+07[/TD]
[TD="align: right"]6.33E+08[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]8[/TD]

[TD="align: right"]0[/TD]
[TD="align: right"]1.33E+08[/TD]
[TD="align: right"]98060410[/TD]
[TD="align: right"]-1882650[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]-2619966[/TD]
[TD="align: right"]-2619966[/TD]
[TD="align: right"]2.26E+08[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]-2616765[/TD]
[TD="align: right"]-2619966[/TD]
[TD="align: right"]-2619966[/TD]
[TD="align: right"]-2619966[/TD]
[TD="align: right"]2.26E+08[/TD]

[TD="align: center"]9[/TD]

[TD="align: right"]0[/TD]
[TD="align: right"]77243320[/TD]
[TD="align: right"]46500323[/TD]
[TD="align: right"]-3274592[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]-258381[/TD]
[TD="align: right"]-258381[/TD]
[TD="align: right"]1.20E+08[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]-539400[/TD]
[TD="align: right"]-258381[/TD]
[TD="align: right"]-258381[/TD]
[TD="align: right"]-258381[/TD]
[TD="align: right"]1.20E+08[/TD]
[TD="align: right"][/TD]

[TD="align: center"]10[/TD]

[TD="align: right"]0[/TD]
[TD="align: right"]24288087[/TD]
[TD="align: right"]16571036[/TD]
[TD="align: right"]-1523567[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]283484[/TD]
[TD="align: right"]283484[/TD]
[TD="align: right"]39619040[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]283484[/TD]
[TD="align: right"]283484[/TD]
[TD="align: right"]283484[/TD]
[TD="align: right"]39619040[/TD]
[TD="align: right"][/TD]

[TD="align: center"]11[/TD]

[TD="align: right"]0[/TD]
[TD="align: right"]17256108[/TD]
[TD="align: right"]1.00E+07[/TD]
[TD="align: right"]686280[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]-539400[/TD]
[TD="align: right"]-539400[/TD]
[TD="align: right"]29722842[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]-539400[/TD]
[TD="align: right"]-539400[/TD]
[TD="align: right"]-539400[/TD]
[TD="align: right"]-539400[/TD]
[TD="align: right"]29722842[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]12[/TD]

[TD="align: right"]0[/TD]
[TD="align: right"]1.00E+07[/TD]
[TD="align: right"]1.00E+07[/TD]
[TD="align: right"]-2407233[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]20026544[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]20026544[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]13[/TD]

[TD="align: right"]0[/TD]
[TD="align: right"]24611712[/TD]
[TD="align: right"]6.00E+06[/TD]
[TD="align: right"]-31359[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]-2465[/TD]
[TD="align: right"]-2465[/TD]
[TD="align: right"]30706969[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]-2465[/TD]
[TD="align: right"]-2465[/TD]
[TD="align: right"]-2465[/TD]
[TD="align: right"]30706969[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]14[/TD]

[TD="align: right"]0[/TD]
[TD="align: right"]113968[/TD]
[TD="align: right"]20021[/TD]
[TD="align: right"]1287[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]135276[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]135276[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]15[/TD]

[TD="align: right"]0[/TD]
[TD="align: right"]55687591[/TD]
[TD="align: right"]51560086[/TD]
[TD="align: right"]1391942[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]-2361585[/TD]
[TD="align: right"]-2361585[/TD]
[TD="align: right"]1.06E+08[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]-2077365[/TD]
[TD="align: right"]-2361585[/TD]
[TD="align: right"]-2361585[/TD]
[TD="align: right"]-2361585[/TD]
[TD="align: right"]1.06E+08[/TD]
[TD="align: right"][/TD]

[TD="align: center"]16[/TD]

[TD="align: right"]0[/TD]
[TD="align: right"]17853173[/TD]
[TD="align: right"]15046975[/TD]
[TD="align: right"]627282[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]-284148[/TD]
[TD="align: right"]-284148[/TD]
[TD="align: right"]33243282[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]-284148[/TD]
[TD="align: right"]-284148[/TD]
[TD="align: right"]-284148[/TD]
[TD="align: right"]33243282[/TD]
[TD="align: right"][/TD]

[TD="align: center"]17[/TD]

[TD="align: right"]0[/TD]
[TD="align: right"]2824759[/TD]
[TD="align: right"]9.00E+06[/TD]
[TD="align: right"]2.00E+06[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]-2077365[/TD]
[TD="align: right"]-2077365[/TD]
[TD="align: right"]12223147[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]-2077365[/TD]
[TD="align: right"]-2077365[/TD]
[TD="align: right"]-2077365[/TD]
[TD="align: right"]-2077365[/TD]
[TD="align: right"]12223147[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]18[/TD]

[TD="align: right"]0[/TD]
[TD="align: right"]3.00E+07[/TD]
[TD="align: right"]2.00E+07[/TD]
[TD="align: right"]-362092[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]53539182[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]53539182[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]19[/TD]

[TD="align: right"]0[/TD]
[TD="align: right"]3868712[/TD]
[TD="align: right"]2.00E+06[/TD]
[TD="align: right"]73344[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]6091385[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]6091385[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]20[/TD]

[TD="align: right"]0[/TD]
[TD="align: right"]509241[/TD]
[TD="align: right"]1612695[/TD]
[TD="align: right"]-940827[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]-72[/TD]
[TD="align: right"]-72[/TD]
[TD="align: right"]1181037[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]-72[/TD]
[TD="align: right"]-72[/TD]
[TD="align: right"]-72[/TD]
[TD="align: right"]1181037[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]21[/TD]

[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]59005505[/TD]
[TD="align: right"]2.01E+08[/TD]
[TD="align: right"]1.77E+08[/TD]
[TD="align: right"]1.77E+08[/TD]
[TD="align: right"]1.46E+08[/TD]
[TD="align: right"]92348334[/TD]
[TD="align: right"]68763369[/TD]
[TD="align: right"]-2.40E+07[/TD]
[TD="align: right"]3.28E+08[/TD]
[TD="align: right"]75206327[/TD]
[TD="align: right"]1.89E+08[/TD]
[TD="align: right"]1.45E+08[/TD]
[TD="align: right"]1.45E+08[/TD]
[TD="align: right"]-3.20E+07[/TD]
[TD="align: right"]4.04E+08[/TD]

[TD="align: center"]22[/TD]

[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]42199528[/TD]
[TD="align: right"]1.14E+08[/TD]
[TD="align: right"]1.03E+08[/TD]
[TD="align: right"]1.03E+08[/TD]
[TD="align: right"]77626361[/TD]
[TD="align: right"]49730650[/TD]
[TD="align: right"]43717188[/TD]
[TD="align: right"]-6013462[/TD]
[TD="align: right"]2.00E+08[/TD]
[TD="align: right"]52639297[/TD]
[TD="align: right"]1.04E+08[/TD]
[TD="align: right"]95841380[/TD]
[TD="align: right"]96917990[/TD]
[TD="align: right"]-5723620[/TD]
[TD="align: right"]2.53E+08[/TD]
[TD="align: right"][/TD]

[TD="align: center"]23[/TD]

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

[TD="align: center"]24[/TD]

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

[TD="align: center"]25[/TD]

[TD="align: right"]50000000[/TD]
[TD="align: right"]172000000[/TD]
[TD="align: right"]260000000[/TD]
[TD="align: right"]502000000[/TD]
[TD="align: right"]876000000[/TD]
[TD="align: right"]339000000[/TD]
[TD="align: right"]1770000000[/TD]
[TD="align: right"]178000000[/TD]
[TD="align: right"]118000000[/TD]
[TD="align: right"]-60000000[/TD]
[TD="align: right"]1110000000[/TD]
[TD="align: right"]127000000[/TD]
[TD="align: right"]339000000[/TD]
[TD="align: right"]246000000[/TD]
[TD="align: right"]246000000[/TD]
[TD="align: right"]-93000000[/TD]
[TD="align: right"]1230000000[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]26[/TD]

[TD="align: right"]50000000[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]-3041183[/TD]
[TD="align: right"]-920341[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]49836698[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]49836698[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]27[/TD]

[TD="align: right"]49109159[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]-3000000[/TD]
[TD="align: right"]-401769[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]45666208[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]45666208[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]28[/TD]

[TD="align: right"]4689062[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]-518572[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]4170490[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]4170490[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]29[/TD]

[TD="align: right"]0[/TD]
[TD="align: right"]1000000[/TD]
[TD="align: right"]348055[/TD]
[TD="align: right"]683673[/TD]
[TD="align: right"]838032[/TD]
[TD="align: right"]838032[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]530138[/TD]
[TD="align: right"]196320[/TD]
[TD="align: right"]-333818[/TD]
[TD="align: right"]2623447[/TD]
[TD="align: right"]719000[/TD]
[TD="align: right"]697872[/TD]
[TD="align: right"]850320[/TD]
[TD="align: right"]915320[/TD]
[TD="align: right"]77288[/TD]
[TD="align: right"]3342447[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]30[/TD]

[TD="align: right"]0[/TD]
[TD="align: right"]1000000[/TD]
[TD="align: right"]348055[/TD]
[TD="align: right"]683673[/TD]
[TD="align: right"]838032[/TD]
[TD="align: right"]838032[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]530138[/TD]
[TD="align: right"]196320[/TD]
[TD="align: right"]-333818[/TD]
[TD="align: right"]2623447[/TD]
[TD="align: right"]719000[/TD]
[TD="align: right"]697872[/TD]
[TD="align: right"]850320[/TD]
[TD="align: right"]915320[/TD]
[TD="align: right"]77288[/TD]
[TD="align: right"]3342447[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]31[/TD]

[TD="align: right"]0[/TD]
[TD="align: right"]100000000[/TD]
[TD="align: right"]157000000[/TD]
[TD="align: right"]199000000[/TD]
[TD="align: right"]185000000[/TD]
[TD="align: right"]185000000[/TD]
[TD="align: right"]440000000[/TD]
[TD="align: right"]94778334[/TD]
[TD="align: right"]66143403[/TD]
[TD="align: right"]-29000000[/TD]
[TD="align: right"]555000000[/TD]
[TD="align: right"]77620727[/TD]
[TD="align: right"]195000000[/TD]
[TD="align: right"]144000000[/TD]
[TD="align: right"]144000000[/TD]
[TD="align: right"]-41000000[/TD]
[TD="align: right"]633000000[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]32[/TD]

[TD="align: right"]0[/TD]
[TD="align: right"]133000000[/TD]
[TD="align: right"]98060410[/TD]
[TD="align: right"]-1882650[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]-2619966[/TD]
[TD="align: right"]-2619966[/TD]
[TD="align: right"]226000000[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]-2616765[/TD]
[TD="align: right"]-2619966[/TD]
[TD="align: right"]-2619966[/TD]
[TD="align: right"]-2619966[/TD]
[TD="align: right"]226000000[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]33[/TD]

[TD="align: right"]0[/TD]
[TD="align: right"]77243320[/TD]
[TD="align: right"]46500323[/TD]
[TD="align: right"]-3274592[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]-258381[/TD]
[TD="align: right"]-258381[/TD]
[TD="align: right"]120000000[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]-539400[/TD]
[TD="align: right"]-258381[/TD]
[TD="align: right"]-258381[/TD]
[TD="align: right"]-258381[/TD]
[TD="align: right"]120000000[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]34[/TD]

[TD="align: right"]0[/TD]
[TD="align: right"]24288087[/TD]
[TD="align: right"]16571036[/TD]
[TD="align: right"]-1523567[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]283484[/TD]
[TD="align: right"]283484[/TD]
[TD="align: right"]39619040[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]283484[/TD]
[TD="align: right"]283484[/TD]
[TD="align: right"]283484[/TD]
[TD="align: right"]39619040[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]35[/TD]

[TD="align: right"]0[/TD]
[TD="align: right"]17256108[/TD]
[TD="align: right"]10000000[/TD]
[TD="align: right"]686280[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]-539400[/TD]
[TD="align: right"]-539400[/TD]
[TD="align: right"]29722842[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]-539400[/TD]
[TD="align: right"]-539400[/TD]
[TD="align: right"]-539400[/TD]
[TD="align: right"]-539400[/TD]
[TD="align: right"]29722842[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]36[/TD]

[TD="align: right"]0[/TD]
[TD="align: right"]10000000[/TD]
[TD="align: right"]10000000[/TD]
[TD="align: right"]-2407233[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]20026544[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]20026544[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]37[/TD]

[TD="align: right"]0[/TD]
[TD="align: right"]24611712[/TD]
[TD="align: right"]6000000[/TD]
[TD="align: right"]-31359[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]-2465[/TD]
[TD="align: right"]-2465[/TD]
[TD="align: right"]30706969[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]-2465[/TD]
[TD="align: right"]-2465[/TD]
[TD="align: right"]-2465[/TD]
[TD="align: right"]30706969[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]38[/TD]

[TD="align: right"]0[/TD]
[TD="align: right"]113968[/TD]
[TD="align: right"]20021[/TD]
[TD="align: right"]1287[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]135276[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]135276[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]39[/TD]

[TD="align: right"]0[/TD]
[TD="align: right"]55687591[/TD]
[TD="align: right"]51560086[/TD]
[TD="align: right"]1391942[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]-2361585[/TD]
[TD="align: right"]-2361585[/TD]
[TD="align: right"]106000000[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]-2077365[/TD]
[TD="align: right"]-2361585[/TD]
[TD="align: right"]-2361585[/TD]
[TD="align: right"]-2361585[/TD]
[TD="align: right"]106000000[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]40[/TD]

[TD="align: right"]0[/TD]
[TD="align: right"]17853173[/TD]
[TD="align: right"]15046975[/TD]
[TD="align: right"]627282[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]-284148[/TD]
[TD="align: right"]-284148[/TD]
[TD="align: right"]33243282[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]-284148[/TD]
[TD="align: right"]-284148[/TD]
[TD="align: right"]-284148[/TD]
[TD="align: right"]33243282[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]41[/TD]

[TD="align: right"]0[/TD]
[TD="align: right"]2824759[/TD]
[TD="align: right"]9000000[/TD]
[TD="align: right"]2000000[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]-2077365[/TD]
[TD="align: right"]-2077365[/TD]
[TD="align: right"]12223147[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]-2077365[/TD]
[TD="align: right"]-2077365[/TD]
[TD="align: right"]-2077365[/TD]
[TD="align: right"]-2077365[/TD]
[TD="align: right"]12223147[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]42[/TD]

[TD="align: right"]0[/TD]
[TD="align: right"]30000000[/TD]
[TD="align: right"]20000000[/TD]
[TD="align: right"]-362092[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]53539182[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]53539182[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]43[/TD]

[TD="align: right"]0[/TD]
[TD="align: right"]3868712[/TD]
[TD="align: right"]2000000[/TD]
[TD="align: right"]73344[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]6091385[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]6091385[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]44[/TD]

[TD="align: right"]0[/TD]
[TD="align: right"]509241[/TD]
[TD="align: right"]1612695[/TD]
[TD="align: right"]-940827[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]-72[/TD]
[TD="align: right"]-72[/TD]
[TD="align: right"]1181037[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]-72[/TD]
[TD="align: right"]-72[/TD]
[TD="align: right"]-72[/TD]
[TD="align: right"]1181037[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]45[/TD]

[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]59005505[/TD]
[TD="align: right"]201000000[/TD]
[TD="align: right"]177000000[/TD]
[TD="align: right"]177000000[/TD]
[TD="align: right"]146000000[/TD]
[TD="align: right"]92348334[/TD]
[TD="align: right"]68763369[/TD]
[TD="align: right"]-24000000[/TD]
[TD="align: right"]328000000[/TD]
[TD="align: right"]75206327[/TD]
[TD="align: right"]189000000[/TD]
[TD="align: right"]145000000[/TD]
[TD="align: right"]145000000[/TD]
[TD="align: right"]-32000000[/TD]
[TD="align: right"]404000000[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]46[/TD]

[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]42199528[/TD]
[TD="align: right"]114000000[/TD]
[TD="align: right"]103000000[/TD]
[TD="align: right"]103000000[/TD]
[TD="align: right"]77626361[/TD]
[TD="align: right"]49730650[/TD]
[TD="align: right"]43717188[/TD]
[TD="align: right"]-6013462[/TD]
[TD="align: right"]200000000[/TD]
[TD="align: right"]52639297[/TD]
[TD="align: right"]104000000[/TD]
[TD="align: right"]95841380[/TD]
[TD="align: right"]96917990[/TD]
[TD="align: right"]-5723620[/TD]
[TD="align: right"]253000000[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

</tbody>
Sheet3​



Worked perfectly! Thank you very much! :)
Click to expand...
 
Upvote 0
AFPMM said:
Worked perfectly! Thank you very much! :)
Click to expand...
You are welcome. Thanks for letting us know. :)

BTW, best not to quote whole long posts - it makes the post & thread harder to read & navigate.
 
Upvote 0
You must log in or register to reply here.

Forum statistics

Threads
1,223,912
Messages
6,175,338
Members
452,637
Latest member
Ezio2866

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top