<?php /* Smarty version 2.6.19, created on 2024-06-15 03:05:20
         compiled from /www/exchange2/exchange/admin/templates/reports/accounts_journal/v1/detr_tpr.html */ ?>
<tr><td>ALL</td><td>=SUM(Q2:Q<?php echo $this->_tpl_vars['addDETR']; ?>
)</td><td></td><td></td><td></td><td></td><td></td><td>ALL EUR</td><td>=SUM(X2:X<?php echo $this->_tpl_vars['addDETR']; ?>
)</td><td>=SUM(Y2:Y<?php echo $this->_tpl_vars['addDETR']; ?>
)</td><td>=SUM(Z2:Z<?php echo $this->_tpl_vars['addDETR']; ?>
)</td><td></td><td></td><td>=SUM(AC2:AC<?php echo $this->_tpl_vars['addDETR']; ?>
)</td><td></td><td></td><td>=SUM(AF2:AF<?php echo $this->_tpl_vars['addDETR']; ?>
)</td><td></td><td></td><td></td><td>=SUM(AJ2:AJ<?php echo $this->_tpl_vars['addDETR']; ?>
)</td><td></td><td>=SUM(AL2:AL<?php echo $this->_tpl_vars['addDETR']; ?>
)</td><td></td><td></td><td></td><td>=SUM(AP2:AP<?php echo $this->_tpl_vars['addDETR']; ?>
)</td><td>=SUMIFS(AQ2:AQ<?php echo $this->_tpl_vars['addDETR']; ?>
,AZ2:AZ<?php echo $this->_tpl_vars['addDETR']; ?>
,"R")</td><td>=SUMIFS(AR2:AR<?php echo $this->_tpl_vars['addDETR']; ?>
,AZ2:AZ<?php echo $this->_tpl_vars['addDETR']; ?>
,"R")</td><td></td><td></td><td></td><td>=SUMIFS(AV2:AV<?php echo $this->_tpl_vars['addDETR']; ?>
,AZ2:AZ<?php echo $this->_tpl_vars['addDETR']; ?>
,"R")</td><td>=SUMIFS(AV2:AV<?php echo $this->_tpl_vars['addDETR']; ?>
,AZ2:AZ<?php echo $this->_tpl_vars['addDETR']; ?>
,"R",BB2:BB<?php echo $this->_tpl_vars['addDETR']; ?>
,"PAID")</td><td></td><td>=SUM(AY2:AY<?php echo $this->_tpl_vars['addDETR']; ?>
)</td><td></td><td>=SUM(BA2:BA<?php echo $this->_tpl_vars['addDETR']; ?>
)</td><td></td><td>=SUM(BC2:BC<?php echo $this->_tpl_vars['addDETR']; ?>
)</td><td>=SUM(BD2:BD<?php echo $this->_tpl_vars['addDETR']; ?>
)</td><td></td><td></td><td>=SUM(BG2:BG<?php echo $this->_tpl_vars['addDETR']; ?>
)</td><td></td><td>=SUM(BI2:BI<?php echo $this->_tpl_vars['addDETR']; ?>
)</td></tr>
<tr><td>EUR</td><td>=SUMIFS(Q2:Q<?php echo $this->_tpl_vars['addDETR']; ?>
,O2:O<?php echo $this->_tpl_vars['addDETR']; ?>
,"EUR")</td><td></td><td></td><td></td><td></td><td></td><td>EUR</td><td>=SUMIFS(X2:X<?php echo $this->_tpl_vars['addDETR']; ?>
,O2:O<?php echo $this->_tpl_vars['addDETR']; ?>
,"EUR")</td><td></td><td>Settled/Reconciled</td><td></td><td></td><td></td><td>=SUMIFS(AD2:AD<?php echo $this->_tpl_vars['addDETR']; ?>
,O2:O<?php echo $this->_tpl_vars['addDETR']; ?>
,"EUR",P2:P<?php echo $this->_tpl_vars['addDETR']; ?>
,"EUR")</td><td></td><td>Commission for Reserve</td><td></td><td></td><td></td><td></td><td>=SUMIFS(AK2:AK<?php echo $this->_tpl_vars['addDETR']; ?>
,O2:O<?php echo $this->_tpl_vars['addDETR']; ?>
,"EUR",AZ2:AZ<?php echo $this->_tpl_vars['addDETR']; ?>
,"R")</td><td>Reconciled trades</td><td></td><td>Reconciled trades</td><td></td><td></td><td>EUR</td><td>=SUMIFS(AR2:AR<?php echo $this->_tpl_vars['addDETR']; ?>
,O2:O<?php echo $this->_tpl_vars['addDETR']; ?>
,"EUR",AZ2:AZ<?php echo $this->_tpl_vars['addDETR']; ?>
,"R")</td><td></td><td></td><td>EUR</td><td>=SUMIFS(AV2:AV<?php echo $this->_tpl_vars['addDETR']; ?>
,O2:O<?php echo $this->_tpl_vars['addDETR']; ?>
,"EUR",AZ2:AZ<?php echo $this->_tpl_vars['addDETR']; ?>
,"R")</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr>
<tr><td>GBP</td><td>=SUMIFS(Q2:Q<?php echo $this->_tpl_vars['addDETR']; ?>
,O2:O<?php echo $this->_tpl_vars['addDETR']; ?>
,"GBP")</td><td></td><td></td><td></td><td></td><td></td><td>GBP</td><td>=SUMIFS(X2:X<?php echo $this->_tpl_vars['addDETR']; ?>
,O2:O<?php echo $this->_tpl_vars['addDETR']; ?>
,"GBP")</td><td></td><td>=SUMIFS(Z2:Z<?php echo $this->_tpl_vars['addDETR']; ?>
,AZ2:AZ<?php echo $this->_tpl_vars['addDETR']; ?>
,"R")</td><td></td><td></td><td></td><td></td><td>=SUMIFS(AE2:AE<?php echo $this->_tpl_vars['addDETR']; ?>
,O2:O<?php echo $this->_tpl_vars['addDETR']; ?>
,"GBP",P2:P<?php echo $this->_tpl_vars['addDETR']; ?>
,"EUR")</td><td>=SUMIFS(AF2:AF<?php echo $this->_tpl_vars['addDETR']; ?>
,AZ2:AZ<?php echo $this->_tpl_vars['addDETR']; ?>
,"R", BB2:BB<?php echo $this->_tpl_vars['addDETR']; ?>
,"PAID")</td><td></td><td></td><td></td><td></td><td></td><td>=SUMIFS(AL2:AL<?php echo $this->_tpl_vars['addDETR']; ?>
,AZ2:AZ<?php echo $this->_tpl_vars['addDETR']; ?>
,"R")</td><td></td><td>=SUMIFS(AN2:AN<?php echo $this->_tpl_vars['addDETR']; ?>
,AZ2:AZ<?php echo $this->_tpl_vars['addDETR']; ?>
,"R")</td><td></td><td></td><td>GBP</td><td>=SUMIFS(AR2:AR<?php echo $this->_tpl_vars['addDETR']; ?>
,O2:O<?php echo $this->_tpl_vars['addDETR']; ?>
,"GBP",AZ2:AZ<?php echo $this->_tpl_vars['addDETR']; ?>
,"R")</td><td></td><td></td><td>GBP</td><td>=SUMIFS(AV2:AV<?php echo $this->_tpl_vars['addDETR']; ?>
,O2:O<?php echo $this->_tpl_vars['addDETR']; ?>
,"GBP",AZ2:AZ<?php echo $this->_tpl_vars['addDETR']; ?>
,"R")</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr>
<tr><td>USD</td><td>=SUMIFS(Q2:Q<?php echo $this->_tpl_vars['addDETR']; ?>
,O2:O<?php echo $this->_tpl_vars['addDETR']; ?>
,"USD")</td><td></td><td></td><td></td><td></td><td></td><td>USD</td><td>=SUMIFS(X2:X<?php echo $this->_tpl_vars['addDETR']; ?>
,O2:O<?php echo $this->_tpl_vars['addDETR']; ?>
,"USD")</td><td></td><td></td><td></td><td></td><td></td><td></td><td>=SUMIFS(AE2:AE<?php echo $this->_tpl_vars['addDETR']; ?>
,O2:O<?php echo $this->_tpl_vars['addDETR']; ?>
,"GBP",P2:P<?php echo $this->_tpl_vars['addDETR']; ?>
,"GBP")</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td>=SUMIFS(AN2:AN<?php echo $this->_tpl_vars['addDETR']; ?>
,AZ2:AZ<?php echo $this->_tpl_vars['addDETR']; ?>
,"R",O2:O<?php echo $this->_tpl_vars['addDETR']; ?>
,"GBP",P2:P<?php echo $this->_tpl_vars['addDETR']; ?>
,"EUR")</td><td></td><td></td><td>USD</td><td>=SUMIFS(AR2:AR<?php echo $this->_tpl_vars['addDETR']; ?>
,O2:O<?php echo $this->_tpl_vars['addDETR']; ?>
,"USD",AZ2:AZ<?php echo $this->_tpl_vars['addDETR']; ?>
,"R")</td><td></td><td></td><td>USD</td><td>=SUMIFS(AV2:AV<?php echo $this->_tpl_vars['addDETR']; ?>
,O2:O<?php echo $this->_tpl_vars['addDETR']; ?>
,"USD",AZ2:AZ<?php echo $this->_tpl_vars['addDETR']; ?>
,"R")</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td>GBP & USD Loss included in Reserve</td><td></td><td></td><td></td><td>USD</td><td>=SUMIFS(AE2:AE<?php echo $this->_tpl_vars['addDETR']; ?>
,O2:O<?php echo $this->_tpl_vars['addDETR']; ?>
,"USD")</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td>=SUMIFS(AN2:AN<?php echo $this->_tpl_vars['addDETR']; ?>
,AZ2:AZ<?php echo $this->_tpl_vars['addDETR']; ?>
,"R",O2:O<?php echo $this->_tpl_vars['addDETR']; ?>
,"GBP",P2:P<?php echo $this->_tpl_vars['addDETR']; ?>
,"GBP")</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr>
<tr><td>GBP-EUR</td><td>=SUMIFS(Q2:Q<?php echo $this->_tpl_vars['addDETR']; ?>
,O2:O<?php echo $this->_tpl_vars['addDETR']; ?>
,"GBP",P2:P<?php echo $this->_tpl_vars['addDETR']; ?>
,"EUR")</td><td></td><td></td><td></td><td></td><td></td><td>GBP-EUR</td><td>=SUMIFS(X2:X<?php echo $this->_tpl_vars['addDETR']; ?>
,O2:O<?php echo $this->_tpl_vars['addDETR']; ?>
,"GBP",P2:P<?php echo $this->_tpl_vars['addDETR']; ?>
,"EUR")</td><td></td><td>=SUMIFS(Z2:Z<?php echo $this->_tpl_vars['addDETR']; ?>
,AZ2:AZ<?php echo $this->_tpl_vars['addDETR']; ?>
,"R",Z2:Z<?php echo $this->_tpl_vars['addDETR']; ?>
,"&lt;0",O2:O<?php echo $this->_tpl_vars['addDETR']; ?>
,"GBP", P2:P<?php echo $this->_tpl_vars['addDETR']; ?>
,"EUR")</td><td></td><td></td><td></td><td></td><td></td><td>Commission for traded d-ETR</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td>=SUMIFS(AN2:AN<?php echo $this->_tpl_vars['addDETR']; ?>
,AZ2:AZ<?php echo $this->_tpl_vars['addDETR']; ?>
,"R",O2:O<?php echo $this->_tpl_vars['addDETR']; ?>
,"USD",P2:P<?php echo $this->_tpl_vars['addDETR']; ?>
,"EUR")</td><td></td><td></td><td>GBP-EUR</td><td>=SUMIFS(AR2:AR<?php echo $this->_tpl_vars['addDETR']; ?>
,O2:O<?php echo $this->_tpl_vars['addDETR']; ?>
,"GBP",P2:P<?php echo $this->_tpl_vars['addDETR']; ?>
,"EUR",AZ2:AZ<?php echo $this->_tpl_vars['addDETR']; ?>
,"R")</td><td></td><td></td><td>GBP-EUR</td><td>=SUMIFS(AV2:AV<?php echo $this->_tpl_vars['addDETR']; ?>
,O2:O<?php echo $this->_tpl_vars['addDETR']; ?>
,"GBP",P2:P<?php echo $this->_tpl_vars['addDETR']; ?>
,"EUR",AZ2:AZ<?php echo $this->_tpl_vars['addDETR']; ?>
,"R")</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr>
<tr><td>USD-EUR</td><td>=SUMIFS(Q2:Q<?php echo $this->_tpl_vars['addDETR']; ?>
,O2:O<?php echo $this->_tpl_vars['addDETR']; ?>
,"USD",P2:P<?php echo $this->_tpl_vars['addDETR']; ?>
,"EUR")</td><td></td><td></td><td></td><td></td><td></td><td>USD-EUR</td><td>=SUMIFS(X2:X<?php echo $this->_tpl_vars['addDETR']; ?>
,O2:O<?php echo $this->_tpl_vars['addDETR']; ?>
,"USD",P2:P<?php echo $this->_tpl_vars['addDETR']; ?>
,"EUR")</td><td></td><td>=SUMIFS(Z2:Z<?php echo $this->_tpl_vars['addDETR']; ?>
,AZ2:AZ<?php echo $this->_tpl_vars['addDETR']; ?>
,"R",Z2:Z<?php echo $this->_tpl_vars['addDETR']; ?>
,"&lt;0",O2:O<?php echo $this->_tpl_vars['addDETR']; ?>
,"USD", P2:P<?php echo $this->_tpl_vars['addDETR']; ?>
,"EUR")</td><td></td><td></td><td></td><td></td><td>EUR</td><td>=SUMIFS(AF2:AF<?php echo $this->_tpl_vars['addDETR']; ?>
,O2:O<?php echo $this->_tpl_vars['addDETR']; ?>
,"EUR")</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td>=SUMIFS(AN2:AN<?php echo $this->_tpl_vars['addDETR']; ?>
,AZ2:AZ<?php echo $this->_tpl_vars['addDETR']; ?>
,"R",O2:O<?php echo $this->_tpl_vars['addDETR']; ?>
,"USD",P2:P<?php echo $this->_tpl_vars['addDETR']; ?>
,"USD")</td><td></td><td></td><td>USD-EUR</td><td>=SUMIFS(AR2:AR<?php echo $this->_tpl_vars['addDETR']; ?>
,O2:O<?php echo $this->_tpl_vars['addDETR']; ?>
,"USD",P2:P<?php echo $this->_tpl_vars['addDETR']; ?>
,"EUR",AZ2:AZ<?php echo $this->_tpl_vars['addDETR']; ?>
,"R")</td><td></td><td></td><td>USD-EUR</td><td>=SUMIFS(AV2:AV<?php echo $this->_tpl_vars['addDETR']; ?>
,O2:O<?php echo $this->_tpl_vars['addDETR']; ?>
,"USD",P2:P<?php echo $this->_tpl_vars['addDETR']; ?>
,"EUR",AZ2:AZ<?php echo $this->_tpl_vars['addDETR']; ?>
,"R")</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr>
<tr><td>GBP-GBP</td><td>=SUMIFS(Q2:Q<?php echo $this->_tpl_vars['addDETR']; ?>
,O2:O<?php echo $this->_tpl_vars['addDETR']; ?>
,"GBP",P2:P<?php echo $this->_tpl_vars['addDETR']; ?>
,"GBP")</td><td></td><td></td><td></td><td></td><td></td><td>GBP-GBP</td><td>=SUMIFS(X2:X<?php echo $this->_tpl_vars['addDETR']; ?>
,O2:O<?php echo $this->_tpl_vars['addDETR']; ?>
,"GBP",P2:P<?php echo $this->_tpl_vars['addDETR']; ?>
,"GBP")</td><td></td><td>=SUMIFS(Z2:Z<?php echo $this->_tpl_vars['addDETR']; ?>
,AZ2:AZ<?php echo $this->_tpl_vars['addDETR']; ?>
,"R",Z2:Z<?php echo $this->_tpl_vars['addDETR']; ?>
,"&lt;0",O2:O<?php echo $this->_tpl_vars['addDETR']; ?>
,"GBP", P2:P<?php echo $this->_tpl_vars['addDETR']; ?>
,"GBP")</td><td></td><td></td><td></td><td></td><td>GBP-EUR</td><td>=SUMIFS(AF2:AF<?php echo $this->_tpl_vars['addDETR']; ?>
,O2:O<?php echo $this->_tpl_vars['addDETR']; ?>
,"GBP",P2:P<?php echo $this->_tpl_vars['addDETR']; ?>
,"EUR")</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td>GBP-GBP</td><td>=SUMIFS(AR2:AR<?php echo $this->_tpl_vars['addDETR']; ?>
,O2:O<?php echo $this->_tpl_vars['addDETR']; ?>
,"GBP",P2:P<?php echo $this->_tpl_vars['addDETR']; ?>
,"GBP",AZ2:AZ<?php echo $this->_tpl_vars['addDETR']; ?>
,"R")</td><td></td><td></td><td>GBP-GBP</td><td>=SUMIFS(AV2:AV<?php echo $this->_tpl_vars['addDETR']; ?>
,O2:O<?php echo $this->_tpl_vars['addDETR']; ?>
,"GBP",P2:P<?php echo $this->_tpl_vars['addDETR']; ?>
,"GBP",AZ2:AZ<?php echo $this->_tpl_vars['addDETR']; ?>
,"R")</td><td>=SUMIFS(AW2:AW<?php echo $this->_tpl_vars['addDETR']; ?>
,O2:O<?php echo $this->_tpl_vars['addDETR']; ?>
,"GBP",P2:P<?php echo $this->_tpl_vars['addDETR']; ?>
,"GBP",AZ2:AZ<?php echo $this->_tpl_vars['addDETR']; ?>
,"R",BB2:BB<?php echo $this->_tpl_vars['addDETR']; ?>
,"PAID")</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td>=SUMIFS(BH2:BH<?php echo $this->_tpl_vars['addDETR']; ?>
,O2:O<?php echo $this->_tpl_vars['addDETR']; ?>
,"GBP",P2:P<?php echo $this->_tpl_vars['addDETR']; ?>
,"GBP",AZ2:AZ<?php echo $this->_tpl_vars['addDETR']; ?>
,"R")</td><td></td></tr>
<tr><td>USD-USD</td><td>=SUMIFS(Q2:Q<?php echo $this->_tpl_vars['addDETR']; ?>
,O2:O<?php echo $this->_tpl_vars['addDETR']; ?>
,"USD",P2:P<?php echo $this->_tpl_vars['addDETR']; ?>
,"USD")</td><td></td><td></td><td></td><td></td><td></td><td>USD-USD</td><td>=SUMIFS(X2:X<?php echo $this->_tpl_vars['addDETR']; ?>
,O2:O<?php echo $this->_tpl_vars['addDETR']; ?>
,"USD",P2:P<?php echo $this->_tpl_vars['addDETR']; ?>
,"USD")</td><td></td><td>=SUMIFS(Z2:Z<?php echo $this->_tpl_vars['addDETR']; ?>
,AZ2:AZ<?php echo $this->_tpl_vars['addDETR']; ?>
,"R",Z2:Z<?php echo $this->_tpl_vars['addDETR']; ?>
,"&lt;0",O2:O<?php echo $this->_tpl_vars['addDETR']; ?>
,"USD", P2:P<?php echo $this->_tpl_vars['addDETR']; ?>
,"USD")</td><td></td><td></td><td></td><td></td><td>USD-EUR</td><td>=SUMIFS(AF2:AF<?php echo $this->_tpl_vars['addDETR']; ?>
,O2:O<?php echo $this->_tpl_vars['addDETR']; ?>
,"USD",P2:P<?php echo $this->_tpl_vars['addDETR']; ?>
,"EUR")</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td>USD-USD</td><td>=SUMIFS(AR2:AR<?php echo $this->_tpl_vars['addDETR']; ?>
,O2:O<?php echo $this->_tpl_vars['addDETR']; ?>
,"USD",P2:P<?php echo $this->_tpl_vars['addDETR']; ?>
,"USD",AZ2:AZ<?php echo $this->_tpl_vars['addDETR']; ?>
,"R")</td><td></td><td></td><td>USD-USD</td><td>=SUMIFS(AV2:AV<?php echo $this->_tpl_vars['addDETR']; ?>
,O2:O<?php echo $this->_tpl_vars['addDETR']; ?>
,"USD",P2:P<?php echo $this->_tpl_vars['addDETR']; ?>
,"USD",AZ2:AZ<?php echo $this->_tpl_vars['addDETR']; ?>
,"R")</td><td>=SUMIFS(AW2:AW<?php echo $this->_tpl_vars['addDETR']; ?>
,O2:O<?php echo $this->_tpl_vars['addDETR']; ?>
,"USD",P2:P<?php echo $this->_tpl_vars['addDETR']; ?>
,"USD",AZ2:AZ<?php echo $this->_tpl_vars['addDETR']; ?>
,"R",BB2:BB<?php echo $this->_tpl_vars['addDETR']; ?>
,"PAID")</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td>=SUMIFS(BH2:BH<?php echo $this->_tpl_vars['addDETR']; ?>
,O2:O<?php echo $this->_tpl_vars['addDETR']; ?>
,"USD",P2:P<?php echo $this->_tpl_vars['addDETR']; ?>
,"USD",AZ2:AZ<?php echo $this->_tpl_vars['addDETR']; ?>
,"R")</td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td>GBP & USD Loss crystalised in Reserve payment</td><td></td><td></td><td></td><td></td><td>GBP-GBP</td><td>=SUMIFS(AF2:AF<?php echo $this->_tpl_vars['addDETR']; ?>
,O2:O<?php echo $this->_tpl_vars['addDETR']; ?>
,"GBP",P2:P<?php echo $this->_tpl_vars['addDETR']; ?>
,"GBP")</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr>
<tr><td></td><td>Settled/Reconciled</td><td></td><td></td><td></td><td></td><td></td><td></td><td>Settled/Reconciled</td><td></td><td>=SUMIFS(Z2:Z<?php echo $this->_tpl_vars['addDETR']; ?>
,AZ2:AZ<?php echo $this->_tpl_vars['addDETR']; ?>
,"R",Z2:Z<?php echo $this->_tpl_vars['addDETR']; ?>
,"&lt;0",O2:O<?php echo $this->_tpl_vars['addDETR']; ?>
,"GBP", P2:P<?php echo $this->_tpl_vars['addDETR']; ?>
,"EUR", BB2:BB<?php echo $this->_tpl_vars['addDETR']; ?>
,"PAID")</td><td></td><td></td><td></td><td></td><td>USD-USD</td><td>=SUMIFS(AF2:AF<?php echo $this->_tpl_vars['addDETR']; ?>
,O2:O<?php echo $this->_tpl_vars['addDETR']; ?>
,"USD",P2:P<?php echo $this->_tpl_vars['addDETR']; ?>
,"USD")</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td>Paid Reserves (as calculated)</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr>
<tr><td>EUR</td><td>=SUMIFS(Q2:Q<?php echo $this->_tpl_vars['addDETR']; ?>
,O2:O<?php echo $this->_tpl_vars['addDETR']; ?>
,"EUR",AZ2:AZ<?php echo $this->_tpl_vars['addDETR']; ?>
,"R")</td><td></td><td></td><td></td><td></td><td></td><td>ALL EUR</td><td>=SUM(X49045:X49047)</td><td>=SUM(Y49045:Y49047)</td><td>=SUMIFS(Z2:Z<?php echo $this->_tpl_vars['addDETR']; ?>
,AZ2:AZ<?php echo $this->_tpl_vars['addDETR']; ?>
,"R",Z2:Z<?php echo $this->_tpl_vars['addDETR']; ?>
,"&lt;0",O2:O<?php echo $this->_tpl_vars['addDETR']; ?>
,"USD", P2:P<?php echo $this->_tpl_vars['addDETR']; ?>
,"EUR", BB2:BB<?php echo $this->_tpl_vars['addDETR']; ?>
,"PAID")</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td>All EUR</td><td>=SUMIFS(AV2:AV<?php echo $this->_tpl_vars['addDETR']; ?>
,O2:O<?php echo $this->_tpl_vars['addDETR']; ?>
,"EUR",AZ2:AZ<?php echo $this->_tpl_vars['addDETR']; ?>
,"R",BB2:BB<?php echo $this->_tpl_vars['addDETR']; ?>
,"PAID")+SUMIFS(AV2:AV<?php echo $this->_tpl_vars['addDETR']; ?>
,O2:O<?php echo $this->_tpl_vars['addDETR']; ?>
,"GBP",AZ2:AZ<?php echo $this->_tpl_vars['addDETR']; ?>
,"R",BB2:BB<?php echo $this->_tpl_vars['addDETR']; ?>
,"PAID")+SUMIFS(AV2:AV<?php echo $this->_tpl_vars['addDETR']; ?>
,O2:O<?php echo $this->_tpl_vars['addDETR']; ?>
,"USD",AZ2:AZ<?php echo $this->_tpl_vars['addDETR']; ?>
,"R",BB2:BB<?php echo $this->_tpl_vars['addDETR']; ?>
,"PAID")</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr>
<tr><td>GBP</td><td>=SUMIFS(Q2:Q<?php echo $this->_tpl_vars['addDETR']; ?>
,O2:O<?php echo $this->_tpl_vars['addDETR']; ?>
,"GBP",AZ2:AZ<?php echo $this->_tpl_vars['addDETR']; ?>
,"R")</td><td></td><td></td><td></td><td></td><td></td><td>EUR</td><td>=SUMIFS(X2:X<?php echo $this->_tpl_vars['addDETR']; ?>
,O2:O<?php echo $this->_tpl_vars['addDETR']; ?>
,"EUR",AZ2:AZ<?php echo $this->_tpl_vars['addDETR']; ?>
,"R")</td><td>=SUMIFS(Y2:Y<?php echo $this->_tpl_vars['addDETR']; ?>
,O2:O<?php echo $this->_tpl_vars['addDETR']; ?>
,"EUR",AZ2:AZ<?php echo $this->_tpl_vars['addDETR']; ?>
,"R")</td><td>=SUMIFS(Z2:Z<?php echo $this->_tpl_vars['addDETR']; ?>
,AZ2:AZ<?php echo $this->_tpl_vars['addDETR']; ?>
,"R",Z2:Z<?php echo $this->_tpl_vars['addDETR']; ?>
,"&lt;0",O2:O<?php echo $this->_tpl_vars['addDETR']; ?>
,"GBP", P2:P<?php echo $this->_tpl_vars['addDETR']; ?>
,"GBP", BB2:BB<?php echo $this->_tpl_vars['addDETR']; ?>
,"PAID")</td><td></td><td></td><td></td><td></td><td></td><td>Commission for Reserve</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td>EUR</td><td>=SUMIFS(AV2:AV<?php echo $this->_tpl_vars['addDETR']; ?>
,O2:O<?php echo $this->_tpl_vars['addDETR']; ?>
,"EUR",AZ2:AZ<?php echo $this->_tpl_vars['addDETR']; ?>
,"R",BB2:BB<?php echo $this->_tpl_vars['addDETR']; ?>
,"PAID")</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr>
<tr><td>USD</td><td>=SUMIFS(Q2:Q<?php echo $this->_tpl_vars['addDETR']; ?>
,O2:O<?php echo $this->_tpl_vars['addDETR']; ?>
,"USD",AZ2:AZ<?php echo $this->_tpl_vars['addDETR']; ?>
,"R")</td><td></td><td></td><td></td><td></td><td></td><td>GBP</td><td>=SUMIFS(X2:X<?php echo $this->_tpl_vars['addDETR']; ?>
,O2:O<?php echo $this->_tpl_vars['addDETR']; ?>
,"GBP",AZ2:AZ<?php echo $this->_tpl_vars['addDETR']; ?>
,"R")</td><td>=SUMIFS(Y2:Y<?php echo $this->_tpl_vars['addDETR']; ?>
,O2:O<?php echo $this->_tpl_vars['addDETR']; ?>
,"GBP",AZ2:AZ<?php echo $this->_tpl_vars['addDETR']; ?>
,"R")</td><td>=SUMIFS(Z2:Z<?php echo $this->_tpl_vars['addDETR']; ?>
,AZ2:AZ<?php echo $this->_tpl_vars['addDETR']; ?>
,"R",Z2:Z<?php echo $this->_tpl_vars['addDETR']; ?>
,"&lt;0",O2:O<?php echo $this->_tpl_vars['addDETR']; ?>
,"USD", P2:P<?php echo $this->_tpl_vars['addDETR']; ?>
,"USD", BB2:BB<?php echo $this->_tpl_vars['addDETR']; ?>
,"PAID")</td><td></td><td></td><td></td><td></td><td>EUR</td><td>=SUMIFS(AF2:AF<?php echo $this->_tpl_vars['addDETR']; ?>
,AZ2:AZ<?php echo $this->_tpl_vars['addDETR']; ?>
,"R", BB2:BB<?php echo $this->_tpl_vars['addDETR']; ?>
,"PAID",O2:O<?php echo $this->_tpl_vars['addDETR']; ?>
,"EUR",P2:P<?php echo $this->_tpl_vars['addDETR']; ?>
,"EUR")</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td>GBP</td><td>=SUMIFS(AV2:AV<?php echo $this->_tpl_vars['addDETR']; ?>
,O2:O<?php echo $this->_tpl_vars['addDETR']; ?>
,"GBP",AZ2:AZ<?php echo $this->_tpl_vars['addDETR']; ?>
,"R",BB2:BB<?php echo $this->_tpl_vars['addDETR']; ?>
,"PAID")</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td>USD</td><td>=SUMIFS(X2:X<?php echo $this->_tpl_vars['addDETR']; ?>
,O2:O<?php echo $this->_tpl_vars['addDETR']; ?>
,"USD",AZ2:AZ<?php echo $this->_tpl_vars['addDETR']; ?>
,"R")</td><td>=SUMIFS(Y2:Y<?php echo $this->_tpl_vars['addDETR']; ?>
,O2:O<?php echo $this->_tpl_vars['addDETR']; ?>
,"USD",AZ2:AZ<?php echo $this->_tpl_vars['addDETR']; ?>
,"R")</td><td></td><td></td><td></td><td></td><td></td><td>GBP-EUR</td><td>=SUMIFS(AF2:AF<?php echo $this->_tpl_vars['addDETR']; ?>
,AZ2:AZ<?php echo $this->_tpl_vars['addDETR']; ?>
,"R", BB2:BB<?php echo $this->_tpl_vars['addDETR']; ?>
,"PAID",O2:O<?php echo $this->_tpl_vars['addDETR']; ?>
,"GBP",P2:P<?php echo $this->_tpl_vars['addDETR']; ?>
,"EUR")</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td>USD</td><td>=SUMIFS(AV2:AV<?php echo $this->_tpl_vars['addDETR']; ?>
,O2:O<?php echo $this->_tpl_vars['addDETR']; ?>
,"USD",AZ2:AZ<?php echo $this->_tpl_vars['addDETR']; ?>
,"R",BB2:BB<?php echo $this->_tpl_vars['addDETR']; ?>
,"PAID")</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr>
<tr><td>GBP-EUR</td><td>=SUMIFS(Q2:Q<?php echo $this->_tpl_vars['addDETR']; ?>
,O2:O<?php echo $this->_tpl_vars['addDETR']; ?>
,"GBP",P2:P<?php echo $this->_tpl_vars['addDETR']; ?>
,"EUR",AZ2:AZ<?php echo $this->_tpl_vars['addDETR']; ?>
,"R")</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td>USD-EUR</td><td>=SUMIFS(AF2:AF<?php echo $this->_tpl_vars['addDETR']; ?>
,AZ2:AZ<?php echo $this->_tpl_vars['addDETR']; ?>
,"R", BB2:BB<?php echo $this->_tpl_vars['addDETR']; ?>
,"PAID",O2:O<?php echo $this->_tpl_vars['addDETR']; ?>
,"USD",P2:P<?php echo $this->_tpl_vars['addDETR']; ?>
,"EUR")</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr>
<tr><td>USD-EUR</td><td>=SUMIFS(Q2:Q<?php echo $this->_tpl_vars['addDETR']; ?>
,O2:O<?php echo $this->_tpl_vars['addDETR']; ?>
,"USD",P2:P<?php echo $this->_tpl_vars['addDETR']; ?>
,"EUR",AZ2:AZ<?php echo $this->_tpl_vars['addDETR']; ?>
,"R")</td><td></td><td></td><td></td><td></td><td></td><td>GBP-EUR</td><td>=SUMIFS(X2:X<?php echo $this->_tpl_vars['addDETR']; ?>
,O2:O<?php echo $this->_tpl_vars['addDETR']; ?>
,"GBP",P2:P<?php echo $this->_tpl_vars['addDETR']; ?>
,"EUR",AZ2:AZ<?php echo $this->_tpl_vars['addDETR']; ?>
,"R")</td><td>=SUMIFS(Y2:Y<?php echo $this->_tpl_vars['addDETR']; ?>
,O2:O<?php echo $this->_tpl_vars['addDETR']; ?>
,"GBP",P2:P<?php echo $this->_tpl_vars['addDETR']; ?>
,"EUR",AZ2:AZ<?php echo $this->_tpl_vars['addDETR']; ?>
,"R")</td><td></td><td></td><td></td><td></td><td></td><td>GBP-GBP</td><td>=SUMIFS(AF2:AF<?php echo $this->_tpl_vars['addDETR']; ?>
,AZ2:AZ<?php echo $this->_tpl_vars['addDETR']; ?>
,"R", BB2:BB<?php echo $this->_tpl_vars['addDETR']; ?>
,"PAID",O2:O<?php echo $this->_tpl_vars['addDETR']; ?>
,"GBP",P2:P<?php echo $this->_tpl_vars['addDETR']; ?>
,"GBP")</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td>GBP-EUR</td><td>=SUMIFS(AV2:AV<?php echo $this->_tpl_vars['addDETR']; ?>
,O2:O<?php echo $this->_tpl_vars['addDETR']; ?>
,"GBP",P2:P<?php echo $this->_tpl_vars['addDETR']; ?>
,"EUR",AZ2:AZ<?php echo $this->_tpl_vars['addDETR']; ?>
,"R",BB2:BB<?php echo $this->_tpl_vars['addDETR']; ?>
,"PAID")</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr>
<tr><td>GBP-GBP</td><td>=SUMIFS(Q2:Q<?php echo $this->_tpl_vars['addDETR']; ?>
,O2:O<?php echo $this->_tpl_vars['addDETR']; ?>
,"GBP",P2:P<?php echo $this->_tpl_vars['addDETR']; ?>
,"GBP",AZ2:AZ<?php echo $this->_tpl_vars['addDETR']; ?>
,"R")</td><td></td><td></td><td></td><td></td><td></td><td>USD-EUR</td><td>=SUMIFS(X2:X<?php echo $this->_tpl_vars['addDETR']; ?>
,O2:O<?php echo $this->_tpl_vars['addDETR']; ?>
,"USD",P2:P<?php echo $this->_tpl_vars['addDETR']; ?>
,"EUR",AZ2:AZ<?php echo $this->_tpl_vars['addDETR']; ?>
,"R")</td><td>=SUMIFS(Y2:Y<?php echo $this->_tpl_vars['addDETR']; ?>
,O2:O<?php echo $this->_tpl_vars['addDETR']; ?>
,"USD",P2:P<?php echo $this->_tpl_vars['addDETR']; ?>
,"EUR",AZ2:AZ<?php echo $this->_tpl_vars['addDETR']; ?>
,"R")</td><td></td><td></td><td></td><td></td><td></td><td>USD-USD</td><td>=SUMIFS(AF2:AF<?php echo $this->_tpl_vars['addDETR']; ?>
,AZ2:AZ<?php echo $this->_tpl_vars['addDETR']; ?>
,"R", BB2:BB<?php echo $this->_tpl_vars['addDETR']; ?>
,"PAID",O2:O<?php echo $this->_tpl_vars['addDETR']; ?>
,"USD",P2:P<?php echo $this->_tpl_vars['addDETR']; ?>
,"USD")</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td>USD-EUR</td><td>=SUMIFS(AV2:AV<?php echo $this->_tpl_vars['addDETR']; ?>
,O2:O<?php echo $this->_tpl_vars['addDETR']; ?>
,"USD",P2:P<?php echo $this->_tpl_vars['addDETR']; ?>
,"EUR",AZ2:AZ<?php echo $this->_tpl_vars['addDETR']; ?>
,"R",BB2:BB<?php echo $this->_tpl_vars['addDETR']; ?>
,"PAID")</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr>
<tr><td>USD-USD</td><td>=SUMIFS(Q2:Q<?php echo $this->_tpl_vars['addDETR']; ?>
,O2:O<?php echo $this->_tpl_vars['addDETR']; ?>
,"USD",P2:P<?php echo $this->_tpl_vars['addDETR']; ?>
,"USD",AZ2:AZ<?php echo $this->_tpl_vars['addDETR']; ?>
,"R")</td><td></td><td></td><td></td><td></td><td></td><td>GBP-GBP</td><td>=SUMIFS(X2:X<?php echo $this->_tpl_vars['addDETR']; ?>
,O2:O<?php echo $this->_tpl_vars['addDETR']; ?>
,"GBP",P2:P<?php echo $this->_tpl_vars['addDETR']; ?>
,"GBP",AZ2:AZ<?php echo $this->_tpl_vars['addDETR']; ?>
,"R")</td><td>=SUMIFS(Y2:Y<?php echo $this->_tpl_vars['addDETR']; ?>
,O2:O<?php echo $this->_tpl_vars['addDETR']; ?>
,"GBP",P2:P<?php echo $this->_tpl_vars['addDETR']; ?>
,"GBP",AZ2:AZ<?php echo $this->_tpl_vars['addDETR']; ?>
,"R")</td><td>=SUMIFS(Y2:Y<?php echo $this->_tpl_vars['addDETR']; ?>
,O2:O<?php echo $this->_tpl_vars['addDETR']; ?>
,"GBP",P2:P<?php echo $this->_tpl_vars['addDETR']; ?>
,"EUR",AZ2:AZ<?php echo $this->_tpl_vars['addDETR']; ?>
,"R",Z2:Z<?php echo $this->_tpl_vars['addDETR']; ?>
,"&lt;0")</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td>GBP-GBP</td><td>=SUMIFS(AV2:AV<?php echo $this->_tpl_vars['addDETR']; ?>
,O2:O<?php echo $this->_tpl_vars['addDETR']; ?>
,"GBP",P2:P<?php echo $this->_tpl_vars['addDETR']; ?>
,"GBP",AZ2:AZ<?php echo $this->_tpl_vars['addDETR']; ?>
,"R",BB2:BB<?php echo $this->_tpl_vars['addDETR']; ?>
,"PAID")</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td>USD-USD</td><td>=SUMIFS(X2:X<?php echo $this->_tpl_vars['addDETR']; ?>
,O2:O<?php echo $this->_tpl_vars['addDETR']; ?>
,"USD",P2:P<?php echo $this->_tpl_vars['addDETR']; ?>
,"USD",AZ2:AZ<?php echo $this->_tpl_vars['addDETR']; ?>
,"R")</td><td>=SUMIFS(Y2:Y<?php echo $this->_tpl_vars['addDETR']; ?>
,O2:O<?php echo $this->_tpl_vars['addDETR']; ?>
,"USD",P2:P<?php echo $this->_tpl_vars['addDETR']; ?>
,"USD",AZ2:AZ<?php echo $this->_tpl_vars['addDETR']; ?>
,"R")</td><td>=SUMIFS(Y2:Y<?php echo $this->_tpl_vars['addDETR']; ?>
,O2:O<?php echo $this->_tpl_vars['addDETR']; ?>
,"USD",P2:P<?php echo $this->_tpl_vars['addDETR']; ?>
,"EUR",AZ2:AZ<?php echo $this->_tpl_vars['addDETR']; ?>
,"R",Z2:Z<?php echo $this->_tpl_vars['addDETR']; ?>
,"&lt;0")</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td>USD-USD</td><td>=SUMIFS(AV2:AV<?php echo $this->_tpl_vars['addDETR']; ?>
,O2:O<?php echo $this->_tpl_vars['addDETR']; ?>
,"USD",P2:P<?php echo $this->_tpl_vars['addDETR']; ?>
,"USD",AZ2:AZ<?php echo $this->_tpl_vars['addDETR']; ?>
,"R",BB2:BB<?php echo $this->_tpl_vars['addDETR']; ?>
,"PAID")</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr>
<tr><td></td><td>Ccy Reserve Paid</td><td></td><td></td><td></td><td></td><td></td><td></td><td>EUR Reserve Paid</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr>
<tr><td>EUR</td><td>=SUMIFS(Q2:Q<?php echo $this->_tpl_vars['addDETR']; ?>
,O2:O<?php echo $this->_tpl_vars['addDETR']; ?>
,"EUR",AZ2:AZ<?php echo $this->_tpl_vars['addDETR']; ?>
,"R",BB2:BB<?php echo $this->_tpl_vars['addDETR']; ?>
,"PAID")</td><td></td><td></td><td></td><td></td><td></td><td>EUR</td><td>=SUMIFS(X2:X<?php echo $this->_tpl_vars['addDETR']; ?>
,O2:O<?php echo $this->_tpl_vars['addDETR']; ?>
,"EUR",AZ2:AZ<?php echo $this->_tpl_vars['addDETR']; ?>
,"R",BB2:BB<?php echo $this->_tpl_vars['addDETR']; ?>
,"PAID")</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr>
<tr><td>GBP</td><td>=SUMIFS(Q2:Q<?php echo $this->_tpl_vars['addDETR']; ?>
,O2:O<?php echo $this->_tpl_vars['addDETR']; ?>
,"GBP",AZ2:AZ<?php echo $this->_tpl_vars['addDETR']; ?>
,"R",BB2:BB<?php echo $this->_tpl_vars['addDETR']; ?>
,"PAID")</td><td></td><td></td><td></td><td></td><td></td><td>GBP</td><td>=SUMIFS(X2:X<?php echo $this->_tpl_vars['addDETR']; ?>
,O2:O<?php echo $this->_tpl_vars['addDETR']; ?>
,"GBP",AZ2:AZ<?php echo $this->_tpl_vars['addDETR']; ?>
,"R",BB2:BB<?php echo $this->_tpl_vars['addDETR']; ?>
,"PAID")</td><td></td><td>GBP Fx Gain</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr>
<tr><td>USD</td><td>=SUMIFS(Q2:Q<?php echo $this->_tpl_vars['addDETR']; ?>
,O2:O<?php echo $this->_tpl_vars['addDETR']; ?>
,"USD",AZ2:AZ<?php echo $this->_tpl_vars['addDETR']; ?>
,"R",BB2:BB<?php echo $this->_tpl_vars['addDETR']; ?>
,"PAID")</td><td></td><td></td><td></td><td></td><td></td><td>USD</td><td>=SUMIFS(X2:X<?php echo $this->_tpl_vars['addDETR']; ?>
,O2:O<?php echo $this->_tpl_vars['addDETR']; ?>
,"USD",AZ2:AZ<?php echo $this->_tpl_vars['addDETR']; ?>
,"R",BB2:BB<?php echo $this->_tpl_vars['addDETR']; ?>
,"PAID")</td><td></td><td>=SUMIFS(Z2:Z<?php echo $this->_tpl_vars['addDETR']; ?>
,AZ2:AZ<?php echo $this->_tpl_vars['addDETR']; ?>
,"R",Z2:Z<?php echo $this->_tpl_vars['addDETR']; ?>
,"&gt;0",O2:O<?php echo $this->_tpl_vars['addDETR']; ?>
,"GBP")</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td>USD Fx Gain</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr>
<tr><td>GBP-EUR</td><td>=SUMIFS(Q2:Q<?php echo $this->_tpl_vars['addDETR']; ?>
,O2:O<?php echo $this->_tpl_vars['addDETR']; ?>
,"GBP",P2:P<?php echo $this->_tpl_vars['addDETR']; ?>
,"EUR",AZ2:AZ<?php echo $this->_tpl_vars['addDETR']; ?>
,"R",BB2:BB<?php echo $this->_tpl_vars['addDETR']; ?>
,"PAID")</td><td></td><td></td><td></td><td></td><td></td><td>GBP-EUR</td><td>=SUMIFS(X2:X<?php echo $this->_tpl_vars['addDETR']; ?>
,O2:O<?php echo $this->_tpl_vars['addDETR']; ?>
,"GBP",P2:P<?php echo $this->_tpl_vars['addDETR']; ?>
,"EUR",AZ2:AZ<?php echo $this->_tpl_vars['addDETR']; ?>
,"R",BB2:BB<?php echo $this->_tpl_vars['addDETR']; ?>
,"PAID")</td><td></td><td>=SUMIFS(Z2:Z<?php echo $this->_tpl_vars['addDETR']; ?>
,AZ2:AZ<?php echo $this->_tpl_vars['addDETR']; ?>
,"R",Z2:Z<?php echo $this->_tpl_vars['addDETR']; ?>
,"&gt;0",O2:O<?php echo $this->_tpl_vars['addDETR']; ?>
,"USD")</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr>
<tr><td>USD-EUR</td><td>=SUMIFS(Q2:Q<?php echo $this->_tpl_vars['addDETR']; ?>
,O2:O<?php echo $this->_tpl_vars['addDETR']; ?>
,"USD",P2:P<?php echo $this->_tpl_vars['addDETR']; ?>
,"EUR",AZ2:AZ<?php echo $this->_tpl_vars['addDETR']; ?>
,"R",BB2:BB<?php echo $this->_tpl_vars['addDETR']; ?>
,"PAID")</td><td></td><td></td><td></td><td></td><td></td><td>USD-EUR</td><td>=SUMIFS(X2:X<?php echo $this->_tpl_vars['addDETR']; ?>
,O2:O<?php echo $this->_tpl_vars['addDETR']; ?>
,"USD",P2:P<?php echo $this->_tpl_vars['addDETR']; ?>
,"EUR",AZ2:AZ<?php echo $this->_tpl_vars['addDETR']; ?>
,"R",BB2:BB<?php echo $this->_tpl_vars['addDETR']; ?>
,"PAID")</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr>
<tr><td>GBP-GBP</td><td>=SUMIFS(Q2:Q<?php echo $this->_tpl_vars['addDETR']; ?>
,O2:O<?php echo $this->_tpl_vars['addDETR']; ?>
,"GBP",P2:P<?php echo $this->_tpl_vars['addDETR']; ?>
,"GBP",AZ2:AZ<?php echo $this->_tpl_vars['addDETR']; ?>
,"R",BB2:BB<?php echo $this->_tpl_vars['addDETR']; ?>
,"PAID")</td><td></td><td></td><td></td><td></td><td></td><td>GBP-GBP</td><td>=SUMIFS(X2:X<?php echo $this->_tpl_vars['addDETR']; ?>
,O2:O<?php echo $this->_tpl_vars['addDETR']; ?>
,"GBP",P2:P<?php echo $this->_tpl_vars['addDETR']; ?>
,"GBP",AZ2:AZ<?php echo $this->_tpl_vars['addDETR']; ?>
,"R",BB2:BB<?php echo $this->_tpl_vars['addDETR']; ?>
,"PAID")</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr>
<tr><td>USD-USD</td><td>=SUMIFS(Q2:Q<?php echo $this->_tpl_vars['addDETR']; ?>
,O2:O<?php echo $this->_tpl_vars['addDETR']; ?>
,"USD",P2:P<?php echo $this->_tpl_vars['addDETR']; ?>
,"USD",AZ2:AZ<?php echo $this->_tpl_vars['addDETR']; ?>
,"R",BB2:BB<?php echo $this->_tpl_vars['addDETR']; ?>
,"PAID")</td><td></td><td></td><td></td><td></td><td></td><td>USD-USD</td><td>=SUMIFS(X2:X<?php echo $this->_tpl_vars['addDETR']; ?>
,O2:O<?php echo $this->_tpl_vars['addDETR']; ?>
,"USD",P2:P<?php echo $this->_tpl_vars['addDETR']; ?>
,"USD",AZ2:AZ<?php echo $this->_tpl_vars['addDETR']; ?>
,"R",BB2:BB<?php echo $this->_tpl_vars['addDETR']; ?>
,"PAID")</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr>