Exporting data from complex forms

I use online several online forms to screen patients for trauma, dissociation and other mental health issues. I then print out the results from Jotform and manually enter the data into a scoring sheet. Many of the responses are then divided into various factors, added up and then averaged. A lot of room for error as well as time consuming.

I have attached an example of a scoring sheet.

Can you advise how I might make a spreadsheet template and then automatically export data from form so all calculations are done and I end up with total and averaged scores

Thanks

It is not possible to create spreadsheet template inisde of JotForm, but you can download your submissions in Excel and then you can customize your Excel document.

How to Export Form Data to Excel 

If you want to perform calculation inside of your Excel this articles may help you:

https://support.office.com/en-us/article/Use-Excel-as-your-calculator-a1abc057-ed11-443a-a635-68216555ad0a 

https://support.office.com/en-us/article/Overview-of-formulas-in-Excel-ecfdc708-9162-49e8-b993-c311f47ca173 

We also have other type of reports: https://www.jotform.com/help/326-How-To-Create-Form-Reports-in-JotForm 

Just to mention that you can also perform calculation inside of your form:

https://www.jotform.com/help/259-How-to-Perform-Form-Calculation-Using-a-Widget 

Hope this will help. Let us know if you need further assistance.