vehicle dynamics week 3 set 3

Please note:
Front Ride Rate: 200 lb/in
Rear Ride Rate: 250 lb/in
1,Calculate the following parameters:
(i) Roll moment (ft-lb/g)
(ii) Roll gradient (deg/g)
(iii) Load transfer due to roll or elastic component (lb/g)
(iv) Front roll stiffness (ft-lb/deg) at wheel center level (hint: isolate the tire contribution)
(v) Front anti-roll spring rate (lb/in) for one wheel jounce
(vi) Front anti-roll spring rate (lb/in) for roll
( vii) Front anti-roll bar stiffness (ft-lb/deg)
(viii) Auxiliary roll stiffness (%)
please see the following excel file:
https://drive.google.com/file/d/18zi4CKfUYc--SU8nAuXfl_eCoJip9HUY/view?usp=sharing