Google Sheets Add-on: Send formula driven figures back to Anaplan

The idea would be to receive information from Anaplan, have the ability to update the information using editable inputs (e.g increase sales forecast by 10%) and then send the result (of Anaplan data * 10%) back to the Anaplan module.

1 Comment
johan_vangerwen
Frequent Contributor

Some use case to support the requirement:

  • Some users wants to have a more detailed planning than implemented in Anaplan and look for a solution in Excel to be combined with Anaplan. The cells for Anaplan should have a formula with sum/sumifs/lookup to the local excel modeled planning details.
  • Some parts of the planning process cannot be standarized. Think of contracts in real estate and in mining raw materials. Also think of tax planning where local tax regulation is something which is more not structured