Complicated but interesting.....Need some thoughts

[ScaleRobotics]

Here's one way to do it.

You could have 5 lookup tables. One for each boom length. Say the boom is between 10 and 12 meters extended, so in between the values of your chart... For example the boom is at 10.5 meters, and radius is 5 meters. Do the lookup for the nearest known values, so lookup for the 10 meter, and the lookup for the 12 meter boom extension.

4760 at 10 meter extension
4000 at 12 meter extension

Difference between the two extensions is 12 - 10 = 2 meters. We are at .5 meters over 10, so 1/4 the difference. The difference in load is 760 for the two lengths. So 1/4 of 760 = 190.

4760 - 190 = 4570

load at 10.5 meter boom extension, at 5 meter radius = 4570

If you had a radius that was in between two numbers on the load chart, you could do similar lookups on the two radius's which the actual radius is between. Then do similar math.

[rsocor01]

How accurate do you need the data to be? From your table for each column you can approximate and find a formula. The results can be very close to what you have. The formulas are very easy to get using Excel.

Robert

[Megahertz]

Thanks for the replies.

Scalerobotics, could you explain with a little code snippet for my better understanding please.

Robert, I want them to be as accurate as practically possible. Of course I understand there is always a slight margin of error but lets see how this one goes. I knew that you can put formulas in Excel and get values but didn't knew that by putting values one can come up with formulas as well, so could you please explain more how to do it.

[rsocor01]

Robert, I want them to be as accurate as practically possible. Of course I understand there is always a slight margin of error but lets see how this one goes. I knew that you can put formulas in Excel and get values but didn't knew that by putting values one can come up with formulas as well, so could you please explain more how to do it.

Very easy . Using data from your table and the column for Length = 13.85m,




First, plot the data as a X-Y graph. Then goto Charts -> Add Trendline. I chose a second degree polynomial for the approximation since it's clearly not a stright line. R^2=0.9993 refers to how close to been perfect is the line fitting approximation (R^2=1 is perfect).

Robert

[Megahertz]

I will work with what I have got. Will report back very soon. Thanks for the help

[Megahertz]

ScaleRobotics, please could you help me get started with the coding side, I want to try your approach as well and see how it goes but though I understand what you meant above but I need help as to how I should approach it from the coding point of view. Thanks

[Megahertz]

Very easy . Using data from your table and the column for Length = 13.85m,

First, plot the data as a X-Y graph. Then goto Charts -> Add Trendline. I chose a second degree polynomial for the approximation since it's clearly not a stright line. R^2=0.9993 refers to how close to been perfect is the line fitting approximation (R^2=1 is perfect).

Robert

Robert, I also tried your method and found formulas for all the columns. Now I am trying to implement them, and I am facing a problem with calculations. For example formula for my first column comes to be :

y = -875x^2 + 4375x + 2250
R² = 1

Now my x is the radius. While calculating on excel sheet I just put 2,3,4 as radius values and their corresponding load in front. Now my actual radius is in centimeters. How do I calculate if I want for example 215 centimeters) OR (264 centimeters)? Should I make a new graph with radius in centimeters all the way from 200 to 400 or is there a better way to do it?

[rsocor01]

Hmm, just a quick look. You can use the same formulas. The "in-between" values will be found in the formula by interpolation. But, if you use cm you might need to declare your variables as LONG instead of WORD

[Megahertz]

Thanks guys for your replies. It has surely helped me upto now and I have made the software reliable enough to pick the correct MAX safe weight from the chart. Without the above examples my task would have been much more harder. My next task is to monitor the radius and boom so that the ACTUAL lifted weight stays within the safe parameter. I would appreciate your thoughts on accomplishing this next next task. Please let me know if you need more explanation on this.

[Megahertz]

Here's one way to do it.
4760 at 10 meter extension
4000 at 12 meter extension

Difference between the two extensions is 12 - 10 = 2 meters. We are at .5 meters over 10, so 1/4 the difference. The difference in load is 760 for the two lengths. So 1/4 of 760 = 190.

4760 - 190 = 4570

load at 10.5 meter boom extension, at 5 meter radius = 4570

It has been some time with this project and I have been able to reach to some solid ground in picking up weights using the correct radius using graphs. The two weights I get are correct. I am a little stuck with the calculation as you advised above for averaging. I have written a routine to do the calculations between the two weights as above but I am not sure if it is entirely correct as the results are not satisfactory:

	If (wWeight1>wWeight2) then
			wTemp=((wBoomDiff*100)/bBoom_Jump)                 ; Boom Diff can be from 1 to 206. Boom jump can only be 200 or 185 or 207
			wDummy=wTemp * (wWeight1-wWeight2)               ; Bit confused as this can result in 32 bit result or not, so not sure how to implement DIV32 here
			wSafe=wWeight1-wDummy
		Else
			If (wWeight2>wWeight1) then                                ; Same confusion as above
				wTemp=((wBoomDiff*100)/bBoom_Jump)
				wDummy=wTemp * (wWeight2-wWeight1)
				wSafe=wWeight1 +wDummy
			Else
				wSafe=wWeight1
			Endif
		Endif