sutoiku / formula.js Goto Github PK

http://stoic.com/formula 404s.

the formula works fine in ie9 but i cannot get it to work in ie8 gets
'Object doesn't support property or method 'indexOf'' now it says the error is in the jquery included file, but i am sure it has to do with something in forumula.js.

link for reference: http://go.segalco.com/xylem/calc/index.html
thanks,

Hi

I think that in bower.json file 'rm-jstat' package should be replaced with 'jstat' library.

Could you also check number of version and dependencies packages in files package.json and bower.json ?

It would be nice to have this library as npm package with dependencies

I noticed the following issues with AVERAGEIF and SUMIF not behaving like the implementation in Excel:

1. AVERAGEIF / SUMIF assumes the cells are numeric for both the range and criteria. It will not successfully compare to text cells.
2. The criteria parameter requires an operator... there is no implied equals.

Given this example spreadsheet...

...here's the result of some formulas we could write:

A few notes:

• These issues occur whether or not the third optional parameter is used.
• There are a few more minor differences, but I wouldn't consider them as high of a priority, since they are less commonly used. They include:
  • this implementation doesn't handle wildcards
  • this implementation accepts non-range values, whereas the implementations used in excel and google sheets do not.

FREQUENCY() is giving me weird results. I feed in 5 numbers as data, i.e. [ 4, 5, 5, 7, 10 ] and my bins are [ [ 4, 6 ], [ 6, 8 ], [ 8, 10 ], [ 10, 12 ], [ 12, 14 ] ] and I get back [ 1, 2, 0, 1, 0, 1, 0, 0, 0, 0, 0 ].

So with 5 items and with 5 buckets I get 11 values back. This is not how FREQUENCY works in Excel.

Any ideas?

edit: quick fix with lodash (note that if value is same as upper bin value, it will be moved to the next bin):

var frequencies = []
    _.each(bins, b => {
        var frequency = 0
        _.each(values, v => {
            if(b[0] <= v  && b[1] > v) {
                frequency++
            }
        })
        frequencies.push({bin: b, frequency: frequency})
    })

https://travis-ci.org/sutoiku/formula.js

Dear @psq , @hmalphettes , @miguelvps , @joaojeronimo , @Y--

I hope you are well and my best wishes for 2020,

I have an issue #josdejong/mathjs#1699

And maybe you could help me with your library.

Topic translate from different protocols formula .

One of the properties is "Formulas".

Formulas ( Rx / Tx)

• Formulas provide a way to project values received from an equipment to another value range or representation.
• For example, an equipment might send gain values as INTEGERs ranging from 0 to 65535, while the actual gain range in is -64db to 12db. Obviously, the user of a front-end application prefers to deal with the gain values in db instead of the technical INTEGER range.
• To accommodate for this need, I am looking to provides the concept of formulas.

• This will create a basic formula which does not alter the input value – meaning it returns the identity of the input value:

Picture from ww.lawo.de

• The input value of the formula is denoted with the symbol $. You can use this symbol in an arithmetic expression which yields the desired output range.
• The line “$ =“ defines the input value (as sent by the device) of the formula.
• The following line “RX($) =“ defines the expression used to convert values that have been received from the device.
• The following line “TX($) =” defines the expression used to convert values that are about to get sent to the device. This expression has to reverse the projection made in the RX expression.

• To follow the ifSpeed example, let’s display the speed of the interface in megabytes per second instead of bits per second:
o Enter a test input value in the “$ =” field, e.g. “10000000” (10 megabit)
o Enter the expression $ / 8000000.0 into the “RX” field. 8000000 is the factor used to turn unit bits into unit megabyte.
o To reverse the RX expression, enter the expression $ * 8000000.0 into the “TX” field.
o You will now see the following:

Picture from www.lawo.de

o You can see that the result of the RX expression is 1.25 (megabytes) and the result of the TX expression, which uses 1.25 as input value, is 10000000 (bits per second, which is equal to the input value of the RX expression).

INPUT RANGE

