Any SQL Database to provide a facility to upload and insert a data file into a SQL database.
Queries or stored procedures written against that database
Our customers will upload an excel file
Insert excel into SQL database, then based on criteria or inputs into the page we want queries written into this data.
I have attached an excel spreadsheet which We have had done to show you roughly what we need to achieve. Inside the spreadsheet are comments on how and what we require in purple coloured text boxes. The excel spreadsheet has many limitations and it is only to be used as a guideline only to show you what we need to do.
We want something which is easy to read and work with and is set out cleanly
INside the spreadsheet you will find the purple text boxes in the pages named "Datalog 1" This page is the excel which will be uploaded by our cutsomers- it will be in this exact format with the time and date in the one column. Pages named " Set Parameters and notes" have most of the purple text boxes- the yellow data are the fields our customer fills in to calculate the results from their entries. We want each entry to be exported into a document to form a report. Some customers might do 1 or 2 entries, some might do 10 or more entries based on the different data they enter into the field selection. Each entry we want to be able to press a button called Calculate and this then sends the info to the report form and keeps adding each entry down the page as
Page named "RESULTS" This shows 2 calculate buttons and the results and pie charts below is the data we need displayed along with 2 pie charts.
Please read all text boxes and im sure you will have some questions. We look forward to working with you.