{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["RVData","Sheet2","Sheet3"],"not_rendered":{"charts":1,"images":1,"macros":1,"external_links":0,"defined_names":28,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"RVData","index":0,"n_rows":179,"n_cols":47,"rows_kept":179,"cut":false,"hidden":false,"merged":[[34,30,34,31],[6,3,6,4]]}
[]
[null,"Barton Consultancy"]
[]
["Retirement village data sheet"]
["Client name",null,null,null,null,null,"Instructions"]
["Operator name",null,null,null,null,null,1,"Input valuation date."]
["Valuation date",null,null,{"$f":"EOMONTH(NOW(),-1)","v":"2018-10-31"},null,null,2,"Count records to be included in this spreadsheet."]
[null,null,null,null,null,null,3,"Make room for required number of records by clicking button above."]
[null,null,null,null,null,null,4,"Read comments describing input data."]
[null,null,null,null,null,null,5,"Populate input data (magenta fields in Residents' data)"]
[null,null,null,null,null,null,6,"Check totals, maximum and minimum for reasonableness.  "]
[null,null,null,null,null,null,7,"Correct if necessary, guided by minimum and maximum rows ."]
[null,null,null,null,null,null,8,"Check and print Data summary"]
[null,null,null,null,null,null,9,"Send to Barton@Actuary.com.au"]
[]
[]
[]
["Data summary"]
[]
[]
[null,null,"Occupied","Vacant","Terminated","All",null,null,null,"Year ended","Termination rate"]
["Females",null,{"$f":"$S$77","v":11},null,{"$f":"$S$79","v":11},{"$f":"C22+E22","v":22},null,null,null,{"$f":"EOMONTH(J23,-12)","v":"2014-10-31"},{"$f":"INDEX(TerminationRate,ROW(J22)-ROW($K$21))","v":0}]
["Males",null,{"$f":"$T$77","v":4},null,{"$f":"$T$79","v":4},{"$f":"C23+E23","v":8},null,null,null,{"$f":"EOMONTH(J24,-12)","v":"2015-10-31"},{"$f":"INDEX(TerminationRate,ROW(J23)-ROW($K$21))","v":0}]
["Occupancies",null,{"$f":"R77","v":14},{"$f":"R78","v":2},{"$f":"R79","v":24},{"$f":"COUNT(B37:B76)","v":40},{"$f":"IF(SUM(C24:E24)<>F24,\"Error\",\"ok\")","v":"ok"},{"$f":"IF(SUM(V37:W76)>0,\"Exit modes missing\",\"Exit modes ok\")","v":"Exit modes ok"},null,{"$f":"EOMONTH(J25,-12)","v":"2016-10-31"},{"$f":"INDEX(TerminationRate,ROW(J24)-ROW($K$21))","v":0}]
["Purchase",null,{"$f":"L77","v":4664000},{"$f":"L78","v":425000},{"$f":"L79","v":4038750},{"$f":"L80","v":9127750},{"$f":"IF(SUM(C25:E25)<>F25,\"Error\",\"ok\")","v":"ok"},null,null,{"$f":"EOMONTH(J26,-12)","v":"2017-10-31"},{"$f":"INDEX(TerminationRate,ROW(J25)-ROW($K$21))","v":0}]
["Average purchase",null,{"$f":"IF(C$24<>0,C25/C$24)","v":333142.85714285716},{"$f":"IF(D$24<>0,D25/D$24)","v":212500},{"$f":"IF(E$24<>0,E25/E$24)","v":168281.25},{"$f":"IF(F$24<>0,F25/F$24)","v":228193.75},null,null,null,{"$f":"ValnDate","v":"2018-10-31"},{"$f":"INDEX(TerminationRate,ROW(J26)-ROW($K$21))","v":0}]
["Reallocation",null,{"$f":"M77","v":6305000},{"$f":"M78","v":650000},{"$f":"M79","v":6572750},{"$f":"M80","v":13527750},{"$f":"IF(SUM(C27:E27)<>F27,\"Error\",\"ok\")","v":"ok"},null,null,"All",{"$f":"GlobalTermination *1","v":0}]
["Average reallocation",null,{"$f":"IF(C$24<>0,C27/C$24)","v":450357.14285714284},{"$f":"IF(D$24<>0,D27/D$24)","v":325000},{"$f":"IF(E$24<>0,E27/E$24)","v":273864.58333333331},{"$f":"IF(F$24<>0,F27/F$24)","v":338193.75},{"$f":"IF(COUNT(IF(Q37:Q76<>\"\",1,\"\"))>0,COUNT(IF(Q37:Q76<>\"\",1,\"\"))&\" error(s). See column \"&CHAR(64+COLUMN($Q$37)),\"ok\")","v":"ok"},null,null,"Expectancy (a) ",{"$f":"1/K27+0.5","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,null,null,null,null,null,null,"(a) ","Assumes continuation of current termination rate"]
[]
["Residents' data",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D32<FinDate,IF(E32<FinDate,YEARFRAC(D32,E32),\"\"),\"\")","v":0},null,{"$f":"IF(H32<FinDate,IF(I32<FinDate,YEARFRAC(H32,I32),\"\"),\"\")","v":0},null,{"$f":"IF(D32<FinDate,D32,IF(E32<=ValnDate,E32-365.25*IF(I32<=ValnDate,Z72,Y72),\"\"))","v":"00:00:00"},{"$f":"IF(H32<FinDate,H32,IF(I32<=ValnDate,I32-365.25*IF(M32<=ValnDate,AD72,AC72),\"\"))","v":"00:00:00"}]
[]
[]
[null,null,null,"Female",null,null,null,"Male",null,null,null,null,null,null,null,null,null,"Occupied","Female","Spouse",null,"Female exit error","Male exit error",null,"Entry ages",null,null,null,"Imputed birthdate",null,"Occupancy dates",null,"Beginners year end",null,null,null,null,"Enders year end",null,null,null,null,"Exits year end"]
["Record ID","Occupancy","Name","Female Birth","Female entry","Female Exit","Female exit mode ","Male Birth","Male entry","Male Exit","Male exit mode ","Purchase","Reallocation","Care level","Site code","Contract code",null,null,null,null,null,null,null,null,"Single female","Coupled female","Single male","Coupled male","Female","Male","First","Last",{"$f":"EOMONTH(ValnDate,-48)","v":"2014-10-31"},{"$f":"EOMONTH(AG36,12)","v":"2015-10-31"},{"$f":"EOMONTH(AH36,12)","v":"2016-10-31"},{"$f":"EOMONTH(AI36,12)","v":"2017-10-31"},{"$f":"EOMONTH(AJ36,12)","v":"2018-10-31"},{"$f":"EOMONTH(ValnDate,-48)","v":"2014-10-31"},{"$f":"EOMONTH(AL36,12)","v":"2015-10-31"},{"$f":"EOMONTH(AM36,12)","v":"2016-10-31"},{"$f":"EOMONTH(AN36,12)","v":"2017-10-31"},{"$f":"EOMONTH(AO36,12)","v":"2018-10-31"},{"$f":"EOMONTH(ValnDate,-48)","v":"2014-10-31"},{"$f":"EOMONTH(AQ36,12)","v":"2015-10-31"},{"$f":"EOMONTH(AR36,12)","v":"2016-10-31"},{"$f":"EOMONTH(AS36,12)","v":"2017-10-31"},{"$f":"EOMONTH(AT36,12)","v":"2018-10-31"}]
["001",1,"Occupant(s)1","1920-03-24","1990-01-20","2013-08-18",3,"1917-01-26","1990-01-20","2003-08-21",1,146000,470000,1,1,1,{"$f":"IF(IF(AND(F37>0,F37<E37),1,0) + IF(AND(J37>0,J37<I37),1,0) >0, \"Exit < entry\",\"\")","v":""},{"$f":"IF(OR(S37>0,T37>0),1,IF(OR(ISBLANK(E37),E37>$D$7),-1,0))","v":0},{"$f":"IF(AND(ISNUMBER(E37),E37<=$D$7),IF((AND(ISNUMBER(F37), F37<=$D$7)),0,1),0)","v":0},{"$f":"IF(AND(ISNUMBER(I37),I37<=$D$7),IF((AND(ISNUMBER(J37), J37<=$D$7)),0,1),0)","v":0},null,{"$f":"IF(AND(ISNUMBER(F37),F37<$D$7),IF(G37>0,0,1),0)","v":0},{"$f":"IF(AND(ISNUMBER(J37),J37<$D$7),IF(K37>0,0,1),0)","v":0},null,{"$f":"IF(I37<FinDate,\"\",IF(D37<FinDate,IF(E37<FinDate,YEARFRAC(D37,E37),\"\"),\"\"))","v":""},{"$f":"IF(I37 = FinDate,\"\",IF(D37<FinDate,IF(E37<FinDate,YEARFRAC(D37,E37),\"\"),\"\"))","v":69.822222222222223},{"$f":"IF(E37 < FinDate,\"\",IF(H37<FinDate,IF(I37<FinDate,YEARFRAC(H37,I37),\"\"),\"\"))","v":""},{"$f":"IF(E37=FinDate,\"\",IF(H37<FinDate,IF(I37<FinDate,YEARFRAC(H37,I37),\"\"),\"\"))","v":72.983333333333334},{"$f":"IF(D37<FinDate,D37,IF(E37<=ValnDate,E37-365.25*IF(I37<=ValnDate,Z77,Y77),\"\"))","v":"1920-03-24"},{"$f":"IF(H37<FinDate,H37,IF(I37<=ValnDate,I37-365.25*IF(E37<=ValnDate,AD77,AC77),\"\"))","v":"1917-01-26"},{"$f":"MIN(E37,I37)","v":"1990-01-20"},{"$f":"IF(R37=-1,\"\",MAX(IF(E37<FinDate,F37,0),IF(I37<FinDate,J37,0)))","v":"2013-08-18"},{"$f":"IF(AND($AE37<EOMONTH(AG$36,-12),$AF37>EOMONTH(AG$36,-12)),1,0)","v":0},0,0,0,0,{"$f":"IF(AND($AE37<AL$36,$AF37>AL$36),1,0)","v":0},0,0,0,0,{"$f":"IF(AND($AF37>EOMONTH(AQ$36,-12),$AF37<=AQ$36),1,0)","v":0},0,0,0,0]
["001",2,"Occupant(s)2","1942-01-04","2014-05-17","2099-12-31",0,"2099-12-31","2099-12-31","2099-12-31",null,480000,480000,1,1,1,null,1,1,0,null,0,0,null,72.36944444444444,"","","",{"$f":"IF(D38<FinDate,D38,IF(E38<=ValnDate,E38-365.25*IF(I38<=ValnDate,Z54,Y54),\"\"))","v":"1942-01-04"},{"$f":"IF(H38<FinDate,H38,IF(I38<=ValnDate,I38-365.25*IF(E38<=ValnDate,AD54,AC54),\"\"))","v":""},{"$f":"MIN(E38,I38)","v":"2014-05-17"},"2099-12-31",0,1,1,1,1,1,1,1,1,1,0,0,0,0,0]
["002",1,"Occupant(s)3","1918-07-03","1992-01-02","2099-12-31",0,"2099-12-31","2099-12-31","2099-12-31",0,143000,490000,1,1,1,null,1,1,0,null,0,0,null,73.49722222222222,"","","","1918-07-03","","1992-01-02","2099-12-31",1,1,1,1,1,1,1,1,1,1,0,0,0,0,0]
["003",1,"Occupant(s)4","2099-12-31","2099-12-31","2099-12-31",0,"1924-10-16","1990-09-14","2007-04-06",1,147000,350000,1,1,1,null,-1,0,0,null,0,0,null,"","",65.911111111111111,"","","1924-10-16","1990-09-14","",1,1,1,1,1,1,1,1,1,1,0,0,0,0,0]
["003",2,"Occupant(s)5","1932-05-18","2007-08-19","2099-12-31",0,"2099-12-31","2099-12-31","2099-12-31",0,350000,470000,1,1,1,null,1,1,0,null,0,0,null,75.25277777777778,"","","","1932-05-18","","2007-08-19","2099-12-31",1,1,1,1,1,1,1,1,1,1,0,0,0,0,0]
["004",1,"Occupant(s)6","1925-08-06","1990-03-08","2010-08-14",2,"2099-12-31","2099-12-31","2099-12-31",0,142000,445000,1,1,1,null,0,0,0,null,0,0,null,64.588888888888889,"","","","1925-08-06","","1990-03-08","2010-08-14",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["004",2,"Occupant(s)7","1926-04-14","2012-04-01","2099-12-31",0,"2099-12-31","2099-12-31","2099-12-31",0,445000,470000,1,1,1,null,1,1,0,null,0,0,null,85.963888888888889,"","","","1926-04-14","","2012-04-01","2099-12-31",1,1,1,1,1,1,1,1,1,1,0,0,0,0,0]
["005",1,"Occupant(s)8","1927-04-30","1990-02-22","2011-07-07",3,"1922-10-01","1990-02-22","2012-02-21",2,155000,460000,1,1,1,null,0,0,0,null,0,0,null,"",62.81111111111111,"",67.391666666666666,"1927-04-30","1922-10-01","1990-02-22","2012-02-21",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["005",2,"Occupant(s)9","2099-12-31","2099-12-31","2099-12-31",0,"1935-09-16","2012-03-11","2099-12-31",0,460000,490000,1,1,1,null,1,0,1,null,0,0,null,"","",76.486111111111114,"","","1935-09-16","2012-03-11","2099-12-31",1,1,1,1,1,1,1,1,1,1,0,0,0,0,0]
["006",1,"Occupant(s)10","1920-10-14T09:00:00","1991-03-10","1993-04-15",3,"2099-12-31","2099-12-31","2099-12-31",0,136000,165750,1,1,1,null,0,0,0,null,0,0,null,70.405555555555551,"","","","1920-10-14T09:00:00","","1991-03-10","1993-04-15",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["006",2,"Occupant(s)11","1915-02-28","1993-04-15","2004-07-28",1,"2099-12-31","2099-12-31","2099-12-31",0,165750,290000,1,1,1,null,0,0,0,null,0,0,null,78.125,"","","","1915-02-28","","1993-04-15","2004-07-28",{"$f":"IF(AND($AE47<EOMONTH(AG$36,-12),$AF47>EOMONTH(AG$36,-12)),1,0)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"IF(AND($AF47>EOMONTH(AQ$36,-12),$AF47<=AQ$36),1,0)","v":0},0,0,0,0]
["006",3,"Occupant(s)12","1933-11-25","2004-10-15","2012-01-29",3,"2099-12-31","2099-12-31","2099-12-31",0,290000,444000,1,1,1,null,0,0,0,null,0,0,null,70.888888888888886,"","","","1933-11-25","","2004-10-15","2012-01-29",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["006",4,"Occupant(s)13","1932-02-01","2014-06-29","2099-12-31",0,"2099-12-31","2099-12-31","2099-12-31",0,444000,490000,1,1,1,null,1,1,0,null,0,0,null,82.411111111111111,"","","","1932-02-01","","2014-06-29","2099-12-31",0,1,1,1,1,1,1,1,1,1,0,0,0,0,0]
["007",1,"Occupant(s)14","1930-01-13T21:00:00","1989-10-21","1992-07-15",3,"2099-12-31","2099-12-31","2099-12-31",0,106000,119000,1,1,1,null,0,0,0,null,0,0,null,59.772222222222226,"","","","1930-01-13T21:00:00","","1989-10-21","1992-07-15",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["007",2,"Occupant(s)15","1917-12-08","1992-07-19","2010-08-27",3,"2099-12-31","2099-12-31","2099-12-31",0,119000,330000,1,1,1,null,0,0,0,null,0,0,null,74.613888888888894,"","","","1917-12-08","","1992-07-19","2010-08-27",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["007",3,"Occupant(s)16","1944-09-24","2014-02-13","2099-12-31",0,"2099-12-31","2099-12-31","2099-12-31",0,345000,390000,1,1,1,null,1,1,0,null,0,0,null,69.386111111111106,"","","","1944-09-24","","2014-02-13","2099-12-31",0,1,1,1,1,1,1,1,1,1,0,0,0,0,0]
["008",1,"Occupant(s)17","1914-04-08","1990-03-08","2006-12-09",3,"2099-12-31","2099-12-31","2099-12-31",0,139500,345000,1,1,1,null,0,0,0,null,0,0,null,75.916666666666671,"","","","1914-04-08","","1990-03-08","2006-12-09",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["008",2,"Occupant(s)18","1931-09-03","2008-03-16","2012-03-10",3,"2099-12-31","2099-12-31","2099-12-31",0,345000,440000,1,1,1,null,0,0,0,null,0,0,null,76.536111111111111,"","","","1931-09-03","","2008-03-16","2012-03-10",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["008",3,"Occupant(s)19","1934-07-24","2014-01-03","2099-12-31",0,"1936-08-24","2014-01-03","2099-12-31",0,440000,470000,1,1,1,null,1,1,1,null,0,0,null,"",79.441666666666663,"",77.358333333333334,"1934-07-24","1936-08-24","2014-01-03","2099-12-31",0,1,1,1,1,1,1,1,1,1,0,0,0,0,0]
["009",1,"Occupant(s)20","1915-10-20","1990-12-23","2003-07-23",1,"1913-02-26","1990-12-23","2006-01-13",3,151000,343000,1,1,1,null,0,0,0,null,0,0,null,"",75.174999999999997,"",77.825000000000003,"1915-10-20","1913-02-26","1990-12-23","2006-01-13",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["009",2,"Occupant(s)21","1927-03-01","2005-11-13","2009-10-05",3,"1922-02-21","2006-01-13","2010-04-07",3,343000,400000,1,1,1,null,0,0,0,null,0,0,null,"",78.7,"",83.894444444444446,"1927-03-01","1922-02-21","2005-11-13","2010-04-07",{"$f":"IF(AND($AE57<EOMONTH(AG$36,-12),$AF57>EOMONTH(AG$36,-12)),1,0)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"IF(AND($AF57>EOMONTH(AQ$36,-12),$AF57<=AQ$36),1,0)","v":0},0,0,0,0]
["009",3,"Occupant(s)22","2099-12-31","2099-12-31","2099-12-31",0,"1929-10-15","2011-08-19","2099-12-31",0,400000,480000,1,1,1,null,1,0,1,null,0,0,null,"","",81.844444444444449,"","","1929-10-15","2011-08-19","2099-12-31",1,1,1,1,1,1,1,1,1,1,0,0,0,0,0]
["010",1,"Occupant(s)23","1913-05-03T21:00:00","1990-01-28","1991-11-03",3,"1915-05-04T09:00:00","1990-01-28","1991-11-03",3,99500,116000,1,1,1,null,0,0,0,null,0,0,null,"",76.736111111111114,"",74.733333333333334,"1913-05-03T21:00:00","1915-05-04T09:00:00","1990-01-28","1991-11-03",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["010",2,"Occupant(s)24","1930-11-09T15:00:00","1991-11-16","1994-05-11",1,"2099-12-31","2099-12-31","2099-12-31",0,116000,150000,1,1,1,null,0,0,0,null,0,0,null,61.019444444444446,"","","","1930-11-09T15:00:00","","1991-11-16","1994-05-11",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["010",3,"Occupant(s)25","1911-06-11","1995-07-30","2002-10-12",3,"2099-12-31","2099-12-31","2099-12-31",0,150000,182000,1,1,1,null,0,0,0,null,0,0,null,84.136111111111106,"","","","1911-06-11","","1995-07-30","2002-10-12",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["010",4,"Occupant(s)26","1920-07-08","2003-07-18","2006-02-13",3,"1918-04-25","2003-07-18","2005-01-13",1,182000,270000,1,1,1,null,0,0,0,null,0,0,null,"",83.027777777777771,"",85.230555555555554,"1920-07-08","1918-04-25","2003-07-18","2006-02-13",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["010",5,"Occupant(s)27","1927-05-02","2006-10-26","2099-12-31",0,"2099-12-31","2099-12-31","2099-12-31",0,270000,370000,1,1,1,null,1,1,0,null,0,0,null,79.483333333333334,"","","","1927-05-02","","2006-10-26","2099-12-31",1,1,1,1,1,1,1,1,1,1,0,0,0,0,0]
["011",1,"Occupant(s)28","1929-12-01T21:00:00","1991-08-29","2000-01-22",3,"2099-12-31","2099-12-31","2099-12-31",0,117000,182000,1,1,1,null,0,0,0,null,0,0,null,61.744444444444447,"","","","1929-12-01T21:00:00","","1991-08-29","2000-01-22",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["011",2,"Occupant(s)29","1926-10-30","2000-09-08","2099-12-31",0,"2099-12-31","2099-12-31","2099-12-31",0,182000,370000,1,1,1,null,1,1,0,null,0,0,null,73.855555555555554,"","","","1926-10-30","","2000-09-08","2099-12-31",1,1,1,1,1,1,1,1,1,1,0,0,0,0,0]
["012",1,"Occupant(s)30","1911-03-07T21:00:00","1990-04-29","1997-04-07",3,"2099-12-31","2099-12-31","2099-12-31",0,153000,200000,1,1,1,{"$f":"IF(IF(AND(F66>0,F66<E66),1,0) + IF(AND(J66>0,J66<I66),1,0) >0, \"Exit < entry\",\"\")","v":""},0,0,0,null,0,0,null,79.144444444444446,"","","","1911-03-07T21:00:00","","1990-04-29","1997-04-07",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["012",2,"Occupant(s)31","1917-02-23T21:00:00","1997-09-06","1999-01-09",3,"2099-12-31","2099-12-31","2099-12-31",0,200000,225000,1,1,1,"",0,0,0,null,0,0,null,80.536111111111111,"","","","1917-02-23T21:00:00","","1997-09-06","1999-01-09",{"$f":"IF(AND($AE67<EOMONTH(AG$36,-12),$AF67>EOMONTH(AG$36,-12)),1,0)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"IF(AND($AF67>EOMONTH(AQ$36,-12),$AF67<=AQ$36),1,0)","v":0},0,0,0,0]
["012",3,"Occupant(s)32","1924-01-19","1999-08-26","2099-12-31",0,"2099-12-31","2099-12-31","2099-12-31",0,225000,495000,1,1,1,"",1,1,0,null,0,0,null,75.602777777777774,"","","","1924-01-19","","1999-08-26","2099-12-31",1,1,1,1,1,1,1,1,1,1,0,0,0,0,0]
["014",1,"Occupant(s)33","1916-04-09T03:00:00","1990-04-22","1998-10-09",3,"2099-12-31","2099-12-31","2099-12-31",0,103000,160000,1,1,1,"",0,0,0,null,0,0,null,74.036111111111111,"","","","1916-04-09T03:00:00","","1990-04-22","1998-10-09",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["014",2,"Occupant(s)34","1920-02-23T09:00:00","1999-06-09","2000-08-24",1,"2099-12-31","2099-12-31","2099-12-31",0,160000,180000,1,1,1,"",0,0,0,null,0,0,null,79.294444444444451,"","","","1920-02-23T09:00:00","","1999-06-09","2000-08-24",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["014",3,"Occupant(s)35","1910-02-03","2000-12-03","2006-06-17",3,"2099-12-31","2099-12-31","2099-12-31",0,180000,278000,1,1,1,"",0,0,0,null,0,0,null,90.833333333333329,"","","","1910-02-03","","2000-12-03","2006-06-17",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["014",4,"Occupant(s)36","2099-12-31","2099-12-31","2099-12-31",0,"1917-12-21","2007-01-31","2008-11-16",1,278000,300000,1,1,1,"",-1,0,0,null,0,0,null,"","",89.111111111111114,"","","1917-12-21","2007-01-31","",1,1,1,1,1,1,1,1,1,1,0,0,0,0,0]
["014",5,"Occupant(s)37","2099-12-31","2099-12-31","2099-12-31",0,"1924-03-20","2011-08-20","2099-12-31",0,300000,370000,1,1,1,"",1,0,1,null,0,0,null,"","",87.416666666666671,"","","1924-03-20","2011-08-20","2099-12-31",1,1,1,1,1,1,1,1,1,1,0,0,0,0,0]
["015",1,"Occupant(s)38","1908-11-23T03:00:00","1992-06-28","1994-05-25",3,"2099-12-31","2099-12-31","2099-12-31",0,142000,198000,1,1,1,"",0,0,0,null,0,0,null,83.597222222222229,"","","","1908-11-23T03:00:00","","1992-06-28","1994-05-25",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["015",2,"Occupant(s)39","1920-03-28T09:00:00","1995-08-05","1996-09-27",3,"1923-03-29T03:00:00","1995-08-05","1996-09-27",3,198000,180000,1,1,1,"",0,0,0,null,0,0,null,"",75.352777777777774,"",72.349999999999994,"1920-03-28T09:00:00","1923-03-29T03:00:00","1995-08-05","1996-09-27",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["015",3,"Occupant(s)40","1932-06-10","1997-06-26","2099-12-31",0,"2099-12-31","2099-12-31","2099-12-31",0,180000,470000,1,1,1,"",{"$f":"IF(OR(S76>0,T76>0),1,IF(OR(ISBLANK(E76),E76>$D$7),-1,0))","v":1},{"$f":"IF(AND(ISNUMBER(E76),E76<=$D$7),IF((AND(ISNUMBER(F76), F76<=$D$7)),0,1),0)","v":1},{"$f":"IF(AND(ISNUMBER(I76),I76<=$D$7),IF((AND(ISNUMBER(J76), J76<=$D$7)),0,1),0)","v":0},null,{"$f":"IF(AND(ISNUMBER(F76),F76<$D$7),IF(G76>0,0,1),0)","v":0},{"$f":"IF(AND(ISNUMBER(J76),J76<$D$7),IF(K76>0,0,1),0)","v":0},null,65.044444444444451,"","","","1932-06-10","",{"$f":"MIN(E76,I76)","v":"1997-06-26"},"2099-12-31",1,1,1,1,1,1,1,1,1,1,0,0,0,0,0]
["Total occupied",{"$f":"R77","v":14},"Minimum",{"$f":"MIN(D$37:D76)","v":"1908-11-23T03:00:00"},{"$f":"MIN(E$37:E76)","v":"1989-10-21"},null,null,{"$f":"MIN(H$37:H76)","v":"1913-02-26"},{"$f":"MIN(I$37:I76)","v":"1990-01-20"},null,"$'000",{"$f":"SUM(IF($R$37:$R76=1,L$37:L76,0))","v":4664000},{"$f":"SUM(IF($R$37:$R76=1,M$37:M76,0))","v":6305000},{"$f":"SUM(IF($R$37:$R76=1,N$37:N76,0))","v":14},{"$f":"SUM(IF($R$37:$R76=1,O$37:O76,0))","v":14},{"$f":"SUM(IF($R$37:$R76=1,P$37:P76,0))","v":14},{"$f":"COUNT(IF(Q$37:Q76<>\"\",1,\"\") )& \" error(s)\"","v":"0 error(s)"},{"$f":"SUM(IF(R$37:R76=1,1,0))","v":14},{"$f":"SUM(IF(S$37:S76=1,1,0))","v":11},{"$f":"SUM(IF(T$37:T76=1,1,0))","v":4},null,{"$f":"MIN(V$37:V76)","v":0},{"$f":"MIN(W$37:W76)","v":0},"Average",{"$f":"AVERAGE(Y37:Y76)","v":74.742798353909464},{"$f":"AVERAGE(Z37:Z76)","v":75.13333333333334},{"$f":"AVERAGE(AA37:AA76)","v":80.153888888888886},{"$f":"AVERAGE(AB37:AB76)","v":76.470833333333346},"1923-09-30T07:06:51.429","1923-03-01T12:00:00","1999-08-02T21:36:00","2038-10-09T13:53:41.053",{"$f":"SUM(AG37:AG76)","v":12},16,16,16,16,16,16,16,16,16,0,0,0,0,0]
["Vacant & reserved",{"$f":"R78","v":2},"Maximum",{"$f":"MAX(D$37:D76)","v":"2099-12-31"},{"$f":"MAX(E$37:E76)","v":"2099-12-31"},null,null,{"$f":"MAX(H$37:H76)","v":"2099-12-31"},{"$f":"MAX(I$37:I76)","v":"2099-12-31"},null,"$'000",{"$f":"SUM(IF($R$37:$R76=-1,L$37:L76,0))","v":425000},{"$f":"SUM(IF($R$37:$R76=-1,M$37:M76,0))","v":650000},{"$f":"SUM(IF($R$37:$R76=-1,N$37:N76,0))","v":2},{"$f":"SUM(IF($R$37:$R76=-1,O$37:O76,0))","v":2},{"$f":"SUM(IF($R$37:$R76=-1,P$37:P76,0))","v":2},null,{"$f":"SUM(IF(R$37:R76=-1,1,0))","v":2},{"$f":"R78","v":2},{"$f":"S78","v":2},null,{"$f":"MAX(V$37:V76)","v":0},{"$f":"MAX(W$37:W76)","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(SUM(AG77:AP77)-SUM(AQ77:AU77)<>0,2*SUM(AQ77:AU77)/(SUM(AG77:AP77)-SUM(AQ77:AU77)),0)","v":0},{"$f":"IF((AG77+AL77-AQ77)<>0,2*AQ77/(AG77+AL77-AQ77),0)","v":0},{"$f":"IF((AH77+AM77-AR77)<>0,2*AR77/(AH77+AM77-AR77),0)","v":0},{"$f":"IF((AI77+AN77-AS77)<>0,2*AS77/(AI77+AN77-AS77),0)","v":0},{"$f":"IF((AJ77+AO77-AT77)<>0,2*AT77/(AJ77+AO77-AT77),0)","v":0},{"$f":"IF((AK77+AP77-AU77)<>0,2*AU77/(AK77+AP77-AU77),0)","v":0}]
["Terminations",{"$f":"R79","v":24},"Average",{"$f":"AVERAGE(D$37:D76)","v":"1945-10-11T06:13:30"},{"$f":"AVERAGE(E$37:E76)","v":"2011-04-03T21:00:00"},null,null,{"$f":"AVERAGE(H$37:H76)","v":"2042-07-11T17:42:00"},{"$f":"AVERAGE(I$37:I76)","v":"2067-11-03T11:24:00"},null,"$'000",{"$f":"SUM(IF($R$37:$R76=0,L$37:L76,0))","v":4038750},{"$f":"SUM(IF($R$37:$R76=0,M$37:M76,0))","v":6572750},{"$f":"SUM(IF($R$37:$R76=0,N$37:N76,0))","v":24},{"$f":"SUM(IF($R$37:$R76=0,O$37:O76,0))","v":24},{"$f":"SUM(IF($R$37:$R76=0,P$37:P76,0))","v":24},null,{"$f":"SUM(IF(R$37:R76=0,1,0))","v":24},{"$f":"SUM(IF($S$37:$S$76>0,1,0))","v":11},{"$f":"SUM(IF($T$37:$T$76>0,1,0))","v":4},null,{"$f":"AVERAGE(V$37:V76)","v":0},{"$f":"AVERAGE(W$37:W76)","v":0}]
["All",{"$f":"R80","v":40},null,null,null,null,null,null,null,null,"$'000",{"$f":"SUM(L$37:L76)","v":9127750},{"$f":"SUM(M$37:M76)","v":13527750},{"$f":"SUM(N$37:N76)","v":40},{"$f":"SUM(O$37:O76)","v":40},{"$f":"SUM(P$37:P76)","v":40},null,{"$f":"COUNT(R$37:R76)","v":40},{"$f":"COUNT(S$37:S76)","v":40},{"$f":"COUNT(T$37:T76)","v":40}]
["Average live",null,null,{"$f":"SUM(IF($S$37:$S76=1,D$37:D76,0)/SUM(IF($S$37:$S76=1,1,0)))","v":"1931-01-07T08:43:38.182"},{"$f":"SUM(IF($S$37:$S76=1,E$37:E76,0)/SUM(IF($S$37:$S76=1,1,0)))","v":"2006-09-06T21:49:05.455"},null,null,{"$f":"SUM(IF($T$37:$T76=1,H$37:H76,0)/SUM(IF($T$37:$T76=1,1,0)))","v":"1931-08-04"},{"$f":"SUM(IF($T$37:$T76=1,I$37:I76,0)/SUM(IF($T$37:$T76=1,1,0)))","v":"2012-05-13T12:00:00"},null,null,{"$f":"SUM(IF($R$37:$R76=1,L$37:L76,0)/SUM(IF($R$37:$R76=1,1,0)))","v":333142.8571428571},{"$f":"SUM(IF($R$37:$R76=1,M$37:M76,0)/SUM(IF($R$37:$R76=1,1,0)))","v":450357.14285714284},{"$f":"SUM(IF($R$37:$R76=1,N$37:N76,0)/SUM(IF($R$37:$R76=1,1,0)))","v":0.99999999999999967},{"$f":"SUM(IF($R$37:$R76=1,O$37:O76,0)/SUM(IF($R$37:$R76=1,1,0)))","v":0.99999999999999967},{"$f":"SUM(IF($R$37:$R76=1,P$37:P76,0)/SUM(IF($R$37:$R76=1,1,0)))","v":0.99999999999999967}]
["Maximum",null,null,{"$f":"MAX(IF(D$37:D76<NOW()+3000,D$37:D76,0))","v":"1944-09-24"},{"$f":"MAX(IF(E$37:E76<NOW()+3000,E$37:E76,0))","v":"2014-06-29"},{"$f":"MAX(IF(F$37:F76<NOW()+3000,F$37:F76,0))","v":"2013-08-18"},{"$f":"MAX(G$37:G76)","v":3},{"$f":"MAX(IF(H$37:H76<NOW()+3000,H$37:H76,0))","v":"1936-08-24"},{"$f":"MAX(IF(I$37:I76<NOW()+3000,I$37:I76,0))","v":"2014-01-03"},{"$f":"MAX(IF(J$37:J76<NOW()+3000,J$37:J76,0))","v":"2012-02-21"},{"$f":"MAX(K$37:K76)","v":3},{"$f":"MAX(L$37:L76)","v":480000},{"$f":"MAX(M$37:M76)","v":495000},{"$f":"MAX(N$37:N76)","v":1},{"$f":"MAX(O$37:O76)","v":1},{"$f":"MAX(P$37:P76)","v":1}]
["Minimum",null,null,{"$f":"MIN(D$37:D76)","v":"1908-11-23T03:00:00"},{"$f":"MIN(E$37:E76)","v":"1989-10-21"},{"$f":"MIN(F$37:F76)","v":"1991-11-03"},{"$f":"MIN(G$37:G76)","v":0},{"$f":"MIN(H$37:H76)","v":"1913-02-26"},{"$f":"MIN(I$37:I76)","v":"1990-01-20"},{"$f":"MIN(J$37:J76)","v":"1991-11-03"},{"$f":"MIN(K$37:K76)","v":0},{"$f":"MIN(L$37:L76)","v":99500},{"$f":"MIN(M$37:M76)","v":116000},{"$f":"MIN(N$37:N76)","v":1},{"$f":"MIN(O$37:O76)","v":1},{"$f":"MIN(P$37:P76)","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(L77:L79)=L80,\"ok\",\"Error\")","v":"ok"},{"$f":"IF(SUM(M77:M79)=M80,\"ok\",\"Error\")","v":"ok"},{"$f":"IF(SUM(N77:N79)=N80,\"ok\",\"Error\")","v":"ok"},{"$f":"IF(SUM(O77:O79)=O80,\"ok\",\"Error\")","v":"ok"},{"$f":"IF(SUM(P77:P79)=P80,\"ok\",\"Error\")","v":"ok"},null,{"$f":"IF(SUM(R77:R79)=R80,\"ok\",\"Error\")","v":"ok"}]
["Row of maximum",null,null,{"$f":"MIN(IF(D$37:D76=D82,ROW(D$37:D76),999999))","v":52},{"$f":"MIN(IF(E$37:E76=E82,ROW(E$37:E76),999999))","v":49},{"$f":"MIN(IF(F$37:F76=F82,ROW(F$37:F76),999999))","v":37},{"$f":"MIN(IF(G$37:G76=G82,ROW(G$37:G76),999999))","v":37},{"$f":"MIN(IF(H$37:H76=H82,ROW(H$37:H76),999999))","v":55},{"$f":"MIN(IF(I$37:I76=I82,ROW(I$37:I76),999999))","v":55},{"$f":"MIN(IF(J$37:J76=J82,ROW(J$37:J76),999999))","v":44},{"$f":"MIN(IF(K$37:K76=K82,ROW(K$37:K76),999999))","v":56},{"$f":"MIN(IF(L$37:L76=L82,ROW(L$37:L76),999999))","v":38},{"$f":"MIN(IF(M$37:M76=M82,ROW(M$37:M76),999999))","v":68},{"$f":"MIN(IF(N$37:N76=N82,ROW(N$37:N76),999999))","v":37},{"$f":"MIN(IF(O$37:O76=O82,ROW(O$37:O76),999999))","v":37},{"$f":"MIN(IF(P$37:P76=P82,ROW(P$37:P76),999999))","v":37}]
["Row of minimum",null,null,{"$f":"MIN(IF(D$37:D76=D83,ROW(D$37:D76),999999))","v":74},{"$f":"MIN(IF(E$37:E76=E83,ROW(E$37:E76),999999))","v":50},{"$f":"MIN(IF(F$37:F76=F83,ROW(F$37:F76),999999))","v":59},{"$f":"MIN(IF(G$37:G76=G83,ROW(G$37:G76),999999))","v":38},{"$f":"MIN(IF(H$37:H76=H83,ROW(H$37:H76),999999))","v":56},{"$f":"MIN(IF(I$37:I76=I83,ROW(I$37:I76),999999))","v":37},{"$f":"MIN(IF(J$37:J76=J83,ROW(J$37:J76),999999))","v":59},{"$f":"MIN(IF(K$37:K76=K83,ROW(K$37:K76),999999))","v":38},{"$f":"MIN(IF(L$37:L76=L83,ROW(L$37:L76),999999))","v":59},{"$f":"MIN(IF(M$37:M76=M83,ROW(M$37:M76),999999))","v":59},{"$f":"MIN(IF(N$37:N76=N83,ROW(N$37:N76),999999))","v":37},{"$f":"MIN(IF(O$37:O76=O83,ROW(O$37:O76),999999))","v":37},{"$f":"MIN(IF(P$37:P76=P83,ROW(P$37:P76),999999))","v":37}]
[]
[]
[]
["Entry distribution"]
[]
["Age","Single female entry","Single male entry","Coupled female entry","Coupled male entry"]
[57,{"$f":"SUM(IF(EntAgeFS<>\"\",1,0)*IF(EntAgeFS>=$G93,1,0)*IF(EntAgeFS<$H93,1,0))","v":1},{"$f":"SUM(IF(EntAgeMS<>\"\",1,0)*IF(EntAgeMS>=$G93,1,0)*IF(EntAgeMS<$H93,1,0))","v":0},{"$f":"SUM(IF(EntAgeFC<>\"\",1,0)*IF(EntAgeFC>=$G93,1,0)*IF(EntAgeFC<$H93,1,0))","v":0},{"$f":"SUM(IF(EntAgeMC=\"\",1,0)*IF(EntAgeMC>=$G93,1,0)*IF(EntAgeMC<$H93,1,0))","v":0},null,5,{"$f":"A93+3","v":60}]
[{"$f":"5+A93","v":62},{"$f":"SUM(IF(EntAgeFS<>\"\",1,0)*IF(EntAgeFS>=$G94,1,0)*IF(EntAgeFS<$H94,1,0))","v":3},{"$f":"SUM(IF(EntAgeMS<>\"\",1,0)*IF(EntAgeMS>=$G94,1,0)*IF(EntAgeMS<$H94,1,0))","v":0},{"$f":"SUM(IF(EntAgeFC<>\"\",1,0)*IF(EntAgeFC>=$G94,1,0)*IF(EntAgeFC<$H94,1,0))","v":1},{"$f":"SUM(IF(EntAgeMC=\"\",1,0)*IF(EntAgeMC>=$G94,1,0)*IF(EntAgeMC<$H94,1,0))","v":0},null,{"$f":"A94-2","v":60},{"$f":"A94+3","v":65}]
[67,{"$f":"SUM(IF(EntAgeFS<>\"\",1,0)*IF(EntAgeFS>=$G95,1,0)*IF(EntAgeFS<$H95,1,0))","v":2},{"$f":"SUM(IF(EntAgeMS<>\"\",1,0)*IF(EntAgeMS>=$G95,1,0)*IF(EntAgeMS<$H95,1,0))","v":1},{"$f":"SUM(IF(EntAgeFC<>\"\",1,0)*IF(EntAgeFC>=$G95,1,0)*IF(EntAgeFC<$H95,1,0))","v":1},{"$f":"SUM(IF(EntAgeMC=\"\",1,0)*IF(EntAgeMC>=$G95,1,0)*IF(EntAgeMC<$H95,1,0))","v":0},null,65,70]
[72,{"$f":"SUM(IF(EntAgeFS<>\"\",1,0)*IF(EntAgeFS>=$G96,1,0)*IF(EntAgeFS<$H96,1,0))","v":7},{"$f":"SUM(IF(EntAgeMS<>\"\",1,0)*IF(EntAgeMS>=$G96,1,0)*IF(EntAgeMS<$H96,1,0))","v":0},{"$f":"SUM(IF(EntAgeFC<>\"\",1,0)*IF(EntAgeFC>=$G96,1,0)*IF(EntAgeFC<$H96,1,0))","v":0},{"$f":"SUM(IF(EntAgeMC=\"\",1,0)*IF(EntAgeMC>=$G96,1,0)*IF(EntAgeMC<$H96,1,0))","v":0},null,70,75]
[77,{"$f":"SUM(IF(EntAgeFS<>\"\",1,0)*IF(EntAgeFS>=$G97,1,0)*IF(EntAgeFS<$H97,1,0))","v":8},{"$f":"SUM(IF(EntAgeMS<>\"\",1,0)*IF(EntAgeMS>=$G97,1,0)*IF(EntAgeMS<$H97,1,0))","v":1},{"$f":"SUM(IF(EntAgeFC<>\"\",1,0)*IF(EntAgeFC>=$G97,1,0)*IF(EntAgeFC<$H97,1,0))","v":5},{"$f":"SUM(IF(EntAgeMC=\"\",1,0)*IF(EntAgeMC>=$G97,1,0)*IF(EntAgeMC<$H97,1,0))","v":0},null,75,80]
[82,{"$f":"SUM(IF(EntAgeFS<>\"\",1,0)*IF(EntAgeFS>=$G98,1,0)*IF(EntAgeFS<$H98,1,0))","v":4},{"$f":"SUM(IF(EntAgeMS<>\"\",1,0)*IF(EntAgeMS>=$G98,1,0)*IF(EntAgeMS<$H98,1,0))","v":1},{"$f":"SUM(IF(EntAgeFC<>\"\",1,0)*IF(EntAgeFC>=$G98,1,0)*IF(EntAgeFC<$H98,1,0))","v":1},{"$f":"SUM(IF(EntAgeMC=\"\",1,0)*IF(EntAgeMC>=$G98,1,0)*IF(EntAgeMC<$H98,1,0))","v":0},null,80,85]
[87,{"$f":"SUM(IF(EntAgeFS<>\"\",1,0)*IF(EntAgeFS>=$G99,1,0)*IF(EntAgeFS<$H99,1,0))","v":1},{"$f":"SUM(IF(EntAgeMS<>\"\",1,0)*IF(EntAgeMS>=$G99,1,0)*IF(EntAgeMS<$H99,1,0))","v":2},{"$f":"SUM(IF(EntAgeFC<>\"\",1,0)*IF(EntAgeFC>=$G99,1,0)*IF(EntAgeFC<$H99,1,0))","v":0},{"$f":"SUM(IF(EntAgeMC=\"\",1,0)*IF(EntAgeMC>=$G99,1,0)*IF(EntAgeMC<$H99,1,0))","v":0},null,85,90]
[92,{"$f":"SUM(IF(EntAgeFS<>\"\",1,0)*IF(EntAgeFS>=$G100,1,0)*IF(EntAgeFS<$H100,1,0))","v":1},{"$f":"SUM(IF(EntAgeMS<>\"\",1,0)*IF(EntAgeMS>=$G100,1,0)*IF(EntAgeMS<$H100,1,0))","v":0},{"$f":"SUM(IF(EntAgeFC<>\"\",1,0)*IF(EntAgeFC>=$G100,1,0)*IF(EntAgeFC<$H100,1,0))","v":0},{"$f":"SUM(IF(EntAgeMC=\"\",1,0)*IF(EntAgeMC>=$G100,1,0)*IF(EntAgeMC<$H100,1,0))","v":0},null,{"$f":"A100-2","v":90},{"$f":"A100+3","v":95}]
[97,{"$f":"SUM(IF(EntAgeFS<>\"\",1,0)*IF(EntAgeFS>=$G101,1,0)*IF(EntAgeFS<$H101,1,0))","v":0},{"$f":"SUM(IF(EntAgeMS<>\"\",1,0)*IF(EntAgeMS>=$G101,1,0)*IF(EntAgeMS<$H101,1,0))","v":0},{"$f":"SUM(IF(EntAgeFC<>\"\",1,0)*IF(EntAgeFC>=$G101,1,0)*IF(EntAgeFC<$H101,1,0))","v":0},{"$f":"SUM(IF(EntAgeMC=\"\",1,0)*IF(EntAgeMC>=$G101,1,0)*IF(EntAgeMC<$H101,1,0))","v":0},null,95,199]
["All",{"$f":"SUM(B93:B101)","v":27},{"$f":"SUM(C93:C101)","v":5},{"$f":"SUM(D93:D101)","v":8},{"$f":"SUM(E93:E101)","v":0}]
[]
[]
["Final date ",null,null,{"$f":"DATE(2099,12,31)","v":"2099-12-31"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"IF(D37<DATE(2099,12,31),D37+1500,D37)","v":"1924-05-02"},"1994-02-28","2017-09-26",null,{"$f":"IF(H37<DATE(2099,12,31),H37+1500,H37)","v":"1921-03-06"},"1994-02-28","2007-09-29"]
[null,null,null,{"$f":"IF(D38<DATE(2099,12,31),D38+1500,D38)","v":"1946-02-12"},"2018-06-25","2099-12-31",null,{"$f":"IF(H38<DATE(2099,12,31),H38+1500,H38)","v":"2099-12-31"},"2099-12-31","2099-12-31"]
[null,null,null,{"$f":"IF(D39<DATE(2099,12,31),D39+1500,D39)","v":"1922-08-11"},"1996-02-10","2099-12-31",null,{"$f":"IF(H39<DATE(2099,12,31),H39+1500,H39)","v":"2099-12-31"},"2099-12-31","2099-12-31"]
[null,null,null,{"$f":"IF(D40<DATE(2099,12,31),D40+1500,D40)","v":"2099-12-31"},"2099-12-31","2099-12-31",null,{"$f":"IF(H40<DATE(2099,12,31),H40+1500,H40)","v":"1928-11-24"},"1994-10-23","2011-05-15"]
[null,null,null,{"$f":"IF(D41<DATE(2099,12,31),D41+1500,D41)","v":"1936-06-26"},"2011-09-27","2099-12-31",null,{"$f":"IF(H41<DATE(2099,12,31),H41+1500,H41)","v":"2099-12-31"},"2099-12-31","2099-12-31"]
[null,null,null,{"$f":"IF(D42<DATE(2099,12,31),D42+1500,D42)","v":"1929-09-14"},"1994-04-16","2014-09-22",null,{"$f":"IF(H42<DATE(2099,12,31),H42+1500,H42)","v":"2099-12-31"},"2099-12-31","2099-12-31"]
[null,null,null,{"$f":"IF(D43<DATE(2099,12,31),D43+1500,D43)","v":"1930-05-23"},"2016-05-10","2099-12-31",null,{"$f":"IF(H43<DATE(2099,12,31),H43+1500,H43)","v":"2099-12-31"},"2099-12-31","2099-12-31"]
[null,null,null,{"$f":"IF(D44<DATE(2099,12,31),D44+1500,D44)","v":"1931-06-08"},"1994-04-02","2015-08-15",null,{"$f":"IF(H44<DATE(2099,12,31),H44+1500,H44)","v":"1926-11-09"},"1994-04-02","2016-03-31"]
[null,null,null,{"$f":"IF(D45<DATE(2099,12,31),D45+1500,D45)","v":"2099-12-31"},"2099-12-31","2099-12-31",null,{"$f":"IF(H45<DATE(2099,12,31),H45+1500,H45)","v":"1939-10-25"},"2016-04-19","2099-12-31"]
[null,null,null,{"$f":"IF(D46<DATE(2099,12,31),D46+1500,D46)","v":"1924-11-22T09:00:00"},"1995-04-18","1997-05-24",null,{"$f":"IF(H46<DATE(2099,12,31),H46+1500,H46)","v":"2099-12-31"},"2099-12-31","2099-12-31"]
[null,null,null,{"$f":"IF(D47<DATE(2099,12,31),D47+1500,D47)","v":"1919-04-08"},"1997-05-24","2008-09-05",null,{"$f":"IF(H47<DATE(2099,12,31),H47+1500,H47)","v":"2099-12-31"},"2099-12-31","2099-12-31"]
[null,null,null,{"$f":"IF(D48<DATE(2099,12,31),D48+1500,D48)","v":"1938-01-03"},"2008-11-23","2016-03-08",null,{"$f":"IF(H48<DATE(2099,12,31),H48+1500,H48)","v":"2099-12-31"},"2099-12-31","2099-12-31"]
[null,null,null,{"$f":"IF(D49<DATE(2099,12,31),D49+1500,D49)","v":"1936-03-11"},"2018-08-07","2099-12-31",null,{"$f":"IF(H49<DATE(2099,12,31),H49+1500,H49)","v":"2099-12-31"},"2099-12-31","2099-12-31"]
[null,null,null,{"$f":"IF(D50<DATE(2099,12,31),D50+1500,D50)","v":"1934-02-21T21:00:00"},"1993-11-29","1996-08-23",null,{"$f":"IF(H50<DATE(2099,12,31),H50+1500,H50)","v":"2099-12-31"},"2099-12-31","2099-12-31"]
[null,null,null,{"$f":"IF(D51<DATE(2099,12,31),D51+1500,D51)","v":"1922-01-16"},"1996-08-27","2014-10-05",null,{"$f":"IF(H51<DATE(2099,12,31),H51+1500,H51)","v":"2099-12-31"},"2099-12-31","2099-12-31"]
[null,null,null,{"$f":"IF(D52<DATE(2099,12,31),D52+1500,D52)","v":"1948-11-02"},"2018-03-24","2099-12-31",null,{"$f":"IF(H52<DATE(2099,12,31),H52+1500,H52)","v":"2099-12-31"},"2099-12-31","2099-12-31"]
[null,null,null,{"$f":"IF(D53<DATE(2099,12,31),D53+1500,D53)","v":"1918-05-17"},{"$f":"IF(E53<DATE(2099,12,31),E53+1500,E53)","v":"1994-04-16"},"2011-01-17",null,{"$f":"IF(H53<DATE(2099,12,31),H53+1500,H53)","v":"2099-12-31"},"2099-12-31","2099-12-31"]
[null,null,null,{"$f":"IF(D54<DATE(2099,12,31),D54+1500,D54)","v":"1935-10-12"},"2012-04-24","2016-04-18",null,{"$f":"IF(H54<DATE(2099,12,31),H54+1500,H54)","v":"2099-12-31"},"2099-12-31","2099-12-31"]
[null,null,null,{"$f":"IF(D55<DATE(2099,12,31),D55+1500,D55)","v":"1938-09-01"},"2018-02-11","2099-12-31",null,{"$f":"IF(H55<DATE(2099,12,31),H55+1500,H55)","v":"1940-10-02"},"2018-02-11","2099-12-31"]
[null,null,null,{"$f":"IF(D56<DATE(2099,12,31),D56+1500,D56)","v":"1919-11-28"},"1995-01-31","2007-08-31",null,{"$f":"IF(H56<DATE(2099,12,31),H56+1500,H56)","v":"1917-04-06"},"1995-01-31","2010-02-21"]
[null,null,null,{"$f":"IF(D57<DATE(2099,12,31),D57+1500,D57)","v":"1931-04-09"},"2009-12-22","2013-11-13",null,{"$f":"IF(H57<DATE(2099,12,31),H57+1500,H57)","v":"1926-04-01"},"2010-02-21","2014-05-16"]
[null,null,null,{"$f":"IF(D58<DATE(2099,12,31),D58+1500,D58)","v":"2099-12-31"},"2099-12-31","2099-12-31",null,{"$f":"IF(H58<DATE(2099,12,31),H58+1500,H58)","v":"1933-11-23"},"2015-09-27","2099-12-31"]
[null,null,null,{"$f":"IF(D59<DATE(2099,12,31),D59+1500,D59)","v":"1917-06-11T21:00:00"},"1994-03-08","1995-12-12",null,{"$f":"IF(H59<DATE(2099,12,31),H59+1500,H59)","v":"1919-06-12T09:00:00"},"1994-03-08","1995-12-12"]
[null,null,null,{"$f":"IF(D60<DATE(2099,12,31),D60+1500,D60)","v":"1934-12-18T15:00:00"},"1995-12-25","1998-06-19",null,{"$f":"IF(H60<DATE(2099,12,31),H60+1500,H60)","v":"2099-12-31"},"2099-12-31","2099-12-31"]
[null,null,null,{"$f":"IF(D61<DATE(2099,12,31),D61+1500,D61)","v":"1915-07-20"},"1999-09-07","2006-11-20",null,{"$f":"IF(H61<DATE(2099,12,31),H61+1500,H61)","v":"2099-12-31"},"2099-12-31","2099-12-31"]
[null,null,null,{"$f":"IF(D62<DATE(2099,12,31),D62+1500,D62)","v":"1924-08-16"},"2007-08-26","2010-03-24",null,{"$f":"IF(H62<DATE(2099,12,31),H62+1500,H62)","v":"1922-06-03"},"2007-08-26","2009-02-21"]
[null,null,null,{"$f":"IF(D63<DATE(2099,12,31),D63+1500,D63)","v":"1931-06-10"},"2010-12-04","2099-12-31",null,{"$f":"IF(H63<DATE(2099,12,31),H63+1500,H63)","v":"2099-12-31"},"2099-12-31","2099-12-31"]
[null,null,null,{"$f":"IF(D64<DATE(2099,12,31),D64+1500,D64)","v":"1934-01-09T21:00:00"},"1995-10-07","2004-03-01",null,{"$f":"IF(H64<DATE(2099,12,31),H64+1500,H64)","v":"2099-12-31"},"2099-12-31","2099-12-31"]
[null,null,null,{"$f":"IF(D65<DATE(2099,12,31),D65+1500,D65)","v":"1930-12-08"},"2004-10-17","2099-12-31",null,{"$f":"IF(H65<DATE(2099,12,31),H65+1500,H65)","v":"2099-12-31"},"2099-12-31","2099-12-31"]
[null,null,null,{"$f":"IF(D66<DATE(2099,12,31),D66+1500,D66)","v":"1915-04-15T21:00:00"},"1994-06-07","2001-05-16",null,{"$f":"IF(H66<DATE(2099,12,31),H66+1500,H66)","v":"2099-12-31"},"2099-12-31","2099-12-31"]
[null,null,null,{"$f":"IF(D67<DATE(2099,12,31),D67+1500,D67)","v":"1921-04-03T21:00:00"},"2001-10-15","2003-02-17",null,{"$f":"IF(H67<DATE(2099,12,31),H67+1500,H67)","v":"2099-12-31"},"2099-12-31","2099-12-31"]
[null,null,null,{"$f":"IF(D68<DATE(2099,12,31),D68+1500,D68)","v":"1928-02-27"},"2003-10-04","2099-12-31",null,{"$f":"IF(H68<DATE(2099,12,31),H68+1500,H68)","v":"2099-12-31"},"2099-12-31","2099-12-31"]
[null,null,null,{"$f":"IF(D69<DATE(2099,12,31),D69+1500,D69)","v":"1920-05-18T03:00:00"},"1994-05-31","2002-11-17",null,{"$f":"IF(H69<DATE(2099,12,31),H69+1500,H69)","v":"2099-12-31"},"2099-12-31","2099-12-31"]
[null,null,null,{"$f":"IF(D70<DATE(2099,12,31),D70+1500,D70)","v":"1924-04-02T09:00:00"},"2003-07-18","2004-10-02",null,{"$f":"IF(H70<DATE(2099,12,31),H70+1500,H70)","v":"2099-12-31"},"2099-12-31","2099-12-31"]
[null,null,null,{"$f":"IF(D71<DATE(2099,12,31),D71+1500,D71)","v":"1914-03-14"},"2005-01-11","2010-07-26",null,{"$f":"IF(H71<DATE(2099,12,31),H71+1500,H71)","v":"2099-12-31"},"2099-12-31","2099-12-31"]
[null,null,null,{"$f":"IF(D72<DATE(2099,12,31),D72+1500,D72)","v":"2099-12-31"},"2099-12-31","2099-12-31",null,{"$f":"IF(H72<DATE(2099,12,31),H72+1500,H72)","v":"1922-01-29"},"2011-03-11","2012-12-25"]
[null,null,null,{"$f":"IF(D73<DATE(2099,12,31),D73+1500,D73)","v":"2099-12-31"},"2099-12-31","2099-12-31",null,{"$f":"IF(H73<DATE(2099,12,31),H73+1500,H73)","v":"1928-04-28"},"2015-09-28","2099-12-31"]
[null,null,null,{"$f":"IF(D74<DATE(2099,12,31),D74+1500,D74)","v":"1913-01-01T03:00:00"},"1996-08-06","1998-07-03",null,{"$f":"IF(H74<DATE(2099,12,31),H74+1500,H74)","v":"2099-12-31"},"2099-12-31","2099-12-31"]
[null,null,null,{"$f":"IF(D75<DATE(2099,12,31),D75+1500,D75)","v":"1924-05-06T09:00:00"},"1999-09-13","2000-11-05",null,{"$f":"IF(H75<DATE(2099,12,31),H75+1500,H75)","v":"1927-05-07T03:00:00"},"1999-09-13","2000-11-05"]
[null,null,null,{"$f":"IF(D76<DATE(2099,12,31),D76+1500,D76)","v":"1936-07-19"},"2001-08-04","2099-12-31",null,{"$f":"IF(H76<DATE(2099,12,31),H76+1500,H76)","v":"2099-12-31"},"2099-12-31","2099-12-31"]
[null,null,null,{"$f":"IF(D77<DATE(2099,12,31),D77+1500,D77)","v":"1913-01-01T03:00:00"},"1993-11-29","1904-02-08",null,{"$f":"IF(H77<DATE(2099,12,31),H77+1500,H77)","v":"1917-04-06"},"1994-02-28","1904-02-08"]
[null,null,null,{"$f":"IF(D78<DATE(2099,12,31),D78+1500,D78)","v":"2099-12-31"},"2099-12-31","1904-02-08",null,{"$f":"IF(H78<DATE(2099,12,31),H78+1500,H78)","v":"2099-12-31"},"2099-12-31","1904-02-08"]
[null,null,null,{"$f":"IF(D79<DATE(2099,12,31),D79+1500,D79)","v":"1949-11-19T06:13:30"},"2015-05-12T21:00:00","1904-02-08",null,{"$f":"IF(H79<DATE(2099,12,31),H79+1500,H79)","v":"2046-08-19T17:42:00"},"2071-12-12T11:24:00","1904-02-08"]
[null,null,null,{"$f":"IF(D80<DATE(2099,12,31),D80+1500,D80)","v":"1904-02-08"},"1904-02-08","1904-02-08",null,{"$f":"IF(H80<DATE(2099,12,31),H80+1500,H80)","v":"1904-02-08"},"1904-02-08","1904-02-08"]
[null,null,null,{"$f":"IF(D81<DATE(2099,12,31),D81+1500,D81)","v":"1935-02-15T08:43:38.182"},"2010-10-15T21:49:05.455","1904-02-08",null,{"$f":"IF(H81<DATE(2099,12,31),H81+1500,H81)","v":"1935-09-12"},"2016-06-21T12:00:00","1904-02-08"]
[null,null,null,{"$f":"IF(D82<DATE(2099,12,31),D82+1500,D82)","v":"1948-11-02"},"2018-08-07","2017-09-26",null,{"$f":"IF(H82<DATE(2099,12,31),H82+1500,H82)","v":"1940-10-02"},"2018-02-11","2016-03-31"]
[null,null,null,{"$f":"IF(D83<DATE(2099,12,31),D83+1500,D83)","v":"1913-01-01T03:00:00"},"1993-11-29","1995-12-12",null,{"$f":"IF(H83<DATE(2099,12,31),H83+1500,H83)","v":"1917-04-06"},"1994-02-28","1995-12-12"]
[null,null,null,{"$f":"IF(D84<DATE(2099,12,31),D84+1500,D84)","v":"1904-02-08"},"1904-02-08","1904-02-08",null,{"$f":"IF(H84<DATE(2099,12,31),H84+1500,H84)","v":"1904-02-08"},"1904-02-08","1904-02-08"]
[null,null,null,{"$f":"IF(D85<DATE(2099,12,31),D85+1500,D85)","v":"1904-03-31"},"1904-03-28","1904-03-16",null,{"$f":"IF(H85<DATE(2099,12,31),H85+1500,H85)","v":"1904-04-03"},"1904-04-03","1904-03-23"]
[null,null,null,{"$f":"IF(D86<DATE(2099,12,31),D86+1500,D86)","v":"1904-04-22"},"1904-03-29","1904-04-07",null,{"$f":"IF(H86<DATE(2099,12,31),H86+1500,H86)","v":"1904-04-04"},"1904-03-16","1904-04-07"]
[null,null,null,{"$f":"IF(D87<DATE(2099,12,31),D87+1500,D87)","v":"1904-02-08"},"1904-02-08","1904-02-08",null,{"$f":"IF(H87<DATE(2099,12,31),H87+1500,H87)","v":"1904-02-08"},"1904-02-08","1904-02-08"]
[null,null,null,{"$f":"IF(D88<DATE(2099,12,31),D88+1500,D88)","v":"1904-02-08"},"1904-02-08","1904-02-08",null,{"$f":"IF(H88<DATE(2099,12,31),H88+1500,H88)","v":"1904-02-08"},"1904-02-08","1904-02-08"]
[null,null,null,{"$f":"IF(D89<DATE(2099,12,31),D89+1500,D89)","v":"1904-02-08"},"1904-02-08","1904-02-08",null,{"$f":"IF(H89<DATE(2099,12,31),H89+1500,H89)","v":"1904-02-08"},"1904-02-08","1904-02-08"]
[null,null,null,{"$f":"IF(D90<DATE(2099,12,31),D90+1500,D90)","v":"1904-02-08"},"1904-02-08","1904-02-08",null,{"$f":"IF(H90<DATE(2099,12,31),H90+1500,H90)","v":"1904-02-08"},"1904-02-08","1904-02-08"]
[null,null,null,{"$f":"IF(D91<DATE(2099,12,31),D91+1500,D91)","v":"1904-02-08"},"1904-02-08","1904-02-08",null,{"$f":"IF(H91<DATE(2099,12,31),H91+1500,H91)","v":"1904-02-08"},"1904-02-08","1904-02-08"]
[null,null,null,{"$f":"IF(D92<DATE(2099,12,31),D92+1500,D92)","v":"Coupled female entry"},"Coupled male entry","1904-02-08",null,{"$f":"IF(H92<DATE(2099,12,31),H92+1500,H92)","v":"1904-02-08"},"1904-02-08","1904-02-08"]
[null,null,null,{"$f":"IF(D93<DATE(2099,12,31),D93+1500,D93)","v":"1904-02-08"},"1904-02-08","1904-02-08",null,{"$f":"IF(H93<DATE(2099,12,31),H93+1500,H93)","v":"1904-04-08"},"1904-02-08","1904-02-08"]
[null,null,null,{"$f":"IF(D94<DATE(2099,12,31),D94+1500,D94)","v":"1904-02-09"},"1904-02-08","1904-02-08",null,{"$f":"IF(H94<DATE(2099,12,31),H94+1500,H94)","v":"1904-04-13"},"1904-02-08","1904-02-08"]
[null,null,null,{"$f":"IF(D95<DATE(2099,12,31),D95+1500,D95)","v":"1904-02-09"},"1904-02-08","1904-02-08",null,{"$f":"IF(H95<DATE(2099,12,31),H95+1500,H95)","v":"1904-04-18"},"1904-02-08","1904-02-08"]
[null,null,null,{"$f":"IF(D96<DATE(2099,12,31),D96+1500,D96)","v":"1904-02-08"},"1904-02-08","1904-02-08",null,{"$f":"IF(H96<DATE(2099,12,31),H96+1500,H96)","v":"1904-04-23"},"1904-02-08","1904-02-08"]
[null,null,null,{"$f":"IF(D97<DATE(2099,12,31),D97+1500,D97)","v":"1904-02-13"},"1904-02-08","1904-02-08",null,{"$f":"IF(H97<DATE(2099,12,31),H97+1500,H97)","v":"1904-04-28"},"1904-02-08","1904-02-08"]

{"sheet":"Sheet2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}