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

{"sheet":"ISO_717","index":0,"n_rows":41,"n_cols":27,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
[{"$f":"Traduccion!G3","v":"Acoustical Insulation: Global values calculation according  ISO 717 and Draft ISO 16717"}]
[null,null,null,{"$f":"Traduccion!G10","v":"Shifted value"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STC (1)","STC (2)",1]
[null,null,null,21.983333333333334,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,29.46153846153846,29.5]
[null,{"$f":"Traduccion!G4","v":"Insulation"},{"$f":"Traduccion!G5","v":"Ref curve"},{"$f":"Traduccion!G6","v":"Shifted curve"},{"$f":"Traduccion!G7","v":"Negative differences"},"Li\"Cx-3150\"","Li\"Cx-3150\"-Ri","10^Li*0,1","Li \"Cx-5000\"","Li\"Cx-5000\"-Ri","10^Li*0,1","Li\"Ctr\"","Li\"Ctr\"-Ri","10^Li*0,1",null,"LiLliving","10^Li/10","10^(Li-Ri)/10","LiTraffic","10^Li/10","10^(Li-Ri)/10",null,{"$f":"Traduccion!G8","v":"STC Control Adjustment"},{"$f":"Traduccion!G9","v":"Transmission Loss Adjusted"}]
["50HZ",18.7,null,null,"--",-40,{"$f":"F5-B5","v":-58.7},{"$f":"10^(G5*0.1)","v":1.3489628825916478E-6},-41,{"$f":"I5-B5","v":-59.7},{"$f":"10^(J5*0.1)","v":1.0715193052376028E-6},-25,{"$f":"L5-B5","v":-43.7},{"$f":"10^(M5*0.1)","v":4.265795188015923E-5},null,-41,{"$f":"10^(P5/10)","v":7.9432823472428153E-5},{"$f":"10^((P5-B5)/10)","v":1.0715193052376028E-6},-25,{"$f":"10^(S5/10)","v":3.1622776601683764E-3},{"$f":"10^((S5-B5)/10)","v":4.265795188015923E-5}]
["63Hz",19.2,null,null,"--",-36,-55.2,{"$f":"10^(G6*0.1)","v":3.0199517204020095E-6},-37,{"$f":"I6-B6","v":-56.2},{"$f":"10^(J6*0.1)","v":2.3988329190194829E-6},-23,-42.2,{"$f":"10^(M6*0.1)","v":6.0255958607435637E-5},null,-37,{"$f":"10^(P6/10)","v":1.9952623149688758E-4},{"$f":"10^((P6-B6)/10)","v":2.3988329190194872E-6},-23,{"$f":"10^(S6/10)","v":5.0118723362727212E-3},{"$f":"10^((S6-B6)/10)","v":6.0255958607435637E-5}]
["80Hz",20,null,null,"--",-33,-53,5.0118723362727089E-6,-34,-54,3.9810717055349657E-6,-21,-41,7.9432823472428018E-5,null,-34,3.9810717055349708E-4,3.9810717055349657E-6,-21,7.9432823472428121E-3,7.9432823472428153E-5]
["100Hz",20.399999999999999,33,{"$f":"(C8-$D$3)","v":11.016666666666666},{"$f":"IF(B8<D8,D8-B8,0)","v":0},-29,-49.4,{"$f":"10^(G8*0.1)","v":1.1481536214968799E-5},-30,-50.4,9.1201083935590828E-6,-20,-40.4,{"$f":"10^(M8*0.1)","v":9.1201083935590923E-5},null,-30,1E-3,9.1201083935590828E-6,-20,0.01,9.1201083935590923E-5]
["125Hz",16.3,36,14.016666666666666,0,-26,-42.3,{"$f":"10^(G9*0.1)","v":5.8884365535558867E-5},-27,-43.3,4.6773514128719762E-5,-20,-36.299999999999997,{"$f":"10^(M9*0.1)","v":2.3442288153199204E-4},null,-27,1.9952623149688781E-3,4.6773514128719762E-5,-20,0.01,2.3442288153199204E-4,null,16,{"$f":"B9+W9","v":32.299999999999997},{"$f":"IF(X9>$Y$3,0,$Y$3-X9)","v":0},{"$f":"IF(X9>$Z$3,0,$Z$3-X9)","v":0}]
["160Hz",17.7,39,17.016666666666666,0,-23,-40.700000000000003,8.5113803820237487E-5,-24,-41.7,6.7608297539197985E-5,-18,-35.700000000000003,2.6915348039269118E-4,null,-24,3.9810717055349717E-3,6.7608297539198107E-5,-18,1.5848931924611124E-2,2.6915348039269118E-4,null,13,{"$f":"B10+W10","v":30.7},{"$f":"IF(X10>$Y$3,0,$Y$3-X10)","v":0},{"$f":"IF(X10>$Z$3,0,$Z$3-X10)","v":0}]
["200Hz",22.6,42,20.016666666666666,0,-21,-43.6,4.3651583224016559E-5,-22,-44.6,3.4673685045253161E-5,-16,-38.6,1.3803842646028819E-4,null,-22,6.3095734448019251E-3,3.4673685045253161E-5,-16,2.511886431509578E-2,1.3803842646028819E-4,null,10,32.6,0,0]
["250Hz",22.4,45,23.016666666666666,0.61666666666666714,-19,-41.4,7.2443596007499048E-5,-20,-42.4,5.7543993733715576E-5,-15,-37.4,1.8197008586099805E-4,null,-20,0.01,5.7543993733715576E-5,-15,3.1622776601683784E-2,1.819700858609984E-4,null,7,29.4,6.153846153846132E-2,0.10000000000000142]
["315Hz",22.7,48,26.016666666666666,3.3166666666666664,-17,-39.700000000000003,1.0715193052376032E-4,-18,-40.700000000000003,8.5113803820237487E-5,-14,-36.700000000000003,2.1379620895022272E-4,null,-18,1.5848931924611124E-2,8.5113803820237487E-5,-14,3.9810717055349727E-2,2.1379620895022272E-4,null,4,26.7,2.7615384615384606,2.8000000000000007]
["400Hz",24.8,51,29.016666666666666,4.216666666666665,-15,-39.799999999999997,1.0471285480508985E-4,-16,-40.799999999999997,8.3176377110266955E-5,-13,-37.799999999999997,1.6595869074375585E-4,null,-16,2.511886431509578E-2,8.3176377110266955E-5,-13,5.0118723362727206E-2,1.6595869074375585E-4,null,1,25.8,3.6615384615384592,3.6999999999999993]
["500Hz",26.6,52,30.016666666666666,3.4166666666666643,-13,-39.6,1.0964781961431837E-4,-14,-40.6,8.709635899560788E-5,-12,-38.6,1.3803842646028819E-4,null,-14,3.9810717055349727E-2,8.709635899560788E-5,-12,6.3095734448019317E-2,1.3803842646028819E-4,null,0,26.6,2.8615384615384585,2.8999999999999986]
["630Hz",28,53,31.016666666666666,3.0166666666666657,-12,-40,1E-4,-13,-41,7.9432823472428018E-5,-11,-39,1.2589254117941647E-4,null,-13,5.0118723362727206E-2,7.9432823472428153E-5,-11,7.9432823472428096E-2,1.2589254117941672E-4,null,-1,27,2.4615384615384599,2.5]
["800Hz",30.5,54,32.016666666666666,1.5166666666666657,-11,-41.5,7.0794578438413704E-5,-12,-42.5,5.6234132519034887E-5,-9,-39.5,1.1220184543019618E-4,null,-12,6.3095734448019317E-2,5.6234132519034887E-5,-9,0.12589254117941667,1.1220184543019618E-4,null,-2,28.5,0.9615384615384599,1]
["1000Hz",31.8,55,33.016666666666666,1.216666666666665,-10,-41.8,6.6069344800759539E-5,-11,-42.8,5.2480746024977172E-5,-8,-39.799999999999997,1.0471285480508985E-4,null,-11,7.9432823472428096E-2,5.248074602497726E-5,-8,0.15848931924611132,1.0471285480509003E-4,null,-3,28.8,0.66153846153845919,0.69999999999999929]
["1250Hz",32.5,56,34.016666666666666,1.5166666666666657,-9,-41.5,7.0794578438413704E-5,-10,-42.5,5.6234132519034887E-5,-9,-41.5,7.0794578438413704E-5,null,-10,0.1,5.6234132519034887E-5,-9,0.12589254117941667,7.0794578438413704E-5,null,-4,28.5,0.9615384615384599,1]
["1600Hz",33.4,56,34.016666666666666,0.61666666666666714,-9,-42.4,5.7543993733715576E-5,-10,-43.4,4.5708818961487455E-5,-10,-43.4,4.5708818961487455E-5,null,-10,0.1,4.5708818961487455E-5,-10,0.1,4.5708818961487455E-5,null,-4,29.4,6.153846153846132E-2,0.10000000000000142]
["2000Hz",33,56,34.016666666666666,1.0166666666666657,-9,-42,6.3095734448019279E-5,-10,-43,5.0118723362727238E-5,-11,-44,3.9810717055349634E-5,null,-10,0.1,5.0118723362727238E-5,-11,7.9432823472428096E-2,3.9810717055349634E-5,null,-4,29,0.4615384615384599,0.5]
["2500Hz",31,56,34.016666666666666,3.0166666666666657,-9,-40,1E-4,-10,-41,7.9432823472428018E-5,-13,-44,3.9810717055349634E-5,null,-10,0.1,7.9432823472428153E-5,-13,5.0118723362727206E-2,3.9810717055349634E-5,null,-4,27,2.4615384615384599,2.5]
["3150Hz",25.5,56,34.016666666666666,8.5166666666666657,-9,-34.5,3.5481338923357516E-4,-10,-35.5,2.818382931264449E-4,-15,-40.5,8.912509381337452E-5,null,-10,0.1,2.8183829312644545E-4,-15,3.1622776601683784E-2,8.912509381337452E-5,null,-4,21.5,7.9615384615384599,8]
["4000Hz",26.8,null,null,"--",-9,-35.799999999999997,2.6302679918953782E-4,-10,-36.799999999999997,2.0892961308540387E-4,-16,-42.8,5.2480746024977172E-5,null,null,null,null,null,null,null,null,-4,22.8,6.6615384615384592,6.6999999999999993]
["5000Hz",29.2,null,null,"--",-9,-38.200000000000003,1.5135612484362069E-4,-10,-39.200000000000003,1.2022644346174109E-4,-18,-47.2,1.9054607179632416E-5]
[null,null,null,null,{"$f":"SUM(E8:E23)","v":31.999999999999989},null,"S 100-3150",{"$f":"-10*LOG(SUM(H8:H23))","v":28.308550611864916},null,"S 100-5000",{"$f":"-10*LOG(SUM(K8:K25))","v":28.234044737362524},null,"S 100-3150",{"$f":"-10*LOG(SUM(N8:N23))","v":26.859986221068141},null,"S 50-3150",{"$f":"SUM(Q5:Q23)","v":0.79738876826905969},{"$f":"SUM(R5:R23)","v":1.1800380561549136E-3},"S 50-3150",{"$f":"SUM(T5:T23)","v":1.0126147285653828},{"$f":"SUM(U5:U23)","v":2.2429831850345281E-3},null,null,"S",{"$f":"SUM(Y9:Y24)","v":31.999999999999979}]
["Rw(C;Ctr)=",{"$f":"CONCATENATE(ROUND(E30,0),\"(\",ROUND(H30,0),\";\",ROUND(N30,0),\")\")","v":"30(-2;-3)"},null,null,null,null,"S 50-3150",{"$f":"IF(OR(B5=0,B6=0,B7=0),\"--\",-10*LOG(SUM(H5:H23)))","v":28.281039864976272},null,"S 50-5000",{"$f":"IF(OR(B5=0,B6=0,B7=0),\"--\",-10*LOG(SUM(K5:K25)))","v":28.212548976308597},null,"S 50-3150",{"$f":"IF(OR(B5=0,B6=0,B7=0),\"--\",-10*LOG(SUM(N5:N23)))","v":26.491739821789988},null,"S 100-3150",{"$f":"SUM(Q8:Q23)","v":0.79671170204353692},{"$f":"SUM(R8:R23)","v":1.1725866322251214E-3},"S 100-3150",{"$f":"SUM(T8:T23)","v":0.9964972962216988},{"$f":"SUM(U8:U23)","v":2.0606364510745052E-3},null,null,"Max.",null,{"$f":"MAX(Z9:Z24)","v":8}]
["C50-3150",{"$f":"H31","v":-1.7189601350237282},null,null,null,null,null,null,null,null,null,null,"S 100-5000",{"$f":"-10*LOG(SUM(N8:N25))","v":26.711778040337254}]
["C100-5000",{"$f":"K30","v":-1.7659552626374762},null,null,null,null,null,null,null,null,null,null,"S 50-5000",{"$f":"IF(OR(B5=0,B6=0,B7=0),\"--\",-10*LOG(SUM(N5:N25)))","v":26.355393363662781}]
["C50-5000",{"$f":"K31","v":-1.7874510236914034},null,"Rw",{"$f":"INT(D15)","v":30},null,"C",{"$f":"H26-E30","v":-1.6914493881350836},null,"C100-5000",{"$f":"K26-E30","v":-1.7659552626374762},null,"Ctr",{"$f":"N26-E30","v":-3.1400137789318592},null,null,"Rliving50,HZ",{"$f":"10*LOG(Q26/R26)","v":28.297741005514627},null,"Rtraffic,50Hz",{"$f":"10*LOG(T26/U26)","v":26.54618222125093},null,null,"STC",{"$f":"MIN(Y3:Z3)","v":29.46153846153846}]
["Ctr50-3150",{"$f":"N31","v":-3.508260178210012},null,null,null,null,"C50-3150",{"$f":"IF(H27=\"--\",\"--\",H27-E30)","v":-1.7189601350237282},null,"C50-5000",{"$f":"IF(K27=\"--\",\"--\",K27-E30)","v":-1.7874510236914034},null,"Ctr50-3150",{"$f":"IF(N27=\"--\",\"--\",N27-E30)","v":-3.508260178210012},null,null,"Rliving,100Hz",{"$f":"10*LOG(Q27/R27)","v":28.321562572846702},null,"Rtrafic,100Hz",{"$f":"10*LOG(T27/U27)","v":26.844747467814646}]
["Ctr100-5000",{"$f":"N32","v":-3.2882219596627458},null,null,null,null,null,null,null,null,null,null,"Ctr100-5000",{"$f":"N28-E30","v":-3.2882219596627458}]
["Ctr50-5000",{"$f":"N33","v":-3.6446066363372189},null,null,null,null,null,null,null,null,null,null,"Ctr50-5000",{"$f":"IF(N29=\"--\",\"--\",N29-E30)","v":-3.6446066363372189}]
[]
["Rliving50,HZ",{"$f":"R30","v":28.297741005514627}]
["Rliving,100Hz",{"$f":"R31","v":28.321562572846702}]
["Rtraffic,50Hz",{"$f":"U30","v":26.54618222125093}]
["Rtrafic,100Hz",{"$f":"U31","v":26.844747467814646}]
[]
["STC",{"$f":"Y30","v":29.46153846153846}]
["© Josep Sole"]

{"sheet":"Traduccion","index":1,"n_rows":10,"n_cols":7,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,null,null,null,null,"Selección"]
[1,"Acoustical Insulation: Global values calculation according  ISO 717 and Draft ISO 16717","Aislamiento acústico: Calculo de valores globales según ISO 717 y Borrador ISO 16717",null,null,1,{"$f":"VLOOKUP(F3,$A$3:$C$10,ISO_717!$AA$2+1)","v":"Acoustical Insulation: Global values calculation according  ISO 717 and Draft ISO 16717"}]
[2,"Insulation","Aislamiento",null,null,2,{"$f":"VLOOKUP(F4,$A$3:$C$10,ISO_717!$AA$2+1)","v":"Insulation"}]
[3,"Ref curve","Curva referencia",null,null,3,{"$f":"VLOOKUP(F5,$A$3:$C$10,ISO_717!$AA$2+1)","v":"Ref curve"}]
[4,"Shifted curve","Curva ajustada",null,null,4,{"$f":"VLOOKUP(F6,$A$3:$C$10,ISO_717!$AA$2+1)","v":"Shifted curve"}]
[5,"Negative differences","Diferencias negativas",null,null,5,{"$f":"VLOOKUP(F7,$A$3:$C$10,ISO_717!$AA$2+1)","v":"Negative differences"}]
[6,"STC Control Adjustment","STC (control del ajuste)",null,null,6,{"$f":"VLOOKUP(F8,$A$3:$C$10,ISO_717!$AA$2+1)","v":"STC Control Adjustment"}]
[7,"Transmission Loss Adjusted","Transmisión acústica ajustada",null,null,7,{"$f":"VLOOKUP(F9,$A$3:$C$10,ISO_717!$AA$2+1)","v":"Transmission Loss Adjusted"}]
[8,"Shifted value","Valor de ajuste",null,null,8,{"$f":"VLOOKUP(F10,$A$3:$C$10,ISO_717!$AA$2+1)","v":"Shifted value"}]

{"sheet":"Instructions","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}