{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Getting started","The Form","Recurring data sets","Definitions of values"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"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":"Getting started","index":0,"n_rows":27,"n_cols":10,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["Reporting construction-sector details"]
["Contracts (VSURAKKA)"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"<--- Click this button to fill in the Form. "]
["Getting started:"]
[]
["Give Yes as the answer to the Enable Macros question.  Alternatively, click Settings - Enable this content - OK - to enable the Macros. "]
[]
["When you click on the Create Report button, you start a Macro that creates and saves a file according to the input you have made.  "]
["The place where it saves it is the \"Ilmoittimelle\" folder of your C: disk (C:\\Ilmoittimelle)."]
["If there is no \"Ilmoittimelle\" folder, the Macro will set it up. Click OK when prompted."]
["If you workstation has no C: disk you must change the Save setting of the Macro. "]
[]
["You must click Enter or an arrow button after any input you make, otherwise it is not saved."]
[]
["1. Enter your input in the data elements as appropriate."]
[]
["2. Click Create Report."]
[]
["3. When the report file is ready, we recommend that you go to "]
["Ilmoitin.fi to run a technical check on it. "]
[]
[]
["If you copy-paste any input from another computer file, use Paste Special - Values/Text, "]
["otherwise you may disrupt the Macro with fonts or other formatting coming from the file you copied from."]

{"sheet":"The Form","index":1,"n_rows":23,"n_cols":3,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[null,"Enter the values. To add recurring partial data sets (data about the contractor or the contract), click Add Recurring Data Sets. Entries that must be within the range of their permissible values are indicated by an arrow next to the value field. In addition to the arrows, this worksheet contains no other features to control the users' input."]
[null,"When you are done with your input, click the Create Report button to create a computer file that contains name-value pairs. It is saved automatically in a folder named \"C:\\Ilmoittimelle\". Clicking the Name-value pairs button displays a list of the data now formatted as name-value pairs."]
["Contract details",null,"Arvo"]
["000","Name of information flow","VSURAKKA"]
["010","Filer's Finnish Business ID or personal identity code"]
["150","Filer's ID code issued in a foreign country"]
["151","Type of the foreign-issued ID code"]
["Details on the construction site or the contract"]
[250,"Site ID"]
[251,"Contract number"]
["252","Site street address"]
["253","Free-text description of where the site is located"]
["254","Site postal code "]
["255","Post office"]
["Recurring data set on contractor and contract details, quantity: 0 - n. ",null,"Recurring data sets"]
["ID details of the principal of a subcontractor-filer "]
["450","Name of the principal "]
["451","Principal’s Finnish Business ID or personal identity code"]
["452","Principal's foreign identity code "]
["453","Type of the principal’s foreign ID code"]
["454","Principal's country of tax residence "]
["455","Name of the country of tax residence"]
["999","Final code.",1]

{"sheet":"Recurring data sets","index":2,"n_rows":7,"n_cols":21,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Recurring data set on contractor and contract details, quantity: 0 - n. "]
[]
["Enter your input, then click on the Go to Form button."]
[]
["Type of contract","Contractor's name","Contractor's Business ID or Finnish personal identity code","Contractor's foreign-issued identity code ","Type of the foreign-issued ID code","Contractor's country of tax residence ","Contractor's country of tax residence ","Contractor's home address with its 'c/o' details ","Contractor's address in the country of tax residence ","Contractor's PO box in the country of tax residence ","Contractor's postal code in the country of tax residence ","Contractor's post-office name in the country of tax residence ","Country code of the address country","Country name of the address country ","Last name of contractor's person to contact ","First name of contractor's person to contact ","Telephone of contractor's person to contact ","VAT reverse charge","Amount invoiced so far","Contract start date","Contract end date"]
["P/V","P/V","P/V","P/V","P/V","P/V","P/V","V","P/V","P/V","P/V","P/V","P/V","P/V","P/V","P/V","P/V","P/V","P/V","P/V","P/V"]
[400,300,301,302,303,304,305,"306",307,308,309,310,311,312,350,351,352,402,403,407,408]

{"sheet":"Definitions of values","index":3,"n_rows":283,"n_cols":5,"rows_kept":283,"cut":false,"hidden":false,"merged":[]}
[null,"VSRAKYHT",null,null,"VSURAKKA"]
[]
[null,"Filing type "]
[null,"P"]
[null,"K"]
[null,"D"]
[]
[null,"Reporting month ",null,null,"VAT reverse charge "]
[null,"01",null,null,"1"]
[null,"02",null,null,"2"]
[null,"03"]
[null,"04",null,null,"Type of contract "]
[null,"05",null,null,"1"]
[null,"06",null,null,"2"]
[null,"07",null,null,"4"]
[null,"08"]
[null,"09"]
[null,"10"]
[null,"11"]
[null,"12"]
[]
[null,"Type of the foreign-issued ID code"]
[null,"1"]
[null,"2"]
[null,"3"]
[null,"4"]
[]
[]
[null,"Country codes (ISO3166-1) "]
[null,"AD","Andorra"]
[null,"AE","Arabiemiraatit"]
[null,"AF","Afganistan"]
[null,"AG","Antigua ja Barbuda"]
[null,"AI","Anguilla"]
[null,"AL","Albania"]
[null,"AM","Armenia"]
[null,"AO","Angola"]
[null,"AQ","Antarktis"]
[null,"AR","Argentiina"]
[null,"AS","Amerikan Samoa"]
[null,"AT","Itävalta"]
[null,"AU","Australia"]
[null,"AW","Aruba"]
[null,"AX","Ahvenanmaa"]
[null,"AZ","Azerbaidzan"]
[null,"BA","Bosnia ja Herzegovina"]
[null,"BB","Barbados"]
[null,"BD","Bangladesh"]
[null,"BE","Belgia"]
[null,"BF","Burkina Faso"]
[null,"BG","Bulgaria"]
[null,"BH","Bahrain"]
[null,"BI","Burundi"]
[null,"BJ","Benin"]
[null,"BL","Saint-Barthélemy"]
[null,"BM","Bermuda"]
[null,"BN","Brunei Darussalam"]
[null,"BO","Bolivia"]
[null,"BQ","Bonaire, Sint Eustatius and Saba"]
[null,"BR","Brasilia"]
[null,"BS","Bahama"]
[null,"BT","Bhutan"]
[null,"BV","Bouvet'n saari"]
[null,"BW","Botswana"]
[null,"BY","Valko-Venäjä"]
[null,"BZ","Belize"]
[null,"CA","Kanada"]
[null,"CC","Kookossaaret"]
[null,"CD","Kongon demokraattinen tasavalta"]
[null,"CF","Keski-Afrikan tasavalta"]
[null,"CG","Kongon tasavalta"]
[null,"CH","Sveitsi"]
[null,"CI","Norsunluurannikko"]
[null,"CK","Cookinsaaret"]
[null,"CL","Chile"]
[null,"CM","Kamerun"]
[null,"CN","Kiina"]
[null,"CO","Kolumbia"]
[null,"CR","Costa Rica"]
[null,"CU","Kuuba"]
[null,"CV","Kap Verde"]
[null,"CW","Curacao"]
[null,"CX","Joulusaari"]
[null,"CY","Kypros"]
[null,"CZ","Tsekki"]
[null,"DE","Saksa"]
[null,"DJ","Djibouti"]
[null,"DK","Tanska "]
[null,"DM","Dominica"]
[null,"DO","Dominikaaninen tasavalta"]
[null,"DZ","Algeria"]
[null,"EC","Ecuador"]
[null,"EE","Viro"]
[null,"EG","Egypti"]
[null,"EH","Länsi-Sahara"]
[null,"ER","Eritrea"]
[null,"ES","Espanja"]
[null,"ET","Etiopia"]
[null,"FI","Suomi"]
[null,"FJ","Fidzi"]
[null,"FK","Falklandinsaaret"]
[null,"FM","Mikronesian liittovaltio"]
[null,"FO","Färsaaret"]
[null,"FR","Ranska"]
[null,"GA","Gabon"]
[null,"GB","Iso-Britannia"]
[null,"GD","Grenada"]
[null,"GE","Georgia"]
[null,"GF","Ranskan Guayana"]
[null,"GG","Guernsey"]
[null,"GH","Ghana"]
[null,"GI","Gibraltar"]
[null,"GL","Grönlanti"]
[null,"GM","Gambia"]
[null,"GN","Guinea"]
[null,"GP","Guadeloupe"]
[null,"GQ","Päiväntasaajan Guinea"]
[null,"GR","Kreikka "]
[null,"GS","Etelä-Georgia ja Eteläiset Sandwichsaaret"]
[null,"GT","Guatemala"]
[null,"GU","Guam"]
[null,"GW","Guinea-Bissau"]
[null,"GY","Guyana"]
[null,"HK","Hongkong"]
[null,"HM","Heard ja McDonaldinsaaret"]
[null,"HN","Honduras"]
[null,"HR","Kroatia"]
[null,"HT","Haiti"]
[null,"HU","Unkari"]
[null,"ID","Indonesia"]
[null,"IE","Irlanti"]
[null,"IL","Israel"]
[null,"IM","Mansaari"]
[null,"IN","Intia"]
[null,"IO","Brittiläinen Intian valtameren alue"]
[null,"IQ","Irak"]
[null,"IR","Iran"]
[null,"IS","Islanti"]
[null,"IT","Italia"]
[null,"JE","Jersey"]
[null,"JM","Jamaika"]
[null,"JO","Jordania"]
[null,"JP","Japani"]
[null,"KE","Kenia"]
[null,"KG","Kirgisia"]
[null,"KH","Kambodza"]
[null,"KI","Kiribati"]
[null,"KM","Komorit"]
[null,"KN","Saint Kitts ja Nevis"]
[null,"KP","Korean demokraattinen kansantasavalta"]
[null,"KP","Korean tasavalta"]
[null,"KW","Kuwait"]
[null,"KY","Caymansaaret"]
[null,"KZ","Kazakstan"]
[null,"LA","Laos"]
[null,"LB","Libanon"]
[null,"LC","Saint Lucia"]
[null,"LI","Liechtenstein"]
[null,"LK","Sri Lanka"]
[null,"LR","Liberia"]
[null,"LS","Lesotho"]
[null,"LT","Liettua"]
[null,"LU","Luxemburg"]
[null,"LV","Latvia"]
[null,"LY","Libya"]
[null,"MA","Marokko"]
[null,"MC","Monaco"]
[null,"MD","Moldova"]
[null,"ME","Montenegro"]
[null,"MF","Saint Martin (French part)"]
[null,"MG","Madagaskar"]
[null,"MH","Marshallinsaaret"]
[null,"MK","Makedonia"]
[null,"ML","Mali"]
[null,"MM","Myanmar"]
[null,"MN","Mongolia"]
[null,"MO","Macao"]
[null,"MP","Pohjois-Mariaanit"]
[null,"MQ","Martinique"]
[null,"MR","Mauritania"]
[null,"MS","Montserrat"]
[null,"MT","Malta"]
[null,"MU","Mauritius"]
[null,"MV","Malediivit"]
[null,"MW","Malawi"]
[null,"MX","Meksiko"]
[null,"MY","Malesia"]
[null,"MZ","Mosambik"]
[null,"NA","Namibia"]
[null,"NC","Uusi-Kaledonia"]
[null,"NE","Niger"]
[null,"NF","Norfolkinsaari"]
[null,"NG","Nigeria"]
[null,"NI","Nicaragua"]
[null,"NL","Alankomaat"]
[null,"NO","Norja"]
[null,"NP","Nepal"]
[null,"NR","Nauru"]
[null,"NU","Niue"]
[null,"NZ","Uusi Seelanti"]
[null,"OM","Oman"]
[null,"PA","Panama"]
[null,"PE","Peru"]
[null,"PF","Ranskan Polynesia"]
[null,"PG","Papua-Uusi-Guinea"]
[null,"PH","Filippiinit"]
[null,"PK","Pakistan"]
[null,"PL","Puola"]
[null,"PM","Saint-Pierre ja Miquelon"]
[null,"PN","Pitcairn"]
[null,"PR","Puerto Rico"]
[null,"PS","Palestiina"]
[null,"PT","Portugali"]
[null,"PW","Palau"]
[null,"PY","Paraguay"]
[null,"QA","Qatar"]
[null,"RE","Réunion"]
[null,"RO","Romania"]
[null,"RS","Serbia"]
[null,"RU","Venäjä"]
[null,"RW","Ruanda"]
[null,"SA","Saudi-Arabia"]
[null,"SB","Salomonsaaret"]
[null,"SC","Seychellit"]
[null,"SD","Sudan"]
[null,"SE","Ruotsi"]
[null,"SG","Singapore"]
[null,"SH","Saint Helena"]
[null,"SI","Slovenia"]
[null,"SJ","Svalbard ja Jan Mayen"]
[null,"SK","Slovakia"]
[null,"SL","Sierra Leone"]
[null,"SM","San Marino"]
[null,"SN","Senegal"]
[null,"SO","Somalia"]
[null,"SR","Suriname"]
[null,"SS","Etelä-Sudan"]
[null,"ST","Sao Tomé ja Principe"]
[null,"SV","El Salvador"]
[null,"SX","Sint Maarten (Dutch part)"]
[null,"SY","Syyria"]
[null,"SZ","Swazimaa"]
[null,"TC","Turks- ja Caicossaaret"]
[null,"TD","Tsad"]
[null,"TF","Ranskan eteläiset alueet"]
[null,"TG","Togo"]
[null,"TH","Thaimaa"]
[null,"TJ","Tadzikistan"]
[null,"TK","Tokelau"]
[null,"TL","Itä-Timor"]
[null,"TM","Turkmenistan"]
[null,"TN","Tunisia"]
[null,"TO","Tonga"]
[null,"TR","Turkki"]
[null,"TT","Trinidad ja Tobago"]
[null,"TV","Tuvalu"]
[null,"TW","Taiwan"]
[null,"TZ","Tansania"]
[null,"UA","Ukraina"]
[null,"UG","Uganda"]
[null,"UM","Yhdysvaltain pienet erillissaaret"]
[null,"US","Amerikan Yhdysvallat"]
[null,"UY","Uruguay"]
[null,"UZ","Uzbegistan "]
[null,"VA","Vatikaanivaltio"]
[null,"VC","Saint Vincent ja Grenadiinit"]
[null,"VE","Venezuela"]
[null,"VG","Brittiläiset Neitsytsaaret"]
[null,"VI","Yhdysvaltain Neitsytsaaret"]
[null,"VN","Vietnam"]
[null,"VU","Vanuatu"]
[null,"WF","Wallis ja Futunasaaret"]
[null,"WS","Samoa"]
[null,"YE","Jemen"]
[null,"YT","Mayotte"]
[null,"ZA","Etelä-Afrikka"]
[null,"ZM","Sambia"]
[null,"ZW","Zimbabwe"]
[null,"XX","Country is not listed"]
[]
[null,"No-activity reporting "]
[null,"1"]
[null,"2"]