Ejemplo de clase

Una Serie de tiempo es una colección de obserbaciones sobre un determinado fenómeno, efectuadas en momento sucesivos, usualmente equiespaciados.

Algunos ejemplos de series de tiempo son: 1. Precios de acciones 2. Niveles de inventario 3. Rotación de personal 4. Ventas 5. PIB (GDP)

Más información: Libro R for Data Science (2e)

Instalamos las librerías

#install.packages("forecast")
library(forecast)
## Registered S3 method overwritten by 'quantmod':
##   method            from
##   as.zoo.data.frame zoo
#install.packages("tidyverse")
library(tidyverse)
## ── Attaching core tidyverse packages ──────────────────────── tidyverse 2.0.0 ──
## ✔ dplyr     1.1.4     ✔ readr     2.1.5
## ✔ forcats   1.0.0     ✔ stringr   1.5.1
## ✔ ggplot2   3.4.4     ✔ tibble    3.2.1
## ✔ lubridate 1.9.3     ✔ tidyr     1.3.1
## ✔ purrr     1.0.2
## ── Conflicts ────────────────────────────────────────── tidyverse_conflicts() ──
## ✖ dplyr::filter() masks stats::filter()
## ✖ dplyr::lag()    masks stats::lag()
## ℹ Use the conflicted package (<http://conflicted.r-lib.org/>) to force all conflicts to become errors

Crear la serie de tiempo

Los siguientes datos de producción trimestral inician en el primer trimestre de 2020.

Se busca pronósticar la producción de los siguientes 5 trimestres.

produccion <- c(50,53,55,57,55,60)

ts <- ts(data=produccion, start = c(2020,1), frequency = 4)
ts
##      Qtr1 Qtr2 Qtr3 Qtr4
## 2020   50   53   55   57
## 2021   55   60

Crear el modelo ARIMA

ARIMA significa AutoRegressive Integrated Moving Average o Modelo Autorregresivo Integrado de Promedio Móvil.

arima <- auto.arima(ts)
arima
## Series: ts 
## ARIMA(0,1,0) 
## 
## sigma^2 = 9.2:  log likelihood = -12.64
## AIC=27.29   AICc=28.62   BIC=26.89
summary(arima)
## Series: ts 
## ARIMA(0,1,0) 
## 
## sigma^2 = 9.2:  log likelihood = -12.64
## AIC=27.29   AICc=28.62   BIC=26.89
## 
## Training set error measures:
##                 ME    RMSE      MAE      MPE     MAPE      MASE       ACF1
## Training set 1.675 2.76895 2.341667 2.933747 4.145868 0.3902778 -0.5152989

Generar el prónostico

Series:ts

pronostico <- forecast(arima, level=c(95), h=5)
pronostico
##         Point Forecast    Lo 95    Hi 95
## 2021 Q3             60 54.05497 65.94503
## 2021 Q4             60 51.59246 68.40754
## 2022 Q1             60 49.70291 70.29709
## 2022 Q2             60 48.10995 71.89005
## 2022 Q3             60 46.70652 73.29348

Actividad Hershey’s

Crear la serie de tiempo

library(readr)
lechita <- read_csv("C:/Users/melis/Downloads/Ventas_Históricas_Lechitas.csv")
#View(lechita)
lechita$Ventas...6 <- as.numeric(lechita$Ventas...6)
ts1 <- ts(data=lechita$Ventas...6, start= c(2017,1), frequency=12)
ts1
##           Jan      Feb      Mar      Apr      May      Jun      Jul      Aug
## 2017 32496.44 31287.28 33376.02 32949.77 34004.11 33757.89 32927.30 34324.12
##           Sep      Oct      Nov      Dec
## 2017 35151.28 36133.07 34799.91 34846.17

Crear modelo ARIMA

