Title: ASARI Calculators
Author: asari-software
Published: Октябрь 4, 2026
Last modified: Октябрь 4, 2026
---
Search plugins
# ASARI Calculators
By [asari-software](https://profiles.wordpress.org/asaricrm/)
[Download](https://downloads.wordpress.org/plugin/asari-calculators.1.0.1.zip)
* [Details](https://os.wordpress.org/plugins/asari-calculators/#description)
* [Reviews](https://os.wordpress.org/plugins/asari-calculators/#reviews)
* [Installation](https://os.wordpress.org/plugins/asari-calculators/#installation)
* [Development](https://os.wordpress.org/plugins/asari-calculators/#developers)
[Support](https://wordpress.org/support/plugin/asari-calculators/)
## Description
[ASARI](https://asaricrm.com/) Calculators adds a spreadsheet editor to WordPress
and connects it to the Contact Form 7 forms you already use, so you do not need
to rebuild them in a separate form builder. You model the calculation the way you
would in a spreadsheet: values and formulas such as `=ROUND(B2*B3,2)` or `=IF(B4
>0,B2/B4,0)` in a grid of cells, edited under **ASARI Calculators** in the admin
menu. Then you bind cells to form fields by adding a class such as `b2-edit` to
an input or `b7-read` to a result. Results update live as visitors type, are sent
in the Contact Form 7 email, and follow Polish and English number formats.
The plugin requires [Contact Form 7](https://wordpress.org/plugins/contact-form-7/).
Until Contact Form 7 is installed and active, an admin notice is shown and calculators
are not loaded on the site.
#### Example calculator
The **Add example calculator** button at the top of the ASARI Calculators screen
creates a ready-made loan or lease instalment calculator (amount, annual interest
rate, number of months monthly instalment, total cost, total interest) together
with its Contact Form 7 form. The calculator then shows the form shortcode to paste
into a page, with a Copy button and a link to edit the form. Labels are created
in the site language. The button is shown until the example calculator exists.
#### Connecting a calculator to a form
Mark the form with the calculator ID, in one of these ways:
* add the `html_class` attribute to the form shortcode: `[contact-form-7 id="123"
html_class="asari-calculator-asari-calc-1"]`,
* or wrap the fields in the form template: ` ...
`,
* or, outside Contact Form 7 markup, use `data-asari-calculator="asari-calc-1"`
on a parent element in the page content.
Then bind fields or text elements to cells with classes (in Contact Form 7 tags
use the `class:` option, e.g. `[number salary class:b3-edit]`):
* `b3-edit` writes the field value into cell B3 before calculation.
* `b27-read` displays the calculated value of cell B27. Read fields are made read-
only, so their values are still sent with the form.
* A read list, radio or checkbox selects the option that matches the result, either
the same text (`High`) or a label that reads as the same number (`Yes - ...`
for 1, `1,67%` for 1.67). The other options are locked, and the selected one
is sent with the form. A single checkbox is checked when the result is not 0.
Results update live while visitors fill in the form, and the calculator also recalculates
when the page loads, immediately before the form is submitted and after Contact
Form 7 resets the form.
#### Formulas
A cell starting with `=` is a formula. Supported syntax:
* cell references and ranges: `B1`, `B1:B4` (case-insensitive),
* numbers and text in double quotes: `12.5`, `"yes"` (write `""` for a quote inside
text),
* arithmetic: `+ - * / % ^`,
* comparisons: `= <> < > <= >=` (also `==` and `!=`),
* logic: `&&`, `||`, `!`, `TRUE`, `FALSE`,
* functions: `SUM`, `AVERAGE` (`AVG`), `MIN`, `MAX`, `ROUND`, `ABS`, `CEIL`, `FLOOR`,`
IF`,
* argument separator: `,` or `;`.
Examples: `=B1*2`, `=SUM(B1:B4)`, `=ROUND(B1/12,2)`, `=IF(B1>0,B1,0)`, `=IF(B3>5000,"
high","low")`.
Formulas are evaluated by the plugin’s own parser; they cannot run JavaScript. A
formula that cannot be parsed shows an empty value.
#### Numbers in Polish and English
Field values are read in both Polish and English formats: `1 000,50`, `1.000,50`
and `10,000.50` all work, a label such as `Basic - 250 zł` becomes 250, `-5 zł`
becomes -5 and `1,67%` becomes 1.67. Labels starting with `Tak` / `Yes` / `True`
become 1, and `Nie` / `Bez` / `No` / `False` become 0. A single separator followed
by three digits (`1,234`) follows the site language: on a Polish site `1,234` is
1.234 and `1.234` is 1234, on an English site the other way round. Number inputs
are always read exactly.
Results in text fields and elements use the site decimal point, e.g. `7147,39` on
a Polish site; number inputs always get `7147.39`. Use the `asari_calculators_number_format`
filter to add a thousands separator, e.g. `array( 'decimal' => ',', 'thousands'
=> ' ' )` for `7 147,39`.
The plugin includes a Polish translation (used on WordPress 6.8 and later); WordPress.
org language packs take precedence when available.
## Screenshots
[⌊Calculator editor with the example loan calculator: a grid of values and formulas,
the formula bar with the calculated value, and the Contact Form 7 shortcode with
a Copy button.⌉⌊Calculator editor with the example loan calculator: a grid of values
and formulas, the formula bar with the calculated value, and the Contact Form 7
shortcode with a Copy button.⌉[
Calculator editor with the example loan calculator: a grid of values and formulas,
the formula bar with the calculated value, and the Contact Form 7 shortcode with
a Copy button.
[⌊The Contact Form 7 form of the example: fields are bound to cells with b2-edit
and b7-read classes inside the calculator wrapper.⌉⌊The Contact Form 7 form of the
example: fields are bound to cells with b2-edit and b7-read classes inside the calculator
wrapper.⌉[
The Contact Form 7 form of the example: fields are bound to cells with `b2-edit`
and `b7-read` classes inside the calculator wrapper.
[⌊The calculator on a page: results update as the visitor types and are sent with
the form.⌉⌊The calculator on a page: results update as the visitor types and are
sent with the form.⌉[
The calculator on a page: results update as the visitor types and are sent with
the form.
[⌊A second calculator with an IF formula that returns text, used to fill a read
field.⌉⌊A second calculator with an IF formula that returns text, used to fill a
read field.⌉[
A second calculator with an `IF` formula that returns text, used to fill a read
field.
## Installation
1. Install and activate Contact Form 7.
2. Upload the `asari-calculators` folder to `/wp-content/plugins/` or install the
plugin from the Plugins screen, then activate it.
3. Go to **ASARI Calculators** and click **Add example calculator**, or build your
own calculator and save it.
4. Mark a Contact Form 7 form with the calculator ID and add `bN-edit` / `bN-read`
classes to its fields.
## FAQ
### Does the plugin load scripts on every page?
No. The frontend script and style load only on requests that render a marked Contact
Form 7 form or contain a calculator marker in the page content, and only the calculators
used there are printed into the page.
### Can results be calculated only when the form is submitted?
Yes. Return `false` from the `asari_calculators_live_recalculation` filter; the
calculator then recalculates only on page load and before submission.
### What happens to my calculators when I delete the plugin?
Deleting the plugin from the Plugins screen removes all calculators (the `asari_calculators_data`
option, on every site of a multisite network). Deactivating keeps them.
### My calculator is inserted in a way the plugin does not detect.
Use the `asari_calculators_enqueue_all_frontend_calculators` filter (return `true`)
to load all calculators, or `asari_calculators_frontend_calculators` to choose them
for the current page.
## Reviews
There are no reviews for this plugin.
## Contributors & Developers
“ASARI Calculators” is open source software. The following people have contributed
to this plugin.
Contributors
* [ asari-software ](https://profiles.wordpress.org/asaricrm/)
[Translate “ASARI Calculators” into your language.](https://translate.wordpress.org/projects/wp-plugins/asari-calculators)
### Interested in development?
[Browse the code](https://plugins.trac.wordpress.org/browser/asari-calculators/),
check out the [SVN repository](https://plugins.svn.wordpress.org/asari-calculators/),
or subscribe to the [development log](https://plugins.trac.wordpress.org/log/asari-calculators/)
by [RSS](https://plugins.trac.wordpress.org/log/asari-calculators/?limit=100&mode=stop_on_copy&format=rss).
## Changelog
#### 1.0.1
* Changed: The plugin description links to the ASARI website (asaricrm.com).
#### 1.0.0
* Added: **Add example calculator** button that creates a loan instalment calculator
with its Contact Form 7 form; calculators linked to a form show its shortcode
with a Copy button and an Edit form link.
* Added: Contact Form 7 is a required plugin (`Requires Plugins` header); when
it is missing or inactive, an admin notice links to install or activate it and
calculators are not loaded on the frontend.
* Added: Calculators load automatically for Contact Form 7 forms inserted with
the shortcode or block, marked with `html_class` or a wrapper element in the
form template.
* Added: The browser warns before leaving the ASARI Calculators screen with unsaved
changes (edits, added or deleted calculators); saving does not trigger the warning.
* Fixed: Deleting the last calculator and saving now leaves the list empty instead
of bringing back the default calculator.
* Fixed: Read lists, radios and checkboxes select the matching option and are sent
with the form (they were disabled and missing from Contact Form 7 emails, and
radio and checkbox groups were replaced by plain text).
* Fixed: Saving a calculator that contained a double quote no longer replaces all
calculators with the default one; unreadable submitted data now keeps the previous
calculators and shows an error.
* Fixed: Formulas with `<`, `<>` and `<=` are saved unchanged instead of being
stripped or HTML-encoded.
* Security: Formulas are evaluated by a dedicated parser instead of being compiled
to JavaScript, so a formula can no longer execute code in visitors’ browsers.
* Added: Live recalculation while visitors edit bound fields (can be turned off
with the `asari_calculators_live_recalculation` filter); results are also restored
after Contact Form 7 resets the form.
* Added: `uninstall.php` removes the calculators when the plugin is deleted.
* Added: Polish and English number formats in field values (`1 000,50`, `1.000,50`,`
10,000.50`, `-5 zł`, yes/no words), results shown with the site decimal point,
and the `asari_calculators_number_format` filter.
* Added: Translatable editor interface and a bundled Polish translation.
* Changed: One shared formula engine for the editor and the frontend; cell references
are case-insensitive, `IF` evaluates only the selected branch, text in formulas
may contain non-ASCII letters, comparisons return 1 / 0 (usable in other formulas)
and a bare range outside a function is an error.
#### 0.1.0 – 0.1.3
* Internal development releases, not published.
## Meta
* Version **1.0.1**
* Last updated **1 бон ago**
* Active installations **Fewer than 10**
* WordPress version ** 6.5 or higher **
* Tested up to **7.1.2**
* PHP version ** 7.4 or higher **
* Language
* [English (US)](https://wordpress.org/plugins/asari-calculators/)
* Tags
* [calculator](https://os.wordpress.org/plugins/tags/calculator/)[contact form 7](https://os.wordpress.org/plugins/tags/contact-form-7/)
[forms](https://os.wordpress.org/plugins/tags/forms/)[formulas](https://os.wordpress.org/plugins/tags/formulas/)
[spreadsheet](https://os.wordpress.org/plugins/tags/spreadsheet/)
* [Advanced View](https://os.wordpress.org/plugins/asari-calculators/advanced/)
## Ratings
No reviews have been submitted yet.
[Your review](https://wordpress.org/support/plugin/asari-calculators/reviews/#new-post)
[See all reviews](https://wordpress.org/support/plugin/asari-calculators/reviews/)
## Contributors
* [ asari-software ](https://profiles.wordpress.org/asaricrm/)
## Support
Got something to say? Need help?
[View support forum](https://wordpress.org/support/plugin/asari-calculators/)