Google Sheets Tool Development
Budget: ₹750 – ₹1,250 INR
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
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
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