Em Andamento

Convert excel spreadsheet to Web page form

I have a spreadsheet which allows data for jobs to be recorded. I want the sheet turned into a Web page to allow data entry and the results saved in a mysql database.

There are several drop down boxes that need to have pre entered data choices pulled from the database email. E.g combo boxes.

Spreadsheet has 12 to18 rows of 5 column max.

Here is a copy of the spreadsheet.

the workbook contains two spreadsheets:
Explanation sheet: Shows how the spreadsheet looks at the moment for the admin person to use but has been coloured to show which parts of the sheet need to have combo box drop down type entry areas:
Web page: Shows how I would like the page to work - it doesn't have to look exactly like the sheet, as long as it is clear and easy to enter in.

Explanation sheet:
- Red areas get their data staff data from a staff lookup: Firstname and lastname e.g. Joe Smith, Mary Bloggs
- Orange areas get their data from a Job type lookup table.
- Yellow areas - Machine type e.g. digger, tractor, truck, ute etc
- Blue areas have a registration plate (license plate). These are normally a maximum of 6 chars ( 0-9 and A-Z) e.g. AAB1234 12AFGH XY34
- the green drop down is an address / job number e.g 123-15 Robert Street

Web page sheet: I've reduced the number of lines for each area to two lines - to make it easier to fin on a tablet screen ( Samsung Galaxy 10'' Tablet)
The plus sign would add another line to the area if more than two lines are needed.
If the user choose [New Entry] from a drop down list it allows addition of a new entry in the combo box / lookup list and saves it back to the database. If this is too hard to implement quickly I'm happy to leave it until the second round of work.
The submit button changes the sheet status to submitted.
I would like the sheet to auto save back to the DB as status=draft so that if there was a problem like a battery running out that the sheet can be retrieved.
Once submit is clicked the sheet is no longer editable.

I've added a screen shot from the freshbooks site. They use a similar style. The green plus to the left adds a line, the red x to the right deletes a line. You add as many lines to each section as required.

Security: Initially none required. I'll make the site unfindable with a URl getting them there.
There will be second round of work etc where I'll get user names, passwords and a small work flow going.

Screens required.
Data entry screen similar to sheet called web page.
Data entry screen to add data to look up table

DB:

Table: Lookup
ID - bigInt(20) auto Increment - Primary Key
Key: VarChar( 20) Upper case - key to descripte lookup type (e.g. PERSON, JOBTYPE, VEHICLETYPE, REGISTRATION)
Value: VarChar (100 ) - The value looked up.

Combo boxes return values ordered ascending (e.g. A-Z)

Table: JOB Sheet:
ID - bigInt(20) auto Increment - Primary Key
Address - VarChar(200) (looked up by green combo box)
Date - DateTime
IsSubmitted - boolean - (defaults to false)
IsProcessed - Boolean (defaults to false)

Table LabourItems
ID - bigInt(20) auto Increment - Primary Key
JobID - bigInt(20) - Foreign Key ( JobSheet.ID)
LABOUR TYPE varchar(100)
NAME varchar(100)
TASK varchar(100)
START TIME :DateTime
FINISH TIME : DateTime

Table MachineryItems
ID - bigInt(20) auto Increment - Primary Key
JobID - bigInt(20) - Foreign Key ( JobSheet.ID)
Machine TYPE varchar(100)
NAME varchar(100)
TASK varchar(100)
START TIME :DateTime
FINISH TIME : DateTime

Table TruckItems
ID - bigInt(20) auto Increment - Primary Key
JobID - bigInt(20) - Foreign Key ( JobSheet.ID)
Registration varchar(100)
NAME varchar(100)
TASK varchar(100)
START TIME :DateTime
FINISH TIME : DateTime

Table EquipmentItems
ID - bigInt(20) auto Increment - Primary Key
JobID - bigInt(20) - Foreign Key ( JobSheet.ID)
Registration varchar(100)
NAME varchar(100)
TASK varchar(100)
START TIME :DateTime
FINISH TIME : DateTime

Table Dumpingtems
ID - bigInt(20) auto Increment - Primary Key
JobID - bigInt(20) - Foreign Key ( JobSheet.ID)
Registration varchar(100)
NAME varchar(100)
Tofrom varchar(100)
docketRef varchar(100)

Habilidades: HTML5, MySQL, PHP

Ver mais: web page spreadsheet, web page data entry, spreadsheet web page, spreadsheet web form, spreadsheet in web page, jobs spreadsheet, excel to web, data entry form php mysql, convert excel to web form, excel sheet jobs, convert excel web, data entry excel mysql, mysql spreadsheet, web page excel data entry, excel convert spreadsheet form, excel drop, convert excel spreadsheet web form, convert excel spreadsheet php form, excel data entry mysql, web page data entry excel spreadsheet, excel spreadsheet data entry database, email web page, database convert form, mysql spreadsheet data, excel convert email template

Acerca do Empregador:
( 48 comentários ) Christchurch, New Zealand

ID do Projeto: #6812039

Premiar a:

needdone

