{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["prob-1","prob-2-3","pROB-selecc-bomba","Gr-entcurva","Gr-entcurva (2)","Gr-enjaco-t25","Gr-enjaco-t75","Gr-recuperac","Gr-qespcifico","Gr-qespcifico (2)","Gr-bomba","Gr-curvas sistemaáfico2","cURVATIPO","GR-CURTIPO"],"not_rendered":{"charts":20,"images":0,"macros":1,"external_links":0,"defined_names":5,"comments":1,"pivot_tables":0},"unopened":[{"sheet":"Gr-entcurva","index":3,"reason":"not_a_worksheet"},{"sheet":"Gr-entcurva (2)","index":4,"reason":"not_a_worksheet"},{"sheet":"Gr-enjaco-t25","index":5,"reason":"not_a_worksheet"},{"sheet":"Gr-enjaco-t75","index":6,"reason":"not_a_worksheet"},{"sheet":"Gr-recuperac","index":7,"reason":"not_a_worksheet"},{"sheet":"Gr-qespcifico","index":8,"reason":"not_a_worksheet"},{"sheet":"Gr-qespcifico (2)","index":9,"reason":"not_a_worksheet"},{"sheet":"Gr-bomba","index":10,"reason":"not_a_worksheet"},{"sheet":"Gr-curvas sistemaáfico2","index":11,"reason":"not_a_worksheet"},{"sheet":"GR-CURTIPO","index":13,"reason":"not_a_worksheet"}],"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":"prob-1","index":0,"n_rows":113,"n_cols":27,"rows_kept":113,"cut":false,"hidden":false,"merged":[[10,21,12,21],[110,16,112,16]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Problema 1.",null,null,null,null,"Cuadro resumen"]
["Problema 1.",null,null,null,null,null,"Punto 2","Punto 1","Problema 1.","Punto 2","Punto 1",null,null,"Punto 2","Punto 1",null,"Método de la curva tipo",null,null,null,null,"u <",0.01,"r (m)=",25,75]
["Q (m3/d)=",540,null,null,null,"t0(min)",0.27,null,"t0(min)",3.5,null,null,"(t/r2)0 (min/m2)=",{"$f":"6*10^(-4)","v":6.0000000000000006E-4},null,null,null,null,null,null,null,null,"Punto A","Punto B","Jacob-t-r25","Jacob-t-r75","Jacob-t/r2"]
[null,null,null,"R2=",0.99,"t(min)",100,10,"t(min)",100,10,null,"t/r2(min/m2)=",0.1,0.01,null,"Datos de la prueba",null,"Curva tipo de Theis"]
[null,null,null,"Ln=",0.18229999999999999,"x (m)",1.0900000000000001,0.67,"x (m)",0.56999999999999995,0.19,null,"x (m)",0.96,0.52,null,"x (m)","t/r2(min/m2)","u","W(u)","1/u","(1/u)=",10,100]
[null,null,null,"Intersección=",0.249,"D log(t2/t1)=",1,null,"D log(t2/t1)=",1,null,null,"Inc. log(t2/t1)=",1,null,null,{"$f":"+C11","v":0.18},{"$f":"+D11","v":1.6000000000000001E-3},1E-4,8.6332000000000004,{"$f":"1/S6","v":10000},"W(u)=",1,3.9]
["r (m)=",null,25,null,null,"D x=",{"$f":"+G5-H5","v":0.42000000000000004},null,"D x=",{"$f":"+J5-K5","v":0.37999999999999995},"r (m)=",75,"D x=",{"$f":"+N5-O5","v":0.43999999999999995},null,null,0.25,2.2399999999999998E-3,1.1E-4,8.5379000000000005,{"$f":"1/S7","v":9090.9090909090901},"x (m)=",0.23,0.9]
[null,"t (min)","x (m)","t/r2(min/m2)","Apr. Lineal",null,null,null,null,"t (min)","x (m)","t/r2(min/m2)",null,null,null,null,0.32,3.2000000000000002E-3,1.2E-4,8.4509000000000007,8333.3333333333339,"t/r2(min/m2)=",{"$f":"8.2*10^(-3)","v":8.199999999999999E-3},8.4000000000000005E-2,null,null,{"$f":"+N3","v":6.0000000000000006E-4}]
[null,0.2,null,null,{"$f":"+$E$6+$E$5*LN(B9)","v":-4.4400531436736446E-2},"T",null,null,null,null,null,null,null,null,null,null,0.4,4.4799999999999996E-3,1.2999999999999999E-4,8.3709000000000007,7692.3076923076933,"T (m2/d)=",{"$f":"$B$3*W6/(4*PI()*W7)","v":186.83406362961625},{"$f":"$B$3*X6/(4*PI()*X7)","v":186.21128341751756},{"$f":"2.303*$B$3/(4*PI()*G7)","v":235.62889324755102},{"$f":"2.303*$B$3/(4*PI()*J7)","v":260.43193464203011},{"$f":"2.303*$B$3/(4*PI()*N7)","v":224.91848900902602}]
[null,0.4,null,null,{"$f":"+$E$6+$E$5*LN(B10)","v":8.1960199579341558E-2},null,null,null,null,null,null,null,null,null,null,null,0.46,6.0799999999999995E-3,1.3999999999999999E-4,8.2967999999999993,7142.8571428571431,"S=",{"$f":"1/W5*4*W9/(24*60)*W8","v":4.2556647826745922E-4},{"$f":"1/X5*4*X9/(24*60)*X8","v":4.3449299464087436E-4},{"$f":"2.25*Y9/(24*60)*G3/Y2^2","v":1.5904950294209693E-4},{"$f":"2.25*Z9/(24*60)*J3/Z2^2","v":2.5319771423530711E-4},{"$f":"2.25*AA9/(24*60)*AA8","v":2.108610834459619E-4}]
[null,1,0.18,{"$f":"+B11/C$7^2","v":1.6000000000000001E-3},{"$f":"+$E$6+$E$5*LN(B11)","v":0.249},null,null,null,null,3,2.1999999999999999E-2,{"$f":"+J11/L$7^2","v":5.3333333333333336E-4},null,null,null,null,0.5,7.5200000000000006E-3,1.5000000000000001E-4,8.2278000000000002,6666.6666666666661,"  u<0,01","u t (d)=",null,{"$f":"+Y2^2*Y10/(4*Y9)","v":1.0546875E-4},{"$f":"+Z2^2*Z10/(4*Z9)","v":1.3671875000000003E-3}]
[null,1.4,0.25,2.2399999999999998E-3,{"$f":"+$E$6+$E$5*LN(B12)","v":0.31033888873604709},null,null,null,null,4,0.03,7.1111111111111115E-4,null,null,null,null,0.55000000000000004,8.9599999999999992E-3,1.6000000000000001E-4,8.1633999999999993,6249.9999999999991,null,"t (min)>",null,{"$f":"+Y11/$W$2*24*60","v":15.1875},{"$f":"+Z11/$W$2*24*60","v":196.87500000000006}]
[null,2,0.32,3.2000000000000002E-3,0.37536073101607803,null,null,null,null,4.3,3.3000000000000002E-2,7.6444444444444444E-4,null,null,null,null,0.6,1.072E-2,1.7000000000000001E-4,8.1027000000000005,5882.3529411764703,null,"t/r2(min/m2)>",null,null,null,{"$f":"AA10/(W2*4*AA9)*24*60","v":3.3750000000000002E-2}]
[null,2.8,0.4,4.4799999999999996E-3,0.43669961975212512,null,null,null,null,5.3,6.2E-2,9.4222222222222222E-4,null,null,null,null,0.65,1.2800000000000001E-2,1.8000000000000001E-4,8.0455000000000005,5555.5555555555557]
[null,3.8,0.46,6.0799999999999995E-3,0.49237069446530557,null,null,null,null,6,7.5999999999999998E-2,1.0666666666666667E-3,null,null,null,null,0.7,1.712E-2,1.9000000000000001E-4,7.9915000000000003,5263.1578947368416]
[null,4.7,0.5,7.5200000000000006E-3,0.53112064533892922,null,null,null,null,7,0.105,1.2444444444444445E-3,null,null,null,null,0.76,2.1759999999999998E-2,2.0000000000000001E-4,7.9401999999999999,5000]
[null,5.6,0.55000000000000004,8.9599999999999992E-3,0.56306035076820315,null,null,null,null,8,0.126,1.4222222222222223E-3,null,null,null,null,0.8,2.64E-2,3.0000000000000003E-4,7.5347999999999997,3333.333333333333]
[null,6.7,0.6,1.072E-2,0.59575420206215857,null,null,null,null,8.6999999999999993,0.14599999999999999,1.5466666666666665E-3,null,null,null,null,0.82,2.8000000000000001E-2,4.0000000000000002E-4,7.2472000000000003,2500]
[null,8,0.65,1.2800000000000001E-2,0.62808219304823409,null,null,null,null,11,0.186,1.9555555555555554E-3,null,null,null,null,0.84,3.3599999999999998E-2,5.0000000000000001E-4,7.0242000000000004,2000]
[null,10.7,0.7,1.712E-2,0.68109543406959094,null,null,null,null,12,0.214,2.1333333333333334E-3,null,null,null,null,0.9,4.2079999999999999E-2,6.0000000000000006E-4,6.8419999999999996,1666.6666666666665]
[null,13.6,0.76,2.1759999999999998E-2,0.72481572321686771,null,null,null,null,15,0.25,2.6666666666666666E-3,null,null,null,null,0.96,5.7599999999999998E-2,6.9999999999999999E-4,6.6879,1428.5714285714287]
[null,16.5,0.8,2.64E-2,0.76005259743926123,null,null,null,null,18,0.28799999999999998,3.2000000000000002E-3,null,null,null,null,1.04,8.6400000000000005E-2,8.0000000000000004E-4,6.5545,1250]
[null,17.5,0.82,2.8000000000000001E-2,{"$f":"+$E$6+$E$5*LN(B23)","v":0.77077922059344206},null,null,null,null,27,0.35,4.7999999999999996E-3,null,null,null,null,1.05,0.104,9.0000000000000008E-4,6.4367999999999999,1111.1111111111111]
[null,21,0.84,3.3599999999999998E-2,0.80401644039697995,null,null,null,null,31,0.38500000000000001,5.5111111111111107E-3,null,null,null,null,1.0900000000000001,0.128,9.8999999999999999E-4,6.3415999999999997,1010.1010101010102]
[null,26.3,0.9,4.2079999999999999E-2,0.84504241761319188,null,null,null,null,35,0.42699999999999999,6.2222222222222219E-3,null,null,null,null,1.1100000000000001,0.1552,1E-3,6.3315000000000001,1000]
[null,36,0.96,5.7599999999999998E-2,0.90227550248054877,null,null,null,null,50,0.48699999999999999,8.8888888888888889E-3,null,null,null,null,1.1499999999999999,0.19040000000000001,1.1000000000000001E-3,6.2363,909.09090909090901]
[null,54,1.04,8.6400000000000005E-2,0.97619179168866721,null,null,null,null,60,0.51,1.0666666666666666E-2,null,null,null,null,1.2,0.25919999999999999,1.2000000000000001E-3,6.1494,833.33333333333326]
[null,65,1.05,0.104,1.0099907993019746,null,null,null,null,80,0.56599999999999995,1.4222222222222223E-2,null,null,null,null,1.22,0.30399999999999999,1.3000000000000002E-3,6.0694999999999997,769.23076923076917]
[null,80,1.0900000000000001,0.128,1.0478434555010485,null,null,null,null,106,0.60199999999999998,1.8844444444444445E-2,null,null,null,null,1.28,0.44800000000000001,1.4E-3,5.9954999999999998,714.28571428571433]
[null,97,1.1100000000000001,0.1552,1.0829698113811665,null,null,null,null,120,0.622,2.1333333333333333E-2,null,null,null,null,1.31,0.58240000000000003,1.5E-3,5.9265999999999996,666.66666666666663]
[null,119,1.1499999999999999,0.19040000000000001,1.120234212794232,null,null,null,null,150,0.65400000000000003,2.6666666666666668E-2,null,null,null,null,1.35,0.78400000000000003,1.6000000000000001E-3,5.8620999999999999,625]
[null,162,1.2,0.25919999999999999,1.1764688119128635,null,null,null,null,180,0.69,3.2000000000000001E-2,null,null,null,null,1.4,0.97599999999999998,1.7000000000000001E-3,5.8015999999999996,588.23529411764707]
[null,190,1.22,0.30399999999999999,1.2055324883548566,null,null,null,null,220,0.71,3.911111111111111E-2,null,null,null,null,1.42,1.1679999999999999,1.8000000000000002E-3,5.7446000000000002,555.55555555555554]
[null,280,1.28,0.44800000000000001,1.276222144657754,null,null,null,null,245,0.74,4.3555555555555556E-2,null,null,null,null,1.47,1.52,1.9E-3,5.6905999999999999,526.31578947368416]
[null,364,1.31,0.58240000000000003,{"$f":"+$E$6+$E$5*LN(B35)","v":1.3240511500701779},null,null,null,null,300,0.77400000000000002,5.3333333333333337E-2,null,null,null,null,1.48,1.952,2E-3,5.6394000000000002,500]
[null,490,1.35,0.78400000000000003,1.3782401027983817,null,null,null,null,360,0.79500000000000004,6.4000000000000001E-2,null,null,null,null,1.5,2.3679999999999999,3.0000000000000001E-3,5.2348999999999997,333.33333333333331]
[null,610,1.4,0.97599999999999998,1.4181735678916092,null,null,null,null,500,0.83,8.8888888888888892E-2,null,null,null,null,{"$f":"+K11","v":2.1999999999999999E-2},{"$f":"+L11","v":5.3333333333333336E-4},4.0000000000000001E-3,4.9481999999999999,250]
[null,730,1.42,1.1679999999999999,1.450912018574166,null,null,null,null,610,0.86,0.10844444444444444,null,null,null,null,0.03,7.1111111111111115E-4,5.0000000000000001E-3,4.7260999999999997,200]
[null,950,1.47,1.52,1.4989330197915929,null,null,null,null,730,0.89,0.12977777777777777,null,null,null,null,3.3000000000000002E-2,7.6444444444444444E-4,6.0000000000000001E-3,4.5448000000000004,166.66666666666666]
[null,1220,1.48,1.952,1.5445342989076871,null,null,null,null,850,0.92,0.15111111111111111,null,null,null,null,6.2E-2,9.4222222222222222E-4,7.0000000000000001E-3,4.3916000000000004,142.85714285714286]
[null,1480,1.5,2.3679999999999999,1.5797530599600127,null,null,null,null,1100,0.95,0.19555555555555557,null,null,null,null,7.5999999999999998E-2,1.0666666666666667E-3,8.0000000000000002E-3,4.2591000000000001,125]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.105,1.2444444444444445E-3,9.0000000000000011E-3,4.1422999999999996,111.1111111111111]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.126,1.4222222222222223E-3,9.9000000000000008E-3,4.0479000000000003,101.010101010101]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.14599999999999999,1.5466666666666665E-3,0.01,4.0378999999999996,100]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.186,1.9555555555555554E-3,1.1000000000000001E-2,3.9436,90.909090909090907]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.214,2.1333333333333334E-3,1.2E-2,3.8576000000000001,83.333333333333329]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.25,2.6666666666666666E-3,1.3000000000000001E-2,3.7785000000000002,76.92307692307692]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.28799999999999998,3.2000000000000002E-3,1.4E-2,3.7054,71.428571428571431]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.35,4.7999999999999996E-3,1.4999999999999999E-2,3.6374,66.666666666666671]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.38500000000000001,5.5111111111111107E-3,1.6E-2,3.5739000000000001,62.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.42699999999999999,6.2222222222222219E-3,1.7000000000000001E-2,3.5143,58.823529411764703]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.48699999999999999,8.8888888888888889E-3,1.8000000000000002E-2,3.4581,55.55555555555555]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.51,1.0666666666666666E-2,1.9E-2,3.4049999999999998,52.631578947368425]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.56599999999999995,1.4222222222222223E-2,0.02,3.3546999999999998,50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.60199999999999998,1.8844444444444445E-2,0.03,2.9590999999999998,33.333333333333336]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.622,2.1333333333333333E-2,0.04,2.6812999999999998,25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.65400000000000003,2.6666666666666668E-2,0.05,2.4679000000000002,20]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.69,3.2000000000000001E-2,0.06,2.2953000000000001,16.666666666666668]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.71,3.911111111111111E-2,7.0000000000000007E-2,2.1507999999999998,14.285714285714285]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.74,4.3555555555555556E-2,0.08,2.0268999999999999,12.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.77400000000000002,5.3333333333333337E-2,0.09,1.9187000000000001,11.111111111111111]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.79500000000000004,6.4000000000000001E-2,9.9000000000000005E-2,1.8320000000000001,10.1010101010101]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.83,8.8888888888888892E-2,0.1,1.8229,10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.86,0.10844444444444444,0.11,1.7371000000000001,9.0909090909090917]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.89,0.12977777777777777,0.12,1.6595,8.3333333333333339]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.92,0.15111111111111111,0.13,1.5889,7.6923076923076916]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.95,0.19555555555555557,0.14000000000000001,1.5241,7.1428571428571423]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.15,1.4644999999999999,6.666666666666667]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.16,1.4092,6.25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.17,1.3577999999999999,5.8823529411764701]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.18,1.3089,{"$f":"1/S71","v":5.5555555555555554}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.19,1.2648999999999999,5.2631578947368425]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.2,1.2226999999999999,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.3,0.90569999999999995,3.3333333333333335]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.4,0.70240000000000002,2.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.5,0.55979999999999996,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.6,0.45540000000000003,1.6666666666666667]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.7,0.37380000000000002,1.4285714285714286]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.8,0.31059999999999999,1.25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.9,0.26019999999999999,1.1111111111111112]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.99,0.22309999999999999,1.0101010101010102]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,0.21940000000000001,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.1000000000000001,0.186,0.90909090909090906]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,0.15840000000000001,0.83333333333333337]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.3,0.13550000000000001,0.76923076923076916]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.4,0.1162,0.7142857142857143]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.5,0.1,0.66666666666666663]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.6,8.6309999999999998E-2,0.625]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.7,7.4650000000000008E-2,0.58823529411764708]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.8,6.4710000000000004E-2,0.55555555555555558]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.9,5.62E-2,0.52631578947368418]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,1.3050000000000001E-2,0.33333333333333331]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,3.7789999999999998E-3,0.25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,1.1479999999999999E-3,0.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,3.6010000000000003E-4,0.16666666666666666]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,1.155E-4,0.14285714285714285]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,3.7669999999999997E-5,0.125]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,1.2449999999999999E-5,0.1111111111111111]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.9,4.6369999999999998E-6,0.10101010101010101]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cuadro resumen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"u <",0.01,"r (m)=",25,75]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Punto A","Punto B","Jacob-t-r25","Jacob-t-r75","Jacob-t/r2"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(1/u)=",10,100]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"W(u)=",1,3.9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x (m)=",0.23,0.9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"t/r2(min/m2)=",8.199999999999999E-3,8.4000000000000005E-2,null,null,6.0000000000000006E-4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T (m2/d)=",186.83406362961625,186.21128341751756,235.62889324755102,260.43193464203011,224.91848900902602]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"S=",4.2556647826745922E-4,4.3449299464087436E-4,1.5904950294209693E-4,2.5319771423530711E-4,2.108610834459619E-4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"  u<0,01","u t (d)=",null,1.0546875E-4,1.3671874999999999E-3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"t (min)>",null,15.1875,196.875]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"t/r2(min/m2)>",null,null,null,3.3750000000000002E-2]

