Appendix > Structural Analysis Calculations > Structural Analysis Tables |
Version: 10.1 |
ArcFM Structural Analysis allows you to perform "what if" scenarios to evaluate the structural integrity of a support structure and its associated features. These analysis tools rely on lookup tables in the EngAnalysisLookupTables.mdb. This database is installed in the Support folder of the ArcFM Solution installation directory. The tables included in this database are defined below. These tables must be owned by SDE.
MMENG_ANCHORCAPACITY
Field |
Data Type |
Description |
Units |
How Used |
---|---|---|---|---|
AnchorType |
text |
Reflects the value chosen by the user in the Type field on the Anchor Properties dialog. |
Used to look up anchor properties (i.e., torque, holding capacity, shear pins) |
|
Torque |
long integer |
The appropriate amount of torque for the anchor type. |
Ft-lbs |
Used in anchor calculations. |
HoldingCapacity |
long integer |
The maximum holding capacity for the anchor type. |
lbs |
Used in anchor calculations. |
ShearPins |
long integer |
The number of shear pins required for the anchor type. |
|
Used in anchor calculations. |
MMENG_ANCHORPRICE
Field |
Data Type |
Description |
Units |
How Used |
---|---|---|---|---|
AnchorType |
text |
Reflects the value chosen by the user in the Type field on the Anchor Properties dialog. |
|
Used to look up price by torque. |
Torque |
long integer |
The appropriate amount of torque for the anchor type. |
ft.-lbs. |
Used to create unique combination of price and torque. |
Price |
long integer |
The cost of the anchor type. |
US $$ |
Used the choose the lowest priced anchor for the run capacity needed. |
MMENG_ANCHORSTOCKNUMBER
Field |
Data Type |
Description |
Units |
How Used |
---|---|---|---|---|
AnchorType |
text |
Reflects the value chosen by the user in the Type field on the Anchor Properties dialog. |
|
Not currently used. |
StockNumber |
text |
The stock number associated with the anchor type. |
|
Not currently used. |
MMENG_ANCHORTORQUES
Field |
Data Type |
Description |
Units |
How Used |
---|---|---|---|---|
SoilClass |
text |
Reflects the value chosen by the user in the Soil Class field. |
|
The value selected in the Soil Class field is used to filter the list of available anchors. |
AnchorType |
text |
Reflects the value chosen by the user in the Type field on the Anchor Properties dialog. |
|
Used to create a unique combination of anchor type and torque by soil type. |
Torque |
long integer |
The appropriate amount of torque for the anchor type. |
ft.-lbs. |
Used to create a unique combination of anchor type and torque by soil type. |
MMENG_ANCHORTYPES
Field |
Data Type |
Description |
Units |
How Used |
---|---|---|---|---|
AnchorType |
text |
This field populates the pull down menu for the Type field in the Anchor Properties dialog. |
|
Not currently used. |
MMENG_CONDMATLTRANSLATION
Field |
Data Type |
Description |
Units |
How Used |
---|---|---|---|---|
GeoMaterial |
text |
Material type in the geodatabase. |
|
Used to auto-populate engineering data grids with geodatabase materials. |
EngMaterial |
text |
Material type in the engineering calculations tables. |
|
Used to auto-populate engineering data grids with geodatabase materials. |
MMENG_CONDMATLVV
Field |
Data Type |
Description |
Units |
How Used |
---|---|---|---|---|
ConductorMaterial |
text |
Reflects the conductor material. |
|
The conductor material is shown along with the size in the Type field in the Span Properties and Add Span dialogs (Figure 1). |
MMENG_CONDSIZETRANSLATION
Field |
Data Type |
Description |
Units |
How Used |
---|---|---|---|---|
GeoSize |
text |
Size in the geodatabase. |
|
Used to auto-populate engineering data grids with geodatabase size. |
EngSize |
text |
Size in the engineering calculations tables. |
|
Used to auto-populate engineering data grids with geodatabase size. |
MMENG_CONDSIZEVV
Field |
Data Type |
Description |
Units |
How Used |
---|---|---|---|---|
ConductorSize |
text |
Reflects the size of the conductor. |
|
The conductor material is shown along with the size in the Type field in the Span Properties and Add Span dialogs (Figure 1). |
MMENG_CONDTENSION
Field |
Data Type |
Description |
Units |
How Used |
---|---|---|---|---|
RulingSpan |
long integer |
Reflects the value selected in the Design Ruling Span field on the Ruling Span tab. |
ft. |
This value is used as the basis for the sag and tension computations of the conductor. |
LoadingDistrict |
text |
The loading district of the pole. This field reflects the value chosen by the user in the Loading District field. |
|
The chosen value for a pole is used to retrieve the correct values from other MMENG tables. |
ConductorSize |
text |
Reflects the size of the conductor. The size is shown along with the conductor material in the Type field in the Conductor grid (Figure 1). |
|
Used to calculate the Wind Moment on Pole. |
ConductorMaterial |
text |
Reflects the conductor material. The conductor material is shown along with the size in the Type field in the Conductor grid (Figure 1). |
|
Used in pole moment calculations. |
Stranding |
text |
|
|
Not currently used. |
SortSize |
text |
|
|
Not currently used. |
Sag_at_Max_Tension |
text |
Sag at conductor maximum tension. |
feet |
Used to calculate conductor clearance. |
Tension_at_Max_Sag |
text |
|
lbs. |
Not currently used. |
MaxSag |
text |
|
|
Not currently used. |
MaxCondTension |
long integer |
Maximum conductor tension. |
lbs. |
Used in pole moment calculations. |
WeightPerFoot |
double |
Weight of one foot of conductor. |
lbs.-ft. |
Used in pole moment calculations. |
MMENG_CONDTRANSWINDLOAD
Field |
Data Type |
Description |
Units |
How Used |
---|---|---|---|---|
LoadingDistrict |
text |
The loading district of the pole. This field reflects the value chosen by the user in the Loading District field. |
|
Used to calculate the Wind Moment on Pole. |
ConductorSize |
text |
Reflects the size of the conductor. The size is shown along with the conductor material in the Type field in the Conductor grid (Figure 1). |
|
Used to calculate the Wind Moment on Pole. |
ConductorMaterial |
text |
Reflects the conductor material. The conductor material is shown along with the size in the Type field in the Conductor grid (Figure 1). |
|
Used to calculate the Wind Moment on Pole. |
SortSize |
long integer |
|
|
Not currently used. |
TransverseWindLoad |
double |
Wind load of the conductor loading district. |
lbs. |
Used in the wind load calculation. |
Figure 1, The Type field displays the conductor’s size and material
MMENG_DEVICEWEIGHT
Field |
Data Type |
Description |
Units |
How Used |
---|---|---|---|---|
ModelName |
text |
ArcFM object model name that identifies the device. |
|
Used to look up device weight by type and rating. |
ManufacturerModel |
text |
Name of manufacturer model for device. |
|
Uniquely identifies a device and weight. Used in buckling calculations. |
SerialNumber |
text |
Serial number of the device model. |
|
Uniquely identifies a device and weight. Used in buckling calculations. |
Rating |
text |
Rating of the device (e.g., 25 kVA). |
|
Uniquely identifies a device and weight. Used in buckling calculations. |
DeviceType |
text |
Distinguishes like devices by type. |
|
Uniquely identifies a device and weight. Used in buckling calculations. |
Weight |
double |
Weight of device. |
lbs |
Used in buckling calculations. |
Diameter |
double |
|
|
Not currently used. |
AttachmentHeight |
double |
|
|
Not currently used. |
MMENG_GUYCABLEDIAMETERVV
Field |
Data Type |
Description |
Units |
How Used |
---|---|---|---|---|
Diameter_as_Text |
text |
Diameter of the guy wire. |
|
Look up values for guy types to populate the guy properties. |
MMENG_GUYCABLEMATERIALVV
Field |
Data Type |
Description |
Units |
How Used |
---|---|---|---|---|
Material |
text |
Material of a guy wire. |
|
Look up values for guy types to populate the guy properties. |
MMENG_GUYCABLESTRENGTH
Field |
Data Type |
Description |
Units |
How Used |
---|---|---|---|---|
Diameter_as_Text |
text |
Diameter of the guy. |
|
Look up values for guy types to populate the guy properties. |
Material |
text |
Material type of the guy wire. |
|
Used to uniquely identify the rated breaking strength for a given guy material and diameter. |
Diameter |
double |
Diameter of the guy wire. |
in. |
Used to uniquely identify the rated breaking strength for a given guy material and diameter. |
RatedBreakingStrength |
double |
Total Guy Capacity for a guy. |
ft.-lbs. |
This value is displayed in the Guys and Anchors field on the Bisector Guy and Dead End Guy tabs. |
MMENG_GUYWIRESIZETRNSLATN
Field |
Data Type |
Description |
Units |
How Used |
---|---|---|---|---|
GeoWireSize |
text |
Wire size in the geodatabase. |
in. |
Used to auto-populate engineering data grids with geodatabase wire size. |
EngWireSize |
text |
Wire size in the engineering calculation tables. |
in. |
Used to auto-populate engineering data grids with geodatabase wire size. |
MMENG_GUYWRSTRNGTHTRNSLATN
Field |
Data Type |
Description |
Units |
How Used |
---|---|---|---|---|
GeoWireStrength |
text |
Wire strength in the geodatabase. |
ft.-lbs. |
Used to auto-populate engineering data grids with geodatabase wire strength. |
EngWireStrength |
text |
Wire strength in the engineering calculation tables. |
ft.-lbs. |
Used to auto-populate engineering data grids with geodatabase wire strength. |
MMENG_INSULATORSTRENGTH
Field |
Data Type |
Description |
Units |
How Used |
---|---|---|---|---|
Insulator |
text |
This field lists the types of insulators available for selection on the Cross Arm Tab (Figure 3). |
|
Used to populate the drop down box in the Insulator field on the Cross Arm tab. |
Description |
text |
This field provides a description of the insulators. |
|
Used to display insulator strength on the Cross Arm tab. |
WorkingStrength |
double |
Rated strength of insulator. |
ft.-lbs. |
Used when comparing the load of the wire/conductor to the strength of the insulator(s). If the load of the conductor exceeds the strength of the insulator(s), the Insulator fields are highlighted in red on the Cross Arm tab. |
MMENG_LOADINGDISTRICTS
Field |
Data Type |
Description |
Units |
How Used |
---|---|---|---|---|
LoadingDistrict |
text |
This lookup table populates the Loading District field on the Transverse Pole Strength tab. |
|
The chosen value for a pole is used to retrieve the correct values from other MMENG tables. |
RadialIce |
double |
The amount of radial ice associated with the loading district. |
in. |
Not currently used. |
WindPressure |
double |
The amount of wind pressure associated with the loading district. |
lbs/sq. ft. |
Not currently used. |
Temperature |
double |
The temperature associated with the loading district. |
|
Not currently used. |
K |
double |
|
|
Not currently used. |
MMENG_NESCLEARANCE
Field |
Data Type |
Description |
Units |
How Used |
---|---|---|---|---|
ClearanceCategory |
text |
The NESC clearance category value. |
|
If NESC is selected as the Clearance Standard, this field is used to populate the Clearance Category field. |
NeutralWire |
float |
Clearance value of the neutral wire. |
feet |
Used to calculate clearance results. If the results are less than 0, the conductor fails and is highlighted in red on the Conductors grid. |
SecondaryWire |
float |
Clearance value of the secondary wire. |
feet |
Used to calculate clearance results. If the results are less than 0, the conductor fails and is highlighted in red on the Conductors grid. |
PrimaryWire |
float |
Clearance value of the primary wire. |
feet |
Used to calculate clearance results. If the results are less than 0, the conductor fails and is highlighted in red on the Conductors grid. |
MMENG_PINSTOCKNUMBER
Field |
Data Type |
Description |
Units |
How Used |
---|---|---|---|---|
Pin |
text |
The types of pins available for section on the Cross Arm tab (Figure 3). |
|
Not currently used. |
StockNumber |
text |
The stock number associated with the pin. |
|
Not currently used. |
MMENG_PINSTRENGTH
Field |
Data Type |
Description |
Units |
How Used |
---|---|---|---|---|
Pin |
text |
The types of pins available for selection on the Cross Arm tab (Figure 3). |
|
Used to populate the drop-down lists in the Pin fields on the Cross Arm tab. |
Description |
text |
A description of the pin. |
|
Used to populate the drop-down lists in the Pin fields on the Cross Arm tab. |
WorkingStrength |
long integer |
Rated breaking strength of the pin. |
ft.-lbs. |
Used when comparing the load of the wire/conductor to the strength of the pin(s). If the load of the conductor exceeds the strength of the pin(s), the field(s) are highlighted in red. |
MMENG_POLECLASSES
Field |
Data Type |
Description |
Units |
How Used |
---|---|---|---|---|
Class |
long integer |
This field populates the pole’s Class field (Figure 2). |
|
This value is used along with the Height and Material values to display the Maximum Resisting Moment of the pole. |
MinTopCircumference |
double |
|
in. |
Not currently used. |
MaxHorzLbs2ftFromTop |
double |
|
|
Not currently used. |
MMENG_POLECLASSTRANSLATION
Field |
Data Type |
Description |
Units |
How Used |
---|---|---|---|---|
EngPoleClassTranslation |
long integer |
Pole class in the engineering calculations tables. |
|
Used to auto-populate engineering data grids with geodatabase pole class. |
GeoPoleClassTranslation |
text |
Pole class in the geodatabase. |
|
Used to auto-populate engineering data grids with geodatabase pole class. |
MMENG_POLEHEIGHTSETDEPTH
Field |
Data Type |
Description |
Units |
How Used |
---|---|---|---|---|
Height |
long integer |
This field populates the pole’s Height field (Figure 2). |
ft. |
This value is used along with the Material and Class values to display the Maximum Resisting Moment of the pole. |
SettingDepth |
double |
The optimum setting depth for the height. The user may change the value in this field in the user interface. |
in. |
This value is used to calculate Total Bending Moment. |
Figure 2, Pole Properties
MMENG_POLEHEIGHTTRANSLATION
Field |
Data Type |
Description |
Units |
How Used |
---|---|---|---|---|
GeoPoleHeight |
text |
Pole height in the geodatabase. |
ft. |
Used to auto-populate engineering data grids with geodatabase pole height. |
EngPoleHeight |
long integer |
Pole height in the engineering calculation tables. |
ft. |
Used to auto-populate engineering data grids with geodatabase pole height. |
MMENG_POLEMATERIALTRANSLATION
Field |
Data Type |
Description |
Units |
How Used |
---|---|---|---|---|
EngPoleMaterial |
text |
Pole material in the engineering calculation tables. |
|
Used to auto-populate engineering data grids with geodatabase pole material. |
GeoPoleMaterial |
text |
Pole material in the geodatabase. |
|
Used to auto-populate engineering data grids with geodatabase pole material. |
MMENG_POLESETDEPTHADJUST
Field |
Data Type |
Description |
Units |
How Used |
---|---|---|---|---|
ModelName |
text |
Model name of device on pole. |
|
Used to adjust the setting depth of a pole based on the device. |
Description |
text |
Description of the device. |
|
Not currently used. |
SetDepthAdjust |
long integer |
The amount by which the depth of the pole will be adjusted. |
in. |
Used to adjust the setting depth of a pole based on the device. |
MMENG_POLEWINDMOMENT
Field |
Data Type |
Description |
Units |
How Used |
---|---|---|---|---|
Species |
text |
The species of wood used for the pole. |
|
Used to find the appropriate wind moment for a specific species, height, class, and loading district. |
Height |
long integer |
Height of the pole. |
ft. |
Used to find the appropriate wind moment for a specific species, height, class, and loading district. |
Class |
long integer |
Class of the pole. |
|
Used to find the appropriate wind moment for a specific species, height, class, and loading district. |
LoadingDistrict |
text |
The loading district of the pole. This field reflects the value chosen by the user in the Loading District field. |
|
Used to find the appropriate wind moment for a specific species, height, class, and loading district. |
WindMoment |
long integer |
The wind moment on the pole only. |
|
Used to calculate wind moment on the pole based on the loading district. |
MMENG_REACLEARANCE
Field |
Data Type |
Description |
Units |
How Used |
---|---|---|---|---|
ClearanceCategory |
text |
The REA clearance category value. |
|
If REA is selected as the Clearance Standard, this field is used to populate the Clearance Category field. |
NeutralWire |
long integer |
Clearance value of the neutral wire. |
ft. |
Used to calculate clearance results. If the results are less than 0, the conductor fails and is highlighted in red on the Conductors grid. |
SecondaryWire |
long integer |
Clearance value of the secondary wire. |
ft. |
Used to calculate clearance results. If the results are less than 0, the conductor fails and is highlighted in red on the Conductors grid. |
Primary1Wire |
long integer |
Clearance value of the primary wire. |
ft. |
Used to calculate clearance results. If the results are less than 0, the conductor fails and is highlighted in red on the Conductors grid. |
Primary2Wire |
long integer |
Clearance value of the primary wire |
ft. |
Used to calculate clearance results. If the results are less than 0, the conductor fails and is highlighted in red on the Conductors grid. |
MMENG_SOILCLASS
Field |
Data Type |
Description |
Units |
How Used |
---|---|---|---|---|
SoilClass |
text |
This field populates the pull down menu for the Soil Class field (Overcapacity Factors). |
|
Used to look up values associated with soil class codes. |
MMENG_SOILCLASSDESCRIPTION
Field |
Data Type |
Description |
Units |
How Used |
---|---|---|---|---|
SoilClass |
text |
Reflects the value chosen by the user in the Soil Class field. |
|
The value selected in the Soil Class field uses the MMENG_ANCHORTORQUES table to filter the list of available anchors. |
EngineeringDescription |
text |
Engineering description for the soil class. |
|
Used to display the engineering descriptions of soil classes by soil class codes. |
FamiliarName |
text |
|
|
Not currently used. |
MMENG_VOLTAGETRANSLATION
Field |
Data Type |
Description |
Units |
How Used |
---|---|---|---|---|
GeoVoltage |
text |
Voltage in the geodatabase. |
|
Used to auto-populate engineering data grids with geodatabase voltage. |
EngVoltage |
text |
Voltage in the engineering calculation tables. |
|
Used to auto-populate engineering data grids with geodatabase voltage. |
MMENG_WDSPCIESULTFIBERSTRESS
Field |
Data Type |
Description |
Units |
How Used |
---|---|---|---|---|
Species |
text |
Populates the pole’s Material field (Figure 2). |
|
This value is used along with the Height and Class values to display the Maximum Resisting Moment of the pole. |
Abbrev |
text |
Code used to identify the wood species. |
|
Used to look up values for maximum resistance moment calculations. |
UltimateFiberStress |
double |
|
lbs./sq. in. |
Not currently used. |
MMENG_WOODPOLERESISMOMENT
Field |
Data Type |
Description |
Units |
How Used |
---|---|---|---|---|
Class |
long integer |
The value selected in the pole’s Class field. |
|
Used to calculate the Maximum Resisting Moment of the pole. |
Height |
long integer |
The value selected in the pole’s Height field. |
ft. |
Used to calculate the Maximum Resisting Moment of the pole. |
Species |
text |
The value selected in the pole’s Material field. |
|
Used to calculate the Maximum Resisting Moment of the pole. |
MinCircumferenceAtSixFeet |
double |
|
in. |
Not currently used. |
ResistingMoment |
long integer |
Resisting moment of the pole by height, class, and species. |
ft.-lbs. |
Used to display resisting moment of the pole. Also used in deflection and buckling calculations. |
HTABVGND |
double |
Height of the pole above ground. |
|
Not currently used. |
CIRCTOP |
double |
Circumference of the pole top. |
|
Used in pole top deflection and buckling calculations. |
CIRCGND |
double |
Circumference of the pole at the ground. |
|
Used in pole top deflection and buckling calculations. |
MMENG_XARM
Field |
Data Type |
Description |
Units |
How Used |
---|---|---|---|---|
DisplayName |
text |
The name of the configuration as it appears in the Cross Arm Configuration field (Figure 3). |
|
Used to populate the drop-down list of the Cross Arm Configuration field on the Cross Arm tab. |
Code |
text |
A unique code that identifies the cross arm configuration. |
|
Used in cross arm strength calculations. |
BendStress |
double |
Maximum bending stress for the cross arm. |
|
Used to calculate the maximum moment on the cross arm. |
DimV |
double |
Vertical dimension of the cross arm. |
|
Used to calculate the maximum moment on the cross arm. |
DimH |
double |
Horizontal dimension of the cross arm. |
|
Used to calculate the maximum moment on the cross arm. |
BoltDiam |
double |
Bolt diameter for the cross arm. |
in. |
Used to calculate the maximum moment on the cross arm. |
MMENG_XARM_CONFIG
Field |
Data Type |
Description |
Units |
How Used |
---|---|---|---|---|
DisplayName |
text |
The name of the configuration as it appears in the Cross Arm Configuration field (Figure 3). |
|
Used to populate the drop-down lists of the Cross Arm Configuration field on the Cross Arm tab. |
Code |
text |
A unique code that identifies the cross arm configuration. |
|
Used internally to associate cross arm values to a cross arm configuration. |
ImageName |
text |
The name of the image associated with the selected configuration. |
|
Used to display the graphic that corresponds with the selected cross arm configuration. If an image name is listed Designer will attempt to load it from <ArcFM install directory>\Program Files (x86)\Miner and Miner\ArcFM Solution\bin\Graphics. If a path and name is provided, Designer will load the image from that location. If no image name appears or the image name is invalid, or the image path is invalid, Designer will load a default image. |
NumWires |
short integer |
The number of wires associated with the configuration. |
|
Used to automatically associate a conductor to a pin position. |
DeadEnd |
short integer |
This field indicates whether the configuration is a dead end. A value of 0 indicates it is NOT a dead end. Any other value indicates that it is a dead end. |
|
Used to calculate moments on the cross arms in transverse and dead end cases. |
CondAtt1 |
double |
Attachment height of conductor #1. |
|
Used to determine the actual moment on the cross arm. |
CondAtt2 |
double |
Attachment height of conductor #2. |
|
Used to determine the actual moment on the cross arm. |
CondAtt3 |
double |
Attachment height of conductor #3. |
|
Used to determine the actual moment on the cross arm. |
CondAtt4 |
double |
Attachment height of conductor #4. |
|
Used to determine the actual moment on the cross arm. |
Figure 3, Cross Arm Configuration