arima1 <- auto.arima(ts1)
arima1
## Series: ts1 
## ARIMA(0,1,0) 
## 
## sigma^2 = 1204405:  log likelihood = -92.62
## AIC=187.23   AICc=187.68   BIC=187.63
summary(arima1)
## Series: ts1 
## ARIMA(0,1,0) 
## 
## sigma^2 = 1204405:  log likelihood = -92.62
## AIC=187.23   AICc=187.68   BIC=187.63
## 
## Training set error measures:
##                    ME     RMSE      MAE       MPE     MAPE MASE       ACF1
## Training set 198.5189 1050.732 872.7489 0.5408539 2.581043  NaN -0.3929139

Generar el pronóstico

pronostico1 <- forecast(arima1, level=c(95), h=12)
pronostico1
##          Point Forecast    Lo 95    Hi 95
## Jan 2018       34846.17 32695.20 36997.14
## Feb 2018       34846.17 31804.24 37888.10
## Mar 2018       34846.17 31120.58 38571.76
## Apr 2018       34846.17 30544.23 39148.11
## May 2018       34846.17 30036.46 39655.88
## Jun 2018       34846.17 29577.39 40114.95
## Jul 2018       34846.17 29155.24 40537.10
## Aug 2018       34846.17 28762.31 40930.03
## Sep 2018       34846.17 28393.26 41299.08
## Oct 2018       34846.17 28044.21 41648.13
## Nov 2018       34846.17 27712.21 41980.13
## Dec 2018       34846.17 27394.99 42297.35
plot(pronostico1)

El pronóstico realizado se basa en la serie de tiempo, la cual comienza a partir del mes 1 del año 2017 y con una frecuencia mensual. Se puede ver que las ventas pronosticadas se mantendrán igual, es decir, no tendrán ni una baja ni una subida.

Actividad Finanzas Corporativas

#install.packages("finreportr")
library(finreportr)

Información disponible

Con la función “finreportr” podemos obtener la siguiente información - companyInfo(): Brinda información general como nombre, ubicación, ZIP, etc. - AnnualReports() : Brinda el nombre, fecha y número de acceso. - GetIncome(): Brinda el Estado de Resultados. - GetBalanceSheet(): Brinda el Balance General. - GetCashFlow(): Brinda el flujo de efectivo.

options(HTTPUserAgent = "a a@gmail.com")
CompanyInfo("JPM")
##               company        CIK  SIC state state.inc FY.end     street.address
## 1 JPMORGAN CHASE & CO 0000019617 6021    NY        DE   1231 383 MADISON AVENUE
##          city.state
## 1 NEW YORK NY 10017
AnnualReports("JPM")
##    filing.name filing.date         accession.no
## 1         10-K  2024-02-16 0000019617-24-000225
## 2         10-K  2023-02-21 0000019617-23-000231
## 3         10-K  2022-02-22 0000019617-22-000272
## 4         10-K  2021-02-23 0000019617-21-000236
## 5         10-K  2020-02-25 0000019617-20-000257
## 6         10-K  2019-02-26 0000019617-19-000054
## 7         10-K  2018-02-27 0000019617-18-000057
## 8         10-K  2017-02-28 0000019617-17-000314
## 9         10-K  2016-02-23 0000019617-16-000902
## 10        10-K  2015-02-24 0000019617-15-000272
## 11        10-K  2014-02-20 0000019617-14-000289
## 12        10-K  2013-02-28 0000019617-13-000221
## 13        10-K  2012-02-29 0000019617-12-000163
## 14        10-K  2011-02-28 0000950123-11-019773
## 15        10-K  2010-02-24 0000950123-10-016029
## 16        10-K  2009-03-02 0000950123-09-003840
## 17        10-K  2008-02-29 0001193125-08-043536
## 18        10-K  2007-03-01 0000950123-07-003015
## 19      10-K/A  2006-08-03 0000950123-06-009854
## 20      10-K/A  2006-06-22 0000950123-06-008545
## 21        10-K  2006-03-09 0000950123-06-002875
## 22      10-K/A  2005-06-28 9999999997-05-030472
## 23        10-K  2005-03-02 0000950123-05-002539
## 24      10-K/A  2004-06-28 9999999997-04-028305
## 25        10-K  2004-02-18 0000950123-04-002022
## 26      10-K/A  2003-06-30 9999999997-03-028080
## 27        10-K  2003-03-19 0000950123-03-002985
## 28      10-K/A  2002-06-28 9999999997-02-037872
## 29     10-K405  2002-03-22 0000950123-02-002823
## 30     10-K405  2001-03-22 0000950123-01-002499
## 31      10-K/A  2000-06-28 0000019617-00-000125
## 32        10-K  2000-03-13 0000950123-00-002204
## 33      10-K/A  1999-06-29 0000950123-99-006055
## 34     10-K405  1999-03-11 0000950123-99-002057
## 35     10-K405  1998-03-30 0000950123-98-003043
## 36        10-K  1997-03-25 0000950123-97-002412
## 37     10-K405  1996-03-20 0000950123-96-001197
## 38      10-K/A  1995-06-26 0000019617-95-000080
## 39     10-K405  1995-03-27 0000950123-95-000706
## 40      10-K/A  1994-05-09 0000019617-94-000048
## 41        10-K  1994-03-25 0000950123-94-000607
google_income <- GetIncome("GOOG", 2016)
amazon_balance <- GetBalanceSheet("AMZN", 2015)
apple_cashflow <- GetCashFlow("AAPL", 2014)

