{"text_format":"3","workbook":"xlsx","n_sheets":9,"sheets":["Volumen R01","Volumen R02","Diseño R","AnexoI","AnexoII","AnexoIII","AnexoIV","AnexoV","AnexoVI"],"not_rendered":{"charts":26,"images":26,"macros":1,"defined_names":12,"comments":3},"read":"whole","date_system":"1900"}

{"sheet":"Volumen R01","index":0,"n_rows":84,"n_cols":27,"rows_kept":84,"merged":[[2,0,2,13],[6,0,6,20],[9,1,9,19],[13,5,13,6],[13,10,13,11],[13,15,13,16],[15,5,15,6],[15,15,15,16],[17,5,17,7],[17,9,17,10],[21,1,21,3],[21,4,21,10],[21,14,21,16],[21,23,21,25],[22,1,22,3],[22,4,22,5],[22,6,22,7],[22,8,22,9],[22,14,22,16],[23,4,23,5],[23,6,23,7],[23,8,23,9],[23,14,23,15],[24,4,24,5],[24,6,24,7],[24,8,24,9],[24,14,24,15],[25,4,25,5],[25,6,25,7],[25,8,25,9],[26,4,26,5],[26,6,26,7],[26,8,26,9],[26,17,26,18],[30,5,30,6],[31,5,31,6],[32,5,32,6],[34,5,34,6],[34,14,34,15],[36,8,36,9],[36,10,36,11],[40,12,40,13],[44,5,44,6],[44,16,44,17],[45,17,45,18],[46,5,46,7],[46,8,46,9],[47,5,47,7],[47,8,47,9],[51,1,51,2],[51,3,51,4],[51,5,51,8],[51,11,51,12],[51,13,51,14],[51,15,51,18],[53,10,53,11],[55,7,55,9],[55,10,55,11],[55,12,55,13],[56,7,56,9],[56,10,56,11],[56,12,56,13],[60,9,60,11],[67,4,67,5],[67,14,67,15],[69,8,69,9],[69,10,69,11],[71,2,71,3],[71,4,71,5],[71,14,71,15],[71,16,71,17],[73,5,73,15],[77,9,77,10],[79,9,79,10],[79,14,79,15],[79,16,79,17],[81,9,81,10],[83,9,83,10]]}
[]
[]
["Grupo Crixuz Ingenieria y Construccion S.A.C."]
[{"$nulls":3},"Cel:","#942656792"]
[{"$nulls":3},"Correo:","grupo_crixuz@hotmail.com"]
[{"$nulls":3},"G. General :","Max J. Cardenas Alarcon"]
["Hoja de cálculo que se distribuye de manera condicional, dar el crédito a Crixuz Ingenieria y Construccion SAC, no se tienen restricciones adicionales"]
[]
[]
[null,"ANALISIS Y DISEÑO DE RESERVORIOS RECTANGULARES - VOLUMEN DEL RESERVORIO"]
[]
["01","CÁLCULO DE LA POBLACION FUTURA"]
[]
[null,"Población Actual   :",null,null,"Pa=",null,null,"habitantes",{"$nulls":4},"Familias",null,null,{"$f":"+IFERROR(F14/K14,)","v":{"v":0,"d":"0.0"}},null,"Miembros / familias"]
[]
[null,"Tasa crecimiento:",null,null,"r=",null,null,"%",{"$nulls":3},"Periodo diseño  :",null,null,"Tr=",null,null,"años"]
[]
[null,"Población futura:",null,null,"Pf =","Pa*(1+ r/100)Tr",null,null,"=",{"$f":"+IFERROR(F14*(1+F16/100)^P16,)","v":0},null,"habitantes"]
[null,{"$f":"20+D15","v":20}]
["02","CÁLCULO DEL PROMEDIO DIARIO ANUAL (Pda)"]
[]
[{"$nulls":4},"DOTACIÓN POR CLIMAS (Lps)",{"$nulls":7},"Poblacion:"]
[null,"POBLACIÓN",null,null,"FRIO",null,"TEMPLADO",null,"CALIDO",null,"K2",null,"Clima:",{"$nulls":9},"POBLACIÓN","Frio","Templado","Cálido","K2"]
[null,null,"< 2000",null,50,null,60,null,70,null,2.5,null,"Dotación:",null,{"$f":"+IFERROR(INDEX(X24:Z27,MATCH(O22,W24:W27,0),MATCH(O23,X23:Z23,0)),)","v":0},null,"lts/hab./dia",{"$nulls":5},"< 2000",50,60,70,2.5]
[null,null,"2000-10000",null,120,null,150,null,150,null,2.5,null,"Nro Habit:",null,{"$f":"IFERROR(J18,)","v":0},null,"hab",{"$nulls":5},"2000-10000",120,150,150,2.5]
[null,null,"10000-50000",null,150,null,200,null,200,null,1.8,{"$nulls":11},"10000-50000",150,200,200,1.8]
[null,null,"> 50000",null,200,null,250,null,250,null,1.8,null,"Pda = (Dot*N°Habot) / 86400 =",{"$nulls":4},{"$f":"+IFERROR((O24*O25/86400),)","v":{"v":0,"d":"0.000"}},null,"Lt/seg",null,null,"> 50000",200,250,250,1.8]
[]
["03","CÁLCULO DE LA DEMANDA EDUCATIVA"]
[]
[null,"Nivel secundario=",{"$nulls":5},"Est."]
[null,"Nivel primario=",{"$nulls":5},"Est."]
[null,"Nivel inicial=",{"$nulls":5},"Est."]
[]
[null,"Total=",{"$nulls":3},{"$f":"IFERROR(+SUM(F31:F33),)","v":0},null,"hab",{"$nulls":3},"Demanda (RNE)=",{"$nulls":4},"L/hab/dia"]
[]
[{"$nulls":8},"Pdb=",null,{"$f":"IFERROR(F35*O35/(24*3600),)","v":{"v":0,"d":"0.000"}},null,"Lt/seg"]
[]
["04","CÁLCULO DE LA DEMANDA TOTAL"]
[]
[{"$nulls":4},"Pd=","Pda + Pdb",{"$nulls":5},"Pd=",{"$f":"IFERROR(R27+K37,)","v":{"v":0,"d":"0.000"}},null,"Lt/seg"]
[]
["05","CAUDAL MÁXIMO DIARIO (Qmax-diario)"]
[]
[{"$nulls":4},"K1 =",{"$nulls":4},"Qmax-d = Pd*K1",{"$nulls":4},"Perdidas :"]
[]
[{"$nulls":5},"Qmax-diar =",null,null,{"$f":"IFERROR((M41)*F45,)","v":{"v":0,"d":"0.000"}},null,"Lt/ Seg",null,"Sin considerar pérdidas"]
[{"$nulls":5},"Qmax-diar =",null,null,{"$f":"IFERROR(+I47+(I47*Q45),)","v":{"v":0,"d":"0.000"}},null,"Lt/ Seg",null,{"$f":"+CONCATENATE(\"Con perdidas \",Q45*100,\"%\")","v":"Con perdidas 0%"}]
[]
["06","CAUDAL MÁXIMO HORARIO (Qmax-horario)"]
[]
[null,"K2  =",null,{"v":1.8,"d":"1.80"},null,"> 10000 Habitantes",{"$nulls":5},"K2  =",null,{"v":2.5,"d":"2.50"},null,"<  10000 Habitantes"]
[]
[{"$nulls":9},"K2 =",{"$f":"IFERROR(+VLOOKUP(O22,W24:AA27,5,FALSE),)","v":0}]
[]
[{"$nulls":7},"Qmax-hora  =",null,null," (K2* Qm)",null,"Lt/ Seg"]
[{"$nulls":7},"Qmax-hora  =",null,null,{"$f":"IFERROR(M41*N52,)","v":{"v":0,"d":"0.00"}},null,"Lt/ Seg"]
[]
["07","CÁLCULO DEL VOLUMEN DEL RESERVORIO (M3)"]
[]
[{"$nulls":9},"Valmace = Vr + VR"]
[]
[null,"Donde:"]
[]
[{"$nulls":3},"Vr = Volumen de Regulación ",{"$nulls":9},"VR = Volumen de Reserva"]
[{"$nulls":3},"Vr =",null,"x Qmd x 86.40",{"$nulls":7},"VR =",null,"x Qmd x 86.40"]
[]
[{"$nulls":3},"Vr :",{"$f":"IFERROR((I48*E66)*86.4,)","v":{"v":0,"d":"0.00"}},null,"m3",{"$nulls":6},"VR :",{"$f":"IFERROR((I48*O66)*86.4,)","v":{"v":0,"d":"0.00"}},null,"m3"]
[]
[{"$nulls":8},"V. almace:",null,{"$f":"IFERROR(SUM(E68+O68),)","v":{"v":0,"d":"0.00"}},null,"m3"]
[]
[null,null,"Intervalo :",{"$nulls":3},"m3",{"$nulls":7},"V. diseño:",null,{"$f":"IFERROR(+E72*(ROUNDUP(K70/E72,0)),)","v":{"v":0,"d":"0.00"}},null,"m3"]
[]
[{"$nulls":5},{"$f":"IFERROR(+CONCATENATE(\"Por lo tanto se Proyectara un Reservorio de \",Q72,\"m3 de Almacenamiento\"),)","v":"Por lo tanto se Proyectara un Reservorio de 0m3 de Almacenamiento"}]
[]
["08","DIMENSIONES DEL RESERVORIO"]
[]
[null,null,"Volumen de diseño reserv. :",{"$nulls":5},"V =",{"$f":"IFERROR(+Q72,)","v":{"v":0,"d":"0.00"}},null,"m3"]
[]
[null,null,"Altura de agua en el reserv :",{"$nulls":5},"h =",null,null,"m",null,null,"Intervalo :",{"$nulls":3},"m3"]
[]
[null,null,"Longitud muro (cuadrado) :",{"$nulls":5},"L =",{"$f":"IFERROR(Q80*(ROUNDUP(SQRT(J78/J80)/Q80,0)),)","v":{"v":0,"d":"0.00"}},null,"m"]
[]
[null,null,"Volumen final del reservorio :",{"$nulls":5},"V' =",{"$f":"IFERROR(+J82*J82*J80,)","v":{"v":0,"d":"0.00"}},null,"m3"]

