Maintenance planning

**kong** · 03-29-2010, 05:27 AM

Hello,

I am trying to do a sheet which plots the month of each maintenance depending on its next date and the frequency. I cant seem to get my head around it!!

Can anybody help? basically I need a 1 in each of the month the maintenance will hit yearly.
so if the job was for march and the freq is 4 then i need a 1 in mar, jun, sep, dec and the rest will be 0.

Any help will be appreciated, thanks in advance!

Kong.

**DonkeyOte** · 03-29-2010, 05:51 AM

Can you explain the logic behind your example ?

Surely if freq. was 4 and first instance was March then the 2nd instance should be July and third November, no ?

Using your suggested results the implication would be such that for a frequency of 2 each and every month would be used as opposed to every other month ie:

Mar, Apr, May

rather than

Mar, May, Jul etc...

we would expect there to be "frequency-1" blanks between the 1's.

Please confirm.

EDIT: just to furnish by means of example... assuming above logic to be correct then, using your file,

F3: =IF(F$1<$E3,0,0+(MOD(F$1-$E3,$D3)=0))
copied across matrix

**kong** · 03-29-2010, 05:56 AM

sorry you are right, i tried to simplify it before posting it and messed it up. that freq was the no of visits a year not frequency! i would like it to be zeros if poss.

thanks for your quick response and sorry the confusion!!

**DonkeyOte** · 03-29-2010, 05:58 AM

Per my late edit see if the below achieves the desired results:

F3: =IF(F$1<$E3,0,0+(MOD(F$1-$E3,$D3)=0))
copied across matrix

**kong** · 03-29-2010, 06:11 AM

thanks alot, is it possible to populate prior months from the start month?

eg. if the start month is jun and freq is 4 can mar have a 1 in it too? as i want to see the whole years maintenance.

thanks again.

**DonkeyOte** · 03-29-2010, 06:16 AM

Yes, simply take out the pre-emptive IF

F3: =0+(MOD(F$1-$E3,$D3)=0)
copied across matrix

(note I presume you meant Feb rather than Mar...)

**kong** · 03-29-2010, 06:32 AM

you are the man!! thanks alot!

**Udul** · 07-02-2012, 07:22 PM

Hi

I never used excel for maintenance planning as I'm working with projects,but I have a interview on tomorrow as a maintenance planning officer.Is anyone can help me to learn basics (let me know basic steps to schedule maintenance work for one year).It is much appriciated as I just google to find it,then I found this forum.
How can I create below equation

F3: =IF(F$1<$E3,0,0+(MOD(F$1-$E3,$D3)=0))

**arlu1201** · 07-03-2012, 02:51 AM

Udul,

Welcome to the Forum, unfortunately:

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.