Take advantage of Excel Power Pivot and enable write-back to your data warehouse

Leave a comment

Employee Budgeting

Load your HR FTE and part-time into the model.


Highlight the cells you want to change, and use the Power Planner Calculate function to give % increase to employees.


it supports any type of arithmetic function, with audit trail.


Leave a comment

Edit SQL Tables in Excel

Add new members on the fly.

In the Power Planner Ribbon, you can open any SQL table, edit the members, add new products on the fly, and reprocess the model.


  • Just click ‘Open’


Select the table to edit. New members are automatically added to the Budget model.


Click Insert Row, and Save the table and the model is regenerated.


Enable write-back on any Pivot Table with Power Plannner

Any Pivot Table you can now turn into a Budgeting, Forecasting or Planning solution!

    Get Started:

  • Install Power Planner
  • Enable Cell Editing in the Pivot Table
  • Budget and Forecast on any new or existing model


Enjoy Features:

– Multi User Budgeting and Forecasting Features

– Goal Seeking on any number

– Even and Seasonal Allocations

– Revenue Forecasting

– HR Budgeting

– Capital Expenditure

– Driver based planning

– Collaboration and commenting

Go to our website for more information.

Leave a comment

Powerful Goal Seeking

With Power Planner, you can take advantage of the Goal Seeking Feature. In this example we want seek a new amount for the number of units sold in order to read our targeted Gross Profit:

Set the Number of Units as the Target for the Goal Seeking:

Go to the P&L and adjust your Gross Profit to $13MM.


Your number of units have now been adjusted to meet the new Gross Profit Target!


You are now empowered to budget and forecast.

Leave a comment

Power Planner is Easy

Enable any Pivot Table as your Budgeting Solution

Excel Pivot Tables are still by far the preferred analytics tool for corporate America. A lot of companies have invested heavily in SQL and Pivot Tables.

Make it a Budget System:

With Power Pivot you can make your Pivot Solution into a budgeting solution with the click of a button: Here is how to get started:

  • Install Power Planner
  • Log on to the Pivot Table
  • Click Enable Editing.

Voila – you can now use your Excel Pivot Tables as a Budgeting System from inside Excel for everybody in your organization.

We provide pre-built solutions for Microsoft Dynamics GP/AX/NAV, MAS 500, Salesforce Data.

Lear more at http://www.power-planner.com or email info@power-planner.com