{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["DATOS","PROJECT ID","Diseño","Confiabilidad","Desviacion Estandar","Indice de Serviciabilidad","So","Coef (a)","m","REPORTE","F´c (Mpa)"],"not_rendered":{"charts":1,"images":3,"macros":1,"external_links":22,"defined_names":979,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"DATOS","index":0,"n_rows":31,"n_cols":2,"rows_kept":31,"cut":false,"hidden":false,"merged":[[24,1,25,8],[27,1,27,9]]}
[]
[]
[null,"Hoja de excel para el calculo de espesores de pavimento flexible, mediante una macro."]
[]
[null,"Elaborada por:"]
[null,"Ing. Ricardo Vladimir Estrada"]
[null,"Managua, Nicaragua"]
[]
[null,"Procedimiento:"]
[null,"En la pestaña \"Diseño\", ingrese los datos correspondientes, como son:"]
[null,"Esal de diseño(Ejes equivalentes)"]
[null,"Serviciabilidad"]
[null,"Datos de suelo (CBR)"]
[null,"Esabilidad Marshal de la Mezcla asfaltica"]
[null,"etc."]
[]
[null,"Luego de ingresar todos los datos, se procede al calculodel SN (Numero Estructural)"]
[null,"Hacer Click en el cuadro de: Numero estructural Iterar (Para ejecutar Macro)"]
[null,"ingresar el dato de "]
[null,"Luego Aceptar"]
[]
[null,"Si no se ejecutara la macro, se puede hacer iterando, hasta lograr la igualdad en "]
[null,"Una vez calculado el SN, se procede a proponer espesores, hasta que el SN (Calculado) sea mayor que el requerido"]
[]
[null,"Activar la pestaña DESARROLLADOR, en excel para ejecutar macros"]
[]
[]
[null,"Se tiene que tener cierto conociminto previo, de el diseño de espesores por el metodo de la ASSHTO"]
[]
[null,"Dudas: Contactar a "]
[null,"stradaric@hotmail.com"]

{"sheet":"PROJECT ID","index":1,"n_rows":16,"n_cols":12,"rows_kept":16,"cut":false,"hidden":false,"merged":[[15,6,15,10],[1,11,1,13],[5,6,5,10],[7,6,7,10],[9,6,10,10],[12,6,13,10]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,"Excel Diseño de Pavimento Flexible"]
[]
[]
[]
[null,null,null,null,"Empresa:",null,"GOBIERNO REGIONAL TUMBES"]
[]
[null,null,null,null,"Cliente:",null,"GOBIERNO REGIONAL TUMBES"]
[]
[null,null,null,null,"Descripcion del Proyecto:",null,"CARPETA AFIRMADA"]
[]
[]
[null,null,null,null,"Ubicacion:",null,"HUASIMO - CABO INGA"]
[]
[]
[null,null,null,null,"Ingeniero:"]

{"sheet":"Diseño","index":2,"n_rows":55,"n_cols":25,"rows_kept":55,"cut":false,"hidden":false,"merged":[[3,2,3,12],[4,3,4,11],[5,3,6,11]]}
[]
[]
[]
[null,null,"DISEÑO DE PAVIMENTO FLEXIBLE"]
[null,null,null," Diseño de espesores de Pavimento de acuerdo a:"]
[null,null,null,"1993 AASHTO Guide for Design of Pavements Structures"]
[]
[]
[]
[]
[]
[null,null,null,null,"DATOS:"]
[null,null,null,null,"ESAL DE DISEÑO",7801.3558034805701]
[null,null,null,null,"CONFIABILIDAD",{"$f":"Confiabilidad!C11","v":0.75}]
[null,null,null,null,"DESVIACION",{"$f":"ROUND(+IF(F14=\"\",\"\",-NORMSINV(F14)),3)","v":-0.67400000000000004}]
[null,null,null,null,"SERV INICIAL (Po)",{"$f":"'Indice de Serviciabilidad'!G10","v":4.2}]
[null,null,null,null,"SERV FINAL (Pt)",{"$f":"'Indice de Serviciabilidad'!G13","v":2}]
[null,null,null,null,"DELTA PSI",{"$f":"F16-F17","v":2.2000000000000002}]
[null,null,null,null,"So",{"$f":"So!F9","v":0.45}]
[]
[null,null,null,null,"DATOS DE SUELO"]
[null,null,null,null,"CBR BASE (%)",80]
[null,null,null,null,"CBR SUBBASE (%)",30,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Adoquin"]
[null,null,null,null,"CBR SUBRASANTE (%)",5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Asfalto"]
[null,null,null,null,"ESTABILIO MARSHALL (N)",9000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Base Granular"]
[null,null,null,null,"F´c (Mpa)",4.2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Base cementada"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sub Base Granular"]
[null,null,null,null,"Modulo Resiliente (Psi)",{"$f":"+IF(F24=\"\",\"\",2555*POWER(F24,0.64))","v":7157.0113714588069},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tratamiento simple"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Doble Tratamiento"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,{"$f":"ROUND(LOG(F13),3)","v":3.8919999999999999},"=",{"$f":"ROUND((F15*F19+9.36*LOG(J40+1)-0.2+(LOG(F18/(4.2-1.5)))/(0.4+1094/((J40+1)^5.19))+2.32*LOG(F28)-8.07),3)","v":3.8919999999999999},null,{"$f":"IF(E40=G40,\"SN\",\"ITERAR\")","v":"SN"},1.3826000000000001]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(E40>G40,\"AUMENTAR\",IF(E40<G40,\"DISMINUIR\",IF(E40=G40,\"\",\"ERROR\")))","v":""}]
[]
[null,null,null,null,"CAPA DE MATERIAL","Coeficiente de Capa (a)","Coeficiente de Drenaje (m)","ESPESOR (Pulg)","Numero Estructural de Capa (SN)","ESPESOR (cm)","Numero Estructural de Capa (SN)",null,null,null,null,"Espesor en cm (Calculado)","Espesor en cm (Propuesto)"]
[]
[null,null,null,null,"Base Granular",{"$f":"IF(E45=\"Adoquin\",0.44,IF(E45=\"Asfalto\",POWER($F$25,0.441)*0.0078,IF(E45=\"Base Granular\",POWER($F$22,0.32)*0.032,IF(E45=\"Sub Base Granular\",POWER($F$23,0.19)*0.058,IF(E45=\"Tratamiento simple\",0,IF(E45=\"Doble Tratamiento\",0,IF(E45=\"Base cementada\",POWER($F$26,0.514)*0.0918,\"\")))))))","v":0.13005850997020973},1,8,{"$f":"IF(F45>=0,ROUND(F45*G45*H45,3),\"\")","v":1.04},20,{"$f":"F45*G45*J45","v":2.6011701994041947},null,null,null,null,{"$f":"H45*2.54","v":20.32},{"$f":"J45","v":20}]
[null,null,null,null,"Base Granular",{"$f":"IF(E46=\"Adoquin\",0.44,IF(E46=\"Asfalto\",POWER($F$25,0.441)*0.0078,IF(E46=\"Base Granular\",POWER($F$22,0.32)*0.032,IF(E46=\"Sub Base Granular\",POWER($F$23,0.19)*0.058,IF(E46=\"Tratamiento simple\",0,IF(E46=\"Doble Tratamiento\",0,IF(E46=\"Base cementada\",POWER($F$26,0.514)*0.0918,\"\")))))))","v":0.13005850997020973},1,2,{"$f":"ROUND(F46*G46*H46,3)","v":0.26},5,{"$f":"F46*G46*J46","v":0.65029254985104867},null,null,null,null,{"$f":"H46*2.54","v":5.08},{"$f":"J46","v":5}]
[null,null,null,null,"Base Granular",0.13005850997020973,1,2,0.26,5,0.65029254985104867,null,null,null,null,5.08,5]
[null,null,null,null,null,null,null,null,{"$f":"IF(F48>0,ROUND(F48*G48*H48,3),\"\")","v":""},null,{"$f":"IF(F48>0,F48*G48*J48,\"\")","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(F49>0,ROUND(F49*G49*H49,3),\"\")","v":""},null,{"$f":"IF(F49>0,F49*G49*J49,\"\")","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(F50>0,ROUND(F50*G50*H50,3),\"\")","v":""},null,""]
[]
[]
[null,null,null,null,null,null,"SN (Calculado)",null,{"$f":"ROUND(SUM(I45:I52),3)","v":1.56},null,{"$f":"ROUND(SUM(K45:K52),3)","v":3.9020000000000001}]
[null,null,null,null,null,null,"SN (Requerido)",null,{"$f":"J40","v":1.3826000000000001},null,{"$f":"I54*2.54","v":3.5118040000000001}]
[null,null,null,null,null,null,null,null,{"$f":"IF(I53>=J40,\"OK\",\"AUMENTAR ESPESORES\")","v":"OK"},null,{"$f":"IF(K53>=J40*2.54,\"OK\",\"AUMENTAR ESPESORES\")","v":"OK"}]

{"sheet":"Confiabilidad","index":3,"n_rows":17,"n_cols":8,"rows_kept":17,"cut":false,"hidden":false,"merged":[[3,2,3,7],[4,2,4,4],[4,5,4,7]]}
[]
[null,"AASHTO-93 "]
[null,"PAG. 99"]
[null,"Clasificacion","Nivel de confiabilidad recomendado (R)"]
[null,"funcional","Urbano",null,null,"Rural"]
[null,"Autopista y carreteras interestatales, y otras vias",85,"-",99.9,80,"-",99.9]
[null,"Arterias principales",80,"-",99,75,"-",95]
[null,"Colectoras",80,"-",95,75,"-",95]
[null,"Locales",50,"-",80,50,"-",80]
[]
[null,"Confiabilidad",0.75]
[]
[null,"Generalmente ante los incrementos de los volumenes de tráfico, de las dificultades para diversificar"]
[null,"el tráfico y de las espectativas de disponibilidad del público, debe minimizarse el riesgo de que  los"]
[null,"pavimentos no se comporten adecuadamente. Este objetivo se alcanza seleccionando niveles de "]
[null,"confiabilidad más altos. La Tabla No. 1 presenta los niveles de confiabilidad recomendados para "]
[null,"varias clasificaciones funcionales."]

{"sheet":"Desviacion Estandar","index":4,"n_rows":24,"n_cols":3,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[null,"AASHTO-93 "]
[null,"PAG. 84"]
[null,"CONFIABILIDAD Y DESVIACION ESTÁNDAR"]
[null,"Confiabilidad (R%)","Desviacion normal estándar (ZR)"]
[null,50,0]
[null,60,-0.253]
[null,70,-0.52400000000000002]
[null,75,-0.67400000000000004]
[null,80,-0.84099999999999997]
[null,85,-1.0369999999999999]
[null,90,-1.282]
[null,91,-1.34]
[null,92,-1.405]
[null,93,-1.476]
[null,94,-1.5549999999999999]
[null,95,-1.645]
[null,96,-1.7509999999999999]
[null,97,-1.881]
[null,98,-2.0539999999999998]
[null,99,-2.327]
[null,99.9,-3.09]
[null,99.99,-3.75]
[null,"La selección de un nivel apropiado de confiabilidad para el diseño de una vialidad particular, depende"]
[null,"primariamente del uso del proyectado y de las consecuencias (riesgos)"]

{"sheet":"Indice de Serviciabilidad","index":5,"n_rows":16,"n_cols":7,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[null,"AASHTO-93 "]
[null,"PAG. 28"]
[null,"Valor Indice Serviciabilidad (PSI)"]
[null,"Para el diseño es necesario seleccionar un índices de serviciabilidad inicial y terminal."]
[null,"El índice de Serviciabilidad terminal o final de diseño deberá ser tal que culminado el periodo de vida"]
[null,"proyectado, la vía (superficie de rodadura) ofrezca una adecuada serviciabilidad"]
[]
[null,"- Indice de serviciabilidad inicial (pi)"]
[null,4.2,null,"pavimentos flexible",null,"Pi",4.2]
[null,4.5,null,"pavimentos rígidos"]
[null,"- Indice de serviciabilidad final (pt )"]
[null,"2.5  ó  3.0",null,"carretras principales",null,"Pt",2]
[null,2,null,"carreteras con clasificación menor"]
[null,1.5,null,"carreteras relativamente menores , donde las condiciones económicas"]
[null,null,null,"determinan que gastos iniciales deben ser mantenidos bajos"]

{"sheet":"So","index":6,"n_rows":9,"n_cols":6,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"AASHTO-93 "]
[null,null,"PAG. 84"]
[null,null,"Criterio para la selección de la Desviacion estandar total (So)"]
[null,null,0.3,"-",0.4,"Pavimentos rigidos"]
[null,null,0.4,"-",0.5,"Pavimentos flexibles"]
[]
[null,null,null,null,"So",0.45]

{"sheet":"Coef (a)","index":7,"n_rows":23,"n_cols":13,"rows_kept":23,"cut":false,"hidden":false,"merged":[[3,0,3,2],[3,4,3,6],[3,8,3,9],[3,11,3,12]]}
["1 KN","1000 NEWTON"]
["1000 NEWTON",{"$f":"1000*0.101972","v":101.97199999999999}]
["1 NEWTON",0.10197199999999999]
["Coeficiente Estructural Capa Asfáltica",null,null,null,"Coeficiente Estructural Bases Tratadas con Asfálto",null,null,null,"Coeficiente Estructural Capa Base Granular Triturada",null,null,"Coeficiente Estructural Capa Sub Base Granular"]
["Estabilidad Marshall (N)","Estabilidad Marshall (Kg)","Coeficiente Estructural (a1)",null,"Estabilidad Marshall (N)","Estabilidad Marshall (Kg)","Coeficiente Estructural (a2)",null,"Valor CBR","Coeficiente Estructural (a3)",null,"Valor CBR","Coeficiente Estructural (a4)"]
[5000,{"$f":"+A6*$B$3","v":509.85999999999996},0.33,null,1000,{"$f":"+E6*$B$3","v":101.97199999999999},0.12,null,40,0.11,null,10,0.08]
[6000,{"$f":"+A7*$B$3","v":611.83199999999999},0.36,null,2000,{"$f":"+E7*$B$3","v":203.94399999999999},0.17,null,50,0.12,null,20,0.09]
[7000,713.80399999999997,0.39,null,3000,305.916,0.2,null,60,0.12,null,30,0.11]
[8000,815.77599999999995,0.41,null,4000,407.88799999999998,0.22,null,70,0.13,null,40,0.12]
[9000,917.74799999999993,0.43,null,5000,509.85999999999996,0.25,null,80,0.13,null,50,0.12]
[10000,1019.7199999999999,0.45,null,6000,611.83199999999999,0.27,null,90,0.14000000000000001,null,60,0.13]
[null,null,null,null,7000,713.80399999999997,0.28999999999999998,null,100,0.14000000000000001]
[null,null,null,null,8000,815.77599999999995,0.31]
[]
[612,{"$f":"+IF(A15=\"\",\"\",IF(A15=0,0,IF(A15<B7,C6,IF(A15<B8,C7,IF(A15<B9,C8,IF(A15<B10,C9,IF(A15<B11,C10,IF(A15>1019,C11))))))))","v":0.36},null,null,500,{"$f":"+IF(E15=\"\",\"\",IF(E15=0,0,IF(E15<F7,G6,IF(E15<F8,G7,IF(E15<F9,G8,IF(E15<F10,G9,IF(E15<F11,G10,IF(E15<F12,G11,IF(E15<F13,G12,IF(E15>F13,G13))))))))))","v":0.22},null,null,90,{"$f":"+IF(I15=\"\",\"\",IF(I15=0,0,IF(I15<I7,J6,IF(I15<I8,J7,IF(I15<I9,J8,IF(I15<I10,J9,IF(I15<I11,J10,IF(I15<I12,J11,IF(I15>99,J12)))))))))","v":0.14000000000000001},null,45,{"$f":"+IF(L15=\"\",\"\",IF(L15=0,0,IF(L15<L7,M6,IF(L15<L8,M7,IF(L15<L9,M8,IF(L15<L10,M9,IF(L15<L11,M10,IF(L15>59,M11))))))))","v":0.12}]
[]
[3500,{"$f":"+IF(A17=\"\",\"\",IF(A17=0,0,IF(A17<B7,C6,IF(A17<B8,C7,IF(A17<B9,C8,IF(A17<B10,C9,IF(A17<B11,C10,IF(A17>1019,C11))))))))","v":0.45},null,null,500,{"$f":"+IF(E17=\"\",\"\",IF(E17=0,0,IF(E17<F7,G6,IF(E17<F8,G7,IF(E17<F9,G8,IF(E17<F10,G9,IF(E17<F11,G10,IF(E17<F12,G11,IF(E17<F13,G12,IF(E17>F13,G13))))))))))","v":0.22},null,null,90,{"$f":"+IF(I17=\"\",\"\",IF(I17=0,0,IF(I17<I7,J6,IF(I17<I8,J7,IF(I17<I9,J8,IF(I17<I10,J9,IF(I17<I11,J10,IF(I17<I12,J11,IF(I17>99,J12)))))))))","v":0.14000000000000001},null,45,{"$f":"+IF(L17=\"\",\"\",IF(L17=0,0,IF(L17<L7,M6,IF(L17<L8,M7,IF(L17<L9,M8,IF(L17<L10,M9,IF(L17<L11,M10,IF(L17>59,M11))))))))","v":0.12}]
[]
["% de Deterioro de la Vía",10]
[]
["Coef. De Reducción sup. De Rodadura",{"$f":"+IF($B$15=\"\",\"\",(B15*(1-($B$19/100))))","v":0.32400000000000001},null,null,"Coef. De Reducción Base Asf. Estab.",{"$f":"+IF($F$15=\"\",\"\",(F15*(1-($B$19/100))))","v":0.19800000000000001},null,null,"Coef. De Reducción Base Gran. Trit.",{"$f":"+IF($J$15=\"\",\"\",(J15*(1-($B$19/100))))","v":0.12600000000000003},null,"Coef. De Reducción Sub Base Granular",{"$f":"+IF($M$15=\"\",\"\",(M15*(1-($B$19/100))))","v":0.108}]
[]
["Coef. De Reducción sup. De Rod. Propuesta",{"$f":"+IF($B$17=\"\",\"\",(B17*(1-($B$19/100))))","v":0.40500000000000003},null,null,"Coef. De Reducción Base Asf. Estab. Propuesta",{"$f":"+IF($F$17=\"\",\"\",(F17*(1-($B$19/100))))","v":0.19800000000000001},null,null,"Coef. De Reducción Base Gran. Trit. Propuesta",{"$f":"+IF($J$17=\"\",\"\",(J17*(1-($B$19/100))))","v":0.12600000000000003},null,"Coef. De Reducción Sub Base Granular Propuesta",{"$f":"+IF($M$17=\"\",\"\",(M17*(1-($B$19/100))))","v":0.108}]

{"sheet":"m","index":8,"n_rows":54,"n_cols":10,"rows_kept":54,"cut":false,"hidden":false,"merged":[[2,0,2,3],[2,4,2,7],[3,0,3,3],[3,4,3,7],[4,0,4,3],[4,4,4,7],[5,0,5,3],[5,4,5,7],[6,0,6,3],[6,4,6,7],[7,0,7,3],[7,4,7,7],[20,8,20,9],[8,0,9,0],[8,1,8,7],[20,0,20,1],[20,2,20,3],[20,4,20,5],[20,6,20,7]]}
[]
[]
["Calidad de Drenaje",null,null,null,"Tiempo de Eliminación del Agua en"]
["Excelente",null,null,null,"2 Horas"]
["Bueno",null,null,null,"1 Día"]
["Regular",null,null,null,"1 Semana"]
["Pobre",null,null,null,"1 Mes"]
["Malo",null,null,null,"El Agua no Drena"]
["Calidad de Drenaje","Porcentaje de tiempo anual en que la estructura del pavimento está expuesta a niveles cercanos a saturación"]
[null,0,0.01,0.01,0.05,0.05,0.25,0.25]
["Excelente",1.4,1.35,1.35,1.3,1.3,1.2,1.2]
["Bueno",1.35,1.25,1.25,1.1499999999999999,1.1499999999999999,1,1]
["Regular",1.25,1.1499999999999999,1.1499999999999999,1.05,1,0.8,0.8]
["Pobre",1.1499999999999999,1.05,1.05,0.8,0.8,0.6,0.6]
["Malo",1.05,0.95,0.95,0.75,0.75,0.4,0.4]
[]
["Calidad de Drenaje","Excelente","Bueno",null,"Coef.de Drenaje BG",{"$f":"+IF(B17=\"\",\"\",IF(B17=A21,A22,IF(B17=C21,C22,IF(B17=E21,E22,IF(B17=G21,G22,IF(B17=I21,I22))))))","v":1.2424608956960967}]
["Porcentaje de Exposición BG",0.16438356164383564,null,null,"Coef. de Drenaje SBG",{"$f":"+IF(C17=\"\",\"\",IF(C17=A21,A23,IF(C17=C21,C23,IF(C17=E21,E23,IF(C17=G21,G23,IF(C17=I21,I23))))))","v":1.0639948456824537}]
["Porcentaje de Exposición SBG",0.16438356164383564]
[]
["Excelente",null,"Bueno",null,"Regular",null,"Pobre",null,"Malo"]
[{"$f":"IF(B18=\"\",\"\",IF(B17=A21,27860*B18^6-23600*B18^5+7844.2*B18^4-1294.7*B18^3+110.52*B18^2-5.079*B18+1.3972,\"\"))","v":1.2424608956960967},"B.G.",{"$f":"IF(B18=\"\",\"\",IF(B17=C21,52379*B18^6-44691*B18^5+15008*B18^4-2514.7*B18^3+219.67*B18^2-10.185*B18+1.3447,\"\"))","v":""},"B.G.",{"$f":"IF(B18=\"\",\"\",IF(B17=E21,59060*B18^6-49708*B18^5+16369*B18^4-2664.1*B18^3+222.4*B18^2-10.131*B18+1.2443,\"\"))","v":""},"B.G.",{"$f":"IF(B18=\"\",\"\",IF(B17=G21,-6727.6*B18^6+224.26*B18^5+2466.6*B18^4-1015.5*B18^3+165*B18^2-12.864*B18+1.1575,\"\"))","v":""},"B.G.",{"$f":"IF(B18=\"\",\"\",IF(B17=I21,24110*B18^6-23109*B18^5+8916.2*B18^4-1764.2*B18^3+187.78*B18^2-11.882*B18+1.0526,\"\"))","v":""},"B.G."]
[{"$f":"IF(B19=\"\",\"\",IF(C17=A21,27860*B19^6-23600*B19^5+7844.2*B19^4-1294.7*B19^3+110.52*B19^2-5.079*B19+1.3972,\"\"))","v":""},"S.B.G",{"$f":"IF(B19=\"\",\"\",IF(C17=C21,52379*B19^6-44691*B19^5+15008*B19^4-2514.7*B19^3+219.67*B19^2-10.185*B19+1.3447,\"\"))","v":1.0639948456824537},"S.B.G",{"$f":"IF(B19=\"\",\"\",IF(C17=E21,59060*B19^6-49708*B19^5+16369*B19^4-2664.1*B19^3+222.4*B19^2-10.131*B19+1.2443,\"\"))","v":""},"S.B.G",{"$f":"IF(B19=\"\",\"\",IF(C17=G21,-6727.6*B19^6+224.26*B19^5+2466.6*B19^4-1015.5*B19^3+165*B19^2-12.864*B19+1.1575,\"\"))","v":""},"S.B.G",{"$f":"IF(B19=\"\",\"\",IF(C17=I21,24110*B19^6-23109*B19^5+8916.2*B19^4-1764.2*B19^3+187.78*B19^2-11.882*B19+1.0526,\"\"))","v":""},"S.B.G"]
[0,1.4,0,1.35,0,1.25,0,1.1499999999999999,0,1.05]
[2E-3,1.39,2E-3,1.33,2E-3,1.23,2E-3,1.1299999999999999,2E-3,1.03]
[4.0000000000000001E-3,1.38,4.0000000000000001E-3,1.31,4.0000000000000001E-3,1.21,4.0000000000000001E-3,1.1100000000000001,4.0000000000000001E-3,1.01]
[6.0000000000000001E-3,1.37,6.0000000000000001E-3,1.29,6.0000000000000001E-3,1.19,6.0000000000000001E-3,1.0900000000000001,6.0000000000000001E-3,0.99]
[8.0000000000000002E-3,1.36,8.0000000000000002E-3,1.27,8.0000000000000002E-3,1.17,8.0000000000000002E-3,1.07,8.0000000000000002E-3,0.97]
[0.01,1.35,0.01,1.25,0.01,1.1499999999999999,0.01,1.05,0.01,0.95]
[1.4999999999999999E-2,1.34,1.4999999999999999E-2,1.23,1.4999999999999999E-2,1.1299999999999999,1.4999999999999999E-2,{"$f":"+H29-0.05","v":1},1.4999999999999999E-2,{"$f":"+J29-0.04","v":0.90999999999999992}]
[0.02,1.33,0.02,1.21,0.02,1.1100000000000001,0.02,{"$f":"+H30-0.05","v":0.95},0.02,{"$f":"+J30-0.04","v":0.86999999999999988}]
[0.03,1.32,0.03,1.19,0.03,1.0900000000000001,0.03,0.89999999999999991,0.03,0.82999999999999985]
[0.04,1.31,0.04,1.17,0.04,1.07,0.04,0.84999999999999987,0.04,0.78999999999999981]
[0.05,1.3,0.05,1.1499999999999999,0.05,1.05,0.05,0.79999999999999982,0.05,0.74999999999999978]
[0.06,{"$f":"+B34-0.005","v":1.2950000000000002},0.06,{"$f":"+D34-0.0075","v":1.1424999999999998},0.06,{"$f":"+F34-0.0125","v":1.0375000000000001},0.06,{"$f":"+H34-0.01","v":0.78999999999999981},0.06,{"$f":"+J34-0.0175","v":0.73249999999999982}]
[7.0000000000000007E-2,{"$f":"+B35-0.005","v":1.2900000000000003},7.0000000000000007E-2,{"$f":"+D35-0.0075","v":1.1349999999999998},7.0000000000000007E-2,{"$f":"+F35-0.0125","v":1.0250000000000001},7.0000000000000007E-2,{"$f":"+H35-0.01","v":0.7799999999999998},7.0000000000000007E-2,{"$f":"+J35-0.0175","v":0.71499999999999986}]
[0.08,1.2850000000000004,0.08,1.1274999999999997,0.08,1.0125000000000002,0.08,0.7699999999999998,0.08,0.6974999999999999]
[0.09,1.2800000000000005,0.09,1.1199999999999997,0.09,1.0000000000000002,0.09,0.75999999999999979,0.09,0.67999999999999994]
[0.1,1.2750000000000006,0.1,1.1124999999999996,0.1,0.98750000000000027,0.1,0.74999999999999978,0.1,0.66249999999999998]
[0.11,1.2700000000000007,0.11,1.1049999999999995,0.11,0.97500000000000031,0.11,0.73999999999999977,0.11,0.64500000000000002]
[0.12,1.2650000000000008,0.12,1.0974999999999995,0.12,0.96250000000000036,0.12,0.72999999999999976,0.12,0.62750000000000006]
[0.13,1.2600000000000009,0.13,1.0899999999999994,0.13,0.9500000000000004,0.13,0.71999999999999975,0.13,0.6100000000000001]
[0.14000000000000001,1.255000000000001,0.14000000000000001,1.0824999999999994,0.14000000000000001,0.93750000000000044,0.14000000000000001,0.70999999999999974,0.14000000000000001,0.59250000000000014]
[0.15,1.2500000000000011,0.15,1.0749999999999993,0.15,0.92500000000000049,0.15,0.69999999999999973,0.15,0.57500000000000018]
[0.16,1.2450000000000012,0.16,1.0674999999999992,0.16,0.91250000000000053,0.16,0.68999999999999972,0.16,0.55750000000000022]
[0.17,1.2400000000000013,0.17,1.0599999999999992,0.17,0.90000000000000058,0.17,0.67999999999999972,0.17,0.54000000000000026]
[0.18,1.2350000000000014,0.18,1.0524999999999991,0.18,0.88750000000000062,0.18,0.66999999999999971,0.18,0.5225000000000003]
[0.19,1.2300000000000015,0.19,1.044999999999999,0.19,0.87500000000000067,0.19,0.6599999999999997,0.19,0.50500000000000034]
[0.2,1.2250000000000016,0.2,1.037499999999999,0.2,0.86250000000000071,0.2,0.64999999999999969,0.2,0.48750000000000032]
[0.21,1.2200000000000017,0.21,1.0299999999999989,0.21,0.85000000000000075,0.21,0.63999999999999968,0.21,0.47000000000000031]
[0.22,1.2150000000000019,0.22,1.0224999999999989,0.22,0.8375000000000008,0.22,0.62999999999999967,0.22,0.45250000000000029]
[0.23,1.210000000000002,0.23,1.0149999999999988,0.23,0.82500000000000084,0.23,0.61999999999999966,0.23,0.43500000000000028]
[0.24,1.2050000000000021,0.24,1.0074999999999987,0.24,0.81250000000000089,0.24,0.60999999999999965,0.24,0.41750000000000026]
[0.25,1.2000000000000022,0.25,0.99999999999999878,0.25,0.80000000000000093,0.25,0.59999999999999964,0.25,0.40000000000000024]

{"sheet":"REPORTE","index":9,"n_rows":41,"n_cols":10,"rows_kept":41,"cut":false,"hidden":false,"merged":[[17,4,17,10],[13,4,13,10],[15,4,15,10],[1,2,1,10],[2,2,2,10],[3,2,4,10],[9,4,9,10],[11,4,11,11]]}
[]
[null,null,"DISEÑO DE PAVIMENTO FLEXIBLE"]
[null,null," Diseño de espesores de Pavimento de acuerdo a:"]
[null,null,"1993 AASHTO Guide for Design of Pavements Structures"]
[]
[]
[]
[]
[]
[null,null,null,"Empresa:",{"$f":"'PROJECT ID'!G6","v":"GOBIERNO REGIONAL TUMBES"}]
[]
[null,null,null,"Cliente:",{"$f":"'PROJECT ID'!G8","v":"GOBIERNO REGIONAL TUMBES"}]
[]
[null,null,null,"Descripcion del Proyecto:",{"$f":"'PROJECT ID'!G10","v":"CARPETA AFIRMADA"}]
[]
[null,null,null,"Ubicacion:",{"$f":"'PROJECT ID'!G13","v":"HUASIMO - CABO INGA"}]
[]
[null,null,null,"Ingeniero:",{"$f":"'PROJECT ID'!G16","v":0}]
[]
[]
[]
[null,null,null,"Diseño de Pavimento Flexible"]
[]
[null,null,null,"Número Estructural",{"$f":"Diseño!J40","v":1.3826000000000001},null,null,"Módulo Resiliente (Psi)",null,{"$f":"Diseño!F28","v":7157.0113714588069}]
[null,null,null,"Design ESALs",{"$f":"Diseño!F13","v":7801.3558034805701},null,null,"Serviciabilidad Inicial ",null,{"$f":"Diseño!F16","v":4.2}]
[null,null,null,"Confiabilidad",{"$f":"Diseño!F14","v":0.75},null,null,"Serviciabilidad Final ",null,{"$f":"Diseño!F17","v":2}]
[null,null,null,"Desviación Estandar",{"$f":"Diseño!F15","v":-0.67400000000000004}]
[]
[]
[null,null,null,"Diseño de Espesores de Pavimento"]
[]
[null,null,null,"CAPA DE MATERIAL","Coeficiente de Capa (a)","Coeficiente de Drenaje (m)","ESPESOR (Pulg)","Numero Estructural de Capa (SN)","ESPESOR (cm)","Numero Estructural de Capa (SN)"]
[]
[null,null,null,"Asfalto",{"$f":"Diseño!F45","v":0.13005850997020973},{"$f":"Diseño!G45","v":1},{"$f":"Diseño!H45","v":8},{"$f":"Diseño!I45","v":1.04},{"$f":"Diseño!J45","v":20},{"$f":"Diseño!K45","v":2.6011701994041947}]
[null,null,null,"Base Granular",{"$f":"Diseño!F46","v":0.13005850997020973},{"$f":"Diseño!G46","v":1},{"$f":"Diseño!H46","v":2},{"$f":"Diseño!I46","v":0.26},{"$f":"Diseño!J46","v":5},{"$f":"Diseño!K46","v":0.65029254985104867}]
[null,null,null,"Sub Base Granular",{"$f":"Diseño!F47","v":0.13005850997020973},{"$f":"Diseño!G47","v":1},{"$f":"Diseño!H47","v":2},{"$f":"Diseño!I47","v":0.26},{"$f":"Diseño!J47","v":5},{"$f":"Diseño!K47","v":0.65029254985104867}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"SUM(H34:H40)","v":1.56},null,{"$f":"SUM(J34:J40)","v":3.9017552991062918}]

{"sheet":"F´c (Mpa)","index":10,"n_rows":20,"n_cols":5,"rows_kept":20,"cut":false,"hidden":false,"merged":[[19,4,19,8]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Resistencia a la compresion (Base estabilizada con cemento)"]
[]
[null,null,null,null,"Especificaciones adecuadas:"]
[null,null,null,null,"•Suelos Finos (Res. = 2 – 2,4 MPa ; Retracción = 525 x 10-6 )"]
[null,null,null,null,"•Suelos Gruesos (Res. = 3,1MPa ; Retracción = 300 x 10-6 )"]
[]
[null,null,null,null,"Se determina en laboratorio"]