business catalog article new catalog business opportunities finance catalog deposites money catalog making art loan catalog deposits making catalog your home good income catalog outcome issue medicine catalog drugs market catalog money trends self catalog roof repairing market catalog online secure catalog skin tools wedding catalog jewellery newspaper catalog for magazine geo catalog places business catalog design Car catalog and Jips production catalog business ladies catalog cosmetics sector sport catalog and fat burn vat catalog insurance price fitness catalog catalog furniture catalog at home which catalog insurance firms new catalog devoloping technology healthy catalog nutrition dress catalog up company catalog income insurance catalog and life dream catalog home create catalog new business individual catalog loan form cooking catalog ingredients which catalog firms is good choosing catalog most efficient business comment catalog on goods technology catalog business secret catalog of business company catalog redirects credits catalog in business guide catalog for business cheap catalog insurance tips selling catalog abroad protein catalog diets improve catalog your home security catalog importance

Recently in Plantillas Category

Esta plantilla es la que yo empleo para mi proyecto de Seminario de Finanzas.. Espero les sea util.

Anualidad.PNG

Anualidad.xlsx

Para calcular las cantidades necesarias a vender para estar en punto de equilibrio empleando solver.

1- Es necesario instalar el Complemento Solver.

  • Click en el botóton de office. Opciones de Excel
  • Complementos.
  • Complementos de Excel (Click en Ir)
  • En el recuadro marcar Solver y Aceptar.
  • Después de unos minutos se instala Solver y Aparece en menu Datos.

Solver1.PNG

Solver2.PNG

2- Es necesaria una referencia a Solver desde Visual Basic.

  • Desde la plantilla de excel (Alt+F11)
  • Se muestra el Editor de VBA de Excel
  • Selecciona Herramientas, Referencias.
  • Aparece un formulario con todas las bibliotecas disponibles.
  • Buscar y maracar Solver.
  • Listo ...

3- Para usar la plantilla solo es necesario introducir los nombres de los Articulos en forma de lista. El macro se activa al cambiar de hoja. En teoria en la hoja 2 es un estado de resultados, aqui se cambia los importes.

Solver3.PNG

PUNTO DE EQUILIBRIO CON SOLVER.xlsm

About this Archive

This page is an archive of recent entries in the Plantillas category.

Macros is the previous category.

Varios is the next category.

Find recent content on the main index or look in the archives to find all content.