{"sheet":"Volumen R02","index":1,"n_rows":79,"n_cols":41,"rows_kept":79,"merged":[[2,0,2,18],[6,0,6,27],[9,1,9,26],[13,8,13,9],[13,21,13,22],[17,2,17,26],[28,24,28,25],[32,24,32,25],[36,24,36,25],[40,24,40,25],[44,2,44,3],[44,4,44,5],[44,6,44,7],[44,8,44,9],[44,10,44,11],[45,2,45,3],[45,4,45,5],[45,6,45,7],[45,8,45,9],[45,10,45,11],[46,2,46,3],[46,4,46,5],[46,6,46,7],[46,8,46,9],[46,10,46,11],[47,2,47,3],[47,4,47,5],[47,6,47,7],[47,8,47,9],[47,10,47,11],[48,2,48,3],[48,4,48,5],[48,6,48,7],[48,8,48,9],[48,10,48,11],[49,2,49,3],[49,4,49,5],[49,6,49,7],[49,8,49,9],[49,10,49,11],[50,2,50,3],[50,4,50,5],[50,6,50,7],[50,8,50,9],[50,10,50,11],[51,2,51,3],[51,4,51,5],[51,6,51,7],[51,8,51,9],[51,10,51,11],[52,2,52,3],[52,4,52,5],[52,6,52,7],[52,8,52,9],[52,10,52,11],[53,2,53,3],[53,4,53,5],[53,6,53,7],[53,8,53,9],[53,10,53,11],[54,2,54,3],[54,4,54,5],[54,6,54,7],[54,8,54,9],[54,10,54,11],[55,2,55,3],[55,4,55,5],[55,6,55,7],[55,8,55,9],[55,10,55,11],[56,2,56,3],[56,4,56,5],[56,6,56,7],[56,8,56,9],[56,10,56,11],[57,2,57,3],[57,4,57,5],[57,6,57,7],[57,8,57,9],[57,10,57,11],[58,2,58,3],[58,4,58,5],[58,6,58,7],[58,8,58,9],[58,10,58,11],[59,2,59,3],[59,4,59,5],[59,6,59,7],[59,8,59,9],[59,10,59,11],[60,2,60,3],[60,4,60,5],[60,6,60,7],[60,8,60,9],[60,10,60,11],[61,2,61,3],[61,4,61,5],[61,6,61,7],[61,8,61,9],[61,10,61,11],[62,2,62,3],[62,4,62,5],[62,6,62,7],[62,8,62,9],[62,10,62,11],[63,2,63,3],[63,4,63,5],[63,6,63,7],[63,8,63,9],[63,10,63,11],[64,2,64,3],[64,4,64,5],[64,6,64,7],[64,8,64,9],[64,10,64,11],[65,2,65,3],[65,4,65,5],[65,6,65,7],[65,8,65,9],[65,10,65,11],[66,2,66,3],[66,4,66,5],[66,6,66,7],[66,8,66,9],[66,10,66,11],[67,2,67,3],[67,4,67,5],[67,6,67,7],[67,8,67,9],[67,10,67,11],[68,2,68,3],[68,4,68,5],[68,6,68,7],[68,8,68,9],[68,10,68,11],[69,2,69,3],[69,4,69,5],[69,6,69,7],[69,8,69,9],[69,10,69,11],[70,2,70,3],[70,4,70,5],[70,6,70,7],[70,8,70,9],[70,10,70,11],[72,6,72,8],[72,14,72,15],[72,22,72,24],[74,6,74,8],[74,14,74,15],[74,22,74,24],[76,6,76,7],[76,23,76,24],[78,7,78,8],[78,10,78,11],[78,13,78,14],[78,22,78,24]]}
[]
[]
["Grupo Crixuz Ingenieria y Construccion S.A.C."]
[{"$nulls":5},"Cel:","#942656792"]
[{"$nulls":5},"Correo:","grupo_crixuz@hotmail.com"]
[{"$nulls":5},"G. General :","Max J. Cardenas Alarcon"]
["Hoja de cálculo que se distribuye de manera condicional, dar el crédito a Crixuz Ingenieria y Construccion SAC, no se tienen restricciones adicionales"]
[]
[]
[null,"ANALISIS Y DISEÑO DE RESERVORIOS RECTANGULARES - VOLUMEN DEL RESERVORIO"]
[]
["01","CAUDAL DE DEMANDA"]
[]
[{"$nulls":3},"Demanda diaria :",{"$nulls":3},"Qd=",null,null,"lt/seg",{"$nulls":5},"Demanda horaria :",{"$nulls":3},"Qh=",null,null,"lt/seg"]
[]
["02","REGISTRO DE VARIACION HORARIA DURANTE EL DIA DE MAXIMO CONSUMO",{"$nulls":19},"Insertar Filas :",{"$nulls":3},{"$f":"6+MATCH(\"xxx\",A7:A80,0)","v":22}]
[]
[null,null,"VARIACIONES HORARIAS DEL MAXIMO CONSUMO"]
[null,"N°",0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24]
[null,{"$f":"+ROW(A20)-19","v":1},{"$nulls":25},"--"]
[null,{"$f":"+ROW(A21)-19","v":2},{"$nulls":25},"--"]
["xxx",3,{"$nulls":25},"--"]
[null,"MAX",{"$f":"+MAX(C20:C22)","v":{"v":0,"d":"0.0"}},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"}]
[]
["03","CURVA DE VARIACIONES HORARIAS DEL DIA DE MAXIMO CONSUMO"]
[]
[{"$nulls":22},"Consumo Maximo Horario"]
[]
[{"$nulls":23},"Qmax=",{"$f":"+MAX(C23:AA23)","v":{"v":0,"d":"0.00"}},null,"lt/seg",null,null,0,{"$f":"+Y29","v":{"v":0,"d":"0.00"}}]
[{"$nulls":29},24,{"$f":"+Y29","v":{"v":0,"d":"0.00"}}]
[{"$nulls":22},"Consumo Medio del Dia"]
[]
[{"$nulls":23},"Qmax=",{"$f":"+AVERAGE(C23:AA23)","v":{"v":0,"d":"0.00"}},null,"lt/seg",null,null,0,{"$f":"+Y33","v":{"v":0,"d":"0.00"}}]
[{"$nulls":29},24,{"$f":"+Y33","v":{"v":0,"d":"0.00"}}]
[{"$nulls":22},"Consumo Medio"]
[]
[{"$nulls":23},"Qmax=",{"$f":"+Y29-Y33","v":{"v":0,"d":"0.00"}},null,"lt/seg",null,null,0,{"$f":"+Y37","v":{"v":0,"d":"0.00"}}]
[{"$nulls":29},24,{"$f":"+Y37","v":{"v":0,"d":"0.00"}}]
[{"$nulls":22},"Demanda"]
[]
[{"$nulls":23},"Qd=",{"$f":"+I14","v":{"v":0,"d":"0.000"}},null,"lt/seg"]
[]
["04","CURVA DE CONSUMOS ACUMULADOS, OBTENIDO DE LA CURVA DE VARIACIONES HORARIAS"]
[]
[null,null,"Tiempo",null,"Consumo",null,"Volumen",null,"Vol. Acu.",null,"Cambio"]
[null,null,"Horas",null,"lt/seg",null,"m3",null,"m3",null,"Pendient"]
[null,null,0,null,{"$f":"+AD47","v":{"v":0,"d":"0.00"}},null,{"$f":"+E47*60*60/1000","v":{"v":0,"d":"0.000"}},null,{"$f":"+G47","v":{"v":0,"d":"0.0"}},null,{"$f":"+AK47","v":{"v":0,"d":"0.0"}},{"$nulls":18},{"$f":"+TRANSPOSE(C23:AA23)","v":{"v":0,"d":"0.00"}},0,{"$f":"+I47","v":{"v":0,"d":"0.000"}},{"$f":"+C47","v":0},{"$f":"+AF47","v":{"v":0,"d":"0.000"}},{"$f":"+IF(K47<=0,K47/MIN($K$47:$L$71),1+K47/MAX($K$47:$L$71))","v":{"$error":"#DIV/0!"}},{"$f":"+AG47","v":0},{"$f":"+ROUND(I47-AH47,3)","v":{"v":0,"d":"0.000"}},{"$f":"+AJ47","v":0},{"$f":"AH47-ABS($G$73)","v":{"v":0,"d":"0.000"}},{"$f":"+AJ47","v":0},{"$f":"AH47+ABS($G$75)","v":{"v":0,"d":"0.000"}}]
[null,null,1,null,{"$f":"+AD48","v":{"v":0,"d":"0.00"}},null,{"$f":"+E48*60*60/1000","v":{"v":0,"d":"0.000"}},null,{"$f":"+G48+I47","v":{"v":0,"d":"0.0"}},null,{"v":0,"d":"0.0"},{"$nulls":18},{"v":0,"d":"0.00"},24,{"$f":"+I71","v":{"v":0,"d":"0.000"}},{"$f":"+C48","v":1},{"$f":"+$AH$47+(($AH$71-$AH$47)*(AG48-$AG$47)/($AG$71-$AG$47))","v":{"v":0,"d":"0.000"}},{"$f":"+IF(K48<=0,K48/MIN($K$47:$L$71),1+K48/MAX($K$47:$L$71))","v":{"$error":"#DIV/0!"}},1,{"v":0,"d":"0.000"},{"$f":"+AJ48","v":1},{"v":0,"d":"0.000"},{"$f":"+AJ48","v":1},{"v":0,"d":"0.000"}]
[null,null,2,null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.000"},null,{"$f":"+G49+I48","v":{"v":0,"d":"0.0"}},null,{"v":0,"d":"0.0"},{"$nulls":18},{"v":0,"d":"0.00"},null,null,2,{"$f":"+$AH$47+(($AH$71-$AH$47)*(AG49-$AG$47)/($AG$71-$AG$47))","v":{"v":0,"d":"0.000"}},{"$error":"#DIV/0!"},2,{"v":0,"d":"0.000"},2,{"v":0,"d":"0.000"},2,{"v":0,"d":"0.000"}]
[null,null,3,null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.000"},null,{"v":0,"d":"0.0"},null,{"v":0,"d":"0.0"},{"$nulls":18},{"v":0,"d":"0.00"},0,{"$f":"+AM47","v":{"v":0,"d":"0.000"}},3,{"v":0,"d":"0.000"},{"$error":"#DIV/0!"},3,{"v":0,"d":"0.000"},3,{"v":0,"d":"0.000"},3,{"v":0,"d":"0.000"}]
[null,null,4,null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.0"},null,{"v":0,"d":"0.0"},{"$nulls":18},{"v":0,"d":"0.00"},24,{"$f":"+AM71","v":{"v":0,"d":"0.000"}},4,{"v":0,"d":"0.000"},{"$error":"#DIV/0!"},4,{"v":0,"d":"0.000"},4,{"v":0,"d":"0.000"},4,{"v":0,"d":"0.000"}]
[null,null,5,null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.0"},null,{"v":0,"d":"0.0"},{"$nulls":18},{"v":0,"d":"0.00"},null,null,5,{"v":0,"d":"0.000"},{"$error":"#DIV/0!"},5,{"v":0,"d":"0.000"},5,{"v":0,"d":"0.000"},5,{"v":0,"d":"0.000"}]
[null,null,6,null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.0"},null,{"v":0,"d":"0.0"},{"$nulls":18},{"v":0,"d":"0.00"},0,{"$f":"+AO47","v":{"v":0,"d":"0.000"}},6,{"v":0,"d":"0.000"},{"$error":"#DIV/0!"},6,{"v":0,"d":"0.000"},6,{"v":0,"d":"0.000"},6,{"v":0,"d":"0.000"}]
[null,null,7,null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.0"},null,{"v":0,"d":"0.0"},{"$nulls":18},{"v":0,"d":"0.00"},24,{"$f":"+AO71","v":{"v":0,"d":"0.000"}},7,{"v":0,"d":"0.000"},{"$error":"#DIV/0!"},7,{"v":0,"d":"0.000"},7,{"v":0,"d":"0.000"},7,{"v":0,"d":"0.000"}]
[null,null,8,null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.0"},null,{"v":0,"d":"0.0"},{"$nulls":18},{"v":0,"d":"0.00"},null,null,8,{"v":0,"d":"0.000"},{"$error":"#DIV/0!"},8,{"v":0,"d":"0.000"},8,{"v":0,"d":"0.000"},8,{"v":0,"d":"0.000"}]
[null,null,9,null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.0"},null,{"v":0,"d":"0.0"},{"$nulls":18},{"v":0,"d":"0.00"},0,{"$f":"+W73","v":{"v":0,"d":"0.00"}},9,{"v":0,"d":"0.000"},{"$error":"#DIV/0!"},9,{"v":0,"d":"0.000"},9,{"v":0,"d":"0.000"},9,{"v":0,"d":"0.000"}]
[null,null,10,null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.0"},null,{"v":0,"d":"0.0"},{"$nulls":18},{"v":0,"d":"0.00"},{"$f":"+G77","v":0},{"$f":"+AF56","v":{"v":0,"d":"0.00"}},10,{"v":0,"d":"0.000"},{"$error":"#DIV/0!"},10,{"v":0,"d":"0.000"},10,{"v":0,"d":"0.000"},10,{"v":0,"d":"0.000"}]
[null,null,11,null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.0"},null,{"v":0,"d":"0.0"},{"$nulls":18},{"v":0,"d":"0.00"},{"$f":"+G77","v":0},{"$f":"+W75","v":{"v":0,"d":"0.00"}},11,{"v":0,"d":"0.000"},{"$error":"#DIV/0!"},11,{"v":0,"d":"0.000"},11,{"v":0,"d":"0.000"},11,{"v":0,"d":"0.000"}]
[null,null,12,null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.0"},null,{"v":0,"d":"0.0"},{"$nulls":18},{"v":0,"d":"0.00"},0,{"$f":"+AF58","v":{"v":0,"d":"0.00"}},12,{"v":0,"d":"0.000"},{"$error":"#DIV/0!"},12,{"v":0,"d":"0.000"},12,{"v":0,"d":"0.000"},12,{"v":0,"d":"0.000"}]
[null,null,13,null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.0"},null,{"v":0,"d":"0.0"},{"$nulls":18},{"v":0,"d":"0.00"},null,null,13,{"v":0,"d":"0.000"},{"$error":"#DIV/0!"},13,{"v":0,"d":"0.000"},13,{"v":0,"d":"0.000"},13,{"v":0,"d":"0.000"}]
[null,null,14,null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.0"},null,{"v":0,"d":"0.0"},{"$nulls":18},{"v":0,"d":"0.00"},null,null,14,{"v":0,"d":"0.000"},{"$error":"#DIV/0!"},14,{"v":0,"d":"0.000"},14,{"v":0,"d":"0.000"},14,{"v":0,"d":"0.000"}]
[null,null,15,null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.0"},null,{"v":0,"d":"0.0"},{"$nulls":18},{"v":0,"d":"0.00"},null,null,15,{"v":0,"d":"0.000"},{"$error":"#DIV/0!"},15,{"v":0,"d":"0.000"},15,{"v":0,"d":"0.000"},15,{"v":0,"d":"0.000"}]
[null,null,16,null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.0"},null,{"v":0,"d":"0.0"},{"$nulls":18},{"v":0,"d":"0.00"},null,null,16,{"v":0,"d":"0.000"},{"$error":"#DIV/0!"},16,{"v":0,"d":"0.000"},16,{"v":0,"d":"0.000"},16,{"v":0,"d":"0.000"}]
[null,null,17,null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.0"},null,{"v":0,"d":"0.0"},{"$nulls":18},{"v":0,"d":"0.00"},null,null,17,{"v":0,"d":"0.000"},{"$error":"#DIV/0!"},17,{"v":0,"d":"0.000"},17,{"v":0,"d":"0.000"},17,{"v":0,"d":"0.000"}]
[null,null,18,null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.0"},null,{"v":0,"d":"0.0"},{"$nulls":18},{"v":0,"d":"0.00"},null,null,18,{"v":0,"d":"0.000"},{"$error":"#DIV/0!"},18,{"v":0,"d":"0.000"},18,{"v":0,"d":"0.000"},18,{"v":0,"d":"0.000"}]
[null,null,19,null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.0"},null,{"v":0,"d":"0.0"},{"$nulls":18},{"v":0,"d":"0.00"},null,null,19,{"v":0,"d":"0.000"},{"$error":"#DIV/0!"},19,{"v":0,"d":"0.000"},19,{"v":0,"d":"0.000"},19,{"v":0,"d":"0.000"}]
[null,null,20,null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.000"},null,{"v":0,"d":"0.0"},null,{"v":0,"d":"0.0"},{"$nulls":18},{"v":0,"d":"0.00"},null,null,20,{"v":0,"d":"0.000"},{"$error":"#DIV/0!"},20,{"v":0,"d":"0.000"},20,{"v":0,"d":"0.000"},20,{"v":0,"d":"0.000"}]
[null,null,21,null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.000"},null,{"v":0,"d":"0.0"},null,{"v":0,"d":"0.0"},{"$nulls":18},{"v":0,"d":"0.00"},null,null,21,{"v":0,"d":"0.000"},{"$error":"#DIV/0!"},21,{"v":0,"d":"0.000"},21,{"v":0,"d":"0.000"},21,{"v":0,"d":"0.000"}]
[null,null,22,null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.000"},null,{"v":0,"d":"0.0"},null,{"v":0,"d":"0.0"},{"$nulls":18},{"v":0,"d":"0.00"},null,null,22,{"v":0,"d":"0.000"},{"$error":"#DIV/0!"},22,{"v":0,"d":"0.000"},22,{"v":0,"d":"0.000"},22,{"v":0,"d":"0.000"}]
[null,null,23,null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.000"},null,{"v":0,"d":"0.0"},null,{"v":0,"d":"0.0"},{"$nulls":18},{"v":0,"d":"0.00"},null,null,23,{"v":0,"d":"0.000"},{"$error":"#DIV/0!"},23,{"v":0,"d":"0.000"},23,{"v":0,"d":"0.000"},23,{"v":0,"d":"0.000"}]
[null,null,24,null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.000"},null,{"v":0,"d":"0.0"},null,{"v":0,"d":"0.0"},{"$nulls":18},{"v":0,"d":"0.00"},null,null,24,{"$f":"+AF48","v":{"v":0,"d":"0.000"}},{"$error":"#DIV/0!"},24,{"v":0,"d":"0.000"},24,{"v":0,"d":"0.000"},24,{"v":0,"d":"0.000"}]
[]
[null,"1° Cambio de Pendiente :",{"$nulls":4},{"$f":"IFERROR(+VLOOKUP(O73,AJ47:AK71,2,0),)","v":{"v":0,"d":"0.00"}},{"$nulls":3},"Tiempo d Aparicion:",{"$nulls":3},{"$f":"IFERROR(+VLOOKUP(1,AI47:AJ71,2,0),)","v":0},null,"hr",null,"Volumen regulado1:",{"$nulls":3},{"$f":"IFERROR(+VLOOKUP(G77,AL47:AM71,2,0),)","v":{"v":0,"d":"0.00"}},null,null,"m3"]
[]
[null,"2° Cambio de Pendiente :",{"$nulls":4},{"$f":"IFERROR(+VLOOKUP(O75,AJ47:AK71,2,0),)","v":0},{"$nulls":3},"Tiempo d Aparicion:",{"$nulls":3},{"$f":"IFERROR(+VLOOKUP(2,AI47:AJ71,2,0),)","v":0},null,"hr",null,"Volumen regulado2:",{"$nulls":3},{"$f":"IFERROR(+VLOOKUP(G77,AN47:AO71,2,0),)","v":{"v":0,"d":"0.00"}},null,null,"m3"]
[]
[null,"Tiempo de Aparicion :",{"$nulls":6},"hr",{"$nulls":9},"Intervalo de Volumen :",{"$nulls":6},"m3"]
[]
[null,"Volumen del Reservorio sera :",{"$nulls":5},{"$f":"IFERROR(+W75,)","v":{"v":0,"d":"0.0"}},null,"-",{"$f":"IFERROR(+W73,)","v":{"v":0,"d":"0.0"}},null,"=",{"$f":"IFERROR(+H79-K79,)","v":{"v":0,"d":"0.0"}},null,"m3",null,null,"Volumen de Diseño :",{"$nulls":3},{"$f":"IFERROR(+X77*(ROUNDUP(N79/X77,0)),)","v":{"v":0,"d":"0.00"}},null,null,"m3"]

{"sheet":"Diseño R","index":2,"n_rows":692,"n_cols":28,"rows_kept":692,"merged":[[2,0,2,13],[6,0,6,20],[9,1,9,19],[13,6,13,7],[14,6,14,7],[15,6,15,7],[16,6,16,7],[17,6,17,7],[18,6,18,7],[19,6,19,7],[20,6,20,7],[21,6,21,7],[22,6,22,7],[23,6,23,7],[24,6,24,7],[25,6,25,7],[27,6,27,7],[27,16,27,18],[28,6,28,7],[28,12,28,19],[38,8,38,9],[38,13,38,18],[39,8,39,9],[41,15,41,16],[45,3,46,3],[45,4,46,4],[45,5,45,8],[45,9,45,12],[45,13,45,16],[46,5,46,6],[46,7,46,8],[46,9,46,10],[46,11,46,12],[46,13,46,14],[46,15,46,16],[47,3,51,3],[47,5,47,6],[47,7,47,8],[47,9,47,10],[47,11,47,12],[47,13,47,14],[47,15,47,16],[48,5,48,6],[48,7,48,8],[48,9,48,10],[48,11,48,12],[48,13,48,14],[48,15,48,16],[49,5,49,6],[49,7,49,8],[49,9,49,10],[49,11,49,12],[49,13,49,14],[49,15,49,16],[50,5,50,6],[50,7,50,8],[50,9,50,10],[50,11,50,12],[50,13,50,14],[50,15,50,16],[51,5,51,6],[51,7,51,8],[51,9,51,10],[51,11,51,12],[51,13,51,14],[51,15,51,16],[52,3,52,16],[58,3,59,3],[58,4,59,4],[58,5,58,8],[58,9,58,12],[58,13,58,16],[59,5,59,6],[59,7,59,8],[59,9,59,10],[59,11,59,12],[59,13,59,14],[59,15,59,16],[60,3,64,3],[60,5,60,6],[60,7,60,8],[60,9,60,10],[60,11,60,12],[60,13,60,14],[60,15,60,16],[61,5,61,6],[61,7,61,8],[61,9,61,10],[61,11,61,12],[61,13,61,14],[61,15,61,16],[62,5,62,6],[62,7,62,8],[62,9,62,10],[62,11,62,12],[62,13,62,14],[62,15,62,16],[63,5,63,6],[63,7,63,8],[63,9,63,10],[63,11,63,12],[63,13,63,14],[63,15,63,16],[64,5,64,6],[64,7,64,8],[64,9,64,10],[64,11,64,12],[64,13,64,14],[64,15,64,16],[65,3,65,16],[67,4,68,4],[67,15,68,15],[69,3,75,3],[73,9,73,10],[75,9,75,10],[132,15,132,17],[137,8,137,9],[137,11,137,12],[138,8,138,9],[138,11,138,12],[147,4,147,5],[149,4,149,5],[151,4,151,5],[153,4,153,5],[157,4,157,5],[157,11,157,19],[163,12,163,14],[165,3,165,4],[165,13,165,14],[169,6,169,7],[169,15,169,16],[171,4,171,5],[171,13,171,14],[173,4,173,5],[173,13,173,14],[175,7,175,8],[175,13,175,14],[177,13,177,14],[181,2,181,3],[181,4,181,5],[181,6,181,7],[181,8,181,9],[181,10,181,11],[181,12,181,13],[182,2,182,3],[182,4,182,5],[182,6,182,7],[182,8,182,9],[182,10,182,11],[182,12,182,13],[183,2,183,3],[183,4,183,5],[183,6,183,7],[183,8,183,9],[183,10,183,11],[183,12,183,13],[183,18,183,19],[185,18,185,19],[189,12,189,14],[191,3,191,4],[191,13,191,14],[195,6,195,7],[195,15,195,16],[197,4,197,5],[197,13,197,14],[199,4,199,5],[199,13,199,14],[201,7,201,8],[201,13,201,14],[203,13,203,14],[207,2,207,3],[207,4,207,5],[207,6,207,7],[207,8,207,9],[207,10,207,11],[207,12,207,13],[208,2,208,3],[208,4,208,5],[208,6,208,7],[208,8,208,9],[208,10,208,11],[208,12,208,13],[209,2,209,3],[209,4,209,5],[209,6,209,7],[209,8,209,9],[209,10,209,11],[209,12,209,13],[209,18,209,19],[215,12,215,13],[217,11,217,13],[218,7,218,9],[220,12,220,19],[222,1,222,7],[222,8,222,9],[222,10,222,11],[222,12,222,13],[222,14,222,15],[222,16,222,17],[222,18,222,19],[223,1,223,7],[223,8,223,9],[223,10,223,11],[223,12,223,13],[223,14,223,15],[223,16,223,17],[223,18,223,19],[224,1,224,7],[224,8,224,9],[224,10,224,11],[224,12,224,13],[224,14,224,15],[224,16,224,17],[224,18,224,19],[225,1,225,7],[225,8,225,9],[225,10,225,11],[225,12,225,13],[225,14,225,15],[225,16,225,17],[225,18,225,19],[226,1,226,7],[226,8,226,9],[226,10,226,11],[226,12,226,13],[226,14,226,15],[226,16,226,17],[226,18,226,19],[227,1,227,7],[227,8,227,9],[227,10,227,11],[227,12,227,13],[227,14,227,15],[227,16,227,17],[227,18,227,19],[228,1,228,7],[228,8,228,9],[228,10,228,11],[228,12,228,13],[228,14,228,15],[228,16,228,17],[228,18,228,19],[229,1,229,7],[229,8,229,9],[229,10,229,11],[229,12,229,13],[229,14,229,15],[229,16,229,17],[229,18,229,19],[230,1,230,7],[230,8,230,9],[230,10,230,11],[230,12,230,13],[230,14,230,15],[230,16,230,17],[230,18,230,19],[231,1,231,7],[231,8,231,9],[231,10,231,11],[231,12,231,13],[231,14,231,15],[231,16,231,17],[231,18,231,19],[233,10,233,11],[254,11,254,12],[254,16,254,18],[258,11,258,13],[262,4,262,6],[262,11,262,13],[262,16,262,18],[268,4,268,7],[268,14,268,15],[275,3,275,4],[275,6,275,7],[276,3,276,4],[280,4,280,5],[280,11,280,12],[280,16,280,18],[287,8,287,9],[287,17,287,18],[289,8,289,9],[289,10,289,11],[289,13,289,14],[293,7,293,8],[293,10,293,11],[293,17,293,18],[294,7,294,8],[296,14,296,15],[301,8,301,11],[303,4,303,5],[309,5,309,6],[309,8,309,9],[309,14,309,15],[310,8,310,9],[310,14,310,15],[311,14,311,15],[313,13,313,15],[319,4,319,5],[319,8,319,9],[319,16,319,17],[321,15,321,16],[323,15,323,16],[325,15,325,16],[327,1,327,19],[329,15,329,16],[335,12,335,14],[337,3,337,4],[337,13,337,14],[341,6,341,7],[341,15,341,16],[343,4,343,5],[343,13,343,14],[345,4,345,5],[345,13,345,14],[347,7,347,8],[347,13,347,14],[349,13,349,14],[353,2,353,3],[353,4,353,5],[353,6,353,7],[353,8,353,9],[353,10,353,11],[353,12,353,13],[354,2,354,3],[354,4,354,5],[354,6,354,7],[354,8,354,9],[354,10,354,11],[354,12,354,13],[355,2,355,3],[355,4,355,5],[355,6,355,7],[355,8,355,9],[355,10,355,11],[355,12,355,13],[355,18,355,19],[361,12,361,13],[363,11,363,13],[364,7,364,9],[368,11,368,13],[372,4,372,6],[372,11,372,13],[372,16,372,18],[378,4,378,7],[378,14,378,15],[385,3,385,4],[385,6,385,7],[386,3,386,4],[390,4,390,5],[390,11,390,12],[390,16,390,18],[394,15,394,16],[398,5,398,6],[398,8,398,9],[398,14,398,15],[399,5,399,6],[399,8,399,9],[399,14,399,15],[400,14,400,15],[406,14,406,15],[410,4,410,6],[410,14,410,15],[414,4,414,6],[414,14,414,15],[418,8,418,9],[418,17,418,18],[422,7,422,8],[422,17,422,18],[424,15,424,16],[428,3,429,3],[428,4,429,4],[428,5,428,8],[428,9,428,12],[428,13,428,16],[429,5,429,6],[429,7,429,8],[429,9,429,10],[429,11,429,12],[429,13,429,14],[429,15,429,16],[430,3,434,3],[430,5,430,6],[430,7,430,8],[430,9,430,10],[430,11,430,12],[430,13,430,14],[430,15,430,16],[431,5,431,6],[431,7,431,8],[431,9,431,10],[431,11,431,12],[431,13,431,14],[431,15,431,16],[432,5,432,6],[432,7,432,8],[432,9,432,10],[432,11,432,12],[432,13,432,14],[432,15,432,16],[433,5,433,6],[433,7,433,8],[433,9,433,10],[433,11,433,12],[433,13,433,14],[433,15,433,16],[434,5,434,6],[434,7,434,8],[434,9,434,10],[434,11,434,12],[434,13,434,14],[434,15,434,16],[435,3,435,16],[441,3,442,3],[441,4,442,4],[441,5,441,8],[441,9,441,12],[441,13,441,16],[442,5,442,6],[442,7,442,8],[442,9,442,10],[442,11,442,12],[442,13,442,14],[442,15,442,16],[443,3,447,3],[443,5,443,6],[443,7,443,8],[443,9,443,10],[443,11,443,12],[443,13,443,14],[443,15,443,16],[444,5,444,6],[444,7,444,8],[444,9,444,10],[444,11,444,12],[444,13,444,14],[444,15,444,16],[445,5,445,6],[445,7,445,8],[445,9,445,10],[445,11,445,12],[445,13,445,14],[445,15,445,16],[446,5,446,6],[446,7,446,8],[446,9,446,10],[446,11,446,12],[446,13,446,14],[446,15,446,16],[447,5,447,6],[447,7,447,8],[447,9,447,10],[447,11,447,12],[447,13,447,14],[447,15,447,16],[448,3,448,16],[450,4,451,4],[450,15,451,15],[452,3,458,3],[456,9,456,10],[458,9,458,10],[515,15,515,17],[517,17,517,18],[523,4,523,5],[523,8,523,9],[523,16,523,17],[525,15,525,16],[527,15,527,16],[529,15,529,16],[531,1,531,19],[533,15,533,16],[539,12,539,14],[541,3,541,4],[541,13,541,14],[545,6,545,7],[545,15,545,16],[547,4,547,5],[547,13,547,14],[549,4,549,5],[549,13,549,14],[551,7,551,8],[551,13,551,14],[553,13,553,14],[557,2,557,3],[557,4,557,5],[557,6,557,7],[557,8,557,9],[557,10,557,11],[557,12,557,13],[558,2,558,3],[558,4,558,5],[558,6,558,7],[558,8,558,9],[558,10,558,11],[558,12,558,13],[559,2,559,3],[559,4,559,5],[559,6,559,7],[559,8,559,9],[559,10,559,11],[559,12,559,13],[559,18,559,19],[565,12,565,13],[567,11,567,13],[568,7,568,9],[570,12,570,19],[572,1,572,7],[572,8,572,9],[572,10,572,11],[572,12,572,13],[572,14,572,15],[572,16,572,17],[572,18,572,19],[573,1,573,7],[573,8,573,9],[573,10,573,11],[573,12,573,13],[573,14,573,15],[573,16,573,17],[573,18,573,19],[574,1,574,7],[574,8,574,9],[574,10,574,11],[574,12,574,13],[574,14,574,15],[574,16,574,17],[574,18,574,19],[575,1,575,7],[575,8,575,9],[575,10,575,11],[575,12,575,13],[575,14,575,15],[575,16,575,17],[575,18,575,19],[576,1,576,7],[576,8,576,9],[576,10,576,11],[576,12,576,13],[576,14,576,15],[576,16,576,17],[576,18,576,19],[577,1,577,7],[577,8,577,9],[577,10,577,11],[577,12,577,13],[577,14,577,15],[577,16,577,17],[577,18,577,19],[578,1,578,7],[578,8,578,9],[578,10,578,11],[578,12,578,13],[578,14,578,15],[578,16,578,17],[578,18,578,19],[579,1,579,7],[579,8,579,9],[579,10,579,11],[579,12,579,13],[579,14,579,15],[579,16,579,17],[579,18,579,19],[580,1,580,7],[580,8,580,9],[580,10,580,11],[580,12,580,13],[580,14,580,15],[580,16,580,17],[580,18,580,19],[581,1,581,7],[581,8,581,9],[581,10,581,11],[581,12,581,13],[581,14,581,15],[581,16,581,17],[581,18,581,19],[585,10,585,11],[601,11,601,12],[601,16,601,18],[605,11,605,13],[609,4,609,6],[609,11,609,13],[609,16,609,18],[615,4,615,7],[615,14,615,15],[622,6,622,7],[626,4,626,5],[626,11,626,12],[626,16,626,18],[636,5,636,6],[638,5,638,6],[640,5,640,6],[642,5,642,6],[644,5,644,6],[646,5,646,6],[650,5,650,7],[652,15,652,16],[654,6,654,7],[654,12,654,13],[654,16,654,18],[658,1,658,3],[658,4,658,6],[658,9,658,11],[658,14,658,16],[658,17,658,19],[661,7,661,8],[662,16,662,17],[665,0,665,2],[670,9,670,10],[672,18,673,20],[673,0,673,2],[673,12,673,13],[682,0,682,2],[683,0,684,2],[683,5,684,6],[683,14,684,15],[683,18,683,20],[687,15,687,16],[688,7,688,8],[691,3,691,6],[691,9,691,11],[691,14,691,17]]}
[]
[]
["Grupo Crixuz Ingenieria y Construccion S.A.C."]
[{"$nulls":3},"Cel:","#942656792"]
[{"$nulls":3},"Correo:","grupo_crixuz@hotmail.com"]
[{"$nulls":3},"G. General :","Max J. Cardenas Alarcon"]
["Hoja de cálculo que se distribuye de manera condicional, dar el crédito a Crixuz Ingenieria y Construccion SAC, no se tienen restricciones adicionales"]
[]
[]
[null,"ANALISIS Y DISEÑO DE RESERVORIOS RECTANGULARES - DISEÑO"]
[]
["01","DATOS INICIALES DE DISEÑO",{"$nulls":19},0,0,{"$f":"+V25","v":0.15},{"$f":"+W20-0.15-G17","v":{"v":0,"d":"0.00"}}]
[{"$nulls":21},{"$f":"+G20","v":{"v":0,"d":"0.00"}},{"$f":"+W12","v":0},{"$f":"+V23","v":0.15},{"$f":"+Y12","v":{"v":0,"d":"0.00"}}]
[null,"Volumen Reservorio: :",{"$nulls":3},"V =",null,null,"m3",{"$nulls":12},{"$f":"+G20+0.25","v":0.25},{"$f":"+G19-0.15","v":-0.15}]
[null,"Altura del Agua:",{"$nulls":3},"h =",null,null,"m",{"$nulls":12},{"$f":"+G18+0.15+G28+0.15+G18-V14","v":{"v":0.04999999999999999,"d":"0.05"}},{"$f":"+W14","v":-0.15}]
[null,"Intervalo Medida :",{"$nulls":3},"It =",null,null,"m",{"$nulls":12},{"$f":"+V15+0.25","v":{"v":0.3,"d":"0.30"}},{"$f":"+W12","v":0}]
[null,"Borde Libre :",{"$nulls":3},"BL =",null,null,"m",{"$nulls":12},{"$f":"+V16+G20","v":{"v":0.3,"d":"0.30"}},{"$f":"+W12","v":0}]
[null,"Volado de la Cimentacion :",{"$nulls":3},"Vz =",null,null,"m",{"$nulls":12},{"$f":"+V17","v":{"v":0.3,"d":"0.30"}},{"$f":"+G19","v":{"v":0,"d":"0.00"}}]
[null,"Espesor de Cimentacion:",{"$nulls":3},"Hz =",null,null,"m",{"$nulls":12},{"$f":"+V18-G18","v":{"v":0.3,"d":"0.30"}},{"$f":"+W18","v":{"v":0,"d":"0.00"}}]
[null,"Longitud Ensanchamiento:",{"$nulls":3},"Lz =",null,null,"m",{"$nulls":12},{"$f":"+V19","v":{"v":0.3,"d":"0.30"}},{"$f":"+W19+G29+0.15","v":0.15}]
[null,"Peso Especifico del Agua :",{"$nulls":3},"γa =",null,null,"kg/m3",{"$nulls":12},{"$f":"+V20-0.15-G28+0.8","v":{"v":0.9500000000000001,"d":"0.95"}},{"$f":"+W20","v":0.15}]
[null,"Peso Especifico concreto :",{"$nulls":3},"γc =",null,null,"kg/m3",{"$nulls":12},{"$f":"+V21","v":{"v":0.9500000000000001,"d":"0.95"}},{"$f":"+W21-0.15","v":{"v":0,"d":"0.00"}}]
[null,"Peso Especifico Terreno :",{"$nulls":3},"γt =",null,null,"kg/m3",{"$nulls":12},{"$f":"+V20-0.15","v":0.15},{"$f":"+W20-0.15","v":{"v":0,"d":"0.00"}}]
[null,"Capacidad Portante :",{"$nulls":3},"σt =",null,null,"kg/cm2",{"$nulls":12},{"$f":"+V23","v":0.15},{"$f":"+W23-G29","v":{"v":0,"d":"0.00"}}]
[null,"Resistencia del Concreto:",{"$nulls":3},"f'c =",null,null,"kg/cm2",{"$nulls":12},{"$f":"+V24-G28","v":0.15},{"$f":"+W24","v":{"v":0,"d":"0.00"}}]
[null,"Esfuerzo de Fluencia Acero",{"$nulls":3},"fy =",null,null,"kg/cm2",{"$nulls":12},{"$f":"+V25","v":0.15},{"$f":"+W25+G29+0.15","v":0.15}]
[{"$nulls":21},{"$f":"+V26-0.15","v":{"v":0,"d":"0.00"}},{"$f":"+W26","v":0.15}]
[null,"Ancho de la Pared :",{"$nulls":3},"b =",{"$f":"IFERROR(G16*(ROUNDUP(SQRT(G14/G15)/G16,0)),)","v":{"v":0,"d":"0.00"}},null,"m",null,null,"Volumen Real de Almacenamiento :",{"$nulls":4},{"$f":"+G28*G28*G15","v":{"v":0,"d":"0.00"}},null,null,"m3",null,{"$f":"+V27","v":{"v":0,"d":"0.00"}},{"$f":"+W27-G29-0.15","v":{"v":0,"d":"0.00"}}]
[null,"Altura Total del Muro :",{"$nulls":3},"H =",{"$f":"+G15+G17","v":{"v":0,"d":"0.00"}},null,"m",null,null,"Tipo :",{"$nulls":9},{"$f":"+V28-G18","v":{"v":0,"d":"0.00"}},{"$f":"+W28","v":{"v":0,"d":"0.00"}}]
[{"$nulls":21},{"$f":"+V29","v":{"v":0,"d":"0.00"}},{"$f":"+W29-G19","v":{"v":0,"d":"0.00"}}]
["02","ANALISIS Y DISEÑO DE LAS PAREDES DEL RESERVORIO"]
[]
[null,"Utilizando el Metodo PCA se determina momentos y fuerzas cortantes, en los reservorios apoyados o superficiales, típicos para"]
[null,"poblaciones rurales; se utiliza preferentemente la condición que considera la tapa libre y el fondo empotrado. Para este caso y "]
[null,"cuando actúa solo el empuje del agua, la presión en el borde es cero y la presión máxima (P) ocurren en la base."]
[null,"El análisis se realiza cuando el reservorio se encuentra lleno y sujeto a la presión del agua. Para el cálculo de momentos utilizamos",{"$nulls":20},"Top: Articulado - Midle: Empotrado - Botton: Articulado"]
[null,"los coeficientes (k) propuestos por el PCA, los cuales se encuentran en función de el ancho de la pared (b) y la altura de agua (h).",{"$nulls":20},"Top: Libre - Midle: Empotrado - Botton: Articulado"]
[{"$nulls":22},"Top: Libre - Midle: Empotrado - Botton: Empotrado"]
[null,"Obtenemos la relación b/h:",{"$nulls":4},"b","=",{"$f":"+G28","v":{"v":0,"d":"0.00"}},null,"=",{"$f":"IFERROR(+I39/I40,)","v":{"v":0,"d":"0.00"}},null,{"$f":"+IF(L39>=0.5,IF(L39<=3,\"Cumple con la relacion\", \"No cumple con la relacion\"),\"No cumple con la relacion\")","v":"No cumple con la relacion"}]
[{"$nulls":6},"h",null,{"$f":"+G15","v":{"v":0,"d":"0.00"}},{"$nulls":4},0.5,"<","b/h =",{"$f":"+L39","v":{"v":0,"d":"0.00"}},"<",{"v":3,"d":"3.0"},{"$nulls":3},{"$f":"+IF(M29=\"Top: Articulado - Midle: Empotrado - Botton: Articulado\",1,IF(M29=\"Top: Libre - Midle: Empotrado - Botton: Articulado\",2,3))","v":3}]
[]
[null,"Debemos definir la relacion a ser utilizada para el cálculo de los momentos:",{"$nulls":12},"b/h ="]
[]
[null,"Para la relación se presentan los coeficientes (k) para el cáculo de los momentos, cuya información se muestra a continuación:"]
[]
[{"$nulls":3},"b/h","x/h","y = 0",{"$nulls":3},"y = b/4",{"$nulls":3},"y = b/2"]
[{"$nulls":5},"Mx",null,"My",null,"Mx",null,"My",null,"Mx",null,"My"]
[{"$nulls":3},{"$f":"+P42","v":0},0,{"$f":"+IFERROR(W48,)","v":{"v":0,"d":"0.000"}},null,{"$f":"IFERROR(+X48,)","v":{"v":0,"d":"0.000"}},null,{"$f":"IFERROR(+Y48,)","v":{"v":0,"d":"0.000"}},null,{"$f":"IFERROR(+Z48,)","v":{"v":0,"d":"0.000"}},null,{"$f":"IFERROR(+AA48,)","v":{"v":0,"d":"0.000"}},null,{"$f":"IFERROR(+AB48,)","v":{"v":0,"d":"0.000"}},{"$nulls":5},{"$f":"+$D$48+0.05","v":0.05},{"$f":"+IF($W$40=1,VLOOKUP(V48,AnexoI!$E$16:$K$60,2,0),IF($W$40=2,VLOOKUP(V48,AnexoII!$E$16:$K$60,2,0),VLOOKUP(V48,AnexoIII!$E$16:$K$60,2,0)))","v":{"$error":"#N/A"}},{"$f":"+IF($W$40=1,VLOOKUP(V48,AnexoI!$E$16:$K$60,3,0),IF($W$40=2,VLOOKUP(V48,AnexoII!$E$16:$K$60,3,0),VLOOKUP(V48,AnexoIII!$E$16:$K$60,3,0)))","v":{"$error":"#N/A"}},{"$f":"+IF($W$40=1,VLOOKUP(V48,AnexoI!$E$16:$K$60,4,0),IF($W$40=2,VLOOKUP(V48,AnexoII!$E$16:$K$60,4,0),VLOOKUP(V48,AnexoIII!$E$16:$K$60,4,0)))","v":{"$error":"#N/A"}},{"$f":"+IF($W$40=1,VLOOKUP(V48,AnexoI!$E$16:$K$60,5,0),IF($W$40=2,VLOOKUP(V48,AnexoII!$E$16:$K$60,5,0),VLOOKUP(V48,AnexoIII!$E$16:$K$60,5,0)))","v":{"$error":"#N/A"}},{"$f":"+IF($W$40=1,VLOOKUP(V48,AnexoI!$E$16:$K$60,6,0),IF($W$40=2,VLOOKUP(V48,AnexoII!$E$16:$K$60,6,0),VLOOKUP(V48,AnexoIII!$E$16:$K$60,6,0)))","v":{"$error":"#N/A"}},{"$f":"+IF($W$40=1,VLOOKUP(V48,AnexoI!$E$16:$K$60,7,0),IF($W$40=2,VLOOKUP(V48,AnexoII!$E$16:$K$60,7,0),VLOOKUP(V48,AnexoIII!$E$16:$K$60,7,0)))","v":{"$error":"#N/A"}}]
[{"$nulls":4},0.25,{"$f":"+IFERROR(W49,)","v":{"v":0,"d":"0.000"}},null,{"$f":"IFERROR(+X49,)","v":{"v":0,"d":"0.000"}},null,{"$f":"IFERROR(+Y49,)","v":{"v":0,"d":"0.000"}},null,{"$f":"IFERROR(+Z49,)","v":{"v":0,"d":"0.000"}},null,{"$f":"IFERROR(+AA49,)","v":{"v":0,"d":"0.000"}},null,{"$f":"IFERROR(+AB49,)","v":{"v":0,"d":"0.000"}},{"$nulls":5},{"$f":"+$D$48+0.04","v":0.04},{"$f":"+IF($W$40=1,VLOOKUP(V49,AnexoI!$E$16:$K$60,2,0),IF($W$40=2,VLOOKUP(V49,AnexoII!$E$16:$K$60,2,0),VLOOKUP(V49,AnexoIII!$E$16:$K$60,2,0)))","v":{"$error":"#N/A"}},{"$f":"+IF($W$40=1,VLOOKUP(V49,AnexoI!$E$16:$K$60,3,0),IF($W$40=2,VLOOKUP(V49,AnexoII!$E$16:$K$60,3,0),VLOOKUP(V49,AnexoIII!$E$16:$K$60,3,0)))","v":{"$error":"#N/A"}},{"$f":"+IF($W$40=1,VLOOKUP(V49,AnexoI!$E$16:$K$60,4,0),IF($W$40=2,VLOOKUP(V49,AnexoII!$E$16:$K$60,4,0),VLOOKUP(V49,AnexoIII!$E$16:$K$60,4,0)))","v":{"$error":"#N/A"}},{"$f":"+IF($W$40=1,VLOOKUP(V49,AnexoI!$E$16:$K$60,5,0),IF($W$40=2,VLOOKUP(V49,AnexoII!$E$16:$K$60,5,0),VLOOKUP(V49,AnexoIII!$E$16:$K$60,5,0)))","v":{"$error":"#N/A"}},{"$f":"+IF($W$40=1,VLOOKUP(V49,AnexoI!$E$16:$K$60,6,0),IF($W$40=2,VLOOKUP(V49,AnexoII!$E$16:$K$60,6,0),VLOOKUP(V49,AnexoIII!$E$16:$K$60,6,0)))","v":{"$error":"#N/A"}},{"$f":"+IF($W$40=1,VLOOKUP(V49,AnexoI!$E$16:$K$60,7,0),IF($W$40=2,VLOOKUP(V49,AnexoII!$E$16:$K$60,7,0),VLOOKUP(V49,AnexoIII!$E$16:$K$60,7,0)))","v":{"$error":"#N/A"}}]
[{"$nulls":4},0.5,{"$f":"+IFERROR(W50,)","v":{"v":0,"d":"0.000"}},null,{"$f":"IFERROR(+X50,)","v":{"v":0,"d":"0.000"}},null,{"$f":"IFERROR(+Y50,)","v":{"v":0,"d":"0.000"}},null,{"$f":"IFERROR(+Z50,)","v":{"v":0,"d":"0.000"}},null,{"$f":"IFERROR(+AA50,)","v":{"v":0,"d":"0.000"}},null,{"$f":"IFERROR(+AB50,)","v":{"v":0,"d":"0.000"}},{"$nulls":5},{"$f":"+$D$48+0.03","v":0.03},{"$f":"+IF($W$40=1,VLOOKUP(V50,AnexoI!$E$16:$K$60,2,0),IF($W$40=2,VLOOKUP(V50,AnexoII!$E$16:$K$60,2,0),VLOOKUP(V50,AnexoIII!$E$16:$K$60,2,0)))","v":{"$error":"#N/A"}},{"$f":"+IF($W$40=1,VLOOKUP(V50,AnexoI!$E$16:$K$60,3,0),IF($W$40=2,VLOOKUP(V50,AnexoII!$E$16:$K$60,3,0),VLOOKUP(V50,AnexoIII!$E$16:$K$60,3,0)))","v":{"$error":"#N/A"}},{"$f":"+IF($W$40=1,VLOOKUP(V50,AnexoI!$E$16:$K$60,4,0),IF($W$40=2,VLOOKUP(V50,AnexoII!$E$16:$K$60,4,0),VLOOKUP(V50,AnexoIII!$E$16:$K$60,4,0)))","v":{"$error":"#N/A"}},{"$f":"+IF($W$40=1,VLOOKUP(V50,AnexoI!$E$16:$K$60,5,0),IF($W$40=2,VLOOKUP(V50,AnexoII!$E$16:$K$60,5,0),VLOOKUP(V50,AnexoIII!$E$16:$K$60,5,0)))","v":{"$error":"#N/A"}},{"$f":"+IF($W$40=1,VLOOKUP(V50,AnexoI!$E$16:$K$60,6,0),IF($W$40=2,VLOOKUP(V50,AnexoII!$E$16:$K$60,6,0),VLOOKUP(V50,AnexoIII!$E$16:$K$60,6,0)))","v":{"$error":"#N/A"}},{"$f":"+IF($W$40=1,VLOOKUP(V50,AnexoI!$E$16:$K$60,7,0),IF($W$40=2,VLOOKUP(V50,AnexoII!$E$16:$K$60,7,0),VLOOKUP(V50,AnexoIII!$E$16:$K$60,7,0)))","v":{"$error":"#N/A"}}]
[{"$nulls":4},0.75,{"$f":"+IFERROR(W51,)","v":{"v":0,"d":"0.000"}},null,{"$f":"IFERROR(+X51,)","v":{"v":0,"d":"0.000"}},null,{"$f":"IFERROR(+Y51,)","v":{"v":0,"d":"0.000"}},null,{"$f":"IFERROR(+Z51,)","v":{"v":0,"d":"0.000"}},null,{"$f":"IFERROR(+AA51,)","v":{"v":0,"d":"0.000"}},null,{"$f":"IFERROR(+AB51,)","v":{"v":0,"d":"0.000"}},{"$nulls":5},{"$f":"+$D$48+0.02","v":0.02},{"$f":"+IF($W$40=1,VLOOKUP(V51,AnexoI!$E$16:$K$60,2,0),IF($W$40=2,VLOOKUP(V51,AnexoII!$E$16:$K$60,2,0),VLOOKUP(V51,AnexoIII!$E$16:$K$60,2,0)))","v":{"$error":"#N/A"}},{"$f":"+IF($W$40=1,VLOOKUP(V51,AnexoI!$E$16:$K$60,3,0),IF($W$40=2,VLOOKUP(V51,AnexoII!$E$16:$K$60,3,0),VLOOKUP(V51,AnexoIII!$E$16:$K$60,3,0)))","v":{"$error":"#N/A"}},{"$f":"+IF($W$40=1,VLOOKUP(V51,AnexoI!$E$16:$K$60,4,0),IF($W$40=2,VLOOKUP(V51,AnexoII!$E$16:$K$60,4,0),VLOOKUP(V51,AnexoIII!$E$16:$K$60,4,0)))","v":{"$error":"#N/A"}},{"$f":"+IF($W$40=1,VLOOKUP(V51,AnexoI!$E$16:$K$60,5,0),IF($W$40=2,VLOOKUP(V51,AnexoII!$E$16:$K$60,5,0),VLOOKUP(V51,AnexoIII!$E$16:$K$60,5,0)))","v":{"$error":"#N/A"}},{"$f":"+IF($W$40=1,VLOOKUP(V51,AnexoI!$E$16:$K$60,6,0),IF($W$40=2,VLOOKUP(V51,AnexoII!$E$16:$K$60,6,0),VLOOKUP(V51,AnexoIII!$E$16:$K$60,6,0)))","v":{"$error":"#N/A"}},{"$f":"+IF($W$40=1,VLOOKUP(V51,AnexoI!$E$16:$K$60,7,0),IF($W$40=2,VLOOKUP(V51,AnexoII!$E$16:$K$60,7,0),VLOOKUP(V51,AnexoIII!$E$16:$K$60,7,0)))","v":{"$error":"#N/A"}}]
[{"$nulls":4},1,{"$f":"+IFERROR(W52,)","v":{"v":0,"d":"0.000"}},null,{"$f":"IFERROR(+X52,)","v":{"v":0,"d":"0.000"}},null,{"$f":"IFERROR(+Y52,)","v":{"v":0,"d":"0.000"}},null,{"$f":"IFERROR(+Z52,)","v":{"v":0,"d":"0.000"}},null,{"$f":"IFERROR(+AA52,)","v":{"v":0,"d":"0.000"}},null,{"$f":"IFERROR(+AB52,)","v":{"v":0,"d":"0.000"}},{"$nulls":5},{"$f":"+$D$48+0.01","v":0.01},{"$f":"+IF($W$40=1,VLOOKUP(V52,AnexoI!$E$16:$K$60,2,0),IF($W$40=2,VLOOKUP(V52,AnexoII!$E$16:$K$60,2,0),VLOOKUP(V52,AnexoIII!$E$16:$K$60,2,0)))","v":{"$error":"#N/A"}},{"$f":"+IF($W$40=1,VLOOKUP(V52,AnexoI!$E$16:$K$60,3,0),IF($W$40=2,VLOOKUP(V52,AnexoII!$E$16:$K$60,3,0),VLOOKUP(V52,AnexoIII!$E$16:$K$60,3,0)))","v":{"$error":"#N/A"}},{"$f":"+IF($W$40=1,VLOOKUP(V52,AnexoI!$E$16:$K$60,4,0),IF($W$40=2,VLOOKUP(V52,AnexoII!$E$16:$K$60,4,0),VLOOKUP(V52,AnexoIII!$E$16:$K$60,4,0)))","v":{"$error":"#N/A"}},{"$f":"+IF($W$40=1,VLOOKUP(V52,AnexoI!$E$16:$K$60,5,0),IF($W$40=2,VLOOKUP(V52,AnexoII!$E$16:$K$60,5,0),VLOOKUP(V52,AnexoIII!$E$16:$K$60,5,0)))","v":{"$error":"#N/A"}},{"$f":"+IF($W$40=1,VLOOKUP(V52,AnexoI!$E$16:$K$60,6,0),IF($W$40=2,VLOOKUP(V52,AnexoII!$E$16:$K$60,6,0),VLOOKUP(V52,AnexoIII!$E$16:$K$60,6,0)))","v":{"$error":"#N/A"}},{"$f":"+IF($W$40=1,VLOOKUP(V52,AnexoI!$E$16:$K$60,7,0),IF($W$40=2,VLOOKUP(V52,AnexoII!$E$16:$K$60,7,0),VLOOKUP(V52,AnexoIII!$E$16:$K$60,7,0)))","v":{"$error":"#N/A"}}]
[{"$nulls":3},"Valores de los coeficientes (K) para el calculo de momentos"]
[]
[null,"Los momentos se determinan mediante la siguiente fórmula:",{"$nulls":11},"M =","k * γa * h3"]
[]
[null,"Conocidos los datos se calculan los momentos, los que se muestran en el cuadro siguiente:",{"$nulls":20},0,0]
[{"$nulls":22},0,-1]
[{"$nulls":3},"b/h","x/h","y = 0",{"$nulls":3},"y = b/4",{"$nulls":3},"y = b/2"]
[{"$nulls":5},"Mx",null,"My",null,"Mx",null,"My",null,"Mx",null,"My"]
[{"$nulls":3},{"$f":"+D48","v":0},0,{"$f":"+F48*$G$21*$G$15*$G$15*$G$15","v":{"v":0,"d":"0.000"}},null,{"$f":"+H48*$G$21*$G$15*$G$15*$G$15","v":{"v":0,"d":"0.000"}},null,{"$f":"+J48*$G$21*$G$15*$G$15*$G$15","v":{"v":0,"d":"0.000"}},null,{"$f":"+L48*$G$21*$G$15*$G$15*$G$15","v":{"v":0,"d":"0.000"}},null,{"$f":"+N48*$G$21*$G$15*$G$15*$G$15","v":{"v":0,"d":"0.000"}},null,{"$f":"+P48*$G$21*$G$15*$G$15*$G$15","v":{"v":0,"d":"0.000"}},{"$nulls":5},{"$f":"+E61*(-1)","v":0},{"$f":"+W48*$G$21*$G$15*$G$15*$G$15","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$nulls":4},0.25,{"$f":"+F49*$G$21*$G$15*$G$15*$G$15","v":{"v":0,"d":"0.000"}},null,{"$f":"+H49*$G$21*$G$15*$G$15*$G$15","v":{"v":0,"d":"0.000"}},null,{"$f":"+J49*$G$21*$G$15*$G$15*$G$15","v":{"v":0,"d":"0.000"}},null,{"$f":"+L49*$G$21*$G$15*$G$15*$G$15","v":{"v":0,"d":"0.000"}},null,{"$f":"+N49*$G$21*$G$15*$G$15*$G$15","v":{"v":0,"d":"0.000"}},null,{"$f":"+P49*$G$21*$G$15*$G$15*$G$15","v":{"v":0,"d":"0.000"}},{"$nulls":5},{"$f":"+E62*(-1)","v":-0.25},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$nulls":4},0.5,{"$f":"+F50*$G$21*$G$15*$G$15*$G$15","v":{"v":0,"d":"0.000"}},null,{"$f":"+H50*$G$21*$G$15*$G$15*$G$15","v":{"v":0,"d":"0.000"}},null,{"$f":"+J50*$G$21*$G$15*$G$15*$G$15","v":{"v":0,"d":"0.000"}},null,{"$f":"+L50*$G$21*$G$15*$G$15*$G$15","v":{"v":0,"d":"0.000"}},null,{"$f":"+N50*$G$21*$G$15*$G$15*$G$15","v":{"v":0,"d":"0.000"}},null,{"$f":"+P50*$G$21*$G$15*$G$15*$G$15","v":{"v":0,"d":"0.000"}},{"$nulls":5},{"$f":"+E63*(-1)","v":-0.5},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$nulls":4},0.75,{"$f":"+F51*$G$21*$G$15*$G$15*$G$15","v":{"v":0,"d":"0.000"}},null,{"$f":"+H51*$G$21*$G$15*$G$15*$G$15","v":{"v":0,"d":"0.000"}},null,{"$f":"+J51*$G$21*$G$15*$G$15*$G$15","v":{"v":0,"d":"0.000"}},null,{"$f":"+L51*$G$21*$G$15*$G$15*$G$15","v":{"v":0,"d":"0.000"}},null,{"$f":"+N51*$G$21*$G$15*$G$15*$G$15","v":{"v":0,"d":"0.000"}},null,{"$f":"+P51*$G$21*$G$15*$G$15*$G$15","v":{"v":0,"d":"0.000"}},{"$nulls":5},{"$f":"+E64*(-1)","v":-0.75},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$nulls":4},1,{"$f":"+F52*$G$21*$G$15*$G$15*$G$15","v":{"v":0,"d":"0.000"}},null,{"$f":"+H52*$G$21*$G$15*$G$15*$G$15","v":{"v":0,"d":"0.000"}},null,{"$f":"+J52*$G$21*$G$15*$G$15*$G$15","v":{"v":0,"d":"0.000"}},null,{"$f":"+L52*$G$21*$G$15*$G$15*$G$15","v":{"v":0,"d":"0.000"}},null,{"$f":"+N52*$G$21*$G$15*$G$15*$G$15","v":{"v":0,"d":"0.000"}},null,{"$f":"+P52*$G$21*$G$15*$G$15*$G$15","v":{"v":0,"d":"0.000"}},{"$nulls":5},{"$f":"+E65*(-1)","v":-1},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$nulls":3},"Valores de los momentos verticales y horizontales (Klg-m)"]
[]
[{"$nulls":4},"y ",null,null,"b/2",{"$nulls":4},"b/2",null,null," y"]
[{"$nulls":21},0,{"$f":"+AB61","v":{"$error":"#N/A"}},null,0,{"$f":"+AB62","v":{"$error":"#N/A"}}]
[{"$nulls":4},"//",{"$f":"+IF(M29=\"Top: Articulado - Midle: Empotrado - Botton: Articulado\",\"Articulado\",\"Libre\")","v":"Libre"},{"$nulls":8},{"$f":"+IF(M29=\"Top: Articulado - Midle: Empotrado - Botton: Articulado\",\"Articulado\",\"Libre\")","v":"Libre"},"\\\\",{"$nulls":5},0.25,{"$f":"+Z61","v":{"$error":"#N/A"}},null,0.25,{"$f":"+Z62","v":{"$error":"#N/A"}}]
[{"$nulls":4},"//",{"$nulls":10},"\\\\",{"$nulls":5},0.5,{"$f":"+X61","v":{"$error":"#N/A"}},null,0.5,{"$f":"+X62","v":{"$error":"#N/A"}}]
[{"$nulls":4},"//",{"$nulls":10},"\\\\",{"$nulls":5},0.75,{"$f":"+Z61","v":{"$error":"#N/A"}},null,0.75,{"$f":"+Z62","v":{"$error":"#N/A"}}]
[{"$nulls":4},"//","Empotrado",{"$nulls":8},"Empotrado","\\\\","h",{"$nulls":4},1,{"$f":"+AB61","v":{"$error":"#N/A"}},null,1,{"$f":"+AB62","v":{"$error":"#N/A"}}]
[{"$nulls":4},"//",{"$nulls":4},"x",{"$nulls":5},"\\\\"]
[{"$nulls":4},"//",{"$nulls":10},"\\\\"]
[{"$nulls":4},"//",{"$nulls":4},{"$f":"+IF(M29=\"Top: Libre - Midle: Empotrado - Botton: Empotrado\",\"Empotrado\",\"Articulado\")","v":"Articulado"},{"$nulls":5},"\\\\"]
[{"$nulls":3},"γa*h",{"$f":"+IF(M29=\"Top: Libre - Midle: Empotrado - Botton: Empotrado\",\"//\",\"\")","v":""},{"$f":"+IF($M$29=\"Top: Libre - Midle: Empotrado - Botton: Empotrado\",\"//////////////\",\"\")","v":""},{"$f":"+IF($M$29=\"Top: Libre - Midle: Empotrado - Botton: Empotrado\",\"//////////////\",\"\")","v":""},"","","","","","","","",{"$f":"+IF($M$29=\"Top: Libre - Midle: Empotrado - Botton: Empotrado\",\"\\\\\",\"\")","v":""}]
[]
[null,"Graficamos los momento verticales Mx (kg-m), tenemos:"]
[]
[{"$nulls":21},0,{"$f":"+AB63","v":{"$error":"#N/A"}},null,0,{"$f":"+AB64","v":{"$error":"#N/A"}}]
[{"$nulls":21},0.25,{"$f":"+Z63","v":{"$error":"#N/A"}},null,0.25,{"$f":"+Z64","v":{"$error":"#N/A"}}]
[{"$nulls":21},0.5,{"$f":"+X63","v":{"$error":"#N/A"}},null,0.5,{"$f":"+X64","v":{"$error":"#N/A"}}]
[{"$nulls":21},0.75,{"$f":"+Z63","v":{"$error":"#N/A"}},null,0.75,{"$f":"+Z64","v":{"$error":"#N/A"}}]
[{"$nulls":21},1,{"$f":"+AB63","v":{"$error":"#N/A"}},null,1,{"$f":"+AB64","v":{"$error":"#N/A"}}]
[]
[]
[]
[]
[]
[{"$nulls":21},0,{"$f":"+AB65","v":{"$error":"#N/A"}},null,0,0]
[{"$nulls":21},0.25,{"$f":"+Z65","v":{"$error":"#N/A"}},null,1,0]
[{"$nulls":21},0.5,{"$f":"+X65","v":{"$error":"#N/A"}}]
[{"$nulls":21},0.75,{"$f":"+Z65","v":{"$error":"#N/A"}}]
[{"$nulls":21},1,{"$f":"+AB65","v":{"$error":"#N/A"}}]
[]
[]
[{"$nulls":22},{"$f":"+ABS(W61)","v":{"$error":"#N/A"}},{"$f":"+ABS(X61)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$nulls":22},{"$f":"+ABS(W62)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$nulls":22},{"$f":"+ABS(W63)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"Graficamos los momento horizontales My (kg-m), tenemos:",{"$nulls":20},{"$f":"+ABS(W64)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$nulls":22},{"$f":"+ABS(W65)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[]
[{"$nulls":22},{"$f":"+W98","v":{"$error":"#N/A"}},null,{"$f":"+X98","v":{"$error":"#N/A"}}]
[{"$nulls":22},{"$f":"+W99","v":{"$error":"#N/A"}},null,{"$f":"+X99","v":{"$error":"#N/A"}}]
[{"$nulls":22},{"$error":"#N/A"},null,{"$error":"#N/A"}]
[{"$nulls":22},{"$error":"#N/A"},null,{"$error":"#N/A"}]
[{"$nulls":22},{"$error":"#N/A"},null,{"$error":"#N/A"}]
[{"$nulls":22},{"$f":"+Y98","v":{"$error":"#N/A"}},null,{"$f":"+Z98","v":{"$error":"#N/A"}}]
[{"$nulls":22},{"$f":"+Y99","v":{"$error":"#N/A"}},null,{"$f":"+Z99","v":{"$error":"#N/A"}}]
[{"$nulls":22},{"$error":"#N/A"},null,{"$error":"#N/A"}]
[{"$nulls":22},{"$error":"#N/A"},null,{"$error":"#N/A"}]
[{"$nulls":22},{"$error":"#N/A"},null,{"$error":"#N/A"}]
[{"$nulls":22},{"$f":"+AA98","v":{"$error":"#N/A"}},null,{"$f":"+AB98","v":{"$error":"#N/A"}}]
[{"$nulls":22},{"$f":"+AA99","v":{"$error":"#N/A"}},null,{"$f":"+AB99","v":{"$error":"#N/A"}}]
[{"$nulls":22},{"$error":"#N/A"},null,{"$error":"#N/A"}]
[{"$nulls":22},{"$error":"#N/A"},null,{"$error":"#N/A"}]
[{"$nulls":22},{"$error":"#N/A"},null,{"$error":"#N/A"}]
{"$rows_empty":14}
[null,"De los graficos se puede ver que el máximo momento absoluto es:",{"$nulls":12},"Mmax =",{"$f":"IFERROR(+MAX(W98:AB102),)","v":{"v":0,"d":"0.000"}},null,null,"kg-m"]
[]
[null,"El espesor de la pared ( e ) originado por un momento \"M\" y el esfuerzo de tracción por flexión (ft) en cualquier punto de la pared,"]
[null,"se determina mediante el métodos elástico sin agrietamiento, cuyo valor se estima mediante:"]
[]
[{"$nulls":7},"e1 =","√(6* Mmax)",null,"=","√(6* Mmax)"]
[{"$nulls":8},"√(fr*b)",null,null,"√(2*√fr*b)"]
[]
[null,"Donde :",null,"Mmax: Es el momento Maximo (kg-m)"]
[{"$nulls":3},"fr : Es la resistencia del concreto a tracción por flexión (kg/cm2); fr = 2*√f'c",{"$nulls":10},"según el Art. 9.6.2.3 - E060 - RNE"]
[{"$nulls":3},"b : Es el ancho de analisis del muro, para este caso 1.00 m"]
[{"$nulls":3},"f'c : Es la resistencia a compresion del concreto (kg/cm2)"]
[]
[null,"Por lo tanto el espesor de la pared será:"]
[]
[{"$nulls":3},"fr =",{"$f":"2*SQRT(G25)","v":{"v":0,"d":"0.00"}},null,"kg/cm2"]
[]
[{"$nulls":3},"b =",null,null,"cm"]
[]
[{"$nulls":3},"e1 =",{"$f":"IFERROR(+SQRT((6*P133*100)/(E148*E150)),)","v":{"v":0,"d":"0.000"}},null,"cm"]
[]
[{"$nulls":3},"emin =",null,null,"cm"]
[]
[null,"El espesor de la pared para el diseño de concreto armado sera:"]
[]
[{"$nulls":3},"e1 =",{"$f":"+IF(E152<E154,E154,2.5*(ROUNDUP(E152/2.5,0)) )","v":{"v":0,"d":"0.00"}},null,"cm",{"$nulls":4},"Maximo momento absoluto originado por el empuje del agua"]
[]
[null,"Diseño de la armadura vertical del muro"]
[]
[null,"Para el diseno estructural de la armadura vertical de la pared se considera el momento maximo absoluto."]
[]
[null,"Para la armadura vertical resulta un momento (Mx) igual:",{"$nulls":9},"Mx=",{"$f":"IFERROR(K164*MAX(W104:W118),)","v":{"v":0,"d":"0.000"}},null,null,"kg-m"]
[]
[null,null,"r1 =",null,null,"cm","(Recubrimiento)",{"$nulls":5},"d1 =",{"$f":"+E158-D166","v":{"v":0,"d":"0.00"}},null,"cm","(Peralte efectivo)"]
[]
[null,"Calculamos el area de acero con la siguiente ecuacion:",{"$nulls":8},"Mu = 0.9*b*d1*f'c*w*(1-0.59w)"]
[]
[null,null,"Factor de reduccion f'c :",{"$nulls":8},"Factor de reduccion fy :"]
[]
[{"$nulls":3},"w1=",{"$f":"IFERROR(+(-V173+SQRT((V173^2)-4*V172*V174))/(2*V172),)","v":{"v":0,"d":"0.00000"}},{"$nulls":7},"w2=",{"$f":"IFERROR(+(-V173-SQRT((V173^2)-4*V172*V174))/(2*V172),)","v":{"v":0,"d":"0.0000"}},{"$nulls":7},0.59]
[{"$nulls":21},{"$f":"+-1","v":-1}]
[{"$nulls":3},"ρ =",{"$f":"IFERROR(+MIN(N172,E172)*G25/(G26*P170),)","v":{"v":0,"d":"0.00000"}},{"$nulls":7},"As=",{"$f":"+E174*E150*N166","v":{"v":0,"d":"0.00"}},null,"cm2",{"$nulls":5},{"$f":"+(M164*100)/(0.9*E150*((N166)^2)*G25*G170)","v":{"$error":"#DIV/0!"}}]
[]
[null,"El acero minimo es dado por :",{"$nulls":4},"Asmin =",null,null,"*b*e1",null,null,"Asmin =",{"$f":"H176*E150*E158","v":{"v":0,"d":"0.00"}},null,"cm2"]
[]
[null,"Por lo tanto el area de acero que utilizaremos en le muro sera: ",{"$nulls":10},"As =",{"$f":"+MAX(N174,N176)","v":{"v":0,"d":"0.00"}},null,"cm2"]
[]
[null,"La distribucion de acero vertical en el muro sera de :"]
[]
[null,"Ø","3/8\"",null,"1/2\"",null,"5/8\"",null,"3/4\"",null,"7/8\"",null,"1\"",null,null,"Distribucion de acero",{"$nulls":5},{"$f":"+C182","v":"3/8\""},{"$f":"+E182","v":"1/2\""},{"$f":"+G182","v":"5/8\""},{"$f":"+I182","v":"3/4\""},{"$f":"+K182","v":"7/8\""},{"$f":"+M182","v":"1\""}]
[null,"Area",0.71,null,1.27,null,1.98,null,2.85,null,3.88,null,5.07,{"$nulls":8},{"$f":"+C183","v":0.71},{"$f":"+E183","v":1.27},{"$f":"+G183","v":1.98},{"$f":"+I183","v":2.85},{"$f":"+K183","v":3.88},{"$f":"+M183","v":5.07}]
[null,"s (cm)",{"$f":"IFERROR(+C183*100/$N$178,)","v":{"v":0,"d":"0.00"}},null,{"$f":"IFERROR(+E183*100/$N$178,)","v":{"v":0,"d":"0.00"}},null,{"$f":"IFERROR(+G183*100/$N$178,)","v":{"v":0,"d":"0.00"}},null,{"$f":"IFERROR(+I183*100/$N$178,)","v":{"v":0,"d":"0.00"}},null,{"$f":"IFERROR(+K183*100/$N$178,)","v":{"v":0,"d":"0.00"}},null,{"$f":"IFERROR(+M183*100/$N$178,)","v":{"v":0,"d":"0.00"}},null,null,"Ø",null,"@",{"$f":"IFERROR((2.5*(ROUNDDOWN(HLOOKUP(Q184,V182:AA184,3,0)/2.5,0)))/100,)","v":{"v":0,"d":"0.000"}},null,"m",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[]
[null,"Diseño de la armadura horizontal del muro"]
[]
[null,"Para el diseno estructural de la armadura horizontal de la pared se considera el momento maximo absoluto."]
[]
[null,"Para la armadura horizontal el momento (My) es igual a :",{"$nulls":9},"My =",{"$f":"IFERROR(K190*MAX(Y104:Y118),)","v":{"v":0,"d":"0.000"}},null,null,"kg-m"]
[]
[null,null,"r =",null,null,"cm","(Recubrimiento)",{"$nulls":5},"d =",{"$f":"+E158-D192","v":{"v":0,"d":"0.00"}},null,"cm","(Peralte efectivo)"]
[]
[null,"Calculamos el area de acero con la siguiente ecuacion:",{"$nulls":8},"Mu = 0.9*b*d2*f'c*w*(1-0.59w)"]
[]
[null,null,"Factor de reduccion f'c :",{"$nulls":8},"Factor de reduccion fy :"]
[]
[{"$nulls":3},"w1=",{"$f":"IFERROR(+(-V199+SQRT((V199^2)-4*V198*V200))/(2*V198),)","v":{"v":0,"d":"0.00000"}},{"$nulls":7},"w2=",{"$f":"IFERROR(+(-V199-SQRT((V199^2)-4*V198*V200))/(2*V198),)","v":{"v":0,"d":"0.0000"}},{"$nulls":7},0.59]
[{"$nulls":21},{"$f":"+-1","v":-1}]
[{"$nulls":3},"ρ =",{"$f":"IFERROR(+MIN(N198,E198)*G25/(G26*P196),)","v":{"v":0,"d":"0.00000"}},{"$nulls":7},"As=",{"$f":"+E200*E150*N192","v":{"v":0,"d":"0.00"}},null,"cm2",{"$nulls":5},{"$f":"+(M190*100)/(0.9*E150*((N192)^2)*G25*G196)","v":{"$error":"#DIV/0!"}}]
[]
[null,"El acero minimo es dado por :",{"$nulls":4},"Asmin =",null,null,"*b*e1",null,null,"Asmin =",{"$f":"H202*E150*E158","v":{"v":0,"d":"0.00"}},null,"cm2"]
[]
[null,"Por lo tanto el area de acero que utilizaremos en le muro sera: ",{"$nulls":10},"As =",{"$f":"+MAX(N200,N202)","v":{"v":0,"d":"0.00"}},null,"cm2"]
[]
[null,"La distribucion de acero vertical en el muro sera de :"]
[]
[null,"Ø","3/8\"",null,"1/2\"",null,"5/8\"",null,"3/4\"",null,"7/8\"",null,"1\"",null,null,"Distribucion de acero",{"$nulls":5},{"$f":"+C208","v":"3/8\""},{"$f":"+E208","v":"1/2\""},{"$f":"+G208","v":"5/8\""},{"$f":"+I208","v":"3/4\""},{"$f":"+K208","v":"7/8\""},{"$f":"+M208","v":"1\""}]
[null,"Area",0.71,null,1.27,null,1.98,null,2.85,null,3.88,null,5.07,{"$nulls":8},{"$f":"+C209","v":0.71},{"$f":"+E209","v":1.27},{"$f":"+G209","v":1.98},{"$f":"+I209","v":2.85},{"$f":"+K209","v":3.88},{"$f":"+M209","v":5.07}]
[null,"s (cm)",{"$f":"IFERROR(+C209*100/$N$204,)","v":{"v":0,"d":"0.00"}},null,{"$f":"IFERROR(+E209*100/$N$204,)","v":{"v":0,"d":"0.00"}},null,{"$f":"IFERROR(+G209*100/$N$204,)","v":{"v":0,"d":"0.00"}},null,{"$f":"IFERROR(+I209*100/$N$204,)","v":{"v":0,"d":"0.00"}},null,{"$f":"IFERROR(+K209*100/$N$204,)","v":{"v":0,"d":"0.00"}},null,{"$f":"IFERROR(+M209*100/$N$204,)","v":{"v":0,"d":"0.00"}},null,null,"Ø",null,"@",{"$f":"IFERROR((2.5*(ROUNDDOWN(HLOOKUP(Q210,V208:AA210,3,0)/2.5,0)))/100,)","v":{"v":0,"d":"0.000"}},null,"m",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[]
[null,"Verificacion por cortante en el muro del reservorio",{"$nulls":20},"Top: Articulado - Midle: Empotrado - Botton: Articulado",{"$nulls":4},{"$f":"+IF(M221=\"Top: Articulado - Midle: Empotrado - Botton: Articulado\",1,2)","v":2}]
[{"$nulls":22},"Top: Libre - Midle: Empotrado - Botton: Articulado"]
[null,"Se verifica el efecto del cortante en la base del muro del reservorio. El cortante que se produce por el empuje del agua es:"]
[]
[null,"El cortante  en la base del muro del reservorio se da cuando :",{"$nulls":9},"x =",null,null,"m",{"$nulls":7},0.5,1,2,5,10,"Infinito"]
[{"$nulls":22},"0.1407wh2","0.2419wh2","0.3290wh2","","","0.3333wh2"]
[{"$nulls":6},"Vu =",null,"* ( γa * x * h )",null,"=",{"$f":"+H218*G21*M216*G15/2","v":{"v":0,"d":"0.000"}},null,null,"kg",{"$nulls":7},"-0.2575wh2","-0.4397wh2","-0.5833wh2","","","-0.6000wh2"]
[{"$nulls":7},2,{"$nulls":14},"0.1280wh2","0.2582wh2","0.3604wh2","","","0.3912wh2"]
[{"$nulls":22},"0.1736wh2","0.3113wh2","0.4023wh2","","","0.4118wh2"]
[null,"Calculamos el cortante usando las tablas del PCA para el tipo de reservorio:",{"$nulls":20},"0.1919wh2","0.3153wh2","0.3904wh2","","","0.3980wh2"]
[{"$nulls":22},"0.0000wh2b","0.0052wh2b","0.0538wh2b","0.1203wh2b","0.1435wh2b","0.1667wh2b"]
[null,"b/h",{"$nulls":6},{"$f":"+IF($AB$212=1,W216,IF($AB$212=2,W227,\"\"))","v":0.5},null,{"$f":"+IF($AB$212=1,X216,IF($AB$212=2,X227,\"\"))","v":1},null,{"$f":"+IF($AB$212=1,Y216,IF($AB$212=2,Y227,\"\"))","v":2},null,{"$f":"+IF($AB$212=1,Z216,IF($AB$212=2,Z227,\"\"))","v":3},null,{"$f":"+IF($AB$212=1,AA216,IF($AB$212=2,AA227,\"\"))","v":""},null,{"$f":"+IF($AB$212=1,AB216,IF($AB$212=2,AB227,\"\"))","v":""},{"$nulls":3},"0.0480wh2b","0.0960wh2b","0.1818wh2b","0.2715wh2b","0.3023wh2b","0.3333wh2b"]
[null,"Centro de la base",{"$nulls":6},{"$f":"+IF($AB$212=1,W217,IF($AB$212=2,W228,\"\"))","v":"0.141wh2"},null,{"$f":"+IF($AB$212=1,X217,IF($AB$212=2,X228,\"\"))","v":"0.242wh2"},null,{"$f":"+IF($AB$212=1,Y217,IF($AB$212=2,Y228,\"\"))","v":"0.380wh2"},null,{"$f":"+IF($AB$212=1,Z217,IF($AB$212=2,Z228,\"\"))","v":"0.450wh2"},null,{"$f":"+IF($AB$212=1,AA217,IF($AB$212=2,AA228,\"\"))","v":""},null,{"$f":"+IF($AB$212=1,AB217,IF($AB$212=2,AB228,\"\"))","v":""},{"$nulls":3},"0.2260wh2b","0.1994wh2b","0.1322wh2b","0.0541wh2b","0.0271wh2b","0.2750wh2b"]
[null,"Vértice de la base",{"$nulls":6},"-0.258wh2",null,"-0.440wh2",null,"-0.583wh2",null,"-0.590wh2",null,"",null,"",{"$nulls":3},"0.5000wh2b","0.5000wh2b","0.5000wh2b","0.5000wh2b","0.5000wh2b","0.5000wh2b"]
[null,{"$f":"+IF($AB$212=1,W256,Z256)","v":"Tope inferior del lado empotrado"},{"$nulls":6},"0.000wh2",null,"0.010wh2",null,"0.100wh2",null,"0.165wh2",null,"",null,""]
[null,{"$f":"+IF($AB$212=1,W257,Z257)","v":"Centro del lado empotrado"},{"$nulls":6},"0.128wh2",null,"0.258wh2",null,"0.375wh2",null,"0.406wh2",null,"",null,"",{"$nulls":3},0.5,1,2,3,"",""]
[null,"Tercio inferior del lado empotrado",{"$nulls":6},"0.174wh2",null,"0.311wh2",null,"0.406wh2",null,"0.416wh2",null,"",null,"",{"$nulls":3},"0.141wh2","0.242wh2","0.380wh2","0.450wh2","",""]
[null,"Cuarto inferior del lado empotrado",{"$nulls":6},"0.192wh2b",null,"0.315wh2b",null,"0.390wh2b",null,"0.398wh2b",null,"",null,"",{"$nulls":3},"-0.258wh2","-0.440wh2","-0.583wh2","-0.590wh2","",""]
[null,"Total en el borde inferior",{"$nulls":6},"0.048wh2b",null,"0.096wh2b",null,"0.204wh2b",null,"0.286wh2b",null,"",null,"",{"$nulls":3},"0.000wh2","0.010wh2","0.100wh2","0.165wh2","",""]
[null,"Total de un lado empotrado",{"$nulls":6},"0.226wh2b",null,"0.202wh2b",null,"0.148wh2b",null,"0.107wh2b",null,"",null,"",{"$nulls":3},"0.128wh2","0.258wh2","0.375wh2","0.406wh2","",""]
[null,"Total de los 4 bordes",{"$nulls":6},"0.500wh2b",null,"0.500wh2b",null,"0.500wh2b",null,"0.500wh2b",null,"",null,"",{"$nulls":3},"0.174wh2","0.311wh2","0.406wh2","0.416wh2","",""]
[{"$nulls":22},"0.192wh2b","0.315wh2b","0.390wh2b","0.398wh2b","",""]
[{"$nulls":9},"b/h =",{"$f":"+P42","v":{"v":0,"d":"0.00"}},{"$nulls":11},"0.048wh2b","0.096wh2b","0.204wh2b","0.286wh2b","",""]
[{"$nulls":22},"0.226wh2b","0.202wh2b","0.148wh2b","0.107wh2b","",""]
[{"$nulls":22},"0.500wh2b","0.500wh2b","0.500wh2b","0.500wh2b","",""]
[]
[{"$nulls":22},{"$f":"+IF($AB$212=1,AnexoV!M3,AnexoVI!M3)","v":{"v":0,"d":"0.0000"}},{"$f":"+IF($AB$212=1,AnexoV!N3,AnexoVI!N3)","v":{"v":0.01,"d":"0.0100"}},{"$f":"+IF($AB$212=1,AnexoV!O3,AnexoVI!O3)","v":{"v":0.1,"d":"0.1000"}},{"$f":"+IF($AB$212=1,AnexoV!P3,AnexoVI!P3)","v":{"v":0.165,"d":"0.1650"}},{"$f":"+IF($AB$212=1,AnexoV!Q3,AnexoVI!Q3)","v":{"v":0,"d":"0.0000"}}]
[{"$nulls":22},{"$f":"+IF($AB$212=1,AnexoV!M4,AnexoVI!M4)","v":{"v":0.128,"d":"0.1280"}},{"$f":"+IF($AB$212=1,AnexoV!N4,AnexoVI!N4)","v":{"v":0.258,"d":"0.2580"}},{"$f":"+IF($AB$212=1,AnexoV!O4,AnexoVI!O4)","v":{"v":0.375,"d":"0.3750"}},{"$f":"+IF($AB$212=1,AnexoV!P4,AnexoVI!P4)","v":{"v":0.406,"d":"0.4060"}},{"$f":"+IF($AB$212=1,AnexoV!Q4,AnexoVI!Q4)","v":{"v":0.5,"d":"0.5000"}}]
[{"$nulls":22},{"$f":"+IF($AB$212=1,AnexoV!M5,AnexoVI!M5)","v":{"v":0.174,"d":"0.1740"}},{"$f":"+IF($AB$212=1,AnexoV!N5,AnexoVI!N5)","v":{"v":0.311,"d":"0.3110"}},{"$f":"+IF($AB$212=1,AnexoV!O5,AnexoVI!O5)","v":{"v":0.406,"d":"0.4060"}},{"$f":"+IF($AB$212=1,AnexoV!P5,AnexoVI!P5)","v":{"v":0.416,"d":"0.4160"}},{"$f":"+IF($AB$212=1,AnexoV!Q5,AnexoVI!Q5)","v":{"v":0.6666666666666667,"d":"0.6667"}}]
[{"$nulls":22},{"$f":"+IF($AB$212=1,AnexoV!M6,AnexoVI!M6)","v":{"v":0.192,"d":"0.1920"}},{"$f":"+IF($AB$212=1,AnexoV!N6,AnexoVI!N6)","v":{"v":0.315,"d":"0.3150"}},{"$f":"+IF($AB$212=1,AnexoV!O6,AnexoVI!O6)","v":{"v":0.39,"d":"0.3900"}},{"$f":"+IF($AB$212=1,AnexoV!P6,AnexoVI!P6)","v":{"v":0.398,"d":"0.3980"}},{"$f":"+IF($AB$212=1,AnexoV!Q6,AnexoVI!Q6)","v":{"v":0.75,"d":"0.7500"}}]
[{"$nulls":22},{"$f":"+IF($AB$212=1,AnexoV!M7,AnexoVI!M7)","v":{"v":0,"d":"0.0000"}},{"$f":"+IF($AB$212=1,AnexoV!N7,AnexoVI!N7)","v":{"v":0,"d":"0.0000"}},{"$f":"+IF($AB$212=1,AnexoV!O7,AnexoVI!O7)","v":{"v":0,"d":"0.0000"}},{"$f":"+IF($AB$212=1,AnexoV!P7,AnexoVI!P7)","v":{"v":0,"d":"0.0000"}},{"$f":"+IF($AB$212=1,AnexoV!Q7,AnexoVI!Q7)","v":{"v":1,"d":"1.0000"}}]
[{"$nulls":22},true,true,true,true]
[{"$nulls":22},{"$f":"IF(W$243,W238,NA())","v":{"v":0,"d":"0.0000"}},{"$f":"IF(X$243,X238,NA())","v":{"v":0.01,"d":"0.0100"}},{"$f":"IF(Y$243,Y238,NA())","v":{"v":0.1,"d":"0.1000"}},{"v":0.165,"d":"0.1650"},{"$f":"+AA238","v":{"v":0,"d":"0.0000"}}]
[{"$nulls":22},{"$f":"IF(W$243,W239,NA())","v":{"v":0.128,"d":"0.1280"}},{"v":0.258,"d":"0.2580"},{"v":0.375,"d":"0.3750"},{"v":0.406,"d":"0.4060"},{"$f":"+AA239","v":{"v":0.5,"d":"0.5000"}}]
[{"$nulls":22},{"v":0.174,"d":"0.1740"},{"v":0.311,"d":"0.3110"},{"v":0.406,"d":"0.4060"},{"v":0.416,"d":"0.4160"},{"v":0.6666666666666667,"d":"0.6667"}]
[{"$nulls":22},{"v":0.192,"d":"0.1920"},{"v":0.315,"d":"0.3150"},{"v":0.39,"d":"0.3900"},{"v":0.398,"d":"0.3980"},{"v":0.75,"d":"0.7500"}]
[{"$nulls":22},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":1,"d":"1.0000"}]
[]
[]
[]
[]
[]
[]
[null,"De la tabla y del grafico anterior obtenemos un cortante maximo de:",{"$nulls":11},"*wh2 *",null,"=",{"$f":"+IFERROR(L255*G21*G15*G15*O255,)","v":{"v":0,"d":"0.000"}},null,null,"kg"]
[{"$nulls":22},"Centro del lado empotrado",null,null,"Tope inferior del lado empotrado"]
[null,"La resistencia del concreto al cortante esta dado por la siguiente expresión:",{"$nulls":20},"Tercio inferior del lado empotrado",null,null,"Centro del lado empotrado"]
[{"$nulls":22},"Cuarto inferior del lado empotrado",null,null,"Tercio inferior del lado empotrado"]
[{"$nulls":5},"ØVc =",null,"* 0.53 * √f'c * b * d1  =",{"$nulls":3},{"$f":"+G259*0.53*SQRT(G25)*E150*N192","v":{"v":0,"d":"0.000"}},null,null,"kg",{"$nulls":7},"Total en el borde superior",null,null,"Cuarto inferior del lado empotrado"]
[]
[null,"Verificamos el efecto de corte"]
[]
[{"$nulls":3},"Vu=",{"$f":"+IFERROR(MAX(Q255,L218),)","v":{"v":0,"d":"0.000"}},null,null,"kg","<",null,"ØVc=",{"$f":"+L259","v":{"v":0,"d":"0.000"}},null,null,"kg",null,{"$f":"+IF(E263<L263,\"Cumple\",\"Cambiar seccion\")","v":"Cambiar seccion"}]
[]
[null,"Revision de la longitud de anclaje del gancho del muro en la cimentacion"]
[]
[null,"La longitud basica de anclaje de un gancho estandar, para acero de diametro de:",{"$nulls":11},"Ø",{"$f":"+Q184","v":0},", es:"]
[]
[{"$nulls":4},"ldh = ( 318 * db ) / √f'c",{"$nulls":8},"ldh=",{"$f":"IFERROR(318*HLOOKUP(O267,W269:AB270,2,0)/SQRT(G25),)","v":{"v":0,"d":"0.00"}},null,"cm",{"$nulls":4},"Ø","3/8\"","1/2\"","5/8\"","3/4\"","7/8\"","1\""]
[{"$nulls":21},"db",0.98,1.27,1.59,1.91,2.22,2.54]
[null,"La longitud de anclaje del gancho se reduce por los factores que cumplen las condiciones del ACI"]
[]
[null,null,"r1=",null,null,"Para ganchos de diametro menor a #11 con dobles de 90°, recubrimiento lateral mayor a 6.5 cm"]
[{"$nulls":5},"y recubrimiento detrás del acero de refuerzo de 5 cm."]
[]
[null,null,"r2=","As req",null,"=",{"$f":"IFERROR(+N200/(HLOOKUP(Q184,V182:AA184,2,FALSE)*100/(S184*100)),)","v":{"v":0,"d":"0.0000"}}]
[{"$nulls":3},"As prov"]
[]
[null,"La longitud de anclaje del gancho sera finalmente:",{"$nulls":8},"Ldh=","r1*r2*ldh"]
[]
[{"$nulls":3},"Ldh=",{"$f":"+G276*D273*O269","v":{"v":0,"d":"0.00"}},null,"cm",null,"<",null,"Hz=",{"$f":"+G19*100","v":{"v":0,"d":"0.00"}},null,"cm",null,null,{"$f":"+IF(E281<L281,\"Cumple\",\"Cambiar seccion\")","v":"Cambiar seccion"}]
[]
["03","ANALISIS Y DISEÑO DE LA LOSA DE CUBIERTA"]
[]
[null,"La losa de cubierta sera considerada como una losa armada en dos sentidos y apoyada en sus cuatro lados. Para el calculo del"]
[null,"espesor de la losa tenemos:"]
[]
[null,null,"Espesor de los apoyos (muros):",{"$nulls":4},"e1 =",{"$f":"+E158/100","v":{"v":0,"d":"0.00"}},null,"m",null,"Luz interna (Ancho muro):",{"$nulls":3},"Li =",{"$f":"+G28","v":{"v":0,"d":"0.00"}},null,"m"]
[]
[null,null,"Luz de calculo (L) :",{"$nulls":4},"L =",{"$f":"+CONCATENATE(R288,\"  +\")","v":"0  +"},null,{"$f":"+CONCATENATE(\"2 (\",I288,\") / 2\")","v":"2 (0) / 2"},null,"=",{"$f":"+R288+2*I288/2","v":{"v":0,"d":"0.00"}},null,"m"]
[]
[null,"Hallamos el espesor \"e2\" de la losa de cubierta:"]
[]
[null,null,"e2 ="," L ",null,null,"e2 =",{"$f":"+N290","v":{"v":0,"d":"0.00"}},null,"=",{"$f":"+N290/36","v":{"v":0,"d":"0.00"}},null,"m",{"$nulls":3},"e2 min =",null,null,"m"]
[{"$nulls":3},36,{"$nulls":3},36]
[]
[null,"El espesor de la losa de cubierta para el diseño de concreto armado sera:",{"$nulls":11},"e2=",{"$f":"+IF(K294<R294,R294,0.025*(ROUNDUP(K294/0.025,0)) )","v":0},null,"m"]
[]
[null,"Segun el Reglamento Nacional de Edificaciones para losas macizas en dos direcciones, cuando la relacion de los dos lados es"]
[null,"igual a la unidad, los momentos flexionantes en las fajas centrales son:"]
[]
[{"$nulls":8},"Ma = Mb = C . W . L2"]
[]
[null,"Donde :",null,"C ="]
[{"$nulls":3},"W : Es el peso de la carga muerta y la carga viva"]
[{"$nulls":3},"L : Es la luz libre entre ejes de los apoyos"]
[]
[null,"El peso de la sobrecarga sera:"]
[]
[null,null,"Peso Propio (CM) :",null,null,{"$f":"+O297","v":0},null,"m    x",{"$f":"+G22","v":{"v":0,"d":"0.00"}},null,"kg/m3","x",null,"=",{"$f":"+F310*I310*M310","v":{"v":0,"d":"0.00"}},null,"kg/m2"]
[null,null,"Sobre carga (CV) :",{"$nulls":7},"kg/m2","x",null,"=",{"$f":"+I311*M311","v":{"v":0,"d":"0.00"}},null,"kg/m2"]
[{"$nulls":13},"W =",{"$f":"+SUM(O310:P311)","v":{"v":0,"d":"0.00"}},null,"kg/m2"]
[]
[null,"Reemplazando en la ecuacion de momentos, se tiene:",{"$nulls":10},"Ma = Mb =",{"$f":"+E304*O312*N290*N290","v":{"v":0,"d":"0.00"}},null,null,"kg-m"]
[]
[null,"Conocidos los valores de los momentos, se calcula el espesor util \"d2\" mediante el metodo elastico con la siguiente relacion:"]
[]
[null,null,"d2 = L * [ W / (Ø*f'c*b*w*(1-0.59w)) ]1/2",{"$nulls":8},"w = ρ*fy / f'c",{"$nulls":3},"ρ = Asmin / (b*e2min)",{"$nulls":6},{"$f":"+(I320)/(R294*100*E150)","v":{"$error":"#DIV/0!"}},{"$f":"+W318*G26/G25","v":{"$error":"#DIV/0!"}}]
[]
[{"$nulls":3},"As min =",null,null,"*b*e2min =",null,{"$f":"+E320*E150*R294*100","v":{"v":0,"d":"0.00"}},null,"cm2",{"$nulls":4},"Ø ="]
[]
[null,"Reemplazando valores en la ecuación anterior tenemos el espesor útil calculado :",{"$nulls":12},"d2=",{"$f":"IFERROR(+(N290*100*SQRT((O312/10000)/(Q320*G25*E150*X318*(1-0.59*X318)))),)","v":{"v":0,"d":"0.00"}},null,"cm"]
[]
[null,"Considerando un recubrimiento de :",{"$nulls":12},"r2 =",null,null,"cm"]
[]
[null,"Tenemos que el espeesor de la losa de cubierta sera de :",{"$nulls":12},"e2 = d2 + r2 =",{"$f":"+P324+P322","v":{"v":0,"d":"0.00"}},null,"cm"]
[]
[null,{"$f":"+IF(P326<(R294*100),\"Siendo el Espesor Calculado menor que el Espesor Mínimo, tomamos el espesor e2 anterior\",\"Siendo el Espesor Calculado mayor que el Espesor Mínimo, tomamos el espesor mayor de los e2 hallados anteriormente\")","v":"Siendo el Espesor Calculado mayor que el Espesor Mínimo, tomamos el espesor mayor de los e2 hallados anteriormente"}]
[]
[null,"El espesor de la losa de cubierta para el diseño de concreto armado sera:",{"$nulls":12},"e2 =",{"$f":"+IF(P326>(O297*100),2.5*ROUNDUP(P326/2.5,0),MAX(P326,O297*100))","v":{"v":0,"d":"0.00"}},null,"cm"]
[]
[null,"Diseño de la armadura en la losa de cubierta"]
[]
[null,"Para el diseno estructural del refuerzo se considera el momento en el centro de la losa cuyo valor permitira definir el area de acero."]
[]
[null,"De los calculos anteriores tenemos que momento de diseño es:",{"$nulls":9},"Mx =",{"$f":"+N314","v":{"v":0,"d":"0.00"}},null,null,"kg-m"]
[]
[null,null,"r2 =",{"$f":"+P324","v":{"v":0,"d":"0.00"}},null,"cm","(Recubrimiento)",{"$nulls":5},"d2 =",{"$f":"+P330-D338","v":{"v":0,"d":"0.00"}},null,"cm","(Peralte efectivo)"]
[]
[null,"Calculamos el area de acero con la siguiente ecuacion:",{"$nulls":8},"Mu = 0.9*b*d2*f'c*w*(1-0.59w)"]
[]
[null,null,"Factor de reduccion f'c :",{"$nulls":8},"Factor de reduccion fy :"]
[]
[{"$nulls":3},"w1=",{"$f":"IFERROR(+(-V345+SQRT((V345^2)-4*V344*V346))/(2*V344),)","v":{"v":0,"d":"0.00000"}},{"$nulls":7},"w2=",{"$f":"IFERROR(+(-V345-SQRT((V345^2)-4*V344*V346))/(2*V344),)","v":{"v":0,"d":"0.0000"}},{"$nulls":7},0.59]
[{"$nulls":21},{"$f":"+-1","v":-1}]
[{"$nulls":3},"ρ =",{"$f":"IFERROR(+MIN(N344,E344)*G25/(G26*P342),)","v":{"v":0,"d":"0.00000"}},{"$nulls":7},"As=",{"$f":"+E346*E150*N338","v":{"v":0,"d":"0.00"}},null,"cm2",{"$nulls":5},{"$f":"+(M336*100)/(0.9*E150*((N338)^2)*G25*G342)","v":{"$error":"#DIV/0!"}}]
[]
[null,"El acero minimo es dado por :",{"$nulls":4},"Asmin =",null,null,"*b*e2",null,null,"Asmin =",{"$f":"H348*E150*P330","v":{"v":0,"d":"0.00"}},null,"cm2"]
[]
[null,"Por lo tanto el area de acero que utilizaremos en la losa de cubierta sera: ",{"$nulls":10},"As =",{"$f":"+MAX(N346,N348)","v":{"v":0,"d":"0.00"}},null,"cm2"]
[]
[null,"La distribucion de acero vertical en el muro sera de :"]
[]
[null,"Ø","3/8\"",null,"1/2\"",null,"5/8\"",null,"3/4\"",null,"7/8\"",null,"1\"",null,null,"Distribucion de acero",{"$nulls":5},{"$f":"+C354","v":"3/8\""},{"$f":"+E354","v":"1/2\""},{"$f":"+G354","v":"5/8\""},{"$f":"+I354","v":"3/4\""},{"$f":"+K354","v":"7/8\""},{"$f":"+M354","v":"1\""}]
[null,"Area",0.71,null,1.27,null,1.98,null,2.85,null,3.88,null,5.07,{"$nulls":8},{"$f":"+C355","v":0.71},{"$f":"+E355","v":1.27},{"$f":"+G355","v":1.98},{"$f":"+I355","v":2.85},{"$f":"+K355","v":3.88},{"$f":"+M355","v":5.07}]
[null,"s (cm)",{"$f":"IFERROR(+C355*100/$N$350,)","v":{"v":0,"d":"0.00"}},null,{"$f":"IFERROR(+E355*100/$N$350,)","v":{"v":0,"d":"0.00"}},null,{"$f":"IFERROR(+G355*100/$N$350,)","v":{"v":0,"d":"0.00"}},null,{"$f":"IFERROR(+I355*100/$N$350,)","v":{"v":0,"d":"0.00"}},null,{"$f":"IFERROR(+K355*100/$N$350,)","v":{"v":0,"d":"0.00"}},null,{"$f":"IFERROR(+M355*100/$N$350,)","v":{"v":0,"d":"0.00"}},null,null,"Ø",null,"@",{"$f":"IFERROR((2.5*(ROUNDDOWN(HLOOKUP(Q356,V354:AA356,3,0)/2.5,0)))/100,)","v":{"v":0,"d":"0.000"}},null,"m",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[]
[null,"Verificacion por cortante en la losa de cubierta del reservorio"]
[]
[null,"Se verifica el efecto del cortante en la cara del muro. El cortante que se produce por las cargas en la losa de cubierta es:"]
[]
[null,"El cortante en la cara del muro se da en la luz interna del reservorio :",{"$nulls":9},"Li =",{"$f":"+R288","v":{"v":0,"d":"0.00"}},null,"m"]
[]
[{"$nulls":6},"Vu =",null,"* W * Li",null,"=",{"$f":"+H364*O312*M362/3","v":{"v":0,"d":"0.00"}},null,null,"kg"]
[{"$nulls":7},3]
[]
[null,"La resistencia del concreto al cortante esta dado por la siguiente expresión:"]
[]
[{"$nulls":5},"ØVc =",null,"* 0.53 * √f'c * b * d2  =",{"$nulls":3},{"$f":"+G369*0.53*SQRT(G25)*E150*N338","v":{"v":0,"d":"0.000"}},null,null,"kg"]
[]
[null,"Verificamos el efecto de corte"]
[]
[{"$nulls":3},"Vu=",{"$f":"+L364","v":{"v":0,"d":"0.000"}},null,null,"kg","<",null,"ØVc=",{"$f":"+L369","v":{"v":0,"d":"0.000"}},null,null,"kg",null,{"$f":"+IF(E373<L373,\"Cumple\",\"Cambiar seccion\")","v":"Cambiar seccion"}]
[]
[null,"Revision de la longitud de anclaje del gancho de la losa de cubierta en el muro del reservorio"]
[]
[null,"La longitud basica de anclaje de un gancho estandar, para acero de diametro de:",{"$nulls":11},"Ø",{"$f":"+Q356","v":0},", es:"]
[]
[{"$nulls":4},"ldh = ( 318 * db ) / √f'c",{"$nulls":8},"ldh=",{"$f":"IFERROR(318*HLOOKUP(O377,W379:AB380,2,0)/SQRT(G25),)","v":{"v":0,"d":"0.00"}},null,"cm",{"$nulls":4},"Ø","3/8\"","1/2\"","5/8\"","3/4\"","7/8\"","1\""]
[{"$nulls":21},"db",0.98,1.27,1.59,1.91,2.22,2.54]
[null,"La longitud de anclaje del gancho se reduce por los factores que cumplen las condiciones del ACI"]
[]
[null,null,"r1=",null,null,"Para ganchos de diametro menor a #11 con dobles de 90°, recubrimiento lateral mayor a 6.5 cm"]
[{"$nulls":5},"y recubrimiento detrás del acero de refuerzo de 5 cm."]
[]
[null,null,"r2=","As req",null,"=",{"$f":"IFERROR(+N346/(HLOOKUP(Q356,V354:AA356,2,FALSE)*100/(S356*100)),)","v":{"v":0,"d":"0.0000"}}]
[{"$nulls":3},"As prov"]
[]
[null,"La longitud de anclaje del gancho sera finalmente:",{"$nulls":8},"Ldh=","r1*r2*ldh"]
[]
[{"$nulls":3},"Ldh=",{"$f":"+G386*D383*O379","v":{"v":0,"d":"0.00"}},null,"cm",null,"<",null,"e1=",{"$f":"+E158","v":{"v":0,"d":"0.00"}},null,"cm",null,null,{"$f":"+IF(E391<L391,\"Cumple\",\"Cambiar seccion\")","v":"Cambiar seccion"}]
[]
["04","ANALISIS Y DISEÑO DE LA LOSA DE FONDO"]
[]
[null,"Para el diseño de la losa de fonfo, asumiremos un espesor inicial :",{"$nulls":12},"e3min =",null,null,"cm"]
[]
[null,"Con la altura de agua y espesor de la losa de fondo procedemos a calcular la fuerza ejercida sobre esta losa:"]
[]
[null,null,"Peso del agua (CV):",null,null,{"$f":"+G15","v":{"v":0,"d":"0.00"}},null,"m    x",{"$f":"+G21","v":{"v":0,"d":"0.00"}},null,"kg/m3","x",null,"=",{"$f":"+F399*I399*M399","v":{"v":0,"d":"0.00"}},null,"kg/m2"]
[null,null,"Peso propio (CM) :",null,null,{"$f":"+P395/100","v":{"v":0,"d":"0.00"}},null,"m    x",{"$f":"+G22","v":{"v":0,"d":"0.00"}},null,"kg/m3","x",null,"=",{"$f":"+F400*I400*M400","v":{"v":0,"d":"0.00"}},null,"kg/m2"]
[{"$nulls":13},"W =",{"$f":"+SUM(O399:P400)","v":{"v":0,"d":"0.00"}},null,"kg/m2"]
[]
[null,"La losa de fondo sera analizada como una placa flexible y no como una placa rigida, debido a que el espesor es pequeno en"]
[null,"relación a la longitud; ademas la consideraremos apoyada en un medio cuya rigidez aumenta con el empotramiento."]
[null,"Dicha placa estará empotrada en los bordes."]
[]
[null,"Debido a la accion de las cargas verticales actuantes para una luz de:",{"$nulls":11},"L =",{"$f":"+N290","v":{"v":0,"d":"0.00"}},null,"m"]
[]
[null,"Se originan los siguientes momentos de empotramiento en los extremos:"]
[]
[{"$nulls":4},"M = -WL2 / 192",{"$nulls":8},"M =",{"$f":"-O401*O407*O407/192","v":{"v":0,"d":"0.00"}},null,"kg-m"]
[]
[null,"El momento generado en el centro de luz de la losa de fondo será:"]
[]
[{"$nulls":4},"M = WL2 / 384",{"$nulls":8},"M =",{"$f":"+O401*O407*O407/384","v":{"v":0,"d":"0.00"}},null,"kg-m"]
[]
[null,"Para losas planas rectangulares reforzadas con acero en dos direcciones, Timoshenko recomienda los siguientes coeficientes:"]
[]
[null,null,"Para un momento de empotramiento :",{"$nulls":9},"Para un momento en el centro :"]
[]
[null,"Utilizando los coeficientes mencionados anteriormente tenemos lo siguientes momentos:"]
[]
[null,"Momento de empotramiento :",{"$nulls":4},"Me =",{"$f":"+O411*I419","v":{"v":0,"d":"0.00"}},null,"kg-m",null,null,"Momento en el centro:",{"$nulls":3},"Mc =",{"$f":"+O415*R419","v":{"v":0,"d":"0.00"}},null,"kg-m"]
[]
[null,"Calculamos el momento de acuerdo a las tablas de la PCA:",{"$nulls":12},"b/h =",{"$f":"+P42","v":{"v":0,"d":"0.00"}}]
[]
[null,"Para la relación se presentan los coeficientes (k) para el cáculo de los momentos, cuya información se muestra a continuación:"]
[]
[{"$nulls":3},"b/h","x/h","y = 0",{"$nulls":3},"y = b/4",{"$nulls":3},"y = b/2"]
[{"$nulls":5},"Mx",null,"My",null,"Mx",null,"My",null,"Mx",null,"My"]
[{"$nulls":3},{"$f":"+P425","v":0},0,{"$f":"+IFERROR(W431,)","v":{"v":0,"d":"0.000"}},null,{"$f":"IFERROR(+X431,)","v":{"v":0,"d":"0.000"}},null,{"$f":"IFERROR(+Y431,)","v":{"v":0,"d":"0.000"}},null,{"$f":"IFERROR(+Z431,)","v":{"v":0,"d":"0.000"}},null,{"$f":"IFERROR(+AA431,)","v":{"v":0,"d":"0.000"}},null,{"$f":"IFERROR(+AB431,)","v":{"v":0,"d":"0.000"}},{"$nulls":5},{"$f":"+$D$48+0.05","v":0.05},{"$f":"+VLOOKUP(V431,AnexoIV!$E$16:$K$60,2,0)","v":{"$error":"#N/A"}},{"$f":"+VLOOKUP(V431,AnexoIV!$E$16:$K$60,3,0)","v":{"$error":"#N/A"}},{"$f":"+VLOOKUP(V431,AnexoIV!$E$16:$K$60,4,0)","v":{"$error":"#N/A"}},{"$f":"+VLOOKUP(V431,AnexoIV!$E$16:$K$60,5,0)","v":{"$error":"#N/A"}},{"$f":"+VLOOKUP(V431,AnexoIV!$E$16:$K$60,6,0)","v":{"$error":"#N/A"}},{"$f":"+VLOOKUP(V431,AnexoIV!$E$16:$K$60,7,0)","v":{"$error":"#N/A"}}]
[{"$nulls":4},0.25,{"$f":"+IFERROR(W432,)","v":{"v":0,"d":"0.000"}},null,{"$f":"IFERROR(+X432,)","v":{"v":0,"d":"0.000"}},null,{"$f":"IFERROR(+Y432,)","v":{"v":0,"d":"0.000"}},null,{"$f":"IFERROR(+Z432,)","v":{"v":0,"d":"0.000"}},null,{"$f":"IFERROR(+AA432,)","v":{"v":0,"d":"0.000"}},null,{"$f":"IFERROR(+AB432,)","v":{"v":0,"d":"0.000"}},{"$nulls":5},{"$f":"+$D$48+0.04","v":0.04},{"$f":"+VLOOKUP(V432,AnexoIV!$E$16:$K$60,2,0)","v":{"$error":"#N/A"}},{"$f":"+VLOOKUP(V432,AnexoIV!$E$16:$K$60,3,0)","v":{"$error":"#N/A"}},{"$f":"+VLOOKUP(V432,AnexoIV!$E$16:$K$60,4,0)","v":{"$error":"#N/A"}},{"$f":"+VLOOKUP(V432,AnexoIV!$E$16:$K$60,5,0)","v":{"$error":"#N/A"}},{"$f":"+VLOOKUP(V432,AnexoIV!$E$16:$K$60,6,0)","v":{"$error":"#N/A"}},{"$f":"+VLOOKUP(V432,AnexoIV!$E$16:$K$60,7,0)","v":{"$error":"#N/A"}}]
[{"$nulls":4},0.5,{"$f":"+IFERROR(W433,)","v":{"v":0,"d":"0.000"}},null,{"$f":"IFERROR(+X433,)","v":{"v":0,"d":"0.000"}},null,{"$f":"IFERROR(+Y433,)","v":{"v":0,"d":"0.000"}},null,{"$f":"IFERROR(+Z433,)","v":{"v":0,"d":"0.000"}},null,{"$f":"IFERROR(+AA433,)","v":{"v":0,"d":"0.000"}},null,{"$f":"IFERROR(+AB433,)","v":{"v":0,"d":"0.000"}},{"$nulls":5},{"$f":"+$D$48+0.03","v":0.03},{"$f":"+VLOOKUP(V433,AnexoIV!$E$16:$K$60,2,0)","v":{"$error":"#N/A"}},{"$f":"+VLOOKUP(V433,AnexoIV!$E$16:$K$60,3,0)","v":{"$error":"#N/A"}},{"$f":"+VLOOKUP(V433,AnexoIV!$E$16:$K$60,4,0)","v":{"$error":"#N/A"}},{"$f":"+VLOOKUP(V433,AnexoIV!$E$16:$K$60,5,0)","v":{"$error":"#N/A"}},{"$f":"+VLOOKUP(V433,AnexoIV!$E$16:$K$60,6,0)","v":{"$error":"#N/A"}},{"$f":"+VLOOKUP(V433,AnexoIV!$E$16:$K$60,7,0)","v":{"$error":"#N/A"}}]
[{"$nulls":4},0.75,{"$f":"+IFERROR(W434,)","v":{"v":0,"d":"0.000"}},null,{"$f":"IFERROR(+X434,)","v":{"v":0,"d":"0.000"}},null,{"$f":"IFERROR(+Y434,)","v":{"v":0,"d":"0.000"}},null,{"$f":"IFERROR(+Z434,)","v":{"v":0,"d":"0.000"}},null,{"$f":"IFERROR(+AA434,)","v":{"v":0,"d":"0.000"}},null,{"$f":"IFERROR(+AB434,)","v":{"v":0,"d":"0.000"}},{"$nulls":5},{"$f":"+$D$48+0.02","v":0.02},{"$f":"+VLOOKUP(V434,AnexoIV!$E$16:$K$60,2,0)","v":{"$error":"#N/A"}},{"$f":"+VLOOKUP(V434,AnexoIV!$E$16:$K$60,3,0)","v":{"$error":"#N/A"}},{"$f":"+VLOOKUP(V434,AnexoIV!$E$16:$K$60,4,0)","v":{"$error":"#N/A"}},{"$f":"+VLOOKUP(V434,AnexoIV!$E$16:$K$60,5,0)","v":{"$error":"#N/A"}},{"$f":"+VLOOKUP(V434,AnexoIV!$E$16:$K$60,6,0)","v":{"$error":"#N/A"}},{"$f":"+VLOOKUP(V434,AnexoIV!$E$16:$K$60,7,0)","v":{"$error":"#N/A"}}]
[{"$nulls":4},1,{"$f":"+IFERROR(W435,)","v":{"v":0,"d":"0.000"}},null,{"$f":"IFERROR(+X435,)","v":{"v":0,"d":"0.000"}},null,{"$f":"IFERROR(+Y435,)","v":{"v":0,"d":"0.000"}},null,{"$f":"IFERROR(+Z435,)","v":{"v":0,"d":"0.000"}},null,{"$f":"IFERROR(+AA435,)","v":{"v":0,"d":"0.000"}},null,{"$f":"IFERROR(+AB435,)","v":{"v":0,"d":"0.000"}},{"$nulls":5},{"$f":"+$D$48+0.01","v":0.01},{"$f":"+VLOOKUP(V435,AnexoIV!$E$16:$K$60,2,0)","v":{"$error":"#N/A"}},{"$f":"+VLOOKUP(V435,AnexoIV!$E$16:$K$60,3,0)","v":{"$error":"#N/A"}},{"$f":"+VLOOKUP(V435,AnexoIV!$E$16:$K$60,4,0)","v":{"$error":"#N/A"}},{"$f":"+VLOOKUP(V435,AnexoIV!$E$16:$K$60,5,0)","v":{"$error":"#N/A"}},{"$f":"+VLOOKUP(V435,AnexoIV!$E$16:$K$60,6,0)","v":{"$error":"#N/A"}},{"$f":"+VLOOKUP(V435,AnexoIV!$E$16:$K$60,7,0)","v":{"$error":"#N/A"}}]
[{"$nulls":3},"Valores de los coeficientes (K) para el calculo de momentos"]
[]
[null,"Los momentos se determinan mediante la siguiente fórmula:",{"$nulls":11},"M =","k * γa * h2"]
[]
[null,"Conocidos los datos se calculan los momentos, los que se muestran en el cuadro siguiente:",{"$nulls":20},0,0]
[{"$nulls":22},0,-1]
[{"$nulls":3},"b/h","x/h","y = 0",{"$nulls":3},"y = b/4",{"$nulls":3},"y = b/2"]
[{"$nulls":5},"Mx",null,"My",null,"Mx",null,"My",null,"Mx",null,"My"]
[{"$nulls":3},{"$f":"+D431","v":0},0,{"$f":"+F431*$G$21*$G$15*$G$15","v":{"v":0,"d":"0.000"}},null,{"$f":"+H431*$G$21*$G$15*$G$15","v":{"v":0,"d":"0.000"}},null,{"$f":"+J431*$G$21*$G$15*$G$15","v":{"v":0,"d":"0.000"}},null,{"$f":"+L431*$G$21*$G$15*$G$15","v":{"v":0,"d":"0.000"}},null,{"$f":"+N431*$G$21*$G$15*$G$15","v":{"v":0,"d":"0.000"}},null,{"$f":"+P431*$G$21*$G$15*$G$15","v":{"v":0,"d":"0.000"}},{"$nulls":5},{"$f":"+E444*(-1)","v":0},{"$f":"+W431*$G$21*$G$15*$G$15","v":{"$error":"#N/A"}},{"$f":"+X431*$G$21*$G$15*$G$15","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$nulls":4},0.25,{"$f":"+F432*$G$21*$G$15*$G$15","v":{"v":0,"d":"0.000"}},null,{"$f":"+H432*$G$21*$G$15*$G$15","v":{"v":0,"d":"0.000"}},null,{"$f":"+J432*$G$21*$G$15*$G$15","v":{"v":0,"d":"0.000"}},null,{"$f":"+L432*$G$21*$G$15*$G$15","v":{"v":0,"d":"0.000"}},null,{"$f":"+N432*$G$21*$G$15*$G$15","v":{"v":0,"d":"0.000"}},null,{"$f":"+P432*$G$21*$G$15*$G$15","v":{"v":0,"d":"0.000"}},{"$nulls":5},{"$f":"+E445*(-1)","v":-0.25},{"$f":"+W432*$G$21*$G$15*$G$15","v":{"$error":"#N/A"}},{"$f":"+X432*$G$21*$G$15*$G$15","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$nulls":4},0.5,{"$f":"+F433*$G$21*$G$15*$G$15","v":{"v":0,"d":"0.000"}},null,{"$f":"+H433*$G$21*$G$15*$G$15","v":{"v":0,"d":"0.000"}},null,{"$f":"+J433*$G$21*$G$15*$G$15","v":{"v":0,"d":"0.000"}},null,{"$f":"+L433*$G$21*$G$15*$G$15","v":{"v":0,"d":"0.000"}},null,{"$f":"+N433*$G$21*$G$15*$G$15","v":{"v":0,"d":"0.000"}},null,{"$f":"+P433*$G$21*$G$15*$G$15","v":{"v":0,"d":"0.000"}},{"$nulls":5},{"$f":"+E446*(-1)","v":-0.5},{"$f":"+W433*$G$21*$G$15*$G$15","v":{"$error":"#N/A"}},{"$f":"+X433*$G$21*$G$15*$G$15","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$nulls":4},0.75,{"$f":"+F434*$G$21*$G$15*$G$15","v":{"v":0,"d":"0.000"}},null,{"$f":"+H434*$G$21*$G$15*$G$15","v":{"v":0,"d":"0.000"}},null,{"$f":"+J434*$G$21*$G$15*$G$15","v":{"v":0,"d":"0.000"}},null,{"$f":"+L434*$G$21*$G$15*$G$15","v":{"v":0,"d":"0.000"}},null,{"$f":"+N434*$G$21*$G$15*$G$15","v":{"v":0,"d":"0.000"}},null,{"$f":"+P434*$G$21*$G$15*$G$15","v":{"v":0,"d":"0.000"}},{"$nulls":5},{"$f":"+E447*(-1)","v":-0.75},{"$f":"+W434*$G$21*$G$15*$G$15","v":{"$error":"#N/A"}},{"$f":"+X434*$G$21*$G$15*$G$15","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$nulls":4},1,{"$f":"+F435*$G$21*$G$15*$G$15","v":{"v":0,"d":"0.000"}},null,{"$f":"+H435*$G$21*$G$15*$G$15","v":{"v":0,"d":"0.000"}},null,{"$f":"+J435*$G$21*$G$15*$G$15","v":{"v":0,"d":"0.000"}},null,{"$f":"+L435*$G$21*$G$15*$G$15","v":{"v":0,"d":"0.000"}},null,{"$f":"+N435*$G$21*$G$15*$G$15","v":{"v":0,"d":"0.000"}},null,{"$f":"+P435*$G$21*$G$15*$G$15","v":{"v":0,"d":"0.000"}},{"$nulls":5},{"$f":"+E448*(-1)","v":-1},{"$f":"+W435*$G$21*$G$15*$G$15","v":{"$error":"#N/A"}},{"$f":"+X435*$G$21*$G$15*$G$15","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$nulls":3},"Valores de los momentos verticales y horizontales (Kg-m)"]
[]
[{"$nulls":4},"y ",null,null,"b/2",{"$nulls":4},"b/2",null,null," y"]
[{"$nulls":21},0,{"$f":"+AB444","v":{"$error":"#N/A"}},null,0,{"$f":"+AB445","v":{"$error":"#N/A"}}]
[{"$nulls":5},{"$f":"+IF(M412=\"Top: Articulado - Midle: Empotrado - Botton: Articulado\",\"Articulado\",\"Libre\")","v":"Libre"},{"$nulls":8},"Articulado",{"$nulls":6},0.25,{"$f":"+Z444","v":{"$error":"#N/A"}},null,0.25,{"$f":"+Z445","v":{"$error":"#N/A"}}]
[{"$nulls":21},0.5,{"$f":"+X444","v":{"$error":"#N/A"}},null,0.5,{"$f":"+X445","v":{"$error":"#N/A"}}]
[{"$nulls":21},0.75,{"$f":"+Z444","v":{"$error":"#N/A"}},null,0.75,{"$f":"+Z445","v":{"$error":"#N/A"}}]
[{"$nulls":5},"Articulado",{"$nulls":8},"Articulado",null,"h",{"$nulls":4},1,{"$f":"+AB444","v":{"$error":"#N/A"}},null,1,{"$f":"+AB445","v":{"$error":"#N/A"}}]
[{"$nulls":9},"x"]
[]
[{"$nulls":9},{"$f":"+IF(M412=\"Top: Libre - Midle: Empotrado - Botton: Empotrado\",\"Empotrado\",\"Articulado\")","v":"Articulado"}]
[{"$nulls":3},"γa*h",{"$f":"+IF(M412=\"Top: Libre - Midle: Empotrado - Botton: Empotrado\",\"//\",\"\")","v":""}]
[]
[null,"Graficamos los momento verticales Mx (kg-m), tenemos:"]
[]
[{"$nulls":21},0,{"$f":"+AB446","v":{"$error":"#N/A"}},null,0,{"$f":"+AB447","v":{"$error":"#N/A"}}]
[{"$nulls":21},0.25,{"$f":"+Z446","v":{"$error":"#N/A"}},null,0.25,{"$f":"+Z447","v":{"$error":"#N/A"}}]
[{"$nulls":21},0.5,{"$f":"+X446","v":{"$error":"#N/A"}},null,0.5,{"$f":"+X447","v":{"$error":"#N/A"}}]
[{"$nulls":21},0.75,{"$f":"+Z446","v":{"$error":"#N/A"}},null,0.75,{"$f":"+Z447","v":{"$error":"#N/A"}}]
[{"$nulls":21},1,{"$f":"+AB446","v":{"$error":"#N/A"}},null,1,{"$f":"+AB447","v":{"$error":"#N/A"}}]
[]
[]
[]
[]
[]
[{"$nulls":21},0,{"$f":"+AB448","v":{"$error":"#N/A"}},null,0,0]
[{"$nulls":21},0.25,{"$f":"+Z448","v":{"$error":"#N/A"}},null,1,0]
[{"$nulls":21},0.5,{"$f":"+X448","v":{"$error":"#N/A"}}]
[{"$nulls":21},0.75,{"$f":"+Z448","v":{"$error":"#N/A"}}]
[{"$nulls":21},1,{"$f":"+AB448","v":{"$error":"#N/A"}}]
[]
[]
[{"$nulls":22},{"$f":"+ABS(W444)","v":{"$error":"#N/A"}},{"$f":"+ABS(X444)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$nulls":22},{"$f":"+ABS(W445)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$nulls":22},{"$f":"+ABS(W446)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"Graficamos los momento horizontales My (kg-m), tenemos:",{"$nulls":20},{"$f":"+ABS(W447)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$nulls":22},{"$f":"+ABS(W448)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[]
[{"$nulls":22},{"$f":"+W481","v":{"$error":"#N/A"}},null,{"$f":"+X481","v":{"$error":"#N/A"}}]
[{"$nulls":22},{"$f":"+W482","v":{"$error":"#N/A"}},null,{"$f":"+X482","v":{"$error":"#N/A"}}]
[{"$nulls":22},{"$error":"#N/A"},null,{"$error":"#N/A"}]
[{"$nulls":22},{"$error":"#N/A"},null,{"$error":"#N/A"}]
[{"$nulls":22},{"$error":"#N/A"},null,{"$error":"#N/A"}]
[{"$nulls":22},{"$f":"+Y481","v":{"$error":"#N/A"}},null,{"$f":"+Z481","v":{"$error":"#N/A"}}]
[{"$nulls":22},{"$f":"+Y482","v":{"$error":"#N/A"}},null,{"$f":"+Z482","v":{"$error":"#N/A"}}]
[{"$nulls":22},{"$error":"#N/A"},null,{"$error":"#N/A"}]
[{"$nulls":22},{"$error":"#N/A"},null,{"$error":"#N/A"}]
[{"$nulls":22},{"$error":"#N/A"},null,{"$error":"#N/A"}]
[{"$nulls":22},{"$f":"+AA481","v":{"$error":"#N/A"}},null,{"$f":"+AB481","v":{"$error":"#N/A"}}]
[{"$nulls":22},{"$f":"+AA482","v":{"$error":"#N/A"}},null,{"$f":"+AB482","v":{"$error":"#N/A"}}]
[{"$nulls":22},{"$error":"#N/A"},null,{"$error":"#N/A"}]
[{"$nulls":22},{"$error":"#N/A"},null,{"$error":"#N/A"}]
[{"$nulls":22},{"$error":"#N/A"},null,{"$error":"#N/A"}]
{"$rows_empty":14}
[null,"De los graficos se puede ver que el máximo momento absoluto es:",{"$nulls":12},"Mmax =",{"$f":"IFERROR(+MAX(W481:AB485),)","v":{"v":0,"d":"0.000"}},{"$nulls":3},"kg-m"]
[]
[null,"Revisamos el espesor, considerando como máximo momento absoluto:",{"$nulls":10},"Momento para el diseño :",{"$nulls":3},"M =",{"$f":"+MAX(ABS(H423),ABS(R423),ABS(P516))","v":{"v":0,"d":"0.00"}},null,"kg-m"]
[]
[null,"Conocidos los valores de los momentos, se calcula el espesor util \"d3\" mediante el metodo elastico con la siguiente relacion:"]
[]
[null,null,"d3 = L * [ W / (Ø*f'c*b*w*(1-0.59w)) ]1/2",{"$nulls":8},"w = ρ*fy / f'c",{"$nulls":3},"ρ = Asmin / (b*e3min)",{"$nulls":6},{"$f":"+(I524)/(P395*E150)","v":{"$error":"#DIV/0!"}},{"$f":"+W522*G26/G25","v":{"$error":"#DIV/0!"}}]
[]
[{"$nulls":3},"As min =",null,null,"*b*e3min =",null,{"$f":"+E524*E150*P395","v":{"v":0,"d":"0.00"}},null,"cm2",{"$nulls":4},"Ø ="]
[]
[null,"Reemplazando valores en la ecuación anterior tenemos el espesor útil calculado :",{"$nulls":12},"d3=",{"$f":"IFERROR(+(O407*100*SQRT((O401/10000)/(Q524*G25*E150*X522*(1-0.59*X522)))),)","v":{"v":0,"d":"0.00"}},null,"cm"]
[]
[null,"Considerando un recubrimiento de :",{"$nulls":12},"r3 =",null,null,"cm"]
[]
[null,"Tenemos que el espeesor de la losa de cubierta sera de :",{"$nulls":12},"e3 = d3 + r3 =",{"$f":"+P528+P526","v":{"v":0,"d":"0.00"}},null,"cm"]
[]
[null,{"$f":"+IF(P530<(P395),\"Siendo el Espesor Calculado menor que el Espesor Mínimo, tomamos el espesor e3 anterior\",\"Siendo el Espesor Calculado mayor que el Espesor Mínimo, tomamos el espesor mayor del e3 hallado anteriormente\")","v":"Siendo el Espesor Calculado mayor que el Espesor Mínimo, tomamos el espesor mayor del e3 hallado anteriormente"}]
[]
[null,"El espesor de la losa de cubierta para el diseño de concreto armado sera:",{"$nulls":12},"e2 =",{"$f":"+IF(P530>(P395),2.5*ROUNDUP(P530/2.5,0),MAX(P530,P395))","v":{"v":0,"d":"0.00"}},null,"cm"]
[]
[null,"Diseño de la armadura en la losa de fondo"]
[]
[null,"Para el diseno estructural del refuerzo se considera el momento mayor de la losa cuyo valor permitira definir el area de acero."]
[]
[null,"De los calculos anteriores tenemos que momento de diseño es:",{"$nulls":9},"Mx =",{"$f":"+R518","v":{"v":0,"d":"0.00"}},null,null,"kg-m"]
[]
[null,null,"r3 =",{"$f":"+P528","v":{"v":0,"d":"0.00"}},null,"cm","(Recubrimiento)",{"$nulls":5},"d3 =",{"$f":"+P534-D542","v":{"v":0,"d":"0.00"}},null,"cm","(Peralte efectivo)"]
[]
[null,"Calculamos el area de acero con la siguiente ecuacion:",{"$nulls":8},"Mu = 0.9*b*d2*f'c*w*(1-0.59w)"]
[]
[null,null,"Factor de reduccion f'c :",{"$nulls":8},"Factor de reduccion fy :"]
[]
[{"$nulls":3},"w1=",{"$f":"IFERROR(+(-V549+SQRT((V549^2)-4*V548*V550))/(2*V548),)","v":{"v":0,"d":"0.00000"}},{"$nulls":7},"w2=",{"$f":"IFERROR(+(-V549-SQRT((V549^2)-4*V548*V550))/(2*V548),)","v":{"v":0,"d":"0.0000"}},{"$nulls":7},0.59]
[{"$nulls":21},{"$f":"+-1","v":-1}]
[{"$nulls":3},"ρ =",{"$f":"IFERROR(+MIN(N548,E548)*G25/(G26*P546),)","v":{"v":0,"d":"0.00000"}},{"$nulls":7},"As=",{"$f":"+E550*E150*N542","v":{"v":0,"d":"0.00"}},null,"cm2",{"$nulls":5},{"$f":"+(M540*100)/(0.9*E150*((N542)^2)*G25*G546)","v":{"$error":"#DIV/0!"}}]
[]
[null,"El acero minimo es dado por :",{"$nulls":4},"Asmin =",null,null,"*b*e2",null,null,"Asmin =",{"$f":"H552*E150*P534","v":{"v":0,"d":"0.00"}},null,"cm2"]
[]
[null,"Por lo tanto el area de acero que utilizaremos en la losa de cubierta sera: ",{"$nulls":10},"As =",{"$f":"+MAX(N550,N552)","v":{"v":0,"d":"0.00"}},null,"cm2"]
[]
[null,"La distribucion de acero vertical en el muro sera de :"]
[]
[null,"Ø","3/8\"",null,"1/2\"",null,"5/8\"",null,"3/4\"",null,"7/8\"",null,"1\"",null,null,"Distribucion de acero",{"$nulls":5},{"$f":"+C558","v":"3/8\""},{"$f":"+E558","v":"1/2\""},{"$f":"+G558","v":"5/8\""},{"$f":"+I558","v":"3/4\""},{"$f":"+K558","v":"7/8\""},{"$f":"+M558","v":"1\""}]
[null,"Area",0.71,null,1.27,null,1.98,null,2.85,null,3.88,null,5.07,{"$nulls":8},{"$f":"+C559","v":0.71},{"$f":"+E559","v":1.27},{"$f":"+G559","v":1.98},{"$f":"+I559","v":2.85},{"$f":"+K559","v":3.88},{"$f":"+M559","v":5.07}]
[null,"s (cm)",{"$f":"IFERROR(+C559*100/$N$554,)","v":{"v":0,"d":"0.00"}},null,{"$f":"IFERROR(+E559*100/$N$554,)","v":{"v":0,"d":"0.00"}},null,{"$f":"IFERROR(+G559*100/$N$554,)","v":{"v":0,"d":"0.00"}},null,{"$f":"IFERROR(+I559*100/$N$554,)","v":{"v":0,"d":"0.00"}},null,{"$f":"IFERROR(+K559*100/$N$554,)","v":{"v":0,"d":"0.00"}},null,{"$f":"IFERROR(+M559*100/$N$554,)","v":{"v":0,"d":"0.00"}},null,null,"Ø",null,"@",{"$f":"IFERROR((2.5*(ROUNDDOWN(HLOOKUP(Q560,V558:AA560,3,0)/2.5,0)))/100,)","v":{"v":0,"d":"0.000"}},null,"m",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[]
[null,"Verificacion por cortante en la losa de fondo del reservorio"]
[]
[null,"Se verifica el efecto del cortante en la cara del muro. El cortante que se produce por las cargas en la losa de fondo es:"]
[]
[null,"El cortante en la cara del muro se da en la luz interna del reservorio :",{"$nulls":9},"Li =",{"$f":"+R288","v":{"v":0,"d":"0.00"}},null,"m"]
[]
[{"$nulls":6},"Vu =",null,"* W * Li",null,"=",{"$f":"+H568*O401*M566/3","v":{"v":0,"d":"0.00"}},null,null,"kg"]
[{"$nulls":7},3]
[]
[null,"Calculamos el cortante usando las tablas del PCA para el tipo de reservorio:"]
[]
[null,"b/h",{"$nulls":6},{"$f":"+IF($AB$573=1,W577,IF($AB$573=2,W588,\"\"))","v":0.5},null,{"$f":"+IF($AB$573=1,X577,IF($AB$573=2,X588,\"\"))","v":1},null,{"$f":"+IF($AB$573=1,Y577,IF($AB$573=2,Y588,\"\"))","v":2},null,{"$f":"+IF($AB$573=1,Z577,IF($AB$573=2,Z588,\"\"))","v":3},null,{"$f":"+IF($AB$573=1,AA577,IF($AB$573=2,AA588,\"\"))","v":""},null,{"$f":"+IF($AB$573=1,AB577,IF($AB$573=2,AB588,\"\"))","v":""},{"$nulls":3},"Top: Articulado - Midle: Empotrado - Botton: Articulado",{"$nulls":4},{"$f":"+IF(M571=\"Top: Articulado - Midle: Empotrado - Botton: Articulado\",1,2)","v":2}]
[null,"Centro de la base",{"$nulls":6},"0.141wh2",null,"0.242wh2",null,"0.380wh2",null,"0.450wh2",null,"",null,"",{"$nulls":3},"Top: Libre - Midle: Empotrado - Botton: Articulado"]
[null,"Vértice de la base",{"$nulls":6},"-0.258wh2",null,"-0.440wh2",null,"-0.583wh2",null,"-0.590wh2",null,"",null,""]
[null,{"$f":"+IF($AB$212=1,W610,Z610)","v":"Tope inferior del lado empotrado"},{"$nulls":6},"0.000wh2",null,"0.010wh2",null,"0.100wh2",null,"0.165wh2",null,"",null,""]
[null,{"$f":"+IF($AB$212=1,W611,Z611)","v":"Centro del lado empotrado"},{"$nulls":6},"0.128wh2",null,"0.258wh2",null,"0.375wh2",null,"0.406wh2",null,"",null,"",{"$nulls":3},0.5,1,2,5,10,"Infinito"]
[null,{"$f":"+IF($AB$212=1,W612,Z612)","v":"Tercio inferior del lado empotrado"},{"$nulls":6},"0.174wh2",null,"0.311wh2",null,"0.406wh2",null,"0.416wh2",null,"",null,"",{"$nulls":3},"0.1407wh2","0.2419wh2","0.3290wh2","","","0.3333wh2"]
[null,{"$f":"+IF($AB$212=1,W613,Z613)","v":"Cuarto inferior del lado empotrado"},{"$nulls":6},"0.192wh2b",null,"0.315wh2b",null,"0.390wh2b",null,"0.398wh2b",null,"",null,"",{"$nulls":3},"-0.2575wh2","-0.4397wh2","-0.5833wh2","","","-0.6000wh2"]
[null,"Total en el borde inferior",{"$nulls":6},"0.048wh2b",null,"0.096wh2b",null,"0.204wh2b",null,"0.286wh2b",null,"",null,"",{"$nulls":3},"0.1280wh2","0.2582wh2","0.3604wh2","","","0.3912wh2"]
[null,"Total de un lado empotrado",{"$nulls":6},"0.226wh2b",null,"0.202wh2b",null,"0.148wh2b",null,"0.107wh2b",null,"",null,"",{"$nulls":3},"0.1736wh2","0.3113wh2","0.4023wh2","","","0.4118wh2"]
[null,"Total de los 4 bordes",{"$nulls":6},"0.500wh2b",null,"0.500wh2b",null,"0.500wh2b",null,"0.500wh2b",null,"",null,"",{"$nulls":3},"0.1919wh2","0.3153wh2","0.3904wh2","","","0.3980wh2"]
[{"$nulls":22},"0.0000wh2b","0.0052wh2b","0.0538wh2b","0.1203wh2b","0.1435wh2b","0.1667wh2b"]
[null,"Graficamos la variación del cortante para una relación de:",{"$nulls":20},"0.0480wh2b","0.0960wh2b","0.1818wh2b","0.2715wh2b","0.3023wh2b","0.3333wh2b"]
[{"$nulls":22},"0.2260wh2b","0.1994wh2b","0.1322wh2b","0.0541wh2b","0.0271wh2b","0.2750wh2b"]
[{"$nulls":9},"b/h =",{"$f":"+P42","v":{"v":0,"d":"0.00"}},{"$nulls":11},"0.5000wh2b","0.5000wh2b","0.5000wh2b","0.5000wh2b","0.5000wh2b","0.5000wh2b"]
[]
[{"$nulls":22},0.5,1,2,3,"",""]
[{"$nulls":22},"0.141wh2","0.242wh2","0.380wh2","0.450wh2","",""]
[{"$nulls":22},"-0.258wh2","-0.440wh2","-0.583wh2","-0.590wh2","",""]
[{"$nulls":22},"0.000wh2","0.010wh2","0.100wh2","0.165wh2","",""]
[{"$nulls":22},"0.128wh2","0.258wh2","0.375wh2","0.406wh2","",""]
[{"$nulls":22},"0.174wh2","0.311wh2","0.406wh2","0.416wh2","",""]
[{"$nulls":22},"0.192wh2b","0.315wh2b","0.390wh2b","0.398wh2b","",""]
[{"$nulls":22},"0.048wh2b","0.096wh2b","0.204wh2b","0.286wh2b","",""]
[{"$nulls":22},"0.226wh2b","0.202wh2b","0.148wh2b","0.107wh2b","",""]
[{"$nulls":22},"0.500wh2b","0.500wh2b","0.500wh2b","0.500wh2b","",""]
[]
[]
[{"$nulls":22},{"$f":"+IF($AB$573=1,AnexoV!N20,AnexoVI!N20)","v":{"v":-0.258,"d":"-0.2580"}},{"$f":"+IF($AB$573=1,AnexoV!O20,AnexoVI!O20)","v":{"v":-0.44,"d":"-0.4400"}},{"$f":"+IF($AB$573=1,AnexoV!P20,AnexoVI!P20)","v":{"v":-0.583,"d":"-0.5830"}},{"$f":"+IF($AB$573=1,AnexoV!Q20,AnexoVI!Q20)","v":{"v":-0.59,"d":"-0.5900"}},{"$f":"+IF($AB$573=1,AnexoV!M20,AnexoVI!M20)","v":{"v":0,"d":"0.0000"}}]
[{"$nulls":22},{"$f":"+IF($AB$573=1,AnexoV!N21,AnexoVI!N21)","v":{"v":0.141,"d":"0.1410"}},{"$f":"+IF($AB$573=1,AnexoV!O21,AnexoVI!O21)","v":{"v":0.242,"d":"0.2420"}},{"$f":"+IF($AB$573=1,AnexoV!P21,AnexoVI!P21)","v":{"v":0.38,"d":"0.3800"}},{"$f":"+IF($AB$573=1,AnexoV!Q21,AnexoVI!Q21)","v":{"v":0.45,"d":"0.4500"}},{"$f":"+IF($AB$573=1,AnexoV!M21,AnexoVI!M21)","v":{"v":0.5,"d":"0.5000"}}]
[null,"De la tabla y del grafico anterior obtenemos un cortante maximo de:",{"$nulls":11},"wh2 *",null,"=",{"$f":"+IFERROR(L602*G21*G15*G15*O602,)","v":{"v":0,"d":"0.000"}},null,null,"kg",null,null,{"$f":"+IF($AB$573=1,AnexoV!N22,AnexoVI!N22)","v":{"v":-0.258,"d":"-0.2580"}},{"$f":"+IF($AB$573=1,AnexoV!O22,AnexoVI!O22)","v":{"v":-0.44,"d":"-0.4400"}},{"$f":"+IF($AB$573=1,AnexoV!P22,AnexoVI!P22)","v":{"v":-0.583,"d":"-0.5830"}},{"$f":"+IF($AB$573=1,AnexoV!Q22,AnexoVI!Q22)","v":{"v":-0.59,"d":"-0.5900"}},{"$f":"+IF($AB$573=1,AnexoV!M22,AnexoVI!M22)","v":{"v":1,"d":"1.0000"}}]
[]
[null,"La resistencia del concreto al cortante esta dado por la siguiente expresión:"]
[{"$nulls":22},false,false,true,true]
[{"$nulls":5},"ØVc =",null,"* 0.53 * √f'c * b * d3  =",{"$nulls":3},{"$f":"+G606*0.53*SQRT(G25)*E150*N542","v":{"v":0,"d":"0.000"}},null,null,"kg",{"$nulls":7},{"$f":"IF(W$605,W600,NA())","v":{"$error":"#N/A"}},{"$f":"IF(X$605,X600,NA())","v":{"$error":"#N/A"}},{"v":-0.583,"d":"-0.5830"},{"v":-0.59,"d":"-0.5900"},{"$f":"+AA600","v":{"v":0,"d":"0.0000"}}]
[{"$nulls":22},{"$f":"IF(W$605,W601,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"v":0.38,"d":"0.3800"},{"v":0.45,"d":"0.4500"},{"$f":"+AA601","v":{"v":0.5,"d":"0.5000"}}]
[null,"Verificamos el efecto de corte",{"$nulls":20},{"$f":"IF(W$605,W602,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"v":-0.583,"d":"-0.5830"},{"v":-0.59,"d":"-0.5900"},{"v":1,"d":"1.0000"}]
[]
[{"$nulls":3},"Vu=",{"$f":"+IFERROR(MAX(L568,Q602),)","v":{"v":0,"d":"0.000"}},null,null,"kg","<",null,"ØVc=",{"$f":"+L606","v":{"v":0,"d":"0.000"}},null,null,"kg",null,{"$f":"+IF(E610<L610,\"Cumple\",\"Cambiar seccion\")","v":"Cambiar seccion"},{"$nulls":5},"Centro del lado empotrado",null,null,"Tope inferior del lado empotrado"]
[{"$nulls":22},"Tercio inferior del lado empotrado",null,null,"Centro del lado empotrado"]
[null,"Revision de la longitud de anclaje del gancho de la losa de fondo en el muro del reservorio",{"$nulls":20},"Cuarto inferior del lado empotrado",null,null,"Tercio inferior del lado empotrado"]
[{"$nulls":22},"Total en el borde superior",null,null,"Cuarto inferior del lado empotrado"]
[null,"La longitud basica de anclaje de un gancho estandar, para acero de diametro de:",{"$nulls":11},"Ø",{"$f":"+Q560","v":0},", es:"]
[]
[{"$nulls":4},"ldh = ( 318 * db ) / √f'c",{"$nulls":8},"ldh=",{"$f":"IFERROR(318*HLOOKUP(O614,W616:AB617,2,0)/SQRT(G25),)","v":{"v":0,"d":"0.00"}},null,"cm",{"$nulls":4},"Ø","3/8\"","1/2\"","5/8\"","3/4\"","7/8\"","1\""]
[{"$nulls":21},"db",0.98,1.27,1.59,1.91,2.22,2.54]
[null,"La longitud de anclaje del gancho se reduce por los factores que cumplen las condiciones del ACI"]
[]
[null,null,"r1=",null,null,"Para ganchos de diametro menor a #11 con dobles de 90°, recubrimiento lateral mayor a 6.5 cm"]
[{"$nulls":5},"y recubrimiento detrás del acero de refuerzo de 5 cm."]
[]
[null,null,"r2=","  Asreq / Asprov =",null,null,{"$f":"IFERROR(+N550/(HLOOKUP(Q560,V558:AA560,2,FALSE)*100/(S560*100)),)","v":{"v":0,"d":"0.0000"}}]
[]
[null,"La longitud de anclaje del gancho sera finalmente:",{"$nulls":8},"Ldh=","r1*r2*ldh"]
[]
[{"$nulls":3},"Ldh=",{"$f":"+G623*D620*O616","v":{"v":0,"d":"0.00"}},null,"cm",null,"<",null,"e1=",{"$f":"+E158","v":{"v":0,"d":"0.00"}},null,"cm",null,null,{"$f":"+IF(E627<L627,\"Cumple\",\"Cambiar seccion\")","v":"Cambiar seccion"}]
[]
["05","VERIFICACION DE LA CAPACIDAD PORTANTE DEL TERRENO"]
[]
[null,"La capacidad portante neta del terreno \"qnt\" es :"]
[]
[{"$nulls":7},"qnt =","qt - Hzapata*γc - Hlosacimen*γc"]
[]
[null,"Tenemos los siguientes datos para el analisis:"]
[]
[{"$nulls":4},"Hzapata =",{"$f":"+G19","v":{"v":0,"d":"0.00"}},null,"m"]
[]
[{"$nulls":4},"Hcimen =",{"$f":"+P534/100","v":{"v":0,"d":"0.00"}},null,"m"]
[]
[{"$nulls":4},"Hlosa =",{"$f":"+P330/100","v":{"v":0,"d":"0.00"}},null,"m"]
[]
[{"$nulls":4},"Hagua =",{"$f":"+G15","v":{"v":0,"d":"0.00"}},null,"m"]
[]
[{"$nulls":4},"Hmuro =",{"$f":"+G29","v":{"v":0,"d":"0.00"}},null,"m"]
[]
[{"$nulls":4},"qnt =",{"$f":"+((G24*10000)-(F637-F639)*G22-F639*G22)/10000","v":{"v":0,"d":"0.000"}},null,"kg/cm2"]
[]
[null,"Peso total del reservorio en condiciones de servicio (lleno) :"]
[]
[{"$nulls":4},"Pt =",{"$f":"(2*G20*(F637-F639)*(G28+2*G18+2*(E158/100))*G22)+(2*G20*(F637-F639)*(2*G18+2*(E158/100)+G28-2*G20)*G22)+(F639*(2*G18+2*(E158/100)+G28-2*G20)*(2*G18+2*(E158/100)+G28-2*G20)*G22)+(4*(E158/100)*F645*G28*G22)+(F641*G28*G28*G22)+(G28*G28*F643*G21)","v":{"v":0,"d":"0.00"}},null,null,"kg"]
[]
[null,"Area necesaria de la cimentacion del reservorio :",{"$nulls":12},"Acimen = Pt / qnt =",{"$f":"IFERROR(+(F651/F647)/10000,)","v":{"v":0,"d":"0.000"}},null,"m2"]
[]
[null,"Verificacion :",{"$nulls":3},"Acimen =",{"$f":"+P653","v":{"v":0,"d":"0.000"}},null,"m2","<",null,"Areserv =",{"$f":"+(2*G18+2*(E158/100)+G28)*(2*G18+2*(E158/100)+G28)","v":{"v":0,"d":"0.000"}},null,"m2",null,{"$f":"+IF(G655<M655,\"Cumple\",\"Cambiar seccion\")","v":"Cambiar seccion"}]
[]
["06","ESQUEMA FINAL DE LA DISTRIBUCION DE ACEROS EN EL RESERVORIO"]
[]
[null,{"$f":"+CONCATENATE(G18,\" m\")","v":" m"},null,null,{"$f":"+CONCATENATE(E158/100,\" m\")","v":"0 m"},{"$nulls":4},{"$f":"+CONCATENATE(G28,\" m\")","v":"0 m"},{"$nulls":4},{"$f":"+CONCATENATE(E158/100,\" m\")","v":"0 m"},null,null,{"$f":"+CONCATENATE(G18,\" m\")","v":" m"}]
[]
[]
[{"$nulls":4},"Ø",{"$f":"+Q356","v":0},"@",{"$f":"+S356","v":{"v":0,"d":"0.000"}},null,"m"]
[{"$nulls":13},"Ø",{"$f":"+F662","v":0},"@",{"$f":"+H662","v":{"v":0,"d":"0.000"}},null,"m"]
[]
[]
[{"$f":"+CONCATENATE(P330/100,\" m\")","v":"0 m"},{"$nulls":3},"•",null,null,"•","•","•","•","•","•","•","•","•","•"]
[{"$nulls":4},"•",{"$nulls":11},"•"]
[{"$nulls":4},"•",{"$nulls":11},"•"]
[{"$nulls":4},"•",{"$nulls":11},"•"]
[{"$nulls":4},"•",{"$nulls":11},"•"]
[{"$nulls":4},"•",null,"Ø",{"$f":"+Q184","v":0},"@",{"$f":"+S184","v":{"v":0,"d":"0.000"}},null,"m",{"$nulls":4},"•"]
[{"$nulls":4},"•",{"$nulls":11},"•"]
[{"$nulls":4},"•",{"$nulls":11},"•",null,{"$f":"+CONCATENATE(G29+P330/100,\" m\")","v":"0 m"}]
[{"$f":"+CONCATENATE(G29,\" m\")","v":"0 m"},{"$nulls":3},"•",{"$nulls":4},"Ø",{"$f":"+Q210","v":0},"@",{"$f":"+S210","v":{"v":0,"d":"0.000"}},null,"m",null,"•"]
[{"$nulls":4},"•",{"$nulls":11},"•"]
[{"$nulls":4},"•",{"$nulls":11},"•"]
[{"$nulls":4},"•",{"$nulls":11},"•"]
[{"$nulls":4},"•",{"$nulls":11},"•"]
[{"$nulls":4},"•",{"$nulls":11},"•"]
[{"$nulls":4},"•",{"$nulls":11},"•"]
[{"$nulls":4},"•",{"$nulls":11},"•"]
[{"$nulls":4},"•",{"$nulls":11},"•"]
[{"$f":"+CONCATENATE(P534/100,\" m\")","v":"0 m"},null,null,"•","•","•","•","•","•","•","•","•","•","•","•","•","•","•"]
[{"$f":"+CONCATENATE(G19-P534/100,\" m\")","v":"0 m"},{"$nulls":17},{"$f":"+CONCATENATE(G19,\" m\")","v":" m"}]
[]
[]
[]
[{"$nulls":12},"Ø",{"$f":"+F689","v":0},"@",{"$f":"+H689","v":{"v":0,"d":"0.000"}},null,"m"]
[{"$nulls":4},"Ø",{"$f":"+Q560","v":0},"@",{"$f":"+S560","v":{"v":0,"d":"0.000"}},null,"m"]
[]
[]
[{"$nulls":3},{"$f":"+CONCATENATE(G20,\" m\")","v":" m"},{"$nulls":5},{"$f":"+CONCATENATE((G28+G18+G18+E158/100+E158/100)-(G20+G20),\" m\")","v":"0 m"},{"$nulls":4},{"$f":"+CONCATENATE(G20,\" m\")","v":" m"}]

{"sheet":"AnexoI","index":3,"n_rows":60,"n_cols":16,"rows_kept":60,"merged":[[0,1,0,10],[2,2,3,2],[2,9,3,9],[4,1,10,1],[8,5,8,6],[10,5,10,6],[13,1,14,1],[13,2,14,2],[13,3,14,3],[13,4,14,4],[13,5,13,6],[13,7,13,8],[13,9,13,10],[15,1,19,1],[20,1,24,1],[25,1,29,1],[30,1,34,1],[35,1,39,1],[40,1,44,1],[45,1,49,1],[50,1,54,1],[55,1,59,1]]}
[null,"TABLA N°01 DE DISEÑO PARA RESERVORIOS RECTANGULARES DE C°A° - PCA"]
[]
[null,null,"y",null,"b/2",null,null,"b/2",null,"y"]
[]
[null,null,"//","Articulado",{"$nulls":4},"Articulado","\\\\"]
[null,null,"//",{"$nulls":6},"\\\\"]
[null,null,"//",{"$nulls":6},"\\\\"]
[null,null,"//","Empotrado",{"$nulls":4},"Empotrado","\\\\","h"]
[null,null,"//",null,null,"x",{"$nulls":3},"\\\\"]
[null,null,"//",{"$nulls":6},"\\\\"]
[null,null,"//",null,null,"Articulado",{"$nulls":3},"\\\\"]
[null,"γa*h"]
[]
[null,"b/h","b/h","x/h",null,"y = 0",null,"y = b/4",null,"y = b/2"]
[{"$nulls":5},"Mx","My","Mx","My","Mx","My"]
[null,{"v":3,"d":"3.00"},{"v":3,"d":"3.00"},0,3.05,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},null,0.05,{"v":3,"d":"3.00"},null,{"$f":"+$B$16+M16","v":3.05}]
[null,null,{"v":3,"d":"3.00"},0.25,3.04,0.035,{"v":0.01,"d":"0.010"},0.026,0.011,-0.008,-0.039,null,0.04,{"v":2.5,"d":"2.50"},null,3.04]
[null,null,{"v":3,"d":"3.00"},0.5,3.03,0.057,0.016,0.044,0.017,-0.013,-0.063,null,0.03,{"v":2,"d":"2.00"},null,3.03]
[null,null,{"v":3,"d":"3.00"},0.75,3.02,0.051,0.013,0.041,0.014,-0.011,-0.055,null,0.02,1.75,null,3.02]
[null,null,{"v":3,"d":"3.00"},1,3.01,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},null,0.01,{"v":1.5,"d":"1.50"},null,{"$f":"+$B$16+M20","v":3.01}]
[null,{"v":2.5,"d":"2.50"},{"v":2.5,"d":"2.50"},0,2.55,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},null,0.05,1.25,null,{"$f":"+$B$21+M21","v":2.55}]
[null,null,{"v":2.5,"d":"2.50"},0.25,2.54,0.031,0.011,0.021,{"v":0.01,"d":"0.010"},-0.008,-0.038,null,0.04,{"v":1,"d":"1.00"},null,2.54]
[null,null,{"v":2.5,"d":"2.50"},0.5,2.53,0.052,0.017,0.036,0.017,-0.012,-0.062,null,0.03,0.75,null,2.53]
[null,null,{"v":2.5,"d":"2.50"},0.75,2.52,0.047,0.015,0.036,0.014,-0.011,-0.055,null,0.02,{"v":0.5,"d":"0.50"},null,2.52]
[null,null,{"v":2.5,"d":"2.50"},1,2.51,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},null,0.01,null,null,{"$f":"+$B$21+M25","v":2.51}]
[null,{"v":2,"d":"2.00"},{"v":2,"d":"2.00"},0,2.05,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},null,0.05,null,null,{"$f":"+$B$26+M26","v":2.05}]
[null,null,{"v":2,"d":"2.00"},0.25,2.04,0.025,0.013,0.015,0.009,-0.007,-0.037,null,0.04,null,null,2.04]
[null,null,{"v":2,"d":"2.00"},0.5,2.03,0.042,{"v":0.02,"d":"0.020"},0.028,0.015,-0.012,-0.059,null,0.03,null,null,2.03]
[null,null,{"v":2,"d":"2.00"},0.75,2.02,0.041,0.016,0.029,0.013,-0.011,-0.053,null,0.02,null,null,2.02]
[null,null,{"v":2,"d":"2.00"},1,2.01,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},null,0.01,null,null,{"$f":"+$B$26+M30","v":2.01}]
[null,1.75,1.75,0,{"v":1.8,"d":"1.80"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},null,0.05,null,null,{"$f":"+$B$31+M31","v":{"v":1.8,"d":"1.80"}}]
[null,null,1.75,0.25,1.79,{"v":0.02,"d":"0.020"},0.013,0.012,0.008,-0.007,-0.035,null,0.04,null,null,1.79]
[null,null,1.75,0.5,1.78,0.036,{"v":0.02,"d":"0.020"},0.023,0.013,-0.011,-0.057,null,0.03,null,null,1.78]
[null,null,1.75,0.75,1.77,0.036,0.017,0.025,0.012,{"v":-0.01,"d":"-0.010"},-0.051,null,0.02,null,null,1.77]
[null,null,1.75,1,1.76,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},null,0.01,null,null,{"$f":"+$B$31+M35","v":1.76}]
[null,{"v":1.5,"d":"1.50"},{"v":1.5,"d":"1.50"},0,1.55,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},null,0.05,null,null,{"$f":"+$B$36+M36","v":1.55}]
[null,null,{"v":1.5,"d":"1.50"},0.25,1.54,0.015,0.013,0.008,0.007,-0.006,-0.032,null,0.04,null,null,1.54]
[null,null,{"v":1.5,"d":"1.50"},0.5,1.53,0.028,0.021,0.016,0.011,{"v":-0.01,"d":"-0.010"},-0.052,null,0.03,null,null,1.53]
[null,null,{"v":1.5,"d":"1.50"},0.75,1.52,{"v":0.03,"d":"0.030"},0.017,{"v":0.02,"d":"0.020"},0.011,{"v":-0.01,"d":"-0.010"},-0.048,null,0.02,null,null,1.52]
[null,null,{"v":1.5,"d":"1.50"},1,1.51,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},null,0.01,null,null,{"$f":"+$B$36+M40","v":1.51}]
[null,1.25,1.25,0,{"v":1.3,"d":"1.30"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},null,0.05,null,null,{"$f":"+$B$41+M41","v":{"v":1.3,"d":"1.30"}}]
[null,null,1.25,0.25,1.29,0.009,0.012,0.005,0.005,-0.006,-0.028,null,0.04,null,null,1.29]
[null,null,1.25,0.5,1.28,0.019,0.019,0.011,0.009,-0.009,-0.045,null,0.03,null,null,1.28]
[null,null,1.25,0.75,1.27,0.023,0.017,0.014,0.009,-0.009,-0.043,null,0.02,null,null,1.27]
[null,null,1.25,1,1.26,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},null,0.01,null,null,{"$f":"+$B$41+M45","v":1.26}]
[null,{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},0,1.05,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},null,0.05,null,null,{"$f":"+$B$46+M46","v":1.05}]
[null,null,{"v":1,"d":"1.00"},0.25,1.04,0.005,0.009,{"v":2E-3,"d":"0.002"},0.003,-0.004,{"v":-0.02,"d":"-0.020"},null,0.04,null,null,1.04]
[null,null,{"v":1,"d":"1.00"},0.5,1.03,0.011,0.016,0.006,0.006,-0.007,-0.035,null,0.03,null,null,1.03]
[null,null,{"v":1,"d":"1.00"},0.75,1.02,0.016,0.014,0.009,0.007,-0.007,-0.035,null,0.02,null,null,1.02]
[null,null,{"v":1,"d":"1.00"},1,1.01,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},null,0.01,null,null,{"$f":"+$B$46+M50","v":1.01}]
[null,0.75,0.75,0,{"v":0.8,"d":"0.80"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},null,0.05,null,null,{"$f":"+$B$51+M51","v":{"v":0.8,"d":"0.80"}}]
[null,null,0.75,0.25,0.79,{"v":1E-3,"d":"0.001"},0.006,{"v":0,"d":"0.000"},{"v":2E-3,"d":"0.002"},{"v":-2E-3,"d":"-0.002"},-0.012,null,0.04,null,null,0.79]
[null,null,0.75,0.5,0.78,0.005,0.011,{"v":2E-3,"d":"0.002"},0.003,-0.004,-0.022,null,0.03,null,null,0.78]
[null,null,0.75,0.75,0.77,0.009,0.011,0.005,0.005,-0.005,-0.025,null,0.02,null,null,0.77]
[null,null,0.76,1,0.76,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},null,0.01,null,null,{"$f":"+$B$51+M55","v":0.76}]
[null,{"v":0.5,"d":"0.50"},0.55,0,0.55,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},null,0.05,null,null,{"$f":"+$B$56+M56","v":0.55}]
[null,null,0.54,0.25,0.54,{"v":0,"d":"0.000"},0.003,{"v":0,"d":"0.000"},{"v":1E-3,"d":"0.001"},{"v":-1E-3,"d":"-0.001"},-0.005,null,0.04,null,null,0.54]
[null,null,0.53,0.5,0.53,{"v":1E-3,"d":"0.001"},0.005,{"v":1E-3,"d":"0.001"},{"v":1E-3,"d":"0.001"},{"v":-2E-3,"d":"-0.002"},{"v":-0.01,"d":"-0.010"},null,0.03,null,null,0.53]
[null,null,0.52,0.75,0.52,0.004,0.007,{"v":2E-3,"d":"0.002"},{"v":2E-3,"d":"0.002"},-0.003,-0.014,null,0.02,null,null,0.52]
[null,null,0.51,1,0.51,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},null,0.01,null,null,{"$f":"+$B$56+M60","v":0.51}]

{"sheet":"AnexoII","index":4,"n_rows":60,"n_cols":16,"rows_kept":60,"merged":[[0,1,0,10],[2,2,3,2],[2,9,3,9],[4,1,10,1],[8,5,8,6],[10,5,10,6],[13,1,14,1],[13,2,14,2],[13,3,14,3],[13,4,14,4],[13,5,13,6],[13,7,13,8],[13,9,13,10],[15,1,19,1],[20,1,24,1],[25,1,29,1],[30,1,34,1],[35,1,39,1],[40,1,44,1],[45,1,49,1],[50,1,54,1],[55,1,59,1]]}
[null,"TABLA N°02 DE DISEÑO PARA RESERVORIOS RECTANGULARES DE C°A° - PCA"]
[]
[null,null,"y",null,"b/2",null,null,"b/2",null,"y"]
[]
[null,null,"//","libre",{"$nulls":4},"libre","\\\\"]
[null,null,"//",{"$nulls":6},"\\\\"]
[null,null,"//",{"$nulls":6},"\\\\"]
[null,null,"//","Empotrado",{"$nulls":4},"Empotrado","\\\\","h"]
[null,null,"//",null,null,"x",{"$nulls":3},"\\\\"]
[null,null,"//",{"$nulls":6},"\\\\"]
[null,null,"//",null,null,"Articulado",{"$nulls":3},"\\\\"]
[null,"γa*h"]
[]
[null,"b/h","b/h","x/h",null,"y = 0",null,"y = b/4",null,"y = b/2"]
[{"$nulls":5},"Mx","My","Mx","My","Mx","My"]
[null,{"v":3,"d":"3.00"},{"v":3,"d":"3.00"},0,3.05,{"v":0,"d":"0.000"},{"v":0.07,"d":"0.070"},{"v":0,"d":"0.000"},0.027,{"v":0,"d":"0.000"},-0.196,null,0.05,{"v":3,"d":"3.00"},null,{"$f":"+$B$16+M16","v":3.05}]
[null,null,{"v":3,"d":"3.00"},0.25,3.04,0.028,0.061,0.015,0.028,-0.034,{"v":-0.17,"d":"-0.170"},null,0.04,{"v":2.5,"d":"2.50"},null,3.04]
[null,null,{"v":3,"d":"3.00"},0.5,3.03,0.049,0.049,0.032,0.026,-0.027,-0.137,null,0.03,{"v":2,"d":"2.00"},null,3.03]
[null,null,{"v":3,"d":"3.00"},0.75,3.02,0.046,{"v":0.03,"d":"0.030"},0.034,0.018,-0.017,-0.087,null,0.02,1.75,null,3.02]
[null,null,{"v":3,"d":"3.00"},1,3.01,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},null,0.01,{"v":1.5,"d":"1.50"},null,{"$f":"+$B$16+M20","v":3.01}]
[null,{"v":2.5,"d":"2.50"},{"v":2.5,"d":"2.50"},0,2.55,{"v":0,"d":"0.000"},0.061,{"v":0,"d":"0.000"},0.019,{"v":0,"d":"0.000"},-0.138,null,0.05,1.25,null,{"$f":"+$B$21+M21","v":2.55}]
[null,null,{"v":2.5,"d":"2.50"},0.25,2.54,0.024,0.053,{"v":0.01,"d":"0.010"},0.022,-0.026,-0.132,null,0.04,{"v":1,"d":"1.00"},null,2.54]
[null,null,{"v":2.5,"d":"2.50"},0.5,2.53,0.042,0.044,0.025,0.022,-0.023,-0.115,null,0.03,0.75,null,2.53]
[null,null,{"v":2.5,"d":"2.50"},0.75,2.52,0.041,0.027,{"v":0.03,"d":"0.030"},0.016,-0.016,-0.078,null,0.02,{"v":0.5,"d":"0.50"},null,2.52]
[null,null,{"v":2.5,"d":"2.50"},1,2.51,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},null,0.01,null,null,{"$f":"+$B$21+M25","v":2.51}]
[null,{"v":2,"d":"2.00"},{"v":2,"d":"2.00"},0,2.05,{"v":0,"d":"0.000"},0.045,{"v":0,"d":"0.000"},0.011,{"v":0,"d":"0.000"},-0.091,null,0.05,null,null,{"$f":"+$B$26+M26","v":2.05}]
[null,null,{"v":2,"d":"2.00"},0.25,2.04,0.016,0.042,0.006,0.014,-0.019,-0.094,null,0.04,null,null,2.04]
[null,null,{"v":2,"d":"2.00"},0.5,2.03,0.033,0.036,{"v":0.02,"d":"0.020"},0.016,-0.018,-0.089,null,0.03,null,null,2.03]
[null,null,{"v":2,"d":"2.00"},0.75,2.02,0.035,0.024,0.025,0.014,-0.013,-0.065,null,0.02,null,null,2.02]
[null,null,{"v":2,"d":"2.00"},1,2.01,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},null,0.01,null,null,{"$f":"+$B$26+M30","v":2.01}]
[null,1.75,1.75,0,{"v":1.8,"d":"1.80"},{"v":0,"d":"0.000"},0.036,{"v":0,"d":"0.000"},0.008,{"v":0,"d":"0.000"},-0.071,null,0.05,null,null,{"$f":"+$B$31+M31","v":{"v":1.8,"d":"1.80"}}]
[null,null,1.75,0.25,1.79,0.013,0.035,0.005,0.011,-0.015,-0.076,null,0.04,null,null,1.79]
[null,null,1.75,0.5,1.78,0.028,0.032,0.017,0.014,-0.015,-0.076,null,0.03,null,null,1.78]
[null,null,1.75,0.75,1.77,0.031,0.022,0.021,0.012,-0.012,-0.059,null,0.02,null,null,1.77]
[null,null,1.75,1,1.76,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},null,0.01,null,null,{"$f":"+$B$31+M35","v":1.76}]
[null,{"v":1.5,"d":"1.50"},{"v":1.5,"d":"1.50"},0,1.55,{"v":0,"d":"0.000"},0.027,{"v":0,"d":"0.000"},0.005,{"v":0,"d":"0.000"},-0.052,null,0.05,null,null,{"$f":"+$B$36+M36","v":1.55}]
[null,null,{"v":1.5,"d":"1.50"},0.25,1.54,0.009,0.028,0.003,0.008,-0.012,-0.059,null,0.04,null,null,1.54]
[null,null,{"v":1.5,"d":"1.50"},0.5,1.53,0.022,0.027,0.012,0.011,-0.013,-0.063,null,0.03,null,null,1.53]
[null,null,{"v":1.5,"d":"1.50"},0.75,1.52,0.027,{"v":0.02,"d":"0.020"},0.017,0.011,{"v":-0.01,"d":"-0.010"},-0.052,null,0.02,null,null,1.52]
[null,null,{"v":1.5,"d":"1.50"},1,1.51,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},null,0.01,null,null,{"$f":"+$B$36+M40","v":1.51}]
[null,1.25,1.25,0,{"v":1.3,"d":"1.30"},{"v":0,"d":"0.000"},0.017,{"v":0,"d":"0.000"},0.003,{"v":0,"d":"0.000"},-0.034,null,0.05,null,null,{"$f":"+$B$41+M41","v":{"v":1.3,"d":"1.30"}}]
[null,null,1.25,0.25,1.29,0.005,{"v":0.02,"d":"0.020"},{"v":2E-3,"d":"0.002"},0.005,-0.008,-0.042,null,0.04,null,null,1.29]
[null,null,1.25,0.5,1.28,0.017,0.023,0.009,0.009,{"v":-0.01,"d":"-0.010"},-0.049,null,0.03,null,null,1.28]
[null,null,1.25,0.75,1.27,0.021,0.017,0.013,0.009,-0.009,-0.044,null,0.02,null,null,1.27]
[null,null,1.25,1,1.26,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},null,0.01,null,null,{"$f":"+$B$41+M45","v":1.26}]
[null,{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},0,1.05,{"v":0,"d":"0.000"},{"v":0.01,"d":"0.010"},{"v":0,"d":"0.000"},{"v":2E-3,"d":"0.002"},{"v":0,"d":"0.000"},-0.019,null,0.05,null,null,{"$f":"+$B$46+M46","v":1.05}]
[null,null,{"v":1,"d":"1.00"},0.25,1.04,{"v":2E-3,"d":"0.002"},0.013,{"v":0,"d":"0.000"},0.003,-0.005,-0.025,null,0.04,null,null,1.04]
[null,null,{"v":1,"d":"1.00"},0.5,1.03,{"v":0.01,"d":"0.010"},0.017,0.005,0.006,-0.007,-0.036,null,0.03,null,null,1.03]
[null,null,{"v":1,"d":"1.00"},0.75,1.02,0.015,0.015,0.009,0.007,-0.007,-0.036,null,0.02,null,null,1.02]
[null,null,{"v":1,"d":"1.00"},1,1.01,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},null,0.01,null,null,{"$f":"+$B$46+M50","v":1.01}]
[null,0.75,0.75,0,{"v":0.8,"d":"0.80"},{"v":0,"d":"0.000"},0.005,{"v":0,"d":"0.000"},{"v":1E-3,"d":"0.001"},{"v":0,"d":"0.000"},-0.008,null,0.05,null,null,{"$f":"+$B$51+M51","v":{"v":0.8,"d":"0.80"}}]
[null,null,0.75,0.25,0.79,{"v":1E-3,"d":"0.001"},0.008,{"v":0,"d":"0.000"},{"v":2E-3,"d":"0.002"},-0.003,-0.013,null,0.04,null,null,0.79]
[null,null,0.75,0.5,0.78,0.005,0.011,{"v":2E-3,"d":"0.002"},0.004,-0.004,-0.022,null,0.03,null,null,0.78]
[null,null,0.75,0.75,0.77,{"v":0.01,"d":"0.010"},0.012,0.006,0.004,-0.005,-0.026,null,0.02,null,null,0.77]
[null,null,0.76,1,0.76,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},null,0.01,null,null,{"$f":"+$B$51+M55","v":0.76}]
[null,{"v":0.5,"d":"0.50"},0.55,0,0.55,{"v":0,"d":"0.000"},{"v":2E-3,"d":"0.002"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},-0.003,null,0.05,null,null,{"$f":"+$B$56+M56","v":0.55}]
[null,null,0.54,0.25,0.54,{"v":0,"d":"0.000"},0.004,{"v":0,"d":"0.000"},{"v":1E-3,"d":"0.001"},{"v":-1E-3,"d":"-0.001"},-0.005,null,0.04,null,null,0.54]
[null,null,0.53,0.5,0.53,{"v":2E-3,"d":"0.002"},0.006,{"v":1E-3,"d":"0.001"},{"v":2E-3,"d":"0.002"},{"v":-2E-3,"d":"-0.002"},{"v":-0.01,"d":"-0.010"},null,0.03,null,null,0.53]
[null,null,0.52,0.75,0.52,0.007,0.008,{"v":2E-3,"d":"0.002"},{"v":2E-3,"d":"0.002"},-0.003,-0.014,null,0.02,null,null,0.52]
[null,null,0.51,1,0.51,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},null,0.01,null,null,{"$f":"+$B$56+M60","v":0.51}]

{"sheet":"AnexoIII","index":5,"n_rows":60,"n_cols":16,"rows_kept":60,"merged":[[0,1,0,10],[2,2,3,2],[2,9,3,9],[4,1,10,1],[8,5,8,6],[10,5,10,6],[13,1,14,1],[13,2,14,2],[13,3,14,3],[13,4,14,4],[13,5,13,6],[13,7,13,8],[13,9,13,10],[15,1,19,1],[20,1,24,1],[25,1,29,1],[30,1,34,1],[35,1,39,1],[40,1,44,1],[45,1,49,1],[50,1,54,1],[55,1,59,1]]}
[null,"TABLA N°03 DE DISEÑO PARA RESERVORIOS RECTANGULARES DE C°A° - PCA"]
[]
[null,null,"y",null,"b/2",null,null,"b/2",null,"y"]
[]
[null,null,"//","libre",{"$nulls":4},"libre","\\\\"]
[null,null,"//",{"$nulls":6},"\\\\"]
[null,null,"//",{"$nulls":6},"\\\\"]
[null,null,"//","Empotrado",{"$nulls":4},"Empotrado","\\\\","h"]
[null,null,"//",null,null,"x",{"$nulls":3},"\\\\"]
[null,null,"//",{"$nulls":6},"\\\\"]
[null,null,"//",null,null,"Empotrado",{"$nulls":3},"\\\\"]
[null,"γa*h","//","/////////////////","/////////////////","/////////////////","/////////////////","/////////////////","/////////////////","\\\\"]
[]
[null,"b/h","b/h","x/h",null,"y = 0",null,"y = b/4",null,"y = b/2"]
[{"$nulls":5},"Mx","My","Mx","My","Mx","My"]
[null,{"v":3,"d":"3.00"},{"v":3,"d":"3.00"},0,3.05,{"v":0,"d":"0.000"},0.025,{"v":0,"d":"0.000"},0.014,{"v":0,"d":"0.000"},-0.082,null,0.05,{"v":3,"d":"3.00"},null,{"$f":"+$B$16+M16","v":3.05}]
[null,null,{"v":3,"d":"3.00"},0.25,3.04,{"v":0.01,"d":"0.010"},0.019,0.007,0.013,-0.014,-0.071,null,0.04,{"v":2.5,"d":"2.50"},null,3.04]
[null,null,{"v":3,"d":"3.00"},0.5,3.03,0.005,{"v":0.01,"d":"0.010"},0.008,{"v":0.01,"d":"0.010"},-0.011,-0.055,null,0.03,{"v":2,"d":"2.00"},null,3.03]
[null,null,{"v":3,"d":"3.00"},0.75,3.02,-0.033,-0.004,-0.018,{"v":0,"d":"0.000"},-0.006,-0.028,null,0.02,1.75,null,3.02]
[null,null,{"v":3,"d":"3.00"},1,3.01,-0.126,-0.025,-0.092,-0.018,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},null,0.01,{"v":1.5,"d":"1.50"},null,{"$f":"+$B$16+M20","v":3.01}]
[null,{"v":2.5,"d":"2.50"},{"v":2.5,"d":"2.50"},0,2.55,{"v":0,"d":"0.000"},0.027,{"v":0,"d":"0.000"},0.013,{"v":0,"d":"0.000"},-0.074,null,0.05,1.25,null,{"$f":"+$B$21+M21","v":2.55}]
[null,null,{"v":2.5,"d":"2.50"},0.25,2.54,0.012,0.022,0.007,0.013,-0.013,-0.066,null,0.04,{"v":1,"d":"1.00"},null,2.54]
[null,null,{"v":2.5,"d":"2.50"},0.5,2.53,0.011,0.014,0.008,{"v":0.01,"d":"0.010"},-0.011,-0.053,null,0.03,0.75,null,2.53]
[null,null,{"v":2.5,"d":"2.50"},0.75,2.52,-0.021,{"v":-1E-3,"d":"-0.001"},{"v":-0.01,"d":"-0.010"},{"v":1E-3,"d":"0.001"},-0.005,-0.027,null,0.02,{"v":0.5,"d":"0.50"},null,2.52]
[null,null,{"v":2.5,"d":"2.50"},1,2.51,-0.108,-0.022,-0.077,-0.015,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},null,0.01,null,null,{"$f":"+$B$21+M25","v":2.51}]
[null,{"v":2,"d":"2.00"},{"v":2,"d":"2.00"},0,2.05,{"v":0,"d":"0.000"},0.027,{"v":0,"d":"0.000"},0.009,{"v":0,"d":"0.000"},{"v":-0.06,"d":"-0.060"},null,0.05,null,null,{"$f":"+$B$26+M26","v":2.05}]
[null,null,{"v":2,"d":"2.00"},0.25,2.04,0.013,0.023,0.006,{"v":0.01,"d":"0.010"},-0.012,-0.059,null,0.04,null,null,2.04]
[null,null,{"v":2,"d":"2.00"},0.5,2.03,0.015,0.016,{"v":0.01,"d":"0.010"},{"v":0.01,"d":"0.010"},{"v":-0.01,"d":"-0.010"},-0.049,null,0.03,null,null,2.03]
[null,null,{"v":2,"d":"2.00"},0.75,2.02,-0.008,0.003,{"v":-2E-3,"d":"-0.002"},0.003,-0.005,-0.027,null,0.02,null,null,2.02]
[null,null,{"v":2,"d":"2.00"},1,2.01,-0.086,-0.017,-0.059,-0.012,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},null,0.01,null,null,{"$f":"+$B$26+M30","v":2.01}]
[null,1.75,1.75,0,{"v":1.8,"d":"1.80"},{"v":0,"d":"0.000"},0.025,{"v":0,"d":"0.000"},0.007,{"v":0,"d":"0.000"},{"v":-0.05,"d":"-0.050"},null,0.05,null,null,{"$f":"+$B$31+M31","v":{"v":1.8,"d":"1.80"}}]
[null,null,1.75,0.25,1.79,0.012,0.022,0.005,0.008,{"v":-0.01,"d":"-0.010"},-0.052,null,0.04,null,null,1.79]
[null,null,1.75,0.5,1.78,0.016,0.016,{"v":0.01,"d":"0.010"},0.009,-0.009,-0.046,null,0.03,null,null,1.78]
[null,null,1.75,0.75,1.77,{"v":-2E-3,"d":"-0.002"},0.005,{"v":1E-3,"d":"0.001"},0.004,-0.005,-0.027,null,0.02,null,null,1.77]
[null,null,1.75,1,1.76,-0.074,-0.015,{"v":-0.05,"d":"-0.050"},{"v":-0.01,"d":"-0.010"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},null,0.01,null,null,{"$f":"+$B$31+M35","v":1.76}]
[null,{"v":1.5,"d":"1.50"},{"v":1.5,"d":"1.50"},0,1.55,{"v":0,"d":"0.000"},0.021,{"v":0,"d":"0.000"},0.005,{"v":0,"d":"0.000"},{"v":-0.04,"d":"-0.040"},null,0.05,null,null,{"$f":"+$B$36+M36","v":1.55}]
[null,null,{"v":1.5,"d":"1.50"},0.25,1.54,0.008,{"v":0.02,"d":"0.020"},0.004,0.007,-0.009,-0.044,null,0.04,null,null,1.54]
[null,null,{"v":1.5,"d":"1.50"},0.5,1.53,0.016,0.016,{"v":0.01,"d":"0.010"},0.008,-0.008,-0.042,null,0.03,null,null,1.53]
[null,null,{"v":1.5,"d":"1.50"},0.75,1.52,0.003,0.006,0.003,0.004,-0.005,-0.026,null,0.02,null,null,1.52]
[null,null,{"v":1.5,"d":"1.50"},1,1.51,{"v":-0.06,"d":"-0.060"},-0.012,-0.041,-0.008,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},null,0.01,null,null,{"$f":"+$B$36+M40","v":1.51}]
[null,1.25,1.25,0,{"v":1.3,"d":"1.30"},{"v":0,"d":"0.000"},0.015,{"v":0,"d":"0.000"},0.003,{"v":0,"d":"0.000"},-0.029,null,0.05,null,null,{"$f":"+$B$41+M41","v":{"v":1.3,"d":"1.30"}}]
[null,null,1.25,0.25,1.29,0.005,0.015,{"v":2E-3,"d":"0.002"},0.005,-0.007,-0.034,null,0.04,null,null,1.29]
[null,null,1.25,0.5,1.28,0.014,0.015,0.008,0.007,-0.007,-0.037,null,0.03,null,null,1.28]
[null,null,1.25,0.75,1.27,0.006,0.007,0.005,0.005,-0.005,-0.024,null,0.02,null,null,1.27]
[null,null,1.25,1,1.26,{"v":-0.47,"d":"-0.470"},-0.009,-0.031,-0.006,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},null,0.01,null,null,{"$f":"+$B$41+M45","v":1.26}]
[null,{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},0,1.05,{"v":0,"d":"0.000"},0.009,{"v":0,"d":"0.000"},{"v":2E-3,"d":"0.002"},{"v":0,"d":"0.000"},-0.018,null,0.05,null,null,{"$f":"+$B$46+M46","v":1.05}]
[null,null,{"v":1,"d":"1.00"},0.25,1.04,{"v":2E-3,"d":"0.002"},0.011,{"v":0,"d":"0.000"},0.003,-0.005,-0.023,null,0.04,null,null,1.04]
[null,null,{"v":1,"d":"1.00"},0.5,1.03,0.009,0.013,0.005,0.005,-0.006,-0.029,null,0.03,null,null,1.03]
[null,null,{"v":1,"d":"1.00"},0.75,1.02,0.008,0.008,0.005,0.004,-0.004,{"v":-0.02,"d":"-0.020"},null,0.02,null,null,1.02]
[null,null,{"v":1,"d":"1.00"},1,1.01,-0.035,-0.007,-0.022,-0.005,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},null,0.01,null,null,{"$f":"+$B$46+M50","v":1.01}]
[null,0.75,0.75,0,{"v":0.8,"d":"0.80"},{"v":0,"d":"0.000"},0.004,{"v":0,"d":"0.000"},{"v":1E-3,"d":"0.001"},{"v":0,"d":"0.000"},-0.007,null,0.05,null,null,{"$f":"+$B$51+M51","v":{"v":0.8,"d":"0.80"}}]
[null,null,0.75,0.25,0.79,{"v":1E-3,"d":"0.001"},0.008,{"v":0,"d":"0.000"},{"v":2E-3,"d":"0.002"},{"v":-2E-3,"d":"-0.002"},-0.011,null,0.04,null,null,0.79]
[null,null,0.75,0.5,0.78,0.005,{"v":0.01,"d":"0.010"},{"v":2E-3,"d":"0.002"},0.003,-0.003,-0.017,null,0.03,null,null,0.78]
[null,null,0.75,0.75,0.77,0.007,0.007,0.003,0.003,-0.003,-0.013,null,0.02,null,null,0.77]
[null,null,0.76,1,0.76,-0.024,-0.005,-0.015,-0.003,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},null,0.01,null,null,{"$f":"+$B$51+M55","v":0.76}]
[null,{"v":0.5,"d":"0.50"},0.55,0,0.55,{"v":0,"d":"0.000"},{"v":1E-3,"d":"0.001"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":-2E-3,"d":"-0.002"},null,0.05,null,null,{"$f":"+$B$56+M56","v":0.55}]
[null,null,0.54,0.25,0.54,{"v":0,"d":"0.000"},0.005,{"v":0,"d":"0.000"},{"v":1E-3,"d":"0.001"},{"v":-1E-3,"d":"-0.001"},-0.004,null,0.04,null,null,0.54]
[null,null,0.53,0.5,0.53,{"v":2E-3,"d":"0.002"},0.006,{"v":1E-3,"d":"0.001"},{"v":1E-3,"d":"0.001"},{"v":-2E-3,"d":"-0.002"},-0.009,null,0.03,null,null,0.53]
[null,null,0.52,0.75,0.52,0.004,0.006,{"v":1E-3,"d":"0.001"},{"v":1E-3,"d":"0.001"},{"v":-1E-3,"d":"-0.001"},-0.007,null,0.02,null,null,0.52]
[null,null,0.51,1,0.51,-0.015,-0.003,-0.008,{"v":-2E-3,"d":"-0.002"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},null,0.01,null,null,{"$f":"+$B$56+M60","v":0.51}]

{"sheet":"AnexoIV","index":6,"n_rows":60,"n_cols":16,"rows_kept":60,"merged":[[0,1,0,10],[2,2,3,2],[2,9,3,9],[4,1,10,1],[8,5,8,6],[10,5,10,6],[13,1,14,1],[13,2,14,2],[13,3,14,3],[13,4,14,4],[13,5,13,6],[13,7,13,8],[13,9,13,10],[15,1,19,1],[20,1,24,1],[25,1,29,1],[30,1,34,1],[35,1,39,1],[40,1,44,1],[45,1,49,1],[50,1,54,1],[55,1,59,1]]}
[null,"TABLA N°04 DE DISEÑO PARA RESERVORIOS RECTANGULARES DE C°A° - PCA"]
[]
[null,null,"y",null,"b/2",null,null,"b/2",null,"y"]
[]
[{"$nulls":3},"Articulado",{"$nulls":4},"Articulado"]
[]
[]
[{"$nulls":3},"Articulado",{"$nulls":4},"Articulado",null,"h"]
[{"$nulls":5},"x"]
[]
[{"$nulls":5},"Articulado"]
[null,"γa*h"]
[]
[null,"b/h","b/h","x/h",null,"y = 0",null,"y = b/4",null,"y = b/2"]
[{"$nulls":5},"Mx","My","Mx","My","Mx","My"]
[null,{"v":3,"d":"3.00"},{"v":3,"d":"3.00"},0,3.05,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},null,0.05,{"v":3,"d":"3.00"},null,{"$f":"+$B$16+M16","v":3.05}]
[null,null,{"v":3,"d":"3.00"},0.25,3.04,0.089,0.022,0.077,0.025,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},null,0.04,{"v":2.5,"d":"2.50"},null,3.04]
[null,null,{"v":3,"d":"3.00"},0.5,3.03,0.118,0.029,0.101,0.034,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},null,0.03,{"v":2,"d":"2.00"},null,3.03]
[null,null,{"v":3,"d":"3.00"},0.75,3.02,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},null,0.02,1.75,null,3.02]
[null,null,{"v":3,"d":"3.00"},1,3.01,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},null,0.01,{"v":1.5,"d":"1.50"},null,{"$f":"+$B$16+M20","v":3.01}]
[null,{"v":2.5,"d":"2.50"},{"v":2.5,"d":"2.50"},0,2.55,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},null,0.05,1.25,null,{"$f":"+$B$21+M21","v":2.55}]
[null,null,{"v":2.5,"d":"2.50"},0.25,2.54,0.085,0.024,{"v":0.07,"d":"0.070"},0.027,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},null,0.04,{"v":1,"d":"1.00"},null,2.54]
[null,null,{"v":2.5,"d":"2.50"},0.5,2.53,0.112,0.032,0.092,0.037,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},null,0.03,0.75,null,2.53]
[null,null,{"v":2.5,"d":"2.50"},0.75,2.52,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},null,0.02,{"v":0.5,"d":"0.50"},null,2.52]
[null,null,{"v":2.5,"d":"2.50"},1,2.51,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},null,0.01,null,null,{"$f":"+$B$21+M25","v":2.51}]
[null,{"v":2,"d":"2.00"},{"v":2,"d":"2.00"},0,2.05,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},null,0.05,null,null,{"$f":"+$B$26+M26","v":2.05}]
[null,null,{"v":2,"d":"2.00"},0.25,2.04,0.076,0.027,0.061,0.028,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},null,0.04,null,null,2.04]
[null,null,{"v":2,"d":"2.00"},0.5,2.03,{"v":0.1,"d":"0.100"},0.037,0.078,0.038,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},null,0.03,null,null,2.03]
[null,null,{"v":2,"d":"2.00"},0.75,2.02,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},null,0.02,null,null,2.02]
[null,null,{"v":2,"d":"2.00"},1,2.01,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},null,0.01,null,null,{"$f":"+$B$26+M30","v":2.01}]
[null,1.75,1.75,0,{"v":1.8,"d":"1.80"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},null,0.05,null,null,{"$f":"+$B$31+M31","v":{"v":1.8,"d":"1.80"}}]
[null,null,1.75,0.25,1.79,{"v":0.07,"d":"0.070"},0.029,0.054,0.029,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},null,0.04,null,null,1.79]
[null,null,1.75,0.5,1.78,0.091,{"v":0.04,"d":"0.040"},{"v":0.07,"d":"0.070"},0.039,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},null,0.03,null,null,1.78]
[null,null,1.75,0.75,1.77,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},null,0.02,null,null,1.77]
[null,null,1.75,1,1.76,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},null,0.01,null,null,{"$f":"+$B$31+M35","v":1.76}]
[null,{"v":1.5,"d":"1.50"},{"v":1.5,"d":"1.50"},0,1.55,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},null,0.05,null,null,{"$f":"+$B$36+M36","v":1.55}]
[null,null,{"v":1.5,"d":"1.50"},0.25,1.54,0.061,0.031,0.047,0.029,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},null,0.04,null,null,1.54]
[null,null,{"v":1.5,"d":"1.50"},0.5,1.53,0.078,0.043,0.059,{"v":0.04,"d":"0.040"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},null,0.03,null,null,1.53]
[null,null,{"v":1.5,"d":"1.50"},0.75,1.52,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},null,0.02,null,null,1.52]
[null,null,{"v":1.5,"d":"1.50"},1,1.51,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},null,0.01,null,null,{"$f":"+$B$36+M40","v":1.51}]
[null,1.25,1.25,0,{"v":1.3,"d":"1.30"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},null,0.05,null,null,{"$f":"+$B$41+M41","v":{"v":1.3,"d":"1.30"}}]
[null,null,1.25,0.25,1.29,0.049,0.033,0.038,0.029,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},null,0.04,null,null,1.29]
[null,null,1.25,0.5,1.28,0.063,0.044,0.047,0.039,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},null,0.03,null,null,1.28]
[null,null,1.25,0.75,1.27,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},null,0.02,null,null,1.27]
[null,null,1.25,1,1.26,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},null,0.01,null,null,{"$f":"+$B$41+M45","v":1.26}]
[null,{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},0,1.05,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},null,0.05,null,null,{"$f":"+$B$46+M46","v":1.05}]
[null,null,{"v":1,"d":"1.00"},0.25,1.04,0.036,0.033,0.027,0.027,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},null,0.04,null,null,1.04]
[null,null,{"v":1,"d":"1.00"},0.5,1.03,0.044,0.044,0.033,0.036,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},null,0.03,null,null,1.03]
[null,null,{"v":1,"d":"1.00"},0.75,1.02,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},null,0.02,null,null,1.02]
[null,null,{"v":1,"d":"1.00"},1,1.01,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},null,0.01,null,null,{"$f":"+$B$46+M50","v":1.01}]
[null,0.75,0.75,0,{"v":0.8,"d":"0.80"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},null,0.05,null,null,{"$f":"+$B$51+M51","v":{"v":0.8,"d":"0.80"}}]
[null,null,0.75,0.25,0.79,0.022,0.029,0.016,0.023,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},null,0.04,null,null,0.79]
[null,null,0.75,0.5,0.78,0.025,0.038,0.018,{"v":0.03,"d":"0.030"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},null,0.03,null,null,0.78]
[null,null,0.75,0.75,0.77,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},null,0.02,null,null,0.77]
[null,null,0.76,1,0.76,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},null,0.01,null,null,{"$f":"+$B$51+M55","v":0.76}]
[null,{"v":0.5,"d":"0.50"},0.55,0,0.55,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},null,0.05,null,null,{"$f":"+$B$56+M56","v":0.55}]
[null,null,0.54,0.25,0.54,{"v":0.01,"d":"0.010"},{"v":0.02,"d":"0.020"},0.007,0.015,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},null,0.04,null,null,0.54]
[null,null,0.53,0.5,0.53,0.009,0.025,0.007,0.019,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},null,0.03,null,null,0.53]
[null,null,0.52,0.75,0.52,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},null,0.02,null,null,0.52]
[null,null,0.51,1,0.51,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},null,0.01,null,null,{"$f":"+$B$56+M60","v":0.51}]

