Fermé

Build me an SQL version of an excel spreadsheet

I have a spreadsheet that is getting very busy and I need to move it now to SQL and then have a web page reporting the data.

I need this excel sheet to log the information direct to MSSQL server for the reporting.

I need the vehicles to each have an individual trackable with each of the tasks

I need for each of the locations to report and count the number of buckets placed into them or removed from them.

I need the reports capability at a minimum for the ones shown in the excel file.

Also I need a html or browser version of a live reporting

Web page to be Total movement from a selected date and time with bucket and tonnes and a target tonnes for the period of time. THis should update every 5 minutes.

Location of materials - a live tracker showing the actual current live totals of each of the locations. Need a way to add in new locations and an estimated target material storage value

Need to be able to track the vehicle that is moving the material, where it moved it, and how long it took to move, also the operator driving the vehicle.

Material is not always dirt - Ore or Waste, for drills it it bolts, Upholes, Down holes, face holes

For Agigitator it is Paste fill mix cubic meter

Need also to refer the material as Production or development

Also need the SQL to capture data direct from FTP file transfers and also source other information through an API from Pi, Postgress, Oracle or SQL.

Compétences : SQL, Administration de Bases de données, Programmation de bases de données

en voir plus : can build front end excel spreadsheet, upload excel spreadsheet mysql database phpmyadmin version, outsourcing programming excel vba oracle sql server, sql select from excel sheet, create sql query in excel, how to write sql query in excel sheet, excel data connection sql query with parameters, sql query in excel formula, excel sql connection, excel 2016 sql query, excel sql tutorial, sql bulk load excel spreadsheet, load excel spreadsheet sql server, sql 2005 create job import excel spreadsheet sql, build widget excel spreadsheet, update sql server excel spreadsheet, build excel spreadsheet, update sql database excel spreadsheet, import excel spreadsheet sql, import excel spreadsheet sql table

Concernant l'employeur :
( 37 commentaires ) faridabad, India

Nº du projet : #20746381

8 freelance font une offre moyenne de $103 pour ce travail

leemilun

Hi. Sir I would be very glad to meet you. I read your description carefully. I can bring you perfect result as you want. I am an experienced web developer and designer with the depth knowledge related to WordPress, Cod Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 3 jours
(3 Commentaires)
3.9
masterb325

-I have done Certifications in Business Analytics and working as Analyst for 3 years. -Looking to bring the benefits of data analysis to your business, the company might have analytics already implemented but with the Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 3 jours
(2 Commentaires)
2.5
fashionstar66

Dear Sir, I'm a Web Developer from Russian who is specialized in Database Administration, SQL. I have read your description with great interest. I have 10+ years of experience in SQL, Database. if you hire me, i could Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 7 jours
(1 Évaluation)
0.6
CHARAPARAMBU

<iframe style="width:120px;height:240px;" marginwidth="0" marginheight="0" scrolling="no" frameborder="0" src="//[login to view URL] Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% AUD en 1 jour
(0 Commentaires)
0.0
hengzhulu

Hello sir. I am a senior DBA and i am very interesting in your project. I have rich experience with Database Programming. Once you check me you can hire me. Please contact me and let's discuss more details. Thanks.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 3 jours
(0 Commentaires)
0.0
nkrfreelancer

Hi My name is Nareshjangir. I have been working currently in SQL and have done recently a task which matches with one of the task in your list. lets discuss it further, I would like to close the deal as soon as poss Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 7 jours
(0 Commentaires)
0.0
Bibaswan146

1. 10 Years of experience 2. Expert in ASP.net,C#.net,VB.net,Sql server,MySql,MS Access,Crystal Report 3. Worked in almost 150 projects. 4. Dedication,timely execution and perfection is our key Skill.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% AUD en 1 jour
(0 Commentaires)
0.0
nandasheetal22

Hi, looking at your project description, I think this is the best suited job for me as I have over 8 years of experience in Database Development along with Performance Tuning. I have worked on various Databases like O Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 7 jours
(0 Commentaires)
0.0