İmport Text File With Excel Vba

tevfikuzunn

New Member
Joined
Nov 1, 2017
Messages
2
Hi, I am Tevfik .

I have an NX Nastran Fem Analysis Solution File with format .f06. I have to import it to excel with macro but I couldn't do . The values must import in different columns . Text file added. I need Von Mises column values which is at read colour.

Thanks.
Code:
1 
 
 
 
                                                             
                 Copyright 2013 Siemens Product Lifecycle    
                        Management Software Inc.             
                         All Rights Reserved.                
                                                             
               This software and related documentation are   
                 proprietary to Siemens Product Lifecycle    
                        Management Software Inc.             
                                                             
              Siemens and the Siemens logo are registered    
             trademarks of Siemens AG. NX is a trademark or  
                registered trademark of Siemens Product      
               Lifecycle Management Software Inc. or its     
             subsidiaries in the United States and in other  
             countries.  NASTRAN is a registered trademark   
                 of the National Aeronautics and Space       
                 Administration.  All other trademarks,      
              registered trademarks or service marks belong  
                      to their respective holders.           
                                                             
           LIMITATIONS TO U.S. GOVERNMENT RIGHTS. UNPUBLISHED
           - RIGHTS RESERVED UNDER THE COPYRIGHT LAWS OF THE 
            UNITED STATES. This computer software and related
               computer software documentation have been     
            developed exclusively at private expense and are 
           provided subject to the following rights:  If this
               computer software and computer  software      
            documentation qualify as "commercial items" (as  
             that term is defined in FAR 2.101), their use,  
            duplication or disclosure by the U.S. Government 
           is subject to the protections and restrictions as 
            set forth in the Siemens commercial license for  
            software and/or documentation, as prescribed in  
           FAR 12.212 and FAR 27.405(b)(2)(i) (for civilian  
             agencies) and in DFARS 227.7202-1(a) and DFARS  
           227.7202-3(a) (for the Department of Defense), or 
           any successor or similar regulation, as applicable
           or as amended from time to time.  If this computer
           software and computer documentation do not qualify
            as "commercial items", then they are "restricted 
           computer software" and are provided with "restric-
            tive rights", and their use, duplication or dis- 
            closure by the U.S. Government is subject to the 
            protections and restrictions as set forth in FAR 
           27.404(b) and FAR 52-227-14 (for civilian agencies
           ), and DFARS 227.7203-5(c) and DFARS 252.227-7014 
           (for the Department of Defense), or any successor 
           or similar regulation, as applicable or as amended
              from time to time.  Siemens PLM Software Inc.  
            5800 Granite Parkway, Suite 600, Plano, TX 75024 


                * * * * * * * * * * * * * * * * * * * *
                * * * * * * * * * * * * * * * * * * * *
                * *                                 * *
                * *                                 * *
                * *                                 * *
                * *                                 * *
                * *       N X   N a s t r a n       * *
                * *                                 * *
                * *         VERSION -   9.1         * *
                * *                                 * *
                * *          MAY  1, 2014           * *
                * *                                 * *
                * *                                 * *
                * *Intel64 Family 6 Model 63 Steppi * *
                * *                                 * *
                * * Intel(R) Xeon(R) CPU E5-1650 v3 * *
                * *                                 * *
                * *    Windows 7 Service Pack 1     * *
                * *                                 * *
                * *       Compiled for X86-64       * *
                * *                                 * *
                * * * * * * * * * * * * * * * * * * * *
                * * * * * * * * * * * * * * * * * * * *
1 
  
                        Welcome to NX Nastran
                        -------------------------
  
  
 This "news" information can be turned off by setting "news=no" in the runtime
 configuration (RC) file.  The "news" keyword can be set in the system RC file
 for global, or multi-user control, and in a local file for local control.
 Individual jobs can be controlled by setting news to yes or no on the command
 line.
1                                                                           OCTOBER  25, 2017  NX NASTRAN  5/ 1/14   PAGE     1
                                                                                                                                    
