{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Captura","Cuadro de indicadores","Configuracion","Estructura"],"not_rendered":{"charts":8,"macros":1,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Captura","index":0,"n_rows":11,"n_cols":9,"rows_kept":11,"merged":[[10,0,14,8]]}
["No.","Objetivo","Meta","Indicador","Valor pasado","Valor actual","Tendencia","Formato","Formateado"]
[1,null,null,"Indicador 1",null,null,{"$f":"IF(F2-E2 =0,\"Estático\",IF(F2-E2<0,\"Disminuye\",\"Aumenta\"))","v":"Estático"},"General",{"$f":"TEXT(F2,IF(H2=\"Moneda\",\"$ #,##0.00\",IF(H2=\"Porcentaje\",\"0#.##%\",IF(H2=\"General\",\"#,##0.00\"))))","v":"0.00"}]
[2,null,null,"Indicador 2",null,null,{"$f":"IF(F3-E3 =0,\"Estático\",IF(F3-E3<0,\"Disminuye\",\"Aumenta\"))","v":"Estático"},"General",{"$f":"TEXT(F3,IF(H3=\"Moneda\",\"$ #,##0.00\",IF(H3=\"Porcentaje\",\"0#.##%\",IF(H3=\"General\",\"#,##0.00\"))))","v":"0.00"}]
[3,null,null,"Indicador 3",null,null,"Estático","General","0.00"]
[4,null,null,"Indicador 4",null,null,"Estático","General","0.00"]
[5,null,null,"Indicador 5",null,null,"Estático","General","0.00"]
[6,null,null,"Indicador 6",null,null,"Estático","General","0.00"]
[7,null,null,"Indicador 7",null,null,"Estático","Porcentaje","0.%"]
[8,null,null,"Indicador 8",null,null,"Estático","Porcentaje","0.%"]
[]
["Coloque el objetivo, la meta y el nombre del indicador en cada renglón. Asimismo, coloque el valor pasado (del periodo anterior) y el valor acatual del indicador (si no hay valor pasado, dejar en blanco). Luego, indique el formato en el que el indicador deberá presentarse.\nNOTA: Sólo deben llenarse las celdas en color azul, lo demás se llena en automático\npara configuar el \"cuadro de indicadores\" referirse a la hoja \"configuración\""]

{"sheet":"Cuadro de indicadores","index":1,"n_rows":24,"n_cols":23,"rows_kept":24,"merged":[[9,1,9,4],[9,8,9,11],[9,15,9,18],[9,22,9,25],[10,1,10,4],[10,8,10,11],[10,15,10,18],[10,22,10,25],[21,1,21,4],[21,8,21,11],[21,15,21,18],[21,22,21,25],[22,8,22,11],[22,15,22,18],[22,22,22,25],[23,1,23,4],[23,8,23,11],[23,15,23,18],[23,22,23,25]]}
{"$rows_empty":9}
[null,{"$f":"Estructura!A1","v":"Indicador 1"},{"$nulls":6},{"$f":"Estructura!D1","v":"Indicador 2"},{"$nulls":6},{"$f":"Estructura!G1","v":"Indicador 3"},{"$nulls":6},{"$f":"Estructura!J1","v":"Indicador 4"}]
[null,{"$f":"IF(B10=\"\",\"\",Captura!G2)","v":"Estático"},{"$nulls":6},{"$f":"IF(I10=\"\",\"\",Captura!G3)","v":"Estático"},{"$nulls":6},{"$f":"IF(P10=\"\",\"\",Captura!G4)","v":"Estático"},{"$nulls":6},{"$f":"IF(W10=\"\",\"\",Captura!G5)","v":"Estático"}]
{"$rows_empty":10}
[null,{"$f":"Estructura!M1","v":"Indicador 5"},{"$nulls":6},{"$f":"Estructura!P1","v":"Indicador 6"},{"$nulls":6},{"$f":"Estructura!S1","v":"Indicador 7"},{"$nulls":6},{"$f":"Estructura!V1","v":"Indicador 8"}]
[]
[null,{"$f":"IF(B22=\"\",\"\",Captura!G6)","v":"Estático"},{"$nulls":6},{"$f":"IF(I22=\"\",\"\",Captura!G7)","v":"Estático"},{"$nulls":6},{"$f":"IF(P22=\"\",\"\",Captura!G8)","v":"Estático"},{"$nulls":6},{"$f":"IF(W22=\"\",\"\",Captura!G9)","v":"Estático"}]

