Fiscal Month Calendar
in [Project]
|
Prev: VBA - Filters
Next: Float/Slack Time
From: SpaceCamel on 24 Aug 2005 14:52 My company uses a Fiscal Month of last Sunday in a month. Does anyone know of a way to get MSP to show alternative (user defined) calendars on the timescale? Thanks,
From: Mike Glen on 24 Aug 2005 15:37 Hi SpaceCamel , Welcome to this Microsoft Project newsgroup :) No - the only selection you can make is when the fiscal year starts. I believe this is because Project is a schedulling program and not designed for fiscal use. The best I can offer is to export the data to Excel and create a fiscal calender there. FAQs, companion products and other useful Project information can be seen at this web address: http://project.mvps.org/faqs.htm Hope this helps - please let us know how you get on :) Mike Glen MS Project MVP wrote: > My company uses a Fiscal Month of last Sunday in a month. Does > anyone know of a way to get MSP to show alternative (user defined) > calendars on the timescale? > > Thanks,
From: John on 24 Aug 2005 16:55 In article <6C9C64FF-F37F-4946-A466-0ACC4A68B987(a)microsoft.com>, "SpaceCamel" <SpaceCamel(a)discussions.microsoft.com> wrote: > My company uses a Fiscal Month of last Sunday in a month. Does anyone know > of a way to get MSP to show alternative (user defined) calendars on the > timescale? > > Thanks, SpaceCamel, As Mike indicated, Project can vary the fiscal year start but it cannot handle company financial calendars. Through the use of VBA however, that feature can be accommodated - I've done it a couple times myself. John Project MVP
From: SpaceCamel on 25 Aug 2005 14:09 John, Can you tell me how you did it in VBA. Thanks "John" wrote: > In article <6C9C64FF-F37F-4946-A466-0ACC4A68B987(a)microsoft.com>, > "SpaceCamel" <SpaceCamel(a)discussions.microsoft.com> wrote: > > > My company uses a Fiscal Month of last Sunday in a month. Does anyone know > > of a way to get MSP to show alternative (user defined) calendars on the > > timescale? > > > > Thanks, > > SpaceCamel, > As Mike indicated, Project can vary the fiscal year start but it cannot > handle company financial calendars. Through the use of VBA however, that > feature can be accommodated - I've done it a couple times myself. > > John > Project MVP >
From: John on 25 Aug 2005 15:19
In article <11DC25E8-BC28-4F13-BE1B-DFF7955CDD24(a)microsoft.com>, "SpaceCamel" <SpaceCamel(a)discussions.microsoft.com> wrote: > John, Can you tell me how you did it in VBA. > > Thanks SpaceCamel, It isn't a simple macro but it definitely does the trick. Depending on the structure of your financial month (I think you mentioned you use the last Friday as end-of-month) either a look up table or an algorithm (I've done it both ways) is needed to provide a definition for each month. For example I have an algorithm (proprietary) for the commonly used 4-4-5 financial month sequence. Depending on the data desired (i.e. task, resource, assignment), a loop is set up to break down (re-allocate) the data for each task into financial month chunks and there are a couple of ways to do that. As the data is re-allocated I store it in one or more arrays. After all the data is gathered, I open Excel and dump the data arrays onto a formatted Worksheet. A couple nice things about having the data in Excel is that it is easier to distribute electronically (recipients don't need Project to review the data) and it is easy to interface the data with other applications. That's the basic process - simple to describe - a little more interesting to code up. John Project MVP |