Search found 4 matches

by Ed Conklin
Wed, Jan 02 2008, 10:09AM
Forum: eCabinet Systems Software
Topic: 32 MM system
Replies: 2
Views: 2150

32 MM system

A while back, I posted a message asking how folks got the correct hole patterns in eCab for the 32 MM system. Someone responded saying to put a 'dummy' shelf in 1.0807" from the deck. That worked out pretty well. Someone else also responded saying the logic to fully handle the 32MM system was h...
by Ed Conklin
Mon, Dec 03 2007, 9:34PM
Forum: eCabinet Systems Software
Topic: Help please. I'd like to write formulas using Excel output.
Replies: 6
Views: 5030

Sorry about that. When I wrote the formula, I didn't think about metric. Try the following formula. It will strip off the 'mm' and then convert the string to a number.

This formula assumes the imported number (stored as a string) is in E16.

=VALUE(LEFT(E16,LEN(E16)-2))
by Ed Conklin
Mon, Dec 03 2007, 8:46PM
Forum: eCabinet Systems Software
Topic: Help please. I'd like to write formulas using Excel output.
Replies: 6
Views: 5030

Another way to convert the number inported in a string format is through a formula within Excel. The simple formula that will do this is '=value(A1)'. A1 is assumed to be the cell with the number in string format. The value of that cell is stored as a number in the cell with the formula. I find that...
by Ed Conklin
Tue, Mar 13 2007, 4:27PM
Forum: eCabinet Systems Software
Topic: Script to print samples of items in Materials Directory
Replies: 2
Views: 2581

Script to print samples of items in Materials Directory

When I try to detail a room, I often want to use some imagination related to selecting materials. eCab comes with a wide selection of materials (directory named MATERIALS with lots of subdirectories) for this process, but I have not found a convenient way to search through the selections. Has anyone...