{"sheet":"Configuracion","index":2,"n_rows":15,"n_cols":10,"rows_kept":15,"merged":[[0,2,0,9],[14,1,19,9]]}
[null,null,"Configuración del tablero de control"]
[null,"Nombre",{"$f":"+Captura!D2","v":"Indicador 1"},{"$f":"+Captura!D3","v":"Indicador 2"},{"$f":"+Captura!D4","v":"Indicador 3"},{"$f":"+Captura!D5","v":"Indicador 4"},{"$f":"+Captura!D6","v":"Indicador 5"},{"$f":"+Captura!D7","v":"Indicador 6"},{"$f":"+Captura!D8","v":"Indicador 7"},{"$f":"+Captura!D9","v":"Indicador 8"}]
[null,"Escala 0",0,0,0,0,10,10,{"v":0,"d":"0%"},{"v":1,"d":"100%"}]
[null,"Escala 1",{"$nulls":3},1,null,9,{"v":0.1,"d":"10%"}]
[null,"Escala 2",{"$nulls":3},2,null,8,{"v":0.2,"d":"20%"}]
[null,"Escala 3",300,1.5,3,3,7,7,{"v":0.3,"d":"30%"},{"v":0.7,"d":"70%"}]
[null,"Escala 4",{"$nulls":3},4,null,6,{"v":0.4,"d":"40%"}]
[null,"Escala 5",null,2.5,5,5,5,5,{"v":0.5,"d":"50%"},{"v":0.5,"d":"50%"}]
[null,"Escala 6",{"$nulls":3},6,null,4,{"v":0.6,"d":"60%"}]
[null,"Escala 7",500,3.5,7,7,3,3,{"v":0.7,"d":"70%"},{"v":0.3,"d":"30%"}]
[null,"Escala 8",{"$nulls":3},8,null,2,{"v":0.8,"d":"80%"}]
[null,"Escala 9",{"$nulls":3},9,null,1,{"v":0.9,"d":"90%"}]
[null,"Escala 10",770,5,10,10,0,0,{"v":1,"d":"100%"},{"v":0,"d":"0%"}]
[]
[null,"Modifique cada columna para configurar los indicadores visuales de la hoja \"cuadro de indicadores\" (no olvide dar clic en el botón de formato para que el tablero de indicadores tenga el formato adecuado). Decida qué escala desea, así como los valores de cada una de las escalas. Si usted borra el contenido de las celdas de una columna, ese indicador quedará en blanco.\nNOTA: Sólo modifique las celdas en color azul. Para aplicar el formato de la pantalla de captura dar clic en el botón <<Formato>> en la parte superior derecha"]

