Category Code Master Error

Problem

when transferring a bid from BidMagic estimating software to MacNail construction estimating software, it says 'category code master is missing important columns.'

NOTE-- This answer applies to our retired MacNail construction software, which we retired in 2001. It has been replaced by Goldenseal estimating software and accounting software .

Diagnosis

Do they have XL 2.2? Did they purchase BM before 1/5/94 (can check date on the Transfer Manager? If so, it's a known bug.

Solution

Cell D81 in the Transfer Manager 3.4 will be: {=SET.NAME("cat.array",DEREF(TEXTREF("r1c2:r1c"&GET.DOCUMENT(12))))}
should be changed to:
{=SET.NAME("cat.array",DEREF(TEXTREF("'"&file.cat.master&"'!r1c2:r1c"&GET.DOCUMENT(12))))}

Comments

You don't type in the brackets! Instead, hold down the command (clover-leaf) key when the formula is entered, and Excel will put them in. They mark it as an array formula.
Can also send them a bugfix disk, but the one change above shouldn't be too awful to talk through, and it will fix it.

Entered 1/4/94 by Dennis. Updated 11/11/2010.