Buses
Bus Name Bus Voltage V THD V RMS V TIF
001-UTILITY CO 69,000 0.69 68,737.97 13.94
Branches
Component Name
Type From Bus To Bus
Bus Volt.
I_THD I_RMS I_T I_K LF Amps LF Angle C1 Cable 003-HV SWGR 004-TX B PRI 13,800 32.97 13.76 3,065.39 4.14 13.06 -24.58 Filters
Filter Name Bus Name Bus Voltage I_THD I_RMS I_T I_K LF Amps
LFAngle
Cap-Bus13 013-DS SWG2 4,160 139.58 807.29 261,401.50 19.20 470.17 81.24
Motors
Motor Name Type Bus Name Bus Volt. I_THD I_RMS I_T I_K LF A mps
LF Angle
M 28 # 1&2 Ind Mtr 028-MTR 28 A 480 40.61 672.60 180,069 5.55 623.18 -45.04
Non-Motor Loads
Load Name Bus Name Bus Voltage I_THD I_RMS I_T I_K LF Amps LF Angle L1 013-DS SWG2 4,160 0.00 0.00 0.00 0.00 27.24 -8.80 Sources Source Name
Type Bus Name Bus Voltage I_THD I_RMS I_T I_K LF Amps
LF Angle
G1 Gen. 008-DS SWG1 4,160 12.38 89.89 7,798.23 1.49 89.21 38.66
Harmonic Sources
Source Name Bus Connected To
Lib. Source Name Component Type
Bus Voltage Rated kVA
I_THD I_RMS I_T I_K LF Amps
LF Angle M 28 # 1&2 SKM Six Pulse 480 40.61 672.60 180,069. 5.55 623.18 -45.04
028-MTR 28 A Ind Mtr 250.00
M25 SKM Six Pulse 4,160 40.61 299.56 80,199.6 5.55 277.55 -44.95
025-MTR 25 Ind Mtr 1,956.46
Figure 6
When you create a query for this report, you simply choose the subreport that you want to query on. As shown in Figure 7, the list of subreports corresponds to the sections of the report shown in Figure 6
Figure 7
Not every report has subreports. Those reports that don't contain subreports will simply list "Main Report," as shown following:
This report contains subreports. This report doesn't contain subreports.
7.8.7. Creating your own Crystal Reports
Important: To make your own reports, you must purchase Seagate Crystal Reports. PTW only includes the Report Viewer, not the Report Designer.
Before taking on this venture, you must be aware of the complications involved in making your own reports. You must, of course, purchase the full version of Crystal Reports, since you need the Crystal Report Designer to create reports (PTW only includes the Report Viewer, not the Report Designer). In addition, you must understand SQL (a querying language) and relational database technology. We will provide instructions on making the Reports, and enough information about the Project Database structure to know what you’re looking for, but you must know SQL and database usage quite well to do so. We don’t say this to discourage you from creating your own reports (quite the contrary!), just to let you know what is needed for making your own Crystal Reports for PTW.
Tip: If you’re new to SQL, but want to learn, this provides an excellent learning opportunity, because you can learn a lot about SQL and relational databases by experimenting with Crystal Reports that extract data from a PTW Project Database. Read all the following pages, then try making one or two Reports. It will be difficult at first, but if you keep practicing with Crystal Reports and read an introductory tutorial to SQL in a book or on the Internet, you’ll become proficient surprisingly quickly.
Connecting a Crystal Report to PTW through ODBC
The following steps describe how to use Crystal Reports to open a PTW project: 1. Start PTW.
2. Open the Project which you want to open in Crystal Reports (you have to open the Project in PTW first so the Data Source Name, or DSN, will point to this
Project―this will make sense in a moment). 3. Close PTW.
4. Start the 32-bit Crystal Report Designer. 5. Click File>New. This opens the Report Gallery:
6. Click the Standard button. This opens the Standard Report Expert:
8. Select "ODBC - PTW_PRJ" and click OK. (This is the Data Source Name, or DSN, which you set back in step 2 to point to the PTW Project you want to open; whenever you work in PTW, this DSN is automatically updated to point to the project you currently have open.)
9. You will now see a list of all the tables in the PTW Project. Since there are literally hundreds of them, you should not choose all of them, but just those tables that contain the data you want to show (for example, to see Load Flow Voltage, you would choose the BusOutput table). For a list of all the tables in the PTW Project and their relations to one another, see the following section, "PTW’s Database Structure."
PTW’s Database Structure
As you can see from the previous section, it's not enough to just connect Crystal Reports to a PTW Project; you need to know where to find the field you want, too. Since it's difficult to manually search for the field you want (there are hundreds of tables, each with an average of 10 fields, resulting in thousands of fields), you need to know something about PTW's database structure and some experimentation will be required. If you can not locate the desired data field, contact SKM for additional database information.
8 Libraries
Libraries are data containers that you can use to dramatically speed up system modeling. Libraries contain frequently used component attributes that you can copy into your project components as needed. This greatly reduces your data entry, because instead of having to type in component attributes over and over, you can simply select the library model you want, and PTW copies the component attributes into the Component Editor. Not only does this make your work easier and faster, but it also minimizes data entry errors. Libraries are fully customizable: you can enter manufacturer’s data into new libraries to model your equipment according to exact specifications. This chapter introduces libraries and library concepts, and details the procedure of working with the library data in your projects.
This chapter discusses: • What is a library? • Managing libraries. • The library interface.
• Reviewing and editing library data.
IN THIS CHAPTER
8.1. What is a Library? ... 8-2 8.2. Managing Libraries... 8-4 8.3. Changing Project Library References... 8-6 8.4. Adding and Editing Library Entries... 8-8 8.5. Copying Library Entries ... 8-8 8.6. Cable Library ... 8-9 8.7. Demand Load Library... 8-13 8.8. Motor Control Center Library... 8-14 8.9. Transformer Library ... 8-16 8.10. CAPTOR Library... 8-17 8.11. TMS Library ... 8-17 8.12. I*SIM Library... 8-18 8.13. HI_WAVE Library ... 8-18 8.14. Standard Transmission Line Library ... 8-19 8.15. 3-Phase Transmission Line Library ... 8-21 8.16. Bus Library ... 8-21 8.17. Reliability Library... 8-22