Hot News:

Mit Unterstützung durch:

  Foren auf CAD.de (alle Foren)
  NX
  Volumenausgabe von UG zu Excel

Antwort erstellen  Neues Thema erstellen
CAD.de Login | Logout | Profil | Profil bearbeiten | Registrieren | Voreinstellungen | Hilfe | Suchen

Anzeige:

Darstellung des Themas zum Ausdrucken. Bitte dann die Druckfunktion des Browsers verwenden. | Suche nach Beiträgen nächster neuer Beitrag | nächster älterer Beitrag
  
Gut zu wissen: Hilfreiche Tipps und Tricks aus der Praxis prägnant, und auf den Punkt gebracht für NX
  
On-Demand-Webinare zu Solid Edge (Solid Edge)
Autor Thema:  Volumenausgabe von UG zu Excel (1111 mal gelesen)
Danni
Mitglied



Sehen Sie sich das Profil von Danni an!   Senden Sie eine Private Message an Danni  Schreiben Sie einen Gästebucheintrag für Danni

Beiträge: 35
Registriert: 05.06.2002

erstellt am: 06. Sep. 2002 11:29    Editieren oder löschen Sie diesen Beitrag!  <-- editieren / zitieren -->   Antwort mit Zitat in Fett Antwort mit kursivem Zitat    Unities abgeben: 1 Unity (wenig hilfreich, aber dennoch)2 Unities3 Unities4 Unities5 Unities6 Unities7 Unities8 Unities9 Unities10 Unities

Hallo UG-User,

vielleicht hat jemand von Euch damit Erfahrung:
Gibt es eine Möglichkeit, das Volumen eines Körpers in Excel direkt auszugeben?
Es muss wohl irgendwie per Attribut gehen, aber ich habe keine Ahnung wie.
Habe V18.0.3 und Excel 2000.

Danni

[Diese Nachricht wurde von Danni am 06. September 2002 editiert.]

Eine Antwort auf diesen Beitrag verfassen (mit Zitat/Zitat des Beitrags) IP

Danni
Mitglied



Sehen Sie sich das Profil von Danni an!   Senden Sie eine Private Message an Danni  Schreiben Sie einen Gästebucheintrag für Danni

Beiträge: 35
Registriert: 05.06.2002

erstellt am: 10. Sep. 2002 10:06    Editieren oder löschen Sie diesen Beitrag!  <-- editieren / zitieren -->   Antwort mit Zitat in Fett Antwort mit kursivem Zitat    Unities abgeben: 1 Unity (wenig hilfreich, aber dennoch)2 Unities3 Unities4 Unities5 Unities6 Unities7 Unities8 Unities9 Unities10 Unities

Hab's rausgefunden, wenn es jemanden interessiert:

Man muss dem Koerper per Attribut einen Namen und den Wert 1 zuweisen.

In Excel lautet die Eingabe: =mass3d("Koerper1";2;3)

Wenn man die 2 durch die 1 ersetzt wird der Bereich, oder durch die 3 ersetzt, wird die Masse angezeigt.

Eine Antwort auf diesen Beitrag verfassen (mit Zitat/Zitat des Beitrags) IP

konradw
Mitglied
CAD Key User


Sehen Sie sich das Profil von konradw an!   Senden Sie eine Private Message an konradw  Schreiben Sie einen Gästebucheintrag für konradw

Beiträge: 981
Registriert: 07.03.2000

NX12

erstellt am: 10. Sep. 2002 12:46    Editieren oder löschen Sie diesen Beitrag!  <-- editieren / zitieren -->   Antwort mit Zitat in Fett Antwort mit kursivem Zitat    Unities abgeben: 1 Unity (wenig hilfreich, aber dennoch)2 Unities3 Unities4 Unities5 Unities6 Unities7 Unities8 Unities9 Unities10 Unities Nur für Danni 10 Unities + Antwort hilfreich

Hi Danni!

Habe ich schon mal gehoert, jedoch nie verwendet. Nun kann man es hier im Forum nachlesen. 

Das ist genauso wie damals mit dem SECTION COMPONENT (NO/YES) Attribut.

------------------
Gruss, Konrad

Eine Antwort auf diesen Beitrag verfassen (mit Zitat/Zitat des Beitrags) IP

konradw
Mitglied
CAD Key User


Sehen Sie sich das Profil von konradw an!   Senden Sie eine Private Message an konradw  Schreiben Sie einen Gästebucheintrag für konradw

