Property spreadsheet

You can also obtain the properties spreadsheet by clicking the LEFT mouse button on a part to select it. Once the part is selected, click the RIGHT mouse button on the part and then select Edit Properties from the menu that appears. 

To accept the changes click the LEFT mouse button on the OK button. You will return to the properties spreadsheet ... 

The second way to edit a part s properties is to double-click the LEFT mouse button on the graphic symbol for that part. To edit the properties of R2, double-click the LEFT mouse button on the R2 resistor graphic, +AVV-. Make sure that you click on the center of the graphic. If you double-click fast enough, the properties spreadsheet will appear ... 

Double-click the LEFT mouse button on the graphic symbol for the breakout Zener diode 03,, to obtain the properties spreadsheet for the part. Two screen captures are shown to display the properties we need for this discussion. 

Note that the model Dx does not appear in the schematic. This is because, with predefined models like the D1N4001, the text D1N4001 displayed on the schematic is the Value property and not the Implementation property. Since the Implementation attribute has been changed to DX in the property spreadsheet, PSpice will use model Dx in the simulation. 

We would like to see how the rise and fall times vary with random device tolerances. We must set up the Transient Analysis to view waveforms versus time, and the Monte Carlo analysis to allow for device variations. First we will look at the input pulsed waveform. The property spreadsheet for Vi is ... 

The property calculation experiment offers a list of 34 molecular properties, including thermodynamic, electrostatic, graph theory, geometric properties, and Lipinski properties. These properties are useful for traditional QSAR activity prediction. Some are computed with MOPAC others are displayed in the browser without units. A table of computed properties can be exported to a Microsoft Excel spreadsheet. 

In using a spreadsheet for process modeling, the engineer usually finds it preferable to use constant physical properties, to express reactor performance as a constant "conversion per pass," and to use constant relative volatiHties for distillation calculations such simplifications do not affect observed trends in parametric studies and permit the user quickly to obtain useful insights into the process being modeled (74,75). 

The Excel spreadsheet is constructed so that on page one, the referenced properties are listed in Column C, and the same with conversion factors to SI units in Column D. Conversion formulas and values calculated in SI Units are in Column E. Column F is a duplicate of Column E, and this can be used for additional calculation by changing to other conditions or to an entirely new case. It is recommended toleave Column E alone for a comparison case and to copy Column F to another page to execute calculations. 

An Excel spreadsheet program (Example 7-l.xls) was developed to determine the theoretical power of any agitator type with given fluid physical properties and tank geometry. 

Simple phase equilibrium calculations, like the one illustrated here, can be readily implemented in spreadsheet software and automated. In practice, the calculations will most often be carried out in commercial physical property packages, allowing more elaborate methods for calculating the equilibrium K-values to be used. 

The there is means in practice that you must search around the object space until you come to a Spreadsheet and tiy it for that property but we said that specification functions need not execute efficiently to be meaningful. 

The solutions of a diffusion equation under the transient case (non-steady state) are often some special functions. The values of these functions, much like the exponential function or the trigonometric functions, cannot be calculated simply with a piece of paper and a pencil, not even with a calculator, but have to be calculated with a simple computer program (such as a spreadsheet program, but see later comments for practical help). Nevertheless, the values of these functions have been tabulated, and are now easily available with a spreadsheet program. The properties of these functions have been studied in great detail, again much like the exponential function and the trigonometric functions. One such function encountered often in one-dimensional diffusion problems is the error function, erf(z). The error function erf(z) is defined by... 

This window displays a spreadsheet of all of the part s properties. Note that there are more properties than appear on the schematic. Not all properties of a part are displayed on the schematic. To change the voltage of the source, click the LEFT mouse button on the text 12 in the DC column to select the cell ... 

Next, we will attempt to change the name of the source. The property that specifies the name of the source is not displayed in the window. Click the LEFT mouse button as shown below to scroll the spreadsheet to the right ... 

If you get the properties of the wrong item, close the spreadsheet by clicking on the lower El and try again. Keep trying until you see the spreadsheet below ... 

Edit the properties to change the value to 5k and then close the spreadsheet by typing CTRL-F4. 

The Implementation property shows that the model for this diode is Dbteah. Suppose we want both Zener diodes in the circuit to use the model Dln4734A. Change the Implementation property to Dln4734A and type CTRL-F4 to close the spreadsheet and return to the schematic. In the schematic, the text Dbreak will change to D1H4734A ... 

Thus, when we change the model (Implementation property), the change will not be displayed on the screen. Click the Cancel button to return to the spreadsheet. 

Change the Implementation property to Dx and then type CTRL-F4 to close the spreadsheet to return to the schematic ... 

The properties for specifying the bit sequence of this source are not displayed. Scroll the spreadsheet to the right until you see the properties LINE I to LINE 13. 

Now comes the most magical property of a spreadsheet. Highlight cell C5 and the empty cells below it from C6 to C12. Then select the FILL DOWN command from the EDIT menu. This procedure copies the formula from C5 into the cells below it and evaluates the numbers in each of the selected cells. The density of water at each temperature now appears in column C in Figure 2-19d. 

Spreadsheets for titration of river sediment with HN03 or NaOH. [Data from M. Davranche. s. Lacour. F. Borders, and J.-C. Bollinger, Determination of the Surface Chemical Properties of Natural Solids" J. Chem. Ed. 2003,80,76.]... 

Traditionally data, properties, information etc has been stored in files on computer disks. More recently, it has become common practice on Macintosh computers, when using Microsoft software or some UNIX applications, to use either extensions to the file name or the first few bytes in the file (or another file) to indicate some aspects of the data, for example that it is suitable for Microsoft Excel. While this approach is practical to indicate something about files containing columns of data, it is not appropriate to store information about the values in cells in spreadsheet or how it relates to data in other columns. This requires a relational database such as ORACLE, and for performance reasons the values in the cells may only be accessed via the ORACLE API (Application Programming Interface) or SQL (Standard Query Language), in other words, it is suggested that relational databases such as ORACLE should be viewed as sophisticated file systems which allow the values to be organised, efficiently stored, rapidly retrieved etc. 

---