{"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":38,"rows_kept":49,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2017]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SEPTIEMBRE",null,null,null,null,null,null,null,null,null,null,null,null,"Empresa - Sector","Empresa - Sector"]
[null,null,null,null,null,"Acumulado a:",{"$f":"R4","v":"SEPTIEMBRE"},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,null,null,null,null,null,null,null,null,"p.p."]
[null,null,null,null,null,"Total","Facturación, €",null,"(a)",{"$f":"O5","v":"iEMPRESA"},null,null,null,"Cuota de Facturación","∆",null,"(b)","∆ (a-b)",null,null,null,null,null,null,null,null,null,null,null,null,null,"Puntos porcentuales"]
[null,null,null,null,null,null,2016,2017,"% i.a.",2016,2017,"% i.a.",2016,2017,"Dif.P.P.",null,"% i.a.","Dif.P.P.",null,null,null,null,null,null,null,null,null,null,null,null,"Dif. Ritmo","Importancia Relativa",null,null,"Empresa"]
[null,null,null,null,null,"Nacional",{"$f":"empresa_ccaa!F12","v":2256241251.3194637},{"$f":"empresa_ccaa!G12","v":2593768217.5713682},{"$f":"((H8/G8)-1)","v":0.14959701940318504},{"$f":"empresa_ccaa!K12","v":0},{"$f":"empresa_ccaa!L12","v":0},{"$f":"IF(J8>0,((K8/J8)-1),\"n.a.\")","v":"n.a."},{"$f":"J8/G8","v":0},{"$f":"K8/H8","v":0},{"$f":"(N8-M8)*100","v":0},null,{"$f":"((H8-K8)/(G8-J8))-1","v":0.14959701940318504},{"$f":"(I8-Q8)*100","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L8=\"n.a.\",\"n.a.\",(L8-I8)*100)","v":"n.a."},{"$f":"empresa_ccaa!M12-empresa_ccaa!H12","v":{"$error":"#DIV/0!"}},null,"criterio_rank","peso","Comunidad","% i.a.","Total_Regional"]
[null,null,null,null,null,"ANDALUCIA",{"$f":"empresa_ccaa!F13","v":216353427.86420116},{"$f":"empresa_ccaa!G13","v":241175607.53944868},{"$f":"((H9/G9)-1)","v":0.11472977303982312},{"$f":"empresa_ccaa!K13","v":0},{"$f":"empresa_ccaa!L13","v":0},"n.a.",0,0,{"$f":"(N9-M9)*100","v":0},null,{"$f":"((H9-K9)/(G9-J9))-1","v":0.11472977303982312},0,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L9=\"n.a.\",\"n.a.\",(L9-I9)*100)","v":"n.a."},{"$f":"empresa_ccaa!M13-empresa_ccaa!H13","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(AI9=$AI$27,1,0)","v":1},{"$f":"N9","v":0},{"$f":"F9","v":"ANDALUCIA"},{"$f":"L9","v":"n.a."},{"$f":"I9","v":0.11472977303982312}]
[null,null,null,null,null,"ARAGON",{"$f":"empresa_ccaa!F14","v":119152154.57894002},{"$f":"empresa_ccaa!G14","v":148547988.51427644},{"$f":"((H10/G10)-1)","v":0.24670837081557995},{"$f":"empresa_ccaa!K14","v":0},{"$f":"empresa_ccaa!L14","v":0},"n.a.",0,0,0,null,0.24670837081557995,0,null,null,null,null,null,null,null,null,null,null,null,null,"n.a.",{"$f":"empresa_ccaa!M14-empresa_ccaa!H14","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(AI10=$AI$27,1,0)","v":1},0,"ARAGON",{"$f":"L10","v":"n.a."},{"$f":"I10","v":0.24670837081557995}]
[null,null,null,null,null,"ASTURIAS",{"$f":"empresa_ccaa!F15","v":38578525.031756938},{"$f":"empresa_ccaa!G15","v":52864850.237925068},0.37031807707547038,{"$f":"empresa_ccaa!K15","v":0},{"$f":"empresa_ccaa!L15","v":0},"n.a.",0,0,0,null,0.37031807707547038,0,null,null,null,null,null,null,null,null,null,null,null,null,"n.a.",{"$f":"empresa_ccaa!M15-empresa_ccaa!H15","v":{"$error":"#DIV/0!"}},null,1,0,"ASTURIAS","n.a.",0.37031807707547038]
[null,null,null,null,null,"BALEARES",{"$f":"empresa_ccaa!F16","v":10528008.801441783},{"$f":"empresa_ccaa!G16","v":13881532.758823618},0.31853354424652247,{"$f":"empresa_ccaa!K16","v":0},{"$f":"empresa_ccaa!L16","v":0},"n.a.",0,0,0,null,0.31853354424652247,0,null,null,null,null,null,null,null,null,null,null,null,null,"n.a.",{"$f":"empresa_ccaa!M16-empresa_ccaa!H16","v":{"$error":"#DIV/0!"}},null,1,0,"BALEARES","n.a.",0.31853354424652247]
[null,null,null,null,null,"CANARIAS",{"$f":"empresa_ccaa!F17","v":44896069.235174},{"$f":"empresa_ccaa!G17","v":54099670.297050044},0.20499792562386387,{"$f":"empresa_ccaa!K17","v":0},{"$f":"empresa_ccaa!L17","v":0},"n.a.",0,0,0,null,0.20499792562386387,0,null,null,null,null,null,null,null,null,null,null,null,null,"n.a.",{"$f":"empresa_ccaa!M17-empresa_ccaa!H17","v":{"$error":"#DIV/0!"}},null,1,0,"CANARIAS","n.a.",0.20499792562386387]
[null,null,null,null,null,"CANTABRIA",{"$f":"empresa_ccaa!F18","v":47208652.628320612},{"$f":"empresa_ccaa!G18","v":60997846.480792314},0.29209039201003417,{"$f":"empresa_ccaa!K18","v":0},{"$f":"empresa_ccaa!L18","v":0},"n.a.",0,0,0,null,0.29209039201003417,0,null,null,null,null,null,null,null,null,null,null,null,null,"n.a.",{"$f":"empresa_ccaa!M18-empresa_ccaa!H18","v":{"$error":"#DIV/0!"}},null,1,0,"CANTABRIA","n.a.",0.29209039201003417]
[null,null,null,null,null,"CASTILLA-LA MANCHA",{"$f":"empresa_ccaa!F19","v":99639961.104905561},{"$f":"empresa_ccaa!G19","v":111973205.19131178},0.12377809013214303,{"$f":"empresa_ccaa!K19","v":0},{"$f":"empresa_ccaa!L19","v":0},"n.a.",0,0,0,null,0.12377809013214303,0,null,null,null,null,null,null,null,null,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.",0.12377809013214303]
[null,null,null,null,null,"CASTILLA Y LEÓN",{"$f":"empresa_ccaa!F20","v":160992166.95391658},{"$f":"empresa_ccaa!G20","v":178791167.31926408},0.11055817622755781,{"$f":"empresa_ccaa!K20","v":0},{"$f":"empresa_ccaa!L20","v":0},"n.a.",0,0,{"$f":"(N16-M16)*100","v":0},null,0.11055817622755781,0,null,null,null,null,null,null,null,null,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.",0.11055817622755781]
[null,null,null,null,null,"CATALUÑA",{"$f":"empresa_ccaa!F21","v":550367259.66599548},{"$f":"empresa_ccaa!G21","v":627201091.90219927},0.13960465650306375,{"$f":"empresa_ccaa!K21","v":0},{"$f":"empresa_ccaa!L21","v":0},"n.a.",0,0,{"$f":"(N17-M17)*100","v":0},null,0.13960465650306375,0,null,null,null,null,null,null,null,null,null,null,null,null,"n.a.",{"$f":"empresa_ccaa!M21-empresa_ccaa!H21","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(AI17=$AI$27,1,0)","v":1},{"$f":"N17","v":0},"CATALUÑA","n.a.",0.13960465650306375]
[null,null,null,null,null,"COMUNIDAD VALENCIANA",{"$f":"empresa_ccaa!F22","v":168578229.6680122},{"$f":"empresa_ccaa!G22","v":195202939.66208464},0.15793682284186716,{"$f":"empresa_ccaa!K22","v":0},{"$f":"empresa_ccaa!L22","v":0},"n.a.",0,0,{"$f":"(N18-M18)*100","v":0},null,0.15793682284186716,0,null,null,null,null,null,null,null,null,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.15793682284186716]
[null,null,null,null,null,"EXTREMADURA",{"$f":"empresa_ccaa!F23","v":13488846.241774984},{"$f":"empresa_ccaa!G23","v":16410434.451514825},0.2165928914432782,{"$f":"empresa_ccaa!K23","v":0},{"$f":"empresa_ccaa!L23","v":0},"n.a.",0,0,0,null,0.2165928914432782,0,null,null,null,null,null,null,null,null,null,null,null,null,"n.a.",{"$f":"empresa_ccaa!M23-empresa_ccaa!H23","v":{"$error":"#DIV/0!"}},null,1,0,"EXTREMADURA","n.a.",0.2165928914432782]
[null,null,null,null,null,"GALICIA",{"$f":"empresa_ccaa!F24","v":121313207.83959073},{"$f":"empresa_ccaa!G24","v":136393532.28269175},0.12430900733448036,{"$f":"empresa_ccaa!K24","v":0},{"$f":"empresa_ccaa!L24","v":0},"n.a.",0,0,0,null,0.12430900733448036,0,null,null,null,null,null,null,null,null,null,null,null,null,"n.a.",{"$f":"empresa_ccaa!M24-empresa_ccaa!H24","v":{"$error":"#DIV/0!"}},null,1,0,"GALICIA","n.a.",0.12430900733448036]
[null,null,null,null,null,"MADRID",{"$f":"empresa_ccaa!F25","v":376383464.55367911},{"$f":"empresa_ccaa!G25","v":411402568.6660645},9.3041027065074555E-2,{"$f":"empresa_ccaa!K25","v":0},{"$f":"empresa_ccaa!L25","v":0},"n.a.",0,0,0,null,9.3041027065074555E-2,0,null,null,null,null,null,null,null,null,null,null,null,null,"n.a.",{"$f":"empresa_ccaa!M25-empresa_ccaa!H25","v":{"$error":"#DIV/0!"}},null,1,0,"MADRID","n.a.",9.3041027065074555E-2]
[null,null,null,null,null,"MURCIA",{"$f":"empresa_ccaa!F26","v":76597298.436606035},{"$f":"empresa_ccaa!G26","v":98610449.607117638},0.28738808835053464,{"$f":"empresa_ccaa!K26","v":0},{"$f":"empresa_ccaa!L26","v":0},"n.a.",0,0,0,null,0.28738808835053464,0,null,null,null,null,null,null,null,null,null,null,null,null,"n.a.",{"$f":"empresa_ccaa!M26-empresa_ccaa!H26","v":{"$error":"#DIV/0!"}},null,1,0,"MURCIA","n.a.",0.28738808835053464]
[null,null,null,null,null,"NAVARRA",{"$f":"empresa_ccaa!F27","v":71133278.272880584},{"$f":"empresa_ccaa!G27","v":85812377.109829456},0.20636049952087254,{"$f":"empresa_ccaa!K27","v":0},{"$f":"empresa_ccaa!L27","v":0},"n.a.",0,0,0,null,0.20636049952087254,0,null,null,null,null,null,null,null,null,null,null,null,null,"n.a.",{"$f":"empresa_ccaa!M27-empresa_ccaa!H27","v":{"$error":"#DIV/0!"}},null,1,0,"NAVARRA","n.a.",0.20636049952087254]
[null,null,null,null,null,"PAIS VASCO",{"$f":"empresa_ccaa!F28","v":120174154.11368929},{"$f":"empresa_ccaa!G28","v":136666704.96413156},0.13723875131119878,{"$f":"empresa_ccaa!K28","v":0},{"$f":"empresa_ccaa!L28","v":0},"n.a.",0,0,0,null,0.13723875131119878,0,null,null,null,null,null,null,null,null,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.13723875131119878]
[null,null,null,null,null,"RIOJA (LA)",{"$f":"empresa_ccaa!F29","v":20856546.328578606},{"$f":"empresa_ccaa!G29","v":23736250.586843248},0.13807196133516775,{"$f":"empresa_ccaa!K29","v":0},{"$f":"empresa_ccaa!L29","v":0},"n.a.",0,0,0,null,0.13807196133516775,0,null,null,null,null,null,null,null,null,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.13807196133516775]
[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,"codifico=1","máximo"]
[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":"DMAX(AH8:AJ25,AI8,AH8:AH25)*1","v":0},{"$f":"MAX(AI9:AI25)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"N6","v":"Cuota de Facturación"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"geo data",{"$f":"VLOOKUP(1,AH8:AL25,3,0)","v":"ANDALUCIA"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"N7","v":2017},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"el dato a buscar debe estar en la primera columna. "]
[null,null,null,null,null,null,"% i.a.",null,null,null,"% i.a.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(1,AH8:AL25,4,0)*1","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,2017,null,null,null,2017,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(1,AH8:AL25,5,0)*1","v":0.11472977303982312}]
[null,null,null,null,null,null,"Total",null,null,null,"Empresa",null,null,null,{"$f":"O5","v":"iEMPRESA"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ámbito"]
[null,null,null,null,null,"Ámbito",{"$f":"K34","v":"Nacional"},null,null,null,{"$f":"O34","v":"Nacional"},null,null,null,"Nacional",null,null,"Nacional"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AH28","v":"ANDALUCIA"},null,null,"CCAA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Líder para la"]
[null,null,null,null,null,null,"% i.a.",null,null,null,"% i.a.",null,null,null,null,null,null,"Empresa"]
[null,null,null,null,null,null,2017,null,null,null,2017]
[null,null,null,null,null,null,"Total",null,null,null,"Empresa",null,null,null,{"$f":"O32","v":"iEMPRESA"}]
[]
[null,null,null,null,null,"Ámbito",{"$f":"K44","v":"ANDALUCIA"},null,null,null,{"$f":"O44","v":"ANDALUCIA"},null,null,null,{"$f":"O38","v":"ANDALUCIA"}]
[]
[]
[]
[null,null,null,null,null,"Fuente: Cifras consolidadas del sector. Valores absolutos 2015-2017 y cifras de evolución de 2016 a la fecha. ASEMPLEO ©."]
[null,null,null,null,null,"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!N8","v":0},null,null,null,null,null,null,null,null,null,"Real Value:",{"$f":"Dashboard!N8","v":0},null,null,null,null,null,null,null,null,null,"Real Value:",{"$f":"Dashboard!AH27","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!I8","v":0.14959701940318504},null,null,null,null,null,"Real Value:",{"$f":"Dashboard!$L$8","v":"n.a."},null,null,null,null,null,"Real Value:",{"$f":"Dashboard!AH31","v":0.11472977303982312},null,null,null,null,null,"Real Value:",{"$f":"Dashboard!AH30","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":-1.7008059611936299},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.7705404539203538},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.29919403880637008},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":0.22945954607964625},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.46997289715597584},null,null,null,null,"Angle",null,{"$f":"AU13*PI()/2","v":1.5707963267948966},null,null,null,null,"Angle",null,{"$f":"BB13*PI()/2","v":0.36043421212993265},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.45286212117648239},null,null,null,null,"x",0,{"$f":"SIN(AU15)","v":1},null,null,null,null,"x",0,{"$f":"SIN(BB15)","v":0.35268057780660456},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.89158056237422367},null,null,null,null,"y",0,{"$f":"-COS(AU15)","v":-6.1257422745431001E-17},null,null,null,null,"y",0,{"$f":"-COS(BB15)","v":-0.9357437737105172},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":83,"n_cols":14,"rows_kept":83,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Dashboard!R3","v":2017}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Dashboard!R4","v":"SEPTIEMBRE"}]
[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":"SEPTIEMBRE"},2016,2017,null,null,"Facturación",2016,2017]
[null,null,null,null,null,null,null,"Estructura (%)",null,"Datos acumulados ",null,null,"Estructura (%)","check"]
[null,null,null,null,null,{"$f":"E65","v":2256241251.3194637},{"$f":"B65","v":2593768217.5713682},{"$f":"G12/G$12","v":1},"TOTAL",null,null,null,{"$f":"L12/L$12","v":{"$error":"#DIV/0!"}},{"$f":"L12/K12-1","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,216353427.86420116,{"$f":"B66","v":241175607.53944868},{"$f":"G13/G$12","v":9.2982713684906459E-2},"ANDALUCIA",null,null,null,{"$f":"L13/L$12","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,119152154.57894002,148547988.51427644,{"$f":"G14/G$12","v":5.7271111392276558E-2},"ARAGON",null,null,null,{"$f":"L14/L$12","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,38578525.031756938,52864850.237925068,2.0381485855133268E-2,"ASTURIAS",null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,10528008.801441783,{"$f":"B69","v":13881532.758823618},5.3518786546861777E-3,"BALEARES",null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,44896069.235174,54099670.297050044,2.0857557714893032E-2,"CANARIAS",null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,47208652.628320612,60997846.480792314,2.3517076841163023E-2,"CANTABRIA",null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,99639961.104905561,111973205.19131178,4.3170089151665231E-2,"CASTILLA-LA MANCHA",null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,160992166.95391658,178791167.31926408,6.8931050241132275E-2,"CASTILLA Y LEÓN",null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,550367259.66599548,627201091.90219927,0.24181077077483376,"CATALUÑA",null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,168578229.6680122,195202939.66208464,7.5258436100685847E-2,"COMUNIDAD VALENCIANA",null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,13488846.241774984,16410434.451514825,6.3268700496609768E-3,"EXTREMADURA",null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,121313207.83959073,136393532.28269175,5.2585088890634013E-2,"GALICIA",null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,376383464.55367911,411402568.6660645,0.15861192448848588,"MADRID",null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,76597298.436606035,98610449.607117638,3.8018219569152516E-2,"MURCIA",null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,71133278.272880584,85812377.109829456,3.3084057599479126E-2,"NAVARRA",null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,120174154.11368929,136666704.96413156,5.2690407738937121E-2,"PAIS VASCO",null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,20856546.328578606,23736250.586843248,9.1512612522749986E-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: ",null,null,"D03: ",null,null,"D03 : ","Variación Interanual (%)"]
["MES:AGOSTO","ACUMULADO A LA FECHA",null,{"$f":"A61","v":"MES:AGOSTO"},{"$f":"B61","v":"ACUMULADO A LA FECHA"},null,{"$f":"D61","v":"MES:AGOSTO"},"2017/2016"]
[]
[null,"Facturación",null,null,"Facturación",null,null,"Facturación"]
[null,null,null,null,null,null,null,null,"check"]
["TOTAL",2593768217.5713682,null,"TOTAL",2256241251.3194637,null,"TOTAL",0.14959701940318504,{"$f":"B65/E65-1","v":0.14959701940318504}]
["ANDALUCIA",241175607.53944868,null,"ANDALUCIA",216353427.86420116,null,"ANDALUCIA",0.11472977303982312,{"$f":"B66/E66-1","v":0.11472977303982312}]
["ARAGON",148547988.51427644,null,"ARAGON",119152154.57894002,null,"ARAGON",0.24670837081557995,0.24670837081557995]
["ASTURIAS",52864850.237925068,null,"ASTURIAS",38578525.031756938,null,"ASTURIAS",0.37031807707547038,0.37031807707547038]
["BALEARES",13881532.758823618,null,"BALEARES",10528008.801441783,null,"BALEARES",0.31853354424652247,0.31853354424652247]
["CANARIAS",54099670.297050044,null,"CANARIAS",44896069.235174,null,"CANARIAS",0.20499792562386387,0.20499792562386387]
["CANTABRIA",60997846.480792314,null,"CANTABRIA",47208652.628320612,null,"CANTABRIA",0.29209039201003417,0.29209039201003417]
["CASTILLA-LA MANCHA",111973205.19131178,null,"CASTILLA-LA MANCHA",99639961.104905561,null,"CASTILLA-LA MANCHA",0.12377809013214303,0.12377809013214303]
["CASTILLA Y LEÓN",178791167.31926408,null,"CASTILLA Y LEÓN",160992166.95391658,null,"CASTILLA Y LEÓN",0.11055817622755781,0.11055817622755781]
["CATALUÑA",627201091.90219927,null,"CATALUÑA",550367259.66599548,null,"CATALUÑA",0.13960465650306375,0.13960465650306375]
["COMUNIDAD VALENCIANA",195202939.66208464,null,"COMUNIDAD VALENCIANA",168578229.6680122,null,"COMUNIDAD VALENCIANA",0.15793682284186716,0.15793682284186716]
["EXTREMADURA",16410434.451514825,null,"EXTREMADURA",13488846.241774984,null,"EXTREMADURA",0.2165928914432782,0.2165928914432782]
["GALICIA",136393532.28269175,null,"GALICIA",121313207.83959073,null,"GALICIA",0.12430900733448036,0.12430900733448036]
["MADRID",411402568.6660645,null,"MADRID",376383464.55367911,null,"MADRID",9.3041027065074555E-2,9.3041027065074555E-2]
["MURCIA",98610449.607117638,null,"MURCIA",76597298.436606035,null,"MURCIA",0.28738808835053464,0.28738808835053464]
["NAVARRA",85812377.109829456,null,"NAVARRA",71133278.272880584,null,"NAVARRA",0.20636049952087254,0.20636049952087254]
["PAIS VASCO",136666704.96413156,null,"PAIS VASCO",120174154.11368929,null,"PAIS VASCO",0.13723875131119878,0.13723875131119878]
["RIOJA (LA)",23736250.586843248,null,"RIOJA (LA)",20856546.328578606,null,"RIOJA (LA)",0.13807196133516775,0.13807196133516775]
["Ceuta y Melilla",0,null,"Ceuta y Melilla",0,null,"Ceuta y Melilla",0]