×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Problem to export the table to the excel!

Problem to export the table to the excel!

Problem to export the table to the excel!

(OP)
All the units are stranges when i export the SAP2000´s table to the excel and i can´t recognize the units that the program exported ...


what can i do to change this?

This file is an example of this case.
I´m working with: kN,m,C....

RE: Problem to export the table to the excel!

Problem is your Control Panel or Excel Settings.

Lets make a small test. Do the following

1-check how Excel writes one million with 2 decimal places. Let us say it writes 1,000,000.00

2-Enter a general frame member in sap2000, and set its area as one million. See how sap2000 reads it. Does it read it like 1,000,000.00?

Probably no.

In that case go to Control Panel-Regional settings, and set your numbers so that they read the same way.




 

RE: Problem to export the table to the excel!

Both the Excel and SAP2000 use the same decimal symbol as set in Control Panel / Regional and Language Settings.
The problem might be from your SAP2000 input file. If you wrote, for example, 2.5, and in your Control Panel you have "," as decimal separator, SAP2000 understands 25 instead of 2.5.
When you export the table from SAP to Excel, the units of measure are given at the top of each column. Make sure your units of measure are set to kN, m and C before you export the results to Excel. If this were the case and you can't recognize the order of magnitude for the units of measure, check your input file for the decimal symbol misunderstanding.

best wishes,
iotoma

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources