Find Jobs
Hire Freelancers

Excel sheet

$30-250 CAD

Closed
Posted over 4 years ago

$30-250 CAD

Paid on delivery
I am looking for excel sheet for 4 crew 5-5-4 schedule. Total of 60 workers work in 4 , 12 hour crews. This Sheet will be about number of hours an employee worked during period of six months. It should satisfy following conditions: • whenever colleague call in, to replace him/her an overtime opportunity arises. Replacement should be in accordance with seniority, also there should be equal division of overtime opportunities to all employees. for Example: Senior employee get called once, he will be called next time only if there is no junior employee to work or if no body sign up for overtime. just to explain more here is another example: most senior employee, is allotted overtime opportunity, next opportunity will go to employee next in line of progression, or to next one, if the worker next to him is not interested. But if there is no employee interested in that case, the senior who already got called last time could get called again as there is no body interested to work. • This sheet should show how much overtime each employee worked, for period of six months and then reset. So, it will collect data from January-June and then start again from July-DEC and then start fresh • The data which keep collecting overtime should be visible as graph or any other interactive way , so that if superior need to call he could know which worker had most overtime hours and which have least , so that colleague with least number of overtime could get priority among all the workers could get opportunity . • One more Example: Let one senior colleague worked for 108 hours of work time, another colleague worked for 84 hours of overtime and third collogue worked for 48 hours. There should be chart showing that Senior worker worked most hours, so workers with least hours should get opportunity , it could be like 108 hours could be showing as red bar in a chart , 84 as orange and 48 as green.
Project ID: 22258396

About the project

