01 Exemplo Relatório Procv

Esta é uma pré-visualização de arquivo. Entre para ver o arquivo original

Relatório
	1	3	4	6	7	8	9	10	11	12	13	14	15	16	17
	Colunas1	Colunas2	Colunas3	Colunas4	Colunas5	Colunas6	Colunas7	Colunas8	Colunas9	Colunas10	Colunas11	Colunas12	Colunas13	Colunas14	Colunas15	Colunas16
	EVOLUÇÃO DE VENDAS - 2014
	Código	Nome	UF	Jan	Fev	Mar	Abr	Mai	Jun	Jul	Ago	Set	Out	Nov	Dez	Total
	647	CARNE MOIDA - KG	PE	* 149.74	* 134.90	* 146.95	* 167.36	* 171.40	* 133.46	* 58.12	* 187.80	* 132.35	0.0	0.0	0.0	* 1,282.08
	374	PICANHA	PE	* 116.77	* 150.84	* 138.22	* 159.04	* 164.99	* 152.96	* 125.58	* 167.44	* 173.05	0.0	0.0	0.0	* 1,348.89
	1623	CARNE MOIDA PATINHO (M) - KG	AL	* 32.08	* 37.60	* 37.84	* 43.60	* 46.43	* 45.26	* 42.28	* 75.11	* 59.15	0.0	0.0	0.0	* 419.35
	98	COXAO DURO BIFE - KG	PE	* 53.00	* 71.48	* 58.21	* 75.87	* 73.09	* 64.38	* 66.05	* 93.74	* 87.03	0.0	0.0	0.0	* 642.83
	1409	COPA LOMBO - KG	AL	* 31.23	* 35.41	* 29.76	* 42.10	* 43.54	* 34.48	* 42.80	* 59.52	* 65.30	0.0	0.0	0.0	* 384.16
	1639	LOMBO - KG	AL	* 84.45	* 59.93	* 52.01	* 75.46	* 67.86	* 81.59	* 73.50	* 76.39	* 48.49	0.0	0.0	0.0	* 619.69
	208	ACEM -KG	PE	* 333.06	* 423.47	* 300.99	* 253.89	* 890.67	* 389.67	* 572.05	* 659.96	* 453.56	0.0	0.0	0.0	* 4,277.33
	727	COXAO DURO - KG	PE	* 234.63	* 326.68	* 261.00	* 252.85	* 299.31	* 304.54	* 414.45	* 365.90	* 293.38	0.0	0.0	0.0	* 2,752.75
	1503	COXAO MOLE - KG	AL	* 3.53	* 13.43	* 15.62	* 36.49	* 69.85	* 234.85	* 137.39	* 197.96	* 172.90	0.0	0.0	0.0	* 881.99
	602	CUPIM - KG	PE	* 290.10	* 264.91	* 423.81	* 439.55	* 542.60	* 407.53	* 310.76	* 507.29	* 308.34	0.0	0.0	0.0	* 3,494.88
	1428	PEITO DE FRANGO EM CUBOS - KG	AL	* 17.43	* 24.19	* 20.02	* 29.57	* 30.95	* 28.54	* 31.03	* 39.89	* 32.21	0.0	0.0	0.0	* 253.82
	TOTAL	* 1,346.01	* 1,542.84	* 1,484.44	* 1,575.77	* 2,400.69	* 1,877.26	* 1,874.03	* 2,430.99	* 1,825.75	0.0	0.0	0.0	* 16,357.78
	%S/ Total Ano	* 0.08
	1) Montar Relatório Evolução Vendas => Formatar e Colocar Fórmulas
	2) Buscar informações da Planilha "Dados"
