Converting leave (date and time) information to calendar form - repost
$15-25 USD / hour
已关闭
已发布超过 10 年前
$15-25 USD / hour
I need a code to automatically post information from the leave summary to the leave calendar.
Information from Column B, C, H, I and K from the individual summary need to be transferred to the leave calendar. Please take a moment to view them the summary and calendar as it is complicated to describe it all.
Column B and C is the first and last name for the individual.
Column H and I is for the date(s) the leave is taken, and is needed to plot the exact coordinates on the leave calendar.
Finally, Column K is the total number of hours which applies to annual leave only.
7.5 hours is the maximum for one day. Always use 7.5 hours for the first day, and let the remainder be distributed to the following days. For example, if an 11.5 hour annual leave is taken for 2 days, put 7.5 in the first block and 4 hours in the second block, and color the first light blue and the second brown (for any value under 7.5). Please see the legend for the correct colors.
For the rest of the leave type, color the box with the correct color but leave the value blank.
Please also provide instructions how to use this code for individual summary that is generated in the future.
Serious bidders only, thank you!
Good day,
I am expert. I teach excel. I can say there is no formula in excel that I cannot handle it. I've got lots of experiences in excel automating and conditional formatting.
Here are the links for my past experiences:
https://www.freelancer.com/projects/Excel/Drawing-EXCEL.html
https://www.freelancer.com/projects/4848189.html
https://www.freelancer.com/projects/Visual-Basic-Excel/Excel-user-form.html
https://www.freelancer.com/projects/Excel/Excel-Spreadsheet-Timecard-for-work.html
https://www.freelancer.com/projects/Data-Entry-Excel/Excel-Line-Restructured.html
Regards.
Please share the leave summary and calendar so that I can analyse how to go about it and also assess scope of work.
I will then let you know my fixed cost for the project as I prefer working on fixed cost basis.
I commit only if I am confident of delivering and once committed I ensure a very thorough job and also support if you need changes / enhancements in future. I look forward to hearing from you and working on the project.
Hello,
can i get the file to converting leave (date & time), because there is no file attached.
regards,
...................................................................................................................................................
My Skills are acquired in : Data Entry, Data Processing, Excel, Word. I have experience in Absence Management and peoplesoft. We can chat further for more details and send email
Hello there,
Greetings for the day!!
Thanks for sharing your requirements over Freelancer.
I have well understood the proposed Calender project. I have extensive expertise in working on similar projects. I can easily work on building the Calender as per your requirement.
For greater confidence on my abilities, please go through my Freelancer Portfolio shared below wherein I have uploaded samples of similar projects done recently.
https://www.freelancer.com/u/dkd12.html
I can quote a ballapark cost estimation of $14/hr + Freelancer fees.
Looking forward for a favorable response.
Sincerely,
Deepak
Hello, I have significant experience creating Excel macros for automation of sales/financial analysis and automation of data entry into other systems such as AS/400 systems. I feel that I can finish this project quickly for you as I have done similar projects many times while working in a traditional work environment.