Baixe o app para aproveitar ainda mais
Esta é uma pré-visualização de arquivo. Entre para ver o arquivo original
Cadastro Número da Cotação 43219 www.tudoexcel.com.br Data 4/29/18 Empresa ASNX ENGENHARIA Fornecedores Contato Telefone OBS Casas Bahia Joana 11 0000-1111 Submarino José 11 0000-2222 Ponto Frio Maria 11 0000-3333 Ricardo Eletro Ricardo 11 0000-4444 Americanas Paulo 11 0000-5555 Quantidade Máxima de Itens por cotação = 100 Inserir Itens Analisar Imprimir Ajuda www.google.com Inserir Itens Planilha de Cotação de Preços Número 43219 Cadastro Análise Imprime Ajuda www.guiadecompra.com Empresa ASNX ENGENHARIA 4/29/18 Casas Bahia Submarino Ponto Frio Ricardo Eletro Americanas Joana 11 0000-1111 José 11 0000-2222 Maria 11 0000-3333 Ricardo 11 0000-4444 Paulo 11 0000-5555 Item Código do item Nome do produto QTDE Unid. Medida Preço 1 Unitário Preço 1 Total Preço 2 Unitário Preço 2 Total Preço 3 Unitario Preço 3 Total Preço 4 Unitário Preço 4 Total Preço 5 Unitário Preço 5 Total 1 CA-990A Item de Teste, pode apagar tudo que tem cabeçalho na cor branca 90000 CX R$ 20.00 R$ 1,800,000.00 R$ 19.80 R$ 1,782,000.00 R$ 22.00 R$ 1,980,000.00 R$ 19.80 R$ 1,782,000.00 R$ 20.00 R$ 1,800,000.00 2 Item 2 para teste o código é opcional 100 PC R$ 300.00 R$ 30,000.00 R$ 311.00 R$ 31,100.00 R$ 299.00 R$ 29,900.00 R$ 299.01 R$ 29,901.00 R$ 299.00 0.0 3 0.0 0.0 0.0 0.0 0.0 4 0.0 0.0 0.0 0.0 0.0 5 0.0 0.0 0.0 0.0 0.0 6 0.0 0.0 0.0 0.0 0.0 7 0.0 0.0 0.0 0.0 0.0 8 0.0 0.0 0.0 0.0 0.0 9 0.0 0.0 0.0 0.0 0.0 10 0.0 0.0 0.0 0.0 0.0 11 0.0 0.0 0.0 0.0 0.0 12 0.0 0.0 0.0 0.0 0.0 13 0.0 0.0 0.0 0.0 0.0 14 0.0 0.0 0.0 0.0 0.0 15 0.0 0.0 0.0 0.0 0.0 16 0.0 0.0 0.0 0.0 0.0 17 0.0 0.0 0.0 0.0 0.0 18 0.0 0.0 0.0 0.0 0.0 19 0.0 0.0 0.0 0.0 0.0 20 0.0 0.0 0.0 0.0 0.0 21 0.0 0.0 0.0 0.0 0.0 22 0.0 0.0 0.0 0.0 0.0 23 0.0 0.0 0.0 0.0 0.0 24 0.0 0.0 0.0 0.0 0.0 25 0.0 0.0 0.0 0.0 0.0 26 0.0 0.0 0.0 0.0 0.0 27 0.0 0.0 0.0 0.0 0.0 28 0.0 0.0 0.0 0.0 0.0 29 0.0 0.0 0.0 0.0 0.0 30 0.0 0.0 0.0 0.0 0.0 31 0.0 0.0 0.0 0.0 0.0 32 0.0 0.0 0.0 0.0 0.0 33 0.0 0.0 0.0 0.0 0.0 34 0.0 0.0 0.0 0.0 0.0 35 0.0 0.0 0.0 0.0 0.0 36 0.0 0.0 0.0 0.0 0.0 37 0.0 0.0 0.0 0.0 0.0 38 0.0 0.0 0.0 0.0 0.0 39 0.0 0.0 0.0 0.0 0.0 40 0.0 0.0 0.0 0.0 0.0 41 0.0 0.0 0.0 0.0 0.0 42 0.0 0.0 0.0 0.0 0.0 43 0.0 0.0 0.0 0.0 0.0 44 0.0 0.0 0.0 0.0 0.0 45 0.0 0.0 0.0 0.0 0.0 46 0.0 0.0 0.0 0.0 0.0 47 0.0 0.0 0.0 0.0 0.0 48 0.0 0.0 0.0 0.0 0.0 49 0.0 0.0 0.0 0.0 0.0 50 0.0 0.0 0.0 0.0 0.0 51 0.0 0.0 0.0 0.0 0.0 52 0.0 0.0 0.0 0.0 0.0 53 0.0 0.0 0.0 0.0 0.0 54 0.0 0.0 0.0 0.0 0.0 55 0.0 0.0 0.0 0.0 0.0 56 0.0 0.0 0.0 0.0 0.0 57 0.0 0.0 0.0 0.0 0.0 58 0.0 0.0 0.0 0.0 0.0 59 0.0 0.0 0.0 0.0 0.0 60 0.0 0.0 0.0 0.0 0.0 61 0.0 0.0 0.0 0.0 0.0 62 0.0 0.0 0.0 0.0 0.0 63 0.0 0.0 0.0 0.0 0.0 64 0.0 0.0 0.0 0.0 0.0 65 0.0 0.0 0.0 0.0 0.0 66 0.0 0.0 0.0 0.0 0.0 67 0.0 0.0 0.0 0.0 0.0 68 0.0 0.0 0.0 0.0 0.0 69 0.0 0.0 0.0 0.0 0.0 70 0.0 0.0 0.0 0.0 0.0 71 0.0 0.0 0.0 0.0 0.0 72 0.0 0.0 0.0 0.0 0.0 73 0.0 0.0 0.0 0.0 0.0 74 0.0 0.0 0.0 0.0 0.0 75 0.0 0.0 0.0 0.0 0.0 76 0.0 0.0 0.0 0.0 0.0 77 0.0 0.0 0.0 0.0 0.0 78 0.0 0.0 0.0 0.0 0.0 79 0.0 0.0 0.0 0.0 0.0 80 0.0 0.0 0.0 0.0 0.0 81 0.0 0.0 0.0 0.0 0.0 82 0.0 0.0 0.0 0.0 0.0 83 0.0 0.0 0.0 0.0 0.0 84 0.0 0.0 0.0 0.0 0.0 85 0.0 0.0 0.0 0.0 0.0 86 0.0 0.0 0.0 0.0 0.0 87 0.0 0.0 0.0 0.0 0.0 88 0.0 0.0 0.0 0.0 0.0 89 0.0 0.0 0.0 0.0 0.0 90 0.0 0.0 0.0 0.0 0.0 91 0.0 0.0 0.0 0.0 0.0 92 0.0 0.0 0.0 0.0 0.0 93 0.0 0.0 0.0 0.0 0.0 94 0.0 0.0 0.0 0.0 0.0 95 0.0 0.0 0.0 0.0 0.0 96 0.0 0.0 0.0 0.0 0.0 97 0.0 0.0 0.0 0.0 0.0 98 0.0 0.0 0.0 0.0 0.0 99 0.0 0.0 0.0 0.0 0.0 100 0.0 0.0 0.0 0.0 0.0 Fim da Cotação: funciona até 100 itens linha 105 www.guiadecompra.com Analise www.guiadecompra.com Número 11 0000-1111 11 0000-2222 11 0000-3333 11 0000-4444 11 0000-5555 Imprimir FILTRAR RESULTADOS Acer: Acer: Para filtrar os resultados desejados, deixe-os selecionados na caixa de seleção. Os resultados que não farão parte da sua análise, DESMARQUE-OS das caixas de seleção. Faça isso para visualizar apenas as células preenchidas com informações úteis na cotação 43219 Joana José Maria Ricardo Paulo Quem ganhou o item da linha item Código Descrição do Item QTDE Medida Casas Bahia Submarino Ponto Frio Ricardo Eletro Americanas 1 CA-990A CUTOS 1 TESTE 12 R$ 100.00 R$ 122.00 R$ 101.00 R$ 107.00 R$ 145.00 R$ 100.00 Casas Bahia 2 0 R$ 30.00 R$ 45.00 R$ 43.00 R$ 42.00 R$ 56.00 R$ 30.00 Casas Bahia 3 0 0 0 0.0 0.0 0.0 0.0 0.0 0.0 . 4 0 0 0 0.0 0.0 0.0 0.0 0.0 0.0 . 5 0 0 0 0.0 0.0 0.0 0.0 0.0 0.0 . 6 0 0 0 0.0 0.0 0.0 0.0 0.0 0.0 . 7 0 0 0 0.0 0.0 0.0 0.0 0.0 0.0 . 8 0 0 0 0.0 0.0 0.0 0.0 0.0 0.0 . 9 0 0 0 0.0 0.0 0.0 0.0 0.0 0.0 . 10 0 0 0 0.0 0.0 0.0 0.0 0.0 0.0 . 11 0 0 0 0.0 0.0 0.0 0.0 0.0 0.0 . 12 0 0 0 0.0 0.0 0.0 0.0 0.0 0.0 . 13 0 0 0 0.0 0.0 0.0 0.0 0.0 0.0 . 14 0 0 0 0.0 0.0 0.0 0.0 0.0 0.0 . 15 0 0 0 0.0 0.0 0.0 0.0 0.0 0.0 . 16 0 0 0 0.0 0.0 0.0 0.0 0.0 0.0 . 17 0 0 0 0.0 0.0 0.0 0.0 0.0 0.0 . 18 0 0 0 0.0 0.0 0.0 0.0 0.0 0.0 . 19 0 0 0 0.0 0.0 0.0 0.0 0.0 0.0 . 20 0 0 0 0.0 0.0 0.0 0.0 0.0 0.0 . 21 0 0 0 0.0 0.0 0.0 0.0 0.0 0.0 . 22 0 0 0 0.0 0.0 0.0 0.0 0.0 0.0 . 23 0 0 0 0.0 0.0 0.0 0.0 0.0 0.0 . 24 0 0 0 0.0 0.0 0.0 0.0 0.0 0.0 . 25 0 0 0 0.0 0.0 0.0 0.0 0.0 0.0 . 26 0 0 0 0.0 0.0 0.0 0.0 0.0 0.0 . 27 0 0 0 0.0 0.0 0.0 0.0 0.0 0.0 . 28 0 0 0 0.0 0.0 0.0 0.0 0.0 0.0 . 29 0 0 0 0.0 0.0 0.0 0.0 0.0 0.0 . 30 0 0 0 0.0 0.0 0.0 0.0 0.0 0.0 . 31 0 0 0 0.0 0.0 0.0 0.0 0.0 0.0 . 32 0 0 0 0.0 0.0 0.0 0.0 0.0 0.0 . 33 0 0 0 0.0 0.0 0.0 0.0 0.0 0.0 . 34 0 0 0 0.0 0.0 0.0 0.0 0.0 0.0 . 35 0 0 0 0.0 0.0 0.0 0.0 0.0 0.0 . 36 0 0 0 0.0 0.0 0.0 0.0 0.0 0.0 . 37 0 0 0 0.0 0.0 0.0 0.0 0.0 0.0 . 38 0 0 0 0.0 0.0 0.0 0.0 0.0 0.0 . 39 0 0 0 0.0 0.0 0.0 0.0 0.0 0.0 . 40 0 0 0 0.0 0.0 0.0 0.0 0.0 0.0 . 41 0 0 0 0.0 0.0 0.0 0.0 0.0 0.0 . 42 0 0 0 0.0 0.0 0.0 0.0 0.0 0.0 . 43 0 0 0 0.0 0.0 0.0 0.0 0.0 0.0 . 44 0 0 0 0.0 0.0 0.0 0.0 0.0 0.0 . 45 0 0 0 0.0 0.0 0.0 0.0 0.0 0.0 . 46 0 0 0 0.0 0.0 0.0 0.0 0.0 0.0 . 47 0 0 0 0.0 0.0 0.0 0.0 0.0 0.0 . 48 0 0 0 0.0 0.0 0.0 0.0 0.0 0.0 . 49 0 0 0 0.0 0.0 0.0 0.0 0.0 0.0 . 50 0 0 0 0.0 0.0 0.0 0.0 0.0 0.0 . 51 0 0 0 0.0 0.0 0.0 0.0 0.0 0.0 . 52 0 0 0 0.0 0.0 0.0 0.0 0.0 0.0 . 53 0 0 0 0.0 0.0 0.0 0.0 0.0 0.0 . 54 0 0 0 0.0 0.0 0.0 0.0 0.0 0.0 . 55 0 0 0 0.0 0.0 0.0 0.0 0.0 0.0 . 56 0 0 0 0.0 0.0 0.0 0.0 0.0 0.0 . 57 0 0 0 0.0 0.0 0.0 0.0 0.0 0.0 . 58 0 0 0 0.0 0.0 0.0 0.0 0.0 0.0 . 59 0 0 0 0.0 0.0 0.0 0.0 0.0 0.0 . 60 0 0 0 0.0 0.0 0.0 0.0 0.0 0.0 . 61 0 0 0 0.0 0.0 0.0 0.0 0.0 0.0 . 62 0 0 0 0.0 0.0 0.0 0.0 0.0 0.0 . 63 0 0 0 0.0 0.0 0.0 0.0 0.0 0.0 . 64 0 0 0 0.0 0.0 0.0 0.0 0.0 0.0 . 65 0 0 0 0.0 0.0 0.0 0.0 0.0 0.0 . 66 0 0 0 0.0 0.0 0.0 0.0 0.0 0.0 . 67 0 0 0 0.0 0.0 0.0 0.0 0.0 0.0 . 68 0 0 0 0.0 0.0 0.0 0.0 0.0 0.0 . 69 0 0 0 0.0 0.0 0.0 0.0 0.0 0.0 . 70 0 0 0 0.0 0.0 0.0 0.0 0.0 0.0 . 71 0 0 0 0.0 0.0 0.0 0.0 0.0 0.0 . 72 0 0 0 0.0 0.0 0.0 0.0 0.0 0.0 . 73 0 0 0 0.0 0.0 0.0 0.0 0.0 0.0 . 74 0 0 0 0.0 0.0 0.0 0.0 0.0 0.0 . 75 0 0 0 0.0 0.0 0.0 0.0 0.0 0.0 . 76 0 0 0 0.0 0.0 0.0 0.0 0.0 0.0 . 77 0 0 0 0.0 0.0 0.0 0.0 0.0 0.0 . 78 0 0 0 0.0 0.0 0.0 0.0 0.0 0.0 . 79 0 0 0 0.0 0.0 0.0 0.0 0.0 0.0 . 80 0 0 0 0.0 0.0 0.0 0.0 0.0 0.0 . 81 0 0 0 0.0 0.0 0.0 0.0 0.0 0.0 . 82 0 0 0 0.0 0.0 0.0 0.0 0.0 0.0 . 83 0 0 0 0.0 0.0 0.0 0.0 0.0 0.0 . 84 0 0 0 0.0 0.0 0.0 0.0 0.0 0.0 . 85 0 0 0 0.0 0.0 0.0 0.0 0.0 0.0 . 86 0 0 0 0.0 0.0 0.0 0.0 0.0 0.0 . 87 0 0 0 0.0 0.0 0.0 0.0 0.0 0.0 . 88 0 0 0 0.0 0.0 0.0 0.0 0.0 0.0 . 89 0 0 0 0.0 0.0 0.0 0.0 0.0 0.0 . 90 0 0 0 0.0 0.0 0.0 0.0 0.0 0.0 . 91 0 0 0 0.0 0.0 0.0 0.0 0.0 0.0 . 92 0 0 0 0.0 0.0 0.0 0.0 0.0 0.0 . 93 0 0 0 0.0 0.0 0.0 0.0 0.0 0.0 . 94 0 0 0 0.0 0.0 0.0 0.0 0.0 0.0 . 95 0 0 0 0.0 0.0 0.0 0.0 0.0 0.0 . 96 0 0 0 0.0 0.0 0.0 0.0 0.0 0.0 . 97 0 0 0 0.0 0.0 0.0 0.0 0.0 0.0 . 98 0 0 0 0.0 0.0 0.0 0.0 0.0 0.0 . 99 0 0 0 0.0 0.0 0.0 0.0 0.0 0.0 . 100 0 0 0 0.0 0.0 0.0 0.0 0.0 0.0 . R$ 130.00 R$ 167.00 ERROR:#VALUE! R$ 149.00 R$ 201.00 Imprime www.google.com Análise Cadastro Inserir Itens Selecione o Fornecedor Abaixo Cotação 43219 4/29/18 1 Casas Bahia Joana 11 0000-1111 Item Edivaldo: Edivaldo: Para Limpar as células vazias, clique na setinha e desmarque a caixa com ZERO. Para mudar de fornecedor, marque a caixa com ZERO, aliás, todas devem estar selecionadas, para que a tabela funcione. Para filtrar de novo Desmarque-a Códigos Descrição dos Itens QTDE Preço Total 1 CA-990A CUTOS 1 TESTE 12 R$ 100.00 2 0 0 0 R$ 30.00 0 0 0.0 0 0 0.0 0 0 0.0 0 0 0.0 0 0 0.0 0 0 0.0 0 0 0.0 0 0 0.0 0 0 0.0 0 0 0.0 0 0 0.0 0 0 0.0 0 0 0.0 0 0 0.0 0 0 0.0 0 0 0.0 0 0 0.0 0 0 0.0 0 0 0.0 0 0 0.0 0 0 0.0 0 0 0.0 0 0 0.0 0 0 0.0 0 0 0.0 0 0 0.0 0 0 0.0 0 0 0.0 0 0 0.0 0 0 0.0 0 0 0.0 0 0 0.0 0 0 0.0 0 0 0.0 0 0 0.0 0 0 0.0 0 0 0.0 0 0 0.0 0 0 0.0 0 0 0.0 0 0 0.0 0 0 0.0 0 0 0.0 0 0 0.0 0 0 0.0 0 0 0.0 0 0 0.0 0 0 0.0 0 0 0.0 0 0 0.0 0 0 0.0 0 0 0.0 0 0 0.0 0 0 0.0 0 0 0.0 0 0 0.0 0 0 0.0 0 0 0.0 0 0 0.0 0 0 0.0 0 0 0.0 0 0 0.0 0 0 0.0 0 0 0.0 0 0 0.0 0 0 0.0 0 0 0.0 0 0 0.0 0 0 0.0 0 0 0.0 0 0 0.0 0 0 0.0 0 0 0.0 0 0 0.0 0 0 0.0 0 0 0.0 0 0 0.0 0 0 0.0 0 0 0.0 0 0 0.0 0 0 0.0 0 0 0.0 0 0 0.0 0 0 0.0 0 0 0.0 0 0 0.0 0 0 0.0 0 0 0.0 0 0 0.0 0 0 0.0 0 0 0.0 0 0 0.0 0 0 0.0 0 0 0.0 0 0 0.0 0 0 0.0 0 0 0.0 0 0 0.0 Totais ERROR:#VALUE! Comprador Aprovação Ajuda www.guiadecompra.com Desenvolvida por www.tudoexcel.com.br www.guiadecompra.com Obter Ajuda VER MAIS PLANILHAS Clique nos links para ver as planilhas www.guiadecompra.com Planilha de Controle de Estoque Faz o controle de entrada, saída de mercadorias, calcula preço dos itens, tem cadastro por família de itens Planilha de Fluxo de Caixa Calcula as entrada e saída de recursos do caixa, pode ser utilizada por empresas e pessoas físicas, tem vários recursos Planilha de Cotação de Preços Faz cotação com até 5 fornecedores, tem uma tabela de análise com os menores preços, muito boa planilha para economizar Planilha de Cadastro de Clientes Cadastra clientes com praticamente todas as opções, nome, contatos, documentos, endereço, etc. Planilha de Custo de Construção e Reformas Calcula os custos de materiais e de mão-de-obra, com análise perfeita e com gráfico Planilha de Orçamento Familiar Planeja os gastos de toda a família, faz um resumo mensal, analisa lucros e prejuízos, etc. Planilha de Gerenciamento de Vendas Gerencia as vendas por vendedor, por período e por cliente, com análise gráfica do período mensal Planilha de Custo de Fabricação de Produtos Calcula o custo de um produto a ser fabricado, tem conversão de moeda, taxas e impostos, custo de mão-de-obra, custo de componentes, etc. Planilha para Controle de Produtos Perecóveis Controla produtos perecíveis como alimentos, com data de vencimento, estoques máximo e mínimo, aviso de compras, etc Planilha de Gastos Domésticos Gastos domésticos ou gastos pessoais, já vem com praticamente todas as despesas cadastradas. É só alimentar a planilha Planilha de Comissão de Vendas Calcula a comissão das vendas para vendedores e afiliados. Planilha para Controle de Débitos de Clientes Controla débitos de clientes que compram a prazo no seu comércio. Faz uma tabela de cadastro com s as dívidas e as parcelas Pacote de Planilhas com 25 Planilhas Pacote imperdível, com todas as planilhas citadas e mais planilhas para organizar suas atividades. www.guiadecompra.com Planilhas são a melhor forma de controlar tudo e reduzir custos Você Anuncia, Alguém Compra Todas as planilhas são desenvolvidas com fórmulas, algumas com o formato tabela e outras com macros. www.guiadecompra.com
Compartilhar