![]() |
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
![]() Quote:
Designed properly, such design allows: Register project's detailed phases and their budgets/costs monthly (I advice to use month number in format yyyymm); Register project's start and end at any month; Register projects of any length (from single month to several years); In case this is needed, registering both planned budget and real costs spent; Design monthly and yearly reports for single project, and as total of all projects in report period; Design reports for totals of selected project (from start to end); etc. Based on your post, I assume the main data entry table will be, where planned (and realized) phases of project are registered (E.g. Month, Project, Phase, [Type], Amount, ...). (Type is optional - in case you want enter both planned and realized phases.) |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
EdStockton | Excel | 1 | 08-06-2014 11:00 PM |
Combine or merge multiple worksheets into one worksheet | timomaha | Excel | 1 | 07-21-2014 01:02 PM |
![]() |
mars1886 | Excel Programming | 3 | 02-09-2014 12:50 AM |
![]() |
nolesca | Excel | 4 | 06-07-2010 08:13 AM |
![]() |
Equilar | Excel | 3 | 05-03-2010 01:40 AM |