Find Jobs
Hire Freelancers

Spreadsheet for PTO

$250-750 USD

Closed
Posted almost 2 years ago

$250-750 USD

Paid on delivery
I need to be able to calculate PTO for our employees for seven locations according to the attached chart. Sometimes the employees work in more than 1 location. Each month we need to 1. Determine average hours each employee worked per month based upon the formula attached. If they worked in more than one location, those hours need to be added together. 2. Create the correct multiplier for PTO based upon the length of employment. 3. Accrue PTO hours during the year and subtract PTO taken during the year (we will enter this manually). 4. Delete 50% of hours not taken by end of year. 5. Allow easy addition of new employees into the spreadsheet as they are hired.
Project ID: 33656522

About the project

37 proposals
Remote project
Active 2 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
37 freelancers are bidding on average $347 USD for this job
User Avatar
Greetings! Thanks for very detailed requirements. I can come up with a solution for all the 4 requirements. To set this up exactly as per requirements, I would need the Timesheet file that is being currently used. Being a full time freelancer working exclusively on Excel based projects, I work on such Excel based tasks every single day. I have 20 years experience in using Excel as part of my daily work life. Have a Great Day! Srinivasan Krishnamoorthi
$250 USD in 2 days
5.0 (249 reviews)
7.1
7.1
User Avatar
Hello, I will be glad to assist you with that. I am an advance level Excel expert holding years of experience in performing Data Analytics, Automation and various other calculations and analysis using VBA, Macro, Power Queries, Pivot Tables and Excel based formulas. Lets discuss your project in detail and how I am highly suitable for this.
$250 USD in 1 day
4.8 (223 reviews)
7.3
7.3
User Avatar
Hello, I can assist you to create a spreadsheet for PTO. I’m ready to start. Please drop a PM if you’re interested. Best regards, Hoang
$250 USD in 14 days
5.0 (170 reviews)
7.1
7.1
User Avatar
Hello, I am an Excel expert. I offer my services to create an Excel spreadsheet to calculate PTO for employees of 7 locations as per the requirements mentioned in the project details. We can discuss further details over chat. You can check my reviews for quality of work and client satisfaction. Looking forward to working with you. Thanks, Hamid
$250 USD in 2 days
5.0 (94 reviews)
6.2
6.2
User Avatar
Hi! I would like to know more details, so I could help you. Hope for our productive cooperation! Have a nice day!
$500 USD in 4 days
5.0 (4 reviews)
5.1
5.1
User Avatar
Hellothere, I will help with the project on Spreadsheet for PTO. I have read the instructions carefully and I clearly understand what is required of the project. I have handled several assignments in this field and I will be glad to offer my expertise and on this one too. With me, the quality and the deadline of your paper are my utmost priority. I have the expertise needed to complete your project as I have skills in Excel and Data Processing. Feel free to contact me for more details. Thanks & regards.
$300 USD in 2 days
4.7 (17 reviews)
4.9
4.9
User Avatar
Hi, I understand perfectly your requirements. I am ready to start right now. I have strong knowledge about it. I am ready to start work right now and can assure the best service from my end. Waiting for your good response. Let me know more details about the project. Click on the "CHAT" button so we will discuss it in detail. I'm always online and available. Please feel free to contact me at any time. I am available 24/7 for support. Best Regards AB.
$250 USD in 1 day
5.0 (9 reviews)
3.4
3.4
User Avatar
Hello there, Can we talk more about the job...... Looking forward to hearing from you... Thanks Punit
$350 USD in 4 days
4.9 (3 reviews)
3.0
3.0
User Avatar
Hi, I will make the PTO Spreadsheet by keeping in view the length of Service and accrual rate as mentioned in picture. I am an excel expert and I can perform the task in some hours. I assure you of best quality of work within given timeframe. I have prepared same spreadsheets and dashboards previously. Let's discuss some details in chat. Thanks & Regards. Faraz Ahmed
$250 USD in 1 day
4.7 (4 reviews)
3.3
3.3
User Avatar
I will be happy to help ypu with these project. I have Master's of accountancy and wide experiance with Excel and similar tasks. Feel free to reach out with more detaisl and we can talk deadlines and price. Thank you!
$250 USD in 7 days
5.0 (8 reviews)
3.3
3.3
User Avatar
Hello! I have vast experience in Excel and Data Processing, and I am confident that I can produce quality content for you that will be of interest to your readers. I am available for a full-time writing position, and I am happy to work on a freelance basis if that is what you prefer. I look forward to hearing from you soon! Thank you for your time. Thanks & regards - Wilfred
$250 USD in 3 days
5.0 (1 review)
2.9
2.9
User Avatar
Greetings, I'm Interested in your project and I understand your requirments for this task. I can start work on your project immediately once you confirm. I can complete your project in an estimated time because client satisfaction is the main priority for me also the work will be done within a reasonable budget. You can check my portfolio here: https://www.freelancer.pk/u/Sheryar77 Thank you Shehryar Javed
$250 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I can do complete my work within limited time period with perfection and I assure you'll praise of my work.
$500 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am certified management account (cma) I will do my best, complete before the due date .??????????????
$250 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am expert in data entry and will complete your work in given time frame please trust us and give one chance to prove us and looking for long term work with you and you will not feel disappointed
$500 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Availability is one of the most important factor where you have to focus on. You have to make sure that you can give as much as time the client wants. We generally see too many newcomers are entering the freelancing world day by day. Most of them do not have enough experiences in data entry tasks. It is true that skilled arrangements of false information can bring you a job. But it may not last longer. We should respect the clients and honest to the information. Please try to describe your bid proposal for data entry job with proper arrangement and 100% confidend.
$500 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I will do your work very hard or honestly. I complete this work within 3to4days please give that work.
$350 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello there, I' ve studied Computer Science and im working as an IT. I have developed several Excel projects for my Department. Thanks Constantinos
$250 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello Sir, Hope you are doing great. I have gone through your requirements and completely understand your requirements. So believe I can perform the task with ease and satisfy you with my work. Previously I have held a position as an Excel payroll specialist for an e-commerce based company where I have managed payroll for over 80 employees. Hence, I know the ins and outs to manage and calculate employees salaries, bonuses, over time, PTO etc. Besides that, I used to calculate orders amount, finding out gross profit, net profit on a weekly as well as monthly basis. Moreover, I have full proficiency in English language that will definitely aid to our communication and other necessary requisite. I am new on freelancer.com. However, I have tons of experience to perform your task. I hope you will give me the opportunity to perform your assignment. I can assure that I will give 200% on your project and will make you happy at the end of the project. Please feel free to contact and have any query that you need. Sincerely, Muhtadi Mujaffer Mahan
$250 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am a very accomplished person, I have great knowledge in Excel and file management, I will be fulfilling everything as ordered! I'll do a great job
$250 USD in 7 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Washington, United States
0.0
0
Payment method verified
Member since May 9, 2022

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.