Entregable 2.4
Javier Ayala
2022-09-23
Librerias
library(data.table)
library(dplyr)
library(plyr)
library(ggplot2)
library(naniar)
library(Hmisc)
library(psych)
library(tidyverse)
library(janitor)
library(knitr)
library(pollster)
library(epiDisplay)
library(descr)Importar Bases de Datos
setwd("C:\\Users\\javaw\\OneDrive - Instituto Tecnologico y de Estudios Superiores de Monterrey\\7mo Semestre\\Reto")
#carton<-read.csv()
merma<-read.csv("FORM - Merma.csv")
scrap<-read.csv("FORM - Scrap.csv")
carton<-read.csv("FORM - Produccion Carton Mes.csv")1) ¿Cuántas variables y cuantos registros tiene la base de datos?
Producción de cartón
describe(carton)## vars n mean sd median trimmed mad min max range skew
## ï..* 1 51 26.00 14.87 26 26.00 19.27 1 51 50 0.00
## X* 2 51 5.24 2.16 5 5.15 2.97 1 9 8 0.34
## X.1* 3 51 22.39 13.72 22 22.29 17.79 1 46 45 0.04
## X.2* 4 51 26.00 14.87 26 26.00 19.27 1 51 50 0.00
## X.3* 5 51 10.49 6.77 8 10.00 7.41 1 24 23 0.47
## X.4* 6 51 3.53 2.59 2 3.17 1.48 1 11 10 0.93
## X.5* 7 51 11.49 9.55 11 10.83 14.83 1 29 28 0.32
## X.6* 8 51 7.63 4.60 8 7.56 7.41 1 14 13 0.08
## TIEMPO.DE.MAQUINAS* 9 51 10.04 8.53 9 9.17 10.38 1 28 27 0.58
## X.7* 10 51 7.55 7.24 2 6.56 1.48 1 24 23 0.84
## X.8* 11 51 7.88 7.94 2 6.73 1.48 1 26 25 0.94
## X.9* 12 51 11.92 10.58 9 10.90 10.38 1 33 32 0.54
## X.10* 13 51 11.92 10.58 9 10.90 10.38 1 33 32 0.54
## X.11* 14 51 2.69 0.91 3 2.66 0.00 1 6 5 0.80
## X.12* 15 51 1.16 0.42 1 1.05 0.00 1 3 2 2.60
## kurtosis se
## ï..* -1.27 2.08
## X* -1.05 0.30
## X.1* -1.28 1.92
## X.2* -1.27 2.08
## X.3* -1.15 0.95
## X.4* 0.16 0.36
## X.5* -1.39 1.34
## X.6* -1.61 0.64
## TIEMPO.DE.MAQUINAS* -1.04 1.19
## X.7* -0.77 1.01
## X.8* -0.62 1.11
## X.9* -1.20 1.48
## X.10* -1.20 1.48
## X.11* 2.58 0.13
## X.12* 6.36 0.06dim(carton)## [1] 51 15Merma
describe(merma)## vars n mean sd median trimmed mad min max range skew kurtosis
## ï..Fecha* 1 60 19.77 13.83 20.5 19.40 17.79 1 43 42 0.05 -1.34
## Mes* 2 60 6.25 4.56 5.0 5.60 4.45 1 19 18 1.05 0.44
## Kilos* 3 60 28.72 15.92 29.0 28.77 19.27 1 56 55 -0.03 -1.21
## se
## ï..Fecha* 1.79
## Mes* 0.59
## Kilos* 2.06dim(merma)## [1] 60 3Scrap
describe(scrap)## vars n mean sd median trimmed mad min max
## ï..Referencia* 1 251 126.00 72.60 126 126.00 93.40 1 251
## Fecha* 2 251 16.21 7.11 17 16.50 7.41 1 27
## Producto* 3 251 45.20 24.83 46 44.94 26.69 1 96
## Cantidad 4 251 13.34 105.90 2 3.95 1.48 0 1674
## Unidad.de.medida* 5 251 2.00 0.06 2 2.00 0.00 1 2
## Ubicación.de.origen* 6 251 3.47 0.86 4 3.60 0.00 1 4
## Ubicación.de.desecho* 7 251 2.00 0.06 2 2.00 0.00 1 2
## Estado* 8 251 2.00 0.06 2 2.00 0.00 1 2
## range skew kurtosis se
## ï..Referencia* 250 0.00 -1.21 4.58
## Fecha* 26 -0.29 -0.99 0.45
## Producto* 95 0.01 -0.80 1.57
## Cantidad 1674 15.37 237.90 6.68
## Unidad.de.medida* 1 -15.65 244.02 0.00
## Ubicación.de.origen* 3 -1.11 -0.62 0.05
## Ubicación.de.desecho* 1 -15.65 244.02 0.00
## Estado* 1 -15.65 244.02 0.00dim(scrap)## [1] 251 82) Aplica al menos 2 técnicas de limpieza de bases de datos y explícalas brevemente, ¿por qué realizaste esas técnicas?
Merma
Eliminar renglones de total La base de datos de merma posee filas para dividir el mes e indicar el total por mes. Hemos optado por eliminar estas filas para que la base este limpia. Adem
merma<-merma[- grep("Total", merma$Mes),]Cambiar tipo de variable Como podemos observar, el tipo de variable de varias columnas no es el correspondiente.
str(merma)## 'data.frame': 50 obs. of 3 variables:
## $ ï..Fecha: chr "11/01/2022" "11/01/2022" "22/01/2022" "22/01/2022" ...
## $ Mes : chr "ENERO" "ENERO" "ENERO" "ENERO" ...
## $ Kilos : chr "5080" "3810" "2990" "2680" ...merma2<-merma
merma2$Kilos<-as.numeric(merma2$Kilos)
str(merma2$Kilos)## num [1:50] 5080 3810 2990 2680 3650 4380 3870 3590 3410 3930 ...merma2$ï..Fecha<-as.POSIXct(merma2$ï..Fecha, format ="%d/%m/%Y")
str(merma2$ï..Fecha)## POSIXct[1:50], format: "2022-01-11" "2022-01-11" "2022-01-22" "2022-01-22" "2022-02-18" ...Scrap
Eliminar renglones del total En la base de datos de Scrap está la fila del mes de agosto con el total. Esta fila hay que eliminarla, al igual que como lo hicimos con la base de datos de Merma.
scrap<-scrap[- grep("agosto", scrap$ï..Referencia),]Cambiar tipo de variable Como podemos observar algunas variables tienen un tipo de variable incorrecto.
str(scrap)## 'data.frame': 250 obs. of 8 variables:
## $ ï..Referencia : chr "SP/08731" "SP/08730" "SP/08729" "SP/08728" ...
## $ Fecha : chr "31/08/2022" "31/08/2022" "31/08/2022" "31/08/2022" ...
## $ Producto : chr "[BACKFRAME 60% CUELLO ARMADO] 18805. 60% Backframe. Cuello Armado." "[N61506747 CAJA] N61506747. Kit. Caja." "[N61506729 SEPARADOR] N61506729. Kit. Separador." "[341332 DIVISOR - U611 & U625] 341332. U611. U625. Divisor Troquelado." ...
## $ Cantidad : num 2 1 1 31 1 1 1 9 2 1 ...
## $ Unidad.de.medida : chr "Unidad(es)" "Unidad(es)" "Unidad(es)" "Unidad(es)" ...
## $ Ubicación.de.origen : chr "SAB/Calidad/Entrega de PT" "SAB/Calidad/Entrega de PT" "SAB/Calidad/Entrega de PT" "SAB/Pre-Production" ...
## $ Ubicación.de.desecho: chr "Virtual Locations/Scrapped" "Virtual Locations/Scrapped" "Virtual Locations/Scrapped" "Virtual Locations/Scrapped" ...
## $ Estado : chr "Hecho" "Hecho" "Hecho" "Hecho" ...scrap2<-scrap
scrap2$Fecha<-as.POSIXct(scrap2$Fecha, format ="%d/%m/%Y")
str(scrap2$Fecha)## POSIXct[1:250], format: "2022-08-31" "2022-08-31" "2022-08-31" "2022-08-31" "2022-08-31" ...Eliminar columnas que no son necesarias
colnames(scrap2)## [1] "ï..Referencia" "Fecha" "Producto"
## [4] "Cantidad" "Unidad.de.medida" "Ubicación.de.origen"
## [7] "Ubicación.de.desecho" "Estado"scrap2<- dplyr::select(scrap2, -c(Unidad.de.medida,Estado))Producción de cartón
Convertir primera fila a nombres de columna La primera fila contiene los nombres de las columnas, por lo que es necesario hacer este cambio.
colnames(carton)<-carton[1,]
carton<-carton[-1,]Eliminar columnas vacías La columna de Tiempo Materiales está vacía, por lo que no es necesaria para el análisis y podemos eliminarla.
carton<-clean_names(carton)
carton<- dplyr::select(carton, -c(tiempo_materiales))Cambiar tipo de variable Como podemos observar algunas variables tienen un tipo de variable incorrecto.
str(carton)## 'data.frame': 50 obs. of 14 variables:
## $ no : chr "1" "2" "3" "4" ...
## $ cliente : chr "STABILUS 1" "HANON SYSTEMS" "HANON SYSTEMS" "VARROC" ...
## $ id_form : chr "" "" "" "VL-017-13928" ...
## $ producto : chr "STABOMAT 643920. CAJA IMP. CORTE. AZUL.PC0011. ( 2 Pza/Caja)." "CANOO CAJA EFP-051-19495 24" "CANOO TAPA EFP-051-19496 24" "729 KIT. CAJA HSC. ( 2 Partes)" ...
## $ piezas_prog : chr "100" "24" "24" "15" ...
## $ tmo_min : chr "15" "10" "10" "10" ...
## $ hr_fin : chr "8:15" "8:25" "8:35" "8:45" ...
## $ estacion_arranque : chr "C1" "C1Y2" "C1Y2" "C1Y2" ...
## $ laminas_procesadas : chr "2" "24" "24" "32" ...
## $ inicio_sep_up : chr "8:03" "8:33" "9:07" "9:30" ...
## $ fin_inicio_de_sep_up: chr "8:04" "8:35" "9:08" "9:32" ...
## $ inicio_de_proceso : chr "8:06" "8:39" "1:10" "9:35" ...
## $ fin_de_proceso : chr "8:33" "9:06" "9:30" "10.00" ...
## $ tiempo_calidad : chr "1" "1" "1" "1" ...carton2<-carton
carton2$no<-as.integer(carton2$no)
carton2$piezas_prog <-as.integer(carton2$piezas_prog)
carton2$tmo_min <-as.integer(carton2$tmo_min)
carton2$hr_fin<-as.POSIXct(carton2$hr_fin,format="%H:%M")
carton2$hr_fin <- as.ITime(carton2$hr_fin)
carton2$inicio_sep_up<-as.POSIXct(carton2$inicio_sep_up,format="%H:%M")
carton2$inicio_sep_up <- as.ITime(carton2$inicio_sep_up)
carton2$fin_inicio_de_sep_up<-as.POSIXct(carton2$fin_inicio_de_sep_up,format="%H:%M")
carton2$fin_inicio_de_sep_up <- as.ITime(carton2$fin_inicio_de_sep_up)
carton2$inicio_de_proceso<-as.POSIXct(carton2$inicio_de_proceso,format="%H:%M")
carton2$inicio_de_proceso <- as.ITime(carton2$inicio_de_proceso)
carton2$fin_de_proceso<-as.POSIXct(carton2$fin_de_proceso,format="%H:%M")
carton2$fin_de_proceso <- as.ITime(carton2$fin_de_proceso)
str(carton2)## 'data.frame': 50 obs. of 14 variables:
## $ no : int 1 2 3 4 5 6 7 8 9 10 ...
## $ cliente : chr "STABILUS 1" "HANON SYSTEMS" "HANON SYSTEMS" "VARROC" ...
## $ id_form : chr "" "" "" "VL-017-13928" ...
## $ producto : chr "STABOMAT 643920. CAJA IMP. CORTE. AZUL.PC0011. ( 2 Pza/Caja)." "CANOO CAJA EFP-051-19495 24" "CANOO TAPA EFP-051-19496 24" "729 KIT. CAJA HSC. ( 2 Partes)" ...
## $ piezas_prog : int 100 24 24 15 15 1 15 63 15 56 ...
## $ tmo_min : int 15 10 10 10 10 10 10 10 10 10 ...
## $ hr_fin : 'ITime' int 08:15:00 08:25:00 08:35:00 08:45:00 08:55:00 09:05:00 09:15:00 09:25:00 09:35:00 09:45:00 ...
## $ estacion_arranque : chr "C1" "C1Y2" "C1Y2" "C1Y2" ...
## $ laminas_procesadas : chr "2" "24" "24" "32" ...
## $ inicio_sep_up : 'ITime' int 08:03:00 08:33:00 09:07:00 09:30:00 NA NA NA NA 12:24:00 NA ...
## $ fin_inicio_de_sep_up: 'ITime' int 08:04:00 08:35:00 09:08:00 09:32:00 10:02:00 10:34:00 10:32:00 NA 12:26:00 NA ...
## $ inicio_de_proceso : 'ITime' int 08:06:00 08:39:00 01:10:00 09:35:00 NA NA 10:34:00 NA 12:27:00 NA ...
## $ fin_de_proceso : 'ITime' int 08:33:00 09:06:00 09:30:00 NA NA 10:41:00 11:00:00 NA 12:42:00 NA ...
## $ tiempo_calidad : chr "1" "1" "1" "1" ...3) y 4) Clasifica cada variable en cualitativa, cuantitativa discreta o cuantitativa continua y elige la escala de medición
Merma
Variable<-c("`Fecha`","`Mes`","`Kilos`")
Type<-c("Qualitative (nominal)", "Qualitative (nominal)", "Quantitative (discrete)")
table<-data.frame(Variable,Type)
knitr::kable(table)| Variable | Type |
|---|---|
Fecha |
Qualitative (nominal) |
Mes |
Qualitative (nominal) |
Kilos |
Quantitative (discrete) |
Scrap
Variable2<-c("`Referencia`","`Fecha`","`Producto`","`Cantidad`", "`Ubicación de origen`", "`Ubicación de Desecho`")
Type2<-c("Qualitative (nominal)", "Quantitative (discrete)", "Qualitative (nominal)","Quantitative (discrete)", "Qualitative (nominal)","Qualitative (nominal)")
table2<-data.frame(Variable2,Type2)
knitr::kable(table2)| Variable2 | Type2 |
|---|---|
Referencia |
Qualitative (nominal) |
Fecha |
Quantitative (discrete) |
Producto |
Qualitative (nominal) |
Cantidad |
Quantitative (discrete) |
Ubicación de origen |
Qualitative (nominal) |
Ubicación de Desecho |
Qualitative (nominal) |
Producción de cartón
Variable3<-c("`Cliente`","`ID Form`", "`Producto`","`Piezas programadas`", "`Tiempo minutos`", "`Hora fin`", "`Estacion arranque`", "`Laminas procesadas`", "`Inicio set up`", "`Fin inicio set up`", "`Inicio de proceso`", "`Fin de proceso`", "`Tiempo calidad`")
Type3<-c("Qualitative (nominal)","Qualitative (nominal)", "Qualitative (nominal)","Quantitative (discrete)", "Quantitative (discrete)", "Quantitative (continuous)", "Qualitative (nominal)", "Quantitative (discrete)", "Quantitative (continuous)", "Quantitative (continuous)", "Quantitative (continuous)", "Quantitative (continuous)", "Quantitative (discrete)" )
table3<-data.frame(Variable3,Type3)
knitr::kable(table3)| Variable3 | Type3 |
|---|---|
Cliente |
Qualitative (nominal) |
ID Form |
Qualitative (nominal) |
Producto |
Qualitative (nominal) |
Piezas programadas |
Quantitative (discrete) |
Tiempo minutos |
Quantitative (discrete) |
Hora fin |
Quantitative (continuous) |
Estacion arranque |
Qualitative (nominal) |
Laminas procesadas |
Quantitative (discrete) |
Inicio set up |
Quantitative (continuous) |
Fin inicio set up |
Quantitative (continuous) |
Inicio de proceso |
Quantitative (continuous) |
Fin de proceso |
Quantitative (continuous) |
Tiempo calidad |
Quantitative (discrete) |
5) Realizar un análisis estadístico descriptivo en el que logres destacar el conjunto de datos, que apoyan a la empresa a mejorar su operación.
Incorpora al menos dos propuestas concretas, apoyadas de tu análisis en donde se incluye al menos: (1) Tabla de frecuencia, (opcional) Tablas cruzadas, (2-3) Gráficos de datos cualitativos y cuantitativos, así como (2-3) Gráficos de dispersión.
Tablas de frecuencia
Scrap
ubicacion_origen <- scrap2 %>% group_by(Ubicación.de.origen) %>% tally()
ubicacion_origen## # A tibble: 3 x 2
## Ubicación.de.origen n
## <chr> <int>
## 1 SAB/Calidad/Entrega de PT 58
## 2 SAB/Post-Production 13
## 3 SAB/Pre-Production 179Merma
mes <- merma2 %>% group_by(Mes) %>% tally()
mes## # A tibble: 9 x 2
## Mes n
## <chr> <int>
## 1 ABRIL 5
## 2 AGOSTO 11
## 3 ENERO 4
## 4 FEBRERO 6
## 5 JULIO 5
## 6 JUNIO 4
## 7 MARZO 6
## 8 MAYO 5
## 9 SEPTIEMBRE 4Producción de cartón
cliente <- carton2 %>% group_by(cliente) %>% tally()
cliente## # A tibble: 8 x 2
## cliente n
## <chr> <int>
## 1 HANON SYSTEMS 2
## 2 MERIDIAN LIGHTWEIGHT 7
## 3 STABILUS 1 15
## 4 STABILUS 3 8
## 5 STABILUS 3. 1
## 6 TRMX 6
## 7 VARROC 6
## 8 YANFENG 5Tablas cruzadas
Producción de cartón
CrossTable(carton2$cliente,carton2$estacion_arranque)## Warning in chisq.test(tab, correct = FALSE, ...): Chi-squared approximation may
## be incorrect## Cell Contents
## |-------------------------|
## | N |
## | Chi-square contribution |
## | N / Row Total |
## | N / Col Total |
## | N / Table Total |
## |-------------------------|
##
## =====================================================================================================================================
## carton2$estacion_arranque
## crtn2$ C1 C1Y2 C3 C3. CAJAS CELDAS FLEXO RANURA ROTATI ROTATI SIERRA STABIL TROQUE Total
## -------------------------------------------------------------------------------------------------------------------------------------
## HANON 0 2 0 0 0 0 0 0 0 0 0 0 0 2
## 0.040 7.471 0.240 0.040 0.200 0.080 0.120 0.120 0.040 0.200 0.040 0.240 0.280
## 0.000 1.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.040
## 0.000 0.222 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000
## 0.00 0.04 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
## -------------------------------------------------------------------------------------------------------------------------------------
## MERIDI 0 4 3 0 0 0 0 0 0 0 0 0 0 7
## 0.140 5.958 5.554 0.140 0.700 0.280 0.420 0.420 0.140 0.700 0.140 0.840 0.980
## 0.000 0.571 0.429 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.140
## 0.000 0.444 0.500 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000
## 0.00 0.08 0.06 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
## -------------------------------------------------------------------------------------------------------------------------------------
## STABIL 1 0 0 0 2 0 3 1 0 3 0 4 1 15
## 1.633 2.700 1.800 0.300 0.167 0.600 4.900 0.011 0.300 1.500 0.300 2.689 0.576
## 0.067 0.000 0.000 0.000 0.133 0.000 0.200 0.067 0.000 0.200 0.000 0.267 0.067 0.300
## 1.000 0.000 0.000 0.000 0.400 0.000 1.000 0.333 0.000 0.600 0.000 0.667 0.143
## 0.02 0.00 0.00 0.00 0.04 0.00 0.06 0.02 0.00 0.06 0.00 0.08 0.02
## -------------------------------------------------------------------------------------------------------------------------------------
## STABIL 0 0 0 1 0 0 0 0 0 1 0 2 4 8
## 0.160 1.440 0.960 4.410 0.800 0.320 0.480 0.480 0.160 0.050 0.160 1.127 7.406
## 0.000 0.000 0.000 0.125 0.000 0.000 0.000 0.000 0.000 0.125 0.000 0.250 0.500 0.160
## 0.000 0.000 0.000 1.000 0.000 0.000 0.000 0.000 0.000 0.200 0.000 0.333 0.571
## 0.00 0.00 0.00 0.02 0.00 0.00 0.00 0.00 0.00 0.02 0.00 0.04 0.08
## -------------------------------------------------------------------------------------------------------------------------------------
## STABIL 0 0 0 0 0 0 0 0 0 1 0 0 0 1
## 0.020 0.180 0.120 0.020 0.100 0.040 0.060 0.060 0.020 8.100 0.020 0.120 0.140
## 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 1.000 0.000 0.000 0.000 0.020
## 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.200 0.000 0.000 0.000
## 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.02 0.00 0.00 0.00
## -------------------------------------------------------------------------------------------------------------------------------------
## TRMX 0 1 0 0 1 2 0 1 0 0 0 0 1 6
## 0.120 0.006 0.720 0.120 0.267 12.907 0.360 1.138 0.120 0.600 0.120 0.720 0.030
## 0.000 0.167 0.000 0.000 0.167 0.333 0.000 0.167 0.000 0.000 0.000 0.000 0.167 0.120
## 0.000 0.111 0.000 0.000 0.200 1.000 0.000 0.333 0.000 0.000 0.000 0.000 0.143
## 0.00 0.02 0.00 0.00 0.02 0.04 0.00 0.02 0.00 0.00 0.00 0.00 0.02
## -------------------------------------------------------------------------------------------------------------------------------------
## VARROC 0 2 3 0 0 0 0 0 0 0 0 0 1 6
## 0.120 0.784 7.220 0.120 0.600 0.240 0.360 0.360 0.120 0.600 0.120 0.720 0.030
## 0.000 0.333 0.500 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.167 0.120
## 0.000 0.222 0.500 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.143
## 0.00 0.04 0.06 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.02
## -------------------------------------------------------------------------------------------------------------------------------------
## YANFEN 0 0 0 0 2 0 0 1 1 0 1 0 0 5
## 0.100 0.900 0.600 0.100 4.500 0.200 0.300 1.633 8.100 0.500 8.100 0.600 0.700
## 0.000 0.000 0.000 0.000 0.400 0.000 0.000 0.200 0.200 0.000 0.200 0.000 0.000 0.100
## 0.000 0.000 0.000 0.000 0.400 0.000 0.000 0.333 1.000 0.000 1.000 0.000 0.000
## 0.00 0.00 0.00 0.00 0.04 0.00 0.00 0.02 0.02 0.00 0.02 0.00 0.00
## -------------------------------------------------------------------------------------------------------------------------------------
## Total 1 9 6 1 5 2 3 3 1 5 1 6 7 50
## 0.02 0.18 0.12 0.02 0.10 0.04 0.06 0.06 0.02 0.10 0.02 0.12 0.14
## =====================================================================================================================================Scrap
colnames(scrap2)## [1] "ï..Referencia" "Fecha" "Producto"
## [4] "Cantidad" "Ubicación.de.origen" "Ubicación.de.desecho"CrossTable(scrap2$ï..Referencia,scrap2$`Ubicación.de.origen`, prop.chisq=FALSE)## Cell Contents
## |-------------------------|
## | N |
## | N / Row Total |
## | N / Col Total |
## | N / Table Total |
## |-------------------------|
##
## ==============================================================================
## scrap2$Ubicación.de.origen
## scrap2$ï..Rfrnc SAB/Cldd/E d PT SAB/Post-Prdctn SAB/Pre-Prodctn Total
## ------------------------------------------------------------------------------
## SP/08479 1 0 0 1
## 1.000 0.000 0.000 0.004
## 0.017 0.000 0.000
## 0.004 0.000 0.000
## ------------------------------------------------------------------------------
## SP/08480 1 0 0 1
## 1.000 0.000 0.000 0.004
## 0.017 0.000 0.000
## 0.004 0.000 0.000
## ------------------------------------------------------------------------------
## SP/08481 0 1 0 1
## 0.000 1.000 0.000 0.004
## 0.000 0.077 0.000
## 0.000 0.004 0.000
## ------------------------------------------------------------------------------
## SP/08482 0 1 0 1
## 0.000 1.000 0.000 0.004
## 0.000 0.077 0.000
## 0.000 0.004 0.000
## ------------------------------------------------------------------------------
## SP/08483 1 0 0 1
## 1.000 0.000 0.000 0.004
## 0.017 0.000 0.000
## 0.004 0.000 0.000
## ------------------------------------------------------------------------------
## SP/08484 1 0 0 1
## 1.000 0.000 0.000 0.004
## 0.017 0.000 0.000
## 0.004 0.000 0.000
## ------------------------------------------------------------------------------
## SP/08485 1 0 0 1
## 1.000 0.000 0.000 0.004
## 0.017 0.000 0.000
## 0.004 0.000 0.000
## ------------------------------------------------------------------------------
## SP/08486 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08487 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08488 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08489 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08490 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08491 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08492 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08493 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08494 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08495 1 0 0 1
## 1.000 0.000 0.000 0.004
## 0.017 0.000 0.000
## 0.004 0.000 0.000
## ------------------------------------------------------------------------------
## SP/08496 1 0 0 1
## 1.000 0.000 0.000 0.004
## 0.017 0.000 0.000
## 0.004 0.000 0.000
## ------------------------------------------------------------------------------
## SP/08497 1 0 0 1
## 1.000 0.000 0.000 0.004
## 0.017 0.000 0.000
## 0.004 0.000 0.000
## ------------------------------------------------------------------------------
## SP/08498 1 0 0 1
## 1.000 0.000 0.000 0.004
## 0.017 0.000 0.000
## 0.004 0.000 0.000
## ------------------------------------------------------------------------------
## SP/08499 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08500 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08501 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08502 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08503 1 0 0 1
## 1.000 0.000 0.000 0.004
## 0.017 0.000 0.000
## 0.004 0.000 0.000
## ------------------------------------------------------------------------------
## SP/08504 1 0 0 1
## 1.000 0.000 0.000 0.004
## 0.017 0.000 0.000
## 0.004 0.000 0.000
## ------------------------------------------------------------------------------
## SP/08505 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08506 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08507 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08508 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08509 0 1 0 1
## 0.000 1.000 0.000 0.004
## 0.000 0.077 0.000
## 0.000 0.004 0.000
## ------------------------------------------------------------------------------
## SP/08510 1 0 0 1
## 1.000 0.000 0.000 0.004
## 0.017 0.000 0.000
## 0.004 0.000 0.000
## ------------------------------------------------------------------------------
## SP/08511 1 0 0 1
## 1.000 0.000 0.000 0.004
## 0.017 0.000 0.000
## 0.004 0.000 0.000
## ------------------------------------------------------------------------------
## SP/08512 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08513 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08514 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08515 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08516 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08517 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08518 1 0 0 1
## 1.000 0.000 0.000 0.004
## 0.017 0.000 0.000
## 0.004 0.000 0.000
## ------------------------------------------------------------------------------
## SP/08519 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08520 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08521 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08522 0 1 0 1
## 0.000 1.000 0.000 0.004
## 0.000 0.077 0.000
## 0.000 0.004 0.000
## ------------------------------------------------------------------------------
## SP/08523 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08524 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08525 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08526 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08527 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08528 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08529 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08530 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08531 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08532 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08533 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08534 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08535 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08536 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08537 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08538 0 1 0 1
## 0.000 1.000 0.000 0.004
## 0.000 0.077 0.000
## 0.000 0.004 0.000
## ------------------------------------------------------------------------------
## SP/08539 1 0 0 1
## 1.000 0.000 0.000 0.004
## 0.017 0.000 0.000
## 0.004 0.000 0.000
## ------------------------------------------------------------------------------
## SP/08540 1 0 0 1
## 1.000 0.000 0.000 0.004
## 0.017 0.000 0.000
## 0.004 0.000 0.000
## ------------------------------------------------------------------------------
## SP/08541 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08542 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08543 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08544 0 1 0 1
## 0.000 1.000 0.000 0.004
## 0.000 0.077 0.000
## 0.000 0.004 0.000
## ------------------------------------------------------------------------------
## SP/08545 1 0 0 1
## 1.000 0.000 0.000 0.004
## 0.017 0.000 0.000
## 0.004 0.000 0.000
## ------------------------------------------------------------------------------
## SP/08546 1 0 0 1
## 1.000 0.000 0.000 0.004
## 0.017 0.000 0.000
## 0.004 0.000 0.000
## ------------------------------------------------------------------------------
## SP/08547 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08548 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08549 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08550 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08551 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08552 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08553 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08554 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08555 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08556 1 0 0 1
## 1.000 0.000 0.000 0.004
## 0.017 0.000 0.000
## 0.004 0.000 0.000
## ------------------------------------------------------------------------------
## SP/08557 1 0 0 1
## 1.000 0.000 0.000 0.004
## 0.017 0.000 0.000
## 0.004 0.000 0.000
## ------------------------------------------------------------------------------
## SP/08558 1 0 0 1
## 1.000 0.000 0.000 0.004
## 0.017 0.000 0.000
## 0.004 0.000 0.000
## ------------------------------------------------------------------------------
## SP/08559 1 0 0 1
## 1.000 0.000 0.000 0.004
## 0.017 0.000 0.000
## 0.004 0.000 0.000
## ------------------------------------------------------------------------------
## SP/08560 1 0 0 1
## 1.000 0.000 0.000 0.004
## 0.017 0.000 0.000
## 0.004 0.000 0.000
## ------------------------------------------------------------------------------
## SP/08561 0 1 0 1
## 0.000 1.000 0.000 0.004
## 0.000 0.077 0.000
## 0.000 0.004 0.000
## ------------------------------------------------------------------------------
## SP/08563 0 1 0 1
## 0.000 1.000 0.000 0.004
## 0.000 0.077 0.000
## 0.000 0.004 0.000
## ------------------------------------------------------------------------------
## SP/08564 0 1 0 1
## 0.000 1.000 0.000 0.004
## 0.000 0.077 0.000
## 0.000 0.004 0.000
## ------------------------------------------------------------------------------
## SP/08565 0 1 0 1
## 0.000 1.000 0.000 0.004
## 0.000 0.077 0.000
## 0.000 0.004 0.000
## ------------------------------------------------------------------------------
## SP/08566 0 1 0 1
## 0.000 1.000 0.000 0.004
## 0.000 0.077 0.000
## 0.000 0.004 0.000
## ------------------------------------------------------------------------------
## SP/08567 1 0 0 1
## 1.000 0.000 0.000 0.004
## 0.017 0.000 0.000
## 0.004 0.000 0.000
## ------------------------------------------------------------------------------
## SP/08568 1 0 0 1
## 1.000 0.000 0.000 0.004
## 0.017 0.000 0.000
## 0.004 0.000 0.000
## ------------------------------------------------------------------------------
## SP/08569 1 0 0 1
## 1.000 0.000 0.000 0.004
## 0.017 0.000 0.000
## 0.004 0.000 0.000
## ------------------------------------------------------------------------------
## SP/08570 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08572 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08573 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08574 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08575 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08576 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08577 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08578 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08579 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08580 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08581 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08582 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08583 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08584 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08585 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08586 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08587 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08588 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08589 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08590 1 0 0 1
## 1.000 0.000 0.000 0.004
## 0.017 0.000 0.000
## 0.004 0.000 0.000
## ------------------------------------------------------------------------------
## SP/08591 1 0 0 1
## 1.000 0.000 0.000 0.004
## 0.017 0.000 0.000
## 0.004 0.000 0.000
## ------------------------------------------------------------------------------
## SP/08592 1 0 0 1
## 1.000 0.000 0.000 0.004
## 0.017 0.000 0.000
## 0.004 0.000 0.000
## ------------------------------------------------------------------------------
## SP/08593 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08594 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08595 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08596 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08597 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08598 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08599 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08600 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08601 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08602 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08603 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08604 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08605 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08606 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08607 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08608 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08609 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08610 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08611 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08612 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08613 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08614 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08615 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08616 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08617 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08618 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08619 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08620 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08621 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08622 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08623 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08624 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08625 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08626 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08627 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08628 0 1 0 1
## 0.000 1.000 0.000 0.004
## 0.000 0.077 0.000
## 0.000 0.004 0.000
## ------------------------------------------------------------------------------
## SP/08629 1 0 0 1
## 1.000 0.000 0.000 0.004
## 0.017 0.000 0.000
## 0.004 0.000 0.000
## ------------------------------------------------------------------------------
## SP/08631 1 0 0 1
## 1.000 0.000 0.000 0.004
## 0.017 0.000 0.000
## 0.004 0.000 0.000
## ------------------------------------------------------------------------------
## SP/08632 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08633 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08634 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08635 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08636 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08637 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08638 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08639 1 0 0 1
## 1.000 0.000 0.000 0.004
## 0.017 0.000 0.000
## 0.004 0.000 0.000
## ------------------------------------------------------------------------------
## SP/08640 0 1 0 1
## 0.000 1.000 0.000 0.004
## 0.000 0.077 0.000
## 0.000 0.004 0.000
## ------------------------------------------------------------------------------
## SP/08641 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08642 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08643 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08644 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08645 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08646 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08647 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08648 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08649 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08650 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08651 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08652 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08653 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08654 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08655 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08656 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08657 1 0 0 1
## 1.000 0.000 0.000 0.004
## 0.017 0.000 0.000
## 0.004 0.000 0.000
## ------------------------------------------------------------------------------
## SP/08658 1 0 0 1
## 1.000 0.000 0.000 0.004
## 0.017 0.000 0.000
## 0.004 0.000 0.000
## ------------------------------------------------------------------------------
## SP/08659 1 0 0 1
## 1.000 0.000 0.000 0.004
## 0.017 0.000 0.000
## 0.004 0.000 0.000
## ------------------------------------------------------------------------------
## SP/08660 1 0 0 1
## 1.000 0.000 0.000 0.004
## 0.017 0.000 0.000
## 0.004 0.000 0.000
## ------------------------------------------------------------------------------
## SP/08661 1 0 0 1
## 1.000 0.000 0.000 0.004
## 0.017 0.000 0.000
## 0.004 0.000 0.000
## ------------------------------------------------------------------------------
## SP/08662 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08663 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08664 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08665 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08666 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08667 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08668 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08669 1 0 0 1
## 1.000 0.000 0.000 0.004
## 0.017 0.000 0.000
## 0.004 0.000 0.000
## ------------------------------------------------------------------------------
## SP/08670 1 0 0 1
## 1.000 0.000 0.000 0.004
## 0.017 0.000 0.000
## 0.004 0.000 0.000
## ------------------------------------------------------------------------------
## SP/08671 1 0 0 1
## 1.000 0.000 0.000 0.004
## 0.017 0.000 0.000
## 0.004 0.000 0.000
## ------------------------------------------------------------------------------
## SP/08672 1 0 0 1
## 1.000 0.000 0.000 0.004
## 0.017 0.000 0.000
## 0.004 0.000 0.000
## ------------------------------------------------------------------------------
## SP/08673 1 0 0 1
## 1.000 0.000 0.000 0.004
## 0.017 0.000 0.000
## 0.004 0.000 0.000
## ------------------------------------------------------------------------------
## SP/08674 1 0 0 1
## 1.000 0.000 0.000 0.004
## 0.017 0.000 0.000
## 0.004 0.000 0.000
## ------------------------------------------------------------------------------
## SP/08675 1 0 0 1
## 1.000 0.000 0.000 0.004
## 0.017 0.000 0.000
## 0.004 0.000 0.000
## ------------------------------------------------------------------------------
## SP/08676 1 0 0 1
## 1.000 0.000 0.000 0.004
## 0.017 0.000 0.000
## 0.004 0.000 0.000
## ------------------------------------------------------------------------------
## SP/08677 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08678 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08679 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08680 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08681 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08682 1 0 0 1
## 1.000 0.000 0.000 0.004
## 0.017 0.000 0.000
## 0.004 0.000 0.000
## ------------------------------------------------------------------------------
## SP/08683 1 0 0 1
## 1.000 0.000 0.000 0.004
## 0.017 0.000 0.000
## 0.004 0.000 0.000
## ------------------------------------------------------------------------------
## SP/08684 1 0 0 1
## 1.000 0.000 0.000 0.004
## 0.017 0.000 0.000
## 0.004 0.000 0.000
## ------------------------------------------------------------------------------
## SP/08685 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08686 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08687 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08688 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08689 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08690 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08691 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08692 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08693 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08694 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08695 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08696 1 0 0 1
## 1.000 0.000 0.000 0.004
## 0.017 0.000 0.000
## 0.004 0.000 0.000
## ------------------------------------------------------------------------------
## SP/08697 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08698 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08699 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08700 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08701 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08702 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08703 1 0 0 1
## 1.000 0.000 0.000 0.004
## 0.017 0.000 0.000
## 0.004 0.000 0.000
## ------------------------------------------------------------------------------
## SP/08704 1 0 0 1
## 1.000 0.000 0.000 0.004
## 0.017 0.000 0.000
## 0.004 0.000 0.000
## ------------------------------------------------------------------------------
## SP/08705 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08706 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08707 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08708 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08709 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08710 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08711 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08712 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08713 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08714 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08715 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08716 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08717 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08718 1 0 0 1
## 1.000 0.000 0.000 0.004
## 0.017 0.000 0.000
## 0.004 0.000 0.000
## ------------------------------------------------------------------------------
## SP/08719 1 0 0 1
## 1.000 0.000 0.000 0.004
## 0.017 0.000 0.000
## 0.004 0.000 0.000
## ------------------------------------------------------------------------------
## SP/08720 1 0 0 1
## 1.000 0.000 0.000 0.004
## 0.017 0.000 0.000
## 0.004 0.000 0.000
## ------------------------------------------------------------------------------
## SP/08721 1 0 0 1
## 1.000 0.000 0.000 0.004
## 0.017 0.000 0.000
## 0.004 0.000 0.000
## ------------------------------------------------------------------------------
## SP/08722 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08723 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08724 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08725 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08726 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08727 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08728 0 0 1 1
## 0.000 0.000 1.000 0.004
## 0.000 0.000 0.006
## 0.000 0.000 0.004
## ------------------------------------------------------------------------------
## SP/08729 1 0 0 1
## 1.000 0.000 0.000 0.004
## 0.017 0.000 0.000
## 0.004 0.000 0.000
## ------------------------------------------------------------------------------
## SP/08730 1 0 0 1
## 1.000 0.000 0.000 0.004
## 0.017 0.000 0.000
## 0.004 0.000 0.000
## ------------------------------------------------------------------------------
## SP/08731 1 0 0 1
## 1.000 0.000 0.000 0.004
## 0.017 0.000 0.000
## 0.004 0.000 0.000
## ------------------------------------------------------------------------------
## Total 58 13 179 250
## 0.232 0.052 0.716
## ==============================================================================CrossTable(scrap2$`Ubicación.de.desecho`,scrap2$`Ubicación.de.origen`, prop.chisq=FALSE)## Cell Contents
## |-------------------------|
## | N |
## | N / Table Total |
## |-------------------------|
##
## ==============================================================================
## scrap2$Ubicación.de.origen
## scrp2$Ubccón.. SAB/Cldd/E d PT SAB/Post-Prdctn SAB/Pre-Prodctn Total
## ------------------------------------------------------------------------------
## Vrtl Lctns/Scrp 58 13 179 250
## 0.232 0.052 0.716
## ------------------------------------------------------------------------------
## Total 58 13 179 250
## ==============================================================================Gráficos de datos cualitativos y cuantitativos
Scrap En esta ocasión queremos saber en que día del mes de agosto hubo mayor cantidad de scrap y graficarlo.
scrap_fecha<-aggregate(Cantidad ~ Fecha, data = scrap2, sum)
scrap_fecha## Fecha Cantidad
## 1 2022-08-01 2.0
## 2 2022-08-02 18.0
## 3 2022-08-03 56.0
## 4 2022-08-04 8.0
## 5 2022-08-05 67.0
## 6 2022-08-06 82.0
## 7 2022-08-08 14.0
## 8 2022-08-09 15.0
## 9 2022-08-10 65.0
## 10 2022-08-11 17.0
## 11 2022-08-12 155.0
## 12 2022-08-13 24.0
## 13 2022-08-15 9.0
## 14 2022-08-16 168.0
## 15 2022-08-17 46.0
## 16 2022-08-19 129.0
## 17 2022-08-20 156.0
## 18 2022-08-22 78.0
## 19 2022-08-23 1.0
## 20 2022-08-24 191.0
## 21 2022-08-25 88.0
## 22 2022-08-26 25.5
## 23 2022-08-27 41.0
## 24 2022-08-29 102.5
## 25 2022-08-30 66.0
## 26 2022-08-31 50.0ggplot(scrap_fecha,aes(x=Fecha,y=Cantidad))+
geom_point()+
labs(title="Cantidad por día")
Merma Para gráficar el total de kilos de merma por mes primero es necesario obtener la cantidad total de kilos por mes, eso lo hacemos de la siguiente manera.
merma_mes<-aggregate(Kilos ~ Mes, data = merma2, sum)
merma_mes## Mes Kilos
## 1 ABRIL 18820
## 2 AGOSTO 32100
## 3 ENERO 14560
## 4 FEBRERO 22830
## 5 JULIO 19370
## 6 JUNIO 18280
## 7 MARZO 22470
## 8 MAYO 23410
## 9 SEPTIEMBRE 13586Una vez que ya tenemos el total por mes podemos graficarlo.
ggplot(merma_mes,aes(x=Mes,y=Kilos, fill=Kilos))+
geom_bar(stat="identity")+
theme_minimal()+
labs(title="Kilos de merma por mes")
Producción de cartón Para la producción de cartón vamos a graficar el tiempo en minutos que tomó el proceso. Para esto necesitamos restar el tiempo de inicio de proceso al de fin de proceso.
carton2<-mutate(carton2, tiempo_proceso = difftime(carton2$fin_de_proceso,carton2$inicio_de_proceso, units = "mins"))Asi mismo, vamos a sacar el promedio de tiempo que toma el proceso por cliente. De esta forma podremos saber cual cliente consume mas tiempo de produccion de Form en el mes de agosto.
prod_cliente<-aggregate(tiempo_proceso ~ cliente, data=carton2, mean)
prod_cliente## cliente tiempo_proceso
## 1 HANON SYSTEMS 263.50 mins
## 2 MERIDIAN LIGHTWEIGHT 32.20 mins
## 3 STABILUS 1 21.25 mins
## 4 STABILUS 3 15.20 mins
## 5 STABILUS 3. 15.00 mins
## 6 TRMX 17.50 mins
## 7 VARROC 30.00 mins
## 8 YANFENG 35.00 minsggplot(prod_cliente,aes(x=cliente,y=tiempo_proceso))+
geom_point()+
labs(title="Tiempo promedio por cliente")+ theme(axis.text.x = element_text(angle=90, hjust=1))## Don't know how to automatically pick scale for object of type difftime. Defaulting to continuous.
Gráficos de dispersión
Scrap
ggplot(scrap2, aes(x = Ubicación.de.origen, y = Cantidad)) +
geom_boxplot()
Merma
ggplot(merma2, aes(x = Mes, y = Kilos)) +
geom_boxplot()
Producción de carton
ggplot(carton2, aes(x = cliente, y = piezas_prog)) +
geom_boxplot()+theme(axis.text.x = element_text(angle=90, hjust=1))
6) Incluye una breve reflexión de la actividad.
Me parece de gran valor analizar las bases de datos de merma, scrap y producción de Form, ya que podemos analizar y transformar la información disponible con tal de interpretarla y obtener conclusiones de valor que ayuden a la toma de decisiones.
LS0tDQp0aXRsZTogIkVudHJlZ2FibGUgMi40Ig0KYXV0aG9yOiAiSmF2aWVyIEF5YWxhIg0KZGF0ZTogJzIwMjItMDktMjMnDQpvdXRwdXQ6DQogIGh0bWxfZG9jdW1lbnQ6DQogICAgdG9jOiB0cnVlDQogICAgdG9jX2Zsb2F0OiB0cnVlDQogICAgY29kZV9kb3dubG9hZDogdHJ1ZQ0KLS0tDQo8Y2VudGVyPg0KPGltZyBzcmM9IkM6Ly9Vc2Vycy8vamF2YXcvL09uZURyaXZlIC0gSW5zdGl0dXRvIFRlY25vbG9naWNvIHkgZGUgRXN0dWRpb3MgU3VwZXJpb3JlcyBkZSBNb250ZXJyZXkvL0xvZ28gSVRFU00gc21hbGwucG5nIj4NCjwvY2VudGVyPiANCg0KDQpgYGB7Y3NzLCBlY2hvPUZBTFNFfQ0KaDEsIGg0IHsNCiAgdGV4dC1hbGlnbjogY2VudGVyOw0KfQ0KDQpoMSwgaDIsIGgzIHsNCiAgY29sb3I6ICMwNjFGNkI7DQp9DQpgYGANCg0KIyMgTGlicmVyaWFzDQpgYGB7ciBtZXNzYWdlPUZBTFNFLCB3YXJuaW5nPUZBTFNFfQ0KDQpsaWJyYXJ5KGRhdGEudGFibGUpDQpsaWJyYXJ5KGRwbHlyKQ0KbGlicmFyeShwbHlyKQ0KbGlicmFyeShnZ3Bsb3QyKQ0KbGlicmFyeShuYW5pYXIpDQpsaWJyYXJ5KEhtaXNjKSAgICAgICAgIA0KbGlicmFyeShwc3ljaCkNCmxpYnJhcnkodGlkeXZlcnNlKQ0KbGlicmFyeShqYW5pdG9yKQ0KbGlicmFyeShrbml0cikNCmxpYnJhcnkocG9sbHN0ZXIpDQpsaWJyYXJ5KGVwaURpc3BsYXkpDQpsaWJyYXJ5KGRlc2NyKQ0KYGBgDQoNCiMjIEltcG9ydGFyIEJhc2VzIGRlIERhdG9zIA0KYGBge3J9DQpzZXR3ZCgiQzpcXFVzZXJzXFxqYXZhd1xcT25lRHJpdmUgLSBJbnN0aXR1dG8gVGVjbm9sb2dpY28geSBkZSBFc3R1ZGlvcyBTdXBlcmlvcmVzIGRlIE1vbnRlcnJleVxcN21vIFNlbWVzdHJlXFxSZXRvIikNCiNjYXJ0b248LXJlYWQuY3N2KCkNCm1lcm1hPC1yZWFkLmNzdigiRk9STSAtIE1lcm1hLmNzdiIpDQpzY3JhcDwtcmVhZC5jc3YoIkZPUk0gLSBTY3JhcC5jc3YiKQ0KY2FydG9uPC1yZWFkLmNzdigiRk9STSAtIFByb2R1Y2Npb24gQ2FydG9uIE1lcy5jc3YiKQ0KYGBgDQoNCg0KIyMgMSkgwr9DdcOhbnRhcyB2YXJpYWJsZXMgeSBjdWFudG9zIHJlZ2lzdHJvcyB0aWVuZSBsYSBiYXNlIGRlIGRhdG9zPw0KIyMjIFByb2R1Y2Npw7NuIGRlIGNhcnTDs24NCmBgYHtyfQ0KZGVzY3JpYmUoY2FydG9uKQ0KYGBgDQoNCmBgYHtyfQ0KZGltKGNhcnRvbikNCmBgYA0KDQoNCg0KIyMjIE1lcm1hICANCmBgYHtyfQ0KZGVzY3JpYmUobWVybWEpDQpgYGANCmBgYHtyfQ0KZGltKG1lcm1hKQ0KYGBgDQoNCg0KIyMjIFNjcmFwDQpgYGB7cn0NCmRlc2NyaWJlKHNjcmFwKQ0KYGBgDQpgYGB7cn0NCmRpbShzY3JhcCkNCmBgYA0KDQoNCiMjIDIpIEFwbGljYSBhbCBtZW5vcyAyIHTDqWNuaWNhcyBkZSBsaW1waWV6YSBkZSBiYXNlcyBkZSBkYXRvcyB5IGV4cGzDrWNhbGFzIGJyZXZlbWVudGUsIMK/cG9yIHF1w6kgcmVhbGl6YXN0ZSBlc2FzIHTDqWNuaWNhcz8NCg0KIyMjIE1lcm1hDQoqKkVsaW1pbmFyIHJlbmdsb25lcyBkZSB0b3RhbCoqDQpMYSBiYXNlIGRlIGRhdG9zIGRlIG1lcm1hIHBvc2VlIGZpbGFzIHBhcmEgZGl2aWRpciBlbCBtZXMgZSBpbmRpY2FyIGVsIHRvdGFsIHBvciBtZXMuIEhlbW9zIG9wdGFkbyBwb3IgZWxpbWluYXIgZXN0YXMgZmlsYXMgcGFyYSBxdWUgbGEgYmFzZSBlc3RlIGxpbXBpYS4gQWRlbQ0KYGBge3J9DQptZXJtYTwtbWVybWFbLSBncmVwKCJUb3RhbCIsIG1lcm1hJE1lcyksXQ0KYGBgDQoNCg0KKipDYW1iaWFyIHRpcG8gZGUgdmFyaWFibGUqKg0KQ29tbyBwb2RlbW9zIG9ic2VydmFyLCBlbCB0aXBvIGRlIHZhcmlhYmxlIGRlIHZhcmlhcyBjb2x1bW5hcyBubyBlcyBlbCBjb3JyZXNwb25kaWVudGUuIA0KYGBge3J9DQpzdHIobWVybWEpDQpgYGANCg0KYGBge3J9DQptZXJtYTI8LW1lcm1hDQptZXJtYTIkS2lsb3M8LWFzLm51bWVyaWMobWVybWEyJEtpbG9zKQ0Kc3RyKG1lcm1hMiRLaWxvcykNCmBgYA0KDQpgYGB7cn0NCm1lcm1hMiTDry4uRmVjaGE8LWFzLlBPU0lYY3QobWVybWEyJMOvLi5GZWNoYSwgZm9ybWF0ID0iJWQvJW0vJVkiKQ0Kc3RyKG1lcm1hMiTDry4uRmVjaGEpDQpgYGANCg0KDQojIyMgU2NyYXAgIA0KDQoqKkVsaW1pbmFyIHJlbmdsb25lcyBkZWwgdG90YWwqKg0KRW4gbGEgYmFzZSBkZSBkYXRvcyBkZSAqKlNjcmFwKiogZXN0w6EgbGEgZmlsYSBkZWwgbWVzIGRlIGFnb3N0byBjb24gZWwgdG90YWwuIEVzdGEgZmlsYSBoYXkgcXVlIGVsaW1pbmFybGEsIGFsIGlndWFsIHF1ZSBjb21vIGxvIGhpY2ltb3MgY29uIGxhIGJhc2UgZGUgZGF0b3MgZGUgKipNZXJtYSoqLg0KYGBge3J9DQpzY3JhcDwtc2NyYXBbLSBncmVwKCJhZ29zdG8iLCBzY3JhcCTDry4uUmVmZXJlbmNpYSksXQ0KYGBgDQoNCg0KKipDYW1iaWFyIHRpcG8gZGUgdmFyaWFibGUqKg0KQ29tbyBwb2RlbW9zIG9ic2VydmFyIGFsZ3VuYXMgdmFyaWFibGVzIHRpZW5lbiB1biB0aXBvIGRlIHZhcmlhYmxlIGluY29ycmVjdG8uDQpgYGB7cn0NCnN0cihzY3JhcCkNCmBgYA0KDQpgYGB7cn0NCnNjcmFwMjwtc2NyYXANCnNjcmFwMiRGZWNoYTwtYXMuUE9TSVhjdChzY3JhcDIkRmVjaGEsIGZvcm1hdCA9IiVkLyVtLyVZIikNCnN0cihzY3JhcDIkRmVjaGEpDQpgYGANCg0KKipFbGltaW5hciBjb2x1bW5hcyBxdWUgbm8gc29uIG5lY2VzYXJpYXMqKg0KYGBge3J9DQpjb2xuYW1lcyhzY3JhcDIpDQpzY3JhcDI8LSBkcGx5cjo6c2VsZWN0KHNjcmFwMiwgLWMoVW5pZGFkLmRlLm1lZGlkYSxFc3RhZG8pKQ0KYGBgDQojIyMgUHJvZHVjY2nDs24gZGUgY2FydMOzbiAgDQoNCioqQ29udmVydGlyIHByaW1lcmEgZmlsYSBhIG5vbWJyZXMgZGUgY29sdW1uYSoqDQpMYSBwcmltZXJhIGZpbGEgY29udGllbmUgbG9zIG5vbWJyZXMgZGUgbGFzIGNvbHVtbmFzLCBwb3IgbG8gcXVlIGVzIG5lY2VzYXJpbyBoYWNlciBlc3RlIGNhbWJpby4NCmBgYHtyfQ0KY29sbmFtZXMoY2FydG9uKTwtY2FydG9uWzEsXQ0KY2FydG9uPC1jYXJ0b25bLTEsXQ0KYGBgDQoNCioqRWxpbWluYXIgY29sdW1uYXMgdmFjw61hcyoqDQpMYSBjb2x1bW5hIGRlIFRpZW1wbyBNYXRlcmlhbGVzIGVzdMOhIHZhY8OtYSwgcG9yIGxvIHF1ZSBubyBlcyBuZWNlc2FyaWEgcGFyYSBlbCBhbsOhbGlzaXMgeSBwb2RlbW9zIGVsaW1pbmFybGEuIA0KYGBge3J9DQpjYXJ0b248LWNsZWFuX25hbWVzKGNhcnRvbikNCmNhcnRvbjwtIGRwbHlyOjpzZWxlY3QoY2FydG9uLCAtYyh0aWVtcG9fbWF0ZXJpYWxlcykpDQpgYGANCg0KDQoqKkNhbWJpYXIgdGlwbyBkZSB2YXJpYWJsZSoqDQpDb21vIHBvZGVtb3Mgb2JzZXJ2YXIgYWxndW5hcyB2YXJpYWJsZXMgdGllbmVuIHVuIHRpcG8gZGUgdmFyaWFibGUgaW5jb3JyZWN0by4NCmBgYHtyfQ0Kc3RyKGNhcnRvbikNCmBgYA0KDQpgYGB7cn0NCmNhcnRvbjI8LWNhcnRvbg0KY2FydG9uMiRubzwtYXMuaW50ZWdlcihjYXJ0b24yJG5vKQ0KY2FydG9uMiRwaWV6YXNfcHJvZyA8LWFzLmludGVnZXIoY2FydG9uMiRwaWV6YXNfcHJvZykNCmNhcnRvbjIkdG1vX21pbiA8LWFzLmludGVnZXIoY2FydG9uMiR0bW9fbWluKQ0KDQpjYXJ0b24yJGhyX2ZpbjwtYXMuUE9TSVhjdChjYXJ0b24yJGhyX2Zpbixmb3JtYXQ9IiVIOiVNIikNCmNhcnRvbjIkaHJfZmluIDwtIGFzLklUaW1lKGNhcnRvbjIkaHJfZmluKQ0KDQpjYXJ0b24yJGluaWNpb19zZXBfdXA8LWFzLlBPU0lYY3QoY2FydG9uMiRpbmljaW9fc2VwX3VwLGZvcm1hdD0iJUg6JU0iKQ0KY2FydG9uMiRpbmljaW9fc2VwX3VwIDwtIGFzLklUaW1lKGNhcnRvbjIkaW5pY2lvX3NlcF91cCkNCg0KY2FydG9uMiRmaW5faW5pY2lvX2RlX3NlcF91cDwtYXMuUE9TSVhjdChjYXJ0b24yJGZpbl9pbmljaW9fZGVfc2VwX3VwLGZvcm1hdD0iJUg6JU0iKQ0KY2FydG9uMiRmaW5faW5pY2lvX2RlX3NlcF91cCA8LSBhcy5JVGltZShjYXJ0b24yJGZpbl9pbmljaW9fZGVfc2VwX3VwKQ0KDQpjYXJ0b24yJGluaWNpb19kZV9wcm9jZXNvPC1hcy5QT1NJWGN0KGNhcnRvbjIkaW5pY2lvX2RlX3Byb2Nlc28sZm9ybWF0PSIlSDolTSIpDQpjYXJ0b24yJGluaWNpb19kZV9wcm9jZXNvIDwtIGFzLklUaW1lKGNhcnRvbjIkaW5pY2lvX2RlX3Byb2Nlc28pDQoNCmNhcnRvbjIkZmluX2RlX3Byb2Nlc288LWFzLlBPU0lYY3QoY2FydG9uMiRmaW5fZGVfcHJvY2Vzbyxmb3JtYXQ9IiVIOiVNIikNCmNhcnRvbjIkZmluX2RlX3Byb2Nlc28gPC0gYXMuSVRpbWUoY2FydG9uMiRmaW5fZGVfcHJvY2VzbykNCg0Kc3RyKGNhcnRvbjIpDQpgYGANCg0KIyMgMykgeSA0KSBDbGFzaWZpY2EgY2FkYSB2YXJpYWJsZSBlbiBjdWFsaXRhdGl2YSwgY3VhbnRpdGF0aXZhIGRpc2NyZXRhIG8gY3VhbnRpdGF0aXZhIGNvbnRpbnVhIHkgZWxpZ2UgbGEgZXNjYWxhIGRlIG1lZGljacOzbg0KDQojIyMgTWVybWENCmBgYHtyfQ0KVmFyaWFibGU8LWMoImBGZWNoYWAiLCJgTWVzYCIsImBLaWxvc2AiKQ0KDQpUeXBlPC1jKCJRdWFsaXRhdGl2ZSAobm9taW5hbCkiLCAiUXVhbGl0YXRpdmUgKG5vbWluYWwpIiwgIlF1YW50aXRhdGl2ZSAoZGlzY3JldGUpIikNCg0KdGFibGU8LWRhdGEuZnJhbWUoVmFyaWFibGUsVHlwZSkNCmtuaXRyOjprYWJsZSh0YWJsZSkNCmBgYA0KDQoNCiMjIyBTY3JhcA0KYGBge3J9DQpWYXJpYWJsZTI8LWMoImBSZWZlcmVuY2lhYCIsImBGZWNoYWAiLCJgUHJvZHVjdG9gIiwiYENhbnRpZGFkYCIsICJgVWJpY2FjacOzbiBkZSBvcmlnZW5gIiwgImBVYmljYWNpw7NuIGRlIERlc2VjaG9gIikNCg0KVHlwZTI8LWMoIlF1YWxpdGF0aXZlIChub21pbmFsKSIsICJRdWFudGl0YXRpdmUgKGRpc2NyZXRlKSIsICJRdWFsaXRhdGl2ZSAobm9taW5hbCkiLCJRdWFudGl0YXRpdmUgKGRpc2NyZXRlKSIsICJRdWFsaXRhdGl2ZSAobm9taW5hbCkiLCJRdWFsaXRhdGl2ZSAobm9taW5hbCkiKQ0KDQp0YWJsZTI8LWRhdGEuZnJhbWUoVmFyaWFibGUyLFR5cGUyKQ0Ka25pdHI6OmthYmxlKHRhYmxlMikNCmBgYA0KDQoNCiMjIyBQcm9kdWNjacOzbiBkZSBjYXJ0w7NuDQoNCmBgYHtyfQ0KVmFyaWFibGUzPC1jKCJgQ2xpZW50ZWAiLCJgSUQgRm9ybWAiLCAiYFByb2R1Y3RvYCIsImBQaWV6YXMgcHJvZ3JhbWFkYXNgIiwgImBUaWVtcG8gbWludXRvc2AiLCAiYEhvcmEgZmluYCIsICJgRXN0YWNpb24gYXJyYW5xdWVgIiwgImBMYW1pbmFzIHByb2Nlc2FkYXNgIiwgImBJbmljaW8gc2V0IHVwYCIsICJgRmluIGluaWNpbyBzZXQgdXBgIiwgImBJbmljaW8gZGUgcHJvY2Vzb2AiLCAiYEZpbiBkZSBwcm9jZXNvYCIsICJgVGllbXBvIGNhbGlkYWRgIikNClR5cGUzPC1jKCJRdWFsaXRhdGl2ZSAobm9taW5hbCkiLCJRdWFsaXRhdGl2ZSAobm9taW5hbCkiLCAiUXVhbGl0YXRpdmUgKG5vbWluYWwpIiwiUXVhbnRpdGF0aXZlIChkaXNjcmV0ZSkiLCAiUXVhbnRpdGF0aXZlIChkaXNjcmV0ZSkiLCAiUXVhbnRpdGF0aXZlIChjb250aW51b3VzKSIsICJRdWFsaXRhdGl2ZSAobm9taW5hbCkiLCAiUXVhbnRpdGF0aXZlIChkaXNjcmV0ZSkiLCAiUXVhbnRpdGF0aXZlIChjb250aW51b3VzKSIsICJRdWFudGl0YXRpdmUgKGNvbnRpbnVvdXMpIiwgIlF1YW50aXRhdGl2ZSAoY29udGludW91cykiLCAiUXVhbnRpdGF0aXZlIChjb250aW51b3VzKSIsICJRdWFudGl0YXRpdmUgKGRpc2NyZXRlKSIgKQ0KDQp0YWJsZTM8LWRhdGEuZnJhbWUoVmFyaWFibGUzLFR5cGUzKQ0Ka25pdHI6OmthYmxlKHRhYmxlMykNCmBgYA0KDQoNCiMjIDUpIFJlYWxpemFyIHVuIGFuw6FsaXNpcyBlc3RhZMOtc3RpY28gZGVzY3JpcHRpdm8gZW4gZWwgcXVlIGxvZ3JlcyBkZXN0YWNhciBlbCBjb25qdW50byBkZSBkYXRvcywgcXVlIGFwb3lhbiBhIGxhIGVtcHJlc2EgYSBtZWpvcmFyIHN1IG9wZXJhY2nDs24uIA0KDQpJbmNvcnBvcmEgYWwgbWVub3MgZG9zIHByb3B1ZXN0YXMgY29uY3JldGFzLCBhcG95YWRhcyBkZSB0dSBhbsOhbGlzaXMgZW4gZG9uZGUgc2UgaW5jbHV5ZSBhbCBtZW5vczogKDEpIFRhYmxhIGRlIGZyZWN1ZW5jaWEsIChvcGNpb25hbCkgVGFibGFzIGNydXphZGFzLCAoMi0zKSBHcsOhZmljb3MgZGUgZGF0b3MgY3VhbGl0YXRpdm9zIHkgY3VhbnRpdGF0aXZvcywgYXPDrSBjb21vICgyLTMpIEdyw6FmaWNvcyBkZSBkaXNwZXJzacOzbi4NCg0KDQojIyMgVGFibGFzIGRlIGZyZWN1ZW5jaWENCg0KKipTY3JhcCoqDQpgYGB7cn0NCnViaWNhY2lvbl9vcmlnZW4gPC0gc2NyYXAyICU+JSBncm91cF9ieShVYmljYWNpw4PCs24uZGUub3JpZ2VuKSAlPiUgdGFsbHkoKQ0KdWJpY2FjaW9uX29yaWdlbg0KYGBgDQoNCg0KKipNZXJtYSoqDQpgYGB7cn0NCm1lcyA8LSBtZXJtYTIgJT4lIGdyb3VwX2J5KE1lcykgJT4lIHRhbGx5KCkNCm1lcw0KYGBgDQoNCg0KKipQcm9kdWNjacOzbiBkZSBjYXJ0w7NuKioNCmBgYHtyfQ0KY2xpZW50ZSA8LSBjYXJ0b24yICU+JSBncm91cF9ieShjbGllbnRlKSAlPiUgdGFsbHkoKQ0KY2xpZW50ZQ0KYGBgDQoNCg0KIyMjIFRhYmxhcyBjcnV6YWRhcw0KKipQcm9kdWNjacOzbiBkZSBjYXJ0w7NuKioNCmBgYHtyfQ0KQ3Jvc3NUYWJsZShjYXJ0b24yJGNsaWVudGUsY2FydG9uMiRlc3RhY2lvbl9hcnJhbnF1ZSkNCmBgYA0KDQoqKlNjcmFwKioNCmBgYHtyfQ0KY29sbmFtZXMoc2NyYXAyKQ0KQ3Jvc3NUYWJsZShzY3JhcDIkw68uLlJlZmVyZW5jaWEsc2NyYXAyJGBVYmljYWNpw4PCs24uZGUub3JpZ2VuYCwgcHJvcC5jaGlzcT1GQUxTRSkNCg0KYGBgDQoNCmBgYHtyfQ0KQ3Jvc3NUYWJsZShzY3JhcDIkYFViaWNhY2nDg8Kzbi5kZS5kZXNlY2hvYCxzY3JhcDIkYFViaWNhY2nDg8Kzbi5kZS5vcmlnZW5gLCBwcm9wLmNoaXNxPUZBTFNFKQ0KYGBgDQoNCg0KDQojIyMgR3LDoWZpY29zIGRlIGRhdG9zIGN1YWxpdGF0aXZvcyB5IGN1YW50aXRhdGl2b3MNCg0KKipTY3JhcCoqDQpFbiBlc3RhIG9jYXNpw7NuIHF1ZXJlbW9zIHNhYmVyIGVuIHF1ZSBkw61hIGRlbCBtZXMgZGUgYWdvc3RvIGh1Ym8gbWF5b3IgY2FudGlkYWQgZGUgc2NyYXAgeSBncmFmaWNhcmxvLg0KYGBge3J9DQpzY3JhcF9mZWNoYTwtYWdncmVnYXRlKENhbnRpZGFkIH4gRmVjaGEsIGRhdGEgPSBzY3JhcDIsIHN1bSkNCnNjcmFwX2ZlY2hhDQpgYGANCg0KYGBge3J9DQpnZ3Bsb3Qoc2NyYXBfZmVjaGEsYWVzKHg9RmVjaGEseT1DYW50aWRhZCkpKw0KICBnZW9tX3BvaW50KCkrDQogIGxhYnModGl0bGU9IkNhbnRpZGFkIHBvciBkw61hIikNCmBgYA0KDQoNCioqTWVybWEqKg0KUGFyYSBncsOhZmljYXIgZWwgdG90YWwgZGUga2lsb3MgZGUgbWVybWEgcG9yIG1lcyBwcmltZXJvIGVzIG5lY2VzYXJpbyBvYnRlbmVyIGxhIGNhbnRpZGFkIHRvdGFsIGRlIGtpbG9zIHBvciBtZXMsIGVzbyBsbyBoYWNlbW9zIGRlIGxhIHNpZ3VpZW50ZSBtYW5lcmEuDQpgYGB7cn0NCm1lcm1hX21lczwtYWdncmVnYXRlKEtpbG9zIH4gTWVzLCBkYXRhID0gbWVybWEyLCBzdW0pDQptZXJtYV9tZXMNCmBgYA0KDQpVbmEgdmV6IHF1ZSB5YSB0ZW5lbW9zIGVsIHRvdGFsIHBvciBtZXMgcG9kZW1vcyBncmFmaWNhcmxvLg0KYGBge3J9DQpnZ3Bsb3QobWVybWFfbWVzLGFlcyh4PU1lcyx5PUtpbG9zLCBmaWxsPUtpbG9zKSkrDQogIGdlb21fYmFyKHN0YXQ9ImlkZW50aXR5IikrDQogIHRoZW1lX21pbmltYWwoKSsNCiAgbGFicyh0aXRsZT0iS2lsb3MgZGUgbWVybWEgcG9yIG1lcyIpDQpgYGANCg0KDQoqKlByb2R1Y2Npw7NuIGRlIGNhcnTDs24qKg0KUGFyYSBsYSBwcm9kdWNjacOzbiBkZSBjYXJ0w7NuIHZhbW9zIGEgZ3JhZmljYXIgZWwgdGllbXBvIGVuIG1pbnV0b3MgcXVlIHRvbcOzIGVsIHByb2Nlc28uIFBhcmEgZXN0byBuZWNlc2l0YW1vcyByZXN0YXIgZWwgdGllbXBvIGRlIGluaWNpbyBkZSBwcm9jZXNvIGFsIGRlIGZpbiBkZSBwcm9jZXNvLg0KYGBge3J9DQpjYXJ0b24yPC1tdXRhdGUoY2FydG9uMiwgdGllbXBvX3Byb2Nlc28gPSBkaWZmdGltZShjYXJ0b24yJGZpbl9kZV9wcm9jZXNvLGNhcnRvbjIkaW5pY2lvX2RlX3Byb2Nlc28sIHVuaXRzID0gIm1pbnMiKSkNCmBgYA0KDQpBc2kgbWlzbW8sIHZhbW9zIGEgc2FjYXIgZWwgcHJvbWVkaW8gZGUgdGllbXBvIHF1ZSB0b21hIGVsIHByb2Nlc28gcG9yIGNsaWVudGUuIERlIGVzdGEgZm9ybWEgcG9kcmVtb3Mgc2FiZXIgY3VhbCBjbGllbnRlIGNvbnN1bWUgbWFzIHRpZW1wbyBkZSBwcm9kdWNjaW9uIGRlIEZvcm0gZW4gZWwgbWVzIGRlIGFnb3N0by4NCmBgYHtyfQ0KcHJvZF9jbGllbnRlPC1hZ2dyZWdhdGUodGllbXBvX3Byb2Nlc28gfiBjbGllbnRlLCBkYXRhPWNhcnRvbjIsIG1lYW4pDQpwcm9kX2NsaWVudGUNCmBgYA0KDQpgYGB7cn0NCmdncGxvdChwcm9kX2NsaWVudGUsYWVzKHg9Y2xpZW50ZSx5PXRpZW1wb19wcm9jZXNvKSkrDQogIGdlb21fcG9pbnQoKSsNCiAgbGFicyh0aXRsZT0iVGllbXBvIHByb21lZGlvIHBvciBjbGllbnRlIikrIHRoZW1lKGF4aXMudGV4dC54ID0gZWxlbWVudF90ZXh0KGFuZ2xlPTkwLCBoanVzdD0xKSkNCmBgYA0KDQoNCiMjIyBHcsOhZmljb3MgZGUgZGlzcGVyc2nDs24gDQoqKlNjcmFwKioNCmBgYHtyfQ0KZ2dwbG90KHNjcmFwMiwgYWVzKHggPSBVYmljYWNpw4PCs24uZGUub3JpZ2VuLCB5ID0gQ2FudGlkYWQpKSArDQogIGdlb21fYm94cGxvdCgpDQpgYGANCg0KKipNZXJtYSoqDQpgYGB7cn0NCmdncGxvdChtZXJtYTIsIGFlcyh4ID0gTWVzLCB5ID0gS2lsb3MpKSArDQogIGdlb21fYm94cGxvdCgpDQpgYGANCg0KKipQcm9kdWNjacOzbiBkZSBjYXJ0b24qKg0KYGBge3J9DQpnZ3Bsb3QoY2FydG9uMiwgYWVzKHggPSBjbGllbnRlLCB5ID0gcGllemFzX3Byb2cpKSArDQogIGdlb21fYm94cGxvdCgpK3RoZW1lKGF4aXMudGV4dC54ID0gZWxlbWVudF90ZXh0KGFuZ2xlPTkwLCBoanVzdD0xKSkNCmBgYA0KDQoNCiMjIDYpIEluY2x1eWUgdW5hIGJyZXZlIHJlZmxleGnDs24gZGUgbGEgYWN0aXZpZGFkLg0KTWUgcGFyZWNlIGRlIGdyYW4gdmFsb3IgYW5hbGl6YXIgbGFzIGJhc2VzIGRlIGRhdG9zIGRlIG1lcm1hLCBzY3JhcCB5IHByb2R1Y2Npw7NuIGRlIEZvcm0sIHlhIHF1ZSBwb2RlbW9zIGFuYWxpemFyIHkgdHJhbnNmb3JtYXIgbGEgaW5mb3JtYWNpw7NuIGRpc3BvbmlibGUgY29uIHRhbCBkZSBpbnRlcnByZXRhcmxhIHkgb2J0ZW5lciBjb25jbHVzaW9uZXMgZGUgdmFsb3IgcXVlIGF5dWRlbiBhIGxhIHRvbWEgZGUgZGVjaXNpb25lcy4g