Spreadsheet: sally_beck__33746__Data Source and Timeline for Dave Delainey report
Sheet: Sheet1

Transaction Counts and Volumetric Information - Page 1
Line Item Description on the Report | Data Source |  | Responsible Party |  | 1st Day Information Available
New Deals
Natural Gas - Houston | Sitara Deal Counts (excludes Book-to-book and daily retrades) |  | Obtained by Query run by [NAME] |  | 1st/2nd Work Day
Natural Gas - Calgary | Sitara Deal Counts (excludes Book-to-book and daily retrades) |  | Obtained by Query run by [NAME] |  | 1st/2nd Work Day
Power | EnPower Deal Counts using deal date by portfolio for physical and financial power deals only (excludes [NAME]) |  | Obtained by [NAME] using system-generated report from EnPower |  | 1st Work Day
Financial | TAGG/DCAF Deal Counts (excludes Book-to-Book deals, but includes intercompany transactions for which confirmations are sent out) |  | Obtained by Query run by [NAME] |  | 1st Work Day
Active Deals
Natural Gas - Houston | Sitara Deal Counts (excludes Book-to-book and daily retrades) |  | Obtained by Query run by [NAME] |  | 1st/2nd Work Day
Natural Gas - Calgary | Sitara Deal Counts (excludes Book-to-book and daily retrades) |  | Obtained by Query run by [NAME] |  | 1st/2nd Work Day
Power | EnPower Deal Counts using flow date by portfolio for physical and financial power deals only (excludes [NAME]) |  | Obtained by [NAME] using system-generated report from EnPower |  | 1st Work Day
Financial | Unify Settlements Deal Count (includes Gas, Liquids, Weather, Pulp & Paper and Interest Rate/FX transactions) |  | Obtained by [NAME] from Unify Financial Settlements report |  | 6th Work Day (after [NAME] cycle is complete)
Daily Sales Volumes
Natural Gas - Houston | Excel Spreadsheet totaling volumes by Legal Entity based on information from CPR |  | [NAME] (off-system)                 [NAME] (on-system) |  | 6th Work Day
Natural Gas - Calgary | Unify Settlements |  | [NAME] |  | 6th Work Day
Power | General Ledger |  | [NAME] |  | 6th Work Day
Coal | General Ledger |  | [NAME] |  | 4th Work Day
Pulp & Paper | General Ledger |  | [NAME] |  | 4th Work Day
General [NAME] 2
Line Item Description on the Report | Data Source |  | Responsible Party |  | 1st Day Information Available
Accounts Receivable
Natural Gas - Houston | Excel Spreadsheet totaling General [NAME] account balances by Legal Entity and aged by category, including details for amounts included in the >90 day aging category |  | [NAME] (off-system)                 [NAME] (on-system) |  | 6th Work Day
Natural Gas - Calgary | General Ledger |  | [NAME] |  | 6th Work Day
Power | General Ledger |  | [NAME] |  | 6th Work Day
Financial | General Ledger |  | [NAME] |  | 6th Work Day
Coal | General Ledger |  | [NAME] |  | 6th Work Day
Pulp & Paper | General Ledger |  | [NAME] |  | 6th Work Day
Interest Rate / FX | General Ledger |  | [NAME] |  | 6th Work Day
Non ENA Intercompany | Excel Spreadsheet totaling General [NAME] account balances by Legal Entity and aged by category |  | [NAME] (off-system)                 [NAME] (on-system) |  | 6th Work Day
Collection Rate %
Natural Gas - Houston | Excel spreadsheet computing %'s based on information from the General Ledger |  | [NAME] |  | 6th Work Day
Power | Excel spreadsheet computing %'s based on information from the General Ledger |  | [NAME] |  | 6th Work Day
Financial | Excel spreadsheet computing %'s based on information from the General Ledger |  | [NAME] |  | 6th Work Day
Interest Rate / FX | Excel spreadsheet computing %'s based on information from the General Ledger |  | [NAME] |  | 6th Work Day
Accounts Payable
Natural Gas - Houston | Excel Spreadsheet totaling General [NAME] account balances by Legal Entity and aged by category, including details for amounts included in the >90 day aging category |  | [NAME] (off-system)                 [NAME] (on-system) |  | 6th Work Day
Natural Gas - Calgary | General Ledger |  | [NAME] |  | 6th Work Day
Power | General Ledger |  | [NAME] |  | 6th Work Day
Financial | General Ledger |  | [NAME] |  | 6th Work Day
Coal | General Ledger |  | [NAME] |  | 6th Work Day
Pulp & Paper | General Ledger |  | [NAME] |  | 6th Work Day
Interest Rate / FX | General Ledger |  | [NAME] |  | 6th Work Day
Non ENA Intercompany | Excel Spreadsheet totaling General [NAME] account balances by Legal Entity and aged by category |  | [NAME] (off-system)                 [NAME] (on-system) |  | 6th Work Day
General [NAME] 3
Line Item Description on the Report | Data Source |  | Responsible Party |  | 1st Day Information Available
Gross Revenues
Natural Gas - Houston | Excel Spreadsheet totaling General [NAME] account balances by Legal Entity |  | [NAME] (off-system)                 [NAME] (on-system) |  | 6th Work Day
Natural Gas - Calgary | General Ledger |  | [NAME] |  | 6th Work Day
Power | General Ledger |  | [NAME] |  | 6th Work Day
Financial | General Ledger |  | [NAME] |  | 6th Work Day
Coal | General Ledger |  | [NAME] |  | 4th Work Day
Pulp & Paper | General Ledger |  | [NAME] |  | 4th Work Day
Interest Rate / FX | General Ledger |  | [NAME] |  | 6th Work Day
Non ENA Intercompany | Excel Spreadsheet totaling General [NAME] account balances by Legal Entity |  | [NAME] (off-system)                 [NAME] (on-system) |  | 6th Work Day
Flash-to-Actual Adjustments
Natural Gas - Houston | Excel spreadsheet summarizing all regional adjustments from OA Access database |  | [NAME] |  | 6th Work Day
Power | Excel spreadsheet |  | [NAME] |  | 6th Work Day
Volumetric Imbalances and Unaccounted for
Off system Imbalances | Excel spreadsheet detailing imbalances by contract from Unify as well as balances from pipeline statements |  | [NAME] |  | 9th Work Day
On system Imbalances | Excel spreadsheet detailing imbalances by contract from Unify as well as balances from customer confirmations |  | [NAME] |  | 6th Work Day
Off system Unaccounted for | General Ledger |  | [NAME] |  | 6th Work Day
On system Unaccounted for | General Ledger |  | [NAME] |  | 6th Work Day