{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["simulateur","table_simulateur","Feuil1","Feuil2"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":49,"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":"simulateur","index":0,"n_rows":182,"n_cols":13,"rows_kept":182,"cut":false,"hidden":false,"merged":[[112,2,112,5],[113,2,113,5],[114,2,114,5],[115,2,115,5],[98,2,98,5],[99,2,99,5],[100,2,100,5],[101,2,101,5],[102,2,102,5],[154,2,154,5],[103,2,103,5],[135,2,135,5],[132,2,132,5],[131,2,131,5],[128,2,128,5],[125,2,125,5],[122,2,122,5],[116,2,116,5],[104,2,104,5],[105,2,105,5],[106,2,106,5],[107,2,107,5],[108,2,108,5],[109,2,109,5],[110,2,110,5],[140,2,140,5],[149,2,149,5],[148,2,148,5],[152,2,152,5],[153,2,153,5],[97,2,97,5],[176,2,176,5],[147,2,147,5],[151,2,151,5],[161,2,161,5],[166,2,166,5],[168,2,168,5],[170,2,170,5],[171,2,171,5],[162,2,162,5],[156,2,156,5],[157,2,157,5],[158,2,158,5],[159,2,159,5],[138,2,138,5],[139,2,139,5],[79,2,79,4],[80,2,80,4],[81,2,81,4],[83,2,83,4],[84,2,84,4],[67,2,67,5],[68,2,68,5],[57,2,57,5],[60,2,60,5],[61,2,61,5],[62,2,62,5],[65,2,65,5],[66,2,66,5]]}
[null,"Sélection type de bien :",null,null,"Logement (étage)"]
[]
[null,"Entrée :",null,1,null,null,null,null,null,"Montant total TTC :",null,{"$f":"I182","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"L3/D10","v":{"$error":"#REF!"}},{"$f":"3500000/table_simulateur!C21","v":289.29540863389781}]
[null,"Etage :",null,"1er étage"]
[null,null,null,null,null,null,null,null,null,{"$f":"B44","v":"1 - Honoraires"},null,null,{"$f":"SUM(I45:I51)","v":{"$error":"#REF!"}}]
[null,{"$f":"IF(bien=table_simulateur!A3,\"N° Bureau :\",IF(bien=table_simulateur!A2,\"N° appartement :\",\"\"))","v":"N° appartement :"},null,"Apt 111",null,null,null,null,null,{"$f":"B54","v":"2- Travaux d'Etanchéité des loggias, garde-corps"},null,null,{"$f":"SUM(I56:I69)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,{"$f":"B71","v":"3 - Remplacement des chassis"},null,null,{"$f":"SUM(I71:I86)","v":{"$error":"#REF!"}}]
[null,"Typologie :",null,{"$f":"IF(table_simulateur!B20<>\"\",table_simulateur!B20,\"\")","v":"Type IVbis"},null,null,null,null,null,{"$f":"B88","v":"4 - Isolation et ravalement de façade"},null,null,{"$f":"SUM(I89:I118)","v":{"$error":"#N/A"}}]
[null,"Surface :",null,{"$f":"IF(table_simulateur!B21<>\"\",table_simulateur!B21,\"\")","v":98.72},null,null,null,null,null,{"$f":"B120","v":"5 - Isolation de la toiture"},null,null,{"$f":"SUM(I121:I143)","v":{"$error":"#N/A"}}]
[null,"Tantièmes :",null,{"$f":"IF(table_simulateur!B24<>\"\",table_simulateur!B24,\"\")","v":8.1600000000000006E-3},"mettre en valeur numerique",null,null,null,null,{"$f":"B144","v":"6 - Traitement des Rez-de-Chaussée"},null,null,{"$f":"SUM(I144:I173)","v":{"$error":"#REF!"}}]
[null,"Surface des loggias :",null,{"$f":"IF(table_simulateur!B25<>\"\",table_simulateur!B25,\"\")","v":12.71},null,null,null,null,null,{"$f":"B174","v":"7 - Traitement des Sous-sols"},null,null,{"$f":"SUM(I174:I177)","v":{"$error":"#REF!"}}]
[null,"Lineaire de garde-corps :",null,{"$f":"IF(table_simulateur!B26<>\"\",table_simulateur!B26,\"\")","v":6.75},null,null,null,null,null,null,null,null,{"$f":"SUM(M6:M12)","v":{"$error":"#REF!"}}]
[null,"Surface chassis Mormal :",null,{"$f":"IF(table_simulateur!B27<>\"\",table_simulateur!B27,\"\")","v":15.34}]
[null,"Surface chassis parc et pignon :",null,{"$f":"IF(table_simulateur!B28<>\"\",table_simulateur!B28,\"\")","v":14.3}]
[]
[]
["Financement"]
[]
[null,null,"Montant des travaux :",{"$f":"SUMIF(table_simulateur!O186:O377,\"oui\",table_simulateur!J186:J377)","v":48583.930009575335},"TTC"]
[null,null,"Ecopret :",23440.81,"TTC sur 10 ans"]
[null,null,"Solde à financer :",{"$f":"cout_travaux-ecopret","v":25143.120009575334}]
[null,null,"Taux du prêt :","3,25%"]
[null,null,"Taux de l'assurance du prêt :","0,25%"]
[null,null,"Durée du prêt :","10","ans"]
[]
[null,null,"Coût de la mensualité :",{"$f":"ecopret/120+IF(ISERROR((D22*(D23+D24)/12)/(1-(1+(D23+D24)/12)^(-12*D25))),\"\",IF(AND(taux_pret<>\"\",taux_assurance<>\"\",duree_pret<>\"\"),(D22*(D23+D24)/12)/(1-(1+(D23+D24)/12)^(-12*D25)),\"\"))","v":443.97000661789343}]
[null,null,"Coût total du prêt (compris assurance) :",{"$f":"IF(ISERROR(D25*12*D27-D22),\"\",IF(AND(taux_pret<>\"\",taux_assurance<>\"\",duree_pret<>\"\"),D25*12*D27-D22-ecopret,\"\"))","v":4692.4707845718731}]
[]
["Valeur du bien"]
[null,null,"valeur fonciere actuelle",2400,{"$f":"ROUND(D31*D10,-2)","v":236900}]
[null,null,"valeur fonciere envisagée",3000,{"$f":"ROUND(D32*D10,-2)","v":296200}]
[null,null,"évolution de l'immobilier",0.02,"/an"]
[]
["Economies de charges"]
[null,null,"consommation actuelle",{"$f":"166*D10/0.865","v":18945.109826589596}]
[null,null,"consommation future",{"$f":"109*D10/0.865","v":12439.8612716763}]
[null,null,"cout kWh actuel gaz",0.05,"€ TTC/kWh hors abonnement"]
[null,null,"évolution cout gaz",0.02,"/an"]
[]
[]
["Devis"]
[null,null,null,null,null,null,"MONTANT HT","TVA","MONTANT TTC","MONTANT TOTAL PROJET TTC","Répartition","imputation","total"]
[null,"1 - Honoraires"]
[null,null,{"$f":"table_simulateur!#REF!","v":{"$error":"#REF!"}},null,null,null,{"$f":"ROUND(OFFSET(table_simulateur!F$186,MATCH(C45,table_simulateur!B$186:B$384,0)-1,0)*OFFSET(table_simulateur!B$20,MATCH(K45,table_simulateur!D$21:D$31,0),0)/OFFSET(table_simulateur!B$20,MATCH(K45,table_simulateur!D$21:D$31,0),1),2)","v":{"$error":"#REF!"}},{"$f":"OFFSET(table_simulateur!H$186,MATCH(C45,table_simulateur!B$186:B$384,0)-1,0)","v":{"$error":"#REF!"}},{"$f":"ROUND(G45*(1+H45),2)","v":{"$error":"#REF!"}},{"$f":"+G45*M45/L45","v":{"$error":"#REF!"}},"tantièmes",{"$f":"OFFSET(table_simulateur!B$20,MATCH(simulateur!K45,table_simulateur!D$21:D$31,0),0)","v":8.1600000000000006E-3},{"$f":"OFFSET(table_simulateur!C$20,MATCH(simulateur!K45,table_simulateur!D$21:D$31,0),0)","v":0.99990000000000134}]
[null,null,{"$f":"table_simulateur!#REF!","v":{"$error":"#REF!"}},null,null,null,{"$f":"ROUND(OFFSET(table_simulateur!F$186,MATCH(C46,table_simulateur!B$186:B$384,0)-1,0)*OFFSET(table_simulateur!B$20,MATCH(K46,table_simulateur!D$21:D$31,0),0)/OFFSET(table_simulateur!B$20,MATCH(K46,table_simulateur!D$21:D$31,0),1),2)","v":{"$error":"#REF!"}},{"$f":"OFFSET(table_simulateur!H$186,MATCH(C46,table_simulateur!B$186:B$384,0)-1,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},"tantièmes",{"$f":"OFFSET(table_simulateur!B$20,MATCH(simulateur!K46,table_simulateur!D$21:D$31,0),0)","v":8.1600000000000006E-3},{"$f":"OFFSET(table_simulateur!C$20,MATCH(simulateur!K46,table_simulateur!D$21:D$31,0),0)","v":0.99990000000000134}]
[null,null,{"$f":"table_simulateur!#REF!","v":{"$error":"#REF!"}},null,null,null,{"$f":"ROUND(OFFSET(table_simulateur!F$186,MATCH(C47,table_simulateur!B$186:B$384,0)-1,0)*OFFSET(table_simulateur!B$20,MATCH(K47,table_simulateur!D$21:D$31,0),0)/OFFSET(table_simulateur!B$20,MATCH(K47,table_simulateur!D$21:D$31,0),1),2)","v":{"$error":"#REF!"}},{"$f":"OFFSET(table_simulateur!H$186,MATCH(C47,table_simulateur!B$186:B$384,0)-1,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},"tantièmes",{"$f":"OFFSET(table_simulateur!B$20,MATCH(simulateur!K47,table_simulateur!D$21:D$31,0),0)","v":8.1600000000000006E-3},{"$f":"OFFSET(table_simulateur!C$20,MATCH(simulateur!K47,table_simulateur!D$21:D$31,0),0)","v":0.99990000000000134}]
[null,null,{"$f":"table_simulateur!#REF!","v":{"$error":"#REF!"}},null,null,null,{"$f":"ROUND(OFFSET(table_simulateur!F$186,MATCH(C48,table_simulateur!B$186:B$384,0)-1,0)*OFFSET(table_simulateur!B$20,MATCH(K48,table_simulateur!D$21:D$31,0),0)/OFFSET(table_simulateur!B$20,MATCH(K48,table_simulateur!D$21:D$31,0),1),2)","v":{"$error":"#REF!"}},{"$f":"OFFSET(table_simulateur!H$186,MATCH(C48,table_simulateur!B$186:B$384,0)-1,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},"tantièmes",{"$f":"OFFSET(table_simulateur!B$20,MATCH(simulateur!K48,table_simulateur!D$21:D$31,0),0)","v":8.1600000000000006E-3},{"$f":"OFFSET(table_simulateur!C$20,MATCH(simulateur!K48,table_simulateur!D$21:D$31,0),0)","v":0.99990000000000134}]
[null,null,{"$f":"table_simulateur!#REF!","v":{"$error":"#REF!"}},null,null,null,{"$f":"ROUND(OFFSET(table_simulateur!F$186,MATCH(C49,table_simulateur!B$186:B$384,0)-1,0)*OFFSET(table_simulateur!B$20,MATCH(K49,table_simulateur!D$21:D$31,0),0)/OFFSET(table_simulateur!B$20,MATCH(K49,table_simulateur!D$21:D$31,0),1),2)","v":{"$error":"#REF!"}},{"$f":"OFFSET(table_simulateur!H$186,MATCH(C49,table_simulateur!B$186:B$384,0)-1,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},"tantièmes",{"$f":"OFFSET(table_simulateur!B$20,MATCH(simulateur!K49,table_simulateur!D$21:D$31,0),0)","v":8.1600000000000006E-3},{"$f":"OFFSET(table_simulateur!C$20,MATCH(simulateur!K49,table_simulateur!D$21:D$31,0),0)","v":0.99990000000000134}]
[null,null,{"$f":"table_simulateur!#REF!","v":{"$error":"#REF!"}},null,null,null,{"$f":"ROUND(OFFSET(table_simulateur!F$186,MATCH(C50,table_simulateur!B$186:B$384,0)-1,0)*OFFSET(table_simulateur!B$20,MATCH(K50,table_simulateur!D$21:D$31,0),0)/OFFSET(table_simulateur!B$20,MATCH(K50,table_simulateur!D$21:D$31,0),1),2)","v":{"$error":"#REF!"}},{"$f":"OFFSET(table_simulateur!H$186,MATCH(C50,table_simulateur!B$186:B$384,0)-1,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},"tantièmes",{"$f":"OFFSET(table_simulateur!B$20,MATCH(simulateur!K50,table_simulateur!D$21:D$31,0),0)","v":8.1600000000000006E-3},{"$f":"OFFSET(table_simulateur!C$20,MATCH(simulateur!K50,table_simulateur!D$21:D$31,0),0)","v":0.99990000000000134}]
[]
[null,null,{"$f":"\"Répartition des coûts : \"&K45","v":"Répartition des coûts : tantièmes"}]
[]
[null,"2- Travaux d'Etanchéité des loggias, garde-corps"]
[]
[null,"Le loggia est-il actuellement recouvert d'un revêtement de sol de type carrelage / pavage?",null,null,null,"non"]
[]
[null,null,{"$f":"table_simulateur!B192","v":"Option : Dépose des revetements de sol mis en œuvre par les propriétaires et évacuation."},null,null,null,{"$f":"IF(F56=\"oui\",D12*table_simulateur!E192,\"pas de revêtement à déposer\")","v":"pas de revêtement à déposer"},{"$f":"OFFSET(table_simulateur!H$186,MATCH(C58,table_simulateur!B$186:B$384,0)-1,0)","v":7.0000000000000007E-2},{"$f":"IF(F56=\"oui\",ROUND(G58*(1+H58),2),0)","v":0},null,"option"]
[]
[null,null,{"$f":"\"Répartition des coûts : \"&K61","v":"Répartition des coûts : surface de loggia"}]
[null,null,{"$f":"table_simulateur!B195","v":"Démolition chape et enlévement de la chape, des relevés et des rives de dalles"},null,null,null,{"$f":"ROUND(OFFSET(table_simulateur!F$186,MATCH(C61,table_simulateur!B$186:B$384,0)-1,0)*OFFSET(table_simulateur!B$20,MATCH(K61,table_simulateur!D$21:D$31,0),0)/OFFSET(table_simulateur!B$20,MATCH(K61,table_simulateur!D$21:D$31,0),1),2)","v":1618.53},{"$f":"OFFSET(table_simulateur!H$186,MATCH(C61,table_simulateur!B$186:B$384,0)-1,0)","v":7.0000000000000007E-2},{"$f":"ROUND(G61*(1+H61),2)","v":1731.83},{"$f":"+G61*M61/L61","v":190619.79205350133},"surface de loggia",{"$f":"OFFSET(table_simulateur!B$20,MATCH(simulateur!K61,table_simulateur!D$21:D$31,0),0)","v":12.71},{"$f":"OFFSET(table_simulateur!C$20,MATCH(simulateur!K61,table_simulateur!D$21:D$31,0),0)","v":1496.9000000000012}]
[null,null,{"$f":"table_simulateur!B198","v":"Mise en œuvre d’un Système d’Etanchéité Liquide, sans forme de pente"},null,null,null,{"$f":"ROUND(OFFSET(table_simulateur!F$186,MATCH(C62,table_simulateur!B$186:B$384,0)-1,0)*OFFSET(table_simulateur!B$20,MATCH(K62,table_simulateur!D$21:D$31,0),0)/OFFSET(table_simulateur!B$20,MATCH(K62,table_simulateur!D$21:D$31,0),1),2)","v":2033.31},{"$f":"OFFSET(table_simulateur!H$186,MATCH(C62,table_simulateur!B$186:B$384,0)-1,0)","v":7.0000000000000007E-2},{"$f":"ROUND(G62*(1+H62),2)","v":2175.64},{"$f":"+G62*M62/L62","v":239469.84571203793},"surface de loggia",{"$f":"OFFSET(table_simulateur!B$20,MATCH(simulateur!K62,table_simulateur!D$21:D$31,0),0)","v":12.71},{"$f":"OFFSET(table_simulateur!C$20,MATCH(simulateur!K62,table_simulateur!D$21:D$31,0),0)","v":1496.9000000000012}]
[null,null,{"$f":"table_simulateur!B204","v":"Décapage des sous-faces des dalles béton des loggias et mise en peinture"},null,null,null,{"$f":"ROUND(OFFSET(table_simulateur!F$186,MATCH(C63,table_simulateur!B$186:B$384,0)-1,0)*OFFSET(table_simulateur!B$20,MATCH(K63,table_simulateur!D$21:D$31,0),0)/OFFSET(table_simulateur!B$20,MATCH(K63,table_simulateur!D$21:D$31,0),1),2)","v":515.77},{"$f":"OFFSET(table_simulateur!H$186,MATCH(C63,table_simulateur!B$186:B$384,0)-1,0)","v":7.0000000000000007E-2},{"$f":"ROUND(G63*(1+H63),2)","v":551.87},{"$f":"+G63*M63/L63","v":60743.990007867862},"surface de loggia",{"$f":"OFFSET(table_simulateur!B$20,MATCH(simulateur!K63,table_simulateur!D$21:D$31,0),0)","v":12.71},{"$f":"OFFSET(table_simulateur!C$20,MATCH(simulateur!K63,table_simulateur!D$21:D$31,0),0)","v":1496.9000000000012}]
[]
[null,null,{"$f":"\"Répartition des coûts : \"&K66","v":"Répartition des coûts : surface de loggia"}]
[null,null,{"$f":"table_simulateur!#REF!","v":{"$error":"#REF!"}},null,null,null,{"$f":"ROUND(OFFSET(table_simulateur!F$186,MATCH(C66,table_simulateur!B$186:B$384,0)-1,0)*OFFSET(table_simulateur!B$20,MATCH(K66,table_simulateur!D$21:D$31,0),0)/OFFSET(table_simulateur!B$20,MATCH(K66,table_simulateur!D$21:D$31,0),1),2)","v":{"$error":"#REF!"}},{"$f":"OFFSET(table_simulateur!H$186,MATCH(C66,table_simulateur!B$186:B$384,0)-1,0)","v":{"$error":"#REF!"}},{"$f":"ROUND(G66*(1+H66),2)","v":{"$error":"#REF!"}},{"$f":"+G66*M66/L66","v":{"$error":"#REF!"}},"surface de loggia",{"$f":"OFFSET(table_simulateur!B$20,MATCH(simulateur!K66,table_simulateur!D$21:D$31,0),0)","v":12.71},{"$f":"OFFSET(table_simulateur!C$20,MATCH(simulateur!K66,table_simulateur!D$21:D$31,0),0)","v":1496.9000000000012}]
[null,null,{"$f":"table_simulateur!B207","v":"Décapage des gardes-corps et remise en peinture noire"},null,null,null,{"$f":"ROUND(OFFSET(table_simulateur!F$186,MATCH(C67,table_simulateur!B$186:B$384,0)-1,0)*OFFSET(table_simulateur!B$20,MATCH(K67,table_simulateur!D$21:D$31,0),0)/OFFSET(table_simulateur!B$20,MATCH(K67,table_simulateur!D$21:D$31,0),1),2)","v":728.07},{"$f":"OFFSET(table_simulateur!H$186,MATCH(C67,table_simulateur!B$186:B$384,0)-1,0)","v":7.0000000000000007E-2},{"$f":"ROUND(G67*(1+H67),2)","v":779.03},{"$f":"+G67*M67/L67","v":85747.284264358837},"surface de loggia",{"$f":"OFFSET(table_simulateur!B$20,MATCH(simulateur!K67,table_simulateur!D$21:D$31,0),0)","v":12.71},{"$f":"OFFSET(table_simulateur!C$20,MATCH(simulateur!K67,table_simulateur!D$21:D$31,0),0)","v":1496.9000000000012}]
[null,null,{"$f":"table_simulateur!B210","v":"Plus-value pour garde-corps neufs en aluminium comprenant main courante et remplissage en verre feuilleté"},null,null,null,{"$f":"ROUND(OFFSET(table_simulateur!F$186,MATCH(C68,table_simulateur!B$186:B$384,0)-1,0)*OFFSET(table_simulateur!B$20,MATCH(K68,table_simulateur!D$21:D$31,0),0)/OFFSET(table_simulateur!B$20,MATCH(K68,table_simulateur!D$21:D$31,0),1),2)","v":1380.97},{"$f":"OFFSET(table_simulateur!H$186,MATCH(C68,table_simulateur!B$186:B$384,0)-1,0)","v":7.0000000000000007E-2},{"$f":"ROUND(G68*(1+H68),2)","v":1477.64},{"$f":"+G68*M68/L68","v":162641.54154209295},"surface de loggia",{"$f":"OFFSET(table_simulateur!B$20,MATCH(simulateur!K68,table_simulateur!D$21:D$31,0),0)","v":12.71},{"$f":"OFFSET(table_simulateur!C$20,MATCH(simulateur!K68,table_simulateur!D$21:D$31,0),0)","v":1496.9000000000012}]
[null,null,{"$f":"table_simulateur!B201","v":"Mise en œuvre d'une tôle pliée d'habillage en rive de dalle"},null,null,null,{"$f":"ROUND(OFFSET(table_simulateur!F$186,MATCH(C69,table_simulateur!B$186:B$384,0)-1,0)*OFFSET(table_simulateur!B$20,MATCH(K69,table_simulateur!D$21:D$31,0),0)/OFFSET(table_simulateur!B$20,MATCH(K69,table_simulateur!D$21:D$31,0),1),2)","v":1011.87},{"$f":"OFFSET(table_simulateur!H$186,MATCH(C69,table_simulateur!B$186:B$384,0)-1,0)","v":7.0000000000000007E-2},{"$f":"ROUND(G69*(1+H69),2)","v":1082.7},{"$f":"+G69*M69/L69","v":119171.3771046421},"surface de loggia",{"$f":"OFFSET(table_simulateur!B$20,MATCH(simulateur!K69,table_simulateur!D$21:D$31,0),0)","v":12.71},{"$f":"OFFSET(table_simulateur!C$20,MATCH(simulateur!K69,table_simulateur!D$21:D$31,0),0)","v":1496.9000000000012}]
[]
[null,"3 - Remplacement des chassis"]
[]
[null,null,"Dépose des chassis existant",null,null,null,{"$f":"ROUND((table_simulateur!#REF!+table_simulateur!#REF!+table_simulateur!G275)*OFFSET(table_simulateur!B$20,MATCH(K73,table_simulateur!D$21:D$31,0),0)/OFFSET(table_simulateur!B$20,MATCH(K73,table_simulateur!D$21:D$31,0),1),2)","v":{"$error":"#REF!"}},7.0000000000000007E-2,{"$f":"ROUND(G73*(1+H73),2)","v":{"$error":"#REF!"}},{"$f":"+G73*M73/L73","v":{"$error":"#REF!"}},"surface actuelle des chassis",{"$f":"OFFSET(table_simulateur!B$20,MATCH(simulateur!K73,table_simulateur!D$21:D$31,0),0)","v":29.64},{"$f":"OFFSET(table_simulateur!C$20,MATCH(simulateur!K73,table_simulateur!D$21:D$31,0),0)","v":3243.7499999999955}]
[]
[null,null,"Remplacement des chassis existants",null,null,null,{"$f":"ROUND((table_simulateur!#REF!+table_simulateur!#REF!+table_simulateur!G279)*OFFSET(table_simulateur!B$20,MATCH(K75,table_simulateur!D$21:D$31,0),0)/OFFSET(table_simulateur!B$20,MATCH(K75,table_simulateur!D$21:D$31,0),1),2)","v":{"$error":"#REF!"}},7.0000000000000007E-2,{"$f":"ROUND(G75*(1+H75),2)","v":{"$error":"#REF!"}},{"$f":"+G75*M75/L75","v":{"$error":"#REF!"}},"surface actuelle des chassis",{"$f":"OFFSET(table_simulateur!B$20,MATCH(simulateur!K75,table_simulateur!D$21:D$31,0),0)","v":29.64},{"$f":"OFFSET(table_simulateur!C$20,MATCH(simulateur!K75,table_simulateur!D$21:D$31,0),0)","v":3243.7499999999955}]
[]
[null,null,"Option : Façade côté Parc : remplacement de la partie opaque par des chassis vitrés  :",null,null,"non",{"$f":"IF(F77=\"oui\",ROUND(table_simulateur!E245*OFFSET(table_simulateur!B$20,MATCH(K77,table_simulateur!D$21:D$31,0),0),1),0)","v":0},7.0000000000000007E-2,{"$f":"ROUND(G77*(1+H77),2)","v":0},null,"option vitrage surface",{"$f":"(table_simulateur!B$27+table_simulateur!B$28)","v":29.64},{"$f":"(table_simulateur!C$27+table_simulateur!C$28)","v":3243.7499999999982}]
[null,null,"Surface traitée à expliquer; Cumul des options à intégrer"]
[]
[null,null,{"$f":"table_simulateur!#REF!","v":{"$error":"#REF!"}},null,null,"non",{"$f":"IF(F80=\"oui\",ROUND(table_simulateur!#REF!*(table_simulateur!B$27+table_simulateur!B$28),1),0)","v":0},{"$f":"OFFSET(table_simulateur!H$186,MATCH(C80,table_simulateur!B$186:B$384,0)-1,0)","v":{"$error":"#REF!"}},{"$f":"ROUND(G80*(1+H80),2)","v":{"$error":"#REF!"}},null,"option vitrage surface",{"$f":"(table_simulateur!B$27+table_simulateur!B$28)","v":29.64},{"$f":"(table_simulateur!C$27+table_simulateur!C$28)","v":3243.7499999999982}]
[null,null,{"$f":"table_simulateur!#REF!","v":{"$error":"#REF!"}},null,null,"non",{"$f":"IF(F81=\"oui\",ROUND(table_simulateur!#REF!*(table_simulateur!B$27+table_simulateur!B$28),1),0)","v":0},{"$f":"OFFSET(table_simulateur!H$186,MATCH(C81,table_simulateur!B$186:B$384,0)-1,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,"option vitrage surface",{"$f":"(table_simulateur!B$27+table_simulateur!B$28)","v":29.64},{"$f":"(table_simulateur!C$27+table_simulateur!C$28)","v":3243.7499999999982}]
[null,null,{"$f":"table_simulateur!#REF!","v":{"$error":"#REF!"}},null,null,"non",{"$f":"IF(F82=\"oui\",ROUND(table_simulateur!#REF!*(table_simulateur!B$27+table_simulateur!B$28),1),0)","v":0},{"$f":"OFFSET(table_simulateur!H$186,MATCH(C82,table_simulateur!B$186:B$384,0)-1,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,"option vitrage surface",{"$f":"(table_simulateur!B$27+table_simulateur!B$28)","v":29.64},{"$f":"(table_simulateur!C$27+table_simulateur!C$28)","v":3243.7499999999982}]
[null,null,{"$f":"table_simulateur!#REF!","v":{"$error":"#REF!"}},null,null,"non",{"$f":"IF(F77=\"oui\",ROUND(table_simulateur!E248*(table_simulateur!B$27+table_simulateur!B$28),1),0)","v":0},{"$f":"OFFSET(table_simulateur!H$186,MATCH(C83,table_simulateur!B$186:B$384,0)-1,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,"option vitrage surface",{"$f":"(table_simulateur!B$27+table_simulateur!B$28)","v":29.64},{"$f":"(table_simulateur!C$27+table_simulateur!C$28)","v":3243.7499999999982}]
[null,null,{"$f":"table_simulateur!#REF!","v":{"$error":"#REF!"}},null,null,"non",{"$f":"IF(F77=\"oui\",ROUND(table_simulateur!E249*(table_simulateur!B$27+table_simulateur!B$28),1),0)","v":0},{"$f":"OFFSET(table_simulateur!H$186,MATCH(C84,table_simulateur!B$186:B$384,0)-1,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,"option vitrage surface",{"$f":"(table_simulateur!B$27+table_simulateur!B$28)","v":29.64},{"$f":"(table_simulateur!C$27+table_simulateur!C$28)","v":3243.7499999999982}]
[null,null,{"$f":"table_simulateur!#REF!","v":{"$error":"#REF!"}},null,null,"non",{"$f":"IF(F77=\"oui\",ROUND(table_simulateur!E250*(table_simulateur!B$27+table_simulateur!B$28),1),0)","v":0},{"$f":"OFFSET(table_simulateur!H$186,MATCH(C85,table_simulateur!B$186:B$384,0)-1,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,"option vitrage surface",{"$f":"(table_simulateur!B$27+table_simulateur!B$28)","v":29.64},{"$f":"(table_simulateur!C$27+table_simulateur!C$28)","v":3243.7499999999982}]
[]
[]
[null,"4 - Isolation et ravalement de façade"]
[]
[null,null,{"$f":"table_simulateur!B257","v":"- Mise en œuvre d'un complexe isolant + parement minéral sur support béton"}]
[null,null,{"$f":"\"Répartition des coûts : \"&K93","v":"Répartition des coûts : surface des logements"}]
[null,null,{"$f":"table_simulateur!B258","v":"Dépose du parement de façade existant"}]
[null,null,{"$f":"table_simulateur!B259","v":0},null,null,null,{"$f":"ROUND(OFFSET(table_simulateur!F$186,MATCH(C93,table_simulateur!B$186:B$384,0)-1,0)*OFFSET(table_simulateur!B$20,MATCH(K93,table_simulateur!D$21:D$31,0),0)/OFFSET(table_simulateur!B$20,MATCH(K93,table_simulateur!D$21:D$31,0),1),2)","v":{"$error":"#N/A"}},{"$f":"OFFSET(table_simulateur!H$186,MATCH(C93,table_simulateur!B$186:B$384,0)-1,0)","v":{"$error":"#N/A"}},{"$f":"ROUND(G93*(1+H93),2)","v":{"$error":"#N/A"}},{"$f":"+G93*M93/L93","v":{"$error":"#N/A"}},"surface des logements",{"$f":"OFFSET(table_simulateur!B$20,MATCH(simulateur!K93,table_simulateur!D$21:D$31,0),0)","v":98.72},{"$f":"OFFSET(table_simulateur!C$20,MATCH(simulateur!K93,table_simulateur!D$21:D$31,0),0)","v":11194.449999999992}]
[null,null,{"$f":"table_simulateur!B261","v":"Corniches décoratives "},null,null,null,{"$f":"ROUND(OFFSET(table_simulateur!F$186,MATCH(C94,table_simulateur!B$186:B$384,0)-1,0)*OFFSET(table_simulateur!B$20,MATCH(K94,table_simulateur!D$21:D$31,0),0)/OFFSET(table_simulateur!B$20,MATCH(K94,table_simulateur!D$21:D$31,0),1),2)","v":32.54},{"$f":"OFFSET(table_simulateur!H$186,MATCH(C94,table_simulateur!B$186:B$384,0)-1,0)","v":7.0000000000000007E-2},{"$f":"ROUND(G94*(1+H94),2)","v":34.82},{"$f":"+G94*M94/L94","v":3689.9048115883274},"surface des logements",{"$f":"OFFSET(table_simulateur!B$20,MATCH(simulateur!K94,table_simulateur!D$21:D$31,0),0)","v":98.72},{"$f":"OFFSET(table_simulateur!C$20,MATCH(simulateur!K94,table_simulateur!D$21:D$31,0),0)","v":11194.449999999992}]
[]
[null,null,{"$f":"table_simulateur!B225","v":0}]
[null,null,{"$f":"\"Répartition des coûts : \"&K99","v":"Répartition des coûts : surface des logements"}]
[null,null,{"$f":"table_simulateur!B230","v":"Mise en oeuvre d'un complexe isolant + parement minéral sur les murs de refend en béton au droit des logements"}]
[null,null,{"$f":"table_simulateur!B231","v":0},null,null,null,{"$f":"ROUND(OFFSET(table_simulateur!F$186,MATCH(C99,table_simulateur!B$186:B$384,0)-1,0)*OFFSET(table_simulateur!B$20,MATCH(K99,table_simulateur!D$21:D$31,0),0)/OFFSET(table_simulateur!B$20,MATCH(K99,table_simulateur!D$21:D$31,0),1),2)","v":{"$error":"#N/A"}},{"$f":"OFFSET(table_simulateur!H$186,MATCH(C99,table_simulateur!B$186:B$384,0)-1,0)","v":{"$error":"#N/A"}},{"$f":"ROUND(G99*(1+H99),2)","v":{"$error":"#N/A"}},{"$f":"+G99*M99/L99","v":{"$error":"#N/A"}},"surface des logements",{"$f":"OFFSET(table_simulateur!B$20,MATCH(simulateur!K99,table_simulateur!D$21:D$31,0),0)","v":98.72},{"$f":"OFFSET(table_simulateur!C$20,MATCH(simulateur!K99,table_simulateur!D$21:D$31,0),0)","v":11194.449999999992}]
[]
[null,null,{"$f":"table_simulateur!B227","v":"Mise en oeuvre d'un complexe isolant + parement minéral sur les parties pleines actuellement en lambris logement / loggias profondes"},null,null,null,{"$f":"ROUND(OFFSET(table_simulateur!F$186,MATCH(C101,table_simulateur!B$186:B$384,0)-1,0)*OFFSET(table_simulateur!B$20,MATCH(K101,table_simulateur!D$21:D$31,0),0)/OFFSET(table_simulateur!B$20,MATCH(K101,table_simulateur!D$21:D$31,0),1),2)","v":428.37},{"$f":"OFFSET(table_simulateur!H$186,MATCH(C101,table_simulateur!B$186:B$384,0)-1,0)","v":7.0000000000000007E-2},{"$f":"ROUND(G101*(1+H101),2)","v":458.36},{"$f":"+G101*M101/L101","v":48575.430981563986},"surface des logements",{"$f":"OFFSET(table_simulateur!B$20,MATCH(simulateur!K101,table_simulateur!D$21:D$31,0),0)","v":98.72},{"$f":"OFFSET(table_simulateur!C$20,MATCH(simulateur!K101,table_simulateur!D$21:D$31,0),0)","v":11194.449999999992}]
[null,null,{"$f":"table_simulateur!B216","v":"- Décapage et mise en peintre des murs de refends"},null,null,null,{"$f":"ROUND(OFFSET(table_simulateur!F$186,MATCH(C102,table_simulateur!B$186:B$384,0)-1,0)*OFFSET(table_simulateur!B$20,MATCH(K102,table_simulateur!D$21:D$31,0),0)/OFFSET(table_simulateur!B$20,MATCH(K102,table_simulateur!D$21:D$31,0),1),2)","v":0},{"$f":"OFFSET(table_simulateur!H$186,MATCH(C102,table_simulateur!B$186:B$384,0)-1,0)","v":0},{"$f":"ROUND(G102*(1+H102),2)","v":0},{"$f":"+G102*M102/L102","v":0},"surface des logements",{"$f":"OFFSET(table_simulateur!B$20,MATCH(simulateur!K102,table_simulateur!D$21:D$31,0),0)","v":98.72},{"$f":"OFFSET(table_simulateur!C$20,MATCH(simulateur!K102,table_simulateur!D$21:D$31,0),0)","v":11194.449999999992}]
[null,null,{"$f":"table_simulateur!B217","v":"Décapage et mise en peintre des murs de refends"}]
[null,null,{"$f":"table_simulateur!B218","v":0},null,null,null,{"$f":"ROUND(OFFSET(table_simulateur!F$186,MATCH(C104,table_simulateur!B$186:B$384,0)-1,0)*OFFSET(table_simulateur!B$20,MATCH(K104,table_simulateur!D$21:D$31,0),0)/OFFSET(table_simulateur!B$20,MATCH(K104,table_simulateur!D$21:D$31,0),1),2)","v":{"$error":"#N/A"}},{"$f":"OFFSET(table_simulateur!H$186,MATCH(C104,table_simulateur!B$186:B$384,0)-1,0)","v":{"$error":"#N/A"}},{"$f":"ROUND(G104*(1+H104),2)","v":{"$error":"#N/A"}},{"$f":"+G104*M104/L104","v":{"$error":"#N/A"}},"surface des logements",{"$f":"OFFSET(table_simulateur!B$20,MATCH(simulateur!K104,table_simulateur!D$21:D$31,0),0)","v":98.72},{"$f":"OFFSET(table_simulateur!C$20,MATCH(simulateur!K104,table_simulateur!D$21:D$31,0),0)","v":11194.449999999992}]
[]
[null,null,{"$f":"table_simulateur!#REF!","v":{"$error":"#REF!"}},null,null,null,{"$f":"ROUND(OFFSET(table_simulateur!F$186,MATCH(C106,table_simulateur!B$186:B$384,0)-1,0)*OFFSET(table_simulateur!B$20,MATCH(K106,table_simulateur!D$21:D$31,0),0)/OFFSET(table_simulateur!B$20,MATCH(K106,table_simulateur!D$21:D$31,0),1),2)","v":{"$error":"#REF!"}},{"$f":"OFFSET(table_simulateur!H$186,MATCH(C106,table_simulateur!B$186:B$384,0)-1,0)","v":{"$error":"#REF!"}},{"$f":"ROUND(G106*(1+H106),2)","v":{"$error":"#REF!"}},{"$f":"+G106*M106/L106","v":{"$error":"#REF!"}},"surface des logements",{"$f":"OFFSET(table_simulateur!B$20,MATCH(simulateur!K106,table_simulateur!D$21:D$31,0),0)","v":98.72},{"$f":"OFFSET(table_simulateur!C$20,MATCH(simulateur!K106,table_simulateur!D$21:D$31,0),0)","v":11194.449999999992}]
[]
[null,null,{"$f":"table_simulateur!B219","v":"- Mise en œuvre d'un habillage de la tranche des murs de refends"},null,null,null,{"$f":"ROUND(OFFSET(table_simulateur!F$186,MATCH(C108,table_simulateur!B$186:B$384,0)-1,0)*OFFSET(table_simulateur!B$20,MATCH(K108,table_simulateur!D$21:D$31,0),0)/OFFSET(table_simulateur!B$20,MATCH(K108,table_simulateur!D$21:D$31,0),1),2)","v":0},{"$f":"OFFSET(table_simulateur!H$186,MATCH(C108,table_simulateur!B$186:B$384,0)-1,0)","v":0},{"$f":"ROUND(G108*(1+H108),2)","v":0},{"$f":"+G108*M108/L108","v":0},"surface des logements",{"$f":"OFFSET(table_simulateur!B$20,MATCH(simulateur!K108,table_simulateur!D$21:D$31,0),0)","v":98.72},{"$f":"OFFSET(table_simulateur!C$20,MATCH(simulateur!K108,table_simulateur!D$21:D$31,0),0)","v":11194.449999999992}]
[null,null,{"$f":"table_simulateur!B220","v":"Mise en oeuvre d'un habillage en tôle laquée sur l'about des murs de refends après réfection et traitement des béton"}]
[null,null,{"$f":"table_simulateur!#REF!","v":{"$error":"#REF!"}},null,null,null,{"$f":"ROUND(OFFSET(table_simulateur!F$186,MATCH(C110,table_simulateur!B$186:B$384,0)-1,0)*OFFSET(table_simulateur!B$20,MATCH(K110,table_simulateur!D$21:D$31,0),0)/OFFSET(table_simulateur!B$20,MATCH(K110,table_simulateur!D$21:D$31,0),1),2)","v":{"$error":"#REF!"}},{"$f":"OFFSET(table_simulateur!H$186,MATCH(C110,table_simulateur!B$186:B$384,0)-1,0)","v":{"$error":"#REF!"}},{"$f":"ROUND(G110*(1+H110),2)","v":{"$error":"#REF!"}},{"$f":"+G110*M110/L110","v":{"$error":"#REF!"}},"surface des logements",{"$f":"OFFSET(table_simulateur!B$20,MATCH(simulateur!K110,table_simulateur!D$21:D$31,0),0)","v":98.72},{"$f":"OFFSET(table_simulateur!C$20,MATCH(simulateur!K110,table_simulateur!D$21:D$31,0),0)","v":11194.449999999992}]
[]
[null,null,{"$f":"table_simulateur!B263","v":0}]
[]
[null,null,{"$f":"table_simulateur!B265","v":"Dépose du parement de façade existant "}]
[null,null,{"$f":"table_simulateur!B266","v":0},null,null,null,{"$f":"ROUND(OFFSET(table_simulateur!F$186,MATCH(C115,table_simulateur!B$186:B$384,0)-1,0)*OFFSET(table_simulateur!B$20,MATCH(K115,table_simulateur!D$21:D$31,0),0)/OFFSET(table_simulateur!B$20,MATCH(K115,table_simulateur!D$21:D$31,0),1),2)","v":{"$error":"#N/A"}},{"$f":"OFFSET(table_simulateur!H$186,MATCH(C115,table_simulateur!B$186:B$384,0)-1,0)","v":{"$error":"#N/A"}},{"$f":"ROUND(G115*(1+H115),2)","v":{"$error":"#N/A"}},{"$f":"+G115*M115/L115","v":{"$error":"#N/A"}},"surface des logements",{"$f":"OFFSET(table_simulateur!B$20,MATCH(simulateur!K115,table_simulateur!D$21:D$31,0),0)","v":98.72},{"$f":"OFFSET(table_simulateur!C$20,MATCH(simulateur!K115,table_simulateur!D$21:D$31,0),0)","v":11194.449999999992}]
[]
[null,null,{"$f":"table_simulateur!B330","v":0},null,null,null,{"$f":"ROUND(OFFSET(table_simulateur!F$186,MATCH(C117,table_simulateur!B$186:B$384,0)-1,0)*OFFSET(table_simulateur!B$20,MATCH(K117,table_simulateur!D$21:D$31,0),0)/OFFSET(table_simulateur!B$20,MATCH(K117,table_simulateur!D$21:D$31,0),1),2)","v":{"$error":"#N/A"}},{"$f":"OFFSET(table_simulateur!H$186,MATCH(C117,table_simulateur!B$186:B$384,0)-1,0)","v":{"$error":"#N/A"}},{"$f":"ROUND(G117*(1+H117),2)","v":{"$error":"#N/A"}},{"$f":"+G117*M117/L117","v":{"$error":"#N/A"}},"surface des logements",{"$f":"OFFSET(table_simulateur!B$20,MATCH(simulateur!K117,table_simulateur!D$21:D$31,0),0)","v":98.72},{"$f":"OFFSET(table_simulateur!C$20,MATCH(simulateur!K117,table_simulateur!D$21:D$31,0),0)","v":11194.449999999992}]
[]
[]
[null,"5 - Isolation de la toiture"]
[]
[null,null,{"$f":"table_simulateur!B333","v":"Prestation de base :\n- Dépose de la sécurité collective existante\n- Dépose de l'étanchéité existante et de ses relevés\n- Dépose de la couvertine d'acrotère existante\n- Dépose de l'isolation existante\n- Réhausse des acrotères de 20cm\n- Mise en œuvre d'une étanchéité bicouche élastomère inaccessible autoprotégée sur isolant polyuréthane 225mm Th36\n- Mise en oeuvre d'une couvertine d'acrotère\n- Repose de la sécurité collective existante"}]
[null,null,{"$f":"table_simulateur!B334","v":0}]
[]
[null,null,{"$f":"table_simulateur!B336","v":"Dépose et repose de la sécurité collective existante"}]
[null,null,{"$f":"table_simulateur!B337","v":0},null,null,null,{"$f":"ROUND(OFFSET(table_simulateur!F$186,MATCH(C126,table_simulateur!B$186:B$384,0)-1,0)*OFFSET(table_simulateur!B$20,MATCH(K126,table_simulateur!D$21:D$31,0),0)/OFFSET(table_simulateur!B$20,MATCH(K126,table_simulateur!D$21:D$31,0),1),2)","v":{"$error":"#N/A"}},{"$f":"OFFSET(table_simulateur!H$186,MATCH(C126,table_simulateur!B$186:B$384,0)-1,0)","v":{"$error":"#N/A"}},{"$f":"ROUND(G126*(1+H126),2)","v":{"$error":"#N/A"}},{"$f":"+G126*M126/L126","v":{"$error":"#N/A"}},"tantièmes",{"$f":"OFFSET(table_simulateur!B$20,MATCH(simulateur!K126,table_simulateur!D$21:D$31,0),0)","v":8.1600000000000006E-3},{"$f":"OFFSET(table_simulateur!C$20,MATCH(simulateur!K126,table_simulateur!D$21:D$31,0),0)","v":0.99990000000000134}]
[]
[null,null,{"$f":"table_simulateur!B339","v":"Dépose de l'étanchéité et de l'isolant existants"}]
[null,null,{"$f":"table_simulateur!B340","v":0},null,null,null,{"$f":"ROUND(OFFSET(table_simulateur!F$186,MATCH(C129,table_simulateur!B$186:B$384,0)-1,0)*OFFSET(table_simulateur!B$20,MATCH(K129,table_simulateur!D$21:D$31,0),0)/OFFSET(table_simulateur!B$20,MATCH(K129,table_simulateur!D$21:D$31,0),1),2)","v":{"$error":"#N/A"}},{"$f":"OFFSET(table_simulateur!H$186,MATCH(C129,table_simulateur!B$186:B$384,0)-1,0)","v":{"$error":"#N/A"}},{"$f":"ROUND(G129*(1+H129),2)","v":{"$error":"#N/A"}},{"$f":"+G129*M129/L129","v":{"$error":"#N/A"}},"tantièmes",{"$f":"OFFSET(table_simulateur!B$20,MATCH(simulateur!K129,table_simulateur!D$21:D$31,0),0)","v":8.1600000000000006E-3},{"$f":"OFFSET(table_simulateur!C$20,MATCH(simulateur!K129,table_simulateur!D$21:D$31,0),0)","v":0.99990000000000134}]
[]
[null,null,{"$f":"table_simulateur!B342","v":"Dépose de la couvertine d'acrotère"}]
[null,null,{"$f":"table_simulateur!B343","v":0},null,null,null,{"$f":"ROUND(OFFSET(table_simulateur!F$186,MATCH(C132,table_simulateur!B$186:B$384,0)-1,0)*OFFSET(table_simulateur!B$20,MATCH(K132,table_simulateur!D$21:D$31,0),0)/OFFSET(table_simulateur!B$20,MATCH(K132,table_simulateur!D$21:D$31,0),1),2)","v":{"$error":"#N/A"}},{"$f":"OFFSET(table_simulateur!H$186,MATCH(C132,table_simulateur!B$186:B$384,0)-1,0)","v":{"$error":"#N/A"}},{"$f":"ROUND(G132*(1+H132),2)","v":{"$error":"#N/A"}},{"$f":"+G132*M132/L132","v":{"$error":"#N/A"}},"tantièmes",{"$f":"OFFSET(table_simulateur!B$20,MATCH(simulateur!K132,table_simulateur!D$21:D$31,0),0)","v":8.1600000000000006E-3},{"$f":"OFFSET(table_simulateur!C$20,MATCH(simulateur!K132,table_simulateur!D$21:D$31,0),0)","v":0.99990000000000134}]
[null,null,{"$f":"table_simulateur!B345","v":0},null,null,null,{"$f":"ROUND(OFFSET(table_simulateur!F$186,MATCH(C133,table_simulateur!B$186:B$384,0)-1,0)*OFFSET(table_simulateur!B$20,MATCH(K133,table_simulateur!D$21:D$31,0),0)/OFFSET(table_simulateur!B$20,MATCH(K133,table_simulateur!D$21:D$31,0),1),2)","v":{"$error":"#N/A"}},{"$f":"OFFSET(table_simulateur!H$186,MATCH(C133,table_simulateur!B$186:B$384,0)-1,0)","v":{"$error":"#N/A"}},{"$f":"ROUND(G133*(1+H133),2)","v":{"$error":"#N/A"}},{"$f":"+G133*M133/L133","v":{"$error":"#N/A"}},"tantièmes",{"$f":"OFFSET(table_simulateur!B$20,MATCH(simulateur!K133,table_simulateur!D$21:D$31,0),0)","v":8.1600000000000006E-3},{"$f":"OFFSET(table_simulateur!C$20,MATCH(simulateur!K133,table_simulateur!D$21:D$31,0),0)","v":0.99990000000000134}]
[]
[null,null,{"$f":"table_simulateur!B347","v":"Réhausse de l'acrotère : mise en œuvre d'un rang de maçonnerie"}]
[null,null,{"$f":"table_simulateur!B348","v":0},null,null,null,{"$f":"ROUND(OFFSET(table_simulateur!F$186,MATCH(C136,table_simulateur!B$186:B$384,0)-1,0)*OFFSET(table_simulateur!B$20,MATCH(K136,table_simulateur!D$21:D$31,0),0)/OFFSET(table_simulateur!B$20,MATCH(K136,table_simulateur!D$21:D$31,0),1),2)","v":{"$error":"#N/A"}},{"$f":"OFFSET(table_simulateur!H$186,MATCH(C136,table_simulateur!B$186:B$384,0)-1,0)","v":{"$error":"#N/A"}},{"$f":"ROUND(G136*(1+H136),2)","v":{"$error":"#N/A"}},{"$f":"+G136*M136/L136","v":{"$error":"#N/A"}},"tantièmes",{"$f":"OFFSET(table_simulateur!B$20,MATCH(simulateur!K136,table_simulateur!D$21:D$31,0),0)","v":8.1600000000000006E-3},{"$f":"OFFSET(table_simulateur!C$20,MATCH(simulateur!K136,table_simulateur!D$21:D$31,0),0)","v":0.99990000000000134}]
[]
[null,null,{"$f":"table_simulateur!B350","v":"Surface courante et relevés d'étanchéité"}]
[null,null,{"$f":"table_simulateur!B351","v":"Traitement des édicules d'ascenceur"},null,null,null,{"$f":"ROUND(OFFSET(table_simulateur!F$186,MATCH(C139,table_simulateur!B$186:B$384,0)-1,0)*OFFSET(table_simulateur!B$20,MATCH(K139,table_simulateur!D$21:D$31,0),0)/OFFSET(table_simulateur!B$20,MATCH(K139,table_simulateur!D$21:D$31,0),1),2)","v":21.11},{"$f":"OFFSET(table_simulateur!H$186,MATCH(C139,table_simulateur!B$186:B$384,0)-1,0)","v":0},{"$f":"ROUND(G139*(1+H139),2)","v":21.11},{"$f":"+G139*M139/L139","v":2586.7511029411799},"tantièmes",{"$f":"OFFSET(table_simulateur!B$20,MATCH(simulateur!K139,table_simulateur!D$21:D$31,0),0)","v":8.1600000000000006E-3},{"$f":"OFFSET(table_simulateur!C$20,MATCH(simulateur!K139,table_simulateur!D$21:D$31,0),0)","v":0.99990000000000134}]
[null,null,{"$f":"table_simulateur!B352","v":"Traitement des sorties et cheminées (ventilations)"},null,null,null,{"$f":"ROUND(OFFSET(table_simulateur!F$186,MATCH(C140,table_simulateur!B$186:B$384,0)-1,0)*OFFSET(table_simulateur!B$20,MATCH(K140,table_simulateur!D$21:D$31,0),0)/OFFSET(table_simulateur!B$20,MATCH(K140,table_simulateur!D$21:D$31,0),1),2)","v":159.49},{"$f":"OFFSET(table_simulateur!H$186,MATCH(C140,table_simulateur!B$186:B$384,0)-1,0)","v":0},{"$f":"ROUND(G140*(1+H140),2)","v":159.49},{"$f":"+G140*M140/L140","v":19543.388602941202},"tantièmes",{"$f":"OFFSET(table_simulateur!B$20,MATCH(simulateur!K140,table_simulateur!D$21:D$31,0),0)","v":8.1600000000000006E-3},{"$f":"OFFSET(table_simulateur!C$20,MATCH(simulateur!K140,table_simulateur!D$21:D$31,0),0)","v":0.99990000000000134}]
[null,null,{"$f":"table_simulateur!#REF!","v":{"$error":"#REF!"}},null,null,null,{"$f":"ROUND(OFFSET(table_simulateur!F$186,MATCH(C141,table_simulateur!B$186:B$384,0)-1,0)*OFFSET(table_simulateur!B$20,MATCH(K141,table_simulateur!D$21:D$31,0),0)/OFFSET(table_simulateur!B$20,MATCH(K141,table_simulateur!D$21:D$31,0),1),2)","v":{"$error":"#REF!"}},{"$f":"OFFSET(table_simulateur!H$186,MATCH(C141,table_simulateur!B$186:B$384,0)-1,0)","v":{"$error":"#REF!"}},{"$f":"ROUND(G141*(1+H141),2)","v":{"$error":"#REF!"}},{"$f":"+G141*M141/L141","v":{"$error":"#REF!"}},"tantièmes",{"$f":"OFFSET(table_simulateur!B$20,MATCH(simulateur!K141,table_simulateur!D$21:D$31,0),0)","v":8.1600000000000006E-3},{"$f":"OFFSET(table_simulateur!C$20,MATCH(simulateur!K141,table_simulateur!D$21:D$31,0),0)","v":0.99990000000000134}]
[]
[]
[null,"6 - Traitement des Rez-de-Chaussée"]
[]
[null,null,{"$f":"table_simulateur!B293","v":"Isolation des planchers haut et bas du Rez-de-Chaussée (intérieur)"}]
[]
[null,null,{"$f":"table_simulateur!B295","v":"Dépose du faux plafond métallique existant"}]
[null,null,{"$f":"table_simulateur!B296","v":"Nettoyage du faux plafond métallique"},null,null,null,{"$f":"ROUND(OFFSET(table_simulateur!F$186,MATCH(C149,table_simulateur!B$186:B$384,0)-1,0)*OFFSET(table_simulateur!B$20,MATCH(K149,table_simulateur!D$21:D$31,0),0)/OFFSET(table_simulateur!B$20,MATCH(K149,table_simulateur!D$21:D$31,0),1),2)","v":0},{"$f":"OFFSET(table_simulateur!H$186,MATCH(C149,table_simulateur!B$186:B$384,0)-1,0)","v":0},{"$f":"ROUND(G149*(1+H149),2)","v":0},{"$f":"+G149*M149/L149","v":{"$error":"#DIV/0!"}},"surface des bureaux",{"$f":"OFFSET(table_simulateur!B$20,MATCH(simulateur!K149,table_simulateur!D$21:D$31,0),0)","v":0},{"$f":"OFFSET(table_simulateur!C$20,MATCH(simulateur!K149,table_simulateur!D$21:D$31,0),0)","v":903.91000000000008}]
[null,null,{"$f":"table_simulateur!B297","v":"Mise en œuvre d'un isolant type laine minerale et repose du faux plafond"},null,null,null,{"$f":"ROUND(OFFSET(table_simulateur!F$186,MATCH(C150,table_simulateur!B$186:B$384,0)-1,0)*OFFSET(table_simulateur!B$20,MATCH(K150,table_simulateur!D$21:D$31,0),0)/OFFSET(table_simulateur!B$20,MATCH(K150,table_simulateur!D$21:D$31,0),1),2)","v":0},{"$f":"OFFSET(table_simulateur!H$186,MATCH(C150,table_simulateur!B$186:B$384,0)-1,0)","v":0},{"$f":"ROUND(G150*(1+H150),2)","v":0},{"$f":"+G150*M150/L150","v":{"$error":"#DIV/0!"}},"surface des bureaux",{"$f":"OFFSET(table_simulateur!B$20,MATCH(simulateur!K150,table_simulateur!D$21:D$31,0),0)","v":0},{"$f":"OFFSET(table_simulateur!C$20,MATCH(simulateur!K150,table_simulateur!D$21:D$31,0),0)","v":903.91000000000008}]
[]
[null,null,{"$f":"table_simulateur!B311","v":"Création de SAS au droit des cages d'escalier"}]
[null,null,{"$f":"table_simulateur!B312","v":"Mise en oeuvre d'un bloc-porte vitré formant SAS.\n2 ventaux tiercé (0,90+0,35m). Finition aluminium anodisé, double vitrage feuilleté. Poignées de tirage intérieure et extérieure, sans serrure."},null,null,null,{"$f":"ROUND(OFFSET(table_simulateur!F$186,MATCH(C153,table_simulateur!B$186:B$384,0)-1,0)*OFFSET(table_simulateur!B$20,MATCH(K153,table_simulateur!D$21:D$31,0),0)/OFFSET(table_simulateur!B$20,MATCH(K153,table_simulateur!D$21:D$31,0),1),2)","v":173.31},{"$f":"OFFSET(table_simulateur!H$186,MATCH(C153,table_simulateur!B$186:B$384,0)-1,0)","v":0},{"$f":"ROUND(G153*(1+H153),2)","v":173.31},{"$f":"+G153*M153/L153","v":21236.846691176499},"tantièmes",{"$f":"OFFSET(table_simulateur!B$20,MATCH(simulateur!K153,table_simulateur!D$21:D$31,0),0)","v":8.1600000000000006E-3},{"$f":"OFFSET(table_simulateur!C$20,MATCH(simulateur!K153,table_simulateur!D$21:D$31,0),0)","v":0.99990000000000134}]
[null,null,{"$f":"table_simulateur!#REF!","v":{"$error":"#REF!"}},null,null,null,{"$f":"ROUND(OFFSET(table_simulateur!F$186,MATCH(C154,table_simulateur!B$186:B$384,0)-1,0)*OFFSET(table_simulateur!B$20,MATCH(K154,table_simulateur!D$21:D$31,0),0)/OFFSET(table_simulateur!B$20,MATCH(K154,table_simulateur!D$21:D$31,0),1),2)","v":{"$error":"#REF!"}},{"$f":"OFFSET(table_simulateur!H$186,MATCH(C154,table_simulateur!B$186:B$384,0)-1,0)","v":{"$error":"#REF!"}},{"$f":"ROUND(G154*(1+H154),2)","v":{"$error":"#REF!"}},{"$f":"+G154*M154/L154","v":{"$error":"#REF!"}},"tantièmes",{"$f":"OFFSET(table_simulateur!B$20,MATCH(simulateur!K154,table_simulateur!D$21:D$31,0),0)","v":8.1600000000000006E-3},{"$f":"OFFSET(table_simulateur!C$20,MATCH(simulateur!K154,table_simulateur!D$21:D$31,0),0)","v":0.99990000000000134}]
[null,null,{"$f":"table_simulateur!#REF!","v":{"$error":"#REF!"}},null,null,null,{"$f":"ROUND(OFFSET(table_simulateur!F$186,MATCH(C155,table_simulateur!B$186:B$384,0)-1,0)*OFFSET(table_simulateur!B$20,MATCH(K155,table_simulateur!D$21:D$31,0),0)/OFFSET(table_simulateur!B$20,MATCH(K155,table_simulateur!D$21:D$31,0),1),2)","v":{"$error":"#REF!"}},{"$f":"OFFSET(table_simulateur!H$186,MATCH(C155,table_simulateur!B$186:B$384,0)-1,0)","v":{"$error":"#REF!"}},{"$f":"ROUND(G155*(1+H155),2)","v":{"$error":"#REF!"}},{"$f":"+G155*M155/L155","v":{"$error":"#REF!"}},"tantièmes",{"$f":"OFFSET(table_simulateur!B$20,MATCH(simulateur!K155,table_simulateur!D$21:D$31,0),0)","v":8.1600000000000006E-3},{"$f":"OFFSET(table_simulateur!C$20,MATCH(simulateur!K155,table_simulateur!D$21:D$31,0),0)","v":0.99990000000000134}]
[]
[null,null,{"$f":"table_simulateur!B324","v":"Option bureaux : Plus-value pour remplacement de l'ensemble des chassis extérieurs fixes des bureaux par des chassis neufs en aluminium anodisé (au lieu du survitrage prévu en base)."}]
[null,null,{"$f":"table_simulateur!B325","v":"Remplacement des portes des bureaux donnant sur la coursive (pas d'intervention prévue en base)"},null,null,null,{"$f":"ROUND(OFFSET(table_simulateur!F$186,MATCH(C158,table_simulateur!B$186:B$384,0)-1,0)*OFFSET(table_simulateur!B$20,MATCH(K158,table_simulateur!D$21:D$31,0),0)/OFFSET(table_simulateur!B$20,MATCH(K158,table_simulateur!D$21:D$31,0),1),2)","v":296.99},{"$f":"OFFSET(table_simulateur!H$186,MATCH(C158,table_simulateur!B$186:B$384,0)-1,0)","v":7.0000000000000007E-2},{"$f":"ROUND(G158*(1+H158),2)","v":317.77999999999997},{"$f":"+G158*M158/L158","v":36396.798383306275},"surface habitable",{"$f":"OFFSET(table_simulateur!B$20,MATCH(simulateur!K158,table_simulateur!D$21:D$31,0),0)","v":98.72},{"$f":"OFFSET(table_simulateur!C$20,MATCH(simulateur!K158,table_simulateur!D$21:D$31,0),0)","v":12098.359999999986}]
[null,null,{"$f":"table_simulateur!B326","v":"Remplacement des portes des bureaux intérieures donnant sur les halls (pas d'intervention prévue en base)"},null,null,null,{"$f":"ROUND(OFFSET(table_simulateur!F$186,MATCH(C159,table_simulateur!B$186:B$384,0)-1,0)*OFFSET(table_simulateur!B$20,MATCH(K159,table_simulateur!D$21:D$31,0),0)/OFFSET(table_simulateur!B$20,MATCH(K159,table_simulateur!D$21:D$31,0),1),2)","v":84.24},{"$f":"OFFSET(table_simulateur!H$186,MATCH(C159,table_simulateur!B$186:B$384,0)-1,0)","v":7.0000000000000007E-2},{"$f":"ROUND(G159*(1+H159),2)","v":90.14},{"$f":"+G159*M159/L159","v":10323.803144246342},"surface habitable",{"$f":"OFFSET(table_simulateur!B$20,MATCH(simulateur!K159,table_simulateur!D$21:D$31,0),0)","v":98.72},{"$f":"OFFSET(table_simulateur!C$20,MATCH(simulateur!K159,table_simulateur!D$21:D$31,0),0)","v":12098.359999999986}]
[null,null,{"$f":"table_simulateur!#REF!","v":{"$error":"#REF!"}},null,null,null,{"$f":"ROUND(OFFSET(table_simulateur!F$186,MATCH(C160,table_simulateur!B$186:B$384,0)-1,0)*OFFSET(table_simulateur!B$20,MATCH(K160,table_simulateur!D$21:D$31,0),0)/OFFSET(table_simulateur!B$20,MATCH(K160,table_simulateur!D$21:D$31,0),1),2)","v":{"$error":"#REF!"}},{"$f":"OFFSET(table_simulateur!H$186,MATCH(C160,table_simulateur!B$186:B$384,0)-1,0)","v":{"$error":"#REF!"}},{"$f":"ROUND(G160*(1+H160),2)","v":{"$error":"#REF!"}},{"$f":"+G160*M160/L160","v":{"$error":"#REF!"}},"surface habitable",{"$f":"OFFSET(table_simulateur!B$20,MATCH(simulateur!K160,table_simulateur!D$21:D$31,0),0)","v":98.72},{"$f":"OFFSET(table_simulateur!C$20,MATCH(simulateur!K160,table_simulateur!D$21:D$31,0),0)","v":12098.359999999986}]
[]
[null,null,{"$f":"table_simulateur!#REF!","v":{"$error":"#REF!"}}]
[null,null,{"$f":"table_simulateur!B307","v":"Isolation du plancher haut du Rez-de-Chaussée en coursives extérieures, compris remplacement du faux-plafond métallique"},null,null,null,{"$f":"ROUND(OFFSET(table_simulateur!F$186,MATCH(C163,table_simulateur!B$186:B$384,0)-1,0)*OFFSET(table_simulateur!B$20,MATCH(K163,table_simulateur!D$21:D$31,0),0)/OFFSET(table_simulateur!B$20,MATCH(K163,table_simulateur!D$21:D$31,0),1),2)","v":1076.8499999999999},{"$f":"OFFSET(table_simulateur!H$186,MATCH(C163,table_simulateur!B$186:B$384,0)-1,0)","v":7.0000000000000007E-2},{"$f":"ROUND(G163*(1+H163),2)","v":1152.23},{"$f":"+G163*M163/L163","v":122110.44856665307},"surface des logements",{"$f":"OFFSET(table_simulateur!B$20,MATCH(simulateur!K163,table_simulateur!D$21:D$31,0),0)","v":98.72},{"$f":"OFFSET(table_simulateur!C$20,MATCH(simulateur!K163,table_simulateur!D$21:D$31,0),0)","v":11194.449999999992}]
[]
[null,null,{"$f":"table_simulateur!B309","v":"Mise en œuvre d'un isolant type laine minerale et mise en œuvre d'un faux plafond métallique neuf sur ossature métallique galva"}]
[]
[null,null,{"$f":"table_simulateur!B359","v":"Réfection complète des marches et contre-marches des escaliers d'accès aux Entrées"}]
[null,null,{"$f":"table_simulateur!#REF!","v":{"$error":"#REF!"}},null,null,null,{"$f":"ROUND(OFFSET(table_simulateur!F$186,MATCH(C168,table_simulateur!B$186:B$384,0)-1,0)*OFFSET(table_simulateur!B$20,MATCH(K168,table_simulateur!D$21:D$31,0),0)/OFFSET(table_simulateur!B$20,MATCH(K168,table_simulateur!D$21:D$31,0),1),2)","v":{"$error":"#REF!"}},{"$f":"OFFSET(table_simulateur!H$186,MATCH(C168,table_simulateur!B$186:B$384,0)-1,0)","v":{"$error":"#REF!"}},{"$f":"ROUND(G168*(1+H168),2)","v":{"$error":"#REF!"}},{"$f":"+G168*M168/L168","v":{"$error":"#REF!"}},"tantièmes",{"$f":"OFFSET(table_simulateur!B$20,MATCH(simulateur!K168,table_simulateur!D$21:D$31,0),0)","v":8.1600000000000006E-3},{"$f":"OFFSET(table_simulateur!C$20,MATCH(simulateur!K168,table_simulateur!D$21:D$31,0),0)","v":0.99990000000000134}]
[null,null,{"$f":"table_simulateur!#REF!","v":{"$error":"#REF!"}},null,null,null,{"$f":"ROUND(OFFSET(table_simulateur!F$186,MATCH(C169,table_simulateur!B$186:B$384,0)-1,0)*OFFSET(table_simulateur!B$20,MATCH(K169,table_simulateur!D$21:D$31,0),0)/OFFSET(table_simulateur!B$20,MATCH(K169,table_simulateur!D$21:D$31,0),1),2)","v":{"$error":"#REF!"}},{"$f":"OFFSET(table_simulateur!H$186,MATCH(C169,table_simulateur!B$186:B$384,0)-1,0)","v":{"$error":"#REF!"}},{"$f":"ROUND(G169*(1+H169),2)","v":{"$error":"#REF!"}},{"$f":"+G169*M169/L169","v":{"$error":"#REF!"}},"tantièmes",{"$f":"OFFSET(table_simulateur!B$20,MATCH(simulateur!K169,table_simulateur!D$21:D$31,0),0)","v":8.1600000000000006E-3},{"$f":"OFFSET(table_simulateur!C$20,MATCH(simulateur!K169,table_simulateur!D$21:D$31,0),0)","v":0.99990000000000134}]
[]
[null,null,{"$f":"table_simulateur!#REF!","v":{"$error":"#REF!"}}]
[null,null,{"$f":"table_simulateur!B304","v":"Flocage sous dalle béton en laine de roche avec durcisseur dans l'ensemble des caves, garages et circulations sous l'emprise de l'élévation du bâtiment"},null,null,null,{"$f":"ROUND(OFFSET(table_simulateur!F$186,MATCH(C172,table_simulateur!B$186:B$384,0)-1,0)*OFFSET(table_simulateur!B$20,MATCH(K172,table_simulateur!D$21:D$31,0),0)/OFFSET(table_simulateur!B$20,MATCH(K172,table_simulateur!D$21:D$31,0),1),2)","v":0},{"$f":"OFFSET(table_simulateur!H$186,MATCH(C172,table_simulateur!B$186:B$384,0)-1,0)","v":0},{"$f":"ROUND(G172*(1+H172),2)","v":0},{"$f":"+G172*M172/L172","v":0},"tantièmes",{"$f":"OFFSET(table_simulateur!B$20,MATCH(simulateur!K172,table_simulateur!D$21:D$31,0),0)","v":8.1600000000000006E-3},{"$f":"OFFSET(table_simulateur!C$20,MATCH(simulateur!K172,table_simulateur!D$21:D$31,0),0)","v":0.99990000000000134}]
[]
[null,"7 - Traitement des Sous-sols"]
[]
[null,null,{"$f":"\"Répartition des coûts : \"&K177","v":"Répartition des coûts : tantièmes"}]
[null,null,{"$f":"table_simulateur!#REF!","v":{"$error":"#REF!"}},null,null,null,{"$f":"ROUND(OFFSET(table_simulateur!F$186,MATCH(C177,table_simulateur!B$186:B$384,0)-1,0)*OFFSET(table_simulateur!B$20,MATCH(K177,table_simulateur!D$21:D$31,0),0)/OFFSET(table_simulateur!B$20,MATCH(K177,table_simulateur!D$21:D$31,0),1),2)","v":{"$error":"#REF!"}},{"$f":"OFFSET(table_simulateur!H$186,MATCH(C177,table_simulateur!B$186:B$384,0)-1,0)","v":{"$error":"#REF!"}},{"$f":"ROUND(G177*(1+H177),2)","v":{"$error":"#REF!"}},{"$f":"+G177*M177/L177","v":{"$error":"#REF!"}},"tantièmes",{"$f":"OFFSET(table_simulateur!B$20,MATCH(simulateur!K177,table_simulateur!D$21:D$31,0),0)","v":8.1600000000000006E-3},{"$f":"OFFSET(table_simulateur!C$20,MATCH(simulateur!K177,table_simulateur!D$21:D$31,0),0)","v":0.99990000000000134}]
[]
[]
[]
[]
[null,null,null,null,"MONTANT TOTAL Cis options :",null,null,null,{"$f":"SUM(I43:I181)","v":{"$error":"#REF!"}},{"$f":"SUM(J43:J181)","v":{"$error":"#REF!"}}]

{"sheet":"table_simulateur","index":1,"n_rows":375,"n_cols":26,"rows_kept":375,"cut":false,"hidden":false,"merged":[[226,1,226,2],[245,1,245,2],[228,1,228,2],[316,1,316,2],[234,1,234,2],[238,1,238,2],[237,1,237,2],[239,1,239,2],[240,1,240,2],[241,1,241,2],[242,1,242,2],[236,1,236,2],[294,1,294,2],[292,1,292,2],[264,1,264,2],[265,1,265,2],[353,1,353,2],[362,1,362,2],[327,1,327,2],[246,1,246,2],[310,1,310,2],[311,1,311,2],[359,1,359,2],[360,1,360,2],[251,1,251,2],[263,1,263,2],[255,1,255,2],[259,1,259,2],[337,1,337,2],[283,1,283,2],[338,1,338,2],[341,1,341,2],[331,1,331,2],[343,1,343,2],[345,1,345,2],[323,1,323,2],[304,1,304,2],[295,1,295,2],[324,1,324,2],[325,1,325,2],[366,1,366,2],[367,1,367,2],[284,1,284,2],[247,1,247,2],[286,1,286,2],[320,1,320,2],[334,1,334,2],[256,1,256,2],[244,1,244,2],[249,1,249,2],[303,1,303,2],[307,1,307,2],[313,1,313,2],[314,1,314,2],[315,1,315,2],[317,1,317,2],[346,1,346,2],[291,1,291,2],[348,1,348,2],[322,1,322,2],[287,1,287,2],[319,1,319,2],[321,1,321,2],[358,1,358,2],[185,5,185,6],[203,1,203,2],[269,1,269,2],[209,1,209,2],[200,1,200,2],[197,1,197,2],[194,1,194,2],[206,1,206,2],[193,1,193,2],[205,1,205,2],[208,1,208,2],[199,1,199,2],[196,1,196,2],[202,1,202,2],[218,1,218,2],[219,1,219,2],[225,1,225,2],[229,1,229,2],[261,1,261,2],[190,1,190,2],[211,1,211,2],[221,1,221,2],[232,1,232,2],[233,1,233,2],[340,1,340,2],[235,1,235,2],[243,1,243,2],[273,1,273,2],[293,1,293,2],[266,1,266,2],[332,1,332,2],[335,1,335,2],[298,1,298,2],[299,1,299,2],[306,1,306,2],[308,1,308,2],[296,1,296,2],[300,1,300,2],[301,1,301,2],[372,1,372,2],[215,1,215,2],[216,1,216,2],[285,1,285,2],[248,1,248,2],[191,1,191,2],[276,1,276,2],[277,1,277,2],[282,1,282,2],[270,1,270,2],[271,1,271,2],[279,1,279,2],[280,1,280,2],[275,1,275,2],[278,1,278,2],[274,1,274,2],[272,1,272,2],[349,1,349,2],[350,1,350,2],[351,1,351,2],[260,1,260,2],[267,1,267,2],[268,1,268,2],[257,1,257,2]]}
["table_simu_liste_bien","table_simu_liste_entree","table_simu_liste_etage"]
["Logement (étage)",{"$f":"IF(bien=A2,1,IF(bien=A3,1,\"\"))","v":1},{"$f":"IF(bien=A2,\"1er étage\",IF(bien=A3,\"Rez-de-Chaussée\",\"\"))","v":"1er étage"}]
["Bureau (rez-de-chaussée)",{"$f":"IF(AND(B2<>\"\",B2<>9),B2+1,\"\")","v":2},{"$f":"IF(bien=A$2,\"2ème étage\",\"\")","v":"2ème étage"}]
[null,3,{"$f":"IF(bien=A$2,\"3ème étage\",\"\")","v":"3ème étage"}]
[null,4,{"$f":"IF(bien=A$2,\"4ème étage\",\"\")","v":"4ème étage"}]
[null,5,{"$f":"IF(bien=A$2,\"5ème étage\",\"\")","v":"5ème étage"}]
[null,6,null,"Conciergerie1"]
[null,7]
[null,8]
[null,{"$f":"IF(AND(B9<>\"\",B9<>9),B9+1,\"\")","v":9}]
[]
["table_simu_liste_numero",null,null,null,null,null,null,"Bureau",{"$f":"SUMIF(D$38:D$177,H12,E$38:E$177)","v":903.91000000000008},{"$f":"COUNTIF(D$38:D$177,H12)","v":9}]
[{"$f":"IF(AND(bien<>\"\",simulateur!D3<>\"\",simulateur!D5<>\"\"),IF(bien=A2,\"Apt \",\"\")&IF(bien=A3,IF(saisie_entree=1,\"Conciergerie\",\"Com\"),\"\")&simulateur!D3&IF(bien=table_simulateur!A2,LEFT(simulateur!D5,1)&\"1\",\"\"),\"\")","v":"Apt 111"},null,null,null,null,null,null,"Type I",{"$f":"SUMIF(D$38:D$177,H13,E$38:E$177)","v":26.9},{"$f":"COUNTIF(D$38:D$177,H13)","v":1}]
[{"$f":"IF(bien=A2,OFFSET(C37,MATCH(A13,C37:C177,0),0),\"\")","v":"Apt 112"},null,null,null,null,null,null,"Type II",1718.4000000000008,{"$f":"COUNTIF(D$38:D$177,H14)","v":40}]
[{"$f":"IF(bien=A2,IF(AND(saisie_entree=8,saisie_etage<>\"1er étage\"),\"\",OFFSET(C38,MATCH(A14,C38:C178,0),0)),\"\")","v":"Apt 113"},null,null,null,null,null,null,"Type IIe ",317.64999999999998,5]
["select apt",null,null,null,null,null,null,"Type IV",2467.9999999999995,{"$f":"COUNTIF(D$38:D$177,H16)","v":25}]
[{"$f":"saisie_numeroapt","v":"Apt 111"},null,null,null,null,null,null,"Type IVbis",2961.5999999999985,{"$f":"COUNTIF(D$38:D$177,H17)","v":30}]
[null,null,null,null,null,null,null,"Type V",2371.7999999999997,20]
[null,null,"TOTAL",null,null,null,null,"Type Vg",594.6,5]
["Typologie :",{"$f":"IF(A17<>0,OFFSET(D37,MATCH(A17,C37:C177,0)-1,0),\"\")","v":"Type IVbis"},null,null,null,null,null,"Type VI",125.58,1]
["Surface :",{"$f":"IF(A17<>0,OFFSET(E37,MATCH(A17,C37:C177,0)-1,0),\"\")","v":98.72},{"$f":"E179","v":12098.359999999986},{"$f":"E36","v":"surface habitable"},null,null,null,"Type VIIc",609.91999999999996,4]
["Surface bureaux seuls:",{"$f":"IF(A17<>0,OFFSET(F37,MATCH(A17,C37:C177,0)-1,0),\"\")","v":0},{"$f":"F179","v":903.91000000000008},{"$f":"F36","v":"surface des bureaux"},null,null,null,null,{"$f":"SUM(I12:I21)","v":12098.359999999999},{"$f":"SUM(J12:J21)","v":140}]
["Surface logements seuls:",{"$f":"IF(A17<>0,OFFSET(G37,MATCH(A17,C37:C177,0)-1,0),\"\")","v":98.72},{"$f":"G179","v":11194.449999999992},{"$f":"G36","v":"surface des logements"}]
["Tantièmes :",{"$f":"IF(A17<>0,OFFSET(H37,MATCH(A17,C37:C177,0)-1,0),\"\")","v":8.1600000000000006E-3},{"$f":"H179","v":0.99990000000000134},{"$f":"H36","v":"tantièmes"}]
["Surface loggia :",{"$f":"IF(A17<>0,OFFSET(I37,MATCH(A17,C37:C177,0)-1,0),\"\")","v":12.71},{"$f":"I179+1.54","v":1496.9000000000012},{"$f":"I36","v":"surface de loggia"}]
["Lineaire garde-corps :",{"$f":"IF(A17<>0,OFFSET(J37,MATCH(A17,C37:C177,0)-1,0),\"\")","v":6.75},{"$f":"J179","v":969.80999999999983},{"$f":"J36","v":"linéaire de garde-corps"}]
["Surface chassis mormal :",{"$f":"IF(A17<>0,OFFSET(L37,MATCH(A17,C37:C177,0)-1,0),\"\")","v":15.34},{"$f":"L179","v":1425.8499999999983},"Surface chassis Mormal"]
["Surface chassis parc et pignon :",{"$f":"IF(A17<>0,OFFSET(M37,MATCH(A17,C37:C177,0)-1,0),\"\")","v":14.3},{"$f":"M179","v":1817.8999999999999},"Surface chassis Parc"]
["Chassis pignons :",{"$f":"IF(A17<>0,OFFSET(S37,MATCH(A17,C37:C177,0)-1,0),\"\")","v":1},{"$f":"S179","v":10},"Surface chassis pignons"]
["Surface totale chassis :",{"$f":"B28+B27","v":29.64},{"$f":"K179","v":3243.7499999999955},{"$f":"K36","v":"surface actuelle des chassis"}]
["Surface option vitrage :",{"$f":"IF(A17<>0,OFFSET(N37,MATCH(A17,C37:C177,0)-1,0),\"\")","v":3.1},null,"option vitrage surface"]
[]
[]
[]
[null,null,null,null,null,null,null,"METTRE LES TANTIEMES EN FRACTION"]
[null,null,null,null,"surface habitable","surface des bureaux","surface des logements","tantièmes","surface de loggia","linéaire de garde-corps","surface actuelle des chassis","Surface chassis Parc","Surface chassis Mormal",null,null,null,null,null,"Chassis pignons :"]
["Entrée","Niveau","N°appt","Typo","Surface","Surface bureaux seuls","Surface logements seuls","Tantièmes","Surface de loggia","Linéaire de garde-corps","Surface actuelle chassis","Surface actuelle de chassis Façade avenue Mormal","Surface actuelle de chassis Façade avenue Mormal","Option : surface opaque à passer en vitrée","Chassis type C8","Chassis type C9","Chassis type C20","Chassis type C21","Chassis type P1",null,"N°Lot","Quote part parties communes générales","Quote part parties communes particulières","N°logt"]
[1,"R","Conciergerie1","Bureau",43.27,{"$f":"E38","v":43.27},null,{"$f":"ROUND(E38/E$179,5)","v":3.5799999999999998E-3},0,0]
[2,"R","Bur2","Bureau",107.58,107.58,null,8.8900000000000003E-3,0,0,null,null,null,null,null,null,null,null,null,null,"701/1",{"$f":"ROUND(1585/2,0)","v":793},{"$f":"ROUND(201/2,0)","v":101},"1/1"]
[3,"R","Bur3","Bureau",107.58,107.58,null,8.8900000000000003E-3,0,0,null,null,null,null,null,null,null,null,null,null,"701/2",{"$f":"ROUND(1585/2,0)","v":793},{"$f":"ROUND(201/2,0)","v":101},"1/2"]
[4,"R","Bur4","Bureau",107.58,107.58,null,8.8900000000000003E-3,0,0,null,null,null,null,null,null,null,null,null,null,"702/1",{"$f":"ROUND(1554/2,0)","v":777},{"$f":"ROUND(198/2,0)","v":99},"2/1"]
[5,"R","Bur5","Bureau",107.58,107.58,null,8.8900000000000003E-3,0,0,null,null,null,null,null,null,null,null,null,null,"702/2",{"$f":"ROUND(1554/2,0)","v":777},{"$f":"ROUND(198/2,0)","v":99},"2/2"]
[6,"R","Bur6","Bureau",107.58,107.58,null,8.8900000000000003E-3,0,0,null,null,null,null,null,null,null,null,null,null,"703/1",{"$f":"ROUND(1555/2,0)","v":778},{"$f":"ROUND(198/2,0)","v":99},"3/1"]
[7,"R","Bur7","Bureau",107.58,107.58,null,8.8900000000000003E-3,0,0,null,null,null,null,null,null,null,null,null,null,"703/2",{"$f":"ROUND(1555/2,0)","v":778},{"$f":"ROUND(198/2,0)","v":99},"3/2"]
[8,"R","Bur8","Bureau",107.58,107.58,null,8.8900000000000003E-3,0,0,null,null,null,null,null,null,null,null,null,null,"704/1",{"$f":"1584/2","v":792},{"$f":"ROUND(201/2,0)","v":101},"4/1"]
[9,"R","Bur9","Bureau",107.58,107.58,null,8.8900000000000003E-3,0,0,null,null,null,null,null,null,null,null,null,null,"704/2",{"$f":"1584/2","v":792},{"$f":"ROUND(201/2,0)","v":101},"4/2"]
[1,1,"Apt 111","Type IVbis",98.72,null,{"$f":"E47","v":98.72},8.1600000000000006E-3,12.71,6.75,{"$f":"L47+M47","v":29.64},{"$f":"ROUND(1.44*(3.15+3.75+3.75),2)","v":15.34},{"$f":"ROUND(P47*(2.5*3.6)+R47*(3.6*2.5-2.05*1.795)+O47*(2.5*3.6-1.31*2.05-2.29*1.2)+Q47*(2.5*3-1.495*2.05)+S47*1.4*0.61,1)","v":14.3},{"$f":"ROUND(R47*(2.05*1.795)+O47*(1.31*1.2+2.29*1.2)+Q47*(1.495*2.05),1)","v":3.1},0,1,1,0,1,null,"?",0,0,0]
[1,1,"Apt 112","Type II",42.96,null,{"$f":"E48","v":42.96},3.5500000000000002E-3,7.16,7.35,{"$f":"L48+M48","v":12.6},0,{"$f":"ROUND(P48*(2.5*3.6)+R48*(3.6*2.5-2.05*1.795)+O48*(2.5*3.6-1.31*2.05-2.29*1.2)+Q48*(2.5*3-1.495*2.05)+S48*1.4*0.61,1)","v":12.6},{"$f":"ROUND(R48*(2.05*1.795)+O48*(1.31*1.2+2.29*1.2)+Q48*(1.495*2.05),1)","v":4.3},1,1,0,0,0,null,705,394,50,121]
[1,1,"Apt 113","Type IVbis",98.72,null,98.72,8.1600000000000006E-3,12.71,6.75,28.740000000000002,{"$f":"ROUND(1.44*(3.15+3.75+3.75),2)","v":15.34},13.4,3.1,0,1,1,0,0,null,706,790,101,116]
[1,2,"Apt 121","Type IVbis",98.72,null,98.72,8.1600000000000006E-3,12.71,6.75,29.64,{"$f":"ROUND(1.44*(3.15+3.75+3.75),2)","v":15.34},14.3,3.1,0,1,1,0,1,null,730,807,103,127]
[1,2,"Apt 122","Type II",42.96,null,42.96,3.5500000000000002E-3,7.16,7.35,12.6,0,12.6,4.3,1,1,0,0,0,null,731,403,51,122]
[1,2,"Apt 123","Type IVbis",98.72,null,98.72,8.1600000000000006E-3,12.71,6.75,28.740000000000002,{"$f":"ROUND(1.44*(3.15+3.75+3.75),2)","v":15.34},13.4,3.1,0,1,1,0,0,null,732,807,103,117]
[1,3,"Apt 131","Type IVbis",98.72,null,98.72,8.1600000000000006E-3,12.71,6.75,29.64,{"$f":"ROUND(1.44*(3.15+3.75+3.75),2)","v":15.34},14.3,3.1,0,1,1,0,1,null,756,823,105,128]
[1,3,"Apt 132","Type II",42.96,null,42.96,3.5500000000000002E-3,7.16,7.35,12.6,0,12.6,4.3,1,1,0,0,0,null,757,411,52,123]
[1,3,"Apt 133","Type IVbis",98.72,null,98.72,8.1600000000000006E-3,12.71,6.75,28.740000000000002,{"$f":"ROUND(1.44*(3.15+3.75+3.75),2)","v":15.34},13.4,3.1,0,1,1,0,0,null,758,823,105,118]
[1,4,"Apt 141","Type IVbis",98.72,null,98.72,8.1600000000000006E-3,12.71,6.75,29.64,{"$f":"ROUND(1.44*(3.15+3.75+3.75),2)","v":15.34},14.3,3.1,0,1,1,0,1,null,782,840,107,129]
[1,4,"Apt 142","Type II",42.96,null,42.96,3.5500000000000002E-3,7.16,7.35,12.6,0,12.6,4.3,1,1,0,0,0,null,783,419,53,124]
[1,4,"Apt 143","Type IVbis",98.72,null,98.72,8.1600000000000006E-3,12.71,6.75,28.740000000000002,{"$f":"ROUND(1.44*(3.15+3.75+3.75),2)","v":15.34},13.4,3.1,0,1,1,0,0,null,784,840,107,119]
[1,5,"Apt 151","Type IVbis",98.72,null,98.72,8.1600000000000006E-3,12.71,6.75,29.64,{"$f":"ROUND(1.44*(3.15+3.75+3.75),2)","v":15.34},14.3,3.1,0,1,1,0,1,null,808,857,109,130]
[1,5,"Apt 152","Type II",42.96,null,42.96,3.5500000000000002E-3,7.16,7.35,12.6,0,12.6,4.3,1,1,0,0,0,null,809,428,54,125]
[1,5,"Apt 153","Type IVbis",98.72,null,98.72,8.1600000000000006E-3,12.71,6.75,28.740000000000002,{"$f":"ROUND(1.44*(3.15+3.75+3.75),2)","v":15.34},13.4,3.1,0,1,1,0,0,null,810,857,109,120]
[2,1,"Apt 211","Type IVbis",98.72,null,98.72,8.1600000000000006E-3,12.71,6.75,28.740000000000002,{"$f":"ROUND(1.44*(3.15+3.75+3.75),2)","v":15.34},13.4,3.1,0,1,1,0,0,null,707,790,101,111]
[2,1,"Apt 212","Type II",42.96,null,42.96,3.5500000000000002E-3,7.16,7.35,12.6,0,12.6,4.3,1,1,0,0,0,null,708,394,50,106]
[2,1,"Apt 213","Type IVbis",98.72,null,98.72,8.1600000000000006E-3,12.71,6.75,28.740000000000002,{"$f":"ROUND(1.44*(3.15+3.75+3.75),2)","v":15.34},13.4,3.1,0,1,1,0,0,null,709,790,101,101]
[2,2,"Apt 221","Type IVbis",98.72,null,98.72,8.1600000000000006E-3,12.71,6.75,28.740000000000002,{"$f":"ROUND(1.44*(3.15+3.75+3.75),2)","v":15.34},13.4,3.1,0,1,1,0,0,null,733,807,103,112]
[2,2,"Apt 222","Type II",42.96,null,42.96,3.5500000000000002E-3,7.16,7.35,12.6,0,12.6,4.3,1,1,0,0,0,null,734,403,51,107]
[2,2,"Apt 223","Type IVbis",98.72,null,98.72,8.1600000000000006E-3,12.71,6.75,28.740000000000002,{"$f":"ROUND(1.44*(3.15+3.75+3.75),2)","v":15.34},13.4,3.1,0,1,1,0,0,null,735,807,103,102]
[2,3,"Apt 231","Type IVbis",98.72,null,98.72,8.1600000000000006E-3,12.71,6.75,28.740000000000002,{"$f":"ROUND(1.44*(3.15+3.75+3.75),2)","v":15.34},13.4,3.1,0,1,1,0,0,null,759,823,105,113]
[2,3,"Apt 232","Type II",42.96,null,42.96,3.5500000000000002E-3,7.16,7.35,12.6,0,12.6,4.3,1,1,0,0,0,null,760,411,52,108]
[2,3,"Apt 233","Type IVbis",98.72,null,98.72,{"$f":"ROUND(E70/E$179,5)","v":8.1600000000000006E-3},12.71,6.75,28.740000000000002,{"$f":"ROUND(1.44*(3.15+3.75+3.75),2)","v":15.34},13.4,3.1,0,1,1,0,0,null,761,823,105,103]
[2,4,"Apt 241","Type IVbis",98.72,null,98.72,8.1600000000000006E-3,12.71,6.75,28.740000000000002,{"$f":"ROUND(1.44*(3.15+3.75+3.75),2)","v":15.34},13.4,3.1,0,1,1,0,0,null,785,840,107,114]
[2,4,"Apt 242","Type II",42.96,null,42.96,3.5500000000000002E-3,7.16,7.35,12.6,0,12.6,4.3,1,1,0,0,0,null,786,419,53,109]
[2,4,"Apt 243","Type IVbis",98.72,null,98.72,8.1600000000000006E-3,12.71,6.75,28.740000000000002,{"$f":"ROUND(1.44*(3.15+3.75+3.75),2)","v":15.34},13.4,3.1,0,1,1,0,0,null,787,840,107,104]
[2,5,"Apt 251","Type IVbis",98.72,null,98.72,8.1600000000000006E-3,12.71,6.75,28.740000000000002,{"$f":"ROUND(1.44*(3.15+3.75+3.75),2)","v":15.34},13.4,3.1,0,1,1,0,0,null,811,857,109,115]
[2,5,"Apt 252","Type II",42.96,null,42.96,3.5500000000000002E-3,7.16,7.35,12.6,0,12.6,4.3,1,1,0,0,0,null,812,428,54,110]
[2,5,"Apt 253","Type IVbis",98.72,null,98.72,8.1600000000000006E-3,12.71,6.75,28.740000000000002,{"$f":"ROUND(1.44*(3.15+3.75+3.75),2)","v":15.34},13.4,3.1,0,1,1,0,0,null,813,857,109,105]
[3,1,"Apt 311","Type IV",98.72,null,98.72,8.1600000000000006E-3,12.71,6.75,28.740000000000002,{"$f":"ROUND(1.44*(3.15+3.75+3.75),2)","v":15.34},13.4,3.1,0,1,1,0,0,null,710,757,96,96]
[3,1,"Apt 312","Type II",42.96,null,42.96,3.5500000000000002E-3,7.16,7.35,12.6,0,12.6,4.3,1,1,0,0,0,null,711,394,50,91]
[3,1,"Apt 313","Type V",118.59,null,{"$f":"E79","v":118.59},9.7999999999999997E-3,14.25,9.9,{"$f":"L79+M79","v":33.239999999999995},{"$f":"ROUND(1.44*(3.15+3.75+3.75),2)","v":15.34},{"$f":"ROUND(P79*(2.5*3.6)+R79*(3.6*2.5-2.05*1.795)+O79*(2.5*3.6-1.31*2.05-2.29*1.2)+Q79*(2.5*3-1.495*2.05)+S79*1.4*0.61,1)","v":17.899999999999999},{"$f":"ROUND(R79*(2.05*1.795)+O79*(1.31*1.2+2.29*1.2)+Q79*(1.495*2.05),1)","v":6.1},0,1,2,0,0,null,712,905,115,86]
[3,2,"Apt 321","Type IV",98.72,null,98.72,8.1600000000000006E-3,12.71,6.75,28.740000000000002,{"$f":"ROUND(1.44*(3.15+3.75+3.75),2)","v":15.34},13.4,3.1,0,1,1,0,0,null,736,773,98,97]
[3,2,"Apt 322","Type II",42.96,null,42.96,3.5500000000000002E-3,7.16,7.35,12.6,0,12.6,4.3,1,1,0,0,0,null,737,403,51,92]
[3,2,"Apt 323","Type V",118.59,null,118.59,9.7999999999999997E-3,14.25,6.75,33.270000000000003,{"$f":"ROUND(1.44*(3.15+3.15+3.75+3.75),2)","v":19.87},13.4,3.1,0,1,1,0,0,null,738,883,112,87]
[3,3,"Apt 331","Type IV",98.72,null,98.72,8.1600000000000006E-3,12.71,6.75,28.740000000000002,{"$f":"ROUND(1.44*(3.15+3.75+3.75),2)","v":15.34},13.4,3.1,0,1,1,0,0,null,762,789,100,98]
[3,3,"Apt 332","Type II",42.96,null,42.96,3.5500000000000002E-3,7.16,7.35,12.6,0,12.6,4.3,1,1,0,0,0,null,763,411,52,93]
[3,3,"Apt 333","Type V",118.59,null,118.59,9.7999999999999997E-3,14.25,9.9,33.239999999999995,{"$f":"ROUND(1.44*(3.15+3.75+3.75),2)","v":15.34},17.899999999999999,6.1,0,1,2,0,0,null,764,944,120,88]
[3,4,"Apt 341","Type IV",98.72,null,98.72,8.1600000000000006E-3,12.71,6.75,28.740000000000002,{"$f":"ROUND(1.44*(3.15+3.75+3.75),2)","v":15.34},13.4,3.1,0,1,1,0,0,null,788,805,102,99]
[3,4,"Apt 342","Type II",42.96,null,42.96,3.5500000000000002E-3,7.16,7.35,12.6,0,12.6,4.3,1,1,0,0,0,null,789,419,53,94]
[3,4,"Apt 343","Type V",118.59,null,118.59,9.7999999999999997E-3,12.71,6.75,33.270000000000003,{"$f":"ROUND(1.44*(3.15+3.15+3.75+3.75),2)","v":19.87},13.4,3.1,0,1,1,0,0,null,790,920,117,89]
[3,5,"Apt 351","Type IV",98.72,null,98.72,8.1600000000000006E-3,12.71,6.75,28.740000000000002,{"$f":"ROUND(1.44*(3.15+3.75+3.75),2)","v":15.34},13.4,3.1,0,1,1,0,0,null,814,821,105,100]
[3,5,"Apt 352","Type II",42.96,null,42.96,3.5500000000000002E-3,7.16,7.35,12.6,0,12.6,4.3,1,1,0,0,0,null,815,428,54,95]
[3,5,"Apt 353","Type V",118.59,null,118.59,9.7999999999999997E-3,14.25,9.9,33.239999999999995,{"$f":"ROUND(1.44*(3.15+3.75+3.75),2)","v":15.34},17.899999999999999,6.1,0,1,2,0,0,null,816,982,125,90]
[4,1,"Apt 411","Type V",118.59,null,118.59,9.7999999999999997E-3,14.25,6.75,33.270000000000003,{"$f":"ROUND(1.44*(3.15+3.15+3.75+3.75),2)","v":19.87},13.4,3.1,0,1,1,0,0,null,713,865,110,81]
[4,1,"Apt 412","Type II",42.96,null,42.96,3.5500000000000002E-3,7.16,7.35,12.6,0,12.6,4.3,1,1,0,0,0,null,714,394,50,76]
[4,1,"Apt 413","Type IV",98.72,null,98.72,8.1600000000000006E-3,12.71,6.75,28.740000000000002,{"$f":"ROUND(1.44*(3.15+3.75+3.75),2)","v":15.34},13.4,3.1,0,1,1,0,0,null,715,757,96,71]
[4,2,"Apt 421","Type V",118.59,null,118.59,9.7999999999999997E-3,14.25,9.9,33.239999999999995,{"$f":"ROUND(1.44*(3.15+3.75+3.75),2)","v":15.34},17.899999999999999,6.1,0,1,2,0,0,null,739,924,118,82]
[4,2,"Apt 422","Type II",42.96,null,42.96,3.5500000000000002E-3,7.16,7.35,12.6,0,12.6,4.3,1,1,0,0,0,null,740,403,51,77]
[4,2,"Apt 423","Type IV",98.72,null,98.72,8.1600000000000006E-3,12.71,6.75,28.740000000000002,{"$f":"ROUND(1.44*(3.15+3.75+3.75),2)","v":15.34},13.4,3.1,0,1,1,0,0,null,741,773,98,72]
[4,3,"Apt 431","Type V",118.59,null,118.59,9.7999999999999997E-3,14.25,6.75,33.270000000000003,{"$f":"ROUND(1.44*(3.15+3.15+3.75+3.75),2)","v":19.87},13.4,3.1,0,1,1,0,0,null,765,902,115,83]
[4,3,"Apt 432","Type II",42.96,null,42.96,3.5500000000000002E-3,7.16,7.35,12.6,0,12.6,4.3,1,1,0,0,0,null,766,411,52,78]
[4,3,"Apt 433","Type IV",98.72,null,98.72,8.1600000000000006E-3,12.71,6.75,28.740000000000002,{"$f":"ROUND(1.44*(3.15+3.75+3.75),2)","v":15.34},13.4,3.1,0,1,1,0,0,null,767,789,100,73]
[4,4,"Apt 441","Type V",118.59,null,118.59,9.7999999999999997E-3,14.25,9.9,33.239999999999995,{"$f":"ROUND(1.44*(3.15+3.75+3.75),2)","v":15.34},17.899999999999999,6.1,0,1,2,0,0,null,791,963,123,84]
[4,4,"Apt 442","Type II",42.96,null,42.96,{"$f":"ROUND(E102/E$179,5)","v":3.5500000000000002E-3},7.16,7.35,12.6,0,12.6,4.3,1,1,0,0,0,null,792,419,53,79]
[4,4,"Apt 443","Type IV",98.72,null,98.72,8.1600000000000006E-3,12.71,6.75,28.740000000000002,{"$f":"ROUND(1.44*(3.15+3.75+3.75),2)","v":15.34},13.4,3.1,0,1,1,0,0,null,793,805,102,74]
[4,5,"Apt 451","Type V",118.59,null,118.59,9.7999999999999997E-3,14.25,6.75,33.270000000000003,{"$f":"ROUND(1.44*(3.15+3.15+3.75+3.75),2)","v":19.87},13.4,3.1,0,1,1,0,0,null,817,939,120,85]
[4,5,"Apt 452","Type II",42.96,null,42.96,3.5500000000000002E-3,7.16,7.35,12.6,0,12.6,4.3,1,1,0,0,0,null,818,428,54,80]
[4,5,"Apt 453","Type IV",98.72,null,98.72,8.1600000000000006E-3,12.71,6.75,28.740000000000002,{"$f":"ROUND(1.44*(3.15+3.75+3.75),2)","v":15.34},13.4,3.1,0,1,1,0,0,null,819,821,105,75]
[5,1,"Apt 511","Type IV",98.72,null,98.72,8.1600000000000006E-3,12.71,6.75,28.740000000000002,{"$f":"ROUND(1.44*(3.15+3.75+3.75),2)","v":15.34},13.4,3.1,0,1,1,0,0,null,716,757,96,66]
[5,1,"Apt 512","Type II",42.96,null,42.96,3.5500000000000002E-3,7.16,7.35,12.6,0,12.6,4.3,1,1,0,0,0,null,717,394,50,61]
[5,1,"Apt 513","Type V",118.59,null,118.59,9.7999999999999997E-3,14.25,6.75,33.270000000000003,{"$f":"ROUND(1.44*(3.15+3.15+3.75+3.75),2)","v":19.87},13.4,3.1,0,1,1,0,0,null,718,865,110,56]
[5,2,"Apt 521","Type IV",98.72,null,98.72,8.1600000000000006E-3,12.71,6.75,28.740000000000002,{"$f":"ROUND(1.44*(3.15+3.75+3.75),2)","v":15.34},13.4,3.1,0,1,1,0,0,null,742,773,98,67]
[5,2,"Apt 522","Type II",42.96,null,{"$f":"E111","v":42.96},3.5500000000000002E-3,7.16,7.35,{"$f":"L111+M111","v":12.6},0,{"$f":"ROUND(P111*(2.5*3.6)+R111*(3.6*2.5-2.05*1.795)+O111*(2.5*3.6-1.31*2.05-2.29*1.2)+Q111*(2.5*3-1.495*2.05)+S111*1.4*0.61,1)","v":12.6},{"$f":"ROUND(R111*(2.05*1.795)+O111*(1.31*1.2+2.29*1.2)+Q111*(1.495*2.05),1)","v":4.3},1,1,0,0,0,null,743,403,51,62]
[5,2,"Apt 523","Type V",118.59,null,118.59,9.7999999999999997E-3,14.25,9.9,33.239999999999995,{"$f":"ROUND(1.44*(3.15+3.75+3.75),2)","v":15.34},17.899999999999999,6.1,0,1,2,0,0,null,744,924,118,57]
[5,3,"Apt 531","Type IV",98.72,null,98.72,8.1600000000000006E-3,12.71,6.75,28.740000000000002,{"$f":"ROUND(1.44*(3.15+3.75+3.75),2)","v":15.34},13.4,3.1,0,1,1,0,0,null,768,789,100,68]
[5,3,"Apt 532","Type II",42.96,null,42.96,3.5500000000000002E-3,7.16,7.35,12.6,0,12.6,4.3,1,1,0,0,0,null,769,411,52,63]
[5,3,"Apt 533","Type V",118.59,null,118.59,9.7999999999999997E-3,14.25,6.75,33.270000000000003,{"$f":"ROUND(1.44*(3.15+3.15+3.75+3.75),2)","v":19.87},13.4,3.1,0,1,1,0,0,null,770,902,115,58]
[5,4,"Apt 541","Type IV",98.72,null,98.72,8.1600000000000006E-3,12.71,6.75,28.740000000000002,{"$f":"ROUND(1.44*(3.15+3.75+3.75),2)","v":15.34},13.4,3.1,0,1,1,0,0,null,794,805,102,69]
[5,4,"Apt 542","Type II",42.96,null,42.96,3.5500000000000002E-3,7.16,7.35,12.6,0,12.6,4.3,1,1,0,0,0,null,795,419,53,64]
[5,4,"Apt 543","Type V",118.59,null,118.59,9.7999999999999997E-3,14.25,9.9,33.239999999999995,{"$f":"ROUND(1.44*(3.15+3.75+3.75),2)","v":15.34},17.899999999999999,6.1,0,1,2,0,0,null,796,963,123,59]
[5,5,"Apt 551","Type IV",98.72,null,98.72,8.1600000000000006E-3,12.71,6.75,28.740000000000002,{"$f":"ROUND(1.44*(3.15+3.75+3.75),2)","v":15.34},13.4,3.1,0,1,1,0,0,null,820,821,105,70]
[5,5,"Apt 552","Type II",42.96,null,42.96,3.5500000000000002E-3,7.16,7.35,12.6,0,12.6,4.3,1,1,0,0,0,null,821,428,54,65]
[5,5,"Apt 553","Type V",118.59,null,118.59,9.7999999999999997E-3,14.25,6.75,33.270000000000003,{"$f":"ROUND(1.44*(3.15+3.15+3.75+3.75),2)","v":19.87},13.4,3.1,0,1,1,0,0,null,822,939,120,60]
[6,1,"Apt 611","Type V",118.59,null,118.59,9.7999999999999997E-3,14.25,9.9,33.239999999999995,{"$f":"ROUND(1.44*(3.15+3.75+3.75),2)","v":15.34},17.899999999999999,6.1,0,1,2,0,0,null,719,905,115,51]
[6,1,"Apt 612","Type II",42.96,null,42.96,3.5500000000000002E-3,7.16,7.35,12.6,0,12.6,4.3,1,1,0,0,0,null,720,394,50,46]
[6,1,"Apt 613","Type IV",98.72,null,98.72,8.1600000000000006E-3,12.71,6.75,28.740000000000002,{"$f":"ROUND(1.44*(3.15+3.75+3.75),2)","v":15.34},13.4,3.1,0,1,1,0,0,null,721,757,96,41]
[6,2,"Apt 621","Type V",118.59,null,118.59,9.7999999999999997E-3,14.25,6.75,33.270000000000003,{"$f":"ROUND(1.44*(3.15+3.15+3.75+3.75),2)","v":19.87},13.4,3.1,0,1,1,0,0,null,745,883,112,52]
[6,2,"Apt 622","Type II",42.96,null,42.96,3.5500000000000002E-3,7.16,7.35,12.6,0,12.6,4.3,1,1,0,0,0,null,746,403,51,47]
[6,2,"Apt 623","Type IV",98.72,null,98.72,8.1600000000000006E-3,12.71,6.75,28.740000000000002,{"$f":"ROUND(1.44*(3.15+3.75+3.75),2)","v":15.34},13.4,3.1,0,1,1,0,0,null,747,773,98,42]
[6,3,"Apt 631","Type V",118.59,null,118.59,9.7999999999999997E-3,14.25,9.9,33.239999999999995,{"$f":"ROUND(1.44*(3.15+3.75+3.75),2)","v":15.34},17.899999999999999,6.1,0,1,2,0,0,null,771,944,120,53]
[6,3,"Apt 632","Type II",42.96,null,42.96,3.5500000000000002E-3,7.16,7.35,12.6,0,12.6,4.3,1,1,0,0,0,null,772,411,52,48]
[6,3,"Apt 633","Type IV",98.72,null,98.72,8.1600000000000006E-3,12.71,6.75,28.740000000000002,{"$f":"ROUND(1.44*(3.15+3.75+3.75),2)","v":15.34},13.4,3.1,0,1,1,0,0,null,773,789,100,43]
[6,4,"Apt 641","Type V",118.59,null,118.59,9.7999999999999997E-3,14.25,6.75,33.270000000000003,{"$f":"ROUND(1.44*(3.15+3.15+3.75+3.75),2)","v":19.87},13.4,3.1,0,1,1,0,0,null,797,920,117,54]
[6,4,"Apt 642","Type II",42.96,null,42.96,3.5500000000000002E-3,7.16,7.35,12.6,0,12.6,4.3,1,1,0,0,0,null,798,419,53,49]
[6,4,"Apt 643","Type IV",98.72,null,98.72,8.1600000000000006E-3,12.71,6.75,28.740000000000002,{"$f":"ROUND(1.44*(3.15+3.75+3.75),2)","v":15.34},13.4,3.1,0,1,1,0,0,null,799,805,102,44]
[6,5,"Apt 651","Type V",118.59,null,118.59,{"$f":"ROUND(E134/E$179,5)","v":9.7999999999999997E-3},14.25,9.9,33.239999999999995,{"$f":"ROUND(1.44*(3.15+3.75+3.75),2)","v":15.34},17.899999999999999,6.1,0,1,2,0,0,null,823,982,125,55]
[6,5,"Apt 652","Type II",42.96,null,42.96,3.5500000000000002E-3,7.16,7.35,12.6,0,12.6,4.3,1,1,0,0,0,null,824,428,54,50]
[6,5,"Apt 653","Type IV",98.72,null,98.72,8.1600000000000006E-3,12.71,6.75,28.740000000000002,{"$f":"ROUND(1.44*(3.15+3.75+3.75),2)","v":15.34},13.4,3.1,0,1,1,0,0,null,825,821,105,45]
[7,1,"Apt 711","Type IV",98.72,null,98.72,8.1600000000000006E-3,12.71,6.75,28.740000000000002,{"$f":"ROUND(1.44*(3.15+3.75+3.75),2)","v":15.34},13.4,3.1,0,1,1,0,0,null,722,757,96,36]
[7,1,"Apt 712","Type II",42.96,null,42.96,3.5500000000000002E-3,7.16,7.35,12.6,0,12.6,4.3,1,1,0,0,0,null,723,394,50,31]
[7,1,"Apt 713","Type IIe ",63.53,null,63.53,5.2500000000000003E-3,{"$f":"ROUND(2.68*3.6,2)","v":9.65},{"$f":"ROUND(6.75/2,2)","v":3.38},19.8,{"$f":"ROUND(1.44*(3.75+3.75),2)","v":10.8},9,0,0,1,0,0,0,null,724,536,68,26]
[7,2,"Apt 721","Type IV",98.72,null,98.72,8.1600000000000006E-3,12.71,6.75,28.740000000000002,{"$f":"ROUND(1.44*(3.15+3.75+3.75),2)","v":15.34},13.4,3.1,0,1,1,0,0,null,748,773,98,37]
[7,2,"Apt 722","Type II",42.96,null,42.96,3.5500000000000002E-3,7.16,7.35,12.6,0,12.6,4.3,1,1,0,0,0,null,749,403,51,32]
[7,2,"Apt 723","Type IIe ",63.53,null,63.53,5.2500000000000003E-3,{"$f":"ROUND(2.68*3.6,2)","v":9.65},{"$f":"ROUND(6.75/2,2)","v":3.38},19.8,{"$f":"ROUND(1.44*(3.75+3.75),2)","v":10.8},9,0,0,1,0,0,0,null,750,550,70,27]
[7,3,"Apt 731","Type IV",98.72,null,{"$f":"E143","v":98.72},8.1600000000000006E-3,12.71,6.75,{"$f":"L143+M143","v":28.740000000000002},{"$f":"ROUND(1.44*(3.15+3.75+3.75),2)","v":15.34},{"$f":"ROUND(P143*(2.5*3.6)+R143*(3.6*2.5-2.05*1.795)+O143*(2.5*3.6-1.31*2.05-2.29*1.2)+Q143*(2.5*3-1.495*2.05)+S143*1.4*0.61,1)","v":13.4},{"$f":"ROUND(R143*(2.05*1.795)+O143*(1.31*1.2+2.29*1.2)+Q143*(1.495*2.05),1)","v":3.1},0,1,1,0,0,null,774,789,100,38]
[7,3,"Apt 732","Type II",42.96,null,42.96,3.5500000000000002E-3,7.16,7.35,12.6,0,12.6,4.3,1,1,0,0,0,null,775,411,52,33]
[7,3,"Apt 733","Type IIe ",63.53,null,63.53,5.2500000000000003E-3,{"$f":"ROUND(2.68*3.6,2)","v":9.65},{"$f":"ROUND(6.75/2,2)","v":3.38},19.8,{"$f":"ROUND(1.44*(3.75+3.75),2)","v":10.8},9,0,0,1,0,0,0,null,776,559,71,28]
[7,4,"Apt 741","Type IV",98.72,null,98.72,8.1600000000000006E-3,12.71,6.75,28.740000000000002,{"$f":"ROUND(1.44*(3.15+3.75+3.75),2)","v":15.34},13.4,3.1,0,1,1,0,0,null,800,805,102,39]
[7,4,"Apt 742","Type II",42.96,null,42.96,3.5500000000000002E-3,7.16,7.35,12.6,0,12.6,4.3,1,1,0,0,0,null,801,419,53,34]
[7,4,"Apt 743","Type IIe ",63.53,null,63.53,5.2500000000000003E-3,{"$f":"ROUND(2.68*3.6,2)","v":9.65},{"$f":"ROUND(6.75/2,2)","v":3.38},19.8,{"$f":"ROUND(1.44*(3.75+3.75),2)","v":10.8},9,0,0,1,0,0,0,null,802,571,73,29]
[7,5,"Apt 751","Type IV",98.72,null,98.72,8.1600000000000006E-3,12.71,6.75,28.740000000000002,{"$f":"ROUND(1.44*(3.15+3.75+3.75),2)","v":15.34},13.4,3.1,0,1,1,0,0,null,826,821,105,40]
[7,5,"Apt 752","Type II",42.96,null,42.96,3.5500000000000002E-3,7.16,7.35,12.6,0,12.6,4.3,1,1,0,0,0,null,827,428,54,35]
[7,5,"Apt 753","Type IIe ",63.53,null,63.53,5.2500000000000003E-3,{"$f":"ROUND(2.68*3.6,2)","v":9.65},{"$f":"ROUND(6.75/2,2)","v":3.38},19.8,{"$f":"ROUND(1.44*(3.75+3.75),2)","v":10.8},9,0,0,1,0,0,0,null,828,582,74,30]
[8,1,"Apt 811","Type VI",125.58,null,125.58,1.038E-2,{"$f":"12.71+12.71-9.65","v":15.770000000000001},{"$f":"ROUND(6.75*1.5,2)","v":10.130000000000001},43.07,{"$f":"ROUND(1.44*(3.15+3.15+3.75+3.75),2)","v":19.87},23.2,9.8000000000000007,0,1,2,1,0,null,"725/1",{"$f":"ROUND(1139*125.58/(125.58+26.9),0)","v":938},{"$f":"ROUND(145*125.58/(125.58+26.9),0)","v":119},"21/1"]
[8,1,"Apt 811bis","Type I",26.9,null,26.9,2.2200000000000002E-3,{"$f":"7.16/2","v":3.58},{"$f":"ROUND(7.35/2,2)","v":3.68},5.3,0,5.3,3.7,0,0,0,1,0,null,"725/2",{"$f":"ROUND(1139*26.9/(125.58+26.9),0)","v":201},{"$f":"ROUND(145*26.9/(125.58+26.9),0)","v":26},"21/2"]
[8,1,"Apt 812","Type Vg",118.92,null,118.92,9.8300000000000002E-3,{"$f":"12.71+7.16/2","v":16.29},{"$f":"ROUND(6.75+7.35/2,2)","v":10.43},28.740000000000002,{"$f":"ROUND(1.44*(3.15+3.75+3.75),2)","v":15.34},13.4,3.1,0,1,1,0,0,null,726,929,118,16]
[8,2,"Apt 821","Type VIIc",152.47999999999999,null,152.47999999999999,1.26E-2,{"$f":"12.71+12.71-9.65+7.16/2","v":19.350000000000001},{"$f":"ROUND(6.75*1.5+7.35/2,2)","v":13.8},43.07,{"$f":"ROUND(1.44*(3.15+3.15+3.75+3.75),2)","v":19.87},23.2,9.8000000000000007,0,1,2,1,0,null,751,1160,148,22]
[8,2,"Apt 822","Type Vg",118.92,null,118.92,9.8300000000000002E-3,{"$f":"12.71+7.16/2","v":16.29},{"$f":"ROUND(6.75+7.35/2,2)","v":10.43},34.14,{"$f":"ROUND(1.44*(3.15+3.75+3.75),2)","v":15.34},18.8,6.7,0,1,1,1,0,null,752,949,121,17,null,"Remy"]
[8,3,"Apt 831","Type VIIc",152.47999999999999,null,152.47999999999999,1.26E-2,{"$f":"12.71+12.71-9.65+7.16/2","v":19.350000000000001},{"$f":"ROUND(6.75*1.5+7.35/2,2)","v":13.8},43.07,{"$f":"ROUND(1.44*(3.15+3.15+3.75+3.75),2)","v":19.87},23.2,9.8000000000000007,0,1,2,1,0,null,777,1180,150,23]
[8,3,"Apt 832","Type Vg",118.92,null,118.92,9.8300000000000002E-3,{"$f":"12.71+7.16/2","v":16.29},{"$f":"ROUND(6.75+7.35/2,2)","v":10.43},34.14,{"$f":"ROUND(1.44*(3.15+3.75+3.75),2)","v":15.34},18.8,6.7,0,1,1,1,0,null,778,969,124,18]
[8,4,"Apt 841","Type VIIc",152.47999999999999,null,152.47999999999999,1.26E-2,{"$f":"12.71+12.71-9.65+7.16/2","v":19.350000000000001},{"$f":"ROUND(6.75*1.5+7.35/2,2)","v":13.8},43.07,{"$f":"ROUND(1.44*(3.15+3.15+3.75+3.75),2)","v":19.87},23.2,9.8000000000000007,0,1,2,1,0,null,803,1200,153,24]
[8,4,"Apt 842","Type Vg",118.92,null,118.92,9.8300000000000002E-3,{"$f":"12.71+7.16/2","v":16.29},{"$f":"ROUND(6.75+7.35/2,2)","v":10.43},34.14,{"$f":"ROUND(1.44*(3.15+3.75+3.75),2)","v":15.34},18.8,6.7,0,1,1,1,0,null,804,988,126,19]
[8,5,"Apt 851","Type VIIc",152.47999999999999,null,152.47999999999999,1.26E-2,{"$f":"12.71+12.71-9.65+7.16/2","v":19.350000000000001},{"$f":"ROUND(6.75*1.5+7.35/2,2)","v":13.8},43.07,{"$f":"ROUND(1.44*(3.15+3.15+3.75+3.75),2)","v":19.87},23.2,9.8000000000000007,0,1,2,1,0,null,829,1221,155,25]
[8,5,"Apt 852","Type Vg",118.92,null,118.92,9.8300000000000002E-3,{"$f":"12.71+7.16/2","v":16.29},{"$f":"ROUND(6.75+7.35/2,2)","v":10.43},34.14,{"$f":"ROUND(1.44*(3.15+3.75+3.75),2)","v":15.34},18.8,6.7,0,1,1,1,0,null,830,1008,128,20]
[9,1,"Apt 911","Type IVbis",98.72,null,98.72,8.1600000000000006E-3,12.71,6.75,28.740000000000002,{"$f":"ROUND(1.44*(3.15+3.75+3.75),2)","v":15.34},13.4,3.1,0,1,1,0,0,null,727,790,101,11]
[9,1,"Apt 912","Type II",42.96,null,42.96,3.5500000000000002E-3,7.16,7.35,12.6,0,12.6,4.3,1,1,0,0,0,null,728,394,50,6]
[9,1,"Apt 913","Type IVbis",98.72,null,98.72,8.1600000000000006E-3,12.71,6.75,29.64,{"$f":"ROUND(1.44*(3.15+3.75+3.75),2)","v":15.34},14.3,3.1,0,1,1,0,1,null,729,790,101,1]
[9,2,"Apt 921","Type IVbis",98.72,null,98.72,{"$f":"ROUND(E166/E$179,5)","v":8.1600000000000006E-3},12.71,6.75,28.740000000000002,{"$f":"ROUND(1.44*(3.15+3.75+3.75),2)","v":15.34},13.4,3.1,0,1,1,0,0,null,753,807,103,12]
[9,2,"Apt 922","Type II",42.96,null,42.96,3.5500000000000002E-3,7.16,7.35,12.6,0,12.6,4.3,1,1,0,0,0,null,754,403,51,7]
[9,2,"Apt 923","Type IVbis",98.72,null,98.72,8.1600000000000006E-3,12.71,6.75,29.64,{"$f":"ROUND(1.44*(3.15+3.75+3.75),2)","v":15.34},14.3,3.1,0,1,1,0,1,null,755,807,103,2]
[9,3,"Apt 931","Type IVbis",98.72,null,98.72,8.1600000000000006E-3,12.71,6.75,28.740000000000002,{"$f":"ROUND(1.44*(3.15+3.75+3.75),2)","v":15.34},13.4,3.1,0,1,1,0,0,null,779,823,105,13]
[9,3,"Apt 932","Type II",42.96,null,42.96,3.5500000000000002E-3,7.16,7.35,12.6,0,12.6,4.3,1,1,0,0,0,null,780,411,52,8]
[9,3,"Apt 933","Type IVbis",98.72,null,98.72,8.1600000000000006E-3,12.71,6.75,29.64,{"$f":"ROUND(1.44*(3.15+3.75+3.75),2)","v":15.34},14.3,3.1,0,1,1,0,1,null,781,823,105,3]
[9,4,"Apt 941","Type IVbis",98.72,null,98.72,8.1600000000000006E-3,12.71,6.75,28.740000000000002,{"$f":"ROUND(1.44*(3.15+3.75+3.75),2)","v":15.34},13.4,3.1,0,1,1,0,0,null,805,840,107,14]
[9,4,"Apt 942","Type II",42.96,null,42.96,3.5500000000000002E-3,7.16,7.35,12.6,0,12.6,4.3,1,1,0,0,0,null,806,419,53,9]
[9,4,"Apt 943","Type IVbis",98.72,null,98.72,8.1600000000000006E-3,12.71,6.75,29.64,{"$f":"ROUND(1.44*(3.15+3.75+3.75),2)","v":15.34},14.3,3.1,0,1,1,0,1,null,807,840,107,4]
[9,5,"Apt 951","Type IVbis",98.72,null,98.72,8.1600000000000006E-3,12.71,6.75,{"$f":"L175+M175","v":28.740000000000002},{"$f":"ROUND(1.44*(3.15+3.75+3.75),2)","v":15.34},13.4,{"$f":"ROUND(R175*(2.05*1.795)+O175*(1.31*1.2+2.29*1.2)+Q175*(1.495*2.05),1)","v":3.1},0,1,1,0,0,null,831,857,109,15]
[9,5,"Apt 952","Type II",42.96,null,42.96,3.5500000000000002E-3,7.16,7.35,{"$f":"L176+M176","v":12.6},0,12.6,{"$f":"ROUND(R176*(2.05*1.795)+O176*(1.31*1.2+2.29*1.2)+Q176*(1.495*2.05),1)","v":4.3},1,1,0,0,0,null,832,428,54,10]
[9,5,"Apt 953","Type IVbis",98.72,null,{"$f":"E177","v":98.72},8.1600000000000006E-3,12.71,6.75,{"$f":"L177+M177","v":29.64},{"$f":"ROUND(1.44*(3.15+3.75+3.75),2)","v":15.34},{"$f":"ROUND(P177*(2.5*3.6)+R177*(3.6*2.5-2.05*1.795)+O177*(2.5*3.6-1.31*2.05-2.29*1.2)+Q177*(2.5*3-1.495*2.05)+S177*1.4*0.61,1)","v":14.3},{"$f":"ROUND(R177*(2.05*1.795)+O177*(1.31*1.2+2.29*1.2)+Q177*(1.495*2.05),1)","v":3.1},0,1,1,0,1,null,833,857,109,5]
[]
[null,null,null,null,{"$f":"SUM(E37:E177)","v":12098.359999999986},903.91000000000008,11194.449999999992,0.99990000000000134,1495.3600000000013,969.80999999999983,3243.7499999999955,1425.8499999999983,1817.8999999999999,517.10000000000082,40,130,100,10,10,null,null,{"$f":"SUM(V37:V177)","v":98352},{"$f":"SUM(W37:W177)","v":12508}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"2.5*3.6-1.31*2.05-2.29*1.2","v":3.5665000000000009},{"$f":"(2.5*3.6)","v":9},{"$f":"3*2.5-2.05*1.495","v":4.4352499999999999},{"$f":"(2.5*3.6-1.795*2.05)","v":5.3202500000000006},{"$f":"(2.5*3.6-1.795*2.05)","v":5.3202500000000006},null,null,"/100.000","/100.000"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"caves : "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"99720-98410+60+(12671-12644)*10","v":1640}]
[]
[]
[null,null,null,"Quantité","Prix Unitaire","Montant Total HT",null,"TVA","Montant total TTC","Montant TTC au logement",null,null,null,null,"Ligne retenue","option"]
[]
["1 - Traitement de la façade côté Parc (étages) :",null,null,null,null,null,null,null,{"$f":"I189+I215+I224","v":2181417.0224320004},{"$f":"SUM(J189:J377)","v":117029.24363420028}]
["1.1 - Travaux d'étanchéité des balcons :",null,null,null,null,null,null,null,{"$f":"SUM(I190:I214)","v":1143106.2893020001},{"$f":"SUM(J190:J214)","v":9779.5749201912186}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"Dépose des revetements de sol :",null,null,null,null,null,null,null,null,null,null,null,null,null,""]
["02.01.01","Option : Dépose des revetements de sol mis en œuvre par les propriétaires et évacuation.",null,1453.0945000000002,51.1,{"$f":"D192*E192*IF(O192=\"oui\",1,0)","v":0},null,7.0000000000000007E-2,{"$f":"F192*(1+H192)","v":0},{"$f":"+I192*L192/M192","v":0},"surface de loggia",{"$f":"OFFSET(table_simulateur!B$20,MATCH(K192,table_simulateur!D$21:D$31,0),0)","v":12.71},{"$f":"OFFSET(table_simulateur!C$20,MATCH(K192,table_simulateur!D$21:D$31,0),0)","v":1496.9000000000012},null,"non","option"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"- Démolition chape et enlévement de l'étanchéité",null,null,null,null,null,null,null,null,null,null,null,null,null,""]
["02.01.02 et 02.01.03","Démolition chape et enlévement de la chape, des relevés et des rives de dalles",null,1453.0945000000002,{"$f":"190619.34/D195","v":131.18165404934089},{"$f":"D195*E195*IF(O195=\"oui\",1,0)","v":190619.34},null,7.0000000000000007E-2,{"$f":"F195*(1+H195)","v":203962.69380000001},{"$f":"+I195*L195/M195","v":1731.8229929841659},"surface de loggia",{"$f":"OFFSET(table_simulateur!B$20,MATCH(K195,table_simulateur!D$21:D$31,0),0)","v":12.71},{"$f":"OFFSET(table_simulateur!C$20,MATCH(K195,table_simulateur!D$21:D$31,0),0)","v":1496.9000000000012},null,"oui","base"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"- Réalisation de l'étanchéité des loggias",null,null,null,null,null,null,null,null,null,null,null,null,null,""]
["02.01.07","Mise en œuvre d’un Système d’Etanchéité Liquide, sans forme de pente",null,1453.0945000000002,164.8,{"$f":"D198*E198*IF(O198=\"oui\",1,0)","v":239469.97360000006},null,7.0000000000000007E-2,{"$f":"F198*(1+H198)","v":256232.87175200006},{"$f":"+I198*L198/M198","v":2175.6428618931914},"surface de loggia",{"$f":"OFFSET(table_simulateur!B$20,MATCH(K198,table_simulateur!D$21:D$31,0),0)","v":12.71},{"$f":"OFFSET(table_simulateur!C$20,MATCH(K198,table_simulateur!D$21:D$31,0),0)","v":1496.9000000000012},null,"oui","base"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"- Mise en œuvre d'une tôle pliée d'habillage en rive de dalle",null,null,null,null,null,null,null,null,null,null,null,null,null,""]
["02.01.06","Mise en œuvre d'une tôle pliée d'habillage en rive de dalle",null,994.75,119.8,{"$f":"D201*E201*IF(O201=\"oui\",1,0)","v":119171.05},null,7.0000000000000007E-2,{"$f":"F201*(1+H201)","v":127513.02350000001},{"$f":"+I201*L201/M201","v":1082.6979281748941},"surface de loggia",{"$f":"OFFSET(table_simulateur!B$20,MATCH(K201,table_simulateur!D$21:D$31,0),0)","v":12.71},{"$f":"OFFSET(table_simulateur!C$20,MATCH(K201,table_simulateur!D$21:D$31,0),0)","v":1496.9000000000012},null,"oui","base"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"- Décapage et mise en peinture des sous-faces des dalles de loggias",null,null,null,null,null,null,null,null,null,null,null,null,null,""]
["01.01.A","Décapage des sous-faces des dalles béton des loggias et mise en peinture",null,1586,38.299999999999997,{"$f":"D204*E204*IF(O204=\"oui\",1,0)","v":60743.799999999996},null,7.0000000000000007E-2,64995.866000000002,{"$f":"+I204*L204/M204","v":551.87217373237979},"surface de loggia",{"$f":"OFFSET(table_simulateur!B$20,MATCH(K204,table_simulateur!D$21:D$31,0),0)","v":12.71},{"$f":"OFFSET(table_simulateur!C$20,MATCH(K204,table_simulateur!D$21:D$31,0),0)","v":1496.9000000000012},null,"oui","base"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"- Décapage et remise en peinture des garde-corps existants",null,null,null,null,null,null,null,null,null,null,null,null,null,""]
["02.01.04","Décapage des gardes-corps et remise en peinture noire",null,994.75,86.2,{"$f":"D207*E207*IF(O207=\"oui\",1,0)","v":85747.45},null,7.0000000000000007E-2,{"$f":"F207*(1+H207)","v":91749.771500000003},{"$f":"+I207*L207/M207","v":779.03640574854649},"surface de loggia",{"$f":"OFFSET(table_simulateur!B$20,MATCH(K207,table_simulateur!D$21:D$31,0),0)","v":12.71},{"$f":"OFFSET(table_simulateur!C$20,MATCH(K207,table_simulateur!D$21:D$31,0),0)","v":1496.9000000000012},null,"oui","base"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"- PV pour remplacement des garde-corps existant par des gardes-corps neufs",null,null,null,null,null,null,null,null,null,null,null,null,null,""]
["02.01.05","Plus-value pour garde-corps neufs en aluminium comprenant main courante et remplissage en verre feuilleté",null,994.75,163.5,{"$f":"D210*E210*IF(O210=\"oui\",1,0)","v":162641.625},null,7.0000000000000007E-2,{"$f":"F210*(1+H210)","v":174026.53875000001},{"$f":"+I210*L210/M210","v":1477.6386582353521},"surface de loggia",{"$f":"OFFSET(table_simulateur!B$20,MATCH(K210,table_simulateur!D$21:D$31,0),0)","v":12.71},{"$f":"OFFSET(table_simulateur!C$20,MATCH(K210,table_simulateur!D$21:D$31,0),0)","v":1496.9000000000012},null,"oui","base"]
[]
[null,"Fraction des honoraires correspondante (Architecte, BET, bureau de contrôle, SPS), Pilotage et Assurances",null,1,{"$f":"507327.28*0.4+13.57%*I192/(1.1069)","v":202930.91200000001},{"$f":"D212*E212*IF(O212=\"oui\",1,0)","v":202930.91200000001},null,{"$f":"I212/F212-1","v":0.10690639383713019},{"$f":"561563.81*0.4+13.57%*I192","v":224625.52400000003},{"$f":"IF(LEFT(A17,3)=\"apt\",(I212+(1997*8+803)*C21/C23)*L212/M212,0)","v":1980.8638994226885},"surface habitable",{"$f":"OFFSET(table_simulateur!B$20,MATCH(K212,table_simulateur!D$21:D$31,0),0)","v":98.72},{"$f":"OFFSET(table_simulateur!C$20,MATCH(K212,table_simulateur!D$21:D$31,0),0)","v":12098.359999999986},null,"oui","base"]
[]
[]
["1.2 - Travaux de ravalement des bétons :",null,null,null,null,null,null,null,{"$f":"SUM(I216:I223)","v":98415.195120000004},{"$f":"SUM(J216:J223)","v":803.04669907709899}]
[null,"- Décapage et mise en peintre des murs de refends",null,null,null,null,null,null,null,null,null,null,null,null,null,""]
["01.01.A","Décapage et mise en peintre des murs de refends",null,{"$f":"2*461.16","v":922.32},38.299999999999997,{"$f":"D217*E217*IF(O217=\"oui\",1,0)","v":35324.856},null,7.0000000000000007E-2,{"$f":"F217*(1+H217)","v":37797.59592},{"$f":"+I217*L217/M217","v":308.42020482300114},"surface habitable",{"$f":"OFFSET(table_simulateur!B$20,MATCH(K217,table_simulateur!D$21:D$31,0),0)","v":98.72},{"$f":"OFFSET(table_simulateur!C$20,MATCH(K217,table_simulateur!D$21:D$31,0),0)","v":12098.359999999986},null,"oui","base"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"- Mise en œuvre d'un habillage de la tranche des murs de refends",null,null,null,null,null,null,null,null,null,null,null,null,null,""]
["01.01.A","Mise en oeuvre d'un habillage en tôle laquée sur l'about des murs de refends après réfection et traitement des béton",null,{"$f":"2.74*5*29","v":397.3},117.2,{"$f":"D220*E220*IF(O220=\"oui\",1,0)","v":46563.560000000005},null,7.0000000000000007E-2,{"$f":"F220*(1+H220)","v":49823.009200000008},{"$f":"+I220*L220/M220","v":406.54497537054664},"surface habitable",{"$f":"OFFSET(table_simulateur!B$20,MATCH(K220,table_simulateur!D$21:D$31,0),0)","v":98.72},{"$f":"OFFSET(table_simulateur!C$20,MATCH(K220,table_simulateur!D$21:D$31,0),0)","v":12098.359999999986},null,"oui","base"]
[]
[null,"Fraction des honoraires correspondante (Architecte, BET, bureau de contrôle, SPS), Pilotage et Assurances ",null,1,{"$f":"2856.45+4236.35+2659.24","v":9752.0400000000009},{"$f":"D222*E222*IF(O222=\"oui\",1,0)","v":9752.0400000000009},null,{"$f":"I222/F222-1","v":0.10690583713766544},{"$f":"3416.31+4532.89+2845.39","v":10794.59},{"$f":"+I222*L222/M222","v":88.081518883551254},"surface habitable",{"$f":"OFFSET(table_simulateur!B$20,MATCH(K222,table_simulateur!D$21:D$31,0),0)","v":98.72},{"$f":"OFFSET(table_simulateur!C$20,MATCH(K222,table_simulateur!D$21:D$31,0),0)","v":12098.359999999986},null,"oui","base"]
[]
["1.3 - Travaux d'isolation des façades :",null,null,null,null,null,null,null,{"$f":"SUM(I225:I232)+SUM(I246:I252)","v":939895.53801000002},{"$f":"SUM(J225:J232)+SUM(J246:J252)","v":8163.8942245394537}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"- Mise en œuvre d'un complexe isolant + parement minéral sur les parties pleines actuellement en lambris logement/loggias profondes",null,null,null,null,null,null,null,null,null,null,null,null,null,""]
["01.01.A","Mise en oeuvre d'un complexe isolant + parement minéral sur les parties pleines actuellement en lambris logement / loggias profondes",null,384.3,126.4,{"$f":"D227*E227*IF(O227=\"oui\",1,0)","v":48575.520000000004},null,7.0000000000000007E-2,{"$f":"F227*(1+H227)","v":51975.806400000009},{"$f":"+I227*L227/M227","v":424.11133474355256},"surface habitable",{"$f":"OFFSET(table_simulateur!B$20,MATCH(K227,table_simulateur!D$21:D$31,0),0)","v":98.72},{"$f":"OFFSET(table_simulateur!C$20,MATCH(K227,table_simulateur!D$21:D$31,0),0)","v":12098.359999999986},null,"oui","base"]
[]
[null,"- Mise en œuvre d'un complexe isolant + parement minéral sur les murs de refend au droit des logements",null,null,null,null,null,null,null,null,null,null,null,null,null,""]
["01.01.A","Mise en oeuvre d'un complexe isolant + parement minéral sur les murs de refend en béton au droit des logements",null,384.30000000000007,117.3,{"$f":"D230*E230*IF(O230=\"oui\",1,0)","v":45078.390000000007},null,7.0000000000000007E-2,{"$f":"F230*(1+H230)","v":48233.877300000007},{"$f":"+I230*L230/M230","v":393.57800289097088},"surface habitable",{"$f":"OFFSET(table_simulateur!B$20,MATCH(K230,table_simulateur!D$21:D$31,0),0)","v":98.72},{"$f":"OFFSET(table_simulateur!C$20,MATCH(K230,table_simulateur!D$21:D$31,0),0)","v":12098.359999999986},null,"oui","base"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"Remplacement des chassis bois par chassis PVC double vitrage",null,null,null,{"$f":"(F233+F238+F243+F244+F245)*IF(O232=\"oui\",1,0)","v":688405.73300000001},null,7.0000000000000007E-2,{"$f":"F232*(1+H232)","v":736594.13430999999},{"$f":"+I232*L232/M232","v":6495.770041322553},"surface des logements",{"$f":"OFFSET(table_simulateur!B$20,MATCH(K232,table_simulateur!D$21:D$31,0),0)","v":98.72},{"$f":"OFFSET(table_simulateur!C$20,MATCH(K232,table_simulateur!D$21:D$31,0),0)","v":11194.449999999992},null,"oui","base"]
[null,"Dépose et évacuation des chassis existants :",null,null,null,{"$f":"IF(O233=\"oui\",SUM(F234:F237),0)","v":87836},null,7.0000000000000007E-2,{"$f":"F233*(1+H233)","v":93984.52},{"$f":"+I233*L233/M233","v":828.81712048381189},"surface des logements",{"$f":"OFFSET(table_simulateur!B$20,MATCH(K233,table_simulateur!D$21:D$31,0),0)","v":98.72},{"$f":"OFFSET(table_simulateur!C$20,MATCH(K233,table_simulateur!D$21:D$31,0),0)","v":11194.449999999992},null,"oui","base"]
["03.01.01","Menuiserie type C8 (3600x2500)",null,40,313.7,{"$f":"D234*E234","v":12548}]
["03.01.02","Menuiserie type C9 et C9' (3600x2500)",null,130,313.7,{"$f":"D235*E235","v":40781}]
["03.01.03","Menuiserie type C20 et C20' (3000x2500)",null,100,313.7,{"$f":"D236*E236","v":31370}]
["03.01.04","Menuiserie type C21 et C21' (3600x2500)",null,10,313.7,{"$f":"D237*E237","v":3137}]
[null,"Fourniture et mise en œuvre de nouveaux chassis PVC blanc :",null,null,null,{"$f":"IF(O238=\"oui\",SUM(F239:F242),0)","v":507787},null,7.0000000000000007E-2,{"$f":"F238*(1+H238)","v":543332.09000000008},{"$f":"+I238*L238/M238","v":4791.4586178686804},"surface des logements",{"$f":"OFFSET(table_simulateur!B$20,MATCH(K238,table_simulateur!D$21:D$31,0),0)","v":98.72},{"$f":"OFFSET(table_simulateur!C$20,MATCH(K238,table_simulateur!D$21:D$31,0),0)","v":11194.449999999992},null,"oui","base"]
["03.01.05","Menuiserie type C8 (3600x2500). \nLes surfaces actuellement en lambris bois seront isolées et traitées parement bois. (Option proposée après pour remplacement de cette partie par un vitrage)",null,40,1225.8,{"$f":"D239*E239","v":49032}]
["03.01.06","Menuiserie type C9 et C9' (3600x2500)",null,130,1436.5,186745]
["03.01.07","Menuiserie type C20 et C20' (3000x2500).\nLes surfaces actuellement en lambris bois seront isolées et traitées parement bois. (Option proposée après pour remplacement de cette partie par un vitrage)",null,100,1291.5999999999999,129159.99999999999]
["03.01.08","Menuiserie type C21 et C21' (3600x2500).\nLes surfaces actuellement en lambris bois seront isolées et traitées parement bois. (Option proposée après pour remplacement de cette partie par un vitrage)",null,100,1428.5,142850]
["03.01.09","Plus-value pour chassis acoustique 38dB",null,116.50999999999999,116.3,13550.112999999999,null,7.0000000000000007E-2,{"$f":"F243*(1+H243)","v":14498.62091},{"$f":"+I243*L243/M243","v":127.858345540442},"surface des logements",{"$f":"OFFSET(table_simulateur!B$20,MATCH(K243,table_simulateur!D$21:D$31,0),0)","v":98.72},{"$f":"OFFSET(table_simulateur!C$20,MATCH(K243,table_simulateur!D$21:D$31,0),0)","v":11194.449999999992},null,"oui","base"]
["03.01.10","Plus-value pour chassis acoustique 35dB",null,1165.0999999999999,34.200000000000003,39846.42,null,7.0000000000000007E-2,42635.669399999999,375.98928783173835,"surface des logements",{"$f":"OFFSET(table_simulateur!B$20,MATCH(K244,table_simulateur!D$21:D$31,0),0)","v":98.72},{"$f":"OFFSET(table_simulateur!C$20,MATCH(K244,table_simulateur!D$21:D$31,0),0)","v":11194.449999999992},null,"oui","base"]
["Option 03.01.F","Modification des ensembles menuisés : remplacement de l'ensemble du lambris bois par des chassis fixes vitrés.",null,803.8,49,{"$f":"D245*E245*IF(O245=\"oui\",1,0)","v":39386.199999999997},null,7.0000000000000007E-2,42143.233999999997,371.64666959788133,"surface des logements",{"$f":"OFFSET(table_simulateur!B$20,MATCH(K245,table_simulateur!D$21:D$31,0),0)","v":98.72},{"$f":"OFFSET(table_simulateur!C$20,MATCH(K245,table_simulateur!D$21:D$31,0),0)","v":11194.449999999992},null,"oui","base"]
[null,"Option : Mise en œuvre d'un intercalaire dans le vitrage de type WarmEdge",null,2330.1999999999998,7.5,0,null,7.0000000000000007E-2,0,0,"surface des logements",{"$f":"OFFSET(table_simulateur!B$20,MATCH(K246,table_simulateur!D$21:D$31,0),0)","v":98.72},{"$f":"OFFSET(table_simulateur!C$20,MATCH(K246,table_simulateur!D$21:D$31,0),0)","v":11194.449999999992},null,"non","option"]
[null,"Option : Vitrage type Planistar au lieu de Planitherm",null,2330.1999999999998,34.9,0,null,7.0000000000000007E-2,0,0,"surface des logements",{"$f":"OFFSET(table_simulateur!B$20,MATCH(K247,table_simulateur!D$21:D$31,0),0)","v":98.72},{"$f":"OFFSET(table_simulateur!C$20,MATCH(K247,table_simulateur!D$21:D$31,0),0)","v":11194.449999999992},null,"non","option"]
[null,"Option : Chassis PVC avec triple vitrage",null,2330.1999999999998,75.2,0,null,7.0000000000000007E-2,0,0,"surface des logements",{"$f":"OFFSET(table_simulateur!B$20,MATCH(K248,table_simulateur!D$21:D$31,0),0)","v":98.72},{"$f":"OFFSET(table_simulateur!C$20,MATCH(K248,table_simulateur!D$21:D$31,0),0)","v":11194.449999999992},null,"non","option"]
[null,"Option : Plus-value pour volets roulants manuels par tringle. Tablier PVC blanc. La hauteur de vitrage des chassis sera réduite de 25cm environ (caisson du volet roulant)",null,2330.1999999999998,95.8,0,null,7.0000000000000007E-2,0,0,"surface des logements",{"$f":"OFFSET(table_simulateur!B$20,MATCH(K249,table_simulateur!D$21:D$31,0),0)","v":98.72},{"$f":"OFFSET(table_simulateur!C$20,MATCH(K249,table_simulateur!D$21:D$31,0),0)","v":11194.449999999992},null,"non","option"]
[null,"Option* : Plus-value pour chassis aluminium laqués blancs coulissants, au lieu de PVC blanc.",null,2330.1999999999998,218.9,0,null,7.0000000000000007E-2,0,0,"surface des logements",{"$f":"OFFSET(table_simulateur!B$20,MATCH(K250,table_simulateur!D$21:D$31,0),0)","v":98.72},{"$f":"OFFSET(table_simulateur!C$20,MATCH(K250,table_simulateur!D$21:D$31,0),0)","v":11194.449999999992},null,"non","option"]
[]
[null,"Fraction des honoraires correspondante (Architecte, BET, bureau de contrôle, SPS), Pilotage et Assurances  ",null,1,{"$f":"27279.98+40458.41+25396.6+SUM(I246:I250)*13.57%/1.1069","v":93134.989999999991},{"$f":"D252*E252*IF(O252=\"oui\",1,0)","v":93134.989999999991},null,{"$f":"I252/F252-1","v":0.10690643763423413},{"$f":"32626.86+43290.5+27174.36+13.57%*SUM(I246:I250)","v":103091.72},{"$f":"IF(LEFT(A17,3)=\"Apt\",+(I252+(803+1*(369-41)))*L252/M252,11.5%*SUM(J225:J250))","v":850.43484558237753},"surface habitable",{"$f":"OFFSET(table_simulateur!B$20,MATCH(K252,table_simulateur!D$21:D$31,0),0)","v":98.72},{"$f":"OFFSET(table_simulateur!C$20,MATCH(K252,table_simulateur!D$21:D$31,0),0)","v":12098.359999999986},null,"oui","base"]
[]
["2 - Traitement des façades av. Mormal et pignons (étages) :",null,null,null,null,null,null,null,{"$f":"I255+I271+SUM(I283:I288)","v":886719.01209720003},{"$f":"J255+SUM(J272:J289)","v":7566.9743625898191}]
[null,"Travaux de ravalement et d'isolation des parties pleines",null,null,null,{"$f":"SUM(F256:F269)*IF(O255=\"oui\",1,0)","v":267540.19231999997},null,7.0000000000000007E-2,{"$f":"F255*(1+H255)","v":286268.00578239997},{"$f":"+I255*L255/M255","v":2335.8849902663301},"surface habitable",{"$f":"OFFSET(table_simulateur!B$20,MATCH(K255,table_simulateur!D$21:D$31,0),0)","v":98.72},{"$f":"OFFSET(table_simulateur!C$20,MATCH(K255,table_simulateur!D$21:D$31,0),0)","v":12098.359999999986},null,"oui","base"]
["01.01","Pignons",null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"- Mise en œuvre d'un complexe isolant + parement minéral sur support béton",null,null,null,null,null,null,null,null,null,null,null,null,null,""]
["01.01.A","Dépose du parement de façade existant",null,428.58279999999996,11.3,{"$f":"D258*E258*IF(O258=\"oui\",1,0)","v":4842.9856399999999},null,7.0000000000000007E-2,{"$f":"F258*(1+H258)","v":5181.9946348000003},{"$f":"+I258*L258/M258","v":42.283955044109831},"surface habitable",{"$f":"OFFSET(table_simulateur!B$20,MATCH(K258,table_simulateur!D$21:D$31,0),0)","v":98.72},{"$f":"OFFSET(table_simulateur!C$20,MATCH(K258,table_simulateur!D$21:D$31,0),0)","v":12098.359999999986},null,"oui","base"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
["01.01.A","Mise en œuvre de 120mm d'isolant et d'un revêtement de façade",null,434.58279999999996,88.1,{"$f":"D260*E260*IF(O260=\"oui\",1,0)","v":38286.744679999996},null,7.0000000000000007E-2,{"$f":"F260*(1+H260)","v":40966.8168076},{"$f":"+I260*L260/M260","v":334.28036157349231},"surface habitable",{"$f":"OFFSET(table_simulateur!B$20,MATCH(K260,table_simulateur!D$21:D$31,0),0)","v":98.72},{"$f":"OFFSET(table_simulateur!C$20,MATCH(K260,table_simulateur!D$21:D$31,0),0)","v":12098.359999999986},null,"oui","base"]
["04.03","Corniches décoratives ",null,90,41,{"$f":"D261*E261*IF(O261=\"oui\",1,0)","v":3690},null,7.0000000000000007E-2,{"$f":"F261*(1+H261)","v":3948.3},{"$f":"+I261*L261/M261","v":32.21727374619374},"surface habitable",{"$f":"OFFSET(table_simulateur!B$20,MATCH(K261,table_simulateur!D$21:D$31,0),0)","v":98.72},{"$f":"OFFSET(table_simulateur!C$20,MATCH(K261,table_simulateur!D$21:D$31,0),0)","v":12098.359999999986},null,"oui","base"]
[null,"Façade côté Avenue de Mormal",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,null,null,""]
[null,"- Mise en œuvre d'un complexe isolant + parement minéral sur support béton",null,null,null,null,null,null,null,null,null,null,null,null,null,""]
["01.01.A","Dépose du parement de façade existant ",null,1396.98,19.399999999999999,{"$f":"D265*E265*IF(O265=\"oui\",1,0)","v":27101.411999999997},null,7.0000000000000007E-2,{"$f":"F265*(1+H265)","v":28998.510839999999},{"$f":"+I265*L265/M265","v":236.62157433939834},"surface habitable",{"$f":"OFFSET(table_simulateur!B$20,MATCH(K265,table_simulateur!D$21:D$31,0),0)","v":98.72},{"$f":"OFFSET(table_simulateur!C$20,MATCH(K265,table_simulateur!D$21:D$31,0),0)","v":12098.359999999986},null,"oui","base"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
["01.01.A","Mise en œuvre de 120mm d'isolant et d'un revêtement de façade ",null,1436.78,109.5,{"$f":"D267*E267*IF(O267=\"oui\",1,0)","v":157327.41},null,7.0000000000000007E-2,{"$f":"F267*(1+H267)","v":168340.32870000001},{"$f":"+I267*L267/M267","v":1373.6206600947585},"surface habitable",{"$f":"OFFSET(table_simulateur!B$20,MATCH(K267,table_simulateur!D$21:D$31,0),0)","v":98.72},{"$f":"OFFSET(table_simulateur!C$20,MATCH(K267,table_simulateur!D$21:D$31,0),0)","v":12098.359999999986},null,"oui","base"]
["04.10","Frontons décoratifs (hauteur 1m)",null,4,2984.41,{"$f":"E268*D268","v":11937.64},null,7.0000000000000007E-2,{"$f":"(1+H268)*F268","v":12773.274799999999},{"$f":"+I268*L268/M268","v":104.22715874349923},"surface habitable",{"$f":"OFFSET(table_simulateur!B$20,MATCH(K268,table_simulateur!D$21:D$31,0),0)","v":98.72},{"$f":"OFFSET(table_simulateur!C$20,MATCH(K268,table_simulateur!D$21:D$31,0),0)","v":12098.359999999986},null,"oui","base"]
["04.11","Corniches décoratives",null,{"$f":"198*3","v":594},41,{"$f":"E269*D269","v":24354},null,7.0000000000000007E-2,{"$f":"(1+H269)*F269","v":26058.780000000002},{"$f":"+I269*L269/M269","v":212.63400672487867},"surface habitable",{"$f":"OFFSET(table_simulateur!B$20,MATCH(K269,table_simulateur!D$21:D$31,0),0)","v":98.72},{"$f":"OFFSET(table_simulateur!C$20,MATCH(K269,table_simulateur!D$21:D$31,0),0)","v":12098.359999999986},null,"oui","base"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"Remplacement des chassis bois par chassis PVC double vitrage ",null,null,null,{"$f":"(F276+F272+F280+F281)*IF(O271=\"oui\",1,0)","v":470272.80963999999},null,7.0000000000000007E-2,{"$f":"F271*(1+H271)","v":503191.90631480003},{"$f":"+I271*L271/M271","v":4437.4761592929617},"surface des logements",{"$f":"OFFSET(table_simulateur!B$20,MATCH(K271,table_simulateur!D$21:D$31,0),0)","v":98.72},{"$f":"OFFSET(table_simulateur!C$20,MATCH(K271,table_simulateur!D$21:D$31,0),0)","v":11194.449999999992},null,"oui","base"]
[null,"Dépose et évacuation des chassis existants :",null,null,null,{"$f":"IF(O272=\"oui\",SUM(F273:F275),0)","v":88207},null,7.0000000000000007E-2,{"$f":"F272*(1+H272)","v":94381.49},{"$f":"+I272*L272/M272","v":832.31786222637174},"surface des logements",{"$f":"OFFSET(table_simulateur!B$20,MATCH(K272,table_simulateur!D$21:D$31,0),0)","v":98.72},{"$f":"OFFSET(table_simulateur!C$20,MATCH(K272,table_simulateur!D$21:D$31,0),0)","v":11194.449999999992},null,"oui","base"]
["03.02.01","Menuiserie type C1 et C1' (3600x1440)",null,180,305.5,{"$f":"D273*E273","v":54990}]
["03.02.02","Menuiserie type C2 et C2' (3000x1440)",null,100,305.5,{"$f":"D274*E274","v":30550}]
["01.01.A","Menuiserie type P1 (1400x610)",null,10,266.7,{"$f":"D275*E275","v":2667}]
[null,"Fourniture et mise en œuvre de nouveaux chassis PVC blanc :",null,null,null,{"$f":"IF(O276=\"oui\",SUM(F277:F279),0)","v":346831},null,7.0000000000000007E-2,{"$f":"F276*(1+H276)","v":371109.17000000004},{"$f":"+I276*L276/M276","v":3272.6839873687431},"surface des logements",{"$f":"OFFSET(table_simulateur!B$20,MATCH(K276,table_simulateur!D$21:D$31,0),0)","v":98.72},{"$f":"OFFSET(table_simulateur!C$20,MATCH(K276,table_simulateur!D$21:D$31,0),0)","v":11194.449999999992},null,"oui","base"]
["03.02.03","Menuiserie type C1 et C1' (3600x1440+meneau 160)",null,180,1275,{"$f":"D277*E277","v":229500}]
["03.02.04","Menuiserie type C2 et C2' (3000x1440+meneau 160)",null,100,1130.3,{"$f":"D278*E278","v":113030}]
["01.01.E","Menuiserie type P1 (1400x610)",null,10,430.1,{"$f":"D279*E279","v":4301}]
["01.01.I","Plus-value pour chassis acoustique 38dB",null,{"$f":"4.27+150.1632","v":154.4332},116.3,{"$f":"D280*E280","v":17960.581159999998},null,7.0000000000000007E-2,{"$f":"F280*(1+H280)","v":19217.821841199999},{"$f":"+I280*L280/M280","v":169.47535360497972},"surface des logements",{"$f":"OFFSET(table_simulateur!B$20,MATCH(K280,table_simulateur!D$21:D$31,0),0)","v":98.72},{"$f":"OFFSET(table_simulateur!C$20,MATCH(K280,table_simulateur!D$21:D$31,0),0)","v":11194.449999999992},null,"oui","base"]
["03.02.06","Plus-value pour chassis acoustique 35dB",null,505.09439999999995,34.200000000000003,{"$f":"D281*E281","v":17274.228479999998},null,7.0000000000000007E-2,{"$f":"F281*(1+H281)","v":18483.4244736},{"$f":"+I281*L281/M281","v":162.99895609286685},"surface des logements",{"$f":"OFFSET(table_simulateur!B$20,MATCH(K281,table_simulateur!D$21:D$31,0),0)","v":98.72},{"$f":"OFFSET(table_simulateur!C$20,MATCH(K281,table_simulateur!D$21:D$31,0),0)","v":11194.449999999992},null,"oui","base"]
[]
["Option 01.01.B","Option : Mise en œuvre d'un intercalaire dans le vitrage de type WarmEdge ",null,{"$f":"8.54+1365.12","v":1373.6599999999999},7.5,{"$f":"D283*E283*IF(O283=\"oui\",1,0)","v":0},null,7.0000000000000007E-2,{"$f":"F283*(1+H283)","v":0},{"$f":"+I283*L283/M283","v":0},"surface des logements",{"$f":"OFFSET(table_simulateur!B$20,MATCH(K283,table_simulateur!D$21:D$31,0),0)","v":98.72},{"$f":"OFFSET(table_simulateur!C$20,MATCH(K283,table_simulateur!D$21:D$31,0),0)","v":11194.449999999992},null,"non","option"]
["Option 01.01.C","Option : Vitrage type Planistar au lieu de Planitherm ",null,{"$f":"8.54+1365.12","v":1373.6599999999999},34.9,0,null,7.0000000000000007E-2,{"$f":"F284*(1+H284)","v":0},0,"surface des logements",{"$f":"OFFSET(table_simulateur!B$20,MATCH(K284,table_simulateur!D$21:D$31,0),0)","v":98.72},{"$f":"OFFSET(table_simulateur!C$20,MATCH(K284,table_simulateur!D$21:D$31,0),0)","v":11194.449999999992},null,"non","option"]
["Option 01.01.D","Option : Chassis PVC avec triple vitrage ",null,{"$f":"8.54+1365.12","v":1373.6599999999999},75.2,0,null,7.0000000000000007E-2,{"$f":"F285*(1+H285)","v":0},0,"surface des logements",{"$f":"OFFSET(table_simulateur!B$20,MATCH(K285,table_simulateur!D$21:D$31,0),0)","v":98.72},{"$f":"OFFSET(table_simulateur!C$20,MATCH(K285,table_simulateur!D$21:D$31,0),0)","v":11194.449999999992},null,"non","option"]
["Option 03.01.E","Option : Plus-value pour volets roulants manuels par tringle. Tablier PVC blanc. La hauteur de vitrage des chassis sera réduite de 25cm environ (caisson du volet roulant) ",null,1365.12,95.8,0,null,7.0000000000000007E-2,{"$f":"F286*(1+H286)","v":0},0,"surface des logements",{"$f":"OFFSET(table_simulateur!B$20,MATCH(K286,table_simulateur!D$21:D$31,0),0)","v":98.72},{"$f":"OFFSET(table_simulateur!C$20,MATCH(K286,table_simulateur!D$21:D$31,0),0)","v":11194.449999999992},null,"non","option"]
["Option 01.01.E","Option* : Plus-value pour chassis aluminium laqués blancs coulissants, au lieu de PVC blanc. ",null,{"$f":"8.54+1365.12","v":1373.6599999999999},218.9,0,null,7.0000000000000007E-2,{"$f":"F287*(1+H287)","v":0},0,"surface des logements",{"$f":"OFFSET(table_simulateur!B$20,MATCH(K287,table_simulateur!D$21:D$31,0),0)","v":98.72},{"$f":"OFFSET(table_simulateur!C$20,MATCH(K287,table_simulateur!D$21:D$31,0),0)","v":11194.449999999992},null,"non","option"]
[null,"Fraction des honoraires correspondante (Architecte, BET, bureau de contrôle, SPS), Pilotage et Assurances   ",null,1,{"$f":"16404.16+24328.69+9332.4+13840.7+15271.64+8688.1+13.57%*SUM(I283:I287)/(1+10.69%)","v":87865.69},87865.69,null,{"$f":"I288/F288-1","v":0.10690646144132021},{"$f":"9296.27+16340.65+26031.7+14809.55+11161.55+19619.38+13.57%*SUM(I283:I287)","v":97259.1},793.61321303052739,"surface habitable",{"$f":"OFFSET(table_simulateur!B$20,MATCH(K288,table_simulateur!D$21:D$31,0),0)","v":98.72},{"$f":"OFFSET(table_simulateur!C$20,MATCH(K288,table_simulateur!D$21:D$31,0),0)","v":12098.359999999986},null,"oui","base"]
[]
["3 - Traitement du Rez-de-Chaussée :",null,null,null,null,null,null,null,{"$f":"I293+SUM(I307:I320)+I328","v":577761.03700000001},{"$f":"J293+SUM(J307:J320)+J328","v":3265.4098624408634}]
[]
["01.01","Travaux intérieurs",null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"Isolation des planchers haut et bas du Rez-de-Chaussée (intérieur)",null,null,null,{"$f":"F294+F299+F305","v":125088.3},null,7.0000000000000007E-2,{"$f":"F293*(1+H293)","v":133844.481},{"$f":"+I293*L293/M293","v":1092.1420063810315},"surface habitable",{"$f":"OFFSET(table_simulateur!B$20,MATCH(K293,table_simulateur!D$21:D$31,0),0)","v":98.72},{"$f":"OFFSET(table_simulateur!C$20,MATCH(K293,table_simulateur!D$21:D$31,0),0)","v":12098.359999999986},null,"oui","base"]
[null,"Parties communes : Mise en œuvre d'un isolant dans le plenum du faux plafond métallique intérieur existant",null,null,null,{"$f":"IF(O294=\"oui\",SUM(F295:F297),0)","v":25719.3},null,7.0000000000000007E-2,{"$f":"F294*(1+H294)","v":27519.651000000002},{"$f":"+I294*L294/M294","v":224.55439801097037},"surface habitable",{"$f":"OFFSET(table_simulateur!B$20,MATCH(K294,table_simulateur!D$21:D$31,0),0)","v":98.72},{"$f":"OFFSET(table_simulateur!C$20,MATCH(K294,table_simulateur!D$21:D$31,0),0)","v":12098.359999999986},null,"oui","base"]
["01.01.A","Dépose du faux plafond métallique existant",null,697,12.3,{"$f":"E295*D295","v":8573.1},null,null,null,null,null,null,null,null,null,""]
["01.01.A","Nettoyage du faux plafond métallique",null,697,4.0999999999999996,{"$f":"E296*D296","v":2857.7},null,null,null,null,null,null,null,null,null,""]
["01.01.A","Mise en œuvre d'un isolant type laine minerale et repose du faux plafond",null,697,20.5,{"$f":"E297*D297","v":14288.5},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,"Bureaux : Mise en œuvre d'un isolant dans le plenum du faux plafond métallique intérieur existant",null,null,null,{"$f":"IF(O299=\"oui\",SUM(F300:F302),0)","v":34833.599999999999},null,7.0000000000000007E-2,{"$f":"F299*(1+H299)","v":37271.951999999997},{"$f":"+I299*L299/M299","v":304.13106416406885},"surface habitable",{"$f":"OFFSET(table_simulateur!B$20,MATCH(K299,table_simulateur!D$21:D$31,0),0)","v":98.72},{"$f":"OFFSET(table_simulateur!C$20,MATCH(K299,table_simulateur!D$21:D$31,0),0)","v":12098.359999999986},null,"oui","base"]
["01.01.A","Dépose du faux plafond métallique existant",null,944,12.3,{"$f":"E300*D300","v":11611.2},null,null,null,null,null,null,null,null,null,""]
["01.01.A","Nettoyage du faux plafond métallique",null,944,4.0999999999999996,{"$f":"E301*D301","v":3870.3999999999996},null,null,null,null,null,null,null,null,null,""]
["01.01.A","Mise en œuvre d'un isolant type laine minerale et repose du faux plafond",null,944,20.5,{"$f":"E302*D302","v":19352},null,null,null,null,null,null,null,null,null,""]
[]
[null,"Flocage sous dalle béton en laine de roche avec durcisseur dans l'ensemble des caves, garages et circulations sous l'emprise de l'élévation du bâtiment",null,null,null,null,null,null,null,null,null,null,null,null,null,""]
["01.01.A","Flocage sous dalle haute béton des sous-sols en laine de roche avec durcisseur",null,1887,34.200000000000003,{"$f":"D305*E305*IF(O305=\"oui\",1,0)","v":64535.400000000009},null,7.0000000000000007E-2,{"$f":"F305*(1+H305)","v":69052.878000000012},{"$f":"+I305*L305/M305","v":563.45654420599226},"surface habitable",{"$f":"OFFSET(table_simulateur!B$20,MATCH(K305,table_simulateur!D$21:D$31,0),0)","v":98.72},{"$f":"OFFSET(table_simulateur!C$20,MATCH(K305,table_simulateur!D$21:D$31,0),0)","v":12098.359999999986},null,"oui","base"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"Isolation du plancher haut du Rez-de-Chaussée en coursives extérieures, compris remplacement du faux-plafond métallique",null,null,null,{"$f":"IF(O307=\"oui\",SUM(F308:F309),0)","v":122111},null,7.0000000000000007E-2,{"$f":"F307*(1+H307)","v":130658.77},{"$f":"+I307*L307/M307","v":1066.1472938811553},"surface habitable",{"$f":"OFFSET(table_simulateur!B$20,MATCH(K307,table_simulateur!D$21:D$31,0),0)","v":98.72},{"$f":"OFFSET(table_simulateur!C$20,MATCH(K307,table_simulateur!D$21:D$31,0),0)","v":12098.359999999986},null,"oui","base"]
["01.01.A","Dépose du faux plafond métallique existant",null,935,4.0999999999999996,{"$f":"E308*D308","v":3833.4999999999995},null,null,null,null,null,null,null,null,null,""]
["01.01.A","Mise en œuvre d'un isolant type laine minerale et mise en œuvre d'un faux plafond métallique neuf sur ossature métallique galva",null,935,126.5,{"$f":"E309*D309","v":118277.5},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,"Création de SAS au droit des cages d'escalier",null,null,null,{"$f":"IF(O311=\"oui\",SUM(F312),0)","v":21236.399999999998},null,7.0000000000000007E-2,{"$f":"F311*(1+H311)","v":22722.948},{"$f":"+I311*L311/M311","v":185.41433934516766},"surface habitable",{"$f":"OFFSET(table_simulateur!B$20,MATCH(K311,table_simulateur!D$21:D$31,0),0)","v":98.72},{"$f":"OFFSET(table_simulateur!C$20,MATCH(K311,table_simulateur!D$21:D$31,0),0)","v":12098.359999999986},null,"oui","base"]
["01.01.A","Mise en oeuvre d'un bloc-porte vitré formant SAS.\n2 ventaux tiercé (0,90+0,35m). Finition aluminium anodisé, double vitrage feuilleté. Poignées de tirage intérieure et extérieure, sans serrure.",null,9,2359.6,{"$f":"E312*D312","v":21236.399999999998},null,null,null,null,null,null,null,null,null,""]
[]
[null,"Parties communes : Mise en œuvre d'un survitrage feuilleté sur les chassis fixes des halls d'entrée",null,null,null,{"$f":"IF(O314=\"oui\",SUM(F315:F316),0)","v":64431.7},null,7.0000000000000007E-2,{"$f":"F314*(1+H314)","v":68941.918999999994},{"$f":"+I314*L314/M314","v":562.55114277307064},"surface habitable",{"$f":"OFFSET(table_simulateur!B$20,MATCH(K314,table_simulateur!D$21:D$31,0),0)","v":98.72},{"$f":"OFFSET(table_simulateur!C$20,MATCH(K314,table_simulateur!D$21:D$31,0),0)","v":12098.359999999986},null,"oui","base"]
["01.01.A","Nettoyage des chassis existants",null,251,2.1,{"$f":"E315*D315","v":527.1},null,null,null,null,null,null,null,null,null,""]
["01.01.A","Mise en œuvre d'un survitrage STADIP aluminium sur les chassis fixes existants",null,251,254.6,{"$f":"E316*D316","v":63904.6},null,null,null,null,null,null,null,null,null,""]
["Option 01.01.A","Option parties communes : Plus-value pour remplacement de l'ensemble des chassis extérieurs fixes des halls par des chassis neufs en aluminium anodisé (au lieu du survitrage prévu en base).",null,251,264.39999999999998,{"$f":"D317*E317*IF(O317=\"oui\",1,0)","v":0},null,7.0000000000000007E-2,{"$f":"F317*(1+H317)","v":0},{"$f":"+I317*L317/M317","v":0},"surface habitable",{"$f":"OFFSET(table_simulateur!B$20,MATCH(K317,table_simulateur!D$21:D$31,0),0)","v":98.72},{"$f":"OFFSET(table_simulateur!C$20,MATCH(K317,table_simulateur!D$21:D$31,0),0)","v":12098.359999999986},null,"non","option"]
["01.01.B","Option : Remplacement des portes des halls donnant sur les coursives (pas d'intervention prévue en base)",null,82,742.1,{"$f":"D318*E318*IF(O318=\"oui\",1,0)","v":0},null,7.0000000000000007E-2,{"$f":"F318*(1+H318)","v":0},{"$f":"+I318*L318/M318","v":0},"surface habitable",{"$f":"OFFSET(table_simulateur!B$20,MATCH(K318,table_simulateur!D$21:D$31,0),0)","v":98.72},{"$f":"OFFSET(table_simulateur!C$20,MATCH(K318,table_simulateur!D$21:D$31,0),0)","v":12098.359999999986},null,"non","option"]
[]
["Bureaux :"," - Mise en œuvre d'un survitrage feuilleté sur les chassis fixes donnant sur les coursives extérieures,",null,null,null,{"$f":"F321+F326+F325","v":147870.70000000001},null,7.0000000000000007E-2,{"$f":"F320*(1+H320)","v":158221.64900000003},{"$f":"+I320*L320/M320","v":0},"surface des bureaux",{"$f":"OFFSET(table_simulateur!B$20,MATCH(K320,table_simulateur!D$21:D$31,0),0)","v":0},{"$f":"OFFSET(table_simulateur!C$20,MATCH(K320,table_simulateur!D$21:D$31,0),0)","v":903.91000000000008},null,"oui","base"]
[null,"Bureaux : Mise en œuvre d'un survitrage feuilleté sur les chassis fixes des bureaux donnant sur les coursives extérieures",null,null,null,{"$f":"IF(O321=\"oui\",SUM(F322:F323),0)","v":101150.3},null,7.0000000000000007E-2,{"$f":"F321*(1+H321)","v":108230.82100000001},{"$f":"+I321*L321/M321","v":0},"surface des bureaux",{"$f":"OFFSET(table_simulateur!B$20,MATCH(K321,table_simulateur!D$21:D$31,0),0)","v":0},{"$f":"OFFSET(table_simulateur!C$20,MATCH(K321,table_simulateur!D$21:D$31,0),0)","v":903.91000000000008},null,"oui","base"]
["01.01.A","Nettoyage des chassis existants",null,383,2.1,{"$f":"E322*D322","v":804.30000000000007},null,null,null,null,null,null,null,null,null,""]
["01.01.A","Mise en œuvre d'un survitrage STADIP aluminium sur les chassis fixes existants",null,383,262,{"$f":"E323*D323","v":100346},null,null,null,null,null,null,null,null,null,""]
["Option 01.01.A","Option bureaux : Plus-value pour remplacement de l'ensemble des chassis extérieurs fixes des bureaux par des chassis neufs en aluminium anodisé (au lieu du survitrage prévu en base).",null,383,243.2,{"$f":"D324*E324*IF(O324=\"oui\",1,0)","v":0},null,7.0000000000000007E-2,{"$f":"F324*(1+H324)","v":0},{"$f":"+I324*L324/M324","v":0},"surface des bureaux",{"$f":"OFFSET(table_simulateur!B$20,MATCH(K324,table_simulateur!D$21:D$31,0),0)","v":0},{"$f":"OFFSET(table_simulateur!C$20,MATCH(K324,table_simulateur!D$21:D$31,0),0)","v":903.91000000000008},null,"non","option"]
["01.01.B","Remplacement des portes des bureaux donnant sur la coursive (pas d'intervention prévue en base)",null,42,866.6,{"$f":"D325*E325*IF(O325=\"oui\",1,0)","v":36397.200000000004},null,7.0000000000000007E-2,{"$f":"F325*(1+H325)","v":38945.004000000008},{"$f":"+I325*L325/M325","v":0},"surface des bureaux",{"$f":"OFFSET(table_simulateur!B$20,MATCH(K325,table_simulateur!D$21:D$31,0),0)","v":0},{"$f":"OFFSET(table_simulateur!C$20,MATCH(K325,table_simulateur!D$21:D$31,0),0)","v":903.91000000000008},null,"oui","base"]
["01.01.C","Remplacement des portes des bureaux intérieures donnant sur les halls (pas d'intervention prévue en base)",null,8,1290.4000000000001,{"$f":"D326*E326*IF(O326=\"oui\",1,0)","v":10323.200000000001},null,7.0000000000000007E-2,{"$f":"F326*(1+H326)","v":11045.824000000001},{"$f":"+I326*L326/M326","v":0},"surface des bureaux",{"$f":"OFFSET(table_simulateur!B$20,MATCH(K326,table_simulateur!D$21:D$31,0),0)","v":0},{"$f":"OFFSET(table_simulateur!C$20,MATCH(K326,table_simulateur!D$21:D$31,0),0)","v":903.91000000000008},null,"oui","base"]
[]
[null,"Fraction des honoraires correspondante (Architecte, BET, bureau de contrôle, SPS), Pilotage et Assurances    ",null,1,{"$f":"57250.8+(I324+I317+I318)*13.57%/1.1069","v":57250.8},{"$f":"D328*E328*IF(O328=\"oui\",1,0)","v":57250.8},null,{"$f":"I328/F328-1","v":0.10690627903889549},{"$f":"63371.27+(I324+I317+I318)*13.57%","v":63371.27},{"$f":"IF(LEFT(A17,3)=\"Apt\",(I328-19356)*L328/M328,IF(LEFT(A17,3)=\"Con\",1357.65,(I328)*L328/M328+1997+(917-102)))","v":359.15508006043831},"surface habitable",{"$f":"OFFSET(table_simulateur!B$20,MATCH(K328,table_simulateur!D$21:D$31,0),0)","v":98.72},{"$f":"OFFSET(table_simulateur!C$20,MATCH(K328,table_simulateur!D$21:D$31,0),0)","v":12098.359999999986},null,"oui","base"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
["4 - Isolation de la toiture terrasse",null,null,null,null,null,null,null,{"$f":"SUM(I332:I356)","v":384327.30780000001},{"$f":"SUM(J332:J356)","v":3136.0276786288432},null,null,null,null,null,""]
["01.01","Isolation de la toiture et remplacement de l'isolation",null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"Prestation de base :\n- Dépose de la sécurité collective existante\n- Dépose de l'étanchéité existante et de ses relevés\n- Dépose de la couvertine d'acrotère existante\n- Dépose de l'isolation existante\n- Réhausse des acrotères de 20cm\n- Mise en œuvre d'une étanchéité bicouche élastomère inaccessible autoprotégée sur isolant polyuréthane 225mm Th36\n- Mise en oeuvre d'une couvertine d'acrotère\n- Repose de la sécurité collective existante",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,null,null,""]
[null,"- Dépose et repose de la sécurité collective existante :",null,null,null,null,null,null,null,null,null,null,null,null,null,""]
["01.01.A","Dépose et repose de la sécurité collective existante",null,426,25.6,{"$f":"D336*E336*IF(O336=\"oui\",1,0)","v":10905.6},null,7.0000000000000007E-2,{"$f":"F336*(1+H336)","v":11668.992},{"$f":"+I336*L336/M336","v":95.216450018019088},"surface habitable",{"$f":"OFFSET(table_simulateur!B$20,MATCH(K336,table_simulateur!D$21:D$31,0),0)","v":98.72},{"$f":"OFFSET(table_simulateur!C$20,MATCH(K336,table_simulateur!D$21:D$31,0),0)","v":12098.359999999986},null,"oui","base"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"- Dépose de l'étanchéité et de l'isolant existants :",null,null,null,null,null,null,null,null,null,null,null,null,null,""]
["01.01.A","Dépose de l'étanchéité et de l'isolant existants",null,2937.8,19.8,{"$f":"D339*E339*IF(O339=\"oui\",1,0)","v":58168.44},null,7.0000000000000007E-2,{"$f":"F339*(1+H339)","v":62240.230800000005},{"$f":"+I339*L339/M339","v":507.86681703768176},"surface habitable",{"$f":"OFFSET(table_simulateur!B$20,MATCH(K339,table_simulateur!D$21:D$31,0),0)","v":98.72},{"$f":"OFFSET(table_simulateur!C$20,MATCH(K339,table_simulateur!D$21:D$31,0),0)","v":12098.359999999986},null,"oui","base"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"- Remplacement de la couvertine d'acrotère",null,null,null,null,null,null,null,null,null,null,null,null,null,""]
["01.01.A","Dépose de la couvertine d'acrotère",null,550,6.3,{"$f":"D342*E342*IF(O342=\"oui\",1,0)","v":3465},null,7.0000000000000007E-2,{"$f":"F342*(1+H342)","v":3707.55},{"$f":"+I342*L342/M342","v":30.252805834840462},"surface habitable",{"$f":"OFFSET(table_simulateur!B$20,MATCH(K342,table_simulateur!D$21:D$31,0),0)","v":98.72},{"$f":"OFFSET(table_simulateur!C$20,MATCH(K342,table_simulateur!D$21:D$31,0),0)","v":12098.359999999986},null,"oui","base"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
["01.01.A","Mise en œuvre d'une nouvelle couvertine d'acrotère aluminium laquée",null,550,25.4,{"$f":"D344*E344*IF(O344=\"oui\",1,0)","v":13970},null,7.0000000000000007E-2,{"$f":"F344*(1+H344)","v":14947.900000000001},{"$f":"+I344*L344/M344","v":121.97162987380122},"surface habitable",{"$f":"OFFSET(table_simulateur!B$20,MATCH(K344,table_simulateur!D$21:D$31,0),0)","v":98.72},{"$f":"OFFSET(table_simulateur!C$20,MATCH(K344,table_simulateur!D$21:D$31,0),0)","v":12098.359999999986},null,"oui","base"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"- Rehausse de l'acrotère",null,null,null,null,null,null,null,null,null,null,null,null,null,""]
["01.01.A","Réhausse de l'acrotère : mise en œuvre d'un rang de maçonnerie",null,550,28.7,{"$f":"D347*E347*IF(O347=\"oui\",1,0)","v":15785},null,7.0000000000000007E-2,{"$f":"F347*(1+H347)","v":16889.95},{"$f":"+I347*L347/M347","v":137.81833769205099},"surface habitable",{"$f":"OFFSET(table_simulateur!B$20,MATCH(K347,table_simulateur!D$21:D$31,0),0)","v":98.72},{"$f":"OFFSET(table_simulateur!C$20,MATCH(K347,table_simulateur!D$21:D$31,0),0)","v":12098.359999999986},null,"oui","base"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"Mise en œuvre d'une isolation polyuréthane 22cm et d'une étanchéité multicouche",null,null,null,{"$f":"IF(O349=\"oui\",SUM(F350:F352),0)","v":217493.5},null,7.0000000000000007E-2,{"$f":"F349*(1+H349)","v":232718.04500000001},{"$f":"+I349*L349/M349","v":1898.9288963462841},"surface habitable",{"$f":"OFFSET(table_simulateur!B$20,MATCH(K349,table_simulateur!D$21:D$31,0),0)","v":98.72},{"$f":"OFFSET(table_simulateur!C$20,MATCH(K349,table_simulateur!D$21:D$31,0),0)","v":12098.359999999986},null,"oui","base"]
["01.01.A","Surface courante et relevés d'étanchéité",null,2937.8,66.5,{"$f":"E350*D350","v":195363.7},null,null,null,null,null,null,null,null,null,""]
["01.01.A","Traitement des édicules d'ascenceur",null,9,287.39999999999998,{"$f":"E351*D351","v":2586.6},null,null,null,null,null,null,null,null,null,""]
["01.01.A","Traitement des sorties et cheminées (ventilations)",null,68,287.39999999999998,{"$f":"E352*D352","v":19543.199999999997},null,null,null,null,null,null,null,null,null,""]
[]
[null,"Fraction des honoraires correspondante (Architecte, BET, bureau de contrôle, SPS), Pilotage et Assurances     ",null,1,{"$f":"11154.9+16543.62+10384.78","v":38083.299999999996},{"$f":"D354*E354*IF(O354=\"oui\",1,0)","v":38083.299999999996},null,{"$f":"I354/F354-1","v":0.10690617672313074},{"$f":"13341.26+17701.67+11111.71","v":42154.64},{"$f":"+I354*L354/M354","v":343.97274182616525},"surface habitable",{"$f":"OFFSET(table_simulateur!B$20,MATCH(K354,table_simulateur!D$21:D$31,0),0)","v":98.72},{"$f":"OFFSET(table_simulateur!C$20,MATCH(K354,table_simulateur!D$21:D$31,0),0)","v":12098.359999999986},null,"oui","base"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
["5 - Aménagements extérieurs divers :",null,null,null,null,null,null,null,{"$f":"SUM(I358:I364)","v":184775.61800000002},{"$f":"SUM(J358:J364)","v":1507.7290648451544},null,null,null,null,null,""]
[]
[null,"Réfection complète des marches et contre-marches des escaliers d'accès aux Entrées",null,1,60408,{"$f":"D359*E359*IF(O359=\"oui\",1,0)","v":60408},null,7.0000000000000007E-2,{"$f":"F359*(1+H359)","v":64636.560000000005},{"$f":"+I359*L359/M359","v":527.42034484012777},"surface habitable",{"$f":"OFFSET(table_simulateur!B$20,MATCH(K359,table_simulateur!D$21:D$31,0),0)","v":98.72},{"$f":"OFFSET(table_simulateur!C$20,MATCH(K359,table_simulateur!D$21:D$31,0),0)","v":12098.359999999986},null,"oui","base"]
[null,"Remplacement des garde-corps de part et d'autre des escaliers d'accès aux Entrées (garde-corps aluminium)",null,1,29546.400000000001,{"$f":"D360*E360*IF(O360=\"oui\",1,0)","v":29546.400000000001},null,7.0000000000000007E-2,{"$f":"F360*(1+H360)","v":31614.648000000005},{"$f":"+I360*L360/M360","v":257.96868753781536},"surface habitable",{"$f":"OFFSET(table_simulateur!B$20,MATCH(K360,table_simulateur!D$21:D$31,0),0)","v":98.72},{"$f":"OFFSET(table_simulateur!C$20,MATCH(K360,table_simulateur!D$21:D$31,0),0)","v":12098.359999999986},null,"oui","base"]
[null,"Mise en œuvre de coffrage métallique des poteaux de façades, remplacement des éclairages en applique",null,1,63792,{"$f":"D361*E361*IF(O361=\"oui\",1,0)","v":63792},null,7.0000000000000007E-2,{"$f":"F361*(1+H361)","v":68257.440000000002},{"$f":"+I361*L361/M361","v":556.965942226881},"surface habitable",{"$f":"OFFSET(table_simulateur!B$20,MATCH(K361,table_simulateur!D$21:D$31,0),0)","v":98.72},{"$f":"OFFSET(table_simulateur!C$20,MATCH(K361,table_simulateur!D$21:D$31,0),0)","v":12098.359999999986},null,"oui","base"]
[]
[null,"Fraction des honoraires correspondante (Architecte, BET, bureau de contrôle, SPS), Pilotage et Assurances      ",null,1,{"$f":"5363.02+7953.79+4992.76","v":18309.57},{"$f":"D363*E363*IF(O363=\"oui\",1,0)","v":18309.57},null,{"$f":"I363/F363-1","v":0.1069058421361071},{"$f":"5342.25+8510.55+6414.17","v":20266.97},{"$f":"+I363*L363/M363","v":165.3740902403303},"surface habitable",{"$f":"OFFSET(table_simulateur!B$20,MATCH(K363,table_simulateur!D$21:D$31,0),0)","v":98.72},{"$f":"OFFSET(table_simulateur!C$20,MATCH(K363,table_simulateur!D$21:D$31,0),0)","v":12098.359999999986},null,"oui","base"]
[]
["6 - Ventilation mécanique contrôlée des logements (option)",null,null,null,null,null,null,null,{"$f":"SUM(I366:I368)","v":0},{"$f":"SUM(J366:J368)","v":0},null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"- Mise en œuvre d'une ventilation mécanique contrôlée simple flux Hygro B dans les pièces humides des logements",null,null,null,null,null,null,null,null,null,null,null,null,null,""]
["01.01.A","Option : Mise en œuvre d'une VMC simple flux Hygro B dans les pièces humides des logements.",null,1,162198.70000000001,{"$f":"D368*E368*IF(O368=\"oui\",1,0)","v":0},null,7.0000000000000007E-2,{"$f":"F368*(1+H368)","v":0},{"$f":"+I368*L368/M368","v":0},"surface habitable",{"$f":"OFFSET(table_simulateur!B$20,MATCH(K368,table_simulateur!D$21:D$31,0),0)","v":98.72},{"$f":"OFFSET(table_simulateur!C$20,MATCH(K368,table_simulateur!D$21:D$31,0),0)","v":12098.359999999986},null,"non","option"]
[null,"- Groupes de ventilation en toiture terrasse, réutilisation des conduits shunt de ventilation naturelle existante,"]
[null,"- Condamnation des arrivées d'air existantes en pièces humides, "]
[null,"- PV pour grilles d'amenée d'air sur les nouveaux chassis,"]
[null,"- Détalonage de l'ensemble des portes intérieures des logements"]
[null,"Fraction des honoraires correspondante (Architecte, BET, bureau de contrôle, SPS), Pilotage et Assurances       ",null,1,{"$f":"13.57%*SUM(I368)/(1+10.69%)","v":0},{"$f":"D373*E373*IF(O373=\"oui\",1,0)","v":0},null,{"$f":"I373/F373-1","v":{"$error":"#DIV/0!"}},{"$f":"13.57%*I368","v":0},{"$f":"+I373*L373/M373","v":0},"surface habitable",{"$f":"OFFSET(table_simulateur!B$20,MATCH(K373,table_simulateur!D$21:D$31,0),0)","v":98.72},{"$f":"OFFSET(table_simulateur!C$20,MATCH(K373,table_simulateur!D$21:D$31,0),0)","v":12098.359999999986},null,"oui","base"]
[]
[null,null,null,null,null,null,null,null,{"$f":"I357+DEVISTOT4+DEVISTOT6+I290+I254+I215+I224+I189","v":4214999.9973291997},{"$f":"J357+devislog6+devislog4+J290+J254+J215+J224+J189","v":34222.656812312453}]

{"sheet":"Feuil1","index":2,"n_rows":14,"n_cols":13,"rows_kept":14,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[null,2013,2014,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024]
["remboursement prêt et assurance",{"$f":"12*mensualite","v":5327.6400794147212},{"$f":"B6","v":5327.6400794147212},{"$f":"C6","v":5327.6400794147212},5327.6400794147212,5327.6400794147212,5327.6400794147212,5327.6400794147212,5327.6400794147212,5327.6400794147212,5327.6400794147212]
["remboursement prêt et assurance cumulé",{"$f":"B6","v":5327.6400794147212},{"$f":"C6+B7","v":10655.280158829442},15982.920238244164,21310.560317658885,26638.200397073604,31965.840476488323,37293.480555903043,42621.120635317762,47948.760714732482,53276.400794147201,53276.400794147201,53276.400794147201]
["économie de charges",{"$f":"simulateur!D38*(simulateur!D37-simulateur!D36)","v":-325.26242774566481},{"$f":"B8*(1+simulateur!$D39)","v":-331.7676763005781},{"$f":"C8*(1+simulateur!$D39)","v":-338.40302982658966},{"$f":"D8*(1+simulateur!$D39)","v":-345.17109042312148},{"$f":"E8*(1+simulateur!$D39)","v":-352.07451223158392},{"$f":"F8*(1+simulateur!$D39)","v":-359.11600247621561},{"$f":"G8*(1+simulateur!$D39)","v":-366.29832252573993},{"$f":"H8*(1+simulateur!$D39)","v":-373.62428897625472},{"$f":"I8*(1+simulateur!$D39)","v":-381.09677475577979},{"$f":"J8*(1+simulateur!$D39)","v":-388.71871025089541},{"$f":"K8*(1+simulateur!$D39)","v":-396.49308445591333},{"$f":"L8*(1+simulateur!$D39)","v":-404.42294614503163}]
["économie de charges cumulé",{"$f":"B8","v":-325.26242774566481},{"$f":"C8+B9","v":-657.03010404624297},{"$f":"D8+C9","v":-995.43313387283263},-1340.6042242959541,-1692.6787365275379,-2051.7947390037534,-2418.0930615294933,-2791.7173505057481,-3172.8141252615278,-3561.5328355124234,-3958.0259199683369,-4362.4488661133682]
["coût cumulé des travaux",{"$f":"SUM(B7,B9)","v":5002.3776516690559},{"$f":"SUM(C7,C9)","v":9998.2500547831987},14987.48710437133,19969.956093362929,24945.521660546066,29914.045737484572,34875.38749437355,39829.403284812011,44775.946589470957,49714.867958634779,49318.374874178866,48913.951928033835]
[]
["Valeur du bien",{"$f":"valeur_logt_actuel","v":236900},{"$f":"valeur_logt_future*(1+simulateur!D33)","v":302124},{"$f":"C12*(1+simulateur!$D33)","v":308166.48},{"$f":"D12*(1+simulateur!$D33)","v":314329.80959999998},{"$f":"E12*(1+simulateur!$D33)","v":320616.40579200001},{"$f":"F12*(1+simulateur!$D33)","v":327028.73390783998},{"$f":"G12*(1+simulateur!$D33)","v":333569.3085859968},{"$f":"H12*(1+simulateur!$D33)","v":340240.69475771673},{"$f":"I12*(1+simulateur!$D33)","v":347045.50865287107},{"$f":"J12*(1+simulateur!$D33)","v":353986.41882592847},{"$f":"K12*(1+simulateur!$D33)","v":361066.14720244706},{"$f":"L12*(1+simulateur!$D33)","v":368287.47014649602}]
[]
["Valeur du bien - montant investi en travaux",{"$f":"B12-B10","v":231897.62234833094},292125.74994521681,293178.99289562867,294359.85350663704,295670.88413145393,297114.6881703554,298693.92109162326,300411.29147290473,302269.56206340011,304271.55086729367,311747.77232826821,319373.51821846218]

{"sheet":"Feuil2","index":3,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[[13,5,13,13]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"puis cliquez ici pour lancer le simulateur :"]
[]
[]
[null,null,null,null,null,"Si le bouton n'est pas visible, pensez à activer les macros."]