Find Jobs
Hire Freelancers

Analyze some Data

$30-250 CAD

Closed
Posted about 9 years ago

$30-250 CAD

Paid on delivery
Hello, I am looking for a simple excel tool I can use to help calculate the cost of different staffing schedules. I want to be able to calculate the following shift schedules: Days on Days off •15 and 6 ◦Wednesdays remember that all crews work ◦This is a 3 crew schedule •8 and 6 ◦Wednesdays all crew would work, 2 crews going off and 2 coming on ◦this a a 4 crew schedule •8 and 4 ◦3 crew schedule 10 and 5 ◦3 crew schedules I need to know the following over a fixed period (per full rotation?) •total of labour •total regular time •total over time •calculate hours per person •calculate the $ cost Use 15.00/hour/regular employee Use 20.00/hour/supervisor Assume15 persons per crew Assume 2 of those people are supervisors I need a front page that will allow me to change some variables, calculate the changes and apply them to the different staffing options. For example what happens if crew size changes to 20 people or a group works 16hrs instead of 12. Thanks for your help
Project ID: 7227431

About the project

29 proposals
Remote project
Active 9 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
29 freelancers are bidding on average $110 CAD for this job
User Avatar
A proposal has not yet been provided
$149 CAD in 5 days
5.0 (850 reviews)
9.2
9.2
User Avatar
Hi, I am good at excel and macros... I can create vba. Please see my experience list in the freelancer. I will create vba to meet your requirement with all the conditions satisfied. Looking forward for your reply to start the work on immediately.
$90 CAD in 3 days
5.0 (1139 reviews)
8.4
8.4
User Avatar
A proposal has not yet been provided
$150 CAD in 2 days
4.9 (256 reviews)
7.7
7.7
User Avatar
Hi! excel automation is my masterpiece in my accounting field. It is my pleasure to help your project. Feel free to message me with your actual data. Thank you.
$100 CAD in 3 days
4.9 (75 reviews)
5.7
5.7
User Avatar
See my portfolio and reviews, contact me if you're interested. Thanks, ______________________________________________________
$155 CAD in 3 days
4.9 (34 reviews)
5.3
5.3
User Avatar
As A Microsoft Certified System Administrator I am Excellent in word editing, processing , spread sheets I can very quickly help you with any Microsoft Excel problem, formula(s), or task. I am an advanced user with over 10 years of MS Excel experience. I am ready to start your project
$111 CAD in 2 days
4.8 (19 reviews)
4.6
4.6
User Avatar
Hi, My name is Dan. I am an expert in excel and all advanced functionalities. I can do the schedule analysis as outlined in the job description and I have experience of working on such a project. Please message me so that we can discuss and proceed further. Thanks ! Regards Dan
$150 CAD in 4 days
4.9 (10 reviews)
4.3
4.3
User Avatar
I'm an excel expert and I have experience in freelancer projects making customized templates for my costumers. I also have expertise on costs accounting and labor force calculations.
$100 CAD in 3 days
5.0 (13 reviews)
3.6
3.6
User Avatar
A proposal has not yet been provided
$111 CAD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Being Analyst I’m good at data processing and structuring activities, preparation of presentations and web based research.
$111 CAD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$105 CAD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have been working with clients for years to develop Excel tools such as you describe. I will create a visually compelling, easy to use file that will allow you to easily adjust the parameters to calculate your costs.
$111 CAD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$155 CAD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Expert in Excel, VBA and Macros in Excel. Expert in Access Databases. Can do this Excel Data Analysis task efficiently. Ready to start. Thanks.
$55 CAD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
This project requires to calculate labours hours of working ,their extra hours of working and extra hours calculation and their pay off. I have excel knowledge of more than 3 years and very well versed with calculation. I would like to know more about this project as i am little confused fr its hours of calculation.
$100 CAD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I'm working for an IT giant where my everyday work is to deal with macro. I recently came across this site and I found your requirement interesting. Give me a chance, I can prove you! Cheers!
$111 CAD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello I would be glad to do the required tool but i will need a further clearer explanation, Probably it would only take one day to finish.
$155 CAD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$177 CAD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$35 CAD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am good at Excel and have pursued an advance course in the same. I will set up such that it becomes easy for you to navigate the record as per your say.
$155 CAD in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of CANADA
San Antonio, Canada
0.0
0
Member since Mar 1, 2015

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.