{"text_format":"1","workbook":"xlsx","n_sheets":20,"sheets":["Accueil","Avant de commencer une pêche","Retrouver les caractéristiques","Aide d'achat d'un matériel","Portatif DC","Portatif PDC","NON Portatif 1 Anode","NON Portatif 2 Anodes","Portatif DC (2)","Portatif PDC (2)","NON Portatif 1 Anode (2)","NON Portatif 2 Anodes (2)","Guide avant de pêcher","Guide retrouver les caractérist","Guide achat","Fiches techniques engin des pêc","Achat portatif DC","Achat portatif PDC","Achat non portatif DC 1 anode","Achat non portatif DC 2anodes"],"not_rendered":{"charts":0,"images":41,"macros":1,"external_links":0,"defined_names":0,"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":"Accueil","index":0,"n_rows":14,"n_cols":2,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,1,0,2],[1,1,1,2],[10,1,10,2],[2,1,2,2],[4,1,4,2],[6,1,6,2],[8,1,8,2]]}
[null,"CARPE©"]
[null,"(Conseils et Accompagnement pour les Réglages de Pêches Electriques)"]
[null,"Accueil"]
[]
[null,"AVANT DE COMMENCER UNE PECHE"]
[]
[null,"RETROUVER LES CARACTERISTIQUES D'UNE PECHE PRECEDENTE"]
[]
[null,"FICHES TECHNIQUES DES APPAREILS DE PECHE ELECTRIQUE"]
[]
[null,"AIDE AU CHOIX D'UN MATERIEL AVANT L'ACHAT"]
[]
[]
[null,"cliquer sur l'onglet de votre choix"]

{"sheet":"Avant de commencer une pêche","index":1,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,0,0,2],[11,1,11,2],[8,1,8,2]]}
["AVANT DE COMMENCER UNE PECHE"]
[]
["Type d'engin","Courant utilisé","Sélectionner "]
["Portatif avec 1 anode","Continu","Cliquer ici"]
["Portatif avec 1 anode","Continu Pulsé ","Cliquer ici"]
["Non Portatif avec  1 anode","Continu","Cliquer ici"]
["Non Portatif avec 2 anodes","Continu","Cliquer ici"]
[]
[null,"GUIDE DE PECHE"]
[]
[]
[null,"Retour à l'Accueil"]

{"sheet":"Retrouver les caractéristiques","index":2,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,0,0,2],[12,1,12,2],[9,0,9,1]]}
["RETROUVER LES CARACTERISTIQUES D'UNE PECHE PRECEDENTE"]
[]
["Type d'engin","Courant utilisé","Sélectionner "]
["Portatif avec 1 anode","Continu","Cliquer ici"]
["Portatif avec 1 anode","Continu Pulsé","Cliquer ici"]
["Non Portatif avec  1 anode","Continu","Cliquer ici"]
["Non Portatif avec 2 anodes","Continu","Cliquer ici"]
[]
[]
["GUIDE POUR RETROUVER LES CARACTERISTIQUES"]
[]
[]
[null,"Retour à l'Accueil"]

{"sheet":"Aide d'achat d'un matériel","index":3,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,0,0,2],[12,1,12,2],[9,0,9,1]]}
["AIDE AU CHOIX D'UN MATERIEL AVANT L'ACHAT"]
[]
["Type d'engin","Courant utilisé","Sélectionner "]
["Portatif avec 1 anode","Continu","Cliquer ici"]
["Portatif avec 1 anode","Continu Pulsé","Cliquer ici"]
["Non Portatif avec  1 anode","Continu","Cliquer ici"]
["Non Portatif avec 2 anodes","Continu","Cliquer ici"]
[]
[]
["GUIDE D'AIDE AU CHOIX D'UN MATERIEL"]
[]
[]
[null,"Retour à l'Accueil"]

