I creating an excel file with some grid points spacing (0.05" interval). I saved the file as csv and converted into dat. Now when I am trying to import it into Patran it is not reading the grid points and given me error.
Here is my file for reference.
GRID 101 0.55 0 0
GRID 101 0.55 0 0
Here is the error
$REJECT (SEMTRN) IGNORE INPUT CARD(S) BEFORE BEGIN BULK
$REJECT (SEMTRN) CASE CONTROL CARD(S) AFTER CEND
The .dat file does not have any begin bulk or CEND command.
Any idea what is going wrong with this? or a way out of this
From what you've posted it looks like your spacings are wrong (although it's possible that's just something that's happened with pasting into the message here.)
In the GRID entries above it looks like you've only got 7 characters per field instead of 8. So the first field is ending up as "GRID 1", etc.
You may find it easier to write the file out of Excel with "," comma separators rather than trying to do fixed width format. This will correspond to Nastran free format input, though it does not make an easily readable file (I was going to use the phrase deck, but few people these days understand the reference to a deck of cards :-) ). It also enables you to handle real numbers in exponential format better.
An alternative approach in Excel: Set column width to 8 and save the file as *.prn. This writes a formatted small field Nastran file. Ensure that the last column does not contain more than 8 characters.