Spreadsheet: 675739d1588445998-hlookup-with-moving-row_index_num-excelforumforecastquestrion
Sheet: Hoja1

 |  | June | July | August | September | October | November | December | January | February | March | April | May | June | July | August | September | October | November | December | January | February | March | April | May | June | July | August | September | October | November | December | January | February | March | April | May | June | July | August | September | October | November | December | January | February | March | April | May | June | July | August | September | October | November | December |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | January | February | March | April | May | June | July | August | September | October | November | December | January | February | March | April | May | June | July | August | September | October | November | December
 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52 | 53 | 54 | 55 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 56 | 57 | 58 | 59 | 60 | 61 | 62 | 63 | 64 | 65 | 66 | 67
 |  | 2015 |  |  |  |  |  |  | 2016 |  |  |  |  |  |  |  |  |  |  |  | 2017 |  |  |  |  |  |  |  |  |  |  |  | 2018 |  |  |  |  |  |  |  |  |  |  |  | 2019 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LTF |  |  | SEASONALITY INDEX |  |  |  |  |  |  |  |  |  |  |  | LTF+SI |  |  |  |  |  |  |  |  |  |  |  | REAL
COD | DES | Jun | Jul | Ago | Sep | Oct | Nov | Dic | Ene | Feb | Mar | Abr | May | Jun | Jul | Ago | Sep | Oct | Nov | Dic | Ene | Feb | Mar | Abr | May | Jun | Jul | Ago | Sep | Oct | Nov | Dic | Ene | Feb | Mar | Abr | May | Jun | Jul | Ago | Sep | Oct | Nov | Dic | Ene | Feb | Mar | Abr | May | Jun | Jul | Ago | Sep | Oct | Nov | Dic | Rot | Ult.[NAME] | Media | STDEVA | Desv/Media | Intercept | Slope | LTF+SI -> | January | February | March | April | May | June | July | August | September | October | November | December |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Proyeccion Annual | Proyeccion Ventas
107084 | PLATE A-36 1/4"X6’X20’ (6 MM) | 15 | 65 | 16 | 5 | 25 | 32 | 33 | 0 | 27 | 28 | 2 | 28 | 18 | 56 | 53 | 15 | 5 | 3 | 3 | 1 | 15 | 12 | 11 | 22 | 5 | 26 | 21 | 39 | 6 | 26 | 72 | 50 | 36 | 41 | 62 | 40 | 35 | 24 | 45 | 20 | 8 | 4 | 20 | 35 | 30 | 43 | 1 | 4 | 12 | 30 | 15 | 13 | 5 | 36 | 0 | 7.072463768115942 | 19/11/2019 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12472 |  | X
780863 | ELBOW H.N. SOLDA [NAME] | 35 | 41 | 39 | 34 | 20 | 29 | 62 | 27 | 25 | 4 | 29 | 18 | 28 | 29 | 17 | 44 | 7 | 7 | 7 | 0 | 0 | 5 | 10 | 2 | 9 | 18 | 35 | 3 | 48 | 23 | 35 | 34 | 1 | 0 | 15 | 1 | 42 | 60 | 52 | 20 | 88 | 12 | 46 | 50 | 23 | 17 | 16 | 13 | 45 | 30 | 77 | 24 | 0 | 32 | 0 | 2.636042402826855 | 29/11/2019 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 24 | 23 | 11 | 20
107077 | PLATE H.N A-36 5/8"X4’X8’ (15.8 MM) | 7 | 9 | 3 | 10 | 14 | 9 | 1 | 0 | 0 | 0 | 3 | 2 | 8 | 13 | 26 | 11 | 10 | 0 | 6 | 5 | 14 | 6 | 15 | 6 | 13 | 10 | 7 | 3 | 2 | 11 | 4 | 0 | 10 | 13 | 2 | 6 | 5 | 8 | 7 | 4 | 3 | 1 | 1 | 0 | 5 | 6 | 2 | 9 | 1 | 7 | 3 | 10 | 8 | 1 | 1 | 3.375 | 09/12/2019
107057 | PLATE H.N. A-36 1/2"X4’X8’ (12.7 MM) | 3 | 3 | 8 | 2 | 3 | 5 | 6 | 3 | 2 | 5 | 10 | 11 | 7 | 5 | 16 | 2 | 19 | 4 | 4 | 22 | 12 | 40 | 20 | 5 | 11 | 8 | 11 | 13 | 8 | 11 | 8 | 21 | 15 | 10 | 0 | 10 | 8 | 14 | 7 | 10 | 14 | 5 | 3 | 6 | 2 | 5 | 3 | 1 | 14 | 16 | 8 | 2 | 2 | 2 | 0 | 5.652173913043478 | 26/11/2019
780850 | ELBOW H.N. SOLDA C-40 3X90 | 37 | 91 | 62 | 43 | 22 | 95 | 74 | 42 | 92 | 52 | 131 | 35 | 77 | 0 | 0 | 0 | 8 | 0 | 16 | 0 | 0 | 15 | 39 | 22 | 53 | 58 | 23 | 15 | 41 | 33 | 27 | 72 | 2 | 10 | 43 | 30 | 53 | 71 | 99 | 9 | 28 | 63 | 30 | 13 | 48 | 62 | 36 | 12 | 13 | 18 | 101 | 11 | 0 | 45 | 0 | 3.015503875968992 | 29/11/2019
798354 | PIPE H.N. CED-40 C/C 2"X20 | 57 | 32 | 0 | 7 | 66 | 58 | 25 | 9 | 39 | 42 | 29 | 18 | 15 | 51 | 17 | 45 | 21 | 0 | 15 | 21 | 39 | 29 | 5 | 17 | 48 | 19 | 7 | 10 | 48 | 6 | 51 | 45 | 2 | 5 | 38 | 12 | 1 | 10 | 20 | 5 | 18 | 14 | 2 | 14 | 0 | 27 | 0 | 5 | 0 | 71 | 14 | 32 | 15 | 30 | 5 | 6 | 10/12/2019
107046 | PLATE H.N. A-36 1"X4’X8’ (25 MM) | 2 | 3 | 1 | 5 | 2 | 3 | 1 | 1 | 1 | 2 | 0 | 5 | 1 | 3 | 0 | 2 | 3 | 3 | 4 | 4 | 6 | 7 | 0 | 2 | 8 | 4 | 7 | 10 | 2 | 5 | 4 | 1 | 14 | 4 | 5 | 2 | 12 | 2 | 7 | 12 | 3 | 6 | 7 | 0 | 1 | 4 | 2 | 1 | 3 | 6 | 10 | 3 | 0 | 0 | 0 | 4.352941176470588 | 07/09/2019