Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Calendarize?

Hi. I am attempting to calendarize quantities across 12 months using some
type of automated function (as the start dates and quantities will change per
project and I don't want this to be a manual function). I've gotten as far as
"telling" the application that if a project duration begins in a particular
month, to put quantities in the start month...but the kicker (problem) is
that I don't know how to make the application spread the quantities over the
other months (duration) of the project...for instance, a project begins in
April and ends in June. I need to see 200 pages per month (project totals 600
pages with equal amounts of pages being completed over the 3-month period);
the program reads that I need 200 pages in April, but I don't know how to get
the rest of the pages for May and June to read--and then end at June...can
anyone help?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 05:42 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"