everydayExcel

How do I disable the warning about circular reference?

I am working on a spreadsheet with regards to construction,

i have a start date say 1 july with a duration of 10 days to carry out the works, therefore we need to complete 10% per day, i have a summary progress chart that will record the % completed, however i need to calculate the planned %, so my problem is how do i link the start date to the summary and get the same to calculated the same on a daily bases, ie todays planned is 10% and every day thereafter the planned % needs to increas by the daily planed %

Regards

working file on formula

amhaving problemswith what lookup is all about, what it is used for and how it is being used

Hi there

I need your help to create an excel formula.
I have students in my programmes and have both full time students and part time students.
Minimum period of enrolment for full time student is 12 months ( 2 semesters) and 18 months ( 3 semesters) for part time students.
Maximum period of enrolment for full time student is 36 months ( 6 semesters) and 48 months ( 8 semesters) for part time students.
My problem is that students are allowed to change their study plan from full time to part time.
As students’ enrolment status is changed to full time to part time or vies versa, the minimum and maximum period need to be changed according to students’ enrolment status.
Is it possible I can get a formula to have remaining period of their study in a single glance?

File – (removed)

I was trying to move a set of worksheets containing tables to a new file and a message pops up telling me that I am not able to do so. This happens to both Excel 2007 and 2010 file. So to resolve this, I guess the alternative is to re-save the file and delete the unwanted worksheets. Another method is to copy  or move the file to the new file one by one.

Have you filed your income tax? If not, it is good to start working on it now. It is due on 18 Apr. For couples who are both working, it might be good to find out who should claim for the relief and save on the taxes. I have created a simple template to help you. Click on this Income Taxes to download. Do give us your feedback on this template.

I need a loan amortization table where loan tenure,initial grace period (during which no payment is made), interest rate, repayment-terms(monthly, quarterlr, semi-annual, or annual) are flexible to change. Maximum tenure will not be more than 15 years excluding initial 2 years grace period, however, I should be able to play around these numbers depending upon free cash flow.

Thanks
Mansoor
Cell:+966 50 300 1714

During our courses, we found that some of the participants are not very sure when to use SUM and COUNT. A few of them have the impression that when you need to total up the numbers, e.g. number of employees, COUNT should be used. This is not always the case. The rule is to remember that when you need to count the number of cells in a range, you use COUNT. Therefore, if you select 2 cells, the COUNT result is 2. If the numbers in the 2 cells are 9 and 8 respectively, SUM will give you the result as 17. The same concept applies to SUMIF and COUNTIF.

When the word business modelling is mentioned, people have the impression that it is some sort of complicated Excel stuff that they will probably not use it. But on the most basic level, business modelling is nothing more than creating a template that allow you to perform computation that consists of multiple variables/factors. Of course, if the computation is business related, it is called business modelling. That does not mean that it cannot be for personal stuff, like computing how much income tax you need pay, how much money you need to have to buy that house or car, etc.

I hav a data sheet with a list of 100 venues each with diffrent room hire costs for each day of the week. I am looking to get a formulae that will pick up the costs based on the venue and day chosen.

http://www.excel-course.com/wp-content/uploads/2013/03/Receipt-Stats-2013-v21.xlsx