GPL Data Integration

Initiative

• Such as Rent Collection

• Utility Expenses

• Invoices management

• Owner's Payouts

• via Applications

Applications

• Forms for data entries

• Google Spreadsheet based database

Data Aggregation

Raw Data Feeds

ok

GPL Bank Raw Data => Rent Combined Data => GPL Rent Aggregate

GPL Bank Raw Data => Rent Combined Data => GPL Rent Aggregate + GPL Lease => GPL Rent Payment

"GPL Rent Payment"::"PVT Rent Pmt All"

• "GPL Rent Payment"::"Due Pay" Range:A2:F including column labels

  • "GPL Rent Payment"::"GRent" Range A3:F

  • D10:B10 "GPL Lease"::"MonthlyDue" Range A3:F with no column labels

• "GPL Rent Payment"::"Due Pay" Range:A2:F including column labels

  • D11:B11 "GPL "Rent Aggregate"::"Aggregate" Range A3:F with no column labels

  • Formula: A3 and C3

OK