Google Sheets Tool Development

I would like a Google Sheets based tool where: You enter the child’s postcode in a control sheet. The system shows the 10 closest staff members based on distance from that postcode, including: Name Postcode Distance to child Phone Email Skillset Qualifications Packages covered The system identifies the closest large town (from your predefined Essex towns list) to the child’s postcode. It calculates the pricing as follows: £14 per hour staff wage £5 per hour profit £5 per day travel to work if staff live more than 10 miles away or £0 travel if under ten miles On-job mileage calculated from child postcode to nearest large town and back, plus 5 additional miles Mileage charged at £0.35 per mile Total cost divided by total job hours to produce the final hourly rate I would like to see: The lowest possible hourly rate (using the closest staff member) An average rate example (mix of ten closest staff under and over 10 miles) A clear breakdown of: Travel to work costs included On-job mileage expenses Total expenses Final calculated hourly rate and average hourly rate The system will be structured across 4 sheets: Staff Data Towns Control (input + results) Expenses

Mã dự án: 40239515