{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["To_Do","Export","Données d'entrée","Table ECS","Guide choix","Calcul2","TempVPM_W","Offre"],"not_rendered":{"charts":1,"images":14,"macros":1,"external_links":0,"defined_names":27,"comments":1,"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":"To_Do","index":0,"n_rows":24,"n_cols":12,"rows_kept":24,"cut":false,"hidden":true,"merged":[]}
["Date","Version VGF","Feuille","Modification faite / à faire",0.25,0.5,0.75,1,"Date réalisé à 100%","Date réalisé à 100%  par qui","Réponse ou commentaire","Non du fichier"]
["2014-08-01","Outil d'aide à la détermination du système d'ECS-2014-07-31_2.xlsx","Calcul2","Contrôler les valeur de cellule G57:J63","x","x","x","x","2014-08-28","CDS","Données du Guide collectifs"]
[null,null,"Calcul2","Calculer les valeurs des cellules D57:F57","x","x","x","x","2014-08-28","CDS","Données du Guide collectifs"]
[null,null,"Calcul2","Puissance minimum du générateur pour soutirage 60°C\nréponse D90 D102 D114 font référence à la puissance de l'échangeur. Ne faudrait il pas faire référence à la puissance de transition ligne 76","x","x","x","x","2014-08-01","GM"]
[null,null,"Calcul2","Puissance minimum du générateur réponse D159 font référence à la puissance de semi accumulé. Ne faudrait il pas faire référence à la puissance de transition ligne 148","x","x","x","x","2014-08-01","GM"]
[null,null,"Table ","restriction de la liste [type_bat] à logement collectif et hôtellerie","x","x","x","x","2014-08-01","GM","phase 1 de l'outil"]
[null,null,null,"confirmation logement collectif seul pour la réunion prescrition","x","x","x","x","2014-09-09","CDS"]
[null,null,"Calcul2","Vérifier les formules avec les autres typologie de projet"]
[null,null,"Données entrée","Brider les solutions avec comme message\" Pour ce type d'installation qui nécessite un besoin élévé en ECS, merci de vous rapprocher du commercial de votre secteur\""]
[null,null,"Calcul2","Points avec Tony F concernant les données ECS","x",null,null,null,null,null,"Vu avec Tony, il relance pour avoir l'ensemble des données comme celle reçu en fin juillet"]
[null,null,null,"Formules de Tony et outils sur la chute des puissances entre SI/SA - Controler les puissances"]
[null,"2014-09-04","Calcul2","Vsu = 0,8 x V ballon pour calcul PSA (VIHR)","x","x","x","x","2014-09-04","GM"]
[null,null,"Calcul2","Contrôle si Psa est bien > à equivalence de rechauffage < à 8 h modifier par Contrôle si Psa ou PSI  est bien > à equivalence de rechauffage < à 8 h ","x","x","x","x","2014-09-04","GM"]
[null,null,"Calcul2","=SI($D$159<>FAUX;TempVPM_W!$B$34;\"\") reectification du renvoie ","x","x","x","x","2014-09-09","GM"]
["2014-09-09","2014-09-09","Calcul2","ajout des plages nommées pour module ECS\nVpm\nTpm\nVph\nTph\ns","x","x","x","x","2014-09-09","ES","Transparent pour l'outil ECS"]
["2014-09-09","2014-09-09","Calcul2","insertion cellules W45:AK45 pour coef simultanéité","x","x","x","x","2014-09-09","ES"]
["2014-09-09","2014-09-09","table ECS","onglet renommé était table","x","x","x","x","2014-09-09","ES","Transparent pour l'outil ECS"]
["2014-09-11","2014-09-11","Données entrée","Modification de la version de l'outil avec passage au mois de septembre","X","X","X","X","2014-09-11","CDS"]
["2014-09-11","2014-09-11","Données entrée","Passage des résultats en arrière plan pour cocher le résultat souhaité","X","X","X","X","2014-09-11","CDS"]
["2014-09-18","2014-09-18","Données entrée","Afficher le nombre de logement total en dessous du tableau typologie"]
["2014-09-18","2014-09-18","Données entrée","Faire des bulles d'aides comme dans l'outil chaufferie pour expliquer le couple puissance / volume des ballons uniSTOR & allSTOR"]
["2014-10-30","2014-10-30","Données entrée","Suite à la remarque de Guy concernant la température moyenne eau froide, il est préciser \"température moyenne mensuelle la plus faible\"","X","X","X","X","2014-10-30"]
["2014-10-30","2014-10-30","Guide de choix","Correction de la faute d'orthographe sur explication allSTOR","X","X","X","X","2014-10-30"]
["2014-10-30","2014-10-30","Données entrée","Empecher la saisie de texte lorsqu'on attend un entier dans le nb de logement","X","X","X","X","2014-10-30"]

{"sheet":"Export","index":1,"n_rows":77,"n_cols":9,"rows_kept":77,"cut":false,"hidden":true,"merged":[]}
["description","ref","Qté","ligne active","nombre de ligne active",null,null,"Export1",{"$f":"\"'Export'!A2:A\"&N","v":"'Export'!A2:A2"}]
[null,{"$f":"Offre!B68","v":"0010003078"},{"$f":"Offre!C68","v":1},{"$f":"IF(OR(C2=0,C2=\"\"),0,1)","v":1},{"$f":"MAX(2,D2:D77)","v":2},null,null,"Export2",{"$f":"\"'Export'!B2:B\"&N","v":"'Export'!B2:B2"}]
[null,{"$f":"Offre!B69","v":""},{"$f":"Offre!C69","v":""},{"$f":"IF(OR(C3=0,C3=\"\"),0,1)","v":0},null,null,null,"Export3",{"$f":"\"'Export'!C2:C\"&N","v":"'Export'!C2:C2"}]
[null,{"$f":"Offre!B70","v":""},{"$f":"Offre!C70","v":""},0]
[null,{"$f":"Offre!B71","v":""},{"$f":"Offre!C71","v":""},0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,{"$f":"IF(OR(C67=0,C67=\"\"),0,1)","v":0}]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]

