Excel Spreadsheet to Web app on MySQL with Mobile App

Closed

Description

The client is a customs clearing agency that has been using a shared excel workbook in their office to capture information. The sheet has evolved and currently contains 13 sheets which is used for data entry, data storage, calculations and reporting. The next evolution has to be a web based application with MySQL database .

The company is very young based in Africa growing at a phenomenal rate, with users that have very little IT background. The current workbook and all sheets are locked to prevent changes of the data and sheet formats.

The sheets that are currently used for data entry and calculations have to be converted into forms with provision for prevention of entry duplication (10 forms). There are 4 reports that are drawn from the data that are submitted to clients on either daily weekly or monthly basis. There are some sheets that contain data with variables to calculate import and export duties (>4000 rows).

The current data contains about 2500 rows with 140 columns, some cells have multiple entries. The data added daily equals on average 10 to 15 rows per day at this time peaking to about 40 per day in June July. There are 7 people using the worksheet at the moment the web based application will be accessed and used by 30 plus people. The website will also have serve as customer portal for the monitoring of the clearing status of their cargo.

The system will have to provide for data entry, clearing process monitoring and reporting. There should be allowance for a mobile app

Skills: Android, HTML, MySQL, PHP, Website Design

See more: website design worksheet, web portal & application, web design mobile app, web design day rate, web design africa, web agency web design, spreadsheet to web application, spreadsheet on web, reporting application design, mobile app agency, formats in excel, excel to web, evolution of web, evolution of the web, duties of data capture, data entry application design, customs data entry, customer portal design, client information app, young web, little agency, a little agency, customer database in excel, web design mobile app design, storage app

Project ID: #5177013

26 freelancers are bidding on average R19909 for this job

best1

Hi Greetings from Panacea InfoTech Pvt. Ltd. (ISO 9001:2008 certified) We gone through your provided project details & happy to tell you we can help you to develop report exporting/generating application, which fetch More

R21649 ZAR in 40 days
(206 Reviews)
9.6
phpMaestro

---------Please share if there is any perplexity in your mind regarding the project. We will be happy to offer our services to you---------- Hi Greetings! We have more than 10 years of experience with LAMP technol More

R21649 ZAR in 30 days
(297 Reviews)
9.5
krishdts

Greetings, This is Kris from DreamzTech Solutions. Please open the chat room so we can discuss this in details. To get an idea of the quality of our work you can check the below link : http://dreamztechusa.com/P More

R21649 ZAR in 15 days
(98 Reviews)
8.6
buraqtech

1. Crowd Funding Site In these days we are already near to finish a full CMS based crowd funding site which is a clone of kickstarter but we implemented many unique features in this project to distinguish it from kic More

R19469 ZAR in 30 days
(86 Reviews)
8.0
qualifiedcoders

Hi, We have read your Requirements and would like to discuss further as we have strong hands in web,desktop & mobile application development & completed over 150 projects in last 5 years including complex processing More

R21649 ZAR in 18 days
(54 Reviews)
7.8
qitsol

Awards winning apps. Android & IPad http://www.capturatalk.com/ Award winning app - IPhone https://itunes.apple.com/au/app/am-dinner/id641904571?mt=8 Vehicle barcode scanner for ios, web .. aecvt.atlanti More

R25773 ZAR in 20 days
(123 Reviews)
7.5
Huiming324

Dear sir. I have already checked your job description. I have already developed many mobile Web Service apps such as "Smart Driver, Smart Food, Orange Talk, Taxi Driver, Night Club, Accentu Date, Catch son, MemeGenera More

R20618 ZAR in 20 days
(39 Reviews)
6.7
wanggil

Hi, I have read your requirement carefully. I am an iPhone | Android software expert with rich experience. I have done many successful iPhone | android apps and games: single, multi-player, cocos2d, unity3d. And I More

R16237 ZAR in 10 days
(12 Reviews)
6.7
mamun00001

Hello, I hope you are having a good day. Your project sounds very interesting, and immediately I would say that it is something I can help you with. I am completely clear with the requirement and very much interested t More

R23157 ZAR in 20 days
(94 Reviews)
6.8
softwareweaver

A proposal has not yet been provided

R30000 ZAR in 20 days
(23 Reviews)
6.6
monster816

Hi, I'm an expert ios and android app developer with 5+ years of experience. I am an expert in Native Android SDK,objective c, HTML5, Database(MySQL,MSSQL),CSS,DHTML,JQuery,etc. I believe my skills would be ideal More

R21649 ZAR in 10 days
(15 Reviews)
6.3
codeware1

Hello, I have gone through your project’s initial requirements with the help of the job posting you have placed. And I think I have requisite experience and expertise to complete your project successfully. I am very More

R16237 ZAR in 15 days
(52 Reviews)
6.4
mitss

hello, i checked your given details we develop your mobile app by using phonegap which is integrate with your website and here please check here our developed phonegap apps HTML5 with JQuery mobile website More

R21649 ZAR in 35 days
(21 Reviews)
6.3
irshadwazid

Hello, Thanks, for giving us a chance to bid on your project.We are WebGloabalIt is an (ISO 9001:2008) (ISO 27001:2005) certified company which have thorough 5 stars ranking and great reviews by customers from More

R16237 ZAR in 10 days
(25 Reviews)
5.7
ominfowave

Dear Sir, Trust us we can do this project as we had done similar project of our clients. We want to work with you and build a healthy longterm relationship so please contact us and discuss for this project before fi More

R13055 ZAR in 25 days
(29 Reviews)
5.5
ProsperoWeb

Hello, We are one of the leading web development company based in Toronto, Canada. We have thoughtfully reviewed your requirements for Excel spreadsheet to web app project. We are interested in your project and w More

R17500 ZAR in 30 days
(26 Reviews)
5.3
djain01

Hi, Greetings.. Many thanks for providing the opportunity to bid on the project. I have done many project based on Visual Basic and Excel and VBA. You can also visit my port-folio to know about my work-profile More

R22222 ZAR in 30 days
(40 Reviews)
5.1
mahindaranil

We are php, mysql experts. Previously, We have worked on cleaning data duplication job on freelancer site. Thank you

R17500 ZAR in 30 days
(3 Reviews)
4.5
VRWebSolutions

Hello, We can create the Excel Spreadsheet to Web app on MySQL with Mobile App based on your requirements and timeline. I primarily work with small businesses, professional services and individuals. My goal i More

R16237 ZAR in 30 days
(3 Reviews)
4.2
TirthaBiswas

we are the best that we can prove with our quality of work . kindly check our online portfolio.our web portfolio url http://www.quantum-webtech.com/ . kindly check my portfolio website for this kind of task ........our More

R16578 ZAR in 25 days
(6 Reviews)
4.3