Tech Tips

Converting DOS Statements

Here is a list of steps to through to "clean up" a converted specification. The DOS conversion was written before the Adagio Financial Reporter had "SmartSheet" technology, and it also sometimes found it difficult to keep track of the "A" and "T" accumulators. However, cleaning up financial statement can be done quickly by following this checklist:

Import the specification. Use File | Import spec... and select "File of Type" DOS specification.

Highlight the whole sheet and unhide all the rows and columns. Use Format | Rows | Unhide and Format | Columns | Unhide.

Delete Column B (which is usually empty) and all columns between the account description and the first column of numbers.

Delete the all but the last rightmost columns that contain rounding information. Clear the contents of the last column and format it Hide when printed.

Select Formula | Named Ranges and delete all the named ranges in the sheet.

Edit all the total cells to replace what is normally an unduly complicated formula with a simple =SUM() or cell+cell+cell.

If there are "Generated rows", then open the source specification and create a line with .Range in column A and the account ranges from the source specification in column B. Copy the formulas to reference the account range. Delete the "Generated Rows".

Insert ".SmartSheet" in cell A1.

Save the specification.

Print out the specification from both systems and proof the numbers. If there are differences, then it is most likely due to an internal restriction of 255 characters in a cell string in the Financial Reporter. Some specifications may have a list of accounts longer than this. You can usually reduce the list length by carefully inspecting the accounts being referenced.