{"id":5178,"date":"2024-05-19T17:57:45","date_gmt":"2024-05-19T20:57:45","guid":{"rendered":"https:\/\/pacotedeplanilhas.com\/loja\/?post_type=product&#038;p=5178"},"modified":"2024-07-17T21:37:56","modified_gmt":"2024-07-18T00:37:56","slug":"planilha-dashboard-logistica","status":"publish","type":"product","link":"https:\/\/pacotedeplanilhas.com\/loja\/store\/logistica\/planilha-dashboard-logistica\/","title":{"rendered":"Planilha Dashboard Controle Log\u00edstica"},"content":{"rendered":"<p>FA\u00c7A O CONTROLE E ACOMPANHAMENTO DE LOG\u00cdSTICA DA SUA EMPRESA DE MANEIRA SIMPLES E R\u00c1PIDA.<\/p>\n<p>Funcionalidades<\/p>\n<p>Lan\u00e7amentos:<\/p>\n<p>\u2013Empresa\/filial, cliente, tipo carga, rota, valor mercadoria, total peso, vendedor, data doc fiscal, valor compra frete, total venda, sub &#8211; total, total operacional, margem operacional, margem 2, meta;<\/p>\n<p>Meta Vendedores:<\/p>\n<p>\u2013Maycon R$1.250,00, Rafael Sanfelice R$1.250,00, Patricia R$250.000, Juliano Viera R$150.000, Alef R$50,000;<\/p>\n<p>Dashboard 01<\/p>\n<p>Valores totais:<\/p>\n<p>\u2013Meta de faturamento, faturamento total, quantidade de pedidos, tranporte de carga solta, tranporte container;<\/p>\n<p>Gr\u00e1ficos:<\/p>\n<p>\u2013Meta de faturamento, faturamento di\u00e1rio, faturamento por vendedor, faturamento por empresa, clientes &#8211; top 10, tipo de ve\u00edculo;<\/p>\n<p>Os filtros em forma de Segmenta\u00e7\u00e3o de dados:<\/p>\n<p>\u2013 Data doc fiscal, empresa\/filial, vendedor, tipo de carga;<\/p>\n<p>Dashboard 02<\/p>\n<p>Valores totais:<\/p>\n<p>\u2013Meta de margem operacional, faturamento total, m\u00e9dia da margem operacional, vendedor em destaque faturamenti operacional, vendedor em destaque margem operacional;<\/p>\n<p>Gr\u00e1ficos:<\/p>\n<p>\u2013Meta margem operacional<span style=\"font-size: 16px;\">, faturamento operacional, faturamento operacional vendedor, margem operacional vendedor, clientes margem operacional &#8211; top 10, margem operacional;<\/span><\/p>\n<p>Os filtros em forma de Segmenta\u00e7\u00e3o de dados:<\/p>\n<p>\u2013Data doc fiscal, cliente, vendedor;<\/p>\n<p>Dashboard Vendedor<\/p>\n<p>Valores totais:<\/p>\n<p>\u2013Meta e faturamento da empresa, meta e faturamento de cada vendedor;<\/p>\n<p>Gr\u00e1ficos:<\/p>\n<p>\u2013Faturamento por vendedor, meta x realizado;<\/p>\n<p>Os filtros em forma de Segmenta\u00e7\u00e3o de dados:<\/p>\n<p>\u2013Vendedor, cliente, data doc fiscal;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>Planilha 100% edit\u00e1vel<\/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. Planilha 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 Log\u00edstico\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/nqxeCU4iTf0?feature=oembed\" 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 LOG\u00cdSTICA DA SUA EMPRESA DE MANEIRA SIMPLES E R\u00c1PIDA. Funcionalidades Lan\u00e7amentos: \u2013Empresa\/filial, cliente, tipo carga, rota, valor mercadoria, total peso, vendedor, data doc fiscal, valor compra frete, total venda, sub &#8211; total, total operacional, margem operacional, margem 2, meta; Meta Vendedores: \u2013Maycon R$1.250,00, Rafael Sanfelice R$1.250,00, Patricia R$250.000, Juliano [&hellip;]<\/p>\n","protected":false},"featured_media":5179,"comment_status":"open","ping_status":"closed","template":"","meta":{"site-sidebar-layout":"default","site-content-layout":"default","ast-site-content-layout":"","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":"default","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":[989,120],"product_tag":[665,666,443,739,748,124,740,747,668,738,744,657,742,743,745,559,741,746],"class_list":{"0":"post-5178","1":"product","2":"type-product","3":"status-publish","4":"has-post-thumbnail","6":"product_cat-logistica","7":"product_cat-planilhas-em-excel","8":"product_tag-analise-logistica","9":"product_tag-cadeia-de-suprimentos","10":"product_tag-controle-de-frota","11":"product_tag-controle-logistico","12":"product_tag-controle-total","13":"product_tag-dashboard","14":"product_tag-eficiencia-logistica","15":"product_tag-faturamento","16":"product_tag-gestao-de-transporte","17":"product_tag-gestao-logistica","18":"product_tag-indicadores-logisticos","19":"product_tag-logistica","20":"product_tag-monitoramento-de-entregas","21":"product_tag-otimizacao-logistica","22":"product_tag-performance-logistica","23":"product_tag-planilha","24":"product_tag-transporte","25":"product_tag-veiculos","26":"desktop-align-left","27":"tablet-align-left","28":"mobile-align-left","30":"first","31":"instock","32":"virtual","33":"purchasable","34":"product-type-simple"},"_links":{"self":[{"href":"https:\/\/pacotedeplanilhas.com\/loja\/wp-json\/wp\/v2\/product\/5178","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=5178"}],"version-history":[{"count":1,"href":"https:\/\/pacotedeplanilhas.com\/loja\/wp-json\/wp\/v2\/product\/5178\/revisions"}],"predecessor-version":[{"id":5185,"href":"https:\/\/pacotedeplanilhas.com\/loja\/wp-json\/wp\/v2\/product\/5178\/revisions\/5185"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/pacotedeplanilhas.com\/loja\/wp-json\/wp\/v2\/media\/5179"}],"wp:attachment":[{"href":"https:\/\/pacotedeplanilhas.com\/loja\/wp-json\/wp\/v2\/media?parent=5178"}],"wp:term":[{"taxonomy":"product_brand","embeddable":true,"href":"https:\/\/pacotedeplanilhas.com\/loja\/wp-json\/wp\/v2\/product_brand?post=5178"},{"taxonomy":"product_cat","embeddable":true,"href":"https:\/\/pacotedeplanilhas.com\/loja\/wp-json\/wp\/v2\/product_cat?post=5178"},{"taxonomy":"product_tag","embeddable":true,"href":"https:\/\/pacotedeplanilhas.com\/loja\/wp-json\/wp\/v2\/product_tag?post=5178"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}