Material Takeoff Gets Stuck

Problem

1. 'Gets stuck' when making Material Takeoff. When halt it, there are a zillion extra materials in for each item.
2. Prices & units are wrong in material takeoff created from MacNail material takeoff software.

Diagnosis

1. The problem--when you choose 'Get Takeoff Materials' in Customizing, some old code that should have been removed puts new headings into the Takeoff Master, so the top heading doesn't match the criteria. The result when making a takeoff is that everything is found for every item!
2. Another bug--in all undated Cust Managers, when the Cust cmd *Takeoff Materials has been used to update the Takeoff Master.

Solution

1. SHORT TERM: Trash the Takeoff Master in Customizing--Master Files folder. It will then use the one in Sched which is fine. LONG TERM: send them latest Customizing Manager, and redo Takeoff Master.
2. SHORT TERM: Trash the Takeoff Master in Customizing--Master Files folder. It will then use the one in Sched which is fine . LONG TERM: send latest Customizing Manager. Or fix code as follows: cell D81 in the Customizing Manager is =SELECT( "r2c1:r"&source.bottom&"c3"). The final 3 should be a 5.

f they are desperate to fix it right away, and have customized things so they need to use stuff from Customizing rather than the old takeoff stuff:
1. rename the Takeoff Master headings so they match those in the Criteria at the bottom
2. Select first 3 rows in Takeoff Master, sort on 2nd column, select all 5 rows, sort on first column.

Comments

Entered 1/29/93 by Dennis. Updated 11/23/2010.