There are many ways you could do this, but I think the best would be to use Excel's VLOOKUP function to compare the model number in Stardraw's External Datasource spreadsheet with that in the Extron spreadsheet, and get the value you want from the appropriate column.

In Stardraw, use Tools | External Datasource to build your spreadsheet, choosing Extron and then selecting Cost Price and Sale Price as the Attributes you want.  You'll get something like this:

In Excel, use VLOOKUP to get values for Cost Price and Sale Price.  As an example, and assuming your Extron price list is saved as "C:\Data\Extron.xls", cell C2 would contain this formula:

=VLOOKUP(A2,'C:\Data\[Extron.xls]Sheet1'!$A:$D,3,FALSE)

This formula gets the value of cell A2 ("70-097-11") and locates the row that contains that value in the lookup array (columns A-D in the Extron spreadsheet), and it returns the value found in column 3 of that row (which is the Cost.  To return Sale use column 4).  The FALSE statement is there to avoid returning an error if the Extron spreadsheet is not sorted.

The advantage of using this method is that it handles changes to the Extron spreadsheet, and it's easy to change the link to another spreadsheet.

I hope this is helpful.

Kind regards,
Rob Robinson
Stardraw.com

Thanks for your response.We have a standard format of price list from the distributors of products like Extron ,Crestron etc..(Please find the attached Excel for your easy reference). When there is an update in the price, they will make that changes in the same format. Can we  copy this format to the corresponding sheet in Stardraw AV 2007 System attributes Excel sheet,instead of changing contents in each columns. If we can connect this format to the stardraw, it will be easy for us to update the price database.

 [email][/email]

Thanks for your post, but you don't describe what your problem is, so it's difficult to give a useful answer.

Yes, you can change the format of any Numeric attribute, but without knowing what you want to do I can't suggest whether to do this in the symbol, the document, the External Datasource, or the Report.  Text (String) attributes are not formatted.

The External Datasource is central to what I think you might want to do.  As long as your database can provide data that can be used by Excel, and, again without knowing what database it is, I'm sure it does, then you can exchange data with Stardraw AV.

If you can describe exactly what you're trying to do, and the problem you're experiencing, I'm sure we can give a more specific answer.

Kind regards,
Rob Robinson
Stardraw.com

I am facing difficulty in getting  complete product description and model number from Stardraw AV 2007 System Atributes format..Is it possible to change the format of Stardraw AV 2007 System Atributes?Can we export our database format  into this for our projects?

Thanks