# Is there a way to use an external matrix file with numbers to use as input with the " Calculation" widget or some alternative.

**winnie_jo**Hello is there a way to use an external matrix file with numbers to use as

input with the " Calculation" widget or some alternative.

*This is a re-post of a comment on How to Insert Text or Calculation into a Field Using Conditional Logic*- JotForm Support
**BDAVID**You can perform calculations with values obtained from an Input Table(matrix) field, please check this guide: https://www.jotform.com/help/343-How-to-Perform-Form-Calculation-in-the-Matrix-Field

- JotForm Developer
**gizem**I do not think this is possible. You can set conditions for the output fields or you can use the form calculation widget. But, you can not pass values to conditions/calculation widget from the spreadsheet.

I can suggest you set the Update Calculate Field condition/Form Calculation widget according to your spreadsheet.

Smart Forms Using Conditional Logic

How to Insert Text or Calculation into a Field Using Conditional Logic

How to Perform Form Calculation Using a Widget

Give it a try. If you encounter any problems, feel free to contact us. We will be glad to help.

- JotForm Support
**david**It is not possible to use an external sheet in conjunction with the form in order to produce calculation values. There would be no way to connect the sheet to the form. The closest thing we have that allows for an external document to interact with the form would be our submissions to spreadsheet widget:

https://www.jotform.com/help/442-How-to-Use-the-Spreadsheet-to-Form-Widget

But that only uses data from the sheet to populate form fields.

For your purposes, it would require using the tools available in the form. Setting up the calculations and such in an input table within the form, rather than in an external document would be the only option.

- JotForm Support
**BDAVID**It is still not clear to me what you are trying to accomplish, have you started to work in a form? Can you share the link, so we can take a look?

It seems like you were looking to perform calculations in a spreadsheet, you may try the Spreadsheet widget: https://widgets.jotform.com/widget/spreadsheet

- JotForm Support
**BDAVID**Please check if this is what you mean: https://form.jotform.co/80917253126859

**winnie_jo**Ok Bdavid ! But I need the set up without the table matrix. Because there are sometimes more the 50 items in the top row and first columns a table becomes then to large for the window

A good solution would be to let user have to fill in 2 blank fields to get result for field 3.

like this example.

- JotForm Support
**Kevin_G**You can achieve what you shown on your screenshot, you can have two fields and perform the calculation in a third field that can be a Form Calculation widget.

On this guide you will find everything related to form calculations: https://www.jotform.com/help/259-How-to-Perform-Form-Calculation-Using-a-Widget

Thanks.

**winnie_jo**Kevin I dont think so after reading your link. How would you integrate and convert this spreadsheet data beneath into a formula as screen shot below.

Glass prices:

100 200 300 400 500 width cm(top row)

100 11 23 35 46 57 prices

200 21 33 45 56 67 prices

300 31 43 55 68 78 prices

400 41 53 65 78 89 prices

500 51 63 75 88 99 prices

Height cm (first column)

(As you can see in the matrix width is filled in by user as '200' see top row, height filled in by user as '300' see column left. This will give '43' as the price.

So the whole matrix table above is the data. Is it possible to convert all the data into a formula so it can be generated into a working calculation, as the screenshot example beneath. Please dont give a link be more specific.

- JotForm Support
**Victoria_K**Hello,

I was searching for an option for you, but it seems that we do not have any currently. We do have a

**Spreadsheet to Form Widget**to populate rows of a spreadsheet to form fields, but as I understand the range of prices you have is not very small. So, you will need to add lots of conditional statements or other calculations to automate the process.If you know the formula how prices are calculated based on height and width, we could try to re-create it for the form.

**Related guide: How-to-Use-the-Spreadsheet-to-Form-Widget**Let us know if you need further assistance.

Thank you.