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.
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
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
You were correct. I needed to use weighted avg. I really appreciate you're help. Thanks again!