AMAPstudio

User Tools


Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
documentation:exceladdsdoublequotesduringcsvexport [2019/10/25 08:29]
coligny
documentation:exceladdsdoublequotesduringcsvexport [2019/10/25 09:54] (current)
coligny
Line 1: Line 1:
 ====== Excel adds double quotes around some fields during CSV file export ====== ====== Excel adds double quotes around some fields during CSV file export ======
  
-If you build or tune your data files with Excel, you may use its 'Save As CSV file' or 'Save As tab delimited file' feature to get a text file with a tab separator, which is a standard for input files in Capsis.+If you build or tune your data files with Excel, you may use its 'Save As CSV file' or 'Save As tab delimited file' feature to get a text file with a tab separator ​between columns, which is a standard for input files in Capsis ​(e.g. inventory files, species files, soil compartment files, configuration or parameter files...). 
 + 
 +The exported file may contain sections like this small extract: 
 + 
 +<​code>​ 
 +#name1 name2     name3  
 +1      12.5      {(0,​65);​(1,​65);​(2,​65)} 
 + 
 +</​code>​ 
 + 
 +But sometimes, you may instead get something **with extra double quotes**, looking like this:  
 + 
 +<​code>​ 
 +#name1 name2     name3  
 +1      12.5      "​{(0,​65);​(1,​65);​(2,​65)}"​ 
 + 
 +</​code>​ 
 + 
 +and the file will not be read in Capsis. 
 + 
 +This extra double quotes addition seems to be done by the 'Save As' feature in Excel. A workaround has been found to get the expected result, based on Copy and Paste, here is an example of how it can be done. 
 + 
 +  - **Open a simple text file editor** (e.g. Textpad, NotePad++, SciTE, gedit...) and create a new empty document. 
 +  - **In Excel, select the range of cells** to be exported (you may try **Ctrl+A** to select faster the whole document to check if it works). 
 +  - **Copy the selection** in the system clipboard with **Ctrl+C**. 
 +  - **Paste it in the empty document** in the text editor with **Ctrl+V**. 
 +  - **Save** the resulting text file. 
 + 
 +Below is an example of a complex input file with several different sections for the Samsara2 model, which can benefit from this simple Copy/Paste technique. 
 + 
 +<​code>​ 
 + 
 +# Model : samsara2  
 +# Author : Benoit Courbaud  
 +# Project : sam  
 +# Stand date : 2012  
 +# Initial source  
 +# File format :  
 +#    Name : Chargeur d'​inventaires Samsara2  
 +#    Class name : samsara2.extension.ioformat.Samsa2Inventory  
 +#    Version : 1.0  
 +#    Author : F. de Coligny  
 +  
 +# Samsa2InventoryExport  
 +#  
 +# Key records section  
 +#​  
 + ​treeRecruitmentDbh = 0  
 + date = 2010  
 + ​cellWidth = 5  
 + ​plotXMin = 0  
 + ​plotYMin = 0  
 + ​plotXMax = 125  
 + ​plotYMax = 80  
 + ​plotSlope = 0  
 + ​plotAspect = 144  
 + ​bottomAzimut = 270  
 + ​canopyTop = 40  
 + ​balRadius = 17  
 +  
 +  
 +# Species parameters  
 +#  
 +# Spec. Spec. Spec Growth Growth Growth Growth Growth Height Height Height CBHeight CBHeight CBRadius CBRadius CBRadius Crown Crown Crown Sapl. Sapl. Sapl. Sapl. Sapl. Sapl. Sapl. Sapl. Sapl. Sapl. Mortal. Mortal. Mortal. Mortal. Mortal. Mortal. Storm Storm Storm 
 +# spCode spName Color VolRule LogA beta sigmaB sigmaLbda muLogK sigmaLogK r muLogK sigmaLogK muLogK sigmaLogK b shape Transmis HBc/​H RainDensity repDbh Alpha1 Alpha2 Beta1 Beta2 Beta3 InitialHeight Rhg1 Rhg2 P1 P2 P3 P4 P5 HarvestDbh stormP1 stormP2 stormP3 
 +0 Epicea 0,​128,​0 Algan8 -3.58 0.588 0.6 0.1049 3.53 0.1039 0.0767 0.488 0.6164 -0.774 0.1578 0.525 P 0.2 0.23 0 17.5 5 1 -2.23 0.215 -0.001102 0.08 0.98 17.8 -2.158 -0.066 0.058 -7.28 0.00034 300 -1.863 0.923 0.205 
 +1 Sapin 0,​0,​128 Algan8 -1.347 0.416 0.6025 0.1844 3.28 0.1766 0.0846 0.714 0.4615 -0.354 0.1217 0.454 P 0.2 0.23 0 17.5 5 1 -2.38 0.24 -0.002107 0.08 0.67 0.5 -2.158 -0.066 0.058 -7.28 0.00034 300 -1.599 1.47 0.015 
 +2 Hetre 128,​0,​0 Algan8 -1.5 0.4 0.6025 0.1844 3.0115 0.1432 0.0996 0.1939 0.6583 -1.086 0.1489 0.725 E 0.2 0.23 0 17.5 51 1 -1.9 0.213 -0.002985 0.08 1.49 7.39 -2.158 -0.066 0.058 -7.28 0.00034 300 -3.057 0.941 0.231 
 +3 Erable 136,​66,​29 Algan8 -2.19 0.4 0.6025 0.1844 2.8 0.1432 0.0996 0.1939 0.6583 -1.086 0.1489 0.725 E 0.2 0.23 0 17.5 51 1 -1.9 0.213 -0.002985 0.08 1.49 7.39 -2.158 -0.066 0.058 -7.28 0.00034 300 -3.057 0.941 0.231 
 +4 Frene 240,​195,​0 Algan8 -2.19 0.4 0.6025 0.1844 2.8 0.1432 0.0996 0.1939 0.6583 -1.086 0.1489 0.725 E 0.2 0.23 0 17.5 51 1 -1.9 0.213 -0.002985 0.08 1.49 7.39 -2.158 -0.066 0.058 -7.28 0.00034 300 -3.057 0.941 0.231 
 +5 Sorbier 223,​109,​20 Algan8 -2.19 0.4 0.6025 0.1844 2.5 0.1432 0.0996 0.1939 0.6583 -1.086 0.1489 0.725 E 0.2 0.23 0 17.5 51 1 -1.9 0.213 -0.002985 0.08 1.49 7.39 -2.158 -0.066 0.058 -7.28 0.00034 300 -3.057 0.941 0.231 
 +6 Saule 187,​174,​152 Algan8 -2.19 0.4 0.6025 0.1844 2.5 0.1432 0.0996 0.1939 0.6583 -1.086 0.1489 0.725 E 0.2 0.23 0 17.5 51 1 -1.9 0.213 -0.002985 0.08 1.49 7.39 -2.158 -0.066 0.058 -7.28 0.00034 300 -3.057 0.941 0.231 
 +7 Other 187,​174,​152 Algan8 -2.19 0.4 0.6025 0.1844 2.5 0.1432 0.0996 0.1939 0.6583 -1.086 0.1489 0.725 E 0.2 0.23 0 17.5 51 1 -1.9 0.213 -0.002985 0.08 1.49 7.39 -2.158 -0.066 0.058 -7.28 0.00034 300 -3.057 0.941 0.231 
 +  
 +  
 +# Dead wood  
 +#​  
 +# Log volumes (m3/ha) per Holeksa'​s dbh and decay classes  
 +# D / décomp fresh I.1 I.2 II III IV V VI VII VIII  
 +< 23 cm 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2  
 +23-35 cm 0.6 0.6 0.6 0.6 0.6 0.6 0.6 0.6 0.6 0.6  
 +> 35 cm 0.5 0.5 0.5 0.5 0.5 0.5 0.5 0.5 0.5 0.5  
 +  
 +  
 +  
 +# Dendro micro habitats  
 +# Catalogue  
 +TREM (Breed.Woodpecker,​Rot.Hole,​Dendrotelm,​Root.Concav,​Bark.Loss,​Exposed.HeartWood,​Crack,​Crown.DeadWood,​Burr.Canker,​Polypore,​Sap.Run)  
 +#  
 +# Parameters  
 +# TREM Sp K lambda  
 +Breed.Woodpecker 0 2 800  
 +Rot.Hole 0 2 500  
 +Dendrotelm 0 2 700  
 +Root.Concav 0 2 200  
 +Bark.Loss 0 2 400  
 +Exposed.HeartWood 0 2 700  
 +Crack 0 2 700  
 +Crown.DeadWood 0 2 500  
 +Burr.Canker 0 2 500  
 +Polypore 0 2 800  
 +Sap.Run 0 2 500  
 +Breed.Woodpecker 1 2 800  
 +Rot.Hole 1 2 500  
 +Dendrotelm 1 2 700  
 +Root.Concav 1 2 200  
 +Bark.Loss 1 2 400  
 +Exposed.HeartWood 1 2 700  
 +Crack 1 2 700  
 +Crown.DeadWood 1 2 500  
 +Burr.Canker 1 2 500  
 +Polypore 1 2 800  
 +Sap.Run 1 2 500  
 +Breed.Woodpecker 2 2 800  
 +Rot.Hole 2 2 500  
 +Dendrotelm 2 2 700  
 +Root.Concav 2 2 200  
 +Bark.Loss 2 2 400  
 +Exposed.HeartWood 2 2 700  
 +Crack 2 2 700  
 +Crown.DeadWood 2 2 500  
 +Burr.Canker 2 2 500  
 +Polypore 2 2 800  
 +Sap.Run 2 2 500  
 +Breed.Woodpecker 3 2 800  
 +Rot.Hole 3 2 500  
 +Dendrotelm 3 2 700  
 +Root.Concav 3 2 200  
 +Bark.Loss 3 2 400  
 +Exposed.HeartWood 3 2 700  
 +Crack 3 2 700  
 +Crown.DeadWood 3 2 500  
 +Burr.Canker 3 2 500  
 +Polypore 3 2 800  
 +Sap.Run 3 2 500  
 +Breed.Woodpecker 4 2 800  
 +Rot.Hole 4 2 500  
 +Dendrotelm 4 2 700  
 +Root.Concav 4 2 200  
 +Bark.Loss 4 2 400  
 +Exposed.HeartWood 4 2 700  
 +Crack 4 2 700  
 +Crown.DeadWood 4 2 500  
 +Burr.Canker 4 2 500  
 +Polypore 4 2 800  
 +Sap.Run 4 2 500  
 +Breed.Woodpecker 5 2 800  
 +Rot.Hole 5 2 500  
 +Dendrotelm 5 2 700  
 +Root.Concav 5 2 200  
 +Bark.Loss 5 2 400  
 +Exposed.HeartWood 5 2 700  
 +Crack 5 2 700  
 +Crown.DeadWood 5 2 500  
 +Burr.Canker 5 2 500  
 +Polypore 5 2 800  
 +Sap.Run 5 2 500  
 +Breed.Woodpecker 6 2 800  
 +Rot.Hole 6 2 500  
 +Dendrotelm 6 2 700  
 +Root.Concav 6 2 200  
 +Bark.Loss 6 2 400  
 +Exposed.HeartWood 6 2 700  
 +Crack 6 2 700  
 +Crown.DeadWood 6 2 500  
 +Burr.Canker 6 2 500  
 +Polypore 6 2 800  
 +Sap.Run 6 2 500  
 +Breed.Woodpecker 7 2 800  
 +Rot.Hole 7 2 500  
 +Dendrotelm 7 2 700  
 +Root.Concav 7 2 200  
 +Bark.Loss 7 2 400  
 +Exposed.HeartWood 7 2 700  
 +Crack 7 2 700  
 +Crown.DeadWood 7 2 500  
 +Burr.Canker 7 2 500  
 +Polypore 7 2 800  
 +Sap.Run 7 2 500  
 +  
 +  
 +# Tree records  
 +#  
 +# Id  speciesId X Y Z Dbh H CBH CR Age  REM LifeStage  
 +#     (m) (m) (m) (cm)  (m) (m) (m) (yr)  (vector) ​ (char)  
 +1 2 0.69 76.56 44.3 4 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +10 2 25 76 44.1 100 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +100 2 32.27 64.09 37.85 68 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +101 2 40.43 61.55 36.62 54 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +102 2 43.37 60.33 37 27 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +103 2 46.84 59.46 37.73 54 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +104 1 47.61 57.06 35.57 69 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +105 2 55.37 59.82 37.13 35 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +106 2 55.49 59.54 37.11 46 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +107 1 69.09 59.3 38.43 72 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +108 1 80.15 59.18 39.46 92 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +109 0 79.96 62.72 41.65 33 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +11 3 37.6 78.3 45.99 44 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +110 2 84.06 64.13 42.66 68 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +111 1 84.93 63.14 42.18 10 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +112 1 88 60.85 41.52 71 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +113 2 85.05 59.53 40.15 31 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +114 2 87.54 56.93 39.77 68 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +115 2 88.11 57.12 39.71 1 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +116 2 88.31 57.47 39.52 100 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +117 1 91.14 58.36 40.46 70 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +118 1 95.2 59.98 41.92 38 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +119 2 97.49 59.12 42.14 60 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +12 3 37.44 77.93 45.56 7 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +120 2 102.45 59.98 43.58 69 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +121 1 102.04 59.16 42.87 1 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +122 1 101.82 61.63 44.04 4 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +123 2 103.19 63.87 45.59 53 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +124 2 109.72 59.79 45.13 63 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +125 2 117.55 55.68 44.36 27 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +126 2 117.21 55.65 44.22 20 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +127 2 116.4 55.45 43.19 12 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +128 7 119.82 58.83 45.61 4 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +129 0 119.87 54.89 43.54 40 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +13 3 37.41 76.92 44.99 24 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +130 1 124.64 55.33 45 12 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +131 0 123.54 51.53 42.93 56 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +132 1 118.03 53.08 42.38 100 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +133 1 124.14 48.45 41.04 55 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +134 2 117.83 47.61 38.6 100 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +135 1 113.09 46.56 37.58 96 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +136 2 106.96 52.09 39.74 54 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +137 1 106.39 53.59 40.36 35 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +138 2 99.33 51.93 38.33 69 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +139 1 99.12 51.84 38.16 101 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +14 1 45.09 76.91 45.84 72 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +140 1 98.25 47.53 35.12 83 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +141 2 93.77 48.52 35.39 101 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +142 2 85.96 55.82 39.02 1 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +143 1 86.09 54.09 37.93 61 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +144 1 84.06 48.31 34.21 44 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +145 2 80.04 50.55 34.85 56 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +146 2 79.64 50.4 34.37 4 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +147 2 75.15 55.09 36.73 54 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +148 2 73.9 49.73 33.48 59 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +149 2 73.56 49.19 33.14 100 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +15 1 53.49 73.75 45.18 59 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +150 2 73.95 49.53 33.34 100 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +151 1 66.4 50.1 33.22 70 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +152 1 63.25 54.58 35.56 63 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +153 1 60.86 53.01 34.04 63 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +154 1 62.73 46.48 30.84 9 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +155 1 60.54 48.65 31.63 7 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +156 1 61.39 46.84 30.71 1 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +157 1 55.29 54.09 33.84 1 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +158 2 55.91 48.54 31.33 68 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +159 2 51.23 52.71 32.95 1 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +16 2 57.29 72.93 45.11 21 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +160 1 50.36 53.07 32.92 100 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +161 2 50.28 49.53 31.07 100 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +162 2 50.33 49.2 30.78 100 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +163 2 41.77 53.58 32.75 27 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +164 2 41.61 56.97 34.08 24 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +165 2 40.48 55.71 33.63 44 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +166 2 38.97 51.09 31.03 15 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +167 2 38.69 50.77 30.7 53 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +168 2 39.37 50.82 30.71 100 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +169 2 38.63 50.54 30.06 15 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +17 2 61.82 74.1 46.17 43 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +170 2 41.08 48.24 29.6 31 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +171 1 30.86 57.33 33.75 27 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +172 1 27.42 55.64 32.62 100 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +173 1 29.06 56.38 33.73 100 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +174 2 31.25 49.79 29.01 100 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +175 2 25.9 55.66 33.18 27 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +176 3 29.15 45.87 27.03 15 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +177 1 25.62 48.81 29.26 87 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +178 1 19.97 48.42 29.41 69 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +179 1 18.66 47.1 28.78 40 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +18 1 60.99 75.68 47.11 76 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +180 1 17.22 46.91 28.75 70 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +181 1 17.16 46.51 28.32 12 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +182 2 11.09 50.34 30.41 13 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +183 1 11.55 43.53 26.64 21 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +184 3 11.84 42.67 26.18 13 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +185 7 8.26 50.09 30.62 4 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +186 2 1.54 42.63 26.16 68 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +187 1 22.59 36.52 23.03 84 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +188 1 21.46 35.42 22.71 40 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +189 2 22.21 34.72 21.39 27 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +19 1 65.28 76.05 47.67 33 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +190 1 23.51 33.79 21.55 21 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +191 1 23.4 32.89 19.82 80 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +192 2 42.52 32.27 20.66 15 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +193 1 41.94 33.58 21.39 61 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +194 2 42.27 34.55 22.1 31 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +195 2 54.17 38.79 26.54 55 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +196 1 56.63 38.88 26.82 83 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +197 1 64.29 34.22 24.07 93 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +198 1 65.4 32.73 23.5 101 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +199 2 74.1 30.43 22.45 53 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +2 1 3.26 76.68 44.59 75 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +20 1 65.68 73.06 45.96 72 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +200 1 75.97 30.51 22.58 100 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +201 1 77.44 30.13 22.68 4 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +202 1 78.85 32.82 25.02 12 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +203 1 81 34.11 25.84 90 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +204 1 92.11 28.15 23.21 68 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +205 2 94.2 30.41 24.8 49 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +206 2 98.05 35.06 28.1 46 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +207 1 101.28 36.93 30.3 79 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +208 2 99.33 34.01 27.52 12 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +209 2 100.41 33.42 27.4 24 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +21 1 71.21 75.36 48.41 56 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +210 1 100.81 32.29 26.76 49 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +211 2 106.35 34.72 29.36 35 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +212 1 106.46 35.85 30.6 73 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +213 2 106.91 32.26 27.75 43 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +214 2 111.03 35.33 31.28 75 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +215 2 100.15 29.61 25.07 9 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +216 2 100.35 28.7 24.8 65 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +217 1 102.41 28.71 24.89 16 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +218 1 107.85 25.68 24.16 76 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +219 2 119.7 32.81 32.07 63 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +221 1 123.63 18.96 23.03 27 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +222 1 101.77 19.95 19.89 72 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +223 1 106.77 15.05 17.72 21 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +224 2 104.87 14.4 16.98 61 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +225 2 99.2 16.14 17.5 75 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +226 2 94.79 23.64 20.91 44 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +227 1 95.2 24.41 21.44 76 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +228 1 96.28 24.54 21.43 27 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +229 1 86.41 26.22 21.31 70 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +23 1 79.87 76.99 50.29 56 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +230 1 93.5 17.64 17.21 27 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +231 1 88.65 21.2 18.48 61 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +232 7 87.21 21.28 18.66 9 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +233 1 84.05 21.53 18.19 20 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +234 2 94.76 14.12 15.19 101 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +235 2 89.37 15.36 15.07 15 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +236 1 88 13.52 14.05 65 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +237 2 84 13.88 13.94 49 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +238 2 83.68 16.34 15.53 55 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +239 2 79.4 25.48 20.69 79 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +24 7 84.71 77.62 51.52 16 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +240 1 77.55 18.52 16.02 100 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +241 1 76.07 19.64 16.38 5 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +242 1 69.31 27.65 21.24 27 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +243 2 64.97 29.34 21.22 33 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +244 1 67.15 22.09 17.29 60 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +245 2 67.24 20.41 16.31 68 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +246 1 61.89 24.78 18.42 49 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +247 1 57.65 25.67 17.84 21 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +248 1 58.53 22.17 16.59 56 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +249 1 57.2 20.02 15.04 21 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +25 2 89.5 78.33 52.31 43 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +250 2 45.36 30.22 19.54 62 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +251 2 45.21 30.7 19.81 21 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +252 1 46.24 24.86 16.61 59 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +253 1 41.36 22.98 14.93 35 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +254 1 44.48 21.22 14.9 60 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +255 7 44.35 20.54 14.27 21 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +256 1 34.39 24.84 14.71 71 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +257 1 38.4 19.44 12.58 70 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +258 2 33.68 28.51 16.93 62 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +259 1 32.15 20.56 13.65 68 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +26 1 88.86 76.55 51.02 9 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +260 1 30.24 29.54 17.72 60 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +261 1 27.98 28.51 16.95 44 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +262 2 27.74 25.45 15.42 49 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +263 2 25.28 28.28 17.01 21 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +264 2 26.69 21.74 13.69 54 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +265 1 24.11 20.07 12.69 5 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +266 1 24.17 21.44 13.39 69 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +267 1 21.5 23.8 14.83 12 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +268 1 22.49 25.59 16.15 72 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +269 1 20.59 28.9 17.54 34 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +27 2 90.94 77.27 51.7 12 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +270 2 20 30.21 17.88 49 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +271 1 19.7 30.61 18.06 100 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +272 1 18.97 27.61 16.75 12 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +273 2 18.43 24.99 16.23 38 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +274 1 17.34 30.27 18.67 35 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +275 2 16.63 32.75 19.5 12 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +276 1 19.42 21.11 13.68 65 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +277 1 18.48 19.74 13.17 102 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +278 2 17.07 21.59 12.19 31 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +279 2 9.47 22.41 16.28 56 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +28 1 91.35 75.37 50.54 24 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +280 1 11.05 24.4 16.2 12 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +281 2 8.53 28.35 17.93 67 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +282 1 12.46 19.58 12.56 10 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +283 7 6.24 23.05 14.24 100 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +284 1 6.2 23.61 14.74 44 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +285 2 5.07 26.37 16.44 43 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +286 1 5.46 28.32 17.36 24 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +287 1 3.44 22.94 14.45 72 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +288 1 2.4 21.39 12.95 95 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +289 1 4.41 18.2 9.23 88 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +29 2 92.79 74.13 50.22 60 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +290 1 10.61 17.99 12.15 75 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +291 2 4.78 15.21 9.96 31 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +292 2 3.24 14.87 9.65 101 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +293 1 14.71 12.24 8.81 98 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +294 1 21.6 16.33 10.36 87 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +295 1 23.63 16.73 11.41 15 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +296 1 22.82 12.56 8.94 22 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +297 1 24.15 11.91 8.28 37 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +298 1 27.85 16.67 12.52 55 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +299 2 28.55 11.36 7.28 8 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +3 2 8.76 79.13 45.76 101 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +30 7 90.59 73.69 49.12 7 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +300 2 33.14 20.52 12.64 15 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +301 1 37.63 17.72 11.46 69 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +302 2 37.97 10.82 8.11 28 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +303 1 42.65 16.01 11.44 78 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +304 1 41.75 6.23 6.26 32 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +305 2 44.68 7.78 6.97 52 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +306 1 49.92 16.23 12.97 65 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +307 7 51.88 11.59 9.47 14 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +308 1 54.5 13.83 11.3 80 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +309 1 67.49 15.54 13.81 21 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +31 2 100.82 72.78 51.19 65 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +310 1 69.04 14.45 12.98 69 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +311 7 66.1 10.17 10.13 25 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +312 7 66.27 9.74 9.99 19 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +313 1 72.4 16.96 14.74 3 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +314 1 76.15 14.82 13.94 70 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +315 2 85.62 7.92 10.5 29 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +316 1 84.52 5.71 9.23 93 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +317 2 93.19 7.61 11.21 18 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +318 2 94.19 8.02 11.93 45 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +319 1 96.01 9.17 12.66 17 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +32 1 101.21 75.65 53.1 86 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +320 1 91.11 2.06 7.62 77 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +321 2 97.68 5.49 10.4 11 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +322 1 104.35 10.63 13.87 82 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +323 2 106.77 3.08 10.46 36 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +324 2 111.75 6.21 13.26 20 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +325 1 118.53 10.35 16.86 77 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +326 1 118.12 4.14 13.09 91 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +327 1 119.24 3.53 12.74 26 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +328 1 120.38 2.23 12.21 53 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +329 2 104.62 0.78 9.46 57 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +33 1 106.11 77.22 54.6 7 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +330 1 101.57 4.24 9.92 6 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +331 2 100.68 2.04 8.86 48 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +332 2 97.37 2.85 8.72 50 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +333 1 83.58 2.62 7.36 2 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +334 2 74.93 5.96 9.12 66 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +335 1 68.37 5.3 7.73 39 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +336 2 67.62 3.87 6.85 47 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +337 1 68.74 0.63 5.42 99 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +338 2 63 0.17 4.76 41 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +339 1 57.17 8.83 8.33 64 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +340 1 57.43 3.48 5.5 51 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +341 2 50.14 6.2 6.05 58 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +342 1 49.96 2.05 4.49 85 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +343 1 48.24 0.43 3.59 42 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +344 1 43.54 2.37 4.29 97 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +345 1 40.97 3.01 4.11 23 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +346 2 40.84 0.85 3.24 30 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +347 2 37.49 3.68 4.45 74 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +348 2 33.1 0.57 2.6 43 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +349 1 27.86 4.01 4.55 68 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +35 1 119.82 76.47 56.75 10 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +350 1 24.67 5.16 5.26 44 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +352 1 23.28 3.06 4.32 40 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +354 1 20.21 5.28 5.75 94 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +356 1 11.19 5.55 5.13 79 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +357 2 2.18 2.53 2.28 43 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +358 2 2.1 1.97 1.96 55 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +36 1 120.38 75.52 56.41 100 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +37 1 121.74 76.24 57.07 100 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +38 1 122.14 75.46 56.79 101 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +39 1 123.81 75.14 56.91 100 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +4 2 8.74 74.19 42.77 1 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +40 1 121.88 73.75 55.71 5 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +41 1 123.01 72.52 55.31 7 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +42 1 120.49 71.89 54.01 5 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +43 1 119.47 72.9 54.44 5 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +44 1 119.05 73.4 54.58 33 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +45 1 117.92 71.96 53.47 7 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +46 1 123.92 65.83 51.16 9 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +47 1 120.92 65.51 49.9 24 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +48 1 121.26 63.16 48.52 40 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +49 1 118.28 61.98 47.33 72 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +5 1 11.66 72.76 42.13 88 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +50 2 117.51 65.2 48.96 40 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +51 0 111.73 64.79 48 12 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +52 1 112.11 68.69 50.43 90 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +53 1 107.88 74.1 52.21 100 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +539 1 121.74 74.17 56.06 9 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +54 1 101.64 69.22 48.93 89 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +55 1 86.11 68.53 45.45 10 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +56 2 85.33 69.77 46.09 100 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +57 1 76.96 70.21 45.43 4 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +58 2 76.67 71.45 46.69 55 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +59 0 77.49 66.58 43.38 49 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +6 1 12.75 68.77 39.91 73 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +60 2 70.41 64.48 41.61 55 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +61 1 63.27 64.81 41.04 21 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +62 1 61.55 67.55 42.4 60 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +63 0 51.58 69.68 42.92 33 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +64 0 45.8 69.01 41.71 33 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +65 2 44.43 70.33 41.99 35 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +66 2 44.49 70.63 42.14 56 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +67 2 44.23 67.47 40.7 35 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +68 1 44.51 66.35 40.04 43 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +69 1 48.79 64.5 40.03 88 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +7 1 14.48 68.85 39.81 10 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +70 2 41.26 64.75 38.88 35 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +71 2 31.41 70.01 41.02 44 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +72 2 31.1 68.56 40.2 4 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +73 1 30.05 68.75 40.3 4 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +74 2 29.6 68.01 40.19 73 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +75 1 24.74 63.52 37.4 7 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +76 2 24.37 63.74 37.67 43 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +77 1 21.92 66.25 38.29 72 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +78 1 20.41 66.02 38.21 20 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +79 1 19.13 63.69 36.87 72 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +8 2 14.86 69.31 40.18 55 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +80 2 14.8 64.65 37.5 53 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +81 2 15.01 61.06 35.21 59 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +82 2 11.8 62.29 35.97 40 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +83 1 4.45 64.13 37.34 81 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +84 1 0.76 68.19 39.97 75 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +87 2 4.83 56.26 32.24 62 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +88 1 10.22 57.55 33.3 73 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +89 2 10.53 52.23 31.95 62 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +9 2 20.45 69.4 40.16 53 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +90 2 11.16 52.27 31.36 101 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +91 2 15.24 56.72 34.23 24 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +92 2 20.28 56.85 33.01 20 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +93 1 24.06 60.41 35.29 81 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +94 0 27.06 62.05 36.24 20 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +95 1 29.71 61 36.17 68 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +96 2 30.94 60.92 35.89 12 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +97 0 31.53 61.23 36.03 15 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +98 2 32.3 62.21 36.75 12 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 +99 2 32.37 62.69 37.01 43 NA NA NA NA (0,​0,​0,​0,​0,​0,​0,​0,​0,​0,​0) alive  
 + 
 +</​code>​ 
 + 
 + 
 + 
  
-The expected result may look like this extract : 
  
-1{(0,​65);​(1,​65);​(2,​65)} 
documentation/exceladdsdoublequotesduringcsvexport.1571992198.txt · Last modified: 2019/10/25 08:29 by coligny