{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Dashboard","Ayuda y Version","pBlock","pAccel0","pAccel1","empresa_ccaa"],"not_rendered":{"charts":12,"images":7,"macros":1,"external_links":0,"defined_names":6,"comments":0,"pivot_tables":0},"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":"Dashboard","index":0,"n_rows":49,"n_cols":25,"rows_kept":49,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,2020]
[null,null,null,null,null,null,null,null,null,null,null,null,"ABRIL",null,null,null,null,"Empresa - Sector","Empresa - Sector"]
["Acumulado a:",{"$f":"M4","v":"ABRIL"},null,null,"Datos acumulados",null,"Cuota Negocio / Total ASEMPLEO",null,null,{"$f":"empresa_ccaa!L5","v":"iEMPRESA"},null,"¿▲\"sin\" mi Empresa?",null,null,null,null,null,null,"p.p."]
["Total","Facturación, €",null,"(a)",{"$f":"J5","v":"iEMPRESA"},null,null,null,"Cuota de Facturación","∆",null,"(b)","∆ (a-b)",null,null,null,null,null,"Puntos porcentuales"]
[null,2019,2020,"% i.a.",{"$f":"B7","v":2019},{"$f":"C7","v":2020},"% i.a.",{"$f":"E7","v":2019},{"$f":"F7","v":2020},"Dif.P.P.",null,"% i.a.","Dif.P.P.",null,null,null,null,"Dif. Ritmo","Importancia Relativa",null,null,"Empresa"]
["Nacional",{"$f":"empresa_ccaa!F12","v":1277637816.628484},{"$f":"empresa_ccaa!G12","v":1148608609.9072335},{"$f":"((C8/B8)-1)","v":-0.10099044114218647},{"$f":"empresa_ccaa!K12","v":0},{"$f":"empresa_ccaa!L12","v":0},{"$f":"IF(E8>0,((F8/E8)-1),\"n.a.\")","v":"n.a."},{"$f":"E8/B8","v":0},{"$f":"F8/C8","v":0},{"$f":"(I8-H8)*100","v":0},null,{"$f":"((C8-F8)/(B8-E8))-1","v":-0.10099044114218647},{"$f":"(D8-L8)*100","v":0},null,null,null,null,{"$f":"IF(G8=\"n.a.\",\"n.a.\",(G8-D8)*100)","v":"n.a."},{"$f":"empresa_ccaa!M12-empresa_ccaa!H12","v":{"$error":"#DIV/0!"}},null,"criterio_rank","peso","Comunidad","% i.a.","Total_Regional"]
["ANDALUCIA",{"$f":"empresa_ccaa!F13","v":104777541.1735598},{"$f":"empresa_ccaa!G13","v":104818275.12255777},{"$f":"((C9/B9)-1)","v":3.8876603269866195E-4},{"$f":"empresa_ccaa!K13","v":0},{"$f":"empresa_ccaa!L13","v":0},"n.a.",{"$f":"E9/B9","v":0},{"$f":"F9/C9","v":0},{"$f":"(I9-H9)*100","v":0},null,{"$f":"((C9-F9)/(B9-E9))-1","v":3.8876603269866195E-4},0,null,null,null,null,{"$f":"IF(G9=\"n.a.\",\"n.a.\",(G9-D9)*100)","v":"n.a."},{"$f":"empresa_ccaa!M13-empresa_ccaa!H13","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(V9=$V$27,1,0)","v":1},{"$f":"I9","v":0},{"$f":"A9","v":"ANDALUCIA"},{"$f":"G9","v":"n.a."},{"$f":"D9","v":3.8876603269866195E-4}]
["ARAGON",{"$f":"empresa_ccaa!F14","v":63318988.808063805},{"$f":"empresa_ccaa!G14","v":54091175.420959704},{"$f":"((C10/B10)-1)","v":-0.14573532459711236},{"$f":"empresa_ccaa!K14","v":0},{"$f":"empresa_ccaa!L14","v":0},"n.a.",0,0,0,null,-0.14573532459711236,0,null,null,null,null,"n.a.",{"$f":"empresa_ccaa!M14-empresa_ccaa!H14","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(V10=$V$27,1,0)","v":1},0,"ARAGON",{"$f":"G10","v":"n.a."},{"$f":"D10","v":-0.14573532459711236}]
["ASTURIAS",{"$f":"empresa_ccaa!F15","v":21408824.960594188},{"$f":"empresa_ccaa!G15","v":19706909.201977435},-7.9495991104105768E-2,{"$f":"empresa_ccaa!K15","v":0},{"$f":"empresa_ccaa!L15","v":0},"n.a.",0,0,0,null,-7.9495991104105768E-2,0,null,null,null,null,"n.a.",{"$f":"empresa_ccaa!M15-empresa_ccaa!H15","v":{"$error":"#DIV/0!"}},null,1,0,"ASTURIAS","n.a.",-7.9495991104105768E-2]
["BALEARES",{"$f":"empresa_ccaa!F16","v":4492980.0373369809},{"$f":"empresa_ccaa!G16","v":2926723.1656061881},-0.34860089711396169,{"$f":"empresa_ccaa!K16","v":0},{"$f":"empresa_ccaa!L16","v":0},{"$f":"IF(E12>0,((F12/E12)-1),\"n.a.\")","v":"n.a."},0,0,0,null,-0.34860089711396169,0,null,null,null,null,"n.a.",{"$f":"empresa_ccaa!M16-empresa_ccaa!H16","v":{"$error":"#DIV/0!"}},null,1,0,"BALEARES","n.a.",-0.34860089711396169]
["CANARIAS",{"$f":"empresa_ccaa!F17","v":30756687.532573137},{"$f":"empresa_ccaa!G17","v":23197317.166429266},-0.24577973028265976,{"$f":"empresa_ccaa!K17","v":0},{"$f":"empresa_ccaa!L17","v":0},"n.a.",0,0,0,null,-0.24577973028265976,0,null,null,null,null,"n.a.",{"$f":"empresa_ccaa!M17-empresa_ccaa!H17","v":{"$error":"#DIV/0!"}},null,1,0,"CANARIAS","n.a.",-0.24577973028265976]
["CANTABRIA",{"$f":"empresa_ccaa!F18","v":33989925.051196188},{"$f":"empresa_ccaa!G18","v":31251849.513747938},-8.0555503824268904E-2,{"$f":"empresa_ccaa!K18","v":0},{"$f":"empresa_ccaa!L18","v":0},"n.a.",0,0,0,null,-8.0555503824268904E-2,0,null,null,null,null,"n.a.",{"$f":"empresa_ccaa!M18-empresa_ccaa!H18","v":{"$error":"#DIV/0!"}},null,1,0,"CANTABRIA","n.a.",-8.0555503824268904E-2]
["CASTILLA-LA MANCHA",{"$f":"empresa_ccaa!F19","v":53369874.849731982},{"$f":"empresa_ccaa!G19","v":56166562.200408727},5.2401984425691328E-2,{"$f":"empresa_ccaa!K19","v":0},{"$f":"empresa_ccaa!L19","v":0},"n.a.",0,0,0,null,5.2401984425691328E-2,0,null,null,null,null,"n.a.",{"$f":"empresa_ccaa!M19-empresa_ccaa!H19","v":{"$error":"#DIV/0!"}},null,1,0,"CASTILLA-LA MANCHA","n.a.",5.2401984425691328E-2]
["CASTILLA Y LEÓN",{"$f":"empresa_ccaa!F20","v":78340915.965112209},{"$f":"empresa_ccaa!G20","v":72292647.53796643},-7.7204464010087293E-2,{"$f":"empresa_ccaa!K20","v":0},{"$f":"empresa_ccaa!L20","v":0},"n.a.",0,0,{"$f":"(I16-H16)*100","v":0},null,-7.7204464010087293E-2,0,null,null,null,null,"n.a.",{"$f":"empresa_ccaa!M20-empresa_ccaa!H20","v":{"$error":"#DIV/0!"}},null,1,0,"CASTILLA Y LEÓN","n.a.",-7.7204464010087293E-2]
["CATALUÑA",{"$f":"empresa_ccaa!F21","v":311856946.9589687},{"$f":"empresa_ccaa!G21","v":258136831.18729129},-0.17225883949522991,{"$f":"empresa_ccaa!K21","v":0},{"$f":"empresa_ccaa!L21","v":0},{"$f":"IF(E17>0,((F17/E17)-1),\"n.a.\")","v":"n.a."},0,0,{"$f":"(I17-H17)*100","v":0},null,-0.17225883949522991,0,null,null,null,null,"n.a.",{"$f":"empresa_ccaa!M21-empresa_ccaa!H21","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(V17=$V$27,1,0)","v":1},{"$f":"I17","v":0},"CATALUÑA","n.a.",-0.17225883949522991]
["COMUNIDAD VALENCIANA",{"$f":"empresa_ccaa!F22","v":103495814.48706615},{"$f":"empresa_ccaa!G22","v":90510714.073211238},-0.12546498115126825,{"$f":"empresa_ccaa!K22","v":0},{"$f":"empresa_ccaa!L22","v":0},"n.a.",0,0,{"$f":"(I18-H18)*100","v":0},null,-0.12546498115126825,0,null,null,null,null,"n.a.",{"$f":"empresa_ccaa!M22-empresa_ccaa!H22","v":{"$error":"#DIV/0!"}},null,1,0,"COMUNIDAD VALENCIANA","n.a.",-0.12546498115126825]
["EXTREMADURA",{"$f":"empresa_ccaa!F23","v":7732105.923550793},{"$f":"empresa_ccaa!G23","v":8451228.5936064273},9.3004761854761808E-2,{"$f":"empresa_ccaa!K23","v":0},{"$f":"empresa_ccaa!L23","v":0},"n.a.",0,0,0,null,9.3004761854761808E-2,0,null,null,null,null,"n.a.",{"$f":"empresa_ccaa!M23-empresa_ccaa!H23","v":{"$error":"#DIV/0!"}},null,1,0,"EXTREMADURA","n.a.",9.3004761854761808E-2]
["GALICIA",{"$f":"empresa_ccaa!F24","v":66806638.676306754},{"$f":"empresa_ccaa!G24","v":66225111.637253664},-8.7046295184931566E-3,{"$f":"empresa_ccaa!K24","v":0},{"$f":"empresa_ccaa!L24","v":0},"n.a.",0,0,0,null,-8.7046295184931566E-3,0,null,null,null,null,"n.a.",{"$f":"empresa_ccaa!M24-empresa_ccaa!H24","v":{"$error":"#DIV/0!"}},null,1,0,"GALICIA","n.a.",-8.7046295184931566E-3]
["MADRID",{"$f":"empresa_ccaa!F25","v":205693191.33717352},{"$f":"empresa_ccaa!G25","v":186902675.00408626},-9.1352155173117677E-2,{"$f":"empresa_ccaa!K25","v":0},{"$f":"empresa_ccaa!L25","v":0},"n.a.",0,0,0,null,-9.1352155173117677E-2,0,null,null,null,null,"n.a.",{"$f":"empresa_ccaa!M25-empresa_ccaa!H25","v":{"$error":"#DIV/0!"}},null,1,0,"MADRID","n.a.",-9.1352155173117677E-2]
["MURCIA",{"$f":"empresa_ccaa!F26","v":70809969.861232087},{"$f":"empresa_ccaa!G26","v":77371479.263089582},9.2663637828348744E-2,{"$f":"empresa_ccaa!K26","v":0},{"$f":"empresa_ccaa!L26","v":0},"n.a.",0,0,0,null,9.2663637828348744E-2,0,null,null,null,null,"n.a.",{"$f":"empresa_ccaa!M26-empresa_ccaa!H26","v":{"$error":"#DIV/0!"}},null,1,0,"MURCIA","n.a.",9.2663637828348744E-2]
["NAVARRA",{"$f":"empresa_ccaa!F27","v":46749107.076008908},{"$f":"empresa_ccaa!G27","v":38808347.381455652},-0.16985906664789241,{"$f":"empresa_ccaa!K27","v":0},{"$f":"empresa_ccaa!L27","v":0},"n.a.",0,0,0,null,-0.16985906664789241,0,null,null,null,null,"n.a.",{"$f":"empresa_ccaa!M27-empresa_ccaa!H27","v":{"$error":"#DIV/0!"}},null,1,0,"NAVARRA","n.a.",-0.16985906664789241]
["PAIS VASCO",{"$f":"empresa_ccaa!F28","v":62413140.050434485},{"$f":"empresa_ccaa!G28","v":47537442.743480258},-0.23834239544643243,{"$f":"empresa_ccaa!K28","v":0},{"$f":"empresa_ccaa!L28","v":0},"n.a.",0,0,0,null,-0.23834239544643243,0,null,null,null,null,"n.a.",{"$f":"empresa_ccaa!M28-empresa_ccaa!H28","v":{"$error":"#DIV/0!"}},null,1,0,"PAIS VASCO","n.a.",-0.23834239544643243]
["RIOJA (LA)",{"$f":"empresa_ccaa!F29","v":11625163.879574209},{"$f":"empresa_ccaa!G29","v":10213320.694105927},-0.12144716410827872,{"$f":"empresa_ccaa!K29","v":0},{"$f":"empresa_ccaa!L29","v":0},"n.a.",0,0,0,null,-0.12144716410827872,0,null,null,null,null,"n.a.",{"$f":"empresa_ccaa!M29-empresa_ccaa!H29","v":{"$error":"#DIV/0!"}},null,1,0,"RIOJA (LA)","n.a.",-0.12144716410827872]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"codifico=1","máximo"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DMAX(U8:W25,V8,U8:U25)*1","v":0},{"$f":"MAX(V9:V25)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"I6","v":"Cuota de Facturación"},null,null,null,null,null,null,null,null,null,"geo data",{"$f":"VLOOKUP(1,U8:Y25,3,0)","v":"ANDALUCIA"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"I7","v":2020},null,null,null,null,null,null,null,"el dato a buscar debe estar en la primera columna. "]
[null,"% i.a.",null,null,null,"% i.a.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(1,U8:Y25,4,0)*1","v":{"$error":"#VALUE!"}}]
[null,{"$f":"C7","v":2020},null,null,null,{"$f":"B31","v":2020},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(1,U8:Y25,5,0)*1","v":3.8876603269866195E-4}]
[null,"Total",null,null,null,"Empresa",null,null,null,{"$f":"J5","v":"iEMPRESA"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Ámbito"]
["Ámbito",{"$f":"F34","v":"Nacional"},null,null,null,{"$f":"J34","v":"Nacional"},null,null,null,"Nacional",null,null,"Nacional"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"U28","v":"ANDALUCIA"},null,null,"CCAA"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Líder para la"]
[null,"% i.a.",null,null,null,"% i.a.",null,null,null,null,null,null,"Empresa"]
[null,{"$f":"B31","v":2020},null,null,null,{"$f":"B41","v":2020}]
[null,"Total",null,null,null,"Empresa",null,null,null,{"$f":"J32","v":"iEMPRESA"}]
[]
["Ámbito",{"$f":"F44","v":"ANDALUCIA"},null,null,null,{"$f":"J44","v":"ANDALUCIA"},null,null,null,{"$f":"J38","v":"ANDALUCIA"}]
[]
[]
[]
["Fuente: Cifras consolidadas del sector. Valores absolutos 2015-2020 y cifras de evolución de 2016 a la fecha. ASEMPLEO ©."]
["Nota de Confidencialidad: Este informe comparativo contiene datos redondeados que son ficticeos y serán reemplazados por los que la Empresa introduzca en \"empresa_ccaa\"."]

{"sheet":"Ayuda y Version","index":1,"n_rows":2,"n_cols":8,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,null,null,null,null,"Versión de plantilla:",2.5]

{"sheet":"pBlock","index":2,"n_rows":5,"n_cols":3,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[null,"Block Test"]
[null,"Info1","Info2"]

{"sheet":"pAccel0","index":3,"n_rows":30,"n_cols":42,"rows_kept":30,"cut":false,"hidden":true,"merged":[]}
["Gauge Configuration",null,null,null,null,null,null,null,null,null,null,null,null,null,"Gauge Configuration",null,null,null,null,null,null,null,null,null,null,"Gauge Configuration",null,null,null,null,null,null,null,null,null,null,"Gauge Configuration"]
[null,null,null,null,null,"Decal",null,null,null,null,null,null,null,null,null,null,null,null,null,"Decal",null,null,null,null,null,null,null,null,null,null,"Decal",null,null,null,null,null,null,null,null,null,null,"Decal"]
["Title:",{"$f":"Dashboard!#REF!","v":{"$error":"#REF!"}},null,null,null,0,null,null,null,null,null,null,null,null,"Title:",{"$f":"pAccel0!B3","v":{"$error":"#REF!"}},null,null,null,0,null,null,null,null,null,"Title:","Empresa",null,null,null,0,null,null,null,null,null,"Title:","CCAA",null,null,null,0]
["Real Value:",{"$f":"Dashboard!#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,"Real Value:",{"$f":"Dashboard!I8","v":0},null,null,null,null,null,null,null,null,null,"Real Value:",{"$f":"Dashboard!I8","v":0},null,null,null,null,null,null,null,null,null,"Real Value:",{"$f":"Dashboard!U27","v":0}]
[]
["Color bands",null,null,null,null,null,null,null,null,null,null,null,null,null,"Color bands",null,null,null,null,null,null,null,null,null,null,"Color bands",null,null,null,null,null,null,null,null,null,null,"Color bands"]
["Red:",2,null,null,null,null,null,null,null,null,null,null,null,null,"Red:",2,null,null,null,null,null,null,null,null,null,"Red:",2,null,null,null,null,null,null,null,null,null,"Red:",2]
["Yellow:",15,null,null,null,null,null,null,null,null,null,null,null,null,"Yellow:",15,null,null,null,null,null,null,null,null,null,"Yellow:",15,null,null,null,null,null,null,null,null,null,"Yellow:",15]
["Green:",23,null,null,null,null,null,null,null,null,null,null,null,null,"Green:",23,null,null,null,null,null,null,null,null,null,"Green:",23,null,null,null,null,null,null,null,null,null,"Green:",23]
[]
["Advanced Parameters",null,null,null,null,null,null,null,null,null,null,null,null,null,"Advanced Parameters",null,null,null,null,null,null,null,null,null,null,"Advanced Parameters",null,null,null,null,null,null,null,null,null,null,"Advanced Parameters"]
[null,"Value to 100%",{"$f":"IF(ISERROR((B4-F3/100)*B27),0,(B4-F3/100)*B27)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"Value to 100%",{"$f":"IF(ISERROR((P4-T3/100)*P27),0,(P4-T3/100)*P27)","v":0},null,null,null,null,null,null,null,null,null,"Value to 100%",{"$f":"IF(ISERROR((AA4-AE3/100)*AA27),0,(AA4-AE3/100)*AA27)","v":0},null,null,null,null,null,null,null,null,null,"Value to 100%",{"$f":"IF(ISERROR((AL4-AP3/100)*AL27),0,(AL4-AP3/100)*AL27)","v":0}]
[null,"Relative value",{"$f":"IF(C12>100%,102%,IF(C12<0%,-2%,C12))*1.506-0.253","v":-0.253},null,null,null,null,null,null,null,null,null,null,null,null,"Relative value",{"$f":"IF(Q12>100%,102%,IF(Q12<0%,-2%,Q12))*1.506-0.253","v":-0.253},null,null,null,null,null,null,null,null,null,"Relative value",{"$f":"IF(AB12>100%,102%,IF(AB12<0%,-2%,AB12))*1.506-0.253","v":-0.253},null,null,null,null,null,null,null,null,null,"Relative value",{"$f":"IF(AM12>100%,102%,IF(AM12<0%,-2%,AM12))*1.506-0.253","v":-0.253}]
[]
["Angle",null,{"$f":"C13*PI()","v":-0.79482294135821763},null,null,null,null,null,null,null,null,null,null,null,"Angle",null,{"$f":"Q13*PI()","v":-0.79482294135821763},null,null,null,null,null,null,null,null,"Angle",null,{"$f":"AB13*PI()","v":-0.79482294135821763},null,null,null,null,null,null,null,null,"Angle",null,{"$f":"AM13*PI()","v":-0.79482294135821763}]
["x",0,{"$f":"-COS(C15)","v":-0.70041115078380645},null,null,null,null,null,null,null,null,null,null,null,"x",0,{"$f":"-COS(Q15)","v":-0.70041115078380645},null,null,null,null,null,null,null,null,"x",0,{"$f":"-COS(AB15)","v":-0.70041115078380645},null,null,null,null,null,null,null,null,"x",0,{"$f":"-COS(AM15)","v":-0.70041115078380645}]
["y",0,{"$f":"SIN(C15)","v":-0.7137396022764213},null,null,null,null,null,null,null,null,null,null,null,"y",0,{"$f":"SIN(Q15)","v":-0.7137396022764213},null,null,null,null,null,null,null,null,"y",0,{"$f":"SIN(AB15)","v":-0.7137396022764213},null,null,null,null,null,null,null,null,"y",0,{"$f":"SIN(AM15)","v":-0.7137396022764213}]
[]
[null,null,null,"Value","Label",null,null,null,null,null,null,null,null,null,null,null,null,"Value","Label",null,null,null,null,null,null,null,null,null,"Value","Label",null,null,null,null,null,null,null,null,null,"Value","Label"]
[null,null,70,10,{"$f":"B26+F3","v":4},null,null,null,null,null,null,null,null,null,null,null,70,10,{"$f":"P26+T3","v":4},null,null,null,null,null,null,null,null,70,10,{"$f":"AA26+AE3","v":4},null,null,null,null,null,null,null,null,70,10,{"$f":"AL26+AP3","v":4}]
[null,null,{"$f":"B7*$C$20/$B$25","v":3.5},10,{"$f":"E20+$B$26","v":8},null,null,null,null,null,null,null,null,null,null,null,{"$f":"P7*$C$20/$B$25","v":3.5},10,{"$f":"S20+$B$26","v":8},null,null,null,null,null,null,null,null,{"$f":"AA7*$AB$20/$AA$25","v":3.5},10,{"$f":"AD20+$AA$26","v":8},null,null,null,null,null,null,null,null,{"$f":"AL7*$AM$20/$AL$25","v":3.5},10,{"$f":"AO20+$AL$26","v":8}]
[null,null,{"$f":"B8*$C$20/$B$25","v":26.25},10,12,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P8*$C$20/$B$25","v":26.25},10,12,null,null,null,null,null,null,null,null,{"$f":"AA8*$AB$20/$AA$25","v":26.25},10,12,null,null,null,null,null,null,null,null,{"$f":"AL8*$AM$20/$AL$25","v":26.25},10,{"$f":"AO21+$AL$26","v":12}]
[null,null,{"$f":"B9*$C$20/$B$25","v":40.25},10,16,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P9*$C$20/$B$25","v":40.25},10,16,null,null,null,null,null,null,null,null,{"$f":"AA9*$AB$20/$AA$25","v":40.25},10,16,null,null,null,null,null,null,null,null,40.25,10,16]
["White",null,23,10,20,null,null,null,null,null,null,null,null,null,"White",null,23,10,20,null,null,null,null,null,null,"White",null,23,10,20,null,null,null,null,null,null,"White",null,23,10,20]
["Total",{"$f":"SUM(B7:B24)","v":40},{"$f":"SUM(C21:C24)","v":93},10,24,null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(P7:P24)","v":40},{"$f":"SUM(Q21:Q24)","v":93},10,24,null,null,null,null,null,null,"Total",{"$f":"SUM(AA7:AA24)","v":40},{"$f":"SUM(AB21:AB24)","v":93},10,24,null,null,null,null,null,null,"Total",{"$f":"SUM(AL7:AL24)","v":40},{"$f":"SUM(AM21:AM24)","v":93},10,24]
["Increment",{"$f":"B25/10","v":4},null,10,28,null,null,null,null,null,null,null,null,null,"Increment",{"$f":"P25/10","v":4},null,10,28,null,null,null,null,null,null,"Increment",{"$f":"AA25/10","v":4},null,10,28,null,null,null,null,null,null,"Increment",{"$f":"AL25/10","v":4},null,10,28]
["Conversion",{"$f":"100/B25","v":2.5},null,10,32,null,null,null,null,null,null,null,null,null,"Conversion",{"$f":"100/P25","v":2.5},null,10,32,null,null,null,null,null,null,"Conversion",{"$f":"100/AA25","v":2.5},null,10,32,null,null,null,null,null,null,"Conversion",{"$f":"100/AL25","v":2.5},null,10,32]
[null,null,null,10,36,null,null,null,null,null,null,null,null,null,null,null,null,10,36,null,null,null,null,null,null,null,null,null,10,36,null,null,null,null,null,null,null,null,null,10,36]
[null,null,null,10,40,null,null,null,null,null,null,null,null,null,null,null,null,10,40,null,null,null,null,null,null,null,null,null,10,40,null,null,null,null,null,null,null,null,null,10,40]
[null,null,null,33,{"$f":"F3","v":0},null,null,null,null,null,null,null,null,null,null,null,null,33,{"$f":"T3","v":0},null,null,null,null,null,null,null,null,null,33,{"$f":"AE3","v":0},null,null,null,null,null,null,null,null,null,33,{"$f":"AP3","v":0}]

{"sheet":"pAccel1","index":4,"n_rows":35,"n_cols":64,"rows_kept":35,"cut":false,"hidden":true,"merged":[]}
["Gauge Configuration",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gauge Configuration",null,null,null,null,null,null,"Gauge Configuration",null,null,null,null,null,null,"Gauge Configuration",null,null,null,null,null,null,"Gauge Configuration",null,null,null,null,null,null,"Gauge Configuration",null,null,null,null,null,null,"Gauge Configuration",null,null,null,null,null,null,"Gauge Configuration"]
[null,null,null,null,null,"Decal",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Decal",null,null,null,null,null,null,"Decal",null,null,null,null,null,null,"Decal",null,null,null,null,null,null,"Decal",null,null,null,null,null,null,"Decal",null,null,null,null,null,null,"Decal",null,null,null,null,null,null,"Decal"]
["Title:","CPDs",null,null,null,100,null,null,null,null,null,null,null,null,null,null,"Title:","Facturación",null,null,null,100,null,"Title:","CPDs",null,null,null,100,null,"Title:","Facturación",null,null,null,100,null,"Title:","Facturación",null,null,null,100,null,"Title:","Facturación",null,null,null,100,null,"Title:","Facturación",null,null,null,100,null,"Title:","Facturación",null,null,null,100]
["Real Value:",{"$f":"Dashboard!#REF!","v":{"$error":"#REF!"}},{"$f":"Dashboard!#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,"Real Value:",{"$f":"Dashboard!#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,"Real Value:",{"$f":"Dashboard!#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,"Real Value:",{"$f":"Dashboard!#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,"Real Value:",{"$f":"Dashboard!D8","v":-0.10099044114218647},null,null,null,null,null,"Real Value:",{"$f":"Dashboard!$G$8","v":"n.a."},null,null,null,null,null,"Real Value:",{"$f":"Dashboard!U31","v":3.8876603269866195E-4},null,null,null,null,null,"Real Value:",{"$f":"Dashboard!U30","v":{"$error":"#VALUE!"}}]
[]
["Color bands"]
["Red:",-50]
["Yellow:",0]
["Green:",50]
[]
["Advanced Parameters",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Advanced Parameters",null,null,null,null,null,null,"Advanced Parameters",null,null,null,null,null,null,"Advanced Parameters",null,null,null,null,null,null,"Advanced Parameters",null,null,null,null,null,null,"Advanced Parameters",null,null,null,null,null,null,"Advanced Parameters",null,null,null,null,null,null,"Advanced Parameters"]
[null,"Value to 100%",{"$f":"IF(ISERROR((B4-F3/100)*B27),0,(B4-F3/100)*B27)","v":0},null,{"$f":"IF(ISERROR((C4-F3/100)*B27),0,(C4-F3/100)*B27)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"Value to 100%",{"$f":"IF(ISERROR((R4-V3/100)*R27),0,(R4-V3/100)*R27)","v":0},null,null,null,null,null,"Value to 100%",{"$f":"IF(ISERROR((Y4-AC3/100)*Y27),0,(Y4-AC3/100)*Y27)","v":0},null,null,null,null,null,"Value to 100%",{"$f":"IF(ISERROR((AF4-AJ3/100)*AF27),0,(AF4-AJ3/100)*AF27)","v":0},null,null,null,null,null,"Value to 100%",{"$f":"IF(ISERROR((AM4-AQ3/100)*AM27),0,(AM4-AQ3/100)*AM27)","v":-2.2019808822843729},null,null,null,null,null,"Value to 100%",{"$f":"IF(ISERROR((AT4-AX3/100)*AT27),0,(AT4-AX3/100)*AT27)","v":0},null,null,null,null,null,"Value to 100%",{"$f":"IF(ISERROR((BA4-BE3/100)*BA27),0,(BA4-BE3/100)*BA27)","v":-1.9992224679346027},null,null,null,null,null,"Value to 100%",{"$f":"IF(ISERROR((BH4-BL3/100)*BH27),0,(BH4-BL3/100)*BH27)","v":0}]
[null,"Relative value",{"$f":"IF(B4<-100%,-100%,IF(B4>100%,100%,2*B4/1))","v":{"$error":"#REF!"}},"ojo1, todo en porcentaje, por 2, y con 1 al final en lugar de 100.",{"$f":"IF(C4<-100%,-100%,IF(C4>100%,100%,2*C4/1))","v":{"$error":"#REF!"}},null,null,null,"Todos los negritas tienen dato 50, en lugar de 100 para que la escala recorra menos. ",null,null,null,null,null,null,null,null,"Relative value",{"$f":"IF(R4<-100%,-100%,IF(R4>100%,100%,2*R4/1))","v":{"$error":"#REF!"}},null,null,null,null,null,"Relative value",{"$f":"IF(Y4<-100%,-100%,IF(Y4>100%,100%,2*Y4/1))","v":{"$error":"#REF!"}},null,null,null,null,null,"Relative value",{"$f":"IF(AF4<-100%,-100%,IF(AF4>100%,100%,2*AF4/1))","v":{"$error":"#REF!"}},null,null,null,null,null,"Relative value",{"$f":"IF(AM4<-100%,-100%,IF(AM4>100%,100%,2*AM4/1))","v":-0.20198088228437294},null,null,null,null,null,"Relative value",{"$f":"IF(AT4<-100%,-100%,IF(AT4>100%,100%,2*AT4/1))","v":1},null,null,null,null,null,"Relative value",{"$f":"IF(BA4<-100%,-100%,IF(BA4>100%,100%,2*BA4/1))","v":7.7753206539732389E-4},null,null,null,null,null,"Relative value",{"$f":"IF(BH4<-100%,-100%,IF(BH4>100%,100%,2*BH4/1))","v":{"$error":"#VALUE!"}}]
[]
["Angle",null,{"$f":"C13*PI()/2","v":{"$error":"#REF!"}},null,{"$f":"E13*PI()/2","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,"Angle",null,{"$f":"S13*PI()/2","v":{"$error":"#REF!"}},null,null,null,null,"Angle",null,{"$f":"Z13*PI()/2","v":{"$error":"#REF!"}},null,null,null,null,"Angle",null,{"$f":"AG13*PI()/2","v":{"$error":"#REF!"}},null,null,null,null,"Angle",null,{"$f":"AN13*PI()/2","v":-0.31727082797508543},null,null,null,null,"Angle",null,{"$f":"AU13*PI()/2","v":1.5707963267948966},null,null,null,null,"Angle",null,{"$f":"BB13*PI()/2","v":1.2213445122913657E-3},null,null,null,null,"Angle",null,{"$f":"BI13*PI()/2","v":{"$error":"#VALUE!"}}]
["x",0,{"$f":"SIN(C15)","v":{"$error":"#REF!"}},{"$f":"B16","v":0},{"$f":"SIN(E15)","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,"x",0,{"$f":"SIN(S15)","v":{"$error":"#REF!"}},null,null,null,null,"x",0,{"$f":"SIN(Z15)","v":{"$error":"#REF!"}},null,null,null,null,"x",0,{"$f":"SIN(AG15)","v":{"$error":"#REF!"}},null,null,null,null,"x",0,{"$f":"SIN(AN15)","v":-0.31197476557912024},null,null,null,null,"x",0,{"$f":"SIN(AU15)","v":1},null,null,null,null,"x",0,{"$f":"SIN(BB15)","v":1.2213442086483658E-3},null,null,null,null,"x",0,{"$f":"SIN(BI15)","v":{"$error":"#VALUE!"}}]
["y",0,{"$f":"-COS(C15)","v":{"$error":"#REF!"}},{"$f":"B17","v":0},{"$f":"-COS(E15)","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,"y",0,{"$f":"-COS(S15)","v":{"$error":"#REF!"}},null,null,null,null,"y",0,{"$f":"-COS(Z15)","v":{"$error":"#REF!"}},null,null,null,null,"y",0,{"$f":"-COS(AG15)","v":{"$error":"#REF!"}},null,null,null,null,"y",0,{"$f":"-COS(AN15)","v":-0.9500903881430719},null,null,null,null,"y",0,{"$f":"-COS(AU15)","v":-6.1257422745431001E-17},null,null,null,null,"y",0,{"$f":"-COS(BB15)","v":-0.99999925415888391},null,null,null,null,"y",0,{"$f":"-COS(BI15)","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,"Value","Label"]
[null,null,50,0,50]
[null,null,{"$f":"E21","v":40},{"$f":"D31/D33","v":5},{"$f":"E20+$B$26","v":40}]
[null,null,{"$f":"E22","v":30},{"$f":"D21","v":5},{"$f":"E21+$B$26","v":30}]
[null,null,20,{"$f":"D22","v":5},20]
["White",null,10,5,10,null,null,null,null,null,null,null,null,null,null,null,"White",null,null,null,null,null,null,"White",null,null,null,null,null,null,"White",null,null,null,null,null,null,"White",null,null,null,null,null,null,"White",null,null,null,null,null,null,"White",null,null,null,null,null,null,"White"]
["Total",50,0,5,0,null,null,null,null,null,null,null,null,null,null,null,"Total",50,null,null,null,null,null,"Total",50,null,null,null,null,null,"Total",50,null,null,null,null,null,"Total",50,null,null,null,null,null,"Total",50,null,null,null,null,null,"Total",50,null,null,null,null,null,"Total",50]
["Increment",-10,-10,5,-10,null,null,null,null,null,null,null,null,null,null,null,"Increment",-10,null,null,null,null,null,"Increment",-10,null,null,null,null,null,"Increment",-10,null,null,null,null,null,"Increment",-10,null,null,null,null,null,"Increment",-10,null,null,null,null,null,"Increment",-10,null,null,null,null,null,"Increment",-10]
["Conversion",{"$f":"100/B25","v":2},-20,5,-20,null,null,null,null,null,null,null,null,null,null,null,"Conversion",{"$f":"100/R25","v":2},null,null,null,null,null,"Conversion",{"$f":"100/Y25","v":2},null,null,null,null,null,"Conversion",{"$f":"100/AF25","v":2},null,null,null,null,null,"Conversion",{"$f":"100/AM25","v":2},null,null,null,null,null,"Conversion",{"$f":"100/AT25","v":2},null,null,null,null,null,"Conversion",{"$f":"100/BA25","v":2},null,null,null,null,null,"Conversion",{"$f":"100/BH25","v":2}]
[null,null,-30,5,-30]
[null,null,-40,5,-40]
[null,null,-50,5,-50]
[null,null,null,50]
[]
[null,null,null,10]
[]
[null,null,null,{"$f":"SUM(D20:D30)","v":50}]

{"sheet":"empresa_ccaa","index":5,"n_rows":185,"n_cols":13,"rows_kept":185,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Dashboard!M3","v":2020}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Dashboard!M4","v":"ABRIL"}]
[null,null,null,null,null,null,null,null,null,null,"Empresa",{"$f":"L9","v":"iEMPRESA"}]
[]
[]
[]
[null,null,"Facturación, €",null,null,"ASEMPLEO","ASEMPLEO",null,null,null,"Empresa = ","iEMPRESA"]
[null,null,"Dato acumulado a",null,{"$f":"M4","v":"ABRIL"},{"$f":"Dashboard!B7","v":2019},{"$f":"Dashboard!C7","v":2020},null,null,"Facturación",{"$f":"F10","v":2019},{"$f":"G10","v":2020}]
[null,null,null,null,null,null,null,"Estructura (%)",null,"Datos acumulados ",null,null,"Estructura (%)"]
[null,null,null,null,null,{"$f":"D167","v":1277637816.628484},{"$f":"A167","v":1148608609.9072335},{"$f":"G12/G$12","v":1},"TOTAL",null,{"$f":"SUM(K13:K29)","v":0},{"$f":"SUM(L13:L29)","v":0},{"$f":"L12/L$12","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,{"$f":"D168","v":104777541.1735598},{"$f":"A168","v":104818275.12255777},{"$f":"G13/G$12","v":9.1256738125115866E-2},"ANDALUCIA",null,null,null,{"$f":"L13/L$12","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,{"$f":"D169","v":63318988.808063805},{"$f":"A169","v":54091175.420959704},{"$f":"G14/G$12","v":4.7092782479950537E-2},"ARAGON",null,null,null,{"$f":"L14/L$12","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,{"$f":"D170","v":21408824.960594188},{"$f":"A170","v":19706909.201977435},1.7157201358232069E-2,"ASTURIAS",null,null,null,{"$f":"L15/L$12","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,{"$f":"D171","v":4492980.0373369809},{"$f":"A171","v":2926723.1656061881},2.5480595743075291E-3,"BALEARES",null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,{"$f":"D172","v":30756687.532573137},{"$f":"A172","v":23197317.166429266},2.019601539318322E-2,"CANARIAS",null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,{"$f":"D173","v":33989925.051196188},{"$f":"A173","v":31251849.513747938},2.7208440929475507E-2,"CANTABRIA",null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,{"$f":"D174","v":53369874.849731982},{"$f":"A174","v":56166562.200408727},4.8899652776366508E-2,"CASTILLA-LA MANCHA",null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,{"$f":"D175","v":78340915.965112209},{"$f":"A175","v":72292647.53796643},6.2939322336966544E-2,"CASTILLA Y LEÓN",null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,{"$f":"D176","v":311856946.9589687},{"$f":"A176","v":258136831.18729129},0.22473872210320583,"CATALUÑA",null,null,null,{"$f":"L21/L$12","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,{"$f":"D177","v":103495814.48706615},{"$f":"A177","v":90510714.073211238},7.8800309602869226E-2,"COMUNIDAD VALENCIANA",null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,{"$f":"D178","v":7732105.923550793},{"$f":"A178","v":8451228.5936064273},7.3577966599858453E-3,"EXTREMADURA",null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,{"$f":"D179","v":66806638.676306754},{"$f":"A179","v":66225111.637253664},5.7656812830788627E-2,"GALICIA",null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,{"$f":"D180","v":205693191.33717352},{"$f":"A180","v":186902675.00408626},0.1627209420092901,"MADRID",null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,{"$f":"D181","v":70809969.861232087},{"$f":"A181","v":77371479.263089582},6.7361047615112718E-2,"MURCIA",null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,{"$f":"D182","v":46749107.076008908},{"$f":"A182","v":38808347.381455652},3.3787268393008107E-2,"NAVARRA",null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,{"$f":"D183","v":62413140.050434485},{"$f":"A183","v":47537442.743480258},4.1386981025085284E-2,"PAIS VASCO",null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,{"$f":"D184","v":11625163.879574209},{"$f":"A184","v":10213320.694105927},8.8919067870567321E-3,"RIOJA (LA)",null,null,null,{"$error":"#DIV/0!"}]
[]
["Fuente: Cifras consolidadas del sector. ASEMPLEO ©."]
["Nota de Confidencialidad: Este informe comparativo se genera con los datos propios de la Empresa. "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["D03: "]
["MES:"]
[]
[]
[]
["TOTAL"]
["ANDALUCIA"]
["ARAGON"]
["ASTURIAS"]
["BALEARES"]
["CANARIAS"]
["CANTABRIA"]
["CASTILLA-LA MANCHA"]
["CASTILLA Y LEÓN"]
["CATALUÑA"]
["COMUNIDAD VALENCIANA"]
["EXTREMADURA"]
["GALICIA"]
["MADRID"]
["MURCIA"]
["NAVARRA"]
["PAIS VASCO"]
["RIOJA (LA)"]
["Ceuta y Melilla"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"D03: ",null,null,"D03 : ","Variación Interanual (%)"]
["ACUMULADO A LA FECHA",null,{"$f":"A61","v":"MES:"},{"$f":"A163","v":"ACUMULADO A LA FECHA"},null,{"$f":"C163","v":"MES:"},"Tasa % i.a."]
[]
["Facturación",null,null,"Facturación",null,null,"Facturación"]
[null,null,null,null,null,null,null,"check"]
[1148608609.9072335,null,"TOTAL",1277637816.628484,null,"TOTAL",-0.10099044114218647,{"$f":"A167/D167-1","v":-0.10099044114218647}]
[104818275.12255777,null,"ANDALUCIA",104777541.1735598,null,"ANDALUCIA",3.8876603269866195E-4,{"$f":"A168/D168-1","v":3.8876603269866195E-4}]
[54091175.420959704,null,"ARAGON",63318988.808063805,null,"ARAGON",-0.14573532459711236,-0.14573532459711236]
[19706909.201977435,null,"ASTURIAS",21408824.960594188,null,"ASTURIAS",-7.9495991104105768E-2,-7.9495991104105768E-2]
[2926723.1656061881,null,"BALEARES",4492980.0373369809,null,"BALEARES",-0.34860089711396169,-0.34860089711396169]
[23197317.166429266,null,"CANARIAS",30756687.532573137,null,"CANARIAS",-0.24577973028265976,-0.24577973028265976]
[31251849.513747938,null,"CANTABRIA",33989925.051196188,null,"CANTABRIA",-8.0555503824268904E-2,-8.0555503824268904E-2]
[56166562.200408727,null,"CASTILLA-LA MANCHA",53369874.849731982,null,"CASTILLA-LA MANCHA",5.2401984425691328E-2,5.2401984425691328E-2]
[72292647.53796643,null,"CASTILLA Y LEÓN",78340915.965112209,null,"CASTILLA Y LEÓN",-7.7204464010087293E-2,-7.7204464010087293E-2]
[258136831.18729129,null,"CATALUÑA",311856946.9589687,null,"CATALUÑA",-0.17225883949522991,-0.17225883949522991]
[90510714.073211238,null,"COMUNIDAD VALENCIANA",103495814.48706615,null,"COMUNIDAD VALENCIANA",-0.12546498115126825,-0.12546498115126825]
[8451228.5936064273,null,"EXTREMADURA",7732105.923550793,null,"EXTREMADURA",9.3004761854761808E-2,9.3004761854761808E-2]
[66225111.637253664,null,"GALICIA",66806638.676306754,null,"GALICIA",-8.7046295184931566E-3,-8.7046295184931566E-3]
[186902675.00408626,null,"MADRID",205693191.33717352,null,"MADRID",-9.1352155173117677E-2,-9.1352155173117677E-2]
[77371479.263089582,null,"MURCIA",70809969.861232087,null,"MURCIA",9.2663637828348744E-2,9.2663637828348744E-2]
[38808347.381455652,null,"NAVARRA",46749107.076008908,null,"NAVARRA",-0.16985906664789241,-0.16985906664789241]
[47537442.743480258,null,"PAIS VASCO",62413140.050434485,null,"PAIS VASCO",-0.23834239544643243,-0.23834239544643243]
[10213320.694105927,null,"RIOJA (LA)",11625163.879574209,null,"RIOJA (LA)",-0.12144716410827872,{"$f":"A184/D184-1","v":-0.12144716410827872}]
[null,null,"Ceuta y Melilla",null,null,"Ceuta y Melilla"]