×
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

Northing, Easting, Elevation Values for Weight Control Report

Northing, Easting, Elevation Values for Weight Control Report

Northing, Easting, Elevation Values for Weight Control Report

(OP)
I am building an Access Database and having problems calculating the northing, easting, and elevation values. First I'd like to say that I'm not a Structural person at all. I was provided some information and am to create a database showing various info and also print out reports. Without getting into the details of the database itself, all I need to know is how the values enclosed in the red box in the attached document are found.
http://files.engineering.com/getfile.aspx?folder=0...

Below is an example of what I was trying to do. This example is for INPLACE only.

INPLACE = AI + AL
Under TIME, there are no AI's and 4 AL's. I sum the NOTHING AL's to get 1380.638. I then divide by 4 to get an average and get 345.160. I do the same procedure for EASTING and ELEVATION: EASTING = 744.896 ELEVATION = 66.572

As can be seen, the NORTHING and EASTING values come close, but not the ELEVATION. I have no idea if I am doing this correctly. Is there a formula to calculate this that I should be using.

If this type of report looks familiar to you guys, I would greatly appreciate any help you could provide!!!

THANK YOU.

RE: Northing, Easting, Elevation Values for Weight Control Report

I know nothing about what you're doing, but I notice that the INPLACE data (three values) all have the same elevation, hence the result is the same as the data.

oh, I see your problem ... there are four AL data ... one has zero weight (?). and this throws off the simple average you're calculating.

I think making simple average (sum data/number of data) is too crude. I suggest a weighted (no pun intended) average = sum(weight*elev)/sum(weight). maybe?

another day in paradise, or is paradise one day closer ?

RE: Northing, Easting, Elevation Values for Weight Control Report

(OP)
Thanks rb1957!!
You were correct. I needed to use weighted avg. I really appreciate you're help. Thanks again!

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