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
Hello,
I have been working as freelancer since last ~ 5 years,prior to this was working with a MNC as an Sr. Software Professional.
Below are some key areas of my skills:
-- VBA and Excel,Word,Office Applications
-- Expert on C# using .NET framework using Visual Studio 2012 and 2013
-- Expert in VB.NET using VS2012/VS2013
-- WPF and Windows Forms Application
-- Expert in ASP.NET,MVC
-- JS,Google extensions and google scripts
I have experience in all the above areas and during my project work I have completed all of the above tasks.
As a Freelancer also I have worked in few of the above areas where I got a chance and delivered the best.
Delivering best & Customer satisfaction is the key for any individual and I always worked keeping these things during project execution.
Would be looking forward to work on this opportunity and will ensure to deliver best.
Regards,
Abhinov
we are experts Developers team in developing E.r.p & Book Keeping & C.R.M Application
we have lots of global clients from manufacturing , retail stores , wholesale business, schools , hospitals ,where we had completed all the modules according to customer requirements
Hi,
I can work for you on this project. You can contact me at any time to get my services. I will give you good results with satisfaction guaranteed.
Thanks.
I am good in data entry. I can work in your project graphic designing! I Am good in Ms Office and i can in photoshop to
I also know about email hadnling dat extraction web searching web scrapping i am also good in VA Virtual Assiatance and
video editing, video uploading.
Hello ,
I am Falguni Ahmed .I am very much interested on your project .I feel that I am the exact match for your requirements after thoroughly reviewing the job description and desired skills I experience in Data Entry, Data Processing, Excel, Visual Basic. Here I would like to mention that if you get enough time to give me a better feedback it would be very helpful for me..I would highly pleased if you consider my particulars yours obediently.
So I hope your kind response.
Regards
Falguni Ahmed
Hi
Based on the data provided by you, I have already prepared a sample sheet which fulfills your requirements and allows you to analyse your revenue on various parameters like per child, per week, per month, per quarter. It is automated such that you can add/ delete children and get the output.
I could share my screen and explain my worksheet that i made based on dummy data. Post which you can accept my bid
Regards
Srikanth. S
7 3 3 7 2 0 0 1 8 5