Revised PTO Log

@zafarfarooq612

Hello, I am an experienced Excel specialist with a strong background in building and revising leave-tracking logs with complex anniversary-based rules, and I can update your workbook accurately and cleanly. I will revise the existing formulas to correctly calculate sick and vacation time based on hire dates, probation periods, and multi-year milestones, ensuring the blue and green columns behave exactly as specified for employees hired before and after 2025. I will also add a dedicated sheet for Ailyn with her 6-hour workday rules and correct sick and vacation accruals, as well as a separate “Part Time Worker” sheet for 4-hour employees with properly scaled vacation entitlements at the 1- and 5-year anniversaries. All changes will be clearly structured, formula-driven, and easy to maintain, so the log remains accurate, transparent, and reliable going forward. Regards, Zafar

@ameenulhaq66

Hi Rumble, Thank you for considering my proposal. With over 8 years of real-world experience and freelancing in Excel, I am confident in my ability to assist with your project. I have carefully reviewed the requirements for revising the PTO log attached and am eager to discuss the details further. I would like to connect with you in chat to delve deeper into the specifics of the project and ensure that I can provide the tailored solutions you are looking for. Your project aligns perfectly with my expertise, and I am committed to delivering high-quality results. Looking forward to discussing this project with you in more detail. Regards.

@carlitanjuguna05

Hi there, I’m confident in my ability to revise the PTO log according to your specifications. With extensive experience in Excel and data management, I understand how crucial accurate tracking of sick and vacation days is for employee satisfaction and administrative efficiency. I’ll ensure that the sick and vacation time categories are updated per your guidelines, including adjustments for Ailyn's specific needs and creating the new sheet for part-time workers. The formulas and calculations will be meticulously crafted to reflect the unique circumstances of each employee category. I anticipate that this project can be completed within 5 days. Once I have your go-ahead, I can begin immediately to ensure that the log is revised effectively.

@muhammadj121

Hi there! I can update your Excel log to correctly calculate sick and vacation hours based on hire dates, probation, and anniversary rules, including the new sheets for Ailyn and a part-time worker. All formulas will be automated, accurate, and easy to maintain. With 8+ years of experience in Excel, I deliver accurate, efficient, and well-structured data solutions—on time and within budget. I specialize in: Advanced Excel dashboards, formulas, and pivot tables Data cleaning, analysis, and visualization VBA/Macro automation to save time Google Sheets automation via Apps Script You’ll receive: Fully editable, documented files Clean, easy-to-use dashboards Fast communication and unlimited revisions View my profile and work: freelancer.com/u/muhammadj121 Looking forward to helping streamline your data processes! – Junaid

@giaphung2k1

Hello Hello — I can revise your PTO log for clarity, accuracy, and usability. With experience improving HR forms and Excel documents, I’ll reorganize layout, correct wording, add formulas/validation and formatting, and deliver a polished, ready-to-use file within 48 hours. I’ll revise until you’re satisfied. Please share the attachment. Giáp Văn Hưng

@durgesh8527

As a highly experienced Full Stack Software Engineer with over 12 years in the field, I can certainly take your Excel log and transform it into an automated and efficient time management solution that ensures accurate calculations of sick and vacation days for various employee scenarios. My proficiency in Python and more specifically Django platform has equipped me with the skills necessary to handle complex calculations and manage data seamlessly - a perfect fit for your project needs. I have extensive experience in data management, manipulation, and automation. This includes dealing with complex formulae over multiple sheets to provide precise calculations. Additionally, using my web development skills, I'll create new sheets on demand such as for Ailyn's 6 hour work day and part-time workers using Excel's formulas and my skills set: HTML5, CSS3, Jquery and Bootstrap to ensure consistent results. Having successfully managed hundreds of projects myself, I understand the importance of meeting strict deadlines while maintaining high-quality output. This is why I'd be ideal for your project; in addition to my technical capabilities, I'm also readily available for collaboration being in a compatible time zone. Tackling the complexity of managing sick and vacation time should not burden you anymore because once I'm on-boarded, all those problems will be elegantly abstracted away providing you with an easy to manage interface.

@Joejoe777

