{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Instructions","StandData","TreatmentProposals","beskrivning av kolumner (sv)","column descriptions (en)"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"comments":4,"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":"Instructions","index":0,"n_rows":21,"n_cols":3,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Svenska:",null,"English:"]
["1. Fyll i data i bladen StandRegister och TreatmentProposals. Notera vilka kolumner som är obligatoriska (röda), frivlliga (vita), samt rekommenderade (gröna).",null,"1. Fill in the data in sheets StandRegister and TreatmentProposals. Note what columns are optional (white), obligatory (red) and recommended (green)"]
["2. Spara Excel-dokumentet!!!!",null,"2. Save the document!!!"]
["3. Klicka på knappen \"Export to csv-files\" nedan för att spara dessa filer som csv-filer. Om knappen inte visas eller om du inte kan köra makrot av någon anledning, så spara vart och ett av de två bladen som csv-fil via Arkiv >  Spara som…",null,"3. Click on button \"Export to csv-files\" to save these sheets as csv-files. If the button does not work, then save each sheet to a csf-file via File > Save As…"]
["4. Importera datat till Heureka-databasen med hjälp av funktionen \"Importera beståndsregister\" som finns i menyn Datahantering.",null,"4. Import the data to the Heureka database with funktion Import Stand Register under menu Data Management"]
[]
["Hjälplänk: "]
["http://heurekaslu.org/help/index.html?importera_bestandsregister.htm"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Red field",null,"Mandatory"]
["Green field",null,"Recommended"]
["White field",null,"Optional, may be needed depening on context"]

{"sheet":"StandData","index":1,"n_rows":2,"n_cols":108,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["AreaLevel2","AreaLevel3","StandId","ParentStandId","TotalArea","ProdArea","ImpArea","NCArea","Layer","Register","CountyCode","Altitude","Latitude","CoordEast","CoordNorth","DistanceToCoast","RoadId1","RoadId2","ClimateCode","SKSManagementClass","MaturityClass","BlueTargetClass","SiteIndexSpecies","SIS","SIH","SI_Management","SoilMoistureCode","VegetationType","BottomLayer","SoilDepth","SoilWater","Texture","SlopeDirectionNorthEast","Ditch","Peat","SoilBearingCapacity","Surface","SlopeType","TerrRoadSlope","InventoryYear","OwnerType","EvenAgedCode","DGV","DG","H","MeanAge","N","G","V","CAI","PropPine","PropSpruce","PropBirch","PropAspen","PropOak","PropBeech","PropSouthernBroadleaf","PropContorta","PropOtherBroadleaf","DiameterType","DGPine","DGSpruce","DGBirch","DGAspen","DGOak","DGBeech","DGSouthernBroadleaf","DGContorta","DGOtherBroadleaf","HPine","HSpruce","HBirch","HAspen","HOak","HBeech","HSouthernBroadleaf","HContorta","HOtherBroadleaf","SpeciesUser","ProportionSpeciesUser","MeanDiameterSpeciesUser","MeanHeightSpeciesUser","DeadWoodTotal","DeadWoodDecayClass1","DeadWoodDecayClass2","DeadWoodDecayClass3","DeadWoodDecayClass4","DeadWoodDecayClass5","TerrainTransportDistance","LastClearcutYear","LastThinningYear","LastFertilizationYear","LastRegenerationYear","RegenerationMethod","RegenerationSpecies","RegenerationBreeded","Note","UserDefinedVariable1_TaxType","UserDefinedVariable2","UserDefinedVariable3","UserDefinedVariable4","UserDefinedVariable5","UserDefinedVariable6","UserDefinedVariable7","UserDefinedVariable8","UserDefinedVariable9","UserDefinedVariable10","SetAsideType"]
[null,null,"ExampleStand1",null,13.37,13.24,0.13,0,0,10,15,100,59,1533907,6614742,100,null,null,null,"PG","S1",null,"T",26,null,null,2,13,null,null,null,null,null,null,0,2,2,1,null,2011,null,null,29.1,26.464290909999999,24.5,85,560,28.61,326.3,6.1710000000000003,0.41839999999999999,0.56030000000000002,2.8400000000000002E-2,null,null,null,null,null,0,0,29.8,28.6,17.3,null,null,null,null,null,null,25,24,18]

{"sheet":"TreatmentProposals","index":2,"n_rows":1,"n_cols":8,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["AreaLevel2","AreaLevel3","StandId","Treatment","Year","Species","ThinningForm","ThinningGrade"]

{"sheet":"beskrivning av kolumner (sv)","index":3,"n_rows":114,"n_cols":8,"rows_kept":114,"cut":false,"hidden":false,"merged":[]}
["No","Blad","Kolum","Kommentar","Typ","Giltiga värden","Beskrivning","Länk"]
[1,"StandData; TreatmentProposals","AreaLevel2",null,"text(max 50 tecken)",null,"Namn på underområde 2, t ex namnet på ett skifte på fastigheten"]
[2,"StandData; TreatmentProposals","AreaLevel3",null,"text(max 50 tecken)",null,"Namn på underområde 3, namn på ytterligare ett \"underområde\"."]
[3,"StandData; TreatmentProposals","StandId","obligatory","text(max 25 tecken)",null,"BeståndsID (namn). Ska vara unik för aktuellt område (inte bara unik för underområde!). Tips! \"Padda gärna med nollor före id:t så att alla id får samma längd, det gör sorteringen tydligare)"]
[4,"StandData","ParentStandId (alt. SetAsideWithinStandId)","https://www.heurekaslu.se/wiki/Import_of_stand_register#ParentStandId","text(max 25 tecken)","StandId av en tidigare inmatad rad","Om denna kolumn har ett värde betyder det att beståndet är en hänsynsyta inom ett annat bestånd. \nVärdet ska då vara huvudbeståndets StandId.\nDess utveckling kan kopplas till huvudbeståndet."]
[5,"StandData","TotalArea","obligatory","decimaltal",null,"Total areal (ha)"]
[6,"StandData","ProdArea","obligatory","decimaltal",null,"Produktiv areal (ha)"]
[7,"StandData","ImpArea",null,"decimaltal",null,"Impediment (jha)"]
[8,"StandData","NCArea",null,"decimaltal",null,"Areal som ska avsättas för naturvård (ha). Användning av denna variabel beror på inställningarna i kontrolltabellen NatureConservation) "]
[9,"StandData","Layer","obligatory if more than one layer","heltal","1 eller 2","1 eller tom = Huvudskikt (default)\n2=Överståndarskikt\n6=Naturvårdsskikt (3,4,5 reserverade)"]
[11,"StandData","Register",null,"heltal",null,"Frivillig heltalsvariabel"]
[12,"StandData","CountyCode","Obligatorisk om data ska användas för trädsimulering","heltal","1-31","Länskod enligt RIS. Klicka på länken för förteckning.","http://heurekaslu.org/wiki/Variable:CountyCode"]
[13,"StandData","Altitude","Obligatorisk om data ska användas för trädsimulering","decimaltal",null,"Höjd över havet (m)"]
[14,"StandData","Latitude","Obligatorisk om data ska användas för trädsimulering","decimaltal","54-70","Breddgrad (° N). Obligatorisk om inte koordinater anges."]
[15,"StandData","CoordEast",null,"decimaltal",null,"Ostkoordnat, m (RT90, 2.5 gon V eller Sweref99TM)"]
[16,"StandData","CoordNorth",null,"decimaltal",null,"Nordkoordinat, m (RT90, 2.5 gon V eller Sweref99TM)"]
[17,"StandData","DistanceToCoast",null,"heltal",null,"Avstånd till kust, km"]
[18,"StandData","RoadId1",null,"heltal",null,"Väg som beståndet ansluter till"]
[19,"StandData","RoadId2",null,"heltal",null,"Väg som beståndet ansluter till"]
[20,"StandData","ClimateCode","recommended if data is used for tree simulation","heltal","0-6","Klimatzon: \n0 = Övriga\n1 = M1 Maritim, Västkusten\n2 = M2 Maritim, Östkusten\n3 = M3 Maritim, Fjällen\n4 = K1 Kontinental, Mellansverige\n5 = K2 Kontinental, Norra Sverige\n6 = K3 Kontinental, Södra Sverige","http://heurekaslu.org/wiki/Variable:ClimateCode"]
[21,"StandData","SKSManagementClass","useful for defining forest domains","text (2 tecken)","PG,PF,NS,NO","Målklass enl. Skogsstyrelsens \"Grön Skogsbruksplan\" "]
[22,"StandData","MaturityClass",null,"text (2 tecken)","K1-E3","Huggningsklass (kallas MaturityClass i engelsk version)\nK1 = Kalmark som är obehandlad eller ofullständigt behandlad (åtgärder kvarstår).\nK2 = Kalmark under föryngring, behandlad med nödvändiga återväxtåtgärder (åtgärder utförda).\nR1 = Röjningsskog. Plantskog, skog vars huvudträdslag har en medelhöjd som är lägre än 1.3 m.\nR2 = Röjningsskog. Ungskog, skog vars huvudträdslag har en medelhöjd mellan 1.3 och 7 m.\nG1 = Yngre gallringsskog, skog som är yngre än lägsta tillåtna ålder för föryngringsavverkning.\nG2 = Äldre gallringsskog, skog som snart uppnår lägsta ålder för föryngringsavverkning.\nS1 = Skog som kan föryngringsavverkas. Yngre avverkningsbar skog som inte är att hänföra till S2.\nS2 = Skog som är mogen att föryngringsavverka. Skog som uppnått lämplig växttid eller som av andra skäl bör föryngringsavverkas.\nS3 = Skog som är mogen att föryngringsavverka, men som inte bör föryngringsavverkas pga. naturvårdsskäl.\nE1 = Restskog.\nE2 = Gles skog eller skog av ett för marken olämpligt trädslag.\nE3 = Hagmarkskog."]
[23,"StandData","BlueTargetClass","0, 1, 2, 4, 8 eller summan av flera av dessa",null,null,"Blue target class (Blå målklass) according to WWF. You can enter a code such as \"VO\". If a stand consists of multiple classes, you can enter the sum of the numeric codes, for example VS and VO can be entered as 12 (4 + 8). Heureka has a GIS function (the BufferZone tool in the map window) to create buffer zone of varying widths depending on the class value of the intersecting water streams. Alternative columns names are \"BlaMalklass\", \"BlueTargetClass\", \"BlueGoalClass\" and \"BlueTarget\". The value is not used in Heureka per se, other than that you can used in forest domain and report conditions.\nNone or blank = No specific water protection or no class assigned\nVG or 1 = Water environment with general management consideration\nVF or 2 = Water environment with enforced management considerations\nVS or 4 = Water environment with specific management actions\nVO or 8 = Water environment to be set aside and left unmanaged","https://www.heurekaslu.se/wiki/StandRegisterFileSpecification#blamalklass"]
[24,"StandData","SiteIndexSpecies","Obligatorisk om data ska användas för trädsimulering","heltal eller text","T (1), G (2), B (3), Bok (6), Ek (5), C (8)","Bonitetsvisande trädslag: \nT eller 1=Tall (H100)\nG eller 2=Gran (H100)\nB eller 3=Björk (H50)\nEk eller 5=Ek (H100)  \nBok eller 6= Bok (H100)\nC eller 8= Contorta (H50) (för contorta anges hellre tall och SIS och SIH enligt tall H100)\nSystemet konverterar SIS resp SIH till tall eller gran beroende på trädslag, enligt http://www.lantmateriet.se/upload/filer/kartor/programvaror/Produktionsformaga_och_konvertering_av_standortsindex.pdf."]
[25,"StandData","SIS","Obligatorisk om data ska användas för trädsimulering","decimaltal",">0","Ståndortsindex enligt ståndsortsbonitering. Kan även beräknas av PlanStart givet att alla ståndortsfaktorer har matats in (lat, alt, textur, jorddjup, vegtyp, markfukt, rörl markvatten, torv, lutning). "]
[26,"StandData","SIH",null,"decimaltal",null,"Ståndortsindex enligt höjdutveckling. Används ej."]
[27,"StandData","SI_Management",null,null,null,"Ståndortsindex för bestämning av LÅF (lägsta ålder föryngringsavverkning), givet att huvudträdslaget är tall eller gran, övriga trädslag är inte beroende av ståndortsindex. Om kolumnen fylls i används högsta värdet av detta och SIS. Om kolumnen lämnas tom används SIS. SIS kan justeras upp av klimatmodellen, det gör inte SI_Management. ","https://www.heurekaslu.se/wiki/Import_of_stand_register#ParentStandId"]
[28,"StandData","SoilMoistureCode","Obligatorisk om data ska användas för trädsimulering","heltal","1-5","Markfuktighet: \n1 = Torr\n2 = Frisk\n3 = Frisk-fuktig\n4 = Fuktig\n5 = Blöt"]
[29,"StandData","VegetationType","Obligatorisk om data ska användas för trädsimulering","heltal","1-18","1=Högört utan ris\n2=Högört med bredbl. gräs \n3=Högört med lingon \n4=Lågört utan ris \n5=Lågört med bredbl. gräs \n6=Lågört med lingon) \n7=Utan fältskikt \n8=Bredbladig grästyp \n9=Smalbladig grästyp \n10=Hög starr \n11=Låg starr \n12=Fräken \n13=Blåbär \n14=Lingon \n15=Kråkbär \n16=Fattigris \n17=Lavrik typ \n18=Lavtyp"]
[30,"StandData","BottomLayer",null,"heltal","1-6","Bottenskikt enligt RIS:\n1 =Lavtyp\n2=Lavrik vitmosstyp \n3=Lavrik typ \n4=Vitmosstyp\n5=Sumpmosstyp (ej vitmosstyp) \n6=Friskmosstyp"]
[31,"StandData","SoilDepth","Används för SIS-beräkning om SIS ej anges","heltal","1-4","Jorddjup enligt RIS:\n1 =Mäktigt (>70 cm, inga synliga hällar)\n2 =Tämligen grunt (20-70 cm, enstaka hällar)\n3 =Grunt (<20 cm, rikligt med hällar)\n4=Mycket varierande (Brottytor i berggrunden delvis synliga)\n"]
[32,"StandData","SoilWater","recommended if data is used for tree simulation","heltal","1-3","Rörligt markvatten enligt RIS:\n1=Sällan-saknas \n2=Kortare perioder\n3=Längre perioder"]
[33,"StandData","Texture",null,"heltal",null,"Jordartens textur enligt RIS (morän/sediment):\n1=Stenig morän/sten\n2=Grusig morän/grus\n3=Sandig morän/grovsand\n4=Sandig-moig morän/mellansand\n5=Sandig-moig morän/grovmo\n6=Moig morän/finmo\n7=Mjälig morän/mjäla\n8=Lerig morän/lera\nhttp://heureka.resgeom.slu.se/wiki/index.php?title=Variable:SoilTextureCode"]
[34,"StandData","SlopeDirectionNorthEast",null,"heltal",null,"1=Lutningsriktning nordost\n0=annan"]
[35,"StandData","Ditch","recommended if data is used for tree simulation","heltal","0/1","1=Dike eller ingrepp med dränerande funktion förekommer beståndet som påverkar produktionen. Egentligen inom 25 m från en provyta centrum enligt RIS.\n0=Inget dike"]
[36,"StandData","Peat","required if data is used for tree simulation",null,"0/1","1=Torv (djupare än 30 cm) täcker mer än 50 % av ytan\n0=Torv täcker högst 50 % av ytan"]
[37,"StandData","SoilBearingCapacity",null,"heltal","1-5","Grundförhållanden (bärighet) enligt Skogforsk terrängtypschema GYL (Berg, 1985):\n 1 = Mycket goda grundförhålanden. Går i allmänhet bra att köra året runt.\n2 = Mellanklass/goda. Går bra att köra runt, förutom ev. vid tjällossning och ymninga höstregn.\n3 = Medelgoda. Försiktighet under perioden med hög markfuktighet, särskilt med lågt liggande terrängpartier, med tunga maskiner och många överfarter.\n4 = Mellanklass/dåliga. Viktigt med armering. Tveksam bärighet för tunga maskiner om marken inte är frusen. Risk för lokala försumpningar.\n5 = Mycket dåliga grundförhållanden. Hjufordon kan användas endast då marken är frusen."]
[38,"StandData","Surface",null,"heltal","1-5","Ytstruktur enligt Skogforsk terrängtypschema GYL (Berg, 1985)\n1 = Mycket jämn\n2 = Jämn\n3 = Medeljämn\n4 = Ojämn\n5 = Mycket ojämn"]
[39,"StandData","SlopeType",null,"heltal","1-5","Lutning inom beståndet\n1 = 0-10 %\n2 = 10-20 %\n3 = 20-33 %\n4 = 33-50 %\n5 = >50 %"]
[40,"StandData","TerrRoadSlope",null,"heltal","1-5","Lutning fram till billväg\n1 = 0-10 %\n2 = 10-20 %\n3 = 20-33 %\n4 = 33-50 %\n5 = >50 %"]
[41,"StandData","InventoryYear","Obligatorisk om data ska användas för trädsimulering","heltal (ÅÅÅÅ) eller datum (ÅÅÅÅ-MM-DD)",null,"Inventeringsår"]
[42,"StandData","OwnerType",null,"heltal","0-5","Ägargrupp\n0=Ej uppgift\n1=Stat\n2=Kyrka\n3=Övriga offentliga\n4=Bolag\n5=Enskilda"]
[43,"StandData","EvenAgedCode",null,"heltal","1-3","1 = Helt likåldrigt\n2 = Tämligen likåldrigt\n3 = Olikåldrigt\nVid simulering av trädlistor påverkas trädens ålder och storlek av denna parameter"]
[44,"StandData","DGV",null,"decimaltal",null,"Grundytevägd medeldiameter (cm)"]
[45,"StandData","DG","At least two of DG, N and G are required for established stands (H >= 7m)","decimaltal",null,"Grundytemedelstammens diameter (cm)"]
[46,"StandData","H",null,"decimaltal",null,"Medelhöjd (grundytevägd alt. huvudstammarnas aritmetiska medelhöjd i ungskog)"]
[47,"StandData","MeanAge","Obligatorisk om data ska användas för trädsimulering","decimaltal",null,"Medelålder (grundytevägd totalålder, år)"]
[48,"StandData","N","At least two of DG, N and G are required for established stands (H >= 7m)","decimaltal",null,"Stamantal (träd per ha, produktiv areal)"]
[49,"StandData","G","At least two of DG, N and G are required for established stands (H >= 7m)","decimaltal",null,"Grundyta (m2/ha, produktiv areal)"]
[50,"StandData","V",null,"decimaltal",null,"Volym (m3sk/ha, produktiv areal)"]
[51,"StandData","CAI",null,"decimaltal",null,"Löpande tillväxt (m3sk/ha,år)"]
[52,"StandData","PropPine","Obligatorisk om data ska användas för trädsimulering","decimaltal",null,"Andel tall (av grundyta om medelhöjd >7 m, annars av stamantal)"]
[53,"StandData","PropSpruce","Obligatorisk om data ska användas för trädsimulering","decimaltal",null,"Andel gran (av grundyta om medelhöjd >7 m, annars av stamantal)"]
[54,"StandData","PropBirch","Obligatorisk om data ska användas för trädsimulering","decimaltal",null,"Andel björk (av grundyta om medelhöjd >7 m, annars av stamantal)"]
[55,"StandData","PropAspen","Obligatorisk om data ska användas för trädsimulering","decimaltal",null,"Andel asp (av grundyta om medelhöjd >7 m, annars av stamantal)"]
[56,"StandData","PropOak","Obligatorisk om data ska användas för trädsimulering","decimaltal",null,"Andel ek (av grundyta om medelhöjd >7 m, annars av stamantal)"]
[57,"StandData","PropBeech","Obligatorisk om data ska användas för trädsimulering","decimaltal",null,"Andel bok (av grundyta om medelhöjd >7 m, annars av stamantal)"]
[58,"StandData","PropSouthernBroadleaf","Obligatorisk om data ska användas för trädsimulering","decimaltal",null,"Andel ädellövträd (av grundyta om medelhöjd >7 m, annars av stamantal)"]
[59,"StandData","PropContorta","Obligatorisk om data ska användas för trädsimulering","decimaltal",null,"Andel tall (av grundyta om medelhöjd >7 m, annars av stamantal)"]
[60,"StandData","PropOtherBroadleaf","Obligatorisk om data ska användas för trädsimulering","decimaltal",null,"Andel övriga trädslag (av grundyta om medelhöjd >7 m, annars av stamantal)"]
[61,"StandData","DiameterType",null,"heltal","0 eller 1","Typ av medeldiameter. 0=Dg (rekommenderas),  1=Dgv. "]
[62,"StandData","DgPine","recommended if data is used for tree simulation","decimaltal",null,"Medeldiameter DG  tall (cm). Dgv om dg ej tillgänglig (se kolumn DiameterType)"]
[63,"StandData","DgSpruce","recommended if data is used for tree simulation","decimaltal",null,"Medeldiameter DG  gran (cm). Dgv om dg ej tillgänglig (se kolumn DiameterType)"]
[64,"StandData","DgBirch","recommended if data is used for tree simulation","decimaltal",null,"Medeldiameter DG  björk (cm). Dgv om dg ej tillgänglig (se kolumn DiameterType)"]
[65,"StandData","DgAspen","recommended if data is used for tree simulation","decimaltal",null,"Medeldiameter DG  asp (cm). Dgv om dg ej tillgänglig (se kolumn DiameterType)"]
[66,"StandData","DgOak","recommended if data is used for tree simulation","decimaltal",null,"Medeldiameter DG  ek (cm). Dgv om dg ej tillgänglig (se kolumn DiameterType)"]
[67,"StandData","DgBeech","recommended if data is used for tree simulation","decimaltal",null,"Medeldiameter DG  bok (cm). Dgv om dg ej tillgänglig (se kolumn DiameterType)"]
[68,"StandData","DgSouthernBroadleaf","recommended if data is used for tree simulation","decimaltal",null,"Medeldiameter DG  ädellövträd (cm). Dgv om dg ej tillgänglig (se kolumn DiameterType)"]
[69,"StandData","DgContorta","recommended if data is used for tree simulation","decimaltal",null,"Medeldiameter DG  contorta (cm). Dgv om dg ej tillgänglig (se kolumn DiameterType)"]
[70,"StandData","DgOtherBroadleaf","recommended if data is used for tree simulation","decimaltal",null,"Medeldiameter DG  övriga trädslag (cm). Dgv om dg ej tillgänglig (se kolumn DiameterType)"]
[71,"StandData","HPine","recommended if data is used for tree simulation","decimaltal",null,"Medelhöjd (hgv, m)   tall "]
[72,"StandData","HSpruce","recommended if data is used for tree simulation","decimaltal",null,"Medelhöjd (hgv, m)   gran "]
[73,"StandData","HBirch","recommended if data is used for tree simulation","decimaltal",null,"Medelhöjd (hgv, m)   björk "]
[74,"StandData","HAspen","recommended if data is used for tree simulation","decimaltal",null,"Medelhöjd (hgv, m)   asp "]
[75,"StandData","HOak","recommended if data is used for tree simulation","decimaltal",null,"Medelhöjd (hgv, m)   ek "]
[76,"StandData","HBeech","recommended if data is used for tree simulation","decimaltal",null,"Medelhöjd (hgv, m)   bok "]
[77,"StandData","HSouthernBroadleaf","recommended if data is used for tree simulation","decimaltal",null,"Medelhöjd (hgv, m)   ädellövträd "]
[78,"StandData","HContorta","recommended if data is used for tree simulation","decimaltal",null,"Medelhöjd (hgv, m)   contorta "]
[79,"StandData","HOtherBroadleaf","recommended if data is used for tree simulation","decimaltal",null,"Medelhöjd (hgv, m)   övriga trädslag "]
[80,"StandData","SpeciesUser",null,"heltal","10-96, se länk","Trädslag definierat av användaren","http://heureka.resgeom.slu.se/wiki/index.php?title=Definition:SpeciesCode/sv"]
[81,"StandData","ProportionSpeciesUser",null,"decimaltal","mellan 0 och 1","Andel av användarangivet trädslag SpeciesUser (av grundyta om medelhöjd >7 m, annars av stamantal)"]
[82,"StandData","MeanDiameterSpeciesUser",null,"decimaltal",null,"Medeldiameter användarangivet trädslag (dg eller dgv beroende på kol DiameterType, cm)"]
[83,"StandData","HSpeciesUser",null,"decimaltal",null,"Medelhöjd användarangivet trädslag (hgv, m)"]
[84,"StandData","DeadWoodTotal",null,"decimaltal",null,"Volym död ved (m3sk/ha)"]
[85,"StandData","DeadWoodDecayClass1",null,"decimaltal",null,"Död ved i nedbrytningsklass 1 (m3sk/ha)"]
[86,"StandData","DeadWoodDecayClass2",null,"decimaltal",null,"Död ved i nedbrytningsklass 2 (m3sk/ha)"]
[87,"StandData","DeadWoodDecayClass3",null,"decimaltal",null,"Död ved i nedbrytningsklass 3 (m3sk/ha)"]
[88,"StandData","DeadWoodDecayClass4",null,"decimaltal",null,"Död ved i nedbrytningsklass 4 (m3sk/ha)"]
[89,"StandData","DeadWoodDecayClass5",null,"decimaltal",null,"Död ved i nedbrytningsklass 5 (m3sk/ha)"]
[90,"StandData","TerrainTransportDistance",null,"heltal","större än 0 eller tom","Terrängtransportavstånd (avstånd mellan beståndsmitt och märmaste väg, m)"]
[91,"StandData","LastClearcutYear",null,"heltal (ÅÅÅÅ)","Format: ÅÅÅÅ","Årtal senaste slutavverkning"]
[92,"StandData","LastThinningYear",null,"heltal (ÅÅÅÅ)","Format: ÅÅÅÅ","Årtal senaste gallring "]
[93,"StandData","LastFertilizationYear",null,"heltal (ÅÅÅÅ)","Format: ÅÅÅÅ","Årtal senaste gödsling"]
[94,"StandData","LastRegenerationYear",null,"heltal (ÅÅÅÅ)","Format: ÅÅÅÅ","Årtal senaste föryngring"]
[95,"StandData","RegenerationMethod","Anges om föryngring redan gjorts","heltal","0-2","Föryngringsmetod:\n0 = Naturlig föryngring\n1 = Plantering\n2 = Sådd"]
[96,"StandData","RegenerationSpecies","Anges om föryngring redan gjorts","heltal","1-9","Huvudträdslag i föryngring","http://heureka.resgeom.slu.se/wiki/index.php?title=Definition:SpeciesCode/sv"]
[97,"StandData","RegenerationBreeded","Anges om föryngring redan gjorts","heltal","0-1","Utfördes föryngringen med förädlat material\n0=Ej förädlat material\n1=Förädlat material"]
[98,"StandData","Note",null,"text",null,"Anteckning"]
[99,"StandData","UserDefinedVariable1",null,"heltal",null,"Fri för användare att ange. Om du byter namn på kolumn blir detta tillgängligt i tabellvyer. Variabeln blir tillgänglig i villkor t ex när man gör skogsdomäner i PlanWise."]
[100,"StandData","UserDefinedVariable2",null,"heltal"]
[101,"StandData","UserDefinedVariable3",null,"heltal"]
[102,"StandData","UserDefinedVariable4",null,"heltal"]
[103,"StandData","UserDefinedVariable5",null,"heltal"]
[104,"StandData","UserDefinedVariable6",null,"decimaltal"]
[105,"StandData","UserDefinedVariable7",null,"decimaltal"]
[106,"StandData","UserDefinedVariable8",null,"decimaltal"]
[107,"StandData","UserDefinedVariable9",null,"decimaltal"]
[108,"StandData","UserDefinedVariable10",null,"decimaltal"]
[109,"StandData","SetAsideType","https://www.heurekaslu.se/wiki/Import_of_stand_register#SetAsideType"]
[110,"TreatmentProposals","Treatment",null,"heltal eller textkod","1-32768","Åtgärdskod","http://heureka.resgeom.slu.se/wiki/index.php?title=Definition:TreatmentCode/sv "]
[111,"TreatmentProposals","Year",null,"heltal eller intervall angivet som t ex 1-5 om åtgärd ska göras första femårsperioden","Enskilt värde = periodår som åtgärden ska utföras. År 0=omedelbart. Intervall: Intervall då åtgärden ska utföras, alt. Ingen åtgärd får utföras (om ”None”). "]
[112,"TreatmentProposals","Species",null,"heltal","önskat trädslag som ska lämnas kvar fyllas i. Som specialfall kan man ange vad som ska tas bort genom att ange ”Ta bort” fram trädslaget.",null,"http://heureka.resgeom.slu.se/wiki/index.php?title=Definition:SpeciesCode/sv"]
[113,"TreatmentProposals","ThinningForm",null,"text","\"FromBelow\",\"Uniform\",\"FromAbove\", eller tom"]
[114,"TreatmentProposals","ThinningGrade",null,"heltal (%)","mellan 0 och 100, eller tom"]

{"sheet":"column descriptions (en)","index":4,"n_rows":114,"n_cols":7,"rows_kept":114,"cut":false,"hidden":false,"merged":[]}
["No","Sheet","Column","Comment","Type","Valid values","Description"]
[1,"StandData; TreatmentProposals","AreaLevel2",null,"text(max 50 tecken)",null,"Description for level two, to be used in any subdivision of the analysis area (for stratification purposes, etc.)"]
[2,"StandData; TreatmentProposals","AreaLevel3",null,"text(max 50 tecken)",null,"Description for level three to be used in any subdivision of the analysis area (for stratification purposes, etc.)"]
[3,"StandData; TreatmentProposals","StandId","obligatory","text(max 25 tecken)",null,"Identity of stand (sv: Avdelning) Mandatory!"]
[4,"StandData","ParentStandId (alt. SetAsideWithinStandId)","https://www.heurekaslu.se/wiki/Import_of_stand_register#ParentStandId"]
[5,"StandData","TotalArea","obligatory","float"]
[6,"StandData","ProdArea","obligatory","float"]
[7,"StandData","ImpArea",null,"float"]
[8,"StandData","NCArea",null,"float"]
[9,"StandData","Layer","obligatory if more than one layer","integer","1 eller 2","Mandatory if more the one layer"]
[10,"StandData","Register",null,"integer",null,"Register number (some companys use this)"]
[11,"StandData","CountyCode","obligatory if data should be used for tree simulation","integer","1-31"]
[12,"StandData","Altitude","obligatory if data should be used for tree simulation","float"]
[13,"StandData","Latitude","obligatory if data should be used for tree simulation","float","54-70"]
[14,"StandData","CoordEast",null,"float"]
[15,"StandData","CoordNorth",null,"float"]
[16,"StandData","DistanceToCoast",null,"integer"]
[17,"StandData","RoadId1",null,"integer"]
[18,"StandData","RoadId2",null,"integer"]
[19,"StandData","ClimateCode","recommended if data is used for tree simulation","integer","0-6"]
[20,"StandData","SKSManagementClass","useful for defining forest domains","text (2 tecken)","PG,PF,NS,NO"]
[21,"StandData","MaturityClass",null,"text (2 tecken)","K1-E3"]
[22,"StandData","BlueTargetClass","https://www.heurekaslu.se/wiki/Import_of_stand_register#blamalklass"]
[23,"StandData","SiteIndexSpecies","obligatory if data should be used for tree simulation","integer eller text","T (1), G (2), B (3), Bok (6), Ek (5), C (8)"]
[24,"StandData","SIS","obligatory if data should be used for tree simulation","float"]
[25,"StandData","SIH",null,"float"]
[26,"StandData","SI_Management"]
[27,"StandData","SoilMoistureCode","obligatory if data should be used for tree simulation","integer","1-5"]
[28,"StandData","VegetationType","obligatory if data should be used for tree simulation","integer","1-18"]
[29,"StandData","BottomLayer",null,"integer","1-6"]
[30,"StandData","SoilDepth",null,"integer","1-4"]
[31,"StandData","SoilWater","recommended if data is used for tree simulation","integer","1-3"]
[32,"StandData","Texture",null,"integer"]
[33,"StandData","SlopeDirectionNorthEast",null,"integer"]
[34,"StandData","Ditch",null,"integer","0/1"]
[35,"StandData","Peat","recommended if data is used for tree simulation",null,"0/1"]
[36,"StandData","SoilBearingCapacity",null,"integer","1-5"]
[37,"StandData","Surface",null,"integer","1-5"]
[38,"StandData","SlopeType","Within-stand slope","integer","1-5"]
[39,"StandData","TerrRoadSlope","Slope in forwarding road to roadside","integer"]
[40,"StandData","InventoryYear","obligatory if data should be used for tree simulation","integer (ÅÅÅÅ) or date (ÅÅÅÅ-MM-DD)"]
[41,"StandData","OwnerType",null,"integer","0-5"]
[42,"StandData","EvenAgedCode",null,"integer","1-3"]
[43,"StandData","DGV",null,"float"]
[44,"StandData","DG",null,"float"]
[45,"StandData","H",null,"float"]
[46,"StandData","MeanAge","obligatory if data should be used for tree simulation","float"]
[47,"StandData","N","obligatory if data should be used for tree simulation","float"]
[48,"StandData","G","obligatory if data should be used for tree simulation","float"]
[49,"StandData","V",null,"float"]
[50,"StandData","CAI",null,"float"]
[51,"StandData","PropPine","obligatory if data should be used for tree simulation","float"]
[52,"StandData","PropSpruce","obligatory if data should be used for tree simulation","float"]
[53,"StandData","PropBirch","obligatory if data should be used for tree simulation","float"]
[54,"StandData","PropAspen","obligatory if data should be used for tree simulation","float"]
[55,"StandData","PropOak","obligatory if data should be used for tree simulation","float"]
[56,"StandData","PropBeech","obligatory if data should be used for tree simulation","float"]
[57,"StandData","PropSouthernBroadleaf","obligatory if data should be used for tree simulation","float"]
[58,"StandData","PropContorta","obligatory if data should be used for tree simulation","float"]
[59,"StandData","PropOtherBroadleaf","obligatory if data should be used for tree simulation","float"]
[60,"StandData","DiameterType",null,"integer","0 eller 1","Indicator for which type of mean diameter is entered in fields DGPine to DGBroadLeaf.\n0 (default)= Diameter of mean basal area tree\n1 = Basal area weighted mean diameter"]
[61,"StandData","DGPine","recommended if data is used for tree simulation","float"]
[62,"StandData","DGSpruce","recommended if data is used for tree simulation","float"]
[63,"StandData","DGBirch","recommended if data is used for tree simulation","float"]
[64,"StandData","DGAspen","recommended if data is used for tree simulation","float"]
[65,"StandData","DGOak","recommended if data is used for tree simulation","float"]
[66,"StandData","DGBeech","recommended if data is used for tree simulation","float"]
[67,"StandData","DGSouthernBroadleaf","recommended if data is used for tree simulation","float"]
[68,"StandData","DGContorta","recommended if data is used for tree simulation","float"]
[69,"StandData","DGOtherBroadleaf","recommended if data is used for tree simulation","float"]
[70,"StandData","HPine","recommended if data is used for tree simulation","float"]
[71,"StandData","HSpruce","recommended if data is used for tree simulation","float"]
[72,"StandData","HBirch","recommended if data is used for tree simulation","float"]
[73,"StandData","HAspen","recommended if data is used for tree simulation","float"]
[74,"StandData","HOak","recommended if data is used for tree simulation","float"]
[75,"StandData","HBeech","recommended if data is used for tree simulation","float"]
[76,"StandData","HSouthernBroadleaf","recommended if data is used for tree simulation","float"]
[77,"StandData","HContorta","recommended if data is used for tree simulation","float"]
[78,"StandData","HOtherBroadleaf","recommended if data is used for tree simulation","float"]
[79,"StandData","SpeciesUser",null,"integer","10-96, se länk"]
[80,"StandData","ProportionSpeciesUser",null,"float","mellan 0 och 1"]
[81,"StandData","MeanDiameterSpeciesUser",null,"float"]
[82,"StandData",{"$f":"'beskrivning av kolumner (sv)'!D83","v":0},null,"float"]
[83,"StandData","DeadWoodTotal",null,"float"]
[84,"StandData","DeadWoodDecayClass1",null,"float"]
[85,"StandData","DeadWoodDecayClass2",null,"float"]
[86,"StandData","DeadWoodDecayClass3",null,"float"]
[87,"StandData","DeadWoodDecayClass4",null,"float"]
[88,"StandData","DeadWoodDecayClass5",null,"float"]
[89,"StandData","TerrainTransportDistance",null,"integer","större än 0 eller tom"]
[90,"StandData","LastClearcutYear",null,"integer (ÅÅÅÅ)","Format: ÅÅÅÅ"]
[91,"StandData","LastThinningYear",null,"integer (ÅÅÅÅ)","Format: ÅÅÅÅ"]
[92,"StandData","LastFertilizationYear",null,"integer (ÅÅÅÅ)","Format: ÅÅÅÅ"]
[93,"StandData","LastRegenerationYear",null,"integer (ÅÅÅÅ)","Format: ÅÅÅÅ"]
[94,"StandData","RegenerationMethod","Anges om föryngring redan gjorts","integer","0-2"]
[95,"StandData","RegenerationSpecies","Anges om föryngring redan gjorts","integer","1-9"]
[96,"StandData","RegenerationBreeded","Anges om föryngring redan gjorts","integer","0-1","0=Ej förädlat material   1=Förädlat material"]
[97,"StandData","Note",null,"text"]
[98,"StandData","UserDefinedVariable1",null,"integer"]
[99,"StandData","UserDefinedVariable2",null,"integer"]
[100,"StandData","UserDefinedVariable3",null,"integer"]
[101,"StandData","UserDefinedVariable4",null,"integer"]
[102,"StandData","UserDefinedVariable5",null,"integer"]
[103,"StandData","UserDefinedVariable6",null,"float"]
[104,"StandData","UserDefinedVariable7",null,"float"]
[105,"StandData","UserDefinedVariable8",null,"float"]
[106,"StandData","UserDefinedVariable9",null,"float"]
[107,"StandData","UserDefinedVariable10",null,"float"]
[108,"StandData","SetAsideType","https://www.heurekaslu.se/wiki/Import_of_stand_register#SetAsideType"]
[null,"TreatmentProposals","Treatment",null,"integer eller textkod","1-32768"]
[null,"TreatmentProposals","Year",null,"integer eller intervall angivet som t ex 1-5 om åtgärd ska göras första femårsperioden","Enskilt värde = periodår som åtgärden ska utföras. År 0=omedelbart. Intervall: Intervall då åtgärden ska utföras, alt. Ingen åtgärd får utföras (om ”None”). "]
[null,"TreatmentProposals","Species",null,"integer","önskat trädslag som ska lämnas kvar fyllas i. Som specialfall kan man ange vad som ska tas bort genom att ange ”Ta bort” fram trädslaget."]
[null,"TreatmentProposals","ThinningForm",null,"text","\"FromBelow\",\"Unifrom\",\"FromAbove\", eller tom"]
[null,"TreatmentProposals","ThinningGrade",null,"integer (%)","mellan 0 och 100, eller tom"]