tongue weight : real wt. vs. projected weight

From day one 'til now, I've been a great fan of Angib's works on behalf of TnTTT members. His design portfolio, comments, new ideas, and especially his files on tongue strength and my favorite: Trailer Balance. I've gone overboard on manipulating figures to try to get a perfect balance, using his basic formulae and my alterations. I guided my whole build on the projected results, not having actual weights or placement of items ready at hand.Here's an earlier post of mine that shows what I was trying to do: http://www.tnttt.com/viewtopic.php?f=21&t=48615&hilit=tongue+weight+balance. Now, having finished my build, and envious of those that started their builds about the same time as myself (but have already taken them out), I packed the trailer as if I were to travel with it (simulated ice chest containing cinder blocks, not withstanding). I then got the bathroom scale out, and measured the tongue weight using this method . Perhaps not the most accurate way to do it, but the only way I can do it in my limited garage bay space. On first weighing it, I got only 30lbs tongue weight, which was quite a shock!. I then went over the trailer, moved a water jug from the rear to the front
, lightened the fuel by one gallon (too heavy for my wife to pour anyway), and added the extra balancing weights (2x15lb barbell weights) I had initially planned to use on the tongue .
(didn't actually think they'd be needed), then checked it for front to rear level and side to side level, and inflated the tires to the same pressure (tires were not the same, after 6 months, so the trailer wasn't level)...that helped. With the re-leveled and re-balanced trailer, the measured tongue weight came to exactly 100 lbs (my goal from the start). Whether or not that is really accurate, I don't know, but it feels like 100 lbs when I lift it (much better than the 30 lbs at first try). If the weighing method is in the ballpark, then can I assume that the total trailer weight is around 1000 llbs, as the described method suggests? I don't remember where I found that method, but it seems to work. And as to my using Andrew's balance equation, somewhere I put weights in wrong, or was adding weights that are already included, as Andrew suggested in the earlier post, well anyway, my latest balance sheet appears to be wrong, I hope, that my tongue/(trailer wt. inferred) weights are as measured, not as my mishandling of Andrew's spreadsheet indicates. I re-did my latest version (to reflect the re-balancing I did this afternoon), condensed it to fit this forum's sizing limitations, and included (in the lower right hand portion) the weight of the trailer when last weighed plus my best guess of the added weights (400lbs less the 12lb jack plus added weight of 601.5lbs). Also shown is the tongue weight as measured. If you compare those figures to the spreadsheet, then you'll see that somewhere I really goofed, and Andrew was correct about my over-elaboration. Here it is: I would like your feedback on this, especially from Andrew, to see where my data/plans went awry.