Build me an excel calendar with some functionality
$10-30 AUD
Pago na entrega
Hi, I am looking to create an excel spread sheet that:
1) Lets me type in a date
2) The excel girds will populate 12 month calendar on 1 page from the date (in arrears)
3) Each month column needs to have 4 areas like the image attached:
a. Date (pre-populated – see image below)
b. Day (pre-populated – see image below)
c. Empty cell (FOR DROP DOWN Code – see point 4)
d. Cell for me to input an INTEGER – this will be hours taken (e.g. 15.4)
4) Drop down admin populates on another sheet in alph numeric order – I will add the code A, B, C, H, L, P, S in the drop down.
A = annual leave
B = bereavement leave
C = carer leave
H = public holiday
L = long service leave
P = parental leave
S = sick leave
5) The Cell Should default to nothing
6) When the calendar is populated, a pie chart and bar chart with will be updated.
7) Bar chart needs to show dates for the flat horizontal axis and hours in the vertical left axis.
8) Bar chart needs trend line as well
9) Pie Chart meeds a breakdown of hours based on code
10) I need a cell which tells me the %age ratio of Sickness to Worked Hour. This is the Total number of Sickness Hours / Total number of Worked Hours (which would include regular hours and planned holiday Leave, multiplied by 100. The holiday leave are codes A, H, L, P – These reports are focusing on sick, carer and bereavement leave
ID do Projeto: #26685417
Sobre o projeto
Concedido a:
Greetings I have read your project and i have more than two decades of experience in Excel and Database. I have completed many tasks of Chart development and functionality of Spread Sheet. i submitted project of chart Mais
8 freelancers estão ofertando em média $42 nesse trabalho
------------------I CAN START RIGHT AWAY 100% ACCURACY------------------- Hello sir, I can Build an excel calendar with some functionality by maintaining 100% accuracy of your data absolutely as you want. ------- VBA M Mais
hello! I can help you with your project. You can be assured of a high quality and accurate output. I hope you will consider me, thanks!
Hi there, I am an expert in excel formulas, dashboards, macros.I have gone through the description on your project and will be able to finish before the deadline. Thanks Arun
Hi Sir/Madam I have read project description carefully and I am an expert of excel sheet. I want to know about your project in more details via chat with you. Please send me a message. Thank you.
sir/mam before applying for this project I have gone through your job description and found that my skills and interest are matched with the requirement of the company being a fresher I have been looking forward to the Mais
I am interested. with sample. No advance. Paid after satisfaction only. I have done this many time in Excel. I will design a calendar for you with holiday and all kind of priority that u will say. thanks