BOARD INDEX

Started by Emax, May 24 2010 12:33 PM

You cannot reply to this topic

No replies to this topic

#1 Emax

Established User

Industry II
2,904 Posts:

Posted 24 May 2010 - 12:33 PM

Since any peek at the online users "last click" status reveals that "Board Index" is BY FAR the most visited location, I thought I'd better post something with that title. :rolleyes:

Just for grins, here is a handy Excel sheet set up to be a self-calculating bill of materials. Play with it and see if you like it.
Normally, I hide columns I and J so that it prints nicely on an 8.5 x 11 sheet. One of those columns is needed only once and the other is a calculated value of interest to no one. Once all entries are made, I lock the sheet.
<Matbill.0.unprotect> is an unlocked blank sheet (careful - you can overwrite the formulas). Matbill.0 is a locked blank. Matbill.1 and Matbill.2 are worksheets I have used for previous projects.

[attachment=18778:Matbill.0.unprotect.xls] [attachment=18779:Matbill.0.xls] [attachment=18780:Matbill.1.Sisyan A-100.xls] [attachment=18781:Matbill.2.BHR DR2.xls]

This post has been edited by Emax: 24 May 2010 - 12:42 PM

There are three roads to ruin; women, gambling and technicians. The most pleasant is with women, the quickest is with gambling, but the surest is with technicians. Georges Pompidou

Back to top

Back to Off Topic Discussions

1 User(s) are reading this topic

0 members, 1 guests, 0 anonymous users