View Single Post
 
Old 10-03-2022, 12:46 PM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
 
Join Date: May 2017
Posts: 874
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
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