Build me an excel calendar with some functionality

Concluído Postado há 3 anos Pago na entrega
Concluído 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

Excel

ID do Projeto: #26685417

Sobre o projeto

8 propostas Projeto remoto Ativo em há 3 anos

Concedido a:

professional800

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

$10 AUD em 1 dia
(15 Comentários)
4.2

8 freelancers estão ofertando em média $42 nesse trabalho

AnowarRatul

------------------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

$39 AUD em 1 dia
(203 Comentários)
6.1
sevillajk01

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!

$200 AUD in 7 dias
(45 Comentários)
5.1
arunkumar9896

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

$30 AUD em 1 dia
(9 Comentários)
3.4
usamarehman377

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.

$10 AUD em 1 dia
(5 Comentários)
3.2
GURPREET49114

Good job Relevant Skills and Experience Excel

$25 AUD em 1 dia
(0 Comentários)
0.0
NishantGoel1999

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

$10 AUD in 10 dias
(0 Comentários)
0.0
tabrejalam344

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

$10 AUD em 1 dia
(0 Comentários)
0.0