Create a Google Spreadsheet that automates a variety of functions based on data. This spreadsheet will be used to track sales for a Real Estate Company. Data that will be manually entered will include the address/client name, sales price, total commission, contract month, closing month, closed - yes or no, & lead source.
Automated tasks to be performed include:
1) Create a Sheet of all Closed Data
2) Create a Sheet of all Pending Data, sorted by Date
3) Create a Summary Page that includes a summary of data:
Total Closed Commission (Year and by Month), Total Pending Commission (Year and by Month), Total Number of Referrals by Vendor, Total Number of Contracts (Month & Year), Total Number of Buyer Contracts (Month & Year) & Seller Contracts (Month & Year), Calculate Percentage of Sells in Greater Madison Area, & Total Number of Sales Per Form of Advertising.
4) Create Agent Commission Worksheet - Break it down by agent & Month/Year