0        N A S T R A N    F I L E    A N D    S Y S T E M    P A R A M E T E R    E C H O                                           
0                                                                                                                                   
                                                                                                                                    
                                                                                                                                    
     NASTRAN BUFFSIZE=8193 $(C:/PLM/NX9/NXNASTRAN/CONF/NAST9.RCF[2])                 
     NASTRAN DIAGA=128 DIAGB=0 $(C:/PLM/NX9/NXNASTRAN/CONF/NAST9.RCF[6])             
     NASTRAN SYSTEM(442)=1 $(COMMAND LINE[5])                                        
     NASTRAN PARALLEL=12 $(COMMAND LINE[6])                                          
     NASTRAN REAL=2147483647 $(PROGRAM DEFAULT)                                      
     $*$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$             
     $*                                                                              
     $*                    NX V9.0.3.4 TRANSLATOR                                    
     $*                    FOR NX NASTRAN VERSION 7.1                                
     $*                                                                              
     $*             FEM FILE: D:\USERS\26025821\DESKTOP\MIL_ANALIZ\E400-1000\REV_1\E4
     $*             SIM FILE: D:\USERS\26025821\DESKTOP\MIL_ANALIZ\E400-1000\REV_1\E4
     $*        ANALYSIS TYPE: STRUCTURAL                                             
     $*        SOLUTION NAME: SOLUTION 1                                             
     $*        SOLUTION TYPE: SOL 101 LINEAR STATICS - GLOBAL CONSTRAINTS            
     $*                                                                              
     $*    SOLVER INPUT FILE: E400-1000_FEM1_SIM1-SOLUTION_1.DAT                     
     $*        CREATION DATE: 25-OCT-2017                                            
     $*        CREATION TIME: 18:18:49                                               
     $*             HOSTNAME: A00122183                                              
     $*      NASTRAN LICENSE: DESKTOP BUNDLE                                         
     $*                                                                              
     $*                UNITS: MM (MILLI-NEWTON)                                      
     $*                      ... LENGTH : MM                                         
     $*                      ... TIME   : SEC                                        
     $*                      ... MASS   : KILOGRAM (KG)                              
     $*                      ... TEMPERATURE : DEG CELSIUS                           
     $*                      ... FORCE  : MILLI-NEWTON                               
     $*                      ... THERMAL ENERGY : MN-MM (MICRO-JOULE)                
     $*                                                                              
     $* IMPORTANT NOTE:                                                              
     $*     THIS BANNER WAS GENERATED BY NX AND ALTERING THIS INFORMATION            
     $*     MAY COMPROMISE THE NX POST PROCESSING OF RESULTS.                        
     $*                                                                              
     $*$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$             
     $*                                                                              
     $*$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$                                           
     $*                                                                              
     $* FILE MANAGEMENT                                                              
     $*                                                                              
     $*$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$                                           
     $*                                                                              
     $*                                                                              
     $*$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$                                           
     $*                                                                              
     $* EXECUTIVE CONTROL                                                            
     $*                                                                              
     $*$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$                                           
     $*                                                                              
1                                                                           OCTOBER  25, 2017  NX NASTRAN  5/ 1/14   PAGE     2
                                                                                                                                    
0        N A S T R A N    E X E C U T I V E    C O N T R O L    E C H O                                                             
0                                                                                                                                   
                                                                                                                                    
                                                                                                                                    
     ID,NASTRAN,E400-1000_FEM1_SIM1-SOLUTION_1                                               
     SOL 101                                                                                 
     CEND                                                                                    
1                                                                           OCTOBER  25, 2017  NX NASTRAN  5/ 1/14   PAGE     3
                                                                                                                                    
0                                                                                                                                   
0                                        C A S E    C O N T R O L    E C H O                                                        
                 COMMAND                                                                                                            
                 COUNT                                                                                                              
                  1      $*                                                                                      
                  2      $*$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$                                                   
                  3      $*                                                                                      
                  4      $* CASE CONTROL                                                                         
                  5      $*                                                                                      
                  6      $*$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$                                                   
                  7      $*                                                                                      
                  8      ECHO = NONE                                                                             
                  9      SPC = 1                                                                                 
                 10      OUTPUT                                                                                  
                 11      DISPLACEMENT(PLOT,REAL) = ALL                                                           
                 12      ESE(PRINT,AVERAGE) = ALL                                                                
                 13      EKE(PRINT,AVERAGE) = ALL                                                                
                 14      SPCFORCES(PLOT,REAL) = ALL                                                              
                 15      STRAIN(PRINT,REAL,VONMISES,FIBER,CENTER) = ALL                                          
                 16      STRESS(PRINT,REAL,VONMISES,CENTER) = ALL                                                
                 17      $*  NX STEP: SUBCASE - STATIC LOADS 1                                                   
                 18      SUBCASE 1                                                                               
                 19      LABEL = SUBCASE - STATIC LOADS 1                                                        
                 20      LOAD = 2                                                                                
                 21      $*                                                                                      
                 22      $*$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$                                                   
                 23      $*                                                                                      
                 24      $* BULK DATA                                                                            
                 25      $*                                                                                      
                 26      $*$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$                                                   
                 27      $*                                                                                      
                 28      BEGIN BULK                                                                              
0                             INPUT BULK DATA ENTRY COUNT =      670162
0                       TOTAL COUNT=    670130




                                        M O D E L   S U M M A R Y


                                   NUMBER OF GRID     POINTS   =   245192
 
 
                                   NUMBER OF CHEXA    ELEMENTS =    57377
 
                                   NUMBER OF RBE3     ELEMENTS =        1
 *** USER INFORMATION MESSAGE 4109 (OUTPX2)
     THE LABEL IS NX9.1    FOR FORTRAN UNIT 12
     (MAXIMUM SIZE OF FORTRAN RECORDS WRITTEN =        7 WORDS.)
     (NUMBER OF FORTRAN RECORDS WRITTEN =        8 RECORDS.)
     (TOTAL DATA WRITTEN FOR TAPE LABEL =       17 WORDS.)
1                                                                           OCTOBER  25, 2017  NX NASTRAN  5/ 1/14   PAGE     4
                                                                                                                                    
