Previous in Forum: Increasing the Pressure by Decreasing the Pipe Size   Next in Forum: Success in Formatting of Posts
Close

Comments Format:






Change Mode
Close

Subscribe to Discussion:

CR4 allows you to "subscribe" to a discussion
so that you can be notified of new comments to
the discussion via email.

Close

Rating Vote:







Add Vote
5 comments
Rate Comments: Nested
joomunm
Associate

Join Date: May 2008
Location: Mauritius
Posts: 32

Automatic Scheduling for Meter Reading

03/01/2009 1:10 PM

I would be glad if someone could help me to schedule a factory calendar for the year 2009 so that Electricity Meter Reading tour could be timely and promptly done according to the local rules and regulations.

Saturdays, Sundays and Public Holidays are non-working days. Therefore, these days should be skipped from the calender.

We have 20 Portions to read for a whole month.

Portion 1 is read on the first day of the month, for example, Portion 1 starts on 2nd March 2009.

List of Public Holidays:

01 JAN 2009 - THU

02 JAN 2009 - FRI

26 JAN 2009 - MON

23 FEB 2009 - MON

12 MAR 2009 - THU

27 MAR 2009 - FRI

01 MAY 2009 - FRI

24 AUG 2009 - MON

02 NOV 2009 - MON

25 DEC 2009 - FRI

Thanks for your help.
Register to Reply
Interested in this topic? By joining CR4 you can "subscribe" to
this discussion and receive notification when new comments are added.
Anonymous Poster
#1

Re: How to schedule a meter reading programme to have a 30-days consumption monthly.

03/01/2009 1:44 PM

Sounds like beurocracy gone mad...
Does it really matter?
Can't they find something more important for you to do?

I'd just read it first working day of the month and be damned...
Reading it will not effect the actual consumpion.
As my big Sis would say 'You don't fatten a pig by weighing it'
Del
Register to Reply Off Topic (Score 5)
user-deleted-1105
Guru
Popular Science - Weaponology - New Member United Kingdom - Member - New Member

Join Date: May 2007
Location: Harlow England
Posts: 16512
Good Answers: 670
#2
In reply to #1

Re: How to schedule a meter reading programme to have a 30-days consumption monthly.

03/01/2009 1:47 PM

Oh, #1 was was me. If there are local rules and regulations then surely they spell out when to read it...
I dunno this seems like the sort of 'problem creation exercise' my mother in law would dream up .

Sorry if this sounds harsh... honesty is my one weakness.

Del

__________________
 health warning: These posts may contain traces of nut.
Register to Reply Off Topic (Score 5)
Hendrik
Guru
Popular Science - Biology - New Member Hobbies - Musician - New Member APIX Pilot Plant Design Project - Member - New Member Hobbies - CNC - New Member Fans of Old Computers - ZX-81 - New Member

Join Date: Jan 2007
Location: Centurion, South Africa
Posts: 3921
Good Answers: 97
#3

Re: How to schedule a meter reading programme to have a 30-days consumption monthly.

03/01/2009 1:57 PM

So they need an exact average. Such rules are absurd.

A manual way of doing it:-

Draw a grid of 30 blocks across

start with 1/1 in block 1.1.

write in the dates 1 to 30 Jan in row 1

31 Jan to .... in row 2

fill at least the last row with Jan 2010

etc .

Now mark weekends and holidays.

Now for the result - choose the first column without a mark.

If no clear column exist you may have to apply for an exception in writing.

__________________
 Never do today what you can put of until tomorrow - Student motto
Register to Reply
joomunm
Associate

Join Date: May 2008
Location: Mauritius
Posts: 32
#4
In reply to #3

Re: How to schedule a meter reading programme to have a 30-days consumption monthly.

03/02/2009 12:43 PM

Hi Hendrik,

Can you email me an Excel Template to have a clear idea of your explanation?

My email address: joomunm@gmail.com

Thanking you before hand.

M I Joomun
Register to Reply
Hendrik
Guru
Popular Science - Biology - New Member Hobbies - Musician - New Member APIX Pilot Plant Design Project - Member - New Member Hobbies - CNC - New Member Fans of Old Computers - ZX-81 - New Member

Join Date: Jan 2007
Location: Centurion, South Africa
Posts: 3921
Good Answers: 97
#5

Re: Automatic Scheduling for Meter Reading

03/02/2009 1:54 PM

I will do it here by just using the days of the week to show that it is impossible to find such dates.

M T W T F S S M T W T F S S M T W T F S S M T W T F S S M T

W T F S S M T W T F S S M T W T F S S M T W T F S S M T W T

F S S M T W T F S S M T W T F S S M T W T F S S M T W T F S

S M T W T F S S M T W T F S S M T W T F S S M T W T F S S M

T W T F S S M T W T F S S M T W T F S S M T W T F S S M T W

T F S S M T W T F S S M T W T F S S M T W T F S S M T W T F

S S ETC

You will notice that after the 4th row no column will exist

without a S.

What you will have to do is offer to read the meter on the first working day of each month and multiply the reading by 30/actual number of days between readings.

__________________
 Never do today what you can put of until tomorrow - Student motto
Register to Reply
Register to Reply
Have a Different Question?
5 comments
Copy to Clipboard

Users who posted comments:

Anonymous Poster (1); Hendrik (2); joomunm (1); user-deleted-1105 (1)

Previous in Forum: Increasing the Pressure by Decreasing the Pipe Size   Next in Forum: Success in Formatting of Posts

Advertisement

Got Something to Say?
Ask a Question
Start a Discussion

Search this Forum
General Discussion:
Go

CR4 Sections
Aerospace
BioMech & BioMed
Chemical & Material Science
Civil Engineering
Communications & Electronics
Education and Engineering Careers
Electrical Engineering
General Discussion
Instrumentation
Manufacturing
Mechanical Engineering
New Technologies & Research
Software & Programming
Sustainable Engineering
Transportation

Site Directories
Forum Directory
Blog Directory
User Group Directory
RSS Feeds

CR4 Rules of Conduct
CR4 FAQ
Site Glossary

Who's Online (111 right now)
Show Members
Advertisement