{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["images","opciones","ARMARIOS","BATERÍAS","INDEX"],"not_rendered":{"charts":0,"images":36,"macros":1,"external_links":0,"defined_names":26,"comments":2,"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":"images","index":0,"n_rows":18,"n_cols":32,"rows_kept":18,"cut":false,"hidden":true,"merged":[]}
["ALL IMAGES",null,null,null,{"$f":"+ARMARIOS!D4","v":0},{"$f":"IF(E1=\"COBRE\",\"Tubería de cobre Ø\",IF(E1=\"ACERO\",\"Tubería de acero Ø\",IF(E1=\"PE\",\"Tubería de PE Ø\",\"Tubería de inox Ø\")))&ARMARIOS!E4","v":"Tubería de inox Ø"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ARMARIOS!D11=\"NO\",\"NO\",ARMARIOS!D11&ARMARIOS!H11)","v":"NO"},{"$f":"IF(ARMARIOS!D13=\"NO\",\"NO\",ARMARIOS!D13&ARMARIOS!H13)","v":""},{"$f":"IF(ARMARIOS!D15=\"NO\",\"NO\",ARMARIOS!D15&ARMARIOS!H15)","v":""},null,{"$f":"IF(ARMARIOS!K4=\"Regulación sólo\",\"Regulación sólo\",IF(ARMARIOS!M6=\"SI\",\"CON contador \"&ARMARIOS!K4,\"SIN contador - \"&ARMARIOS!K4))","v":"SIN contador - "},{"$f":"IF(LEFT(W1,3)=\"CON\",\"Con contador \"&ARMARIOS!K4,IF(LEFT(W1,3)=\"SIN\",\"Con soporte para \"&ARMARIOS!K4,\"Regulación sólo\"))","v":"Con soporte para "},null,null,{"$f":"+ARMARIOS!G4","v":0},{"$f":"IF(AA1=\"COBRE\",\"Tubería de cobre Ø\",IF(AA1=\"ACERO\",\"Tubería de acero Ø\",IF(AA1=\"PE\",\"Tubería de PE Ø\",\"Tubería de inox Ø\")))&ARMARIOS!H4","v":"Tubería de inox Ø"}]
["objeto","imagen","opciones",null,"ENTRADA",{"$f":"INDEX(images!$E$3:$F$6,MATCH(ARMARIOS!$B$20,images!$E$3:$E$6,0),2)","v":0},null,null,"TOMAENTRADA",{"$f":"INDEX(images!$I$3:$J$8,MATCH(ARMARIOS!$D$8,images!$I$3:$I$8,0),2)","v":{"$error":"#N/A"}},null,"FILTROSINO",{"$f":"INDEX(images!$L$3:$M$4,MATCH(ARMARIOS!$D$9,images!$L$3:$L$4,0),2)","v":{"$error":"#N/A"}},null,"REGULADORONO",{"$f":"INDEX(images!$O$3:$P$7,MATCH(ARMARIOS!$D$10,images!$O$3:$O$7,0),2)","v":{"$error":"#N/A"}},null,"LLAVE1-3",{"$f":"INDEX(images!$R$3:$S$8,MATCH(images!$S$1,images!$R$3:$R$8,0),2)","v":0},{"$f":"INDEX(images!$R$3:$S$8,MATCH(images!$T$1,images!$R$3:$R$8,0),2)","v":{"$error":"#N/A"}},{"$f":"INDEX(images!$R$3:$S$8,MATCH(images!$U$1,images!$R$3:$R$8,0),2)","v":{"$error":"#N/A"}},null,"CONTADORSINO",{"$f":"INDEX(images!$W$3:$X$5,MATCH(images!$X$1,images!$W$3:$W$5,0),2)","v":"\n\nSoporte para  \n\n\n"},null,null,"SALIDA",{"$f":"INDEX(images!$AA$3:$AB$6,MATCH(ARMARIOS!$N$20,images!$AA$3:$AA$6,0),2)","v":0},null,"TODASTOMAS",{"$f":"INDEX(images!$AD$3:$AE$13,MATCH(ARMARIOS!$D$12,images!$AD$3:$AD$13,0),2)","v":{"$error":"#N/A"}},{"$f":"INDEX(images!$AD$3:$AE$13,MATCH(ARMARIOS!$D$16,images!$AD$3:$AD$13,0),2)","v":{"$error":"#N/A"}}]
["Nada",null,null,null,{"$f":"\"Tubería de cobre Ø\" & ARMARIOS!E4","v":"Tubería de cobre Ø"},null,"---",null,"Llave",null,"---","NO",null,null,"Sin regulador",null,"---","SI",null,"---",null,null,{"$f":"IF(LEFT(W1,3)=\"CON\",\"Con contador \" & ARMARIOS!K4,\"Sin contador\")","v":"Sin contador"},{"$f":"+\"      \"& ARMARIOS!K4&\" \n\n  \"","v":"       \n\n  "},"---",null,{"$f":"\"Tubería de cobre Ø\" & ARMARIOS!H4","v":"Tubería de cobre Ø"},null,"---","Llave",null,"---"]
["Regulador",null,null,null,{"$f":"\"Tubería de acero Ø\" & ARMARIOS!E4","v":"Tubería de acero Ø"},null,"---",null,"Toma de presión",null,"---","SI",null,"---","Regulador sin seguridades",null,"---","NO",null,"---",null,null,{"$f":"\"Con soporte para \"& ARMARIOS!K4","v":"Con soporte para "},{"$f":"\"\n\nSoporte para \"&ARMARIOS!K4&\" \n\n\n\"","v":"\n\nSoporte para  \n\n\n"},"---",null,{"$f":"\"Tubería de acero Ø\" & ARMARIOS!H4","v":"Tubería de acero Ø"},null,"---","Toma de presión",null,"---"]
["Llave",null,null,null,{"$f":"\"Tubería de PE Ø\" & ARMARIOS!E4","v":"Tubería de PE Ø"},null,"---",null,"Toma en la tubería de entrada y después llave",null,"---",null,null,null,"Regulador con VIS MAX",null,"---",{"$f":"\"SI\"&opciones!G28","v":"SIDe palanca"},null,"---",null,null,"Regulación sólo",null,"---",null,{"$f":"\"Tubería de PE Ø\" & ARMARIOS!H4","v":"Tubería de PE Ø"},null,"---","Toma en la tubería de entrada y después llave",null,"---"]
["Toma de presión",null,"> 150mbar Peterson\n< 150 mbar Débil Calibre",null,{"$f":"\"Tubería de inox Ø\" & ARMARIOS!E4","v":"Tubería de inox Ø"},null,"---",null,null,null,null,null,null,null,"Regulador con VIS MIN",null,"---",{"$f":"\"SI\"&opciones!G29","v":"SIDe mariposa"},null,"---",null,null,null,null,null,null,{"$f":"\"Tubería de inox Ø\" & ARMARIOS!H4","v":"Tubería de inox Ø"},null,"---",null,null,"---"]
["Válvula de 3 vías",null,null,null,null,null,null,null,"Llave con toma incorporada",null,"---",null,null,null,"Regulador con VIS MIN & MAX",null,"---",{"$f":"\"SI\"&opciones!G30","v":"SIDe bola"},null,"---",null,null,null,null,null,null,null,null,null,"Llave con toma incorporada",null,"---"]
["Contador",null,null,null,null,null,null,null,"Llave con manómetro",null,"---",null,null,null,null,null,null,"SINO",null,"---",null,null,null,null,null,null,null,null,null,"Llave con manómetro",null,"---"]
["Manometro",null,null,null,null,null,null,null,"Válvula con mínima",null,"---",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Toma de presión Peterson",null,"---"]
["Regulador con VIS MAX",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,"Toma de presión con manómetro",null,"---"]
["Regulador con VIS MIN",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,"Válvula de 3 vías enchufe rápido con manómetro",null,"---"]
["Regulador con VIS MIN & MAX",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,"Válvula de 3 vías con manómetro",null,"---"]
["Limitador de presión",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,"Válvula portamanómetro",null,"---"]
["Filtro",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,"Válvula con mínima",null,"---"]
["Tubería de cobre",null,"Para Entrada",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,"Toma de presión débil calibre",null,"---"]
["Tubería de acero",null,"Para Entrada"]
["Tubería de PE",null,"Para Entrada"]
["Tubería de inox",null,"Para Entrada"]

{"sheet":"opciones","index":1,"n_rows":110,"n_cols":57,"rows_kept":110,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,"DIAMETROS",null,null,null,null,null,null,null,null,null,"BATERIAS",null,null,null,null,null,null,"mins",{"$f":"+MIN(AD3:AD98)","v":348.33333333333331},{"$f":"+MIN(AE3:AE98)","v":300},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
["CONTADORES",null,null,null,null,null,null,null,"GAS","GLP",null,null,"COBRE","ACERO","PE","ACERO_INOX",null,"Regulación sólo",null,null,"HELPER","TIPO","DESCRIPCION","CONTADORES VERTICAL","CONTADORES HORIZONTAL","CONTADORES TOTAL","ALTO BATERIA","ANCHO BATERIA","FONDO BATERIA","ESPACIO VERTICAL","ESPACIO HORIZONTAL","ALTO ARMARIO","ANCHO ARMARIO","FONDO ARMARIO",null,null,null,"TIPO DE ARMARIO / BATERIA",null,null,null,null,null,null,null,null,null,null,"Martigrap baterias en ARMARIOS"]
["Modelo","Modelo","Caudal MAX","Presión trabajo","Conexiones","Caudal MIN","OPCION",null,null,"GN",null,null,"15 mm","20 mm","10 mm","12 mm",null,"1 x G-4",null,null,{"$f":"+V3&TEXT(Z3,\"00\")","v":"GLP MPB02"},"GLP MPB",{"$f":"\"Batería con \"&X3&\" verticales y \"&Y3&\" horizontales. Total: \"&Z3&\" contadores.\"","v":"Batería con 2 verticales y 1 horizontales. Total: 2 contadores."},2,1,{"$f":"+Y3*X3","v":2},1030,500,270,{"$f":"+AA3/X3","v":515},{"$f":"+AB3/Y3","v":500},null,null,270,null,null,null,null,"Batería sin armario",null,null,"Convertidor de presión:"]
["1 x G-4","G-4","6 m3/h","0,5 bar","MxM 7/8\"","0,04 m3/h",1,null,null,null,null,null,"18 mm","32 mm","15 mm","15 mm",null,"2 x G-4",null,null,"GLP MPB02","GLP MPB","Batería con 1 verticales y 2 horizontales. Total: 2 contadores.",1,2,2,600,700,270,600,350,null,null,270,null,null,null,null,"Armario galvanizado",null,null,null,null,null,null,null,null,null,"TIPO","Martigrap code","Size","total","layout","vertical","horizontal","Real space","removed"]
["2 x G-4","G-4","6 m3/h","0,5 bar","MxM 7/8\"","0,04 m3/h",2,null,null,null,null,null,"22 mm","40 mm","20 mm","18 mm",null,"G-6",null,null,"GLP MPB03","GLP MPB","Batería con 3 verticales y 1 horizontales. Total: 3 contadores.",3,1,3,1415,500,270,471.66666666666669,500,900,770,270,null,"900x770x270",null,null,null,null,null,null,"AS IS","number","units","BAR","EQUIV",null,"GN MPA",7402100000,"1070x770x400",3,"2+1",2,2,{"$f":"+BC5*BB5","v":4},{"$f":"(BB5*BC5)-AZ5","v":1}]
["G-6","G-6","10 m3/h","0,5 bar","MxM 1 1/4\"","0,06 m3/h",3,null,null,null,null,null,"28 mm","63 mm","25 mm","22 mm",null,"G-16",null,null,"GLP MPB03","GLP MPB","Batería con 1 verticales y 3 horizontales. Total: 3 contadores.",1,3,3,600,1000,270,600,333.33333333333331,900,770,270,null,"900x770x270",null,null,null,null,null,"entrada:",{"$f":"+BATERÍAS!E4","v":0},{"$f":"VALUE(TRIM(SUBSTITUTE(SUBSTITUTE(UPPER(AQ6),\"MBAR\",\"\"),\"BAR\",\"\")))","v":0},{"$f":"+IF(RIGHT(AQ6,4)=\"mbar\",\"MBAR\",IF(RIGHT(AQ6,4)=\"MBAR\",\"MBAR\",\"BAR\"))","v":"BAR"},{"$f":"+IF(AS6=\"BAR\",AR6,AR6/1000)","v":0},{"$f":"VLOOKUP(AT6,$J$19:$L$24,3)","v":{"$error":"#DIV/0!"}},null,"GN MPA",7402200000,"1070x770x400",4,"2+2",2,2,{"$f":"+BC6*BB6","v":4},{"$f":"(BB6*BC6)-AZ6","v":0}]
["G-16","G-16","25 m3/h","0,5 bar","MxM 2\"","0,16 m3/h",4,null,"MATERIAL","COBRE",null,null,"35 mm","90 mm","32 mm","28 mm",null,"G-25",null,null,"GLP MPB04","GLP MPB","Batería con 4 verticales y 1 horizontales. Total: 4 contadores.",4,1,4,1800,500,270,450,500,900,770,270,null,"900x770x270",null,null,null,null,null,null,null,null,null,null,null,null,"GN MPA",7412210000,"1070x1540x400",5,"2+2+1",2,3,6,1]
["G-25","G-25","40 m3/h","0,5 bar","MxM 2 1/2\"","0,25 m3/h",5,null,null,"ACERO",null,null,"42 mm","110 mm","40 mm","35 mm",null,"G-40",null,null,"GLP MPB04","GLP MPB","Batería con 1 verticales y 4 horizontales. Total: 4 contadores.",1,4,4,600,1300,270,600,325,900,770,270,null,"900x770x270",null,null,null,null,null,"salida:",{"$f":"IF(BATERÍAS!H4=\"\",0,BATERÍAS!H4)","v":0},{"$f":"VALUE(TRIM(SUBSTITUTE(SUBSTITUTE(UPPER(AQ8),\"MBAR\",\"\"),\"BAR\",\"\")))","v":0},{"$f":"+IF(RIGHT(AQ8,4)=\"mbar\",\"MBAR\",IF(RIGHT(AQ8,4)=\"MBAR\",\"MBAR\",\"BAR\"))","v":"BAR"},{"$f":"+IF(AS8=\"BAR\",AR8,AR8/1000)","v":0},{"$f":"VLOOKUP(AT8,$J$19:$L$24,3)","v":{"$error":"#DIV/0!"}},null,"GN MPA",7403200000,"1500x770x400",5,"3+2",3,2,6,1]
["G-40","G-40","65 m3/h","0,5 bar","DN 65","0,4 m3/h",6,null,null,"PE",null,null,"54 mm",null,"50 mm","42 mm",null,"G-65",null,null,"GLP MPB04","GLP MPB","Batería con 2 verticales y 2 horizontales. Total: 4 contadores.",2,2,4,1030,700,270,515,350,900,770,270,null,"900x770x270",null,"TIPO DE GAS",null,null,null,null,null,null,null,null,null,null,"GN MPA",7412220000,"1070x1540x400",6,"2+2+2",2,3,6,0]
["G-65","G-65","100 m3/h","0,5 bar","DN 80","0,65 m3/h",7,null,null,"ACERO_INOX",null,null,null,null,"65 mm",null,null,"G-100",null,null,"GLP MPB05","GLP MPB","Batería con 5 verticales y 1 horizontales. Total: 5 contadores.",5,1,5,2185,500,270,437,500,1350,770,270,null,"1350x770x270",null,null,"GLP MPA",null,null,null,null,null,null,null,null,null,"GN MPA",7403300000,"1500x770x400",6,"3+3",3,2,6,0]
["G-100","G-100","160 m3/h","0,5 bar","DN 100","1 m3/h",8,null,null,null,null,null,null,null,"80 mm",null,null,"G-160",null,null,"GLP MPB05","GLP MPB","Batería con 1 verticales y 5 horizontales. Total: 5 contadores.",1,5,5,600,1600,270,600,320,900,1540,270,null,"900x1540x270",null,null,"GN MPA",null,null,null,null,null,null,null,null,null,"GN MPA",7404200000,"1930x770x400",6,"4+2",4,2,8,2]
["G-160","G-160","250 m3/h","?","DN 150","1,6 m3/h",9,null,null,null,null,null,null,null,"100 mm",null,null,null,null,null,"GLP MPB06","GLP MPB","Batería con 3 verticales y 2 horizontales. Total: 6 contadores.",3,2,6,1415,700,270,471.66666666666669,350,1350,770,270,null,"1350x770x270",null,null,"GN BP",null,null,null,null,null,null,null,null,null,"GN MPA",7412221000,"1070x1540x400",7,"2+2+2+1",2,4,8,1]
[null,null,null,null,null,null,null,null,"CONEXIÓN","PARA SOLDAR",null,null,null,null,"125 mm",null,null,null,null,null,"GLP MPB06","GLP MPB","Batería con 2 verticales y 3 horizontales. Total: 6 contadores.",2,3,6,1030,1000,270,515,333.33333333333331,900,1540,270,null,"900x1540x270",null,null,null,null,null,null,null,null,null,null,null,null,"GN MPA",7404300000,"1930x770x400",7,"4+3",4,2,8,1]
[null,null,null,null,null,null,null,null,null,"TUERCA / ROSCA",null,null,null,null,"150 mm",null,null,null,null,null,"GLP MPB08","GLP MPB","Batería con 4 verticales y 2 horizontales. Total: 8 contadores.",4,2,8,1800,700,270,450,350,1700,770,270,null,"1700x770x270",null,null,null,null,null,null,null,null,null,null,null,null,"GN MPA",7403310000,"1500x1050x400",7,"3+3+1",3,3,9,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GLP MPB08","GLP MPB","Batería con 2 verticales y 4 horizontales. Total: 8 contadores.",2,4,8,1030,1300,270,515,325,900,1540,270,null,"900x1540x270",null,null,null,null,null,null,null,null,null,null,null,null,"GN MPA",7412222000,"1070x1540x400",8,"2+2+2+2",2,4,8,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GLP MPB09","GLP MPB","Batería con 3 verticales y 3 horizontales. Total: 9 contadores.",3,3,9,1415,1000,270,471.66666666666669,333.33333333333331,1350,1540,270,null,"1350x1540x270",null,null,null,null,null,null,null,null,null,null,null,null,"GN MPA",7404400000,"1930x770x400",8,"4+4",4,2,8,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GLP MPB10","GLP MPB","Batería con 5 verticales y 2 horizontales. Total: 10 contadores.",5,2,10,2185,700,270,437,350,1700,1050,270,null,"1700x1050x270",null,null,null,null,null,null,null,null,null,null,null,null,"GN MPA",7403320000,"1500x1050x400",8,"3+3+2",3,3,9,1]
[null,null,null,null,null,null,null,null,null,"from (bar)","to (bar)",null,null,null,"Medidas entre centros de contador",null,null,null,null,null,"GLP MPB10","GLP MPB","Batería con 2 verticales y 5 horizontales. Total: 10 contadores.",2,5,10,1030,1600,270,515,320,1350,1540,270,null,"1350x1540x270",null,null,null,null,null,null,null,null,null,null,null,null,"GN MPA",7403330000,"1500x1050x400",9,"3+3+3",3,3,9,0]
[null,null,null,null,null,null,null,null,"N/A",-1,0,{"$f":"0/0","v":{"$error":"#DIV/0!"}},null,null,"G-16","G-40","G-65","G-100",null,null,"GLP MPB12","GLP MPB","Batería con 4 verticales y 3 horizontales. Total: 12 contadores.",4,3,12,1800,1000,270,450,333.33333333333331,1700,1050,270,null,"1700x1050x270",null,null,null,null,null,null,null,null,null,null,null,null,"GN MPA",7404410000,"1930x1050x400",9,"4+4+1",4,3,12,3]
["Convertidor de presión:",null,null,null,null,null,null,null,"BP",9.9999999999999995E-8,0.05,"BP",null,null,"250 mm","430 mm","500 mm","675 mm",null,null,"GLP MPB12","GLP MPB","Batería con 3 verticales y 4 horizontales. Total: 12 contadores.",3,4,12,1415,1300,270,471.66666666666669,325,1350,1540,270,null,"1350x1540x270",null,null,null,null,null,null,null,null,null,null,null,null,"GN MPA",7413322000,"1500x1540x400",10,"3+3+2+2",3,4,12,2]
[null,null,null,null,null,null,null,null,"MPA",5.0000009999999998E-2,0.4,"MPA",null,null,"280 mm","510 mm","640 mm","710 mm",null,null,"GLP MPB14","GLP MPB","Batería con 2 verticales y 7 horizontales. Total: 14 contadores.",2,7,14,1030,2100,270,515,300,1700,1540,270,null,"1700x1540x270",null,null,null,null,null,null,null,null,null,null,null,null,"GN MPA",7404420000,"1930x1050x400",10,"4+4+2",4,3,12,2]
[null,"AS IS","number","units","BAR","EQUIV",null,null,"MPB",0.40000001000000002,4,"MPB",null,null,null,null,null,null,null,null,"GLP MPB15","GLP MPB","Batería con 5 verticales y 3 horizontales. Total: 15 contadores.",5,3,15,2185,1000,270,437,333.33333333333331,1700,1540,270,null,"1700x1540x270",null,null,null,null,null,null,null,null,null,null,null,null,"GN MPA",7404330000,"1930x1050x400",10,"4+3+3",4,3,12,2]
["entrada:",{"$f":"ARMARIOS!C4","v":0},{"$f":"VALUE(TRIM(SUBSTITUTE(SUBSTITUTE(UPPER(B23),\"MBAR\",\"\"),\"BAR\",\"\")))","v":0},{"$f":"+IF(RIGHT(B23,4)=\"mbar\",\"MBAR\",IF(RIGHT(B23,4)=\"MBAR\",\"MBAR\",\"BAR\"))","v":"BAR"},{"$f":"+IF(D23=\"BAR\",C23,C23/1000)","v":0},{"$f":"VLOOKUP(E23,$J$19:$L$24,3)","v":{"$error":"#DIV/0!"}},null,null,"APA",4.0000001000000003,16,"APA",null,null,null,null,null,null,null,null,"GLP MPB15","GLP MPB","Batería con 3 verticales y 5 horizontales. Total: 15 contadores.",3,5,15,1415,1600,270,471.66666666666669,320,1700,1540,270,null,"1700x1540x270",null,null,null,null,null,null,null,null,null,null,null,null,"GN MPA",7413332000,"1500x1540x400",11,"3+3+3+2",3,4,12,1]
[null,null,null,null,null,null,null,null,"APB",16.000000010000001,1000,"APB",null,null,null,null,null,null,null,null,"GLP MPB16","GLP MPB","Batería con 4 verticales y 4 horizontales. Total: 16 contadores.",4,4,16,1800,1300,270,450,325,1700,1540,270,null,"1700x1540x270",null,null,null,null,null,null,null,null,null,null,null,null,"GN MPA",7404430000,"1930x1050x400",11,"4+4+3",4,3,12,1]
["salida:",{"$f":"+ARMARIOS!F4","v":0},{"$f":"VALUE(TRIM(SUBSTITUTE(SUBSTITUTE(UPPER(B25),\"MBAR\",\"\"),\"BAR\",\"\")))","v":0},{"$f":"+IF(RIGHT(B25,4)=\"mbar\",\"MBAR\",IF(RIGHT(B25,4)=\"MBAR\",\"MBAR\",\"BAR\"))","v":"BAR"},{"$f":"+IF(D25=\"BAR\",C25,C25/1000)","v":0},{"$f":"VLOOKUP(E25,$J$19:$L$24,3)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GLP MPB16","GLP MPB","Batería con 2 verticales y 8 horizontales. Total: 16 contadores.",2,8,16,1030,2450,270,515,306.25,1700,1540,270,null,"1700x1540x270",null,null,null,null,null,null,null,null,null,null,null,null,"GN MPA",7413333000,"1500x1540x400",12,"3+3+3+3",3,4,12,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GLP MPB18","GLP MPB","Batería con 3 verticales y 6 horizontales. Total: 18 contadores.",3,6,18,1415,1900,270,471.66666666666669,316.66666666666669,1700,1540,270,null,"1700x1820x270",null,null,null,null,null,null,null,null,null,null,null,null,"GN MPA",7404440000,"1930x1050x400",12,"4+4+4",4,3,12,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GLP MPB20","GLP MPB","Batería con 5 verticales y 4 horizontales. Total: 20 contadores.",5,4,20,2185,1300,270,437,325,1700,1820,270,null,"1700x1820x270",null,null,null,null,null,null,null,null,null,null,null,null,"GN MPA",7414441000,"1930x1540x400",13,"4+4+4+1",4,4,16,3]
[null,null,null,null,null,"LLAVES","De palanca",null,"ARMARIO",null,null,"REARME","Manual",null,null,null,null,null,null,null,"GLP MPB20","GLP MPB","Batería con 4 verticales y 5 horizontales. Total: 20 contadores.",4,5,20,1800,1600,270,450,320,1700,1820,270,null,"1700x1820x270",null,null,null,null,null,null,null,null,null,null,null,null,"GN MPA",7414333000,"1930x1540x400",13,"4+3+3+3",4,4,16,3]
[null,null,null,null,null,null,"De mariposa",null,null,"Sin armario",null,null,"Automático",null,null,null,null,null,null,null,"GLP MPB21","GLP MPB","Batería con 3 verticales y 7 horizontales. Total: 21 contadores.",3,7,21,1415,2100,270,471.66666666666669,300,1700,2100,270,null,"1700x2100x270",null,null,null,null,null,null,null,null,null,null,null,null,"GN MPA",7414442000,"1930x1540x400",14,"4+4+4+2",4,4,16,2]
["REGULADOR",null,null,null,null,null,"De bola",null,null,"Con armario con mirilla (G-4)",null,null,null,null,null,null,null,null,null,null,"GLP MPB24","GLP MPB","Batería con 4 verticales y 6 horizontales. Total: 24 contadores.",4,6,24,1800,1900,270,450,316.66666666666669,1700,2100,270,null,"1700x2100x270",null,null,null,null,null,null,null,null,null,null,null,null,"GN MPA",7414443000,"1930x1540x400",15,"4+4+4+3",4,4,16,1]
[null,"Regulador con VIS MIN",null,null,null,null,null,null,null,"Con armario sin mirilla",null,null,null,null,null,null,null,null,null,null,"GLP MPB24","GLP MPB","Batería con 3 verticales y 8 horizontales. Total: 24 contadores.",3,8,24,1415,2450,270,471.66666666666669,306.25,1700,2100,270,null,"1700x2100x270",null,null,null,null,null,null,null,null,null,null,null,null,"GN MPA",7414444000,"1930x1540x400",16,"4+4+4+4",4,4,16,0]
[null,"Regulador con VIS MAX",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GLP MPB25","GLP MPB","Batería con 5 verticales y 5 horizontales. Total: 25 contadores.",5,5,25,2185,1600,270,437,320,null,null,270,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GN MPA",7414444100,"1930x1820x400",17,"4+4+4+4+1",4,5,20,3]
[null,"Regulador con VIS MIN & MAX",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GLP MPB28","GLP MPB","Batería con 4 verticales y 7 horizontales. Total: 28 contadores.",4,7,28,1800,2100,270,450,300,null,null,270,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GN MPA",7414444200,"1930x1820x400",18,"4+4+4+4+2",4,5,20,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GLP MPB30","GLP MPB","Batería con 5 verticales y 6 horizontales. Total: 30 contadores.",5,6,30,2185,1900,270,437,316.66666666666669,null,null,270,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GN MPA",7414444300,"1930x1820x400",19,"4+4+4+4+3",4,5,20,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+V35&TEXT(Z35,\"00\")","v":"GN BP02"},"GN BP",{"$f":"\"Batería con \"&X35&\" verticales y \"&Y35&\" horizontales. Total: \"&Z35&\" contadores.\"","v":"Batería con 2 verticales y 1 horizontales. Total: 2 contadores."},2,1,{"$f":"+Y35*X35","v":2},1030,500,380,{"$f":"+AA35/X35","v":515},{"$f":"+AB35/Y35","v":500},null,null,400,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GN MPA",7414444400,"1930x1820x400",20,"4+4+4+4+4",4,5,20,0]
[null,null,null,null,null,null,null,null,"Tomas Antes del Contador",null,null,null,null,"Tomas Antes de SALIDA",null,null,null,null,null,null,"GN BP02","GN BP","Batería con 1 verticales y 2 horizontales. Total: 2 contadores.",1,2,2,600,700,380,600,350,null,null,400,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GN MPA",7414444410,"1930x2100x400",21,"4+4+4+4+4+1",4,6,24,3]
[null,null,null,null,null,null,null,null,null,"Toma de presión Peterson",null,null,null,null,"Toma de presión débil calibre",null,null,null,null,null,"GN BP03","GN BP","Batería con 3 verticales y 1 horizontales. Total: 3 contadores.",3,1,3,1415,500,380,471.66666666666669,500,1070,770,400,null,"1070x770x400",null,null,null,null,null,null,null,null,null,null,null,null,"GN MPA",7414444420,"1930x2100x400",22,"4+4+4+4+4+2",4,6,24,2]
["Convertidor de CAUDAL:",null,null,null,null,null,null,null,null,"Válvula de 3 vías con manómetro",null,null,null,null,"Toma de presión Peterson",null,null,null,null,null,"GN BP03","GN BP","Batería con 1 verticales y 3 horizontales. Total: 3 contadores.",1,3,3,600,1000,380,600,333.33333333333331,1070,770,400,null,"1070x770x400",null,null,null,null,null,null,null,null,null,null,null,null,"GN MPA",7414444430,"1930x2100x400",23,"4+4+4+4+4+3",4,6,24,1]
[null,null,null,null,null,null,null,null,null,"Válvula de 3 vías enchufe rápido con manómetro",null,null,null,null,"Válvula con mínima",null,null,null,null,null,"GN BP04","GN BP","Batería con 4 verticales y 1 horizontales. Total: 4 contadores.",4,1,4,1800,500,380,450,500,1070,770,400,null,"1070x770x400",null,null,null,null,null,null,null,null,null,null,null,null,"GN MPA",7414444440,"1930x2100x400",24,"4+4+4+4+4+4",4,6,24,0]
[null,"AS IS","number",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GN BP04","GN BP","Batería con 1 verticales y 4 horizontales. Total: 4 contadores.",1,4,4,600,1300,380,600,325,1070,770,400,null,"1070x770x400",null,null,null,null,null,null,null,null,null,null,null,null,"TIPO","Martigrap code","Size","total","layout","vertical","horizontal","Real space","removed"]
["valor introducido",{"$f":"ARMARIOS!J4","v":0},{"$f":"VALUE(TRIM(SUBSTITUTE(SUBSTITUTE(UPPER(B41),\"M3/H\",\"\"),\"KG/H\",\"\")))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GN BP04","GN BP","Batería con 2 verticales y 2 horizontales. Total: 4 contadores.",2,2,4,1030,700,380,515,350,1070,770,400,null,"1070x770x400",null,null,null,null,null,null,null,null,null,null,null,null,"GN BP",7602100000,"1070x770x400",3,"2+1",2,2,{"$f":"+BC41*BB41","v":4},{"$f":"(BB41*BC41)-AZ41","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GN BP05","GN BP","Batería con 5 verticales y 1 horizontales. Total: 5 contadores.",5,1,5,2185,500,380,437,500,1500,770,400,null,"1500x770x400",null,null,null,null,null,null,null,null,null,null,null,null,"GN BP",7602200000,"1070x770x400",4,"2+2",2,2,{"$f":"+BC42*BB42","v":4},{"$f":"(BB42*BC42)-AZ42","v":0}]
["max real",{"$f":"IF(ARMARIOS!N4=\"-\",0,ARMARIOS!N4)","v":0},{"$f":"IF(ISERROR(B43),C41,VALUE(TRIM(SUBSTITUTE(SUBSTITUTE(UPPER(B43),\"M3/H\",\"\"),\"KG/H\",\"\"))))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GN BP05","GN BP","Batería con 1 verticales y 5 horizontales. Total: 5 contadores.",1,5,5,600,1600,380,600,320,1070,1540,400,null,"1070x1540x400",null,null,null,null,null,null,null,null,null,null,null,null,"GN BP",7603200000,"1500x770x400",5,"3+2",3,2,6,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GN BP06","GN BP","Batería con 3 verticales y 2 horizontales. Total: 6 contadores.",3,2,6,1415,700,380,471.66666666666669,350,1930,770,400,null,"1500x770x400",null,null,null,null,null,null,null,null,null,null,null,null,"GN BP",7603300000,"1500x770x400",6,"3+3",3,2,6,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GN BP06","GN BP","Batería con 2 verticales y 3 horizontales. Total: 6 contadores.",2,3,6,1030,1000,380,515,333.33333333333331,1070,1540,400,null,"1070x1540x400",null,null,null,null,null,null,null,null,null,null,null,null,"GN BP",7604200000,"1930x770x400",6,"4+2",4,2,8,2]
[null,null,"DO NOT MOVE - in macro hard coded",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GN BP08","GN BP","Batería con 4 verticales y 2 horizontales. Total: 8 contadores.",4,2,8,1800,700,380,450,350,1930,770,400,null,"1930x770x400",null,null,null,null,null,null,null,null,null,null,null,null,"GN BP",7604300000,"1930x770x400",7,"4+3",4,2,8,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GN BP08","GN BP","Batería con 2 verticales y 4 horizontales. Total: 8 contadores.",2,4,8,1030,1300,380,515,325,1070,1540,400,null,"1070x1540x400",null,null,null,null,null,null,null,null,null,null,null,null,"GN BP",7603310000,"1500x1050x400",7,"3+3+1",3,3,9,2]
["Dimensiones de armarios",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GN BP09","GN BP","Batería con 3 verticales y 3 horizontales. Total: 9 contadores.",3,3,9,1415,1000,380,471.66666666666669,333.33333333333331,1500,1050,400,null,"1500x1050x400",null,null,null,null,null,null,null,null,null,null,null,null,"GN BP",7604400000,"1930x770x400",8,"4+4",4,2,8,0]
["Buscable","Tipo","Material","Mirilla","MODELO","Contador","Medida","Número","Alto","Ancho","Fondo","Presion Salida","Regulador","Caudal",null,null,null,null,null,null,"GN BP10","GN BP","Batería con 5 verticales y 2 horizontales. Total: 10 contadores.",5,2,10,2185,700,380,437,350,1930,1050,400,null,"1930x1050x400",null,null,null,null,null,null,null,null,null,null,null,null,"GN BP",7603320000,"1500x1050x400",8,"3+3+2",3,3,9,1]
[{"$f":"+B50&\" \"&F50&G50&L50&M50&N50","v":"GLP 1 x G-40,1510"},"GLP","Poliéster","NO",1,"1 x G-4",null,1,520,536,230,0.151,null,0,null,null,null,null,null,null,"GN BP10","GN BP","Batería con 2 verticales y 5 horizontales. Total: 10 contadores.",2,5,10,1030,1600,380,515,320,1500,1540,400,null,"1500x1540x400",null,null,null,null,null,null,null,null,null,null,null,null,"GN BP",7603330000,"1500x1050x400",9,"3+3+3",3,3,9,0]
[{"$f":"+B51&\" \"&F51&G51&L51&M51&N51","v":"GLP 1 x G-40,150"},"GLP","Poliéster","SI",2,"1 x G-4",null,1,485,350,220,0.15,null,0,null,null,null,null,null,null,"GN BP12","GN BP","Batería con 4 verticales y 3 horizontales. Total: 12 contadores.",4,3,12,1800,1000,380,450,333.33333333333331,1930,1050,400,null,"1930x1050x400",null,null,null,null,null,null,null,null,null,null,null,null,"GN BP",7604410000,"1930x1050x400",9,"4+4+1",4,3,12,3]
[{"$f":"+B52&\" \"&F52&G52&L52&M52&N52","v":"GLP 2 x G-400"},"GLP","Poliéster","SI",3,"2 x G-4",null,2,520,700,230,0,null,0,null,null,null,null,null,null,"GN BP12","GN BP","Batería con 3 verticales y 4 horizontales. Total: 12 contadores.",3,4,12,1415,1300,380,471.66666666666669,325,1500,1540,400,null,"1500x1540x400",null,null,null,null,null,null,null,null,null,null,null,null,"GN BP",7604420000,"1930x1050x400",10,"4+4+2",4,3,12,2]
["GLP G-600","GLP","Poliéster","NO",4,"G-6",null,1,520,700,230,0,null,0,null,null,null,null,null,null,"GN BP14","GN BP","Batería con 2 verticales y 7 horizontales. Total: 14 contadores.",2,7,14,1030,2100,380,515,300,1930,1540,400,null,"1930x1540x400",null,null,null,null,null,null,null,null,null,null,null,null,"GN BP",7604330000,"1930x1050x400",10,"4+3+3",4,3,12,2]
["GLP Regulación sólo050","GLP","Poliéster","NO",5,"Regulación sólo",null,0,485,350,195,0,null,50,null,null,null,null,null,null,"GN BP15","GN BP","Batería con 5 verticales y 3 horizontales. Total: 15 contadores.",5,3,15,2185,1000,380,437,333.33333333333331,1930,1540,400,null,"1930x1540x400",null,null,null,null,null,null,null,null,null,null,null,null,"GN BP",7604430000,"1930x1050x400",11,"4+4+3",4,3,12,1]
["GLP Regulación sólo051","GLP","Poliéster","NO",6,"Regulación sólo",null,0,530,530,230,0,null,51,null,null,null,null,null,null,"GN BP15","GN BP","Batería con 3 verticales y 5 horizontales. Total: 15 contadores.",3,5,15,1415,1600,380,471.66666666666669,320,1930,1540,400,null,"1930x1540x400",null,null,null,null,null,null,null,null,null,null,null,null,"GN BP",7604440000,"1930x1050x400",12,"4+4+4",4,3,12,0]
["GN 1 x G-40,022Regulador con VIS MIN0","GN","Poliéster","SI",7,"1 x G-4",null,1,485,350,220,2.1999999999999999E-2,"Regulador con VIS MIN",0,"AMBAS COSAS si no va en el grande",null,null,null,null,null,"GN BP16","GN BP","Batería con 4 verticales y 4 horizontales. Total: 16 contadores.",4,4,16,1800,1300,380,450,325,1930,1540,400,null,"1930x1540x400",null,null,null,null,null,null,null,null,null,null,null,null,"GN BP",7612210000,"1070x1540x400",5,"2+2+1",2,3,6,1]
["GN 1 x G-40,0220","GN","Poliéster","NO",8,"1 x G-4",null,1,530,530,230,2.1999999999999999E-2,null,0,null,null,null,null,null,null,"GN BP16","GN BP","Batería con 2 verticales y 8 horizontales. Total: 16 contadores.",2,8,16,1030,2450,380,515,306.25,1930,1540,400,null,"1930x1540x400",null,null,null,null,null,null,null,null,null,null,null,null,"GN BP",7612220000,"1070x1540x400",6,"2+2+2",2,3,6,0]
[{"$f":"+B58&\" \"&F58&G58&L58&M58&N58","v":"GN 1 x G-40,0230"},"GN","Poliéster","NO",8,"1 x G-4",null,1,530,530,230,2.3E-2,null,0,null,null,null,null,null,null,"GN BP18","GN BP","Batería con 3 verticales y 6 horizontales. Total: 18 contadores.",3,6,18,1415,1900,380,471.66666666666669,316.66666666666669,1930,1820,400,null,"1930x1820x400",null,null,null,null,null,null,null,null,null,null,null,null,"GN BP",7612221000,"1070x1540x400",7,"2+2+2+1",2,4,8,1]
["GN 2 x G-400","GN","Poliéster","SI",9,"2 x G-4",null,2,530,700,230,0,null,0,null,null,null,null,null,null,"GN BP20","GN BP","Batería con 5 verticales y 4 horizontales. Total: 20 contadores.",5,4,20,2185,1300,380,437,325,1930,1820,400,null,"1930x1820x400",null,null,null,null,null,null,null,null,null,null,null,null,"GN BP",7612222000,"1070x1540x400",8,"2+2+2+2",2,4,8,0]
["GN G-100675 mm00","GN","Poliéster","NO",10,"G-100","675 mm",1,1500,1300,700,0,null,0,null,null,null,null,null,null,"GN BP20","GN BP","Batería con 4 verticales y 5 horizontales. Total: 20 contadores.",4,5,20,1800,1600,380,450,320,1930,1820,400,null,"1930x1820x400",null,null,null,null,null,null,null,null,null,null,null,null,"GN BP",7613322000,"1500x1540x400",10,"3+3+2+2",3,4,12,2]
["GN G-100710 mm00","GN","Poliéster","NO",11,"G-100","710 mm",1,1500,1300,700,0,null,0,null,null,null,null,null,null,"GN BP21","GN BP","Batería con 3 verticales y 7 horizontales. Total: 21 contadores.",3,7,21,1415,2100,380,471.66666666666669,300,1930,2100,400,null,"1930x2100x400",null,null,null,null,null,null,null,null,null,null,null,null,"GN BP",7613332000,"1500x1540x400",11,"3+3+3+2",3,4,12,1]
["GN G-16250 mm00","GN","Poliéster","NO",12,"G-16","250 mm",1,750,500,300,0,null,0,null,null,null,null,null,null,"GN BP24","GN BP","Batería con 4 verticales y 6 horizontales. Total: 24 contadores.",4,6,24,1800,1900,380,450,316.66666666666669,1930,2100,400,null,"1930x2100x400",null,null,null,null,null,null,null,null,null,null,null,null,"GN BP",7613333000,"1500x1540x400",12,"3+3+3+3",3,4,12,0]
["GN G-16280 mm00","GN","Poliéster","NO",13,"G-16","280 mm",1,750,750,300,0,null,0,null,null,null,null,null,null,"GN BP24","GN BP","Batería con 3 verticales y 8 horizontales. Total: 24 contadores.",3,8,24,1415,2450,380,471.66666666666669,306.25,1930,2100,400,null,"1930x2100x400",null,null,null,null,null,null,null,null,null,null,null,null,"GN BP",7614441000,"1930x1540x400",13,"4+4+4+1",4,4,16,3]
["GN G-2500","GN","Poliéster","NO",14,"G-25",null,1,750,750,300,0,null,0,null,null,null,null,null,null,"GN BP25","GN BP","Batería con 5 verticales y 5 horizontales. Total: 25 contadores.",5,5,25,2185,1600,380,437,320,null,null,400,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GN BP",7614333000,"1930x1540x400",13,"4+3+3+3",4,4,16,3]
["GN G-40430 mm00","GN","Poliéster","NO",15,"G-40","430 mm",1,1400,1000,450,0,null,0,null,null,null,null,null,null,"GN BP28","GN BP","Batería con 4 verticales y 7 horizontales. Total: 28 contadores.",4,7,28,1800,2100,380,450,300,null,null,400,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GN BP",7614442000,"1930x1540x400",14,"4+4+4+2",4,4,16,2]
["GN G-40510 mm00","GN","Poliéster","NO",16,"G-40","510 mm",1,1400,1000,450,0,null,0,null,null,null,null,null,null,"GN BP30","GN BP","Batería con 5 verticales y 6 horizontales. Total: 30 contadores.",5,6,30,2185,1900,380,437,316.66666666666669,null,null,400,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GN BP",7614443000,"1930x1540x400",15,"4+4+4+3",4,4,16,1]
["GN G-65500 mm00","GN","Poliéster","NO",17,"G-65","500 mm",1,1400,1400,600,0,null,0,null,null,null,null,null,null,{"$f":"+V67&TEXT(Z67,\"00\")","v":"GN MPA02"},"GN MPA",{"$f":"\"Batería con \"&X67&\" verticales y \"&Y67&\" horizontales. Total: \"&Z67&\" contadores.\"","v":"Batería con 2 verticales y 1 horizontales. Total: 2 contadores."},2,1,{"$f":"+Y67*X67","v":2},1045,500,380,{"$f":"+AA67/X67","v":522.5},{"$f":"+AB67/Y67","v":500},1070,770,400,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GN BP",7614444000,"1930x1540x400",16,"4+4+4+4",4,4,16,0]
["GN G-65640 mm00","GN","Poliéster","NO",18,"G-65","640 mm",1,1400,1400,600,0,null,0,null,null,null,null,null,null,"GN MPA02","GN MPA","Batería con 1 verticales y 2 horizontales. Total: 2 contadores.",1,2,2,600,700,380,600,350,1070,770,400,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GN BP",7614444100,"1930x1820x400",17,"4+4+4+4+1",4,5,20,3]
["GN G-600","GN","Poliéster","NO",19,"G-6",null,1,530,530,230,0,null,0,null,null,null,null,null,null,"GN MPA03","GN MPA","Batería con 3 verticales y 1 horizontales. Total: 3 contadores.",3,1,3,1475,500,380,491.66666666666669,500,1070,770,400,null,"1070x770x400",null,null,null,null,null,null,null,null,null,null,null,null,"GN BP",7614444200,"1930x1820x400",18,"4+4+4+4+2",4,5,20,2]
["GN Regulación sólo025","GN","Poliéster","NO",20,"Regulación sólo",null,0,520,210,210,0,null,25,null,null,null,null,null,null,"GN MPA03","GN MPA","Batería con 1 verticales y 3 horizontales. Total: 3 contadores.",1,3,3,600,1000,380,600,333.33333333333331,1070,770,400,null,"1070x770x400",null,null,null,null,null,null,null,null,null,null,null,null,"GN BP",7614444300,"1930x1820x400",19,"4+4+4+4+3",4,5,20,1]
["GN Regulación sólo050","GN","Poliéster","NO",21,"Regulación sólo",null,0,485,350,195,0,null,50,null,null,null,null,null,null,"GN MPA04","GN MPA","Batería con 4 verticales y 1 horizontales. Total: 4 contadores.",4,1,4,1905,500,380,476.25,500,1930,770,400,null,"1930x770x400",null,null,null,null,null,null,null,null,null,null,null,null,"GN BP",7614444400,"1930x1820x400",20,"4+4+4+4+4",4,5,20,0]
["GN Regulación sólo051","GN","Poliéster","NO",22,"Regulación sólo",null,0,530,530,230,0,null,51,null,null,null,null,null,null,"GN MPA04","GN MPA","Batería con 1 verticales y 4 horizontales. Total: 4 contadores.",1,4,4,600,1300,380,600,325,1070,770,400,null,"1070x770x400",null,null,null,null,null,null,null,null,null,null,null,null,"GN BP",7614444410,"1930x2100x400",21,"4+4+4+4+4+1",4,6,24,3]
["GLP G-100675 mm00","GLP","Poliéster","NO",23,"G-100","675 mm",1,1500,1300,700,0,null,0,null,null,null,null,null,null,"GN MPA04","GN MPA","Batería con 2 verticales y 2 horizontales. Total: 4 contadores.",2,2,4,1045,700,380,522.5,350,1070,770,400,null,"1070x770x400",null,null,null,null,null,null,null,null,null,null,null,null,"GN BP",7614444420,"1930x2100x400",22,"4+4+4+4+4+2",4,6,24,2]
["GLP G-100710 mm00","GLP","Poliéster","NO",24,"G-100","710 mm",1,1500,1300,700,0,null,0,null,null,null,null,null,null,"GN MPA05","GN MPA","Batería con 5 verticales y 1 horizontales. Total: 5 contadores.",5,1,5,2335,500,380,467,500,1930,770,400,null,"1930x770x400",null,null,null,null,null,null,null,null,null,null,null,null,"GN BP",7614444430,"1930x2100x400",23,"4+4+4+4+4+3",4,6,24,1]
["GLP G-16250 mm00","GLP","Poliéster","NO",25,"G-16","250 mm",1,750,500,300,0,null,0,null,null,null,null,null,null,"GN MPA05","GN MPA","Batería con 1 verticales y 5 horizontales. Total: 5 contadores.",1,5,5,600,1600,380,600,320,1070,1540,400,null,"1070x1540x400",null,null,null,null,null,null,null,null,null,null,null,null,"GN BP",7614444440,"1930x2100x400",24,"4+4+4+4+4+4",4,6,24,0]
["GLP G-16280 mm00","GLP","Poliéster","NO",26,"G-16","280 mm",1,750,750,300,0,null,0,null,null,null,null,null,null,"GN MPA06","GN MPA","Batería con 3 verticales y 2 horizontales. Total: 6 contadores.",3,2,6,1475,700,380,491.66666666666669,350,1500,770,400,null,"1500x770x400",null,null,null,null,null,null,null,null,null,null,null,null,"GLP MPB",5602100000,"900x770x270",3,"2+1",2,2,{"$f":"+BC76*BB76","v":4},{"$f":"(BB76*BC76)-AZ76","v":1}]
["GLP G-2500","GLP","Poliéster","NO",27,"G-25",null,1,750,750,300,0,null,0,null,null,null,null,null,null,"GN MPA06","GN MPA","Batería con 2 verticales y 3 horizontales. Total: 6 contadores.",2,3,6,1045,1000,380,522.5,333.33333333333331,1070,1540,400,null,"1070x1540x400",null,null,null,null,null,null,null,null,null,null,null,null,"GLP MPB",5602200000,"900x770x270",4,"2+2",2,2,4,0]
["GLP G-40430 mm00","GLP","Poliéster","NO",28,"G-40","430 mm",1,1400,1000,450,0,null,0,null,null,null,null,null,null,"GN MPA08","GN MPA","Batería con 4 verticales y 2 horizontales. Total: 8 contadores.",4,2,8,1905,700,380,476.25,350,1930,770,400,null,"1930x770x400",null,null,null,null,null,null,null,null,null,null,null,null,"GLP MPB",5612210000,"900x1540x270",5,"2+2+1",2,3,6,1]
["GLP G-40510 mm00","GLP","Poliéster","NO",29,"G-40","510 mm",1,1400,1000,450,0,null,0,null,null,null,null,null,null,"GN MPA08","GN MPA","Batería con 2 verticales y 4 horizontales. Total: 8 contadores.",2,4,8,1045,1300,380,522.5,325,1070,1540,400,null,"1070x1540x400",null,null,null,null,null,null,null,null,null,null,null,null,"GLP MPB",5603200000,"1350x770x270",5,"3+2",3,2,6,1]
["GLP G-65500 mm00","GLP","Poliéster","NO",30,"G-65","500 mm",1,1400,1400,600,0,null,0,null,null,null,null,null,null,"GN MPA09","GN MPA","Batería con 3 verticales y 3 horizontales. Total: 9 contadores.",3,3,9,1475,1000,380,491.66666666666669,333.33333333333331,1500,1050,400,null,"1500x1050x400",null,null,null,null,null,null,null,null,null,null,null,null,"GLP MPB",5612220000,"900x1540x270",6,"2+2+2",2,3,6,0]
["GLP G-65640 mm00","GLP","Poliéster","NO",31,"G-65","640 mm",1,1400,1400,600,0,null,0,null,null,null,null,null,null,"GN MPA10","GN MPA","Batería con 5 verticales y 2 horizontales. Total: 10 contadores.",5,2,10,2335,700,380,467,350,1930,1050,400,null,"1930x1050x400",null,null,null,null,null,null,null,null,null,null,null,null,"GLP MPB",5603300000,"1350x770x270",6,"3+3",3,2,6,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GN MPA10","GN MPA","Batería con 2 verticales y 5 horizontales. Total: 10 contadores.",2,5,10,1030,1600,380,515,320,1500,1540,400,null,"1500x1540x400",null,null,null,null,null,null,null,null,null,null,null,null,"GLP MPB",5604200000,"1700x770x270",6,"4+2",4,2,8,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GN MPA12","GN MPA","Batería con 4 verticales y 3 horizontales. Total: 12 contadores.",4,3,12,1905,1000,380,476.25,333.33333333333331,1930,1050,400,null,"1930x1050x400",null,null,null,null,null,null,null,null,null,null,null,null,"GLP MPB",5612221000,"900x1540x270",7,"2+2+2+1",2,4,8,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GN MPA12","GN MPA","Batería con 3 verticales y 4 horizontales. Total: 12 contadores.",3,4,12,1475,1300,380,491.66666666666669,325,1500,1540,400,null,"1500x1540x400",null,null,null,null,null,null,null,null,null,null,null,null,"GLP MPB",5604300000,"1700x770x270",7,"4+3",4,2,8,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GN MPA14","GN MPA","Batería con 2 verticales y 7 horizontales. Total: 14 contadores.",2,7,14,1045,2100,380,522.5,300,1930,1540,400,null,"1930x1540x400",null,null,null,null,null,null,null,null,null,null,null,null,"GLP MPB",5612222000,"900x1540x270",8,"2+2+2+2",2,4,8,0]
[null,null,{"$f":"\"DO NOT MOVE - in macro hard coded OR EDIT THE ROW IN MACRO - \" & ROW(B89)","v":"DO NOT MOVE - in macro hard coded OR EDIT THE ROW IN MACRO - 89"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GN MPA15","GN MPA","Batería con 5 verticales y 3 horizontales. Total: 15 contadores.",5,3,15,2335,1000,380,467,333.33333333333331,1930,1540,400,null,"1930x1540x400",null,null,null,null,null,null,null,null,null,null,null,null,"GLP MPB",5604400000,"1700x770x270",8,"4+4",4,2,8,0]
["criteria",null,null,null,"Only relevant 1 x G-4","Only relevant GN 1 x G-4","Only relevant Regulación sólo",null,null,null,null,null,null,null,null,null,null,null,null,null,"GN MPA15","GN MPA","Batería con 3 verticales y 5 horizontales. Total: 15 contadores.",3,5,15,1475,1600,380,491.66666666666669,320,1930,1540,400,null,"1930x1540x400",null,null,null,null,null,null,null,null,null,null,null,null,"GLP MPB",5613310000,"1350x1540x270",7,"3+3+1",3,3,9,2]
[null,"Tipo","Contador","Medida","Presion Salida","Regulador","Caudal",null,"Corresponds to:","MODELO","Alto","Ancho","Fondo",null,null,null,null,null,null,null,"GN MPA16","GN MPA","Batería con 4 verticales y 4 horizontales. Total: 16 contadores.",4,4,16,1905,1300,380,476.25,325,1930,1540,400,null,"1930x1540x400",null,null,null,null,null,null,null,null,null,null,null,null,"GLP MPB",5613320000,"1350x1540x270",8,"3+3+2",3,3,9,1]
[null,{"$f":"ARMARIOS!B4","v":0},{"$f":"ARMARIOS!K4","v":0},{"$f":"IF(ARMARIOS!N5<>0,ARMARIOS!N5,\"\")","v":""},{"$f":"IF(C89=\"1 x G-4\",IF(B89=\"GLP\",IF(E25>=0.151,0.151,0.15),IF(E25>=0.023,0.023,0.022)),0)","v":0},{"$f":"IF(AND(B89=\"GN\",C89=\"1 x G-4\"),IF(E89=0.022,IF(ARMARIOS!D10=\"Regulador con VIS MIN\",\"Regulador con VIS MIN\",\"\"),\"\"),\"\")","v":""},{"$f":"IF(C89=\"Regulación sólo\",IF(ARMARIOS!J4>=51,51,IF(AND(ARMARIOS!J4<=25,B89=\"GN\"),25,50)),0)","v":0},null,null,{"$f":"VLOOKUP(F91,$A$50:$E$81,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"INDEX($I$50:$K$81,J89,1)","v":{"$error":"#N/A"}},{"$f":"INDEX($I$50:$K$81,J89,2)","v":{"$error":"#N/A"}},{"$f":"INDEX($I$50:$K$81,J89,3)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,"GN MPA16","GN MPA","Batería con 2 verticales y 8 horizontales. Total: 16 contadores.",2,8,16,1045,2450,380,522.5,306.25,1930,1540,400,null,"1930x1540x400",null,null,null,null,null,null,null,null,null,null,null,null,"GLP MPB",5613330000,"1350x1540x270",9,"3+3+3",3,3,9,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"+K89&\" x \"&L89&\" x \"&M89","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,"GN MPA18","GN MPA","Batería con 3 verticales y 6 horizontales. Total: 18 contadores.",3,6,18,1475,1900,380,491.66666666666669,316.66666666666669,1930,1820,400,null,"1930x1820x400",null,null,null,null,null,null,null,null,null,null,null,null,"GLP MPB",5604410000,"1700x1050x270",9,"4+4+1",4,3,12,3]
[null,null,null,null,"VALUE TO LOOK UP",{"$f":"+B89&\" \"&C89&D89&E89&F89&G89","v":"0 000"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GN MPA20","GN MPA","Batería con 5 verticales y 4 horizontales. Total: 20 contadores.",5,4,20,2335,1300,380,467,325,1930,1820,400,null,"1930x1820x400",null,null,null,null,null,null,null,null,null,null,null,null,"GLP MPB",5613322000,"1350x1540x270",10,"3+3+2+2",3,4,12,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GN MPA20","GN MPA","Batería con 4 verticales y 5 horizontales. Total: 20 contadores.",4,5,20,1905,1600,380,476.25,320,1930,1820,400,null,"1930x1820x400",null,null,null,null,null,null,null,null,null,null,null,null,"GLP MPB",5604420000,"1700x1050x270",10,"4+4+2",4,3,12,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GN MPA21","GN MPA","Batería con 3 verticales y 7 horizontales. Total: 21 contadores.",3,7,21,1475,2100,380,491.66666666666669,300,1930,2100,400,null,"1930x2100x400",null,null,null,null,null,null,null,null,null,null,null,null,"GLP MPB",5604330000,"1700x1050x270",10,"4+3+3",4,3,12,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GN MPA24","GN MPA","Batería con 4 verticales y 6 horizontales. Total: 24 contadores.",4,6,24,1905,1900,380,476.25,316.66666666666669,1930,2100,400,null,"1930x2100x400",null,null,null,null,null,null,null,null,null,null,null,null,"GLP MPB",5613332000,"1350x1540x270",11,"3+3+3+2",3,4,12,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GN MPA24","GN MPA","Batería con 3 verticales y 8 horizontales. Total: 24 contadores.",3,8,24,1045,2450,380,348.33333333333331,306.25,1930,2100,400,null,"1930x2100x400",null,null,null,null,null,null,null,null,null,null,null,null,"GLP MPB",5604430000,"1700x1050x270",11,"4+4+3",4,3,12,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GN MPA25","GN MPA","Batería con 5 verticales y 5 horizontales. Total: 25 contadores.",5,5,25,2335,1600,380,467,320,null,null,400,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GLP MPB",5613333000,"1350x1540x270",12,"3+3+3+3",3,4,12,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GN MPA28","GN MPA","Batería con 4 verticales y 7 horizontales. Total: 28 contadores.",4,7,28,1905,2100,380,476.25,300,null,null,400,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GLP MPB",5604440000,"1700x1050x270",12,"4+4+4",4,3,12,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GN MPA30","GN MPA","Batería con 5 verticales y 6 horizontales. Total: 30 contadores.",5,6,30,2335,1900,380,467,316.66666666666669,null,null,400,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GLP MPB",5614441000,"1700x1540x270",13,"4+4+4+1",4,4,16,3]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GLP MPB",5614333000,"1700x1540x270",13,"4+3+3+3",4,4,16,3]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GLP MPB",5614442000,"1700x1540x270",14,"4+4+4+2",4,4,16,2]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GLP MPB",5614443000,"1700x1540x270",15,"4+4+4+3",4,4,16,1]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GLP MPB",5614444000,"1700x1540x270",16,"4+4+4+4",4,4,16,0]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GLP MPB",5614444100,"1700x1820x270",17,"4+4+4+4+1",4,5,20,3]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GLP MPB",5614444200,"1700x1820x270",18,"4+4+4+4+2",4,5,20,2]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GLP MPB",5614444300,"1700x1820x270",19,"4+4+4+4+3",4,5,20,1]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GLP MPB",5614444400,"1700x1820x270",20,"4+4+4+4+4",4,5,20,0]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GLP MPB",5614444410,"1700x2100x270",21,"4+4+4+4+4+1",4,6,24,3]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GLP MPB",5614444420,"1700x2100x270",22,"4+4+4+4+4+2",4,6,24,2]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GLP MPB",5614444430,"1700x2100x270",23,"4+4+4+4+4+3",4,6,24,1]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GLP MPB",5614444440,"1700x2100x270",24,"4+4+4+4+4+4",4,6,24,0]

{"sheet":"ARMARIOS","index":2,"n_rows":21,"n_cols":24,"rows_kept":21,"cut":false,"hidden":true,"merged":[[11,1,11,2],[11,3,11,6],[12,1,12,2],[14,1,14,2],[10,1,10,2],[7,3,7,6],[9,3,9,4],[5,9,5,10],[5,1,5,7],[7,1,7,2],[8,1,8,2],[9,1,9,2],[7,9,7,12],[19,9,19,10],[20,1,20,13],[15,1,15,2],[15,3,15,6],[17,4,17,5],[17,9,17,10],[16,1,16,2]]}
[null,"CONFIGURADOR DE ARMARIOS DE REGULACIÓN DE ANCARGAS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(K4=\"\",K4=\"Regulación sólo\"),\"\",VLOOKUP(K4,opciones!A3:G13,7,FALSE))","v":""},"Llaves",null,"Para contador(es)",null,"Tomas en Entrada","Tomas Antes del Contador","Tomas en SALIDA"]
[null,null,null,null,null,null,null,{"$f":"IF(ISERROR(opciones!F23),\"\",opciones!F23)","v":""},{"$f":"IF(H2=\"\",\"\",\">a>\")","v":""},{"$f":"IF(ISERROR(opciones!F25),\"\",opciones!F25)","v":""},{"$f":"IF(opciones!E25>opciones!E23,\"OJO: Presión de Salida > Entrada\",\"\")","v":""},null,null,null,null,null,"GAS",{"$f":"+opciones!G28","v":"De palanca"},null,{"$f":"+opciones!R2","v":"Regulación sólo"},null,{"$f":"+images!I3","v":"Llave"},{"$f":"+opciones!J37","v":"Toma de presión Peterson"},{"$f":"+opciones!O37","v":"Toma de presión débil calibre"}]
[null,"Gas","Presión de entrada (bar/mbar)","Material Entrada","Diámetro Entrada","Presión de salida (bar/mbar)","Material Salida","Diámetro Salida","Conexión de Salida","Caudal\n(m3/h)","PARA Contador(es)","Presión de trabajo","Conexiones Contador","Caudal Max.",null,null,{"$f":"+opciones!J2","v":"GLP"},{"$f":"+opciones!G29","v":"De mariposa"},null,{"$f":"+opciones!R3","v":"1 x G-4"},"rearme",{"$f":"+images!I4","v":"Toma de presión"},{"$f":"+opciones!J38","v":"Válvula de 3 vías con manómetro"},{"$f":"+opciones!O38","v":"Toma de presión Peterson"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(VLOOKUP(K4,opciones!$A$4:$E$13,4,FALSE)),\"-\",VLOOKUP(K4,opciones!$A$4:$E$13,4,FALSE))","v":"-"},{"$f":"IF(ISERROR(VLOOKUP(K4,opciones!$A$4:$E$13,5,FALSE)),\"-\",VLOOKUP(K4,opciones!$A$4:$E$13,5,FALSE))","v":"-"},{"$f":"IF(ISERROR(VLOOKUP(K4,opciones!$A$4:$E$13,3,FALSE)),\"-\",VLOOKUP(K4,opciones!$A$4:$E$13,3,FALSE))","v":"-"},null,null,{"$f":"+opciones!J3","v":"GN"},{"$f":"+opciones!G30","v":"De bola"},null,{"$f":"+opciones!R4","v":"2 x G-4"},{"$f":"+opciones!M28","v":"Manual"},{"$f":"+images!I5","v":"Toma en la tubería de entrada y después llave"},{"$f":"+opciones!J39","v":"Válvula de 3 vías enchufe rápido con manómetro"},{"$f":"+opciones!O39","v":"Válvula con mínima"}]
[null,null,null,{"$f":"IF(D4=\"PE\",\"Salvo indicaciones al contrario, SDR 11\",\"\")","v":""},null,null,{"$f":"IF(G4=\"PE\",\"Salvo indicaciones al contrario, SDR 11\",\"\")","v":""},null,null,{"$f":"IF(opciones!C41>opciones!C43,\"OJO: Caudal Máx. del contador es \" & N4,\"\")","v":""},null,null,{"$f":"IF(OR(K4=T6,K4=T8,K4=T9,K4=T10),\"Indicar medidas \"& K4,\"\")","v":""},null,null,null,null,null,null,{"$f":"+opciones!R5","v":"G-6"},{"$f":"+opciones!M29","v":"Automático"},{"$f":"+images!I7","v":"Llave con toma incorporada"}]
[null,"Esta hoja está pensada para AYUDAR a configurar y visualizar el armario de regulación / medición que quieres. Igualmente, se puede adaptar cualquier armario a cualquier indicación específica que tengas. Las opciones presentadas aquí NO son de ninguna manera exhaustivas.",null,null,null,null,null,null,"Con armario:",null,null,"Con contador:",null,null,null,null,"materiales","armario",null,{"$f":"+opciones!R6","v":"G-16"},null,{"$f":"+images!I8","v":"Llave con manómetro"}]
[null,"OPCIONES / CONFIGURACIONES ESPECÍFICAS:",null,null,null,"PARA CUALQUIER DUDA, CONSÚLTANOS!!",null,null,null,{"$f":"IF(ISNUMBER(FIND(\"con mirilla\",J6)),IF(OR(K4=T3,K4=T4),\"\",\"No se puede servir un armario con mirilla para \"&K4),\"\")","v":""},null,null,null,null,null,null,{"$f":"+opciones!J7","v":"COBRE"},{"$f":"+opciones!J29","v":"Sin armario"},null,{"$f":"+opciones!R7","v":"G-25"}]
[null,"Toma de presión / llave de entrada:",null,null,null,null,null,null,null,{"$f":"IF(I4=Q13,IF(K4<>\"Regulación sólo\",\"La conexión rosca / tuerca de salida sería de 1''\",\"La conexión rosca / tuerca de salida sería de 1½'' o 2½''\"),\"\")","v":""},null,null,null,null,null,null,{"$f":"+opciones!J8","v":"ACERO"},{"$f":"+opciones!J30","v":"Con armario con mirilla (G-4)"},null,{"$f":"+opciones!R8","v":"G-40"},null,"Form Complete?"]
[null,"Filtro:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+opciones!J9","v":"PE"},{"$f":"+opciones!J31","v":"Con armario sin mirilla"},null,{"$f":"+opciones!R9","v":"G-65"},null,{"$f":"IF(COUNTIF(V10:W21,\"YES\")=21,\"COMPLETE\",\"INCOMPLETE\")","v":"INCOMPLETE"},"Some are NOT needed (marked YES \"hard coded\")"]
[null,"Regulador:",null,null,null,{"$f":"IF(H2=\"\",\"\",IF(H2=\"MPA\",\"* VIS MIN Obligatorio para MPA\",IF(H2=\"MPB\",\"* VIS MIN MAX Obligatorio para MPB\",\"\")))","v":""},{"$f":"IF(ISNUMBER(FIND(\"VIS\",D10)),\"Rearme:\",\"\")","v":""},null,null,null,null,null,null,null,null,null,{"$f":"+opciones!J10","v":"ACERO_INOX"},null,null,{"$f":"+opciones!R10","v":"G-100"},null,{"$f":"+IF(B4<>\"\",\"YES\",\"NO\")","v":"NO"},"YES"]
[null,"Llave de cierre después\ndel regulador:",null,"NO",null,null,null,null,null,null,null,null,null,null,null,null,"conexiones","reguladores",null,{"$f":"+opciones!R11","v":"G-160"},null,{"$f":"+IF(C4<>\"\",\"YES\",\"NO\")","v":"NO"},{"$f":"+IF(D9<>\"\",\"YES\",\"\")","v":""}]
[null,"Toma de presión antes del contador",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+opciones!J13","v":"PARA SOLDAR"},{"$f":"+opciones!B31","v":"Regulador con VIS MIN"},null,null,null,{"$f":"+IF(D4<>\"\",\"YES\",\"NO\")","v":"NO"},"YES"]
[null,"Llave de cierre en la ENTRADA del contador",null,null,{"$f":"IF(Q1=\"\",\"\",IF(Q1>=4,\"* Obligatorio\",\"\"))","v":""},null,{"$f":"IF(ISNUMBER(FIND(\"VIS\",D13)),\"Rearme:\",\"\")","v":""},null,null,null,null,null,null,null,null,null,{"$f":"+opciones!J14","v":"TUERCA / ROSCA"},{"$f":"+opciones!B32","v":"Regulador con VIS MAX"},null,null,null,{"$f":"+IF(E4<>\"\",\"YES\",\"NO\")","v":"NO"},{"$f":"+IF(D11<>\"\",\"YES\",\"\")","v":"YES"}]
[null,null,{"$f":"IF(OR(K4=T2,K4=\"\"),\"\",IF(Q1>=6,\"Sistema de sujección de contador incluído\",\"Soporte para contador incluido\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+opciones!B33","v":"Regulador con VIS MIN & MAX"},null,null,null,{"$f":"+IF(F4<>\"\",\"YES\",\"NO\")","v":"NO"},"YES"]
[null,"Llave de cierre en la\nSALIDA del contador",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+V9","v":"INCOMPLETE"},{"$f":"IF(COUNTIF(V10:V21,\"NO\")=12,\"EMPTY\",\"\")","v":"EMPTY"},null,null,null,{"$f":"+IF(G4<>\"\",\"YES\",\"NO\")","v":"NO"},{"$f":"+IF(D13<>\"\",\"YES\",\"\")","v":""}]
[null,"Toma de presión antes de la SALIDA del armario",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STATUS","RUN COMPLETE",null,null,null,{"$f":"+IF(H4<>\"\",\"YES\",\"NO\")","v":"NO"},{"$f":"+IF(D15<>\"\",\"YES\",\"\")","v":""}]
[null,{"$f":"IF(OR(J6=R8,J6=R9),\"Seguramente, el armario tendrá las siguientes dimensiones:\",\"\")","v":""},null,{"$f":"IF(OR(J6=R8,J6=R9),IF(AND(V9=\"COMPLETE\",NOT(ISERROR(opciones!K90))),opciones!K90&\" mm\",\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(V9=\"COMPLETE\",\"\",\"Por favor, completa todos los campos de tu configuración.\")","v":"Por favor, completa todos los campos de tu configuración."},null,null,null,null,null,null,null,{"$f":"+IF(I4<>\"\",\"YES\",\"NO\")","v":"NO"},"YES"]
[null,"Entrada","Toma","Filtro","Regulador",null,"Llave","Toma","Llave","Soporte / Contador",null,"Llave","Toma","Salida",null,null,null,null,null,null,null,{"$f":"+IF(J4<>\"\",\"YES\",\"NO\")","v":"NO"},{"$f":"+IF(OR((AND(M5<>\"\",N5<>\"\")),AND(M5=\"\",N5=\"\")),\"YES\",\"\")","v":"YES"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+IF(K4<>\"\",\"YES\",\"NO\")","v":"NO"}]
[null,{"$f":"+images!F1","v":"Tubería de inox Ø"},{"$f":"IF(D8=0,\"\",D8)","v":""},{"$f":"IF(D9=\"SI\",\"Con Filtro\",\"Sin Filtro\")","v":"Sin Filtro"},{"$f":"IF(D10=0,\"\",D10)","v":""},{"$f":"IF(H10<>\"\",\"Rearme \"&H10,\"\")","v":""},{"$f":"IF(D11=\"SI\",\"Llave después de regulador\",\"\")","v":""},{"$f":"IF(D12=0,\"\",D12)","v":""},{"$f":"IF(D13=\"SI\",\"Llave entrada contador\",\"\")","v":""},{"$f":"\"Armario \n\" & images!X1","v":"Armario \nCon soporte para "},null,{"$f":"IF(D15=\"SI\",\"Llave salida contador\",\"\")","v":""},{"$f":"IF(D16=0,\"\",D16)","v":""},{"$f":"+images!AB1","v":"Tubería de inox Ø"},null,null,null,null,null,null,null,{"$f":"+IF(J6<>\"\",\"YES\",\"NO\")","v":"NO"}]
[null,"Ancargas SL  -  ancargas.es  - C/ Narcís Monturiol, 2  |  P.I. Can Tapiolas, nave 14  |  08110 MONTCADA I REIXAC  |  Barcelona  |Tel.:   93 308 80 40  |  ancargas@ancargas.com",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+IF(M6<>\"\",\"YES\",\"NO\")","v":"NO"}]

{"sheet":"BATERÍAS","index":3,"n_rows":24,"n_cols":38,"rows_kept":24,"cut":false,"hidden":true,"merged":[[2,11,2,13],[23,1,23,13],[5,1,5,7],[5,9,5,10],[6,8,6,9]]}
[null,"CONFIGURADOR DE BATERIAS PARA CONTADORES DE ANCARGAS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Next time open file:","TIPO de armario",null,"Entrada",null,"Material"]
[null,null,null,null,null,null,null,{"$f":"IF(ISERROR(opciones!AU6),\"\",opciones!AU6)","v":""},{"$f":"IF(H2=\"\",\"\",\">a>\")","v":""},{"$f":"IF(ISERROR(opciones!AU8),\"\",opciones!AU8)","v":""},{"$f":"IF(opciones!AT8>opciones!AT6,\"OJO: Presión de Salida > Entrada\",\"\")","v":""},null,null,null,null,null,"As a user",{"$f":"+opciones!AM3","v":"Batería sin armario"},"Open Options","A",null,{"$f":"+opciones!J7","v":"COBRE"}]
[null,"Gas","No. total de contadores","PARA Contadores","Presión de entrada (bar/mbar)","Material Entrada","Diámetro Entrada","Presión de salida (bar/mbar)","Material Salida","Diametro Salida","Selecciona tu configuración:",null,null,null,null,null,null,{"$f":"+opciones!AM4","v":"Armario galvanizado"},"As a user","B",null,{"$f":"+opciones!J8","v":"ACERO"}]
[null,null,null,"G-4",null,"COBRE",null,{"$f":"IF(B4=\"GLP\",S6,IF(B4=\"GN\",S7,\"\"))","v":""},"COBRE",{"$f":"IF(B4=\"GLP\",S9,IF(B4=\"GN\",S10,\"\"))","v":""},{"$f":"IF(ISERROR(U21),\"\",IF(C4=U21,\"Estructura de la batería:\",IF(C4<U21,IF(U21-C4=1,\"Se  quitará 1 contador\",IF(U21-C4>1,\"Se quitarán \"&U21-C4&\" contadores\",\"\")))))","v":""},{"$f":"IF(ISERROR(R21),\"\",\"Alto:\n\"&R21& \" mm\")","v":""},{"$f":"IF(ISERROR(S21),\"\",\"Ancho:\n\"&S21& \" mm\")","v":""},{"$f":"IF(ISERROR(T21),\"\",\"Fondo:\n\"&T21& \" mm\")","v":""},null,null,"Form Completed?",null,"In editor Mode","C",null,{"$f":"+opciones!J9","v":"PE"}]
[null,null,null,null,{"$f":"IF(opciones!AT6>opciones!K22,\"La presión de entrada debe ser BP, MPA o MPB\",\"\")","v":""},null,null,null,null,{"$f":"IF(C4>S17,\"Consultarnos! El número máximo habitual es \"&S17,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(COUNTIF(Q6:Q13,\"YES\")=8,\"COMPLETE\",\"INCOMPLETE\")","v":"INCOMPLETE"},null,null,"D",null,{"$f":"+opciones!J10","v":"ACERO_INOX"}]
[null,"Esta hoja está pensada para AYUDAR a configurar y visualizar una batería de centralización de contadores. Igualmente, podemos adaptarnos a cualquier configuración que tengas.",null,null,null,null,null,null,"Armario:",null,null,"Con contadores:",null,null,null,null,{"$f":"+IF(B4<>\"\",\"YES\",\"\")","v":""},null,"150 mbar","E"]
[null,{"$f":"IF(Q5<>\"COMPLETE\",\"Por favor completa todos los campos\",\"\")","v":"Por favor completa todos los campos"},null,null,null,null,null,null,"Selecciona la entrada\ndel gráfico:",null,null,"Ubicación de la entrada:",null,null,null,null,{"$f":"+IF(C4<>\"\",\"YES\",\"\")","v":""},null,"22 mbar","F"]
[null,"DETALLE DE LA CONFIGURACION:",null,null,"PARA CUALQUIER DUDA - CONSULTANOS!!",null,null,null,null,null,null,null,null,null,null,null,{"$f":"+IF(AND(E4<>\"\",E5=\"\"),\"YES\",\"\")","v":""},"GAS",null,"G"]
[null,null,{"$f":"IF(Q5=\"COMPLETE\",\"La salida de la batería será por la parte superior.\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+IF(G4<>\"\",\"YES\",\"\")","v":""},{"$f":"+opciones!J2","v":"GLP"},"15 mm","H"]
[null,null,{"$f":"IF(Q5=\"COMPLETE\",IF(J6=R2,\"La batería se suministrará sin armario.\",\"La batería se suministrará con armario de dimensiones:\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+IF(L3<>\"\",\"YES\",\"\")","v":""},{"$f":"+opciones!J3","v":"GN"},"22 mm"]
[null,null,{"$f":"IF(Q5=\"COMPLETE\",IF(J6=R2,\"Las baterías de Ancargas se suministran con bastidor de acero inoxidable de gran calidad.\",IF(ISERROR(V22),\"\",\"Dimensiones del armario:  \"&V22&\" (a confirmar).\")),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+IF(J6<>\"\",\"YES\",\"\")","v":""}]
[null,null,{"$f":"IF(Q5=\"COMPLETE\",IF(M6=\"SI\",\"La batería se suministrará con \"& C4 &\" contadores G-4.\",\"La batería se suministrará preparada para \"& C4 &\" contadores G-4.\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+IF(M6<>\"\",\"YES\",\"\")","v":""},null,null,null,null,null,1,2,3,4,5,6,7,8,11,12,13]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+IF(M7<>\"\",\"YES\",\"\")","v":""},"TIPO","CONTADORES TOTAL","INDEX",null,null,"TIPO","DESCRIPCION","VERTICAL","HORIZONTAL","TOTAL","ALTO","ANCHO","FONDO","ALTO","ANCHO","FONDO"]
[null,null,{"$f":"IF(Q5=\"COMPLETE\",\"En la entrada de la batería:\",\"\")","v":""},null,null,{"$f":"IF(Q5=\"COMPLETE\",IF(B4=\"GLP\",\"Manómetro\",IF(B4=\"GN\",\"Con toma Peterson común\",\"\")),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B4=\"GLP\",\"GLP MPB\",IF(B4=\"GN\",IF(H2=\"MPA\",\"GN MPA\",\"GN BP\"),\"\"))","v":""},{"$f":"C4","v":0},null,null,null,{"$f":"INDEX(opciones!$V$3:$AE$98,BATERÍAS!$T15,W$12)","v":{"$error":"#N/A"}},{"$f":"INDEX(opciones!$V$3:$AE$98,BATERÍAS!$T15,X$12)","v":{"$error":"#N/A"}},{"$f":"INDEX(opciones!$V$3:$AE$98,BATERÍAS!$T15,Y$12)","v":{"$error":"#N/A"}},{"$f":"INDEX(opciones!$V$3:$AE$98,BATERÍAS!$T15,Z$12)","v":{"$error":"#N/A"}},{"$f":"INDEX(opciones!$V$3:$AE$98,BATERÍAS!$T15,AA$12)","v":{"$error":"#N/A"}},{"$f":"INDEX(opciones!$V$3:$AE$98,BATERÍAS!$T15,AB$12)","v":{"$error":"#N/A"}},{"$f":"INDEX(opciones!$V$3:$AE$98,BATERÍAS!$T15,AC$12)","v":{"$error":"#N/A"}},{"$f":"INDEX(opciones!$V$3:$AE$98,BATERÍAS!$T15,AD$12)","v":{"$error":"#N/A"}},{"$f":"INDEX(opciones!$V$3:$AH$98,BATERÍAS!$T15,AE$12)","v":{"$error":"#N/A"}},{"$f":"INDEX(opciones!$V$3:$AH$98,BATERÍAS!$T15,AF$12)","v":{"$error":"#N/A"}},{"$f":"INDEX(opciones!$V$3:$AH$98,BATERÍAS!$T15,AG$12)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,{"$f":"IF(AND(Q5=\"COMPLETE\",B4=\"GLP\"),\"Con filtro de 10 micras\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,"Get",{"$f":"VLOOKUP(R14&TEXT(S14,\"00\"),opciones!U3:U98,1)","v":{"$error":"#N/A"}},{"$f":"+MATCH(S15,opciones!U3:U98,)","v":{"$error":"#N/A"}},null,null,{"$f":"IF(ISERROR(INDEX(opciones!$V$3:$AE$98,BATERÍAS!$T16,W$12)),\"\",INDEX(opciones!$V$3:$AE$98,BATERÍAS!$T16,W$12))","v":""},{"$f":"IF(ISERROR(INDEX(opciones!$V$3:$AE$98,BATERÍAS!$T16,X$12)),\"\",INDEX(opciones!$V$3:$AE$98,BATERÍAS!$T16,X$12))","v":""},{"$f":"IF(ISERROR(INDEX(opciones!$V$3:$AE$98,BATERÍAS!$T16,Y$12)),\"\",INDEX(opciones!$V$3:$AE$98,BATERÍAS!$T16,Y$12))","v":""},{"$f":"IF(ISERROR(INDEX(opciones!$V$3:$AE$98,BATERÍAS!$T16,Z$12)),\"\",INDEX(opciones!$V$3:$AE$98,BATERÍAS!$T16,Z$12))","v":""},{"$f":"IF(ISERROR(INDEX(opciones!$V$3:$AE$98,BATERÍAS!$T16,AA$12)),\"\",INDEX(opciones!$V$3:$AE$98,BATERÍAS!$T16,AA$12))","v":""},{"$f":"IF(ISERROR(INDEX(opciones!$V$3:$AE$98,BATERÍAS!$T16,AB$12)),\"\",INDEX(opciones!$V$3:$AE$98,BATERÍAS!$T16,AB$12))","v":""},{"$f":"IF(ISERROR(INDEX(opciones!$V$3:$AE$98,BATERÍAS!$T16,AC$12)),\"\",INDEX(opciones!$V$3:$AE$98,BATERÍAS!$T16,AC$12))","v":""},{"$f":"IF(ISERROR(INDEX(opciones!$V$3:$AE$98,BATERÍAS!$T16,AD$12)),\"\",INDEX(opciones!$V$3:$AE$98,BATERÍAS!$T16,AD$12))","v":""},{"$f":"IF(ISERROR(INDEX(opciones!$V$3:$AH$98,BATERÍAS!$T16,AE$12)),\"\",INDEX(opciones!$V$3:$AH$98,BATERÍAS!$T16,AE$12))","v":""},{"$f":"IF(ISERROR(INDEX(opciones!$V$3:$AH$98,BATERÍAS!$T16,AF$12)),\"\",INDEX(opciones!$V$3:$AH$98,BATERÍAS!$T16,AF$12))","v":""},{"$f":"IF(ISERROR(INDEX(opciones!$V$3:$AH$98,BATERÍAS!$T16,AG$12)),\"\",INDEX(opciones!$V$3:$AH$98,BATERÍAS!$T16,AG$12))","v":""}]
[null,null,null,null,null,{"$f":"IF(AND(Q5=\"COMPLETE\",B4=\"GLP\"),\"Con toma Peterson común\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,"to",{"$f":"15","v":15},{"$f":"IF(INDEX(opciones!$V$3:$AE$98,BATERÍAS!T15+1,1)=$R$14,T15+1,\"\")","v":{"$error":"#N/A"}},null,null,{"$f":"IF(ISERROR(INDEX(opciones!$V$3:$AE$98,BATERÍAS!$T17,W$12)),\"\",INDEX(opciones!$V$3:$AE$98,BATERÍAS!$T17,W$12))","v":""},{"$f":"IF(ISERROR(INDEX(opciones!$V$3:$AE$98,BATERÍAS!$T17,X$12)),\"\",INDEX(opciones!$V$3:$AE$98,BATERÍAS!$T17,X$12))","v":""},{"$f":"IF(ISERROR(INDEX(opciones!$V$3:$AE$98,BATERÍAS!$T17,Y$12)),\"\",INDEX(opciones!$V$3:$AE$98,BATERÍAS!$T17,Y$12))","v":""},{"$f":"IF(ISERROR(INDEX(opciones!$V$3:$AE$98,BATERÍAS!$T17,Z$12)),\"\",INDEX(opciones!$V$3:$AE$98,BATERÍAS!$T17,Z$12))","v":""},{"$f":"IF(ISERROR(INDEX(opciones!$V$3:$AE$98,BATERÍAS!$T17,AA$12)),\"\",INDEX(opciones!$V$3:$AE$98,BATERÍAS!$T17,AA$12))","v":""},{"$f":"IF(ISERROR(INDEX(opciones!$V$3:$AE$98,BATERÍAS!$T17,AB$12)),\"\",INDEX(opciones!$V$3:$AE$98,BATERÍAS!$T17,AB$12))","v":""},{"$f":"IF(ISERROR(INDEX(opciones!$V$3:$AE$98,BATERÍAS!$T17,AC$12)),\"\",INDEX(opciones!$V$3:$AE$98,BATERÍAS!$T17,AC$12))","v":""},{"$f":"IF(ISERROR(INDEX(opciones!$V$3:$AE$98,BATERÍAS!$T17,AD$12)),\"\",INDEX(opciones!$V$3:$AE$98,BATERÍAS!$T17,AD$12))","v":""},{"$f":"IF(ISERROR(INDEX(opciones!$V$3:$AH$98,BATERÍAS!$T17,AE$12)),\"\",INDEX(opciones!$V$3:$AH$98,BATERÍAS!$T17,AE$12))","v":""},{"$f":"IF(ISERROR(INDEX(opciones!$V$3:$AH$98,BATERÍAS!$T17,AF$12)),\"\",INDEX(opciones!$V$3:$AH$98,BATERÍAS!$T17,AF$12))","v":""},{"$f":"IF(ISERROR(INDEX(opciones!$V$3:$AH$98,BATERÍAS!$T17,AG$12)),\"\",INDEX(opciones!$V$3:$AH$98,BATERÍAS!$T17,AG$12))","v":""}]
[null,null,null,null,null,{"$f":"IF(AND(Q5=\"COMPLETE\",B4=\"GLP\"),\"Con 2 llaves comunes\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,"MAX",30,{"$f":"IF(INDEX(opciones!$V$3:$AE$98,BATERÍAS!T16+1,1)=$R$14,T16+1,\"\")","v":{"$error":"#N/A"}},null,null,{"$f":"IF(ISERROR(INDEX(opciones!$V$3:$AE$98,BATERÍAS!$T18,W$12)),\"\",INDEX(opciones!$V$3:$AE$98,BATERÍAS!$T18,W$12))","v":""},{"$f":"IF(ISERROR(INDEX(opciones!$V$3:$AE$98,BATERÍAS!$T18,X$12)),\"\",INDEX(opciones!$V$3:$AE$98,BATERÍAS!$T18,X$12))","v":""},{"$f":"IF(ISERROR(INDEX(opciones!$V$3:$AE$98,BATERÍAS!$T18,Y$12)),\"\",INDEX(opciones!$V$3:$AE$98,BATERÍAS!$T18,Y$12))","v":""},{"$f":"IF(ISERROR(INDEX(opciones!$V$3:$AE$98,BATERÍAS!$T18,Z$12)),\"\",INDEX(opciones!$V$3:$AE$98,BATERÍAS!$T18,Z$12))","v":""},{"$f":"IF(ISERROR(INDEX(opciones!$V$3:$AE$98,BATERÍAS!$T18,AA$12)),\"\",INDEX(opciones!$V$3:$AE$98,BATERÍAS!$T18,AA$12))","v":""},{"$f":"IF(ISERROR(INDEX(opciones!$V$3:$AE$98,BATERÍAS!$T18,AB$12)),\"\",INDEX(opciones!$V$3:$AE$98,BATERÍAS!$T18,AB$12))","v":""},{"$f":"IF(ISERROR(INDEX(opciones!$V$3:$AE$98,BATERÍAS!$T18,AC$12)),\"\",INDEX(opciones!$V$3:$AE$98,BATERÍAS!$T18,AC$12))","v":""},{"$f":"IF(ISERROR(INDEX(opciones!$V$3:$AE$98,BATERÍAS!$T18,AD$12)),\"\",INDEX(opciones!$V$3:$AE$98,BATERÍAS!$T18,AD$12))","v":""},{"$f":"IF(ISERROR(INDEX(opciones!$V$3:$AH$98,BATERÍAS!$T18,AE$12)),\"\",INDEX(opciones!$V$3:$AH$98,BATERÍAS!$T18,AE$12))","v":""},{"$f":"IF(ISERROR(INDEX(opciones!$V$3:$AH$98,BATERÍAS!$T18,AF$12)),\"\",INDEX(opciones!$V$3:$AH$98,BATERÍAS!$T18,AF$12))","v":""},{"$f":"IF(ISERROR(INDEX(opciones!$V$3:$AH$98,BATERÍAS!$T18,AG$12)),\"\",INDEX(opciones!$V$3:$AH$98,BATERÍAS!$T18,AG$12))","v":""}]
[null,null,{"$f":"IF(Q5=\"COMPLETE\",\"Reguladores individuales de abonado:\",\"\")","v":""},null,null,{"$f":"IF(Q5=\"COMPLETE\",IF(B4=\"GLP\",\"A 150mbar\",IF(B4=\"GN\",\"A 22 mbar\",\"\")),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(INDEX(opciones!$V$3:$AE$98,BATERÍAS!T17+1,1)=$R$14,T17+1,\"\")","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"                                            "]
[null,null,null,null,null,{"$f":"IF(Q5=\"COMPLETE\",\"Con llave individual\",\"\")","v":""}]
[null,null,null,null,null,{"$f":"IF(Q5=\"COMPLETE\",IF(B4=\"GLP\",\"Regulador con VIS MAX con rearme manual\",IF(B4=\"GN\",\"Regulador con VIS MIN con rearme automático\",\"\")),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,"ALTO","ANCHO","FONDO","TOTAL","ALTO","ANCHO","FONDO"]
[null,null,null,null,null,{"$f":"IF(Q5=\"COMPLETE\",IF(B4=\"GLP\",\"Toma Peterson individual\",IF(B4=\"GN\",\"Toma de débil calibre individual\",\"\")),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"+VLOOKUP(L3,$X$14:$AD$17,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"+VLOOKUP(L3,$X$14:$AD$17,6,FALSE)","v":{"$error":"#N/A"}},{"$f":"+VLOOKUP(L3,$X$14:$AD$17,7,FALSE)","v":{"$error":"#N/A"}},{"$f":"+VLOOKUP(L3,$X$14:$AD$17,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"+VLOOKUP(L3,$X$14:$AG$17,8,FALSE)","v":{"$error":"#N/A"}},{"$f":"+VLOOKUP(L3,$X$14:$AG$17,9,FALSE)","v":{"$error":"#N/A"}},{"$f":"+VLOOKUP(L3,$X$14:$AG$17,10,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+V21&\" x \"&W21&\" x \"&X21 & \" mm\"","v":{"$error":"#N/A"}}]
[]
[null,"Ancargas SL  -  ancargas.es  - C/ Narcís Monturiol, 2  |  P.I. Can Tapiolas, nave 14  |  08110 MONTCADA I REIXAC  |  Barcelona  |Tel.:   93 308 80 40  |  ancargas@ancargas.com"]

{"sheet":"INDEX","index":4,"n_rows":23,"n_cols":3,"rows_kept":23,"cut":false,"hidden":false,"merged":[[20,1,20,13],[6,1,6,13],[22,1,22,13],[18,1,18,13],[3,2,4,10]]}
[]
[]
[]
[null,null,"Este documento Excel debería funcionar correctamente con su versión de Excel. Asegúrase con los macros estén habilitados."]
[]
[]
[null,"Bienvenidos al configurador de Armarios y Baterías de Ancargas"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Este Excel requiere macros para funcionar correctamente. Garantizamos que no contiene malware ni cualquier macro malintencionado pero, por favor, sólo utiliza el documento que haya descargado de nuestra web.\nFunciona correctamente con Excel 2010 y versiones más recientes. Con versiones anteriores NO funcionan correctamente los elementos gráficos.\nSi lo ha descargado de cualquier otra fuente, no podemos garantizar la seguridad."]
[]
[null,"Ancargas S.L.  -  www.ancargas.es\nC/ Narcís Monturiol, 2  |  P.I. Can Tapiolas, nave 14  |  08110 MONTCADA I REIXAC  |  Barcelona\nTel.:   93 308 80 40  |  ancargas@ancargas.com"]
[]
[null,{"$f":"TODAY()","v":"2025-02-22"}]