Round a number to a specified decimal precision
JSON.parse with bigints support
Support for representing 64-bit integers in JavaScript
An arbitrary-precision Decimal type for JavaScript.
Convert values with PostCSS (e.g. ms -> s)
Round a number to a specific number of decimal places: `1.234` → `1.2`
Implements performance.now (based on process.hrtime).
The RAW rational numbers library
Calculate percentages from a list of values.
Node.js JSON replacement which handles 64-bit integers and arbitrary-precision decimals.
An arbitrary-precision Decimal type for JavaScript.
Test if two floats are almost equal
Shim for process.hrtime in the browser
Work with large numbers on the client side. Round them off to any required precision.
Find the decimal precision of a given number
safely inject a block of tokens into a shader
JavaScript string formatting utilities for Vega.
An arbitrary length unsigned integer formatter library for Node.js
Perform addition, subtraction, multiplication and division operations precisely using javascript
Remove meaningless precision from GeoJSON
TypeScript definitions for moment-round
Set of practical webgl utils
Convert a double-precision floating-point number to the nearest single-precision floating-point number.
unit bezier curve interpolation
Splittable solves the common problem of dividing monetary values where the sum of rounded installments doesn't equal the original total. It ensures precise financial calculations by truncating values to the specified precision and attributing any difference to the first installment. Perfect for e-commerce payments, invoice distribution, and subscription billing.
Control of IEEE compliant FPUs rounding mode and precision
# 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)