Baixe o app para aproveitar ainda mais
Esta é uma pré-visualização de arquivo. Entre para ver o arquivo original
Exercício Exercício 1) Preparar relatório de acompanhamento de Vendas Diárias 2) Informações na Planilha "dados TXT" 3) Fórmulas que permitam automatizar o relatório, de forma que o preenchimento das informações sejam automáticas a cada nova alimentação em "Dados TXT" => Vendas Brutas => Título => Dias Faturados => Média Faturamento => Projeção com base na média faturada e dias úteis no mês 4) Montar fórmula para cálculo de dias úteis no mês 5) Ao digitar o 1º dia do mês (célula "b5"), automaticamente os demais dias são alterados / na coluna "C", informar o dia da semana (Ex.: Segunda-Feira) 6) Na célula "g40", alertar Diretoria caso a projeção das vendas não atinga a meta LOJAS EVOLUÇÃO VENDAS DIÁRIAS - ABRIL 2014 LOJA 01 DATA VENDAS BRUTAS DEVOLUÇÃO VENDAS TOTAIS CUSTO PRODUTO VENDIDO MARGEM BRUTA MARGEM % TOTAL MÉDIA DIA Dias Faturados PROJEÇÃO Dias Úteis META * 1,500,000 1-Jan-13 1-Feb-13 1-Mar-13 1-Apr-13 1-May-13 1-Jun-13 1-Jul-13 1-Aug-13 1-Sep-13 1-Oct-13 1-Nov-13 1-Dec-13 1-Jan-14 1-Feb-14 1-Mar-14 1-Apr-14 1-May-14 1-Jun-14 1-Jul-14 1-Aug-14 1-Sep-14 1-Oct-14 1-Nov-14 Dados TXT DATA VENDAS 1-Jan-13 * 32,989 2-Jan-13 * 47,610 3-Jan-13 * 10,380 4-Jan-13 * 15,172 7-Jan-13 * 47,910 8-Jan-13 * 34,430 9-Jan-13 * 36,639 10-Jan-13 * 25,140 11-Jan-13 * 11,463 14-Jan-13 * 37,972 15-Jan-13 * 12,905 16-Jan-13 * 30,234 17-Jan-13 * 34,931 18-Jan-13 * 45,522 21-Jan-13 * 34,423 22-Jan-13 * 19,640 23-Jan-13 * 44,732 24-Jan-13 * 39,259 25-Jan-13 * 11,035 28-Jan-13 * 35,574 29-Jan-13 * 38,833 30-Jan-13 * 42,997 31-Jan-13 * 36,214 1-Feb-13 * 30,101 4-Feb-13 * 49,494 5-Feb-13 * 37,713 6-Feb-13 * 45,045 7-Feb-13 * 10,188 8-Feb-13 * 42,032 11-Feb-13 * 37,645 12-Feb-13 * 14,801 13-Feb-13 * 46,877 14-Feb-13 * 29,794 15-Feb-13 * 33,213 18-Feb-13 * 46,795 19-Feb-13 * 49,683 20-Feb-13 * 26,796 21-Feb-13 * 12,470 22-Feb-13 * 27,097 25-Feb-13 * 41,436 26-Feb-13 * 36,741 27-Feb-13 * 22,297 28-Feb-13 * 11,339 1-Mar-13 * 42,257 4-Mar-13 * 46,910 5-Mar-13 * 21,118 6-Mar-13 * 27,680 7-Mar-13 * 20,071 8-Mar-13 * 14,938 11-Mar-13 * 26,550 12-Mar-13 * 39,083 13-Mar-13 * 23,877 14-Mar-13 * 44,856 15-Mar-13 * 20,825 18-Mar-13 * 26,955 19-Mar-13 * 33,004 20-Mar-13 * 14,505 21-Mar-13 * 43,988 22-Mar-13 * 22,094 25-Mar-13 * 35,179 26-Mar-13 * 22,603 27-Mar-13 * 11,658 28-Mar-13 * 49,782 29-Mar-13 * 19,993 1-Apr-13 * 10,760 2-Apr-13 * 18,477 3-Apr-13 * 46,861 4-Apr-13 * 10,889 5-Apr-13 * 31,131 8-Apr-13 * 44,867 9-Apr-13 * 33,809 10-Apr-13 * 20,595 11-Apr-13 * 40,692 12-Apr-13 * 30,389 15-Apr-13 * 49,499 16-Apr-13 * 18,020 17-Apr-13 * 29,132 18-Apr-13 * 28,912 19-Apr-13 * 43,622 22-Apr-13 * 27,146 23-Apr-13 * 23,769 24-Apr-13 * 29,944 25-Apr-13 * 49,202 26-Apr-13 * 41,870 29-Apr-13 * 10,665 30-Apr-13 * 26,333 1-May-13 * 14,870 2-May-13 * 32,140 3-May-13 * 32,297 6-May-13 * 26,849 7-May-13 * 43,931 8-May-13 * 41,069 9-May-13 * 12,534 10-May-13 * 30,347 13-May-13 * 27,753 14-May-13 * 24,859 15-May-13 * 22,971 16-May-13 * 46,406 17-May-13 * 11,691 20-May-13 * 14,011 21-May-13 * 27,613 22-May-13 * 14,953 23-May-13 * 42,053 24-May-13 * 42,290 27-May-13 * 35,348 28-May-13 * 14,847 29-May-13 * 17,470 30-May-13 * 22,231 31-May-13 * 33,258 3-Jun-13 * 49,587 4-Jun-13 * 23,799 5-Jun-13 * 16,539 6-Jun-13 * 34,893 7-Jun-13 * 48,560 10-Jun-13 * 30,068 11-Jun-13 * 41,837 12-Jun-13 * 15,258 13-Jun-13 * 27,351 14-Jun-13 * 46,510 17-Jun-13 * 27,075 18-Jun-13 * 32,330 19-Jun-13 * 34,698 20-Jun-13 * 35,370 21-Jun-13 * 24,869 24-Jun-13 * 45,633 25-Jun-13 * 35,007 26-Jun-13 * 16,671 27-Jun-13 * 24,889 28-Jun-13 * 47,937 1-Jul-13 * 12,600 2-Jul-13 * 26,878 3-Jul-13 * 41,703 4-Jul-13 * 22,542 5-Jul-13 * 28,433 8-Jul-13 * 14,997 9-Jul-13 * 21,796 10-Jul-13 * 28,712 11-Jul-13 * 14,905 12-Jul-13 * 35,337 15-Jul-13 * 43,623 16-Jul-13 * 23,785 17-Jul-13 * 26,672 18-Jul-13 * 32,491 19-Jul-13 * 30,072 22-Jul-13 * 28,376 23-Jul-13 * 39,730 24-Jul-13 * 21,961 25-Jul-13 * 48,132 26-Jul-13 * 17,797 29-Jul-13 * 34,412 30-Jul-13 * 36,265 31-Jul-13 * 49,776 1-Aug-13 * 11,271 2-Aug-13 * 17,983 5-Aug-13 * 13,454 6-Aug-13 * 13,202 7-Aug-13 * 32,675 8-Aug-13 * 47,721 9-Aug-13 * 41,021 12-Aug-13 * 16,320 13-Aug-13 * 33,646 14-Aug-13 * 15,103 15-Aug-13 * 11,010 16-Aug-13 * 12,318 19-Aug-13 * 18,094 20-Aug-13 * 10,674 21-Aug-13 * 32,422 22-Aug-13 * 30,556 23-Aug-13 * 45,391 26-Aug-13 * 38,005 27-Aug-13 * 49,509 28-Aug-13 * 17,495 29-Aug-13 * 11,644 30-Aug-13 * 48,939 2-Sep-13 * 43,808 3-Sep-13 * 42,122 4-Sep-13 * 10,472 5-Sep-13 * 31,056 6-Sep-13 * 36,891 9-Sep-13 * 29,706 10-Sep-13 * 43,518 11-Sep-13 * 16,979 12-Sep-13 * 24,286 13-Sep-13 * 26,934 16-Sep-13 * 49,066 17-Sep-13 * 42,656 18-Sep-13 * 18,315 19-Sep-13 * 22,339 20-Sep-13 * 38,642 23-Sep-13 * 41,288 24-Sep-13 * 25,222 25-Sep-13 * 16,179 26-Sep-13 * 46,382 27-Sep-13 * 33,991 30-Sep-13 * 24,173 1-Oct-13 * 35,264 2-Oct-13 * 41,707 3-Oct-13 * 49,977 4-Oct-13 * 26,545 7-Oct-13 * 26,087 8-Oct-13 * 13,853 9-Oct-13 * 29,311 10-Oct-13 * 10,296 11-Oct-13 * 35,374 14-Oct-13 * 47,114 15-Oct-13 * 19,452 16-Oct-13 * 22,444 17-Oct-13 * 48,204 18-Oct-13 * 45,760 21-Oct-13 * 25,126 22-Oct-13 * 46,909 23-Oct-13 * 18,033 24-Oct-13 * 38,630 25-Oct-13 * 23,611 28-Oct-13 * 36,005 29-Oct-13 * 16,865 30-Oct-13 * 15,948 31-Oct-13 * 39,451 1-Nov-13 * 32,288 4-Nov-13 * 12,644 5-Nov-13 * 40,392 6-Nov-13 * 39,715 7-Nov-13 * 24,263 8-Nov-13 * 28,089 11-Nov-13 * 19,607 12-Nov-13 * 40,313 13-Nov-13 * 25,482 14-Nov-13 * 45,638 15-Nov-13 * 26,001 18-Nov-13 * 32,992 19-Nov-13 * 24,112 20-Nov-13 * 16,543 21-Nov-13 * 40,116 22-Nov-13 * 29,965 25-Nov-13 * 30,918 26-Nov-13 * 18,455 27-Nov-13 * 24,572 28-Nov-13 * 49,845 29-Nov-13 * 46,909 2-Dec-13 * 20,655 3-Dec-13 * 23,972 4-Dec-13 * 23,934 5-Dec-13 * 39,173 6-Dec-13 * 15,020 9-Dec-13 * 41,170 10-Dec-13 * 32,356 11-Dec-13 * 23,128 12-Dec-13 * 25,318 13-Dec-13 * 22,613 16-Dec-13 * 40,408 17-Dec-13 * 26,377 18-Dec-13 * 34,829 19-Dec-13 * 12,751 20-Dec-13 * 15,005 23-Dec-13 * 15,179 24-Dec-13 * 20,464 25-Dec-13 * 33,343 26-Dec-13 * 39,710 27-Dec-13 * 12,749 30-Dec-13 * 47,099 31-Dec-13 * 48,877 1-Jan-14 * 28,226 2-Jan-14 * 44,156 3-Jan-14 * 40,645 6-Jan-14 * 22,182 7-Jan-14 * 17,821 8-Jan-14 * 49,709 9-Jan-14 * 29,605 10-Jan-14 * 22,169 13-Jan-14 * 21,742 14-Jan-14 * 25,615 15-Jan-14 * 18,780 16-Jan-14 * 13,548 17-Jan-14 * 13,706 20-Jan-14 * 12,299 21-Jan-14 * 27,012 22-Jan-14 * 48,263 23-Jan-14 * 19,698 24-Jan-14 * 27,673 27-Jan-14 * 38,801 28-Jan-14 * 35,080 29-Jan-14 * 43,044 30-Jan-14 * 31,038 31-Jan-14 * 44,764 3-Feb-14 * 42,731 4-Feb-14 * 27,546 5-Feb-14 * 40,337 6-Feb-14 * 27,769 7-Feb-14 * 17,778 10-Feb-14 * 23,992 11-Feb-14 * 35,219 12-Feb-14 * 41,354 13-Feb-14 * 28,586 14-Feb-14 * 48,869 17-Feb-14 * 27,183 18-Feb-14 * 31,931 19-Feb-14 * 37,488 20-Feb-14 * 36,543 21-Feb-14 * 34,201 24-Feb-14 * 15,092 25-Feb-14 * 43,079 26-Feb-14 * 30,903 27-Feb-14 * 20,943 28-Feb-14 * 37,090 3-Mar-14 * 27,162 4-Mar-14 * 33,841 5-Mar-14 * 46,964 6-Mar-14 * 37,412 7-Mar-14 * 10,558 10-Mar-14 * 46,362 11-Mar-14 * 33,983 12-Mar-14 * 42,314 13-Mar-14 * 29,297 14-Mar-14 * 49,047 17-Mar-14 * 12,203 18-Mar-14 * 38,385 19-Mar-14 * 12,867 20-Mar-14 * 18,603 21-Mar-14 * 37,288 24-Mar-14 * 21,937 25-Mar-14 * 24,728 26-Mar-14 * 30,998 27-Mar-14 * 31,921 28-Mar-14 * 15,771 31-Mar-14 * 40,018 1-Apr-14 * 34,009 2-Apr-14 * 27,166 3-Apr-14 * 15,512 4-Apr-14 * 26,578 7-Apr-14 * 20,785 8-Apr-14 * 41,423 9-Apr-14 * 49,508 10-Apr-14 * 16,635 11-Apr-14 * 30,911 14-Apr-14 * 39,475 15-Apr-14 * 11,437 16-Apr-14 * 42,481 17-Apr-14 * 34,059 18-Apr-14 * 35,823 21-Apr-14 * 49,366 22-Apr-14 * 49,695 23-Apr-14 * 13,532 24-Apr-14 * 44,233 25-Apr-14 * 22,278 28-Apr-14 * 41,843 29-Apr-14 * 10,852 30-Apr-14 * 36,982 1-May-14 * 31,455 2-May-14 * 48,097 5-May-14 * 26,737 6-May-14 * 36,721 7-May-14 * 31,823 8-May-14 * 24,902 9-May-14 * 49,791 12-May-14 * 48,404 13-May-14 * 41,768 14-May-14 * 39,468 15-May-14 * 17,299 16-May-14 * 10,072 19-May-14 * 37,708 20-May-14 * 44,313 21-May-14 * 16,718 22-May-14 * 43,661 23-May-14 * 12,771 26-May-14 * 47,804
Compartilhar