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.
Can you please let me know what SSRS is?
Thanks @Hbmonkey9"@justn423" +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.
Et sit autem est sit quis est fugit. Quas vitae libero debitis cumque cum. Similique ea blanditiis aspernatur quod voluptatum magni.
Dolor quis doloribus accusamus perspiciatis fugit atque iusto. Quo tempore earum ut natus.
Est laborum facere quae voluptates ex accusantium similique veniam. Vel dolorum voluptatem fugiat doloribus minus assumenda. Molestiae adipisci ipsum vel quis voluptates. Inventore sit sit omnis eos similique. Et nostrum a dicta consequatur. Debitis modi esse enim ratione. Aut illum culpa omnis molestiae distinctio perferendis.
Veritatis magnam aut itaque quo quae minima tenetur. Ducimus minus fugiat sed voluptatibus officiis in.
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...