Análisis Financiero de Empresa

Información de Visa

options(HTTPUserAgent = "a a@gmail.com")
CompanyInfo("V")
##     company        CIK  SIC state state.inc FY.end street.address
## 1 VISA INC. 0001403161 7389    CA        DE   0930  P.O. BOX 8999
##                    city.state
## 1 SAN FRANCISCO CA 94128-8999
AnnualReports("V")
##    filing.name filing.date         accession.no
## 1         10-K  2023-11-15 0001403161-23-000099
## 2         10-K  2022-11-16 0001403161-22-000081
## 3         10-K  2021-11-18 0001403161-21-000060
## 4         10-K  2020-11-19 0001403161-20-000070
## 5         10-K  2019-11-14 0001403161-19-000050
## 6         10-K  2018-11-16 0001403161-18-000055
## 7         10-K  2017-11-17 0001403161-17-000044
## 8         10-K  2016-11-15 0001403161-16-000058
## 9         10-K  2015-11-20 0001403161-15-000013
## 10        10-K  2014-11-21 0001403161-14-000017
## 11        10-K  2013-11-22 0001403161-13-000011
## 12        10-K  2012-11-16 0001384108-12-000011
## 13        10-K  2011-11-18 0001193125-11-315956
## 14        10-K  2010-11-19 0001193125-10-265236
## 15        10-K  2009-11-20 0001193125-09-239249
## 16        10-K  2008-11-21 0001193125-08-240384
## 17      10-K/A  2008-02-25 0001193125-08-036840
## 18      10-K/A  2008-02-04 0001193125-08-019268
## 19        10-K  2007-12-21 0001193125-07-270394
visa_income <- GetIncome("V", 2016)
visa_income2 <- GetIncome("V", 2013)
#view(visa_income)
visa_balance <- GetBalanceSheet("V", 2015)
visa_cashflow <- GetCashFlow("V", 2014)
merge_visa <- rbind(visa_income, visa_income2)

Serie de tiempo

