mjncad
Super Member
Very ambitious project, and I'm glad it's working as you had hoped it would.
I see you also have toolboxes under the bed, in front of the rear wheels... how much do you want to store ??![]()
Now the big question, does anybody have a spreadsheet to calculate all these numbers. I will be building a dump trailer next summer and it would be nice to have a spreadsheet that one just need to fill in the values and get the results.
Eric
It would be a lot more fun to have you post a new thread and let LD1 and I dicker over the details again.
I don't have any spreadsheet created, but it should be a big deal to do it. What specifically are you going to want to know?
Now the big question, does anybody have a spreadsheet to calculate all these numbers. I will be building a dump trailer next summer and it would be nice to have a spreadsheet that one just need to fill in the values and get the results.
Eric
Might I offer a suggestion for the spreadsheet.
Personally I still dont like the torque calculations. Too much work for the same end result IMO. But there is more than one way to skin a cat
Anyways, I dont like having to input the max load and having to look at the "torque needed" and "torque avaliabe" to know wether it will dump.
Instead, I like the "max load" to be what is solved for instead of inputed. And with all the other info you provided, it is very easy.
Your spread-sheet is read onlybut the formula for "max dump" would be...
=(C29/((C26/2)-C27))*G19)
If you so choose![]()
If you want to change anything on the spreadsheet just unprotect the sheet. There's no password on it. I protected the sheet to make it more clear to a user where the inputs were vs. the results. If that doesn't fix the problem, it may be due to some security setting on your computer as it was downloaded from the internet. "Save As" may solve that problem.
I added a section for the Max Dump calculation using your formula (I had to add a parenthesis). I can see how that could be useful.