... | ... | @@ -42,28 +42,38 @@ |
|
|
|
|
|
## Datasets
|
|
|
|
|
|
64 Excel files with multiple sheets
|
|
|
64 Excel files with multiple sheets. Each file is a dataset, each
|
|
|
sheet is a dimension
|
|
|
|
|
|
* **datasetCode**: table number, cell A1
|
|
|
* **datasetName**: cell A2
|
|
|
* **how to get release date**: top of bankstats html page
|
|
|
* **dataset docHref**: no
|
|
|
* **dataset notes**: yes (bottom of the sheet)
|
|
|
* **dimension_list**: (provided or to be made up from the series)
|
|
|
* **dimension_list**:
|
|
|
- u: units, cell A3
|
|
|
- i: indicator, cell A5
|
|
|
- sa: seasonal adustment, cell C3 (if available)
|
|
|
|
|
|
* **use of attributes**: ?
|
|
|
* **attribute_list**: no
|
|
|
* **available frequencies**: annual, quarterly, monthly
|
|
|
* **availability of previous updates**: no
|
|
|
* **availability of previous updates**: yes, via API
|
|
|
* **existence of real time datasets**: no
|
|
|
|
|
|
## Series
|
|
|
|
|
|
* **Series key**: (provided or to be made up, suggest scheme if necessary)
|
|
|
* **Series name**: (provided or to be made up from dimensions)
|
|
|
* **Series key**: concatenation of 3 or 4 letter prefix in column B (first non empty
|
|
|
cell) and code in the column of the series. Some prefixes are
|
|
|
ambiguous when two prefixes are used in the same
|
|
|
sheet. (ex. LPM/RPM). The only solution that I can think of is to
|
|
|
use the API to validate one combination or the other.
|
|
|
* **Series name**: concatenate the indicator label and the header
|
|
|
lines on top of the series (duplicate cells spanning several columns)
|
|
|
* **Series docHref**: yes/no
|
|
|
* **Series notes**: yes (next to series code and bottom of the sheet)
|
|
|
* **missing values**: code for missing values or way to detect them
|
|
|
* **date format**:
|
|
|
* **date format**: yyyy mmm,
|
|
|
* **mixed frequencies in the same dataset**: yes/no
|
|
|
|
|
|
## Updates
|
... | ... | |