{"sheet":"Portatif DC","index":4,"n_rows":109,"n_cols":19,"rows_kept":109,"cut":false,"hidden":false,"merged":[[36,9,36,17],[61,0,61,5],[62,0,62,5],[34,18,35,18],[4,17,5,17],[4,7,5,7],[4,8,5,8],[4,16,5,16],[6,0,6,8],[34,16,35,16],[34,17,35,17],[7,1,7,2],[20,1,20,2],[6,9,6,18],[108,1,108,2],[84,0,84,5],[38,1,38,2],[51,1,51,2],[106,1,106,2],[102,1,104,2],[86,2,86,4]]}
[]
["Paramètres du modèle :"]
["Parameters","Values","Standard deviation","Student t value","Pr > t"]
["Constant",-34.452219999999997,3.5405470000000001,-9.7307600000000001,"<0,001"]
["D(0.1 V.cm-1)",1.60701,4.0932000000000003E-2,39.260089999999998,"<0,001"]
["Duty cycle (%)",0.26811000000000001,3.4722999999999997E-2,7.7214900000000002,"<0,001"]
[]
[null,"AVANT DE COMMENCER UNE PECHE"]
[null,"Rayon d'ATTRACTION (cm)",100]
[null,"Conductivité spécifique pour 25°C (µS/cm)",500]
[null,"Température (°C)",13.1]
[null,"Conductivité Ambiante (µS/cm²)",{"$f":"$C$10/(1.023^(25-$C$11))","v":381.46084208798891}]
[null,"Modèle Anode","Anode INOX 40 cm"]
[null,"Modèle Cathode","Cathode  Cuivre ELT60 II Hans Grassl"]
["Résistance anode (Ohm) à 350µS/cm",{"$f":"IF(C13=A87,B87, IF(C13=A88,B88, IF(C13=A89,B89, IF(C13=A90,B90, IF(C13=A91,B91, IF(C13=A92,B92, IF(C13=A93,B93,IF(C13=A94,B94,IF(C13=A95,B95,\"X\")))))))))","v":30.325632777771425}]
["Résistance cathode (Ohm) à 350µS/cm",{"$f":"IF(C14=B65,F65,IF(C14=B66,F66,IF(C14=B67,F67,IF(C14=B68,F68,IF(C14=B69,F69,IF(C14=B70,F70,IF(C14=B71,F71,IF(C14=B72,F72,\"X\"))))))))","v":19.490708303307116}]
["Résistance ambiante Anode (Ohm)",{"$f":"(B15*350)/C12","v":27.82453741286438}]
["Résistance ambiante Cathode (Ohm)",{"$f":"(B16*350)/C12","v":17.883219333385643}]
["Résistance équivalente Totale (Ohm)",{"$f":"B17+B18","v":45.707756746250027}]
["Tension appliquée à l'Anode (V)",{"$f":"(B5-1.96*C5)*C9+(B6-1.96*C6)*100+(B4-C4*1.96)","v":131.29192788000003},{"$f":"B5*C9+B6*100+B4","v":153.05977999999999},{"$f":"(B5+1.96*C5)*C9+(B6+1.96*C6)*100+(B4+1.96*C4)","v":174.82763211999998}]
[null,"REGLAGES DE LA TENSION / INFORMATIONS SUPPLEMENTAIRES"]
[null,"MINIMALE","MOYENNE","MAXIMALE"]
["Tension à REGLER sur l'Appareil (V)",{"$f":"B20*(B19/B17)","v":215.67508610262527},{"$f":"C20*(B19/B17)","v":251.43344121293492},{"$f":"D20*(B19/B17)","v":287.1917963232446}]
["Rayon de TETANIE moyen (cm)",{"$f":"K35+K36*B20","v":12.593818866666801},{"$f":"K35+K36*C20","v":13.575766675799999},{"$f":"K35+K36*D20","v":14.557714484933198}]
["Puissance de sortie requise (W)",{"$f":"(B23^2)/$B$19","v":1017.6772188495355},{"$f":"(C23^2)/$B$19","v":1383.1082481501353},{"$f":"(D23^2)/$B$19","v":1804.4886414632194}]
["Charge électrique de la batterie (Ah)",7]
["Tension fournie par la batterie (V)",24]
["Temps de décharge pour 25% profondeur de décharge de la batterie (minutes) à ne pas dépasser",{"$f":"((B26*B27)/B25)*0.25*60","v":2.4762271900404844},{"$f":"((B26*B27)/C25)*0.25*60","v":1.8219832058484378},{"$f":"((B26*B27)/D25)*0.25*60","v":1.3965175186453866}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Paramètres du modèle :"]
[null,null,null,null,null,null,null,null,null,"R²aj. (coefficient de détermination ajusté)",0.17]
[null,null,null,null,null,null,null,null,null,"Paramètre","Valeur","Ecart-type","t de Student","Pr > t","Borne inférieure 95 %","Borne supérieure 95 %"]
[null,null,null,null,null,null,null,null,null,"Constant",6.6712400000000001,1.0230300000000001,6.5209999999999999,"<0,001",{"$f":"6.67124-1.96*1.02303","v":4.6661011999999999},{"$f":"6.67124+1.96*1.02303","v":8.6763788000000002},0.17,null,54]
[null,null,null,null,null,null,null,null,null,"Va",4.5109999999999997E-2,1.3259999999999999E-2,3.4020000000000001,1.2899999999999999E-3,{"$f":"0.04511-1.96*0.01326","v":1.9120399999999999E-2},{"$f":"0.04511+1.96*0.01326","v":7.1099599999999999E-2}]
[null,null,null,null,null,null,null,null,null,"L'équation du modèle s'écrit : D(1V/cm) = 6,671 + 0,045*Va"]
[]
[null,"RETROUVER LES CARACTERISTIQUES D'UNE PECHE PRECEDENTE"]
[null,"Tension réglée sur l'appareil (V)",120]
[null,"Tension appliquée à l'Anode (V)",{"$f":"C40*(B49/B51)","v":64.125613201857846}]
[null,"Conductivité spécifique pour 25°C (µS/cm)",213]
[null,"Température (°C)",13]
[null,"Conductivité Ambiante (µS/cm²)",{"$f":"$C$42/(1.023^(25-$C$43))","v":162.13321661224387}]
[null,"Modèle Anode","Anode  LR-24 (Smith Root) 28 cm aluminium"]
[null,"Modèle Cathode","Cathode INOX LR-24 Smith Root"]
["Résistance anode (Ohm) à 350µS/cm",{"$f":"IF(C45=A87,B87, IF(C45=A88,B88, IF(C45=A89,B89, IF(C45=A90,B90, IF(C45=A91,B91, IF(C45=A92,B92, IF(C45=A93,B93,IF(C45=A94,B94,IF(C45=A95,B95,\"X\")))))))))","v":37.093261309907561}]
["Résistance cathode (Ohm) à 350µS/cm",{"$f":"IF(C46=B65,F65,IF(C46=B66,F66,IF(C46=B67,F67,IF(C46=B68,F68,IF(C46=B69,F69,IF(C46=B70,F70,IF(C46=B71,F71,IF(C46=B72,F72,\"X\"))))))))","v":32.320365085792105}]
["Résistance ambiante Anode (Ohm)",{"$f":"(B47*350)/C44","v":80.073915325548597}]
["Résistance ambiante Cathode (Ohm)",{"$f":"(B48*350)/C44","v":69.770575187447278}]
["Résistance équivalente Totale (Ohm)",{"$f":"B49+B50","v":149.84449051299589}]
[null,"INFORMATIONS SUR LE CHAMP ELECTRIQUE / PUISSANCE REQUISE"]
[null,"MINIMALE","MOYENNE","MAXIMALE"]
["Rayon d'ATTRACTION (cm)",{"$f":"O5+O6*C41","v":0},{"$f":"K5+K6*C41","v":0},{"$f":"P5+P6*C41","v":0}]
["Rayon de TETANIE (cm)",{"$f":"O35+O36*C41","v":5.892208574664803},{"$f":"K35+K36*C41","v":9.5639464115358077},{"$f":"P35+P36*C41","v":13.235684248406812}]
["Puissance Requise (VA)",{"$f":"($C$40^2)/B51","v":96.099629360420835}]
["Charge électrique de la batterie (Ah)",7]
["Tension fournie par la batterie (V)",24]
["Temps de décharge pour 25% profondeur de décharge de la batterie (minutes) à ne pas dépasser",{"$f":"((B57*B58)/B56)*0.25*60","v":26.222785839774279}]
[]
[]
["Tableaux des résistances des cathodes et des anodes"]
["Taille des Cathodes et la Résistance Equivalente mesurée à une conductivité ambiante de 350 µS.cm-1"]
["Référence Cathode","Type de Cathode","Dimension 1 cm)","Dimension 2 (cm)","Epaisseur du cordon/ Taille de la Maille (mm)","Résistance mesurée en Ω"]
["P","Cathode Héron Dream Electronique","4 tresses de 850 *10 sur une tige de métal",null,null,6.7269212884583069]
["R","Cathode Martin Pêcheur Dream Electronique",null,null,3,33.038083021941517]
["S","Cathode  Cuivre ELT60 II Hans Grassl",210,15,3,19.490708303307116]
["T","Cathode INOX LR-24 Smith Root",110,null,5,32.320365085792105]
["A","Bande de Cuivre 75*2,5 cm",75,2.5,3,48]
["B","Bande de Cuivre 150*2,5 cm",150,2.5,3,31]
["C","Bande de Cuivre 300*2,5 cm",300,2.5,3,20]
["H","Cathode cuivre EL63II 5 mètres",500,2.5,null,15.557027781685669]
["D","Maille d'Acier",25,25,13,49]
["E","Maille d'Acier",50,50,13,27]
["F","Maille d'Acier",75,75,13,19]
["G","Maille d'Aluminium expansé",60,55,25.4,26]
["H","Maille d'Aluminium perforé",29,39,null,35]
["I","Maille d'Aluminium perforé",16,17,null,60]
["J","Plaque d'Aluminium épaisse de 2 mm",30,41,null,34]
["K","Tôle perforée en Acier Inoxydable",50,50,6,21]
["L","Treillis d'Acier soudé",29,40,25.4,34]
["M","Treillis d'Acier soudé",17,17,25.4,64]
["N","Cable inox",110,null,5,40]
["O","8 tresses de cuivre de 90*1 soudées sur une barre en cuivre",null,null,3,20]
["Résistances équivalentes Anodes pour une conductivité ambiante de 350 µS.cm-1"]
["Type d'anode","Résistance mesurée en Ω"]
["Anode Martin Pêcheur (Dream Electronique) 35 cm aluminium",30.996190228711924,"Si l'anode n'est pas dans la liste ci-contre :"]
["Anode  LR-24 (Smith Root) 28 cm aluminium",37.093261309907561]
["Anode ELT60II (Hans Grassl) 40 cm inox",27.562744722895957,"Diamètre anode Da  (mm) ="]
["Anode EL63II (Hans Grassl) 30 cm inox",31.019777707914521]
["Anode INOX 20 cm",41.424312990970819,"Résistance anode Ra (Ohm) à 350µS/cm"]
["Anode INOX 30 cm",37.6437665278483,null,"(Beaumont et al., 2005)"]
["Anode INOX 40 cm",30.325632777771425]
["Anode INOX 50 cm",25.347999778481856]
["Anode canne anglaise 36 cm de long inox",30.558181906149095]
[]
[]
[]
[]
[]
[]
[]
[null,"Portatif Courant Continu 1 Anode"]
[]
[]
[]
[null,"Retour à la page précédente"]
[]
[null,"Retour à l'Accueil"]

{"sheet":"Portatif PDC","index":5,"n_rows":89,"n_cols":12,"rows_kept":89,"cut":false,"hidden":false,"merged":[[36,9,37,9],[3,7,4,7],[3,8,4,8],[3,9,4,9],[88,1,88,2],[8,1,8,2],[22,1,22,2],[82,1,84,2],[0,1,1,1],[86,1,86,2],[44,0,44,5],[66,0,66,5],[68,2,68,4],[43,0,43,5]]}
["Paramètres du modèle :"]
["R²aj. (coefficient de détermination ajusté)"]
["Variable modélisée","Valeur","Erreur-standard","t de Student","Pr > t","Borne de prédiction inférieure   95 %","Borne de prédiction supérieure 95 %","R² ajusté","AIC"]
["Constant",-34.452219999999997,3.5405470000000001,-9.7307600000000001,"<0,001"]
["D(0.1 V.cm-1)",1.60701,4.0932000000000003E-2,39.260089999999998,"<0,001"]
["Duty cycle (%)",0.26811000000000001,3.4722999999999997E-2,7.7214900000000002,"<0,001"]
[]
[]
[null,"AVANT DE COMMENCER UNE PECHE"]
[null,"Rayon d'ATTRACTION (cm)",80]
[null,"Conductivité spécifique pour 25°C (µS/cm)",200]
[null,"Température (°C)",12]
[null,"Conductivité Ambiante (µS/cm²)",{"$f":"$C$11/(1.023^(25-$C$12))","v":148.81501669327889}]
[null,"Modèle Anode","Anode INOX 30 cm"]
[null,"Modèle Cathode","Cathode Martin Pêcheur Dream Electronique"]
[null,"Résistance anode (Ohm) à 350µS/cm",{"$f":"IF(C14=A69,B69, IF(C14=A70,B70, IF(C14=A71,B71, IF(C14=A72,B72, IF(C14=A73,B73, IF(C14=A74,B74, IF(C14=A75,B75,IF(C14=A76,B76,IF(C14=A77,B77,\"X\")))))))))","v":37.6437665278483}]
[null,"Résistance cathode (Ohm) à 350µS/cm",{"$f":"IF(C15=B47,F47,IF(C15=B48,F48,IF(C15=B49,F49,IF(C15=B50,F50,IF(C15=B51,F51,IF(C15=B52,F52,IF(C15=B53,F53,IF(C15=B54,F54,\"X\"))))))))","v":33.038083021941517}]
[null,"Rapport cyclique (%)",25]
[null,"Résistance ambiante Anode (Ohm)",{"$f":"(C16*350)/C13","v":88.534870858513017}]
[null,"Résistance ambiante Cathode (Ohm)",{"$f":"(C17*350)/C13","v":77.702703091534048}]
[null,"Résistance équivalente Totale (Ohm)",{"$f":"C19+C20","v":166.23757395004708}]
["Tension appliquée à l'Anode (V)",{"$f":"(B4-1.96*C4)+(B5-1.96*C5)*C10+(B6-1.96*C6)*C18","v":85.752293280000018},{"$f":"B4+B5*C10+B6*C18","v":100.81133},{"$f":"(B4+1.96*C4)+(B5+1.96*C5)*C10+(B6+1.96*C6)*C18","v":115.87036672000001}]
[null,"REGLAGES DE LA TENSION / INFORMATIONS SUPPLEMENTAIRES"]
[null,"MINIMALE","MOYENNE","MAXIMALE"]
["Tension à REGLER sur l'Appareil (V)",{"$f":"B22*($C$21/$C$19)","v":161.01286484397039},{"$f":"C22*($C$21/$C$19)","v":189.28847767406197},{"$f":"D22*($C$21/$C$19)","v":217.56409050415357}]
["Rayon de TETANIE moyen (cm)",{"$f":"C22*B38+B37+B39*C18-1.159","v":21.353202711590004},{"$f":"C22*B38+B37+B39*C18","v":22.512202711590003},{"$f":"D22*B38+B37+B39*C18+1.159","v":26.151772417218563}]
["Puissance de sortie requise (W)",{"$f":"(B25^2/C21)*(C18/100)","v":38.988091003200267},{"$f":"(C25^2/C21)*(C18/100)","v":53.883918852982198},{"$f":"(D25^2/C21)*(C18/100)","v":71.184468637522059}]
["Charge électrique de la batterie (Ah)",7]
["Tension fournie par la batterie (V)",24]
["Temps de décharge pour 25% profondeur de décharge de la batterie (minutes) à ne pas dépasser",{"$f":"((B28*B29)/B27)*0.25*60","v":64.635121524497066},{"$f":"((B28*B29)/C27)*0.25*60","v":46.767199818476655},{"$f":"((B28*B29)/D27)*0.25*60","v":35.400980694708487}]
[]
[]
[]
["Paramètres du modèle :"]
["R²aj. (coefficient de détermination ajusté)",0.69601983644310028]
["Variable modélisée","Valeur","Erreur-standard","t de Student","Pr > t","Borne de prédiction inférieure   95 %","Borne de prédiction supérieure 95 %","R² ajusté","AIC","Individus statistiques","AIC","Individus statistiques"]
["Constant",6.753558,0.80761760000000005,"8.362321","<0,001",null,null,null,null,221,null,221]
["Va",0.16472300000000001,7.0644999999999996E-3,"23.317094","<0,001"]
["Duty cycle (%)",-3.3891999999999999E-2,1.7311799999999999E-2,"-1.957744","0.0515"]
[]
[]
[]
[]
["Tableaux des résistances des cathodes et des anodes"]
["Taille des Cathodes et la Résistance Equivalente mesurée à une conductivité ambiante de 350 µS.cm-1"]
["Référence Cathode","Type de Cathode","Dimension 1 cm)","Dimension 2 (cm)","Epaisseur du cordon/ Taille de la Maille (mm)","Résistance mesurée en Ω"]
["P","Cathode Héron Dream Electronique","4 tresses de 850 *10 sur une tige de métal",null,null,6.7269212884583069]
["R","Cathode Martin Pêcheur Dream Electronique",null,null,3,33.038083021941517]
["S","Cathode  Cuivre ELT60 II Hans Grassl",210,15,3,19.490708303307116]
["T","Cathode INOX LR-24 Smith Root",110,null,5,32.320365085792105]
["A","Bande de Cuivre 75*2,5 cm",75,2.5,3,48]
["B","Bande de Cuivre 150*2,5 cm",150,2.5,3,31]
["C","Bande de Cuivre 300*2,5 cm",300,2.5,3,20]
["H","Cathode cuivre EL63II 5 mètres",500,2.5,null,15.557027781685669]
["D","Maille d'Acier",25,25,13,49]
["E","Maille d'Acier",50,50,13,27]
["F","Maille d'Acier",75,75,13,19]
["G","Maille d'Aluminium expansé",60,55,25.4,26]
["H","Maille d'Aluminium perforé",29,39,null,35]
["I","Maille d'Aluminium perforé",16,17,null,60]
["J","Plaque d'Aluminium épaisse de 2 mm",30,41,null,34]
["K","Tôle perforée en Acier Inoxydable",50,50,6,21]
["L","Treillis d'Acier soudé",29,40,25.4,34]
["M","Treillis d'Acier soudé",17,17,25.4,64]
["N","Cable inox",110,null,5,40]
["O","8 tresses de cuivre de 90*1 soudées sur une barre en cuivre",null,null,3,20]
["Résistances équivalentes Anodes pour une conductivité ambiante de 350 µS.cm-1"]
["Type d'anode","Résistance mesurée en Ω"]
["Anode Martin Pêcheur (Dream Electronique) 35 cm aluminium",30.996190228711924,"Si l'anode n'est pas dans la liste ci-contre :"]
["Anode  LR-24 (Smith Root) 28 cm aluminium",37.093261309907561]
["Anode ELT60II (Hans Grassl) 40 cm inox",27.562744722895957,"Diamètre anode Da  (mm) ="]
["Anode EL63II (Hans Grassl) 30 cm inox",31.019777707914521]
["Anode INOX 20 cm",41.424312990970819,"Résistance anode Ra (Ohm) à 350µS/cm"]
["Anode INOX 30 cm",37.6437665278483,null,"(Beaumont et al., 2005)"]
["Anode INOX 40 cm",30.325632777771425]
["Anode INOX 50 cm",25.347999778481856]
["Anode canne anglaise 36 cm de long inox",30.558181906149095]
[]
[]
[]
[]
[]
[null,"Portatif Courant Continu Pulsé 1 Anode"]
[]
[]
[]
[null,"Retour à la page précédente"]
[]
[null,"Retour à l'Accueil"]

{"sheet":"NON Portatif 1 Anode","index":6,"n_rows":111,"n_cols":10,"rows_kept":111,"cut":false,"hidden":false,"merged":[[110,1,110,2],[104,1,106,2],[87,0,87,5],[89,2,89,4],[65,0,65,5],[108,1,108,2],[3,7,4,7],[3,8,4,8],[5,0,5,9],[40,8,41,8],[64,0,64,5],[6,1,6,2],[43,1,43,2],[19,1,19,2],[56,1,56,2],[42,0,42,9],[31,7,32,7],[40,7,41,7],[31,8,32,8],[33,0,33,9],[3,9,4,9],[31,9,32,9]]}
["Paramètres du modèle :"]
["R²aj. (coefficient de détermination ajusté)"]
["Paramètre","Valeur","Erreur standard","t de Student","Pr > t","Borne inférieure 95 %","Borne supérieure 95 %"]
["Constant",null,null,null,null,null,null,0.87,null,168]
["D(0.1 V.cm-1)",1.3,1.2E-2,33.409999999999997,1E-3]
["Model equation: Va = -22.62 + 1.87 * D(0.1 V.cm-1)"]
[null,"AVANT DE COMMENCER UNE PECHE"]
[null,"Rayon d'ATTRACTION (cm)",200]
[null,"Conductivité spécifique pour 25°C (µS/cm)",200]
[null,"Température (°C)",16]
[null,"Conductivité Ambiante (µS/cm²)",{"$f":"C9/(1.023^(25-C10))","v":162.98562126582047},{"$f":"C9/(1.023^(25-C10))","v":162.98562126582047}]
[null,"Modèle Anode","Anode INOX 30 cm"]
[null,"Modèle Cathode","Cathode Héron Dream Electronique"]
["Résistance anode (Ohm) à 350µS/cm",{"$f":"IF(C12=A90,B90,IF(C12=A91,B91,IF(C12=A92,B92,IF(C12=A93,B93,IF(C12=A94,B94,IF(C12=A95,B95,IF(C12=A96,B96,IF(C12=A97,B97,IF(C12=A98,B98,\"X\")))))))))","v":37.6437665278483},{"$f":"B14","v":37.6437665278483},{"$f":"C14","v":37.6437665278483}]
["Résistance cathode (Ohm) à 350µS/cm",{"$f":"IF(C13=B68,F68,IF(C13=B69,F69,IF(C13=B70,F70,IF(C13=B71,F71,IF(C13=B72,F72,IF(C13=B73,F73,IF(C13=B74,F74,IF(C13=B75,F75,\"X\"))))))))","v":6.7269212884583069},{"$f":"B15","v":6.7269212884583069},{"$f":"C15","v":6.7269212884583069}]
["Résistance ambiante Anode (Ohm)",{"$f":"B14*350/C11","v":80.837304434718789},{"$f":"C14*350/C11","v":80.837304434718789},{"$f":"D14*350/D11","v":80.837304434718789}]
["Résistance ambiante Cathode (Ohm)",{"$f":"B15*350/C11","v":14.445583804723949},{"$f":"C15*350/C11","v":14.445583804723949},{"$f":"D15*350/D11","v":14.445583804723949}]
["Résistance équivalente Totale (Ohm)",{"$f":"B17+B16","v":95.282888239442741},{"$f":"C17+C16","v":95.282888239442741},{"$f":"D17+D16","v":95.282888239442741}]
["Tension appliquée à l'anode (V)",{"$f":"(B5-1.96*C5)*C8","v":255.29600000000002},{"$f":"B4+B5*C8","v":260},{"$f":"(B5+1.96*C5)*C8","v":264.70400000000001}]
[null,"REGLAGES DE LA TENSION / INFORMATIONS SUPPLEMENTAIRES"]
[null,"MINIMALE","MOYENNE","MAXIMALE"]
["Tension à REGLER sur l'Appareil (V)",{"$f":"B19*(B18/B16)","v":300.91726098587344},{"$f":"C19*(C18/C16)","v":306.46186331288811},{"$f":"D19*(D18/D16)","v":312.00646563990284}]
["Rayon de TETANIE moyen (cm)",{"$f":"B32+B33*B19","v":30.942135008000001},{"$f":"B32+B33*C19","v":31.440631999999997},{"$f":"B32+B33*D19","v":31.939128992000001}]
["Puissance de sortie requise (W)",{"$f":"(((B22^2)/B18))","v":950.3406081865204},{"$f":"(((C22^2)/C18))","v":985.68457989216586},{"$f":"(((D22^2)/D18))","v":1021.6738430144088}]
[]
[]
[]
[]
["Paramètres du modèle :"]
["R²aj. (coefficient de détermination ajusté)"]
["Paramètre","Valeur","Erreur standard","t de Student","Pr > t","Borne inférieure 95 %","Borne supérieure 95 %"]
["Constant",3.8876520000000001,1.1620564,3.345494,1E-3,3.1325414,4.6427630999999998,0.59689519999999996,1197.8489999999999,189]
["Va",0.105973,6.3401000000000004E-3,16.714662000000001,"<0,001",0.1027421,0.1092042]
["Model equation: D(1 V.cm-1) = 3.89 + 0.11 * Va"]
[]
[]
[]
["Paramètres du modèle :"]
["R²aj. (coefficient de détermination ajusté)",0.81]
["Paramètre","Valeur","Erreur standard","t de Student","Pr > t","Borne inférieure 95 %","Borne supérieure 95 %"]
["Constante",10.154102,5.1059749999999999,1.9886710000000001," < 0,05",-33.78,54.09,0.80958759999999996,186]
["Va",0.69307099999999999,2.4695999999999999E-2,28.063772,"< 0,0001",0.6925,0.69359999999999999]
["L'équation du modèle s'écrit : D(0,1 V/cm) =  10,15 + 0,69 * Va"]
[null,"RETROUVER LES CARACTERISTIQUES D'UNE PECHE PRECEDENTE"]
[null,"Tension réglée sur l'appareil (V)",200]
[null,"Tension appliquée à l'Anode (V)",{"$f":"C45*(B54/B56)","v":133.16454394963188}]
[null,"Conductivité spécifique pour 25°C (µS/cm)",244]
[null,"Température (°C)",13]
[null,"Conductivité Ambiante (µS/cm²)",{"$f":"$C$47/(1.023^(25-$C$48))","v":185.73006973421363}]
[null,"Modèle Anode","Anode Martin Pêcheur (Dream Electronique) 35 cm aluminium"]
[null,"Modèle Cathode","Cathode cuivre EL63II 5 mètres Hans Grassl"]
["Résistance anode (Ohm) à 350µS/cm",{"$f":"IF(C50=A90,B90,IF(C50=A91,B91,IF(C50=A92,B92,IF(C50=A93,B93,IF(C50=A94,B94,IF(C50=A95,B95,IF(C50=A96,B96,IF(C50=A97,B97,IF(C50=A98,B98,\"X\")))))))))","v":30.996190228711924}]
["Résistance cathode (Ohm) à 350µS/cm",{"$f":"IF(C51=B68,F68,IF(C51=B69,F69,IF(C51=B70,F70,IF(C51=B71,F71,IF(C51=B72,F72,IF(C51=B73,F73,IF(C51=B74,F74,IF(C51=B75,F75,\"X\"))))))))","v":15.557027781685669}]
["Résistance ambiante Anode (Ohm)",{"$f":"(B52*350)/C49","v":58.41093257313694},{"$f":"B54","v":58.41093257313694},{"$f":"C54","v":58.41093257313694}]
["Résistance ambiante Cathode (Ohm)",{"$f":"(B53*350)/C49","v":29.316522259329982},{"$f":"B55","v":29.316522259329982},{"$f":"C55","v":29.316522259329982}]
["Résistance équivalente Totale (Ohm)",{"$f":"B54+B55","v":87.727454832466918},{"$f":"C54+C55","v":87.727454832466918},{"$f":"D54+D55","v":87.727454832466918}]
[null,"INFORMATIONS SUR LE CHAMP ELECTRIQUE / PUISSANCE REQUISE"]
[null,"MINIMALE","MOYENNE","MAXIMALE"]
["Rayon d'ATTRACTION (cm)",{"$f":"F42*C46+F41","v":58.436446685120075},{"$f":"B42*C46+B41","v":102.44658563971531},{"$f":"G42*C46+G41","v":146.45292768346468}]
["Rayon de TETANIE (cm)",{"$f":"F33*C46+F32","v":16.814146290927475},{"$f":"B33*C46+B32","v":17.999498215974338},{"$f":"G33*C46+G32","v":19.184890590384391}]
["Puissance Requise (VA)",{"$f":"(((C45^2)/B56))*(1/0.6)","v":759.92933790202812}]
[]
[]
[]
["Tableaux des résistances des cathodes et des anodes"]
["Taille des Cathodes et la Résistance Equivalente mesurée à une conductivité ambiante de 350 µS.cm-1"]
["Référence Cathode","Type de Cathode","Dimension 1 cm)","Dimension 2 (cm)","Epaisseur du cordon/ Taille de la Maille (mm)","Résistance mesurée en Ω"]
["A","Cathode Héron Dream Electronique","4 tresses de 850 *10 sur une tige de métal",null,null,6.7269212884583069]
["B","Cathode Martin Pêcheur Dream Electronique",null,null,3,33.038083021941517]
["C","Cathode  Cuivre ELT60 II Hans Grassl",210,15,3,19.490708303307116]
["D","Cathode INOX LR-24 Smith Root",110,null,5,32.320365085792105]
["E","Bande de Cuivre 75*2,5 cm",75,2.5,3,48]
["F","Bande de Cuivre 150*2,5 cm",150,2.5,3,31]
["G","Bande de Cuivre 300*2,5 cm",300,2.5,3,20]
["H","Cathode cuivre EL63II 5 mètres Hans Grassl",500,2.5,null,15.557027781685669]
["I","Maille d'Acier",25,25,13,49]
["J","Maille d'Acier",50,50,13,27]
["K","Maille d'Acier",75,75,13,19]
["L","Maille d'Aluminium expansé",60,55,25.4,26]
["M","Maille d'Aluminium perforé",29,39,null,35]
["N","Maille d'Aluminium perforé",16,17,null,60]
["O","Plaque d'Aluminium épaisse de 2 mm",30,41,null,34]
["P","Tôle perforée en Acier Inoxydable",50,50,6,21]
["Q","Treillis d'Acier soudé",29,40,25.4,34]
["R","Treillis d'Acier soudé",17,17,25.4,64]
["S","Cable inox",110,null,5,40]
["T","8 tresses de cuivre de 90*1 soudées sur une barre en cuivre",null,null,3,20]
["Résistances équivalentes Anodes pour une conductivité ambiante de 350 µS.cm-1"]
["Type d'anode","Résistance mesurée en Ω"]
["Anode Martin Pêcheur (Dream Electronique) 35 cm aluminium",30.996190228711924,"Si l'anode n'est pas dans la liste ci-contre :"]
["Anode  LR-24 (Smith Root) 28 cm aluminium",37.093261309907561]
["Anode ELT60II (Hans Grassl) 40 cm inox",27.562744722895957,"Diamètre anode Da  (mm) ="]
["Anode EL63II (Hans Grassl) 30 cm inox",31.019777707914521]
["Anode INOX 20 cm",41.424312990970819,"Résistance anode Ra (Ohm) à 350µS/cm"]
["Anode INOX 30 cm",37.6437665278483,null,"(Beaumont et al., 2005)"]
["Anode INOX 40 cm",30.325632777771425]
["Anode INOX 50 cm",25.347999778481856]
["Anode canne anglaise 36 cm de long inox",30.558181906149095]
[]
[]
[]
[]
[]
[]
[null,"NON Portatif Courant Continu 1 Anode"]
[]
[]
[]
[null,"Retour à la page précédente"]
[]
[null,"Retour à l'Accueil"]

{"sheet":"NON Portatif 2 Anodes","index":7,"n_rows":122,"n_cols":10,"rows_kept":122,"cut":false,"hidden":false,"merged":[[6,1,6,2],[20,1,20,2],[5,0,5,9],[34,0,34,9],[61,2,61,3],[40,7,41,7],[40,8,41,8],[3,9,4,9],[32,9,33,9],[3,7,4,7],[3,8,4,8],[32,7,33,7],[32,8,33,8],[43,1,43,2],[57,1,57,2],[42,0,42,9],[119,1,119,2],[121,1,121,2],[115,1,117,2]]}
["Paramètres du modèle :"]
["R²aj. (coefficient de détermination ajusté)",0.81]
["Paramètre","Valeur","Erreur standard","t de Student","Pr > t","Borne inférieure 95 %","Borne supérieure 95 %"]
["Constant",null,null,null,null,null,null,0.78322380000000003,null,168]
["D(0.1 V.cm-1)",1.3,1.2E-2,33.409999999999997,1E-3]
["Model equation: Va = -22.62 + 1.87 * D(0.1 V.cm-1)"]
[null,"AVANT DE COMMENCER UNE PECHE"]
[null,"Rayon d'ATTRACTION (cm)",100]
[null,"Conductivité spécifique pour 25°C (µS/cm)",231]
[null,"Température (°C)",13.1]
[null,"Conductivité Ambiante (µS/cm²)",{"$f":"C9/(1.023^(25-C10))","v":176.23490904465089},{"$f":"C9/(1.023^(25-C10))","v":176.23490904465089}]
[null,"Modèle Anode","Anode INOX 20 cm"]
[null,"Modèle Cathode","Cathode Héron Dream Electronique"]
["Résistance anode (Ohm) à 350µS/cm",{"$f":"IF(C12=A104,B104,IF(C12=A105,B105,IF(C12=A108,B108,IF(C12=A109,B109,IF(C12=A110,B110,IF(C12=A111,B111,IF(C12=A106,B106,IF(C12=A107,B107,IF(C12=A112,B112,\"X\")))))))))","v":41.424312990970819},{"$f":"B14","v":41.424312990970819},{"$f":"C14","v":41.424312990970819}]
["Résistance cathode (Ohm) à 350µS/cm",{"$f":"IF(C13=B82,F82,IF(C13=B83,F83,IF(C13=B84,F84,IF(C13=B85,F85,IF(C13=B86,F86,IF(C13=B87,F87,IF(C13=B88,F88,IF(C13=B89,F89,\"X\"))))))))","v":6.7269212884583069},{"$f":"B15","v":6.7269212884583069},{"$f":"C15","v":6.7269212884583069}]
["Résistance ambiante Anode (Ohm)",{"$f":"B14*350/C11","v":82.268091069099384}]
["Résistance ambiante équivalente  2 Anodes arrangées (Ohm)",{"$f":"B16/2","v":41.134045534549692}]
["Résistance ambiante Cathode (Ohm)",{"$f":"B15*350/C11","v":13.359569132605225},{"$f":"B15*350/C11","v":13.359569132605225},{"$f":"B15*350/D11","v":13.359569132605225}]
["Résistance équivalente Totale (Ohm)",{"$f":"B18+(B17)","v":54.493614667154915},{"$f":"B19","v":54.493614667154915},{"$f":"B19","v":54.493614667154915}]
["Tension appliquée à l'anode (V)",{"$f":"(B5-1.96*C5)*C8","v":127.64800000000001},{"$f":"B5*C8","v":130},{"$f":"(B5+1.96*C5)*C8","v":132.352}]
[null,"REGLAGES DE LA TENSION / INFORMATIONS SUPPLEMENTAIRES"]
[null,"MINIMALE","MOYENNE","MAXIMALE"]
["Tension à REGLER sur l'Appareil (V)",{"$f":"B20*(B19/B17)","v":169.10568446739435},{"$f":"C20*(C19/B17)","v":172.22157010498609},{"$f":"D20*(D19/B17)","v":175.33745574257784}]
["Rayon de TETANIE moyen (cm)",{"$f":"B34*B20+ B33","v":17.414893504000002},{"$f":"B33+B34*C20","v":17.664141999999998},{"$f":"B34*D20+B33","v":17.913390496000002}]
["Puissance de sortie requise (W)",{"$f":"((($B$23^2)/(B17+B18)))","v":524.77217181964863},{"$f":"((($C$23^2)/(B17+C18)))","v":544.28889312244235},{"$f":"((($D$23^2)/(B17+D18)))","v":564.16194033115573}]
[]
[]
[]
[]
["Paramètres du modèle :"]
["R²aj. (coefficient de détermination ajusté)",0.57999999999999996]
["Paramètre","Valeur","Erreur standard","t de Student","Pr > t","Borne inférieure 95 %","Borne supérieure 95 %"]
["Constant",3.8876520000000001,1.1620564,3.345494,1E-3,3.1325414,4.6427630999999998,0.59689519999999996,1197.8489999999999,189]
["Va",0.105973,6.3401000000000004E-3,16.714662000000001,"<0,001",0.1027421,0.1092042]
["Model equation: D(1 V.cm-1) = 3.89 + 0.11 * Va"]
[]
[]
["Paramètres du modèle :"]
["R²aj. (coefficient de détermination ajusté)",0.81]
["Paramètre","Valeur","Erreur standard","t de Student","Pr > t","Borne inférieure 95 %","Borne supérieure 95 %"]
["Constante",10.154102,5.1059749999999999,1.9886710000000001," < 0,05",-33.78,54.09,0.80958759999999996,186]
["Va",0.69307099999999999,2.4695999999999999E-2,28.063772,"< 0,0001",0.6925,0.69359999999999999]
["L'équation du modèle s'écrit : D(0,1 V/cm) =  10,15 + 0,69 * Va"]
[null,"RETROUVER LES CARACTERISTIQUES D'UNE PECHE PRECEDENTE"]
[null,"Tension réglée sur l'appareil (V)",198.7]
[null,"Tension appliquée à l'Anode (V)",{"$f":"C45*(B55/B57)","v":129.80434047053953}]
[null,"Conductivité spécifique pour 25°C (µS/cm)",231]
[null,"Température (°C)",13.1]
[null,"Conductivité Ambiante (µS/cm²)",{"$f":"$C$47/(1.023^(25-$C$48))","v":176.23490904465089}]
[null,"Modèle Anode","Anode INOX 50 cm"]
[null,"Modèle Cathode","Cathode Héron Dream Electronique"]
["Résistance anode (Ohm) à 350µS/cm",{"$f":"IF(C50=A104,B104,IF(C50=A105,B105,IF(C50=A108,B108,IF(C50=A109,B109,IF(C50=A110,B110,IF(C50=A111,B111,IF(C50=A106,B106,IF(C12=A107,B107,IF(C12=A112,B112,\"X\")))))))))","v":25.347999778481856}]
["Résistance cathode (Ohm) à 350µS/cm",{"$f":"IF(C51=B82,F82,IF(C51=B83,F83,IF(C51=B84,F84,IF(C51=B85,F85,IF(C51=B86,F86,IF(C51=B87,F87,IF(C51=B88,F88,IF(C51=B89,F89,\"X\"))))))))","v":6.7269212884583069},{"$f":"B53","v":6.7269212884583069},{"$f":"C53","v":6.7269212884583069}]
["Résistance ambiante Anode (Ohm)",{"$f":"(B52*350)/C49","v":50.340763759925053},{"$f":"B54","v":50.340763759925053},{"$f":"C54","v":50.340763759925053}]
["Résistance ambiante équivalente  2 Anodes arrangées (Ohm)",{"$f":"B54/2","v":25.170381879962527}]
["Résistance ambiante Cathode (Ohm)",{"$f":"(B53*350)/C49","v":13.359569132605225},{"$f":"B56","v":13.359569132605225},{"$f":"C56","v":13.359569132605225}]
["Résistance équivalente Totale (Ohm)",{"$f":"B56+(B55)","v":38.52995101256775},{"$f":"C56+(B55)","v":38.52995101256775},{"$f":"D56+(B55)","v":38.52995101256775}]
[null,"INFORMATIONS SUR LE CHAMP ELECTRIQUE / PUISSANCE REQUISE"]
[null,"MINIMALE","MOYENNE","MAXIMALE"]
["Rayon d'ATTRACTION (cm)",{"$f":"F42*C46+F41","v":56.109505775848618},{"$f":"B41+B42*C46","v":100.11772605425729},{"$f":"G42*C46+G41","v":144.12229055036622}]
["Rayon de TETANIE (cm)",{"$f":"F34*C46+F33","v":16.468911929058219},{"$f":"B34*C46+B33","v":17.643407372684486},{"$f":"G34*C46+G33","v":18.817942257612891}]
["Puissance Requise (VA)",{"$f":"((($C$45^2)/B57))*(1/0.6)","v":1707.8354614362995}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Tableaux des résistances des cathodes et des anodes"]
["Taille des Cathodes et la Résistance Equivalente mesurée à une conductivité ambiante de 350 µS.cm-1"]
["Référence Cathode","Type de Cathode","Dimension 1 cm)","Dimension 2 (cm)","Epaisseur du cordon/ Taille de la Maille (mm)","Résistance mesurée en Ω"]
["A","Cathode Héron Dream Electronique","4 tresses de 850 *10 sur une tige de métal",null,null,6.7269212884583069]
["B","Cathode Martin Pêcheur Dream Electronique",null,null,3,33.038083021941517]
["C","Cathode  Cuivre ELT60 II Hans Grassl",210,15,3,19.490708303307116]
["D","Cathode INOX LR-24 Smith Root",110,null,5,32.320365085792105]
["E","Bande de Cuivre 75*2,5 cm",75,2.5,3,48]
["F","Bande de Cuivre 150*2,5 cm",150,2.5,3,31]
["G","Bande de Cuivre 300*2,5 cm",300,2.5,3,20]
["H","Cathode cuivre EL63II 5 mètres Hans Grassl",500,2.5,null,15.557027781685669]
["I","Maille d'Acier",25,25,13,49]
["J","Maille d'Acier",50,50,13,27]
["K","Maille d'Acier",75,75,13,19]
["L","Maille d'Aluminium expansé",60,55,25.4,26]
["M","Maille d'Aluminium perforé",29,39,null,35]
["N","Maille d'Aluminium perforé",16,17,null,60]
["O","Plaque d'Aluminium épaisse de 2 mm",30,41,null,34]
["P","Tôle perforée en Acier Inoxydable",50,50,6,21]
["Q","Treillis d'Acier soudé",29,40,25.4,34]
["R","Treillis d'Acier soudé",17,17,25.4,64]
["S","Cable inox",110,null,5,40]
["T","8 tresses de cuivre de 90*1 soudées sur une barre en cuivre",null,null,3,20]
["Résistances équivalentes Anodes pour une conductivité ambiante de 350 µS.cm-1"]
["Type d'anode","Résistance mesurée en Ω"]
["Anode Martin Pêcheur (Dream Electronique) 35 cm aluminium",30.996190228711924,"Si l'anode n'est pas dans la liste ci-contre :"]
["Anode  LR-24 (Smith Root) 28 cm aluminium",37.093261309907561]
["Anode ELT60II (Hans Grassl) 40 cm inox",27.562744722895957,"Diamètre anode Da  (mm) ="]
["Anode EL63II (Hans Grassl) 30 cm inox",31.019777707914521]
["Anode INOX 20 cm",41.424312990970819,"Résistance anode Ra (Ohm) à 350µS/cm"]
["Anode INOX 30 cm",37.6437665278483,null,"(Beaumont et al., 2005)"]
["Anode INOX 40 cm",30.325632777771425]
["Anode INOX 50 cm",25.347999778481856]
["Anode canne anglaise 36 cm de long inox",30.558181906149095]
[]
[]
[]
[null,"NON Portatif Courant Continu 2 Anodes"]
[]
[]
[]
[null,"Retour à la page précédente"]
[]
[null,"Retour à l'Accueil"]

{"sheet":"Portatif DC (2)","index":8,"n_rows":107,"n_cols":19,"rows_kept":107,"cut":false,"hidden":false,"merged":[[61,0,61,5],[62,0,62,5],[84,0,84,5],[86,2,86,4],[106,1,106,2],[100,1,102,2],[104,1,104,2],[3,17,5,17],[3,18,5,18],[6,9,6,18],[38,1,38,2],[51,1,51,2],[36,9,36,17],[3,7,4,7],[3,8,4,8],[5,0,5,8],[6,1,6,2],[19,1,19,2],[34,16,35,16],[34,17,35,17],[34,18,35,18],[3,14,5,15],[3,16,5,16]]}
["Paramètres du modèle :",null,null,null,null,null,null,null,null,"Paramètres du modèle :"]
["R²aj, (coefficient de détermination ajusté)",0.84,null,null,null,null,null,null,null,"R²aj, (coefficient de détermination ajusté)",0.84]
["Paramètre","Valeur","Ecart-type","t de Student","Pr > t","Borne inférieure 95 %","Borne supérieure 95 %",null,null,"Paramètre","Valeur","Ecart-type","t de Student","Pr > t","Borne inférieure 95 %","Borne supérieure 95 %"]
["Constante",-17.637048,7.6848720000000004,-2.2950349999999999,"< 0,05",-56.147053,20.872958000000001,0.83545689999999995,41,"Constant",27.812944999999999,1.4362849,19.3645,"<0,001",3.0939999999999999,null,0.87804499999999996,1975.175,262]
["D(0,1 V/cm)",1.8462430000000001,0.12923200000000001,14.286265,"< 0,0001",1.834257,1.8582289999999999,null,null,"Va",0.55915400000000004,1.3940299999999999E-2,40.110579999999999,"<0,001"]
["L'équation du modèle s'écrit : Va =  5,66 + 1,45 * D(0,1 V/cm)",null,null,null,null,null,null,null,null,"Duty cycle (%)",-0.17693600000000001,1.8357700000000001E-2,-9.6382499999999993,"<0,001"]
[null,"AVANT DE COMMENCER UNE PECHE",null,null,null,null,null,null,null,"Model equation:  D(0,1 V,cm-1) =  24,81 + 0,56*Va - 0,18*Duty cycle +/- 37,75"]
[null,"Rayon d'ATTRACTION (cm)",46]
[null,"Conductivité spécifique pour 25°C (µS/cm)",213]
[null,"Température (°C)",13.1]
[null,"Conductivité Ambiante (µS/cm²)",{"$f":"$C$9/(1.023^(25-$C$10))","v":162.50231872948328}]
[null,"Modèle Anode","Anode  LR-24 (Smith Root) 28 cm aluminium"]
[null,"Modèle Cathode","Cathode INOX LR-24 Smith Root"]
["Résistance anode (Ohm) à 350µS/cm",{"$f":"IF(C12=A87,B87, IF(C12=A88,B88, IF(C12=A89,B89, IF(C12=A90,B90, IF(C12=A91,B91, IF(C12=A92,B92, IF(C12=A93,B93,IF(C12=A94,B94,IF(C12=A95,B95,\"X\")))))))))","v":37.093261309907561}]
["Résistance cathode (Ohm) à 350µS/cm",{"$f":"IF(C13=B65,F65,IF(C13=B66,F66,IF(C13=B67,F67,IF(C13=B68,F68,IF(C13=B69,F69,IF(C13=B70,F70,IF(C13=B71,F71,IF(C13=B72,F72,\"X\"))))))))","v":32.320365085792105}]
["Résistance ambiante Anode (Ohm)",{"$f":"(B14*350)/C11","v":79.892038218111693}]
["Résistance ambiante Cathode (Ohm)",{"$f":"(B15*350)/C11","v":69.612100728596204}]
["Résistance équivalente Totale (Ohm)",{"$f":"B16+B17","v":149.50413894670788}]
["Tension appliquée à l'Anode (V)",{"$f":"F5*C8+F4","v":28.228769},{"$f":"B4+B5*C8","v":67.290130000000005},{"$f":"G5*C8+G4","v":106.35149199999999}]
[null,"REGLAGES DE LA TENSION / INFORMATIONS SUPPLEMENTAIRES"]
[null,"MINIMALE","MOYENNE","MAXIMALE"]
["Tension à REGLER sur l'Appareil (V)",{"$f":"B19*(B18/B16)","v":52.825261402753462},{"$f":"C19*(B18/B16)","v":125.92184615189076},{"$f":"D19*(B18/B16)","v":199.01843277235517}]
["Rayon de TETANIE moyen (cm)",{"$f":"K35+K36*B19","v":7.9446397695900002},{"$f":"K35+K36*C19","v":9.7066977642999994},{"$f":"K35+K36*D19","v":11.468755804120001}]
["Puissance Requise (VA) Thermique",{"$f":"(B22^2)/$B$18*(1/0.6)","v":31.108483706304355},{"$f":"(C22^2)/$B$18*(1/0.6)","v":176.7655781974992},{"$f":"(D22^2)/$B$18*(1/0.6)","v":441.55228591233418}]
["Puissance Requise (VA) Batterie",{"$f":"(B22^2)/$B$18","v":18.665090223782613},{"$f":"(C22^2)/$B$18","v":106.05934691849951},{"$f":"(D22^2)/$B$18","v":264.93137154740049}]
["Charge électrique de la batterie (Ah)",7]
["Tension fournie par la batterie (V)",24]
["Temps de décharge pour 25% profondeur de décharge de la batterie (minutes) à ne pas dépasser",{"$f":"((B26*B27)/B25)*0.25*60","v":135.01140202307064},{"$f":"((B26*B27)/C25)*0.25*60","v":23.760282079961087},{"$f":"((B26*B27)/D25)*0.25*60","v":9.511897308655012}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Paramètres du modèle :"]
[null,null,null,null,null,null,null,null,null,"R²aj, (coefficient de détermination ajusté)",0.17]
[null,null,null,null,null,null,null,null,null,"Paramètre","Valeur","Ecart-type","t de Student","Pr > t","Borne inférieure 95 %","Borne supérieure 95 %"]
[null,null,null,null,null,null,null,null,null,"Constant",6.6712400000000001,1.0230300000000001,6.5209999999999999,"<0,001",{"$f":"6.67124-1.96*1.02303","v":4.6661011999999999},{"$f":"6.67124+1.96*1.02303","v":8.6763788000000002},0.17,null,54]
[null,null,null,null,null,null,null,null,null,"Va",4.5109999999999997E-2,1.3259999999999999E-2,3.4020000000000001,1.2899999999999999E-3,{"$f":"0.04511-1.96*0.01326","v":1.9120399999999999E-2},{"$f":"0.04511+1.96*0.01326","v":7.1099599999999999E-2}]
[null,null,null,null,null,null,null,null,null,"L'équation du modèle s'écrit : D(1V/cm) = 6,671 + 0,045*Va"]
[]
[null,"RETROUVER LES CARACTERISTIQUES D'UNE PECHE PRECEDENTE"]
[null,"Tension réglée sur l'appareil (V)",200]
[null,"Tension appliquée à l'Anode (V)",{"$f":"C40*(B49/B51)","v":122.82510091478048}]
[null,"Conductivité spécifique pour 25°C (µS/cm)",213]
[null,"Température (°C)",13]
[null,"Conductivité Ambiante (µS/cm²)",{"$f":"$C$42/(1.023^(25-$C$43))","v":162.13321661224387}]
[null,"Modèle Anode","Anode EL63II (Hans Grassl) 30 cm inox"]
[null,"Modèle Cathode","Cathode  Cuivre ELT60 II Hans Grassl"]
["Résistance anode (Ohm) à 350µS/cm",{"$f":"IF(C45=A87,B87, IF(C45=A88,B88, IF(C45=A89,B89, IF(C45=A90,B90, IF(C45=A91,B91, IF(C45=A92,B92, IF(C45=A93,B93,IF(C45=A94,B94,IF(C45=A95,B95,\"X\")))))))))","v":31.019777707914521}]
["Résistance cathode (Ohm) à 350µS/cm",{"$f":"IF(C46=B65,F65,IF(C46=B66,F66,IF(C46=B67,F67,IF(C46=B68,F68,IF(C46=B69,F69,IF(C46=B70,F70,IF(C46=B71,F71,IF(C46=B72,F72,\"X\"))))))))","v":19.490708303307116}]
["Résistance ambiante Anode (Ohm)",{"$f":"(B47*350)/C44","v":66.962972946718168}]
["Résistance ambiante Cathode (Ohm)",{"$f":"(B48*350)/C44","v":42.074955698142425}]
["Résistance équivalente Totale (Ohm)",{"$f":"B49+B50","v":109.03792864486059}]
[null,"INFORMATIONS SUR LE CHAMP ELECTRIQUE / PUISSANCE REQUISE"]
[null,"MINIMALE","MOYENNE","MAXIMALE"]
["Rayon d'ATTRACTION (cm)",{"$f":"(K4-1.96*L4)+(K5-1.96*L5)*C41+(K6-1.96*L6)*100","v":69.028315114509823},{"$f":"K4+K5*C41+K6*100","v":78.797491476903161},{"$f":"(K4+1.96*L4)+(K5+1.96*L5)*C41+(K6+1.96*L6)*100","v":88.5666678392965}]
["Rayon de TETANIE (cm)",{"$f":"O35+O36*C41","v":7.0145662595309686},{"$f":"K35+K36*C41","v":12.211880302265747},{"$f":"P35+P36*C41","v":17.409194345000525}]
["Puissance de sortie requise (W)",{"$f":"($C$40^2)/B51","v":366.84482635653376}]
["Charge électrique de la batterie (Ah)",7]
["Tension fournie par la batterie (V)",24]
["Temps de décharge pour 25% profondeur de décharge de la batterie (minutes) à ne pas dépasser",{"$f":"((B57*B58)/B56)*0.25*60","v":6.8693895046262172}]
[]
[]
["Tableaux des résistances des cathodes et des anodes"]
["Taille des Cathodes et la Résistance Equivalente mesurée à une conductivité ambiante de 350 µS,cm-1"]
["Référence Cathode","Type de Cathode","Dimension 1 cm)","Dimension 2 (cm)","Epaisseur du cordon/ Taille de la Maille (mm)","Résistance mesurée en Ω"]
["P","Cathode Héron Dream Electronique","4 tresses de 850 *10 sur une tige de métal",null,null,6.7269212884583069]
["R","Cathode Martin Pêcheur Dream Electronique",null,null,3,33.038083021941517]
["S","Cathode  Cuivre ELT60 II Hans Grassl",210,15,3,19.490708303307116]
["T","Cathode INOX LR-24 Smith Root",110,null,5,32.320365085792105]
["A","Bande de Cuivre 75*2,5 cm",75,2.5,3,48]
["B","Bande de Cuivre 150*2,5 cm",150,2.5,3,31]
["C","Bande de Cuivre 300*2,5 cm",300,2.5,3,20]
["H","Cathode cuivre EL63II 5 mètres",500,2.5,null,15.557027781685669]
["D","Maille d'Acier",25,25,13,49]
["E","Maille d'Acier",50,50,13,27]
["F","Maille d'Acier",75,75,13,19]
["G","Maille d'Aluminium expansé",60,55,25.4,26]
["H","Maille d'Aluminium perforé",29,39,null,35]
["I","Maille d'Aluminium perforé",16,17,null,60]
["J","Plaque d'Aluminium épaisse de 2 mm",30,41,null,34]
["K","Tôle perforée en Acier Inoxydable",50,50,6,21]
["L","Treillis d'Acier soudé",29,40,25.4,34]
["M","Treillis d'Acier soudé",17,17,25.4,64]
["N","Cable inox",110,null,5,40]
["O","8 tresses de cuivre de 90*1 soudées sur une barre en cuivre",null,null,3,20]
["Résistances équivalentes Anodes pour une conductivité ambiante de 350 µS,cm-1"]
["Type d'anode","Résistance mesurée en Ω"]
["Anode Martin Pêcheur (Dream Electronique) 35 cm aluminium",30.996190228711924,"Si l'anode n'est pas dans la liste ci-contre :"]
["Anode  LR-24 (Smith Root) 28 cm aluminium",37.093261309907561]
["Anode ELT60II (Hans Grassl) 40 cm inox",27.562744722895957,"Diamètre anode Da  (mm) ="]
["Anode EL63II (Hans Grassl) 30 cm inox",31.019777707914521]
["Anode INOX 20 cm",41.424312990970819,"Résistance anode Ra (Ohm) à 350µS/cm"]
["Anode INOX 30 cm",37.6437665278483,null,"(Beaumont et al,, 2005)"]
["Anode INOX 40 cm",30.325632777771425]
["Anode INOX 50 cm",25.347999778481856]
["Anode canne anglaise 36 cm de long inox",30.558181906149095]
[]
[]
[]
[]
[]
[null,"Portatif Courant Continu 1 Anode"]
[]
[]
[]
[null,"Retour à la page précédente"]
[]
[null,"Retour à l'Accueil"]

{"sheet":"Portatif PDC (2)","index":9,"n_rows":87,"n_cols":12,"rows_kept":87,"cut":false,"hidden":false,"merged":[[4,9,6,9],[84,1,84,2],[86,1,86,2],[80,1,82,2],[4,5,6,6],[4,7,6,7],[38,0,38,9],[67,2,67,4],[42,0,42,5],[43,0,43,5],[65,0,65,5],[4,8,6,8],[7,0,7,9],[35,5,37,6],[35,7,37,7],[35,8,37,8],[35,9,37,9],[9,1,9,2],[23,1,23,2]]}
[]
["Paramètres du modèle :"]
["R²aj. (coefficient de détermination ajusté)"]
["Variable modélisée","Valeur","Erreur-standard","t de Student","Pr > t","Borne de prédiction inférieure   95 %","Borne de prédiction supérieure 95 %","R² ajusté","AIC","Individus statistiques","AIC","Individus statistiques"]
["Constant",27.812944999999999,1.4362849,19.3645,"<0,001",3.0939999999999999,null,0.87804499999999996,1975.175,262]
["Va",0.55915400000000004,1.3940299999999999E-2,40.110579999999999,"<0,001"]
["Duty cycle (%)",-0.17693600000000001,1.8357700000000001E-2,-9.6382499999999993,"<0,001"]
["Model equation:  D(0,1 V,cm-1) =  24,81 + 0,56*Va - 0,18*Duty cycle +/- 37,75"]
[]
[null,"RETROUVER LES CARACTERISTIQUES D'UNE PECHE PRECEDENTE"]
[null,"Tension réglée sur l'appareil (V)",200]
[null,"Tension appliquée (V)",{"$f":"C11*(C20/(C20+C21))","v":96.811250148437082}]
[null,"Conductivité spécifique pour 25°C (µS/cm)",213]
[null,"Température (°C)",12]
[null,"Conductivité Ambiante (µS/cm²)",{"$f":"$C$13/(1.023^(25-$C$14))","v":158.48799277834203}]
[null,"Modèle Anode","Anode Martin Pêcheur (Dream Electronique) 35 cm aluminium"]
[null,"Modèle Cathode","Cathode Martin Pêcheur Dream Electronique"]
[null,"Résistance anode (Ohm) à 350µS/cm",{"$f":"IF(C16=A68,B68, IF(C16=A69,B69, IF(C16=A70,B70, IF(C16=A71,B71, IF(C16=A72,B72, IF(C16=A73,B73, IF(C16=A74,B74, IF(C16=A75,B75, IF(C16=A76,B76,\"X\")))))))))","v":30.996190228711924}]
[null,"Résistance cathode (Ohm) à 350µS/cm",{"$f":"IF(C17=B46,F46,IF(C17=B47,F47,IF(C17=B48,F48,IF(C17=B49,F49,IF(C17=B50,F50,IF(C17=B51,F51,IF(C17=B52,F52,IF(C17=B53,F53,\"X\"))))))))","v":33.038083021941517}]
[null,"Résistance ambiante Anode (Ohm)",{"$f":"(C18*350)/C15","v":68.451031462187103}]
[null,"Résistance ambiante Cathode (Ohm)",{"$f":"(C19*350)/C15","v":72.960284592989709}]
[null,"Résistance équivalente Totale (Ohm)",{"$f":"C20+C21","v":141.41131605517683}]
[null,"Rapport Cyclique (entre 10% et 50%max)",5.7]
[null,"INFORMATIONS SUR LE CHAMP ELECTRIQUE / PUISSANCE REQUISE"]
[null,"MINIMALE","MOYENNE","MAXIMALE"]
["Rayon d'ATTRACTION (cm)",{"$f":"(B5-1.96*C5)+(B6-1.96*C6)*C12+C23*(B7-1.96*C7)","v":75.27142431102844},{"$f":"B5+C12*B6+C23*B7","v":80.936807565499194},{"$f":"(B5+1.96*C5)+C12*(B6+1.96*C6)+C23*(B7+1.96*C7)","v":86.602190819969934}]
["Rayon de TETANIE (cm)",{"$f":"(B36-1.96*C36)+C12*(B37-1.96*C37)+C23*(B38-1.96*C38)","v":19.390586002320681},{"$f":"B36+C12*B37+C23*B38","v":22.507413158201004},{"$f":"(B36+1.96*C36)+C12*(B37+1.96*C37)+C23*(B38+1.96*C38)","v":25.624240314081327}]
["Puissance de sortie requise (W)",{"$f":"(C11^2/C22)*(C23/100)","v":16.123179273081469}]
["Charge électrique de la batterie (Ah)",4]
["Tension fournie par la batterie (V)",24]
["Temps de décharge pour 25% profondeur de décharge de la batterie (minutes) à ne pas dépasser",{"$f":"((B29*B30)/B28)*0.25*60","v":89.312410140111695}]
[]
["Paramètres du modèle :"]
["R²aj. (coefficient de détermination ajusté)",0.69601983644310028]
["Variable modélisée","Valeur","Erreur-standard","t de Student","Pr > t","Borne de prédiction inférieure   95 %","Borne de prédiction supérieure 95 %","R² ajusté","AIC","Individus statistiques","AIC","Individus statistiques"]
["Constant",6.753558,0.80761760000000005,8.3623209999999997,"<0,001",1.5189999999999999,null,0.72431020000000002,1340.5160000000001,221]
["Va",0.16472300000000001,7.0644999999999996E-3,23.317094000000001,"<0,001"]
["Duty cycle (%)",-3.3891999999999999E-2,1.7311799999999999E-2,-1.9577439999999999,5.1499999999999997E-2]
["Model equation: D(0,5 V,cm-1) = 6,75 + 0,16 * Va - 0,034 *Duty cycle +/- 1,52"]
[]
[]
[]
["Tableaux des résistances des cathodes et des anodes"]
["Taille des Cathodes et la Résistance Equivalente mesurée à une conductivité ambiante de 350 µS.cm-1"]
["Référence Cathode","Type de Cathode","Dimension 1 cm)","Dimension 2 (cm)","Epaisseur du cordon/ Taille de la Maille (mm)","Résistance mesurée en Ω"]
["P","Cathode Héron Dream Electronique","4 tresses de 850 *10 sur une tige de métal",null,null,6.7269212884583069]
["R","Cathode Martin Pêcheur Dream Electronique",null,null,3,33.038083021941517]
["S","Cathode  Cuivre ELT60 II Hans Grassl",210,15,3,19.490708303307116]
["T","Cathode INOX LR-24 Smith Root",110,null,5,32.320365085792105]
["A","Bande de Cuivre 75*2,5 cm",75,2.5,3,48]
["B","Bande de Cuivre 150*2,5 cm",150,2.5,3,31]
["C","Bande de Cuivre 300*2,5 cm",300,2.5,3,20]
["H","Cathode cuivre EL63II 5 mètres",500,2.5,null,15.557027781685669]
["D","Maille d'Acier",25,25,13,49]
["E","Maille d'Acier",50,50,13,27]
["F","Maille d'Acier",75,75,13,19]
["G","Maille d'Aluminium expansé",60,55,25.4,26]
["H","Maille d'Aluminium perforé",29,39,null,35]
["I","Maille d'Aluminium perforé",16,17,null,60]
["J","Plaque d'Aluminium épaisse de 2 mm",30,41,null,34]
["K","Tôle perforée en Acier Inoxydable",50,50,6,21]
["L","Treillis d'Acier soudé",29,40,25.4,34]
["M","Treillis d'Acier soudé",17,17,25.4,64]
["N","Cable inox",110,null,5,40]
["O","8 tresses de cuivre de 90*1 soudées sur une barre en cuivre",null,null,3,20]
["Résistances équivalentes Anodes pour une conductivité ambiante de 350 µS.cm-1"]
["Type d'anode","Résistance mesurée en Ω"]
["Anode Martin Pêcheur (Dream Electronique) 35 cm aluminium",30.996190228711924,"Si l'anode n'est pas dans la liste ci-contre :"]
["Anode  LR-24 (Smith Root) 28 cm aluminium",37.093261309907561]
["Anode ELT60II (Hans Grassl) 40 cm inox",27.562744722895957,"Diamètre anode Da  (mm) ="]
["Anode EL63II (Hans Grassl) 30 cm inox",31.019777707914521]
["Anode INOX 20 cm",41.424312990970819,"Résistance anode Ra (Ohm) à 350µS/cm"]
["Anode INOX 30 cm",37.6437665278483,null,"(Beaumont et al., 2005)"]
["Anode INOX 40 cm",30.325632777771425]
["Anode INOX 50 cm",25.347999778481856]
["Anode canne anglaise 36 cm de long inox",30.558181906149095]
[]
[]
[]
[]
[null,"Portatif Courant Continu Pulsé 1 Anode"]
[]
[]
[]
[null,"Retour à la page précédente"]
[]
[null,"Retour à l'Accueil"]

{"sheet":"NON Portatif 1 Anode (2)","index":10,"n_rows":109,"n_cols":10,"rows_kept":109,"cut":false,"hidden":false,"merged":[[87,0,87,5],[89,2,89,4],[102,1,104,2],[108,1,108,2],[56,1,56,2],[106,1,106,2],[3,7,4,7],[3,8,4,8],[5,0,5,9],[6,1,6,2],[19,1,19,2],[42,0,42,9],[43,1,43,2],[64,0,64,5],[65,0,65,5],[31,7,32,7],[31,8,32,8],[33,0,33,9],[40,7,41,7],[40,8,41,8],[40,9,41,9],[31,9,32,9]]}
["Paramètres du modèle :"]
["R²aj. (coefficient de détermination ajusté)",0.81]
["Paramètre","Valeur","Erreur standard","t de Student","Pr > t","Borne inférieure 95 %","Borne supérieure 95 %"]
["Constante",25.207208999999999,6.4411800000000001,3.913446,"< 0,0001",-31.73,82.14,0.80958759999999996,186]
["D(0,1 V/cm) ",1.1696009999999999,4.1676999999999999E-2,28.063772,"< 0,0001",1.1679999999999999,1.1719999999999999]
["L'équation du modèle s'écrit : Va = 25,21 + 1,17 * D(0,1 V/cm) "]
[null,"AVANT DE COMMENCER UNE PECHE"]
[null,"Rayon d'ATTRACTION (cm)",150]
[null,"Conductivité spécifique pour 25°C (µS/cm)",240]
[null,"Température (°C)",16]
[null,"Conductivité Ambiante (µS/cm²)",{"$f":"C9/(1.023^(25-C10))","v":195.58274551898458},{"$f":"C9/(1.023^(25-C10))","v":195.58274551898458}]
[null,"Modèle Anode","Anode Martin Pêcheur (Dream Electronique) 35 cm aluminium"]
[null,"Modèle Cathode","Cathode Héron Dream Electronique"]
["Résistance anode (Ohm) à 350µS/cm",{"$f":"IF(C12=A90,B90,IF(C12=A91,B91,IF(C12=A92,B92,IF(C12=A93,B93,IF(C12=A94,B94,IF(C12=A95,B95,IF(C12=A96,B96,IF(C12=A97,B97,IF(C12=A98,B98,\"X\")))))))))","v":30.996190228711924},{"$f":"B14","v":30.996190228711924},{"$f":"C14","v":30.996190228711924}]
["Résistance cathode (Ohm) à 350µS/cm",{"$f":"IF(C13=B68,F68,IF(C13=B69,F69,IF(C13=B70,F70,IF(C13=B71,F71,IF(C13=B72,F72,IF(C13=B73,F73,IF(C13=B74,F74,IF(C13=B75,F75,\"X\"))))))))","v":6.7269212884583069},{"$f":"B15","v":6.7269212884583069},{"$f":"C15","v":6.7269212884583069}]
["Résistance ambiante Anode (Ohm)",{"$f":"B14*350/C11","v":55.468423614066346},{"$f":"C14*350/C11","v":55.468423614066346},{"$f":"D14*350/D11","v":55.468423614066346}]
["Résistance ambiante Cathode (Ohm)",{"$f":"B15*350/C11","v":12.037986503936622},{"$f":"C15*350/C11","v":12.037986503936622},{"$f":"D15*350/D11","v":12.037986503936622}]
["Résistance équivalente Totale (Ohm)",{"$f":"B17+B16","v":67.506410118002975},{"$f":"C17+C16","v":67.506410118002975},{"$f":"D17+D16","v":67.506410118002975}]
["Tension appliquée à l'anode (V)",{"$f":"F5*C8+F4","v":143.47},{"$f":"B4+B5*C8","v":200.64735899999999},{"$f":"G5*C8+G4","v":257.94}]
[null,"REGLAGES DE LA TENSION / INFORMATIONS SUPPLEMENTAIRES"]
[null,"MINIMALE","MOYENNE","MAXIMALE"]
["Tension à REGLER sur l'Appareil (V)",{"$f":"B19*(B18/B16)","v":174.606452258611},{"$f":"C19*(C18/C16)","v":244.19267798180724},{"$f":"D19*(D18/D16)","v":313.91920468102131}]
["Rayon de TETANIE moyen (cm)",{"$f":"B32+F32+B33*B19","v":22.224139709999999},{"$f":"B32+B33*C19","v":25.150854575306997},{"$f":"B32+B33*D19","v":31.222327619999998}]
["Puissance Requise (VA)",{"$f":"(((B22^2)/B18))*(1/0.6)","v":752.70415350299834},{"$f":"(((C22^2)/C18))*(1/0.6)","v":1472.2074510082743},{"$f":"(((D22^2)/D18))*(1/0.6)","v":2432.9854230461287}]
[]
[]
[]
[]
["Paramètres du modèle :"]
["R²aj. (coefficient de détermination ajusté)",0.57999999999999996]
["Paramètre","Valeur","Erreur standard","t de Student","Pr > t","Borne inférieure 95 %","Borne supérieure 95 %"]
["Constant",3.8876520000000001,1.1620564,3.345494,1E-3,3.1325414,4.6427630999999998,0.59689519999999996,1197.8489999999999,189]
["Va",0.105973,6.3401000000000004E-3,16.714662000000001,"<0,001",0.1027421,0.1092042]
["Model equation: D(1 V,cm-1) = 3,89 + 0,11 * Va"]
[]
[]
[]
["Paramètres du modèle :"]
["R²aj. (coefficient de détermination ajusté)",0.81]
["Paramètre","Valeur","Erreur standard","t de Student","Pr > t","Borne inférieure 95 %","Borne supérieure 95 %"]
["Constant",12.61,3.56,3.55,1E-3,null,null,0.89,168]
["Va",0.7,1.9E-2,36.35,"<0,001"]
["Model equation: D(0.1 V.cm-1) =  12.84 + 0.68 * Va "]
[null,"RETROUVER LES CARACTERISTIQUES D'UNE PECHE PRECEDENTE"]
[null,"Tension réglée sur l'appareil (V)",200]
[null,"Tension appliquée à l'Anode (V)",{"$f":"C45*(B54/B56)","v":164.33527873014162}]
[null,"Conductivité spécifique pour 25°C (µS/cm)",244]
[null,"Température (°C)",13]
[null,"Conductivité Ambiante (µS/cm²)",{"$f":"$C$47/(1.023^(25-$C$48))","v":185.73006973421363}]
[null,"Modèle Anode","Anode Martin Pêcheur (Dream Electronique) 35 cm aluminium"]
[null,"Modèle Cathode","Cathode Héron Dream Electronique"]
["Résistance anode (Ohm) à 350µS/cm",{"$f":"IF(C50=A90,B90,IF(C50=A91,B91,IF(C50=A92,B92,IF(C50=A93,B93,IF(C50=A94,B94,IF(C50=A95,B95,IF(C50=A96,B96,IF(C50=A97,B97,IF(C50=A98,B98,\"X\")))))))))","v":30.996190228711924}]
["Résistance cathode (Ohm) à 350µS/cm",{"$f":"IF(C51=B68,F68,IF(C51=B69,F69,IF(C51=B70,F70,IF(C51=B71,F71,IF(C51=B72,F72,IF(C51=B73,F73,IF(C51=B74,F74,IF(C51=B75,F75,\"X\"))))))))","v":6.7269212884583069}]
["Résistance ambiante Anode (Ohm)",{"$f":"(B52*350)/C49","v":58.41093257313694},{"$f":"B54","v":58.41093257313694},{"$f":"C54","v":58.41093257313694}]
["Résistance ambiante Cathode (Ohm)",{"$f":"(B53*350)/C49","v":12.676581957513234},{"$f":"B55","v":12.676581957513234},{"$f":"C55","v":12.676581957513234}]
["Résistance équivalente Totale (Ohm)",{"$f":"B54+B55","v":71.087514530650168},{"$f":"C54+C55","v":71.087514530650168},{"$f":"D54+D55","v":71.087514530650168}]
[null,"INFORMATIONS SUR LE CHAMP ELECTRIQUE / PUISSANCE REQUISE"]
[null,"MINIMALE","MOYENNE","MAXIMALE"]
["Rayon d'ATTRACTION (cm)",{"$f":"(B42-1.96*C42)*C46+(B41-1.96*C41)","v":114.54724933118867},{"$f":"B42*C46+B41","v":127.64469511109913},{"$f":"(B42+1.96*C42)*C46+(B41+1.96*C41)","v":140.7421408910096}]
["Rayon de TETANIE (cm)",{"$f":"(B33-1.96*C33)*C46+(B32-1.96*C32)","v":16.982995831542436},{"$f":"B33*C46+B32","v":21.302754492869298},{"$f":"(B33+1.96*C33)*C46+(B32+1.96*C32)","v":25.622513154196159}]
["Puissance de sortie requise (W)",{"$f":"(((C45^2)/B56))","v":562.68671459533948}]
[]
[]
[]
["Tableaux des résistances des cathodes et des anodes"]
["Taille des Cathodes et la Résistance Equivalente mesurée à une conductivité ambiante de 350 µS.cm-1"]
["Référence Cathode","Type de Cathode","Dimension 1 cm)","Dimension 2 (cm)","Epaisseur du cordon/ Taille de la Maille (mm)","Résistance mesurée en Ω"]
["A","Cathode Héron Dream Electronique","4 tresses de 850 *10 sur une tige de métal",null,null,6.7269212884583069]
["B","Cathode Martin Pêcheur Dream Electronique",null,null,3,33.038083021941517]
["C","Cathode  Cuivre ELT60 II Hans Grassl",210,15,3,19.490708303307116]
["D","Cathode INOX LR-24 Smith Root",110,null,5,32.320365085792105]
["E","Bande de Cuivre 75*2,5 cm",75,2.5,3,48]
["F","Bande de Cuivre 150*2,5 cm",150,2.5,3,31]
["G","Bande de Cuivre 300*2,5 cm",300,2.5,3,20]
["H","Cathode cuivre EL63II 5 mètres Hans Grassl",500,2.5,null,15.557027781685669]
["I","Maille d'Acier",25,25,13,49]
["J","Maille d'Acier",50,50,13,27]
["K","Maille d'Acier",75,75,13,19]
["L","Maille d'Aluminium expansé",60,55,25.4,26]
["M","Maille d'Aluminium perforé",29,39,null,35]
["N","Maille d'Aluminium perforé",16,17,null,60]
["O","Plaque d'Aluminium épaisse de 2 mm",30,41,null,34]
["P","Tôle perforée en Acier Inoxydable",50,50,6,21]
["Q","Treillis d'Acier soudé",29,40,25.4,34]
["R","Treillis d'Acier soudé",17,17,25.4,64]
["S","Cable inox",110,null,5,40]
["T","8 tresses de cuivre de 90*1 soudées sur une barre en cuivre",null,null,3,20]
["Résistances équivalentes Anodes pour une conductivité ambiante de 350 µS.cm-1"]
["Type d'anode","Résistance mesurée en Ω"]
["Anode Martin Pêcheur (Dream Electronique) 35 cm aluminium",30.996190228711924,"Si l'anode n'est pas dans la liste ci-contre :"]
["Anode  LR-24 (Smith Root) 28 cm aluminium",37.093261309907561]
["Anode ELT60II (Hans Grassl) 40 cm inox",27.562744722895957,"Diamètre anode Da  (mm) ="]
["Anode EL63II (Hans Grassl) 30 cm inox",31.019777707914521]
["Anode INOX 20 cm",41.424312990970819,"Résistance anode Ra (Ohm) à 350µS/cm"]
["Anode INOX 30 cm",37.6437665278483,null,"(Beaumont et al., 2005)"]
["Anode INOX 40 cm",30.325632777771425]
["Anode INOX 50 cm",25.347999778481856]
["Anode canne anglaise 36 cm de long inox",30.558181906149095]
[]
[]
[]
[]
[null,"NON Portatif Courant Continu 1 Anode"]
[]
[]
[]
[null,"Retour à la page précédente"]
[]
[null,"Retour à l'Accueil"]

{"sheet":"NON Portatif 2 Anodes (2)","index":11,"n_rows":122,"n_cols":10,"rows_kept":122,"cut":false,"hidden":false,"merged":[[57,1,57,2],[119,1,119,2],[32,7,33,7],[32,8,33,8],[121,1,121,2],[61,2,61,3],[115,1,117,2],[34,0,34,9],[40,7,41,7],[40,8,41,8],[42,0,42,9],[43,1,43,2],[40,9,41,9],[32,9,33,9],[3,7,4,7],[3,8,4,8],[5,0,5,9],[6,1,6,2],[20,1,20,2]]}
["Paramètres du modèle :"]
["R²aj. (coefficient de détermination ajusté)",0.81]
["Paramètre","Valeur","Erreur standard","t de Student","Pr > t","Borne inférieure 95 %","Borne supérieure 95 %"]
["Constante",25.207208999999999,6.4411800000000001,3.913446,"< 0,0001",-31.73,82.14,0.80958759999999996,186]
["D(0,1 V/cm) ",1.1696009999999999,4.1676999999999999E-2,28.063772,"< 0,0001",1.1679999999999999,1.1719999999999999]
["L'équation du modèle s'écrit : Va = 25,21 + 1,17 * D(0,1 V/cm) "]
[null,"AVANT DE COMMENCER UNE PECHE"]
[null,"Rayon d'ATTRACTION (cm)",100]
[null,"Conductivité spécifique pour 25°C (µS/cm)",231]
[null,"Température (°C)",13.1]
[null,"Conductivité Ambiante (µS/cm²)",{"$f":"C9/(1.023^(25-C10))","v":176.23490904465089},{"$f":"C9/(1.023^(25-C10))","v":176.23490904465089}]
[null,"Modèle Anode","Anode INOX 20 cm"]
[null,"Modèle Cathode","Bande de Cuivre 150*2,5 cm"]
["Résistance anode (Ohm) à 350µS/cm",{"$f":"IF(C12=A104,B104,IF(C12=A105,B105,IF(C12=A108,B108,IF(C12=A109,B109,IF(C12=A110,B110,IF(C12=A111,B111,IF(C12=A106,B106,IF(C12=A107,B107,IF(C12=A112,B112,\"X\")))))))))","v":41.424312990970819},{"$f":"B14","v":41.424312990970819},{"$f":"C14","v":41.424312990970819}]
["Résistance cathode (Ohm) à 350µS/cm",{"$f":"IF(C13=B82,F82,IF(C13=B83,F83,IF(C13=B84,F84,IF(C13=B85,F85,IF(C13=B86,F86,IF(C13=B87,F87,IF(C13=B88,F88,IF(C13=B89,F89,\"X\"))))))))","v":31},{"$f":"B15","v":31},{"$f":"C15","v":31}]
["Résistance ambiante Anode (Ohm)",{"$f":"B14*350/C11","v":82.268091069099384}]
["Résistance ambiante équivalente  2 Anodes arrangées (Ohm)",{"$f":"B16/2","v":41.134045534549692}]
["Résistance ambiante Cathode (Ohm)",{"$f":"B15*350/C11","v":61.565555081093741},{"$f":"B15*350/C11","v":61.565555081093741},{"$f":"B15*350/D11","v":61.565555081093741}]
["Résistance équivalente Totale (Ohm)",{"$f":"B18+(B17)","v":102.69960061564343},{"$f":"B19","v":102.69960061564343},{"$f":"B19","v":102.69960061564343}]
["Tension appliquée à l'anode (V)",{"$f":"F5*C8+F4","v":85.07},{"$f":"B5*C8+B4","v":142.16730899999999},{"$f":"G5*C8+G4","v":199.33999999999997}]
[null,"REGLAGES DE LA TENSION / INFORMATIONS SUPPLEMENTAIRES"]
[null,"MINIMALE","MOYENNE","MAXIMALE"]
["Tension à REGLER sur l'Appareil (V)",{"$f":"B20*(B19/B17)","v":212.39474286657784},{"$f":"C20*(C19/B17)","v":354.94991229679465},{"$f":"D20*(D19/B17)","v":497.69328838631276}]
["Rayon de TETANIE moyen (cm)",{"$f":"B34*B20+ B33","v":12.90277511},{"$f":"B33+B34*C20","v":18.953548236656999},{"$f":"B34*D20+B33","v":25.012309819999995}]
["Puissance Requise (VA)",{"$f":"((($B$23^2)/(B17+B18)))*(1/0.6)","v":732.09513517959158},{"$f":"((($C$23^2)/(B17+C18)))*(1/0.6)","v":2044.6272345793852},{"$f":"((($D$23^2)/(B17+D18)))*(1/0.6)","v":4019.7918300870765}]
[]
[]
[]
[]
["Paramètres du modèle :"]
["R²aj. (coefficient de détermination ajusté)",0.57999999999999996]
["Paramètre","Valeur","Erreur standard","t de Student","Pr > t","Borne inférieure 95 %","Borne supérieure 95 %"]
["Constant",3.8876520000000001,1.1620564,3.345494,1E-3,3.1325414,4.6427630999999998,0.59689519999999996,1197.8489999999999,189]
["Va",0.105973,6.3401000000000004E-3,16.714662000000001,"<0,001",0.1027421,0.1092042]
["Model equation: D(1 V,cm-1) = 3,89 + 0,11 * Va"]
[]
[]
["Paramètres du modèle :"]
["R²aj. (coefficient de détermination ajusté)",0.81]
["Paramètre","Valeur","Erreur standard","t de Student","Pr > t","Borne inférieure 95 %","Borne supérieure 95 %"]
["Constant",12.61,3.56,3.55,1E-3,null,null,0.89,168,186]
["Va",0.7,1.9E-2,36.35,"<0,001"]
["Model equation: D(0.1 V.cm-1) =  12.84 + 0.68 * Va "]
[null,"RETROUVER LES CARACTERISTIQUES D'UNE PECHE PRECEDENTE"]
[null,"Tension réglée sur l'appareil (V)",200]
[null,"Tension appliquée à l'Anode (V)",{"$f":"C45*(B55/B57)","v":139.46531992114524}]
[null,"Conductivité spécifique pour 25°C (µS/cm)",244]
[null,"Température (°C)",13]
[null,"Conductivité Ambiante (µS/cm²)",{"$f":"$C$47/(1.023^(25-$C$48))","v":185.73006973421363}]
[null,"Modèle Anode","Anode Martin Pêcheur (Dream Electronique) 35 cm aluminium"]
[null,"Modèle Cathode","Cathode Héron Dream Electronique"]
["Résistance anode (Ohm) à 350µS/cm",{"$f":"IF(C50=A104,B104,IF(C50=A105,B105,IF(C50=A108,B108,IF(C50=A109,B109,IF(C50=A110,B110,IF(C50=A111,B111,IF(C50=A106,B106,IF(C12=A107,B107,IF(C12=A112,B112,\"X\")))))))))","v":30.996190228711924}]
["Résistance cathode (Ohm) à 350µS/cm",{"$f":"IF(C51=B82,F82,IF(C51=B83,F83,IF(C51=B84,F84,IF(C51=B85,F85,IF(C51=B86,F86,IF(C51=B87,F87,IF(C51=B88,F88,IF(C51=B89,F89,\"X\"))))))))","v":6.7269212884583069},{"$f":"B53","v":6.7269212884583069},{"$f":"C53","v":6.7269212884583069}]
["Résistance ambiante Anode (Ohm)",{"$f":"(B52*350)/C49","v":58.41093257313694},{"$f":"B54","v":58.41093257313694},{"$f":"C54","v":58.41093257313694}]
["Résistance ambiante équivalente  2 Anodes arrangées (Ohm)",{"$f":"B54/2","v":29.20546628656847}]
["Résistance ambiante Cathode (Ohm)",{"$f":"(B53*350)/C49","v":12.676581957513234},{"$f":"B56","v":12.676581957513234},{"$f":"C56","v":12.676581957513234}]
["Résistance équivalente Totale (Ohm)",{"$f":"B56+(B55)","v":41.882048244081702},{"$f":"C56+(B55)","v":41.882048244081702},{"$f":"D56+(B55)","v":41.882048244081702}]
[null,"INFORMATIONS SUR LE CHAMP ELECTRIQUE / PUISSANCE REQUISE"]
[null,"MINIMALE","MOYENNE","MAXIMALE"]
["Rayon d'ATTRACTION (cm)",{"$f":"(B42-1.96*C42)*C46+(B41-1.96*C41)","v":98.064435430938218},{"$f":"B41+B42*C46","v":110.23572394480166},{"$f":"(B42+1.96*C42)*C46+(B41+1.96*C41)","v":122.40701245866509}]
["Rayon de TETANIE (cm)",{"$f":"F34*C46+F33","v":17.461501245870295},{"$f":"B34*C46+B33","v":18.667210348003525},{"$f":"G34*C46+G33","v":19.872961789732727}]
["Puissance de sortie requise (W)",{"$f":"((($C$45^2)/B57))","v":955.06312792742528}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Tableaux des résistances des cathodes et des anodes"]
["Taille des Cathodes et la Résistance Equivalente mesurée à une conductivité ambiante de 350 µS.cm-1"]
["Référence Cathode","Type de Cathode","Dimension 1 cm)","Dimension 2 (cm)","Epaisseur du cordon/ Taille de la Maille (mm)","Résistance mesurée en Ω"]
["A","Cathode Héron Dream Electronique","4 tresses de 850 *10 sur une tige de métal",null,null,6.7269212884583069]
["B","Cathode Martin Pêcheur Dream Electronique",null,null,3,33.038083021941517]
["C","Cathode  Cuivre ELT60 II Hans Grassl",210,15,3,19.490708303307116]
["D","Cathode INOX LR-24 Smith Root",110,null,5,32.320365085792105]
["E","Bande de Cuivre 75*2,5 cm",75,2.5,3,48]
["F","Bande de Cuivre 150*2,5 cm",150,2.5,3,31]
["G","Bande de Cuivre 300*2,5 cm",300,2.5,3,20]
["H","Cathode cuivre EL63II 5 mètres Hans Grassl",500,2.5,null,15.557027781685669]
["I","Maille d'Acier",25,25,13,49]
["J","Maille d'Acier",50,50,13,27]
["K","Maille d'Acier",75,75,13,19]
["L","Maille d'Aluminium expansé",60,55,25.4,26]
["M","Maille d'Aluminium perforé",29,39,null,35]
["N","Maille d'Aluminium perforé",16,17,null,60]
["O","Plaque d'Aluminium épaisse de 2 mm",30,41,null,34]
["P","Tôle perforée en Acier Inoxydable",50,50,6,21]
["Q","Treillis d'Acier soudé",29,40,25.4,34]
["R","Treillis d'Acier soudé",17,17,25.4,64]
["S","Cable inox",110,null,5,40]
["T","8 tresses de cuivre de 90*1 soudées sur une barre en cuivre",null,null,3,20]
["Résistances équivalentes Anodes pour une conductivité ambiante de 350 µS.cm-1"]
["Type d'anode","Résistance mesurée en Ω"]
["Anode Martin Pêcheur (Dream Electronique) 35 cm aluminium",30.996190228711924,"Si l'anode n'est pas dans la liste ci-contre :"]
["Anode  LR-24 (Smith Root) 28 cm aluminium",37.093261309907561]
["Anode ELT60II (Hans Grassl) 40 cm inox",27.562744722895957,"Diamètre anode Da  (mm) ="]
["Anode EL63II (Hans Grassl) 30 cm inox",31.019777707914521]
["Anode INOX 20 cm",41.424312990970819,"Résistance anode Ra (Ohm) à 350µS/cm"]
["Anode INOX 30 cm",37.6437665278483,null,"(Beaumont et al., 2005)"]
["Anode INOX 40 cm",30.325632777771425]
["Anode INOX 50 cm",25.347999778481856]
["Anode canne anglaise 36 cm de long inox",30.558181906149095]
[]
[]
[]
[null,"NON Portatif Courant Continu 2 Anodes"]
[]
[]
[]
[null,"Retour à la page précédente"]
[]
[null,"Retour à l'Accueil"]

{"sheet":"Guide avant de pêcher","index":12,"n_rows":9,"n_cols":10,"rows_kept":9,"cut":false,"hidden":false,"merged":[[8,9,8,10],[6,8,6,11]]}
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Retour à la page précédente"]
[]
[null,null,null,null,null,null,null,null,null,"Retour à l'Accueil"]

{"sheet":"Guide retrouver les caractérist","index":13,"n_rows":9,"n_cols":10,"rows_kept":9,"cut":false,"hidden":false,"merged":[[8,9,8,10],[6,8,6,11]]}
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Retour à la page précédente"]
[]
[null,null,null,null,null,null,null,null,null,"Retour à l'Accueil"]

{"sheet":"Guide achat","index":14,"n_rows":45,"n_cols":10,"rows_kept":45,"cut":false,"hidden":false,"merged":[[44,3,44,4],[8,9,8,10],[42,2,42,5],[6,8,6,11]]}
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Retour à la page précédente"]
[]
[null,null,null,null,null,null,null,null,null,"Retour à l'Accueil"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Retour à la page précédente"]
[]
[null,null,null,"Retour à l'Accueil"]

{"sheet":"Fiches techniques engin des pêc","index":15,"n_rows":133,"n_cols":13,"rows_kept":133,"cut":false,"hidden":false,"merged":[[0,12,0,13],[32,12,32,13],[66,12,66,13],[98,12,98,13],[132,12,132,13]]}
[null,null,null,null,null,null,null,null,null,null,null,null,"Retour à l'Accueil"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Retour à l'Accueil"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Retour à l'Accueil"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Retour à l'Accueil"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Retour à l'Accueil"]

{"sheet":"Achat portatif DC","index":16,"n_rows":132,"n_cols":10,"rows_kept":132,"cut":false,"hidden":false,"merged":[[37,1,37,2],[17,3,17,4],[16,1,16,4],[19,1,19,2],[17,1,17,2],[29,0,29,1],[29,2,29,3],[25,1,25,4],[131,2,131,3],[129,2,129,3],[71,1,71,2],[90,0,90,5],[91,0,91,5],[113,0,113,5],[115,2,115,4],[83,5,86,5],[41,3,41,4],[83,6,86,6],[83,7,86,7],[83,8,84,8],[87,0,87,9],[56,1,56,2],[51,8,54,8],[51,5,53,5],[51,6,53,6],[51,7,54,7],[41,1,41,2],[55,0,55,9],[19,3,19,4],[10,0,10,5],[18,3,18,4],[18,1,18,2],[8,0,8,5],[3,9,5,9],[6,0,6,9],[0,1,1,1],[11,0,11,1],[11,2,11,3],[11,4,11,5],[3,5,5,6],[3,7,5,7],[3,8,5,8],[7,0,7,8]]}
["Paramètres du modèle :",0.91]
["R²aj. (coefficient de détermination ajusté)"]
["Paramètre","Valeur","Ecart-type","t de Student","Pr > t","Borne inférieure 95 %","Borne supérieure 95 %"]
["Constant",-34.452219999999997,3.5405470000000001,-9.7307600000000001,"<0,001",5.75,null,"0.8596504","2275.619",262]
["D(0,1 V,cm-1)",1.60701,4.0932000000000003E-2,39.260089999999998,"<0,001"]
["Duty cycle (%)",0.26811000000000001,3.4722999999999997E-2,7.7214900000000002,"<0,001"]
["Model equation:  Va =  -34.45+ 1.61 * D(0.1 V.cm-1)+0.27* Duty cycle +/- 5.75"]
[]
["Conseils avant l'achat d'un matériel portatif fournissant du courant continu "]
[]
["Conditions environnementales de pêche"]
["Rayon d'ATTRACTION (cm)",null,"Conductivité spécifique pour 25°C (µS/cm)",null,"Température (°C)"]
["Minimum","Maximum","Minimum","Maximum","Minimum","Maximum"]
[80,300,180,500,4,20]
[]
[]
[null,"Configuration de l'appareil de pêche sucseptible d'être acheté "]
[null,"Modèle Anode",null,"Modèle Cathode"]
[null,"Anode INOX 30 cm",null,"Bande de Cuivre 300*2,5 cm"]
[null,"Tensions réglables ",null,"Si l'engin est alimenté par une batterie "]
[null,"Minimum","Maximum","Charge électrique de la batterie (Ah)","Tension fournie par la batterie (V)"]
[null,50,530,7,24]
[null,"Puissance de sortie de l'engin susceptible d'être acheté (W) "]
[null,1300]
[]
[null,"Compatibilité avec les conditions de travail voulues"]
[]
[]
[]
["MINIMUM",null,"MAXIMUM"]
["Conductivité Ambiante (µS/cm²)",{"$f":"$C$14/(1.023^(25-$E$14))","v":111.65654804523555},"Conductivité Ambiante (µS/cm²)",{"$f":"$D$14/(1.023^(25-$F$14))","v":446.26398144612153}]
["Résistance anode (Ohm) à 350µS/cm",{"$f":"IF(B19=A116,B116, IF(B19=A117,B117, IF(B19=A118,B118, IF(B19=A119,B119, IF(B19=A120,B120, IF(B19=A121,B121, IF(B19=A122,B122,IF(B19=A123,B123,IF(B19=A124,B124,\"X\")))))))))","v":37.6437665278483},"Résistance anode (Ohm) à 350µS/cm",{"$f":"IF(B19=A116,B116, IF(B19=A117,B117, IF(B19=A118,B118, IF(B19=A119,B119, IF(B19=A120,B120, IF(B19=A121,B121, IF(B19=A122,B122,IF(B19=A123,B123,IF(B19=A124,B124,\"X\")))))))))","v":37.6437665278483}]
["Résistance cathode (Ohm) à 350µS/cm",{"$f":"IF(D19=B94,F94,IF(D19=B95,F95,IF(D19=B96,F96,IF(D19=B97,F97,IF(D19=B98,F98,IF(D19=B99,F99,IF(D19=B100,F100,IF(D19=B101,F101,\"X\"))))))))","v":20},"Résistance cathode (Ohm) à 350µS/cm",{"$f":"IF(D19=B94,F94,IF(D19=B95,F95,IF(D19=B96,F96,IF(D19=B97,F97,IF(D19=B98,F98,IF(D19=B99,F99,IF(D19=B100,F100,IF(D19=B101,F101,\"X\"))))))))","v":20}]
["Résistance ambiante Anode (Ohm)",{"$f":"(B32*350)/B31","v":117.99861732613454},"Résistance ambiante Anode (Ohm)",{"$f":"(D32*350)/D31","v":29.523597763933793}]
["Résistance ambiante Cathode (Ohm)",{"$f":"(B33*350)/B31","v":62.692247992156105},"Résistance ambiante Cathode (Ohm)",{"$f":"(D33*350)/D31","v":15.685783058978794}]
["Résistance équivalente Totale (Ohm)",{"$f":"B34+B35","v":180.69086531829063},"Résistance équivalente Totale (Ohm)",{"$f":"D34+D35","v":45.209380822912586}]
["Tension moyenne appliquée à l'Anode (V)",{"$f":"B4+B5*A14+B6*100","v":120.91958},null,{"$f":"B4+B5*B14+B6*100","v":474.46177999999998}]
[null," Tension moyenne à REGLER sur l'Appareil (V) "]
[null,"Minimum","Maximum"]
[null,{"$f":"B37*($B$36/$B$34)","v":185.16372512854099},{"$f":"D37*($D$36/$D$34)","v":726.54164541357386}]
["Compatible (oui/non)",{"$f":"IF(B22<B40, \"OUI\", IF(B22=B40, \"OUI\", \"NON\"))","v":"OUI"},{"$f":"IF(C22>C40, \"OUI\", IF(C22=C40, \"OUI\", \"NON\"))","v":"NON"}]
[null,"Puissance de sortie requise (W)",null,"Si l'engin est alimenté par une Batterie. Temps de décharge pour 25% profondeur de décharge de la batterie (minutes) à ne pas dépasser"]
[null,"Minimum","Maximum","Maximum","Minimum"]
[null,{"$f":"(B40^2/B36)","v":189.74730705441632},{"$f":"(C40^2/D36)","v":11675.956469917786},{"$f":"((D22*E22)/B44)*0.25*60","v":13.28082089342805},{"$f":"((D22*E22)/C44)*0.25*60","v":0.21582814277293585}]
["Compatible (oui/non)",{"$f":"IF(B24>B44, \"OUI\", IF(B24=B44, \"OUI\", \"NON\"))","v":"OUI"},{"$f":"IF(B24>C44, \"OUI\", IF(B24=C44, \"OUI\", \"NON\"))","v":"NON"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Tableaux des résistances des cathodes et des anodes"]
["Taille des Cathodes et la Résistance Equivalente mesurée à une conductivité ambiante de 350 µS.cm-1"]
["Référence Cathode","Type de Cathode","Dimension 1 cm)","Dimension 2 (cm)","Epaisseur du cordon/ Taille de la Maille (mm)","Résistance mesurée en Ω"]
["P","Cathode Héron Dream Electronique","4 tresses de 850 *10 sur une tige de métal",null,null,6.7269212884583069]
["R","Cathode Martin Pêcheur Dream Electronique",null,null,3,33.038083021941517]
["S","Cathode  Cuivre ELT60 II Hans Grassl",210,15,3,19.490708303307116]
["T","Cathode INOX LR-24 Smith Root",110,null,5,32.320365085792105]
["A","Bande de Cuivre 75*2,5 cm",75,2.5,3,48]
["B","Bande de Cuivre 150*2,5 cm",150,2.5,3,31]
["C","Bande de Cuivre 300*2,5 cm",300,2.5,3,20]
["H","Cathode cuivre EL63II 5 mètres",500,2.5,null,15.557027781685669]
["D","Maille d'Acier",25,25,13,49]
["E","Maille d'Acier",50,50,13,27]
["F","Maille d'Acier",75,75,13,19]
["G","Maille d'Aluminium expansé",60,55,25.4,26]
["H","Maille d'Aluminium perforé",29,39,null,35]
["I","Maille d'Aluminium perforé",16,17,null,60]
["J","Plaque d'Aluminium épaisse de 2 mm",30,41,null,34]
["K","Tôle perforée en Acier Inoxydable",50,50,6,21]
["L","Treillis d'Acier soudé",29,40,25.4,34]
["M","Treillis d'Acier soudé",17,17,25.4,64]
["N","Cable inox",110,null,5,40]
["O","8 tresses de cuivre de 90*1 soudées sur une barre en cuivre",null,null,3,20]
["Résistances équivalentes Anodes pour une conductivité ambiante de 350 µS.cm-1"]
["Type d'anode","Résistance mesurée en Ω"]
["Anode Martin Pêcheur (Dream Electronique) 35 cm aluminium",30.996190228711924,"Si l'anode n'est pas dans la liste ci-contre :"]
["Anode  LR-24 (Smith Root) 28 cm aluminium",37.093261309907561]
["Anode ELT60II (Hans Grassl) 40 cm inox",27.562744722895957,"Diamètre anode Da  (mm) ="]
["Anode EL63II (Hans Grassl) 30 cm inox",31.019777707914521]
["Anode INOX 20 cm",41.424312990970819,"Résistance anode Ra (Ohm) à 350µS/cm"]
["Anode INOX 30 cm",37.6437665278483,null,"(Beaumont et al., 2005)"]
["Anode INOX 40 cm",30.325632777771425]
["Anode INOX 50 cm",25.347999778481856]
["Anode canne anglaise 36 cm de long inox",30.558181906149095]
[]
[]
[]
[]
[]
[null,null,"Retour au choix du type d'appareil"]
[]
[null,null,"Retour à l'Accueil"]

{"sheet":"Achat portatif PDC","index":17,"n_rows":129,"n_cols":12,"rows_kept":129,"cut":false,"hidden":false,"merged":[[16,1,16,4],[17,1,17,2],[17,3,17,4],[18,1,18,2],[37,1,37,2],[18,3,18,4],[21,1,21,2],[21,3,21,4],[25,1,25,4],[29,0,29,1],[29,2,29,3],[128,2,128,3],[83,5,86,5],[91,0,91,5],[113,0,113,5],[115,2,115,4],[126,2,126,3],[83,6,86,6],[41,1,41,2],[41,3,41,4],[87,0,87,9],[90,0,90,5],[83,7,86,7],[83,8,84,8],[51,5,53,5],[51,6,53,6],[51,7,54,7],[51,8,54,8],[56,1,56,2],[71,1,71,2],[55,0,55,9],[8,0,8,5],[10,0,10,5],[11,0,11,1],[11,2,11,3],[11,4,11,5],[3,7,5,7],[3,8,5,8],[3,9,5,9],[6,0,6,9],[0,1,1,1],[3,5,5,6]]}
["Paramètres du modèle :",0.91]
["R²aj. (coefficient de détermination ajusté)"]
["Variable modélisée","Valeur","Erreur-standard","t de Student","Pr > t","Borne de prédiction inférieure   95 %","Borne de prédiction supérieure 95 %","R² ajusté","AIC","Individus statistiques","AIC","Individus statistiques"]
["Constant",-34.452219999999997,3.5405470000000001,-9.7307600000000001,"<0,001",5.75,null,0.85965040000000004,2275.6190000000001,262,1718.77,221]
["D(0,1 V,cm-1)",1.60701,4.0932000000000003E-2,39.260089999999998,"<0,001"]
["Duty cycle (%)",0.26811000000000001,3.4722999999999997E-2,7.7214900000000002,"<0,001"]
["Model equation:  Va =  -34,45+ 1,61 * D(0,1 V,cm-1)+0,27* Duty cycle +/- 5,75"]
[]
["Conseils avant l'achat d'un matériel portatif fournissant du courant continu pulsé"]
[]
["Conditions environnementales de pêche"]
["Rayon d'ATTRACTION (cm)",null,"Conductivité spécifique pour 25°C (µS/cm)",null,"Température (°C)"]
["Minimum","Maximum","Minimum","Maximum","Minimum","Maximum"]
[100,150,200,500,10,25]
[]
[]
[null,"Configuration de l'appareil de pêche voulu "]
[null,"Modèle Anode",null,"Modèle Cathode"]
[null,"Anode Martin Pêcheur (Dream Electronique) 35 cm aluminium",null,"Cathode Martin Pêcheur Dream Electronique"]
[null,"Puissance de sortie de l'engin (W) ","Rapport Cyclique en % (entre 10% et 50 %)"]
[null,240,25]
[null,"Tensions réglables ",null,"Si l'engin est alimenté par une batterie "]
[null,"Minimum","Maximum","Charge électrique de la batterie (Ah)","Tension fournie par la batterie (V)"]
[null,70,500,7,24]
[]
[null,"Compatibilité avec les conditions de travail voulues"]
[]
[]
[]
["MINIMUM",null,"MAXIMUM"]
["Conductivité Ambiante (µS/cm²)",{"$f":"$C$14/(1.023^(25-$E$14))","v":142.19865545367489},"Conductivité Ambiante (µS/cm²)",{"$f":"$D$14/(1.023^(25-$F$14))","v":500}]
["Résistance anode (Ohm) à 350µS/cm",{"$f":"IF(B19=A116,B116, IF(B19=A117,B117, IF(B19=A118,B118, IF(B19=A119,B119, IF(B19=A120,B120, IF(B19=A121,B121, IF(B19=A122,B122,IF(B19=A123,B123,IF(B19=A124,B124,\"X\")))))))))","v":30.996190228711924},"Résistance anode (Ohm) à 350µS/cm",{"$f":"IF(B19=A116,B116, IF(B19=A117,B117, IF(B19=A118,B118, IF(B19=A119,B119, IF(B19=A120,B120, IF(B19=A121,B121, IF(B19=A122,B122,IF(B19=A123,B123,IF(B19=A124,B124,\"X\")))))))))","v":30.996190228711924}]
["Résistance cathode (Ohm) à 350µS/cm",{"$f":"IF(D19=B94,F94,IF(D19=B95,F95,IF(D19=B96,F96,IF(D19=B97,F97,IF(D19=B98,F98,IF(D19=B99,F99,IF(D19=B100,F100,IF(D19=B101,F101,\"X\"))))))))","v":33.038083021941517},"Résistance cathode (Ohm) à 350µS/cm",{"$f":"IF(D19=B94,F94,IF(D19=B95,F95,IF(D19=B96,F96,IF(D19=B97,F97,IF(D19=B98,F98,IF(D19=B99,F99,IF(D19=B100,F100,IF(D19=B101,F101,\"X\"))))))))","v":33.038083021941517}]
["Résistance ambiante Anode (Ohm)",{"$f":"(B32*350)/B31","v":76.29232882292213},"Résistance ambiante Anode (Ohm)",{"$f":"(D32*350)/D31","v":21.697333160098346}]
["Résistance ambiante Cathode (Ohm)",{"$f":"(B33*350)/B31","v":81.318132163680005},"Résistance ambiante Cathode (Ohm)",{"$f":"(D33*350)/D31","v":23.126658115359064}]
["Résistance équivalente Totale (Ohm)",{"$f":"B34+B35","v":157.61046098660213},"Résistance équivalente Totale (Ohm)",{"$f":"D34+D35","v":44.823991275457409}]
["Tension moyenne appliquée à l'Anode (V)",{"$f":"B4+B5*A14+B6*C21","v":132.95152999999999},null,{"$f":"B4+B5*B14+B6*C21","v":213.30203000000003}]
[null," Tension moyenne à REGLER sur l'Appareil (V) "]
[null,"Minimum","Maximum"]
[null,{"$f":"B37*($B$36/$B$34)","v":274.66132251396476},{"$f":"D37*($D$36/$D$34)","v":440.65546033741316}]
["Compatible (oui/non)",{"$f":"IF(B24<B40, \"OUI\", IF(B24=B40, \"OUI\", \"NON\"))","v":"OUI"},{"$f":"IF(C24>C40, \"OUI\", IF(C24=C40, \"OUI\", \"NON\"))","v":"OUI"}]
[null,"Puissance de sortie requise (W)",null,"Si l'engin est alimenté par une Batterie. Temps de décharge pour 25% profondeur de décharge de la batterie (minutes) à ne pas dépasser"]
[null,"Minimum","Maximum","Maximum","Minimum"]
[null,{"$f":"(B40^2/B36)*(C21/100)","v":119.66027129939829},{"$f":"(C40^2/D36)*(C21/100)","v":1082.9983519980283},{"$f":"((D24*E24)/B44)*0.25*60","v":21.05962131487054},{"$f":"((D24*E24)/C44)*0.25*60","v":2.3268733468992275}]
["Compatible (oui/non)",{"$f":"IF(B21>B44, \"OUI\", IF(B21=B44, \"OUI\", \"NON\"))","v":"OUI"},{"$f":"IF(B21>C44, \"OUI\", IF(B21=C44, \"OUI\", \"NON\"))","v":"NON"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Paramètres du modèle :"]
["R²aj. (coefficient de détermination ajusté)",0.69601983644310028]
["Paramètre","Valeur","Ecart-type","t de Student","Pr > t","Borne inférieure 95 %","Borne supérieure 95 %"]
["Constante",10.064669,0.88255439999999996,11.404021,"< 0,0001","1,00 * D(0,5 V/cm) - 9,10","1,00 * D(0,5 V/cm) + 9,10",0.79543569999999997,221]
["Va",0.15579299999999999,6.1104000000000002E-3,25.496248000000001,"< 0,0001"]
["Rapport cyclique",-4.8554E-2,1.9072599999999999E-2,-2.5457610000000002,"< 0,05"]
["Fréquence",-5.5071000000000002E-2,1.3196299999999999E-2,-4.1732170000000002,"< 0,0001"]
["L'équation du modèle s'écrit : D(0,5 V/cm) =  10,06 + 0,16 * Va - 0,05 * Rapport cyclique - 0,06 * Fréquence"]
[]
[]
["Tableaux des résistances des cathodes et des anodes"]
["Taille des Cathodes et la Résistance Equivalente mesurée à une conductivité ambiante de 350 µS.cm-1"]
["Référence Cathode","Type de Cathode","Dimension 1 cm)","Dimension 2 (cm)","Epaisseur du cordon/ Taille de la Maille (mm)","Résistance mesurée en Ω"]
["P","Cathode Héron Dream Electronique","4 tresses de 850 *10 sur une tige de métal",null,null,6.7269212884583069]
["R","Cathode Martin Pêcheur Dream Electronique",null,null,3,33.038083021941517]
["S","Cathode  Cuivre ELT60 II Hans Grassl",210,15,3,19.490708303307116]
["T","Cathode INOX LR-24 Smith Root",110,null,5,32.320365085792105]
["A","Bande de Cuivre 75*2,5 cm",75,2.5,3,48]
["B","Bande de Cuivre 150*2,5 cm",150,2.5,3,31]
["C","Bande de Cuivre 300*2,5 cm",300,2.5,3,20]
["H","Cathode cuivre EL63II 5 mètres",500,2.5,null,15.557027781685669]
["D","Maille d'Acier",25,25,13,49]
["E","Maille d'Acier",50,50,13,27]
["F","Maille d'Acier",75,75,13,19]
["G","Maille d'Aluminium expansé",60,55,25.4,26]
["H","Maille d'Aluminium perforé",29,39,null,35]
["I","Maille d'Aluminium perforé",16,17,null,60]
["J","Plaque d'Aluminium épaisse de 2 mm",30,41,null,34]
["K","Tôle perforée en Acier Inoxydable",50,50,6,21]
["L","Treillis d'Acier soudé",29,40,25.4,34]
["M","Treillis d'Acier soudé",17,17,25.4,64]
["N","Cable inox",110,null,5,40]
["O","8 tresses de cuivre de 90*1 soudées sur une barre en cuivre",null,null,3,20]
["Résistances équivalentes Anodes pour une conductivité ambiante de 350 µS.cm-1"]
["Type d'anode","Résistance mesurée en Ω"]
["Anode Martin Pêcheur (Dream Electronique) 35 cm aluminium",30.996190228711924,"Si l'anode n'est pas dans la liste ci-contre :"]
["Anode  LR-24 (Smith Root) 28 cm aluminium",37.093261309907561]
["Anode ELT60II (Hans Grassl) 40 cm inox",27.562744722895957,"Diamètre anode Da  (mm) ="]
["Anode EL63II (Hans Grassl) 30 cm inox",31.019777707914521]
["Anode INOX 20 cm",41.424312990970819,"Résistance anode Ra (Ohm) à 350µS/cm"]
["Anode INOX 30 cm",37.6437665278483,null,"(Beaumont et al., 2005)"]
["Anode INOX 40 cm",30.325632777771425]
["Anode INOX 50 cm",25.347999778481856]
["Anode canne anglaise 36 cm de long inox",30.558181906149095]
[]
[]
[null,null,"Retour au choix du type d'appareil"]
[]
[null,null,"Retour à l'Accueil"]

{"sheet":"Achat non portatif DC 1 anode","index":18,"n_rows":145,"n_cols":10,"rows_kept":145,"cut":false,"hidden":false,"merged":[[10,0,10,5],[0,1,1,1],[3,7,4,7],[3,8,4,8],[7,0,7,8],[8,0,8,5],[5,0,5,9],[3,9,4,9],[25,2,25,3],[11,0,11,1],[11,2,11,3],[11,4,11,5],[16,1,16,4],[17,1,17,2],[17,3,17,4],[18,1,18,2],[18,3,18,4],[19,1,19,2],[60,0,60,9],[61,1,61,2],[76,1,76,2],[88,5,91,5],[88,6,91,6],[88,7,91,7],[88,8,89,8],[144,2,144,3],[45,1,45,4],[37,2,37,3],[41,2,41,3],[92,0,92,9],[95,0,95,5],[96,0,96,5],[118,0,118,5],[56,8,59,8],[120,2,120,4],[132,2,132,3],[46,1,46,2],[46,3,46,4],[56,5,58,5],[56,6,58,6],[56,7,59,7]]}
["Paramètres du modèle :",0.91]
["R²aj. (coefficient de détermination ajusté)"]
["Paramètre","Valeur","Erreur standard","t de Student","Pr > t","Borne inférieure 95 %","Borne supérieure 95 %"]
["Constant",null,null,null,null,null,null,0.87,null,186]
["D(0,1 V,cm-1)",1.3,1.2E-2,33.409999999999997,"<0,001"]
["Model equation: Va = -22,62 + 1,87 * D(0,1 V,cm-1)"]
[]
[]
["Conseils avant l'achat d'un matériel non portatif avec 1 anode fournissant du courant continu "]
[]
["Conditions environnementales de pêche"]
["Rayon d'ATTRACTION (cm)",null,"Conductivité spécifique pour 25°C (µS/cm)",null,"Température (°C)"]
["Minimum","Maximum","Minimum","Maximum","Minimum","Maximum"]
[100,200,15,40000,10,25]
[]
[]
[null,"Configuration de l'appareil de pêche voulu "]
[null,"Modèle Anode",null,"Modèle Cathode"]
[null,"Anode Martin Pêcheur (Dream Electronique) 35 cm aluminium",null,"Bande de Cuivre 300*2,5 cm"]
[null,"Tensions réglables "]
[null,"Minimum","Maximum","Puissance de sortie de l'engin (W) "]
[null,150,1000,45000]
[]
[]
[]
[null,null,"Compatibilité"]
[]
[]
[]
[null,"MINIMUM",null,"MAXIMUM"]
[null,"Conductivité Ambiante (µS/cm²)",{"$f":"$C$14/(1.023^(25-$E$14))","v":10.664899159025618},"Conductivité Ambiante (µS/cm²)",{"$f":"$D$14/(1.023^(25-$F$14))","v":40000}]
[null,"Résistance anode (Ohm) à 350µS/cm",{"$f":"IF(B19=A121,B121, IF(B19=A122,B122, IF(B19=A123,B123, IF(B19=A124,B124, IF(B19=A125,B125, IF(B19=A126,B126, IF(B19=A127,B127,IF(B19=A128,B128,IF(B19=A129,B129,\"X\")))))))))","v":30.996190228711924},"Résistance anode (Ohm) à 350µS/cm",{"$f":"IF(B19=A121,B121, IF(B19=A122,B122, IF(B19=A123,B123, IF(B19=A124,B124, IF(B19=A125,B125, IF(B19=A126,B126, IF(B19=A127,B127,IF(B19=A128,B128,IF(B19=A129,B129,\"X\")))))))))","v":30.996190228711924}]
[null,"Résistance cathode (Ohm) à 350µS/cm",{"$f":"IF(D19=B99,F99,IF(D19=B100,F100,IF(D19=B101,F101,IF(D19=B102,F102,IF(D19=B103,F103,IF(D19=B104,F104,IF(D19=B105,F105,IF(D19=B106,F106,\"X\"))))))))","v":20},"Résistance cathode (Ohm) à 350µS/cm",{"$f":"IF(D19=B99,F99,IF(D19=B100,F100,IF(D19=B101,F101,IF(D19=B102,F102,IF(D19=B103,F103,IF(D19=B104,F104,IF(D19=B105,F105,IF(D19=B106,F106,\"X\"))))))))","v":20}]
[null,"Résistance ambiante Anode (Ohm)",{"$f":"(C32*350)/C31","v":1017.231050972295},"Résistance ambiante Anode (Ohm)",{"$f":"(E32*350)/E31","v":0.27121666450122933}]
[null,"Résistance ambiante Cathode (Ohm)",{"$f":"(C33*350)/C31","v":656.3587611680282},"Résistance ambiante Cathode (Ohm)",{"$f":"(E33*350)/E31","v":0.17499999999999999}]
[null,"Résistance équivalente Totale (Ohm)",{"$f":"C34+C35","v":1673.5898121403231},"Résistance équivalente Totale (Ohm)",{"$f":"E34+E35","v":0.44621666450122932}]
[null,"Tension moyenne appliquée à l'Anode (V)",{"$f":"B4+B5*A14","v":130},null,{"$f":"B4+B5*B14","v":260}]
[null,null," Tension moyenne à REGLER sur l'Appareil (V) "]
[null,null,"Minimum","Maximum"]
[null,null,{"$f":"C37*($C$36/$C$34)","v":213.88127640253049},{"$f":"E37*($E$36/$E$34)","v":427.76255280506098}]
[null,"Compatible (oui/non)",{"$f":"IF(B22<C40, \"OUI\", IF(B22=C40, \"OUI\", \"NON\"))","v":"OUI"},{"$f":"IF(C22>D40, \"OUI\", IF(C22=D40, \"OUI\", \"NON\"))","v":"OUI"}]
[null,null,"Puissance de sortie requise (W)"]
[null,null,"Minimum","Maximum"]
[null,null,{"$f":"(C40^2/C36)","v":27.33357962849508},{"$f":"(D40^2/E36)","v":410071.64487420989}]
[null,"Compatible (oui/non)",{"$f":"IF(D22>C44, \"OUI\", IF(D22=C44, \"OUI\", \"NON\"))","v":"OUI"},{"$f":"IF(D22>D44, \"OUI\", IF(D22=D44, \"OUI\", \"NON\"))","v":"NON"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Tableaux des résistances des cathodes et des anodes"]
["Taille des Cathodes et la Résistance Equivalente mesurée à une conductivité ambiante de 350 µS.cm-1"]
["Référence Cathode","Type de Cathode","Dimension 1 cm)","Dimension 2 (cm)","Epaisseur du cordon/ Taille de la Maille (mm)","Résistance mesurée en Ω"]
["P","Cathode Héron Dream Electronique","4 tresses de 850 *10 sur une tige de métal",null,null,6.7269212884583069]
["R","Cathode Martin Pêcheur Dream Electronique",null,null,3,33.038083021941517]
["S","Cathode  Cuivre ELT60 II Hans Grassl",210,15,3,19.490708303307116]
["T","Cathode INOX LR-24 Smith Root",110,null,5,32.320365085792105]
["A","Bande de Cuivre 75*2,5 cm",75,2.5,3,48]
["B","Bande de Cuivre 150*2,5 cm",150,2.5,3,31]
["C","Bande de Cuivre 300*2,5 cm",300,2.5,3,20]
["H","Cathode cuivre EL63II 5 mètres",500,2.5,null,15.557027781685669]
["D","Maille d'Acier",25,25,13,49]
["E","Maille d'Acier",50,50,13,27]
["F","Maille d'Acier",75,75,13,19]
["G","Maille d'Aluminium expansé",60,55,25.4,26]
["H","Maille d'Aluminium perforé",29,39,null,35]
["I","Maille d'Aluminium perforé",16,17,null,60]
["J","Plaque d'Aluminium épaisse de 2 mm",30,41,null,34]
["K","Tôle perforée en Acier Inoxydable",50,50,6,21]
["L","Treillis d'Acier soudé",29,40,25.4,34]
["M","Treillis d'Acier soudé",17,17,25.4,64]
["N","Cable inox",110,null,5,40]
["O","8 tresses de cuivre de 90*1 soudées sur une barre en cuivre",null,null,3,20]
["Résistances équivalentes Anodes pour une conductivité ambiante de 350 µS.cm-1"]
["Type d'anode","Résistance mesurée en Ω"]
["Anode Martin Pêcheur (Dream Electronique) 35 cm aluminium",30.996190228711924,"Si l'anode n'est pas dans la liste ci-contre :"]
["Anode  LR-24 (Smith Root) 28 cm aluminium",37.093261309907561]
["Anode ELT60II (Hans Grassl) 40 cm inox",27.562744722895957,"Diamètre anode Da  (mm) ="]
["Anode EL63II (Hans Grassl) 30 cm inox",31.019777707914521]
["Anode INOX 20 cm",41.424312990970819,"Résistance anode Ra (Ohm) à 350µS/cm"]
["Anode INOX 30 cm",37.6437665278483,null,"(Beaumont et al., 2005)"]
["Anode INOX 40 cm",30.325632777771425]
["Anode INOX 50 cm",25.347999778481856]
["Anode canne anglaise 36 cm de long inox",30.558181906149095]
[]
[]
[]
[null,null,"Retour au choix du type d'appareil"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Retour à l'Accueil"]

{"sheet":"Achat non portatif DC 2anodes","index":19,"n_rows":130,"n_cols":10,"rows_kept":130,"cut":false,"hidden":false,"merged":[[17,1,17,2],[17,3,17,4],[0,1,1,1],[3,7,4,7],[3,8,4,8],[5,0,5,9],[7,0,7,8],[8,0,8,5],[10,0,10,5],[11,0,11,1],[11,2,11,3],[11,4,11,5],[16,1,16,4],[3,9,4,9],[18,1,18,2],[18,3,18,4],[19,1,19,2],[19,3,19,4],[48,2,48,3],[57,7,60,7],[57,8,60,8],[61,0,61,9],[62,1,62,2],[77,1,77,2],[121,2,121,4],[38,2,38,3],[42,2,42,3],[25,2,25,3],[93,0,93,9],[96,0,96,5],[97,0,97,5],[119,0,119,5],[50,2,50,3],[89,5,92,5],[89,6,92,6],[89,7,92,7],[89,8,90,8],[47,3,47,4],[57,5,59,5],[57,6,59,6]]}
["Paramètres du modèle :",0.91]
["R²aj. (coefficient de détermination ajusté)"]
["Paramètre","Valeur","Erreur standard","t de Student","Pr > t","Borne inférieure 95 %","Borne supérieure 95 %"]
["Constant",null,null,null,null,null,null,0.87,null,186]
["D(0,1 V,cm-1)",1.3,1.2E-2,33.409999999999997,"<0,001"]
["Model equation: Va = -22,62 + 1,87 * D(0,1 V,cm-1)"]
[]
["L'équation du modèle s'écrit : Va =  -17,64 + 1,85 * D(0,1 V/cm)"]
["Conseils avant l'achat d'un matériel non portatif avec 2 anodes fournissant du courant continu "]
[]
["Conditions environnementales de pêche"]
["Rayon d'ATTRACTION (cm)",null,"Conductivité spécifique pour 25°C (µS/cm)",null,"Température (°C)"]
["Minimum","Maximum","Minimum","Maximum","Minimum","Maximum"]
[150,150,50,3000,10,20]
[]
[]
[null,"Configuration de l'appareil de pêche voulu "]
[null,"Modèle Anode",null,"Modèle Cathode"]
[null,"Anode INOX 40 cm",null,"Cathode Héron Dream Electronique"]
[null,"Tensions réglables "]
[null,"Minimum","Maximum","Puissance de sortie de l'engin (W) "]
[null,140,650,6000]
[]
[]
[]
[null,null,"Compatibilité"]
[]
[]
[]
[null,"MINIMUM",null,"MAXIMUM"]
[null,"Conductivité Ambiante (µS/cm²)",{"$f":"$C$14/(1.023^(25-$E$14))","v":35.549663863418722},"Conductivité Ambiante (µS/cm²)",{"$f":"$D$14/(1.023^(25-$F$14))","v":2677.5838886767292}]
[null,"Résistance anode (Ohm) à 350µS/cm",{"$f":"IF(B19=A122,B122, IF(B19=A123,B123, IF(B19=A124,B124, IF(B19=A125,B125, IF(B19=A126,B126, IF(B19=A127,B127, IF(B19=A128,B128,IF(B19=A129,B129,IF(B19=A130,B130,\"X\")))))))))","v":30.325632777771425},"Résistance anode (Ohm) à 350µS/cm",{"$f":"IF(B19=A122,B122, IF(B19=A123,B123, IF(B19=A124,B124, IF(B19=A125,B125, IF(B19=A126,B126, IF(B19=A127,B127, IF(B19=A128,B128,IF(B19=A129,B129,IF(B19=A130,B130,\"X\")))))))))","v":30.325632777771425}]
[null,"Résistance cathode (Ohm) à 350µS/cm",{"$f":"IF(D19=B100,F100,IF(D19=B101,F101,IF(D19=B102,F102,IF(D19=B103,F103,IF(D19=B104,F104,IF(D19=B105,F105,IF(D19=B106,F106,IF(D19=B107,F107,\"X\"))))))))","v":6.7269212884583069},"Résistance cathode (Ohm) à 350µS/cm",{"$f":"IF(D19=B100,F100,IF(D19=B101,F101,IF(D19=B102,F102,IF(D19=B103,F103,IF(D19=B104,F104,IF(D19=B105,F105,IF(D19=B106,F106,IF(D19=B107,F107,\"X\"))))))))","v":6.7269212884583069}]
[null,"Résistance ambiante Anode (Ohm)",{"$f":"(C32*350)/C31","v":298.56742142481903},"Résistance ambiante Anode (Ohm)",{"$f":"(E32*350)/E31","v":3.9640108073198252}]
[null,"Résistance ambiante équivalente  2 Anodes arrangées (Ohm)",{"$f":"C34/2","v":149.28371071240952},"Résistance ambiante équivalente  2 Anodes arrangées (Ohm)",{"$f":"E34/2","v":1.9820054036599126}]
[null,"Résistance ambiante Cathode (Ohm)",{"$f":"(C33*350)/C31","v":66.229105850509953},"Résistance ambiante Cathode (Ohm)",{"$f":"(E33*350)/E31","v":0.87930856654652589}]
[null,"Résistance équivalente Totale (Ohm)",{"$f":"C35+C36","v":215.51281656291945},"Résistance équivalente Totale (Ohm)",{"$f":"E35+E36","v":2.8613139702064387}]
[null,"Tension moyenne appliquée à l'Anode (V)",{"$f":"B5*A14","v":195},null,{"$f":"B5*B14","v":195}]
[null,null," Tension moyenne à REGLER sur l'Appareil (V) "]
[null,null,"Minimum","Maximum"]
[null,null,{"$f":"C38*($C$37/$C$34)","v":140.75547502543384},{"$f":"E38*($E$37/$E$34)","v":140.75547502543384}]
[null,"Compatible (oui/non)",{"$f":"IF(B22<C41, \"OUI\", IF(B22=C41, \"OUI\", \"NON\"))","v":"OUI"},{"$f":"IF(C22>D41, \"OUI\", IF(C22=D41, \"OUI\", \"NON\"))","v":"OUI"}]
[null,null,"Puissance de sortie requise (W)"]
[null,null,"Minimum","Maximum"]
[null,null,{"$f":"(C41^2/C37)","v":91.930048827751918},{"$f":"(D41^2/E37)","v":6924.1278503267922}]
[null,"Compatible (oui/non)",{"$f":"IF(D22>C45, \"OUI\", IF(D22=C45, \"OUI\", \"NON\"))","v":"OUI"},{"$f":"IF(D22>D45, \"OUI\", IF(D22=D45, \"OUI\", \"NON\"))","v":"NON"}]
[]
[]
[null,null,"Retour au choix du type d'appareil"]
[]
[null,null,"Retour à l'Accueil"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Tableaux des résistances des cathodes et des anodes"]
["Taille des Cathodes et la Résistance Equivalente mesurée à une conductivité ambiante de 350 µS.cm-1"]
["Référence Cathode","Type de Cathode","Dimension 1 cm)","Dimension 2 (cm)","Epaisseur du cordon/ Taille de la Maille (mm)","Résistance mesurée en Ω"]
["P","Cathode Héron Dream Electronique","4 tresses de 850 *10 sur une tige de métal",null,null,6.7269212884583069]
["R","Cathode Martin Pêcheur Dream Electronique",null,null,3,33.038083021941517]
["S","Cathode  Cuivre ELT60 II Hans Grassl",210,15,3,19.490708303307116]
["T","Cathode INOX LR-24 Smith Root",110,null,5,32.320365085792105]
["A","Bande de Cuivre 75*2,5 cm",75,2.5,3,48]
["B","Bande de Cuivre 150*2,5 cm",150,2.5,3,31]
["C","Bande de Cuivre 300*2,5 cm",300,2.5,3,20]
["H","Cathode cuivre EL63II 5 mètres",500,2.5,null,15.557027781685669]
["D","Maille d'Acier",25,25,13,49]
["E","Maille d'Acier",50,50,13,27]
["F","Maille d'Acier",75,75,13,19]
["G","Maille d'Aluminium expansé",60,55,25.4,26]
["H","Maille d'Aluminium perforé",29,39,null,35]
["I","Maille d'Aluminium perforé",16,17,null,60]
["J","Plaque d'Aluminium épaisse de 2 mm",30,41,null,34]
["K","Tôle perforée en Acier Inoxydable",50,50,6,21]
["L","Treillis d'Acier soudé",29,40,25.4,34]
["M","Treillis d'Acier soudé",17,17,25.4,64]
["N","Cable inox",110,null,5,40]
["O","8 tresses de cuivre de 90*1 soudées sur une barre en cuivre",null,null,3,20]
["Résistances équivalentes Anodes pour une conductivité ambiante de 350 µS.cm-1"]
["Type d'anode","Résistance mesurée en Ω"]
["Anode Martin Pêcheur (Dream Electronique) 35 cm aluminium",30.996190228711924,"Si l'anode n'est pas dans la liste ci-contre :"]
["Anode  LR-24 (Smith Root) 28 cm aluminium",37.093261309907561]
["Anode ELT60II (Hans Grassl) 40 cm inox",27.562744722895957,"Diamètre anode Da  (mm) ="]
["Anode EL63II (Hans Grassl) 30 cm inox",31.019777707914521]
["Anode INOX 20 cm",41.424312990970819,"Résistance anode Ra (Ohm) à 350µS/cm"]
["Anode INOX 30 cm",37.6437665278483,null,"(Beaumont et al., 2005)"]
["Anode INOX 40 cm",30.325632777771425]
["Anode INOX 50 cm",25.347999778481856]
["Anode canne anglaise 36 cm de long inox",30.558181906149095]