Beiträge: 981
Registriert: 07.03.2000

NX12

erstellt am: 10. Sep. 2002 13:30    Editieren oder löschen Sie diesen Beitrag!  <-- editieren / zitieren -->   Antwort mit Zitat in Fett Antwort mit kursivem Zitat    Unities abgeben: 1 Unity (wenig hilfreich, aber dennoch)2 Unities3 Unities4 Unities5 Unities6 Unities7 Unities8 Unities9 Unities10 Unities Nur für Danni 10 Unities + Antwort hilfreich

Object-Related Functions

Object-related functions generally work on a specific Unigraphics object. In order to use a Unigraphics object with one of these spreadsheet functions, you will
need to assign a Unigraphics name attribute to the object.
This section contents are:

      MASS3D Functions

      MASS3D Keywords

      Using Component Names

        NOTE: Object-related functions may take string or numeric arguments. String arguments such as "object_name" may be specified by the string in double
      quotes, such as "LINE1", or by a cell reference to that string.
UGATTR( "object_name", "attribute_title", attribute_type)

      Returns a Unigraphics attribute value given a Unigraphics object name, a user-defined attribute title, and a numeric attribute type. The numeric
      attribute type may be:

                  1 = integer attribute

                  2 = real attribute

                  3 = string attribute

                  4 = reference attribute

      If the object name is the string "PART", then the specified work part attribute title and type will be returned.

UGNAMES()

      Returns the object name, object type and subtype, and layer of all named geometric objects in the work part. One row of information will be returned
      per object.

ALLATTR("object_name")

      Returns all the integer, real, and string attribute titles and types associated with a given object. If the object name is the string "PART"; then all
      integers, real, and string part attribute titles and types will be returned.

ARCLEN( "object_name", param1, param2, units )

      Returns arc length of a curve between two parameter values param1 and param2. This function will work on any curve type, such as arcs, circles, conics,
      and lines.
      Parameter values are from 0.0 to 1.0. Units' conversion is a number from 1 to 4, where:

                  1 = INCHES

                  2 = MILLIMETERS

                  3 = CENTIMETERS

                  4 = METERS

      If the object is not a curve, you will get the message:

              @ARCLEN: Curve object type required.

      EVALCRV( "object_name", eval_type, param1, param2, steps)

              Returns curve evaluation information for a number of steps along a curve between two parameter values param1 and param2.
              Parameter values range from 0.0 to 1.0, and the number of steps can be from 1 to 100. Curve evaluation types are:

Type
                      # Values
                                                              Description
1
                      3
                                                              Point
2
                      1
                                                              Curvature
3
                      1
                                                              Normalized curvature
4
                      3
                                                              Tangent
5
                      3
                                                              Binormal
6
                      3
                                                              Principal Normal
7
                      1
                                                              Torsion
8
                      3
                                                              Derivative


When multiple steps are used between parameter values the first column will contain the evaluated parameter value, and the column(s) to the right will contain the
data value(s), so that the data is in a form acceptable to the graphing functions in the spreadsheet.
As with ARCLEN, this function will work on any curve type and will return an error message if the object is not a curve.
EVALSRF( "object_name", eval_type, umin, umax, numu, vmin, vmax, numv )

      For EVALSRF, the object must be a face. The function returns surface evaluation information for a number of steps in u and v between two parameter
      values.
      Parameter values range from 0.0 to 1.0, number of steps from 1 to 100. Surface evaluation types are:
        Type
                              # Values
                                                                          Description
        1
                              1
                                                                          Gaussian curvature
        2
                              1
                                                                          Mean curvature
        3
                              1
                                                                          Min radius
        4
                              1
                                                                          Max radius


      When multiple steps are used between parameter values, the output will be in a form compatible with the graphing functions. If just u or v are
      changing, you get output in the same form as @EVALCRV. If both u and v are changing you get output compatible with a surface graph.

POINT( "object_name" )

      Returns the "defining" xyz position for object in the current cell and the next two columns. For circles, arcs, and elliptical conics, the center of
      the circle is returned. For planes and coordinate systems, the object origin is returned.
      The function recognizes the following types of Unigraphics objects:

                          RM_point_type,

                          RM_gfem_node_type,

                          RM_mdm_analysis_pt_type,

                          RM_conic_type

                          RM_circle_type,

                          RM_coordinate_system_type,

                          RM_plane_type

      Use of other object types will result in the error message:

                    @POINT: Unable to process object type.

