{"id":40861,"date":"2019-02-06T06:48:10","date_gmt":"2019-02-06T12:48:10","guid":{"rendered":"https:\/\/aplicaexcelcontable.com\/blog\/?p=40861"},"modified":"2025-03-11T14:31:02","modified_gmt":"2025-03-11T20:31:02","slug":"formulas-hoja-resumen","status":"publish","type":"post","link":"https:\/\/aplicaexcelcontable.com\/blog\/formulas-hoja-resumen.html","title":{"rendered":"Formulas hoja Resumen de tu App FI"},"content":{"rendered":"<h1 style=\"text-align: center;\">Formulas Hoja Resumen de tu App FI<\/h1>\n<p style=\"text-align: justify;\">Estas listo para aplicar las f\u00f3rmulas Hoja Resumen de tu App FI (Facturaci\u00f3n e Inventario) b\u00e1sico?<\/p>\n<p><span style=\"width: 100%;\"><img loading=\"lazy\" decoding=\"async\" alt=\"Formulas hoja Resumen\" width=\"456\" height=\"147\" title=\"Formulas Hoja Resumen\" data-id=\"40867\" src=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2019\/02\/Formulas-Hoja-Resumen.png.webp\" style=\"aspect-ratio: auto 464 \/ 150;\" data-width=\"456\" data-height=\"147\" data-init-width=\"464\" data-init-height=\"150\"><\/span><\/p>\n<p style=\"text-align: justify;\">Y en el tema de hoy vamos a ver y agregar las formulas para la Hoja Resumen, vamos a asignarle formula a las celdas:<\/p>\n<ul>\n<li style=\"\"><span style=\"\">Crearemos formulas para la columna Entrada<\/span><\/li>\n<li style=\"\"><span style=\"\">Crearemos formulas para la columna Salida<\/span><\/li>\n<li style=\"\"><span style=\"\">Asignaremos formulas para la columna Saldos<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\">Por lo tanto, este es el tema 14 y antes de comenzar, tengo una pregunta para ti, \u00bfya viste el tema 13?<\/p>\n<p style=\"text-align: justify;\">Si no has visto el tema 13 \u00bb Formulas hoja Base de tu App FI b\u00e1sico\u00bb, tan solo pulsa clic en el bot\u00f3n Ver tema13:<\/p>\n<p style=\"text-align: justify;\">Si ya viste el tema 13 y estas preparado para continuar con el tema 14, entonces veamos los pasos:<\/p>\n<h2 style=\"text-align: center;\">Formulas Hoja Resumen &#8211; Columna Entrada<\/h2>\n<p style=\"text-align: justify;\">Para comenzar, nos vamos a la Hoja Resumen y nos ubicamos dentro de la celda C5.<\/p>\n<p style=\"text-align: justify;\">Dentro de este vamos a escribir la siguiente formula:<\/p>\n<p style=\"text-align: center;\">=SUMAR.SI(BASE[COD.PROD];[@CODIGO];BASE[ENTRADA])<\/p>\n<p style=\"text-align: justify;\">Pulsamos enter y listo, le hemos agregado la formula para llamar el movimiento de entrada de cada producto.<\/p>\n<p style=\"text-align: justify;\">Y ahora continuamos con la siguiente formula:<\/p>\n<h2 style=\"text-align: center;\">Formulas Hoja Resumen &#8211; Columna Salida<\/h2>\n<p style=\"text-align: justify;\">A continuaci\u00f3n, vamos a ubicarnos en la celda D5 y vamos a escribir la siguiente formula:<\/p>\n<p style=\"text-align: center;\">=SUMAR.SI(BASE[COD.PROD];[@CODIGO];BASE[SALIDA])<\/p>\n<p style=\"text-align: justify;\">Y pulsamos enter, con este paso hemos agregado la segunda formula para llamar el movimiento de Salida de cada producto, ahora veamos la ultima formula:<\/p>\n<h2 style=\"text-align: center;\">Formulas Hoja Resumen &#8211; Columna Saldos<\/h2>\n<p style=\"text-align: justify;\">Para finalizar de agregar formula, vamos a ubicarnos en la celda E5 y escribimos la siguiente formula:<\/p>\n<p style=\"text-align: center;\">=[@ENTRADA]-[@SADLIDA]<\/p>\n<p style=\"text-align: justify;\">Pulsamos enter, y listo, hemos formulado la hoja Resumen.<\/p>\n<p style=\"\">\u00bfQu\u00e9 tal te pareci\u00f3 el art\u00edculo de hoy \u00abFormulas Hoja Resumen de tu App FI \u00ab? \u00bfTe gusto?<\/p>\n<p style=\"\">Si te gusto, te invito a compartirlo con tus amigos por correo electr\u00f3nico, WhatsApp o bien por <a href=\"https:\/\/www.facebook.com\/AplicaExceContable\/\" target=\"_blank\" style=\"outline: none;\" rel=\"noopener\">Facebook<\/a>, a continuaci\u00f3n, te dejo un bot\u00f3n para que puedas compartirlo:<\/p>\n<p style=\"\">Cualquier duda o pregunta, puedes escribirme directamente en la<span style=\"--tcb-text-highlight-color: rgb(237, 243, 13) !important;\">&nbsp;<\/span><a href=\"#comentario\" style=\"outline: none;\"><span style=\"--tcb-text-highlight-color: rgb(237, 243, 13) !important;\">secci\u00f3n de comentarios<\/span><\/a>, en la <a href=\"https:\/\/aplicaexcelcontable.com\/blog\/contacto\" target=\"_blank\" style=\"outline: none;\"><span style=\"--tcb-text-highlight-color: rgb(231, 100, 224) !important;\" data-text-highlight=\"bubble\">pagina del chat<\/span><\/a>, directamente en <span style=\"--tcb-text-highlight-color: rgb(30, 184, 76) !important;\">whatsapp<\/span> o bien al correo electr\u00f3nico rogerperez@aplicaexcelcontable.com.<span style=\"--tcb-text-highlight-color: transparent !important;\"><\/span><\/p>\n<p style=\"\">Te saluda,<span style=\"--tcb-text-highlight-color: transparent !important;\"><\/span><\/p>\n<p style=\"\"><strong>Roger Perez \u2013 Aplica Excel Contable<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Formulas Hoja Resumen de tu App FI Estas listo para aplicar las f\u00f3rmulas Hoja Resumen de tu App FI (Facturaci\u00f3n e Inventario) b\u00e1sico? Y en el tema de hoy vamos a ver y agregar las formulas para la Hoja Resumen, vamos a asignarle formula a las celdas: Crearemos formulas para la columna Entrada Crearemos formulas [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":40867,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","tve_updated_post":"<div class=\"thrv_wrapper thrv_text_element\" data-tag=\"h2\" style=\"\"><h1 class=\"\" style=\"text-align: center;\">Formulas Hoja Resumen de tu App FI<\/h1><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box\" style=\"\" data-css=\"tve-u-168c2b1a8c5\">\n<div class=\"tve-content-box-background\"><\/div>\n<div class=\"tve-cb tve_empty_dropzone\" data-css=\"tve-u-168c2b09983\" style=\"\"><div class=\"thrv_wrapper thrv_text_element tve_empty_dropzone\" style=\"\"><p data-css=\"tve-u-168c2b09985\" style=\"text-align: justify;\">Estas listo para aplicar las f\u00f3rmulas Hoja Resumen de tu App FI (Facturaci\u00f3n e Inventario) b\u00e1sico?<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper tve_image_caption\" style=\"\" data-css=\"tve-u-168c2b67bcd\"><span class=\"tve_image_frame\" style=\"width: 100%;\"><img loading=\"lazy\" decoding=\"async\" class=\"tve_image wp-image-40867\" alt=\"Formulas hoja Resumen\" width=\"456\" height=\"147\" title=\"Formulas Hoja Resumen\" data-id=\"40867\" src=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2019\/02\/Formulas-Hoja-Resumen.png.webp\" style=\"aspect-ratio: auto 464 \/ 150;\" data-width=\"456\" data-height=\"147\" data-init-width=\"464\" data-init-height=\"150\"><\/span><\/div><div class=\"thrv_wrapper thrv-button tve_ea_thrive_lightbox\" data-css=\"tve-u-16b842270a1\" data-button-size=\"l\" data-tcb_hover_state_parent=\"\" style=\"\">\n\t<a href=\"\" class=\"tcb-button-link tve_evt_manager_listen tve_et_click\" data-tcb-events=\"__TCB_EVENT_[{&quot;config&quot;:{&quot;l_anim&quot;:&quot;instant&quot;,&quot;l_id&quot;:&quot;42924&quot;},&quot;a&quot;:&quot;thrive_lightbox&quot;,&quot;t&quot;:&quot;click&quot;}]_TNEVE_BCT__\">\n\t\t<span class=\"tcb-button-texts\"><span class=\"tcb-button-text thrv-inline-text\" data-css=\"tve-u-16b842a1609\">Clic aqui P\/ver video Ahora \u2192<\/span><\/span>\n\t<\/a>\n<\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box\" style=\"\" data-css=\"tve-u-168c2b90e65\">\n<div class=\"tve-content-box-background\"><\/div>\n<div class=\"tve-cb tve_empty_dropzone\" data-css=\"tve-u-168c2b86786\" style=\"\"><div class=\"thrv_wrapper thrv_text_element tve_empty_dropzone\" style=\"\"><p data-css=\"tve-u-168c2b86788\" style=\"text-align: justify;\">Y en el tema de hoy vamos a ver y agregar las formulas para la Hoja Resumen, vamos a asignarle formula a las celdas:<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv-styled_list\" data-icon-code=\"icon-check\" style=\"\" data-css=\"tve-u-168c2bc8e59\"><ul class=\"tcb-styled-list\"><li class=\"thrv-styled-list-item\" style=\"\"><div class=\"tcb-styled-list-icon\"><div class=\"thrv_wrapper thrv_icon tve_no_drag tcb-no-delete tcb-no-clone tcb-no-save tcb-icon-inherit-style\" data-css=\"tve-u-168c2bc9fa2\" style=\"\"><svg class=\"tcb-icon\" viewBox=\"0 0 32 32\" data-id=\"icon-check\" data-name=\"\"><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 tcb-no-save\" data-css=\"tve-u-168c2bb3a76\" style=\"\">Crearemos formulas para la columna Entrada<\/span><\/li><li class=\"thrv-styled-list-item\" style=\"\"><div class=\"tcb-styled-list-icon\"><div class=\"thrv_wrapper thrv_icon tve_no_drag tcb-no-delete tcb-no-clone tcb-no-save tcb-icon-inherit-style\" data-css=\"tve-u-168c2bc9fa2\"><svg class=\"tcb-icon\" viewBox=\"0 0 32 32\" data-id=\"icon-check\" data-name=\"\"><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 tcb-no-save\" data-css=\"tve-u-168c2bb3a76\" style=\"\">Crearemos formulas para la columna Salida<\/span><\/li><li class=\"thrv-styled-list-item\" style=\"\"><div class=\"tcb-styled-list-icon\"><div class=\"thrv_wrapper thrv_icon tve_no_drag tcb-no-delete tcb-no-clone tcb-no-save tcb-icon-inherit-style\" data-css=\"tve-u-168c2bc9fa2\"><svg class=\"tcb-icon\" viewBox=\"0 0 32 32\" data-id=\"icon-check\" data-name=\"\"><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 tcb-no-save\" data-css=\"tve-u-168c2bb3a76\" style=\"\">Asignaremos formulas para la columna Saldos<\/span><\/li><\/ul><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box\" style=\"\" data-css=\"tve-u-168c2be1fa7\">\n<div class=\"tve-content-box-background\"><\/div>\n<div class=\"tve-cb tve_empty_dropzone\" data-css=\"tve-u-168c2bd26ec\" style=\"\"><div class=\"thrv_wrapper thrv_text_element tve_empty_dropzone\" style=\"\"><p data-css=\"tve-u-168c2bd26ed\" style=\"text-align: justify;\">Por lo tanto, este es el tema 14 y antes de comenzar, tengo una pregunta para ti, \u00bfya viste el tema 13?<\/p><p data-css=\"tve-u-168c2bd26ed\" style=\"text-align: justify;\">Si no has visto el tema 13 \" Formulas hoja Base de tu App FI b\u00e1sico\", tan solo pulsa clic en el bot\u00f3n Ver tema13:<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv-button tve_ea_thrive_animation tve_anim_slide_left\" data-css=\"tve-u-168c2c00ee7\" data-tcb_hover_state_parent=\"\" data-button-size=\"m\" style=\"\">\n<a href=\"https:\/\/aplicaexcelcontable.com\/blog\/formulas-hoja-base-de-tu-app-fi.html\" class=\"tcb-button-link tve_evt_manager_listen tve_et_tve-viewport\" target=\"_blank\" data-tcb-events=\"__TCB_EVENT_[{&quot;t&quot;:&quot;tve-viewport&quot;,&quot;config&quot;:{&quot;anim&quot;:&quot;slide_left&quot;,&quot;loop&quot;:0},&quot;a&quot;:&quot;thrive_animation&quot;}]_TNEVE_BCT__\">\n<span class=\"tcb-button-texts\"><span class=\"tcb-button-text thrv-inline-text\">Clic aqu\u00ed para ver el tema 13 \u2192<\/span><\/span>\n<\/a>\n<\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box\" style=\"\" data-css=\"tve-u-168c2c17fe3\">\n<div class=\"tve-content-box-background\"><\/div>\n<div class=\"tve-cb tve_empty_dropzone\" data-css=\"tve-u-168c2c12904\" style=\"\"><div class=\"thrv_wrapper thrv_text_element tve_empty_dropzone\" style=\"\"><p data-css=\"tve-u-168c2c12906\" style=\"text-align: justify;\">Si ya viste el tema 13 y estas preparado para continuar con el tema 14, entonces veamos los pasos:<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_text_element\" data-tag=\"h2\" style=\"\"><h2 style=\"text-align: center;\" class=\"\">Formulas Hoja Resumen - Columna Entrada<\/h2><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box\" style=\"\" data-css=\"tve-u-168c2c607e9\">\n<div class=\"tve-content-box-background\"><\/div>\n<div class=\"tve-cb tve_empty_dropzone\" data-css=\"tve-u-168c2c47cb4\" style=\"\"><div class=\"thrv_wrapper thrv_text_element tve_empty_dropzone\" style=\"\"><p data-css=\"tve-u-168c2c47cb6\" style=\"text-align: justify;\">Para comenzar, nos vamos a la Hoja Resumen y nos ubicamos dentro de la celda C5.<\/p><p data-css=\"tve-u-168c2c47cb6\" style=\"text-align: justify;\">Dentro de este vamos a escribir la siguiente formula:<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box\" style=\"\" data-css=\"tve-u-168c2caaaaa\">\n<div class=\"tve-content-box-background\" data-css=\"tve-u-168c2caaaa5\" data-clip-id=\"709a10134391c\"><svg width=\"0\" height=\"0\" class=\"tve-decoration-svg\"><defs><clipPath id=\"clip-bottom-709a10134391c\" class=\"decoration-clip clip-path-bottom\" clipPathUnits=\"objectBoundingBox\" data-screen=\"\" decoration-type=\"divider\" pointer-width=\"13\" pointer-height=\"27\" style=\"curves\" clip-path=\"url(#clip-top-709a10134391c)\"><polygon points=\"0 0, 0 0.73, 1 0.73, 1 0\"><\/polygon><ellipse cx=\"0.0625\" cy=\"0.73\" rx=\"0.062500\" ry=\"0.27\"><\/ellipse><ellipse cx=\"0.1875\" cy=\"0.73\" rx=\"0.062500\" ry=\"0.27\"><\/ellipse><ellipse cx=\"0.3125\" cy=\"0.73\" rx=\"0.062500\" ry=\"0.27\"><\/ellipse><ellipse cx=\"0.4375\" cy=\"0.73\" rx=\"0.062500\" ry=\"0.27\"><\/ellipse><ellipse cx=\"0.5625\" cy=\"0.73\" rx=\"0.062500\" ry=\"0.27\"><\/ellipse><ellipse cx=\"0.6875\" cy=\"0.73\" rx=\"0.062500\" ry=\"0.27\"><\/ellipse><ellipse cx=\"0.8125\" cy=\"0.73\" rx=\"0.062500\" ry=\"0.27\"><\/ellipse><ellipse cx=\"0.9375\" cy=\"0.73\" rx=\"0.062500\" ry=\"0.27\"><\/ellipse><\/clipPath><clipPath id=\"clip-top-709a10134391c\" class=\"decoration-clip clip-path-top\" clipPathUnits=\"objectBoundingBox\" data-screen=\"\" decoration-type=\"divider\" pointer-width=\"7\" pointer-height=\"6\" style=\"zigzag\"><polygon points=\"0 1, 1 1,1 0.06, 0.9642850000000001 0, 0.92857 0.06, 0.892855 0, 0.85714 0.06, 0.8214250000000001 0, 0.78571 0.06, 0.749995 0, 0.71428 0.06, 0.6785650000000001 0, 0.64285 0.06, 0.607135 0, 0.57142 0.06, 0.5357050000000001 0, 0.49999000000000005 0.06, 0.464275 0, 0.42856000000000005 0.06, 0.3928450000000001 0, 0.35713000000000006 0.06, 0.321415 0, 0.28570000000000007 0.06, 0.24998500000000012 0, 0.21427000000000007 0.06, 0.17855500000000002 0, 0.14284000000000008 0.06, 0.10712500000000014 0, 0.07141000000000008 0.06, 0.03569500000000003 0, -0.00001999999999990898 0.06, 0 0\"><\/polygon><\/clipPath><\/defs><\/svg><\/div>\n<div class=\"tve-cb\" data-css=\"tve-u-168c2caaaa9\"><div class=\"thrv_wrapper thrv_text_element\" style=\"\"><p data-css=\"tve-u-168c2caaaa7\" style=\"text-align: center;\">=SUMAR.SI(BASE[COD.PROD];[@CODIGO];BASE[ENTRADA])<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box\" style=\"\" data-css=\"tve-u-168c2ce7340\">\n<div class=\"tve-content-box-background\"><\/div>\n<div class=\"tve-cb tve_empty_dropzone\" data-css=\"tve-u-168c2cd0c39\" style=\"\"><div class=\"thrv_wrapper thrv_text_element tve_empty_dropzone\" style=\"\"><p data-css=\"tve-u-168c2cd0c3b\" style=\"text-align: justify;\">Pulsamos enter y listo, le hemos agregado la formula para llamar el movimiento de entrada de cada producto.<\/p><p data-css=\"tve-u-168c2cd0c3b\" style=\"text-align: justify;\">Y ahora continuamos con la siguiente formula:<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_text_element\" data-tag=\"h2\" style=\"\"><h2 style=\"text-align: center;\" class=\"\">Formulas Hoja Resumen - Columna Salida<\/h2><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box\" style=\"\" data-css=\"tve-u-168c2cfc341\">\n<div class=\"tve-content-box-background\"><\/div>\n<div class=\"tve-cb tve_empty_dropzone\" data-css=\"tve-u-168c2cf4c66\" style=\"\"><div class=\"thrv_wrapper thrv_text_element tve_empty_dropzone\" style=\"\"><p data-css=\"tve-u-168c2cf4c67\" style=\"text-align: justify;\">A continuaci\u00f3n, vamos a ubicarnos en la celda D5 y vamos a escribir la siguiente formula:<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box\" style=\"\" data-css=\"tve-u-168c2d02777\">\n<div class=\"tve-content-box-background\" data-css=\"tve-u-168c2d02773\" data-clip-id=\"c2b17364c8638\"><svg width=\"0\" height=\"0\" class=\"tve-decoration-svg\"><defs><clipPath id=\"clip-bottom-c2b17364c8638\" class=\"decoration-clip clip-path-bottom\" clipPathUnits=\"objectBoundingBox\" data-screen=\"\" decoration-type=\"divider\" pointer-width=\"13\" pointer-height=\"27\" style=\"curves\" clip-path=\"url(#clip-top-c2b17364c8638)\"><polygon points=\"0 0, 0 0.73, 1 0.73, 1 0\"><\/polygon><ellipse cx=\"0.0625\" cy=\"0.73\" rx=\"0.062500\" ry=\"0.27\"><\/ellipse><ellipse cx=\"0.1875\" cy=\"0.73\" rx=\"0.062500\" ry=\"0.27\"><\/ellipse><ellipse cx=\"0.3125\" cy=\"0.73\" rx=\"0.062500\" ry=\"0.27\"><\/ellipse><ellipse cx=\"0.4375\" cy=\"0.73\" rx=\"0.062500\" ry=\"0.27\"><\/ellipse><ellipse cx=\"0.5625\" cy=\"0.73\" rx=\"0.062500\" ry=\"0.27\"><\/ellipse><ellipse cx=\"0.6875\" cy=\"0.73\" rx=\"0.062500\" ry=\"0.27\"><\/ellipse><ellipse cx=\"0.8125\" cy=\"0.73\" rx=\"0.062500\" ry=\"0.27\"><\/ellipse><ellipse cx=\"0.9375\" cy=\"0.73\" rx=\"0.062500\" ry=\"0.27\"><\/ellipse><\/clipPath><clipPath id=\"clip-top-c2b17364c8638\" class=\"decoration-clip clip-path-top\" clipPathUnits=\"objectBoundingBox\" data-screen=\"\" decoration-type=\"divider\" pointer-width=\"7\" pointer-height=\"6\" style=\"zigzag\"><polygon points=\"0 1, 1 1,1 0.06, 0.9642850000000001 0, 0.92857 0.06, 0.892855 0, 0.85714 0.06, 0.8214250000000001 0, 0.78571 0.06, 0.749995 0, 0.71428 0.06, 0.6785650000000001 0, 0.64285 0.06, 0.607135 0, 0.57142 0.06, 0.5357050000000001 0, 0.49999000000000005 0.06, 0.464275 0, 0.42856000000000005 0.06, 0.3928450000000001 0, 0.35713000000000006 0.06, 0.321415 0, 0.28570000000000007 0.06, 0.24998500000000012 0, 0.21427000000000007 0.06, 0.17855500000000002 0, 0.14284000000000008 0.06, 0.10712500000000014 0, 0.07141000000000008 0.06, 0.03569500000000003 0, -0.00001999999999990898 0.06, 0 0\"><\/polygon><\/clipPath><\/defs><\/svg><\/div>\n<div class=\"tve-cb\" data-css=\"tve-u-168c2d02776\"><div class=\"thrv_wrapper thrv_text_element\" style=\"\"><p data-css=\"tve-u-168c2d02774\" style=\"text-align: center;\">=SUMAR.SI(BASE[COD.PROD];[@CODIGO];BASE[SALIDA])<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box\" style=\"\" data-css=\"tve-u-168c2d3d381\">\n<div class=\"tve-content-box-background\"><\/div>\n<div class=\"tve-cb tve_empty_dropzone\" data-css=\"tve-u-168c2d2601b\" style=\"\"><div class=\"thrv_wrapper thrv_text_element tve_empty_dropzone\" style=\"\"><p data-css=\"tve-u-168c2d2601c\" style=\"text-align: justify;\">Y pulsamos enter, con este paso hemos agregado la segunda formula para llamar el movimiento de Salida de cada producto, ahora veamos la ultima formula:<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_text_element\" data-tag=\"h2\" style=\"\"><h2 style=\"text-align: center;\" class=\"\">Formulas Hoja Resumen - Columna Saldos<\/h2><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box\" style=\"\" data-css=\"tve-u-168c2d5dc81\">\n<div class=\"tve-content-box-background\"><\/div>\n<div class=\"tve-cb tve_empty_dropzone\" data-css=\"tve-u-168c2d543b7\" style=\"\"><div class=\"thrv_wrapper thrv_text_element tve_empty_dropzone\" style=\"\"><p data-css=\"tve-u-168c2d543b8\" style=\"text-align: justify;\">Para finalizar de agregar formula, vamos a ubicarnos en la celda E5 y escribimos la siguiente formula:<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box\" style=\"\" data-css=\"tve-u-168c2d61f44\">\n<div class=\"tve-content-box-background\" data-css=\"tve-u-168c2d61f3f\" data-clip-id=\"991244c68325e\"><svg width=\"0\" height=\"0\" class=\"tve-decoration-svg\"><defs><clipPath id=\"clip-bottom-991244c68325e\" class=\"decoration-clip clip-path-bottom\" clipPathUnits=\"objectBoundingBox\" data-screen=\"\" decoration-type=\"divider\" pointer-width=\"13\" pointer-height=\"27\" style=\"curves\" clip-path=\"url(#clip-top-991244c68325e)\"><polygon points=\"0 0, 0 0.73, 1 0.73, 1 0\"><\/polygon><ellipse cx=\"0.0625\" cy=\"0.73\" rx=\"0.062500\" ry=\"0.27\"><\/ellipse><ellipse cx=\"0.1875\" cy=\"0.73\" rx=\"0.062500\" ry=\"0.27\"><\/ellipse><ellipse cx=\"0.3125\" cy=\"0.73\" rx=\"0.062500\" ry=\"0.27\"><\/ellipse><ellipse cx=\"0.4375\" cy=\"0.73\" rx=\"0.062500\" ry=\"0.27\"><\/ellipse><ellipse cx=\"0.5625\" cy=\"0.73\" rx=\"0.062500\" ry=\"0.27\"><\/ellipse><ellipse cx=\"0.6875\" cy=\"0.73\" rx=\"0.062500\" ry=\"0.27\"><\/ellipse><ellipse cx=\"0.8125\" cy=\"0.73\" rx=\"0.062500\" ry=\"0.27\"><\/ellipse><ellipse cx=\"0.9375\" cy=\"0.73\" rx=\"0.062500\" ry=\"0.27\"><\/ellipse><\/clipPath><clipPath id=\"clip-top-991244c68325e\" class=\"decoration-clip clip-path-top\" clipPathUnits=\"objectBoundingBox\" data-screen=\"\" decoration-type=\"divider\" pointer-width=\"7\" pointer-height=\"6\" style=\"zigzag\"><polygon points=\"0 1, 1 1,1 0.06, 0.9642850000000001 0, 0.92857 0.06, 0.892855 0, 0.85714 0.06, 0.8214250000000001 0, 0.78571 0.06, 0.749995 0, 0.71428 0.06, 0.6785650000000001 0, 0.64285 0.06, 0.607135 0, 0.57142 0.06, 0.5357050000000001 0, 0.49999000000000005 0.06, 0.464275 0, 0.42856000000000005 0.06, 0.3928450000000001 0, 0.35713000000000006 0.06, 0.321415 0, 0.28570000000000007 0.06, 0.24998500000000012 0, 0.21427000000000007 0.06, 0.17855500000000002 0, 0.14284000000000008 0.06, 0.10712500000000014 0, 0.07141000000000008 0.06, 0.03569500000000003 0, -0.00001999999999990898 0.06, 0 0\"><\/polygon><\/clipPath><\/defs><\/svg><\/div>\n<div class=\"tve-cb\" data-css=\"tve-u-168c2d61f42\"><div class=\"thrv_wrapper thrv_text_element\" style=\"\"><p data-css=\"tve-u-168c2d61f41\" style=\"text-align: center;\">=[@ENTRADA]-[@SADLIDA]<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box\" style=\"\" data-css=\"tve-u-168c2d924c9\">\n<div class=\"tve-content-box-background\"><\/div>\n<div class=\"tve-cb tve_empty_dropzone\" data-css=\"tve-u-168c2d8487d\" style=\"\"><div class=\"thrv_wrapper thrv_text_element tve_empty_dropzone\" style=\"\"><p data-css=\"tve-u-168c2d8487f\" style=\"text-align: justify;\">Pulsamos enter, y listo, hemos formulado la hoja Resumen.<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-19586e806a1\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-19586e806a0\"><div class=\"thrv_wrapper thrv_text_element\">\t<p style=\"\">\u00bfQu\u00e9 tal te pareci\u00f3 el art\u00edculo de hoy \"Formulas Hoja Resumen de tu App FI \"? \u00bfTe gusto?<\/p><p style=\"\">Si te gusto, te invito a compartirlo con tus amigos por correo electr\u00f3nico, WhatsApp o bien por <a href=\"https:\/\/www.facebook.com\/AplicaExceContable\/\" target=\"_blank\" class=\"\" style=\"outline: none;\">Facebook<\/a>, a continuaci\u00f3n, te dejo un bot\u00f3n para que puedas compartirlo:<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_social_custom thrv_social\" data-counts=\"\" data-min_shares=\"0\" style=\"\" data-css=\"tve-u-168c2d9a8d6\">\n<div class=\"tve_social_items tve_social_custom tve_style_1 tve_social_itb\">\n<div class=\"tve_s_item tve_s_fb_share\" data-s=\"fb_share\" data-href=\"https:\/\/aplicaexcelcontable.com\/blog\/formulas-hoja-resumen-de-tu-app-fi.html\" data-label=\"Compartir\">\n<a href=\"javascript:void(0)\" class=\"tve_s_link\"><span class=\"tve_s_icon thrv-svg-icon\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"tcb-facebook\" viewBox=\"0 0 16 28\"><path d=\"M14.984 0.187v4.125h-2.453q-1.344 0-1.813 0.562t-0.469 1.687v2.953h4.578l-0.609 4.625h-3.969v11.859h-4.781v-11.859h-3.984v-4.625h3.984v-3.406q0-2.906 1.625-4.508t4.328-1.602q2.297 0 3.563 0.187z\"><\/path><\/svg><\/span><span class=\"tve_s_text\">Compartir<\/span><span class=\"tve_s_count\">0<\/span><\/a>\n<\/div>\n<\/div>\n<\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-19586e81f74\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-19586e81f73\"><div class=\"thrv_wrapper thrv_text_element tcb-highlight-added\">\t<p style=\"\">Cualquier duda o pregunta, puedes escribirme directamente en la<span style=\"--tcb-text-highlight-color: rgb(237, 243, 13) !important;\" data-css=\"tve-u-19586e81f75\">&nbsp;<\/span><a href=\"#comentario\" class=\"tve-jump-scroll\" style=\"outline: none;\"><span style=\"--tcb-text-highlight-color: rgb(237, 243, 13) !important;\" data-css=\"tve-u-19586e81f76\">secci\u00f3n de comentarios<\/span><\/a>, en la <a href=\"https:\/\/aplicaexcelcontable.com\/blog\/contacto\" target=\"_blank\" class=\"\" style=\"outline: none;\"><span style=\"--tcb-text-highlight-color: rgb(231, 100, 224) !important;\" data-css=\"tve-u-19586e81f77\" data-text-highlight=\"bubble\">pagina del chat<\/span><\/a>, directamente en <span style=\"--tcb-text-highlight-color: rgb(30, 184, 76) !important;\" data-css=\"tve-u-19586e81f78\">whatsapp<\/span> o bien al correo electr\u00f3nico rogerperez@aplicaexcelcontable.com.<span style=\"--tcb-text-highlight-color: transparent !important;\" data-css=\"tve-u-19586e81f79\"><\/span><\/p><p style=\"\">Te saluda,<span style=\"--tcb-text-highlight-color: transparent !important;\"><\/span><\/p><p style=\"\"><strong>Roger Perez \u2013 Aplica Excel Contable<\/strong><\/p><\/div><\/div>\n<\/div>","tve_custom_css":"@media (min-width: 300px){[data-css=\"tve-u-168c2b09983\"] p { margin: 0px 0px 11px !important; padding: 0px !important; }:not(#tve) [data-css=\"tve-u-168c2b09985\"] { color: rgb(10, 0, 0) !important; }[data-css=\"tve-u-168c2b1a8c5\"] { margin-top: 0px !important; margin-bottom: 0px !important; }[data-css=\"tve-u-168c2b67bcd\"] { width: 464px; float: none; border: 4px dashed rgb(235, 235, 10); border-radius: 10px; overflow: hidden; margin: 0px auto !important; }[data-css=\"tve-u-168c2b86786\"] p { margin: 0px 0px 11px !important; padding: 0px !important; }:not(#tve) [data-css=\"tve-u-168c2b86788\"] { color: rgb(10, 0, 0) !important; }[data-css=\"tve-u-168c2b90e65\"] { margin-top: 10px !important; margin-bottom: 0px !important; }:not(#tve) [data-css=\"tve-u-168c2bc8e59\"] p, :not(#tve) [data-css=\"tve-u-168c2bc8e59\"] li, :not(#tve) [data-css=\"tve-u-168c2bc8e59\"] blockquote, :not(#tve) [data-css=\"tve-u-168c2bc8e59\"] address, :not(#tve) [data-css=\"tve-u-168c2bc8e59\"] .tcb-plain-text, :not(#tve) [data-css=\"tve-u-168c2bc8e59\"] label, :not(#tve) [data-css=\"tve-u-168c2bc8e59\"] h1, :not(#tve) [data-css=\"tve-u-168c2bc8e59\"] h2, :not(#tve) [data-css=\"tve-u-168c2bc8e59\"] h3, :not(#tve) [data-css=\"tve-u-168c2bc8e59\"] h4, :not(#tve) [data-css=\"tve-u-168c2bc8e59\"] h5, :not(#tve) [data-css=\"tve-u-168c2bc8e59\"] h6 { color: rgb(10, 1, 1); }[data-css=\"tve-u-168c2bc9fa2\"] { font-size: 24px !important; width: 24px !important; height: 24px !important; }[data-css=\"tve-u-168c2bc8e59\"] { margin-top: 0px !important; margin-bottom: 0px !important; --tve-font-size: 20px; }[data-css=\"tve-u-168c2bd26ec\"] p { margin: 0px 0px 11px !important; padding: 0px !important; }:not(#tve) [data-css=\"tve-u-168c2bd26ed\"] { color: rgb(10, 0, 0) !important; }[data-css=\"tve-u-168c2be1fa7\"] { margin-top: 0px !important; margin-bottom: 0px !important; }[data-css=\"tve-u-168c2c00ee7\"] .tcb-button-link { border-color: rgb(255, 255, 255); padding: 14px 22px; border-radius: 10px; overflow: hidden; background-image: none !important; background-color: rgb(46, 26, 188) !important; }:not(#tve) [data-css=\"tve-u-168c2c00ee7\"]:hover .tcb-button-link { background-color: rgb(40, 21, 162) !important; }:not(#tve) [data-css=\"tve-u-168c2c00ee7\"] .tcb-button-link { line-height: 1.2em; font-size: 24px; }[data-css=\"tve-u-168c2c00ee7\"] { margin-top: 0px !important; margin-bottom: 0px !important; }[data-css=\"tve-u-168c2c12904\"] p { margin: 0px 0px 11px !important; padding: 0px !important; }:not(#tve) [data-css=\"tve-u-168c2c12906\"] { color: rgb(10, 0, 0) !important; }[data-css=\"tve-u-168c2c17fe3\"] { margin-top: 10px !important; margin-bottom: 0px !important; }[data-css=\"tve-u-168c2c47cb4\"] p { margin: 0px 0px 11px !important; padding: 0px !important; }:not(#tve) [data-css=\"tve-u-168c2c47cb6\"] { color: rgb(10, 0, 0) !important; }[data-css=\"tve-u-168c2c607e9\"] { margin-top: 0px !important; margin-bottom: 0px !important; }[data-css=\"tve-u-168c2caaaa5\"] { clip-path: url(\"#clip-bottom-709a10134391c\"); -webkit-clip-path: url(\"#clip-bottom-709a10134391c\");  border-radius: 10px; overflow: hidden; border: none !important; background-color: rgb(155, 10, 124) !important; }:not(#tve) [data-css=\"tve-u-168c2caaaa7\"] { color: rgb(251, 247, 247) !important; }[data-css=\"tve-u-168c2caaaa9\"] p { margin: 0px 0px 12px !important; padding: 0px !important; }:not(#tve) .thrv-content-box [data-css=\"tve-u-168c2caaaa9\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-168c2caaaa9\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-168c2caaaa9\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-168c2caaaa9\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-168c2caaaa9\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-168c2caaaa9\"] label { font-size: 20px; }[data-css=\"tve-u-168c2caaaaa\"] { max-width: 584px; float: none; margin: 0px auto !important; }[data-css=\"tve-u-168c2cd0c39\"] p { margin: 0px 0px 11px !important; padding: 0px !important; }:not(#tve) [data-css=\"tve-u-168c2cd0c3b\"] { color: rgb(10, 0, 0) !important; }[data-css=\"tve-u-168c2ce7340\"] { margin-top: 10px !important; margin-bottom: 0px !important; }[data-css=\"tve-u-168c2cf4c66\"] p { margin: 0px 0px 11px !important; padding: 0px !important; }:not(#tve) [data-css=\"tve-u-168c2cf4c67\"] { color: rgb(10, 0, 0) !important; }[data-css=\"tve-u-168c2cfc341\"] { margin-top: 0px !important; margin-bottom: 0px !important; }[data-css=\"tve-u-168c2d02773\"] { clip-path: url(\"#clip-bottom-c2b17364c8638\"); -webkit-clip-path: url(\"#clip-bottom-c2b17364c8638\");  border-radius: 10px; overflow: hidden; border: none !important; background-color: rgb(11, 63, 6) !important; }:not(#tve) [data-css=\"tve-u-168c2d02774\"] { color: rgb(251, 247, 247) !important; }[data-css=\"tve-u-168c2d02776\"] p { margin: 0px 0px 12px !important; padding: 0px !important; }:not(#tve) .thrv-content-box [data-css=\"tve-u-168c2d02776\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-168c2d02776\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-168c2d02776\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-168c2d02776\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-168c2d02776\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-168c2d02776\"] label { font-size: 20px; }[data-css=\"tve-u-168c2d02777\"] { max-width: 526px; float: none; margin: 0px auto !important; }[data-css=\"tve-u-168c2d2601b\"] p { margin: 0px 0px 11px !important; padding: 0px !important; }:not(#tve) [data-css=\"tve-u-168c2d2601c\"] { color: rgb(10, 0, 0) !important; }[data-css=\"tve-u-168c2d3d381\"] { margin-top: 10px !important; margin-bottom: 0px !important; }[data-css=\"tve-u-168c2d543b7\"] p { margin: 0px 0px 11px !important; padding: 0px !important; }:not(#tve) [data-css=\"tve-u-168c2d543b8\"] { color: rgb(10, 0, 0) !important; }[data-css=\"tve-u-168c2d5dc81\"] { margin-top: 0px !important; margin-bottom: 0px !important; }[data-css=\"tve-u-168c2d61f3f\"] { clip-path: url(\"#clip-bottom-991244c68325e\"); -webkit-clip-path: url(\"#clip-bottom-991244c68325e\");  border-radius: 10px; overflow: hidden; border: none !important; background-color: rgb(242, 140, 17) !important; }:not(#tve) [data-css=\"tve-u-168c2d61f41\"] { color: rgb(251, 247, 247) !important; }[data-css=\"tve-u-168c2d61f42\"] p { margin: 0px 0px 12px !important; padding: 0px !important; }:not(#tve) .thrv-content-box [data-css=\"tve-u-168c2d61f42\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-168c2d61f42\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-168c2d61f42\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-168c2d61f42\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-168c2d61f42\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-168c2d61f42\"] label { font-size: 20px; }[data-css=\"tve-u-168c2d61f44\"] { max-width: 284px; float: none; margin: 0px auto !important; }[data-css=\"tve-u-168c2d8487d\"] p { margin: 0px 0px 11px !important; padding: 0px !important; }:not(#tve) [data-css=\"tve-u-168c2d8487f\"] { color: rgb(10, 0, 0) !important; }[data-css=\"tve-u-168c2d924c9\"] { margin-top: 10px !important; margin-bottom: 0px !important; }[data-css=\"tve-u-168c2d9a8d6\"] { float: none; margin: 0px auto !important; }:not(#tve) [data-css=\"tve-u-16b842270a1\"] .tcb-button-link { line-height: 1.2em; font-size: 32px; }[data-css=\"tve-u-16b842270a1\"] .tcb-button-link { padding: 18px 30px; border-radius: 10px; overflow: hidden; background-image: none !important; background-color: rgb(241, 12, 12) !important; }:not(#tve) [data-css=\"tve-u-16b842270a1\"]:hover .tcb-button-link { background-color: rgb(215, 12, 9) !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; }:not(#tve) .thrv-content-box [data-css=\"tve-u-168c2b09983\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-168c2b09983\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-168c2b09983\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-168c2b09983\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-168c2b09983\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-168c2b09983\"] label { font-size: var(--tve-font-size, 20px); }[data-css=\"tve-u-168c2b09983\"] { --tve-font-size: 20px; }:not(#tve) .thrv-content-box [data-css=\"tve-u-168c2b86786\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-168c2b86786\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-168c2b86786\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-168c2b86786\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-168c2b86786\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-168c2b86786\"] label { font-size: var(--tve-font-size, 20px); }[data-css=\"tve-u-168c2b86786\"] { --tve-font-size: 20px; }:not(#tve) [data-css=\"tve-u-168c2bc8e59\"] li { font-size: var(--tve-font-size, 20px) !important; }:not(#tve) .thrv-content-box [data-css=\"tve-u-168c2bd26ec\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-168c2bd26ec\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-168c2bd26ec\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-168c2bd26ec\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-168c2bd26ec\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-168c2bd26ec\"] label { font-size: var(--tve-font-size, 20px); }[data-css=\"tve-u-168c2bd26ec\"] { --tve-font-size: 20px; }:not(#tve) .thrv-content-box [data-css=\"tve-u-168c2c12904\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-168c2c12904\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-168c2c12904\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-168c2c12904\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-168c2c12904\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-168c2c12904\"] label { font-size: var(--tve-font-size, 20px); }[data-css=\"tve-u-168c2c12904\"] { --tve-font-size: 20px; }:not(#tve) .thrv-content-box [data-css=\"tve-u-168c2c47cb4\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-168c2c47cb4\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-168c2c47cb4\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-168c2c47cb4\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-168c2c47cb4\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-168c2c47cb4\"] label { font-size: var(--tve-font-size, 20px); }[data-css=\"tve-u-168c2c47cb4\"] { --tve-font-size: 20px; }:not(#tve) .thrv-content-box [data-css=\"tve-u-168c2cd0c39\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-168c2cd0c39\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-168c2cd0c39\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-168c2cd0c39\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-168c2cd0c39\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-168c2cd0c39\"] label { font-size: var(--tve-font-size, 20px); }[data-css=\"tve-u-168c2cd0c39\"] { --tve-font-size: 20px; }:not(#tve) .thrv-content-box [data-css=\"tve-u-168c2cf4c66\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-168c2cf4c66\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-168c2cf4c66\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-168c2cf4c66\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-168c2cf4c66\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-168c2cf4c66\"] label { font-size: var(--tve-font-size, 20px); }[data-css=\"tve-u-168c2cf4c66\"] { --tve-font-size: 20px; }:not(#tve) .thrv-content-box [data-css=\"tve-u-168c2d2601b\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-168c2d2601b\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-168c2d2601b\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-168c2d2601b\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-168c2d2601b\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-168c2d2601b\"] label { font-size: var(--tve-font-size, 20px); }[data-css=\"tve-u-168c2d2601b\"] { --tve-font-size: 20px; }:not(#tve) .thrv-content-box [data-css=\"tve-u-168c2d543b7\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-168c2d543b7\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-168c2d543b7\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-168c2d543b7\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-168c2d543b7\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-168c2d543b7\"] label { font-size: var(--tve-font-size, 20px); }[data-css=\"tve-u-168c2d543b7\"] { --tve-font-size: 20px; }:not(#tve) .thrv-content-box [data-css=\"tve-u-168c2d8487d\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-168c2d8487d\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-168c2d8487d\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-168c2d8487d\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-168c2d8487d\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-168c2d8487d\"] label { font-size: var(--tve-font-size, 20px); }[data-css=\"tve-u-168c2d8487d\"] { --tve-font-size: 20px; }:not(#tve) .thrv-content-box [data-css=\"tve-u-19586e806a0\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-19586e806a0\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-19586e806a0\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-19586e806a0\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-19586e806a0\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-19586e806a0\"] label { font-size: var(--tve-font-size,20px); }[data-css=\"tve-u-19586e806a0\"] { --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-19586e806a0\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-19586e806a0\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-19586e806a0\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-19586e806a0\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-19586e806a0\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-19586e806a0\"] label, :not(#tve) .thrv-content-box [data-css=\"tve-u-19586e806a0\"] h1, :not(#tve) .thrv-content-box [data-css=\"tve-u-19586e806a0\"] h2, :not(#tve) .thrv-content-box [data-css=\"tve-u-19586e806a0\"] h3, :not(#tve) .thrv-content-box [data-css=\"tve-u-19586e806a0\"] h4, :not(#tve) .thrv-content-box [data-css=\"tve-u-19586e806a0\"] h5, :not(#tve) .thrv-content-box [data-css=\"tve-u-19586e806a0\"] 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-19586e806a0\"] p { padding: 0px 0px 11px !important; margin: 0px !important; }[data-css=\"tve-u-19586e806a1\"] { margin-top: 0px !important; margin-bottom: 10px !important; }:not(#tve) .thrv-content-box [data-css=\"tve-u-19586e81f73\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-19586e81f73\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-19586e81f73\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-19586e81f73\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-19586e81f73\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-19586e81f73\"] label { font-size: var(--tve-font-size,20px); }[data-css=\"tve-u-19586e81f73\"] { --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-19586e81f73\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-19586e81f73\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-19586e81f73\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-19586e81f73\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-19586e81f73\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-19586e81f73\"] label, :not(#tve) .thrv-content-box [data-css=\"tve-u-19586e81f73\"] h1, :not(#tve) .thrv-content-box [data-css=\"tve-u-19586e81f73\"] h2, :not(#tve) .thrv-content-box [data-css=\"tve-u-19586e81f73\"] h3, :not(#tve) .thrv-content-box [data-css=\"tve-u-19586e81f73\"] h4, :not(#tve) .thrv-content-box [data-css=\"tve-u-19586e81f73\"] h5, :not(#tve) .thrv-content-box [data-css=\"tve-u-19586e81f73\"] 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-19586e81f73\"] p { padding: 0px 0px 11px !important; margin: 0px !important; }[data-css=\"tve-u-19586e81f74\"] { margin-top: 20px !important; margin-bottom: 20px !important; padding: 0px !important; }[data-css=\"tve-u-19586e81f75\"] { --tcb-text-highlight-color: rgb(237, 243, 13) !important; }[data-css=\"tve-u-19586e81f76\"] { --tcb-text-highlight-color: rgb(237, 243, 13) !important; }[data-css=\"tve-u-19586e81f77\"] { --tve-highlight-background: url(\"data:image\/svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%20314%20114%22%20preserveAspectRatio%3D'none'%3E%0A%09%09%09%09%09%3Cpath%20d%3D%22M149.412%202.398C98.053%204.579%2074.996%207.562%2053.903%2014.754%2028.892%2023.283%208.503%2040.617%202.929%2058.09c-4.148%2013.004-.464%2026.402%2010.207%2037.118%205.664%205.687%2015.228%2012.328%2021.753%2015.104%202.939%201.25%208.598%202.708%2010.559%202.72%201.16.008%201.111-.129-.909-2.543-2.554-3.05-4.753-7.567-4.761-9.775-.008-2.502%202.482-6.937%204.862-8.661%205.613-4.066%2020.333-6.115%2050.607-7.046%2012.81-.394%2019.622.068%2047.623%203.231%2057%206.439%2066.925%207.222%2091.845%207.248%2016.516.016%2020.951-.139%2026.167-.919%2020.12-3.007%2032.633-8.401%2041.489-17.883%206.859-7.344%2010.154-16.516%2010.254-28.537.032-3.902-.231-7.704-.651-9.42-5.257-21.464-31.961-33.668-80.137-36.622-11.85-.727-62.651-.546-82.425.293%22%2F%3E%0A%09%09%09%09%3C%2Fsvg%3E\"); --tcb-text-highlight-color: #2ABB61 !important; }[data-css=\"tve-u-19586e81f78\"] { --tcb-text-highlight-color: rgb(30, 184, 76) !important; }[data-css=\"tve-u-19586e81f79\"] { --tcb-text-highlight-color: transparent !important; }}@media (max-width: 1023px){:not(#tve) [data-css=\"tve-u-16b842a1609\"] { font-size: 30px !important; }}@media (max-width: 767px){:not(#tve) [data-css=\"tve-u-16b842a1609\"] { font-size: 17px !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":[1],"tags":[6118,5991,5992],"class_list":["post-40861","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-y-contabilidad","tag-formulas-hoja-resumen","tag-hoja-resumen","tag-resumen-de-tu-app-fi","post-wrapper","thrv_wrapper"],"_links":{"self":[{"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/posts\/40861","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=40861"}],"version-history":[{"count":0,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/posts\/40861\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/media\/40867"}],"wp:attachment":[{"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/media?parent=40861"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/categories?post=40861"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/tags?post=40861"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}