• I have an Analog to Digital convert 12 bits (4096 positions)
• The manufacturer of the A/D converter infor you for 0 = -128dB and for 4095 = +15 dB

I am looking to create as above "Formula" with possibility to select linear or log the Rx and Tx formula.

Data model of my paramater

{
                    "identifier": "ParameTypeStream",
                    "description": "Stream PPM MAIN",
                    "value": 0,
                    "minimum": -4096,
                    "maximum": 480,
                    "access": "read",
                    "format": "%8.2f°",
                    "enumeration": "",
                    "factor": 32,
                    "isOnline": true,
                    "default": -1024,
                    "type": "integer",
                     "formula": "1000*\n1000/"
                }

The properties : formula

The Minimum & Maximum are :

"minimum": -4096,
"maximum": 480,

Then I need to generate the correct formula for Rx & Tx.

Regarding formula "1000\n1000/"*

That means when the client receives this properties the "/n" is the separation from RX formula then TX formula then no needs two properties

Here :

RX = value *1000
TX = value /1000

Use case - write the formula - RX

1. the client introduces the formula in an editbox. Just the '$' indicates the value I need to passing into the math expression and get the result.

Use case - write the formula - TX

If the RX formula is already written in the editbox , I need and expect with Mathjs library to generate the invert formula for TX and vice-versa if Tx is filled, then I got RX.

If RX = $/1000
then I need to get for TX = $*1000

The formula could be complex (log, square, ^, (expression)*log) I attached a document from my friend written for F# (Microsoft) long time ago and now we are using nodejs and javascript.

Ember+ Formulas.pdf

I hope you could make a simple example of code how to use it and then I will try it ;-)

Best Wishes for 2020
Youssef

All 24 of them

https://nodesecurity.io/check/formulajs

There are two issues and both tie back to old versions of uglify-js. old jstat lists uglify-js as a dependency, new versions correctly list as dev dependency. Can you update to latest version?

This function does not appear to be working correctly
In FormulaJS:
BETADIST(1/52,0.4,9.6)
FormulaJS = 9.966606842186747
Excel = 0.540601367

Could some one check this out for me.

http://www.stoic.com/formula

It says:

502 Bad Gateway

nginx/1.4.6 (Ubuntu)

The docs are missing.
How would you use this with EtherCalc ?

Also, could one add functions like: importxml or importhttp (like in google spreadsheets) ?

Dear Sutoiku team @Y-- @AurelienRibon

I started a Github organization to be the future home of Formulajs. The aim is to federates contributions around the project and continue the development and maintenance of the library.

First action was to relaunch a documentation website based on the work you did back in 2015. You can see the result here: https://formulajs.info

The roadmap in the coming month is to gather the improvements made in the main forks of the original project. I started from the Handsontable fork, which seemed to be the most lively project.

If you agree with the new dynamic, I would like to make pull request on your repo to mark it as deprecated and redirect it to the one of the Formulajs organisation. That would also be a pleasure to welcome you as member of this new community.

I look forward hearing from you. Thanks again for the heavy work you did, building this great library!

Nicolas

Hi,