41 proposals
Remote project
Active 4 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
41 freelancers are bidding on average $160 CAD for this job
User Avatar
Hi, there! My name is Paris, and I was glad to see that you're looking for an Excel developer. According to your brief, you want to have an Excel application that will track employees' progress with visual graphs. I plan to use a combination of formulas and VBA code to accomplish this. The Excel file will run on PCs. I will charge you $200* and can deliver within five days (we can discuss the milestones, I don't require any payment in front). I'm among the most experienced and skilled Excel and VBA developers on this platform. In particular, I am in the top 2% of the freelancers having completed over 340 projects successfully in less than 7 years, and I feel confident in achieving your task as well. I'm online from 7 am to 9 pm, Athens time (including weekends). I'm looking forward to working with you. Sincerely, Paris Pallas *My quote is indicative and may change after we discuss the tasks needed in detail.
$200 CAD in 5 days
5.0 (661 reviews)
8.7
8.7
User Avatar
hi, I read your rules and I can do the project on Microsoft Excl. I am financial experts and a guru in Microsoft Office/Excel/VBA/Macro. I have extensive knowledge and expertise in advanced formulas, Pivot Tables, Visual Basic Application (automation) including preparation of graphical and visualisation reports, dynamic dashboards, screen layout's (user-forms), drop-down boxes, reports generator and charts (by VBscript). Furthermore, I have experience in accounting, financial reports, consolidating, forecasting, budgeting, costing, cash flow, multi-currency, including collections, payments, inventory, bill of materials, taxation and bank reconciliation. With these skills, I prepare dynamic & designed reports and dashboards, for pitch decks, business plans, due diligence, financial modules, feasibility studies, and financial projections with scenarios and charts.
$500 CAD in 7 days
4.9 (96 reviews)
7.5
7.5
User Avatar
I can definitely help you with that. I am a professional Financial Analyst, Data Analyst and Excel expert holding years of experience in utilizing advance level tools and functions of Excel including VBA and Macro to create complex calculations and create highly dynamic and automated dashboards. I will be happy to discuss in detail how I am highly suitable for this project.
$60 CAD in 1 day
4.8 (242 reviews)
7.3
7.3
User Avatar
I am postgraduate with more than 6 years of experience in advanced excel based tools, employee management system, VBA automation, google scripting and data processing. I have successfully completed similar projects, please have a look at my portfolio for details. I have developed excel based automation tools for Ernst & Young also. You can get your work done here with highest quality at lowest price. Looking forward to work with you
$300 CAD in 5 days
4.9 (51 reviews)
5.9
5.9
User Avatar
Hello. My name is Marko and I am an Engineering Graduate with an MBA degree. I am a full time freelancer and I will work hard on this till completion. An Expert Excel/VBA programmer on freelancer.com and I do not bid on projects which I am not sure. I will not disappoint you and I will do my best for give you a perfect solution. If I have an opportunity to work with you, That's my pleasure. No milestones required in advance, please pay me once the job is 100% complete. Also, before you consider awarding me the project, I can provide you with some sample files via your requirements. Please message me, so we can discuss here as I may have some questions. Thank you. Marko R.
$155 CAD in 1 day
4.9 (45 reviews)
5.6
5.6
User Avatar
Hi Good Day! A serious freelancer here. I can help you to complete this project. Can you share any existing file you have? I can make it automated using Excel Formulas and VBA Macro. Please consider my bid. I've done a lot of Reports and Templates using MS Excel. I can use my expertise in VBA Macro do it quickly and accurately. Message me anytime to discuss. With my experience as a VBA Macro developer for 8 years I can give you the high quality tool that can generate accurate result that you wanted using MS Excel. I am also a Project Management Analyst for 8 years in Accenture which given me the knowledge of creating quality dashboards and financial reports for our Clients. Please message me anytime to discuss more about this project. I am willing to help you out and show you my expertise. Thank you!
$150 CAD in 3 days
4.8 (83 reviews)
5.6
5.6
User Avatar
Good Day I have over 40 years of work experience, in positions of Middle and Senior Management, during which I utilized Excel for Human Resources, Operational, Resources and Financial management and measurement purposes My business is focused entirely on Excel based projects which with my experience and qualifications, I am certain that I will be able to provide you with the service you require. If you send me your requirements, I will be able to advise and complete your project accordingly.
$180 CAD in 7 days
5.0 (1 review)
2.4
2.4
User Avatar
I am Data Entry Specialist. Expertise in Data Entry, Data Processing, MS Word, MS Excel , copy writing and pdf works. I am ready to work on this project. I will be completed the quality work with on time. Revisions up to your satisfaction. I will work for company and individual with on-time delivery with 100% quality for any type of Data Entry.
$140 CAD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Good day! Ma'am/Sir, Your recent job opening caught my eye and I would like to be part of your company! To give you an overview of my work experience, I have been a Encoder/Data Entry/VA for almost 6years. I have adequate knowledge about MS office and the like (excel/gdoc/word/Powerpoint) because I use it to track all my activities and agendas at work. I'm a determined and goal-oriented person who aims to be the best version of myself every day. I am a well-organized person with great attention to detail. I can work with minimum to zero supervision. I will be an asset and will never be your liability. I hope you find my application interesting and I hope to hear from you soon.
$31 CAD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I am Karthik having vast experince in skilled , planning and organizing with the ability to complete tasks on deadline. An independent worker who successfully meets the challenges of a fast-paced environment providing data entry and administrative support to a large department. Sound knowledge of database management tools and data entry technologies.
$140 CAD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello I have over 10 years of experience in graphic design field 2d design. I am expert in all the skills of designing like:- .Ms Office, Excel, Power point, 2D Character Design. .Flyer Designing .Banner Designing .Logo Designing .Brochure Designing .Poster Designing .Illustration .Caricature .Business card .Letterhead format.
$140 CAD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I would like to work with your company . I am a engg. and do part work of data entry . You trust on my work and i will give you my best .
$222 CAD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am an expert who understands the value of time. I am very hard working and aim to deliver in less time than quoted. I want to make you, my employer happy without changing my bid. If you are looking for a true Freelancer, I am the Right person for you. I am available almost 24-7 and am very responsive. I feel proud that I am a trusted Freelancer who pleases almost every single client. You can rest assured, your work will be delivered well in advance of others, with passion and accuracy. I guarantee you instant communication when you need me. Why choose me? I think every client is the reason for my success. I only take projects which I am sure I can do quickly and at my FIRST BID. I promise to deliver 100% Satisfaction. It"s my aim as an independent contractor to fully utilize my skills to assist clients. I have more than 5 years of experience in the same domain. Expert in the following fields: 1, Data Entry 2, Data Analysis 3, PDF Please ping me for more discussion.
$140 CAD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have typing speed of 80-100wpm (words per minute) and have valuable experience in data entry, data analysis and web research. I will work for you or your company with on time delivery and 100% accuracy. All kind of typing work. Online research and data collection Copy paste- data entry job Transfer pdf/scanned word or excel Transfer data from paper format into database system Type in data provided directly from customer or other parties Create and manage spreadsheet with large number of figures Verify data by comparing it to source documents Update existing data Produce reports Retrieve data as requested Perform regular backups to ensure data preservation Sort, organize and store paperwork after entering data
$35 CAD in 4 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi I give my best With hard work Relevant Skills and Experience I have good typing speed and know about exal Ms world etc
$155 CAD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi - I am a goal-driven , seasoned accounting and finance virtual assistant with significant professional experience of + 25 years; has hands on experience of account management, data entry and data analyses. Also good hands on Microsoft excel. I offer 2 days work free of cost , if satisfied with my work than we can proceed with mutual understanding as per your requirements and volume of work. Please contact me before placing your order.
$120 CAD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
you will never be disappointed with work Relevant Skills and Experience i do this work every day in office
$155 CAD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Respected Sir, Quality of work is my passion and I will not compromise on it. I hope you will find me ever best.
$30 CAD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I want work for data entry
$155 CAD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Ready to start right now! Ready to start right now! Ready to start right now! Ready to start right now! Ready to start right now! Ready to start right now! Ready to start right now! Ready to start right now!
$140 CAD in 7 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of CANADA
Regina, Canada
0.0
0
Member since Nov 11, 2019

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.