{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Aux","UsoParametros"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":10,"comments":0,"pivot_tables":1},"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":"Aux","index":0,"n_rows":13,"n_cols":16,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[null,"Fecha",null,"Año",null,"Mes",null,"Número","Nombre",null,"NombreMes",null,"NombreMesdeFecha"]
[null,"2012-09-05",null,2012,null,9,null,1,"Enero",null,{"$f":"VLOOKUP(rgMes,rgMeses,2,0)","v":"Septiembre"},null,{"$f":"TEXT(rgFecha,\"mmmm\")","v":"septiembre"},null,null,"Uso de parámetros >>"]
[null,null,null,null,null,null,null,2,"Febrero"]
[null,null,null,null,null,null,null,3,"Marzo"]
[null,null,null,null,null,null,null,4,"Abril"]
[null,null,null,null,null,null,null,5,"Mayo"]
[null,null,null,null,null,null,null,6,"Junio"]
[null,null,null,null,null,null,null,7,"Julio"]
[null,null,null,null,null,null,null,8,"Agosto"]
[null,null,null,null,null,null,null,9,"Septiembre"]
[null,null,null,null,null,null,null,10,"Octubre"]
[null,null,null,null,null,null,null,11,"Noviembre"]
[null,null,null,null,null,null,null,12,"Diciembre"]

