I need advice on how I would pull in past data into my Model. I have a Excel file that is attached and have set up the layout of the Model in Anaplan and have put the Formulas in my Line Items. I just need to pull in this data and then create a Flat File that will be uploaded into Anaplan Daily. My question is with the Excel Model that I already have, it is possible to import this Excel file and Map the Columns to my Line Items to pull in the past data I need in the Model?
I'm not totally clear on the goal, but would it work to create a 'Securitization - Baseline' module that doesn't have any formulas that you could then upload your Excel file to? This would retain all the data elements in your Excel file and allow you to reference it.
When you set up the import from the Excel file, set Time as Column Headers and Line Items as Column 1. Then on the tabs, you can specify the date format and maps the row labels to line items appropriately.