como deflacionar preços

Prévia do material em texto

Planilha1
		Milho	Soja	Frango	Suino	IGP_DI	milho_def	soja_def	frango_def	suino_def
	Jan-20	39.19	77.64	3.42	4.73	751.82	56.63445514	112.1995177	4.942328057	6.835442021
	Feb-20	39.54	77.77	3.23	4.56	751.91	57.13340953	112.3739317	4.667195569	6.588981979
	Mar-20	42.27	82.78	3.23	4.72	764.276	60.08988373	117.6777993	4.591680257	6.709823781
	Apr-20	39.98	85.86	3.19	4.33	764.656	56.80623773	121.9955871	4.532563741	6.15235141
	May-20	40.21	94.03	3.20	4.19	772.843	56.52780648	132.1887501	4.498606832	5.890363321
	Jun-20	38.19	91.99	3.45	4.27	785.221	52.84173763	127.2823107	4.77360552	5.908201615
	Jul-20	41.17	98.88	3.54	4.66	803.584	55.66329666	133.6892585	4.78620525	6.300484878
	Aug-20	45.55	107.90	3.60	5.56	834.713	59.28851078	140.4441342	4.685809853	7.236972996
	Sep-20	50.33	122.11	3.86	6.21	862.259	63.41741451	153.8625171	4.863723823	7.824799208
	Oct-20	59.81	141.21	4.16	6.59	893.997	72.68705593	171.6124255	5.055645422	8.008822916
	Nov-20	67.58	146.96	4.45	7.17	917.538	80.02274883	174.0180996	5.269328682	8.490131831
	Dec-20	63.59	137.38	4.60	6.71	924.504	74.73075472	161.4485152	5.405904572	7.885569495
	Jan-21	72.54	150.79	4.62	6.65	951.395	82.83922447	172.1991544	5.275947298	7.594166566
	Feb-21	72.39	153.24	4.74	6.49	977.133	80.49042746	170.3875273	5.270405114	7.216229787
	Mar-21	77.84	156.96	4.90	6.40	998.344	84.71141827	170.8158301	5.332553308	6.964967586
	Apr-21	90.13	159.58	4.79	6.46	1020.495	95.95725762	169.8974722	5.099692267	6.87766431
	May-21	91.38	159.74	5.03	6.63	1055.167	94.0912615	164.4795153	5.17924103	6.826713326
	Jun-21	78.82	146.44	5.12	6.46	1056.343	81.06825215	150.6170369	5.266042261	6.644264259
	Jul-21	88.34	150.76	5.36	6.44	1071.615	89.56492132	152.8504362	5.434321692	6.529296958
	Aug-21	93.64	155.05	5.60	6.60	1070.147	95.06864511	157.4155641	5.685437982	6.700694764
	Sep-21	85.66	156.89	5.91	6.53	1064.31	87.44384892	160.1571965	6.03307433	6.665985681
	Oct-21	82.85	158.44	5.91	6.71	1081.301	83.24635869	159.1979852	5.938273746	6.742100988
	Nov-21	77.13	153.58	5.87	6.38	1075.022	77.95165087	155.2160578	5.932531967	6.447964897
	Dec-21	79.89	156.49	5.41	6.43	1088.489	79.74210843	156.2003073	5.399985062	6.418096848
	Jan-22	88.35	164.95	5.08	6.10	1110.398	86.44411316	161.3960817	4.970549226	5.96857289
	Feb-22	90.95	183.94	5.09	6.01	1127.077	87.67602846	177.3114324	4.904608172	5.797923762
	Mar-22	90.67	190.63	5.36	6.19	1153.777	85.3809684	179.5100254	5.047336392	5.828920199
	Apr-22	78.05	172.19	5.69	6.29	1158.546	73.19458675	161.4782305	5.336030732	5.898705325
	May-22	80.36	177.86	5.58	6.45	1166.542	74.84432677	165.6522145	5.197005269	6.007291036
	Jun-22	79.31	175.94	5.58	6.51	1173.831	73.40771622	162.8464707	5.164734038	6.025523044
	Jul-22	73.89	171.54	5.53	6.69	1169.426	68.64432417	159.3703187	5.136992029	6.212293081
	Aug-22	75.33	167.48	5.47	6.66	1162.956	70.37843212	156.4654623	5.110544786	6.224713243
	Sep-22	75.56	167.30	5.39	6.62	1148.811	71.45531486	158.2243946	5.093176406	6.262297487
	Oct-22	76.06	165.87	5.23	6.68	1141.733	72.37875444	157.8420194	4.976872018	6.356693132
	Nov-22	75.90	169.10	5.19	6.69	1139.734	72.35670477	161.1960163	4.943561846	6.375563736
	Dec-22	73.95	166.22	5.14	6.73	1143.225	70.27599605	157.9657975	4.882373573	6.397150549
	Jan-23	76.80	163.13	5.00	6.61	1143.861	72.946978	154.9458401	4.749152213	6.278379226
	Feb-23	75.26	158.14	4.98	6.74	1144.271	71.45862583	150.1523663	4.728460758	6.399563355
	Mar-23	72.92	149.15	4.91	6.91	1140.357	69.47445763	142.1025145	4.677997627	6.583495642
	Apr-23	61.76	132.16	4.86	6.64	1128.805	59.44395555	127.2039049	4.677746502	6.390995221
	May-23	48.20	123.73	4.77	6.10	1102.506	47.49910368	121.9307904	4.700637439	6.011297353
	Jun-23	46.83	119.68	4.54	5.41	1086.474	46.83	119.68	4.54	5.41