What-if analysis tools (goal seek & data tables) for Sheets.
Listing updated:26. september 2022
Works with:
13 tis.+
Pregled
Ponder is a what-if analysis add-on for Google Sheets. What-if tools allow you to explore the potential results of your spreadsheet formulas.

► GOAL SEEK
 
With the Goal Seek tool, you can determine the input necessary to achieve your desired result (i.e. goal). Goal seeking is commonly used to answer what-if scenarios such as:

◆ How large of a mortgage can I get if I want my payments to be $1000/month? 
◆ What rate do I need if I want to pay $200/month on my auto loan? 
◆ How many items do I need to sell to break even?

► DATA TABLES

With Data Tables, you can quickly create a set of results based on one or two input variables. For example, using the PMT formula, you can quickly create a table showing:

◆ Mortgage payments at various rates
◆ Or, mortgage payments at various rates across different starting loan sizes

** Ponder currently only supports Goal Seek and Data Tables, but I plan to add other what if analysis tools (e.g. scenario manager) soon. ** 

You can help support the development of this add-on by buying me a coffee: https://www.buymeacoffee.com/sheetsify
Additional information
PricingNi na voljo
Developer
Pravilnik o zasebnosti
Pogoji storitve
Ponder will ask for the permissions shown below. Learn more
Ponder will need access to your Google account
This will allow Ponder to :
Ogled in upravljanje preglednic, v katerih je nameščena ta aplikacija
Prikazovanje in izvajanje spletne vsebine tretjih oseb v pozivih in stranskih vrsticah v Googlovih aplikacijah
Ogled glavnega e-poštnega naslova računa Google
Ogled osebnih podatkov, vključno z osebnimi podatki, ki ste jih dali javno na voljo
Mnenja
Language:
Razvrsti po:
Google ne preverja mnenj ali ocen. Več informacij o mnenjih
No comments
Iskanje
Počisti iskanje
Zapiranje iskanja
Googlove aplikacije
Glavni meni