{"id":26872,"date":"2017-11-17T20:37:49","date_gmt":"2017-11-18T02:37:49","guid":{"rendered":"https:\/\/aplicaexcelcontable.com\/blog\/?p=26872"},"modified":"2024-12-18T13:54:31","modified_gmt":"2024-12-18T19:54:31","slug":"barra-de-estado-en-excel","status":"publish","type":"post","link":"https:\/\/aplicaexcelcontable.com\/blog\/barra-de-estado-en-excel.html","title":{"rendered":"Barra de estado en Excel"},"content":{"rendered":"<h1 style=\"text-align: center;\">Como crear una barra de estado en Excel para tu Proyecto<\/h1>\n<p style=\"\">Te gustar\u00eda aprender los pasos de como crear barra de estado en excel para cada etapa de tus proyectos?<\/p>\n<p><span><img decoding=\"async\" loading=\"lazy\" alt=\"Ejemplo de Barra de Estado en excel\" title=\"6457d27114ad6b9ea9d6b485fb20bf88.gif\" src=\"\/\/i.pinimg.com\/originals\/64\/57\/d2\/6457d27114ad6b9ea9d6b485fb20bf88.gif\" width=\"584\"><\/span><\/p>\n<p style=\"\">Hola soy Roger Perez y en este articulo voy a compartirte un tips de excel para crear Barra de Estado o bien barras de progreso para cada etapa de proyecto.<\/p>\n<p style=\"\">Y antes de ver los pasos, quiero compartirles que me inspire en escribir este articulo, gracias a un visita al blog desde mexico, que me hizo la siguiente pregunta desde el chat:<\/p>\n<blockquote style=\"\"><p>Queria ver si es posible una idea en excel, es posible una condicional que si escribo un texto, se pongan de color \u00abx\u00bb cantidad de celdas.<\/p><\/blockquote>\n<p>Tratando de compartirme una idea de lo que quiere automatizar, me compartio la siguiente imagen:<\/p>\n<p><span><img decoding=\"async\" loading=\"lazy\" alt=\"Barra de Estado en Excel\" title=\"6646118a9c99c11efbabeab02e7b7837.png\" src=\"\/\/i.pinimg.com\/originals\/66\/46\/11\/6646118a9c99c11efbabeab02e7b7837.png\" width=\"430\" data-width=\"430\" data-height=\"199\" data-init-width=\"430\" height=\"199\"><\/span><\/p>\n<p style=\"\">No puedo mencionar su nombre, ya que no lo compartio, pero despu\u00e9s de explicarme todo su proyecto, considero que sera de mucha ayuda este peque\u00f1o truco para tus proyectos.<\/p>\n<p style=\"\">En la siguiente imagen te dejo un ejemplo de la automatizaci\u00f3n que el visitante queria lograr:<\/p>\n<p><span><img decoding=\"async\" loading=\"lazy\" alt=\"Ejemplo de Barra de Estado en excel\" title=\"6457d27114ad6b9ea9d6b485fb20bf88.gif\" src=\"\/\/i.pinimg.com\/originals\/64\/57\/d2\/6457d27114ad6b9ea9d6b485fb20bf88.gif\" width=\"584\" data-width=\"584\" data-height=\"212\" data-init-width=\"584\" height=\"212\"><\/span><\/p>\n<p style=\"\">Est\u00e1s listo para aprender a crear Barra de estado en Excel?<\/p>\n<p style=\"\">Comencemos:<\/p>\n<h2 style=\"text-align: center;\">Pasos para crear Barra de Estado en Excel<\/h2>\n<p style=\"\">Como primer paso, te invito a que descargues el archivo de practica, pulsa clic en el enlace:<\/p>\n<p><a href=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2017\/11\/Ejemplo-barra-de-estado-en-Excel.xlsx\" target=\"_blank\"><\/a><\/p>\n<p style=\"text-align: center;\"><a href=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2017\/11\/Ejemplo-barra-de-estado-en-Excel.xlsx\" target=\"_blank\" style=\"outline: none;\"><em><strong>Haz clic para descargar el archivo excel<\/strong><\/em><\/a><\/p>\n<p style=\"\">Pulsa clic en el enlace o bien en la imagen de excel para descargar el archivo de practica.<\/p>\n<p style=\"\">Ya lo descargaste?<\/p>\n<p style=\"\">Muy bien, ahora, tan solo abre el archivo y veamos el segundo paso:<\/p>\n<p style=\"\">Para poder explicarte los pasos de como crear gr\u00e1ficos de barra de estado, hemos creado dos hojas: PLAN y PARAMETROS.<\/p>\n<p style=\"\">En la Columna estado, le hemos agregado Validacion Dinamica, para ver como hacer una <a href=\"https:\/\/aplicaexcelcontable.com\/blog\/validacion-dinamica-en-excel.html\" target=\"_blank\" style=\"outline: none;\">validacion dinamica<\/a>, visita el siguiente enlace:<\/p>\n<p style=\"text-align: justify;\"><span style=\"color: rgb(4, 0, 0);\">Ahora, en la columna valor hemos agregado una formula que llamara automaticamente el valor del parametro una vez se seleccione el estado. <\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"color: rgb(4, 0, 0);\">Para ver como crear formulas con la funcion SI y buscarV, visita el siguiente enlace:<\/span><\/p>\n<p style=\"text-align: justify;\"><a href=\"https:\/\/aplicaexcelcontable.com\/blog\/como-aplicar-la-formula-excel-buscarv.html\" style=\"outline: none;\" target=\"_blank\"><span><strong>Haz clic aqui para ver como aplicar la funcion BuscarV =&gt;<\/strong><\/span><\/a><\/p>\n<p style=\"text-align: justify;\"><span style=\"color: rgb(4, 0, 0);\">Y para crear la barra de estado de cada etapa de proyecto, tan solo sigamos los siguientes pasos:<\/span><\/p>\n<ul>\n<li>  <span><span style=\"color: rgb(6, 1, 1);\">En la celda I7 escribe la siguiente formula: <strong>=SI(H7=35;\u00bb35&#8243;;SI(H7=50;\u00bb50&#8243;;SI(H7=75;\u00bb75&#8243;;SI(H7=100;\u00bb100&#8243;;\u00bb\u00bb))))<\/strong><\/span><\/span><\/li>\n<li>  <span style=\"\">\n<p>Ahora en la Celda J7 escribe la siguiente formula: <strong>=SI(H7=50;\u00bb50&#8243;;SI(H7=75;\u00bb75&#8243;;SI(H7=100;\u00bb100&#8243;;\u00bb\u00bb)))<\/strong><\/p>\n<p><\/span><\/li>\n<li>  <span>\n<p>Por lo tanto, en la celda K7 escribe la siguiente formula:<strong>=SI(H7=75;\u00bb75&#8243;;SI(H7=100;\u00bb100&#8243;;\u00bb\u00bb))<\/strong><\/p>\n<p><\/span><\/li>\n<li>  <span>\n<p>Y en la celda L7 escribe la siguiente formula: <strong>=SI(H7=100;\u00bb100&#8243;;\u00bb\u00bb)<\/strong><\/p>\n<p><\/span><\/li>\n<li>  <span style=\"\">\n<p>Ahora, seleccionamos de la I7 a la L13 y rellenamos las f\u00f3rmulas hacia abajo.<\/p>\n<p><\/span><\/li>\n<\/ul>\n<p>Muy bien, ahora, solo nos falta crear los formatos condicionales para crear la barra de estado.<\/p>\n<h2 style=\"text-align: center;\">Creando Formato Condicional para barra de estado<\/h2>\n<ul>\n<li style=\"\">Como primer paso seleccionamos de la I7 a la L13, en este caso ya lo tengo seleccionado.<\/li>\n<li style=\"\">Ahora, vamos a crear cuatro reglas de formato Condicional.<\/li>\n<li style=\"\">Por lo tanto, nos ubicamos en formato condiconal y pulsamos clic en Nueva regla.<\/li>\n<li style=\"\">Dentro de este seleccionamos \u201cAplicar formato \u00fanicamente a las celdas que contengan\u201d.<\/li>\n<li style=\"\">Ahora, vamos a editar la descripcion de la regla, en la primer lista desplegable, seleccionamos: Valor de la Celda.<\/li>\n<li style=\"\">En la siguiente lista desplegable seleccionamos \u201cIgual a\u201d y en el cuadro de texto escribimos: =\u201d35\u201d.<\/li>\n<li style=\"\">En seguida pulsamos clic en formato, y en la seccion fuente, le aplicamos el color de fuente verde y en la seccion relleno, le aplicamos el color de relleno verde.<\/li>\n<\/ul>\n<h2 style=\"text-align: center;\"><span style=\"color: rgb(9, 30, 245);\">Continuamos con mas Formato Condicional<\/span><\/h2>\n<p style=\"\">Tan solo aceptamos y nuevamente aceptar.<\/p>\n<p style=\"\">Ahora, vamos a seguir los mismos pasos para crear la segunda regla de formato condicional.<\/p>\n<p style=\"\">En este caso solo cambiara el valor en el cuadro de texto por 50 y el color de formato para la fuente y relleno en amarrillo.<\/p>\n<p style=\"\">Listo, ahora continuamos con la tercera regla condicional, para eso repetimos los pasos anteriores.<\/p>\n<p style=\"\">En este caso solo cambiara el valor en el cuadro de texto por 75 y el color de formato para la fuente y relleno en anaranjado.<\/p>\n<p style=\"\">y el ultimo formato condicional con valor de 100 y el formato para la fuente y relleno en color Azul.<\/p>\n<p style=\"\">Ahora, si nos vamos al adminitrador de reglas, puedes notar que hemo creado 4 formato condianal, tal a como se muestra en la imagen:<\/p>\n<p><span><img decoding=\"async\" loading=\"lazy\" alt=\"Formato Condicional Barra de Estados\" title=\"e076c39721a7055b34953824f569ed6f.png\" src=\"\/\/i.pinimg.com\/originals\/e0\/76\/c3\/e076c39721a7055b34953824f569ed6f.png\" width=\"623\"><\/span><\/p>\n<p style=\"\">Ahora estamos listo para crear la barra de estado para cada etapa, puedes hacer la prueba, seleccionando el estado y veras como cambiara autom\u00e1ticamente el gr\u00e1fico.<\/p>\n<p style=\"\">Puedes ver la imagen al comienzo de este articulo.<\/p>\n<p style=\"\">Que tal te parecio este articulo? te gusto?<\/p>\n<p style=\"\">Si te gusto, compartelo con tus amigos de <a href=\"https:\/\/www.facebook.com\/AplicaExceContable\/\" target=\"_blank\" rel=\"noopener\">facebook<\/a> pulsando clic en el boton compartir:<\/p>\n<p style=\"\">No olvides visitar nuestra pagina de facebook, <a href=\"https:\/\/www.facebook.com\/AplicaExceContable\/\" target=\"_blank\" style=\"outline: none;\" rel=\"noopener\">pulsando clic aqui<\/a>.<\/p>\n<p style=\"\">Tambien puedes contactarme por whatsapp o correo electronico, para eso <a href=\"https:\/\/aplicaexcelcontable.com\/blog\/contacto\" target=\"_blank\" style=\"outline: none;\">visita el siguiente enlace<\/a>.<\/p>\n<p style=\"\">Saludos,<\/p>\n<p style=\"\"><strong>Roger Perez &#8211; Aplica Excel Contable<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Como crear una barra de estado en Excel para tu Proyecto Te gustar\u00eda aprender los pasos de como crear barra de estado en excel para cada etapa de tus proyectos? Hola soy Roger Perez y en este articulo voy a compartirte un tips de excel para crear Barra de Estado o bien barras de progreso [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":48971,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","tve_updated_post":"<div class=\"thrv_wrapper thrv_text_element\" style=\"\"><h1 data-css=\"tve-u-15fcb048774\" class=\"\" style=\"text-align: center;\">Como crear una barra de estado en Excel para tu Proyecto<\/h1><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-18da833f800\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-18da833f7f8\"><div class=\"thrv_wrapper thrv_text_element\">\t<p style=\"\">Te gustar\u00eda aprender los pasos de como crear barra de estado en excel para cada etapa de tus proyectos?<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper tve_image_caption\" data-css=\"tve-u-18da834b221\" style=\"\"><span class=\"tve_image_frame\"><img decoding=\"async\" loading=\"lazy\" class=\"tve_image\" alt=\"Ejemplo de Barra de Estado en excel\" title=\"6457d27114ad6b9ea9d6b485fb20bf88.gif\" src=\"\/\/i.pinimg.com\/originals\/64\/57\/d2\/6457d27114ad6b9ea9d6b485fb20bf88.gif\" width=\"584\"><\/span><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-18da833f800\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-18da833f7f8\"><div class=\"thrv_wrapper thrv_text_element\"><p style=\"\">Hola soy Roger Perez y en este articulo voy a compartirte un tips de excel para crear Barra de Estado o bien barras de progreso para cada etapa de proyecto.<\/p><p style=\"\">Y antes de ver los pasos, quiero compartirles que me inspire en escribir este articulo, gracias a un visita al blog desde mexico, que me hizo la siguiente pregunta desde el chat:<\/p><blockquote class=\"\" style=\"\">Queria ver si es posible una idea en excel, es posible una condicional que si escribo un texto, se pongan de color \"x\" cantidad de celdas.<\/blockquote><p>Tratando de compartirme una idea de lo que quiere automatizar, me compartio la siguiente imagen:<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper tve_image_caption\" data-css=\"tve-u-15fcb22e119\" style=\"\"><span class=\"tve_image_frame\"><img decoding=\"async\" loading=\"lazy\" class=\"tve_image\" alt=\"Barra de Estado en Excel\" title=\"6646118a9c99c11efbabeab02e7b7837.png\" src=\"\/\/i.pinimg.com\/originals\/66\/46\/11\/6646118a9c99c11efbabeab02e7b7837.png\" width=\"430\" data-width=\"430\" data-height=\"199\" data-init-width=\"430\" height=\"199\"><\/span><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-18da83a4c50\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-18da83a4c47\"><div class=\"thrv_wrapper thrv_text_element\">\t<p style=\"\">No puedo mencionar su nombre, ya que no lo compartio, pero despu\u00e9s de explicarme todo su proyecto, considero que sera de mucha ayuda este peque\u00f1o truco para tus proyectos.<\/p><p style=\"\">En la siguiente imagen te dejo un ejemplo de la automatizaci\u00f3n que el visitante queria lograr:<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper tve_image_caption\" data-css=\"tve-u-15fcbe8dcb1\" style=\"\"><span class=\"tve_image_frame\"><img decoding=\"async\" loading=\"lazy\" class=\"tve_image\" alt=\"Ejemplo de Barra de Estado en excel\" title=\"6457d27114ad6b9ea9d6b485fb20bf88.gif\" src=\"\/\/i.pinimg.com\/originals\/64\/57\/d2\/6457d27114ad6b9ea9d6b485fb20bf88.gif\" width=\"584\" data-width=\"584\" data-height=\"212\" data-init-width=\"584\" height=\"212\"><\/span><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-18da83bae2c\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-18da83bae26\"><div class=\"thrv_wrapper thrv_text_element\">\t<p style=\"\">Est\u00e1s listo para aprender a crear Barra de estado en Excel?<\/p><p style=\"\">Comencemos:<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_text_element\"><h2 style=\"text-align: center;\" data-css=\"tve-u-18da83f655c\" class=\"\">Pasos para crear Barra de Estado en Excel<\/h2><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-18da83bae2c\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-18da83bae26\"><div class=\"thrv_wrapper thrv_text_element\">\t<p style=\"\">Como primer paso, te invito a que descargues el archivo de practica, pulsa clic en el enlace:<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-18da84eb12d\" style=\"\" id=\"descarga\">\n\t<div class=\"tve-content-box-background\" style=\"\" data-css=\"tve-u-18da84eb12e\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-18da84eb12a\"><div class=\"thrv_wrapper thrv-columns\" data-css=\"tve-u-18da84eb12b\" style=\"--tcb-col-el-width: 645.938;\"><div class=\"tcb-flex-row v-2 tcb-resized tcb--cols--2\"><div class=\"tcb-flex-col\" data-css=\"tve-u-18da84eb127\" style=\"\"><div class=\"tcb-col\"><a href=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2017\/11\/Ejemplo-barra-de-estado-en-Excel.xlsx\" target=\"_blank\"><div class=\"thrv_wrapper thrv_icon tcb-icon-display tcb-local-vars-root\" data-css=\"tve-u-18da84eb126\" style=\"\" data-link-wrap=\"true\"><svg class=\"tcb-icon tcb-local-vars-root\" viewBox=\"0 0 384 512\" data-id=\"icon-file-excel-solid\" data-name=\"\" style=\"\"><path d=\"M224 136V0H24C10.7 0 0 10.7 0 24v464c0 13.3 10.7 24 24 24h336c13.3 0 24-10.7 24-24V160H248c-13.2 0-24-10.8-24-24zm60.1 106.5L224 336l60.1 93.5c5.1 8-.6 18.5-10.1 18.5h-34.9c-4.4 0-8.5-2.4-10.6-6.3C208.9 405.5 192 373 192 373c-6.4 14.8-10 20-36.6 68.8-2.1 3.9-6.1 6.3-10.5 6.3H110c-9.5 0-15.2-10.5-10.1-18.5l60.3-93.5-60.3-93.5c-5.2-8 .6-18.5 10.1-18.5h34.8c4.4 0 8.5 2.4 10.6 6.3 26.1 48.8 20 33.6 36.6 68.5 0 0 6.1-11.7 36.6-68.5 2.1-3.9 6.2-6.3 10.6-6.3H274c9.5-.1 15.2 10.4 10.1 18.4zM384 121.9v6.1H256V0h6.1c6.4 0 12.5 2.5 17 7l97.9 98c4.5 4.5 7 10.6 7 16.9z\"><\/path><\/svg><\/div><\/a><\/div><\/div><div class=\"tcb-flex-col\" data-css=\"tve-u-18da84eb128\" style=\"\"><div class=\"tcb-col\"><div class=\"thrv_wrapper thrv_text_element\"><p style=\"text-align: center;\" data-css=\"tve-u-18da84eb129\"><a href=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2017\/11\/Ejemplo-barra-de-estado-en-Excel.xlsx\" target=\"_blank\" class=\"\" style=\"outline: none;\"><em><strong>Haz clic para descargar el archivo excel<\/strong><\/em><\/a><\/p><\/div><div class=\"thrv_wrapper thrv_text_element\">\t<p style=\"\">Pulsa clic en el enlace o bien en la imagen de excel para descargar el archivo de practica.<\/p><\/div><div class=\"thrv_wrapper thrv_icon tcb-icon-display tcb-local-vars-root tve_evt_manager_listen tve_et_tve-viewport tve_ea_thrive_animation tve_anim_slide_right tve-viewport-triggered\" data-css=\"tve-u-18da84eb12f\" style=\"\" data-tcb-events=\"__TCB_EVENT_[{&quot;t&quot;:&quot;tve-viewport&quot;,&quot;config&quot;:{&quot;anim&quot;:&quot;slide_right&quot;,&quot;loop&quot;:1},&quot;a&quot;:&quot;thrive_animation&quot;}]_TNEVE_BCT__\"><svg class=\"tcb-icon\" viewBox=\"0 0 384 512\" data-id=\"icon-hand-point-up-solid\" data-name=\"\" style=\"\"><path d=\"M135.652 0c23.625 0 43.826 20.65 43.826 44.8v99.851c17.048-16.34 49.766-18.346 70.944 6.299 22.829-14.288 53.017-2.147 62.315 16.45C361.878 158.426 384 189.346 384 240c0 2.746-.203 13.276-.195 16 .168 61.971-31.065 76.894-38.315 123.731C343.683 391.404 333.599 400 321.786 400H150.261l-.001-.002c-18.366-.011-35.889-10.607-43.845-28.464C93.421 342.648 57.377 276.122 29.092 264 10.897 256.203.008 242.616 0 224c-.014-34.222 35.098-57.752 66.908-44.119 8.359 3.583 16.67 8.312 24.918 14.153V44.8c0-23.45 20.543-44.8 43.826-44.8zM136 416h192c13.255 0 24 10.745 24 24v48c0 13.255-10.745 24-24 24H136c-13.255 0-24-10.745-24-24v-48c0-13.255 10.745-24 24-24zm168 28c-11.046 0-20 8.954-20 20s8.954 20 20 20 20-8.954 20-20-8.954-20-20-20z\"><\/path><\/svg><\/div><\/div><\/div><\/div><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-18da8504d4e\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-18da8504d40\"><div class=\"thrv_wrapper thrv_text_element\">\t<p style=\"\">Ya lo descargaste?<\/p><\/div><\/div>\n<\/div><div class=\"thrv_responsive_video thrv_wrapper tcb-lazy-load tcb-lazy-load-youtube\" data-type=\"youtube\" data-rel=\"0\" data-modestbranding=\"1\" data-aspect-ratio=\"16:9\" data-aspect-ratio-default=\"0\" data-float-position=\"top-left\" data-float-width-d=\"300px\" data-float-padding1-d=\"25px\" data-float-padding2-d=\"25px\" data-float-visibility=\"mobile\" data-url=\"https:\/\/youtu.be\/soa5rtU3CGw\" data-css=\"tve-u-1874f18a31a\" style=\"\" id=\"video\">\n\t\n\n\t<div class=\"tve_responsive_video_container\" style=\"padding-bottom: 56.25%;\">\n\t\t<div class=\"video_overlay\"><\/div>\n\t<iframe title=\"Responsive Video\" class=\"tcb-responsive-video\" data-code=\"soa5rtU3CGw\" data-hash=\"undefined\" data-provider=\"youtube\" frameborder=\"0\" allowfullscreen=\"\" loading=\"lazy\" data-src=\"https:\/\/www.youtube.com\/embed\/soa5rtU3CGw?rel=0&amp;modestbranding=1&amp;controls=1&amp;showinfo=1&amp;fs=1&amp;wmode=transparent&amp;enablejsapi=1\"><\/iframe><\/div>\n<\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-18da8679ed2\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-18da8679ecc\"><div class=\"thrv_wrapper thrv_text_element\">\t<p style=\"\">Muy bien, ahora, tan solo abre el archivo y veamos el segundo paso:<\/p><p style=\"\">Para poder explicarte los pasos de como crear gr\u00e1ficos de barra de estado, hemos creado dos hojas: PLAN y PARAMETROS.<\/p><p style=\"\">En la Columna estado, le hemos agregado Validacion Dinamica, para ver como hacer una <a href=\"https:\/\/aplicaexcelcontable.com\/blog\/validacion-dinamica-en-excel.html\" target=\"_blank\" class=\"\" style=\"outline: none;\">validacion dinamica<\/a>, visita el siguiente enlace:<\/p><\/div><div class=\"thrv_wrapper thrv-button thrv-button-v2 tcb-local-vars-root\" data-css=\"tve-u-18da8693e8f\" style=\"\">\n\t<div class=\"thrive-colors-palette-config\" style=\"display: none !important\">__CONFIG_colors_palette__{\"active_palette\":0,\"config\":{\"colors\":{\"62516\":{\"name\":\"Main Accent\",\"parent\":-1}},\"gradients\":[]},\"palettes\":[{\"name\":\"Default Palette\",\"value\":{\"colors\":{\"62516\":{\"val\":\"rgb(233, 246, 16)\"}},\"gradients\":[]}}]}__CONFIG_colors_palette__<\/div>\n\t<a href=\"https:\/\/aplicaexcelcontable.com\/blog\/validacion-dinamica-en-excel.html\" class=\"tcb-button-link tcb-plain-text\" target=\"_blank\">\n\t\t<span class=\"tcb-button-texts\"><span class=\"tcb-button-text thrv-inline-text\" style=\"\" data-css=\"tve-u-18da869ff59\">Clic aqui para aprender a aplicar Validacion dinamica &gt;&gt;<\/span><\/span>\n\t<\/a>\n<\/div><div class=\"thrv_wrapper thrv_text_element\"><p style=\"text-align: justify;\"><span data-css=\"tve-u-15fcbfb0bc3\" style=\"color: rgb(4, 0, 0);\">Ahora, en la columna valor hemos agregado una formula que llamara automaticamente el valor del parametro una vez se seleccione el estado. <\/span><\/p><p style=\"text-align: justify;\"><span data-css=\"tve-u-15fcbfb0bc3\" style=\"color: rgb(4, 0, 0);\">Para ver como crear formulas con la funcion SI y buscarV, visita el siguiente enlace:<\/span><\/p><p style=\"text-align: justify;\"><a data-css=\"tve-u-15fcceb1cb6\" href=\"https:\/\/aplicaexcelcontable.com\/blog\/como-aplicar-la-formula-excel-buscarv.html\" class=\"\" style=\"outline: none;\" target=\"_blank\"><span data-css=\"tve-u-15fcceb1cef\"><strong>Haz clic aqui para ver como aplicar la funcion BuscarV =&gt;<\/strong><\/span><\/a><\/p><p style=\"text-align: justify;\"><span data-css=\"tve-u-15fcbfb0be4\" style=\"color: rgb(4, 0, 0);\">Y para crear la barra de estado de cada etapa de proyecto, tan solo sigamos los siguientes pasos:<\/span><\/p><\/div><div class=\"thrv_wrapper thrv-styled_list\" data-icon-code=\"icon-check\" style=\"\" data-css=\"tve-u-15fccc96e41\"><ul class=\"tcb-styled-list\"><li class=\"thrv-styled-list-item\" data-css=\"tve-u-18da86d2eed\"><div class=\"tcb-styled-list-icon\"><div class=\"thrv_wrapper thrv_icon tve_no_drag tcb-no-delete tcb-no-clone tcb-icon-inherit-style\" style=\"\" data-css=\"tve-u-15fcc12bdfc\"><svg class=\"tcb-icon\" viewBox=\"0 0 32 32\" data-name=\"checkcheck\"> <path d=\"M29.333 10.267c0 0.4-0.133 0.8-0.533 1.2l-14.8 14.8c-0.267 0.267-0.667 0.4-1.067 0.4s-0.933-0.133-1.2-0.533l-2.4-2.267-6.267-6.267c-0.267-0.267-0.4-0.667-0.4-1.2s0.133-0.8 0.533-1.2l2.4-2.4c0.267-0.133 0.667-0.4 1.067-0.4s0.8 0.133 1.2 0.533l5.067 5.067 11.2-11.333c0.267-0.267 0.667-0.533 1.2-0.533 0.4 0 0.8 0.133 1.2 0.533l2.4 2.4c0.267 0.267 0.4 0.667 0.4 1.2z\"><\/path> <\/svg><\/div><\/div><span class=\"thrv-advanced-inline-text tve_editable tcb-styled-list-icon-text tcb-no-delete\" data-css=\"tve-u-18da86c3250\"><meta charset=\"utf-8\"><span style=\"color: rgb(6, 1, 1);\" data-css=\"tve-u-15fcc2ba61a\">En la celda I7 escribe la siguiente formula: <strong>=SI(H7=35;\"35\";SI(H7=50;\"50\";SI(H7=75;\"75\";SI(H7=100;\"100\";\"\"))))<\/strong><\/span><\/span><\/li><li class=\"thrv-styled-list-item\" data-css=\"tve-u-18da86d2eed\"><div class=\"tcb-styled-list-icon\"><div class=\"thrv_wrapper thrv_icon tve_no_drag tcb-no-delete tcb-no-clone tcb-icon-inherit-style\" style=\"\" data-css=\"tve-u-15fcc2c0dfd\"><svg class=\"tcb-icon\" viewBox=\"0 0 32 32\" data-name=\"checkcheck\"> <path d=\"M29.333 10.267c0 0.4-0.133 0.8-0.533 1.2l-14.8 14.8c-0.267 0.267-0.667 0.4-1.067 0.4s-0.933-0.133-1.2-0.533l-2.4-2.267-6.267-6.267c-0.267-0.267-0.4-0.667-0.4-1.2s0.133-0.8 0.533-1.2l2.4-2.4c0.267-0.133 0.667-0.4 1.067-0.4s0.8 0.133 1.2 0.533l5.067 5.067 11.2-11.333c0.267-0.267 0.667-0.533 1.2-0.533 0.4 0 0.8 0.133 1.2 0.533l2.4 2.4c0.267 0.267 0.4 0.667 0.4 1.2z\"><\/path> <\/svg><\/div><\/div><span class=\"thrv-advanced-inline-text tve_editable tcb-styled-list-icon-text tcb-no-delete tve_empty_dropzone\" style=\"\" data-css=\"tve-u-18da86c3250\"><meta charset=\"utf-8\"><div class=\"thrv_wrapper thrv_text_element tve_empty_dropzone\"><p data-css=\"tve-u-15fcc2d0428\">Ahora en la Celda J7 escribe la siguiente formula: <strong>=SI(H7=50;\"50\";SI(H7=75;\"75\";SI(H7=100;\"100\";\"\")))<\/strong><\/p><\/div><\/span><\/li><li class=\"thrv-styled-list-item\" data-css=\"tve-u-18da86d2eed\"><div class=\"tcb-styled-list-icon\"><div class=\"thrv_wrapper thrv_icon tve_no_drag tcb-no-delete tcb-no-clone tcb-icon-inherit-style\" style=\"\" data-css=\"tve-u-15fcc2c3027\"><svg class=\"tcb-icon\" viewBox=\"0 0 32 32\" data-name=\"checkcheck\"> <path d=\"M29.333 10.267c0 0.4-0.133 0.8-0.533 1.2l-14.8 14.8c-0.267 0.267-0.667 0.4-1.067 0.4s-0.933-0.133-1.2-0.533l-2.4-2.267-6.267-6.267c-0.267-0.267-0.4-0.667-0.4-1.2s0.133-0.8 0.533-1.2l2.4-2.4c0.267-0.133 0.667-0.4 1.067-0.4s0.8 0.133 1.2 0.533l5.067 5.067 11.2-11.333c0.267-0.267 0.667-0.533 1.2-0.533 0.4 0 0.8 0.133 1.2 0.533l2.4 2.4c0.267 0.267 0.4 0.667 0.4 1.2z\"><\/path> <\/svg><\/div><\/div><span class=\"thrv-advanced-inline-text tve_editable tcb-styled-list-icon-text tcb-no-delete tve_empty_dropzone\" data-css=\"tve-u-18da86c3250\"><meta charset=\"utf-8\"><div class=\"thrv_wrapper thrv_text_element tve_empty_dropzone\"><p data-css=\"tve-u-15fcc2e58c8\">Por lo tanto, en la celda K7 escribe la siguiente formula:<strong>=SI(H7=75;\"75\";SI(H7=100;\"100\";\"\"))<\/strong><\/p><\/div><\/span><\/li><li class=\"thrv-styled-list-item\" data-css=\"tve-u-18da86d2eed\"><div class=\"tcb-styled-list-icon\"><div class=\"thrv_wrapper thrv_icon tve_no_drag tcb-no-delete tcb-no-clone tcb-icon-inherit-style\" data-css=\"tve-u-15fcc2fcfc4\" style=\"\"><svg class=\"tcb-icon\" viewBox=\"0 0 32 32\" data-name=\"checkcheck\"> <path d=\"M29.333 10.267c0 0.4-0.133 0.8-0.533 1.2l-14.8 14.8c-0.267 0.267-0.667 0.4-1.067 0.4s-0.933-0.133-1.2-0.533l-2.4-2.267-6.267-6.267c-0.267-0.267-0.4-0.667-0.4-1.2s0.133-0.8 0.533-1.2l2.4-2.4c0.267-0.133 0.667-0.4 1.067-0.4s0.8 0.133 1.2 0.533l5.067 5.067 11.2-11.333c0.267-0.267 0.667-0.533 1.2-0.533 0.4 0 0.8 0.133 1.2 0.533l2.4 2.4c0.267 0.267 0.4 0.667 0.4 1.2z\"><\/path> <\/svg><\/div><\/div><span class=\"thrv-advanced-inline-text tve_editable tcb-styled-list-icon-text tcb-no-delete tve_empty_dropzone\" data-css=\"tve-u-18da86c3250\"><meta charset=\"utf-8\"><div class=\"thrv_wrapper thrv_text_element tve_empty_dropzone\"><p data-css=\"tve-u-15fcc30b15c\">Y en la celda L7 escribe la siguiente formula: <strong>=SI(H7=100;\"100\";\"\")<\/strong><\/p><\/div><\/span><\/li><li class=\"thrv-styled-list-item\" data-css=\"tve-u-18da86d2eed\"><div class=\"tcb-styled-list-icon\"><div class=\"thrv_wrapper thrv_icon tve_no_drag tcb-no-delete tcb-no-clone tcb-icon-inherit-style\" data-css=\"tve-u-15fcc33a5e7\" style=\"\"><svg class=\"tcb-icon\" viewBox=\"0 0 32 32\" data-name=\"checkcheck\"> <path d=\"M29.333 10.267c0 0.4-0.133 0.8-0.533 1.2l-14.8 14.8c-0.267 0.267-0.667 0.4-1.067 0.4s-0.933-0.133-1.2-0.533l-2.4-2.267-6.267-6.267c-0.267-0.267-0.4-0.667-0.4-1.2s0.133-0.8 0.533-1.2l2.4-2.4c0.267-0.133 0.667-0.4 1.067-0.4s0.8 0.133 1.2 0.533l5.067 5.067 11.2-11.333c0.267-0.267 0.667-0.533 1.2-0.533 0.4 0 0.8 0.133 1.2 0.533l2.4 2.4c0.267 0.267 0.4 0.667 0.4 1.2z\"><\/path> <\/svg><\/div><\/div><span class=\"thrv-advanced-inline-text tve_editable tcb-styled-list-icon-text tcb-no-delete tve_empty_dropzone\" style=\"\" data-css=\"tve-u-18da86c3250\"><meta charset=\"utf-8\"><div class=\"thrv_wrapper thrv_text_element tve_empty_dropzone\"><p data-css=\"tve-u-15fcc33f7d3\">Ahora, seleccionamos de la I7 a la L13 y rellenamos las f\u00f3rmulas hacia abajo.<\/p><\/div><\/span><\/li><\/ul><\/div><div class=\"thrv_wrapper thrv_text_element tve_empty_dropzone\" style=\"\"><meta charset=\"utf-8\" class=\"\"><p data-css=\"tve-u-15fcc3502f6\">Muy bien, ahora, solo nos falta crear los formatos condicionales para crear la barra de estado.<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_text_element\" style=\"\" data-css=\"tve-u-15fccdffa67\"><meta charset=\"utf-8\" class=\"\"><h2 data-css=\"tve-u-15fcc35b41a\" class=\"\" style=\"text-align: center;\">Creando Formato Condicional para barra de estado<\/h2><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-18da86f1e2b\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-18da86f1e25\"><div class=\"thrv_wrapper thrv_text_element\"><ul class=\"\"><li class=\"\" style=\"\">Como primer paso seleccionamos de la I7 a la L13, en este caso ya lo tengo seleccionado.<\/li><li class=\"\" style=\"\">Ahora, vamos a crear cuatro reglas de formato Condicional.<\/li><li class=\"\" style=\"\">Por lo tanto, nos ubicamos en formato condiconal y pulsamos clic en Nueva regla.<\/li><li class=\"\" style=\"\">Dentro de este seleccionamos \u201cAplicar formato \u00fanicamente a las celdas que contengan\u201d.<\/li><li class=\"\" style=\"\">Ahora, vamos a editar la descripcion de la regla, en la primer lista desplegable, seleccionamos: Valor de la Celda.<\/li><li class=\"\" style=\"\">En la siguiente lista desplegable seleccionamos \u201cIgual a\u201d y en el cuadro de texto escribimos: =\u201d35\u201d.<\/li><li class=\"\" style=\"\">En seguida pulsamos clic en formato, y en la seccion fuente, le aplicamos el color de fuente verde y en la seccion relleno, le aplicamos el color de relleno verde.<\/li><\/ul><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_text_element\" style=\"\" data-css=\"tve-u-15fccfcf624\"><h2 class=\"\" style=\"text-align: center;\" data-css=\"tve-u-18da879ade8\"><span data-css=\"tve-u-15fccfc808c\" style=\"color: rgb(9, 30, 245);\">Continuamos con mas Formato Condicional<\/span><\/h2><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-18da87bc514\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-18da87bc50d\"><div class=\"thrv_wrapper thrv_text_element\">\t<p style=\"\">Tan solo aceptamos y nuevamente aceptar.<\/p><p style=\"\">Ahora, vamos a seguir los mismos pasos para crear la segunda regla de formato condicional.<\/p><p style=\"\">En este caso solo cambiara el valor en el cuadro de texto por 50 y el color de formato para la fuente y relleno en amarrillo.<\/p><p style=\"\">Listo, ahora continuamos con la tercera regla condicional, para eso repetimos los pasos anteriores.<\/p><p style=\"\">En este caso solo cambiara el valor en el cuadro de texto por 75 y el color de formato para la fuente y relleno en anaranjado.<\/p><p style=\"\">y el ultimo formato condicional con valor de 100 y el formato para la fuente y relleno en color Azul.<\/p><p style=\"\">Ahora, si nos vamos al adminitrador de reglas, puedes notar que hemo creado 4 formato condianal, tal a como se muestra en la imagen:<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper tve_image_caption\" data-css=\"tve-u-15fcc3f7037\" data-clear=\"both\" style=\"\"><span class=\"tve_image_frame\"><img decoding=\"async\" loading=\"lazy\" class=\"tve_image\" alt=\"Formato Condicional Barra de Estados\" title=\"e076c39721a7055b34953824f569ed6f.png\" src=\"\/\/i.pinimg.com\/originals\/e0\/76\/c3\/e076c39721a7055b34953824f569ed6f.png\" width=\"623\"><\/span><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-18da87f3956\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-18da87f394f\"><div class=\"thrv_wrapper thrv_text_element\">\t<p style=\"\">Ahora estamos listo para crear la barra de estado para cada etapa, puedes hacer la prueba, seleccionando el estado y veras como cambiara autom\u00e1ticamente el gr\u00e1fico.<\/p><p style=\"\">Puedes ver la imagen al comienzo de este articulo.<\/p><p style=\"\">Que tal te parecio este articulo? te gusto?<\/p><p style=\"\">Si te gusto, compartelo con tus amigos de <a href=\"https:\/\/www.facebook.com\/AplicaExceContable\/\" target=\"_blank\">facebook<\/a> pulsando clic en el boton compartir:<\/p><\/div><\/div>\n<\/div><div class=\"tcb-clear\" data-css=\"tve-u-18da8800744\"><div class=\"thrv_wrapper thrv_social_custom thrv_social\" data-counts=\"\" data-min_shares=\"0\" data-device-config=\"{&quot;desktop&quot;:{&quot;isFullWidth&quot;:&quot;0&quot;},&quot;tablet&quot;:{},&quot;mobile&quot;:{&quot;button_type&quot;:&quot;tve_social_ib&quot;,&quot;showCount&quot;:&quot;0&quot;}}\" data-css=\"tve-u-18da8800743\" style=\"\">\n<div class=\"tve_social_items tve_social_custom tve-prevent-content-edit tve_style_6 tve_social_itb\">\n\t\n\t\t\n\t\t<div class=\"thrv_wrapper tve_s_item tve_s_fb_share tve_share_item\" data-s=\"fb_share\" data-href=\"{tcb_post_url}\" data-label=\"Compartir\">\n\t\t\t<a href=\"javascript:void(0)\" class=\"tve_s_link\">\n\t\t\t\t<span class=\"thrv_wrapper tve_s_icon\">\n\t\t\t\t\t<svg class=\"tcb-icon\" viewBox=\"0 0 264 512\" data-id=\"icon-fb\" data-name=\"\">\n            <path d=\"M76.7 512V283H0v-91h76.7v-71.7C76.7 42.4 124.3 0 193.8 0c33.3 0 61.9 2.5 70.2 3.6V85h-48.2c-37.8 0-45.1 18-45.1 44.3V192H256l-11.7 91h-73.6v229\"><\/path>\n        <\/svg>\n\t\t\t\t<\/span>\n\t\t\t\t<span class=\"tve_s_text\">Compartir<\/span>\n\t\t\t\t<span class=\"tve_s_count\">0<\/span>\n\t\t\t<\/a>\n\t\t<\/div>\n\t\t\n\t\t<div class=\"thrv_wrapper tve_s_item tve_s_t_share tve_share_item\" data-s=\"t_share\" data-href=\"{tcb_post_url}\" data-label=\"Tweet\">\n\t\t\t<a href=\"javascript:void(0)\" class=\"tve_s_link\">\n\t\t\t\t<span class=\"thrv_wrapper tve_s_icon\">\n\t\t\t\t\t<svg class=\"tcb-icon\" viewBox=\"0 0 512 512\" data-id=\"icon-t\" data-name=\"\">\n            <path d=\"M459.37 151.716c.325 4.548.325 9.097.325 13.645 0 138.72-105.583 298.558-298.558 298.558-59.452 0-114.68-17.219-161.137-47.106 8.447.974 16.568 1.299 25.34 1.299 49.055 0 94.213-16.568 130.274-44.832-46.132-.975-84.792-31.188-98.112-72.772 6.498.974 12.995 1.624 19.818 1.624 9.421 0 18.843-1.3 27.614-3.573-48.081-9.747-84.143-51.98-84.143-102.985v-1.299c13.969 7.797 30.214 12.67 47.431 13.319-28.264-18.843-46.781-51.005-46.781-87.391 0-19.492 5.197-37.36 14.294-52.954 51.655 63.675 129.3 105.258 216.365 109.807-1.624-7.797-2.599-15.918-2.599-24.04 0-57.828 46.782-104.934 104.934-104.934 30.213 0 57.502 12.67 76.67 33.137 23.715-4.548 46.456-13.32 66.599-25.34-7.798 24.366-24.366 44.833-46.132 57.827 21.117-2.273 41.584-8.122 60.426-16.243-14.292 20.791-32.161 39.308-52.628 54.253z\"><\/path>\n        <\/svg>\n\t\t\t\t<\/span>\n\t\t\t\t<span class=\"tve_s_text\">Tweet<\/span>\n\t\t\t\t<span class=\"tve_s_count\">0<\/span>\n\t\t\t<\/a>\n\t\t<\/div>\n\t\t\n\t\t<div class=\"thrv_wrapper tve_s_item tve_s_pin_share tve_share_item\" data-s=\"pin_share\" data-href=\"{tcb_post_url}\" data-label=\"Pin\">\n\t\t\t<a href=\"javascript:void(0)\" class=\"tve_s_link\">\n\t\t\t\t<span class=\"thrv_wrapper tve_s_icon\">\n\t\t\t\t\t<svg class=\"tcb-icon\" viewBox=\"0 0 384 512\" data-id=\"icon-pin\" data-name=\"\">\n            <path d=\"M204 6.5C101.4 6.5 0 74.9 0 185.6 0 256 39.6 296 63.6 296c9.9 0 15.6-27.6 15.6-35.4 0-9.3-23.7-29.1-23.7-67.8 0-80.4 61.2-137.4 140.4-137.4 68.1 0 118.5 38.7 118.5 109.8 0 53.1-21.3 152.7-90.3 152.7-24.9 0-46.2-18-46.2-43.8 0-37.8 26.4-74.4 26.4-113.4 0-66.2-93.9-54.2-93.9 25.8 0 16.8 2.1 35.4 9.6 50.7-13.8 59.4-42 147.9-42 209.1 0 18.9 2.7 37.5 4.5 56.4 3.4 3.8 1.7 3.4 6.9 1.5 50.4-69 48.6-82.5 71.4-172.8 12.3 23.4 44.1 36 69.3 36 106.2 0 153.9-103.5 153.9-196.8C384 71.3 298.2 6.5 204 6.5z\"><\/path>\n        <\/svg>\n\t\t\t\t<\/span>\n\t\t\t\t<span class=\"tve_s_text tve-froala\">Pin<\/span>\n\t\t\t\t<span class=\"tve_s_count\">0<\/span>\n\t\t\t<\/a>\n\t\t<\/div>\n\t\t\n\t\n<\/div>\n<\/div><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-18da8810ecc\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-18da8810ec6\"><div class=\"thrv_wrapper thrv_text_element\">\t<p style=\"\">No olvides visitar nuestra pagina de facebook, <a href=\"https:\/\/www.facebook.com\/AplicaExceContable\/\" target=\"_blank\" class=\"\" style=\"outline: none;\">pulsando clic aqui<\/a>.<\/p><p style=\"\">Tambien puedes contactarme por whatsapp o correo electronico, para eso <a href=\"https:\/\/aplicaexcelcontable.com\/blog\/contacto\" target=\"_blank\" class=\"\" style=\"outline: none;\">visita el siguiente enlace<\/a>.<\/p><p style=\"\">Saludos,<\/p><p style=\"\"><strong>Roger Perez - Aplica Excel Contable<\/strong><\/p><\/div><\/div>\n<\/div>","tve_custom_css":"@media (min-width: 300px){[data-css=\"tve-u-15fccfcf624\"] { margin-top: 0px !important; }[data-css=\"tve-u-15fccfc808c\"] { color: rgb(9, 30, 245) !important; }:not(#tve) [data-css=\"tve-u-15fcceb1cb6\"] { color: rgb(15, 25, 188) !important; }[data-css=\"tve-u-15fccdffa67\"] { margin-top: 0px !important; }[data-css=\"tve-u-15fccc96e41\"] > ul > li { margin-bottom: 1px; }[data-css=\"tve-u-15fccc96e41\"] { margin-top: 0px !important; margin-bottom: 0px !important; }[data-css=\"tve-u-15fcc3f7037\"] + div { clear: both; }[data-css=\"tve-u-15fcc3f7037\"] { width: 623px; float: none; margin-left: auto !important; margin-right: auto !important; margin-top: 0px !important; }:not(#tve) [data-css=\"tve-u-15fcc35b41a\"] { color: rgb(8, 21, 246) !important; font-size: 38px !important; }:not(#tve) [data-css=\"tve-u-15fcc3502f6\"] { color: rgb(6, 1, 1) !important; }:not(#tve) [data-css=\"tve-u-15fcc33a5e7\"] > :first-child { color: rgb(25, 190, 77); }:not(#tve) [data-css=\"tve-u-15fcc33f7d3\"] { color: rgb(6, 0, 0) !important; }:not(#tve) [data-css=\"tve-u-15fcc30b15c\"] { color: rgb(4, 0, 0) !important; }:not(#tve) [data-css=\"tve-u-15fcc2fcfc4\"] > :first-child { color: rgb(25, 190, 77); }:not(#tve) [data-css=\"tve-u-15fcc2e58c8\"] { color: rgb(8, 1, 1) !important; }:not(#tve) [data-css=\"tve-u-15fcc2d0428\"] { color: rgb(13, 1, 1) !important; }:not(#tve) [data-css=\"tve-u-15fcc2c3027\"] > :first-child { color: rgb(25, 190, 77); }:not(#tve) [data-css=\"tve-u-15fcc2c0dfd\"] > :first-child { color: rgb(25, 190, 77); }[data-css=\"tve-u-15fcc2ba61a\"] { color: rgb(6, 1, 1) !important; }:not(#tve) [data-css=\"tve-u-15fcc12bdfc\"] > :first-child { color: rgb(25, 190, 77); }[data-css=\"tve-u-15fcbfb0be4\"] { color: rgb(4, 0, 0) !important; }[data-css=\"tve-u-15fcbfb0bc3\"] { color: rgb(4, 0, 0) !important; }[data-css=\"tve-u-15fcbe8dcb1\"] + div { clear: none; }[data-css=\"tve-u-15fcbe8dcb1\"] { float: none; margin-left: auto; margin-right: auto; width: 584px; margin-top: 0px !important; }[data-css=\"tve-u-15fcb22e119\"] + div { clear: none; }[data-css=\"tve-u-15fcb22e119\"] { float: none; margin-left: auto; margin-right: auto; width: 430px; margin-top: 0px !important; }:not(#tve) [data-css=\"tve-u-15fcb048774\"] { font-size: 42px !important; color: rgb(249, 8, 8) !important; }[data-css=\"tve-u-1874f18a31a\"] { --tve-alignment: center; float: none; border: 4px dashed rgba(7, 199, 88, 0.85); --tve-applied-border: 4px dashed rgba(7,199,88,0.85); --tve-border-width: 4px; --tve-border-radius: 20px; border-radius: 20px; overflow: hidden; margin-left: auto !important; margin-right: auto !important; margin-bottom: 0px !important; }:not(#tve) .thrv-content-box [data-css=\"tve-u-18da833f7f8\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da833f7f8\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da833f7f8\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da833f7f8\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da833f7f8\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da833f7f8\"] label { font-size: var(--tve-font-size,20px); }[data-css=\"tve-u-18da833f7f8\"] { --tve-font-size: 20px; --tve-color: rgb(7,0,0); --tve-applied---tve-color: rgb(7,0,0); text-align: justify; }:not(#tve) .thrv-content-box [data-css=\"tve-u-18da833f7f8\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da833f7f8\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da833f7f8\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da833f7f8\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da833f7f8\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da833f7f8\"] label, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da833f7f8\"] h1, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da833f7f8\"] h2, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da833f7f8\"] h3, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da833f7f8\"] h4, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da833f7f8\"] h5, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da833f7f8\"] h6 { color: var(--tve-color,rgb(7,0,0)); --tve-applied-color: var$(--tve-color,rgb(7,0,0)); --tcb-applied-color: rgb(7,0,0); }[data-css=\"tve-u-18da833f7f8\"] p { padding: 0px 0px 11px !important; margin: 0px !important; }[data-css=\"tve-u-18da833f800\"] { margin-top: 0px !important; margin-bottom: 10px !important; padding-top: 0px !important; padding-bottom: 0px !important; }[data-css=\"tve-u-18da834b221\"] + div { clear: none; }[data-css=\"tve-u-18da834b221\"] { float: none; margin-left: auto; margin-right: auto; width: 584px; margin-top: 0px !important; }:not(#tve) .thrv-content-box [data-css=\"tve-u-18da83a4c47\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da83a4c47\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da83a4c47\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da83a4c47\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da83a4c47\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da83a4c47\"] label { font-size: var(--tve-font-size,20px); }[data-css=\"tve-u-18da83a4c47\"] { --tve-font-size: 20px; --tve-color: rgb(7,0,0); --tve-applied---tve-color: rgb(7,0,0); text-align: justify; }:not(#tve) .thrv-content-box [data-css=\"tve-u-18da83a4c47\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da83a4c47\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da83a4c47\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da83a4c47\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da83a4c47\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da83a4c47\"] label, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da83a4c47\"] h1, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da83a4c47\"] h2, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da83a4c47\"] h3, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da83a4c47\"] h4, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da83a4c47\"] h5, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da83a4c47\"] h6 { color: var(--tve-color,rgb(7,0,0)); --tve-applied-color: var$(--tve-color,rgb(7,0,0)); --tcb-applied-color: rgb(7,0,0); }[data-css=\"tve-u-18da83a4c47\"] p { padding: 0px 0px 11px !important; margin: 0px !important; }[data-css=\"tve-u-18da83a4c50\"] { margin-top: 0px !important; margin-bottom: 10px !important; padding-bottom: 0px !important; }:not(#tve) .thrv-content-box [data-css=\"tve-u-18da83bae26\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da83bae26\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da83bae26\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da83bae26\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da83bae26\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da83bae26\"] label { font-size: var(--tve-font-size,20px); }[data-css=\"tve-u-18da83bae26\"] { --tve-font-size: 20px; --tve-color: rgb(7,0,0); --tve-applied---tve-color: rgb(7,0,0); text-align: justify; }:not(#tve) .thrv-content-box [data-css=\"tve-u-18da83bae26\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da83bae26\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da83bae26\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da83bae26\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da83bae26\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da83bae26\"] label, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da83bae26\"] h1, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da83bae26\"] h2, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da83bae26\"] h3, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da83bae26\"] h4, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da83bae26\"] h5, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da83bae26\"] h6 { color: var(--tve-color,rgb(7,0,0)); --tve-applied-color: var$(--tve-color,rgb(7,0,0)); --tcb-applied-color: rgb(7,0,0); }[data-css=\"tve-u-18da83bae26\"] p { padding: 0px 0px 11px !important; margin: 0px !important; }[data-css=\"tve-u-18da83bae2c\"] { margin-top: 0px !important; margin-bottom: 10px !important; padding-top: 0px !important; padding-bottom: 0px !important; }:not(#tve) [data-css=\"tve-u-18da83f655c\"] { color: rgb(0, 5, 6) !important; --tcb-applied-color: rgb(0,5,6) !important; --tve-applied-color: rgb(0,5,6) !important; }[data-css=\"tve-u-18da84eb126\"] { font-size: 84px; margin-left: auto; margin-right: auto; --tcb-local-color-icon: rgb(4,228,38); --tcb-local-color-var: rgb(4,228,38); --tve-icon-size: 84px; --tcb-icon-rotation-angle: -22deg; width: 84px; height: 84px; }:not(#tve) [data-css=\"tve-u-18da84eb126\"] > :first-child { color: rgb(4, 228, 38); --tve-applied-color: rgb(4,228,38); }[data-css=\"tve-u-18da84eb127\"] { max-width: 18.1%; }[data-css=\"tve-u-18da84eb128\"] { max-width: 81.9%; }:not(#tve) [data-css=\"tve-u-18da84eb129\"] { font-size: 21px !important; }:not(#tve) .thrv-content-box [data-css=\"tve-u-18da84eb12a\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da84eb12a\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da84eb12a\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da84eb12a\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da84eb12a\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da84eb12a\"] label, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da84eb12a\"] h1, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da84eb12a\"] h2, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da84eb12a\"] h3, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da84eb12a\"] h4, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da84eb12a\"] h5, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da84eb12a\"] h6 { color: var(--tve-color,rgb(0,3,6)); --tve-applied-color: var$(--tve-color,rgb(0,3,6)); --tcb-applied-color: rgb(0,3,6); }[data-css=\"tve-u-18da84eb12a\"] { --tve-color: rgb(0,3,6); --tve-applied---tve-color: rgb(0,3,6); text-align: justify; }[data-css=\"tve-u-18da84eb12a\"] p { padding: 0px 0px 9px !important; margin: 0px !important; }[data-css=\"tve-u-18da84eb12b\"] { margin-bottom: 0px !important; margin-top: 0px !important; }[data-css=\"tve-u-18da84eb12d\"] { margin-top: 0px !important; padding-top: 0px !important; padding-bottom: 0px !important; margin-bottom: 0px !important; }[data-css=\"tve-u-18da84eb12e\"] { --tve-border-width: 6px; --tve-border-radius: 60px; border-radius: 60px; overflow: hidden; border: 6px dashed rgb(234, 194, 13) !important; --tve-applied-border: 6px dashed rgb(234,194,13) !important; }[data-css=\"tve-u-18da84eb12f\"] { font-size: 60px; --tcb-local-color-icon: rgb(227,12,38); --tcb-local-color-var: rgb(227,12,38); --tve-icon-size: 60px; float: none; z-index: 3; position: relative; --tve-alignment: center; margin: -109px auto 0px !important; padding-top: 0px !important; }:not(#tve) [data-css=\"tve-u-18da84eb12f\"] > :first-child { color: rgb(227, 12, 38); --tve-applied-color: rgb(227,12,38); }:not(#tve) .thrv-content-box [data-css=\"tve-u-18da8504d40\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da8504d40\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da8504d40\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da8504d40\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da8504d40\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da8504d40\"] label { font-size: var(--tve-font-size,20px); }[data-css=\"tve-u-18da8504d40\"] { --tve-font-size: 20px; --tve-color: rgb(7,0,0); --tve-applied---tve-color: rgb(7,0,0); text-align: justify; }:not(#tve) .thrv-content-box [data-css=\"tve-u-18da8504d40\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da8504d40\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da8504d40\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da8504d40\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da8504d40\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da8504d40\"] label, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da8504d40\"] h1, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da8504d40\"] h2, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da8504d40\"] h3, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da8504d40\"] h4, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da8504d40\"] h5, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da8504d40\"] h6 { color: var(--tve-color,rgb(7,0,0)); --tve-applied-color: var$(--tve-color,rgb(7,0,0)); --tcb-applied-color: rgb(7,0,0); }[data-css=\"tve-u-18da8504d40\"] p { padding: 0px 0px 11px !important; margin: 0px !important; }[data-css=\"tve-u-18da8504d4e\"] { margin-top: 0px !important; margin-bottom: 10px !important; padding-bottom: 0px !important; }:not(#tve) .thrv-content-box [data-css=\"tve-u-18da8679ecc\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da8679ecc\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da8679ecc\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da8679ecc\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da8679ecc\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da8679ecc\"] label { font-size: var(--tve-font-size,20px); }[data-css=\"tve-u-18da8679ecc\"] { --tve-font-size: 20px; --tve-color: rgb(7,0,0); --tve-applied---tve-color: rgb(7,0,0); text-align: justify; }:not(#tve) .thrv-content-box [data-css=\"tve-u-18da8679ecc\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da8679ecc\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da8679ecc\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da8679ecc\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da8679ecc\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da8679ecc\"] label, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da8679ecc\"] h1, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da8679ecc\"] h2, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da8679ecc\"] h3, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da8679ecc\"] h4, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da8679ecc\"] h5, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da8679ecc\"] h6 { color: var(--tve-color,rgb(7,0,0)); --tve-applied-color: var$(--tve-color,rgb(7,0,0)); --tcb-applied-color: rgb(7,0,0); }[data-css=\"tve-u-18da8679ecc\"] p { padding: 0px 0px 11px !important; margin: 0px !important; }[data-css=\"tve-u-18da8679ed2\"] { margin-top: 0px !important; margin-bottom: 0px !important; }[data-css=\"tve-u-18da8693e8f\"] .tcb-button-link { letter-spacing: 2px; background-image: linear-gradient(var(--tcb-local-color-62516,rgb(19,114,211)),var(--tcb-local-color-62516,rgb(19,114,211))); --tve-applied-background-image: linear-gradient(var$(--tcb-local-color-62516,rgb(19,114,211)),var$(--tcb-local-color-62516,rgb(19,114,211))); background-size: auto; background-attachment: scroll; border-radius: 5px; padding: 18px; background-position: 50% 50%; background-repeat: no-repeat; background-color: transparent !important; }[data-css=\"tve-u-18da8693e8f\"] .tcb-button-link span { color: rgb(255, 255, 255); --tcb-applied-color: #fff; }[data-css=\"tve-u-18da8693e8f\"] { --tcb-local-color-62516: rgb(233,246,16) !important; margin-bottom: 10px !important; }:not(#tve) [data-css=\"tve-u-18da869ff59\"] { color: rgb(8, 0, 0) !important; --tcb-applied-color: rgb(8,0,0) !important; --tve-applied-color: rgb(8,0,0) !important; }:not(#tve) .thrv-content-box [data-css=\"tve-u-18da86f1e25\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da86f1e25\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da86f1e25\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da86f1e25\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da86f1e25\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da86f1e25\"] label { font-size: var(--tve-font-size,20px); }[data-css=\"tve-u-18da86f1e25\"] { --tve-font-size: 20px; --tve-color: rgb(7,0,0); --tve-applied---tve-color: rgb(7,0,0); text-align: justify; }:not(#tve) .thrv-content-box [data-css=\"tve-u-18da86f1e25\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da86f1e25\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da86f1e25\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da86f1e25\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da86f1e25\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da86f1e25\"] label, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da86f1e25\"] h1, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da86f1e25\"] h2, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da86f1e25\"] h3, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da86f1e25\"] h4, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da86f1e25\"] h5, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da86f1e25\"] h6 { color: var(--tve-color,rgb(7,0,0)); --tve-applied-color: var$(--tve-color,rgb(7,0,0)); --tcb-applied-color: rgb(7,0,0); }[data-css=\"tve-u-18da86f1e25\"] p { padding: 0px 0px 11px !important; margin: 0px !important; }[data-css=\"tve-u-18da86f1e2b\"] { margin-top: 0px !important; margin-bottom: 0px !important; }:not(#tve) [data-css=\"tve-u-18da879ade8\"] { font-size: 38px !important; }:not(#tve) .thrv-content-box [data-css=\"tve-u-18da87bc50d\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da87bc50d\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da87bc50d\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da87bc50d\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da87bc50d\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da87bc50d\"] label { font-size: var(--tve-font-size,20px); }[data-css=\"tve-u-18da87bc50d\"] { --tve-font-size: 20px; --tve-color: rgb(7,0,0); --tve-applied---tve-color: rgb(7,0,0); text-align: justify; }:not(#tve) .thrv-content-box [data-css=\"tve-u-18da87bc50d\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da87bc50d\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da87bc50d\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da87bc50d\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da87bc50d\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da87bc50d\"] label, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da87bc50d\"] h1, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da87bc50d\"] h2, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da87bc50d\"] h3, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da87bc50d\"] h4, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da87bc50d\"] h5, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da87bc50d\"] h6 { color: var(--tve-color,rgb(7,0,0)); --tve-applied-color: var$(--tve-color,rgb(7,0,0)); --tcb-applied-color: rgb(7,0,0); }[data-css=\"tve-u-18da87bc50d\"] p { padding: 0px 0px 11px !important; margin: 0px !important; }[data-css=\"tve-u-18da87bc514\"] { margin-top: 0px !important; margin-bottom: 10px !important; padding-bottom: 0px !important; }:not(#tve) .thrv-content-box [data-css=\"tve-u-18da87f394f\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da87f394f\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da87f394f\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da87f394f\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da87f394f\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da87f394f\"] label { font-size: var(--tve-font-size,20px); }[data-css=\"tve-u-18da87f394f\"] { --tve-font-size: 20px; --tve-color: rgb(7,0,0); --tve-applied---tve-color: rgb(7,0,0); text-align: justify; }:not(#tve) .thrv-content-box [data-css=\"tve-u-18da87f394f\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da87f394f\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da87f394f\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da87f394f\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da87f394f\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da87f394f\"] label, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da87f394f\"] h1, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da87f394f\"] h2, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da87f394f\"] h3, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da87f394f\"] h4, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da87f394f\"] h5, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da87f394f\"] h6 { color: var(--tve-color,rgb(7,0,0)); --tve-applied-color: var$(--tve-color,rgb(7,0,0)); --tcb-applied-color: rgb(7,0,0); }[data-css=\"tve-u-18da87f394f\"] p { padding: 0px 0px 11px !important; margin: 0px !important; }[data-css=\"tve-u-18da87f3956\"] { margin-top: 0px !important; margin-bottom: 0px !important; padding-bottom: 10px !important; }[data-css=\"tve-u-18da8800743\"] { float: right; z-index: 3; position: relative; --tve-alignment: right; margin-top: 0px !important; margin-bottom: 10px !important; }[data-css=\"tve-u-18da8800744\"]::after { clear: both; }:not(#tve) .thrv-content-box [data-css=\"tve-u-18da8810ec6\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da8810ec6\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da8810ec6\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da8810ec6\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da8810ec6\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da8810ec6\"] label { font-size: var(--tve-font-size,20px); }[data-css=\"tve-u-18da8810ec6\"] { --tve-font-size: 20px; --tve-color: rgb(7,0,0); --tve-applied---tve-color: rgb(7,0,0); text-align: justify; }:not(#tve) .thrv-content-box [data-css=\"tve-u-18da8810ec6\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da8810ec6\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da8810ec6\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da8810ec6\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da8810ec6\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da8810ec6\"] label, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da8810ec6\"] h1, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da8810ec6\"] h2, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da8810ec6\"] h3, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da8810ec6\"] h4, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da8810ec6\"] h5, :not(#tve) .thrv-content-box [data-css=\"tve-u-18da8810ec6\"] h6 { color: var(--tve-color,rgb(7,0,0)); --tve-applied-color: var$(--tve-color,rgb(7,0,0)); --tcb-applied-color: rgb(7,0,0); }[data-css=\"tve-u-18da8810ec6\"] p { padding: 0px 0px 11px !important; margin: 0px !important; }[data-css=\"tve-u-18da8810ecc\"] { margin-top: 0px !important; margin-bottom: 0px !important; padding-bottom: 0px !important; }.tcb-post-list[data-css=\"tve-u-186df1bf84d\"] .post-wrapper.thrv_wrapper { width: calc(100% + 0px); }.tcb-post-list[data-css=\"tve-u-186df1bf84d\"] .post-wrapper.thrv_wrapper:nth-child(n+2) { margin-top: 50px !important; }.tcb-post-list[data-css=\"tve-u-186df1bf84d\"] .post-wrapper.thrv_wrapper:not(:nth-child(n+2)) { margin-top: 0px !important; }.tcb-post-list[data-css=\"tve-u-186df1bf84d\"] .post-wrapper.thrv_wrapper:not(:nth-child(n)) { margin-right: 30px !important; }.tcb-post-list[data-css=\"tve-u-186df1bf84d\"] .post-wrapper.thrv_wrapper:nth-child(n) { margin-right: 0px !important; }.tcb-post-list[data-css=\"tve-u-18703fb75db\"] .post-wrapper.thrv_wrapper { width: calc(33.3333% - 13.3333px); }.tcb-post-list[data-css=\"tve-u-18703fb75db\"] .post-wrapper.thrv_wrapper:nth-child(n+4) { margin-top: 20px !important; }.tcb-post-list[data-css=\"tve-u-18703fb75db\"] .post-wrapper.thrv_wrapper:not(:nth-child(n+4)) { margin-top: 0px !important; }.tcb-post-list[data-css=\"tve-u-18703fb75db\"] .post-wrapper.thrv_wrapper:not(:nth-child(3n)) { margin-right: 20px !important; }.tcb-post-list[data-css=\"tve-u-18703fb75db\"] .post-wrapper.thrv_wrapper:nth-child(3n) { margin-right: 0px !important; }}","tve_user_custom_css":"","tve_globals":{"e":"1","font_cls":[]},"tcb2_ready":1,"tcb_editor_enabled":1,"tve_landing_page":"","_tve_header":"","_tve_footer":""},"categories":[64],"tags":[3441,3440,66],"class_list":["post-26872","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-soluciones-excel","tag-barra-de-estado","tag-barra-de-estado-en-excel","tag-excel","post-wrapper","thrv_wrapper"],"_links":{"self":[{"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/posts\/26872","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/comments?post=26872"}],"version-history":[{"count":0,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/posts\/26872\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/media\/48971"}],"wp:attachment":[{"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/media?parent=26872"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/categories?post=26872"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/tags?post=26872"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}