MASS3D( "object_name", type, units)

      Returns mass properties for a named sheet or solid body, or all sheets or solids in a part or assembly component.
      Single return values are returned in the cell. Multiple values are returned in sets of 3 columns. When all properties (type=0) are returned, each
      property is placed in consecutive rows of the spreadsheet. Multiple values for a property are placed in adjacent columns.
      Values for "object_name" are:

"object name string"
                                                            name of a single sheet body or solid object
PART
                                                            extracts mass properties for all sheets and solids in the part
SOLIDS
                                                            extracts mass properties for all solids in the part
SHEETS
                                                            extracts mass properties for all sheets in the part
Assembly Component Part Name
                                                            extracts mass properties for all sheets and solids in the component
                                                            part


      Units are:

1
            pounds & inches
2
            pounds & feet
3
            grams & centimeters
4
            kilograms & meters


      Values for the type field are shown below.

Type
          # Values
                          Description
0
          42
                          All properties
1
          1
                          Area
2
          1
                          Volume
3
          1
                          Mass
4
          3
                          Center of Mass (CofM), WCS
5
          3
                          First Moments, WCS Axes and Origin
6
          3
                          Moments of Inertia with respect to (w.r.t.) WCS Axes and Origin
7
          3
                          Moments of Inertia w.r.t. CofM Origin/WCS Axes
8
          1
                          Spherical Moment of Inertia w.r.t. CofM Origin/ WCS Axes
9
          3
                          Inertia Products w.r.t. WCS Axes and Origin
10
          3
                          Inertia Products w.r.t. CofM Origin/WCS Axes
11
          3x3=9
                          Principal Axes, WCS
12
          3
                          Principal Moments w.r.t. CofM Origin
13
          3
                          Radii Of Gyration w.r.t. WCS Axes and Origin
14
          3
                          Radii Of Gyration w.r.t. CofM

                          Origin/WCS Axes
15
          1
                          Spherical Radius of Gyration w.r.t. CofM Origin/WCS Axes
16
          1
                          Density


Usage Notes for @MASS3D

@MASS3D is one of the more useful of the spreadsheet built-in functions, and can be used to obtain mass properties information from the part.
The capabilities of the mass properties command have been enhanced to allow you to determine mass properties of an entire part, a component, an assembly, or even a
sub-assembly.
The basic mass properties function has the following form:

              MASS3D("object_name", type, units )

where "object_name" is the named object to use in calculations (the type and units fields are discussed on the preceding pages).
The "object_name" can be one of 3 special keywords: PART, SOLIDS, or SHEETS. In addition, "object_name" can also be the name of a component in an assembly.

MASS3D Keywords

Instead of selecting a specific object, you can use a keyword that selects all appropriate data from the part. If you want to have mass properties calculations on
all of the solids in a part, including any solids in assembly components, use either PART or SOLIDS as the object name. In a similar manner, you can perform mass
properties calculations on all sheet bodies in the part by using the keyword, SHEETS.

Using Components of Assemblies

When you are working in an assembly you can use the names of parts in the assembly as the value for the "object_name". For example, consider the following part
structure:

Given the part structure shown above, all of the following formulas would be good examples of valid cell contents:

  =@MASS3D("sub_comp.prt", 1, 2 )for a sub assembly

  =@MASS3D("sub_comp1.prt", 1, 2 )for a component

  =@MASS3D("SUB_COMP1.PRT", 1, 2 )case insensitive for names

Using Components and UG/Manager

For a part named 000007/A in UG/Manager, the proper use of the MASS3D function for this component would be:

  =@MASS3D("00007/A",0,1)


Sorry, leider nur in Englisch aber komplett...

------------------
Gruss, Konrad

Eine Antwort auf diesen Beitrag verfassen (mit Zitat/Zitat des Beitrags) IP

Anzeige.:

Anzeige: (Infos zum Werbeplatz >>)

Darstellung des Themas zum Ausdrucken. Bitte dann die Druckfunktion des Browsers verwenden. | Suche nach Beiträgen

nächster neuerer Beitrag | nächster älterer Beitrag
Antwort erstellen


Diesen Beitrag mit Lesezeichen versehen ... | Nach anderen Beiträgen suchen | CAD.de-Newsletter

Administrative Optionen: Beitrag schliessen | Archivieren/Bewegen | Beitrag melden!

Fragen und Anregungen: Kritik-Forum | Neues aus der Community: Community-Forum

(c)2024 CAD.de | Impressum | Datenschutz