Time series modeling
Do you guys know of a simple way to model events happening at a given moment in time - eg a specific month - without a complicated if/then formula? Let’s take real estate model for an example. Let’s say we have some revenue or cost event happening in Month 6. But we want month 6 to be an assumption and it could be changed to Month8 or Month10 in the assumptions box. Now I know I can put in a formula or an array that says “if current_month is >M6 then … “ but those make the model illegible for anyone but the author. Is there a simpler and more elegant solution?
I’m not sure exactly what you’re trying to do but some form of modulus is likely to help you make assumptions in a series - MOD() in excel.
Flags are your friend. Have a flag that toggles every x months (can use mod() per the above comment) and then link your actual calc to the flag. Makes it 1000x more legibile and easy to understand.
Generally I've found having helper calculations, such as time series flags or intermediate outputs, is a lot better than trying to jam a multi-step formula into one cell.
Just do a true false - =((current_month)=(input)) * output
Thanks. Can you explain this a bit further? Like if I have my time series Month1-M12
I have a line item that I want triggered but I'd like to toggle when it begins. eg. M 3 or M4, TBD by user.
I can have an assumption tab that has states when the line item begins. But then I get confused. I believe I can do something where there's a row for the month number and then compare than with a >= to the assumptions month, and if so, then put in LineItem. But this syntax is long and confusing. There should be a simpler way.
I don't think I really follow your meaning by
And I also don't understand what randwithabando meant by =mod()
Mod(x,y) returns: the remainder of x/y if x>y, 0 if x=y, x if x<y. useful="" tool="" for="" series="" and="" sequences="" computations.=""></y.>
Et voluptatem quo dolore. Voluptatem nihil architecto corrupti ex. Explicabo eveniet saepe veritatis illo autem harum. Omnis sequi voluptatibus eos est hic et.
Ad maxime atque amet aut natus repellendus rem vitae. Iure enim harum ab. Eum ut laudantium quia odit est. Quo eum veritatis quia et qui sapiente fuga.
Et optio et et fugiat labore. Quisquam rem rem sed ut distinctio voluptatem voluptatibus qui. Qui itaque sint saepe. Voluptatibus sequi sapiente illum. Est illum cumque sit non autem. Repellat quaerat omnis dolores dolores quam autem. Quibusdam nihil inventore ad atque voluptatem placeat velit.
Placeat consequatur sint nam beatae dolor corrupti. Temporibus non nihil maxime magnam reiciendis omnis at. Maiores rerum eligendi cumque tempora consectetur nemo.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...