What-if analysis tools (goal seek & data tables) for Sheets.
Listing updated:2022 m. rugsėjo 26 d.
Works with:
13 tūkst.+
Apžvalga
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
PricingNepasiekiama
Developer
Ne prekiautojas
Paslaugos teikimo sąlygos
Ponder will ask for the permissions shown below. Learn more
Ponder will need access to your Google account
This will allow Ponder to :
Peržiūrėkite ir tvarkykite skaičiuokles, kuriose įdiegta ši programa
Rodykite trečiosios šalies žiniatinklio turinį „Google“ programų paraginimuose ir šoninėse juostose
Peržiūrėti pirminį „Google“ paskyros el. pašto adresą
Peržiūrėkite savo asmens informaciją, įskaitant bet kokią viešai pasiekiamą asmens informaciją
Įvertinimai
Language:
Rūšiuoti pagal:
„Google“ nepatvirtina apžvalgų ar įvertinimų. Sužinokite daugiau apie apžvalgas
No comments
Paieška
Išvalyti paiešką
Uždaryti paiešką
Google Apps
Pagrindinis meniu