Spreadsheet: 794322d1661979020-8x8-matrix-8x8-matrix
Sheet: Sheet1

 |  |  |  |  | Measured from front wheel |  |  |  | Measured from 2nd wheel |  |  |  | Measured from 3rd wheel |  |  |  | Measured from 4th wheel
 | Wcg | 145.64 | lbs |  | Eq1 |  |  |  | Eq2 |  |  |  | Eq3 |  |  |  | Eq4 |  |  |  |  |  | Matrix of CG equations |  |  |  |  |  |  |  |  | result
 | Dcg | 170 | in |  | Dcg |  | D |  | Dcg |  | D |  | Dcg |  | D |  | Dcg |  | D |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8
 |  |  |  |  |  |  | equation constant |  |  |  | equation constant |  |  |  | equation constant |  |  |  | equation constant |  |  | 1
 |  |  |  |  | W1 |  | 0 |  | W1 |  |  |  | W1 |  |  |  | W1 |  |  |  |  | 2
 | D1 | 90 |  |  | [NAME] |  |  |  | [NAME] |  | 0 |  | [NAME] |  |  |  | [NAME] |  |  |  |  | 3
 | D2 | 71 |  |  | W3 |  |  |  | W3 |  |  |  | W3 |  | 0 |  | W3 |  |  |  |  | 4
 | D3 | 74 |  |  | W4 |  |  |  | W4 |  |  |  | W4 |  |  |  | W4 |  | 0 |  |  | 5
 | D4 | 72 |  |  | W5 |  |  |  | W5 |  |  |  | W5 |  |  |  | W5 |  |  |  |  | 6
 | D5 | 73 |  |  | W6 |  |  |  | W6 |  |  |  | W6 |  |  |  | W6 |  |  |  |  | 7
 | D6 | 72 |  |  | W7 |  |  |  | W7 |  |  |  | W7 |  |  |  | W7 |  |  |  |  | 8
 | D7 | 73 |  |  | W8 |  |  |  | W8 |  |  |  | W8 |  |  |  | W8
 |  |  |  |  | Measured from 5th wheel |  |  |  | Measured from 7th wheel |  |  |  | Measured from 7th wheel |  |  |  | Measured from 8th wheel |  |  |  |  |  |  |  | Inverse Matrix |  |  |  |  |  |  |  |  | Should be equal to
 | Known weights |  |  |  | Eq5 |  |  |  | Eq6 |  |  |  | Eq7 |  |  |  | Eq8 |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8
 |  |  |  |  | Dcg |  | D |  | Dcg |  | D |  | Dcg |  | D |  | Dcg |  | D
 |  |  |  |  |  |  | equation constant |  |  |  | equation constant |  |  |  | equation constant |  |  |  | equation constant |  |  | 1 |  | 3127499741229.562 | -30395388110074.42 | 32643278549083.15 | -51212808262633.19 | 4691249611844.312 | 781874935307.3677 | 20051927358753.35
 | W1 | 18.78 |  |  | W1 |  |  |  | W1 |  |  |  | W1 |  |  |  | W1 |  |  |  |  | 2 | 170554475173973.3 | -73496243918893.42 | 56783667176698.36 | -120604208771163.1 | -124709052181526.4 | -75059993789508.1 | -71150619112971.28 | 237681975423390.2 |  |  | 1572864
 | [NAME] | 18.54 |  |  | [NAME] |  |  |  | [NAME] |  |  |  | [NAME] |  |  |  | [NAME] |  |  |  |  | 3 | 170091307355153.2 | -70368744177663.8 | 35184372088831.87 | -70368744177663.6 | -140737488355327.9 | -140737488355327.9 | 0 | 216936785621997.9 |  |  | 1310720
 | W3 | 19.26 |  |  | W3 |  |  |  | W3 |  |  |  | W3 |  |  |  | W3 |  |  |  |  | 4 | -765544918801384.6 | 316659348799487.2 | -158329674399743.5 | 387028092977150.9 | 633318697598974.6 | 422212465065983.1 | 140737488355327.8 | -976081499595795.2 |  |  | 1048576
 | W4 | 15.96 |  |  | W4 |  |  |  | W4 |  |  |  | W4 |  |  |  | W4 |  |  |  |  | 5 | 770035114858435.1 | -351843720888319.1 | 263882790666239.3 | -527765581332478.7 | -562949953421310.4 | -422212465065982.8 | -140737488355327.6 | 971591303538743.8 |  |  | 0
 | W5 | 17.22 |  |  | W5 |  | 0 |  | W5 |  |  |  | W5 |  |  |  | W5 |  |  |  |  | 6 | -648598767763266.8 | 281474976710655.2 | -228698418577407.4 | 457396837154814.9 | 492581209243646.6 | 351843720888318.9 | 140737488355327.7 | -846737046012088.8 |  |  | 0
 | W6 | 17 |  |  | W6 |  |  |  | W6 |  | 0 |  | W6 |  |  |  | W6 |  |  |  |  | 7 | 19435176963354.82 | 0 | 0 | -35184372088832 | 0 | 0 | 0 | 15749195125477.18 |  |  | 0
 | W7 | 18.96 |  |  | W7 |  |  |  | W7 |  |  |  | W7 |  | 0 |  | W7 |  |  |  |  | 8 | 263715246037244.8 | -105553116266495.7 | 61572651155455.81 | -123145302310911.6 | -246290604621823.5 | -140737488355327.6 | -70368744177663.89 | 360807358539521.6 |  |  | 0
 | W8 | 19.92 |  |  | W8 |  |  |  | W8 |  |  |  | W8 |  |  |  | W8 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Identity matrix
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Test matrix
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  | -87 | -70 | -52 | -36 | -17 | 0.75 | 19.09375 |  |  |  | 2 | 1 | 3 | -2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 144 | 96 | 80 | 56 | 24 | 4 | -38 | -62 |  |  |  | 4 | 3 | 1 | -1 |  |  | -6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 112 | 96 | 80 | 72 | 72 | 36 | 34 | 20 |  |  |  | 1 | 1 | 1 | 1 |  |  | -2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 0 | -64 | 0 | 32 | 32 | 48 | 96 | 118 |  |  |  | -2 | -2 | -2 | 2 |  |  | -5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 64 | 0 | -64 | -32 | -96 | -48 | -128 | -78 |  |  |  |  |  |  |  |  |  | -10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | -64 | 0 | -64 | 0 | 32 | 48 | 96 | 34
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 | 0 | 0 | 0 | 0 | 0.5 | 0.5 | 0.75 | 0 |  |  |  |  | Inverse matrix
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | 0 | 0 | 16 | 0 | -16 | -8 | -16 | -32 |  |  |  |  | 0.5 | -0.25 | 0.875
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -0.75 | -0.25 | 0.375 | -1.0625
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.25 | -0.25 | 0.375 | -0.0625
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0.5 | 0.25
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Idetity matrix
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 1 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 1 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 1