{"sheet":"Données d'entrée","index":2,"n_rows":114,"n_cols":18,"rows_kept":114,"cut":false,"hidden":false,"merged":[[58,1,58,5],[56,1,56,5],[23,1,23,11],[25,1,25,5],[25,7,25,11],[42,1,42,5],[40,1,40,5],[31,1,31,5],[26,1,26,5],[27,1,27,5],[28,1,28,5],[29,1,29,5],[30,1,30,5],[55,7,55,11],[57,1,57,5],[56,7,56,11],[33,1,33,5],[51,7,51,11],[53,1,53,5],[54,1,54,5],[51,1,51,5],[52,1,52,5],[46,7,46,11],[45,1,45,5],[48,1,48,5],[47,7,47,11],[34,1,34,5],[41,1,41,5],[43,1,43,5],[35,1,35,5],[44,1,44,5],[46,1,46,5],[49,1,49,5],[48,7,48,11],[55,1,55,5],[50,1,50,5],[47,1,47,5],[20,4,20,5],[8,2,8,5],[8,7,8,11],[9,2,9,5],[9,7,9,11],[10,2,10,5],[10,9,10,11],[12,2,12,5],[12,7,12,11],[13,2,13,5],[13,7,13,11],[14,2,14,5],[14,7,14,11],[15,4,15,5],[15,9,15,11],[20,9,20,11],[17,2,17,5],[17,7,17,11],[18,2,18,5],[18,7,18,11],[19,2,19,5],[19,7,19,11]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,1,"Cellule liée au choix de la solution"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,"Dossier",null,null,null,null,"Référence chantier",null,null,null,null,null,null,1,1]
[null,"N° Ref :",null,null,null,null,"Nom :",null,null,null,null,null,null,null,1,1]
[null,"Date :",{"$f":"TODAY()","v":"2020-12-11"},null,null,null,"Code postal :","59490","Ville :","VILLENEUVE D'ASQ",null,null,null,null,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1]
[null,null,"Bureau d'étude",null,null,null,null,"Installateur",null,null,null,null,null,null,1,1]
[null,"Société :",null,null,null,null,"Société :",null,null,null,null,null,null,null,1,1]
[null,"Nom :",null,null,null,null,"Nom :",null,null,null,null,null,null,null,1,1]
[null,"Code postal :",null,"Ville :",null,null,"Code postal :",null,"Ville :",null,null,null,null,null,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1]
[null,null,"Maître d'ouvrage",null,null,null,null,"Distributeur",null,null,null,null,null,null,1,1]
[null,"Société :",null,null,null,null,"Société :",null,null,null,null,null,null,null,1,1]
[null,"Nom :",null,null,null,null,"Nom :",null,null,null,null,null,null,null,1,1]
[null,"Code postal :",null,"Ville :",null,null,"Code postal :",null,"Ville :",null,null,null,null,null,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,"Définition du Projet",null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,"Commentaires",null,null,null,null,1]
[null,{"$f":"Calcul2!B44","v":"Profils de l'établissement"},null,null,null,null,"Logements collectifs",{"$f":"IF(G26=\"NON\",\"La production de chaleur ne sera pas chiffrée\",\"\")","v":""},{"$f":"IF(G26=\"NON\",\"La production de chaleur ne sera pas chiffrée\",\"\")","v":""},null,null,null,null,null,1,{"$f":"MATCH(G26,type_bat,0)","v":1}]
[null,{"$f":"Calcul2!B176","v":"Logements collectifs"},null,null,null,null,{"$f":"Calcul2!C176","v":"Oui"},null,null,null,null,null,null,null,{"$f":"IF(P27=$P$26,1,0)","v":0},0]
[null,{"$f":"Calcul2!B177","v":"Nombre de logements de type 1 ou studio"},null,null,null,null,11,null,null,null,null,null,null,null,{"$f":"IF(P28=$P$26,1,0)","v":1},1]
[null,{"$f":"Calcul2!B178","v":"Nombre de logements de type 2"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(P29=$P$26,1,0)","v":1},1]
[null,{"$f":"Calcul2!B179","v":"Nombre de logements de type 3"},null,null,null,null,null,null,null,null,null,null,null,null,1,1]
[null,{"$f":"Calcul2!B180","v":"Nombre de logements de type 4"},null,null,null,null,null,null,null,null,null,null,null,null,1,1]
[null,{"$f":"Calcul2!B181","v":"Nombre de logements de type 5"},null,null,null,null,null,null,null,null,null,null,null,null,1,1]
[null,{"$f":"Calcul2!B184","v":"Nombre total de logements"},null,null,null,null,{"$f":"Calcul2!D184","v":11},null,null,null,null,null,null,null,1,1]
[null,{"$f":"Calcul2!B182","v":"Consommation journalière"},null,null,null,null,{"$f":"Calcul2!C183","v":550},null,null,null,null,null,null,null,1,1]
[null,{"$f":"Calcul2!B194","v":"Hôtellerie"},null,null,null,null,{"$f":"Calcul2!C194","v":"Oui"},null,null,null,null,null,null,null,0,0]
[null,"Catégorie",null,null,null,null,"Hôtel 1 *",null,null,null,null,null,null,null,{"$f":"IF(P36=$P$26,1,0)","v":0},2]
[null,"Nombre de chambres",null,null,null,null,50,null,null,null,null,null,null,null,{"$f":"IF(P37=$P$26,1,0)","v":0},2]
[null,"Hotel de sport d'hiver, de seminaire ou de bord de mer ?",null,null,null,null,"Oui",null,null,null,null,null,null,null,{"$f":"IF(P38=$P$26,1,0)","v":0},2]
[null,"Coefficient de simultanéité",null,null,null,null,{"$f":"Calcul2!C201","v":0.8},null,null,null,null,null,null,null,0,2]
[null,"Choix du coefficient de simultanéité, correction manuelle",null,null,null,null,null,null,null,null,null,null,null,null,0,2]
[null,{"$f":"Calcul2!B197","v":"Consommation journalière"},null,null,null,null,{"$f":"IF(ISERROR(Calcul2!C203)=TRUE,\"Erreur de saisie\",Calcul2!C203)","v":3000},null,null,null,null,null,null,null,0,2]
[null,{"$f":"Calcul2!A212","v":"Camping"},null,null,null,null,{"$f":"Calcul2!C214","v":"Oui"},null,null,null,null,null,null,null,0,0]
[null,{"$f":"Calcul2!B215","v":"Sanitaire collectif + lavage vaisselle"},null,null,null,null,5,null,null,null,null,null,null,null,0,3]
[null,{"$f":"Calcul2!B216","v":"Consommation journalière"},null,null,null,null,{"$f":"Calcul2!C217","v":300},{"$f":"Calcul2!D217","v":"Litres à 60°C "},null,null,null,null,null,null,0,3]
[null,{"$f":"Calcul2!B227","v":"Restauration"},null,null,null,null,{"$f":"Calcul2!C227","v":"Oui"},null,null,null,null,null,null,null,0,0]
[null,"Type d'etablisement de restauration",null,null,null,null,"Traditionnelle (50 à 150 repas par jour)",null,null,null,null,null,null,null,0,4]
[null,"Nombre de repas",null,null,null,null,10,null,null,null,null,null,null,null,0,4]
[null,{"$f":"Calcul2!B230","v":"Consommation journalière"},null,null,null,null,{"$f":"Calcul2!C231","v":120},{"$f":"Calcul2!D231","v":"Litres à 60°C "},null,null,null,null,null,null,0,4]
[null,{"$f":"Calcul2!B241","v":"Santé"},null,null,null,null,{"$f":"Calcul2!C241","v":"Oui"},{"$f":"IF(G50=\"NON\",\"Le préchauffage solaire ne sera pas chiffré\",\"\")","v":""},{"$f":"IF(G50=\"NON\",\"Le préchauffage solaire ne sera pas chiffré\",\"\")","v":""},null,null,null,null,null,0,0]
[null,"Type d'etablisement de santé",null,null,null,null,"Maison de retraite",null,null,null,null,null,null,null,0,5]
[null,"Nombre de lits",null,null,null,null,25,null,null,null,null,null,null,null,0,5]
[null,{"$f":"Calcul2!B244","v":"Consommation journalière"},null,null,null,null,{"$f":"Calcul2!C245","v":1000},{"$f":"Calcul2!D245","v":"Litres à 60°C "},{"$f":"IF(G53=\"NON\",\"Le préchauffage solaire ne sera pas chiffré\",\"\")","v":""},null,null,null,null,null,0,5]
[null,{"$f":"Calcul2!B255","v":"Internat"},null,null,null,null,{"$f":"Calcul2!C255","v":"Oui"},null,null,null,null,null,null,null,0]
[null,{"$f":"Calcul2!B256","v":"Nombre d'interne"},null,null,null,null,null,null,null,null,null,null,null,null,0,6]
[null,{"$f":"Calcul2!B257","v":"Consommation journalière"},null,null,null,null,{"$f":"Calcul2!C258","v":0},{"$f":"Calcul2!D258","v":"Litres à 60°C "},null,null,null,null,null,null,0,6]
[null,{"$f":"Calcul2!A266","v":"Sport"},null,null,null,null,{"$f":"Calcul2!C268","v":"Oui"},{"$f":"IF(G57=\"NON\",\"La production ECS ne sera pas chiffrée\",\"\")","v":""},{"$f":"IF(G57=\"NON\",\"La production ECS ne sera pas chiffrée\",\"\")","v":""},null,null,null,null,null,0,0]
[null,{"$f":"Calcul2!B269","v":"En salle"},null,null,null,null,null,{"$f":"IF(G58=\"NON\",\"Le préchauffage solaire ne sera pas chiffré\",\"\")","v":""},{"$f":"IF(G58=\"NON\",\"Le préchauffage solaire ne sera pas chiffré\",\"\")","v":""},null,null,null,null,null,0,7]
[null,{"$f":"Calcul2!B270","v":"Vestiaires / Foot / rugby"},null,null,null,null,null,null,null,null,null,null,null,null,0,7]
[null,{"$f":"Calcul2!B271","v":"Consommation journalière"},null,null,null,null,{"$f":"Calcul2!C272","v":0},{"$f":"Calcul2!D272","v":"Litres à 60°C "},null,null,null,null,null,null,0,7]
[null,"Température primaire",null,null,null,null,80,null,null,null,null,null,null,null,1]
[null,"Température de consigne ECS",null,null,null,null,60,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,"Hypothèses (source  AICVF - 2004)                                                      ",null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,"Commentaires",null,null,null,null,1]
[null,"Température moyenne mensuelle la plus faible",null,null,null,null,{"$f":"'Table ECS'!E176","v":5.7},null," suivant la référence chantier renseigné",null,null,null,null,null,1]
[null,{"$f":"B27","v":"Logements collectifs"},null,null,null,null,"Consommation par type de logement",null,null,null,null,null,null,null,{"$f":"IF(P66=$P$26,1,0)","v":0},0]
[null,{"$f":"B28","v":"Nombre de logements de type 1 ou studio"},null,null,null,null,{"$f":"Calcul2!D177","v":50},null,null,null,null,null,null,null,1,1]
[null,{"$f":"B29","v":"Nombre de logements de type 2"},null,null,null,null,{"$f":"Calcul2!D178","v":75},null,null,null,null,null,null,null,1,1]
[null,"Nombre de logements de type 3",null,null,null,null,{"$f":"Calcul2!D179","v":100},null,null,null,null,null,null,null,1,1]
[null,"Nombre de logements de type 4",null,null,null,null,{"$f":"Calcul2!D180","v":150},null,null,null,null,null,null,null,1,1]
[null,"Nombre de logements de type 5",null,null,null,null,{"$f":"Calcul2!D181","v":200},null,null,null,null,null,null,null,1,1]
[null,{"$f":"B35","v":"Hôtellerie"},null,null,null,null,"Consommation par chambre",null,null,null,null,null,null,null,0,0]
[null,"Hotel 1 *",null,null,null,null,{"$f":"'Table ECS'!C189","v":75},{"$f":"'Table ECS'!D189","v":"Litres à 60°C / chambre / jour"},null,null,null,null,null,null,0,2]
[null,"Hotel 2 *",null,null,null,null,{"$f":"'Table ECS'!C190","v":100},{"$f":"'Table ECS'!D190","v":"Litres à 60°C / chambre / jour"},null,null,null,null,null,null,0,2]
[null,"Hotel 3 *",null,null,null,null,{"$f":"'Table ECS'!C191","v":150},{"$f":"'Table ECS'!D191","v":"Litres à 60°C / chambre / jour"},null,null,null,null,null,null,0,2]
[null,"Hotel 4 *",null,null,null,null,{"$f":"'Table ECS'!C192","v":200},{"$f":"'Table ECS'!D192","v":"Litres à 60°C / chambre / jour"},null,null,null,null,null,null,0,2]
[null,{"$f":"B42","v":"Camping"},null,null,null,null,"Consommation par emplacement",null,null,null,null,null,null,null,0,0]
[null,{"$f":"B43","v":"Sanitaire collectif + lavage vaisselle"},null,null,null,null,{"$f":"'Table ECS'!C194","v":60},{"$f":"'Table ECS'!D194","v":"Litres à 60°C / emplacement / jour"},null,null,null,null,null,null,0,3]
[null,{"$f":"B45","v":"Restauration"},null,null,null,null,"Consommation par repas",null,null,null,null,null,null,null,0,0]
[null,{"$f":"B46","v":"Type d'etablisement de restauration"},null,null,null,null,{"$f":"'Table ECS'!C196","v":12},{"$f":"'Table ECS'!D196","v":"Litres à 60°C / repas"},null,null,null,null,null,null,0,4]
[null,{"$f":"B47","v":"Nombre de repas"},null,null,null,null,{"$f":"'Table ECS'!C197","v":5},{"$f":"'Table ECS'!D197","v":"Litres à 60°C / repas"},null,null,null,null,null,null,0,4]
[null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,{"$f":"'Table ECS'!C198","v":1},{"$f":"'Table ECS'!D198","v":"Litres à 60°C / repas"},null,null,null,null,null,null,0,4]
[null,{"$f":"B49","v":"Santé"},null,null,null,null,"Consommation par lit",null,null,null,null,null,null,null,0,0]
[null,{"$f":"B50","v":"Type d'etablisement de santé"},null,null,null,null,{"$f":"'Table ECS'!C200","v":40},{"$f":"'Table ECS'!D200","v":"Litres à 60°C / lit / jour"},null,null,null,null,null,null,0,5]
[null,{"$f":"B51","v":"Nombre de lits"},null,null,null,null,{"$f":"'Table ECS'!C201","v":50},{"$f":"'Table ECS'!D201","v":"Litres à 60°C / lit / jour"},null,null,null,null,null,null,0,5]
[null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,{"$f":"'Table ECS'!C202","v":60},{"$f":"'Table ECS'!D202","v":"Litres à 60°C / lit / jour"},null,null,null,null,null,null,0,5]
[null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,{"$f":"'Table ECS'!C203","v":100},{"$f":"'Table ECS'!D203","v":"Litres à 60°C / lit / jour"},null,null,null,null,null,null,0,5]
[null,{"$f":"B53","v":"Internat"},null,null,null,null,"Consommation par interne",null,null,null,null,null,null,null,0,0]
[null,{"$f":"B54","v":"Nombre d'interne"},null,null,null,null,{"$f":"'Table ECS'!C205","v":40},{"$f":"'Table ECS'!D205","v":"Litres à 60°C / interne/ jour"},null,null,null,null,null,null,0,6]
[null,{"$f":"B56","v":"Sport"},null,null,null,null,"Consommation par pomme de douche?",null,null,null,null,null,null,null,0,0]
[null,{"$f":"B57","v":"En salle"},null,null,null,null,{"$f":"'Table ECS'!C207","v":25},{"$f":"'Table ECS'!D207","v":"Litres à 60°C / personne/ jour"},null,null,null,null,null,null,0,7]
[null,{"$f":"B58","v":"Vestiaires / Foot / rugby"},null,null,null,null,{"$f":"'Table ECS'!C208","v":40},{"$f":"'Table ECS'!D208","v":"Litres à 60°C / personne/ jour"},null,null,null,null,null,null,0,7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,"Couples puissance / volume ballon ECS - Production SI (semi-instantanée) & SA (semi-accumulée)",null,null,null,null,null,null,null,null,null,"Aide",null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,"Couples puissance / volume ballon ECS - Production ECS instantanée",null,null,null,null,null,null,null,null,null,"Aide",null,null,1]
[null,"L'augmentation du stockage d'énergie primaire permet de diminuer la puissance du générateur",null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,{"$f":"Calcul2!AA10","v":"Température de stockage  : 76 °C"},null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,{"$f":"Calcul2!AA11","v":"Module(s) aguaFLOW W : VPM 40/45/2 W"},null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]

{"sheet":"Table ECS","index":3,"n_rows":236,"n_cols":15,"rows_kept":236,"cut":false,"hidden":true,"merged":[]}
[]
[]
["Listes","type_bat","O_N","répartition","type_répartition","profil de puisage"]
[1,{"$f":"Calcul2!A175","v":"Logements collectifs"},"OUI","Journalière","Constante","Par defaut"]
[2,{"$f":"Calcul2!A192","v":"Hôtellerie"},"NON","Mensuelle","Par défaut","personalisé"]
[3,{"$f":"Calcul2!B214","v":"Camping"},null,"Annuelle","Personnalisée"]
[4,{"$f":"Calcul2!A225","v":"Restauration"}]
[5,{"$f":"Calcul2!A239","v":"Santé"}]
[6,{"$f":"Calcul2!A253","v":"Internat"}]
[7,{"$f":"Calcul2!A266","v":"Sport"}]
[]
[]
[]
["Liste","Liste_sante"]
[null,"Maison de retraite"]
[null,"Hôpital"]
[null,"Clinique/Maternité"]
[null,"Foyer pour handicapés"]
[]
["Liste","Liste_sport"]
[null,"Interieur"]
[null,"Vestiaires / Foot / rugby"]
[]
[null,null,"Répartition annelle "]
[null,"logements",null,null,null,"restaurants"]
[null,null,"par défaut *","constante",null,null,"par défaut *","constante","personnalisé"]
[null,"Janvier",1.25,1,null,"Janvier",0.85,1]
[null,"Février",1.2,1,null,"Février",0.78,1]
[null,"Mars",1.1000000000000001,1,null,"Mars",0.77,1]
[null,"Avril",1.05,1,null,"Avril",0.73,1]
[null,"Mai",1,1,null,"Mai",0.78,1]
[null,"Juin",0.8,1,null,"Juin",1.05,1]
[null,"Juillet",0.5,1,null,"Juillet",1.24,1]
[null,"Août",0.6,1,null,"Août",1.25,1]
[null,"Septembre",0.9,1,null,"Septembre",1.28,1]
[null,"Octobre",1.05,1,null,"Octobre",1.28,1]
[null,"Novembre",1.1499999999999999,1,null,"Novembre",1,1]
[null,"Décembre",1.4,1,null,"Décembre",0.99,1]
[]
[null,"logements","Répartition hebdomadaire et journalière"]
[null,null,"semaine","Samedi","Dimanche"]
[null,"de 0h à 1h",0.02,0.06,0.05]
[null,"de 1h à 2h",0.02,0.04,0.05]
[null,"de 2h à 3h",0.01,0.02,0.02]
[null,"de 3h à 4h",0.01,0.02,0.02]
[null,"de 4h à 5h",0.02,0.01,0.02]
[null,"de 5h à 6h",0.2,0.05,0.02]
[null,"de 6h à 7h",1.6,0.35,0.04]
[null,"de 7h à 8h",3.3,1.07,0.36]
[null,"de 8h à 9h",1.8,2.21,1.28]
[null,"de 9h à 10h",1.5,2.59,2.63]
[null,"de 10h à 11h",1.23,2.63,3.53]
[null,"de 11h à 12h",0.9,1.83,2.94]
[null,"de 12h à 13h",1.1000000000000001,1.5,1.74]
[null,"de 13h à 14h",1.42,1.94,1.38]
[null,"de 14h à 15h",0.8,1.72,1.56]
[null,"de 15h à 16h",0.5,1.06,1]
[null,"de 16h à 17h",0.54,0.73,0.74]
[null,"de 17h à 18h",0.85,0.89,0.68]
[null,"de 18h à 19h",1.65,1.38,1.3]
[null,"de 19h à 20h",1.9,1.34,1.59]
[null,"de 20h à 21h",2.25,1.19,1.59]
[null,"de 21h à 22h",1.3,0.6,0.68]
[null,"de 22h à 23h",0.78,0.44,0.59]
[null,"de 23h à 24h",0.3,0.33,0.19]
[null,null,{"$f":"SUM(C42:C65)","v":24.000000000000004},{"$f":"SUM(D42:D65)","v":24},{"$f":"SUM(E42:E65)","v":24}]
["Matrice","DEPARTEMENT","Zone climatique","département","Ville"]
[null,1,"H1c","AIN","Ambérieu"]
[null,2,"H1a","AISNE","Laon"]
[null,3,"H1c","ALLIER","Vichy"]
[null,4,"H2d","ALPES DE HAUTE PROVENCE","Digne"]
[null,5,"H1c","HAUTES ALPES","Embrun"]
[null,6,"H3","ALPES MARITIME","Nice"]
[null,7,"H2d","ARDECHE","Privas"]
[null,8,"H1b","ARDENNES","Charleville Mézières"]
[null,9,"H2c","ARIEGE","Cazaux"]
[null,10,"H1b","AUBE","Troyes"]
[null,11,"H3","AUDE","Carcassonne"]
[null,12,"H2c","AVEYRON","Millau"]
[null,13,"H3","BOUCHES DU RHÔNE","Marseille"]
[null,14,"H1a","CALVADOS","Caen"]
[null,15,"H1c","CANTAL","Aurillac"]
[null,16,"H2b","CHARENTE","Angoulème"]
[null,17,"H2b","CHARENTE MARITIME","La Rochelle"]
[null,18,"H2b","CHER","Bourges"]
[null,19,"H1c","CORREZE","Tulle"]
[null,20,"H3","CORSE","Bastia"]
[null,21,"H1c","CÔTE D'OR","Dijon"]
[null,22,"H2a","CÔTE D'ARMOR","Saint Brieuc"]
[null,23,"H1c","CREUSE ","Guerret"]
[null,24,"H2c","DORDOGNE","Périgueux"]
[null,25,"H1c","DOUBS","Besançon"]
[null,26,"H2d","DRÔME","Montélimar"]
[null,27,"H1a","EURE ","Evreux"]
[null,28,"H1a","EURE ET LOIR","Chartres"]
[null,29,"H2a","FINISTERE","Brest"]
[null,30,"H3","GARD","Nimes"]
[null,31,"H2c","HAUTE GARONNE","Toulouse"]
[null,32,"H2c","GERS","Auch"]
[null,33,"H2c","GIRONDE","Bordeaux"]
[null,34,"H3","HERAULT","Montpellier"]
[null,35,"H2a","ILLE ET VILAINE","Rennes"]
[null,36,"H2b","INDRE","Chateauroux"]
[null,37,"H2b","INDRE ET LOIRE","Tours"]
[null,38,"H1c","ISERE","Grenoble"]
[null,39,"H1c","JURA","Lons le Saunier"]
[null,40,"H2c","LANDES","Mont de Marsan"]
[null,41,"H2b","LOIR ET CHER","Blois"]
[null,42,"H1c","LOIRE","Saint Etienne"]
[null,43,"H1c","HAUTE LOIRE","Le Puy-en-Velay"]
[null,44,"H2b","LOIRE ATLANTIQUE","Nantes"]
[null,45,"H1b","LOIRET","Orléans"]
[null,46,"H2c","LOT","Gourdon"]
[null,47,"H2c","LOT ET GARONNE","Agen"]
[null,48,"H2d","LOZERE","Mende"]
[null,49,"H2b","MAINE ET LOIRE","Angers"]
[null,50,"H2a","MANCHE","Saint Lô"]
[null,51,"H1b","MARNE","Reims"]
[null,52,"H1b","HAUTE MARNE","Langres"]
[null,53,"H2b","MAYENNE","Laval"]
[null,54,"H1b","MEURTHE ET MOSELLE","Nancy"]
[null,55,"H1b","MEURTHE ET MOSELLE","Bar le Duc"]
[null,56,"H2a","MORBIHAN","Vannes"]
[null,57,"H1b","MOSELLE","Metz"]
[null,58,"H1b","NIEVRE","Nevers"]
[null,59,"H1a","NORD","Valenciennes"]
[null,60,"H1a","OISE","Beauvais"]
[null,61,"H1a","ORNE","Alençon"]
[null,62,"H1a","NORD","Arras"]
[null,63,"H1c","PUY DE DOME","Clermont-Fd"]
[null,64,"H2c","PYRENEES ATLANTIQUES","Biarritz"]
[null,65,"H2c","HAUTES PYRENEES","Tarbes"]
[null,66,"H3","PYRENEES ORIENTALES","Perpignan"]
[null,67,"H1b","BAS RHIN","Strasbourg"]
[null,68,"H1b","HAUT RHIN","Mulhouse"]
[null,69,"H1c","RHONE","Lyon"]
[null,70,"H1b","HAUTE SAÔNE","Vesoul"]
[null,71,"H1c","SAÔNE ET LOIRE","Macon"]
[null,72,"H2b","SARTHE","Le Mans"]
[null,73,"H1c","SAVOIE","Chambéry"]
[null,74,"H1c","HAUTE SAVOIE","Annecy"]
[null,75,"H1a","PARIS","Paris"]
[null,76,"H1a","SEINE MARITIME","Rouen"]
[null,77,"H1a","SEINE ET MARNE","Meulin"]
[null,78,"H1a","YVELINES","Saint Quentin"]
[null,79,"H2b","DEUX SEVRES","Niort"]
[null,80,"H1a","SOMME","Amiens"]
[null,81,"H2c","TARN","Albi"]
[null,82,"H2c","TARN ET GARONNE","Montauban"]
[null,83,"H3","VAR","Toulon"]
[null,84,"H2d","VAUCLUSE","Avignon"]
[null,85,"H2b","VENDEE","La Roche sur Yon"]
[null,86,"H2b","VIENNE ","Poitiers"]
[null,87,"H1c","HAUTE VIENNE","Limoges"]
[null,88,"H1b","VOSGES","Epinal"]
[null,89,"H1b","YONNE","Auxerre"]
[null,90,"H1b","TERRITOIRE DE BELFORT","Belfort"]
[null,91,"H1a","ESSONNE","idf"]
[null,92,"H1a","HAUTS DE SEINE","idf"]
[null,93,"H1a","SEINE ST DENIS","idf"]
[null,94,"H1a","VAL DE MARNE","idf"]
[null,95,"H1a","VAL D'OISE","idf"]
[]
[null,null,"Température eau froide (matrice Tef)"]
[null,null,"Janvier","Février","Mars","Avril","Mai","Juin","Juillet","Août","Septembre","Octobre","Novembre","Décembre","Tmin"]
[null,"H1a",5.7,5.7,7,9.1999999999999993,11.8,14,15.3,15.3,14,11.8,9.1999999999999993,7,{"$f":"MIN(C166:N166)","v":5.7}]
[null,"H1b",5.7,5.7,7,9.1999999999999993,11.8,14,15.3,15.3,14,11.8,9.1999999999999993,7,{"$f":"MIN(C167:N167)","v":5.7}]
[null,"H1c",5.7,5.7,7,9.1999999999999993,11.8,14,15.3,15.3,14,11.8,9.1999999999999993,7,5.7]
[null,"H2a",7.2,7.2,8.5,10.7,13.3,15.5,16.8,16.8,15.5,13.3,10.7,8.5,7.2]
[null,"H2b",7.2,7.2,8.5,10.7,13.3,15.5,16.8,16.8,15.5,13.3,10.7,8.5,7.2]
[null,"H2c",7.2,7.2,8.5,10.7,13.3,15.5,16.8,16.8,15.5,13.3,10.7,8.5,7.2]
[null,"H2d",7.2,7.2,8.5,10.7,13.3,15.5,16.8,16.8,15.5,13.3,10.7,8.5,7.2]
[null,"H3",9.6999999999999993,9.6999999999999993,11,13.2,15.8,18,19.3,19.3,18,15.8,13.2,11,9.6999999999999993]
[]
[null,null,"Code postal",{"$f":"'Données d''entrée'!H11","v":"59490"}]
[null,null,"Zone climatique",{"$f":"VLOOKUP(VALUE(LEFT('Données d''entrée'!H11,LEN('Données d''entrée'!H11)-3)),departement,2,FALSE)","v":"H1a"},{"$f":"VLOOKUP(D176,B164:O173,14,FALSE)","v":5.7},"Tmin"]
[]
["Liste","Vol_ballon"]
[null,2000]
[null,1500]
[null,1000]
[null,750]
[null,500]
[null,400]
[null,300]
[]
[null,"Matrice volume ECS / hotel"]
["Matrice","Vol_ECS_Hotel","conso à 60 °C","(source consommation :  AICVF - 2004)"]
[null,"Hôtel 1 *",75,"Litres à 60°C / chambre / jour"]
[null,"Hôtel 2 *",100,"Litres à 60°C / chambre / jour"]
[null,"Hôtel 3 *",150,"Litres à 60°C / chambre / jour"]
[null,"Hôtel 4 *",200,"Litres à 60°C / chambre / jour"]
[null,"Vol_ECS_Camping"]
[null,"Sanitaire collectif + lavage vaisselle",60,"Litres à 60°C / emplacement / jour"]
["Matrice & liste","Vol_ECS_Restauration"]
[null,"Traditionnelle (50 à 150 repas par jour)",12,"Litres à 60°C / repas"]
[null,"Commerciale (500 repas par jour)",5,"Litres à 60°C / repas"]
[null,"Cuisine centrale (5000 repas par jour)",1,"Litres à 60°C / repas"]
[null,"Vol_ECS_Santé"]
[null,"Maison de retraite",40,"Litres à 60°C / lit / jour"]
[null,"Hôpital",50,"Litres à 60°C / lit / jour"]
[null,"Clinique/Maternité",60,"Litres à 60°C / lit / jour"]
[null,"Foyer pour handicapés",100,"Litres à 60°C / lit / jour"]
[null,"Vol_ECS_Internat"]
[null,"Nombre d'interne",40,"Litres à 60°C / interne/ jour"]
[null,"Vol_ECS_Sport"]
[null,"En salle",25,"Litres à 60°C / personne/ jour"]
[null,"Vestiaires / Foot / Rugby",40,"Litres à 60°C / personne/ jour"]
[]
[]
["Liste des T° primaire utilisable","Liste_Tem_Cons"]
[null,{"$f":"IF(Calcul2!$C45<45,\"\",45)","v":45}]
[null,{"$f":"IF(Calcul2!$C$45<50,\"\",50)","v":50}]
[null,{"$f":"IF(Calcul2!$C$45<55,\"\",55)","v":55}]
[null,{"$f":"IF(Calcul2!$C$45<60,\"\",60)","v":60}]
[null,{"$f":"IF(Calcul2!$C$45<65,\"\",65)","v":65}]
[]
["Table VPM W",null,null,null,"aguaFLOW exclusiv VPM 20/25/2 W","aguaFLOW exclusiv VPM 30/35/2 W","aguaFLOW exclusiv VPM 40/45/2 W","Vanne motorisée cascade module VPM W","Support fix. mur 1 VPM W (avec collect.)","Support fix. mur 2 VPM W (avec collect.)","Support fix. mur extens 1 VPM W (collect)","Kit pompe circulation interne pour VPM W","Kit raccord et tube pour pompe externe","nb station sanitaire"]
[null,null,null,null,10014311,10014312,10014313,10015146,10014300,10014301,10014303,10015144,10015145]
[null,1,"VPM 20/25/2 W",1,1,null,null,null,1,null,null,1,1,1]
[null,2,"VPM 30/35/2 W",2,null,1,null,null,1,null,null,1,1,1]
[null,3,"VPM 40/45/2 W",3,null,null,1,null,1,null,null,1,1,1]
[null,4,"2x VPM 20/25/2 W",4,2,null,null,2,null,1,null,2,2,2]
[null,5,"VPM 30/35/2 W + VPM 20/25/2 W",5,1,1,null,2,null,1,null,2,2,2]
[null,6,"2x VPM 30/35/2 W",6,null,2,null,2,null,1,null,2,2,2]
[null,7,"3x VPM 20/25/2 W",7,3,null,null,3,null,1,1,3,3,3]
[null,8,"VPM 30/35/2 W + 2x VPM 20/25/2 W",8,2,1,null,3,null,1,1,3,3,3]
[null,9,"2x VPM 40/45/2 W",9,null,null,2,2,null,1,null,2,2,2]
[null,10,"2x VPM 30/35/2 W + VPM 20/25/2 W",10,1,2,null,3,null,1,1,3,3,3]
[null,11,"3x VPM 30/35/2 W",11,null,3,null,3,null,1,1,3,3,3]
[null,12,"VPM 30/35/2 W + 3x VPM 20/25/2 W",12,3,1,null,4,null,1,2,4,4,4]
[null,13,"2x VPM 30/35/2 W + 2x VPM 20/25/2 W",13,2,2,null,4,null,1,2,4,4,4]
[null,14,"3x VPM 30/35/2 W + VPM 20/25/2 W",14,1,3,null,4,null,1,2,4,4,4]
[null,15,"3x VPM 40/45/2 W",15,null,null,3,3,null,1,1,3,3,3]
[null,16,"4x VPM 30/35/2 W",16,null,4,null,4,null,1,2,4,4,4]
[null,17,"4x VPM 40/45/2 W",17,null,null,4,4,null,1,2,4,4,4]

{"sheet":"Guide choix","index":4,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[[2,0,2,10],[3,0,3,10],[0,0,0,10]]}
["Guide de choix (source Guide collectif VAILLANT)"]

{"sheet":"Calcul2","index":5,"n_rows":278,"n_cols":34,"rows_kept":278,"cut":false,"hidden":true,"merged":[[191,7,191,8],[265,7,265,8],[211,7,211,8],[211,1,211,2],[252,1,252,2],[191,1,191,2],[265,1,265,2],[224,1,224,2],[238,1,238,2],[1,1,1,2],[11,1,11,2],[67,1,67,2],[52,1,52,2],[62,1,62,2],[49,1,49,2],[72,1,72,2],[80,1,80,2],[174,1,174,2],[20,1,20,2],[47,1,47,2],[117,1,117,2],[134,1,134,2]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Affichage des solutions",null,null,"Solutions","Solution 1","Solution 2","Solution 3","Solution 4"]
[null,"Semi-instantané",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Affichage uniSTOR",null,"Type de ballon",{"$f":"IF(ISERROR(INDEX(INDIRECT($AB$23),1,1))=TRUE,\"\",INDEX(INDIRECT($AB$23),1,1))","v":"VIHR 400"},{"$f":"IF(ISERROR(INDEX(INDIRECT($AB$23),1,2))=TRUE,\"\",INDEX(INDIRECT($AB$23),1,2))","v":"VIHR 500"},{"$f":"IF(ISERROR(INDEX(INDIRECT($AB$23),1,3))=TRUE,\"\",INDEX(INDIRECT($AB$23),1,3))","v":"VIHR 750 "},{"$f":"IF(ISERROR(INDEX(INDIRECT($AB$23),1,4))=TRUE,\"\",INDEX(INDIRECT($AB$23),1,4))","v":"VIHR 1000"}]
[null,"N","N= Σni * Ni","Nb de logement standard / Méthode Qualitel = T3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Puissance minimum du générateur dédiée à l'ECS (kW)",{"$f":"IF(ISERROR(INDEX(INDIRECT($AB$23),2,1))=TRUE,\"\",INDEX(INDIRECT($AB$23),2,1))","v":26.282882387974233},{"$f":"IF(ISERROR(INDEX(INDIRECT($AB$23),2,2))=TRUE,\"\",INDEX(INDIRECT($AB$23),2,2))","v":23.381832382343003},{"$f":"IF(ISERROR(INDEX(INDIRECT($AB$23),2,3))=TRUE,\"\",INDEX(INDIRECT($AB$23),2,3))","v":15.467011171327371},{"$f":"IF(ISERROR(INDEX(INDIRECT($AB$23),2,4))=TRUE,\"\",INDEX(INDIRECT($AB$23),2,4))","v":11.43076768523175}]
[null,"s","0.17 +(N-1) ^(-1/2)","Simultanéité",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Choix de la solution"]
[null,"Vph","0.75*150*N","Volume de pointe pluri-horaire"]
[null,"Tph","5*N^0.905/(15+N^0.92)","Temps pluri-horaire"]
[null,"Vpm","50*N*s","Volume de pointe de 10 minutes"]
[null,"Tpm",{"$f":"1/6","v":0.16666666666666666},"Temps 10 min"]
[null,"Puissance besoin ECS","(1.16/1000)*(Vpm-Vsu)*(Temp ECS - Temp EF)/Tpm",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Affichage allSTOR"]
[null,"Consommation","Somme ni * Ci",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(D164)=TRUE,\"\",IF(D164>C45,\"Le Delta T entre la température primaire et la température de consigne est trop faible pour proposer une solution\",\"Température de stockage  : \"&ROUNDUP(D164,0)&\" °C\"))","v":"Température de stockage  : 76 °C"}]
[null,"Volume ballon",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(D163)=TRUE,\"\",IF(D164>C45,\"\",\"Module(s) aguaFLOW W : \"&IF(ISERROR(D163)=TRUE,\"\",D163)))","v":"Module(s) aguaFLOW W : VPM 40/45/2 W"},{"$f":"D163","v":"VPM 40/45/2 W"}]
[null,"Semi-accumulé",{"$f":"'Données d''entrée'!#REF!","v":{"$error":"#REF!"}}]
[null,"Volume ballon",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Solutions","Solution 5","Solution 6","Solution 7","Solution 8"]
[null,"Volume du ballon retenue",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ballon",{"$f":"IF(ISERROR(D161)=TRUE,\"\",IF(D164>C45,\"\",D161))","v":"VPS 500"},{"$f":"IF(ISERROR(E161)=TRUE,\"\",IF(D164>C45,\"\",E161))","v":"VPS 800"},{"$f":"IF(ISERROR(F161)=TRUE,\"\",IF(D164>C45,\"\",F161))","v":"VPS 1000"},{"$f":"IF(ISERROR(G161)=TRUE,\"\",IF(D164>C45,\"\",G161))","v":""}]
[null,"Puissance besoin ECS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Puissance minimum du générateur  dédiée à l'ECS  (kW)",{"$f":"IF(ISERROR(D162)=TRUE,\"\",IF(D164>C45,\"\",D162))","v":26.964203772418351},{"$f":"IF(ISERROR(E162)=TRUE,\"\",IF(D164>C45,\"\",E162))","v":19.894154717170707},{"$f":"IF(ISERROR(F162)=TRUE,\"\",IF(D164>C45,\"\",F162))","v":15.361440340287201},{"$f":"IF(ISERROR(G162)=TRUE,\"\",IF(D164>C45,\"\",G162))","v":""}]
[null,"Tpm",null,"Durée de point de 10 min",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Choix de la solution"]
[null,"Vpm",null,"Volume puisé maximal"]
[null,"Consommation"]
[null,"Simultanéité","0.17 +(N-1) ^(-1/2)"]
[null,"Nb de logement standard",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Recherche où trouver le résultat des couples puissance/volume en fonction de la température du primaire "]
[null,"Dimensionnement",{"$f":"'Données d''entrée'!#REF!","v":{"$error":"#REF!"}}]
[null,"Qp","(1.16/1000)*Vp*(Tgen-Tef)","Quantité d'energie souhaité",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N° de ligne",{"$f":"VLOOKUP(C45,Y25:Z27,2,FALSE)","v":3}]
[null,"Tgen",null,"Température de l'ECS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Adresse de la matrice",{"$f":"INDEX(AB25:AB27,AB22,1)","v":"D115:G116"}]
[null,"Tef",null,"Temp Eau froide",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N° de ligne",null,"Matrice des adresse des resultats"]
[null,"Qsu",null,"Energie en SI ou SA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,60,1,"en fonction de la température de primaire 60 °C",{"$f":"\"D\"&ROW(D91)&\":G\"&ROW(G92)","v":"D91:G92"}]
[null,"Vsu",null,"Volume stocké utile en SI ou SA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,70,2,"en fonction de la température de primaire 70 °C",{"$f":"\"D\"&ROW(D103)&\":G\"&ROW(G104)","v":"D103:G104"}]
[null,"P","Pdisp + (1,16/1000)*(Vpm-Vsu)*(Tgen-Tef)/Tpm","Puissance de production en Semi Instantané",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,80,3,"en fonction de la température de primaire 80 °C",{"$f":"\"D\"&ROW(D115)&\":G\"&ROW(G116)","v":"D115:G116"}]
[null,"Vpm",null,"Volume puisé en litre  à Tgen durant tpm"]
[null,"Vsu",null,"Volume stocké en litre à Tgen"]
[null,"Tef",null,"Température EF"]
[null,"Tpm",null,"Durée de pointe de conso extreme soit 1/6 h",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Recherche où trouver le résultat Vpm … en fonction du type d'établissement"]
[null,"Pdisp",null,"Puissance nécessaire au maintien de boucle en température"]
[null,"P","Pdisp + (1,16/1000)*(Vph-Vsu)*(Tgen-Tef)/Tph",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N° de colonne",{"$f":"HLOOKUP(C44,$AB$40:$AH$41,2,FALSE)","v":4}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Adresss de Vpm",{"$f":"INDEX($AB$42:$AH$47,AC34,$AB$33)","v":232.34527228867526},1]
[null,"Volume de transition entre semi-instantané et semi-accumulé",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Adresss de Tpm",{"$f":"INDEX($AB$42:$AH$47,AC35,$AB$33)","v":0.16666666666666666},2]
[null," VSI/SA =","(Vh x t10-V10 x th)/(0,8 x t10 - 0,6 x th)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Adresss de Vph",990.00000000000011,3]
[null,"si V < VSI/SA alors P = PSI sinon P = PSA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Adresss de Tph",1.5980134058362387,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Adresse de s",0.16666666666666666,5]
[null,"Volume de transition entre semi-accumulé et accumulé",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Adresse de C",550,6]
[null,"c'est la capacité seuil telle que PSA = PA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Matrice des adresse des resultats","Camping","Hôtellerie","Internat","Logements collectifs","Restauration","Santé","Sport"]
[null," VSA/A =","1,25 x (Vh - VA x th/tc)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"en fonction du profils de l'établissement",1,2,3,4,5,6,7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vpm",{"$f":"D220","v":31.25},{"$f":"D207","v":30.612244897959187},{"$f":"D261","v":0},{"$f":"D187","v":232.34527228867526},{"$f":"D234","v":33.333333333333336},{"$f":"D248","v":31.25},{"$f":"D275","v":0}]
[null,"Rappel de données d'entrées communes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tpm",{"$f":"D221","v":0.16666666666666666},{"$f":"D208","v":0.16666666666666666},{"$f":"D262","v":0.16666666666666666},{"$f":"D188","v":0.16666666666666666},{"$f":"D235","v":0.16666666666666666},{"$f":"D249","v":0.16666666666666666},{"$f":"D276","v":0.16666666666666666}]
["Données d'entrées","Profils de l'établissement",{"$f":"'Données d''entrée'!G26","v":"Logements collectifs"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vph",{"$f":"D222","v":2812.5},{"$f":"D209","v":5625},{"$f":"D263","v":0},{"$f":"D189","v":990.00000000000011},{"$f":"D236","v":1125},{"$f":"D250","v":2812.5},{"$f":"D277","v":0}]
["Données d'entrées","Température primaire",{"$f":"'Données d''entrée'!G60","v":80},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tph",{"$f":"D223","v":2.6822758491682159},{"$f":"D210","v":3.3434295591185639},{"$f":"D264","v":0},{"$f":"D190","v":1.5980134058362387},{"$f":"D237","v":1.723000700464689},{"$f":"D251","v":2.6822758491682159},{"$f":"D278","v":0}]
["Données d'entrées","Température de consigne ECS",{"$f":"'Données d''entrée'!G61","v":60},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"s",{"$f":"D219","v":2.5000000000000001E-2},{"$f":"D206","v":1.2244897959183675E-2},{"$f":"D260","v":1},{"$f":"D188","v":0.16666666666666666},{"$f":"D233","v":6.6666666666666666E-2},{"$f":"D247","v":2.5000000000000001E-2},{"$f":"D276","v":0.16666666666666666}]
[null,"Selection de la solution",{"$f":"'Données d''entrée'!Q2","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C",{"$f":"C217","v":300},{"$f":"C203","v":3000},{"$f":"C258","v":0},{"$f":"C183","v":550},{"$f":"C231","v":120},{"$f":"C245","v":1000},{"$f":"C272","v":0}]
["Données d'entrées","Donnée commune"]
["Données d'entrées","Temp EF",{"$f":"'Table ECS'!E176","v":5.7}]
["Calculs","Donnée ballon uniSTOR"]
["Calculs","Type de ballon",null,"VIHR 300","VIHR 400","VIHR 500","VIHR 750 ","VIHR 1000","VIHR 1500","VIHR 2000","VIHR 1000 + VIHR 1500","2x VIHR 1500","VIHR 1500 + VIHR 2000","2x VIHR 2000",null,null,null,null,null,null,null,null,null,"Recherche la solution choisi manuellement"]
["Calculs","Volume ballon ",null,295,404,496,747,875,1342,1909,{"$f":"H52+I52","v":2217},{"$f":"I52*2","v":2684},{"$f":"I52+J52","v":3251},{"$f":"J52*2","v":3818},null,null,null,null,null,null,null,null,null,null,null,null,"Determination de la solution choisi","Solutions","Ballon :",{"$f":"INDEX(AB53:AB60,C47,1)","v":"VIHR 400"},"Données de sorties de la feuille"]
["Calculs","Caractéristique ballons * Guide VGF",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AB2","v":"VIHR 400"},"auroFLOW :",{"$f":"IF(C47>4,AB61,\"\")","v":""},"Données de sorties de la feuille"]
["Calculs","Temp Primaire ",null,60,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AC2","v":"VIHR 500"}]
["Calculs","Puissance échangeur pour soutirage 45°C","60/45/10 °C",46,46,62,34,40,51,62,{"$f":"+H55+I55","v":91},{"$f":"+I55*2","v":102},{"$f":"+J55+I55","v":113},{"$f":"+J55*2","v":124},null,"Montage en parallèle pour les ballons",null,null,null,null,null,null,null,null,null,null,null,{"$f":"AD2","v":"VIHR 750 "}]
["Calculs","Puissance échangeur pour soutirage 60°C","60/60/10 °C","-","-","-",46,55,69,84,{"$f":"+H56+I56","v":124},{"$f":"+I56*2","v":138},{"$f":"+J56+I56","v":153},{"$f":"+J56*2","v":168},null,"Montage en parallèle pour les ballons",null,null,null,null,null,null,null,null,null,null,null,{"$f":"AE2","v":"VIHR 1000"}]
["Calculs","Temp Primaire ",null,70,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Calcul2!AB14","v":"VPS 500"}]
["Calculs","Puissance échangeur pour soutirage 45°C","70/45/10 °C",38,38,48,50,59,74,90,{"$f":"+H58+I58","v":133},{"$f":"+I58*2","v":148},{"$f":"+J58+I58","v":164},{"$f":"+J58*2","v":180},null,"\"-\" Elements manquants",null,null,null,null,null,null,null,null,null,null,null,{"$f":"Calcul2!AC14","v":"VPS 800"}]
["Calculs","Puissance échangeur pour soutirage 60°C","70/60/10 °C",28,28,35,41,48,60,73,{"$f":"+H59+I59","v":108},{"$f":"+I59*2","v":120},{"$f":"+J59+I59","v":133},{"$f":"+J59*2","v":146},null,"Hypothèses de puissance",null,null,null,null,null,null,null,null,null,null,null,{"$f":"Calcul2!AD14","v":"VPS 1000"}]
["Calculs","Temp Primaire ",null,80,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Calcul2!AE14","v":""}]
["Calculs","Puissance échangeur pour soutirage 45°C","80/45/10 °C",50,50,63,65,77,97,118,{"$f":"+H61+I61","v":174},{"$f":"+I61*2","v":194},{"$f":"+J61+I61","v":215},{"$f":"+J61*2","v":236},null,"Montage en parallèle pour les ballons",null,null,null,null,null,null,null,null,null,null,null,{"$f":"Calcul2!AB11","v":"VPM 40/45/2 W"}]
["Calculs","Puissance échangeur pour soutirage 60°C","80/60/10 °C",41,41,51,54,63,79,96,{"$f":"+H62+I62","v":142},{"$f":"+I62*2","v":158},{"$f":"+J62+I62","v":175},{"$f":"+J62*2","v":192},null,"Hypothèses de puissance"]
["Calculs","Système semi-instantané - Puissance besoin ECS"]
["Calculs","Volume stocké utile (Vsu) = 0,6 x Volume réel ballon",null,{"$f":"0.6*D52","v":177},242.39999999999998,297.59999999999997,448.2,525,805.19999999999993,1145.3999999999999,1330.2,1610.3999999999999,1950.6,2290.7999999999997,null,"=0,6*D52"]
["Calculs","Vpm",null,{"$f":"AB34","v":232.34527228867526},null,null,null,null,null,null,null,null,null,null,null,"=INDEX(INDIRECT($AB$19);1;1)"]
["Calculs","Tpm",null,{"$f":"AB35","v":0.16666666666666666},null,null,null,null,null,null,null,null,null,null,null,"=INDEX(INDIRECT($AB$18);1;1)"]
["Calculs","Puissance besoin ECS","=1,16 / 1000 * (Vpm - Vsu)*(TECS - TEF) / Tpm",{"$f":"(1.16/1000)*($D$65-D64)*($C$46-$C$49)/$D$66","v":20.916528065514466},-3.7999631344855267,-24.661588734485523,-81.577545534485523,-110.60241593448553,-216.4978415344855,-345.06894713448548,-414.91004153448552,-520.80546713448553,-649.37657273448553,-777.94767833448532]
["Calculs","Système semi-accumulé - Puissance besoin ECS"]
["Calculs","Volume stocké utile (Vsu) = 0,6 x Volume réel ballon",null,{"$f":"0.8*D52","v":236},{"$f":"0.8*E52","v":323.20000000000005},396.8,597.6,700,1073.6000000000001,1527.2,1773.6000000000001,2147.2000000000003,2600.8000000000002,3054.4,null,"=0,8*D52"]
["Calculs","Vph",null,{"$f":"AB36","v":990.00000000000011},null,null,null,null,null,null,null,null,null,null,null,"=INDEX(INDIRECT($AB$20);1;1)"]
["Calculs","Tph",null,{"$f":"AB37","v":1.5980134058362387},null,null,null,null,null,null,null,null,null,null,null,"=INDEX(INDIRECT($AB$21);1;1)"]
["Calculs","Puissance besoin ECS","=1,16 / 1000 * (Vph - Vsu)*(TECS - TEF) / Tph",{"$f":"1.16/1000*($D$70-D69)*($C$46-$C$49)/$D$71","v":29.719995981602541},{"$f":"1.16/1000*($D$70-E69)*($C$46-$C$49)/$D$71","v":26.282882387974233},23.381832382343003,15.467011171327371,11.43076768523175,-3.2952144085702555,-21.174511725884457,-30.886722614302052,-45.612704708104069,-63.492002025418266,-81.37129934273247]
["Calculs","Limite entre SI & SA"]
["Calculs","Volume de transition = Vsutr","=(Vpm*Tph-Vph*Tpm)/(Tph-Tpm)"]
["Calculs","Vsutr",null,{"$f":"(D65*D71-D70*D66)/(D71-D66)","v":144.12361048145365},"litres à 60°C"]
[null,"si V < Vsutr alors P = PSI sinon P = PSA"]
["modif gilles le 29/07","P =",null,{"$f":"IF(D52<$D$75,D67,D72)","v":29.719995981602541},26.282882387974233,23.381832382343003,15.467011171327371,11.43076768523175,-3.2952144085702555,-21.174511725884457,-30.886722614302052,-45.612704708104069,-63.492002025418266,-81.37129934273247]
[null,"Si la puissance > 0 réponse VRAI",null,{"$f":"D77>0","v":true},{"$f":"E77>0","v":true},true,true,true,false,false,false,false,false,false]
["Calculs","Puissance de transition = Ptr","=pertes + 1.16/1000*(Vph-Vpm)*(Temp consigne - Temp EF)/(Tph-Tpm)"]
["Calculs","Ptr",null,{"$f":"(1.16/1000)*(D70-D65)*(C46-C49)/(D71-D66)","v":33.34143620347966},"kW"]
["Calculs","Couple besoins / puissance"]
["Calculs",{"$f":"B54","v":"Temp Primaire "},null,{"$f":"D54","v":60}]
["Calculs","Si Vpm < Vstockage utile",null,{"$f":"IF($D$65<D$64,TRUE,FALSE)","v":false},true,true,true,true,true,true,true,true,true,true,null,"=SI($D$65<D$50;VRAI;FAUX)"]
["Calculs","Si Pbesoin ECS < P échangeur soutirage 60°C",null,{"$f":"AND(D$56<>\"-\",D$77<D$56)","v":false},{"$f":"AND(E$56<>\"-\",E$77<E$56,E77>0)","v":false},false,true,true,false,false,false,false,false,false,null,"=ET(D57<>\"-\";D76<D57;E76>0)"]
["Calculs","Si les solutions sont VRAI",null,{"$f":"AND(D83=TRUE,D84=TRUE,D$78=TRUE)","v":false},{"$f":"AND(E83=TRUE,E84=TRUE,E$78=TRUE)","v":false},false,true,true,false,false,false,false,false,false,null,"=OU(ET(D85=VRAI;D86=VRAI);ET(D79=VRAI;D87=VRAI))"]
["Calculs","Index",null,1,2,3,4,5,6,7,8,9,10,11]
["Calculs"]
["Calculs","Primaire à 60°C",null,"Solution 1","Solution 2","Solution 3","Solution 4"]
["Calculs",null,null,{"$f":"IFERROR(D90,1)","v":4},{"$f":"D89+1","v":5},{"$f":"E89+1","v":6},{"$f":"F89+1","v":7},null,null,null,null,null,null,null,null,"compteur"]
["Calculs",null,null,{"$f":"IF(ISERROR(HLOOKUP(TRUE,D85:N86,2,FALSE))=TRUE,FALSE,HLOOKUP(TRUE,D85:N86,2,FALSE))","v":4},{"$f":"IF(E89>=11,FALSE,IF(INDEX($D85:$N85,1,E89)=TRUE,INDEX($D86:$N86,1,E89),FALSE))","v":5},{"$f":"IF(F89>=11,FALSE,IF(INDEX($D85:$N85,1,F89)=TRUE,INDEX($D86:$N86,1,F89),FALSE))","v":false},{"$f":"IF(G89>=11,FALSE,IF(INDEX($D85:$N85,1,G89)=TRUE,INDEX($D86:$N86,1,G89),FALSE))","v":false},null,null,null,null,null,null,null,null,"compteur"]
["Calculs",null,"Type de ballon",{"$f":"IF(D90<>FALSE,INDEX($D$51:$N$51,1,D90),\"\")","v":"VIHR 750 "},{"$f":"IF(E90<>FALSE,INDEX($D$51:$N$51,1,E90),\"\")","v":"VIHR 1000"},{"$f":"IF(F90<>FALSE,INDEX($D$51:$N$51,1,F90),\"\")","v":""},{"$f":"IF(G90<>FALSE,INDEX($D$51:$N$51,1,G90),\"\")","v":""}]
["Calculs",null,"Puissance minimum du générateur pour soutirage 60°C",{"$f":"IF(D90<>FALSE,INDEX($D77:$N77,1,D90),\"\")","v":15.467011171327371},{"$f":"IF(E90<>FALSE,INDEX($D77:$N77,1,E90),\"\")","v":11.43076768523175},{"$f":"IF(F90<>FALSE,INDEX($D77:$N77,1,F90),\"\")","v":""},{"$f":"IF(G90<>FALSE,INDEX($D77:$N77,1,G90),\"\")","v":""}]
["Calculs"]
["Calculs",{"$f":"B57","v":"Temp Primaire "},null,{"$f":"D57","v":70}]
["Calculs","Si Vpm < Vstockage utile",null,{"$f":"IF($D$65<D$64,TRUE,FALSE)","v":false},true,true,true,true,true,true,true,true,true,true,null,"=SI($D$65<L$50;VRAI;FAUX)"]
["Calculs","Si Pbesoin ECS < P échangeur soutirage 60°C",null,{"$f":"AND(D$59<>\"-\",D$77<D$59)","v":false},{"$f":"AND(E$59<>\"-\",E$77<E$59,E77>0)","v":true},true,true,true,false,false,false,false,false,false,null,"=ET(L60<>\"-\";L67>0;L67<L60;E76>0)"]
["Calculs","Si les solutions sont VRAI",null,{"$f":"AND(D95=TRUE,D96=TRUE,D$78=TRUE)","v":false},{"$f":"AND(E95=TRUE,E96=TRUE,E$78=TRUE)","v":true},{"$f":"AND(F95=TRUE,F96=TRUE,F$78=TRUE)","v":true},{"$f":"AND(G95=TRUE,G96=TRUE,G$78=TRUE)","v":true},{"$f":"AND(H95=TRUE,H96=TRUE,H$78=TRUE)","v":true},{"$f":"AND(I95=TRUE,I96=TRUE,I$78=TRUE)","v":false},{"$f":"AND(J95=TRUE,J96=TRUE,J$78=TRUE)","v":false},{"$f":"AND(K95=TRUE,K96=TRUE,K$78=TRUE)","v":false},{"$f":"AND(L95=TRUE,L96=TRUE,L$78=TRUE)","v":false},{"$f":"AND(M95=TRUE,M96=TRUE,M$78=TRUE)","v":false},{"$f":"AND(N95=TRUE,N96=TRUE,N$78=TRUE)","v":false},null,"=OU(ET(L107=VRAI;L108=VRAI);ET(L109=VRAI;L107=VRAI))"]
["Calculs","Index",null,1,2,3,4,5,6,7,8,9,10,11]
["Calculs"]
["Calculs","Primaire à 70°C",null,"Solution 1","Solution 2","Solution 3","Solution 4"]
["Calculs",null,null,{"$f":"IFERROR(D102,1)","v":2},{"$f":"D101+1","v":3},{"$f":"E101+1","v":4},{"$f":"F101+1","v":5},null,null,null,null,null,null,null,null,"compteur"]
["Calculs",null,null,{"$f":"IF(ISERROR(HLOOKUP(TRUE,D97:N98,2,FALSE))=TRUE,FALSE,HLOOKUP(TRUE,D97:N98,2,FALSE))","v":2},{"$f":"IF(E101>=11,FALSE,IF(INDEX($D97:$N97,1,E101)=TRUE,INDEX($D98:$N98,1,E101),FALSE))","v":3},{"$f":"IF(F101>=11,FALSE,IF(INDEX($D97:$N97,1,F101)=TRUE,INDEX($D98:$N98,1,F101),FALSE))","v":4},{"$f":"IF(G101>=11,FALSE,IF(INDEX($D97:$N97,1,G101)=TRUE,INDEX($D98:$N98,1,G101),FALSE))","v":5},null,null,null,null,null,null,null,null,"compteur"]
["Calculs",null,"Type de ballon",{"$f":"IF(D102<>FALSE,INDEX($D$51:$N$51,1,D102),\"\")","v":"VIHR 400"},{"$f":"IF(E102<>FALSE,INDEX($D$51:$N$51,1,E102),\"\")","v":"VIHR 500"},{"$f":"IF(F102<>FALSE,INDEX($D$51:$N$51,1,F102),\"\")","v":"VIHR 750 "},{"$f":"IF(G102<>FALSE,INDEX($D$51:$N$51,1,G102),\"\")","v":"VIHR 1000"}]
["Calculs",null,"Puissance minimum du générateur pour soutirage 60°C",{"$f":"IF(D102<>FALSE,INDEX($D77:$N77,1,D102),\"\")","v":26.282882387974233},{"$f":"IF(E102<>FALSE,INDEX($D77:$N77,1,E102),\"\")","v":23.381832382343003},{"$f":"IF(F102<>FALSE,INDEX($D77:$N77,1,F102),\"\")","v":15.467011171327371},{"$f":"IF(G102<>FALSE,INDEX($D77:$N77,1,G102),\"\")","v":11.43076768523175}]
["Calculs"]
["Calculs",{"$f":"B60","v":"Temp Primaire "},null,{"$f":"D60","v":80}]
["Calculs","Si Vpm < Vstockage utile",null,{"$f":"IF($D$65<D$64,TRUE,FALSE)","v":false},true,true,true,true,true,true,true,true,true,true,null,"=SI($D$65<L$50;VRAI;FAUX)"]
["Calculs","Si Pbesoin ECS SI < Péchangeur soutirage 60°C",null,{"$f":"AND(D$62<>\"-\",D$77<D$62)","v":true},{"$f":"AND(E$62<>\"-\",E$77<E$62,E77>0)","v":true},true,true,true,false,false,false,false,false,false,null,"=ET(L63<>\"-\";L67>0;L67<L63;E76>0)"]
["Calculs","Si les solutions sont VRAI",null,{"$f":"AND(D107=TRUE,D108=TRUE,D$78=TRUE)","v":false},{"$f":"AND(E107=TRUE,E108=TRUE,E$78=TRUE)","v":true},{"$f":"AND(F107=TRUE,F108=TRUE,F$78=TRUE)","v":true},{"$f":"AND(G107=TRUE,G108=TRUE,G$78=TRUE)","v":true},{"$f":"AND(H107=TRUE,H108=TRUE,H$78=TRUE)","v":true},{"$f":"AND(I107=TRUE,I108=TRUE,I$78=TRUE)","v":false},{"$f":"AND(J107=TRUE,J108=TRUE,J$78=TRUE)","v":false},{"$f":"AND(K107=TRUE,K108=TRUE,K$78=TRUE)","v":false},{"$f":"AND(L107=TRUE,L108=TRUE,L$78=TRUE)","v":false},{"$f":"AND(M107=TRUE,M108=TRUE,M$78=TRUE)","v":false},{"$f":"AND(N107=TRUE,N108=TRUE,N$78=TRUE)","v":false},null,"=OU(ET(L129=VRAI;L130=VRAI);ET(L131=VRAI;T123=VRAI))"]
["Calculs","Si 2 solutions sont VRAI",null,1,2,3,4,5,6,7,8,9,10,11]
["Calculs"]
["Calculs","Primaire à 80°C",null,"Solution 1","Solution 2","Solution 3","Solution 4"]
["Calculs",null,null,{"$f":"IFERROR(D114,1)","v":2},{"$f":"D113+1","v":3},{"$f":"E113+1","v":4},{"$f":"F113+1","v":5},null,null,null,null,null,null,null,null,"compteur"]
["Calculs",null,null,{"$f":"IF(ISERROR(HLOOKUP(TRUE,D109:N110,2,FALSE))=TRUE,FALSE,HLOOKUP(TRUE,D109:N110,2,FALSE))","v":2},{"$f":"IF(E113>=11,FALSE,IF(INDEX($D109:$N109,1,E113)=TRUE,INDEX($D110:$N110,1,E113),FALSE))","v":3},{"$f":"IF(F113>=11,FALSE,IF(INDEX($D109:$N109,1,F113)=TRUE,INDEX($D110:$N110,1,F113),FALSE))","v":4},{"$f":"IF(G113>=11,FALSE,IF(INDEX($D109:$N109,1,G113)=TRUE,INDEX($D110:$N110,1,G113),FALSE))","v":5},null,null,null,null,null,null,null,null,"compteur"]
["Calculs",null,"Type de ballon",{"$f":"IF(D114<>FALSE,INDEX($D$51:$N$51,1,D114),\"\")","v":"VIHR 400"},{"$f":"IF(E114<>FALSE,INDEX($D$51:$N$51,1,E114),\"\")","v":"VIHR 500"},{"$f":"IF(F114<>FALSE,INDEX($D$51:$N$51,1,F114),\"\")","v":"VIHR 750 "},{"$f":"IF(G114<>FALSE,INDEX($D$51:$N$51,1,G114),\"\")","v":"VIHR 1000"}]
["Calculs",null,"Puissance minimum du générateur pour soutirage 60°C",{"$f":"IF(D114<>FALSE,INDEX($D77:$N77,1,D114),\"\")","v":26.282882387974233},{"$f":"IF(E114<>FALSE,INDEX($D77:$N77,1,E114),\"\")","v":23.381832382343003},{"$f":"IF(F114<>FALSE,INDEX($D77:$N77,1,F114),\"\")","v":15.467011171327371},{"$f":"IF(G114<>FALSE,INDEX($D77:$N77,1,G114),\"\")","v":11.43076768523175}]
["Calculs"]
["Calculs","Calcul allSTOR"]
["Calculs","TECS =",null,{"$f":"Calcul2!C46","v":60},"°C"]
["Calculs","TEF =",null,{"$f":"Calcul2!C49","v":5.7},"°C",null,null,null,null,null,null,null,null,null,null,"en fontion de la zone clim"]
["Calculs"]
["Calculs","DT =","TECS - TEF",{"$f":"D119-D120","v":54.3},"°C"]
["Calculs","1 ° Durant le débit de pointe"]
["Calculs","t10 =",null,{"$f":"10*60","v":600},"s",{"$f":"D124/60","v":10},"mn"]
["Calculs"," V10  =",null,{"$f":"Calcul2!D65","v":232.34527228867526},"Litres",{"$f":"D125+D125*($D$119-45)/($D$119-$D$120)","v":296.5290491639999},"l","volume utile si on était à 45°C",null,null,null,null,null,null,null,"en foction du profil de l'établisement"]
["Calculs","DébitECS =",null,{"$f":"D125/D124","v":0.38724212048112544},"kg / s",{"$f":"F125/F124","v":29.65290491639999},"l /mn","Valeur pour recherche"]
["Calculs","TD2Mini.t10 =",null,{"$f":"TempVPM_W!B32","v":75.27328},"°C",{"$f":"TempVPM_W!B33","v":"VPM 40/45/2 W"},null,"=> issu outil allSTOR"]
["Calculs","P =","\"M cp DT\"",{"$f":"$D$126*4180*($D$119-$D$120)/1000","v":87.893893054082966},"kW"]
["Calculs","2 ° Puis durant le débit pluri-horaire quand TD2 = TD2MINI.t10"]
["Calculs","th ou tph  =",null,{"$f":"Calcul2!D71*3600","v":5752.8482610104593},"s",{"$f":"D130/60","v":95.880804350174316},"mn",null,null,null,null,null,null,null,null,"en foction du profil de l'établisement"]
["Calculs"," Vh ou Vph =",null,{"$f":"Calcul2!D70","v":990.00000000000011},"Litres",{"$f":"D131+D131*($D$119-45)/($D$119-$D$120)","v":1263.4806629834256},"l","volume utile si on était à 45°C",null,null,null,null,null,null,null,"en foction du profil de l'établisement"]
["Calculs","DébitECS =",null,{"$f":"D131/D130","v":0.1720886689658857},"kg / s",{"$f":"F131/F130","v":13.177618518603182},"l /mn","Valeur pour recherche"]
["Calculs","TD2Mini.th =",null,{"$f":"TempVPM_W!B38","v":65.571699999999993},"°C",{"$f":"TempVPM_W!B39","v":"VPM 20/25/2 W"},null,"=> issu outil allSTOR"]
["Calculs","P =","\"M cp DT\"",{"$f":"$D$132*4180*($D$119-$D$120)/1000","v":39.059653549862936},"kW"]
["Calculs","Donnée ballon allSTOR",null,"VPS 300","VPS 500","VPS 800","VPS 1000","VPS 1500","VPS 2000","VPS 1500 + VPS 1000","2x VPS 1500","VPS 2000+ VPS 1500","2x VPS 2000"]
["Calculs",null,null,0.30299999999999999,0.49099999999999999,0.77800000000000002,0.96199999999999997,1.5049999999999999,1.917,2.4670000000000001,3.01,3.4220000000000002,3.8340000000000001,"m3"]
["Calculs","Méthode suivant AICVF"]
["Calculs","En instantané pur"]
["Calculs","PI =","1,16/1000 x DT x V10 / t10",{"$f":"4180/1000*$D$122*$D$125/$D$124","v":87.893893054082952},87.893893054082952,87.893893054082952,87.893893054082952,87.893893054082952,87.893893054082952,87.893893054082952,87.893893054082952,87.893893054082952,87.893893054082952,"kW"]
["Calculs","V =",0]
["Calculs","En semi-instantané"]
["Calculs"," Vsu =","0,6 x V . (TECS - TEF)/(TD2Mini - TEF)",{"$f":"0.6*(D$136*($D$119-$D$120)/($D$127-$D$120))*1000","v":141.88981747015521},229.92706395328779,364.32434980785729,450.48846338709342,704.76625509103485,897.69894419236812,1155.2547184781283,1409.5325101820697,1602.4651992834029,1795.3978883847362,"Litres"]
["Calculs","PSI =","1,16/1000 x DT x (V10 Utile-VSU) / t10",{"$f":"4180/1000*$D$122*($D$125-D$142)/$D$124","v":34.218394003297945},0.91478403119372809,-49.926365234731357,-82.521387760620584,-178.71213358430458,-251.69664054444792,-349.12741439900816,-445.31816022269214,-518.30266718283542,-591.28717414297887,"kW"]
["Calculs","En semi-accumulé"]
["Calculs"," Vsu =","0,8 x V . (TECS - TEF)/(TD2Mini - TEF)",{"$f":"0.8*D$136*($D$119-$D$120)/($D$127-$D$120)*1000","v":189.18642329354026},306.56941860438383,485.76579974380974,600.65128451612463,939.68834012137984,1196.931925589824,1540.3396246375048,1879.3766802427597,2136.6202657112049,2393.863851179648,"Litres"]
["Calculs","PSA =","1,16/1000 x DT x (Vph-VSU) / th",{"$f":"4180/1000*$D$122*($D$131-D145)/$D$130","v":31.595455418364548},26.964203772418351,19.894154717170707,15.361440340287201,1.9850060650277239,-8.1643326484288252,-21.713207144548022,-35.089641419807485,-45.238980133264079,-55.388318846720587,"kW"]
["Calculs","Volume de transition entre semi-instantané et semi-accumulé"]
["Calculs"," VSI/SA =","(Vh x t10 - V10 x th)/(0,8 x t10 - 0,6 x th)",{"$f":"($D$131*$D$124-$D$125*$D$130)/(0.8*$D$124-0.6*$D$130)","v":249.90572982894602},249.90572982894602,249.90572982894602,249.90572982894602,249.90572982894602,249.90572982894602,249.90572982894602,249.90572982894602,249.90572982894602,249.90572982894602,"Litres"]
["Calculs","si V < VSI/SA alors P = PSI sinon P = PSA","Vtr = Th/(1-3,6Th) x (coeff logt x 620,7 + Vh/Th - V10/T10)"]
["Calculs","P =",null,{"$f":"IF(D136*1000<D148,D143,D146)","v":31.595455418364548},{"$f":"IF(E136*1000<E148,E143,E146)","v":26.964203772418351},{"$f":"IF(F136*1000<F148,F143,F146)","v":19.894154717170707},{"$f":"IF(G136*1000<G148,G143,G146)","v":15.361440340287201},{"$f":"IF(H136*1000<H148,H143,H146)","v":1.9850060650277239},-8.1643326484288252,-21.713207144548022,-35.089641419807485,-45.238980133264079,-55.388318846720587,"kW"]
[null,"Si la puissance > 0 réponse VRAI",null,{"$f":"D150>0","v":true},{"$f":"E150>0","v":true},{"$f":"F150>0","v":true},{"$f":"G150>0","v":true},{"$f":"H150>0","v":true},{"$f":"I150>0","v":false},{"$f":"J150>0","v":false},{"$f":"K150>0","v":false},{"$f":"L150>0","v":false},{"$f":"M150>0","v":false}]
["Calculs"]
["Calculs","Contrôle si V10 est bien < Vsu",null,{"$f":"IF($D$125<D$145,TRUE,FALSE)","v":false},true,true,true,true,true,true,true,true,true]
["Calculs","Contrôle si Psa ou PSI est bien > à equivalence de rechauffage < à 8 h",null,{"$f":"IF(D$136*1000*1.16*($D$127-$D$120)/1000/SQRT(D150^2)*60<480,TRUE,FALSE)","v":true},true,true,true,false,false,false,true,true,true]
["Calculs","Si les 3 solutions sont Vrai",null,{"$f":"AND(D153=TRUE,D154=TRUE,D$151=TRUE)","v":false},{"$f":"AND(E153=TRUE,E154=TRUE,E$151=TRUE)","v":true},true,true,false,false,false,false,false,false]
["Calculs","Si les 3 solutions sont Vrai donne l'index",null,1,2,3,4,5,6,7,8,9,10]
["Calculs"]
["Calculs",null,null,{"$f":"D159","v":2},{"$f":"D158+1","v":3},{"$f":"E158+1","v":4},{"$f":"F158+1","v":5}]
["Calculs","Index des réponses PV ",null,{"$f":"HLOOKUP(TRUE,Calcul2!D155:M156,2,FALSE)","v":2},{"$f":"IF(INDEX(Calcul2!D155:M155,1,E158)=TRUE,INDEX(Calcul2!D156:M156,1,E158),FALSE)","v":3},{"$f":"IF(INDEX(Calcul2!D155:M155,1,F158)=TRUE,INDEX(Calcul2!D156:M156,1,F158),FALSE)","v":4},{"$f":"IF(INDEX(Calcul2!D155:M155,1,G158)=TRUE,INDEX(Calcul2!D156:M156,1,G158),FALSE)","v":false}]
["Calculs",null,"Solutions","Solution 9","Solution 10","Solution 11","Solution 12"]
["Calculs",null,"Ballon",{"$f":"IF($D$159<>FALSE,INDEX(Calcul2!$D$135:$M$135,1,$D$159),\"\")","v":"VPS 500"},{"$f":"IF($E$159<>FALSE,INDEX(Calcul2!$D$135:$M$135,1,$E$159),\"\")","v":"VPS 800"},{"$f":"IF($F$159<>FALSE,INDEX(Calcul2!$D$135:$M$135,1,$F$159),\"\")","v":"VPS 1000"},{"$f":"IF($G$159<>FALSE,INDEX(Calcul2!$D$135:$M$135,1,$G$159),\"\")","v":""}]
["Calculs",null,"Puissance minimum du générateur",{"$f":"IF($D$159<>FALSE,INDEX(Calcul2!$D$150:$M$150,1,$D$159),\"\")","v":26.964203772418351},{"$f":"IF($E$159<>FALSE,INDEX(Calcul2!$D$150:$M$150,1,$E$159),\"\")","v":19.894154717170707},{"$f":"IF($F$159<>FALSE,INDEX(Calcul2!$D$150:$M$150,1,$F$159),\"\")","v":15.361440340287201},{"$f":"IF($G$159<>FALSE,INDEX(Calcul2!$D$150:$M$150,1,$G$159),\"\")","v":""}]
["Calculs",null,"Module aguaFLOW W",{"$f":"IF($D$159<>FALSE,Calcul2!$F$127,\"\")","v":"VPM 40/45/2 W"},{"$f":"IF($E$159<>FALSE,Calcul2!$F$127,\"\")","v":"VPM 40/45/2 W"},{"$f":"IF($F$159<>FALSE,Calcul2!$F$127,\"\")","v":"VPM 40/45/2 W"},{"$f":"IF($G$159<>FALSE,Calcul2!$F$127,\"\")","v":""}]
["Calculs",null,"Temperature de stockage TD2Mini.t10  (en °C)",{"$f":"IF($D$159<>FALSE,Calcul2!$D$127,\"\")","v":75.27328},{"$f":"IF($E$159<>FALSE,Calcul2!$D$127,\"\")","v":75.27328},{"$f":"IF($F$159<>FALSE,Calcul2!$D$127,\"\")","v":75.27328},{"$f":"IF($G$159<>FALSE,Calcul2!$D$127,\"\")","v":""}]
["Calculs",null,"Choix de la solution"]
["Calculs",null,"Puissance échangeurs (en kW)*",{"$f":"IF($D$159<>FALSE,TempVPM_W!$B$34,\"\")","v":109},{"$f":"IF($D$159<>FALSE,TempVPM_W!$B$34,\"\")","v":109},{"$f":"IF($D$159<>FALSE,TempVPM_W!$B$34,\"\")","v":109},{"$f":"IF($D$159<>FALSE,TempVPM_W!$B$34,\"\")","v":109}]
["Calculs",null,"Volume ballon (en L)",{"$f":"IF($D$159<>FALSE,INDEX(Calcul2!$D$136:$M$136,1,$D$159),\"\")*1000","v":491},{"$f":"IF($E$159<>FALSE,INDEX(Calcul2!$D$136:$M$136,1,$E$159),\"\")*1000","v":778},{"$f":"IF($F$159<>FALSE,INDEX(Calcul2!$D$136:$M$136,1,$F$159)*1000,\"\")","v":962},{"$f":"IF($G$159<>FALSE,INDEX(Calcul2!$D$136:$M$136,1,$G$159)*1000,\"\")","v":""}]
["Calculs",null,"Temps de réchauffage du volume V10 (en mn)",{"$f":"IF(D159<>FALSE,Calcul2!$D$125*1.16*(Calcul2!$D$127-Calcul2!$D$120)/1000/D162*60,\"\")","v":41.725154891083378},{"$f":"IF(E159<>FALSE,Calcul2!$D$125*1.16*(Calcul2!$D$127-Calcul2!$D$120)/1000/E162*60,\"\")","v":56.553575405132726},{"$f":"IF(F159<>FALSE,Calcul2!$D$125*1.16*(Calcul2!$D$127-Calcul2!$D$120)/1000/F162*60,\"\")","v":73.24089108807199},{"$f":"IF(G159<>FALSE,Calcul2!$D$125*1.16*(Calcul2!$D$127-Calcul2!$D$120)/1000/G162*60,\"\")","v":""}]
["Calculs",null,"Temps de réchauffage au démarrage (en mn)",{"$f":"IF(D159<>FALSE,D167*1.16*(Calcul2!$D$127-Calcul2!$D$120)/1000/D162*60,\"\")","v":88.17502869637903},{"$f":"IF(E159<>FALSE,E167*1.16*(Calcul2!$D$127-Calcul2!$D$120)/1000/E162*60,\"\")","v":189.36766490573348},{"$f":"IF(F159<>FALSE,F167*1.16*(Calcul2!$D$127-Calcul2!$D$120)/1000/F162*60,\"\")","v":303.24583983437236},{"$f":"IF(G159<>FALSE,G167*1.16*(Calcul2!$D$127-Calcul2!$D$120)/1000/G162*60,\"\")","v":""}]
["Calculs",null,"volume utile après 10 mn (en L)",{"$f":"IF($D$159<>FALSE,INDEX(Calcul2!$D$145:$M$145,1,$D$159)-Calcul2!$D$125,\"\")","v":74.224146315708566},{"$f":"IF($E$159<>FALSE,INDEX(Calcul2!$D$145:$M$145,1,$E$159)-Calcul2!$D$125,\"\")","v":253.42052745513448},{"$f":"IF($F$159<>FALSE,INDEX(Calcul2!$D$145:$M$145,1,$F$159)-Calcul2!$D$125,\"\")","v":368.3060122274494},{"$f":"IF($G$159<>FALSE,INDEX(Calcul2!$D$145:$M$145,1,$G$159)-Calcul2!$D$125,\"\")","v":""}]
["Calculs",null,"* T° eau froide 10 °C, T° primaire 65 °C , T° sortie ECS à 45 °C  "]
["Calculs"]
["Calculs"]
[{"$f":"B$176","v":"Logements collectifs"}]
["Logements collectifs","Définition des besoins"]
["Logements collectifs","Logements collectifs","Oui","conso à 60 °C","*source consommation :  AICVF - 2004",null,null,null,"N Standard"]
["Logements collectifs","Nombre de logements de type 1 ou studio",{"$f":"'Données d''entrée'!G28","v":11},50,"Litres à 60°C / Jour",null,null,null,0.8]
["Logements collectifs","Nombre de logements de type 2",{"$f":"'Données d''entrée'!G29","v":0},75,"Litres à 60°C / Jour",null,null,null,0.9]
["Logements collectifs","Nombre de logements de type 3",{"$f":"'Données d''entrée'!G30","v":0},100,"Litres à 60°C / Jour",null,null,null,1]
["Logements collectifs","Nombre de logements de type 4",{"$f":"'Données d''entrée'!G31","v":0},150,"Litres à 60°C / Jour",null,null,null,1.2,"?"]
["Logements collectifs","Nombre de logements de type 5",{"$f":"'Données d''entrée'!G32","v":0},200,"Litres à 60°C / Jour",null,null,null,1.4,"?"]
["Logements collectifs","Consommation journalière",0,null,null,null,null,null,null,"Aicvf"]
["Logements collectifs","C (Volume d'eau) à 60°C",{"$f":"SUMPRODUCT(Calcul2!$C$177:$C$181,Calcul2!$D$177:$D$181)","v":550},"Litres à 60°C ",null,"C=Somme ni * Ci"]
[null,"Nombre total de logements",null,{"$f":"SUM(C177:C181)","v":11}]
[{"$f":"B$176","v":"Logements collectifs"},"N",null,{"$f":"SUMPRODUCT(Calcul2!C177:C181,Calcul2!I177:I181)","v":8.8000000000000007}]
["Logements collectifs","s",null,{"$f":"0.17+1/SQRT($D$185-1)","v":0.52805743701971641}]
["Logements collectifs","Vpm",null,{"$f":"50*$D$185*$D$186","v":232.34527228867526}]
["Logements collectifs","Tpm",null,{"$f":"$C$8","v":0.16666666666666666}]
["Logements collectifs","Vph",null,{"$f":"0.75*150*$D$185","v":990.00000000000011}]
["Logements collectifs","Tph",null,{"$f":"5*$D$185^0.905/(15+$D$185^0.92)","v":1.5980134058362387}]
[{"$f":"B$194","v":"Hôtellerie"}]
["Hôtellerie","Définition des besoins",{"$f":"'Données d''entrée'!G145","v":0}]
["Hôtellerie","Profils de l'établissement"]
["Hôtellerie","Hôtellerie","Oui","Voir table"]
["Hôtellerie","Catégorie",{"$f":"'Données d''entrée'!G36","v":"Hôtel 1 *"}]
["Hôtellerie",null,{"$f":"'Données d''entrée'!G37","v":50}]
["Hôtellerie","Consommation journalière","Oui"]
["Hôtellerie","C (Volume d'eau) à 60°C",{"$f":"VLOOKUP(C195,Vol_ECS_Hotel,2,FALSE)*C196","v":3750},"Litres à 60°C ","C=Somme ni * Ci"]
["Hôtellerie","Facteur de simultaneité suivant \"guide du chauffage pour l'habitat collectif & le tertiaire\""]
["Hôtellerie","Est ce qu'il sagir du hotelde sport d'hiver, de seminaire ou de bord de mer?",{"$f":"'Données d''entrée'!G38","v":"Oui"}]
["Hôtellerie","Coefficient de simultanéité",{"$f":"IF(C200=\"oui\",0.8,0.6)","v":0.8}]
["Hôtellerie","Coefficient de simultanéité, correction manuelle",{"$f":"'Données d''entrée'!G40","v":0},"Coefficient de simultanéité retenu:",null,null,{"$f":"IF(C202=0,C201,C202)","v":0.8}]
["Hôtellerie","C (Volume d'eau) à 60°C \"probable\"",{"$f":"C198*G202","v":3000}]
["Hôtellerie"]
["Hôtellerie","N",null,{"$f":"C196","v":50}]
["Hôtellerie","s",null,{"$f":"(0.8/(D205-1)^1/2)*1.5","v":1.2244897959183675E-2},null,"Source AICVF"]
["Hôtellerie","Vpm",null,{"$f":"50*D205*D206","v":30.612244897959187}]
["Hôtellerie","Tpm",null,{"$f":"C8","v":0.16666666666666666}]
["Hôtellerie","Vph",null,{"$f":"0.75*150*D205","v":5625}]
["Hôtellerie","Tph",null,{"$f":"5*D205^0.905/(15+D205^0.92)","v":3.3434295591185639}]
[{"$f":"B$214","v":"Camping"}]
["Camping","Définition des besoins",{"$f":"'Données d''entrée'!G250","v":0}]
["Camping","Profils de l'établissement","nb de douche"]
["Camping","Camping","Oui"]
["Camping","Sanitaire collectif + lavage vaisselle",{"$f":"'Données d''entrée'!G43","v":5}]
["Camping","Consommation journalière","Oui"]
["Camping","C (Volume d'eau) à 60°C",{"$f":"SUMPRODUCT(C215,'Table ECS'!$C$194)","v":300},"Litres à 60°C ","C=Somme ni * Ci"]
["Camping","N",null,{"$f":"SUMPRODUCT(C215,C215)","v":25}]
["Camping","s",null,{"$f":"(0.8/(D218-1)^1/2)*1.5","v":2.5000000000000001E-2}]
["Camping","Vpm",null,{"$f":"50*D218*D219","v":31.25}]
["Camping","Tpm",null,{"$f":"C8","v":0.16666666666666666}]
["Camping","Vph",null,{"$f":"0.75*150*D218","v":2812.5}]
["Camping","Tph",null,{"$f":"5*D218^0.905/(15+D218^0.92)","v":2.6822758491682159}]
[{"$f":"B$227","v":"Restauration"}]
["Restauration","Définition des besoins",{"$f":"'Données d''entrée'!G314","v":0}]
["Restauration","Profils de l'établissement",{"$f":"'Données d''entrée'!G240","v":0}]
["Restauration","Restauration","Oui"]
["Restauration","Type d'etablisement de restauration",{"$f":"'Données d''entrée'!G46","v":"Traditionnelle (50 à 150 repas par jour)"}]
["Restauration","Nombre de repas",{"$f":"'Données d''entrée'!G47","v":10}]
["Restauration","Consommation journalière","Oui"]
["Restauration","C (Volume d'eau) à 60°C",{"$f":"VLOOKUP($C$228,Vol_ECS_Restauration,2,FALSE)*C229","v":120},"Litres à 60°C ","C=Somme ni * Ci"]
["Restauration","N",null,{"$f":"SUMPRODUCT(C228:C229)","v":10}]
["Restauration","s",null,{"$f":"(0.8/(D232-1)^1/2)*1.5","v":6.6666666666666666E-2}]
["Restauration","Vpm",null,{"$f":"50*D232*D233","v":33.333333333333336}]
["Restauration","Tpm",null,{"$f":"C8","v":0.16666666666666666}]
["Restauration","Vph",null,{"$f":"0.75*150*D232","v":1125}]
["Restauration","Tph",null,{"$f":"5*D232^0.905/(15+D232^0.92)","v":1.723000700464689}]
[{"$f":"B$241","v":"Santé"}]
["Santé","Définition des besoins",{"$f":"'Données d''entrée'!G361","v":0}]
["Santé","Profils de l'établissement",{"$f":"'Données d''entrée'!G287","v":0}]
["Santé","Santé","Oui"]
["Santé","Type d'etablisement de santé",{"$f":"'Données d''entrée'!G50","v":"Maison de retraite"}]
["Santé","Nombre de lits",{"$f":"'Données d''entrée'!G51","v":25}]
[{"$f":"B$241","v":"Santé"},"Consommation journalière","Oui"]
["Santé","C (Volume d'eau) à 60°C",{"$f":"VLOOKUP($C$242,'Table ECS'!$B$200:$C$203,2,FALSE)*C243","v":1000},"Litres à 60°C ","C=Somme ni * Ci"]
["Santé","N",null,{"$f":"SUMPRODUCT(C242:C243)","v":25}]
["Santé","s",null,{"$f":"(0.8/(D246-1)^1/2)*1.5","v":2.5000000000000001E-2}]
["Santé","Vpm",null,{"$f":"50*D246*D247","v":31.25}]
["Santé","Tpm",null,{"$f":"C8","v":0.16666666666666666}]
["Santé","Vph",null,{"$f":"0.75*150*D246","v":2812.5}]
["Santé","Tph",null,{"$f":"5*D246^0.905/(15+D246^0.92)","v":2.6822758491682159}]
[{"$f":"B$255","v":"Internat"}]
["Internat","Définition des besoins",{"$f":"'Données d''entrée'!G404","v":0}]
["Internat","Profils de l'établissement",{"$f":"'Données d''entrée'!G330","v":0}]
["Internat","Internat","Oui"]
["Internat","Nombre d'interne",{"$f":"'Données d''entrée'!G54","v":0}]
["Internat","Consommation journalière","Oui"]
["Internat","C (Volume d'eau) à 60°C",{"$f":"SUMPRODUCT($C$256,'Table ECS'!$C$205)","v":0},"Litres à 60°C ","C=Somme ni * Ci"]
["Internat","N",null,{"$f":"SUMPRODUCT(C256)","v":0}]
["Internat","s",null,1,null,"Source AICVF"]
["Internat","Vpm",null,{"$f":"50*D259*D260","v":0}]
["Internat","Tpm",null,{"$f":"C8","v":0.16666666666666666}]
["Internat","Vph",null,{"$f":"0.75*150*D259","v":0}]
["Internat","Tph",null,{"$f":"5*D259^0.905/(15+D259^0.92)","v":0}]
[{"$f":"B$268","v":"Sport"}]
["Sport","Définition des besoins",{"$f":"'Données d''entrée'!G222","v":0}]
["Sport","Profils de l'établissement","nb de douche"]
["Sport","Sport","Oui"]
["Sport","En salle",{"$f":"'Données d''entrée'!G57","v":0}]
["Sport","Vestiaires / Foot / rugby",{"$f":"'Données d''entrée'!G58","v":0}]
["Sport","Consommation journalière","Oui"]
["Sport","C (Volume d'eau) à 60°C",{"$f":"SUMPRODUCT(C269:C270,'Table ECS'!C207:C208)","v":0},"Litres à 60°C ","C=Somme ni * Ci"]
["Sport","N",null,{"$f":"SUMPRODUCT(C269:C270)","v":0}]
["Sport","s",null,1,null,"Source AICVF"]
["Sport","Vpm",null,{"$f":"50*D273*D274","v":0}]
["Sport","Tpm",null,{"$f":"C8","v":0.16666666666666666}]
["Sport","Vph",null,{"$f":"0.75*150*D273","v":0}]
["Sport","Tph",null,{"$f":"5*D273^0.905/(15+D273^0.92)","v":0}]

{"sheet":"TempVPM_W","index":6,"n_rows":60,"n_cols":19,"rows_kept":60,"cut":false,"hidden":true,"merged":[]}
["Code","Température de consigne","Température de stockage","Débit","Température de consigne","Température de stockage","Débit","Température de consigne","Température de stockage","Débit","Température de consigne","Température de stockage","Débit","Débit max.",null,"Delta T sur le stock",null,null,"Débit max."]
[1,50,{"$f":" 0.0071429*B2^2 + 0.042857*B2 + 32.571+2","v":54.571100000000001},{"$f":" 0.0036429*B2^2 - 0.64393*B2 + 35.35","v":12.260750000000002},55,{"$f":" 0.0071429*E2^2 + 0.042857*E2 + 32.571+2","v":58.535407499999998},{"$f":" 0.0036429*E2^2 - 0.64393*E2 + 35.35","v":10.953622500000002},60,{"$f":" 0.0071429*H2^2 + 0.042857*H2 + 32.571+2","v":62.856859999999998},{"$f":" 0.0036429*H2^2 - 0.64393*H2 + 35.35","v":9.82864},65,{"$f":" 0.0071429*K2^2 + 0.042857*K2 + 32.571+2","v":67.535457499999993},{"$f":" 0.0036429*K2^2 - 0.64393*K2 + 35.35","v":8.885802500000004},"14 l/min","VPM 20/25/2 W",{"$f":"ROUND(Q2*R2,1)","v":27.5},3.5,{"$f":"70/8.9","v":7.8651685393258424},14]
[2,50,{"$f":" 0.0064286*B3^2 + 0.096429*B3 + 34.643+2","v":57.53595},{"$f":"0.0064762*B3^2 - 1.0929*B3 + 56.952","v":18.497500000000002},55,{"$f":" 0.0064286*E3^2 + 0.096429*E3 + 34.643+2","v":61.39311},{"$f":"0.0064762*E3^2 - 1.0929*E3 + 56.952","v":16.433005000000001},60,{"$f":" 0.0064286*H3^2 + 0.096429*H3 + 34.643+2","v":65.571699999999993},{"$f":"0.0064762*H3^2 - 1.0929*H3 + 56.952","v":14.692319999999995},65,{"$f":" 0.0064286*K3^2 + 0.096429*K3 + 34.643+2","v":70.071719999999999},{"$f":"0.0064762*K3^2 - 1.0929*K3 + 56.952","v":13.275444999999998},"21 l/min","VPM 20/25/2 W",{"$f":"ROUND(Q3*R3,1)","v":33},4.2,{"$f":"70/8.9","v":7.8651685393258424},21]
[3,50,{"$f":" 0.0092857*B4^2 - 0.225*B4 + 45.714+2","v":59.678249999999991},{"$f":" 0.0079048*B4^2 - 1.3243*B4 + 68.467","v":22.013999999999996},55,{"$f":" 0.0092857*E4^2 - 0.225*E4 + 45.714+2","v":63.428242499999996},{"$f":" 0.0079048*E4^2 - 1.3243*E4 + 68.467","v":19.542519999999996},60,{"$f":" 0.0092857*H4^2 - 0.225*H4 + 45.714+2","v":67.64251999999999},{"$f":" 0.0079048*H4^2 - 1.3243*H4 + 68.467","v":17.466279999999998},65,{"$f":" 0.0092857*K4^2 - 0.225*K4 + 45.714+2","v":72.321082499999989},{"$f":" 0.0079048*K4^2 - 1.3243*K4 + 68.467","v":15.78528},"25 l/min","VPM 20/25/2 W",37.799999999999997,4.8,7.8651685393258424,23]
[4,50,{"$f":" 0.0064286*B5^2 - 0.060714*B5 + 48.571+2","v":63.6068},{"$f":" 0.0096667*B5^2 - 1.6264*B5 + 84.448","v":27.294749999999986},55,{"$f":" 0.0064286*E5^2 - 0.060714*E5 + 48.571+2","v":66.678245000000004},{"$f":" 0.0096667*E5^2 - 1.6264*E5 + 84.448","v":24.237767499999997},60,{"$f":" 0.0064286*H5^2 - 0.060714*H5 + 48.571+2","v":70.071119999999993},{"$f":" 0.0096667*H5^2 - 1.6264*H5 + 84.448","v":21.66411999999999},65,{"$f":" 0.0064286*K5^2 - 0.060714*K5 + 48.571+2","v":73.785425000000004},{"$f":" 0.0096667*K5^2 - 1.6264*K5 + 84.448","v":19.573807499999987},"31 l/min","VPM 30/35/2 W",44,5.6,7.8651685393258424,31]
[5,50,{"$f":"0.0092857*B6^2 - 0.39643*B6 + 60.571+2","v":65.96374999999999},{"$f":" 0.010714*B6^2 - 1.8136*B6 + 94.714","v":30.818999999999988},55,{"$f":"0.0092857*E6^2 - 0.39643*E6 + 60.571+2","v":68.856592499999991},{"$f":" 0.010714*E6^2 - 1.8136*E6 + 94.714","v":27.375849999999986},60,{"$f":"0.0092857*H6^2 - 0.39643*H6 + 60.571+2","v":72.213719999999995},{"$f":" 0.010714*H6^2 - 1.8136*H6 + 94.714","v":24.468400000000003},65,{"$f":"0.0092857*K6^2 - 0.39643*K6 + 60.571+2","v":76.035132500000003},{"$f":" 0.010714*K6^2 - 1.8136*K6 + 94.714","v":22.096649999999997},"35 l/min","VPM 30/35/2 W",44.8,5.7,7.8651685393258424,35]
[6,50,{"$f":" -0.00055556*B7^3 + 0.10548*B7^2 - 5.6992*B7 + 153.4+2","v":64.694999999999965},{"$f":" -0.00011111*B7^3 + 0.034143*B7^2 - 3.4827*B7 + 138.66","v":35.993750000000006},55,{"$f":" -0.00055556*E7^3 + 0.10548*E7^2 - 5.6992*E7 + 153.4+2","v":68.589705000000009},{"$f":" -0.00011111*E7^3 + 0.034143*E7^2 - 3.4827*E7 + 138.66","v":31.908148750000009},60,{"$f":" -0.00055556*H7^3 + 0.10548*H7^2 - 5.6992*H7 + 153.4+2","v":73.175039999999996},{"$f":" -0.00011111*H7^3 + 0.034143*H7^2 - 3.4827*H7 + 138.66","v":28.613040000000012},65,{"$f":" -0.00055556*K7^3 + 0.10548*K7^2 - 5.6992*K7 + 153.4+2","v":78.034335000000027},{"$f":" -0.00011111*K7^3 + 0.034143*K7^2 - 3.4827*K7 + 138.66","v":26.025091250000017},"41 l/min","VPM 40/45/2 W",44.8,5.7,7.8651685393258424,41]
[7,50,{"$f":" -0.00066667*B8^3 + 0.12667*B8^2 - 7.0333*B8 + 183.26+2","v":66.93625000000003},{"$f":" -0.00028889*B8^3 + 0.065905*B8^2 - 5.4166*B8 + 181.6","v":39.421250000000015},55,{"$f":" -0.00066667*E8^3 + 0.12667*E8^2 - 7.0333*E8 + 183.26+2","v":70.688028750000001},{"$f":" -0.00028889*E8^3 + 0.065905*E8^2 - 5.4166*E8 + 181.6","v":34.985551249999986},60,{"$f":" -0.00066667*H8^3 + 0.12667*H8^2 - 7.0333*H8 + 183.26+2","v":75.27328},{"$f":" -0.00028889*H8^3 + 0.065905*H8^2 - 5.4166*H8 + 181.6","v":31.461760000000027},65,{"$f":" -0.00066667*K8^3 + 0.12667*K8^2 - 7.0333*K8 + 183.26+2","v":80.192001249999976},{"$f":" -0.00028889*K8^3 + 0.065905*K8^2 - 5.4166*K8 + 181.6","v":28.633208750000023},"45 l/min","VPM 40/45/2 W",44.8,5.7,7.8651685393258424,45]
[8,50,{"$f":" 0.0092857*B9^2 - 0.225*B9 + 45.714+2","v":59.678249999999991},{"$f":"( 0.0079048*B9^2 - 1.3243*B9 + 68.467)*2","v":44.027999999999992},55,{"$f":" 0.0092857*E9^2 - 0.225*E9 + 45.714+2","v":63.428242499999996},{"$f":"( 0.0079048*E9^2 - 1.3243*E9 + 68.467)*2","v":39.085039999999992},60,{"$f":" 0.0092857*H9^2 - 0.225*H9 + 45.714+2","v":67.64251999999999},{"$f":"( 0.0079048*H9^2 - 1.3243*H9 + 68.467)*2","v":34.932559999999995},65,{"$f":" 0.0092857*K9^2 - 0.225*K9 + 45.714+2","v":72.321082499999989},{"$f":"( 0.0079048*K9^2 - 1.3243*K9 + 68.467)*2","v":31.57056},"2x 25 l/min","2x VPM 20/25/2 W",44.8,5.7,7.8651685393258424]
[9,50,{"$f":"0.0092857*B10^2 - 0.39643*B10 + 60.571+2","v":65.96374999999999},{"$f":" (0.010714*B10^2 - 1.8136*B10 + 94.714)+(0.0079048*B10^2 - 1.3243*B10 + 68.467)","v":52.832999999999984},55,{"$f":"0.0092857*E10^2 - 0.39643*E10 + 60.571+2","v":68.856592499999991},{"$f":" (0.010714*E10^2 - 1.8136*E10 + 94.714)+(0.0079048*E10^2 - 1.3243*E10 + 68.467)","v":46.918369999999982},60,{"$f":"0.0092857*H10^2 - 0.39643*H10 + 60.571+2","v":72.213719999999995},{"$f":" (0.010714*H10^2 - 1.8136*H10 + 94.714)+(0.0079048*H10^2 - 1.3243*H10 + 68.467)","v":41.93468},65,{"$f":"0.0092857*K10^2 - 0.39643*K10 + 60.571+2","v":76.035132500000003},{"$f":" (0.010714*K10^2 - 1.8136*K10 + 94.714)+(0.0079048*K10^2 - 1.3243*K10 + 68.467)","v":37.881929999999997},"25 l/min + 35 l/min","VPM 30/35/2 W + VPM 20/25/2 W",44.8,5.7,7.8651685393258424]
[10,50,{"$f":"0.0092857*B11^2 - 0.39643*B11 + 60.571+2","v":65.96374999999999},{"$f":" (0.010714*B11^2 - 1.8136*B11 + 94.714)*2","v":61.637999999999977},55,68.856592499999991,{"$f":" (0.010714*E11^2 - 1.8136*E11 + 94.714)*2","v":54.751699999999971},60,72.213719999999995,{"$f":" (0.010714*H11^2 - 1.8136*H11 + 94.714)*2","v":48.936800000000005},65,76.035132500000003,{"$f":" (0.010714*K11^2 - 1.8136*K11 + 94.714)*2","v":44.193299999999994},"2x 35 l/min","2x VPM 30/35/2 W",44.8,5.7,7.8651685393258424]
[11,50,{"$f":" 0.0092857*B12^2 - 0.225*B12 + 45.714+2","v":59.678249999999991},{"$f":"( 0.0079048*B12^2 - 1.3243*B12 + 68.467)*3","v":66.041999999999987},55,{"$f":" 0.0092857*E12^2 - 0.225*E12 + 45.714+2","v":63.428242499999996},{"$f":"( 0.0079048*E12^2 - 1.3243*E12 + 68.467)*3","v":58.627559999999988},60,{"$f":" 0.0092857*H12^2 - 0.225*H12 + 45.714+2","v":67.64251999999999},{"$f":"( 0.0079048*H12^2 - 1.3243*H12 + 68.467)*3","v":52.398839999999993},65,{"$f":" 0.0092857*K12^2 - 0.225*K12 + 45.714+2","v":72.321082499999989},{"$f":"( 0.0079048*K12^2 - 1.3243*K12 + 68.467)*3","v":47.355840000000001},"3x 25 l/min","3x VPM 20/25/2 W",44.8,5.7,7.8651685393258424]
[12,50,{"$f":"0.0092857*B13^2 - 0.39643*B13 + 60.571+2","v":65.96374999999999},{"$f":" (0.010714*B13^2 - 1.8136*B13 + 94.714)+(0.0079048*B13^2 - 1.3243*B13 + 68.467)*2","v":74.84699999999998},55,68.856592499999991,{"$f":" (0.010714*E13^2 - 1.8136*E13 + 94.714)+(0.0079048*E13^2 - 1.3243*E13 + 68.467)*2","v":66.460889999999978},60,72.213719999999995,{"$f":" (0.010714*H13^2 - 1.8136*H13 + 94.714)+(0.0079048*H13^2 - 1.3243*H13 + 68.467)*2","v":59.400959999999998},65,76.035132500000003,{"$f":" (0.010714*K13^2 - 1.8136*K13 + 94.714)+(0.0079048*K13^2 - 1.3243*K13 + 68.467)*2","v":53.667209999999997},"2x 25 l/min + 35 l/min","VPM 30/35/2 W + 2x VPM 20/25/2 W",44.8,5.7,7.8651685393258424]
[13,50,{"$f":" -0.00066667*B14^3 + 0.12667*B14^2 - 7.0333*B14 + 183.26+2","v":66.93625000000003},{"$f":" (-0.00028889*B14^3 + 0.065905*B14^2 - 5.4166*B14 + 181.6)*2","v":78.84250000000003},55,{"$f":" -0.00066667*E14^3 + 0.12667*E14^2 - 7.0333*E14 + 183.26+2","v":70.688028750000001},{"$f":" (-0.00028889*E14^3 + 0.065905*E14^2 - 5.4166*E14 + 181.6)*2","v":69.971102499999972},60,{"$f":" -0.00066667*H14^3 + 0.12667*H14^2 - 7.0333*H14 + 183.26+2","v":75.27328},{"$f":" (-0.00028889*H14^3 + 0.065905*H14^2 - 5.4166*H14 + 181.6)*2","v":62.923520000000053},65,{"$f":" -0.00066667*K14^3 + 0.12667*K14^2 - 7.0333*K14 + 183.26+2","v":80.192001249999976},{"$f":" (-0.00028889*K14^3 + 0.065905*K14^2 - 5.4166*K14 + 181.6)*2","v":57.266417500000045},"2x 45 l/min ","2x VPM 40/45/2 W",44.8,5.7,7.8651685393258424]
[14,50,{"$f":"0.0092857*B15^2 - 0.39643*B15 + 60.571+2","v":65.96374999999999},{"$f":" (0.010714*B15^2 - 1.8136*B15 + 94.714)*2+(0.0079048*B15^2 - 1.3243*B15 + 68.467)","v":83.651999999999973},55,{"$f":"0.0092857*E15^2 - 0.39643*E15 + 60.571+2","v":68.856592499999991},{"$f":" (0.010714*E15^2 - 1.8136*E15 + 94.714)*2+(0.0079048*E15^2 - 1.3243*E15 + 68.467)","v":74.294219999999967},60,{"$f":"0.0092857*H15^2 - 0.39643*H15 + 60.571+2","v":72.213719999999995},{"$f":" (0.010714*H15^2 - 1.8136*H15 + 94.714)*2+(0.0079048*H15^2 - 1.3243*H15 + 68.467)","v":66.403080000000003},65,{"$f":"0.0092857*K15^2 - 0.39643*K15 + 60.571+2","v":76.035132500000003},{"$f":" (0.010714*K15^2 - 1.8136*K15 + 94.714)*2+(0.0079048*K15^2 - 1.3243*K15 + 68.467)","v":59.978579999999994},"25 l/min+ 2x35 l/min","2x VPM 30/35/2 W + VPM 20/25/2 W",44.8,5.7,7.8651685393258424]
[15,50,{"$f":"0.0092857*B16^2 - 0.39643*B16 + 60.571+2","v":65.96374999999999},{"$f":" (0.010714*B16^2 - 1.8136*B16 + 94.714)*3","v":92.456999999999965},55,68.856592499999991,{"$f":" (0.010714*E16^2 - 1.8136*E16 + 94.714)*3","v":82.127549999999957},60,72.213719999999995,{"$f":" (0.010714*H16^2 - 1.8136*H16 + 94.714)*3","v":73.405200000000008},65,76.035132500000003,{"$f":" (0.010714*K16^2 - 1.8136*K16 + 94.714)*3","v":66.28994999999999},"3x 35 l/min","3x VPM 30/35/2 W",44.8,5.7,7.8651685393258424]
[16,50,{"$f":"0.0092857*B17^2 - 0.39643*B17 + 60.571+2","v":65.96374999999999},{"$f":" (0.010714*B17^2 - 1.8136*B17 + 94.714)+(0.0079048*B17^2 - 1.3243*B17 + 68.467)*3","v":96.860999999999976},55,68.856592499999991,{"$f":" (0.010714*E17^2 - 1.8136*E17 + 94.714)+(0.0079048*E17^2 - 1.3243*E17 + 68.467)*3","v":86.003409999999974},60,72.213719999999995,{"$f":" (0.010714*H17^2 - 1.8136*H17 + 94.714)+(0.0079048*H17^2 - 1.3243*H17 + 68.467)*3","v":76.867239999999995},65,76.035132500000003,{"$f":" (0.010714*K17^2 - 1.8136*K17 + 94.714)+(0.0079048*K17^2 - 1.3243*K17 + 68.467)*3","v":69.452489999999997},"3x 25 l/min + 35 l/min","VPM 30/35/2 W + 3x VPM 20/25/2 W",44.8,5.7,7.8651685393258424]
[17,50,{"$f":"0.0092857*B18^2 - 0.39643*B18 + 60.571+2","v":65.96374999999999},{"$f":" (0.010714*B18^2 - 1.8136*B18 + 94.714)*2+(0.0079048*B18^2 - 1.3243*B18 + 68.467)*2","v":105.66599999999997},55,68.856592499999991,{"$f":" (0.010714*E18^2 - 1.8136*E18 + 94.714)*2+(0.0079048*E18^2 - 1.3243*E18 + 68.467)*2","v":93.836739999999963},60,72.213719999999995,{"$f":" (0.010714*H18^2 - 1.8136*H18 + 94.714)*2+(0.0079048*H18^2 - 1.3243*H18 + 68.467)*2","v":83.86936},65,76.035132500000003,{"$f":" (0.010714*K18^2 - 1.8136*K18 + 94.714)*2+(0.0079048*K18^2 - 1.3243*K18 + 68.467)*2","v":75.763859999999994},"2x 25 l/min +2x 35 l/min","2x VPM 30/35/2 W + 2x VPM 20/25/2 W",44.8,5.7,7.8651685393258424]
[18,50,{"$f":"0.0092857*B19^2 - 0.39643*B19 + 60.571+2","v":65.96374999999999},{"$f":" (0.010714*B19^2 - 1.8136*B19 + 94.714)*3+(0.0079048*B19^2 - 1.3243*B19 + 68.467)","v":114.47099999999996},55,68.856592499999991,{"$f":" (0.010714*E19^2 - 1.8136*E19 + 94.714)*3+(0.0079048*E19^2 - 1.3243*E19 + 68.467)","v":101.67006999999995},60,72.213719999999995,{"$f":" (0.010714*H19^2 - 1.8136*H19 + 94.714)*3+(0.0079048*H19^2 - 1.3243*H19 + 68.467)","v":90.871480000000005},65,76.035132500000003,{"$f":" (0.010714*K19^2 - 1.8136*K19 + 94.714)*3+(0.0079048*K19^2 - 1.3243*K19 + 68.467)","v":82.075229999999991},"25 l/min+ 3x35 l/min","3x VPM 30/35/2 W + VPM 20/25/2 W",44.8,5.7,7.8651685393258424]
[19,50,{"$f":" -0.00066667*B20^3 + 0.12667*B20^2 - 7.0333*B20 + 183.26+2","v":66.93625000000003},{"$f":" (-0.00028889*B20^3 + 0.065905*B20^2 - 5.4166*B20 + 181.6)*3","v":118.26375000000004},55,{"$f":" -0.00066667*E20^3 + 0.12667*E20^2 - 7.0333*E20 + 183.26+2","v":70.688028750000001},{"$f":" (-0.00028889*E20^3 + 0.065905*E20^2 - 5.4166*E20 + 181.6)*3","v":104.95665374999996},60,{"$f":" -0.00066667*H20^3 + 0.12667*H20^2 - 7.0333*H20 + 183.26+2","v":75.27328},{"$f":" (-0.00028889*H20^3 + 0.065905*H20^2 - 5.4166*H20 + 181.6)*3","v":94.38528000000008},65,{"$f":" -0.00066667*K20^3 + 0.12667*K20^2 - 7.0333*K20 + 183.26+2","v":80.192001249999976},{"$f":" (-0.00028889*K20^3 + 0.065905*K20^2 - 5.4166*K20 + 181.6)*3","v":85.899626250000068},"3x 45 l/min","3x VPM 40/45/2 W",44.8,5.7,7.8651685393258424]
[20,50,{"$f":"0.0092857*B21^2 - 0.39643*B21 + 60.571+2","v":65.96374999999999},{"$f":" (0.010714*B21^2 - 1.8136*B21 + 94.714)*4","v":123.27599999999995},55,{"$f":"0.0092857*E21^2 - 0.39643*E21 + 60.571+2","v":68.856592499999991},{"$f":" (0.010714*E21^2 - 1.8136*E21 + 94.714)*4","v":109.50339999999994},60,{"$f":"0.0092857*H21^2 - 0.39643*H21 + 60.571+2","v":72.213719999999995},{"$f":" (0.010714*H21^2 - 1.8136*H21 + 94.714)*4","v":97.87360000000001},65,{"$f":"0.0092857*K21^2 - 0.39643*K21 + 60.571+2","v":76.035132500000003},{"$f":" (0.010714*K21^2 - 1.8136*K21 + 94.714)*4","v":88.386599999999987},"4x 35 l/min","4x VPM 30/35/2 W",44.8,5.7,7.8651685393258424]
[21,50,{"$f":" -0.00066667*B22^3 + 0.12667*B22^2 - 7.0333*B22 + 183.26+2","v":66.93625000000003},{"$f":" (-0.00028889*B22^3 + 0.065905*B22^2 - 5.4166*B22 + 181.6)*4","v":157.68500000000006},55,{"$f":" -0.00066667*E22^3 + 0.12667*E22^2 - 7.0333*E22 + 183.26+2","v":70.688028750000001},{"$f":" (-0.00028889*E22^3 + 0.065905*E22^2 - 5.4166*E22 + 181.6)*4","v":139.94220499999994},60,{"$f":" -0.00066667*H22^3 + 0.12667*H22^2 - 7.0333*H22 + 183.26+2","v":75.27328},{"$f":" (-0.00028889*H22^3 + 0.065905*H22^2 - 5.4166*H22 + 181.6)*4","v":125.84704000000011},65,{"$f":" -0.00066667*K22^3 + 0.12667*K22^2 - 7.0333*K22 + 183.26+2","v":80.192001249999976},{"$f":" (-0.00028889*K22^3 + 0.065905*K22^2 - 5.4166*K22 + 181.6)*4","v":114.53283500000009},"4x 45 l/min","4x VPM 40/45/2 W",44.8,5.7,7.8651685393258424]
["Table du \"code\" 1 à 21 en fonction de la température de consigne 50 55 60 65 et du débit"]
[null,"index T°","index Débit",null,null,null,null,null,"Température de stockage","Débit",null,"Débit max."]
[50,3,4,null,null,null,{"$f":"IF($B$37<J25,1,0)","v":0},{"$f":"IF($B$31<J25,1,0)","v":0},{"$f":"INDEX(Temperature,K25,$B$29)","v":62.856859999999998},{"$f":"INDEX(Temperature,K25,$B$30)","v":9.82864},1,"14 l/min","VPM 20/25/2 W",60,14]
[55,6,7,null,null,null,1,{"$f":"IF($B$31<J26,1,0)","v":0},{"$f":"INDEX(Temperature,K26,$B$29)","v":65.571699999999993},{"$f":"INDEX(Temperature,K26,$B$30)","v":14.692319999999995},2,"21 l/min","VPM 20/25/2 W",60,21]
[60,9,10,null,null,null,1,0,67.64251999999999,{"$f":"INDEX(Temperature,K27,$B$30)","v":17.466279999999998},3,"25 l/min","VPM 20/25/2 W",60,25]
[65,12,13,null,null,null,1,0,70.071119999999993,21.66411999999999,4,"31 l/min","VPM 30/35/2 W",85]
["index T°",{"$f":"VLOOKUP(Calcul2!D119,TempVPM_W!$A$25:$C$28,2,FALSE)","v":9},null,null,null,null,1,0,72.213719999999995,24.468400000000003,5,"35 l/min","VPM 30/35/2 W",85]
["index Débit",{"$f":"VLOOKUP(Calcul2!D119,TempVPM_W!$A$25:$C$28,3,FALSE)","v":10},null,null,null,null,1,{"$f":"IF($B$31<J30,1,0)","v":0},73.175039999999996,28.613040000000012,6,"41 l/min","VPM 40/45/2 W",109]
["DébitECS sur t10 =",{"$f":"Calcul2!F126","v":29.65290491639999},"l /mn",null,null,null,1,1,75.27328,31.461760000000027,7,"45 l/min","VPM 40/45/2 W",109]
["TD2Mini.t10 =",{"$f":"VLOOKUP(1,H25:I45,2,FALSE)","v":75.27328},"°C",null,null,"10 logts",1,1,67.64251999999999,34.932559999999995,8,"2x 25 l/min","2x VPM 20/25/2 W",120,{"$f":"50","v":50}]
["Module aguaFLOW",{"$f":"VLOOKUP(1,H25:M45,6,FALSE)","v":"VPM 40/45/2 W"},null,null,null,null,1,1,{"$f":"INDEX(Temperature,K33,$B$29)","v":72.213719999999995},{"$f":"INDEX(Temperature,K33,$B$30)","v":41.93468},9,"25 l/min + 35 l/min","VPM 30/35/2 W + VPM 20/25/2 W",{"$f":"60+85","v":145},60]
["\"Puissance\"",{"$f":"VLOOKUP(1,H25:N45,7,FALSE)","v":109},"kW",null,null,null,1,{"$f":"IF($B$31<J34,1,0)","v":1},72.213719999999995,48.936800000000005,10,"2x 35 l/min","2x VPM 30/35/2 W",170,70]
[null,null,null,null,null,"20 logts",1,1,67.64251999999999,52.398839999999993,11,"3x 25 l/min","3x VPM 20/25/2 W",180,75]
[null,null,null,null,null,null,1,1,72.213719999999995,59.400959999999998,12,"2x 25 l/min + 35 l/min","VPM 30/35/2 W + 2x VPM 20/25/2 W",{"$f":"85+60+60","v":205},85]
["DébitECS sur th =",{"$f":"Calcul2!F132","v":13.177618518603182},"l /mn",null,null,null,1,1,75.27328,62.923520000000053,13,"2x 45 l/min ","2x VPM 40/45/2 W",218,90]
["TD2Mini.tc =",{"$f":"VLOOKUP(1,G25:I45,3,FALSE)","v":65.571699999999993},"°C",null,null,null,1,1,72.213719999999995,66.403080000000003,14,"25 l/min+ 2x35 l/min","2x VPM 30/35/2 W + VPM 20/25/2 W",{"$f":"2*85+60","v":230},95]
["Module aguaFLOW",{"$f":"VLOOKUP(1,G25:M45,7,FALSE)","v":"VPM 20/25/2 W"},null,null,null,"30 logts",1,1,72.213719999999995,73.405200000000008,15,"3x 35 l/min","3x VPM 30/35/2 W",{"$f":"3*85","v":255},105]
[null,null,null,null,null,null,1,1,72.213719999999995,76.867239999999995,16,"3x 25 l/min + 35 l/min","VPM 30/35/2 W + 3x VPM 20/25/2 W",{"$f":"85+3*60","v":265},110]
[null,null,null,null,null,null,1,1,72.213719999999995,83.86936,17,"2x 25 l/min +2x 35 l/min","2x VPM 30/35/2 W + 2x VPM 20/25/2 W",{"$f":"2*85+2*60","v":290},120]
[null,null,null,null,null,null,1,1,72.213719999999995,90.871480000000005,18,"25 l/min+ 3x35 l/min","3x VPM 30/35/2 W + VPM 20/25/2 W",{"$f":"3*85+60","v":315},130]
[null,null,null,null,null,null,1,1,75.27328,94.38528000000008,19,"3x 45 l/min","3x VPM 40/45/2 W",{"$f":"3*109","v":327},{"$f":"3*45","v":135}]
[null,null,null,null,null,null,1,1,72.213719999999995,97.87360000000001,20,"4x 35 l/min","4x VPM 30/35/2 W",{"$f":"4*85","v":340},{"$f":"4*35","v":140}]
[null,null,null,null,null,"50 logts",1,1,75.27328,125.84704000000011,21,"4x 45 l/min","4x VPM 40/45/2 W",{"$f":"4*109","v":436},{"$f":"4*45","v":180}]
[]
[]
[]
[]
[1,"VPS 300/3-7","VPS 300/3-5",152,303,303,303]
[2,"VPS 500/3-7","VPS 500/3-5",246,491,491,491]
[3,"VPS 800/3-7","VPS 800/3-5",390,778,778,778]
[4,"VPS 1000/3-7","VPS 1000/3-5",481,962,962,962]
[5,"VPS 1500/3-7","VPS 1500/3-5",743,1505,1505,1505]
[6,"VPS 2000/3-7","VPS 2000/3-5",959,1917,1917,1917]
[null,null,"VPS 1500/3-5 + VPS 1000/3-5",null,null,2467,2467]
[null,null,"2x VPS 1500/3-5",null,null,3010,3010]
[null,null,"VPS 2000/3-5 + VPS 1500/3-5",null,null,3422,3422]
[null,null,"2x VPS 2000/3-5",null,null,3834,3834]
[null,"allSTOR exclusiv","allSTOR plus","Volume utile = env 50% volume stokage","Volume de stockage brut VPS/3-7","Volume utile = volume de stockage","Volume de stockage brut VPS/3-5"]

{"sheet":"Offre","index":7,"n_rows":91,"n_cols":13,"rows_kept":91,"cut":false,"hidden":true,"merged":[]}
["Report des informations"]
["Ballon :",{"$f":"Calcul2!AD52","v":"VIHR 400"},null,null,null,"Données d'entrées de la feuille"]
["auroFLOW :",{"$f":"Calcul2!AD53","v":""},null,null,null,"Données d'entrées de la feuille"]
["Liste des solutions","Références corespondantes","Qté","Références corespondantes","Qté"]
["VIHR 300","0010003077",1]
["VIHR 400","0010003078",1]
["VIHR 500","0010003079",1]
["VIHR 750 ","0010014931",1]
["VIHR 1000","0010014932",1]
["VIHR 1500","0010014933",1]
["VIHR 2000","0010014934",1]
["VIHR 1000 +VIHR 1500","0010014932",1,"0010014933",1]
["2x VIHR 1500","0010014933",2]
["VIHR 1500 + VIHR 2000","0010014933",1,"0010014934",1]
["2x VIHR 2000","0010014934",2]
["VPS 300","0010015118",1]
["VPS 500","0010015119",1]
["VPS 800","0010015120",1]
["VPS 1000","0010015121",1]
["VPS 1500","0010015122",1]
["VPS 2000","0010015123",1]
["VPS 1500 + VPS 1000","0010015122",1,"0010015121",1]
["2x VPS 1500","0010015122",2]
["VPS 2000+ VPS 1500","0010015123",1,"0010015122",1]
["2x VPS 2000","0010015123",2]
["VPM 20/25/2 W","0010014311",1]
["Support fix. mur 1 VPM W (avec collect.)",10014300,"1"]
["Kit pompe circulation interne pour VPM W",10015144,"1"]
["Kit raccord et tube pour pompe externe",10015145,"1"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["VPM 30/35/2 W","0010014312",1]
["VPM 40/45/2 W","0010014313",1]
["2x VPM 20/25/2 W","0010014311",2]
["VPM 30/35/2 W + VPM 20/25/2 W","0010014311",1,"0010014312",1]
["2x VPM 30/35/2 W","0010014312",2]
["3x VPM 20/25/2 W","0010014311",3]
["VPM 30/35/2 W + 2x VPM 20/25/2 W","0010014312",1,"0010014311",2]
["2x VPM 40/45/2 W","0010014313",2]
["2x VPM 30/35/2 W + VPM 20/25/2 W","0010014312",2,"0010014311",1]
["3x VPM 30/35/2 W","0010014312",3]
["VPM 30/35/2 W + 3x VPM 20/25/2 W","0010014312",1,"0010014311",3]
["2x VPM 30/35/2 W + 2x VPM 20/25/2 W","0010014312",2,"0010014311",2]
["3x VPM 30/35/2 W + VPM 20/25/2 W","0010014312",3,"0010014311",1]
["3x VPM 40/45/2 W","0010014313",3]
["4x VPM 30/35/2 W","0010014312",4]
["4x VPM 40/45/2 W","0010014313",4]
[]
["Liste de produit","Références","Qté"]
[1,{"$f":"VLOOKUP($B$2,$A$5:$E$25,2,FALSE)","v":"0010003078"},{"$f":"VLOOKUP($B$2,$A$5:$E$25,3,FALSE)","v":1},null,null,"Recherche ballon 1"]
[{"$f":"IF(B62=0,\"\",MAX($A$61:$A61)+1)","v":""},{"$f":"VLOOKUP($B$2,$A$5:$E$25,4,FALSE)","v":0},{"$f":"VLOOKUP($B$2,$A$5:$E$58,5,FALSE)","v":0},null,null,"Recherche ballon 2"]
[{"$f":"IF(B63=0,\"\",MAX($A$61:$A62)+1)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($B$3,A26:E58,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($B$3,$A$26:$E$58,3,FALSE)","v":{"$error":"#N/A"}},null,null,"Recherche aguaFLOW 1"]
[null,null,null,null,null,"Recherche accessoires aguaFLOW 1"]
[{"$f":"IF(B65=0,\"\",MAX($A$61:$A63)+1)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($B$3,$A$26:$E$58,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($B$3,$A$26:$E$58,5,FALSE)","v":{"$error":"#N/A"}},null,null,"Recherche aguaFLOW 2"]
[]
["Liste de produit sans \"vide\"","Références","Qté"]
[1,{"$f":"IF(ISERROR(VLOOKUP($A68,$A$61:$C$65,2,FALSE))=TRUE,\"\",VLOOKUP($A68,$A$61:$C$65,2,FALSE))","v":"0010003078"},{"$f":"IF(ISERROR(VLOOKUP($A68,$A$61:$C$65,3,FALSE))=TRUE,\"\",VLOOKUP($A68,$A$61:$C$65,3,FALSE))","v":1},null,null,"Données de sorties de la feuille"]
[2,{"$f":"IF(ISERROR(VLOOKUP($A69,$A$61:$C$65,2,FALSE))=TRUE,\"\",VLOOKUP($A69,$A$61:$C$65,2,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP($A69,$A$61:$C$65,3,FALSE))=TRUE,\"\",VLOOKUP($A69,$A$61:$C$65,3,FALSE))","v":""},null,null,"Données de sorties de la feuille"]
[3,{"$f":"IF(ISERROR(VLOOKUP($A70,$A$61:$C$65,2,FALSE))=TRUE,\"\",VLOOKUP($A70,$A$61:$C$65,2,FALSE))","v":""},"",null,null,"Données de sorties de la feuille"]
[4,{"$f":"IF(ISERROR(VLOOKUP($A71,$A$61:$C$65,2,FALSE))=TRUE,\"\",VLOOKUP($A71,$A$61:$C$65,2,FALSE))","v":""},"",null,null,"Données de sorties de la feuille"]
[]
[null,null,null,"aguaFLOW exclusiv VPM 20/25/2 W","aguaFLOW exclusiv VPM 30/35/2 W","aguaFLOW exclusiv VPM 40/45/2 W","Vanne motorisée cascade module VPM W","Support fix. mur 1 VPM W (avec collect.)","Support fix. mur 2 VPM W (avec collect.)","Support fix. mur extens 1 VPM W (collect)","Kit pompe circulation interne pour VPM W","Kit raccord et tube pour pompe externe","nb station sanitaire"]
[null,null,null,10014311,10014312,10014313,10015146,10014300,10014301,10014303,10015144,10015145]
[1,"VPM 20/25/2 W",1,10014311,null,null,null,1,null,null,1,1,1]
[2,"VPM 30/35/2 W",2,null,1,null,null,1,null,null,1,1,1]
[3,"VPM 40/45/2 W",3,null,null,1,null,1,null,null,1,1,1]
[4,"2x VPM 20/25/2 W",4,2,null,null,2,null,1,null,2,2,2]
[5,"VPM 30/35/2 W + VPM 20/25/2 W",5,10014311,1,null,2,null,1,null,2,2,2]
[6,"2x VPM 30/35/2 W",6,null,2,null,2,null,1,null,2,2,2]
[7,"3x VPM 20/25/2 W",7,3,null,null,3,null,1,1,3,3,3]
[8,"VPM 30/35/2 W + 2x VPM 20/25/2 W",8,2,1,null,3,null,1,1,3,3,3]
[9,"2x VPM 40/45/2 W",9,null,null,2,2,null,1,null,2,2,2]
[10,"2x VPM 30/35/2 W + VPM 20/25/2 W",10,10014311,2,null,3,null,1,1,3,3,3]
[11,"3x VPM 30/35/2 W",11,null,3,null,3,null,1,1,3,3,3]
[12,"VPM 30/35/2 W + 3x VPM 20/25/2 W",12,3,1,null,4,null,1,2,4,4,4]
[13,"2x VPM 30/35/2 W + 2x VPM 20/25/2 W",13,2,2,null,4,null,1,2,4,4,4]
[14,"3x VPM 30/35/2 W + VPM 20/25/2 W",14,10014311,3,null,4,null,1,2,4,4,4]
[15,"3x VPM 40/45/2 W",15,null,null,3,3,null,1,1,3,3,3]
[16,"4x VPM 30/35/2 W",16,null,4,null,4,null,1,2,4,4,4]
[17,"4x VPM 40/45/2 W",17,null,null,4,4,null,1,2,4,4,4]