Previous in Forum: Preventing Addiction to Internet   Next in Forum: HeartBleed Checker
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
2 comments
Rate Comments: Nested
Anonymous Poster #1

Distribution Linear in Excel

04/06/2014 6:41 AM

Dear All

I am working as a project scheduler, I have create daily progress reporting in excel I made formula to distribute the quantity on daily plan ( =IF(AND(06/01/2010>=Start Date,06/01/2010<=Finish date),Daily plan Quantity,""), can anyone help to create formula to distribute weekly instead of daily.

Regards

Mohd

KSA
Reply
Interested in this topic? By joining CR4 you can "subscribe" to
this discussion and receive notification when new comments are added.
lyn
Guru

Join Date: Oct 2008
Posts: 42355
Good Answers: 1693
#1

Re: distribution linear in excel

04/06/2014 11:18 AM

Staple each day's report together.

Just like magic, at the end of the week, a weekly report.
Reply
NotUrOrdinaryJoe
Guru
Popular Science - Cosmology - New Member Technical Fields - Technical Writing - New Member Engineering Fields - Energy Engineering - New Member Engineering Fields - Electrical Engineering - New Member Engineering Fields - Control Engineering - New Member Engineering Fields - Electromechanical Engineering - Old Member, New Association

Join Date: Apr 2008
Location: Lexington, KY
Posts: 1639
Good Answers: 73
#2

Re: Distribution Linear in Excel

04/11/2014 3:56 PM

From the date in the equation, it looks like this was borrowed from an Excel sheet that used to work in June of 2010. You have provided the arguments without stating what other arguments might be available (and defined) such as "Weekly plan Quantity" or something like it.

I'm not sure you need an Excel sheet for this. Why not just mark a line on the wall where start and finish are located and throw a dart somewhere in between.

__________________
 A great troubleshooting tip...."When you eliminate the impossible, whatever remains, however improbable, must be the truth." Sir Arthur Conan Doyle
Reply
Reply to Forum Thread
Have a Different Question?
2 comments

Previous in Forum: Preventing Addiction to Internet   Next in Forum: HeartBleed Checker

Advertisement

Got Something to Say?
Ask a Question
Start a Discussion

Search this Forum
Software & Programming:
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 (102 right now)
Show Members
Advertisement