Northing, Easting, Elevation Values for Weight Control Report

[centaur_15]

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=0ee64812-c3ca-4911-a1bc-fc3313d045df&file=WCR.pdf

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.

 

[rb1957]

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 ?

 

[centaur_15]

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