Completed

Excel expert for forecasting

Trying to create a revenue forecast for a childrens day nursery.

Each child has a booking pattern eg Alice Mon 10 hours, Tue 0, Wed 5 hours, Thurs 0, Fri 5 hours = 20 hours.

The nursery is open 51 weeks a year, but also closes on public holidays. For 2018 these are 1st Jan, 30th Mar, 2nd Apr, 7th & 28th May, 27th Aug and it is shut 24th - 28th Dec.

What is the best way to calculate the hours for each week for each child making sure that we don't include hours when the nursery is closed?

So far I have created a calendar for the next 3 years with all the bank holidays highlighted in red - not sure if I am going down the right route with this.

So what I need is to compute the range and give me number of hours booked for a child, keeping in mind the public holidays occurred in between. checked attachment if you fully understand project then bid plz.

my budget is $10

A - afternoon

M - morning

D - Full day

Skills: Data Entry, Data Processing, Excel, Statistics, Visual Basic

See more: forecast wizard excel, forecast wizard excel download, excel forecasting tools download, free forecasting software excel, microsoft forecaster excel add in, free forecasting tools in excel, proforecaster, excel forecasting add-in free, excel expert freelance contract jobs, buy excel expert, freelance statistician excel expert, excel expert service, excel expert job, excel expert finance job, excel expert independent contractor bid

About the Employer:
( 0 reviews ) DUBAI, United Arab Emirates

Project ID: #15871417

Awarded to:

SoufianeAch

Hi, I'm good in excel and data processing. I have completed many processes automation using excel. I'm rigorous and conscientious; I will complete the task to the highest standards. Please get in touch to discuss in More

$10 AUD in 1 day
(3 Reviews)
2.6

16 freelancers are bidding on average $20 for this job

renesontiongson

Pleasure to help you. Excel automation is my masterpiece in my accounting field. Feel free to message me to start the job. Thank you so much.

$20 AUD in 1 day
(64 Reviews)
5.3
arslantahir87

professional candidate for the job. i will forcast your details for coming year with accuracy looking for ur response

$25 AUD in 2 days
(13 Reviews)
3.3
manish1988ag

Hi, I am interested in your project and I would like to know more details. Kindly drop a message so we can discuss. I have more then 5 years experience of advance excel such as lookups, pivots, macros, vbscripts etc More

$15 AUD in 2 days
(4 Reviews)
2.0
sumonahmed1122

Dear Sir, Cordial greetings from self side! Sir with due to respect and humble i would like to inform you that i want do this job with less price, if you select me. Thank you with regards!

$25 AUD in 1 day
(3 Reviews)
1.4
vipingfreelancer

Hello, I have experience in MS Excel as well in Statistics, I have done many projects in excel

$10 AUD in 1 day
(2 Reviews)
0.7
Cabr

A proposal has not yet been provided

$25 AUD in 1 day
(0 Reviews)
0.0
kushalkuma

Hi, I have over 7 years of experience in different industries like finance banking telecom. I am expert in excel with advanced function and formula (VBA, MACRO), ms word, ms PowerPoint.

$25 AUD in 1 day
(0 Reviews)
0.0
Shruti110

I can do the project easily. Please provide the detailed requirement/output of the project ad give details like revenue etc. for each student

$40 AUD in 2 days
(0 Reviews)
0.0
mohamedgouda3

I'understand the project [login to view URL] i can do so easy , i'm professional in Microsoft Excel works Please , contact me to discuss further details.

$13 AUD in 2 days
(0 Reviews)
0.0
jatin12970

Having strong skill to represent data in Excel with graphical represetation. Be an Engineer, always submit such reports to higher management

$27 AUD in 2 days
(0 Reviews)
0.0
djolegajic

Dear Sir, I am a final year finance student, with completed Excel advanced course. I suppose that I am perfectly suitable for job you offer. I think that the best to calculate hours is to calculate number of days t More

$15 AUD in 3 days
(0 Reviews)
0.0
capraveenbagda

I have understood the instructions and file. Can easily complete the task. Relevant experience (of Excel) of approx 6 years. Hoping for positive feedback.

$10 AUD in 1 day
(1 Review)
0.0
nguyennhuly1989

I am Ly. I have experience for excel. So I can do this project. Pls contact me to discuss for project. I can help you. It needn't pay money.

$15 AUD in 2 days
(0 Reviews)
0.0
$25 AUD in 1 day
(0 Reviews)
0.0
shyafeeq

Hi As a data entry clerk, your posting have me attracted to as this is my field of expertise. I have a Degree of Office System Management and capable of doing data entry perfectly. I'm looking forward for your More

$25 AUD in 1 day
(0 Reviews)
0.0