Hi,
I have recently had an enquiry about putting a large 30MB excel model into TM1 - the model based on inputs calculates P&L BS and CF for 5 years in a detailed level. Has anyone any experiance of using TM1 for this?
TM1 to use for excel model
-
Paul Segal
- Community Contributor
- Posts: 312
- Joined: Mon May 12, 2008 8:11 am
- OLAP Product: TM1
- Version: TM1 11 and up
- Excel Version: Too many to count
Re: TM1 to use for excel model
From what you say, this would be meat and drink for TM1. Most (although by no means all) TM1 apps are financial in one way or another, and most people on this forum will have experience of it. 30MB does not sound so large in this context. Whether it is worth buying TM1 to develop this app is another matter, depending on all sorts of factors that you don't mention.AWILDE wrote:Hi,
I have recently had an enquiry about putting a large 30MB excel model into TM1 - the model based on inputs calculates P&L BS and CF for 5 years in a detailed level. Has anyone any experiance of using TM1 for this?
Regards
Paul
Paul
-
stephen waters
- MVP
- Posts: 324
- Joined: Mon Jun 30, 2008 12:59 pm
- OLAP Product: TM1
- Version: 10_2_2
- Excel Version: Excel 2010
Re: TM1 to use for excel model
AS Paul said, this is a very standard type of application for TM1. We did something very similar a couple of years ago for a ticket selling company with a very complex business model; several selling channels (telephone\interent\direct), multiple ticket types with varying settlement periods, different payment types with their own costs, etc . The Excel model we were replacing was monthly; the end result in TM1 was a daily cash flow, P&L and BS going forward for 5 years at a much more detailed product level. TM1 handled this very well.