Export/Import Add-in (for financial models)

Shades all inter-sheet links with RED (Links-out) or BLUE (Links-in) in the whole workbook.

by Anurag Kushwaha
Financial modeller & VBA Expert

1 review623 views|Start the discussion!|

Original Tool: Export/Import Add-in (FREE version) by Anurag Kushwaha

add-inexcelexport importfast modellingfinancial modellingmacrovba

Description
The FAST modelling Export-Import Add-in is one of a kind add-in for identifying and tracking cross sheet calculations (popularly known as Exports / Imports or Links-out / Links-in). If you are a financial modeller builder/reviewer, this add-in is an absolute must.

This add-in automatically shades all exports and imports throughout the whole workbook with a click of a button. Contains variety of options like
-Sheet selection
-Highlight options
-Highlight styles
-Erasable shading
-Choice of Shading colors

New ribbon options added in the latest version.

Download trial version here: https://www.eloquens.com/method/7Lbh8N/excel-addin-export-import-mark-for-financial-models-free-version

This business tool includes
.xlam Excel add-in (Compatible with Windows Excel 2010, 2013 and 2016 versions)

Acquire business license for $10.00

Add to cart

Add to bookmarks

Discuss

Further information

Objectives

-------------------------
Background
-------------------------
Your business relies on information in spreadsheets and financial models to make key business decisions. But Errors happen easily; more so if a business is not using standards and procedural controls.

In financial modelling terminology - A line item that is used on / referenced by another worksheet in the model is called an Export. The dependents of an Export is an Import. F.A.S.T, a fastest growing best practice modelling standards, says to "Mark exports with red font and imports with blue font".

Why marking export is crucial?

a. they tend to be significant line items on the sheet and the immediate visual identification of that is useful; and
b. deletion of these line items is going to cause repercussions elsewhere in the model that will have to be managed.
c. Further, this helps when you need to understand a model structure and gets you the answer for questions like which cells flow to output sheet, which are inputs, which are local calculations, etc.

What you lose if you don't have export/import markings?

- You loose ability to identify important lines within a sheet
- Ability to know whether the calculation block is redundant or not.
- No idea if a calculation is present in the same sheet or other sheet.
- No Information about incorrect or missing line-linkages across sheets.
- Ability to spot blank cell references across sheets, which are difficult to find, and pose a significant risk to the model.

This add-in is like an X-Ray Report of the financial model, highlighting important lines and revealing the modelling structure.

Well, if you want to find out what this add-in can do download the trial version from the link above.

Or buy it from eloquens ... to get access to additional but crucial options, including any free future updates.

---------------------------------------
Installation instructions:
---------------------------------------

- 1) Open Excel and Go to File->Excel Options->Add-ins.
- 2) In Manage drop-down select Excel Add-ins and press Go.
- 3) Now go to Browse and navigate to the Add-in file. Press Open and then Ok.

This should bring up the FL Add-in Tab in the Ribbon.

Reviews

J M Niaj(last updated: 23/09/2017 08:53)
Its a boon for Financial Models
Its been years since I am into this sector. I never came across with such amazing tool. If you are a FAST modeller you know the importance of export / import. Even also, now a days, modelling is just a job of single person. You model being presented, audited ... so its very important it understandable and error free. This tool stands on all these parameters. You don't have to worry about import / export anymore. you can reduce your time while formatting and focus on your key area, rest this Add-in is taking care of. I will really looking forward to meet this guy and explore more such tool. Just a additional requirement. Can we also select start range from where it should start marking export / import ? As currently, it is marking timeline section as well.. i.e., rows in the freeze pane.. which I want to avoid. Please advice.