Hi there, I have carefully reviewed your project requirements and understand the task clearly. After analyzing the details and expected outcome, I am submitting this proposal with a focused and practical approach to revising the PTO log in the attached Excel file. To meet the specified criteria: 1. The blue column will represent sick time, starting with 40 hours for workers after their 90-day probation. 2. The green column will track vacation time. Employees hired before 2025 will receive 40 hours/5 days of vacation in the first year, doubling to 80 hours/10 days on their 4th year anniversary. 3. Employees hired in 2025 will have no vacation time in the first year and receive 40 hours/5 days on their 1-year reload anniversary, doubling to 80 hours/10 days on their 5th year anniversary. 4. For Ailyn, a new worker with a 6-hour workday starting on 1/7/26, a new sheet will be created with 40 hours of sick time and 30 hours of vacation on her 1-year anniversary. 5. Ailyn's vacation time will double to 60 hours/10 days on her 5th year anniversary. 6. A sheet named 'part-time worker' will be added for a 4-hour worker with similar sick time allocation. 7. Part-time workers will receive 8 hours/2 days of vacation on their 1-year anniversary, increasing to 16 hours/4 days on their 5th year anniversary. Let's discuss in detail through chat.

@muzafar042

Greetings, I can accurately revise and restructure your Excel log to fully reflect these sick and vacation accrual rules, including correcting formulas, anniversary-based triggers, and creating clean, easy-to-audit worksheets for full-time, part-time, and Ailyn’s custom schedule. I have strong experience building HR-compliant Excel trackers using date-driven formulas, conditional logic, and clear documentation so future updates are simple and error-free. I will ensure sick time begins after the 90-day probation, vacation rules differ correctly by hire year, anniversary milestones are calculated automatically, and all new sheets are formatted consistently and professionally. My goal is to deliver a precise, reliable file that meets your policy requirements and minimizes ongoing administrative effort. Best regards, Muzafar Hussain

@QuickMentor

Revised PTO Log I’m an experienced Full Stack Developer skilled in JavaScript (React, Node.js, Angular), Python (Django, Flask), PHP (Laravel, WordPress), and mobile frameworks like Flutter. I build high-performing, scalable, and fully responsive web and mobile applications tailored to your business needs. I ensure clean, efficient code and timely delivery. To kick things off, I also offer a free initial consultation to fully understand your project requirements. Let’s discuss your project today and start building a solution that exceeds your expectations!

@romanpotapcz

**Database Processing** Hi there! I’m an experienced Excel specialist and can revise your log per your specifications. I’ll update sick and vacation time formulas for pre-2025 and 2025 hires, create a sheet for Ailyn (6-hour day) with correct sick/vacation accruals, and add a “part-time worker” sheet (4-hour day) with proportional vacation and sick time. All formulas will be automated, accurate, and easy to maintain. BEST REGARDS

@cloudaxisltd

I’m confident I’m the ideal person for your project, clearly understanding the need to create a seamless, automated Excel log that manages sick and vacation time based on hire dates and work hours, including special rules for part-time and new employees like Ailyn. The goal is a clean, professional, and user-friendly workbook with integrated formulas updating balances accurately. While I am new to freelancer, I have tons of experience and have done other projects off site involving Excel formula automation and employee time tracking. I would love to chat more about your project! Regards, Henning Munnik

@Jomsmathews

As a graphic design artist by trade, I developed a knack for meticulousness and organization, and these are the exact skills you need for your revised PTO log. Although I must admit this project falls outside my core skills, I do have deepen understanding of excel functions. Throughout my 8+ years in professional design, I have consistently delivered top-tier work. My clients admire me for my ability to deliver creative, innovative solutions within deadline, often taking previously disorganized data and molding it into a visual masterpiece. Your PTO log requirements might be complex to grasp initially but rest assured my eye for detail will enable me to incorporate all specifications perfectly. Let's talk about adapting to the changing PTO scenarios. These changes appear challenging but are genuinely interesting as well. It would be great to discuss the formulas you currently have implemented and how we can mold them to accommodate the new rules. Excel is a powerful tool in my arsenal and with my expertise, your PTO log will be transformed into an efficient, user-friendly tool that accurately captures each employee's vacation time. Let's transform our ideas into reality ready to chat about the project and bring our vision to life Budget and deadline will be discussed over chat https://www.freelancer.ca/u/Jomsmathews Regards, Joms D.