merge_visa$Amount <- as.numeric(merge_visa$Amount)
str(merge_visa)
## 'data.frame':    130 obs. of  5 variables:
##  $ Metric   : chr  "Service fees" "Service fees" "Service fees" "Data Processing Fees" ...
##  $ Units    : chr  "usd" "usd" "usd" "usd" ...
##  $ Amount   : num  5.80e+09 6.30e+09 6.75e+09 5.17e+09 5.55e+09 ...
##  $ startDate: chr  "2013-10-01" "2014-10-01" "2015-10-01" "2013-10-01" ...
##  $ endDate  : chr  "2014-09-30" "2015-09-30" "2016-09-30" "2014-09-30" ...
visa1 <- merge_visa %>% select(Metric, Amount, startDate)
visa2 <- visa1 %>% filter(Metric=="Revenues")
visa2 <- visa2 [order(visa2$startDate), ]
visa3 <- visa2 %>% select(Amount)
ts <- ts(data = visa3$Amount, start=2010, frequency=1) #frequencia de 1 es para años
ts
## Time Series:
## Start = 2010 
## End = 2015 
## Frequency = 1 
## [1] 9.1880e+09 1.0421e+10 1.1778e+10 1.2702e+10 1.3880e+10 1.5082e+10

Modelo Arima

arima <- auto.arima(ts)
arima
## Series: ts 
## ARIMA(0,1,0) with drift 
## 
## Coefficients:
##            drift
##       1178800000
## s.e.    62342384
## 
## sigma^2 = 2.505e+16:  log likelihood = -100.93
## AIC=205.87   AICc=211.87   BIC=205.09
summary(arima)
## Series: ts 
## ARIMA(0,1,0) with drift 
## 
## Coefficients:
##            drift
##       1178800000
## s.e.    62342384
## 
## sigma^2 = 2.505e+16:  log likelihood = -100.93
## AIC=205.87   AICc=211.87   BIC=205.09
## 
## Training set error measures:
##                   ME      RMSE      MAE        MPE      MAPE       MASE
## Training set 1334866 129240697 86534866 0.04372382 0.7143061 0.07340929
##                    ACF1
## Training set -0.3502541

Generamos el pronóstico

pronostico <- forecast(arima, level=c(95), h=5)
pronostico
##      Point Forecast       Lo 95       Hi 95
## 2016    16260800000 15950563413 16571036587
## 2017    17439600000 17000859212 17878340788
## 2018    18618400000 18081054470 19155745530
## 2019    19797200000 19176726827 20417673173
## 2020    20976000000 20282289903 21669710097
plot(pronostico)

