Database linked with simple leave provision calculator for NGO, preferably with Sharepoint

Closed Posted 7 years ago Paid on delivery
Closed Paid on delivery

I've attached a simplified overview of what we are looking for...but in plain English

we are looking for a Sharepoint solution to simplifying our (already quite simple) personnel database and leave system. Currently we use Excel, but we are a charity that operates completely on volunteers in Australia, and so we need to make the process simpler and more efficient. We have 180 staff. I'd like to have a database that is searchable that allows to store individual personnel information (reasonably confidentially) in that database. Our staff have a maximum of 12 working days a year leave in addition to holidays (e.g. for sickness or carer's leave). I need a field in the database that keeps track of leave...so that when staff exceed that leave their salaries (which are fixed and paid monthly) are adjusted downward by a simple pro-rata formula for the month in which they have exceeded the annual total of 12...and only that month of course (otherwise they would pay a monthly penalty for exceeding their 12 days, which is not the intention.) I am very open to options that are web-based, simple, but do NOT allow or include Sharepoint. Has to be secure however. Excel solution could be acceptable, but I want a place where I can easily place written and numerica personnel data and find it back again...

Database Programming Excel Human Resources

Project ID: #11947087

About the project

12 proposals Remote project Active 7 years ago

12 freelancers are bidding on average $90 for this job

cugamelover

I can do exactly what you need in Excel. I'm a computer science professional with a PhD degree and extensive experience in automation of data acquisition, processing, analysis, and presentation in Excel using custom da More

$100 USD in 3 days
(117 Reviews)
6.6
fawadrafique

Hi, I can do this work effectively with having an excellent output. I am able to start work immediately and can deliver the work within given time. Awaiting for your response. Thank You. Fawad

$100 USD in 2 days
(35 Reviews)
3.7
ksinghrajeev

Hi, I can build a system password protect which can modified only by the person who knows the password. Can build these in either excel or access. Let me know if you are ok with this. Thanks, Rajeev

$100 USD in 10 days
(3 Reviews)
3.3
fixen2011

Hi, I would like to propose an enhance version in Excel. Can I take a look at your current excel file ? I would like to discuss further details with you.

$100 USD in 5 days
(4 Reviews)
1.9
abdulfastian1

i am professional Developer and i will provide you the best and the most suitable solution for you.. it will make your work as much easy as it can be. I have done many payroll management systems as mentioned in my prof More

$89 USD in 9 days
(0 Reviews)
0.0
AhmedSamir1920

I have all of the skills and experience that you’re looking for and my background will add value to this project.

$111 USD in 7 days
(0 Reviews)
0.0
JBG1974

I propose using a MS Access Database for your solution. It will provide easy searches that can be customized, allow pro-rata deductions for only the selected months, you can create custom reports from the data, and it More

$77 USD in 7 days
(0 Reviews)
0.0
saeednami

As a Proficient user of Microsoft Office (Word, Excel, Visio, PowerPoint, …) I am able to use Excel very effectively to speed up the tasks in high accuracy and also making smart worksheets to avoid doing same process More

$77 USD in 4 days
(0 Reviews)
0.0