Presentaci - PowerPoint PPT Presentation

About This Presentation
Title:

Presentaci

Description:

COREP TEMPLATES TO XBRL MAPPER Fernando Wagener fernando.wagener_at_bde.es Bank of Spain Why develop a mapper with Excel VB? Concept It s a low cost tool which ... – PowerPoint PPT presentation

Number of Views:50
Avg rating:3.0/5.0
Slides: 16
Provided by: PEDR1182
Category:

less

Transcript and Presenter's Notes

Title: Presentaci


1
(No Transcript)
2
COREP TEMPLATES TO XBRL MAPPER
  • Fernando Wagener
  • fernando.wagener_at_bde.es
  • Bank of Spain

3
Why develop a mapper with Excel VB?
  • Concept
  • Its a low cost tool which converts COREP
    Templates written in Excel into an XBRL instance
  • It has been developed in Excel using VBA
  • Its not a latest technology, but its a useful
    solution
  • The file with the corep templates should be
    generated with the coreptest.xlt tool, a data
    entry facility available in the corep webpage
  • Its an appropriate environment because the data
    source is in Excel format

4
Why develop a mapper with Excel VB? (II)
  • Benefits
  • Easy to use
  • Very user friendly
  • Efficient, reliable and useful for testing
    instances
  • Fast, good for intensive testing
  • Easy to understand its internal operation
  • The code can be followed perfectly by people who
    program Excel macros
  • Autonomous the taxonomy is included in the Excel
    file
  • It doesnt need to have the taxonomy files
    available
  • It doesnt have links to external information or
    databases
  • No Internet connection required
  • Its not an on-line tool once the file has been
    downloaded, you dont need to be connected to the
    Internet.
  • Open code
  • You simply need the Microsoft Excel application
    to see or edit the code.

5
How to use (I)
  • Download converttoxbrl.xls
  • from www.corep.info

6
How to use (II)
  1. Open converttoxbrl.xls if the file is opened
    directly from the Webpage, it will not work
    properly. It must be downloaded.
  2. 3. Open the corep file the Find file button can
    be used to open the file with the COREP templates
  3. 4. Select the corep file once opened, the file
    must be selected from the scroll-down box.

7
How to use (III)
  • Press Generate XBRL
  • The xbrl instance will be generated in the same
    folder as the corep file
  • You can also see the results in the Output sheet

8
How it works (I)
  • The internal operation is divided into two
    phases
  • I) The generation of the Output sheet with all
    data required
  • II) The generation of the XBRL instance from the
    Output sheet

9
How it works (II)
  • I) The generation of the Output sheet with all
    data required
  • Its the most difficult step because the corep
    templates are very irregular.
  • The tool must know several parameters about the
    templates.
  • The cells with data must have their dimensions
    perfectly defined
  • The tool runs throughout all the templates
    looking for cells with values.
  • When it founds a cell with an item, it identifies
    the dimension depending on the column and the row
    where it is located.z

10
How it works (III)
  • Information about the Corep Templates in the
    Templates sheet

11
How it works (IV)
  • Information about the Corep Templates in
    Templates sheet Areas

12
How it works (V)
  • Information about the dimensions automatically
    imported into Dim and PriDim sheets

13
How it works (VI)
  • Output sheet

14
How it works (VII)
  • II) The generation of the XBRL instance from the
    Output sheet
  • It only takes the information included in the
    Output sheet and exports it in XBRL format

15
  • FERNANDO WAGENER - fernando.wagener_at_bde.es
  • THANK YOU FOR YOUR ATTENTION
Write a Comment
User Comments (0)
About PowerShow.com