{"id":3675,"date":"2022-10-05T12:54:33","date_gmt":"2022-10-05T15:54:33","guid":{"rendered":"https:\/\/pacotedeplanilhas.com\/loja\/?post_type=product&#038;p=3675"},"modified":"2022-12-01T01:34:52","modified_gmt":"2022-12-01T04:34:52","slug":"cotacao-de-precos","status":"publish","type":"product","link":"https:\/\/pacotedeplanilhas.com\/loja\/store\/planilhas-em-excel\/cotacao-de-precos\/","title":{"rendered":"Planilha Dashboard Cota\u00e7\u00e3o de pre\u00e7os"},"content":{"rendered":"<p>Planilha Dashboard em excel &#8211; Cota\u00e7\u00e3o de pre\u00e7os com indicadores de maior e menor pre\u00e7o autom\u00e1ticos.<\/p>\n<p>&#8211; Planilha com resumo dos lan\u00e7amentos: Valor total, menor valor de pedido, % de disponibilidade de itens e valor l\u00edquido e valor bruto;<\/p>\n<p>&#8211; Sinalizador autom\u00e1tico de qual o menor pre\u00e7o entre os fornecedores;<\/p>\n<p>&#8211; Lan\u00e7amento de desconto e frete;<\/p>\n<p>&#8211; Lan\u00e7amento do Diferencial de Al\u00edquota;<\/p>\n<p>&#8211; Base de dados com informa\u00e7\u00f5es sobre as cota\u00e7\u00f5es;<\/p>\n<p>&#8211; Base de dados de fornecedores, cidade do fornecedor, tipo de entrega, formas de pagamento e contato;<\/p>\n<p>&#8211; Dashboard din\u00e2mico em Excel com informa\u00e7\u00f5es sobre valores gastos nas cota\u00e7\u00f5es, quantidades de cota\u00e7\u00f5es e outros;<\/p>\n<p>&#8211; Planilha 100% edit\u00e1vel &#8211; 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>&nbsp;<\/p>\n<div class=\"ast-oembed-container \" style=\"height: 100%;\"><iframe title=\"Planilha dashboard de Cota\u00e7\u00e3o de pre\u00e7os\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/JqPivRi0S0A?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>Desenvolvida em Excel Avan\u00e7ado, foi idealizada para calcular o consumo de combust\u00edvel dos ve\u00edculos. Pode ser utilizado para qualquer ve\u00edculo como carros, motos e caminh\u00f5es.<\/p>\n<p>Muito simples de se utilizar, basta preencher na planilha a quantidade de litros abastecidos. Depois disto, a planilha faz os c\u00e1lculos automaticamente do consumo m\u00e9dio dos ve\u00edculos da empresa e do tanque de combust\u00edvel da empresa.<\/p>\n","protected":false},"featured_media":3676,"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":[120],"product_tag":[295,289,290,292,294,293,291],"class_list":{"0":"post-3675","1":"product","2":"type-product","3":"status-publish","4":"has-post-thumbnail","6":"product_cat-planilhas-em-excel","7":"product_tag-como-cotar-precos-no-excel","8":"product_tag-cotacao-de-precos","9":"product_tag-cotacao-de-precos-em-excel","10":"product_tag-dashbaord-cotacao-de-precos","11":"product_tag-dashboard-cotacoes","12":"product_tag-ferramenta-de-cotacao-de-precos","13":"product_tag-planilha-para-cotacao-de-precos","14":"desktop-align-left","15":"tablet-align-left","16":"mobile-align-left","18":"first","19":"instock","20":"shipping-taxable","21":"purchasable","22":"product-type-simple"},"_links":{"self":[{"href":"https:\/\/pacotedeplanilhas.com\/loja\/wp-json\/wp\/v2\/product\/3675","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=3675"}],"version-history":[{"count":1,"href":"https:\/\/pacotedeplanilhas.com\/loja\/wp-json\/wp\/v2\/product\/3675\/revisions"}],"predecessor-version":[{"id":3680,"href":"https:\/\/pacotedeplanilhas.com\/loja\/wp-json\/wp\/v2\/product\/3675\/revisions\/3680"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/pacotedeplanilhas.com\/loja\/wp-json\/wp\/v2\/media\/3676"}],"wp:attachment":[{"href":"https:\/\/pacotedeplanilhas.com\/loja\/wp-json\/wp\/v2\/media?parent=3675"}],"wp:term":[{"taxonomy":"product_brand","embeddable":true,"href":"https:\/\/pacotedeplanilhas.com\/loja\/wp-json\/wp\/v2\/product_brand?post=3675"},{"taxonomy":"product_cat","embeddable":true,"href":"https:\/\/pacotedeplanilhas.com\/loja\/wp-json\/wp\/v2\/product_cat?post=3675"},{"taxonomy":"product_tag","embeddable":true,"href":"https:\/\/pacotedeplanilhas.com\/loja\/wp-json\/wp\/v2\/product_tag?post=3675"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}