Staff Selection & Activity Locator Google sheet

Заказчик: AI | Опубликовано: 17.02.2026

i would like to build something to help us choose the staff we want to use.. when we get a package we get the post code of the child sent to us. we record all our staff information on 'my maps'. we would like to put the location into an app or something and for it to tell us the following information we would enter the childs post code and from this we will see- the ten closest staff memeber by mile to child postcode each staff member will show – name/post code/distance to child/phone/email/skillset/qualifications/packages covered. Using maps for sheets for data We also want to see the closet large towns around essex uk to the child postcode as this is where we would take the child when covering the package – the towns we would call the largest towns are – Southend, Basildon, Brentwood, Harlow, Loughton, Bishops Stortford, Saffrom Walden, Braintree, Chelmsford, Colchester. We would like to see which is the closest town and a list of activities in that town(data from google places) We would then like to see the price per hour we would be able to offer to cover that package. The price would be worked out as follows- We pay our staff £14 per hour. We do not pay trave lexpenses to and from the package unless they live further than ten miles away then we would pay £5 per day of travel not per hour but per day but staff under ten miles from child post code do not get travel to work expenses. We also pay for tavel on the job – this would be worked out by the distance from the childs postcode to the center of the largest town and back again plus 5 miles to travel around the town. Milage on the job will be calculated at 35 pence per mile. We want t make a profilt of £5 per hour on each job Some jobs may be 2 hours a day for 5 dyas , some may be 6 hours a day 3 days a week so to work out hourly rate - New hourly rate we would charge would be £14 hourly rate we pay plus £5 minimum profit (times the amount of hours on the job ) plus travel to work at £5 per day if travelling over 10 miles (times the amount of days) or no travel to work if under 10 miles. Plus expenses on the job (child post code to nearest town and back plus 5 miles). Once you have added these up then divide by total hours to get new hourly rate . We would like to see two rates – the lowest rate based on using closest staff member (wether we have £5 a day travel or not ) then an average rate say for example if it was 5 days a week and some days had travel by staff under ten miles and other days covered by staff we pay £5 travel to. We would also like to see a breakdown of expenses ie – expenses on the job – to and from expenses I would like to keep it simple to start with using google sheets I think I will need 4 sheets for data an to show results, staff date- control (data input) one for the towns and one for the expenses. i have some of these sheet on csv already Would you be able to help me build this