{"sheet":"Estructura","index":3,"n_rows":28,"n_cols":23,"rows_kept":28}
[{"$f":"IF(Configuracion!C2=\"\",\"\",Configuracion!C2)","v":"Indicador 1"},{"$f":"Captura!I2","v":"0.00"},null,{"$f":"IF(Configuracion!D2=\"\",\"\",Configuracion!D2)","v":"Indicador 2"},{"$f":"Captura!I3","v":"0.00"},null,{"$f":"IF(Configuracion!E2=\"\",\"\",Configuracion!E2)","v":"Indicador 3"},{"$f":"Captura!I4","v":"0.00"},null,{"$f":"IF(Configuracion!F2=\"\",\"\",Configuracion!F2)","v":"Indicador 4"},{"$f":"Captura!I5","v":"0.00"},null,{"$f":"IF(Configuracion!G2=\"\",\"\",Configuracion!G2)","v":"Indicador 5"},{"$f":"Captura!I6","v":"0.00"},null,{"$f":"IF(Configuracion!H2=\"\",\"\",Configuracion!H2)","v":"Indicador 6"},{"$f":"Captura!I7","v":"0.00"},null,{"$f":"IF(Configuracion!I2=\"\",\"\",Configuracion!I2)","v":"Indicador 7"},{"$f":"Captura!I8","v":"0.%"},null,{"$f":"IF(Configuracion!J2=\"\",\"\",Configuracion!J2)","v":"Indicador 8"},{"$f":"Captura!I9","v":"0.%"}]
[]
[{"$f":"IF(Configuracion!C3=\"\",\"\",Configuracion!C3)","v":0},0,null,{"$f":"IF(Configuracion!D3=\"\",\"\",Configuracion!D3)","v":0},0,null,{"$f":"IF(Configuracion!E3=\"\",\"\",Configuracion!E3)","v":0},0,null,{"$f":"IF(Configuracion!F3=\"\",\"\",Configuracion!F3)","v":0},0,null,{"$f":"IF(Configuracion!G3=\"\",\"\",Configuracion!G3)","v":10},0,null,{"$f":"IF(Configuracion!H3=\"\",\"\",Configuracion!H3)","v":10},0,null,{"$f":"IF(Configuracion!I3=\"\",\"\",Configuracion!I3)","v":{"v":0,"d":"0%"}},0,null,{"$f":"IF(Configuracion!J3=\"\",\"\",Configuracion!J3)","v":{"v":1,"d":"100%"}},0]
[null,1,null,null,1,null,null,1,null,null,1,null,null,1,null,null,1,null,null,1,null,null,1]
[{"$f":"IF(Configuracion!C4=\"\",\"\",Configuracion!C4)","v":""},0,null,{"$f":"IF(Configuracion!D4=\"\",\"\",Configuracion!D4)","v":""},0,null,{"$f":"IF(Configuracion!E4=\"\",\"\",Configuracion!E4)","v":""},0,null,{"$f":"IF(Configuracion!F4=\"\",\"\",Configuracion!F4)","v":1},0,null,{"$f":"IF(Configuracion!G4=\"\",\"\",Configuracion!G4)","v":""},0,null,{"$f":"IF(Configuracion!H4=\"\",\"\",Configuracion!H4)","v":9},0,null,{"$f":"IF(Configuracion!I4=\"\",\"\",Configuracion!I4)","v":{"v":0.1,"d":"10%"}},0,null,{"$f":"IF(Configuracion!J4=\"\",\"\",Configuracion!J4)","v":""},0]
[null,1,null,null,1,null,null,1,null,null,1,null,null,1,null,null,1,null,null,1,null,null,1]
[{"$f":"IF(Configuracion!C5=\"\",\"\",Configuracion!C5)","v":""},0,null,{"$f":"IF(Configuracion!D5=\"\",\"\",Configuracion!D5)","v":""},0,null,{"$f":"IF(Configuracion!E5=\"\",\"\",Configuracion!E5)","v":""},0,null,{"$f":"IF(Configuracion!F5=\"\",\"\",Configuracion!F5)","v":2},0,null,{"$f":"IF(Configuracion!G5=\"\",\"\",Configuracion!G5)","v":""},0,null,{"$f":"IF(Configuracion!H5=\"\",\"\",Configuracion!H5)","v":8},0,null,{"$f":"IF(Configuracion!I5=\"\",\"\",Configuracion!I5)","v":{"v":0.2,"d":"20%"}},0,null,{"$f":"IF(Configuracion!J5=\"\",\"\",Configuracion!J5)","v":""},0]
[null,1,null,null,1,null,null,1,null,null,1,null,null,1,null,null,1,null,null,1,null,null,1]
[{"$f":"IF(Configuracion!C6=\"\",\"\",Configuracion!C6)","v":300},0,null,{"$f":"IF(Configuracion!D6=\"\",\"\",Configuracion!D6)","v":1.5},0,null,{"$f":"IF(Configuracion!E6=\"\",\"\",Configuracion!E6)","v":3},0,null,{"$f":"IF(Configuracion!F6=\"\",\"\",Configuracion!F6)","v":3},0,null,{"$f":"IF(Configuracion!G6=\"\",\"\",Configuracion!G6)","v":7},0,null,{"$f":"IF(Configuracion!H6=\"\",\"\",Configuracion!H6)","v":7},0,null,{"$f":"IF(Configuracion!I6=\"\",\"\",Configuracion!I6)","v":{"v":0.3,"d":"30%"}},0,null,{"$f":"IF(Configuracion!J6=\"\",\"\",Configuracion!J6)","v":{"v":0.7,"d":"70%"}},0]
[null,1,null,null,1,null,null,1,null,null,1,null,null,1,null,null,1,null,null,1,null,null,1]
[{"$f":"IF(Configuracion!C7=\"\",\"\",Configuracion!C7)","v":""},0,null,{"$f":"IF(Configuracion!D7=\"\",\"\",Configuracion!D7)","v":""},0,null,{"$f":"IF(Configuracion!E7=\"\",\"\",Configuracion!E7)","v":""},0,null,{"$f":"IF(Configuracion!F7=\"\",\"\",Configuracion!F7)","v":4},0,null,{"$f":"IF(Configuracion!G7=\"\",\"\",Configuracion!G7)","v":""},0,null,{"$f":"IF(Configuracion!H7=\"\",\"\",Configuracion!H7)","v":6},0,null,{"$f":"IF(Configuracion!I7=\"\",\"\",Configuracion!I7)","v":{"v":0.4,"d":"40%"}},0,null,{"$f":"IF(Configuracion!J7=\"\",\"\",Configuracion!J7)","v":""},0]
[null,1,null,null,1,null,null,1,null,null,1,null,null,1,null,null,1,null,null,1,null,null,1]
[{"$f":"IF(Configuracion!C8=\"\",\"\",Configuracion!C8)","v":""},0,null,{"$f":"IF(Configuracion!D8=\"\",\"\",Configuracion!D8)","v":2.5},0,null,{"$f":"IF(Configuracion!E8=\"\",\"\",Configuracion!E8)","v":5},0,null,{"$f":"IF(Configuracion!F8=\"\",\"\",Configuracion!F8)","v":5},0,null,{"$f":"IF(Configuracion!G8=\"\",\"\",Configuracion!G8)","v":5},0,null,{"$f":"IF(Configuracion!H8=\"\",\"\",Configuracion!H8)","v":5},0,null,{"$f":"IF(Configuracion!I8=\"\",\"\",Configuracion!I8)","v":{"v":0.5,"d":"50%"}},0,null,{"$f":"IF(Configuracion!J8=\"\",\"\",Configuracion!J8)","v":{"v":0.5,"d":"50%"}},0]
[null,1,null,null,1,null,null,1,null,null,1,null,null,1,null,null,1,null,null,1,null,null,1]
[{"$f":"IF(Configuracion!C9=\"\",\"\",Configuracion!C9)","v":""},0,null,{"$f":"IF(Configuracion!D9=\"\",\"\",Configuracion!D9)","v":""},0,null,{"$f":"IF(Configuracion!E9=\"\",\"\",Configuracion!E9)","v":""},0,null,{"$f":"IF(Configuracion!F9=\"\",\"\",Configuracion!F9)","v":6},0,null,{"$f":"IF(Configuracion!G9=\"\",\"\",Configuracion!G9)","v":""},0,null,{"$f":"IF(Configuracion!H9=\"\",\"\",Configuracion!H9)","v":4},0,null,{"$f":"IF(Configuracion!I9=\"\",\"\",Configuracion!I9)","v":{"v":0.6,"d":"60%"}},0,null,{"$f":"IF(Configuracion!J9=\"\",\"\",Configuracion!J9)","v":""},0]
[null,1,null,null,1,null,null,1,null,null,1,null,null,1,null,null,1,null,null,1,null,null,1]
[{"$f":"IF(Configuracion!C10=\"\",\"\",Configuracion!C10)","v":500},0,null,{"$f":"IF(Configuracion!D10=\"\",\"\",Configuracion!D10)","v":3.5},0,null,{"$f":"IF(Configuracion!E10=\"\",\"\",Configuracion!E10)","v":7},0,null,{"$f":"IF(Configuracion!F10=\"\",\"\",Configuracion!F10)","v":7},0,null,{"$f":"IF(Configuracion!G10=\"\",\"\",Configuracion!G10)","v":3},0,null,{"$f":"IF(Configuracion!H10=\"\",\"\",Configuracion!H10)","v":3},0,null,{"$f":"IF(Configuracion!I10=\"\",\"\",Configuracion!I10)","v":{"v":0.7,"d":"70%"}},0,null,{"$f":"IF(Configuracion!J10=\"\",\"\",Configuracion!J10)","v":{"v":0.3,"d":"30%"}},0]
[null,1,null,null,1,null,null,1,null,null,1,null,null,1,null,null,1,null,null,1,null,null,1]
[{"$f":"IF(Configuracion!C11=\"\",\"\",Configuracion!C11)","v":""},0,null,{"$f":"IF(Configuracion!D11=\"\",\"\",Configuracion!D11)","v":""},0,null,{"$f":"IF(Configuracion!E11=\"\",\"\",Configuracion!E11)","v":""},0,null,{"$f":"IF(Configuracion!F11=\"\",\"\",Configuracion!F11)","v":8},0,null,{"$f":"IF(Configuracion!G11=\"\",\"\",Configuracion!G11)","v":""},0,null,{"$f":"IF(Configuracion!H11=\"\",\"\",Configuracion!H11)","v":2},0,null,{"$f":"IF(Configuracion!I11=\"\",\"\",Configuracion!I11)","v":{"v":0.8,"d":"80%"}},0,null,{"$f":"IF(Configuracion!J11=\"\",\"\",Configuracion!J11)","v":""},0]
[null,1,null,null,1,null,null,1,null,null,1,null,null,1,null,null,1,null,null,1,null,null,1]
[{"$f":"IF(Configuracion!C12=\"\",\"\",Configuracion!C12)","v":""},0,null,{"$f":"IF(Configuracion!D12=\"\",\"\",Configuracion!D12)","v":""},0,null,{"$f":"IF(Configuracion!E12=\"\",\"\",Configuracion!E12)","v":""},0,null,{"$f":"IF(Configuracion!F12=\"\",\"\",Configuracion!F12)","v":9},0,null,{"$f":"IF(Configuracion!G12=\"\",\"\",Configuracion!G12)","v":""},0,null,{"$f":"IF(Configuracion!H12=\"\",\"\",Configuracion!H12)","v":1},0,null,{"$f":"IF(Configuracion!I12=\"\",\"\",Configuracion!I12)","v":{"v":0.9,"d":"90%"}},0,null,{"$f":"IF(Configuracion!J12=\"\",\"\",Configuracion!J12)","v":""},0]
[null,1,null,null,1,null,null,1,null,null,1,null,null,1,null,null,1,null,null,1,null,null,1]
[{"$f":"IF(Configuracion!C13=\"\",\"\",Configuracion!C13)","v":770},0,null,{"$f":"IF(Configuracion!D13=\"\",\"\",Configuracion!D13)","v":5},0,null,{"$f":"IF(Configuracion!E13=\"\",\"\",Configuracion!E13)","v":10},0,null,{"$f":"IF(Configuracion!F13=\"\",\"\",Configuracion!F13)","v":10},0,null,{"$f":"IF(Configuracion!G13=\"\",\"\",Configuracion!G13)","v":0},0,null,{"$f":"IF(Configuracion!H13=\"\",\"\",Configuracion!H13)","v":0},0,null,{"$f":"IF(Configuracion!I13=\"\",\"\",Configuracion!I13)","v":{"v":1,"d":"100%"}},0,null,{"$f":"IF(Configuracion!J13=\"\",\"\",Configuracion!J13)","v":{"v":0,"d":"0%"}},0]
[null,{"$f":"SUM(B3:B23)","v":10},null,null,{"$f":"SUM(E3:E23)","v":10},null,null,{"$f":"SUM(H3:H23)","v":10},null,null,{"$f":"SUM(K3:K23)","v":10},null,null,{"$f":"SUM(N3:N23)","v":10},null,null,{"$f":"SUM(Q3:Q23)","v":10},null,null,{"$f":"SUM(T3:T23)","v":10},null,null,{"$f":"SUM(W3:W23)","v":10}]
["x","y",null,"x","y",null,"x","y",null,"x","y",null,"x","y",null,"x","y",null,"x","y",null,"x","y"]
[0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0]
[{"$f":"COS(B28)","v":{"v":-1,"d":"-1.00"}},{"$f":"SIN(B28)","v":{"v":-3.215743643592006e-16,"d":"-0.00"}},null,{"$f":"COS(E28)","v":{"v":-1,"d":"-1.00"}},{"$f":"SIN(E28)","v":{"v":1.22514845490862E-16,"d":"0.00"}},null,{"$f":"COS(H28)","v":{"v":-1,"d":"-1.00"}},{"$f":"SIN(H28)","v":{"v":1.22514845490862E-16,"d":"0.00"}},null,{"$f":"COS(K28)","v":{"v":-1,"d":"-1.00"}},{"$f":"SIN(K28)","v":{"v":1.22514845490862E-16,"d":"0.00"}},null,{"$f":"COS(N28)","v":{"v":-1,"d":"-1.00"}},{"$f":"SIN(N28)","v":{"v":1.22514845490862E-16,"d":"0.00"}},null,{"$f":"COS(Q28)","v":{"v":-1,"d":"-1.00"}},{"$f":"SIN(Q28)","v":{"v":1.22514845490862E-16,"d":"0.00"}},null,{"$f":"COS(T28)","v":{"v":-1,"d":"-1.00"}},{"$f":"SIN(T28)","v":{"v":1.22514845490862E-16,"d":"0.00"}},null,{"$f":"COS(W28)","v":{"v":-1,"d":"-1.00"}},{"$f":"SIN(W28)","v":{"v":1.22514845490862E-16,"d":"0.00"}}]
["Longitud",{"$f":"(MAX(A3:A24)-B1)*PI()/(MAX(A3:A24)-MIN(A3:A24))","v":3.1415926535897936},null,"Longitud",{"$f":"(MAX(D3:D24)-E1)*PI()/(MAX(D3:D24)-MIN(D3:D24))","v":3.141592653589793},null,"Longitud",{"$f":"(MAX(G3:G24)-H1)*PI()/(MAX(G3:G24)-MIN(G3:G24))","v":3.141592653589793},null,"Longitud",{"$f":"(MAX(J3:J24)-K1)*PI()/(MAX(J3:J24)-MIN(J3:J24))","v":3.141592653589793},null,"Longitud",{"$f":"(MAX(M3:M24)-N1)*PI()/(MAX(M3:M24)-MIN(M3:M24))","v":3.141592653589793},null,"Longitud",{"$f":"(MAX(P3:P24)-Q1)*PI()/(MAX(P3:P24)-MIN(P3:P24))","v":3.141592653589793},null,"Longitud",{"$f":"(MAX(S3:S24)-T1)*PI()/(MAX(S3:S24)-MIN(S3:S24))","v":3.141592653589793},null,"Longitud",{"$f":"(MAX(V3:V24)-W1)*PI()/(MAX(V3:V24)-MIN(V3:V24))","v":3.141592653589793}]