0                                                                                                                                   
0                                                                                                                                   
                                                                                                                                    
                                                                                                                                    
 *** USER INFORMATION MESSAGE 4114 (OUTPX2)
     DATA BLOCK PVT0     WRITTEN ON FORTRAN UNIT  12, TRL =
                    101                27                 0                 0                 0                 0                 0
     (MAXIMUM POSSIBLE FORTRAN RECORD SIZE =    16386 WORDS.)
     (MAXIMUM SIZE OF FORTRAN RECORDS WRITTEN =       27 WORDS.)
     (NUMBER OF FORTRAN RECORDS WRITTEN =       19 RECORDS.)
     (TOTAL DATA WRITTEN FOR DATA BLOCK =       51 WORDS.)
 *** USER INFORMATION MESSAGE 4114 (OUTPX2)
     DATA BLOCK GPL      WRITTEN ON FORTRAN UNIT  12, TRL =
                    101            245192            245192                 0                 0                 0                 0
     (MAXIMUM POSSIBLE FORTRAN RECORD SIZE =    16386 WORDS.)
     (MAXIMUM SIZE OF FORTRAN RECORDS WRITTEN =    16386 WORDS.)
     (NUMBER OF FORTRAN RECORDS WRITTEN =      110 RECORDS.)
     (TOTAL DATA WRITTEN FOR DATA BLOCK =   735648 WORDS.)
 *** USER INFORMATION MESSAGE 4114 (OUTPX2)
     DATA BLOCK GPDT     WRITTEN ON FORTRAN UNIT  12, TRL =
                    102            245192                10                 0                 2                 0                 0
     (MAXIMUM POSSIBLE FORTRAN RECORD SIZE =    16386 WORDS.)
     (MAXIMUM SIZE OF FORTRAN RECORDS WRITTEN =    16386 WORDS.)
     (NUMBER OF FORTRAN RECORDS WRITTEN =      317 RECORDS.)
     (TOTAL DATA WRITTEN FOR DATA BLOCK =  2452093 WORDS.)
 *** USER INFORMATION MESSAGE 4114 (OUTPX2)
     DATA BLOCK EPT      WRITTEN ON FORTRAN UNIT  12, TRL =
                    101                 0               256                 0                 0                 0                 0
     (MAXIMUM POSSIBLE FORTRAN RECORD SIZE =    16386 WORDS.)
     (MAXIMUM SIZE OF FORTRAN RECORDS WRITTEN =       10 WORDS.)
     (NUMBER OF FORTRAN RECORDS WRITTEN =       24 RECORDS.)
     (TOTAL DATA WRITTEN FOR DATA BLOCK =       41 WORDS.)
 *** USER INFORMATION MESSAGE 4114 (OUTPX2)
     DATA BLOCK MPT      WRITTEN ON FORTRAN UNIT  12, TRL =
                    101             32768                 0                 0                 0                 0                 0
     (MAXIMUM POSSIBLE FORTRAN RECORD SIZE =    16386 WORDS.)
     (MAXIMUM SIZE OF FORTRAN RECORDS WRITTEN =       15 WORDS.)
     (NUMBER OF FORTRAN RECORDS WRITTEN =       24 RECORDS.)
     (TOTAL DATA WRITTEN FOR DATA BLOCK =       46 WORDS.)
 *** USER INFORMATION MESSAGE 4114 (OUTPX2)
     DATA BLOCK GEOM2    WRITTEN ON FORTRAN UNIT  12, TRL =
                    101                 0                 0                 0                 0               128                 0
     (MAXIMUM POSSIBLE FORTRAN RECORD SIZE =    16386 WORDS.)
     (MAXIMUM SIZE OF FORTRAN RECORDS WRITTEN =    16386 WORDS.)
     (NUMBER OF FORTRAN RECORDS WRITTEN =      178 RECORDS.)
     (TOTAL DATA WRITTEN FOR DATA BLOCK =  1262405 WORDS.)
 *** USER INFORMATION MESSAGE 4114 (OUTPX2)
     DATA BLOCK GEOM3    WRITTEN ON FORTRAN UNIT  12, TRL =
                    102                 0                 0                64                 0                 0                 0
     (MAXIMUM POSSIBLE FORTRAN RECORD SIZE =    16386 WORDS.)
     (MAXIMUM SIZE OF FORTRAN RECORDS WRITTEN =       10 WORDS.)
     (NUMBER OF FORTRAN RECORDS WRITTEN =       24 RECORDS.)
     (TOTAL DATA WRITTEN FOR DATA BLOCK =       41 WORDS.)
1                                                                           OCTOBER  25, 2017  NX NASTRAN  5/ 1/14   PAGE     5
                                                                                                                                    
