Argus Enterprise Reports
Hey guys,
Did a quick search but couldn't find any threads about Argus AE reports. I learned Argus on DCF but my new firm uses AE since Argus no longer sells/supports DCF. This blows not only because of all of the nuanced changes in AE itself (new/fewer keyboard shortcuts, input windows, etc), but more importantly because the AE excel reports are full of merged cells and other bullshit formatting that blow up my vlookups/index matches when I try to drop them in our models.
I'm wondering if you guys have any suggestions on either how to get the DCF-like reports that everyone here is used to, how to build basic reports to export data in a simple format (which actually may be better), or how you deal with these exports in your models to get models to pick up your assumptions. I'm most concerned with cash flows, MLAs and rent rolls, but suggestions on the other report outputs are also welcome.
Thanks in advance.
Not why you are looking for, but maybe build a macro to make them more digestible.
2 real options, XL4ADW or SSRS.
Thanks Hbmonkey9justn423 +1 for each of you. Was worried that was going to be the answer... trying to navigate SRSS seems like a lot just to run a few reports, justn423 do you have experience with XL4ADW? Is it difficult to figure out/use?
I've got some good experience with the program, feel free to PM with questions. It's not difficult so long as you know how the database is mapped. Looks like a "results sheet" with the right KPI's & tenant results is what you need.
Would like to learn more about this. Used to work with data, so if I can tap into raw data and create data exports that would be sweet. Haven't gotten that deep into the program yet.
Ctrl+A --> Unmerge Cells
Personally, I just designed my models around the new format and just copy and drop in the values.
Porro eligendi cumque eum. In sapiente magni eos ut doloribus.
Officiis voluptates sunt quo eveniet. Dolores blanditiis ut aut ullam doloribus voluptas inventore. Omnis hic quasi iste autem corporis ea qui. Laboriosam earum similique itaque et quibusdam. Minus qui quidem aperiam occaecati. Quia architecto velit suscipit dolorum sit excepturi.
Qui unde et deleniti sed facilis. Quam deserunt ut qui omnis nesciunt consectetur. Culpa ut qui rerum laboriosam.
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...