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

{"sheet":"datos","index":0,"n_rows":13,"n_cols":2,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[2,{"$f":"VLOOKUP(A1,$A$2:$B$13,2,0)","v":"FEBRERO"}]
[1,"ENERO"]
[2,"FEBRERO"]
[3,"MARZO"]
[4,"ABRIL"]
[5,"MAYO"]
[6,"JUNIO"]
[7,"JULIO"]
[8,"AGOSTO"]
[9,"SEPTIEMBRE"]
[10,"OCTUBRE"]
[11,"NOVIEMBRE"]
[12,"DICIEMBRE"]

{"sheet":"GRAFICO","index":1,"n_rows":31,"n_cols":27,"rows_kept":31,"cut":false,"hidden":false,"merged":[[1,7,2,11],[3,7,3,11]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,"                      Fuente: Pharma360°",null,null,null,null,"TABLERO DE CONTROL VENTAS",null,null,null,null,null,{"$f":"+fuentes!F5","v":0.98874789739377034},null,{"$f":"+fuentes!F6","v":0.49918947379008788},null,null,null,null,null,null,null,null,null,null," "]
[null,null,"                     Análisis Gráfico por linea/Producto/Cliente",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,"                            Ult. Act.:",null,null,{"$f":"+DASH!$C$5","v":"2016-03-07T16:05:54"},null,{"$f":"+DASH!I4","v":"Selección: Inf. MENSUAL A ABRIL /Lin: (ALL) /Marca: MERC: 18-GLYCEROL/  /Cliente: (ALL)"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[]
[]
[null,null,{"$f":"+DASH!C9","v":"GENERAL"}]
[null,null,{"$f":"+DASH!C10","v":"SNC"}]
[null,null,{"$f":"+DASH!C11","v":"CARDIOLOGICA"}]
[null,null,{"$f":"+DASH!C12","v":"RESPIRATORIA"}]
[null,null,{"$f":"+DASH!C13","v":"METABOLICOS"}]
[null,null,{"$f":"+DASH!C14","v":"OFTALMOLOGICA"}]
[null,null,{"$f":"+DASH!C15","v":"GINECOLOCICA"}]
[null,null,{"$f":"+DASH!C16","v":"Total general"}]
[]
[]
[]
[]
[null," "]
[null," ",null,null,null,{"$f":"IF(fuentes!$B$14=1,\"%Cumplimiento en Valores ($) \",\"%Cumplimiento en Unidades \")","v":"%Cumplimiento en Valores ($) "},"NUR PLAN","NUR VTA.","%VAR","TOTAL"]
[null,null,null,null,{"$f":"IF($J$22=\"LINEA\",DASH!C19,DASH!$C9)","v":"GENERAL"},{"$f":"IF(fuentes!$B$14=1,IF($J$22=\"LINEA\",DASH!P19,DASH!$P9),IF($J$22=\"LINEA\",DASH!I19,DASH!$I9))","v":1.0033494953148832},{"$f":"IF($J$22=\"LINEA\",DASH!R19,DASH!R9)","v":0},{"$f":"IF($J$22=\"LINEA\",DASH!S19,+DASH!S9)","v":0.50437097718109891},{"$f":"(+H23/G23)-1","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,{"$f":"IF($J$22=\"LINEA\",DASH!C20,DASH!$C10)","v":"SNC"},{"$f":"IF(fuentes!$B$14=1,IF($J$22=\"LINEA\",DASH!P20,DASH!$P10),IF($J$22=\"LINEA\",DASH!I20,DASH!$I10))","v":0.98411303669128336},{"$f":"IF($J$22=\"LINEA\",DASH!R20,DASH!R10)","v":0},{"$f":"IF($J$22=\"LINEA\",DASH!S20,+DASH!S10)","v":0.49567815257056425},{"$f":"(+H24/G24)-1","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,{"$f":"IF($J$22=\"LINEA\",DASH!C21,DASH!$C11)","v":"CARDIOLOGICA"},{"$f":"IF(fuentes!$B$14=1,IF($J$22=\"LINEA\",DASH!P21,DASH!$P11),IF($J$22=\"LINEA\",DASH!I21,DASH!$I11))","v":0.98531619356129807},{"$f":"IF($J$22=\"LINEA\",DASH!R21,DASH!R11)","v":0},{"$f":"IF($J$22=\"LINEA\",DASH!S21,+DASH!S11)","v":0.49918911232500052},{"$error":"#DIV/0!"}]
[null,null,null,null,{"$f":"IF($J$22=\"LINEA\",DASH!C22,DASH!$C12)","v":"RESPIRATORIA"},{"$f":"IF(fuentes!$B$14=1,IF($J$22=\"LINEA\",DASH!P22,DASH!$P12),IF($J$22=\"LINEA\",DASH!I22,DASH!$I12))","v":0.96343951989867294},{"$f":"IF($J$22=\"LINEA\",DASH!R22,DASH!R12)","v":0},{"$f":"IF($J$22=\"LINEA\",DASH!S22,+DASH!S12)","v":0.4977362083006458},{"$error":"#DIV/0!"}]
[null,null,null,null,{"$f":"IF($J$22=\"LINEA\",DASH!C23,DASH!$C13)","v":"METABOLICOS"},{"$f":"IF(fuentes!$B$14=1,IF($J$22=\"LINEA\",DASH!P23,DASH!$P13),IF($J$22=\"LINEA\",DASH!I23,DASH!$I13))","v":0.98054321928268073},{"$f":"IF($J$22=\"LINEA\",DASH!R23,DASH!R13)","v":0},{"$f":"IF($J$22=\"LINEA\",DASH!S23,+DASH!S13)","v":0.49466632669618238},{"$error":"#DIV/0!"}]
[null,null,null,null,{"$f":"IF($J$22=\"LINEA\",DASH!C24,DASH!$C14)","v":"OFTALMOLOGICA"},{"$f":"IF(fuentes!$B$14=1,IF($J$22=\"LINEA\",DASH!P24,DASH!$P14),IF($J$22=\"LINEA\",DASH!I24,DASH!$I14))","v":0.99517172003051613},{"$f":"IF($J$22=\"LINEA\",DASH!R24,DASH!R14)","v":0},{"$f":"IF($J$22=\"LINEA\",DASH!S24,+DASH!S14)","v":0.50028649041126994},{"$error":"#DIV/0!"}]
[null,null,null,null,"TOTAL",{"$f":"IF(fuentes!$B$14=1,IF($J$22=\"LINEA\",DASH!P31,DASH!$P16),IF($J$22=\"LINEA\",DASH!I31,DASH!$I16))","v":0.98874789739377034},{"$f":"IF($J$22=\"LINEA\",DASH!R31,DASH!R16)","v":0},{"$f":"IF($J$22=\"LINEA\",DASH!S31,+DASH!S16)","v":0.49918947379008788},{"$error":"#DIV/0!"}]
[]
[null,null,null,null," "]

{"sheet":"DASH","index":2,"n_rows":48,"n_cols":38,"rows_kept":48,"cut":false,"hidden":false,"merged":[[33,30,33,31],[33,26,33,27],[25,10,25,12],[26,10,26,12],[27,10,27,12],[28,10,28,12],[29,10,29,12],[33,8,33,9],[17,15,17,16],[7,15,7,16],[33,15,33,16],[33,11,33,12],[7,10,7,12],[8,10,8,12],[9,10,9,12],[10,10,10,12],[11,10,11,12],[12,10,12,12],[13,10,13,12],[14,10,14,12],[20,10,20,12],[21,10,21,12],[22,10,22,12],[1,20,2,21],[1,10,2,18],[1,22,2,22],[32,20,32,28],[4,2,4,4],[15,10,15,12],[17,10,17,12],[18,10,18,12],[19,10,19,12],[3,8,3,19],[7,8,7,9],[17,8,17,9],[23,10,23,12],[24,10,24,12],[30,10,30,12],[43,21,43,22],[43,27,43,28],[43,31,43,32],[43,29,43,30],[43,23,43,24],[43,25,43,26]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,"                          Fuente: Pharma360°",null,null,null,null,null,null,null,"TABLERO DE CONTROL VENTAS ",null,null,null,null,null,null,null,null,null,{"$f":"+fuentes!F5","v":0.98874789739377034},null,{"$f":"+fuentes!F6","v":0.49918947379008788},null,null,null,null,null,null," "]
[null,null,"                          Análisis por linea/Producto/Cliente",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,"                            Ult. Act.:",null,null,null,null,null,{"$f":"\"Selección: Inf. \"&fuentes!C30&\" /Lin: \"&fuentes!Y2&\" /Marca: \"&fuentes!Y3&\"/\"&fuentes!AA4&\" /Cliente: \"&fuentes!Y5","v":"Selección: Inf. MENSUAL A ABRIL /Lin: (ALL) /Marca: MERC: 18-GLYCEROL/  /Cliente: (ALL)"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null,null,null," "]
[null,null,"2016-03-07T16:05:54",null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Año actual : \"&fuentes!C6","v":"Año actual : 2016"},null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null,null,null,{"$f":"100%-AL5","v":1.1252102606229664E-2},{"$f":"+fuentes!F5","v":0.98874789739377034}]
[null,null,null,null,null,null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"LINEAS","PLAN (U)","VTA (U)","  VTA (U) BONIF."," TOT  VTA (U)"," %BONI. (U)","%CUM (U)",null,"FCST (U)",null,null," PLAN ($)"," VTA ($)","%CUM ($)",null,"NUR PLAN","NUR VTA"]
[null,null,{"$f":"fuentes!H12","v":"GENERAL"},{"$f":"IFERROR((VLOOKUP($C9,fuentes!$H$11:$P$19,2,0)),\" \")","v":60317.379999999903},{"$f":"IFERROR((VLOOKUP($C9,fuentes!$H$11:$P$19,3,0)),\" \")","v":60079.620000000032},{"$f":"IFERROR((VLOOKUP($C9,fuentes!$H$11:$P$19,4,0)),\" \")","v":60027.390000000036},{"$f":"IFERROR((VLOOKUP($C9,fuentes!$H$11:$P$19,5,0)),\" \")","v":120107.01000000007},{"$f":"IFERROR((VLOOKUP($C9,fuentes!$H$11:$P$19,6,0)),\" \")","v":0.99913065362264286},{"$f":"IFERROR((+E9/D9),0)","v":0.99605818422484749},{"$f":"IFERROR((+E9/D9),0)","v":0.99605818422484749},{"$f":"IF(fuentes!$B$14=1,\" \",SUMIF(#REF!,DASH!C9,#REF!))","v":" "},null,null,{"$f":"IFERROR((VLOOKUP($C9,fuentes!$H$11:$P$19,7,0)),\" \")","v":60376.259999999886},{"$f":"IFERROR((VLOOKUP($C9,fuentes!$H$11:$P$19,8,0)),\" \")","v":60578.490000000049},{"$f":"IFERROR((+O9/N9),0)","v":1.0033494953148832},{"$f":"IFERROR((+O9/N9),0)","v":1.0033494953148832},{"$f":"IFERROR((VLOOKUP($C9,fuentes!$H$11:$Q$19,10,0)),\" \")","v":0},{"$f":"IFERROR((+O9/G9),0)","v":0.50437097718109891}]
[null,null,{"$f":"fuentes!H13","v":"SNC"},{"$f":"IFERROR((VLOOKUP($C10,fuentes!$H$11:$P$19,2,0)),\" \")","v":51903.69999999999},{"$f":"IFERROR((VLOOKUP($C10,fuentes!$H$11:$P$19,3,0)),\" \")","v":51695.510000000089},{"$f":"IFERROR((VLOOKUP($C10,fuentes!$H$11:$P$19,4,0)),\" \")","v":51834.289999999892},{"$f":"IFERROR((VLOOKUP($C10,fuentes!$H$11:$P$19,5,0)),\" \")","v":103529.79999999999},{"$f":"IFERROR((VLOOKUP($C10,fuentes!$H$11:$P$19,6,0)),\" \")","v":1.0026845658355978},{"$f":"IFERROR((+E10/D10),0)","v":0.99598891793841482},0.99598891793841482,{"$f":"IF(fuentes!$B$14=1,\" \",SUMIF(#REF!,DASH!C10,#REF!))","v":" "},null,null,{"$f":"IFERROR((VLOOKUP($C10,fuentes!$H$11:$P$19,7,0)),\" \")","v":52145.900000000009},{"$f":"IFERROR((VLOOKUP($C10,fuentes!$H$11:$P$19,8,0)),\" \")","v":51317.46},{"$f":"IFERROR((+O10/N10),0)","v":0.98411303669128336},{"$f":"IFERROR((+O10/N10),0)","v":0.98411303669128336},{"$f":"IFERROR((VLOOKUP($C10,fuentes!$H$11:$Q$19,10,0)),\" \")","v":0},{"$f":"IFERROR((+O10/G10),0)","v":0.49567815257056425}]
[null,null,{"$f":"fuentes!H14","v":"CARDIOLOGICA"},{"$f":"IFERROR((VLOOKUP($C11,fuentes!$H$11:$P$19,2,0)),\" \")","v":37070.969999999994},{"$f":"IFERROR((VLOOKUP($C11,fuentes!$H$11:$P$19,3,0)),\" \")","v":36668.400000000045},{"$f":"IFERROR((VLOOKUP($C11,fuentes!$H$11:$P$19,4,0)),\" \")","v":36609.32},{"$f":"IFERROR((VLOOKUP($C11,fuentes!$H$11:$P$19,5,0)),\" \")","v":73277.720000000045},{"$f":"IFERROR((VLOOKUP($C11,fuentes!$H$11:$P$19,6,0)),\" \")","v":0.99838880343838166},0.98914055931096623,0.98914055931096623,{"$f":"IF(fuentes!$B$14=1,\" \",SUMIF(#REF!,DASH!C11,#REF!))","v":" "},null,null,{"$f":"IFERROR((VLOOKUP($C11,fuentes!$H$11:$P$19,7,0)),\" \")","v":37124.57},{"$f":"IFERROR((VLOOKUP($C11,fuentes!$H$11:$P$19,8,0)),\" \")","v":36579.439999999959},0.98531619356129807,0.98531619356129807,{"$f":"IFERROR((VLOOKUP($C11,fuentes!$H$11:$Q$19,10,0)),\" \")","v":0},0.49918911232500052]
[null,null,{"$f":"fuentes!H15","v":"RESPIRATORIA"},{"$f":"IFERROR((VLOOKUP($C12,fuentes!$H$11:$P$19,2,0)),\" \")","v":15992.440000000013},{"$f":"IFERROR((VLOOKUP($C12,fuentes!$H$11:$P$19,3,0)),\" \")","v":15404.669999999998},{"$f":"IFERROR((VLOOKUP($C12,fuentes!$H$11:$P$19,4,0)),\" \")","v":15404.259999999995},{"$f":"IFERROR((VLOOKUP($C12,fuentes!$H$11:$P$19,5,0)),\" \")","v":30808.929999999993},{"$f":"IFERROR((VLOOKUP($C12,fuentes!$H$11:$P$19,6,0)),\" \")","v":0.99997338469438146},0.96324700921185169,0.96324700921185169,{"$f":"IF(fuentes!$B$14=1,\" \",SUMIF(#REF!,DASH!C12,#REF!))","v":" "},null,null,{"$f":"IFERROR((VLOOKUP($C12,fuentes!$H$11:$P$19,7,0)),\" \")","v":15916.639999999998},{"$f":"IFERROR((VLOOKUP($C12,fuentes!$H$11:$P$19,8,0)),\" \")","v":15334.720000000012},0.96343951989867294,0.96343951989867294,{"$f":"IFERROR((VLOOKUP($C12,fuentes!$H$11:$Q$19,10,0)),\" \")","v":0},0.4977362083006458]
[null,null,{"$f":"fuentes!H16","v":"METABOLICOS"},{"$f":"IFERROR((VLOOKUP($C13,fuentes!$H$11:$P$19,2,0)),\" \")","v":11913.540000000003},{"$f":"IFERROR((VLOOKUP($C13,fuentes!$H$11:$P$19,3,0)),\" \")","v":11981.190000000004},{"$f":"IFERROR((VLOOKUP($C13,fuentes!$H$11:$P$19,4,0)),\" \")","v":11746.360000000008},{"$f":"IFERROR((VLOOKUP($C13,fuentes!$H$11:$P$19,5,0)),\" \")","v":23727.55000000001},{"$f":"IFERROR((VLOOKUP($C13,fuentes!$H$11:$P$19,6,0)),\" \")","v":0.98040011050655262},1.0056784129654159,1.0056784129654159,{"$f":"IF(fuentes!$B$14=1,\" \",SUMIF(#REF!,DASH!C13,#REF!))","v":" "},null,null,{"$f":"IFERROR((VLOOKUP($C13,fuentes!$H$11:$P$19,7,0)),\" \")","v":11970.120000000004},{"$f":"IFERROR((VLOOKUP($C13,fuentes!$H$11:$P$19,8,0)),\" \")","v":11737.220000000007},0.98054321928268073,0.98054321928268073,{"$f":"IFERROR((VLOOKUP($C13,fuentes!$H$11:$Q$19,10,0)),\" \")","v":0},0.49466632669618238]
[null,null,{"$f":"fuentes!H17","v":"OFTALMOLOGICA"},{"$f":"IFERROR((VLOOKUP($C14,fuentes!$H$11:$P$19,2,0)),\" \")","v":6433.4600000000037},{"$f":"IFERROR((VLOOKUP($C14,fuentes!$H$11:$P$19,3,0)),\" \")","v":6438.4200000000028},{"$f":"IFERROR((VLOOKUP($C14,fuentes!$H$11:$P$19,4,0)),\" \")","v":6493.9499999999989},{"$f":"IFERROR((VLOOKUP($C14,fuentes!$H$11:$P$19,5,0)),\" \")","v":12932.370000000003},{"$f":"IFERROR((VLOOKUP($C14,fuentes!$H$11:$P$19,6,0)),\" \")","v":1.008624786826581},1.0007709692762525,1.0007709692762525,{"$f":"IF(fuentes!$B$14=1,\" \",SUMIF(#REF!,DASH!C14,#REF!))","v":" "},null,null,{"$f":"IFERROR((VLOOKUP($C14,fuentes!$H$11:$P$19,7,0)),\" \")","v":6501.2800000000025},{"$f":"IFERROR((VLOOKUP($C14,fuentes!$H$11:$P$19,8,0)),\" \")","v":6469.8899999999967},0.99517172003051613,0.99517172003051613,{"$f":"IFERROR((VLOOKUP($C14,fuentes!$H$11:$Q$19,10,0)),\" \")","v":0},0.50028649041126994]
[null,null,{"$f":"fuentes!H18","v":"GINECOLOCICA"},{"$f":"IFERROR((VLOOKUP($C15,fuentes!$H$11:$P$19,2,0)),\" \")","v":4720.6499999999996},{"$f":"IFERROR((VLOOKUP($C15,fuentes!$H$11:$P$19,3,0)),\" \")","v":4686.1000000000031},{"$f":"IFERROR((VLOOKUP($C15,fuentes!$H$11:$P$19,4,0)),\" \")","v":4749.3999999999969},{"$f":"IFERROR((VLOOKUP($C15,fuentes!$H$11:$P$19,5,0)),\" \")","v":9435.5},{"$f":"IFERROR((VLOOKUP($C15,fuentes!$H$11:$P$19,6,0)),\" \")","v":1.0135080343996061},0.99268109264614057,0.99268109264614057,{"$f":"IF(fuentes!$B$14=1,\" \",SUMIF(#REF!,DASH!C15,#REF!))","v":" "},null,null,{"$f":"IFERROR((VLOOKUP($C15,fuentes!$H$11:$P$19,7,0)),\" \")","v":4695.29},{"$f":"IFERROR((VLOOKUP($C15,fuentes!$H$11:$P$19,8,0)),\" \")","v":4589.2300000000032},0.97741140589825193,0.97741140589825193,{"$f":"IFERROR((VLOOKUP($C15,fuentes!$H$11:$Q$19,10,0)),\" \")","v":0},0.48637910020666664]
[" ",null,"Total general",{"$f":"VLOOKUP($C16,fuentes!$H$11:$P$19,2,0)","v":188352.1399999999},{"$f":"VLOOKUP($C16,fuentes!$H$11:$P$19,3,0)","v":186953.91000000021},{"$f":"VLOOKUP($C16,fuentes!$H$11:$P$19,4,0)","v":186864.96999999991},{"$f":"VLOOKUP($C16,fuentes!$H$11:$P$19,5,0)","v":373818.88},{"$f":"VLOOKUP($C16,fuentes!$H$11:$P$19,6,0)","v":0.99952426777273373},{"$f":"IFERROR((+E16/D16),0)","v":0.99257651120927171},0.99257651120927171,{"$f":"SUM(K9:K15)","v":0},null,null,{"$f":"VLOOKUP($C16,fuentes!$H$11:$P$19,7,0)","v":188730.05999999988},{"$f":"VLOOKUP($C16,fuentes!$H$11:$P$19,8,0)","v":186606.45},{"$f":"IFERROR((+O16/N16),0)","v":0.98874789739377034},0.98874789739377034,{"$f":"VLOOKUP($C16,fuentes!$H$11:$Q$19,10,0)","v":0},0.49918947379008788]
[null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,"MARCAS","PLAN (U)","VTA (U)","  VTA (U) BONIF."," TOT  VTA (U)"," %BONI. (U)","%CUM (U)",null,"FCST (U)",null,null," PLAN ($)"," VTA ($)","%CUM ($)",null,"NUR PLAN","NUR VTA",null,"($/.000)","ENE","FEB","MAR","ABR","MAY","JUN","JUL","AGO","SEP","OCT","NOV","DIC","TOTAL"]
[null,1,{"$f":"IFERROR((VLOOKUP($B19,fuentes!$G$71:$P$161,2,0)),\" \")","v":"Rótulos de fila"},{"$f":"IFERROR((VLOOKUP($B19,fuentes!$G$71:$P$161,3,0)),\" \")","v":"UNI PLAN"},{"$f":"VLOOKUP($B19,fuentes!$G$71:$P$161,4,0)","v":" UNI NET"},{"$f":"VLOOKUP($B19,fuentes!$G$71:$P$161,5,0)","v":" UNI BONIF."},{"$f":"VLOOKUP($B19,fuentes!$G$71:$P$161,6,0)","v":" TOT UNI"},{"$f":"IFERROR((VLOOKUP($B19,fuentes!$G$71:$P$161,7,0)),\" \")","v":" %Bonif."},{"$f":"IFERROR((+E19/D19),0)","v":0},{"$f":"IFERROR((+E19/D19),0)","v":0},{"$f":"IF(fuentes!$B$14=1,\" \",SUMIF(#REF!,DASH!C19,#REF!))","v":" "},null,null,{"$f":"VLOOKUP($B19,fuentes!$G$71:$P$161,8,0)","v":" VALOR_PLAN"},{"$f":"VLOOKUP($B19,fuentes!$G$71:$P$161,9,0)","v":" VENTA ($)"},{"$f":"IFERROR((+O19/N19),0)","v":0},{"$f":"IFERROR((+O19/N19),0)","v":0},{"$f":"VLOOKUP($B19,fuentes!$G$71:$Q$161,11,0)","v":0},{"$f":"IFERROR((+O19/G19),0)","v":0},null,{"$f":"\"Vta ($)  \"&fuentes!C5","v":"Vta ($)  2015"},{"$f":"VLOOKUP(fuentes!$X14,fuentes!$AB$13:$AQ$28,MATCH(fuentes!AE$1,fuentes!$AB$12:$AQ$12,0),0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(fuentes!$X14,fuentes!$AB$13:$AQ$28,MATCH(fuentes!AF$1,fuentes!$AB$12:$AQ$12,0),0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(fuentes!$X14,fuentes!$AB$13:$AQ$28,MATCH(fuentes!AG$1,fuentes!$AB$12:$AQ$12,0),0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(fuentes!$X14,fuentes!$AB$13:$AQ$28,MATCH(fuentes!AH$1,fuentes!$AB$12:$AQ$12,0),0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(fuentes!$X14,fuentes!$AB$13:$AQ$28,MATCH(fuentes!AI$1,fuentes!$AB$12:$AQ$12,0),0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(fuentes!$X14,fuentes!$AB$13:$AQ$28,MATCH(fuentes!AJ$1,fuentes!$AB$12:$AQ$12,0),0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(fuentes!$X14,fuentes!$AB$13:$AQ$28,MATCH(fuentes!AK$1,fuentes!$AB$12:$AQ$12,0),0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(fuentes!$X14,fuentes!$AB$13:$AQ$28,MATCH(fuentes!AL$1,fuentes!$AB$12:$AQ$12,0),0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(fuentes!$X14,fuentes!$AB$13:$AQ$28,MATCH(fuentes!AM$1,fuentes!$AB$12:$AQ$12,0),0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(fuentes!$X14,fuentes!$AB$13:$AQ$28,MATCH(fuentes!AN$1,fuentes!$AB$12:$AQ$12,0),0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(fuentes!$X14,fuentes!$AB$13:$AQ$28,MATCH(fuentes!AO$1,fuentes!$AB$12:$AQ$12,0),0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(fuentes!$X14,fuentes!$AB$13:$AQ$28,MATCH(fuentes!AP$1,fuentes!$AB$12:$AQ$12,0),0)","v":{"$error":"#N/A"}},{"$f":"SUM(V19:AG19)","v":{"$error":"#N/A"}}]
[null,{"$f":"+B19+1","v":2},{"$f":"VLOOKUP($B20,fuentes!$G$71:$P$161,2,0)","v":"MERC: 19-LINAGLIPTINA"},{"$f":"IFERROR((VLOOKUP($B20,fuentes!$G$71:$P$161,3,0)),\" \")","v":18199.980000000007},{"$f":"VLOOKUP($B20,fuentes!$G$71:$P$161,4,0)","v":18195.060000000016},{"$f":"VLOOKUP($B20,fuentes!$G$71:$P$161,5,0)","v":18134.279999999981},{"$f":"VLOOKUP($B20,fuentes!$G$71:$P$161,6,0)","v":36329.339999999997},{"$f":"IFERROR((VLOOKUP($B20,fuentes!$G$71:$P$161,7,0)),\" \")","v":0.99665953286221454},{"$f":"IFERROR((+E20/D20),0)","v":0.99972967003260493},{"$f":"IFERROR((+E20/D20),0)","v":0.99972967003260493},{"$f":"IF(fuentes!$B$14=1,\" \",SUMIF(#REF!,DASH!C20,#REF!))","v":" "},null,null,{"$f":"VLOOKUP($B20,fuentes!$G$71:$P$161,8,0)","v":18407.970000000005},{"$f":"VLOOKUP($B20,fuentes!$G$71:$P$161,9,0)","v":18224.069999999989},{"$f":"IFERROR((+O20/N20),0)","v":0.99000976207588254},{"$f":"IFERROR((+O20/N20),0)","v":0.99000976207588254},{"$f":"VLOOKUP($B20,fuentes!$G$71:$Q$161,11,0)","v":0},{"$f":"IFERROR((+O20/G20),0)","v":0.50163504208994691},null,{"$f":"\"Plan ($) \"&fuentes!C6","v":"Plan ($) 2016"},{"$f":"VLOOKUP(fuentes!$X15,fuentes!$AB$13:$AQ$28,MATCH(fuentes!AE$1,fuentes!$AB$12:$AQ$12,0),0)","v":2.11},{"$f":"VLOOKUP(fuentes!$X15,fuentes!$AB$13:$AQ$28,MATCH(fuentes!AF$1,fuentes!$AB$12:$AQ$12,0),0)","v":1.64},{"$f":"VLOOKUP(fuentes!$X15,fuentes!$AB$13:$AQ$28,MATCH(fuentes!AG$1,fuentes!$AB$12:$AQ$12,0),0)","v":1.45},{"$f":"VLOOKUP(fuentes!$X15,fuentes!$AB$13:$AQ$28,MATCH(fuentes!AH$1,fuentes!$AB$12:$AQ$12,0),0)","v":590.26},{"$f":"VLOOKUP(fuentes!$X15,fuentes!$AB$13:$AQ$28,MATCH(fuentes!AI$1,fuentes!$AB$12:$AQ$12,0),0)","v":1040.2},{"$f":"VLOOKUP(fuentes!$X15,fuentes!$AB$13:$AQ$28,MATCH(fuentes!AJ$1,fuentes!$AB$12:$AQ$12,0),0)","v":609.89},{"$f":"VLOOKUP(fuentes!$X15,fuentes!$AB$13:$AQ$28,MATCH(fuentes!AK$1,fuentes!$AB$12:$AQ$12,0),0)","v":613.97},{"$f":"VLOOKUP(fuentes!$X15,fuentes!$AB$13:$AQ$28,MATCH(fuentes!AL$1,fuentes!$AB$12:$AQ$12,0),0)","v":883.38},{"$f":"VLOOKUP(fuentes!$X15,fuentes!$AB$13:$AQ$28,MATCH(fuentes!AM$1,fuentes!$AB$12:$AQ$12,0),0)","v":807.55},{"$f":"VLOOKUP(fuentes!$X15,fuentes!$AB$13:$AQ$28,MATCH(fuentes!AN$1,fuentes!$AB$12:$AQ$12,0),0)","v":692.14},{"$f":"VLOOKUP(fuentes!$X15,fuentes!$AB$13:$AQ$28,MATCH(fuentes!AO$1,fuentes!$AB$12:$AQ$12,0),0)","v":688},{"$f":"VLOOKUP(fuentes!$X15,fuentes!$AB$13:$AQ$28,MATCH(fuentes!AP$1,fuentes!$AB$12:$AQ$12,0),0)","v":643.51},{"$f":"SUM(V20:AG20)","v":6574.1000000000013}]
[null,{"$f":"+B20+1","v":3},{"$f":"VLOOKUP($B21,fuentes!$G$71:$P$161,2,0)","v":"MERC: 18-GLYCEROL"},{"$f":"IFERROR((VLOOKUP($B21,fuentes!$G$71:$P$161,3,0)),\" \")","v":14606.680000000009},{"$f":"VLOOKUP($B21,fuentes!$G$71:$P$161,4,0)","v":14536.540000000003},{"$f":"VLOOKUP($B21,fuentes!$G$71:$P$161,5,0)","v":14529.92},{"$f":"VLOOKUP($B21,fuentes!$G$71:$P$161,6,0)","v":29066.460000000003},{"$f":"IFERROR((VLOOKUP($B21,fuentes!$G$71:$P$161,7,0)),\" \")","v":0.99954459589420852},0.99519808745039895,0.99519808745039895,{"$f":"IF(fuentes!$B$14=1,\" \",SUMIF(#REF!,DASH!C21,#REF!))","v":" "},null,null,{"$f":"VLOOKUP($B21,fuentes!$G$71:$P$161,8,0)","v":14540.80000000001},{"$f":"VLOOKUP($B21,fuentes!$G$71:$P$161,9,0)","v":14683.31000000001},1.0098006987235915,1.0098006987235915,{"$f":"VLOOKUP($B21,fuentes!$G$71:$Q$161,11,0)","v":0},0.50516333946411118,null,{"$f":"\"Vta ($)  \"&fuentes!C6","v":"Vta ($)  2016"},{"$f":"VLOOKUP(fuentes!$X16,fuentes!$AB$13:$AQ$28,MATCH(fuentes!AE$1,fuentes!$AB$12:$AQ$12,0),0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(fuentes!$X16,fuentes!$AB$13:$AQ$28,MATCH(fuentes!AF$1,fuentes!$AB$12:$AQ$12,0),0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(fuentes!$X16,fuentes!$AB$13:$AQ$28,MATCH(fuentes!AG$1,fuentes!$AB$12:$AQ$12,0),0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(fuentes!$X16,fuentes!$AB$13:$AQ$28,MATCH(fuentes!AH$1,fuentes!$AB$12:$AQ$12,0),0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(fuentes!$X16,fuentes!$AB$13:$AQ$28,MATCH(fuentes!AI$1,fuentes!$AB$12:$AQ$12,0),0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(fuentes!$X16,fuentes!$AB$13:$AQ$28,MATCH(fuentes!AJ$1,fuentes!$AB$12:$AQ$12,0),0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(fuentes!$X16,fuentes!$AB$13:$AQ$28,MATCH(fuentes!AK$1,fuentes!$AB$12:$AQ$12,0),0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(fuentes!$X16,fuentes!$AB$13:$AQ$28,MATCH(fuentes!AL$1,fuentes!$AB$12:$AQ$12,0),0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(fuentes!$X16,fuentes!$AB$13:$AQ$28,MATCH(fuentes!AM$1,fuentes!$AB$12:$AQ$12,0),0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(fuentes!$X16,fuentes!$AB$13:$AQ$28,MATCH(fuentes!AN$1,fuentes!$AB$12:$AQ$12,0),0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(fuentes!$X16,fuentes!$AB$13:$AQ$28,MATCH(fuentes!AO$1,fuentes!$AB$12:$AQ$12,0),0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(fuentes!$X16,fuentes!$AB$13:$AQ$28,MATCH(fuentes!AP$1,fuentes!$AB$12:$AQ$12,0),0)","v":{"$error":"#N/A"}},{"$f":"SUM(V21:AG21)","v":{"$error":"#N/A"}}]
[null,4,{"$f":"VLOOKUP($B22,fuentes!$G$71:$P$161,2,0)","v":"MERC: 32-COM_B"},{"$f":"IFERROR((VLOOKUP($B22,fuentes!$G$71:$P$161,3,0)),\" \")","v":14043.320000000009},{"$f":"VLOOKUP($B22,fuentes!$G$71:$P$161,4,0)","v":13778.859999999997},{"$f":"VLOOKUP($B22,fuentes!$G$71:$P$161,5,0)","v":13943.989999999991},{"$f":"VLOOKUP($B22,fuentes!$G$71:$P$161,6,0)","v":27722.849999999988},{"$f":"IFERROR((VLOOKUP($B22,fuentes!$G$71:$P$161,7,0)),\" \")","v":1.0119843005880018},0.98116827075079027,0.98116827075079027,{"$f":"IF(fuentes!$B$14=1,\" \",SUMIF(#REF!,DASH!C22,#REF!))","v":" "},null,null,{"$f":"VLOOKUP($B22,fuentes!$G$71:$P$161,8,0)","v":14040.840000000009},{"$f":"VLOOKUP($B22,fuentes!$G$71:$P$161,9,0)","v":14079.400000000005},1.0027462744394207,1.0027462744394207,{"$f":"VLOOKUP($B22,fuentes!$G$71:$Q$161,11,0)","v":0},0.50786264759936339,null,"% CUM ($)",{"$f":"IFERROR((+V21/V20),\" \")","v":" "},{"$f":"IFERROR((+W21/W20),\" \")","v":" "}," "," "," "," "," "," "," "," "," "," "," "]
[null,5,{"$f":"VLOOKUP($B23,fuentes!$G$71:$P$161,2,0)","v":"MERC: 25-FAMOTIDINA"},{"$f":"IFERROR((VLOOKUP($B23,fuentes!$G$71:$P$161,3,0)),\" \")","v":7034.069999999997},{"$f":"VLOOKUP($B23,fuentes!$G$71:$P$161,4,0)","v":6593.329999999999},{"$f":"VLOOKUP($B23,fuentes!$G$71:$P$161,5,0)","v":6667.4399999999969},{"$f":"VLOOKUP($B23,fuentes!$G$71:$P$161,6,0)","v":13260.769999999997},{"$f":"IFERROR((VLOOKUP($B23,fuentes!$G$71:$P$161,7,0)),\" \")","v":1.0112401472397101},0.93734210776975524,0.93734210776975524,{"$f":"IF(fuentes!$B$14=1,\" \",SUMIF(#REF!,DASH!C23,#REF!))","v":" "},null,null,{"$f":"VLOOKUP($B23,fuentes!$G$71:$P$161,8,0)","v":6985.54},{"$f":"VLOOKUP($B23,fuentes!$G$71:$P$161,9,0)","v":6624.1399999999976},0.9482645579296658,0.9482645579296658,{"$f":"VLOOKUP($B23,fuentes!$G$71:$Q$161,11,0)","v":0},0.49952906203787556,null,{"$f":"\"Vta (U)   \"&fuentes!C5","v":"Vta (U)   2015"},{"$f":"VLOOKUP(fuentes!$X18,fuentes!$AB$13:$AQ$28,MATCH(fuentes!AE$1,fuentes!$AB$12:$AQ$12,0),0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(fuentes!$X18,fuentes!$AB$13:$AQ$28,MATCH(fuentes!AF$1,fuentes!$AB$12:$AQ$12,0),0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(fuentes!$X18,fuentes!$AB$13:$AQ$28,MATCH(fuentes!AG$1,fuentes!$AB$12:$AQ$12,0),0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(fuentes!$X18,fuentes!$AB$13:$AQ$28,MATCH(fuentes!AH$1,fuentes!$AB$12:$AQ$12,0),0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(fuentes!$X18,fuentes!$AB$13:$AQ$28,MATCH(fuentes!AI$1,fuentes!$AB$12:$AQ$12,0),0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(fuentes!$X18,fuentes!$AB$13:$AQ$28,MATCH(fuentes!AJ$1,fuentes!$AB$12:$AQ$12,0),0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(fuentes!$X18,fuentes!$AB$13:$AQ$28,MATCH(fuentes!AK$1,fuentes!$AB$12:$AQ$12,0),0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(fuentes!$X18,fuentes!$AB$13:$AQ$28,MATCH(fuentes!AL$1,fuentes!$AB$12:$AQ$12,0),0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(fuentes!$X18,fuentes!$AB$13:$AQ$28,MATCH(fuentes!AM$1,fuentes!$AB$12:$AQ$12,0),0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(fuentes!$X18,fuentes!$AB$13:$AQ$28,MATCH(fuentes!AN$1,fuentes!$AB$12:$AQ$12,0),0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(fuentes!$X18,fuentes!$AB$13:$AQ$28,MATCH(fuentes!AO$1,fuentes!$AB$12:$AQ$12,0),0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(fuentes!$X18,fuentes!$AB$13:$AQ$28,MATCH(fuentes!AP$1,fuentes!$AB$12:$AQ$12,0),0)","v":{"$error":"#N/A"}},{"$f":"SUM(V23:AG23)","v":{"$error":"#N/A"}}]
[null,6,{"$f":"IFERROR((VLOOKUP($B24,fuentes!$G$71:$P$161,2,0)),\" \")","v":"MERC: 36-CHLORMADINONE"},{"$f":"IFERROR((VLOOKUP($B24,fuentes!$G$71:$P$161,3,0)),\" \")","v":6619.6100000000015},{"$f":"VLOOKUP($B24,fuentes!$G$71:$P$161,4,0)","v":6554.5900000000029},{"$f":"VLOOKUP($B24,fuentes!$G$71:$P$161,5,0)","v":6528.4299999999994},{"$f":"VLOOKUP($B24,fuentes!$G$71:$P$161,6,0)","v":13083.020000000002},{"$f":"IFERROR((VLOOKUP($B24,fuentes!$G$71:$P$161,7,0)),\" \")","v":0.99600890368428785},0.99017766907718152,0.99017766907718152,{"$f":"IF(fuentes!$B$14=1,\" \",SUMIF(#REF!,DASH!C24,#REF!))","v":" "},null,null,{"$f":"VLOOKUP($B24,fuentes!$G$71:$P$161,8,0)","v":6661.7300000000023},{"$f":"VLOOKUP($B24,fuentes!$G$71:$P$161,9,0)","v":6574.3400000000038},0.98688178596250542,0.98688178596250542,{"$f":"VLOOKUP($B24,fuentes!$G$71:$Q$161,11,0)","v":0},0.50250935945981912,null,{"$f":"\"Plan( U)  \"&fuentes!C6","v":"Plan( U)  2016"},{"$f":"VLOOKUP(fuentes!$X19,fuentes!$AB$13:$AQ$28,MATCH(fuentes!AE$1,fuentes!$AB$12:$AQ$12,0),0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(fuentes!$X19,fuentes!$AB$13:$AQ$28,MATCH(fuentes!AF$1,fuentes!$AB$12:$AQ$12,0),0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(fuentes!$X19,fuentes!$AB$13:$AQ$28,MATCH(fuentes!AG$1,fuentes!$AB$12:$AQ$12,0),0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(fuentes!$X19,fuentes!$AB$13:$AQ$28,MATCH(fuentes!AH$1,fuentes!$AB$12:$AQ$12,0),0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(fuentes!$X19,fuentes!$AB$13:$AQ$28,MATCH(fuentes!AI$1,fuentes!$AB$12:$AQ$12,0),0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(fuentes!$X19,fuentes!$AB$13:$AQ$28,MATCH(fuentes!AJ$1,fuentes!$AB$12:$AQ$12,0),0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(fuentes!$X19,fuentes!$AB$13:$AQ$28,MATCH(fuentes!AK$1,fuentes!$AB$12:$AQ$12,0),0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(fuentes!$X19,fuentes!$AB$13:$AQ$28,MATCH(fuentes!AL$1,fuentes!$AB$12:$AQ$12,0),0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(fuentes!$X19,fuentes!$AB$13:$AQ$28,MATCH(fuentes!AM$1,fuentes!$AB$12:$AQ$12,0),0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(fuentes!$X19,fuentes!$AB$13:$AQ$28,MATCH(fuentes!AN$1,fuentes!$AB$12:$AQ$12,0),0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(fuentes!$X19,fuentes!$AB$13:$AQ$28,MATCH(fuentes!AO$1,fuentes!$AB$12:$AQ$12,0),0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(fuentes!$X19,fuentes!$AB$13:$AQ$28,MATCH(fuentes!AP$1,fuentes!$AB$12:$AQ$12,0),0)","v":{"$error":"#N/A"}},{"$f":"SUM(V24:AG24)","v":{"$error":"#N/A"}}]
[null,7,{"$f":"VLOOKUP($B25,fuentes!$G$71:$P$161,2,0)","v":"MERC: 40-EPROSAR"},{"$f":"IFERROR((VLOOKUP($B25,fuentes!$G$71:$P$161,3,0)),\" \")","v":3267.7499999999995},{"$f":"VLOOKUP($B25,fuentes!$G$71:$P$161,4,0)","v":3345.6},{"$f":"VLOOKUP($B25,fuentes!$G$71:$P$161,5,0)","v":3232.06},{"$f":"VLOOKUP($B25,fuentes!$G$71:$P$161,6,0)","v":6577.66},{"$f":"IFERROR((VLOOKUP($B25,fuentes!$G$71:$P$161,7,0)),\" \")","v":0.96606288857006217},1.0238237319256369,1.0238237319256369,{"$f":"IF(fuentes!$B$14=1,\" \",SUMIF(#REF!,DASH!C25,#REF!))","v":" "},null,null,{"$f":"VLOOKUP($B25,fuentes!$G$71:$P$161,8,0)","v":3311.88},{"$f":"VLOOKUP($B25,fuentes!$G$71:$P$161,9,0)","v":3320.44},1.0025846347089871,1.0025846347089871,{"$f":"VLOOKUP($B25,fuentes!$G$71:$Q$161,11,0)","v":0},0.50480566037162156,null,{"$f":"\"Vta( U)  \"&fuentes!C6","v":"Vta( U)  2016"},{"$f":"VLOOKUP(fuentes!$X20,fuentes!$AB$13:$AQ$28,MATCH(fuentes!AE$1,fuentes!$AB$12:$AQ$12,0),0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(fuentes!$X20,fuentes!$AB$13:$AQ$28,MATCH(fuentes!AF$1,fuentes!$AB$12:$AQ$12,0),0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(fuentes!$X20,fuentes!$AB$13:$AQ$28,MATCH(fuentes!AG$1,fuentes!$AB$12:$AQ$12,0),0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(fuentes!$X20,fuentes!$AB$13:$AQ$28,MATCH(fuentes!AH$1,fuentes!$AB$12:$AQ$12,0),0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(fuentes!$X20,fuentes!$AB$13:$AQ$28,MATCH(fuentes!AI$1,fuentes!$AB$12:$AQ$12,0),0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(fuentes!$X20,fuentes!$AB$13:$AQ$28,MATCH(fuentes!AJ$1,fuentes!$AB$12:$AQ$12,0),0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(fuentes!$X20,fuentes!$AB$13:$AQ$28,MATCH(fuentes!AK$1,fuentes!$AB$12:$AQ$12,0),0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(fuentes!$X20,fuentes!$AB$13:$AQ$28,MATCH(fuentes!AL$1,fuentes!$AB$12:$AQ$12,0),0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(fuentes!$X20,fuentes!$AB$13:$AQ$28,MATCH(fuentes!AM$1,fuentes!$AB$12:$AQ$12,0),0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(fuentes!$X20,fuentes!$AB$13:$AQ$28,MATCH(fuentes!AN$1,fuentes!$AB$12:$AQ$12,0),0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(fuentes!$X20,fuentes!$AB$13:$AQ$28,MATCH(fuentes!AO$1,fuentes!$AB$12:$AQ$12,0),0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(fuentes!$X20,fuentes!$AB$13:$AQ$28,MATCH(fuentes!AP$1,fuentes!$AB$12:$AQ$12,0),0)","v":{"$error":"#N/A"}},{"$f":"SUM(V25:AG25)","v":{"$error":"#N/A"}}]
[null,8,{"$f":"VLOOKUP($B26,fuentes!$G$71:$P$161,2,0)","v":"MERC: 28-GLYCEROL"},{"$f":"IFERROR((VLOOKUP($B26,fuentes!$G$71:$P$161,3,0)),\" \")","v":3206.6499999999996},{"$f":"VLOOKUP($B26,fuentes!$G$71:$P$161,4,0)","v":3089.7599999999998},{"$f":"VLOOKUP($B26,fuentes!$G$71:$P$161,5,0)","v":3151.9999999999995},{"$f":"VLOOKUP($B26,fuentes!$G$71:$P$161,6,0)","v":6241.7599999999993},{"$f":"IFERROR((VLOOKUP($B26,fuentes!$G$71:$P$161,7,0)),\" \")","v":1.0201439594013775},0.96354762758642198,0.96354762758642198,{"$f":"IF(fuentes!$B$14=1,\" \",SUMIF(#REF!,DASH!C26,#REF!))","v":" "},null,null,{"$f":"VLOOKUP($B26,fuentes!$G$71:$P$161,8,0)","v":3141.7299999999987},{"$f":"VLOOKUP($B26,fuentes!$G$71:$P$161,9,0)","v":3069.8799999999992},0.9771304345058297,0.9771304345058297,{"$f":"VLOOKUP($B26,fuentes!$G$71:$Q$161,11,0)","v":0},0.4918292276537386,null,{"$f":"\"Tot Vta (U)\"&fuentes!C6","v":"Tot Vta (U)2016"},{"$f":"VLOOKUP(fuentes!$X21,fuentes!$AB$13:$AQ$28,MATCH(fuentes!AE$1,fuentes!$AB$12:$AQ$12,0),0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(fuentes!$X21,fuentes!$AB$13:$AQ$28,MATCH(fuentes!AF$1,fuentes!$AB$12:$AQ$12,0),0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(fuentes!$X21,fuentes!$AB$13:$AQ$28,MATCH(fuentes!AG$1,fuentes!$AB$12:$AQ$12,0),0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(fuentes!$X21,fuentes!$AB$13:$AQ$28,MATCH(fuentes!AH$1,fuentes!$AB$12:$AQ$12,0),0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(fuentes!$X21,fuentes!$AB$13:$AQ$28,MATCH(fuentes!AI$1,fuentes!$AB$12:$AQ$12,0),0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(fuentes!$X21,fuentes!$AB$13:$AQ$28,MATCH(fuentes!AJ$1,fuentes!$AB$12:$AQ$12,0),0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(fuentes!$X21,fuentes!$AB$13:$AQ$28,MATCH(fuentes!AK$1,fuentes!$AB$12:$AQ$12,0),0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(fuentes!$X21,fuentes!$AB$13:$AQ$28,MATCH(fuentes!AL$1,fuentes!$AB$12:$AQ$12,0),0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(fuentes!$X21,fuentes!$AB$13:$AQ$28,MATCH(fuentes!AM$1,fuentes!$AB$12:$AQ$12,0),0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(fuentes!$X21,fuentes!$AB$13:$AQ$28,MATCH(fuentes!AN$1,fuentes!$AB$12:$AQ$12,0),0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(fuentes!$X21,fuentes!$AB$13:$AQ$28,MATCH(fuentes!AO$1,fuentes!$AB$12:$AQ$12,0),0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(fuentes!$X21,fuentes!$AB$13:$AQ$28,MATCH(fuentes!AP$1,fuentes!$AB$12:$AQ$12,0),0)","v":{"$error":"#N/A"}},{"$f":"SUM(V26:AG26)","v":{"$error":"#N/A"}}]
[null,9,{"$f":"VLOOKUP($B27,fuentes!$G$71:$P$161,2,0)","v":"MERC: 23-ACITRETIN"},{"$f":"IFERROR((VLOOKUP($B27,fuentes!$G$71:$P$161,3,0)),\" \")","v":2894.4700000000003},{"$f":"VLOOKUP($B27,fuentes!$G$71:$P$161,4,0)","v":2945.1600000000003},{"$f":"VLOOKUP($B27,fuentes!$G$71:$P$161,5,0)","v":2939.5600000000004},{"$f":"VLOOKUP($B27,fuentes!$G$71:$P$161,6,0)","v":5884.7200000000012},{"$f":"IFERROR((VLOOKUP($B27,fuentes!$G$71:$P$161,7,0)),\" \")","v":0.99809857528962775},1.0175127052621034,1.0175127052621034,{"$f":"IF(fuentes!$B$14=1,\" \",SUMIF(#REF!,DASH!C27,#REF!))","v":" "},null,null,{"$f":"VLOOKUP($B27,fuentes!$G$71:$P$161,8,0)","v":2917.5499999999997},{"$f":"VLOOKUP($B27,fuentes!$G$71:$P$161,9,0)","v":2916.54},0.99965381912906381,0.99965381912906381,{"$f":"VLOOKUP($B27,fuentes!$G$71:$Q$161,11,0)","v":0},{"$f":"IFERROR((+O27/G27),0)","v":0.49561236558408883},null,"% CUM (U)",{"$f":"IFERROR((+V25/V24),\" \")","v":" "},{"$f":"IFERROR((+W25/W24),\" \")","v":" "}," ",{"$f":"IFERROR((+Y25/Y24),\" \")","v":" "}," "," "," "," "," "," "," "," "," "]
[null,10,{"$f":"VLOOKUP($B28,fuentes!$G$71:$P$161,2,0)","v":"MERC: 46-LINCOMICINA"},{"$f":"IFERROR((VLOOKUP($B28,fuentes!$G$71:$P$161,3,0)),\" \")","v":2815.0000000000005},{"$f":"VLOOKUP($B28,fuentes!$G$71:$P$161,4,0)","v":2815.8600000000006},{"$f":"VLOOKUP($B28,fuentes!$G$71:$P$161,5,0)","v":2770.5399999999991},{"$f":"VLOOKUP($B28,fuentes!$G$71:$P$161,6,0)","v":5586.4},{"$f":"IFERROR((VLOOKUP($B28,fuentes!$G$71:$P$161,7,0)),\" \")","v":0.9839054498448071},1.0003055062166963,1.0003055062166963,{"$f":"IF(fuentes!$B$14=1,\" \",SUMIF(#REF!,DASH!C28,#REF!))","v":" "},null,null,{"$f":"VLOOKUP($B28,fuentes!$G$71:$P$161,8,0)","v":2873.3100000000004},{"$f":"VLOOKUP($B28,fuentes!$G$71:$P$161,9,0)","v":2842.2599999999993},0.98919364774423879,0.98919364774423879,{"$f":"VLOOKUP($B28,fuentes!$G$71:$Q$161,11,0)","v":0},0.5087820421022482,null,"% BON (U)",{"$f":"VLOOKUP(fuentes!$X23,fuentes!$AB$13:$AQ$28,MATCH(fuentes!AE$1,fuentes!$AB$12:$AQ$12,0),0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(fuentes!$X23,fuentes!$AB$13:$AQ$28,MATCH(fuentes!AF$1,fuentes!$AB$12:$AQ$12,0),0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(fuentes!$X23,fuentes!$AB$13:$AQ$28,MATCH(fuentes!AG$1,fuentes!$AB$12:$AQ$12,0),0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(fuentes!$X23,fuentes!$AB$13:$AQ$28,MATCH(fuentes!AH$1,fuentes!$AB$12:$AQ$12,0),0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(fuentes!$X23,fuentes!$AB$13:$AQ$28,MATCH(fuentes!AI$1,fuentes!$AB$12:$AQ$12,0),0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(fuentes!$X23,fuentes!$AB$13:$AQ$28,MATCH(fuentes!AJ$1,fuentes!$AB$12:$AQ$12,0),0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(fuentes!$X23,fuentes!$AB$13:$AQ$28,MATCH(fuentes!AK$1,fuentes!$AB$12:$AQ$12,0),0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(fuentes!$X23,fuentes!$AB$13:$AQ$28,MATCH(fuentes!AL$1,fuentes!$AB$12:$AQ$12,0),0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(fuentes!$X23,fuentes!$AB$13:$AQ$28,MATCH(fuentes!AM$1,fuentes!$AB$12:$AQ$12,0),0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(fuentes!$X23,fuentes!$AB$13:$AQ$28,MATCH(fuentes!AN$1,fuentes!$AB$12:$AQ$12,0),0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(fuentes!$X23,fuentes!$AB$13:$AQ$28,MATCH(fuentes!AO$1,fuentes!$AB$12:$AQ$12,0),0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(fuentes!$X23,fuentes!$AB$13:$AQ$28,MATCH(fuentes!AP$1,fuentes!$AB$12:$AQ$12,0),0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(fuentes!$X23,fuentes!$AB$13:$AQ$28,MATCH(fuentes!AQ$1,fuentes!$AB$12:$AQ$12,0),0)","v":{"$error":"#N/A"}}]
[null,11,{"$f":"VLOOKUP($B29,fuentes!$G$71:$P$161,2,0)","v":"MERC: 1069-ERITROPOYETINA"},{"$f":"IFERROR((VLOOKUP($B29,fuentes!$G$71:$P$161,3,0)),\" \")","v":2121.3900000000003},{"$f":"VLOOKUP($B29,fuentes!$G$71:$P$161,4,0)","v":2057.5200000000013},{"$f":"VLOOKUP($B29,fuentes!$G$71:$P$161,5,0)","v":2084.8399999999997},{"$f":"VLOOKUP($B29,fuentes!$G$71:$P$161,6,0)","v":4142.3600000000006},{"$f":"IFERROR((VLOOKUP($B29,fuentes!$G$71:$P$161,7,0)),\" \")","v":1.0132781212333286},0.96989238188169125,0.96989238188169125,{"$f":"IF(fuentes!$B$14=1,\" \",SUMIF(#REF!,DASH!C29,#REF!))","v":" "},null,null,{"$f":"VLOOKUP($B29,fuentes!$G$71:$P$161,8,0)","v":2095.1400000000003},{"$f":"VLOOKUP($B29,fuentes!$G$71:$P$161,9,0)","v":2121.7199999999993},{"$f":"IFERROR((+O29/N29),0)","v":1.012686503049915},1.012686503049915,{"$f":"VLOOKUP($B29,fuentes!$G$71:$Q$161,11,0)","v":0},{"$f":"IFERROR((+O29/G29),0)","v":0.51220077443775991},null,"P.P PLAN",{"$f":"IFERROR((+V20/V24),0)","v":0},{"$f":"IFERROR((+W20/W24),0)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,12,{"$f":"VLOOKUP($B30,fuentes!$G$71:$P$161,2,0)","v":"MERC: 33-LOSARTAN"},{"$f":"IFERROR((VLOOKUP($B30,fuentes!$G$71:$P$161,3,0)),\" \")","v":2108.9299999999998},{"$f":"VLOOKUP($B30,fuentes!$G$71:$P$161,4,0)","v":2131.5499999999997},{"$f":"VLOOKUP($B30,fuentes!$G$71:$P$161,5,0)","v":2068.0300000000002},{"$f":"VLOOKUP($B30,fuentes!$G$71:$P$161,6,0)","v":4199.58},{"$f":"IFERROR((VLOOKUP($B30,fuentes!$G$71:$P$161,7,0)),\" \")","v":0.97020008913701317},1.0107258183059655,1.0107258183059655,{"$f":"IF(fuentes!$B$14=1,\" \",SUMIF(#REF!,DASH!C30,#REF!))","v":" "},null,null,{"$f":"VLOOKUP($B30,fuentes!$G$71:$P$161,8,0)","v":2071.06},{"$f":"VLOOKUP($B30,fuentes!$G$71:$P$161,9,0)","v":2072.8200000000002},1.0008498063793421,1.0008498063793421,{"$f":"VLOOKUP($B30,fuentes!$G$71:$Q$161,11,0)","v":0},0.49357792922149363,null,"P.P VTA",{"$f":"IFERROR((+V21/V26),0)","v":0},{"$f":"IFERROR((+W21/W26),0)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Total general",{"$f":"+fuentes!I69","v":82743.280000000028},{"$f":"+fuentes!J69","v":81922.71000000005},{"$f":"+fuentes!K69","v":81925.599999999948},{"$f":"+fuentes!L69","v":163848.30999999997},{"$f":"IFERROR((+F31/E31),0)","v":1.0000352771533059},{"$f":"IFERROR((+E31/D31),0)","v":0.99008294087447368},0.99008294087447368,{"$f":"SUM(K19:K30)","v":0},null,null,{"$f":"+fuentes!N69","v":82794.180000000022},{"$f":"+fuentes!O69","v":82383.099999999991},{"$f":"IFERROR((+O31/N31),0)","v":0.99503491670549749},0.99503491670549749,{"$f":"+fuentes!Q69","v":0},{"$f":"IFERROR((+O31/G31),0)","v":0.50280103590937253}]
[]
[null,null,null,null,null,null,null,null,null,null," ",null,null,null,null,null,null,null,null,null,{"$f":"\"Selección actual : \"&fuentes!AD7&\" - \"&fuentes!AB67&\"-\"&fuentes!AA4","v":"Selección actual : (Varios elementos) - MERC: 18-GLYCEROL- "}]
[null,null,"ITEMS","PLAN (U)","VTA (U)","  VTA (U) BONIF."," TOT  VTA (U)"," %BONI. (U)","%CUM (U)",null,"FCST (U) ","FCST (U) cump",null," PLAN ($)"," VTA ($)","%CUM ($)",null,"NUR PLAN","NUR VTA",null,"CLIENTES","PLAN (U)","VTA (U)","  VTA (U) BONIF."," TOT  VTA (U)"," %BONI. (U)","%CUM (U)",null," PLAN ($)"," VTA ($)","%CUM ($)",null,"NUR VTA"]
[{"$f":"VLOOKUP($B35,fuentes!$Z$71:$AM$186,12,0)","v":"(ALL)"},6,{"$f":"VLOOKUP($B35,fuentes!$Z$71:$AM$186,11,0)","v":"CLOTRIMAZOL SOFT JABON LIQD 120 ML x 1"},{"$f":"VLOOKUP($B35,fuentes!$Z$71:$AM$186,3,0)","v":1652.89},{"$f":"VLOOKUP($B35,fuentes!$Z$71:$AM$186,4,0)","v":1649.6099999999997},{"$f":"VLOOKUP($B35,fuentes!$Z$71:$AM$186,5,0)","v":1646.7599999999998},{"$f":"VLOOKUP($B35,fuentes!$Z$71:$AM$186,6,0)","v":3296.3699999999994},{"$f":"VLOOKUP($B35,fuentes!$Z$71:$AM$186,7,0)","v":0.99827231891174284},{"$f":"IF(C35=\"\",\" \",(IFERROR((+E35/D35),0)))","v":0.99801559692417496},{"$f":"IF(C35=\"\",\" \",(IFERROR((+E35/D35),0)))","v":0.99801559692417496},{"$f":"IF(C35=\"\",\" \",(IF(fuentes!$B$14=1,\" \",SUMIF(#REF!,DASH!A35,#REF!))))","v":" "},{"$f":"IFERROR((+G35/K35),\" \")","v":" "},{"$f":"IFERROR((+G35/K35),\" \")","v":" "},{"$f":"VLOOKUP($B35,fuentes!$Z$71:$AM$186,8,0)","v":1680.9400000000003},{"$f":"VLOOKUP($B35,fuentes!$Z$71:$AM$186,9,0)","v":1723.7399999999998},{"$f":"IFERROR((+O35/N35),0)","v":1.0254619439123345},{"$f":"IFERROR((+O35/N35),0)","v":1.0254619439123345},{"$f":"VLOOKUP($B35,fuentes!$Z$71:$AM$186,13,0)","v":0},{"$f":"IFERROR((+O35/G35),0)","v":0.52292066727946196},null,"DIFARE",{"$f":"IFERROR((VLOOKUP($U35,fuentes!$H$41:$N$49,2,0)),\" \")","v":" "},{"$f":"IFERROR((VLOOKUP($U35,fuentes!$H$41:$N$49,3,0)),\" \")","v":" "},{"$f":"IFERROR((VLOOKUP($U35,fuentes!$H$41:$N$49,4,0)),\" \")","v":" "},{"$f":"IFERROR((VLOOKUP($U35,fuentes!$H$41:$N$49,5,0)),\" \")","v":" "},{"$f":"IFERROR((VLOOKUP($U35,fuentes!$H$41:$N$49,6,0)),\" \")","v":" "},{"$f":"IFERROR((+W35/V35),0)","v":0},{"$f":"IFERROR((+W35/V35),0)","v":0},{"$f":"IFERROR((VLOOKUP($U35,fuentes!$H$41:$N$49,7,0)),\" \")","v":" "},{"$f":"IFERROR((VLOOKUP($U35,fuentes!$H$41:$Q$49,8,0)),\" \")","v":" "},{"$f":"IFERROR((+AD35/AC35),0)","v":0},{"$f":"IFERROR((+AD35/AC35),0)","v":0},{"$f":"IFERROR((+AE35/Z35),\" \")","v":" "}]
[{"$f":"VLOOKUP($B36,fuentes!$Z$71:$AM$186,12,0)","v":"/25M"},{"$f":"+B35+1","v":7},{"$f":"VLOOKUP($B36,fuentes!$Z$71:$AM$186,11,0)","v":"TRAMAD TABL 25 MG x 30 (/25M)"},{"$f":"VLOOKUP($B36,fuentes!$Z$71:$AM$186,3,0)","v":1282.1399999999999},{"$f":"VLOOKUP($B36,fuentes!$Z$71:$AM$186,4,0)","v":1330.16},{"$f":"VLOOKUP($B36,fuentes!$Z$71:$AM$186,5,0)","v":1292.1200000000001},{"$f":"VLOOKUP($B36,fuentes!$Z$71:$AM$186,6,0)","v":2622.28},{"$f":"VLOOKUP($B36,fuentes!$Z$71:$AM$186,7,0)","v":0.97140193660912977},1.0374530082518292,1.0374530082518292,{"$f":"IF(C36=\"\",\" \",(IF(fuentes!$B$14=1,\" \",SUMIF(#REF!,DASH!A36,#REF!))))","v":" "}," "," ",{"$f":"VLOOKUP($B36,fuentes!$Z$71:$AM$186,8,0)","v":1266.0600000000002},{"$f":"VLOOKUP($B36,fuentes!$Z$71:$AM$186,9,0)","v":1333.2200000000005},1.0530464590935662,1.0530464590935662,{"$f":"VLOOKUP($B36,fuentes!$Z$71:$AM$186,13,0)","v":0},0.50842015345424607,null,"FARMAENLACE",{"$f":"IFERROR((VLOOKUP($U36,fuentes!$H$41:$N$49,2,0)),\" \")","v":" "},{"$f":"IFERROR((VLOOKUP($U36,fuentes!$H$41:$N$49,3,0)),\" \")","v":" "},{"$f":"IFERROR((VLOOKUP($U36,fuentes!$H$41:$N$49,4,0)),\" \")","v":" "},{"$f":"IFERROR((VLOOKUP($U36,fuentes!$H$41:$N$49,5,0)),\" \")","v":" "},{"$f":"IFERROR((VLOOKUP($U36,fuentes!$H$41:$N$49,6,0)),\" \")","v":" "},{"$f":"IFERROR((+W36/V36),0)","v":0},0,{"$f":"IFERROR((VLOOKUP($U36,fuentes!$H$41:$N$49,7,0)),\" \")","v":" "},{"$f":"IFERROR((VLOOKUP($U36,fuentes!$H$41:$Q$49,8,0)),\" \")","v":" "},{"$f":"IFERROR((+AD36/AC36),0)","v":0},{"$f":"IFERROR((+AD36/AC36),0)","v":0}," "]
[{"$f":"VLOOKUP($B37,fuentes!$Z$71:$AM$186,12,0)","v":"(ALL)"},8,{"$f":"VLOOKUP($B37,fuentes!$Z$71:$AM$186,11,0)","v":"GLYCEROL SP.F30.BRON 200 ML x 1"},{"$f":"VLOOKUP($B37,fuentes!$Z$71:$AM$186,3,0)","v":1430.86},{"$f":"VLOOKUP($B37,fuentes!$Z$71:$AM$186,4,0)","v":1423.4900000000002},{"$f":"VLOOKUP($B37,fuentes!$Z$71:$AM$186,5,0)","v":1434.4999999999998},{"$f":"VLOOKUP($B37,fuentes!$Z$71:$AM$186,6,0)","v":2857.99},{"$f":"VLOOKUP($B37,fuentes!$Z$71:$AM$186,7,0)","v":1.007734511657967},0.99484925149909864,0.99484925149909864,{"$f":"IF(C37=\"\",\" \",(IF(fuentes!$B$14=1,\" \",SUMIF(#REF!,DASH!A37,#REF!))))","v":" "}," "," ",{"$f":"VLOOKUP($B37,fuentes!$Z$71:$AM$186,8,0)","v":1490.53},{"$f":"VLOOKUP($B37,fuentes!$Z$71:$AM$186,9,0)","v":1434.8799999999999},0.96266428719985497,0.96266428719985497,{"$f":"VLOOKUP($B37,fuentes!$Z$71:$AM$186,13,0)","v":0},0.50205913946514857,null,"FYBECA",{"$f":"IFERROR((VLOOKUP($U37,fuentes!$H$41:$N$49,2,0)),\" \")","v":" "},{"$f":"IFERROR((VLOOKUP($U37,fuentes!$H$41:$N$49,3,0)),\" \")","v":" "},{"$f":"IFERROR((VLOOKUP($U37,fuentes!$H$41:$N$49,4,0)),\" \")","v":" "},{"$f":"IFERROR((VLOOKUP($U37,fuentes!$H$41:$N$49,5,0)),\" \")","v":" "},{"$f":"IFERROR((VLOOKUP($U37,fuentes!$H$41:$N$49,6,0)),\" \")","v":" "},0,0,{"$f":"IFERROR((VLOOKUP($U37,fuentes!$H$41:$N$49,7,0)),\" \")","v":" "},{"$f":"IFERROR((VLOOKUP($U37,fuentes!$H$41:$Q$49,8,0)),\" \")","v":" "},0,0," "]
[{"$f":"VLOOKUP($B38,fuentes!$Z$71:$AM$186,12,0)","v":"(ALL)"},9,{"$f":"VLOOKUP($B38,fuentes!$Z$71:$AM$186,11,0)","v":"RIVASTIG A.IV LIOF 2 MG x 5"},{"$f":"VLOOKUP($B38,fuentes!$Z$71:$AM$186,3,0)","v":655.33000000000004},{"$f":"VLOOKUP($B38,fuentes!$Z$71:$AM$186,4,0)","v":630.67999999999995},{"$f":"VLOOKUP($B38,fuentes!$Z$71:$AM$186,5,0)","v":647.30999999999995},{"$f":"VLOOKUP($B38,fuentes!$Z$71:$AM$186,6,0)","v":1277.9899999999998},{"$f":"VLOOKUP($B38,fuentes!$Z$71:$AM$186,7,0)","v":1.0263683643051944},0.96238536309950695,0.96238536309950695,{"$f":"IF(C38=\"\",\" \",(IF(fuentes!$B$14=1,\" \",SUMIF(#REF!,DASH!A38,#REF!))))","v":" "}," "," ",{"$f":"VLOOKUP($B38,fuentes!$Z$71:$AM$186,8,0)","v":590.26},{"$f":"VLOOKUP($B38,fuentes!$Z$71:$AM$186,9,0)","v":609.94000000000005},1.0333412394538002,1.0333412394538002,{"$f":"VLOOKUP($B38,fuentes!$Z$71:$AM$186,13,0)","v":0},0.47726508032144238,null,"SANA SANA",{"$f":"IFERROR((VLOOKUP($U38,fuentes!$H$41:$N$49,2,0)),\" \")","v":" "},{"$f":"IFERROR((VLOOKUP($U38,fuentes!$H$41:$N$49,3,0)),\" \")","v":" "},{"$f":"IFERROR((VLOOKUP($U38,fuentes!$H$41:$N$49,4,0)),\" \")","v":" "},{"$f":"IFERROR((VLOOKUP($U38,fuentes!$H$41:$N$49,5,0)),\" \")","v":" "},{"$f":"IFERROR((VLOOKUP($U38,fuentes!$H$41:$N$49,6,0)),\" \")","v":" "},0,0,{"$f":"IFERROR((VLOOKUP($U38,fuentes!$H$41:$N$49,7,0)),\" \")","v":" "},{"$f":"IFERROR((VLOOKUP($U38,fuentes!$H$41:$Q$49,8,0)),\" \")","v":" "},0,0," "]
[{"$f":"VLOOKUP($B39,fuentes!$Z$71:$AM$186,12,0)","v":"(ALL)"},10,{"$f":"VLOOKUP($B39,fuentes!$Z$71:$AM$186,11,0)","v":"IBUPRO TABL 400 MG x 100"},{"$f":"VLOOKUP($B39,fuentes!$Z$71:$AM$186,3,0)","v":449.81},{"$f":"VLOOKUP($B39,fuentes!$Z$71:$AM$186,4,0)","v":433.52},{"$f":"VLOOKUP($B39,fuentes!$Z$71:$AM$186,5,0)","v":427.6},{"$f":"VLOOKUP($B39,fuentes!$Z$71:$AM$186,6,0)","v":861.12},{"$f":"VLOOKUP($B39,fuentes!$Z$71:$AM$186,7,0)","v":0.98634434397490323},0.96378470909939751,0.96378470909939751,{"$f":"IF(C39=\"\",\" \",(IF(fuentes!$B$14=1,\" \",SUMIF(#REF!,DASH!A39,#REF!))))","v":" "}," "," ",{"$f":"VLOOKUP($B39,fuentes!$Z$71:$AM$186,8,0)","v":447.54},{"$f":"VLOOKUP($B39,fuentes!$Z$71:$AM$186,9,0)","v":426.72},0.95347901863520579,0.95347901863520579,{"$f":"VLOOKUP($B39,fuentes!$Z$71:$AM$186,13,0)","v":0},0.49554069119286515,null,"SUMELAB",{"$f":"IFERROR((VLOOKUP($U39,fuentes!$H$41:$N$49,2,0)),\" \")","v":" "},{"$f":"IFERROR((VLOOKUP($U39,fuentes!$H$41:$N$49,3,0)),\" \")","v":" "},{"$f":"IFERROR((VLOOKUP($U39,fuentes!$H$41:$N$49,4,0)),\" \")","v":" "},{"$f":"IFERROR((VLOOKUP($U39,fuentes!$H$41:$N$49,5,0)),\" \")","v":" "},{"$f":"IFERROR((VLOOKUP($U39,fuentes!$H$41:$N$49,6,0)),\" \")","v":" "},0,0,{"$f":"IFERROR((VLOOKUP($U39,fuentes!$H$41:$N$49,7,0)),\" \")","v":" "},{"$f":"IFERROR((VLOOKUP($U39,fuentes!$H$41:$Q$49,8,0)),\" \")","v":" "},0,0," "]
[{"$f":"VLOOKUP($B40,fuentes!$Z$71:$AM$186,12,0)","v":"(ALL)"},11,{"$f":"VLOOKUP($B40,fuentes!$Z$71:$AM$186,11,0)","v":"INSULINE R A.SC 1000 IU 10 ML x 1"},{"$f":"VLOOKUP($B40,fuentes!$Z$71:$AM$186,3,0)","v":213.47},{"$f":"VLOOKUP($B40,fuentes!$Z$71:$AM$186,4,0)","v":212.91},{"$f":"VLOOKUP($B40,fuentes!$Z$71:$AM$186,5,0)","v":212.42},{"$f":"VLOOKUP($B40,fuentes!$Z$71:$AM$186,6,0)","v":425.33},{"$f":"VLOOKUP($B40,fuentes!$Z$71:$AM$186,7,0)","v":0.99769855807618235},0.99737668056401363,0.99737668056401363,{"$f":"IF(C40=\"\",\" \",(IF(fuentes!$B$14=1,\" \",SUMIF(#REF!,DASH!A40,#REF!))))","v":" "}," "," ",{"$f":"VLOOKUP($B40,fuentes!$Z$71:$AM$186,8,0)","v":209.93},{"$f":"VLOOKUP($B40,fuentes!$Z$71:$AM$186,9,0)","v":216.28},1.0302481779640833,1.0302481779640833,{"$f":"VLOOKUP($B40,fuentes!$Z$71:$AM$186,13,0)","v":0},0.50849928290974067,null,"LOJAFARM",{"$f":"IFERROR((VLOOKUP($U40,fuentes!$H$41:$N$49,2,0)),\" \")","v":59.739999999999995},{"$f":"IFERROR((VLOOKUP($U40,fuentes!$H$41:$N$49,3,0)),\" \")","v":50.149999999999991},{"$f":"IFERROR((VLOOKUP($U40,fuentes!$H$41:$N$49,4,0)),\" \")","v":51.52},{"$f":"IFERROR((VLOOKUP($U40,fuentes!$H$41:$N$49,5,0)),\" \")","v":101.66999999999999},{"$f":"IFERROR((VLOOKUP($U40,fuentes!$H$41:$N$49,6,0)),\" \")","v":1.0273180458624129},0.83947104117843985,0.83947104117843985,{"$f":"IFERROR((VLOOKUP($U40,fuentes!$H$41:$N$49,7,0)),\" \")","v":51.300000000000004},{"$f":"IFERROR((VLOOKUP($U40,fuentes!$H$41:$Q$49,8,0)),\" \")","v":57.41},1.1191033138401558,1.1191033138401558,1.0893445494775584]
[{"$f":"VLOOKUP($B41,fuentes!$Z$71:$AM$186,12,0)","v":"/ML"},12,{"$f":"VLOOKUP($B41,fuentes!$Z$71:$AM$186,11,0)","v":"METFORMINA V.SC 100 IU 10 ML x 1 "},{"$f":"VLOOKUP($B41,fuentes!$Z$71:$AM$186,3,0)","v":597.69000000000005},{"$f":"VLOOKUP($B41,fuentes!$Z$71:$AM$186,4,0)","v":635.48},{"$f":"VLOOKUP($B41,fuentes!$Z$71:$AM$186,5,0)","v":651.13},{"$f":"VLOOKUP($B41,fuentes!$Z$71:$AM$186,6,0)","v":1286.6100000000001},{"$f":"VLOOKUP($B41,fuentes!$Z$71:$AM$186,7,0)","v":1.0246270535658084},1.0632267563452624,1.0632267563452624,{"$f":"IF(C41=\"\",\" \",(IF(fuentes!$B$14=1,\" \",SUMIF(#REF!,DASH!A41,#REF!))))","v":" "}," "," ",{"$f":"VLOOKUP($B41,fuentes!$Z$71:$AM$186,8,0)","v":582.59},{"$f":"VLOOKUP($B41,fuentes!$Z$71:$AM$186,9,0)","v":622.65},1.0687619080313771,1.0687619080313771,{"$f":"VLOOKUP($B41,fuentes!$Z$71:$AM$186,13,0)","v":0},0.4839461841583696,null,"RESTO_CLIENTES",{"$f":"IFERROR((VLOOKUP($U41,fuentes!$H$41:$N$49,2,0)),\" \")","v":20498.910000000003},{"$f":"IFERROR((VLOOKUP($U41,fuentes!$H$41:$N$49,3,0)),\" \")","v":20490.510000000046},{"$f":"IFERROR((VLOOKUP($U41,fuentes!$H$41:$N$49,4,0)),\" \")","v":20296.679999999949},{"$f":"IFERROR((VLOOKUP($U41,fuentes!$H$41:$N$49,5,0)),\" \")","v":40787.189999999995},{"$f":"IFERROR((VLOOKUP($U41,fuentes!$H$41:$N$49,6,0)),\" \")","v":0.99054049899196772},0.99959022211425108,0.99959022211425108,{"$f":"IFERROR((VLOOKUP($U41,fuentes!$H$41:$N$49,7,0)),\" \")","v":20263.780000000046},{"$f":"IFERROR((VLOOKUP($U41,fuentes!$H$41:$Q$49,8,0)),\" \")","v":20610.820000000036},1.017126123556414,1.017126123556414,1.0268395129643879]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL",{"$f":"SUM(V35:V41)","v":20558.650000000005},{"$f":"SUM(W35:W41)","v":20540.660000000047},{"$f":"SUM(X35:X41)","v":20348.19999999995},{"$f":"SUM(Y35:Y41)","v":40888.859999999993},{"$f":"+GETPIVOTDATA(\" %Bonif.\",fuentes!$H$40)","v":1.0035374725447228},{"$f":"IFERROR((+W42/V42),0)","v":0.99912494254243556},0.99912494254243556,{"$f":"SUM(AC35:AC41)","v":20315.080000000045},{"$f":"SUM(AD35:AD41)","v":20668.230000000036},{"$f":"IFERROR((+AD42/AC42),0)","v":1.0173836381643582},1.0173836381643582,1.0137973578450687]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]

{"sheet":"fuentes","index":3,"n_rows":279,"n_cols":58,"rows_kept":279,"cut":false,"hidden":false,"merged":[[5,9,7,10],[4,0,5,0],[0,0,0,2],[1,0,1,2]]}
["MANTENER FORMULAS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SELECCIÓN SIN DISTRIB",{"$f":"IF(Z1=0,\"(ALL)\",AB2&AB3&AB4)","v":"MERC: 18-GLYCEROL"},{"$f":"SUM(Z2:Z5)","v":3},null," ",null,null,"ENERO","FEBRERO","MARZO","ABRIL","MAYO","JUNIO","JULIO","AGOSTO","SEPTIEMBRE","OCTUBRE","NOVIEMBRE","DICIEMBRE","Total general"]
["DATOS PARA CAMBIAR ANUALMENTE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LINEA","(ALL)",{"$f":"IF(Y2=\"(ALL)\",0,1)","v":0},null,{"$f":"IF(Z2<>0,Y2,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MARCA","MERC: 18-GLYCEROL",{"$f":"IF(Y3=\"(ALL)\",0,3)","v":3},null,{"$f":"IF(Z3<>0,Y3,\"\")","v":"MERC: 18-GLYCEROL"}]
[null,null,null,null,null,null,null,null,null,null,"TAB1",null,null,null,null,null,null,null,null,null,null,null,null,"COD_ITEM","(ALL)",{"$f":"IF(Y4=\"(ALL)\",0,5)","v":0}," ",{"$f":"IF(AA4<>\" \",Y4,\"\")","v":""}]
["DATOS PARA CAMBIO DE AÑO","AÑO BASE",2015,null,"%CUM",{"$f":"IF(B14=1,(IF(Y2=\"(ALL)\",DASH!P16,(VLOOKUP(fuentes!Y2,DASH!$C$9:$S$16,14,0)))),(IF(Y2=\"(ALL)\",DASH!I16,(VLOOKUP(fuentes!Y2,DASH!$C$9:$S$17,7,0)))))","v":0.98874789739377034},null,null,null,null,null," ",null,null,null,null,null,null,null,null,null,null,null,"CLIENTE","(ALL)",0,null,null,null,null,null,"TAB5"]
[null,"AÑO ACTUAL",2016,null,"NUR",{"$f":"IF(Y2=\"(ALL)\",DASH!S16,(VLOOKUP(fuentes!Y2,DASH!$C$9:$S$16,17,0)))","v":0.49918947379008788},null,"ANIO",2016,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LIN+MAR",4,null,null,null,"CLIENTE","(Todas)"]
[null,null,null,null,null,null,null,"MES","abril",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LIN+MAR+ITE",9,"I271 I500",null,null,"LINEA","(Varios elementos)"]
[null,null,null,null,null,null,null,"CLIENTE","(Todas)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LIN+ITEM",6,"H271 H500",null,null,"PRODUCTO","MERC: 18-GLYCEROL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MAR+ITEM",8,"G271 G500",null,null,"COD_ITEM","(Todas)",null,{"$f":"IF(AD9<>\"(Todas)\",(MID(AD9,(FIND(\"(\",AD9)+1),(LEN(AD9))-(FIND(\"(\",AD9)+1))),\"(ALL)\")","v":"(ALL)"}," "]
[null,null,null,null,null,null,null,null,"Valores",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TODO",0," TOTAL"]
[null,null,null,null,null,null,1,"Rótulos de fila","UNI PLAN"," UNI NET"," UNI BONIF."," TOT UNI"," %Bonif."," VALOR PLAN"," VENTA ($)"," P_PROM",{"$f":"IFERROR((+N11/R11),0)","v":0},{"$f":"SUMIF($K$289:$K$427,H11,$F$289:$F$427)","v":0},null,null,null,null,null,"SOLO LINEA",1,"K271 K500",null,null,null,null,"MES"]
[null,null,null,null,null,null,{"$f":"+G11+1","v":2},"GENERAL",60317.379999999903,60079.620000000032,60027.390000000036,120107.01000000007,0.99913065362264286,60376.259999999886,60578.490000000049,0.50437097718109891,{"$f":"IFERROR((+N12/R12),0)","v":0},0,null,null,null,null,null,null,null,null,null,null,"ANIO","Valores","enero","febrero","marzo","abril","mayo","junio","julio","agosto","septiembre","Octubre","Noviembre","diciembre","Total general",null," ","ENE","FEB","MAR","ABR","MAY","JUN","JUL","AGO","SEP","OCT","NOV","DIC","TOTAL"]
[null,null,null,null,null,null,{"$f":"+G12+1","v":3},"SNC",51903.69999999999,51695.510000000089,51834.289999999892,103529.79999999999,1.0026845658355978,52145.900000000009,51317.46,0.49567815257056425,0,0,null,null,null,null,null,"NO BORRAR",null,null,null,{"$f":"+AC13&AD13","v":"2015 VALOR_PLAN"},2015," VALOR_PLAN",1.31,1.1499999999999999,1.1100000000000001,619.17999999999995,1.1200000000000001,642.98,624.46,610.4,1073.51,1013.3,814.8,695.41,6098.7300000000005]
[null,1,null,null,1,null,4,"CARDIOLOGICA",37070.969999999994,36668.400000000045,36609.32,73277.720000000045,0.99838880343838166,37124.57,36579.439999999959,0.49918911232500052,0,0,null,null,null,null,null,{"$f":"fuentes!C5&\" VALOR_VENTA_NETO\"","v":"2015 VALOR_VENTA_NETO"},null,null,null,{"$f":"+AC14&AD14","v":" VALOR_VENTA_NETO"},null," VALOR_VENTA_NETO",1.48,1.01,3.89,666.5,2.5299999999999998,692.94,665.5,648.33000000000004,1027.94,600.79,788.73,679.96,5779.5999999999995]
[1,"USD$ /.000",null,null,1,"ABSOLUTOS",5,"RESPIRATORIA",15992.440000000013,15404.669999999998,15404.259999999995,30808.929999999993,0.99997338469438146,15916.639999999998,15334.720000000012,0.4977362083006458,0,0,null,null,null,null,null,{"$f":"fuentes!C6&\" VALOR_PLAN\"","v":"2016 VALOR_PLAN"},null,null,null,{"$f":"+AC15&AD15","v":" UNIDADES_PLAN"},null," UNIDADES_PLAN",5.55,8.4600000000000009,1.38,709.81,1.97,666.93,648.39,611.61,1057.8900000000001,1048.31,824.38,691.37,6276.0499999999993,null,{"$f":"IF(B14=1,+DASH!U19,DASH!$U$23)","v":"Vta ($)  2015"},{"$f":"IF($B$14=1,+DASH!V19/1000,DASH!V23)","v":{"$error":"#N/A"}},{"$f":"IF($B$14=1,+DASH!W19/1000,DASH!W23)","v":{"$error":"#N/A"}},{"$f":"IF($B$14=1,+DASH!X19/1000,DASH!X23)","v":{"$error":"#N/A"}},{"$f":"IF($B$14=1,+DASH!Y19/1000,DASH!Y23)","v":{"$error":"#N/A"}},{"$f":"IF($B$14=1,+DASH!Z19/1000,DASH!Z23)","v":{"$error":"#N/A"}},{"$f":"IF($B$14=1,+DASH!AA19/1000,DASH!AA23)","v":{"$error":"#N/A"}},{"$f":"IF($B$14=1,+DASH!AB19/1000,DASH!AB23)","v":{"$error":"#N/A"}},{"$f":"IF($B$14=1,+DASH!AC19/1000,DASH!AC23)","v":{"$error":"#N/A"}},{"$f":"IF($B$14=1,+DASH!AD19/1000,DASH!AD23)","v":{"$error":"#N/A"}},{"$f":"IF($B$14=1,+DASH!AE19/1000,DASH!AE23)","v":{"$error":"#N/A"}},{"$f":"IF($B$14=1,+DASH!AF19/1000,DASH!AF23)","v":{"$error":"#N/A"}},{"$f":"IF($B$14=1,+DASH!AG19/1000,DASH!AG23)","v":{"$error":"#N/A"}},{"$f":"SUM(AT15:BE15)","v":{"$error":"#N/A"}}]
[2,"Unidades",null,null,2,"PORCENTAJES",6,"METABOLICOS",11913.540000000003,11981.190000000004,11746.360000000008,23727.55000000001,0.98040011050655262,11970.120000000004,11737.220000000007,0.49466632669618238,0,0,null,null,null,null,null,{"$f":"fuentes!C6&\" VALOR_VENTA_NETO\"","v":"2016 VALOR_VENTA_NETO"},null,null,null," UNI_NET_PACK",null," UNI_NET_PACK",2.34,1.1299999999999999,1.31,645.71,3.88,608.48,617.22,609.99,979.62,1165.68,805.74,699.36,6140.4599999999991]
[null,null,null,null,null,null,7,"OFTALMOLOGICA",6433.4600000000037,6438.4200000000028,6493.9499999999989,12932.370000000003,1.008624786826581,6501.2800000000025,6469.8899999999967,0.50028649041126994,0,0,null,null,null,null,null,null,null,null,null," TOT_UNI_PACK",null," TOT_UNI_PACK",3.76,2.57,3.26,1358.3000000000002,4.9399999999999995,1290.76,1277.0500000000002,1242.25,1981.27,1751.1100000000001,1629.25,1400.5500000000002,11945.07]
[null,null,null,null,null,null,8,"GINECOLOCICA",4720.6499999999996,4686.1000000000031,4749.3999999999969,9435.5,1.0135080343996061,4695.29,4589.2300000000032,0.48637910020666664,0,0,null,null,null,null,null,{"$f":"fuentes!C5&\" UNI_NET_PACK\"","v":"2015 UNI_NET_PACK"},null,null,null," UNI_BON_PACK",null," UNI_BON_PACK",1.42,1.44,1.95,712.59,1.06,682.28,659.83,632.26,1001.65,585.42999999999995,823.51,701.19,5804.6100000000006]
[null,null,null,null,"ORIGEN",1,9,"Total general",188352.1399999999,186953.91000000021,186864.96999999991,373818.88,0.99952426777273373,188730.05999999988,186606.45,0.49918947379008688,0,{"$f":"SUM(R11:R18)","v":0},null,null,null,null,null,{"$f":"fuentes!C6&\" UNIDADES_PLAN\"","v":"2016 UNIDADES_PLAN"},null,null,null," %Bonif.",null," %Bonif.",0.60683760683760679,1.2743362831858407,1.4885496183206106,1.1035759086896595,0.27319587628865982,1.1212858269787009,1.0690353520624738,1.0365087952261511,1.0224883117943693,0.5022218790748747,1.0220542606796237,1.0026166781056967,0.94530540057259582,null,{"$f":"IF(B14=1,+DASH!U20,DASH!$U$24)","v":"Plan ($) 2016"},{"$f":"IF($B$14=1,+DASH!V20/1000,DASH!V24)","v":2.1099999999999999E-3},{"$f":"IF($B$14=1,+DASH!W20/1000,DASH!W24)","v":1.64E-3},{"$f":"IF($B$14=1,+DASH!X20/1000,DASH!X24)","v":1.4499999999999999E-3},{"$f":"IF($B$14=1,+DASH!Y20/1000,DASH!Y24)","v":0.59026000000000001},{"$f":"IF($B$14=1,+DASH!Z20/1000,DASH!Z24)","v":1.0402},{"$f":"IF($B$14=1,+DASH!AA20/1000,DASH!AA24)","v":0.60988999999999993},{"$f":"IF($B$14=1,+DASH!AB20/1000,DASH!AB24)","v":0.61397000000000002},{"$f":"IF($B$14=1,+DASH!AC20/1000,DASH!AC24)","v":0.88337999999999994},{"$f":"IF($B$14=1,+DASH!AD20/1000,DASH!AD24)","v":0.80754999999999999},{"$f":"IF($B$14=1,+DASH!AE20/1000,DASH!AE24)","v":0.69213999999999998},{"$f":"IF($B$14=1,+DASH!AF20/1000,DASH!AF24)","v":0.68799999999999994},{"$f":"IF($B$14=1,+DASH!AG20/1000,DASH!AG24)","v":0.64351000000000003},{"$f":"SUM(AT19:BE19)","v":6.5740999999999996}]
[null,null,null,null,"GRAFICO ",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"fuentes!C6&\" UNI_NET_PACK\"","v":"2016 UNI_NET_PACK"},null,null,null,"2016 VALOR_PLAN",2016," VALOR_PLAN",2.11,1.64,1.45,590.26,1040.2,609.89,613.97,883.38,807.55,692.14,688,643.51,6574.1000000000013,null,{"$f":"IF(B14=1,+DASH!U21,DASH!U25)","v":"Vta ($)  2016"},{"$f":"IF($B$14=1,+DASH!V21/1000,DASH!V25)","v":{"$error":"#N/A"}},{"$f":"IF($B$14=1,+DASH!W21/1000,DASH!W25)","v":{"$error":"#N/A"}},{"$f":"IF($B$14=1,+DASH!X21/1000,DASH!X25)","v":{"$error":"#N/A"}},{"$f":"IF($B$14=1,+DASH!Y21/1000,DASH!Y25)","v":{"$error":"#N/A"}},{"$f":"IF($B$14=1,+DASH!Z21/1000,DASH!Z25)","v":{"$error":"#N/A"}},{"$f":"IF($B$14=1,+DASH!AA21/1000,DASH!AA25)","v":{"$error":"#N/A"}},{"$f":"IF($B$14=1,+DASH!AB21/1000,DASH!AB25)","v":{"$error":"#N/A"}},{"$f":"IF($B$14=1,+DASH!AC21/1000,DASH!AC25)","v":{"$error":"#N/A"}},{"$f":"IF($B$14=1,+DASH!AD21/1000,DASH!AD25)","v":{"$error":"#N/A"}},{"$f":"IF($B$14=1,+DASH!AE21/1000,DASH!AE25)","v":{"$error":"#N/A"}},{"$f":"IF($B$14=1,+DASH!AF21/1000,DASH!AF25)","v":{"$error":"#N/A"}},{"$f":"IF($B$14=1,+DASH!AG21/1000,DASH!AG25)","v":{"$error":"#N/A"}},{"$f":"SUM(AT20:BE20)","v":{"$error":"#N/A"}}]
[null,null,null,null,"DASH",2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"fuentes!C6&\" TOT_UNI_PACK\"","v":"2016 TOT_UNI_PACK"},null,null,null," VALOR_VENTA_NETO",null," VALOR_VENTA_NETO",1.22,1.3,3.73,609.94000000000005,572.91,624.62,596,623.05999999999995,825.86,695.76,680.28,645.17999999999995,5879.86]
[null,null,null,null,null,null,null,null,null,"TOTAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," UNIDADES_PLAN",null," UNIDADES_PLAN",1.94,2.86,1.95,655.33000000000004,1021.47,621.53,621.84,906.07,781.9,673.29,683.02,640.04,6611.2400000000007]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"fuentes!C6&\" %Bonif.\"","v":"2016 %Bonif."},null,null,null,{"$f":"+AC23&AD23","v":" UNI_NET_PACK"},null," UNI_NET_PACK",2.58,2.0099999999999998,1.91,630.67999999999995,1188.06,581.77,614.89,911.07,778.67,674.71,698.33,634.44000000000005,6719.119999999999,null,"%CUM",{"$f":"+AT20/AT19","v":{"$error":"#N/A"}},{"$f":"+AU20/AU19","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"fuentes!C6&\" FCST\"","v":"2016 FCST"},null,null,null," TOT_UNI_PACK",null," TOT_UNI_PACK",4.38,3.55,3.11,1277.9899999999998,1781.23,1185,1226.6500000000001,1514.62,1596.42,1354.33,1410.49,1248.83,12606.599999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ","CON SELEC TODOS","(ALL)",null,null,null," UNI_BON_PACK",null," UNI_BON_PACK",1.8,1.54,1.2,647.30999999999995,593.16999999999996,603.23,611.76,603.54999999999995,817.75,679.62,712.16,614.39,5887.4800000000005]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MES ACTUAL",{"$f":"MONTH(TODAY())","v":4},null,null,null," %Bonif.",null," %Bonif.",0.69767441860465118,0.76616915422885579,0.62827225130890052,1.0263683643051944,0.49927613083514299,1.0368874297402755,0.99490965863813041,0.66246281844424681,1.0501881413178882,1.0072772005750619,1.0198043904744174,0.96839732677636958,0.87622783935991633]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CLIENTE",{"$f":"IF(Y5<>\"(ALL)\",0,1)","v":1}]
[null,null,null,null,null,null,null,null," "]
[]
[null,1,{"$f":"IF(B30=1,\"MENSUAL A \"&C31,\"ACUMULADA ENERO - \"&C31)","v":"MENSUAL A ABRIL"},null," ",null,null,null,null,null,"TAB2"]
[null,4,{"$f":"VLOOKUP(B31,$B$32:$C$43,2,0)","v":"ABRIL"}," "]
[1,1,"ENERO",{"$f":"IF($B$30=1,IF(B32=$B$31,1,0),IF(B32<=$B$31,1,0))","v":0}]
[{"$f":"+A32+1","v":2},2,"FEBRERO",{"$f":"IF($B$30=1,IF(B33=$B$31,1,0),IF(B33<=$B$31,1,0))","v":0}]
[{"$f":"+A33+1","v":3},3,"MARZO",0,null,null,null,"ANIO",2016]
[4,4,"ABRIL",1,null,null,null,"MES","abril"]
[5,5,"MAYO",0,null,null,null,"LINEA","(Todas)"]
[6,6,"JUNIO",0,null,null,null,"PRODUCTO","MERC: 18-GLYCEROL"]
[7,7,"JULIO",0,null,null,null,"COD_ITEM","(Todas)"]
[8,8,"AGOSTO",0]
[9,9,"SEPTIEMBRE",0,null,null," ",null,"Valores"]
[10,10,"OCTUBRE",0,null,null,1,"Rótulos de fila"," UNIDADES PLAN"," UNI NET"," UNI BONIF."," TOT UNI"," %Bonif."," VALOR_PLAN"," VENTA ($)"," P_PROM"]
[11,11,"NOVIEMBRE",0,null,null,2,"LOJAFARM",59.739999999999995,50.149999999999991,51.52,101.66999999999999,1.0273180458624129,51.300000000000004,57.41,0.56467001081931745]
[12,12,"DICIEMBRE",0,null,null,3,"RESTO_CLIENTES",20498.910000000003,20490.510000000046,20296.679999999949,40787.189999999995,0.99054049899196772,20263.780000000046,20610.820000000036,0.50532581430591417]
[null,null,null,null,null,null,4,"DISTRIBUIDORA COSTA AZUL",1370.11,1427.77,1429.3000000000002,2857.07,1.0010716011682554,1421.1000000000001,1451.81,0.50814645773467215]
[null,8,{"$f":"IF(B45=8,\"(ALL)\",VLOOKUP(B45,$B$46:$C$53,2,0))","v":"(ALL)"},null,null,null,5,"DISTRIBUIDORA LA ECONOMICA",1007.74,1041.1500000000001,1054.33,2095.48,1.0126590789031358,984.3,970.81,0.46328764769885655]
[null," ","Rótulos de fila",null,"tab6",null,6,"DISTRIBUIDORA ZONA SUR",12504.66,12284.170000000004,12480.55,24764.720000000001,1.0159864280614803,12618.659999999998,12355.719999999998,0.49892427614768092]
[null,1,"(en blanco)",null,null,null,7,"FARMACOS INDEPENDIENTES DE LATINOAMERICA",903.16,873.93000000000006,942.73000000000013,1816.6600000000003,1.0787248406622956,906.39,919.03,0.50588992987130221]
[null,2,"LOJAFARM",null,null,null,8,"SUPER DESPENSAS LA SALUD",669.12,646.74,689.54,1336.28,1.0661780622815968,645.06999999999994,662.8,0.49600383153231359]
[null,3,"RESTO_CLIENTES",null,null,null,null,"Total general",37013.44000000001,36814.420000000049,36944.649999999951,73759.069999999992,1.0035374725447228,36890.600000000042,37028.400000000038,0.50201826026277252]
[null,4,"DISTRIBUIDORA COSTA AZUL"]
[null,5,"DISTRIBUIDORA LA ECONOMICA"]
[null,6,"DISTRIBUIDORA ZONA SUR"]
[null,7,"FARMACOS INDEPENDIENTES DE LATINOAMERICA"]
[null,8,"SUPER DESPENSAS LA SALUD"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TAB4"]
[null,null,null,null,null,null,null,null,null,null,null,"TAB3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ANIO",2016]
[null,null,null,null,null,null,null,"ANIO",2016,null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MES","abril",null,null," "]
[null,null,null,null,null,null,null,"MES","abril",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LINEA","(Varios elementos)"]
[null,null,null,null,null,null,null,"LINEA","(Varios elementos)",null,null,null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,"PRODUCTO","MERC: 18-GLYCEROL"]
[null,null,null,null,null,null,null,"CLIENTE","(Todas)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CLIENTE","(Todas)"]
[null,null,null,null,null,null,null,"total general",{"$f":"SUM(I71:I250)","v":82743.280000000028},{"$f":"SUM(J71:J250)","v":81922.71000000005},{"$f":"SUM(K71:K250)","v":81925.599999999948},{"$f":"SUM(L71:L250)","v":163848.30999999997},{"$f":"IFERROR((+K69/J69),\" \")","v":1.0000352771533059},{"$f":"SUM(N71:N250)","v":82794.180000000022},{"$f":"SUM(O71:O250)","v":82383.099999999991}," ",{"$f":"IFERROR((+N69/R69),0)","v":0},{"$f":"SUM(R71:R250)","v":0},null,null,null,null,null,null,null,null,"total general",{"$f":"SUM(AB71:AB326)","v":14606.679999999998},{"$f":"SUM(AC71:AC326)","v":14536.54},{"$f":"SUM(AD71:AD326)","v":14529.919999999998},{"$f":"SUM(AE71:AE326)","v":29066.46},{"$f":"+AD69/AC69","v":0.99954459589420852},{"$f":"SUM(AG71:AG326)","v":14540.800000000001},{"$f":"SUM(AH71:AH326)","v":14683.310000000003}," "]
[null,null,null,null,null,null,null,null,"Valores",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Valores"]
[null,null,null,null,null,null,1,"Rótulos de fila","UNI PLAN"," UNI NET"," UNI BONIF."," TOT UNI"," %Bonif."," VALOR_PLAN"," VENTA ($)"," P_PROM",{"$f":"IFERROR((+N71/R71),0)","v":0},{"$f":"SUMIF($M$289:$M$427,H71,$F$289:$F$427)","v":0},null,null,null,null,null,null,null,1,"Rótulos de fila","UNI PLAN"," UNI NET"," UNI BONIF."," TOT UNI"," %Bonif."," VALOR_PLAN"," VENTA ($)"," P_PROM",{"$f":"+AA71","v":"Rótulos de fila"},{"$f":"IFERROR((MID(AA71,(FIND(\"(\",AA71)+1),(LEN(AA71))-(FIND(\"(\",AA71)+1))),\"(ALL)\")","v":"(ALL)"},{"$f":"IFERROR((+AG71/AM71),0)","v":0},{"$f":"SUMIF($L$289:$L$427,AK71,$F$289:$F$427)","v":0}]
[null,null,null,null,null,null,{"$f":"+G71+1","v":2},"MERC: 19-LINAGLIPTINA",18199.980000000007,18195.060000000016,18134.279999999981,36329.339999999997,0.99665953286221454,18407.970000000005,18224.069999999989,0.50163504208994691,{"$f":"IFERROR((+N72/R72),0)","v":0},{"$f":"SUMIF($M$289:$M$427,H72,$F$289:$F$427)","v":0},null,null,null,null,null,null,null,2,"ATORVAS CAPS x 28",2194.4799999999987,2181.4600000000009,2182.2899999999995,4363.75,1.0003804791286564,2184.2900000000004,2161.2800000000011,0.49528043540532823,{"$f":"IFERROR((LEFT(AA72,(FIND(\"(\",AA72)-1))),\"\")","v":""},{"$f":"IFERROR((MID(AA72,(FIND(\"(\",AA72)+1),(LEN(AA72))-(FIND(\"(\",AA72)+1))),\"(ALL)\")","v":"(ALL)"},{"$f":"IFERROR((+AG72/AM72),0)","v":0},{"$f":"SUMIF($L$289:$L$427,AK72,$F$289:$F$427)","v":0}]
[null,null,null,null,null,null,3,"MERC: 18-GLYCEROL",14606.680000000009,14536.540000000003,14529.92,29066.460000000003,0.99954459589420852,14540.80000000001,14683.31000000001,0.50516333946411118,0,{"$f":"SUMIF($M$289:$M$427,H73,$F$289:$F$427)","v":0},null,null,null,null,null,null,null,3,"GLYCYRRHIZA CAPS 20 MG x 10 (/135)",2744.1499999999987,2792.8699999999994,2729.900000000001,5522.77,0.97745330072649339,2712.6400000000003,2865.1900000000014,0.51879582166195604,{"$f":"+AA73","v":"GLYCYRRHIZA CAPS 20 MG x 10 (/135)"},"/135",0,0]
[null,null,null,null,null,null,4,"MERC: 32-COM_B",14043.320000000009,13778.859999999997,13943.989999999991,27722.849999999988,1.0119843005880018,14040.840000000009,14079.400000000005,0.50786264759936339,0,0,null,null,null,null,null,null,null,4,"GLYCEROL SENS. FACE EMULS.LIMPIA 200 ML x 1",2315.8700000000003,2253.5699999999997,2273.3099999999995,4526.8799999999992,1.0087594350297526,2305.2899999999995,2272.2399999999998,0.50194394373166507,"GLYCEROL SENS. FACE EMULS.LIMPIA 200 ML x 1","(ALL)",0,0]
[null,null,null,null,null,null,5,"MERC: 25-FAMOTIDINA",7034.069999999997,6593.329999999999,6667.4399999999969,13260.769999999997,1.0112401472397101,6985.54,6624.1399999999976,0.49952906203787556,0,0,null,null,null,null,null,null,null,5,"CRECE +D 200 G x 1",437.72,397.6,416.78,814.38,1.0482394366197181,452.96,419.22,0.51477197377145811,"CRECE +D 200 G x 1","(ALL)",0,0]
[null,null,null,null,null,null,6,"MERC: 36-CHLORMADINONE",6619.6100000000015,6554.5900000000029,6528.4299999999994,13083.020000000002,0.99600890368428785,6661.7300000000023,6574.3400000000038,0.50250935945981912,0,0,null,null,null,null,null,null,null,6,"CLOTRIMAZOL SOFT JABON LIQD 120 ML x 1",1652.89,1649.6099999999997,1646.7599999999998,3296.3699999999994,0.99827231891174284,1680.9400000000003,1723.7399999999998,0.52292066727946196,"CLOTRIMAZOL SOFT JABON LIQD 120 ML x 1","(ALL)",0,0]
[null,null,null,null,null,null,7,"MERC: 40-EPROSAR",3267.7499999999995,3345.6,3232.06,6577.66,0.96606288857006217,3311.88,3320.44,0.50480566037162156,0,0,null,null,null,null,null,null,null,7,"TRAMAD TABL 25 MG x 30 (/25M)",1282.1399999999999,1330.16,1292.1200000000001,2622.28,0.97140193660912977,1266.0600000000002,1333.2200000000005,0.50842015345424607,"TRAMAD TABL 25 MG x 30 (/25M)","/25M",0,0]
[null,null,null,null,null,null,8,"MERC: 28-GLYCEROL",3206.6499999999996,3089.7599999999998,3151.9999999999995,6241.7599999999993,1.0201439594013775,3141.7299999999987,3069.8799999999992,0.4918292276537386,0,0,null,null,null,null,null,null,null,8,"GLYCEROL SP.F30.BRON 200 ML x 1",1430.86,1423.4900000000002,1434.4999999999998,2857.99,1.007734511657967,1490.53,1434.8799999999999,0.50205913946514857,"GLYCEROL SP.F30.BRON 200 ML x 1","(ALL)",0,0]
[null,null,null,null,null,null,9,"MERC: 23-ACITRETIN",2894.4700000000003,2945.1600000000003,2939.5600000000004,5884.7200000000012,0.99809857528962775,2917.5499999999997,2916.54,0.49561236558408883,0,{"$f":"SUMIF($M$289:$M$427,H79,$F$289:$F$427)","v":0},null,null,null,null,null,null,null,9,"RIVASTIG A.IV LIOF 2 MG x 5",655.33000000000004,630.67999999999995,647.30999999999995,1277.9899999999998,1.0263683643051944,590.26,609.94000000000005,0.47726508032144238,"RIVASTIG A.IV LIOF 2 MG x 5","(ALL)",0,0]
[null,null,null,null,null,null,10,"MERC: 46-LINCOMICINA",2815.0000000000005,2815.8600000000006,2770.5399999999991,5586.4,0.9839054498448071,2873.3100000000004,2842.2599999999993,0.5087820421022482,0,0,null,null,null,null,null,null,null,10,"IBUPRO TABL 400 MG x 100",449.81,433.52,427.6,861.12,0.98634434397490323,447.54,426.72,0.49554069119286515,"IBUPRO TABL 400 MG x 100","(ALL)",{"$f":"IFERROR((+AG80/AM80),0)","v":0},0]
[null,null,null,null,null,null,11,"MERC: 1069-ERITROPOYETINA",2121.3900000000003,2057.5200000000013,2084.8399999999997,4142.3600000000006,1.0132781212333286,2095.1400000000003,2121.7199999999993,0.51220077443775991,0,0,null,null,null,null,null,null,null,11,"INSULINE R A.SC 1000 IU 10 ML x 1",213.47,212.91,212.42,425.33,0.99769855807618235,209.93,216.28,0.50849928290974067,"INSULINE R A.SC 1000 IU 10 ML x 1","(ALL)",0,0]
[null,null,null,null,null,null,12,"MERC: 33-LOSARTAN",2108.9299999999998,2131.5499999999997,2068.0300000000002,4199.58,0.97020008913701317,2071.06,2072.8200000000002,0.49357792922149363,0,0,null,null,null,null,null,null,null,12,"METFORMINA V.SC 100 IU 10 ML x 1 (/ML)",597.69000000000005,635.48,651.13,1286.6100000000001,1.0246270535658084,582.59,622.65,0.4839461841583696,{"$f":"IFERROR((LEFT(AA82,(FIND(\"(\",AA82)-1))),\"\")","v":"METFORMINA V.SC 100 IU 10 ML x 1 "},"/ML",0,0]
[null,null,null,null,null,null,13,"MERC: 1071-VILDAGLIPTIN",1681.02,1689.1,1712.9099999999999,3402.0099999999998,1.014096264282754,1686.59,1686.22,0.49565403981763728,0,0,null,null,null,null,null,null,null,13,"MICONAZOL OVULOS x 10",632.27,595.19000000000005,615.79999999999995,1210.99,1.0346275979099109,617.77,597.95000000000005,0.49376956044228282,"","(ALL)",0,0]
[null,null,null,null,null,null,14,"MERC: 49-ADAPALEN",1282.3000000000002,1280.57,1248.6500000000001,2529.2200000000003,0.97507360003748345,1255.93,1230.56,0.48653735143641114,0,0,null,null,null,null,null,null,null,14,null,null,null,null,null,null,null,null,null,"","(ALL)",0,0]
[null,null,null,null,null,null,15,"MERC: 47-LOSARTAN",1255.74,1271.3499999999999,1276.8400000000001,2548.19,1.0043182443858891,1203.46,1328,0.5211542310424262,0,0,null,null,null,null,null,null,null,15,null,null,null,null,null,null,null,null,null,"","(ALL)",0,0]
[null,null,null,null,null,null,16,"MERC: 24-LOVASTATINA",839.31,862.6,866.92000000000007,1729.52,1.0050081150011594,819.57999999999993,813.58,0.47040797446690413,0,0,null,null,null,null,null,null,null,16,null,null,null,null,null,null,null,null,null,"","(ALL)",0,0]
[null,null,null,null,null,null,17,"COM_B",391.18,376.68,398.14,774.81999999999994,1.0569714346394818,399.67,397.51,0.51303528561472345,0,0,null,null,null,null,null,null,null,17,null,null,null,null,null,null,null,null,null,"","(ALL)",0,0]
[null,null,null,null,null,null,18,"MERC: 42-LOUTEN T",375.88,398.58,371.05,769.63,0.93092980079281451,381.4,398.31,0.51753439964658343,0,0,null,null,null,null,null,null,null,18,null,null,null,null,null,null,null,null,null,"","(ALL)",0,0]
[null,null,null,null,null,null,19,null,null,null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,null,19,null,null,null,null,null,null,null,null,null,"","(ALL)",0,0]
[null,null,null,null,null,null,20,null,null,null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,null,20,null,null,null,null,null,null,null,null,null,"","(ALL)",0,0]
[null,null,null,null,null,null,21,null,null,null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,null,21,null,null,null,null,null,null,null,null,null,"","(ALL)",0,0]
[null,null,null,null,null,null,22,null,null,null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,null,22,null,null,null,null,null,null,null,null,null,"","(ALL)",0,0]
[null,null,null,null,null,null,23,null,null,null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,null,23,null,null,null,null,null,null,null,null,null,"","(ALL)",0,0]
[null,null,null,null,null,null,24,null,null,null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,null,24,null,null,null,null,null,null,null,null,null,"","(ALL)",0,0]
[null,null,null,null,null,null,25,null,null,null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,null,25,null,null,null,null,null,null,null,null,null,"","(ALL)",0,0]
[null,null,null,null,null,null,26,null,null,null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,null,26,null,null,null,null,null,null,null,null,null,"","(ALL)",0,0]
[null,null,null,null,null,null,27,null,null,null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,null,27,null,null,null,null,null,null,null,null,null,"","(ALL)",0,0]
[null,null,null,null,null,null,28,null,null,null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,null,28,null,null,null,null,null,null,null,null,null,"","(ALL)",0,0]
[null,null,null,null,null,null,29,null,null,null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,null,29,null,null,null,null,null,null,null,null,null,"","(ALL)",0,0]
[null,null,null,null,null,null,30,null,null,null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,null,30,null,null,null,null,null,null,null,null,null,"","(ALL)",0,0]
[null,null,null,null,null,null,31,null,null,null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,null,31,null,null,null,null,null,null,null,null,null,"","(ALL)",0,0]
[null,null,null,null,null,null,32,null,null,null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,null,32,null,null,null,null,null,null,null,null,null,"","(ALL)",0,0]
[null,null,null,null,null,null,33,null,null,null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,null,33,null,null,null,null,null,null,null,null,null,"","(ALL)",{"$f":"IFERROR((+AG103/AM103),0)","v":0},{"$f":"SUMIF($L$289:$L$427,AK103,$F$289:$F$427)","v":0}]
[null,null,null,null,null,null,{"$f":"+G103+1","v":34},null,null,null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,null,34,null,null,null,null,null,null,null,null,null,"","(ALL)",0,0]
[null,null,null,null,null,null,35,null,null,null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,null,35,null,null,null,null,null,null,null,null,null,"","(ALL)",0,0]
[null,null,null,null,null,null,36,null,null,null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,null,36,null,null,null,null,null,null,null,null,null,"","(ALL)",0,0]
[null,null,null,null,null,null,37,null,null,null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,null,37,null,null,null,null,null,null,null,null,null,"","(ALL)",0,0]
[null,null,null,null,null,null,38,null,null,null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,null,38,null,null,null,null,null,null,null,null,null,"","(ALL)",0,0]
[null,null,null,null,null,null,39,null,null,null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,null,39,null,null,null,null,null,null,null,null,null,"","(ALL)",0,0]
[null,null,null,null,null,null,40,null,null,null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,null,40,null,null,null,null,null,null,null,null,null,"","(ALL)",0,0]
[null,null,null,null,null,null,41,null,null,null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,null,41,null,null,null,null,null,null,null,null,null,"","(ALL)",0,0]
[null,null,null,null,null,null,42,null,null,null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,null,42,null,null,null,null,null,null,null,null,null,"","(ALL)",0,0]
[null,null,null,null,null,null,43,null,null,null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,null,43,null,null,null,null,null,null,null,null,null,"","(ALL)",0,0]
[null,null,null,null,null,null,44,null,null,null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,null,44,null,null,null,null,null,null,null,null,null,"","(ALL)",0,0]
[null,null,null,null,null,null,45,null,null,null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,null,45,null,null,null,null,null,null,null,null,null,"","(ALL)",0,0]
[null,null,null,null,null,null,46,null,null,null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,null,46,null,null,null,null,null,null,null,null,null,"","(ALL)",0,0]
[null,null,null,null,null,null,47,null,null,null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,null,47,null,null,null,null,null,null,null,null,null,"","(ALL)",0,0]
[null,null,null,null,null,null,48,null,null,null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,null,48,null,null,null,null,null,null,null,null,null,"","(ALL)",0,0]
[null,null,null,null,null,null,49,null,null,null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,null,49,null,null,null,null,null,null,null,null,null,"","(ALL)",0,0]
[null,null,null,null,null,null,50,null,null,null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,null,50,null,null,null,null,null,null,null,null,null,"","(ALL)",0,0]
[null,null,null,null,null,null,51,null,null,null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,null,51,null,null,null,null,null,null,null,null,null,"","(ALL)",0,0]
[null,null,null,null,null,null,52,null,null,null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,null,52,null,null,null,null,null,null,null,null,null,"","(ALL)",0,0]
[null,null,null,null,null,null,53,null,null,null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,null,53,null,null,null,null,null,null,null,null,null,"","(ALL)",0,0]
[null,null,null,null,null,null,54,null,null,null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,null,54,null,null,null,null,null,null,null,null,null,"","(ALL)",0,0]
[null,null,null,null,null,null,55,null,null,null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,null,55,null,null,null,null,null,null,null,null,null,"","(ALL)",0,0]
[null,null,null,null,null,null,56,null,null,null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,null,56,null,null,null,null,null,null,null,null,null,"","(ALL)",0,0]
[null,null,null,null,null,null,57,null,null,null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,null,57,null,null,null,null,null,null,null,null,null,"","(ALL)",0,0]
[null,null,null,null,null,null,{"$f":"+G127+1","v":58},null,null,null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,null,58,null,null,null,null,null,null,null,null,null,"",{"$f":"IFERROR((MID(AA128,(FIND(\"(\",AA128)+1),(LEN(AA128))-(FIND(\"(\",AA128)+1))),\"\")","v":""},0,0]
[null,null,null,null,null,null,59,null,null,null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,null,59,null,null,null,null,null,null,null,null,null,"","",0,0]
[null,null,null,null,null,null,60,null,null,null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,null,60,null,null,null,null,null,null,null,null,null,"","",0,0]
[null,null,null,null,null,null,61,null,null,null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,null,61,null,null,null,null,null,null,null,null,null,"","",0,0]
[null,null,null,null,null,null,62,null,null,null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,null,62,null,null,null,null,null,null,null,null,null,"","",0,0]
[null,null,null,null,null,null,63,null,null,null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,null,63,null,null,null,null,null,null,null,null,null,"","",0,0]
[null,null,null,null,null,null,64,null,null,null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,null,64,null,null,null,null,null,null,null,null,null,"","",0,0]
[null,null,null,null,null,null,65,null,null,null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,null,65,null,null,null,null,null,null,null,null,null,"","",0,0]
[null,null,null,null,null,null,66,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR((+N136/R136),0)","v":0},{"$f":"SUMIF($M$289:$M$427,H136,$F$289:$F$427)","v":0},null,null,null,null,null,null,null,66,null,null,null,null,null,null,null,null,null,"","",{"$f":"IFERROR((+AG136/AM136),0)","v":0},{"$f":"SUMIF($L$289:$L$427,AK136,$F$289:$F$427)","v":0}]
[null,null,null,null,null,null,67,null,null,null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,null,67,null,null,null,null,null,null,null,null,null,"","",0,0]
[null,null,null,null,null,null,68,null,null,null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,null,68,null,null,null,null,null,null,null,null,null,"","",0,0]
[null,null,null,null,null,null,69,null,null,null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,null,69,null,null,null,null,null,null,null,null,null,"","",0,0]
[null,null,null,null,null,null,70,null,null,null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,null,70,null,null,null,null,null,null,null,null,null,"","",0,0]
[null,null,null,null,null,null,71,null,null,null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,null,71,null,null,null,null,null,null,null,null,null,"","",0,0]
[null,null,null,null,null,null,72,null,null,null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,null,72,null,null,null,null,null,null,null,null,null,"","",0,0]
[null,null,null,null,null,null,73,null,null,null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,null,73,null,null,null,null,null,null,null,null,null,"","",0,0]
[null,null,null,null,null,null,74,null,null,null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,null,74,null,null,null,null,null,null,null,null,null,"","",0,0]
[null,null,null,null,null,null,75,null,null,null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,null,75,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR((LEFT(AA145,(FIND(\"(\",AA145)-1))),\"\")","v":""},{"$f":"IFERROR((MID(AA145,(FIND(\"(\",AA145)+1),(LEN(AA145))-(FIND(\"(\",AA145)+1))),\"\")","v":""},0,0]
[null,null,null,null,null,null,76,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,76,null,null,null,null,null,null,null,null,null,"","",0,0]
[null,null,null,null,null,null,77,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,77,null,null,null,null,null,null,null,null,null,"","",0,0]
[null,null,null,null,null,null,78,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,78,null,null,null,null,null,null,null,null,null,"","",0,0]
[null,null,null,null,null,null,79,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,79,null,null,null,null,null,null,null,null,null,"","",0,0]
[null,null,null,null,null,null,80,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,80,null,null,null,null,null,null,null,null,null,"","",0,0]
[null,null,null,null,null,null,81,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,81,null,null,null,null,null,null,null,null,null,"","",0,0]
[null,null,null,null,null,null,82,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,82,null,null,null,null,null,null,null,null,null,"","",0,0]
[null,null,null,null,null,null,83,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,83,null,null,null,null,null,null,null,null,null,"","",0,0]
[null,null,null,null,null,null,84,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,84,null,null,null,null,null,null,null,null,null,"","",0,0]
[null,null,null,null,null,null,85,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,85,null,null,null,null,null,null,null,null,null,"","",0,0]
[null,null,null,null,null,null,86,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,86,null,null,null,null,null,null,null,null,null,"","",0,0]
[null,null,null,null,null,null,87,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,87,null,null,null,null,null,null,null,null,null,"","",0,0]
[null,null,null,null,null,null,88,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,88,null,null,null,null,null,null,null,null,null,"","",0,0]
[null,null,null,null,null,null,89,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,89,null,null,null,null,null,null,null,null,null,"","",0,0]
[null,null,null,null,null,null,90,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,90,null,null,null,null,null,null,null,null,null,"","",0,0]
[null,null,null,null,null,null,91,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,91,null,null,null,null,null,null,null,null,null,"","",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,92,null,null,null,null,null,null,null,null,null,"","",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,93,null,null,null,null,null,null,null,null,null,"","",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,94,null,null,null,null,null,null,null,null,null,"","",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,95,null,null,null,null,null,null,null,null,null,"","",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,96,null,null,null,null,null,null,null,null,null,"","",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,97,null,null,null,null,null,null,null,null,null,"","",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,98,null,null,null,null,null,null,null,null,null,"","",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,99,null,null,null,null,null,null,null,null,null,"","",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100,null,null,null,null,null,null,null,null,null,"","",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,101,null,null,null,null,null,null,null,null,null,"","",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,102,null,null,null,null,null,null,null,null,null,"","",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,103,null,null,null,null,null,null,null,null,null,"","",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,104,null,null,null,null,null,null,null,null,null,"","",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,105,null,null,null,null,null,null,null,null,null,"","",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,106,null,null,null,null,null,null,null,null,null,"","",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,107,null,null,null,null,null,null,null,null,null,"","",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,108,null,null,null,null,null,null,null,null,null,"","",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,109,null,null,null,null,null,null,null,null,null,"","",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,110,null,null,null,null,null,null,null,null,null,"","",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,111,null,null,null,null,null,null,null,null,null,"","",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,112,null,null,null,null,null,null,null,null,null,"","",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,113,null,null,null,null,null,null,null,null,null,"","",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,114,null,null,null,null,null,null,null,null,null,"","",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,115,null,null,null,null,null,null,null,null,null,"","",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,116,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR((LEFT(AA186,(FIND(\"(\",AA186)-1))),\"\")","v":""},{"$f":"IFERROR((MID(AA186,(FIND(\"(\",AA186)+1),(LEN(AA186))-(FIND(\"(\",AA186)+1))),\"\")","v":""},{"$f":"IFERROR((+AG186/AM186),0)","v":0},{"$f":"SUMIF($L$289:$L$427,AK186,$F$289:$F$427)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,117,null,null,null,null,null,null,null,null,null,"","",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,118,null,null,null,null,null,null,null,null,null,"","",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,119,null,null,null,null,null,null,null,null,null,"","",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",0,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"…………………………….. P r o c e s a n d o…………….."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"LIN+MAR",4,"J271 J500"]
[null,null,null,null,null,null,"LIN+MAR+ITE",9,"I271 I500"]
[null,null,null,null,null,null,"LIN+ITEM",6,"H271 H500"]
[null,null,null,null,null,null,"MAR+ITEM",8,"G271 G500"]
[null,null,null,null,null,null,"TODO",0," TOTAL"]
[null,null,null,null,null,null,"SOLO LINEA",1,"K271 K500"]

{"sheet":"Hoja2","index":4,"n_rows":8,"n_cols":2,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["ANIMUS","LINEA_ALFA"]
["DISCONTINUADOS","LINEA_BETA"]
["FORTIA","Linea"]
["NOVUS"]
["OPTIMUN"]
["OTROS PROD"]
["SIGNUM"]
["TEMPUS"]