0                                                                                                                                   
0                                                                                                                                   
                                                                                                                                    
                                                                                                                                    
 *** USER INFORMATION MESSAGE 4114 (OUTPX2)
     DATA BLOCK GEOM4    WRITTEN ON FORTRAN UNIT  12, TRL =
                    103                 0                 0                 0               512               512                 0
     (MAXIMUM POSSIBLE FORTRAN RECORD SIZE =    16386 WORDS.)
     (MAXIMUM SIZE OF FORTRAN RECORDS WRITTEN =    16386 WORDS.)
     (NUMBER OF FORTRAN RECORDS WRITTEN =       31 RECORDS.)
     (TOTAL DATA WRITTEN FOR DATA BLOCK =    37284 WORDS.)
 *** USER INFORMATION MESSAGE 4114 (OUTPX2)
     DATA BLOCK GEOM1    WRITTEN ON FORTRAN UNIT  12, TRL =
                    104                 0                 0                 8                 0                 0                 0
     (MAXIMUM POSSIBLE FORTRAN RECORD SIZE =    16386 WORDS.)
     (MAXIMUM SIZE OF FORTRAN RECORDS WRITTEN =    16386 WORDS.)
     (NUMBER OF FORTRAN RECORDS WRITTEN =      352 RECORDS.)
     (TOTAL DATA WRITTEN FOR DATA BLOCK =  2697310 WORDS.)
 *** USER INFORMATION MESSAGE 4114 (OUTPX2)
     DATA BLOCK BGPDT    WRITTEN ON FORTRAN UNIT  12, TRL =
                    105            245192                 0           1471152                 2                 0            245192
     (MAXIMUM POSSIBLE FORTRAN RECORD SIZE =    16386 WORDS.)
     (MAXIMUM SIZE OF FORTRAN RECORDS WRITTEN =    16386 WORDS.)
     (NUMBER OF FORTRAN RECORDS WRITTEN =      440 RECORDS.)
     (TOTAL DATA WRITTEN FOR DATA BLOCK =  3432924 WORDS.)
 *** USER INFORMATION MESSAGE 4114 (OUTPX2)
     DATA BLOCK CASECC   WRITTEN ON FORTRAN UNIT  12, TRL =
                    103                 1                 0               600                 0                 0                 0
     (MAXIMUM POSSIBLE FORTRAN RECORD SIZE =    16386 WORDS.)
     (MAXIMUM SIZE OF FORTRAN RECORDS WRITTEN =      600 WORDS.)
     (NUMBER OF FORTRAN RECORDS WRITTEN =       19 RECORDS.)
     (TOTAL DATA WRITTEN FOR DATA BLOCK =      624 WORDS.)
 *** USER INFORMATION MESSAGE 4114 (OUTPX2)
     DATA BLOCK EQEXIN   WRITTEN ON FORTRAN UNIT  12, TRL =
                    101            245192                 0                 0                 0                 0                 0
     (MAXIMUM POSSIBLE FORTRAN RECORD SIZE =    16386 WORDS.)
     (MAXIMUM SIZE OF FORTRAN RECORDS WRITTEN =    16386 WORDS.)
     (NUMBER OF FORTRAN RECORDS WRITTEN =      140 RECORDS.)
     (TOTAL DATA WRITTEN FOR DATA BLOCK =   980854 WORDS.)
1                                                                           OCTOBER  25, 2017  NX NASTRAN  5/ 1/14   PAGE     6
                                                                                                                                    
0                                                                                                                                   
 *** USER INFORMATION MESSAGE 7310 (VECPRN)
     ORIGIN OF SUPERELEMENT BASIC COORDINATE SYSTEM WILL BE USED AS REFERENCE LOCATION.
     RESULTANTS ABOUT ORIGIN OF SUPERELEMENT BASIC COORDINATE SYSTEM IN SUPERELEMENT BASIC SYSTEM COORDINATES.
0                                                  OLOAD    RESULTANT       
  SUBCASE/    LOAD
  DAREA ID    TYPE       T1            T2            T3            R1            R2            R3
0        1     FX    0.000000E+00     ----          ----          ----       0.000000E+00  0.000000E+00                             
               FY       ----      -3.400000E+06     ----      -6.460000E+08     ----       0.000000E+00                             
               FZ       ----          ----       0.000000E+00  0.000000E+00  0.000000E+00     ----                                  
               MX       ----          ----          ----       0.000000E+00     ----          ----                                  
               MY       ----          ----          ----          ----       0.000000E+00     ----                                  
               MZ       ----          ----          ----          ----          ----       0.000000E+00                             
             TOTALS  0.000000E+00 -3.400000E+06  0.000000E+00 -6.460000E+08  0.000000E+00  0.000000E+00
1                                                                           OCTOBER  25, 2017  NX NASTRAN  5/ 1/14   PAGE     7
                                                                                                                                    