LS0tDQp0aXRsZTogIkFjdGl2aWRhZCAyLiBHZW5lcmFjacOzbiBkZSBlc2NlbmFyaW9zIGZ1dHVyb3MgY29uIG1vZGVsb3MgZGUgcHJvbsOzc3RpY29zIGVuIHNlcmllcyBkZSB0aWVtcG8iDQphdXRob3I6ICJNZWxpc3NhIEVzY8OhcmNlZ2EgQTAxNTY4NTE0LCBQYXRyaWNpbyBGYXLDrWFzIEEwMDgzMTc1NCwgWGltZW5hIEZlcm7DoW5kZXogQTAwODMxNzI1Ig0KZGF0ZTogIjIwMjQtMDItMjEiDQpvdXRwdXQ6IA0KICBodG1sX2RvY3VtZW50Og0KICAgIHRvYzogVFJVRQ0KICAgIHRvY19mbG9hdDogVFJVRQ0KICAgIGNvZGVfZG93bmxvYWQ6IFRSVUUgDQotLS0NCg0KIVtdKEM6L1VzZXJzL21lbGlzL0Rvd25sb2Fkcy9naWZsZWNoaXRhLmdpZikNCg0KIyBFamVtcGxvIGRlIGNsYXNlDQpVbmEgKlNlcmllIGRlIHRpZW1wbyogZXMgdW5hIGNvbGVjY2nDs24gZGUgb2JzZXJiYWNpb25lcyBzb2JyZSB1biBkZXRlcm1pbmFkbyBmZW7Ds21lbm8sIGVmZWN0dWFkYXMgZW4gbW9tZW50byBzdWNlc2l2b3MsIHVzdWFsbWVudGUgZXF1aWVzcGFjaWFkb3MuDQoNCkFsZ3Vub3MgZWplbXBsb3MgZGUgc2VyaWVzIGRlIHRpZW1wbyBzb246DQoxLiBQcmVjaW9zIGRlIGFjY2lvbmVzDQoyLiBOaXZlbGVzIGRlIGludmVudGFyaW8NCjMuIFJvdGFjacOzbiBkZSBwZXJzb25hbA0KNC4gVmVudGFzDQo1LiBQSUIgKEdEUCkNCg0KTcOhcyBpbmZvcm1hY2nDs246IA0KW0xpYnJvIFIgZm9yIERhdGEgU2NpZW5jZSAoMmUpXShodHRwczovL3I0ZHMuaGFkbGV5Lm56LykNCg0KIyMgSW5zdGFsYW1vcyBsYXMgbGlicmVyw61hcyANCmBgYHtyfQ0KI2luc3RhbGwucGFja2FnZXMoImZvcmVjYXN0IikNCmxpYnJhcnkoZm9yZWNhc3QpDQojaW5zdGFsbC5wYWNrYWdlcygidGlkeXZlcnNlIikNCmxpYnJhcnkodGlkeXZlcnNlKQ0KYGBgDQoNCiMjIENyZWFyIGxhIHNlcmllIGRlIHRpZW1wbw0KTG9zIHNpZ3VpZW50ZXMgZGF0b3MgZGUgcHJvZHVjY2nDs24gdHJpbWVzdHJhbCBpbmljaWFuIGVuIGVsIHByaW1lciB0cmltZXN0cmUgZGUgMjAyMC4NCg0KU2UgYnVzY2EgcHJvbsOzc3RpY2FyIGxhIHByb2R1Y2Npw7NuIGRlIGxvcyBzaWd1aWVudGVzIDUgdHJpbWVzdHJlcy4NCg0KYGBge3J9DQpwcm9kdWNjaW9uIDwtIGMoNTAsNTMsNTUsNTcsNTUsNjApDQoNCnRzIDwtIHRzKGRhdGE9cHJvZHVjY2lvbiwgc3RhcnQgPSBjKDIwMjAsMSksIGZyZXF1ZW5jeSA9IDQpDQp0cw0KYGBgDQoNCiMjIENyZWFyIGVsIG1vZGVsbyBBUklNQQ0KKkFSSU1BKiBzaWduaWZpY2EgQXV0b1JlZ3Jlc3NpdmUgSW50ZWdyYXRlZCBNb3ZpbmcgQXZlcmFnZSBvIE1vZGVsbyBBdXRvcnJlZ3Jlc2l2byBJbnRlZ3JhZG8gZGUgUHJvbWVkaW8gTcOzdmlsLg0KYGBge3J9DQphcmltYSA8LSBhdXRvLmFyaW1hKHRzKQ0KYXJpbWENCnN1bW1hcnkoYXJpbWEpDQpgYGANCg0KIyMgR2VuZXJhciBlbCBwcsOzbm9zdGljbyANClNlcmllczp0cw0KYGBge3J9DQpwcm9ub3N0aWNvIDwtIGZvcmVjYXN0KGFyaW1hLCBsZXZlbD1jKDk1KSwgaD01KQ0KcHJvbm9zdGljbw0KYGBgDQoNCiMgQWN0aXZpZGFkIEhlcnNoZXkncw0KDQojIyBDcmVhciBsYSBzZXJpZSBkZSB0aWVtcG8NCmBgYHtyIG1lc3NhZ2U9RkFMU0UsIHdhcm5pbmc9RkFMU0V9DQpsaWJyYXJ5KHJlYWRyKQ0KbGVjaGl0YSA8LSByZWFkX2NzdigiQzovVXNlcnMvbWVsaXMvRG93bmxvYWRzL1ZlbnRhc19IaXN0w7NyaWNhc19MZWNoaXRhcy5jc3YiKQ0KI1ZpZXcobGVjaGl0YSkNCmxlY2hpdGEkVmVudGFzLi4uNiA8LSBhcy5udW1lcmljKGxlY2hpdGEkVmVudGFzLi4uNikNCnRzMSA8LSB0cyhkYXRhPWxlY2hpdGEkVmVudGFzLi4uNiwgc3RhcnQ9IGMoMjAxNywxKSwgZnJlcXVlbmN5PTEyKQ0KdHMxDQpgYGANCg0KIyMgQ3JlYXIgbW9kZWxvIEFSSU1BDQpgYGB7cn0NCmFyaW1hMSA8LSBhdXRvLmFyaW1hKHRzMSkNCmFyaW1hMQ0Kc3VtbWFyeShhcmltYTEpDQpgYGANCg0KIyMgR2VuZXJhciBlbCBwcm9uw7NzdGljbyANCmBgYHtyfQ0KcHJvbm9zdGljbzEgPC0gZm9yZWNhc3QoYXJpbWExLCBsZXZlbD1jKDk1KSwgaD0xMikNCnByb25vc3RpY28xDQpwbG90KHByb25vc3RpY28xKQ0KYGBgDQoNCkVsIHByb27Ds3N0aWNvIHJlYWxpemFkbyBzZSBiYXNhIGVuIGxhIHNlcmllIGRlIHRpZW1wbywgbGEgY3VhbCBjb21pZW56YSBhIHBhcnRpciBkZWwgbWVzIDEgZGVsIGHDsW8gMjAxNyB5IGNvbiB1bmEgZnJlY3VlbmNpYSBtZW5zdWFsLiBTZSBwdWVkZSB2ZXIgcXVlIGxhcyB2ZW50YXMgcHJvbm9zdGljYWRhcyBzZSBtYW50ZW5kcsOhbiBpZ3VhbCwgZXMgZGVjaXIsIG5vIHRlbmRyw6FuIG5pIHVuYSBiYWphIG5pIHVuYSBzdWJpZGEuIA0KDQoNCiMgQWN0aXZpZGFkIEZpbmFuemFzIENvcnBvcmF0aXZhcw0KYGBge3J9DQojaW5zdGFsbC5wYWNrYWdlcygiZmlucmVwb3J0ciIpDQpsaWJyYXJ5KGZpbnJlcG9ydHIpDQpgYGANCg0KIyMgSW5mb3JtYWNpw7NuIGRpc3BvbmlibGUgDQpDb24gbGEgZnVuY2nDs24gImZpbnJlcG9ydHIiIHBvZGVtb3Mgb2J0ZW5lciBsYSBzaWd1aWVudGUgaW5mb3JtYWNpw7NuIA0KLSBjb21wYW55SW5mbygpOiBCcmluZGEgaW5mb3JtYWNpw7NuIGdlbmVyYWwgY29tbyBub21icmUsIHViaWNhY2nDs24sIFpJUCwgZXRjLiANCi0gQW5udWFsUmVwb3J0cygpIDogQnJpbmRhIGVsIG5vbWJyZSwgZmVjaGEgeSBuw7ptZXJvIGRlIGFjY2Vzby4NCi0gR2V0SW5jb21lKCk6IEJyaW5kYSBlbCBFc3RhZG8gZGUgUmVzdWx0YWRvcy4gDQotIEdldEJhbGFuY2VTaGVldCgpOiBCcmluZGEgZWwgQmFsYW5jZSBHZW5lcmFsLiANCi0gR2V0Q2FzaEZsb3coKTogQnJpbmRhIGVsIGZsdWpvIGRlIGVmZWN0aXZvLiANCg0KYGBge3J9DQpvcHRpb25zKEhUVFBVc2VyQWdlbnQgPSAiYSBhQGdtYWlsLmNvbSIpDQpDb21wYW55SW5mbygiSlBNIikNCkFubnVhbFJlcG9ydHMoIkpQTSIpDQpnb29nbGVfaW5jb21lIDwtIEdldEluY29tZSgiR09PRyIsIDIwMTYpDQphbWF6b25fYmFsYW5jZSA8LSBHZXRCYWxhbmNlU2hlZXQoIkFNWk4iLCAyMDE1KQ0KYXBwbGVfY2FzaGZsb3cgPC0gR2V0Q2FzaEZsb3coIkFBUEwiLCAyMDE0KQ0KYGBgDQoNCg0KIyBBbsOhbGlzaXMgRmluYW5jaWVybyBkZSBFbXByZXNhDQoNCiMjIEluZm9ybWFjacOzbiBkZSBWaXNhDQpgYGB7cn0NCm9wdGlvbnMoSFRUUFVzZXJBZ2VudCA9ICJhIGFAZ21haWwuY29tIikNCkNvbXBhbnlJbmZvKCJWIikNCkFubnVhbFJlcG9ydHMoIlYiKQ0KdmlzYV9pbmNvbWUgPC0gR2V0SW5jb21lKCJWIiwgMjAxNikNCnZpc2FfaW5jb21lMiA8LSBHZXRJbmNvbWUoIlYiLCAyMDEzKQ0KI3ZpZXcodmlzYV9pbmNvbWUpDQp2aXNhX2JhbGFuY2UgPC0gR2V0QmFsYW5jZVNoZWV0KCJWIiwgMjAxNSkNCnZpc2FfY2FzaGZsb3cgPC0gR2V0Q2FzaEZsb3coIlYiLCAyMDE0KQ0KYGBgDQoNCmBgYHtyfQ0KbWVyZ2VfdmlzYSA8LSByYmluZCh2aXNhX2luY29tZSwgdmlzYV9pbmNvbWUyKQ0KYGBgDQoNCiMjIFNlcmllIGRlIHRpZW1wbw0KYGBge3J9DQptZXJnZV92aXNhJEFtb3VudCA8LSBhcy5udW1lcmljKG1lcmdlX3Zpc2EkQW1vdW50KQ0Kc3RyKG1lcmdlX3Zpc2EpDQp2aXNhMSA8LSBtZXJnZV92aXNhICU+JSBzZWxlY3QoTWV0cmljLCBBbW91bnQsIHN0YXJ0RGF0ZSkNCnZpc2EyIDwtIHZpc2ExICU+JSBmaWx0ZXIoTWV0cmljPT0iUmV2ZW51ZXMiKQ0KdmlzYTIgPC0gdmlzYTIgW29yZGVyKHZpc2EyJHN0YXJ0RGF0ZSksIF0NCnZpc2EzIDwtIHZpc2EyICU+JSBzZWxlY3QoQW1vdW50KQ0KdHMgPC0gdHMoZGF0YSA9IHZpc2EzJEFtb3VudCwgc3RhcnQ9MjAxMCwgZnJlcXVlbmN5PTEpICNmcmVxdWVuY2lhIGRlIDEgZXMgcGFyYSBhw7Fvcw0KdHMNCmBgYA0KDQojIyBNb2RlbG8gQXJpbWENCmBgYHtyfQ0KYXJpbWEgPC0gYXV0by5hcmltYSh0cykNCmFyaW1hDQpzdW1tYXJ5KGFyaW1hKQ0KYGBgDQoNCiMjIEdlbmVyYW1vcyBlbCBwcm9uw7NzdGljbw0KYGBge3J9DQpwcm9ub3N0aWNvIDwtIGZvcmVjYXN0KGFyaW1hLCBsZXZlbD1jKDk1KSwgaD01KQ0KcHJvbm9zdGljbw0KcGxvdChwcm9ub3N0aWNvKQ0KYGBgDQoNCg0KDQoNCg0KDQoNCg0K