Forum


Calc Builder Support

Calc Builder support
Forums
Public write access is disabled. Please login

Excel Calculator Import 17.12.2015 13:18

Hi
I have an Excel calculator that runs over 8 pages in sheet 0 and 2 pages in sheet 1. Both sheets are named and sheet 0 is both input and output while sheet 1 feeds certain constant values to sheet 0 and does calculations that feeds back to sheet 0.
Any suggestions on how I should start this off? There are quite a lot of specialized calculations involved and most of it is inter dependent.

Regards
Andre

Re: Excel Calculator Import 17.12.2015 19:52

Hi,
in order to configure the excel mapping for your calculation you only will need to take into account which are the inputs, that will be attached to the fields of your form, and the outputs, that you can print at the output section, you don't need to worry about internal calculations made by the excel, so, the steps would be:

- Create the fields (inputs) of your form at calcbuilder
- At the 'spreadsheet' option upload your excel sheet and map each field of your form to one cell of the sheet (of sheet 0 for your case).
- Now add to the 'ouput' mapping each output cell of your spreadsheet to one variable (you can name each one as you want)
- Print the output variables at the output section of your calculator.


We have a video at the demo section of the extension that shows how to create a calculator from an excel sheet, we suggest to check it first:

https://www.moonsoft.es/en/demo-calcbuilder-en

(Build a calculator from excel)

and let us know if you have any problem with any of the steps.

Thanks, regards
Moonsoft Team
www.moonsoft.es
Are you satisfied with our products/services/support?
Please help us to keep improving, add a review at  joomla extensions site and  magento connect
FaLang translation system by Faboba

Our clients' feedback