{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Conso"],"not_rendered":{"charts":1,"images":0,"macros":0,"external_links":1,"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":"Conso","index":0,"n_rows":108,"n_cols":21,"rows_kept":108,"cut":false,"hidden":false,"merged":[[3,1,3,7],[10,3,10,4],[13,1,13,7],[45,1,45,6]]}
[]
["La question ici est de savoir combien de temps on doit faire tourner le moteur diesel pour équilibrer"]
[]
[1,"Paramètres de votre pack batteries"]
[null,null,"Voltage","Capacité théorique","Nbre de packs",null,null,"Energie utilisable"]
[null,null,"(volts)","(Ah)",null,null,null,"(en watts heure)",null,{"$f":"0.6*0.72*0.95","v":0.41039999999999999}]
[null,"Batteries plomb",12,100,5,null,null,{"$f":"C7*D7*E7*0.6*0.75*0.95","v":2565},1,"L'énergie utilisable tient compte des déchéances batterie"]
[null,"Batteries lithium",12,100,0,null,null,{"$f":"D8*E8*0.8*0.925*C8","v":0},{"$f":"0.6*0.75*0.95","v":0.42749999999999994}]
[null,"Total",null,{"$f":"IF(E8<>0,SUM(D7:D8),D7)","v":100},{"$f":"SUM(E7:E8)","v":5},null,null,{"$f":"SUM(H7:H8)","v":2565}]
[]
[null,"Adéquation du parc à la consommation",null,{"$f":"IF(H9>F104,\"Parc équilibré\",\"Parc déséquilibré\")","v":"Parc équilibré"},null,null,null,null,2,"Compte tenu de 1) la simple comparaison de la conso (8) avec la production (7) permet de \nsavoir si le parc est équilibré ou non"]
[]
[]
[2,"Paramètres de votre production d'énergie"]
["2.1","Alternateur",null,null,null,null,null,"Puissance délivrée"]
[null,"Vitesse de rotation moteur (en tr/min)",1200,1500,1800,2000,2200,"(en watts)"]
[null,"I1 Intensité (A)",null,null,40,null,null,{"$f":"SUM(C17:G17)*12","v":480}]
[null,"I2 Intensité (A)",null,null,40,null,null,{"$f":"SUM(C18:G18)*12","v":480}]
[null,null,"Indiquer une seule valeur d'intensité par producteur: celle qui correspond au régime de rotation choisi"]
[]
["2.2","Pile à combustible",null,null,null,null,null,"Puissance délivrée"]
[null,null,"Qté","Puissance",null,null,null,"(en watts)"]
[null,null,null,"(en watts)"]
[null,null,0,40,null,null,null,{"$f":"C24*D24","v":0}]
[]
["2.3","Panneaux solaires","Surface","Puissance au m2","Rendement",null,null,"Puissance délivrée"]
[null,null,"(en m2)","(en watts)",null,null,null,"(en watts)"]
[null,null,{"$f":"3*1+1*2","v":5},160,0.42,null,null,{"$f":"C28*D28*E28","v":336},3,"Le rendement de 0,5 est arbitraire en prend en considération "]
[]
["2.4","Eolienne",null,null,null,null,null,"Puissance délivrée"]
[null,"Vitesse du Vent (en kts)",10,15,20,25,30,"(en watts)"]
[1,"Aerogen4",12,32,52,78,102,{"$f":"IF(B$38=1,(C32*0.7+D32*0.2+E32*0.05+F32*0.04+G32*0.01)*0.7,0)","v":15.077999999999998},4,"La puissance délivrée tient compte d'une distribution statistique des vents"]
[2,"aerogen6",30,90,120,180,240,{"$f":"IF(B$38=2,(C33*0.8+D33*0.1+E33*0.05+F33*0.04+G33*0.01)*0.7,0)","v":0}]
[3,"Air breeze marine",20,95,172,200,200,{"$f":"IF(B$38=3,(C34*0.8+D34*0.1+E34*0.05+F34*0.04+G34*0.01)*0.7,0)","v":0}]
[4,"Rutland914",12,54,100,168,186,{"$f":"IF(B$38=4,(C35*0.8+D35*0.1+E35*0.05+F35*0.04+G35*0.01)*0.7,0)","v":0}]
[5,"S300",40,80,150,220,300,{"$f":"IF(B$38=5,(C36*0.8+D36*0.1+E36*0.05+F36*0.04+G36*0.01)*0.7,0)","v":0}]
[6,"Superwind 350",12,70,180,350,250,{"$f":"IF(B$38=6,(C37*0.8+D37*0.1+E37*0.05+F37*0.04+G37*0.01)*0.7,0)","v":0}]
[null,1]
["2.5","Hydrogénérateur",null,null,null,null,null,"Puissance délivrée"]
[null,"vitesse du navire (en kts)",3,5,6,7,8,"(en watts)"]
[1,"Intensité (A)",0.6,3,5,6,7,{"$f":"IF(B43=1,(C41*0.05+D41*0.15+E41*0.7+F41*0.1+G41*0)*12,0)","v":0},5,"La puissance délivrée tient compte d'une distribution statistique de la vitesse du voilier"]
[2,"watt and sea",1.5,5,10,12,16,{"$f":"IF(B43=2,(C42*0.15+D42*0.15+E42*0.6+F42*0.1+G42*0)*12,0)","v":0}]
[null,0]
[]
[]
[3,"Production / Consommation "]
[null,null,"Puissance","Intensité","Tps Utilisation","Production / Conso","Production / Conso"]
[null,null,null,null,"(en 24 heures)","(sur 24 heures)","(sur 24 heures)"]
[null,null,"(Watts)","(A)","(en dixième d'Heures)","Wh","Ah"]
[null,null,null,null,null,null,null,"watt / 100W"]
[null,"Panneaux solaires",{"$f":"H28","v":336},{"$f":"C51/12","v":28},6,{"$f":"C51*E51","v":2016},{"$f":"D51*E51","v":168},{"$f":"G51/C28","v":33.6}]
[null,"Pile à combustible",{"$f":"H24","v":0},{"$f":"C52/12","v":0},12,{"$f":"C52*E52","v":0},{"$f":"D52*E52","v":0},"a 15 kts"]
[null,"Eolienne",{"$f":"SUM(H32:H37)","v":15.077999999999998},{"$f":"C53/12","v":1.2564999999999997},24,{"$f":"C53*E53","v":361.87199999999996},{"$f":"D53*E53","v":30.155999999999992},{"$f":"80/12*24","v":160}]
[null,"Hydrogénérateur",{"$f":"SUM(H41:H42)","v":0},{"$f":"C54/12","v":0},24,{"$f":"C54*E54","v":0},{"$f":"D54*E54","v":0}]
[null,"Alternateur moteur",{"$f":"H17+15","v":495},{"$f":"C55/12","v":41.25},{"$f":"IF((G106)>0,\"Bilan équilibré\",IF((D11=\"Parc équilibré\"),INT(ABS(G106/D55)+1),INT(ABS(G106/D55)+3)))","v":"Bilan équilibré"},null,null,null,6,"Le temps de mise en marche du moteur tient compte d'un temps minimum nécessaire de recharge \ndes batteries et tient compte du fait que la parc de batterie (2) équilibre ou non la consommation (8)"]
[null,"Production totale hors moteur",null,null,null,{"$f":"SUM(F51:F54)","v":2377.8719999999998},{"$f":"SUM(G51:G54)","v":198.15600000000001},null,7]
[null,"Eclairage cabine"]
[null,"Eclairage cabine avant plafonnier",3,3,1,{"$f":"C58*E58","v":3},{"$f":"D58*E58","v":3},{"$f":"G58/G$104","v":1.5842560157721487E-2}]
[null,"Eclairage cabine avant lecteur",3,{"$f":"C59/12","v":0.25},1,{"$f":"C59*E59","v":3},{"$f":"D59*E59","v":0.25},{"$f":"G59/G$104","v":1.3202133464767906E-3}]
[null,"Eclairage salle d'eau plafonnier",3,{"$f":"C60/12","v":0.25},1,{"$f":"C60*E60","v":3},{"$f":"D60*E60","v":0.25},{"$f":"G60/G$104","v":1.3202133464767906E-3}]
[null,"Eclairage salle d'eau tube",3,{"$f":"C61/12","v":0.25},1,{"$f":"C61*E61","v":3},{"$f":"D61*E61","v":0.25},{"$f":"G61/G$104","v":1.3202133464767906E-3}]
[]
[null,"Eclairage carré"]
[null,"Plafonniers carré",3,{"$f":"C64/12","v":0.25},2,{"$f":"C64*E64","v":6},{"$f":"D64*E64","v":0.5},{"$f":"G64/G$104","v":2.6404266929535812E-3}]
[null,"Plafonnier cuisine",3,{"$f":"C65/12","v":0.25},2,{"$f":"C65*E65","v":6},{"$f":"D65*E65","v":0.5},{"$f":"G65/G$104","v":2.6404266929535812E-3}]
[null,"Plafonnier table à carte",3,{"$f":"C66/12","v":0.25},4,{"$f":"C66*E66","v":12},{"$f":"D66*E66","v":1},{"$f":"G66/G$104","v":5.2808533859071624E-3}]
[null,"Lecteur de carte",3,{"$f":"C67/12","v":0.25},1,{"$f":"C67*E67","v":3},{"$f":"D67*E67","v":0.25},{"$f":"G67/G$104","v":1.3202133464767906E-3}]
[null,null,3,{"$f":"C68/12","v":0.25}]
[null,"Cabine arrière tribord"]
[null,"Plafonnier",3,{"$f":"C70/12","v":0.25},1,{"$f":"C70*E70","v":3},{"$f":"D70*E70","v":0.25},{"$f":"G70/G$104","v":1.3202133464767906E-3}]
[null,"Lecteur",3,{"$f":"C71/12","v":0.25},1,{"$f":"C71*E71","v":3},{"$f":"D71*E71","v":0.25},{"$f":"G71/G$104","v":1.3202133464767906E-3}]
[]
[null,"Cabine arrière babord"]
[null,"Plafonnier",3,{"$f":"C74/12","v":0.25},1,{"$f":"C74*E74","v":3},{"$f":"D74*E74","v":0.25},{"$f":"G74/G$104","v":1.3202133464767906E-3}]
[null,"Lecteur",3,{"$f":"C75/12","v":0.25},1,{"$f":"C75*E75","v":3},{"$f":"D75*E75","v":0.25},{"$f":"G75/G$104","v":1.3202133464767906E-3}]
[null,"Sous Total Eclairage",{"$f":"SUM(C58:C75)","v":39},{"$f":"SUM(D58:D75)","v":6},null,{"$f":"SUM(F58:F75)","v":51},{"$f":"SUM(G58:G75)","v":7},{"$f":"SUM(H58:H75)","v":3.6965973701350151E-2},null,null,null,null,null,null,null,null,null,null,null,"Eclairage",{"$f":"H76","v":3.6965973701350151E-2}]
[null,"Feux de navigation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Feux",{"$f":"H83","v":2.5242479184636235E-2}]
[null,"Tricolore",2.2799999999999998,{"$f":"C78/12","v":0.18999999999999997},12,{"$f":"C78*E78","v":27.36},{"$f":"D78*E78","v":2.2799999999999998},{"$f":"G78/G$104","v":1.2040345719868329E-2},null,null,null,null,null,null,null,null,null,null,null,"Confort",{"$f":"H90","v":0.22751676670950025}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Com",{"$f":"H94","v":3.8022144378531568E-2}]
[null,"Feu de pont",50,{"$f":"C80/12","v":4.166666666666667},0.6,{"$f":"C80*E80","v":30},{"$f":"D80*E80","v":2.5},{"$f":"G80/G$104","v":1.3202133464767906E-2},null,null,null,null,null,null,null,null,null,null,null,"Nav",{"$f":"H102","v":0.67225263602598173}]
[]
[null,"Feu de mouillage",2.5,{"$f":"C82/12","v":0.20833333333333334},0,{"$f":"C82*E82","v":0},{"$f":"D82*E82","v":0},{"$f":"G82/G$104","v":0}]
[null,"Sous Total Feux",null,null,null,{"$f":"SUM(F78:F82)","v":57.36},{"$f":"SUM(G78:G82)","v":4.7799999999999994},{"$f":"SUM(H78:H82)","v":2.5242479184636235E-2}]
[null,"Confort"]
[null,"Pompe évacuation salle d'eau",120,{"$f":"C85/12","v":10},0.1,{"$f":"C85*E85","v":12},{"$f":"D85*E85","v":1},{"$f":"G85/G$104","v":5.2808533859071624E-3}]
[null,"Réfrigérateur",40,{"$f":"C86/12","v":3.3333333333333335},12,{"$f":"C86*E86","v":480},{"$f":"D86*E86","v":40},{"$f":"G86/G$104","v":0.2112341354362865}]
[null,"Auto radio",15,{"$f":"C87/12","v":1.25},0,{"$f":"C87*E87","v":0},{"$f":"D87*E87","v":0},{"$f":"G87/G$104","v":0}]
[null,"Pompe de pression eau douce",100,{"$f":"C88/12","v":8.3333333333333339},0.25,{"$f":"C88*E88","v":25},{"$f":"D88*E88","v":2.0833333333333335},{"$f":"G88/G$104","v":1.1001777887306588E-2}]
[null,"Désalinisateur",{"$f":"38*12","v":456},{"$f":"C89/12","v":38},0,{"$f":"C89*E89","v":0},{"$f":"D89*E89","v":0},{"$f":"G89/G$104","v":0}]
[null,"Sous Total Confort",null,null,null,{"$f":"SUM(F85:F89)","v":517},{"$f":"SUM(G85:G89)","v":43.083333333333336},{"$f":"SUM(H85:H89)","v":0.22751676670950025}]
[null,"Communications"]
[null,"VHF (mode veille)",3.6,{"$f":"C92/12","v":0.3},24,{"$f":"C92*E92","v":86.4},{"$f":"D92*E92","v":7.1999999999999993},{"$f":"G92/G$104","v":3.8022144378531568E-2}]
[null,"Iridium (charge)"]
[null,"Sous Total Communications",null,null,null,{"$f":"SUM(F92:F93)","v":86.4},{"$f":"SUM(G92:G93)","v":7.1999999999999993},{"$f":"SUM(H92:H93)","v":3.8022144378531568E-2}]
[null,"Navigation"]
[null,"Radar",{"$f":"(8*0.8+38*0.2)*1+(40*1)*0","v":14},{"$f":"C96/12","v":1.1666666666666667},12,{"$f":"C96*E96","v":168},{"$f":"D96*E96","v":14},{"$f":"G96/G$104","v":7.3931947402700274E-2}]
[null,"Plotter",10,0.83333333333333337,0,0,0,0]
[null,"Electronique divers AIS, Multiplex",5,0.41666666666666669,24,120,10,5.2808533859071624E-2]
[null,"Cartographie PC",17,1.4166666666666667,6,102,8.5,4.4887253780210877E-2]
[null,"Instruments de nav",2.4,0.19999999999999998,24,57.599999999999994,4.8,2.5348096252354377E-2]
[null,"Pilote automatique",45,3.75,24,1080,90,0.47527680473164463]
[null,"Sous Total Navigation",null,{"$f":"SUM(D96:D101)","v":7.7833333333333332},null,{"$f":"SUM(F97:F101)","v":1359.6},{"$f":"SUM(G96:G101)","v":127.3},{"$f":"SUM(H96:H101)","v":0.67225263602598173}]
[]
[4,"Consommation totale",null,null,null,{"$f":"SUM(F58:F101)-F94-F90-F83-F76","v":2239.3599999999997},{"$f":"SUM(G58:G101)-G94-G90-G83-G76","v":189.36333333333334}]
[]
[5,"Bilan électrique",null,null,null,{"$f":"F56-F104","v":138.51200000000017},{"$f":"G56-G104","v":8.792666666666662},"be v3"]
[]
[null,null,null,null,null,{"$f":"SUM(F58:F101)-F94-F90-F83-F76-F102","v":879.75999999999976},{"$f":"SUM(G58:G101)-G94-G90-G83-G76-G102","v":62.063333333333347}]