I would like to bring formula.js an hosted CDN repository (for example: https://cdnjs.com or http://www.jsdelivr.com). This might imply some updates of the repository:

• build files included in the repository
• reduce slightly the number of dependencies (maybe include bessel into the code) and let numeral, numeric and jStats as external dependencies.

I am ready to create a pull request in this direction and wonder if would fit the current guidelines of the library development?

Thanks in advance.
Nicolas

I'm having trouble evaluating SUBTOTAL formulas, as the parser leaves them without brackets/parentheses, i.e.:

SUBTOTAL(9, 5,1)

while the demo page (https://formulajs.info/functions/) requires brackets, i.e.:

SUBTOTAL(9, [5,1])

What gives? Thanks.

When I run "make build" then I get 4 files in the dist directory. In this directory I get a formula.js and formula.standalone.js which are identical when I diff them.

Is this the process for producing a build for the browser or am I missing something?

There should be a

future = (typeof future === 'undefined') ? 0 : future;

at the beginning of the function

The websitestoic.com/formula is not found.

I was going to ask about DAVERAGE and friends. I see the code but it doesn't show up in http://www.stoic.com/pages/formula?type=database

Also, the github link on the webpage points to https://github.com/sutoiku/FormulaJS and 404s. I think it probably should say https://github.com/sutoiku/Formula.JS

i write a demo by README sample.

<!-- Numeric -->
<script src="https://cdnjs.cloudflare.com/ajax/libs/numeric/1.2.6/numeric.min.js"></script>
<!-- Numeral.js -->
<script src="https://cdnjs.cloudflare.com/ajax/libs/numeral.js/1.4.5/numeral.min.js"></script>
<!-- jStat -->
<script src="https://cdn.jsdelivr.net/jstat/latest/jstat.min.js"></script>

<!-- Finally add formula.js -->
<script src="local-formula-path/formula.js"></script>

<script>
    
        window.onload = function()
        {
            formulajs.NORMDIST(21.2366,formulajs.AVERAGE(22.3016,21.2366), formulajs.STDEV(22.3016,21.2366),1);
        }
    </script>

but throw an exception

Uncaught TypeError: Cannot read property 'normal' of undefined
    at Object.exports.NORM.DIST [as NORMDIST] (formula.js:6481)
    at window.onload (excel.html:25)

it seems to the exception because jstat..

First off, really nice work!

The website says

JavaScript implementation of all functions supported by Microsoft Excel

But I don't find NEGBINOM.DIST or NEGBINOMDIST anywhere in the sections. I would have expected it to be here: http://www.stoic.com/pages/formula?type=statistical

hey, I know this is an OpenOffice port, but I noticed that the implementation doesn't return the same PMT as Excel.

(Excel Example)
rate | time | principle | pmt |  
0.1 | 12 | 2000 | ($293.53) | =PMT(A2,B2,C2)

exports.PMT = function(rate, periods, present, future, type) {
      //formula:
      //PMT = PV x IR / (1 - (1 + IR) -NP)
      //converted to js:
      //PMT = (PV * IR) / (1 - Math.pow(1 + IR, -NP))
      //(ir,np,pv) =>{//(rate, time, principle)
  let pay = (present * rate) / (1 - Math.pow(1 + rate, -periods));
  return -pay;
  //your implementation goes on for additional  work but this was all I needed for mine

I'm comparing the values to an Excel sheet calculating PMT from $100-$5000 for a time period of 1-18 months and the above PMT lines up with Excel through the whole sheet.

Also, though this isn't technically an Excel function, I also use .toMoney to format like excel:

// eslint-disable-next-line
Number.prototype.toMoney = function(decimals, decimal_sep, thousands_sep)
{
     var n = this,
     c = isNaN(decimals) ? 2 : Math.abs(decimals),
     d = decimal_sep || '.',
     t = (typeof thousands_sep === 'undefined') ? ',' : thousands_sep,
     sign = (n < 0) ? '-' : '',
     // eslint-disable-next-line
     i = parseInt(n = Math.abs(n).toFixed(c)) + '',
     // eslint-disable-next-line
     j = ((j = i.length) > 3) ? j % 3 : 0;
     return sign + (j ? i.substr(0, j) + t : '') + i.substr(j).replace(/(\d{3})(?=\d)/g, "$1" + t) + (c ? d + Math.abs(n - i).toFixed(c).slice(2) : '');
}

Reference: #30 (comment)
Not in Excel and difficult to package.

When does the below formulas will get implemented in formulajs:
COUPPCD
COUPNCD
PRICE
YIELD

The Documentation is lacking to the point that i am not sure what i need to do to allow this to run on my site. I keep getting the require error. I am sure i need to install something else but if there is more requirements can they please be listed and possibly a simple example would be great. Looks like i need WebPack and Node.JS to get this to run but how would i install it to my project.

Thanks for clarifying on the NEGBINOM issue.

There are bessel functions in Excel (BESSELJ, BESSELY, BESSELI, BESSELK), but according to

Hi,
I am trying to use the FINV and i get different results using formulaJs and excel.
FINV(0.05,8,22) gives
0.319 in Formula.js and
2.3965 when used in Microsoft Excel.
Am i doing anything wrong?
Thanks
Azeet

The function below uses jStat.normal which doesn't appear to be in the latest version.

 Formula.NORMSDIST = function (z, cumulative) {
      return (cumulative) ? jStat.normal.cdf(z, 0, 1) : jStat.normal.pdf(z, 0, 1);
    };

Hi,

Great work on the library. Do you have any plans to add the LOOKUP functions from EXCEL?

Thanks

I can't access to website's document.

Hi, I'm using your library within my custom calculators which are built in React.js. When I build and run my project, I get an error : 'cannot set property 'jStat' of undefined'. I suspect that jStat is trying to set a global variable which interferes with how React.js works under the hood. Did anyone run into such an issue before? Where are you implementing jStat? Thank you

I just found formula.js last week and I am very appreciative of the work that you guys have done to make working with formula easier for the rest of the JS world. I do want to bring to your attention some trouble with getting the library to work.

I followed the instructions and included the latest version of every dependency. When I tried to load the page, the code is throwing an exception on line 3303:

CORREL = jStat.corrcoeff;

The problem is that jStat is undefined. It seems that the namespace for jstat has changed from jStat to jstat in version 1.0.0. Also, a bunch of functions seem to have been moved. I am able to get the code to work if I include the jstat.js file from stoic.com. I am hoping that one of you might have a quick solution for this problem. If not, it might be helpful to update the dependency section to direct people to download the old version of jstat. Let me know if I can assist in fixing this problem.

The following sum function allows the user to send in:

• a set of individual numbers,
• an array of numbers,
• both an array and a set of numbers

and then the function returns the total.

**Note: the function does not check for letters or special characters. It just skips over them.

function SUM(){
var nums = [], res = 0;
for(var i in arguments){
if(Object.prototype.toString.call( arguments[i] ) === '[object Array]'){
// This line will allow multidimensional arrays to be converted to a single dimension array
nums = nums.concat(arguments[i].toString().split(','));
}
if(Object.prototype.toString.call( arguments[i] ) === '[object Number]'){
nums.push(arguments[i]);
}
}
for(var i=0; i<nums.length; i++){
if(isNaN(nums[i]))continue;
res += Number(nums[i]);
}
return res;
}

// Examples

SUM( 5,10,15 ) // Result: 30
SUM( [5,10,15] ) // Result: 30
SUM( 1,1,[5,10,15],3 ) // Result: 35
SUM( a, 1, 3 ) // Result: 4

I noticed that REGEXEXTRACT can't handle capture groups. Google handles this as you can see here https://support.google.com/docs/answer/3098244

In their example,
text = "(Content) between brackets"
regex = '(([A-Za-z]+))'

returns
'Content'

I think that if the match call returns more than one element in the array then the first value should be returned instead of the entire match.

Current impl

    Formula.REGEXEXTRACT = function (text, regular_expression) {
      var match = text.match(new RegExp(regular_expression));
      return match ? match[0] : null;
    };

Proposed

    Formula.REGEXEXTRACT = function (text, regular_expression) {
      var match = text.match(new RegExp(regular_expression));
      return match ? (match[match.length > 1 ? match.length - 1 : 0]) : null;
    };

i use cumipmt function as disaply in formula.js when it's given right answer when i put month like 1 month 2 month (in int format) but when i pass 1.5, 2.5 then give me a wrong answer . when i compare this answer to excel sheet then i found formula.js return wrong answer
please help !!!!

No update in months and 4 open pull requests ...

Hi, I'm trying to "use" the demos (function.html) in the repo but this file is missing http://stoic.cloudfoundry.com/public/run2.js. In the website this file is missing http://stoic-dev.cfapps.io/public/require.js
Thanks.

I want to use Sourcegraph for formula.js code search, browsing, and usage examples. Can an admin enable Sourcegraph for this repository? Just go to https://sourcegraph.com/github.com/sutoiku/formula.js. (It should only take 30 seconds.)

Thank you!