Hoja1DepartamentoContabilidadValoresEtiquetas de filaSuma de 2010Suma de 2011Proy1500500Proy2550550Proy3605695.75Proy4665.5632.225Total general2320.52377.975

Datos ProyectosDepartamentoProyecto20102011ComprasProy130,00033,000ContabilidadProy1500500CRMProy110,00012,000ProduccinProy150,00070,000ProyectosProy1100,00095,000RRHHProy1200,000210,000TesoreraProy11,000900VentasProy140,00043,000ComprasProy233,00031,350ContabilidadProy2550605CRMProy211,00013,200ProduccinProy255,00060,500ProyectosProy2110,000110,000RRHHProy2220,000209,000TesoreraProy21,1001,100VentasProy244,00044,000ComprasProy336,30041,745ContabilidadProy3605726CRMProy312,10014,520ProduccinProy360,50057,475ProyectosProy3121,000121,000RRHHProy3242,000278,300TesoreraProy31,2101,452VentasProy348,40055,660ComprasProy439,93037,934ContabilidadProy4666666CRMProy413,31012,645ProduccinProy466,55066,550ProyectosProy4133,100159,720RRHHProy4266,200319,440TesoreraProy41,3311,531VentasProy453,24063,888

Hoja2Proyecto(Todas)ValoresEtiquetas de filaCoste 2010Previsto 2011Compras139,230146,751Contabilidad2,3212377.975CRM46,41051875Produccin232,050270255Proyectos464,100471200RRHH928,200949090Tesorera4,6414705.45Ventas185,640205426Total general2,002,5922,101,680

Formulas ProyectosCampo calculadoOrden de resolucinCampoFrmula1Variacin='2011'/'2010'-1Elemento calculadoOrden de resolucinElementoFrmulaNotas:Cuando una celda se actualiza con ms de una frmula,el valor lo establece la frmula con la ltima orden de resolucin.Para cambiar el orden de resolucin de varios elementos o campos calculados,en la ficha Opciones, dentro del grupo Clculos, haga clic en Campos, elementos y conjuntos y luego haga clic en Orden de resolucin.

Datos PreciosFechaArtculoFacturacinUnidades2/3/11Art345,488833/4/11Art241,027256/16/11Art595,121145/28/11Art466,941992/14/11Art346,624143/26/11Art219,169445/2/11Art347,444502/28/11Art142,964696/1/11Art546,595975/19/11Art198,039625/21/11Art416,365853/13/11Art432,501895/11/11Art340,632621/20/11Art162,966314/13/11Art210,681553/31/11Art191,600815/14/11Art516,495762/28/11Art250,064804/30/11Art583,402336/18/11Art398,742193/4/11Art232,546986/5/11Art264,540685/11/11Art590,649941/14/11Art116,424995/21/11Art528,725994/20/11Art354,926993/19/11Art332,671124/20/11Art423,674905/3/11Art168,259183/25/11Art185,927706/30/11Art330,405575/30/11Art175,981246/28/11Art187,577232/9/11Art356,663894/15/11Art397,568824/11/11Art331,636785/18/11Art387,469795/19/11Art329,561762/3/11Art381,559764/16/11Art559,324296/2/11Art281,993272/9/11Art536,088833/19/11Art140,171114/19/11Art190,787563/6/11Art589,743976/5/11Art414,676966/4/11Art329,424903/2/11Art488,268273/11/11Art543,396111/31/11Art337,664582/21/11Art178,900484/28/11Art293,104244/11/11Art234,274222/19/11Art521,339346/27/11Art181,237282/6/11Art141,660121/31/11Art153,007674/19/11Art447,790655/13/11Art283,675375/24/11Art545,994601/5/11Art494,119864/18/11Art398,782285/23/11Art246,725556/13/11Art353,690781/1/11Art351,591974/18/11Art537,147116/19/11Art241,201196/29/11Art280,127996/2/11Art499,779184/12/11Art549,274171/19/11Art496,224621/7/11Art235,868381/8/11Art546,954673/9/11Art589,558805/5/11Art250,354455/30/11Art499,757763/31/11Art559,761331/26/11Art414,133862/28/11Art392,511183/30/11Art183,305785/21/11Art251,854484/6/11Art218,745423/27/11Art230,486901/5/11Art194,223664/7/11Art256,340246/30/11Art228,323482/8/11Art428,272316/6/11Art271,961764/5/11Art144,960591/1/11Art565,034632/3/11Art132,874274/27/11Art254,643484/7/11Art416,395271/22/11Art292,206203/30/11Art474,936761/29/11Art270,636375/28/11Art219,658652/15/11Art116,783854/30/11Art218,766974/23/11Art283,453456/4/11Art250,392111/30/11Art529,813726/19/11Art161,504314/20/11Art588,016251/15/11Art223,506452/7/11Art120,017303/18/11Art165,497952/3/11Art515,175731/22/11Art363,572242/21/11Art335,695253/10/11Art591,820874/27/11Art556,388353/21/11Art586,789553/20/11Art251,047301/23/11Art331,631772/20/11Art263,592453/23/11Art326,802211/3/11Art168,165795/5/11Art519,546332/24/11Art222,682995/4/11Art381,934622/11/11Art515,478215/18/11Art172,628311/16/11Art150,750821/17/11Art534,451812/2/11Art357,888321/1/11Art455,447484/25/11Art594,744583/31/11Art578,053464/17/11Art238,502332/23/11Art510,967381/2/11Art449,923251/13/11Art456,335193/4/11Art159,254756/16/11Art593,046923/28/11Art237,400103/25/11Art492,136894/30/11Art245,158834/14/11Art214,726454/25/11Art369,916461/25/11Art579,531233/8/11Art352,643931/31/11Art294,326956/17/11Art233,414766/19/11Art190,937843/8/11Art444,851661/21/11Art261,117982/5/11Art350,107516/24/11Art346,878704/27/11Art414,618312/10/11Art163,109943/9/11Art338,271491/14/11Art283,372375/12/11Art237,617174/6/11Art119,125545/2/11Art466,452955/23/11Art159,409115/20/11Art375,301216/4/11Art284,319492/15/11Art513,194154/23/11Art521,597901/29/11Art178,486494/11/11Art534,086283/29/11Art498,767513/14/11Art495,940564/17/11Art280,253694/28/11Art277,062926/5/11Art290,807885/23/11Art178,161156/29/11Art136,107475/21/11Art561,150462/27/11Art191,870581/23/11Art378,349886/6/11Art237,898302/27/11Art549,508613/9/11Art223,095415/18/11Art457,037254/6/11Art135,414991/7/11Art482,867321/23/11Art167,551961/24/11Art390,763954/26/11Art123,341623/4/11Art521,508902/5/11Art522,255715/29/11Art522,576736/28/11Art178,295645/6/11Art513,865505/30/11Art286,717935/2/11Art170,896175/18/11Art417,978343/9/11Art380,527191/9/11Art147,739366/24/11Art487,537511/4/11Art423,924825/17/11Art151,626175/27/11Art444,140722/3/11Art299,064375/17/11Art563,120594/27/11Art582,819385/6/11Art537,78373

Formula PreciosCampo calculadoOrden de resolucinCampoFrmula1Precio medio=Facturacin/UnidadesElemento calculadoOrden de resolucinElementoFrmulaNotas:Cuando una celda se actualiza con ms de una frmula,el valor lo establece la frmula con la ltima orden de resolucin.Para cambiar el orden de resolucin de varios elementos o campos calculados,en la ficha Opciones, dentro del grupo Clculos, haga clic en Campos, elementos y conjuntos y luego haga clic en Orden de resolucin.