Database design
$30-250 AUD
Pagado a la entrega
I run a Uber driver, income processing service.
I accept people's payments from Uber
I take the drivers on as employees and pay them as such.
I issue them with a fuel card for petrol purchases and an e-tag for toll road usage.
Each week from their Uber income, I deduct
- those two amounts (tolls and fuel)
- Workcover insurance (1.1%)
- Superannuation 9.5%
- my Fee GROSS < $500 (per week) CHARGE $5
GROSS BETWEEN $501 - $1000, we charge $8
GROSS EARNINGS GREATER THAN $1001 $15
I have attempted to create an excel spreadsheet that will allow me to import data from the fuel card usage and from tolls, allow me to input driver's income and then produce a report showing:
- Name
- Employee Code
- Gross income
- fee breakdown
- Income history graph
- Toll usage for past 7 days
- Fuel card usage with average mileage (based on odometer reading) (graph)
I was advised due to the volume of data being imported each week, a database would be a better way to go. (see access database attached)
The excel sheet worked, but I couldn't get the report to generate the way I wanted. So I attempted to convert this to an Access DB.
Project crtieria:
Import CSV files from fuel & toll data (sample files provided when assigned)
Have a GUI interface to request reports
Ability to produce individual reports in batch and export (either as PDF or email (individually)
Ability to request reports for specific employee
Perform the deduction calculation
This database can either be web based or desktop based (access? or other)
I engage with most bidders, those placing low bids only to jack up the price later will not be considered.
Nº del proyecto: #8152264
Sobre el proyecto
24 freelancers están ofertando un promedio de $335 por este trabajo
Hey, What is the volume of data being imported each week? Even If it is more than a thousand records a week, you would still be better-off in using Excel itself. I reviewed the spreadsheet and have an understandin Más
Hi, My name is Florin and I am a database applications developer. I am from Romania, my time zone is GMT+2, Bucharest. You were advised correctly, it is better to have a database driven application, instead one t Más
Thanks for your time on the chat. I have updated my bid in line with that. Within 5 days I will design, implement and help you go live with a sql-backed desktop app that allows you to import the data easily automating Más
I am database expert having experience of 2 years.I will definitely complete your work and deliver it to you on time
I have been writing academic papers, academic reports, essays, creative writing, technical writing and many others such as programming, databases and graphical user interface design for the last six years. I assure you Más
Hello Sir, This is Ahmed Mohsen from Egypt. I have excellent experience in excel, excel programming and linking between excel and MS Access. I can use my experience to support you with the required program, and if Más
I've created many DB applications over the years, and have specialised in converting Access DB projects to fully fledged applications when businesses grow. This makes me very good at designing access DBs in a way that Más
Day to day basis I work on big database projects ( millions of rows of data ) and I can understand exactly what you need from this project. I will create a WEB based database system for you that is fully automated. ( y Más
Hello, I'm able to design your Access database for your Uber driver income processing servier. I have over 3 year experience designing Access databases and would be able to customize the database per your request. Wh Más
I am a J2EE developer and can make your project with ms access DB so comforting that you can access all the details of Your every Employee very Easily.
hi, I would suggest a mysql database setup on your desktop. The milestones for the project will be : 1. set up the database, 2. data model , 3. module for loading csv files, 4. GUI to get reports.