Excel expert required to finish daily data dashboard

Job ID: 34342533

Budget: $30 – $250 AUD

The bare bones of the dashboard is in place, I just need someone to finish the formulas to pull the data from the input sheet based on date and shift. I've placed notes on each cell.