Relatório (mgn)
	3	4	6	7	8	9	10	11	12	13	14	15	16	17
	EVOLUÇÃO VENDAS	Em milhares de R$
	Código	Nome	UF	Jan-09	Feb-09	Mar-09	Apr-09	May-09	Jun-09	Jul-09	Aug-09	Sep-09	Oct-09	Nov-09	Dec-09	TOTAL
	647	CARNE MOIDA - KG	PE	149.7	134.9	146.9	167.4	171.4	133.5	58.1	187.8	132.3	0.0	0.0	0.0	1,282
	374	PICANHA	PE	116.8	150.8	138.2	159.0	165.0	153.0	125.6	167.4	173.0	0.0	0.0	0.0	1,349
	1623	CARNE MOIDA PATINHO (M) - KG	AL	32.1	37.6	37.8	43.6	46.4	45.3	42.3	75.1	59.2	0.0	0.0	0.0	419
	98	COXAO DURO BIFE - KG	PE	53.0	71.5	58.2	75.9	73.1	64.4	66.1	93.7	87.0	0.0	0.0	0.0	643
	1409	COPA LOMBO - KG	AL	31.2	35.4	29.8	42.1	43.5	34.5	42.8	59.5	65.3	0.0	0.0	0.0	384
	1639	LOMBO - KG	AL	84.4	59.9	52.0	75.5	67.9	81.6	73.5	76.4	48.5	0.0	0.0	0.0	620
	208	ACEM -KG	PE	333.1	423.5	301.0	253.9	890.7	389.7	572.1	660.0	453.6	0.0	0.0	0.0	4,277
	727	COXAO DURO - KG	PE	234.6	326.7	261.0	252.9	299.3	304.5	414.5	365.9	293.4	0.0	0.0	0.0	2,753
	1503	COXAO MOLE - KG	AL	3.5	13.4	15.6	36.5	69.8	234.8	137.4	198.0	172.9	0.0	0.0	0.0	882
	602	CUPIM - KG	PE	290.1	264.9	423.8	439.6	542.6	407.5	310.8	507.3	308.3	0.0	0.0	0.0	3,495
	1428	PEITO DE FRANGO EM CUBOS - KG	AL	17.4	24.2	20.0	29.6	30.9	28.5	31.0	39.9	32.2	0.0	0.0	0.0	254
	TOTAL	1,346	1,543	1,484	1,576	2,401	1,877	1,874	2,431	1,826	0	0	0	16,358
