{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["PT"],"not_rendered":{"charts":0,"images":11,"macros":1,"external_links":0,"defined_names":127,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"PT","index":0,"n_rows":58,"n_cols":40,"rows_kept":58,"cut":false,"hidden":false,"merged":[[42,9,46,9],[44,29,48,29],[29,20,29,22],[30,20,30,22],[31,1,35,1],[32,18,36,18],[37,29,41,29],[39,11,39,15],[40,11,40,15],[26,9,30,9],[26,29,26,33],[28,3,28,5],[28,27,32,27],[29,3,29,5],[15,1,19,1],[16,18,20,18],[23,11,23,15],[24,11,24,15],[25,29,25,33],[8,11,8,15],[8,29,8,33],[9,11,9,15],[9,29,9,33],[11,2,11,3],[11,9,15,9],[11,27,15,27],[12,2,14,3],[13,20,13,24],[14,20,14,24]]}
[null,"PILARES",null,null,null,null,null,null,null,"HUECOS: JAMBAS, DINTELES Y ALFEIZARES",null,null,null,null,"Umuro:",{"$f":"IF($G$9=\"\",\"\",$G$9)","v":2},null,null,"CAPIALZADOS",null,null,null,null,"Umuro:",{"$f":"IF($G$9=\"\",\"\",$G$9)","v":2},null,null,"SUELOS EN CONTACTO CON EL AIRE EXTERIOR",null,null,null,null,null,null,"Umuro:",{"$f":"IF($G$9=\"\",\"\",$G$9)","v":2},null,"Elemento","Dato 2",{"$f":"L9","v":"Ψi [w/mK]"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Umarco:",null,null,null,null,null,null,null,null,"Umarco:",{"$f":"IF(P2=\"\",\"\",P2)","v":""},null,null,null,null,null,null,null,null,null,"Usuelo:",null,null,{"$f":"\"Pilar integrado en fachada \"&IF(G9=\"\",\"\",\".- U muro = \"&G9&\" [w/m2 K]\")","v":"Pilar integrado en fachada .- U muro = 2 [w/m2 K]"},null,{"$f":"IF(G10=0,\"\",G10)","v":7.6214303451701021E-2}]
[null,null,null,null,null,null,null,null,null,"JAMBAS",null,null,null,null,"Longitud [m]:",null,null,null,1.8,{"$f":"Y22","v":-0.13373354854730568},null,null,null,"Ψi [w/mK]:",{"$f":"IFERROR(IF($Y$2=\"\",\"\",VLOOKUP($Y$2,S3:T7,2)),\"\")","v":""},null,null,0.32,{"$f":"AH17","v":0.22000000000000003},null,null,null,null,null,"Ψi [w/mK]:",{"$f":"IF(AJ2=\"\",\"\",_xlfn.FORECAST.LINEAR($AJ$2,AC3:AC7,AB3:AB7))","v":""},null,{"$f":"\"Encuentro de fachada con forjado \"&IF(G26=\"\",\"\",\".- Canto forjado [cm]\")","v":"Encuentro de fachada con forjado .- Canto forjado [cm]"},{"$f":"IF(G26=0,\"\",G26)","v":30},{"$f":"IF(G27=0,\"\",G27)","v":0.80880307921529671}]
[null,null,null,null,null,null,null,null,null,1.8,{"$f":"P17","v":0.1000372485721381},null,null,null,"Ψi [w/mK]:",{"$f":"IF(P2=\"\",\"\",VLOOKUP(P2,J4:K8,2))","v":""},null,null,2.2000000000000002,{"$f":"X22","v":-0.14817730320337721},null,null,null,null,null,null,null,0.37,{"$f":"AG17","v":0.23000000000000004},null,null,null,null,null,null,null,null,{"$f":"\"Encuentro de fachada con cubierta \"&IF(Y32=\"\",\"\",\".- U cubierta [w/m2 K]\")","v":"Encuentro de fachada con cubierta "},{"$f":"IF(Y32=0,\"\",Y32)","v":""},{"$f":"IF(Y33=0,\"\",Y33)","v":""}]
[null,null,null,null,null,null,null,null,null,2.2000000000000002,{"$f":"O17","v":0.15123292773777008},null,null,null,null,null,null,null,3.2,{"$f":"W22","v":-0.10744723118947105},null,null,null,null,{"$f":"IFERROR(MATCH(Y1,T17:T21,0),\"\")","v":""},null,null,0.42,{"$f":"AF17","v":0.22628631735783461},null,null,null,null,null,null,{"$f":"IFERROR(MATCH(AJ1,AC12:AC16,0),\"\")","v":""},null,{"$f":"\"Encuentro de fachada con suelo exterior \"&IF(AJ2=\"\",\"\",\".- U suelo [w/m2 K]\")","v":"Encuentro de fachada con suelo exterior "},{"$f":"IF(AJ2=0,\"\",AJ2)","v":""},{"$f":"IF(AJ3=0,\"\",AJ3)","v":""}]
[null,null,null,null,null,null,null,null,null,3.2,{"$f":"N17","v":0.26362428606903399},null,null,null,null,{"$f":"IFERROR(MATCH(P1,K12:K16,0),\"\")","v":""},null,null,4,{"$f":"V22","v":-7.3733548547305669E-2},null,null,null,null,{"$f":"IFERROR(MATCH(Y2,U16:Y16,0),\"\")","v":""},null,null,0.52,{"$f":"AE17","v":0.22880432083436797},null,null,null,null,null,null,{"$f":"IFERROR(MATCH(AJ2,AD11:AH11,0),\"\")","v":""},null,{"$f":"\"Encuentro de fachada con solera \"&IF(AJ23=\"\",\"\",\".- U solera [w/m2 K]\")","v":"Encuentro de fachada con solera "},{"$f":"IF(AJ23=0,\"\",AJ23)","v":""},{"$f":"IF(AJ24=0,\"\",AJ24)","v":""}]
[null,null,null,null,null,null,null,null,null,4,{"$f":"M17","v":0.37544077477030047},null,null,null,null,{"$f":"IFERROR(MATCH(P2,L11:P11,0),\"\")","v":""},null,null,5.7,{"$f":"U22","v":-5.7447231189471037E-2},null,null,null,null,null,null,null,0.53,{"$f":"AD17","v":0.22880432083436797}]
[null,null,null,null,null,null,null,null,null,5.7,{"$f":"L17","v":0.86007077228706219},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,{"$f":"\"Contorno de huecos de fachada \"&IF(Y2=\"\",\"\",\".- U marco [w/m2 K]\")","v":"Contorno de huecos de fachada "},{"$f":"Y2","v":""},{"$f":"IF(L50=0,\"\",L50)","v":""}]
[null,null,null,null,null,"Umuro",2,null,null,null,null,"Ψi [w/mK]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ψi [w/mK]",null,null,null,null,null,null,null,{"$f":"\"Cajas de persiana (capialzados) \"&IF(Y2=\"\",\"\",\".- U marco [w/m2 K]\")","v":"Cajas de persiana (capialzados) "},{"$f":"Y2","v":""},{"$f":"IF(Y3=0,\"\",Y3)","v":""}]
[null,null,null,null,null,"Ψi [w/mK]:",{"$f":"IF(G9=\"\",\"\",_xlfn.FORECAST.LINEAR(G9,D16:D20,C16:C20))","v":7.6214303451701021E-2},null,null,null,null,"Umarco [w/m2K]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Usuelo [w/m2K]"]
[null,null,null,null,null,null,null,null,null,null,null,5.7,4,3.2,2.2000000000000002,1.8,null,null,null,null,null,null,null,null,null,null,null,null,null,0.53,0.52,0.42,0.37,0.32,null,null,null,"Esquina saliente (al exterior)",null,{"$f":"IF(AJ38=0,\"\",AJ38)","v":0.26116091383163642}]
[null,null,"Ψi [w/mK]",null,null,null,null,null,null,"Umuro [w/m2K]",0.73,0.38,0.17,0.12,7.0000000000000007E-2,0.05,null,null,null,null,null,null,null,null,null,null,null,"Umuro [w/m2K]",0.73,0.26,0.26,0.24,0.23,0.22,null,null,null,"Esquina entrante (al interior)",null,{"$f":"IF(AJ45=0,\"\",AJ45)","v":-0.39239384156940649}]
[null,null,"Dimensiones del pilar [cmxcm] 20x20 / 30x30",null,null,null,null,null,null,null,0.44,0.27,0.16,0.1,0.05,0.03,null,null,null,null,null,null,null,null,null,null,null,null,0.44,0.26,0.26,0.24,0.23,0.22]
[null,null,null,null,null,null,null,null,null,null,0.31,0.22,0.11,7.0000000000000007E-2,0.04,0.03,null,null,null,null,"Ψi [w/mK]",null,null,null,null,null,null,null,0.31,0.27,0.27,0.24,0.23,0.22,null,null,null,"Pilar en esquina saliente",null,{"$f":"IF($G$10=\"\",\"\",$AN$2+AN11)","v":0.33737521728333741}]
[null,null,null,null,null,null,null,null,null,null,0.27,0.2,0.1,7.0000000000000007E-2,0.04,0.03,null,null,null,null,"Umarco [w/m2K]",null,null,null,null,null,null,null,0.27,0.27,0.27,0.24,0.23,0.22,null,null,null,"Pilar en esquina entrante",null,{"$f":"IF($G$10=\"\",\"\",$AN$2+AN12)","v":-0.31617953811770549}]
[null,"Umuro [w/m2K]",0.73,0.02,null,null,null,null,null,null,0.24,0.2,0.1,7.0000000000000007E-2,0.04,0.03,null,null,null,null,5.7,4,3.2,2.2000000000000002,1.8,null,null,null,0.24,0.27,0.27,0.25,0.23,0.22]
[null,null,0.44,0.01,null,null,null,null,null,null,null,{"$f":"_xlfn.FORECAST.LINEAR($P$1,L12:L16,$K$12:$K$16)","v":0.86007077228706219},{"$f":"_xlfn.FORECAST.LINEAR($P$1,M12:M16,$K$12:$K$16)","v":0.37544077477030047},0.26362428606903399,0.15123292773777008,0.1000372485721381,null,null,"Umuro [w/m2K]",0.73,0.08,0.05,0.03,0,-0.01,null,null,null,null,{"$f":"_xlfn.FORECAST.LINEAR($AJ$1,AD12:AD16,$AC$12:$AC$16)","v":0.22880432083436797},{"$f":"_xlfn.FORECAST.LINEAR($AJ$1,AE12:AE16,$AC$12:$AC$16)","v":0.22880432083436797},0.22628631735783461,0.23000000000000004,0.22000000000000003]
[null,null,0.31,0,null,null,null,null,null,"DINTEL",null,null,null,null,"Umuro:",{"$f":"P1","v":2},null,null,null,0.44,0.11,0.08,0.06,0.03,0.02]
[null,null,0.27,0,null,null,null,null,null,1.8,{"$f":"P32","v":0.24185373727340451},null,null,null,"Umarco:",{"$f":"P2","v":0},null,null,null,0.31,0.13,0.1,0.08,0.05,0.04,null,null,"SUELOS EN CONTACTO CON EL TERRENO"]
[null,null,0.24,0,null,null,null,null,null,2.2000000000000002,{"$f":"O32","v":0.23185373727340453},null,null,null,"Longitud:",null,null,null,null,0.27,0.13,0.1,0.08,0.06,0.04,null,null,0.32,{"$f":"AH34","v":-0.1568748447976161}]
[null,null,null,null,null,null,null,null,null,3.2,{"$f":"N32","v":0.22499255028557241},null,null,null,"Ψi [w/mK]:",{"$f":"IF(P19=0,\"\",VLOOKUP(P19,J19:K23,2))","v":""},null,null,null,0.24,0.13,0.09,0.08,0.05,0.03,null,null,0.37,{"$f":"AG34","v":-0.11687484479761606}]
[null,null,null,null,null,null,null,null,null,4,{"$f":"M32","v":0.27294015396076482},null,null,null,null,{"$f":"IFERROR(MATCH(P18,K27:K31,0),\"\")","v":""},null,null,null,null,{"$f":"_xlfn.FORECAST.LINEAR($Y$1,U17:U21,$T$17:$T$21)","v":-5.7447231189471037E-2},{"$f":"_xlfn.FORECAST.LINEAR($Y$1,V17:V21,$T$17:$T$21)","v":-7.3733548547305669E-2},-0.10744723118947105,-0.14817730320337721,-0.13373354854730568,null,null,0.42,{"$f":"AF34","v":-8.760491681152216E-2},null,null,null,null,null,"Umuro:",{"$f":"IF($G$9=\"\",\"\",$G$9)","v":2}]
[null,"FRENTE DE FORJADOS",null,null,null,null,null,null,null,5.7,{"$f":"L32","v":0.72385646883536126},null,null,null,null,{"$f":"IFERROR(MATCH(P19,L26:P26,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,0.52,{"$f":"AE34","v":-3.8070523963248004E-2},null,null,null,null,null,"Usuelo:"]
[null,null,null,null,null,null,null,null,null,null,null,"Ψi [w/mK]",null,null,null,null,null,null,"CUBIERTAS PLANAS",null,null,null,null,null,null,null,null,0.53,{"$f":"AD34","v":-2.8070523963248051E-2},null,null,null,null,null,"Ψi [w/mK]:",{"$f":"IF(AJ23=\"\",\"\",_xlfn.FORECAST.LINEAR(AJ23,AC20:AC24,AB20:AB24))","v":""}]
[null,25,{"$f":"D37","v":0.69432207598708717},null,null,"Umuro",{"$f":"IF($G$9=\"\",\"\",$G$9)","v":2},null,null,null,null,"Umarco [w/m2K]"]
[null,30,{"$f":"E37","v":0.80880307921529671},null,null,"E forjado",30,null,null,null,null,5.7,4,3.2,2.2000000000000002,1.8,null,null,0.28000000000000003,{"$f":"W38","v":0.64316116215545072},null,null,null,null,null,null,null,null,null,"Ψi [w/mK]",null,null,null,null,null,{"$f":"IFERROR(MATCH(AJ22,AC29:AC33,0),\"\")","v":""}]
[null,35,{"$f":"F37","v":0.91930593493916057},null,null,"Ψi [w/mK]:",{"$f":"IFERROR(VLOOKUP($G$26,B25:C27,2),\"\")","v":0.80880307921529671},null,null,"Umuro [w/m2K]",0.73,0.3,0.11,0.1,0.12,0.13,null,null,0.38,{"$f":"V38","v":0.65243109014154443},null,null,null,null,null,null,null,null,null,"Usolera [w/m2K]",null,null,null,null,null,{"$f":"IFERROR(MATCH(AJ23,AD28:AH28,0),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,0.44,0.2,0.11,0.1,0.11,0.12,null,null,0.5,{"$f":"U38","v":0.60239384156940645},null,null,null,null,null,null,null,null,null,0.53,0.52,0.42,0.37,0.32]
[null,null,null,"Ψi [w/mK]",null,null,null,null,null,null,0.31,0.16,7.0000000000000007E-2,0.08,0.09,0.1,null,null,null,null,null,null,null,null,null,null,null,"Umuro [w/m2K]",0.73,0.31,0.3,0.23,0.19,0.15]
[null,null,null,"Espesor forjado [cm]",null,null,null,null,null,null,0.27,0.14000000000000001,0.06,0.06,0.08,0.09,null,null,null,null,"Ψi [w/mK]",null,null,null,null,null,null,null,0.44,0.38,0.37,0.3,0.26,0.22]
[null,null,null,25,30,35,null,null,null,null,0.24,0.14000000000000001,0.05,0.05,0.08,0.09,null,null,null,null,"Ucubierta [w/m2K]",null,null,"Umuro:",{"$f":"IF($G$9=\"\",\"\",$G$9)","v":2},null,null,null,0.31,0.42,0.41,0.33,0.28999999999999998,0.25]
[null,"Umuro [w/m2K]",0.73,0.25,0.28999999999999998,0.33,null,null,null,null,null,{"$f":"_xlfn.FORECAST.LINEAR($P$1,L27:L31,$K$27:$K$31)","v":0.72385646883536126},{"$f":"_xlfn.FORECAST.LINEAR($P$1,M27:M31,$K$27:$K$31)","v":0.27294015396076482},0.22499255028557241,0.23185373727340453,0.24185373727340451,null,null,null,null,0.5,0.38,0.28000000000000003,"Ucubierta:",null,null,null,null,0.27,0.43,0.42,0.35,0.3,0.26]
[null,null,0.44,0.15,0.17,0.19,null,null,null,"ALFEIZAR",null,null,null,null,"Umuro:",{"$f":"P1","v":2},null,null,"Umuro [w/m2K]",0.73,0.37,0.37,0.35,"Ψi [w/mK]:",{"$f":"IF(Y32=\"\",\"\",_xlfn.FORECAST.LINEAR(Y32,T26:T28,S26:S28))","v":""},null,null,null,0.24,0.44,0.43,0.35,0.31,0.27]
[null,null,0.31,0.1,0.12,0.13,null,null,null,null,null,null,null,null,"Umarco:",{"$f":"P2","v":0},null,null,null,0.44,0.32,0.3,0.28000000000000003,null,null,null,null,null,null,{"$f":"_xlfn.FORECAST.LINEAR($AJ$22,AD29:AD33,$AC$29:$AC$33)","v":-2.8070523963248051E-2},{"$f":"_xlfn.FORECAST.LINEAR($AJ$22,AE29:AE33,$AC$29:$AC$33)","v":-3.8070523963248004E-2},-8.760491681152216E-2,-0.11687484479761606,-0.1568748447976161]
[null,null,0.27,0.09,0.1,0.12,null,null,null,null,"Es una puerta",0,null,null,"Longitud:",{"$f":"IF(L35=TRUE,0,IF(P20=\"\",\"\",P20))","v":""},null,null,null,0.31,0.28999999999999998,0.27,0.25,null,{"$f":"IFERROR(MATCH(Y31,T33:T37,0),\"\")","v":""}]
[null,null,0.24,0.08,0.09,0.1,null,null,null,null,null,null,null,null,"Ψi [w/mK]:",{"$f":"IF(P34=0,\"\",VLOOKUP(P34,J37:K41,2))","v":""},null,null,null,0.27,0.28999999999999998,0.27,0.24,null,{"$f":"IFERROR(MATCH(Y32,U32:W32,0),\"\")","v":""},null,null,"ESQUINAS"]
[null,null,null,{"$f":"IF($G$9=\"\",\"\",_xlfn.FORECAST.LINEAR($G$25,D32:D36,$C$32:$C$36))","v":0.69432207598708717},{"$f":"IF($G$9=\"\",\"\",_xlfn.FORECAST.LINEAR($G$25,E32:E36,$C$32:$C$36))","v":0.80880307921529671},0.91930593493916057,null,null,null,1.8,{"$f":"P48","v":0.12119567916563195},null,null,null,null,{"$f":"IFERROR(MATCH(P33,K43:K47,0),\"\")","v":""},null,null,null,0.24,0.28000000000000003,0.26,0.24,null,null,null,null,null,null,null,"Ψi [w/mK]",null,null,null,"Umuro",{"$f":"IF($G$9=\"\",\"\",$G$9)","v":2}]
[null,null,null,null,null,null,{"$f":"MATCH(G25,C32:C36,0)","v":{"$error":"#N/A"}},null,null,2.2000000000000002,{"$f":"O48","v":0.12119567916563195},null,null,null,null,{"$f":"IFERROR(MATCH(P34,L42:P42,0),\"\")","v":""},null,null,null,null,{"$f":"_xlfn.FORECAST.LINEAR($Y$31,U33:U37,$T$33:$T$37)","v":0.60239384156940645},{"$f":"_xlfn.FORECAST.LINEAR($Y$31,V33:V37,$T$33:$T$37)","v":0.65243109014154443},0.64316116215545072,null,null,null,null,null,null,"Umuro [w/m2K]",0.73,0.11,null,null,"Ψi [w/mK]:",{"$f":"IFERROR(_xlfn.FORECAST.LINEAR($AJ$37,AF38:AF42,$AE$38:$AE42),\"\")","v":0.26116091383163642}]
[null,null,null,null,null,null,{"$f":"MATCH(G26,D31:F31,0)","v":2},null,null,3.2,{"$f":"N48","v":0.1449093618077974},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.44,0.08]
[null,null,null,null,null,null,null,null,null,4,{"$f":"M48","v":0.17563943382170344},"Ψi [w/mK]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.31,0.06]
[null,null,null,null,null,null,null,null,null,5.7,{"$f":"L48","v":0.46915445741246581},"Umarco [w/m2K]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.27,0.06]
[null,null,null,null,null,null,null,null,null,null,null,5.7,4,3.2,2.2000000000000002,1.8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.24,0.05]
[null,null,null,null,null,null,null,null,null,"Umuro [w/m2K]",0.73,0.25,0.12,0.1,0.09,0.09]
[null,null,null,null,null,null,null,null,null,null,0.44,0.24,0.12,0.1,0.09,0.09,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ψi [w/mK]",null,null,null,"Umuro",{"$f":"IF($G$9=\"\",\"\",$G$9)","v":2}]
[null,null,null,null,null,null,null,null,null,null,0.31,0.19,0.11,0.09,0.08,0.08,null,null,null,null,null,null,null,null,null,null,null,null,null,"Umuro [w/m2K]",0.73,-0.16,null,null,"Ψi [w/mK]:",{"$f":"IFERROR(_xlfn.FORECAST.LINEAR($AJ$37,AF45:AF49,$AE$45:$AE49),\"\")","v":-0.39239384156940649}]
[null,null,null,null,null,null,null,null,null,null,0.27,0.18,0.1,0.09,0.08,0.08,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.44,-0.11]
[null,null,null,null,null,null,null,null,null,null,0.24,0.17,0.1,0.08,0.08,0.08,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.31,-0.08]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"_xlfn.FORECAST.LINEAR($P$1,L43:L47,$K$43:$K$47)","v":0.46915445741246581},{"$f":"_xlfn.FORECAST.LINEAR($P$1,M43:M47,$K$43:$K$47)","v":0.17563943382170344},0.1449093618077974,0.12119567916563195,0.12119567916563195,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.27,-0.08]
[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,null,0.24,-7.0000000000000007E-2]
[null,null,null,null,null,null,null,null,null,null,"Ψi Hueco [w/mK]:",{"$f":"IF(OR(P3=\"\",P20=\"\"),\"\",(2*P3*P4+P20*P21+P35*P36)/(2*P3+P20+P35))","v":""}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,0.73,5.7,25,0.5,0.53]
[null,null,null,null,null,null,null,null,null,0.44,4,30,0.38,0.52]
[null,null,null,null,null,null,null,null,null,0.31,3.2,35,0.28000000000000003,0.42]
[null,null,null,null,null,null,null,null,null,0.27,2.2000000000000002,null,null,0.37]
[null,null,null,null,null,null,null,null,null,0.24,1.8,null,null,0.32]