Each week we pay employees based on how much worked have done, We use excel and the task has become hard manage and match all the data. We need help with creating to database based App to reduced work load. It is very simple nothing complex.
I have attached a sample excel which we create, The employees is given a Issue ticket which has ticket number, Model number, quantity, Employees name. At the end of the week we collect the ticket and enter them in excel. Sometime we have more then 200 tickets which is very consuming process to enter in excel and veirfy and cross again mistakes or over payment. Then we also have to deduct the adv money given to the them.
We don;t want any complex System this works well, Just need help Streamlining it.
Form 1 Employee Adv; Which will all us to enter adv amount which is to be deducted from there payment
Form 2 Department: which will allow us to enter and new department, if we need to any new department. It maybe help to add sort code which will display department in order we want on the reports
Form 3 Model Rates: This all to Add New, Edit Model rates, A search by model number will be helpful. ( there are over 500 models ) Not all model have all department, 1 model might have singer, Overlock only other might have Singer, overlock, Flatlock, Press and so on. Also i am not sure but when new department is added how will have effect table.
Form 4 Ticket entry: This form will allow us to enter all Issue ticket data;:::::: Date, ( which be today's date but can be changed if wanted) Select employee, Maybe a sub form from here for fast entry, All ticket are entered at the same time for same employee, So one person tickets are entered and then the next and next. Ticket Number, Select model number from drop down; enter quantity which you select model the rate is already pulled from the rates table and which ever department they are assigned.
Report 1: Detail of all employee along with there ticket number name department item referee quantity rate amount and total and deduct adv and final total.
Report 2: Detail summary of model and departments, See attachment.
Report 3: Summary of all employee with there totals, adv amount, and in hand pay. See attachment.
All of the table and sample excel sheet is attached.
If you have any questions please let me know.
Hi There! I am a professional Software and Database developer and would like to work on your project. I can make you a software to manage your employees wags. I have some very good ideas for your management software Plus
18 freelance font une offre moyenne de $439 pour ce travail
[login to view URL] I have gone through your project requirements. I have also gone through all your attachments. I will develop your wage system in access with all the forms and reports you have mentioned. I will convert th Plus
Hi! You are correct, this is better suited to the database than to Excel. I've worked before on several similar systems, usually those were part of the other programs (like the program for restoration service). I do Plus
Hi there - My name is Paris. I've read your brief and can see that you'd like to have a database about work tracking. I have 7 years’ experience designing and developing Access databases. I would approach your project Plus
Hi, I am good at Excel and Access. I can see there is a good scope with excel itself. May be shall i make better Excel? or u want to go with Access only. I have seen the attachments. Hopefully, a quick voice chat Plus
Hi Mr. Employer I can do this project in effective manner with 100% accuracy report to your requirements. See Below video as my earlier work with Access. [login to view URL] Pm me for more information and sa Plus
Hi I am interested in this project. I am an experienced MS Access applications developer. I can do this job for you. If interested in hiring me then please let me know so that we can finalize the scope, timelines Plus
Hi there, I viewed your "wage system"... if you'd like to have a professional Ms Access(if need with Excel automation) DB, here is my introduction: I’m an Access/VBA coder, a mathematician and a full time de Plus
Hi, I have gone through your process , i can provide you browser based app, can run on local or as well web. [login to view URL] tracking System, below is the admin panel to manage all the operations. nice part is report Plus
Hi, I have been an independent Access programmer in New Jersey for the last 20 years. Access is all I do, full-time. Hence I work quickly and efficiently and have a lot of great ideas from all the projects I have wo Plus
I have bachelor and master degrees in IT. My Primary skills include Java, Python, VB/.NET, ArcGIS, and PHP. Also database skills include MS Access, MySQL, and Oracle. My Other skills include server and network administ Plus
Hi, If you want I can do this job in excel, including tables (employees, models, advance payments) screen layouts to enter the information and report generator to see the results. I am a specialist in financial repor Plus
I will work on Ms Access. I can start the project from the first of August, if you can wait I'd be glad to do a good work for you.
Hello, I am Mangesh Shinde and I have read your requirement for your wage calculation system and the attached excel. I am an experienced software developer. I have experience in development of invoicing and accounting Plus
HI I am expert in Access Databases. I saw the attached files. I have done similar projects. I can do this efficiently. Ready to start. s k y p e [login to view URL] Thanks.