© Matti Mattila

CAATsScripts

Updated 14.10.2008; 17.10.2008; 03.01.2008; 03.02.2009; 08.06.2010
Macros for sale
Invoice. You can download a price list and an invoice here. Fill in the invoice. Together with a payment document it should be valid for book-keeping. You may need to pay value added tax according to the rates of your own country.
Payment. The invoice has information needed to make a payment. You can pay it by wire, but it might be easier to make the payment via PayPal. Make a payment to my - and Fact-Finding Service's [1] - account: "m2la@nic.fi" via Paypal (https://www.paypal.com/).
Delivery. After payment, please, send a delivery request for the macro(s) to email
"f-fs@welho.com", and you will get in return information for downloading a fully operational Excel or IDEA Macro.

An Example of a Delivery Request:
To: f-fs@welho.com
Subject:Delivery Request
Message: Hello! I have remitted 20 USD for a macro called "Cr7b" on Oct. 14, 2008 from my account [Email address in PayPal]. Please, deliver the macro and its source code to me, email: [email address].
Regards
[Your name]

Download. After receiving the message a verification of the payment takes place. You will get information needed to download the a Winzip file where one or more macros are. Downloading the file is easy. You will have 14 days for making the download. After downloading the worksheet containing the macro make a backup copy of the worksheet.
1. Excel Macros
Available Excel Macro licences:
Macro's name and Functionality Demo; Size [2] Introduction
TextImport3 - Imports an ASCII Fixed length Files to Excel
Demo macro reads max 100 lines.
xl07c3.zip
118272; 53481
xl07c3.html
StringPivotTable - Makes a Pivot Table from Strings
Demo macro makes a string pivot table max 3 rows 3 columns
xl07eD.zip
65024
xl07d.html
TexEdiMac #1 - Seven functionalities for editing text files
Demo macro processes max 20 lines.
xl07eD.zip
316416
xl07e.html
TexImp04 - Imports Lines of a Text File
Demo macro imports 50 lines or less.
xl07c4D.zip
72704
xl07c4.html
Prices of licences of the macros are shown in a document here. Full version of TexImp04 macro comes without charge when any of the following macros is bought: 'TextImport3'; 'StringPivotTable'; 'TexEdiMac #1'.
2. IDEA Macros
Available IDEA Macro licences:
Macro's name and Functionality Demo; Size [2] Introduction
CHMM - makes an uppercase/lowercase copy of a raw data file cmm.zip; 5226 i_gui47.html
CROMM: Cr7a - makes a pivot table using one numeric field cr7a2.zip; 17120 cs_3cr01
CROMM: Cr7b - makes a pivot table using two numeric fields cr7b2.zip; 21063 cromm3.html
FEMM - examines composition of character fields fmm.zip; 8956 i_gui43.html
LIMM - copies chosen lines of a text file into a new file #1 lmm.zip; 6344 i_gui48.html
LIM2 - copies chosen lines of a text file into a new file #2 lm2.zip; 6744 i_gui49.html
NAMM - Renames files #1 nmm.zip; 5906 i_gui45.html
NAM2 - Renames files #2 nm2.zip; 6785 i_gui46.html
NAM3 - Renames files #3 nm3.zip; 7575 i_gui453.html
SEMM - Searches a string or parts of it in a field #1 smm.zip; 14416 i_gui44.html
SEM2 - Searches a string or parts of it in a field #2 sm2.zip; 12051 i_gui4a.html
SEM3 - Searches several strings in a field sm3.zip; 13922 i_gui4b.html
Prices of licences of the macros are shown in a document here.
Test free!
You can test functionality of IDEA macros with demo versions (functionality limited up to 500 records). They are compiled within IDEA7 (extension ".ise"). Macros are case sensitive, and they recognize spaces as characters. Execution of text search macros can take a long time due to heavy computing. Macros cannot be run if their introductory file (e.g. "cmm.txt", "cr7a2.txt", "cr7b2.txt", "fmm.txt" etc.) is changed in any way.
Tips
Good to remember in Use of IDEA: CAATs basics
Miscellaneous Tips: Inquiries; Comparisons; Time recording system; File examination; Conversion tables; Risk based sampling; Print files; Entry analysis..
Complentary Continuos Audit System: Tips in building it
Macros:
CROMM: creates Pivot Tables
Miscellaneous [IDEA] Macros: File/Field selection; Field examination; Text search; File renaming; [Raw] data manipulation
Excel Macros: HeaderFooter; TextImport
Legal Notice: Read this, too, please.
Return to Main Site

[1] Fact-Finding Service is registred (# 1653819-8) in the Joint business information system of the National Board of Patents and Registration and the Tax Administration.
[2] Size of a compiled macro (*.ise) in the Winzip File. See the picture: "cmm.zip": "CMM.ise".
Here is a web site where to download Winzip to extract Winzip files.