{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["Sales 2022_23 bulk template"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Sales 2022_23 bulk template","index":0,"n_rows":5,"n_cols":126,"rows_kept":5,"cut":false,"hidden":false,"merged":[[3,113,3,125],[3,1,3,4],[2,87,2,91],[2,50,2,56],[2,66,2,67],[2,44,2,47],[3,5,3,111],[2,1,2,4],[1,72,1,73],[1,74,1,75],[1,77,1,78],[1,87,1,88],[2,68,2,72],[2,74,2,75],[2,80,2,83],[1,8,1,12],[1,13,1,18],[2,41,2,42],[2,48,2,49],[2,57,2,65],[1,19,1,23],[1,24,1,29],[1,32,1,33],[1,43,1,47],[2,30,2,32],[2,36,2,37]]}
["Question","What is the purchaser code?","What is the day of the sale completion date? - DD","What is the month of the sale completion date? - MM","What is the year of the sale completion date? - YY","[BLANK]","Was the buyer interviewed for any of the answers you will provide on this log?","Age of Buyer 1","Age of Buyer 2 or Person 2","Age of Person 3","Age of Person 4","Age of Person 5","Age of Person 6","Gender identity of Buyer 1","Gender identity of Buyer 2 or Person 2","Gender identity of Person 3","Gender identity of Person 4","Gender identity of Person 5","Gender identity of Person 6","Person 2's relationship to lead tenant","Person 3's relationship to lead tenant","Person 4's relationship to lead tenant","Person 5's relationship to lead tenant","Person 6's relationship to lead tenant","Working situation of Buyer 1","Working situation of Buyer 2 or Person 2","Working situation of Person 3","Working situation of Person 4","Working situation of Person 5","Working situation of Person 6","What is the buyer 1's ethnic group?","What is buyer 1's nationality?","What is buyer 1's gross annual income?","What is buyer 2's gross annual income?","Was buyer 1's income used for a mortgage application?","Was buyer 2's income used for a mortgage application?","What is the total amount the buyers had in savings before they paid any deposit for the property?\n\nTo the nearest £10","Have any of the buyers previously owned a property?","[BLANK]","What was buyer 1's previous tenure?","What is the local authority of buyer 1's last settled home","Part 1 of postcode of buyer 1's last settled home","Part 2 of postcode of buyer 1's last settled home","Do you know the postcode of buyer 1's last settled home?","Was the buyer registered with their PRP (HA)?","Was the buyer registered with the local authority?","Was the buyer registered with a Help to Buy agent?","Was the buyer registered with another PRP (HA)?","Does anyone in the household consider themselves to have a disability?","Does anyone in the household use a wheelchair?","How many bedrooms does the property have?","What type of unit is the property?","Which type of building is the property?","What is the local authority of the property?","Part 1 of postcode of property","Part 2 of postcode of property","Is the property built or adapted to wheelchair-user standards?","What is the type of shared ownership sale?","Is this a resale?\n\nShared ownership","What is the day of the practical completion or handover date? - DD\n\nShared ownership","What is the month of the practical completion or handover date? - MM\n\nShared ownership","What is the year of the practical completion or handover date? - YY\n\nShared ownership","What is the day of the exchange of contracts date? - DD\n\nShared ownership","What is the month of the exchange of contracts date? - MM\n\nShared ownership","What is the year of the exchange of contracts date? - YY\n\nShared ownership","Was the household re-housed under a local authority nominations agreement?\n\nShared ownership","How many bedrooms did the buyer's previous property have?\n\nShared ownership","What was the type of the buyer's previous property?\n\nShared ownership","What was the full purchase price?\n\nShared ownership","What was the initial percentage equity stake purchased?\n\nShared ownership","What is the mortgage amount?\n\nShared ownership","Does this include any extra borrowing?\n\nShared ownership","How much was the cash deposit paid on the property?\n\nShared ownership","How much cash discount was given through Social Homebuy?\n\nShared ownership","What is the basic monthly rent?\n\nShared ownership","What are the total monthly leasehold charges for the property?\n\nShared ownership","What is the type of discounted ownership sale?","What was the full purchase price?\n\nDiscounted ownership","What was the amount of any loan, grant, discount or subsidy given?\n\nDiscounted ownership","What was the percentage discount?\n\nDiscounted ownership","What is the mortgage amount?\n\nDiscounted ownership","Does this include any extra borrowing?\n\nDiscounted ownership","How much was the cash deposit paid on the property?\n\nDiscounted ownership","What are the total monthly leasehold charges for the property?\n\nDiscounted ownership","What is the type of outright sale?","What is the 'other' type of outright sale?\n\nOutright sale","[BLANK]","What is the full purchase price?\n\nOutright sale","What is the mortgage amount?\n\nOutright sale","Does this include any extra borrowing?\n\nOutright sale","How much was the cash deposit paid on the property?\n\nOutright sale","What are the total monthly leasehold charges for the property?\n\nOutright sale","Which organisation owned this property before the sale?\n\nOrganisation's CORE ID","Username","BLANK","Has the buyer ever served in the UK Armed Forces and for how long?","[BLANK]","Are any of the buyers a spouse or civil partner of a UK Armed Forces regular who died in service within the last 2 years?","What is the name of the mortgage lender?\n\nShared ownership","What is the name of the 'other' mortgage lender?\n\nShared ownership","What is the name of the mortgage lender?\n\nDiscounted ownership","What is the name of the 'other' mortgage lender?\n\nDiscounted ownership","What is the name of the mortgage lender?\n\nOutright sale","What is the name of the 'other' mortgage lender?\n\nOutright sale","Were the buyers receiving any of these housing-related benefits immediately before buying this property?","What is the length of the mortgage in years?\n\nShared ownership","What is the length of the mortgage in years?\n\nDiscounted ownership","What is the length of the mortgage in years?\n\nOutright sale","How long have the buyers been living in the property before the purchase?\n\nDiscounted ownership","Are there more than two joint purchasers of this property?","How long have the buyers been living in the property before the purchase?\n\nShared ownership","Is this a staircasing transaction?","Data Protection question","Was this purchase made through an ownership scheme?","Is the buyer a company?\n\nOutright sale","Will the buyers live in the property?","Is this a joint purchase?","Will buyer 1 live in the property?","Will buyer 2 live in the property?","Besides the buyers, how many people live in the property?","What percentage of the property has been bought in this staircasing transaction?\n\nShared ownership","What percentage of the property does the buyer now own in total?\n\nShared ownership","What was the rent type of the buyer's previous property?\n\nShared ownership","Was a mortgage used for the purchase of this property?\n\nShared ownership","Was a mortgage used for the purchase of this property?\n\nDiscounted ownership","Was a mortgage used for the purchase of this property?\n\nOutright sale"]
["Values","Max 9 digits","1 - 31","1 - 12","19 - 23",null,"1 or null","15 - 110\nor R","1 - 110 or R",{"$nulls":4},"M, F, X or R",{"$nulls":5},"P, C, X or R",{"$nulls":4},"0 - 10",{"$nulls":5},"1 - 19","12 -13, 17 -19","0 - 99999",null,"1 or 2","1 or 2","0 - 999990","1 - 3",null,"1 - 7 or 9","ONS CODE - E + 9 digits","XXX(X)","XXX","1 or null",{"$nulls":4},"1 - 3","1 - 3","1 - 9","1 - 4 or 9","1 or 2","ONS CODE E + 9 digits","XXX(X)","XXX","1 - 3","2, 16, 18, 24, 28 or 30-31","1 or 2","1 - 31","1 - 12","19 - 23","1 - 31","1 - 12","19 - 23","1 - 3","1 - 9","1 - 4 or 9","0 - 999999","0 - 100","0 - 999999","1 - 3","0 - 999999",null,"0 - 999.99",null,"8, 9, 14, 21, 22, 27 or 29","0 - 999999",null,"0 - 100","0 - 999999","1 - 3","0 - 999999","0 - 999.99","10 or 12",null,null,"0 - 999999",null,"1-3","0 - 999999","0-999.99","Up to 7 digits","Username of CORE account this sales log should be assigned to",null,"3 - 8",null,"4 - 7","1 - 40",null,"1 - 40",null,"1 - 40",null,"1 - 4"," Integer <=60"," Integer <=60"," Integer <=60"," Integer <=80","1 - 3"," Integer <=80","1 - 3",1,"1 - 3","1 - 2","1 - 2","1 - 2","1 - 2","1 - 2","0 - 5","1 - 100","1 - 100","1-3 or 9-10","1 - 2","1 - 2","1 - 2"]
["Can be Null?","No",{"$nulls":4},"No","No","If fields 14, 19 and 25 are all also null","If fields 15, 20 and 26 are all also null","If fields 16, 21 and 27 are all also null","If fields 17, 22 and 28 are all also null","If fields 18, 23 and 29 are all also null","No","If fields 8, 19 and 25 are all also null","If fields 9, 20 and 26 are also null","If fields 10, 21 and 27 are all also null","If fields 11, 22 and 28 are all also null","If fields 12, 23 and 29 are all also null","If fields 8, 14 and 25 are all also null","If fields 9, 15 and 26 are all also null","If fields 10, 16 and 27 are all also null","If fields 11, 17 and 28 are all also null","If fields 12, 18 and 29 are all also null","If field 6 = 1","If fields 8, 14 and 19 are all also null","If fields 9, 15 and 20 are all also null","If fields 10, 16 and 21 are all also null","If fields 11, 17 and 22 are all also null","If fields 12, 18 and 23 are all also null","If field 6 =  1",null,null,"If field 116 = 2","If field 32  is null","If field 116 = 2","If field 6 = 1",null,null,"If field 6 = 1","No","If field 43 = 1",null,"If fields 41 and 42 BOTH have valid entries","Yes",null,null,null,"If field 6 = 1",null,"No",{"$nulls":6},"If field 113 = 2 or 3",{"$nulls":8},"If field 113 = 2 or 3\nOR\nfield 39 = 3 - 7 or 9",null,"If field 113 = 2 or 3",{"$nulls":4},"If field 57 is null, 2, 16, 24 or 28","If field 113 = 2 or 3",null,"If field 113 = 1 or 3","If field 76 is null","If field 76 is null, 9 or 14","If field 76 is null, 8, 21 or 22","If field 113 = 1 or 3",null,null,null,"If field 113 = 1 or 2","If field 84 is null or 10",null,"If field 113 = 1 or 2",{"$nulls":4},"No","Yes",null,"No",null,"No","If field 113 = 2 or 3","If field 113 = 2 or 3\nOR\nIf field 98 is not 40","If field 113 = 1 or 3","If field 113 = 1 or 3\nOR\nIf field 100 is not 40","If field 113 = 1 or 2","If field 113 = 1 or 2\nOR\nIf field 102 is not 40","No","If field 113 = 2 or 3","If field 113 = 1 or 3","If field 113 = 1 or 2","If field 113 = 1 or 3","If field 116 = 2","If field 113 = 2 or 3","If field 113 = 2 or 3","No","No","If field 113 = 1 or 2","If field 113 = 1 or 2","No","No","If field 116 = 2","No","If field 113 = 2 or 3","If field 113 = 2 or 3","If field 113 = 1 or 2\nOR\nIf field 39 = 3 - 9","If field 113 = 2 or 3","If field 113 = 1 or 3","If field 113 = 1 or 2"]
["Bulk upload format and duplicate check","Yes"]
["Field number",1,{"$f":"B5+1","v":2},{"$f":"C5+1","v":3},{"$f":"D5+1","v":4},{"$f":"E5+1","v":5},{"$f":"F5+1","v":6},{"$f":"G5+1","v":7},{"$f":"H5+1","v":8},{"$f":"I5+1","v":9},{"$f":"J5+1","v":10},{"$f":"K5+1","v":11},{"$f":"L5+1","v":12},{"$f":"M5+1","v":13},{"$f":"N5+1","v":14},{"$f":"O5+1","v":15},{"$f":"P5+1","v":16},{"$f":"Q5+1","v":17},{"$f":"R5+1","v":18},{"$f":"S5+1","v":19},{"$f":"T5+1","v":20},{"$f":"U5+1","v":21},{"$f":"V5+1","v":22},{"$f":"W5+1","v":23},{"$f":"X5+1","v":24},{"$f":"Y5+1","v":25},{"$f":"Z5+1","v":26},{"$f":"AA5+1","v":27},{"$f":"AB5+1","v":28},{"$f":"AC5+1","v":29},{"$f":"AD5+1","v":30},{"$f":"AE5+1","v":31},{"$f":"AF5+1","v":32},{"$f":"AG5+1","v":33},{"$f":"AH5+1","v":34},{"$f":"AI5+1","v":35},{"$f":"AJ5+1","v":36},{"$f":"AK5+1","v":37},{"$f":"AL5+1","v":38},{"$f":"AM5+1","v":39},{"$f":"AN5+1","v":40},{"$f":"AO5+1","v":41},{"$f":"AP5+1","v":42},{"$f":"AQ5+1","v":43},{"$f":"AR5+1","v":44},{"$f":"AS5+1","v":45},{"$f":"AT5+1","v":46},{"$f":"AU5+1","v":47},{"$f":"AV5+1","v":48},{"$f":"AW5+1","v":49},{"$f":"AX5+1","v":50},{"$f":"AY5+1","v":51},{"$f":"AZ5+1","v":52},{"$f":"BA5+1","v":53},{"$f":"BB5+1","v":54},{"$f":"BC5+1","v":55},{"$f":"BD5+1","v":56},{"$f":"BE5+1","v":57},{"$f":"BF5+1","v":58},{"$f":"BG5+1","v":59},{"$f":"BH5+1","v":60},{"$f":"BI5+1","v":61},{"$f":"BJ5+1","v":62},{"$f":"BK5+1","v":63},{"$f":"BL5+1","v":64},{"$f":"BM5+1","v":65},{"$f":"BN5+1","v":66},{"$f":"BO5+1","v":67},{"$f":"BP5+1","v":68},{"$f":"BQ5+1","v":69},{"$f":"BR5+1","v":70},{"$f":"BS5+1","v":71},{"$f":"BT5+1","v":72},{"$f":"BU5+1","v":73},{"$f":"BV5+1","v":74},{"$f":"BW5+1","v":75},{"$f":"BX5+1","v":76},{"$f":"BY5+1","v":77},{"$f":"BZ5+1","v":78},{"$f":"CA5+1","v":79},{"$f":"CB5+1","v":80},{"$f":"CC5+1","v":81},{"$f":"CD5+1","v":82},{"$f":"CE5+1","v":83},{"$f":"CF5+1","v":84},{"$f":"CG5+1","v":85},{"$f":"CH5+1","v":86},{"$f":"CI5+1","v":87},{"$f":"CJ5+1","v":88},{"$f":"CK5+1","v":89},{"$f":"CL5+1","v":90},{"$f":"CM5+1","v":91},{"$f":"CN5+1","v":92},{"$f":"CO5+1","v":93},{"$f":"CP5+1","v":94},{"$f":"CQ5+1","v":95},{"$f":"CR5+1","v":96},{"$f":"CS5+1","v":97},{"$f":"CT5+1","v":98},{"$f":"CU5+1","v":99},{"$f":"CV5+1","v":100},{"$f":"CW5+1","v":101},{"$f":"CX5+1","v":102},{"$f":"CY5+1","v":103},{"$f":"CZ5+1","v":104},{"$f":"DA5+1","v":105},{"$f":"DB5+1","v":106},{"$f":"DC5+1","v":107},{"$f":"DD5+1","v":108},{"$f":"DE5+1","v":109},{"$f":"DF5+1","v":110},{"$f":"DG5+1","v":111},112,{"$f":"DI5+1","v":113},{"$f":"DJ5+1","v":114},{"$f":"DK5+1","v":115},{"$f":"DL5+1","v":116},{"$f":"DM5+1","v":117},{"$f":"DN5+1","v":118},{"$f":"DO5+1","v":119},{"$f":"DP5+1","v":120},{"$f":"DQ5+1","v":121},{"$f":"DR5+1","v":122},{"$f":"DS5+1","v":123},{"$f":"DT5+1","v":124},{"$f":"DU5+1","v":125}]