{"sheet":"UsoParametros","index":1,"n_rows":19,"n_cols":15,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"<< Definición de rangos"]
[]
[]
[null,"Venta","A/M",null,null,null,null,null,null,null,null,null,null,"Referencia al año actual"]
[null,null,2012,null,null,null,null,null,null,null,null,"Total general",null,"Fórmula","=rgAño"]
[null,"Municipio",1,2,3,4,5,6,7,8,9,null,null,"Valor",{"$f":"rgAño","v":2012}]
[null,"ALCOBENDAS",384.78000000000003,298.38000000000005,565.36199999999997,783.39,838.60979999999995,451.90000000000003,213.91840000000002,994.87399999999991,370.32830000000001,4901.5424999999996]
[null,"ALCORCON",null,48,11,null,null,null,22,null,98,179,null,"Referencia a las ventas de Madrid del mes de junio"]
[null,"BECERRIL DE LA SIERRA",141,null,null,90,96,79,40,null,null,446,null,"Fórmula","=IMPORTARDATOSDINAMICOS(\"IMPORTE_POTENCIAL\";$N$5;\"Año\";2012;\"Mes\";6;\"POBLACION\";\"MADRID\")"]
[null,"COLMENAR VIEJO",1023,1306,994,800,1039,855,882,294,606,7799,null,"Valor",{"$f":"GETPIVOTDATA(\"IMPORTE_POTENCIAL\",$B$5,\"Año\",2012,\"Mes\",6,\"POBLACION\",\"MADRID\")","v":4289}]
[null,"LEGANES",172.85,null,null,null,null,null,null,null,null,172.85]
[null,"MADRID",3515,3535,2716,2155,2643,4289,3102,3103,3365,28423,null,"Referencia a las ventas de Madrid del mes @PAR(Mes) y el año @PAR(Año), año y mes indicados como parámetros de ejecución del informe"]
[null,"Total general",5236.63,5187.38,4286.3620000000001,3828.39,4616.6098000000002,5674.9,4259.9184000000005,4391.8739999999998,4439.3283000000001,41921.392500000002,null,"Fórmula","=IMPORTARDATOSDINAMICOS(\"IMPORTE_POTENCIAL\";$N$5;\"Año\";rgAño;\"Mes\";rgMes;\"POBLACION\";\"MADRID\")"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Valor",{"$f":"GETPIVOTDATA(\"IMPORTE_POTENCIAL\",$B$5,\"Año\",rgAño,\"Mes\",rgMes,\"POBLACION\",\"MADRID\")","v":3365}]
[]
[null,null,1,2,3,4,5,6,7,8,9,null,null,"Tabla con datos de ventas mensuales de Madrid y Colmenar Viejo"]
[null,"Madrid",{"$f":"GETPIVOTDATA(\"IMPORTE_POTENCIAL\",$B$5,\"Año\",rgAño,\"Mes\",C$17,\"POBLACION\",$B18)","v":3515},{"$f":"GETPIVOTDATA(\"IMPORTE_POTENCIAL\",$B$5,\"Año\",rgAño,\"Mes\",D$17,\"POBLACION\",$B18)","v":3535},{"$f":"GETPIVOTDATA(\"IMPORTE_POTENCIAL\",$B$5,\"Año\",rgAño,\"Mes\",E$17,\"POBLACION\",$B18)","v":2716},{"$f":"GETPIVOTDATA(\"IMPORTE_POTENCIAL\",$B$5,\"Año\",rgAño,\"Mes\",F$17,\"POBLACION\",$B18)","v":2155},{"$f":"GETPIVOTDATA(\"IMPORTE_POTENCIAL\",$B$5,\"Año\",rgAño,\"Mes\",G$17,\"POBLACION\",$B18)","v":2643},{"$f":"GETPIVOTDATA(\"IMPORTE_POTENCIAL\",$B$5,\"Año\",rgAño,\"Mes\",H$17,\"POBLACION\",$B18)","v":4289},{"$f":"GETPIVOTDATA(\"IMPORTE_POTENCIAL\",$B$5,\"Año\",rgAño,\"Mes\",I$17,\"POBLACION\",$B18)","v":3102},{"$f":"GETPIVOTDATA(\"IMPORTE_POTENCIAL\",$B$5,\"Año\",rgAño,\"Mes\",J$17,\"POBLACION\",$B18)","v":3103},{"$f":"GETPIVOTDATA(\"IMPORTE_POTENCIAL\",$B$5,\"Año\",rgAño,\"Mes\",K$17,\"POBLACION\",$B18)","v":3365}]
[null,"Colmenar Viejo",{"$f":"GETPIVOTDATA(\"IMPORTE_POTENCIAL\",$B$5,\"Año\",rgAño,\"Mes\",C$17,\"POBLACION\",$B19)","v":1023},{"$f":"GETPIVOTDATA(\"IMPORTE_POTENCIAL\",$B$5,\"Año\",rgAño,\"Mes\",D$17,\"POBLACION\",$B19)","v":1306},{"$f":"GETPIVOTDATA(\"IMPORTE_POTENCIAL\",$B$5,\"Año\",rgAño,\"Mes\",E$17,\"POBLACION\",$B19)","v":994},{"$f":"GETPIVOTDATA(\"IMPORTE_POTENCIAL\",$B$5,\"Año\",rgAño,\"Mes\",F$17,\"POBLACION\",$B19)","v":800},{"$f":"GETPIVOTDATA(\"IMPORTE_POTENCIAL\",$B$5,\"Año\",rgAño,\"Mes\",G$17,\"POBLACION\",$B19)","v":1039},{"$f":"GETPIVOTDATA(\"IMPORTE_POTENCIAL\",$B$5,\"Año\",rgAño,\"Mes\",H$17,\"POBLACION\",$B19)","v":855},{"$f":"GETPIVOTDATA(\"IMPORTE_POTENCIAL\",$B$5,\"Año\",rgAño,\"Mes\",I$17,\"POBLACION\",$B19)","v":882},{"$f":"GETPIVOTDATA(\"IMPORTE_POTENCIAL\",$B$5,\"Año\",rgAño,\"Mes\",J$17,\"POBLACION\",$B19)","v":294},{"$f":"GETPIVOTDATA(\"IMPORTE_POTENCIAL\",$B$5,\"Año\",rgAño,\"Mes\",K$17,\"POBLACION\",$B19)","v":606},null,null,"Gráfico comparativo de ventas entre Madrid y Colmenar Viejo"]