@elinaikes

Hello, My name is Elinaike Towo, and I would be glad to assist with revising and updating your Excel log based on the outlined requirements. I have strong experience working with Excel formulas, employee leave tracking, and anniversary-based accrual systems, ensuring accuracy and clarity in all calculations. I will: Correct sick time calculations, ensuring the 40 hours begin after the 90-day probation period Update vacation time rules for employees hired before 2025 and those hired in 2025, including all anniversary-based increases Create a new sheet for Ailyn with a start date of 1/7/26, reflecting her 6-hour workday, sick time eligibility, and vacation accrual milestones Apply the correct vacation increase on Ailyn’s 5th-year anniversary Add a “Part Time Worker” sheet for 4-hour employees with accurate sick and vacation formulas Ensure all formulas are clean, consistent, and easy to maintain moving forward I’m detail-oriented, reliable, and committed to delivering an accurate and well-structured Excel file that meets your needs. I look forward to the opportunity to work with you. Kind regards, Elinaike Towo

@prasadsah8642

This job best job for me please give me this opportunity।I completed this job on time। I from India jharkhand state।

@strdmgrblr

I can streamline your Excel log to ensure clean, automated sick and vacation time tracking that adjusts seamlessly for full and part-time employees. Your detailed requirements for probation periods, anniversary adjustments, and varying work hours caught my eye. This will create a professional, integrated, and user-friendly workbook with separate sheets for employees like Ailyn and part-time workers, applying precise formulas for accurate time accrual. With expertise in Excel automation and HR data management, I’ll deliver exactly what you need. Does this approach sound like what you’re looking for? Regards, Alicia

@mahmoudm272

Hi, I'm mahmoud , I have experience 12 years in the excel and in the material management Why you trust me ?! Because i will show some workbook for the business (jouranl entry- banking - LG - deposits - material management- AP - AR ) and i depending on the easy way I'm prepared alot of databases by excel I will explain the concept so you don't need any support I can progress this in a few days even if you need any editing it will be for free Helping you to get the best practice to manage your business professionally

@Simrandk5

Just give me 2 days and I'll deliver this project to you I can revise your PTO Excel log exactly as described. I have experience with HR data management, Excel formulas, and employee leave tracking, and I’ll ensure sick and vacation time are correctly calculated for all employees, including part-time and new hires like Ailyn. I’ll also create separate sheets where needed and make formulas dynamic so future updates are easy. I can deliver accurate and ready-to-use logs efficiently. Looking forward to helping you streamline this PTO tracking!

@tdse7

I help businesses grow through smart web development, clean design, and strategic content delivering digital solutions that are secure, scalable, and user focused. Your Excel log needs clean and automated formulas that ensure seamless tracking of sick and vacation time based on hire dates and hours worked. I understand the importance of integrated sheets for full-time, part-time, and specific employees like Ailyn with customized hours and anniversary rules. I have tons of experience and have done other projects off site involving complex data management and user-friendly spreadsheet design. I have a few ideas to make these time tracking sheets top notch and easy to maintain. I’m passionate about delivering top-notch results and am ready to go the extra mile for your project. Let’s achieve great things together. Kind Regards, Tiaan

@ABDULLAH0150

Hi, I will revise your Excel log exactly to your rules and add the Ailyn (6-hr) and Part time worker (4-hr) sheets with correct sick/vacation formulas. I will deliver the updated master log, Ailyn sheet, part-time sheet, backup copy, changelog, and a QA/reconciliation summary. I will implement: 90-day sick eligibility (40h), pre-2025 and 2025 hire vacation rules, Ailyn’s 1-yr/5-yr hours, and part-time prorated vacation (2 days → 4 days). All formulas use built-in Excel functions, no macros required, with data validation to avoid blank mandatory cells. I never overwrite originals and will keep an untouched backup tab and provide a rollback-ready file. Looking forward to your response. Regards,