GPL Tools Development

GPL ToDo List:

• https://docs.google.com/document/d/1HhAqyH3GQfnbG4RMWzrn4EVp0kKBPqR4OKzqxmKiWZ8/edit?usp=sharing 

GPL Google Doc Index

• https://docs.google.com/document/d/1fSje-T7zhsae6zcgIpqlJBa1JQ7MYiXYPv3LXPdmE8g/edit?usp=sharing

• GPL Data Index: https://docs.google.com/spreadsheets/d/1mi7Y6QzFN3dqSE60WAN5K0UsVa2cCkopYQF8a-nTqiM/edit?usp=sharing

  • Tracking all Google Sheets based data set files called GSS. 

• GPL Account Lookup: https://docs.google.com/spreadsheets/d/1VJtLPEtPnemTwi9MVyyqr-R9P6Gx7ihK2E4TmodIwWE/edit?usp=sharing

  • Mapping table with an account number from all data source for searching for a corresponding property and OG group. 

  • Create a local ByAcct sheet using "ByAccount" sheet from this GSS: 

    • BOA Bank Data: https://docs.google.com/spreadsheets/d/1UgFHrznQTIgDfiJKD2joi6QB-i3pSem-bcCoURe4QhU/edit?usp=sharing

    • or WF Bank Data: https://docs.google.com/spreadsheets/d/1NF4iazbmCNsAGcaT7D34--sxltOb77umLUtmLcb7o-U/edit?usp=sharing

    • ByAcct Sheet

• GPL Lease: https://docs.google.com/spreadsheets/d/1PpbM5wMI-l_7awBIc2-kMcDwJqZnUi-d0FkL5iXGN0Y/edit?usp=sharing

  • Controls Lease Terms for Tenants with rent, utilities, pet fees,HAP payment, and some adjustment proration, credits, penalties etc

• GPL Data Feeds and Integration Folder:

  • Rent Data Folder: https://drive.google.com/drive/folders/1AqiCe5D7vMS3Cug4X8qcSU8IMJXwl2Vq

  • Utils Data and HOA Folder: https://drive.google.com/drive/folders/1gJ9fPZYGIdr3NlTwWWryxe3Zxcjo-agB

  • 
    

• End

• Aggregate All Utilities: https://docs.google.com/spreadsheets/d/1Ov0TVw4PeooBiF_Pibnf2zZqpNQs1BRony_lnaFN2fE/edit?usp=sharing

  • Consolidate utilities from Vendor's website

  • Add Utilities records from GPL Data Sets

• GPL Rent Payment: https://docs.google.com/spreadsheets/d/16Axn1krV9qVSE-CdJwYsCIyg8DWDq5Vc8_f_rliDDT4/edit?usp=sharing

  • Compare Rent Payment vs Lease with balance calculated. The goal is to zero balance.

  • Input: "GPL Rent Aggregate" and "GPL Lease"

  • Output: "DuePay" Sheet => "PVT Rent Pmt All"

  • Starting date is specified such as 2023-01-01

• GPL Rent Aggregate: https://docs.google.com/spreadsheets/d/18ER1qkyL4V58fMnGeRk_woj4P9TEZ3iT7f8D5XpWlJg/edit?usp=sharing

  • Aggregate the Rent data from all data sources and support "GPL Rent Payment:" above

• End

• Google Sheets Function List: https://support.google.com/docs/table/25273?hl=en&ref_topic=3105704&sjid=12250381782103129961-NC#

• 
  
• 
  

• Use the followings as renter's portal template:

• 4922 Copperlyn Renter's Ledger: https://docs.google.com/spreadsheets/d/16cYcZd_z4IOSIpkREm3AGtLykUXrJG53kss8dimkOhM/edit?usp=sharing

• 4922 Copperlyn Renter's Stmt: https://docs.google.com/document/d/1wIpMzOhmO-G76EXYV72grRB3Iga-8UKm0BWYSqHkRpE/edit?usp=sharing

• 856 Raysilva Renter's Stmt: https://docs.google.com/document/d/1R2sBTjSino0T07iStKEL9dp-EimA9lYTia6SHzfNejI/edit?usp=sharing

• RentStmt_856Raysilva_TiffanyFountain.doc

• https://docs.google.com/document/d/1R2sBTjSino0T07iStKEL9dp-EimA9lYTia6SHzfNejI/edit?usp=sharing

• 
  

• Renter_856Raysilva_TiffanyFountain

• https://docs.google.com/spreadsheets/d/19HicytvKHssqqcSUMyu189Bjz6ogTsTQzeJwj-OAFA0/edit?usp=sharing

• 
  
• 
  

• 1213 Jimmy Renter's Ledger: https://docs.google.com/spreadsheets/d/1OQ9O6VCAerTc7_zJsw-IlSl8i8HUgeLhKn0mf_s3jKo/edit#gid=761558402

• 1213 Jimmy Renter's Statement: https://docs.google.com/document/d/1JB0cGbgefKC7nm_YQ87v0sFk1eZpStzIFDgOcN66Qqk/edit

•