Spreadsheet: 154904d1336594418-analyse-date-frequency-cross-referencing-multiple-date-ranges-pastrentalsummarydataexamples
Sheet: Properties

Alt Name | Managed | Start Date | End Date
House001 | 0 | 00:00:00 | 00:00:00
House002 | Yes | 2003-01-01 00:00:00 | 2011-03-31 00:00:00
House003 | Yes | 2005-01-01 00:00:00 | 2007-09-30 00:00:00
House004 | 0 | 00:00:00 | 00:00:00
House005 | 0 | 00:00:00 | 00:00:00
House006 | Yes | 2003-01-01 00:00:00 | 2008-02-21 00:00:00
House007 | Yes | 2003-05-15 00:00:00 | 2007-10-23 00:00:00
House008 | 0 | 00:00:00 | 00:00:00
House009 | 0 | 00:00:00 | 00:00:00
House010 | Yes | 2005-01-01 00:00:00 | 2005-02-01 00:00:00
House011 | Yes | 2003-12-01 00:00:00 | 2007-06-09 00:00:00
House012 | 0 | 00:00:00 | 00:00:00
House013 | 0 | 00:00:00 | 00:00:00
House014 | 0 | 00:00:00 | 00:00:00
House015 | 0 | 00:00:00 | 00:00:00
House016 | 0 | 00:00:00 | 00:00:00
House017 | 0 | 00:00:00 | 00:00:00
House018 | 0 | 00:00:00 | 00:00:00
House019 | 0 | 00:00:00 | 00:00:00
House020 | 0 | 00:00:00 | 00:00:00
House021 | 0 | 00:00:00 | 00:00:00
House022 | 0 | 00:00:00 | 00:00:00
House023 | 0 | 00:00:00 | 00:00:00
House024 | Yes | 2004-03-01 00:00:00 | 2007-03-05 00:00:00
House025 | 0 | 00:00:00 | 00:00:00
House026 | 0 | 00:00:00 | 00:00:00
House027 | 0 | 00:00:00 | 00:00:00
House028 | 0 | 00:00:00 | 00:00:00
House029 | Yes | 2006-01-01 00:00:00 | 2009-01-06 00:00:00
House030 | 0 | 00:00:00 | 00:00:00
House031 | 0 | 00:00:00 | 00:00:00
House032 | Yes | 2005-01-01 00:00:00 | 2012-05-07 00:00:00
House033 | 0 | 00:00:00 | 00:00:00
House034 | 0 | 00:00:00 | 00:00:00
House035 | Yes | 2004-11-22 00:00:00 | 2012-03-31 00:00:00
House036 | 0 | 00:00:00 | 00:00:00
House037 | Yes | 2005-01-01 00:00:00 | 2006-11-30 00:00:00
House038 | 0 | 00:00:00 | 00:00:00
House039 | 0 | 00:00:00 | 00:00:00
House040 | 0 | 00:00:00 | 00:00:00
House041 | 0 | 00:00:00 | 00:00:00
House042 | 0 | 00:00:00 | 00:00:00
House043 | 0 | 00:00:00 | 00:00:00
House044 | 0 | 00:00:00 | 00:00:00
House045 | 0 | 00:00:00 | 00:00:00
House046 | Yes | 2005-01-01 00:00:00 | 2006-10-23 00:00:00
House047 | 0 | 00:00:00 | 00:00:00
House048 | Yes | 2003-05-01 00:00:00 | 2012-05-07 00:00:00
House049 | 0 | 00:00:00 | 00:00:00
House050 | Yes | 2004-03-15 00:00:00 | 2007-08-31 00:00:00
House051 | Yes | 2004-01-01 00:00:00 | 2011-04-30 00:00:00
House052 | 0 | 00:00:00 | 00:00:00
House053 | 0 | 00:00:00 | 00:00:00
House054 | 0 | 00:00:00 | 00:00:00
House055 | 0 | 00:00:00 | 00:00:00
House056 | 0 | 00:00:00 | 00:00:00
House057 | 0 | 00:00:00 | 00:00:00
House058 | Yes | 2004-01-01 00:00:00 | 2011-08-31 00:00:00
House059 | 0 | 00:00:00 | 00:00:00
House060 | 0 | 00:00:00 | 00:00:00
House061 | 0 | 00:00:00 | 00:00:00
House062 | 0 | 00:00:00 | 00:00:00
House063 | Yes | 2006-12-01 00:00:00 | 2009-10-31 00:00:00
House064 | 0 | 00:00:00 | 00:00:00
House065 | 0 | 00:00:00 | 00:00:00
House066 | 0 | 00:00:00 | 00:00:00
House067 | 0 | 00:00:00 | 00:00:00
House068 | 0 | 00:00:00 | 00:00:00
House069 | 0 | 00:00:00 | 00:00:00
House070 | 0 | 00:00:00 | 00:00:00
House071 | 0 | 00:00:00 | 00:00:00
House072 | 0 | 00:00:00 | 00:00:00
House073 | Yes | 2004-07-01 00:00:00 | 2007-04-15 00:00:00
House074 | 0 | 00:00:00 | 00:00:00
House075 | 0 | 00:00:00 | 00:00:00
House076 | Yes | 2004-01-01 00:00:00 | 2005-03-31 00:00:00
House077 | 0 | 00:00:00 | 00:00:00
House078 | Yes | 2004-07-01 00:00:00 | 2005-03-15 00:00:00
House079 | Yes | 2006-03-01 00:00:00 | 2007-04-01 00:00:00
House080 | Yes | 2004-05-01 00:00:00 | 2005-03-31 00:00:00
House081 | Yes | 2004-09-01 00:00:00 | 2005-02-28 00:00:00
House082 | Yes | 2004-07-01 00:00:00 | 2005-03-15 00:00:00
House083 | 0 | 00:00:00 | 00:00:00
House084 | Yes | 2004-07-15 00:00:00 | 2006-01-15 00:00:00
House085 | 0 | 00:00:00 | 00:00:00
House086 | Yes | 2004-07-01 00:00:00 | 2005-03-15 00:00:00
House087 | 0 | 00:00:00 | 00:00:00
House088 | Yes | 2005-01-01 00:00:00 | 2005-10-31 00:00:00
House089 | 0 | 00:00:00 | 00:00:00
House090 | 0 | 00:00:00 | 00:00:00
House091 | 0 | 00:00:00 | 00:00:00
House092 | Yes | 2005-01-01 00:00:00 | 2008-12-31 00:00:00
House093 | 0 | 00:00:00 | 00:00:00
House094 | 0 | 00:00:00 | 00:00:00
House095 | Yes | 2004-07-01 00:00:00 | 2005-03-15 00:00:00
House096 | 0 | 00:00:00 | 00:00:00
House097 | Yes | 2004-07-01 00:00:00 | 2005-03-15 00:00:00
House098 | 0 | 00:00:00 | 00:00:00
House099 | Yes | 2005-09-01 00:00:00 | 2007-03-05 00:00:00
House100 | Yes | 2011-05-01 00:00:00 | 2011-09-30 00:00:00
House101 | 0 | 00:00:00 | 00:00:00
House102 | Yes | 2005-07-01 00:00:00 | 2011-08-31 00:00:00
House103 | 0 | 00:00:00 | 00:00:00
House104 | Yes | 2005-07-01 00:00:00 | 2011-08-31 00:00:00
House105 | Yes | 2005-05-15 00:00:00 | 2012-05-09 00:00:00
House106 | Yes | 2005-07-01 00:00:00 | 2007-06-09 00:00:00
House107 | Yes | 2005-01-01 00:00:00 | 2006-04-30 00:00:00
House108 | Yes | 2005-07-01 00:00:00 | 2007-06-30 00:00:00
House109 | Yes | 2005-07-01 00:00:00 | 2007-04-30 00:00:00
House110 | Yes | 2005-07-01 00:00:00 | 2012-05-09 00:00:00
House111 | Yes | 2005-01-01 00:00:00 | 2006-12-31 00:00:00
House112 | Yes | 2005-12-01 00:00:00 | 2008-01-31 00:00:00
House113 | Yes | 2005-12-01 00:00:00 | 2007-05-31 00:00:00
House114 | Yes | 2005-10-01 00:00:00 | 2009-06-30 00:00:00
House115 | Yes | 2005-10-01 00:00:00 | 2010-05-28 00:00:00
House116 | Yes | 2005-01-01 00:00:00 | 2006-07-31 00:00:00
House117 | Yes | 2005-01-01 00:00:00 | 2006-07-31 00:00:00
House118 | Yes | 2005-12-01 00:00:00 | 2012-05-09 00:00:00
House119 | Yes | 2005-07-01 00:00:00 | 2011-08-31 00:00:00
House120 | Yes | 2005-08-15 00:00:00 | 2007-02-28 00:00:00
House121 | Yes | 2005-01-01 00:00:00 | 2006-07-28 00:00:00
House122 | Yes | 2006-07-01 00:00:00 | 2007-07-31 00:00:00
House123 | 0 | 00:00:00 | 00:00:00
House124 | Yes | 2005-09-15 00:00:00 | 2011-04-30 00:00:00
House125 | Yes | 2005-12-01 00:00:00 | 2012-05-09 00:00:00
House126 | Yes | 2005-01-01 00:00:00 | 2006-07-31 00:00:00
House127 | Yes | 2006-01-01 00:00:00 | 2007-09-30 00:00:00
House128 | Yes | 2006-07-01 00:00:00 | 2012-04-30 00:00:00
House129 | Yes | 2005-12-01 00:00:00 | 2007-05-31 00:00:00
House130 | 0 | 00:00:00 | 00:00:00
House131 | Yes | 2005-12-01 00:00:00 | 2010-11-30 00:00:00
House132 | Yes | 2005-01-12 00:00:00 | 2006-04-24 00:00:00
House133 | 0 | 00:00:00 | 00:00:00
House134 | 0 | 00:00:00 | 00:00:00
House135 | 0 | 00:00:00 | 00:00:00
House136 | 0 | 00:00:00 | 00:00:00
House137 | Yes | 2005-12-15 00:00:00 | 2009-07-25 00:00:00
House138 | Yes | 2006-01-01 00:00:00 | 2007-09-30 00:00:00
House139 | Yes | 2006-01-01 00:00:00 | 2007-11-26 00:00:00
House140 | 0 | 00:00:00 | 00:00:00
House141 | 0 | 00:00:00 | 00:00:00
House142 | 0 | 00:00:00 | 00:00:00
House143 | 0 | 00:00:00 | 00:00:00
House144 | 0 | 00:00:00 | 00:00:00
House145 | 0 | 00:00:00 | 00:00:00
House146 | Yes | 2006-05-01 00:00:00 | 2008-04-15 00:00:00
House147 | Yes | 2006-12-01 00:00:00 | 2009-09-03 00:00:00
House148 | 0 | 00:00:00 | 00:00:00
House149 | 0 | 00:00:00 | 00:00:00
House150 | Yes | 2005-09-15 00:00:00 | 2011-04-30 00:00:00
House151 | 0 | 00:00:00 | 00:00:00
House152 | 0 | 00:00:00 | 00:00:00
House153 | 0 | 00:00:00 | 00:00:00
House154 | Yes | 2005-09-15 00:00:00 | 2011-04-30 00:00:00
House155 | 0 | 00:00:00 | 00:00:00
House156 | 0 | 00:00:00 | 00:00:00
House157 | Yes | 2007-09-24 00:00:00 | 2010-02-28 00:00:00
House158 | Yes | 2007-11-12 00:00:00 | 2010-11-30 00:00:00
House159 | 0 | 00:00:00 | 00:00:00
House160 | Yes | 2006-12-01 00:00:00 | 2009-10-31 00:00:00
House161 | Yes | 2005-12-15 00:00:00 | 2009-07-25 00:00:00
[NAME] | 0 | 00:00:00 | 00:00:00
House163 | Yes | 2008-01-01 00:00:00 | 2009-03-16 00:00:00
House164 | 0 | 00:00:00 | 00:00:00
House165 | Yes | 2008-03-20 00:00:00 | 2008-12-31 00:00:00
House166 | Yes | 2008-07-01 00:00:00 | 2012-05-09 00:00:00
House167 | Yes | 2008-07-15 00:00:00 | 2011-03-31 00:00:00
House168 | 0 | 00:00:00 | 00:00:00
House169 | Yes | 2008-10-22 00:00:00 | 2009-09-01 00:00:00
House170 | 0 | 00:00:00 | 00:00:00
House171 | 0 | 00:00:00 | 00:00:00
House172 | Yes | 2003-01-01 00:00:00 | 2012-05-09 00:00:00
House173 | 0 | 00:00:00 | 00:00:00
House174 | 0 | 00:00:00 | 00:00:00
House175 | 0 | 00:00:00 | 00:00:00
House176 | 0 | 00:00:00 | 00:00:00
House177 | 0 | 00:00:00 | 00:00:00
House178 | 0 | 00:00:00 | 00:00:00
House179 | 0 | 00:00:00 | 00:00:00
House180 | 0 | 00:00:00 | 00:00:00
House181 | 0 | 00:00:00 | 00:00:00
House182 | Yes | 2011-02-15 00:00:00 | 2011-08-31 00:00:00
House183 | 0 | 00:00:00 | 00:00:00
House184 | 0 | 00:00:00 | 00:00:00
House185 | 0 | 00:00:00 | 00:00:00
House186 | 0 | 00:00:00 | 00:00:00
House187 | 0 | 00:00:00 | 00:00:00