Hello I can create a form based on the Excel columns and rows. Can you please show me the sample Excel file? I am a programmer with over 10 years of PHP, MySQL and Javascript experience so I am confident that I c Mais

$200 NZD em 3 dias
(65 Avaliações)
5.9

48 freelancers estão ofertando em média $187 para este trabalho

rinsadsl

A proposal has not yet been provided

$189 NZD in 5 dias
(862 Comentários)
8.5
RockStone435

Hello - I am interested in this project. Can you please show me the spread sheet to review it? Thanks.

$100 NZD in 3 dias
(521 Comentários)
8.6
mituld

Hi I work towards providing reliable, relevant and robust IT solutions at most competitive prices to my customers. I ensure 100% customer satisfaction so lets start Thanks

$206 NZD in 7 dias
(377 Comentários)
8.2
xtreemsolution

Hello There Thanks for allowing me to post my offer I have checked your assignment and find that you need to create a website for your business I would be able to sign the NDA/Contract to get some more informa Mais

$257 NZD in 3 dias
(81 Comentários)
8.1
pointlogic

Hello...I have an experience of more than 6 years in web development and maintenance. I have in-depth knowledge of php, mysql, jquery, paypal integrations, API's, css, html, html5. I look forward to work on this.

$147 NZD in 3 dias
(261 Comentários)
7.9
zeeshanarshad

Greetings, I will create easy to use and efficient solution on urgent basis with quality, validation and care. QUESTIONS: =========== 1- Do you need the data-entry in password protected area OR just a entry pag Mais

$200 NZD em 1 dia
(470 Comentários)
7.6
Infowaze21

Hello Employer, I have gone through the brief as per it you want web page to allow data entry and the results saved in a MySQL database. Please share the complete details. I am having more than 5 years of experie Mais

$263 NZD in 7 dias
(26 Comentários)
7.3
darkwind

Hello, I am a web developer with an extensive knowledge and experience with different web development and would like to offer you my services to create the webpage form. I understand that several of the fields ne Mais

$200 NZD in 3 dias
(269 Comentários)
7.6
ThemePlugger

Hello, I'm a PHP developer. I'll be able to help you convert your existing spreadsheet to a functional web page form connected to your database. Please see my portfolio at CodeCanyon: [url removed, login to view] Tha Mais

$200 NZD em 1 dia
(87 Comentários)
7.0
logicscreators

Hello, I've read the updates of the project description and understood the requirement. I can start right away. Looking forward to hear from you. Best regardxs

$200 NZD in 3 dias
(133 Comentários)
7.1
prashushinde9

Hi, I (Myself a senior PHP, ASP.NET programmer using C# and VB) have a team having experience of more than 10 years in developing web and mobile applications. I have a team of expert programmers who write robust and bu Mais

$268 NZD in 8 dias
(57 Comentários)
7.1
opengeek

Hi Shane, I can see the spreadsheet to have a better idea of what need to be converted in web form? Please provide some more details. Waiting to hear from you. Thanks Gyan

$210 NZD in 3 dias
(238 Comentários)
6.8
mentor11

I already worked for social media and 7 plus year experience in php(ERP Solutions, webportals, Facebook application, facebook fanpages, Twitter, Mysapce, CMS(wordpress , drupal and joomla ),using the world leading tech Mais

$200 NZD em 1 dia
(132 Comentários)
7.1
venky0106

Hello, We can do this, please take a look on my portfolio. [url removed, login to view] Waiting for your positive reply. Thanks & Regards, Venkat

$100 NZD in 3 dias
(132 Comentários)
6.5
VnBestSolutions

Dear Sir. We claim to get it done perfectly for you EXACTLY in the way you want it - Kindly give we a chance and we will prove myself - Ready to prove our words, let's get it done right away and I mean RIGHT AWAY !! Mais

$252 NZD in 3 dias
(171 Comentários)
6.7
plusinfotech

Hi sir, I have 8 years experience in web development with wide knowledge of PHP/MySQL , i can develop your requirement with full of your satisfaction. I will develop secure admin script with the following featrue Mais

$200 NZD in 5 dias
(63 Comentários)
6.3
OverStudio

Hi, I'm experienced PHP/MySQL developer with great JavaScript/jQuery/AJAX skills. I can develop the form you need looking good with some CSS styling, interactive JS-based input validation, DB-based drop downs and Mais

$200 NZD in 3 dias
(49 Comentários)
6.2
PaulSimonk

Hi, I could definitely help you. With more than 64 developers in house we believe we can do the task after discussing the clarifications and all are well experienced in Graphic Design, HTML, PHP, Web Hosting, Website Mais

$257 NZD in 3 dias
(42 Comentários)
6.3
quinconx

Hello Sir, Quinconx Technologies is a team of professionals that will do your work with more perfect and [url removed, login to view] team is ready to start the [url removed, login to view] our team had gone through the description of the Mais

$263 NZD in 5 dias
(44 Comentários)
5.9
zaaid1989

Hi, Hope you are fine. I am PHP developer and want to work for you on this project. I have considerable amount of experience and I am quite sure that I will be doing your task with ease. Please ask if you have a Mais

$200 NZD in 3 dias
(22 Comentários)
5.6