Complicated but interesting.....Need some thoughts

[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.

[rsocor01]

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.

Well, If I underestand your question correctly, then just some more code like this would do the job.

IF (Radius < Radius_Min) or (Radius > Radius_Max) then DoSomething
IF (Boom < Boom_Min) or (Boom > Boom_Max) then DoSomethingElse

[Megahertz]

Robert Thanks, but I do not see this to be this easy because once the radius and boom will change the weight could change drastically from one column to another in some cases. So something which kind of predicts 3-4 steps ahead of the limit being reaching would work better, but can't imagine clearly on how to start something like that.