{"product_id":"planilha-de-fretes-fracionados-por-faixas-de-cep","title":"Planilha de Cálculo de Fretes Fracionados por Faixas de Cep em Excel 5.0","description":"\u003cp style=\"text-align: justify;\"\u003e\u003cspan style=\"font-size: 12pt;\"\u003eA Planilha de Cálculo para Fretes Fracionados por faixas de CEP é única no mercado, só a Visual tem esse tipo de Planilha, ela é perfeita para calcular os valores de Fretes que envolvem faixas de peso diferentes por CEP - Ideal tanto para empresas de transportes que precisam cobrar o frete corretamente de seus clientes quanto para empresas em geral que precisam conferir o frete de sua mercadoria. Confira abaixo sua funcionalidade:\u003c\/span\u003e\u003c\/p\u003e\u003ch3 class=\"spr-header-title\"\u003e\u003cspan style=\"color: #3366ff;\"\u003e\u003cspan style=\"color: #6699ff;\"\u003e\u003cspan style=\"color: #5b9bd5;\"\u003eCadastro de cliente\u003c\/span\u003e\u003c\/span\u003e\u003c\/span\u003e\u003c\/h3\u003e\u003cp style=\"font-size: 14px; font-weight: 400;\"\u003e\u003cspan style=\"font-size: 12pt;\"\u003eCadastre todos os seus clientes, atribua um código a eles e insira todos os seus dados.\u003c\/span\u003e\u003c\/p\u003e\u003ch3 class=\"spr-header-title\"\u003e\u003cspan style=\"color: #3366ff;\"\u003e\u003cspan style=\"color: #6699ff;\"\u003e\u003cspan style=\"color: #5b9bd5;\"\u003eCadastro de Configurações por Estado\u003c\/span\u003e\u003c\/span\u003e\u003c\/span\u003e\u003c\/h3\u003e\u003cp style=\"text-align: justify;\"\u003e\u003cspan style=\"font-size: 12pt;\"\u003eCom essa planilha você pode cadastrar por Estado as configurações de impostos e outros valores agregados ao frete.\u003c\/span\u003e\u003c\/p\u003e\u003ch3 class=\"spr-header-title\"\u003e\u003cspan style=\"color: #3366ff;\"\u003e\u003cspan style=\"color: #6699ff;\"\u003e\u003cspan style=\"color: #5b9bd5;\"\u003eTabela de CEP \u003c\/span\u003e\u003c\/span\u003e\u003c\/span\u003e\u003c\/h3\u003e\u003cp style=\"text-align: justify;\"\u003e\u003cspan style=\"font-size: 12pt;\"\u003eA Planilha possui em sua base de dados mais de um milhão de Cep's cadastrados - está totalmente atualizada, mas você também está livre para cadastrar sempre que surgir um Cep novo.\u003c\/span\u003e\u003c\/p\u003e\u003ch3 class=\"spr-header-title\"\u003e\u003cspan style=\"color: #3366ff;\"\u003e\u003cspan style=\"color: #6699ff;\"\u003e\u003cspan style=\"color: #5b9bd5;\"\u003eTabela de Frete\u003c\/span\u003e\u003c\/span\u003e\u003c\/span\u003e\u003c\/h3\u003e\u003cp style=\"text-align: justify;\"\u003e\u003cspan style=\"font-size: 12pt;\"\u003eConfigure as faixas de CEP que você vai trabalhar, pode ser por estado, região ou cidades - quem define isso é você, configure também as faixas de peso e atribua um valor de frete peso a cada uma delas, insira frete valor e outras taxas também se necessário.\u003c\/span\u003e\u003c\/p\u003e\u003ch3 class=\"spr-header-title\"\u003e\u003cspan style=\"color: #3366ff;\"\u003e\u003cspan style=\"color: #6699ff;\"\u003e\u003cspan style=\"color: #5b9bd5;\"\u003eCálculo do Frete Fracionado\u003c\/span\u003e\u003c\/span\u003e\u003c\/span\u003e\u003c\/h3\u003e\u003cp style=\"color: #000000; font-size: 14px; font-weight: 400;\"\u003e\u003cspan style=\"font-size: 12pt;\"\u003eDepois que todas as configurações de dados estiverem inseridas na planilha – vem a melhor parte de nosso trabalho, aqui vão três etapas que irão usar muito e é muito fácil de fazer.\u003c\/span\u003e\u003c\/p\u003e\u003cp style=\"color: #000000; font-size: 14px; font-weight: 400;\"\u003e\u003cspan style=\"font-size: 12pt;\"\u003e1º aqui você vai informar o Cep , então qualquer valor entre a primeira e última faixa de peso cadastrada anteriormente você pode colocar; bastando apenas digitar.\u003c\/span\u003e\u003c\/p\u003e\u003cp style=\"color: #000000; font-size: 14px; font-weight: 400;\"\u003e\u003cspan style=\"font-size: 12pt;\"\u003e2º você vai informar o valor da mercadoria, simples, apenas isso!\u003c\/span\u003e\u003c\/p\u003e\u003cp style=\"color: #000000; font-size: 14px; font-weight: 400;\"\u003e\u003cspan style=\"font-size: 12pt;\"\u003e3º você informar o peso da mercadoria.\u003c\/span\u003e\u003c\/p\u003e\u003cp style=\"color: #000000; font-size: 14px; font-weight: 400;\"\u003e\u003cspan style=\"color: #3366ff;\"\u003e\u003cspan style=\"color: #6699ff;\"\u003e\u003cspan style=\"color: #5b9bd5;\"\u003e\u003cspan style=\"font-size: 12pt;\"\u003e\u003cspan style=\"color: #000000;\"\u003eCom as informações acima você terá o valor do frete fracionado.\u003c\/span\u003e\u003c\/span\u003e\u003c\/span\u003e\u003c\/span\u003e\u003c\/span\u003e\u003c\/p\u003e\u003ch3 class=\"spr-header-title\"\u003e\u003cspan style=\"color: #3366ff;\"\u003e\u003cspan style=\"color: #6699ff;\"\u003e\u003cspan style=\"color: #5b9bd5;\"\u003eLançamento de fretes cubado\u003c\/span\u003e\u003c\/span\u003e\u003c\/span\u003e\u003c\/h3\u003e\u003cp style=\"font-size: 14px; font-weight: 400;\"\u003e\u003cspan style=\"font-size: 12pt;\"\u003eA planilha proporciona a função de fretes cubados, ou seja, ela está preparada para calcular as dimensões dos volumes (m³) quando esse ultrapassar o peso frete.\u003c\/span\u003e\u003c\/p\u003e\u003ch3 class=\"spr-header-title\"\u003e\u003cspan style=\"color: #3366ff;\"\u003e\u003cspan style=\"color: #6699ff;\"\u003e\u003cspan style=\"color: #5b9bd5;\"\u003eOrçamento de Frete\u003c\/span\u003e\u003c\/span\u003e\u003c\/span\u003e\u003c\/h3\u003e\u003cp style=\"font-size: 14px; font-weight: 400;\"\u003e\u003cspan style=\"font-size: 12pt;\"\u003eEnvie orçamentos para seus clientes, imprima ou gere um PDF e envie por e-mail.\u003c\/span\u003e\u003c\/p\u003e\u003ch3 class=\"spr-header-title\"\u003e\u003cspan style=\"color: #3366ff;\"\u003e\u003cspan style=\"color: #6699ff;\"\u003e\u003cspan style=\"color: #5b9bd5;\"\u003eOrdem de Coleta\u003c\/span\u003e\u003c\/span\u003e\u003c\/span\u003e\u003c\/h3\u003e\u003cp style=\"font-size: 14px; font-weight: 400;\"\u003e\u003cspan style=\"font-size: 12pt;\"\u003eVocê também pode gerar ordem coleta a partir dos fretes cotados, imprima ou gere um PDF e envie por e-mail.\u003c\/span\u003e\u003c\/p\u003e\u003cp style=\"font-size: 14px; font-weight: 400;\"\u003e \u003c\/p\u003e\u003cp style=\"text-align: justify;\"\u003e\u003cspan style=\"font-size: 12pt;\"\u003e\u003cspan style=\"font-size: 12pt;\"\u003e\u003cspan style=\"text-decoration: underline;\"\u003e\u003cspan style=\"color: #000000; text-decoration: underline;\"\u003eDeseja falar conosco ao vivo? é só clicar\u003c\/span\u003e\u003c\/span\u003e \u003cstrong\u003e\u003cspan style=\"color: #ff0000;\"\u003e\u003ca style=\"color: #ff0000;\" href=\"https:\/\/tawk.to\/chat\/594bc23ce9c6d324a4736cb9\/default\" target=\"_blank\" rel=\"noopener noreferrer\"\u003eaqui!\u003c\/a\u003e\u003c\/span\u003e\u003c\/strong\u003e\u003c\/span\u003e\u003c\/span\u003e\u003c\/p\u003e\u003cp style=\"text-align: justify;\"\u003e \u003c\/p\u003e\u003cp style=\"text-align: justify;\"\u003e\u003cspan style=\"font-size: 12pt;\"\u003e\u003cspan style=\"font-size: 12pt;\"\u003e\u003cstrong\u003e\u003cspan style=\"color: #ff0000;\"\u003e\u003cspan style=\"font-size: 12pt;\"\u003e\u003cspan style=\"font-size: 12pt;\"\u003e\u003cstrong\u003e\u003cspan style=\"color: #ff0000;\"\u003e\u003cspan style=\"font-size: 18px;\"\u003e\u003cstrong\u003e\u003cspan style=\"color: #b22222;\"\u003e→ Para um melhor funcionamento da planilha recomendamos utilizar Office 2013 em diante\u003c\/span\u003e\u003c\/strong\u003e\u003c\/span\u003e\u003c\/span\u003e\u003c\/strong\u003e\u003c\/span\u003e\u003c\/span\u003e\u003c\/span\u003e\u003c\/strong\u003e\u003c\/span\u003e\u003c\/span\u003e\u003c\/p\u003e\u003cp style=\"text-align: justify;\"\u003e \u003c\/p\u003e\u003cp style=\"text-align: justify;\"\u003e\u003cspan style=\"font-size: 12pt;\"\u003e\u003cspan style=\"font-size: 12pt;\"\u003e\u003cstrong style=\"font-size: 18px;\"\u003e\u003cspan style=\"color: #b22222;\"\u003e\u003cstrong\u003e\u003cstrong\u003e\u003cstrong\u003e\u003cstrong\u003e\u003cspan style=\"color: #000080;\"\u003eAssista ao vídeo de atualização da planilha para entender suas mudanças na versão 5.0 - Bem como a todos os outros vídeos da série:\u003c\/span\u003e\u003c\/strong\u003e\u003c\/strong\u003e\u003c\/strong\u003e\u003c\/strong\u003e\u003c\/span\u003e\u003c\/strong\u003e\u003c\/span\u003e\u003c\/span\u003e\u003c\/p\u003e\u003cp style=\"text-align: justify;\"\u003e \u003c\/p\u003e\u003cp style=\"text-align: justify;\"\u003e \u003ciframe src=\"\/\/www.youtube.com\/embed\/u5TdsHdB4h0\" width=\"560\" height=\"314\" allowfullscreen=\"allowfullscreen\"\u003e\u003c\/iframe\u003e\u003c\/p\u003e\u003cp style=\"text-align: justify;\"\u003e\u003ciframe src=\"\/\/www.youtube.com\/embed\/G_vWf8hmTJ4\" width=\"560\" height=\"314\" allowfullscreen=\"allowfullscreen\"\u003e\u003c\/iframe\u003e\u003c\/p\u003e\u003cp style=\"text-align: justify;\"\u003e\u003ciframe src=\"\/\/www.youtube.com\/embed\/iOzC8e_y29g\" width=\"560\" height=\"314\" allowfullscreen=\"allowfullscreen\"\u003e\u003c\/iframe\u003e\u003c\/p\u003e\u003cp style=\"text-align: justify;\"\u003e\u003ciframe src=\"\/\/www.youtube.com\/embed\/6oSGGX6mYJw\" width=\"560\" height=\"314\" allowfullscreen=\"allowfullscreen\"\u003e\u003c\/iframe\u003e\u003c\/p\u003e\u003cp style=\"text-align: justify;\"\u003e\u003ciframe src=\"\/\/www.youtube.com\/embed\/6irj-8FQ2J0\" width=\"560\" height=\"314\" allowfullscreen=\"allowfullscreen\"\u003e\u003c\/iframe\u003e\u003c\/p\u003e\u003cp style=\"text-align: justify;\"\u003e \u003c\/p\u003e","brand":"VIZUAL PLANILHAS","offers":[{"title":"Default Title","offer_id":35647905267874,"sku":"","price":280.0,"currency_code":"PLN","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0458\/0904\/1570\/products\/PzXCt6CWFi.jpg?v=1597227803","url":"https:\/\/luzdiuwi-vc.myshopify.com\/products\/planilha-de-fretes-fracionados-por-faixas-de-cep","provider":"luzdiuwi.vc","version":"1.0","type":"link"}