A tool for parsing formulas and create reusable functions
Math and string formula parser.
Math and string formula parser.
Parses and compiles CSS nth-checks to highly optimized functions.
Formula parsing, dependency management, and calculation engine for Univer.
Formula parser
Formula editing UI for Univer Sheets.
Performance-enhanced formula engine plugin for Univer Pro.
Sheet formula services and calculation integration for Univer Sheets.
fast excel formula parser
Self-healing markdown. Intelligently parses and styles incomplete Markdown blocks.
Formula parser
Tokenize Excel formulas
Parse excel formula into a tree
Excel-style formula parsing, binding, compilation, and evaluation for bilig.
Formula parser
Diagnose stale cached XLSX formula values and recalculate XLSX formulas in Node.js without Excel, LibreOffice, or browser automation.
Recalculate ExcelJS XLSX workbook formulas in Node.js without Excel, LibreOffice, or browser automation.
Abstract syntax tree for excel formulas
Scoped ExcelJS formula recalculation package for Node.js without Excel, LibreOffice, or browser automation.
Recalculate SheetJS and xlsx workbook formulas in Node.js without Excel, LibreOffice, or browser automation.
Scoped SheetJS formula recalculation package for Node.js without Excel, LibreOffice, or browser automation.
Formula to detect the grade level of text according to the (revised) Dale-Chall Readability Formula (1995)
Jspreadsheet formula pro is a JavaScript software to parse spreadsheet-like formulas.
LXL (Like Excel) is a mini-language that mimics Microsoft Excel formulas. Easily extended with new constants and functions.
Calculates the geo distance between two locations using longitude and latitude using Haversine, Speherical or Vincenty formula. This is done using Math formulas without resorting to Active Record or SQL DB functionality
Calculates the haversine distance between two locations using longitude and latitude. This is done using Math formulas without resorting to Active Record or SQL DB functionality
Calculates the geo distance between two locations using longitude and latitude using Haversine, Speherical or Vincenty formula. This is done using Math formulas without resorting to Active Record or SQL DB functionality
This is a gem dedicated to parsing, manipulating and finding roots,extrema and inflection points of polynomials. It can solve polynomial equations with a degree up to 4 by implementing formulas for solving quadratic, cubic and quartic functions.
Amoskeag is a purely functional, statically-validated Domain-Specific Language (DSL) designed for high-security, sandboxed evaluation. It's perfect for: - Business Rules Engines (insurance underwriting, loan approval) - Template Engines (secure alternative to ERB with more power than Liquid) - Spreadsheet Formula Engines (Excel-like calculations) This gem provides native Ruby bindings to the Amoskeag library, compiled from Rust for maximum performance and security.
# Excel to Code [](https://travis-ci.org/tamc/excel_to_code) excel_to_c - roughly translate some Excel files into C. excel_to_ruby - roughly translate some Excel files into Ruby. This allows spreadsheets to be: 1. Embedded in other programs, such as web servers, or optimisers 2. Without depending on any Microsoft code For example, running [these commands](examples/simple/compile.sh) turns [this spreadsheet](examples/simple/simple.xlsx) into [this Ruby code](examples/simple/ruby/simple.rb) or [this C code](examples/simple/c/simple.c). # Install Requires Ruby. Install by: gem install excel_to_code # Run To just have a go: excel_to_c <excel_file_name> This will produce a file called excelspreadsheet.c For a more complex spreadsheet: excel_to_c --compile --run-tests --settable <name of input worksheet> --prune-except <name of output worksheet> <excel file name> See the full list of options: excel_to_c --help # Gotchas, limitations and bugs 0. No custom functions, no macros for generating results 1. Results are cached. So you must call reset(), then set values, then read values. 2. It must be possible to replace INDIRECT and OFFSET formula with standard references at compile time (e.g., INDIRECT("A"&"1") is fine, INDIRECT(userInput&"3") is not. 3. Doesn't implement all functions. [See which functions are implemented](docs/Which_functions_are_implemented.md). 4. Doesn't implement references that involve range unions and lists (but does implement standard ranges) 5. Sometimes gives cells as being empty, when excel would give the cell as having a numeric value of zero 6. The generated C version does not multithread and will give bad results if you try. 7. The generated code uses floating point, rather than fully precise arithmetic, so results can differ slightly. 8. The generated code uses the sprintf approach to rounding (even-odd) rather than excel's 0.5 rounds away from zero. 9. Ranges like this: Sheet1!A10:Sheet1!B20 and 3D ranges don't work. Report bugs: <https://github.com/tamc/excel_to_code/issues> # Changelog See [Changes](CHANGES.md). # License See [License](LICENSE.md) # Hacking Source code: <https://github.com/tamc/excel_to_code> Documentation: * [Installing from source](docs/installing_from_source.md) * [Structure of this project](docs/structure_of_this_project.md) * [How does the calculation work](docs/how_does_the_calculation_work.md) * [How to fix parsing errors](docs/How_to_fix_parsing_errors.md) * [How to implement a new Excel function](docs/How_to_add_a_missing_function.md) Some notes on how Excel works under the hood: * [The Excel file structure](docs/implementation/excel_file_structure.md) * [Relationships](docs/implementation/relationships.md) * [Workbooks](docs/implementation/workbook.md) * [Worksheets](docs/implementation/worksheets.md) * [Cells](docs/implementation/cell.md) * [Tables](docs/implementation/tables.md) * [Shared Strings](docs/implementation/shared_strings.md) * [Array formulae](docs/implementation/array_formulae.md)
RDocF95 is an improved RDoc for generation of documents of Fortran 90/95 programs. Differences to the original one are given below. <b>Enhancement of "parser/f95.rb"</b> :: The Fortran 90/95 parse script "parser/f95.rb" (In rdoc-f95, old name "parsers/parse_f95.rb" is used yet) is modified in order to parse almost all entities of the Fortran 90/95 Standard. <b>Addition of <tt>--ignore-case</tt> option </b> :: In the Fortran 90/95 Standard, upper case letters are not distinguished from lower case letters, although original RDoc produces case-dependently cross-references of Class and Methods. When this options is specified, upper cases are not distinguished from lower cases. <b>Cross-reference of file names</b> :: Cross-reference of file names is available as well as modules, subroutines, and so on. <b>Modification of <tt>--style</tt> option</b> :: Original RDoc can not treat relative path stylesheet. Application of this patch modifies this function. <b>Conversion of TeX formula into MathML</b>:: TeX formula can be converted into MathML format with --mathml option, if <b>MathML library for Ruby version 0.6b -- 0.8</b> is installed. This library is available from {Bottega of Hiraku (only JAPANESE)}[http://www.hinet.mydns.jp/~hiraku/]. See {RDocF95::Markup::ToXHtmlTexParser}[link:classes/RDocF95/Markup/ToXHtmlTexParser.html] about format. <b>*** Caution ***</b> Documents generated with "--mathml" option are not displayed correctly according to browser and/or its setting. We have been confirmed that documents generated with "--mathml" option are displayed correctly with {Mozilla Firefox}[http://www.mozilla.org/products/firefox/] and Internet Explorer (+ {MathPlayer}[http://www.dessci.com/en/products/mathplayer/]). See {MathML Software - Browsers}[http://www.w3.org/Math/Software/mathml_software_cat_browsers.html] for other browsers. Some formats of comments in HTML document are changed to improve the analysis features. See {parse_f95.rb}[link:files/lib/rdoc-f95/parsers/parse_f95_rb.html]