PHPackages                             kidjapa/php-goalseek - PHPackages - PHPackages  [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register)

1. [Directory](/)
2. /
3. [Utility & Helpers](/categories/utility)
4. /
5. kidjapa/php-goalseek

ActiveLibrary[Utility & Helpers](/categories/utility)

kidjapa/php-goalseek
====================

A simple goalseek function for PHP. Using the goalseek function from Libre Office

1.0(5y ago)82.1k1MITPHPPHP ^7.1

Since Nov 5Pushed 5y ago2 watchersCompare

[ Source](https://github.com/kidjapa/Php-GoalSeek)[ Packagist](https://packagist.org/packages/kidjapa/php-goalseek)[ Docs](https://github.com/kidjapa/Php-GoalSeek)[ RSS](/packages/kidjapa-php-goalseek/feed)WikiDiscussions master Synced today

READMEChangelog (1)DependenciesVersions (2)Used By (0)

Php-GoalSeek
============

[](#php-goalseek)

- Php function to simulate Goal Seek from libre office using the Regula Falsi method.
- In most cases the result is equal of the Excel formula. Because the Excel do not show what formula are used in goal seak we need to use the similar function in Libre Office.
- Install

```
composer require kidjapa/php-goalseek
```

In Libre office
---------------

[](#in-libre-office)

- Function in archive: core/sc/source/coredata/dcoumen4.cxx

```
bool ScDocument::Solver(SCCOL nFCol, SCROW nFRow, SCTAB nFTab,
                        SCCOL nVCol, SCROW nVRow, SCTAB nVTab,
                        const OUString& sValStr,
                        double& nX
                        )
```

Sample
------

[](#sample)

```
$goalSeek = new SolveGoalSeek();

$getValue = 0;

$getValue = $goalSeek->seekGoal(
    function($value, $data){
        return sqrt($value);
    },
    16,  // The Actual Value
    20   // The Goal Value
);

echo "------------- results ------------- \n";
echo "Result: ".$getValue."\n"; // Expect: 400
```

###  Health Score

29

—

LowBetter than 60% of packages

Maintenance20

Infrequent updates — may be unmaintained

Popularity26

Limited adoption so far

Community9

Small or concentrated contributor base

Maturity48

Maturing project, gaining track record

 Bus Factor1

Top contributor holds 100% of commits — single point of failure

How is this calculated?**Maintenance (25%)** — Last commit recency, latest release date, and issue-to-star ratio. Uses a 2-year decay window.

**Popularity (30%)** — Total and monthly downloads, GitHub stars, and forks. Logarithmic scaling prevents top-heavy scores.

**Community (15%)** — Contributors, dependents, forks, watchers, and maintainers. Measures real ecosystem engagement.

**Maturity (30%)** — Project age, version count, PHP version support, and release stability.

###  Release Activity

Cadence

Unknown

Total

1

Last Release

2012d ago

### Community

Maintainers

![](https://www.gravatar.com/avatar/18a204450a05fe288b7cd2d78bbfa0e768b14cde845f57b22ad87c0786d1a6d6?d=identicon)[brunolkatz](/maintainers/brunolkatz)

---

Top Contributors

[![brunolkatz](https://avatars.githubusercontent.com/u/36176666?v=4)](https://github.com/brunolkatz "brunolkatz (17 commits)")

---

Tags

LibreOfficegoalseekcalc

### Embed Badge

![Health badge](/badges/kidjapa-php-goalseek/health.svg)

```
[![Health](https://phpackages.com/badges/kidjapa-php-goalseek/health.svg)](https://phpackages.com/packages/kidjapa-php-goalseek)
```

PHPackages © 2026

[Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)