| Applies To | |
| Product(s): | AutoPIPE |
| Version(s): | ALL; |
| Area: | |
| Date Logged & Current Version | Juky 2022 12.08.01.010 |
Problem:
Look at the "Result Summary" output report, notice that the reported sections are based one Max Ratio and Max Stress for each category of combination printed in the report.
How to find the maximum stress and maximum ratio for each combination and add them to the Results Summary report?
Solution:
Best to log all new features as an Idea here. All Ideas logged here are sent directly to the Program manager, Development team, and available for the whole community to see and vote on for inclusion into a future version of the application.
The only other suggestion is to Explore the power of the Excel Report Manager
Most user have not explored / used AutoPIPE's Excel Report Manager. This feature enables the user's to create very customize reports that can be project specific, saved, reused, shared among a group of users, etc..
In this case, consider the following steps:
Note:
a. This procedure requires user to have experience with Excel and knowledge of Pivot Table.
b. Screen shots below maybe slightly different based on the version of the program and select code + edition in the model. Research available reports in your situation and try to mimic the settings below.
1. Analyze the model using ASME B31.3, 2018
2. Think about the end goal: create a table to indicates the maximum stress value for each code combination and indicate its location.
3. Open Excel Reports (Result > Report Manager > Excel Reports)
4. Since this report will focus on the Code Compliance results, move the following fields from the Code_Compliance drop down to the center column: Point_Name, Load_Combinations, and Code Stress
5. Next left mouse click on the words in the center column 1. "Code_Compliance, notice that the icons above are no longer greyed out, press on the 2. "Pivot Table" icon
6. Again, best to have some working knowledge of Excel and Pivot tables. configure the dialog as indicated below and press Done button
7. Back on the Bentley SQLite Report Manager dialog, press the "Generate Report" (green lighting bolt icon) button, wait a brief moment and then press on the "Open Generate Report" (Excel grid icon) button.
8. In just a moment Excel should automatically launch and display new file with 2 tabs; 1. "Code compliance" and 2. "Pivot-Code_Compliance".
9. Select the 2nd tab, "Pivot-Code_Compliance".
10. This excel sheet contains: a. the raw data, b. pivot table, and c. chart. Scroll down the bottom of the raw data to see the other 2 items mentioned.
11. Right mouse click the first cell under MaxP stress - 1, select Sort - 2, and choose Sort Largest to the smallest - 3
12. Afterwards Left mouse click the combination Max P(1), from the Pivot Table Analyze ribbon in excel select Collapse Field command
In see all the node point where this value occurs, simple expand the individual combination.
Experienced Pivot Table users can continue to customize this excel sheet as necessary.
13. Lastly, back in AutoPIPE save the report and close the Report Manager dialog.
Note: As of July 2022, there is no Code compliance Ratio SQlite option. This will be added in a future version of the application. Until then, experience user can easily add a column to the pivot table that would calculate the Ratio. Just include the Code compliance to the Code allowable table into the middle column.
See Also
"Result Summary" sub-report using Results> Output Report