The Rolling Pin is a flexible general purpose macro which uses a wide range of spreadsheet formats. Before you import data, some general rolling pin formatting must occur. Once you identify the data in the file, then you can import that data into the dataset.

Use the Rolling Pin spreadsheet format to import data using the Spreadsheet Import (Dataset) option. You can import before the macro has been run by using the import_rolling_pin file format or after the macro using the ONESOURCE Tax Provision format.

The Rolling Pin macro is a flexible general purpose macro which:

•Handles a wide range of spreadsheet formats.

•Generates import_categories spreadsheets.

•Generates import_numbers spreadsheets.

•Is easily configurable.

Rolling Pin Input:

Spreadsheet based provision processes often represent the current provision as follows:

 

Rolling Pin Challenge:

The challenge is assigning the Rolling Pin rows and columns for the source spreadsheet.

 

From the entry example:

•Some rows contain perms while others contain temps, tax rates, and so forth.

•Some columns contain unit information while others contain totals, and comments,

•At the intersection of a row with perms and a column with unit information is a useful value.

 

Rolling Pin Output:

•Most information can be imported by categories and numbers spreadsheets.

•These spreadsheets must be arranged in specific ways.

•You need separate sheets for perms, temps, and so forth.

•The columns in each sheet have specific meanings.

•The Rolling Pin must produce spreadsheets that can be imported directly into the system.

 

Rolling Pin Annotations and Markers:

The Rolling Pin looks for special values in the spreadsheet for values to track what is in the rows/columns.

Consider the (simplified) example:

 

The special values, or annotations, go in marker rows and columns.

•Specify marker row with #mark in 1st column.

•Specify marker column with #mark in 1st row.

•The #unit annotations, indicate that there is unit information in columns 2, 3 and 4.

•The #perm annotations indicate that rows 3 and 4 contain Permanent Differences values.

•The Rolling Pin can process the sheet and use the annotations to produce an import_numbers #UP# spreadsheet.

•The macro iterates through each row and column building the list of permanent difference amounts in the format required by the standard import_numbers #UP# sheet format.

 

Rolling Pin Category Codes:

•Unit code is read from the row annotated by #ucode.

•Permanent code is read from the column annotated by #code.

•The full set of annotations and markers that produce the import_categories #UPD# include:

 

 

Rolling Pin Extra Features:

•Flip the sign (+/-) of a row of values.

•Add “–f” to the end of a marker that extracts numeric values in the opposite sign (converting 100 to -100 and vice versa).

•#ptbi-f.

•#temp-do-f.

•Flip the sign of a whole unit.

•Use #unit-f instead of #unit.