{"sheet":"AnexoV","index":7,"n_rows":28,"n_cols":17,"rows_kept":28,"merged":[[0,2,0,8],[2,2,3,2],[2,9,3,9],[4,1,10,1],[8,5,8,6],[8,16,9,16],[10,5,10,6],[13,1,13,3],[23,12,24,12]]}
[null,null,"TABLA N°05 DE DISEÑO PARA RESERVORIOS RECTANGULARES DE C°A° - PCA"]
[{"$nulls":12},"b/h = 1/2","b/h = 1","b/h = 2","b/h = inf","h"]
[null,null,"y",null,"b/2",null,null,"b/2",null,"y",null,null,{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.00"}]
[{"$nulls":12},{"v":0.128,"d":"0.1280"},0.2582,0.3604,0.3912,{"v":0.5,"d":"0.50"}]
[null,null,"//","Articulado",{"$nulls":4},"Articulado","\\\\",null,null,0.1736,0.3113,0.4023,0.4118,{"$f":"1-1/3","v":{"v":0.6666666666666667,"d":"0.67"}}]
[null,null,"//",{"$nulls":6},"\\\\",null,null,0.1919,0.3153,0.3904,{"v":0.398,"d":"0.3980"},{"$f":"1-1/4","v":0.75}]
[null,null,"//",{"$nulls":6},"\\\\",null,null,{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":1,"d":"1.00"}]
[null,null,"//","Empotrado",{"$nulls":4},"Empotrado","\\\\              h"]
[null,null,"//",null,null,"x",{"$nulls":3},"\\\\",null,null,"b/h = 1/2","b/h = 1","b/h = 2","b/h = inf","h"]
[null,null,"//",{"$nulls":6},"\\\\",null,null,true,true,true,true]
[null,null,"//",null,null,"Articulado",{"$nulls":3},"\\\\",null,null,{"$f":"IF(M$10,M3,NA())","v":{"v":0,"d":"0.0000"}},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.00"}]
[null,"γa*h",{"$nulls":10},{"v":0.128,"d":"0.1280"},0.2582,0.3604,0.3912,{"v":0.5,"d":"0.50"}]
[{"$nulls":12},0.1736,0.3113,0.4023,0.4118,{"$f":"1-1/3","v":{"v":0.6666666666666667,"d":"0.67"}}]
[null,"b/h",null,null,0.5,1,2,5,10,"Infinito",null,null,0.1919,0.3153,0.3904,{"v":0.398,"d":"0.3980"},{"$f":"1-1/4","v":0.75}]
[null,"Centro de la base",null,null,"0.1407wh2","0.2419wh2","0.3290wh2",null,null,"0.3333wh2",null,null,{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":1,"d":"1.00"}]
[null,"Vértice de la base",null,null,"-0.2575wh2","-0.4397wh2","-0.5833wh2",null,null,"-0.6000wh2"]
[null,"Centro del lado empotrado",null,null,"0.1280wh2","0.2582wh2","0.3604wh2",null,null,"0.3912wh2"]
[null,"Tercio inferior del lado empotrado",null,null,"0.1736wh2","0.3113wh2","0.4023wh2",null,null,"0.4118wh2"]
[null,"Cuarto inferior del lado empotrado",null,null,"0.1919wh2","0.3153wh2","0.3904wh2",null,null,"0.3980wh2",null,null,"b","b/h = 1/2","b/h = 1","b/h = 2","b/h = inf"]
[null,"Total en el borde superior",null,null,"0.0000wh2b","0.0052wh2b","0.0538wh2b","0.1203wh2b","0.1435wh2b","0.1667wh2b",null,null,{"v":0,"d":"0.00"},-0.2575,-0.4397,-0.5833,{"v":-0.6,"d":"-0.6000"}]
[null,"Total en el borde inferior",null,null,"0.0480wh2b","0.0960wh2b","0.1818wh2b","0.2715wh2b","0.3023wh2b","0.3333wh2b",null,null,{"v":0.5,"d":"0.50"},0.1407,0.2419,{"v":0.329,"d":"0.3290"},0.3333]
[null,"Total de un lado empotrado",null,null,"0.2260wh2b","0.1994wh2b","0.1322wh2b","0.0541wh2b","0.0271wh2b","0.2750wh2b",null,null,{"v":1,"d":"1.00"},-0.2575,-0.4397,-0.5833,{"v":-0.6,"d":"-0.6000"}]
[null,"Total de los 4 bordes",null,null,"0.5000wh2b","0.5000wh2b","0.5000wh2b","0.5000wh2b","0.5000wh2b","0.5000wh2b"]
[{"$nulls":12},"b","b/h = 1/2","b/h = 1","b/h = 2","b/h = inf"]
[{"$nulls":13},true,true,true,true]
[{"$nulls":12},{"v":0,"d":"0.00"},{"$f":"IF(N$25,N20,NA())","v":-0.2575},-0.4397,-0.5833,{"v":-0.6,"d":"-0.6000"}]
[{"$nulls":12},{"v":0.5,"d":"0.50"},0.1407,0.2419,{"v":0.329,"d":"0.3290"},0.3333]
[{"$nulls":12},{"v":1,"d":"1.00"},-0.2575,-0.4397,-0.5833,{"v":-0.6,"d":"-0.6000"}]

{"sheet":"AnexoVI","index":8,"n_rows":28,"n_cols":17,"rows_kept":28,"merged":[[0,2,0,8],[2,2,3,2],[2,9,3,9],[4,1,10,1],[8,5,8,6],[8,16,9,16],[10,5,10,6],[13,2,13,4],[23,12,24,12]]}
[null,null,"TABLA N°06 DE DISEÑO PARA RESERVORIOS RECTANGULARES DE C°A° - PCA"]
[{"$nulls":12},"b/h = 1/2","b/h = 1","b/h = 2","b/h = 3","h"]
[null,null,"y",null,"b/2",null,null,"b/2",null,"y",null,null,{"v":0,"d":"0.0000"},{"v":0.01,"d":"0.0100"},{"v":0.1,"d":"0.1000"},{"v":0.165,"d":"0.1650"},{"v":0,"d":"0.00"}]
[{"$nulls":12},{"v":0.128,"d":"0.1280"},{"v":0.258,"d":"0.2580"},{"v":0.375,"d":"0.3750"},{"v":0.406,"d":"0.4060"},{"v":0.5,"d":"0.50"}]
[null,null,"//","Libre",{"$nulls":4},"Libre","\\\\",null,null,{"v":0.174,"d":"0.1740"},{"v":0.311,"d":"0.3110"},{"v":0.406,"d":"0.4060"},{"v":0.416,"d":"0.4160"},{"$f":"1-1/3","v":{"v":0.6666666666666667,"d":"0.67"}}]
[null,null,"//",{"$nulls":6},"\\\\",null,null,{"v":0.192,"d":"0.1920"},{"v":0.315,"d":"0.3150"},{"v":0.39,"d":"0.3900"},{"v":0.398,"d":"0.3980"},{"$f":"1-1/4","v":0.75}]
[null,null,"//",{"$nulls":6},"\\\\",null,null,{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":1,"d":"1.00"}]
[null,null,"//","Empotrado",{"$nulls":4},"Empotrado","\\\\              h"]
[null,null,"//",null,null,"x",{"$nulls":3},"\\\\",null,null,"b/h = 1/2","b/h = 1","b/h = 2","b/h = 3","h"]
[null,null,"//",{"$nulls":6},"\\\\",null,null,false,true,true,true]
[null,null,"//",null,null,"Articulado",{"$nulls":3},"\\\\",null,null,{"$f":"IF(M$10,M3,NA())","v":{"$error":"#N/A"}},{"v":0.01,"d":"0.0100"},{"v":0.1,"d":"0.1000"},{"v":0.165,"d":"0.1650"},{"v":0,"d":"0.00"}]
[null,"γa*h",{"$nulls":10},{"$error":"#N/A"},{"v":0.258,"d":"0.2580"},{"v":0.375,"d":"0.3750"},{"v":0.406,"d":"0.4060"},{"v":0.5,"d":"0.50"}]
[{"$nulls":12},{"$error":"#N/A"},{"v":0.311,"d":"0.3110"},{"v":0.406,"d":"0.4060"},{"v":0.416,"d":"0.4160"},{"$f":"1-1/3","v":{"v":0.6666666666666667,"d":"0.67"}}]
[null,null,"b/h",null,null,0.5,1,2,3,{"$nulls":3},{"$error":"#N/A"},{"v":0.315,"d":"0.3150"},{"v":0.39,"d":"0.3900"},{"v":0.398,"d":"0.3980"},{"$f":"1-1/4","v":0.75}]
[null,null,"Centro de la base",null,null,"0.141wh2","0.242wh2","0.380wh2","0.450wh2",{"$nulls":3},{"$error":"#N/A"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":1,"d":"1.00"}]
[null,null,"Vértice de la base",null,null,"-0.258wh2","-0.440wh2","-0.583wh2","-0.590wh2"]
[null,null,"Tope inferior del lado empotrado",null,null,"0.000wh2","0.010wh2","0.100wh2","0.165wh2"]
[null,null,"Centro del lado empotrado",null,null,"0.128wh2","0.258wh2","0.375wh2","0.406wh2"]
[null,null,"Tercio inferior del lado empotrado",null,null,"0.174wh2","0.311wh2","0.406wh2","0.416wh2",{"$nulls":3},"b","b/h = 1/2","b/h = 1","b/h = 2","b/h = 3"]
[null,null,"Cuarto inferior del lado empotrado",null,null,"0.192wh2b","0.315wh2b","0.390wh2b","0.398wh2b",{"$nulls":3},{"v":0,"d":"0.00"},{"v":-0.258,"d":"-0.2580"},{"v":-0.44,"d":"-0.4400"},{"v":-0.583,"d":"-0.5830"},{"v":-0.59,"d":"-0.5900"}]
[null,null,"Total en el lado inferior",null,null,"0.048wh2b","0.096wh2b","0.204wh2b","0.286wh2b",{"$nulls":3},{"v":0.5,"d":"0.50"},{"v":0.141,"d":"0.1410"},{"v":0.242,"d":"0.2420"},{"v":0.38,"d":"0.3800"},{"v":0.45,"d":"0.4500"}]
[null,null,"Total de un lado empotrado",null,null,"0.226wh2b","0.202wh2b","0.148wh2b","0.107wh2b",{"$nulls":3},{"v":1,"d":"1.00"},{"v":-0.258,"d":"-0.2580"},{"v":-0.44,"d":"-0.4400"},{"v":-0.583,"d":"-0.5830"},{"v":-0.59,"d":"-0.5900"}]
[null,null,"Total de los 4 bordes",null,null,"0.500wh2b","0.500wh2b","0.500wh2b","0.500wh2b"]
[{"$nulls":12},"b","b/h = 1/2","b/h = 1","b/h = 2","b/h = 3"]
[{"$nulls":13},true,true,true,true]
[{"$nulls":12},{"v":0,"d":"0.00"},{"$f":"IF(N$25,N20,NA())","v":{"v":-0.258,"d":"-0.2580"}},{"v":-0.44,"d":"-0.4400"},{"v":-0.583,"d":"-0.5830"},{"v":-0.59,"d":"-0.5900"}]
[{"$nulls":12},{"v":0.5,"d":"0.50"},{"v":0.141,"d":"0.1410"},{"v":0.242,"d":"0.2420"},{"v":0.38,"d":"0.3800"},{"v":0.45,"d":"0.4500"}]
[{"$nulls":12},{"v":1,"d":"1.00"},{"v":-0.258,"d":"-0.2580"},{"v":-0.44,"d":"-0.4400"},{"v":-0.583,"d":"-0.5830"},{"v":-0.59,"d":"-0.5900"}]