Find Jobs
Hire Freelancers

I need a spreadsheet made

$30-250 USD

Closed
Posted about 6 years ago

$30-250 USD

Paid on delivery
Hello. I'm with an Auto Repair facility, and have 4+ technicians that I need an excel sheet to calculate their pay for the week. Payroll is done Weekly, Monday-Sunday. There are a bunch of different variables that is far too complicated for myself to figure out. I'd need to download a file weekly and somehow transfer that data to our spreadsheet, 4 different reports and 4 technicians to grab data for. Determine total amount employee is getting paid per job (FR Hours), manually enter what the employee got paid last week (unless the spreadsheet can show what previous week was paid and pull it from that sheet), time clock hours, time employee was standing around and why. And have the spreadsheet show Each week totals for the entire year, week starts Monday and ends Sunday. Following excel sheets are extracted from our management software and will be exactly as extracted per week.
Project ID: 16732815

About the project

49 proposals
Remote project
Active 6 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
49 freelancers are bidding on average $113 USD for this job
User Avatar
Dear Employer, I understand that you want to make an excel sheet to calculate the pay for the week. I hav more than 5 years of experience in Excel. Kindly ping me for more discussion.
$150 USD in 2 days
4.9 (485 reviews)
8.3
8.3
User Avatar
Hello, I’m an Excel expert and I would like to help you with your project. I'm fully available and I can start right away. Please check my profile and contact me to discuss. Regards.
$150 USD in 3 days
5.0 (483 reviews)
8.0
8.0
User Avatar
Hello there !!! We are expert in creating Payroll spreadsheets as we have high proficiency in Excel. I would like to ask few queries. Looking forward to have a chat. Thanks Brad
$88 USD in 2 days
4.8 (116 reviews)
7.8
7.8
User Avatar
"I am extremely good with Excel as it is part of my daily professional work. Working with complicated formula and Developing Macro programs are part and parcel of my daily work. I am a Business (MBA) Graduate with major in Finance and MARKETING along with 5 years of experience in Sales, Marketing and Advertising. Currently I am working for a MNC as an B2B Analyst Manager.I believe I can do a fantastic work for you if you provide me the opportunity. "
$70 USD in 3 days
4.9 (266 reviews)
7.1
7.1
User Avatar
Hi I would like to bid for this project. I posses Data Analytics, Research, Accountancy, Administration, Banking, Financial/Business Analysis & Reporting and Content Writing experience with Advance MS Excel Dashboards, Power BI & Microstrategy Dashboards, MS & Google Office Suites, WordPress, Social Media Marketing and Touch Typing 60wpm Skills.
$120 USD in 1 day
5.0 (36 reviews)
6.7
6.7
User Avatar
Hello, I'm ready to work on excel sheet to calculate payments for the week project. Relevant Skills Excel, VBA Milestones 63 USD - project requirements done and delivered 63 USD - last milestone after full checking and testing I have samples of work very similar to what you are seeking, check my profile please.
$127 USD in 2 days
5.0 (116 reviews)
6.6
6.6
User Avatar
dear i understand your demand. I am mphill in computer science having seven years of experience in Excel development. I can deliver you a Excel calculator or Dashboard according to your demand in which you can easily calculate everything.
$250 USD in 1 day
4.8 (86 reviews)
6.4
6.4
User Avatar
Hi, I have over five years experience in using Excel at an advanced level (formulas, array formulas, pivot table, macros, automatic calculation sheets) as an Industrial Engineer at Michelin. I am always keen to improve my work quality and productivity and I made complex Excel sheets to automate my tasks. I will be pleased to help you with your project and I am sure you will be satisfied with my professionalism and the quality of my work. Best regards, Florin Enache.
$120 USD in 3 days
5.0 (23 reviews)
5.7
5.7
User Avatar
- Have done similar Wage calculations weekly based on the Hourly Rate and the numbers of Clocked by the employees. - Reports for the 4 technicians can be got based on the FR Hours. - And also have the track in Excel of the previously paid Pay(last week). - Reports can be run on every Monday to calculate the wages for last week. - Will provide buttons to generate the reports. My Skills: - Have expertise in Excel automation, macros, formulas, calculations, summarising and Graphs. - Extensively the macros/VBA to automate: - Data camparision using formulas, lookups and summaries., - Data validation in a particular, Data consolidation into sheets, comparing, plugging in default values for few cells - Data camparision using formulas, lookups and bringing up summaries., - Mathematical functions, scientific calculations, index, array, formula arrays which are advanced concepts - Have used them. - With summary data plotting graphs, bringing pivot tables - Pl. review my portfolio on projects done - https://www.freelancer.com/u/satishtl
$100 USD in 3 days
4.7 (49 reviews)
6.1
6.1
User Avatar
I am an advanced excel expert. Please discuss in detail over chat now. Thank you!............................................................
$200 USD in 2 days
4.9 (41 reviews)
5.5
5.5
User Avatar
I am here freelancer first to discuss the details of spreadsheet made then i can sure about my price and the deadline. My way of working is not only to complete but also to provide enough understanding to the project owner. So this will be base of our long term relationships.
$120 USD in 3 days
5.0 (15 reviews)
4.7
4.7
User Avatar
Dear Sir I saw your project now and I can do it and I can give you quality work so please message me for quality work Thank You
$155 USD in 3 days
4.9 (15 reviews)
4.2
4.2
User Avatar
Dear Sir I am an excel professional having hands on expertise in developing spreadsheet for analytical purpose I will do your project as per your requirements by applying advanced excel formulas with conditional formatting if required. Best regards Humayoon
$175 USD in 3 days
4.7 (12 reviews)
4.1
4.1
User Avatar
We have the expertise to do this job for you as required. All you need is provide the details and we are good to go.
$35 USD in 3 days
5.0 (8 reviews)
3.6
3.6
User Avatar
1. Excel expert with extensive vba programming experience. I can help by building in the formulas and calculations that you need in your spreadsheet. If you need the spreadsheet to interface with another spreadsheet file, that is something I can do as well if we deem that the best solution. 2. I have worked for several years in excel as well as different languages and perform daily work using vba, user forms, pivot tables, formulas, etc. 3. On the surface, I would say I could turn this around in a few days or so. That would depend on teh scope however. 4. I believe with my background I could help move your project forward. I work in excel everyday for a current project. If your needs cannot be met with a standard excel formula, can also write a custom formula. I look forward to the opportunity.
$194 USD in 3 days
5.0 (1 review)
3.8
3.8
User Avatar
A proposal has not yet been provided
$50 USD in 2 days
5.0 (8 reviews)
3.3
3.3
User Avatar
I am expert in excel would be greatful to you if you give me chance to prove myself
$30 USD in 1 day
5.0 (6 reviews)
3.4
3.4
User Avatar
Hi. My name is Bill and I am an Excel expert but a web developer by trade. I have a timesheet that I have built for myself at a previous job that could be of use to you. Let me know if you'd like to chat.
$150 USD in 3 days
5.0 (3 reviews)
2.6
2.6
User Avatar
A proposal has not yet been provided
$31 USD in 3 days
5.0 (3 reviews)
1.3
1.3
User Avatar
Hello, I am here to make your work easy. Just trust me and inbox me before placing the order. Thankyou
$30 USD in 2 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
United States
0.0
0
Member since Apr 18, 2018

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.