{"id":7960,"date":"2026-06-03T19:50:28","date_gmt":"2026-06-03T22:50:28","guid":{"rendered":"https:\/\/pacotedeplanilhas.com\/loja\/?post_type=product&#038;p=7960"},"modified":"2026-06-03T20:27:34","modified_gmt":"2026-06-03T23:27:34","slug":"planilha-dashboard-controle-de-horas-extras-1-1","status":"publish","type":"product","link":"https:\/\/pacotedeplanilhas.com\/loja\/store\/planilhas-em-excel\/planilha-dashboard-controle-de-horas-extras-1-1\/","title":{"rendered":"Planilha Dashboard Controle de Horas Extras 1.1"},"content":{"rendered":"<p>FA\u00c7A O CONTROLE E ACOMPANHAMENTO DE HORAS EXTRAS DA SUA EMPRESA DE MANEIRA SIMPLES E R\u00c1PIDA.<\/p>\n<p>Funcionalidades:<\/p>\n<p>Lan\u00e7amentos<\/p>\n<p>C\u00e9lulas manuais em branco<\/p>\n<p>\u2013Data\/m\u00eas, funcion\u00e1rio, departamento, fun\u00e7\u00e3o, sal\u00e1rio base, carga hr mensal, valor da hora, quantidade de extra 50% m\u00eas, quantidade de extra 100% m\u00eas,<\/p>\n<p>C\u00e9lulas em cinza com preenchimento autom\u00e1tico<\/p>\n<p>\u2013Valor total a 50%, valor total 100%, quantidade geral, total geral, m\u00eas, ano;<\/p>\n<p>Dashboard<\/p>\n<p>Valores Totais<\/p>\n<p>\u2013Valor total H.E., quantidade total H.E., valor H.E. 50%, quantidade H.E 100%;<\/p>\n<p>Gr\u00e1ficos<\/p>\n<p>\u2013Valor gasto com H.E. por m\u00eas, quantidade de horas realizadas por m\u00eas, valor de H.E. por \u00e1rea, quantidade de H.E. por \u00e1rea, top 10 funcion\u00e1rios com mais H.E.;<\/p>\n<p>Filtros em forma de segmenta\u00e7\u00e3o de dados<\/p>\n<p>\u2013Ano, m\u00eas, departamento, funcion\u00e1rio, fun\u00e7\u00e3o;<\/p>\n<p>\u2013 Planilha 100% edit\u00e1vel \u2013 Apenas s\u00e3o bloqueadas as c\u00e9lulas das formulas, para garantir o funcionamento da automa\u00e7\u00e3o;<\/p>\n<p>PR\u00c9-REQUISITOS:<br \/>\nTer qualquer vers\u00e3o do EXCEL instalada no computador.<\/p>\n<p>VANTAGENS:<br \/>\nSimplicidade em usar e c\u00e1lculos precisos.<\/p>\n<p>INFORMA\u00c7\u00d5ES \u00daTEIS:<br \/>\nSuporte p\u00f3s-venda, via e-mail, para esclarecer quaisquer d\u00favidas que possam surgir.<br \/>\nPlanilha original, comercializada pelo pr\u00f3prio desenvolvedor.<\/p>\n<p>Video explicativo da planilha:<\/p>\n<div class=\"ast-oembed-container \" style=\"height: 100%;\"><iframe title=\"Planilha Dashboard Controle de Horas Extras 1.1\" width=\"500\" height=\"375\" src=\"https:\/\/www.youtube.com\/embed\/Zb7YZvTAYng?feature=oembed&#038;enablejsapi=1&#038;origin=https:\/\/pacotedeplanilhas.com\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe><\/div>\n","protected":false},"excerpt":{"rendered":"<p>FA\u00c7A O CONTROLE E ACOMPANHAMENTO DE HORAS EXTRAS DA SUA EMPRESA DE MANEIRA SIMPLES E R\u00c1PIDA.<\/p>\n","protected":false},"featured_media":7961,"comment_status":"open","ping_status":"closed","template":"","meta":{"site-sidebar-layout":"default","site-content-layout":"default","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"default","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"set","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}}},"product_brand":[],"product_cat":[120,990],"product_tag":[2124,2760,2765,2767,199,2762,2673,1523,2763,1324,2766,2764,2761,2460,2768],"class_list":{"0":"post-7960","1":"product","2":"type-product","3":"status-publish","4":"has-post-thumbnail","6":"product_cat-planilhas-em-excel","7":"product_cat-recursos-humanos","8":"product_tag-controle-de-funcionarios-excel","9":"product_tag-controle-de-horas-extras-excel","10":"product_tag-controle-jornada-de-trabalho-excel","11":"product_tag-custos-trabalhistas-excel","12":"product_tag-dashboard-departamento-pessoal","13":"product_tag-dashboard-horas-extras-excel","14":"product_tag-dashboard-rh-excel","15":"product_tag-excel-para-rh","16":"product_tag-gestao-de-horas-extras-excel","17":"product_tag-gestao-de-pessoas-excel","18":"product_tag-indicadores-rh-excel","19":"product_tag-planilha-departamento-pessoal","20":"product_tag-planilha-horas-extras-excel","21":"product_tag-planilha-recursos-humanos","22":"product_tag-produtividade-funcionarios-excel","23":"desktop-align-left","24":"tablet-align-left","25":"mobile-align-left","27":"first","28":"instock","29":"shipping-taxable","30":"product-type-grouped"},"_links":{"self":[{"href":"https:\/\/pacotedeplanilhas.com\/loja\/wp-json\/wp\/v2\/product\/7960","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pacotedeplanilhas.com\/loja\/wp-json\/wp\/v2\/product"}],"about":[{"href":"https:\/\/pacotedeplanilhas.com\/loja\/wp-json\/wp\/v2\/types\/product"}],"replies":[{"embeddable":true,"href":"https:\/\/pacotedeplanilhas.com\/loja\/wp-json\/wp\/v2\/comments?post=7960"}],"version-history":[{"count":2,"href":"https:\/\/pacotedeplanilhas.com\/loja\/wp-json\/wp\/v2\/product\/7960\/revisions"}],"predecessor-version":[{"id":7965,"href":"https:\/\/pacotedeplanilhas.com\/loja\/wp-json\/wp\/v2\/product\/7960\/revisions\/7965"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/pacotedeplanilhas.com\/loja\/wp-json\/wp\/v2\/media\/7961"}],"wp:attachment":[{"href":"https:\/\/pacotedeplanilhas.com\/loja\/wp-json\/wp\/v2\/media?parent=7960"}],"wp:term":[{"taxonomy":"product_brand","embeddable":true,"href":"https:\/\/pacotedeplanilhas.com\/loja\/wp-json\/wp\/v2\/product_brand?post=7960"},{"taxonomy":"product_cat","embeddable":true,"href":"https:\/\/pacotedeplanilhas.com\/loja\/wp-json\/wp\/v2\/product_cat?post=7960"},{"taxonomy":"product_tag","embeddable":true,"href":"https:\/\/pacotedeplanilhas.com\/loja\/wp-json\/wp\/v2\/product_tag?post=7960"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}