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.'

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.