Closed

SQL Energy calculation

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.

Skills: PHP, Software Architecture

See more: yellow software, what is selection criteria, we energy, sql data entry form, pie database, excel energy, sql database report, excel to sql, excel calculation, upload excel file php database, sql different, yellow page data file, php excel database report, data work yellow pages, excel date selection, date calculation, yellow pages entry work, excel upload sql database, insert sql, queries sql, upload excel sql, read text file insert database, php upload excel file database, excel spreadsheet customer form, criteria selection excel

About the Employer:
( 1 review ) Woonona, Australia

Project ID: #4281276

10 freelancers are bidding on average $605 for this job

marchingantssl

hi, Is it mysql or sql server?

$750 AUD in 30 days
(110 Reviews)
6.8
graphicaa

Dear sir.. we are anlaysing your details. can you give 30 minutes please. Thanks

$750 AUD in 10 days
(93 Reviews)
6.6
Linkbuild

Hi there, please open private message board for a more detailed proposal, looking forward to hear back from you, regards Ivan

$750 AUD in 15 days
(26 Reviews)
5.9
spcinc

Hi, sir! I can do it.

$750 AUD in 30 days
(3 Reviews)
4.6
SoftDevelopINC

Hello, May I help you to do this project? Please check pm for more [url removed, login to view]

$600 AUD in 15 days
(13 Reviews)
4.3
code827562

Hello. Very interesting project. There will be some challenges for me in it too. I am very interested doing this. Cheers!

$700 AUD in 10 days
(11 Reviews)
3.8
csanuragjain

hi i can do this contact if interested

$650 AUD in 25 days
(5 Reviews)
3.8
GT1002

I am interested

$750 AUD in 25 days
(1 Review)
1.9
ravinsjain1991

**************************************************************************************** Hello Sir, Lets explore the project requirements in detail. We are please to tell you that we are company of professional websi More

$600 AUD in 25 days
(0 Reviews)
0.0
naaziaansari

Respected Sir!!!! I've read you requirements and i'm ready to work with u... although we're new to freelancer but we've worked a lot in local markets.. so all i want is u to trust me.. and i wont let it down... for More

$550 AUD in 15 days
(0 Reviews)
0.0
irshadjan

let's start.

$450 AUD in 10 days
(0 Reviews)
0.0
zeesh49

Have extensive experience in the technologies required for this job. Will deliver on time and as per expectations. Hoping to hear from you soon. Zeeshan

$250 AUD in 30 days
(0 Reviews)
0.0