Vacation Accrual Spreadsheet Tracker

Hello,

I need help building a vacation tracker for my company. i have created a spreadsheet with all the columns i need. now i need the columns to read from each other. if that makes any sense.

Here is the vacation policy

0-2 years of service- accrue .77 weekly
3-4 years of service- accrue 1.54 weekly
5+ years of service- accrue 2.31 weekly

We are allowed 40 hours rollover.

I need the following to reflect:
Column B to read to Column C & D & E- the start will reflect the correct amounts
Column F will be put in by myself
Column F needs to read to column T - (Added in to balance)
Column G-R needs to read to Column S
Column S needs to be subtracted from Column T
Column S needs to have the yearly allotment & rollover amount


I hope that makes sense

Please help!

I have attached the spreadsheet with the columns