0                                                                                                            SUBCASE 1              
0                                         G R I D   P O I N T   S I N G U L A R I T Y   T A B L E
0                             POINT    TYPE   FAILED      STIFFNESS       OLD USET           NEW USET
                               ID            DIRECTION      RATIO     EXCLUSIVE  UNION   EXCLUSIVE  UNION
                                1        G      4         0.00E+00          BF       F         SB       S    *
                                1        G      5         0.00E+00          BF       F         SB       S    *
                                1        G      6         0.00E+00          BF       F         SB       S    *
                                2        G      4         0.00E+00          BF       F         SB       S    *
                                2        G      5         0.00E+00          BF       F         SB       S    *
                                2        G      6         0.00E+00          BF       F         SB       S    *
                                3        G      4         0.00E+00          BF       F         SB       S    *
                                3        G      5         0.00E+00          BF       F         SB       S    *
                                3        G      6         0.00E+00          BF       F         SB       S    *
                                4        G      4         0.00E+00          BF       F         SB       S    *
                                4        G      5         0.00E+00          BF       F         SB       S    *
                                4        G      6         0.00E+00          BF       F         SB       S    *
                                5        G      4         0.00E+00          BF       F         SB       S    *
                                5        G      5         0.00E+00          BF       F         SB       S    *
                                5        G      6         0.00E+00          BF       F         SB       S    *
                                6        G      4         0.00E+00          BF       F         SB       S    *
                                6        G      5         0.00E+00          BF       F         SB       S    *
                                6        G      6         0.00E+00          BF       F         SB       S    *
                            
                                                                                                                                    
0     SUBCASE - STATIC LOADS 1                                                                               SUBCASE 1              
 
                      S T R E S S E S   I N   H E X A H E D R O N   S O L I D   E L E M E N T S   ( H E X A )
