{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Anvisningar","Blankett","Deluppgiftsgrupper","Värdebestämningar"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"Anvisningar","index":0,"n_rows":27,"n_cols":10,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["Skyldigheten att lämna uppgifter vid byggande"]
["Uppgifter om entreprenader (VSURAKKA)"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"<--- Tryck på knappen för att öppna tabellen som ska fyllas i"]
["ANVISNINGAR:"]
[]
["Ta makrorna i bruk när Excel ber om dem eller du får detta meddelande i övre balken: Inställningar - Ta detta innehåll i bruk - OK"]
[]
["När du trycker på knappen Skapa fil startar en makro som sparar den skapade filen "]
["på disken C: i mappen Ilmoittimelle (C:\\Ilmoittimelle)."]
["Existerar inte mappen frågar makron om den ska skapas."]
["Existerar ingen C:-disk måste du ändra den adress där makron sparar filen. (tekstiksi ja tarkistus aliohjelmiin)"]
[]
["Bekräfta alltid med Enter eller en piltangent de uppgifter du fyllt i."]
[]
["1. Fyll i uppgifterna i respektive kolumn enligt beskrivning och kod."]
[]
["2. Starta makron med kommandoknappen."]
[]
["3. När filen har skapats kan du granska att uppgifterna har matats rätt "]
["i tjänsten för kontroll av TYVI-material i webbtjänsten Ilmoitin.fi"]
[]
[]
["OM DU KOPIERAR UPPGIFTER UR EN ANNAN FIL SKA DU ANVÄNDA FUNKTIONEN \"KLISTRA IN SPECIAL\" "]
["SÅ ATT INTE KÄLLFILENS FORMATERINGAR FÖLJER MED OCH STÖR MAKRON."]

{"sheet":"Blankett","index":1,"n_rows":23,"n_cols":3,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[null,"Mata in uppgifterna i fältet Värde. Via knappen \"Lägg till deluppgiftsgrupper\" kan du lägga till återkommande deluppgiftsgrupper för entreprenörer och entreprenader.  Om en uppgift har vissa tillåtna värden ska du välja värdet med pilen bredvid fältet. Andra kalkyler eller kontroller ingår inte."]
[null,"När uppgifterna är inmatade kan du skapa en fil med kod-uppgiftspar via tangenten Skapa fil. Filen sparas i mappen C:\\Ilmoittimelle. Via knappen Kod-uppgiftspar får du på denna sida en lista över de uppgifter som omvandlats till kod-uppgiftspar."]
["Uppgifter om entreprenader",null,"Värde"]
["000","Postkod","VSURAKKA"]
["010","Den uppgiftsskyldiges finska FO-nummer eller personbeteckning"]
["150","Den uppgiftsskyldiges utländska beteckning"]
["151","Den uppgiftsskyldiges utländska beteckningstyp"]
["Uppgifter om byggarbetsplatsen eller avtalet"]
["250","Byggarbetsplatsens nummer "]
["251","Avtalets nummer"]
["252","Byggarbetsplatsens gatuadress"]
["253","Fritt formulerad beskrivning av var byggarbetsplatsen ligger"]
["254","Byggarbetsplatsens postnummer"]
["255","Byggarbetsplatsens postanstalt"]
["Uppgifter om entreprenören och entreprenaden – återkommande deluppgiftsgrupp, 0–n st.",null,"Deluppgiftsgrupper"]
["Entreprenadgivarens identifikationsuppgifter"]
["450","Entreprenadgivarens namn"]
["451","Entreprenadgivarens finska FO-nummer eller personbeteckning."]
["452","Entreprenadgivarens utländska beteckning"]
["453","Entreprenadgivarens utländska beteckningstyp"]
["454","Entreprenadgivarens hemviststat"]
["455","Namn på entreprenadgivarens hemstat"]
["999","Avslutningskod",1]

{"sheet":"Deluppgiftsgrupper","index":2,"n_rows":7,"n_cols":21,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Uppgifter om entreprenören och entreprenaden – återkommande deluppgiftsgrupp, 0–n st."]
[]
["Mata in uppgifterna och återvänd till huvudsidan genom att trycka på knappen Till blanketten."]
[]
["Uppdragets art","Namn","Entreprenörens FO-nummer eller finländska personbeteckning","Entreprenörens utländska beteckning","Entreprenörens utländska beteckningstyp","Entreprenörens hemstat","Namn på entreprenörens hemstat","Entreprenörens c/o-adress i hemstaten","Entreprenörens gatuadress i hemstaten","Entreprenörens PB i hemstaten","Entreprenörens postnummer i hemstaten","Entreprenörens postanstalt i hemstaten","Adressens landskod för entreprenören","Landets namn för entreprenörens adress","Efternamn för entreprenörens kontaktperson","Förnamn för entreprenörens kontaktperson","Telefonnummer för entreprenörens kontaktperson","Omvänd moms","Entreprenadens fakturerade belopp","Entreprenadens startdatum","Entreprenadens slutdatum"]
["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":"Värdebestämningar","index":3,"n_rows":283,"n_cols":5,"rows_kept":283,"cut":false,"hidden":false,"merged":[]}
[null,"VSRAKYHT",null,null,"VSURAKKA"]
[]
[null,"Anmälans typ"]
[null,"P"]
[null,"K"]
[null,"D"]
[]
[null,"Redovisningsmånad",null,null,"Omvänd moms"]
[null,"01",null,null,"1"]
[null,"02",null,null,"2"]
[null,"03"]
[null,"04",null,null,"Uppdragets art"]
[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,"Typ av utländsk beteckning"]
[null,"1"]
[null,"2"]
[null,"3"]
[null,"4"]
[]
[]
[null,"Landskod enligt ISO3166-1"]
[null,"AD","Andorra"]
[null,"AE","Förenade Arabemiraten"]
[null,"AF","Afghanistan"]
[null,"AG","Antigua och Barbuda"]
[null,"AI","Anguilla"]
[null,"AL","Albanien"]
[null,"AM","Armenien"]
[null,"AO","Angola"]
[null,"AQ","Antarktis"]
[null,"AR","Argentina"]
[null,"AS","Amerikanska Samoa"]
[null,"AT","Österrike"]
[null,"AU","Australien"]
[null,"AW","Aruba"]
[null,"AX","Åland"]
[null,"AZ","Azerbajdzjan"]
[null,"BA","Bosnien och Hercegovina"]
[null,"BB","Barbados"]
[null,"BD","Bangladesh"]
[null,"BE","Belgien"]
[null,"BF","Burkina Faso"]
[null,"BG","Bulgarien"]
[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 och Saba"]
[null,"BR","Brasilien"]
[null,"BS","Bahama"]
[null,"BT","Bhutan"]
[null,"BV","Bouvetön"]
[null,"BW","Botswana"]
[null,"BY","Vitryssland"]
[null,"BZ","Belize"]
[null,"CA","Kanada"]
[null,"CC","Cocosöarna "]
[null,"CD","Demokratiska republiken Kongo"]
[null,"CF","Centralafrikanska republiken"]
[null,"CG","Kongo-Brazzaville"]
[null,"CH","Schweiz"]
[null,"CI","Elfenbenskusten"]
[null,"CK","Cooköarna"]
[null,"CL","Chile"]
[null,"CM","Kamerun"]
[null,"CN","Kina"]
[null,"CO","Colombia"]
[null,"CR","Costa Rica"]
[null,"CU","Kuba"]
[null,"CV","Kap Verde"]
[null,"CW","Curaçao"]
[null,"CX","Julön"]
[null,"CY","Cypern"]
[null,"CZ","Tjeckien"]
[null,"DE","Tyskland"]
[null,"DJ","Djibouti"]
[null,"DK","Danmark "]
[null,"DM","Dominica"]
[null,"DO","Dominikanska republiken"]
[null,"DZ","Algeriet"]
[null,"EC","Ecuador"]
[null,"EE","Estland"]
[null,"EG","Egypten"]
[null,"EH","Västsahara"]
[null,"ER","Eritrea"]
[null,"ES","Spanien"]
[null,"ET","Etiopien"]
[null,"FI","Finland"]
[null,"FJ","Fiji"]
[null,"FK","Falklandsöarna"]
[null,"FM","Mikronesien"]
[null,"FO","Färöarna"]
[null,"FR","Frankrike"]
[null,"GA","Gabon"]
[null,"GB","Storbritannien"]
[null,"GD","Grenada"]
[null,"GE","Georgien"]
[null,"GF","Franska Guayana "]
[null,"GG","Guernsey"]
[null,"GH","Ghana"]
[null,"GI","Gibraltar"]
[null,"GL","Grönland"]
[null,"GM","Gambia"]
[null,"GN","Guinea"]
[null,"GP","Guadeloupe"]
[null,"GQ","Ekvatorialguinea"]
[null,"GR","Grekland "]
[null,"GS","Södra Georgien och Södra Sandwichöarna"]
[null,"GT","Guatemala"]
[null,"GU","Guam"]
[null,"GW","Guinea-Bissau"]
[null,"GY","Guyana"]
[null,"HK","Hongkong"]
[null,"HM","Heardön och McDonaldöarna "]
[null,"HN","Honduras"]
[null,"HR","Kroatien"]
[null,"HT","Haiti"]
[null,"HU","Ungern"]
[null,"ID","Indonesien"]
[null,"IE","Irland"]
[null,"IL","Israel"]
[null,"IM","Isle of Man"]
[null,"IN","Indien"]
[null,"IO","Brittiska territoriet i Indiska oceanen"]
[null,"IQ","Irak"]
[null,"IR","Iran"]
[null,"IS","Island"]
[null,"IT","Italien"]
[null,"JE","Jersey"]
[null,"JM","Jamaica"]
[null,"JO","Jordania"]
[null,"JP","Japan"]
[null,"KE","Kenya"]
[null,"KG","Kirgizistan "]
[null,"KH","Kambodja"]
[null,"KI","Kiribati"]
[null,"KM","Komorerna"]
[null,"KN","Saint Kitts och Nevis"]
[null,"KP","Demokratiska folkrepubliken Korea"]
[null,"KP","Republiken Korea"]
[null,"KW","Kuwait"]
[null,"KY","Caymanöarna"]
[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","Litauen"]
[null,"LU","Luxemburg"]
[null,"LV","Lettland"]
[null,"LY","Libyen"]
[null,"MA","Marocko"]
[null,"MC","Monaco"]
[null,"MD","Moldavien"]
[null,"ME","Montenegro"]
[null,"MF","Saint Martin (franska delen)"]
[null,"MG","Madagaskar"]
[null,"MH","Marshallöarna"]
[null,"MK","Makedonien"]
[null,"ML","Mali"]
[null,"MM","Myanmar"]
[null,"MN","Mongoliet"]
[null,"MO","Macao"]
[null,"MP","Nordmarianerna"]
[null,"MQ","Martinique"]
[null,"MR","Mauretanien"]
[null,"MS","Montserrat"]
[null,"MT","Malta"]
[null,"MU","Mauritius"]
[null,"MV","Maldiverna"]
[null,"MW","Malawi"]
[null,"MX","Mexiko"]
[null,"MY","Malaysia"]
[null,"MZ","Moçambique"]
[null,"NA","Namibia"]
[null,"NC","Nya Kaledonien"]
[null,"NE","Niger"]
[null,"NF","Norfolkön"]
[null,"NG","Nigeria"]
[null,"NI","Nicaragua"]
[null,"NL","Nederländerna"]
[null,"NO","Norge"]
[null,"NP","Nepal"]
[null,"NR","Nauru"]
[null,"NU","Niue"]
[null,"NZ","Nya Zeeland"]
[null,"OM","Oman"]
[null,"PA","Panama"]
[null,"PE","Peru"]
[null,"PF","Franska Polynesien"]
[null,"PG","Papua Nya Guinea"]
[null,"PH","Filippinerna"]
[null,"PK","Pakistan"]
[null,"PL","Polen"]
[null,"PM","Saint-Pierre och Miquelon "]
[null,"PN","Pitcairn"]
[null,"PR","Puerto Rico"]
[null,"PS","Palestina"]
[null,"PT","Portugal"]
[null,"PW","Palau"]
[null,"PY","Paraguay"]
[null,"QA","Qatar"]
[null,"RE","Réunion"]
[null,"RO","Rumänien"]
[null,"RS","Serbien"]
[null,"RU","Ryssland"]
[null,"RW","Rwanda"]
[null,"SA","Saudiarabien"]
[null,"SB","Salomonöarna"]
[null,"SC","Seychellerna"]
[null,"SD","Sudan"]
[null,"SE","Sverige"]
[null,"SG","Singapore"]
[null,"SH","Saint Helena"]
[null,"SI","Slovenien"]
[null,"SJ","Svalbard och Jan Mayen"]
[null,"SK","Slovakien"]
[null,"SL","Sierra Leone"]
[null,"SM","San Marino"]
[null,"SN","Senegal"]
[null,"SO","Somalia"]
[null,"SR","Surinam"]
[null,"SS","Sydsudan"]
[null,"ST","São Tomé och Príncipe"]
[null,"SV","El Salvador"]
[null,"SX","Sint Maarten (nederländska delen)"]
[null,"SY","Syrien"]
[null,"SZ","Swaziland"]
[null,"TC","Turks- och Caicosöarna"]
[null,"TD","Tchad"]
[null,"TF","De franska territorierna i södra Indiska oceanen"]
[null,"TG","Togo"]
[null,"TH","Thailand"]
[null,"TJ","Tadzjikistan"]
[null,"TK","Tokelau"]
[null,"TL","Östtimor"]
[null,"TM","Turkmenistan"]
[null,"TN","Tunisien"]
[null,"TO","Tonga"]
[null,"TR","Turkiet"]
[null,"TT","Trinidad och Tobago"]
[null,"TV","Tuvalu"]
[null,"TW","Taiwan"]
[null,"TZ","Tanzania"]
[null,"UA","Ukraina"]
[null,"UG","Uganda"]
[null,"UM","Förenta staternas mindre öar i Oceanien och Västindien"]
[null,"US","Amerikas Förenta stater"]
[null,"UY","Uruguay"]
[null,"UZ","Uzbekistan "]
[null,"VA","Vatikanen"]
[null,"VC","Saint Vincent och Grenadinerna"]
[null,"VE","Venezuela"]
[null,"VG","Brittiska Jungfruöarna"]
[null,"VI","Amerikanska Jungfruöarna"]
[null,"VN","Vietnam"]
[null,"VU","Vanuatu"]
[null,"WF","Wallis och Futuna"]
[null,"WS","Samoa"]
[null,"YE","Yemen"]
[null,"YT","Mayotte"]
[null,"ZA","Sydafrika"]
[null,"ZM","Zambia"]
[null,"ZW","Zimbabwe"]
[null,"XX","Staten finns inte i listrutan"]
[]
[null,"Ingen verksamhet"]
[null,"1"]
[null,"2"]