Closed

SQL Energy calculation

This project received 12 bids from talented freelancers with an average bid price of $629 AUD.

Get free quotes for a project like this
Employer working
Skills Required
Project Budget
$250-$750 AUD
Total Bids
12
Project Description

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.

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online