Dados
	Cod Forn	Reg	Nome	UF	Val	Jan-14	Feb-14	Mar-14	Apr-14	May-14	Jun-14	Jul-14	Aug-14	Sep-14
	208	ACEM -KG	PE	* 333,061.09	* 423,472.06	* 300,993.49	* 253,892.58	* 890,668.87	* 389,673.59	* 572,050.94	* 659,963.19	* 453,555.05
	727	COXAO DURO - KG	PE	* 234,631.85	* 326,678.37	* 261,004.97	* 252,851.96	* 299,313.44	* 304,542.98	* 414,450.84	* 365,896.38	* 293,375.51
	1503	COXAO MOLE - KG	AL	* 3,528.64	* 13,428.67	* 15,619.12	* 36,485.15	* 69,846.64	* 234,845.54	* 137,387.16	* 197,955.92	* 172,898.11
	602	CUPIM - KG	PE	* 290,103.78	* 264,910.95	* 423,806.50	* 439,551.96	* 542,599.72	* 407,530.42	* 310,758.60	* 507,285.87	* 308,335.19
	1380	FRALDINHA - KG	AL	* 56,150.98	* 75,031.40	* 70,905.25	* 94,630.97	* 126,028.39	* 199,698.61	* 162,331.36	* 143,937.63	* 140,068.62
	838	LAGARTO - KG	PE	* 166,906.93	* 140,514.82	* 115,336.96	* 249,113.10	* 250,538.14	* 247,664.27	* 242,849.13	* 271,405.17	* 161,964.01
	1667	ALCATRA ESPETO (100 GR) - KG	PE	* 89,156.64	* 123,898.68	* 143,979.31	* 103,291.09	* 94,831.38	* 92,853.98	* 66,011.47	* 124,699.59	* 199,993.14
	676	ALMONDEGA BOVINA - KG	PE	* 147,585.87	* 172,897.14	* 184,082.93	* 179,404.32	* 196,283.50	* 209,250.98	* 165,564.36	* 224,607.05	* 211,258.67
	278	CARNE DE PANELA - KG	PE	* 104,192.58	* 144,414.26	* 147,097.85	* 154,672.85	* 158,584.09	* 156,811.32	* 132,552.94	* 174,105.62	* 164,221.36
	647	CARNE MOIDA - KG	PE	* 149,739.35	* 134,897.70	* 146,949.61	* 167,358.03	* 171,399.12	* 133,464.85	* 58,119.46	* 187,802.33	* 132,346.14
	374	PICANHA	PE	* 116,766.91	* 150,840.82	* 138,220.13	* 159,039.17	* 164,991.94	* 152,958.92	* 125,583.81	* 167,438.51	* 173,045.77
	1623	CARNE MOIDA PATINHO (M) - KG	AL	* 32,079.52	* 37,600.86	* 37,844.91	* 43,598.42	* 46,429.14	* 45,255.66	* 42,282.06	* 75,107.68	* 59,154.09
	1299	CARNE EM TIRAS PATINHO (M) - KG	AL	* 315,433.46	* 347,548.51	* 256,146.63	* 217,561.76	* 264,384.91	* 270,043.24	* 326,918.55	* 363,964.30	* 351,268.57
	98	COXAO DURO BIFE - KG	PE	* 52,995.38	* 71,475.80	* 58,206.76	* 75,865.10	* 73,085.71	* 64,379.91	* 66,052.85	* 93,741.35	* 87,032.08
	454	COXAO MOLE BIFE - KG	RN	* 68,444.57	* 71,202.22	* 99,413.12	* 96,689.81	* 108,147.81	* 100,945.48	* 130,097.03	* 110,416.33	* 139,962.24
	275	ESPETO BOVINO - KG	PE	* 101,646.25	* 108,809.12	* 59,835.85	* 116,258.74	* 88,255.50	* 91,505.00	* 95,137.92	* 109,838.62	* 48,754.61
	1451	HAMBURGUER BOVINO - KG	AL	* 32,469.92	* 43,753.70	* 42,507.90	* 52,693.44	* 62,331.83	* 57,981.36	* 52,268.43	* 63,453.36	* 67,184.71
	109	KIBE SEMI PRONTO - KG	PE	* 65,253.03	* 56,757.76	* 36,039.65	* 70,228.79	* 66,514.71	* 94,512.16	* 50,486.23	* 57,509.73	* 83,462.68
	991	BISTECA SUINA KG	RN	* 22,546.56	* 8,384.00	* 5,414.05	* 10,091.26	* 13,277.70	* 8,102.80	* 8,569.84	* 14,343.50	* 68,104.54
	1409	COPA LOMBO - KG	AL	* 31,230.70	* 35,406.58	* 29,763.78	* 42,098.73	* 43,544.54	* 34,483.96	* 42,804.03	* 59,522.38	* 65,302.92
	1639	LOMBO - KG	AL	* 84,445.11	* 59,934.25	* 52,010.86	* 75,457.58	* 67,860.13	* 81,592.70	* 73,503.85	* 76,392.35	* 48,494.10
	106	PERNIL SEM OSSO - KG	PE	* 52,421.25	* 63,938.59	* 45,426.69	* 47,583.60	* 64,744.98	* 64,260.27	* 40,316.77	* 77,387.96	* 61,055.29
	92	BACON INTEIRO - KG	PE	* 123,540.40	* 52,755.00	* 94,738.16	* 51,568.64	* 77,270.63	* 38,426.88	* 80,719.02	* 77,514.79	* 58,423.59
	604	COPA LOMBO BIFES - KG	PE	* 39,997.48	* 51,191.37	* 30,629.40	* 52,555.76	* 51,265.95	* 52,172.30	* 32,428.49	* 44,009.88	* 39,814.15
	603	COXA/SOBRECOXA DE FRANGO - KG	PE	* 50,538.29	* 70,211.65	* 56,875.91	* 51,737.63	* 53,633.83	* 52,203.07	* 39,151.02	* 58,422.74	* 46,695.87
	1505	FILE PEITO DE FRANGO - KG	PE	* 19,084.22	* 89,754.83	* 137,100.85	* 82,855.58	* 82,787.03	* 53,670.19	* 34,924.91	* 40,139.48	* 31,343.97
	1428	PEITO DE FRANGO EM CUBOS - KG	AL	* 17,427.81	* 24,192.13	* 20,020.17	* 29,568.28	* 30,948.60	* 28,535.68	* 31,033.51	* 39,887.39	* 32,209.00