{"sheet":"prob-2-3","index":1,"n_rows":28,"n_cols":16,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
["Problema 2.",null,null,null,null,null,null,null,null,"Problema 3."]
["Q (m3/h)=",47,null,null,null,null,"Punto 2","Punto 1",null,null,null,null,"B (s/m^2)=",21,"D xp/Q=",14.5]
[null,null,null,"R2=",0.99,"t/t'",100,10,null,"T (m2/s)=",7.1999999999999995E-2,null,"log (2,25 T t/r^2 S)=",{"$f":"4*PI()*K3*N2/2.303","v":8.2502615583634675},"D Q(m3/s)=",0.04]
[null,null,null,"Ln=",0.48470000000000002,"x (m)",2.0299999999999998,0.95,null,"S=",{"$f":"4.8*10^(-3)","v":4.7999999999999996E-3},null,"rep (m)=",{"$f":"(2.25*K3*K5*3600/(K4*10^N3))^0.5","v":2.6131080015360422E-2},"C(s2/m5)=",{"$f":"+P2/P3","v":362.5}]
[null,null,null,"Intersección=",-0.18720000000000001,"D log(t/t')=",{"$f":"LOG(G3/H3)","v":1},null,null,"t (h)=",1,null,"Dep (m)=",{"$f":"2*N4","v":5.2262160030720844E-2},{"$f":"+O7*60","v":1.44},{"$f":"+P7*60","v":3.54}]
["r (m)=",null,25,null,null,"D x=",{"$f":"+G4-H4","v":1.0799999999999998},null,null,null,null,75,null,null,{"$f":"+O7*3600","v":86.4},{"$f":"+P7*3600","v":212.39999999999998}]
["t (min)","t' (min)","x' (m)","t/t' ","Apr. Lineal","T(m2/s)=",{"$f":"2.303/(4*PI()*G6)*B2/3600*G5","v":2.2154179777790443E-3},null,null,"Q (m3/s)=","xp (m)","xp/Q(s/m2)","Q(m3/s)",1.2E-2,2.4E-2,5.8999999999999997E-2]
[0,"-","-",null,null,null,null,null,null,null,null,null,"t (d)",null,"Q/ xp"]
[44,0,2.44,100,{"$f":"+$E$5+$E$4*LN(D9)","v":2.0449259891484282},null,null,null,null,null,null,null,1,{"$f":"1/(2.303/(4*PI()*$K$3)*LOG(2.25*$K$3*$M9*24*3600/($K$4*$N$4^2))+$P$4*N$7)","v":3.4646248775767573E-2},{"$f":"1/(2.303/(4*PI()*$K$3)*LOG(2.25*$K$3*$M9*24*3600/($K$4*$N$4^2))+$P$4*O$7)","v":3.0108553138671904E-2},{"$f":"1/(2.303/(4*PI()*$K$3)*LOG(2.25*$K$3*$M9*24*3600/($K$4*$N$4^2))+$P$4*P$7)","v":2.1786182148167615E-2}]
[45,1,1.69,{"$f":"+A10/B10","v":45},{"$f":"+$E$5+$E$4*LN(D10)","v":1.657889308791674},null,null,null,null,8.1000000000000003E-2,4,{"$f":"+K10/J10","v":49.382716049382715},2,{"$f":"1/(2.303/(4*PI()*$K$3)*LOG(2.25*$K$3*$M10*24*3600/($K$4*$N$4^2))+$P$4*N$7)","v":3.3750275830607399E-2},{"$f":"1/(2.303/(4*PI()*$K$3)*LOG(2.25*$K$3*$M10*24*3600/($K$4*$N$4^2))+$P$4*O$7)","v":2.9429606425729886E-2},2.1428470037104842E-2]
[46,2,1.3,{"$f":"+A11/B11","v":23},{"$f":"+$E$5+$E$4*LN(D11)","v":1.3325740464608589},null,null,null,null,5.8999999999999997E-2,2.4,{"$f":"+K11/J11","v":40.677966101694913},3,3.3247327416529894E-2,2.9046458029763602E-2,2.1224615504682857E-2]
[47,3,1.1399999999999999,15.666666666666666,1.1464691662314326,null,null,null,null,2.4E-2,0.76,{"$f":"+K12/J12","v":31.666666666666668},5,3.263463284270355E-2,2.8577720923051636E-2,2.0973245167388639E-2]
[48,4,1.01,12,1.0172342531522438,null,null,null,null,0,0.09,"-",10,3.183848723140225E-2,2.7965357397646655E-2,2.0641527339777567E-2]
[49,5,0.91,9.8000000000000007,0.91907074233741226,null,null,null,null,null,null,null,20,3.108026163654725E-2,2.7378686780935274E-2,2.0320139191423E-2]
[50,6,0.84,8.3333333333333339,0.8404917359961841,null,null,null,null,null,null,null,30,3.0653239469385984E-2,2.7046778918284872E-2,2.0136736735525167E-2]
[51,7,0.78,7.2857142857142856,0.77537323493437038,null,null,null,null,null,null,null,50,3.0131674743731202E-2,2.6639907828857067E-2,1.9910336819218714E-2]
[52,8,0.73,6.5,0.72006251514420128,null,null,null,null,null,null,null,100,2.9451696622999905E-2,2.6107001278899398E-2,1.9611149618861713E-2]
[54,10,0.63,5.4,0.63019757279548994,null,null,null,null,null,null,null,200,2.88017311891379E-2,2.5594997193223022E-2,1.9320820913219454E-2]
[56,12,0.56000000000000005,4.666666666666667,0.5594537113470831,null,null,null,null,null,null,null,300,2.8434655235431792E-2,2.5304698137361241E-2,1.9154940253883992E-2]
[58,14,0.51,4.1428571428571432,0.50174563954733364,null,null,null,null,null,null,null,400,2.8179834309392107E-2,2.5102689424532122E-2,1.9038963011197455E-2]
[61,17,0.43,3.5882352941176472,0.43208205410075606,null,null,null,null,null,null,null,500,2.798530337010437E-2,2.4948206736891243E-2,1.8949966707207989E-2]
[64,20,0.38,3.2,0.37657919751281355,null,null,null,null,null,null,null,700,2.7697001212199753E-2,2.4718828430797719E-2,1.8817333686293784E-2]
[67,23,0.33,2.9130434782608696,0.33104046615794247,null,null,null,null,null,null,null,1000,2.7397804373233071E-2,2.4480238550571947E-2,1.8678749278779379E-2]
[71,26,0.28999999999999998,2.7307692307692308,0.29972154442291321]
[75,31,0.24,2.4193548387096775,0.24103289061709929]
[80,36,0.21,2.2222222222222223,0.19983668035675392]
[88,44,0.15,2,0.14876843841740547]
[null,null,null,1.48,2.8227999450386732E-3]

{"sheet":"pROB-selecc-bomba","index":2,"n_rows":25,"n_cols":14,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["Problema 1.","Selección de bombas",null,null,"u(m/s)=",1.5,"L (m)=",93,"H (m)=",{"$f":"+J20","v":84.79837925097172},"t (h)=",{"$f":"30*24","v":720}]
["Q(L/s)=",10,{"$f":"+B2/1000*3600","v":36},"m3/h","D (m)=",{"$f":"+SQRT(4*C2/3600*1/(F1*PI()))","v":9.2131773192356131E-2},"zD (m)=",80,"Cogeríamos ",6,"que está más próximo"]
["T (m2/s)=",{"$f":"34/3600","v":9.4444444444444445E-3},null,null,"Dc (m)=",0.09,null,"Q/ xp","Rdto =",0.73,"Pabs (CV/fase)=",2.9,"Pabs (kW)=",{"$f":"+L3*735*J2/1000","v":12.789}]
["S=",{"$f":"6*10^(-4)","v":6.0000000000000006E-4},"rep (m)=",0.12,"k (m)=",{"$f":"3*0.00001","v":3.0000000000000004E-5},"t (1mes)=",{"$f":"+D15","v":4.7113516392393064E-3},"Pabs (kW)=",{"$f":"9806*J1*G20/J3*1/1000","v":11.39086173883601},"CE (pta/(kW*h))=",10,"P (kW)=",{"$f":"+N3*J3","v":9.3359699999999997}]
[null,null,"C(s2/m5)=",2200,null," Q(m3/h)"," Q(m3/s)"," xp(m)","hfs (m)","H (m)","C (pta/m^3)=",{"$f":"9806/J3*J1*1/(3.6*10^6)*L4","v":3.1641282607877801}]
[null,null,null,null,null,{"$f":"+G6*3600","v":0},0,{"$f":"+G6/$H$4","v":0},0,{"$f":"+$H$2+H6+I6","v":80},"V (m3/mes)=",{"$f":"+G20*L1*3600","v":25920}]
[null,null,"Q(m3/s)",{"$f":"36/3600","v":0.01},null,{"$f":"+G7*3600","v":3.6},1E-3,{"$f":"+G7/$H$4","v":0.2122533142445423},{"$f":"1.1*$H$1*IWC(G7,$F$3,$F$4,10^(-6))","v":4.1274914346450087E-2},{"$f":"+$H$2+H7+I7","v":80.253528228590994},"C (pta/m^3)=",{"$f":"+N3*L1/L6*L4","v":3.5525000000000002}]
[{"$f":"300*0.001/60","v":5.0000000000000001E-3},null,"t (d)","Q/ xp(m2/s)",null,7.2,2E-3,0.4245066284890846,{"$f":"1.1*$H$1*IWC(G8,$F$3,$F$4,10^(-6))","v":0.1412723545982201},80.565778983087299]
[null,null,1,{"$f":"1/(2.303/(4*PI()*$B$3)*LOG(2.25*$B$3*$C9*24*3600/($B$4*$D$4^2))+$D$5*D$7)","v":5.4469146757948964E-3},null,10.8,3.0000000000000001E-3,0.6367599427336269,{"$f":"1.1*$H$1*IWC(G9,$F$3,$F$4,10^(-6))","v":0.29291970896599806},80.92967965169963]
[null,null,2,5.2789509015276825E-3,null,14.4,4.0000000000000001E-3,0.84901325697816921,{"$f":"1.1*$H$1*IWC(G10,$F$3,$F$4,10^(-6))","v":0.49365672259508131},81.342669979573245]
[null,null,3,5.1854153676318491E-3,null,18,5.0000000000000001E-3,1.0612665712227116,0.74207278899497575,81.803339360217691]
[null,null,5,5.0721900083113636E-3,null,21.6,6.0000000000000001E-3,1.2735198854672538,1.0372719786757787,82.310791864143027]
[null,null,10,4.9262320402451787E-3,null,24,{"$f":"+F13/3600","v":6.6666666666666671E-3},1.4150220949636154,1.2597527099637116,{"$f":"+$H$2+H13+I13","v":82.674774804927324}]
[null,null,20,4.7884393172193613E-3,null,25.2,7.0000000000000001E-3,1.4857731997117962,1.3786423559821004,82.864415555693895]
[null,null,30,4.7113516392393064E-3,null,27,{"$f":"+F15/3600","v":7.4999999999999997E-3},1.5918998568340672,1.5664970287633493,83.158396885597412]
[null,null,50,4.6176956684708479E-3,null,28.8,8.0000000000000002E-3,1.6980265139563384,1.7657371510116466,83.463763664967985]
[null,null,100,4.4964102295194184E-3,null,30,{"$f":"30/3600","v":8.3333333333333332E-3},1.7687776187045192,1.9048698920976646,83.673647510802184]
[null,null,200,4.3813329426446454E-3,null,32.4,8.9999999999999993E-3,1.9102798282008806,2.1982240574301435,84.108503885631023]
[null,null,300,4.3167073820611045E-3,null,33,{"$f":"33/3600","v":9.1666666666666667E-3},1.9456553805749712,2.2746994005289842,84.220354781103964]
[null,null,400,4.2719990441699848E-3,null,36,0.01,2.1225331424454232,2.675846108526303,84.79837925097172]
[null,null,null,null,null,39,{"$f":"+F21/3600","v":1.0833333333333334E-2},2.299410904315875,3.1081952573149874,85.407606161630866]
[null,null,null,null,null,39.599999999999994,1.0999999999999999E-2,2.3347864566899652,3.1984006793087918,85.533187135998759]
[null,null,null,null,null,42,{"$f":"+F23/3600","v":1.1666666666666667E-2},2.4762886661863268,3.5716512453589759,86.047939911545299]
[null,null,null,null,null,43.2,1.2E-2,2.5470397709345076,3.765718419258925,86.312758190193435]
[null,null,null,null,null,45,{"$f":"+F25/3600","v":1.2500000000000001E-2},2.653166428056779,4.0661266185977381,86.719293046654514]

{"sheet":"cURVATIPO","index":12,"n_rows":95,"n_cols":5,"rows_kept":95,"cut":false,"hidden":false,"merged":[]}
["1 /u","W(u)",null,"u","W(u)"]
[{"$f":"1/D2","v":10000},8.6332000000000004,null,1E-4,8.6332000000000004]
[9090.9090909090901,8.5379000000000005,null,1.1E-4,8.5379000000000005]
[8333.3333333333339,8.4509000000000007,null,1.2E-4,8.4509000000000007]
[7692.3076923076933,8.3709000000000007,null,1.2999999999999999E-4,8.3709000000000007]
[7142.8571428571431,8.2967999999999993,null,1.3999999999999999E-4,8.2967999999999993]
[6666.6666666666661,8.2278000000000002,null,1.5000000000000001E-4,8.2278000000000002]
[6249.9999999999991,8.1633999999999993,null,1.6000000000000001E-4,8.1633999999999993]
[5882.3529411764703,8.1027000000000005,null,1.7000000000000001E-4,8.1027000000000005]
[5555.5555555555557,8.0455000000000005,null,1.8000000000000001E-4,8.0455000000000005]
[5263.1578947368416,7.9915000000000003,null,1.9000000000000001E-4,7.9915000000000003]
[5000,7.9401999999999999,null,2.0000000000000001E-4,7.9401999999999999]
[3333.333333333333,7.5347999999999997,null,3.0000000000000003E-4,7.5347999999999997]
[2500,7.2472000000000003,null,4.0000000000000002E-4,7.2472000000000003]
[2000,7.0242000000000004,null,5.0000000000000001E-4,7.0242000000000004]
[1666.6666666666665,6.8419999999999996,null,6.0000000000000006E-4,6.8419999999999996]
[1428.5714285714287,6.6879,null,6.9999999999999999E-4,6.6879]
[1250,6.5545,null,8.0000000000000004E-4,6.5545]
[1111.1111111111111,6.4367999999999999,null,9.0000000000000008E-4,6.4367999999999999]
[1010.1010101010102,6.3415999999999997,null,9.8999999999999999E-4,6.3415999999999997]
[1000,6.3315000000000001,null,1E-3,6.3315000000000001]
[909.09090909090901,6.2363,null,1.1000000000000001E-3,6.2363]
[833.33333333333326,6.1494,null,1.2000000000000001E-3,6.1494]
[769.23076923076917,6.0694999999999997,null,1.3000000000000002E-3,6.0694999999999997]
[714.28571428571433,5.9954999999999998,null,1.4E-3,5.9954999999999998]
[666.66666666666663,5.9265999999999996,null,1.5E-3,5.9265999999999996]
[625,5.8620999999999999,null,1.6000000000000001E-3,5.8620999999999999]
[588.23529411764707,5.8015999999999996,null,1.7000000000000001E-3,5.8015999999999996]
[555.55555555555554,5.7446000000000002,null,1.8000000000000002E-3,5.7446000000000002]
[526.31578947368416,5.6905999999999999,null,1.9E-3,5.6905999999999999]
[500,5.6394000000000002,null,2E-3,5.6394000000000002]
[333.33333333333331,5.2348999999999997,null,3.0000000000000001E-3,5.2348999999999997]
[250,4.9481999999999999,null,4.0000000000000001E-3,4.9481999999999999]
[{"$f":"1/D34","v":200},4.7260999999999997,null,5.0000000000000001E-3,4.7260999999999997]
[166.66666666666666,4.5448000000000004,null,6.0000000000000001E-3,4.5448000000000004]
[142.85714285714286,4.3916000000000004,null,7.0000000000000001E-3,4.3916000000000004]
[125,4.2591000000000001,null,8.0000000000000002E-3,4.2591000000000001]
[111.1111111111111,4.1422999999999996,null,9.0000000000000011E-3,4.1422999999999996]
[101.010101010101,4.0479000000000003,null,9.9000000000000008E-3,4.0479000000000003]
[100,4.0378999999999996,null,0.01,4.0378999999999996]
[90.909090909090907,3.9436,null,1.1000000000000001E-2,3.9436]
[83.333333333333329,3.8576000000000001,null,1.2E-2,3.8576000000000001]
[76.92307692307692,3.7785000000000002,null,1.3000000000000001E-2,3.7785000000000002]
[71.428571428571431,3.7054,null,1.4E-2,3.7054]
[66.666666666666671,3.6374,null,1.4999999999999999E-2,3.6374]
[62.5,3.5739000000000001,null,1.6E-2,3.5739000000000001]
[58.823529411764703,3.5143,null,1.7000000000000001E-2,3.5143]
[55.55555555555555,3.4581,null,1.8000000000000002E-2,3.4581]
[52.631578947368425,3.4049999999999998,null,1.9E-2,3.4049999999999998]
[50,3.3546999999999998,null,0.02,3.3546999999999998]
[33.333333333333336,2.9590999999999998,null,0.03,2.9590999999999998]
[25,2.6812999999999998,null,0.04,2.6812999999999998]
[20,2.4679000000000002,null,0.05,2.4679000000000002]
[16.666666666666668,2.2953000000000001,null,0.06,2.2953000000000001]
[14.285714285714285,2.1507999999999998,null,7.0000000000000007E-2,2.1507999999999998]
[12.5,2.0268999999999999,null,0.08,2.0268999999999999]
[11.111111111111111,1.9187000000000001,null,0.09,1.9187000000000001]
[10.1010101010101,1.8320000000000001,null,9.9000000000000005E-2,1.8320000000000001]
[10,1.8229,null,0.1,1.8229]
[9.0909090909090917,1.7371000000000001,null,0.11,1.7371000000000001]
[8.3333333333333339,1.6595,null,0.12,1.6595]
[7.6923076923076916,1.5889,null,0.13,1.5889]
[7.1428571428571423,1.5241,null,0.14000000000000001,1.5241]
[6.666666666666667,1.4644999999999999,null,0.15,1.4644999999999999]
[6.25,1.4092,null,0.16,1.4092]
[{"$f":"1/D66","v":5.8823529411764701},1.3577999999999999,null,0.17,1.3577999999999999]
[5.5555555555555554,1.3089,null,0.18,1.3089]
[5.2631578947368425,1.2648999999999999,null,0.19,1.2648999999999999]
[5,1.2226999999999999,null,0.2,1.2226999999999999]
[3.3333333333333335,0.90569999999999995,null,0.3,0.90569999999999995]
[2.5,0.70240000000000002,null,0.4,0.70240000000000002]
[2,0.55979999999999996,null,0.5,0.55979999999999996]
[1.6666666666666667,0.45540000000000003,null,0.6,0.45540000000000003]
[1.4285714285714286,0.37380000000000002,null,0.7,0.37380000000000002]
[1.25,0.31059999999999999,null,0.8,0.31059999999999999]
[1.1111111111111112,0.26019999999999999,null,0.9,0.26019999999999999]
[1.0101010101010102,0.22309999999999999,null,0.99,0.22309999999999999]
[1,0.21940000000000001,null,1,0.21940000000000001]
[0.90909090909090906,0.186,null,1.1000000000000001,0.186]
[0.83333333333333337,0.15840000000000001,null,1.2,0.15840000000000001]
[0.76923076923076916,0.13550000000000001,null,1.3,0.13550000000000001]
[0.7142857142857143,0.1162,null,1.4,0.1162]
[0.66666666666666663,0.1,null,1.5,0.1]
[0.625,8.6309999999999998E-2,null,1.6,8.6309999999999998E-2]
[0.58823529411764708,7.4650000000000008E-2,null,1.7,7.4650000000000008E-2]
[0.55555555555555558,6.4710000000000004E-2,null,1.8,6.4710000000000004E-2]
[0.52631578947368418,5.62E-2,null,1.9,5.62E-2]
[0.33333333333333331,1.3050000000000001E-2,null,3,1.3050000000000001E-2]
[0.25,3.7789999999999998E-3,null,4,3.7789999999999998E-3]
[0.2,1.1479999999999999E-3,null,5,1.1479999999999999E-3]
[0.16666666666666666,3.6010000000000003E-4,null,6,3.6010000000000003E-4]
[0.14285714285714285,1.155E-4,null,7,1.155E-4]
[0.125,3.7669999999999997E-5,null,8,3.7669999999999997E-5]
[0.1111111111111111,1.2449999999999999E-5,null,9,1.2449999999999999E-5]
[0.10101010101010101,4.6369999999999998E-6,null,9.9,4.6369999999999998E-6]