0                CORNER        ------CENTER AND CORNER POINT STRESSES---------       DIR.  COSINES       MEAN                   
  ELEMENT-ID    GRID-ID        NORMAL              SHEAR             PRINCIPAL       -A-  -B-  -C-     PRESSURE       [B][COLOR=#ff0000]VON MISES [/COLOR][/B]
0                242122  X   1.133073E+04  XY   9.837081E+03   A   2.313543E+04  LX 0.78-0.11 0.61   3.218683E+04    1.275364E+05
                         Y   4.391786E+02  YZ   2.604926E+04   B  -1.157625E+05  LY 0.58-0.21-0.78
                         Z  -1.083304E+05  ZX   1.638517E+04   C  -3.933470E+03  LZ 0.21 0.97-0.10
0                159624  X   1.413738E+04  XY   1.609090E+04   A   3.735323E+04  LX 0.60-0.06-0.80   1.652680E+04    1.125573E+05
                         Y   2.237969E+04  YZ   1.586538E+04   B  -8.869683E+04  LY 0.79-0.13 0.60
                         Z  -8.609748E+04  ZX   8.085578E+03   C   1.763184E+03  LZ 0.14 0.99 0.03
0                159623  X  -1.747499E+04  XY   1.873978E+04   A   1.444014E+04  LX 0.53-0.05-0.85   3.788439E+04    9.857641E+04
                         Y  -1.513256E+03  YZ   1.880456E+04   B  -9.848080E+04  LY 0.83-0.18 0.53
                         Z  -9.466493E+04  ZX   7.252242E+03   C  -2.961252E+04  LZ 0.18 0.98 0.06
0                241998  X  -1.164482E+04  XY   2.269017E+04   A   3.078335E+04  LX 0.47-0.06-0.88   3.177917E+04    1.166159E+05
                         Y   1.818997E+04  YZ  -9.791447E+03   B  -1.030296E+05  LY 0.88 0.09 0.46
                         Z  -1.018827E+05  ZX   3.737099E+03   C  -2.309127E+04  LZ-0.05 0.99-0.10
0                241999  X  -8.923224E+02  XY   1.172749E+04   A   1.191930E+04  LX 0.70 0.04-0.72   3.965329E+04    1.195408E+05
                         Y  -2.217668E+03  YZ  -1.545210E+04   B  -1.180564E+05  LY 0.71 0.13 0.70
                         Z  -1.158499E+05  ZX  -5.670306E+03   C  -1.282272E+04  LZ-0.12 0.99-0.07
0     57104           0GRID CS 20 GP
0                CENTER  X   1.340146E+04  XY   1.644309E+04   A   3.696736E+04  LX 0.58-0.02-0.82   8.917912E+03    8.991698E+04
                         Y   2.376653E+04  YZ   1.084421E+04   B  -6.526604E+04  LY 0.81-0.12 0.58
                         Z  -6.392173E+04  ZX   3.335397E+03   C   1.544944E+03  LZ 0.11 0.99 0.05
0                159624  X   9.900619E+03  XY   1.640112E+04   A   3.081530E+04  LX 0.62-0.00-0.79   2.328207E+04    1.152770E+05
                         Y   1.726304E+04  YZ   8.251739E+03   B  -9.760339E+04  LY 0.78-0.07 0.62
                         Z  -9.700988E+04  ZX   1.454181E+03   C  -3.058128E+03  LZ 0.06 1.00 0.04
0                159623  X  -2.128463E+04  XY   1.889679E+04   A   7.319555E+03  LX 0.55-0.01-0.83   4.370470E+04    9.801277E+04
                         Y  -5.762604E+03  YZ   7.008030E+03   B  -1.045660E+05  LY 0.83-0.07 0.55
                         Z  -1.040669E+05  ZX   1.743758E+03   C  -3.386768E+04  LZ 0.06 1.00 0.03
0                241998  X  -1.066980E+03  XY   2.283134E+04   A   5.536273E+04  LX 0.44-0.12-0.89   1.678075E+04    1.279649E+05
                         Y   2.837904E+04  YZ   4.002787E+04   B  -9.228384E+04  LY 0.84-0.29 0.46
                         Z  -7.765431E+04  ZX   1.840874E+04   C  -1.342114E+04  LZ 0.31 0.95 0.03
0                241999  X   1.135866E+04  XY   1.202230E+04   A   2.989232E+04  LX 0.68-0.14-0.72   2.256014E+04    1.135349E+05
                         Y   9.199476E+03  YZ   2.426130E+04   B  -9.604393E+04  LY 0.69-0.21 0.70
                         Z  -8.823857E+04  ZX   1.808780E+04   C  -1.528828E+03  LZ 0.25 0.97 0.05
0                160222  X   2.240716E+04  XY   1.929912E+04   A   5.287206E+04  LX 0.53 0.07-0.85  -7.076231E+03    8.288924E+04
                         Y   3.797228E+04  YZ   1.594724E+04   B  -4.260350E+04  LY 0.84-0.21 0.51
                         Z  -3.915075E+04  ZX  -4.120900E+02   C   1.096013E+04  LZ 0.14 0.98 0.17
0                160221  X  -8.274882E+03  XY   2.079110E+04   A   3.096993E+04  LX 0.46 0.14-0.88   1.413382E+04    7.525580E+04
                         Y   1.572450E+04  YZ   1.882445E+04   B  -5.571332E+04  LY 0.87-0.29 0.40
                         Z  -4.985106E+04  ZX  -6.308698E+02   C  -1.765805E+04  LZ 0.20 0.95 0.25
1                                                                           OCTOBER  25, 2017  NX NASTRAN  5/ 1/14   PAGE102551
                                                                                                                                    
0     SUBCASE - STATIC LOADS 1                                                                               SUBCASE 1              
 
                      
                                                                                                                                    
0     SUBCASE - STATIC LOADS 1                                                                               SUBCASE 1              
 
                      S T R E S S E S   I N   H E X A H E D R O N   S O L I D   E L E M E N T S   ( H E X A )
0                CORNER        ------CENTER AND CORNER POINT STRESSES---------       DIR.  COSINES       MEAN                   
  ELEMENT-ID    GRID-ID        NORMAL              SHEAR             PRINCIPAL       -A-  -B-  -C-     PRESSURE       VON MISES 
0                232620  X   1.223073E+04  XY  -3.304891E+04   A   5.001576E+04  LX-0.64 0.57-0.52  -7.794091E+03    6.729364E+04
                         Y   1.055822E+04  YZ   1.894873E+04   B  -2.644976E+04  LY 0.69 0.72-0.08
                         Z   5.933223E+02  ZX  -4.313411E+03   C  -1.837257E+02  LZ 0.32-0.41-0.85
0                232619  X   3.653259E+04  XY  -3.956508E+04   A   6.910783E+04  LX 0.74 0.29-0.61  -7.223160E+03    1.106460E+05
                         Y  -1.176219E+04  YZ   4.278613E+04   B  -5.848359E+04  LY-0.56 0.77-0.31
                         Z  -3.100921E+03  ZX  -4.665128E+03   C   1.104524E+04  LZ-0.38-0.57-0.73
1                                                                           OCTOBER  25, 2017  NX NASTRAN  5/ 1/14   PAGE102762
                                                                                                                                    
0                                                                                                                                   
1                                                                           OCTOBER  25, 2017  NX NASTRAN  5/ 1/14   PAGE102763
                                                                                                                                    
0     SUBCASE - STATIC LOADS 1                                                                               SUBCASE 1              
 
                                           E L E M E N T   S T R A I N   E N E R G I E S
 
                ELEMENT-TYPE = HEXA                * TOTAL ENERGY OF ALL ELEMENTS IN PROBLEM     =   1.495625E+06
                SUBCASE               1            * TOTAL ENERGY OF ALL ELEMENTS IN SET      -1 =   1.495625E+06
0
                                    ELEMENT-ID          STRAIN-ENERGY           PERCENT OF TOTAL    STRAIN-ENERGY-DENSITY
                                          7242          1.907395E+01                 0.0013              2.048528E+01
                                          7243          2.671168E+01                 0.0018              2.868816E+01
                                          7244          3.566567E+01                 0.0024              3.830468E+01
                                          7245          4.633645E+01                 0.0031              4.976503E+01
                                          7246          5.903668E+01                 0.0039              6.340498E+01
                                          7247          7.384431E+01                 0.0049              7.930835E+01
                                          7248          9.038338E+01                 0.0060              9.707130E+01
                                          7249          1.074911E+02                 0.0072              1.154450E+02
                                          7250          1.227633E+02                 0.0082              1.318474E+02
                                          7251          1.320839E+02                 0.0088              1.418580E+02
                                          7252          1.295979E+02                 0.0087              1.391881E+02
                                          7253          1.092953E+02                 0.0073              1.173832E+02
                                          7254          7.107687E+01                 0.0048              7.633672E+01
                                          7255          2.962847E+01                 0.0020              3.182088E+01
                                          7301          1.838616E+01                 0.0012              2.114826E+01
                                          7302          2.551329E+01                 0.0017              2.934608E+01
                                          7303          3.396314E+01                 0.0023              3.906533E+01
                                          7304          4.412934E+01                 0.0030              5.075878E+01
                                          7305          5.632285E+01                 0.0038              6.478409E+01
                                          7306          7.064448E+01                 0.0047              8.125729E+01
                                          7307          8.678491E+01                 0.0058              9.982256E+01
                                          7308          1.037145E+02                 0.0069              1.192956E+02
                                          7309          1.192482E+02                 0.0080              1.371631E+02
                                          7310          1.295628E+02                 0.0087              1.490274E+02
                                          7311          1.290444E+02                 0.0086              1.484313E+02
                                          7312          1.115515E+02                 0.0075              1.283106E+02
                                          7313          7.600037E+01                 0.0051              8.741847E+01
                                          7314          3.644176E+01                 0.0024              4.191645E+01
                                          7315          1.678088E+01                 0.0011              2.109145E+01
                                          7316          2.085406E+01                 0.0014              2.386732E+01
                                          7317          2.852363E+01                 0.0019              2.986171E+01
                                          7318          3.346480E+01                 0.0022              2.926928E+01
                                          7319          2.827164E+01                 0.0019              2.472732E+01
                                          7320          2.304076E+01                 0.0015              2.015249E+01
                                          7321          1.905234E+01                 0.0013              1.666446E+01
                                          7322          1.630307E+01                 0.0011              1.426041E+01
                                          7360          1.961494E+01                 0.0013              2.234955E+01
                                          7361          2.679829E+01                 0.0018              3.053437E+01
                                          7362          3.549215E+01                 0.0024              4.044028E+01
                                          7363          4.613113E+01                 0.0031              5.256252E+01
                                          7364          5.906444E+01                 0.0039              6.729893E+01
                                          7365          7.444814E+01                 0.0050              8.482742E+01
                                          7366          9.205145E+01                 0.0062              1.048850E+02
                                          7367          1.109460E+02                 0.0074              1.264139E+02
                                          7368          1.290487E+02                 0.0086              1.470407E+02
                                          7369          1.425506E+02                 0.0095              1.624252E+02
1                                                                           OCTOBER  25, 2017  NX NASTRAN  5/ 1/14   PAGE102764
                                                                                                                                    
0     SUBCASE - STATIC LOADS 1                                                                               SUBCASE 1              
 
                                         
                                                                                                                                    
0     SUBCASE - STATIC LOADS 1                                                                               SUBCASE 1              
 
                                           E L E M E N T   S T R A I N   E N E R G I E S
 
                ELEMENT-TYPE = HEXA                * TOTAL ENERGY OF ALL ELEMENTS IN PROBLEM     =   1.495625E+06
                SUBCASE               1            * TOTAL ENERGY OF ALL ELEMENTS IN SET      -1 =   1.495625E+06
0
                                    ELEMENT-ID          STRAIN-ENERGY           PERCENT OF TOTAL    STRAIN-ENERGY-DENSITY
                                         56397          2.027787E+01                 0.0014              3.994864E+02
                                         56398          1.662885E+01                 0.0011              3.275985E+02
                                         56419          1.518344E+01                 0.0010              1.832278E+02
                                         56426          3.230623E+01                 0.0022              6.729693E+02
                                         56427          4.074715E+01                 0.0027              7.688598E+02
                                         56428          2.357957E+01                 0.0016              4.449412E+02
                                         56429          1.886528E+01                 0.0013              3.559956E+02
                                         56430          1.611887E+01                 0.0011              3.041782E+02
                                         56457          2.717589E+01                 0.0018              2.374225E+02
                                         56458          3.398682E+01                 0.0023              2.690817E+02
                                         56459          2.081217E+01                 0.0014              1.647759E+02
                                         56460          1.705793E+01                 0.0011              1.350535E+02
                                         56489          1.797512E+01                 0.0012              3.813917E+02
                                         56520          1.834634E+01                 0.0012              3.326087E+02
                                         56550          1.564153E+01                 0.0010              2.947044E+02
                                         56551          1.902879E+01                 0.0013              3.247785E+02
                                         56581          1.941006E+01                 0.0013              3.628502E+02
                                         56582          2.441553E+01                 0.0016              4.135331E+02
                                         56603          1.856611E+01                 0.0012              9.125332E+01
                                         56604          2.178876E+01                 0.0015              1.070905E+02
                                         56605          2.202544E+01                 0.0015              1.082510E+02
                                         56606          1.972276E+01                 0.0013              9.693407E+01
                                         56607          1.561230E+01                 0.0010              7.673465E+01
                                         56611          2.217467E+01                 0.0015              1.669647E+02
                                         56612          4.563678E+01                 0.0031              3.868779E+02
                                         56613          5.707391E+01                 0.0038              4.384956E+02
                                         56614          3.457449E+01                 0.0023              2.656298E+02
                                         56615          2.802795E+01                 0.0019              2.153311E+02
                                         56616          2.414305E+01                 0.0016              1.854822E+02
                                         56617          2.106193E+01                 0.0014              1.618085E+02
                                         56618          1.837134E+01                 0.0012              1.411350E+02
                                         56619          1.591605E+01                 0.0011              1.222702E+02
                                         56643          2.122485E+01                 0.0014              4.973401E+02
                                         56644          2.690363E+01                 0.0018              5.707084E+02
                                         56645          1.550952E+01                 0.0010              3.290021E+02
                                         56674          2.182037E+01                 0.0015              4.540624E+02
                                         56675          2.760235E+01                 0.0018              5.204126E+02
                                         56676          1.598821E+01                 0.0011              3.014467E+02
                                         56705          2.034896E+01                 0.0014              4.435052E+02
                                         56706          2.482052E+01                 0.0017              4.899901E+02
                                         56707          1.555240E+01                 0.0010              3.070247E+02
                                         56736          2.642754E+01                 0.0018              5.268125E+02
                                         56737          3.320952E+01                 0.0022              5.999908E+02
                                         56738          1.933488E+01                 0.0013              3.493147E+02
                                         56739          1.551342E+01                 0.0010              2.802693E+02
                                         57078          1.655071E+01                 0.0011              1.275475E+02


                        TYPE = HEXA     SUBTOTAL        1.495620E+06                99.9997
1                                                                           OCTOBER  25, 2017  NX NASTRAN  5/ 1/14   PAGE103194
                                                                                                                                    
0                                                                                                                                   
 *** USER INFORMATION MESSAGE 4114 (OUTPX2)
     DATA BLOCK ONRGY1   WRITTEN ON FORTRAN UNIT  12, TRL =
                    101                 1                 0                 0                 0                 1                 0
     (MAXIMUM POSSIBLE FORTRAN RECORD SIZE =    16386 WORDS.)
     (MAXIMUM SIZE OF FORTRAN RECORDS WRITTEN =    16386 WORDS.)
     (NUMBER OF FORTRAN RECORDS WRITTEN =       32 RECORDS.)
     (TOTAL DATA WRITTEN FOR DATA BLOCK =    79486 WORDS.)
 *** USER INFORMATION MESSAGE 4110 (OUTPX2)
                                 END-OF-DATA SIMULATION ON FORTRAN UNIT 12
                                 (MAXIMUM SIZE OF FORTRAN RECORDS WRITTEN =      1 WORDS.)
                                       (NUMBER OF FORTRAN RECORDS WRITTEN =      1 RECORDS.)
                                       (TOTAL DATA WRITTEN FOR EOF MARKER =      1 WORDS.)
1                                                                           OCTOBER  25, 2017  NX NASTRAN  5/ 1/14   PAGE103195
                                                                                                                                    
0                                                                                                                                   
 * * * *  D B D I C T   P R I N T  * * * *      SUBDMAP = PRTSUM  ,  DMAP STATEMENT NO.     31






0                                   * * * *  A N A L Y S I S  S U M M A R Y  T A B L E  * * * *
0 SEID  PEID PROJ VERS APRCH      SEMG SEMR SEKR SELG SELR MODES DYNRED SOLLIN PVALID SOLNL LOOPID DESIGN CYCLE SENSITIVITY
 --------------------------------------------------------------------------------------------------------------------------
     0     0    1    1 '        '    T    T    T    T    T     F      F      T      0     F     -1            0           F
0SEID = SUPERELEMENT ID.
 PEID = PRIMARY SUPERELEMENT ID OF IMAGE SUPERELEMENT.
 PROJ = PROJECT ID NUMBER.
 VERS = VERSION ID.
 APRCH = BLANK FOR STRUCTURAL ANALYSIS.  HEAT FOR HEAT TRANSFER ANALYSIS.
 SEMG = STIFFNESS AND MASS MATRIX GENERATION STEP.
 SEMR = MASS MATRIX REDUCTION STEP (INCLUDES EIGENVALUE SOLUTION FOR MODES).
 SEKR = STIFFNESS MATRIX REDUCTION STEP.
 SELG = LOAD MATRIX GENERATION STEP.
 SELR = LOAD MATRIX REDUCTION STEP. 
 MODES = T (TRUE) IF NORMAL MODES OR BUCKLING MODES CALCULATED.
 DYNRED = T (TRUE) MEANS GENERALIZED DYNAMIC AND/OR COMPONENT MODE REDUCTION PERFORMED.
 SOLLIN = T (TRUE) IF LINEAR SOLUTION EXISTS IN DATABASE.
 PVALID = P-DISTRIBUTION ID OF P-VALUE FOR P-ELEMENTS
 LOOPID = THE LAST LOOPID VALUE USED IN THE NONLINEAR ANALYSIS.  USEFUL FOR RESTARTS.
 SOLNL = T (TRUE) IF NONLINEAR SOLUTION EXISTS IN DATABASE.
 DESIGN CYCLE = THE LAST DESIGN CYCLE (ONLY VALID IN OPTIMIZATION).
 SENSITIVITY = SENSITIVITY MATRIX GENERATION FLAG.
1                                        * * * END OF JOB * * *
 

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.

Forum statistics

Threads
1,214,592
Messages
6,120,433
Members
448,961
Latest member
nzskater

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top