{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["Guidance","Preliminary checks","FLEGT licences template"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Guidance","index":0,"n_rows":3,"n_cols":1,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["GUIDANCE for compiling FLEGT licence data: \n\n- This information can be extracted from FLEGIT as an Excel file, which has the same format as this template. The reporting authority can then complete and verify the dataset as required, by editing the generated Excel sheet.\n\n- Please provide the customs/import data in the same row as the corresponding FLEGT licence data (i.e. do not provide separate documents or Excel sheets), so that licence and customs data can be compared. For reporting authorities using FLEGIT to generate the dataset, please note that in specific cases FLEGIT outputs the licence and customs data in different rows - this does not need to be edited and can be submitted as is.\n\n- Please ensure that at least the weight of the timber/timber products is provided and that the same unit of measure is used for both the FLEGT licence and cleared customs data.\n\n- Please use a separate line for each HS code (HS Heading as specified in Annexes II  and III  of the Regulation) for each FLEGT licence. Where a combined weight has been provided for a number of HS codes, please use only one row and enter all the different HS codes - separated by semicolon - in the HS code cell and add the combined weight.\n\n- Please enter 6 digits for HS codes (except for 4-digit codes) and do not use commas, spaces or full stops as separators for 6-digit HS codes (e.g. 441012 and not 4410.12 or 4410 12).\n\n- Please do not use commas, spaces or full stops as thousand separators for weights and/or volumes (e.g. 10000 kg and not 10,000 kg or 10.000 kg); only use full stops as decimal points (e.g. 6.3 m3 and not 6,3 m3). Please include three decimals for weights/volumes, where available. \n\n- For multiple countries of origin, please list all using their ISO2 codes and separate them with semicolons (“;”).\n\n- For multiple species within one HS code, please list all and separate them with semicolons (“;”).\n\n- Please include in the dataset all FLEGT licences which were received in the previous year but where the shipments were cleared in the reporting year (note that in FLEGIT the date the licence was ‘received’ corresponds to the date the license was ‘requested’). \n\n- Please include in the dataset all FLEGT licences which were received in the reporting year but for which the shipments will be cleared in the coming year (note that in FLEGIT the date the licence was ‘received’ corresponds to the date the license was ‘requested’). \n"]
[]
["Once you have compiled the data, please refer to the 'Preliminary checks' list to verify the dataset before submission."]

{"sheet":"Preliminary checks","index":1,"n_rows":17,"n_cols":4,"rows_kept":17,"cut":false,"hidden":false,"merged":[[8,3,11,3]]}
["Preliminary checks of the FLEGT licence dataset",null,"Check done? y/n","Further information:"]
[null,"Apply filters to the dataset"]
[1,"Ensure that all customs data is included, also where specific importers may submit self-declarations of imports. "]
[2,"Ensure that licence and customs data from outermost regions and other territories which are treated as your MS for customs purposes is also included, for those MS where this is relevant."]
[3,"Check ‘Licence Number’ data column: are there any typos in the licence numbers or licence numbers that do not follow the same formatting pattern as the rest? E.g. 170103800078002IDXX instead of 17.01038-00078.002-ID-XX.\nPlease remove any observation/testing rows that are not valid licences (e.g. licence numbers ending in –OBS)\n"]
[4,"Check ‘HS codes on FLEGT licence’ data column: are there any non-VPA HS codes included for which ID issue V-legal licences for 15 HS codes (see 'further information' to the right)? Please remove any such rows unless customs reclassified the HS codes and a FLEGT licence would have been required. ",null,"15 Non-VPA HS codes for which ID issue V-legal licences: 4420.10.00, 4420.90.90, 4601.22.00, 4602.12.00, 4819.10.00, 4819.20.00, 4819.40.00, 4820.10.00, 4820.20.00, 4820.30.00, 7009.92.00, 9401.59.00, 9405.20.90, 9401.53.00, 9403.83.00"]
[5,"Check ‘HS codes on FLEGT licence’ data column: are there any banned VPA HS codes included? Please cross-check the description of the goods in the first instance and/or the licence details. Please correct the HS code as appropriate. "]
[6,"Using the filters, check the dates columns (‘Date licence received’, ‘Date licence validated/rejected’ and ‘Date shipment cleared’) for dates in the future, missing dates, typos (e.g. not dates), etc.\n"]
[7,"Filter the ‘Date Licence received by CA’ to show any years earlier than the reporting year (i.e. for the 2019 report, any dates 2018 or earlier). Then please exclude any licences ONLY where the other two dates are also in earlier years (i.e. for the 2019 report, if a licence was received in 2018 or earlier, only include in the dataset if it was validated or the shipment was cleared in 2019, or if the shipment has not yet been cleared)\n",null,"Steps 6-9 on verification of the licences included in the dataset: For 2019 for example, the 3 kinds of licences to include (and only these):"]
[8,"Filter the ‘Date Licence received by CA’ to show all licences in the reporting year (i.e. for the 2019 report, all dates in 2019).\nCheck that all licences are included in the dataset: there should be licences from Jan-Dec (if any were received), even if they have not been cleared yet.\n"]
[9,"Filter the ‘Date shipment cleared’ to show any shipments cleared in years earlier than the reporting year (i.e. for the 2019 report, any dates 2018 or earlier). Then please exclude any shipments cleared in earlier years unless the licence was received/approved retrospectively.\n"]
[10,"Filter the ‘Date shipment cleared’ to show all shipments cleared in the reporting year (i.e. for the 2019 report, all dates in 2019).\nDouble-check that all cleared licences are included in the dataset; some of the licences may have been received/validated the year before and these need to remain included.\n"]
[11,"Check ‘Status of licence’ data column: is there anything other than approved/validated/rejected/ignore?\n"]
[12,"Check ‘Status of clearance’ data column: is there anything other than cleared/not cleared (if customs did not clear the shipment that arrived) /blank (if customs have not had the shipment yet)\n"]
[13,"Check ‘Country of harvest’ and ‘Scientific names’ data columns for anything unusual e.g. numbers. Please separate all ISO2 codes or species names with semicolons ( ‘;’ ).\n"]
[14,"Check both columns with HS codes for anything unusual e.g. letters or typos. HS codes should be 6 digits (except for 4-digit codes) and should not contain commas, spaces or full stops as separators (e.g. 441012 and not 4410.12 or 4410 12).\n"]
[15,"Check the quantities, both licence and customs data:\na. Are any of the rows completely blank for quantities? Filter Volume to bring up blanks, then see if these rows are also blank in weight and number of items. \nb. Do the same filtering, for a quantity of 0 - does the row have a non-zero quantity in the other columns?\nc. Are ‘,’ or ‘.’ or ‘ ‘ used as thousand separators? (e.g. 10,000 kg or 10.000 kg or 10 000kg). Please only use full stops as decimal points (e.g. 6.35 m3 and not 6,35 m3) and do not use thousand separators at all. \nd. Sort the dataset on Volume. Are any of the quantities repeated a lot? Are there rows that are completely duplicated? Sort again on Net weight and check again.\ne. Sum up the quantities on the licence side and on the customs side – are the quantities within 10% of each other? E.g. is the volume based on licences within 10% the volume based on customs data? This will not be a perfect match, as there are licences which aren’t cleared yet, or some which are reported in different units. \n"]

{"sheet":"FLEGT licences template","index":2,"n_rows":2,"n_cols":19,"rows_kept":2,"cut":false,"hidden":false,"merged":[[0,9,0,13],[0,14,0,17]]}
[{"$nulls":9},"As per FLEGT licence",{"$nulls":4},"Actually imported"]
["Licence number","Date licence received by CA (for FLEGIT: date licence submitted electronically)","Date licence validated/ rejected","Status of licence (Pending / Validated /  Rejected)","Date shipment cleared","Status of clearance (cleared/ disposed/ not cleared)","FLEGT licence issuing country","Country of harvest","Species (scientific name) if available","HS codes on FLEGT licence (6 digits)","Description of goods","Volume (m³)","Net weight (kg)","Number of units (if applicable)","HS codes cleared by customs (6 digits)","Volume (m³)","Net weight (kg)","Number of units (if applicable)","Comments"]