Back to search:
Freelance Google / Hong Kong
Freelance Job: Google Sheets Formula Expert
Hong Kong
Published on www.peopleperhour.com
28 Mar 2025
Hello,
**** UK & English Speaking ONLY ****
I need a spreadsheet to work out how many letters someone is able to send based on the number of hours they have available each week derived from two scenarios:
Ball Park Offer Strategy (100 Letters / 15 Responses)
Average response rate from 100 letters sent is 15
10% of initial responses say no (15% of 15 letters)
Each of the 2.25 responses would required:
Initial Call - 15 Minutes
Site Check - 20 mins
Quick Fire Appraisal - 45 mins
Ball Park Offer to Landowner - 20 Mins
(1hr 40mins)
Of the Ball Park Offers Presented, 50% continue further to an appraisal which requires:
Round #1 of Detailed Appraisal Work - 2hrs
Creating Offer Letter - 30 mins
Presenting Offer - 30 mins
(3hrs)
-
No Ball Park Offer Strategy (100 Letters / 15 Responses)
Average response rate from 100 letters sent is 15
10% of initial responses say no (15% of 15 letters)
Each of the 2.25 responses would required:
Initial Call - 15 Minutes
Site Check - 20 mins
Quick Fire Appraisal - 45 mins
(1hr 20mins)
After Quick Fire Appraisal, 75% of sites continue to next stage:
Round #1 of Detailed Appraisal Work - 2 hrs
Creating Offer Letter: - 30 mins
Presenting Offer - 30 mins
_______________________________________
It will look something like this:
https://docs.google.com/spreadsheets/d/1IOvPJ1yMwnZS4f9QqVH2ryg7ZSpXCl4obegowIqmzXA/edit?usp=sharing
View all