Find Jobs
Hire Freelancers

Create a spreadsheet to calculate staff hours.

$30-250 AUD

Lezárt
Kiadva ekkor: több mint 5 évvel ezelőtt

$30-250 AUD

Teljesítéskor fizetve
I need a spreadsheet that can be used to calculate staff hours/pay as follows: * The start and finish time of each day is variable and must be input in HH:MM format * Each payment period starts on Thursday and finishes on Wednesday, 2 weeks apart * Each day should have an un-paid lunch break, default value 30 minutes but may be changed for a particular day if required (some days staff may have 45 minutes un-paid lunch break) * User must enter $ hourly rate * After 8 hours work per day (Mon - Fri), the hourly rate increases to x1.5 * After 10 hours work per day (Mon - Fri), the hourly rate increases to x2.0 * On Saturday the first two hours are x1.5 * After 2 hours work on Saturday the hourly rate increases to x2.0 * On Sunday the hourly rate is x2.0 * Each day must show the total number of hours worked at each rate * A summary table must be included to show the number of hours at each rate for the two week period RDO Allowance: * A check-box must be provided to select if the staff member participates in a RDO scheme. * If the RDO box is selected and the staff member has worked for 8hrs that day, they only get paid for 7.6hrs standard rate - The remaining 0.4hrs is added to a "pool" * If the RDO "pool" reaches 24hrs, the staff member is paid for 8hrs and no longer accumulates time in the pool - The maximum number of hours in the pool is 24.
Projektazonosító: 17705204

A projektről

45 ajánlat
Távolról teljesíthető projekt
Aktiválva: 5 évvel ezelőtt

Szeretne pénzt keresni?

A Freelancer oldalán történő árajánlatadás előnyei

