Creating a Calculator from .xmlx or Google Docs

  • Resolved ja152

    (@jdj)


    10 years ago

    Hi,

    I have an excel file with 2 sheets:
    – Data
    – Calculator

    Data: Contains 7 columns and 30 rows that serves as a data-source to the calculator, each cell dependent on the other and the 3 cells in the calculator sheet.

    Calculator: In this sheet I have 3 cells where the user can enter a custom value. And a 4th that shows the final result.

    How can I use this plugin to function with this setup? I have the calculator available in a .xmlx file or Google Spreadsheet.

    https://www.ads-software.com/plugins/calculated-fields-form/

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author codepeople

    (@codepeople)

    Hi,

    You cannot import your Excel file with its equations to our plugin in a straightforward way, you should recreate your project but using the operations and fields available in the plugin.

    Best regards.

    Thread Starter ja152

    (@jdj)

    Hi,

    Is it possible to create a table in the plugin with the 7 columns, 30 rows and 210 cells all with individual calculations? Otherwise I do not see a way to recreate it?

    Plugin Author codepeople

    (@codepeople)

    Hi,

    The Calculated Fields Form does not includes a control for tables, but you can emulate a table with <div> fields, and some custom class names, to display the fields, side by side.

    About create 210 cells, and all of them with an equation associated, it is possible, but the performance of your page can be compromised, because all equations are checked and evaluated after modify any field in the form.

    Best regards.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Creating a Calculator from .xmlx or Google Docs’ is closed to new replies.