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

{"sheet":"Hoja1","index":0,"n_rows":53,"n_cols":16,"rows_kept":53,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Partida","Perfilado de Terreno con Tractor",null,null,"Costo unitario directo por : m2",null,{"$f":"+H9+H15+H18","v":2.8762499999999998}]
[null,"Jornada",10]
[null,"Rendimiento",400,"m2 /jornada"]
[]
[null,"Descripción Recurso",null,"Unidad","Cuadrilla","Cantidad","Precio US $","Parcial US $"]
[null,null,null,null,null,null,null,null,null,"Function cant(arg1, arg2, arg3)"]
[null,"Mano de Obra",null,null,null,null,null,{"$f":"SUM(H10:H13)","v":0.57225000000000004},null,"resultado = ((arg1 * arg2) / arg3)"]
[null,"Capataz",null,"hh",1,{"$f":"+cant(E10,$C$4,$C$5)","v":2.5000000000000001E-2},6.78,{"$f":"+parcial(F10,G10)","v":0.16950000000000001},null,"cant = resultado"]
[null,"Peon",null,"hh",1,{"$f":"+cant(E11,$C$4,$C$5)","v":2.5000000000000001E-2},5.22,{"$f":"+parcial(F11,G11)","v":0.1305},null,"End Function"]
[null,"Vigía",null,"hh",1,2.5000000000000001E-2,3.91,9.7750000000000004E-2]
[null,"Operador de equipo pesado",null,"hh",1,2.5000000000000001E-2,6.98,0.17450000000000002]
[null,null,null,null,null,null,null,null,null,null,1,"x","10 horas"]
[null,"Materiales",null,null,null,null,null,{"$f":"SUM(H16)","v":0.78299999999999992},null,"Cantidad =",null,null,"1 jornada","=",{"$f":"+K14*10/K16","v":2.5000000000000001E-2},"horas/m2"]
[null,"Petroleo diesel  D-2",null,"gln",null,0.15,5.22,{"$f":"+parcial(F16,G16)","v":0.78299999999999992},null,null,400,"m2"]
[null,null,null,null,null,null,null,null,null,null,null,"jornada"]
[null,"Equipos",null,null,null,null,null,{"$f":"SUM(H19:H20)","v":1.5209999999999999}]
[null,"Herramientas manuales",null,"%MO",null,0.05,0.42,{"$f":"+parcial(F19,G19)","v":2.1000000000000001E-2}]
[null,"Tractor sobre oruga 75-100HP",null,"hm",1,{"$f":"+cant(E20,$C$4,$C$5)","v":2.5000000000000001E-2},60,{"$f":"+parcial(F20,G20)","v":1.5}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Partida","Es el nombre del trabajo que se va ha realizar."]
[null,null,null,null,"Variable cuadrilla","La cuadrilla es el grupo de recursos que se utiliza para realizar los trabajos dentro de la partida."]
[null,null,null,null,"Por ejempo:","La partida Perfilado de terreno con tractor utilizará los siguientes recursos:"]
[null,null,null,null,null,"Un (01) Capataz"]
[null,null,null,null,null,"Un(01) Peón"]
[null,null,null,null,null,"Un(01) Vigía"]
[null,null,null,null,null,"Un(01) Operador de equipo pesado"]
[null,null,null,null,null,"(06) Galones de Petroleo"]
[null,null,null,null,null,"(01) Tractor sobre Orugas"]
[null,null,null,null,"Variable jornada","La jornada es la cantidad de horas trabajas al día. En este caso utilizaremos 10 horas de trabajo."]
[null,null,null,null,"Varibale Rendimiento","El rendimiento es el metrado o cantidad de trabajo que se realiza en una jornada laboral utilizando una cuadrilla especifica."]
[]
[null,null,null,null,"Función cantidad ","Relaciona las siguientes variables: el valor de la cuadrilla, jornada y rendimiento de la siguiente manera."]
[null,null,null,null,null,"cant = cuadrilla x jornada /rendimiento"]
[null,null,null,null,null,"De esta forma se obtiene la cantidad de horas por metro cuadrado de cada personal o equipo para realizar las actividades de la partida."]
[]
[null,null,null,null,"Entonces si se multiplica la cantidad por su costo unitario  se obtiene el costo por la unidad trabajada "]

{"sheet":"Hoja2","index":1,"n_rows":2,"n_cols":8,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[null,"Partida","Rendimiento","Unidad","Ratio de HH","Costo de Mano de Obra","Costo de Materiales","Costo de Equipos"]
[null,"Perfilado de Terreno con Tractor e=0.30 m",400,"m2/dia",7.7500000000000013E-2,0.41970000000000002,0.78299999999999992,1.5209999999999999]

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