Getting complete control over your files at any moment is important to relieve your day-to-day duties and enhance your productivity. Achieve any objective with DocHub features for document management and convenient PDF editing. Access, modify and save and integrate your workflows with other secure cloud storage.
DocHub provides you with lossless editing, the chance to work with any formatting, and securely eSign documents without looking for a third-party eSignature alternative. Obtain the most of the file managing solutions in one place. Check out all DocHub capabilities today with your free account.
[Music] allocating amounts across different time periods is challenge that we face especially in contracts and prepaid rentals if you look at this table I have some contracts to end contracts how to start the in period number of days the contract and the amount what we are trying to do is we are trying to allocate this into number of months based on exact number of days people use many methods to spell this there are complicated formulas but the issue here is you know how dynamic it is whenever you go and make changes to maintain it to add new contracts you need to expand your range what I have done I have used power query to solve this problem let me take you through how it has been done so this is the contracts as January and ends in October in 2020 I have transformed this table into a table of data which is most suitable for analysis I have the wind contracts the period in months and the amount allocated amounts by month if you go and filter by contract one is the start and this is