Ditutup

Work out Excel formulae

Background,

We are an out of school club that runs a breakfast and after school club with a long day on a Friday. We charge different amounts for Monday to Thursdays and Fridays. Breakfast price remains constant.

Requirments

I need an excel code/formula written to express the monthly fee that a customer has to pay for each school year. For 2015 we used the below for each customer but now need to streamline it. I need someone to write the forumla so I can put in the days required, and a price will come out so I can invoice the client

“ We use a formula to enable a standard monthly fee, rather than differing amounts for each

term.

We take all the days that your child attends throughout the school year, add the fee

to each day and divide it by 11 (the months that the children attend school). Holidays and in

service days are deducted through this calculation.

Example: Child attends breakfast club on Mondays and Thursdays:

Total Mondays plus total Thursdays in 2014/15 school year = 73 days

Fee per breakfast club session = £3

2015/16 year fee (73 × 3) = £219

Monthly fee (219 / 11 months that a child is in school) = £19.91”

I also need to be able to update the number of each day in a year and the price for each day.

Please ask anything if you need to.

Thanks

Kemahiran: Excel

Lihat lagi: work sheets excel work book java, excel work rosters, creating excel work book dynamically, excel, microsoft excel, excel work needed, convert excel work label, department reports companies pakistan using excel work sheet, excel work instruction template, excel vba add installation, excel work sheet design

Tentang Majikan:
( 11 ulasan ) Mussleburgh, United Kingdom

ID Projek: #10107820

51 pekerja bebas membida secara purata £8/jam untuk pekerjaan ini

£45 GBP / jam
(250 Ulasan)
7.6
P0L

Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

£10 GBP / jam
(273 Ulasan)
7.2
priyal1997

Dear Sir/Madam, I’m happy to help you on this task. I’ve read your brief and happy to discuss the project in more detailed. I am highly qualified for this project and have already done lots of similar excel templates Lagi

£10 GBP / jam
(184 Ulasan)
6.7
cugamelover

I can do exactly what you need. I'm a computer science professional with a PhD degree and extensive experience in Excel and VBA. I've done a lot of similar work. I could send you samples of my work if you wish. Please Lagi

£8 GBP / jam
(166 Ulasan)
7.0
Tanmoy236

I am extremely good with excel as it is part of my daily professional work. I am fast accurate and at the same time understand the value of quality and deadlines. I have already done 62 works on Freelancer where I got Lagi

£8 GBP / jam
(175 Ulasan)
6.6
elqueabandona

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. They speak for themselves. Best rega Lagi

£10 GBP / jam
(205 Ulasan)
6.8
TonmoyRoy111

Dear client, I have sound knowledge in Excel and I have previously carried out a number of projects in excel using macros and formulas. I ensure you will be happy after hiring me. Kindly contact me for further detail Lagi

£5 GBP / jam
(275 Ulasan)
6.5
watersev

Hi there, I would suggest to create a template sheet for doing that sort of calculation that would have a dates table: start date to end date, week days for every day and prices shown. That way you can easily amend pri Lagi

£5 GBP / jam
(244 Ulasan)
6.4
imperturbable54

This is my primary Bid details Hello, hope you are well.I have just seen your project and understood what you [login to view URL] doubt your thought is good.I want to gratify you by doing your work can . i AM READY TO WORK. As lo Lagi

£10 GBP / jam
(127 Ulasan)
6.5
dpune

Hi, I have more than 14 years of VBA/Excel exp and I am expert in this kind of work. Let us discuss more to review requirements. I have completed more than 270 projects. Please look at the feedback left by my em Lagi

£10 GBP / jam
(115 Ulasan)
6.2
royalcalif

I Can Start Immediately ***PM me for more Information and Sample*** Hi Mr. Employer, Glad to contact with you. I can do this project through effective manner with 100% accuracy fulfilled your requirements. I as Lagi

£7 GBP / jam
(66 Ulasan)
5.6
£8 GBP / jam
(51 Ulasan)
5.3
archanaoswal

I have excellent command on MS Excel. I have completed complex projects in Excel before involving Userforms, Macros, formulas, graphs etc. For instance - Build a reservation system - Build a complex shift allowance c Lagi

£8 GBP / jam
(69 Ulasan)
5.5
robertal

UPDATE: It only took two hours to do the basic version - I was at a loose end :) For £15 fixed price project it is yours to take away! I am an Excel expert highly proficient in VBA macros; my previous experience has Lagi

£6 GBP / jam
(8 Ulasan)
4.7
teeares

The total Mondays in a year is 52(53 some years). I do not know how you got the figure of 73. You have mentioned school years. How is that defined? Anyway, whatever, is the calculation, I can get you the Excel formula Lagi

£5 GBP / jam
(50 Ulasan)
5.0
webanis

Hi , I am interested by your offer: Excel (VBA code). I will be happy to do this job even though I'm new in the field of freelance. Let me know more details of this work. I will start working immediately :) Lagi

£5 GBP / jam
(16 Ulasan)
4.0
tomkusvw

Hi! My name is Tomasz Kustra, and I am from Poland. I am interested in this project. I can do such thing for you with no problem. using formulas or macros. My last project using VBA is here: [login to view URL] Lagi

£10 GBP / jam
(2 Ulasan)
3.7
kchg

Hello, sir. I am very interested from your project. I'm TOP 6TH freelancer as you can see my profile: (https://www.freelancer.com/u/kchg.html). I have enough skills for your project. Kind Regards

£15 GBP / jam
(1 Ulasan)
3.4
gsanggara

Hello, I am interesting to your project and placed bid for your consideration. With my experience in excel formulas, template's and macro I am confident that I will able to complete your project as per timeline and req Lagi

£5 GBP / jam
(18 Ulasan)
3.6
mrfarhanzahid

hi there, I am MBA student, I have studied your requirements, i can work on your project, hoping to see response from you

£5 GBP / jam
(15 Ulasan)
3.6