Advanced ETL by DB Software Laboratory
https://www.etl-tools.com
deal static




MapID=0
{
Objects
O=0,2,27,10,0
OP=5,0,,C:\\DT-DropBox\\2. First State Investment Mappings\\Input\\EDIF I Q2 2020 Report_BUMA.xlsx,C:\\Users\\Public\\Documents\\DBSL\\Demo\\Excel,-1,\c,",4,0,,,,,,-1,Page 9,"Page 9",,0,EDIF1,3794,0,,0,1,1,1,,,{CR}+{LF},0,0,,,,0,0,0,-1,-1,1,1,"C:\\Users\\Public\\Documents\\DBSL\\Advanced ETL Processor\\Logs\\Rejected.tab",0,,,0,0,,0,0,0,0,0,0,,,,0,0,0,,,,,,,0,,,0,,0,0,0,0,0,0,,,,0,,0,0,0,0,,0,,,0,0,0,,0,0,,,0,,0
SF=[Investment]\t0,1,27,[Acquisition]\t0,28,61,[Start of Period]\t0,62,87,[End of Period]\t0,88,110,[Income in the Period]\t0,111,128,[Total Return in Period]\t0,129,145,[Income Since Purchase]\t0,146,163,[Total Return Since]\t0,164,184,[Gross IRR from Cash\t]\t0,185,198,[Gross IRR since Purchase (%)2]\t0,199,213
O=1,3,297,10,0
D=Validator1
IF=[Investment]\t0,1,27,[Acquisition]\t0,28,61,[Start of Period]\t0,62,87,[End of Period]\t0,88,110,[Income in the Period]\t0,111,128,[Total Return in Period]\t0,129,145,[Income Since Purchase]\t0,146,163,[Total Return Since]\t0,164,184,[Gross IRR from Cash\t]\t0,185,198,[Gross IRR since Purchase (%)2]\t0,199,213
OF=1,0,0,0,[Investment],,0,0,\c\c,Mapped To,2,0,0,0,[Acquisition],,0,0,\c\c,Mapped To,3,0,0,0,[Start of Period],,0,0,\c\c,Mapped To,4,0,0,0,[End of Period],,0,0,\c\c,Mapped To,5,0,0,0,[Income in the Period],,0,0,\c\c,Mapped To,6,0,0,0,[Total Return in Period],,0,0,\c\c,Mapped To,7,0,0,0,[Income Since Purchase],,0,0,\c\c,Mapped To,8,0,0,0,[Total Return Since],,0,0,\c\c,Mapped To,9,0,0,0,[Gross IRR from Cash\t],,0,0,\c\c,Mapped To,10,0,0,0,[Gross IRR since Purchase (%)2],,0,0,\c\c,Mapped To
O=2,5,1439,163,0
OP=5,0,,,,,5 Asset Details,0,-1,0,0,0,0,0,C:\\DT-DropBox\\2. First State Investment Mappings\\output\\CEPRES Information Request Pack Infrastructure 2020(1).xlsx,0,-1,\c,",,,,Writer3,3794,C:\\Users\\Public\\Documents\\DBSL\\Demo\\Excel,0,0,0,0,0,0,0,,,0,0,0,0,1,,B14,,,0,0,,,,456,0,0,,,,,0,,,,,0,,,-1,,0,0,0,,,,,0,,,,0,0,,
TF=1,0,0,0,[F1],,8,0,\c\c,Mapped To,2,0,0,0,Fund Name (Fund Invested in this Transaction),STRING,51,0,\c\c,Mapped To,3,0,0,0,Asset Name,STRING,27,0,\c\c,Mapped To,4,0,0,0,Asset Location,STRING,20,0,\c\c,Not Mapped,5,0,0,0,State,STRING,8,0,\c\c,Not Mapped,6,0,0,0,Postal Code,STRING,8,0,\c\c,Not Mapped,7,0,0,0,City,STRING,8,0,\c\c,Not Mapped,8,0,0,0,Street Address,STRING,8,0,\c\c,Not Mapped,9,0,0,0,Google Map URL,STRING,8,0,\c\c,Not Mapped,10,0,0,0,Asset's Business Description,STRING,8,0,\c\c,Not Mapped,11,0,0,0,Asset's Website,STRING,8,0,\c\c,Mapped To,12,0,0,0,Asset's Industry Sector,STRING,38,0,\c\c,Not Mapped,13,0,0,0,Standard Industry Classification (ID),STRING,8,0,\c\c,Not Mapped,14,0,0,0,Use Of Proceeds,STRING,36,0,\c\c,Not Mapped,15,0,0,0,Realization Status,STRING,8,0,\c\c,Not Mapped,16,0,0,0,Valuation (NAV) Currency*,STRING,8,0,\c\c,Not Mapped,17,0,0,0,Valuation (NAV) as of Mar-2020*,STRING,8,0,\c\c,Not Mapped,18,0,0,0,Board Representation,STRING,8,0,\c\c,Not Mapped,19,0,0,0,Is Investment Manager Lead in Transaction?,STRING,8,0,\c\c,Not Mapped,20,0,0,0,Is Transaction Syndicated?,STRING,8,0,\c\c,Not Mapped,21,0,0,0,Deal Source Type,STRING,8,0,\c\c,Not Mapped,22,0,0,0,Deal Source,STRING,8,0,\c\c,Not Mapped,23,0,0,0,Responsible Partner for Transaction,STRING,8,0,\c\c,Not Mapped,24,0,0,0,Investment Thesis,STRING,8,0,\c\c,Not Mapped,25,0,0,0,Deal Gross TVPI as of Valuation Date,STRING,8,0,\c\c,Mapped To,26,0,0,0,Deal Gross IRR as of Valuation Date,STRING,30,0,\c\c,Not Mapped,27,0,0,0,Comments,STRING,8,0,\c\c,Not Mapped,28,0,0,0,[F28],,8,0,\c\c,Not Mapped
O=3,2,10,103,0
OP=5,0,,C:\\DT-DropBox\\2. First State Investment Mappings\\Input\\EDIF I Q2 2020 Report_BUMA.xlsx,C:\\Users\\Public\\Documents\\DBSL\\Demo\\Excel,-1,\c,",5,0,,,,,,-1,Page 8 Changed,"Page 8 Changed",,0,EDIF1 Key Info,3794,0,,0,1,1,1,,,{CR}+{LF},0,0,,,,0,0,0,-1,-1,1,1,"C:\\Users\\Public\\Documents\\DBSL\\Advanced ETL Processor\\Logs\\Rejected.tab",0,,,0,0,,0,0,0,0,0,0,,,,0,0,0,,,,,,,0,,,0,,0,0,0,0,0,0,,,,0,,0,0,0,0,,0,,,0,0,0,,0,0,,,0,,0
SF=[F1\t\n\l]\t0,1,30,[F2]\t0,31,66,[F3]\t0,67,108,[F4]\t0,109,152,[F5]\t0,153,175,[F6]\t0,176,194,[F7]\t0,195,202
O=4,3,290,103,0
D=Validator5
IF=[F1\t\n\l]\t0,1,30,[F2]\t0,31,66,[F3]\t0,67,108,[F4]\t0,109,152,[F5]\t0,153,175,[F6]\t0,176,194,[F7]\t0,195,202
OF=1,0,0,0,[F1\t\n\l],,0,0,\c\c,Mapped To,2,0,0,0,[F2],,0,0,\c\c,Mapped To,3,0,0,0,[F3],,0,0,\c\c,Mapped To,4,0,0,0,[F4],,0,0,\c\c,Mapped To,5,0,0,0,[F5],,0,0,\c\c,Mapped To,6,0,0,0,[F6],,0,0,\c\c,Mapped To,7,0,0,0,[F7],,0,0,\c\c,Mapped To
O=5,4,550,103,0
D=Transformer6
IF=[F1\t\n\l]\t0,1,9,[F2]\t0,10,39,[F3]\t0,40,56,[F4]\t0,57,70,[F5]\t0,71,78,[F6]\t0,79,95,[F7]\t0,96,103
OF=1,0,0,0,[Sector],,0,0,\c\c,Mapped To,2,0,0,0,[Geography],,0,0,\c\c,Mapped To,3,0,0,0,[Asset Name],,0,0,\c\c,Mapped To
O=6,4,544,17,0
D=Transformer6
IF=[Investment]\t0,0,0,[Acquisition]\t0,0,0,[Start of Period]\t0,0,0,[End of Period]\t0,0,0,[Income in the Period]\t0,0,0,[Total Return in Period]\t0,0,0,[Income Since Purchase]\t0,0,0,[Total Return Since]\t0,0,0,[Gross IRR from Cash\t]\t0,0,0,[Gross IRR since Purchase (%)2]\t0,0,0
OF=1,0,0,0,[Fund Name],,0,0,\c\c,Mapped To,2,0,0,0,[Gross IRR],,0,0,\c\c,Mapped To,3,0,0,0,[Asset Name],,0,0,\c\c,Mapped To
O=7,522,903,23,0
OP=,Joiner7,,0,1\c0\c[Fund Name]\c[Fund Name]\c2\c0\c[Asset Name]\c[Asset Name]\c3\c0\c[Gross IRR]\c[Gross IRR]\c4\c1\c[Sector]\c[Sector]\c5\c1\c[Geography]\c[Geography],C:\\DT-DropBox\\BayVK Mapping\\Input\\sets,0,#Source1#.[Asset Name],#Source2#.[Asset Name]
O=8,4,1322,30,0
D=Transformer8
IF=[Fund Name]\t0,0,0,[Asset Name]\t0,0,0,[Gross IRR]\t0,0,0,[Sector]\t0,0,0,[Geography]\t0,0,0
OF=1,0,0,0,[F1],,8,0,\c\c,Mapped To,2,0,0,0,Fund Name (Fund Invested in this Transaction),,0,0,\c\c,Mapped To,3,0,0,0,Asset Name,,0,0,\c\c,Mapped To,4,0,0,0,Asset Location,,0,0,\c\c,Not Mapped,5,0,0,0,State,,0,0,\c\c,Not Mapped,6,0,0,0,Postal Code,,0,0,\c\c,Not Mapped,7,0,0,0,City,,0,0,\c\c,Not Mapped,8,0,0,0,Street Address,,0,0,\c\c,Not Mapped,9,0,0,0,Google Map URL,,0,0,\c\c,Not Mapped,10,0,0,0,Asset's Business Description,,0,0,\c\c,Not Mapped,11,0,0,0,Asset's Website,,0,0,\c\c,Mapped To,12,0,0,0,Asset's Industry Sector,,0,0,\c\c,Not Mapped,13,0,0,0,Standard Industry Classification (ID),,0,0,\c\c,Not Mapped,14,0,0,0,Use Of Proceeds,,0,0,\c\c,Not Mapped,15,0,0,0,Realization Status,,0,0,\c\c,Not Mapped,16,0,0,0,Valuation (NAV) Currency*,,0,0,\c\c,Not Mapped,17,0,0,0,Valuation (NAV) as of Mar-2020*,,0,0,\c\c,Not Mapped,18,0,0,0,Board Representation,,0,0,\c\c,Not Mapped,19,0,0,0,Is Investment Manager Lead in Transaction?,,0,0,\c\c,Not Mapped,20,0,0,0,Is Transaction Syndicated?,,0,0,\c\c,Not Mapped,21,0,0,0,Deal Source Type,,0,0,\c\c,Not Mapped,22,0,0,0,Deal Source,,0,0,\c\c,Not Mapped,23,0,0,0,Responsible Partner for Transaction,,0,0,\c\c,Not Mapped,24,0,0,0,Investment Thesis,,0,0,\c\c,Not Mapped,25,0,0,0,Deal Gross TVPI as of Valuation Date,,0,0,\c\c,Mapped To,26,0,0,0,Deal Gross IRR as of Valuation Date,,0,0,\c\c,Not Mapped,27,0,0,0,Comments,,0,0,\c\c,Not Mapped,28,0,0,0,[F28],,0,0,\c\c,Not Mapped
O=9,2,17,210,0
OP=5,0,,C:\\DT-DropBox\\2. First State Investment Mappings\\Input\\EDIF II Q2 2020 Report_BUMA.xlsx,C:\\Users\\Public\\Documents\\DBSL\\Demo\\Excel,-1,\c,",1,0,,,,,,-1,Page 11,"Page 11",,0,EDIFII,3794,0,,0,1,1,1,,,{CR}+{LF},0,0,,,,0,0,0,-1,-1,1,1,"C:\\Users\\Public\\Documents\\DBSL\\Advanced ETL Processor\\Logs\\Rejected.tab",0,,,0,0,,0,0,0,0,0,0,,,,0,0,0,,,,,,,0,,,0,,0,0,0,0,0,0,,,,0,,0,0,0,0,,0,,,0,0,0,,0,0,,,0,,0
SF=[Investment]\t0,1,8,[Acquisition]\t0,9,17,[Start of Period]\t0,18,25,[End of Period]\t0,26,75,[Income in the Period]\t0,76,84,[Total Return in Period]\t0,85,92,[Income Since Purchase]\t0,93,100,[Total Return Since]\t0,101,109,[Gross IRR from Cash]\t0,110,117,[Gross IRR since Purchase (%)2]\t0,118,125
O=10,2,37,290,0
OP=5,0,,C:\\DT-DropBox\\2. First State Investment Mappings\\Input\\EDIF II Q2 2020 Report_BUMA.xlsx,C:\\Users\\Public\\Documents\\DBSL\\Demo\\Excel,-1,\c,",1,0,,,,,,-1,Page 10 Changed ,"Page 10 Changed ",,0,EDIFII Key Info,3794,0,,0,1,1,1,,,{CR}+{LF},0,0,,,,0,0,0,-1,-1,1,1,"C:\\Users\\Public\\Documents\\DBSL\\Advanced ETL Processor\\Logs\\Rejected.tab",0,,,0,0,,0,0,0,0,0,0,,,,0,0,0,,,,,,,0,,,0,,0,0,0,0,0,0,,,,0,,0,0,0,0,,0,,,0,0,0,,0,0,,,0,,0
SF=[Investment]\t0,1,9,[Sector]\t0,10,18,[Geography]\t0,19,26,[F4]\t0,27,36,[F5]\t0,37,45,[F6]\t0,46,53,[F7]\t0,54,61,[F8]\t0,62,70,[F9]\t0,71,78
O=11,3,417,190,0
D=Validator12
IF=[Investment]\t0,1,8,[Acquisition]\t0,9,17,[Start of Period]\t0,18,25,[End of Period]\t0,26,75,[Income in the Period]\t0,76,84,[Total Return in Period]\t0,85,92,[Income Since Purchase]\t0,93,100,[Total Return Since]\t0,101,109,[Gross IRR from Cash]\t0,110,117,[Gross IRR since Purchase (%)2]\t0,118,125
OF=1,0,0,0,[Investment],,0,0,\c\c,Mapped To,2,0,0,0,[Acquisition],,0,0,\c\c,Mapped To,3,0,0,0,[Start of Period],,0,0,\c\c,Mapped To,4,0,0,0,[End of Period],,0,0,\c\c,Mapped To,5,0,0,0,[Income in the Period],,0,0,\c\c,Mapped To,6,0,0,0,[Total Return in Period],,0,0,\c\c,Mapped To,7,0,0,0,[Income Since Purchase],,0,0,\c\c,Mapped To,8,0,0,0,[Total Return Since],,0,0,\c\c,Mapped To,9,0,0,0,[Gross IRR from Cash],,0,0,\c\c,Mapped To,10,0,0,0,[Gross IRR since Purchase (%)2],,0,0,\c\c,Mapped To
O=12,3,317,270,0
D=Validator12
IF=[Investment]\t0,1,9,[Sector]\t0,10,18,[Geography]\t0,19,26,[F4]\t0,27,36,[F5]\t0,37,45,[F6]\t0,46,53,[F7]\t0,54,61,[F8]\t0,62,70,[F9]\t0,71,78
OF=1,0,0,0,[Investment],,0,0,\c\c,Mapped To,2,0,0,0,[Sector],,0,0,\c\c,Mapped To,3,0,0,0,[Geography],,0,0,\c\c,Mapped To,4,0,0,0,[F4],,0,0,\c\c,Mapped To,5,0,0,0,[F5],,0,0,\c\c,Mapped To,6,0,0,0,[F6],,0,0,\c\c,Mapped To,7,0,0,0,[F7],,0,0,\c\c,Mapped To,8,0,0,0,[F8],,0,0,\c\c,Mapped To,9,0,0,0,[F9],,0,0,\c\c,Mapped To
O=13,4,697,190,0
D=Transformer13
IF=[Investment]\t0,0,0,[Acquisition]\t0,0,0,[Start of Period]\t0,0,0,[End of Period]\t0,0,0,[Income in the Period]\t0,0,0,[Total Return in Period]\t0,0,0,[Income Since Purchase]\t0,0,0,[Total Return Since]\t0,0,0,[Gross IRR from Cash]\t0,0,0,[Gross IRR since Purchase (%)2]\t0,0,0
OF=1,0,0,0,[Fund Name],,0,0,\c\c,Mapped To,2,0,0,0,[Gross IRR],,0,0,\c\c,Mapped To,3,0,0,0,[Asset Name],,0,0,\c\c,Mapped To
O=14,4,677,270,0
D=Transformer14
IF=[Investment]\t0,0,0,[Sector]\t0,0,0,[Geography]\t0,0,0,[F4]\t0,0,0,[F5]\t0,0,0,[F6]\t0,0,0,[F7]\t0,0,0,[F8]\t0,0,0,[F9]\t0,0,0
OF=1,0,0,0,[Sector],,0,0,\c\c,Mapped To,2,0,0,0,[Geography],,0,0,\c\c,Mapped To,3,0,0,0,[Asset Name],,0,0,\c\c,Mapped To
O=15,522,923,343,0
OP=,Joiner15,,0,1\c0\c[Fund Name]\c[Fund Name]\c2\c0\c[Asset Name]\c[Asset Name]\c3\c0\c[Gross IRR]\c[Gross IRR]\c4\c1\c[Sector]\c[Sector]\c5\c1\c[Geography]\c[Geography],C:\\DT-DropBox\\1. First state\\input,0,#Source1#.[Asset Name],#Source2#.[Asset Name]
O=16,11,1043,183,0
OP=[Fund Name]\c[Fund Name]\c[Fund Name]\c[Asset Name]\c[Asset Name]\c[Asset Name]\c[Gross IRR]\c[Gross IRR]\c[Gross IRR]\c[Sector]\c[Sector]\c[Sector]\c[Geography]\c[Geography]\c[Geography],Union All16
Links
L=0,0,1,0,1
L=1,1,0,0,0
L=2,1,12,0,1
L=3,1,-1,1,1
L=4,5,-1,1,1
L=5,5,16,0,1
L=6,5,10,0,0
L=7,2,19,0,0
L=8,3,9,0,1
L=9,4,8,0,0
L=10,4,6,0,1
L=11,4,-1,1,1
L=12,6,2,0,0
L=13,6,15,0,1
L=14,6,-1,1,1
L=15,7,13,0,0
L=16,7,5,1,0
L=17,7,38,0,1
L=18,8,40,0,0
L=19,8,7,0,1
L=20,8,-1,1,1
L=21,9,25,0,1
L=22,10,26,0,1
L=23,11,-1,1,1
L=24,11,29,0,1
L=25,11,21,0,0
L=26,12,22,0,0
L=27,12,32,0,1
L=28,12,-1,1,1
L=29,13,24,0,0
L=30,13,35,0,1
L=31,13,-1,1,1
L=32,14,27,0,0
L=33,14,36,0,1
L=34,14,-1,1,1
L=35,15,30,0,0
L=36,15,33,1,0
L=37,15,39,0,1
L=38,16,17,0,0
L=39,16,37,1,0
L=40,16,18,0,1
Tabs
SubTransformations
}
MapID=2
{
Objects
O=0,0,10,12,0
OP=0,[Investment]
O=1,0,10,37,0
OP=1,[Acquisition]
O=2,0,10,62,0
OP=2,[Start of Period]
O=3,0,10,87,0
OP=3,[End of Period]
O=4,0,10,112,0
OP=4,[Income in the Period]
O=5,0,10,137,0
OP=5,[Total Return in Period]
O=6,0,10,162,0
OP=6,[Income Since Purchase]
O=7,0,10,187,0
OP=7,[Total Return Since]
O=8,0,10,212,0
OP=8,[Gross IRR from Cash\t]
O=9,0,10,237,0
OP=9,[Gross IRR since Purchase (%)2]
O=10,1,1188,10,0
OP=1,[Investment]
O=11,1,1188,35,0
OP=2,[Acquisition]
O=12,1,1188,60,0
OP=3,[Start of Period]
O=13,1,1188,85,0
OP=4,[End of Period]
O=14,1,1188,110,0
OP=5,[Income in the Period]
O=15,1,1188,135,0
OP=6,[Total Return in Period]
O=16,1,1188,160,0
OP=7,[Income Since Purchase]
O=17,1,1188,185,0
OP=8,[Total Return Since]
O=18,1,1188,210,0
OP=9,[Gross IRR from Cash\t]
O=19,1,1188,235,0
OP=10,[Gross IRR since Purchase (%)2]
O=20,517,568,10,0
OP=0,4,-1,0,
O=21,517,563,43,0
OP=0,4,-1,0,
O=22,517,583,63,0
OP=0,4,-1,0,
O=23,517,563,163,0
OP=0,4,-1,0,
O=24,517,583,123,0
OP=0,4,-1,0,
O=25,517,603,243,0
OP=0,4,-1,0,
O=26,517,583,223,0
OP=0,4,-1,0,
O=27,517,583,203,0
OP=0,4,-1,0,
O=28,517,583,83,0
OP=0,4,-1,0,
O=29,517,603,183,0
OP=0,4,-1,0,
Links
L=0,0,20,0,1
L=1,1,22,0,1
L=2,2,24,0,1
L=3,3,26,0,1
L=4,4,36,0,1
L=5,5,28,0,1
L=6,6,38,0,1
L=7,7,34,0,1
L=8,8,32,0,1
L=9,9,30,0,1
L=10,10,21,0,0
L=11,11,23,0,0
L=12,12,25,0,0
L=13,13,27,0,0
L=14,14,37,0,0
L=15,15,29,0,0
L=16,16,39,0,0
L=17,17,35,0,0
L=18,18,33,0,0
L=19,19,31,0,0
L=20,20,0,0,0
L=21,20,10,0,1
L=22,21,1,0,0
L=23,21,11,0,1
L=24,22,2,0,0
L=25,22,12,0,1
L=26,23,3,0,0
L=27,23,13,0,1
L=28,24,5,0,0
L=29,24,15,0,1
L=30,25,9,0,0
L=31,25,19,0,1
L=32,26,8,0,0
L=33,26,18,0,1
L=34,27,7,0,0
L=35,27,17,0,1
L=36,28,4,0,0
L=37,28,14,0,1
L=38,29,6,0,0
L=39,29,16,0,1
Tabs
SubTransformations
}
MapID=5
{
Objects
O=0,0,10,19,0
OP=0,[F1\t\n\l]
O=1,0,10,44,0
OP=1,[F2]
O=2,0,10,69,0
OP=2,[F3]
O=3,0,10,94,0
OP=3,[F4]
O=4,0,10,119,0
OP=4,[F5]
O=5,0,10,144,0
OP=5,[F6]
O=6,0,10,169,0
OP=6,[F7]
O=7,1,908,17,0
OP=1,[F1\t\n\l]
O=8,1,908,42,0
OP=2,[F2]
O=9,1,908,67,0
OP=3,[F3]
O=10,1,908,92,0
OP=4,[F4]
O=11,1,908,117,0
OP=5,[F5]
O=12,1,908,142,0
OP=6,[F6]
O=13,1,908,167,0
OP=7,[F7]
O=14,517,383,10,0
OP=0,4,-1,0,
O=15,517,408,57,0
OP=0,4,-1,0,
O=16,517,443,83,0
OP=0,4,-1,0,
O=17,517,443,150,0
OP=0,4,-1,0,
Links
L=0,0,14,0,1
L=1,1,16,0,1
L=2,2,18,0,1
L=3,3,10,0,1
L=4,4,11,0,1
L=5,5,20,0,1
L=6,6,13,0,1
L=7,7,15,0,0
L=8,8,17,0,0
L=9,9,19,0,0
L=10,10,3,0,0
L=11,11,4,0,0
L=12,12,21,0,0
L=13,13,6,0,0
L=14,14,0,0,0
L=15,14,7,0,1
L=16,15,1,0,0
L=17,15,8,0,1
L=18,16,2,0,0
L=19,16,9,0,1
L=20,17,5,0,0
L=21,17,12,0,1
Tabs
SubTransformations
}
MapID=6
{
Objects
O=0,0,10,10,0
OP=0,[F1\t\n\l]
O=1,0,17,42,0
OP=1,[F2]
O=2,0,17,67,0
OP=2,[F3]
O=3,0,17,92,0
OP=3,[F4]
O=4,0,17,117,0
OP=4,[F5]
O=5,0,17,142,0
OP=5,[F6]
O=6,0,17,167,0
OP=6,[F7]
O=7,1,623,63,0
OP=1,[Sector]
O=8,1,643,103,0
OP=2,[Geography]
O=9,1,610,30,0
OP=3,[Asset Name]
Links
L=0,0,9,0,1
L=1,1,7,0,1
L=2,2,8,0,1
L=3,3,-1,0,1
L=4,4,-1,0,1
L=5,5,-1,0,1
L=6,6,-1,0,1
L=7,7,1,0,0
L=8,8,2,0,0
L=9,9,0,0,0
Tabs
SubTransformations
}
MapID=7
{
Objects
O=0,0,10,10,0
OP=0,[Investment]
O=1,0,10,35,0
OP=1,[Acquisition]
O=2,0,10,60,0
OP=2,[Start of Period]
O=3,0,10,85,0
OP=3,[End of Period]
O=4,0,10,110,0
OP=4,[Income in the Period]
O=5,0,10,135,0
OP=5,[Total Return in Period]
O=6,0,10,160,0
OP=6,[Income Since Purchase]
O=7,0,10,185,0
OP=7,[Total Return Since]
O=8,0,10,210,0
OP=8,[Gross IRR from Cash\t]
O=9,0,10,235,0
OP=9,[Gross IRR since Purchase (%)2]
O=10,1,1008,128,0
OP=1,[Fund Name]
O=11,1,988,68,0
OP=2,[Gross IRR]
O=12,1,968,28,0
OP=3,[Asset Name]
O=13,545,734,247,0
OP=5,0,
O=14,248,388,248,0
OP=0,0
O=15,13,408,288,0
OP=Page 1,
O=16,13,448,368,0
OP=A2,
Links
L=0,0,12,0,1
L=1,1,-1,0,1
L=2,2,-1,0,1
L=3,3,-1,0,1
L=4,4,-1,0,1
L=5,5,-1,0,1
L=6,6,-1,0,1
L=7,7,-1,0,1
L=8,8,-1,0,1
L=9,9,11,0,1
L=10,10,16,0,0
L=11,11,9,0,0
L=12,12,0,0,0
L=13,13,17,0,0
L=14,13,18,1,0
L=15,13,19,2,0
L=16,13,10,0,1
L=17,14,13,0,1
L=18,15,14,0,1
L=19,16,15,0,1
Tabs
SubTransformations
}
MapID=9
{
Objects
O=0,0,10,10,0
OP=0,[Fund Name]
O=1,0,10,35,0
OP=1,[Asset Name]
O=2,0,10,60,0
OP=2,[Gross IRR]
O=3,0,10,85,0
OP=3,[Sector]
O=4,0,10,110,0
OP=4,[Geography]
O=5,1,420,10,0
OP=1,[F1]
O=6,1,420,35,0
OP=2,Fund Name (Fund Invested in this Transaction)
O=7,1,420,60,0
OP=3,Asset Name
O=8,1,420,85,0
OP=4,Asset Location
O=9,1,420,110,0
OP=5,State
O=10,1,420,135,0
OP=6,Postal Code
O=11,1,420,160,0
OP=7,City
O=12,1,420,185,0
OP=8,Street Address
O=13,1,420,210,0
OP=9,Google Map URL
O=14,1,420,235,0
OP=10,Asset's Business Description
O=15,1,420,260,0
OP=11,Asset's Website
O=16,1,420,285,0
OP=12,Asset's Industry Sector
O=17,1,768,68,0
OP=13,Standard Industry Classification (ID)
O=18,1,768,93,0
OP=14,Use Of Proceeds
O=19,1,768,118,0
OP=15,Realization Status
O=20,1,768,143,0
OP=16,Valuation (NAV) Currency*
O=21,1,768,168,0
OP=17,Valuation (NAV) as of Mar-2020*
O=22,1,768,193,0
OP=18,Board Representation
O=23,1,768,218,0
OP=19,Is Investment Manager Lead in Transaction?
O=24,1,768,243,0
OP=20,Is Transaction Syndicated?
O=25,1,768,268,0
OP=21,Deal Source Type
O=26,1,768,293,0
OP=22,Deal Source
O=27,1,768,318,0
OP=23,Responsible Partner for Transaction
O=28,1,768,343,0
OP=24,Investment Thesis
O=29,1,768,368,0
OP=25,Deal Gross TVPI as of Valuation Date
O=30,1,768,393,0
OP=26,Deal Gross IRR as of Valuation Date
O=31,1,768,418,0
OP=27,Comments
O=32,1,768,443,0
OP=28,[F28]
Links
L=0,0,5,0,1
L=1,1,6,0,1
L=2,2,29,0,1
L=3,3,15,0,1
L=4,4,7,0,1
L=5,5,0,0,0
L=6,6,1,0,0
L=7,7,4,0,0
L=8,8,-1,0,0
L=9,9,-1,0,0
L=10,10,-1,0,0
L=11,11,-1,0,0
L=12,12,-1,0,0
L=13,13,-1,0,0
L=14,14,-1,0,0
L=15,15,3,0,0
L=16,16,-1,0,0
L=17,17,-1,0,0
L=18,18,-1,0,0
L=19,19,-1,0,0
L=20,20,-1,0,0
L=21,21,-1,0,0
L=22,22,-1,0,0
L=23,23,-1,0,0
L=24,24,-1,0,0
L=25,25,-1,0,0
L=26,26,-1,0,0
L=27,27,-1,0,0
L=28,28,-1,0,0
L=29,29,2,0,0
L=30,30,-1,0,0
L=31,31,-1,0,0
L=32,32,-1,0,0
Tabs
SubTransformations
}
MapID=12
{
Objects
O=0,0,10,10,0
OP=0,[Investment]
O=1,0,10,35,0
OP=1,[Acquisition]
O=2,0,10,60,0
OP=2,[Start of Period]
O=3,0,10,85,0
OP=3,[End of Period]
O=4,0,10,110,0
OP=4,[Income in the Period]
O=5,0,10,135,0
OP=5,[Total Return in Period]
O=6,0,10,160,0
OP=6,[Income Since Purchase]
O=7,0,10,185,0
OP=7,[Total Return Since]
O=8,0,10,210,0
OP=8,[Gross IRR from Cash]
O=9,0,10,235,0
OP=9,[Gross IRR since Purchase (%)2]
O=10,1,1108,48,0
OP=1,[Investment]
O=11,1,1108,73,0
OP=2,[Acquisition]
O=12,1,1108,98,0
OP=3,[Start of Period]
O=13,1,1108,123,0
OP=4,[End of Period]
O=14,1,1108,148,0
OP=5,[Income in the Period]
O=15,1,1108,173,0
OP=6,[Total Return in Period]
O=16,1,1108,198,0
OP=7,[Income Since Purchase]
O=17,1,1108,223,0
OP=8,[Total Return Since]
O=18,1,1108,248,0
OP=9,[Gross IRR from Cash]
O=19,1,1108,273,0
OP=10,[Gross IRR since Purchase (%)2]
O=20,517,583,25,0
OP=0,4,-1,0,
O=21,517,578,58,0
OP=0,4,-1,0,
O=22,517,598,98,0
OP=0,4,-1,0,
O=23,517,578,138,0
OP=0,4,-1,0,
O=24,517,598,218,0
OP=0,4,-1,0,
O=25,517,598,418,0
OP=0,4,-1,0,
O=26,517,578,338,0
OP=0,4,-1,0,
O=27,517,598,278,0
OP=0,4,-1,0,
O=28,517,578,178,0
OP=0,4,-1,0,
O=29,517,598,238,0
OP=0,4,-1,0,
Links
L=0,0,39,0,1
L=1,1,37,0,1
L=2,2,35,0,1
L=3,3,33,0,1
L=4,4,23,0,1
L=5,5,31,0,1
L=6,6,21,0,1
L=7,7,25,0,1
L=8,8,27,0,1
L=9,9,29,0,1
L=10,10,38,0,0
L=11,11,36,0,0
L=12,12,34,0,0
L=13,13,32,0,0
L=14,14,22,0,0
L=15,15,30,0,0
L=16,16,20,0,0
L=17,17,24,0,0
L=18,18,26,0,0
L=19,19,28,0,0
L=20,29,16,0,1
L=21,29,6,0,0
L=22,28,14,0,1
L=23,28,4,0,0
L=24,27,17,0,1
L=25,27,7,0,0
L=26,26,18,0,1
L=27,26,8,0,0
L=28,25,19,0,1
L=29,25,9,0,0
L=30,24,15,0,1
L=31,24,5,0,0
L=32,23,13,0,1
L=33,23,3,0,0
L=34,22,12,0,1
L=35,22,2,0,0
L=36,21,11,0,1
L=37,21,1,0,0
L=38,20,10,0,1
L=39,20,0,0,0
Tabs
SubTransformations
}
MapID=13
{
Objects
O=0,0,10,10,0
OP=0,[Investment]
O=1,0,10,35,0
OP=1,[Sector]
O=2,0,10,60,0
OP=2,[Geography]
O=3,0,10,85,0
OP=3,[F4]
O=4,0,10,110,0
OP=4,[F5]
O=5,0,10,135,0
OP=5,[F6]
O=6,0,10,160,0
OP=6,[F7]
O=7,0,10,185,0
OP=7,[F8]
O=8,0,10,210,0
OP=8,[F9]
O=9,1,1008,28,0
OP=1,[Investment]
O=10,1,1008,53,0
OP=2,[Sector]
O=11,1,1008,78,0
OP=3,[Geography]
O=12,1,1008,103,0
OP=4,[F4]
O=13,1,1008,128,0
OP=5,[F5]
O=14,1,1008,153,0
OP=6,[F6]
O=15,1,1008,178,0
OP=7,[F7]
O=16,1,1008,203,0
OP=8,[F8]
O=17,1,1008,228,0
OP=9,[F9]
O=18,517,398,25,0
OP=0,4,-1,0,
O=19,517,418,58,0
OP=0,4,-1,0,
O=20,517,438,78,0
OP=0,4,-1,0,
O=21,517,458,165,0
OP=0,4,-1,0,
Links
L=0,0,25,0,1
L=1,1,23,0,1
L=2,2,21,0,1
L=3,3,12,0,1
L=4,4,13,0,1
L=5,5,19,0,1
L=6,6,15,0,1
L=7,7,16,0,1
L=8,8,17,0,1
L=9,9,24,0,0
L=10,10,22,0,0
L=11,11,20,0,0
L=12,12,3,0,0
L=13,13,4,0,0
L=14,14,18,0,0
L=15,15,6,0,0
L=16,16,7,0,0
L=17,17,8,0,0
L=18,21,14,0,1
L=19,21,5,0,0
L=20,20,11,0,1
L=21,20,2,0,0
L=22,19,10,0,1
L=23,19,1,0,0
L=24,18,9,0,1
L=25,18,0,0,0
Tabs
SubTransformations
}
MapID=14
{
Objects
O=0,0,10,10,0
OP=0,[Investment]
O=1,0,10,35,0
OP=1,[Acquisition]
O=2,0,10,60,0
OP=2,[Start of Period]
O=3,0,10,85,0
OP=3,[End of Period]
O=4,0,10,110,0
OP=4,[Income in the Period]
O=5,0,10,135,0
OP=5,[Total Return in Period]
O=6,0,10,160,0
OP=6,[Income Since Purchase]
O=7,0,10,185,0
OP=7,[Total Return Since]
O=8,0,10,210,0
OP=8,[Gross IRR from Cash]
O=9,0,10,235,0
OP=9,[Gross IRR since Purchase (%)2]
O=10,1,1023,143,0
OP=1,[Fund Name]
O=11,1,1003,83,0
OP=2,[Gross IRR]
O=12,1,983,43,0
OP=3,[Asset Name]
O=13,545,749,262,0
OP=5,0,
O=14,248,403,263,0
OP=0,9
O=15,13,423,303,0
OP=Page 1,
O=16,13,463,383,0
OP=A2,
Links
L=0,0,17,0,1
L=1,1,-1,0,1
L=2,2,-1,0,1
L=3,3,-1,0,1
L=4,4,-1,0,1
L=5,5,-1,0,1
L=6,6,-1,0,1
L=7,7,-1,0,1
L=8,8,-1,0,1
L=9,9,18,0,1
L=10,16,14,0,1
L=11,15,15,0,1
L=12,14,16,0,1
L=13,13,19,0,1
L=14,13,10,2,0
L=15,13,11,1,0
L=16,13,12,0,0
L=17,12,0,0,0
L=18,11,9,0,0
L=19,10,13,0,0
Tabs
SubTransformations
}
MapID=15
{
Objects
O=0,0,10,10,0
OP=0,[Investment]
O=1,0,10,35,0
OP=1,[Sector]
O=2,0,10,60,0
OP=2,[Geography]
O=3,0,10,85,0
OP=3,[F4]
O=4,0,10,110,0
OP=4,[F5]
O=5,0,10,135,0
OP=5,[F6]
O=6,0,10,160,0
OP=6,[F7]
O=7,0,10,185,0
OP=7,[F8]
O=8,0,10,210,0
OP=8,[F9]
O=9,1,603,63,0
OP=1,[Sector]
O=10,1,603,103,0
OP=2,[Geography]
O=11,1,618,38,0
OP=3,[Asset Name]
Links
L=0,0,9,0,1
L=1,1,11,0,1
L=2,2,10,0,1
L=3,3,-1,0,1
L=4,4,-1,0,1
L=5,5,-1,0,1
L=6,6,-1,0,1
L=7,7,-1,0,1
L=8,8,-1,0,1
L=9,11,0,0,0
L=10,10,2,0,0
L=11,9,1,0,0
Tabs
SubTransformations
}