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