![]() ![]() The aim here is to provide a simple example - not create a beast that can be tailored for any situation, spikes, normalisations, etc. The aim is to get the concept across - you can then modify the maths as you see fit thereafter.Īs usual, I provide an Excel example - and make use of Excel 365 this time as I use dynamic arrays to “spill” my formulas. ![]() Here, I assume I am considering a forecast of total costs (cell I12, given the range name Total_Costs), with costs of 20% (cell I16, Initial_Percentage_Completed) already accounted for. This “Date Used” cell is named Start_Date and is defined as The start date of this forecast is given by I22, although it is cell J22 that is used for the formulas. ![]() Similarly, the total number of periods is input in cell I31 ( No_of_Periods), which generates the final date in cell J31, given by the formula Where the EOMONTH function returns the end of the month cited in cell I22 zero periods in the future, ie, the end of the month input. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |