View Single Post
 
Old 10-03-2022, 12:46 PM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
 
Join Date: May 2017
Posts: 932
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default

Quote:
Originally Posted by grNadpa View Post
Before I attempt to educate myself on Excel defined tables and Validation lists, would you take a moment confirm that your solution should work for my project?
Yes, it will work!

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.)
Reply With Quote