{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["01|Ficha Operaciones","02|Elementos","03|Ciclos","04|Fecuencia","05|06|07|08|09|USP","10|Eficiencia","11|Incentivos"],"not_rendered":{"charts":0,"images":10,"macros":1,"external_links":0,"defined_names":3,"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":"01|Ficha Operaciones","index":0,"n_rows":129,"n_cols":12,"rows_kept":129,"cut":false,"hidden":false,"merged":[[103,2,103,3],[104,2,104,3],[105,2,105,3],[6,1,6,4],[6,5,6,11],[11,5,11,11],[7,5,10,11],[47,1,47,4],[47,5,47,11],[18,1,18,11],[97,4,97,5],[97,6,97,8],[101,1,102,1],[101,2,102,3],[101,4,102,4],[101,5,102,5],[101,6,102,6],[101,7,101,11],[94,4,94,5],[94,6,94,8],[95,4,95,5],[95,6,95,8],[96,4,96,5],[96,6,96,8],[93,4,93,5],[93,6,93,8],[1,1,1,11],[87,1,87,11],[91,1,91,3],[91,4,91,8],[92,4,92,5],[92,6,92,8],[61,1,61,11],[74,1,74,11]]}
[]
[null,"FICHA DE OPERACIONES DEL PRODUCTO Y/O PROCESO ESTUDIO DE TIEMPOS"]
[]
[null,"Proceso a Estudiar:",null,"PINTURA ELECTROESTÁTICA DIFUSOR"]
[null,"Analista d tiempos:",null,"Ing. Yornandy Martínez","Operarios:",null,"• Juan David García"]
[null,"Fecha del estudio:",null,"2018-08-07",null,null,"• Andrés Arango"]
[null,"PRODUCTO TERMINADO",null,null,null,"DESCRIPCIÓN DEL PRODUCTO / PROCESO"]
[null,null,null,null,null,"Difusor de techo con elemento central fijo, removible y aleta curva, aplicación sistemas de aire acondicionado, ventilación y calefacción."]
[]
[]
[]
[null,null,null,null,null,"MATERIALES UTILIZADOS EN EL PROCESO"]
[null,null,null,null,null,"• Aluminio extruido",null,null,"• Pintura Epoxipoliéster"]
[null,null,null,null,null,"• Cerradores aluminio"]
[null,null,null,null,null,"• Gancho esquina"]
[null,null,null,null,null,"• Panel central"]
[null,null,null,null,null,"• Varilla acero 1/4\""]
[]
[null,"SECUENCIA DE OPERACIONES"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"DESCRIPCIÓN DE LAS OPERACIONES",null,null,null,"SEGURIDAD INDUSTRIAL"]
[null,1,"Seleccionar productos a ser pintados"]
[null,2,"Colgar productos en soporte para ser lavados"]
[null,3,"Sumergir productos en tanque de Foxfes"]
[null,4,"Ubicar productos en carro de secado"]
[null,5,"Secar productos en horno a 120° / 10 minutos"]
[null,6,"Organizar productos para ser pintados"]
[null,7,"Pintar producto parte frontal pintura electroestática"]
[null,8,"Pintar producto parte posterior pintura electroestática"]
[null,9,"Ubicar producto pintado en carro de horneado"]
[null,10,"Ingresar carro al horno 180° - 15 minutos"]
[null,11,"Sacar carro del horno"]
[null,12,"Enfriar producto terminado"]
[]
[null,"PRINCIPALES MAQUINAS - EQUIPOS - HERRAMIENTAS UTILIZADAS EN EL PROCESO"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"DIAGRAMA DE RECORRIDOS EN PUESTOS DE TRABAJO"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"CURSOGRAMA ANALÍTICO DEL PROCESO"]
[]
[null,"Hoja N°___1___   De:__1__   Diagrama N°:__1__",null,null,null,"Operar.","X","Mater.",null,"Maqui."]
[]
[null,"Proceso: Pintura Electroestática",null,null,"RESUMEN"]
[null,"Fecha: Mayo 12 de 2017",null,null,"SÍMBOLO",null,"ACTIVIDAD",null,null,"Act.","Pro.","Econ."]
[null,"El estudio Inicia: Ingreso de productos sección de pintura",null,null,null,null,"Operación",null,null,{"$f":"COUNTA($H$104:$H$125)","v":9}]
[null,"Método: Actual",null,null,null,null,"Transporte",null,null,{"$f":"COUNTA($I$104:$I$125)","v":5}]
[null,"Producto: L-JS F 4 STYLE 9 12\"X12\"",null,null,null,null,"Inspección",null,null,{"$f":"COUNTA($J$104:$J$125)","v":1}]
[null,"Nombre del operario: Andrés Arango",null,null,null,null,"Espera",null,null,{"$f":"COUNTA($K$104:$K$125)","v":1}]
[null,"Elaborado por: Yornandy Martínez",null,null,null,null,"Almacenaje",null,null,{"$f":"COUNTA($L$104:$L$125)","v":1}]
[null,"Tamaño del Lote:",null,1,"Total de actividades realizadas",null,null,null,null,{"$f":"SUM(J94:J98)","v":17}]
[null,null,null,null,"Distancia total en metros",null,null,null,null,{"$f":"F126","v":15.600000000000001}]
[null,null,null,null,"Tiempo min/hombre",null,null,null,null,{"$f":"D126","v":43.63333333333334}]
[null,"NUMERO","DESCRIPCIÓN DEL PROCESO",null,"Cantidad","Distancia metros","Tiempo Segundos","SÍMBOLOS PROCESOS"]
[]
[null,1,"Colocar gancho metálico al producto",null,1,null,5.3,"•"]
[null,2,"Transportar producto al tanque 1 de lavado",null,1,1.5,5.0999999999999996,null,"•"]
[null,3,"Colgar producto en soporte metálico",null,1,null,2,"•"]
[null,4,"Dejar escurrir",null,1,null,2.5,"•"]
[null,5,"Colocar producto en carro de secado",null,1,null,4.3,"•"]
[null,6,"Transportar carro con productos al horno",null,1,4.8,38.200000000000003,null,"•"]
[null,7,"Secar productos a 180°C",null,1,null,1080,"•"]
[null,8,"Sacar carro del horno",null,1,null,30.2,"•"]
[null,9,"Transportar carro con productos a zona de enfriamiento",null,1,2.2999999999999998,25.8,null,"•"]
[null,10,"Colocar producto en carro de curado",null,1,null,15.7,"•"]
[null,11,"Transportar carro con productos al horno",null,1,1.8,48.2,null,"•"]
[null,12,"Hornear productos a 220°C",null,1,null,1080,"•"]
[null,13,"Transportar carro con productos a zona de enfriamiento",null,1,5.2,25.3,null,"•"]
[null,14,"Esperar inspector de calidad",null,1,null,240,null,null,null,"•"]
[null,15,"Despegar producto del carro",null,1,null,1.8,"•"]
[null,16,"Inspeccionar producto",null,1,null,5.9,null,null,"•"]
[null,17,"Almacenar producto pintado",null,1,null,7.7,null,null,null,null,"•"]
[]
[]
[]
[]
[]
[null,null,"Tiempo Minutos:",{"$f":"G126/60","v":43.63333333333334},"m",{"$f":"SUM(F104:F125)","v":15.600000000000001},{"$f":"SUM(G104:G125)","v":2618.0000000000005},"s"]
[]
[null,"Observaciones:"]
[null,"El proceso se encuentra estandarizado"]

{"sheet":"02|Elementos","index":1,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"FICHA DESCRIPTIVA DE ELEMENTOS Y PUNTOS DE CORTE"]
[null,"Nombre del proceso: Ensamble Dámper OB 8\"x8\" Palanca"]
[null,"Analistas de tiempos: Yornandy Martinez"]
[null,"Operarios: Santiago Restrepo"]
[]
[null,"Elem.","Descripción del elemento","Puntos de corte / finalización",null,"Imagen finaliza el elemento"]
[null,1,"Ensamblar marco Dámper OB","Posiciona soporte para ensamble complementos y piñones"]
[null,2,"Ensamblar complemento y piñon en la aleta","Posiciona marco dámper para ensamble de aletas"]
[null,3,"Ensamblar aleta en marco dámper OB","Sujeta remachador de marco"]
[null,4,"Cerrar marco dámper OB","Libera remachador de marco"]
[null,5,"Ajustar manualmente el panel de aletas","Sujeta palanca de accionamiento"]
[null,6,"Ensamblar palanca de accionamiento","Libera martillo de ajuste"]
[null,7,"Pruebas de accionamiento mecánico","Almacena dámper"]

{"sheet":"03|Ciclos","index":2,"n_rows":107,"n_cols":11,"rows_kept":107,"cut":false,"hidden":false,"merged":[[47,4,47,5],[48,8,48,10],[50,8,50,10],[51,8,51,10],[55,1,55,2],[44,8,45,8],[1,1,1,11],[11,1,11,2],[11,4,11,7],[14,8,15,8],[17,4,17,5],[18,8,18,10],[20,8,20,10],[21,8,21,10],[30,1,30,11],[40,1,40,2],[40,4,40,7]]}
[]
[null,"SIMULADOR PARA CALCULO MUESTREO ALEATORIO SIMPLE (SIN CICLOS)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Tabla Z",null,null,"DATOS PARA EL CALCULO"]
[null,"Confianza","Valor Z",null,"Nivel de confianza solicitado",null,null,0.95]
[null,0.99,2.58,null,"Nivel de error permitido",null,null,0.05]
[null,0.98,2.38,null,"p: probabilidad de que ocurra",null,null,0.5,{"$f":"SUM(H15:H16)","v":1}]
[null,0.97,2.25,null,"q: probabilidad de que no ocurra",null,null,0.5]
[null,0.96,2.12]
[null,0.95,1.96,null,"Definición variables",null,null,"n  =",{"$f":"F20^2","v":3.8415999999999997},{"$f":"F21","v":0.5},{"$f":"F22","v":0.5}]
[null,0.94,1.88,null,"n","?",null,null,{"$f":"F23^2","v":2.5000000000000005E-3}]
[null,0.93,1.81,null,"Z",{"$f":"INDEX(B14:C24,MATCH(H13,B14:B24,0),2)","v":1.96}]
[null,0.92,1.75,null,"p",{"$f":"H15/1","v":0.5},null,"n  =",{"$f":"I18*J18*K18","v":0.96039999999999992}]
[null,0.91,1.69,null,"q",{"$f":"H16/1","v":0.5},null,null,{"$f":"I19","v":2.5000000000000005E-3}]
[null,0.9,1.65,null,"E",{"$f":"H14/1","v":0.05}]
[null,0.8,1.28,null,null,null,null,"n  =",{"$f":"I21/I22","v":384.15999999999991},"Ciclos o muestreos"]
[]
[]
[null,"Sino hay información previa p y q valdrán el 50% cada uno."]
[null,"se descome la población"]
[]
[]
[null,"SIMULADOR PARA CALCULO MUESTREO ALEATORIO SIMPLE (CON CICLOS)"]
[]
[null,null,null,null,null,null,"n","Tamaño de la muestra"]
[null,null,null,null,null,null,"Z","Nivel de confianza"]
[null,null,null,null,null,null,"p","Variabilidad positiva"]
[null,null,null,null,null,null,"q","Variabilidad negativa"]
[null,null,null,null,null,null,"E","Nivel de error permitido"]
[null,null,null,null,null,null,"N","Tamaño población (mediciones)"]
[null,null,null,null,null,null,"σ","Sigma"]
[]
[null,"Tabla Z",null,null,"DATOS PARA EL CALCULO"]
[null,"Confianza","Valor Z",null,"Nivel de confianza solicitado",null,null,0.95]
[null,0.99,2.58,null,"Nivel de error permitido",null,null,0.05]
[null,0.98,2.38,null,"Tamaño de la Población",null,null,{"$f":"COUNT(C58:C107)","v":50}]
[null,0.97,2.25,null,"p: probabilidad de que ocurra",null,null,0.5,{"$f":"SUM(H45:H46)","v":1}]
[null,0.96,2.12,null,"q: probabilidad de que no ocurra",null,null,0.5]
[null,0.95,1.96]
[null,0.94,1.88,null,"Definición variables",null,null,"n  =",{"$f":"F54","v":50},{"$f":"F50^2","v":3.8415999999999997},{"$f":"F51*F52","v":0.25}]
[null,0.93,1.81,null,"n","?",null,null,{"$f":"(F54-1)*F53^2+F50^2*F51*F52","v":1.0829}]
[null,0.92,1.75,null,"Z",{"$f":"INDEX(B43:C53,MATCH(H42,B43:B53,0),2)","v":1.96}]
[null,0.91,1.69,null,"p",{"$f":"H45/1","v":0.5},null,"n  =",{"$f":"I48*J48*K48","v":48.019999999999996}]
[null,0.9,1.65,null,"q",{"$f":"H46/1","v":0.5},null,null,{"$f":"I49","v":1.0829}]
[null,0.8,1.28,null,"E",{"$f":"H43/1","v":0.05}]
[null,null,null,null,"N",{"$f":"H44","v":50},null,"n  =",{"$f":"I51/I52","v":44.343891402714931},"Ciclos o muestreos"]
[]
[null,"Tiempo Normalizado"]
[null,"Ciclos","TN / Seg"]
[null,1,3.93]
[null,2,4.0949999999999998]
[null,3,3.85]
[null,4,4.944]
[null,5,3.6960000000000002]
[null,6,3.45]
[null,7,2.5959999999999996]
[null,8,2.4750000000000001]
[null,9,4.4295999999999998]
[null,10,2.8050000000000002]
[null,11,4.7119999999999997]
[null,12,4.6560000000000006]
[null,13,4.1420000000000003]
[null,14,5.4]
[null,15,3.78]
[null,16,3.4319999999999999]
[null,17,3.9805000000000001]
[null,18,3.762]
[null,19,3.52]
[null,20,5.96]
[null,21,2.3760000000000003]
[null,22,3.12]
[null,23,2.4750000000000001]
[null,24,4.4295999999999998]
[null,25,2.8050000000000002]
[null,26,4.7119999999999997]
[null,27,3.78]
[null,28,3.4319999999999999]
[null,29,3.9805000000000001]
[null,30,3.85]
[null,31,4.944]
[null,32,3.6960000000000002]
[null,33,4.4295999999999998]
[null,34,2.8050000000000002]
[null,35,4.7119999999999997]
[null,36,5.96]
[null,37,2.3760000000000003]
[null,38,3.12]
[null,39,2.4750000000000001]
[null,40,4.4295999999999998]
[null,41,2.8050000000000002]
[null,42,2.4750000000000001]
[null,43,4.4295999999999998]
[null,44,2.8050000000000002]
[null,45,4.7119999999999997]
[null,46,4.6560000000000006]
[null,47,4.1420000000000003]
[null,48,4.944]
[null,49,3.6960000000000002]
[null,50,4.4295999999999998]

{"sheet":"04|Fecuencia","index":3,"n_rows":23,"n_cols":23,"rows_kept":23,"cut":false,"hidden":false,"merged":[[6,16,6,22],[13,20,13,21],[14,20,14,21],[15,20,15,21],[1,10,1,15],[2,17,2,18],[1,1,1,8],[3,1,3,4],[4,1,4,4],[6,5,6,7],[6,11,6,13]]}
[]
[null,"OBSERVACIONES ALEATORIAS",null,null,null,null,null,null,null,null,"ESCALA DE TIEMPO TURNO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hora Desc."]
[null,"Hora",null,null,null,"06:00:00","06:30:00","07:00:00","07:30:00","08:00:00","08:30:00","09:00:00","09:30:00","10:00:00","10:30:00","11:00:00","11:30:00","12:00:00","12:30:00","01:00:00","01:30:00","02:00:00","02:30:00"]
[null,"Observacion",null,null,null,1,{"$f":"F5+1","v":2},{"$f":"G5+1","v":3},4,5,6,7,8,9,10,11,12,null,null,13,14,15,{"$f":"V5+1","v":16}]
[]
[null,"Hora","Obs","Hor","Min","Hora de la Obser.",null,null,null,null,null,"Hora de la Obser.",null,null,null,null,"CALCULO DE DIAS PARA OBSERVACIONES"]
[null,6,1,{"$f":"RANDBETWEEN(1,16)","v":14},{"$f":"RANDBETWEEN(1,9)/10","v":0.9},{"$f":"INDEX(B$8:D$23,MATCH(D8,C$8:C$23,0),1)","v":13},":",{"$f":"(E8*60)","v":54}]
[null,6,2,{"$f":"RANDBETWEEN(1,16)","v":11},{"$f":"RANDBETWEEN(1,9)/10","v":0.9},{"$f":"INDEX(B$8:D$23,MATCH(D9,C$8:C$23,0),1)","v":11},":",54,null,null,null,null,null,null,null,null,"MUESTREO:",null,null,null,84]
[null,7,3,4,0.6,7,":",36,null,null,null,null,null,null,null,null,"OBSERVACIONES:",null,null,null,{"$f":"COUNT(C8:C23)","v":16}]
[null,7,4,7,0.9,9,":",54,null,7,null,null,null,null,null,null,"DIAS:",null,null,null,{"$f":"ROUNDUP(U9/U10,)","v":6}]
[null,8,5,4,0.8,7,":",48,null,8]
[null,8,6,8,0.2,9,":",12,null,8]
[null,9,7,5,0.8,8,":",48,null,9,null,null,null,null,null,null,"ITERACIONES",null,null,null,5000,null,{"$f":"100%-W15","v":0.95660000000000001}]
[null,9,8,1,0.7,6,":",42,null,9,null,null,null,null,null,null,"SIMULACION",null,null,null,217,null,{"$f":"U15/U14","v":4.3400000000000001E-2}]
[null,10,9,6,0.7,8,":",42,null,10]
[null,10,10,5,0.7,8,":",42,null,10,null,null,null,null,null,null,{"$f":"W15*100","v":4.34},{"$f":"Q17-(100/7)","v":-9.9457142857142866},{"$f":"R17-(100/7)","v":-24.231428571428573},-38.517142857142858,-52.802857142857142,-67.088571428571427,-81.374285714285719]
[null,11,11,5,0.2,8,":",12,null,11]
[null,11,12,8,0.1,9,":",6,null,11]
[null,13,13,16,0.8,14,":",48,null,1]
[null,13,14,14,0.8,13,":",48,null,1]
[null,14,15,14,0.3,13,":",18,null,2]
[null,14,16,5,0.1,8,":",6,null,2]

{"sheet":"05|06|07|08|09|USP","index":4,"n_rows":41,"n_cols":10,"rows_kept":41,"cut":false,"hidden":false,"merged":[[37,3,39,3],[27,5,27,7],[28,9,29,9],[1,1,1,9],[27,1,27,3],[29,3,31,3],[33,3,35,3]]}
[]
[null,"Modelo para el calculo de la USP (Unidad Estándar de Producción)"]
[]
[null,"Elemento1.\nCorte","Tiempo Cronometro seg.","Valoración ritmo de trabajo","Tiempo Normaliz. Seg","% de Suplement.","Tiempo estándar seg","Tiempo Complem. Seg","USP Total seg","USP Total min"]
[null,"Ciclo 1",35.799999999999997,0.9,{"$f":"IFERROR((C5*D5),0)","v":32.22},{"$f":"$D$41","v":0.19000000000000003},{"$f":"E5*(1+F5)","v":38.341799999999999},0,{"$f":"(G5+H5)","v":38.341799999999999},{"$f":"IFERROR(I5/60,0)","v":0.63902999999999999}]
[null,"Ciclo 2",32.299999999999997,1.1499999999999999,{"$f":"IFERROR((C6*D6),0)","v":37.144999999999996},{"$f":"$D$41","v":0.19000000000000003},{"$f":"E6*(1+F6)","v":44.202549999999995},0,{"$f":"(G6+H6)","v":44.202549999999995},{"$f":"IFERROR(I6/60,0)","v":0.73670916666666664}]
[null,"Ciclo 3",34.5,1,{"$f":"IFERROR((C7*D7),0)","v":34.5},{"$f":"$D$41","v":0.19000000000000003},{"$f":"E7*(1+F7)","v":41.055},0,{"$f":"(G7+H7)","v":41.055},0.68425000000000002]
[]
[]
[null,null,{"$f":"IFERROR(AVERAGE(C5:C9),0)","v":34.199999999999996},null,{"$f":"IFERROR(AVERAGE(E5:E9),0)","v":34.621666666666663},null,{"$f":"IFERROR(AVERAGE(G5:G9),0)","v":41.199783333333329},null,{"$f":"IFERROR(AVERAGE(I5:I9),0)","v":41.199783333333329},{"$f":"IFERROR(AVERAGE(J5:J9),0)","v":0.68666305555555551}]
[]
[null,"Elemento2. Pulido","Tiempo Cronometro seg.","Valoración ritmo de trabajo","Tiempo Normaliz. Seg","% de Suplement.","Tiempo estándar seg","Tiempo Complem. Seg","USP Total seg","USP Total min"]
[null,"Ciclo 1",145,0.98,{"$f":"IFERROR((C13*D13),0)","v":142.1},{"$f":"$D$41","v":0.19000000000000003},{"$f":"E13*(1+F13)","v":169.09899999999999},0,{"$f":"(G13+H13)","v":169.09899999999999},{"$f":"IFERROR(I13/60,0)","v":2.8183166666666666}]
[null,"Ciclo 2",122,1.1499999999999999,{"$f":"IFERROR((C14*D14),0)","v":140.29999999999998},{"$f":"$D$41","v":0.19000000000000003},{"$f":"E14*(1+F14)","v":166.95699999999997},0,{"$f":"(G14+H14)","v":166.95699999999997},{"$f":"IFERROR(I14/60,0)","v":2.7826166666666663}]
[null,"Ciclo 3",140,1,{"$f":"IFERROR((C15*D15),0)","v":140},{"$f":"$D$41","v":0.19000000000000003},{"$f":"E15*(1+F15)","v":166.6},0,{"$f":"(G15+H15)","v":166.6},2.7766666666666664]
[]
[]
[null,null,{"$f":"IFERROR(AVERAGE(C13:C17),0)","v":135.66666666666666},null,{"$f":"IFERROR(AVERAGE(E13:E17),0)","v":140.79999999999998},null,{"$f":"IFERROR(AVERAGE(G13:G17),0)","v":167.55199999999999},null,{"$f":"IFERROR(AVERAGE(I13:I17),0)","v":167.55199999999999},{"$f":"IFERROR(AVERAGE(J13:J17),0)","v":2.7925333333333331}]
[]
[null,"Elemento3. Pintura","Tiempo Cronometro seg.","Valoración ritmo de trabajo","Tiempo Normaliz. Seg","% de Suplement.","Tiempo estándar seg","Tiempo Complem. Seg","USP Total seg","USP Total min"]
[null,"Ciclo 1",186,1.05,{"$f":"IFERROR((C21*D21),0)","v":195.3},{"$f":"$D$41","v":0.19000000000000003},{"$f":"E21*(1+F21)","v":232.40700000000001},{"$f":"120/10","v":12},{"$f":"(G21+H21)","v":244.40700000000001},{"$f":"I21/60","v":4.0734500000000002}]
[null,"Ciclo 2",195,1,{"$f":"IFERROR((C22*D22),0)","v":195},{"$f":"$D$41","v":0.19000000000000003},{"$f":"E22*(1+F22)","v":232.04999999999998},{"$f":"120/10","v":12},{"$f":"(G22+H22)","v":244.04999999999998},{"$f":"I22/60","v":4.0674999999999999}]
[null,"Ciclo 3",200,0.95,{"$f":"IFERROR((C23*D23),0)","v":190},{"$f":"$D$41","v":0.19000000000000003},{"$f":"E23*(1+F23)","v":226.1},12,{"$f":"(G23+H23)","v":238.1},{"$f":"I23/60","v":3.9683333333333333}]
[]
[]
[null,null,{"$f":"IFERROR(AVERAGE(C21:C25),0)","v":193.66666666666666},null,{"$f":"IFERROR(AVERAGE(E21:E25),0)","v":193.43333333333331},null,{"$f":"IFERROR(AVERAGE(G21:G25),0)","v":230.18566666666666},null,{"$f":"IFERROR(AVERAGE(I21:I25),0)","v":242.18566666666666},{"$f":"IFERROR(AVERAGE(J21:J25),0)","v":4.0364277777777779}]
[]
[null,"Calculo de tiempos suplementarios",null,null,null,"Resumen USP Total Minutos",null,null,null,"USP TOTAL"]
[null,"Por Fatiga Constantes",null,null,null,"Elemento","Tiempo/min","% Particip.",null,{"$f":"J10+J18+J26","v":7.515624166666667}]
[null,"Necesidad personal",7.0000000000000007E-2,{"$f":"SUM(C30:C32)","v":0.11000000000000001},null,1,{"$f":"J10","v":0.68666305555555551},{"$f":"G30/$J$29","v":9.1364741015263484E-2}]
[null,"Fatiga",0.04,null,null,2,{"$f":"J18","v":2.7925333333333331},{"$f":"G31/$J$29","v":0.37156372796271409}]
[null,null,null,null,null,3,{"$f":"J26","v":4.0364277777777779},0.53707153102202243]
[null,"Por Fatiga Variables",null,null,null,4]
[null,"Concentración",0.03,{"$f":"SUM(C34:C36)","v":0.05},null,5]
[null,"Estado de pie",0.02,null,null,6]
[null,null,null,null,null,7]
[null,"Suplementos por Contingencia",null,null,null,8]
[null,"Falta de M.P",0.01,{"$f":"SUM(C38:C40)","v":0.03},null,9]
[null,"Paro mecanico",0.02,null,null,10]
[null,null,null,null,null,11]
[null,"Suplementos Totales",null,{"$f":"D30+D34+D38","v":0.19000000000000003}]

{"sheet":"10|Eficiencia","index":5,"n_rows":21,"n_cols":5,"rows_kept":21,"cut":false,"hidden":false,"merged":[[1,1,1,4],[11,1,11,4]]}
[]
[null,"CALCULO DE EFICIENCIA OPERACIONAL"]
[]
[null,"TURNO DE TRABAJO HORAS:","06:00:00","16:00:00",{"$f":"(D4-C4)*24","v":10}]
[null,"TURNO DE TRABAJO MINUTOS:",null,null,{"$f":"E4*60","v":600}]
[null,"% DE EFICIENCIA:",null,null,0.96]
[null,"USP DEL PRODUCTO MINUTOS:",null,null,12.5]
[null,"UNIDADES TEORICAS O PROGRAMADAS:",null,null,{"$f":"E5*E6/E7","v":46.08}]
[null,"UNIDADES REALES PRODUCIDAS:",null,null,38]
[null,"EFICIENCIA OPERACIONAL",null,null,{"$f":"E9/E8","v":0.82465277777777779}]
[]
[null,"CALCULO DE LA CAPACIDAD DE PLANTA"]
[]
[null,"DIAS HABILES DEL MES",null,null,24]
[null,"CANTIDAD OPERARIOS MOD",null,null,15]
[null,"NUMERO DE TURNOS",null,null,1]
[null,"HORAS POR TURNO",null,null,10]
[null,"FACTOR DE MINUTOS",null,null,60]
[null,"USP DEL PRODUCTO MINUTOS",null,null,{"$f":"E7","v":12.5}]
[null,"CAPACIDAD DE PLANTA EN MINUTOS",null,null,{"$f":"E14*E15*E16*E17*E18","v":216000}]
[null,"CAPACIDAD DE PLANTA EN UNIDADES",null,null,{"$f":"E20/E19","v":17280}]

{"sheet":"11|Incentivos","index":6,"n_rows":36,"n_cols":6,"rows_kept":36,"cut":false,"hidden":false,"merged":[[1,1,1,5],[3,1,3,5],[15,2,15,5],[22,2,22,5],[30,2,30,5]]}
[]
[null,"CALCULO PAGO DE INCENTIVOS"]
[]
[null,"TABLA DE DATOS INICIALES"]
[null,"Turno de trabajo horas:",null,"14:00:00","22:00:00",{"$f":"(E5-D5)*24","v":7.9999999999999982}]
[null,"Turno en minutos:",null,null,null,{"$f":"F5*60","v":479.99999999999989}]
[null,"Salario mensual pagado:",null,null,null,877000]
[null,"Unidades reales producidas:",null,null,null,45]
[null,"USP del producto en minutos:",null,null,null,{"$f":"'10|Eficiencia'!E19","v":12.5}]
[]
[null,"Minutos exigibles",null,null,{"$f":"F6","v":479.99999999999989}]
[null,"Minutos reales",null,null,{"$f":"F8*F9","v":562.5}]
[null,"Unidades Teóricas",null,null,{"$f":"(F6/F9)","v":38.399999999999991}]
[null,"Diferencia de Unidades",null,null,{"$f":"F8-E13","v":6.6000000000000085}]
[]
[null,1,"POR PAGO A MINUTOS"]
[null,"Minutos a Incentivo",null,null,null,{"$f":"E12-F6","v":82.500000000000114}]
[null,"Valor del minuto",null,null,null,{"$f":"(F7/240)/60","v":60.902777777777779}]
[null,"Incentivo",null,null,null,{"$f":"F18*F17","v":5024.4791666666733}]
[null,"Salario día",null,null,null,{"$f":"F18*F6","v":29233.333333333328}]
[null,"Salario día + Incentivo",null,null,null,{"$f":"IF(E14<0,F20,F19+F20)","v":34257.8125}]
[]
[null,2,"EFICIENCIA DEL TRABAJADOR"]
[null,"Producción real",null,null,null,{"$f":"F8","v":45}]
[null,"Producción teórica exigible",null,null,null,{"$f":"E13","v":38.399999999999991}]
[null,"% de eficiencia en unidades",null,null,null,{"$f":"F24/F25","v":1.1718750000000002}]
[null,"Eficiencia en minutos Incentivo",null,null,null,{"$f":"(F24*F9)/F6","v":1.1718750000000002}]
[null,"Salario día",null,null,null,{"$f":"F20","v":29233.333333333328}]
[null,"Salario día + Incentivo",null,null,null,{"$f":"IF(E14<0,F28,F28*F27)","v":34257.8125}]
[]
[null,3,"POR UNIDAD"]
[null,"Valor de cada unidad",null,null,null,{"$f":"F20/E13","v":761.28472222222229}]
[null,"Unidades a incentivos",null,null,null,{"$f":"F8-E13","v":6.6000000000000085}]
[null,"Incentivos ",null,null,null,{"$f":"F33*F32","v":5024.4791666666733}]
[null,"Salario día",null,null,null,{"$f":"F20","v":29233.333333333328}]
[null,"Salario día + Incentivo",null,null,null,{"$f":"IF(E14<0,F35,F35+F34)","v":34257.8125}]