	
              Read Me First.
              
              File List
              
              Attbom.ulp                : Eagle ULP to produce BOM.
              Attribute_BOM.xls         : Excel spreadsheet template to import text BOM & edit & generate bck annotate script.
              BOM_ITEMS.lbr             : Libry with BOM items part.
              LIB_ATT_VAR_VAL_ON.scr    : Script to add standard attributes to  device at time of creation in library.
              Example schematic         : Folder with an example to play with.

        
        
        
        	ATTRIBUTE_BOM.xls  Help    (also included as sheet in spreadsheet)
		
		
Introduction		Attribute bom.xls is a spread sheet template set up to import the semicolon delimited text file produced by atbom.ulp
		Atbom.ulp exports a range of predefined attributes for each part on the schematic, in a page by page sequence. The output of Attbom is  a ; delimited text file.
		Atbom.ulp also exports this information as an easily readable html file
		The ; delimited text file is most suited for importing int Excel. The html format file is better suited for import into Open office Calc.
		The pre defined attributes are used to store a rang of useful manufacturer part data, compliance data & design change note data, for each part on the schematic.
		Attribute bom.xls can be used to create an eagle script , which will back annotate data from the spreadsheet to the eagle schematic.
		The back annotation script can be applied either on a part by part basis by copying a single line, and pasting to the text input of eagle, or by pasting many lines to an eagle script file.
		Attribute bom.xls has two parts list views: by part & by value.
		
Usage	1	Open an Eagle schematic.
	2	Create the following 3 Global attributes  GCN, PCBNAME,  PROJECT,  from the Edit menu. ( These Global attributes are used as text variables in the drawing frame to set the titlse of all sheets in 1 hit)
		There must be no more or less than these 3 Global attributes on the schematic, otherwise the text file header will be the wrong size and not import to the spreadsheet corectly.
		Global attribute GCN is used to record the  Global Design Change Note number that the documentation is issued with. Parts with their DCN attribute set to the value of the Global attribute GCN are highlighted to show there has been a change.
		Global attribute PCBNAME is used to store a descriptive name for the PCB.
		Global attribute PROJECT is used to store the name of the project that the PCB is part of.
	3	Run the Eagle User Languahe Program (ULP)  Attbom.ulp. ( or HtmlAttbom)  This will create a semicolon delimitted text file in the directory that caontains the schematic. 
		The text file will be named Schematic name_BOM.txt.
	4	Open the Excell spreadsheet ATTRIBUTE_BOM.xls. Save the spreadsheet with a suitable new name into the working directory.
	5	On the Part sheet, press the Import BOM macro button. A file open dialoge will allow you to select the newly crated text BOM.
		Note: The Excel spread sheet remembers the last file imported, it is necesaary to clear the previous file name from the file select dialogue, before other text files are visable to the dialoge.
	6	The text BOM will import to the Part sheet. The three global attributes will be dispalyed on the sheet tital bar, along with the source schematic file, path & date.
		The parts will be aranged in sheet & referance order, ie all parts on sheet 1 will be listed in referance order before sheet 2 etc.
	7	Save the spread sheet.
	8	There are a number of macro buttons that apply predefined sorts & filters & text checks  to aid  data entry.
		
		Import BOM:   Opens a file select dialog to reimport the text BOM.
		Sort by Ref:   Sorts the parts list by part Referance ignoring the sheeet of oragin.
		Sort by Value:   Sorts the parts by Value ignoring the sheet of oragin.
		Sort Final:   Sorts the parts by Type - Value & Manufacturers Part No ignoring the sheet of oragin.
		Filter on:   Applys automatic filters to the headings.
		Filter off:   Removes automatic filters from the headings.
		Single value:  Colapses the Part sheet so only one line is shown for each value of part, and applies a highlight to that line.
		Reset highlight:   Removes the highlight applied by Single value.
		Text check:   Removes spaces, commas, and semicolons from critical fields. The value field must not contain any of these charecters!
		
	9	Use the user friendly edditing facilities in the spread sheet to add attributed to each part listed on the Part sheet.
		If a part is not to be fiteed put NF in the value colunn, quantities will be adjusted next time attbom is run after back annotation.
		Attributes can be back annotated to the schematic, on a line by line basis, by copying the eagle script generated in column X , and pasting it into the eagle command input box + enter.
		A back annotation script for the whole schematic can be created by selecting all the lines in column x, then pasting into a text editor. Save the text  file in the schematics working directory as mypcbname.scr.
		Run the script from the eagle schematic. All the attributes from the spreadsheet will be back annotated to the schematic.
		When running the script there may be some prompts asking to force overwrite parts with no user value, or attributes set in the library.
		
	10	Create a parts list sorted by value in this manner:
		On the Parts sheet press the sort final macro button.
		Change to the Value sheet.
		Select the show filter on column R to update the filter.
		A partslist arranged by part type / value is now displayed.
		Note items that have had there DCN attribute set to the same value as the global attribute GCN will have the DCN value highlighted to indicate a change to that part.
		Notes recorded in the Notes attribute are concatonated. 
		
		
Attribute Fields		
		
Page		Schematic page:  Not editable. Required to generate attribute script.
REF		Componant REF: Not editable. Required to generate attribute script.
LIBRARY		The Library the device is from: Not editable.
Device		The Device in the Library: Not editable
TYPE		Device TYPE: eg C,D,R,U,PL,SK. Used for search & filtering especialy if a master spreadsheet is used.
SUBTYPE		Sevise SUBTYPE: further refines TYPE, use as required eg X7R, PNP, NPN
VALUE		The componants value: No spaces or commas please!
FEED		PICK & PLACE machine feeder. Used on Attmount.ulp for manufacture data generation.
BIN		The stores BIN location of the part.
DESCRIPTION		Extended user description.
MFR		Manufacturer.
MFPN		Manufacturers part No.
VEND		Vendor.
QTY		Quantity. NOT edditable. Set value to NF on Part sheet to not fit. If the attribute QTY is added to a part this value will appear in the Part list as the quantity. Usful for adding sundrie items such as screws.
EACH		Cost of one item.
NOTES		Notes relevant to that part eg design change info.
DCN		Design change note number: Use to identify changes to the design.
RoHS		ROHS compliance of PART eg Y, N ,Y-EX
UL		UL Approvals etc
FIRE		UL Fire rating for plastic parts
CRITICAL		Critical Part: Use to identify saftym, EMC or lead time critical parts.
		
		
		
Known issues	Only use the 3 specified global attributes,otherwise the template will become corrupted.
		Do not delete lines from the parts or value sheets it will mess the formulas up.
		Take care when copying & pasting between rows. Paste special - value can be a safer bet.
		Dont use semicolons anywhere!
		Dont use spaces,commas etc in the value field.
		Macros are not fully comatible with open office, best to re write your own if you wish to use oo. ( Particularly import BOM does not work)
		
		
		
		
		
		
		
		
Attbom.ulp and supporting files created by J.Meech 2010.
You may use these files as you wish, with the understanding that there  absolutely no garantee of correct function.
Use at your own risk.
The Example circuit is only intended as an example of how to use Attbom.ulp not as a correct example of using the LT1910.