Határozzon meg költségvetést és időkeretet
Kapja meg fizetését a munkáért
Vázolja ajánlatát
Ingyen regisztrálhat és adhat árajánlatot munkákra
45 szabadúszó adott átlagosan $150 AUD összegű árajánlatot erre a munkára
Felhasználó avatár
Hello, Hope you are doing well. I can help with you in your project Create a spreadsheet to calculate staff hours. I can assure you the quality job. I have good experience in Excel. We have worked on several similar projects before! We have worked on 400+ Projects. Please check the profile reviews. I can deliver your job with in your deadline. Please ping me for more discussion. I can assure the 100% job satisfaction. Thanks,
$230 AUD 3 napon belül
4,9 (498 értékelés)
8,4
8,4
Felhasználó avatár
Hello! My name's Paris and I was glad to see that you're looking for an Excel developer. You mention that you need somebody to develop a spreadsheet that will traxck your employees working hours. You've added a comprehensive set of rules which I'm going to integrate in my code. The final Excel spreadsheet will run on desktop PCs and will be user-friendly and easy to use. I've delivered more than 240 projects in the last 5 years and this makes me very confident with your task. I can deliver the project within 3-5 days including all required revisions for $180. I never ask for payments in front. I will only ask you to release the agreed milestones once the task for each one of them is met and you're happy with it. Feel free to visit my personal page on this platform and get an idea of how satisfied my clients are from my work. Don't hesitate to contact me. I'm looking forward to hearing from you soon. Sincerely, Paris Pallas
$180 AUD 5 napon belül
5,0 (496 értékelés)
8,4
8,4
Felhasználó avatár
I love excel, and have done several similar projects. I understand that you need to create a spreadsheet, that should calculate the staff hours.. Have read the description, and feel like a perfect match. ZERO ERROR GUARANTEED!! Please read my ~400 reviews. I am here to impress you with my work.
$200 AUD 3 napon belül
5,0 (314 értékelés)
7,8
7,8
Felhasználó avatár
Hi, I did similar projects in the past. I am a financial expert and guru in Excel/VBA/Macro. I have extensive knowledge and expertise in advanced formulas, Pivot Tables, Visual Basic Application including preparation of dynamic dashboards, screen layout's (user-forms), drop-down boxes, generator reports, and charts. Furthermore, I have an experience in dashboards, financial reports, accounting, consolidating, forecasting, budgeting and cost acquisition based on inventory, bill of materials, collections, payments, and bank reconciliation. With these skills, I develop financial modules including depreciation schedule, long-term debt, business valuation methodology & ratios The modules incorporate complex components of business in a simplified and logical manner.
$250 AUD 3 napon belül
4,9 (93 értékelés)
7,5
7,5
Felhasználó avatár
Greetings! Thanks for detailed requirements. Being a full time freelancer working exclusively on Excel based projects, I work on such Excel based tasks every single day. I can come up with an Excel Workbook as per requirements specified in Project Description. I have 18 years experience in using Excel as part of my daily work life. Over the last 26 MONTHS , I have spent at least 250 HOURS on automation in Excel every month. If awarded, I can get your work completed to your fullest satisfaction. Have a Great Day! Srinivasan Krishnamoorthi
$120 AUD 3 napon belül
5,0 (246 értékelés)
7,0
7,0
Felhasználó avatár
Hi there, I’ve checked the project details and I can do this perfectly. I have huge experience in working with these projects. Waiting for your quick reply. Create a spreadsheet to calculate staff hour. Look forward to hearing from you soon. Best Regards
$300 AUD 3 napon belül
4,9 (132 értékelés)
6,7
6,7
Felhasználó avatár
I am an ACCA (UK) professional , APA and Mcom finance. After carefully reading your project description, I think that I am the perfect candidate! With over 8 years of experience. I can guarantee getting the job right the first time. Feel free to view my 100% positive reviews before you hire me and rest assured that you will receive top-quality work at an affordable cost. Kind regards, Javed
$111 AUD 1 napon belül
4,9 (106 értékelés)
6,7
6,7
Felhasználó avatár
Hi, I have checked your project description and complete details that you want a tool to calculate staff hours and salary based on multiple criteria. I will build one efficient and quality product for you. I have many years of experience in Excel,data analysis, pivots and VBA macros etc. I have finished many such projects. Please give me this opportunity to work on your project. Quality work with high accuracy and 100% customer satisfaction is guaranteed. Thanks and regards, Mohan
$199 AUD 5 napon belül
5,0 (92 értékelés)
6,4
6,4
Felhasználó avatár
- Have done 4-5 projects related to timesheet, Wage calculations. - This includes off the total hours logged in a day removing the break hours Calcuatings based on the Hourly rate Saturday / SUnday or Public Holiday using a separtae logic RDO Allowance, Timeoff, Salaried or Wages Labour Costing, Cost Loading etc. - Recently have done a very complex Wage calculation for a Australian client. - Can show case. My Skills: - Have expertise in Excel automation, macros, formulas, calculations, summarising and Graphs. - Extensively the macros/VBA to automate: - 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 Sample HighComplex Projects using Macros: (via Freelancer) - Complex Data anlaysis and graphing - Using Surface, Scatter Dynamically setting axis values, legennd colors(Excel 2013 to Excel 2016) - Heating Wire Design, Canada, - Identify the wiremodel running through multiple iterations. - System log generation (users logged in time, duration, days) between time period based on the text log files. Generate report. - Employee Tax, Canada - Calculations per hours,wage,provincial deductions, Federal deductions per reference tables. +...
$200 AUD 4 napon belül
4,7 (49 értékelés)
6,1
6,1
Felhasználó avatár
Hello, I hope you are well. These are my strengths: Immediate availability. Responsible, fast and accurate. Full-time freelancer. Excel expert. 100% satisfaction guaranteed. Available to any help after completion. Experience of 7 years using excel for organizing and analyzing any company variables. Experience on programming with VB in excel, creating any report using pivot tables and pivot charts, dashboards. Passionate about excel automation.
$155 AUD 3 napon belül
4,9 (32 értékelés)
5,2
5,2
Felhasználó avatár
hi! I would be happy to create the staff hours monitoring for you . You will be assured of a quality output from me. thanks
$210 AUD 3 napon belül
4,9 (64 értékelés)
5,4
5,4
Felhasználó avatár
Aeronautical engineer and MS Excel advanced expert. 30 years experience in MS Excel. VBA programming. Data mining and analysis, stochastic simulation, discrete event simulation, Excel Solver, genetic algorithms, neural networks and other advanced models. I have a high performance desktop computer with which I can deal with extremely large and complex worksheets.
$100 AUD 2 napon belül
5,0 (41 értékelés)
5,2
5,2
Felhasználó avatár
I am very able to create spreadsheet to calculate staff hours as per your requirement. I am ready to start. regards
$144 AUD 3 napon belül
4,6 (43 értékelés)
5,6
5,6
Felhasználó avatár
Hello! Thank you for stopping by our profile. We are a dedicated team of experienced and creative professional Graphic Designer having 6 years of experience who are truly passionate about creating stunning work. We are in this field since 6 years SKILL:- PowerPoint, Infographics, Illustrations, Logos, Brochures, Flyers, Banners, Posters, Christmas Cards, Graphics Designing, PDF, MSWORD, LAYout format, image editing • 100% client satisfaction guaranteed. • No front payment EXPERIENCE:- 6 years o Work 6 days a week and available online on CHAT 24x7 for any queries o Proper understanding of projects to ensure delivery within the timeframe. o CAN MEET ANY DEADLINES
$30 AUD 0 napon belül
5,0 (9 értékelés)
4,8
4,8
Felhasználó avatár
I'm the Excel / Google Spreadsheet expert with 8+ years of experience. I have a completed medical degree, a master's degree in the project management and unique life experience, which comes from the necessity to work in absolutely different areas of our life. My current software skills include (but are not limited to): - MS Office / Google Docs API / Open Office - MS Excel (expert) - Excel VBA - Excel PowerQuery / PowerPivot - Excel RegExp - Google Spreadsheets - Google Apps Script - MS Project (advanced) - MOZ/Majestic/Seo Site Checkup - Screaming Frog - Google Analytics - Google Keyword Planner and AdWords - Asana / Trello - Skype / GoToMeeting / Hangouts - GIMP / Adobe Photoshop - Other tools The Courses: Thank you please let me start work on it .
$155 AUD 3 napon belül
5,0 (9 értékelés)
4,6
4,6
Felhasználó avatár
Hello, It is a simple and easy project. You create a worksheet for each employee. When my macro runs, it will calculate the payment for each employee and share with you in a Summary worksheet as well. Please share what you are using at the moment, so that I would not work with design. Best Regards, Serdar Yalcin
$100 AUD 5 napon belül
5,0 (25 értékelés)
4,6
4,6
Felhasználó avatár
Dear Sir! I'm seeing your project description. I have good experience in this task. I will give you my best service. Please contact me so that we can chat more for this project. Thank you very much Best regards
$200 AUD 3 napon belül
4,8 (9 értékelés)
3,4
3,4
Felhasználó avatár
I process payroll at my day job. I can complete for you. Hire me - looking for extra money. I am a professional.
$222 AUD 3 napon belül
5,0 (5 értékelés)
2,9
2,9
Felhasználó avatár
Hi,I have read your requirements of Create a spreadsheet to calculate staff hours and I’m pretty confident that I will be able to get your work done within the given time your requirements conclude.I am very keen to discuss further. You can reach me at any time on online . I have also a few clarifying questions on the project.I’m an Expert, Honest, Sincere, Quick learner and Responsible worker as I’m taking my work like my Responsibility. kind regards.
$150 AUD 3 napon belül
5,0 (3 értékelés)
2,9
2,9
Felhasználó avatár
Hey, I am very competent with excel and excel formulas. I also have an experience creating project scheduling worksheets calculating the man hours involved and payment required. Kindly hire me for a good job
$155 AUD 3 napon belül
5,0 (3 értékelés)
1,8
1,8

Az ügyfélről

AUSTRALIA zászlója
Wangara, Australia
5,0
42
Fizetési mód hitelesítve
Tagság kezdete: febr. 27, 2015

Ügyfél-hitelesítés

Köszönjük! E-mailben elküldtük a linket, melyen átveheti ajándék egyenlegét.
E-mailje elküldése során valami hiba történt. Kérjük, próbálja újra.
Regisztrált Felhasználók Összes Közzétett Munka
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Előnézet betöltése
Hozzáférést adott a helymeghatározáshoz.
Belépési munkamenete lejárt, és kijelentkeztettük. Kérjük, lépjen be újra.