TM1 Forum

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?

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?

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.

Regards

Paul

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.