All Forums  Origin Forum  Origin Forum  Defining commonly used parameters

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize: 640 x 480 800 x 600 1024 x 768 1280 x 1024 UserName: Password: Anti-Spam Code: Format Mode: Basic  Help  Prompt  Format: Font Andale Mono Arial Arial Black Book Antiqua Century Gothic Comic Sans MS Courier New Georgia Impact Lucida Console Script MT Bold Stencil Tahoma Times New Roman Trebuchet MS Verdana   Size 1 2 3 4 5 6   Color Black Red Yellow Pink Green Orange Purple Blue Beige Brown Teal Navy Maroon LimeGreen Message: * HTML is OFF * Forum Code is ON Smilies [quote][i]Originally posted by dhabersat[/i] [br]Origin Version: 7.5 SR6 Operating System: Windows XP I would like to use Origin worksheets to analyze measurement data. In some cases, I need to access fundamental physical constants such as electron charge, the boltzmann constant, etc. Other times, I need test-device specific parameters, such as geometry or doping. Then, there are measurement params, such as sweep steps, ambient temperature, etc. The important point is I'd like to be able to store these values ONCE and then link to them as needed, such as in worksheet formulas, text boxes, and graph labels. To do these calculations in Excel is very simple; just put the information onto the spreadsheet (a row/col might contain a label and value pair). I can then define a "name" to refer to in calculations, so if I defined the gate area as "AG" and wanted to calculate current density from measured current "IG", I'd just create a column of cells with the forumula "=IG/AG". In Origin, the best I have come up with so far is to create a formula like "=col(IG)/2E-5", but then if the parameter changes then I have to re-enter the value by hand for each instance. I understand that it may be possible to do something like this using the Info Variables when an ASCII data file is imported. This often will not work for me, though, because it seems difficult to view/edit info variables and I cannot figure out how to do this when importing an Excel spreadsheet, only ASCII data. A lot of my data is stored, with these parameter variables, on Excel spreadsheets and it would be ideal to be able to grab these from the spreadsheet while importing the columnar data. It would be nice if it were possible to have a worksheet with, say, two+ columns; at least "Name" and "Value" plus perhaps others like "Uncertainty", "Units", etc., and then refer to those values by name on other worksheets. We have a lot of specialized measurement and analysis that currently works out of Excel. The limited graphing capabilities and poor quality led me to Origin, but I would like to use Origin as more than just a Copy-and-Paste graph generator. Thanks, [/quote]   Check here to include your profile signature. Check here to subscribe to this topic.